Engineering data imports and exports
Registers out as spreadsheets, and in again - without destroying what somebody has verified.
Demonstration project - no figure here describes a real facilityChanges are not saved
Why
The workbook writer produces files Excel opens, with numbers in cells as numbers. File sizes below are measured from the bytes.
Writes are validated against the engineering rules and then refused, because no database has been configured for this environment.
Registers
5
Records
50
Verified records
1
an import must not overwrite these
Exportable
23 kB
An import must not overwrite a verification
Somebody checked that number against a drawing. A round trip through a spreadsheet does not carry that check, so an import that overwrites a verified value destroys the verification while leaving the flag in place - which is worse than losing the value, because the record still claims somebody checked it.
Registers
Import a register
Numbers are numbers
An exported design pressure is a numeric cell, not the text “24 barg”. A register an engineer cannot filter by pressure range is a table of text that happens to look numeric, and filtering a line list by pressure is the first thing anybody does with one.
What an export carries
- Every row, with its unit, subsystem and test pack
- The drawings each item appears on
- Whether a person has verified it
- A footnote saying the data is synthetic