Pine Property Services: Rent roll workbook
Rent roll workbook for Pine Property Services. A two-sheet workbook holding the rent roll and the area schedule. The two sheets carry the same six areas, so the building area check can be run within the workbook: both sum to 1200.00 sq m.
Rendered preview of the xlsx file (6.6 KB). Download above for the original.
Specifications
- Document Set
- property
- Industry
- trades-property
- Source Kit
- trades-property
- Entity
- Pine Property Services
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 2
- Rows
- 6
- Building Area
- 1200.00
Testing contract
Expected to pass- Scenario
- Sum the area column on both sheets and compare them with each other and with the building area on the rent roll sheet.
- Expected result
- Both sheets sum to 1200.00, which is the building_area_sq_m value on every rent roll row. The broken variant in this directory fails that comparison by 18.50 sq m.
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: Rent roll 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 rows · 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("rent-roll.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- docxPine Property Services: Commercial lease (DOCX)Commercial lease (DOCX) for Pine Property Services. A ten year lease of U-02 from 1 April 2024 to 31 March 2034, with a tenant break at 31 March 2029 and a rent review the day after. Clause 3.1 states the rent as 195.00 sq m at 225.00 USD, which is 43,875.00 a year and 10,968.75 a quarter, and clause 4.1 fixes the service charge proportion at 16.2500 percent, the area of the demise over the lettable area. Clause 4.3 says in words that the common parts are excluded from the denominator, which is why the six proportions add to one hundred percent. The PDF twin in the same directory carries the identical text.
- pdfPine Property Services: Commercial lease (PDF)Commercial lease (PDF) for Pine Property Services. A ten year lease of U-02 from 1 April 2024 to 31 March 2034, with a tenant break at 31 March 2029 and a rent review the day after. Clause 3.1 states the rent as 195.00 sq m at 225.00 USD, which is 43,875.00 a year and 10,968.75 a quarter, and clause 4.1 fixes the service charge proportion at 16.2500 percent, the area of the demise over the lettable area. Clause 4.3 says in words that the common parts are excluded from the denominator, which is why the six proportions add to one hundred percent. The DOCX twin in the same directory carries the identical text.
- mdPine Property Services: property document set READMEDocument set README for Pine Property Services. 26 files, 1 of them intentionally invalid, with the reconciliation identities, the declared parameters and the measured size of each deliberate defect named in full.
- pdfPine Property Services: Quarterly rent and service charge demandQuarterly rent and service charge demand for Pine Property Services. The 2026-Q4 demand across the 5 let demises: 61,368.75 USD of rent and 21,400.00 of service charge on account, 82,768.75 in total. It states in words that the vacant demise is not demanded and that the 6,476.00 USD balancing charge is dealt with separately, which are the two amounts most easily double counted.
- pdfPine Property Services: Schedule of dilapidationsSchedule of dilapidations for Pine Property Services. A served dilapidations schedule against U-04: 5 remedial items totalling 22,430.00 USD, preliminaries at 8 percent of that, contract administration at 5 percent of the running total, and 5,653.85 USD of lost rent for a 8 week programme, giving a 31,089.47 USD claim. Each on cost states the base it is charged on, so the compounding order is visible rather than assumed.
- pdfPine Property Services: Service charge reconciliation statementService charge reconciliation statement for Pine Property Services. The statement a tenant receives: expenditure by head of charge against budget, then the apportionment by demise. Actual expenditure is 102,476.00 USD against 96,000.00 budgeted, and the 6,476.00 USD overspend is recovered by balancing charges that sum to the same figure. The statement explains in words why the common parts are outside the denominator and why the vacant unit share stays with the landlord.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.