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

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.

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.

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

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.