In case there's any confusion, your Int, Vit, Str,DPS, HP, CC, CD, APS should exactly match the in game value (APS rounds to 2 decimals though). Your armor and lowest resist should match the in game values exactly, though they might differ by 1 due to rounding on the char sheet.
Detailed version with full gear stats comparison
https://drive.google.com/file/d/0B4-opYZrg_XRcE9RR0tVRTBwUlk/edit?usp=sharing
Features:
The spreadsheet features the ability to input your total stats and weapon stats to compute your dps and EHP. There's also a separate tab where you can compare different gear sets. The DPS value should match your in game Damage Number, provided all applicable stats are entered correctly. Additionally the spreadsheet computes relative dps gains for a range of dps stats and also reports those values in terms of comperable values of your primary stat, i.e., how many Intellect is 1%IAS worth, etc.
Here are some more specific features:
1) Calculates unbuffed dps, char sheet buffed dps, and effective char sheet dps. Char sheet buffed dps is what you will see in game based on all your skills. The effective char sheet dps is what your buffed char sheet dps would be if it included all the bonuses for the skill you use (such as +disintegrate%) and elemental damage type (like +arcane damage%).
2) Paragon point table where you can input how many points you spent on each stat. The table also shows you the relative gain of a paragon point for each stat to your effective char sheet dps and your EHP.
3) A second sheet allows you to compare two gear sets and displays the difference in EHP and DPS.
4) Relative dps and EHP gains for each stat are shown (int, vit, crit%, etc.).
5) A comparison of Marquise Ruby vs Emerald is shown for easy reference, or the gear comparison can be used to compare the different gems at higher levels. For most people Emerald will be much better now that weapon damage% has been drastically cut on new drops (used to go up to 50%, now it's like 10%, if that).
Limitations and Workarounds
Does not compute toughness stat, and toughness is not the same as EHP. I have no plans to implement functionality to compute toughness.
The spreadsheet does not work well with weapons that have a base attack speed of 1.15 APS, or any other base APS not divisible by 0.1. The workaround currently is to set the 1.15 APS weapon to 1.15 APS in the spreadsheet, and put 15% IAS on the weapon IAS cell in column C. That tricks the spreadsheet into computing the correct IAS. If your weapon does have IAS, I'm still working on a solution.
If you have any issues downloading or using the spreadsheet, feel free to post here or send me a PM after you've read the Help tab.
Currently planned additions: update to include other buffs like cold blooded and audacity/
EDIT:
3-15-14 Updated based on 2.0 changes
3-21-14 Updated formulas to account for AR from sockets
3-25-14 Updated Crit Damage to display the amount including paragon levels.
3-28-14
- Updated Mob level to 73 for Armor and resist mitigation and EHP calcs
- Updated Str, vit, and Int for a lvl 70 character
- Added Unwavering Will to buffs list
- Updated Enchantress EHP calculation to include armor from paragon points
- Updated HP calculation based on lvl 70 character
3-30-14 Corrected Paragon armor contribution on Full Gear Comparison tab
Added percent differences for DPS and EHP values between Equipped Items tab and Full Gear Comparison tab
3-31-14 Updated Life per Second from paragon levels to the correct amount for level 70 (165.1)
4-13-14 Updated Elite damage bonus calculation to be consistent with changes in game. It now is just an additve modifier.
Changed fill for cells C12 and C13 since they should remain blank
5-9-14 Corrected the Life% display on Equipped Items and Full Gear Comparison tabs to correctly include the amount from paragon points
5-22-14 Updated APS calculation to account for change in Enchantress contribution. Recent patch changed it from +0.03 APS to +3% IAS.
5-30-14 Fix a bug with Primary relative dps gain calculation on 'Equipped Items' tab that would give incorrect values when the enchantress was indicated as being used
5-31-14 fixed weapon damage% affix on weapons to work correctly with elemental damage, per patch 2.0.5 changes
1