{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Pro-Forma"],"not_rendered":{"macros":1,"external_links":1,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Pro-Forma","index":0,"n_rows":89,"n_cols":192,"rows_kept":89,"merged":[[2,1,2,2],[2,3,2,5],[4,7,4,18],[5,1,13,1],[5,2,7,2],[5,20,7,20],[5,21,7,21],[8,2,10,2],[8,20,10,20],[8,21,10,21],[11,2,13,2],[11,20,13,20],[11,21,13,21],[14,1,16,1],[14,2,16,2],[14,20,16,20],[14,21,16,21],[17,1,19,1],[17,2,19,2],[17,20,19,20],[17,21,19,21],[20,1,22,1],[20,2,22,2],[20,20,22,20],[20,21,22,21],[23,1,25,1],[23,2,25,2],[23,20,25,20],[23,21,25,21],[26,1,28,1],[26,2,28,2],[26,20,28,20],[26,21,28,21],[29,1,31,1],[29,2,31,2],[29,20,31,20],[29,21,31,21]],"flags":["formulas_cached_only"]}
[null,"APR Core Indicators Pro-Forma"]
[]
[null,"Select your LA from the drop down list (Click in yellow box and use the drop down arrow).",{"$nulls":188},"C","Yes"]
[{"$nulls":190},"F","No"]
[null,"Core Indicator","Definitions",null,"Year","Value","Year Type3 (Enter C for Calendar Year and F for Financial Year)","Actual and Trajectory Data2",{"$nulls":11},"Is your LA on track to meet its target for this core indicator?","Please indicate if your reported or target figures have changed since you previously reported.","Please outline the methodology and source of data used to calculate your figures. Also include any other relevant information.",{"$nulls":169},"No Clear Evidence"]
[null,"Road Condition (% where structural maintenance should be considered)4","(1) principal roads - BV96","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","",""]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"List of LAs"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Bath & North-East Somerset"]
[null,null,"(2) non-principal roads - BV97a","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Bedfordshire"]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Blackburn and Darwen"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Blackpool"]
[null,null,"(3) unclassified roads - BV97b","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Bournemouth, Poole and Christchurch (Joint Plan)"]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Bracknell Forest"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Brighton & Hove"]
[null,"Number of bus passenger journeys5","Thousands of bus passenger journeys (i.e. boardings) per year in the authority - BV102","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Bristol City"]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Buckinghamshire"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Cambridgeshire"]
[null,"Number of cycling trips","Number of cycling trips across the authority or number of cycling trips at a representative number of counting points (please state which)","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Cumbria"]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Darlington"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Derby Joint Plan"]
[null,"Number of deaths and serious injuries (all ages)6","Number of people killed or seriously injured on roads in the authority","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Derbyshire "]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Devon "]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Dorset "]
[null,"Number of children killed and seriously injured6","Number of children (aged less than 16) killed or seriously injured in the authority","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Durham "]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"East Riding of Yorkshire"]
[{"$nulls":3},"Units\n",{"$nulls":3},"Trajectories",{"$nulls":180},"East Sussex "]
[null,"Light rail passenger journeys7","Thousands of light rail passengers per year","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Essex "]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Gloucestershire"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Greater Manchester (Joint Plan)"]
[null,"% of rural households within 13 minutes walk of an hourly or better bus service7","% of rural9 households within 13 minutes walk of an hourly or better bus service or % of rural8 households within 800 metres of an hourly or better bus service (please state which)","\nBase Data1",{"$nulls":3},"Year","","","","","","","","","","","",{"$nulls":169},"Greater Nottingham (Joint Plan)"]
[{"$nulls":3},"\nTarget Data2",{"$nulls":3},"Actual Figures",{"$nulls":180},"Halton"]
[{"$nulls":3},"Units",{"$nulls":3},"Trajectories",{"$nulls":180},"Hampshire"]
[{"$nulls":188},"Hartlepool"]
[null,"NB - Please refer to section 10 of the guidance for descriptions of footnotes.",{"$nulls":186},"Herefordshire"]
[{"$nulls":188},"Hertfordshire"]
[{"$nulls":188},"Isle of Wight"]
[{"$nulls":188},"Kent"]
[{"$nulls":188},"Kingston-upon-Hull"]
[{"$nulls":188},"Lancashire"]
[{"$nulls":188},"Leicestershire"]
[{"$nulls":188},"Lincolnshire"]
[{"$nulls":188},"Luton and Dunstable (Joint Plan)"]
[{"$nulls":188},"Medway"]
[{"$nulls":188},"Merseyside (Joint Plan)"]
[{"$nulls":188},"Middlesborough"]
[{"$nulls":188},"Milton Keynes"]
[{"$nulls":188},"Norfolk"]
[{"$nulls":188},"Northamptonshire"]
[{"$nulls":188},"North-East Lincolnshire"]
[{"$nulls":188},"North Lincolnshire"]
[{"$nulls":188},"North Nottinghamshire"]
[{"$nulls":188},"North Somerset"]
[{"$nulls":188},"North Yorkshire"]
[{"$nulls":188},"Northumberland"]
[{"$nulls":188},"Oxfordshire"]
[{"$nulls":188},"Peterborough"]
[{"$nulls":188},"Plymouth"]
[{"$nulls":188},"Portsmouth"]
[{"$nulls":188},"Reading"]
[{"$nulls":188},"Redcar & Cleveland"]
[{"$nulls":188},"Rutland"]
[{"$nulls":188},"Shropshire"]
[{"$nulls":188},"Slough"]
[{"$nulls":188},"Somerset"]
[{"$nulls":188},"South Gloucestershire"]
[{"$nulls":188},"South Yorkshire (Joint Plan)"]
[{"$nulls":188},"Southampton"]
[{"$nulls":188},"Southend-on-Sea"]
[{"$nulls":188},"Staffordshire"]
[{"$nulls":188},"Stockton-on-Tees"]
[{"$nulls":188},"Stoke on Trent"]
[{"$nulls":188},"Suffolk"]
[{"$nulls":188},"Surrey"]
[{"$nulls":188},"Swindon"]
[{"$nulls":188},"Telford & Wrekin"]
[{"$nulls":188},"Thurrock"]
[{"$nulls":188},"Torbay"]
[{"$nulls":188},"Tyne & Wear (Joint Plan)"]
[{"$nulls":188},"Warrington"]
[{"$nulls":188},"Warwickshire"]
[{"$nulls":188},"West Berkshire"]
[{"$nulls":188},"West Midlands (Joint Plan)"]
[{"$nulls":188},"West Sussex"]
[{"$nulls":188},"West Yorkshire (Joint Plan)"]
[{"$nulls":188},"Wiltshire"]
[{"$nulls":188},"Windsor & Maidenhead"]
[{"$nulls":188},"Wokingham"]
[{"$nulls":188},"Worcestershire"]
[{"$nulls":188},"York City"]