Changelog

Follow new updates and improvements to Cedars.

April 17th, 2025

Improved

Fixed

Claims

CET

Data tab

User-defined Report Bug Fix: Sorting and Filtering

https://cedars.cpuc.ca.gov/reports/user-defined/

Fixed a bug that caused an error when users attempted to sort repeatedly on the same field in the user-defined reports page.


Updated CET Guide: How Are The Gross Measure Costs Populated

https://cedars.sound-data.com/cet_ui/cet-user-guide/

Replaced:

The gross measure costs have been a source of confusion historically. This confusion is due to two factors: 1) The field names for the unitized gross measure cost (1st and 2nd baseline) are misleading, as they don't truly represent 1st and 2nd baseline unitized gross measure costs and 2) The CET calculation itself is not widely understood and is not well-documented. This is especially confusing for early retirement/accelerated replacement (AR) measures. In the case of AR, while there are both UnitMeaCost1stBaseline and UnitMeaCost2ndBaseline fields, the CET simply uses the value for “UnitMeaCost2ndBaseline” as the effective measure cost. Please see the definitions below (also defined in the Metadata.csv in the SoT) for further details

  • UnitMeaCost1stBaseline: Incremental measure cost over Code/Std for single baseline measures. The Desktop CET called this field 'Gross Measure Cost'. Field not used for dual baseline CE calculations, except when calculating excess incentives (for single and dual baseline measures).

  • UnitMeaCost2ndBaseline: NPV gross measure cost based on first and second baseline measure costs. The Desktop CET called this field 'Gross Measure Cost_ER', (where ER = early retirement, aka accelerated replacement). This is the only measure cost field used for dual baseline CE calculations, except UnitMeaCost1stBaseline is used to calculate excess incentives (for single and dual baseline measures).

New text:

The gross measure costs have been a source of confusion historically. This confusion is  because the CET calculation itself is not widely understood and is not well-documented. This is especially confusing for early retirement/accelerated replacement (AR) measures. In the case of AR, both UnitMeaCost1stBaseline and UnitMeaCost2ndBaseline fields are used to calculate the Accelerated Replacement Cost (ARC) using the formula:

Where the Full Measure Cost (FMC) is the value entered into the UnitMeaCost1stBaseline field, the Incremental Measure Cost (IMC) is the value entered into the UnitMeaCost2ndBaseline field, the Remaining Useful Life (RUL) is the value entered into the RUL_Yrs field, and the Discount Rate (D) is the utility weighted average cost of capital (WACC) for each utility. The formula used in the CET is slightly more complicated than the one shown above in that it includes the market effects adder and compounds the discount quarterly instead of annually.

For further information please see the CET Input Guide


Cost Effectiveness Tool (CET) database documentation Version 24.3

https://cedars.cpuc.ca.gov/cet_ui/spec/

2024 CET Database Version 24.3 Documentation added to the database documentation.


Claims Reopen Bug Fix

Fixed a system error that prevented CPUC from reopening Program Administrator claims when the deadline had passed and the claim reopen button was double-clicked.

April 8th, 2025

Fixed

Monthly Reports

The Monthly Report Deadlines order within CEDARS was updated on April 8, 2025, to reflect the posted schedule from the CPUC.

April 2nd, 2025

Fixed

Claims

The language about reopening Statewide Claims on the Active Dashboard was recently fixed to list only the program administrators who had confirmed local submissions. “Statewide cannot be reopened until the local claims of the same period are also open for [list IOUs that have local claims submitted].”

Previously, it listed all IOU program administrators, regardless of who had submitted a local claim.

March 24th, 2025

Improved

Claims

The claims specification description for the ProgramCost table field CostsRecoveredFromOtherSources Field was updated on March 24, 2025.

The description for this field was updated from “Program-level costs recovered from other sources” to the following:

This field captures program-level energy efficiency (EE) activity costs that are recovered from ratepayers outside of the EE Public Purpose Program (PPP) budget, such as those covered by the General Rate Case (GRC). These costs are included to ensure accurate cost-effectiveness calculations but should not be confused with Integrated Demand-Side Management (IDSM) fields.

Claims ProgramCost: https://cedars.cpuc.ca.gov/claims/specification/data-rules-program-cost/

March 24th, 2025

Improved

Claims

Starting March 24, 2025, CEDARS users can now easily download their uploaded data by clicking directly on the file name in the upload message. This change is in place on the Quarterly Claims Upload Summary page and the Statewide Quarterly Claims Upload Summary page.

March 20th, 2025

Improved

Claims

To make PII data processing more efficient, we added a file naming convention to the guidelines for preparing your claims’ PII files on March 20, 2025. We request that data reporting teams name each PII CSV file using your PA code and table name, following this format: PA_site.csv (e.g., SCE_site.csv), PA_contact.csv (e.g., SCE_contact.csv). The year and quarter can be excluded from individual file names, but can be included when creating the zip file (e.g., SCE2023Q4.zip).

User Guide: Preparing your Claims PII file: https://cedars.cpuc.ca.gov/claims/specification/user-guide/#PreparingYourClaimsPIIFile

March 14th, 2025

New

Starting March 2025, CEDARS users will now receive Featurebase email notifications from the CEDARS Team at cedars-project@cpuc.ca.gov. This change was implemented to improve email deliverability and ensure that important notifications don’t get flagged as spam or end up in junk folders due to company email security filters.

February 27th, 2025

New

Budget Filing

As of 2024, East Bay Community Energy (EBCE) changed its name to Ava Community Energy (AVA). The 2024-2027 budget filing under EBCE was removed on February 27, 2025.

For budget filings, claims, and monthly reports before 2024, refer to EBCE. For budget filings, claims, and monthly reports after 2024, refer to AVA.

February 3rd, 2025

New

CET

PacifiCorp was added to the CET avoided costs so that their programs running in Northern California can be evaluated using the CET; their PA code is “PAC”. PacifiCorp only has avoided cost data in the CET for avoided cost version 2026.

January 28th, 2025

New Features and Updates

  • Avoided Costs Updated:
    CEDARS users can now select "2026" for Avoided Costs in the CET run parameters. Access the tool here: Run CET. Program year assignment to CET Avoided Cost Version table updated.

  • Updated Documentation Resources:
    The CET Specification now includes updated documentation and resources for the 2026 Avoided Cost data. View the specs here: CET Specification

2026 Avoided Cost Changes Overview

  1. Electric Avoided Costs:

    • "Flat" avoided costs for electricity have increased slightly to $36/MWh.

    • Avoided costs during the middle of the day have decreased.

  2. Gas Avoided Costs:

    • Additional outputs are now included for fuel substitution:

      • Annual

      • Summer Only

      • Winter Only

    • Gas avoided cost calculations have been updated.