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.
Pop in your email and we'll send the download link + the 3-step install. Full features for 15 days, then a one-time license. Windows & Mac.
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.
Describes the active cell's formula as a plain-English sentence - exactly what you want when you inherit a model and stare at =IFERROR(VLOOKUP(MATCH(…))) for the first time. Rule-based and offline; nothing leaves your machine.
Why it matters: understand a cryptic formula in seconds, not minutes.
Shows which cells depend on the active cell - across all sheets - as a tree, so you can see the blast radius before you change a number. Optional Ask AI sends only the formula text and structure, never your data.
Why it matters: know what breaks downstream before you edit.
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.
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.
Ranks sheets by recalculation time to find the bottlenecks slowing the model down. And lists which cells feed charts, pivots, data validation, form controls, and conditional formatting - the hidden wiring that breaks silently.
Why it matters: find the slow sheet and the off-screen dependencies.
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.
Flags numeric literals (other than 0 or 1) buried inside formulas - the silent overrides that wreck a model. And flags cells whose formula breaks the pattern of their row or column neighbours, so a stray hand-edit can't hide in a block.
Why it matters: the costliest errors are the ones that look fine.
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.
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.
FormulaMapper.xlam (~460 KB) above.%AppData%\Microsoft\AddIns\, Mac is ~/Library/Group Containers/UBF8T346G9.Office/User Content/Add-Ins/.Blocked? If Excel says the file is blocked, right-click the .xlam → Properties → tick Unblock → re-enable. Standard for add-ins downloaded from the internet. (We're code-signing the installer to remove this step.)