Hi all. I have being thinking about making this spreadsheet for a while now. Since I am planning to roll a barbarian first, hence this spreadsheet. I feel every class is so unique in their spells and runes that there needs to be a separate spreadsheet for each of them.
Now what does this spreadsheet do for you?
Well if you are a Barbarian, it does 2 things for you.
1a. You can choose your build(any 6 active skills) and the rune and it will compute the white damage range, white damage average, critical damage range, critical damage average, approximate damage, and any other damage due to extra effects from the rune for each skill. Hence it's useful for any offensive skill. For ex. if you select Ground Stomp, then it will show it does 0 MH (mainhand) and 0 OH (offhand) damage, however if you choose Ground Stomp with the rune Trembling Stomp (76% weapon damage), then it will show the amount of damage the rune would do. Here is a screenshot of it
1b. You can also select your 3 passive skills and based on that your damage might change (For ex. if you have Weapons master and you are wielding a sword, then your damage will go up by 15% and so on.)
1c. Skill affixes can also be added. Though it wasn't in the beta but it has been data mined, that weapons have affixes which enhance the damage or critical chance of some barbarian skills like Bash, Cleave, Seismic Slam and so on. You can also select the skill which has an affix and mention the amount of increase in that affix.
2a. The other thing that it does, is to compare different pieces of gear in the same slot and how it affects the weapon damage and the overall DPS.
1. The first thing that you want to do is Enable Editing and Enable Macros else it won't work.
2. Press the "Input Char. Attb." and fill up the text boxes. Make sure you read what exactly you need to fill up for Crit % and Bonus Crit Damage %. Please read #8 and #9 on that worksheet. Press Enter to update the fields on the "Barb_Skill_Damage_Calculation" and "Gear_Comparison" worksheet.
3. Now go to the "Barb_Skill_Damage_Calculation" worksheet and start playing with the different skills to see how much damage they do.
4. Check the "Gear_Comparison" worksheet to change gear and see the effect on weapon damage and DPS.
5. Any time you want to update both the stats of "Barb_Skill_Damage_Calculation" and "Gear_Comparison" at the same time, click on the "Input Char. Attb." button and fill it up. However you can also manually update each of those worksheets. (But in that case the other sheet won't be updated and you have to manually update that too.)
Things to note.
1. In the beta, some skills did damage from both MH and OH weapon (so weapon damage was calculated separately for them). Therefore, for now I have listed both MH and OH damage for every skill.
2. The damage done by the skill that is shown takes into account the fact, that the monster has 0 armor and will take the entire damage. Once I know the armor values of all the monsters and how much damage they mitigate, I will update the spreadsheet likewise.
3. This spreadsheet only cares about your damage and DPS. It doesn't list any effects that has nothing to do with damage.
Please have a look at it and let me know if you find any bugs and if you have any suggestions. I hope the spreadsheet will help Barbarians who want to seriously theory craft and min-max their gear. Here is the link for the spreadsheet
BTW programing isn't my profession, it's just a hobby, hence to some programers the spreadsheet might not look very professional. I apologize for that.
I do have a minor suggestion though: a link to where we can check for updates, whenever you decide on a location to advertise this.
When I played WoW, I had spreadsheets like this for damage calculations or combat table coverage, and I would always insert a link to where I could check to see if it got updated. Since the spreadsheet is locked, I can't do that myself.
I do have a minor suggestion though: a link to where we can check for updates, whenever you decide on a location to advertise this.
When I played WoW, I had spreadsheets like this for damage calculations or combat table coverage, and I would always insert a link to where I could check to see if it got updated. Since the spreadsheet is locked, I can't do that myself.
Just some quality-of-life stuff.
Here is the blog that I just made. I will update it quite often after May 15th.
I do have a minor suggestion though: a link to where we can check for updates, whenever you decide on a location to advertise this.
When I played WoW, I had spreadsheets like this for damage calculations or combat table coverage, and I would always insert a link to where I could check to see if it got updated. Since the spreadsheet is locked, I can't do that myself.
Just some quality-of-life stuff.
Here is the blog that I just made. I will update it quite often after May 15th.
Oh, I should have clarified. I was referring to a link inside the spreadsheet. It was more of a reminder thing that I would do, so I didn't forget to check for updates.
I do have a minor suggestion though: a link to where we can check for updates, whenever you decide on a location to advertise this.
When I played WoW, I had spreadsheets like this for damage calculations or combat table coverage, and I would always insert a link to where I could check to see if it got updated. Since the spreadsheet is locked, I can't do that myself.
Just some quality-of-life stuff.
Here is the blog that I just made. I will update it quite often after May 15th.
Oh, I should have clarified. I was referring to a link inside the spreadsheet. It was more of a reminder thing that I would do, so I didn't forget to check for updates.
But thanks for the link anyway.
Sorry, I misunderstood you. I have put a link on the spreadsheet where you can always find the updated versions.
Well, heading to bed for real this time *shakes fist at your spreadsheet keeping me awake*
Some quick notes I have so far would be to put a link as others have said already - perhaps just below the top center title of the "How to use" tab. It's quite common for people to download spreadsheets without bookmarking where they got it from and then say screw it to trying to find the forum thread again.
I'm curious if you plan to have additional questions like "How many enemies are you fighting?" for things like Brawler (passive) or if you're just going to assume it always applies if you choose it? I'm assuming so but thought I'd ask for the sake of asking since you said the spreadsheet only includes things that have an impact on your damage yet the only passives I saw change anything were Ruthless and Weapons Master.
Do you have plans to model Fury?
All in all, this functions way better than many other game spreadsheets I've seen! It just needs gussying up which will come in time (and is subjective). Personally, I think it could all be one tab but maybe that's just me. I think with the proper borders and coloring you can format the two gear comparison columns (current and possible DPS) into the left half of a tab with both DPS values in the top row and freeze pane it. Then, active/passive skill selection on the right. Lastly, on the Active Skills table, Avg White Damage and Avg Crit Damage columns could be removed in my opinion. The approximate damage per hit is all that matters, which ought to be changed to DPS and include haste imo. The only reason I see having them would be for auditing purposes, but you could just as easily put your formula used as a mouseover note on the column title and let anyone interested in auditing your work go from there.
Once again, baller spreadsheet you've got so far, and I don't mean to be so critical. I just see a lot of potential is all, and if my view differs from yours, s'all good.
Well, heading to bed for real this time *shakes fist at your spreadsheet keeping me awake*
Some quick notes I have so far would be to put a link as others have said already - perhaps just below the top center title of the "How to use" tab. It's quite common for people to download spreadsheets without bookmarking where they got it from and then say screw it to trying to find the forum thread again.
I'm curious if you plan to have additional questions like "How many enemies are you fighting?" for things like Brawler (passive) or if you're just going to assume it always applies if you choose it? I'm assuming so but thought I'd ask for the sake of asking since you said the spreadsheet only includes things that have an impact on your damage yet the only passives I saw change anything were Ruthless and Weapons Master.
Do you have plans to model Fury?
All in all, this functions way better than many other game spreadsheets I've seen! It just needs gussying up which will come in time (and is subjective). Personally, I think it could all be one tab but maybe that's just me. I think with the proper borders and coloring you can format the two gear comparison columns (current and possible DPS) into the left half of a tab with both DPS values in the top row and freeze pane it. Then, active/passive skill selection on the right. Lastly, on the Active Skills table, Avg White Damage and Avg Crit Damage columns could be removed in my opinion. The approximate damage per hit is all that matters, which ought to be changed to DPS and include haste imo. The only reason I see having them would be for auditing purposes, but you could just as easily put your formula used as a mouseover note on the column title and let anyone interested in auditing your work go from there.
Once again, baller spreadsheet you've got so far, and I don't mean to be so critical. I just see a lot of potential is all, and if my view differs from yours, s'all good.
Thanks for looking at it and for the suggestions. I have updated the spreadsheet (Ver 1.01 now) with the link of the page where the updated version will always reside. I have also updated a minor error. The page is
Regarding the passive Brawler, at the moment I don't have it incorporated in the spreadsheet since it's not a static damage increase and depends on a "specific condition", in this case having 3 enemies within 8 yds. I have only incorporated those passives which give a static damage or critical chance increase which for the Barbarian are Ruthless, Weapons Master and No Escape (for Ancient Spear and Weapon Throw).
Regarding Fury, I have plans for it, but I think it's much harder to model than just the damage so I have left it out for now. But I have plans for it and will start working on it soon.
Yes, I think the spreadsheet could be packed in 1 tab, however I felt there are lots of people who use small monitors and for them they might have to scroll quite a bit if I put everything on one sheet.
I do have a minor suggestion though: a link to where we can check for updates, whenever you decide on a location to advertise this.
When I played WoW, I had spreadsheets like this for damage calculations or combat table coverage, and I would always insert a link to where I could check to see if it got updated. Since the spreadsheet is locked, I can't do that myself.
Just some quality-of-life stuff.
Here is the blog that I just made. I will update it quite often after May 15th.
Oh, I should have clarified. I was referring to a link inside the spreadsheet. It was more of a reminder thing that I would do, so I didn't forget to check for updates.
But thanks for the link anyway.
Sorry, I misunderstood you. I have put a link on the spreadsheet where you can always find the updated versions.
Thanks! I know it's just an easy copy/paste, but keep up the good work. =)
Yes, my plan is to keep it updated all the time. On a side not, does anyone know how much armor a boss or any elite monster has? and depending on that, how much damage is mitigated?
Yes, my plan is to keep it updated all the time. On a side not, does anyone know how much armor a boss or any elite monster has? and depending on that, how much damage is mitigated?
I think we have some speculated player armor formulas around somewhere, but I'm not sure if those are 100% correct or even apply to bosses. Even so I don't think we have armor numbers for bosses. I'd think it'd change depending on the boss and difficulty, unless they stick a static - for example - 20% damage reduction on bosses.
Might have to wait until we get datamined info, or the 15th, for stuff like that.
Now what does this spreadsheet do for you?
Well if you are a Barbarian, it does 2 things for you.
1a. You can choose your build(any 6 active skills) and the rune and it will compute the white damage range, white damage average, critical damage range, critical damage average, approximate damage, and any other damage due to extra effects from the rune for each skill. Hence it's useful for any offensive skill. For ex. if you select Ground Stomp, then it will show it does 0 MH (mainhand) and 0 OH (offhand) damage, however if you choose Ground Stomp with the rune Trembling Stomp (76% weapon damage), then it will show the amount of damage the rune would do. Here is a screenshot of it
http://img341.images....rbskilldmg.jpg
1b. You can also select your 3 passive skills and based on that your damage might change (For ex. if you have Weapons master and you are wielding a sword, then your damage will go up by 15% and so on.)
1c. Skill affixes can also be added. Though it wasn't in the beta but it has been data mined, that weapons have affixes which enhance the damage or critical chance of some barbarian skills like Bash, Cleave, Seismic Slam and so on. You can also select the skill which has an affix and mention the amount of increase in that affix.
2a. The other thing that it does, is to compare different pieces of gear in the same slot and how it affects the weapon damage and the overall DPS.
Here is a screenshot of that tab.
http://img443.images....omparisonv.jpg
So how to use the spreadsheet the first time you open it.
This is how it will look the first time you start it.
http://img52.imagesh...35/howtouse.jpg
1. The first thing that you want to do is Enable Editing and Enable Macros else it won't work.
2. Press the "Input Char. Attb." and fill up the text boxes. Make sure you read what exactly you need to fill up for Crit % and Bonus Crit Damage %. Please read #8 and #9 on that worksheet. Press Enter to update the fields on the "Barb_Skill_Damage_Calculation" and "Gear_Comparison" worksheet.
3. Now go to the "Barb_Skill_Damage_Calculation" worksheet and start playing with the different skills to see how much damage they do.
4. Check the "Gear_Comparison" worksheet to change gear and see the effect on weapon damage and DPS.
5. Any time you want to update both the stats of "Barb_Skill_Damage_Calculation" and "Gear_Comparison" at the same time, click on the "Input Char. Attb." button and fill it up. However you can also manually update each of those worksheets. (But in that case the other sheet won't be updated and you have to manually update that too.)
Things to note.
1. In the beta, some skills did damage from both MH and OH weapon (so weapon damage was calculated separately for them). Therefore, for now I have listed both MH and OH damage for every skill.
2. The damage done by the skill that is shown takes into account the fact, that the monster has 0 armor and will take the entire damage. Once I know the armor values of all the monsters and how much damage they mitigate, I will update the spreadsheet likewise.
3. This spreadsheet only cares about your damage and DPS. It doesn't list any effects that has nothing to do with damage.
Please have a look at it and let me know if you find any bugs and if you have any suggestions. I hope the spreadsheet will help Barbarians who want to seriously theory craft and min-max their gear. Here is the link for the spreadsheet
http://dl.dropbox.co...ator_v1.02.xlsm
BTW programing isn't my profession, it's just a hobby, hence to some programers the spreadsheet might not look very professional. I apologize for that.
http://diablo3barb.wordpress.com/barbarian-calculator/
My D3 blog
http://diablo3barb.wordpress.com/
This. I'm about to head to bed, but I'm looking forward to playing around with it tomorrow. Thanks for the hard work!
Yes, my plan is to keep it up to date. I plan on starting a blog to discuss about the spreadsheet and any other theory crafting that I do.
http://diablo3barb.wordpress.com/barbarian-calculator/
My D3 blog
http://diablo3barb.wordpress.com/
When I played WoW, I had spreadsheets like this for damage calculations or combat table coverage, and I would always insert a link to where I could check to see if it got updated. Since the spreadsheet is locked, I can't do that myself.
Just some quality-of-life stuff.
Here is the blog that I just made. I will update it quite often after May 15th.
http://diablo3barb.wordpress.com/
and here is the page where I will update the spreadsheet
http://diablo3barb.wordpress.com/barbarian-calculator/
http://diablo3barb.wordpress.com/barbarian-calculator/
My D3 blog
http://diablo3barb.wordpress.com/
But thanks for the link anyway.
Sorry, I misunderstood you. I have put a link on the spreadsheet where you can always find the updated versions.
http://diablo3barb.wordpress.com/barbarian-calculator/
My D3 blog
http://diablo3barb.wordpress.com/
Some quick notes I have so far would be to put a link as others have said already - perhaps just below the top center title of the "How to use" tab. It's quite common for people to download spreadsheets without bookmarking where they got it from and then say screw it to trying to find the forum thread again.
I'm curious if you plan to have additional questions like "How many enemies are you fighting?" for things like Brawler (passive) or if you're just going to assume it always applies if you choose it? I'm assuming so but thought I'd ask for the sake of asking since you said the spreadsheet only includes things that have an impact on your damage yet the only passives I saw change anything were Ruthless and Weapons Master.
Do you have plans to model Fury?
All in all, this functions way better than many other game spreadsheets I've seen! It just needs gussying up which will come in time (and is subjective). Personally, I think it could all be one tab but maybe that's just me. I think with the proper borders and coloring you can format the two gear comparison columns (current and possible DPS) into the left half of a tab with both DPS values in the top row and freeze pane it. Then, active/passive skill selection on the right. Lastly, on the Active Skills table, Avg White Damage and Avg Crit Damage columns could be removed in my opinion. The approximate damage per hit is all that matters, which ought to be changed to DPS and include haste imo. The only reason I see having them would be for auditing purposes, but you could just as easily put your formula used as a mouseover note on the column title and let anyone interested in auditing your work go from there.
Once again, baller spreadsheet you've got so far, and I don't mean to be so critical. I just see a lot of potential is all, and if my view differs from yours, s'all good.
Thanks for looking at it and for the suggestions. I have updated the spreadsheet (Ver 1.01 now) with the link of the page where the updated version will always reside. I have also updated a minor error. The page is
http://diablo3barb.wordpress.com/barbarian-calculator/
You can also find it in my signature.
Regarding the passive Brawler, at the moment I don't have it incorporated in the spreadsheet since it's not a static damage increase and depends on a "specific condition", in this case having 3 enemies within 8 yds. I have only incorporated those passives which give a static damage or critical chance increase which for the Barbarian are Ruthless, Weapons Master and No Escape (for Ancient Spear and Weapon Throw).
Regarding Fury, I have plans for it, but I think it's much harder to model than just the damage so I have left it out for now. But I have plans for it and will start working on it soon.
Yes, I think the spreadsheet could be packed in 1 tab, however I felt there are lots of people who use small monitors and for them they might have to scroll quite a bit if I put everything on one sheet.
Thanks for all the suggestions.
http://diablo3barb.wordpress.com/barbarian-calculator/
My D3 blog
http://diablo3barb.wordpress.com/
Im getting so wound up for the 15th its killing me lol
Just make sure to keep updating it with info :3
http://diablo3barb.wordpress.com/barbarian-calculator/
My D3 blog
http://diablo3barb.wordpress.com/
Might have to wait until we get datamined info, or the 15th, for stuff like that.