[Resto] spreadsheets and calculations - Page 5

Zigizi · 02/23/10, 12:50 PM

Originally Posted by stassart

Anyone else having any luck figuring out the exact mechanics behind the T10 4-piece? My delay releasing T10 4-piece support for shaman_hep has been trying to get the results to match what the calculations expect them to be.

...

I am trying to find the conditions that cause it not to match the expected value so that I can determine exactly how T10 4-piece scales with SP.

Stass, I am planning on doing a run tonight with the 4 piece set and I should be able to provide logs afterwards. Are there any particular conditions I should attempt to simulate, or conflicting trinket/procs I should avoid? I'm eager to help out on gathering this data in any way I can.

stassart · 02/23/10, 5:32 PM

Originally Posted by Zigizi

Stass, I am planning on doing a run tonight with the 4 piece set and I should be able to provide logs afterwards. Are there any particular conditions I should attempt to simulate, or conflicting trinket/procs I should avoid? I'm eager to help out on gathering this data in any way I can.

I believe I have plenty of 4-piece logs to work with. It is a matter of figuring out what the rules are for the T10 4-piece.

Here are a couple examples where the behavior is not consistent:

2/17 18:05:34.562  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x10514,55459,"Chain Heal",0x8,12590,12590,0,1
(hop1: 1049.2)
2/17 18:05:35.343  SPELL_AURA_APPLIED,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x10514,70809,"Chain Heal",0x8,BUFF
2/17 18:05:38.437  SPELL_PERIODIC_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x10514,70809,"Chain Heal",0x8,1049,1049,0,nil
(matches expected 1049.2)
2/17 18:05:41.421  SPELL_PERIODIC_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x10514,70809,"Chain Heal",0x8,1050,1050,0,nil
(matches expected 1049.2)
2/17 18:05:42.218  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x10514,55459,"Chain Heal",0x8,12462,12462,0,1
(hop1: 1038.5, total: 2087.7)
2/17 18:05:43.000  SPELL_AURA_REFRESH,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x10514,70809,"Chain Heal",0x8,BUFF
2/17 18:05:46.187  SPELL_PERIODIC_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x514,70809,"Chain Heal",0x8,1388,1388,0,nil
(does not match expected 2087)

2/17 18:06:33.343  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002353224,"Savvant",0x514,55459,"Chain Heal",0x8,4506,0,0,1
2/17 18:06:33.343  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x514,55459,"Chain Heal",0x8,7570,0,0,1
2/17 18:06:33.343  
SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x10514,55459,"Chain Heal",0x8,12533,3533,0,1
(hop1: 1044.4)
2/17 18:06:34.156  SPELL_AURA_APPLIED,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x10514,70809,"Chain Heal",0x8,BUFF
2/17 18:06:35.703  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x03000000017C03D8,"Gnomesrtasty",0x514,55459,"Chain Heal",0x8,3005,2171,0,nil
2/17 18:06:35.703  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000115C7CC,"HarlÃ¶t",0x514,55459,"Chain Heal",0x8,7627,6343,0,1
2/17 18:06:35.703  
SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x514,55459,"Chain Heal",0x8,12472,12472,0,1
(hop1: 1039.3, total: 2083.7)
2/17 18:06:36.421  SPELL_AURA_REFRESH,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x514,70809,"Chain Heal",0x8,BUFF
2/17 18:06:39.609  SPELL_PERIODIC_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x514,70809,"Chain Heal",0x8,2084,2084,0,nil
(matches expected 2083.7)
2/17 18:06:41.765  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x514,55459,"Chain Heal",0x8,4511,2182,0,1
2/17 18:06:41.765  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x03000000030B333B,"Taal",0x10514,55459,"Chain Heal",0x8,7627,1211,0,1
2/17 18:06:41.765  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x030000000425368F,"Kilromi",0x514,55459,"Chain Heal",0x8,8401,8401,0,nil
(hop3: 375.9, total: 2459.7)
2/17 18:06:42.484  SPELL_AURA_REFRESH,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x514,70809,"Chain Heal",0x8,BUFF
2/17 18:06:44.468  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x10514,55459,"Chain Heal",0x8,7588,2995,0,1
2/17 18:06:44.468  SPELL_HEAL,0x0300000000226850,"Trelis",0x511,0x03000000030B333B,"Taal",0x514,55459,"Chain Heal",0x8,8391,8391,0,nil
(hop2: 632.3, total: 3092)
2/17 18:06:44.921  SPELL_AURA_REFRESH,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x10514,70809,"Chain Heal",0x8,BUFF
2/17 18:06:47.859  SPELL_PERIODIC_HEAL,0x0300000000226850,"Trelis",0x511,0x0300000002E5CE1E,"Content",0x514,70809,"Chain Heal",0x8,2397,0,0,nil
(does not match expected 3092)

Edit: Thank you very much Micah! It seems that it behaves exactly as your post below describes.

Micah · 02/24/10, 12:46 PM

I only worked through the first example but it seems to work just like scorch or deep wounds does IIRC. Basically, whatever amount of healing gained by the CH crit bonus that is left when the buff reapplies gets added to the new value and redistributed.

t0: 12590 Chain Heal Direct Crit
t1: (12590 * 0.25) = 3148 25% of CH crit, rounded
t4: 3148/3 = 1049 First tick of 3 from the CH crit, 2099 remaining to heal
t7: 3148/3 = 1050 Second tick of 3 from the CH crit, smart rounded, 1049 remaining to heal
t8: 12462 Chain Heal Direct Crit
t9: ((12462 * 0.25) + 1049) = (3116 + 1049) = 4165 25% of CH crit plus remaining amount to heal, rounded
t12: 4165/3 = 1388 First tick of 3 from the amount of CH crit bonus to heal, matches combat log

Using this method appears to be in line with at least the first combat log example.

EDIT: Worked through the second example and I get the same result as the combat log using the above method.

stassart · 02/25/10, 11:45 AM

Thanks Micah, that really helped.

I have a found a few inconsistencies with the way it works for anyone interested.

t0: chain heal crit
t1: chain heal hot applied
t2: chain heal hot tick from t0
t3: chain heal crit
t4: chain heal hot tick from t0
t5: chain heal hot refresh

Sometimes the t4 hot tick will count when reducing the remaining amount of the previous hot, and sometimes it does not.

t0: chain heal crit
t1: chain heal hot applied
t2: chain heal hot tick from t0
t3: chain heal hot tick from t0
t4: chain heal crit
t5: chain heal hot tick from t0
t6: chain heal hot t0 removed
t7: chain heal hot t4 applied

When this occurs 1/3 of the t0 hot tick sometimes carries over to the t4 hot.

Both of these situations cause it to have higher output so no complaints.