. 
This spreadsheet allows the user to calculate the frictional head loss (m) for a given flow rate (LPS) and pipe length (m), for a series of different diameter pipes (in). The user can also find the optimum combination of 100m sections of two pipes of different diameters (in) to “burn off” a given frictional head (m).
Microsoft Excel Spreadsheet (196KB)