Tern Client Services: Sales pipeline workbook
Sales pipeline workbook for Tern Client Services. Two worksheets: Deals (12 rows, the same data as pipeline-export.csv) and By stage (4 rows). The By stage sheet is derived from the Deals sheet, so its amount column sums to the same 34500.00 and its share_of_pipeline_percent column sums to 100.00.
Rendered preview of the xlsx file (6.4 KB). Download above for the original.
Specifications
- Document Set
- professional-services
- Industry
- professional-services
- Source Kit
- crm-services
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 2
- Deals
- 12
- Stages
- 4
Testing contract
Expected to pass- Scenario
- Open the workbook and rebuild the By stage sheet from the Deals sheet.
- Expected result
- Grouping the 12 Deals rows by stage reproduces all 4 By stage rows exactly; the amount column totals 34500.00, the weighted column 15825.00 and the percentage column 100.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: Sales pipeline 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("pipeline-export.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- mdTern Client Services: Document set READMEDocument set README for Tern Client Services. 27 files, 1 of them intentionally invalid, with the reconciliation identities and the exact defect in each broken file named in full.
- pdfTern Client Services: Expense claim PDFExpense claim PDF for Tern Client Services. A one-page expense claim. The line table closes on 221.57 and the allocation table splits the same figure into 146.32 of mileage and 75.25 of receipted items across the three projects.
- pdfTern Client Services: Fee schedule PDFFee schedule PDF for Tern Client Services. A one-page rate card listing the same 5 codes as fee-schedule.csv with the standard rate at 100.00 per hour and mileage at 0.62 per kilometre. The notes state that COST is internal and never billed.
- pdfTern Client Services: Progress bill PDFProgress bill PDF for Tern Client Services. A one-page progress bill for PROJECT-3 against a 4,000.00 budget. It states 3,200.00 of work completed, 80.00 percent of budget, nothing previously billed, 3,200.00 payable in cash and 800.00 of budget remaining.
- pdfTern Client Services: Project timesheet PDFProject timesheet PDF for Tern Client Services. A one-page timesheet for PROJECT-3. The entry table lists 8 lines and closes on a Total row of 32 hours and 3,200.00.
- pdfTern Client Services: Retainer statement PDFRetainer statement PDF for Tern Client Services. A one-page retainer statement. The movement table replays the three ledger entries to a closing balance of 0.00 and the invoice table shows 4,000.00 of the 7,200.00 billed taken from the retainer, leaving 3,200.00 in cash. Draws are printed in accounting parentheses.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.