0413 692 829 Book a chat

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.

42 profiles
BOM builds itself
Works offline
Illustration of a tradesperson measuring an outdoor louvred roof with a digital workbook
42 profile diagrams on dropdowns
11 job sheet tabs, one BOM
0 hand-tallied totals left
The problem

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.

What we built

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 it works

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.

The results

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 team
Get in touch

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





    We'll never share your details.