Roman Army Campaigning spreadsheet

<strong>UPDATED May 2023</strong> 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').**2023年5月更新**，附带行军营地防御构型与营地规划动态图表。这些简易二维可视化模型可根据用户在电子表格中修改的参数实时更新，直观验证方案的适配性。本电子表格用于计算罗马帝国早期远征军队的相关行军参数，可通过网址www.bandaarcgeophysics.co.uk/arch_intro.html获取。用户可在其中设定军队规模、行军速率与行军距离，以及营地防御工事（壕沟、壁垒与栅栏）的相关参数，随后该电子表格将计算与罗马行军营地相关的70余项参数与指标，例如营地内部道路规划。计算得出的营地规模可与现存考古营地遗迹进行交叉比对，以开展对比分析。配套的研究论文包含该电子表格的使用说明与实际使用的观测结果，论文标题为"Early Imperial Roman army campaigning: observations on marching metrics, energy expenditure and the building of marching camps"，可通过www.bandaarcgeophysics.co.uk/arch_intro.html、Zenodo.org（https://zenodo.org/record/838275#.ZGSOIHbMIuU）或Academia.edu（搜索"steve kaye"）获取。