Find the outcome you need.
Start with a symptom, a platform or the thing you want working.
With JavaScript, search filters the whole collection in your browser. Without it, use the linked pages and section navigation below; query filters need JavaScript.
Showing entries 1–40 of 56 in this first collection.
Composed outcome
Turn one scanned and old-format file archive into an organised, searchable collection
You scan the paper. We turn the scans and your old Office files into one organised, searchable collection, with a manifest and a spreadsheet index, for an agreed inventory.
From £2,450 · untested offer price
One-off outcome
Rename and sort one folder of files into a clear structure, with a manifest
A folder of badly named files, handed over by an agreed secure route, is copied into an agreed naming scheme after you approve a dry run. A manifest has a row for every file and shows none changed.
From £245 · untested offer price
One-off outcome
Convert a batch of old .doc and .xls files to current formats and check them
Every old Word and Excel file in one folder is converted to a current format in a parallel folder structure, with a log of what converted, what did not and a sampled check against the original.
From £295 · untested offer price
Recurring responsibility
Have each month's batch of same-layout PDFs turned into checked spreadsheet rows
Each month's PDFs in one agreed layout are extracted into your workbook with a page or file reconciliation and an exceptions list, so nobody retypes them.
From £395/month · untested offer price
One-off outcome
Collect the answers from a batch of filled-in PDF forms into one sheet
The values typed into a batch of fillable PDF forms from one template arrive as one spreadsheet, one row per form, checked against the field list, with unreadable files listed.
From £245 · untested offer price
One-off outcome
Turn a text-based PDF price list into one checked spreadsheet
One PDF price list in one layout becomes one spreadsheet whose row counts match the source page by page. Every row we could not read with confidence is listed for you to decide.
From £295 · untested offer price
One-off outcome
Make a batch of scanned PDFs searchable and test it with terms you choose
Image-only PDFs in one folder get an added text layer, with originals kept. A search test of terms you choose is held to a floor agreed in writing beforehand, and poor pages are listed.
From £195 · untested offer price
One-off outcome
Produce a batch of customer quotations from your price list and briefs
Each customer brief (a reference, item codes and quantities) becomes one checked quotation in your template, with totals worked from your price list and rules and a proof sheet of every calculation.
From £495 · untested offer price
Recurring responsibility
Get your weekly or monthly report pack built from your standard export
Each period we turn the export you send into the same formatted report pack, check its totals against the export and note anything odd, month after month.
From £295/month · untested offer price
One-off outcome
Turn a merged-cell Excel report into a flat table you can sort and pivot
One sheet of merged cells, repeated headings and subtotal rows becomes a flat table with one row per record, whose row count and totals reconcile with the original.
From £145 · untested offer price
Composed outcome
Make one set of messy workbooks clean enough to import, analyse or hand over
A defined set of inherited workbooks is repaired, flattened and date-fixed into consistent tables that pass a column-by-column readiness check you can use before any import.
From £1,500 · untested offer price
One-off outcome
Fix mixed date and decimal formats in one spreadsheet or CSV export
Dates typed as text, day-first and month-first entries mixed together, and comma or point decimals become real dates and numbers. Ambiguous rows are listed, not guessed.
From £125 · untested offer price
One-off outcome
Merge duplicate rows in one product, part, asset or company list, with a review file
One list of items, parts, assets or companies, with no personal data, is checked against written rules. Clear duplicates are merged with a log; uncertain pairs stay separate for you to decide.
From £195 · untested offer price
One-off outcome
Repair the broken formulas in one Excel workbook so its totals check out
The error values and wrong totals in one workbook are traced and fixed until your agreed check cases return the answers you calculated by hand, with every change listed.
£195 · untested offer price
One-off outcome
Make new Facebook leads appear in Salesforce again
A new synthetic lead submitted to the agreed Facebook form starts one Zap and creates one Salesforce test lead with the agreed fields.
£165 · untested offer price
One-off outcome
Send every mapped Google Sheets invoice field to Xero
One disposable row with the agreed columns makes one draft Xero invoice containing every agreed line item and amount.
£145 · untested offer price
Buyer collection
For a finance manager: make an invoice integration complete and safe to repeat
Define authoritative fields, duplicate rules and reconciliation before repairing a spreadsheet-to-accounting automation.
Troubleshooting guide
A Zap runs, but fields are missing: trace the value from trigger to destination
Inspect one synthetic record through each step and separate missing input, transformation, permissions and destination validation.
Troubleshooting guide
One Sheets row becomes one Xero invoice line: check the line-item shape
Distinguish missing spreadsheet headers from multiple products mapped into one invoice line, using a disposable two-product acceptance case.
Free tool
Workflow time-value calculator: show the assumptions behind automation payback
Use your own time, volume, cost and running-cost inputs to calculate simple monthly value and payback; not a quote or guaranteed saving.
Troubleshooting guide
A Zap created the record twice: find which of five causes it was
Count the runs, then check for a second Zap on the same trigger, a self-trigger, a replay and a plain create step before you change anything.
Troubleshooting guide
A Zap stopped or shows Errored or Halted: what each status means and what to replay
Read the run status first, understand why a Zap turns itself off, and know what a replay repeats and why error emails can arrive hours late.
Platform
Zapier automations: what repeats, what stops and who is told
The documented behaviours behind duplicate records, switched-off Zaps, late alerts and scheduled runs, and which outcome fits each problem.
Inspectable example
Synthetic price list: a page-by-page row count that finds two mistakes a matching total hides
An invented three-page price list shows why rows are counted per page. A first extraction matches on the total, 14 of 14, while page 1 is a row short and page 2 has an extra row.
Inspectable example
Synthetic merged-cell report flattened: nine rows in, five records out, every total reconciled
An invented printed-style sales report with merged region labels, subtotal rows and a spacer becomes a flat five-record table, with a reconciliation showing 9 original rows = 5 records + 4 removed.
Inspectable example
Synthetic quotation: why the same three lines total 4.38 or 4.39 depending on the rounding rule
Three invented lines of 1.30 plus a 12.5 per cent add-on give 4.38 if the add-on is rounded per line and 4.39 if it is rounded on the total. The rule must be written down.
Inspectable example
Synthetic rename manifest: three clean renames with matching checksums and four held names
An invented seven-file folder shows a dry run and a manifest with a row for every file, with three renamed files whose checksums match, and four held, a pair of names that differ only in letter case, a reserved device name and a name ending in a period, all listed, not guessed.
Inspectable example
Synthetic date column: which rows a rule can settle, and which must stay on the ambiguity list
Nine invented entries show day-first and month-first typing, a two-digit year, a row where only one reading is possible, an impossible date and a four-year shift, with the decision and reason for each.
Platform
PDF documents: getting data, forms and searchable text out of office files
For office managers and administrators with PDF price lists, filled forms and scans: how to tell which kind of PDF you have, how to check what is extracted and where a paid, checked job fits.
Platform
Microsoft Excel workbooks: repair, tidy and make them reliable
For administrators and small businesses who rely on Excel: where workbooks go wrong, the order to diagnose them in, and the checked, fixed-scope jobs that repair formulas, flatten layouts and clean dates and duplicates.
Buyer collection
For an office manager: sort your PDF, scan and old-file jobs into do it yourself, buy, or leave
List the jobs by what the file actually is, find the ones your own software already handles, and ask for outside help only where volume, repetition or the need for a checked record justifies it.
Buyer collection
For an operations lead: stop rebuilding the weekly report by hand, or decide to hand it over
Work out what the report actually costs you in steps, put the method in writing, decide whether to template it yourself or hand it over, and choose checks that show each pack matches its export.
Collection
A messy workbook: the order to diagnose it in, and where each fix leads
Seven checks in a fixed order, from stale calculation to import readiness, each pointing to the guide that explains it and the checked job that covers it if you would rather not do it yourself.
Collection
From a PDF to a checked spreadsheet: the order of questions that saves the most effort
Seven steps from "does it have text?" to "who signs off the exceptions?", linked to the guides, the worked example and the checked jobs, including what to do when the same document arrives every month.
Troubleshooting guide
Excel shows #REF! or #NAME?: work out which kind of broken formula you have
Each Excel error value points to a different kind of break. Learn what they mean, how to trace a formula back to its inputs, and why hiding the error is not a repair.
Troubleshooting guide
Totals look wrong but Excel shows no error: stale calculation, text numbers and displayed versus stored values
When no error appears, three quiet causes explain most wrong totals: manual calculation, numbers stored as text and rounding that is displayed but not stored. Here is how to tell which.
Troubleshooting guide
Merged cells stop Excel sorting and pivoting: how to flatten a printed-style report safely
Merged group labels, spacer rows and subtotal lines make a report readable on paper and unusable as data. See what merging does, what a flat table needs and how to prove nothing was lost.
Troubleshooting guide
Dates sort wrongly or change between computers: serial numbers, text dates and day-month order
Excel stores dates as numbers and reads typed dates through regional settings. Learn how text dates, a four-year offset and day-first entries produce wrong sorting, and what to do with rows that cannot be settled.
Troubleshooting guide
Cleaning duplicates in a contact list: write the match rules before you delete anything
Removing duplicates is a set of decisions, not a button. Compare exact and near matches, avoid merging people who only share a field, and keep a log so every merge can be undone.
Troubleshooting guide
Old .doc and .xls files: what converting really changes and how to check a whole batch
Converting one old Office file is easy. Converting a folder needs an inventory, copies instead of overwrites, a decision about macros and a check that the new files match the old.