# Pump Curve Calculator Excel

For preliminary calculation we choose 70% adiabatic efficiency. A calculation of the predicted response and noise of the prototype is presented with the general formalism of thermal detectors. The desired viscosity conversion method can be selected separately for each duty chart in the database and can also be deactivated, if desired. This version is usable for browsers without Javascript also. By exact, I mean that the generated curve is a direct result of the two curves that were entered. Features * Graph Water Supply Curve * Graph Sprinkler (CMDA, CMSA, & ESFR) Demand Curve * Graph Fire/Booster Pump Test * Graph Parallel Water Supplies. Example Water Hammer Potential Calculation. vector([Pump Intake Press. 1) Install piping so that the suction side of pump is connected to the reservoir tank and the pump outlet leads to the graduated container. 82” instead of the “standard calculation ART 220. Tromp Curve Calculation - Free download as Excel Spreadsheet (. There are three affinity laws:. When ready, copy the results from the screen with ctrl c. 9 mm/min) over 1500 ft 2(139 m ). Vertical Pumps. In the pump vs. It works with Excel 2000, 2003, 2007, 2010, 2013 and 2016. Where the two curves cross, is where the system operates relative to flow rate and head. Warning: This file type may contain malicious code. pump and system curves. The Pump efficiency at that point. Using the figures, a user can estimate the power requirement or efficiency of the pump based on its discharge. Slurrytech™ Curve Engine™ is an Excel ® based software package that allows the user to perform Newtonian slurry calculations and to view the results overlaid onto a pump performance curve as a system resistance curve. Simple Calculation All pumps works best at the centre of the pump curve (see the pumps technical specification pump curves). A tangent is a straight line that touches a curve at a single point and does not cross through it. pdf), Text File (. You can copy and paste the data into EXCEL, so you shouldn’t need to type in the data. New: Creates a new row in the curve points table. Converting Corrosion Rates To convert the corrosion rate between the mils per year (MPY) and the metric equivalent millimeter per year (MM/Y), you can use the following equation to convert mils per year to micrometers per year (MicroM/Y):. Excel base Programs (Electrical Engineering): Designed by: Jignesh. Finding the slope of a curve at a point is one of two fundamental problems in calculus. NFPA 25 requires that records be kept by the property owner of all inspection, testing, and maintenance of the fire pump system. or do other calculations. Select a pump based on flowrate and total head loss requirements. Although a number of factors determine the price per gallon, the price of crude oil makes the most impact. 5 HP SuperPump) is one pump for our example. CliffsNotes is the original (and most widely imitated) study guide. Download Free MEP Calculation Excel Sheets, AutoCAD Drawings, and Training Courses for HVAC, Firefighting, Plumbing and Electrical Systems Design. To find the pump performance curve you need, simply type the pump name into the "Product" search field and select the product and model you want. This calculator determines the pressure (head) required just after the pump, and the pressure (head) that the pump must generate or add. Excel offers options for drawing a variety of shapes with circles, curves and straight lines. The calculator generates solution with detailed explanation. Spreadsheet. Transition curves- used between tangents and circular curves or between two circular curves that have significantly different radii. Pump Curves. Values $1,000,000 + with a full-time captain - ;$1,000,000 must have been declined by standard markets and accompanied with comprehensive marketing list. 2) Using the Viking Online Calculator, determine the RPM associated with each flow rate to be tested. Note: If you wish, you could right click on the result, click format cell, choose percentage, and then click ok. So, total system resistance 1 = 30*0. Actual Power output = 70% of P o = 0. If we had to do this on paper, we would calculate this as follows:. Oil and Gas Presentations required steam surface condenser as per HEI spreadsheet. Download Fire Pump Sizing Excel Calculator This excel sheet calculator performs all hydraulic calculations for fire sprinkler system. Either of these two points, or any point to the right of the curve [such as 0. P = Power transmitted to the fluid by the pump in Watt. This is the head and flow rate for the given pump/system combination. Although Hunter’s formulation seems complicated, it is relatively easy to calculate using excel. The system will have a single operating point unless a device is added, and rarely does a pumping application require the pump to produce maximum flow. The safety factor can be a total multiplier or additional head. The example included is for a pump that is pumping 600 GPM through 600 feet of 6" and 8" steel pipe. This calculator will be produce more accurate results compared to the one above which does not account for utility source impedance. Tromp Curve Calculation - Free download as Excel Spreadsheet (. Figure 1: Sketch of Tree System Figure 2: Commercial Excel Data Entry Form. Excel offers options for drawing a variety of shapes with circles, curves and straight lines. For example; any change to engine speed changes pump speed. (Equation 7) So, by using a reasonable estimated BSFC and a reasonable best-power air to fuel ratio, you can use Equation 7 to estimate the airflow required for a given amount of horsepower, and with Equation 3, you can calculate the airflow of your engine at a given RPM if it was operating at 100% VE. Compare & Calculate Your Savings. In addition it provide a graph of the curve with shaded and filled area. Since the power curve is available, it is more convenient to read the static head than the manometric head; the static head curve is already corrected for the losses in the system and it is no longer required to determine the head loss Loss hor the head loss coefﬁcient Loss coef. To find the pump performance curve you need, simply type the pump name into the "Product" search field and select the product and model you want. Four Constant Speed Pumps of Equal Capacity. Also this course will help you for your interviews. Curve Calculation The pump curves are automatically calculated by the software to match the respective operating conditions. Engineeringanddesign. All fields are required. 8 Important Terminology Well yield: is a measure how much water can be withdrawn from the well over a period of time and measured in m3/hr or m/hr or m3/day. 1 MB Excel) 12/01/2019 MC and Loadshape Version 3. Calculation Details Step 1: Determine Properties of Steam Produced Using the Steam Property Calculator, properties are determined using Steam Pressure and the selected second parameter (Temperature, Specific Enthalpy, Specific Entropy, or Quality). Salinity Calculator Use this calculator to see how much salt is needed to bring your pool to the ideal salinity of 3,400 PPM. Download Calculation sheet for Fire finding Pump. Measure the vertical distance between the water level in the base reservoir tank and the water input at the destination tank and write down the measurement in feet. Pump Power Pumps are usually driven by electric motors, diesel engines or steam turbines. Web based calculation available at CheCalc. However, numerical errors in the calculation of flow for very small depths tend to increase the velocity head as the flow approaches zero. 1 0 Qm3/h 0 10 20 30 40 50 60 70 80 90 An. Pump Efficiency and Power • Pump efficiency, Epump pump water horsepower WHP E brake horsepower BHP = = (221) • n by the pump manufacturer calculate required BHP, knowing Epump Water horsepower is defined as: where brake horsepower refers to the input power needed at the pump shaft (not necessarily in “horsepower”; could be watts or some other unit) Pump efficiency is usually give • Typically use the above equation to • QH WHP 3956 = (222. NOMENCLATUREin the turbulent flow region. The single curve in Figure 7 crosses the x-axis (zero head difference) at the pump station operating point. (a) (i) Use the graph to determine the number of molecules of air in the sample. The characteristic hydraulic curve for the selected pump has been overlaid onto the system curves (see Figure­3 on. According to this law, theoretically, a calibration curve generated by observing the response of the instrument in terms of the liquid’s absorbance, for its different concentrations, looks like a straight line. You can try various combinations to come up with an appropriate combination of ring and pinion gear ratio and tire diameter for your vehicle. Integrals and Area Under the Curve. A one-dimensional flow procedure for analytical study of centrifugal pump performance is done applying the principle theories of turbomachines. We'll show you a list of radiators that will generate enough heat to keep your room at an efficient yet comfortable temperature. Please note that higher the HP one uses does not mean that more water is pumped out. Create plots of R(t), f(t) and h(t). Since the power curve is available, it is more convenient to read the static head than the manometric head; the static head curve is already corrected for the losses in the system and it is no longer required to determine the head loss Loss hor the head loss coefﬁcient Loss coef. Use below calculator if the utility or generator source impedance is known. The book then takes a look at general pump design, volute design, and design of multi-stage casing. 2 To calculate Packer Inflation Pressure for an injection test (pump in):. Switch on the IFD7. 1 MB Excel) 12/01/2019 MC and Loadshape Version 3. This is the number of cubic feet that your compressor pumps in the time it took for your tank to fill (recorded in Step 4). The point where the pump operates on its curve is dependent upon the characteristics of the system In which it is operating, commonly called the System Head Curve. Please guide me and let me know the formula to calculate the capacity and LPM required for it. 2 Note:!This example uses pump data from a manufacturer. The user can then plot the saturated liquid and saturated vapor lines in one of four common formats: (1) Temperature – entropy, (2) Pressure – volume, (3) Temperature – volume and (4) enthalpy – entropy (Mollier diagram). Polynomial Curve Fitting with Excel EAS 199A Fall 2011 EAS 199A: Polynomial curve ﬁt Overview Practical motivation: ﬁtting a pump curve Get data from the manufacturer. 9 Rotodynamic pump with system curve P. For example, while the middle of the pump efficiency curve is generally where a pump is operating at maximum efficiency in terms of pressure and flow rate, moving right on the curve above shows an increase in horsepower needed to maintain a flow rate as head increases. The Capacitor Discharge Calculator calculates the voltage that a capacitor with a a capacitance, of C, and a resistor, R, in series with it, will discharge to after time, t, has elapsed. Pump manufacturers provide Head versus Flow curve for various pump models. From this point, the user determines the flow and head at the pump’s best efficiency. Characteristic curves, especially of centrifugal pumps, are presented and it is shown how to match a pump to a system head. In particular, a characterization of the micromachined electron tunneling transducer has been carried out. Calculate the NPSH available and check with respect to the NPSH required. TDH = Static Height + Static Lift + Friction Loss. This calculator is good for anticipating results from pump tests. The Formula for PSI: Feet of Head/2. With changes in viscosity and pressure, slip correction indicates that flow capacity drops from a high of about 7 GPM to a low of about 3. We take the time to compare our calculators' output to published results. How do you calculate hydraulic pump flow? To find the output flow of a hydraulic pump, use this pump flow formula: Flow (GPM) = (RPM x Disp) / 231. vector([Pump Intake Press. Step 3 Select the proper Armstrong Water Heater/Water Temperature Controller. Pump Head – Performance Curve. 1 0 Qm3/h 0 10 20 30 40 50 60 70 80 90 An. Head is a measurement of the height of the incompressible fluid column the pump could create from the kinetic energy, that the pump gives to the liquid. For example, let us calculate, in SI units, the required drive power for an external gear pump with an overall efficiency of 85%. 5*ρ*A*v³*Cp*η (see also the video explanation) P= power [W] A= swept area of blades [m2] v=wind speed at hub height [m/s] ρ= density of air (1. to calculate the pump’s head performance curve. The acceleration curve is plotted on a time versus current curve along with the motor’s thermal limits to select the proper over current protection. The example included is for a pump that is pumping 600 GPM through 600 feet of 6" and 8" steel pipe. Enter information into any 3 of the following 4 fields and press calculate. Warning: This file type may contain malicious code. Pipes and turbines are then discussed along with their basic equations and definitions. This allows you to estimate the impact of entrained gas flow rate on the suction pressure. The head and flow rate determine the performance of a pump, which is graphically shown in the figure as the performance curve or pump characteristic curve. From this point, the user determines the flow and head at the pump’s best efficiency. 7 x 20000628 = 14000439. Note: If you wish, you could right click on the result, click format cell, choose percentage, and then click ok. Pump Definitions Dialog Box; Pump Controls; Pump Curve Dialog Box; Pump Curve Combinations. The main problem with using excel for any of the above S-curve examples (or any S-curve) is that it becomes really difficult to manage the S-curve data once the project begins. This will then provide the right pump curve as well as additional pump information. Each manufacturer sells different models of pumps. PCS (TM): 'Pump Curve Software' is a user friendly and elegant web-based (and offline) pump curve & selection software system; surprisingly intuitive and easy to use. Pool Pump Energy Savings Calculator Pool owners can save up to 90% when switching to one of our variable speed pumps. Calculation available in English & Metric units. The desired viscosity conversion method can be selected separately for each duty chart in the database and can also be deactivated, if desired. Features * Graph Water Supply Curve * Graph Sprinkler (CMDA, CMSA, & ESFR) Demand Curve * Graph Fire/Booster Pump Test * Graph Parallel Water Supplies. Probability calculator is a online tool that computes probability of selected event based on probability of other events. First of all, the data should be read form the pump curves. Substitute your H and then solve for Q. Example: College Dormitory Refer to the modified Hunter Curves. Calculate Pipe Friction Loss: Enter value, select unit and click on calculate. 1 1 1 1 1. Standard 1. As standard the Flowrate is from zero flow to 20% past the Best Efficiency Flow. Aug 30, 2016. XLS - solve catenary equations COMPRESS. Answer to It is proposed to run the pump in p11. Finding the slope of a curve at a point is one of two fundamental problems in calculus. Using the figures, a user can estimate the power requirement or efficiency of the pump based on its discharge. Motor efficiency: 65% (assumed) Option 2: 4 × 3 – 13 2,850 rpm. Most current pump curves can be seen on the web. 01745 x r x θ = 0. 01 Pump Off Time 1 Pump On Time 2 TON2 – TOFF1. This video is about an example in pump calculation using Excel or Numbers. I'm supposed to draw an OC Curve and have been looking online. Pump No 2 has a Max Head of 29m and Max Capacity of 66m3/hour. h (2r – h) = 0. National Pump Selector. Note that equation (8) performs the complete calculation from the base input level to the GRMS response for each natural frequency. Use of trade names does not constitute endorsement by the U. Then compare against the measurements. Download Calculation sheet for Fire finding Pump. The EPA conducted field tests to create curves which relate the Method 21 screenings to a mass emission rate. In Excel 2007 and 2010, click the bell curve chart to activate the Chart Tools, and then click the Design > Save As Template. Alternative Pump Applications. Since reliability calculations require the left portion of area 2under the X distribution curve and CHIINV happens to calculate the right side, we must use the equation below to determine the correct value for probability: CHIINV(probability) =1−α. Create the graph in Excel. That is not a simple task. 82” instead of the “standard calculation ART 220. This spreadsheet allows the user to find the pump power requirement (Watts or Brake Horse Power) for various feeder pipe diameters (in) and given a known flow rate (LPS), pipe length (m) and head (m) and then select a suitable pump based upon available pump characteristic data. Installed cost of pump and motor: $20,000 for 3,500 rpm. Allows you to calculate trapeze lengths and materials not provided in the standard NFPA. 1 1 1 1 1. Produce professional PDF reports that can easily be printed or emailed to your customer. Fluid slippage loss at impeller exit and volute loss are estimated. Minor losses are used to check sewer system surcharge. Extract the polynomial coefﬁcients for later use. Calculate heat loss for each room of your house. Head is a measurement of the height of the incompressible fluid column the pump could create from the kinetic energy, that the pump gives to the liquid. Lecture 11 Pumps & System Curves I. Using affinity laws, we can accurately calculate the pressure, flow and required speed and power of a pump from a specific known set point. Online calculator to quickly determine Water Flow Rate through an Orifice. Using excel, I created axle torque vs car mph curves for each gear, based on dyno curves, gear ratios, ire size, etc, and confirmed this. Knowing any two of the three variables allows you to find the third. The calculator uses the generally accepted equation shown at the bottom of the column to estimate the change in NPSHr as speed is decreased. The acceleration curve is plotted on a time versus current curve along with the motor’s thermal limits to select the proper over current protection. Then click OK. Our heating calculator / BTU calculator can help work out the appropriate heat output for each room of your home. Please note that higher the HP one uses does not mean that more water is pumped out. Microsoft® Office Excel® workbooks. Produce professional PDF reports that can easily be printed or emailed to your customer. Nov 13, 2018 - Download Rainwater Drainage Design Calculation Excel Sheets XLS. I'm supposed to draw an OC Curve and have been looking online. Coupling Efficiency is obtained from Supplier Manual. 064 H 2 = H 1∗2. So basically it looks like rectangular column graphs. The calculation for working out the pressure loss within an installation is as follows: Head Loss (Pc) = [Equiv. Converting Corrosion Rates To convert the corrosion rate between the mils per year (MPY) and the metric equivalent millimeter per year (MM/Y), you can use the following equation to convert mils per year to micrometers per year (MicroM/Y):. Chemical engineering students are usually taught to find the Darcy friction factor using a Moody diagram, which is a summary of a large number of empirical experiments. Oil and Gas Presentations required steam surface condenser as per HEI spreadsheet. The fluid slippage is modeled by the slip factor approach. Some of the key features of the spreadsheet are: Estimates pressure drop in suction & discharge piping based on 2-K method. The required pressure just after the pump (total dynamic head) includes pre-existing pressure of water entering the pump, pressure needed to overcome elevation differences (sometimes pressure is added if flowing downhill), and the pressure losses due to friction in the pipes in order to produce the required pressure at the emitters, or sprinklers. This centrifugal pump power calculator is meant to quickly calculate mechanical power required for a specific set point. its combustion chamber size. Application is developed in MS Excel, is multi-language, supports Imperial and Metric units and solves the following main. COUSCOUS - the CAPE-OPEN Unit-operations Simple package is shipped with COCO. 3 LSU AgCenter Pub. The inspiration came from Pump Sizing Calculation from CheCalc. In-floor suction outlet cover/grate must. Hint: If the calculation will not complete, first run a case where you pick a design point from the representative pump curve provided to prime the cells with normal values for the solver, then rerun with the actual pump design conditions that require an extrapolated pump curve. Engineeringanddesign. manufacturer’s pump curve (B) of fig. The package exhibits more than 100 property calculation methods with their analytical or numerical derivatives. If you know the shape of a pump performance curve at a certain speed or with a certain impeller diameter, you can use the affinity laws to predict the performance of the same pump at a different speed or with a different diameter impeller with a high degree of accuracy. First of all, the data should be read form the pump curves. Perform the regression on the Q^2 vs H and the A, B coefficients will then fit the above equation. Free delivery on millions of items with Prime. 027 55 2 for double suction RPM 2980 1480 980. The following buttons are located above the curve points table on the left. A tangent is a straight line that touches a curve at a single point and does not cross through it. Select the numbers and the row "mV mA mW". I suspect each manufacturer will have their own set of curves. Since reliability calculations require the left portion of area 2under the X distribution curve and CHIINV happens to calculate the right side, we must use the equation below to determine the correct value for probability: CHIINV(probability) =1−α. You can use this calculator to calculate the voltage that the capacitor will have discharged after a time period, of t, has elapsed. Alternatively, you can create an approximate pump curve using the equation H = A + BQ^2. Pump Station Typical Layout. Hence the importance of using those curves and the calculation to determine the operating point parameters can not be overemphasized. The fluid slippage is modeled by the slip factor approach. Like your refrigerator, heat pumps use electricity to move heat from a cool space to a warm space, making the cool space cooler and the warm space warmer. At the given operating point of head and flow, the pump is already slightly cavitating due to insufficient NPSH and the developed head has dropped by 3 percent while the flow rate is fixed at some value. 11 Suter Curve 23 2. When selecting a new pump, an engineer will review pump curves to make sure the pump chosen will run at the best efficiency point for the given application. This document gives brief instructions on generating the parameters or coefficients for the water-to-air heat pump models in cooling mode. Polynomial Curve Fitting with Excel EAS 199A Fall 2011 EAS 199A: Polynomial curve ﬁt Overview Practical motivation: ﬁtting a pump curve Get data from the manufacturer. Please note that higher the HP one uses does not mean that more water is pumped out. These general curves can be used for any specific project. The curves are then plotted for the operating characteristics which include: Pump characteristics. Knowing any two of the three variables allows you to find the third. 2, a positive displacement pump curve shows the influence of viscosity on slip with a correction chart. Integrals and Area Under the Curve. x for Excel calculates pressure drops of flowing liquids and gases in pipes (laminar and turbulent flow). Assume isentropic process, i. Moreover, all operations in this method could be done wi thin EXCEL itself. Example 8 SP2610X15 (1. Sample calculation: Estimate pressure drop across 100 mesh lined Basket Type strainer provided in a 6″ line with following data. 006 m3/s, 24. In about 1640, the Flemish chemist Jan Baptist van Helmont observed that when he burned charcoal in a closed vessel, the mass of the resulting ash was much less than that of the original charcoal. The first curve of the section is the Hyperbola, y=c(x^2 - a^2)^. I'm a Mechanical Engineering student and I'm writing a lab report where we collect data regarding the performance of a water pump. If turbocharged and hp is about same magnitude as torque, you will shift beyond hp peak, but not at redline. For example, let us calculate, in SI units, the required drive power for an external gear pump with an overall efficiency of 85%. This innovative cell formula verification tool turns Excel into an engineer's calculation pad. (4) Number of molecules of air in sample = A B 5 Pressure / 10 Pa – 1. See “Pump Ed 101,” Pumps & Systems, February 2010, for a detailed description of suction specific speed and suction energy. For example, if your stream or waterfall spillway will be 10 inches wide, you will need a pumpthat produces an excess flow of 1000 GPH at your waterfall's height. In the software, rename the current (blank) results table to '50%' (this will be the only table if results from Exercise A are not available). 3, the desired operating point (best efficiency point - BEP) o f the pump can be obtained from the intersection of the system - curve and the si mulated. Table 1: Calculation of the derivative of an example titration curve. Example: The output flow of a pump spinning at a rate of 2000rpm. The power requirement of the pump depends on a number of factors including the pump and motor efficiency, the differential pressure and the fluid density, viscosity and flow rate. Excel Extra Functions - interpolate, cubic spline, polynomial curve fitting, and etc. the calculator will automatically determine the current pump efficiency. Pump curve and system curve can be fitted into a second order polynomial. A dynamic model is required as shown in Appendices H and I. Be able to measure the pump curve and pump efficiency versus flow rate; Be able to perform polynomial curve fit with the Excel Trendline function; Notes and Supplemental Files. The structures are beams. This Excel based calculator allows you to compare the energy consumption of two pumps operating under different system conditions. These positive displacement pumps are engineered to deliver variable rates and constant head capable of handling various types of applications with superior sand-lifting capability. Pump Head – Performance Curve. Spreadsheet. This is a handy calculator for evaluating a centrifugal pump’s hydraulic condition in the field. Pump No 1 has a Max Head of 30m and Max Capacity of 36m3/hour. area of ABCFILM. Pump Head Calculation: Safety Factor Head H safety. Q = Flow rate in m 3 /sec. Process Pumps. Read chart vertically until you intersect the correct curve, then read the chart horinzontally … Continue reading Fixture Counts. AMT Pump Company is A Subsidiary of The Gorman-Rupp Company located in Mansfield, Ohio. In-floor suction outlet cover/grate must. PP = Injection pump pressure (PSI) 1 To calculate Packer Inflation Pressure for a withdraw test (pump out): G = [ (DP - DW) x. Microsoft® Office Excel® workbooks. When defining pumps, you can enter your vendor-specific pump curves to the database which will be stored for all your modeling projects. Finally we need to specify the fluid in the network. To calculate how fast a vehicle was traveling when it lost control rounding a horizontal roadway curve, given the radius, cross slope, and tire-pavement friction. In excel use linear regression simply by taking your Q-H data and squaring the Q. Note: Calculations are possible only, if Javascript is activated in your browser. But if you have used Plot Digitizer to create a chart representing the pump curve in Excel, you can easily plot the system curve and other data that you may be of interest in the context of analyzing a pump directly on the chart using standard Excel charting techniques. Time to heat solid slab. For submittal data documents click here Choose a product group All Accessories Boosters Commercial Pumps Fire Pumps Legacy products Residential Pumps. Pump No 2 has a Max Head of 29m and Max Capacity of 66m3/hour. You need to know the flow and pressure of one (non-trivial) point on the system curve. The program inclues a feature to evaluate the impact of. The book then takes a look at general pump design, volute design, and design of multi-stage casing. CliffsNotes is the original (and most widely imitated) study guide. V (mL) NaOH pH ∆pH/ ∆V 10. It can also be used to project pump and fan performance characteristics based on a known characteristic when used in combination with other affinity laws. National Pump Selector. Cooper and Jacob (1946) developed an approximation for the Theis equation and a data analysis method which does not require type-curve matching. PCS (TM): 'Pump Curve Software' is a user friendly and elegant web-based (and offline) pump curve & selection software system; surprisingly intuitive and easy to use. txt) or read online for free. H = Hydraulic load in meter of water. Remember that the total head developed by a pump and its NPSH required is the same for all specific gravities. com Business member or Plus subscriber. 31 feet of head creates 1 PSI of pressure. It also creates the curve for two parallel pumps or two parallel fans. This was the question: Disetronic Medical Systems and the United States Food and Drug Association (FDA) notified healthcare professionals and patients about a nationwide recall of D-TRON adapters, used with the D-TRONplus insulin pump.$ Select FIT CURVE from the MAIN MENU. Flow Test Graph. I can't seem to find anything that is helping. +Liquid or gas pipe & pump curve (Darcy-Weisbach) +Water pipe (Hazen-Williams) +Water pipe & pump curve (Hazen-Williams) Compressible (gases): +Weymouth, Panhandle A (and B) equations (compressible gases) +Choked flow of gas from tank through pipe +Gas leak rate through hole +Rayleigh flow (compressible with heat transfer but frictionless). Cummins is an established manufacturer of premium custom diesel fire pump drive engine packages. Where the two curves cross, is where the system operates relative to flow rate and head. 00 and the low price target for PUMP is $5. Answer to It is proposed to run the pump in p11. 24 figureto pump water at 20C through the system in Fig. This is a guide to S CURVE in. The Cooper-Jacob calculator presented here estimates the drawdown for a given well location over time. One way to approach this is to set the pump speed and then vary the pump rotor diameter until the difference between the two C H s, called D(CH) on the spreadsheet, is negligible. The pipe is 10-cm-diameter commercial steel. percent by mass (w/w%) salt for the standards and determine the best fit for the data points. Switch on the IFD7. (4) Number of molecules of air in sample = A B 5 Pressure / 10 Pa – 1. A pump performance curve indicates how a pump will perform in regards to pressure head and flow. 7 x 20000628 = 14000439. V (mL) pH 20. Langelier Index calculator (online calculator) This calculator helps you determine the scaling potential of the water by using the Langelier Saturation Index Give the values of your water analysis. For example, while the middle of the pump efficiency curve is generally where a pump is operating at maximum efficiency in terms of pressure and flow rate, moving right on the curve above shows an increase in horsepower needed to maintain a flow rate as head increases. In the pump vs. 12 Frequency Controlled Pump Systems (Soft -stop/Soft-start of Pumps) 24. Formula – 1. This is my request beside this if you can suggest some books for it. The first thing to look at is the motor characteristic. , acting both in the axis of the bolt and in the plane of the connected parts. coefficients for the curve-fit model. 4-conduitesgravitaires1-4. Based on the principle of gear engagement, the equation of rotor tooth profile has been reduced in this paper and has drawn the actual cycloid tooth profile by MATLAB software, the data obtained from MATLAB Workspace is processed by EXCEL, so the parameter drawing of the full gear tooth profile curve is very easy in AutoCAD software platform. The equations are then derived from this data. 8 Important Terminology Well yield: is a measure how much water can be withdrawn from the well over a period of time and measured in m3/hr or m/hr or m3/day. Hint: If the calculation will not complete, first run a case where you pick a design point from the representative pump curve provided to prime the cells with normal values for the solver, then rerun with the actual pump design conditions that require an extrapolated pump curve. Calculate the density of each solution. Pump Head – Performance Curve. There are a great deal of gantt chart excel templates from the net. If a pump’s efficiency curve is plotted together with the pump and system curve, it is evident if the pump is operating closely to the best efficiency point (BEP) or not. The Excel™ spreadsheets (WaterAir_PE_Cooling. Note that NPSHr and NPSH3 are essentially the same thing. Sample characteristic curve for a pump is shown in the following figures. In-floor suction outlet cover/grate must. Bernoulli Calculation The calculation of the "real world" pressure in a constriction of a tube is difficult to do because of viscous losses, turbulence, and the assumptions which must be made about the velocity profile (which affect the calculated kinetic energy). Process Pumps. Switch on the FM50 pump within the software using the Pump On button. Department of Energy (DOE) regulations will go into effect that require Dedicated Purpose Pool Pumps (DP3) manufactured in or imported into the U. 8 and Fig 2. Since this is a fake pump, these points will be based on the results of a hydrant flow test. 16 H–Q curves of a pump at different speeds. Polynomial Curve Fitting with Excel EAS 199A Fall 2011 EAS 199A: Polynomial curve ﬁt Overview Practical motivation: ﬁtting a pump curve Get data from the manufacturer. 63 inches for this pump. Excel is a good utility program for data recording and plotting, and is actually used a lot by. A pumping test is a field experiment in which a well is pumped at a controlled rate and water-level response is measured in one or more surrounding observation wells and optionally in the pumped well (control well) itself; response data from pumping tests are used to estimate the hydraulic properties of aquifers, evaluate well performance and identify aquifer boundaries. Formula – 1. Microsoft Excel 2007 can produce a variety of graphs and charts, including scatter plots, line graphs and pie charts. Pump curve and system curve can be fitted into a second order polynomial. Obviously deeper one installs a pump, less water it pumps. Finding the slope of a curve at a point is one of two fundamental problems in calculus. Step 3: In this step, the graph will be ready. There are a great deal of gantt chart excel templates from the net. Read up to the curve that best fits the application. Extract the polynomial coefﬁcients for later use. These general curves can be used for any specific project. For fire fighting system in high rise building we require 2 pumps 1) Jockey pump & 2) Main Pump to maintain pressure in risers. In about 1640, the Flemish chemist Jan Baptist van Helmont observed that when he burned charcoal in a closed vessel, the mass of the resulting ash was much less than that of the original charcoal. In some cases, a formula can run successfully before it tries to calculate itself. A tangent is a straight line that touches a curve at a single point and does not cross through it. Plot the stimulus strength on the y-axis. Using the figures, a user can estimate the power requirement or efficiency of the pump based on its discharge. In particular, a characterization of the micromachined electron tunneling transducer has been carried out. Immediately look below the Excel table and select “use wizard”. System Curve Development We’ve calculated TDH and head losses for a single flow condition A system curve represents a range of TDH and flow conditions DON’T use a conservative approach to calculate a system curve for a “new” system (use C ≈ 140). Pump testing procedure: PowerPoint slides, PDF slides, PDF slides 2-up, or 3up handouts Updated 26 Nov 2011; Slides on polynomial curve fitting: one slide per page or 2. (Depends on the type of pumps you’re buying. 5-inch plumbing networks. multiply (vectorOrValue) Parameter:. and you can find example calculation sheet from material section. Allows you to calculate trapeze lengths and materials not provided in the standard NFPA. but they are all read the same. Integrals and Area Under the Curve. The package exhibits more than 100 property calculation methods with their analytical or numerical derivatives. 2 To calculate Packer Inflation Pressure for an injection test (pump in):. This course will teach you about fire protection design procedures and how to do calculations. Fire protection systems design engineers always perform hydraulic calculation for fire fighting systems so as to estimate fire pump size and network pipe sizing. dose (mcg/kg/min) x weight (kg) x 60 min/hr concentration (mg/cc) x 1000 mcg/mg Created: Friday, December 28, 2001 Last Modified:. It is a class of curves coming under the roulette family of curves. Production Mix Model Excel 2259 Free downloads Steam table calculator built as an MS Excel add-in. 006 m3/s, 24. Set PIP = myCalc. The pump flow rate at that head. As seen in the figure below, the corresponding curves on the y-axis intersecting with the percentage output gives us the required answer. Then people and AHJs would not start questioning the pumps. 1 0 Qm3/h 0 10 20 30 40 50 60 70 80 90 An. COUSCOUS - the CAPE-OPEN Unit-operations Simple package is shipped with COCO. Angle of the sector = θ = 2 cos -1 ( ( r – h) / r ) = 174. PPM means "parts per million," so to calculate it you divide the amount of the solute by the total amount of solution, them multiply by 10^6. I'm a Mechanical Engineering student and I'm writing a lab report where we collect data regarding the performance of a water pump. Residential Load Calculation spreadsheet manual: 1- Check the box in cell D6 next to the title of the sheet to use the “optional calculation ART 220. So basically it looks like rectangular column graphs. The WEEKNUM function determines the week number during the year for the date and the second argument sets which day of the week is the first day (2 sets the start of the week as Monday). Read up to the curve that best fits the application. P in kW = Here. The following procedures for highly viscous Newtonian fluids are available in Spaix 5 Quick&Easy:. 3241-H: Pump Curves a pump to specific needs. Pump Station Typical Layout. Q = Flow rate in m 3 /sec. BOATS / YACHTS. Pump Calculator Spreadsheet. To calculate how fast a vehicle was traveling when it lost control rounding a horizontal roadway curve, given the radius, cross slope, and tire-pavement friction. Polynomial Curve Fitting with Excel EAS 199A Fall 2011 EAS 199A: Polynomial curve ﬁt Overview Practical motivation: ﬁtting a pump curve Get data from the manufacturer. Also did the same with hp curves vs mph, with same results. 2}{SG}\right) + f1\left(\frac{L_1}{ID_1}\right)\left(\frac{V^{2}}{2g}\right) +f2\left(\frac{L_2}{ID_2}\right)\left(\frac{V^{2}}{2g}\right). Polynomial Curve Fitting with Excel EAS 199A Fall 2011 EAS 199A: Polynomial curve ﬁt Overview Practical motivation: ﬁtting a pump curve Get data from the manufacturer. , acting both in the axis of the bolt and in the plane of the connected parts. You can try various combinations to come up with an appropriate combination of ring and pinion gear ratio and tire diameter for your vehicle. Note: If you wish, you could right click on the result, click format cell, choose percentage, and then click ok. For additional information please see the AES Master Catalog or call our Tech Support Line at 877-347-4788. Currently in beta. Systematic instructions to perform type-curves matching follow. Based on the brake power required, motor kilowatt or hp will be selected. Finally we need to specify the fluid in the network. You will discover a whole lot of Gantt chart excel templates on the internet. pumps operating in parallel are exact. Coverage for all employee benefit plans sponsored by the company for its employees, including plans that aren’t subject to ERISA. freedomcalculator. At the given operating point of head and flow, the pump is already slightly cavitating due to insufficient NPSH and the developed head has dropped by 3 percent while the flow rate is fixed at some value. The user can then plot the saturated liquid and saturated vapor lines in one of four common formats: (1) Temperature – entropy, (2) Pressure – volume, (3) Temperature – volume and (4) enthalpy – entropy (Mollier diagram). This innovative cell formula verification tool turns Excel into an engineer's calculation pad. The program inclues a feature to evaluate the impact of. 1, many different design criteria could be selected, ranging from a density of 0. Pump testing procedure: PowerPoint slides, PDF slides, PDF slides 2-up, or 3up handouts Updated 26 Nov 2011; Slides on polynomial curve fitting: one slide per page or 2. Answer to It is proposed to run the pump in p11. In addition it provide a graph of the curve with shaded and filled area. Pump Curve Combination Editor ; Flow-Efficiency Curve Dialog Box; Speed-Efficiency Curve Dialog Box. Use the following method to convert the absorbance value of the unknown to concentration, in mol/L. (Equation 7) So, by using a reasonable estimated BSFC and a reasonable best-power air to fuel ratio, you can use Equation 7 to estimate the airflow required for a given amount of horsepower, and with Equation 3, you can calculate the airflow of your engine at a given RPM if it was operating at 100% VE. The structures are beams. It also creates the curve for two parallel pumps or two parallel fans. COUSCOUS - the CAPE-OPEN Unit-operations Simple package is shipped with COCO. Net positive suction head available = absolute pressure head at the pump suction – liquid vapour pressure head. Check out our easy-to-use pool volume calculator to calculate the volume of your swimming pool water by choosing the shape, dimensions and depth. You need to know the flow and pressure of one (non-trivial) point on the system. Introduction to O. This wealth of information is continually reviewed and updated, providing our subscribers with the highest level of insight into engineering concepts, methodologies, equations, hydraulic analysis, and program bulletins. Operating point is calculated by solving these equations for positive roots. The BHP per stage is 1. Note that NPSHr and NPSH3 are essentially the same thing. The gallons per minute (GPM) required and total head (TDH), as determined above, can be used directly on the pump performance curves to make the proper pump selection. Some of the key features of the spreadsheet are: Estimates pressure drop in suction & discharge piping based on 2-K method. Download Fire Pump Sizing Excel Calculator This excel sheet calculator performs all hydraulic calculations for fire sprinkler system. Trapeze Calculation. This centrifugal pump curve calculator is meant to quickly calculate the different operating conditions when a centrifugal pump is sped up or slowed down. You may download this template and use it for Pump Affinity law Calculations. Pump Calculator Spreadsheet This spreadsheet allows the user to find the pump power requirement (Watts or Brake Horse Power) for various feeder pipe diameters (in) and given a known flow rate (LPS), pipe length (m) and head (m) and then select a suitable pump based upon available pump characteristic data. An example of two different size impellers is shown in the following pump curve diagram. and the feed composition remain unchanged. area of ABCFILM. Then, I got to thinking that if I could do a curve fit, I could use the equation for the curve to solve for the C V; not a big time saver for picking a particular valve, but if I saved the spreadsheet as a tool or wanted to play “what if” games, it could be handy. Output derived functions to a Microsoft Excel formula format. the calculator will automatically determine the current pump efficiency. Although a number of factors determine the price per gallon, the price of crude oil makes the most impact. On the chart, modify the date range to see if the pump performance has changed over time. • VRh = Rheobase. Compare & Calculate Your Savings. In addition, the curve can be used as a cam to convert uniform circular motion into uniform linear motion (Brown 1923; Steinhaus 1999, p. Excel base Programs (Electrical Engineering): Designed by: Jignesh. These positive displacement pumps are engineered to deliver variable rates and constant head capable of handling various types of applications with superior sand-lifting capability. Plot the stimulus strength on the y-axis. Use A Performance Curve. XLS - solve catenary equations COMPRESS. 00 Drawdown One (D1) Pump On Depth 1 Pump Off Depth 1 DOFF1 – DON1 × Area ÷ (TOFF1 – TON1) = GPMD1 9. S-curve is used for different purposes. Note: Ampacity is based on a curve fit to MIL-STD-975. If the pump is too powerful, it will “short cycle. It computes annual operating costs for both and the payback period for the more efficient system. 63 impeller pump curve line to plot all pump properties for this system. 16 gpm/ft2 (6. Chemical engineering students are usually taught to find the Darcy friction factor using a Moody diagram, which is a summary of a large number of empirical experiments. cos -1 ( ( r – h) / r = 87. 81 = Average Intensity of gravity. and combine it with other, similar files for other lines on the chart to reproduce the pump curve as a chart/graph in an Excel spreadsheet. First, we''ll develop the equations that determine the liquid velocity in a simple pump and pipe system. Find your yodel. Let ℜ be the region in the first quadrant bounded by the curves y = x 3 and y = 2 x − x 2. Pumps with different pump curves should generally not operate in parallel. Calculate the NPSH available and check with respect to the NPSH required. Deduce the specific speed of the pump. 5 Volume / 105 m3 0 0. Installed cost of pump and motor:$20,000 for 3,500 rpm. Performs civil engineering calculations for hydrology, open channels, culverts, gravity sewer, transmission lines, traffic/road geometry, surveying/earthwork, pavement, concrete floors and unit conversions. Emetor is a collection of valuable resources for designing electrical motors and generators. 63 inches for this pump. Solving For Water Horsepower. 24 figureto pump water at 20C through the system in Fig. The Excel™ spreadsheets (WaterAir_PE_Cooling. The safety factor can be a total multiplier or additional head. Area under the curve = Area of (rectangle ABLM + Trapezoid BCFI). Simplify production for wells characterized by highly viscous fluid and high sand cut with progressing cavity pumps (PCPs). The above i-v characteristic curves defines the resistive element, in the sense that if we apply any voltage value to the resistive element, the resulting current is directly obtainable from the I-V characteristics. The worksheet shows you how to calculate for minor loss constants for system elements more specifically by defining Tee, check valve, exit, and entrance. The workbook uses the Coolprop Excel add-in to compute thermophysical properties of a baker’s dozen of fluids. MC and Loadshape Version 3. com Plus subscriber, to view his or her SecurePRO™ card you must be a ProZ. Cement Grinding : Separator Efficiency Test by Tromp curve calculation. Maintenance cost: 10% of installed cost per year. Section A -- Centrifugal Pump Fundamentals A-9 System Curves For a specified impeller diameter and speed, a centrifugal pump has a fixed and predictable performance curve. Pump Definitions Dialog Box; Pump Controls; Pump Curve Dialog Box; Pump Curve Combinations. The spreadsheets were written in Microsoft Excel version 9. Lines of constant pressure curve from the lower left to upper right on a T-s diagram. News, email and search are just the beginning. You may download this template and use it for Pump Affinity law Calculations. Calculation according Hydraulic Institute Standards graphs. This version is usable for browsers without Javascript also. Download also: NFPA Tables In One Excel Sheet, Fire Sprinklers and Fire Pump Tables. When the OC curve is plotted, the sampling risks are obvious. The step-by-step calculation based an EOS is outlined below. Answer to It is proposed to run the pump in p11. GPM = Gallons Per Minute. Pipes and turbines are then discussed along with their basic equations and definitions. Calculate the known part of Suter curve. This calculator will be produce more accurate results compared to the one above which does not account for utility source impedance. 1 1 1 1 1. That is not a simple task. Answer to It is proposed to run the pump in p11. 11 FUNCTIONS WITH (x^2 - a^2)^1/2 AND x^m'. You can use this calculator to calculate the voltage that the capacitor will have discharged after a time period, of t, has elapsed. Figure 1: Sketch of Tree System Figure 2: Commercial Excel Data Entry Form. The number of molecules of air in the sample is constant. © Heartland Community College, CC BY 3. Note: Calculations are possible only, if Javascript is activated in your browser. Pressure Drop Online-Calculator Calculation of pressure drops of flowing liquids and gases in pipes and pipe elements (laminar and turbulent flow). Using the figures, a user can estimate the power requirement or efficiency of the pump based on its discharge. Average power Pavg can be calculated as below. 2} {SG}\right) + f1\left (\frac {L_1} {ID_1}\right)\left (\frac {V^ {2}} {2g}\right) +f2\left (\frac {L_2} {ID_2}\right)\left (\frac {V^ {2}} {2g}\right) H S y s = H + ( P 2 − P 1 ) ( S G 1 0. Residential Load Calculation spreadsheet manual: 1- Check the box in cell D6 next to the title of the sheet to use the “optional calculation ART 220. By closely monitoring the price of crude -- as well as keeping tabs on a. Fire Pump Testing. Delete: Deletes the currently highlighted row from the curve points table. To determine the total number of stages required, divide the TDH by the head/stage:. 1) Install piping so that the suction side of pump is connected to the reservoir tank and the pump outlet leads to the graduated container. It reads user-supplied pump performance data and calculates the coefficients of polynomials that approximate the characteristics for pump power, the boundaries of the working area, and the relations to compute the shaft speed of the pump. The pipe is 10-cm-diameter commercial steel. Time to heat tank. For the Viking Lobe pump curve shown above. The operating point is where the system and pump curves intersect. To calculate power by using polytropic head, we need polytropic efficiency. You can also use this step for other activities. 732 * V * I * PF * Motor Efficiency * Coupling EfficiencyV: Measured Voltage of Motor in VoltI: Measured Current of Motor in AmperePF: Power FactorMotor Efficiency may be considered as design efficiency or may be obtained from Motor efficiency calculation data through tests. c ( r – h) = 0. Curve fitting for the Strength-Duration Data The equation used to fit the strength-duration data is shown below: − = − k Rh t e V V 1 1 • V = stimulus strength ( dependent variable ). If you don’t have a pump curve maybe you can assume P is constantly as a first approximation when working backwards. From this point, the user determines the flow and head at the pump’s best efficiency. Mark the pump curve using the 30. Sample characteristic curve for a pump is shown in the following figures. The example included is for a pump that is pumping 600 GPM through 600 feet of 6" and 8" steel pipe. This is the power given to the pump through Electric Motor. Obtain the relative information from the manufactory, which include P-Q curve, pump speed curve, efficiency curve (or power curve), rated flow rate, head, speed and the total moment of inertia of the pump. , acting both in the axis of the bolt and in the plane of the connected parts. (this is the npsh shown on the pump curve. The spreadsheet is simple. system to that for the pump (after selecting a the pump type) by specifying the pump speed and pump rotor diameter. Resources • Excel Tools 1. A field test of the pump head at one or more measured flow rates can help determine the actual, current, pump and system H-Q curves. when using. This will then provide the right pump curve as well as additional pump information. The curve-fit model performance is not affected by the number of data points and a minimum of 5 data points is required since the governing equations require 6 coefficients. This is the head and flow rate for the given pump/system combination. The calculation for working out the pressure loss within an installation is as follows: Head Loss (Pc) = [Equiv. Pump Station Typical Layout. The script above is equivalent to: Make a System calculation, find the PDP and PIP curves, and subtract them to get the DP across the Pump. “Turndown ratio” is a measure of how much a pump’s capacity can be reduced from its maximum flow rate. RPM = Rotations Per Minute. The first point on the curve at zero flow is referred to as “Shut Off” and the last point at maximum flow is “Run Out”. Equivalent pipe length. The gallons per minute (GPM) required and total head (TDH), as determined above, can be used directly on the pump performance curves to make the proper pump selection. How do you calculate hydraulic pump flow? To find the output flow of a hydraulic pump, use this pump flow formula: Flow (GPM) = (RPM x Disp) / 231. Pumps can generate high volume flow rates when pumping against low-pressure head or low volume flow rates when pumping against high-pressure head. It reads user-supplied pump performance data and calculates the coefficients of polynomials that approximate the characteristics for pump power, the boundaries of the working area, and the relations to compute the shaft speed of the pump. The Specific Enthalpy is then multiplied by the Mass Flow to get the Energy Flow:. Because this person is not a ProZ. Microsoft Excel (192KB). where y is specific weight. Yield Curve Simulation Excel Model & Automated Commentary Yield Curve Simulation Model (automated commentary) showing global impacts of yield curves on bond valuations financial modeling modeler financial modelling model citizn simulation Hello,Please I need help in solving this question. Solar Water Pump - Let the solar water pumping experts LORENTZ advise you on the best water pumping system for your needs. Based on the principle of gear engagement, the equation of rotor tooth profile has been reduced in this paper and has drawn the actual cycloid tooth profile by MATLAB software, the data obtained from MATLAB Workspace is processed by EXCEL, so the parameter drawing of the full gear tooth profile curve is very easy in AutoCAD software platform. com The system curve equation for a typical single outlet system such as in Figure 2-10 is: HP = F EQH v(q) +∆TS The system curve is superimposed on the pump performance chart. Head is a measurement of the height of the incompressible fluid column the pump could create from the kinetic energy, that the pump gives to the liquid. Starting torque is the torque transferred by the shaft coupling during run-up (see Start-up process). 5, with 6 variations of a and c given. Hence the importance of using those curves and the calculation to determine the operating point parameters can not be overemphasized. If you wish, you can skip ahead to the bottom of this post to grab the excel example.