Dynamic Hit Damage Spreadsheet

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.

Video Tutorial: https://www.youtube.com/watch?v=6CMkNFlZjvQ

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.

8 Likes

This is why you are Bae.

1 Like

Well, what does bae mean.

Before anyone else - it is a slang term of endearment.

Well, although it feels strange, I accept it.

I will not be offended.

2 Likes

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 :stuck_out_tongue:

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.

Nice! It looks great!

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.

Feedback:

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.

1 Like

Will check this out and some other issues/features missing. Thanks

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.