{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["README","Concentrations","Property Counts","Summary","Worksheets","Master"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"README","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Local Air Quality Assessment Workbook"]
[]
["TAG Reference"]
["TAG Unit A3 - Environmental Impact Appraisal "]
[]
["Version Control"]
["Date","Description"]
["2019-05-01","Changed PM10 to PM2.5 to align with Defra guidance on concentration-based measurement."]
["2014-01-01","Definitive release"]
["2013-10-17","Release of restructured guidance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Contact"]
["Transport Appraisal and Strategic Modelling (TASM) Division"]
["Department for Transport"]
["Zone 2/25 Great Minster House"]
["33 Horseferry Road"]
["London"]
["SW1P 4DR"]
["tasm@dft.gov.uk"]

{"sheet":"Concentrations","index":1,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,0,7,0],[6,13,6,16],[5,9,5,16],[6,1,6,4],[6,5,6,8],[6,9,6,12],[5,1,5,8]]}
[]
[null,"Pollutant Concentration Entry"]
[]
[null,"Please click the Button to Compile the Local Air Quality Results"]
[]
["Road","NO2 Concentrations",null,null,null,null,null,null,null,"PM2.5 Concentrations"]
[null,"Do-Minimum",null,null,null,"Do-Something",null,null,null,"Do-Minimum",null,null,null,"Do-Something"]
[null,"0-50m ","50-100m","100-150m ","150-200m ","0-50m ","50-100m","100-150m ","150-200m ","0-50m ","50-100m","100-150m ","150-200m ","0-50m ","50-100m","100-150m ","150-200m "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Property Counts","index":2,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,4],[6,5,6,8],[5,1,5,8],[5,0,7,0]]}
[]
[null,"Property Count Entry"]
[]
[null,"Please click the Button to Compile the Local Air Quality Results"]
[]
["Road","Property Input"]
[null,"Do-Minimum",null,null,null,"Do-Something"]
[null,"0-50m ","50-100m","100-150m ","150-200m ","0-50m ","50-100m","100-150m ","150-200m "]

{"sheet":"Summary","index":3,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PM2.5, SUMMARY OF ROUTES:","0-50m ","50-100m","100-150m ","150-200m ","0-200m "]
[null,"THE AGGREGATED TABLE","(i)","(ii)","(iii)","(iv)","(v=i+ii+iii+iv)"]
[null,"Total properties across all routes (min)",0,0,0,0,{"$f":"SUM(C4:F4)","v":0}]
[null,"Total properties across all routes (some)",0,0,0,0,{"$f":"SUM(C5:F5)","v":0}]
[null,"Do-minimum PM2.5 assessment ",null,null,null,null,"Total assessment PM2.5 (I):"]
[null,"across all routes",0,0,0,0,{"$f":"SUM(C7:F7)","v":0}]
[null,"Do-something PM2.5 assessment ",null,null,null,null,"Total assessment PM2.5 (II):"]
[null,"across all routes",0,0,0,0,{"$f":"SUM(C9:F9)","v":0}]
[null,"Net total assessment for PM2.5, all routes (II-I)",null,null,null,null,{"$f":"G9-G7","v":0}]
[null,"Number of properties with an improvement ",null,null,null,null,0]
[null,"Number of properties with no change",null,null,null,null,0]
[null,"Number of properties with a deterioration",null,null,null,null,0]
[]
[null,"Reference Sources:"]
[]
[null,"Quantitative Measures:"]
[]
[null,"Assessment Scores:"]
[]
[null,"Qualitative Comments:"]
[]
[]
[]
[null,"NO2, SUMMARY OF ROUTES:","0-50m ","50-100m","100-150m ","150-200m ","0-200m "]
[null,"THE AGGREGATED TABLE","(i)","(ii)","(iii)","(iv)","(v=i+ii+iii+iv)"]
[null,"Total properties across all routes (min)",{"$f":"C4","v":0},0,0,0,{"$f":"SUM(C27:F27)","v":0}]
[null,"Total properties across all routes (some)",0,0,0,0,{"$f":"SUM(C28:F28)","v":0}]
[null,"Do-minimum NO2 assessment ",null,null,null,null,"Total assessment NO2 (I):"]
[null,"across all routes",0,0,0,0,{"$f":"SUM(C30:F30)","v":0}]
[null,"Do-something NO2 assessment ",null,null,null,null,"Total assessment NO2 (II):"]
[null,"across all routes",0,0,0,0,{"$f":"SUM(C32:F32)","v":0}]
[null,"Net total assessment for NO2, all routes (II-I)",null,null,null,null,{"$f":"G32-G30","v":0}]
[null,"Number of properties with an improvement ",null,null,null,null,0]
[null,"Number of properties with no change",null,null,null,null,0]
[null,"Number of properties with a deterioration",null,null,null,null,0]
[]
[null,"Reference Sources:"]
[]
[null,"Quantitative Measures:"]
[]
[null,"Assessment Scores:"]
[]
[null,"Qualitative Comments:"]

{"sheet":"Worksheets","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PM10","0-50m ","50-100m","100-150m ","150-200m ","0-200m ",null,"NO2","0-50m ","50-100m","100-150m ","150-200m ","0-200m "]
[null,null,"(i)","(ii)","(iii)","(iv)","(v=i+ii+iii+iv)",null,{"$f":"B3","v":0},"(i)","(ii)","(iii)","(iv)","(v=i+ii+iii+iv)"]
[null,"Properties (amin)",null,null,null,null,{"$f":"SUM(C4:F4)","v":0},null,"Properties (amin)",{"$f":"C4","v":0},{"$f":"D4","v":0},0,0,{"$f":"SUM(J4:M4)","v":0}]
[null,"Properties (asome)",null,null,null,null,{"$f":"SUM(C5:F5)","v":0},null,"Properties (asome)",{"$f":"C5","v":0},0,0,0,{"$f":"SUM(J5:M5)","v":0}]
[null,"PM10 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A",null,"NO2 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A"]
[null,"within band for do-minimum (bmin)",null,null,null,null,null,null,"within band for do-minimum (bmin)"]
[null,"PM10 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A",null,"NO2 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A"]
[null,"within band for do-something (bsome)",null,null,null,null,null,null,"within band for do-something (bsome)"]
[null,"Do-minimum PM10 assessment ",null,null,null,null,"Total route assess PM10 (I):",null,"Do-minimum NO2 assessment ",null,null,null,null,"Total route assess NO2 (I):"]
[null,"(c = amin*bmin)",{"$f":"C4*C7","v":0},{"$f":"D4*D7","v":0},{"$f":"E4*E7","v":0},{"$f":"F4*F7","v":0},{"$f":"SUM(C11:F11)","v":0},null,"(c = amin*bmin)",{"$f":"J4*J7","v":0},{"$f":"K4*K7","v":0},{"$f":"L4*L7","v":0},{"$f":"M4*M7","v":0},{"$f":"SUM(J11:M11)","v":0}]
[null,"Do-something PM10 assessment ",null,null,null,null,"Total route assess PM10 (II):",null,"Do-something NO2 assessment ",null,null,null,null,"Total route assess NO2 (II):"]
[null,"(c = asome*bsome)",{"$f":"C5*C9","v":0},{"$f":"D5*D9","v":0},{"$f":"E5*E9","v":0},{"$f":"F5*F9","v":0},{"$f":"SUM(C13:F13)","v":0},null,"(c = asome*bsome)",{"$f":"J5*J9","v":0},{"$f":"K5*K9","v":0},{"$f":"L5*L9","v":0},{"$f":"M5*M9","v":0},{"$f":"SUM(J13:M13)","v":0}]
[null,"Net total route assessment for PM10 (II-I)",{"$f":"(G4*IF((C9-C7)<0,1,0))+IF((AND((G5-G4)<0, (C9-C7)>=0)),(G4-G5),0)","v":0},{"$f":"IF(AND(C9=C7,G5>=G4),G4,IF(AND(C9=C7,G5<G4),G5,0))","v":0},{"$f":"(G5*IF((C9-C7)>0,1,0))+IF((AND((G5-G4)>0, (C9-C7)<=0)),(G5-G4),0)","v":0},null,{"$f":"G13-G11","v":0},null,"Net total route assessment for NO2 (II-I)",{"$f":"(N4*IF((J9-J7)<0,1,0))+IF((AND((N5-N4)<0, (J9-J7)>=0)),(N4-N5),0)","v":0},{"$f":"IF(AND(J9=J7,N5>=N4),N4,IF(AND(J9=J7,N5<N4),N5,0))","v":0},{"$f":"(N5*IF((J9-J7)>0,1,0))+IF((AND((N5-N4)>0, (J9-J7)<=0)),(N5-N4),0)","v":0},null,{"$f":"N13-N11","v":0}]

{"sheet":"Master","index":5,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"PM10","0-50m ","50-100m","100-150m ","150-200m ","0-200m ",null,"NO2","0-50m ","50-100m","100-150m ","150-200m ","0-200m "]
[null,"Test","(i)","(ii)","(iii)","(iv)","(v=i+ii+iii+iv)",null,{"$f":"B3","v":"Test"},"(i)","(ii)","(iii)","(iv)","(v=i+ii+iii+iv)"]
[null,"Properties (amin)",null,null,null,null,{"$f":"SUM(C4:F4)","v":0},null,"Properties (amin)",{"$f":"C4","v":0},{"$f":"D4","v":0},0,0,{"$f":"SUM(J4:M4)","v":0}]
[null,"Properties (asome)",null,null,null,null,{"$f":"SUM(C5:F5)","v":0},null,"Properties (asome)",{"$f":"C5","v":0},0,0,0,{"$f":"SUM(J5:M5)","v":0}]
[null,"PM10 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A",null,"NO2 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A"]
[null,"within band for do-minimum (bmin)",null,null,null,null,null,null,"within band for do-minimum (bmin)"]
[null,"PM10 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A",null,"NO2 concentration at average point ","At 20m:","At 70m:","At 115m:","At 175m:","N/A"]
[null,"within band for do-something (bsome)",null,null,null,null,null,null,"within band for do-something (bsome)"]
[null,"Do-minimum PM10 assessment ",null,null,null,null,"Total route assess PM10 (I):",null,"Do-minimum NO2 assessment ",null,null,null,null,"Total route assess NO2 (I):"]
[null,"(c = amin*bmin)",{"$f":"C4*C7","v":0},{"$f":"D4*D7","v":0},{"$f":"E4*E7","v":0},{"$f":"F4*F7","v":0},{"$f":"SUM(C11:F11)","v":0},null,"(c = amin*bmin)",{"$f":"J4*J7","v":0},{"$f":"K4*K7","v":0},{"$f":"L4*L7","v":0},{"$f":"M4*M7","v":0},{"$f":"SUM(J11:M11)","v":0}]
[null,"Do-something PM10 assessment ",null,null,null,null,"Total route assess PM10 (II):",null,"Do-something NO2 assessment ",null,null,null,null,"Total route assess NO2 (II):"]
[null,"(c = asome*bsome)",{"$f":"C5*C9","v":0},{"$f":"D5*D9","v":0},{"$f":"E5*E9","v":0},{"$f":"F5*F9","v":0},{"$f":"SUM(C13:F13)","v":0},null,"(c = asome*bsome)",{"$f":"J5*J9","v":0},{"$f":"K5*K9","v":0},{"$f":"L5*L9","v":0},{"$f":"M5*M9","v":0},{"$f":"SUM(J13:M13)","v":0}]
[null,"Net total route assessment for PM10 (II-I)",{"$f":"(G4*IF((C9-C7)<0,1,0))+IF((AND((G5-G4)<0, (C9-C7)>=0)),(G4-G5),0)","v":0},{"$f":"IF(AND(C9=C7,G5>=G4),G4,IF(AND(C9=C7,G5<G4),G5,0))","v":0},{"$f":"(G5*IF((C9-C7)>0,1,0))+IF((AND((G5-G4)>0, (C9-C7)<=0)),(G5-G4),0)","v":0},null,{"$f":"G13-G11","v":0},null,"Net total route assessment for NO2 (II-I)",{"$f":"(N4*IF((J9-J7)<0,1,0))+IF((AND((N5-N4)<0, (J9-J7)>=0)),(N4-N5),0)","v":0},{"$f":"IF(AND(J9=J7,N5>=N4),N4,IF(AND(J9=J7,N5<N4),N5,0))","v":0},{"$f":"(N5*IF((J9-J7)>0,1,0))+IF((AND((N5-N4)>0, (J9-J7)<=0)),(N5-N4),0)","v":0},null,{"$f":"N13-N11","v":0}]