Project 02
Grid operation data.
Excel automation, offline.
Turn manual lookup, matching, and rule checks across Excel worksheets into an automated workflow that runs offline on the user's computer.
Synthetic demonstration · No business file uploads
Start with source worksheets
Buses & generation · Lines & equipment · Bus loads
| Type | Unit combination | Installed capacity |
|---|---|---|
| Hydro | 2 × 120 + 1 × 60 | 320 MW |
Look up, verify, fill
300 MW · Combination totalThe combination totals differ from the source's 320 MW. Generate the details and record the discrepancy.
Completed worksheets and review notes
| Generator | Capacity |
|---|---|
| Generator 01 | 120 MW |
| Generator 02 | 120 MW |
| Generator 03 | 60 MW |
The complete toolkit covers: 03 Bus Data · 04 AC Line Parameters · 05 Transformer Parameters · 06 Generator Parameters · 07 Bus Load Data
Manual workflow
Across multiple worksheets,
look up, check, and copy again.
Matching names is only the start. Check voltages, parse combinations, calculate parameters, and verify each completed result.
Automated workflow
Match data by rule.
Generate records and review notes.
Fill confirmed values automatically. Flag capacity differences, missing information, and ambiguous matches for review.
Three programs. Three distinct data tasks.
Program 01Bus & Generator DataExpand combinations and check capacity
03 Bus Data · 06 Generator Parameters
Match sources and calculate parameters
04 AC Line Parameters · 05 Transformer Parameters
Complete IDs, preserve original records
07 Bus Load Data