Warrior DPS Calculation Spreadsheet - Page 106

Coeus · 09/03/09, 6:59 AM

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.

Roshi · 09/03/09, 7:19 AM

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

Jordybe · 09/03/09, 8:01 AM

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.

Orehor · 09/03/09, 8:48 AM

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

Catmax · 09/03/09, 9:51 AM

Getting the #VALUE error, too after running the SEP-Macro.

Any way to fix this?

Speeder · 09/03/09, 9:59 AM

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.

samot · 09/03/09, 11:19 AM

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

Latham · 09/03/09, 11:37 AM

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?

Graussbaf · 09/03/09, 12:13 PM

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 !

PantheraOnca · 09/03/09, 2:10 PM

Two things:

1) Cell H126 ("use exe if MS more than <h126> sec") is a negative number.
2) This results in a "####" in cell f46 ("-Don't use execute passed <f46> 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.

suffer · 09/03/09, 3:34 PM

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]

gab · 09/03/09, 7:18 PM

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

SirMoleman · 09/03/09, 8:00 PM

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.

nomopofomo · 09/03/09, 8:44 PM

Has anyone modeled the ArP changes happening on the PTR in the spreadsheet yet?

phantomlink · 09/03/09, 9:52 PM

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