2024_IE_Reporting_Template.xlsx
XLSX spreadsheet 87 KB Posted
- Attached to
- RFQ - Civil Engineering Services: Sinkhole Mit. , Stormwater, & Underground Utility Infra. & Road Wrk
- Solicitation number
- Not on record
- Issued by
- Shasta County, California
About this file
This is a 2024 Independent Evaluator (IE) reporting template spreadsheet for electrical corporation Wildfire Mitigation Plan (WMP) initiatives. The template consists of five tabs including an Overview, Catalog of Initiatives, Data Requests, SME Interviews, and List of Failed-to-Fund Initiatives. The document provides a structured framework for tracking and evaluating various WMP initiatives, with detailed attention to progress verification, spending analysis, and risk reduction assessment.
The example initiative shown demonstrates a pole replacement program (WMP.972) with a target of 14,850 poles, which achieved 15,850 replacements. While the initiative exceeded its quantitative target with a 104% validation rate based on field inspections and SAP notifications, it experienced significant underspending (-43% variance) due to fewer resource hours than planned. The program failed to meet its risk reduction goals as poles were replaced in lower-risk areas, resulting in only 30% risk mitigation instead of the intended target. The template requires detailed documentation of funding discrepancies, progress validation methods, and risk reduction outcomes for each initiative.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Bid_Packet.pdf | ||
| 2023Mar6Form74R3_(7).pdf | ||
| std1000.pdf | ||
| RFQ_5PA4K00178.01_-_Redding_Training_Center_-_Fire_Props_2.pdf | ||
| Bidder_Instructions.pdf | ||
| gspd05-106.pdf | ||
| STD_204.pdf | ||
| Darfur_Certification_CAL_FIRE-720_.pdf | ||
| 2024_IE_RFQ_Attachments_B_to_E.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ.pdf | ||
| 2024_IE_RFQ_Q_A_Summary.pdf | ||
| 2024_IE_RFQ_Attachment_A.docx | DOCX document | |
| 2024_IE_ARC_Outline.pdf | ||
| 2024_IE_Sample_size_calculator.xlsx | XLSX spreadsheet | |
| 2024-12_Meeting_Notice_Independent_Evaluator_RFQ.pdf |
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Tab 1 - Overview tab IE ARC Attachments
Independent Evaluator:
Electrical Corporation:
Legends
| Tab 1 | Overview Tab - Instructions and overview |
| Tab 2 | Catalog of Initiatives - Initiative review and funding compliance of all initiatives |
| Tab 3 | Data Requests - Comprehensive list of documents reviewed |
| Tab 4 | SME Interviews - Summary of interviews conducted |
| Tab 5 | List of Failed-to-Fund Initiatives - All initiatives funded less than 100% |
Tab 2 - Catalog of Initiatives Catalog of Initiatives
Independent Evaluator:
| Electrical Corporation: | ||||||||||||||||
| WMP Category | Initiative Tracking ID | WMP Section Number | Initiative Name | Initiative Type | WMP - Initiative Description | WMP - Initiative Target | EC-Claimed Progress (Q4 QDR) | EC-Claimed Progress (EC ARC) | EC-Claimed Progress | |||||||
| Kopunova, Sara: Number of "actuals" from which samples are selected | EC-Claimed Initiative Status | Target Not Met - Rationale | Sample Size (#) | Sample Validation Rate (%) | Verification Method | Initiative Validation Rate (%) | IE Finding on Initiative | WMP - Planned Spend ($) | EC-Claimed Actual Spend ($) | Variance (%) | Funding discrepancy - finding | Funding discrepancy - detail | Satisfied Risk Reduction Goal - finding | Satisfied Risk Reduction Goal - detail | ||
| Grid Design Operations and Maintenance | WMP.972 | 8.1.2.1 | Pole replacement | Focus & field verifiable | Replace 14850 poles | 14,850 | 15,850 | 15,840 | 15,850 | Target met | N/A | 400 | 97.50% | Field inspection | ||
| SAP notification (DR064) | 104% | Initiative validated | $ 2,507,000.00 | $ 1,435,000.00 | -43% | Underspend | Due to fewer resource hours charging to the program than initially anticipated in 2021, resulting in lower costs incurred | No | Poles were replaced in lower-risk areas, reducing overall risk mitigation | <-- Example | ||||||
| Grid Design Operations and Maintenance | WMP.550 | 8.1.5 | Lightning arrestor replacement | Focus & non-field verifiable | Replace 2216 arrestors | 2,216 | 1,500 | 1,490 | 1,490 | Target not met | Initiative faced delays in permit processing due to staff turnover | 120 | 83% | Field inspection | ||
| SAP work order (DR082) | 56% | Initiative not validated | $ 3,407,000.00 | $ 4,000,888.00 | 15% | Overspend | Due to lower remediations, driven by a lower find rate and execution limitations due to internal exceptions | No | EC did not meet its target by >30% and did not meet its intended risk reduction | <-- Example | ||||||
| Vegetation Management and Inspections | VM-04 | 8.2.3 | QA/QC for vegetation management inspections | Non-focus & non-field verifiable | Inspect 35 lines miles for vegetation | 35 | 35 | 35 | 35 | Target met | N/A | 35 | 100% | QA/QC documentation (DR034) | ||
| SME interview (SME02) | 100% | Initiative validated | $ 3,150,987.00 | $ 3,149,987.00 | 0% | No discrepancy | N/A | Yes | N/A | <-- Example |
Tab 3 - Data Requests Data Requests
Independent Evaluator:
| Electrical Corporation: | ||||||
| Date Sent | Date Response Received | Section / Initiative | Data Request Number | List of Documents Received | ||
| 5/1/24 | 5/3/24 | 8.1.2.1 - GH-01 | DRU 13535 | DRU13535 Redacted Attachments (ZIP) | ||
| DRU13535 Audit Independent | <-- Example |
Tab 4 - SME Interviews SME Interviews
Independent Evaluator:
| Electrical Corporation: | |||||
| Interview date | Section / Initiative | SME interview number | Positions interviewed | Summary of interview | |
| 5/1/24 | 8.1.2.1 - GH-01 | SME001 | Director of Wildfire Mitigation | Overview of funding verification with slide presentation covering financial assumptions; cost model assmption; major elements of cost models; planning order fields; and overview of 2023 spend high-level drivers | <-- Example |
Tab 5 - List of "Fail-to-Fund" List of Failed-to-Fund Initiatives
Independent Evaluator:
| Electrical Corporation: | |||
| WMP Category | WMP Section Number | WMP Page Number | Initiative Tracking ID |
Kopunova, Sara: Kopunova, Sara:
| If applicable since some commitments occur outside of initiatives | Initiative Name | WMP - Planned Spend ($) | EC-Claimed Actual Spend ($) | Variance (%) | ||||||
| Grid Design Operations and Maintenance | 8.1.2.3 | 87 | SH-01 | Pole replacement | $ 10,000.00 | $ 9,000.00 | 10% | <-- Example |
image1.jpeg image2.jpeg
File details come from the government source that posted it. Updated .