Let's set up the actual cells in a "Booster Pump Calculator" worksheet.

– Pipe length, diameter, material (old galvanized steel—ugh). Darcy-Weisbach in cell F23: =((f*L*V^2)/(D*2*g)) . Each elbow, each valve added head loss.

Open a new Excel workbook. We will create three tabs: , Calculations , and Results .

This is where the mathematics happen.

This is the most complex part of the Excel sheet. You can use the Hazen-Williams formula directly.