Water Heaters History: DEER Water Heater Calculator

File Start Date End Date Date posted Notes
DEER_Wate_WEgUKmu.zip 2023 Jan 1 2022 Feb 1

v5.0 of the DEER Water Heater Calculator is intended for the DEER2023 Update. Enhancements include:

  • Updated residential hot water profiles using CBECC-Res 2022 (RV) 
  • Updated HPWH performance profiles
  • Updated water-heater sizing methodology and TechIDs using recent AHRI product data
  • A macro was also added to the workbook to output 8760 load shapes
DEER-WaterHeater-Calculator-v4.2a.xlsm 2021 Jan 1 2022 Dec 31 2021 Sep 1

The DWHC v.4.2a is made available as an update for the DWHC v.4.2 EnergyImpactID = NG-WtrHt-LrgInst-Gas-gte200kBtuhlt2G-0p96Et. It is not intended to be used for other measures. Version v.4.2 changes the method for determining the normalizing unit (NormUnit) for the unit energy savings. Rather than use the input capacity of the measure case TechnologyID (as v.4.2 does), v.4.2a uses a value equal to the capacity necessary to satisfy the building's peak hot water load.
DEER-WaterHeater-Calculator-v5.1_2022-08-22.xlsm 2023 Jan 1 2022 Aug 29 v5.1 in which the normalizing unit (NormUnit) was changed from Cap-kBTUh (to reflect the input capacity of the water heater) to CapOut-kBtuh (to reflect the output capacity of the water heater). It was necessary to do this to align the water heater equipment capacities for fuel substitution measures. No other changes were made to the workbook.
DEER_WaterHeater_Package_v4.2.zip 2021 Jan 1 2022 Dec 31 2020 Jan 24

An updated water heater calculator package is available here, the package contains:

  • The water heater baseline and measure cases were updated using the DEER-CEC-AHRI-WH-binning-TechID-v4.2.xlsx workbook.
  • The water heater calculator, DEER-WaterHeater-Calculator-v4.2.xlsm, was updated to generate new measures using the updated baseline and measure cases
  • The water heater calculator documentation was updated and is titled DEER-WaterHeater-Documentation-v4.2.pdf.

The DEER water heater calculator v.4.2 was revised from v.4.1 and the corrected EnergyImpact records (784 out of 62,145 water heater records) were uploaded to the PEAR and ExAnte databases. The erroneous records have also been removed from both databases and are no longer available for use.
DEER-WaterHeater-Calculator-v5.0_2022-01-24.xlsm 2023 Jan 1 2022 Jan 24

Standalone Excel file of the DEER Water Heater Calculator v.5.0. The previous "version" was a zip file that contained the calculator, the commercial and residential binning tools, and v.5.0 documentation. The documentation has since been updated and uploaded as a separate resource, and the binning files have been uploaded as separate resources.

Previous versions of this resource include previous releases/versions of the water heater calculator
DEER_Water_Heaters_deer_waterheater_packag_F7t8HJG.zip 2021 Jan 1 2021 Jan 1 2020 Jan 24

For DEER2021, updates were made to the following files:

  • The water heater baseline and measure cases were updated using the DEER-CEC-AHRI-WH-binning-TechID-v4.1.xlsx workbook.
  • The water heater calculator, DEER-WaterHeater-Calculator-v4.1.xlsm, was updated to generate new measures using the updated baseline and measure cases and to include the previously missing heat pump water heaters and other water heaters.
  • The water heater calculator documentation was updated and is titled DEER-WaterHeater-Documentation-v4.1.pdf.

The above files are available within the DEER_WaterHeater_Package_v4.1.zip. The measures and energy impacts provided within the water heater package will be effective as of 2021-01-01. All prior water heater measures and associated energy impacts will expire as of 2020-12-31.