Method and charts for the calculation of a Roman lead pipeline discharge

The excel workbook contains the data obtained from the application of Colebrook-White equation to ancient Roman lead pipes in the range <em>digitus </em>to <em>denaria</em>. The <strong>'Tables'</strong> <strong>worksheet</strong> calculates the values of friction factor, Reynolds number and flowrate corresponding to values of average velocity up to 3m/s and for values of the absolute roughness in the range 0.1 to 0.5 mm. The <strong>'Charts' worksheet</strong> contains the charts derived from the tabled data. The<strong> 'Method'</strong> <strong>worksheet</strong> describes an iterative graphical method, based on the charts, to obtain the discharge of a lead pipeline connecting two points, starting from a range for the maximum hydraulic slope. <em>The graphical method, compared with the numerical solution method, allows to easily take into account the uncertainties present in the topographical and archaeological data, providing a simplified sensitivity analysis.</em>