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.
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
How demi solves it
Three layers in this order: connect the data first, then the rights, then the AI.
- 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 · 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 · 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
demi finds every spreadsheet with macros on the file share and NAS, with its copies and versions.
- 2
For each workbook the agent describes inputs, calculation rules and results in plain language.
- 3
Fixed checks look for unit errors, typed-in values and broken references, and samples are recalculated.
- 4
demi compares prices, surcharges and material values with the ERP and shows each difference with its cell.
- 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.
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 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 packageQuestions 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.
