[Warrior] Fury DPS Spreadsheet for 2.4 - Page 5

issei · 03/23/08, 3:54 PM

Originally Posted by Joeblack

Is there a +hit cap factored into the spreadsheet? Testing around I was able to see that +hit gives more overall dps output than +strength at least as far as 333 hit (didn't test any further because that sounds ridiculous)

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.

Joeblack · 03/24/08, 12:19 AM

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

Ceral · 03/24/08, 2:33 AM

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.

Django · 03/24/08, 6:22 AM

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.

Bovino · 03/24/08, 9:43 AM

Originally Posted by Blodwarrior

My one question about slam spec is the rotation for when you are sitting on full rage bars with both WW and MS up.

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.

Joeblack · 03/24/08, 12:43 PM

Originally Posted by Ceral

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.

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.

Barmbul · 03/24/08, 12:56 PM

Originally Posted by Joeblack

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.

Also answered in this thread

Slayerfalcon · 03/24/08, 1:17 PM

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.

Django · 03/24/08, 1:24 PM

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.

Mahbi · 03/24/08, 3:16 PM

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:

9% Crit
69	Procs
1430	Hits
180	Crits
1610	Attacks
	
				
Hour	Min	Second	ms	
23	18	44	312	
24	23	32	390	
1	5	-12	78	Difference
64.8013	Minutes		
	
24.84518058	Attacks Per Min
				
% Chance				
4.285714286				
				
PPM				
1.064793453				

30% Crit
9	Procs		
			
151	Hits		
67	Crits		
218	Attacks		
13	0	58	859
13	9	24	15
0	9	-34	-844
8.419266667			
	
25.89299147	Attacks Per Min
	
% Chance	
4.128440367	
PPM	
1.068976712

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.

landsoul · 03/24/08, 3:43 PM

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!

Barmbul · 03/24/08, 5:14 PM

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?

landsoul · 03/24/08, 6:21 PM

make sure you look at the talents and buffs page. There are a lot of things that arent normal in a raid that I had included. I think the default has 2x BM hunter, enh shaman and draenaei ret pally

the 2x hunters give you a 100% + 3% x 2 damage factor alone
Ret pally gives you 3% crit 1% hit, 102% damage factor, and improved Might
Moonkin gives you 3% hit
Shaman can do toten twisting giving you windfury and agi totem
Feral druid can give you additional crit rating from a special Idol
Survival hunter (lol?) gives you a lot more AP through expose weakness and imp hunters mark
Make sure you take off things like human expertise and warglaive set bonus.

Like I said, really look through that talents and raid page and make sure that things are taken off that you don't get.

landsoul · 03/24/08, 8:21 PM

New version up.

Joeblack · 03/25/08, 8:06 AM

Originally Posted by landsoul

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!

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.

Barmbul · 03/25/08, 11:14 AM

Onslaught Battle helm missing 12 hit

landsoul · 03/25/08, 11:38 AM

[Onslaught Battle-Helm]?

You mean this?

Barmbul · 03/25/08, 11:44 AM

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

Machinator · 03/26/08, 3:33 PM

I put my gear in the new sheet and I get 50%+ uptimes for Mongoose or Executioner on the MH, which seems rather high. I think this is because you use the unmodified speed for proc chance rather than current speed. There was a whole bunch of testing done at Proc Per Minute Mechanics & Haste

Also adding expertise manually doesnt do anything.

landsoul · 03/26/08, 4:03 PM

Originally Posted by Machinator

I put my gear in the new sheet and I get 50%+ uptimes for Mongoose or Executioner on the MH, which seems rather high. I think this is because you use the unmodified speed for proc chance rather than current speed. There was a whole bunch of testing done at Proc Per Minute Mechanics & Haste

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

Originally Posted by Machinator

Also adding expertise manually doesnt do anything.

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 =(

Machinator · 03/26/08, 5:32 PM

Originally Posted by landsoul

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

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?

landsoul · 03/26/08, 8:31 PM

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!

WernerVonBraun · 03/26/08, 9:46 PM

Originally Posted by landsoul

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.

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.

DarkS · 03/27/08, 10:34 AM

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.