Skip to content
Novus Examples
xlsx6.3 KB

Willow Community Fund: Grant reporting workbook

Grant reporting workbook for Willow Community Fund. Two worksheets: Grant register (3 rows) and Budget vs actual (10 rows). The budget column of the second sheet rolls up to the awarded column of the first, 4500.00, and the pending grant appears on the register with no budget sheet rows at all.

Rendered preview of Willow Community Fund: Grant reporting workbook

Rendered preview of the xlsx file (6.3 KB). Download above for the original.

Specifications

Document Set
nonprofit
Industry
nonprofit
Source Kit
nonprofit-fundraising
Synthetic
true
As Of
2026-09-08
Sheets
2
Grants
3
Budget Lines
10

Testing contract

Expected to pass
Scenario
Open the workbook and roll the Budget vs actual sheet up to the Grant register sheet.
Expected result
The 2 Grant total rows equal the awarded amounts on the register, 4500.00 together, and the pending grant has no rows on the second sheet, so no unawarded money is budgeted.

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

“Willow Community Fund: Grant reporting 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: 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("grant-budget-vs-actual.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)

Generated by generation/industry_documents.py. Free for any use, no attribution required, license.