Im looking for a monk gear and dps sheet comparison, the one I found only wanted to get the stat totals and has no gear compare feature like what the wizards sheet has.
I have a spreadsheet that kind of does the job, you have to enter old/new item stats in separate boxes and use that to compare them. It's a bit inconvenient if you are looking at different gear slots at the same time, but it has a great comparison tool for weapons: https://docs.google....IydmNFRWc#gid=6
The 5 weapon compare is good, how about if I wanted to compare rings/amulets?
Ok so I grabbed the files, it open opens under protected view with Excel and shows some errors and stuff ~_~
After some fiddling around I've finally gotten almost close to my DPS screen values but the calc is still reporting higher.. by about 1k+ with dual wielding due to my off hand weapon having a 1.55 attack speed ( 1.40 base and +11% bonus.)
I dont have the follower with me, I've been able to trace down the mistake is caused by the 11% attack speed bonus that my weapon has, If I equip my offhand with a basic 1.20 attack speed weapon the DPS display is 99.99% accurate.
Make sure that you're accounting for followers and that your rings/amulet doesn't have bugged min-max dmg such as when your min and max dmg on an item is equal or min>max . For example a ring can have both 21-42 dmg and + 21 dmg, this would be 42-42 dmg and would not display the number on the item but it will however still calculate it. The game will only display the 21-42 dmg and you be left saying wtf trying to figure out where you got that extra 600 dps or w/e.
No, I don't think you can get it down to the dot, at least not with this spreadsheet. There seem to be a few rounding errors.
How did you get your crit chance to 42? I thought 39 was max without a shield? Scoundrel?
5.5 from helm (6Max)
10 from Gloves (Max)
3.5 from ring (4.5Max)
4.5 from the to other ring (Max)
5.0 from the bracers (6Max)
8.5 from the amulet (Max)
5% Base
you can get another 10 from a shield and another 3 with a scoundrel, my SS does not include the scoundrel.
If you have issues and wear + dmg gear, do keep in mind that sometimes the display on said items bug and it might say 18-42 but it's really 42-42 or 43-42.
The game won't display when the min = or >max dmg however it still accounts for it in your DPS.
The 5 weapon compare is good, how about if I wanted to compare rings/amulets?
After some fiddling around I've finally gotten almost close to my DPS screen values but the calc is still reporting higher.. by about 1k+ with dual wielding due to my off hand weapon having a 1.55 attack speed ( 1.40 base and +11% bonus.)
The rings I have only give a single range fixed damage boost. 7-14 and 22-40.
I've double checked everything and its still off!
If I do no dual wield then the result is accurate to 0.01 decimal!
Right now since Im back to a slower weapon, DW-ing the calc gives me 45,617,24 while ingame it gives me 45,596.54
Its more accurate with a slower dual wielded weapon.
Yes, weapons tab. Like I've said if I use a weapon that has no +attack speed I get 99.99% accurate results.
I'll post a screenshot of my stats later with my items and try it on your end.
1535 with out weapons equipped
1.09 Atk speed w/o weapons
42%Crit chance
113% Crit damage
22 min
40 max
The axe has a +10% attack speed which is also factored in under the damage tab
Im also using a ring with 9% attack speed.
Damage tab shows 45,981.72 vs 45960.85
The discrepancy is a lot lower now that I've change my other ring ( reduced damage but higher attack speed )
Would it be possible to get the damage down to the dot?
5.5 from helm (6Max)
10 from Gloves (Max)
3.5 from ring (4.5Max)
4.5 from the to other ring (Max)
5.0 from the bracers (6Max)
8.5 from the amulet (Max)
5% Base
you can get another 10 from a shield and another 3 with a scoundrel, my SS does not include the scoundrel.
62.5% is the max if im not mistaken.
Not without knowing the exact number of decimals blizzard uses.
My spreadsheet is accurate within 5-10.
Link: https://docs.google.com/spreadsheet/ccc?key=0Aj4vym4NBukidDg1VDdRTTRMemppOUZhbFZWTGlWaHc#gid=1
If you have issues and wear + dmg gear, do keep in mind that sometimes the display on said items bug and it might say 18-42 but it's really 42-42 or 43-42.
The game won't display when the min = or >max dmg however it still accounts for it in your DPS.
5% base
10% gloves
8.5% neck
9% rings (4.5% each)
6% bracers
6% helm
= 44.5%
You can also lose 1 % crit on a rings pick up a 3.5% Nat's Mark and Nats Soul for 7% more crit.
= 50.5 % crit.
Add a shield to make it 60.5