Data: Expand Summary Data table to include additional CET outputs
The Summary Data table should be updated to include the full set of relevant CET output fields. Currently separate electric and gas benefits are requested, but we also want to:
Retain Total Benefits
Add electric and gas supply, cost
Add fields for water benefits, supply and cost
Add fields for other benefits, supply and cost
Add SCT fields SB, SH, cost
New fields to be included in the Data Summary table:
Parent Program
Filing Other Cost
Filing Rim Ratio
Filing SCT-B Ratio
Filing SCT-H Ratio
Filing Bill Incr Elec
Filing Bill Reduc Elec
Filing Bill Incr Gas
Filing Bill Reduc Gas
Filing Elec Ben
Filing Elec Ben SCT-B
Filing Elec Ben SCT-H
Filing Gas Ben
Filing Gas Ben SCT-B
Filing Gas Ben SCT-H
Filing Tax Credits
Filing Water Energy Ben
Filing Water Energy Ben SCT-B
Filing Water Energy Ben SCT-H
Filing Other Ben
Filing SCT-B Cost
Filing SCT-H Cost
Filing Elec Supply Cost SCT-B
Filing Elec Supply Cost SCT-H
Filing Gas Supply Cost SCT-B
Filing Gas Supply Cost SCT-H
Filing Water Energy Cost
Filing Water Energy Cost SCT-B
Filing Water Energy Cost SCT-H
TBC if we want to show any of these No Admin fields:
Filing Rim Ratio No Admin
Filing SCT-B Ratio No Admin
Filing SCT-H Ratio No Admin
Filing RIM Cost No Admin
Filing SCT-B Cost No Admin
Filing SCT-H Cost No Admin
TBC if we want to show any of these Gross fields:
Filing Elec Ben Gross
Filing Elec Ben Gross SCT-B
Filing Elec Ben Gross SCT-H
Filing Gas Ben Gross
Filing Gas BenGross SCT-B
Filing Gas Ben Gross SCT-H
Filing Tax Credits Gross
Filing Water Energy Ben Gross
Filing Water Energy Ben Gross SCT-B
Filing Water Energy Ben Gross SCT-H
Filing SCT-B Cost Gross
Filing SCT-H Cost Gross
Filing Elec Supply Cost Gross SCT-B
Filing Elec Supply Cost Gross SCT-H
Filing Gas Supply Cost Gross SCT-B
Filing Gas Supply Cost Gross SCT-H
Filing Water Energy Cost Gross
Filing Water Energy Cost Gross SCT-B
Filing Water Energy Cost Gross SCT-H
Mockup of fields:
Summary.Report - Budget Filing Mockup V1.1.xlsx
15.6 KB• Spreadsheet
- Select the module in CEDARS
- Select user type
Log in to comment and vote
Comments3
cedars team
Sep 11, 2025
Notes from Dev Demo Sep 10
Please see the linked ticket description for full details. These updates relate to the https://cedars.cpuc.ca.gov/reports/summary/.
Decisions Made
We do not need [gross / net / lifecycle / first year] site and water kWh fields in this summary.
Use SCT-B instead of SCB/SB.
Use SCT-H instead of SCH/SH.
Outstanding Decisions (TBD)
Do we need the “no admin” variants of the new metrics?
Do we want the gross variants of the new metrics?
The dataset download currently outputs field names in Title Case with spaces. Confirm if this naming convention is acceptable.
cedars team
May 27, 2025
Do we want to add electric and gas benefits and keep total benefits?
cedars team
May 28, 2025
yes, include other and water. supply costs for all.