Digital Check Measure Workbook Case Study
Paper pack out,
smart workbook in.
An Australian manufacturer of custom outdoor roof systems had measurers filling in an 18-page paper pack by hand on every site visit. We rebuilt it as one smart Excel workbook. It drops in the right diagrams, captures the measurements and writes the bill of materials on its own.

Every job started with a pen and ended with retyping.
Every install starts with a check measure. The measurer took a printed pack to site, sketched flashing profiles by hand and wrote dimensions next to them. Back at the factory, someone decoded the sketches, re-added every quantity and built the bill of materials by hand. Slow, and only as good as the handwriting.
Before (18 paper pages): Hand-sketched on site, then decoded and re-added back at the factory.
Now (1 workbook): Diagrams drop in from a dropdown and every total calculates itself.
Same forms they know. Now they do the maths.
No new system to learn. It’s still Excel.
A digital diagram library
We pulled all 42 sheet metal profiles out of their old Word documents, cleaned them up and wired each one to a dropdown. Pick a type and the diagram appears, dimensions and all.
Order sheets that match how they work
The same forms they’ve always used, now with colour-coded slots, A to F measurement cells and photo uploads for site plans. Custom profiles work too.
A bill of materials that writes itself
Every tab totals into one BOM. Lengths convert to lineal metres, counts stay counts, and matching flashings combine into a single line.
How the digital check measure workbook works.
1. On site. The measurer opens the workbook.
2. Pick a profile. 42 diagrams, one dropdown.
3. Type the sizes. A to F cells under each diagram.
4. Totals calculate. Lineal metres and counts, live.
5. BOM ready. One tab, ready for the factory.
What changed for the factory.
Same forms, same Excel. The maths and the bill of materials now do themselves.
Nothing new to learn
The crew opens a file, picks from dropdowns and types numbers like they always have.
Works offline
It runs on the measurer’s laptop with no internet needed, then syncs through OneDrive back in range.
Custom jobs covered
There’s a Custom option in every dropdown. Paste in a photo and the quantities still flow through.
Easy to extend
A new profile is one image dropped in a folder and one name added to a list.
Still running on paper forms?
Measure sheets, job cards, order books. If your team fills something in by hand and someone back at the office keys it in again, you’re paying for that work twice. We can rebuild the forms you already use so they total, check and file themselves.
Talk to our teamMore AI case studies and services.
See what else we’ve built, or how we can help your business with AI.
Looking for the most honest IT support on the Northern Beaches?
Tell us a bit about your business and we’ll come back with a plan, usually within one business day. No pressure, no jargon.
- 0413 692 829
- Northern Beaches · Sydney-wide & remote support Australia-wide
- Mon–Fri · 8:30am–5:30pm
