A Libre Knowledge Page (Rev.23.07.2019)
The intention of this page is to provide Free / Open Source files for piping engineers
It consists of tools, standard reports and user developed functions (UDF), which are included in each application.
Versions for Excel (*.xls) are for the 2003 version. Few files are *.xlsm
For people who were used to the old site and prefer the old format click here
The 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.
Click on the desired category to see the available functions
Some Examples of Piping Tools Applications
– Air and saturated water properties as a function of temperature [ºC]
– 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: firstname.lastname@example.org | https://www.afconsult.com
– Circular channels
Open channels with circular section
xls file for the calculation of slurry properties.
– Settling velocity and drag coefficient
– Pipe dimension and friction factor
– Radiation view factors
Radiation view factors for parallel oposite and perpendicular rectangles with a common adge,
as a function of its geometric parameters.
I welcome any comments or you can contact me by writing to cjcruz[at]piping-tools.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.
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.