Pine Assembly Workshop: Bill of materials workbook
Bill 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.
Rendered preview of the xlsx file (7.2 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
- 3
- Order Quantity
- 2
- Standard Cost
- 40.00
Testing contract
Expected to pass- Scenario
- Divide the Explosion extended quantities by the order quantity and compare with the Indented sheet.
- Expected result
- Every extended quantity divides by 2 to the per-unit quantity on the Indented sheet, and the Standard cost sheet closes on 40.00 USD for a finished unit.
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: Bill of materials 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: 3 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("bill-of-materials.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.
- 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.
- xlsxPine Assembly Workshop: Inspection measurement workbookInspection 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.
- pdfPine Assembly Workshop: Inspection report with measured tolerancesInspection report with measured tolerances for Pine Assembly Workshop. The full report behind the measurement file: 5 characteristics with their limits, all 25 readings with deviation and result, and the 2 failures named with the amount by which each exceeds its limit. The findings paragraph states those overruns in words, so the description, the table and the CSV all carry the same numbers.
- 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.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.