A Libre Knowledge Page (Rev.14.01.2017)

The intention of this page is to provide Free / Open Source files for piping engineers
It consists of tools, standard reports and user developed VBA Excel functions, which
are included in each application
This version is for Excel 2003

General Description

The spread sheets presented here, include all Excel functions required in each case. To produce an Excel add-in from an Excel function, save the Excel function as a complement. Prior to converting an Excel function to an Add-in, it is convenient to eliminate all sheets that do not contain information required (to be read) by the function. At least one sheet needs to be maintained, and it can be an empty one. 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 Excel books are opened and both contain the same function. Also it could happen that an Excel 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 download

1. 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. 13.04.2016)

2 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. 26.09.2016)

3. AAverage particle size determination d50 from gravimetric analysis. Mesh-opening.xls. Rev. 22.09.2013
(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. 08.08.2016)

4. Bernoulli and piezometric line.xls.
(Basic definitions and graphic. Rev. 01.04.2016)

5. Bingham slurries pressure drop calculation.xls
(This file presents some calculation examples of Bingham fluids, from "Slurry Systems Handbook", Abulnaga. In some cases the examples are solved using the function Slurry_Friction_Factor_Bingham_Re_He. Rev. 26.09.2016)

6. 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. 21.04.2015)

7. Channels 0. Channels and pipes with frictional and singular pressure drop.xls
(Channel 0. Pressure loss calculation routines for water and slurry. Weir method for slurry pump calculation, for A-type fluids (Weir definition). Pulp flow in channels. Singular pressure loss for valves and fittings. Rev. 18.03.2015)

8. Channels 1. Channel functions resume and applications.xls
(Channel 1. Resume of VBA functions and applications for circular, semicircular and rectangular channels. Normal and critical cases. Deductions and checking of equations. Rev. 18.03.2015)

9. Channels 2. Circular channel. Array output, constant Manning coefficient.xls
(Channel 2. Circular channels. Outputs in array format. Rev. 18.03.2015)

10. Channels 3. Three channel types. Three sizing options. Constant Manning coefficient.xls
(Channel 3. Pulp flow in channels. Constant Manning's coefficient. Three size options presentation. Manning's coefficient as a function of friction factor and hydraulic radius. Rev. 18.03.2015)

11. Channels 4. Circular channel with. Constant Manning coefficient.xls
(Channel 4. Circular channel for pulp. Constant manning's coefficient Rev. 18.03.2015)

12. Channels 5. Three channel types. Array & single functions. Variable Manning coefficient.xls
(Channel 5. Circular, semicircular and rectangular channels for pulp. Array and single functions. Variable Manning's coefficient. Rev. 18.03.2015)

13. Combustion. Chemical reactions.xls
(Four examples of combustion analysis. Equations for stoichiometric combustion and combustion with excess air. Dew point temperature. Rev. 04.12.2016)

14. Combustion. Mass composition input.xls
(Four examples of combustion analysis with input data in mass composition. Coal, Oil, Wood. Rev. 04.12.2016)

15. Combustion. Orsat analysis.xls
(Five examples of Orsat analysis.Methane, Unknown hydrocarbon, coke gas. Rev. 04.12.2016)

16. Combustion. Volume composition input.xls
(Four examples of combustion analysis with input data in volume composition. Natural gas, Ethane, Octane. Rev. 04.12.2016)

17. 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)

18. 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)

19. 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)

20. 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)

21. 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.11.2014)

22. 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)

23. Coupled water tanks. Stabilization time, oscilation amplitud.xls
(This file presents the solution of a system of ordinary differential equations, resulting from the water movement between two tanks. The problem is solved using a finite differences method. Rev. 08.08.2016)

24. 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 in work)

25. 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. Rev. 05.06.2016)

26. Excel Functions. Part 1 (Eng).pps
(Tutorial for Excel functions) Rev. 01.04.2016)

27. Excel Functions. Part 2 (Eng).pps
(Tutorial for Excel functions)

28. Excel Functions. Part 3 (Eng).pps
(Tutorial for Excel functions)

29. Expansion_loop.xls
(This file derives the expansion loop equation an presents a calculation example. Rev. 04.12.2016)

30. 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. 08.08.2016)

31. 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)

32. Funciones_Excel_(Power_ point_spanish). Parte_1.pps
(Intrucciones para el uso de funciones Excel, Parte 1)

33. Funciones_Excel_(Power_ point_spanish). Parte_2.pps
(Intrucciones para el uso de funciones Excel, Parte 2)

34. Funciones_Excel_(Power_ point_spanish). Parte_3.pps
(Intrucciones para el uso de funciones Excel, Parte 3)

35. Gravitational adduction Water Hammer.xls
(Gravitational discharge of slurry with the option of three pipe sizes, under consideration of three flow rates.. Rev. 08.08.2016)

36. 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)

37. Gravitational discharge of water. Ground profile vs Piezometric elevaton.xls
(Gravitational discharge through a pipe, for a given ground profile. Rev. 08.08.2016)

38. 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. 08.08.2016)

39. 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. 22/04/2016)

40. Heat transfer. Finite differences for a steady state system. Implicite and explicite methods. Incropera.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 Gaus-Seidel iteration. Rev. 08.08.2016)

41. Heat transfer. Finned tubes. Heat flow_ U factor_ Fin efficiency.xls
(U-factor and heat flow of finned pipes. Fin efficiency according Schneider. Incropera and Schneider examples. Rev. 17.02.2015)

42. Heat transfer. Fins. Schneider-Mills-Incropera_De Witt(sp).xls
(Circular and rectangular fins. Fin efficiency according Schneider. Incropera, Schneider and Mills examples. Rev. 17.02.2015)

43. 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. NTU Rev. 21.04.2016)

44. 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. 08.08.2016)

45. 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. 09.06.2016)

46. 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. 09.06.2016)

47. Heat transfer. Single-stream echanger with constant surface temperature. Mills expl. 4.1.xls
(Outlet temperature of an heat exchanger with constant surface temperature. Example of laminar flow of oil. Rev. 08.08.2016)

48. 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)

49. 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)

50. Heat transfer. Thermal conductivity of insulations. Celular_Fibrous_ Granular types.xls
Rev. 08.08.2016)

51. 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. 28.03.2015)

52. Heat transfer. U factor for resistances in series and in parallel. II.xls
(Global heat transfer coefficients "U" for several pipe arrangements. U factors referred to the inside and outside pipe surface. Several VBA functions Rev. 28.03.2015)

53. 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)

54. Ideal gas law. Application to air.xls
(Application of ideal gas law to determine air density Rev. 26.09.2016

55. Isenthalpic throttling process.xls
(Valve throttling process. Application examples for steam valves. Steamdat functions are applied and are included. Rev. 08.08.2016)

56. 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)

57. Link to some free download & freeware thermodynamic and hydraulic files.xls
(Information on links for hydraulic and thermodynamic free information. Rev. 31.01.2014)

58. Moody diagram. Hagen Poiseuille, Colebrook and Churchill equations_Nikuradse data.xls
(Moody diagram. Equations for friction factors with V.B. functions. Rev. 26.07.2016)

59. Math. Least squares method. Linear regresion, and second, third and fourth grades parabolas regresions.xls
(Regresion using the least squares method, for a stright line and parabolas of second, third and four grade. Rev. 22.05.2016)

60. 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)

61. 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)

62. 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)

63. 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)

64. 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. 04.12.2016)

65. 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)

66. 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)

67. Mollier_diagram.xls
(A Pressure-Enthalpy, mollier type diagram, built by means of Steamdat functions. Rev. 04.04.2016)

68. 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. 28.07.2016)

69. 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)

70. 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)

71. 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 Darcy-Weisbach equation and Manning's coefficient. Rev. 19.04.2016)

72 Pipes. Flow rate and pressure loss equations.xls
(Manning, Hazen Williams, Darcy-Weisbach, friction factors, Colebrook. Rev. 28.07.2016)

73. Pipes. Maximum span between pipe supports for a given maximum bending stress.xls
(Determination of the length between pipe supports by the method of the "Maximum Bending Stress". Rev. 04.07.2016)

74. Pipes. Pressure and temperature ratings for carbon steel flanges of material groups 1.1 and 1.2.xls.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 A-105 Rev. 04.07.2016)

75. Pipes. Pressure and wall thickness of a straight pipe. ASME B31.1 and B31.3.xls
(Maximum allowable pressure and temperature ratings according: ASME B31.1-2002 Power piping and ASME B31.3 (2008) Process piping, materials grade B: A53, A106, API 5L, pipes with plane ends. Rev. 03.07.2016)

76. Pressure. Pressure loss in a steam pipe.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. An example from the Handbook of Mechanical Engineering Calculations, by Tyler, G. Hicks. The example presents two design possibilities for the main pipe from the Boiler to a delivery point. a) The steam supply pressure is reduced by means of a Pressure Reducing Valve (PRV). b) The required pressure drop is caused by the friction in the pipe itself. An attemperator is added. A VBA function is used to determine the average friction factor for the case of a pipe with known steam mass flow rate, inlet and outlet pressure and temperature and data of a carbon steel pipe. Rev. 10.06.2016)

77. 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. 07.07.2016)

78. Pipes. Wall thickness calculation according ASME B31.3.xls
(Pipe wall thickness for carbon steel pipes according ASME B31.3. Rev. 03.07.2016)

79. 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 A-105 Rev. 12.06.2015)

80. Pressure rating for PVC pipes .xls
(Pressure rating for industrial PVC, schedules 40, 80 and 120. Rev. 26.09.2016)

81. Propane_Butane_Saturation_Properties.xls
(Propane and butane saturation properties, gas and liquids. Rev. 07.06.2016)

82. Psychrometric charts.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. 03.04.2016)

83. Psychrometric charts with process shwon 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. 22.05.2016)

84. 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. 11.04.2016)

85. 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. 30.03.2016)

86. 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)

87. Pump. Demineralized water(Spanish).xls
(Standard type calculation for water. Rev. 31.01.2014)

88. Pump. Detention time of a pump impulsion system.xls
(The routine calculates the time interval "t", from the de-energization 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)

89. Pumps_Froth_Selection_Warman.xls
(A froth pump calculation according a Warman' reference. Ref. 16.06.2016)

90. 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)

91. Pump. Lubricating oil(Spanish).xls
(Standard type calculation for lubticating oil circuit. Rev. 31.01.2014)

92. 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)

93. Pump. Reactives(Spanish).xls
(Standard type calculation. Rev. 31.01.2014)

94. Pump. Slurry froth.Three diameter options (Rev. 24.10.2013).xls
(Pump selection for Slurry with froth, according Weir. Rev. 31.01.2014)

95. Pump. Slurry lime_Loop(Spanish).xls
(Standard type calculation. Rev. 31.01.2014)

96. Pumps_Slurry_Selection_Typical_Warman.xls
(Example of Warman Slurry Pumping Handbook Australasian version, Feb. 2000 Rev. 14.06.2016)

97. 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)

98. Pump. Water_circuit system_Primary_Grinding_dust_suppression.xls
(Standard type calculation for a water net. Rev. 12.06.2016)

9. 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)

100. Relationships_between_Cv_Kv_and_C.xls
(Determinaqtion of Darcy-Weisbach "K" factor as a function of "Cv" value from valves. Rev. 22.05.2016)

101. Sand_trap.xls
(Determination of the basic sand trap dimensions using a VBA function . Rev. 31.01.2014)

102. Saturated_water_and_dry_air_properties.xls.
(Water and air properties as a function of temperature. Rev. 05.06.2016)

103. 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)

104. Shperical_particle_drag_coefficient.xls
(Shperical particle drag coefficient as a function of particle Reynolds number. Rev. 05.06.2016)

105. Slurry. Basic calculations. Examples 1 to 13_Equations and Figures.xls
(13 examples from chapter 11 of Slurry Systems Handbook. Rev. 03.06.2016)

106. Slurry pressure drop calculations. Examples 5.1 to 5.4 _Equations.xls
(4 examples from chapter 5 of Slurry Systems Handbook. Rev. 03.06.2016)

107. Slurry. Property equations and functions.xls
(Relations between slury concentrations, densities and specific weights. Rev. 03.06.2016)

108. 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)

109. Slurry. Settling velocity according JRI.xls
(JRI recommend thre types of equations to calculated limit deposition velocities, according the particle average size and pipe diameter. Rev. 02.06.2016)

110. Sound_pressure_level.xls
(Calculation of SPL, based on octave band test data. Rev. 02.06.2016)

111. Steamdat_97. Applications.xls
(Steamdat function used to calculate a steam turbine stage and pressure reducing valve "PRV" with desuperheating. Rev. 13.05.2015)

112. Steam. Steam flow required in a pulp dryer.xls
(Determination of steam requirements for a vapor driven slurry dryer. Steam and condensate pipes are defined. Rev. 01.06.2016)

113. Link_to_get_the_Steamdat_functions.xls
(The file is available and free to use at http://www.afconsult.com ┼F's website. Rev. 01.06.2016)

114. 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. 26.09.2016)

115. Stress_Young_Modulus_and_Thermal_Expansion_coefficients_of_steels.xls
(Steel properties as a function of the temperature. Rev. 31.05.2016)

116. Tailings deposition_by Gordon McPhail_2008.pdf
(Prediction of the beach profile of high density thickened tailings from rheological and small scale trial deposition data. By Gordon McPhail, from Metago Environmental Engineers. Rev. 13.10.2014)

117. Tank sulfuric acid storage. API 650-1998. (Spanish).xls
(Calculation report for a sulfuric acid tank. Rev. 31.05.2016)

118. Tank venting according API 2000.xls
(Determination of tank venting diameter, according API 2000 Rev. 26.09.2016))

119. 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.05.2016)

120. 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.09.2016)

121 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. 26.09.2016)

122. Viscosity of oils as a function of temperature.xls
(The viscosity of oils can be shown as straight lines in a Log-Nat Diagram This concept is applied to the case of Rimula 15W-40 oil, where a paire of points "viscosity - temperature" are known. Rev. 26.09.2016)

123. Viscosity ratio of slurries.xls
(Slurry viscosity ratio according Einstein, Thomas and Wellman. Rev. 26.09.2016)

124. 125. Water_ hammer_damper_tank_Hydropack example.xls
( Selection of a water_ hammer_damper_tank according Hydropack. Rev. 31.01.2014)

126. Water_hammer_calculation_of gravitational_adduction.xls
( Waterhammer calculation for a gravitational line. Rev. 28.05.2016)

127. Water hammer. Method of characteristics. Equations, Boundary conditions and Initial conditions.xls
( The Method of Characteristics transform the system of Partial Differential Equations (PDE) in a system of Ordinary Differential Equations (ODE). The system of ODE can be solved numerically by different mathematical methods . The Methods of Characteristics is used here. The application is based on a Streeter example. Rev. 05.06.2016)

128. 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. 05.06.2016)

129. Water hammer. Method of characteristics. Ref. 1.pdf
(Rev. 27.10.2015)

130. Water hammer. Method of characteristics. Ref. 2.pdf
(Rev. 27.10.2015)

131. Water hammer. Method of characteristics. Ref. 3.pdf
(Rev. 27.10.2015)

132. 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 Applications

Air 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, ┼F-Process
Visiting address: Fleminggatan 7 | Delivery: Box 8309, SE-104 20 Stockholm
Direct: +46 (0)10 505 12á78 | Fax: +46 (0)10 505á 27 57 | Mobile: +46 (0)70 342 12 78
e-mail:álennart.delin@afconsult.comá| http://www.afconsult.com
Mollier diagram file
Address to download Steamdat
information file for Steamdat

Circular channels

Open 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.


Slurry properties
xls file for the calculation of slurry properties.

Settling velocity and drag coefficient

Spherical 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 factor

Exterior 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 factors

Radiation 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

I welcome any comments or you can contact me by writing to cjcruz[at]piping-tools.net.

Widget is loading comments...


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.


The 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.




   2011-2016    by cjc: cjcruz[at]piping-tools.net ,   webmaster basia: basia[at]alercerojo.net
   Creative Commons License   This work is published under a license Creative Commons.