Skip to content
← Transform overview

TRANSFORM / SPREADSHEET EXPERT

Follow the number.
Find the logic.

Uncover the formulas, rules and exceptions inside a workbook. Trace a finding to its cells before deciding what to improve.

Called Spreadsheet Genius in the app
Spreadsheet Expert workflowCells → formula → business rule → review. An authored illustration of a fictional handoff project.ONBOARDING / SAVED VALUESB2Monthly handoffs60B3Minutes per review24B5Review effort24hB7Custom risk score—ƒx =B2*B3/60 EXTRACT THE RULEVolume × time → effortKeep the source cells attached Follow the formulaInputs and dependencies REVIEW POINTB7 unknownNo saved result
Cells → formula → business rule → review
Transform workflow illustration · Fictional Northstar example
01Cell-level evidence
02Rules & exceptions
03Bounded scenarios

SEE THE WORK / MAKE A CHOICE

Keep the workbook.
Reveal the reasoning.

Inspect a saved value, follow its formula and review a business rule with the source cells still in reach.

Working demo screens · Fictional examples

TRANSFORM / INSIDE THE DEMO

Read the logic behind the number.

Select a workbook cell, read its formula and follow the inputs and outputs in the inspector.

Saved values, formula references and missing results remain distinguishable.

Try the workbook demoInteractive example · No sign-up
ProcessScout / Spreadsheet ExpertDEMO WORKSPACE
Northstar working demo: Select a workbook cell, read its formula and follow the inputs and outputs in the inspector.

TRANSFORM / INSIDE THE DEMO

A formula becomes a rule to review.

Read the proposed missing-owner rule beside its cell references, then decide whether to accept it in the example.

The proposed rule keeps its cell-level basis. Explore the issues and bounded scenario in the same demo.

Try the rule reviewInteractive example · No sign-up
ProcessScout / Spreadsheet ExpertDEMO WORKSPACE
Northstar working demo: Read the proposed missing-owner rule beside its cell references, then decide whether to accept it in the example.
01

START WITH THE ACTUAL WORKBOOK

Keep the cells in view.

Open the workbook in a familiar grid with sheet tabs, a formula bar and an analyst overlay. Inspect the inputs, formulas, issues and rules in the place where they were found.

The summary and side panels help you move between the overall reading and a specific cell. A finding can take you back to its location; a selected cell can become the starting point for an explanation or question.

Start with
An Excel workbook or supported spreadsheet extract added to your project.
Work toward
An annotated view of the workbook, with cited findings and a visible reading status.

Three states a cell can hold

  1. Saved valueWhat the file recorded
  2. FormulaHow the value is built
  3. No saved resultKept as a gap
Illustration · fictional example
02

FOLLOW THE LOGIC

Ask where a figure came from.

Read a formula in plain language, inspect the values it uses and follow the cells that feed it. Trace in the other direction to see what depends on a changed input. Repeated formula families and their exceptions make patterns easier to inspect.

Ask about a cell, a summary figure or the results of the checks. Deterministic tools read cells, follow dependencies and answer supported row queries. The answer’s figures link back to their cell evidence.

Start with
A selected output, cell address or question about the workbook.
Work toward
A cell-cited answer and an inspectable path through the relevant logic.

Follow one figure

  1. InputsThe cells it reads
  2. The formulaExplained in plain words
  3. OutputsThe cells that read it
Illustration · fictional example

NORTHSTAR / THE WORKED EXAMPLE

A capacity estimate has assumptions worth opening.

An effort figure is usually monthly volume × minutes per item × adoption ÷ 60. Put your own volume, time and adoption into those cells and every input stays open to challenge. Adoption is an assumption, and a correct formula is not an observed result: track what actually changes after the work does.

Walk through this example

FROM CELL EVIDENCE TO A USEFUL NEXT MOVE.

  1. 01 / WorkbookInspect the saved values and structure.
  2. 02 / ExplanationTrace the formulas, rules and exceptions.
  3. 03 / Business contextSee the systems and process steps it supports.
  4. 04 / Proposed changeReview a path to retire, absorb, automate or keep.
Keep the reasoning intact as the analysis moves from spreadsheet detail into business improvement.
03

FIND WHAT NEEDS ATTENTION

Make the exceptions easier to see.

Inspect structural checks for broken references, interrupted formula runs, values typed into formulas, cached errors and control gaps. Open an issue where it occurs rather than trying to reconstruct its location from a separate report.

The reading also identifies details such as hidden sheets, external links, protection and macro presence. Use those signals to direct a reviewer’s attention and keep the scope of the analysis clear.

Start with
The current workbook version and its available structure.
Work toward
A reviewable issue list with severity, locations and the basis for each finding.

Issues worth a second look

  1. Broken referencesWhere a link fails
  2. Typed-over formulasValues replacing logic
  3. Your reviewDecides what matters
Illustration · fictional example
04

READ IT AS A BUSINESS SYSTEM

Find the process hidden in the sheets.

The As-is system view describes data entities and typed fields, functions, interfaces, controls and gaps. Formula-derived rules connect the workbook’s mechanics to the work it supports.

Consider the cited options: retire the workbook, absorb its role into an existing system, automate part of the work, or keep it with appropriate controls. A person can turn a proposed path into a draft initiative with a baseline taken from the workbook.

Start with
The workbook’s structure, rules, outputs and known process or system links.
Work toward
An as-is system description and a proposed improvement path ready for review.
Detail of the Transform demo with fictional example data
ProcessScout / Transformthe process a workbook supports · fictional data
05

LOOK ACROSS THE ESTATE

One workbook is part of a bigger picture.

Review workbooks and extracts together across a project or client. See their criticality, version drift, observed usage and relationships to systems and process steps. Compare sources when two workbooks appear to describe the same measure.

Keep the next action explicit. Assign an owner and review cadence where appropriate, inspect proposed cross-file relationships and decide which links and rules should be accepted into the project.

Start with
Authorized workbooks, versions and supporting project evidence.
Work toward
A spreadsheet inventory connected to business context, review needs and proposed changes.
Detail of the Transform demo with fictional example data
ProcessScout / Transforma workbook among other sources · fictional data

THE PRACTICAL DETAILS

Know where
you stand.

Talk through your workflow
Can I run a what-if?

Supported what-ifs can publish a recalculated result when the engine first reproduces the saved results along the affected calculation path. Unsupported functions, unresolved dependencies or results it cannot verify remain “Not measured.” This is not a claim of complete Excel compatibility.

Does it change my original workbook?

The inspection views read the retained workbook. They explain its saved values and structure without running macros. Accepting a rule or creating an improvement initiative updates the project’s records; it is not an automatic repair to the original file.

What is available in my workspace?

Deep analysis requires the spreadsheet capability, access to the source and a successful reading of the relevant version. Some operations use credits or depend on file size and supported structures. The page identifies unavailable, incomplete and stale readings.

YOUR NEXT CHANGE

See the workflow.
Make it your own.

Try the workflow, or bring one question from your business.

Product view

ProcessScout interactive demo · Fictional Northstar data