FULL Sentinel, Purifier, Warden and Justicar spell coefficient data

[Fluxions]

http://www.unstablerift.com/?q=node/431

The spreadsheet referenced in the title is hosted on our guild website, linked above.

The above linked google docs spreadsheet contains tested coefficient values for all direct cleric healing spells in the Sentinel, Warden, Purifier and Justicar trees (unless I missed one!). These values were obtained through extensive in-game testing, and those spells that do not behave predictably had their formulas derived by linear regression. I recommend that you go to file: download a copy, and interact with it on your computer. If you don't have MS Excel or OpenOffice already, OpenOffice is a free, open source office suite with an excel-type program, available for download through openoffice.org.

A few things you should know:

> TPC= Time Proportionality Constant. This is each spell's unique spellpower coefficient.
The basic formula to calculate most heal values (those not highlighted in blue) is:

HEALVALUE = BASEHEAL + ((SPDMG*CASTTIME))*TPC.


> Some spells do not follow the above formula, instead following a unique linear relationship with spellpower. Unfortunately, Google Docs doesn't support graphs, so to view the linear regressions you'll need to either examine the formulas in the prediction cell, the tab with experimental values, or download a copy of the spreadsheet and load it in to Open Office or Excel to see the graph. Linear regressions relating heal value with SP, as well as logarithmic/exponential regressions relating heal value with TPC are provided. The linear regression is clearly superior (R>.999!).

>The purpose of this spreadsheet is solely to publicize coefficient data for common use and knowledge, NOT to serve as a simulator, hence why I don't include calculators for talents or crit values. I do have a simulator spreadsheet in progress, but it's not ready yet, ETA ~2 weeks as of this post.

> I did include an option to apply the Mein of Honor bonus because it makes Justicar heals worth casting. Without Mein, their coefficients and base values are awful, so it's hard to compare side-by-side.

> Once downloaded and opened in your own excel/openoffice suite, you can enter your SP and Mein in the boxes provided. The predicted heal values will recalculate accordingly. I tested each ability, but there is certainly room for error. PLEASE NOTE: IF YOU HAVE TALENTS THAT INCREASE SPELL EFFECTIVENESS, PREDICTED VALUES WILL NOT BE ACCURATE.

> The only exception to the above caps is Healing Benediction, because, de facto, you must have points in effectiveness to test the spell (51 pts). So the base value of the spell is adjusted and the TPC takes healing effectiveness into consideration by default.

> If you have ANY additional data, anything you find disagrees with my findings, or even any questions, I would love to hear from you. I'm only one person and there's certainly a possibility that i've found bugs, or i've made a mistake. The larger the data pool, the more reliable the conclusions, so please contribute!

[Foopy]

Thanks =) The data provided is fantastic.

[shroudb]

you have some error in your formula after H31 i think. you need to replace J# with J5 (probalbly you just auto fixed the formulas under there and they got messed up)

also healing breth is sent.

i also thing you mean healing bleesing and not caregiver's bleesing.

other than that very good job m8.

[VeroProDiGY]

Nice math, but a subpar presentation it's a little shaky to follow.

Fix up the presentation, and I give an A+

[Ashenne]

as a fellow number-cruncher i say great work.

any chance you or someone you know of has crunched out the coefficients for all the damage spells? since there isn't a lvl 35 target dummy i'd like to theorycraft out an optimal rotation and build for levelling clerics.

[Tukuturi]

This is excellent work, Fluxions. Thank you. It's nice to see something constructive on the cleric board.

[Fuinir]

I've done some formulas for my own use, and while the forecasting is the same, the method is not. Because they are different but arrive at the same values, I would like to know and understand your process. On the spreadsheet, it looks like the heal amount = Base value + (Cast Time*TPC)*(Spell power/5). How does that relate to the equation in the original post, and why did you choose to use this formula? And why is the spell power always divided by 5?

[Xeroskill]

Great Attempt - you do have some issues with your spreadsheet though (you got a little sloppy towards the end) you did a lot of calculations (lines H31-H38) multiplying by a blank cell. If you fix that though, your math looks pretty good

[Shiferbrains]

This is very useful. Thank you for your effort.

[Fluxions]

Thanks for the feedback and corrections, can't believe I missed some of those things

> Corrected cells not referencing SP as intended (in the H31+ area)
> Added experimental data for Healing Flame, not sure why this was deleted
> Moved Healing Breath to Sentinel
> Fixed spell name to Healing Blessing...I think this one needs further testing though, that is an ugly TPC.
> Realized Marked by the Light isn't present...will do that after work tonight.

I've done some formulas for my own use, and while the forecasting is the same, the method is not. Because they are different but arrive at the same values, I would like to know and understand your process. On the spreadsheet, it looks like the heal amount = Base value + (Cast Time*TPC)*(Spell power/5). How does that relate to the equation in the original post, and why did you choose to use this formula? And why is the spell power always divided by 5?

The equation you describe above is exactly the same, just reordered. Yours reads better though, so I'll be correcting mine to match As far as dividing by 5, if you mouse over spellpower in your character window in-game, the game calculates spell damage for you (SP/5) and explains that it increases the damage of spells by a certain amount per second. This SP appropriation method (multiplied by cast time) is also common in other games, so it made sense. It also produces absolutely beautiful results. I would arrive at the same TPC value *5 if I didn't adjust for SPDMG vs SP, but the alternative makes a lot more sense as far as the big picture is concerned.

I use SP in the regression formulas instead of spell damage to save myself a step. It's hideous either way, though.

[shroudb]

The equation you describe above is exactly the same, just reordered. Yours reads better though, so I'll be correcting mine to match As far as dividing by 5, if you mouse over spellpower in your character window in-game, the game calculates spell damage for you (SP/5) and explains that it increases the damage of spells by a certain amount per second. This SP appropriation method (multiplied by cast time) is also common in other games, so it made sense. It also produces absolutely beautiful results. I would arrive at the same TPC value *5 if I didn't adjust for SPDMG vs SP, but the alternative makes a lot more sense as far as the big picture is concerned.

I use SP in the regression formulas instead of spell damage to save myself a step. It's hideous either way, though.

or to say it more simply:

5sp=1dps

dps*cast time=raw value (from sp coefficient)

base value +raw value =damage

this is the general formula for ALL abilities in game as of now.

each individual's sp coefficient is then multiplied by a random %. The theorycraft here compiled all those coefficient for us who are to lazy to do 10casts *3 sp values to get the linear multiplier^^.

[Xeroskill]

Healing Breath is an instant cast, not a 1.5 second cast

[shroudb]

Healing Breath is an instant cast, not a 1.5 second cast

since gcd is 1.5sec, most instant spells calculate that for cast time

[Fluxions]

or to say it more simply:

5sp=1dps

dps*cast time=raw value (from sp coefficient)

base value +raw value =damage

this is the general formula for ALL abilities in game as of now.

each individual's sp coefficient is then multiplied by a random %. The theorycraft here compiled all those coefficient for us who are to lazy to do 10casts *3 sp values to get the linear multiplier^^.

That's another way to look at it. This is likely the general formula for all casted spells only, as melee abilities are subject to DR and much harder to test because of broad weapon damage ranges.

I did a lot more than 10*3 casts. When I originally started plotting values for the unusual spells, I wasn't sure what to expect, so I took recordings at 50-150 SP increments and plotted everything vs everything. I didn't start this project knowing that the most precise linear relationship would be between SP (or SPDMG) and heal value, I had to figure it out.

any chance you or someone you know of has crunched out the coefficients for all the damage spells? since there isn't a lvl 35 target dummy i'd like to theorycraft out an optimal rotation and build for levelling clerics.

Not yet, but people in guild have expressed interest and once I'm done with the simulator, I may do so. I know there are practice dummies for lowbies in Freemarch that you could use, but I'm not sure where.

[Wadis]

Bump for awesomeness.