Increasing Gains Formula?

[Oaks]

Does anyone with more math skills than me (doesn't take much) know the formula to calculate the damage for something like charged bolt with just the skill level? It's a linear gain, with the exception of a jump in the actual gain every 16 levels. For some skills, it's every 8 levels. Anyhow, I imagine someone has asked this question before or has worked this out... I just couldn't find it. Any help would be greatly appreciated.

-- Oaks

[Guest]

Gee, writing down the formula is kinda complicated. Just a per level change I've made as:

=((((B5*0)+(C5*0)+(D5*0)+(E5*0)+(F5*0)+A5)+((B7*0)+(C7*0)+(D7*0)+(E7*0)+(F7*0)+A7))*A9*H5)/2

...Which doesn't include the synergy part. That doesn't make sense without the .xls, I know. The entire formula would be ~7x longer than that.

Here's a calculator for all spells, if that's all you wanted to know. For 1.10 that is.

[Zallambo]

Well, I have two things to say. First, it is only linear if you count the damage per BOLT. If you count the full damage, it would be the number of bolts * the dmg/bolt. This is basically exponential (dmg=lvl*lvl [lvl^2]). If you are completely devoid of any knowledge of algebra, that means that as the slvl gets bigger, the full dmg gets a LOT bigger. This is one of the things that makes CB awsome.

However, since the dmg of cb is determined by things that switch back and forth (the number of bolts, 3,3,4,4,5,5 i believe, as well as the changes at lvl 9 and 17 or whatever they are), you can't write and equation for the damage. Actually, If you have a TI-83 calculator, I believe you could enter in the data and find an equation that matched it pretty closely.

But anyways, what was your question? Can you write an equation for it? no.

[Zath]

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.