Method & Measure

Method for your processes. Measure for your numbers.

Somewhere in your business there’s a process held together by a spreadsheet everyone’s afraid to touch.

The life of one spreadsheet

Somewhere in your business…

MASTER_orders — DO NOT TOUCH.xlsx
OrderClientStatusTotal
1088Harper LtdPAID?£420
1089Brook & Cochased 12/3#REF!
1090fenwick??see email£1,1500
🔒 Ask Dave before editing. Dave is on holiday.

Every team has one — the workbook the whole business quietly runs on. This is its story.

Three years making data and reporting trustworthy, in places that can’t afford wrong numbers.

A local authority’s children’s services, then private healthcare — databases, dashboards, and the workbooks that held them together.

Sales before software: trained to hear what’s needed, not to sell what’s biggest.

Marc’s full background

Start to finish

How an engagement runs.

Five stops, start to finish — tap a stop, or swipe the card.

Audit

week one

I walk the process end to end, and the workbook holding it together. You get a written report either way. If a repair in Excel is all it needs, it's priced in the report and you can stop there.

audit — where the process really lives
orders.xlsx — 14 tabs
invoice tracker (Dave’s copy)
email chains, post-its, memory
✓ 1 process, 7 steps, 3 owners
✓ 42 formulas mapped, 3 load-bearing
Written report — yours either way

The offering

What Marc does.

Six services, covering everything between taking work in and reading the numbers out. Most engagements start with the audit; none of them depends on it.

  • Spreadsheet & process audit

    Map the process end to end before anything gets rebuilt.

    from £180

  • Spreadsheet repair

    Keep it in Excel and make it reliable: formulas fixed, new years that just work.

    from £450

  • Spreadsheet-to-app rebuild

    The workbook's job, done properly — validated, shared, audited.

    from £850

  • Many spreadsheets, one app

    Overlapping workbooks merged into one source of truth.

    from £1,900

  • Reporting & dashboards

    The month-end numbers live on a screen, not rebuilt by hand.

    from £950

  • Data cleanup & automation

    The copying and chasing between systems, done on a schedule.

    from £450

What each one includes, and what it costs

Before and after

What actually changes.

The useful logic in your workbook survives. The scaffolding people built around it to keep it upright is what goes.

orders_FINAL_v8.xlsx✗ autosave failed
fx  =IF(VLOOKUP(A2,Sheet3!$B:$F,4,0)>0,… — do not touch, ask Dave
OrderStatusTotal1088PAID?£4201089see email#REF!1090chased 12/3£1,15001091Dave’s copy£680?
3 copies open · totals disagree by £240
Orders — signed in as marc● live
Total: £1,150✓ Saved

This month

£18,240

Overdue

£2,310

marc · today 14:02 · order 1107 saved — every change logged
BeforeAfter

Drag the divider — same order, same total, different morning.

  • Six versions of the workbook one controlled set of records.

    I inventory the copies, map the overlaps and find the real source of truth — with a retirement date for every sheet it replaces.

  • Updates copied between sheets and inboxes statuses anyone can see.

    I turn the informal handoffs into explicit owners: what's happened, what's waiting, and whose turn it is.

  • A rebuild everyone's afraid to start a switchover on a date you picked.

    I prototype the shape early and run the new system alongside the old one until the outputs already match.

The numbers

Four numbers to start from.

No “book a call to find out”. And if you go on to an app, a dashboard or an automation, £180 of the audit comes off it, so you don’t pay twice for working out what to do.

Start with an audit
from £180
A fixed fee agreed before anything starts, and the written report is yours whatever you do next.
Repair it in Excel
from £450
The budget option: formulas fixed, new years that just work. Priced exactly in the audit report.
Or a working app
£1,600
One process rebuilt properly — forms, roles, reporting, audit trail.
Keep it running
from £59/mo
Optional. Every build hands over complete either way.

Every price, and an estimatorHad the audit already? £180 comes off an app, dashboard or automation.

Who's behind it

Who you’d be dealing with.

Marc, start to finish: the person who audits your process is the person who builds the app and answers the phone afterwards. Every engagement opens with an audit, because working out what’s actually needed comes before building any of it.

The practice stays small on purpose, and the tools are deliberately boring, because boring is what’s still running in five years.

The longer version, and how an engagement runs →

Asked every time

Straight answers.

Our spreadsheet is a mess. Is that a problem?
It's the normal case, and I've unpicked plenty of them. Messy workbooks are usually messy because the business grew around them — that history is useful, and the audit is designed to read it rather than judge it.
What if we only want the audit?
That's a complete engagement in itself. You get the written report and the costed options, and the report stands on its own — it's yours whatever you decide to do next.
Can you fix our spreadsheet without replacing it?
Yes. After the audit you get a choice: a repair that keeps it in Excel and makes it reliable (formulas fixed, new months and years that just work, dropdowns and checks that catch mistakes), or a small app if it has outgrown a spreadsheet. The repair is priced as a fixed fee in the report, along with my honest recommendation.
How much does it cost to have a spreadsheet checked?
A single workbook audit is £180, fixed. You get a written report with a prioritised fix list and a 45-minute walkthrough call, and it's yours whatever you decide next.
Is our data kept confidential?
Yes. Your files are used only for your project. I'm happy to work from an anonymised copy with names swapped for IDs, and I only use AI tools on your material with your agreement, once names and personal details are removed. When the work is signed off, I don't keep anything that identifies your people.
Can our team keep using Excel for some things?
Yes — and they should. Excel is excellent at one-off analysis. The rebuild targets the workbook being used as a shared database, which is the job spreadsheets are worst at. Every app I build exports clean CSV back to Excel.
How disruptive is the switchover?
The app runs alongside the spreadsheet until you're confident, and I migrate your existing data in as part of the build — including the historic rows. Cutover is planned as a morning's work, not a month of parallel running.
Who owns the finished app?
You do — the code, the data and the hosting account. The rest of the procurement answers are under Security and ownership.
Where does our data live?
Wherever you choose to run it: your own server, hosting I run for you, or a box in your building. Security and ownership has the detail.

Get started

Tell Marc about the process — or just the spreadsheet.

Two sentences is plenty to start. If it’s easier, email marc@methodandmeasure.co.uk — and if you’d rather show than tell, Marc will sign an NDA before you send anything.