Pine Property Services: Policy workbook
Policy workbook for Pine Property Services. A six-sheet workbook holding the coverages, endorsements, premium chain, instalments, locations and vehicles that the policy schedule PDF prints. Sheet order matches the order the schedule presents them in, and every figure is the same value as the matching CSV.
Rendered preview of the xlsx file (9.8 KB). Download above for the original.
Specifications
- Document Set
- insurance
- Industry
- trades-property
- Source Kit
- trades-property
- Entity
- Pine Property Services
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 6
- Total Payable
- 8016.08
Testing contract
Expected to pass- Scenario
- Open each sheet and reconcile it against the CSV of the same name.
- Expected result
- All six sheets reproduce their CSV exactly, including the empty premium cells on the three general-liability sub-limits and the 1603.20 final instalment.
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
“Pine Property Services: Policy 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: 6 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("policy-workbook.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- docxPine Property Services: Certificate of insurance (DOCX)Certificate of insurance (DOCX) for Pine Property Services. A certificate of insurance issued 8 September 2026 for policy POL-2026-GL-0001, certifying cover from 1 April 2026 to 31 March 2027 to the manager of PROP-3. The issue date precedes the expiry by 204 days, which is the ordering a valid certificate has and the ordering the deliberately broken certificate in this directory does not. The PDF twin in the same directory carries the identical text.
- pdfPine Property Services: Certificate of insurance (PDF)Certificate of insurance (PDF) for Pine Property Services. A certificate of insurance issued 8 September 2026 for policy POL-2026-GL-0001, certifying cover from 1 April 2026 to 31 March 2027 to the manager of PROP-3. The issue date precedes the expiry by 204 days, which is the ordering a valid certificate has and the ordering the deliberately broken certificate in this directory does not. The DOCX twin in the same directory carries the identical text.
- pdfPine Property Services: Certificate of insurance whose expiry precedes its issue dateCertificate of insurance whose expiry precedes its issue date for Pine Property Services. A certificate issued 8 September 2026 that certifies a policy period ending 31 March 2026, which is 161 days earlier. The document is otherwise a well formed certificate with the same layout, the same limits and the same endorsement wording as the valid one, so only the date comparison catches it. Days of cover remaining reads -161.
- pdfPine Property Services: Claim settlement statementClaim settlement statement for Pine Property Services. A seven-line settlement calculation with a running balance. Assessed loss 18,400.00 USD, less 15.0 percent recoverable depreciation of 2,760.00, gives an actual cash value of 15,640.00; less the 1,000.00 USD deductible the net first payment is 14,640.00 USD. Releasing the held depreciation later brings total recovery to 17,400.00 USD, which is the assessed loss less the deductible.
- docxPine Property Services: First notice of loss claim form (DOCX)First notice of loss claim form (DOCX) for Pine Property Services. A claim form for FNOL-2026-0003, reporting an escape of water at PROP-6 on 6 August 2026, the same date and property the trades-property model records work order WO-06 against, and the one work order in that model whose completion inspection result is follow-up rather than pass. The three estimate lines of 14,200.00, 2,600.00 and 1,600.00 USD sum to the 18,400.00 USD estimated loss the settlement statement then works from. The PDF twin in the same directory carries the identical text.
- pdfPine Property Services: First notice of loss claim form (PDF)First notice of loss claim form (PDF) for Pine Property Services. A claim form for FNOL-2026-0003, reporting an escape of water at PROP-6 on 6 August 2026, the same date and property the trades-property model records work order WO-06 against, and the one work order in that model whose completion inspection result is follow-up rather than pass. The three estimate lines of 14,200.00, 2,600.00 and 1,600.00 USD sum to the 18,400.00 USD estimated loss the settlement statement then works from. The DOCX twin in the same directory carries the identical text.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.