Spreadsheet Tool Development For Visualizing Building Performance And Simulation Data To Help Calibrating Models ✓ Most Recent

One of the most important challenges in calibrating a building energy model is to visualize and analyze a significant amount of timeseries data in a practical and meaningful way. The paper presents a spreadsheet tool under development that addresses this challenge. The tool is based on new features of Excel™ 2010 and later version that use efficient data filtering capabilities. The tool populates different worksheets that address specific calibration tasks such as analyzing time domain profile differences, selecting short periods to calibrate, comparing start-stop schedules on daily profiles and quantifying the fit of the model with statistical indicators. The paper will discuss the functionalities of the tool by presenting a case study of the calibration of an EnergyPlus model using 15-minute total electric consumption measurements.