{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Information","2017","2018","2019","2020","2021","Sheet2","2022","2023","QA QC Log","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":4,"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":"Information","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[3,0,3,12],[4,0,4,12],[6,0,6,12],[7,0,7,12]]}
["Southampton City Council NO2 Diffusion Tube Survey"]
[]
["Information"]
["• Southampton City Council monitor nitrogen dioxide (NO2) across the city using NO2 diffusion tubes "]
["• Monitoring is undertaken in accordance with the Local Air Quality Management Technical Guidance (LAQM TG): https://laqm.defra.gov.uk/technical-guidance/"]
["• Data is collected monthly and is averaged at the end of the year to compare with the annual mean nitrogen dioxide UK objective "]
["• Data is bias adjusted in accordance with the LAQM National Bias Adjustment Spreadsheet: https://laqm.defra.gov.uk/bias-adjustment-factors/national-bias.html   "]
["• The latest version of the bias adjustment factor has been calculated based on the following version: 03/19 (Gradko 20% TEA in water)"]
["• Exceedances of the annual mean nitrogen dioxide UK objective (40 µg/m3) are shown in red. However, some exceedances are not representative of relevant receptors. Refer to the associated Annual Status Report for details."]
["• 60 µg/m3 is used as an indicator of potential exceedances of the hourly mean NO2 UK Objective. Results over 60 µg/m3 are underlined. "]
["• Corrections for distance and annualisations are carried out in accordance with the LAQM TG and calculations are detailed in the associated Annual Status Report for the data year"]
["• Due to ongoing quality assurance and quality control (QA QC) checks the data on this sheet is subject to change. A log of changes is held on \"QA QC Log\""]
["• \"Missing\" indicates where diffusion tubes are abscent from site on collection"]
["• \"Error\" indicates where the validation process has identified an error that may have occurred through tube collection, analytical error or interference (i.e. insects in tubes)"]
[]
["For more information please contact: air.quality@southampton.gov.uk "]

{"sheet":"2017","index":1,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2017"]
["Status"]
["Bias Adjustment factor ",0.87]
["Other comments","Time weighted average applied in accordance with LAQM"]
[]
[]
["Site ID","Site Name","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","Bias Adjusted Time Weighted Annual Mean"]
["N100","6 Sandringham Road",33.22,22.49,19.62,15.1,14.84,13.4,16.170000000000002,15.08,14.69,22.08,26.21,20.89,16.736968421052602]
["N101","Redbridge School Fence",75.069999999999993,54.37,67.59,50.48,46.73,35.840000000000003,47.4,50.55,57.61,57.49,64.930000000000007,57.44,48.238758904109574]
["N102","64 Burgess Road",52.63,57.13,37.159999999999997,27.75,32.770000000000003,29.89,27.01,27.74,32.380000000000003,35.299999999999997,39.89,32.29,30.883284166666666]
["N103","485 Millbrook Road",49.58,37.6,42.8,30.7,35.03,29.51,30.57,32.51,35.36,39.130000000000003,35.51,38.299999999999997,31.501579726027401]
["N104","Regents Park Junction",58.15,50.53,39.58,37.14,46.46,36.35,40.69,34.659999999999997,42.56,42.16,41.66,24.95,35.642803561643838]
["N106","2 Romsey Road, Oakhill",52.8,41.26,49.03,38.049999999999997,43.03,40.17,41.3,40.1,36.94,43.87,40,35.229999999999997,36.279594262295085]
["N107","Cranbury Place",68.760000000000005,65.760000000000005,53.01,43.23,51.53,42.19,50.44,49.56,52,56.07,62.57,32.61,45.269845833333328]
["N109","72 Bevois Valley",61.55,54.26,42.42,38.43,44.12,32.15,36.49,35.65,"Missing",42.59,44.14,38.35,36.59282702702702]
["N110","Brintons Road 1",46.99,36.299999999999997,32.200000000000003,24.65,31.85,24.02,28.05,27.91,31.48,35.479999999999997,31.78,37.03,27.729823966942149]
["N111","Brintons Road 2",46.53,36.380000000000003,29.13,25.26,31.19,25.03,28.78,27.9,33.92,34.520000000000003,34.299999999999997,32.74,27.539142975206609]
["N112","Brintons Road 3",48.36,38.35,29.17,25.85,33.659999999999997,26.32,27.5,29.65,30.95,"Missing",33.85,34.57,27.838411077844313]
["N113","206 Bitterne Road",50.31,41.19,41.22,41.25,31.79,37.42,34.520000000000003,34.15,36.08,43.83,52.24,40.369999999999997,35.223320547945207]
["N114","Bitterne Library",53.74,40.32,44.37,35.58,35.76,40.43,33.81,32.03,35.549999999999997,40.46,42.51,38.380000000000003,34.356538356164386]
["N115","54 Redbridge Road",45.75,48.06,51.33,36.479999999999997,44.5,46.77,38.119999999999997,32.71,36.47,40.380000000000003,39.14,36.130000000000003,35.930809315068494]
["N116","57 Redbridge Road",51.64,39.96,36.35,40.74,43.98,31.62,38.15,36.020000000000003,38.07,37.96,43.09,38.049999999999997,34.345836164383563]
["N117","Victoria Road (Lamp Post)",50.06,39.35,40.9,34.64,36.770000000000003,40.869999999999997,34.450000000000003,37.270000000000003,36.71,"Missing",43.17,38.380000000000003,34.238758006042303]
["N118","3 Rockstone Lane",60.44,51.24,38.54,34.93,39.75,26.2,32.07,"Missing",35.29,41.68,41.05,37.020000000000003,34.094179141104291]
["N120","6-9 Canute Road",61.62,42.69,44.89,47.3,44.37,43.06,41.8,43.01,41.82,47.06,49.09,45.23,39.993421978021978]
["N122","151 Paynes Road",44.49,37.46,42.21,30.49,34.47,29.73,30.62,33.67,33.54,36.46,41.09,42.21,31.587840821917808]
["N123","102 St Andrews Road",54.33,38.799999999999997,40.15,32.61,39.049999999999997,27.63,31.54,13.84,37.130000000000003,39.01,38.35,33.94,30.323670247933887]
["N124","305 Millbrook Road",53.63,"Missing",38.54,37.9,42.83,36.42,38.81,35.92,35.97,41.06,47.73,39.869999999999997,35.451923493975897]
["N125","Princes Court",55.8,38.57,41.21,40.18,35.03,43.11,33.68,34.340000000000003,33.42,34.869999999999997,43.4,41.14,34.525938082191779]
["N126","107 St Andrews Road",55.27,42.6,34.08,35.89,35.6,30.81,33.32,32.270000000000003,30.46,40.79,42.62,36.29,32.251571074380166]
["N129","South West House",45.76,34.200000000000003,31.17,"Missing",33.549999999999997,37.86,29.53,30.63,29.89,34.89,37.880000000000003,35.67,30.167406287425148]
["N130","367A Millbrook Road",53.63,48.46,52.23,38.159999999999997,51.23,44.88,43.67,38.700000000000003,52.98,47.58,48.1,46.7,40.836322191780823]
["N131","142 Romsey Road",52.9,41.21,48.05,42.39,42.8,26.81,41.87,37.33,34.21,41.51,40.229999999999997,39.81,35.248501639344262]
["N133","539 Millbrook Road",43.88,35.08,37.479999999999997,29.7,33.659999999999997,28.26,30.38,29.07,34.14,36.270000000000003,37.4,32.11,29.429358904109588]
["N134","435 Millbrook Road West Ladbrokes",55.7,41.42,48.64,43.06,44.08,34.49,35.33,35.130000000000003,40.79,40.229999999999997,41.45,40.69,36.138941917808218]
["N138","66 Burgess Road",67.45,33.340000000000003,56.31,39.200000000000003,54.59,44.7,46.65,42.64,40.65,43.83,51.16,41.51,40.355360833333336]
["N140","5 Commercial Road ",61.25,55.76,63.22,46.15,54.71,44.31,52.11,48.6,54.41,52.7,53.32,39.869999999999997,45.37635576923077]
["N141","Town Quay Road",48.56,37.08,38.47,43.81,41.07,41.88,33.22,33.479999999999997,28.2,34.909999999999997,41.76,30.89,32.969056318681311]
["N143","102 Romsey Road",48.61,41.15,46.39,40.15,40.369999999999997,36.44,37.65,35.979999999999997,43.3,42.69,46.71,40.75,36.191762295081958]
["N144","208 Northam Road",52.4,"Missing",43.09,38,32.119999999999997,44.47,36.020000000000003,36.700000000000003,35.39,43.05,49.01,47.48,36.376455489614244]
["N146","222 Northam Road",44.83,35.340000000000003,33.74,30.69,31.76,34.799999999999997,30.01,29,32.909999999999997,34.92,40.299999999999997,38.47,30.230235616438353]
["N149","44B Burgess Road",51.17,41.07,36.18,24.09,29.55,29.28,30.7,28.45,20.239999999999998,37.5,38.17,31.71,28.545231666666663]
["N151","134 Romsey Road ",48.47,40.450000000000003,47.46,42.61,43.95,42.35,40.909999999999997,39.61,37.9,42.91,48.26,44.54,37.646112295081977]
["N152","M271",64.900000000000006,51.69,54.66,54.64,53.22,46.36,48.73,50.15,49.94,52.42,57.84,46.81,45.781449863013698]
["N153","Coniston Road ",47.49,36.119999999999997,36.78,30.57,42.12,30.15,35.54,33.79,29.49,30.04,29.67,31.02,29.809322465753425]
["N154","Oceana Boulevard DG5 ",50.62,34.6,39.24,32.630000000000003,33.86,39.590000000000003,"Missing",37.57,34.33,39.229999999999997,46.48,37.799999999999997,33.838169552238803]
["N157","Admiralty House",41.79,"Missing",32.5,28.05,25.38,29.67,27.73,"Missing","Missing",32.71,37.85,31.22,27.840727636363631]
["N158","24 Portsmouth Road",51.03,45.46,40.229999999999997,37.82,44.08,41.48,33.67,36.76,40.51,42.97,45.75,45.52,36.565884890109892]
["N159","35 Portsmouth Road",48.45,35.99,35.79,40.6,33.54,32.29,30.22,33.590000000000003,37.270000000000003,38.24,43.06,29.42,31.875772252747254]
["N160","2 Dorset Street",52.58,40.35,34.53,31.44,34.6,22.06,29.07,26.71,"Missing",52.8,35.729999999999997,59.72,32.566973873873877]
["N161","30 Addis Square",54.32,40.93,35.53,35.99,28.67,29.1,28.16,31.64,31.71,31.19,42.23,34.75,30.439439166666663]
["N162","263A Portswood Road",60.81,43.98,32.840000000000003,40.65,"Missing",42.99,"Missing",36.979999999999997,42.88,43.37,45.39,45.78,37.35713521594684]
["N163","285 Portswood Road",45.21,37.99,43.15,31.19,28.01,28.74,24.42,24.97,29.18,36.53,36.5,32.33,28.683295833333329]
["N164","168 Portswood Road(Int.Food)",56.52,45.96,41.06,32.17,35.200000000000003,34.729999999999997,34.82,31.79,33.979999999999997,37.82,38.22,30.19,32.42980583333334]
["N165","8 The Broadway",55.69,39.65,38.090000000000003,33.1,36.659999999999997,32.06,34.89,28.05,33.35,38.549999999999997,37.28,31.66,31.391267499999991]
["N166","14 New Road",58.96,"Missing",40.75,34.369999999999997,41.11,34.75,33.61,37.869999999999997,39.14,"Missing","Missing","Missing",37.323]
["N167","13 Romsey Road",56.13,38.630000000000003,43.75,48.01,40.33,33.450000000000003,30.21,33.19,33.54,35.68,45.87,36.35,34.464859836065571]
["N168","23 Romsey Road",61.39,35.840000000000003,46.07,48.01,42.44,33.630000000000003,32.090000000000003,33.33,36.44,37.840000000000003,49.45,38.979999999999997,35.889995901639345]
["N169","150 Romsey Road",61.92,47.24,56.3,47.23,53.53,43.3,50.46,43.25,49.34,48.61,49.52,44.93,42.978332786885247]
["N170","Union Castle House (2)",57.73,44.74,48.9,46.36,41.55,44.79,38.869999999999997,42.27,43.54,46.6,50.33,"Missing",40.077430357142852]
["N171","132 Newton Road",34.6,23.75,21.66,16.05,16.27,14.65,14.13,14.45,16.579999999999998,22.13,"Missing",47.23,18.770023853211008]
["N172","4 New Road",62.5,55.65,55.82,42.67,50.79,39.74,33.590000000000003,49.98,47.75,"Missing",53.48,44.65,42.069174626865681]
["N173","19A Burgess Road",44.57,36.89,34.25,26.56,33.619999999999997,27.91,31.11,29.76,30.28,33.840000000000003,34.229999999999997,28.27,28.050830000000001]
["N174","166A Bitterne Road West",58.14,45.81,48.74,44.45,45.9,54.78,42.51,38.950000000000003,41.83,48.17,50.48,45.99,41.160462739726022]
["N175","38 Shirley High Street",62.69,44.44,42.3,40.18,41.34,42.37,"Missing",40.950000000000003,36.92,45.29,48.54,46.26,38.857613274336281]
["N176","Salisbury Arms, Shirley High Street",61.86,41.24,49.03,41.48,47.29,33.64,33.729999999999997,36.090000000000003,33.08,38.36,40.840000000000003,33.880000000000003,35.452024590163923]
["N177","95 Shirley High Street (Windsor Castle Pub)",62.14,49.15,38.58,44.52,48.71,35.65,40.630000000000003,38.130000000000003,36.479999999999997,38.1,43.37,42.55,37.511499999999998]
["N178","2 Gover Road",38.56,29.34,32.29,26,34.159999999999997,24.26,27.03,24.1,24.87,28.08,26.57,24.52,24.527635890410959]
["N180","Opposite 5 Commercial Road",66.92,"Missing",45.33,35.409999999999997,46.29,38.76,41.03,"Missing",48.43,47.67,46.19,40.19,39.663589999999999]
["N184","Redbridge New AMS ","Missing",56.03,"Missing",38,46.92,40.28,41.22,36.950000000000003,39.770000000000003,80.72,56.25,46.62,41.760515131578948]
["N185","Redbridge Causeway 1",70.02,70.16,61.11,58.84,53,37.26,50.66,55.68,49.35,48.27,71.069999999999993,68.36,50.248870491803281]
["N186","Redbridge Causeway 2",62.76,"Missing",41.08,53.28,48.39,36,34.96,43.88,39.450000000000003,42.21,50,41.09,39.042058407079651]

{"sheet":"2018","index":2,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2018"]
["Status"]
["Bias Adjustment factor ",0.92]
["Other comments","Bias adjustment factor updated in June 2019 from 0.93 to 0.92 following national bias adjustment factor update (v 06/19 Gradko 20% TEA in water)"]
[]
["Site ID","Site Name","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","Bias Adjusted Annual Mean"]
["N100","6 Sandringham Road",23.355020512820513,20.992712351190477,18.600000000000001,16.609533564814814,18.142995098039219,15.390676282051281,16.514498655913979,13.624107843137256,16.8,19.88,20.79,20.6,{"$f":"AVERAGE(C7:N7)*0.92","v":16.966298396944179}]
["N101","Redbridge School Fence",51.932317528735624,39.584727932098772,47.022201488095241,47.471734953703702,47.95416176470588,41.8,47.071340773809524,"Missing",43.7,40.1,47.04,48.41,{"$f":"AVERAGE(C8:N8)*0.92","v":41.992687789623346}]
["N102","64 Burgess Road",37.566038942307692,39.340093154761902,36.4,32.154917892156867,28.512829656862746,33.906107142857138,31.234511494252875,24.571917824074074,34.9,36.4,56.85,34.700000000000003,32.701125234890952]
["N103","485 Millbrook Road",33.800485919540229,27.135805555555557,30.191996130952379,35.337061342592591,31.261257352941179,"Error",29.155976190476188,"Missing",30.5,35,59.3,32.14,31.631677589269348]
["N104","Regents Park Junction",36.257732614942526,34.841270216049388,39.62878645833333,45.767784722222224,42.59219852941176,32.800473214285716,41.932190476190478,35.249247619047622,33.4,40.299999999999997,46.96,39.520000000000003,35.975809095203701]
["N106","2 Romsey Road, Oakhill",41.221718303571436,38.204581327160497,36.140731327160495,43.537407142857141,41.741831081081081,40.314688988095241,39.475226190476192,36.707528186274509,39.1,36.799999999999997,43.78,39.869999999999997,36.561851295245212]
["N107","Cranbury Place",54.083453846153844,52.409095684523805,"Missing","Missing",55.811629901960785,50.489204022988503,"Missing",40.654569047619049,53.2,51.5,51.87,54.51,47.485079589220703]
["N109","72 Bevois Valley",44.998985897435901,46.100839880952378,48.4,38.028347222222223,46.858162990196078,42.680576149425285,41.195101190476194,29.04677777777778,40.200000000000003,45.6,42.34,41.47,38.863773984983915]
["N110","Brintons Road 1",41.950617708333333,31.182971726190473,35,26.849159722222222,29.151012626262624,26.351647988505746,29.365273148148148,26.944708333333335,30.8,35.700000000000003,34.22,33.020000000000003,29.174379996063017]
["N111","Brintons Road 2",38.157337847222223,31.043743749999997,34.5,31.945085648148144,28.317133838383835,25.758587643678158,29.513904320987653,23.520452702702702,30.6,36.1,37.36,34,29.195912174252744]
["N112","Brintons Road 3",38.544309722222216,31.817687500000002,36.6,22.820193287037039,26.527768939393937,26.984245689655172,29.407739197530866,27.579977477477478,31.4,33.9,33.409999999999997,32.94,28.514780672354284]
["N113","206 Bitterne Road",41.209433482142856,39.589884523809523,36.4,28.53354523809524,35.23286785714285,36.874938988095238,35.899919540229888,35.308022058823525,35.79,35.9,31.92,32.28,32.578626896106009]
["N114","Bitterne Library",43.4288912202381,34.317648660714283,44.6,31.236205952380953,32.857802380952378,37.407281249999997,39.240826149425288,36.134236519607839,35.130000000000003,28.6,36.479999999999997,35.67,33.35788839688778]
["N115","54 Redbridge Road",38.143664511494251,33.977086111111113,40.771274851190483,40.974429398148146,37.651773284313727,38.164845238095239,44.450578869047618,28.910279761904761,33.1,34.4,42.69,30.55,34.023434788606743]
["N116","57 Redbridge Road",30.455625574712641,40.119800154320984,36.070283184523809,39.082111904761909,42.620140476190471,41.584120535714291,41.563645833333325,28.812001190476188,32.700000000000003,39.700000000000003,37.47,32.07,33.905659212142574]
["N117","Victoria Road (Lamp Post)",35.442801805555554,31.830427314814816,37.418306089743588,36.854464285714286,37.279452702702706,36.512748563218388,30.589205357142855,33.014855392156861,35.299999999999997,40.6,38.74,36.549999999999997,32.976806715847104]
["N118","3 Rockstone Lane",37.59470352564103,43.175004910714286,41.7,33.93568171296296,42.305552696078429,41.474686781609194,35.114114583333333,28.791981481481482,35.200000000000003,41.3,47.24,38.79,35.774332303039586]
["N120","6-9 Canute Road",41.137772023809518,40.863411011904766,42.3,36.821704761904769,41.833911904761898,46.088555059523806,33.804439655172416,34.97079166666667,45.8,44.2,35.61,36.869999999999997,36.823044933087033]
["N122","151 Paynes Road",29.96536235632184,29.596713117283951,29.3,30.51185648148148,31.935718137254899,28.644108630952381,31.264870535714284,27.812835714285715,33.200000000000003,29.7,32.549999999999997,29.91,27.936678981285922]
["N123","102 St Andrews Road",38.565808159722224,35.232867857142864,37.700000000000003,32.949184210526319,36.343217171717171,40.969879464285711,34.110854166666662,29.935121621621622,31.1,41.9,39.700000000000003,42.25,33.791364836629]
["N124","305 Millbrook Road",40.148208477011494,37.300054475308634,31.311962351190481,39.206780092592595,40.788015931372549,40.601334821428573,38.32864285714286,32.775903571428572,34.6,38.200000000000003,40.83,35.54,34.471702530939808]
["N125","Princes Court",36.735711011904762,33.406524404761903,34.5,"Missing",44.045179761904762,47.480834821428573,41.494455459770123,34.95393014705882,39.299999999999997,41.7,37.28,37.630000000000003,35.840409523480233]
["N126","107 St Andrews Road",42.898937673611115,38.220126934523805,39.200000000000003,32.828491228070177,39.331282828282824,39.168105654761902,36.506394345238093,33.111467342342344,37.1,45.9,41.55,36.79,35.466368460523654]
["N129","South West House",29.596182291666668,29.512236011904765,35.700000000000003,30.87585119047619,29.188735714285716,30.998699404761904,33.349760057471265,23.839378472222226,"Missing","Missing",35.950000000000003,31.77,28.591837569136565]
["N130","367A Millbrook Road",48.753514080459773,34.762708024691356,41.274952529761904,44.716749999999998,43.806227941176466,41.256525297619049,45.371940476190481,35.609602380952381,82.2,42.4,"Missing",40.369999999999997,41.861858461125756]
["N131","142 Romsey Road",35.052690476190477,39.374520987654321,39.822537808641975,44.454673809523811,43.182807432432433,39.905194940476193,41.68649404761905,37.011035539215683,38.9,42.3,43,42.55,37.355063219867802]
["N133","539 Millbrook Road",30.813438649425283,26.237648611111108,32.669435119047613,31.897311342592594,27.180769607843139,23.812078869047621,29.83164136904762,26.780910714285714,29.4,31.4,35.659999999999997,32,27.422381294984046]
["N134","435 Millbrook Road West Ladbrokes",42.48881997126437,35.682097993827163,35.148921577380946,40.942579861111113,40.855462009803922,"Missing",36.424495535714286,33.200000000000003,60.2,44.1,43.92,35.93,37.543726072106693]
["N138","66 Burgess Road",51.307399198717953,52.521706547619047,55.5,46.470348039215679,55.255199754901966,59.88850446428571,49.560076149425292,45.942957175925919,49.7,54.5,42.7,47.53,46.833841335307028]
["N140","5 Commercial Road ",46.800368678160922,48.683079012345679,46.389912345679015,50.973819047619052,54.733429398148147,50.756787202380956,52.190016369047619,40.192394144144139,44.9,51.3,"Missing",47.16,44.668492881974863]
["N141","Town Quay Road",29.162118601190475,37.452325595238094,43.6,36.772565476190479,50.924679761904763,45.126244047619053,31.748497126436785,31.9928599537037,37.6,39.700000000000003,35.49,35.08,34.856445609775058]
["N143","102 Romsey Road",38.860985119047619,32.269950925925926,36.240526543209882,39.720922619047613,42.005235360360359,36.36307142857143,38.676712797619047,41.142107843137254,33.799999999999997,34.5,42.15,42.25,35.111762635497136]
["N144","208 Northam Road",42.564858779761906,35.073165178571429,35.5,34.020765476190476,31.31810476190476,32.820947916666668,35.860382183908044,32.576455882352938,36.1,36.18,32.89,34.06,32.12062548041731]
["N146","222 Northam Road",32.661245238095233,30.714101041666666,35.299999999999997,26.944708333333335,28.140430952380953,27.681797619047622,32.776468390804595,23.521819852941178,31.7,28.5,32.14,28.58,27.497310476167328]
["N149","44B Burgess Road",35.775604967948716,37.790158184523804,30.8,30.586796568627452,30.586796568627452,31.531041666666667,33.389297413793102,27.310978009259262,39.700000000000003,29.2,40.72,38.479999999999997,31.116751625757562]
["N151","134 Romsey Road ",39.583742113095241,34.482432098765436,39.383014197530869,40.900265476190476,41.43194369369369,39.393327380952378,36.485919642857141,38.359957107843137,37.1,44.8,44.96,41.14,36.64824613117117]
["N152","M271",48.506405603448272,40.894805555555557,24.037300595238094,52.005744047619046,53.348884523809524,49.876374999999996,45.20814285714286,41.784772619047622,44.1,48.5,50.39,46.08,41.762819694809338]
["N153","Coniston Road ",27.140418247126437,28.673076543209877,33.478185863095234,36.887223809523803,36.625147619047624,36.076425595238092,34.151803571428573,18.165155952380953,"Missing",37.799999999999997,32.119999999999997,30.22,29.384585656815137]
["N154","Oceana Boulevard DG5 ","Missing",28.21823482142857,28.5,31.039648809523811,35.249247619047622,34.254177083333332,34.69403017241379,33.696810185185186,34.6,34.950000000000003,32.68,27.85,29.752143345059793]
["N157","Admiralty House",29.272681994047616,32.751333928571427,30.1,25.912783333333334,"Missing",29.217400297619047,27.241238505747123,24.890413194444445,30.25,27.4,26.88,28.3,26.112598468496543]
["N158","24 Portsmouth Road",35.10264875,33.418657561728395,35.133959294871794,41.833911904761898,38.735923423423422,39.992035919540236,39.741397321428572,33.318362745098035,35.799999999999997,40.700000000000003,39.270000000000003,36.590000000000003,34.472162097265347]
["N159","35 Portsmouth Road",29.795878888888886,35.834975771604938,34.245357211538462,31.31810476190476,39.712068693693695,37.79771264367816,27.354202380952383,31.581626225490197,35.5,42.7,31.34,36.43,31.710094370960945]
["N160","2 Dorset Street",37.493274999999997,32.10023839285715,36.1,31.897311342592594,31.362426470588236,27.755224137931034,26.699011904761907,26.355491898148149,30.5,36.1,40.200000000000003,35.15,30.031328401260726]
["N161","30 Addis Square",38.562684455128206,40.507998419540229,40.299999999999997,30.286179761904762,36.951253787878784,35.114114583333333,31.511272988505748,28.330163194444442,33.799999999999997,39.5,34.74,36.81,32.691714484623063]
["N162","263A Portswood Road",49.155350480769229,41.816684913793104,39.6,36.936363095238093,36.051855952380954,40.527310897435896,44.16322701149425,35.942202546296301,39.799999999999997,"Missing",40.409999999999997,39.69,37.142323209601379]
["N163","285 Portswood Road",34.62681666666667,33.865722557471265,34,26.993847619047617,28.730102380952381,40.218615384615383,29.415793103448276,26.737686342592593,29.2,34,32.64,32.54,29.360924777534223]
["N164","168 Portswood Road(Int.Food)",37.109610576923082,38.922550431034487,41.5,35.560463095238092,38.001047619047618,40.483211538461539,40.683939655172409,27.725021990740743,30.8,33.6,41.23,35.340000000000003,33.806614776174051]
["N165","8 The Broadway",36.256287980769237,39.944591091954024,36.6,33.005220238095241,38.525199999999998,32.082283653846154,37.718637931034479,31.706214120370372,32.4,33.4,34.53,35.11,32.298013351231994]
["N166","14 New Road","Missing",35.918770386904761,42.9,36.479453947368427,36.186864898989903,40.519436011904766,34.131328869047621,35.001780405405405,42,42.6,44.06,34.43,35.480856705277382]
["N167","13 Romsey Road",28.78538407738095,40.569940277777775,37.527247839506174,38.033807142857142,49.458027027027029,39.946144345238096,32.698099702380951,32.104333333333329,29.1,46.1,40.1,39.020000000000003,34.763962087155114]
["N168","23 Romsey Road",35.353668601190471,40.788640432098767,37.752317901234569,40.965784523809525,49.736925675675678,44.000135416666666,33.414714285714282,34.127715686274513,33.4,43.1,40.31,37.79,36.090059193404279]
["N169","150 Romsey Road",41.166436607142863,42.277075462962962,42.616803858024689,50.908300000000004,48.512870495495491,46.641372023809524,50.859160714285714,42.575337009803917,43.2,48.6,48.92,46.37,42.369630639816933]
["N170","Union Castle House (2)",42.3,38.582529166666667,37,40.703708333333331,48.664272619047622,45.965706845238095,46.891304597701144,36.961387731481487,44.1,43.5,36.04,42.95,38.613849712499238]
["N171","132 Newton Road",47.2,"Closed",null,null,null,null,null,null,null,null,null,null,43.424000000000007]
["N172","4 New Road",45,38.035854613095232,48.5,43.042134868421059,44.80361237373738,47.091815476190469,53.807517857142862,39.510641891891886,39.200000000000003,45.1,46.85,41.73,40.838154242836715]
["N173","19A Burgess Road",42.092838141025645,34.968744196428574,35.799999999999997,29.069259803921568,31.092642156862748,34.888892857142856,30.503070402298849,28.393862268518518,34.4,34.299999999999997,35.119999999999997,35.119999999999997,31.10744708667524]
["N174","166A Bitterne Road West",47.73472113095238,43.811768154761907,48.4,38.721757142857143,43.586546428571431,44.737224702380956,53.671961206896547,39.70887867647059,44.3,42.7,48.78,39.1,41.036052403954969]
["N175","38 Shirley High Street",39.85196071428571,38.385062037037038,38.841572067901232,43.521027380952383,42.392594594594598,37.775825892857142,39.925669642857144,39.826909313725494,42,44.9,42.34,43.9,37.847314326056157]
["N176","Salisbury Arms, Shirley High Street",31.414335863095239,33.91551033950617,39.081505246913579,37.526034523809521,47.164860360360358,44.839598214285715,37.796300595238094,21.650191176470589,26.6,42.57,60.39,35.799999999999997,35.170705784508748]
["N177","95 Shirley High Street (Windsor Castle Pub)",35.374143303571429,42.45967947530864,46.226418055555548,46.682321428571427,47.211343468468471,42.362159226190478,33.598986607142855,37.061620098039214,35.5,45.1,45.13,41.87,38.224211494151689]
["N178","2 Gover Road",25.406705172413787,25.082572067901236,27.526189880952384,30.548255952380952,27.534379761904763,27.804645833333336,23.873502976190473,17.804801190476191,20.399999999999999,27.8,35.15,24.28,24.012847384059071]
["N180","Opposite 5 Commercial Road","Missing",38.591022376543208,44.247500154320988,"Missing",48.045026620370372,44.061559523809528,42.464532738095237,31.654996621621624,40.1,42.5,"Missing","Missing",40.1,"Annualised"]
["N184","Redbridge New AMS ",54.638790773809532,39.1,47.234986728395064,51.166281250000004,38.901934523809523,34.520348214285711,38.881459821428571,34.856133333333332,35.6,"Missing",47.04,36.549999999999997,38.346430897586984]
["N185","Redbridge Causeway 1",54.312466379310337,55.261070061728397,49.988910030864197,59.786130952380951,68.107050000000001,64.085818452380948,58.189104166666667,"Mssing","Error",57.47,57.38,55.36,53.354530603986504]
["N186","Redbridge Causeway 2",36.742065229885057,48.447392438271606,37.599440123456787,31.400003571428574,60.506840476190476,58.516699404761908,"Missing","Mssing",33.4,45.3,33.590000000000003,34.04,38.597904594447485]
["N187","Cobden Avenue",null,null,null,null,null,null,null,null,41.9,31.98,36.049999999999997,41.68,{"$f":"AVERAGE(C72:N72)*0.92","v":34.8703}]

{"sheet":"2019","index":3,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2019"]
["Status"]
["Bias Adjustment factor ",0.93]
["Other comments","Bias adjustment factor updated from 0.92 to 0.93 following national bias adjustment factor update "]
[]
[]
["Site ID","Site Name","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","Bias Adjusted Annual Mean"]
["N100","6 Sandringham Road",20.20853125,27.047333797696602,19.423776013727078,15.77,13.34,13.91,13,29.86761181878947,16.353163365156373,20.44889173159476,24.540100200403664,19.921396736482915,{"$f":"(AVERAGE(C8:N8))*0.93","v":18.121887380823441}]
["N101","Redbridge School Fence",54.524132440476187,55.040233864137484,43.19650372866937,42.91,36.29,30.21,38.94,39.549908164489771,32.215001605377822,36.899595885376819,50.340049040246228,45.666183257915549,{"$f":"(AVERAGE(C9:N9))*0.93","v":39.198074618968413}]
["N103","485 Millbrook Road",40.826556547619049,47.097545748117099,32.696880511243911,31.33,25.67,26.71,29.18,24.985166674662469,24.209862256232331,30.069010765548146,37.559746716702904,34.209928065902297,29.802214039667195]
["N104","Regents Park Junction",38.942883928571398,57.941167456756759,34.795301750823604,22.06,31.96,30.09,38.21,30.187715806640455,33.544950133302756,35.634701730599865,43.569600592456325,41.746347076112365,33.997906806832923]
["N106","2 Romsey Road, Oakhill",47.345984195402302,51.139840085007805,"Missing",34.82,31.71,31.49,35.89,33.704524728986271,31.248730077640893,35.174208888537052,44.592401233808857,41.365499880883725,35.380682350358931]
["N107","Cranbury Place",60.599052469135806,65.20323848171013,61.328292379623463,41.44,47.06,44.84,40.46,43.525763038807867,36.684283619552446,53.514665447831405,53.987828662670374,51.150828384251284,46.484031317477665]
["N109","72 Bevois Valley",46.500324074074072,55.626471328153912,38.799515042656253,37.729999999999997,32.82,39.159999999999997,32.450000000000003,30.174051487503764,35.331043841328146,45.887030604132484,46.648533917852525,49.259820011015755,38.004976248770561]
["N110","Brintons Road 1",33.033461206896554,44.552952380952384,32.279388776905527,28.81,13.11,23.7,23.54,27.755575234333268,27.700898268937792,32.70829386285736,37.059272482815921,34.037477706502102,27.767267293815571]
["N111","Brintons Road 2",29.000650862068966,46.768687445887451,32.243602314846875,29.49,24.61,24.75,22.21,27.694484459789617,26.574845493777719,32.383223266018739,37.305923214814698,30.118904887689958,28.14414995072929]
["N112","Brintons Road 3",34.535880747126441,46.268360173160168,32.082563235582931,27.43,24.9,23.31,24.98,27.022485939809425,26.595319180598811,31.578286550037394,38.539176874808575,32.971757065402564,28.691571806905792]
["N113","206 Bitterne Road",41.133677083333332,38.356618193067924,42.34376868997321,33.58,27.81,34.549999999999997,26.11,32.965906046932261,33.191262533041368,36.252397541820507,39.473895910425142,35.977954114405513,32.685274708757447]
["N114","Bitterne Library",37.263958333333335,44.176694347023023,39.457383233086247,40.97,30.8,29.77,32.29,31.942912419078247,28.991602524128531,29.514768435616237,38.660614637898796,39.109399816454847,32.778418365363002]
["N115","54 Redbridge Road",50.2653943452381,45.987961956523939,36.343241286997653,33.229999999999997,29.84,30.19,28.43,27.30612506295957,27.997194516492417,33.97062050947126,42.545802181455159,37.015546345141033,32.791946180831637]
["N116","57 Redbridge Road",44.655325892857142,40.528744415349408,32.682908532349721,38.340000000000003,32.520000000000003,29.7,"Missing",28.843882848799947,29.042690136657711,32.013487032876512,43.83765700598925,32.417955314828077,32.514715054284387]
["N117","Victoria Road (Lamp Post)",44.459757183908046,44.17370620362631,38.804483929717144,38.159999999999997,30.21,33.01,29.07,28.50911047700615,30.824364361038416,33.859255515598413,46.371523759952076,37.007443912275193,33.670622514091946]
["N118","3 Rockstone Lane",44.100992283950617,52.921058135801267,"Missing",39.18,"Missing",30.99,26.94,30.950604411909467,28.329665780383838,39.906049969189041,44.070826796254863,39.157379377906722,35.018831638251818]
["N120","6-9 Canute Road","Missing","Missing",49.204808256439726,44.23,31.66,39.049999999999997,34.409999999999997,37.520000000000003,30.337444765125984,35.561774714887882,44.221094457830084,"Missing",35.773495960075984]
["N122","151 Paynes Road",37.734876488095239,41.978759729621764,33.311155532437802,30.83,"Missing",25.63,30.37,31.2178159844673,30.373353238735412,28.26650540421981,37.003101073679609,42.27306105397512,31.196311319078713]
["N123","102 St Andrews Road","Missing",47.830483534136548,33.664087957636582,38.26,29.92,30.17,27.7,27.890417906012193,33.134502750110919,37.332059935205358,47.28781592657046,33.822072068499509,32.720058115699963]
["N124","305 Millbrook Road",44.512002976190473,52.497459919074828,35.92593698914397,33.97,"Missing",31.25,35.97,29.654666922450094,31.336209092258535,34.305590428712264,43.953540345073918,36.911339998837832,34.68787949133818]
["N125","Princes Court",40.232790178571427,43.168973531313114,38.373724770642205,48.15,33.28,36.72,32.729999999999997,23.291032906991855,29.239759888416771,52.582165605092051,48.743223992499068,50.994384941679378,37.006719325678446]
["N126","107 St Andrews Road",39.939319444444443,50.122466068805601,37.185801400141202,36.94,29.97,26.46,29.35,28.235481312575331,29.210345408594439,"Missing",40.65,35.37654562752585,32.418105646703708]
["N129","South West House",35.298386904761905,38.030271942442859,35.876775002001182,34.130000000000003,"Missing",30.09,26.3,28.285695957039565,21.175591879380566,30.91,39.246070550809563,29.745402069419395,29.513820064040477]
["N130","367A Millbrook Road",45.924757440476185,56.847739720760032,42.916793639792452,40.75,37.53,38.76,43.18,41.260171235336529,33.801541537098124,37.265672927380024,43.650037767515165,43.455355340257597,39.164010394667748]
["N131","142 Romsey Road",43.906234195402298,50.141020343130123,38.504163981108988,39.36,32.44,35.840000000000003,37.229999999999997,36.861839123246384,"Missing",34.581473217848327,44.618282417341639,38.213069224354157,36.497941520660156]
["N133","539 Millbrook Road",38.144370535714287,45.175647827758546,29.095812260061081,25.87,24.22,22.18,25.82,27.380076740449258,25.495606685263102,27.582732745903527,36.867747796675424,33.299360727061028,27.987680037213686]
["N134","435 Millbrook Road West Ladbrokes",43.570166666666672,49.01663583014502,37.681606360059078,35.19,29.81,32.78,34.130000000000003,29.143460680621576,30.810270283612315,29.987915786117686,45.037976745910647,38.329270009471571,33.750265933101858]
["N138","66 Burgess Road",46.764220238095234,65.793567864022251,46.844403889308488,55.98,27.78,44.76,44.05,36.85035793872165,39.785060240966004,46.062629291880953,53.036311964821522,48.645425562307743,43.117278216734597]
["N140","5 Commercial Road ",49.216220959595965,65.933394195898032,43.566919809497982,49.05,39.19,43.39,43.71,39.86021285417786,37.952334572497278,48.688375158428386,59.565004166666668,53.509719817017761,44.45649406886794]
["N141","Town Quay Road",40.949404761904759,36.508520037409099,39.466470180677426,48.07,34.71,36.07,34.17,27.929330343796714,28.573625325884542,32.622212826505987,39.6442387843638,29.890415191115547,33.216826852503488]
["N143","102 Romsey Road",46.021482758620685,51.812776095612726,38.547012633147872,35.5,37.42,32.409999999999997,33.01,33.573995951692496,29.471525025543269,34.672712943191009,39.948439511653717,39.803231264149247,35.044816154229856]
["N144","208 Northam Road",34.090379464285718,44.733799566292504,35.305742685291321,31.66,25.61,29.14,26.58,23.348481823599119,29.470350754823293,41.193001221001218,33.923040322971836,36.499861731413738,30.345485961650102]
["N146","222 Northam Road",34.151803571428573,38.699518314875085,31.962767568120192,31.99,23.67,26.1,25.07,26.195255735423444,25.442049429465829,30.424357753357754,34.637209592929139,34.496409911285397,28.120051320458622]
["N149","44B Burgess Road",32.431928571428571,53.827597619112311,33.509839180195314,29.22,27.12,24.22,26.74,23.645985794529697,25.293972553359644,35.991165922029104,37.655674249617647,33.261541413230162,29.676122161021439]
["N151","134 Romsey Road ",43.886465517241383,49.242121421368722,"Missing",36.29,35.14,32.97,37.75,35.976556457802829,"Missing",35.172475105265654,44.787748760821259,43.49175145955023,36.707762041150666]
["N152","M271",49.118811011904761,57.020043136657904,41.467065900876129,31.78,35.58,41.55,42.97,40.599029852536802,36.927652521853247,41.956904047523579,47.469521897533916,47.969011647631532,39.86662310128014]
["N158","24 Portsmouth Road",44.479525862068968,48.186244595435333,39.081944875481476,41.35,34.049999999999997,33.86,33.770000000000003,26.614169212795435,29.931565691513569,36.345133827047285,"Missing",41.523782167921802,34.595354599636849]
["N159","35 Portsmouth Road",36.829047413793106,40.660290571866511,35.850629246682679,35.11,28.03,33.56,31.17,29.885731556595953,29.79447455094175,37.248801321931836,42.791376797221133,33.600690048940436,32.126155716867942]
["N161","30 Addis Square",38.492440476190474,40.528914807050988,34.827436569116649,30.37,28.37,27.21,26.67,16.79064406779419,21.054782543975236,36.185129725424417,34.990683565340476,32.062437281523259,28.485316350322222]
["N162","263A Portswood Road",44.307255952380956,51.616603550300304,"Missing",33.28,"Missing",35.96,"Missing","Missing",28.163891921397216,40.093574341937142,36.256051537816845,45.446957697506164,36.63320394390562]
["N164","168 Portswood Road(Int.Food)",38.041997023809529,43.800276816603741,33.863109652201643,34.15,27.66,30.24,27.73,22.37,26.662716349733138,32.956573576800515,"Missing","Missing",29.525144627980822]
["N165","8 The Broadway",34.131328869047621,"Missing",32.020820653534209,37.380000000000003,"Missing",30.8,"Missing",26.12,31.847702696000059,38.19481322353662,36.369999999999997,32.046493752293252,30.887486450089217]
["N166","14 New Road",40.531720833333331,54.146272517322828,"Missing",37.08,28.3,"Missing","Missing",30.46,30.767577473486739,41.353609418646251,45.962287032215663,"Missing",35.874920570719311]
["N167","13 Romsey Road",48.354186781609201,45.349465271881577,35.46091854934663,43.5,29.64,31.11,28.14,21.002785051509978,"Error",48.473040148389508,47.914890942694583,34.868810913857267,34.986100983921681]
["N168","23 Romsey Road",51.873011494252879,48.198875849621842,36.178473467766985,45.85,34.76,33.5,26.08,28.934988836174096,27.240182492011158,30.918854476197783,53.985989795171228,35.819629453116193,35.133850454484204]
["N169","150 Romsey Road",45.290041666666667,55.179227766425434,39.404908969300791,38.68,41.72,39,32.58,40.956189323780279,35.786748021442854,40.218404151280438,48.071530212267376,44.672077922078543,38.870832422576278]
["N170","Union Castle House (2)",40.007568452380951,"Missing",49.795244926802262,40.200000000000003,36.520000000000003,36.53,44.69,33.344166335258798,31.414899452460268,"Missing",44.699592279322999,40.312493735616485,36.968798761911287]
["N172","4 New Road",42.003169444444445,56.988859568085587,46.03928343844737,40.299999999999997,37.29,40.020000000000003,37.28,43.219098139295625,37.846192694789025,38.536859076507923,47.722980433004324,51.462618241225009,40.199952230274448]
["N174","166A Bitterne Road West",48.279348214285719,60.389795855244984,48.483024585896231,47.19,34.840000000000003,41.67,39.409999999999997,43.106732319601129,36.054187514026317,37.613122380044537,43.203088086887412,45.121595660068458,40.715469332744242]
["N175","38 Shirley High Street",43.669010057471269,50.233475049152702,38.104046428750621,32.6,33.090000000000003,30.8,33.380000000000003,35.237634333568806,"Missing",32.014261788457276,46.399945201413004,44.777939961880151,35.534988265749575]
["N176","Salisbury Arms, Shirley High Street",41.316537356321838,46.058289054194816,33.186716174065729,44.47,31.69,31.88,23.89,23.85076833608391,27.292321606498117,29.050923119871545,45.625593898095609,35.533885006352918,32.072990177740046]
["N177","95 Shirley High Street (Windsor Castle Pub)",41.613067528735634,54.693752690746884,38.924943909264478,37.119999999999997,"Missing",33.700000000000003,32.229999999999997,28.715269892969591,27.636139221094865,33.327056876858997,49.801786093352177,38.326530685346214,35.178395328680274]
["N178","2 Gover Road",29.360723214285713,33.362212300824247,23.603219860264193,31.97,21.97,23.03,22.27,19.402575724875216,20.737395148936912,25.24257353391631,31.899490903682402,26.890857886104591,24.004776264398945]
["N180","Opposite 5 Commercial Road",47.843795454545457,67.948657014165946,38.42488724127486,41.84,29.31,38.15,38.51,34.197003110242591,35.123703538505467,"Missing",50.964449434049392,"Missing",39.275062108728889]
["N184A","Redbridge AMS (A)",45.290041666666674,52.657552705818865,39.886100099113776,41.39,34.86,34.56,33.909999999999997,33.786854428563188,29.015323931138724,30.599270114704144,45.917900059494762,44.935282613605935,36.177645235480718]
["N184B","Redbridge AMS (B)",null,null,38.229292864227517,35.76,32.22,28.76,32.5,31.37067843777497,32.950641934448477,35.182420704571726,47.69104684015695,45.375921989818785,33.483720257702856]
["N184C","Redbridge AMS (C)",null,null,44.570160059471242,36.24,32.119999999999997,33.409999999999997,36.81,33.905682755979008,31.932706928489281,34.40592456526916,43.919971751421549,43.918653324280712,34.524678242796718]
["N185","Redbridge Causeway 1",57.288217261904762,62.109393192664577,43.422561320052772,44.84,30.86,50.32,46.12,46.015133112684246,40.100514176942163,43.329680383951832,43.758563353294633,46.302407890919639,42.971151478662129]
["N186","Redbridge Causeway 2",42.136937499999995,40.069202772075123,58.540522299299489,39.61,32.79,35.01,36.65,29.996956396607846,29.081244437851769,32.824015275278384,44.272672095809618,33.229182591879947,35.201331836082169]
["N187","Cobden Avenue",40.887980654761904,50.119865314656458,43.184392650312397,28.36,32.32,29.37,31.22,24.467491126987131,30.377901541514596,37.272612823767965,38.006177709501735,35.762317075524479,32.654527264519565]
["N188","Blechynden Terrace, Taxi",null,46.098443793474381,36.42869162486182,44.99,31.37,30.83,27.06,12.903841700629794,25.542495541023037,36.34189607097592,53.370983287802702,40.313423197108598,32.571117359160446]
["N189","Cumberland House",null,54.79434906696639,"Error",43.43,35.979999999999997,36.33,30.01,33.896445658969647,30.905848219810096,39.32388466413181,48.019397264079657,38.080839255086708,36.341681064001115]
["N190","Brunswick Apartments",null,54.145685044565006,38.696524888274546,45.71,30.4,39.19,29.17,43.37201980688539,38.535154233049198,44.590320659062101,53.693347838159951,43.922280884428957,39.011414547237763]
["N191","Marlands House",null,"Missing",51.275653857182121,"Missing",39.020000000000003,40.1,39.67,44.290688024558904,41.846988376718286,48.084784573308049,49.530761942551813,57.134645631844492,42.465197315303577]
["N192","Above Bar Street Bus Stop ",null,60.423068356662903,55.883412401167917,46.78,48.53,36.36,41.97,31.271228739074814,39.141540868785007,49.410020214841943,40.315688881165435,"Missing",41.857901229937916]
["N193","Above Bar Street Taxi Rank",null,54.044033410256567,41.891536434257752,38.840000000000003,28.43,27.99,27.08,40.059874724566427,31.045730623597176,35.79068557555172,54.668811230441683,"Missing",{"$f":"(AVERAGE(C73:N73))*0.93","v":35.32518249587644}]
["N194","Vincents Walk Bus Stop",null,68.555489427192157,66.505648918478883,52.13,47.6,45.96,"Missing",34.725370998488962,34.272592134743419,51.129931975405896,55.796329999999998,12.236958487942779,43.608845940629458]
["N195","Bargate Street",null,53.269427283729449,42.524696339430157,51.44,35.33,37.92,30.61,29.48766655863427,41.272747269723631,43.841302605206678,"Missing",39.790826971757674,37.710260033648822]
["N197","351 Winchester Road",null,null,35.339685675804425,44.86,35.29,44.97,"Missing",34.726699310043237,33.535038871446304,45.489076257700823,50.453593594519624,38.23535946111997,37.499610160965567]
["N198A","Onslow Road (A)",null,null,43.727207777077311,34.619999999999997,33.99,33.57,30.8,29.337017582911304,30.650780586000256,37.427484062809917,43.06630478661836,41.839356948230716,33.389618112159255]
["N198B","Onslow Road (B)",null,null,44.139268454735529,33.53,32.799999999999997,32.299999999999997,28.33,32.215597596265859,31.081614851265314,41.933578280614533,36.976320645903563,41.839356948230716,33.028553520262449]
["N198C","Onslow Road (C)",null,null,48.942055455318332,36.07,33.15,33.11,30.7,29.971181524712552,31.389353612168936,41.462792317560314,37.829315167241461,41.90141012872494,33.900928063132568]
["N199","Dorset Street/Charlottes Place Crossing",null,null,null,43.14,40.630000000000003,"Missing","Missing",23.784525438859127,27.91,37.921094569577463,47.063705872130669,51.117384186418235,36.079577194613783]
["N200","Northam Bridge South ",null,null,null,35.49,25.96,29.22,30.06,29.97,27.522113918372494,36.556268620268625,35.410892968707302,41.853623738152187,30.177766255368393]
["N201","289 Millbrook Road West",null,null,null,58.64,"Missing",59.82,"Missing","Missing",51.069215694036593,48.891343610688551,70.197593424488772,"Missing",53.682976407633795]
["N202","Redbridge Causeway North ",null,null,null,48.33,"Missing",43.78,49.52,54.075018348401692,38.844383243583898,52.334467598735806,56.757409537032117,56.314749279216038,46.49488825581021]
["N203","100 Redbridge Road",null,null,null,49.34,25.35,"Missing","Missing","Missing","Missing",37.111401089069716,"Missing ","Missing",34.658434337611617]
["N204","6 Lodge Road",null,null,null,38.69,46.03,33.380000000000003,30.41,31.764519154462697,33.956675619673732,45.959735040589713,41.889836315015387,42.11,35.566379166739956]
["N205","Stags Gate, Lodge Road",null,null,null,41.08,28.47,35.28,33.29,34.185741631394585,34.804039907901725,"Missing","Missing",47.941062921391293,33.885326478348496]
["N206","Charlottes Place",null,null,null,46.03,31.62,43.92,37.799999999999997,36.655646072987118,40.530598959628158,45.959735040589713,54.188158071009255,44.330475241996986,39.373576716575158]
["N207","205 Waterhouse Lane",null,null,null,35.1,24.6,"Missing",32.770000000000003,34.246557801594712,33.369321078234265,36.032602089648641,41.366661729849973,41.237087990721179,32.401459317718171]
["N208","Sherwood Close",null,null,null,38.5,29.64,31.79,31.23,25.493549701378914,32.007394897411928,42.152725826187385,44.606745499150762,39.805558797717481,32.573350721257469]
["N209","40 Burgess Road",null,null,null,33.54,29.49,26.66,28.97,28.074131536911832,35.279487179489081,38.379585483772445,48.125136192168362,38.37213817870807,31.712016119008485]
["N210","18 Burgess Road",null,null,null,43.27,36,"Missing",33.64,32.297673449544583,35.28,44.65,48.048716761930699,44.032842801175946,36.876735837720709]
["N211","4 Coniston Road",null,38.577031486569467,23.869705408681924,31.94,22.84,26.3,24.52,22.990523639329833,26.585394730315564,31.428118557226984,33.721400917083287,30.802105203623967,26.511280031530259]
["N213","277 Portswood Road",null,43.310219417185273,33.571932538296878,26.96,26.36,25.9,25.18,25.521850963321011,31.519381597238592,33.820546767742151,32.790541071057078,35.208072317083705,28.757506049535454]
["N214","64 Burgess Road 2019",null,"Missing",35.402632891193363,41.45,34.380000000000003,31.33,30.16,30.68,31.519381597238592,39.91614574832348,43.004039155792839,36.934801812462275,32.994261112065985]
["N216","73 Lodge Road",null,null,null,"Missing",23.76,34.31,"Missing",32.613827601182841,34.100135556798463,44.531543736211937,42.811063094204243,44.576799582707864,34.104876243018282]
["N217","11 Saxon Road",null,null,null,null,28.89,29.92,31.12,34.855969228019717,30.502408293460924,34.516835745899257,42.692618800895588,39.740239048447926,31.647675767319097]
["N218","112 St Denys Road",null,null,null,null,null,null,null,null,38.08,40.98,49.963990791619885,34.956889866311236,38.125554752968988]
[]
["Closed sites"]
["N102","64 Burgess Road",41.215575892857139,"Closed"]
["N153","Coniston Road ",35.50313392857143,"Closed"]
["N154","Oceana Boulevard DG5 ",35.134589285714284,"Closed"]
["N157","Admiralty House",27.354202380952383,"Closed"]
["N160","2 Dorset Street",39.578358024691362,"Closed"]
["N163","285 Portswood Road",34.35655059523809,"Closed"]
["N173","19A Burgess Road",34.80699404761905,"Closed"]
["N212","Mitre Pub",null,48.901141814777525,"Closed"]
["N215","Roman Road M27",null,null,null,24.27,24.21,22.44,7.18,"Missing","Closed"]

{"sheet":"2020","index":4,"n_rows":96,"n_cols":15,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2020"]
["Status"]
["Bias Adjustment factor ",0.81]
["Other comments"]
[]
[]
["Site ID","Site Name","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","Bias Adjusted Annual Mean"]
["N100","6 Sandringham Road",12.37348952269851,17.351939565472591,16.885357939969911,16.331877520161768,11.79701429005932,11.190601524991978,11.756386423930936,13.918448265651435,14.529978448275003,20.725342692993078,23.655366139755575,26.120813138898423,13.272971544417951]
["N101","Redbridge School Fence",39.683334185634997,44.171544668591608,32.331356245189141,35.970825583840906,31.201061026354807,32.898614525139664,26.565572013395538,34.689027326731875,40.215939317316888,44.217227936426227,46.021635916655555,45.181249256401259,30.587448690113302]
["N103","485 Millbrook Road",38.913490797539069,28.165901505707598,26.922549856085848,32.460354239144991,24.938289934479279,27.827421762276408,19.748136899719402,26.001002317607433,26.50912262958671,31.476840894387038,32.808345752605206,32.834442044351235,23.530898157760589]
["N104","Regents Park Junction",48.101998466652489,39.926965758674427,37.811964221455938,42.027789285364172,35.539029898750236,37.720549696538647,23.567462548503755,31.589916219376555,33.658236409605614,37.951768174301982,42.076703427716176,40.66925153082795,30.418310405549335]
["N106","2 Romsey Road, Oakhill",42.112250299040134,36.03377968484255,29.336114767043799,35.339282920474723,28.488287861267843,35.554347931289534,26.381422550575319,32.680359300476191,35.386119713082309,37.195288740159747,35.276685691596171,36.673513309192707,27.705878061910269]
["N107","Cranbury Place",40.065471163742707,53.349990050673313,39.699373749772292,36.025014286917688,32.436485339253238,34.248386509447037,37.994834657085455,33.28641640442752,34.391671890881227,40.694459826337543,52.279799011763139,45.880771863117864,32.423805545855785]
["N109","72 Bevois Valley","Missing",28.152741827266826,"Missing",30.473360660907751,26.368996714466764,27.756612616515032,24.969498111495444,29.722321758370583,31.554424221874928,38.080190253972496,44.355491721144276,38.213789604954634,25.891441626768469]
["N110","Brintons Road 1",18.227058101156999,30.111909836066417,24.659699352195656,25.982009680779733,20.71300057934824,23.983711724695162,21.252860780181557,25.778265795551942,27.795487527863973,32.882056994255578,37.847368596330334,33.402522752304662,21.777926741149287]
["N111","Brintons Road 2",28.576140916414158,30.529854387657558,25.391034272742701,25.189566815759196,21.595970408663263,21.866987349284429,20.83766447678363,26.984075952866,28.110947033224345,35.476125690755609,34.571234389747261,33.530135064634386,22.454532231200947]
["N112","Brintons Road 3",15.333539028319793,28.002284956606381,24.979658379934985,24.93665951841222,22.239802575872137,23.056551461085501,22.680098073111942,26.544118192764927,27.129517460992073,34.170146278034899,34.502504301497268,34.630791258478233,21.478882825244948]
["N113","206 Bitterne Road",23.956414053357435,36.451868300150778,32.885401277279222,27.260941737132843,25.952811447406543,26.852790647430503,29.634031515274959,33.940908115409613,37.713524242995597,35.763394881301537,36.293077635988944,36.564240195134118,25.870684773298187]
["N114","Bitterne Library",26.657672263489093,34.326465415226487,31.98047731807803,27.889982496470264,25.894267080744619,30.561608527599272,23.198791816008349,33.236835578873908,31.396959544877586,35.666153041829041,35.116839353616051,34.56596178787337,25.008210960166313]
["N115","54 Redbridge Road",33.106054219944909,36.221459654181714,29.550098461535814,35.018174132489541,28.875733148021794,28.301891503595037,28.301891503595037,28.301891503595037,28.301891503595037,35.233808085165833,35.546819809067976,38.364869203332027,25.995909334148088]
["N116","57 Redbridge Road",38.957117398535871,31.679998561844378,31.598401231399773,35.167345370563048,32.396946944262957,28.949162718842214,22.505402087474497,30.074644611728111,30.279080944350017,30.767065514758819,38.002351156430947,33.012063534847158,25.878796655065052]
["N117","Victoria Road (Lamp Post)",34.400802688431106,31.784304176902356,31.878269776387665,30.6658793211794,28.224079056867744,31.405737515685651,30.12889969155016,31.77494332104644,33.459079489696734,37.80276265902512,43.8374994583871,34.079744919248547,26.962335140022539]
["N118","3 Rockstone Lane",23.868629026030053,37.205930176062267,32.918550624131512,31.356645378152027,25.913811659193875,24.81683564879836,"Missing",27.54314590313933,29.446101838514469,30.784103208434558,41.25040589877861,37.666494642740034,25.24038452211089]
["N120","6-9 Canute Road",31.15170881995062,35.973057413246572,35.518377053649623,30.383382194758653,26.125931498992923,28.818879738781135,28.193380793551174,34.331980952380952,36.116029212999194,33.79189487017598,34.192727042436957,37.245987153350889,26.449425230238543]
["N122","151 Paynes Road",36.21492539600569,34.756245414666274,25.408741868295689,35.955832223433703,28.694767361525514,28.757093413563918,19.072791426809438,25.548848012036764,29.448782553733793,31.274953244135965,32.726324888223694,24.458626634960076,23.781460439523865]
["N123","102 St Andrews Road",28.569516943040142,32.077579906476458,20.797912571636374,"Missing",26.011275512481614,25.043334601726123,24.547709813292261,30.220384045515672,28.777947466687451,37.068347166538388,38.807729428408031,36.516047032477104,24.184964130500592]
["N124","305 Millbrook Road",39.690031421643404,35.8147119765962,29.819361390336265,38.663596859155547,31.821887313878193,32.271874269517262,23.611708382589928,30.554363737174612,33.675630847026596,38.217245397007417,37.032420268262761,36.168290334082307,27.49552574831576]
["N125","Princes Court",31.742438861292793,32.63049419414417,32.551557270186564,31.797081505230093,29.872291487535232,30.546922633629862,22.620067194265694,35.56949011197883,34.658482549320212,39.072317049990062,39.543067857821271,37.86807439951864,26.89687924525666]
["N126","107 St Andrews Road",24.658214028225817,32.017882177113883,28.131982615439171,27.773759166578913,27.007952210811208,25.077177947826684,25.379671821953423,32.20943303042646,32.106571471006504,37.927073355724602,39.952500208007095,37.96648801019662,24.989087657923452]
["N129","South West House",24.861624474583969,28.070616759542272,27.478031953525637,28.238172040745798,23.191320051593848,24.934078893663461,21.30995892764204,26.600733333333334,30.181916210251277,26.700599151311415,33.323463170566207,31.54394023306542,22.034325725988165]
["N130","367A Millbrook Road",46.366089689544495,43.690153469858046,33.613226743437401,41.354950800115446,43.779679332937484,41.495668415949154,34.302039777981499,45.125770419079821,41.972777496836351,46.562529843233918,44.188740685540125,44.610961873811853,34.226724727011977]
["N131","142 Romsey Road",41.781005232993991,36.521472677054945,34.504482989618268,38.119784876137913,29.967579190753458,36.135167886736369,27.738406030704962,34.458320055621719,34.83480682662092,36.19119374655196,37.506854420484977,37.358837921704534,28.695459050211422]
["N133","539 Millbrook Road",36.723497379520829,31.093822584516445,26.138917501925178,36.428121645796068,23.67957498511084,24.379051623335531,19.938530318599874,24.367167194929248,26.335178255376821,29.91172969086487,33.238955290616794,31.837115338877876,23.224837172139249]
["N134","435 Millbrook Road West Ladbrokes",37.558113738016935,34.1451230038912,32.186491043203176,38.302561574392641,33.827964264444056,32.117224944653309,22.909275913460167,31.379219189479866,31.953581542349102,35.080107851597965,38.713847988074136,37.937998097576099,27.41252686770186]
["N138","66 Burgess Road",28.070484942087464,41.875909564251053,39.861700527920732,41.385498054875711,42.701580638160401,35.267840496930887,37.155770529360026,46.458466194565091,46.735815262449094,43.481578959518522,46.610625564956642,47.9366020072491,33.584076410106924]
["N140","5 Commercial Road ",55.511248275516948,40.827609451001031,40.415067285382833,39.814017721521921,30.171294457272801,38.445365367184472,30.755411764708651,36.35194997021533,"Missing",43.843530297028693,51.499036778939214,44.813860326891408,33.316654297589757]
["N141","Town Quay Road",24.411659102852092,25.558836470707575,33.261502648710604,44.01023028258227,35.731003941233737,28.005570440799389,21.433790202131085,34.982034462924865,33.131189285297381,28.172332643491472,30.142303923636604,31.878544615386044,25.023532366333335]
["N143","102 Romsey Road",40.856299434328811,43.301609824655536,32.909399885145845,33.975940026080771,26.181865895950232,31.686233742665738,27.243045149133149,29.084598509689052,34.324331931731884,38.29260290186825,35.767459242160477,35.850915492958244,27.639515387454839]
["N144","208 Northam Road",32.88595529232073,31.39984952978056,27.919995210346688,24.46392685395886,23.443766509828798,26.125812663578234,22.600647088100917,30.42498490866048,30.967971170256202,35.560455701020217,33.599040604438855,32.30832423644263,23.739799259389493]
["N146","222 Northam Road",32.747944688575977,30.420079409306705,25.967009420406036,24.061419773917866,21.097922040696176,23.389771417594165,19.930157544990692,27.115798713160526,27.381729217154437,32.813694939410091,30.891553813252177,27.57978553732228,21.829288489815632]
["N149","44B Burgess Road",29.940433976836669,35.570775211733874,29.691883115153129,28.957178726892501,25.067947126239982,26.841435645713698,32.303847336530261,32.713133813288458,34.622721280814652,41.250313106117595,40.565195623961145,34.916784178119713,26.489811317044612]
["N151","134 Romsey Road ",38.612010166702028,41.185386436502881,34.961258523747837,37.312542372878525,29.903953757227445,38.355397459161104,28.903111331514165,34.100887343531113,36.121203561709521,34.066160816330573,41.543303225808849,37.787299383325646,29.217544720544687]
["N152","M271",50.756986189252267,44.546661545848586,39.338665127020782,42.688993913961141,38.875025962395235,37.226900334798266,28.769750932140191,41.227958019801029,40.54612563237675,44.043045729079005,47.598850826519744,49.092349406877219,34.068013669354741]
["N158","24 Portsmouth Road",38.551627851142612,36.936322850120739,33.684572733829306,34.730448774353206,33.082652183962956,34.865340526978201,32.455212734450257,38.103111155380255,35.281910696762537,38.03201845298225,40.796110629695875,37.280017880554254,29.281455886739337]
["N159","35 Portsmouth Road",37.720858171346293,29.370563144961462,30.270461649434111,33.709982401003188,31.494589595379111,28.774781932247603,31.530617320500614,33.307800358639497,35.646476938175702,37.042346745309196,39.717315523469047,38.17753516090319,27.45652470354241]
["N161","30 Addis Square",29.860769665524725,30.193343383270218,27.206875150351859,27.61785137487772,23.98057965961025,21.890265812374267,24.385673557092463,27.981642996822067,36.327788428021677,34.530404349002808,39.649761170475173,33.130991496638266,24.081026425474153]
["N162","263A Portswood Road",16.22031847951666,39.280435931920636,34.427845055740804,28.653161504101814,25.600231433052837,28.322710448277959,37.828921307504721,30.406479707711359,"Missing",39.932028474544985,40.734271097290659,35.883955097913343,26.309562765039676]
["N164","168 Portswood Road(Int.Food)",28.269448454795274,29.348193961320948,28.998063515825134,28.495550895443234,21.110931327661927,26.438430744599405,22.713031871426121,30.984235735434304,29.472004707732555,33.009731332551304,40.399731765048791,32.764500569686568,23.760260204502977]
["N165","8 The Broadway",29.96603950985482,32.945028173907708,30.501170431759508,30.864705808346319,26.886919253579531,27.761553742610641,25.712230159214773,32.445372786667789,30.826830448620761,31.285768392675809,40.399731765048791,35.84609080934765,25.342297286510302]
["N166","14 New Road",18.840518869132502,"Missing",31.220588039864094,29.203555482939702,28.274316461628853,28.444618215662381,26.132575204530195,"Missing",34.303037306185807,"Missing",44.333833893315727,"Missing",24.376245651667499]
["N167","13 Romsey Road",39.639578889669167,26.545610928904498,28.987794388502277,37.886581486307428,28.345130635840057,27.025120416315023,21.642833969936859,"Missing","Missing",57.919918755617196,34.984674473997416,38.881393850192566,27.690549661417883]
["N168","23 Romsey Road",37.50397278707873,28.355291942003021,30.865922399772764,"Missing","Missing",26.50701912601081,22.542088241863116,30.155289701063364,36.46832649022793,35.487890428849383,40.638943999209069,39.079982496623366,26.535982936628823]
["N169","150 Romsey Road",46.904512945742873,48.876104453324018,38.234622138228701,42.425078226854673,35.757493641620904,44.328820788962929,30.565698343416372,41.145805721093687,38.448969082372329,44.719417887899112,44.081238648212924,40.542989616892626,33.482075725886936]
["N170","Union Castle House (2)","Missing","Missing",32.212961862708752,32.151914220646823,30.326522559531568,30.423602708157858,27.433063673018218,36.036191194272064,38.527418719910393,35.061140710097419,35.880163380760735,"Missing",26.824768112619349]
["N172","4 New Road",38.61039068696661,46.647199093606702,34.786043189365408,29.221013480392159,27.241529805762337,34.876314364288532,35.241530766331564,38.277757742676627,41.384253754999364,43.721580167716496,41.399640129952537,44.202894010998278,30.753684935531322]
["N174","166A Bitterne Road West",34.83615560968213,43.849748456861512,40.756286261780296,30.877249841872235,31.988195891064571,35.255435100943814,30.558049885492739,42.980641058760014,41.332666891435466,45.82627821871381,43.295631861601613,47.256359835074861,31.64485717664661]
["N175","38 Shirley High Street",43.202951847704369,38.512423688634726,"Missing",58.013827900908247,27.231685549134781,30.4821682593461,24.597171186357642,30.881858079904589,32.343689339597447,38.268727658531148,38.822669743899887,38.450303211172923,29.514005085164129]
["N176","Salisbury Arms, Shirley High Street",38.78706748955122,26.767768558304009,29.298708179772479,35.608363754894583,27.486187283233296,30.958374160767409,22.347844021914796,30.862381794696287,29.709638882016595,30.724662000855382,38.371005782069695,37.430480264207425,25.538792546629118]
["N177","95 Shirley High Street (Windsor Castle Pub)",39.003897066394515,32.275372190665287,28.947249880323902,40.380063885264207,30.826522543354674,32.577251285148115,22.201286404760236,28.111520127227188,30.097599802125398,34.982078547382621,41.650895148279012,32.604395145248503,26.571923911766724]
["N178","2 Gover Road",26.993881119774215,23.323585693711646,21.861875288683603,29.112241813606282,22.985043867499844,24.6407638423936,11.818636973703079,24.408492157795354,20.151250421584663,23.424625781869423,28.587371853917034,27.600674832446682,19.231319946171517]
["N180","Opposite 5 Commercial Road",51.126953500257009,40.36865740096637,32.753443155452437,36.400392405065972,26.501168591222235,35.601256572986536,23.191359731715362,32.306946093516579,"Missing",41.557373309303969,"Missing",42.319451718328274,29.332287200783995]
["N184A","Redbridge AMS (A)",48.594718342295714,45.665219582433409,31.865547576299711,42.039783704324883,29.356363256784967,36.499284649773287,24.48271592091529,33.228851271088523,32.436900505901399,40.170818351791262,38.916966867021458,45.091902525999856,30.263562397437507]
["N184B","Redbridge AMS (B)",46.377227935541676,42.03973794096472,34.08872531418109,36.786977740444293,22.845493389004872,33.956637853946383,23.599711652794699,32.039491505288694,32.054061551432603,36.503805871778489,42.369038380327872,43.701691530457602,28.779475544966004]
["N184C","Redbridge AMS (C)",45.933729854190858,47.725602591792651,34.08872531418109,37.28972154556817,32.286254697286012,33.710575260801839,22.798759102393813,31.127775665400097,32.339306767868443,36.785597240186043,42.991747167565599,44.35590846953631,29.796774998182041]
["N185","Redbridge Causeway 1",54.466225460112973,53.148221635894295,44.722935011552522,41.528213641138329,43.365804746974902,38.832687435627548,36.82881747688765,38.935320893747431,45.714451517705449,51.650587841082356,54.480496448593392,54.2886171626661,37.66246060085885]
["N186","Redbridge Causeway 2",41.108177914103088,36.653263132652881,"Missing",30.422838195176855,38.015128274006429,26.915622971925693,29.58174742806229,"Missing","Missing",35.871560928895335,"Missing","Missing",27.605764923472329]
["N187","Cobden Avenue",19.191166214642024,40.080675650735863,31.957385876552401,31.034297808139865,23.108450997848244,25.753849362387651,29.481791342149407,35.258172387064697,32.1185811196315,41.966315132330521,40.78275328027329,40.657653628931691,26.418898764046382]
["N188","Blechynden Terrace, Taxi",42.790156086351999,35.874751911043532,31.122730273337705,39.997160514661324,28.30195842155792,28.781666465258819,21.660840557277492,27.829400833825801,32.435441029312045,34.104575593138044,39.613816370256352,38.623858175692192,27.07670404564065]
["N189","Cumberland House",44.264932406524601,35.572048780487805,"Missing",31.743501792872259,24.524609549479617,26.878046511628852,24.901464585214065,30.87478630273452,36.389063616866167,39.060724881659553,40.718741998764528,39.523228285625748,27.573220950600433]
["N190","Brunswick Apartments",49.098998921251344,38.277070214338508,38.189976869695876,34.729252538068501,24.577023685730794,31.032527173913046,30.635523096777874,32.6578249305295,40.24433738384225,45.472721042620428,44.486734973034714,41.076685748238262,30.407310669017772]
["N191","Marlands House",39.479573305846642,50.593513565521683,40.929635145602703,35.33065656153336,31.271710975688009,38.575493082883099,44.547262601461767,40.311360428236213,37.984915851930758,45.709339514331504,45.914272782801937,46.262344952644739,33.541430316872564]
["N192","Above Bar Street Bus Stop ",28.824184701204665,51.269856404083249,38.618279956824473,32.328155169238279,30.776912601858484,32.914040060068793,40.265175115631784,41.042169405517917,49.167306595706414,49.287037823312161,45.547508746607086,47.313399949838129,32.896396790767675]
["N193","Above Bar Street Taxi Rank",27.163448488274195,39.692477871851594,32.792169074902603,30.925921931490461,25.526844678618605,26.226465872797519,28.705173227605027,33.214012208654133,32.243841571609629,"Missing",42.132018659405873,39.053663626019357,26.337962740099588]
["N194","Vincents Walk Bus Stop",47.187638407635866,54.04848662688984,43.605844637617523,34.448084558823531,36.63988033578034,47.319389157976879,49.35886462331635,44.908093379045411,49.881096937696775,59.372191380102095,55.93772840877353,46.433042203531386,38.416972994360293]
["N195","Bargate Street",40.746218526227295,35.305114131084437,38.326520679918552,34.850625574413833,33.54430131053131,30.899671194619064,35.233771976716866,36.15121564586876,43.262175640266882,43.348763295281515,52.033202832158317,47.728372622396911,31.821521856490158]
["N197","351 Winchester Road",23.9893611654465,35.611454490751022,30.530716190273797,27.737283068061462,25.895569400427572,27.14565862345766,22.74777087730196,30.76556764483707,25.040279853991628,36.918961512708421,38.348257110399416,33.613447337906074,24.188242091100474]
["N198A","Onslow Road (A)",33.236410387750958,38.168379872152855,33.247063530166685,29.641529087968021,25.087157473116953,27.198890213503162,28.570056169594732,29.418161397671263,32.915996286170952,35.322072694635807,40.160659776102491,37.232047571763893,26.33839365109035]
["N198B","Onslow Road (B)",33.447837934746829,41.362303551683318,31.573701392224518,29.121197974662554,25.734104227438021,24.514789205591669,28.420474723680623,27.729764975042269,31.404330221282116,38.10042135965697,42.584487623237237,34.075607004790001,26.194658863097445]
["N198C","Onslow Road (C)",24.398738923323538,40.628296246449608,34.215852136343727,28.739621824905214,25.428601593453077,27.25257223366139,26.700288095668377,28.302102745424978,31.084964151235177,38.118943684090446,45.85566992099632,36.848391812242212,26.161247927326102]
["N199","Dorset Street/Charlottes Place Crossing",23.196328274948765,40.376537543685956,42.718078019878462,37.92000857808403,"Missing",34.081926605508947,28.881185012880856,35.570960983520585,37.955057151941965,46.877644949190454,50.278332639990587,42.411806703217657,30.946997439537011]
["N200","Northam Bridge South ",30.441196025985136,38.928993266769758,33.063781036275671,27.089146544630552,24.332203406028167,29.792225797155957,25.005156424997267,34.659137687920534,"Missing",40.696462510687944,39.558922835690396,41.673279653141321,26.89498265484718]
["N201","289 Millbrook Road West","Missing","Missinng",42.556890522955761,53.646561176827596,44.645045860632564,42.081683906895655,36.638336288651132,"Missing","Missing","Missing",56.881469448579267,"Missing",37.320748272613166]
["N202","Redbridge Causeway North ","Missing",55.287004320678953,41.827925051335953,40.168427612257389,"Missing","Missing",32.717951221938044,47.959257880560379,45.992879848228206,53.445112533258424,53.437000522811665,49.247533697916403,37.8074783420087]
["N204","6 Lodge Road",18.682960098979947,29.761744056981247,31.512192461902696,29.939260394791376,26.430360423109537,28.233217673814163,29.380157837444955,"Missing","Missing",37.01648921121803,44.316342758718946,35.256112928073527,25.152835865447791]
["N205","Stags Gate, Lodge Road",19.258982290619787,32.262570530018152,31.401016278634824,30.901824980039393,24.770331382322663,30.057673763776194,29.854433962272978,36.142054393798972,38.174115723379749,38.768606397525481,43.722832332603566,37.851548118924796,26.538704335389372]
["N206","Charlottes Place",41.824092932809684,39.919806190337091,35.998380353830157,33.333181790331949,35.525929118566317,27.206207669214891,32.906375781964861,43.434016127757332,34.242858596991454,43.915901592316139,41.120166403198127,46.368085032436817,30.766162607308448]
["N207","205 Waterhouse Lane",47.520225344917101,41.573956834528893,31.260165038558544,42.684217075842334,29.304457415128866,32.869672718222631,22.995897725813357,28.659701356572597,28.61384955752002,35.325156418554478,34.57179433681673,36.85314985437013,27.825676448187082]
["N208","Sherwood Close",25.469262187429248,38.93209580007256,30.484253605994873,29.805332127759119,25.875963446137629,25.783556752529254,20.606768562902197,31.626182719964607,34.86199752103802,"Missing",33.446055971358426,25.935745461445631,23.771822133351961]
["N209","40 Burgess Road",22.874975278120729,48.885936502055308,30.397022876343748,27.391860885650448,21.75491794738576,23.578148212500675,25.186050465769352,"Missing","Missing",35.017017179277424,38.881357315042003,37.56410660818333,25.234042854896636]
["N210","18 Burgess Road",38.96623628779232,35.514286441579699,35.196332755630394,26.209823174451067,26.433193678631131,27.397270318403827,28.79385566140866,33.15007086285631,32.762514181394891,39.686307234063051,48.601696643790696,38.10372074389781,27.730033288913244]
["N211","4 Coniston Road",32.861095932460614,26.07281007194026,25.399601231716709,30.966414357687157,22.361840161180254,26.596717486476333,13.746006262738547,26.029067575063436,22.100248735243976,28.13126959021815,31.155554891715649,31.339355546996082,21.381298774432011]
["N213","277 Portswood Road",25.042065599880157,30.949854628917183,26.065734680784267,24.928756264810357,21.714794604136468,22.050614948375394,23.812452556071609,26.929527871568244,29.558102771964727,33.843486757869904,40.399731765048791,30.692327558918887,22.679152875563354]
["N214","64 Burgess Road 2019",29.387192607655063,35.55249438826241,31.695664693653146,31.352257223363129,26.448243797621533,26.536046738915015,23.493707153840184,32.153504371563677,33.966762075136408,37.26720160712788,36.2782208830697,33.785382896176657,25.509375794455977]
["N216","73 Lodge Road",26.131282897276655,31.786783682530359,31.842351714736509,28.811815795556043,24.239366620235046,28.269590850999499,26.28408732198988,33.699173700751913,24.420113621522418,36.287065214947376,44.158352231949891,36.37093072817072,25.13031172069498]
["N217","11 Saxon Road",39.49427242524095,32.185760556620984,33.136376416069879,46.190928571428572,32.143701001430614,31.08590760059343,21.530287037037038,29.710278240192306,32.311574328749181,40.932615017877289,41.819714214836232,37.674881792937576,28.229600061203449]
["N218","112 St Denys Road","Missing","Missing",33.370038636790447,25.310958489293157,30.564932357603684,26.88255077879294,31.178316024632291,38.00188106217503,35.31536412152775,38.387304457049879,39.778403881550133,33.279766089261969,26.89763078779286]

{"sheet":"2021","index":5,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2021"]
["Status",null,null,null,null,"11 saxon",null,"nov"]
["Bias Adjustment factor ",null,null,"Not available, anticipated March 2022",null,"conniston"]
["Other comments"]
[]
[]
[]
["Site ID","X OS Grid Ref","Y  ","Site Name","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","Undajusted annual mean","Data capture"]
["N100",444387,114453,"6 Sandringham Road",26.730834326578798,24.738317483891333,22.080795269656416,19.409979935174484,15.31256633254533,16.23410224862193,15.85,13.953990256865202,18.112231573788463,22.900400604868278,25.858171148420897,21.062795390767842,{"$f":"AVERAGE(E9:P9)","v":20.18701538093158},1]
["N101",437548,113719,"Redbridge School Fence",44.752504103048437,43.726153618323877,34.370173286986095,36.787947165443775,36.301647321428568,40.193473600167167,39.79,30.569492886538736,44.476875090107434,46.539944013079449,46.137923305293079,42.1487119981457,{"$f":"AVERAGE(E10:P10)","v":40.482903865713531},1]
["N103",438808,112903,"485 Millbrook Road",30.960574869966834,32.993973467198046,28.764602498010309,23.433501427212502,26.241409337734222,26.485182271907483,26.99,21.529958886470435,30.811759121367732,30.017112591687262,31.031805493689678,28.655931180197513,28.159650928786835,1]
["N104",439222,112850,"Regents Park Junction",33.82299539514721,43.113002222800233,32.730300327087214,29.277834033781925,31.541346787989617,31.726182870835451,30.39,27.196953258528104,39.887477227728176,33.488706728042828,32.114547884187083,41.48114704994925,33.897541148839757,1]
["N106",439752,113984,"2 Romsey Road, Oakhill",36.92409074484798,37.401326797698943,30.219125801315773,31.152801666220707,33.815000899397134,29.980788365543244,33.15,{"$error":"#N/A"},35.627094975957554,38.520702746877909,34.790131483887855,38.539109246105397,{"$f":"AVERAGE(E13,F13,G13,H13,I13,J13,K13,M13,N13,O13,P13)","v":34.556379338895688},0.92]
["N107",442364,112890,"Cranbury Place",48.772128583838729,43.250267899188643,39.448751133839778,41.978766243771645,{"$error":"#N/A"},40.090678782757678,43.73,40.663480815755641,39.89980765304589,48.315607942285276,55.03191296598461,32.386682988001006,{"$f":"AVERAGE(E14,F14,G14,H14,J14,K14,L14,M14,N14,O14,P14)","v":43.051644091678988},0.92]
["N109",442585,113248,"72 Bevois Valley",38.030954601836868,43.234094728228094,33.213393408459254,37.692212007608262,{"$error":"#N/A"},{"$error":"#N/A"},37.979999999999997,30.201191804499661,33.820754416415866,37.9598606910927,37.29510854766486,32.532624791016659,{"$f":"AVERAGE(E15,F15,G15,H15,K15,L15,M15,N15,O15,P15)","v":36.196019499682222},0.83]
["N110",442579,112248,"Brintons Road 1",33.933604053346876,32.904172469994421,28.946428267510647,27.878405238831466,{"$error":"#N/A"},{"$error":"#N/A"},24.1,21.587037388695379,27.591730872281506,32.278132122677668,34.678254858684532,27.979397338744917,{"$f":"AVERAGE(E16,F16,H16,K16,L16,M16,N16,O16,P16,G16)","v":29.187716261076748},0.83]
["N111",null,null,"Brintons Road 2",32.662375381861978,32.822625574158003,29.872458515450869,27.009192604008586,26.03311782178293,22.140251072553966,24.67,24.383395519517553,29.115502232805362,33.463703326235738,32.900445590612733,27.519641983413425,28.54939246853343,1]
["N112",null,null,"Brintons Road 3",37.111675732059119,30.233511631351753,25.737254477235062,26.73358859784523,25.992249504951243,22.890472346092047,26.35,22.625079422106644,27.296807383147854,32.545841749287561,32.373687288961825,27.618160988127318,28.125694093430472,1]
["N113",444124,113288,"206 Bitterne Road",38.17916611244101,32.522395544316076,39.975574961050221,32.461497181866896,34.112885101328992,31.122246441448894,32.83,29.130574282428192,35.466725681683194,40.234559149309533,45.089857827434031,33.788772461721415,35.409521228752375,1]
["N114",444131,113322,"Bitterne Library",32.837456833710696,33.782807833532516,31.141856525269215,28.919565021832739,35.135453599561153,31.329760893594319,34.31,26.077325487010523,33.50702442590331,33.16790066456803,35.560445315189121,33.337682285011951,32.4256065737653,1]
["N115",437939,113474,"54 Redbridge Road",32.66215219443891,39.725876746831204,30.840078829943682,27.759152993859345,35.523608630952381,30.737928487297477,30.11,23.821715007551532,36.013748715555437,33.762258463469315,30.431077905053911,34.484509526350465,{"$f":"AVERAGE(E21,F21,G21,H21,I21,J21,K21,L21,M21,N21,P21)","v":32.312820872386332},0.92]
["N116",437952,113407,"57 Redbridge Road",32.184009560033275,38.450871178395197,33.51221567217268,34.164227245691826,30.834901785714287,27.688203112530573,30.45,25.233062739757024,35.812772874838686,33.84494665848689,33.074715664439495,31.695523676882789,32.245454180745227,1]
["N117",443752,111121,"Victoria Road (Lamp Post)",37.753933038335369,35.764249934211861,36.261342934297772,33.28711018463602,33.61074064670575,32.652184959606963,29.47,26.541552694511619,36.512066688989165,38.813365223015204,38.305371920587824,36.967726717008276,34.661637078492156,1]
["N118",442472,113065,"3 Rockstone Lane",33.346048034934306,39.995308898974237,30.016160259376104,34.893019027813629,30.281370764282205,{"$error":"#N/A"},29.85,24.515542335225167,{"$error":"#N/A"},34.254262343838796,36.150710696339253,39.61422139956624,{"$f":"AVERAGE(E24,F24,G24,H24,I24,K24,L24,N24,O24,P24)","v":33.291664376035001},0.83]
["N120",442716,111019,"6-9 Canute Road",37.153667260201075,40.131784637411606,35.905086608231635,33.110744311605018,36.173435641207156,32.965099768653509,{"$error":"#N/A"},31.784327855602452,36.38178238003615,41.081022969337589,40.721531357132775,38.330094534718555,{"$f":"AVERAGE(E25,F25,G25,H25,I25,J25,L25,M25,N25,O25,P25)","v":36.703507029467055},1]
["N122",440000,112633,"151 Paynes Road",30.73163097609384,32.033760871645967,28.386501511170476,24.94592854026746,30.800676781202068,27.523493711322182,28.16,{"$error":"#N/A"},45.61588465116526,30.212417808793909,31.910256867112103,28.315512052389121,{"$f":"AVERAGE(E26,F26,G26,H26,I26,J26,K26,M26,N26,O26,P26)","v":30.785096706469304},1]
["N123",442348,112305,"102 St Andrews Road",36.819766067822009,33.279605982170203,29.710691664967005,33.003794484675225,29.517979787944359,25.5443426936158,30.76,26.920243413961167,31.605188937891793,33.815475115370567,36.064114683655589,18.325703658413612,30.447242207540612,1]
["N124",439741,112753,"305 Millbrook Road",{"$error":"#N/A"},39.654329071579177,33.114049353351589,30.279729568976894,35.611850456168391,28.792541026149582,28.58,26.154710428532269,38.711589132868639,{"$error":"#N/A"},{"$error":"#N/A"},35.752185119815671,{"$f":"AVERAGE(F28,G28,H28,I28,J28,K28,L28,M28,P28)","v":32.961220461938034},0.75]
["N125",443125,112641,"Princes Court",35.234531357943837,39.373177209767434,33.48789632943393,34.712638881529593,37.995821546243427,28.802002559924748,37.25,29.943888976500091,35.393465406885632,30.717320130476136,37.052294730156177,36.696600837617609,34.721636497206553,1]
["N126",442365,112286,"107 St Andrews Road",37.018041598612648,35.19882226057122,30.753135660569953,33.788952625495476,30.091940506051106,27.775576223693996,31.51,28.997553535660607,33.688146382170864,37.481719843202988,37.511572084752004,32.304836441451762,33.01002476351939,1]
["N129",442554,111021,"South West House",33.683770517188591,38.021937665130579,29.469966861025043,27.098849898778255,32.117975014869877,27.191123051345382,29.17,22.091497844826893,29.381402421620315,31.441878657220922,31.499753708374474,27.965116691282674,29.927772694305251,1]
["N130",439346,112821,"367A Millbrook Road",36.930430171776401,46.207511113229593,37.556158382478564,38.804078743903354,55.815133138290079,46.015326013180555,41.92,37.790386920975479,49.411799106726924,44.924395913911887,43.003259094283592,43.437366832300619,43.484653785921417,1]
["N131",439378,114185,"142 Romsey Road",36.828013940881448,38.796942296257605,30.92320364170347,38.479342830265949,33.430572999641868,33.813174208657294,33.64,24.323524196156818,39.662879899687191,35.82009930860832,36.778138997262161,41.15987839480443,35.30464755949388,1]
["N133",438609,113020,"539 Millbrook Road",29.355181028693764,31.081335309446946,27.395243122674209,22.990757185334136,25.300457227869341,23.271361149927419,24.92,19.239019763237184,28.163493437586808,31.231021437574231,31.297383815887159,29.15361829580069,26.949905981169323,1]
["N134",438980,112861,"435 Millbrook Road West Ladbrokes",34.498523072329739,37.450999569766608,32.036369133174944,31.715032311776881,31.398848556979267,33.555588740270636,32.22,28.52400802496064,39.029718008380215,33.887082685274379,35.669211581291762,37.39733769852387,33.948559948560749,1]
["N138",441697,115288,"66 Burgess Road",39.163243326416037,52.17093459067295,41.320025093623329,57.01342589502719,44.535441722345958,38.754313551813482,42.65,39.22096355133317,43.33326541446209,44.212918052305007,40.557432646593647,40.522838625025926,43.621233539134892,1]
["N140",441628,112332,"5 Commercial Road ",43.725340028484865,47.159811381001589,39.62869609078863,38.484128358212303,37.832300719421291,42.016377836167713,41.34,35.256617731170593,46.900779395296752,44.988050265633525,49.574108985921491,47.29194414607948,42.849846244848187,1]
["N141",441923,110990,"Town Quay Road",30.080836107456374,33.803168117040208,35.086618976690701,37.309167993058949,32.147960760994366,34.633866184454298,31.49,28.247178532164199,31.068890747389624,32.753138592524365,41.355938243390014,33.028108001579888,33.417072688061914,1]
["N143",439457,114150,"102 Romsey Road",36.077419204961537,34.33529837251033,30.58866364526887,33.687208958573656,31.056392229415533,31.913938746586268,32.31,24.071997310690566,36.487426142696108,38.070179768691652,39.422188990028353,37.870793734052036,33.824292258622911,1]
["N144",443147,112709,"208 Northam Road",35.614760113605101,31.980181146855582,30.953677147747037,28.963631308581046,32.433462310186457,27.088931812891982,30.1,23.695263371333429,31.703151478205612,32.679227865797721,35.98053413877804,29.993059911130697,30.93215671709272,1]
["N146",443164,112741,"222 Northam Road",32.191877590699434,29.50462210073248,27.243453568692509,26.120533255665851,28.200343332753544,23.438650221083844,25.98,20.236285231498723,28.817411410925459,32.026751013558659,32.917488872407418,28.25025792941047,27.910639543952367,1]
["N149",441552,115247,"44B Burgess Road",39.014057643984771,42.777386032854793,36.557921852392766,36.333595932622067,30.539995545872539,30.95470327724151,{"$error":"#N/A"},27.496110441094928,31.770337477793888,40.073364933622699,39.251072259914842,32.611940197621117,{"$f":"AVERAGE(E42,F42,G42,H42,I42,J42,L42,M42,N42,O42,P42)","v":35.216407781365085},0.92]
["N151",439394,114176,"134 Romsey Road ",37.543915961184247,37.996058067587917,31.564863838647177,{"$error":"#N/A"},{"$error":"#N/A"},34.796706858658361,32.909999999999997,28.082668592489458,39.955070020203543,40.888695761486524,37.394421326405471,42.497397711015729,{"$f":"AVERAGE(E43,F43,G43,J43,K43,L43,M43,N43,O43,P43)","v":36.362979813767836},0.83]
["N152",437327,113848,"M271",39.732553755822181,47.017078035892865,36.166589656334637,39.054883564086452,39.761872023809524,32.053089385475602,38.9,26.71604179562145,40.921762584743767,45.862395912109278,44.121400470127568,43.935551119876941,39.52026819199169,1]
["N158",443807,111123,"24 Portsmouth Road",41.494502992791311,36.654679074656343,36.707179117916191,35.106346634904156,37.091576591123193,36.058116143789896,32.380000000000003,27.88164472253888,39.547417487800786,38.029055416700096,39.412979334099397,39.537583776787663,36.658423441092324,1]
["N159",443740,111147,"35 Portsmouth Road",40.242435805621803,35.387338356655903,36.346264112129852,38.531755807030663,29.728587257615334,35.89572046539255,31.04,30.424915229677886,38.670956721451375,38.103488191690701,42.923657323254567,36.752679804372228,36.170649922907742,1]
["N161",442705,114129,"30 Addis Square",33.612691476946146,36.058633826921017,29.614427463243143,34.749982279059324,23.791364106609372,27.204261676699208,28.48,26.643444198078345,26.440482872724669,29.099870603112027,34.499691027922744,32.990712281334353,30.265463484387528,1]
["N162",442872,114336,"263A Portswood Road",37.399724456352061,34.470037958667632,31.219773095628614,36.043300716534993,33.491745202845962,31.034943736894572,33.51,28.596645396538303,{"$error":"#N/A"},{"$error":"#N/A"},37.810680332735238,35.307291181567493,{"$f":"AVERAGE(E48,G48,F48,H48,I48,J48,K48,L48,P48)","v":33.452606860558852},0.75]
["N164",442809,114241,"168 Portswood Road(Int.Food)",32.868323776903019,39.777656808257014,27.875335249966483,32.417768703292253,31.589592706661399,26.722843826796186,31.23,24.327251761692757,27.7383328567321,33.662517971346361,31.412744287378878,34.288653650961379,31.15925179999898,1]
["N165",442766,114181,"8 The Broadway",33.156850440609695,32.566892445111712,27.842940495483564,36.084777851969363,32.303120025627976,31.234947038388736,35.299999999999997,27.012199280541793,34.432629600879601,36.138605919390685,33.191645870465962,36.292347158098032,32.963079677213919,1]
["N166",442251,112129,"14 New Road",39.852424526265366,37.475978141027042,{"$error":"#N/A"},35.124400564897115,{"$error":"#N/A"},29.777123949199115,33.270000000000003,30.513426102170868,32.861714489819299,37.821465459502015,36.779664373055503,30.378528065116654,{"$f":"AVERAGE(E51,F51,H51,J51,K51,L51,M51,N51,O51,P51)","v":34.385472567105296},0.83]
["N167",439759,114011,"13 Romsey Road",36.610069518021177,38.162551066509828,33.682786871864906,34.379006720430105,31.200877161431617,30.167320419853748,28.52,25.169654760119847,33.409557222138069,34.797445792217182,41.74815778066543,34.568109500192875,33.534628067787061,1]
["N168",439737,114025,"23 Romsey Road",35.620395824718599,39.443251997710995,32.319270901371958,35.523998476773905,27.616985611507488,32.066555881931265,31.37,23.810095143212259,36.268934865900384,33.743160563144549,40.714393873715615,36.870458544959682,33.780625140412226,1]
["N169",439361,114195,"150 Romsey Road",38.391756139133967,39.578935972783775,33.685537048374819,38.518049905920201,41.002307870190464,37.526857835385449,37.47,30.94644066952689,46.96340585599615,{"$error":"#N/A"},42.682521311946985,46.771020077264168,{"$f":"AVERAGE(E54,F54,G54,H54,I54,J54,K54,L54,M54,P54)","v":39.08543113745759},0.83]
["N170",442482,111003,"Union Castle House (2)",40.148165634667684,43.574146476921264,43.138664568914429,{"$error":"#N/A"},40.563817024058643,34.23843641618209,35.020000000000003,32.922240086226083,35.819162386894718,40.248015712047511,42.764416093295623,41.012794682418921,{"$f":"AVERAGE(E55,F55,G55,I55,J55,K55,L55,M55,N55,O55,P55)","v":39.040896280147905},1]
["N172",442207,112126,"4 New Road",41.319628215292063,35.912830161543866,34.15076214542011,33.873742970854316,39.253838704874809,33.337916451365899,34.97,34.059523638043757,40.184339802364661,43.227457273962521,41.172790950948247,39.002110225536867,37.538745045017258,0.92]
["N174",443959,113315,"166A Bitterne Road West",42.76041693310146,41.986886590368997,36.178971646772069,37.719127467057803,42.212673355629882,36.515993251633539,41.27,35.14441182438901,40.962740026395196,47.493288092905345,43.975178840909962,29.362033182297768,39.631810100955086,1]
["N175",439959,113737,"38 Shirley High Street",36.721907268367069,33.730390024503471,31.030649271103965,30.982937501397455,33.350865542763557,31.303470205206303,34.18,23.515207409990495,35.339470420177484,36.53306401257381,40.77403409911657,38.143632462328398,33.80046901812738,1]
["N176",439772,113952,"Salisbury Arms, Shirley High Street",34.725940645156072,36.94952505592002,31.990096365862094,31.317793702696541,28.321321375336087,30.218192798308575,29.95,17.43085304516778,36.24069402828836,34.145244939864398,37.990823580405539,37.396609684572539,32.223091268464835,1]
["N177",439844,113907,"95 Shirley High Street (Windsor Castle Pub)",36.055082550821218,34.754408852919475,30.559948137863586,{"$error":"#N/A"},41.650789133253362,31.473044800034071,32.74,22.590221104521689,35.703794857507596,35.495936635651383,36.479937870248122,40.760360948866136,{"$f":"AVERAGE(E60,F60,G60,I60,J60,K60,L60,M60,N60,O60,P60)","v":34.387593171971517},0.92]
["N178",437265,113682,"2 Gover Road",22.720894415695572,28.70096348057465,23.621902799079489,23.022636464614514,20.966095238095239,19.930235434956568,20.64,17.841228369850839,{"$error":"#N/A"},24.348081183831653,23.041745929626885,25.10113731315624,{"$f":"AVERAGE(E61,F61,G61,H61,I61,J61,K61,L61,N61,O61,P61)","v":22.721356420861969},1]
["N180",441633,112318,"Opposite 5 Commercial Road",42.042496377864325,42.324989441630954,32.64190574287268,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.25]
["N184A",437811,113557,"Redbridge AMS (A)",38.005449794699516,47.132977054042172,34.739083912606702,31.609446009029845,24.344421130952384,28.219224951611068,29.62,22.712273831358225,35.67041203217908,34.701251389615507,38.318357126949763,39.488428992505028,33.713443852129103,0.25]
["N184B",null,null,"Redbridge AMS (B)",36.156536020903324,44.485056994826323,33.140471201584091,28.039190325569937,40.580860119047621,29.079332229030818,28.91,21.672497087186596,36.709916754109827,37.796850251679693,38.950585877574362,39.468353137763081,34.582470833272971,1]
["N184C",null,null,"Redbridge AMS (C)",37.245340798805522,41.653819393049368,32.525620158883086,30.869789408728515,32.472877976190475,32.6254805293309,29.86,22.92484379649073,36.767667016439312,36.702208241582717,36.886742373638072,36.651071503172616,33.932121766359273,1]
["N185",437167,113713,"Redbridge Causeway 1",52.388849817995059,45.722152830789312,43.621272465855554,44.775550311346493,50.122071428571431,40.486379090184506,43.77,40.859398928778781,50.49028875928142,44.863186658215632,55.279781247675629,53.808321998096893,47.182271128065885,1]
["N186",437126,113701,"Redbridge Causeway 2",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},34.377025297619049,35.907366320823336,35.020000000000003,29.564736985687446,36.059298725609594,30.775526487900297,38.895084628332029,35.54562694396482,{"$f":"AVERAGE(I67,J67,K67,L67,M67,N67,O67,P67)","v":34.518083173742077},0.66]
["N187",444102,113872,"Cobden Avenue",35.154337673999059,28.791468812875337,32.109430068268068,28.736749216459597,31.578920567759891,27.63299153639106,27.81,25.189960135833889,29.660624617022616,36.315576208175294,38.775115876001209,33.269354004141469,31.252044059743955,1]
["N188",441300,112233,"Blechynden Terrace, Taxi",35.907780031880648,37.557712251416028,31.321724050946681,30.553501305813928,29.44185106127258,28.865310723674114,28.44,24.581592046918285,34.624255329731362,31.292819339151379,34.182329419689928,35.289928634511767,31.838233682917224,1]
["N189",441790,112465,"Cumberland House",45.223864388761974,37.903004588843579,34.946980830675372,35.381459131383835,31.118091310181558,35.832167120541307,32.17,33.006515843636649,35.545186061988048,38.498432173949318,40.737736448286299,35.997555550249594,36.363416120708123,1]
["N190",442024,112553,"Brunswick Apartments",36.651206709042697,36.967500920138832,38.016691327924299,41.380708475331375,31.804060604604658,35.799567544327502,35.869999999999997,30.829212234887773,37.67535047708904,44.237106946516732,42.506510755012322,29.907871411184502,36.803815617171644,1]
["N191",441915,112097,"Marlands House",43.483912667533538,41.274032068638121,37.648419122146358,38.516014379250485,45.314521847075738,37.526783009677359,37.83,35.919826574721895,41.550509463160296,41.997781029866744,43.422586633664615,40.343308576657556,40.402307947699391,1]
["N192",441961,112029,"Above Bar Street Bus Stop ",49.747330675384305,40.502369915868769,39.820125122270639,42.224507780008381,37.567398709031316,38.823073284178022,36.92,39.381221150131545,40.404062611594981,38.456259952876692,47.285813015166561,38.719497405640048,40.820971635179269,1]
["N193",441975,112031,"Above Bar Street Taxi Rank",36.534637451347237,33.498051913816823,34.352638571888164,28.764386073027797,32.525620158891542,28.321481187014921,25.75,30.012298865361721,29.071193333997329,34.87274265161448,31.510252233969638,33.596093193607956,{"$f":"AVERAGE(E74:P74)","v":31.567449636211467},1]
["N194",442090,111775,"Vincents Walk Bus Stop",53.194769681540301,40.341179600255103,43.338789052151874,39.640504313876889,43.982344587889891,43.414068170529703,41.76,{"$error":"#N/A"},46.883529715245196,40.523456196053772,45.568173267328042,45.650239774809648,{"$f":"AVERAGE(E75,F75,G75,H75,I75,J75,K75,M75,N75,O75,P75)","v":44.027004941789123},0.92]
["N195",441945,111655,"Bargate Street",48.337252509726156,36.521840534907902,38.412469581170569,35.144695732547724,33.796312313807285,31.995130579956236,31.71,29.219648111939719,32.844029288040403,52.154240996133886,42.339576237624982,33.246697641292556,37.143491127262287,1]
["N197",440957,115151,"351 Winchester Road",30.734022835146149,39.749912738287868,28.180700474705279,38.157614975727604,26.676445961996173,31.185634979223618,33.53,24.57620935412027,31.062457279349676,41.77589308317016,34.628321406460799,20.188766502307843,31.703831632541281,1]
["N198A",442304,112771,"Onslow Road (A)",38.976717885067757,39.145775475307893,33.116537259286389,34.895707241913762,31.770385833004845,29.901085803180159,33.64,33.035458181095855,30.818451610266969,35.135892618116536,40.114238823701371,35.607276527142652,34.679793938173681,1]
["N198B",null,null,"Onslow Road (B)",34.898712175746788,38.666007227828118,33.751684991858298,33.581288135596232,30.014439058172954,28.517995931226892,33.01,28.755725782557835,31.863716380418253,35.831652867980225,41.033821476307871,35.673002925900647,33.799837246132846,1]
["N198C",null,null,"Onslow Road (C)",38.771792975051625,35.047680633003495,33.901348424789994,34.747305084748881,29.912349129403662,29.01195659978163,33.68,32.505586550800672,33.650781955193033,37.69383471320365,40.482071884743974,33.849095360366348,34.43781694259058,1]
["N199",442210,112583,"Dorset Street/Charlottes Place Crossing",47.688701270632798,47.462565245527657,{"$error":"#N/A"},45.836243354986756,39.831741246591307,37.913810413353652,43.72,30.967288179117645,33.344382810481108,37.645574356168957,37.860951322523952,37.070783967389843,{"$f":"AVERAGE(E81,F81,H81,I81,J81,K81,L81,M81,N81,O81,P81)","v":39.940185651524878},0.92]
["N200",443160,112765,"Northam Bridge South ",39.921976306832505,36.662598531214364,34.864379782916757,31.474955651457087,36.013078180737836,30.14684314638038,32.33,30.211961784865768,33.781773777353671,33.200877041732078,43.395367617845253,32.88780006128885,34.57430099021871,1]
["N201",439759,112738,"289 Millbrook Road West",54.697523529706913,53.162014336917558,51.458196412635729,47.254619319541519,48.443195577257939,49.113779197438895,{"$error":"#N/A"},46.403008893407581,65.375809940230866,55.00939188194392,65.822565701559014,60.310448412799694,{"$f":"AVERAGE(E83,F83,G83,H83,I83,J83,L83,M83,N83)","v":52.324171009897874},0.92]
["N202",437166,113755,"Redbridge Causeway North ",48.134452600014008,43.74663353670487,41.886400632731466,36.223408712213391,35.134589285714284,{"$error":"#N/A"},42.72,{"$error":"#N/A"},39.008613463785707,57.185738287959275,47.511036223279554,48.207274752813689,{"$f":"AVERAGE(E84,F84,G84,H84,I84,K84,M84,N84,O84,P84)","v":43.975814749521625},0.83]
["N204",442542,113261,"6 Lodge Road",38.892817037756807,40.013522845660169,33.345334928692402,40.109953005829567,34.216741913993644,28.812314554486132,33.68,28.174176016574624,34.416470371958575,37.900349033215463,38.623427482239222,36.623119912430795,35.40068559190312,1]
["N205",442101,113438,"Stags Gate, Lodge Road",36.085485144093646,39.642956642516275,31.654116670847159,33.734021831256214,{"$error":"#N/A"},{"$error":"#N/A"},34.590000000000003,24.489547505730147,35.562397565264753,{"$error":"#N/A"},39.812638823561521,39.185465509691582,{"$f":"AVERAGE(E86,F86,G86,H86,K86,L86,M86,P86)","v":34.367998858674973},0.75]
["N206",442265,112516,"Charlottes Place",40.189484833193823,42.536271478901398,35.636272699482817,38.832981050679997,33.267570949720671,31.827257551675206,36.42,41.399949157765988,41.659976556134787,40.819242811422811,41.018088605717949,40.312308920443122,38.659950384594879,1]
["N207",439698,112806,"205 Waterhouse Lane",37.74214131057208,38.939262712467659,32.0111521308189,26.743306106267955,31.56024990703137,26.682955879413949,30.39,22.042754316006196,35.508955265547705,35.693868208091608,33.054286562732003,27.757620341344477,31.510546061691155,1]
["N208",441365,115202,"Sherwood Close",37.298430216159169,41.383238159384149,26.666292837295341,34.067145498430918,30.375067550854666,28.223738558231606,30.74,21.143597040408082,31.922026091746218,38.906548369485193,33.670060422966941,35.894470665416463,32.524217950864895,1]
["N209",441246,115138,"40 Burgess Road",35.013158623521868,39.135563893498151,29.311751765657004,32.223640892632638,27.556130548825113,25.943403707839764,26.84,23.798136738178719,29.833312235856752,35.587506328486455,32.72561814445374,34.437167853024057,31.033782560997853,1]
["N210",441122,115118,"18 Burgess Road",40.813403764298769,43.207019434280788,32.975720736370789,34.363934569356893,36.257169367813155,30.279550746643743,30.92,28.233018559762431,33.659392392658717,41.015785581335258,38.81791858564312,38.49149600349925,35.752867478471913,1]
["N211",437332,113873,"4 Coniston Road",26.138806085406831,32.578789420395147,23.719685118621683,25.543305962153187,21.498437500000001,22.647994812450644,23.75,15.548470238834067,28.549048145827854,26.406076399535507,25.08507460470684,28.627457697934684,25.00776216548887,1]
["N213",442935,114374,"277 Portswood Road",33.322444703725601,37.954684894799307,30.070603488189512,32.036133754528841,27.492920166513507,25.401769056347753,24.65,24.712503695671192,25.799705864335078,31.71769575886643,35.236338788343126,29.62204704664423,29.834737268163718,1]
["N214",441677,115280,"64 Burgess Road 2019",35.797321332415954,41.228344198795988,29.596212711768423,38.346433688532819,31.010608992598524,26.584832342152858,26.21,25.534481478732534,26.208956717031718,35.423603017810642,32.012570324881878,34.597871130641828,31.879269661280262,1]
["N216",442352,113486,"73 Lodge Road",34.753539355129377,37.576670635509934,30.681757554704014,35.175827918324366,30.976843221907881,29.807676306444748,31.33,26.015685752331571,33.70824315215345,38.555214675258057,33.331412516093778,36.244501850892931,33.179781078229176,1]
["N217",440751,112188,"11 Saxon Road",28.657450355842997,37.380113318516074,33.070684503901894,27.419721428571428,34.585091720374798,29.154175677029471,30.28,22.449360617606338,37.240096730682893,35.824337820788642,33.238148478099482,32.929649843366633,31.852402541231722,1]
["N218",443547,114101,"112 St Denys Road",39.531045490829143,43.995844311378477,38.991569755896741,41.708503839935872,34.138413823657963,31.120089047195936,33.6,29.592452607213044,35.949297702655436,36.05407064072584,39.838994230808119,32.997255066054798,36.459794709695949,1]

{"sheet":"Sheet2","index":6,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":true,"merged":[[1,7,2,7],[1,5,2,5]]}
[]
[null,null,null,null,null,"Ref",null,"Location","Sample ","Exposure Data",null,null,null,null,"µg NO2"]
[null,null,null,null,"no",null,"Trim",null,"Number","Date On*","Date Off*","Time* (hr.)","mg/m3 *","ppb *","on tube"]
["6 Sandringham Road","N100",{"$f":"VLOOKUP($B4,$F$4:$O$186,8,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"RIGHT(F4,3)","v":""},{"$f":"RIGHT(G4,4)","v":""},{"$f":"TRIM(H4)","v":""},null,null,null,null,null,null,18.214225462735072,1.6739999999999999]
["Redbridge School Fence","N101",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.013203922079047,1.286]
["485 Millbrook Road","N103",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.425609996043342,1.1599999999999999]
["Regents Park Junction","N104",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.931793941951316,1.956]
["2 Romsey Road, Oakhill","N106",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,27.369311210273338,2.302]
["Cranbury Place","N107",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.241709080574889,2.0270000000000001]
["72 Bevois Valley","N109",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.712391315031955,1.946]
["Brintons Road 1","N110",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.716876419617883,2.0499999999999998]
["Brintons Road 2","N111",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,26.112103012395995,2.238]
["Brintons Road 3","N112",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.156771356289291,1.5640000000000001]
["206 Bitterne Road","N113",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.219411646197784,1.4950000000000001]
["Bitterne Library","N114",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.031823445519304,1.625]
["54 Redbridge Road","N115",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.099615108289967,1.8149999999999999]
["57 Redbridge Road","N116",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.987729132321014,1.754]
["Victoria Road (Lamp Post)","N117",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.340663226113588,1.7090000000000001]
["3 Rockstone Lane","N118",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,23.383367759374288,1.915]
["6-9 Canute Road","N120",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.083802510768283,2.9430000000000001]
["151 Paynes Road","N122",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.795871686953816,1.345]
["305 Millbrook Road","N124",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,34.636313540806917,1.361]
["Princes Court","N125",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.158986848465453,1.74]
["107 St Andrews Road","N126",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,23.61014298832643,1.724]
["South West House","N129",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.840436123204928,1.706]
["367A Millbrook Road","N130",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.199035113537118,1.726]
["142 Romsey Road","N131",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.768641594008781,2.14]
["539 Millbrook Road","N133",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.192659582863975,1.897]
["435 Millbrook Road West Ladbrokes","N134",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,37.042714805803072,2]
["66 Burgess Road","N138",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.318648385589366,1.794]
["5 Commercial Road ","N140",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,23.566259051764597,1.831]
["Town Quay Road","N141",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.587200189261065,1.829]
["102 Romsey Road","N143",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.497284394087135,1.7689999999999999]
["44B Burgess Road","N149",{"$error":"#N/A"},null,{"$f":"RIGHT(F34,3)","v":""},"","",null,null,null,null,null,null,22.594892119792551,1.7509999999999999]
["134 Romsey Road ","N151",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.217534356012614,1.768]
["M271","N152",{"$f":"VLOOKUP($B36,$F$4:$O$186,8,FALSE)","v":{"$error":"#N/A"}},null,"",{"$f":"RIGHT(G36,4)","v":""},{"$f":"TRIM(H36)","v":""},null,null,null,null,null,null,21.996181985740144,1.6579999999999999]
["24 Portsmouth Road","N158",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.185919343176344,2.19]
["35 Portsmouth Road","N159",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.462961683377319,2.2629999999999999]
["263A Portswood Road","N162",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.441519121228026,1.87]
["8 The Broadway","N165",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.828277137443258,2.028]
["14 New Road","N166",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.920579634570789,2.774]
["150 Romsey Road","N169",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.504327616976646,2.0030000000000001]
["Union Castle House (2)","N170",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.842693294214587,2.0270000000000001]
["4 New Road","N172",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,27.159255931797272,1.601]
["166A Bitterne Road West","N174",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.451406236120594,1.391]
["95 Shirley High Street (Windsor Castle Pub)","N177",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.907736959114384,1.4390000000000001]
["2 Gover Road","N178",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.680971313076519,1.7170000000000001]
["Redbridge AMS (A)","184A",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.434210184313923,2.3330000000000002]
["Redbridge AMS (B)","184B",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.284007758110601,1.95]
["Redbridge AMS (C)","184C",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.261316994308423,1.7270000000000001]
["Redbridge Causeway 1","N185",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,23.357837677209876,1.871]
["Redbridge Causeway 2","N186",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.954224495689463,2.0030000000000001]
["Cumberland House","N189",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.411484227147913,2.4350000000000001]
["Brunswick Apartments","N190",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.504183670397961,1.778]
["Marlands House","N191",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.343492575802365,1.552]
["Above Bar Street Bus Stop ","N192",{"$error":"#N/A"},null,{"$f":"RIGHT(F56,3)","v":""},"","",null,null,null,null,null,null,25.704792251091849,1.9339999999999999]
["Above Bar Street Taxi Rank","N193",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.987514186653396,1.998]
["Vincents Walk Bus Stop","N194",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.485769237745668,1.635]
["Bargate Street","N195",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.068912030539497,1.873]
["351 Winchester Road","N197",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.212964044959612,1.843]
["Onslow Road (A)","198A",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.714979331108541,1.6140000000000001]
["Onslow Road (B)","198B",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.153940161832395,1.6140000000000001]
["Onslow Road (C)","198C",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.383599865223086,1.6870000000000001]
["Dorset Street/Charlottes Place Crossing","N199",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.986351480625544,1.677]
["Northam Bridge South ","N200",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.282662890608652,1.919]
["289 Millbrook Road West","N201",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.964500629081332,1.7430000000000001]
["Redbridge Causeway North ","N202",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.294589784227814,1.1859999999999999]
["6 Lodge Road","N204",{"$f":"VLOOKUP($B68,$F$4:$O$186,8,FALSE)","v":{"$error":"#N/A"}},null,"",{"$f":"RIGHT(G68,4)","v":""},{"$f":"TRIM(H68)","v":""},null,null,null,null,null,null,20.655280686299971,1.833]
["Stags Gate, Lodge Road","N205",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.994773755490545,1.748]
["Charlottes Place","N206",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.910063771027584,1.9770000000000001]
["205 Waterhouse Lane","N207",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,12.594207601414606,1.8380000000000001]
["Sherwood Close","N208",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.761696351871031,1.667]
["40 Burgess Road","N209",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.726337420406434,1.944]
["18 Burgess Road","N210",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.650890534320713,1.9490000000000001]
["4 Coniston Road","N211",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.701333598960421,1.694]
["64 Burgess Road 2019","N214",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.771661882882686,1.5049999999999999]
["73 Lodge Road","N216",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.94458985362121,1.984]
["11 Saxon Road","N217",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,23.533328719955133,2.0630000000000002]
["112 St Denys Road","N218",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.559731375359668,1.627]
["10 Regents Park Road","N219",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.95155471863777,2.012]
["Bassett Avenue","N220",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.350506135645482,2.38]
[null,null,null,null,"","","",null,null,null,null,null,null,17.478025224130445,1.85]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,{"$f":"RIGHT(F87,3)","v":""},"",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"",{"$f":"RIGHT(G100,4)","v":""},{"$f":"TRIM(H100)","v":""}]
[null,null,null,null,null,"",""]

{"sheet":"2022","index":7,"n_rows":96,"n_cols":19,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2022"]
["Status"]
["Bias Adjustment factor ","0.83  March 2023 gradko 20% TEA National factor "]
["Other comments"]
[]
[]
[]
["Site ID","X OS Grid Ref","Y  ","Site Name","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","Undajusted annual mean","Data capture","adjusted annual mean"]
["N100",444387,114453,"6 Sandringham Road",30.614158187899836,20.737629260521761,24.170547442628408,15.343859134263967,13.616216732483778,13.639504085510112,32.771507251603396,14.802972459056193,14.959914335351295,18.462825748896567,20.277209993315498,25.979456159191216,{"$f":"AVERAGE(E9:P9)*0.83","v":16.971826221358274},{"$f":"(COUNT(E9:P9))/(COUNTA(E9:P9))","v":1},{"$f":"Q9*0.83","v":14.086615763727366}]
["N101",437548,113719,"Redbridge School Fence",41.766984854687855,null,44.819642192638995,33.445239702909525,34.225446325505978,37.041092374277,40.665186758885092,42.668589489349223,36.980165907857618,42.390046183645481,48.997361917530341,39.094118297396854,{"$f":"AVERAGE(E10:P10)","v":40.190352182243991},{"$f":"(COUNT(E10:P10))/12","v":0.91666666666666663},{"$f":"Q10*0.83","v":33.357992311262514}]
["N103",438808,112903,"485 Millbrook Road",31.827559702873334,29.669764337423448,32.384919564329245,24.229369321487269,25.221022625590457,25.554577163868668,25.422907390913235,28.282578516497964,25.796632139344137,33.431551582867783,33.059241710862523,27.197957737826844,28.506506816157074,1,{"$f":"Q11*0.83","v":23.660400657410371}]
["N104",439222,112850,"Regents Park Junction",35.931236161978767,38.040876418339352,42.283420168275022,29.20687982725461,null,31.540156001589096,36.187830991496249,38.006703378477624,32.403778570736073,43.413872625698318,43.310571471055219,41.011591104560061,37.394265156314582,0.91666666666666663,31.0372400797411]
["N106",439752,113984,"2 Romsey Road, Oakhill",37.660051820870272,23.228606513064047,38.8125178819731,26.863646239150675,29.167743320975738,30.788128321003633,30.9486155171166,32.605723228255044,31.871972365216845,37.619028388051255,39.451128727633055,33.130401522592372,32.678963653825221,1,27.123539832674933]
["N107",442364,112890,"Cranbury Place",58.292648675418064,44.251861611961083,42.336907142341957,40.200062372604016,36.747045111908022,40.00830021443555,40.870856551019692,38.941521908112939,44.02813517348536,40.362278904629868,48.175398322072077,48.523775406688394,43.56156594955641,1,36.156099738131822]
["N109",442585,113248,"72 Bevois Valley",47.320303563029618,31.082844668178243,44.696542860569522,null,29.004381486137191,28.129773393377704,21.953122216467488,35.277033506525555,33.531174125746006,35.223219595765279,41.05200148661568,42.750070999252429,35.456406172878609,0.91666666666666663,29.428817123489242]
["N110",442579,112248,"Brintons Road 1",38.382950089132528,27.835534424707976,34.254524879269788,23.627639951178704,20.772114793702212,22.237364540831251,23.332750148550822,25.346415071185284,26.599735219443108,29.433628849567523,null,31.729480087869561,27.595648914130791,0.91666666666666663,22.904388598728556]
["N111",null,null,"Brintons Road 2",36.359567736191039,30.063225823026833,32.806591864685707,24.332942636288514,19.57556440235992,21.13133471695166,19.155446112501942,23.850245588938563,28.175426621162277,29.130363068633226,29.948966918598313,33.217526051931834,27.312266795105824,1,22.669181439937834]
["N112",null,null,"Brintons Road 3",37.361039809869155,26.010949088942056,32.885930660005386,24.14822050447404,20.61257474152324,21.325219320212891,null,23.840640936487791,29.737369884785537,29.955919916732142,31.053641927890872,33.047020785216368,28.179866143285405,0.91666666666666663,23.389288898926885]
["N113",444124,113288,"206 Bitterne Road",47.159670970165209,30.777314812438703,34.956688246293744,38.388207449086231,31.286784965614558,32.200787304516794,32.276560037095514,41.180352234549616,37.540492987679819,40.502244548112493,34.853599447516615,38.162665057878996,36.607114005079026,1,30.383904624215589]
["N114",444131,113322,"Bitterne Library",37.331689752434158,34.717189216946871,38.678011796861817,29.678810905820512,null,null,29.648402937010665,24.341897857782616,30.721263924717594,39.251711985423128,34.581968835585748,41.044306642281917,33.999525385486507,0.83333333333333337,28.219606069953798]
["N115",437939,113474,"54 Redbridge Road",31.224501524798669,32.908721599664716,37.590779982825858,28.271679186359457,27.332711427474553,28.622662289214045,32.222466505160611,32.575804310135041,30.021663386965276,40.440719535203797,37.427703111815447,29.714166496053014,32.3627982796392,1,26.861122572100534]
["N116",437952,113407,"57 Redbridge Road",31.808713321055862,28.458121757003148,34.883363658126868,28.186840277777776,27.510945911301512,25.985421183491553,30.054221198156679,33.337596172245085,33.51012299362128,37.986915582004038,36.124410561540785,29.715383292385418,31.463504659059168,1,26.114708867019107]
["N117",443752,111121,"Victoria Road (Lamp Post)",38.357537082888278,36.884353179699751,36.342721419874181,29.535526958209825,28.940525182719774,25.459553836856575,29.700507405644448,32.326038464392774,31.111584973166366,33.933523911709393,35.470332716333118,39.320538024019989,33.115228596292873,1,27.485639734923083]
["N118",442472,113065,"3 Rockstone Lane",38.919161116202325,28.87852780274731,39.134218439037184,34.685706073023546,23.434169275362322,24.392832292807924,null,null,30.313937231619022,32.309741801276779,32.296713659227535,36.888799023293984,32.125380671459794,0.83333333333333337,26.664065957311628]
["N120",442716,111019,"6-9 Canute Road",40.818216737495717,38.226074009823641,null,null,null,33.293366317512152,null,34.012770959115564,19.132207823184839,39.281399142471777,38.125243298187151,37.135425874277765,35.003088020258573,0.66666666666666663,29.052563056814616]
["N122",440000,112633,"151 Paynes Road",36.079580963299215,32.212886994916893,31.288343821504569,24.777855327632992,27.880310366866098,27.513899567872212,24.98231850348731,28.231813808159494,26.875824879459376,31.77124767225326,36.461503457502346,30.621271096184248,29.891404704928174,1,24.809865905090383]
["N123",442348,112305,"102 St Andrews Road",44.228029854355505,30.17714506955399,35.64036635299248,28.583709450216471,25.031804644702106,25.939984289084364,26.178204195365971,29.537282161502535,32.45199177084384,32.20917261955038,32.114522354903492,35.425207713368437,31.459785039703295,1,26.111621582953735]
["N124",439741,112753,"305 Millbrook Road",35.861463005404772,33.357292190788939,37.052291080704151,28.987485424801406,29.948645276747161,29.710582186677609,30.821412736895493,34.725095238095236,31.175885665795537,35.829768342644321,34.945657141440726,29.638150651266088,32.671144078438452,1,27.117049585103914]
["N125",443125,112641,"Princes Court",44.752426910656183,28.2950170858938,42.580546723254464,36.0100470631359,30.126981413053731,32.069690149529251,28.023717813231634,36.972253323292797,38.829796512510846,41.905219826739511,40.933199116464515,37.68309189678687,36.515165652879119,1,30.307587491889667]
["N126",442365,112286,"107 St Andrews Road",42.781202030580765,29.471762569762578,51.375103800015232,30.572434518097101,25.079575264253062,26.630956575564824,27.623068469117083,30.88910285539281,35.089891758440352,33.927014182166971,33.375413773945745,37.309396290054039,33.677076840615875,1,27.951973777711174]
["N129",442554,111021,"South West House",34.342679906825552,29.772660868727936,32.716806013654619,null,23.388764152448644,28.951284514385343,25.822166837919283,28.171034124369804,29.60136272385569,32.16231093368652,29.785723723214012,31.898368135013566,29.692105630372819,0.91666666666666663,24.644447673209438]
["N130",439346,112821,"367A Millbrook Road",42.5692817679558,43.254277866200901,44.586558299170811,39.778947595718485,38.876254122458256,43.924354910817044,45.11448864480051,49.062254191887227,42.593825946072201,48.148813407821237,45.275706178277972,35.738686926611805,43.243620821482686,1,35.892205281830627]
["N131",439378,114185,"142 Romsey Road",36.575409595300961,30.966782863908715,40.687401813441674,30.49202929005779,30.033067109803529,32.054234359478983,30.99034022395109,34.359061312671088,31.683940156379922,35.560782522832852,null,32.743834960403483,33.286080382566375,0.91666666666666663,27.627446717530091]
["N133",438609,113020,"539 Millbrook Road",31.000407236116715,28.334624942239394,32.876009056242218,23.406640312264614,24.419015211554942,26.171156273297225,24.727403907987696,28.079173861266288,26.163385286063491,31.91473072625698,32.874309998761944,26.672852579848765,28.053309115991691,1,23.284246566273104]
["N134",438980,112861,"435 Millbrook Road West Ladbrokes",40.222860358513557,34.501697386660979,40.393575003579038,30.262715389084942,30.328543525508948,31.521214786104384,33.449624499084941,35.858318614809079,32.03816217884264,37.305594040968344,40.281720318189166,33.893187402732615,35.004767792006554,1,29.053957267365437]
["N138",441697,115288,"66 Burgess Road",49.010816993458967,35.070227442114842,53.15085308851755,44.0339600105982,37.077108126393192,38.437507871386103,42.264232708465457,42.485703091521266,38.581303124716143,31.880900658807857,40.010201360923382,41.522501586038992,41.127109671911825,1,34.135501027686814]
["N140",441628,112332,"5 Commercial Road ",46.168278197024421,43.828524400535102,48.397746435452795,37.348186685192267,38.331206038094088,37.829040572787108,34.093605565220152,41.807007704163993,37.694798725745734,48.570263031265995,49.001518390014851,43.045953973605386,42.17634414325849,1,35.006365638904548]
["N141",441923,110990,"Town Quay Road",37.826433617835164,null,42.201072534222803,36.063589818181818,30.290417663003531,30.920891977988592,31.781129830094816,39.200535966150184,31.979358416314319,34.45937362935377,30.592389462978741,33.201878129024138,34.410642822286171,0.91666666666666663,28.560833542497519]
["N143",439457,114150,"102 Romsey Road",37.219866171610072,31.772791164660351,35.96525570651832,29.478805405580385,29.463219736673032,30.52013755089633,29.665560074646041,31.679771987774423,31.937112169068147,null,37.808016997159918,32.99659489992569,32.591557442228435,0.91666666666666663,27.050992677049599]
["N144",443147,112709,"208 Northam Road",40.277184219590566,31.6887222836022,34.245736619992122,27.583595134770142,27.546836909159691,28.83787939543906,28.861465412857587,28.300579362005355,33.147781888765294,33.91058792879025,31.455655415198315,40.765485033101157,32.218459133605982,1,26.741321080892963]
["N146",443164,112741,"222 Northam Road",33.266832952094077,27.997348543239827,32.464944967985737,22.689651195958,21.55139905136771,21.483952992001441,25.616761517263633,25.444150482475468,28.365888882144365,33.014430742511443,29.499174432248179,32.700203712087777,27.841228289281471,1,23.108219480103621]
["N149",441552,115247,"44B Burgess Road",45.943948703974897,34.96414689933772,42.050733496333223,null,null,null,null,null,null,null,null,42.55,41.377207274911456,0.33333333333333331,34.343082038176505]
["N151",439394,114176,"134 Romsey Road ",38.194339568756426,33.983947171944131,37.957040588208926,32.547598079626098,31.236078230856798,30.641598391181823,31.700641194347977,36.248720228487329,32.433640410295375,35.805326586027107,38.938243538766265,34.417212034384775,34.508698835240246,1,28.642220033249401]
["N152",437327,113848,"M271",39.363720454309153,39.495258992811664,46.169730864665489,38.288639615117923,32.287236105500952,37.616009550808087,38.632591953035444,44.062426048726543,36.941187362574766,46.234668686673068,45.615374237381651,36.048084261381042,40.062910677748818,1,33.252215862531514]
["N158",443807,111123,"24 Portsmouth Road",43.087661428923404,36.170830057114927,38.477863677037078,31.203823781425474,30.959121328907486,33.280984169182418,34.354770186334449,35.022413741898404,31.781198052267019,36.001246199833105,34.650598361797059,33.61848905555059,34.88408333668928,1,28.953789169452101]
["N159",443740,111147,"35 Portsmouth Road",41.430697246200495,31.739762640623979,35.623600298284863,30.336309433353339,29.247702857146475,26.397327371599722,30.509086956520889,31.815984653466263,33.707567041046474,31.63392515008773,34.112591735691446,32.918653129144353,32.456100709430501,1,26.938563588827314]
["N161",442705,114129,"30 Addis Square",41.245319997028083,28.497605177987396,34.523697575720341,28.700683499415941,24.448150625349932,24.770940849923708,26.347247865016591,28.232687419413047,32.995837484245612,31.39815172469903,32.817131888543948,33.88074099175688,30.654849591591709,1,25.443525161021117]
["N162",442872,114336,"263A Portswood Road",42.594274962243084,37.275885344431039,35.055659617319485,30.823569885460547,30.351556646629653,30.438022251466332,24.560006708635861,30.293960827652658,35.150971013622019,37.85005810385455,41.586753845002853,35.994401897664645,34.331260091998566,1,28.494945876358809]
["N164",442809,114241,"168 Portswood Road(Int.Food)",39.753294050653935,29.05039042433603,37.371589699321959,28.876567328465327,27.569053803338772,33.532687127723335,33.343745322212882,33.183122735930048,29.885370715011366,32.673087071243373,32.529569823280198,34.114507596436106,32.656915474829454,1,27.105239844108446]
["N165",442766,114181,"8 The Broadway",39.201448837611437,31.361698859548486,38.044595022297038,31.569664675790854,29.371323606142877,32.284679965557373,30.36483661142891,33.031061582856076,32.636993966318997,36.826121655895854,39.455430042325411,37.347929437457807,34.291315355269262,1,28.461791744873487]
["N166",442251,112129,"14 New Road",44.252975161661972,null,40.749100445475165,28.662711054860246,27.675646085296364,29.474442300821725,31.568145531436279,35.21564989560715,35.532943000915715,35.974491742656461,37.852854828254401,39.595265600830473,35.141293240710546,0.91666666666666663,29.167273389789752]
["N167",439759,114011,"13 Romsey Road",41.602784655234757,25.549037822805285,36.840178899766649,30.797457772315369,27.310462993735605,26.127277466121186,30.755527959225564,34.389814552768001,33.685074522862713,34.480712910391503,35.245470178925423,null,32.434890884922915,0.91666666666666663,26.920959434486019]
["N168",439737,114025,"23 Romsey Road",37.867417091578389,25.845948506697226,41.370324231658884,31.985571719521754,27.331568451999697,26.313011617517009,31.130091400675017,35.827989174966902,32.852861567046993,34.439955566525789,35.491655069581476,34.522827608793385,32.914935167213542,1,27.319396188787238]
["N169",439361,114195,"150 Romsey Road",46.22161869990159,32.264095157171724,43.37715144589265,32.986905035157818,35.246115301034358,37.504051437374585,37.015479363551989,39.828774116660284,35.0885657879466,44.16058207849786,41.871946819084272,34.791772965452139,38.363088183977155,1,31.841363192701039]
["N170",442482,111003,"Union Castle House (2)",46.691759705764376,38.184456757405712,40.590984914348994,36.179096993208432,30.823377624235029,31.682563359881474,30.772817204301077,36.568092056421676,36.034304114490162,38.205128634796559,38.139493542241979,40.829352878087064,37.058452315431879,1,30.758515421808458]
["N172",442207,112126,"4 New Road",46.522998126549929,40.310109279777372,42.765795372896967,33.61675987916427,33.217144841155474,36.282070033354245,37.375554065892437,35.620475284008776,38.981728645122239,38.003910997184327,41.750877233587012,37.385353381071994,38.486064761647086,1,31.943433752167081]
["N174",443959,113315,"166A Bitterne Road West",46.195270232168724,null,42.735838008917426,33.77691028071726,35.735296519008017,39.098273629032555,40.731994440577147,32.824618673397666,39.439097945182461,35.276883979344376,43.042403664653328,28.774925254965357,37.966501147996759,0.91666666666666663,31.51219595283731]
["N175",439959,113737,"38 Shirley High Street",null,33.829077992271912,34.919515660319668,28.212411451850066,28.808950530486168,28.966675440771422,30.038667495994758,30.130394792417903,30.575555555558033,34.929043692914327,37.255980119283215,36.43876933780502,32.19136746087932,0.91666666666666663,26.718834992529835]
["N176",439772,113952,"Salisbury Arms, Shirley High Street",38.302414918793943,null,43.878982663554233,28.305372453926626,26.424033746650803,26.894827175208118,30.019636363633019,null,51.680120365353588,41.837413478152335,33.460629721669015,32.774272500308676,35.357770338725032,0.83333333333333337,29.346949381141776]
["N177",439844,113907,"95 Shirley High Street (Windsor Castle Pub)",35.436828725899396,29.302951351353986,47.223512667656109,29.386341416099214,30.075278026331716,29.173125558757683,30.926645615041828,36.369298546406434,30.478527863775714,40.044090348061061,38.343296719680801,34.9000540208717,34.304995904994634,1,28.473146601145544]
["N178",437265,113682,"2 Gover Road",23.904946179343732,19.02547094188855,33.703148174654373,22.15560131656963,19.631511466829615,19.896240859570433,21.343149792781205,24.606259314453901,22.16385742940685,28.336800953753244,26.039946436543083,23.726395774906916,23.711110720058457,1,19.680221897648519]
["N184A",437811,113557,"Redbridge AMS (A)",33.114184556823396,40.093293246991365,46.224410249074957,29.518401400726258,30.754415024631644,32.400689449331416,34.091653823352715,35.032215773809526,31.943853246404966,44.056954902157599,45.685859502900634,34.865785411592462,36.481809715649746,1,30.279902063989287]
["N184B",null,null,"Redbridge AMS (B)",40.346066882244003,39.607420979600533,46.025263132781269,27.135982952866943,28.415959133408911,31.620444709748661,33.342174299685297,37.009083064715028,30.766652777777775,43.05026074001119,44.461606053089845,34.481308736512524,36.355185288536831,1,30.174803789485569]
["N184C",null,null,"Redbridge AMS (C)",39.197986123900812,41.306701788651814,43.167549618323015,21.878760972315142,29.524410542513046,31.14819131473293,34.611655796022497,34.892059990091333,33.124796481343203,44.934040524433073,44.363609388184521,34.553163919319339,36.058577204985887,1,29.928619080138287]
["N185",437167,113713,"Redbridge Causeway 1",47.722492786841471,57.449338779285867,48.281006894573757,45.789989058157623,37.735341285105427,41.270840173113506,48.188202764976957,38.988339004170136,null,null,null,null,45.678193843278095,0.66666666666666663,37.91290088992082]
["N186",437126,113701,"Redbridge Causeway 2",42.621703773436153,27.549104968399273,37.923379614110658,null,25.313278060978565,25.234757498883834,32.294549923195085,38.934593558281776,null,null,null,null,32.83876677104076,0.58333333333333337,27.256176419963829]
["N187",444102,113872,"Cobden Avenue",39.792201123960105,33.947795957152699,44.025895307548119,27.144082139876936,28.059987506429675,27.303893382639099,31.085410824741338,24.669681138092791,28.960675254635419,30.114526371786106,34.058482492196937,null,31.742057409005383,0.91666666666666663,26.345907649474466]
["N188",441300,112233,"Blechynden Terrace, Taxi",36.521166248543139,34.617173153395861,41.591962078972216,34.588722204054605,25.717096576658193,26.12505763585682,25.574989913039339,28.916477748388765,28.561978569359976,33.231670052386917,34.547095863794404,32.795979870718874,31.899114159597428,1,26.476264752465863]
["N189",441790,112465,"Cumberland House",40.411519947783596,36.348031811065653,37.479231777192155,34.477660983687478,27.553868941818891,30.616418309387214,28.369861565212798,34.024747059736363,34.491139299160153,36.32340648752448,37.007754875684853,37.018670703516207,34.510192646814154,1,28.643459896855745]
["N190",442024,112553,"Brunswick Apartments",44.032616721399883,36.878670548498548,null,29.774127172360934,30.56468811089011,31.226425315613852,31.892165565219972,35.020211077723332,37.726675933970462,39.558597495718189,40.700740107249395,41.427306984168318,36.254747730255723,0.91666666666666663,30.091440616112248]
["N191",441915,112097,"Marlands House",44.955519023299708,44.635102662002488,49.908094850300792,33.293881949552599,34.745834153116604,38.752873950369235,35.089780091692582,35.552884249314268,38.64207551349584,40.91708919003797,43.588267401224847,37.27737957304786,39.77989855062124,1,33.017315797015627]
["N192",441961,112029,"Above Bar Street Bus Stop ",53.610705306413564,40.843874188983015,40.768871964361331,36.903361841973776,33.853445721779053,35.555939664171234,35.973012435234246,36.853257327651697,43.710745323935079,36.68565575492692,null,null,39.475886952942993,0.83333333333333337,32.764986170942684]
["N193",441975,112031,"Above Bar Street Taxi Rank",40.039637978964066,33.085081034896653,35.70736312689381,28.595892714984526,26.736139112320249,27.581946789337682,30.354510261198975,28.961572753136981,33.155371079530909,31.13510736647461,31.434037776024145,33.065490795115402,31.654345899073164,1,26.273107096230724]
["N194",442090,111775,"Vincents Walk Bus Stop",61.169590233283415,55.87504405403407,46.3839833309368,41.656151867734046,40.990354166666663,45.420655963186938,48.203905497130897,null,48.07246028228856,44.681914527041009,51.074376113881215,47.825109118321514,{"$f":"AVERAGE(E74:P74)","v":48.304867741318645},{"$f":"(COUNT(E74:P74))/12","v":0.91666666666666663},40.093040225294473]
["N195",441945,111655,"Bargate Street",53.213164304494043,36.986519637945761,44.48591751688312,null,null,null,39.630197409327621,34.624924979020832,42.324666118101881,33.319935707537198,null,null,40.655046524758639,0.58333333333333337,{"$f":"Q75*0.83","v":33.743688615549665}]
["N197",440957,115151,"351 Winchester Road",41.284153194863592,28.13111402358907,37.126936759843723,30.369911342092895,29.195829548751956,28.170925002977675,26.991271598554725,28.048650137741049,31.015810998843513,35.635592346199275,35.878922496591542,34.028543727815254,32.156471764822022,1,26.689871564802278]
["N198A",442304,112771,"Onslow Road (A)",45.233108519640965,37.085053166899826,36.402543100348694,30.13619787208194,28.113130399488629,29.755571765716997,28.906718944096767,28.859366702802642,34.206356607881595,32.830244648940315,25.110472961270791,37.590805875938848,32.852464213758999,1,27.267545297419968]
["N198B",null,null,"Onslow Road (B)",43.802327861541151,36.024874402837511,36.996385565280974,30.472727161552424,27.187726561139968,null,25.898288554120033,31.240391106018073,33.807448659101631,31.634273704828068,39.106139339196325,38.738379982712566,34.082632990757155,0.91666666666666663,28.288585382328439]
["N198C",null,null,"Onslow Road (C)",42.535064992938473,36.597370935431158,36.204595612037934,31.196265133913972,30.011803791962606,30.199563880749924,27.547920161536368,30.835110356534596,34.031834380290356,33.655633046989607,38.411463927737245,39.389705827097636,34.218027670601664,1,28.40096296659938]
["N199",442210,112583,"Dorset Street/Charlottes Place Crossing",46.747505892308084,34.233094443402003,46.234509625511961,32.544305983714516,27.912888554560553,29.939625910241144,30.641849155954223,34.100374994882543,32.949482180158114,36.265554738548303,39.335991391282747,63.775200571349068,37.890031953492766,1,31.448726521398996]
["N200",443160,112765,"Northam Bridge South ",45.088716823857652,35.973275095709056,37.709900728941392,30.54440813332819,29.382212335693247,32.322101339366824,29.985610139364564,29.056829998169658,35.627435174230449,37.799089468312992,37.83796231103566,30.115330466275125,34.286906001190395,1,28.458131980988028]
["N201",439759,112738,"289 Millbrook Road West",74.17073107851067,51.498233814242134,61.197754630180711,51.927912631837188,49.386772337976282,49.269139181408157,50.92218972684261,60.499744556311832,52.526692125211866,60.488356052141526,62.752334192529744,50.30069020603441,56.245045877768924,1,46.683388078548205]
["N202",437166,113755,"Redbridge Causeway North ",47.524640225931847,47.642808982992157,46.699320990600839,38.552376551026143,36.01732686980754,42.051084912693753,44.537371848637889,50.312302190431005,40.939420955171194,54.453738638068259,52.868303983327316,41.069119272820721,45.222317951792398,1,37.53452389998769]
["N204",442542,113261,"6 Lodge Road",47.135169852429513,33.9875852681376,40.205062945109169,30.504514827265606,29.006623760658726,30.327086689448034,31.2376852592779,31.172536378705608,34.698485909120045,34.060070156827983,42.012994056467235,39.101337573626765,35.287429389756184,1,29.288566393497632]
["N205",442101,113438,"Stags Gate, Lodge Road",47.154442546232126,41.811302650509887,43.116064457340656,29.982926322221353,32.708239114054116,35.411004373072743,33.721192094039623,32.352927797093976,34.224178861307152,null,48.695918246005199,41.19312260103915,38.215574460265088,0.91666666666666663,31.718926802020022]
["N206",442265,112516,"Charlottes Place",56.075356398243528,null,40.562413619711904,34.768981483370631,35.715122092351379,36.052784520917207,39.438252722858394,40.250461160582972,40.26578274355564,41.278734400602644,44.513287975565227,49.134411268727881,41.64141712604431,0.91666666666666663,34.562376214616776]
["N207",439698,112806,"205 Waterhouse Lane",34.831770988927715,37.150783488216646,36.834963174833241,25.1892198322379,31.805925603987291,30.286204172881561,27.960521029192662,33.539226152087579,28.788094200241989,38.78141973929236,42.473879553910699,33.254908457911256,33.408076366143405,1,27.728703383899024]
["N208",441365,115202,"Sherwood Close",42.102703505651235,29.763905535278301,40.291481445964827,26.719336376980689,25.957668135435291,25.31824000762817,26.624124036625492,29.279008244226908,29.592380059283066,29.806246667969678,37.599229807913822,32.904446426449219,31.329897520783891,1,26.003814942250628]
["N209",441246,115138,"40 Burgess Road",45.433006213951366,33.010568190576613,38.312528526221953,27.493322191427229,24.091013450834229,21.655831922353286,25.578609077976729,27.746553884453814,29.390822141557695,26.980068484248648,32.056467266794371,36.425213875119681,30.681167102126306,1,25.465368694764834]
["N210",441122,115118,"18 Burgess Road",49.827111628256155,35.386650219718376,39.973890739989891,30.774976255018764,29.403231616578665,28.682765708839085,null,30.171866378256841,33.263333534991595,28.98200888504142,36.354861268599336,37.538677872701221,34.578124918908301,0.91666666666666663,28.699843682693889]
["N211",437332,113873,"4 Coniston Road",27.942029590520811,null,34.09873389328969,24.226800987366055,20.855713928384304,22.442302641399536,23.421018872573867,27.793542375834399,22.715880833010935,30.901360655735022,30.315515497147651,27.326472466736206,26.549033794727141,0.91666666666666663,22.035698049623527]
["N213",442935,114374,"277 Portswood Road",37.668545468058717,29.855400816783884,30.562359372750588,26.247144662291731,24.797795646963202,23.028221052634784,30.783858481072567,25.259047092772295,29.552578167195961,29.640398936169504,32.283915595514529,32.186703942169039,29.322164102864736,1,24.337396205377729]
["N214",441677,115280,"64 Burgess Road 2019",40.61071449791617,30.381467451366277,43.355740549866695,32.592197378879909,26.339553588684488,27.85926782733204,29.035233267818004,31.956930517294154,30.040975831089661,26.781523025245157,32.864157755868305,34.828491673279203,32.220521113720004,1,26.743032524387601]
["N216",442352,113486,"73 Lodge Road",40.267252649300147,34.708469796585334,40.838525285958177,26.533712014670634,29.070444715027612,30.186081303915589,30.260636567806984,29.635029164362948,29.293194134332499,36.417911160055624,39.514004558520682,34.823342991529579,33.46238369517215,1,27.773778466992884]
["N217",440751,112188,"11 Saxon Road",39.195629334154383,40.1636979193364,40.049639481803659,26.471045024091403,29.770700809338745,27.20450797457881,27.882273908198385,31.593351344654199,29.689495658885484,37.685690951966144,37.306877045114355,29.630868550370668,33.053648166874389,1,27.434527978505741]
["N218",443547,114101,"112 St Denys Road",47.444827586206898,32.929998202043926,25.647844660194174,39.748970156556908,28.157365781979408,28.760693692073971,29.236589427016153,33.396231807035072,33.358151079129712,29.929963172109865,35.9,30.403908972742538,32.909545378090719,1,27.314922663815295]

{"sheet":"2023","index":8,"n_rows":88,"n_cols":19,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data 2023"]
["Status"]
["Bias Adjustment factor ",null,null,"March 2024 0.81 "]
["Other comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"national bias adjustment factor 0.81 03/24 update"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gradko 20% TEA in water method"]
[]
[]
["Site ID","X OS Grid Ref","Y  ","Site Name","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","Undajusted annual mean","Data capture","adjusted annual mean 0.81 03/24 "]
["N100",444387,114453,"6 Sandringham Road",25.923809574242423,24.130501764310385,16.75372907153729,15.713839930511563,12.150689407791386,13.161887349953833,12.445326633164008,14.779488491051167,19.467052968359567,22.480142438205856,19.57186710418469,18.137437448854769,{"$f":"AVERAGE(E9:P9)","v":17.892981015180577},1,{"$f":"Q9*0.81","v":14.493314622296269}]
["N101",437548,113719,"Redbridge School Fence",45.753164111835041,50.030789371750721,35.581368383578088,40.929818600081703,25.301317748662989,32.446809203990135,32.765414750681693,34.5098471290815,41.79639970391942,37.484509837980141,41.238390351659341,34.33795637766714,{"$f":"AVERAGE(E10:P10)","v":37.681315464240662},1,{"$f":"Q10*0.81","v":30.521865526034937}]
["N103",438808,112903,"485 Millbrook Road",33.23594628743821,30.716973721614988,25.416047693428926,26.709461726505339,18.82652389696683,23.204722393398107,22.859802722838594,25.085954216170919,34.472203356365242,31.042271034998965,28.81586388059501,25.16168537104074,27.128954691780155,1,{"$f":"Q11*0.81","v":21.974453300341928}]
["N104",439222,112850,"Regents Park Junction",35.869037132450842,40.212489017527062,33.462984932968581,37.193615797545597,23.089878890157877,30.212089056751005,29.030677112769975,31.430159165538477,42.78992965568677,38.685021593440794,34.215444705321815,30.766860718171216,33.91318231486084,1,27.469677675037282]
["N106",439752,113984,"2 Romsey Road, Oakhill",38.280556443874495,39.93027561206064,30.614512075057291,33.494024857305419,23.76126246836138,28.898659006879377,27.09432024634334,28.795126021203998,39.627024586051839,36.300809943868664,33.09820143050603,null,32.717706608319311,0.92,26.501342352738643]
["N107",442364,112890,"Cranbury Place",53.473874760597958,49.250381953091981,39.313825609750516,43.070961158974832,36.311662493047493,37.949262092944146,36.154034170572288,37.665164186058767,44.510275050507197,47.739212576521062,42.82183847668788,43.074500545589252,42.611249422861952,1,34.515112032518182]
["N109",442585,113248,"72 Bevois Valley",39.043733574507542,43.082733859520701,33.209546905172509,33.082798209299717,32.887676940900278,31.001048769687696,null,28.726590327015899,38.974075641243722,44.679660521742754,32.353525114902631,29.025209392275706,35.09696356875174,0.92,28.42854049068891]
["N110",442579,112248,"Brintons Road 1",35.196248934811926,33.876741035854607,23.158519165534045,25.599677884613953,18.644374985511138,20.166258039935933,21.159671919224863,22.526633527235379,30.126331930673413,null,27.370645657660663,24.711739993058327,25.685167552192205,0.92,20.804985717275688]
["N111",null,null,"Brintons Road 2",30.579626651045213,33.403946713145473,23.225596701132986,25.182938942306279,19.792899111928666,19.944244189954986,20.33168475716824,22.055145848758354,32.481484915481758,32.370739478263495,27.370645657660663,24.936950548090341,25.972991959578039,1,21.038123487258211]
["N112",null,null,"Brintons Road 3",31.634854601620464,33.116158864539912,24.399453574114435,25.579833173075489,19.237779117493524,20.980308823199397,20.920475627964063,22.212308408250699,31.382413522571198,32.504740173915678,26.777840832154396,24.650318932595049,26.116373804291197,1,21.154262781475872]
["N113",444124,113288,"206 Bitterne Road",40.132842784590416,41.579755175608163,null,30.961964873503263,29.972309832377789,32.241687978465919,29.904606558063278,36.52338399188725,34.604380882423605,37.457195778587668,35.876048666011521,22.702503533611669,33.814243641375498,0.92,27.389537349514153]
["N114",444131,113322,"Bitterne Library",36.400010051057045,39.798504167603227,29.324796683530586,33.919779902928134,25.780182222843791,31.599284933115264,24.581064137195984,31.583800265347083,35.685402538965675,45.891868957598803,30.913563488145403,28.61795576274185,32.841351092589406,1,26.601494384997419]
["N115",437939,113474,"54 Redbridge Road",31.971685816165557,32.872373918650283,27.938741222779154,31.474405332825132,22.623423937301038,27.820924373087596,22.691322441430742,27.086509928269106,35.158382777244682,31.299318147987613,30.204887429079111,24.875374119391918,28.834779120350991,1,23.356171087484302]
["N116",437952,113407,"57 Redbridge Road",34.274651785714283,null,28.7,28.9,27.4,28.8,20.193064748204456,26.095709400055028,29.507621802002223,27.538444279348592,29.677723664577737,20.165550353028614,27.386615093902812,0.92,22.183158226061281]
["N117",443752,111121,"Victoria Road (Lamp Post)",38.889671194810418,41.188796899070951,28.159752534052224,33.097477201465587,26.763936703972895,28.203853157912889,26.791253632318,29.943353108274511,35.982608675378017,34.834889508898215,34.451682943734362,32.550585879560401,32.571488453287365,1,26.382905647162769]
["N118",442472,113065,"3 Rockstone Lane",null,36.380077181627904,29.366107000572764,30.737451683551601,26.66242887946327,26.099905153331598,22.073786661597946,26.019835316029397,null,35.490218429717764,null,null,29.103726288236533,0.66,23.574018293471593]
["N120",442716,111019,"6-9 Canute Road",37.554476263987361,37.291034585350943,30.949566613795717,32.859477427857527,33.038586419753088,31.356474083214835,27.468238698015472,null,40.8724502131194,45.077243831257753,39.067583768115938,38.175732640174942,35.791896776785727,0.92,28.991436389196441]
["N122",440000,112633,"151 Paynes Road",27.497555720649032,32.876618801659809,24.688802563391743,24.825147361863781,17.686336825380245,23.950568317302096,24.122715427516379,25.136711296587119,35.778765456472385,30.605145537106388,28.917888703131947,29.286771322617149,27.114418944473172,1,21.962679345023272]
["N124",439741,112753,"305 Millbrook Road",null,37.928890152203508,29.267290558573677,34.084285919684035,25.184646279101639,31.955963754872741,25.947300763275805,28.325554761310087,null,35.179494192402018,33.351500557231162,27.677205162444544,30.89021321010992,0.83,25.021072700189038]
["N125",443125,112641,"Princes Court",38.169706395811602,39.711662497498729,32.877853411623335,34.800047776460737,32.213114001533874,32.949229991145927,23.269954030678377,32.723641583630879,40.08216780066877,34.758773040268153,32.636482711813628,28.028477258067984,33.518425874933499,1,27.149924958696136]
["N126",442365,112286,"107 St Andrews Road",35.080240063359156,38.820683361094936,30.123072388351215,32.15592449571745,26.378201183429816,27.058985699213128,22.600656241649787,26.783646984656059,39.77598212999191,40.317690708314537,34.291747043375338,28.925328481910952,31.859346565088696,1,25.806070717721845]
["N129",442554,111021,"South West House",37.19816109109847,32.928221461525872,25.128900338875685,26.625221597033974,24.694007716049384,23.126332767399987,20.203088607598335,25.163787847994207,31.520690452116668,29.241069249139507,31.43805359661382,24.653969244486621,27.660125330827711,1,22.404701517970448]
["N130",439346,112821,"367A Millbrook Road",39.213917896570216,44.802532626961131,43.060296984672256,38.992076204172925,33.091265822779071,39.41848881821349,36.516308245563508,41.530585371510298,53.313875576830767,46.307282204024858,41.142268927629146,33.388960197779831,40.8981549063923,1,33.127505474177767]
["N131",439378,114185,"142 Romsey Road",37.969516348228566,34.857135760767378,30.400291818651858,35.33074573758644,26.093183814226119,30.458249478180267,25.339950723744085,29.485849559575868,38.316951411784125,35.130300713694055,33.663911908580495,27.196870767904073,32.020246503576942,1,25.936399667897327]
["N133",438609,113020,"539 Millbrook Road",30.579343409320568,31.076392714114952,22.609707336365954,24.850287357698527,16.613224317618826,21.415956664349956,20.654404315434878,23.538104197653499,31.152837257518399,27.436040208490837,29.258855346158331,21.899290958984633,25.090370340309111,1,20.323199975650382]
["N134",438980,112861,"435 Millbrook Road West Ladbrokes",37.11923648615835,40.426862547483573,30.7,35.799999999999997,28.5,31.6,null,33.332275950002597,39.298816938948328,null,33.858787685819706,25.760489577922709,33.639646918633531,0.83,27.248114004093161]
["N138",441697,115288,"66 Burgess Road",37.686273159613833,44.041849436878543,38.878187106946179,44.037270019368179,40.146738420943642,44.234978462336358,27.376893226950159,34.21768500854408,45.915326562256347,42.748513281710906,34.293677644383379,30.157344416226614,38.644561395513186,1,31.302094730365681]
["N140",441628,112332,"5 Commercial Road ",47.319019686629986,null,41.501931635785262,41.317949404761897,32.547565239686989,37.354454075547579,33.132703676997941,37.890504693402697,48.47907811645986,47.616688448676499,40.524426242143704,35.850728996246552,40.321368201485363,0.92,32.660308243203147]
["N141",441923,110990,"Town Quay Road",35.213411885774143,37.249950636272899,31.132389124487847,39.254926338490222,35.161888888888889,35.437192819914159,22.751024065912919,32.325108812714078,36.038236979598729,32.438968957285105,30.030365118613094,21.037037257383378,32.339208407111286,1,26.194758809760142]
["N143",439457,114150,"102 Romsey Road",37.927540572946661,38.701351277537114,28.797165746495239,32.697682842456537,23.145598451766439,28.769663631667672,27.793391839876829,29.768293804078574,38.62013953265879,36.411146752208687,35.540559067444299,29.904977779911203,32.339792608254001,1,26.195232012685743]
["N149",441552,115247,"44B Burgess Road",33.034699261166189,43.999983205319829,37.745155990736791,35.983920965104943,27.058113976200719,30.458489383918167,26.756335234024554,27.365966850826048,37.81799083800059,41.579325514560168,36.307147680264528,20.309241124900005,33.201364168751873,1,26.89310497668902]
["N151",439394,114176,"134 Romsey Road ",37.530545221981988,39.79271729412082,31.869824541086899,35.348524201323059,25.438413139478694,29.970099009905571,26.840112394149344,29.850322181869274,38.616448946442894,35.550519647156484,33.995827855541556,30.790710889091351,32.966172110178995,1,26.702599409244989]
["N152",437327,113848,"M271",40.002879651198747,43.937317192778721,39.459979028587476,43.24917839135896,32.22078853401694,34.345610162764594,27.467095729920885,32.530216639292483,40.815684997406706,41.739866031554115,37.340107456269195,30.129644687648231,36.936530708566423,1,29.918589873938803]
["N158",443807,111123,"24 Portsmouth Road",38.844193872036186,43.291813301522524,31.129328978626631,36.635338216280573,27.953445001927246,31.864903985337445,28.303016191207949,31.490771995596102,40.06503743090893,38.136026369062058,34.508772003530822,31.753108221686446,34.49797963064357,1,27.943363500821295]
["N159",443740,111147,"35 Portsmouth Road",38.106747973751887,41.361075562624201,29.571142925034305,33.353554810912456,33.943468930911656,29.845894858689569,22.564901517098836,28.120389898949853,32.137388566228402,31.594740740740743,42.057119697605025,26.490752039558821,32.428931460175477,1,26.267434482742139]
["N162",442872,114336,"263A Portswood Road",42.329772522397349,34.896039110142617,31.190070405240206,34.325431008679438,26.902788581462055,30.615716367368613,27.480552705954906,29.062458301380047,37.507532393158776,40.918102943226458,null,34.451234099524193,33.60724531259406,0.92,27.221868703201189]
["N165",442766,114181,"8 The Broadway",34.078199856372997,38.452035450513677,30.78960697617029,34.301417597771533,27.265681225025965,30.649602052335261,23.49153775283699,30.023232390993531,38.148834944504117,33.619536505425032,28.020233515638601,27.65309282951694,31.374417591425416,1,25.413278249054589]
["N166",442251,112129,"14 New Road",41.423115082803662,41.975224013663158,31.489236104033793,30.997833405263872,26.436283473337209,29.731154519734094,27.062660006245128,29.610423741267063,40.849664913156758,41.935883480795042,38.83150448832933,34.524975405973201,34.572329886216856,1,28.003587207835654]
["N169",439361,114195,"150 Romsey Road",null,null,35.305632237143023,40.128433252613135,27.893462664344835,32.50958632343086,31.568191967146234,34.735740200529023,44.346130842915194,38.662017642334398,37.896779657738684,33.810376665471999,35.685635145366739,0.83,28.905364467747059]
["N170",442482,111003,"Union Castle House (2)",null,42.144684684678111,34.015055591892015,null,37.731084876543207,32.511859913167129,27.886233634717364,31.981164019016006,40.338615258649895,42.010764659051674,40.279578142206965,null,36.544337864435818,0.75,29.600913670193016]
["N172",441522,112126,"4 New Road",40.931645626018259,43.016894348407057,33.23915311971065,37.928557657729449,28.179545644405103,34.049956890742848,33.855184978702248,35.398107291271586,42.3963997982287,47.199323153691559,37.145594703769227,34.951438582300838,37.35765014958146,1,30.259696621160984]
["N174",443959,113315,"166A Bitterne Road West",42.447359289033606,43.961834159538235,38.887230384681864,40.914068610961102,30.757025479330206,35.887759316903107,28.262446082331479,31.105861295379661,42.96173683485997,47.415306562005355,37.439571393284396,34.124558123383885,37.847063127641071,1,30.65612113338927]
["N177",439844,113907,"95 Shirley High Street (Windsor Castle Pub)",29.933660317041145,45.237033965633437,32.017564864867744,37.02384729428568,26.691777171217421,31.210039355992844,24.658161662817552,28.474593279256482,39.294520430107525,37.713121090621001,33.351605358283898,25.827260013933291,32.619432067004837,1,26.421739974273919]
["N178",437265,113682,"2 Gover Road",23.726528084043029,27.639468752419042,22.03073115727155,22.397603841537865,17.256322249498776,19.089998015082266,15.801939826829743,19.685340289855073,6.3347958252115406,25.559401622469252,22.307896129738854,17.05052897473702,19.90671289739117,0.92,16.124437446886848]
["N184A",437811,113557,"Redbridge AMS (A)",41.449792672959752,42.615114598381489,31.295450120690546,36.647156820474109,22.123652605460336,29.205811503754923,25.51445432124353,29.961363258840539,39.459927412784914,34.429929539020684,35.66955539199671,27.32669948788697,32.974908977791209,1,26.709676272010881]
["N184B",null,null,"Redbridge AMS (B)",39.785552886397674,41.60094175960122,32.222010722273787,36.890669701687173,22.000743424318891,28.677343402225091,25.662258188824662,29.90162461847558,37.334648596610094,34.635606996647539,35.558135046954398,25.978745701488958,32.520690087125423,1,26.341758970571593]
["N184C",null,null,"Redbridge AMS (C)",41.903508554734643,41.609535219987862,31.809318775222636,37.391454179447436,21.672985607941701,29.10042443269894,25.979717926319566,29.283630672927636,37.267991114395649,34.452120881301902,35.528821106673881,30.165571856210054,33.013756693988498,1,26.741142922130685]
["N185",437167,113713,"Redbridge Causeway 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
["N186",437126,113701,"Redbridge Causeway 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
["N189",441790,112465,"Cumberland House",41.952620750617342,38.930530306789223,32.422492191415756,35.030478150879709,33.288244552683764,29.788371769384387,25.535233128239994,29.864062595269655,42.10494072030496,null,33.945267764200757,27.995848766171751,33.714371881450667,0.92,27.308641223975041]
["N190",442024,112553,"Brunswick Apartments",44.229306188055261,45.152952343180964,32.945840482754484,null,30.45250089720221,29.542186878728319,27.064283036099958,31.818666449828033,null,43.576891495599611,35.1,36.200000000000003,35.608262777144887,0.83,28.84269284948736]
["N191",441915,112097,"Marlands House",44.738625621733043,43.738978995341284,38.713001634656521,42.404765299776997,29.599890925970499,37.04084706938464,32.826445584305695,36.36640961127079,49.498659935080042,46.47572029200478,40.273858582231476,33.285660055254517,39.580238633917524,1,32.059993293473198]
["N192",441961,112029,"Above Bar Street Bus Stop ",46.229913142469464,41.999830579837628,35.728753116186638,32.944965428144812,34.541983708894378,32.722003638082661,32.194016811968886,34.705774372967582,null,45.026333856953933,43.219370778458206,26.628528044203616,36.903770316197075,0.92,29.892053956119632]
["N193",441975,112031,"Above Bar Street Taxi Rank",38.205256514959622,37.370291714127255,29.678204336900414,28.520019139673025,24.561203991640749,26.41802155850127,25.015805833037721,26.596228434704784,36.581835430873241,34.404651743016977,31.12169464141931,42.725283256210517,31.766541382922071,1,25.730898520166878]
["N194",442090,111775,"Vincents Walk Bus Stop",56.678743688741733,52.037134365323574,35.966390387448421,41.592001148300433,36.057144050681693,41.946136333016362,44.889910821781747,39.687756644409582,50.421467480072664,50.956198572389432,48.315978546257632,45.038219796513907,{"$f":"AVERAGE(E63:P63)","v":45.298923486244767},1,36.692128023858267]
["N195",441945,111655,"Bargate Street",41.433294231196847,39.934600351715147,32.452832069960941,34.269934202656778,33.294391794681211,33.336797754069003,26.236823642162911,31.079520010078678,39.734416370444428,40.220473572348936,33.456572492874905,38.789607169331866,35.353271971793468,1,28.63615029715271]
["N197",440957,115151,"351 Winchester Road",35.638791826624363,36.231682185288847,30.404574448472061,29.142492428378571,25.358601388888889,29.612483087163046,23.144606490192892,28.264493496841322,35.104979293430418,40.18716242842882,29.511255533199193,24.544684714903145,30.595483943484297,1,24.782341994222282]
["N198A",442304,112771,"Onslow Road (A)",37.992527314397947,37.192403779215397,32.361946431473484,33.022394762815537,28.230623884263885,27.527280161872891,26.608168096790383,27.660115565340362,34.249478138888016,37.59589481983047,32.417955314828284,33.7431464074037,32.383494556426697,1,26.230630590705626]
["N198B",null,null,"Onslow Road (B)",41.16040451953593,39.28601591248249,32.462605673873092,32.565406146964307,27.57988407947407,25.265240704828972,26.411942668347976,27.275704609915543,33.660661895812574,40.237561563790038,34.230244352804576,32.862712368861011,32.749865374724216,1,26.527390953526616]
["N198C",null,null,"Onslow Road (C)",44.064291957579094,38.97813177523733,33.234326532270074,32.803834990017123,26.450659124103513,27.422878340778556,26.510055382569178,28.219258773231008,34.563513468528242,37.251329592357479,32.841387333047045,32.023228750715653,32.863574668369523,1,26.619495481379314]
["N199",442210,112583,"Dorset Street/Charlottes Place Crossing",39.844636404143458,42.064294133741008,33.841720626786724,34.4206055081142,28.217204316043659,30.228223065353845,26.110136534735329,29.44143787827899,null,37.237544231480662,33.255779977110564,30.723890573414387,33.216861204472984,0.92,26.90565757562312]
["N200",443160,112765,"Northam Bridge South ",43.171341885999233,39.567106263758482,31.223096173315909,31.89174384093511,25.188626278085906,28.16574842475616,27.392079232743395,30.551950784080635,38.478227596010697,37,37.275987410518063,35.112372898173184,33.751523399031392,1,27.338733953215428]
["N201",439759,112738,"289 Millbrook Road West",60.17496520123666,66.363176744186049,47.918891283295025,57.900356552359909,49.388129282099683,57.087655989185819,39.971148518417642,48.168994165158196,57.842198968371576,56.725402253226015,60.186553748778969,46.5923665669605,54.026653272772997,1,43.761589150946129]
["N202",437166,113755,"Redbridge Causeway North ",47.074388902643697,52.439600278883717,45.130390822777535,45.687147659066184,35.578855853396824,45.60297379912874,40.892046347913521,40.748891809365865,47.228993709141605,58.535572481207417,46.935738194258491,38.646733178194559,45.375111086331515,1,36.753839979928529]
["N204",442542,113261,"6 Lodge Road",43.761877371254656,41.605900398403961,30.927963166241103,36.695686284261697,27.211728836427096,29.422052816825321,24.963452767362721,30.685468401756314,37.195893372794288,38.131000997052531,31.795166629067705,30.668822260249026,33.588751108474703,1,27.20688839786451]
["N205",442101,113438,"Stags Gate, Lodge Road",41.022933779046696,39.054977341767433,35.963819726783477,34.016627435374588,27.887858940933491,null,31.824674177063809,33.78917613228176,41.354823512566718,45.581493402592088,35.502181616829731,null,36.599856606523971,0.83,29.64588385128442]
["N206",442265,112516,"Charlottes Place",47.669351780798195,44.753616989534123,null,null,35.534904281236244,38.605388501000654,28.413626946471489,33.946498991424143,47.071741563587011,44.666050917158309,37.367073898696944,35.118315477397012,39.314656934730415,0.83,{"$f":"Q75*0.81","v":31.84487211713164}]
["N207",439698,112806,"205 Waterhouse Lane",null,36.56456561063203,30.495139710095422,31.968384174834238,18.831196882446168,26.952591606394204,24.971359769726593,27.877364964071329,40.236951210477905,34.730461653018651,28.830571309173965,27.211117924880725,29.879064074159206,0.92,24.202041900068959]
["N208",441365,115202,"Sherwood Close",34.507445179512672,36.968434026580489,29.371847770421901,31.108373547812164,20.217618110690356,25.681391402719875,20.8064388524778,26.588098305422822,35.679616852922756,37.23578805858925,30.584442606092168,26.104656956688242,29.571179305827545,1,23.952655237720315]
["N209",441246,115138,"40 Burgess Road",34.302046085237855,39.575517794950741,28.223734278341034,30.104216562408478,22.090327538712714,24.423729034787282,19.662719173197839,23.642955108514442,31.086318646897631,31.790436169478149,28.664839690561941,27.982730865969632,28.462464245754816,1,23.054596039061401]
["N210",441122,115118,"18 Burgess Road",39.251040856274635,40.225986515519885,32.994541431937691,35.411903485256531,25.873964954512992,28.930714378944256,25.204084186348897,28.244741353683779,33.654191846745981,36.930491620886279,35.420365335601012,27.251679762360904,32.449475477339398,1,26.284075136644915]
["N211",437332,113873,"4 Coniston Road",26.304371655107857,30.681298714703452,26.44328228870005,27.194258823530934,20.919957351846655,21.957594283442262,17.244707605346875,21.199185763418203,28.335541134086107,28.221139171422294,24.852106488389445,19.11966262911562,24.372758825759146,1,19.741934648864909]
["N214",441677,115280,"64 Burgess Road 2019",33.004422976881933,35.029582098406173,29.644221803427925,30.636274047419274,24.993780987431833,27.962794613521712,20.774161320980578,23.909428436932473,32.049050736882762,31.592567335767551,29.310204574424546,25.6881248502809,28.716217815196472,1,23.260136430309146]
["N216",442352,113486,"73 Lodge Road",35.806395904078244,34.782949350070865,31.03054339207819,null,24.069357761044305,29.666892190960137,26.691105852789633,30.624647607176925,40.746001575224291,37.729892408292187,32.607153931337173,29.80894873893363,32.142171701089595,0.92,26.035159077882572]
["N217",440751,112188,"11 Saxon Road",36.174888778800309,34.904795826120164,29.694155867278315,32.461176048768415,19.514811360538598,24.61848906560693,25.554446611910414,27.541403278177942,38.624613562338759,31.915417369720593,32.634456099843355,28.163585572669948,30.15018662014781,1,24.421651162319726]
["N218",443547,114101,"112 St Denys Road",40.081975472143704,39.779410210184892,29.835334902278955,35.199751586808738,30.908083117364107,31.577569924690259,22.799146984921286,31.403058108403592,35.619895213484945,40.564433483782153,39.581496626543071,27.984753756882387,33.777909115624013,1,27.360106383655452]
["N219",439255,1122861,"10 Regents Park Road",34.998210458419642,35.140710741233633,32.186577037903177,36.282689736151475,27.188811178402723,33.280888977235762,29.900113023378864,30.717915805333437,43.90086615338528,37.578564408044954,34.518668577232809,31.472857813925174,{"$f":"AVERAGE(E85:P85)","v":33.930572825887246},1,27.483763988968672]
["N220A",441928,116985,"253 Basset Avenue (A)",null,null,null,38.3814828972802,40.873231274422174,36.83247599346948,20.10017262287197,22.965489183873157,41.481729940201021,36.915218399883031,34.903793597904198,26.130692960176937,{"$f":"AVERAGE(E86:P86)","v":33.176031874453571},0.75,26.872585818307392]
["N220B",null,null,"253 Basset Avenue (B)",null,null,null,41.2,38.200000000000003,37,21.6,27.6,36.4,39.200000000000003,32.700000000000003,26.7,{"$f":"AVERAGE(E87:P87)","v":33.4},0.75,27.054000000000002]
["N220C",null,null,"253 Basset Avenue ©",null,null,null,39.4,39.4,37.799999999999997,20.7,25.6,37.4,39.700000000000003,35.9,27.5,33.711111111111109,0.75,27.306000000000001]

{"sheet":"QA QC Log","index":9,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Southampton City Council NO2 Diffusion Tube Data QA QC Log "]
[]
["Date","Update","Description"]
["2019-05-09","2017, 2018, partial 2019 data added","Data updated "]
["2019-07-18","2018 national bias adjustment factor update","National bias adjustment factor used updated from 0.93 to 0.92 in accordance with Defra's updated national local bias adjustment factor spreadsheet issued June 2019 (version 06/19, Gradko 20% TEA in water). https://laqm.defra.gov.uk/bias-adjustment-factors/national-bias.html "]
["2020-07-03","2019 national bias adjustment factor update","National bias adjustment factor remains at  0.92 in accordance with Defra's updated national local bias adjustment factor spreadsheet issued June 2020 (version 06/20, Gradko 20% TEA in water). https://laqm.defra.gov.uk/bias-adjustment-factors/national-bias.html "]

{"sheet":"Sheet1","index":10,"n_rows":113,"n_cols":15,"rows_kept":113,"cut":false,"hidden":true,"merged":[[1,5,2,5],[1,7,2,7]]}
[]
[null,null,null,null,null,"Ref",null,"Location","Sample ","Exposure Data",null,null,null,null,"µg NO2"]
[null,null,null,null,"no",null,"Trim",null,"Number","Date On*","Date Off*","Time* (hr.)","mg/m3 *","ppb *","on tube"]
["6 Sandringham Road","N100",{"$f":"VLOOKUP($B4,$F$4:$O$198,8,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"RIGHT(F4,3)","v":""},{"$f":"RIGHT(G4,4)","v":""},{"$f":"TRIM(H4)","v":""},null,null,null,null,null,null,17.399580465681151,1.6879999999999999]
["Redbridge School Fence","N101",{"$f":"VLOOKUP($B5,$F$4:$O$198,8,FALSE)","v":{"$error":"#N/A"}},null,"","","",null,null,null,null,null,null,20.348819939546001,1.9710000000000001]
["485 Millbrook Road","N103",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.320769080522847,1.968]
["Regents Park Junction","N104",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.506024204506472,1.355]
["2 Romsey Road, Oakhill","N106",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,12.842515299819365,1.2]
["Cranbury Place","N107",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.997090839627631,2.149]
["72 Bevois Valley","N109",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,26.259030370788626,2.4540000000000002]
["Brintons Road 1","N110",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.284037460234618,1.7110000000000001]
["Brintons Road 2","N111",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.315805357366926,1.8080000000000001]
["Brintons Road 3","N112",{"$f":"VLOOKUP($B13,$F$4:$O$198,8,FALSE)","v":{"$error":"#N/A"}},null,"","","",null,null,null,null,null,null,18.210887259964164,1.7050000000000001]
["206 Bitterne Road","N113",null,null,"","","",null,null,null,null,null,null,22.269618731393123,2.085]
["Bitterne Library","N114",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.001985548087184,1.593]
["54 Redbridge Road","N115",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.655101180201612,1.371]
["57 Redbridge Road","N116",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.761262273746327,1.381]
["Victoria Road (Lamp Post)","N117",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.71519760689409,1.7509999999999999]
["3 Rockstone Lane","N118",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.836484017994586,1.8560000000000001]
["6-9 Canute Road","N120",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,25.606604484283523,2.3959999999999999]
["151 Paynes Road","N122",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.504815319461159,1.6379999999999999]
["305 Millbrook Road","N124",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.123744905060146,1.696]
["Princes Court","N125",null,null,"","","",null,null,null,null,null,null,31.576067096196155,2.9550000000000001]
["107 St Andrews Road","N126",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.734767123256521,1.379]
["South West House","N129",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.981888594157848,1.7729999999999999]
["367A Millbrook Road","N130",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.725675778923749,1.4690000000000001]
["142 Romsey Road","N131",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,0.33182267253565567,3.1E-2]
["539 Millbrook Road","N133",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.01760084981996,1.59]
["435 Millbrook Road West Ladbrokes","N134",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.53432775979876,1.5449999999999999]
["66 Burgess Road","N138",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.918956277916145,1.768]
["5 Commercial Road ","N140",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.932704234170714,1.6759999999999999]
["Town Quay Road","N141",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.787460394916643,1.9430000000000001]
["102 Romsey Road","N143",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.699368045389825,1.748]
["44B Burgess Road","N149",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.948754985787058,1.6779999999999999]
["134 Romsey Road ","N151",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.819941390482253,1.972]
["M271","N152",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.092107384336517,1.3640000000000001]
["24 Portsmouth Road","N158",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.758218715937559,1.605]
["35 Portsmouth Road","N159",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.277771961233473,1.6519999999999999]
["263A Portswood Road","N162",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.605419965274667,1.5569999999999999]
["8 The Broadway","N165",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.871627591019195,1.5820000000000001]
["14 New Road","N166",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.278921577191234,1.714]
["150 Romsey Road","N169",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.48922304000741,1.544]
["Union Castle House (2)","N170",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.085643035710689,1.79]
["4 New Road","N172",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.703044950088625,1.379]
["166A Bitterne Road West","N174",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.751968141500818,1.665]
["95 Shirley High Street (Windsor Castle Pub)","N177",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.459569919702602,1.919]
["2 Gover Road","N178",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.555785098807029,2.1040000000000001]
["Redbridge AMS (A)","N184A",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.23447668457813,2.181]
["Redbridge AMS (B)","N184B",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.115643399340804,1.714]
["Redbridge AMS (C)","N184C",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.071463976524445,2.0489999999999999]
["Redbridge Causeway 1","N185",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.591062256789549,2.1080000000000001]
["Redbridge Causeway 2","N186",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.379775519627948,2.0840000000000001]
["Cumberland House","N189",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,13.228817886839918,1.5009999999999999]
["Brunswick Apartments","N190",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,12.447936111137038,1.454]
["Marlands House","N191",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,12.442923244513461,1.4950000000000001]
["Above Bar Street Bus Stop ","N192",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.121661198012948,1.8280000000000001]
["Above Bar Street Taxi Rank","N193",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,21.007547578592366,2.3820000000000001]
["Vincents Walk Bus Stop","N194",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.797690498372937,2.0179999999999998]
["Bargate Street","N195",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.06229994927069,1.7090000000000001]
["351 Winchester Road","N197",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.305005796460375,1.85]
["Onslow Road (A)","N198A",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.093481396938724,1.8260000000000001]
["Onslow Road (B)","N198B",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,20.324385129495273,2.306]
["Onslow Road (C)","N198C",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,18.411812894846324,2.089]
["Dorset Street/Charlottes Place Crossing","N199",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.7352230790256,1.671]
["Northam Bridge South ","N200",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.811044273305146,1.7929999999999999]
["289 Millbrook Road West","N201",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,13.183218733179695,1.4950000000000001]
["Redbridge Causeway North ","N202",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.318957586602323,1.964]
["6 Lodge Road","N204",{"$f":"VLOOKUP($B68,$F$4:$O$198,8,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"RIGHT(F68,3)","v":""},{"$f":"RIGHT(G68,4)","v":""},{"$f":"TRIM(H68)","v":""},null,null,null,null,null,null,17.239593728004216,1.9550000000000001]
["Stags Gate, Lodge Road","N205",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.269591011850526,1.845]
["Charlottes Place","N206",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.467134219396112,1.754]
["205 Waterhouse Lane","N207",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.88566168950625,1.9159999999999999]
["Sherwood Close","N208",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,22.17416654045995,2.5219999999999998]
["40 Burgess Road","N209",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,16.678982524683796,1.897]
["18 Burgess Road","N210",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.281319542915924,1.738]
["4 Coniston Road","N211",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.481499939694057,1.647]
["64 Burgess Road 2019","N214",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,15.747320656710251,1.7909999999999999]
["73 Lodge Road","N216",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.639170218027688,1.665]
["11 Saxon Road","N217",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,7.7259772750815205,0.877]
["112 St Denys Road","N218",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,12.87561646038246,1.462]
["10 Regents Park Road","N219",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,17.430183615362772,1.9790000000000001]
["253 Basset Avenue (A)","N220A",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,19.296583154119414,2.2000000000000002]
["253 Basset Avenue (B)","N220B",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,14.770657287059162,1.6839999999999999]
["253 Basset Avenue ©","N220C",{"$error":"#N/A"},null,"","","",null,null,null,null,null,null,13.279828017993459,1.514]
[null,null,null,null,"","","",null,null,null,null,null,null,15.165360124305668,1.7290000000000001]
[null,null,null,null,"","","",null,null,null,null,null,null,21.49287694913863,2.4500000000000002]
[null,null,null,null,"","","",null,null,null,null,null,null,12.704539591744581,1.448]
[null,null,null,null,"","","",null,null,null,null,null,null,17.13184690678375,1.9530000000000001]
[null,null,null,null,"","","",null,null,null,null,null,null,20.186853756190928,1.954]
[null,null,null,null,"","","",null,null,null,null,null,null,22.304717123652104,2.1589999999999998]
[null,null,null,null,"","","",null,null,null,null,null,null,11.12,1.1499999999999999]
[null,null,null,null,"","","",null,null,null,null,null,null,11.06,1.1499999999999999]
[null,null,null,null,"","","",null,null,null,null,null,null,16.758575192206717,1.96]
[null,null,null,null,"","","",null,null,null,null,null,null,20.350506135645482,2.38]
[null,null,null,null,"","","",null,null,null,null,null,null,17.478025224130445,1.85]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,null,"",""]