An Interactive Use of the Lanchester Combat Model

Technical Comments on Excel

Note: These pages have their own Top/Previous/Next sequence buttons. To return to the paper, close this window.

  1. How Are the Models Constructed?
  2. Only Whole Numbers? -- What To Do for Decimals
  3. Creating a Scroll Bar
  4. Tricks for Working Around the Scroll Bar’s Limitations


1. How Are the Models Constructed?

Consider this Red Force example:

CELL C8 —›





If the previous cell C7 = 0, then all subsequent Red Force cells equal zero as no Red Forces remain, else…



If the Blue Force E7 = 0, then the Red Force equals its previous amount, C7. With the Blue Force destroyed, the Red Force no longer changes – no gains or losses since the opposing force is no longer a threat.


But if the Blue Force E7 ≠ 0, then the Red Force equals its previous numbers, C7, minus the effect of the continuing battle – that it to say, the Red Force continues to experience battle losses proportional to the size of the Blue Force, -$C$3/100*E7, and non-combat losses continue to erode the Red Force too, -$C$4/100*C7, and reinforcements bolster the red Force’s size, +$C$5. After considering these changes, if the Red Force size is less than 1, the Red Force is set to zero, as a fraction of a troop/soldier cannot exist/fight, hence, the condition of if < 1 then 0 or in Excel, < 1, 0.


Now if the Blue Force E7 ≠ 0, and the Red Force is able to fight ( > 0 ), then the Red Force troop size is this resulting value.