Elitist Jerks Warrior DPS Calculation Spreadsheet

09/03/09, 6:59 AM   #1576
Coeus
Von Kaiser

Kilrogg
 Originally Posted by halton Has anyone adapted the new spreadsheet to take the upcoming sword spec change into consideration?
Change W67 to:
`=MAX(MIN(0.5,((1/X55+IF(IF(ISNA(VLOOKUP(C16,MainLookup,15,FALSE)),0,VLOOKUP(C16,MainLookup,15,FALSE))="Sword",IF(AO15=0,0,1/(6+1/(AO15/50*Y174))),0))*(Y59*AE57+AE58*(1-F52-F56-Y59)+F56*AE61)-AE69-AE70-AE71-AE72-AE74)/(15-AO4-AR15+AI57)*X55/2)+J34/AC52-W73,0)`
Change Y68 to:
`=Y67*1/X55+IF(IF(ISNA(VLOOKUP(C16,MainLookup,15,FALSE)),0,VLOOKUP(C16,MainLookup,15,FALSE))="Sword",IF(AO15=0,0,1/(6+1/(AO15/50*Y174))),0)`
Really, what you're doing is changing AO15 references to (AO15*2), but since you're dividing by 100 after that, I just changed it to divide by 50 to do 1 less calculation (not sure if Excel optimizes that on its own or not, I assume not).

*Edit* This is on the ARMS sheet. I haven't done the Fury sheet since no one takes weapon specs as Fury.

 09/03/09, 7:19 AM #1577 Roshi Glass Joe   Roshi Troll Rogue   Taerar (EU) Page: FURY Error Type: REFERENCE After importing my Character pressing "Calculate SEP" leads to scatterd #VALUE errors all around the Spreadsheet, mainly in fields having something to do with ARP. Here is my file with character import: Tseng.xlsm
 09/03/09, 8:01 AM #1578 Jordybe Glass Joe   Jordybe Night Elf Warrior   Twisting Nether (EU) Page: Arms I changed glyph of mortal strike to glyph of heroic strike and I got like +300DPS... I don't think that is correct.
 09/03/09, 8:48 AM #1579 Orehor Glass Joe   Orehor Troll Warrior   Doomhammer Ok I have to ask, I noticed the expertise on the Arms list to be extreamly low....do we not care about the cap anymore? I ask cause I got Legplates of the Redeemed Blood Knight that I could use to replace my 8.5 legs but I go way under the expertise cap
 09/03/09, 9:51 AM #1580 Catmax Glass Joe   Frazz Tauren Warrior   Non-US/EU Server (EU) Getting the #VALUE error, too after running the SEP-Macro. Any way to fix this?
09/03/09, 9:59 AM   #1581
Speeder
Piston Honda

Orc Warrior

Burning Legion (EU)
 Originally Posted by Orehor Ok I have to ask, I noticed the expertise on the Arms list to be extreamly low....do we not care about the cap anymore? I ask cause I got Legplates of the Redeemed Blood Knight that I could use to replace my 8.5 legs but I go way under the expertise cap
I guess Arms values exp lower since dodges proc overpower + overpower (which should be a good amount of your damage due to taste of blodd procs) cannot be dodged.

peace MK

 09/03/09, 11:19 AM #1582 samot Von Kaiser     Gerta Goblin Warrior   Nethersturm (EU) I found a quick and dirty solution for the #VALUE problem by runnig SEP. - Open the VBA macro editor by pressing Alt-F11 - go into Module7 (it contains the Sub SEP() as first function) - search for the comment 'MHSpd and comment out all its lines by adding a ' before it - search for the comment 'OHSpd and comment out all its lines by adding a ' before it - Save and run SEP I don't know, what exactly it does and how it effects the result, but because the most weapons have a similar speed (3.3 in the most cases), the result should be good enought. ```'MHRng range("E101").FormulaR1C1 = _ "=R[0]C[-2]" range("E91").Copy range("F101").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False range("E101").FormulaR1C1 = _ "=0" 'MHSpd ' range("E102").FormulaR1C1 = _ "=R[0]C[-2]" ' range("E91").Copy ' range("F102").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ' Application.CutCopyMode = False ' range("E102").FormulaR1C1 = _ "=0" 'OHRng range("E103").FormulaR1C1 = _ "=R[0]C[-2]" range("E91").Copy range("F103").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False range("E103").FormulaR1C1 = _ "=0" 'OHSpd ' range("E104").FormulaR1C1 = _ "=R[0]C[-2]" ' range("E91").Copy ' range("F104").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ' Application.CutCopyMode = False ' range("E104").FormulaR1C1 = _ "=0" 'SEP=?DPS range("g89").Copy range("f23").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False``` @Landsoul: you should add a "none" line to T219, otherwise you would get an #N/A at Y17 (if you choose "none" as trinket) best regards Thomas
 09/03/09, 11:37 AM #1583 Latham Von Kaiser   Latham Human Warrior   Tichondrius Will you put a date next to the link like you were doing on previous versions so we know if there were any updates made?
 09/03/09, 12:13 PM #1584 Graussbaf Glass Joe   Graussbaf Tauren Warrior   Chants Eternels (EU) I am not 100% sure what I am reporting here is a bug, but it seems weird enough to be worth reporting. In the arms page, after importing my gear, I loose about 400dps by changing my T7.5 legs in favor of T9.5 legs. In the process I do sacrifice my T7 2p bonus, but in no way that bonus can be worth THAT much dps in my opinion. Same thing happens when I replace my T7.5 shoulders by T9.5. By the way, awesome work you made here Landsoul, thanks a lot !
 09/03/09, 2:10 PM #1585 PantheraOnca Glass Joe   Aggramnannon Human Warrior   Daggerspine Two things: 1) Cell H126 ("use exe if MS more than sec") is a negative number. 2) This results in a "####" in cell f46 ("-Don't use execute passed seconds remaining on MS."). Does this mean that I should prioritize execute over MS regardless of timing? Would it be possible to rework the statement so that the #### doesn't show up? Thanks for the new spreadsheet.
09/03/09, 3:34 PM   #1586
suffer
Von Kaiser

Tauren Warrior

Eredar
I've been wanting to find a non-hardmode/heroic BiS item list. I thought I would take a shot at creating one since my guild generally doesn't do hardmodes.

I'm not sure this is totally correct, or how to tell other than by trial and error. Any input on how to go about this is appreciated.

Anyway, my first try at a non-heroic Fury BiS list (using 4 piece T9).

DPS 8320

Unbuffed Stats:
AP = 5598
Crit = 42.38
ArP = 46.77
Haste = 5.73
Hit = 177
Exp = 24

 [Hellscream's Helmet of Triumph] [Charge of the Eredar] [Hellscream's Shoulderplates of Triumph] [Cloak of the Untamed Predator] [Hellscream's Battleplate of Triumph] [Titanium Spikeguards] [Dual-blade Butcher] : X2 [Gauntlets of Bitter Reprisal] [Bloodbath Girdle] [Hellscream's Legplates of Triumph] [Melancholy Sabatons] [Dexterous Brightstone Ring] [Band of Callous Aggression] [Grim Toll] [Death's Choice] [Crimson Star]

Last edited by suffer : 09/03/09 at 3:49 PM.

 09/03/09, 7:18 PM #1587 gab Glass Joe   Gabilein Orc Warrior   Destromath (EU) help Perhaps i missed that one but i have some kinda problems with the new version. Well i am orc though so everytime i change race from anything to orc my dps drops like 4000 and all values of nearly everything is gone. So if anybody can help me.... btw thanks again landsoul for all your hard work..cant be said often enough
 09/03/09, 8:00 PM #1588 SirMoleman Glass Joe   Choc Orc Warrior   Blade's Edge (EU) Does the spreadsheet inlcude racials? Cos it doesnt seem to include my orc expertise rating when i use an axe instead of a polearm. If it does where about is it so i can change it? Cheers. Oh and thanks Landsoul for making a brilliant spreadsheet.
 09/03/09, 8:44 PM #1589 nomopofomo Glass Joe   Bwe Tauren Warrior   Lightbringer Has anyone modeled the ArP changes happening on the PTR in the spreadsheet yet?
09/03/09, 9:52 PM   #1590
Glass Joe

Orc Warrior

Maelstrom
 Originally Posted by nomopofomo Has anyone modeled the ArP changes happening on the PTR in the spreadsheet yet?
What changes? Theres nothing on the PTR patchnotes for 3.2.2 regarding ArP changes

 Elitist Jerks Warrior DPS Calculation Spreadsheet