Hello,
First, thank you for your work, it is very interesting to play with numbers like that. In my attempt to understand the calculations I checked your code and found out something weird.
You have a function in the calculations.js sheet called getHybridCoeficients but it seems like you use pre-calculated coefficients (spelldata.directCoeff and spelldata.overTimeCoeff) in your calculations. I tried to compute these coefficients myself based on your guide, and the getHybridCoeficients function, and my results are different from your pre-calculated ones.
Let’s see for the druid spell regrowth :
baseCastTime = 2 > 1.5 so castTime = 2
tickDuration = 21 > 15 so duration 15
overTimePortion = (duration / 15) / ((duration / 15) + (castTime / 3.5)) = 1 / (1 + (2 / 3.5)) = 0.636
overTimeCoef = (duration / 15) * overTimePortion = 1 * overTimePortion = 0.636
directPortion = 1 - overTimePortion = 0.364
directCoef = (castTime / 3.5) * directPortion = (2 / 3.5) * 0.364 = 0.208
In the regrowth data sheet these values are set to :
directCoeff = 0.325
overTimeCoeff = 0.513
You can see quite a difference between our results but maybe I misunderstood something in the calculations.
Regards,