The reason I'm posting this here has absolutely nothing to do with StarCraft II but it still relates as it is an error in math I've seem to run in to, and Sc2 mapmaking has alot to do with variables and math :)
I'm trying to create a spreadsheet as to calculate DPS.
One formula I created myself with a bit of brainstorming,
One I got off a website,
And the third I got off a website as well.
All three lead to the same answer.
However the answer is not correct.
Could it be the right side of all our brains are just duds? Doubtful.
So here I am.
And here's my calculations.
I'll attach 3 spreadsheets, one with my calculation and one with my modified one that contains the one off the website.
The other just got heavily screwed up along the way.. I really don't know how I failed so hard >_>
Though my calculation is done the longer and harder way it still gets the job done in the same fashion.
Now as you can tell when I apply source stats the separation factor (what the spreadsheet tells me is my dps and what diablo does) multiplies by extreme factors.
Attached is a ZIP folder containing everything you'll need.
I need help with this! What am I doing wrong?