Elitist Jerks - View Single Post

Bokomatic · 03/30/08, 7:46 AM

I've made a little spreadsheet for shammy healing.
I understand that everyone has his own spreadsheet for healing spells, but i discovered that some formulaes at wowwiki are incorrect, even based on blueposts. So i hope my spreadsheet may be useful for some1 just because there are checked numbers.

I've got Draezele's 'Shaman Healing Efficiency' spreadsheet, checked it, tested, removed mistakes and modified.

Original article + spreadsheet:
Draezele's Spreadsheet
Draezele's Article

My spreadsheet (without macros, pure XLS):
RestoShammySpells_v240_20080330.zip

RestoShammySpells.xls calculates Avg.Healed, HPS, HPM, MP5 spent for each valuable shammy's heal.
In addition the real HPS depending on current MP5/Manapool/Time of fight calculated for each spell.

Sheets:
'Notes' - just notes ^^
'HPM;HPS' - complex table for calculating HPS, HPM, Avg.Healing and other
'2.4 check' - results of checking spells after patch 2.4
'Coeff' - table for different kinds of scaling HPS/+healing, HPM/+healing
'HS/ES coeff' - experimantal data and calculations of coefficients for Healing Stream and Earth Shield
'DR coeff' - just table of right downranking penalties

All formulaes and coefficients were checked by series of ingame experiments.
The method was based on minimal/maximal amount healed by spell.

For example:
I have formulae for Lesser Healing Wave Rank2. I calculate minimal and maximal amount healed [744.4;782.9]
I reset data in Recap addon and start using LHW2 on myself, Recap shows me minimal and maximal heals from this test. If formulae is incorrect real values dont match theoretical ones. If its right real values are in the theoretical bracket. In my case real values are [745;783]. So i make a decision that formulae are right.

Note1:
Downranking penalties at wowwiki are incorrect. And original blizzard posts are incorrect too.
([Level at which next higher rank of Spell is Learned] + 5) / [Character Level] = [Downranking Coefficient]
This formula doesn’t match real data.

wowwiki # downranking

The right formula for lvl70 character is: ([Level Learned] + 11) / 70
Some clever pala discovered and checked it 1st, and ive checked it for shammy. It works nice.

Original paladin post is here:
elitistjerks.com # downranking test

Note2:
I found lots of incorrect numbers for Earth Shield and Healing Stream at wowwiki.

wowwiki # Earth_Shield
There is incorrect scaling coefficient (30%). Real is 28.6% per tick.

wowwiki.com # Healing_Stream_Totem
Incorrect scaling coefficient too (6%). Real is 4.4% per tick. In addition Healing Stream is affected by Purification talent.

www.wowwiki.com # Healing_Comparison
As result the final table is incorrect about ES and HST too.

Note3:
On use effects, relics, haste and "5 second rule" arent intended in spreadsheet yet.
So this spreadsheed may be useful by right(checked) coefficient numbers.

Note4:
28.03.2008 Corrected Earth Shield in the tables due to changes in 2.4 patch.
I've discovered that Blizzard changed coefficient for ES Rank1. Old one was 28.6%, new one is 26.55% per tick

((
It seems Blizzard applied downranking penalty to ES1 as to lvl54 spell. And didnt tip it in patchnotes, hehe

I hope it can be useful for someone. Thnx 4 attention.

03/30/08, 7:46 AM	#839 (permalink)
Bokomatic Glass Joe Boko Orc Shaman <Red Army> Lightbringer (EU)	I've made a little spreadsheet for shammy healing. I understand that everyone has his own spreadsheet for healing spells, but i discovered that some formulaes at wowwiki are incorrect, even based on blueposts. So i hope my spreadsheet may be useful for some1 just because there are checked numbers. I've got Draezele's 'Shaman Healing Efficiency' spreadsheet, checked it, tested, removed mistakes and modified. Original article + spreadsheet: Draezele's Spreadsheet Draezele's Article My spreadsheet (without macros, pure XLS): RestoShammySpells_v240_20080330.zip RestoShammySpells.xls calculates Avg.Healed, HPS, HPM, MP5 spent for each valuable shammy's heal. In addition the real HPS depending on current MP5/Manapool/Time of fight calculated for each spell. Sheets: 'Notes' - just notes ^^ 'HPM;HPS' - complex table for calculating HPS, HPM, Avg.Healing and other '2.4 check' - results of checking spells after patch 2.4 'Coeff' - table for different kinds of scaling HPS/+healing, HPM/+healing 'HS/ES coeff' - experimantal data and calculations of coefficients for Healing Stream and Earth Shield 'DR coeff' - just table of right downranking penalties All formulaes and coefficients were checked by series of ingame experiments. The method was based on minimal/maximal amount healed by spell. For example: I have formulae for Lesser Healing Wave Rank2. I calculate minimal and maximal amount healed [744.4;782.9] I reset data in Recap addon and start using LHW2 on myself, Recap shows me minimal and maximal heals from this test. If formulae is incorrect real values dont match theoretical ones. If its right real values are in the theoretical bracket. In my case real values are [745;783]. So i make a decision that formulae are right. Note1: Downranking penalties at wowwiki are incorrect. And original blizzard posts are incorrect too. ([Level at which next higher rank of Spell is Learned] + 5) / [Character Level] = [Downranking Coefficient] This formula doesn’t match real data. wowwiki # downranking The right formula for lvl70 character is: ([Level Learned] + 11) / 70 Some clever pala discovered and checked it 1st, and ive checked it for shammy. It works nice. Original paladin post is here: elitistjerks.com # downranking test Note2: I found lots of incorrect numbers for Earth Shield and Healing Stream at wowwiki. wowwiki # Earth_Shield There is incorrect scaling coefficient (30%). Real is 28.6% per tick. wowwiki.com # Healing_Stream_Totem Incorrect scaling coefficient too (6%). Real is 4.4% per tick. In addition Healing Stream is affected by Purification talent. www.wowwiki.com # Healing_Comparison As result the final table is incorrect about ES and HST too. Note3: On use effects, relics, haste and "5 second rule" arent intended in spreadsheet yet. So this spreadsheed may be useful by right(checked) coefficient numbers. Note4: 28.03.2008 Corrected Earth Shield in the tables due to changes in 2.4 patch. I've discovered that Blizzard changed coefficient for ES Rank1. Old one was 28.6%, new one is 26.55% per tick (( It seems Blizzard applied downranking penalty to ES1 as to lvl54 spell. And didnt tip it in patchnotes, hehe I hope it can be useful for someone. Thnx 4 attention. Last edited by Bokomatic : 03/30/08 at 8:13 AM.