[Elemental] SEIC Spreadsheet - v3 - Page 12

Anthraax · 05/19/09, 1:15 AM

I've been wondering lately if the addition of T8 4p would increase the stat weight for crit over what it is without the 4p bonus.

Binkenstein · 05/19/09, 1:24 AM

Hi. This is me dealing with stupid people.

Originally Posted by Mann�

Hi there, you weighted haste lot more compared to your last version, almost as equal as spellpower now, how come?

Thanks, Mann�*

I dunno, maybe you should change the default settings, like "delay" for instance? Maybe that will affect how haste is valued or something. Otherwise it's just some random number I picked out of my head.

Originally Posted by Cryonic

I've been wondering lately if the addition of T8 4p would increase the stat weight for crit over what it is without the 4p bonus.

Well, if that's what you want to find out you could ENABLE THE FREAKING OPTION and see. It's not like it's hard to see or anything, unless you can't see "Set Bonus" sitting in the middle of the screen.

These messages are brought to you by the "Bink Wishes People Would Think More" Foundation.

tufy · 05/19/09, 1:29 AM

Cryonic (#166): Both 2p and 4p increase the value of crit a tiny bit, but the difference is nowhere near close enough to compete with haste and spellpower.

Mann (#165): As your gear becomes more powerful, so does haste, because there's more and more damage that you can do in less time. So it's not him valuing it higher, haste really does scale as awesomely as that.

Ferala (#164): You could, however, it would be a better idea to calculate the proc separately and then calculate the portion of the time this proc is used in (1/6th with it, 5/6th without it), because it can affect the damage in a lot more ways than simple damage increase, depending on when it pops up.

P.S.: Bink in a bad mood? Let's lighten him up a bit /turn on light

ellotheth · 05/21/09, 12:06 PM

In version 3.1.2.15, the formulae for the following trinkets do not use 60 for the time division:

[Pandora's Plea]:
```
depint*108+depspell*(850*10/50)
```
[Flare of the Heavens]:
```
depcrit*120+depspell*850*10/55
```
[Elemental Focus Stone]:
```
dephaste*(552*10/50)
```

Are these typos, or is there something else going on with these trinkets?

[Edit]

While I'm on the topic: There is a discrepancy between the [Pandora's Plea] tooltip and the aura applied. I don't have the trinket myself, so I can't verify.

Binkenstein · 05/21/09, 6:16 PM

They should all be 55, but it's an estimation of the cooldown time (45 sec cd, 10 sec to proc again)

Quriel · 05/27/09, 10:41 AM

I think we all know that we should use the glyphs:

Glyph of Totem of Wrath until ~2484 spell power unbuffed.
Glyph of Lightning Bolt
Glyph of Flame Shock

However, it appears in your spreadsheet that the Glyph of Shocking is showing to have more DPS than the other glyphs, are you able to confirm this?

Thank you in advance.

--- EDIT (2): Typo ---

ellotheth · 05/27/09, 2:21 PM

Originally Posted by Quriel

However, it appears in your spreadsheet that the Glyph of Shocking is showing to have more DPS than the other glyphs, are you able to confirm this?

It scales with haste and latency. Are you setting either of those to 0?

Quriel · 05/27/09, 2:31 PM

My haste rating is set to 455, and latency to 35. It still shows a bigger DPS increase than the other glyphs, however is it?

pfg · 05/27/09, 4:13 PM

Hi, I am trying to figure out why the 4pc T8 bonus damage appears low.

Wow Web Stats

8% of LB crit damage should be 45 x 10318 x 8% = 37144 but on wws its only 25644. I was expecting it to not work out based on LO proc's not triggering the effect but not to this extent. Is this normal ?

Binkenstein · 05/27/09, 6:59 PM

Originally Posted by Quriel

I think we all know that we should use the glyphs:

Glyph of Totem of Wrath until ~2484 spell power unbuffed.
Glyph of Lightning Bolt
Glyph of Flame Shock

However, it appears in your spreadsheet that the Glyph of Shocking is showing to have more DPS than the other glyphs, are you able to confirm this?

Thank you in advance.

--- EDIT (2): Typo ---

Looks like I'd put in an incorrect formula for LvB cast times on the shocking comparison. Fixing in next release.

or set E253 and E 263 to be =MAX((2-lightningmastery)/(1+B255),1)

Binkenstein · 05/28/09, 12:42 AM

Think I've figured out where the electrified calculations were going off. I'd managed to double-dip on crit multipliers. New version up sometime soon.

lrdx · 05/28/09, 2:35 AM

Originally Posted by pfg

8% of LB crit damage should be 45 x 10318 x 8% = 37144 but on wws its only 25644.

WWS can't tell the difference between LB and LO LB (use WMO or WoL), and 4T8 does not proc for LO LB.

Binkenstein · 05/29/09, 2:32 AM

3.1.2.16: Fixed T8 4pc calculation, set standard internal trinket cooldown

Lintra · 06/02/09, 10:06 AM

Looking at the SEIC 3.1.2.16 cell D4 has the following

MAX(IF(I34="Yes",0.1*J34,0),IF(I41="Yes",280*(1+glyphtow*0.3),0))+211*(1+0.1*N22)

Which implies that the glyphtow buff would not stack with demonic pact if the overall gain from demonic pact > 280*1.3. Is that really the case? I was under the impression that the personal buff from the glyph would stack with anything - but then in an actual raid the buff bars are ever changing and jumping around and, well, I am a tad busy to examine them in minute detail.

Jerenn · 06/11/09, 11:39 AM

I love this spreadsheet, but I was hoping to use Rawr.Elemental to help with some gear comparison choices. For example, the SEIC Wowhead link suggests to me another pair of pants as a huge upgrade over another that I'm wearing. I see a 40 Score on the non-hit link, and the ones I'm wearing give a 30 Score on the with-hit link. That leads me to believe that if I didn't need the hit, I'd be much better off with the new legs. So I just got ahold of a +hit trinket and +hit ring. One I know is an upgrade, one I THINK is an upgrade. Even if I guess a new configuration... dropping hit from my legs and upping hit with my ring/trinket, I don't know how to use SEIC to tell me if it's better or worse than my old configuration.

So from that point... I figure Rawr.Elemental is perfect because its Optimize feature is used for exactly that. However once I plugged in my information, it told me the legs I was considering were complete trash compared to my current ones :P But... the SEIC Wowhead link scores them way higher. What am I supposed to think?

I understand that Rawr.Elemental isn't very up-to-date, but is there some way I can do something to get some confidence? If I hop on a target dummy I'm just going to miss like crazy (we always raid with the +hit debuffs) and not get good numbers. What should I do to be confident and ensure I'm configuring optimally? Thanks!