Coming across a small error with regards to DoTs and haste. It appears that the DoT tick breakpoints are off.

I have 1928 Haste as of right now. Normally, I get 11 ticks in game, which WrathCalcs agrees with. However, when NG is up, I am getting 12 ticks only, although WrathCalcs estimates 13 ticks. It is definitely getting the tick interval correct (1.44 and 1.66 respectively) but in this case, the game does not allow for the 13th tick (would be a ~18.72 second duration total).

After playing with this a bit with some creative reforging, it seems I get the 13th tick at 1930 haste but not at 1926. Assuming your 1928 test is right, the real breakpoint is 1929 or 1930. So there is definitely some kind of rounding going on in the in-game computations. We'd known this somewhat because I think someone mentioned pre-4.0 that a Rejuv breakpoint was a little off, but never really looked into it.

For one idea: 1929 is the first haste level at which the tick rate of IS, rounded to the nearest millisecond, is 1.439, and 1.439 is the first millisecond at which you get a 13th tick. Maybe this is a hypothesis worth checking for other spells.

Looks like some of the conditional formatting references got broken with that last save, going through and updating now. Updating the profile function for the new fields, too.

[edit] Yeah, a ton of references have disappeared, so regemming is broken. Will get it fixed today, just posting so people know I'm aware of it. [/edit]

In the last one I uploaded? Hmm, I didn't even notice. Like I'd mentioned, that happened once before and I don't know what's causing it. At time I just backed up a save. You can look at the notes in my post above or compare to the previous day's version--I don't recall changing anything on "your" pages (front page, gear list, charsheetdata). In prior updates I'd added some items manually (and even a meta gem), but not between these last two versions.

I know it's kind of a pain to put them all back in--although maybe going through and putting them all in once will fix whatever the problem is.

Here's the only detail I can think of:
The worst culprits were always cells I94 and I106 on the front page. The last reference in their conditional format (to G94/G106) would break to #REF sometimes, but I never figured out a repro. Once just I fixed them manually with $'s in them (as you see now), and I don't think the broke after that. But now looking at the 0117 one I uploaded before, a different reference in the I94/I106 conditional formats broke. Something about those two cells. This more drastic version where all the gem-related things broke I only saw once before.

I can't seem to get that file for some reason. Can you link it somewhere else for the moment?

That's what I thought at first too, but I disabled Troll Berserking and the problem still exists. Is it possible there is a threshold for the maximum time in which it can exceed the non-hasted max duration?

I'd been considering some kind of rounding, which seems likely to me, but that's another possibility. I've talked about this more recently on the Resto thread.

Offhand enchant is being nerfed in the next patch to 40 intellect, that's a PTR version we're working on currently. Chaotic gem requirement is being reverted in the PTR too. For the belt socket, I've probably just missed changing the dropdown for the second OO list, I'll sort that out, thanks!

I can add the wrist/glove enchants if anyone really wants it, although why would you use them?

Regarding haste not adding up, remember all haste effects are currently averaged over their duration, the discrepancy is your Witching Hourglass trinket's proc. Intellect is purely what you get from gear on that page.

The forums are showing the last upload as a gif for some reason, I'll reupload tomorrow morning.

Trying the upload again:

Thanks for the info. I will check if the discrepancies come from the trinkets.

Sorry, if I am steering up noobish things...but wondering about the formula to calculate SP from INT used in C3: =SUMME(K8:K112)+B3-10
Why is there a linear factor -10?

The Spellpower wrist/gloves enchants were at least on my server at the beginning the only affordable and only slightly worse than 50 haste on the basis that 50 haste translates into 27 Int. (1:0.54) and Int ~ SP on this scale. I consider them as comparable. Am I wrong?

The first 10 of everythign seem to not benefit your character at all:
10 stra, 10 agi, 10 int, 10 stam, 10 mana (or you could say the first 10 intellect only give you 1 mana each)
Some weird legacy thing probably :o