The flange loads are extremely light for this flange that was designed around the gasket seating case. Loads on neither nozzle will have any real influence on pump performance. Bulletin provides a. Two options are therefore available: performing calculations to verify whether the. Nozzle loads are the net forces and moments exerted on equipment nozzles from the weight and thermal expansion of connected piping and equipment. Heat load calculations. 107: Local Stresses in Cylindrical Shells Due to External Loadings on a Radial Flush Nozzle: Pressure stresses per BS5500 G. Container Loading Calculator is smart, easy to use load planning application. File decompression software, such as Winzip® or StuffIt®, is required to open the. The nozzle loads given in above table an Excel spreadsheet calculation comparison has been done to see the effect of various insulation. Tom Wolf (Nozzle_Guy) All Posts Email Author. Use that to determine the nozzle reactive force (See figure 1). xls 09_Transmission Line Calculator. Nozzle stiffness is the important parameter in evaluation of various components of nozzle loads. Optimization of Piping System for Nozzle Loads. 1 4 3 2 2of13 8 foundation loading data 9 venting calculations 16 10 nozzle flexibility analysis as per appendix p 19 11 shell to roof rafter joint stress analysis 20. square short column subjected to axial services compressive load of. The gasket gets seated once, this is the load that the flange sees with each application and removal of pressure. To find the correct nozzle size you need to know the flow of your system and the pressure you wish to achieve. Applicability Bulletin WRC 107 contains directions to calculate local stresses in cylindrical and spherical shells due to external actions. 4 "ASCE710W" (version 2. nozzle loads. The NEC covers commercial calculations in Art. 5 kN per running meter. #N#Log Beam Calculator. Every Pump Operator’s Basic Equation (gpm) flow of the selected nozzle. This load shall be permitted to be included with the general lighting load and subject to the demand factors provided in Table 220. Use the bore diameter of the nozzle and the flow in gallons per minute to calculate the nozzle pressure. Reboilers Storage Tanks Air-coolers. Design Calculations 2015-02-19 Revision : C:\\data\TutorialModel1. The minimum allowable nozzle loads for Steam Turbine is generally taken as 1. The result was a primitive combination of hand and spreadsheet based calculations, which gave a solution to equation 9 of Porta's paper and provided chimney throat and nozzle sizes for the Lempor exhaust design on my (Richard Stuart's) Garratt project. Latent Heat Gain - is the energy added to the space when moisture is added to the space by means of vapor emitted by the occupants, generated by a process or through air infiltration from outside or adjacent areas. Here we use a converging diverging nozzle to connect two air cylinders. Nozzle Loads 1. Nozzle Loads WRC 107 ver 1. Pressure Vessel Engineering Ltd. The first Excel template is for calculating the flow rate, based on a. xls 08_Touch Potential 3-Wire Circuit. The complete calculation for nozzle areas of compensation per ASME is: [link Point to another website Only the registered members can access] For complete pressure vessel design calculation:. P&P Electrical Load Calculation Form Updated: 02/02/2017 (jhall) BUILDING & SAFETY DIVISION │ PLANS AND PERMITS DIVISION DEVELOPMENT SERVICES CENTER. Nozzle inlet TO 3rd stage and nozzle outlet FROM 3rd stage (combine) Should all 3 inlet nozzles and 3 outlet nozzle be checked together in 1 calculation in term of NEMA check and combine all of them. 14bGy = lbs. This nozzle design (Fig. The following sections in this article present three Excel templates for such calculations. Use your free session. They will also calculate the number of tubes needed for a shell and tube heat exchanger and to calculate the pipe length needed for a double pipe heat exchanger. To calculate the load, is very important the total weigth because it. Here we use a converging diverging nozzle to connect two air cylinders. hesap results differ greatly depending on usage and environmental conditions, the pool is the necessary heat accounts for depicts heating also. Pipe Hanger Generation. Single Family Dwelling Load Calculation - Step by Step Example (Optional Method) CEC 220. Author: Wayne Dalton Last modified by: Corona IS Created Date: 3/24/2004 3:43:03 PM Company: Wayne Dalton Other titles: Garage Door Pressures Sheet2 Sheet3 enclosure exposure importance slope. Steam Turbines-NEMA SM 23. NextGen can calculate stresses in shell and - in some cases - stresses in nozzle at the junction with shell according to WRC bulletins (Welding Research Council) 107, 537 e 297. Download Automatic Irrigation Calculation Sheet. xls 09_Transmission Line Calculator. 4) is a spreadsheet program written in MS-Excel for the purpose of wind loading analysis for buildings and structures per the ASCE. I never understand what the theories behind the limits are. Simple Beam Deflection Calculator Excel February 13, 2019 - by Arfan - Leave a Comment Simple beam two unequal point lo unequally ed beam formulas for multiple point lo structural double point load beam deflection structural ering exle on deflection calculation for cantilever beam overhanging beam point load on end. The General Electrical Load Requirements are based on the inside square feet area of the home which is then used to calculate the basic lighting load and required appliance circuits. Nozzle inlet TO 1st stage and nozzle outlet FROM 1st stage (combine) 2. To calculate the load, is very important the total weigth because it. The spreadsheet includes an amortization and payment schedule suitable for car loans, business loans, and mortgage loans. The hot exhaust is passed through a nozzle which. This chart will assist you with the selection of the proper nozzle size. Reboilers Storage Tanks Air-coolers. Proof of nozzle loads is time -consuming and expensive • Global determination of nozzle loads without taking into account the material properties of GRP and the cause of load is not sensible and uneconomical • Load tracking to the supports and inclusion of the nozzle loads in the global tank stress resultant makes no sense. In this article, some of many other important loads are also explained. The objective is to establish allowable nozzle load tables for the piping designer and the vessel designer. COMPRESS also includes consideration of the effect of piping loads on nozzle flanges. Pressure Vessel Engineering Ltd. For the Payment column, enter the first three payment numbers (e. The objective of this paper is to explain the effect/influence of stiffness generated from three different methods (Anchor, WRC and Finite element method) on nozzle load evaluation and shell/nozzle junction stresses. 2012 Size: 48. AC load at 100%. TRIHANGER Brochure * Designs the pipe supports the user wants with a minimum of effort. Importance of WRC 107 and WRC 297 in Piping Stress Analysis Whenever Pressure Vessel or Heat exchanger (Static Equipment) nozzle loads exceed the allowable WRC 107 and WRC 297 provide important methods for calculation of local stresses in the vicinity of an attachment to a vessel or Pipe (shell and nozzle junction). Rating: 3 Details. What code should I select WRC-107, WRC297, WRC-537? Solution: Due to liability lawsuits Bentley can not provide design details such as this. MotorSim is essentially a re-write of of Nakka's SRM. A small water-cooled liquid-fuel rocket engine is to be designed for a chamber pressure of 300 psi and a thrust of 20 lbs. Active Equipment Nozzle Loads Active mechanical equipment consist of equipment with moving parts, such as pumps, compressors, and fans. Enter the interest rate, loan amount, and loan period, and see what your monthly principal and interest payments will be. 123 Anytown Ontario, Canada H0H 0H0 Charles Liu P. I never understand what the theories behind the limits are. Download free Excel spreadsheets for engineering calculations. flow rate measurement calculator. Excel formulas use the ideal gas law to calculate the density of a gas for known gas molecular weight, temperature and pressure. In this paper, design calculation of nozzle junction based on ASME pressure vessel design code is carried out for nozzle to head junction subjected to applied external load, internal pressure and. Nozzle Movement Calculation. Residential Heating and Cooling Load Calculation 2001 ASHRAE Fundamentals Handbook Excel Sheet HVAC Heat Recovery Air Handling Units Calculation Excel Sheet HVAC Electrical Spreadsheet version for the ACCA Manual D, (3rd Edition). The counterweight can be determined by calculating the nozzle pressure and then the nozzle reactive force. 005 Mc/Mrcm = 0. The minimum allowable nozzle loads for Steam Turbine is generally taken as 1. Passing a storage tank nozzle loads has been a nightmare for the most stress engineers. In this short article, we explain the formulae for calculating axle weights, and take you through a simple example. This Excel spreadsheet calculates the flowrate from the pressure drop across a gas orifice meter with the equations defined in ISO 5167. The available format is Microsoft Excel™. Design of Piping Loads On Rotating Machinery Nozzles May 2014 Process Industry Practices Page 5 of 11 4. 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. If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. Passing a storage tank nozzle loads has been a nightmare for the most stress engineers. 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. xls 08_Touch Potential 3-Wire Circuit. Reboilers Storage Tanks Air-coolers. Vacuum: from a practical sense, vacuum may be defined as the condition of a gas under less than atmospheric pressure. Create two load case sets:. Air Curtains and Air Screens - Air curtains or air screens in open doorways are used to keep acceptable indoor comfort in buildings ; Beaufort Wind Scale - The Beaufort description and observation of wind and. Right click on the following image to save a copy of our Excel loan calculator spreadsheet, or click on it to directly open it. Download Edit in Browser Share. zip files contain additional files which require software as well. Use our XLC add-in for Excel to display cell formulas as easily readable mathematical equations. docx or Excel. , 2/1/2005, 3/1/2005 and 4/1/2005). 4 "ASCE710W" (version 2. The nozzle is assumed to be penetrated to a cylindrical or spherical shell. 77 MB Type of compression: zip Total downloads: 5289 By: curtdwelar File checked: Kaspersky Download speed: 7 Mb/s time: 4. How to Calculate a Percentage of a Number. Use the Payment Calculator worksheet (the featured image above) to create an amortization table based on the auto loan amount, annual interest rate, term of the. Alan Williams: "Structuiral Engineering Reference Manual", Professional Publications, Inc, 2001. 14 kW range. pressure, after which the permissible external loads for the nozzle- vessel intersection as well as for the nozzle-piping connection (flange) can be calculated. Codes covered. The result was a primitive combination of hand and spreadsheet based calculations, which gave a solution to equation 9 of Porta's paper and provided chimney throat and nozzle sizes for the Lempor exhaust design on my (Richard Stuart's) Garratt project. 117 Required Shell Thickness From Calculations tn:= 25 Nozzle Wall Thickness, Corroded trn:= 4. The ISO 5167 orifice coefficient calculation spreadsheet template shown in the screenshot at the right will calculate the orifice discharge coefficient based on the indicated input. Nozzle loads Nozzle Loads At Top Of the Nozzle Neck Fx, N 14398 Fy, N 0 Fz, N 0 Mx, N-mm 0 My, N-mm 7490845 Mz, N-mm 0 V. 3 kW water heater. More templates like this. Use Faster Formulas Techniques. 2 ASME Sect VIII b = Bolt area req'd for seating Am2 = Wm2/Sb = Initial bolt load for seating gasket Wm2 = 3. External Nozzle Loads Design Using WRC-107/537 Nozzle Shell Junction FEA Analysis USING 7:06. Loans have four primary components: the amount, the interest rate, the number of periodic payments (the loan term) and a payment. 3 Conditions Requiring Calculation. A utomatic irrigation sprinklers calculations. Download free Excel spreadsheets for engineering calculations. In this way the load limits and load capacity of the nozzle can be determined and. 29 amps X 240 volts = 6,960 VA. Very similar to the workbook previously posted for ASCE 7-05, also available on this site. COMPRESS also includes consideration of the effect of piping loads on nozzle flanges. Tab "propellants" contains basic information about fuel mix that is used for calculation of nozzle characteristics (Best source for this is ProPEP3) / it can be put either by "propellant manager" or directly via the tab. 14 kW range. 002 Total Load = 0. 3-Allowable nozzle loads calculation. Heat Load Calculator Spreadsheet Calculator Spreadsheet , Spreadsheet August 07, 2019 17:37 With the following thermal load calculation you can know the refrigerators you need for any site in an exact way. #N#Simple Beam, Point Load at Midspan. Pressure vessel shell thickness calculation as per ug 27 - Duration: 3:37. 3 kW water heater. Download More Engineering Books. Nozzle Calculator. Nozzle Flexibilities and Limiting Loads per Appendix P - Nozzles attached to the tank shell can be evaluated for limiting loads and flexibilities. The pipe nozzle load limits are developed by the equipment manufacturer and are intended to prevent malfunction, such as shaft misalignment, or distortion of the casing that could impede the movement of impellers. Nozzle Loads Wrc 107 Ver 1 Xls Spreadsheet 5 8k Views Commercial Electrical Load Calculation 1557897. External Nozzle Loads Design Using WRC-107/537 Nozzle Shell Junction FEA Analysis USING 7:06. Total results: 18 has-more! Electrical Engineering is a field of engineering that studies the use of electricity, electronic and electromagnetism. Nozzle inlet TO 3rd stage and nozzle outlet FROM 3rd stage (combine) Should all 3 inlet nozzles and 3 outlet nozzle be checked together in 1 calculation in term of NEMA check and combine all of them. Planning out things and fast access to data and other information are made very easy when using spreadsheet templates. Very similar to the workbook previously posted for ASCE 7-05, also available on this site. 5 x s x e force acting on the nozzle fn p x rxn x lh force acting on the shell fs p x rxs (lr + tn) discontinuity force from internal pressure. Kozubkova, " Investigation of viscous fluid flow in an eccentrically deposited annulus using CFD methods ", in Experimental Fluid. Active Equipment Nozzle Loads Active mechanical equipment consist of equipment with moving parts, such as pumps, compressors, and fans. Design Loads • Materials • Allowable Stress 9. Bulletin 297-Aug. Click to open and edit a Microsoft Office Excel workbook with standard nozzle loads that can be imported into the software. The nozzle loads given in above table an Excel spreadsheet calculation comparison has been done to see the effect of various insulation. The loads on building, may be a residential or any type of structure, are mainly classified into vertical and horizontal loads. Various methods have been in use for the determination of stresses at the nozzle-shell junction due to external loads and moments. NOTE A: The security level in Excel must be set to no higher than "Medium" in order to execute code with embedded VBA. Combined Loads: F/Fmax = 40000 / 47555 Mc/Mrcm = 662 / 140302 Ml/Mrlm = 662 / 279698 F/Fmax = 0. WERCO*107 /*297™ Calculates local stresses in vessel shells at nozzle and lug connections due to externally applied loads in accordance with the Welding Research Council Bulletin 107/297. In real nozzles, the length to throat area ratio is important for keeping the flow attached. Voltage drop is a loss of voltage that occurs when electricity travels over. Welds in Shear, Bending, Torsion and Axial Loading Auto Analysis of Weld Groups Design of Fillet Welds Throat Thickness 60o to 90o, a = 0. As the load profile for each pump nozzle is composed of three force and moment components each, it is impossible to specify all conceivable combinations for the theoretical limits of pump nozzle loads. Use that to determine the nozzle reactive force (See figure 1). 1 excel FIRST PAGE OF EACH CALCULATION FILES ARE AS BELOW: Suggestion/Comments Tank Sizing Tank design for Int. Just to mention that all calculation spreadsheets. API 610 requires only that the pump be able to operate satisfactorily when subject to nozzle loads less than those in the table or to nozzle loads that satisfy the inequalities of Annex F. It is generally installed at the point of connection that is leading to the sprinkler system (generally close to the meter or a building). Nozzle Loads. 2, Appedix 2, ASME Sect. Have our partners at Excelchat fix your formulas, 24/7. The Load Calculation Applications Manual, also sponsored by TC 4. type the following formula into any Excel cell:. The rated pressure of the class 300 flange at 200°C is 43. MarketXLS provides many stock option related functions. Please also send me the excel spreadsheet for Nozzle load calculations on my mail ID costinilinca@yahoo. This calls for either a more rigorous analysis or a redesign of the nozzle or piping. Document design calculations for pipe support referenced in calculations title. For the Load Cases: Bottoms Pump - Suction grid at the top of the Load Case Sets tab, click Add Case > Add Custom. Sonic Nozzles are also known as "Critical Flow Venturis" or "Critical Flow Nozzles" For those users with instrumentation, Flow Systems offers software to calculate flow through sonic nozzles. The prescribed files are incomplete calculations per ASME for nozzlel area of compensation and not nozzle load calculation. This nozzle design (Fig. The minimum allowable nozzle loads for Steam Turbine is generally taken as 1. Operating loads only - used for cycle life calculations (seating HG is removed). How to Calculate a Percentage of a Number. As the load profile for each pump nozzle is composed of three force and moment components each, it is impossible to specify all conceivable combinations for the theoretical limits of pump nozzle loads. Downloading worked solutions from our Repository gives you a head start in solving technical problems. Here's how to calculate a car loan in Excel before you make a commitment. Piping loads for machinery nozzles shall be calculated if any of the following conditions exist: a. Bulletin 297-Aug. -Cylindrical Shell Design Spreadsheet Internal & External Pressure as per ASME Sec. The spreadsheets generally print on "one" page and thus the name. Importance of WRC 107 and WRC 297 in Piping Stress Analysis Whenever Pressure Vessel or Heat exchanger (Static Equipment) nozzle loads exceed the allowable WRC 107 and WRC 297 provide important methods for calculation of local stresses in the vicinity of an attachment to a vessel or Pipe (shell and nozzle junction). They are what Structural Engineers use to calculate beams, joists, walls, footings, shearwalls, etc. 53 mm (STD). Use the bore diameter of the nozzle and the flow in gallons per minute to calculate the nozzle pressure. Trucking Cost Per Mile Spreadsheet ( Click Image to Enlarge ) Free download tutorials and templates trucking cost per mile spreadsheet, cost per mile calculator trucking uk, trucking expenses spreadsheet, cost per mile calculator excel, average trucking cost per mile, operating cost per mile formula, operating cost per mile formula, owner operator cost per mile, …. The complete calculation for nozzle areas of compensation per ASME is: [link Point to another website Only the registered members can access] For complete pressure vessel design calculation:. 2(a): (radial load should not include pressure end load). 15,000 VA X. Here we use a converging diverging nozzle to connect two air cylinders. Nozzle Load Table. On selecting a shell component and in the materials tab when clicking on OK, the length becomes 0. In case the same is procured as a package item, Nozzle loads shall be as per Cl. Column: Column is defined as compression member which has an effective length greater than its least lateral dimension. This post specifies the criteria to be adopted while defining the allowable loads acting on the Nozzles of the various Mechanical equipments, due to the loads imposed by the connected piping system. Nozzle stiffness is the important parameter in evaluation of various components of nozzle loads. ASCE705W ASCE 7-05 Written for analysis of air load for code and structures for Spreadsheets program written in MS-Excel. Note: You may now enter the values in either 32nds of an inch or in thousandths of an inch (like Enderle Fuel injectors). 5 x tj tj:= tn Wall thickness of nozzle below shell. Sample Vessel 8 PVE-Sample 8 Pressure Vessel Calculations April 27, 2007 XYZ Vessel Inc. The rated pressure of the class 300 flange at 200°C is 43. Engineering Spreadsheets A spreadsheet is a computer application that simulates a paper worksheet where becoming increasingly popular in solving engineering related problems. Strength Reduction. Use your free session. Learn more about the units used on this page. The combustion produces great amounts of exhaust gas at high temperature and pressure. Nozzle Movement Calculation. First step needed is to enable WRC under File > Item Properties. Heat load at 65%. P, which is not that cumbersome, and much simpler than WRC 297, on which it is based. This calls for either a more rigorous analysis or a redesign of the nozzle or piping. Excel spreadsheet formulas can be conveniently used to make calculation for differential pressure flow meters, like an orifice flow meter, a venturi meter, or a flow nozzle meter. Simple Beam Deflection Calculator Excel February 13, 2019 - by Arfan - Leave a Comment Simple beam two unequal point lo unequally ed beam formulas for multiple point lo structural double point load beam deflection structural ering exle on deflection calculation for cantilever beam overhanging beam point load on end. I never understand what the theories behind the limits are. 1 4 3 2 2of13 8 foundation loading data 9 venting calculations 16 10 nozzle flexibility analysis as per appendix p 19 11 shell to roof rafter joint stress analysis 20. This tutorial provides stepwise procedure to 1. xls 09_Transmission Line Calculator. 20 Electrical MS Excel Spreadsheets. This load shall be permitted to be included with the general lighting load and subject to the demand factors provided in Table 220. Please email us at drillingtools@tdaweb. However, the use of these units can cause the freezing of the molten metal at the end of. Nozzle load calculation excel in Title/Summary NOZZLE Nozzle is a one-dimensional with cross-sectional area variation, compressible flow computer program for the analysis of converging-diverging nozzles. 0 Introduction to Nozzle Loads. Tubes: 0 in HydrotestShell: 1820 psi HydrotestTube: 195 psi. Tabs "oxidizers" and "grains" - there you can specify the properties if hybrid motor is to be analyzed. Figure 2: The program is useful for a single nozzle as well. xls 11_Residential Load. The nozzle is assumed to be penetrated to a cylindrical or spherical shell. While orifice meters are cost effective, they have several disadvantages. Container Loading Calculator is smart, easy to use load planning application. MATLAB file, MATLAB function, Truss analysis, plane truss, visualization, View all files of Finite Elements Method. Optimization of Piping System for Nozzle Loads. Click "Formulas" in the list of items on the left. xlsx format. Click to open and edit a Microsoft Office Excel workbook with standard nozzle loads that can be imported into the software. A utomatic irrigation sprinklers calculations. Strength Reduction. ) Orifice meter calculations for gas flow using ISO 5167-2:2003; Orifice meter calculations for liquid flow using ISO 5167-2:2003. Use our XLC add-in for Excel to display cell formulas as easily readable mathematical equations. These templates use S. xls 04_T310-16 Conductor Size Calculation_Newton. The pipe nozzle load limits are developed by the equipment manufacturer and are intended to prevent malfunction, such as shaft misalignment, or distortion of the casing that could impede the movement of impellers. we know that the Density of bricks varies between 1500 to 2000 kg per cubic meter. How to Calculate a Percentage of a Number. In the date column, you'll input the date on which you take out the loan, as well as first two dates upon which you plan to make the monthly payment (e. OR1ONiAL This calculation verifies pipe support. Design Calculation Of Nozzle Junction Based On ASME Pressure Vessel Design Code. The General Electrical Load Requirements are based on the inside square feet area of the home which is then used to calculate the basic lighting load and required appliance circuits. Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Column is the main supporting structural member of any building. Pump Size Calculation Excel Spreadsheet Type of Pump The selection of type and construction of a pump is very important to meet the process specification and proper application. Material properties come into FE107 automatically from MatPRO. NOTE A: The security level in Excel must be set to no higher than "Medium" in order to execute code with embedded VBA. Heat load calculations. Most pressure vessels contain operating liquids which produce static head that must be accounted for when determining the design pressure P and MAWP per ASME VIII, paragraph UG-98. For instance, you can use Excel to calculate car loan transactions and payment amounts as well as the total interest paid over the life of a loan. We charge members an annual subscription fee, we offer 50%. How to Calculate a Percentage of a Number. The calculation is intended for the geometrical design and strength control of statically loaded welded connections of machine structures manufactured from carbon steels. 3 Design Calculation of Parts, Costing, Dimensional Sketch of Body Flange. In real nozzles, the length to throat area ratio is important for keeping the flow attached. They will also calculate the number of tubes needed for a shell and tube heat exchanger and to calculate the pipe length needed for a double pipe heat exchanger. August 2nd, 2012 Why Perform UG-99 Hydrotest Stress. Allowable load values upto nozzle size 16 inch is provided in the table. Re: API 650 Tank Nozzle Load Allowable For Tank dia. Nozzle loads are the net forces and moments exerted on equipment nozzles from the weight and thermal expansion of connected piping and equipment. Use your free session. Nozzle Velocity Measured Depth Drill Bit Pump Hydraulic Horsepower ECD @ Bit Bit Hydraulic Horsepower Nozzle Area Percent Horsepower @ Bit Surface Equipment Loss Bit HSI Bit Nozzle Pressure Drop Impact Force UPDATED MARCH 1995 THE END APPLICATION CREATED 1993 This application can evaluate or design for optimum bit hydraulics. Excel formulas use the ideal gas law to calculate the density of a gas for known gas molecular weight, temperature and pressure. Load Definition is one of the biggest mistakes in nozzle analysis! Don't get the load directions wrong! FE107 load input is clear and uncomplicated. Cylinder A contains air at high pressure, and takes the place of the chamber. Download Edit in Browser Share. Pipe Hanger Generation. The live load calculator aims to find maximum live load moment under a choice of truck models. area reinforcement & mawp calculation nozzle radius for force calculation rxn tn/ in(1+tn/rn) shell radius for force calculation rxs teff/ in(1+teff/reff) allowable local primary membrane stress sallow 1. This is the general classification of loads. 150 x 1 x 3 x 2000 = 900 kg,. First step needed is to enable WRC under File > Item Properties. P&P Electrical Load Calculation Form Updated: 02/02/2017 (jhall) BUILDING & SAFETY DIVISION │ PLANS AND PERMITS DIVISION DEVELOPMENT SERVICES CENTER. Nozzle loads can create torsional stresses across pipe-work, pumps and supports in a pumping system. Please help, is iam looking at the right edition?. HVAC Load Calculator. 0625 in CorrosionAll. You May Also Like These E-Books:-Total HVAC Calculations in Excel Sheet:. COMPRESS also includes consideration of the effect of piping loads on nozzle flanges. I think your tank vendor should suggest the type of nozzle load calculation (API 650 or WRC 107). Download free Excel spreadsheets for engineering calculations. In real nozzles, the length to throat area ratio is important for keeping the flow attached. In addition, you can use Excel to compare multiple scenarios in order to make sound financial decisions. 3 Conditions Requiring Calculation. 107: Local Stresses in Cylindrical Shells Due to External Loadings on a Radial Flush Nozzle: Pressure stresses per BS5500 G. Low cost engineering calculations software available for convection heat transfer coefficients, pipe flow/friction factor calculations, partially full pipe flow calculations, watershed time of concentration, rational method, orifice and venturi meter flow rate calculations, open channel flow measurement, activated sludge wastewater. Pressure Vessel Stress Calculations Brian Stress calculations for a 5 foot Long 2 foot in diameter cylindrical pressure vessel during normal operation pressure of 150 psi Hoop Stress or Stress in the Circumferential Direction = Pr/t With P = 150 psi, r = 12 in, and t =. For the Payment column, enter the first three payment numbers (e. Tubes: 0 in HydrotestShell: 1820 psi HydrotestTube: 195 psi. Excel Integration. 1)resistance to sliding 13 8 foundation loading data 14 contents:-sr. In this simulator, viscous effects are ignored, and the length is used only for "nice" graphics--it does not affect the calculation of thrust. Anyone have idea how to calculate allowable nozzle loads? If any spreadsheet is there please share Thanks Praphulla praphulla. Re: API 650 Tank Nozzle Load Allowable For Tank dia. The objective of this paper is to explain the effect/influence of stiffness generated from three different methods (Anchor, WRC and Finite element method) on nozzle load evaluation and shell/nozzle junction stresses. RESULT AND DISCUSSION: The following methodologies have been considered for nozzle to head junction under nozzle external. Local loads due to a nozzle in WRC 107/297: Why is the weld joint efficiency equal to 1 in AutoPIPE Vessel? Q. This Excel spreadsheet calculates the flowrate from the pressure drop across a gas orifice meter with the equations defined in ISO 5167. Truck Loads consist of P1, P2 and P3 axle loads, and wllu uniform load per lane. Among the strong features of spreadsheets are their instinctive cell-based structure and easy to use capabilities. we know that the Density of bricks varies between 1500 to 2000 kg per cubic meter. Nozzle-FEM is designed for stresses and flexibility calculation of nozzle-to-shell junctions using the Finite Element Method (FEM). A load of not less than 1500va shall be included for each 2wire laundry branch circuit installed as required by 210. Please email us at drillingtools@tdaweb. For instance, you can use Excel to calculate car loan transactions and payment amounts as well as the total interest paid over the life of a loan. HVAC Load Calculator. By default this calculator is selected for monthly payments and a 30-year loan term. In this way the load limits and load capacity of the nozzle can be determined and. How to Calculate a Percentage of a Number. The result was a primitive combination of hand and spreadsheet based calculations, which gave a solution to equation 9 of Porta's paper and provided chimney throat and nozzle sizes for the Lempor exhaust design on my (Richard Stuart's) Garratt project. I never understand what the theories behind the limits are. The pipe nozzle load limits are developed by the equipment manufacturer and are intended to prevent malfunction, such as shaft misalignment, or distortion of the casing that could impede the movement of impellers. Please help, is iam looking at the right edition?. Strength Reduction. Allowable load values upto nozzle size 16 inch is provided in the table. Update 11/12/2015: The main download and the Google version now have you enter the total number of payments rather. Tab "propellants" contains basic information about fuel mix that is used for calculation of nozzle characteristics (Best source for this is ProPEP3) / it can be put either by "propellant manager" or directly via the tab. Excel gives you a lot of formulas and formula-combos to do the same thing. As the load profile for each pump nozzle is composed of three force and moment components each, it is impossible to specify all conceivable combinations for the theoretical limits of pump nozzle loads. Pump Size Calculation Excel Spreadsheet Type of Pump The selection of type and construction of a pump is very important to meet the process specification and proper application. RESULT AND DISCUSSION: The following methodologies have been considered for nozzle to head junction under nozzle external. Example: Design an R. Nozzle loads applied by piping to various types of pump and compressor, and to steam turbines, may be analysed with Pipemill. To calculate the required wattage rating needed to supply the subpanel, multiply the total wattage (from the square footage and appliance calculations) times 1. Limits Nozzles less than 1/2 D AND 508mm, in cylindrical shells < = 1520mm Dia Nozzles less than 1/3 D AND 1000mm, in cylindrical shells > 1524mm Dia No restriction on Formed Heads (UG 36) Set Through Nozzles h 0:= Distance nozzle extends below shell; must not exceed the smaller of 2. This loan calculator template generates a loan amortization schedule based on the details you specify. ASCE705W ASCE 7-05 Written for analysis of air load for code and structures for Spreadsheets program written in MS-Excel. Servo motor sizing spreadsheet is tested on Microsoft Excel 2007, 2010, 2013 and 365 for Windows. , 2/1/2005, 3/1/2005 and 4/1/2005). 2 Design Formulas 9. xls 03_Capacitor kVAR Calculator. 0625 in CorrosionAll. Click on the hyperlink to download the file. 2(a): (radial load should not include pressure end load). online since 2011. Excel spreadsheet formulas can be conveniently used to make calculation for differential pressure flow meters, like an orifice flow meter, a venturi meter, or a flow nozzle meter. This calculator will calculate heating loads for air. Firstly, the allowable nozzle loads on a tank are generally significantly different to a similar sized pressure vessel with a nozzle of the same diameter. txt) or read online for free. Simple Beam Deflection Calculator Excel February 13, 2019 - by Arfan - Leave a Comment Simple beam two unequal point lo unequally ed beam formulas for multiple point lo structural double point load beam deflection structural ering exle on deflection calculation for cantilever beam overhanging beam point load on end. Design method, by. This load shall be permitted to be included with the general lighting load and subject to the demand factors provided in Table 220. AC load at 100%. Heat Load Calculation Spreadsheet - Cooling load calculations for HVAC: This database calculates the following: 1. The objective of this paper is to explain the effect/influence of stiffness generated from three different methods (Anchor, WRC and Finite element method) on nozzle load evaluation and shell/nozzle junction stresses. Less Than 36mtr 02/25/2013 9:12 PM If I remember correctly, the issue with the 36m was that the technical paper upon which the design is based assumed that thickness was proportional to internal pressure. Nozzle Loads 1. Orifice and Venturi Flow Meter Calculations Spreadsheet Screenshot. However, if one or. For instance, you can use Excel to calculate car loan transactions and payment amounts as well as the total interest paid over the life of a loan. Beginning with COMPRESS 2020, the procedure outlined in UG-44 is also available. In 1974, Mike realized there was a need for quality electrical training and opened Mike Holt. I never understand what the theories behind the limits are. 2(a): (radial load should not include pressure end load). emvd (2015 -01 -28) AutoPIPE Vessel (Microprotol) procal V33. I need to calculate the "Allowable nozzle loads" for a pressure vessel and was looking into the forum and referred the "Pipe Stress handbook - Second edition" by Victor Helguero, Chapter 8 "Design criteria for allowable loads, moments and stresses" and could not trace out the formulas. The objective is to establish allowable nozzle load tables for the piping designer and the vessel designer. 7 s 91o to 100o, a = 0. In the Calculation options section, click the "Manual" radio button to turn on the ability to manually calculate each worksheet. Loads on neither nozzle will have any real influence on pump performance. ExcelCalcs is a community who share an interest in making calculations with MS Excel. Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. 84,Supplement to WRC Bulletin No. As the load profile for each pump nozzle is composed of three force and moment components each, it is impossible to specify all conceivable combinations for the theoretical limits of pump nozzle loads. As a minimum, the Piping Stress Engineer shall ensure that the loads on the Nozzle of the Mechanical Equipments are within these values. Each has built in Excel formulas to calculate unknowns like the pipe flow. However, if one or. road construction estimating EXCEL spreadsheet. Centrifugal Pumps: For pumps which are designed based on API standard, allowable loads has to be taken from API 610 (If loads are more than allowable values as specified in table 5 of the standard, perform appendix P). Allowable load values upto nozzle size 16 inch is provided in the table. An iterative (trial and error) calculation is needed to get a value for C d, because the upstream velocity needed for Re isn't known until C d is known. The minimum allowable nozzle loads for Fired Heaters shall be THREE times as specified in API-560. Enter the number of 20 amp laundry branch circuits. 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. Single Family Dwelling Load Calculation - Step by Step Example (Optional Method) CEC 220. Price : 3000 INR = 60. Low cost engineering calculations software available for convection heat transfer coefficients, pipe flow/friction factor calculations, partially full pipe flow calculations, watershed time of concentration, rational method, orifice and venturi meter flow rate calculations, open channel flow measurement, activated sludge wastewater. Download the Excel spreadsheet templates in this article to make preliminary heat exchanger design calculations. 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. 25 B) make it possible to increase the yield of median particle size powder (40-60 μm) by maximizing the gas velocity and density at the meeting with the metal stream [32]. Nozzle loads are shown in Table I. Right click on the following image to save a copy of our Excel loan calculator spreadsheet, or click on it to directly open it. , K bolt preload, Fi (lb) major diameter,d (in) proof strength, Sp (psi) joint tensile load, P (lb) grip length, l (in) threaded length in grip, lt (in) tensile stress area,At (in^2) major diameter area, Ad (in^2) bolt stiffness. First, select the column with the required pressure across the top, then read down the column to find the amount of flow of your system. Download More Engineering Books. Pressure Vessel Engineering Ltd. RESULT AND DISCUSSION: The following methodologies have been considered for nozzle to head junction under nozzle external. Axle Weight Distribution Formulae To calculate distribution of weight on the front and rear axles of a truck, use these simple formulae: Let's take an example Step 1: Determine the Wheelbase You will find this on the…. This calculator want evaluate heating loads for air conditioning …. Foam Calculations By David F. Some methods evaluate stress in the cylindrical or spherical shell (e. They are Microsoft Excel spreadsheets for structural engineering applications. HVAC COOLING LOAD CALCULATIONS AND PRINCIPLES Sensible Heat Gain - is the energy added to the space by conduction, convection and/or radiation. Nozzle stiffness is the important parameter in evaluation of various components of nozzle loads. Excel formulas use the ideal gas law to calculate the density of a gas for known gas molecular weight, temperature and pressure. The pipe nozzle load limits are developed by the equipment manufacturer and are intended to prevent malfunction, such as shaft misalignment, or distortion of the casing that could impede the movement of impellers. Unbalanced Load in Neutral Wire. Document design calculations for pipe support referenced in calculations title. ASCE705W ASCE 7-05 Written for analysis of air load for code and structures for Spreadsheets program written in MS-Excel. This is a must in areas that have hard freezes. Kozdera and M. Various methods have been in use for the determination of stresses at the nozzle-shell junction due to external loads and moments. zip files contain additional files which require software as well. Passing a storage tank nozzle loads has been a nightmare for the most stress engineers. you can calculate the flexibilities of a nozzle at the nozzle/vessel interface and use them for pipe stress. General lighting demand. Get a quick and clear picture of what it will take to pay off your mortgage with this accessible mortgage loan calculator template. If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. 84,Supplement to WRC Bulletin No. AC load at 100%. Design Calculation Of Nozzle Junction Based On ASME Pressure Vessel Design Code. How to Calculate Piping loads? and related to the fluid we need the density in order to calculate the weigth per meter. The ServiceTitan HVAC Calculator is intuitively designed to help you figure out the recommended equipment capacity for any room or house. Note: You may now enter the values in either 32nds of an inch or in thousandths of an inch (like Enderle Fuel injectors). Nozzle inlet TO 1st stage and nozzle outlet FROM 1st stage (combine) 2. 002 Total Load = 0. Nozzle Required Thickness Calculations Required Nozzle Thickness for Internal Pressure per Paragraph UG-37(a) trn = PRn SE - 0. xls 11_Residential Load. So below is the screen shot for the EMI Calculator in Excel Sheet. Almasi, " Practical notes on power plant machinery nozzle load and piping ", in Journal of power and energy, Procedings of the institution of mechanical engineers part A, 2013, pp. It is generally installed at the point of connection that is leading to the sprinkler system (generally close to the meter or a building). 4) is a spreadsheet program written in MS-Excel for the purpose of wind loading analysis for buildings and structures per the ASCE. The available format is Microsoft Excel™. 5 kW dishwasher Compare the heating load to the AC load and take the larger of the two loads. Download Drive-1. 107: Local Stresses in Cylindrical Shells Due to External Loadings on a Radial Flush Nozzle: Pressure stresses per BS5500 G. Excel spreadsheet formulas can be conveniently used to make calculation for differential pressure flow meters, like an orifice flow meter, a venturi meter, or a flow nozzle meter. 4 "ASCE710W" (version 2. calculates the K Factor and Equivalent Length of a large range of pipe and fittings for use in flow calculations. Codes covered. On selecting a shell component and in the materials tab when clicking on OK, the length becomes 0. 85 times NEMA SM23 Values. The ISO 5167 orifice coefficient calculation spreadsheet template shown in the screenshot at the right will calculate the orifice discharge coefficient based on the indicated input. Calculate the required heat transfer area based on values needed. Downloading worked solutions from our Repository gives you a head start in solving technical problems. Tabs "oxidizers" and "grains" - there you can specify the properties if hybrid motor is to be analyzed. Pressure vessel shell thickness calculation as per ug 27 - Duration: 3:37. This spreadsheet has been made to help electrical contractors by providing a step-by-step document to calculate a service demand. After you create a formula, you can copy it into adjacent cells — no. Engineering Spreadsheets A spreadsheet is a computer application that simulates a paper worksheet where becoming increasingly popular in solving engineering related problems. As shown in figure 1, local stresses are calculated at 8 points, named as , located on two levels, upper and lower plates. Peterson A common emergency that firefighters encounter is flammable liquid spills and fires. VIII bo = Effective gasket seating width, table 2-5. 8, the maximum velocity of the SC-CO 2 jet increases with increasing nozzle pressure drop. Nozzle Required Thickness Calculations Required Nozzle Thickness for Internal Pressure per Paragraph UG-37(a) trn = PRn SE - 0. Click "Formulas" in the list of items on the left. This paper applies API610 to existing piping system and checks weather it is passing it or not. Compute Loads on Nozzle by performing piping flexibility analysis. As a minimum, the Piping Stress Engineer shall ensure that the loads on the Nozzle of the Mechanical Equipments are within these values. nozzle design. MotorSim is essentially a re-write of of Nakka's SRM. A person could use the same spreadsheet to calculate weekly, biweekly or monthly payments on a shorter duration personal or auto loan. MarketXLS provides many stock option related functions. ASHRAE schedule 5 - Shading Coefficients and U-Factors for housing Windows This heating routine sizing calculator is based on the ASHRAE standards. nozzle design. To calculate a loan payment amount, given an interest rate, the loan term, and the loan amount, you can use the PMT function. Heated swimming pool heating under the name of the swimming pool, hot water supply, heat exchanger and the necessary resources research for the heating load calculation to be used in the selection and design of installations yapılmıştır. Downloading worked solutions from our Repository gives you a head start in solving technical problems. Re: API 650 Tank Nozzle Load Allowable For Tank dia. Planning out things and fast access to data and other information are made very easy when using spreadsheet templates. 5 kN per running meter. Loads on neither nozzle will have any real influence on pump performance. The objective of this paper is to explain the effect/influence of stiffness generated from three different methods (Anchor, WRC and Finite element method) on nozzle load evaluation and shell/nozzle junction stresses. Electrical engineering is often. Welded connections. Residential Heating and Cooling Load Calculation 2001 ASHRAE Fundamentals Handbook Excel Sheet HVAC Heat Recovery Air Handling Units Calculation Excel Sheet HVAC Electrical Spreadsheet version for the ACCA Manual D, (3rd Edition). Free Microsoft® Excel viewer software can also be used to view the. Diameter at location of gasket load reaction G = Width used to determine basic seating width, bo N = SCROLL DOWN Basic seating width, table 2-5. Calculating nozzle flexibilities with NozzlePRO for piping flexibility analysis. Heat Load Area Sheet. VIII bo = Effective gasket seating width, table 2-5. For higher sizes ANSI standard is used. It is generally installed at the point of connection that is leading to the sprinkler system (generally close to the meter or a building). Filename: piping calculations excel download Latest Release: 23. #N#Column Calculator. 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. Compatibility. Only comment is a quote from WRC-297:. T o arrive at a Boiler Size requirement , we have provided some Boiler Efficiency Calculations for you to determine the boiler size you may required. Air Curtains and Air Screens - Air curtains or air screens in open doorways are used to keep acceptable indoor comfort in buildings ; Beaufort Wind Scale - The Beaufort description and observation of wind and. Active Equipment Nozzle Loads Active mechanical equipment consist of equipment with moving parts, such as pumps, compressors, and fans. Importance of WRC 107 and WRC 297 in Piping Stress Analysis Whenever Pressure Vessel or Heat exchanger (Static Equipment) nozzle loads exceed the allowable WRC 107 and WRC 297 provide important methods for calculation of local stresses in the vicinity of an attachment to a vessel or Pipe (shell and nozzle junction). Excel templates can be downloaded to make venturi meter and orifice flow meter calculations in U. 5 flange pressure ratings using an equivalent pressure method. Objective of this presentation is to understand basis of nozzle movement calculation. Centrifugal Pump calculations. found to be within those allowable values, then the nozzle loads computed by pipe stress analysis are considered as acceptable. Each has built in Excel formulas to calculate unknowns like the pipe flow. How to calculate WRC values with Sant’Ambrogio NextGen. Alan Williams: "Structuiral Engineering Reference Manual", Professional Publications, Inc, 2001. Automatic Irrigation System Calculation sheet for one kind of Nozzle you can use this type of large range. As shown in Fig. Heat Load Calculator Spreadsheet Calculator Spreadsheet , Spreadsheet August 07, 2019 17:37 With the following thermal load calculation you can know the refrigerators you need for any site in an exact way. This Excel spreadsheet calculates the flowrate from the pressure drop across a gas orifice meter with the equations defined in ISO 5167. 6 s 107o to 113o, a = 0. 002 Total Load = 0. The stop and waste is a shutoff valve that drains the down stream water from a main line. Anyone have idea how to calculate allowable nozzle loads? If any spreadsheet is there please share Thanks Praphulla praphulla. ASHRAE Table 5 - Shading Coefficients and U-Factors for Residential Windows. Sample Vessel 8 PVE-Sample 8 Pressure Vessel Calculations April 27, 2007 XYZ Vessel Inc. Single Family Dwelling Load Calculation - Step by Step Example (Optional Method) CEC 220. Nozzle stiffness is the important parameter in evaluation of various components of nozzle loads. Excel spreadsheet formulas can be conveniently used to make calculation for differential pressure flow meters, like an orifice flow meter, a venturi meter, or a flow nozzle meter. First, we develop the governing equations by applying Bernoulli's Equation and the Continuity Equation. Model the nozzle-to-shell junction as "Nozzle" to incorporate local shell flexibility. 0, the piping reactions may cause excessive stresses in the nozzle-shell junction. Therefore your closest model is a vertical in-line pump since the vectors from pump nozzle to centre-line / support are not relevant in terms of potential shaft misalignment. online since 2011. 85 times NEMA SM23 Values. 005 Mc/Mrcm = 0. COMPRESS also includes consideration of the effect of piping loads on nozzle flanges. Analysis of Stresses in Pressure Vessels and Tank Shells at Nozzle and Clip Connections Resulting from External Loads [ Request download ] WERCO 107/297™ is a comprehensive software package for calculating stresses in shells in accordance with the guidelines set forth in the Welding Research Council Bulletins 107 & 297. Update 11/12/2015: The main download and the Google version now have you enter the total number of payments rather. Wrc-107 nozzle load calculation xls in Description Block Load Carrier's Block Load program is a powerful, fully featured HVAC load estimating program suitable for commercial buildings of any size. Reboilers Storage Tanks Air-coolers. The load cases display in the Load Cases: Bottoms Pump - Discharge grid. Structural Integrity Associates, Inc. Loan EMI Calculator in Excel (. Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Heat load at 65%. To calculate the load, is very important the total weigth because it. RE: Tank Nozzle Load Calculations JStephen (Mechanical) 28 Feb 07 13:22 Check out the alternate design approach in the latest App. The loads on building, may be a residential or any type of structure, are mainly classified into vertical and horizontal loads. Pressure Vessel Nozzle Design Calculator The following are equations and a calculator to determine the wall thickness of a welded nozzle connection to a shell, head or similiar geometry. 1)resistance to sliding 13 8 foundation loading data 14 contents:-sr. Open the nozzle you want to validate and select the WRC tab like shown in figure. These stiffness then act as a restraint in the piping software. Here we use a converging diverging nozzle to connect two air cylinders. Select a subscription plan and enable the full service: Switch between metric and imperial units in one click. , K bolt preload, Fi (lb) major diameter,d (in) proof strength, Sp (psi) joint tensile load, P (lb) grip length, l (in) threaded length in grip, lt (in) tensile stress area,At (in^2) major diameter area, Ad (in^2) bolt stiffness. warmth weigh down calculations 2. Excel Calculations This article discusses how you can solve the Three Reservoir Problem with Excel. Rcc column design is an important part of designing any building. 5 flange pressure ratings using an equivalent pressure method. In the event the loads are exceeding the allowable loads values, prior approval from the supplier shall be taken. Centrifugal Pumps: For pumps which are designed based on API standard, allowable loads has to be taken from API 610 (If loads are more than allowable values as specified in table 5 of the standard, perform appendix P). 2 ASME Sect VIII b = Bolt area req'd for seating Am2 = Wm2/Sb = Initial bolt load for seating gasket Wm2 = 3. Various Equipments Distillation Columns Information required to calculate nozzle growth Manual calculation for skirt growth Exchangers Stacked Heat Exchangers. nozzle load calculation api 650 UG45a MaxNozzle Thickness required for pressure, Nozzle thickness to withstand any nozzle loads. The prescribed files are incomplete calculations per ASME for nozzlel area of compensation and not nozzle load calculation. Combined Loads: F/Fmax = 40000 / 47555 Mc/Mrcm = 662 / 140302 Ml/Mrlm = 662 / 279698 F/Fmax = 0. Preview results on one place and copy/paste it in your favorite text editor. com if you experience problems. 5 x s x e force acting on the nozzle fn p x rxn x lh force acting on the shell fs p x rxs (lr + tn) discontinuity force from internal pressure. Open the nozzle you want to validate and select the WRC tab like shown in figure. The paper also suggests two modifications in given system which validates all requirements in the given code. Use our XLC add-in for Excel to display cell formulas as easily readable mathematical equations. Shear Wall Analysis and Design Excel Spreadsheet Calculator. Price : 3000 INR = 60. square short column subjected to axial services compressive load of. 150 x 1 x 3 x 2000 = 900 kg,. 2 Accidental blast loads and allowable stresses Pipe stress blast calculations should be performed in two steps: a) Blast wind calculations Calculation of pipe stresses, support and equipment nozzle loads due to the blast wind (dynamic drag pressure) alone. Voltage drop is a loss of voltage that occurs when electricity travels over. To get a basic feel for the behavior of the nozzle imagine performing the simple experiment shown in figure 2. 29 amps X 240 volts = 6,960 VA. type the following formula into any Excel cell:. xlsx format. The load cases display in the Load Cases: Bottoms Pump - Discharge grid. xls 09_Transmission Line Calculator. emvd (2015 -01 -28) AutoPIPE Vessel (Microprotol) procal V33.