I was a big fan of the OpenOffice spreadsheet in BC, so I thought it was about time to get the new Excel version and start planning out my warrior's gear. However, after inputting all my current gear, the dps calculation has changed to "N/A". Likewise the SEP calculations, after I click on the green button, also all change to "N/A".
Obviously I'm doing something wrong. Could someone enlighten me? I'd love to start using this spreadsheet, but I have a feeling my inexperience with Excel may be getting in the way...
A lot of the time that this happens, it's due to a bug in the vlookup tables that's been reported already. I had this issue frequently as well, due to a few enchant selections bugging out.
If you're afraid of editing your file yourself, just wait for the new release and don't change the enchants. Otherwise, I expect that those issues will be fixed in the new release.
I have entered an equip with 123 expertise rating - the cap with 2/2 Weapon mastery is 148, so expertise should be valuable at that point.
The SEP values on the top even show expertise as being worth 1,2227 Strength. However, if i change a 16 STR gem with an 16 EXP gem my overall DPS value goes down. Is this a bug or am i missing something?
Btw. I can post Gnome Warrior 80 stats later this day if you still need it.
To make it clear - to reproduce the "bug" you need to exchange 1x 16STR gem with 1x 16EXP gem in the first file.
Although the expertise cap is not reached and expertise is worth 1,2 points of str the change decreases dps.
I have adjusted an equip with 140Expertise Rating. Then i raised my expertise rating to 150 through a gem and checked my dps value again. But nothing happened, i checked everything but couldnt find the reason for it. This only appears with expertise ratings above 100. Perhaps im missing something? Through Gear i have 140expertise, there are no Racials nor buffs which increase my expertise. But the main bar says that Expertise Value is 0. Surely im missing something, but i cant imagine what.
Additionally the entered expertise value for Zeliek`s Gauntlets is wrong. They only have 43 expertise, not 53.
But thanks for your good work on this, things like that really help alot when chosing gear.
Playing with the new sheet, seems to be a bug with Darkmoon Card: Greatness (should be 90 STR instead of 90 AP, and needs a PROC entry).
Also a question about 3.0.8 hit cap. Does the spreadsheet take into account the possible rage starvation issues at all? Running with 5-6% hit seems like it would have a much higher chance of running into situations where you get a series of white misses and can't do anything much at all.
Yes that is true, and it probably would help with differentiating a bit, but I have not come across a reasonable model that I can use yet. It's been an issue brought up a few times and I do plan on addressing it.
I only need gnome HP now, I have everything else, but if you want to post those that is fine, I need to verify it I guess.
I figured out what was wrong with the expertise. Its inside an INT() function which means that if the conversion rate doesnt click it over another .25% it doesnt count the full DPS. Your 16 exp gem is doing what an 12 exp gem and a 14 exp gem would also do. Working as intended, just gotta keep that in mind.
(0.2/3*V23) = chance check
B70*(1+0.1*B57)*(1+0.02*V24)*(1-I66-I73+L89*I70)*(O64+P62*IF(B29=80,250,140)*P64) = average bloodsurge damage
which leaves (3*(1-I66-I73)+7*L65)/10 for the numbers of attacks made per second of which Bloodsurge can proc,
because bloodsurge dps would be (chance to proc)*(attacks per second of which bloodsurge can proc)*(average damage dealt by Bloodsurge)
but that line says : (3*(1-(yellow miss chance)-(dodge chance on MH)+7*(heroic strikes landed per second)) / 10
I dont see how that includes the procchance from Heroic strikes, Whirlwinds and BLoodthirsts.
sorry if I am just not seeing the obvious.
If I am wrong and you have some time i would be much obliged if you could explain it to me
second thing I thought was that the average rage cost of a heroic strike would have to rise by 3 (15*0.2) because every Bloodsurge proc of a heroic strike decreases the rage available for heroic strikes equaling less overall heroic strikes.
Please excuse my english. I'm from germany and its damn early too.
Right. (3*(1-I66-I73)+7*L65)/10 came from an older 10 second DPS period that I am changing now in the advent of the 8 second WW glyph. I'm changing it to a more complicated model in a 16 second period that takes into account combining percentage chances of Slam! and when it is up in relation to heroic, BT, and WW. You can see the new rotation table by scrolling all the way down to the 170's on the Set1 page.