First off, I made another small edit to my spreadsheet. When adding the new gear comparison tab, I neglected to add the ability to compare 1h+OH to 2h, which I just did in the form of a logic box. Just set it to 0 for comparing 1h and 1 for comparing 2h.
Magic Weapon is not bugged really, the only issue is the description which can lead to confusion.
Magic Weapon effects aren't calculated after all of your stats, but before them. The spell literally increases your weapon damage by 10-15% (depending on rune). This includes off-hands (and - I have not tested but I assume - any other item that adds to your min/max damage, such as rings or amulets).
For example, a 10-20 weapon with 10% Magic Weapon bonus turns into 11-22.
A 1hander with 5-10 with an offhand that adds 5-10 turns into 11-22 total as well.
Hope this makes it clear enough
I don't think that's completely correct. The reason it is bugged is because it effectively applies the 15% bonus twice to your displayed Damage Number: once on your character sheet for bonus damage due to skills, and once to your weapon, as you described. That's why people see around a 30% increase when activating it, though it's not exactly 30% which is another reason for the general belief that there is a bug associated with it. The reports I've read claim that when you have MW active, your damage is no longer based directly off your Damage Number but instead is based off your unbuffed DN*1.15. In other words, the tooltip of the spell is correct and it essentially increases your dps by 15%, but the in game Damage Number shows an incorrect value while it is active. That's the "tooltip error" I was referring to: the damage number display, though tooltip error is a misleading way to say it.
As I said before, I can get the numbers to match the in game displayed Damage Number, all I have to do is increase the "% Damage Increase from Skills" by the appropriate amount and then multiply the final dps by that fraction I showed (at least when using Force Weapon rune). I get the same results when directly multiplying my final weapon DPS by the same fraction. It doesn't really matter where you put the 1.1499... factor since they're all multiplied together anyway.
However, the in game displayed Damage Number is not correct when you have Magic Weapon active. I just tested it in game to be sure but it definitely only increases your dps by 10 or 15%, not the 20 or 30% shown by your damage number.
If anyone is curious how I tested it, I bought a 5-14 damage range 1h and a +9min dmg necklace. I then took off all my gear but my boots and hat to give me around 130 DPS on my char sheet. With that dps I was hitting Act 1 Inferno zombies for right around 100 a hit. When I activated Magic Weapon, with no rune, it increased the dps on my char sheet by around 20% but I was hitting the zombies for no more than 110 each hit, thus only a 10% damage increase. If my displayed Damage Number was correct I should have been hitting them for around 120 each hit since my dps was 20% higher.
Love the sheet, the DPS part works great but there's something wrong with the EHP part. When i compare some item with what i wear the sheet showed me I will have 125k EHP instead of 100k EHP. After i did equip the item and put the new numbers in 'equipped' it showed me i now have 120k EHP instead of 125k that was calculated earlier.
What item slot was it? And just to be sure, you're comparing the same EHP value? The value on the item comparison sheet is for FA+GC, while there's a couple listed on the other page.
Hey Loroese, I put in everything and the spreadsheet is awesome, thank you for making this!
I have one question: in the dps breakdown section where it says what one of each stat will do to increase your dps vs an equivalent amount of int. Why is %attack speed having a different value than weapon % as?
Hey Loroese, I put in everything and the spreadsheet is awesome, thank you for making this!
I have one question: in the dps breakdown section where it says what one of each stat will do to increase your dps vs an equivalent amount of int. Why is %attack speed having a different value than weapon % as?
Because weapons %AS and other gear %AS are treated differently. The weapon %AS is already included in the weapon dps shown on the character sheet. It is not added to the rest of the gear when calculating your final attack rate. For this reason in the absence of +bonus damage on other gear, weapon %AS has no affect on your damage number. Other %AS will affect your damage number regardless of extra +bonus damage. If you read through some of the previous posts you can see my example of why your damage number is dependent on your weapon AS when using a 1h+OH .
What item slot was it? And just to be sure, you're comparing the same EHP value? The value on the item comparison sheet is for FA+GC, while there's a couple listed on the other page.
I was using the first, simple sheet, the simple one. A had my stats in, the HP and DPS were good, and i looked how my EHP with FA+GC will change if I change some pants. It showed me that from 100k i have now it will be 125k. After that i put on the pants, I change the equipped stats (vit armor resist and int) so they match my actual char profile and the EHP it shows is 120k instead of 125k it said it will be.
Would you mind sending a pm with the relative stats so I can duplicate it and figure out what is going on? When putting the armor stat in did you use the bonus armor for the gear, the armor displayed plus bonus armor, or just the displayed armor value? If it makes any difference the armor value displayed on the item includes any bonus armor but does not include armor due to strength.
I updated the original post to list the spreadsheet features and current limitations.
I did a few edits to the Main Hand comparison area of the detailed item comparison tab to allow for a few extra stats to be compared, specifically bonus damage, crit and armor. Now if you have a 2h and want to compare to a 1h+OH you should be able to fit all the relevent stats in the Main Hand area of that page where as before there was no place for the OH bonus damage or crit% stats.
I also just found a small bug where my EHP comparison for the chest piece was ignoring any Vit in sockets, on the chance you wanted to put a vit gem in to up your EHP instead of DPS. This has been fixed with the current version.
If anyone finds any other errors, bugs, or just can't get things to work out correctly, feel free to pm me or post in the thread.
It seems that on the Main sheet "Actual Weapon APS" need to have the round value changed to 2. Right now it is rounding off the 2nd digit of a weapon. So if you go from a weapon with 1.26 APS to 1.27, there is 0dps change.
If you go from a weapon with 1.26 APS to 1.27 APS you would also have different +IAS values on the weapon. I round it to 1 decimal because the base weapon speed on weapons only uses 1 decimal, though I think there might be an exception for some 2h with 0.95 weapon speed that I need to take into account.
Simple question, if I compare two weapon and the second one has +xx% damage, i need to put it on the calculator or no? I know that the min and max damage are already upgradated in the tooltip
No, you do not need to put any +damage or +damage% found on the main hand weapon. That is already included in the weapon damage range.
I'm having an issue with the spreadsheet since I upgraded my gloves.
Before the upgrade, the stat sheet matched up with my DPS stat in-game perfectly (minus force weapon of course).
However since changing my gloves from an ASpeed pair to a Crit/Crit pair the spreadsheet gives me a lower number than my character sheet does. I'm using the detailed sheet, and the blue boxes in column R all match my character sheet, but the black ones R28 & R29 are lower than the in-game results.
Is there any indication whether the miscalculation is from the spreadsheet or the game client?
Okay, I had a look through myself and the Equipped Calculations sheet wasn't adding 60% crit from my weapon gem. If I manually changed this total to include that bonus, the numbers added up.
I'm having an issue with the spreadsheet since I upgraded my gloves.
Before the upgrade, the stat sheet matched up with my DPS stat in-game perfectly (minus force weapon of course).
However since changing my gloves from an ASpeed pair to a Crit/Crit pair the spreadsheet gives me a lower number than my character sheet does. I'm using the detailed sheet, and the blue boxes in column R all match my character sheet, but the black ones R28 & R29 are lower than the in-game results.
Is there any indication whether the miscalculation is from the spreadsheet or the game client?
Okay, I had a look through myself and the Equipped Calculations sheet wasn't adding 60% crit from my weapon gem. If I manually changed this total to include that bonus, the numbers added up.
edit; P.S. sweet spreadsheet man, love the work.
You're right, there was an error in my Equipped Calculations page where it wasn't adding the bonus life, crit, or vit from sockets to the total. The number was being added on the page you input the gear, so that value should have been correct before. It has now been corrected.
Just to be sure, since the calculator had the voice min + damage/max + damage for weapon comparison, i need to put here the off-hand stats? What about the extra damage like 200-500 fire damage, it's also this included in the white damage tooltip?
Yes, you only need to put values into min+damage or max+damage for your weapon if you're trying to combine your MH+OH in that column. In other words, you shouldn't put any of your MH extra damage information in the shreadsheet since it's already included in the weapon damage range shown on the tooltip.
I can see what you mean now, apologies for the ignorance of that tooltip bug.
Quite a shame, really, oh well - lower DPS it is.
Thats one of the reasons Im not even using magic weapon anymore, when I realized its a false 30% damage increase, sometimes people would think, OMG its 30% damage increase I HAVE TO USE IT, but its actually only 15%, so I guess its ok to skip it for somethingelse.
PS: Im still using the spreadsheet(I think its the one you edited for the first time), and its working great for me, once you learn how to mess around with the numbers and all everything fits fine, and check with the in game changes. I dont use the EHP though cuz I have a rough idea and dont need it.
It's probably worth mentioning I fixed another bug yesterday where my Neck slot equipment comparison was calculating the EHP wrong in the pressence of %life. It was actually decreasing the calculated EHP value when present instead of increasing. It should be fixed now.
Just wanted to thank Loroese for this dps spreadsheet, really appreciate the work you put into it!
Also a tip for anyone who uses different computers or don't have Excel on a particular computer, you can made a copy of the spreadsheet to your Google drive (so you need a Google account). There you can type in your numbers and it saves your data automatically as you work. It allows you to edit it on any computer you want without having to transfer any files.
I do have a suggestion: In "Equipped Comparison", for "New EHP with FA and GC", is it possible to display the number as a difference compared to the current equipped value? Like how DPS is displayed as a DPS difference. Think a EHP difference would be useful to display so that we know if the new piece is higher or lower in EHP.
Also, is it possible to include either a version number or patch notes in the "Notes" section? Would make it easier for viewers to know if they're using an older version, and need to import/download a new version.
Also, is it possible to include either a version number or patch notes in the "Notes" section? Would make it easier for viewers to know if they're using an older version, and need to import/download a new version.
Yes, I'll start adding update notes in the "Notes" secion, or possibly just add an "Update" tab with dates and descriptions of updates.
Awesome spreadsheet, just what I was looking for! Small sidenote, a lot of the hardcore wizards are using EA+Prismatic rune instead of force armor. Generally cause they stack a lot more hp than most others. Is there any intention to possibly add this to the display/calculations?
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
I don't think that's completely correct. The reason it is bugged is because it effectively applies the 15% bonus twice to your displayed Damage Number: once on your character sheet for bonus damage due to skills, and once to your weapon, as you described. That's why people see around a 30% increase when activating it, though it's not exactly 30% which is another reason for the general belief that there is a bug associated with it. The reports I've read claim that when you have MW active, your damage is no longer based directly off your Damage Number but instead is based off your unbuffed DN*1.15. In other words, the tooltip of the spell is correct and it essentially increases your dps by 15%, but the in game Damage Number shows an incorrect value while it is active. That's the "tooltip error" I was referring to: the damage number display, though tooltip error is a misleading way to say it.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
http://www.d3unlimited.com
However, the in game displayed Damage Number is not correct when you have Magic Weapon active. I just tested it in game to be sure but it definitely only increases your dps by 10 or 15%, not the 20 or 30% shown by your damage number.
If anyone is curious how I tested it, I bought a 5-14 damage range 1h and a +9min dmg necklace. I then took off all my gear but my boots and hat to give me around 130 DPS on my char sheet. With that dps I was hitting Act 1 Inferno zombies for right around 100 a hit. When I activated Magic Weapon, with no rune, it increased the dps on my char sheet by around 20% but I was hitting the zombies for no more than 110 each hit, thus only a 10% damage increase. If my displayed Damage Number was correct I should have been hitting them for around 120 each hit since my dps was 20% higher.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Quite a shame, really, oh well - lower DPS it is.
http://www.d3unlimited.com
What item slot was it? And just to be sure, you're comparing the same EHP value? The value on the item comparison sheet is for FA+GC, while there's a couple listed on the other page.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I have one question: in the dps breakdown section where it says what one of each stat will do to increase your dps vs an equivalent amount of int. Why is %attack speed having a different value than weapon % as?
Because weapons %AS and other gear %AS are treated differently. The weapon %AS is already included in the weapon dps shown on the character sheet. It is not added to the rest of the gear when calculating your final attack rate. For this reason in the absence of +bonus damage on other gear, weapon %AS has no affect on your damage number. Other %AS will affect your damage number regardless of extra +bonus damage. If you read through some of the previous posts you can see my example of why your damage number is dependent on your weapon AS when using a 1h+OH .
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Would you mind sending a pm with the relative stats so I can duplicate it and figure out what is going on? When putting the armor stat in did you use the bonus armor for the gear, the armor displayed plus bonus armor, or just the displayed armor value? If it makes any difference the armor value displayed on the item includes any bonus armor but does not include armor due to strength.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I did a few edits to the Main Hand comparison area of the detailed item comparison tab to allow for a few extra stats to be compared, specifically bonus damage, crit and armor. Now if you have a 2h and want to compare to a 1h+OH you should be able to fit all the relevent stats in the Main Hand area of that page where as before there was no place for the OH bonus damage or crit% stats.
I also just found a small bug where my EHP comparison for the chest piece was ignoring any Vit in sockets, on the chance you wanted to put a vit gem in to up your EHP instead of DPS. This has been fixed with the current version.
If anyone finds any other errors, bugs, or just can't get things to work out correctly, feel free to pm me or post in the thread.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
No, you do not need to put any +damage or +damage% found on the main hand weapon. That is already included in the weapon damage range.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Before the upgrade, the stat sheet matched up with my DPS stat in-game perfectly (minus force weapon of course).
However since changing my gloves from an ASpeed pair to a Crit/Crit pair the spreadsheet gives me a lower number than my character sheet does. I'm using the detailed sheet, and the blue boxes in column R all match my character sheet, but the black ones R28 & R29 are lower than the in-game results.
Is there any indication whether the miscalculation is from the spreadsheet or the game client?
Screencaps:
Both sets of gloves to confirm stats
http://img703.images...89/gloveshv.jpg
Spreadsheet output with Crit/Crit gloves input
http://img832.images...spreadsheet.jpg
Character sheet with Crit/Crit gloves equipped
http://img6.imagesha.../statsheets.jpg
Okay, I had a look through myself and the Equipped Calculations sheet wasn't adding 60% crit from my weapon gem. If I manually changed this total to include that bonus, the numbers added up.
edit; P.S. sweet spreadsheet man, love the work.
http://htwtblog.blogspot.com
- - - - - - - - - - - - - - - - - - - - -
You're right, there was an error in my Equipped Calculations page where it wasn't adding the bonus life, crit, or vit from sockets to the total. The number was being added on the page you input the gear, so that value should have been correct before. It has now been corrected.
(1) was because I didn't add any of the vit, life, or crit from sockets on that sheet as mentioned above. Both issues should be fixed now, thanks.
Yes, you only need to put values into min+damage or max+damage for your weapon if you're trying to combine your MH+OH in that column. In other words, you shouldn't put any of your MH extra damage information in the shreadsheet since it's already included in the weapon damage range shown on the tooltip.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
PS: Im still using the spreadsheet(I think its the one you edited for the first time), and its working great for me, once you learn how to mess around with the numbers and all everything fits fine, and check with the in game changes. I dont use the EHP though cuz I have a rough idea and dont need it.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Also a tip for anyone who uses different computers or don't have Excel on a particular computer, you can made a copy of the spreadsheet to your Google drive (so you need a Google account). There you can type in your numbers and it saves your data automatically as you work. It allows you to edit it on any computer you want without having to transfer any files.
I do have a suggestion: In "Equipped Comparison", for "New EHP with FA and GC", is it possible to display the number as a difference compared to the current equipped value? Like how DPS is displayed as a DPS difference. Think a EHP difference would be useful to display so that we know if the new piece is higher or lower in EHP.
Also, is it possible to include either a version number or patch notes in the "Notes" section? Would make it easier for viewers to know if they're using an older version, and need to import/download a new version.
Yes, I'll start adding update notes in the "Notes" secion, or possibly just add an "Update" tab with dates and descriptions of updates.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard