It appears there is an incorrect HPS boost for trinkets that give an average haste increase that would bring you to another haste tier in hot ticks. Correct me if I'm wrong, but it seams the spreadsheet counts hots ticking 100% with that average haste
For example if I equip Witching Hourglass (haste proc) it will detail my haste at 2227 (this trinket adds an average haste of 342), which is high enough for a 9th WG tick. On the HOTS page it shows WG with 9 ticks, Even though a good portion of the time my WG would only be doing 8 ticks.
* There appears to be a bug somewhere. I'm sitting at 1885 haste in the spreadsheet and it's claiming on the HOT page that WG receives 9 ticks, when it should be 8.
Yeah, I'm not sure exactly what to do about that. It's one of annoyances of having such a granular behavior of haste. Nature's Grace is handled explicitly--broken up into 2 different cases and averaged together. I don't have a convenient solution for all other temporary haste effects though.
This is basically final for Cataclysm release. I'll still fix any major issues if they arise, but otherwise I'm going to be on break from this recent spate of heavy updating for a little while--probably until we're a bit into raiding at 85 and have some new experience to go on.
This thread (and all the other current ones) will be locked soon, but a new thread for Cataclysm discussion will be open on release day.
e: snuck in one minor sheet update just now--fixing value of GOTEM proc.
1. Regrowth, 851 casts, 2 Clearcasting procs. Hopefully from Regrowth casts, as I don't expect Energized (Solace buff) or Living Seed to proc it. I will remove Solace for the next tries. World of Logs - Real Time Raid Analysis
I don't know what to make of these numbers, it looks like there is a difference between spells that consume OoC and those that don't in their chance to proc OoC. Maybe someone with a better method and more experience in rigorous testing might take another stab at it.
*later edit: looking through the logs I see some things I'm not sure how to interpret: some Clearcasting procs have the same time stamp as a SPELL_CAST_START - I thought OoC procs on finished, succesful casts
Sorry for being late with updated treecalcs.com - was completely overloaded. I've managed to support version 101019 of Hamlet spreadsheet. Support of the latest version will require some really hard work, so I think it will take like 2 months or so. But at least there is something working right now.