Design a table to log system valves and fittings. Include columns for quantity and equivalent length multipliers. Fitting Type Equivalent Length per Unit (m) Total Length (m) 90° Elbow Gate Valve Check Valve Section C: Automated Formulas (The Calculation Engine) Program Excel formulas to handle the math:
Creating a structured Excel sheet simplifies the calculation. Use the following structure to organize your data. Structure of the Spreadsheet
The head of a booster pump is calculated using the following formula:
: Best for water in turbulent flow (common in municipal plumbing). It is simpler and does not require an iterative friction factor. The general Excel structure involves: booster pump head calculation xls
The static head is the difference in elevation between the suction and discharge points:
Comprehensive Guide to Booster Pump Head Calculation (with XLS Templates)
=B12*2.31 (for imperial) or =B12*10.2 (for metric) . Total Dynamic Head (Cell B18): =SUM(B15:B17) Common Calculation Pitots to Avoid Design a table to log system valves and fittings
Total Dynamic Head (TDH)=Hs+Hf+Hd−HinTotal Dynamic Head (TDH) equals cap H sub s plus cap H sub f plus cap H sub d minus cap H sub i n end-sub Breakdown of Variables
A booster pump must overcome three primary forces to move water from a source to its destination. The sum of these forces is .
After calculating the required TDH and Flow, you need to verify it against a manufacturer’s curve. In Excel: Use the following structure to organize your data
The pressure required at the final fixture to make it work properly (e.g., a shower or sprinkler). 2. Step-by-Step Calculation Methodology
If you are currently setting up a spreadsheet, I can help you write the exact Excel formulas for your specific pipe materials. Tell me: