[Elemental] SEIC Spreadsheet - v3 - Page 8

Shiyo · 03/18/09, 5:04 PM

Originally Posted by lrdx

If a non-ele shaman caster has 50% crit rate, there is still 1.5% of not critting 6 times in a row (that is 10 seconds with 1.66 average cast time). Also, on average that caster will have to cast twice (1/50%) to get the buff on the mage back, meaning 3.33 sec (2*1.66) downtime. So the overall average up chanse is: uptime / (uptime + downtime) = 97.5%*10s / (1.5%*3.33s + 97.5%*10s) = 99.95%

The elemental shaman Provides 0.05% more uptime. It should be well under the difference of an another mage's and the ele shaman's DPS boost from 3%.

I think the point of a mage putting it on another mage is so that they'll put focus magic on you, not another caster with higher uptime. Buff collusion

Binkenstein · 03/26/09, 4:59 PM

3.1.0.11: Changed rotation calculations (mostly to fix a flaw in my rotation logic), added more 3.1 changes, set bonuses and trinkets

SoNoFu · 03/27/09, 12:57 PM

I noticed the rotation selection is gone. Does it default to Priority or Priority +?

(e) Nevermind, I see.

Fokui · 03/28/09, 5:20 PM

I noticed an error in the trinket section for Living Flame. Unless it changed on the PTR and if it has I apologize.
On wowhead it says:
Equip: Improves hit rating by 107 (4.08% @ L80).
Use: Increases spell power by 505 for 20 sec. (2 Min Cooldown)

Well your current formula rates it at 487 DEP for my stats but looking at the formula makes me think its flawed
dephit*107+depspell*(505*20/45) is what is currently there.

Should it not be dephit*107+depspell*(505*20/120) since its a use trinket with a 2minute cooldown rather than an on equip trinket? At that setting it drops it to 295 DEP.

Skah · 03/31/09, 4:05 PM

I ran a dps comparison between 3.0.9.9 and 3.1.0.11 versions of the SEIC spreadsheet and dps is going down by about 600 in 3.1 with my current elemental stats below, which is an 11% dps decline. Is our dps getting nerfed that badly in 3.1 or is the 3.1 version still a work-in-progress?

Stam 958
Int 932
Spell 1971
Hit 289
Crit 499
Haste 565
mp5 136

Also, how should trinkets get accounted for in the SEIC spreadsheet? For example, I have [Illustration of the Dragon Soul] so should I add 200 SP to my base SP? Thanks.

Binkenstein · 04/01/09, 2:59 AM

Well, if you go and look at all the other changes that are going on in 3.1, you'll see that there are other changes that may result in that decrease. Trinkets you can just use common sense and add them to your flat values.

Skah · 04/01/09, 11:35 AM

Spent some more time comparing the differences between the 3.1 and 3.09 versions and noticed that 3.1 does not have an option for Flametongue weapon imbue, which meant I was missing 274 SP. I added that in and the dps decrease significantly reduced, only a 3% DPS decrease now.

If you want to keep the spreadsheet similar to 3.09, I'd suggest adding Flametongue to the buffs section. Not a big deal because you can just add it to your base SP, but would be nice to have it consistent with previous versions. I also noticed that Totem of Wrath glyph option does not seem to be functioning.

Binkenstein · 04/16/09, 2:35 AM

Minor changes for r12, but added a calculator for the ToW/Lava question: rough figure = 4000 spellpower is the break even point.

Jezele · 04/17/09, 1:19 PM

I noticed that the haste EP value has changed from when you reported these values in the PTR thread (it's now 1.135, which is barely above crit rather than being close to SP's value). Was this due to a calculation change?

Also, there is an error in the Pawnelemental() macro. The second line currently reads:

Range("L4:LM5").Select

I believe it should be:

Range("L4:L5").Select

Dememor · 04/17/09, 5:15 PM

I'm curious if the math on the elemental focus stone: Elemental Focus Stone - Item - World of Warcraft is based on the haste or spell power version.

Currently on live it's apparently HASTE not spellpower although the tooltip does say Spellpower.

Binkenstein · 04/17/09, 6:54 PM

The value of haste changes with your latency. Macro fixed.

Warsur · 04/18/09, 9:08 AM

I think there's an error with hit value. If you decrease hit in your stats to get a value under 17%, total dps and dephit are not changing.

Tested with Openoffice and Excel 2007, macros on.

Jezele · 04/18/09, 10:00 AM

Originally Posted by Warsur

If you decrease hit in your stats to get a value under 17%, total dps and dephit are not changing.

I believe this is by design. Technically, the EP value of hit once you've reached the cap is 0, since no more hit will improve your DPS. Instead, it still displays a positive value, telling you how much hit is worth if you were not capped. This allows you to compare items that have different hit values when trying to mix and match which pieces you're going to use to reach hit cap.

Warsur · 04/18/09, 12:05 PM

Ok if you are over the hit cap but you don't do the same dps with 0% hit than with 17%. Dephit should be different as well.

Binkenstein · 04/18/09, 4:40 PM

Originally Posted by Warsur

Ok if you are over the hit cap but you don't do the same dps with 0% hit than with 17%. Dephit should be different as well.

Managing the hit cap is something I have not put in, and have no intention of doing. There are hit inclusive and exclusive lootrank/wowhead links available to use as well.