Hello, I recently made a general use dynamic hit damage calc sheet. I think most things are fixed and working correctly, after getting some people to check it out. Just comment or DM on discord (Zeckar#6616), if you find any issues or have questions.
LE Damage Sheet Template File → Make a Copy to have and editable version Included 10 skill templates, which should all calc properly. You can fill in stats particular to type (spell, melee, throwing) for both yourself and minions, global stats that will fill across the types, and also each skill template has sections to fill in stats specific to the skill. If you need more rows, add a row above the last row (not the total rows) to update formulas dynamically.
To be fair, I asked people with working and trustworthy sheets personal sheets. I did not ask spreadsheet experts because I was learning a lot while using Google Sheets and I don’t wanna get roasted
I actually have tolerance for … novices, it’s people who should know better that I’ll give grief, so you’ve kinda missed the boat on that free pass I’m afraid.
Out of curiosity, do you know javascript / any c type programming language? I’m curious as to why you chose to write all of the functions using formulas rather than Google Apps Script.
Apps Script is limited and requires a lot more redundancy. A script written in one cell can only ever return data, it can’t write data to other cells, so that was a limitation, then it also had a syntax learning curve that I decided wasn’t really worth after finding the other stuff out. The default named functions feature ended up be way easier and faster to implement.
I do know some javascript and C#, I’ll be focusing efforts to developed applications for any future tools, if I decide to make any.
The Skill Void Cleave scales with two main Stats: Strength and Vitality.
If I give my character 44 Str and 34 Vitality, and configure the second stat scaling to be vitality and 4 per point, the total Stats still “only” display 1.76, which is incorrect. The Damage is also not updated.