10-29-2003, 12:59 PM
You can write an equation for it, but you'll have to use a lot of if-statements. Spell damage isn't determined with a single equation in game, and there are 6 break points for minimum damage, another 6 for maximum damage, plus one HitShift value. Your single equation would then somewhat like this:
=IF($B10<=8, C9+$D$4, IF($B10<=16, C9+$E$4, IF($B10<=22, C9+$F$4, IF($B10<=28, C9+$G$4, C9+$H$4))))*min(24, 3+$B10)
And that's just for minimum damage without HitShift. You'll have to repeat it again for maximum damage before you can get an average. I think it's much easier to just list everything in a table instead:
Level_____MinD_____MaxD_____AvgD_____Bolts_____Total_____LM_______MaxSyn
1_________2________4________3________3_________9_________14_______30
2_________2.5______4.5______3.5______4_________14________23_______50
3_________3________5________4________5_________20________35_______77
4_________3.5______5.5______4.5______6_________27________50_______110
5_________4________6________5________7_________35________69_______152
6_________4.5______6.5______5.5______8_________44________92_______203
7_________5________7________6________9_________54________120______264
8_________5.5______7.5______6.5______10________65________152______335
9_________6________8________7________11________77________189______417
10________6.5______8.5______7.5______12________90________232______511
11________7________9________8________13________104_______281______618
12________7.5______9.5______8.5______14________119_______336______738
13________8________10_______9________15________135_______397______873
14________8.5______10.5_____9.5______16________152_______465______1023
15________9________11_______10_______17________170_______541______1189
16________9.5______11.5_____10.5_____18________189_______624______1372
17________10.5_____12.5_____11.5_____19________218.5_____747______1644
18________11.5_____13.5_____12.5_____20________250_______885______1947
19________12.5_____14.5_____13.5_____21________283.5_____1038_____2283
20________13.5_____15.5_____14.5_____22________319_______1206_____2653
21________14.5_____16.5_____15.5_____23________356.5_____1390_____3059
22________15.5_____17.5_____16.5_____24________396_______1592_____3502
23________17_______19_______18_______24________432_______1788_____3935
24________18.5_____20.5_____19.5_____24________468_______1994_____4386
25________20_______22_______21_______24________504_______2208_____4857
26________21.5_____23.5_____22.5_____24________540_______2430_____5346
27________23_______25_______24_______24________576_______2661_____5854
28________24.5_____26.5_____25.5_____24________612_______2901_____6382
29________26.5_____28.5_____27.5_____24________660_______3208_____7057
30________28.5_____30.5_____29.5_____24________708_______3526_____7757
31________30.5_____32.5_____31.5_____24________756_______3856_____8482
32________32.5_____34.5_____33.5_____24________804_______4197_____9233
33________34.5_____36.5_____35.5_____24________852_______4550_____10009
34________36.5_____38.5_____37.5_____24________900_______4914_____10811
35________38.5_____40.5_____39.5_____24________948_______5290_____11638
36________40.5_____42.5_____41.5_____24________996_______5677_____12490
37________42.5_____44.5_____43.5_____24________1044______6076_____13367
38________44.5_____46.5_____45.5_____24________1092______6486_____14270
39________46.5_____48.5_____47.5_____24________1140______6908_____15198
40________48.5_____50.5_____49.5_____24________1188______7342_____16152
MinD: Minimum damage per bolt
MaxD: Maximum damage per bolt
AvgD: Average damage per bolt
Bolts: Number of bolts released
Total: Average damage multiplied by number of bolts released
LM: Total damage multiplied by Lightning Mastery of the same level
MaxSyn: Post mastery damage multiplied by max synergy bonus
Notice that the damage progression pass level 28 will remain linear, so you can extrapolate that to higher levels if you wish.
=IF($B10<=8, C9+$D$4, IF($B10<=16, C9+$E$4, IF($B10<=22, C9+$F$4, IF($B10<=28, C9+$G$4, C9+$H$4))))*min(24, 3+$B10)
And that's just for minimum damage without HitShift. You'll have to repeat it again for maximum damage before you can get an average. I think it's much easier to just list everything in a table instead:
Level_____MinD_____MaxD_____AvgD_____Bolts_____Total_____LM_______MaxSyn
1_________2________4________3________3_________9_________14_______30
2_________2.5______4.5______3.5______4_________14________23_______50
3_________3________5________4________5_________20________35_______77
4_________3.5______5.5______4.5______6_________27________50_______110
5_________4________6________5________7_________35________69_______152
6_________4.5______6.5______5.5______8_________44________92_______203
7_________5________7________6________9_________54________120______264
8_________5.5______7.5______6.5______10________65________152______335
9_________6________8________7________11________77________189______417
10________6.5______8.5______7.5______12________90________232______511
11________7________9________8________13________104_______281______618
12________7.5______9.5______8.5______14________119_______336______738
13________8________10_______9________15________135_______397______873
14________8.5______10.5_____9.5______16________152_______465______1023
15________9________11_______10_______17________170_______541______1189
16________9.5______11.5_____10.5_____18________189_______624______1372
17________10.5_____12.5_____11.5_____19________218.5_____747______1644
18________11.5_____13.5_____12.5_____20________250_______885______1947
19________12.5_____14.5_____13.5_____21________283.5_____1038_____2283
20________13.5_____15.5_____14.5_____22________319_______1206_____2653
21________14.5_____16.5_____15.5_____23________356.5_____1390_____3059
22________15.5_____17.5_____16.5_____24________396_______1592_____3502
23________17_______19_______18_______24________432_______1788_____3935
24________18.5_____20.5_____19.5_____24________468_______1994_____4386
25________20_______22_______21_______24________504_______2208_____4857
26________21.5_____23.5_____22.5_____24________540_______2430_____5346
27________23_______25_______24_______24________576_______2661_____5854
28________24.5_____26.5_____25.5_____24________612_______2901_____6382
29________26.5_____28.5_____27.5_____24________660_______3208_____7057
30________28.5_____30.5_____29.5_____24________708_______3526_____7757
31________30.5_____32.5_____31.5_____24________756_______3856_____8482
32________32.5_____34.5_____33.5_____24________804_______4197_____9233
33________34.5_____36.5_____35.5_____24________852_______4550_____10009
34________36.5_____38.5_____37.5_____24________900_______4914_____10811
35________38.5_____40.5_____39.5_____24________948_______5290_____11638
36________40.5_____42.5_____41.5_____24________996_______5677_____12490
37________42.5_____44.5_____43.5_____24________1044______6076_____13367
38________44.5_____46.5_____45.5_____24________1092______6486_____14270
39________46.5_____48.5_____47.5_____24________1140______6908_____15198
40________48.5_____50.5_____49.5_____24________1188______7342_____16152
MinD: Minimum damage per bolt
MaxD: Maximum damage per bolt
AvgD: Average damage per bolt
Bolts: Number of bolts released
Total: Average damage multiplied by number of bolts released
LM: Total damage multiplied by Lightning Mastery of the same level
MaxSyn: Post mastery damage multiplied by max synergy bonus
Notice that the damage progression pass level 28 will remain linear, so you can extrapolate that to higher levels if you wish.