Sword & Spear v2.01 Army Lists

Download the free Army List generator in Excel for Sword & Spear, a game for Ancient and Medieval combat by Polkovnik Productions and published by Great Excape Games.

Updated to version 2.01 and enhanced by NWA member John Shaw.

You can also download the PDF army lists in case you want to print and do your lists by hand.

Just select the right army list and enter the number of units of each type that you want. The program automatically calculates the points value and the army value.

You can also select stratagems and it calculates the points correctly; even for the Stakes stratagem which depends on the number of Medium Foot Longbow and Longbow (R) units in the army.

The scouting points bonus, army morale and army demoralise level are all calculated automatically to make it easier for the player. 

The cell for the number of units automatically changes to red when too few compulsory units or too many restricted units are chosen according to the standard rules.

Download the army lists and PDFs on this page, then check out the Sword and Spear official website at

http://polkovnik.moonfruit.com/sword-spear/4583102656

Note that the Excel spreadsheets on the official website are only version 1 and a couple of the PDFs have errors, so use the ones below in preference. 

Excel 2010

Army Lists v2.01 Generator – Excel 2010 Version

This is the preferred file to download if you have Excel

Click the picture at left to download the zipped file (1,030 KB) for Excel 2010.

Version 2.01 available 23-Oct-16 1:00pm Australian Eastern Standard Time.

Unzip the file and save the 7 workbooks. Open them in Microsoft Excel 2010 or later version.

PDF Lists

Army Lists v2.01 – PDFs

For those that don’t have Excel or want to print out and manually do their lists

Click the picture at left to download the zipped file (3,005 KB) for Excel 2010.

Version 2.01 available 23-Oct-16 1:00pm Australian Eastern Standard Time.

Unzip the file and save the PDFs. Open them in your favourite PDF reader.

Excel 2003

Army Lists v2.01 Generator – Excel 2003 Version

Only needed if the 2010 version above does not work for you because you have an earlier version of Excel

Click the picture at left to download the zipped file (474 KB) for Excel 2003.

Note that the spreadsheets were developed in Excel 2010. They have not been fully tested for use in Excel 2003. These files are provided for convenience in the hope that they work okay.

Version 2.01 available 23-Oct-16 1:00pm Australian Eastern Standard Time.

Unzip the file and save the 7 spreadsheets. Open them in Microsoft Excel 2003 or later version.

There are 7 workbooks included in each zip file:

1. Biblical

2. Greek & Macedonian Wars

3. Rome & Enemies

4. Dark Ages

5. Byzantium

6. Middle East & Crusades

7. Medieval