Spreadsheet Rescue | Excel Data Cleanup Demonstration

NORTHFIELD DIGITAL / LIVE EXCEL WORKBOOK EXAMPLE

Spreadsheet rescue.
From chaos to clarity.

We took a fictional facilities-management export full of duplicate work orders, mixed currencies, inconsistent job statuses and missing figures — and turned it into a structured, formula-driven reporting workbook.

Discuss your spreadsheet See our dashboards

54Imported raw rows

48Unique work orders retained

6Duplicate rows removed from totals

3Unresolved source issues transparently flagged

01 / THE TRANSFORMATION

Before and after — the same work orders.

The input is preserved separately from the cleaned output. We normalise what can be verified, and flag the rest for the data owner instead of pretending to know the answer.

Before · inconsistent export

Work order	Date / area	Status	Value
WO-26004	01/04 · SOUTH	CLOSED	1080
WO-26004	01/04 · SOUTH	DUPLICATE	1080
WO-26008	31/02 · MIDLAND	OPEN	£1,300.00
WO-26016	05/03 · SOUTH	CLOSED	TBC
WO-26027	21/01 · Northern	Complete	£740 / cost blank

Inconsistent values and repeated records could mislead management reporting.

After · structured and traceable

Work order	Region	Status	Outcome
WO-26004	South	Completed	Unique & unpaid
WO-26008	Midlands	In Progress	Confirm date
WO-26016	South	Completed	Confirm invoice
WO-26027	North	Completed	Confirm cost

Corrected categories, unique work orders, live formulas and flagged exceptions.

02 / MANAGEMENT VIEW

A dashboard that answers real questions.

ILLUSTRATIVE FINANCIAL SNAPSHOT · COMPLETED WORK ORDERS

Known billed revenue£25,540

Recorded direct costs£15,309

Unpaid invoices£3,920

Validated gross margin£10,395

Figures above are calculated from the example workbook. The validated margin excludes records lacking a complete invoice-and-cost pair, so it is not simply total billed revenue minus all recorded costs.

03 / WHAT'S IN THE WORKBOOK

Useful output, not just formatting.

Cleaned and standardised records

Consistent work statuses and regions, editable inputs and validation dropdowns.

Automated analysis

Formula-driven outstanding amounts, margins, exception counts, monthly trends and regional comparisons.

Audit trail and handover

Source row references, duplicate reconciliation, unresolved values and clear usage instructions.

Demonstration transparency: All names, work orders and financial figures are fictional. This shows a working Northfield capability example, not a paid client project, audited saving or customer testimonial. The Excel workbook is available on request.

YOUR WORKBOOK NEXT?

Got an Excel file that's becoming a headache?

Tell us what it should be doing and we'll give you a clear, practical assessment of the fix, deliverables and proposed cost.

Tell us about your spreadsheet