Multi-sheet workbooks with documented formulas and plain sheets for testing spreadsheet parsers and importers.
Each card starts with one representative test file. Choose a use case, search, or filter to find a specific profile; a card’s variant menu contains its related samples.
75 test families · 78 available files · Page 1 of 5
Restaurant Costing
Cost of goods sold workbook with live formulas for Alder Table Bistro. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plu
Restaurant Costing
Inventory variance workbook with live formulas for Alder Table Bistro. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are
Procure To Pay
Procure-to-pay workbook for Alder Table Bistro. 9 worksheets holding the same rows as the CSV exports plus a 'Deliberate defects' sheet naming all 6: Price list 48 rows; Purchase orders 12 rows; Goods received 12 rows; I
Restaurant Costing
Recipe costing as an OpenDocument spreadsheet for Alder Table Bistro. Three tables. PlateCosts holds 12 recipe lines with the as-purchased quantity and line cost as live ODF formulas; Summary rolls each dish up with SUMI
Restaurant Costing
Recipe costing workbook with live formulas for Alder Table Bistro. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 12 recipe lines; Summary uses SUMIF to roll each dish up a
Restaurant Costing
Scheduled hours and overtime workbook for Alder Table Bistro. Three sheets. WeeklyHours carries 24 employee-weeks over 3 Monday-start work weeks, with weekly overtime above 44 hours, payable overtime as the greater of th
Restaurant Costing
Workbook with Excel error cells for Alder Table Bistro. Intentionally full of errors. Three sheets. CachedErrors stores 7 literal error cells with the error cell type (#DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!
Restaurant Costing
Workbook with intentional circular references for Alder Table Bistro. Intentionally circular. Two sheets. Three independent cycles: overhead in B4 is eight percent of the total in B5 while B5 adds B4 back in; B8 and B9 e
Restaurant Costing
Yield test workbook with live formulas for Alder Table Bistro. 5 tests over two sheets. Trimmed weight, trim yield, cooking loss and the yield factor are formulas; the last column is an IF that compares the measured trim
ODF
A budget template as OpenDocument Spreadsheet, budget-versus-actual rows with live SUM formulas for the totals. A usable planning template and a fixture for testing ODS formula parsing and recalculation.
Restaurant Costing
Cost of goods sold workbook with live formulas for Cedar Street Tacos. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plu
Restaurant Costing
Inventory variance workbook with live formulas for Cedar Street Tacos. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are
Procure To Pay
Procure-to-pay workbook for Cedar Street Tacos. 9 worksheets holding the same rows as the CSV exports plus a 'Deliberate defects' sheet naming all 6: Price list 48 rows; Purchase orders 12 rows; Goods received 12 rows; I
Restaurant Costing
Recipe costing workbook with live formulas for Cedar Street Tacos. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 18 recipe lines; Summary uses SUMIF to roll each dish up a
Restaurant Costing
Scheduled hours and overtime workbook for Cedar Street Tacos. Three sheets. WeeklyHours carries 24 employee-weeks over 3 Monday-start work weeks, with weekly overtime above 44 hours, payable overtime as the greater of th
Restaurant Costing
Workbook with Excel error cells for Cedar Street Tacos. Intentionally full of errors. Three sheets. CachedErrors stores 7 literal error cells with the error cell type (#DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!
Restaurant Costing
Workbook with intentional circular references for Cedar Street Tacos. Intentionally circular. Two sheets. Three independent cycles: overhead in B4 is eight percent of the total in B5 while B5 adds B4 back in; B8 and B9 e
Restaurant Costing
Yield test workbook with live formulas for Cedar Street Tacos. 3 tests over two sheets. Trimmed weight, trim yield, cooking loss and the yield factor are formulas; the last column is an IF that compares the measured trim
