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.

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

Like single +res and dmg reduction for Melee and Ranged?

sorry for my english

For some reason, I am getting 404... is this alive?

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

Blizzard Entertainment - Diablo III Community MVPArmory | YouTube | Twitter | Clan Site