Discovery · Systems handbook

Systems handbook

Musterwerk Antriebstechnik GmbH

Situation
Spreadsheets, silos, and a wish for AI
Access
Tier A
Prepared by
Aleph Engineering GmbH
Version
1.0, reviewed by a second engineer

Scope and limits

Systems examined
ERP, AuftragsPlaner, Drive and Sheets, Excel workbooks, Shared mailboxes
Context only
Customer portal, Nightly sync, EDI link, Shop-floor data, File server, Document archive, Quality system, HR and payroll
Period
10 business days
Access
Tier A, context-led: Interviews, the documentation you supply, demonstrations, and limited non-invasive review.
Exclusions
No production data, no changes to any system, no security testing beyond configuration review.
Confidence
Medium for the process and the root causes, which we observed in five real offers. Low for the inner workings of the macros and the ERP data, which we could not inspect. We recommend a short read-only inspection before committing to a larger change.

Excel workbooks

Every statement carries an evidence label, so you can see what we checked and what remains open.

Purpose and users

  • Observed

    The calculation workbook produces every offer price. Six people in sales use it; two senior calculators maintain it.

  • Observed

    One offer typically touches four systems: the mailbox, the workbook, the price sheet, and the ERP.

How an offer is made today

  • Observed

    1. Request arrives by email. 2. Item data copied from the ERP. 3. Base price taken from the Google Sheet. 4. Surcharges calculated by macros. 5. Lead time taken from the capacity sheet. 6. Offer typed into the ERP and sent as PDF.

  • Observed

    Median time from request to offer in the five cases: six business days.

Data sources

  • Observed

    Base prices: ERP, Google Sheet, and a copy inside the workbook (F1).

  • Inferred

    The Google Sheet is the version sales trusts most; the ERP is updated last.

Operations

  • Observed

    The workbook is copied for each year; there are 11 versions on the file server.

  • Unverified

    Which version is the current master; staff gave two different answers.

Known risks

  • Observed

    Conflicting prices (F1).

  • Inferred

    Undocumented surcharge macros (F2).

Knowledge gaps

  • Unverified

    The full logic of the surcharge macros (needs Tier B).

  • Unverified

    How prices in the ERP are maintained and by whom.

Evidence labels

Observed
We saw it, or it was shown or told to us directly.
Validated
We checked it against code, configuration, logs, or a test.
Inferred
A reasoned conclusion from what we saw, not yet checked.
Unverified
Reported to us, but we could not confirm it.

← Back to the guided tour