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.