Just curious is there any where on the spreadsheet to see the exact stat valuations? i.e. if Intellect is worth 1.0 then haste is worth .7, mastery .6, etc.

Just curious to see how it values Mastery vs. Haste as I go up and down in haste, and also to see how much more Mastery is worth with the 4pc bonus, since Eclipse up time is increased. Thanks.

I see. Are these valuations based on a normal rotation? Or is it just giving the stat valuations for Mastery if you are in the corresponding eclipse to buff that spell? i.e. Over the course of a boss fight Wrath benefits xAmount from haste on average and yAmount from Mastery on average vs. In Solar Eclipse Wrath benefits xAmount from haste and yAmount from Mastery.

Mastery just seems really, really high.

Could you copy and paste your values? I imported your character and set it to 4t12 which took mastery to 1.54 DPS per point, which isn't a massive boost from before. Even in BiS, it's still worth under half a point of Intellect.

Spell Intellect // Haste // Crit // Mastery
Wrath: 1.736 // 0.958 // 0.659 // 1.610
Starfire: 1.652 // 0.918 // 0.632 // 1.544
Starsurge: 2.224 // 1.225 // 0.843 // 2.060
Moonfire: 7.301 // 3.899 // 2.683 // 6.557
Moonfire, 3 Starfire casts: 7.301 // 3.899 // 2.683 // 6.557
Insect Swarm: 4.523 // 4.253 // 1.722 // 4.208
MF Dot DPS: .383 // 0.204 // 0.140 // 0.343
IS Dot DPS: .300 // 0.166 // 0.114 0.279
Moonfire (DD only): .459 // 0.257 // 0.177 // 0.432
Moonfire (DD only, 3x LS): .459 // 0.257 // 0.177 // 0.432




That's with my current setup, without 4pc

Stomped, There is a comment in the cell that has that reads "Mastery" (the column header):

Scaling for Eclipsed spells--other 3 stats use uneclipsed spells.

To put Mastery on the same scale as the other spells, the scaling factor would be "This_Spell's_Eclipse_Uptime / (1+EclipseMastery)", a value around 2/5 for Wrath/Starfire in a normal rotation. Even for Solar-only it would only be about 5/8 for the Nature spells.

Edit: That formula I used above is wrong.

RV = rotation value of a stat for a spell
EV = Eclipsed value of a stat.
NEV = non-Eclipsed value of a stat.
EU = Eclipse uptime for a spell

RV = NEV*(1-EU)+EV*EU

For stats other than mastery, the spreadsheet shows NEV, and the RV formula is
EV = NEV*(1+EclipseMastery)
RV = NEV*(1-EU) + EV*EU = NEV*(1-EU + (1+EclipseMastery)*EU) = NEV*(1+EclipseMastery*EU)

For Mastery, the spreadsheet shows EV and the RV formula is
NEV = 0
RV = EV*EU

So to adjust WC single-spell mastery scaling to be in line with the other spells, multiply by EU/(1+EclipseMastery*EU)

If Wrath has an EclipseMastery of 0.6, and an EclipseUptime of 0.55, and shows Eclipse Scaling at 1.61, you'd want to use

1.61*0.55/(1+.6*.55) = 0.67

to put Wrath Mastery on the same scale as Wrath Int/Haste/Crit

Note: EclipseMastery is on the "Basic Calcs" tab. Cell J46 on my copy.


Edit: Caldarp: If you want to know what fraction of Wrath or SF benefit from Eclipse, go to the "Rotation" tab where there are cells showing the number of nukes cast during each Eclipse phase. For Wrath, you might see

Pre-Lunar: 5.6 casts
Solar: 6.9 casts

and compute 6.9/(5.6+6.9) = 55% of Wrath casts benefit from Eclipse.

Before you worry about all though, look near the top right by the stats themselves and you can get a value for each stat for the rotation as a whole.

I'm attaching an "experimental" WC that has an extra tab for Short-AoE comparisons.

It will answer questions like

- How long does a target have to live before IS is higher DPET than Instant Starsurge?
- How many targets does Hurricane need to have higher DPET than MF on a target with 8s to live?

You tell it the Eclipse phase, and if NG is up. The remaining numbers come from the existing WC sheet.

It will give "equivalent DPET" numbers for

DPET
Nukes (SF,Wr,SS,Instant SS,MF DD, LS3DD) - Number of simultaneous casts.
DoTs (FoN, MF, LS3, IS) - Duration
AoE (Typhoon, Hurricane, WM) - Number of targets (sheet does not know AoE caps)
Other (Thorns, Starfall) - Number of hits.

You specify one of those numbers (say 50k DPET or 1 SS Instant cast, and it tells you all the others (8.0 Typhoon targets, MF on a target that lives 10.6s, etc.).

This is based off of the July 25 WC.

Remove post please, sorry!

missed I was 10 rating from breakpoint, explains why haste had double EP value of int.

You're just before a haste breakpoint, Larrabee, inflating the value of haste until you pass it. If you manually add 29 haste on the Gear Setup tab then manually calculate the sheet (F9 with Windows), you'll see the value go back down again.

yea I realised a few minutes after I posted :D thanks anyway! (sry for all the spam, I tried deleting posts but dunno how to)

:(

Bugger, didn't realize that site charged for downloads. Let's try one that doesn't charge,
T11.5 chest WrathCalcs - Bloodfeud T11.5 chest.xls
Offset chest WrathCalcs - Bloodfeud offset chest.xls