We are testing a new beta website for gov.scot go to new site

Stand-alone HL3 Data Collection System

The HL3 Return provides placement level monitoring of temporary accommodation and associated offers.  Submission of the HL3 Return is currently on a voluntary basis.

This page contains user instructions on how to use the stand-alone HL3 data collection system, together with the system itself.  The system is available in Excel 2010 although an Excel 2003-2007 version can also be made available on request.  The stand-alone system is intended to help local authorities to systematically record offers of temporary accommodation and also to generate the HL3 Return.

Where possible local authorities should seek to develop their own integrated IT solutions  to produce the HL3 Return.  This should minimise officers having to enter the same data into two different systems.

Where a local, integrated IT solution is not possible, then the stand-alone system may be used as an alternative.

The stand-alone system can be used in two ways:
1. Local Authority Mode: All temporary accommodation offers are recorded for an entire local authority area. The HL3 Return is then sent directly to the Scottish Government.

2. Area Office Mode:  Each area office records its temporary accommodation offers separately. HL3 Returns are then sent to a central collection point before being sent to the Scottish Government.

Note: To use the system, macros must be enabled in the Excel workbook.

Enable Content for Excel Macros

 

 

Files to Download - Excel 2010 Version

Downloadable documents:

Title:Stand-alone HL3 Data Collection System
Description:Stand-alone HL3 Data Collection System to help local authorities record offers of temporary accommodation.
File:HL3 Combine and Send Tool (Version 2) [XLSM, 50.8 kb: 10 Apr 2015]
Open | Open in new window
File:User Instructions (Version 4) [DOC, 6933.5 kb: 16 Jul 2015]
Open | Open in new window
File:User Instructions (Version 4) [PDF, 4952.9 kb: 16 Jul 2015]
Open | Open in new window
File:HL3 Stand-alone Data Collection System (Version 5) [XLSM, 2582.5 kb: 13 Nov 2015]
Open | Open in new window
 Viewer Help

What's New?

13/11/2015 - Version 5 ensures that all property UPRNs are re-calculated prior to the creation of the HL3 extract and ensures these are used in the extract.

Version 4 fixes a bug in how dates were produced in the HL3 extract.  Dates such as 10th July 2015 were being written as 07/10/2015 rather than 10/07/2015.

Version 3b allows any dates to be entered for TA placements.  Previous versions restricted offer dates to be on or after 1 April 2015.

Excel 2003 and 2007 Versions

Downloadable documents:

Title:Stand-alone HL3 Data Collection System
Description:Stand-alone HL3 Data Collection System to help local authorities record offers of temporary accommodation.
File:HL3 Combine and Send (Excel 2003 & 2007 Version 2) [XLS, 73.7 kb: 10 Apr 2015]
Open | Open in new window
File:HL3 Stand-alone Data Collection System (Excel 2003 & 2007 Version 5) [XLS, 9609.7 kb: 13 Nov 2015]
Open | Open in new window
 Viewer Help

Patches

Downloadable document:

Title:Stand-alone HL3 Data Collection System
Description:Stand-alone HL3 Data Collection System to help local authorities record offers of temporary accommodation.
File:GenerateCSV fix 13112015 1749.txt [TXT, 14.8 kb: 13 Nov 2015]
Open | Open in new window
 Viewer Help

North Ayrshire Council Version

Downloadable document:

Title:Stand-alone HL3 Data Collection System
Description:Stand-alone HL3 Data Collection System to help local authorities record offers of temporary accommodation.
File:VBA Modules for NAC HL3 Standalone System [ZIP, 17.5 kb: 27 Jan 2016]
Open | Open in new window
 Viewer Help