USTChEX Documentation
USTChEX Documentation
This documentation describes the USTCHEX function suite for numerical methods and thermodynamic calculations in Excel. The package integrates core numerical tools including nonlinear equation solvers, ordinary differential equation (ODE) solvers, and numerical integration and interpolation routines; with thermodynamic functions based on cubic equations of state.
Note on Excel Compatibility
USTCHEX uses dynamic array formulas that rely on spill behavior available in newer versions of Microsoft Excel. In Excel 2019 and earlier, outputs will not automatically spill into adjacent cells. Users may need to manually select a sufficient output range before evaluating the function to properly display results.
Last edited: April 16, 2025