Water Heaters History: DEER Water Heater Calculator v6.0

File Start Date End Date Date posted Notes
DEER-WaterHeater-Calculator-v6.0.xlsm 2026 Apr 20 This version (6.0) made updates to the values in the "Tmains" and "Tamb" and Peak Period based on CZ2025 weather data. It also added a macro for creating hourly load shapes. Instructions for using this macro are included in the Intro tab.
DEER-WaterHeater-Calculator-v6.1.xlsm 2026 May 14 This version (6.1) includes updates to the permutation-generation macros. The newer macro buttons are located to the right of the original tool buttons and are labeled “NEW COM IMPACTS” and “NEW RES IMPACTS.” This version also updates the TechID nomenclature to align with the latest protocols. Additionally, a new normalization option has been added, allowing normalization to be based either on the measure-case values or the standard-case values, depending on the measure. This option can be selected in cell $M$5 of the EnImpacts-Com tab. The pre-existing IDs in the EnImpacts-Com and EnImpacts-Res tabs have also been updated to match the IDs in the Measure tab. Finally, the load shape CSV creation macro has been updated to include a status bar.