After seeing the other post regarding EHP in Inferno I decided to make my own EHP calculator in my spreadsheet. I used the damage resistance formulas from the site listed below but had to figure out the armor calc for FA+glass cannon manually. Like the webpage with the EHP calculator you should be able to just input your stats from your details page and then indicate if you have Force Armor and/or glass cannon active and it should be able to calculate your EHP from there. I also added the conversion of Str and Int to armor and resist respectively so it should completely calculate your new EHP for the new item.
If there are any errors or mistakes, please let me know and I'll fix them as soon as I can. Also, if anyone downloaded a previous version before reading this post, I recommend you re-download to make sure your version doesn't have any errors the previous version might have had (there were a few, and I updated the EHP part just before posting this).
Im sorry my ignorance but how could one use that knowledge to know if for example a weapon for sale will be better than my own?
If you open the spreadsheet you will notice a few red boxes. Fill in your in game stats in there including weapon damage, both low and and high end, weapon speed shown in the tooltip, your total crit% and crit damage % shown in the details area of your character sheet/inventory, as well as the total of all +attack speed on your gear besides your weapon, and any +dmg stats you might have. For example, if you have a +2-4 bonus dmg ring, put 2 in the min+dmg and 4 in the max+dmg box. If you have multiple cases of +dmg, add them up. I'll probably edit the spreadsheet later to have multiple boxes for those values so you don't have to add them manually but for now just put the totals. Once again, do not include any of the stats on your weapon in the boxes aside from the base weapon damages and attack speed. If everything is entered correctly the DPS box should show the damage number indicated on your character screen, and the Mod AS box should show your total number of attacks per second shown on your char details screen.
To compare weapons, put the stats of your currently equipped weapon in the Equipped box, including any Int it might have on it, and the attacks per second shown on the weapon in the attack speed box, but do not put any of your weapon stats in the +dmg boxes, even if your weapon has say +100-200 bonus dmg. That value is already included on the total weapon damage displayed. Change the last box (Weapon?) from 0 to 1, or just don't include any values for +attack speed on the weapon. In the next column, input the stats of any weapon you want to compare, including the weapon attack speed. Again, ignore any +bonus damage or +% damage, and you can also ignore any +attack speed. If you are using an offhand, include any relavent stats with the 1h. Using a source means putting the +xxx-yyy damage into the Min +dmg (xxx) and max + dmg (yyy) boxes, and if you have any overlapping stats, like int on both MH and OH, just add them together and input the total.
In the DPS difference box, you should see a number under the Item 1 column. That number represents how your dps will change if you equip the new item instead of the old. If it is negative, that means you lose dps from switching. The same goes for the Item 2 column and in both cases compares the new dps to your current dps, only switching the one item.
I'd recommend trying it out with a couple random rares you have laying around in your bags or can find off mobs to make sure the spreadsheet is giving the correct results. If you have any other issues or questions, just ask or send a pm, but I would definitely make sure the spreadsheet is working correctly before making any significant purchases.
I just recently switched from a slow 2h to a fast 1h and noticed a few interesting trends in dps when comparing different weapons. The abreviated version is that when using an OH I get a higher damage number from a slightly lower dps (905.1dps) weapon that had +attack speed than a weapon without (939.9 dps).
For a 2h the main stat that mattered when it came to dps was the weapon dps. Attack speed weapons gave the same dps as just +xx% dmg weapons. When looking at 1h I noticed that I could get more dps from a 1h with IAS than a slightly higher dps weapon with just+50% dmg or so. Of course, when comparing my 2h to my 1h I included my OH, which is a source with a lot of +dmg. I haven't read a lot of theorycrafting ideas relating to this game yet but I think the reason for the differences can be explained by thinking of attacking as using both your MH and OH simultaneously (I know that's not really how the game works, but when not dual weilding, mathematically you combine the MH and OH stats every attack). Your OH 'attacks' just as frequently as your MH so that if you increase the frequency of MH attacks, you increase frequency of OH 'attacks'. Your OH stats are also completely independant of your MH stats so if you get a faster weapon, you get more effective dps out of your OH. Since IAS on a weapon makes the attack speed faster, it leads to more dps than you would get from an equivalent dps weapon with no IAS.
Quick comparison based on my current spreadsheet:
Current Weapon
364-816 dmg, 905.1 dps, 18% IAS, 1.3 attacks per sec base (back calculated)
effective attacks per sec = 1.3*1.18 = 1.534 but only shows 1.53 on the tooltip
Alternative Weapon
459-987 dmg, 939.9 dps, 1.3 attacks per sec, no relavent stats just +dmg% and bonus dmg
OH
really any OH would work, but here's mine because that's where my numbers come from
+103-360 dmg, 82 Int
When I put those into the comparison area of my spreadsheet it tells me I lose 499.3 dps with the HIGHER dps weapon. On a side note, if my OH was only +103-190 dmg, I would gain 14.4 dps from switching weapons.
So to summarize: If using any gear with +dmg, be it rings, necks, or OHs, you might be able to gain dps by switching to or choosing a lower dps weapon with +IAS compared to a weapon without +IAS.
If anyone questions the calculations of the spreadsheet I'd recommend buying a couple really cheap weapons on the AH, get 2 with about the same dps, one with IAS one without and just equip them and check your in game damage number. As long as you have any +dmg gear not including your weapon, I would expect the IAS weapon to be higher dps than the other, all other things being equal. Unfortunatelly, this means that when shopping for a new weapon you might have to compare several different weapons and look at a lot of different stats to find the one that actually improves your damage number the most for your price range.
I am considering building an application that ghaters all the data posted in the forums, incase i build it, do you have any problem with me using your research? You will have the proper credits.
Nope, I have no problem with that or with anyone editing or modifying my spreadsheet or equations in any way.
This is the DPS and EHPspreadsheet I've been working on. It was made with a wizard in mind but so far should work for any class that is not dual wielding, though it currently does not support any class specific buffs or passives besides some of the wizard ones. If you're having any issues with the spreadsheet please read the "Notes" tab to make sure you're entering the correct information. WEAPON +DAMAGE% now has a box in the spreadsheet, so dps values should be accurate.
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.
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-29-14 Corrected EHP calculation with Unwavering Will
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
0
http://mmo-mechanics.com/swtor/forums/Thread-Diablo-3-formula-list
If there are any errors or mistakes, please let me know and I'll fix them as soon as I can. Also, if anyone downloaded a previous version before reading this post, I recommend you re-download to make sure your version doesn't have any errors the previous version might have had (there were a few, and I updated the EHP part just before posting this).
0
0
If you open the spreadsheet you will notice a few red boxes. Fill in your in game stats in there including weapon damage, both low and and high end, weapon speed shown in the tooltip, your total crit% and crit damage % shown in the details area of your character sheet/inventory, as well as the total of all +attack speed on your gear besides your weapon, and any +dmg stats you might have. For example, if you have a +2-4 bonus dmg ring, put 2 in the min+dmg and 4 in the max+dmg box. If you have multiple cases of +dmg, add them up. I'll probably edit the spreadsheet later to have multiple boxes for those values so you don't have to add them manually but for now just put the totals. Once again, do not include any of the stats on your weapon in the boxes aside from the base weapon damages and attack speed. If everything is entered correctly the DPS box should show the damage number indicated on your character screen, and the Mod AS box should show your total number of attacks per second shown on your char details screen.
To compare weapons, put the stats of your currently equipped weapon in the Equipped box, including any Int it might have on it, and the attacks per second shown on the weapon in the attack speed box, but do not put any of your weapon stats in the +dmg boxes, even if your weapon has say +100-200 bonus dmg. That value is already included on the total weapon damage displayed. Change the last box (Weapon?) from 0 to 1, or just don't include any values for +attack speed on the weapon. In the next column, input the stats of any weapon you want to compare, including the weapon attack speed. Again, ignore any +bonus damage or +% damage, and you can also ignore any +attack speed. If you are using an offhand, include any relavent stats with the 1h. Using a source means putting the +xxx-yyy damage into the Min +dmg (xxx) and max + dmg (yyy) boxes, and if you have any overlapping stats, like int on both MH and OH, just add them together and input the total.
In the DPS difference box, you should see a number under the Item 1 column. That number represents how your dps will change if you equip the new item instead of the old. If it is negative, that means you lose dps from switching. The same goes for the Item 2 column and in both cases compares the new dps to your current dps, only switching the one item.
I'd recommend trying it out with a couple random rares you have laying around in your bags or can find off mobs to make sure the spreadsheet is giving the correct results. If you have any other issues or questions, just ask or send a pm, but I would definitely make sure the spreadsheet is working correctly before making any significant purchases.
0
For a 2h the main stat that mattered when it came to dps was the weapon dps. Attack speed weapons gave the same dps as just +xx% dmg weapons. When looking at 1h I noticed that I could get more dps from a 1h with IAS than a slightly higher dps weapon with just+50% dmg or so. Of course, when comparing my 2h to my 1h I included my OH, which is a source with a lot of +dmg. I haven't read a lot of theorycrafting ideas relating to this game yet but I think the reason for the differences can be explained by thinking of attacking as using both your MH and OH simultaneously (I know that's not really how the game works, but when not dual weilding, mathematically you combine the MH and OH stats every attack). Your OH 'attacks' just as frequently as your MH so that if you increase the frequency of MH attacks, you increase frequency of OH 'attacks'. Your OH stats are also completely independant of your MH stats so if you get a faster weapon, you get more effective dps out of your OH. Since IAS on a weapon makes the attack speed faster, it leads to more dps than you would get from an equivalent dps weapon with no IAS.
Quick comparison based on my current spreadsheet:
Current Weapon
364-816 dmg, 905.1 dps, 18% IAS, 1.3 attacks per sec base (back calculated)
effective attacks per sec = 1.3*1.18 = 1.534 but only shows 1.53 on the tooltip
Alternative Weapon
459-987 dmg, 939.9 dps, 1.3 attacks per sec, no relavent stats just +dmg% and bonus dmg
OH
really any OH would work, but here's mine because that's where my numbers come from
+103-360 dmg, 82 Int
When I put those into the comparison area of my spreadsheet it tells me I lose 499.3 dps with the HIGHER dps weapon. On a side note, if my OH was only +103-190 dmg, I would gain 14.4 dps from switching weapons.
So to summarize: If using any gear with +dmg, be it rings, necks, or OHs, you might be able to gain dps by switching to or choosing a lower dps weapon with +IAS compared to a weapon without +IAS.
If anyone questions the calculations of the spreadsheet I'd recommend buying a couple really cheap weapons on the AH, get 2 with about the same dps, one with IAS one without and just equip them and check your in game damage number. As long as you have any +dmg gear not including your weapon, I would expect the IAS weapon to be higher dps than the other, all other things being equal. Unfortunatelly, this means that when shopping for a new weapon you might have to compare several different weapons and look at a lot of different stats to find the one that actually improves your damage number the most for your price range.
0
Nope, I have no problem with that or with anyone editing or modifying my spreadsheet or equations in any way.
5
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-29-14 Corrected EHP calculation with Unwavering Will3-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