17.5 Downloads and Worksheets

Publication Date: 
15 December 2009


This section contains links to the worksheets and tables which practitioners may need during the course of a STAG Appraisal.

Worksheets are provided both as an MS Word file, to allow practitioners to edit them, and as a PDF file.

MS Excel Spreadsheets have been provided where their functions are need for calculation purposes.

 Appraisal Summary Tables

   

 Part 1 Appraisal Summary Tables

 Word  PDF 

 Part 2 Appraisal Summary Tables

 Word  PDF 

 Option Summary Table

   

 Option Summary Table

 Word  PDF 

 Worksheets

   

 Economy Worksheets - Economic Activity and Location Impacts

 Word  PDF 

 Environment Worksheets

 Word  PDF 

 Excel Spreadsheets

   

 CO2 Monetisation Spreadsheet

 Excel  

 Agglomeration Spreadsheet - TMfS Version

 Agglomeration Spreadsheet - General Version

 Excel

 Excel

 
     

A copy of the DMRB Air Quality Screening spreadsheet can be downloaded from the Highways Agency website here. Note that the latest version of this spreadsheet gives outputs in terms of tonnes of carbon, which must be converted to tonnes CO2 for reporting purposes in STAG.

A copy of the LAQ Excel spreadsheet produced by the Department for Transport is available from WebTAG here.

 

Contact Information

Email:
info@­transportscotland.­gsi.­gov.­uk

or by phone Monday to Friday, 08:00 AM to 05:00 PM

Telephone: 0141 272 7100