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!