You do not need technical words to get started. Describe what is difficult and what you want to make easier. You can send a short inquiry without an account.
Have a complex or technical project? Describe it here. The listed packages are starting points. Larger spreadsheets are welcome; feasibility, size and complexity are reviewed before agreeing a custom scope and price.
To download a file, select its download link. It may open in your browser or appear in Downloads. If the browser asks, choose where to save it. A download is not a project order.
Real public data · A complete worked example
7,787 published lines from three monthly files now feed one numeric GBP ledger and a 1,260-group supplier-name view. 82 groups with case/spacing variants are grouped conservatively; every source line is retained.
These are published spending lines, including grants and transfers. Supplier-name groups support a review; they do not independently verify legal companies or comparable purchase prices.
The practical question
The prepared workbook keeps a route back to the original records and includes the checks and open questions. It is a worked example you can inspect, not a claim of client savings or a live operational system.
What the work involved
Keep source month and row number; align the December Expense Area header with the other months.
Decode the actual Windows-1252 files, parse UK dates and currency text, retain amounts to the penny.
A case/whitespace-only key joins spelling variants. Names with different punctuation or legal suffixes remain separate.
Keep repeated references and identical-looking lines; source # markers become explicit missing values rather than invented facts.
A ranked supplier total and monthly reconciliation are linked to every preserved source line.
Follow actual records
The two columns show the same information before and after. New calculations, group labels and questions appear separately beneath them. “[blank]” marks an empty field; the explanation says why. The full source records and the complete change log are included in the downloads.
Example 1
What changed or was added: The original amount was written as currency text. It is now stored as a spreadsheet number, with the same pound value. This makes numeric totals and sorting possible.
Example 2
What changed or was added: Only capitalization and whitespace are reconciled; distinct legal names are not guessed.
Example 3
What changed or was added: The day/month source is parsed explicitly before monthly totals.
Example 4
What changed or was added: The trailing space is removed before combining files, so the same category stays in one column.
Example 5
What changed or was added: The # marker is not treated as one shared transaction; the source row keeps its own traceable ID.
Checks you can inspect
| Check | Result |
|---|---|
| Original records | 7,787 |
| Prepared records | 7,787 |
| Records removed | 0 |
| Original total (GBP) | £11,541,454,677.32 |
| Prepared total (GBP) | £11,541,454,677.32 |
| Supplier-report total (GBP) | £11,541,454,677.32 |
| Additional identical-looking rows kept | 17 |
| Rows sharing an entity and transaction reference, kept | 958 |
| Logged transformations | 20,895 |
These checks verify the preparation and grouping rules. They do not certify the underlying source, prove a business outcome or settle the questions listed for review.
Open the complete deliverables
Start with the prepared workbook. Compare it with the original workbook, or use the CSV files to inspect every row in another spreadsheet app.
The files contain public source data and independently prepared analysis. Native Microsoft Excel testing has not been performed.
Use the result in context
Source & reuse
Department for Transport: spending over £25,000, October–December 2025. Contains public sector information licensed under the Open Government Licence v3.0. Department for Transport, 2026. Modified for this independent demonstration; no endorsement implied.
Prepared for this demonstration from the source downloaded 2026-10-08. Source details, transformations and limitations are included in the files.
Larger files and more involved reports are welcome. The $125 spreadsheet starter is one defined offer; other work is quoted by size and complexity after review.
Select a file link to open or download it. Check your browser’s downloads list or your device’s Downloads folder.
PDF: read it in your browser. XLSX or CSV: open it in a spreadsheet app. TXT: open it as plain text. You can read the example on this page without downloading anything.
If a file does not open, tell us the file name and what happened. Do not send private data in your first message.
Start with the result you need.
Spreadsheets · Instructions · Research