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.