sorry, answered my own question.

Heya Vontre,

just was retouching my stuff on your spread sheet and i noticed taht even on your last sheet there still was a place to enter our evocation weapon spirit value. But as evocation is no longer based on spi regeneration but on our total mana pool i've found usefull to use an evocation weapon full of intelligence.

Do you plan on adding such a tip in your calculations ?

Just out of curiosity, the "gear selector" just works by using Stirius' item database parser and copying the values directly into your spreadsheet's extra sheets (the head/neck/whatnot sheets)? I'm vaguely considering trying to add something like this to the warlock spreadsheet.

Yeah that's pretty much how it works. I'm not looking forward to updating it for Sunwell.

Vontre, have you tried maxdps.com? What's your opinion?
While I love your sheet, I always found myself using the sheet + lootzor to figure out upgrades; that site makes it a single step. Is it accurate though?

I'm especially concerned about haste, Pintof has elsewhere been scathing about ZA items but that site rates them very highly pre-T6.

Finally, while I'm posting... I've heard tell of a magic 30 haste rating point, does that point really exist and if so why on earth? Thanks in advance.

I don't know anything about a 'magic' value of 30 haste rating.

That site looks ok, however he appears to be using a 1-roll table.

I'm seeing some strange behavior with the "Stat Comparison" section. I was seeing that 10 damage wasn't equal to 10 damage for "Frostbolt Shift" and "Frost (w/ WE) Shift". After a little investigation I found the source. It seems that trinkets and meta gems are only applied to the left side of the stat comparison, not the right. When I turned off my gem and trinkets then the numbers made sense again.

There's an inconsistency in calculations between base gear and upgrade gear calculations. Specifically there is a difference between H52 and Y52 on Calculations page, but there could be others as well (this is in version 2.7.3.1).

Vontre, how about adding [Band of the Eternal Sage] to the spreadsheet?

Couple Q's/weird things:

1) Where's Band of Eternal Sage proc?
2) Why is it that at 159 spell hit t6 level stats 1 damage = .61 spell hit? Is it really THAT good?
3) Does your spreadshoot consider additive effects of multiple abilities? Like icy veins + AP? Veins + Combustion? Popping all your 2 minute timers together every 2 minutes?
4) Where's Drums of Battle? (Maybe not really necessary but i use them)
5) Why are your AB cycles so screwed up? If i put in 200 spell haste it suddenly says my best AB cycle is AB x1 Scorch x4
6) Vampiric Touch doesn't seem to do anything.

Thanks

MINOR BUG -

Going from Major Spellpower to Sunfire should increase DPS, instead it lowers it very slightly for AB(1) and AB(2) spells.

PROBLEM

Sunfire Enchant does not correctly work with the "Calculations" sheet.

Specificly, the formulas in "Calcuations!R47" and "Calculations!S47" reference cells M$10 and N$10 respectively. Both of these should actually be F$10 to pickup the right column amount for Arcane Damage bonus.

You can test this by swapping between "Sunfire" and "Major Spellpower" if you have "AB (1)" and "AB (2)" spells in your "Cycle Builder" sheet.

It is that good yes.

The most recent upload of the file seems to be corrupt.

Equipping Spi weapons during evoc would still have an effect because of the oo5sr ticks you take. Since the timer starts counting when you actually spend mana, assume you cast:

Fireball-->Evocation-->Fireball

This is what it would look like(Assuming 0 spell haste, no t6 set bonus and 0 latency):

So yes, equipping spirit weapons still does have an effect on the mana regained from evocation, indirectly. Though I have no idea whether this is modeled in the spreadsheet and I am pretty sure equipping a high intellect weapon (60% of a bigger mana pool is more mana) would grant a larger benefit.

This item is missing in the list, while the other cards are present. Is there any particular reason for it not being there (e.g. proc is hard to code)? I am interested in the breakeven point between Wrath and Shiffar's for example.

From my understanding the Wrath Trinket basically just sucks and you'd be better off with almost any other trinket.

I just uploaded a new version with Icy Veins and such. I didn't have time to get to all the issues posted here, but some of them have been addressed.

One thing you could add in the future is accounting for the Imp Spirit talent from priests giving 10% of your spirit as +dmg. This does increase the value of some items when trying to find the best possible combinations of gear.

I changed the following cell to account for it.

Calculations Tab : B54 =IF($B$50="yes",spelldamage,IF( $B$51 = "yes", Armory!$C$25, 'Main Sheet'!$B$11))+IF($B$78="yes", 'Game Stats'!$E$87, 0) + B53 * 0.1

Also, adding 17 Damage to the Band of the Eternal Sage puts it roughly in line of how much damage the proc adds when spamming fireball from the simulations i've done. This couldn't really be added to the generic spreadsheet, but it's a good modification that people can add when figuring fire dps for themselves.

1 point of spirit adds 0.25 * 1.1 (kings) * 2 (typical # of OO5SR ticks) = 0.55 mana to a full channel of Evocation.

1 point of int adds 15 * 1.1 (kings) * 60% = 9.9 mana to a full channel of Evocation.

So int is roughly 18x more valuable than spirit during Evocation for a typical DPS scenario. I get the feeling it's not worth discussing further.

Any idea why the spreadsheet appears to be either undervaluing Hex-Shrunken Head and Skull of Gul'dan, or overvaluing some other trinkets?

From the other TC thread, it seems like those two are viewed as the top fire mage trinkets. However, switching from those two in the spreadsheet to Crusade and TLC, I see a significant dps increase for both fire cycle and straight fireball. Unless this is just another example of actual practice revealing different results than cold numbers.

If you're using the switches on the front page, those are only for the effects. They do not include trinket stats.

This is already in the spreadsheet, you do not need to add it yourself. See 'Game Stats'!$E$15 and 'Calculations'$F$47