Water Flow Calculator Excel

The excel spreadsheet templates presented and discussed in this article can be used to calculate frictional head loss and pressure drop for a given pipe flow rate pipe diameter and length and fluid density and viscosity or to calculate the required minimum pipe diameter to carry a specified pipe flow rate at a given maximum head loss with known pipe length and fluid density and viscosity.

Water flow calculator excel. The excel formulas in the spreadsheet templates that can be downloaded will calculate water flow rates for pipe sizes diameters and lengths using the hazen williams formula. This calculator may also be used to determine the appropriate pipe diameter required to achieve a desired velocity and flow rate. You only need to know the diameter of the pipe the material it s made of its length and the drop in height. This flow rate calculator uses flow velocity and cross sectional flow area data to determine the volumetric flow rate of liquid.

Fixtures flows and pressures. Use this pipe flow calculator to analyse the properties of water flowing in a gravity fed system. With this diameter velocity and flow rate calculator you can determine the exact flow rate or velocity at which water will flow through any given pipe. First click on what you are solving for flow rate enter 2 in the pipe diameter box and choose feet from its menu.

You can calculate the flow rate in five simple steps. Click the calculate button and the answer is 5 236 cubic feet per second and the answer is in 23 other different units. These calculations can be conveniently carried out with an excel spreadsheet. Parameters required for this template are hazen williams coefficient and pressure drop over the pipe length.

Water demand calculations excel sheet xls calculator water demand calculations excel sheet free download download this xls sheet for estimation of water demand and drainage flow in water distribution systems. Several kinds of pipe flow calculations can be made with the darcy weisbach equation and the moody friction factor. Water demand calculation excel sheet xls calculator file size. Versions of the hazen williams equation are presented and discussed.

Pressurizing vessel head calculation. D pipe. Select the shape of the cross section of the channel. Many of the calculations require an iterative solution so they are especially suitable for an excel spreadsheet solution.

Input all the measurements required to compute the cross sectional area. Dubai dutee free water demand summary. V water velocity. V 0 408 q d 2.

Input the average velocity of the flow. The following formula is used by this calculator to populate the value for the flow rate pipe diameter or water velocity whichever is unknown. This excel template calculates water flow rates for different pipe sizes using hazen williams equation. Parameters calculated are 60 different flow rates for 10 different pipe diameters and 6 different pipe lenghts.

Choose the unit of the flow rate. Enter 20 in the in the velocity box and choose inches per second from its menu. Click on the calculate button to compute the flow rate. Q flow rate.