Pine Property Services: Schedule of dilapidations lines
Schedule of dilapidations lines for Pine Property Services. The same 12 lines as data, with subtotal and total rows carrying an empty item_ref so they can be told apart from costed items. Only the 5 rows with a reference beginning D are remedial works; the rest are on costs, subtotals or the consequential loss.
item_ref,item,breach_of_clause,cost_usd,category
D1,Redecoration of the demise to the standard in the schedule of condition,6.1,8400.00,remedial works
D2,Reinstatement of partitions installed under licence,6.1,6250.00,remedial works
D3,Replacement of floor covering,6.1,4180.00,remedial works
D4,Ceiling tile replacement in the rear office,6.1,1260.00,remedial works
D5,Mechanical and electrical testing and certification,6.1,2340.00,remedial works
,Works subtotal,,22430.00,subtotal
P1,Preliminaries at 8 percent of the works subtotal,,1794.40,on cost
,Works cost,,24224.40,subtotal
P2,Contract administration at 5 percent of the works cost,,1211.22,on cost
,Total works,,25435.62,subtotal
L1,Loss of rent for 8 weeks at the passing rent,6.1,5653.85,consequential loss
,Total claim,,31089.47,total
Specifications
- Document Set
- property
- Industry
- trades-property
- Source Kit
- trades-property
- Entity
- Pine Property Services
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 12
- Costed Items
- 5
- Subtotal Rows
- 3
- Total Claim
- 31089.47
- Double Count Trap
- true
Testing contract
Expected to pass- Scenario
- Filter to the costed work items and sum them, then follow the subtotal chain down.
- Expected result
- The 5 D rows sum to 22430.00, the works subtotal. Summing every row with a cost gives 134268.96, which is meaningless because the subtotal and total rows are included in it.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Pine Property Services: Schedule of dilapidations lines” is a deterministic Testaroo fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 12 rows. 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.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("dilapidations-schedule.csv")
print(df.head())
print(df.dtypes)Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.
Related files
- csvPine Property Services: Arrears reportArrears report for Pine Property Services. The one genuine arrear: U-05 owes 16012.50 USD for 2026-Q3, due 2026-07-01 and 69 days overdue at the 2026-09-08 snapshot, which puts it in the 61 to 90 day bucket. The 5 fourth-quarter demands are deliberately absent because a demand for a quarter that has not started is not an arrear.
- csvPine Property Services: Building works recharged to the service chargeBuilding works recharged to the service charge for Pine Property Services. The 2 work orders the trades-property model records against PROP-1, with their labour and material costs, totalling 328.00 USD. All of them are recharged to the repairs and maintenance head, which is budgeted at 32,192.36 USD and spent at 31,240.00, so these rows are a subset of that head rather than the whole of it.
- csvPine Property Services: Deposit registerDeposit register for Pine Property Services. The 5 deposits, each two quarterly instalments of the rent on its own lease, holding 122,737.50 USD in total. Every deposit is released on expiry subject to a dilapidations claim, which is what connects this register to the dilapidations schedule in the same directory.
- csvPine Property Services: Lease abstractLease abstract for Pine Property Services. The 5 let demises abstracted onto one row each: term, break, review, rent, service charge proportion and deposit. Quarterly rent is a quarter of annual rent and the deposit is two quarters on every row. Only LSE-2026-02 has a break date, so four of the five rows carry an empty break_date and an empty break_notice_by.
- csvPine Property Services: Lease events diaryLease events diary for Pine Property Services. 12 dated events in ascending order with days measured from the 2026-09-08 snapshot. 1 of them are already in the past and carry a negative number, because a rent review date that has passed is still a fact about the lease and dropping it would hide a review that was never actioned.
- csvPine Property Services: Lease registerLease register for Pine Property Services. The 5 live leases with days to expiry measured from the 2026-09-08 snapshot. The shortest has 935 days to run and the longest 2761. Service charge percentages here are the same apportionment the budget and reconciliation use, so the register can be joined to either.
