This is a collection of sortable Excel worksheets that breaks down all units and terrain by scenario and expansion. Includes all official scenarios, including Expansion 1 (The Spanish Army):

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.

Terrain by Type
Lists terrain by type and the terrain on the reverse side with total. Sortable.


Terrain by Battle
Lists Battle, Year, Game/Expansion and individual Terrain Type. Includes counts and totals. Sortable.


Terrain by Expansion
Lists Terrain Front, Terrain Back, Game/Expansion and Total. Sortable.


Extra Blocks
A simple worksheet to keep track of your extra blocks. Lists Army, Block Color, Size (Infantry, Cavalry, Artillery/Leader) and Total. Sortable.


If you find an error, please let me know.