Quarry & Extraction Operations template
Concessions with licence expiry, permitted annual tonnage and remaining reserves; a daily production log that eats into both and computes recovery from extracted versus processed tonnes; and VIN-validated mobile plant with running hours against its service interval.
Tables
Extraction sites
Site, Name, Mineral, Status, Licence number, Licence expires, Opened, Position, Reserves (kt), Permitted per year (kt), Production log, Shifts logged, Extracted (t), Permit used % and 4 more
Production log
Reference, Site, Site record, Mineral, Date, Shift, Shift supervisor, Extracted (t), Processed (t), Waste rock (t), Blasting carried out, Recovery %, Recovery flag, Notes
Mobile plant
Asset tag, Type, VIN, Site, Site record, State, Engine hours, Last service, Service interval (h), Hours into interval, Notes
Views
- Site map (map)
- Concession register (grid)
- By status (kanban)
- Licence expiries (calendar)
- Production log (grid)
- Tonnes by site (chart)
- Production calendar (calendar)
- Plant board (kanban)
- Plant register (grid)
Forms
- Log a production shift
Automations
- Notify operations on a logged shift
- Email maintenance on a plant state change
- Daily licence and permit check
- “Mobile plant” reached “Breakdown”
- “Extraction sites” reached “Rehabilitation”
- Daily sweep — still open in “Mobile plant”
- “Blasting carried out” was ticked in “Production log”
- Large value in “Extracted (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.