Download the files
Use the workbook and script above. The sheet calls itself synthetic inside the file.
Verify it yourself
Three small, checkable steps.
Run one command
Python 3 is enough. The script has no package install and makes no network request.
python3 trace_number.py sample-outbound.xlsx WK32!F4
Compare the result
The output below is captured from the downloadable script. It lists each input and checks the cached value.
Captured local output
A trace and a refusal.
A success alone is not evidence. The tool should also stop when the workbook does not contain a formula it can verify.
WK32!F4 - traced
A shared SUM formula is resolved, its three source cells are listed, and the recomputed total matches the cached value.
NETIE SOURCE TRACE File name: sample-outbound.xlsx Sheet: WK32 Figure asked: WK32!F4 Value (raw; display format not applied): 6480 Formula: =SUM(C4:E4) Inputs: - WK32!C4 = 2100 - WK32!D4 = 2400 - WK32!E4 = 1980 Recomputed from inputs: 6480 (matches cached value) Verdict: Traced I only used the local file you selected.
WK32!F7 - cannot be traced
This is a typed adjustment with no formula. The script refuses it and exits nonzero instead of inventing source rows.
NETIE SOURCE TRACE File name: sample-outbound.xlsx Sheet: WK32 Figure asked: WK32!F7 Value (raw; display format not applied): 6700 Formula: typed, no formula Inputs: - not available Recomputed from inputs: not applicable Verdict: Cannot be traced Reason: Selected cell has no formula. I only used the local file you selected.
Scope and limits
A narrow local-file check, stated plainly.
What it checks
- Local `.xlsx` and `.csv` files only.
- One cell at a time.
- A same-sheet `SUM(range)` formula with numeric inputs.
- Shared formulas, simple sheet-name matching, and cached-value comparison.
What it does not claim to read
- Display formatting, `.xls`, `.xlsb`, `.xlsm`, PDFs, images, or live systems.
- Pivot caches, merged-cell logic, cross-workbook links, or unsupported formula shapes.
- Client data, model output, security certification, audit opinion, or financial advice.
What this proves
This is the per-figure evidence format inside an Excel cleanup job.
For an agreed Excel or PDF set, the RM1,500 fixed-scope service returns a source map, findings, missing-data notes, and a concise presentation. It is decision support, not an audit, legal advice, or financial advice. The decision, file set, exclusions, and safe handoff are agreed in writing before checkout.