Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Excel Formula Trace Shows What Really Drives Any Cell

    2

    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

    1 useSecurity scanned
    Excel Formula Trace Shows What Really Drives Any Cell

    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

    CellValueFormat
    P&L!B51000general
    P&L!B61250general
    P&L!B71500general

    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.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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 to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 7 days ago

    • Free with an Agensi account

    Software
    Python 3.9 or newer

    The workbook is read-only. Pass the full path and the sheet name explicitly, for example P&L!B19.

    Permissions

    Terminal / Shell
    Read Files

    File Scopes

    *.xlsx
    *.xlsm

    Reads one workbook and prints a report. It never writes to the workbook, runs VBA or makes network calls.

    Listed7 days ago

    What's inside

    Frequently Asked Questions

    No. It reads the .xlsx or .xlsm file directly and never opens Excel.

    No. The workbook is read-only and stays byte-identical after a trace. The self-check asserts it.

    Yes. It follows cross-sheet references and shows each hop in the tree. External workbook links are flagged rather than opened.

    It traces precedents, the cells a formula depends on. It does not list dependents, recalculate the workbook or fix anything. It also does not open legacy .xls files.

    No. There is no network code in the package, and it reads no environment variables.

    New in Finance & Accounting

    Free