Spreadsheeting Resto Druid

[Exinium]

Few questions.

What's the formula for a haste's effect on tick rate/total time?

How much Intellect does a 90 R. Druid need to get 1% crit?

I'll probably have more as I go on, but those two are the two that are keeping me from proceeding.

[Pusekatten]

Haste formula:

HastedTickCount = (BaseDuration/BaseTickTime) * (1 + Haste)

If you want to reverse engineer it to find the breakpoints you can learn how to do so here: http://www.totemspot.com/vb/entry.php?b=55

For crit I found this:

2533.6636 INT is 1% crit.

however, this does not include base int (so int without any gear on). in additions, warlocks have 1.7% base spell crit chance.

I had to dive into the simcraft source code for this.

[Kazistrasz]

Tick speed = base tick speed / ((1 + (haste rating / (425 * 100)))*(1.05 with raid buff)) to the nearest thousandth of a millisecond.

Number of ticks = (base duration / tick speed) rounded to nearest whole number

Duration = tick speed * number of ticks

E.g., with 13163 haste and Rejuvination and 5% spell haste raid buff.

Rejuv has a base of 4 ticks at 3000ms base tick speed for a base duration of 12000ms.

The new tick speed is now 3000ms/((1+(13163/42500))*1.05) = 3000ms/(1.3097*1.05)=3000ms/1.3752=2181.495ms

The number of ticks is now 12000/2181.495 = 5.5008 ticks = 6 ticks rounded to the nearest whole number.

The new duration is now 2181.495 * 6 = 13088.97ms or 13.08897 seconds.