(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)

# Author: cjc

## 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 Derik Marshall Rev. 30.11.2018)

Pipes. Maximum span between pipe supports for a given maximum bending stress

## 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)

Moody diagram. Hagen Poiseuille, Colebrook and Churchill equations_Nikuradse data

## 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)

## 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.9 Rev. 26.07.2019)

## 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)

## 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)

## 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)

Water hammer. Method of characteristics. Example solved using Visual Basic and Finite Differences

## Water_hammer_calculation_of gravitational_adduction.xls

( Waterhammer calculation for a gravitational line. Rev. 28.05.2016)

## Water_ hammer_damper_tank_Hydropack example.xls

( Selection of a water_ hammer_damper_tank according Hydropack. Rev. 31.01.2014)