This repository is a Python package for expediting unit energy savings calculations from DEER prototypes.
Created by: Solaris Technical LLC
Using the simulation results generated by DEER-Prototype-EnergyPlus, this tool simplifies the post-processing method used to generate savings per the Script folder in the DEER-Prototypes-EnergyPlus repository. This method includes similar SQL queries and the lookup tables (i.e. building weights, norm units) to calculate final energy savings.
This tool is a package which contains a simple graphic user interface, Python script, and SQL queries which calculate the final energy savings based on the energy usage file (simdata.csv) produced by result2.py, a Solaris script currently used in place of result.py found in the Scripts folder above. See the following process flow for more details:
To run the tool, download the GitHub repository and collect the necessary inputs information andfiles as stated below.
Additionally, Python or Anaconda (a Python distribution platform) must be installed to run the tool.
This image of the user interface shows the required information and files necessary to use the post-processing tool.
The tool requires the following manual inputs based on the measure information:
- Measure Name: The name/number of the measure package in the format SWXX0XX.
- Measure Type: The type of measure being processed based on the measure end-use. Dropdown options are Cooling Capacity, PTAC/PTHP, Ceiling Insulation, Wall Insulation, Refrigerator/Freezer, and Whole House Fan.
- Sector: The measure pacakge sector. Dropdown options are Residential and Commercial.
- Normalizing Unit: The normalizing unit which will be used to normalize the measure savings. Dropdown options are Cap-Tons, Area-ft2-BA, Area-ft2, Household, kWhreduced.
The tool requires the following input files:
- Measure Definition: Csv file created per eTRM Offering ID table. Name of file must be MeasDef_{Measure Name}.csv
- Simdata: Csv file generated by result2.py. Name of file must be simdata_{Measure Name}.csv
Refer to the look up table NormUnits.csv for the built-in measure options. If the measure does not meet the options listed, the normalizing unit will need to be manually added to the simdata.csv file before post-processing.
For example, if Cooling Capacity is chosen for the measure type, simdata.csv must include a column named Cooling Capacity with values listed for every row for the script to process the end-uses correctly. This specific measure type will apply to all HVAC measures besides PTAC/PTHP and Whole House Fan.
The image below shows example user interface entries for SWHC012, a commercial HVAC measure.
The tool runs the simdata file into the post-processing script and the graphic user interface shows the user inputs and queries successfully executed.
A pop-up window will appear when the tool is finished.
The tool output is an energy savings file called energysavings_{Measure Name}.csv.