Warrior DPS Calculation Spreadsheet - Page 92

Alexxcri · 08/08/09, 7:36 AM

I think I've also found a problem with a item from Ulduar, I've been playing with the spread sheet and when I got to the shoulders, the ones from Auriaya25, Shoulderplates of the Eternal (not sure about the name) were a dps loss against the t7.5 shoulders although I was over 55% ArP on the spreadsheet and ironically the t8,5 shoulders would be a pretty big dps gain (about 50dps) to the t7.5 ones although they have almost the same stats as the ones from Auriya. With both those shoulders (the ilvl226 ones) I am over the hit cap and the soft armor pen cap the only difference would be the +6 crit rating gain from Shoulderplats of the Eternal so that should theoretically mean a dps gain, not a loss. I also put the same gem on both shoulders the only difference that one the t8.5 i hit the socket bonus but that is only 4str which should be more than compensated by the +6 crit from the other ones. Could someone shed some light why there's a more than 100dps difference between the two even though the difference should be more like 1-2dps? This is why I think there's a problem with Shoulderplates of the Eternal.

Daeid · 08/08/09, 7:49 AM

It might be that the T8.5 shoulders are activating the 4-piece set bonus when you equip them. That would account for the jump in dps.

Zxahn · 08/08/09, 1:49 PM

Originally Posted by talliara

After some searching I haven't come up with any relevant information. Would Banner of Victory and Grim Toll be a better combination than the Greatness card and Grim Toll?

Easy way to test this is to edit Mirror of Truth in the sheet to give ArP rather then crit, the proc is more or less identical.

With my gear setup it showed that full ArP gemming with Greatness and the Banner was slightly better then full str using GT and Greatness.

I also threw togther a quick ToC gear setup using the banner and managed to reach hit/exp cap and 100% ArP while using an axe while still wearing full plate. Could the banner be the new Shard of Contempt?

Krazen · 08/08/09, 4:18 PM

Originally Posted by Zxahn

Easy way to test this is to edit Mirror of Truth in the sheet to give ArP rather then crit, the proc is more or less identical.

With my gear setup it showed that full ArP gemming with Greatness and the Banner was slightly better then full str using GT and Greatness.

I also threw togther a quick ToC gear setup using the banner and managed to reach hit/exp cap and 100% ArP while using an axe while still wearing full plate. Could the banner be the new Shard of Contempt?

I have the same question:

I'm at 45% arp passive, plus battle stance. Grim toll puts me at 105% of so arp, so the proc is slightly wasted.

I'm only gemmed for str in all slots, so I cant lose any arp that way.

Gustu · 08/08/09, 10:40 PM

Hope to see the new sheet soon Landsoul, been itching to test all the new gear and combos. Threw something in the donation pot too, figured I'd at least pick up dinner while you're working so hard on the new spreadsheet.

nomopofomo · 08/09/09, 4:49 AM

I'm broke.

Thymoleon · 08/09/09, 6:38 AM

The link is broken. Filefront timeouts.

Alexxcri · 08/09/09, 8:47 AM

Originally Posted by Daeid

It might be that the T8.5 shoulders are activating the 4-piece set bonus when you equip them. That would account for the jump in dps.

I'm not sure but I think I was also swapping with another piece in the set so that even without the shoulders there would be the 4p tier bonus but as I said I'm not sure so it could also be as you say, I'm going to try this as soon as get the chance.

Jay14 · 08/09/09, 2:10 PM

Originally Posted by landsoul

Please be patient with this update. The amount of information I have to add is massive, and the checking and making sure stuff works is also very time consuming. On top of that, I am completely rebuilding the sheet from the ground up. Hopefully you can have it to try out by this weekend. You can only do one boss in the raid this week anyways, so just sit tight and relax.

Just wanted to say thanks. I rely on this sheet a lot and I'm sure you don't get much for the time you put into working on it. I look forward to the update as well. We appreciate you, Landsoul, even if we come across as ungrateful jerks sometimes.

Dalch · 08/10/09, 4:15 AM

Thanks Landsoul and all the guys doing the heavy duty here =p.
I play in a 10man only guild, and would like to ask if you guys, if possible of course, can make a "bis" list for the 10man versions of Ulduar and the new raid.
I have made my personal list, but i would like a more "mathematical" list, just to be sure if i made many wrong choices.

nomopofomo · 08/10/09, 5:27 AM

Originally Posted by Dalch

Thanks Landsoul and all the guys doing the heavy duty here =p.
I play in a 10man only guild, and would like to ask if you guys, if possible of course, can make a "bis" list for the 10man versions of Ulduar and the new raid.
I have made my personal list, but i would like a more "mathematical" list, just to be sure if i made many wrong choices.

Doesn't get any more "mathematical" than working on the spreadsheet and figuring that out yourself.

Eratix · 08/10/09, 8:03 AM

Landsoul - Thank you very much for your dedication and hard work to this ongoing project, keep being awesome!

Just a quick suggestion, however. Those they may be running Excel on an older computer may have a decent wait time for the SEP calculation. You can make this subroutine near-instant (on any machine) by adding:

Sub SEP()
'
' SEP Macro
' Calculates Strength Equivalency Points
'

'
    Application.ScreenUpdating = False
    
    range("Z41").Select
    Selection.Copy
    range("AM29").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

By including Application.ScreenUpdating = False, the workbook won't jump around and look fancy all over the place but I'm sure min/maxing your code is something you'd like to do as well!

proga · 08/10/09, 11:34 AM

You forgot to say that he should put Application.ScreenUpdating = True otherwise there will be some visual bugs.

StaxRexx · 08/10/09, 12:46 PM

Originally Posted by nomopofomo

Doesn't get any more "mathematical" than working on the spreadsheet and figuring that out yourself.

You took the words right out of my mouth.

I maintain my own list which currently revolves around 10man Ulduar, but I don't exclude the 25man bosses that can be pugged. Since we each have slightly different combinations of bosses that we're farming a BiS list for each scenario would just start to cause a lot of clutter. Add into the mix that 5man ToC has some nifty door prizes and 10man teams will probably at least try 10man ToC and that BiS list's ceiling becomes harder and harder to pick.

That being said I can't wait to see the new and improved sheet I've been punching new items into the now old one which is working just fine imo but all the updates and changes all sound pretty sweet. Even if color coding by faction is unneccesary it's still part of what sets Landsoul's sheet apart from all the others.

landsoul · 08/10/09, 3:01 PM

Yes I made a pass on all the macros and made the SEP run at least twice as fast as the one before. I used the select(cell).copy select(cell).pastespecial code. I'll checkout the non screen updating thing too and see if I like that or not.

As fas as other things are concerned, I am pretty close to finishing up everything in the next few days in my free time, so I would like to open the floor to any suggestions or wishes that anyone wants to be added in, so they can be put in now, or in the following update.