EiA Combat Result Calculator Manual

Back to Board game utils page.


General

EiA Combat Result Calculator is a tool to calculate combat results for Empires In Arms board game easily and thus speeding up the game a bit. Also, it is very helpful if the need for modifier adjustments arises afterwards. To use it you need OpenOffice 3.1 or newer.

Notice that all the different combat modifiers, like guards commitment, cavalry edge, etc., are not automatically handled by the calculator. Instead, you as a player must know all the modifiers and modify each combat round based on the current situtation. The following situations are, however, handled by the calculator:

  • Besiege
  • River crossing
  • Combat in port location
  • Trivial combat
  • Outflanking

Several cells has notes to help and remind user for the purpose of the issue. Move the cursor over the red dotted cell to see the note.

Color coding backgrounds

The colors used are probably not the best and I am sorry about that. Unfortunatly colors cannot be selected freely and thus I was forced to use predefined colors. Hopefully you can live with that.

Color coding

In general light colors are editable whereas dark colors cannot be edited. Combat calculations are printed on white or light gray. Attacker has orange color and defender has blue.

Positive numbers and zero are shown in black and negative numbers are in red.

Document protection

All the non-editable cells are protected (i.e. locked) so that they cannot be accidentally changed. This is important so that formulas in the cells are not accidentally overwritten or deleted.

However, if you are interested in the inner logic of the tool or want to make any changes there you can unprotect the sheet. Sheets are protected without a password.

If you create your own version of this document and want to distribute it I ask you to name it differently to distinguish your work from mine. It is also preferable to change the outlook as well.

Tabs

Tabs are divided into two different categories:

  • Fight tabs
  • Helper tabs

First four tabs are used for resolving a combat and the last three are helper tables for result calculation.

  • Fight tabs
    1. Attacker tab is used for setting up attacker's forces.
    2. Defender tab is used for setting up defender's forces.
    3. Troops tab can be used to check attacker's and defender's forces side by side.
    4. Fight tab is where the combat is resolved.
  • Helper tabs
    1. Combat table tab has the troop and morale losses tables which are used for resolving combat.
    2. Operations table tab is used to figure out casuality and morale levels based on drawn chits.
    3. Rules tables are not used in the combat result calculator in anyway but are here only for reference. These tables are corrected and are in practice the same that can be found from http://eia.xnetz.com/.

Using calculator

Step 1, Create a new blank sheet

The easiest way to create a blank combat sheet is to double-click EiA Combat table.ots file. Because it is an OpenOffice template double-clicking it automatically creates a new clean combat sheet ready for use.

Step 2, Attacker enters his forces

Attacker sets up his forces on Attacker tab (should be automatically open after creating a new blank sheet). Number of forces are written under suitable morale column(s). You can divide your troops in multiple groups if you like, except for artillery which must be set on artillery row. Otherwise you can divide your troops as you see fit.

In addition to your troops, you can set the following (initial) modifiers:

  • Casuality level modifier (B2)
  • Morale level modifier (B3)
  • Die roll modifier (B4)

Don't forget to set the terrain modifiers to the above modifier cells.

All the above modifiers can be changed every round during the fight. The idea is that you need to set the modifiers in a Fight tab between the combat rounds only if it is necessary.

Step 3, Defender enters his forces

Defender sets up his forces on Defender tab. This is done exactly like setting up the attacker's forces. See details from Step 2, Attacker enters his forces.

Step 4, Moderator checks troops

From Troops tab both, attacker's and defender's, forces can be examined side by side.

Step 5, Resolve fight

Initial procedures

Set one or more of the following by writing letter x in the appropriate cells:

  • Besiege, cell E1
  • River crossing, cell E2
  • Port combat, cell E2
  • Trivial Combat, cell F2

Draw and mark chits

  1. After revealing chits mark a proper chit column for the attaker and the defender.
    • I3:M3, I11:M11, I19:M19, I27:M27, I35:M35, for the attacker
    • S3:X3, S11:X11, S19:X19, S27:X27, S35:X35, for the defender
  2. If outflanking occurs mark the outflanking forces to a proper cell.
    • G3, G11, G19, G27, G35 for the attacker
    • Q3, Q11, Q19, Q27, Q35 for the defender
  3. Set a proper Final morale modifier to adjust moral level to a correct one.
    • O1, O9, O17, O25, O33 for the attacker
    • Y1, Y9, Y17, Y25, Y33 for the defender

Fighting rounds

  1. If necessary set new modifiers for each combat round as you progress:
    • Casuality Level Modifier in CLM columns
    • Morale Level Modifier in MLM columns
    • Die Roll Modifier in DRM columns
  2. After the first round adjust also:
    • If outflanking succeeded:
      • Put letter x in E3 (single bordered cell) if the outflank succeeded after the first round.
      • Write x in D3 (double bordered cell) if the outflank succeeded after the second round.
    • Outflanking force combat losses in appropriate cells in OF column.
    • Artillery combat losses in appropriate cells in Art l. column.
    • Put the size of the reinforcement in RS column.
  3. Roll for artillery if necessary. Mark the result in aD6 columns. As you can see, the calculator immediately calculates losses based on your input data
  4. Roll other combat and mark the result in D6 column. Again, the losses are calculated immediately.
  5. Repeat phases above until the combat is resolved. Remember to make all the necessary adjustments when the day changes.

Step 6, After combat

After the combat has been resolved you can save the combat sheet if you like. Or, you can simply discard it. It's up to you.

Afterwards

Combat Result Calculator is based on the rules and errata and was inspired by the resources found from http://eia.xnetz.com/.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License