Tools and standard reports for piping engineers
User developed Excel function, 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.
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. 27.03.2015)

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

3.
Average_particle_size_determination_d50_from_gravimetric_analysis_Mesh.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 propertiers.
Gravimetric composition of a flow resulting from the joint of two flows.
Rev. 20.11.2015)

5.
Bingham_slurries_pressure_drop_calculation.xls
(This file presents some calculation examples of Bingham fluids, from "Slurry Systems Handbook", Abulanga.
In some cases the examples are solved using the function Slurry_Friction_Factor_Bingham_Re_He.
Rev. 09.12.2015)

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 parameters in a new line are calculated based in the resulting pressure of the precedent line.
Rev. 02.04.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)

13.
Compresor_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. 31.01.2014)

17.
Cooling tower. Application_ Treybal.xls
(This file is an applications of the Merkel theory for cooling towers.
Some correction have been made, nomenclature reviewed and some literature added.
Still some explanations to be included.
Re. 08.11.2014)

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

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

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

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

22.
Dryer with air impinging jets.xls
(Design of a strip dryer with air impinging jets. Air pressurized in a fan, heat in an heat exchanger and
impinged into a moving steel strip.
This document is a beta version and it is intended to have a final version at the end of April 2015.
Until this date any comment will be carefully considered with a quick answer to the checker.
Also general comments will be welcome. After the given date, comments could also be considered..
Rev. 24.05.2015)

28.
Friction_and_singular_pressure_drop.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. 03.08.2014)

35a.
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. 28/01/2016)

40.
Heat transfer. Heat loss from a pipe in an indoor location (This file is in working).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.
This file if in working. There is some difference between two calculation types. A correction is required.
Rev. 25.01.2016)

53.
Manning_s_coefficient.xls
(Manning`s coefficient as a function of pipe diameter, absolute rugosity and Reynolds number.
Rev. 31.01.2014)

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

55.
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. 31.01.2014)

56.
Mollier_diagram.xls
(A Pressure-Enthalpy, mollier type diagram, is being built by means of Steamdat functions.
Rev. 31.01.2014)

57.
Moody_diagram.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. 31.01.2014)

58.
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. 10.02.2014)

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

61.
Pipe_dimensions_and_friction_factor.xls
(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. 31.01.2014)

62.
Pipe_maximum_alowable_pressures_for_A53_A106_and_API_5L.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.
Rev. 31.01.2014)

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

64.
Pipe_Wall_Thickness_Calculation_according_ASME_B31_3.xls
(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. 31.01.2014)

65.
Pressure. Pressure loss in an isothermic 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. 12.06.2015)

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

67.
Pressure. Pressure and temperature ratings for steel pipe flanges and flanged fittings. ANSI B16.5.xls
(Carbon Steel Flanges - Pressure and Temperature Ratings - Group 1.1
Maximum temperature and pressure ratings of flanges conforming dimensions
ASME B16.5 and materials specification ASTM A-105
Maximum temperature and pressure ratings of flanges conforming dimensions
ASME B16.5 Pipe Flanges and Flanged Fittings - and materials specification
ASTM A-105 Specification for Carbon Steel Forgings for Piping Applications -
temperature inCelcius degrees and pressure in bar man.
Rev. 12.06.2015)

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

71.
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. 12.06.2015)

72.
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. 23.02.2014)

73.
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. 31.01.2014)

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

85.
Pumps_Slurry_Selection_Typical_Warman.xls
(A type slurries, according Weir clasification:
Weight concentration 0 % <= Cw <= 40 % and
average particle size 50 microns < d50 < 300 microns
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.
Rev.- 31.01.2014)

86.
Pump. TDH , NPSH, Power_for water.xls
(Pumpinh system between two water tanks.
Results arecalculated in a spreadsheet and by means of "user defined Excel functions"
Pump selection using a free pump selection program).
Ref. 09.09.2014)

92.
Settling_velocity_of_spherical_particles.xls
(Settling velocity of spherical particles as function of particle diameter,
solids density, liquid density and liquid absolute viscosity.
Function Particle_Settling_velocity_d_rs_rL_mu(d, rs,rL,mu).
Function Particle drag coefficient CD as function of particle Reynolds number.
Function Particle_Drag_Coefficient_CD_Re.
Rev. 31.01.2014)

98.
Slurry_settling_velocity_according_JRI.xls
(JRI recommend thre types of equations to calculated deposition velocities,
according the particle average size and pipe diameter.
Rev. 23.01.2016)

100.
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. 31.01.2014)

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

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

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

113.
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. 31.01.2014)

115.
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. 11.11.2015)

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.

DISCLAIMER

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.