Every feature in ModelxcelPro.

Status tracking, issue flagging, model health scoring. Persistent .mxaudit sidecars.

• Audit TrailMark cells Verified, Questionable, or Erroneous. Status persists in a .mxaudit JSON sidecar that lives next to the workbook on disk and auto-saves on every change — send the file plus its sidecar to your auditor and they open the model exactly as you left it. Status changes also feed the Proof ledger; bulk edits that revoke verified status are recorded as SignatureRevoked records so the loss is auditable after the fact.
• Mark CellApply audit status to the current selection in one click — no dialog, no menu.
• Audit Trail Highlights (toggle)Toggle a color layer that paints cells by Audit Trail status (Verified / Questionable / Erroneous). Off by default so the model still reads cleanly; one click and the review map appears.
• Review Issues TrackerAn issue tracker that lives inside the workbook — severity, status, tags, comments, and savable issue sets, all persisted alongside the model. Reads like a model-review version of Linear or Jira: filter by severity, mark Resolved, save a set as a review packet for the next reviewer. Import an issue set from another reviewer's file with conflict detection.
• Flag CellLog a review issue against the current selection without leaving the cell — severity, tag, comment, done.
• Issue Highlights (toggle)Toggle a layer that paints flagged cells by severity. The review map appears on demand.
• Model Health ReportWorkbook-wide diagnostics on one page: formula counts, complexity distribution (so you know which sheets are doing the heavy lifting), error breakdown, hardcoded-constant count, volatile-function flags, and risk indicators. The one-page health check you'd otherwise build by hand with COUNTIF and INDIRECT.
• Cell Search by attributeFind every error, hardcoded constant, merged cell, volatile function, dynamic array, or formula above a complexity threshold — in one query, across the whole workbook. It is the "show me everything that could break" view for model review.

CalcScope, Dock CalcScope, TrustLens, Flow Diagram, Trace, Sensitivity, and Name Conversion.

• Trace PrecedentsVisual tree of every cell feeding the selected cell — cross-sheet within the workbook. External workbook references are surfaced but not followed (they appear in the diagram as terminal nodes labelled with the source workbook).
• Trace DependentsVisual tree of every cell that depends on the current selection.
• Formula Explorer (Flow Diagram)Ctrl+Shift+WInteractive flow-diagram task pane with two distinct view modes: Drill (recursive function-structure tree — IF → AND → references) for "what does this formula DO," and List (direct cell precedents only) for "what does this formula USE." Toggle with one click. In Drill mode, Prune lets you collapse irrelevant subtrees. Click any node to highlight the path back to root; click any cell reference to navigate. Function nodes color-coded across six categories: Logical (IF / AND / OR / IFERROR / IFS / SWITCH), Lookup (VLOOKUP / INDEX / MATCH / XLOOKUP), Math (SUM / AVERAGE / ROUND / POWER), Text (LEFT / MID / CONCAT / SUBSTITUTE), Date (DATE / EDATE / EOMONTH / WORKDAY), and Financial (NPV / IRR / PMT / RATE / PV / FV). Exports to four targets — PNG, JPEG, BMP, and direct clipboard image — so review packets are one paste away. Viewport culling drops 70–90% of DrawNode calls in typical inspection views, keeping rendering smooth on 100+ node trees.
• TrustLensCtrl+Shift+IAttestation-aware formula workbench reachable from Worksheet Map, Cell Search, Compare drill-in, Formula Explorer, the ribbon, and Ctrl+Shift+I. It combines formula explanation with proof state: Bound / Signed / Unattested / Drifted summary chips, per-node badges for stale or tampered evidence, Result values on nodes, active PATH / OFF branch flags, counterfactual Path reasoning, Proof timeline, Refs timeline, and Live Dependents with cross-sheet counts and navigation.
• CalcScopeFloating formula explainer for the selected cell. It builds a step-by-step tree with live values, branch highlighting, a verified calculation explanation bar, navigable rows, find/edit controls, copy output, and no-write what-if sliders when the formula has eligible leaf inputs. TrustLens audits trust and diagnostics; CalcScope explains the math.
• Dock CalcScopeRead-only cockpit docked beside the grid. It follows selection and re-explains the active cell without writing to the workbook. Tabs cover Explain, Inputs, Impact, Scope, and Hidden context; reviewers can preview, go to, inspect, reveal, or trace deeper from the listed inputs and dependents.
• Classic Pretty PrintCtrl+Shift+YThe classic multi-line indented formula view with syntax highlighting and clickable refs. It remains the Ctrl+Shift+Y shortcut path and never routes through CalcScope.
• Sensitivity AnalysisCtrl+Shift+SMulti-output sensitivity in one form. Auto-detects the model's outputs (≥0.9 confidence joins via the same TopologyDiscoveryService MCI uses) — switch between IRR / NPV / DSCR / LLCR / PLCR / MOIC / Payback / Equity Return without rebuilding. Up to 100 drivers per output, each perturbed at six levels (±1% / ±5% / ±10%) — not just ±1% — to show non-linearity. A Quick-Scan pre-pass with a 0.5%-impact diminishing-returns cutoff trims dead drivers before the full run. UI: Top-N filter (10/20/50/All), hide-zero, hide-outliers, click-bar to navigate to the input cell, "Copy Data" export, ETA-aware progress on a background task so Excel stays responsive.
• Flatten NamesReplace named ranges in formulas with direct cell references so reviewers can see the exact cells being read. Optimized for large financial models and backed by the Name Conversion restore snapshot.
• Apply NamesScan formulas and replace matching cell references with existing defined names. Strict mapping only: no new names are created, so the model returns to readable named-range notation without inventing structure.
• Restore Last Name ConversionUndo the most recent Flatten Names or Apply Names pass while the in-memory snapshot exists. Reviewers can inspect formulas in reference form, then back out the conversion if needed.

Worksheet maps, risk heatmaps, complexity scoring across all sheets.

• Worksheet MapBird's-eye structural map of the workbook with three views: heatmap (cell types, formula density, cross-sheet dependencies), structure tree (every sheet → range → formula as an interactive in-workbook TreeView navigator), and audit. One-click "TrustLens" peek button on any formula opens the full inspector — the central hub that every analysis path feeds.
• Risk HeatmapCtrl+Shift+RThree view modes — three different analyst questions answered by the same source code: (1) RISK — formula complexity scored on a blue/yellow/red gradient with errors flagged. (2) STRUCTURE — every cell type plus formula-consistency arrows (copied vs distinct). (3) AUDIT — only problematic cells: distinct formulas in arrays, hardcoded plugs in formula areas, external references, volatile functions, errors. One-click toggle, all-sheets analysis, customizable color schemes, interactive legend panel.

Workbook diff, version compare, Material Change Intelligence — knows why outputs moved.

• Compare WorkbooksFormula-aware diff of two Excel files. Headline metrics split the delta into five buckets (Total / Formula / Value / Formatting / Structural). A Workbook TreeView navigator inside the results window with per-sheet change counts colour-coded by density. Aligned-sheet detection flags sheets whose structure matches between versions so positional changes don't register as structural. Change grouping collapses near-identical edits — 2,730 cells all moving from `=-Cons!X39` to `=-Cons!X40` become one reviewable item. Per-change tagging uses five impact levels (None / Low / Medium / High / Critical), a Significant flag for material financial moves, and Data Validation as a separate change category. Smaller sheets process first so the first results land fast on huge models. Highlight all changes inside Excel itself with one click.
• Compare to Previous VersionDiff the active workbook against any earlier file on disk. Auto-discovery walks the workbook's folder for sibling files matching common version-suffix patterns (`*_v*`, `*_version*`, `*_rev*`, `*_backup*`); Browse fallback for anything else. Cloud workbooks (OneDrive, SharePoint) auto-resolve to the local synced copy or get snapshotted to a cache folder so the version picker has a folder to enumerate. Once selected, the same Compare Workbooks engine runs and "Explain Output Change" routes into Material Change Intelligence from the results window in one click.
• Material Change IntelligenceAnswer "why did Project IRR move from 12.4% to 11.8%?" with attribution math instead of guesswork. Auto-detects the model's outputs across the standard PF/IB metric vocabulary (IRR, NPV, DSCR, LLCR, PLCR, MOIC, Payback, Equity Return) via named-range and label-context scans; a type-ahead lets you specify any cell. Decomposes the delta into up to 8 ranked drivers. Sensitivity-backed contributions actually re-perturb the live workbook ±1% via the Sensitivity engine — a real local Jacobian, not pattern matching. Residual is exact arithmetic: Δ minus Σ contributions. Confidence blends evidence type, path length, and unexplained residual into a single score per driver. For each driver: a cell-by-cell Dependency Path showing the chain from the changed input through every formula it touched on the way to the output. Seven one-click routes from the result — Open In Excel, TrustLens, Formula Diff, Worksheet Map, Create Review Issue, Mark For Audit, Export Report. And the closed loop: every comparison that intersects a signed block writes a BlockBroken record to the Proof ledger; every explanation has an ExplanationId that links Review Issues and the Audit Trail.
• Compare SheetsCompare specific worksheet pairs across two files. SheetNameMatcher auto-suggests pairings via four-phase fuzzy match (exact → normalized → abbreviation → Levenshtein ≥ 0.6) so a "Revenue" sheet pairs with "Rev v2" even after a rename. Same Compare Workbooks engine underneath: formula-aware, with available R1C1 mode and change grouping.

Smart formatting reads each cell's financial meaning; themes drive the full model look — Smart Format categories plus sheet headers, section headers, subtotals, totals, and flags. Set the model standard once.

• Empty References HighlighterTurn on Empty Referenced Cells and surface the blanks formulas are already reading. The referenced empty cells get the theme's Empty Ref style, so silent zeroes stand out before they travel downstream.
• Smart Format SelectionCtrl+Shift+JPrecision, on demand. Select a range and Smart Formatting first separates inputs from formulas. Then it applies the right notation inside each category: Number, Date, Percent, Factor, Ratio, or Flag. COD becomes a date. DSCR becomes a ratio. WACC and fees become percentages. Exchange-rate labels become factors.
• Smart Format SheetCtrl+Shift+QScale, without ceremony. Format Sheet applies the same input-vs-formula logic across the active worksheet, then classifies eligible cells as numbers, dates, percents, factors, ratios, or flags. Inherit a worksheet. Apply the standard. Move on.
• Auto Format (format-as-you-type)Ctrl+Shift+XJust type. We handle the rest. AutoFormat watches eligible edits and applies the same Smart Formatting engine in the background. Inputs and formulas can both receive the right notation while you build. Helpful, not dictatorial.
• Direct style shortcutsAlt+Shift+N/P/D/F/RSkip the classifier when you already know the answer. Alt+Shift + N / P / D / F / R apply Number, Percent, Date, Factor, or Ratio directly to the selection. Inputs auto-route to the input variant so the look stays consistent.
• Section HeaderAlt+Shift+HAlt+Shift+H stamps a clean section header that matches your theme — bold, aligned, ready. Apply from the ribbon or from the keyboard without leaving the cell.
• Master Shortcut ToggleOne switch in Settings frees up every Smart Format shortcut at once when another add-in needs them. Power-modeler escape hatch, no rebuilds, no edits to the registry.
• Text Case toolsSentence case, lowercase, UPPERCASE, and Capitalize Each Word. Apply to the selection or the sheet, or include it in AutoFormat. Choose whether text case participates in Format Selection, Format Sheet, and AutoFormat.
• Theme Gallery + Custom DesignerSet it once. Use it everywhere. Nine built-in themes (Default, Ruby, Desert, Modern, Emerald, Amethyst, Boardroom Graphite, Covenant Slate, Ocean) and a custom designer define the standards your team actually uses — colors, borders, and the number-format families Smart Format applies. Themes drive the full model look: Smart Format categories plus sheet headers, section headers, subtotals, totals, and flags. Themes persist with the workbook, so the model carries its notation grammar with it.
• Undo FormattingA 20-level formatting snapshot stack for Smart Format passes. Undo restores the captured state of the formatted range, including formulas, values, styles, fonts, fills, borders, and conditional formats. A powerful rewind. Use it like one.
• Flag Pattern DetectionFlags are model logic, not decoration. Smart Format recognises TRUE/FALSE and 1/0 rows when they form through-date, after-date, between-date, or non-consecutive patterns. TRUE and 1 cells get the flag treatment automatically. No rule editor. The model shows you the switch.
• Input Style RoutingInputs and formulas are the first split. After that, both can be classified into the financial-model notation families: Number, Date, Percent, Factor, Ratio, and Flag. Entered assumptions and calculated logic stay visually distinct.
• Auto-fit ColumnsAuto-fit column widths after formatting so pasted or inherited sheets settle back into readable shape.