Every power tool, test meter and ladder carries a QR sticker. Electricians scan it with their phone camera to sign the tool out to a site or back in, and the stores lead gets a Monday list of overdue tools and instruments due for calibration.
Typical results
Under 15 sec
To sign a tool out or back in
≈2 hrs/wk
Stores time saved on hunting for tools
Monday
Overdue and calibration-due list to the stores lead
Figures reflect typical results for this kind of automation.
The challenge
An electrical contractor owns hundreds of drills, cable pullers, test meters and ladders shared across 30 electricians and many sites. Nobody knows who took what, so tools are left on finished sites, bought twice or found broken when needed. Test meters slip past their calibration date, which puts test certificates issued with them in doubt.
Before and after
Tools lost or missing per year
−50%Minutes to find who has a given tool
−97%The automation
Each tool gets a QR sticker linked to its row in a Google Sheets tool register, with its serial number and calibration date. An electrician scans the sticker with a phone, picks their name and the site, and the register shows who has the tool and where. Scanning it again at the store marks it returned, with any damage note. Every Monday, the stores lead gets a list of tools out over 14 days and meters due for calibration.
How it works
- 01
QR sticker on every tool
Each power tool, test meter and ladder gets a QR sticker linked to its row in the tool register, with its serial number and calibration date.
- 02
Scan to sign out
An electrician scans the sticker with the phone camera, picks their name and the site, and the register shows who has the tool and where.
- 03
Scan to return
Back at the store, the same scan marks the tool returned, with the date and any damage note or photo the electrician adds.
- 04
Monday list to the stores lead
Every Monday, the stores lead gets a list of tools out for more than 14 days and test meters due for calibration within a month.
Starts from
- QR sticker on each tool
- Phone camera scan
Delivers
- Who has each tool, and where
- Monday overdue tools list
- Calibration due flagged
The impact
Tools lost or missing drop by about half, from around 40 a year to 20, because every tool has a recorded holder and site. The stores lead finds any tool in a minute instead of half an hour of calls, and no test meter is used past its calibration date unnoticed.
Questions about this automation
What happens when a tool is handed over on site?
The electrician receiving it scans the same sticker and signs it out to themselves. The register moves the tool to the new holder and keeps the handover in the history, so the stores lead can see the full chain if a tool goes missing later.
Does scanning need a special app?
No. The phone's normal camera reads the QR code and opens a short web form already filled in with that tool. The electrician only picks a name and a site, so a sign-out takes a few seconds. Simple automations like this are usually live within days of the stickers going on.
How are calibration dates kept up to date?
Each test meter's row holds its last calibration date and interval. When a meter comes back from the calibration lab, the stores lead scans it and enters the new certificate date, which resets the countdown. Meters due within a month appear on the Monday list, so they go off for calibration in time.