A programme of homes and a very large spreadsheet
A housing association has instructed your practice to survey a sample of its homes: every element from roof coverings to kitchens and boilers, with condition, remaining life and quantities, so it can plan its investment. Each survey is short. There are a great many of them, across several surveyors, over months.
Surveyors record data on whichever tool or form they prefer. At the office, someone reshapes it into the client's spreadsheet format and element codes. Inconsistencies appear: a kitchen recorded as fitted in one year by one surveyor and a different year by another; condition scores used differently; missing photos. The client's asset team sends back questions, and some homes have to be revisited.
Why programme data gets messy
- Each client has its own element list, codes and lifecycle rules.
- Surveyors capture data differently, even with guidance.
- Validation happens at the office, after the surveyor has left the home.
- Photos are not reliably linked to the property and element.
- Reshaping data into the client's format is manual.
What messy data costs
Office time spent cleaning and reshaping. Revisits to homes where data is missing or contradictory, which means another appointment with a tenant. Delays to the client's investment planning. And a weaker case for future programmes if the client's asset team finds the data hard to trust.
| Issue | When it is found today | When it is found with validation |
|---|---|---|
| Missing element | At the office | Before the surveyor leaves the home |
| Impossible date or life | When the client checks | As it is entered |
| Inconsistent condition scoring | In the client's analysis | Flagged against programme norms |
| Photo not linked | When the client asks | Required at capture where your brief says |
| Wrong format | At export | Never, export follows the client's format |
The stock condition capture we build
- For each client, the element list, codes, condition scale and lifecycle rules are set up in the capture tool, along with the property list.
- Surveyors work on a tablet, property by property, with the element list in the order they walk the home, and photos taken against each element.
- Entries are checked as they are made: required elements, sensible dates and remaining lives, and quantities within expected ranges for the property type.
- Before leaving the home, the surveyor sees any gaps or warnings and resolves them.
- Data syncs to a central store, where a programme manager sees progress and flags unusual patterns, such as one surveyor scoring consistently differently.
- Exports follow the client's format and element codes, with photos linked, ready to load into the client's asset management system.
Condition and remaining life are surveyor judgements. Validation checks for gaps and implausible entries. It does not assess the property.
Cleaner programmes
Data leaves each home complete. The office stops reshaping spreadsheets. Revisits are rare. The client's asset team receives data in its own format, which builds confidence in your practice for the next programme. And programme managers can see progress and consistency week by week.
Tenant appointments are easier to manage too, because the same tool can record missed access and rebook, so the property list always shows what is surveyed, booked or outstanding.
Health and safety observations that the client wants recorded alongside condition data, such as a visible hazard, can be captured in the same visit and routed to the client's named contact straight away, rather than waiting in a spreadsheet for the end of the programme. What counts as such an observation is set by the client's brief.
Is your stock condition programme like this?
- Site data is retyped or reshaped into client spreadsheets.
- Homes are revisited because data was missing.
- Surveyors score condition inconsistently.
- Photos are not reliably linked to elements.
- Clients send back questions about data quality.