Pine Assembly Workshop: Inspection measurement workbook
Inspection measurement workbook for Pine Assembly Workshop. The readings and the characteristics in one workbook, so the limits used by the result column can be checked without opening a second file. Decimal values are held as text at the number of places the gauge reads to, which keeps the trailing zero on a nominal of 700.0 that a numeric cell would drop.
Rendered preview of the xlsx file (7.4 KB). Download above for the original.
Specifications
- Document Set
- manufacturing
- Industry
- manufacturing
- Source Kit
- inventory-manufacturing
- Entity
- Pine Assembly Workshop
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 2
- Rows
- 25
- Decimals As Text
- true
Testing contract
Expected to pass- Scenario
- Join the two sheets on characteristic_id and recompute every result.
- Expected result
- The join resolves all 25 readings and reproduces 2 failures. The nominal on CH-1 reads back as the string 700.0 rather than as a float that loses its last digit.
What is a .xlsx file?
XLSX is the default Microsoft Excel format, an Office Open XML spreadsheet stored as a ZIP archive containing worksheet XML, shared strings, styles, and formulas. It supports multiple sheets, cell formatting, charts, and calculated values. It is the standard for editable tabular workbooks.
How to use this file
Use an example XLSX to test spreadsheet parsing, formula and multi-sheet handling, shared-string extraction, and pipelines that read or generate Excel workbooks.
How to use this file for testing
“Pine Assembly Workshop: Inspection measurement workbook” is a deterministic Novus Examples fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 25 rows · 2 sheets. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Document fixtures list their internal structure (pages, fields, tracked changes, embedded objects) in the spec table. Test extractors, converters, and OCR against that known structure, and compare searchable↔scanned or format-twin companions when present.
Code examples
from openpyxl import load_workbook
wb = load_workbook("inspection-measurements.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- pdfHarbour Components: Material certificateMaterial certificate for Harbour Components. The supplier certificate behind the leg stock, naming the 4 purchase orders the inventory-manufacturing model records for LEG and the 48 legs and 144.00 USD they cover. The declared properties are invented values in a plausible shape and the certificate says so in its own words, because a fixture that looked like a real mill certificate would be worse than useless.
- xlsxPine Assembly Workshop: Bill of materials workbookBill of materials workbook for Pine Assembly Workshop. A three-sheet workbook: the indented structure per finished unit, the explosion for BUILD-1, and the standard cost roll-up. The Indented and Explosion sheets differ by the order quantity of 2 on every extended column, which is the comparison the workbook exists to make easy.
- docxPine Assembly Workshop: Certificate of conformance (DOCX)Certificate of conformance (DOCX) for Pine Assembly Workshop. A certificate covering the 2 units released under BUILD-1 and lot LOT-2026-0912. The evidence table names five supporting records, every one of which is a file in this directory, and the certificate states the 2 nonconformances rather than omitting them, explaining that the affected legs were replaced before assembly so no nonconforming part is in the certified units. The PDF twin in the same directory carries the identical text.
- pdfPine Assembly Workshop: Certificate of conformance (PDF)Certificate of conformance (PDF) for Pine Assembly Workshop. A certificate covering the 2 units released under BUILD-1 and lot LOT-2026-0912. The evidence table names five supporting records, every one of which is a file in this directory, and the certificate states the 2 nonconformances rather than omitting them, explaining that the affected legs were replaced before assembly so no nonconforming part is in the certified units. The DOCX twin in the same directory carries the identical text.
- mdPine Assembly Workshop: manufacturing document set READMEDocument set README for Pine Assembly Workshop. 31 files, 1 of them intentionally invalid, with the reconciliation identities, the declared parameters and the measured size of each deliberate defect named in full.
- pdfPine Assembly Workshop: Nonconformance reportNonconformance report for Pine Assembly Workshop. The report for NCR-2026-0001: characteristic CH-3 sample 3 measured 25.41 against a upper 25.300 limit, outside by 0.110, affecting 1 leg worth 3.00 USD. It records that the gauge was inside calibration on the inspection date, which is what makes the reading evidence rather than a suspect measurement.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.