Find files, editable templates and browser test targets by what you need to make or test. The directory below is cut by format; the two collections under it cut the same library by subject and by workflow.
Nonconformance register for Pine Assembly Workshop. 2 nonconformances, one per failing reading, each naming the characteristic, the limit breached and the amount by which it is breached. Both are single legs, 6.00 USD of material in total, so the 80.00 USD work order is not materially affected and the closed_on column is empty because neither is closed at the snapshot.
Numeric expected results for Pine Assembly Workshop. Exact table counts, metric formulas, 6 chart points and three negative-test outcomes. Units received=96.00 units; Units issued=72.00 units; Assembly relationships=6.00 records.
Open delivery exceptions for Pine Assembly Workshop. 3 open exceptions, one for each shipment that has not been delivered. Between them they hold 12 parcels, which is exactly the difference between the 56 parcels shipped and the 44 delivered. Every resolution_target is two days after the raised_date.
Packing list by carton for Pine Assembly Workshop. 168 lines describing the contents of all 56 cartons: three part lines per carton, 4 LEG, 1 PANEL and 12 SCREW, which is the leaf level of the DESK bill of materials. The carton count equals the 56 parcels on shipments-export.csv and every carton weighs 12.200 kg gross.
Packing list whose carton count is short of the bill of lading for Pine Assembly Workshop. The same packing list as packing-list.csv with the 12 lines of the fourth carton on each BOL-2026-0003 consignment removed. It now describes 52 cartons where the register declares 56. BOL-2026-0003 accounts for 12 pieces against a declared 16.
Proof of delivery register for Pine Assembly Workshop. 13 delivery confirmations, one for each delivered shipment and none for the three still in transit. pieces_delivered equals pieces_expected on every row, so the register accounts for all 44 delivered parcels, and the exception_code column is empty throughout because no delivery was short or damaged.
Quarterly interest accrual for Pine Assembly Workshop. The first 4 quarters of the facility rolled up from the monthly schedule. Each row opening balance is the opening balance of the first month in the quarter and each closing is the closing of the last, so closing equals opening less capital repaid and the quarters chain without a gap.
Rated freight charges for Pine Assembly Workshop. 16 rated shipments. line_total equals base_charge plus weight_charge plus fuel_surcharge on every row, weight_charge equals gross_weight_kg times rate_per_kg rounded half up, and fuel_surcharge equals 0.065 of the two added together. The 13 billable rows total 861.19 and all 16 rows total 1093.24.
Shipment export CSV for Pine Assembly Workshop. 16 shipments over 4 delivery rounds, 13 delivered and 3 still in transit. Every parcel is one DESK kit at 12.200 kg gross, so gross_weight_kg is always parcels times 12.200. Parcels total 56 and delivered_parcels total 44; the in-transit rows report 0 delivered and an empty delivery_date.
Shipment export JSON for Pine Assembly Workshop. The same 16 shipments as shipments-export.csv with a totals object. totals.parcels is 56 and totals.grossWeightKg is 683.200, the sum of the per-shipment weights.
Shipment tracking event export for Pine Assembly Workshop. 74 scan events in chronological order per shipment: five for each of the 13 delivered shipments and three for each of the 3 still in transit, which never reach OUTFORDEL or DELIVERED. The DELIVERED timestamp on each shipment equals the delivered_time recorded for it on proof-of-delivery.csv.
Shipment tracking events as newline-delimited JSON for Pine Assembly Workshop. The same 74 scan events as tracking-events.csv, one JSON object per line with no enclosing array and no trailing comma. The file is not valid JSON as a whole and is not meant to be: each line is a complete document, which is what lets a consumer stream it without buffering the whole file.
Standard cost roll-up for Pine Assembly Workshop. Every part with its material cost from the level below, the added value on top and the standard cost the parts table holds. On every row material plus added value equals standard cost. The DESK row takes its material from the two sub-assemblies at their standard costs, 35.00 USD, not from the leaves; the leaves come to 25.20 USD, and the difference is the added value already absorbed into the sub-assemblies.
Tracking events out of order with a duplicated delivery scan for Pine Assembly Workshop. The same events as tracking-events.csv written newest first rather than oldest first, with one extra row: the DELIVERED scan for SHIP-02 appears twice under two different scan_id values, SCN-00010 and SCN-00075, with identical shipment_id, event_code, date and time. The file has 75 rows against 74 distinct events.
Vehicle utilisation report for Pine Assembly Workshop. 4 vehicles, one per round. spare_capacity equals capacity_parcels minus parcels_carried on every row and is positive throughout, from 10 to 22 parcels. fuel_litres is the planned consumption for one run of the round and litres_per_parcel divides it by the parcels carried, rounded half up to three decimals.
Work order cost build-up for Pine Assembly Workshop. The seven line cost of BUILD-1: 50.40 USD of material, 18.50 of labour and 11.10 of absorbed overhead, giving 80.00 USD against a standard cost of 80.00 USD for the output and a variance of 0.00. The order closes exactly to standard, which is deliberate: it makes any variance a reader computes a defect in their arithmetic rather than a property of the fixture.
Work order register for Pine Assembly Workshop. The 4 production orders the model holds, all for 2 DESK each, costed through the same routing. Every order closes to standard with a zero variance because setup is the same and the quantity is the same on all four; a different order quantity would produce a variance, which is why the batch size is a column rather than an assumption.
Work order routing for Pine Assembly Workshop. The 5 operations for BUILD-1, each with a setup time charged once per order and a run time charged per unit. At an order quantity of 2 the total is 10 setup minutes plus 20 run minutes, 30 in all, which at 37.00 USD an hour is 18.50 USD of labour. Treating setup as a per-unit time instead would give 40 minutes and 24.67 USD.
Yield and scrap for Pine Assembly Workshop. Yield by production order. Every order yields 2 good units for 2 ordered, so finished-goods yield is 100.00 percent on all four, while BUILD-1 scrapped 2 legs worth 6.00 USD at component level. The two measures are in separate columns on purpose: component scrap that is replaced before assembly does not reduce finished-goods yield, and reporting one as the other is the mistake this file exists to catch.
Application for payment continuation sheet for Pine Property Services. 12 contract items, 2 change order lines and a TOTAL row, in the shape of an AIA G703 continuation sheet. Scheduled values total 4113.00; 1490.00 was certified on the previous application, 1618.00 is claimed this period and 140.00 is materials stored but not installed, giving 3248.00 completed and stored. Retainage is 10 percent of each line and totals 324.80.
Application for payment summary for Pine Property Services. The nine numbered lines of an AIA G702 style application. Contract sum 3858.00 plus 255.00 of change orders gives 4113.00; 3248.00 is completed and stored, retainage of 324.80 splits 310.80 on work and 14.00 on stored material, and after 1341.00 of previous certificates the current payment due is 1582.20.
Application for payment whose retainage was withheld at the wrong rate for Pine Property Services. The same nine lines as application-for-payment-002-summary.csv, but lines 5a and 5b were computed at 5 percent while their own descriptions still read 10 percent. Retainage reads 162.40 instead of 324.80, so the current payment due on line 8 reads 1744.60 against the correct 1582.20, 162.40 too much.
Approved change order register for Pine Property Services. 2 approved change orders: an addition of 420.00 for extra door hardware and a credit of -165.00 for deleted lighting scope, a net 255.00. The running contract sum moves from 3858.00 to 4113.00, which is line 3 of the payment application. A credit change order is a negative amount, not a separate document type.
