

A Libre Knowledge Page (Rev.30.09.2020)
The intention of this page is to provide Free / Open Source files for piping engineers
General DescriptionThe spread sheets presented here, include all functions required in each case. To produce an addin from a function, save the function as a complement (case of Excel). Examples of functions that read information from a sheet are the "Pipe dimensions functions" and the "Air and water properties functions" It has to be considered, that it is not convenient that the same function is available twice. That could happen, for example, if two books are opened and both contain the same function. Also it could happen that a book has a certain function and at the same time this function has been installed and is available as an addin function. In this case, the addin function should be disabled.See Recommended Good Practice and Disclaimer, at the end of the page. You can leave a comment at the bottom of the page, or by writing to cjcruz[at]pipingtools.net Available toolfiles for download1a. xls Airdry and watersaturated properties.xls.(Water and air properties as a function of temperature. Rev. 15.02.2017) 1b. ods Airdry and watersaturated properties.ods. (Water and air properties as a function of temperature. Rev. 15.02.2017) 2a. xls Air receivers volume calculation.xls (This file presents the calculation of an air receiver, and shows several references related to this theme. Application example and derivation of equation to determine the receiver volume. Rev. 07.08.2018) 2b. ods Air receivers volume calculation.ods (This file presents the calculation of an air receiver, and shows several references related to this theme. Application example and derivation of equation to determine the receiver volume. Rev. 07.08.2018) 3a. xls Atmospheric temperature, pressure and density as function of the height above sea level.xls (This file presents the calculation of atmospheric temperature, pressure and density as a function of the heigth above sea level, according 1976 U.S. Standard Atmosphere. It includes also an approximate method that can be applied for a range of heights 0 km.a.s.l. < H < 6 km.a.s.l. with an error less than 0.1% . Also, it is presented an equation to calculate the water vapor. pressure as a function of temperature. References included. Rev. 09.08.2018) 3b. ods Atmospheric temperature, pressure and density as function of the height above sea level.ods (This file presents the calculation of atmospheric temperature, pressure and density as a function of the heigth above sea level, according 1976 U.S. Standard Atmosphere. It includes also an approximate method that can be applied for a range of heights 0 km.a.s.l. < H < 6 km.a.s.l. with an error less than 0.1% . Also, it is presented an equation to calculate the water vapor. pressure as a function of temperature. References included. Rev. 09.08.2018) 4a. xls Average particle size determination d50 from gravimetric analysis. Meshopening.xls. (For a given granulometric analysis (mesh size vs. Retained percentage) a table of "Mesh vs. Particle size (mesh opening)" is made. The plotted curve allows to find the particle size orresponding to a 50% retained percentage: This is the average particle size or d50 value. Evaluation of a filtrated sample properties. Gravimetric composition of a flow resulting from the joint of two flows. Rev. 09.08.2016) 4b. ods Average particle size determination d50 from gravimetric analysis. Meshopening.ods. (For a given granulometric analysis (mesh size vs. Retained percentage) a table of "Mesh vs. Particle size (mesh opening)" is made. The plotted curve allows to find the particle size orresponding to a 50% retained percentage: This is the average particle size or d50 value. Evaluation of a filtrated sample properties. Gravimetric composition of a flow resulting from the joint of two flows. Rev. 09.08.2016) 5a. xls Bernoulli and piezometric line.xls. (Basic definitions and graphic. Rev. 01.04.2016) 5b. ods Bernoulli and piezometric line.ods. (Basic definitions and graphic. Rev. 01.04.2016) 6a. xls Blower_Air_line.xls (This file presents a calculation sheet for an air line. The pressure drop in each fitting and pipe is calculated and the values in a new line are calculated based in the resulting pressure of the precedent line. Rev. 09.08.2018) 6b. ods Blower_Air_line.ods (This file presents a calculation sheet for an air line. The pressure drop in each fitting and pipe is calculated and the values in a new line are calculated based in the resulting pressure of the precedent line. Rev. 09.08.2018) 7a. xls Channels 1. Channel functions resume and applications_Constant Manning's coefficient_Comparison with Hcanales_Deductions.xls (Resume, deductions, applications for Cicular, Semicircular and rectangular channels. Comparison with Hcanales, for Circular and Rectangular channels. Constant and variable Manning's coefficient Rev. 17.08.2018) 7b. ods Channels 1. Channels functions resume and applications. Constant Manning coefficient. Deductions and comparison with results of Hcanales.ods (Resume, deductions, applications for Cicular, Semicircular and rectangular channels. Comparison with Hcanales, for Circular and Rectangular channels. Constant and variable Manning's coefficient Rev. 19.08.2018) 8a. xls Channels 2. Pulp flow in Circular, Semicircular and Rectangular channels, with constant Manning coefficient.xls (Pulp flow for circular, semicircular and rectangular channels, for constant Manning'a coefficient. Normal and critical cases. Rev. 17.08.2018) 8b. ods Channels 2. Pulp flow in Circular, Semicircular and Rectangular channels, with constant Manning coefficient.ods (Pulp flow for circular, semicircular and rectangular channels, for constant Manning'a coefficient. Normal and critical cases. Rev. 19.08.2018) 9a. xls Channels 3. Pulp flow in Circular, Semicircular and Rectangular channels, with variable Manning coefficient.xls (Pulp flow for circular, semicircular and rectangular channels, for variable Manning'a coefficient Rev. 17.09.2018) 9b. xls Channels 3. Pulp flow in Circular, Semicircular and Rectangular channels, with variable Manning coefficient.ods (Pulp flow for circular, semicircular and rectangular channels, for variable Manning'a coefficient Rev. 19.09.2018) 10. Channels 4. Circular channel. Array output, constant Manning's coefficient.xls (Pulp flow for circular channels, for variable Manning'a coefficient. Array output. Rev. 17.09.2018) 11a. xls Combustion. Adiabatic flame temperature_Jeff Munic.xls (Flame temperature of the combustion of a gas mixture. From an example Jeff Munic. Rev. 17.04.2018) 11b. ods Combustion. Adiabatic flame temperature_Jeff Munic.ods (Flame temperature of the combustion of a gas mixture. From an example Jeff Munic. Rev. 19.04.2018) 12a. xls Combustion. Adiabatic flame temperature_Keenan and Kaye example.xls (Flame temperature of the combustion of octane. From an example of the Gas Tables, Keenen and Kaye. Rev. 19.08.2018) 12b. ods Combustion. Adiabatic flame temperature_Keenan and Kaye example.ods (Flame temperature of the combustion of octane. From an example of the Gas Tables, Keenen and Kaye. Rev. 19.08.2018) 13a. xls Combustion. Chemical reactions.xls (Four examples of combustion analysis. Equations for stoichiometric combustion and combustion with excess air. Dew point temperature. Rev. 19.08.2018) 13b. ods Combustion. Chemical reactions.ods (Four examples of combustion analysis. Equations for stoichiometric combustion and combustion with excess air. Dew point temperature. Rev. 19.08.2018) 14a. xls Combustion. Combustion. Enthalpies of gases of combustion.xls (Enthalpy of gases from Keenan and Kayes Gas Tables Rev. 19.08.2018) 14b. ods Combustion. Combustion. Enthalpies of gases of combustion.ods (Enthalpy of gases from Keenan and Kayes Gas Tables Rev. 19.08.2018) 15a. xls Combustion. Hess's Law and enthalpy of formation.xls (Lower heating values, Higher heating values, enthalpy of formation, difference betweeen HHV and LHV Methane, propane, hydrogen silfide. Rev. 20.08.2018) 15b. ods Combustion. Hess's Law and enthalpy of formation.ods (Lower heating values, Higher heating values, enthalpy of formation, difference betweeen HHV and LHV Methane, propane, hydrogen silfide. Rev. 20.08.2018) 16a. xls Combustion. Mass composition input.xls (Four examples of combustion analysis with input data in mass composition. Coal, Oil, Wood. Rev. 21.08.2018) 16b. ods Combustion. Mass composition input.ods (Four examples of combustion analysis with input data in mass composition. Coal, Oil, Wood. Rev. 21.08.2018) 17a. xls xls Combustion. Orsat analysis.xls (Five examples of Orsat analysis.Methane, Unknown hydrocarbon, coke gas. Rev. 21.08.2018) 17b. ods xls Combustion. Orsat analysis.ods (Five examples of Orsat analysis.Methane, Unknown hydrocarbon, coke gas. Rev. 21.08.2018) 18. Combustion. Volume composition input.xls (Four examples of combustion analysis with input data in volume composition. Natural gas, Ethane, Octane. Rev. 27.12.2016) 19. Combustion. Wet air composition and molecular mass.xls (Wet air composition for air with a given humidity. Excel V.B solution and using Goal seek. Rev. 04.12.2016) 20. Compressor power and air discharge temperature.xls (This file calculates the compressor power of an isentropic and of a real process. Also, the exit temperature of an isentropic and of a real process is calculated. Rev. 08.08.2016) 21. Concentration of nitrogen in a furnace as function of the number of volume changes.xls (A furnace works in ambient of nitrogen. It is required to know the Number of Volume Changes to obtain a desired nitrogen concentration in the furnace. Rev. 08.08.2016) 22. Contraction, velocity and discharge coefficients of a rectangular sharp edeged slot.xls (Coefficients of discharge, contraction and velocity for sharp edged rectangular slots. Singular pressure drop coefficient. Flow rates. Rev. 02.06.2016) 23. Cooling tower. Application_ Treybal.xls (This file is an application of the Merkel theory for cooling towers. Some correction have been made, nomenclature reviewed and some literature added. Still some explanations are required. Pending. Re. 08.12.2018) 24. Cooling tower. Kari Alane Aalto University example.xls (A basic cooling tower application. Required air flow rate is determined, based on a set of initial data. This example correspond to a publication from Kari Alane from Aalto university. Re. 14.11.2018) 25. Cooling tower. Merkel theory_Treybal.xls (This file presents a resume of Merkel's theory for cooling tower, taken from Robert Treybal, Operaciones de transferencia de masa. Rev. 31.01.2014) 26. Dimensioning_compressed_air_installations_Atlas_Copco.xls (This file uses an Atlas Copco reference for the dimensioning of a compressd air installation. It includes compressor, aftercooler, receiver, dryer and pressure drop. Rev. 15.04.2016 ) 27. Dryer with air impinging jets.xls (Design of a strip dryer with air impinging jets. Air pressurized in a fan, heated in an heat exchanger and impinging into a moving steel strip with a water film. Based on Prof. Martin Holger paper. Rev. 13.01.2018) 28. Excel Functions. Part 1 (Eng).pps (Tutorial for Excel functions) Rev. 01.04.2016 29. Excel Functions. Part 2 (Eng).pps (Tutorial for Excel functions) Rev. 01.04.2016 30. Excel Functions. Part 3 (Eng).pps (Tutorial for Excel functions) Rev. 01.04.2016 31a.xls Expansion_loop.xls (This file derives the expansion loop equation an presents a calculation example. Spiraxsarco and Vitaulic references. Rev. 01.08.2018) 31b.ods Expansion_loop.ods (This file derives the expansion loop equation an presents a calculation example. Spiraxsarco and Vitaulic references Rev. 01.08.2018) 32. Flanges Temperature and Pressure Ratings for Group 1.1 materials.xls (Maximum temperature and pressure ratings of flanges conforming dimensions ASME B16.5 Pipe Flanges and Flanged Fittings  and materials specification to ASTM A105. Rev. 06.12.2017) 33. Flow oscillation between two tanks, solved by finite differences.xls ( Two tanks, initially with different water levels, are joint by a pipe and a closed valve. At time zero, the valve is fully open and the water levels start oscillating. Due to the pipe friction, the amplitud of the oscillation will decrease with the time until finally both tanks reaches the same level. The three ordinary differential equations system is solved with finite differences. Rev. 18.09.2020) 34. Friction and singular pressure drop. Water and slurry.xls (This file presents a routine for the calculation of pressure drops due to friction and singularities. Several functions are included for the calculation of fittings and valves. Rev. 08.08.2016) 35. Funciones_Excel_(Power_ point_spanish). Parte_1.pps (Intrucciones para el uso de funciones Excel, Parte 1) 36. Funciones_Excel_(Power_ point_spanish). Parte_2.pps (Intrucciones para el uso de funciones Excel, Parte 2) 37. Funciones_Excel_(Power_ point_spanish). Parte_3.pps (Intrucciones para el uso de funciones Excel, Parte 3) 38. Functions. List of modules and functions for Excel VBA.xls (List of available Excel functions and application examples. 485 VBA functions Rev. 09.01.2019) 39. Gas. Airdry and watersaturated properties.xls (Visual basic functions for dry air at ambient pressure and saturated water . Rev. 31.01.2018) 40. Gas. Atmospheric air at height above sea level_Carmichael.xls (Atmospheric air properties at a given height above sea level (Carmichael) . Rev. 27.02.2018) 41. Gas. Enthalpies_Kennan and Kaye.xls (Enthalpy of gases for combustion calculations (Kennan and Kaye). Rev. 27.02.2018) 42. Gas. Air Properties.xls (Visual basic functions for air properties. Rev. 26.02.2018) 43. Gas. Octane properties.xls (Octane properties for combustion calculations. Rev. 27.02.2018) 44. Gas. Propane_Butane_Saturation_Properties.xls (Saturated Propane and butane properties . Rev. 27.02.2018) 45. Gas. PropertiesVBA functions.xls (Visual Basic functions for gas properties. Rev. 27.02.2018) 46. Gas. Tables.xls (Table with basic gas data. Rev. 27.02.2018) 47. Gas. Viscosity of gases according Sutherland.xls (Sutherland's formula. Dynamic viscosity of an ideal gas as a function of the temperature. Valid for temperatures 0 < T < 555 K, with an error due to pressure less than 10%, below 3.45MPa Rev. 27.02.2018) 48. Gas. Wet air composition.xls (Wet air for a given absolute air humidity. Wet air composition and molecular mass. Rev. 04.09.2020) 49. Gravitational adduction Water Hammer.xls (This file shows a rough method used in an old Project (only of a historical interest). Rev. 26.07.2019) 50. Gravitational discharge of Slurry. Three diameter options(Spanish).xls (Gravitational discharge of slurry with the option of three pipe sizes, under consideration of three flow rates.. Rev. 08.08.2016) 51. Gravitational discharge of water. Ground profile vs Piezometric elevaton.xls (Gravitational discharge through a pipe, for a given ground profile. Rev. 17.07.2018) 52. Heat transfer. Convection in pipes. Thermal conductivity of insulations. VB functions.xls (Convection coefficients for outside and inside of a pipe. Natural, forced and combined outside coefficients and forced interior coefficient for water and steam as fluid. Conductivity of insulations. Rev. 24.06.2020) 53. Heat transfer. Cooling a pipe filled with water.xls (This application calculates the cooling time of water in a carbon steel pipe. The theory needed is deducted. Calculation examples of pipes with and without insulation are presented. A comparison with the results presented in the Mechanical Insulation Design Guide (NMIC) is included. Rev. 04.09.2020) 54. Heat transfer. Exchangers design. Effectivness and number of transfer units NTU.xls (Heat exchangers design by the NTU method. Mills erxamples 8.7 and 8.8. Rev. 27.12.2017) 55. Heat transfer. Flow of oil in an underwater pipeline. Cengel example 8.3.xls (Heat loss from an underwater pipe. Steam condenser. Singlestream. Effectiveness of an heat echanger. NTU Rev. 21.04.2016) 56. Heat transfer. Heat loss from a buried oil pipe. Mills example 3.3.xls (Heat loss from an insulated and an uninsulated buried pipe. The shape form method is used. Rev. 30.09.2019) 57. Heat transfer. Heat loss from a pipe in an indoor location .xls (Heat loss from an insulated indoor pipe. Heat is lost from the exterior pipe surface by convection to the ambient and by radiation interchange with surrounding surfaces. Rev. 04.09.2020) 58. Heat transfer. Heat loss from a pipe in an outdoor location.xls (Heat loss from an insulated outdoor pipe. Heat is lost from the exterior pipe surface by convection to the ambient and by radiation interchange with a clear sky night. Rev. 04.08.2020) 59. Heat transfer. Heat loss from an insulated steel pipe. Mills example 2.1.xls (Heat loss from an insulated indoor pipe. Heat is lost from the exterior pipe surface by convection to the ambient. Mills example 2.1. Rev. 04.09.2020) 60. Heat transfer. Interior pipe convection for water and air.xls (Convection factor for interior flow of water and air in a pipe. Rev. 10.04.2017) 61. Heat_transfer_Pipes_ Ufactors_Annular_fins.xls. (Heat transfer through pipes. Ufactor referred to the inside pipe surface and th outside pipe surfsce. Ufactor of finned pipes. Fin efficiency. Examples. Rev. 30.09.2020) 62. Heat transfer. Steadystate conduction. Twodimensional. Finite differences equations.xls. (Heat transfer by the finite differences method, for steady state systems, using the implicite and explicite methods. Heat equation and Energy balance methods. Examples and derivation of equations from Incropera. Solutions with the matix inversion method and GausSeidel iteration. Rev. 16.02.2019) 63. Heat transfer. Transient conduction. SemiInfinite solid with and without convection. Analytical solution. Underground water pipe.xls. (Transient conduction in a semiinfinite solid. Case of surface mantained at a constant temperature and case where the surface is exposed at an ambient with temperature Tamb and convection h. Three examples. Application to an underground pipe. Rev. 16.02.2019) 64. Heat transfer. Transient conduction. Slab with convection. Solution using a graphic. Annealing of a steel plate.xls (When steel plates are thinned by rolling, periodic reheating is required. A plain carbon steel plate of thickness "2*L", initially at a temperature "tini", is to be reheated to a minimum temperature "tend" in a furnace mantained at "tfurn" A oneterm solution is implemented with VBA functions to replace the use of the Heisler charts.Mills example 3.9 Rev. 26.07.2019) 65. Heat transfer. Transient conduction. Slab with convection. Analytical solution_One term approximation.xls. (Plane wall with its surfaces exposed to an ambient temperature Tamb. and a convection h.Time required to reach a temoerature at a given position. Rev. 18.02.2019) 66. Heat transfer. Transient conduction. Slab with convection. Finite differences solution_explicite method. Resine slab example.xls. (Resine slab cured under an array of air jets. Rev. 18.02.2019) 67. Heat transfer. Transient conduction. Slab with convection. Solution graphic and analytic. Annealing of a steel plate.xls (Annealing of a steel plate in a Furnace. Analytical solution and also using a graphic. Rev. 18.02.2019) 68. Heat transfer. Transient conduction. Slab with infinite convection. Finite differences solution_explicite method_Solved in Visual Basic.xls (Slab with initial temperature and surface temperatures defined in VB code. Slab temperature distribution solved in VB. Case of constant surface temperatures solved analytically in the spreadsheet. Rev. 26.07.2019) 69. Heat transfer. Transient heat conduction equations.xls (Transient analytical solutions. Solutions using graphics. Finite difference explicite method for onedimensional conduction. Rev. 18.02.2019) 70. Heat transfer. Singlestream steam condenser. Mills example 1.8.xls (Performance of a shell  and  tube  steam condenser. Example Mills, 1.8. xls and pdf. Equations, Slide share example. Rev. 08.08.2016) 71. Heat transfer. Temperature of an irradiated surface. Mills example 6.10.xls (Temperature of an irradiated airplane wing, with solar irradiation "Is", air temperature "to" and a known sky emittance. Rev. 08.08.2016) 72. Heat transfer. Thermal conductivity of insulations and refractories.xls (Celular, Fibrous and Granular types of insulations. Refractories insulations. Rev. 04.09.2020) 73. Heat transfer. U factor for resistances in series and in parallel. I.xls (Global heat transfer coefficients "U" for several pipe arrangements. U factors referred to the inside and outside pipe surface. Nocturnal sky radiation. Rev. 24.10.2017) 76. Heat transfer. Underwater pipe for effluent discharge.xls (Underwater pipe for effluent discharge. Discharge temperature of effluent in the sea and heat flow rate from the pipe into the sea. Exterior and interior convection coefficients. Rev. 08.08.2016) 77. Ideal gas. Ideal gas law application to air.xls (Application of ideal gas law to determine air and nitrogen densities. Rev. 06.04.2017 78. Ideal gas. Mass flow of compressible fluids.xls (Application of ideal gas law for the determination of unchoked and choked mass flow rates. Rev. 06.04.2017 79. Isenthalpic throttling process.xls (Valve throttling process. Application examples for steam valves. Steamdat functions are applied and are included. Rev. 08.08.2016) 80. Limit_suction_height_and_Minimum_submergence.xls (This file presents calculation routines for the suction limit height and minimum submergence of a water pump. Rev. 31.01.2014) 81. Mass transfer. Humidification of air flowing over a container. tknGuyen example.xls (Molar flux of watervapor between the water of a container and the air flowing over it.. Rev. 07.11.2018) 82. Math. Bubble point temperature calculation using Newton Raphson_Jeff Munic.xls (Application of the Newton Raphson method to obtain the solution of a bubble pint tempeature. Rev. 19.04.2018) 83. Math. Newton Raphson method applied to floating ball problem.xls (Use of the NewtonRaphson method to solve a third grade equation. Application to solve the case of a metallic thin sphere submerged in water. Rev. 26.01.2019) 84. Math. Least squares method. Regressions linear, second to sixth grades parabolas and exponential curve.xls (Regression using the least squares method, for a stright line and parabolas of second, third, fourth, fifth and sixth grade. Rev. 23.01.2019) 85. Math. Quadratic and Cubic equations solve with VBA functions.xls (Solution of a second and a third grade equations using VBA functions. Real and complex solutions. Links for online solutions of Qudric and Quintic equations. Rev. 26.12.2016) 86. Math. Solution of an implicite equation using the Zero Function method.xls (A routine that can be used to solve implicite equations. Rev. 10.03.2016) 87. Math. Straight line which passes through points A and B, in a LogLog , in a LogNat and in a NatNat plot.xls (Straight line which passes through points A and B in a LogLog graphic, in a LogNat graphic and in a NatNat graphic. Rev. 14.01.2017) 88. Math. System of linear equations solved with matrix inversion method, in Excel and in VBA.xls (Solution of a system of linear equations using the matrix inversion method, in Excel and in Visual Basic.. Rev. 10.03.2016) 89. Math. System of nonlinear equations solved with the NewtonRaphson method, in Excel and VBA.xls (Solution of a system of nonlinear equations using the NewtonRaphson method, in Excel and in Visual Basic.. Rev. 30.10.2018) 90. Math. RungeKutta application to a tank concentration. Jeff Munic.xls (A brine solution of water is added at a given flow rate to a tank with pure water. The volume in the tank is maintained at a constant volume with an overflow drain. Required is the concentration change with time. Ref. Jeff Munic. Rev. 11.12.2018) 91. Math. RungeKutta application to a tank with variable concentration. Jeff Munic.xls (A tank with a solution of caustic liquid is is inially at a given concentration and volume. An upset occurs, and the supply flow rate and the inlet concentration drops down. Required is the tank concentration. Ref. Jeff Munic. Rev. 11.12.2018) 92. Mc_Elvain_Cave_Durand_Bingham_fluids_HR_value.xls (This file presents functions for the calculation of two slurry correction factors applied to the deposition velocity:  Mc Elvain and Cave correction factor and Durand correction factor. (This two function are a digitalization of the curves and therefore no equation is used).  Also is presented a function for Weir  HR factor for estimating the head and the efficiency of slurries, based on the values for water (Note. Weir, in later publications, is proposing a "HRvalue" determination method that also requires the impeller diameter as input data. Rev. 31.01.2014) 93. Minimum_distance_between_pipes_with_ flanches.xls (Flanches dimensions according ASME B16.52003. Minimum distance between flanches and pipes: 30 mm. Valid for pipes without insulation. Distances to be verified if lateral movements or expansions could occur and also if orifice plates or other elements are present. Verify that there is not an occurrence of two flanges face to face. Pipes according ASME B36.10M1996. Rev. 22.05.2016) 94. Mollier_diagram.xls (A PressureEnthalpy, mollier type diagram, built by means of Steamdat functions. Rev. 04.04.2016) 95. Moody diagram. Hagen Poiseuille, Colebrook and Churchill equations_Nikuradse data.xls (For 0 < Re < 2300 Laminar region. Hagen  Poiseuille equation. For 2300 =< Re =< 4000 Critical region. Churchill equation. For 4000 < Re Transition and turbulent regions. Colebrook equation. There is not a theory describing the critical region. Churchill equation describes relatively well this region, for smooth pipes with Rrel <= 0.01, giving conservative values, when compared with Nikuradse experimental data. Although Churchill equation describes also the transition and turbulente regions in accordance with Colebrook, this last equation is used in these regions because its use is often required in certain design criteria Rev. 26.07.2019) 96. Normal_to_real_flow_rate_and_FAD_flow rate.xls (This file presents routines to transform Normal to Real flow rates and inversely, Standard to real flow rates and inversely and FAD flow rates to real or Normal flow rates. Rev. 21.04.2016) 97. Orifice Plates.xls (This file presents routines to calculate orifices plates with applications for air and water. Also, Cameron eqautions for water are presented. Rev. 26.09.2016) 98. Pipes. ColebrookWhite equation solved with NewtonRaphson method.xls ( ColebrookWite equation for the determination of the DarcyWeisbach friction factor is calculated using the NewtonRaphson method . VBA function are used as comparison. Rev. 30.10.2018) 99.a (xls) Pipe dimensions and friction factor.xls (Visual Basic functions for pipe dimensions for carbon steel, stainless steel, HDPE PE100, HDPE PE80, Fibre reinforced polyethylene, pipe friction factor for DarcyWeisbach equation and Manning's coefficient. Rev. 04.09.2020) 99.b (ods) Pipe dimensions and friction factor.ods (LibreOffice Calc Basic functions for pipe dimensions for carbon steel, stainless steel, HDPE PE100, HDPE PE80, pipe friction factor for DarcyWeisbach equation and Manning's coefficient. Rev. 06.07.2017) 100.a (xls) Pipe dimensions_CS_SS_HDPE100_HDPE80.xls (Visual Basic functions for pipe dimensions for carbon steel, stainless steel, HDPE PE100, HDPE PE80, Pipe friction factor for DarcyWeisbach equation and Manning's coefficient. Rev. 04.09.2020) 100.b (ods) >Pipe dimensions_CS_SS_HDPE100_HDPE80.ods (LibreOffice Calc Basic functions for pipe dimensions for carbon steel, stainless steel, HDPE PE100, HDPE PE80, Pipe friction factor for DarcyWeisbach equation and Manning's coefficient. Rev. 04.07.2017) 101.a (xls) Pipes. Flow rate and pressure loss equations.xls (Manning, Hazen Williams, DarcyWeisbach, friction factors, Colebrook. Rev. 10.07.2017) 101.b (ods) Pipes. Flow rate and pressure loss equations.ods (Manning, Hazen Williams, DarcyWeisbach, friction factors, Colebrook. Rev. 10.07.2017) 102.a (xls) Pipes. Maximum span between pipe supports for a given maximum tension stress.xls (Determination of the length between pipe supports by the method of the "Maximum tension Stress due to bending and internal pressure". This file was corrected according comments from Derek Marshall Rev. 04.09.2020) 102.b (ods) Pipes. Maximum span between pipe supports for a given maximum bending stress.ods (Determination of the length between pipe supports by the method of the "Maximum tension Stress due to bending and internal pressure". Pending corrections according comments from Derek Marshall Rev. 30.11.2018) 103. Pipes. Network analysis using the Hardy Cross method _SI units.xls (A water network with three loops is solved using the Hardy Cross method. The solution is found with 12 iteration steps. Rev. 12.12.2018) 104. Pipes. Network analysis using the Hardy Cross method _Imperial units.xls (A water network with three loops is solved using the Hardy Cross method. The solution is found with 12 iteration steps. Rev. 28.10.2018) 105. Pipes. Network analysis using the Newton Raphson method.xls (A water network with one loop is solved using the Newton Raphson method. The solution is found with one iteration step. Rev. 27.10.2018) 106.a (xls) Pipes. Pressure and temperature ratings for carbon steel flanges of material groups 1.1 and 1.2.xls (Carbon Steel Flanges  Pressure and Temperature Ratings  Groupes 1.1 and 1.2 Maximum temperature and pressure ratings of flanges conforming dimensions ASME B16.5 and materials specification ASTM A105 Rev. 24.07.2017) 106.b (ods) Pipes. Pressure and temperature ratings for carbon steel flanges of material groups 1.1 and 1.2.ods (Carbon Steel Flanges  Pressure and Temperature Ratings  Groupes 1.1 and 1.2 Maximum temperature and pressure ratings of flanges conforming dimensions ASME B16.5 and materials specification ASTM A105 Rev. 24.07.2017) 107.a (xls) Pipes. Pressure and wall thickness equations and data for a straight pipe according ASME B31.1 and B31.3.xls (Pipe wall thickness and pressure for carbon steel pipes. Equations and data. Comparison of both standards. Rev. 04.09.2020) 107.b (ods) Pipes. Pressure and wall thickness equations and data for a straight pipe according ASME B31.1 and B31.3.ods (Pipe wall thickness and pressure for carbon steel pipes. Equations and data. Comparison of both standards. Rev. 24.07.2017 108.a (xls) Pipes. Wall thickness calculation according ASME B31.3.xls (Pipe wall thickness for carbon steel pipes according ASME B31.3. Rev. 04.09.2020) 108.b (ods) Pipes. Wall thickness calculation according ASME B31.3.ods (Pipe wall thickness for carbon steel pipes according ASME B31.3. Rev. 04.09.2020) 109.a (xls) Pipes. Slope required for a pipe to avoid fluid accumulation.xls (Slope of a pipe to avoid accumulation of fluid in case the pipe should be emptied. To avoid the accumulation of fluid, one support shall be installed at a height lower than the other, at a difference Dh [mm]. The tangent at the point of inflection (P) of the beam must become horizontal to get that no fluid can remain stored. Rev. 10.07.2017) 109.b (ods) Pipe. Slope required for a pipe to avoid fluid accumulation.ods (Slope of a pipe to avoid accumulation of fluid in case the pipe should be emptied. To avoid the accumulation of fluid, one support shall be installed at a height lower than the other, at a difference Dh [mm]. The tangent at the point of inflection (P) of the beam must become horizontal to get that no fluid can remain stored. Rev. 10.07.2017) 110. Pneumatic transport in dilute phase. Rhodes example.xls (Martin Rhodes, Introduction to particle technology. Example 8.1. Design calculation for dilute pneumatic transport. Spreadsheet make use of some VBA functions. Rev. 30.11.2018) 111. Pressure. Maximum allowable pressure, ASME B31.3. Pipes A53, A106, API 5L (dn Sch) at a given temperature.xls (Maximum allowable pressure and temperature ratings for petroleum refinery piping and chemical plant piping systems according ANSI/ASME B31.3 (2008) Process piping, materials grade B: A53, A106, API 5L, pipes with plane ends. Allowable stresses from ASME B31.3, 2008, page 146) Maximum pressure calculated according Ec. 3a Maximum temperature and pressure ratings of flanges conforming dimensions ASME B16.5 and materials specification ASTM A105 Rev. 12.06.2015) 112. Pressure. Pressure loss in a steam pipe. Tabulated example.xls (Pressure drop of a steam flow rate "m ton/h" in a carbon steel pipe with nominal diameter "dn", schedule "Sch" and absolute rugosity "Rabs". The pipe is located at a hight above sea level "H m.a.s.l." The steam inlet pressure is "pin_g bar (g)". Pipe lengths and fittings are shown in the calculation table. Rev. 05.12.2017) 113. Pressure. Pressure loss in a steam pipe. Tyler example.xls (Pressure drop of a steam flow rate "m ton/h" in a carbon steel pipe with nominal diameter "dn", schedule "Sch" and absolute rugosity "Rabs". Tyler Example with a pressure reducing valve. Rev. 05.12.2017) 114.a (xls) Pressure rating for PVC pipes .xls (Pressure rating for industrial PVC, schedules 40, 80 and 120. Rev. 24.07.2017) 114.b (ods) Pressure rating for PVC pipes .ods (Pressure rating for industrial PVC, schedules 40, 80 and 120. Rev. 24.07.2017) 115. Propane_Butane_Saturation_Properties.xls (Propane and butane saturation properties, gas and liquids. Rev. 07.06.2016) 116.a (xls) Psychrometric chart.xls (Psychrometric charts: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, for heights above sea level of 0 m.a.s.l. and 5300 m.a.s.l. Rev. 01.03.2018) 116.b (ods) Psychrometric chart.ods (Psychrometric charts: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, for heights above sea level of 0 m.a.s.l. and 5300 m.a.s.l. Rev. 15.02.2017) 117.a (xls) Psychrometric chart with process shown in diagram.xls (Psychrometric charts: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, for heights above sea level of 0 m.a.s.l. and 5300 m.a.s.l. Psychtometric functions for following input variable input groups: 1. tdb, f, H 2. tdw, twb, H 3. tdb, x, H 4. enthalpy, x, H 5. tdb, enthalpy, H Rev. 01.03.2018) 117.b (ods) Psychrometric chart with process shown in diagram.ods (Psychrometric charts: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, for heights above sea level of 0 m.a.s.l. and 5300 m.a.s.l. Psychtometric functions for following input variable input groups: 1. tdb, f, H 2. tdw, twb, H 3. tdb, x, H 4. enthalpy, x, H 5. tdb, enthalpy, H Rev. 22.05.2016) 118.a (xls) Psychrometric functions_Deductions.xls (Psychrometric functions: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, dew point temperature, specific volume and density, for heights above sea level til 5300 m.a.s.l. Rev. 01.03.2018) 118.b (ods) Psychrometric functions_Deductions.ods (Psychrometric functions: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, dew point temperature, specific volume and density, for heights above sea level til 5300 m.a.s.l. Rev. 15.02.2017) 119.a (xls) Psychrometric functions_Resume.xls (Psychrometric functions, only a resume: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, dew point temperature, specific volume and density, for heights above sea level til 5300 m.a.s.l. Rev. 01.03.2018) 119.b (ods) Psychrometric functions.ods (Psychrometric functions, only a resume: Dry and wet bulb temperature, absolute humidity, relative humidity, enthalpy, dew point temperature, specific volume and density, for heights above sea level til 5300 m.a.s.l. Rev. 15.02.2017) 120. Psychrometry. Heat recovery air handling unit (Ahu). By Ömer Faruk D.xls (This spreadsheet calculates air flow and battery capacity for Air Handling Units. The data used corresponds to a location in Turkey. In the example, data for the city of Bursa has been used. You can change the data according to your city, in the Data page. By Omer Faruk D., Makine Mühendisi , Mechanical Engineer Rev. 01.10.2014) 121. Pump. Demineralized water(Spanish).xls (Standard type calculation for water. Rev. 31.01.2014) 122. Pump. Detention time of a pump impulsion system.xls (The routine calculates the time interval "t", from the deenergization of the pump, until the system comes to rest. It is considered the inertia of the pump, motor and fluid and the friction between fluid and pipe. An ascending pipe with constant slope is assumed. The friction factor is considered constant and with the value of the steady state condition. Rev. 29.07.2016) 123. Pumps_Froth_Selection_Warman.xls (A froth pump calculation according a Warman' reference. Ref. 16.06.2016) 124. Pump. Heterogeneous_Slurries_Type_A_Warman.xls (A froth pump calculation for heterogeneous slurry, according a Warman. To calculate the pressure drop of a "Weir type A slurry", the system is to be calculated as if the fluid were water. The file presents a usual input data sheet a water pressure drop calculation and finaly the calculation of the pressure difference that in some cases has to be added to the calculated pressure.. Ref. 14.06.2016) 125. Pump. Lubricating oil(Spanish).xls (Standard type calculation for lubticating oil circuit. Rev. 31.01.2014) 126. Pump. Minimum submergence_Limit suction height_Suction mouth.xls (Estimation of minimum submergence to avoid vapor entrainment / vortex formation / cavitation. Minimum pump suction height. Rev. 15.06.2016) 127. Pump. Reactives(Spanish).xls (Standard type calculation. Rev. 31.01.2014) 128. Pump. Slurry froth.Three diameter options (Rev. 24.10.2013).xls (Pump selection for Slurry with froth, according Weir. Rev. 31.01.2014) 129. Pump. Slurry lime_Loop(Spanish).xls (Standard type calculation. Rev. 31.01.2014) 130. Pumps_Slurry_Selection_Typical_Warman.xls (Example of Warman Slurry Pumping Handbook Australasian version, Feb. 2000 Rev. 14.06.2016) 131. Pump. TDH , NPSH, Pump power.xls (Pumping system between two water tanks. Results are calculated in a spreadsheet and by means of "user defined Excel functions" Ref. 06.07.2016) 132. Pump. Water_circuit system_Primary_Grinding_dust_suppression.xls (Standard type calculation for a water net. Rev. 12.06.2016) 133. Reception of a VBA output matrix data in a spreadsheet.xls (Reception of matrix output data from a VB function in an Excel sheet as a vertical matrix. Rev. 07.06.2016) 134. Relationships_between_Cv_Kv_and_C.xls (Determinaqtion of DarcyWeisbach "K" factor as a function of "Cv" value from valves. Rev. 22.05.2016) 135. Sand_trap.xls (Determination of the basic sand trap dimensions using a VBA function . Rev. 31.01.2014) 136. Settling_velocity_of_spherical_particles.xls (Settling velocity of spherical particles as function of particle diameter, solids density, liquid density and liquid absolute viscosity (VBA) Rev. 05.06.2016) 137.a (xls) Slurry. Basic calculations. Examples 1 to 13_ Equations and Figures_Bingham fluids.xls (13 examples from chapter 11 of Slurry Systems Handbook. Rev. 15.02.2017) 137.b (ods) Slurry. Basic calculations. Examples 1 to 13_ Equations and Figures_Bingham fluids.ods (13 examples from chapter 11 of Slurry Systems Handbook. Rev. 15.02.2017) 138.a (xls) Slurry. Bingham pressure drop calculations.xls. Examples 5.1 to 5.4 _Equations (4 examples from chapter 5 of Slurry Systems Handbook. Rev. 15.02.2017) 138.b (ods) Slurry. Bingham pressure drop calculations.ods. Examples 5.1 to 5.4 _Equations (4 examples from chapter 5 of Slurry Systems Handbook. Rev. 15.02.2017) 139.a (xls) Slurry. McElvain CaveDurandBingham fluidsHR value.xls. Examples 5.1 to 5.4 _Equations (4 examples from chapter 5 of Slurry Systems Handbook. Rev. 26.04.2017) 139.b (ods) Slurry. McElvain CaveDurandBingham fluidsHR value.ods. Examples 5.1 to 5.4 _Equations (4 examples from chapter 5 of Slurry Systems Handbook. Rev. 15.02.2017) 140.a (xls) Slurry. Property equations and functions.xls (Relations between slury concentrations, densities and specific weights. Rev. 03.06.2016) 140.b (ods) Slurry. Property equations and functions.ods (Relations between slury concentrations, densities and specific weights. Rev. 05.07.2017) 141. Slurry. Pumps. Power law, Bingham. Heterogeneous flow.xls (Pump power of a power law fluid. Pump pressure of a Bingham fluid well. Pressure loss of an heterogeneous fluid. Rev. 03.06.2016) 142.a (xls) Slurry. Settling velocity according JRI.xls (JRI recommend three types of equations to calculated limit deposition velocities, according the particle average size and pipe diameter. Rev. 04.07.2017) 142.b (ods) Slurry. Settling velocity according JRI.ods (JRI recommend three types of equations to calculated limit deposition velocities, according the particle average size and pipe diameter. Rev. 04.07.2017) 143. Sound_pressure_level.xls (Calculation of SPL, based on octave band test data. Rev. 02.06.2016) 144. Spherical_particle_drag_coefficient.xls (Spherical particle drag coefficient as a function of particle Reynolds number. Rev. 05.06.2016) 145. Steam. Applications using Steamdat_97.xls (Steamdat function used to calculate a steam turbine stage and pressure reducing valve "PRV" with desuperheating. Rev. 06.04.2017) 146.a (xls) Steam. Applications using Magnus Holmgren functions.xls (Steam and water functions used to calculate a steam turbine stage and pressure reducing valve "PRV" with desuperheating. The data used by the functions is included in the code. Rev. 04.09.2020) 146.b (ods) Steam. Applications using Magnus Holmgren functions.ods (Steam and water functions used to calculate a steam turbine stage and pressure reducing valve "PRV" with desuperheating. The data used by the functions is included in the code. Rev. 25.07.2017) 147.a (xls) Steam. Desuperheater. Spirax Sarco.xls (Desuperheater application. An example from Spirax Sarco. Rev. 22.10.2017) 147.b (ods) Steam. Desuperheater. Spirax Sarco.ods (Desuperheater application. An example from Spirax Sarco. Rev. 24.07.2017) 148.a (xls) Steam. Steam properties. Magnus Holmgren. 20 added functions.xls (VBA functions for steam and water properties. Function data is included in the code.Added functions are approximations, not from M. Holmgren . Rev. 27.06.2018) 148.b (ods) Steam. Steam properties. Magnus Holmgren. 20 added functions.ods (VBA functions for steam and water properties. Function data is included in the code. Added functions are approximations, not from M. Holmgren . Rev. 27.06.2018) 149. Steam. Steam dryer. Flow required in a pulp dryer.xlsm (Determination of steam requirements for a vapor driven slurry dryer. Steam and condensate pipes are defined. Rev. 10.04.2017) 150. Link_to_get_the_Steamdat_functions.xls (The file is available and free to use at https://www.afconsult.com ÅF's website. Rev. 01.06.2016) 151. Steam. Steam flow required in a pulp dryer.xls (Throttling processes of steam. Superheated steam, wet steam and saturated steam. Selection of a flash tank. From Tyler. Rev. 10.04.2017) 152. Stress_Young_Modulus_and_Thermal_Expansion_coefficients_of_steels.xls (Steel properties as a function of the temperature. Rev. 31.05.2016) 153. Tank sulfuric acid storage. API 6501998. (Spanish).xls (Calculation report for a sulfuric acid tank. Rev. 31.05.2016) 154. Tank venting according API 2000.xls (Determination of tank venting diameter, according API 2000 Rev. 26.09.2016)) 155. Valves. Pressure loss in valves with gas as a fluid. Normal and choked flow (SI).xls (Flow rate and pressure drop across valves with normal and choked flow. Rev. 22.10.2017) 156. Valves. Valves and fittings pressure drop coefficients.xls (Functions for valves: Ball, Butterfly, Knife, Globe, Pinch, Diaphragm, Plug, Check.xls Fittings: Y_strainer, enlargements and reductions. Rev. 26.04.2017) 157. Viscosity of gases according Sutherland.ods (Sutherland's formula. Dynamic viscosity of an ideal gas as a function of the temperature. Valid for temperatures 0 < T < 555 K, with an error due to pressure less than 10%, below 3.45MPa Rev. 15.02.2017) 158. Viscosity of oils as a function of temperature.xls (The viscosity of oils can be shown as straight lines in a LogNat Diagram This concept is applied to the case of Rimula 15W40 oil, where a paire of points "viscosity  temperature" are known. Rev. 26.09.2016) 159. Viscosity ratio of slurries.xls (Slurry viscosity ratio according Einstein, Thomas and Wellman. Rev. 26.09.2016) 160. Water_ hammer_damper_tank_Hydropack example.xls ( Selection of a water_ hammer_damper_tank according Hydropack. Rev. 31.01.2014) 161. Water_hammer_calculation_of gravitational_adduction.xls ( Waterhammer calculation for a gravitational line. Rev. 28.05.2016) 162. Water hammer. Method of characteristics. Example solved using Visual Basic and Finite Differences.xls ( An application for a simple case consisting in a reservoir, a horizontal pipe and a valve. The water hammer problem is solved by Finite Differences and also using Visual Basic. An application example is solved with input data from a Streeter example. Results of the solution by finite differences and V.B. are in agreement with the results from Streeter example. Rev. 19.06.2019) 163. Water_hammer_Method_of_Characteristics_Streeter_example_13_9.m ( Matlab application for a simple case consisting in a reservoir, a horizontal pipe and a valve. The water hammer problem is solved by Finite Differences and also using Visual Basic. An application example is solved with input data from a Streeter example. The problem is solved using Matlab. Results are in agreement with the results from Streeter example. Rev. 22.05.2019) 164. Water hammer. Method of characteristics. Equations.ods ( Derivation of equations and boundary conditions for a case of the water hammer example of Streeter exmaple 13.9 Rev. 19.05.2019) 165. Water hammer. Water and slurry hammer.xls ( Water hammer examples: Tyler. Water hammer in a carbon steel pipe Pehmco: Water hammer in a HDPE pipe Tsingua University: Slurry hammer in a HDPE PE80 pipe. Rev. 28.05.2016) Some Examples of Piping Tools ApplicationsAir and saturated water properties as a function of temperature [ºC]xls file with the use of air and saturated water functions Water properties (Vapor and liquid)A series of thermodynamic functions, from Lennart Delin and Johan Nygaard Senior Consultants, ÅFProcess Visiting address: Fleminggatan 7  Delivery: Box 8309, SE104 20 Stockholm Direct: +46 (0)10 505 12 78  Fax: +46 (0)10 505 27 57  Mobile: +46 (0)70 342 12 78 email: lennart.delin@afconsult.com  https://www.afconsult.com Mollier diagram file Address to download Steamdat information file for Steamdat Circular channelsOpen channels with circular section xls file for the flow of water in circular channels xls file for the flow of slurry in circular channels xls file for flow in circular, semicircular channels and rectangular channels. SlurriesSlurry properties xls file for the calculation of slurry properties. Settling velocity and drag coefficientSpherical particles settling velocity and drag coefficient xls file for the calculation of settling velocity Shperical particle drag coefficient" Application to a "sand trap" Pipe dimension and friction factorExterior and interior diameters, and thickness of different pipe materials. Determination of the friction factor 81. Pipe dimensions and friction factor functions.xls 82. Moody diagram.xls Radiation view factorsRadiation view factors for parallel oposite and perpendicular rectangles with a common adge, as a function of its geometric parameters. Applications of radiation view factors Application to the radiation interchange among the walls of a furnace Download of J.R. Howell view factors catalog You can contact me by writing to cjcruz[at]pipingtools.net. RECOMMENDED GOOD PRACTICE
The files are free of any virus.
As general good practice, it is recommended to check any type of file to be free of virus before using them.
The presented files contain Excel functions and it is known that Excel has some problems in recognizing
clean files. For this reason it is recommended that, once a file has been checked for viruses and has been
recognized as a clean file, to put it in a directory declared as a trusted directory.
To declare a directory or a file as a safe document, use the Excel trust Center.
This providence will avoid that under given circumstances Excel will erase the Visual Basic code.
DISCLAIMERThe author shall not be responsible for losses of any kind resulting from use of this program or of any documentation and can in no way provide compensation for any losses sustained including but not limited to any obligation, liability, right or remedy for tort nor any business expense, machine downtime or damage caused to the user by any deficiency, defect or error in the program or in any such documentation or any malfunction of the program or for any incidental or consequential losses, damages, or costs, however caused.


20112019 by cjc: cjcruz[at]pipingtools.net ,
webmaster basia: basia[at]alercerojo.net 