Quote from efiloN
Thanks! It makes my life easier by a lot.
You don't seem to calculate shields and block, could you add that if I ask politely?
I could add block % and block value to compare average block amount, but combining it with effective health would require an input field for "Average melee swing" or something along those lines... Yes, I'll definitely add the first half but i'm unsure if the second half will be worth the hassle.
thanks! finally a spreadsheet for barbs :D.
But something feels off:
It seems to me, that I have to put the same information into C and F.
Could you please tell me what the difference between these 2 rows is?
Also "All Resist" seems to be missing.
Column C you input all of your stats, column F you only input the stats that you want to compare. For example if you want to compare an amulet you would put your current amulet stats in column F and your new amulet stats in column G so that the spreadsheet can subtract out the gear you have on and simulate your total stats with the new item equipped.
I'll add all resist shortly.
Quote from Willemh
could you please add the 'reduces damage from elites' stat? I believe its quite a common (stormshield) stat that many barbarians use, and elites are the only monsters that pretty much matter anyway so I would love if the spreadsheet could show me how much -5% from elites actually does to my survivability.
Also, what lvl are the monsters again in act 1-4? 60, 61, 62, 63?
Sure no problem.
Act 1 - Level 61
Act 2 - Level 62
Act 3 - Level 63
Act 4 - Level 63
are others allowed to extend your work and post it here for you to merge?
Is attack speed on weapons any different from normal attack speed? If no, then please merge the 3 attack speed rows into 1.
Yes, if you would like to adjust the formulas and let me know i'd be glad to merge them into the spreadsheet.
Attack speed on weapons is different then attack speed on armor. Attack speed = Weapon base attack speed * Weapon "increases attack speed by" * "Attack Speed Increases" on armor. You could leave the "increases attack speed by" column as 0, and input the weapons tooltip attack speed as its base but you will come out with a less accurate dps figure.
The problem is most weapons base attack speed is 1.20, 1.30, or something else decently rounded, but when you get an increases attack speed by 11% it multiplies to 1.332, 1.443 but the game shows only 1.33, 1.44 while still using 1.332 and 1.443 to calculate your damage. So, depending on how much that matters to you, you can do either method.
Quote from mOOwalker
Very good work on the spreadsheet. In case you are working on extending it here are my comments(plus all the comment above me) to keep a track of them:
Keep up the good work
- Superstition Passive is missing
- Is there a need for both "Current" and "Current Equipped"? I may not understood correct the logic behind it but isn't always our Current = Current Equipped
- Resistance are missing (Fire, Poison, etc). Is there a need for them?
- Block Chance is missing (and shields)
- Reduce damage from elites is missing
- Reduce damage from melee attacks is missing
I could add superstition and other non physical resists to come out with two damage reduction figures, one for physical and one for other types of damage if that would be helpful.
Quote from thebouta
Okay maybe it's just me but i can't download it, all my toolbar options are grayed out.
it there another way to download it?
I'll look into hosting it on an outside site this afternoon once I incorporate the above changes
Quote from Xathian
I'm not actually worried about the legitimacy of your spreadsheet, I'm jsut curious what is causing this.
This is caused by the "Main stat" formula which uses a lookup function to see which stat you have set, I could look into other ways of setting it up, but as of now it works fine and this is the only inconvenience of it
I merged the weapon "Current" and "Current equiped" rows.
If I get the permission from the author I will upload it, when I get home (in 6h). I might even improve it more.
I'd love to have improvements shared, but as stated above, the current equipped is for comparing to possible upgrades and should be a separate column