Hydraulic Calculations of Fire Sprinkler Systems with Excel file

Although many hydraulic calculation programs are available on the market, the software won’t be
useful unless sprinkler system designers understand the concepts behind hydraulic calculations.
Along with understanding basic fire sprinkler design terms like pressure, flow rate, density, design
area, etc., the designer needs to know how to interpret hydraulic calculation tables (worksheets).
The validity of this worksheet cannot be verified without knowledge of every row, column, and cell.
In this text, we`ll design a fire sprinkler system according to NFPA 13-2025 Edition and complete
the hydraulic calculation worksheet. We will use an Excel file developed by NSVsoft for educational
purposes, which applies to tree piping configuration with uniformly spaced sprinklers. This file can
be downloaded for free at www.nsvsoft.net and helps to calculate friction loss (using the HazenWilliams formula), pressure loss or gain due to elevation changes, and the equivalent length of
fittings using the C factor or internal diameter of the pipe. This file contains the internal diameter
of Sch10, Sch30, Sch40, Copper Type K, Copper Type L, CPVC, and Cement-lined Ductile Iron Class
52 in its library.
There are four sheets in the Excel file:
– Hydraulic Calculation
– Equivalent K Factor
– Equivalent Length
– Multipliers
By solving a problem, we learn how to use the “Hydraulic Calculation” Excel file (Please login to Download).

To read more Please click Here.