- Before
- Owns 13 metrics from 10 source systems, all due on one filing date. Can give the number, but proving where it came from takes a week per metric.
- Now
- Opens any metric's trace (sources, tariff steps, record counts, the dollar result) with the explanation for the Commission written beside it.
The SAIDI trace: a reliability penalty followed back to its outage records
A large utility's performance-year report is due to the Commission in 49 days, under its PBR tariff schedule. The morning run leaves reliability in penalty, and each outage minute is worth $1.5M at the sample tariff rate. Here is what happens next, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 0106:00
Ten systems pulled, each month checked
Source collectorThe daily 06:00 run starts. The source collector takes the extracts at the cut-off from ten systems (2.94M records) and checks each month of each system for completeness. Six items are flagged for their owners, none of which blocks the calculation: storm interruptions restored after midnight in August, 1.3 % of water reads still estimated at data freeze, a 2-day call platform outage backfilled from the carrier's call records.
The source collector does not fill a gap with an estimate; it reports it to the owner.
- 0209:40
The scorecard opens in penalty
PBR reporting leadFiling is due in 49 days, with data freeze in three weeks. The run computed all 13 metrics, 10 with money at stake: net incentive −$2.35M, rewards +$1.75M against penalties −$4.10M. Outage minutes per customer (SAIDI, excluding major event days) came out at 121.4 min against a 118.0 target and a ±2.0 deadband: 1.4 minutes past the penalty edge, at $1.5M a minute, −$2.10M.
“3 corrections waiting on E1, E2 · +$4.75M if accepted”
- 03One switch
What the corrections would do, before anyone decides
PBR reporting leadEach bar runs from the penalty cap on the left, through the gray deadband around the target, to the reward cap on the right. A dashed marker shows where SAIDI and SAIFI would land if the open corrections were accepted. The reporting lead switches to With proposed corrections: SAIDI 113.2 min, SAIFI 1.01, net +$4.75M, marked “Preview, not decided”.
“Preview: E1 and E2 with the 3 proposed corrections. Nothing is changed until the metric owner decides.”
- 04The trace
How the number is made, step by step
Metric calculatorThe reporting lead opens E1. Four sources feed it: 14,812 outage records, 2,310,450 smart-meter power-off and power-on events, the major event day register (5 days, T_MED 6.84) and the count of customers served. Four tariff steps follow (keep sustained interruptions, §3.1; remove duplicates, §3.4; assign each interruption to the day it begins, §3.2; exclude major event days, §3.3) down to the customer minutes, 121.4 min and −$2.10M under §4.1.
Click any step to see its records. Each step names its tariff section and its record count.
- 0506:14
Storm outages on the wrong day, a duplicate, three mislabeled
ReconcilerThe reconciler cross-checked the outage records against the meter events and the major event day register, and proposes three corrections, each with both records side by side. 1,214 interruptions began on a major event day in late August, were restored after midnight and were counted on the next day (−7.5 min). One feeder outage was entered again on a crew re-dispatch (−0.8 min). Three recloser events on three feeders, logged as momentary, show 7,870 meters off for 7.2 to 8.4 minutes: sustained (+0.1 min).
“+0.1 min · against the utility”: the reconciler reports corrections that raise a penalty as well as those that lower it.
- 0609:52
The metric owner decides, with the reason on the record
Reliability engineerThe reliability engineer owns E1 to E3, accepts all three corrections in one step, signing as the metric owner, and the reason goes into the audit trail. In the same step the engineer marks the E1–E3 explanations reviewed. No correction changes a metric until its owner accepts it.
Reason: “Checked against the storm log and the feeder crew tickets; matches the PBR tariff §3.1–3.4.”
- 07Seconds later
The explanation for the Commission rewrites itself
Narrative writerSAIDI is now 113.2 min, 2.8 minutes beyond the reward edge, +$4.20M. The paragraph for the Commission says so, adds a sentence on the three corrections with each one cited to its step, and adds a method-change note: last year's report assigned interruptions to the day they were restored; restated on this year's basis, last year's SAIDI is 119.6 min against 124.1 filed.
“Method change · disclosed”: the narrative writer cannot remove a method-change disclosure.
- 08Back on the scorecard
Reliability crosses from penalty into reward
PBR reporting leadE1 moves to +$4.20M, and E2 from $0 inside its deadband to +$0.80M at 1.01. Net incentive +$4.75M: rewards +$6.75M, penalties −$2.00M. The penalties that stand are traced as well: calls answered within 30 seconds at 76.4 % (−$0.40M), small solar and battery applications approved in 15 business days at 82.0 % (−$1.00M), lost water at 14.4 % (−$0.60M).
“Reliability moved from penalty into reward: E1 113.2 min, +$4.20M”
- 09Staff questions
Answering the Commission from the same trace
Narrative writerCommission staff sent four questions ahead of the technical conference. One, due in two weeks, asks for the workpapers behind SAIDI and SAIFI and the interruptions removed on each major event day. The draft answer names the five days and the 2,388 interruptions excluded, and attaches workpaper tabs 1–6, Appendix C and the E1 trace export. It goes to the director of regulatory affairs for review.
“Staff will see the attachments and the answer; the trace stays internal unless it is attached.”
- 10Signed · 10:24
Signed by the Director, attested by the CFO
Director of regulatory affairsThe filing assembler checks 8 of 8 items ready: the scorecard table, 13 workbooks with each figure linked to its records, the major event days appendix, the discussion of results with 13 of 13 sections reviewed by their owners, two method-change disclosures and the data dictionary. The director signs at 10:24. The CFO attests the net incentive of +$4.75M at 10:31, and the report is filed under the docket.
The filing assembler does not submit: the Director signs and the CFO attests.