[Elemental] SEIC Spreadsheet - v3 - Page 9

Warsur · 04/19/09, 7:51 AM

Perfect. What about priority rotation? Any plans to bring it back?

By the way, thank you very much Binkenstein. There are many better elementals out there because of your hard work.

Binkenstein · 04/19/09, 4:29 PM

Originally Posted by Warsur

Perfect. What about priority rotation? Any plans to bring it back?

By the way, thank you very much Binkenstein. There are many better elementals out there because of your hard work.

No. I'm fairly certain I've mentioned this before

Warsur · 04/20/09, 6:54 AM

I read it but I suppose that I misunderstood.

Sorry about that.

clanofmiller · 04/20/09, 11:26 AM

Total mana = 4396+(INT-20)*15+20 -- not that this really matters at this moment. You are not including buffs from food/elixirs for stamina (irrelevant), int, haste.

The values I'm to type in the green fields come from paper doll completely unbuffed, are those fixed values in totals for stats the 'naked' lvl 80 values? Or am I assuming wrong? Are you not double counting buffs from anc. knowledge (total int vs. paper doll frame), crit rating (thundering strikes), mana regen from water shield?

A quick question, you calculate EM crit contribution over the duration of the CD of non/glyphed versions, however, say the combat lasted the default 3 mins and you are glyphed for EM (yeah, right), would it make sense to use 0.15*15*EM segments/fight duration=avg EM crit contribution?

-- EDIT --
water shield =/= mana shield

Binkenstein · 04/20/09, 4:56 PM

Fixed Int, Crit (was doing some double counting of AK, and adding TS on), mp5 didn't include WS. Not sure where you're getting that total mana calc from though.

I figure using an average bonus for EM is better, as you may or may not get 2 uses off in a 3.5 min fight.

clanofmiller · 04/21/09, 4:37 AM

+ base mana #shaman: 4396--this i got from my character, total mana - mana as contributed by int -- as stated in the tooltip, also corresponds with values from, say, wowwiki
(
+ your total intellect
- 20 #as first 20 points of intellect do not get multiplied by 15, but rather by 1)
) * 15 # the total value of your mana without the first 20 with diff. multiplier
+ 20 #mana from first 20 points of INT
=
your total mana

I was just wondering why I get diff. numberes on live char and your spreadsheet.

Source: here.

You may consider this redundant, but what do you think about adding an extra column to trinkets, where you devalue the hit to 0 for hit capped comparison? Damn, how I want that Illustration.

-- EDIT --
Added link and updated with silly feature request.

SoNoFu · 04/21/09, 6:24 PM

Has anybody had a problem with the Pawn values updating? Both cells have the same info in them after I click the update button.

Binkenstein · 04/21/09, 6:50 PM

Originally Posted by clanofmiller

+ base mana #shaman: 4396--this i got from my character, total mana - mana as contributed by int -- as stated in the tooltip, also corresponds with values from, say, wowwiki
(
+ your total intellect
- 20 #as first 20 points of intellect do not get multiplied by 15, but rather by 1)
) * 15 # the total value of your mana without the first 20 with diff. multiplier
+ 20 #mana from first 20 points of INT
=
your total mana

I was just wondering why I get diff. numberes on live char and your spreadsheet.

Source: here.

You may consider this redundant, but what do you think about adding an extra column to trinkets, where you devalue the hit to 0 for hit capped comparison? Damn, how I want that Illustration.

-- EDIT --
Added link and updated with silly feature request.

I'm still not convinced that the first 20 int gives 1 mana each, but I'll do some double checking of that when I test Shocking on the weekend.
As for the feature request, no, not going to happen. I'm not going to do anything at all to devalue hit when you're at the cap. It's your own responsibility to manage that, and if you can't pick between trinkets with/without hit, you've got bigger problems.

Originally Posted by SoNoFu

Has anybody had a problem with the Pawn values updating? Both cells have the same info in them after I click the update button.

Which release, and can you copy/paste the macro "Pawnelemental" please. There was a problem where I had it selecting an incorrect range to copy, but that was fixed.

clanofmiller · 04/21/09, 6:54 PM

The macro error is the one someone else pointed few posts above, you've had a typo there. SoNoFu, simply update the range in VBasic editor and you're good to go.

SoNoFu, they have the same values, save for Hit, which should be appended to the end of the second Pawn string (yeah, devalued hit in the first pawn string , in case you're using Office 2007, try expanding the cell by clicking the double arrow button at the right side of the cell edit line and you should see something like HitRating=1,716 in the second string called 'ElementalHit'.

Oh, I did it, I added a column with 0 value for hit and can now sort trinkets based on whether I am/am not hit capped, just thought it might prove useful to someone quickly skimming through trinkets and having a general idea.

clanofmiller · 04/23/09, 10:45 AM

Originally Posted by SoNoFu

Has anybody had a problem with the Pawn values updating? Both cells have the same info in them after I click the update button.

They have the same values, save for Hit, which should be appended to the end of the second Pawn string (yeah, devalued hit in the first pawn string

, in case you're using Office 2007, try expanding the cell by clicking the double arrow button at the right side of the cell edit line and you should see something like HitRating=1,716 in the second string called 'ElementalHit'.

-- EDIT --
Typo.

SoNoFu · 04/23/09, 12:42 PM

I actually edited the macro and that seemed to fix it. Prior to that, the second string was identical to the first (on tab 1 anyway) including the name. It has been fixed and I appreciate the help.

Binkenstein · 04/26/09, 2:18 AM

Originally Posted by SoNoFu

I actually edited the macro and that seemed to fix it. Prior to that, the second string was identical to the first (on tab 1 anyway) including the name. It has been fixed and I appreciate the help.

You're using 07 right? Can you PM me the macro, and I'll see how it works in 03.

SoNoFu · 04/26/09, 3:00 PM

Actually, I use OO. I just used the post a few above this one for a guide.

I changed

Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Sub Pawnelemental()
' Pawn Elemental Macro
' Macro recorded 3/01/2009 by Binky
'
    Sheets("EP").Select
    Range("L4:LM5").Select
    Selection.Copy
    Sheets("Current").Select
    Range("N6:N7").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

to

Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Sub Pawnelemental()
' Pawn Elemental Macro
' Macro recorded 3/01/2009 by Binky
'
    Sheets("EP").Select
    Range("L4:L5").Select
    Selection.Copy
    Sheets("Current").Select
    Range("N6:N7").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

To be honest, maybe some of the problem was from using OO. I'm not sure, but it seemed to fix the problem.

*edit* I am using 3.1.0.12.

Binkenstein · 04/26/09, 4:47 PM

Hmm.

What I've got atm is

Sub Pawnelemental()
' Pawn Elemental Macro
' Macro recorded 3/01/2009 by Binky
'
    Sheets("EP").Select
    Range("L4:L5").Select
    Selection.Copy
    Sheets("Current").Select
    Range("N6:N7").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

Reminder to self: add in un-removable resist mitigation from level difference.

Pretzle · 05/05/09, 4:54 AM

Am I right in thinking that the new [Flare of the Heavens](PTR stats) calculation will be this?

=depcrit*120+depspell*(850*10/60)