WotLK DPS spreadsheet - Page 243

KergeKacsa · 10/01/09, 8:04 AM

Originally Posted by kovacs

I have used this spreadsheet for quite some time now - great work -thank you!

This morning when I tried to import my settings from my last version, 92PTR2, to the current version 92a. Several calculations appear to have an error, #VALUE, if I choose either of the T9 shoulders. If I choose any other shoulders, the error is corrected and actual values are displayed. Am I missing something?

Kovacs

The another way to solve this that you remove serpent sting from the shot priority, so the problem is somewhere around the serpent crits.

foox · 10/01/09, 8:06 AM

Same here, it seems to break whenever the T9 2 piece bonus is applied, as it doesn't work with any combination of 2 T9 pieces I have tried so far.

Shandara · 10/01/09, 8:33 AM

I forgot to test it with MM specs (which refresh Serpent Sting), which is why it breaks.

I've re-uploaded V92a, fixing this.

Gemfire · 10/01/09, 2:56 PM

I've only started using the spreadsheet recently so if anyone could clarify this it would be appreciated: When using the spreadsheet it shows me as having 314 ArP when survival yet 399 when MM. I'm not seeing anything that would affect this (I just loaded my gear from armory into the sample SV/MM) so I'm sure I'm missing something. Also it shows MM as being ~70 dps higher than survival despite me not having runestone or much in the way of ArP.

KraxisSingular · 10/01/09, 3:10 PM

That was interesting. The change only included thing that I should potentially gain DPS from, or at the very worst gain nothing from, yet I lost around 90 DPS.
I have made sure all the settings are the same, the same buffs/debuffs, same gear, same glyphs and same talents. Same rotation, and my gear isn't part of what has been changed/fixed.

I see a significant drop in Explosive DPS, and a slight to very slight increase in all other DPS (pet is the same). Also the weight of the stats is definately not the same anymore, they are all down. Some like Agility drop by over 5% (from 1.637 to 1.549), and Crit by almost 8%. Since all stats and ratings from Agility to Stamina to ArP are worth less, I can only assume some calculations are changed?

And yes, I have gone from 92 to 92a.

[EDIT] Just noticed something that is different. Old sheet has my Haste to cap at 244 (at 168 atm) but the new one has Haste to cap at 258. I don't know if that has an impact? And even if it does, it should generally lower all DPS save the pet, rather than just Explosive.
MM shows the same weights, yet it is up (due to the bug of course). But eventhough the weights are all down the only affected shot is Steady Shot (again the bug). Realistically MM should like Survival see a difference in power for all the shots since only Steady Shot should be up given the new weights. I'm a little baffled honestly.

[EDIT2] Well, don't I feel like a doofus. I forgot to recalculate the attributes. The new attrubutes are much more even with the old, especially for MM, but Survival still sees a across the board drop save for ArP which increases by 1% (0.995 to 1.005). And of course this doesn't explain the drop of DPS from changes that should produce more or no change. Oh and the Haste issue is fixed as well.

[EDIT3]
Found the bugger! My LnL drops from 7 to 5 on a 6 min fight.

MizarAlcor · 10/01/09, 3:12 PM

Originally Posted by Gemfire

I've only started using the spreadsheet recently so if anyone could clarify this it would be appreciated: When using the spreadsheet it shows me as having 314 ArP when survival yet 399 when MM. I'm not seeing anything that would affect this (I just loaded my gear from armory into the sample SV/MM) so I'm sure I'm missing something. Also it shows MM as being ~70 dps higher than survival despite me not having runestone or much in the way of ArP.

My guess is you probably have the Elixir of ArP + Hearty Rhino food buff enabled for the MM spec, giving more ArP buff. Also, depending on your raid buff setting, the presence of certain raid buffs (mainly sunder/expose armor, mangle/trauma) may yield higher MM theoretical DPS.

Lactose · 10/01/09, 4:02 PM

Originally Posted by Shandara

That's a good idea and it should be fairly easy to implement.

To expand on it slightly, having it sum up the amount of gems at the bottom would be helpful as well.
Refined example output:

REGEM RESULTS
Shoulders:
Blue Socket: Delicate Cardinal Ruby (20 agi)  --> Nightmare Tear (+10 stats)

Legs:
Red Socket: Fractured Cardinal Ruby (20 arp) --> Delicate Cardinal Ruby (20 agi)
Blue Socket: Nightmare Tear (+10 stats) --> Delicate Cardinal Ruby (20 agi)


GEMS NEEDED FOR REGEMMING
2x Delicate Cardinal Ruby
1x Nightmare Tear

Shandara · 10/01/09, 4:12 PM

Originally Posted by KraxisSingular

<snip>
[EDIT3]
Found the bugger! My LnL drops from 7 to 5 on a 6 min fight.

This is very strange since I didn't make any changes to the rotation. I'm not sure what can be causing it (possibly some haste proc affecting Steady Shot speed?)

EDIT:Ah.. I found the culprit. I changed the L&L Proc rate to 4.5% per point (i.e. 13.5%) to check some stuff (mainly the results of the L&L testing done). The V92 version had it at 6.5% per talent.

I forgot to change it back.

Gemfire · 10/01/09, 6:16 PM

Originally Posted by MizarAlcor

My guess is you probably have the Elixir of ArP + Hearty Rhino food buff enabled for the MM spec, giving more ArP buff. Also, depending on your raid buff setting, the presence of certain raid buffs (mainly sunder/expose armor, mangle/trauma) may yield higher MM theoretical DPS.

Quite possibly. We always have mangle up (GM is a feral druid) and sunder up most of the time as well (Prot warrior OT puts it on whatever he's tanking or puts it up on bosses like Icehowl when he's not tanking). I'll drop the rhino + ArP elixir and go from there. Thank you.

nedm · 10/01/09, 8:57 PM

Something I noticed while messing around: When you run a "Calculate DPS" on the gear planner screen, that calculation naturally is specific to your gear/spec/rotation. But when you switch to a different profile, the gear planner screen keeps the gear planner from the last time the calculation was ran. Would it be possible to save the gear planner calculations in a character profile? I mean in such a way that you don't have to rerun the calculation when you change profiles to get accurate results.

OJey · 10/02/09, 6:56 AM

Feature request:

I would like to have an option to choose between Hard Mode and Heroic Raid items based on 10-man or 25-man modes on the Gear Planner tab. So it would be possible to have only 10-man hc and hardmode items mixed up with 25-man normal mode items for example. Cause 25-man hc ist no option for our guild and 25-man normal is possible in a random group.

thiswas · 10/02/09, 7:46 AM

The new sheet isn't showing the 258 gear for me.

kabes · 10/02/09, 10:11 AM

Originally Posted by thiswas

The new sheet isn't showing the 258 gear for me.

Check the "Heroic Raids" box in the gear planner.

Botchitt · 10/02/09, 10:21 AM

Great work on the spreadsheet, btw - I find it an extremely useful tool!

I have a minor query with the formula that calculates critical damage, when both the Relentless Eathsiege Diamond meta gem (+3% critical damage), and the Mortal Shots talent bonus apply...i.e. for everything other than auto-shots. This will affect the majority of hunters, given the popularity of both the gem and the talent.

The spreadsheet is applying an additional (unintended?) 3% bonus to the mortal shots bonus, leading to a small but not insignificant error (0.4% of critical damage when the hunter has Mortal Shots 5/5). For my current gear, this works out at around 6 dps, <0.1% overall which is pretty small beer.
By using the Global Adjusts on the Overview page, I can correct for it, by applying a small critical damage penalty (-0.9% into cell I25).

The current spreadsheet formula (Calculations tab, cell E60) is:- (Base% + MS%) xGem% (+ GlobalAdjust%)
where Base% = 100%; MS% = 0% to 30% depending on talents; and Gem% is either 100% or 106% depending on meta.

This formula gives a maximum "headline" crit damage Total of 137.80%, whereas it should actually be 136.90%.
NB: I note the way the gem is being implemented as 106% x the bonus, not 103% x total crit damage.

The simplest way to correct for the error would be to change the formula in cell E60 to:-
Gem% x Base% + (0.5xGem% + 50%) x MS% (+ GlobalAdjust%)

Hope this makes sense!

alienangel · 10/02/09, 3:21 PM

Originally Posted by Botchitt

The current spreadsheet formula (Calculations tab, cell E60) is:- (Base% + MS%) xGem% (+ GlobalAdjust%)
where Base% = 100%; MS% = 0% to 30% depending on talents; and Gem% is either 100% or 106% depending on meta.

This formula gives a maximum "headline" crit damage Total of 137.80%, whereas it should actually be 136.90%.
NB: I note the way the gem is being implemented as 106% x the bonus, not 103% x total crit damage.

The simplest way to correct for the error would be to change the formula in cell E60 to:-
Gem% x Base% + (0.5xGem% + 50%) x MS% (+ GlobalAdjust%)

Hope this makes sense!

Perhaps I'm misunderstanding your post, but are you saying the 106% the spreadsheet is using isn't matching your in-game observations? The spreadsheet does it that way because that was the only way to match actual in-game damage observed at the time. I think Esoth tested arcane shot recently and it was still exactly matching the calculations with a 106% bonus. If you have tests showing this formula has been changed, please post them.