Mapping your wargame campaign using Excel

Earlier on this blog I posted a tutorial for using Microsoft Excel as a tool to map wargame campaigns.
I now offer a design and set up service for this.  If interested please contact me at

I will need for the basic setup:
A campaign map in bitmap or jpeg format, with the desired scale (miles or kilometres per square).
Order of battle, preferably in an Excel sheet.
This service is offered free of charge.

Additional services – negotiable.
Embedded program for calculating movement and/or contacts, depending on terrain and visibility parameters set by you.
Embedded program for logistics management, also with parameters set by you.
Embedded program for messengers and couriers.
It can get as complex as you wish, but complexity takes time and effort, and will be charged accordingly.  I will not rip-off fellow wargamers.

All programs developed will bear my copyright.
The base map used in the example image is copyright Hasbro Inc. from the digital game of “RISK”

Peninsular War Campaign – opening deployment

The campaign started on 1st June 1808.

The campaign map issued to the players
The campaign map issued to the players

Marshall Bessières was in Burgos with 1,250 cavalry, 10,600 infantry and 30 guns.  His orders were to subdue and control the north of Spain.
General Duhesme (umpire controlled) was in Barcelona with 450 cavalry, 3,000 Infantry and 12 guns.  He was tasked with maintaining the peace along the Pyrenees and Catalonia.
General Junot was in Lisbon with 2,000 cavalry, 13,700 Infantry and 23 guns.  He was responsible for Portugal.
General Dupont was in Madrid with 3,000 cavalry, 16,500 infantry and 36 guns.  His orders were to take and control Andalusia.
Marshall Moncey (umpire controlled) would for the time being hold Madrid with his 9,000 men.
General Blake was in Coruña with 300 cavalry, 10,000 regular infantry, 9,000 militia and 20 guns, defending the north of Spain.
General Castaños was in Seville with 1,300 cavalry, 10,000 regular infantry, 4,000 militia and 16 guns, defending the south.
Don Cristobal d’Escozia (a fictitious character) would command all guerrilla and irregular forces as and when they were activated. He based himself in Pampeluna (modern Pamplona).
The Portuguese army was officially disbanded, but in Oporto there were 275 cavalry and 1,900 infantry. They would be placed at Sir Arthur Wellesley’s disposal.
Great Britain
Sir Arthur Wellesley was in Cork, Ireland with 225 cavalry, 15,000 infantry and 18 guns.  He was ordered to support the insurrections in Spain and Portugal as he thought fit.

The players were given the following history and asked for their orders of battle, deployment and initial orders.
18 Oct French troops cross Franco-Spanish Border (28,000 men under Junot).
27 Oct Treaty of Fontainebleau – Napoleon agrees with Spain to invade Portugal.
19 Nov French troops begin crossing into Portugal.
27- 29 Nov Prince Regent Joao VI sails from Lisbon (to Brazil).
30 Nov Lisbon occupied by the French without a struggle.
Dec Gen Junot disbands the Portuguese Army.

1808 Early months Additional 75,000 French troops cross Pyrenees.
16 Feb Seizure of Pamplona.
29 Feb Seizure of Barcelona.
18 Mar Seizure of Figueras.
19 Mar Abdication of Spanish King, Charles IV.
23 Mar Madrid occupied by the French without struggle.
10 Apr Ferdinand departs to Bayonne to meet up with Napoleon.
2 May Madrid “Dos de Mayo” uprising.
25 May Province of Asturias declares war on France.