Method & Measure

Demo — Spreadsheet-to-app rebuild

JobBook

A trades firm quoting work, tracking jobs and chasing invoices from one workbook with six tabs and three people in it at once.

Everything here is editable and nothing is saved — it’s sample data in your browser. Click around, break things, reset.

Open pipeline
£16,550
quotes + accepted
Jobs in progress
2
Awaiting payment
£8,950
invoiced, not yet paid
Invoiced (6 weeks)
£29,930

New quote

Try giving it a reference that already exists — the workbook this replaces couldn’t stop you.

Jobs pipeline
RefClientJobValueStatusUpdated
Q-1041Harber & SonsWarehouse mezzanine handrails£4,850Quote sent15 Aug
Q-1040Fenwick DairyParlour gate refurbishment£2,100Quote sent13 Aug
Q-1039Bexley CouncilPlay-area fencing, phase 2£9,600Accepted14 Aug
Q-1038Orchard HomesBalcony balustrades, plots 4–9£12,400In progress9 Aug
Q-1037Harber & SonsLoading bay bollards£1,350In progress11 Aug
Q-1036Nested CoffeeCounter frame + shelving£3,200Invoiced8 Aug
Q-1035Kirkstall BreweryTank platform access steps£5,750Invoiced1 Aug
Q-1034Orchard HomesStaircase, plot 2£6,800Paid5 Aug
Q-1033Moor Lane GarageRoller-door frame repair£980Paid29 Jul
Q-1032Bexley CouncilPlay-area fencing, phase 1£8,900Paid22 Jul
Q-1031Fenwick DairyBulk tank frame£4,300Paid15 Jul
Q-1030Nested CoffeeOutdoor seating frames£2,650Paid8 Jul

Invoiced by week

Move a job to “Invoiced” and watch this week’s bar change. The table above is the data behind the chart.

£0£2,500£5,000£7,500£10,000w/c 13 Julw/c 20 Julw/c 27 Jul£10,000w/c 3 Augw/c 10 Aug£0w/c 17 Aug

Could this work for your business?

This demo was built from the same parts I use for real client apps. Tell me what your version would need to do and I’ll tell you what it would cost — usually within a day.