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

Scottish Household Survey - Local Authority Tables - Guidance

Scottish Household Survey logo

This paper provides advice on how to adapt the SHS Local Authority Tables to view the underlying data used to produce the interactive tables and charts. This requires that the user has good experience of using Microsoft Excel through being able to set options and manipulate rows and columns. The SHS Project Team is happy to provide further support as required.

Please note that the data used to populate the tables and charts are ‘hidden’ in the same worksheets, in the rows immediately beneath each piece of presented analysis.  There is no password used to protect the content.  Users should be aware that they may cause problems in the LA Tables if they manipulate the underlying data so please copy and paste to new documents before attempting to modify any estimates.

Download

Downloadable document:

Title:Scottish Household Survey - Local Authority Tables - Guidance
Description:Guidance on how to view the underlying data in the SHS Local Authority Tables
File:SHS - LA Tables - Guidance [PDF, 330.7 kb: 21 Jun 2012]
Open | Open in new window
 Viewer Help