Paper Conference

Proceedings of ASHRAE/IBPSA-USA Building Simulation Conference


Spreadsheet Tool Development for Visualizing Building Performance and Simulation Data to Help Calibrating Models

Simon Sansregret, Karine Lavigne
Hydro-Québec Research Institute, Shawinigan, Qc, Canada

Abstract: 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.
Pages: 187 - 194