Skip to content
Data & IT: legacy data, formats, connectorsPumps & ValvesMachinery & Plant EngineeringMetal & MachiningPlastics & Packaging+2

Understand spreadsheet tools before their author leaves

demi explains the formulas and macros in your costing and design spreadsheets in plain language and shows errors and ERP mismatches.

Today

Prices, surcharges and design calculations often depend on spreadsheets with macros that one person built and understands. Several copies circulate in different versions, with hard-typed values and references nobody can follow any more. When the author leaves, the company keeps calculating with a tool nobody can check.

An example

At Conveyra Fördertechnik, sales prices every bridge crane with a workbook of 14 sheets and 23 macros, built by the head of costing, who retires in the summer. demi finds 6 copies in different versions and describes how capacity, span and FEM group drive girder weight and price. Along the way it spots a hard-typed steel price from 2023, and the workbook applies a different material surcharge for the crane girder than the ERP.
Fictional company, typical workflow.

Your data, wherever it lives

Your costing and design calculators live today as Excel workbooks with macros in folders on the file share and the NAS, often in several copies, with the matching prices and surcharges in the ERP. demi reads, understands and links them, with your rights. The AI explains a workbook in hours instead of weeks and shows every difference, and the responsible person decides what applies.

Where the data lives today

  • Office files
  • Folders & drives
  • NAS & hard disks
  • ERP
Data LayerOne view of everything, with your rights

How demi solves it

Three layers in this order: connect the data first, then the rights, then the AI.

  1. 1 · ConnectData Layer

    Data sources in this case: spreadsheets with macros on the file share and NAS, plus items, prices and surcharges from the ERP. demi replaces nothing and reads every workbook in full: sheets, formulas, macros, named ranges and links to other files. Each spreadsheet becomes one record with its inputs, calculation rules, results and all its copies.

  2. 2 · PermitPermission Layer

    The file share's rights apply: whoever may not open a costing sheet today does not see its description either, and margins and surcharges stay with costing. The responsible specialist approves every description and every correction, and this is recorded.

  3. 3 · ActIntelligence Layer

    The agent turns formulas and macros into calculation rules in plain language and shows which input moves which result. Fixed checks find unit errors, numbers typed into formulas, broken references and outdated material values. demi recalculates samples with its own independent calculation, not an estimate, and every difference is shown with sheet and cell.

How it runs

  1. 1

    demi finds every spreadsheet with macros on the file share and NAS, with its copies and versions.

  2. 2

    For each workbook the agent describes inputs, calculation rules and results in plain language.

  3. 3

    Fixed checks look for unit errors, typed-in values and broken references, and samples are recalculated.

  4. 4

    demi compares prices, surcharges and material values with the ERP and shows each difference with its cell.

  5. 5

    The responsible specialist settles open points and approves the description as the template for replacing the tool.

What changes

  • Every calculation traceable, even without its author

  • Calculation errors and outdated values found before they reach a quote

  • A checked template for moving the spreadsheet into the ERP or a configurator

What does it bring you?

Check it with your own numbers

Every starting value is an assumption you can change. The calculation sits right below, step by step.

Assumption, editable

Your numbers

Result

+230 hfreed per year

Assumptions and calculation

demi documents a workbook's formulas and macros and checks them against the ERP; you settle open points.

8 h → 4.8 h per case

How does it run today?

What is already digital saves less: the factor lowers the share demi brings.

How we calculate

6 spreadsheet tools × 8 h × 40% × 1.0 (manual) × 12 months = 230 h

Value per year, before demi costs

Freed per year+230 h

Assumption: labour cost of €49.50 per hour in German manufacturing in 2025 (Destatis), plus workplace, IT and overheads.

= Value per year, before demi costs

+€14,950

gained per year

230 h ÷ 1,760 h per role = 0.1 full-time roles

An estimate, not a promise. The starting values are assumptions for an industrial company with 150 to 500 people.

Combine with more cases and get the package

Questions about this use case

Can demi follow nested formulas and old macros?

Yes. The agent reads formulas, named ranges, macros and references to other files and turns them into calculation rules you can read without programming skills. Where a macro does something that cannot be settled for sure, such as opening a file that no longer exists, it appears as an open question in the description.

How does demi find errors in a costing spreadsheet?

With fixed checks: units that do not match, numbers in the middle of formulas, references to nothing and values that differ from the ERP or the valid material data sheet. For samples, demi recalculates the result with its own calculation. Each difference shows sheet, cell and where the correct value comes from.

Does demi change our spreadsheets?

No, demi only reads and files the description next to the workbook. The agent proposes corrections; they are made only after the responsible person approves them, in a new version of the file. The old version is kept.

Does this help us replace the spreadsheet later?

Yes. The approved description is the specification for the ERP, a configurator or your own software: every input, every rule, every special case. It comes with test cases from real past calculations, so you can check that the new solution calculates the same.

See this case with your data

In the demo we show you the workflow on your own systems.

Your configurator

No use cases yet

Your configurator is still empty

Add a use case from any card or case page and see what it brings per year, with the calculation. Free, no sign-up, no commitment: try it out and change any number.

Browse use cases