Transform historical offers into a usable calculation basis
Historical offers are valuable if it can be seen for which component, which revision and what quantity they were created. In practice, this information is often separated from ERP exports, Excel files, PDF drawings and network drives. Mass import alone does not solve the problem. It only makes data searchable if positions, documents and calculation levels are reliably linked.
For entry, a manageable, professionally known inventory is selected. Fields and units are unified, identical files and double positions are recognized. Where an assignment is not clear, the record remains in the test status. The original source as well as any manual supplement remain comprehensible. Thus, later, it can be distinguished what actually stood in the old offer and what was assigned to the import.
Released reference cases answer the decisive questions in a new question: Has a comparable part already been calculated? Which machine and sequence of work were planned? Which number of units and cost rates were the basis? The previous price is not taken over unchecked. Instead, the case serves as a starting point for detecting technical and commercial changes faster.
Limits should remain visible consciously. Old hourly sets, missing drawing positions or undocumented special supplements cannot be reconstructed seriously afterwards. Such records can still be useful as search hits, but may not be given the same reliability as fully tested cases. A good import therefore prioritizes quality and origin from mere data.
Result of the application
In "Transfer historical offers into a usable calculation base", existing data are combined with a clear decision and a visible result.
Targeted use of sources
ERP exports, tables, drawings and CAD files are recorded with origin and version status.
Show data quality openly
Missing fields, unclear units and double positions are marked before use.
Release Good References
Only technically tested old cases serve as orientation for a new quotation calculation.


