I know it's pretty easy to just enter the numbers myself, but any chance you'd consider adding a link to LootRank as well as Wowhead? With their ability to import your gear from the Armory, it makes finding upgrades much easier (not to mention being able to diable content you're not currently running).

Also, the socket values for the ElementalHit ratings aren't working properly. The values are using the Runed and Reckless gems, when Rigid and Veiled will typically be better when using hit rating values.

Maybe?
I only did the wowhead one because that's what I use, so if someone throws me a concatenate formula that will generate a lootrank link, I'll add it in.

Well, since you won't be socketing hit after reaching the hit cap, I'm going to leave it as is. I have no aim (nor hope in hell) to make this 100% accurate.

I got a few questions about the spreadsheet.

1. Is it always assumed that the Chaotic Skyflare Diamond are used as a meta? I don't see anywhere to edit this info.

2. In the Pawn values, which gems are used to calculate the value for each slot?

3 The Haste and Damage column in the buff section doesn't seem to update the dps. There also seems to be some problem with the "Focus Magic". Is this section a work in progress?

4. Am I correct that the hit isn't used for calculating the DPS. It's only used in the EP values?

1) If you don't use CSD, you're doing it wrong. See one of the other Ele threads
2) Runed/Reckless/Glowing.
3) They are.
4) Correct. I decided that it was going to be too much of a mission to calculate rotations taking into account hit as well, so I went for the assumption that you'd loose 1% of damage for each 1% you were under the hit cap.

I can't seem to find the cell that uses the T6 4pc bonus, but looking at the "buffs" report cells it seems you are not including the bonus from the 2pc with it. Is it worked in somewhere that I am not seeing?

No, I just haven't added a T6 2pc bonus in (not that it's hard to quantify, so I guess I could put it in there somewhere)

No math or Excel genius, but here goes:

Default No-Hit: Default Hit: Default Hit w/Character: I am unsure about the normalized weighting, so you can correct this as you see fit.

No-Hit Hit If you were so inclined, you could add a "Name" and "Server" entry on the front page and insert that into each of the above like so:

These should give you a basic default setting Lootrank with weighted stats. Each person can then filter it as they see fit.

I apologize if this isn't helpful. My first post and first go at these types of formulas.

On another note, any word on the Rawr plug-in status?

No, there isn't yet.

One request: could people please stop logging into Dragonblight and asking guildies when I will be on? It's starting to get quite annoying for some of them, and I'm no more likely to answer questions than if you PM me here (I'd request that you read the threads & TTT entry, then go ask in the WWS & Gearing thread if you really need help).

New version up

Do you plan to add totems in your item list?

As far as I've read on these forums, everybody seems to point totem of hex as BIS, so is it already included in the calculation?

edit: Well I did read them carrefully but for some reason I thought it could have been so obvious that you didn't mention it, seems that I was wrong...

Yes, I plan on doing so eventually, but no, as you would know if you'd read previous posts they are not included yet.

You'll note that even though it's listed as such, there are no stats against it (I copied the talent/buff system from v2, and haven't really touched it since).

Hey,

I have enough experiences to code the Rawr plugin with C#, but I don't have knowledge of game mechanism. If you would We could work together? I would code the plugin and you would supply me with formulas and math.

There's already two people that have spoken up, but I don't think you have the communicative skills required.

Why do you think so? because my english isn't perfect? but as you want, I just offered you.

Bink-

First off, thank you for this enormously valuable spreadsheet. It's already helped to greatly to re-itemize my gear and set up most of my BiS items.

However, I seem to be having an issue with hit rating DEP. I haven't seen any posts about this yet, so I'm seeing if this is unique to me or a known issue. Basically, regardless of my hit rating relation to the hit cap, it's assigning a static value to DEP (at about 1.7). This value is not changing, and not adjusting based on reaching hit cap. Using my very limited excel knowledge, I tried to trace the values and could not find the cause. Please advise. Thanks.

Hey Bink,

First, thank you for such a great tool for Ele Itemization. I have a quick question regarding the use of SEIC.

When asking for my stats on the spread sheet, am I supposed to be completely unbuffed? I know I am not supposed to have ANY raid buffs. Does that mean I should not have any totems down and no FT on my weapon?

Thanks in advance,
Tiimmy <Second Attempt> of Eonar

If you check "Settings" page, you will notice all the raid buffs listed there and you can edit it to get buffs that you usually get in raid. Including FT and totems (they appear to first page under Buffs). So just enter your unbuffed stats.

I have downloaded your "SEIC 3.0.8.5.zip " excel file. I wanted to do some calculationsfor my own, and why make something new when it already exists?

After going through the numbers and formula's I could not help but wonder why your casting time was different than mine. I found the answer. and I would like to ask you to look at the following:

to explain it clearly, I'm gonna take the biggest numbers I can get with my gear and spells.

ancestral spirit = 10 sec cast
Hasterating = 785 / 32,79 = 23,94%

spell cast after applying hasterating = 10 / (1+23,94%) = 8,068

But,

now adding my Wrath of air totem

spell cast = 10 / (1+23,94%) / (1+5%) = 7,684 OR
spell cast = 10 / ((1+23,94%)*(1+5%)) = 7,684
this is also shown in my spell book

but in your sheet you are adding the totem (and aura) to the hasterating

spell cast = 10 / (1+(23,94%+5%)) = 7,755

Blood lust is added correctly in the sheet. (new time / 1,3)

as i understand it, every source of "spell haste" needs to be applied seperatly. you can't add them. you can however multiply them.

casting time / ((1+hasterating)*(1+aura)*(1+totem)*(1+BL))

equals

casting time / (1+hasterating) / (1+aura) / (1+totem) / (1+BL)


I think you know all this, but that you looked over this in your sheet.

Haste % stacking confirmed and added, relic support has been added as well.

Hello guys !

I'm looking for the complete damage formulas for our different spells (LB, CL, LvB, FS essentially), and I can not find it.
I mean fomulas like:

Non-crit LB Damage = [[(Base LB damage range) + (X% * spell power) * talent1 ] * (Talent2 + debuff1)] * (1 + Glyph1) * .....


I could of course find them myself, but I'm not sure about a lot of factor (are they additive or multiplicative?) and the correct order to apply them as I think that some are additive, and some others multiplicative.

Does anyone have this information plz ?

Thx in advance.


PS: thanks again for your great work Binkenstein

I wonder. Why still put a 150 ms cast delay ontop of each spell.

I believe it was in patch 2.8 where they changed how the server handles precasting. and so you could queue up your next spell befor the first one was finish. this made the then comonly used /stopcasting macros no longer needed.

when i work on my "rotations" I see I have a near perfect rotation as if I do not have Lag. seems to me that you could remove (or at least standard) put it on 0.

Brings me to the spreadsheet again. on the TAB "CC" the delay is not refering towards TAB "CURRENT" and is thereby a static number.