Campaign system introduction

I’m working on a campaign system, primarily for the Napoleonic period but with a few tweaks it could probably be used for anything up to the advent of telephones and radios.

The core of the system is a database, currently MS Access but I’m contemplating moving to SQL and a php user interface. The inspiration for this was Malcolm McCallum’s own campaign system which can be found here http://www.murat.ca I saw his system late last year and was fortunate enough to participate in a beta test.

So far, Kit, Matt and I are testing the system using one of Malcolm’s maps (no sense in reinventing the wheel right?) of Italy. Its going well, although we’ve had to pause a couple of times now to fix problems but that is the point of testing. Along the way we’ve added things to the system too.

Here’s a list of key features so far:

  • Fog of war without an umpire.
  • Lines of supply allowing supply and reinforcements
  • Garrisons and Sieges
  • Incorporation of standing orders to movement.
  • Courier system allowing messages to be delayed or intercepted
  • Regional Ownership governing insurrection and garrison levels

Comments

  1. Simon Gilbert says:

    Hi,
    I’m interested in developments of the MS Access database you mention and if it. I too am an admirer of Malcolm’s maps and had been invited to use them on TMP last year. I’m ok in Excel, but not a heavy user of macros. Perhaps I can repay in other ways as well. My own attempts at Napoleonic Campaign Rules aren’t bad in my opinion, but heavily reliant on outside inspiration. I was getting stuck with applying Tony Bath’s siege rule concept (ancients and Medieval) to Napoleonic sieges with the effect I needed a bit of know how on garrison artillery complements (number of emplaced guns and whether field guns from a battery garrisoned would be stored or used to augment. My campaign stuff consists of a growing number of spreadsheets covering the specific scenario, and its manual operation as I plan it out looks to be an art in itself.

  2. Mike says:

    Are you using elements of the Berthier system?

    I like the Excel set up. Very clean and an excellent way to keep track of all the data.

    Like Simon Gilbert, I too am using an increasing number of spreadsheet data-sheets which becomes very difficult to manage when trying to keep everything up to date.