Powergrid India — PAN India RE Substation Master Skill v2.1.2
Canonical source: https://github.com/d33pm3/Powergrid-India
Package
Powergrid-India/
├── SKILL.md
├── references/substation-master.md
├── references/substations-a.csv ← baseline rows 1–66
├── references/substations-b.csv ← baseline rows 67–132
├── references/generation-script.md
├── evals/
├── src/powergrid_india/
└── tests/
parse_master_table() concatenates substations-a.csv and substations-b.csv (132 unique rows). There is no single references/substations.csv in this tree.
Part 0 — Contract
The 132-row baseline is planning-grade, not a verified regulatory filing. Tag unconfirmed rows [SOURCE_FALLBACK:BASELINE]. Live-confirmed rows may use [SOURCE_LIVE] / [SOURCE_LIVE:NEW]. Every workbook and chat answer carries this caveat.
Loop bounds: each of the 5 public fetches is attempted at most twice. Never simulate a source.
Execution order
- Plan deliverable and verification artifacts
- Live research (CTUIL, PGCIL, CEA, MNRE, GEC) — current year in queries
reconcile(parse_master_table(), live_updates)build_workbook_data(records)thencreate_workbook(...)- QA on the saved file (openpyxl re-open)
Public URLs only: https://www.ctuil.in, https://www.powergrid.in, https://www.cea.nic.in, https://www.mnre.gov.in, https://www.powergrid.in/project/green-energy-corridor
Schema (11 columns)
Region, State, Substation_Name, Type_AIS_GIS, Voltage_Level, Transformation_Capacity_MVA, Renewable_Companies_Connected, Project_Type, Total_Capacity_MW, Remarks, Data_Source
Baseline totals (recompute after live merge)
132 substations, 130,500 MW. WR 54 / 76,550; SR 36 / 31,480; NR 18 / 17,800; ER 16 / 4,000; NER 8 / 670. 30 states.
Workbook (10 sheets)
All_Substations, Regional_Summary, State_Summary, Western_Region, Northern_Region, Southern_Region, Eastern_Region, NorthEastern_Region, Top_50_Substations, Analytics_Dashboard
Dashboard blocks: KPIs, regional, voltage tiers (exclusive match), project mix, 9 BESS/PSP nodes, GEC, top 15, source log + epistemic caveat.
Formatting: data headers #2E7D32, dashboard headers #1C3A6B, sub-headers #00695C, planned #E65100, freeze A2, auto-filter on all sheets.
Implementation
Use src/powergrid_india. Do not hand-build sheet JSON. Checkpoints and xlsx go to outputs/ (gitignored).
python -m powergrid_india.cli --output outputs/PAN_India_RE_Substations_Master_Data.xlsx