Warrior DPS Calculation Spreadsheet - Page 102

MasterMace101 · 08/20/09, 5:35 PM

Originally Posted by Tibor

You have the ilvl 232 version, dropped from 10-man normal-mode. The version posted earlier is the ilvl 245 version dropped in 10-man heroic mode.

^This

There are several items that have the same name and different iLevels.

Ferboten · 08/21/09, 8:30 AM

Just want to point out for those using galindon's modified spreadsheet in the interim that cell Z29 in the arms sheet should be

=C66*(AH48*(1+AH34*AB62-AH31-AH39-AH41*AH42)*Z56/H56)

instead of

=C64*(AH48*(1+AH34*AB62-AH31-AH39-AH41*AH42)*Z56/H56)

otherwise it uses the wrong value for armor pen to determine white dps.

Kaubel · 08/21/09, 5:56 PM

When Landsoul has an updated version of his spreadsheet, he can PM a mod and we'll reopen this thread. Until then, you fucking retards can't be trusted to post here.

Kaubel · 09/01/09, 7:57 PM

Thread is open, but it's probably best if you wait for Landsoul to post his updates before you start asking questions. (That's only if you value your ability to post on our forums of course.)

landsoul · 09/01/09, 8:38 PM

Check the front page for the link. If you don't have 2007, well you are just gonna have to wait a little bit more beacause I have to go back and cut stuff out for 97 because it can't handle some of the cells.

zigzag · 09/01/09, 8:57 PM

Originally Posted by landsoul

Check the front page for the link. If you don't have 2007, well you are just gonna have to wait a little bit more beacause I have to go back and cut stuff out for 97 because it can't handle some of the cells.

The new look is great. Well worth the wait. Thanks for this.

Tkon · 09/01/09, 9:20 PM

Looks and works amazing, just one thing though. On the talents when you try to change say the sword or mace spec, the picture is becoming selected before the drop down menu. I just moved them to the side and could use the menu again. I'm not sure if this is only on my side as I'm using a newer version, either way just a heads up.

kruemelm0nst4 · 09/01/09, 10:02 PM

For some reason the 4pT8 Bonus reduces my dps in the Arms-Sheet by about 400dps.
And I also have the button Fetch Armory on my 3rd Belt socket.
The rest looks great!

Tyvi · 09/01/09, 10:17 PM

I have a problem getting the sheet to work and I am not sure if it just a problem on my end. When I open the sheet, it tells me it found unreadable content in the sheet and if I would like to restore it, to which I press Yes. I realize I my network card is somewhat wonky so I sometimes get corrupted files when downloading (large) files so just making sure it's not that. Am I the only one who gets that? (I downloaded the sheet 5 times now and it always give me the same message)

If not:
The sheet breaks down after I let it run SEP calculations without changing anything in the sheet at all. It gives the error message you'd get when you would not have iterative calculations set as instructed in the first page of the sheet (which I have done).

Also, Aesier's Edge seems to be missing from the Offhand selection.

PS: Thanks alot for your hard work, landsoul!

Bigbazz · 09/01/09, 11:28 PM

Firstly, thanks a lot for the sheet (and updates) its greatly appreciated.

All of the items from "Trial of the Champion - Heroic" that are in the sheet have thier previous ilvl213 stats, rather than the current ilvl219 stats. Obviously quite easy to change, but worth noting. Im just having my first play around and will edit this post if i find anymore errors.

I do appolagise if this isn't the place for error reports. but the first page didn't seem very clear.

Whitelion · 09/02/09, 12:09 AM

Hey Landsoul,

Thanks a TON! It was worth the wait. Everything works perfectly and the calculations are faster than EVER! Good job! I just have a small question, apparently we are getting more DPS from ArP gems than STR gems, which as a fury warrior is kind off weird due to the fact that we are getting that extra 10% from Imp. Zerk Stance. Not to mention raid buff's that increase the attribute of STR even more. By the time you get Mjolnir Runestone, you should really only need about 30% Arp Pen to hit a possible 100% armor reduction. I guess the buffer doesn't hurt, but, seems like a waste. Can you explain? Thanks!

Whitelion · 09/02/09, 12:12 AM

Yeah, I thought the SEP points we're calculated wrong. Can you explain please. I had to edit this message, but I noticed you are fully loaded with ArpPen so im thinking there is a reason for it.

catch22atplay · 09/02/09, 12:41 AM

It's easy. Get rid of your ArP trinket and grab some great gear. Gem ArP in every socket. This includes yellow sockets. Ignore socket bonuses. Granted you may not be able to do this right away. But as an example i loaded up some gear and came out with a quick BIS list that was 9,865 dps. All plate i might add. Using 250ms reaction time and 200ms latency. ArP was 1096 (96 short of the cap) and the SEP for arp was 1.5030 That's fairly insane for fury. Swapping from zerker to executioner on mainhand and swapping 1 20 arp gem to 1 20 str gem increased dps to 9,887 as well.

Bluefish · 09/02/09, 12:55 AM

I'm intrigued by the strong value of the clicky on [Incisor Fragment]. The rankings sheet lists it over both my current trinkets (Greatness and Banner), but equipping it over either is a DPS loss. I do see, though, that the value of the clicky is being averaged in rather than used all at once. I was wondering if the self-scaling of ArP, plus the fact that I'd always use it with Death Wish, could push its value higher than the sheet would suggest. To test, I took my point out of Death Wish in the sheet and modeled it manually. My Warrior is pretty typical: 374 ArP from cap, hit capped, almost Expertise capped. With one trinket slot empty and no Death Wish, the sheet says he does 5275 DPS, so I'll use that as the baseline.

Trinket	Passive DPS	DW DPS	DW + Proc DPS	*Sum(Values Uptimes) = Total DPS**
Banner	+145	+1277	+2050	(2050 * 0.083) + (1277 * 0.166) + (145 * 0.751) + 165 = 656.027
Banner NoDWProc	+145	+1277	--	(1277 * 0.249) + (145 * 0.751) + 205 = 631.868
Fragment	+93	+1214	+1874	(1874 * 0.166) + (1214 * 0.083) + (93 * 0.751) = 481.689

* The additions in the last calculations for the Banner account for DPS from procs outside of Death Wish (117 AP 75% of the time and 201 AP 75% of the time, respectively).

Conclusion: Ignore the sorting bug in the spreadsheet, [Incisor Fragment] is not better than [Banner of Victory].

Jordybe · 09/02/09, 2:27 AM

Nice work landsoul!!

Found 2 things in the arms page.

I filled all my gear by hand. Because im at work and getting stuff from the armory isn't working because the firewall etc.
But I filled all by hand. Pressed the button for SEP calculation and got no error. But my DPS is gone.
See screenshot: http://img259.imageshack.us/img259/4151/landsoul.jpg (Office 2007 Dutch version)
Also on the screenshot you see the words "Fetch Armory" in the 3th socket of my belt. Kinda strange place I think.

And im missing 2 items:
Etched Band of the Kirin Tor
Etched Ring of the Kirin Tor

They are the improved versions of the inscribed band/ring of the kirin tor