Isn't a Logic Scan too much for a few Excel files?

The scan shows how many objects there really are. A small environment usually falls in band S, up to 50 objects.

What do you do with macros and VBA?

We read them out and describe in plain language what they do. Business rules go into the semantic layer, so they no longer depend on one file.

Where does the logic end up?

In one source you can query: a semantic layer on your warehouse or in your BI tool. Excel can stay as a front end for anyone who wants it.

Excel · Access · VBA

Your company's most important report lives in one person's spreadsheet.

No deadline, but a risk: macros, links and Access queries that only one person understands. We map the logic in spreadsheets and databases and turn it into one reliable source.

Book a Logic Scan for Excel and Access

Starts with a free 30-minute intake call.

One person

Knows how the report works

Macros and VBA

Logic nobody dares to change anymore

Links

Files that point to each other and to exports

What we extract

What we take out of Excel and Access

Every object that carries logic is read, linked to what depends on it, and checked for use.

Worksheets and formulas
Formulas, references and the cells the numbers come from.
Pivot tables
Summaries and the source ranges behind them.
Macros and VBA
What every macro does, described in plain language.
Power Query
Steps that fetch and clean data before the formulas start.
Access queries
Queries and tables in Access, and which workbooks they feed.
Links between files
Which files point to each other and to exports.

What you get

AI-native migration: more than new dashboards

Your logic leaves the old platform as something you own, can read and can query.

Knowledge graph

Every table, procedure, report and relationship in one searchable graph.

Semantic layer in Apache Ossie

Your metrics and dimensions in an open standard, not locked in a tool.

MCP endpoint

Query your logic with Claude, ChatGPT or Copilot.

Plain-language documentation

What every report does and where its numbers come from.

Dead and duplicate objects

What is no longer used does not move.

Reconciliation report

Proof that your core KPIs match the old report.

Optional: a rebuild in Power BI, dbt with Omni, or a warehouse with a semantic layer.

The result is a semantic layer your BI tools and AI agents share. Choosing one? Read dbt Semantic Layer vs Cube and the Open Semantic Interchange guide. How we expose it to AI: MCP-driven data consulting.

Curious what's in your environment? The Logic Scan shows you in 5 working days.

Book a Logic Scan for Excel and Access

Who does the work

One specialist for Excel and Access

Carl Groefke, 3 years of experience with Power Query and Power BI. One fixed point of contact who signs off on the reconciliation.

Proof

What it looks like

“Which reports use finance's revenue definition?”

Apache Ossie

metrics:
  - name: net_revenue
    expression: SUM(amount_excl_vat)
    filters:
      - is_intercompany = false
      - is_credit_note = false
    owner: finance
    source: Revenue_2026.xlsx

Case

Example

Logistics company, 120 employees

31 objects (band S) · Logic Scan in 5 working days, Logic Extract in 2 weeks