Originally Posted by Skyhoof

The three-piece set bonus of Ten Storms is “increases the amount healed by Chain Heal to targets beyond the first by 30%”

I couldn’t download the actual spreadsheet but I worked out what formula you used to calculate the set bonus:

Total Healing = T1 + (T1*0.5)*1.3+ [(T1*0.5)*1.3]*0.5*1.3

T1= Healing done to Target #1

I believe the correct formula is:
Total Healing = T1 + (T1*0.5)*1.3+ (T1*0.25)*1.3

If I understand the set bonus correctly, the plus 30% is applied seperately to each jump beyond the first. You can’t divide the healing done on the second jump in half and then add 30%. You need to take 25% of the first heal and then multiply by 30%. Otherwise, you are double counting the 30% boost.

Also, your values do not include the Tier 6 set bonus. The mana cost you list are the normal mana costs with talents. You need to include those T6 set bonuses in your calculations -- and drink more coffee If I can find the time, I will do the math and post the results (properly coded for easy reading).