Who this is for
A small-business owner, office manager or finance administrator who relies on one Excel workbook and no longer trusts its totals, or cannot get past its error messages.
After rows were deleted, a sheet was copied or the file passed between people, cells show #REF! or #NAME? or the totals disagree with a hand calculation.
The result
Up to eight named output cells or ranges in the workbook return the answers you calculated independently for the agreed check cases, no formula error values remain in the agreed sheets, and a change log lists every formula we altered and why.
What is included
- One workbook of up to five sheets and up to eight named outputs, delivered as a repaired copy beside the original
- Find error values, formulas that break the pattern of their neighbours, numbers stored as text, circular references and formulas overwritten by typed values, using Excel's own error checking and dependency tracing
- Repair with the smallest change that restores the intended calculation, and ask you whenever the intent is not clear from the sheet
- Run the agreed check cases through the repaired copy and compare each output with your independently calculated answer
You receive
- A repaired copy of the workbook, with your original left untouched
- A change log listing each changed cell or range, the formula before and after, and the reason
- The check-case table with inputs, expected outputs and actual outputs, plus a list of any points that need your decision
What is not included
- Macros, add-ins, external data connections or links to files we cannot see
- Redesigning the model, adding new features, or restyling the layout
- Audit or assurance of financial statements, or any tax, accounting or financial advice
- Correcting the business figures typed into the workbook, as opposed to the formulas that use them
- Opening password-protected files without a route you are entitled to give us
What we need from you first
- What the workbook is for, how many sheets it has, and which outputs you do not trust
- The error messages you see (type only, such as #REF!) and when they started
- Two or three invented check cases with the answer you expect; no workbook in the first enquiry
Never send passwords, keys, customer records or confidential code in the first enquiry. Secure handover is agreed after scoping.
How we check it is done
- Each agreed check case, with its inputs entered in the repaired copy, returns every expected output value to the agreed number of decimal places.
- No cell on the agreed sheets displays an Excel error value (#REF!, #NAME?, #VALUE!, #DIV/0!, #N/A, #NUM!) unless it is listed in the change log as intended, and no error-hiding wrapper has been added without being listed.
- A comparison of the original and repaired copies shows that only the cells in the change log differ.
- After a full recalculation of all formulas, every checked output has the same value as before the recalculation.
You enter your own check case in the repaired copy, read the change log and confirm in writing that each repaired formula does what you meant. Payment follows sign-off.
When we would stop or decline
- The results depend on macros, add-ins or live data connections that we cannot run or see
- Nobody can say what the correct answer should be and none can be calculated independently
- The workbook is larger or more tangled than the agreed scope, and you do not want it re-quoted
- The file contains personal or confidential data for which no secure route has been agreed
Questions
Can you fix a workbook that uses macros?
Not under this price. Macro code is a different job. We can repair the ordinary formulas around it if the results do not depend on the macros.
Do you check that my numbers are right?
We check that the formulas do what you meant, using check cases you calculate independently. We do not audit your figures or give accounting advice.
Will you change my original file?
No. You get a repaired copy and a change log. The original stays as it is.
What if I do not know what a formula was meant to do?
We ask you about it and may suggest options. We do not guess the intent of a formula that affects your totals.
Price and terms
£195 · untested offer price. £195 after the agreed checks pass and you sign off. No payment before sign-off.
This is a new service with no published client results. The price is a starting point we have not yet tested with buyers. Nothing is ordered or charged by the enquiry. The full specification is on the Synthetic Industry catalogue.