Standard workbook
A structured Excel workbook bringing together household circumstances, property evidence, unanswered questions and officer findings, with a summary and draft letter. It works without VBA macros.
Clear Ground · Practical resources
Digital Tools
Explore Clear Ground’s digital projects for housing and homelessness work. These demonstrations show how specialist sector knowledge can be translated into practical tools that organise information and support professional reasoning.
Prototype — available to explore
Us — The Key to Housing Services
Explore the Us housing-services prototype. It is a developing demonstration, not a live case-management service.
This link leads to a separate prototype website.
Portfolio project · Demonstration available
Clear Ground Accommodation Suitability Tool
Building on my experience of creating an earlier accommodation-suitability tool, I have built a new Clear Ground version from scratch with newly written code.
The project focuses on a practical challenge: helping officers bring together household circumstances, property evidence and their reasons when assessing accommodation suitability within statutory homelessness work.
The work so far includes two workbook editions and a separate web-based demonstration.
What I have built
Enhanced workbook
An edition with additional VBA-enabled recording and export features, including a case log and actions for producing summary and letter PDFs. VBA execution in desktop Excel remains to be tested.
Guided portfolio demonstration
A four-step walkthrough using a fictional household and proposed property. It shows how evidence, unanswered questions and professional reasoning can be organised into an assessment record. Selected workbook images show the underlying design.
Explore the work
The online demonstration illustrates the approach; it does not run the Excel workbooks or VBA, collect case information or make a suitability decision.
This link opens a separate Clear Ground portfolio site.
View the portfolio demonstration
Current status
The workbooks have been built, with initial formula and layout checks carried out in an office suite. Desktop Excel testing remains outstanding, including VBA execution and a final print-layout check. Legal accuracy has not been independently validated.
This is a portfolio demonstration, not a tool offered for operational use. Working files are not available as public downloads.