CoolProp for Google Sheets ✨

This Google Sheets add-on brings the power of the CoolProp thermophysical property library directly into your spreadsheets. Perform property lookups 🚀 for many pure fluids and mixtures using functions that call the CoolProp API hosted on a dedicated server.

Examples

Note: All units are SI (e.g., Kelvin for temperature, Pascals for pressure unless specified otherwise).

Find the saturation pressure of R134A at 20°C (293.15 K): 

=PropsSI("P", "T", 20 + 273.15, "Q", 1, "R134A")
Show More Examples

Find the specific heat (Cp) of a 50/50 by volume ethylene glycol/water mixture at 20°C and atmospheric pressure (101325 Pa): 

=PropsSI("C", "T", 20 + 273.15, "P", 101325, "INCOMP::MEG[0.5]")

Find the enthalpy of R454B (a mixture: 68.9% R32, 31.1% R1234yf by mass) at 50°C and 6 bar (6e5 Pa): 

=PropsSI("H", "T", 50 + 273.15, "P", 6e5, "HEOS::R32[0.689]&R1234yf[0.311]")

Find the critical point temperature of water:

=Props1SI("Tcrit", "Water")

Calculate the dew point temperature of humid air at 22°C, 70% relative humidity, and atmospheric pressure: 

=HAPropsSI("Tdp", "T", 22 + 273.15, "R", 0.7, "P", 101325)

Caveat Emptor

This add-on is great for quick calculations that are easily shared via google sheets. For huge datasets and performance critical applications we recommend using a local copy of CoolProp available via one of the many wrappers (python, Excel, etc.).

Resources & Documentation 📚

Support

For issues or questions related to the core CoolProp library, please refer to the official CoolProp resources:

For support specifically related to this Google Sheets Add-on, please contact: coolpropsheets@electricair.io