Method & Measure

Services

Five ways to sort a process, end to end.

From how work arrives to what the numbers say. An audit is usually the sensible first step — and its fee comes off whatever you build next — but each of these stands on its own.

Spreadsheet & process audit

Before anything gets rebuilt, I map the process end to end — how work arrives, who touches it, where it stalls, and what the workbook holding it together actually does. Start with a single workbook, or have the whole process mapped: both fixed-fee, and the written report is yours either way.

audit — risk report
OrderStatusTotal1088PAID?£4201089chased 12/3#REF!1090see email£1,1500
📄 Risk report1 red · 2 amber · fix list attached

Single workbook audit

£180

  • Formula and link integrity check
  • Risk register: fragile areas, single points of failure
  • Written report with a prioritised fix list
  • 45-minute walkthrough call

Process audit

from £480

  • Everything in the workbook audit
  • Workflow mapping across the team
  • Duplicate/version risk assessment
  • Rebuild recommendation with costed options

Spreadsheet & process audit on the price list →

Spreadsheet-to-app rebuild

The workbook's job, done properly: validated forms instead of free-typed cells, one shared source of truth instead of six copies on email, and an audit trail of who changed what.

orders — new entry
Total: £1,1500
Not a number — did you mean £1,150? Caught at the door, not in the VAT return.
Total: £1,150✓ Saved
Logged: marc · today 14:02 · created order 1107

Data rescue

£850

  • Schema design and data migration
  • Validated entry forms
  • Search, filter and CSV export
  • Single shared login

Working app

£1,600

  • Everything in Data rescue
  • User accounts with roles
  • Status pipeline for your workflow
  • Live dashboard and reports
  • Audit trail of every change

Bespoke system

from £3,500

  • Everything in Working app
  • Multiple linked workflows
  • Email/PDF generation, notifications
  • Integrations (accounting, calendars, APIs)
  • Phased delivery with a working app at each stage

Spreadsheet-to-app rebuild on the price list →

Many spreadsheets, one app

Orders in one sheet, invoices in another, and Dave's copies of both on his desktop. I merge the overlapping workbooks into one app: deduplicated, reconciled, one version of the truth the whole team shares — with a retirement date for every sheet it replaces.

consolidation — 3 workbooks in
orders_v3.xlsx
invoices JUNE final.xlsx
copy of orders (Dave).xlsx

Orders & Invoices

✓ 142 duplicates removed · 9 conflicts flagged for review · one source of truth

Consolidation build

from £1,900

  • Workbook inventory and overlap map
  • Dedupe and merge with a conflict report
  • One app — user accounts, roles, audit trail
  • Retirement plan for every sheet it replaces

Many spreadsheets, one app on the price list →

Reporting & dashboards

The numbers someone re-assembles by hand every month, live on a screen instead — connected to the systems you already run, with drill-down and a scheduled email summary.

dashboard — this month

Sales

£18,240

Overdue

£2,310

✉ Summary emailed Monday 08:00 — nobody assembles this by hand.

KPI dashboard

from £950

  • Connect to your existing sources
  • Agreed KPI set with drill-down
  • Filters by period, site, person
  • Scheduled email summary

Reporting & dashboards on the price list →

Data cleanup & automation

The steps between systems that a person currently is — exports, re-keying, chasing, reconciliations — done by software on a schedule, with validation and an alert when something doesn't add up.

nightly run — 02:00
exportvalidateload
⚠ 2 rows rejected — held for a human, not silently loaded.
✓ 1,418 rows loaded in 41snext run 02:00

Automated workflow

from £450

  • Source/destination mapping
  • Validation with a rejects report
  • Scheduled runs with alerting
  • Runbook so your team owns it

Data cleanup & automation on the price list →

Add-ons

Things worth adding.

Priced separately so they stay a decision rather than an assumption. Any of them can go into a new build or onto a system you already run.

Additional workflow£350
Another process brought into the same app.
Legacy data cleanup£300
Historic data de-duplicated and migrated, not just current rows.
Team training session£250
Half-day on-site or remote session for your staff.
Branded documents£280
Quotes, invoices or reports generated as branded PDFs.

Where to start

Start where it hurts most.

A project can stop after any stage or carry on as confidence builds. Begin with the £180 audit and that fee comes off the build if you go ahead, so the only thing you commit to up front is finding out what the problem actually is.

Describe your processSee every price