fixed numbers to correct base spell damage and included 2/3 playing with fire for AB with the 33/28 spec.

Added latency calculations considering you might never use /stopcast perfectly in a real battle where you look at stuff other than your castbar and your lack of perfection is exactly enough so that ABX3-fireballX2-scorch is impossible but if you drop the scorch you'll have to wait a fraction of a second (which gives 10/48/3 the edge just to be sure).

Remember I added an AP PoM pyro every 3 minutes that replaces a scorch and for the rest
of the spells a flat 2.5% increase from AP (not counted AP AB spamming just in case you don't have the mana for it even though it should probably be useable in most fights, again giving fire the edge).
2/5 T5 is a must of course.


33/28:
ABX3-fireballX2-scorch no latency: 1333 DPS
ABX3-fireballX2 0.13s latency: 1279 DPS

10/48/3:
Fireball spam no latency: 1232 DPS
8Xfireball+scorch no latency: 1223 DPS
Fireball spam 0.13s latency: 1181 DPS
8Xfireball+scorch 0.13s latency: 1169 DPS

So the DPS increase from 33/28 to 10/48/3 is 8.2% with no latency and 8.3% with latency compared to fireball spamming. That's if the fight isn't extremely mana intensive so that the ~25% more DPM of 10/48/3 won't matter, but also not taking into account fights where you have more than enough mana and can spam AB and do even more damage than what's calculated.


Another thing if you don't have 2/5 T5 33/28 will do like 99.1-99.9% of the 10/48/3 but at that point the lack of range and DPM make it not worth considering even if you like the ability to AB spam on fights that allow it.

I played with the latency, and it doesn't change much which spec is better when you play with a realistic range of latencies.
Since I did manage to pull off the 3XAB+2Xfireball+scorch when I was really really trying, it means I could pull off less than 0.125 latency. So worst cast where that rotation doesn't work is if your latency is bigger than 0.13. Once it's already bigger than 0.13 and you swap to 3XAB+2Xfireball+scorch as you add latency it actually favors 33/28 even more compared to 10/48/3, as it means you wait less fractions of a second waiting for the AB debuff (as removing scorch from the rotation with 0.13s means you still need to wait 0.11s on the AB debuff before you can cast AB with 1.5s cast and cheap mana cost). More than 0.13s means you don't have to wait at all making it go even more in the 33/28's favor as scorch is subpar DPS and is just a filler anyway.
So in every way I looked at it, 33/28 came out superior except for mana efficiency, range and 3s-burst AOE that happens more often than AP cooldown.

Just noticed wowiki states that the coefficient for fireball is (1+empowered)*0.9 meaning you get 1.035 coefficient instead of the expected 1.05. Any verification for this?
Also anyone knows exactly how frostbolt works? -5% due to snare additive or does it add a 0.95 multiplier to the end result?

These differences are small but not neglicible. It's a difference of ~1% of fireball's DPS so it's worth checking.

I just noticed your spreadsheet doesn't seem to allow to specify if totem of wrath totem is up, which makes a tremendous difference for a fire build. (keep in mind: totem of wrath stacks, so technically a mage could get +12% crit/+12% hit)

I guess i can always add 66.3 crit rating / 37.8 hit, but I wonder if its intended.

EDIT: I also have another suggestion. Since the cycle builder does not allow to enter arcane blasts, would it be possible to model it as if arcane blast was 3 different spells ? For example, there would be 'arcane blast(1)', 'arcane blast(2)', etc. each of which corresponds to the stacks. This way their individual DPS/DPM would be easy to model. It would also allow me to enter a casting cycle of:

arcane blast(3)
arcane blast(2)
arcane blast(3)
arcane missiles
scorch

Also I've been reading that mana cost of arcane blast is actually base+%, so stuff that increase mana cost by a % add up instead of multiply, so as you stack AB the relative effects of 20% more mana cost from 2/5 T5 and arcane power get reduced, which means 2/5 T5 and AP actually increase AB's DPM. Of course it's not even close to the loss of DPM you get by stacking AB, but DPS>DPM doesn't it? ;p if we wanted DPM we'd roll rogue or use wands.
So the way it *probably* works (any testing will be appreciated as I have neither T5 nor AP):
no stack AB: base X (1+T5%+AP%)
1 AB stack: base X (1+T5%+AP%+75%)
2 AB stack: base X (1+T5%+AP%+150%)
3 AB stack: base X (1+T5%+AP%+150%)
base being the (slightly less than 200? don't remember off the top of my head) no stack mana cost of AB, without 2/5 T5 nor AP.

Also in my spreadsheet I accidently made pyroblast's dot capable of critting, after fixing it 33/28 still pwns 10/48/3 in DPS with 2/5 T5 and still does about equal damage (but not worth it due to less DPM and range) if you don't have 2/5 T5. The difference is ~9% DPS 10/48/3 does ~25% more DPM (minus the "extra DPM" from arcane meditation but it shouldn't be anywhere near 25%), and it stays about the same (~9%) with any latency using the appropriate rotation, as while latency makes you use a rotation with less spells, it also lowers 10/48/3 DPS, so the end result (after calculating actual DPS) is that you actually gain DPS in relation to 10/48/3 (although obviously lose overall DPS), even though it's a neglicible amount.

Hi, just registered. Will you be incorporating Arcane Blast into your rotation builder soon? And how is LC modeled in this Spreadsheet?

I foresee wonderful things for you.

-sol

How exactly are you calculating your "maximum mana efficiency" cycle?

I've looked in calculations and you seem to be casting Scorch 80% of the time and AB 20%, 90% of the time, then AM 10% of the time (on clearcasts). Cursory examination of that tells me something is wrong since AM takes 3 times as long to cast as Scorch (so it should be more than 10%).

I modeled an AB, Scorch x4 cycle with AM on clearcasts, and tried to overlap AB.
This is what I got:
IOW, the cycle you have modeled in the spreadsheet is waaaaay off. It's even more off if you use an ABx2, Scorchx3 cycle instead (the second AB could be more efficient in mana per second than scorch with certain builds).

Anyways, this would all be sort of fixable if the cycle builder allowed us to put Arcane Blast in, and also if there was a clearcast cycle builder specifically for modelling this sort of thing (like the mutilate cycle builder in the rogue sheet).


-sol

Just a little heads up, minor thing, wouldn't have posted it unless it was 8am in the morning..

Include Brilliant wiz. oil on the sheet! It's overall still the best wep. enchant for mages there is- 36 dmg and 14 crit rating vs. 42 dmg, easy!

btw: I'm somewhat confused, if I click the "calculations"-tab it says frostbolt rank 11. How come?

A wonderful spreadsheet!

I needed to add some items to the database and fix others. Fixing them was easy, but updating the offhand is throwing me for a loop. If I add an item to the bottom of the list (The Saga of Terokk), I can't get the drop-down menu to see it. It seems to be only looking at items 2-17, not 2-18 automagically. If I add my item as item #3, the dropdown menu sees it, but them item 17 gets bumped off the bottom. I'm not great with Excel, how do I tell it to automagically see the last item in the list?

V

in the next version will it be updated so the new items stats + new gems are included?