Project · WRK-006
Workshop Inspection & Energy Board
An inspection and power-usage board for a machining workshop. It runs on the shop-floor screen, and inspections are filled in on a phone.
- React
- ECharts
- Python
- InfluxDB
- MQTT
Project background
Two production lines, twenty-odd machines. The power meters could already report data, but nobody was reading it. Inspections were still paper forms, filed at month end.
Problem
- The power bill kept rising, and nobody could say which machine or shift was responsible;
- Missed inspections only came to light after something broke;
- Management wanted a big screen, but not one that just looked nice.
Approach
Pull the meter data in and show it by line and by machine. Move inspections to QR codes on each machine, and flag overdue ones in amber on the big screen.
Key features
- Floor plan with each machine shown as running, idle or alert;
- Power usage by day and by shift;
- Scan-to-inspect: one QR code per machine;
- Overdue alerts pushed to the shift lead;
- Monthly Excel export of inspections and power usage.
Architecture
Meters report over MQTT through a gateway; a Python service writes to InfluxDB. React and ECharts on the front end, one API shared by the big screen and phones. Hosted on the factory's internal network.
What we handled
On-site data integration, dashboard design, front and back end, the inspection workflow, and the on-premise deployment.
How it went
Version one had far too many charts. The workshop manager said you couldn't read anything from three metres away. Version two kept the floor plan and one chart, with text twice as large.
Screenshots
Demo data. Machine names have been changed.
What went wrong
Wi-Fi on the shop floor is patchy, so phone submissions sometimes failed. We added local drafts that upload when the signal comes back (later turned into a standalone prototype in the Lab).
Outcome
The board revealed two air compressors idling overnight. After fixing that, the monthly power bill dropped noticeably, and overdue inspections now get caught the same day.
Current status
Live. Configuration changes when new machines arrive.
Next
The client is considering vibration sensors for simple early fault warnings.