Water & Waste Operations template
Permitted facilities with their permit number, expiry and annual tonnage allowance — each tagged with its own NACE activity code — the collection rounds feeding them on VIN-validated vehicles, and weighbridge tickets that compute the recycling rate per load and draw down the permit.
Tables
Facilities
Facility, Name, Type, Activity (NACE), Permit number, Permit state, Permit expires, Permitted per year (t), Position, Commissioned, Weighbridge tickets, Tickets recorded, Tonnes accepted, Tonnes recovered and 4 more
Collection routes
Route, Waste stream, Tipping point, Facility record, Facility activity (NACE), Frequency, Vehicle VIN, Containers on round, Households served, Driver, Containers per 100 households, Weighbridge tickets, Tonnes collected, Notes
Weighbridge tickets
Ticket, Route, Route record, Waste stream, Facility, Facility record, Date, Gross (t), Recovered (t), Contamination %, Recycling rate %, To disposal (t), Load flag, Notes
Views
- Facility map (map)
- Permit register (grid)
- By permit state (kanban)
- Permit expiries (calendar)
- Weighbridge log (grid)
- Tonnes by facility (chart)
- Ticket calendar (calendar)
- Rounds by stream (kanban)
- Route register (grid)
Forms
- Record a weighbridge ticket
Automations
- Notify the gatehouse on a new ticket
- Email compliance on a permit change
- Daily permit headroom check
- “Facilities” reached “Suspended”
- Daily sweep — still open in “Facilities”
- Large value in “Gross (t)”
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.