I've been working on the spreadsheet, no worries.
There were quite a few things that needed some testing to confirm proper behaviour, there were some numbers that didn't make sense concerning Fingers of Frost, and there was Manly's report on unexpectedly bad Frostfire Bolt crits that I wanted to check and find out what was going on.
First things first.
0) Frostfire Bolt seems to work with resistance/vulnerabilities.
It dealt full damage against frost resistant targets (liches in the Vrykul fort in NW Howling Fjord).
It dealt more damage against fire vulnerable targets (tar lurkers in Un'goro).
That only tested the fire side. If someone wants to test the other side (frost vulnerable/fire resistant), they are free to do so.
1) Pyroblast at 5s cast time retained its old scaling. It's still 115% on the DD and 4*5% on the DoT.
Tested as 0/11/0 with 1285 dmg. 1210-1531 + 4 * 113 tooltip, 2695-3005 + 4 * 177 actual damage.
2) AoE spell damage caps are not touched yet. This means a few things.
1) For almost all AoE spells, the WotLK ranks have the same cap as the old maximum ranks from BC.
AoE Spell Cap Mechanics has a list of the current caps.
2) This means that Frost Nova with a cap of 1600 currently caps at 2 targets right now. Just a fun note to throw around.
4) Living Bombs currently has no cap on either DoT or detonation. Mind you that it still explodes every 3 seconds centered on you, the spell may have a lo of issues to fix.
5) The Water Elemental's Freeze seems to have no cap, but only scales with ~4% of its or ~1% of your damage anyway.
It won't ever hit for more than 100 anyway.
6)
Arcane Explosion right now should be downranked to rank 8 for proper AoE.
When spells got their caps, the new ranks AE got the old pre-buff cap of ~6730, while the old ranks retained their post-buff caps.
So AE9 = AE10 = 6.7k < AE7 < AE8 = 10.1k, downranked AE is the highest spammable AoE DPS right now.
Someone should make a post on US Beta as a reminder to not forget updating those new ranks.
(Note: I specifically checked the last 4 ranks of Arcane Explosion to make sure it affected all new ranks.)
3) More odd stuff about Frostfire Bolt. Tested in a 0/51/20 build, with full Fire Power / PWF / Pyromaniac / Precision / Frost Channeling / Ice Shards.
1) Rank 2 has no DoT scaling. The DoT does tick for its base value plus talents, ticked for 37 for me, base damage is 30 (it should have been a final damage of 36 though; not sure what's going on there).
2) Rank 1 still has it's normal 5% scaling, the DoT was ticking for 101/102.
The ticks show that there is no or only a little downranking penalty at level 80. I haven't checked the direct damage.
I'll probably have a look at that when the EU servers stop crashing every 15 minutes.
3) Mana reduction talents seem to apply twice to Frostfire Bolt.
With the spec above, I was getting 608 Pyro, 221 Scorch, 581 Fireball, 376 (!) FFB.
FFB costs 522 (or 16% of 3268) mana, it should be 442 with talents, but not 376.
4) On Fireball vs. Frostfire Bolt scaling
I thought a lot about the "FB crits harder than FFB" test by Manly as it seemed to contradict my results.
1) My sheet assumed Elemental Oath, which wasn't used in the test. Not sure if it ever actually worked, it's gone now anyway (unless you'll skill smithing and they actually implement a 2nd meta gem).
2) I didn't have the Fireball glyph back then, which was "used" in the test (by picking 4T6 to emulate it).
3) Also, my sheet was Spaghetti Nightmare.
I did some clean up and only compared the +damage scaling on a separate sheet.
I used the initial +dmg coefficient (86%/115%), the gains from PWF/FPow/PIce talents (PIce is the only difference anyway) and the crit multiplier with a CSD meta to get the following scaling with +dmg of hits, crits, DoT:
Frostfire Bolt: 103% hits, 243% crit, 18% DoT (if R2 gets scaling as well).
Fireball: 130% hits, 237% crits, 0% DoT unglyphed. 137% hits, 249% crits, 0% DoT with a 5% glyph.
(Those values are beforee Ignite.)
The above values are rounded so there are some +/-1% errors when adding up and comparing.
The safe results for comparing boths spells are as follows when regarding scaling (both scale similar relatively with +dmg, so the base damage difference makes a very little difference; see previous post and ask Muphrid):
*) Glyphed FB crits slightly harder, unglyphed FB crits slightly weaker than FFB. FFB is pretty much exactly in the middle.
*) FB always hits significantly harder than FFB.
*) If the DoT scaling will be added to rank 2 as well, then FFB may be able to compete as a DoT filler to add damage and reduce mana spent.
Without the DoT scaling, it looks as follows:
* => FFB outscales unglyphed FB only at very high crit values, it needs 68% crit or more.
* => FFB will never outscale glyphed FB. It will always crit slightly lower and hit a lot lower.
With the DoT scaling, using FFB every 9 seconds:
(Living Bomb builds can't get Permafrost unless they sacrifice Precision):
* => FFB is more damage than an unglyphed Fireball when you have at least 41% crit.
* => FFB is only more damage than glyphed FB at extremely high crit values, it needs 78% crit or more.
Frostfire Bolt and Fireball both produce similar damage within a few percent.
Fireball is generally ahead in raw DPS, but costs signicicantly more mana.
Frostfire Bolt can be used as a DoT and scales better with high crit percentages.
Glyhed Fireball is almost always more DPS unless mana is a dire issue.
It remains to be seen whether using FFB to save mana to cast more Living Bombs is actually helpful or harmful.
5) Frostfire Bolt in frost spec.
A frost spec that picks up Ignite to maximise its DPS might actually use FFB on Finger of Frost procs.
As in: Frostbolt - FoF proc! - Frosbolt (already) - Frostfire Bolt - Deep Freeze (3rd charge) - Frostbolt - ...
On a guaranteed crit (FoF is nearly that), FFB crits a lot harder than FrB, but it's longer cast time also prolongs the cycles which makes it less an advantage.
Fire spec doesn't have that issue since FB and FFB have the same cast time.
But in Frost specs, this produces some odd results that I need an explanation for first, or find possible errors.
At the Arcane + Scorch discussion right above:
- In the current design, mages are supposed to bring WC/ISc to the raid.
Many other people want to say "I don't want to spec for X, let someone else do it" which can be a huge headache.
Headache to those who complain, those who have to deal with them, and those who acually want to minmax a raid.
* => I'm honestly happy that we have our little domain that we have to bring, and don't have to argue with others.
- WC/ISc is on deep frost and middle fire.
It does force a single arcane mage into 50/18/0+3. If you have multiple mages and all are arcane for a certain fight, it forces one mage into that spec.
On the other hand, arcane brings focus magic, which may (no EleSham/DemoLock) or may not be useful.
Fire/IV and Frost/Ignite builds won't have it, they could take it but lose 9+ points elsewhere.
- Arcane Blast spam and renewing Scorch/Focus Magic.
If it causes you to lose your AB debuff, you lose a lot of damage to ramp it up again. How much exactly depends, I'll have a look.
With sufficient haste (33%+), you'll not lose your debuff though. Two haste-clicky trinkets and a haste pot can cover 3 ramp ups in 2 minutes for example. I'm trying to figure out of PoM can be used for it, but it doesn't look like it.
So, without sufficient haste, you have to go at lengths to maintain your debuff if it is possible at all.
But the other question is - is Arcane Blast supposed to be spammable? Or, what is it supposed to accomplish anyway?
I don't really like TCing Arcane Blast because it always feels like it's used for something it's not intended to do.
It always leaves some sour taste, also because there isn't a lot else that the spell or even he spec is good for.