Battle Calculator
Elemental Forums
With a view to being able to number crunch easily for balancing mods I've started to put together a battle calculator spreadsheet in excel using Derek's post here as a basis.
Trouble is, the numbers don't really stack up and I was hoping for a little guidance on what had been changed please.
My calculations are based along the following lines:
Unit stats:
- str = Strength
- dex = Dexterity
- con = Constitution
- lvl = Level
Weapon stats:
- w_att = attack factor
- w_hit = To hit bonus
- w_ddg = Dodge bonus
- w_def = Defense bonus
Armour stats:
- a_att = attack factor
- a_hit = To hit bonus
- a_ddg = Dodge bonus
- a_def = Defense bonus
Constants:
- ba = Base accuracy = 15
- al = Accuracy level multiplier = 3
- dd = Dodge dexterity divisor = 2
- sm = Attack strength subtraction = 10
- sf = Attack strength divisor = 10
- dm = Defense dexterity subtraction = 10
- df = Defense dexterity divisor = 10
- hb = Base hit points = 10
- hc = Hit point constitution divisor = 5
- hl = Hit point level multiplier = 2
Base Calculations:
- acc = Accuracy = ba + (lvl * al) + w_hit + a_hit
- ddg = Dodge = (dex / dd) + w_ddg + a_ddg
- att = Attack = w_att + a_att + ((str - sm) / sf)
- def = Defence = a_def + w_def + ((dex - dm) / df)
- hp = Hit Points = hb + ((con / hc) * (lvl * hl))
- rs = Retaliation strikes = ???
Applied Calculations:
- To Hit Percentage = (acc1 / (acc1 + ddg2)) * 100
- Minimum damage = ???
- Maximum damage = ???
- Average damage = ???
Ive tested this in-game and some of the results are a little off. Taking a spearman in enemy territory fighting against an enemy spearman the figures are as follows:
Spearman1:
- str = 10
- dex = 10
- con = 10
- lvl = 4
Weapon stats:
- w_att = 9
Armour stats:
- a_def = 2
Base Calculations:
- acc = Accuracy = 27
- ddg = Dodge = 5
- att = Attack = 9
- def = Defence = 2
- hp = Hit Points = 26
Applied Calculations:
- To Hit Percentage = 84% (actual 91%)
- Minimum damage = ??? (actual 1)
- Maximum damage = ??? (actual 8)
- Average damage = ??? (actual 4.5?)
EnemySpearman2:
- str = 10
- dex = 10
- con = 5
- lvl = 1
Weapon stats:
- w_att = 10
Armour stats:
- a_def = 5
Base Calculations:
- acc = Accuracy = 18
- ddg = Dodge = 5
- att = Attack = 10
- def = Defence = 5
- hp = Hit Points = 12
Applied Calculations:
- To Hit Percentage = 78% (actual 86%)
- Minimum damage = ??? (actual 6)
- Maximum damage = ??? (actual 9)
- Average damage = ??? (actual 7.5?)
So what I currently don't get is:
1. Why are the to-hit calculations not the same as in-game? I suspect mine are the accurate figures based on the amount of dodges in the battles.
2. How is damage calculated? I had assumed it was the same as the to-hit process but I can't be right based on the feedback in-game.
3. How are retaliation strikes calculated?
Where I want to end up is a calculator that tells you an average of how many turns it will take unit A to defeat unit B which would quickly allow modders to balance weapons and armour. In the above example my calculations would be as follows:
Each turn Spearman1 does an average of 4.5 points damage 84% of the time = 3.8 (kill enemy in 4 hits)
EnemySpearman2 does an average of 7.5 points damage 78% of the time = 5.9 (kill enemy in 5 hits)
So by the time Spearman1 dispatches the enemy he will only have an average of 2 hitpoints left. Very close battle. 
