- Home
- Skills
- Finance & Accounting
- Excel Formula Trace Shows What Really Drives Any Cell
Works with the AI Agents you already use
Excel Formula Trace Shows What Really Drives Any Cell
Walks any Excel cell back through every precedent into a readable tree, plus the typed inputs it rests on and the risks on the way.
Free
Excel Formula Trace Shows What Really Drives Any Cell
Example session with this skill installed
I inherited this workbook and need to know what really drives P&L!B19. Trace it four levels deep, show me the inputs it rests on, and flag anything risky on the chain.
- Read your context and instructions
- Compiled the excel formula trace
Formula trace, P&L!B19
Value 937.5, formula =B12-SUM(B15:B17).
Dependency tree
P&L!B19 =B12-SUM(B15:B17)
├─ P&L!B12 =B9-B11
│ ├─ P&L!B9 =SUM(B5:B7)
│ │ ├─ P&L!B5 1000
│ │ ├─ P&L!B6 1250
│ │ └─ P&L!B7 1500
│ └─ P&L!B11 =B9*0.42
│ └─ P&L!B9 (already shown above)
├─ P&L!B15 =B$9*0.11
│ └─ P&L!B9 (already shown above)
├─ P&L!B16 =B$9*0.11
│ └─ P&L!B9 (already shown above)
└─ P&L!B17 =B$9*0.11
└─ P&L!B9 (already shown above)
Inputs this figure depends on
| Cell | Value | Format |
|---|---|---|
| P&L!B5 | 1000 | general |
| P&L!B6 | 1250 | general |
| P&L!B7 | 1500 | general |
Risks on the chain
None. No errors, volatile functions, missing sheets or cycles on the traced path.
Sheets touched are P&L.
Read-only trace. Nothing in the workbook was modified.
Connects securely to your tools. The creator never sees your data.
About this skill
Tracing a figure in an inherited spreadsheet means following precedents one cell at a time, and Excel shows them one arrow at a time.
Excel Formula Trace does it in one pass. It returns a dependency tree you can read, the register of typed inputs the figure actually rests on, and the risks hiding on the chain.
What you get
Given P&L!B19 in the demo workbook, it returns:
P&L!B19 =B12-SUM(B15:B17)
├─ P&L!B12 =B9-B11
│ ├─ P&L!B9 =SUM(B5:B7)
│ │ ├─ P&L!B5 1000
│ │ ├─ P&L!B6 1250
│ │ └─ P&L!B7 1500
│ └─ P&L!B11 =B9*0.42
│ └─ P&L!B9 (already shown above)
├─ P&L!B15 =B$9*0.11
│ └─ P&L!B9 (already shown above)
├─ P&L!B16 =B$9*0.11
│ └─ P&L!B9 (already shown above)
└─ P&L!B17 =B$9*0.11
└─ P&L!B9 (already shown above)
Then the input register, with values and number formats, and the risks found along the way.
- circular references, marked where the loop closes instead of hanging
- volatile functions that make the figure irreproducible
- error cells feeding the total
- references to sheets that no longer exist
- cross-sheet hops, so you can see when a simple line item is really three sheets deep
Why this one is free
It is the free companion to the Excel Model Audit skill. The audit finds the defect and the trace shows you why. Use it on its own as long as you like. There is no account, no limit and no upsell in the output.
The free Excel add-in
OpenCode for Excel is a free, open source Microsoft Excel add-in from the same toolkit. It adds chat, workbook analysis and reviewable edits to Excel, with every model call going to your local OpenCode service. Source and Windows setup are at https://github.com/analystsandeep/opencode-excel-addon.
Safe by construction
Read-only, standard library only, no network, no environment reads, VBA never executed. The workbook is byte-identical after a trace, and the self-check asserts it.
Use it
python3 trace.py "/abs/path/model.xlsx" "P&L!B19" --depth 4
Requires Python 3.9+ with code execution. One file, standard library only, no packages to install.
Read-only. Traces precedents, not dependents. It does not recalculate the workbook and reads the values stored in the file. Requires Python 3.9 or newer with code execution.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 7 days ago
- Free with an Agensi account
Requires
Permissions
File Scopes
Reads one workbook and prints a report. It never writes to the workbook, runs VBA or makes network calls.