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.