DEER Change Log

Added three new GasImpactProfileIDs to facilitate different avoided costs for gas to electric fuel substitution measures, per Page 61 of the 2022 Avoided Cost Calculator Documentation https://www.cpuc.ca.gov/-/media/cpuc-website/divisions/energy-division/documents/demand-side-management/acc-models-latest-version/2022-acc-documentation-v1a.pdf

The new IDs are Annual-FuelSub-ToElec, SummerOnly-FuelSub-ToElec, and WinterOnly-FuelSub-ToElec

Created 3 new BldgType records as shown:

Created two new EUL_IDs for cannabis lighting in greenhouses as shown:

Updated WtrHT-Com-Gas EUL ID value in DEER Table to correct the value from 15 years to 13 years based on the "Commercial HVAC and Water Heating Effective Useful Life Study". IsProposed flag is still TRUE:

Expired four (4) NTG_IDs that were previously applied to lighting measures that used either the wattage-reduction-ratio and delta-Watts methods of determining savings since these methodologies are no longer in use.

Added DEER2026 NTG_ID updates to all active NTG_IDs to align with the Measure Impact Type and Delivery Type updates per Resolution E-5221 DEER2024 Update.

Added four EUL_ID updates in response to "Commercial HVAC and Water Heating Effective Useful Life Study" with IsProposed flag set to TRUE:

Added TechType = Door as a new element of the BldgShell TechGroup

Added: BS-Door: 20.00 years (DEER2024), BS-DoorSeals: 15.00 years (DEER2024), BS-DoorSweep: 5.00 years (DEER2024)

Updated applicable delivery types from Resolution E-5221 based on PY2020 Non Residential Lighting impact evaluation report for 'NonRes-sAll-mLtg-TLEDLamp' and 'NonRes-In-Ltg-LEDFixt', creating a downstream and an upstream version of each NTG_ID:

• NonRes-sAll-mLtg-TLEDLamp-dn
• NonRes-sAll-mLtg-TLEDLamp-up
• NonRes-In-Ltg-LEDFixt-dn
• NonRes-In-Ltg-LEDFixt-up

Added three EUL_ID updates in response to "DRAFT Residential HVAC and DHW Measure Effective Useful Life Study" with IsProposed flag set to TRUE:

Revised the start dates for TechTypes  'spltAC-SEER-BA' and 'spltHP-SEER-BA' from 2024-01-01 to 2023-01-01.

New commercial BldgHVAC type "cDXOH" added for split or package direct expansion unit with "Other Heat" source, such as propane.

New versions of the following EUL_IDs were added to DEER: BS-BlowInIns, BS-CeilIns, and BS-WallIns.

Measures for which there were multiple active versions have been expired accordingly so that only the most recent version is the active version. 67 total Measures were affected.

A new table has been added to the costeff schema that contains FuelIDs intended to support the guidance provided in D.23-04-035. An accompanying view, FuelID_Combinations, was also added that coalesces the records contained within the FuelID table to a managable size. An Excel export of the FuelID_Combinations view is provided for download.

MeasureAppType has been updated to include NC for the NTG_IDs Res-sAll-mAppPlug-AirCleaner-up and Res-sAll-mHVAC-RmAC-dn.

The following fields were removed from the TechType table: NumTechs, NumMeas, NumImp, NumCost, NumDEERMeas, and NumDEERCost. These fields existed for the benefit of the READI tool that the CPUC stopped supporting 2021-01-01. The eTRM has never imported or leveraged these fields and the Deemed Ex Ante team has not updated their contents since no longer supporting READI.

Four new fields added to TechType table:

• IsExempt:
  • TRUE if the TechType saves gas but does not burn gas
• HasViableElecAlt
  • TRUE if the pending working group report determines that a given gas-burning TechType has a viable electric technology
• HasRefrigerant
  • TRUE if the TechType contains refrigerant
• HasViableRefrigerantAlt
  • TRUE if the electric TechType has an alternative TechType that contains refrigerant

Three new Clothes Dryer TechTypes were added.

New MajorVersion and VersionSource records have been added for PY2025 and PY2026 (DEER and ExAnte).

Uploaded BldgHVAC weights used to produce cWtd BldgHVAC records for commercial measures delivered via upstream or midstream delivery types.

Expiration date for DEER2020 ceiling insulation measures was corrected so that they expire on 2023-12-31 rather than 2022-12-31.

For PY2024, rEVAP BldgHVAC was renamed to rEVGF to allow for evaporative cooling with more heating options as indicated by 2019 RASS. Also added the following new types: rDXEH, rEVEF, rEVEH, rEVOH, and rNCEF.

Uploaded BldgHVAC weights used to produce rWtd BldgHVAC records for residential measures delivered via upstream or midstream delivery types.

Uploaded new MeasureIDs, Technology Names, and EnergyImpactIDs for commercial packaged AC/HP systems that now require economizers per 2022 Title 24 for SEER 16-18/16-17. (SEER15 records will follow in the coming weeks to correct anomalous W/cfm ratio.)

Corrected all EUL_hou records to have ClaimSpec=True and FilingSpec=True.

New EUL_ID added for Residential "Fan Controller for HVAC" measures.

New EUL_ID (Com-GasPatioHeater), TechGroup (PatioHeat), TechType (GasPatioHeat), and UseSubCategory (PatioHeat) created for Gas Patio Heater measures.

All-electric new construction NTG_ID, Res-NC-AllElectric, added to NTG_2020 table.

Incorrect TypeID corrected for 9 technology records with Tech Type Boiler_Ec.

Two new fields, WeatherSim and FuelSubID were added to the Measure table to track which TMY weather data were used to model measures, and to indivate whether a given measure is a fuel-substitution.

The recently added WeatherSim and FuelSubID fields were removed in from the EnergyImpact table since they are present in the Measure table.

New source_status record for Commercial Cooktop added to DEER.

Several DEER2020 water heater EnergyImpactIDs in both the Measure and EnergyImpactID table were fixed, changing IDs with "-ite" to "-lte" for less than or equal to.

EUL values corrected for WEN cold-water devices.

Residential clothes washer measures were uploaded in May 2022, this announcement is to upload the QC workbook associated with these measures.

New NTG ID for water-energy projects has been added per D.15-09-023.

New values were added to DEER support tables for Water-Energy-Nexus (WEN) cold-water conservation measures. Nine EUL_IDs were added: Wtr-WaterFixt-Toilet-Res, Wtr-WaterFixt-Toilet-Com, Wtr-WaterFixt-Urinal, Wtr-Irrig-Nozzle-LrgRot, Wtr-Irrig-Nozzle-MultiStrm, Wtr-Irrig-TurfRemoval, Wtr-Irrig-Ctrl-Weather-Res, Wtr-Irrig-Ctrl-Weather-Com, and Wtr-Irrig-Ctrl-SoilMoist. One UseCategory and one UseSubCategory were added: SCW and PointOfUse, respectively. To the Irrigation TechGroup, three TechType records were added: IrrigCtrl, Nozzle, and Xeriscape. To the WaterFixt TechGroup, one TechType was added: Sanitary.

Three new residential building HVAC types were added to DEER: 

• rDXEF: central AC with electric furnace
• rDXHW: central AC with hydronic heating
• rDXWP: central AC with water-source heat pump

Two measure impact types were added:

Based on a review of Quantum's evaluation report cited by Resolution E-5152 DEER2023, the description for "NTG_ID"='NonRes-In-Ltg-LEDFixt' and "Version"='DEER2023' has been updated from "Nonresidential indoor LED linear fixture" to "Nonresidential indoor LED fixture (including High/Low-Bay)".

Added hot water space-heating boiler measures (NG-HVAC-Blr-HW-gt2500to10000kBtuh-87p3Ec-Drft, NG-HVAC-Blr-HW-gt2500to10000kBtuh-95p0Ec-CndLow, NG-HVAC-Blr-HW-gt2500to10000kBtuh-95p0Ec-CndReset, NG-HVAC-Blr-HW-gt2500to10000kBtuh-95p0Ec-CndStd, NG-HVAC-Blr-HW-gt2500to10000kBtuh-98p0Ec-CndLow, NG-HVAC-Blr-HW-gt2500to10000kBtuh-98p0Ec-CndReset, and NG-HVAC-Blr-HW-gt2500to10000kBtuh-98p0Ec-CndStd)

Central Storage Water Heater Measures added (NG-WtrHt-Central-LrgStrg-Gas-gt75kBtuh-0p90Et, NG-WtrHt-Central-LrgStrg-Gas-gt75kBtuh-0p96Et).

Revised the start date for NTG_IDs for greenhouse measures (NonRes-sGHS-mHtCrtn-dn, NonRes-sGHS-mIRF-dn, NonRes-sGHS-mHtCrtn-ci, and NonRes-sGHS-mIRF-ci) from 2024-01-01 to 2023-01-01 to reflect change of Measure Application Type from Add-On Equipment (AOE) to Building Weatherization (BW).

Added commercial heat pump measures (NE-HVAC-airHP-SpltPkg-135to239kBtuh-10p8eer-3p48cop, NE-HVAC-airHP-SpltPkg-135to239kBtuh-11p2eer-3p51cop, NE-HVAC-airHP-SpltPkg-65to134kBtuh-11p5eer-3p50cop, NE-HVAC-airHP-SpltPkg-65to134kBtuh-11p5eer-3p50cop-wPreEcono, NE-HVAC-airHP-SpltPkg-65to134kBtuh-12p0eer-3p55cop, NE-HVAC-airHP-SpltPkg-65to134kBtuh-12p0eer-3p55cop-wPreEcono, NE-HVAC-airHP-SpltPkg-240to759kBtuh-9p7eer-3p30cop, NE-HVAC-airHP-SpltPkg-240to759kBtuh-10p0eer-3p30cop).

Per Resolution E-5152 DEER2024 for Net-to-Gross (NTG) Table
Effective Program Year: 2024. Ever since the creation of the NTG_2020 table per Resolution E-4952 DEER2020 Update, Program Administrators have been asking for improvements to this table. To this end, a new table—serving as a companion to the NTG_2020 table—is proposed to clarify when a given NTG ID may be used. The planned companion table will contain a complete list of all valid combinations of NTG IDs, Measure Application Types, Measure Impact Types, and Delivery Types for deemed and custom measures. Within the NTG_2020 table itself, however, the existing string-type fields that contain sometimes-vague descriptions of which Measure Application Types, Measure Impact Types, and Delivery Types they can be used for will be deleted. 

Added ductless minisplit heat pump measures, SEER 20-22 (RE-HV-DHP-20S, RE-HV-DHP-20S-replRmAC-ER, RE-HV-DHP-21S, RE-HV-DHP-21S-replRmAC-ER, RE-HV-DHP-22S, RE-HV-DHP-22S-replRmAC-ER). 

Added ductless minisplit heat pump measures, SEER 16-19 (RE-HV-DHP-16S-replRmAC-ER, RE-HV-DHP-17S, RE-HV-DHP-17S-replRmAC-ER, RE-HV-DHP-18S, RE-HV-DHP-18S-replRmAC-ER, RE-HV-DHP-19S, RE-HV-DHP-19S-replRmAC-ER).

Added residential freezer and refrigerator measures (Res-Refg-dKWH-Cond, Res-Frzr-dKWH-Cond).

Added residential SEER-rated HP measures (RE-HV-ResHP-16S, RE-HV-ResHP-17S, RE-HV-ResHP-18S, RE-HV-ResHP-19S, RE-HV-ResHP-20S, RE-HV-ResHP-21S).

Added residential SEER-rated AC measures (RE-HV-ResAC-16S, RE-HV-ResAC-17S, RE-HV-ResAC-18S, RE-HV-ResAC-19S, RE-HV-ResAC-20S, RE-HV-ResAC-21S).

Added Whole House Fan measures (WholeHouseFan-0.7CFM-ECM, WholeHouseFan-0.7CFM-PSC, WholeHouseFan-1.5CFM-ECM, WholeHouseFan-1.5CFM-PSC, WholeHouseFan-2.0CFM-ECM, WholeHouseFan-2.0CFM-PSC, WholeHouseFan-3.0CFM-ECM, WholeHouseFan-3.0CFM-PSC)

Added fan controls for residential SEER-rated split ACs (RE-ResAC-FanCtrls)

Added residential fan motor measure (RE-BrushlessFanMotor)

The MeasImpactType table was updated to clarify FuelSub Measure Impact Type records.

Added residential package terminal air conditioners and heat pumps (RE-PTAC-10.7to12.84EER-New, RE-PTAC-8.56to10.27EER-Ex, RE-PTHP-10.7to12.81EER-New, RE-PTHP-8.92to10.70EER-Ex)

Note: VersionSource was corrected on 2022-09-13.

Added residential furnace measures (Res-GasFurnace-AFUE92-ECM, Res-GasFurnace-AFUE95-ECM, Res-GasFurnace-AFUE97-ECM)

For DEER2023 water heater measures that indicated that the normalizing unit was based on the input capacity (NormUnit=Cap-kBTUh), the VersionSource was updated to "DEER WaterHeater Calculator v5.1" and the normalizing unit was updated to output capacity (NormUnit=CapOut-kBtuh).

All water heater EnergyImpact records were revised by correcting the NormUnit from Cap-kBTUh to CapOut-kBtuh. No other changes were made. This is consistent with the "DEER Water Heater Calculator v.5.1.xlsm" that is available at https://cedars.sound-data.com/deer-resources/tools/water-heaters/.

Added the following ceiling insulation measures using EnergyPlus residential building prototypes calibrated with 2019 RASS data and simulated using CZ2022 weather data:

"Unexpired" some lighting EUL_IDs:

ILtg-CFL-Com, ILtg-CFLfix-Com, ILtg-CFLfix-Res, ILtg-CFLfix-ResCmnArea, ILtg-CFL-ResCmn, Iltg-Com-CldCthd-25000hr, ILtg-HID-Cmn, ILtg-HPS, ILtg-Incand-Com, ILtg-Incand-Res, ILtg-Induct-Elec, ILtg-Lfluor-Mag, ILtg-Lfluor-T12Mag, ILtg-MH, ILtg-T5, OLtg-CFL, OLtg-CFL-Cmn, OLtg-CFLfix, OLtg-CFLfix-ResCmnArea, OLtg-HID, OLtg-HID-Cmn, OLtg-HPS, OLtg-Induct, OLtg-LFluor-CommArea, OLtg-Lfluor-Mag, OLtg-LFluor-Res, OLtg-MH, and OLtg-T5.

Added duct optimization measures (Res-DuctOpt-HighToLow-Retrofit, Res-DuctOpt-HightoLow-Replacement) for mobile homes.

Added duct sealing measures (RB-HV-DuctSeal-HighToLow and RB-HV-DuctSeal-MedToLow) using EnergyPlus residential building prototypes calibrated with 2019 RASS data and simulated using CZ2022 weather data.

Added wall insulation measure (RB-BS-BlowInIns-R0-R13) using EnergyPlus residential building prototypes calibrated with 2019 RASS data and simulated using CZ2022 weather data.

The following fields have been added to the EnergyImpact table in DEER:

• APreUseWBkWh & APreUseWBtherm
• AStdUseWBkWh & AStdUseWBtherm
• AMsrUseWBkWh & AMsrUseWBtherm
• APreUseEUkWh & APreUseEUtherm
• AStdUseEUkWh & AStdUseEUtherm
• AMsrUseEUkWh & AMsrUseEUtherm

Added MeasImpactType:

• Cust-NMEC-Pop-FuelSub

Added Measure Application Types (AOE, BRO-RCx, & BW) eligible for Direct-Install Delivery Type (DnDeemDI & DnCustDI) for the following NTG IDs:

• Agricult-Default-HTR-di
• Com-Default-HTR-di
• Ind-Default-HTR-di
• Res-Default-HTR-di

Added high-efficiency central DHW instantaneous boiler systems for MFm buildings:

• NG-WtrHt-Central-Blr-gt150kBtuh-0p90Et
• NG-WtrHt-Central-Blr-gt150kBtuh-0.96Et

Adding missing standard measures of split/package ACs: 

• NE-HVAC-airAC-SpltPkg-240to759kBtuh-10p8eer
• NE-HVAC-airAC-SpltPkg-240to759kBtuh-11p5eer
• NE-HVAC-airAC-SpltPkg-240to759kBtuh-12p5eer

(Previously, only the single-zone and multi-zone component records had been uploaded.)

Added the following NTG IDs:

• Res-sAll-mHVAC-SCT-dn (DEER2024)
• Res-sAll-mHVAC-HP-MidDistr-FuelSub (DEER2024)
• All-In-Ltg-LED (DEER2024)
• All-In-Ltg-LEDFixt-dn (DEER2024)
• All-In-Ltg-LEDFixt-mid (DEER2024)
• NonRes-sAll-mIrrig-WellPump-VFD (DEER2024)
• NonRes-sAll-mIrrig-Pump-eVFD (DEER2024)
• Com-sAll-mFS-Fryer-dn (DEER2024)

Expired the following NTG ID:

• Res-sAll-mHVAC-SCT-dn (DEER2022)

Added:

• NonRes-sAg-mCust-ci (DEER2024)
• NonRes-sAll-mCust (DEER2024)
• NonRes-sAll-mCust-Elec (DEER2024)
• NonRes-sAll-mCust-Ltg-di (DEER2024)

Expired:

• NonRes-sAg-mCust-ci (DEER2019)
• NonRes-sAll-mCust (DEER2019)
• NonRes-sAll-mCust-Elec (DEER2019)

Water-cooled screw chillers are available.

Water-cooled frictionless centrifugal chillers are available.

Water-cooled conventional centrifugal chillers are available.

Added previously expired NTG IDs for which no better data exists:

• Res-sAll-mAppPlug-AirCleaner-up (DEER2016)
• Res-sAll-mAppPlug-ElecClothesDryer-up (DEER2016)
• Res-sAll-mAppPlug-Freezer-up (DEER2016)
• Res-sAll-mAppPlug-GasClothesDryer-up (DEER2016)

EUL_ID ILtg-HID was unexpired as it was still needed.

Residential clothes washer measures are now available.

Air-cooled screw chiller measures are available.

The following two MeasImpactTypes were added: Cust-NMEC-Site-FuelSub and Cust-SEM-FuelSub

Res, SFm, MFm, and DMo records for residential dishwashers have been uploaded.

For DEER2023 NTG_IDs NonRes-In-Ltg-LEDFixt and NonRes-sAll-mLtg-TLEDLamp, changed eligible MeasureAppTypes to include: NR, AR, NC.

Corrected NTGRs for Nonres-sAll-mLtg-TLEDLamp to 0.65.

Added new EUL_ID for new buried duct measure, BS-BuriedDuct, supported by the weighted average of attic insulation, duct sealing, and attic weatherization. Also added new TechType to support associated EUL_ID, BuriedDuct, in the BldgShell TechGroup.

Added newly updated commercial measure categories: package/split ACs, package/split HPs, space-heating furnaces/boilers, duct sealing, and VRF HPs.

For gas fryers, extended 12-year EUL through 2022-03-20 and delayed start date of 11- year EUL until 2022-03-21.

Added:

• Res-sAll-mSHW-InstWtrHtr
• Res-sAll-mSHW-StorWtrHtr
• Res-sMFm-mSHW-DemCtrlRecircPump-di
• Res-sMFm-mSHW-TempCtrl-di
• Nonres-sAll-mLtg-TLEDLamp
• Res-sAll-mHVAC-FanCtrl
• Res-sAll-mHVAC-CndsrCoilClng
• Nonres-sAll-mProc-OzoneLaundry

Updated:

• NonRes-In-Ltg-LEDFixt

Added:

• Res-sAll-mHVAC-SCT-di (DEER2022)
• Res-sAll-mHVAC-SCT-dn (DEER2022)

Expired:

• Res-sAll-mHVAC-SCT-di (DEER2021)
• Res-sAll-mHVAC-SCT-dn (DEER2021)

Updated:

• Res-sAll-mSHW-InstWtrHtr (DEER2023)
• Nonres-sAll-mProc-OzoneLaundry (DEER2023)
• Res-sAll-mHVAC-CndsrCoilClng (DEER2023)

Added records for interactive effects for residential lighting measures by utilizing CZ2022 weather data.

Added records for interactive effects for lighting commercial measures that utilize CZ2022 weather data.

Added 33 records per table to provide updated coincident demand factors for exterior lighting. These needed to be updated since the peak period days for each climate zone changed with the update to CZ2022 weather data (per Resolution E-5152).

Updated missing kW UES values for NE-HVAC-airHP-Split-lt55kBtuh-18p0seer-9p7hspf