This is a collection of sortable Excel worksheets that breaks down all units and terrain by scenario and expansion. Includes all official scenarios up to and including Expansion 6 (The Spartans):
Units/Battle Lists each battle by Year, Game/Expansion, Block Color, Army, Individual Unit counts and Victory Banners. Sortable. Also includes a color-coded row for each army that lists the unit counts that came in each game/expansion.
Epics Same as Units/Battle but includes only Epic scenarios. Sortable.
Terrain by Expansion Lists Terrain Front, Terrain Back, Game/Expansion and Total. Sortable.
Terrain by Battle Lists Battle, Year, Game/Expansion and individual Terrain counts and totals. Sortable.
Xtra Blocks A simple worksheet to keep track of your extra blocks. Lists Army, Block Color, Size (Infantry, Cavalry, Elephant, Leader/Chariot) and Total. Sortable.
V2.0 update adds Expansion 6 data.
Note: On the Units worksheet, the default shows only the Spartan Expansion 6. Simply sort the Game column to
Show All to see all expansions/battles.
Also note the following correction:
Coronea The counts for the Medium Spartan Hoplites and Allied Medium Hoplites are flopped. There should be 3 Spartan Hoplites and 5 Allied Hoplites (with two representing Xenophon's Ten Thousand) in this scenario.
If you find an error, please let me know.