I may have spoke too soon...


Ah, yes. Sorry, that's a hold-over from posting my gear list on the off'cl forums. Remember kids, you can't Drape the willing. And the comments are a pain the butt--they seem to display to the right of cells no matter where I drag them to.

Oh, Efejel...

I just downloaded the Rogue Spreadsheet for my rogue alt and there is this really really useful option on the spreadsheet to optimize gear.

Location
5 Man TRUE
BoE TRUE
Quest TRUE
Crafted TRUE
Reputation TRUE
PvP TRUE
Heroics TRUE
Karazhan FALSE
Gruul's Lair FALSE
Magtheridon FALSE
SSC FALSE
TK FALSE
Doomwalker FALSE
Kazzak FALSE
Hyjal FALSE
Black Temple FALSE
Pre-BC Raiding FALSE
Endgame Crafted FALSE

So you can choose where your gear would be coming from and the gear selection list would add or remove items accordingly for each gear slot.

I think that would be a fantastic addition to the spreadsheet. I appreciate everything you have done for balance druids.

While that sounds really cool, I can only see accomplishing that by adding 18 boolean flags to every item in the spreadsheet. Even then, I think it may be a little beyond my Excel expertise to get it working, though I could almost certainly reverse engineer it off the rogue sheet. Real life is just too busy for me currently to tackle this, especially since I'm trying to squeeze in some time to play the game after a 5 month hiatus. In any event, I don't think there's sooooo much Balance loot in the game that people are spending a great deal of time searching through an alphabetized list of ~40 items to find the one they want.

As for Quag's Eye... it's good. Pretty damn good in starfire-centric environment. I'd say Darkmoon: Crusade (for a fairly stationary fight) > Eye of Mag > Icon of the SC > Quag's Eye ~= Scryer's Bloodgem (depending on how far from the hit cap you are), but that's just an intuitive ranking based on how far I had progressed raid-wise as of this past May. I also have no idea what the current damage values/crit rate/hit rate for Lightning Capacitor and/or what the hidden cooldowns are for the proc crit trinkets (Sextant & Shiffar's).

In the latest beta spreadsheet, I'm getting an Err:503 all over the place if I try to input a IS/SFx4 rotation manually.

You included them on your own, but I've also gotten different numbers from your own rotations, and the one I input manually. For example, I input IS/MF/SFx3, and get 641.2 dps with different things selected - then I look up a couple spots and your own IS/MF/SFx3 (same exact rotation and gear) gives me 660.9 dps. I didn't see anything about this in the thread (might've missed it), so I thought I'd mention it.


I'm using OpenOffice.

Sextant has 45sec hidden cooldown, i think Shiffar is the same.

The +dmg of +healing isnt really worth the effort of checking out for dps, you wouldnt choose alot of those items for it because of the lack of other stats. There might be some exceptions like the Illidan healing cloak, which suddenly has 23 spelldmg and 32 spellhaste, but in most cases it makes only for an interesting side effect.
Basically t6 healing items have the dmg value of t4, with all the wrong gems and enchants of course.

I'll probably be adding them--I'm sure there's a few Resto's out there who will be curious (and perhaps pleasantly surprised) to check out their DPS potential in their epic healing, and to compare it to all-5-man +dmg gear.

Of course, I'll wait until this stuff is finalized, and we have answers to questions like "What happens to Windhawk?" If it gets the +dmg it deserves, it might finally be worthy of having it's name in purple.

T5 chest socket bonus is wrong. It should be +4 crit instead of +4 hit.

Has anyone ever seen this? This website could be huge for information if the calculations are accurate.

SimulationCraft/Trinkets/Druid - Shadowpriest.com Wiki

Ok, so I am getting obsessed with trying to get a +spell damage equivalence value for Quag's Eye.

This is the math I have so far....help out!

Given values:
-600 second fight
-10% hidden proc chance
-0.6 second haste increase on proc
-6 second proc duration (2 casts)
-3 second starfire cast
-0 latency
-2800 average starfire damage including crit rate.
-37 passive spell damage on trinket


Derived:

.1 * 200 casts = 20 procs
20 procs * 2 casts = 40 casts
40 casts * .6 seconds = 24 seconds cast time reduction
24 sec / 3 sec cast time = 8 extra starfires
2800 * 8 = 22400 average extra damage off proc
22400 damage / 600 seconds cast time = 37.33 damage per second off proc
37.33 dps * 3 second cast time = 112 spell damage from proc with given gear??
112 damage from proc + 37 passive trinket damage = 149 spell damage??

Total Trinket value:
149 spell damage
49.67 dps (149/3)

I am leaving out Nature's Grace and assuming the proc does not refresh while already active.
Is my math correct?




Now at SimulationCraft/Trinkets - Shadowpriest.com Wiki that tries to rate trinket values for each class, they have a different formula posted...

SPELL_DMG_EQUIVALENT = 100 * ( DPS_ITEM - DPS_BASE ) / ( DPS_100 - DPS_BASE )

Problem here is the unknowns. What is the value of DPS_Base?
The site has posted the following instructions on how to use the formula, but leaves out how to find the DPS_BASE value:

I doubt it's anywhere near that good. Simply because if it were, 1) everyone would know and 2) it would be nerfed next week. I think the main factor you're disregarding is the probable internal cooldown, though I'm not fully certain this trinket has one, and surprisingly there's no info in the comments on Wowhead.

For base DPS, I'd use the results the spreadsheet gives on a starfire-only rotation.

As for the other comments: all things I should and intend to look into. Eventually. :-/

So with a 2.5~3 sec spell and a 10% chance to proc, and a 45 sec CD (which I wasn't looking that hard for) a rough estimate is 1 PPM, with of course a maximum of 1.25 PPM, or 8 procs in 6 min, less than half of the non-CD-predicted 20.

6 procs = 24 haste starfires, * .6 sec reduction = 14.4 addt'l sec, (rounding to 5 starfires...) = 5 * 2800 = 14000 dmg / 600 sec = 23.33 addt'l DPS

I think here is where your math may have broken down the most. To convert DPS -> SDE (spell damage equivalent) you need to consider how much spell damage it would take to bump starfire's damage by 23.33 DPS. I'm again feeling a bit lazy, and a bit short on time, so I'll say this: with 13% CoS a tier 5 + similar geared Druid would expect about a 46 DPS increase from the 101 +dmg from a Wrath of Air totem, just while spamming starfire. The benefit in a more realistic rotation, that includes MF and IS, would be greater (up to ~49 DPS in the semi-random scenario I have plugged in ATM).

So, a more realistic ballpark is ~70-some +dmg. So pretty good for a blue, as long as you're able to fully use the proc every time it activates--a challenge in phased fights, fights requiring movement, etc. Meaning, that like most aspects of being a Balance Druid: it's yet another situationally beneficial/superior gear/talent/consumable/etc.