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) then create_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
1---2name: powergrid-india3version: "2.1.2"4author: DK Mendiratta5description: |6 PAN India RE Substation skill - 132+ CTU/PGCIL substations across 5 regions (WR, NR, SR, ER, NER) and 30 states. Performs live web research (CTUIL, PGCIL, CEA, MNRE, GEC), reconciles against the embedded baseline, and builds a 10-sheet XLSX workbook with an Analytics Dashboard.78 Always use this skill for: India RE substation data; RE-grid XLSX workbooks; PGCIL/CTUIL substation lists; GNA/LTA connectivity margins; Green Energy Corridor Phase-I/II; 765/400 kV evacuation nodes; BESS or Pump Storage nodes; RE parks (Khavda, Bhadla, Pang, Pavagada, Kurnool, Fatehgarh, Barmer, Rewa); RE developers (Adani Green, NTPC, SECI, ReNew, Greenko); FDRE/hybrid/PSP nodes; InvIT RE transmission assets. Invoke even for casual queries touching India RE substations, PGCIL, or CTUIL. Not for electricity tariff or regulatory-law questions, discom/utility financial modeling, or thermal topics with no RE evacuation angle.9changelog: |10 v2.1.2 (2026-09-06): Public release. Runnable package, exclusive voltage tiers,11 name-key hyphen fix, BESS/PSP filter excludes Hydro-Solar, portable outputs/,12 CSV baseline, epistemic caveat on Dashboard Block 8.13compatibility:14 python_packages: [openpyxl]15metadata:16 source: https://skillmd.com/skills/d33pm3/powergrid-india17---1819# Powergrid India — PAN India RE Substation Master Skill v2.1.22021Canonical source: https://github.com/d33pm3/Powergrid-India2223## Package2425```26Powergrid-India/27├── SKILL.md28├── references/substation-master.md29├── references/substations-a.csv ← baseline rows 1–6630├── references/substations-b.csv ← baseline rows 67–13231├── references/generation-script.md32├── evals/33├── src/powergrid_india/34└── tests/35```3637`parse_master_table()` concatenates `substations-a.csv` and `substations-b.csv` (132 unique rows). There is no single `references/substations.csv` in this tree.3839## Part 0 — Contract4041The 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.4243Loop bounds: each of the 5 public fetches is attempted at most twice. Never simulate a source.4445## Execution order46470. Plan deliverable and verification artifacts481. Live research (CTUIL, PGCIL, CEA, MNRE, GEC) — current year in queries492. `reconcile(parse_master_table(), live_updates)`503. `build_workbook_data(records)` then `create_workbook(...)`514. QA on the saved file (openpyxl re-open)5253Public 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-corridor5455## Schema (11 columns)5657Region, State, Substation_Name, Type_AIS_GIS, Voltage_Level, Transformation_Capacity_MVA, Renewable_Companies_Connected, Project_Type, Total_Capacity_MW, Remarks, Data_Source5859## Baseline totals (recompute after live merge)6061132 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.6263## Workbook (10 sheets)6465All_Substations, Regional_Summary, State_Summary, Western_Region, Northern_Region, Southern_Region, Eastern_Region, NorthEastern_Region, Top_50_Substations, Analytics_Dashboard6667Dashboard blocks: KPIs, regional, voltage tiers (exclusive match), project mix, 9 BESS/PSP nodes, GEC, top 15, source log + epistemic caveat.6869Formatting: data headers `#2E7D32`, dashboard headers `#1C3A6B`, sub-headers `#00695C`, planned `#E65100`, freeze `A2`, auto-filter on all sheets.7071## Implementation7273Use `src/powergrid_india`. Do not hand-build sheet JSON. Checkpoints and xlsx go to `outputs/` (gitignored).7475```bash76python -m powergrid_india.cli --output outputs/PAN_India_RE_Substations_Master_Data.xlsx77```