Hey folks,
tl;dr - Making a spreadsheet, new at it, curious if anyone wants to help/collaborate: Link to spreadsheet below.
I’ve been working on smashing together/creating a spreadsheet whose eventual purpose is to optimize builds for maximum damage, DPS or burst, based on an optimal distribution of combat stats - currently only STR/DEX. However, I’ve never used/learned excel before and this is in its VERY early stages of development and is 100% useless to anyone besides myself.
With that in mind… if you’re in anyway interested in helping this process along shoot me a message and let’s get cracking. Otherwise, have fun checking out the spreadsheet in it’s currently broken state, and let me know if you see any glaringly incorrect errors in the math/game theory.
I also recently learned that some of the formulas that I’ve taken to be written in stone y’all are still deconstructing. Worst case, crit for example, is calculated completely incorrectly. However, at the very least I’m looking to create a working skeleton that can be fleshed out with the correct information once it’s available. Again, to reiterate, I’ve never done this sort of thing before and I more than welcome any and all advice/criticisms. So please feel free to tear it/myself apart. ^^
Cheers!
PS: Thanks to @EternalRift, @ryusacerdos, and whoever the original creator of the second sheet I smashed together is. Deconstructing their sheets and using them as a skeleton is what has allowed me to even begin understanding what a spreadsheet is/does.