General DescriptionThe spread sheets presented here, include all functions required in each case. To produce an add-in 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 add-in function. In this case, the add-in 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]piping-tools.net Available tool-files for download1a. Air_hydrodynamic_drag_force.xls. (Derivation of the parametric equations for a sphere fired into still air, with consideration of the hydrodynamic drag force.System of equations for finite differences. Application to hit a desired point in x-y plane. Application to a parashute. Rev. 07.10.2020)1b. Air_Atlas_Copco_Original_Flow_rates.xls. (Transformation of a volume flow rate from FAD conditions to a Normal state conditions.FAD (Free Air Delivery) (f.a.d) is the actual quantity of compressed air converted back to the inlet conditions of the compressor. Rev. 15.12.2021)1c. Air_FAD_to_Normal_Function.xls. (Function to transform a volume flow rate from FAD conditions to a Normal state conditions.FAD (Free Air Delivery) (f.a.d) is the actual quantity of compressed air converted back to the inlet conditions of the compressor. Rev. 17.12.2021)1d. Air_dry_and_water_saturated_properties.xls. (Functions for dry air and saturated water Rev. 17.12.2021)2a. Air-dry and water-saturated properties.xls. (Water and air properties as a function of temperature. Rev. 15.02.2017)2b.Air-dry and water-saturated properties.ods. (Water and air properties as a function of temperature. Rev. 15.02.2017)3a. 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. 08.07.2021)3b. 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. 08.07.2021)4a. 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 functionof the heigth above sea level, according 1976 U.S. Standard Atmosphere. It includes also anapproximate method that can be applied for a range of heights 0 km.a.s.l. 4b. 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 functionof the heigth above sea level, according 1976 U.S. Standard Atmosphere. It includes also anapproximate method that can be applied for a range of heights 0 km.a.s.l. 5a.Average particle size determination d50 from gravimetric analysis. Mesh-opening.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)5b.Average particle size determination d50 from gravimetric analysis. Mesh-opening.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)6a.Bernoulli and piezometric line.xls.(Basic definitions and graphic.Rev. 01.04.2016)6b.Bernoulli and piezometric line.ods.(Basic definitions and graphic.Rev. 01.04.2016)7a.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)7b.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)8a.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 coefficientRev. 17.08.2018)8b.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 coefficientRev. 19.08.2018)9a.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)9b. odsChannels 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)10a.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 coefficientRev. 17.09.2018)10b.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 coefficientRev. 19.09.2018)11.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)12a. 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)12b. 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)13a. 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)13b. 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)14a.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)14b.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)15a.Combustion. Combustion. Enthalpies of gases of combustion.xls (Enthalpy of gases from Keenan and Kayes Gas Tables Rev. 19.08.2018)15b.Combustion. Combustion. Enthalpies of gases of combustion.ods (Enthalpy of gases from Keenan and Kayes Gas Tables Rev. 19.08.2018)16a. Combustion. Hess's Law and enthalpy of formation.xls (Lower heating values, Higher heating values, enthalpy of formation, difference betweeen HHV and LHVMethane, propane, hydrogen silfide. Rev. 20.08.2018)16b. Combustion. Hess's Law and enthalpy of formation.ods (Lower heating values, Higher heating values, enthalpy of formation, difference betweeen HHV and LHVMethane, propane, hydrogen silfide. Rev. 20.08.2018) 17a.Combustion. Mass composition input.xls (Four examples of combustion analysis with input data in mass composition. Coal, Oil, Wood. Rev. 21.08.2018)17b.Combustion. Mass composition input.ods (Four examples of combustion analysis with input data in mass composition. Coal, Oil, Wood. Rev. 21.08.2018)18a.xlsCombustion. Orsat analysis.xls (Five examples of Orsat analysis.Methane, Unknown hydrocarbon, coke gas. Rev. 21.08.2018)18b.xlsCombustion. Orsat analysis.ods (Five examples of Orsat analysis.Methane, Unknown hydrocarbon, coke gas. Rev. 21.08.2018)19.Combustion. Volume composition input.xls (Four examples of combustion analysis with input data in volume composition. Natural gas, Ethane, Octane. Rev. 27.12.2016)20.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)21.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)22.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 desirednitrogen concentration in the furnace.Rev. 08.08.2016)23.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)24.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)25.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)26.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)27.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 )28.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 andimpinging into a moving steel strip with a water film. Based on Prof. Martin Holger paper.Rev. 13.01.2018)29.Excel Functions. Part 1 (Eng).pps (Tutorial for Excel functions)Rev. 01.04.201630.Excel Functions. Part 2 (Eng).pps (Tutorial for Excel functions)Rev. 01.04.201631.Excel Functions. Part 3 (Eng).pps (Tutorial for Excel functions)Rev. 01.04.201632a.Expansion_loop.xls (This file derives the expansion loop equation an presents a calculation example. Spiraxsarco and Vitaulic references.Rev. 01.08.2018)32b.Expansion_loop.ods (This file derives the expansion loop equation an presents a calculation example. Spiraxsarco and Vitaulic referencesRev. 01.08.2018)33. 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 A-105.Rev. 06.12.2017)34. 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 untilfinally both tanks reaches the same level. The three ordinary differential equations system is solved with finite differences. Rev. 18.09.2020)35. 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)36.Funciones_Excel_(Power_ point_spanish). Parte_1.pps (Intrucciones para el uso de funciones Excel, Parte 1)37.Funciones_Excel_(Power_ point_spanish). Parte_2.pps (Intrucciones para el uso de funciones Excel, Parte 2)38.Funciones_Excel_(Power_ point_spanish). Parte_3.pps (Intrucciones para el uso de funciones Excel, Parte 3) 39. Functions. List of modules and functions for Excel VBA.xls (List of available Excel functions and application examples. 567 VBA functionsRev. 26.01.2022)40.Gas. Air-dry and water-saturated properties.xls (Visual basic functions for dry air at ambient pressure and saturated water . Rev. 31.01.2018)41.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)42.Gas. Enthalpies_Kennan and Kaye.xls (Enthalpy of gases for combustion calculations (Kennan and Kaye). Rev. 27.02.2018)43.Gas. Air Properties.xls (Visual basic functions for air properties. Rev. 26.02.2018)44.Gas. Octane properties.xls (Octane properties for combustion calculations. Rev. 27.02.2018)45.Gas. Propane_Butane_Saturation_Properties.xls (Saturated Propane and butane properties . Rev. 21.07.2021)46.Gas. Properties-VBA functions.xls (Visual Basic functions for gas properties. Rev. 27.02.2018)47.Gas. Tables.xls (Table with basic gas data. Rev. 27.02.2018)48.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 49.Gas. Wet air composition.xls (Wet air for a given absolute air humidity. Wet air composition and molecular mass. Rev. 04.09.2020)51.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)52.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)53.Gravitational discharge of water. Ground profile vs Piezometric elevaton.xls (Gravitational discharge through a pipe, for a given ground profile.Rev. 17.07.2018)54. 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)55. 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)56. 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)57.Fin_Efficiency_circular_fin_Matlab_code.docx. (Fin_Efficiency_circular_Matlab_code.docx Word file containing the Matlab code for the efficiency of a circular fin with rectangular section.Rev. 26.12.2022)57a.Heat transfer. Flow of oil in an underwater pipeline. Cengel example 8.3.xls (Heat loss from an underwater pipe. Steam condenser. Single-stream. Effectiveness of an heat echanger. NTURev. 21.04.2016)58. 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)59.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 surfaceby convection to the ambient and by radiation interchange with surrounding surfaces.Rev. 04.09.2020)60. 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 surfaceby convection to the ambient and by radiation interchange with a clear sky night.Rev. 04.08.2020)61. 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 surfaceby convection to the ambient. Mills example 2.1.Rev. 04.09.2020)62. 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)63.Heat_transfer_Pipes_ U-factors_Annular_fins.xls. (Heat transfer through pipes. U-factor referred to the inside pipe surface and th outside pipe surfsce. U-factor of finned pipes. Fin efficiency. Examples.Rev. 30.09.2020)64. Heat transfer. Steady-state conduction. Two-dimensional. Finite differences equations.xls. (Heat transfer by the finite differences method, for steady state systems, using the implicite andexplicite methods. Heat equation and Energy balance methods. Examples and derivation of equations from Incropera.Solutions with the matix inversion method and Gaus-Seidel iteration.Rev. 16.02.2019)65.Heat transfer. Transient conduction. Semi-Infinite solid with and without convection. Analytical solution. Underground water pipe.xls. (Transient conduction in a semi-infinite 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)66. 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 one-term solution is implemented with VBA functions to replace the use of the Heisler charts.Mills example 3.9Rev. 26.07.2019)67.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)68.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)69.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)70.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 temperaturessolved analytically in the spreadsheet.Rev. 26.07.2019)71. Heat transfer. Transient heat conduction equations.xls (Transient analytical solutions. Solutions using graphics. Finite difference explicite method for one-dimensional conduction.Rev. 18.02.2019)72. Heat transfer. Single-stream 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)73.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)74. Heat transfer. Thermal conductivity of insulations and refractories.xls (Celular, Fibrous and Granular types of insulations. Refractories insulations.Rev. 04.09.2020)75. 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 andheat 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.201778.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.201779. 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 water-vapor 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 Newton-Raphson method to solve a third grade equation. Application to solve the case of a metallic thin sphere submerged in water.Rev. 27.07.2022)83a. Math_Newton_Raphson_solution_of_a_two_Eqs_Syms_with_four_inputs.m (Use of the Newton-Raphson method to solve a two equations system . The method is applicable to two non linear equations.Rev. 07.10.2022)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 Log-Log , in a Log-Nat and in a Nat-Nat plot.xls (Straight line which passes through points A and B in a Log-Log graphic, in a Log-Nat graphic and in a Nat-Nat 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 Newton-Raphson method, in Excel and VBA.xls (Solution of a system of nonlinear equations using the Newton-Raphson method, in Excel and in Visual Basic..Rev. 23.10.2020)90. Math. Runge-Kutta 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. Runge-Kutta 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. Requiredis 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 "HR-value" 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.5-2003. 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.10M-1996.Rev. 22.05.2016)94.Mollier_diagram.xls (A Pressure-Enthalpy, 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
Download En 13480 3 .pdf | Added By Users 1 5l
2ff7e9595c
Comments