Warrior DPS Calculation Spreadsheet - Page 41

Grayson Carlyle · 05/28/09, 3:03 AM

Originally Posted by msflynn42

I noticed that [Fluxing Energy Coils] were not in the spreadsheet as an option when they dropped in our recent XT-002 10 man hard mode kill. They seem viable, I'd like to see how they stack against other options.

They are in fact in the sheet, but they're mislabeled as Bracers of Lost Sentiments, resulting in 2 entries for BoLS. Flux Energy Coils are BiS for many setups.

badscooter · 05/28/09, 5:29 AM

Originally Posted by jpcesar

badscooter, are you at work or something? you are perhaps running behind a proxy to get internet access.

that specific line is going to get the data from armory about your char, and sadly excel does not use the default proxy from IE to get data, so perhaps you should try on other computer with direct internet access.

cheers

I am actually at home right now trying this on a computer with direct internet access... And it has worked before so im a bit surprised it doesnt work now. Any other ideas?

Cheers

jwilley · 05/28/09, 12:16 PM

I have the most recent SS, it goes out and finds my toon and is unable to import many of the items I have equipped.
I can understand that, but these items are all listed in the "lookup" page of the SS.

I would really love to make better use of this, and I am SURE you've answered this one a hundred times, but I am hoping for at minimum a direction to how to locate the info I need.

Again: all (or most) of my items are listed on the lookup page, but when I load my character it lists much of my gear as "must install as custom". Shouldn't it find the gear from the lookup page?

Thanks very much,
Ister, Sen'Jin All.
(John

Phatha · 05/29/09, 4:09 AM

Looks like a new option for the belt is Starfall Girdle. Lose a lot of crit but the same expertise values and it's plate too so you won't be competing with rogues, etc.

Also, these seem like a decent upgrade to the Conqueror Siegebreaker shoulders: Shoulderplates of the Celestial Watch. Certainly seem better itemized. Now it's just a question of the value of losing the set bonus or picking up the Siegebreaker Legplates.

samot · 05/29/09, 8:54 AM

I guess, that only a few people knows, which gem has which color, so I used formating coditions to color the used gems.

Just run the following macro (using Alt-F11 to open the VBA-Editor, paste the makro and run it by pressing F5 or clicking onto the run-icon at the toolbar):

Sub ColorGems()
Dim arrSocketNames(1 To 8)
Dim arrBackColors(1 To 8)
Dim i           As Long
Dim varSheet    As Variant
    
    arrSocketNames(1) = "R":     arrBackColors(1) = RGB(128, 0, 0)
    arrSocketNames(2) = "O":     arrBackColors(2) = RGB(255, 153, 0)
    arrSocketNames(3) = "Y":     arrBackColors(3) = RGB(142, 125, 0)
    arrSocketNames(4) = "G":     arrBackColors(4) = RGB(0, 128, 0)
    arrSocketNames(5) = "B":     arrBackColors(5) = RGB(0, 32, 96)
    arrSocketNames(6) = "P":     arrBackColors(6) = RGB(112, 48, 160)
    arrSocketNames(7) = "PRIS":  arrBackColors(7) = RGB(128, 128, 128)
    arrSocketNames(8) = "M":     arrBackColors(8) = RGB(90, 90, 90)

    ActiveWorkbook.Names.Add Name:="GEM_compl", RefersToR1C1:= _
        "=Lookup!R55C185:R122C197"
    
    For Each varSheet In Array("Fury", "Arms")
        Sheets(varSheet).Select
        range("K6,O6,K7,N7,K8,O8,K9,N7,K10,K11,K12,K13,K14,K15,K16,K17,K18,K19,K20,K21,O10,O12,O14,O16,O18,O20,AB6,AB7,AF6,AB8,AF8,AB9,AB10,AF10,AB11,AB12,AF12,AB14,AB16,AB20").Select
        For i = 1 To 8
            With Selection
                .FormatConditions.Add Type:=xlExpression, Formula1:= _
                    "=SVERWEIS(K6;GEM_compl;12;FALSCH)=""" & arrSocketNames(i) & """"
                j = .FormatConditions.count
    
                .FormatConditions(.FormatConditions.count).SetFirstPriority
                .FormatConditions(1).Interior.Color = arrBackColors(i)
                .FormatConditions(1).StopIfTrue = True
            End With
        Next i
        range("k6").Select
    Next varSheet
    
End Sub

@Landsoul: it would be nice, if you would run this macro too, before uploading the next version...

best regards
Thomas

PS: works only for Excel 2007, because the older versions supports only 3 formating conditions (and one is already used for "None").

catch22atplay · 05/29/09, 9:11 AM

Well having BT lowered by 1 second wasn't the answer i was wanting for buffing fury. Still hate the idea of base weapon damage being 90%. But at least now after how many years Ww and BT will finally not clip each other. So i do like this change for that. This should make nice increase to BT dps and a small increase to Ww dps.

For rage generation i'm glad this is finally cleared up. I think i owe quite a few rounds of Starbucks. Finally this spreadsheet will be a lot more closer to accurate. I just wonder after Landsoul's post on the WoW forums if they'll fix rage generation. With the proposed changes to BT with 20 rage instead of 30 i could think of 2 possibilities. 1) They fix rage but raise BT to 30 rage. 2) Leave rage the way it is and go with proposed changes of 20 rage for BT. I sincerely hope they change rage and do the proposed BT at 20 rage. Making sure we have enough rage to interrupt the general is a huge dps loss. Fury just absolutely sucks on that boss even if you aren't interrupting.

Anyways great job figuring it out. I would suggest rage be tested next patch in case it is changed without us knowing. Maybe even after every patch in the future. Or at least when we notice discrepancies as we recently did. And always question what you think is wrong. Even if you're questioning or assumptions are wrong. Someone is bound to come up with the right answer.

Tutankhamon81 · 05/29/09, 2:57 PM

Quick update for the spreadsheet as I've just read it on the forums.

Rage generation's value of the constant c is now 453.3, and not the previous value of 320.6.

catch22atplay · 05/29/09, 5:15 PM

Ya saw that. Can i say woot? Not sure i'm happy with the answer. I was really hoping it needed to be fixed on Blizzards end. Oh well at least now we have an accurate formula to work with. So overall i'm satisfied. Wish i had more rage though. Whacking on that general for minimal dps is embarrassing.

Machinator · 05/29/09, 8:14 PM

Link to the relevant blue post on rage gen here.

Originally Posted by catch22atplay

But at least now after how many years Ww and BT will finally not clip each other. So i do like this change for that. This should make nice increase to BT dps and a small increase to Ww dps.

But they will clip each other? or you will clip slams? Either way you will end up clipping something so I'm not quite sure how much of a dps increase this will end up being. I am trying to make something to put different rotations in the sheet and the clipping is nuts.

Tallanor · 05/29/09, 11:20 PM

Here is the best non hard mode plate only BIS (Fury) I could calculate for a non JC (with BS though). The following list gets me 6019 dps on the spreadsheet (v2.405):

Head: [Conqueror's Siegebreaker Helmet] with +21 agi/3% crit, 16 exp gems
Neck: [Favor of the Dragon Queen] with 16 ArP gem
Shoulders: [Shoulderplates of the Eternal] with 16 Str gem
Back: [Drape of the Drakerider]
Chest: [Conqueror's Siegebreaker Battleplate] with 2x16 Str gems
Wrists: [Decimator's Armguards] with 16 Str gem
Gloves: [Conqueror's Siegebreaker Gauntlets] 2x16 Str gems
Waist: [Girdle of Embers] with 16 Str gem
Legs: [Conqueror's Siegebreaker Legplates] with 8 str/8 crit, 8 Arp/12 Stam gems (for meta req)
Feet: [Melancholy Sabatons]

Ring: [Sif's Promise]
Ring: [Godbane Signet]

Trinket: [Grim Toll]
Trinket: [Darkmoon Card: Greatness]

Main Hand: [Stormrune Edge]
Off Hand: [Stormrune Edge]
Ranged: [Giant's Bane]

Has anyone come up with a better non hard mode set for a non JC? I know I can up the dps a bit by using some non plate pieces, but I'd like to keep it to all plate if possible.

marodeur · 05/30/09, 7:58 AM

Originally Posted by marodeur

Hello,

how did u validate the Rage Conversion Value (320.6) because i think that value inst near the real value. i testet it ingame, with a c=320.6 i should get ~16 rage but i only get 12 when im hitting for ~850. so i think the c is more like ~500.

i tried that with 1 and 2hand weapons and with and without endless rage, same conclusion 320.6 didnt work for me using the formular from that blizzard blue post for rage gen.

MMO-Champion BlueTracker - Newly Discovered Rage Ghost Nerf Unveiled!

In the formulas people are using, there is a constant value which is labeled as ‘c’. At some point in the past, someone calculated a formula for determining c based on their level and that formula is not correct past level 70 as this value needs retuning from time to time like when a new expansion comes out. The value listed for c is 320.6 when it is actually 453.3.

well last time i postet this i got banned lol, nice to see that i was right.

catch22atplay · 05/30/09, 3:01 PM

Tallanor, Rune Edge are hard mode.

Marodeaur, i figured i'd be banned weeks ago. To EJ's credit i was not. Even when i was clearly wrong i was still allowed to question things. That to me seems right and i thank them for putting up with me. I seriously doubt we'd be where we are right now without me and others doing so and without them letting us do so.

Pilkington · 05/30/09, 3:08 PM

Originally Posted by catch22atplay

Tallanor, Rune Edge are hard mode.

Na, it drops off 25 man Iron Council, non hard mode. Armory me once its back up, ive got Rune Edge and don't have the hard mode achievement.

Lokdar · 05/30/09, 3:09 PM

Rune Edge is normal mode in 25 man IC, my friend. I think you are mistaking Aesir's Edge from Deconstructer Hard Mode which is better then Rune Edge. I have a similiar setup to you Tallanor, but I have one hard-mode item, the trinket from 10 man Thorim, it's probably one of the easier hard-mode encounters to do. I probably need to balance my gems out better though.

Head
Conqueror's Siegebreaker Helmet
gem 1: Chaotic Skyflare Diamond
gem 2: Fractured Scarlet Ruby
enchant : +50 Attack Power and +20 Critical Strike Rating
Neck
Favor of the Dragon Queen
gem 1: Fractured Dragon's Eye
Shoulders
Valorous Dreadnaught Shoulderplates
gem 1: Fractured Dragon's Eye
enchant : +40 Attack Power and +15 Crit Rating
Chest
Conqueror's Siegebreaker Battleplate
gem 1: Fractured Scarlet Ruby
gem 2: Fractured Dragon's Eye
enchant : +10 All Stats
Waist
Girdle of Embers
gem 1: Fractured Scarlet Ruby
Legs
Conqueror's Siegebreaker Legplates
gem 1: Fractured Scarlet Ruby
gem 2: Fractured Scarlet Ruby
enchant : +75 Attack Power and +22 Critical Strike Rating
Feet
Melancholy Sabatons
enchant : +12 Hit Rating and +12 Critical Strike Rating
Wrist
Decimator's Armguards
gem 1: Fractured Scarlet Ruby
enchant : +50 Attack Power
Hands
Conqueror's Siegebreaker Gauntlets
gem 1: Fractured Scarlet Ruby
gem 2: Fractured Scarlet Ruby
enchant : +15 Expertise Rating
Back
Drape of the Drakerider
enchant : +23 Haste Rating
Ring
Strength of the Automaton
Ring #2
Cindershard Ring
Trinket
Mjolinir's Runestone
Trinket #2
Darkmoon Card: Greatness
Main Hand
Rune Edge
enchant : Berserking
Off Hand
Worldcarver
enchant : Berserking
Ranged
Giant's Bane

catch22atplay · 05/30/09, 3:15 PM

Originally Posted by Pilkington

Na, it drops off 25 man Iron Council, non hard mode. Armory me once its back up, ive got Rune Edge and don't have the hard mode achievement.

Damnit why the hell doesn't it drop then.

Oh btw i lost 255dps with rage at 75%. HS use at 67% now. That looks so much closer to ingame results. 5432dps. I may finally shut up after the new changes are applied.

MikHaven · 05/30/09, 6:49 PM

Originally Posted by marodeur

MMO-Champion BlueTracker - Newly Discovered Rage Ghost Nerf Unveiled!
well last time i postet this i got banned lol, nice to see that i was right.

I know your feelings on this Landsoul, but can we sneak a beta version on the new changes soon. I know you like to see how it goes on the PTR, and even wait till it hits some live version and you can test it first, but these changes seem like they are big enough, I'm really curious how they will affect the sheet. Keep up the good work, should link your post was hard to find.

Side comment, I think GC was in complete BS, when he referenced your post as nothing but bumps for comments it was the best warrior post I've seen from a non-blue in a long time. Thanks for your insight and considable weight towards these pressing issues. Not to mention the first few pages were props, confirmations, and a good discussion, GC was completely wrong on the content and bump status of the post.

landsoul · 05/30/09, 8:08 PM

The changes don't affect much really, just a small shift in SEP and a down in DPS and heroic strike frequency. Makes hit and crit a little better.

Spearchuka · 05/30/09, 8:14 PM

Hey Landsoul, been wondering how to understand the dps number given in your spreadsheet, been wondering this for a while. Is it to be taken literally or as a guideline? How close should we be in sense getting to that number? I would do a search for this but I have no clue what to search for.

landsoul · 05/30/09, 8:35 PM

It's a guideline, but it gets more and more accurate in a literal sense each time it is updated.

Machinator · 05/30/09, 8:44 PM

I think that needs to be stated in big, bright text in the OP and front page of the sheet, would save a lot of posts.

landsoul, in the 'Changes next build' you list 'new 4s BT rotations'. How exactly are you creating these rotations and will users be able to change them?

landsoul · 05/30/09, 9:14 PM

It is very much up in the air at the moment. There are a few options, though and I have begun to explore them all:

1. Keeping an 8s period with 1 slam chance in said period
2. Allowing around 6 different 8-10.5 second periods based on relation of bloodsurge chance and optimal places to use them
3. Allowing the user to define their average GCD use, like: I hit 13 BT every minute, 7 WW every minute, and 8 slam every minute.

Which ones (or all) would a user particularly want? I for one don't particularly mind.

Machinator · 05/31/09, 12:18 AM

Originally Posted by landsoul

2. Allowing around 6 different 8-10.5 second periods based on relation of bloodsurge chance and optimal places to use them
3. Allowing the user to define their average GCD use, like: I hit 13 BT every minute, 7 WW every minute, and 8 slam every minute.

Assuming I understand option 2 to be something like 6 different 'example' rotations/priorities that would work. Having different rotation options at least would be great

Something with parts of 2 and 3 would be the best option. A rotation is just a flowchart of the user's priorities, so a couple boxes for priorities and the sheet generates the rotation. It would be a bit more complicated than just picking a rotation, but since slams/sec depends on HS and such, dynamically weaving slams in might be more accurate.
Or it may not be and not worth all that work...

BearBear · 05/31/09, 1:57 AM

Originally Posted by Tallanor

Here is the best non hard mode plate only BIS (Fury) I could calculate for a non JC (with BS though). The following list gets me 6019 dps on the spreadsheet (v2.405):

Head: [Conqueror's Siegebreaker Helmet] with +21 agi/3% crit, 16 exp gems
Neck: [Favor of the Dragon Queen] with 16 ArP gem
Shoulders: [Shoulderplates of the Eternal] with 16 Str gem
Back: [Drape of the Drakerider]
Chest: [Conqueror's Siegebreaker Battleplate] with 2x16 Str gems
Wrists: [Decimator's Armguards] with 16 Str gem
Gloves: [Conqueror's Siegebreaker Gauntlets] 2x16 Str gems
Waist: [Girdle of Embers] with 16 Str gem
Legs: [Conqueror's Siegebreaker Legplates] with 8 str/8 crit, 8 Arp/12 Stam gems (for meta req)
Feet: [Melancholy Sabatons]

Ring: [Sif's Promise]
Ring: [Godbane Signet]

Trinket: [Grim Toll]
Trinket: [Darkmoon Card: Greatness]

Main Hand: [Stormrune Edge]
Off Hand: [Stormrune Edge]
Ranged: [Giant's Bane]

Has anyone come up with a better non hard mode set for a non JC? I know I can up the dps a bit by using some non plate pieces, but I'd like to keep it to all plate if possible.

i put this set into the thing, and it gives me str as 1.0000 and ArP as .7xxx, how come arp is still lower than str? when i swap gems to str it gives me higher dps? wouldn't i want that? or am i missing something

Axira · 05/31/09, 4:19 AM

Originally Posted by landsoul

It is very much up in the air at the moment. There are a few options, though and I have begun to explore them all:

1. Keeping an 8s period with 1 slam chance in said period
2. Allowing around 6 different 8-10.5 second periods based on relation of bloodsurge chance and optimal places to use them
3. Allowing the user to define their average GCD use, like: I hit 13 BT every minute, 7 WW every minute, and 8 slam every minute.

Which ones (or all) would a user particularly want? I for one don't particularly mind.

Isn't there a way you could let the spreadsheet calculate which would be the highest DPS rotation?
Maybe even simulate the rage generation as it would happen per hit and then based on available rage let the spreadsheet try to simulate the most optimal rotation.

I know this is demanding much and the workload shouldn't be aimed at you ... I'm just jealous that certain other classes got very accurate DPS simulators, while for warriors it seems like an almost impossible task to make such a thing.

landsoul · 05/31/09, 2:21 PM

Its not impossible no, but it can only calculate what's best if strictly programmed so. I can calculate many different scenarios, but that requires me to define them all and to figure out/assign when the sheet uses that specific rotation.

I could have something like a 6 minute GCD space and run a macro that would basically go through an entire programmed decision process for that 6 minutes, but the results would vary and the best gearset for that one run would be different from the next.

What I try to shoot for in this sheet is somewhat accurate average results for the best most reliable estimation.