Skip to content
Novus Examples
xlsx7.2 KB

Tern Client Services: Contract register workbook

Contract register workbook for Tern Client Services. A two-sheet workbook: Contracts holds the 11 register rows and Rate card holds the 5 priced terms, including both expense caps with their effective-from and effective-to dates so the amendment is visible as a date range rather than a contradiction.

Rendered preview of Tern Client Services: Contract register workbook

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

Specifications

Document Set
contracts
Industry
professional-services
Source Kit
crm-services
Entity
Tern Client Services
Synthetic
true
As Of
2026-09-08
Sheets
2
Contract Rows
11
Rate Rows
5

Testing contract

Expected to pass
Scenario
Open both sheets and look up the expense cap that applies to an expense dated 2026-09-15.
Expected result
The Rate card sheet holds two expense-cap rows: 250.00 effective 2026-01-05 to 2026-08-31 and 400.00 effective 2026-09-01 with no end date, so the answer is 400.00.

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

“Tern Client Services: Contract register 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("contract-register.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)

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