Corrected the Life% display on Equipped Items and Full Gear Comparison tabs to correctly include the amount from paragon points. Total HP and EHP was calculated correctly but the display was incorrect. It should once again match the value you see in game.
Great spreadsheet! Thank you for sharing. Couple of quick questions:
1) Are you planning on updating this to reflect latest changes?
2) I play multiple classes. [All my chars need to reroll their operator.] Looks like the spreadsheet will be invaluable in helping to choose which stats to reroll on items. That being said: For classes other than wizard, can I just substitute main quality for INT? Example: DEX for monk. If that won't work, may I have your permission to "steal" your work and update it for other classes? I would be happy to share it back to you. Or could you refer me to a spreadsheet that works for all classes?
1) I tend to update it as things change in diablo, though I haven't seen any changes lately that require any changing. I still have plans to add some things, like another damage reduction column.
2) You are welcome to use any or all of it in whatever way you want. Otherwise, yes, substituting your dex values for the int column willgive you the right dps numbers, but only if you aren't dual wielding. The spreadsheet so far does not support that, mostly because I haven't played any of the dual wielding classes enough to actually like them as much as my wiz. Also, that will give you the wrong EHP, since Int does give AR, but you can fix that by putting your int value in some AR slot and dividing by 10. There might be some issues with base stats for the different classes at 70, but otherwise it can work reasonably well for a wide variety of comparisons.
Updated APS calculation to account for change in Enchantress contribution. Recent patch changed it from +0.03 APS to +3% IAS. Thanks to DeiExMachina for pointing out the undocumented change.
The calculation of the gain from INT is off due to an error in cell H25 of Equipped Calculations (drastically overvalued). It's incorrectly still including the Enchantress buff as +0.03 APS while cell H16 also includes it as +3% IAS. Removing '+0.03*'Equipped Items'!$U$23' from the formula in H25 resolves the problem.
I made some updates to the spreadsheet for the latest patch and added a first attempt at firebird dot calculation. It's mostly meant for a rough comparison between gear sets as the actual value should be higher in game due to legendary gems and strongarm bracers. Please let me know if there are any errors.
Corrected the Life% display on Equipped Items and Full Gear Comparison tabs to correctly include the amount from paragon points. Total HP and EHP was calculated correctly but the display was incorrect. It should once again match the value you see in game.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
1) Are you planning on updating this to reflect latest changes?
2) I play multiple classes. [All my chars need to reroll their operator.] Looks like the spreadsheet will be invaluable in helping to choose which stats to reroll on items. That being said: For classes other than wizard, can I just substitute main quality for INT? Example: DEX for monk. If that won't work, may I have your permission to "steal" your work and update it for other classes? I would be happy to share it back to you. Or could you refer me to a spreadsheet that works for all classes?
Thanks.
2) You are welcome to use any or all of it in whatever way you want. Otherwise, yes, substituting your dex values for the int column willgive you the right dps numbers, but only if you aren't dual wielding. The spreadsheet so far does not support that, mostly because I haven't played any of the dual wielding classes enough to actually like them as much as my wiz. Also, that will give you the wrong EHP, since Int does give AR, but you can fix that by putting your int value in some AR slot and dividing by 10. There might be some issues with base stats for the different classes at 70, but otherwise it can work reasonably well for a wide variety of comparisons.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Updated APS calculation to account for change in Enchantress contribution. Recent patch changed it from +0.03 APS to +3% IAS. Thanks to DeiExMachina for pointing out the undocumented change.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
fixed weapon damage% affix on weapons to work correctly with elemental damage, per patch 2.0.5 changes
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Armory | YouTube | Twitter | Clan Site
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I thought dfans was dead outside of the news page.
Edit: I just realized I posted almost exactly the same thing almost exactly four months ago.
Armory | YouTube | Twitter | Clan Site
Whats wrong with this spreadsheet that needs updating? It seems to be working fine for me.