I'm not sure what kind of gear loadout you're entering into the spreadsheet, but going from my current gear and plugging in available upgrades from BT and Hyjal, as well as Sunwell items, 1 hit has never been >=1 str. If I add in a number like 50 to the manual stat addition section for hit, and continually increase it, hit's value further decreases. It seems to be working fine to me.

at around 140 hit rating im getting more overall dps from 8hit gems than 8str gems. I didn't use the manual thing to test it at 333hit rating, i just slapped 200hit into the Hit field on an item, recorded the number, hit Undo then did the same for strength.

edit: CONFIRMED. I loaded the default download from page one of this thread and changed a 10STR gem to a 10HIT gem and max dps went UP to 3390.xx !! WTF

You are simply forgetting to refresh the spreadsheet a few times after a change until the value stabilizes. Changing a 10Str to a 10hit drops the original setup to about 3380 for me. It's the same with your "trinket glitch". If you had read the thread you would have known that. Your battleshout question has also been answered.

Very nice spreadsheet landsoul, thanks.

Hi there,

wanted to report a minor bug. I use Fool's Bane in my Offhand on my Alt. In the Spreadsheet it yields a Weapon-DPS in J80 for Mainhand or J86 for Offhand. It's not listed in the IF-Clauses in the corresponding fields that are summed up. Additionally it get's no socket in fields A81 and A87 but it has a yellow socket, socket bonus is 3sta, so it doesn't matter for dps.

Since this occured, i did some mor testing for other weapons and came up with following weapons missing DPS (sometimes because of different spelling in dropdown and formula):
Mainhand: Warp-Storm Warblade, Talon of Anzu, Sunforged Cleaver, Ced's Carver, Guile of Khoraazi, Vindicator's Brand, Dirge, The Bladefist, Vileblade of the Betrayer, Drakefist Hammer, The Planar Edge, Emerald Ripper, Tracker's Blade, Shard of Azzinoth
Offhand: Dirge, Emerald Ripper

Additionally "Vindicator's Plate Greaves" are missing the Critrating and "Worgen Claw Necklace" (no capital "N") is missing it's AP

Very very nice spreadsheet, i really love it, especially sinse it's OO. Keep on the good work.

Assuming you don't need to refresh Demo Shout, Hamstring is your best bet in this situation. It can proc sword spec and trinkets, as well as refresh Flurry if it crits. Heroic Strike can be used if your next white swing is going to push you to 100 rage.

What is the best way to "refresh" the spreadsheet? F5 didn't do anything and "reload" wanted to revert the file to the last known save.

Simply switching from 8STR to 8HIT and back n forth over and over again appears to refresh values but its saying at in Kara/ZA or better gear @ 114 hit rating, that +hit is better than +str which I don't understand.

I've looked in the rings section and I noticed that you have several earlier rings, maybe I was just overlooking it but I couldn't find the Band of the Exorcist. If it is indeed not there is it possible to have that added.

HI, it's me again after playing around some more.

Found some more missing values:
Mainhand: Talon of Azshara missing AP
Offhand: Talon of Azshara missing Agi and AP

Those are, because of the Namechange to "Talon of Azshara (Unique)" in the Dropdown. Same thing with Shard of Azzinoth, Rod of the Sun King and some other Weapons which got the "(Unique)"-Addition.

Since I saw you were asking for some data about the Rod of the Sun King proc, I took mine to the blasted lands to try and get some data for you.

Wow Web Stats
About 65 minutes of auto attacking in tank gear with Rod on, not DWing.

Wow Web Stats
About 8 minutes of auto attacking in dps gear with Rod on, not DWing.

The difference is 9%ish crit in the longer one and 30%ish crit in the second. I assumed if it was ppm based it would be roughly the same with higher crit. And if it was a flat % base then with a crit increase, and therefore a longer uptime of flurry, a proc increase as well.

Rough calculations:

Granted the second report isnt really long enough to "prove" either way. Id lean toward the chance on hit being a 1 PPM proc. And the much higher parry in my tanking gear normalized the haste gain in flurry apparently.

Thanks for all of your input and support everyone, and the testing. There was a lot of typos I probably made and incorrect box referencing when I initially entered in all the data, and there are a few things I had overlooked.

On the next release I will fix all the missing stats on the items mentioned, and fix the listing DPS problem. Also look for a less confusing talents and buffs page, this seems to come up a lot. Also, I will leave the following versions saved on the intro page with the instructions in the front, so people will stop asking how to refresh and converge the data. I will also leave the sheet saved with best attainable BT gear (bar enchanting and JC) so people can see how much the new 2.4 gear will increase their numbers.

As of now I am continuing to investigate the drop down menus not automatically converging the DPS value, execute modeling, and analyzing the reliability of a MS/slam sheet.

The more response I can get the faster updates will come!

Quick question I have two pieces of BT gear and the dps output after entering all my loot shows around 2517 dps. Much higher than my current personal best of 1671 on Gorefiend and at least 1000 dps higher than any other sheet has shown. I looked at the sheet info to try and spot a red herring and noticed on the proc data tab the uptime for warglaives was showing 18.14%. I do not have the warglaives and they were not entered on the sheet. I also used the recalc option (Cntrl+ Shift+F9) until the sheet stopped updating.... any ideas on that?

New version up.

Not sure if this helps but, I noticed the errors in refreshing properly seem to occur the most when hit rating is involved. When just going between STR and Crit I didn't have those problems so maybe the error lies in the diminishing returns equation you use to calculate the benefits of Hit.

Onslaught Battle helm missing 12 hit

[Onslaught Battle-Helm]?

You mean this?

To F-ing early lol must have been wishful thinking
meant [Vengeful Gladiator's Plate Helm]

This is an easy fix, but I really wish those posts werent 6 months old.

Noted.

Next veriosn release will have a lot of number tweaks in it along with a Talents and Raid page rework. I am gonna try to impliment sperate expertises for different hands also. This version will take a while to put out, because I have to do each change 9 times due to SEP. Sorry =(

I dont think we have the resources to retest everything each patch, just spot check if someone thinks something changed. I would test it myself, but I dont have enough haste to be statistically significant.

OO doesnt have a macro type thing to do SEP without seperate sheets?

It does have macros, but I have no idea on how to work them, or the time to figure it out at the moment. If you could point me in the direction it would really help in cutting down on update time.

@@New Version Up!

You could put every SEP block on it's own page. That way you'll just have to edit once and can copy&paste the rest.

Reporting for sheet version 1.200:

[Fel-Steel Warhelm] miss 1 str and 4 crit rating. Shows 45 str instead 46 and 40 crit instead 44.

[Vindicator's Band of Triumph] miss 2 Armor Penetration. Shows 54 instead 56.

Hmmm... found that this only occurs on Ring 2 slot.

EDIT: It would be nice if [Legplates of Unending Fury] can be added on legs options. Thanks a lot!