Hydraulic calculation spreadsheet

Hydraulic Motor Calculations

OpenFlows FlowMaster helps you perform hydraulic calculations for dozens of element types, from pipes and open channels to drop inlets and weirs:. Quickly perform hydraulic calculations for dozens of hydraulic element types, from pipes and open channels to inlets and weirs. View detailed tables, reports, rating curves, and more, that show results of the hydraulic calculations performed. Learn about the benefits and flexibility offered by a Cloud Services Subscription. OpenFlows FlowMaster Solve-for-anything hydraulic toolbox. Hydraulic Calculator Software Doing hydraulic calculations in a spreadsheet is an error-prone process. Pressure pipe design Perform a quick check or design by plugging in the known information and automatically solving for pipe length, start-and-stop elevations and pressures, discharge, diameter, and roughness. Inlet and gutter hydraulics Design and analyze grate, curb, ditch, slotted, and combination inlets using calculations based on the FHWA Hydraulic Engineering Circular No. Open channel hydraulics Design and analyze channels, ditches, and free surface pipes of any shape including circular, box, elliptical, parabolic, and irregular channels. Weir and orifice modeling Size weirs considering discharge, weir coefficients, and crest, headwater, and tailwater elevations for the following types: rectangular, V-notch, Cipolletti, broad crested, or custom size. Capabilities Calculate hydraulics Quickly perform hydraulic calculations for dozens of hydraulic element types, from pipes and open channels to inlets and weirs. Tell me more! Interested in finding out more about this application? Contact Us. Visit Store. Learn More. Featured User Projects. Related Products. OpenFlows CulvertMaster OpenFlows CulvertMaster is a very easy-to-use calculator product that provides a stress-free culvert solution for any site design or land development project. OpenFlows CivilStorm OpenFlows CivilStorm provides an easy-to-use environment for engineers to analyze, design, and operate stormwater systems. OpenFlows PondPack OpenFlows PondPack enables users to effectively analyze and design detention and retention facilities, outlet structures, and channels. Product Resources. Water Project Showcase Showcase View.

Hydraulic Motor Speed Calculator


We believe that all fire protection engineers should have a good understanding of the principles of hydraulic calculations to enable them to optimize designs and to ensure that all calculations can be properly checked and verified. Fire sprinkler engineers, inspectors, and insurance companies will find a use for our free Hcalc - Hydraulic Calculator. It can be used for teaching the principals of hydraulics in fire protection engineering, checking calculations or for solving simple hydraulic calculations for fire sprinkler, hydrant, hose reel and other types of water-based fire protection systems. Fire protection engineers and consulting engineers from around the world have installed Hcalc to help them with calculations and the verifica. With Hcalc you can calculate the friction loss in a circular pipe using the Hayes and Williams pressure loss formula which is specified in NFPA 13 and EN and in many other international design standards. You can specify the pipe size, flow rate, and the pipes C-factor and Hcalc will calculate the pressure loss per meter and for the total pipe length and the water velocity. You can select the type of pipe material from the drop-down list or enter your own pipe C-factor. Whenever you need to carry out pressure loss calculation or to verify the simple calculator is ready to help. With Hcalc - Spk Flow you can solve any of the three variables in the K-Factor formula, the flow from the sprinkler, the pressure required at a sprinkler and the K-Factor without the need of remembering the formula. The K-factor formula is one of the basic building blocks of fire sprinkler design and fire protection hydraulic calculations, most of us will have committed it to memory but now with Hcalc you know longer need to. You can have this simple tool sitting on your desktop so you no longer need to find your calculator or pen and paper. You can use Hcalc any type of fire sprinkler or water mist nozzle or in fact any other nozzle or head which you have a K-Factor, this could be a hose reel nozzle, a foam monitor or a fire hydrant. Hcalc is easy to use but will have still provided an on-line user manual and a short video tutorial to help get you started. You will also find all the formulas which have been used clearly set out and with additional information. If you're interested in learning more about hydraulic calculations for fire sprinkler systems would like to know how to carry out calculations for a simple tree end fed systems using the time honoured longhand method with paper and pen, then you may find our article how to calculate a fire sprinkler system to be of interest. We personally would not recommend this method anything more than a very simple system as by its nature will very likely to make an error somewhere in the calculation which is then compounded as you move along. Our FHC hydraulic calculation software is ideal for carrying out some calculations from the simplest to the most complicated system design. Hcalc for fire sprinkler hydraulic calculations. Download Hcalc give it a try today for free! Download Hcalc. Pipe pressure loss calculations.

Open Channel Flow Blogs


Read on for information about the use of Excel spreadsheets for storm sewer design calculations. The storm sewer design spreadsheet discussed in this article uses Excel formulas with the rational method to find design storm water runoff rate and the Manning equation to find pipe diameter and slope. The hydraulic portion of stormwater sewer design proceeds in the form of calculations between each pair of manholes in the storm sewer line. The first part of the spreadsheet is essentially a rational method design spreadsheet used to determine the design stormwater runoff flow rate for each section of storm sewer being designed. The next part of the spreadsheet is used to calculate the pipe diameter and slope for each section of storm sewer with the Manning Equation. Finally, the pipe invert elevation at each manhole is calculated in the last part of the spreadsheet. Each part of the storm sewer design spreadsheet will be discussed briefly in the next several sections, followed by presentation and discussion of an Excel spreadsheet template to make the calculations. The parameters in the rational method equations are:. The storm sewer design spreadsheet being discussed here will assume that the manhole locations have already been determined, as shown in the diagram above. A street map like this would be used to determine the area draining to each of the manhole inlets for the length of storm sewer being designed. Following are the criteria typically used to calculate the design pipe diameter and sewer slope for a length of sewer pipe:. The sewer pipe invert elevation or depth at the uppermost manhole is determined by the minimum required depth of cover above the sewer pipe to protect it from freezing. This required minimum cover is usually specified by a state or local agency. Calculation of the invert elevations at manholes with a storm sewer design spreadsheet is presented in the next section. The storm sewer design spreadsheet template shown in the two images below contains design calculations for a storm sewer line along one of the streets on the manhole layout map shown above in the second section of this article. The spreadsheet makes the calculations described above. The various parts of the spreadsheet will now be discussed briefly with reference to the column numbers given on the spreadsheet. Column 4 is the calculated cumulative area draining to downstream sections of storm sewer pipe. The uppermost part of the sewer line in this example is the manhole at 8th Street and Maple Avenue. An estimate of the runoff coefficient is given in column 5. Column 6 shows the inlet time from the farthest point in the drainage area. This is calculated in column 7. Column 8 is the calculated design rainfall intensity. Columns 16 and 17 are used to calculate the pipe flow time to be used for the time of concentration calculation in column 7. Columns 18 and 19 give ground surface elevations taken from the manhole layout map. Columns 20 and 21 calculate the pipe invert elevations. The invert elevation at the lower end of the pipe section is calculated using the sewer slope that was previously determined. Columns 22 and 23 are a check on the depth of cover at each manhole, and column 24 is a listing of the final design pipe slope. Bengtson, Harlan H. McCuen, Richard H. The parameters in the rational method equations are: Q, the design storm water runoff rate cfs — U. A, the runoff area that drains to the section of sewer pipe being designed acres — U. Criteria Used in Storm Sewer Design Spreadsheet Following are the criteria typically used to calculate the design pipe diameter and sewer slope for a length of sewer pipe: The pipe must be sized to carry the design peak stormwater runoff rate.

Download Fire Sprinkler Systems Calculation Excel Sheets


It has 16 representation offices in CIS countries, and offers equipment and components from production sites in Turkey and Republic of Korea. It is ready to develop and deliver different pumping equipment and pipeline fittings according to your individual performance specifications. Pipes interconnect various apparatuses of chemical plants. They are used for transfer of substances between separate apparatuses. As a rule, several separate pipes with the help of connections make up single pipeline system. Pipeline is a system of pipes connected by connecting elements and used for transport of chemical substances and other materials. As a rule, buried pipelines are used at chemical plants for transport of substances. In respect to self-contained and isolated parts of a plant, they also pertain to pipeline system or network. All abovementioned elements are manufactured individually, after which they are connected as a single pipeline system. Moreover pipelines can be equipped with heating and necessary insulation made of different materials. Size of pipes and materials for their manufacture is selected on the basis of process and resign requirements set in each individual case. But for standartization of pipelines sizes their classification and unification were performed. The key criterion was permissible pressure under which pipe operation is possible. Nominal inside diameter DN nominal diameter is a parameter used in pipeline systems as characterization factor with the help of which alignment of pipeline parts, such as pipes, valves, fittings, etc, is performed. Nominal diameter is a nondimensional quantity, but numerically it approximately equals to pipe inside diameter. Example of nominal inside diameter designation: DN Also nominal inside diameter is not denoted in drawings and does not substitute real diameters of pipes. It approximately corresponds to the clear diameter for certain pipeline sections Figure 1. Sizes of these nominal inside diameters are set with a view to avoid any problems with mutual alignment of parts. When determining nominal diameter on the basis of pipeline inside diameter value, the value of nominal inside diameter, which is the nearest to the pipe clear diameter, is selected. Like a nominal diameter, a nominal pressure was calibrated on the basis of accumulated operation experience Table 1. Nominal pressure for a particular pipeline is selected on the basis of pressure practically created in it, by selecting nearest larger value. Moreover, fittings and valves in this pipeline should also correspond to the same level of pressure. Thickness of pipe walls is calculated on the basis of nominal pressure, and provide pipe operation ability with pressure value equal to nominal Table 1. With rise of temperature pipe load capability drops. At the same time permissible overpressure reduces correspondingly. Value p e,zul shows maximal overpressure that can be in the pipeline system upon rise of operation temperature value Figure 1. During selection of materials to be used for pipelines manufacture characteristics, such as parameters of medium to be transported through the pipeline, and tentative operation pressure in this system are taken into account.

Hcalc for fire sprinkler hydraulic calculations

Hydraulic calculations completed by hand are a thing of the past. Computer programs can provide you with pages of information at the click of a mouse. However, given the demand for new sprinkler designers, there is a need to return to the basics. Designers, particularly newer designers, cannot be sat in front of a computer and be expected to get it right and understand sprinkler design the first time opening a program. Designers must understand the steps to be taken to ensure the sprinkler system will be adequate for a given facility. Designers, many times, have to read and interpret specifications, reports, and drawings before beginning the design process within the various computer programs available to companies. Given the number of steps that must be taken in order to design a sprinkler system, that provides a lot of room for error. Additionally, the steps are additive. The decisions made in one step will impact each step down the line. Therefore, it can be inferred that the first few steps the designer takes in the process are, arguably, the most important. The designer must first define the occupancy and then move forward to determine the appropriate design area and density for the system. Furthermore, the designer must understand how to locate the design area within the system. These steps should be completed before the computer calculation program is opened. Occupancy Classification The first step in the design process is determining the occupancy in which the system will be designed Brock, However, this step is not always as straightforward as one may think. The occupancies within NFPA 13 have unique definitions. For instance, one manufacturing occupancy, as defined by the IBC, may not be the same occupancy classification within NFPA 13 as a different manufacturing occupancy. Per NFPA 13, areas within a building will be defined as a light hazard, ordinary hazard Group 1ordinary hazard Group 2extra hazard Group 1and extra hazard Group 2. To add to the confusion, there are then special occupancy classifications of Chapter 22, particularly storage commodity classes Class I through IV and plastic groups Groups A-C. While the Annex has a list of examples of each type of occupancy, it is not all-encompassing. Designers must make judgment calls on what some occupancies should be classified when it does not fit easily into one of the occupancy classifications. Furthermore, many drawings use room names that may need to be interpreted regarding the actual use of such room.

How to do hydraulics calculations



Comments on “Hydraulic calculation spreadsheet

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>