A Faster Workflow For Energy Model Calibration
Posted on: March 11, 2026
Anyone who has calibrated a building energy model for M&V or ASHRAE 14 knows that the real work begins after the first simulation run.
Calibration is rarely a one-and-done process. Instead, it is an iterative workflow where the model is run repeatedly while making small adjustments to assumptions, schedules, equipment efficiencies, or loads. After each run, the results are compared to measured utility data to determine whether the model is moving closer to reality.
In practice, this often means 20 to 30 simulation runs before the model begins to align with the measured data.
The frustrating part is not the modeling itself. It is the repetitive process of extracting results from the simulation output, organizing the monthly values, calculating the comparison metrics, and updating charts to see whether the model improved or got worse.
That repetitive process can consume a surprising amount of time during calibration.
The Iterative Nature of Calibration
A typical calibration cycle looks something like this:
- Run the energy model
- Extract monthly energy consumption from the output file
- Compare the model results to the measured utility bills
- Review the charts and calibration metrics
- Adjust model assumptions
- Run the model again
And repeat.
Each time the model is run, the modeler needs to quickly determine:
- Did the iteration improve the calibration?
- Did the model move closer to the utility data?
- Did a change make things worse?
When this process is repeated dozens of times, even small inefficiencies in the workflow start to add up.
Automating the Comparison Process
To streamline this process, we developed the Energy Model Calibration Toolkit, an Excel-based workflow that allows modelers to quickly import simulation results and immediately compare them to measured utility data.
The goal is simple: reduce the time spent extracting and organizing results so modelers can focus on improving the model.
After running the simulation, the workflow becomes very simple:
- Run the energy model
- Import the results from the output file
- Instantly view the updated comparison charts and metrics
- Adjust the model and run again
Updating the results takes three quick clicks to select and import the new output file for the next iteration.
That small step is still dramatically faster than manually digging through simulation reports and rebuilding the comparison each time.
Direct Import from Simulation Output
The toolkit imports monthly results directly from simulation output files.
For eQUEST, the spreadsheet reads the simulation output file and imports the monthly energy values automatically. The imported results include electricity, electric demand, gas, steam, and chilled water energy consumption.
For EnergyPlus, the tool imports the monthly electricity and gas consumption from the model output (you must enable the .mtr report)
Once the results are imported, the spreadsheet automatically updates the comparison tables and charts so the modeler can immediately evaluate the results.
Visualizing the Results
Each iteration updates the charts automatically so the modeler can quickly see how the model compares to the measured utility data.
Instead of digging through simulation reports, the charts provide a quick visual and numerical answer to the most important question during calibration:
Did the last model run move the results closer to the real building?
This immediate feedback becomes extremely valuable when performing many calibration iterations.
Generating Calibration Reports
Once the model has reached an acceptable level of calibration, the results can be exported to a formatted PDF report with a single click.
The report includes the comparison charts and can be generated with your company logo, making it easy to include the results in project documentation.
Why This Matters
The biggest benefit of this workflow is not that it performs calculations that could not be done manually.
The benefit is speed and efficiency.
During calibration, modelers may run the model dozens of times while testing different assumptions. Each iteration requires comparing the new results against the measured utility data.
By automating the extraction of results and the generation of charts, the calibration toolkit allows modelers to evaluate each iteration quickly and move to the next test without spending time reorganizing data.
Over the course of 20–30 (or 150) iterations, the time savings can be substantial.
Learn More
If you are interested in using this workflow, you can learn more about the toolkit and see a quick walkthrough of it importing from eQUEST and creating a report
For additional help with energy modeling or calibration projects, you can also explore our modeling support services here:
Bob Fassbender graduated from the University of Wisconsin - Madison with a degree in Chemical-Engineering. Following graduation, he spent 3 years working as a Marketing Engineer for Trane C.D.S. In the C.D.S. group, Bob developed and supported design and analysis software, primarily TRACE 700™. In addition to his development work, Bob also traveled around the country as a TRACE 700™ and System Analyzer™ instructor. Bob is also an experienced user with eQUEST energy modeling software. Today, Bob continues training and energy modeling as a LEED accredited professional (with a focus on LEED EA credit 1).