Engineering functions. Directly in Excel.
A Microsoft Excel Add-In providing an extensive library of thermodynamic and engineering functions, unit conversion and practical engineering procedures.
Reliable properties. Directly in Excel.
Thermodynamic and transport properties for fluids and mixtures used throughout energy, process, refrigeration and utility industries.
Water & Steam
IAPWS-95 and industrial IAPWS-IF97.
Natural Gas
AGA8 and GERG-2008 based ISO formulations.
Gas & Air
Generic mixtures, humid air and combustion gases.
Working Fluids
Refrigerants, absorption fluids and heat-transfer fluids.
- Seawater libraries for cooling and desalination applications
- Refrigerants: NH₃, R22, R32, R123, R125, R134a, R152a, R290, R1234yf and R1234zeE
- Aqueous lithium bromide, water-ammonia mixtures and Therminol VP-1
- Properties include density, enthalpy, entropy, specific volume, heat capacity, viscosity, thermal conductivity, speed of sound, isentropic exponent, saturation conditions and vapour fraction
From properties to practical calculations.
Higher-level functions combine property calculations into engineering procedures that can be incorporated directly into Excel models.
- Humid air: relative humidity, wet-bulb temperature and absolute humidity
- Air composition using ISO 2533, ASME PTC 4.4, DIN 1871 and ISO 6976
- Natural gas combustion with optional water or steam injection
- Combustion gas properties according to VDI 4670-1 and ASME PTC 4.4
- High-temperature dissociation option in the VDI combustion-gas library
Standard-based flow engineering.
Differential-pressure flow calculations for primary devices in circular pipes running full.
- ISO 5167: orifice plates, nozzles, Venturi nozzles, Venturi tubes and cone meters
- ASME PTC 19.5: orifices, nozzles and Venturi tubes
- VDI 2040 / 2041 including segment orifices and quarter-circle nozzles
- Mass flow plus underlying coefficients, Reynolds number, expansibility, beta ratio, expansion, pressure loss and validity checks
Engineering tools for a renewable future.
A Solar Library implementing the solar position algorithm according to NREL.
- Solar azimuth and elevation
- Angle of incidence on a specified surface
- Sunrise, solar transit and sunset