Roman Army Campaigning spreadsheet

UPDATED January 2024 with dynamic charts of marching camp defence profiles and camp plans. These simple 2D representations are updated as the user changes values in the spreadsheet giving a visual confirmation of appropriateness.

Spreadsheet calculations for campaigning Roman armies of the early Imperial period. The spreadsheet is also available at www.bandaarcgeophysics.co.uk/arch_intro.html . It allows the definition of army sizes, march rates and distances, and the building of camp defences (ditch, rampart and palisade) before calculating over 70 parameters and metrics associated with a Roman marching camps, e.g internal roads. Calculated camps sizes are cross-matched to extant camps allowing comparisons.

Observations from the use of the spreadsheet, together with instructions on how to use, are available in an accompanying essay, "Early Imperial Roman army campaigning: observations on marching metrics, energy expenditure and the building of marching camps", available at www.bandaarcgeophysics.co.uk/arch_intro.html or from Zenodo.org ( https://zenodo.org/record/838275#.ZGSOIHbMIuU ) or Academia.edu (search 'steve kaye').