Spreadsheet fixtures

Multi-Sheet XLSX with Formulas

A two-sheet workbook where a Summary sheet references a Data sheet with SUM and arithmetic formulas, for testing spreadsheet parsers, formula evaluation, and converters.

File: XLSX · Excel
Use case: Spreadsheet testingConversion testing

Plain Single-Sheet XLSX

A single-sheet workbook of plain tabular values with no formulas: a baseline fixture for spreadsheet importers.

File: XLSX · Excel · 11 rows
Use case: Spreadsheet testing· Conversion set

ODS: OpenDocument Spreadsheet

An OpenDocument Spreadsheet with the same tabular data as the plain XLSX and legacy XLS: a member of an XLSX↔ODS↔XLS conversion set for spreadsheet importers.

File: ODS · Excel · 11 rows
Use case: Spreadsheet testingConversion testing· Conversion set

XLS: Legacy Excel Workbook

A legacy Excel 97–2003 (.xls / BIFF8) workbook holding the same tabular data as the plain XLSX and ODS, for testing legacy-format readers and XLS↔XLSX conversion.

File: XLS · Excel · 11 rows
Use case: Spreadsheet testingConversion testing· Conversion set

XLSX with Embedded Charts

A workbook with a data table plus a native bar chart and a line chart bound to the cells, for testing whether spreadsheet parsers and XLSX-to-PDF converters preserve and render embedded charts.

File: XLSX · Excel
Use case: Spreadsheet testingConversion testing

XLSX with Merged Cells, Conditional Formatting & Data Validation

A dashboard sheet exercising the features importers miss: a merged title cell, a three-colour conditional-formatting scale, a data-validation dropdown, cell borders, and frozen panes.

File: XLSX · Excel
Use case: Spreadsheet testingConversion testing

Monthly Budget Template (XLSX)

A monthly budget workbook with budgeted-vs-actual categories, per-row difference formulas, and column totals.

File: XLSX · Budget
Use case: TemplatesSpreadsheet testing

Expense Tracker Template (XLSX)

A simple expense tracker with date, category, description, amount, and a total formula.

File: XLSX · Expense Tracker
Use case: TemplatesSpreadsheet testing

Project Task List Template (XLSX)

A project task list with task, owner, status, and due-date columns.

File: XLSX · Task List
Use case: TemplatesSpreadsheet testing

Weekly Timesheet Template (XLSX)

A weekly timesheet that computes hours from start and end times minus breaks, multiplies by an hourly rate for pay, and totals the week with live formulas: good for spreadsheet and formula testing.

File: XLSX · Timesheet
Use case: TemplatesSpreadsheet testing

Content Calendar Template (XLSX)

A monthly content calendar tracking posts across channels with owner and status columns and a COUNTIF that tallies published items: a realistic marketing planning sheet.

File: XLSX · Content Calendar
Use case: TemplatesSpreadsheet testing

Gantt Chart Template (XLSX)

A lightweight Gantt chart: eight project tasks with start and end weeks and a coloured cell bar spanning each task's duration across an eight-week grid.

File: XLSX · Gantt Chart
Use case: TemplatesSpreadsheet testing

Habit Tracker Template (XLSX)

A weekly habit tracker with a checkbox grid across seven days, a COUNTIF that counts completed days, and a goal column: a simple personal planning sheet.

File: XLSX · Habit Tracker
Use case: TemplatesSpreadsheet testing

Event Planner Template (XLSX)

A two-sheet event planner: a budget sheet with estimated-versus-actual difference formulas and totals, plus a task sheet with owners, due dates, and status.

File: XLSX · Event Planner
Use case: TemplatesSpreadsheet testing

Grade Tracker Template (XLSX)

A gradebook that computes a weighted average from homework, midterm, and final scores, assigns a letter grade with nested IF, and averages the class: good for formula testing.

File: XLSX · Grade Tracker
Use case: TemplatesSpreadsheet testing

Budget Template (ODS, with formulas)

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.

File: ODS · Budget
Use case: TemplatesSpreadsheet testing+1· Conversion set

Project Risk Register (XLSX)

A scored delivery-risk register with owners, mitigations, triggers, and review dates. This Excel workbook adds filters, frozen headers, print settings, typed cells, and live formulas where the model defines them.

File: XLSX · Planning · 8 rows
Use case: TemplatesConversion testing+1· Conversion set

Event Run of Show (XLSX)

A minute-by-minute production schedule with cues, ownership, locations, and contingencies. This Excel workbook adds filters, frozen headers, print settings, typed cells, and live formulas where the model defines them.

File: XLSX · Planning · 11 rows
Use case: TemplatesConversion testing+1· Conversion set

Vendor Evaluation Scorecard (XLSX)

A weighted comparison of fictional vendors with evidence notes, decisions, and review ownership. This Excel workbook adds filters, frozen headers, print settings, typed cells, and live formulas where the model defines them.

File: XLSX · Business · 5 rows
Use case: TemplatesConversion testing+1· Conversion set

Alder Table Bistro: Procure-to-pay workbook

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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Juniper Corner Cafe: Procure-to-pay workbook

Procure-to-pay workbook for Juniper Corner Cafe. 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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Copper Oven Bakery: Procure-to-pay workbook

Procure-to-pay workbook for Copper Oven Bakery. 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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Ember Lane Pizza: Procure-to-pay workbook

Procure-to-pay workbook for Ember Lane Pizza. 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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Cedar Street Tacos: Procure-to-pay workbook

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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Willow Event Kitchen: Procure-to-pay workbook

Procure-to-pay workbook for Willow Event Kitchen. 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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Harbour Kitchen Group: Procure-to-pay workbook

Procure-to-pay workbook for Harbour Kitchen Group. 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; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.

File: XLSX · Procure To Pay · 134 rows
Use case: Data importSpreadsheet testing

Alder Table Bistro: Recipe costing workbook with live formulas

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 and computes margin and food-cost percent; Notes records the provenance. Exactly 73 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Alder Table Bistro: Yield test workbook with live formulas

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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 5 rows
Use case: Spreadsheet testingData import

Alder Table Bistro: Inventory variance workbook with live formulas

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 formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Alder Table Bistro: Cost of goods sold workbook with live formulas

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, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 1574.81 CAD against 15780.80 CAD of net menu sales, a food cost of 9.98 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Alder Table Bistro: Scheduled hours and overtime workbook

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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Alder Table Bistro: Workbook with intentional circular references

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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (Roast chicken plate) at 3.07 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Alder Table Bistro: Workbook with Excel error cells

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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Alder Table Bistro: Recipe costing as an OpenDocument spreadsheet

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 SUMIF and computes margin and food-cost percent. The same figures in value form are in plate-costs.csv.

File: ODS · Restaurant Costing
Use case: Spreadsheet testingData import· Conversion set

Juniper Corner Cafe: Recipe costing workbook with live formulas

Recipe costing workbook with live formulas for Juniper Corner Cafe. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 8 recipe lines; Summary uses SUMIF to roll each dish up and computes margin and food-cost percent; Notes records the provenance. Exactly 61 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Juniper Corner Cafe: Yield test workbook with live formulas

Yield test workbook with live formulas for Juniper Corner Cafe. 2 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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 2 rows
Use case: Spreadsheet testingData import

Juniper Corner Cafe: Inventory variance workbook with live formulas

Inventory variance workbook with live formulas for Juniper Corner Cafe. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Juniper Corner Cafe: Cost of goods sold workbook with live formulas

Cost of goods sold workbook with live formulas for Juniper Corner Cafe. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 1538.14 CAD against 10234.74 CAD of net menu sales, a food cost of 15.03 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Juniper Corner Cafe: Scheduled hours and overtime workbook

Scheduled hours and overtime workbook for Juniper Corner Cafe. 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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Juniper Corner Cafe: Workbook with intentional circular references

Workbook with intentional circular references for Juniper Corner Cafe. 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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (Flat white) at 0.70 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Juniper Corner Cafe: Workbook with Excel error cells

Workbook with Excel error cells for Juniper Corner Cafe. 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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Copper Oven Bakery: Recipe costing workbook with live formulas

Recipe costing workbook with live formulas for Copper Oven Bakery. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 11 recipe lines; Summary uses SUMIF to roll each dish up and computes margin and food-cost percent; Notes records the provenance. Exactly 70 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Copper Oven Bakery: Yield test workbook with live formulas

Yield test workbook with live formulas for Copper Oven Bakery. 2 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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 2 rows
Use case: Spreadsheet testingData import

Copper Oven Bakery: Inventory variance workbook with live formulas

Inventory variance workbook with live formulas for Copper Oven Bakery. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Copper Oven Bakery: Cost of goods sold workbook with live formulas

Cost of goods sold workbook with live formulas for Copper Oven Bakery. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 623.44 CAD against 6651.14 CAD of net menu sales, a food cost of 9.37 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Copper Oven Bakery: Scheduled hours and overtime workbook

Scheduled hours and overtime workbook for Copper Oven Bakery. 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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Copper Oven Bakery: Workbook with intentional circular references

Workbook with intentional circular references for Copper Oven Bakery. 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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (Yeasted loaf) at 0.86 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Copper Oven Bakery: Workbook with Excel error cells

Workbook with Excel error cells for Copper Oven Bakery. 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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Ember Lane Pizza: Recipe costing workbook with live formulas

Recipe costing workbook with live formulas for Ember Lane Pizza. 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 and computes margin and food-cost percent; Notes records the provenance. Exactly 91 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Ember Lane Pizza: Yield test workbook with live formulas

Yield test workbook with live formulas for Ember Lane Pizza. 2 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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 2 rows
Use case: Spreadsheet testingData import

Ember Lane Pizza: Inventory variance workbook with live formulas

Inventory variance workbook with live formulas for Ember Lane Pizza. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Ember Lane Pizza: Cost of goods sold workbook with live formulas

Cost of goods sold workbook with live formulas for Ember Lane Pizza. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 3110.43 CAD against 25954.50 CAD of net menu sales, a food cost of 11.98 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Ember Lane Pizza: Scheduled hours and overtime workbook

Scheduled hours and overtime workbook for Ember Lane Pizza. 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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Ember Lane Pizza: Workbook with intentional circular references

Workbook with intentional circular references for Ember Lane Pizza. 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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (Margherita pizza) at 2.04 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Ember Lane Pizza: Workbook with Excel error cells

Workbook with Excel error cells for Ember Lane Pizza. 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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Ember Lane Pizza: Inventory variance as an OpenDocument spreadsheet

Inventory variance as an OpenDocument spreadsheet for Ember Lane Pizza. Two tables. Theoretical closing, the variance quantity, the variance at standard cost and the total are live ODF formulas over 6 ingredients. The same figures in value form are in inventory-count-sheet.csv.

File: ODS · Restaurant Costing
Use case: Spreadsheet testingData import· Conversion set

Cedar Street Tacos: Recipe costing workbook with live formulas

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 and computes margin and food-cost percent; Notes records the provenance. Exactly 91 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Cedar Street Tacos: Yield test workbook with live formulas

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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 3 rows
Use case: Spreadsheet testingData import

Cedar Street Tacos: Inventory variance workbook with live formulas

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 formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Cedar Street Tacos: Cost of goods sold workbook with live formulas

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, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 2559.57 CAD against 19374.60 CAD of net menu sales, a food cost of 13.21 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Cedar Street Tacos: Scheduled hours and overtime workbook

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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Cedar Street Tacos: Workbook with intentional circular references

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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (Chicken taco trio) at 2.11 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Cedar Street Tacos: Workbook with Excel error cells

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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Willow Event Kitchen: Recipe costing workbook with live formulas

Recipe costing workbook with live formulas for Willow Event Kitchen. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 19 recipe lines; Summary uses SUMIF to roll each dish up and computes margin and food-cost percent; Notes records the provenance. Exactly 94 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Willow Event Kitchen: Yield test workbook with live formulas

Yield test workbook with live formulas for Willow Event Kitchen. 2 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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 2 rows
Use case: Spreadsheet testingData import

Willow Event Kitchen: Inventory variance workbook with live formulas

Inventory variance workbook with live formulas for Willow Event Kitchen. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Willow Event Kitchen: Cost of goods sold workbook with live formulas

Cost of goods sold workbook with live formulas for Willow Event Kitchen. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 2106.63 CAD against 28781.90 CAD of net menu sales, a food cost of 7.32 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Willow Event Kitchen: Scheduled hours and overtime workbook

Scheduled hours and overtime workbook for Willow Event Kitchen. 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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Willow Event Kitchen: Workbook with intentional circular references

Workbook with intentional circular references for Willow Event Kitchen. 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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (Chicken buffet portion) at 2.19 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Willow Event Kitchen: Workbook with Excel error cells

Workbook with Excel error cells for Willow Event Kitchen. 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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Harbour Kitchen Group: Recipe costing workbook with live formulas

Recipe costing workbook with live formulas for Harbour Kitchen Group. Four sheets. Ingredients converts 6 purchase packs to a cost per recipe unit; PlateCosts holds 10 recipe lines; Summary uses SUMIF to roll each dish up and computes margin and food-cost percent; Notes records the provenance. Exactly 67 cells are live formulas with no cached value, so a values-only reader sees them empty and a recalculating reader reproduces plate-costs.csv exactly.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingData import

Harbour Kitchen Group: Yield test workbook with live formulas

Yield test workbook with live formulas for Harbour Kitchen Group. 4 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 yield against the yield the recipe applies and writes yes or no.

File: XLSX · Restaurant Costing · 4 rows
Use case: Spreadsheet testingData import

Harbour Kitchen Group: Inventory variance workbook with live formulas

Inventory variance workbook with live formulas for Harbour Kitchen Group. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import· Conversion set

Harbour Kitchen Group: Cost of goods sold workbook with live formulas

Cost of goods sold workbook with live formulas for Harbour Kitchen Group. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 3241.08 CAD against 26214.00 CAD of net menu sales, a food cost of 12.36 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.

File: XLSX · Restaurant Costing · 6 rows
Use case: Spreadsheet testingData import

Harbour Kitchen Group: Scheduled hours and overtime workbook

Scheduled hours and overtime workbook for Harbour Kitchen Group. 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 the daily and weekly figures, and the premium at half the base rate. DailyHours breaks the same segments down into 59 employee-days with a daily overtime formula above 8 hours. The period carries 5.00 payable overtime hours and 51.50 CAD of premium.

File: XLSX · Restaurant Costing · 24 rows
Use case: Spreadsheet testingData import· Paired fixture

Harbour Kitchen Group: Workbook with intentional circular references

Workbook with intentional circular references for Harbour Kitchen Group. 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 each add one to the other; B12 doubles itself. Every other cell is a plain value or a label, and B2 is the real plate cost of MENU-01 (House burger) at 3.08 CAD, so the loop is the only thing wrong with the file. Measured in LibreOffice 26.2.4.2, every formula cell on the Circular sheet recalculates to Err:522.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Harbour Kitchen Group: Workbook with Excel error cells

Workbook with Excel error cells for Harbour Kitchen Group. 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!), so a values-only reader still sees them. LiveFormulas holds 7 formulas that evaluate to an error on recalculation, including =SUM(#REF!) and =1/0, with no cached value. Its expected_error_excel column names Excel's value; the Notes sheet records the two cases where LibreOffice 26.2.4.2 was measured to disagree, so this file is also a fixture for cross-engine error mapping. The menu ids alongside them are real, so an importer that skips error cells has valid data left.

File: XLSX · Restaurant Costing
Use case: Spreadsheet testingError handling

Harbour Kitchen Group: Tip pool as an OpenDocument spreadsheet

Tip pool as an OpenDocument spreadsheet for Harbour Kitchen Group. Two tables. Points and the allocation total are live ODF formulas; the allocated amounts are the whole-cent largest-remainder shares that sum to the declared pool of 218.61 CAD.

File: ODS · Restaurant Costing
Use case: Spreadsheet testingData import· Conversion set