Vacuum Pipe Sizing Calculation Xls This article follows up with an introduction to sizing pressure-relief devices to ensure that they function properly. Excel's Goal Seek varies the guess value of Re until it matches the calculated value of Re. equations used for calculations Annular Pressure Losses = (1. ) Equivalent K-factor calculator. AIR/VACUUM VALVE SIZING Some publications list a rule of thumb that suggests Air/Vacuum Valves be 1 in. Wall thickness of a pipe is calculated using Pressure, Temperature and materials. You may want to experiment by adding or removing significant and occasional appliances to see how it impacts the suggested generator size. But I made it better. Scalable and heavy-duty solutions for industrial and manufacturing sites. The larger this value, the higher the flow rate through the valve will be at a given pressure drop. #N#Design Temperature. If you are figuring to just the springline, then one 25 ton load should net you almost 150 lf per load, and so on. 30mm in width over a length of 300mm and F n is the load which the. They provide a practical method of bulk-solid material transport. The theoretical analysis for punp-down time calculation for a vacuum system consists of following procedural steps: Step 1: calculation of Knudsen Number to determine whether the flow is viscous or molecular. if you want to turn over a 5000L system in an hour then you need to adjust pipe size to allow that rate of flow within the gravity specs - then the pump is running at a minimum with head being solely to do with. Download free Excel spreadsheet templates for Darcy Weisbach equation/pipe flow calculations. ExcelCalcs is a community who share an interest in making calculations with MS Excel. VACUUM CALCULATOR. Pipe Weight Per Foot Calculator. A true Windows application with its own help screens, the System Syzer program isn't restricted to the physical size of the original plastic wheel version. Pipe dimensional data as per ANSI/ ASME and JIS is available. Contact LDS Vacuum with any questions: Phone (407)862-4643 via Fax (407)862-8723 or [email protected] HOME STANDBY GENERATOR SIZING CALCULATOR: Use our standby generator sizing tool. If the inlet gas contains dust or foreign particles, a suitable inlet filter should be installed at the inlet port. Input data are design flow, elevations of ground initial and final. Find Surface Area of different objects like Cone, Cube, Cylinder, Pipe, Prism, Pyramid, Rectangular Box, Sphere, Torus (Ring), Tube and more Please enter valid values for Radius of base of pipe(R), Height of pipe(H) and click 'Calculate'. Here is a hydrocyclone sizing calculator with immediate access to all design equations needed for your hydrocyclone design calculation in an online XLS spreadsheet format. Vacuum breaker and air valves are useful tools in the industry for protecting pipelines against vacuum or near vacuum conditions. Duct sizing Excel program. Welcome to our Accumulator Sizing Calculator. Force momentum principles applied to pipe flow. Out of range. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Easily compute water fixture units (WSFU) with this new calculator. Pressure Vessel Design Calculations Handbook This pressure vessel design reference book is prepared for the purpose of making formulas, technical data, design and construction methods readily available for the designer, detailer, layoutmen and others dealing with pressure vessels. This Excel templates the required pipe diameter for a pipe flow using Darcy Weisbach friction factor equation. Sizing (ENGINEERING DESIGN GUIDELINE) CALCULATION SPREADSHEET Excel Format: (British Unit) across a flow restriction or a fluid velocity in a pipe. Example - Vacuum Evacuation Time. Pressure Drop Online-Calculator Calculation of pressure drops of flowing liquids and gases in pipes and pipe elements (laminar and turbulent flow). 02 x 1000 ft Friction Loss (hf) lb f - sec2 π x (pipe radius)2. Volume is the quantification of the three-dimensional space a substance occupies. The line sizing charts on each case specification sheet can be used to size the subfeed branch lines. Pressure Loss Data for Sizing Vacuum Pipe, Low Pressure Vacuum System. Solving Colebrook Equation for Pipe Design, Sizing and Optimisation Calculations: Solve Within Excel Worksheet - No VBA, MACRO, UDF of SOLVER [Kumar, Mr M Anil] on Amazon. Oil Pipe Diameter A guide to the appropriate sizing of Hydraulic pipes can be carried out here. 00 Pressure gain/loss due to elevation change-3. Q is the water flow rate in the pipe, m3/hr, D is the pipe diameter, mm. ETAP, Jefferson Electric. Upper Weld Leg Size(Weld 41): 0. (25 mm) per 1 ft. In case you need to convert from/to Normal or Standard flow rate use the links above. In this lesson you'll learn how to create simple formulas and calculations in Excel. Hydraulic Power. B) Pressure / Vacuum Relief Valve Settings (As per API 2521) Pressure/Vacuum valves on atmospheric pressure fixed roof tanks are usually set at ½ oz/in2 (22 mm WG) pressure or vacuum. Q is the water flow rate in the pipe, m3/hr, D is the pipe diameter, mm. pipe runs 1-2, 2-4 and 22mm tube for pipe run 4-6, the reworked progressive pressure drops are 0. The Medical Gas Pipe Sizing Program allows you to size vacuum systems using the procedures outlined in NFPA 99. By Lance MacNevin sizing PIPES FOR FLOW RATES THE PLASTIC PRESSURE PIPE DESIGN CALCULATOR Developed by the Plastic Pipe Institute’s Building. Schedule Numbers for pipe size/wall thickness combinations are approximated to get a uniform relationship equal to 1000 times the P/S (P=Design Pressure and S=Allowable Stress) expression contained in the modified Barlow formula for pipe wall thickness. 344” Offset Bend Calculation. Valve/FRL Sizing for Cylinder Actuation Air Flow Q (SCFM) if Cv is Known Cv if Air Flow Q (SCFM) is Known Air Flow Q (SCFM) to Atmosphere. ) Equivalent K-factor calculator. D Swing Check Valve, full open Square Inlete, Steel 90° Elbow, flanged 45° Elbow, screwed 45. In layman’s language, dehumidification process is the removal of water from the surrounding air. 90,000 Btu input. D is the outside diameter of pipe in feet. You really do need to worry about pressure loss, especially when using 1/2 inch iron pipe. com (outside Minneapolis/St. xls 830 Pipe sizing program for hot water supply or overheated water, water canalization, piping in cold water or hot water of sanitary use. pdblowers, Inc. These Excel Templates come with a preset column, fields, rules and formulae and you just need to change the column values as per your requirements. In the equation, f D is the Darcy friction factor, L is the pipe length in feet, I. 1-866-468-9814. End pressure = 43. Please fill the corresponding fields and click the "Calculate" button. Longest Length Method: The size of each section of gas piping shall be determined using the total length of piping from the meter to the most remote outlet and the load of that section (see calculation example in “Figure A” use steps 1 – 5. Note that this procedure assumes all wires are of equal size. To become a registered user, enter your email, then submit and fill out the rest of the form. A true Windows application with its own help screens, the System Syzer program isn't restricted to the physical size of the original plastic wheel version. It consists of taking information about your home's construction materials, insulation levels, number of windows, sizes of rooms, etc, and making a calculation based on those factors to determine the. 14 Shell Defelection and rotation due to nozzele forcess excel 15 Basis for nozzle tank load check Excel 16 Tank Pressure and Vacuum Protection calculation excel 17 Tank heat loss calculation excel 18 Material properties as per ASME III. About Hydronic Pipe Sizing Methods Pressure Drop Calculation Revit computes pressure losses in piping based on the geometry and roughness of piping, fluid density, and fluid dynamic viscosity. The Uponor pipe heat-loss calculator uses cylindrical thermal resistance methodology, as supported in ASHRAE handbooks, to determine the pipe heat loss and surface temperature for aboveground building applications. Pipe load calculator solving for internal vacuum pressure given vacuum load per linear length of pipe and inside pipe diameter. Use our XLC add-in for Excel to display cell formulas as easily readable mathematical equations. Vacuum: from a practical sense, vacuum may be defined as the condition of a gas under less than atmospheric pressure. The pipe (conduit) is in lengths and needs to be cut before bending into the required size. Manning Formula Uniform Pipe Flow at Given Slope and Depth. Infinity Pipe Systems Aluminium Compressed Air Pipe Sizing Chart allows you to determine the diameter (mm) of the compressed air pipe main line. Select a subscription plan and enable the full service: Switch between metric and imperial units in one click. 1 excel FIRST PAGE OF EACH CALCULATION FILES ARE AS BELOW:. Water Demand Calculations Excel Sheet - XLS Calculator. We charge members an annual subscription fee, we offer 50%. Tubular Street Light Pole (430V) height is 11 Meter which is in made with three different size of Tubular Pipe. Radiant Floor and Heat Loss Calculator Calculate the Heated Building, Basement, and Garage Envelope Walls, Doors, Windows for the BTU Requirements. For an installed system air leakage load can be estimated by "Drop Test / Pressure rise test" method. Pipe weight is counteracted by buoyancy force. This is the proper and scientific method for calculating AC size taught to HVAC technicians and recommended for use by professionals in the trade. With the example values given here, an assumed pipe diameter of 3 inches gives a calculated pipe ( 3. ENGINEERING DESIGN & PIPING/PROCESSING SOFTWARE TRAINING (AUTOCAD, PDMS, P&ID, HYSYS) AUTOCAD (2D/3D): This software is suitable for drafting and modeling. Calculations based upon SEMI F-32 (refer to PN 417) Component and system performance should be confirmed by physical testing. Inert Gas Purging Requirement Calculation May 17, 2017 December 16, 2018 Rifka Aisyah Calculation Purging is an activity used to remove oxygen in piping or vessels to certain concentration, for example 2%-mole. 5 RADIUS WELDED STEEL PIPE ELBOW BASED ON SMACNA) Delta P = (C x Vp) Vp = (V/4005)^2 Delta P = PSI pounds per square inch "C" = SMACNA Friction loss coefficient for 1. N = 2 for vacuum up to 22. - One cubic foot of LP gas - 2516 BTU This chart refers to low pressure LP, after regulation, Standard nominal pressure at the burner for Liquid Propane Gas is 11” of water column. Summary: This program calculates the minimum required trapeze modulus required based on NFPA 13 requirements and the Correct application of the data obtained from the use of this program is the responsibility of the user. Step 4 Calculate the amount of motive flow used by multiplying the Qm and Qs found in the tables by the Tabulated S. + Pipe walls require reinforcing at point of support. Uses slider bars for input. 3 Pipe Equivalent Length (L) For straight pipes use the actual length of the pipe. Many manufacturers market "high collapse" casing, which they claim has collapse performance properties that exceed the ratings calculated with the formulae in API Bull. Is the default density value of should be done? You did not write this way consistently. 5 inch size is the minimum standard pipe diameter that will do the job. Here’s an example calculation using the compressed air pipe sizing table (table 1) and the equivalent pipe length table (table 2). 2 square mm. The Prinsco Drainage Calculator estimates the capacity of tile drainage systems. 5 PVC Sch 40 & HDPE TC-7 PVC Sch 80 Flex FMC RMC (GRC) Flex LFMC Flex LFMC-B IMC Select conduit size. Discharge Pressure. The image below shows an Excel spreadsheet that can be used as a pipe flow rate calculator, based on the measured pressure difference across a flow nozzle, venturi, or Orifice flow meter. to calculate CLR of 35° bend. Consulting factory is advised. Inert Gas Purging Requirement Calculation May 17, 2017 December 16, 2018 Rifka Aisyah Calculation Purging is an activity used to remove oxygen in piping or vessels to certain concentration, for example 2%-mole. Enter Duct Airflow (CFM), Duct Velocity (FPM), Duct Length and the number of bends. Part 2 Using Figure 10. Vacuum: from a practical sense, vacuum may be defined as the condition of a gas under less than atmospheric pressure. The theoretical analysis for punp-down time calculation for a vacuum system consists of following procedural steps: Step 1: calculation of Knudsen Number to determine whether the flow is viscous or molecular. During an emergency is not the time to discover your home's wattage needs. This is a spreadsheet I used to calculate line size of gas manually. Australian Standards. If it is cut short it will not meet the requirement of the drawing. The app can be used in the SI or US units. Since Warm Air Rises This Suspended Drying Rack Is DesignedHang Pictures On A WallTons Of Curtain Hanging Tips A Quick Way To Hang RodsHow To Hang PicturesHow To Hang A Planter From The Ceiling Toggle BoltHow To Choose The Right Ceiling Light Fixture Size At LumensCeiling Lights Or Hanging Online At Best Prices OnFloor To Ceiling Plant Stand Digitalesmarketing CoRoom Dividers Ceiling To. Download free Excel spreadsheets for engineering calculations. This Excel templates the required pipe diameter for a pipe flow using Darcy Weisbach friction factor equation. Glycol Mix Calculator Based on Pipe Size, Length of Run, Number of Solar Collectors and the Fluid Capacity of the Collector; Calculate the Percent of Polypropylene Glycol Mix with Distilled Water. Notes Tempratures in the above table are in degrees Celsius, as indicated (maximum 400 °C) 176 To 315°C 316 To 400°C of 12. of each pipe segment shall be obtained from the pipe sizing shown in Table 2. Pipe Size: 5 Schedule: 80 Nozzle is adequate for UG-45 requirements. A 8 inch pipe, with 1100 gpm runs at 7. By Lance MacNevin sizing PIPES FOR FLOW RATES THE PLASTIC PRESSURE PIPE DESIGN CALCULATOR Developed by the Plastic Pipe Institute’s Building. Pipe Velocity and Diameter: Calculate the velocity of water in a pipe and calculate the diameter of a pipe required for 5 fps pipe velocity. Second step to solve this sample problem is to calculate various pressure drop values in the suction side. +Force due to pipe bend +Liquid leak rate from pipe crack +Pipe network (12 pipes) +Pressure relief valve sizing +Time to empty tank +Water hammer (enter valve close or opening time) +Water hammer (instantaneous valve closure) Venturi, Nozzle, and Orifice Flow meters (D is pipe diameter): +Venturi (liquids) +Nozzle (liquids) +Orifice (liquids. xls 03_Capacitor kVAR Calculator. Valve sizing calculator. 0260 = WEIGHT PER METRE ALUMINUM SHEET WEIGHT (KGS) = LENGTH (MM) X BREADTH (MM) X 0. Air Valve Sizing Calculator. Web-Based Air Valve Sizing Software. These are just guidelines based on years building smokers but your mileage may vary!. This calculator calculates required thickness of a pipe under internal pressure based on criteria specified in section 302. Theoretical holding force. Conveniently and easily check if the selected pipe wall thickness is adequate to safely contain the high pressure fluid by implementing ASME B31. {{calculator. Vacuum Calculation - Leybold. Macro-enabled MS Excel spreadsheet for quick pipe sizing estimates 1 reviews 6,386 downloads (23905 views). Mark the length where the two ends of the string meet and measure the distance with a ruler. 43 Pipe Segment 2 Type / size PVC Cl 315 1. is the inner pipe diameter in inches, v is the average fluid velocity in ft/s, g is the acceleration due to gravity in ft/s 2, n i is the i-th valve, fitting, pipe contraction and enlargement and so on, and k i is the resistance coefficient. The size, shape, length, turns, and cap on the range hood ductwork adds resistance which reduces the amount of air the vent fan can move, requiring additional CFM for the fan. com Fluid Pressure Loss Calculations Factor D Pressure Loss = Equivalent Length of standard pipe in feet Pipe Tee Size Gate Globe Close Thru Inches. This may be as small as 5/8" (example service meat cases), or as large as 1-3/8" (example multi-shelf ice cream cases). Nominal Pipe Size (A) (SEE MATERIAL CHART) #N#Outside Diameter (Inches) (B) #N#Wall Thickness (Inches) (C) #N#Center Line Radius (Inches) (D) #N#Bend Angle (DEGREES) (E) #N#Lead Tangent Length (Inches) (F). The spreadsheet will only calculate one storm sewer line at a time. The spread sheet contains all formulas needed for calculation of pipe sizing. Complementary modules of calculations are incorporated in the program, has to know: Pipe table editor made up of 246 pipes with 11 categories of piping. Use a dot to represent a decimal point e. In dilution purging method, the inert gas simply. Pipe Size: 5 Schedule: 80 Nozzle is adequate for UG-45 requirements. The program will: Calculate: the collapse pressure, slope, and gravity flow in the pipe. (For Single Pump pool/spa combo, use the higher of No. Vacuum Pipe Thickness Calculator. … This Excel spreadsheet is included as a tool to design rock chutes for conservation practices. 93, for each of the 10 2-team parlays would be $38. Displays of Reynolds numbers, flow rates, relative roughness and. Trapeze Sizing Calculation App. Pipe Size (in) Test Time (sec) Factor Nominal Inputs mm Hg Units Start Pressure" Hg" Water Max Quicker Tests Better Resolution Specification SCFM/ft2 Min Acceptable Range of Start Pressure Lower Forces New Specification Change in pressure Min/ Nom Acceptable Range of Change in Pressure psi. The pipe size is 8" and the maximum allowable temperature of outer wall of insulation is 50 0 C. Back to Hoffman Specialty Home Page. piping, there is no need to calculate each section individually. Fuel pipe sizing Natural gas (values are maximum pipe run in ft) kW Pipe size (in inches) 0. Bringing down the humidity levels means reducing the moisture content in the air. This equation can be converted to normal units of measure, as well as using the inside pipe diameter. Mechanical components in vacuum. Pipe Chart Spreadsheet – Average Wall Thickness. GPM will be known as per the flow distribution and respective pipe sizes. 5 3 7–8 55 200 820 10 20 85 370 800 13–14 10 50 245 545 16–17 40 190 425 20 20 130 305 945 22 15 115 260 799 25 10 95 220 739 27 85 203 552 30 60 147 565 35–36 35 95 370 915 40. This can be met using one or more valves. This Excel template calculates water flow rates for different pipe sizes using Hazen Williams equation. Enter your values: Flow Rate: Co-efficient:. Email: [email protected] Written by Matt Milbury on 23 April 2016. The Medical Gas Pipe Sizing Program allows you to size vacuum systems using the procedures outlined in NFPA 99. Override any of the result values to easily recalculate all other parameters at the touch of a single button. how much capacity and vacuum require for suction of sand. Pipe size going to the compressor. The Excel formulas use an. Manage the permission settings for the user groups below. To determine the size of each section of pipe in any system using piping. Notice that we barely miss the 1 ¼” pipe. They calculate the hot and cold water pipe sizes for any plumbing installation. Test strength of pipe (F n): The Structural design calculator test strength of a concrete pipe may be referred to as F c or F n Values are specified in BS 5911:2010. NPSH Available (NPSHA) is the amount of fluid that a system can deliver to the pump. This does not take into account friction forces within the pipe. This is a spreadsheet I used to calculate line size of gas manually. Water Demand Calculations Excel Sheet - XLS Calculator Flexible Pex Pipe a Smart, Cheaper. Here is the report for orifice calculation for you data: Orifice plate calculator CALCULATION REPORT 1. V is then used to calculate Re. The water is at20C, has a. 4511 Brittmoore Rd. The method for establishing the Hydrostatic Design Stress for PE pipe is described in Chapters 3 and 5. 4"Hg for 400 feet of piping. In this lesson you'll learn how to create simple formulas and calculations in Excel. A true Windows application with its own help screens, the System Syzer program isn't restricted to the physical size of the original plastic wheel version. Pipe Cover Check (ft) Downstr. It is based on the use of positive displacement pumps that are sensitive to suction line conditions, so the first couple of screens ask for information regarding the layout of the main tank(s) relative to the location of the pumps. This needs to be a worst case scenario, with even momentary uses being considered Momentary uses of compressed air are considered any usage of your air for a. NFPA 99 Medical Vacuum Sizing. Online calculator to quickly determine Pipe Sizing by Pressure Loss for Air. The pressure drop is pretty much constant with pipe length at some particular flow rate. The Kv-value is a measure of the flow rate through a valve for a given medium and pressure drop. IEC, NEC, BS, etc) and some standards emphasise certain things over others. Now days we have computer programs that can calculate positive displacement blower performance. OR1ONiAL This calculation verifies pipe support. ΔP = Delta pressure, psi. If you change the setting, it will apply to this item. 5 in Hg gauge. Bob von Bernuth - Duration: 49:22. Calculate the design diameter and slope for a section of sewer pipe. You can check it out by moving your boost gauge to some point upstream of the throttle body. Comparison of NPSHa and NPSHr : All calculated values must be in the same units either meter head or feet head. xlsx format. This video demonstrates some software features and shows an example for sizing a valve for vaporizing liquids (wetted vessels) - fire case. Includes 53 different calculations. This is adequate for letting air back into the line. Pipe Sizing Formula and Factors. Each 50HP pump is around 730 cfm with operating vacuum pressure of 28" Hg. Watershed peak flow calculations are also included. xls 04_T310-16 Conductor Size Calculation_Newton. Guide to using pipe sizing spreadsheet by Peter Wenning To be read in conjunction with: Pipe sizing tabulation sheet (Microsoft Excel spreadsheet) Pipe sizing guide figures (pdf file) "Selection and sizing of copper tubes for water piping systems" by Barrie Smith (pdf file) AS/NZS 3500. If the inlet gas contains dust or foreign particles, a suitable inlet filter should be installed at the inlet port. Glycol Mix Calculator Based on Pipe Size, Length of Run, Number of Solar Collectors and the Fluid Capacity of the Collector; Calculate the Percent of Polypropylene Glycol Mix with Distilled Water. Procedure for determining the size of each section of pipe per CPC 1217. Today, we are here with another comprehensive Copper and aluminum wire size calculator As we have discussed in detail the topic of “How to calculate the proper wire size for Electrical Wiring. The first form calculates the pressure or friction loss along a given length of pipeline with a specified inside diameter. A true Windows application with its own help screens, the System Syzer program isn't restricted to the physical size of the original plastic wheel version. Download Link -2. ΔP is the pressure difference across pipe length L, kN/m2. These are just guidelines based on years building smokers but your mileage may vary!. Use Figure 3 for pipe sizing because there is a good chance liquids will be mixed with vacuum. The pipe (conduit) is in lengths and needs to be cut before bending into the required size. Read Duct Diameter (inches) and Duct. Selection of vacuum hoses Calculation of the suction force FS [N] FS = FTH /n FS = suction. Bengtson, PhD, P. 02 x 1000 ft Friction Loss (hf) lb f - sec2 π x (pipe radius)2. The lightweight aluminum pipe is easy to handle and safe to work with on elevated platforms. The larger this value, the higher the flow rate through the valve will be at a given pressure drop. Selection of vacuum hoses Calculation of the suction force FS [N] FS = FTH /n FS = suction. 4511 Brittmoore Rd. For three-phase transformers, use "Volts x Amps x 1. 3, AS 1210 and AS 4041 in a simple script. vacuum tank , vacuum with ventury (air jet ejector) air consumtion available : 250cfm @9bar. The pipe size is 8" and the maximum allowable temperature of outer wall of insulation is 50 0 C. 5 psig or so. Use the solar panel sizing calculator to determine the right amount of paneling you will need to heat your pool year round. Tank measurements are in INCHES. Pump is a most common equipment used in a chemical plant to transfer fluid from one location to another. The 0° angle is to the right in the "X" axis and aligned with the center of the bolt circle in the "Y" axis. The following formula can also be used to determine the weight per foot for any size pipe with any wall thickness: Wt/Ft = ((OD. All Rights Reserved. The Darcy friction factor varies widely with pipe roughness. Pipe size going to the compressor. Inherited means that the permissions from global configuration, parent group and category will be used. Selection Guides (PDF) Selection guide Cold. Friction loss is a function of the size of the pipe and the effluent flow velocity. Written by Matt Milbury on 23 April 2016. Complementary modules of calculations are incorporated in the program, has to know: Pipe table editor made up of 246 pipes with 11 categories of piping. 003 ACPA Vacuum Test Calculator 12. 5 inch size is the minimum standard pipe diameter that will do the job. i require calculation for sand transfer system. Pipe Sizing by Pressure Loss; Pipe Sizing by Velocity; Pressure Loss through Piping; Water Velocity through Piping; Water Flow Rate through Piping; Insulation Thickness; Valves and Orifices. This is a starting point to use in the iterative Thermal Rating calculations. Preview results on one place and copy/paste it in your favorite text editor. Line pressure drop is to be calculated using EnggCyclopedia's pipe pressure drop calculator. For example, if your waterfall is 20 inches wide, you’ll need a flow rate of about 3,000 GPH for a moderate flow (20 * 150. 1, The nominal wall thickness of straight sections of steel pipe shall be equal to or greater than tn determined in accordance. Suction lift is a function of vacuum systems that can be used to advantage in piping (Figure 2). Resulting blow-off capacity determines minimum tank size. Here I give an example. 50 Irrigation Plan i. Email: [email protected] Live tech support! In business since 1948. Foster® coating calculator. By Jeff Shapiro, PE, FSFPE. Sizing Calculator Wireway Selection 4"x4" 6"x6" 8"x8" 4/O Uses Splices and Taps Splices and taps are permitted within a wireway, provided they are accessible. Download the Gas/Vapor and Steam relief Sizin Calculation Spreadsheet using following link. Duct sizing Excel program. Until now calculation was 1,317,836. 2” radius, and you need to create a 35° bend, your calculations would look something like this: to calculate one degree of bend. Water supply calculation xls in Title/Summary Plumber It is possible to design the water supply system in any type of building, allowing you to import information from a drawing file and, additionally, you can generate plans and isometric drawings of the plumbing system. Find where the CFM & PIPE LENGTH intersect on the chart and it will show the recommended pipe size for that length. The formula for pipe weight per foot of pipe is: Wp = 3. xlsx format. It is usually okay if the pipe gets one size bigger. Calculates approximate return pipe size; Allows easy calculation of flash steam loss and associated energy cost through a failed steam trap. Foster® coating calculator. Available Pressure: Force Required: Cylinder Bore Size: #N#If the recommended bore size exceeds 12" or is larger than desireable for your application please view the Multi-Power ® sizing chart. 00 Chart B Length (incl fittings) 419. All you need is the currency your account is denominated in, the currency pair you are trading, your position size, and the exchange rate asked to calculate the pip value. Step 3 Determines the diameter and speed of the conveyor. Please find below some Excel calculation tools for pressure drop in pipes. “Pipe is pipe”. 00 Irrigation Plan Flow Rate 12. The application of vacuum generating equipment has many uses in industry today but unfortunately, vacuum remains a bit of a mystery. Pa = Prevailing absolute pressure. 1 Project creation and management 1. This needs to be a worst case scenario, with even momentary uses being considered Momentary uses of compressed air are considered any usage of your air for a. In red you will find an orifice calculation, feel free to substitute this numbers with your own ones. Please use this calculator to determine the number of solar pool panels needed. As above said, the capacity of septic tank should be designed correctly because insufficient tank size may result in wastewater backup to the house or it coerces us to clean the water often and also it will increase the maintenance cost. This calculator performs the flow rate calculation from the measured pressure difference caused by the flow contraction in the throat of the Venturi tube. From a m3/h pump will generate only 30% more pumping capacity at 5 times the size of a 20 m3/h pump. Max CFM A study needs to be completed to determine what the max demand in the system (in CFM) is going to be. The two sections need not be of the same size pipe. obtained in Step 3. Many manufacturers market "high collapse" casing, which they claim has collapse performance properties that exceed the ratings calculated with the formulae in API Bull. Take that pipe size to TABLE 2 and use the table to find all the EQUIVELENT LENGTHS OF PIPE needed for each PIPE FITTING. 93 (for exhaust sizing at 2 psi) d = Valve diameter, inches. Foster® coating calculator. 58 psi pressure drop, but it seems to correspond to an ID of about 1. Assumes proper discharge pipe size of a velocity of 10 ft/sec or less. Pipe surface calculator. 5% which provides a large factor of safety against instability and strain (Plastic Pipe Institute, Chapter 6, 2015). xls 830 Pipe sizing program for hot water supply or overheated water, water canalization, piping in cold water or hot water of sanitary use. 71 inches wc. Download Link -1. Conduit type EMT SDR 9 SDR 11 SDR 13. This is the proper and scientific method for calculating AC size taught to HVAC technicians and recommended for use by professionals in the trade. Cl 160 PVC pipe is not commonly available in 1/2" size, therefore the calculator assumes that Cl 315 pipe will be substituted. Until now calculation was 1,317,836. Your use of this website is. The equations allow engineers to size relieve devices that can be used for different. to calculate CLR of 35° bend. A Vacuum pipe is a pipe which its inside space is entirely devoid of matter. This calculator makes the calculation using the equation below: B31. We use them everyday in our consulting practice. Scalable and flexible commercial solutions for office buildings, banks, grocery stores and more. During simultaneous discharges, flows from taps should not be less than the minimum flow rates shown in table 5. D = { [4 5/3 *n * Q] / [π * S 1/2] } 3/8. Pipe Sizing by Pressure Loss; Pipe Sizing by Velocity. 1 excel FIRST PAGE OF EACH CALCULATION FILES ARE AS BELOW:. Calculate BTU/hr. Our products appear worldwide in a range of medical applications, including hospital care, sub-acute treatment, long-term care, home healthcare, and medical. Pipe Vacuum Pressure Load Equations Formulas Design Calculator Fluid Mechanics Hydraulics. The data suggests that there are great variations in the basic principles when are applied in finding out the exact risks. All the results above are got from this spreadsheet. is a leading manufacturer of medical gas construction equipment, respiratory therapy equipment, home healthcare products, and emergency medical supplies. For big pipe or doing an approximate pressure drop estimate, you can use nominal pipe size NPS in place of the pipe inside diameter. Pipe Cover Check (ft) Downstr. how much capacity and vacuum require for suction of sand. that gives a smaller calculated required pipe diameter. From Table 10. Our solar pumps are highly efficient and are the most economical and reliable solution for all off-grid irrigation and water supply demands. The 0° angle is to the right in the "X" axis and aligned with the center of the bolt circle in the "Y" axis. The larger the diameter, the less footage per load of bedding. These Excel® Workbooks are intended as full function control valve sizing applications. This applies to HWS and CWS systems in both Netsys and System Builder. This pipe thickness calculator calculates required pipe thickness for a process pipe based on ASME B31. Doğalgaz Boru kalınlık Hesaplamaları Natural Gas-Pipe Thickness. For an installed system air leakage load can be estimated by "Drop Test / Pressure rise test" method. 5 RADIUS WELDED STEEL PIPE ELBOW BASED ON SMACNA) Delta P = (C x Vp) Vp = (V/4005)^2 Delta P = PSI pounds per square inch "C" = SMACNA Friction loss coefficient for 1. The length of the pipe will have a deep influence on the amount of gas that can flow through it. Pentair PRV 2 SIZE Pressure Relief Valve and Vent Sizing & Selection software is the latest innovation in pressure relief sizing software to meet demands for a simple and integrated approach for sizing all types of pressure relief devices, including low-pressure tank protection products as well as regulators, in a single sizing. The sizing procedure is an iterative calculation. The below section of this page provides you the online vacuum pipe thickness calculator which helps you. Section 9 - Technical Reference The goal of piping design is to reduce capital and installation costs, by using the smallest reasonable piping size for the application. The molten pipe then proceeds through a sizing or calibration device (which fixes its dimensions) to a cooling trough. Please fill all required fields. Loading units and flow rate calculation methods specified by BS EN 806-3 differ to that of the preceding BS 6700. 5 radius elbow (dimensionless) Vp = Air velocity pressure (in w. 1 INTRODUCTION OF THE FSW TECHNIQUEIn today’s modern world there are many different welding techniques to join metals. Many manufacturers market "high collapse" casing, which they claim has collapse performance properties that exceed the ratings calculated with the formulae in API Bull. The most common engineering design flow loss calculation selects a pipe size for the desired total flow rate and available or allowable pressure drop. Upper Weld Leg Size(Weld 41): 0. 02 x 1000 ft Friction Loss (hf) lb f - sec2 π x (pipe radius)2. Orifice plate calculator. vacuum tank , vacuum with ventury (air jet ejector) air consumtion available : 250cfm @9bar. 344” Offset Bend Calculation. To calculate the flowrate of a fluid passing through a venturi, enter the parameters below. In the equation, f D is the Darcy friction factor, L is the pipe length in feet, I. bedsheets for double bed king size bedsheets single bed bedsheets for double bed double bedsheets with 2 pillow covers cotton bedsheets for double bed bedsheets under 300 rs double bedsheet bedsheet family cotton bedsheet bedsheet bedsheet bedsheetbedsheet bedsheet bedsheet double bed bedsheet bedsheet double bed full size bedsheet. Calculation include pressure losses in pipe and fittings, natural gas pipe sizing, two phase flow, pump sizing and compressor rating. Enter average temperature of the air surounding the pipe. Back-checking to Myerson's quoted source (Ryan, J. 54, with units as given above, to calculate the water flow rates for PVC pipe with diameters from 1/2 inch to 6 inches and length from 5 ft to 100 ft, all for a pressure difference of 20 psi across the particular length of pipe. Can you help me translate, program, or host these calculators? [Hide this request] Check out our spreadsheet version of this calculator: Download Spreadsheet Open Google Sheets version View All Spreadsheets. 87 Elevation difference-7. Use Table 12-1 for gas input values of typical appliances. The following is a list of volume calculators for several common shapes. ATLANTA (Dec. Enter relative humidity of the ambient air. Vacuum Calculation - Leybold. CALCULATION WORKSHEET: PIPE SIZING, BRANCH LENGTH METHOD Step 1: • Draw a sketch of a piping system in the space to the right. You do not state the pipe size for which you calculated the 1. Repad to Vessel Weld Leg Size(Weld 42): 0. Leave it in each branch calc. A pipe extrusion line consists of a number of pieces of equipment. They calculate the hot and cold water pipe sizes for any plumbing installation. It consists of taking information about your home's construction materials, insulation levels, number of windows, sizes of rooms, etc, and making a calculation based on those factors to determine the. Is the default density value of should be done? You did not write this way consistently. Head Loss Calculator. Spreadsheet for typical fluid flow calculations like single phase fluid flow in a pipe, fitting losses in a pipe and pump sizing calculation. It uses inert gas, usually nitrogen, to do that. This should be sizing at 1/2" like the hot water is. Piping Design Spreadsheet-Download Free Piping Design Info XLS is an excel file which almost contains all sizes of various fittings and structure sizes. The header pipe in the AP series evacuated tube solar collectors is designed for reliability. LDS Vacuum Products is a 100% woman owned company and certified Woman Owned Small Business (WOSB). The size of each section of gas piping shall be determined using the total length of piping from the meter to the most remote outlet and the load of that section (see calculation example in "Figure A" use steps 1- 6 below: Sizing of Piping Sections. Generator Information. To make the flow gentler, adjust this figure to 100 GPH; to make it more powerful, adjust to 200 GPH per inch. Sizing Vacuum Pumps Pumping speed, or capacity, is measured in terms of gas volume drawn in a length of time. No applicable minimum tank size. , so if you are already working with 3/4 in. Cl 200 PVC pipe is not commonly available in 1/2" size, therefore the calculator assumes that Cl 315 pipe will be substituted. To become a registered user, enter your email, then submit and fill out the rest of the form. Media Contact: Allen Haynes 404. OpenFlows FlowMaster is an efficient calculator product for the design and analysis of a wide variety of hydraulic elements, such as pressure pipes, open channels, weirs, orifices, and inlets. Calculation tools. Pipe Cover (ft) Pipe Thickness (inches) = Upstr. The Medical Gas Pipe Sizing Program allows you to size vacuum systems using the procedures outlined in NFPA 99. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on. System Syzer) can be used to size the return line. Parmar Buy All (52 No's) of Unlock Electrical Software at 30% Discount (US $) Buy All (52 No's) of Unlock Electrical Software at 40% Discount (Indian Rs) (1) Cable size and Voltage Drop Calculation FREE DOWNLOAD BUY UNLOCK VERSION($) BUY UNLOCK VERSION(Rs) Calculate Voltage drop of Cable. A pipe extrusion line consists of a number of pieces of equipment. This pipe thickness calculator calculates required pipe thickness for a process pipe based on ASME B31. Pipe Chart Spreadsheet – Average Wall Thickness. Pipe Velocity and Diameter: Calculate the velocity of water in a pipe and calculate the diameter of a pipe required for 5 fps pipe velocity. 51 x Flow Rate) / (Diam hole2 - Diam Pipe2). Our wattage calculator helps you determine your electrical power needs for recreation, construction, home backup, and emergency use. 2 AIR VALVES: AIR-RELEASE, AIR/VACUUM AND COMBINATION AWWA Manual M51 The velocity of the flow of liquid past an enlarging pocket of air and wastewater gases may only be sufficient to carry part of the pocket of air and wastewater gases down - stream unless the liquid velocity is greater than the critical velocity for transporting. The chart below shows a pressure drop of 0. Pipe size going to the compressor. The formula for pipe weight per foot of pipe is: Wp = 3. The line sizing charts on each case specification sheet can be used to size the subfeed branch lines. Equations displayed for easy reference. COURSE CONTENT 1. is a leading manufacturer of medical gas construction equipment, respiratory therapy equipment, home healthcare products, and emergency medical supplies. Total Dynamic Head in an industrial pumping system is the total amount of pressure when water is flowing in a system. Calculate the amount of solar panels you will need to heat your pool. Pipes are manufactured with high frequency source (ERW) from St37, St44 and St52 steel as. Calculate this by using the pipe resistance calculator below. equal to or greater than the Desired S. Choose the distance between the air compressor and the furthest dropper or outlet point in the blue column. Theoretical holding force. Losses are calculated on the basis of flow rates in circular pipes, the internal diameter of the pipe, the length of the pipe, and the type of pipe. LDS Vacuum Products is a 100% woman owned company and certified Woman Owned Small Business (WOSB). I am thinking I need 1 1/4 inch pipe coming in, but man that is a serious pipe. calculations, so as to appropriately select a pump. Chapter 3: Review of Basic Vacuum Calculations Before we go any further, some time should be spent on some of the vocabulary specific to vacuum technology. 5 inches ) gives a calculated pipe diameter requirement of 1. 33 x ?T°F; Calculate tons of cooling capacity Tons = BTU/hr. 5 in Hg gauge. Q is the water flow rate in the pipe, m3/hr, D is the pipe diameter, mm. This is adequate for letting air back into the line. When the line serves one case. Input data are design flow, elevations of ground initial and final. Bringing down the humidity levels means reducing the moisture content in the air. Typical compressor output is 3. The flow rate through a fixed orifice can be calculated from the meter dimensions of pipe diameter and orifice size and shape. Vacuum in torr, mm Mercury, psi and kPa. When Factor A falls left hand side of the curve Calculate maximum allowable external working pressure (Pa) by below formulae. Please find below some Excel calculation tools for pressure drop in pipes. The table below was prepared using the equation: Q = 0. With these preliminary calculations of pipeline sizing and pipe routing, pressure drop between start and end point, incorporating all fittings, is calculated. There are 2 key aspects to sizing your piping correctly: max system CFM requirements and minimum required operating pressure. Septic Tank Size Calculation based Per User Consumption. So for the example lets change section 7 from 3/4″ to 1″. Force momentum principles applied to pipe flow. Guide to using pipe sizing spreadsheet - The Institute of. ΔP is the pressure difference across pipe length L, kN/m2. Solving for internal vacuum pressure. zip [320 KB] HydroTherm. Reproduction, redistribution or modification of the information is prohibited without the express written permission of Pneumatics Online. Head, NPSH, estimated shut-off pressure, estimated power consumption and the optimum line size. To calculate the flowrate of a fluid passing through a venturi, enter the parameters below. The Excel spreadsheet includes all configurations with a graph/flat pattern that looks like a bell curve. However if you need a more accurate calculation, you need to find out the pipe inside diameter and use in the calculator. Calculate the amount of solar panels you will need to heat your pool. xls , has been developed that will perform flow system calculations and pump selection analysis. If you conduct line sizing calculation, and the result show that NOT GOOD due to pressure drop. IEC, NEC, BS, etc) and some standards emphasise certain things over others. (XLS File 21 KB) Winery Chiller Systems, A Do It Yourself Guide- An article covering basic tips for Winery Chiller Systems- for those that do not have a strong understanding of refrigeration. Gauges have a taperlock handle for quickly replacing worn gauges. Diameter Inch Calculation in SpoolFab More articles like this Pipe Size - Nominal Size or Actual OD The pipe size parameter, PS, is either (a) or (b) below, depending on the setting in the Master Files under minimum weld sizes. When Factor A falls left hand side of the curve Calculate maximum allowable external working pressure (Pa) by below formulae. The Kv-value is a measure of the flow rate through a valve for a given medium and pressure drop. Due to the contraction in the diameter from the inlet to the throat of the Venturi tube, the flow velocity is changing while flow rate remains constant. Imagine, for instance, pumping a liquid from one level up 80 ft to a vessel operating under vacuum. Usually, the Kv-value is given in the product description or datasheet. Is the basic Engineering software, which all beginners in field of Engineering and science need to get acquitted to. This document provides a guideline for sizing round manhole structures for various sizes and angles of incoming pipe. Piping dimensions can be found on our piping datasheets. Fluids Systems Design and Engineering. is pleased to introduce the new easy to use SCFM to ACFM Calculator that allows you to quickly convert your SCFM (Standard Cubic Feet per Minute) value to an ACFM (Actual Cubic Feet per Minute) value. Download free Excel spreadsheets for engineering calculations. Used on pipelines, the following conditions would prevail:. pipe runs 1-2, 2-4 and 22mm tube for pipe run 4-6, the reworked progressive pressure drops are 0. Two types of licenses are available for this spreadsheet. Generally speaking, we are required to calculate the required time from initial pressure to required pressure. 344” Offset Bend Calculation. Download HVAC Books. This version is usable for browsers without Javascript also. 22 feet/sec. Another way to calculate the suction side resistance, in the absence of a vacuum gauge, is to add up all the bits of pipe and valves before the pump. If a standard unit is being used, pick the size unit that has a Tabulated S. A preliminary design is set, and then refined by checking against the performance correlations until an adequate design is achieved. Pipe Size Friction loss calculator Commodore Australia is here to provide green solutions to farmers wanting to install solar pumps for their water needs. where Wp is the pipe weight in pounds per foot of pipe. Use the solar panel sizing calculator to determine the right amount of paneling you will need to heat your pool year round. how to size and where to place the various infrastructures of a gravity fed system. Example: Size a header for 500 SCFM at 100 PSI at an elevation at sea level. Inherited means that the permissions from global configuration, parent group and category will be used. Stress Concentration Factor on Circular Shaft Under Bending Stress in ellipsoidal head of pressure vessel Velocity Pressure calcs Basic Pressure Vessel Calculation Storage Tank Design Calculations Design of Pumping System 4-bar Animation Newton-Raphson Method Overlap Distance for Equal Failure Plate Stress to Fillet Weld Stress Design of Precast Concrete Panel Shaft Deflections. AioFlo (pronounced aye-oh-flow) is a Windows application for pipe sizing (diameter calculation), flow rate and pressure drop calculations for liquids and gases in single phase flow. It is dependent upon the size, condition and type of pipe, number and type of pipe fittings, flow rate, and nature of the liquid. Central Vacuum Sizing Guidelines. For components such as bends, diverter valves, and flexible hoses, use their equivalent length expressed in pipe diameters of the conveying pipe. Bengtson, PhD, P. Guide to using pipe sizing spreadsheet - The Institute of. Pulsating lines: Spans indicated above shall not be used. Just input the diameter and wall. The spread sheet contains all formulas needed for calculation of pipe sizing. Mw k Min Flow in CFH Max Flow in CFH For Mach Calculation. /inch^2 (pound per square inch), multiply the answer for "P" by. In fact, a simple way to think about Excel is to consider each cell in a worksheet like an individual calculator. Here is a hydrocyclone sizing calculator with immediate access to all design equations needed for your hydrocyclone design calculation in an online XLS spreadsheet format. 1 INTRODUCTION OF THE FSW TECHNIQUEIn today’s modern world there are many different welding techniques to join metals. Valve sizing calculator. The size of each section of gas piping shall be determined using the total length of piping from the meter to the most remote outlet and the load of that section (see calculation example in "Figure A" use steps 1- 6 below: Sizing of Piping Sections To determine the size of each section of pipe in any system using piping specific. GPM will be known as per the flow distribution and respective pipe sizes. 1 excel FIRST PAGE OF EACH CALCULATION FILES ARE AS BELOW:. orifice size and flow calculations. Comparison of NPSHa and NPSHr : All calculated values must be in the same units either meter head or feet head. This applies to HWS and CWS systems in both Netsys and System Builder. xls 07_Touch Potential 2-Wire Circuit. Selection of vacuum hoses Calculation of the suction force FS [N] FS = FTH /n FS = suction. Read Round Duct Diameter (inches) and Friction Loss Per 100' of duct (inches of water). The sg of the steels we use is approximately 64. The initial pressure is the design. Pipe diameter Size changes Valve passage size Direction changes Fluid density Fig. 87 Elevation difference-7. com Fluid Pressure Loss Calculations Factor D Pressure Loss = Equivalent Length of standard pipe in feet Pipe Tee Size Gate Globe Close Thru Inches. Bentley Hevacomp V8i v26 now includes the option to implement the BS EN 806-3:2006 standards for pipe sizing. Longest Length Method: The size of each section of gas piping shall be determined using the total length of piping from the meter to the most remote outlet and the load of that section (see calculation example in “Figure A” use steps 1 – 5. Preview results on one place and copy/paste it in your favorite text editor. For big pipe or doing an approximate pressure drop estimate, you can use nominal pipe size NPS in place of the pipe inside diameter. They import the ASK price from the MT4 platform and calculate the correct lot size to risk whatever percentage you choose. Use Table 12-8. From a simplistic standpoint, the best pipe size is obviously the smallest size that will accommodate the application at hand. Below you will find the most current EOF (electronic order form) documents and helpful excel documents. Pipe Pressure Rating Slope of Pipeline Below Vent Velocity of Shock Wave - a Critical Closing Time - Tcr. Example Calculation of Water Flow Rates for Pipe Sizes and Lengths. First Part is 2. Take the calculated CFM and compare to the compressor output. Vacuum Pump Sizing - Selection Guide. Pipe dimensional data as per ANSI/ ASME and JIS is available. So, you could use the tables to calculate the pressure drop for each section of pipe (at the sum of the cf/h of all the appliances downstream from the pipe). Black pipe is used in the installation of household gas lines. Foster® coating calculator. These Excel® Workbooks are intended as full function control valve sizing applications. Step 4 Calculate the amount of motive flow used by multiplying the Qm and Qs found in the tables by the Tabulated S. During this assignment, the German banks data were compared to that of France and Italy banks. 002 Calculate pipe velocity Velocity ft/sec Using a. N = 4 for vacuum up to 28 in Hg gauge. Read Duct Diameter (inches) and Duct. Septic Tank Size Calculation based Per User Consumption. AioFlo (pronounced aye-oh-flow) is a Windows application for pipe sizing (diameter calculation), flow rate and pressure drop calculations for liquids and gases in single phase flow. Register now or log in to join your professional community. So our calculated external pressure design thickness is 6" sch 40=0. Pneumatic conveying systems are widely used in manufacturing plants and process industries. Bringing down the humidity levels means reducing the moisture content in the air. About Pressure Loss through Fittings Revit uses the Excess Head (K) method to compute the head loss through a fitting. 3 microns for the start of the full molecular flow regime in a 6. Net Positive Suction Head Calculator. Please fill the corresponding fields and click the "Calculate" button. (100 mm) diameter valve. #N#Design Pressure, P. Sample Problem Statement. Calculate. It differs from hydraulic or slurry conveying in that the gas expands continuously along the pipe length. Easily compute water fixture units (WSFU) with this new calculator. The third component of friction loss covers losses in other components of the pressure system, such as a splitter valve or other valves. Schedule Numbers for pipe size/wall thickness combinations are approximated to get a uniform relationship equal to 1000 times the P/S (P=Design Pressure and S=Allowable Stress) expression contained in the modified Barlow formula for pipe wall thickness. The sizing procedure is an iterative calculation. Valve Sizing Calculator Manual This Section provides the User a practical guideline for the Valve Sizing Calculator use, showing the main features of the software and describing step-by-step how to size a Control Ball Valve. Calculation exercises are given at the end of the module (paragraph III. From here you can design pipe and w-shape supports and print sign summary sheets for your plans. HDPEapp is an online tool developed for and released by the Plastics Pipe Institute (PPI). The corresponding parameter is: a-12. Differential Pressure. Piping conductivities. Read Duct Diameter (inches) and Duct. This excel sheet calculates the dehumidifier capacity for reducing the humidity in a warehouse, cold room, warehouse, industries etc. The Hazen Williams Coefficient - C - to Calculate Water Flow Rate for Pipe Sizes. Three-quarter-inch and half-inch diameter gas pipes are usually installed, and the ends of each section of pipe come pre-threaded. 616 m/s as determined by Table 2 in the Barrie Smith book. The third component of friction loss covers losses in other components of the pressure system, such as a splitter valve or other valves. Notice that we barely miss the 1 ¼” pipe. Pipe Chart Spreadsheet – Average Wall Thickness. The reactance for multi-core core cables is selected from the circular conductors column in from Table 30 in. NOW AVAILABLE! ORDER YOURS NOW! 2015 Drain Waste Vent Pipe Sizing Calculator DWV is based on Table 7. If you have an average sized house, purchasing a central vacuum system will be fairly easy. Theoretical holding force. At its heart, Excel is a giant calculator. IPS– refers to plastic pipe that has the same outside diameter as iron pipe of the same nominal size. Valve sizing calculator. Guide to using pipe sizing spreadsheet by Peter Wenning To be read in conjunction with: Pipe sizing tabulation sheet (Microsoft Excel spreadsheet) Pipe sizing guide figures (pdf file) "Selection and sizing of copper tubes for water piping systems" by Barrie Smith (pdf file) AS/NZS 3500. 28, and they apply to all conductors 4 AWG and larger (Fig.