Knowledgebase: Downloads > Utilities
Curve-fit Spreadsheet Examples
Posted by Michael J. Witte on 23 January 2014 05:47 PM

The two attached files are example spreadsheets which show how to use Excel to curve-fit a biquadratic curve.  These can be adapted to other curve types.  A more complete curve-fit tool for DX cooling and heating coils is included in the EnergyPlus install folder in


 example curve fit with linest.xls (20.00 KB)
 excel biqudratic fit.xls (21.00 KB)
(7 vote(s))
Not helpful