- This Workbook collects into a Combined data sheet, data published on this UK Gov website, of end-of-week totals for visas issued and arrivals under the Homes for Ukraine scheme. See here
- From the Combined data a Rolling report is generated showing the same data by week since May 10th, the first data recorded after the start of the scheme
- From the Rolling report a forecast is generated of numbers at risk of homelessness 6 months after their arrival if No Action is taken by UK government and local authorities to prevent homelessness
- This No Action report applies two factors to the raw Rolling report data which are set out in the table above: likely homelessness % and cost per week of temporary accommodation.
- A second Action report applies different factors assuming effective action is taken to prevent homelessness, specifically, but not exclusively, a proactive rematching campaign.
- The Reporting sheet compares No Action to Action results, showing potential savings in terms of people and costs of an effective Action campaign week by week for the next 6 months
- The reporting box shows, at local authority and country level, how many people could be saved from homelessness and how much cash could be saved after 6 months by an effective Action campaign
These spreadsheets are password protected. If you would like access to them, you can contact me at friendshipcentre@gmail.com.
The data that powers this spreadsheet was extracted from UK Government ukraine sponsorship scheme visa data