. 
This spreadsheet allows the user to calculate the natural flow rate (LPS) of any combination of up to 4 pipes of different diameters (in) for given pipe lengths (m) and known head (m).
Microsoft Excel Spreadsheet (165KB)
*** Note: this spreadsheet contains macros, and you may get a security warning.