You can load dataset files of the following extension and formats to Results Viewer:
.eso EnergyPlus simulation results file
.htm/.html EnergyPlus HTML summary results file
.epw EnergyPlus format hourly weather file
.csv spreadsheet file
.drb Results Viewer binary dataset file from a previous session
(.drs Results Viewer binary session file saved from a previous session. Not a dataset format, but included here for completeness.)
The processes involved with working with these file formats are described below.
Tip: Each You can load multiple datasets to Results Viewer to allow data comparison. This applies to .eso, .epw, .csv and .drb dataset files.
.eso is the main EnergyPlus detailed simulation results file format supported by DesignBuilder. These files can be loaded into Results Viewer using its Open eso / dataset toolbar command. They can also be loaded directly into Results Viewer by double-clicking on an eso file in Windows File Explorer if the .eso extension has previously been associated with Results Viewer.
.eso files from the previous simulation can typically be found in DesignBuilder's EnergyPlus folder.
When you load simulation results from the DesignBuilder Simulation screen using either the View EnergyPlus Results toolbar / menu command or from the Simulation Manager using the View results in DesignBuilder Results Viewer toolbar command then an eso file from the simulation will be loaded along with the corresponding html summary results file.
EnergyPlus generates a summary results file in html format. These can be attached to the current dataset from the Open Eso / Dataset toolbar / menu command.
When you load simulation results from the DesignBuilder Simulation screen using either the View EnergyPlus Results toolbar / menu command or from the Simulation Manager using the View results in DesignBuilder Results Viewer toolbar command then an htm summary results file from the simulation will be loaded along with the corresponding eso detailed results file.
EnergyPlus format hourly weather files can be loaded as new datasets to Results Viewer using the Open Eso / Dataset toolbar / menu command. They can also be loaded directly into Results Viewer by double-clicking on an epw file in Windows File Explorer if the .epw extension has previously been associated with Results Viewer.
Results Viewer can load csv files of specific formats as new datasets. The csv formats that can be loaded are described below. Note that if you would like to load a csv file with different format to those described below it will usually be possible to modify the csv file to conform with one of the supported formats.
This is the format exported using the Save grid to CSV file toolbar / menu command.
These files consist of a dataset header listing the datasets involved followed by a blank line, followed by 2 rows with a column per selected report which define the data in the rows below. Sections A, B and C in the screenshots below illustrate the overall layout.
In a spreadsheet:
The same data in a text editor:
The format is described in more detail below.
Dataset headers (Section A)
Multiple rows identifying the original datasets relating to the data columns as loaded into the session from which the export file was created. Each dataset label is prefixed by an index number.
Empty line
This is represented by a CR/LF only.
Column headers for exported data (2 rows)
i) Row 1: column identifiers
First column is always Date/Time. This format is custom and specific to Results Viewer.
Other headers are prefixed with dataset identifier in square brackets, and units in suffix in parentheses.
ii) Second row
Area of column data. Row starts with delimiter since Date/Time has no area.
Data rows
Each row starts with the Date/time, followed by delimited values for each variable.
Note: The original dataset names are discarded on import, since they have no meaning. Instead, all columns will be assigned to a new dataset with the name of the CSV file.
This is the format exported when viewing results on the main DesignBuilder screen using the Grid format. It is accessed by setting the Show as Display option to 2-Grid.
These files consist of a header with 2 rows which define the data in the rows below. Subsequent rows contain the data itself. Sections A and B in the screenshots below illustrate the overall layout.
Note: In this format, all values are enclosed in quotes.
In a spreadsheet:
The same data in a text editor:
Line 1 - Column headers (Section A)
Date/Time first, followed by Data column names.
Note that the Date/Time format is local time.
Line 2 – Units (Section A)
The Date/Time column is left blank and so this line starts with a delimiter.
Line 3 to end of file – Data (Section B)
The first column is always Date/Time. This is followed by the data , one item per column to align with the data column headers.
This format is the same as DesignBuilder Grid Results Export Format above, but prefixed with a header. The header includes a version number and an interval value to define the meaning of the data. Multiple intervals are not allowed to be mixed within a single CSV file.
Version followed by a numeric value for file format version. (Defines remaining header fields)
Interval which can be one of:
TimeStep,
Hourly,
Daily,
Monthly,
Annual,
RunPeriod
Example data:
Version:1.0,Interval:Annual
"Date/Time","Mech Vent + Nat Vent + Infiltration","External Infiltration”
,"ac/h","kWh”
"01/01/2002","1.038702","-12397.66"
.drb files are a binary representation of the data format used internally by Results Viewer. A drb file represents the data in a single dataset. They can be saved and loaded more quickly than eso and csv files and are used internally within drs session files, one drb file per dataset in the session.
These files can be saved by using the File > Copy Dataset to File menu command.