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

EnergyPlusVn-n-n\PreProcess\HVACCurveFitTool\CurveFitTool.xlsm



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