{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Home Page","Valuation Summary","Carriageways & Footways GRC","Footways DRC","Street Lighting GRC & DRC","Traffic Mangt Eqpt GRC & DRC","Street Furniture GRC & DRC","SF - Own Data","SF - Derbyshire","SF - Hertfordshire","SF - Medway","Land GRC","Certificate","Valuation Variables","Regions","Regional Factors","GRC Rates","Land Values","List"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[29,4,29,15],[31,4,31,15],[23,8,23,9],[24,8,24,9],[1,1,2,16],[17,2,18,15],[29,2,29,3],[4,2,4,16],[19,2,21,15],[23,2,23,3],[24,2,24,3],[23,4,23,5],[24,4,24,5],[23,6,23,7],[24,6,24,7],[32,4,32,15],[33,4,33,15],[48,3,48,5],[30,2,30,3],[44,4,44,16],[45,4,45,16],[37,2,38,12],[31,2,31,3],[32,2,32,3],[33,2,33,3],[30,4,30,15]]}
[]
[null,"Valuation Toolkit"]
[]
[]
[null,null,"Valuation Toolkit for Carriageways, Footways & Cycleways, Street Lighting, Street Furniture and Traffic Management Equipment."]
[]
[null,null,null,"These cells need to be completed with own data."]
[]
[null,null,null,"These cells are pre-populated with a formula but your own data can be added if you do not need the formula."]
[]
[null,null,null,"Reference only."]
[]
[null,null,null,"Help or more information per page."]
[]
[null,null,null,"More information per cell."]
[]
[]
[null,null,"Please download the latest version of the Valuations Variables File from the CIPFA website and update the rates using the button below."]
[]
[null,null,"The Valuation Variables Sheet holds all variables needed to complete this toolkit for each Local Authority. Included are Regional Factors, Inflation rates, HAMFIG default GRC rates and Land Rates. Please use the Update Rate button to use the latest rates that have been downloaded."]
[]
[]
[]
[null,null,"Version Control",null,"Regional Factors",null,"GRC Rates",null,"Land Values"]
[null,null,{"$f":"'Valuation Variables'!B8","v":"Version 1.4"},null,{"$f":"'Valuation Variables'!C8","v":"2017-06-21"},null,{"$f":"'Valuation Variables'!D8","v":"2018-06-06"},null,{"$f":"'Valuation Variables'!E8","v":"2018-06-13"}]
[]
[]
[null,null,"Version Control"]
[]
[null,null,"14/15 Valuation Toolkit, Version 1.3, Apr 2015 ",null,"For use with the 14/15 valuations."]
[null,null,"14/15 Valuation Toolkit, Version 1.4, Jun 2015",null,"Page Setup' amended to enable worksheets to be printed; Note 4 on 'Land GRC' worksheet updated; Formatting in 'Comments' cells amended to enable larger quantities of text to be displayed; Regional Factor function updated on Carriageways & Footways GRC sheet to enable 'Yorkshire & Humber' Authorities to be selected."]
[null,null,"15/16 Valuation Toolkit, Version 2.4, Oct 2015",null,"\"Help\" button for more information.\nChange Register added to the end of each calculator (worksheet)\n\n"]
[null,null,"15/16 Valuation Toolkit, Version 2.5, Nov 2015",null,"Draft Issue for HAMFIG"]
[null,null,"15/16 Valuation Toolkit, Version 2.6, Feb 2016",null,"Update to Footways DRC sheet following an update to the Footways DRC methodology in the Transport Code and Transport Guidance.\nPrintable certificate produced on completion of Valuation Toolkit.\nHelpdesk number changed to 0121 483 5665"]
[]
[null,null,"Certificate"]
[]
[null,null,"Once Local Authorities have completed their Valuation, they can click on the 'Create Certificate' button to create a PDF Certificate."]
[]
[]
[null,null,"Questions and Queries"]
[]
[null,"Please refer to the Transport Code and Transport Guidance for support in completing this toolkit. Links can be found here:"]
[]
[null,null,"Transport Code:",null,"http://www.cipfa.org/policy-and-guidance/local-authority-transport-infrastructure-assets "]
[null,null,"Transport Guidance:",null,"http://www.cipfa.org/policy-and-guidance/local-authority-transport-infrastructure-assets/local-authority-transport-infrastructure-assets-supporting-documents"]
[]
[null,null,"If you have any questions or queries regarding this spreadsheet, please contact the HAMFIG Helpdesk:"]
[null,null,"Email","hamfig@atkinsglobal.com"]
[null,null,"Telephone","0121 483 5665"]

{"sheet":"Valuation Summary","index":1,"n_rows":129,"n_cols":11,"rows_kept":129,"cut":false,"hidden":false,"merged":[[126,1,126,2],[124,3,124,6],[115,2,121,10],[8,2,8,10],[10,2,10,10],[50,4,51,4],[17,2,17,11],[18,2,18,10],[11,2,11,10],[16,2,16,9],[114,2,114,10],[65,2,65,10],[62,2,62,10],[63,2,63,10],[124,1,124,2],[2,2,2,10],[4,2,4,10],[112,2,112,11],[67,2,67,11],[68,2,68,11],[50,3,51,3],[50,2,51,2],[111,3,111,6],[50,7,51,7],[50,6,51,6],[50,5,51,5],[49,3,49,6],[5,3,5,11],[6,2,6,10],[48,2,48,7],[7,2,7,10]]}
[]
[]
[null,null,"Valuation Summary"]
[]
[null,null,"Highways Infrastructure Assets"]
[]
[null,null,"This tab is used to capture the information required by local authorities to value their Highways Network Assets on a  Depreciated Replacement Cost (DRC) basis. This information is required for Whole of Government Accounts (WGA) purposes for 2015/16 and from 2016/17 local authorities will be required to value their Highways Network Assets on a DRC basis in their financial statements. Please be aware that in many cases local authority staff outside of the central finance team, such as asset management and engineering staff, are undertaking this work. "]
[null,null,"Please refer to the Data Collection Pack (DCT) guidance, CIPFA's Code of Practice on Transport Infrastructure Assets and the accompanying Guidance Notes, and the Highways Asset Management Financial Information Group's (HAMFIG) supporting materials on the CIPFA website."]
[null,null,"Due to the resources and cost involved in auditing the data in this era of substantially tighter public spending, this data has yet to be  audited. This should not detract from the worth of the Highways Infrastructure work and the improved services and efficiency savings that will result. "]
[]
[null,null,"We stress the importance of providing the data to the same quality required for audit review, given the size and complexity of the task, and so that the momentum of the work is maintained. In addition, the quality of the data will feed into the discussion of including local authority Highways Infrastructure Assets in the WGA account itself overall for 2015-16. All estimates should be calculated on the basis set out in the CIPFA Code of Practice on Transport Infrastructure Assets and the accompanying Guidance Notes."]
[null,null,"IMPORTANT:  Figures must be rounded to thousands (£'000s), and the 2015-16 figures in PP&E that feed into the Balance Sheet should still be Historical Cost in the DCT and Statement of Accounts. If you are a body that does not have a Highways Network Asset please enter zeros in order for your DCT to validate. Please provide an explanation to support the entry of zero balances. "]
[]
[null,null,"Code and information on its development (CIPFA):","http://www.cipfa.org/policy-and-guidance/local-authority-transport-infrastructure-assets "]
[null,null,"Supporting materials and spreadsheet calculation templates (CIPFA): ","http://www.cipfa.org/policy-and-guidance/local-authority-transport-infrastructure-assets/local-authority-transport-infrastructure-assets-supporting-documents"]
[]
[null,null,"Please confirm that you have completed this questionnaire by selecting yes in the drop-down box on the right. If you are not completing the questionnaire due to not having a Highways Network Asset, please select the relevant option in the box. Please note that you will be required to comment if you have not completed the questionnaire fully on the validations sheet before you lock your pack."]
[]
[null,null,"DATA REQUIRED: GRC, DRC & lands data estimates"]
[]
[null,null,"Section 1: DRC Disclosure for PPE Note"]
[]
[null,null,"Gross Replacement Cost","Carriageway\n£,000s","Footways + Cycleways\n£,000s","Structures\n£,000s","Street Lighting\n£,000s","Traffic Management\n£,000s","Street furniture\n£,000s","Land\n£,000s","Total \n£,000s"]
[null,null,"GRC Opening Balance",null,null,null,null,null,null,null,{"$f":"SUM(D24:J24)","v":0}]
[null,null,"Additions",null,null,null,null,null,null,null,0]
[null,null,"Revaluation increases / (decreases) recognised in the Revaluation Reserve",{"$f":"D30-D24-D25-D27-D28-D29","v":0},0,0,0,0,0,0,{"$f":"SUM(D26:J26)","v":0}]
[null,null,"Revaluation increases / (decreases) recognised in the Surplus/Deficit on the Provision of Services",null,null,null,null,null,null,null,0]
[null,null,"Disposals / Derecognition",null,null,null,null,null,null,null,0]
[null,null,"Other",null,null,null,null,null,null,null,0]
[null,null,"GRC Closing Balance",{"$f":"IFERROR('Carriageways & Footways GRC'!$P$42,\"Enter a GRC Value\")","v":0},{"$f":"IFERROR('Carriageways & Footways GRC'!$P$44,\"Enter a GRC Value\")","v":0},null,{"$f":"IFERROR(SUM(SLGRC[GRC Value (£)])/1000,\"Enter a GRC Value\")","v":0},{"$f":"IFERROR(SUM(TrafficM[GRC Value (£)])/1000,\"Enter a GRC Value\")","v":0},{"$f":"IFERROR(IF(SF_Sheet=\"Own Data\",SUM(SFOwnData[GRC Value (£)])/1000,IF(SF_Sheet=\"Derbyshire\",SUM(SFDerbyshire[GRC Value (£)])/1000,IF(SF_Sheet=\"Hertfordshire\",SUM(SFHerts[GRC Value (£)])/1000,IF(SF_Sheet=\"Medway\",SUM(SFMedway[GRC Value (£)])/1000,0)))),\"Enter a GRC Value\")","v":0},{"$f":"'Land GRC'!$D$29","v":0},{"$f":"SUM(D30:J30)","v":0}]
[null,null,"Pick a Data Category (Actual Inventory, Sample Inventory, Estimated Values, Combination)","Pick a Data Category","Pick a Data Category","Pick a Data Category","Pick a Data Category","Pick a Data Category","Pick a Data Category","Pick a Data Category"]
[]
[null,null,"Accumulated Depreciation","Carriageway\n£,000s","Footways + Cycleways\n£,000s","Structures\n£,000s","Street Lighting\n£,000s","Traffic Management\n£,000s","Street furniture\n£,000s","Land\n£,000s","Total \n£,000s"]
[null,null,"Accumulated Depreciation Opening Balance",null,null,null,null,null,null,null,{"$f":"SUM(D34:J34)","v":0}]
[null,null,"Depreciation Charge",null,{"$f":"'Footways DRC'!E57","v":0},null,{"$f":"'Street Lighting GRC & DRC'!D25","v":0},{"$f":"'Traffic Mangt Eqpt GRC & DRC'!D32","v":0},{"$f":"IFERROR(IF(SF_Sheet=\"Own Data\",'SF - Own Data'!E50,IF(SF_Sheet=\"Derbyshire\",'SF - Derbyshire'!E50,IF(SF_Sheet=\"Hertfordshire\",'SF - Hertfordshire'!E45,IF(SF_Sheet=\"Medway\",'SF - Medway'!E65,0)))),0)","v":0},null,0]
[null,null,"Depreciation written out to the Revaluation Reserve",{"$f":"D42-D34-D35-D37-D38-D39-D41-D40","v":0},{"$f":"E42-E34-E35-E37-E38-E39-E41-E40","v":0},0,0,0,0,null,0]
[null,null,"Depreciation written out to the Surplus/Deficit on the Provision of Services",null,null,null,null,null,null,null,0]
[null,null,"Impairment losses/(reversals) recognised in the Revaluation Reserve",null,null,null,null,null,null,null,0]
[null,null,"Impairment losses / (reversals) recognised in the Surplus/Deficit on the Provision of Services",null,null,null,null,null,null,null,0]
[null,null,"Disposals / Derecognition",null,null,null,null,null,null,null,0]
[null,null,"Other",null,null,null,null,null,null,null,0]
[null,null,"Accumulated  Depreciation Closing Balance",null,{"$f":"IFERROR('Footways DRC'!$E$56,\"Enter a DRC Value\")","v":0},null,{"$f":"IFERROR(SUM(SLGRC[Accumulated Depreciation (£)])/1000,\"Enter a DRC Value\")","v":0},{"$f":"IFERROR(SUM(TrafficM[Accumulated Depreciation (£)])/1000,\"Enter a GRC Value\")","v":0},{"$f":"IFERROR(IF(SF_Sheet=\"Own Data\",SUM(SFOwnData[Accumulated Depreciation (£)])/1000,IF(SF_Sheet=\"Derbyshire\",SUM(SFDerbyshire[Accumulated Depreciation (£)])/1000,IF(SF_Sheet=\"Hertfordshire\",SUM(SFHerts[Accumulated Depreciation (£)])/1000,IF(SF_Sheet=\"Medway\",SUM(SFMedway[Accumulated Depreciation (£)])/1000,0)))),\"Enter a GRC Value\")","v":0},null,0]
[]
[null,null,"Opening Net Book Value (DRC)",{"$f":"+D24-D34","v":0},0,0,0,0,0,null,0]
[null,null,"Closing Net Book Value (DRC)",{"$f":"+D30-D42","v":0},0,0,0,0,0,null,0]
[]
[null,null,"Section 2: Source of GRC Estimate"]
[]
[null,null,"Allocate the closing Gross Replacement Cost estimate (GRC) value to the appropriate calculation basis used"]
[]
[null,null,"Highway Asset Types: (Level 1 categories \n       defined in Table 4.1 \"Classification of \n       highway assets\", para 4.2.3, pgs 34 to 36,\n       of the transport Code) ","Actual inventory","Sample inventory","Estimated values","Combination","Closing GRC",null,null,"Estimated percentage of work completed"]
[null,null,null,null,null,null,null,null,null,null,"(%)"]
[null,null,"Carriageway",{"$f":"IF($D$31=\"Actual Inventory\",$D$30,0)","v":0},{"$f":"IF($D$31=\"Sample Inventory\",$D$30,0)","v":0},{"$f":"IF($D$31=\"Estimated Values\",$D$30,0)","v":0},{"$f":"IF($D$31=\"Combination\",$D$30,0)","v":0},{"$f":"SUM(D53:G53)","v":0},{"$f":"IF(H53=D30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Footways + Cycleways",{"$f":"IF($E$31=\"Actual Inventory\",$E$30,0)","v":0},{"$f":"IF($E$31=\"Sample Inventory\",$E$30,0)","v":0},{"$f":"IF($E$31=\"Estimated Values\",$E$30,0)","v":0},{"$f":"IF($E$31=\"Combination\",$E$30,0)","v":0},0,{"$f":"IF(H54=E30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Structures",{"$f":"IF($F$31=\"Actual Inventory\",$F$30,0)","v":0},{"$f":"IF($F$31=\"Sample Inventory\",$F$30,0)","v":0},{"$f":"IF($F$31=\"Estimated Values\",$F$30,0)","v":0},{"$f":"IF($F$31=\"Combination\",$F$30,0)","v":0},0,{"$f":"IF(H55=F30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Lighting",{"$f":"IF($G$31=\"Actual Inventory\",$G$30,0)","v":0},{"$f":"IF($G$31=\"Sample Inventory\",$G$30,0)","v":0},{"$f":"IF($G$31=\"Estimated Values\",$G$30,0)","v":0},{"$f":"IF($G$31=\"Combination\",$G$30,0)","v":0},0,{"$f":"IF(H56=G30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Traffic management",{"$f":"IF($H$31=\"Actual Inventory\",$H$30,0)","v":0},{"$f":"IF($H$31=\"Sample Inventory\",$H$30,0)","v":0},{"$f":"IF($H$31=\"Estimated Values\",$H$30,0)","v":0},{"$f":"IF($H$31=\"Combination\",$H$30,0)","v":0},0,{"$f":"IF(H57=H30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Street furniture",{"$f":"IF($I$31=\"Actual Inventory\",$I$30,0)","v":0},{"$f":"IF($I$31=\"Sample Inventory\",$I$30,0)","v":0},{"$f":"IF($I$31=\"Estimated Values\",$I$30,0)","v":0},{"$f":"IF($I$31=\"Combination\",$I$30,0)","v":0},0,{"$f":"IF(H58=I30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Land",{"$f":"IF($J$31=\"Actual Inventory\",$J$30,0)","v":0},{"$f":"IF($J$31=\"Sample Inventory\",$J$30,0)","v":0},{"$f":"IF($J$31=\"Estimated Values\",$J$30,0)","v":0},{"$f":"IF($J$31=\"Combination\",$J$30,0)","v":0},0,{"$f":"IF(H59=J30,\" \",\" GRC not allocated\")","v":" "}]
[null,null,"Total ",{"$f":"SUM(D53:D59)","v":0},{"$f":"SUM(E53:E59)","v":0},0,0,{"$f":"SUM(H53:H59)","v":0},{"$f":"IF(H60=K30,\" \",\" GRC not allocated\")","v":" "},null,{"$f":"SUM(K53:K59)","v":0}]
[]
[null,null,"Rounding Validation check:",{"$f":"IF((D60<10000000)*OR(E60<10000000),\"Ok\",\"You have reported more than £10bn of GRC data, please ensure this is correct, and that you have not failed to round to thousands.\")","v":"Ok"}]
[null,null,"Notes/Evidence"]
[]
[]
[null,null,"CIPFA Questionnaire"]
[]
[null,null,"Please respond to the questions in respect of the CIPFA Code of Practice on Transport Infrastructure Assets and supporting materials below, using a scale of 1 to 5 as follows:"]
[null,null,"1 = Strongly Disagree;   2 = Disagree;   3 = Neither agree nor disagree;   4 = Agree;   5 = Strongly Agree"]
[null,null,null,null,null,null,null,null,null,null,"Answer 1 to 5"]
[null,null,"1. The tools to support the implementation of the Code are helpful and appropriate."]
[]
[null,null,"2. All those who ‘need to know’ at this authority are aware of the Code and its requirements "]
[null,null,"and implications, including senior management, finance practitioners and asset "]
[null,null,"management/engineering practitioners."]
[]
[null,null,"3. The financial and technical practitioners are clear about their roles and work together to "]
[null,null,"produce the required information."]
[]
[null,null,"4. This authority is actively working with other authorities in a regional group (or similar) to "]
[null,null,"support and benchmark our work on asset valuation and implementing the Code."]
[]
[null,null,"5. This authority will be able to fully implement the Code to the published timescales including "]
[null,null,"full implementation in their Statement of Accounts from 2016-17"]
[]
[null,null,"6. This authority has sufficient, appropriate and robust inventory data to implement the Code "]
[null,null,"on the following assets:"]
[null,null,"•  Carriageways\n"]
[null,null,"•  Footways & Cycle tracks"]
[null,null,"•  Structures"]
[null,null,"•  Lighting"]
[null,null,"•  Traffic Management"]
[null,null,"•  Land"]
[]
[null,null,"7. For the areas in question 6 where appropriate inventory data is not yet available, this "]
[null,null,"authority is confident that plans are in place to gather this data and it will be available "]
[null,null,"to fully implement the Code to the published timescales. "]
[]
[null,null,"8. This authority has sufficient, appropriate and robust condition or age data (as appropriate)"]
[null,null,"to implement the Code on the following assets:"]
[null,null,"•  Carriageways\n\n"]
[null,null,"•  Footways & Cycle tracks"]
[null,null,"•  Structures"]
[null,null,"•  Lighting"]
[null,null,"•  Traffic Management"]
[]
[null,null,"9. For the areas in question 8 where appropriate condition or age data is not yet available, this "]
[null,null,"authority is confident that plans are in place to gather this data and it will be available to fully "]
[null,null,"implement the Code to the published timescales. "]
[]
[null,null,"10. This authority has a fully developed and implemented TAMP/ HAMP."]
[]
[null,null,"11. Are there any further issues arising from the Code or where more detailed guidance or exemplification would be helpful? \n(Please keep within the space provided)"]
[]
[null,null,"COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change Register",null,"Change"]
[null,"Version 2.5, Nov 2015",null,"* Help button in title bar ( ὶ ) button"]
[null,null,null,"* Cell information: (?) button"]
[null,null,null,"* Auto Calculate :  Depreciation written out to the Revaluation Reserve"]
[null,null,null,"*'Type Over' cells in GRC and DRC totals"]

{"sheet":"Carriageways & Footways GRC","index":2,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[49,1,49,2],[47,3,47,9],[2,2,2,17],[13,6,16,6],[13,14,16,14],[12,2,12,7],[12,12,12,17],[13,16,16,16],[13,17,16,17],[13,15,16,15],[13,13,16,13],[13,10,16,10],[35,15,36,17],[37,15,38,17],[47,1,47,2],[35,12,36,14],[13,4,16,4],[13,3,16,3],[43,15,44,17],[33,12,33,14],[39,15,40,17],[13,5,16,5],[32,2,32,10],[33,2,44,10],[13,7,16,7],[13,9,16,9],[13,2,16,2],[37,12,38,14],[39,12,40,14],[41,12,42,14],[43,12,44,14],[41,15,42,17],[12,9,12,10],[35,18,36,18],[37,18,38,18],[32,12,32,17],[33,15,33,17],[13,12,16,12]]}
[]
[]
[null,null,"Carriageways, Footways & Cycleways GRC"]
[null,null,"Step 1","Enter your CARRIAGEWAY LENGTH and  WIDTH or AREA"]
[null,null,"Step 2","Enter your FOOTWAY LENGTH and WIDTH, or AREA"]
[null,null,"Step 3","Select your REGION and AUTHORITY - this will apply a regional factor."]
[]
[]
[null,null,"Note 1","Drainage has been included within the default carriageway rates and so will not appear in Street Furniture."]
[null,null,"Note 2","For Cycleways (bound and unbound), each local authority should enter a GRC rate as appropriate. The rate may be taken from the list of footway rates provided or a locally provided value may be entered instead."]
[]
[]
[null,null,"CARRIAGEWAYS",null,null,null,null,null,null,"LINEAR ITEMS",null,null,"FOOTWAYS & CYCLEWAYS"]
[null,null,"Road Classification","Carriageway Length\n","Carriageway Width\n","Calculated Area ","HAMFIG Default GRC Rate","GRC Value",null,"HAMFIG Default GRC Rate","GRC Value ",null,"Footway Hierarchy","Footway Length","Footway Width","Calculated Area","HAMFIG Default GRC Rate","GRC Value"]
[]
[]
[]
[null,null,null,"(km)"," (m)","(m²)","(£/m²)","(£,000s)",null,"(£/m)","(£,000s)",null,null,"(Km)","(m)","(m2)","(£/m²)","(£,000s)"]
[null,null,"M (all)",null,null,{"$f":"D19*E19*1000","v":0},{"$f":"VLOOKUP(C19,'GRC Rates'!A:B,2,FALSE)","v":160.91},{"$f":"F19*G19/1000","v":0},null,{"$f":"VLOOKUP(C19,'GRC Rates'!A:C,3,FALSE)","v":715.13},{"$f":"D19*J19","v":0},null,"1A Urban",null,null,{"$f":"N19*O19*1000","v":0},{"$f":"VLOOKUP(M19,'GRC Rates'!D:E,2,FALSE)","v":251.69},{"$f":"P19*Q19/1000","v":0}]
[null,null,"A Urban",null,null,0,{"$f":"VLOOKUP(C20,'GRC Rates'!A:B,2,FALSE)","v":136.04},{"$f":"F20*G20/1000","v":0},null,{"$f":"VLOOKUP(C20,'GRC Rates'!A:C,3,FALSE)","v":604.6},{"$f":"D20*J20","v":0},null,"1  Urban",null,null,{"$f":"N20*O20*1000","v":0},{"$f":"VLOOKUP(M20,'GRC Rates'!D:E,2,FALSE)","v":82.35},{"$f":"P20*Q20/1000","v":0}]
[null,null,"A Rural",null,null,0,{"$f":"VLOOKUP(C21,'GRC Rates'!A:B,2,FALSE)","v":107.73},0,null,{"$f":"VLOOKUP(C21,'GRC Rates'!A:C,3,FALSE)","v":457.98},0,null,"1 Rural",null,null,{"$f":"N21*O21*1000","v":0},{"$f":"VLOOKUP(M21,'GRC Rates'!D:E,2,FALSE)","v":74.84},0]
[null,null,"B Urban",null,null,0,{"$f":"VLOOKUP(C22,'GRC Rates'!A:B,2,FALSE)","v":126.86},0,null,{"$f":"VLOOKUP(C22,'GRC Rates'!A:C,3,FALSE)","v":554.47},0,null,"2 Urban",null,null,0,{"$f":"VLOOKUP(M22,'GRC Rates'!D:E,2,FALSE)","v":75.650000000000006},0]
[null,null,"B Rural",null,null,0,{"$f":"VLOOKUP(C23,'GRC Rates'!A:B,2,FALSE)","v":100.16},0,null,{"$f":"VLOOKUP(C23,'GRC Rates'!A:C,3,FALSE)","v":255.15},0,null,"2 Rural",null,null,0,{"$f":"VLOOKUP(M23,'GRC Rates'!D:E,2,FALSE)","v":68.7},0]
[null,null,"C Urban",null,null,0,{"$f":"VLOOKUP(C24,'GRC Rates'!A:B,2,FALSE)","v":104.7},0,null,{"$f":"VLOOKUP(C24,'GRC Rates'!A:C,3,FALSE)","v":482.58},0,null,"3 Urban",null,null,0,{"$f":"VLOOKUP(M24,'GRC Rates'!D:E,2,FALSE)","v":67.44},0]
[null,null,"C Rural",null,null,0,{"$f":"VLOOKUP(C25,'GRC Rates'!A:B,2,FALSE)","v":79.92},0,null,{"$f":"VLOOKUP(C25,'GRC Rates'!A:C,3,FALSE)","v":217.98},0,null,"3 Rural",null,null,0,{"$f":"VLOOKUP(M25,'GRC Rates'!D:E,2,FALSE)","v":61.24},0]
[null,null,"U/C Urban",null,null,0,{"$f":"VLOOKUP(C26,'GRC Rates'!A:B,2,FALSE)","v":96.69},0,null,{"$f":"VLOOKUP(C26,'GRC Rates'!A:C,3,FALSE)","v":352.39},0,null,"4 Urban",null,null,0,{"$f":"VLOOKUP(M26,'GRC Rates'!D:E,2,FALSE)","v":64.75},0]
[null,null,"U/C Rural",null,null,0,{"$f":"VLOOKUP(C27,'GRC Rates'!A:B,2,FALSE)","v":74.87},0,null,{"$f":"VLOOKUP(C27,'GRC Rates'!A:C,3,FALSE)","v":166.08},0,null,"4 Rural",null,null,0,{"$f":"VLOOKUP(M27,'GRC Rates'!D:E,2,FALSE)","v":61.02},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cycleways Bound",null,null,0,null,{"$f":"P28*Q28/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cycleways Unbound",null,null,0,null,{"$f":"P29*Q29/1000","v":0}]
[null,null,"Total - Without Factor Applied",null,null,{"$f":"SUM(F19:F27)","v":0},null,{"$f":"SUM(H19:H27)","v":0},null,null,{"$f":"SUM(K19:K27)","v":0},null,"Total - Without Factor Applied",null,null,{"$f":"SUM(P19:P29)","v":0},null,{"$f":"SUM(R19:R29)","v":0}]
[null,null,"Total - With Factor Applied",null,null,null,null,{"$f":"SUM(H19:H27)*P40/100","v":0},null,null,{"$f":"SUM(K19:K27)*P40/100","v":0},null,"Total - With Factor Applied",null,null,null,null,{"$f":"SUM(R19:R29)*P40/100","v":0}]
[]
[null,null,"Notes/Evidence",null,null,null,null,null,null,null,null,null,"SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(M35,'GRC Rates'!$F:$G,2,FALSE)","v":"Inflation - Q1 2010 to Q2 2017"},null,null,{"$f":"VLOOKUP(M34,'GRC Rates'!F:G,2,FALSE)","v":1.1549295774647887}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Select a Region",null,null,"Select_a_Region"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Select an Authority",null,null,"Pick your Authority"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Regional Factor",null,null,{"$f":"VLOOKUP(P38,'Regional Factors'!B:C,2,FALSE)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"              Carriageway GRC (£,000s) (including linear items)",null,null,{"$f":"IFERROR(+ROUND(($H$30+$K$30)*$P$34*($P$40/100),0),\" na\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Footway GRC (£,000s)",null,null,{"$f":"IFERROR(+ROUND($R$30*$P$34*($P$40/100),0),\"na\")","v":0}]
[]
[]
[]
[null,"Change Register",null,"Change"]
[null,"Version 2.5, Nov 2015",null,"*Help button in title bar ( ὶ ) button"]
[null,null,null,"*Cell information (?) button"]
[null,null,null,"*Allow Manual input of Carriageways Area and Footways/Cycleways Area"]
[null,null,null,"*Cycleways Bound and Unbound added to 'Footways and Cycleways' table"]
[null,null,null,"*Totals are also calculated with Regional Factor applied"]
[null,null,null,"*External list reference to Valuation Variable workbook to allow for external updates on rates"]

{"sheet":"Footways DRC","index":3,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":false,"merged":[[47,2,50,2],[31,2,34,2],[27,2,30,2],[35,2,38,2],[23,2,26,2],[43,2,46,2],[1,14,9,18],[2,2,2,11],[11,3,11,11],[16,5,18,5],[16,11,18,11],[16,10,18,10],[16,9,18,9],[16,3,18,3],[16,2,18,2],[12,3,12,11],[68,1,68,2],[16,6,18,6],[59,2,59,11],[60,2,65,11],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[52,2,52,3],[16,7,18,7],[51,2,51,3],[16,4,18,4],[16,8,18,8],[53,2,53,3],[39,2,42,2],[19,2,22,2]]}
[]
[]
[null,null,"Footways and Cycleways (DRC)"]
[null,null,"Step 1","For Bituminous, Other Bituminous and other materials such as Mass Concrete (see Note 2 below) enter the CURRENT AREA per Asset Type"]
[null,null,"Step 2","Then enter the Local Average Treatment Cost per Asset Type"]
[null,null,"Step 3","Then enter an ESTIMATED LIFESPAN"]
[null,null,"Step 4","Then enter a SUM OF ALL TREATMENTS IN LIFECYCLE PLAN per Asset Type"]
[null,null,"Step 5","For Modular Slabs, Block Paving and Other Modular enter the CURRENT AREA per Asset Type"]
[null,null,"Step 6","Then enter the PREVIOUS AREA per Asset Type"]
[null,null,"Step 7","Then enter the Local Average Treatment Cost per Asset Type"]
[]
[null,null,"Note 1","For Modular footways, if the Change in Area is greater than zero then the Annual Depreciation is the Change in Area multiplied by the Local Average Treatment Cost. If the Change in Area is less than or equal to zero then the Annual Depreciation is Zero."]
[null,null,"Note 2","For Mass Concrete: The lifecycle planning approach to determining deterioration should be used. Treatments can be applied to mass concrete (e.g. surface dressed or planed out and inlayed) therefore the ability to develop a lifecycle plan based on treatments is the preferred option"]
[null,null,"Note 3","Add Cycleways Bound and Unbound in Other Bituminous or Other Modular as appropriate to calculate a DRC Value"]
[null,null,"Note 4","Capture the evidence used to determine locally derived inputs, e.g. local rates, sources of inventory data, sources of condition data etc as well as any assumptions made or issues to resolve etc.  "]
[]
[null,null,"Type","Band","Current Area (m²)","Previous Area (m²)","Change in Area (m²)","Local Average Treatment Cost (£/m²)","Accumulated Depreciation (£)","Estimated Lifespan of all Treatments in Lifecycle Plan (years)","Sum of all Treatments in Lifecycle Plan (£/m²)","Annual Depreciation (£)"]
[]
[]
[null,null,"Bituminous","Red",null,null,null,null,{"$f":"H20*E20","v":0},null,null,{"$f":"IF(J20=0,0,(E20*K20)/J20)","v":0}]
[null,null,"Bituminous","Amber",null,null,null,null,{"$f":"H21*E21","v":0},null,null,{"$f":"IF(J21=0,0,(E21*K21)/J21)","v":0}]
[null,null,"Bituminous","Yellow",null,null,null,null,0,null,null,0]
[null,null,"Bituminous","Green",null,null,null,{"$f":"IF(H22>0,H22*0.5,\"£0.00\")","v":"£0.00"},0,null,null,0]
[null,null,"Other Bituminous 1","Red",null,null,null,null,{"$f":"H24*E24","v":0},null,null,{"$f":"IF(J24=0,0,(E24*K24)/J24)","v":0}]
[null,null,"Bituminous","Amber",null,null,null,null,{"$f":"H25*E25","v":0},null,null,{"$f":"IF(J25=0,0,(E25*K25)/J25)","v":0}]
[null,null,"Bituminous","Yellow",null,null,null,null,0,null,null,{"$f":"IF(J26=0,0,(E26*K26)/J26)","v":0}]
[null,null,"Bituminous","Green",null,null,null,{"$f":"IF(H26>0,H26*0.5,\"£0.00\")","v":"£0.00"},0,null,null,0]
[null,null,"Other Bituminous 2","Red",null,null,null,null,{"$f":"H28*E28","v":0},null,null,{"$f":"IF(J28=0,0,(E28*K28)/J28)","v":0}]
[null,null,"Bituminous","Amber",null,null,null,null,{"$f":"H29*E29","v":0},null,null,{"$f":"IF(J29=0,0,(E29*K29)/J29)","v":0}]
[null,null,"Bituminous","Yellow",null,null,null,null,0,null,null,{"$f":"IF(J30=0,0,(E30*K30)/J30)","v":0}]
[null,null,"Bituminous","Green",null,null,null,{"$f":"IF(H30>0,H30*0.5,\"£0.00\")","v":"£0.00"},0,null,null,0]
[null,null,"Modular Slabs","Red",null,null,{"$f":"E32-F32","v":0},null,{"$f":"H32*E32","v":0},null,null,{"$f":"IF(G32>0,(G32*H32),0)","v":0}]
[null,null,null,"Amber",null,null,{"$f":"E33-F33","v":0},null,0,null,null,{"$f":"IF(G33>0,(G33*H33),0)","v":0}]
[null,null,null,"Yellow",null,null,0,null,0,null,null,{"$f":"IF(G34>0,(G34*H34),0)","v":0}]
[null,null,null,"Green",null,null,0,"£0.00",0,null,null,0]
[null,null,"Modular Block Paving","Red",null,null,0,null,0,null,null,0]
[null,null,null,"Amber",null,null,0,null,0,null,null,0]
[null,null,null,"Yellow",null,null,0,null,0,null,null,0]
[null,null,null,"Green",null,null,0,"£0.00",0,null,null,0]
[null,null,"Other Modular 1","Red",null,null,0,null,0,null,null,0]
[null,null,null,"Amber",null,null,0,null,0,null,null,0]
[null,null,null,"Yellow",null,null,0,null,0,null,null,{"$f":"IF(G42>0,(G42*H42),0)","v":0}]
[null,null,null,"Green",null,null,0,"£0.00",0,null,null,0]
[null,null,"Other Modular 2","Red",null,null,{"$f":"E44-F44","v":0},null,{"$f":"H44*E44","v":0},null,null,{"$f":"IF(G44>0,(G44*H44),0)","v":0}]
[null,null,null,"Amber",null,null,0,null,0,null,null,0]
[null,null,null,"Yellow",null,null,0,null,0,null,null,0]
[null,null,null,"Green",null,null,0,"£0.00",0,null,null,{"$f":"IF(G47>0,(G47*H47),0)","v":0}]
[null,null,"Other (Mass Concrete)","Red",null,null,0,null,0,null,null,{"$f":"IF(J48=0,0,(E48*K48)/J48)","v":0}]
[null,null,null,"Amber",null,null,0,null,0,null,null,{"$f":"IF(J49=0,0,(E49*K49)/J49)","v":0}]
[null,null,null,"Yellow",null,null,0,null,0,null,null,0]
[null,null,null,"Green",null,null,0,null,0,null,null,0]
[null,null,"SUB TOTAL: BITUMINOUS",null,null,null,null,null,{"$f":"SUM(I20:I31)","v":0},null,null,{"$f":"SUM(L20:L31)","v":0}]
[null,null,"SUB TOTAL: MODULAR",null,null,null,null,null,{"$f":"SUM(I32:I47)","v":0},null,null,{"$f":"SUM(L32:L47)","v":0}]
[null,null,"SUB TOTAL: MASS CONCRETE",null,null,null,null,null,{"$f":"SUM(I48:I51)","v":0},null,null,{"$f":"SUM(L48:L51)","v":0}]
[null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",null,{"$f":"'Carriageways & Footways GRC'!$P$44","v":0}]
[null,null,"ACCUMULATED DEPRECIATION (£,000s)",null,{"$f":"SUM(I20:I51)/1000","v":0}]
[null,null,"ANNUAL DEPRECIATION (£,000s)",null,{"$f":"SUM(L20:L51)/1000","v":0}]
[null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",null,{"$f":"E55-E56","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change Register",null,"Change"]
[null,"Version 2.5, Nov 2015",null,"* Help button in title bar ( ὶ ) button"]
[null,null,null,"*Cell information (?) button"]
[null,null,null,"* Sub totals added for each 'Type' of Footway"]

{"sheet":"Street Lighting GRC & DRC","index":4,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,2,2,12],[27,2,27,12],[36,2,36,12],[10,3,10,4],[28,2,35,12]]}
[]
[]
[null,null,"Street Lighting"]
[null,null,"Step 1","Insert the number of additional rows required for each section"]
[null,null,"Step 2","Complete the Yellow cells with your inventory data"]
[]
[null,null,"Note 1","The INSERT button will allow you to bulk insert any number of rows per type of Street Lighting"]
[null,null,"Note 2","The DELETE button will allow you to delete selected rows only, providing there is one unique asset type remaining"]
[null,null,"Note 3","The RESET button will set the table back to one unique asset of each type and clear all entered data"]
[]
[null,null,null,"Type in the Number of rows required"]
[null,null,null,"Number of additional Street Lighting Rows"]
[null,null,null,"Number of additional Illuminated Signs Rows"]
[null,null,null,"Number of additional Other Rows"]
[]
[null,null,"Calculation Of GRC and DRC","Column1","No of Units","Replacement Rate/Unit (£)","Estimated Age (Years)","Estimated Lifespan (Years)","Age/ Lifespan","GRC Value (£)","Annual Depreciation (£)","Accumulated Depreciation (£)","DRC Value (£)"]
[null,null,"Street Lighting","Please select from list or type a description",null,null,null,null,{"$f":"IFERROR(G17/H17,0)","v":0},{"$f":"F17*E17","v":0},{"$f":"IFERROR(J17/H17,0)","v":0},{"$f":"IFERROR(MIN(G17,H17)*K17,0)","v":0},{"$f":"J17-L17","v":0}]
[null,null,"Illuminated Signs","Please select from list or type a description",null,null,null,null,{"$f":"IFERROR(G18/H18,0)","v":0},0,{"$f":"IFERROR(J18/H18,0)","v":0},{"$f":"IFERROR(MIN(G18,H18)*K18,0)","v":0},{"$f":"J18-L18","v":0}]
[null,null,"Other","Add Additional Assets Here",null,null,null,null,{"$f":"IFERROR(G19/H19,0)","v":0},{"$f":"F19*E19","v":0},{"$f":"IFERROR(J19/H19,0)","v":0},{"$f":"IFERROR(MIN(G19,H19)*K19,0)","v":0},{"$f":"J19-L19","v":0}]
[null,null,"SUB TOTAL: STREET LIGHTING",{"$f":"SUMIF(SLGRC[Calculation Of GRC and DRC],MID(SLGRC[[#This Row],[Calculation Of GRC and DRC]],12,20),SLGRC[GRC Value (£)])","v":0}]
[null,null,"SUB TOTAL: ILLUMINATED SIGNS",{"$f":"SUMIF(SLGRC[Calculation Of GRC and DRC],MID(SLGRC[[#This Row],[Calculation Of GRC and DRC]],12,20),SLGRC[GRC Value (£)])","v":0}]
[null,null,"SUB TOTAL: OTHER",{"$f":"SUMIF(SLGRC[Calculation Of GRC and DRC],MID(SLGRC[[#This Row],[Calculation Of GRC and DRC]],12,20),SLGRC[GRC Value (£)])","v":0}]
[null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",{"$f":"SUM(SLGRC[GRC Value (£)])/1000","v":0}]
[null,null,"ACCUMULATED DEPRECIATION (£,000s)",{"$f":"SUM(SLGRC[Accumulated Depreciation (£)])/1000","v":0}]
[null,null,"ANNUAL DEPRECIATION (£,000s)",{"$f":"SUM(SLGRC[Annual Depreciation (£)])/1000","v":0}]
[null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",{"$f":"SUM(SLGRC[DRC Value (£)])/1000","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Change Register","Change"]
[null,null,"Version 2.5, Nov 2015","* Help button in title bar ( ὶ ) button"]
[null,null,null,"* Add additional rows"]
[null,null,null,"* Delete Rows"]
[null,null,null,"*Reset table function"]
[null,null,null,"* Sub totals "]
[null,null,null,"* Table layout to allow authorities to copy and paste data from another worksheet"]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Traffic Mangt Eqpt GRC & DRC","index":5,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,2,2,12],[34,2,34,12],[1,15,8,19],[40,2,40,12],[10,3,10,4],[35,2,39,12]]}
[]
[]
[null,null,"Traffic Management Equipment"]
[null,null,"Step 1","Insert the number of rows required for each section"]
[null,null,"Step 2","Complete the Yellow cells with your inventory data"]
[]
[null,null,"Note 1","The INSERT button will allow you to bulk insert any number of rows per type of Traffic Mangement Equipment"]
[null,null,"Note 2","The DELETE button will allow you to delete selected rows only, providing there is one unique asset type remaining"]
[null,null,"Note 3","The RESET button will set the table back to one unique asset of each type and clear all entered data"]
[]
[null,null,null,"Type in the Number of rows required"]
[null,null,null,"Number of additional Traffic Signals Rows"]
[null,null,null,"Number of additional Crossings, Cameras, Junctions and EMS/VMS Rows"]
[null,null,null,"Number of additional Information Systems Rows"]
[null,null,null,"Number of additional InStations Rows"]
[null,null,null,"Number of additional Other Rows"]
[]
[]
[null,null,"Calculation of GRC and DRC","Column1","No of Units","Replacement Rate/Unit (£)","Estimated Age (Years)","Estimated Lifespan (Years)","Age/ Lifespan","GRC Value (£)","Annual Depreciation (£)","Accumulated Depreciation (£)","DRC Value (£)"]
[null,null,"Traffic Signals","Please select from list or type a description",null,null,null,null,{"$f":"IFERROR(G20/H20,0)","v":0},{"$f":"F20*E20","v":0},{"$f":"IFERROR(J20/H20,0)","v":0},{"$f":"IFERROR(MIN(G20,H20)*K20,0)","v":0},{"$f":"J20-L20","v":0}]
[null,null,"Crossings, Cameras, Junctions and EMS/VMS","Please select from list or type a description",null,null,null,null,{"$f":"IFERROR(G21/H21,0)","v":0},{"$f":"F21*E21","v":0},{"$f":"IFERROR(J21/H21,0)","v":0},{"$f":"IFERROR(MIN(G21,H21)*K21,0)","v":0},{"$f":"J21-L21","v":0}]
[null,null,"Information Systems","Please select from list or type a description",null,null,null,null,{"$f":"IFERROR(G22/H22,0)","v":0},{"$f":"F22*E22","v":0},{"$f":"IFERROR(J22/H22,0)","v":0},{"$f":"IFERROR(MIN(G22,H22)*K22,0)","v":0},{"$f":"J22-L22","v":0}]
[null,null,"InStations","Please select from list or type a description",null,null,null,null,{"$f":"IFERROR(G23/H23,0)","v":0},{"$f":"F23*E23","v":0},{"$f":"IFERROR(J23/H23,0)","v":0},{"$f":"IFERROR(MIN(G23,H23)*K23,0)","v":0},{"$f":"J23-L23","v":0}]
[null,null,"Other","Add Additional Assets Here",null,null,null,null,{"$f":"IFERROR(G24/H24,0)","v":0},{"$f":"F24*E24","v":0},{"$f":"IFERROR(J24/H24,0)","v":0},{"$f":"IFERROR(MIN(G24,H24)*K24,0)","v":0},{"$f":"J24-L24","v":0}]
[null,null,"SUB TOTAL: TRAFFIC SIGNALS",{"$f":"SUMIF(TrafficM[Calculation of GRC and DRC],MID(TrafficM[[#This Row],[Calculation of GRC and DRC]],12,50),TrafficM[GRC Value (£)])","v":0}]
[null,null,"SUB TOTAL: CROSSINGS, CAMERAS, JUNCTIONS AND EMS/VMS",{"$f":"SUMIF(TrafficM[Calculation of GRC and DRC],MID(TrafficM[[#This Row],[Calculation of GRC and DRC]],12,50),TrafficM[GRC Value (£)])","v":0}]
[null,null,"SUB TOTAL: INFORMATION SYSTEMS",{"$f":"SUMIF(TrafficM[Calculation of GRC and DRC],MID(TrafficM[[#This Row],[Calculation of GRC and DRC]],12,50),TrafficM[GRC Value (£)])","v":0}]
[null,null,"SUB TOTAL: INSTATIONS",{"$f":"SUMIF(TrafficM[Calculation of GRC and DRC],MID(TrafficM[[#This Row],[Calculation of GRC and DRC]],12,50),TrafficM[GRC Value (£)])","v":0}]
[null,null,"SYB TOTAL: OTHER",{"$f":"SUMIF(TrafficM[Calculation of GRC and DRC],MID(TrafficM[[#This Row],[Calculation of GRC and DRC]],12,50),TrafficM[GRC Value (£)])","v":0}]
[null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",{"$f":"SUM(TrafficM[GRC Value (£)])/1000","v":0}]
[null,null,"ACCUMULATED DEPRECIATION (£,000s)",{"$f":"SUM(TrafficM[Accumulated Depreciation (£)])/1000","v":0}]
[null,null,"ANNUAL DEPRECIATION (£,000s)",{"$f":"SUM(TrafficM[Annual Depreciation (£)])/1000","v":0}]
[null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",{"$f":"SUM(TrafficM[DRC Value (£)])/1000","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[null,null,"Change Register","Change"]
[null,null,"Version 2.5, Nov 2015","* Help button in title bar ( ὶ ) button"]
[null,null,null,"* Add additional rows"]
[null,null,null,"* Delete Rows"]
[null,null,null,"* Reset table function"]
[null,null,null,"* Sub totals "]
[null,null,null,"* Table layout to allow authorities to copy and paste data from another worksheet"]

{"sheet":"Street Furniture GRC & DRC","index":6,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,2,2,16],[17,5,18,15],[14,5,14,15],[3,2,4,16],[7,5,8,15],[12,3,12,15],[10,3,11,15],[5,11,5,13]]}
[]
[]
[null,null,"Street Furniture"]
[null,null,"This sheet will allow you to make the most appropriate selection to input Street Furniture data depending on the status of your current inventory.  Please either add your own inventory data or use the sample data, that best matches your own circumstances, provided by one of the authorities below."]
[]
[null,null,"PLEASE ONLY COMPLETE ONE SHEET FOR STREET FURNITURE",null,null,null,null,null,null,null,"Data Selected:","Own Data"]
[]
[null,null,null,null,null,"Own Inventory Data - to be used for authorities with good data."]
[]
[]
[null,null,null,"Alternatively you can use data collected by other authorities as default data for estimating the value of your Street Furniture assets, particularly where you may not have sufficient data at present. "]
[]
[null,null,null,"Should you be in a position to submit inventory data of your own then this will help us to provide better default rates for use by others. To do this please enter you data into the 'SF - Own Data' Sheet and return this to HAMFIG@atkinsglobal.com"]
[]
[null,null,null,null,null,"Derbyshire - use this if you are a predominantly rural Shire County with few dual carriageways."]
[]
[]
[null,null,null,null,null,"Hertfordshire - use this if you are a mixed Shire County with many designed A roads / dual carriageways."]
[]
[]
[null,null,null,null,null,"Medway - use this if you are predominantly an urban authority."]

{"sheet":"SF - Own Data","index":7,"n_rows":69,"n_cols":29,"rows_kept":69,"cut":false,"hidden":false,"merged":[[53,2,62,28],[9,20,9,21],[8,20,8,21],[7,20,7,21],[6,20,6,21],[13,4,13,5],[13,6,13,7],[13,8,13,9],[12,20,12,28],[13,18,13,19],[12,2,13,2],[6,3,6,11],[7,3,7,11],[9,3,9,11],[2,20,2,23],[52,2,52,28],[5,20,5,21],[4,20,4,21],[3,20,3,21],[64,3,64,4],[68,3,68,7],[13,16,13,17],[2,13,2,18],[12,4,12,11],[12,12,12,19],[12,3,13,3],[2,2,2,11],[4,13,4,16],[13,10,13,11],[13,12,13,13],[13,14,13,15],[8,3,8,10],[3,3,3,11],[4,3,4,11],[5,3,5,11]]}
[]
[]
[null,null,"Street Furniture - Own Data",null,null,null,null,null,null,null,null,null,null,"Adding Additional Rows",null,null,null,null,null,null,"Network Length (km)"]
[null,null,"Step 1","Enter the Number of Additional Assets Rows required in 'Adding Additional Rows' box and press INSERT ROWS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Type/Classification",null," Urban","Rural"]
[null,null,"Step 2","Enter the Urban/Rural NETWORK LENGTHS per Road Type/Classification if this is not already populated",null,null,null,null,null,null,null,null,null,"Number of Additional Assets rows",null,null,null,null,null,null,"A",null,{"$f":"IF('Carriageways & Footways GRC'!D20>0,'Carriageways & Footways GRC'!D20,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D21>0,'Carriageways & Footways GRC'!D21,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 3","Enter the NUMBER OF ASSETS PER ROAD CLASSIFICATION per Asset Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,{"$f":"IF('Carriageways & Footways GRC'!D22>0,'Carriageways & Footways GRC'!D22,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D23>0,'Carriageways & Footways GRC'!D23,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 4","Enter Local Average Treatment Cost/Unit, Estimated Age of Assets, and Estimated Lifespan for each asset type.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",null,{"$f":"IF('Carriageways & Footways GRC'!D24>0,'Carriageways & Footways GRC'!D24,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D25>0,'Carriageways & Footways GRC'!D25,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 5","Add any comments to the comments box provided at the bottom of the sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,{"$f":"IF('Carriageways & Footways GRC'!D26>0,'Carriageways & Footways GRC'!D26,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D27>0,'Carriageways & Footways GRC'!D27,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Note 1","If you have Street Furniture assets on Motorways then please incorporate under A Roads.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length",null,{"$f":"SUM(W5:W8)","v":0},{"$f":"SUM(X5:X8)","v":0}]
[null,null,"Note 2","The DELETE button will allow you to delete selected rows only, providing there is one unique asset type remaining",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand total",null,{"$f":"SUM(W9:X9)","v":0}]
[]
[]
[null,null,"Asset Type","Sub Group","Number of Assets  per Road Classification",null,null,null,null,null,null,null,"Number of Assets per km of Road Classification",null,null,null,null,null,null,null,"GRC and DRC Calculation"]
[null,null,null,null,"A",null,"B",null,"C",null,"UC",null,"A",null,"B",null,"C",null,"UC"]
[null,null,"Asset Type","Sub Group","Urban ","Rural ","Urban","Rural","Urban2","Rural2","Urban3","Rural3","Urban Per Km","Rural Per Km","Urban Per Km2","Rural Per Km2","Urban Per Km3","Rural Per Km3","Urban Per Km4","Rural Per Km4","Total Assets","Local Average Treatment Cost/Unit (£)","Estimated Age (Years)","Estimated Lifespan (Years)","Age/ Lifespan","GRC Value (£)","Annual Depreciation (£)","Accumulated Depreciation (£)","DRC Value (£)"]
[null,null,"Traffic Signs Non-Illuminated ","Warning",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E16/$W$5,0)","v":0},{"$f":"IFERROR(F16/$X$5,0)","v":0},{"$f":"IFERROR(G16/$W$6,0)","v":0},{"$f":"IFERROR(H16/$X$6,0)","v":0},{"$f":"IFERROR(I16/$W$7,0)","v":0},{"$f":"IFERROR(J16/$X$7,0)","v":0},{"$f":"IFERROR(K16/$W$8,0)","v":0},{"$f":"IFERROR(L16/$X$8,0)","v":0},{"$f":"SUM(E16:L16)","v":0},null,null,null,{"$f":"IF(W16=0,0,(W16/X16))","v":0},{"$f":"U16*V16","v":0},{"$f":"IFERROR(Z16/X16,0)","v":0},{"$f":"IFERROR(MIN(W16,X16)*AA16,0)","v":0},{"$f":"Z16-AB16","v":0}]
[null,null,null,"Regulatory",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E17/$W$5,0)","v":0},{"$f":"IFERROR(F17/$X$5,0)","v":0},{"$f":"IFERROR(G17/$W$6,0)","v":0},{"$f":"IFERROR(H17/$X$6,0)","v":0},{"$f":"IFERROR(I17/$W$7,0)","v":0},{"$f":"IFERROR(J17/$X$7,0)","v":0},{"$f":"IFERROR(K17/$W$8,0)","v":0},{"$f":"IFERROR(L17/$X$8,0)","v":0},0,null,null,null,{"$f":"IF(W17=0,0,(W17/X17))","v":0},{"$f":"U17*V17","v":0},{"$f":"IFERROR(Z17/X17,0)","v":0},{"$f":"IFERROR(MIN(W17,X17)*AA17,0)","v":0},{"$f":"Z17-AB17","v":0}]
[null,null,null,"Directional",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(W18=0,0,(W18/X18))","v":0},0,0,0,0]
[null,null,null,"Informatory",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,{"$f":"IFERROR(MIN(W19,X19)*AA19,0)","v":0},0]
[null,null,null,"Boundary ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Non DCC",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Parking Directional",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Not Assessed",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"PROW Signs ","Metal ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Pedestrian Barriers (Lin m)","Standard PGR1 ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Visirail PGR3",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Safety Fencing (Lin m)","Box Single",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Box Double",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Ten",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Un-Ten",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Double - Ten",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"SUM(E32:L32)","v":0},null,null,null,{"$f":"IF(W32=0,0,(W32/X32))","v":0},{"$f":"U32*V32","v":0},{"$f":"IFERROR(Z32/X32,0)","v":0},{"$f":"IFERROR(MIN(W32,X32)*AA32,0)","v":0},{"$f":"Z32-AB32","v":0}]
[null,null,null,"Corr - Un-Ten",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Wire Rope",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Stops",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Shelters ","Concrete",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Enclosed ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Cantilever",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Metal ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Grit Bins",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,{"$f":"SUM(E42:L42)","v":0},null,null,null,{"$f":"IF(W42=0,0,(W42/X42))","v":0},{"$f":"U42*V42","v":0},{"$f":"IFERROR(Z42/X42,0)","v":0},{"$f":"IFERROR(MIN(W42,X42)*AA42,0)","v":0},{"$f":"Z42-AB42","v":0}]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E43/$W$5,0)","v":0},{"$f":"IFERROR(F43/$X$5,0)","v":0},{"$f":"IFERROR(G43/$W$6,0)","v":0},{"$f":"IFERROR(H43/$X$6,0)","v":0},{"$f":"IFERROR(I43/$W$7,0)","v":0},{"$f":"IFERROR(J43/$X$7,0)","v":0},{"$f":"IFERROR(K43/$W$8,0)","v":0},{"$f":"IFERROR(L43/$X$8,0)","v":0},{"$f":"SUM(E43:L43)","v":0},null,null,null,{"$f":"IF(W43=0,0,(W43/X43))","v":0},{"$f":"U43*V43","v":0},{"$f":"IFERROR(Z43/X43,0)","v":0},{"$f":"IFERROR(MIN(W43,X43)*AA43,0)","v":0},{"$f":"Z43-AB43","v":0}]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",{"$f":"SUM(SFOwnData[GRC Value (£)])/1000","v":0}]
[null,null,null,"ACCUMULATED DEPRECIATION (£,000s)",{"$f":"SUM(SFOwnData[Accumulated Depreciation (£)])/1000","v":0}]
[null,null,null,"ANNUAL DEPRECIATION (£,000s)",{"$f":"SUM(SFOwnData[Annual Depreciation (£)])/1000","v":0}]
[null,null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",{"$f":"SUM(SFOwnData[DRC Value (£)])/1000","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Change Register","Change"]
[null,null,"Version 2.5, Nov 2015","* Cell information (?) button"]
[null,null,null,"* Auto populate/manual input in the Network Length Table"]
[null,null,null,"* Add/Delete additional Rows for Additional Assets Only."]
[null,null,null,"* Table layout to allow authorities to copy and paste data from another worksheet"]

{"sheet":"SF - Derbyshire","index":8,"n_rows":68,"n_cols":29,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,3,5,11],[2,2,2,11],[2,13,2,18],[4,13,4,16],[3,20,3,21],[2,20,2,23],[4,20,4,21],[3,3,3,11],[9,20,9,21],[8,20,8,21],[7,20,7,21],[6,20,6,21],[5,20,5,21],[64,3,64,4],[67,3,67,9],[52,2,52,28],[53,2,62,28],[11,20,12,28],[11,4,12,11],[11,12,12,19],[13,20,13,28],[13,12,13,13],[13,14,13,15],[13,16,13,17],[13,18,13,19],[6,3,6,11],[8,3,8,10],[9,3,9,11],[13,10,13,11],[13,8,13,9],[13,4,13,5],[13,6,13,7]]}
[]
[]
[null,null,"Street Furniture - Derbyshire",null,null,null,null,null,null,null,null,null,null,"Adding Additional Rows",null,null,null,null,null,null,"Network length (km)"]
[null,null,"Step 1","Enter the Number of Additional Assets Rows required in 'Adding Additional Rows' box and press INSERT ROWS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Type/Classification",null," Urban","Rural"]
[null,null,"Step 2","Enter the NUMBER OF ASSETS PER ROAD CLASSIFICATION  per Asset Type",null,null,null,null,null,null,null,null,null,"Number of Additional Assets rows",null,null,null,null,null,null,"A",null,{"$f":"IF('Carriageways & Footways GRC'!D20>0,'Carriageways & Footways GRC'!D20,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D21>0,'Carriageways & Footways GRC'!D21,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 3","Enter Local Average Treatment Cost/Unit, Estimated Age of Assets, and Estimated Lifespan for each asset type.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,{"$f":"IF('Carriageways & Footways GRC'!D22>0,'Carriageways & Footways GRC'!D22,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D23>0,'Carriageways & Footways GRC'!D23,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 4","Add any comments to the comments box provided at the bottom of the sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",null,{"$f":"IF('Carriageways & Footways GRC'!D24>0,'Carriageways & Footways GRC'!D24,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D25>0,'Carriageways & Footways GRC'!D25,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,{"$f":"IF('Carriageways & Footways GRC'!D26>0,'Carriageways & Footways GRC'!D26,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D27>0,'Carriageways & Footways GRC'!D27,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Note 1","If you have Street Furniture assets on Motorways then please incorporate under A Roads.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length",null,{"$f":"SUM(W5:W8)","v":0},{"$f":"SUM(X5:X8)","v":0}]
[null,null,"Note 2","To Delete Rows from Additional Assets please select the rows and press DELETE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand total",null,{"$f":"SUM(W9:X9)","v":0}]
[]
[null,null,null,null,"Number of Assets  per road classification",null,null,null,null,null,null,null,"Number of Assets per km of road classification",null,null,null,null,null,null,null,"GRC and DRC Calculation"]
[]
[null,null,null,null,"A",null,"B",null,"C",null,"UC",null,"A",null,"B",null,"C",null,"UC"]
[null,null,"Asset Type","Sub Group","Urban ","Rural ","Urban","Rural","Urban2","Rural2","Urban3","Rural3","Urban Per Km","Rural Per Km","Urban Per Km2","Rural Per Km2","Urban Per Km3","Rural Per Km3","Urban Per Km4","Rural Per Km4","Total Assets","Local Average Treatment Cost/Unit (£)","Estimated Age (Years)","Estimated Lifespan (Years)","Age/ Lifespan","GRC Value (£)","Annual Depreciation (£)","Accumulated Depreciation (£)","DRC Value (£)"]
[null,null,"Traffic Signs Non-Illuminated ","Warning",{"$f":"IFERROR($W$5*M16,0)","v":0},{"$f":"IFERROR($X$5*N16,0)","v":0},{"$f":"IFERROR($W$6*O16,0)","v":0},{"$f":"IFERROR($X$6*P16,0)","v":0},{"$f":"IFERROR($W$7*Q16,0)","v":0},{"$f":"IFERROR($X$7*R16,0)","v":0},{"$f":"IFERROR($W$8*S16,0)","v":0},{"$f":"IFERROR($X$8*T16,0)","v":0},8.4960629921259798,6.1023809523809502,7.8301886792452828,6.1450381679389317,6.776566757493188,2.9049145299145298,2.7088014981273409,1.7622478386167146,{"$f":"SUM(E16:L16)","v":0},null,null,null,{"$f":"IF(W16=0,0,(W16/X16))","v":0},{"$f":"V16*U16","v":0},{"$f":"IFERROR(Z16/X16,0)","v":0},{"$f":"IFERROR(MIN(W16,X16)*AA16,0)","v":0},{"$f":"Z16-AB16","v":0}]
[null,null,null,"Regulatory",{"$f":"IFERROR($W$5*M17,0)","v":0},{"$f":"IFERROR($X$5*N17,0)","v":0},{"$f":"IFERROR($W$6*O17,0)","v":0},{"$f":"IFERROR($X$6*P17,0)","v":0},{"$f":"IFERROR($W$7*Q17,0)","v":0},{"$f":"IFERROR($X$7*R17,0)","v":0},{"$f":"IFERROR($W$8*S17,0)","v":0},{"$f":"IFERROR($X$8*T17,0)","v":0},10.23228346456693,4.2547619047619047,9.1320754716981138,5.1488549618320612,7.1280653950953674,2.7382478632478633,4.3904494382022472,2.3443804034582132,{"$f":"SUM(E17:L17)","v":0},null,null,null,{"$f":"IF(W17=0,0,(W17/X17))","v":0},{"$f":"V17*U17","v":0},{"$f":"IFERROR(Z17/X17,0)","v":0},{"$f":"IFERROR(MIN(W17,X17)*AA17,0)","v":0},0]
[null,null,null,"Directional",0,0,0,0,0,0,0,0,6.122047244094488,2.7571428571428571,3.8160377358490565,2.6564885496183206,2.2452316076294276,1.3685897435897436,0.9185393258426966,1.0201729106628241,0,null,null,null,0,{"$f":"V18*U18","v":0},{"$f":"IFERROR(Z18/X18,0)","v":0},{"$f":"IFERROR(MIN(W18,X18)*AA18,0)","v":0},{"$f":"Z18-AB18","v":0}]
[null,null,null,"Informatory",0,0,0,0,0,0,0,0,4.6102362204724407,1.4738095238095239,2.0990566037735849,0.50763358778625955,1.1743869209809263,0.2638888888888889,1.8174157303370786,0.51873198847262247,0,null,null,null,0,0,0,0,0]
[null,null,null,"Boundary ",0,0,0,0,0,0,0,0,1.0669291338582678,0.52380952380952384,0.88207547169811318,0.66030534351145043,0.8365122615803815,0.35149572649572647,0.22659176029962547,0.26945244956772335,0,null,null,null,0,0,0,0,0]
[null,null,null,"Non DCC",0,0,0,0,0,0,0,0,1.0826771653543308,0.18809523809523809,0.56603773584905659,8.3969465648854963E-2,0.33514986376021799,2.1367521367521368E-2,0.16900749063670412,5.7636887608069162E-2,0,null,null,null,0,0,0,0,0]
[null,null,null,"Parking Directional",0,0,0,0,0,0,0,0,0.35826771653543305,7.1428571428571425E-2,0.23584905660377359,2.6717557251908396E-2,0.17166212534059946,1.9230769230769232E-2,8.5674157303370788E-2,2.0172910662824207E-2,0,null,null,null,0,0,0,0,0]
[null,null,null,"Not Assessed",0,0,0,0,0,0,0,0,0.24409448818897639,9.5238095238095233E-2,0.25471698113207547,8.3969465648854963E-2,0.17166212534059946,7.0512820512820512E-2,0.15636704119850187,9.3659942363112397E-2,0,null,null,null,0,0,0,0,0]
[null,null,"PROW Signs ","Metal ",0,0,0,0,0,0,0,0,0.57874015748031493,0.14761904761904762,0.589622641509434,0.25954198473282442,0.79836512261580383,0.20299145299145299,0.46582397003745318,0.29394812680115273,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber ",0,0,0,0,0,0,0,0,0.26377952755905509,0.37142857142857144,0.3867924528301887,0.69083969465648853,0.54495912806539515,0.82799145299145294,0.27200374531835209,1.355907780979827,0,null,null,null,0,0,0,0,0]
[null,null,"Pedestrian Barriers","Standard PGR1 ",0,0,0,0,0,0,0,0,5.2440944881889759,0.38095238095238093,6.0613207547169807,1.0954198473282444,2.5367847411444142,0.31730769230769229,1.699438202247191,0.34870317002881845,0,null,null,null,0,0,0,0,0]
[null,null,null,"Visirail PGR3",0,0,0,0,0,0,0,0,21.476377952755904,0.85238095238095235,5.6650943396226419,0.91603053435114501,3.7193460490463215,0.20085470085470086,2.8572097378277155,0.17723342939481268,0,null,null,null,0,0,0,0,0]
[null,null,"Safety Fencing (Lin m)","Box Single",0,0,0,0,0,0,0,0,14.492125984251969,80.283333333333331,3.9245283018867925,4.3129770992366412,5.4959128065395095,1.7521367521367521,2.2125468164794007,3.1887608069164264,0,null,null,null,0,0,0,0,0]
[null,null,null,"Box Double",0,0,0,0,0,0,0,0,0.36220472440944884,2.4333333333333331,3.7735849056603772E-2,0,0.1907356948228883,0,4.6816479400749065E-3,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Ten",0,0,0,0,0,0,0,0,14.34251968503937,83.211904761904762,2.1132075471698113,2.8167938931297711,1.4931880108991826,4.9444444444444446,2.0992509363295881,2.3083573487031699,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Un-Ten",0,0,0,0,0,0,0,0,1.3503937007874016,0.60476190476190472,0.91509433962264153,0.46564885496183206,0.60762942779291551,0.27136752136752135,0.23408239700374531,0.29971181556195964,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Double - Ten",0,0,0,0,0,0,0,0,0,0,0,0,0,1.9230769230769232E-2,7.9588014981273412E-3,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr - Un-Ten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Wire Rope",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Stops",null,0,0,0,0,0,0,0,0,3.1417322834645671,0.53095238095238095,2.7264150943396226,0.67938931297709926,1.9754768392370572,0.23824786324786323,1.029494382022472,0.11527377521613832,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Shelters ","Concrete",0,0,0,0,0,0,0,0,0.12204724409448819,4.7619047619047616E-2,0.18396226415094338,4.9618320610687022E-2,0.10899182561307902,1.8162393162393164E-2,2.247191011235955E-2,4.3227665706051877E-3,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber",0,0,0,0,0,0,0,0,7.874015748031496E-2,1.1904761904761904E-2,0.12735849056603774,3.8167938931297711E-2,5.9945504087193457E-2,9.6153846153846159E-3,8.8951310861423213E-3,7.2046109510086453E-3,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Enclosed ",0,0,0,0,0,0,0,0,0.29527559055118108,2.6190476190476191E-2,0.18396226415094338,0,9.5367847411444148E-2,1.1752136752136752E-2,7.0692883895131092E-2,5.763688760806916E-3,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Cantilever",0,0,0,0,0,0,0,0,0.72047244094488194,2.6190476190476191E-2,0.58490566037735847,4.1984732824427481E-2,0.27247956403269757,1.0683760683760684E-2,0.175561797752809,1.0086455331412104E-2,0,null,null,null,0,0,0,0,0]
[null,null,null,"Metal ",0,0,0,0,0,0,0,0,2.7559055118110236E-2,4.7619047619047623E-3,4.716981132075472E-2,3.8167938931297708E-3,2.7247956403269755E-2,1.0683760683760685E-3,1.1235955056179775E-2,0,0,null,null,null,0,0,0,0,0]
[null,null,"Grit Bins",null,0,0,0,0,0,0,0,0,7.874015748031496E-2,2.6190476190476191E-2,0.17452830188679244,5.3435114503816793E-2,0.20163487738419619,7.371794871794872E-2,0.39138576779026218,0.11527377521613832,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E42/$W$5,0)","v":0},{"$f":"IFERROR(F42/$X$5,0)","v":0},{"$f":"IFERROR(G42/$W$6,0)","v":0},{"$f":"IFERROR(H42/$X$6,0)","v":0},{"$f":"IFERROR(I42/$W$7,0)","v":0},{"$f":"IFERROR(J42/$X$7,0)","v":0},{"$f":"IFERROR(K42/$W$8,0)","v":0},{"$f":"IFERROR(L42/$X$8,0)","v":0},{"$f":"SUM(E42:L42)","v":0},null,null,null,{"$f":"IF(W42=0,0,(W42/X42))","v":0},{"$f":"V42*U42","v":0},{"$f":"IFERROR(Z42/X42,0)","v":0},{"$f":"IFERROR(MIN(W42,X42)*AA42,0)","v":0},{"$f":"Z42-AB42","v":0}]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E43/$W$5,0)","v":0},{"$f":"IFERROR(F43/$X$5,0)","v":0},{"$f":"IFERROR(G43/$W$6,0)","v":0},{"$f":"IFERROR(H43/$X$6,0)","v":0},{"$f":"IFERROR(I43/$W$7,0)","v":0},{"$f":"IFERROR(J43/$X$7,0)","v":0},{"$f":"IFERROR(K43/$W$8,0)","v":0},{"$f":"IFERROR(L43/$X$8,0)","v":0},{"$f":"SUM(E43:L43)","v":0},null,null,null,{"$f":"IF(W43=0,0,(W43/X43))","v":0},{"$f":"V43*U43","v":0},{"$f":"IFERROR(Z43/X43,0)","v":0},{"$f":"IFERROR(MIN(W43,X43)*AA43,0)","v":0},{"$f":"Z43-AB43","v":0}]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",{"$f":"SUM(SFDerbyshire[GRC Value (£)])/1000","v":0}]
[null,null,null,"ACCUMULATED DEPRECIATION (£,000s)",{"$f":"SUM(SFDerbyshire[Accumulated Depreciation (£)])/1000","v":0}]
[null,null,null,"ANNUAL DEPRECIATION (£,000s)",{"$f":"SUM(SFDerbyshire[Annual Depreciation (£)])/1000","v":0}]
[null,null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",{"$f":"SUM(SFDerbyshire[DRC Value (£)])/1000","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Change Register","Change"]
[null,null,"Version 2.5, Nov 2015","* Cell information (?) button"]
[null,null,null,"* Auto populate/manual input in the Network Length Table"]
[null,null,null,"* Table layout to allow authorities to copy and paste data from another worksheet"]

{"sheet":"SF - Hertfordshire","index":9,"n_rows":63,"n_cols":29,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,2,2,11],[2,13,2,18],[4,13,4,16],[3,3,3,11],[6,3,6,11],[5,3,5,11],[62,3,62,9],[11,4,12,11],[11,12,12,19],[59,3,59,4],[13,12,13,13],[13,10,13,11],[13,8,13,9],[13,6,13,7],[13,4,13,5],[48,2,57,28],[2,20,2,23],[3,20,3,21],[8,20,8,21],[7,20,7,21],[6,20,6,21],[5,20,5,21],[4,20,4,21],[8,3,8,10],[9,3,9,11],[9,20,9,21],[47,2,47,28],[11,20,12,28],[13,20,13,28],[13,18,13,19],[13,16,13,17],[13,14,13,15]]}
[]
[]
[null,null,"Street Furniture - Hertfordshire",null,null,null,null,null,null,null,null,null,null,"Adding Additional Rows",null,null,null,null,null,null,"Network length (km)"]
[null,null,"Step 1","Enter the Number of Additional Assets Rows required in 'Adding Additional Rows' box and press INSERT ROWS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Type/Classification",null," Urban","Rural"]
[null,null,"Step 2","Enter the NUMBER OF ASSETS PER ROAD CLASSIFICATION  per Asset Type",null,null,null,null,null,null,null,null,null,"Number of Additional Assets rows",null,null,null,null,null,null,"A",null,{"$f":"IF('Carriageways & Footways GRC'!D20>0,'Carriageways & Footways GRC'!D20,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D21>0,'Carriageways & Footways GRC'!D21,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 3","Enter Local Average Treatment Cost/Unit, Estimated Age of Assets, and Estimated Lifespan for each asset type.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,{"$f":"IF('Carriageways & Footways GRC'!D22>0,'Carriageways & Footways GRC'!D22,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D23>0,'Carriageways & Footways GRC'!D23,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 4","Add any comments to the comments box provided at the bottom of the sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",null,{"$f":"IF('Carriageways & Footways GRC'!D24>0,'Carriageways & Footways GRC'!D24,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D25>0,'Carriageways & Footways GRC'!D25,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,{"$f":"IF('Carriageways & Footways GRC'!D26>0,'Carriageways & Footways GRC'!D26,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D27>0,'Carriageways & Footways GRC'!D27,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Note 1","If you have Street Furniture assets on Motorways then please incorporate under A Roads.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length",null,{"$f":"SUM(W5:W8)","v":0},{"$f":"SUM(X5:X8)","v":0}]
[null,null,"Note 2","To Delete Rows from Additional Assets please select the rows and press DELETE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand total",null,{"$f":"SUM(W9:X9)","v":0}]
[]
[null,null,null,null,"Number of Assets  per road classification",null,null,null,null,null,null,null,"Number of Assets per km of road classification",null,null,null,null,null,null,null,"GRC and DRC Calculation"]
[]
[null,null,null,null,"A",null,"B",null,"C",null,"UC",null,"A",null,"B",null,"C",null,"UC"]
[null,null,"Asset Type","Sub Group","Urban ","Rural ","Urban","Rural","Urban2","Rural2","Urban3","Rural3","Urban Per Km","Rural Per Km","Urban Per Km2","Rural Per Km2","Urban Per Km3","Rural Per Km3","Urban Per Km4","Rural Per Km4","Total Assets","Local Average Treatment Cost/Unit (£)","Estimated Age (Years)","Estimated Lifespan (Years)","Age/ Lifespan","GRC Value (£)","Annual Depreciation (£)","Accumulated Depreciation (£)","DRC Value (£)"]
[null,null,"Traffic Signs Non-Illuminated ","Warning",{"$f":"IFERROR($W$5*M16,0)","v":0},{"$f":"IFERROR($X$5*N16,0)","v":0},{"$f":"IFERROR($W$6*O16,0)","v":0},{"$f":"IFERROR($X$6*P16,0)","v":0},{"$f":"IFERROR($W$7*Q16,0)","v":0},{"$f":"IFERROR($X$7*R16,0)","v":0},{"$f":"IFERROR($W$8*S16,0)","v":0},{"$f":"IFERROR($X$8*T16,0)","v":0},8.5299999999999994,6.1784841075794619,10.297619047619047,12.48447204968944,11.977900552486188,7.3782051282051286,4.0260336906584993,2.9588607594936707,{"$f":"SUM(E16:L16)","v":0},null,null,null,{"$f":"IF(W16=0,0,(W16/X16))","v":0},{"$f":"V16*U16","v":0},{"$f":"IF(X16=0,0,(Z16/X16))","v":0},{"$f":"IF(Y16*Z16>Z16,\"Check Age/Lifespan\",Y16*Z16)","v":0},{"$f":"IF(AB16=\"Check Age/Lifespan\", \"ERROR\",Z16-AB16)","v":0}]
[null,null,null,"Regulatory",{"$f":"IFERROR($W$5*M17,0)","v":0},{"$f":"IFERROR($X$5*N17,0)","v":0},{"$f":"IFERROR($W$6*O17,0)","v":0},{"$f":"IFERROR($X$6*P17,0)","v":0},{"$f":"IFERROR($W$7*Q17,0)","v":0},{"$f":"IFERROR($X$7*R17,0)","v":0},{"$f":"IFERROR($W$8*S17,0)","v":0},{"$f":"IFERROR($X$8*T17,0)","v":0},15.836666666666666,3.3007334963325183,15.404761904761905,3.0869565217391304,12.237569060773481,3.1645299145299144,9.5696784073506898,2.7832278481012658,{"$f":"SUM(E17:L17)","v":0},null,null,null,0,{"$f":"V17*U17","v":0},0,0,0]
[null,null,null,"Directional",0,0,0,0,0,0,0,0,12.423333333333334,3.4547677261613692,12.30952380952381,3.298136645962733,7.930939226519337,2.3760683760683761,2.3797856049004595,0.75316455696202533,0,null,null,null,0,0,0,0,0]
[null,null,null,"Informatory",0,0,0,0,0,0,0,0,1.2033333333333334,1.1320293398533008,1.1547619047619047,0.31677018633540371,1.1022099447513811,0.23931623931623933,1.9693721286370598,0.51898734177215189,0,null,null,null,0,0,0,0,0]
[null,null,null,"Boundary ",0,0,0,0,0,0,0,0,2.1833333333333331,0.33496332518337407,2.7797619047619047,1.1614906832298137,3.1077348066298343,1.0662393162393162,7.6849157733537519,1.2531645569620253,0,null,null,null,0,0,0,0,0]
[null,null,null,"Non DCC",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Parking Directional",0,0,0,0,0,0,0,0,0.39666666666666667,0.22493887530562348,0.39880952380952384,0,0,4.2735042735042739E-3,8.5375191424196015E-2,9.4936708860759497E-3,0,null,null,null,0,0,0,0,0]
[null,null,null,"Not Assessed",0,0,0,0,0,0,0,0,1.54,0.24694376528117359,3.5892857142857144,0.57763975155279501,2.8701657458563536,0.89316239316239321,6.5114854517611027,0.754746835443038,0,null,null,null,0,0,0,0,0]
[null,null,"PROW Signs ","Metal ",0,0,0,0,0,0,0,0,0.6166666666666667,0.57212713936430315,1.2083333333333333,1.8757763975155279,5.2209944751381219,2.1880341880341883,0.63131699846860645,2.5490506329113924,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Pedestrian Barriers (Lin m)","Standard PGR1 ",0,0,0,0,0,0,0,0,146.99,0,67.773809523809518,0,29.038674033149171,0,17.254211332312405,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Visirail PGR3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Safety Fencing (Lin m)","Box Single",0,0,0,0,0,0,0,0,78.046666666666667,134.45476772616138,3.9761904761904763,13.875776397515528,1.701657458563536,0,0.91807044410413474,1.8924050632911393,0,null,null,null,0,0,0,0,0]
[null,null,null,"Box Double",0,0,0,0,0,0,0,0,11.4,18.9119804400978,0,0,0,1.2692307692307692,4.9770290964777945E-3,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Ten",0,0,0,0,0,0,0,0,17.690000000000001,173.0562347188264,0.20238095238095238,4.2919254658385091,0,6.4316239316239319,0.25191424196018375,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Un-Ten",0,0,0,0,0,0,0,0,11.61,20.515892420537899,2.9761904761904763,17.63975155279503,1.2928176795580111,0,0.84571209800918834,2.3718354430379747,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Double - Ten",0,0,0,0,0,0,0,0,0,117.15892420537897,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr - Un-Ten",0,0,0,0,0,0,0,0,0.12,0,0.10714285714285714,0.14906832298136646,0,0,0,1.2658227848101266E-2,0,null,null,null,0,0,0,0,0]
[null,null,null,"Wire Rope",0,0,0,0,0,0,0,0,0,24.965770171149146,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Stops",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Shelters ","Concrete",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Enclosed ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Cantilever",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Metal ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Grit Bins",null,0,0,0,0,0,0,0,0,7.0000000000000007E-2,4.8899755501222494E-3,0.1130952380952381,6.2111801242236021E-3,0.18784530386740331,4.05982905982906E-2,0.35987748851454826,5.8544303797468354E-2,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E42/$W$5,0)","v":0},{"$f":"IFERROR(F42/$X$5,0)","v":0},{"$f":"IFERROR(G42/$W$6,0)","v":0},{"$f":"IFERROR(H42/$X$6,0)","v":0},{"$f":"IFERROR(I42/$W$7,0)","v":0},{"$f":"IFERROR(J42/$X$7,0)","v":0},{"$f":"IFERROR(K42/$W$8,0)","v":0},{"$f":"IFERROR(L42/$X$8,0)","v":0},{"$f":"SUM(E42:L42)","v":0},null,null,null,{"$f":"IF(W42=0,0,(W42/X42))","v":0},{"$f":"V42*U42","v":0},{"$f":"IF(X42=0,0,(Z42/X42))","v":0},{"$f":"IF(Y42*Z42>Z42,\"Check Age/Lifespan\",Y42*Z42)","v":0},{"$f":"IF(AB42=\"Check Age/Lifespan\", \"ERROR\",Z42-AB42)","v":0}]
[null,null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",{"$f":"SUM(SFHerts[GRC Value (£)])/1000","v":0}]
[null,null,null,"ACCUMULATED DEPRECIATION (£,000s)",{"$f":"SUM(SFHerts[Accumulated Depreciation (£)])/1000","v":0}]
[null,null,null,"ANNUAL DEPRECIATION (£,000s)",{"$f":"SUM(SFHerts[Annual Depreciation (£)])/1000","v":0}]
[null,null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",{"$f":"SUM(SFHerts[DRC Value (£)])/1000","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Change Register","Change"]
[null,null,"Version 2.5, Nov 2015","* Cell information (?) button"]
[null,null,null,"* Auto populate/manual input in the Network Length Table"]
[null,null,null,"* Table layout to allow authorities to copy and paste data from another worksheet"]

{"sheet":"SF - Medway","index":10,"n_rows":83,"n_cols":29,"rows_kept":83,"cut":false,"hidden":false,"merged":[[2,20,2,23],[7,20,7,21],[6,20,6,21],[5,20,5,21],[4,20,4,21],[3,20,3,21],[79,3,79,4],[82,3,82,9],[67,2,67,28],[68,2,77,28],[9,20,9,21],[13,4,13,5],[13,18,13,19],[8,3,8,10],[9,3,9,11],[13,16,13,17],[11,20,12,28],[11,4,12,11],[11,12,12,19],[13,12,13,13],[13,10,13,11],[13,6,13,7],[13,8,13,9],[13,14,13,15],[8,20,8,21],[2,2,2,11],[2,13,2,18],[4,13,4,16],[3,3,3,11],[6,3,6,11],[5,3,5,11]]}
[]
[]
[null,null,"Street Furniture - Medway",null,null,null,null,null,null,null,null,null,null,"Adding Additional Rows",null,null,null,null,null,null,"Network length (km)"]
[null,null,"Step 1","Enter the Number of Additional Assets Rows required in 'Adding Additional Rows' box and press INSERT ROWS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Type/Classification",null," Urban","Rural"]
[null,null,"Step 2","Enter the NUMBER OF ASSETS PER ROAD CLASSIFICATION  per Asset Type",null,null,null,null,null,null,null,null,null,"Number of Additional Assets rows",null,null,null,null,null,null,"A",null,{"$f":"IF('Carriageways & Footways GRC'!D20>0,'Carriageways & Footways GRC'!D20,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D21>0,'Carriageways & Footways GRC'!D21,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 3","Enter Local Average Treatment Cost/Unit, Estimated Age of Assets, and Estimated Lifespan for each asset type.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,{"$f":"IF('Carriageways & Footways GRC'!D22>0,'Carriageways & Footways GRC'!D22,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D23>0,'Carriageways & Footways GRC'!D23,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Step 4","Add any comments to the comments box provided at the bottom of the sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",null,{"$f":"IF('Carriageways & Footways GRC'!D24>0,'Carriageways & Footways GRC'!D24,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D25>0,'Carriageways & Footways GRC'!D25,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UC",null,{"$f":"IF('Carriageways & Footways GRC'!D26>0,'Carriageways & Footways GRC'!D26,\"Please enter a length\")","v":"Please enter a length"},{"$f":"IF('Carriageways & Footways GRC'!D27>0,'Carriageways & Footways GRC'!D27,\"Please enter a length\")","v":"Please enter a length"}]
[null,null,"Note 1","If you have Street Furniture assets on Motorways then please incorporate under A Roads.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length",null,{"$f":"SUM(W5:W8)","v":0},{"$f":"SUM(X5:X8)","v":0}]
[null,null,"Note 2","To Delete Rows from Additional Assets please select the rows and press DELETE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand total",null,{"$f":"SUM(W9:X9)","v":0}]
[]
[null,null,null,null,"Number of Assets  per road classification",null,null,null,null,null,null,null,"Number of Assets per km of road classification",null,null,null,null,null,null,null,"GRC and DRC Calculation"]
[]
[null,null,null,null,"A",null,"B",null,"C",null,"UC",null,"A",null,"B",null,"C",null,"UC"]
[null,null,"Asset Type","Sub Group","Urban ","Rural ","Urban","Rural","Urban2","Rural2","Urban3","Rural3","Urban Per Km","Rural Per Km","Urban Per Km2","Rural Per Km2","Urban Per Km3","Rural Per Km3","Urban Per Km4","Rural Per Km4","Total Assets","Local Average Treatment Cost/Unit (£)","Estimated Age (Years)","Estimated Lifespan (Years)","Age/ Lifespan","GRC Value (£)","Annual Depreciation (£)","Accumulated Depreciation (£)","DRC Value (£)"]
[null,null,"Traffic Signs Non-Illuminated ","Warning",{"$f":"IFERROR($W$5*M16,0)","v":0},{"$f":"IFERROR($X$5*N16,0)","v":0},{"$f":"IFERROR($W$6*O16,0)","v":0},{"$f":"IFERROR($X$6*P16,0)","v":0},{"$f":"IFERROR($W$7*Q16,0)","v":0},{"$f":"IFERROR($X$7*R16,0)","v":0},{"$f":"IFERROR($W$8*S16,0)","v":0},{"$f":"IFERROR($X$8*T16,0)","v":0},7.6578947368421053,2.60606060606061,2.3333333333333299,4,3.074074074074074,2.6666666666666665,1.346938775510204,1.2972972972972974,{"$f":"SUM(E16:L16)","v":0},null,null,null,{"$f":"IF(X16=0,0,(W16/X16))","v":0},{"$f":"V16*U16","v":0},{"$f":"IF(X16=0,0,(Z16/X16))","v":0},{"$f":"IF(Y16*Z16>Z16,\"Check Age/Lifespan\",Y16*Z16)","v":0},{"$f":"IF(AB16=\"Check Age/Lifespan\", \"ERROR\",Z16-AB16)","v":0}]
[null,null,null,"Regulatory",{"$f":"IFERROR($W$5*M17,0)","v":0},{"$f":"IFERROR($X$5*N17,0)","v":0},{"$f":"IFERROR($W$6*O17,0)","v":0},{"$f":"IFERROR($X$6*P17,0)","v":0},{"$f":"IFERROR($W$7*Q17,0)","v":0},{"$f":"IFERROR($X$7*R17,0)","v":0},{"$f":"IFERROR($W$8*S17,0)","v":0},{"$f":"IFERROR($X$8*T17,0)","v":0},18,5.333333333333333,5.2592592592592595,7,5.8148148148148149,3.0333333333333332,5.8265306122448983,2.4864864864864864,{"$f":"SUM(E17:L17)","v":0},null,null,null,{"$f":"IF(X17=0,0,(W17/X17))","v":0},{"$f":"V17*U17","v":0},0,0,0]
[null,null,null,"Directional",0,0,0,0,0,0,0,0,8.1842105263157894,3.2121212121212119,2.5925925925925926,2.8,2.7037037037037037,1.5666666666666667,0.75680272108843538,2.4054054054054053,0,null,null,null,0,0,0,0,0]
[null,null,null,"Informatory",0,0,0,0,0,0,0,0,9.3947368421052637,1.8787878787878789,2,0,1.4259259259259258,1.0333333333333334,1.4659863945578231,1.1351351351351351,0,null,null,null,0,0,0,0,0]
[null,null,null,"Boundary ",0,0,0,0,0,0,0,0,0.31578947368421051,0.27272727272727271,3.7037037037037035E-2,0.8,0.22222222222222221,0.16666666666666666,1.8707482993197279E-2,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Non DCC",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Parking Directional",0,0,0,0,0,0,0,0,1.1578947368421053,0,0.14814814814814814,0,5.5555555555555552E-2,0,8.5034013605442188E-2,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Not Assessed",0,0,0,0,0,0,0,0,0.18421052631578949,9.0909090909090912E-2,0.1111111111111111,0,3.7037037037037035E-2,0.9,0.43877551020408162,0.7567567567567568,0,null,null,null,0,0,0,0,0]
[null,null,"PROW Signs ","Metal ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Pedestrian Barriers (Lin m)","Ornamental",0,0,0,0,0,0,0,0,25.89,0,0,0,3.48,0,0.19,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Conc post and rail",0,0,0,0,0,0,0,0,2.0299999999999998,0,0.33,0,0,0,0.7,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Kee Klamp Tube",0,0,0,0,0,0,0,0,0.24,0,7.0000000000000007E-2,0,0.5,0.2,0.38,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Other PGR",0,0,0,0,0,0,0,0,0.87,0,0.44,0,3.8,5.67,1.05,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Tubular",0,0,0,0,0,0,0,0,0.82,1.27,1.1100000000000001,12.8,0.56000000000000005,0.03,10.15,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Visi Rail",0,0,0,0,0,0,0,0,152.44999999999999,6.45,16.809999999999999,0,10.57,2.33,4.55,2.86,0,null,null,null,0,0,0,0,0]
[null,null,null,"Non standard steel",0,0,0,0,0,0,0,0,83.95,5.7,7.3,0,21.72,4.2,6.98,0,0,null,null,null,0,0,0,0,0]
[null,null,"Safety Fencing (Lin m)","Box Single",0,0,0,0,0,0,0,0,216.11,29.61,0,23.4,5.5,6.73,0.54,5.32,0,null,null,null,0,0,0,0,0]
[null,null,null,"Box Double",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Ten",0,0,0,0,0,0,0,0,380.18,52.03,14.44,0.6,5.22,9.57,1.67,2.68,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Single - Un-Ten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr Double - Ten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Corr - Un-Ten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Wire Rope",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Stops",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bus Shelters ","Bus Shelter (unspec)",0,0,0,0,0,0,0,0,0.57999999999999996,0.12,0.33,0,0.59,7.0000000000000007E-2,0.14000000000000001,2.8571428571428571E-2,0,null,null,null,0,0,0,0,0]
[null,null,null,"Concrete",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Enclosed ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Glass Cantilever",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Metal ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,"Grit Bins",null,0,0,0,0,0,0,0,0,0.53,0.33,0.15,0,1.37,0.03,0.63,0,0,null,null,null,0,0,0,0,0]
[null,null,"Bollards Non Illum","Cast Iron",0,0,0,0,0,0,0,0,9.4700000000000006,0.06,1.19,0,3.3,0.17,1.62,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Concrete",0,0,0,0,0,0,0,0,0.95,0.06,1,0,0.74,3.53,2.13,1.24,0,null,null,null,0,0,0,0,0]
[null,null,null,"Plastic",0,0,0,0,0,0,0,0,2.66,11.82,2.81,10.199999999999999,4.3099999999999996,2.37,1.78,0.35,0,null,null,null,0,0,0,0,0]
[null,null,null,"Geo",0,0,0,0,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Other ",0,0,0,0,0,0,0,0,0.42,0,0,0,0.33,1.5,0.1,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Steel",0,0,0,0,0,0,0,0,2.08,0.52,2.81,12,3.8,3.1,2.33,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Timber",0,0,0,0,0,0,0,0,5,2.79,0.3,0,1.43,0.97,2.82,1.1399999999999999,0,null,null,null,0,0,0,0,0]
[null,null,"Street Furniture","Bench",0,0,0,0,0,0,0,0,3.32,0.03,0.33,0,0.52,0.37,0.26,0.05,0,null,null,null,0,0,0,0,0]
[null,null,null,"Freestanding Planter",0,0,0,0,0,0,0,0,1.34,0,0,0,0.44,0,0.02,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Built In Planter",0,0,0,0,0,0,0,0,0.97,0,0,0.2,0.04,0,7.0000000000000007E-2,0,0,null,null,null,0,0,0,0,0]
[null,null,null,"Sculpture",0,0,0,0,0,0,0,0,0.42,0,0,0,0,0.03,0.01,0,0,null,null,null,0,0,0,0,0]
[null,null,"Street Name Plates","Recycled Dibond",0,0,0,0,0,0,0,0,0.47,0.03,0.19,0.4,0.39,0.2,0.57999999999999996,0.38,0,null,null,null,0,0,0,0,0]
[null,null,null,"Any other material",0,0,0,0,0,0,0,0,2.13,0.48,1.1499999999999999,1,1.93,1.53,6.78,1.68,0,null,null,null,0,0,0,0,0]
[null,null,"Hooped Barrier","Hooped Barrier",0,0,0,0,0,0,0,0,0.16,0,0.3,0,0.33,0,0.57999999999999996,0.43,0,null,null,null,0,0,0,0,0]
[null,null,"Additional Assets","Add Additional Assets Here",null,null,null,null,null,null,null,null,{"$f":"IFERROR(E62/$W$5,0)","v":0},{"$f":"IFERROR(F62/$X$5,0)","v":0},{"$f":"IFERROR(G62/$W$6,0)","v":0},{"$f":"IFERROR(H62/$X$6,0)","v":0},{"$f":"IFERROR(I62/$W$7,0)","v":0},{"$f":"IFERROR(J62/$X$7,0)","v":0},{"$f":"IFERROR(K62/$W$8,0)","v":0},{"$f":"IFERROR(L62/$X$8,0)","v":0},{"$f":"SUM(E62:L62)","v":0},null,null,null,{"$f":"IF(X62=0,0,(W62/X62))","v":0},{"$f":"V62*U62","v":0},{"$f":"IF(X62=0,0,(Z62/X62))","v":0},{"$f":"IF(Y62*Z62>Z62,\"Check Age/Lifespan\",Y62*Z62)","v":0},{"$f":"IF(AB62=\"Check Age/Lifespan\", \"ERROR\",Z62-AB62)","v":0}]
[null,null,null,"GROSS REPLACEMENT COST (GRC) (£,000s)",{"$f":"SUM(SFMedway[GRC Value (£)])/1000","v":0}]
[null,null,null,"ACCUMULATED DEPRECIATION (£,000s)",{"$f":"SUM(SFMedway[Accumulated Depreciation (£)])/1000","v":0}]
[null,null,null,"ANNUAL DEPRECIATION (£,000s)",{"$f":"SUM(SFMedway[Annual Depreciation (£)])/1000","v":0}]
[null,null,null,"DEPRECIATED REPLACEMENT COST (DRC) (£,000s)",{"$f":"SUM(SFMedway[DRC Value (£)])/1000","v":0}]
[]
[null,null,"Notes/Evidance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Change Register","Change"]
[null,null,"Version 2.5, Nov 2015","* Cell information (?) button"]
[null,null,null,"* Auto populate/manual input in the Network Length Table"]
[null,null,null,"* Table layout to allow authorities to copy and paste data from another worksheet"]

{"sheet":"Land GRC","index":11,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,13,10,13],[39,1,39,2],[39,3,39,4],[40,1,40,2],[7,3,7,10],[43,1,43,2],[27,3,27,6],[12,3,12,9],[26,7,26,8],[28,3,28,6],[30,2,30,6],[22,4,26,4],[22,6,26,6],[16,3,17,3],[16,4,17,4],[31,2,36,6],[13,3,13,9],[2,2,2,10],[11,3,11,10],[10,3,10,10],[9,3,9,10],[6,3,6,10]]}
[]
[]
[null,null," LAND GRC"]
[]
[null,null,"Step 1","Select a REGION"]
[null,null,"Step 2","Select your AUTHORITY (If you are Scotland or Wales please fill in the appropriate yellow cells)"]
[null,null,"Step 3","Enter a VERGE WIDTH"]
[null,null,"Step 4","If your VERGE AREA is not pre-populated or you wish to enter your own please do so in VERGE AREA"]
[]
[null,null,"Note 1","Three components combine to form the area of the highway network and are set against land values.  These three elements are; the carriageway, footway and maintained grass verge area."]
[null,null,"Note 2","The summation of these individual areas provides the total highway area that is maintained by an authority.  "]
[null,null,"Note 3","The verge width entered should be the summation of the average verge width on both sides of the carriageway."]
[null,null,"Note 4","If the average width for each side of the carriageway is unknown, then authorities can use Hertfordshire as an example where the Urban verge width is 1.21 and the Rural Verge Width is 1.61"]
[null,null,"Note 5","Cycleways (bound and unbound) are included in Footways and Cycleways Area for Urban only"]
[]
[null,null,"Rate for Authority","Urban Rate","Rural Rate"]
[null,null,"Select_a_Region",{"$f":"IF(C17=\"Select a Region\",0,IFERROR(VLOOKUP(C18,'Land Values'!B:H,7,FALSE),0))","v":0},{"$f":"IF(C17=\"Select a Region\",0,IFERROR(VLOOKUP(C18,'Land Values'!B:G,6,FALSE),0))","v":0}]
[null,null,"Pick your Authority"]
[null,null,"Scotland"]
[null,null,"Wales"]
[]
[null,null,"Category ","Urban (m²)","Urban Rate (£/m2)","Rural (m²)","Rural Rate (£/m2)"]
[null,null,"Carriageway Area",{"$f":"SUM('Carriageways & Footways GRC'!F20+'Carriageways & Footways GRC'!F22+'Carriageways & Footways GRC'!F24+'Carriageways & Footways GRC'!F26)","v":0},{"$f":"IF(D17>0,D17,IF(D19>0,D19,IF(D20>0,D20,0)))","v":0},{"$f":"SUM('Carriageways & Footways GRC'!F19+'Carriageways & Footways GRC'!F21+'Carriageways & Footways GRC'!F23+'Carriageways & Footways GRC'!F25+'Carriageways & Footways GRC'!F27)","v":0},{"$f":"IF(E17>0,E17,IF(E19>0,E19,IF(E20>0,E20,0)))","v":0}]
[null,null,"Footway and Cycleway Area",{"$f":"SUM('Carriageways & Footways GRC'!P19+'Carriageways & Footways GRC'!P20+'Carriageways & Footways GRC'!P22+'Carriageways & Footways GRC'!P24+'Carriageways & Footways GRC'!P26 +'Carriageways & Footways GRC'!P28+'Carriageways & Footways GRC'!P29)","v":0},null,{"$f":"SUM('Carriageways & Footways GRC'!P21+'Carriageways & Footways GRC'!P23+'Carriageways & Footways GRC'!P25+'Carriageways & Footways GRC'!P27)","v":0}]
[null,null,"Highway Area",{"$f":"D23+D24","v":0},null,{"$f":"F23+F24","v":0}]
[null,null,"Verge Width (m)"]
[null,null,"Verge Area",{"$f":"IF(1000*$D$26*SUM('Carriageways & Footways GRC'!D20,'Carriageways & Footways GRC'!D22,'Carriageways & Footways GRC'!D24,'Carriageways & Footways GRC'!D26)>0,1000*$D$26*SUM('Carriageways & Footways GRC'!D20,'Carriageways & Footways GRC'!D22,'Carriageways & Footways GRC'!D24,'Carriageways & Footways GRC'!D26),\"Please Enter Verge Width or Area\")","v":"Please Enter Verge Width or Area"},null,{"$f":"IF(1000*$F$26*SUM('Carriageways & Footways GRC'!D19,'Carriageways & Footways GRC'!D21,'Carriageways & Footways GRC'!D23,'Carriageways & Footways GRC'!D25,'Carriageways & Footways GRC'!D27)>0,1000*$F$26*SUM('Carriageways & Footways GRC'!D19,'Carriageways & Footways GRC'!D21,'Carriageways & Footways GRC'!D23,'Carriageways & Footways GRC'!D25,'Carriageways & Footways GRC'!D27),\"Please Enter Verge Width or Area\")","v":"Please Enter Verge Width or Area"},null,{"$f":"IF(OR(D27=0,F27=0),\"Check Verge Area\",\" \")","v":" "}]
[null,null,"Total Land Area (m2)",{"$f":"IFERROR(D25+D27+F25+F27,0)","v":0}]
[null,null,"Total Land Value  (£,000's)",{"$f":"IFERROR(((D25+D27)*E23+(F25+F27)*G23)/1000,0)","v":0}]
[]
[null,null,"Notes/Evidence"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change Register",null,"Change"]
[null,"Version 2.5, Nov 2015",null,"* Help button in title bar ( ὶ ) button"]
[null,null,null,"* Cell information (?) button"]
[null,null,null,"* Select Region and then Authority for an easier search"]
[null,null,null,"* Auto populate/manual input for Verge Area"]

{"sheet":"Certificate","index":12,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":true,"merged":[[17,8,17,10],[24,11,24,13],[24,8,24,10],[24,5,24,7],[19,11,19,13],[18,11,18,13],[22,8,22,10],[21,8,21,10],[20,8,20,10],[19,8,19,10],[18,8,18,10],[23,11,23,13],[16,8,16,10],[16,11,16,13],[17,3,17,4],[18,3,18,4],[23,8,23,10],[23,5,23,7],[22,11,22,13],[21,11,21,13],[20,11,20,13],[22,5,22,7],[21,5,21,7],[20,5,20,7],[19,5,19,7],[18,5,18,7],[17,5,17,7],[17,11,17,13],[14,14,14,15],[13,14,13,15],[2,1,2,17],[3,1,32,1],[32,2,32,17],[3,17,31,17],[4,4,4,14],[6,4,6,14],[8,6,10,12],[19,3,19,4],[24,3,24,4],[23,3,23,4],[22,3,22,4],[21,3,21,4],[20,3,20,4],[16,5,16,7]]}
[]
[]
[]
[]
[null,null,null,null,"VALUATION TOOLKIT"]
[]
[null,null,null,null,"Certificate of Valuation for "]
[]
[null,null,null,null,null,null,"Hull"]
[]
[]
[]
[]
[null,null,null,"Valuation Toolkit Version : ",null,null,{"$f":"'Home Page'!C34","v":"15/16 Valuation Toolkit, Version 2.6, Feb 2016"},null,null,null,null,null,"Date of Issue:",null,{"$f":"NOW()","v":"2025-03-31T10:10:02.360"}]
[null,null,null,"Valuation Variables Version:",null,null,{"$f":"'Valuation Variables'!B8","v":"Version 1.4"},null,null,null,null,null,"Time of Issue:",null,{"$f":"NOW()","v":45747.423638425927}]
[]
[null,null,null,null,null,"GRC\nClosing Balance",null,null,"Accumulated Depreciation Closing Balance",null,null,"DRC\nClosing Balance"]
[null,null,null,"Carriageway",null,{"$f":"'Valuation Summary'!D30","v":0},null,null,{"$f":"'Valuation Summary'!D42","v":0},null,null,{"$f":"'Valuation Summary'!D45","v":0}]
[null,null,null,"Footways + Cycleways",null,{"$f":"'Valuation Summary'!E30","v":0},null,null,{"$f":"'Valuation Summary'!E42","v":0},null,null,{"$f":"'Valuation Summary'!E45","v":0}]
[null,null,null,"Structures",null,{"$f":"'Valuation Summary'!F30","v":0},null,null,{"$f":"'Valuation Summary'!F42","v":0},null,null,{"$f":"'Valuation Summary'!F45","v":0}]
[null,null,null,"Street Lighting",null,{"$f":"'Valuation Summary'!G30","v":0},null,null,{"$f":"'Valuation Summary'!G42","v":0},null,null,{"$f":"'Valuation Summary'!G45","v":0}]
[null,null,null,"Traffic Management",null,{"$f":"'Valuation Summary'!H30","v":0},null,null,{"$f":"'Valuation Summary'!H42","v":0},null,null,{"$f":"'Valuation Summary'!H45","v":0}]
[null,null,null,"Street furniture",null,{"$f":"'Valuation Summary'!I30","v":0},null,null,{"$f":"'Valuation Summary'!I42","v":0},null,null,{"$f":"'Valuation Summary'!I45","v":0}]
[null,null,null,"Land",null,{"$f":"'Valuation Summary'!J30","v":0},null,null,"-",null,null,"-"]
[null,null,null,"TOTAL",null,{"$f":"SUM(F18:H24)","v":0},null,null,{"$f":"SUM(I18:K23)","v":0},null,null,{"$f":"SUM(L18:N23)","v":0}]

{"sheet":"Valuation Variables","index":13,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Valuation Variable for the Valuation Toolkit "]
[]
[null,"This Workbook contains Regional Factors, HAMFIG Default GRC Rates and Land Values"]
[null,"The Version Control shows when the rates were last updated in this workbook"]
[]
[null,"Version Control","Regional Factors","GRC Rates","Land Values"]
[null,"Version 1.4","2017-06-21","2018-06-06","2018-06-13"]

{"sheet":"Regions","index":14,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Regions"]
["Select _a_Region"]
["East_Midlands"]
["East_of_England"]
["Greater_London"]
["North_East"]
["North_West"]
["Scotland"]
["South_East"]
["South_West"]
["Wales"]
["West_Midlands"]
["Yorkshire_and_the_Humber"]

{"sheet":"Regional Factors","index":15,"n_rows":215,"n_cols":3,"rows_kept":215,"cut":false,"hidden":true,"merged":[]}
["Region","Authority","Regional Factor"]
["Select a Region","Pick your Authority",0]
["East Midlands","Derby",96]
["East Midlands","Derbyshire",102]
["East Midlands","Leicester",99]
["East Midlands","Leicestershire",100]
["East Midlands","Lincolnshire",101]
["East Midlands","Northamptonshire",106]
["East Midlands","Nottingham",101]
["East Midlands","Nottinghamshire",100]
["East Midlands","Rutland",105]
["East of England","Bedford",99]
["East of England","Cambridgeshire",98]
["East of England","Central Bedfordshire",102]
["East of England","Essex",102]
["East of England","Hertfordshire",105]
["East of England","Luton",104]
["East of England","Norfolk",95]
["East of England","Peterborough",96]
["East of England","Southend-On-Sea",100]
["East of England","Suffolk",96]
["East of England","Thurrock",99]
["Greater London","Barking And Dagenham",120]
["Greater London","Barnet",124]
["Greater London","Bexley",127]
["Greater London","Brent",126]
["Greater London","Bromley",124]
["Greater London","Camden",136]
["Greater London","City Of London",126]
["Greater London","Croydon",127]
["Greater London","Ealing",132]
["Greater London","Enfield",122]
["Greater London","Greater London",128]
["Greater London","Greenwich",128]
["Greater London","Hackney",130]
["Greater London","Hammersmith And Fulham",134]
["Greater London","Haringey",134]
["Greater London","Harrow",120]
["Greater London","Havering",111]
["Greater London","Hillingdon",121]
["Greater London","Hounslow",120]
["Greater London","Islington",132]
["Greater London","Kensington And Chelsea",140]
["Greater London","Kingston Upon Thames",129]
["Greater London","Lambeth",133]
["Greater London","Lewisham",125]
["Greater London","Merton",128]
["Greater London","Newham",123]
["Greater London","Redbridge",118]
["Greater London","Richmond Upon Thames",127]
["Greater London","Southwark",132]
["Greater London","Sutton",124]
["Greater London","Tower Hamlets",131]
["Greater London","Transport for London",127]
["Greater London","Waltham Forest",122]
["Greater London","Wandsworth",134]
["Greater London","Westminster",135]
["North East","County Durham",96]
["North East","Darlington",104]
["North East","Gateshead",99]
["North East","Hartlepool",94]
["North East","Middlesbrough",100]
["North East","Newcastle Upon Tyne",96]
["North East","North Tyneside",97]
["North East","Northumberland",99]
["North East","Redcar And Cleveland",95]
["North East","South Tyneside",94]
["North East","Stockton-On-Tees",97]
["North East","Sunderland",92]
["North East","Tyne And Wear",96]
["North West","Blackburn With Darwen",94]
["North West","Blackpool",94]
["North West","Bolton",91]
["North West","Bury",91]
["North West","Cheshire East",92]
["North West","Cheshire West And Chester",92]
["North West","Cumbria",93]
["North West","Greater Manchester",92]
["North West","Halton",91]
["North West","Knowsley",90]
["North West","Lancashire",92]
["North West","Liverpool",90]
["North West","Manchester",95]
["North West","Merseyside",92]
["North West","Oldham",90]
["North West","Rochdale",91]
["North West","Salford",93]
["North West","Sefton",96]
["North West","St Helens",93]
["North West","Stockport",91]
["North West","Tameside",91]
["North West","Trafford",92]
["North West","Warrington",90]
["North West","Wigan",89]
["North West","Wirral",93]
["Scotland","Aberdeen City",84]
["Scotland","Aberdeenshire",85]
["Scotland","Angus",89]
["Scotland","Argyll And Bute",103]
["Scotland","City Of Edinburgh",94]
["Scotland","Clackmannanshire",91]
["Scotland","Dumfries And Galloway",87]
["Scotland","Dundee City",90]
["Scotland","East Ayrshire",91]
["Scotland","East Dunbartonshire",88]
["Scotland","East Lothian",92]
["Scotland","East Renfrewshire",99]
["Scotland","Eilean Siar",106]
["Scotland","Falkirk",85]
["Scotland","Fife",88]
["Scotland","Glasgow City",92]
["Scotland","Highland",88]
["Scotland","Inverclyde",91]
["Scotland","Midlothian",91]
["Scotland","Moray",85]
["Scotland","North Ayrshire",93]
["Scotland","North Lanarkshire",90]
["Scotland","Orkney Islands",99]
["Scotland","Perth And Kinross",89]
["Scotland","Renfrewshire",91]
["Scotland","Scottish Borders",92]
["Scotland","Shetland Islands",113]
["Scotland","South Ayrshire",96]
["Scotland","South Lanarkshire",90]
["Scotland","Stirling",87]
["Scotland","West Dunbartonshire",86]
["Scotland","West Lothian",91]
["South East","Bracknell Forest",118]
["South East","Brighton And Hove",117]
["South East","Buckinghamshire",114]
["South East","East Sussex",117]
["South East","Hampshire",112]
["South East","Isle Of Wight",111]
["South East","Kent",117]
["South East","Medway",117]
["South East","Milton Keynes",108]
["South East","Oxfordshire",111]
["South East","Portsmouth",108]
["South East","Reading",115]
["South East","Slough",113]
["South East","Southampton",112]
["South East","Surrey",121]
["South East","West Berkshire",114]
["South East","West Sussex",115]
["South East","Windsor And Maidenhead",119]
["South East","Wokingham",114]
["South West","Bath And North East Somerset",102]
["South West","Bournemouth",103]
["South West","Bristol",100]
["South West","Cornwall",100]
["South West","Devon",98]
["South West","Dorset",100]
["South West","Gloucestershire",99]
["South West","North Somerset",97]
["South West","Plymouth",97]
["South West","Poole",99]
["South West","Somerset",97]
["South West","South Gloucestershire",92]
["South West","Swindon",97]
["South West","Torbay",100]
["South West","Wiltshire",99]
["Wales","Blaenau Gwent",92]
["Wales","Bridgend",90]
["Wales","Caerphilly",91]
["Wales","Cardiff",91]
["Wales","Carmarthenshire",94]
["Wales","Ceredigion",96]
["Wales","Conwy",90]
["Wales","Denbighshire",86]
["Wales","Flintshire",86]
["Wales","Gwynedd",93]
["Wales","Isle Of Anglesey",91]
["Wales","Merthyr Tydfil",91]
["Wales","Monmouthshire",97]
["Wales","Neath Port Talbot",85]
["Wales","Newport",92]
["Wales","Pembrokeshire",89]
["Wales","Powys",94]
["Wales","Rhondda Cynon Taf",90]
["Wales","Swansea",90]
["Wales","Torfaen",89]
["Wales","Vale Of Glamorgan",93]
["Wales","Wrexham",89]
["West Midlands","Birmingham",96]
["West Midlands","Coventry",96]
["West Midlands","Dudley",94]
["West Midlands","Herefordshire",93]
["West Midlands","Sandwell",97]
["West Midlands","Shropshire",95]
["West Midlands","Solihull",95]
["West Midlands","Staffordshire",94]
["West Midlands","Stoke-On-Trent",94]
["West Midlands","Telford And Wrekin",91]
["West Midlands","Walsall",93]
["West Midlands","Warwickshire",98]
["West Midlands","West Midlands",96]
["West Midlands","Wolverhampton",95]
["West Midlands","Worcestershire",98]
["Yorkshire and the Humber","Barnsley",89]
["Yorkshire and the Humber","Bradford",89]
["Yorkshire and the Humber","Calderdale",89]
["Yorkshire and the Humber","Doncaster",100]
["Yorkshire and the Humber","East Riding Of Yorkshire",94]
["Yorkshire and the Humber","Kingston Upon Hull",92]
["Yorkshire and the Humber","Kirklees",94]
["Yorkshire and the Humber","Leeds",92]
["Yorkshire and the Humber","North East Lincolnshire",89]
["Yorkshire and the Humber","North Lincolnshire",91]
["Yorkshire and the Humber","North Yorkshire",98]
["Yorkshire and the Humber","Rotherham",90]
["Yorkshire and the Humber","Sheffield",96]
["Yorkshire and the Humber","South Yorkshire",93]
["Yorkshire and the Humber","Wakefield",91]
["Yorkshire and the Humber","West Yorkshire",91]
["Yorkshire and the Humber","York",98]

{"sheet":"GRC Rates","index":16,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Road Classification","HAMFIG Default GRC Rate (£/m2)","HAMFIG Default GRC Rate (£/m2) - Linear Items","Footway Hierarchy","HAMFIG Default GRC Rate (£/m2)","Inflation year","Inflation Rate"]
["M (all)",160.91,715.13,"1A Urban",251.69,"Inflation - Q1 2010 to Q2 2017",1.1549295774647887]
["A Urban",136.04,604.6,"1  Urban",82.35]
["A Rural",107.73,457.98,"1 Rural",74.84]
["B Urban",126.86,554.47,"2 Urban",75.650000000000006]
["B Rural",100.16,255.15,"2 Rural",68.7]
["C Urban",104.7,482.58,"3 Urban",67.44]
["C Rural",79.92,217.98,"3 Rural",61.24]
["U/C Urban",96.69,352.39,"4 Urban",64.75]
["U/C Rural",74.87,166.08,"4 Rural",61.02]
[null,null,null,"Cycleways Bound"]
[null,null,null,"Cycleways Unbound"]

{"sheet":"Land Values","index":17,"n_rows":155,"n_cols":8,"rows_kept":155,"cut":false,"hidden":true,"merged":[]}
["GSS_Code","LA","Ceremonial County","Region","Total Rural Area","Total Urban Area","Rural_per_m2","Urban_per_m2"]
[null,"Pick your Authority",null,"Select a Region",null,null,0,0]
["E06000015","Derby","Derbyshire","East Midlands",279156.81024000002,6927018.9120000014,2.0981999999999998,119.063]
["E10000007","Derbyshire","Derbyshire","East Midlands",33656307.632639997,16320502.34496,2.0981999999999998,118.9586]
["E06000016","Leicester","Leicestershire","East Midlands",158938.81344,7831196.6515200008,2.0981999999999998,179.56720000000001]
["E10000018","Leicestershire","Leicestershire","East Midlands",25578816.975359999,13620039.2064,2.0981999999999998,155.32859999999999]
["E10000019","Lincolnshire","Lincolnshire","East Midlands",68145547.345919997,10660423.403519999,2.0981999999999998,105.5556]
["E10000021","Northamptonshire","Northamptonshire","East Midlands",25297101.30816,13599117.734400002,2.0981999999999998,174.65199999999999]
["E06000018","Nottingham","Nottinghamshire","East Midlands",91925.72928,7630929.8841600008,2.0981999999999998,147.08340000000001]
["E10000024","Nottinghamshire","Nottinghamshire","East Midlands",24474597.776639998,17874372.25728,2.0981999999999998,138.40039999999999]
["E06000017","Rutland","Rutland","East Midlands",4332579.35616,420521.58720000001,2.0981999999999998,181.28389999999999]
["E06000055","Bedford","Bedfordshire","East of England",4772992.4351999993,3106967.3395199999,1.8067,257.63330000000002]
["E06000056","Central Bedfordshire","Bedfordshire","East of England",8386388.1446400005,4142660.6707200008,1.8067,270.84129999999999]
["E06000032","Luton","Bedfordshire","East of England",82752.468479999996,4309935.8860800005,1.8067,236.89080000000001]
["E10000003","Cambridgeshire","Cambridgeshire","East of England",31352322.481920004,8632505.12256,1.9572000000000001,259.38]
["E06000031","Peterborough","Cambridgeshire","East of England",3708894.1823999994,4702261.7664000001,1.8067,187.22669999999999]
["E10000012","Essex","Essex","East of England",42665560.185599998,29003275.699199997,1.8067,352.67619999999999]
["E06000033","Southend-on-Sea","Essex","East of England",48714.842879999997,4362593.6217600005,1.8067,352.67619999999999]
["E06000034","Thurrock","Essex","East of England",1699805.22624,3539848.6886400003,1.8067,392.51690000000002]
["E10000015","Hertfordshire","Hertfordshire","East of England",18375103.54944,26743772.816639997,1.9572000000000001,333.5772]
["E10000020","Norfolk","Norfolk","East of England",72969330.677760005,12762435.882240001,1.9572000000000001,144.23920000000001]
["E10000029","Suffolk","Suffolk","East of England",47260881.043200001,13445554.12992,1.9572000000000001,188.5376]
["E09000002","Barking and Dagenham","Greater London","London",18443.08224,3283995.1795199998,3.1678999999999999,597.08429999999998]
["E09000003","Barnet","Greater London","London",241691.28191999998,7292420.4671999998,3.1678999999999999,601.73910000000001]
["E09000004","Bexley","Greater London","London",149234.46912000002,5286405.3580799997,3.1678999999999999,564.2998]
["E09000005","Brent","Greater London","London",4683.1910399999997,4848985.6588799991,3.1678999999999999,601.73910000000001]
["E09000006","Bromley","Greater London","London",916843.27679999988,7848915.5289599998,3.1678999999999999,564.2998]
["E09000007","Camden","Greater London","London",3283.06176,2901743.7926400006,3.1678999999999999,601.73910000000001]
["E09000001","City of London","Greater London","London",1400.1292800000001,602699.3280000001,3.1678999999999999,672.9162]
["E09000008","Croydon","Greater London","London",134798.65343999999,7572269.2953599999,3.1678999999999999,581.96040000000005]
["E09000009","Ealing","Greater London","London",9849.1852799999979,5834805.4195200009,3.1678999999999999,672.9162]
["E09000010","Enfield","Greater London","London",171008.89344000001,6129862.5484800003,3.1678999999999999,599.75289999999995]
["E09000011","Greenwich","Greater London","London",15884.225279999999,5098546.6329600001,3.1678999999999999,564.2998]
["E09000012","Hackney","Greater London","London",4490.0697600000003,2776826.5113600004,3.1678999999999999,599.75289999999995]
["E09000013","Hammersmith and Fulham","Greater London","London",0,2265489.64224,3.1678999999999999,672.9162]
["E09000014","Haringey","Greater London","London",3041.6601600000004,3567658.1529600006,3.1678999999999999,599.75289999999995]
["E09000015","Harrow","Greater London","London",65564.674559999999,4580708.0140800001,3.1678999999999999,587.23500000000001]
["E09000016","Havering","Greater London","London",585398.88,5648234.1696000006,3.1678999999999999,613.03620000000001]
["E09000017","Hillingdon","Greater London","London",475754.27327999996,6703786.8057600008,3.1678999999999999,721.73479999999995]
["E09000018","Hounslow","Greater London","London",1641.53088,5009340.6950400006,3.1678999999999999,672.9162]
["E09000019","Islington","Greater London","London",2800.2585600000002,2473336.4198400001,3.1678999999999999,599.75289999999995]
["E09000020","Kensington and Chelsea","Greater London","London",1641.53088,2122306.3065599999,3.1678999999999999,672.9162]
["E09000021","Kingston upon Thames","Greater London","London",72806.722559999995,3377707.28064,3.1678999999999999,643.45730000000003]
["E09000022","Lambeth","Greater London","London",25492.008959999999,3788540.6169600007,3.1678999999999999,564.2998]
["E09000023","Lewisham","Greater London","London",6324.721919999999,4434386.4576000003,3.1678999999999999,564.2998]
["E09000024","Merton","Greater London","London",9414.6623999999993,3774072.6144000003,3.1678999999999999,581.96040000000005]
["E09000025","Newham","Greater London","London",0,4174155.5328000002,3.1678999999999999,597.08429999999998]
["E09000026","Redbridge","Greater London","London",116500.41216000001,5157207.2217600001,3.1678999999999999,597.08429999999998]
["E09000027","Richmond upon Thames","Greater London","London",1641.53088,4237177.4438399998,3.1678999999999999,672.9162]
["E09000028","Southwark","Greater London","London",1400.1292800000001,4018837.7433599997,3.1678999999999999,564.2998]
["E09000029","Sutton","Greater London","London",72468.760319999987,4163517.76896,3.1678999999999999,581.96040000000005]
["E09000030","Tower Hamlets","Greater London","London",8883.5788800000009,3054196.9497600002,3.1678999999999999,564.2998]
[null,"Transport for London","Greater London","London",null,null,3.1678999999999999,621.29319999999996]
["E09000031","Waltham Forest","Greater London","London",113844.99456000001,4161361.2480000001,3.1678999999999999,599.75289999999995]
["E09000032","Wandsworth","Greater London","London",0,4337375.2012799997,3.1678999999999999,672.9162]
["E09000033","Westminster","Greater London","London",7966.2528000000002,3534167.70432,3.1678999999999999,672.9162]
["E06000047","County Durham","County Durham","North East",22544398.863360003,9983163.1679999977,1.5094000000000001,104.3091]
["E06000005","Darlington","County Durham","North East",2162765.2147199996,2744816.6591999996,1.5094000000000001,74.037400000000005]
["E06000001","Hartlepool","County Durham","North East",662647.39199999999,3104488.9497600002,1.4,87.452699999999993]
["E06000004","Stockton-on-Tees","County Durham","North East",1651621.46688,6243514.4217600003,1.5094000000000001,86.328000000000003]
["E06000002","Middlesbrough","North Yorkshire","North East",213785.25695999997,4631643.7516800007,1.5094000000000001,86.861999999999995]
["E06000003","Redcar and Cleveland","North Yorkshire","North East",2907730.5523199998,3220104.2227200004,1.5094000000000001,81.652299999999997]
["E06000057","Northumberland","Northumberland","North East",38248586.830080003,6047737.7241599988,1.4,121.0917]
["E08000037","Gateshead","Tyne and Wear","North East",1935171.7862399998,6405929.4182399996,1.4,93.297300000000007]
["E08000021","Newcastle upon Tyne","Tyne and Wear","North East",669503.19744000002,8609201.8214400019,1.4,146.8888]
["E08000022","North Tyneside","Tyne and Wear","North East",775913.02272000001,6836412.844800001,1.4,90.014300000000006]
["E08000023","South Tyneside","Tyne and Wear","North East",508488.33024000004,4834131.4137600008,1.4,80.468800000000002]
["E08000024","Sunderland","Tyne and Wear","North East",1407516.1689599999,9401594.5267199986,1.4,106.0146]
["E06000049","Cheshire East","Cheshire","North West",15729776.536320001,10175978.67264,2.0127999999999999,187.76230000000001]
["E06000050","Cheshire West and Chester","Cheshire","North West",12824701.4016,8481419.9078400005,2.0127999999999999,201.2336]
["E06000006","Halton","Cheshire","North West",791073.04319999996,4715554.9478399996,2.0127999999999999,129.1721]
["E06000007","Warrington","Cheshire","North West",2424010.0262399996,6625797.9955200003,2.0127999999999999,120.12009999999999]
["E10000006","Cumbria","Cumbria","North West",59701560.779520005,8398039.7951999996,1.6851,134.56659999999999]
["E08000001","Bolton","Greater Manchester","North West",1204014.6201599999,8325651.50208,2.0127999999999999,136.58670000000001]
["E08000002","Bury","Greater Manchester","North West",582888.30336000002,5885741.1571199996,2.0127999999999999,142.91839999999999]
["E08000003","Manchester","Greater Manchester","North West",131225.90976000001,13235293.33632,2.0127999999999999,204.66540000000001]
["E08000004","Oldham","Greater Manchester","North West",1337509.7049599998,6523878.2400000002,2.0127999999999999,128.67310000000001]
["E08000005","Rochdale","Greater Manchester","North West",864121.16736000008,6564514.176,2.0127999999999999,130.3057]
["E08000006","Salford","Greater Manchester","North West",267955.77599999995,7420347.2217600001,2.0127999999999999,201.56299999999999]
["E08000007","Stockport","Greater Manchester","North West",762056.57088000001,8787452.7628799994,2.0127999999999999,196.32640000000001]
["E08000008","Tameside","Greater Manchester","North West",545374.49471999996,6742636.3699200004,1.8489,174.3837]
["E08000009","Trafford","Greater Manchester","North West",592399.52640000009,7159263.3446400007,1.8489,158.124]
["E08000010","Wigan","Greater Manchester","North West",1605706.8825599998,9485248.2278399989,1.8489,116.69450000000001]
["E06000008","Blackburn with Darwen","Lancashire","North West",1010313.97632,4216078.9440000001,2.0127999999999999,117.10209999999999]
["E06000009","Blackpool","Lancashire","North West",71358.31296000001,4457062.1145599997,2.0596000000000001,130.44560000000001]
["E10000017","Lancashire","Lancashire","North West",31380663.029759999,30963183.10272,2.0596000000000001,130.44560000000001]
["E08000011","Knowsley","Merseyside","North West",828924.81407999992,4702680.1958400011,1.7319,85.312100000000001]
["E08000012","Liverpool","Merseyside","North West",175112.72063999998,13933169.268480001,1.7319,85.312100000000001]
["E08000014","Sefton","Merseyside","North West",1016880.09984,8436100.7807999998,1.7319,83.399900000000002]
["E08000013","St Helens","Merseyside","North West",1673589.01248,5266674.80064,1.7319,86.229100000000003]
["E08000015","Wirral","Merseyside","North West",1080030.7584000002,10546996.838400001,1.8489,57.793799999999997]
["E06000036","Bracknell Forest","Berkshire","South East",1169928.7142400001,3274323.02208,2.2362000000000002,320.75240000000002]
["E06000038","Reading","Berkshire","South East",116403.85152,3743543.3587199999,2.2362000000000002,282.06729999999999]
["E06000039","Slough","Berkshire","South East",177092.21376000001,2772095.04,2.2362000000000002,307.51010000000002]
["E06000037","West Berkshire","Berkshire","South East",8815889.8713600002,3052507.1385599999,2.2362000000000002,260.98020000000002]
["E06000040","Windsor and Maidenhead","Berkshire","South East",2221474.08384,4185227.8195200004,2.2362000000000002,487.04899999999998]
["E06000041","Wokingham","Berkshire","South East",2611289.3875199999,4462614.3513600007,2.2362000000000002,342.52589999999998]
["E10000002","Buckinghamshire","Buckinghamshire","South East",18875046.263039999,10058818.429439999,2.2362000000000002,385.4948]
["E06000042","Milton Keynes","Buckinghamshire","South East",2669370.6124799997,8503709.3222400006,2.2362000000000002,251.21]
["E10000011","East Sussex","East Sussex","South East",18490928.03712,11886920.559360001,1.8634999999999999,286.7029]
["E10000014","Hampshire","Hampshire","South East",44008815.248640001,33883643.566080004,2.2362000000000002,266.77390000000003]
["E06000046","Isle of Wight","Hampshire","South East",5370895.9180799993,2790264.5337600005,2.2362000000000002,266.77390000000003]
["E06000044","Portsmouth","Hampshire","South East",142088.98176,4283864.5132800005,2.2362000000000002,198.74199999999999]
["E06000045","Southampton","Hampshire","South East",36548.202239999999,5634586.93248,2.2362000000000002,185.35980000000001]
["E10000016","Kent","Kent","South East",49057922.833920002,29226218.123520002,2.2362000000000002,282.54230000000001]
["E06000035","Medway","Kent","South East",1945310.65344,5985279.0835200008,2.2362000000000002,293.47910000000002]
["E10000025","Oxfordshire","Oxfordshire","South East",30634442.403839998,11196994.786560001,2.2362000000000002,315.8707]
["E10000030","Surrey","Surrey","South East",18964895.938560002,31523331.375359997,2.2362000000000002,464.57260000000002]
["E06000043","Brighton and Hove","Sussex","South East",326181.84191999998,5616272.5977600003,2.2362000000000002,291.92430000000002]
["E10000032","West Sussex","West Sussex","South East",20769034.936319999,17234545.363200001,2.2362000000000002,336.09179999999998]
["E06000052","Cornwall","Cornwall","South West",56648023.660799995,5776337.9519999996,2.1892999999999998,175.58860000000001]
["E06000053","Isles of Scilly","Cornwall","South West",312277.10976000002,0,2.1892999999999998,175.58860000000001]
["E10000008","Devon","Devon","South West",99689590.978560001,9856185.9263999984,2.1137999999999999,163.5428]
["E06000026","Plymouth","Devon","South West",324347.18975999998,7341779.0476799998,2.1892999999999998,156.5334]
["E06000027","Torbay","Devon","South West",664820.00640000007,4341849.1776000001,2.1137999999999999,163.5428]
["E06000028","Bournemouth","Dorset","South West",95595.033599999995,4875057.0316799991,2.1137999999999999,187.08690000000001]
["E10000009","Dorset","Dorset","South West",28701346.671360001,8876481.6729600001,2.1137999999999999,187.08690000000001]
["E06000029","Poole","Dorset","South West",324540.31103999994,4849210.9670400005,2.1137999999999999,169.35509999999999]
["E10000013","Gloucestershire","Gloucestershire","South West",34612692.491520002,14152909.098240001,2.1137999999999999,144.48509999999999]
["E06000025","South Gloucestershire","Gloucestershire","South West",6202958.9529600004,7140997.2902400009,2.0131000000000001,204.47630000000001]
["E06000022","Bath and North East Somerset","Somerset","South West",5595061.4438399998,4009809.3235200001,2.1389999999999998,205.5104]
["E06000023","Bristol","Somerset","South West",273556.29312000005,10860786.731520001,2.1892999999999998,190.29599999999999]
["E06000024","North Somerset","Somerset","South West",5425838.9222400002,4825135.1808000002,2.1892999999999998,193.76509999999999]
["E10000027","Somerset","Somerset","South West",50406971.535360001,7746400.316159999,2.1892999999999998,181.73949999999999]
["E06000030","Swindon","Wiltshire","South West",2485760.5555199999,5593661.3145600008,2.1137999999999999,169.01759999999999]
["E06000054","Wiltshire","Wiltshire","South West",33739977.427199997,7457410.4140799996,2.1137999999999999,154.6292]
["E06000019","Herefordshire","Herefordshire","West Midlands",26171699.304960001,2665218.50496,2.3388,177.9873]
["E06000051","Shropshire","Shropshire","West Midlands",40484979.532800004,3927491.3779199999,2.1636000000000002,150.14019999999999]
["E06000020","Telford and Wrekin","Shropshire","West Midlands",3794302.0684799999,5632462.5984000005,2.3388,135.03139999999999]
["E10000028","Staffordshire","Staffordshire","West Midlands",34853321.606399998,20407865.955839999,2.4211999999999998,157.87610000000001]
["E06000021","Stoke-on-Trent","Staffordshire","West Midlands",302572.76543999999,8135362.6675199997,2.4211999999999998,118.6692]
["E10000031","Warwickshire","Warwickshire","West Midlands",24221560.619520001,11043608.20992,2.3439000000000001,225.57040000000001]
["E08000025","Birmingham","West Midlands","West Midlands",345831.93215999997,24481485.768960007,2.2924000000000002,192.18450000000001]
["E08000026","Coventry","West Midlands","West Midlands",450938.1888,8008498.0800000001,2.4211999999999998,153.0659]
["E08000027","Dudley","West Midlands","West Midlands",242946.57024,9803624.751360001,2.4211999999999998,141.42580000000001]
["E08000028","Sandwell","West Midlands","West Midlands",9318.1017599999996,8691133.5244800001,2.4211999999999998,158.97579999999999]
["E08000029","Solihull","West Midlands","West Midlands",2298143.2319999998,5639093.0956800012,2.4211999999999998,262.3134]
["E08000030","Walsall","West Midlands","West Midlands",544505.44896000007,7835638.4409599993,2.4211999999999998,121.2941]
["E08000031","Wolverhampton","West Midlands","West Midlands",49052.805120000005,7468885.0367999999,2.4211999999999998,120.5814]
["E10000034","Worcestershire","Worcestershire","West Midlands",24461755.211520001,13025837.21472,2.0348000000000002,204.81639999999999]
["E06000011","East Riding of Yorkshire","East Riding of Yorkshire","Yorkshire and the Humber",25261518.71232,4636568.3443200001,1.8557999999999999,119.6477]
["E06000010","Kingston upon Hull","East Riding of Yorkshire","Yorkshire and the Humber",105444.21888,6936208.2662400007,1.8557999999999999,121.32380000000001]
["E06000012","North East Lincolnshire","Lincolnshire","Yorkshire and the Humber",1583063.4124799999,4467217.0752000008,1.9733000000000001,86.382099999999994]
["E06000013","North Lincolnshire","Lincolnshire","Yorkshire and the Humber",9640807.4188800007,2635397.3606400001,1.9733000000000001,86.935400000000001]
["E10000023","North Yorkshire","North Yorkshire","Yorkshire and the Humber",70598042.760959998,8341294.3257599995,1.8557999999999999,119.0568]
["E06000014","York","North Yorkshire","Yorkshire and the Humber",2914682.9183999998,4275656.8588800002,2.1377000000000002,152.4187]
["E08000016","Barnsley","South Yorkshire","Yorkshire and the Humber",4299410.7763199992,6719461.8163200002,1.9733000000000001,90.731099999999998]
["E08000017","Doncaster","South Yorkshire","Yorkshire and the Humber",6175004.6476799995,8597469.7036800012,1.6209,110.0821]
["E08000018","Rotherham","South Yorkshire","Yorkshire and the Humber",3271184.8012800002,7882341.6038400009,1.6209,116.3528]
["E08000019","Sheffield","South Yorkshire","Yorkshire and the Humber",3041129.0764799993,15996106.874880001,1.6209,144.23990000000001]
["E08000032","Bradford","West Yorkshire","Yorkshire and the Humber",4204153.7049599998,14039482.533119999,1.8557999999999999,95.957499999999996]
["E08000033","Calderdale","West Yorkshire","Yorkshire and the Humber",4431505.7318399996,6298875.8553599995,1.7383999999999999,94.139899999999997]
["E08000034","Kirklees","West Yorkshire","Yorkshire and the Humber",5479961.16096,12377850.946560003,1.8557999999999999,95.018500000000003]
["E08000035","Leeds","West Yorkshire","Yorkshire and the Humber",5238945.8035200005,23029294.210560001,1.8557999999999999,188.65539999999999]
["E08000036","Wakefield","West Yorkshire","Yorkshire and the Humber",4763191.5302400002,9381944.4364800006,1.8557999999999999,94.250100000000003]

{"sheet":"List","index":18,"n_rows":215,"n_cols":14,"rows_kept":215,"cut":false,"hidden":true,"merged":[]}
["Region Unique","Region","Authority - Carriageway","Select a Region","Region","Pick your Authority","Ceremonial County","Pick a Data Category","StreetLighting","IlluminatedSigns","TrafficSignals","Crossings","InfoSystems","InStations"]
["Select_a_Region","Select an Authority","Select an Authority","Select_a_Region","East Midlands","Derby","Derbyshire","Actual Inventory","Please select from list or type a description","Please select from list or type a description","Please select from list or type a description","Please select from list or type a description","Please select from list or type a description","Please select from list or type a description"]
["South_East","East Midlands","Derby","South_East","East Midlands","Derbyshire","Derbyshire","Sample Inventory","Steel Streetlights","Circular 600mm Aluminium 1 Post","Poles","Puffin Crossing","Real Time Passenger Information (display and remote comms)","UTC"]
["London","East Midlands","Derbyshire","London","East Midlands","Leicester","Leicestershire","Estimated Values","Concrete Streetlights ","Circular 750mm Aluminium 1 Post","RAG head halogen","Pelican Crossing","Real Time Passenger Information (bus fits)","UTMC common database"]
["North_East","East Midlands","Leicester","North_East","East Midlands","Leicestershire","Leicestershire","Combination","Other Types of Streetlights (i.e. Bracketed)","Circular 900mm Aluminium 2 Posts","RAG head LED","Toucan Crossing","Variable Message Signs - 50-100mmm x-height","RTPI central server"]
["South_West","East Midlands","Leicestershire","South_West","East Midlands","Lincolnshire","Lincolnshire",null,"Columns up to 6.0m","Circular 1200mm Aluminium 2 Posts","Loop","Pegasus Crossing","Variable Message Signs - 101-175mmm x-height","RTPI bus depot computer instation"]
["West_Midlands","East Midlands","Lincolnshire","West_Midlands","East Midlands","Northamptonshire","Northamptonshire",null,"Columns up to 8.0m","Circular 1500mm Aluminium 2 Posts","MVD Veh","Zebra Crossing","Variable Message Signs - 176-225mmm x-height","ANPR"]
["Yorkshire_and_the_Humber","East Midlands","Northamptonshire","Yorkshire_and_the_Humber","East Midlands","Nottingham","Nottinghamshire",null,"Columns up to 10.0m","Triangular 600mm Aluminium 1 Post","IRs","School Crossing (flashing amber lights per sign)","Vehicle Activated Signs - (VAS)","VMS"]
["East_Midlands","East Midlands","Nottingham","East_Midlands","East Midlands","Nottinghamshire","Nottinghamshire",null,"Columns up to 12.0m","Triangular 750mm Aluminium 1 Post","MVD Ped","Equestrian Crossing","Safety and Speed Camera Equipment"]
["East_of_England","East Midlands","Nottinghamshire","East_of_England","East Midlands","Rutland","Rutland",null,"Subway Units","Triangular 900mm Aluminium 2 Posts","P Head Halogen","Wig Wags","CCTV (including posts)"]
["Scotland","East Midlands","Rutland","North_West","East of England","Bedford","Bedfordshire",null,"Heritage columns ","Triangular 1200mm Aluminium 2 Posts","P Indicator LED","Camera - TRUVELO","Car Park Monitoring Systems"]
["Wales","East of England","Bedford",null,"East of England","Central Bedfordshire","Bedfordshire",null,"Feeder Pillar Small","Triangular 1500mm Aluminium 2 Posts","W Lamp Tungsten","Camera - GATSO"]
["North_West","East of England","Cambridgeshire",null,"East of England","Luton","Bedfordshire",null,"Feeder Pillar Medium","Rectangular >0.25sq m but < 0.5sq m Alum 1 Post\n","W Lamp LED","Fixed EMS/VMS Signs"]
[null,"East of England","Central Bedfordshire",null,"East of England","Cambridgeshire","Cambridgeshire",null,"Feeder Pillar Large","Rectangular >0.5sq m but < 1.2sq m Alum 1 Post\n","MOVA","Mobile EMS/VMS Signs"]
[null,"East of England","Essex",null,"East of England","Peterborough","Cambridgeshire",null,"Illuminated Bollards","Rectangular >1.2sq m but < 2.0sq m Alum 2 Posts\n",null,"Bridge Height EMS Signs"]
[null,"East of England","Hertfordshire",null,"East of England","Essex","Essex",null,null,"Rectangular >2.0sq m but < 5.0sq m Alum 3 Posts\n",null,"Road Junction"]
[null,"East of England","Luton",null,"East of England","Southend-on-Sea","Essex",null,null,"Rectangular >5.0sq m but < 10.0sq m Alum 3 Posts\n"]
[null,"East of England","Norfolk",null,"East of England","Thurrock","Essex"]
[null,"East of England","Peterborough",null,"East of England","Hertfordshire","Hertfordshire"]
[null,"East of England","Southend-On-Sea",null,"East of England","Norfolk","Norfolk"]
[null,"East of England","Suffolk",null,"East of England","Suffolk","Suffolk"]
[null,"East of England","Thurrock",null,"London","Barking and Dagenham","Greater London"]
[null,"Greater London","Barking And Dagenham",null,"London","Barnet","Greater London"]
[null,"Greater London","Barnet",null,"London","Bexley","Greater London"]
[null,"Greater London","Bexley",null,"London","Brent","Greater London"]
[null,"Greater London","Brent",null,"London","Bromley","Greater London"]
[null,"Greater London","Bromley",null,"London","Camden","Greater London"]
[null,"Greater London","Camden",null,"London","City of London","Greater London"]
[null,"Greater London","City Of London",null,"London","Croydon","Greater London"]
[null,"Greater London","Croydon",null,"London","Ealing","Greater London"]
[null,"Greater London","Ealing",null,"London","Enfield","Greater London"]
[null,"Greater London","Enfield",null,"London","Greenwich","Greater London"]
[null,"Greater London","Greater London",null,"London","Hackney","Greater London"]
[null,"Greater London","Greenwich",null,"London","Hammersmith and Fulham","Greater London"]
[null,"Greater London","Hackney",null,"London","Haringey","Greater London"]
[null,"Greater London","Hammersmith And Fulham",null,"London","Harrow","Greater London"]
[null,"Greater London","Haringey",null,"London","Havering","Greater London"]
[null,"Greater London","Harrow",null,"London","Hillingdon","Greater London"]
[null,"Greater London","Havering",null,"London","Hounslow","Greater London"]
[null,"Greater London","Hillingdon",null,"London","Islington","Greater London"]
[null,"Greater London","Hounslow",null,"London","Kensington and Chelsea","Greater London"]
[null,"Greater London","Islington",null,"London","Kingston upon Thames","Greater London"]
[null,"Greater London","Kensington And Chelsea",null,"London","Lambeth","Greater London"]
[null,"Greater London","Kingston Upon Thames",null,"London","Lewisham","Greater London"]
[null,"Greater London","Lambeth",null,"London","Merton","Greater London"]
[null,"Greater London","Lewisham",null,"London","Newham","Greater London"]
[null,"Greater London","Merton",null,"London","Redbridge","Greater London"]
[null,"Greater London","Newham",null,"London","Richmond upon Thames","Greater London"]
[null,"Greater London","Redbridge",null,"London","Southwark","Greater London"]
[null,"Greater London","Richmond Upon Thames",null,"London","Sutton","Greater London"]
[null,"Greater London","Southwark",null,"London","Tower Hamlets","Greater London"]
[null,"Greater London","Sutton",null,"London","Transport for London","Greater London"]
[null,"Greater London","Tower Hamlets",null,"London","Waltham Forest","Greater London"]
[null,"Greater London","Transport for London",null,"London","Wandsworth","Greater London"]
[null,"Greater London","Waltham Forest",null,"London","Westminster","Greater London"]
[null,"Greater London","Wandsworth",null,"North East England","County Durham","County Durham"]
[null,"Greater London","Westminster",null,"North East England","Darlington","County Durham"]
[null,"North East","County Durham",null,"North East England","Hartlepool","County Durham"]
[null,"North East","Darlington",null,"North East England","Stockton-on-Tees","County Durham"]
[null,"North East","Gateshead",null,"North East England","Middlesbrough","North Yorkshire"]
[null,"North East","Hartlepool",null,"North East England","Redcar and Cleveland","North Yorkshire"]
[null,"North East","Middlesbrough",null,"North East England","Northumberland","Northumberland"]
[null,"North East","Newcastle Upon Tyne",null,"North East England","Gateshead","Tyne and Wear"]
[null,"North East","North Tyneside",null,"North East England","Newcastle upon Tyne","Tyne and Wear"]
[null,"North East","Northumberland",null,"North East England","North Tyneside","Tyne and Wear"]
[null,"North East","Redcar And Cleveland",null,"North East England","South Tyneside","Tyne and Wear"]
[null,"North East","South Tyneside",null,"North East England","Sunderland","Tyne and Wear"]
[null,"North East","Stockton-On-Tees",null,"North West England","Cheshire East","Cheshire"]
[null,"North East","Sunderland",null,"North West England","Cheshire West and Chester","Cheshire"]
[null,"North East","Tyne And Wear",null,"North West England","Halton","Cheshire"]
[null,"North West","Blackburn With Darwen",null,"North West England","Warrington","Cheshire"]
[null,"North West","Blackpool",null,"North West England","Cumbria","Cumbria"]
[null,"North West","Bolton",null,"North West England","Bolton","Greater Manchester"]
[null,"North West","Bury",null,"North West England","Bury","Greater Manchester"]
[null,"North West","Cheshire East",null,"North West England","Manchester","Greater Manchester"]
[null,"North West","Cheshire West And Chester",null,"North West England","Oldham","Greater Manchester"]
[null,"North West","Cumbria",null,"North West England","Rochdale","Greater Manchester"]
[null,"North West","Greater Manchester",null,"North West England","Salford","Greater Manchester"]
[null,"North West","Halton",null,"North West England","Stockport","Greater Manchester"]
[null,"North West","Knowsley",null,"North West England","Tameside","Greater Manchester"]
[null,"North West","Lancashire",null,"North West England","Trafford","Greater Manchester"]
[null,"North West","Liverpool",null,"North West England","Wigan","Greater Manchester"]
[null,"North West","Manchester",null,"North West England","Blackburn with Darwen","Lancashire"]
[null,"North West","Merseyside",null,"North West England","Blackpool","Lancashire"]
[null,"North West","Oldham",null,"North West England","Lancashire","Lancashire"]
[null,"North West","Rochdale",null,"North West England","Knowsley","Merseyside"]
[null,"North West","Salford",null,"North West England","Liverpool","Merseyside"]
[null,"North West","Sefton",null,"North West England","Sefton","Merseyside"]
[null,"North West","St Helens",null,"North West England","St Helens","Merseyside"]
[null,"North West","Stockport",null,"North West England","Wirral","Merseyside"]
[null,"North West","Tameside",null,"South East England","Bracknell Forest","Berkshire"]
[null,"North West","Trafford",null,"South East England","Reading","Berkshire"]
[null,"North West","Warrington",null,"South East England","Slough","Berkshire"]
[null,"North West","Wigan",null,"South East England","West Berkshire","Berkshire"]
[null,"North West","Wirral",null,"South East England","Windsor and Maidenhead","Berkshire"]
[null,"Scotland","Aberdeen City",null,"South East England","Wokingham","Berkshire"]
[null,"Scotland","Aberdeenshire",null,"South East England","Buckinghamshire","Buckinghamshire"]
[null,"Scotland","Angus",null,"South East England","Milton Keynes","Buckinghamshire"]
[null,"Scotland","Argyll And Bute",null,"South East England","East Sussex","East Sussex"]
[null,"Scotland","City Of Edinburgh",null,"South East England","Hampshire","Hampshire"]
[null,"Scotland","Clackmannanshire",null,"South East England","Isle of Wight","Hampshire"]
[null,"Scotland","Dumfries And Galloway",null,"South East England","Portsmouth","Hampshire"]
[null,"Scotland","Dundee City",null,"South East England","Southampton","Hampshire"]
[null,"Scotland","East Ayrshire",null,"South East England","Kent","Kent"]
[null,"Scotland","East Dunbartonshire",null,"South East England","Medway","Kent"]
[null,"Scotland","East Lothian",null,"South East England","Oxfordshire","Oxfordshire"]
[null,"Scotland","East Renfrewshire",null,"South East England","Surrey","Surrey"]
[null,"Scotland","Eilean Siar",null,"South East England","Brighton and Hove","Sussex"]
[null,"Scotland","Falkirk",null,"South East England","West Sussex","West Sussex"]
[null,"Scotland","Fife",null,"South West England","Cornwall","Cornwall"]
[null,"Scotland","Glasgow City",null,"South West England","Isles of Scilly","Cornwall"]
[null,"Scotland","Highland",null,"South West England","Devon","Devon"]
[null,"Scotland","Inverclyde",null,"South West England","Plymouth","Devon"]
[null,"Scotland","Midlothian",null,"South West England","Torbay","Devon"]
[null,"Scotland","Moray",null,"South West England","Bournemouth","Dorset"]
[null,"Scotland","North Ayrshire",null,"South West England","Dorset","Dorset"]
[null,"Scotland","North Lanarkshire",null,"South West England","Poole","Dorset"]
[null,"Scotland","Orkney Islands",null,"South West England","Gloucestershire","Gloucestershire"]
[null,"Scotland","Perth And Kinross",null,"South West England","South Gloucestershire","Gloucestershire"]
[null,"Scotland","Renfrewshire",null,"South West England","Bath and North East Somerset","Somerset"]
[null,"Scotland","Scottish Borders",null,"South West England","Bristol","Somerset"]
[null,"Scotland","Shetland Islands",null,"South West England","North Somerset","Somerset"]
[null,"Scotland","South Ayrshire",null,"South West England","Somerset","Somerset"]
[null,"Scotland","South Lanarkshire",null,"South West England","Swindon","Wiltshire"]
[null,"Scotland","Stirling",null,"South West England","Wiltshire","Wiltshire"]
[null,"Scotland","West Dunbartonshire",null,"West Midlands","Herefordshire","Herefordshire"]
[null,"Scotland","West Lothian",null,"West Midlands","Shropshire","Shropshire"]
[null,"South East","Bracknell Forest",null,"West Midlands","Telford and Wrekin","Shropshire"]
[null,"South East","Brighton And Hove",null,"West Midlands","Staffordshire","Staffordshire"]
[null,"South East","Buckinghamshire",null,"West Midlands","Stoke-on-Trent","Staffordshire"]
[null,"South East","East Sussex",null,"West Midlands","Warwickshire","Warwickshire"]
[null,"South East","Hampshire",null,"West Midlands","Birmingham","West Midlands"]
[null,"South East","Isle Of Wight",null,"West Midlands","Coventry","West Midlands"]
[null,"South East","Kent",null,"West Midlands","Dudley","West Midlands"]
[null,"South East","Medway",null,"West Midlands","Sandwell","West Midlands"]
[null,"South East","Milton Keynes",null,"West Midlands","Solihull","West Midlands"]
[null,"South East","Oxfordshire",null,"West Midlands","Walsall","West Midlands"]
[null,"South East","Portsmouth",null,"West Midlands","Wolverhampton","West Midlands"]
[null,"South East","Reading",null,"West Midlands","Worcestershire","Worcestershire"]
[null,"South East","Slough",null,"Yorkshire and the Humber","East Riding of Yorkshire","East Riding of Yorkshire"]
[null,"South East","Southampton",null,"Yorkshire and the Humber","Kingston upon Hull","East Riding of Yorkshire"]
[null,"South East","Surrey",null,"Yorkshire and the Humber","North East Lincolnshire","Lincolnshire"]
[null,"South East","West Berkshire",null,"Yorkshire and the Humber","North Lincolnshire","Lincolnshire"]
[null,"South East","West Sussex",null,"Yorkshire and the Humber","North Yorkshire","North Yorkshire"]
[null,"South East","Windsor And Maidenhead",null,"Yorkshire and the Humber","York","North Yorkshire"]
[null,"South East","Wokingham",null,"Yorkshire and the Humber","Barnsley","South Yorkshire"]
[null,"South West","Bath And North East Somerset",null,"Yorkshire and the Humber","Doncaster","South Yorkshire"]
[null,"South West","Bournemouth",null,"Yorkshire and the Humber","Rotherham","South Yorkshire"]
[null,"South West","Bristol",null,"Yorkshire and the Humber","Sheffield","South Yorkshire"]
[null,"South West","Cornwall",null,"Yorkshire and the Humber","Bradford","West Yorkshire"]
[null,"South West","Devon",null,"Yorkshire and the Humber","Calderdale","West Yorkshire"]
[null,"South West","Dorset",null,"Yorkshire and the Humber","Kirklees","West Yorkshire"]
[null,"South West","Gloucestershire",null,"Yorkshire and the Humber","Leeds","West Yorkshire"]
[null,"South West","North Somerset",null,"Yorkshire and the Humber","Wakefield","West Yorkshire"]
[null,"South West","Plymouth"]
[null,"South West","Poole"]
[null,"South West","Somerset"]
[null,"South West","South Gloucestershire"]
[null,"South West","Swindon"]
[null,"South West","Torbay"]
[null,"South West","Wiltshire"]
[null,"Wales","Blaenau Gwent"]
[null,"Wales","Bridgend"]
[null,"Wales","Caerphilly"]
[null,"Wales","Cardiff"]
[null,"Wales","Carmarthenshire"]
[null,"Wales","Ceredigion"]
[null,"Wales","Conwy"]
[null,"Wales","Denbighshire"]
[null,"Wales","Flintshire"]
[null,"Wales","Gwynedd"]
[null,"Wales","Isle Of Anglesey"]
[null,"Wales","Merthyr Tydfil"]
[null,"Wales","Monmouthshire"]
[null,"Wales","Neath Port Talbot"]
[null,"Wales","Newport"]
[null,"Wales","Pembrokeshire"]
[null,"Wales","Powys"]
[null,"Wales","Rhondda Cynon Taf"]
[null,"Wales","Swansea"]
[null,"Wales","Torfaen"]
[null,"Wales","Vale Of Glamorgan"]
[null,"Wales","Wrexham"]
[null,"West Midlands","Birmingham"]
[null,"West Midlands","Coventry"]
[null,"West Midlands","Dudley"]
[null,"West Midlands","Herefordshire"]
[null,"West Midlands","Sandwell"]
[null,"West Midlands","Shropshire"]
[null,"West Midlands","Solihull"]
[null,"West Midlands","Staffordshire"]
[null,"West Midlands","Stoke-On-Trent"]
[null,"West Midlands","Telford And Wrekin"]
[null,"West Midlands","Walsall"]
[null,"West Midlands","Warwickshire"]
[null,"West Midlands","West Midlands"]
[null,"West Midlands","Wolverhampton"]
[null,"West Midlands","Worcestershire"]
[null,"Yorkshire and the Humber","Barnsley"]
[null,"Yorkshire and the Humber","Bradford"]
[null,"Yorkshire and the Humber","Calderdale"]
[null,"Yorkshire and the Humber","Doncaster"]
[null,"Yorkshire and the Humber","East Riding Of Yorkshire"]
[null,"Yorkshire and the Humber","Kingston Upon Hull"]
[null,"Yorkshire and the Humber","Kirklees"]
[null,"Yorkshire and the Humber","Leeds"]
[null,"Yorkshire and the Humber","North East Lincolnshire"]
[null,"Yorkshire and the Humber","North Lincolnshire"]
[null,"Yorkshire and the Humber","North Yorkshire"]
[null,"Yorkshire and the Humber","Rotherham"]
[null,"Yorkshire and the Humber","Sheffield"]
[null,"Yorkshire and the Humber","South Yorkshire"]
[null,"Yorkshire and the Humber","Wakefield"]
[null,"Yorkshire and the Humber","West Yorkshire"]
[null,"Yorkshire and the Humber","York"]