Utility Network Operations template
Network assets on a map with condition and inspection dates, supply points carrying contracted capacity, a validated smart-meter MAC address and a SEPA mandate IBAN, and an outage log that computes customer-minutes lost — the figure the regulator actually scores — from duration times customers affected.
Tables
Network assets
Asset, Type, Energy carrier, Rating, Capacity (MVA / MW), Position, Commissioned, Condition, Next inspection, Age (years), Renewal priority, Outages, Outages recorded, Minutes lost and 2 more
Supply points
Supply point, Fed from, Asset record, Energy carrier, Tariff group, Customers behind the point, Contracted capacity (kW), Annual consumption (MWh), Smart meter MAC, Direct debit IBAN, Connected, Load factor %, Notes
Outages
Reference, Asset, Asset record, Asset type, Cause, State, Planned, Started, Restored, Duration (minutes), Customers affected, Crew, Customer-minutes lost, Duration (hours) and 2 more
Views
- Network map (map)
- Asset register (grid)
- By condition (kanban)
- Inspection calendar (calendar)
- Outage board (kanban)
- Outage log (grid)
- Customer-minutes by cause (chart)
- Live outages (grid)
- Supply points (grid)
Forms
- Report an outage
Automations
- Notify the control room on a reported outage
- Email the regulator log on restoration
- Daily inspection-due check
- New record in “Network assets”
- “Outages” reached “Closed”
- Daily sweep — still open in “Outages”
- “Planned” was ticked in “Outages”
- Large value in “Capacity (MVA / MW)”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.