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 posted this on the official Blizz forums. I am posting here as well. Let me know what you guys think.
So I am pretty sure lots of people have asked this question as to how many possible builds are there for each class in D3 (Elective mode enabled). I didn't find the answer anywhere myself, so I decided to create a thread on it. Here's my take on it.
A build consists of any 6 active skills and any 3 passive skills.
For each class
# of active skills = n
# of passive skills = p
Each active skill has 5 runes
No. of ways of picking 6 active skills from a choice on n = nC6. (n "Combination" 6)
No. of ways of picking a rune for each of these active skills already chosen = 5 x 5 x 5 x 5 x 5 x 5 = 5^6
No. of ways of picking a passive skill for a choice of p = pC3. (p "Combination" 3)
Total No. of possible builds for each class, S = nC6 x 5^6 x pC3.
nC6 = n!/(6!(n-6)!) and pC3 = p!/(3!(p-3)!).
Now let's compute the no. of skills for each class individually.
Barbarian
# of active skills = n = 22
# of passive skills = p = 16
Therefore S = 22C6 x 5^6 x 16C3 = 652,863,750,000. (652 billion+)
Demon Hunter
# of active skills = n = 23
# of passive skills = p = 15
Therefore S = 23C6 x 5^6 x 15C3 = 717,670,078,125. (717 billion+)
Monk
# of active skills = n = 21
# of passive skills = p = 14
Therefore S = 21C6 x 5^6 x 14C3 = 308,626,500,000. (308 billion+)
Witch Doctor
# of active skills = n = 22
# of passive skills = p = 15
Therefore S = 22C6 x 5^6 x 15C3 = 530,451,796,875. (530 billion+)
Wizard
# of active skills = n = 25
# of passive skills = p = 15
Therefore S = 25C6 x 5^6 x 15C3 = 1,259,070,312,500. (1259 billion+)
Things to note
Wizard has the most no. of builds and Monk has the least. Wizard has more than 4 times the no. of builds as the Monk.Some interesting comparisons involving the no. of Monk builds since it has the lowest no. of builds.
► If every person in this world (~7 billion) plays Monk in D3, then it is possible to play in such a way such that every single person is playing with a different build.
► So if every single person in this world is playing Monk in D3 with a different build, it will still only cover 2.27% of the all the possible Monk builds.
► So will there be a time when it is certain that 2 people will have the same build?
Yes. Going by the present growth rate of world population (1.1%), the population of Earth will reach 310 billion in the year 2569. If every person in the world is still playing Monk in D3 at that time, then it is guaranteed that there will be atleast 2 people who have the same build
► How much time will it take me to test all the builds for Monk?
If you test a build each second, then it will take 9787 years to check all the 308billion+ builds for the the Monk.
Since checking builds every second isn't possible, so let's say you check a new build every 5 minutes. Then it will take 2.9+ million years to check every build for the Monk.
► And we haven't even touched the other 4 classes which have a lot more builds than the Monk.
3
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.
2
So I am pretty sure lots of people have asked this question as to how many possible builds are there for each class in D3 (Elective mode enabled). I didn't find the answer anywhere myself, so I decided to create a thread on it. Here's my take on it.
A build consists of any 6 active skills and any 3 passive skills.
For each class
# of active skills = n
# of passive skills = p
Each active skill has 5 runes
No. of ways of picking 6 active skills from a choice on n = nC6. (n "Combination" 6)
No. of ways of picking a rune for each of these active skills already chosen = 5 x 5 x 5 x 5 x 5 x 5 = 5^6
No. of ways of picking a passive skill for a choice of p = pC3. (p "Combination" 3)
Total No. of possible builds for each class, S = nC6 x 5^6 x pC3.
nC6 = n!/(6!(n-6)!) and pC3 = p!/(3!(p-3)!).
Now let's compute the no. of skills for each class individually.
Barbarian
# of active skills = n = 22
# of passive skills = p = 16
Therefore S = 22C6 x 5^6 x 16C3 = 652,863,750,000. (652 billion+)
Demon Hunter
# of active skills = n = 23
# of passive skills = p = 15
Therefore S = 23C6 x 5^6 x 15C3 = 717,670,078,125. (717 billion+)
Monk
# of active skills = n = 21
# of passive skills = p = 14
Therefore S = 21C6 x 5^6 x 14C3 = 308,626,500,000. (308 billion+)
Witch Doctor
# of active skills = n = 22
# of passive skills = p = 15
Therefore S = 22C6 x 5^6 x 15C3 = 530,451,796,875. (530 billion+)
Wizard
# of active skills = n = 25
# of passive skills = p = 15
Therefore S = 25C6 x 5^6 x 15C3 = 1,259,070,312,500. (1259 billion+)
Things to note
Wizard has the most no. of builds and Monk has the least. Wizard has more than 4 times the no. of builds as the Monk.Some interesting comparisons involving the no. of Monk builds since it has the lowest no. of builds.
► If every person in this world (~7 billion) plays Monk in D3, then it is possible to play in such a way such that every single person is playing with a different build.
► So if every single person in this world is playing Monk in D3 with a different build, it will still only cover 2.27% of the all the possible Monk builds.
► So will there be a time when it is certain that 2 people will have the same build?
Yes. Going by the present growth rate of world population (1.1%), the population of Earth will reach 310 billion in the year 2569. If every person in the world is still playing Monk in D3 at that time, then it is guaranteed that there will be atleast 2 people who have the same build
► How much time will it take me to test all the builds for Monk?
If you test a build each second, then it will take 9787 years to check all the 308billion+ builds for the the Monk.
Since checking builds every second isn't possible, so let's say you check a new build every 5 minutes. Then it will take 2.9+ million years to check every build for the Monk.
► And we haven't even touched the other 4 classes which have a lot more builds than the Monk.
http://us.battle.net/d3/en/forum/topic/4768346902