Paladin Healing Spreadsheet

Karakas · 02/15/07, 6:43 PM

I haven't really seen one of these around, so I decided to make a spreadsheet to help me analyze Paladin healing with all the new spell coefficients that came with v. 2.0. Here is the link to the file:

http://www.savefile.com/files/494688

NOTE: this spreadsheet is in BETA 1.0. It may be buggy, there may be mathematical errors, and it's probably not that appeasing to the eye.

Any and all feedback on this project is welcome. I hope to eventually develop this thing into something that's easy to use and is extremely powerful as well, so I guess that all starts with this.

If you have any questions, feel free to post them as well, hopefully this project isn't too much of a disgrace for these forums ;)

Fiola · 02/15/07, 7:19 PM

Would be nice to have a box for FoL only +heal or HL only +heal, since we have librams that boost one or the other by different amounts.

Also, you didn't seem to have Light's Grace as an option for the talent list? (-.5 second cast time to Holy Light) That changes the number for HL healing by quite a bit.

One last thing - I'm not sure how to use the talent stat options. Do I just put in the # of points I have in a given talent? It seems that the numbers the spreadsheet calculates are a bit off from what a quick in game heal gives me.

Karakas · 02/15/07, 8:08 PM

Originally Posted by Fiola

Would be nice to have a box for FoL only +heal or HL only +heal, since we have librams that boost one or the other by different amounts.

That can be worked in very easily.

Originally Posted by Fiola

Also, you didn't seem to have Light's Grace as an option for the talent list? (-.5 second cast time to Holy Light) That changes the number for HL healing by quite a bit.

Stupid oversight on my part.

Originally Posted by Fiola

One last thing - I'm not sure how to use the talent stat options. Do I just put in the # of points I have in a given talent? It seems that the numbers the spreadsheet calculates are a bit off from what a quick in game heal gives me.

Yea, just putting in the number of points you have in the talent should work. Is there anything specific that you are getting discrepencies on? Specific ranks, or heals? I can double check my formulae real fast but everything should be correct...

Fiola · 02/16/07, 7:44 PM

Originally Posted by Karakas

Originally Posted by Fiola

One last thing - I'm not sure how to use the talent stat options. Do I just put in the # of points I have in a given talent? It seems that the numbers the spreadsheet calculates are a bit off from what a quick in game heal gives me.

Yea, just putting in the number of points you have in the talent should work. Is there anything specific that you are getting discrepencies on? Specific ranks, or heals? I can double check my formulae real fast but everything should be correct...

Just the libram not getting accounted for, I think.

For user friendliness, might wanna indicate how to enter the talent stuff. = P

Zhorx · 02/16/07, 10:28 PM

Your MP5 colums seems buggy and you didn't describe that it's the added effect of crit and MP5 counted as some sort of equivalent MP5 value, the reason for it not working is the J column in Healmath not updating correctly when changing the crit chance. Bonus damage added from critical heals is not added anywhere.

I did something similar a few days ago, took a slightly different approach on the crit and MP5 issue.
http://forums.wow-europe.com/thread....52325476&sid=1
Or simply:
http://files.filefront.com/Pallyheal.../fileinfo.html
for the spreadsheet.