Understand any Excel model
you didn't build.
FormulaMapper is a Microsoft Excel ribbon add-in that reads any workbook you open and answers the questions that take an analyst hours: what does this formula do, what's broken, where are the hidden hardcodes, how clean is this model? - every answer ties back to a cell, so it's auditable, not a black box.
The account-linked add-in is not ready to download yet.
Downloads, new trial starts and subscriptions are paused until the compatible Windows and Mac build passes the verified-account activation tests.
Visiting this page does not start a trial. The planned terms are an 11-day trial followed by ₹799 per month, but no payment is currently accepted.
Ask about early accessExplain
Understand
Check
Two features do the heavy lifting.
The Formula Tree makes any single formula readable. The Color Map makes a whole sheet's logic visible. Everything else builds on these two.
See the logic, not just the result.
Press Ctrl+Q on any cell and FormulaMapper draws its precedent tree - every operand, function and cross-sheet reference as a node you read top-to-bottom. Understand and visualise a formula's logic in seconds, instead of squinting at five nested levels by hand.
- Each node shows its live value and role
- Click a node to highlight the fragment and jump to its cell
- Drill into any reference to see its formula too
See the whole sheet at a glance.
Map Sheet colours every cell by what it is - inputs, unique formulas, copied-down, copied-across, text - so the model's structure and formula flow jump off the screen. The odd one out is the cell that's the wrong colour: a broken pattern or a hardcoded number you'd never catch by eye.
- Visualise how calculations flow across the sheet
- Inconsistencies and hardcoded cells stand out instantly
- Map several sheets at once - each keeps its own colour key
Review Formula
Pops up the active cell's formula and an expandable precedent tree. Each node shows its live value and role; click to highlight that fragment and jump to the source cell, and the formula bar follows you as you go deeper. Drill into a reference to see its formula - and when a range mixes formulas, every distinct one is surfaced so nothing hides.
Why it matters: stop scrolling a 5-level-deep formula by hand.
Onboarding Brief
For a workbook you didn't build: one click produces a plain-English brief covering what the model does, its key outputs, the calculation drivers, a suggested sheet read-order, and the riskiest cells. It turns "where do I even start?" into a guided tour.
Why it matters: no incumbent does this - it owns the inheritance job.
Sheet Map + Contents
Renders how the workbook's sheets reference each other as a colour-coded node diagram - hover or click a sheet to light up its relationships. And generates a hyperlinked index of every sheet, named range, and table.
Why it matters: see the architecture before you trust the numbers.
Risk Dashboard
Scans the active sheet and lists every quality issue in one panel - circular refs, errors traced to their origin, inconsistencies, hardcodes, broken external links, volatiles, SUM-gaps and sign checks - sorted worst-first. Click any issue to jump to the cell and highlight it.
Why it matters: findings live in the workbook and drive action - not a detached PDF.
Stress Test + Compliance Score
Perturbs each input (0, negative, blank, ×10, sign-swap) and reports which outputs break, error, or go negative - automating "save a copy and see what moves." And scores the sheet 0–100 against FAST/SMART-style modelling standards with a grade and concrete recommendations.
Why it matters: checks behaviour, not just structure - the costliest error class.
Export HTML Report
Writes a self-contained HTML quality report next to the workbook and opens it. Shareable with reviewers, auditors, or your team without sending the original file - handy when the model itself is confidential.
Why it matters: a tidy, sendable artifact for sign-off and review.
Review Panel + Notes
Drop a structured review note on any cell (Ctrl+Shift+N) - category, status and comment. The Review Panel gathers them all with a coverage map, Sign as Preparer / Reviewer, and one-click export - and writes an auditable FM_Review_Notes sheet you can hand to a reviewer.
Why it matters: turn ad-hoc checking into a defensible, signed-off audit trail.
Workbook Map + Contents
One menu - Contents, Calc Timing, Object Links. Contents builds a hyperlinked index of every sheet, named range and table, surfacing broken #REF! names so the rot can't hide in a 36-sheet model.
Why it matters: jump anywhere in a huge workbook in one click.
Select by Type
Highlight every Input, Formula, Hardcode or Cross-sheet reference on the sheet in one click - the cells light up so the model's skeleton is visible at a glance.
Why it matters: see inputs vs formulas vs hardcodes instantly.
Plain-English Explain
Turns the active cell's formula into a plain-English sentence - rule-based and fully offline, so nothing leaves your machine.
Trace Dependents + Ask AI
See every cell that depends on the active one - across all sheets - as a tree, so you know the blast radius before you change a number.
Calc Timing + Object Links
Rank sheets by recalculation time, and reveal which cells feed charts, pivots, data validation and conditional formatting.
Find Hardcodes + Inconsistencies
Flag numeric literals buried inside formulas, and cells whose formula breaks the pattern of their row or column neighbours.
Power Find
Search the whole workbook by value, formula fragment or pattern - and jump straight to every matching cell across every sheet.
Simple, fair pricing
Free Trial
- The full Pro feature set
- Precedent tree (Ctrl+Q) & trace dependents
- Onboarding Brief & Risk Dashboard
- Will start only after explicit verified device approval
Pro
- Everything in the trial, every month
- Onboarding Brief · Stress Test · Snapshot
- Risk Dashboard & Compliance Score
- Compare Versions · hardcode/inconsistency scans
- Review notes & HTML reports
Team / Audit
- Everything in Pro
- Sign-off coverage export
- Bulk key issuance
- Priority support
Release requirements
- The add-in must use the BeginThings verified-account device flow.
- The server and add-in must agree on the 11-day trial and paid-access lifecycle.
- The private release must pass Windows, Mac, activation, cancellation and refund tests before download opens.