Spell-Coefficients, Downranking penalty, Math vs Reality

WoW Classic WoW Classic General Discussion
1

Hello,

I was making a spreadsheet in which I would be able to calculate the the anticipated healing done of different ranks of shaman healing spells. What i found is my calulations are consistently higher than the actual healing done of my spells in game.

So i would like to ask ppl who knows how to calc these to help me find the error because I’m out of ideas.

The base Spell-Coefficient calc should be: base cast time/3,5.
Downranking penatly should be: 1-((20-Spell level learned)*0,0375).

In my healing power gear i have 756 +healing done.

I’m deep resto so i have Purifucation 5/5 for 10% healing done also I have Healing way which is another 18% healing done on healing wave.

Healing Wave R3 Base cast time is 2,5 sec so it’s coeff should be 2,5/3,5=~0,714
It’s a lvl 12 spell so the downranking penalty should be 1-((20-12)*0,0375)=0,7
It’s avarage healing done is (150+179)/2=164,5

So the avarage healing done should be
(0,714 * 0,7 * (756 + 164,5)) * 1,1 * 1,18=~597,4 = 597 according to my calculation.
Yet the actual avarage in game healing is ~570.

Of R4 the overall healing done should be
Spell Coeff 3/3,5=~0,857
Downranking penalty 1-((20-18)*0,0375)=0,925
AvG Healing done (307+361)/2=334

(0,857 * 0,925 * (756 + 334)) * 1,1 * 1,18= 1121,75 = 1122
Yet the actual avarage in game healing is ~1000

Of R5
Spell Coeff 3/3,5=~0,857
No downranking penalty
AvG Healig done (428+499)/2=463,5

(0,857 * (756 + 463,5)) * 1,1 * 1,18=1356,781=1357
Yet the actual avarage in game healing is ~1200

I didn’t calculate the criticals into the avarage healing done.
If anybody knows how to solve this i would be glad to hear it.
Thank you for reading it this far and have a nice day even if you can’t contribute.

2

R3
((0,7 * (0,714 * 756+ 1,18 * 164,5) )* 1,1 = 565

Only played healer on 1.12 servers but talents like healing way, healing light etc only affected the base healing of the spell, the Spell power coefficient should not affect the base healing of the spell

1 Like
3

I see, thank you!

If i were to apply this formula to higher than R3 it would still go over the actual healing done by less of a margin:

R4
(0,925 * (0,857 * 756 + 1,18 * 334) * 1,1) = 1060,247 = 1060
The actual healing done is between 971-1023 ± 2

On R5
(0,857 * 756 + 1,18 * 463,5) * 1,1 = 1314,304 = 1314
The actual healing done is between 1181-1236 ± 16

4

I talked to a shaman in my guild he said purification only affects the base healing of the spell but was not sure of healing way.

Assuming both are only baseline:
(0,925 * (0,857 * 756 + 1,1 * 334* 1,18) = 1000
R4 range is as u stated: 361-307 = 54
1000 ± 54/2 = 974-1026

5

Yes, it seems that it’s close but still misses the mark on R5

(0,857 * 756 + 1,1 * 1,18 * 463,5) = 1249,515 = 1250
R5s range is 499-428 = 71
1250 ± 71/2 = 1215-1286

But just now as i was testing it the highest range was between 1237 - 1154 which is superiour to 71 so idk what to think right now. I didn’t change the +healing and i had the 3 stacks of healing way when both of these happened.

6

R5
min: (0,857 * 756 + 1,1 * 1,18 * 376) = 1136
max: (0,857 * 756 + 1,1 * 1,18 * 441) = 1220

or if healing way affects all spell power based healing:

min: (0,857 * 756 + 1,1* 376) * 1,18 = 1252
max: (0,857 * 756 + 1,1 * 441) * 1,18 = 1336

7

Found the error, i took my spell description as a unmodified number but that’s not the case. It’s been already multiplied by 10%, the normal value is 454-389 according to wowhead in the case of R5.

So it should be
min:(0,857 * 756 + 1,1 * 1,18 * 389)=1152,814=1153
max:(0,857 * 756 + 1,1 * 1,18 * 545)=1237,184=1237
For R5 it should work like that
R4
min:(0,857 * 0,925 * 756 + 1,18 * 1,1 * 279)=961,442=961
max:(0,857 * 0,925 * 756 + 1,18 * 1,1 * 328)=1025,044=1025
This seems to work too
R3
min:(0,714 * 0,7 * 756 + 1,1 * 1,18 * 136)=554,376=554
max:(0,714 * 0,7 * 756 + 1,1 * 1,18 * 163)=589,422=589
Seems to fit too

Thank you for you help, may you have a nice day!

8

go on your gut feeling try Everything till u feel something feels right this math stuff is not gonna work sorry

9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.