Post by Sokanon on Apr 27, 2011 4:34:19 GMT -5
Author: pwnedmark
For now, I am just trying to get this test spreadsheet out there for feedback from the community. I start off expecting a multitude of errors that need fixed and many additions that need to be made. That being said, here's what I've got:
spreadsheets.google.com/ccc?key=0AnktlND72hU4dE5hc0hENTg3T2Z3aTljbGlxenRJemc&hl=en&authkey=CMT85_oH#gid=0
So far I've compiled a list of every piece of gear I could get my hands on. Chain, cloth, crit, spell power, everything I could find. It has been entered by slot and displayed are its major stats and armor type, along with where you can obtain the piece.
What I would appreciate is people to help me look it over and catch any mistakes that may have been made with entering numbers, or pieces that i've left out completely.
Next, after some repetitive dummy testing I obtained some coefficients for different healing spells. My findings were:
Resorative flame - 1.2 * spell power
Healing Invocation - 1.38 * spell power
These are total coefficients derived simply from Heal minus the tooltip of the ability, divided by the spell power which was then varied up and down over many levels.
How I put these numbers to use was forming them into EP weights for spell power and crit. Knowing that this is very rough, I ask you to bear with me through the ep weight calculation. It is based thusly:
Current model spec:rift.zam.com/en/stc.html?t=10Gje.E0oEcxzoz.E0x0fstco
*Note*-I will gladly discuss specs in this thread with anyone. This is simply a spec that I use for modeling.
Spell rotation: Healing Invocation (50%), Restorative Flame (50%)
(This basis denotes the fight purely consisting of casting each spell back and forth endlessly. I realize it may sound silly, but a model must start somewhere)
One of the biggest hurdles was theorycrafting a model for Serendipity. Here it goes:
((crit - (crit*crit))(1.7)*[base(h) + coefficient*spell power] + (1-(crit+(crit-(crit*crit))))[base(h) + coefficient*spell power] + 2*(crit*crit)(1.7)*[base(h)+coefficient*spell power] + (1.5)*(crit-(crit*crit)[base(h)+coefficient*spell power]
This was then adjusted for an additional 0.6sp increase for Resto flames, and Healing Invo was increased as total healing by 1.3.
I would certainly love feedback on anything and everything. The EP weight is very very rudimentary and requires much more work before it's even close to done, but so far it has shed light on how gear really is matching up.
As for the rest, I will continue to add to and edit this OP to explain the rest of the major characteristics of the spreadsheet and my calculations.
Original link: forums.riftgame.com/showthread.php?176651-Very-rough-Cleric-gear-and-stat-value-spreadsheet-(Healing-Theorycrafting)
pwnedmark said:
For now, I am just trying to get this test spreadsheet out there for feedback from the community. I start off expecting a multitude of errors that need fixed and many additions that need to be made. That being said, here's what I've got:
spreadsheets.google.com/ccc?key=0AnktlND72hU4dE5hc0hENTg3T2Z3aTljbGlxenRJemc&hl=en&authkey=CMT85_oH#gid=0
So far I've compiled a list of every piece of gear I could get my hands on. Chain, cloth, crit, spell power, everything I could find. It has been entered by slot and displayed are its major stats and armor type, along with where you can obtain the piece.
What I would appreciate is people to help me look it over and catch any mistakes that may have been made with entering numbers, or pieces that i've left out completely.
Next, after some repetitive dummy testing I obtained some coefficients for different healing spells. My findings were:
Resorative flame - 1.2 * spell power
Healing Invocation - 1.38 * spell power
These are total coefficients derived simply from Heal minus the tooltip of the ability, divided by the spell power which was then varied up and down over many levels.
How I put these numbers to use was forming them into EP weights for spell power and crit. Knowing that this is very rough, I ask you to bear with me through the ep weight calculation. It is based thusly:
Current model spec:rift.zam.com/en/stc.html?t=10Gje.E0oEcxzoz.E0x0fstco
*Note*-I will gladly discuss specs in this thread with anyone. This is simply a spec that I use for modeling.
Spell rotation: Healing Invocation (50%), Restorative Flame (50%)
(This basis denotes the fight purely consisting of casting each spell back and forth endlessly. I realize it may sound silly, but a model must start somewhere)
One of the biggest hurdles was theorycrafting a model for Serendipity. Here it goes:
((crit - (crit*crit))(1.7)*[base(h) + coefficient*spell power] + (1-(crit+(crit-(crit*crit))))[base(h) + coefficient*spell power] + 2*(crit*crit)(1.7)*[base(h)+coefficient*spell power] + (1.5)*(crit-(crit*crit)[base(h)+coefficient*spell power]
This was then adjusted for an additional 0.6sp increase for Resto flames, and Healing Invo was increased as total healing by 1.3.
I would certainly love feedback on anything and everything. The EP weight is very very rudimentary and requires much more work before it's even close to done, but so far it has shed light on how gear really is matching up.
As for the rest, I will continue to add to and edit this OP to explain the rest of the major characteristics of the spreadsheet and my calculations.
Original link: forums.riftgame.com/showthread.php?176651-Very-rough-Cleric-gear-and-stat-value-spreadsheet-(Healing-Theorycrafting)