Code of Practice on Local Authority Transport Infrastructure Assets – supporting documents

These supporting materials were developed by the Highways Asset Management Financial Information Group to help authorities comply with the requirements of the Code of Practice on Local Authority Transport Infrastructure Assets (Transport Code).

2015/16 Highways Network Asset Valuations – Update from HAMFIG – June 2016

Please be aware that an updated version of the Structures Toolkit has been published below. It is essential that this new version of the toolkit is utilised to support the completion of this year's WGA returns. Updated versions of the Valuation Variables Files for both the Structures Toolkit and the Valuation Toolkit have also been published. These files enable the toolkits to be populated with the latest variables (eg rates) correct as of 31 March 2016, and should be used to complete the 2015/16 valuations. The updated versions of the Structures Toolkit are already populated with the latest variables.

Please note that if you have already populated the previous version of the Structures Toolkit (ie Small Version 301 or Full Version 301), then you will need to cut and paste your input data into the updated version, and then re-run the toolkit. We apologise for this minor inconvenience but this step is essential to ensure that the valuations are produced correctly.

Should you require further support, please contact the HAMFIG Helpdesk on T: 0121 483 5665, or via email at E: HAMFIG@atkinsglobal.com.

Toolkits

Updated 15 June 2016

2015/16 Valuation Toolkit

This toolkit has been created to support local authorities in completing their 2015/16 transport infrastructure valuations. The toolkit is compliant with the Transport Code and supports the calculation of:

  • GRC values for carriageways and land; and
  • GRC, DRC, accumulated depreciation and annual depreciation values for footways and cycleways, street lighting, street furniture and traffic management equipment.

UKPMS systems reports provide accumulated depreciation and annual depreciation values for carriageways.

  • 2015/16 Valuation Toolkit Version 2.6, (Excel, 0.5 MB) 7 March 2016
  • 2015/16 Valuation Toolkit Variables Version 1.2, (Excel, 33 KB). Version 1.1 of this file was released on 7 March 2016. The latest version (Version 1.2) was released on 15 June 2016 and has been updated with the latest variables as at the end of March 2016. This process enabled the Toolkits to be issued earlier than in previous years and provided authorities with the opportunity to complete the toolkit in advance of the final indices being available.

Please note that local authorities should now undertake the following steps to complete their 16/17 valuations:

  • Download and save the 2015/16 Valuation Toolkit, Version 2.6 (if not already completed).
  • Populate the toolkit by following the instructions provided within it (if not already completed).
  • Download and save the 2015/16 Valuation Toolkit Variables File, Version 1.2.
  • Update the Valuation Toolkit by pressing the 'Update Rates' button on the homepage of the toolkit and then follow the instructions.

2015/16 Structures Toolkit

This toolkit has been created to support all local authorities complete their 2015/16 structures valuations. The toolkit supports the calculation of:

  • GRC, DRC, accumulated depreciation and annual depreciation values for structures.

This toolkit has been developed in full compliance with the 2013 edition of the Transport Code.

  • 2015/16 Structures Toolkit Small Version 305 (Excel, 9.5 MB), for a maximum of 250 individual or groups of structures and 3,750 elements on those structures. This will calculate GRC and DRC. Version 301 of this file was released on 7 March 2016. The latest version of this file (Version 305) was released on 15 June 2016 and already includes the variables in Version 2.2 of the variables file.
  • 2015/16 Structures Toolkit Full Version 305 (Excel, 60.3 MB) (right click and 'Save Target As' to download). Version 301 of this file was released on 7 March 2016. The latest version of this file (Version 305) was released on 15 June 2016 and already includes the variables in Version 2.2. of the variables file.
  • 2015/16 Structures Toolkit Valuation Variables Version File 2.2 (Excel, 1.2 MB) Version 2.1 of this file was released on 7 March 2016. The latest version of this file (Version 2.2) was released on 15 June 2016 and has been updated with the latest variables as at the end of March 2016. This process enabled the toolkits to be issued earlier than in previous years and provided authorities with the opportunity to complete the toolkits in advance of the final indices being available. Please note that the variables in this file are already included in Versions 305 of the Structures Toolkit.
  • Span Level Conversion Tool Version 301 (Excel, 1.7 MB), 7 March 2016. This file converts span level data to structure level for use in the Structures Toolkit.

Please note that local authorities should now undertake the following steps to complete their 2016/17 structures valuations:

  • Download and save the 2015/16 Structures Toolkit, Small Version 305, or the Full Version 305, as appropriate.
  • Populate and run the toolkit by following the instructions provided within both the toolkit and the supporting guidance.
  • If you have already populated the previous version of the 2015/16 structures toolkit (ie Small Version 301 or Full Version 301), then you will need to cut and paste your input data into the updated version of the toolkit. This is essential.
  • When cutting and pasting data into the Structures Toolkit, please ensure that the 'paste values' function is utilised to ensure that the toolkit functions as designed.
  • Users of the toolkit should be aware that pasting data into the toolkit may have some potentially unexpected consequences. Many cells have data validation criteria, which prevent invalid values from being entered; however, this data validation is ignored when data is pasted in and the user is not warned. This is standard Excel behaviour. Note, though, that invalid data entered in this way should result in an error message in the ‘Checks’ columns – users are advised to carefully review the ‘Checks’ columns prior to running a valuation.
  • Note that when pasting data into the ‘Structures Database’ input sheet, users should do so in two steps: first paste data into columns B to P, then paste data into columns Y to AC. Due to hidden columns, data cannot be pasted into the toolkit in one go.
  • Following the entry of data into the ‘Structures Database’ and the ‘Element Database’, please ensure the ‘Calculation Options’ are set to ‘Automatic’ otherwise the validation checks in Columns BA and Z respectively will not operate and the toolkit may not run as designed. The ‘Calculation Options’ can be found on the ‘Formulas’ option on the menu bar. Please also ensure that the ‘Calculation Options’ are set to ‘Automatic’ prior to analysing a new scenario.
Note that both the small and full versions of the structures toolkit require Excel 2007 to run the required macros. They will not run on older versions of Excel.

HAMFIG Helpdesk

For help with either the Structure Toolkit or the Carriageway and Footway GRC Valuation Toolkit, please contact the HAMFIG Helpdesk or telephone T: 0121 483 5665.

Other notes

Technical Note – Guidance on Calculating GRC/DRC Updated April 2015

Useful weblinks