FOGN Army List and Label Generator

fogn_logo_small

Download the free Army List and Label Generator program for Field of Glory Napoleonic. Written by NWA member John Shaw, this is a spreadsheet for Excel 2010 which has been endorsed by Slitherine Ltd.

It uses pull-down menus to easily choose the units you want in your FOGN army. The program automatically generates the points total for your army and the ACV (Army Combat Value) as per the rulebook.


The colour of the header section automatically changes when a nation is selected for your army and it automatically adds a flag, so you know who you are fighting for. It can automatically generate labels for your troops with a single click!

pastarchives

Excel 2010

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

Version 1.04 available 17-Apr-12 9:15pm Australian Eastern Standard Time.

Unzip the file and save it. Open it in Microsoft Excel. Don't forget to enable macros so that the automatic features work.

pastarchives

Excel 2003

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

Note that the program has been designed for Excel 2010 and has not been tested for use in Excel 2003. This file is provided for convenience in the hope that it works okay.

Version 1.04 available 17-Apr-12 9:15pm Australian Eastern Standard Time.

Unzip the file and save it. Open it in Microsoft Excel. Don't forget to enable macros so that the automatic features work.

 Changes:

Version 1.04 changes:

Changed calculated ACV values to nearest 0.5 points since a removed base from Spent Cavalry is worth 0.5 points.

Version 1.03 changes:

Fully corrected the points cost for Guard units.

Added flags for Netherlands, Poland (Duchy of Warsaw) and Saxony.

Blanked out sample Initiative value of 1 in "Blank Army" worksheet to save confusion, as this value needs to be manually entered.

Changed ACV formula so Fieldworks not count towards ACV total.

Added the ACV values in brackets for when defender gets the +2 ACV if attacker has gained the +40 points for units.

Detailed instruction are given in the spreadsheet on how to use it.

troop_labels  

Spanish and French troops battle it out with the labels generated from the Army List and Label Generator.