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.

3 tables · 9 views · 1 form · 8 automations · sample rows included, so it opens looking like a working app

Use this template

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

Forms

Automations

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.

More Energy & utilities templates

All templates