Just in case anyone ever wants to consider Rake situations, the applicable formulas seem to be

Rake DD and ticks: 99 + 30%*AP. Both ignore armor. Rake Tooltips seem accurate now (for much of 5.0 they were optimistic)
AP (at least for NE) is 260 + Str + AP from gear + 2*Agi when in cat form
Agi in cat form is Agi in caster + (Int*1.05 (or if no MotW, that .05 goes away, in other words this is a MotW double-dip))
Agi in cat form + HotW is 2.1 cat-non-HotW Agi (MotW has no influience here)

Auto attack in cat form (before armor) is 2*(Weapon DPS + AP/14). That number is reduced by Armor.

I believe that the Swipe/Mangel are 250% of the auto attack (plus a small constant), but I'm not sure that number is exactly correct. Tooltips say 400%. I suspect that is 100%+400%, but without the x2 multiplier that cats get on their auto attack. Both are affected by armor.

It probably isn't ever going to be mainstream, but even without HotW, Spending four seconds on cat->rake->moonkin may be better DPET than you'd get from MF spam (LS*3 DD) in Eclipse.

The item API is being updated tomorrow, and it looks like a lot more information will be being provided including upgrade data. This should help fix some of the accuracy problems, I'll look at it more closely once it goes live.

That reminds me, was going to see at some point if 1.13^(4/13)=1.03832 is a more accurate constant for upgrades.

I retested challenge mode scaling for a bit a week or two ago. The bugs with taking gear on/off seem to be fixed in cases where the hit cap wasn't involved. i.e. in Resto spec, items have consistent stats now, which are simply scaled down from their real stats in the proportion you'd expect based on ilvl (there's no special accounting for sockets). For example, for a 476 item, just divide everything by 1.13.

Hit cap specs like Balance have two problems:
1) Some of the bugs are still there, with things changing as I rezoned etc.
2) The hit cap fix is not done on a per-item basis. You would think that, for example, if an item had 113 hit and 113 haste (so that it was 100/100 in challenge mode in Resto), it would be 113 hit and 87 haste in Balance. But this is not the case--the same item might be 110/90, or 115/85, depending on what other gear you have on and how much hit it has. Basically the system first applies the normal scaling, then measures the hit cap discrepancy it caused, then somehow reallocates stats across your gear as a whole to fix that discrepancy, but not necessarily by putting each item back to the same amount of hit it started with. Why it's like this I don't know, since doing it item-by-item seems like it should have been simpler.

So for that reason, I think that a sort of "challenge mode checkbox" for wowhead/spreadsheets might be a bust.

I'll give it a bash when I'm making the updates for the new API stuff, but you should be able to edit the multiplier on the Basic Calcs tab if you want to do some testing.

Yeah, and if you check what I was going over on twitter today, I looked at spellpower progression more closely and it's not exactly 13% for 13 ilvls, closer to 12.88%. Basically stats grow exponentially with ilvl, with a constant of about 1.009363. That would make 4 ilvls worth that^4 = 1.03798, which is close to what we had before. I'm not sure we can get much closer than that with just computation.

Oh, although I do think you probably shouldn't round between upgrades.

Yeah, I'd removed the double rounding in the version I was working on anyway. I'd put it in since it seemed to tie up with the Wowhead figures, before you let me know they were just calculating it too! Removed those now, although the calculation method is still coming up with differences from live stats (annoyingly).

So, for this version we have:

• Armory import of upgrade levels implemented.
• First draft of upgraded trinket procs (PvE epics and heroic blues for now). Let me know if any values are different from Wowhead, can update these manually, or if I've missed a trinket you've upgraded.
• Import/Export/Save/Load Profile stuff updated to include upgrades.
• 5.1 gear added.
• LotC normal intellect proc value corrected.
• Updated upgrade multiplier to 1.009363^(4/13).
• Slippykin's BiS list updated for front page.

Stuff to look at:

• Do we need to start at the lowest level of an item and multiply up from there to get accurate upgrade stats? For example, rather than multiplying up from the Heroic legs for an upgrade multiply all the way up from the LFR version to see if it increases accuracy. Just an idea.
• Have we moved Jade Spirit over to the PPM model?
• Add a check for differences between Armory stats and calculated for upgraded items and adjust any differences found automatically.
• New random stat loot from scenarios.

[edit]Upgraded blue items may be a little funky in this version, just read that the output from the API is giving different results for different quality items so I'll need to apply a check to that. Augh.[/edit]

Let me know if this sorts it:

For over a day I was logged out in resto set and even tho I have switched back to balance over an hour ago (armory shows current set), WC still imports previous set.

EDIT: PC restart didn't help. Problem exists also in older version of WC.

Thats it sorted, thanks a bunch for the quick fix

nvm