{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Calculator","aqi_breaks_usa","aqi_breaks_eu","aqi_breaks_uk","aqi_breaks_india","aqi_breaks_china","aqi_breaks_skorea","aqi_breaks_singapore","Equations","Unit_Conversion","break_point_tally","Concentrations","Country"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":4,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,4,4,5],[7,1,9,1],[10,1,12,1],[13,1,15,1],[22,1,24,1],[19,1,21,1],[16,1,18,1],[4,1,4,3]]}
[]
[]
[]
[]
[null,"Select a nation for required formats",null,null,"USA"]
[]
[null,null,"reqd.time.avg","Conc","Unit","AQI","Remarks"]
[null,"PM2.5","24hr",37.5,"micro-g/m3",105.25,"Unhealthy for Sensitive Groups",null,"Version.1: Calculates AQI for selected country methodology and concentrations for one instance"]
[null,null,"8hr",null,"micro-g/m3","NA"]
[null,null,"1hr",null,"micro-g/m3","NA"]
[null,"PM10","24hr",130,"micro-g/m3",88,"Moderate"]
[null,null,"8hr",null,"micro-g/m3","NA",null,null,null,"Conditional Pollutant","PM2.5-24hr",105.25,"Unhealthy for Sensitive Groups"]
[null,null,"1hr",null,"micro-g/m3","NA",null,null,null,"Average of worst two",null,96.625,"Moderate"]
[null,"SO2","24hr",54,"micro-g/m3",28.500449187289504,"Good",null,null,"Average of all",null,49.564995330432595,"Good"]
[null,null,"8hr",null,"micro-g/m3","NA"]
[null,null,"1hr",null,"micro-g/m3","NA"]
[null,"NO2","24hr",34,"micro-g/m3",19.95838583713973,"Good"]
[null,null,"8hr",null,"micro-g/m3","NA"]
[null,null,"1hr",80,"micro-g/m3","NA"]
[null,"CO","24hr",null,"micro-g/m3","NA"]
[null,null,"8hr",2000,"micro-g/m3",19.192221674942427,"Good"]
[null,null,"1hr",10000,"micro-g/m3","NA"]
[null,"Ozone","24hr",null,"micro-g/m3","NA"]
[null,null,"8hr",80,"micro-g/m3",36.488915283223875,"Good"]
[null,null,"1hr",200,"micro-g/m3",0]

{"sheet":"aqi_breaks_usa","index":1,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,1,2,1],[0,2,2,15],[20,6,20,23],[4,6,4,23]]}
[null,1,"USA AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B20)","v":6},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[null,1,"Good",0,50,43,12,null,null,54,null,null,{"$f":"M27*Unit_Conversion!$K$11","v":94.735348985451537},null,null,{"$f":"P27*Unit_Conversion!$K$12","v":85.17722895388367},null,null,null,{"$f":"T27*Unit_Conversion!$G$13","v":5210.4441941998348},null,null,{"$f":"W27*Unit_Conversion!$G$14","v":109.62233239745107},{"$f":"X27*Unit_Conversion!$G$14","v":0}]
[null,2,"Moderate",50,100,27,35.4,null,null,154,null,null,{"$f":"M28*Unit_Conversion!$K$11","v":203.00431925453901},null,null,{"$f":"P28*Unit_Conversion!$K$12","v":160.71175274317673},null,null,null,{"$f":"T28*Unit_Conversion!$G$13","v":11131.403505790555},null,null,{"$f":"W28*Unit_Conversion!$G$14","v":142.10302347817733},{"$f":"X28*Unit_Conversion!$G$14","v":253.7553990681738}]
[null,3,"Unhealthy for Sensitive Groups",100,150,45,55.4,null,null,254,null,null,{"$f":"M29*Unit_Conversion!$K$11","v":500.74398749452956},null,null,{"$f":"P29*Unit_Conversion!$K$12","v":578.5623098754362},null,null,null,{"$f":"T29*Unit_Conversion!$G$13","v":14683.979092744987},null,null,{"$f":"W29*Unit_Conversion!$G$14","v":172.5536713663582},{"$f":"X29*Unit_Conversion!$G$14","v":332.92708357744402}]
[null,4,"Unhealthy",150,200,3,150.4,null,null,354,null,null,{"$f":"M30*Unit_Conversion!$K$11","v":822.84417404506485},null,null,{"$f":"P30*Unit_Conversion!$K$12","v":1043.019275303217},null,null,null,{"$f":"T30*Unit_Conversion!$G$13","v":18236.55467969942},null,null,{"$f":"W30*Unit_Conversion!$G$14","v":213.15453521726599},{"$f":"X30*Unit_Conversion!$G$14","v":414.12881127925959}]
[null,5,"Very Unhealthy",200,300,13,250.4,null,null,424,null,null,{"$f":"M31*Unit_Conversion!$K$11","v":1634.861451063221},null,null,{"$f":"P31*Unit_Conversion!$K$12","v":2007.2897917622772},null,null,null,{"$f":"T31*Unit_Conversion!$G$13","v":35999.432614471581},null,null,{"$f":"W31*Unit_Conversion!$G$14","v":406.00863850907808},{"$f":"X31*Unit_Conversion!$G$14","v":820.13744978833779}]
[null,6,"Hazardous",300,500,9,500.4,null,null,604,null,null,{"$f":"M32*Unit_Conversion!$K$11","v":2717.5511537540956},null,null,{"$f":"P32*Unit_Conversion!$K$12","v":3292.9838137076913},null,null,null,{"$f":"T32*Unit_Conversion!$G$13","v":59683.269860834458},null,null,{"$f":"W32*Unit_Conversion!$G$14","v":0},{"$f":"X32*Unit_Conversion!$G$14","v":1226.1460882974159}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Break Points"]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,null,null,null,null,null,null,"ug/m3",null,null,"ppb",null,null,"ppb",null,null,null,"ppm",null,null,"ppm","ppm"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,35,null,null,53,null,null,null,4.4000000000000004,null,null,5.3999999999999999E-2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,75,null,null,100,null,null,null,9.4,null,null,7.0000000000000007E-2,0.125]
[null,null,null,null,null,null,null,null,null,null,null,null,185,null,null,360,null,null,null,12.4,null,null,8.5000000000000006E-2,0.16400000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,304,null,null,649,null,null,null,15.4,null,null,0.105,0.20399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,604,null,null,1249,null,null,null,30.4,null,null,0.2,0.40400000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,1004,null,null,2049,null,null,null,50.4,null,null,0,0.60399999999999998]

{"sheet":"aqi_breaks_eu","index":2,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,1,2,1],[0,2,2,15],[4,6,4,23]]}
[null,2,"EU AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B20)","v":6},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",0,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,null,0]
[null,1,"Very Good",0,50,10,10,null,null,20,null,null,null,null,100,null,null,40,null,null,null,null,null,50]
[null,2,"Good",50,100,43,20,null,null,40,null,null,null,null,200,null,null,90,null,null,null,null,null,100]
[null,3,"Medium",100,200,27,25,null,null,50,null,null,null,null,350,null,null,120,null,null,null,null,null,130]
[null,4,"Poor",200,300,45,50,null,null,100,null,null,null,null,500,null,null,230,null,null,null,null,null,240]
[null,5,"Very Poor",300,400,46,75,null,null,150,null,null,null,null,750,null,null,340,null,null,null,null,null,380]
[null,6,"Extremely Poor",400,500,3,800,null,null,1200,null,null,null,null,1250,null,null,1000,null,null,null,null,null,800]

{"sheet":"aqi_breaks_uk","index":3,"n_rows":20,"n_cols":24,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,1,2,1],[0,2,2,15],[4,6,4,23]]}
[null,3,"UK AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B20)","v":10},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",0,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0]
[null,1,"Low",0,1,43,11,null,null,16,null,null,null,null,88,null,null,67,null,null,null,null,33]
[null,2,"Low",1,2,43,23,null,null,33,null,null,null,null,177,null,null,134,null,null,null,null,66]
[null,3,"Low",2,3,43,35,null,null,50,null,null,null,null,266,null,null,200,null,null,null,null,100]
[null,4,"Moderate",3,4,27,41,null,null,58,null,null,null,null,354,null,null,267,null,null,null,null,120]
[null,5,"Moderate",4,5,44,47,null,null,66,null,null,null,null,443,null,null,334,null,null,null,null,140]
[null,6,"Moderate",5,6,45,53,null,null,75,null,null,null,null,532,null,null,400,null,null,null,null,160]
[null,7,"High",6,7,46,58,null,null,83,null,null,null,null,710,null,null,467,null,null,null,null,187]
[null,8,"High",7,8,3,64,null,null,91,null,null,null,null,887,null,null,534,null,null,null,null,213]
[null,9,"High",8,9,53,70,null,null,100,null,null,null,null,1064,null,null,600,null,null,null,null,240]
[null,10,"Very High",9,10,13,100,null,null,150,null,null,null,null,1500,null,null,1000,null,null,null,null,300]

{"sheet":"aqi_breaks_india","index":4,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,3,8,4],[4,6,4,23],[0,1,2,1],[0,2,2,15]]}
[null,4,"INDIA AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B20)","v":6},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",0,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0]
[null,1,"Good",0,50,10,30,null,null,50,null,null,40,null,null,40,null,null,null,1000,null,null,50]
[null,2,"Satisfactory",50,100,43,60,null,null,100,null,null,80,null,null,80,null,null,null,2000,null,null,100]
[null,3,"Moderate",100,200,6,90,null,null,250,null,null,380,null,null,180,null,null,null,10000,null,null,168]
[null,4,"Poor",200,300,45,120,null,null,350,null,null,800,null,null,280,null,null,null,17000,null,null,208]
[null,5,"Very Poor",300,400,3,250,null,null,430,null,null,1600,null,null,400,null,null,null,34000,null,null,748]
[null,6,"Severe",400,500,9,500,null,null,750,null,null,2500,null,null,800,null,null,null,50000,null,null,1000]

{"sheet":"aqi_breaks_china","index":5,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,1,2,1],[0,2,2,15],[4,6,4,23]]}
[null,5,"CHINA AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B19)","v":6},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,0,0]
[null,1,"Optimal",0,50,4,35,null,null,50,null,null,50,null,null,40,null,null,2000,null,null,null,100,0]
[null,2,"Good",50,100,6,75,null,null,150,null,null,150,null,null,80,null,null,4000,null,null,null,160,0]
[null,3,"Light Pollution",100,200,22,115,null,null,350,null,null,800,null,null,280,null,null,24000,null,null,null,265,0]
[null,4,"Moderate Pollution",200,300,3,150,null,null,420,null,null,1600,null,null,565,null,null,36000,null,null,null,800,800]
[null,5,"High Pollution",300,400,21,250,null,null,500,null,null,2100,null,null,750,null,null,48000,null,null,null,0,1000]
[null,6,"Severe Pollution",400,500,30,500,null,null,600,null,null,2620,null,null,940,null,null,60000,null,null,null,0,1200]

{"sheet":"aqi_breaks_skorea","index":6,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,1,2,1],[0,2,2,15],[4,6,4,23],[21,6,21,23]]}
[null,6,"S.KOREA AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B20)","v":6},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",null,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0]
[null,1,"Good",0,50,43,null,null,null,30,null,null,{"$f":"M27*Unit_Conversion!$G$11","v":54.134485134543738},null,null,{"$f":"P27*Unit_Conversion!$G$12","v":48.213525822953017},null,null,null,{"$f":"T27*Unit_Conversion!$G$13","v":2368.3837246362882},null,null,{"$f":"W27*Unit_Conversion!$G$14","v":81.201727701815614}]
[null,2,"Moderate",50,100,27,null,null,null,80,null,null,{"$f":"M28*Unit_Conversion!$G$11","v":135.33621283635935},null,null,{"$f":"P28*Unit_Conversion!$G$12","v":96.427051645906033},null,null,null,{"$f":"T28*Unit_Conversion!$G$13","v":10657.726760863297},null,null,{"$f":"W28*Unit_Conversion!$G$14","v":162.40345540363123}]
[null,3,"Unhealthy for Sensitive Groups",100,150,45,null,null,null,120,null,null,{"$f":"M29*Unit_Conversion!$G$11","v":270.6724256727187},null,null,{"$f":"P29*Unit_Conversion!$G$12","v":241.06762911476508},null,null,null,{"$f":"T29*Unit_Conversion!$G$13","v":14210.302347817729},null,null,{"$f":"W29*Unit_Conversion!$G$14","v":243.60518310544683}]
[null,4,"Unhealthy",150,250,3,null,null,null,200,null,null,{"$f":"M30*Unit_Conversion!$G$11","v":406.00863850907803},null,null,{"$f":"P30*Unit_Conversion!$G$12","v":321.42350548635346},null,null,null,{"$f":"T30*Unit_Conversion!$G$13","v":17762.877934772161},null,null,{"$f":"W30*Unit_Conversion!$G$14","v":609.01295776361712}]
[null,5,"Very Unhealthy",250,350,13,null,null,null,300,null,null,{"$f":"M31*Unit_Conversion!$G$11","v":1082.6897026908748},null,null,{"$f":"P31*Unit_Conversion!$G$12","v":964.27051645906033},null,null,null,{"$f":"T31*Unit_Conversion!$G$13","v":35525.755869544322},null,null,{"$f":"W31*Unit_Conversion!$G$14","v":1015.0215962726952}]
[null,6,"Hazardous",350,500,9,null,null,null,600,null,null,{"$f":"M32*Unit_Conversion!$G$11","v":2706.7242567271869},null,null,{"$f":"P32*Unit_Conversion!$G$12","v":3214.2350548635345},null,null,null,{"$f":"T32*Unit_Conversion!$G$13","v":59209.593115907206},null,null,{"$f":"W32*Unit_Conversion!$G$14","v":1218.0259155272342}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Break Points"]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ppm",null,null,"ppm",null,null,null,"ppm",null,null,"ppm"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.02,null,null,0.03,null,null,null,2,null,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,0.06,null,null,null,9,null,null,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,0.15,null,null,null,12,null,null,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,0.15,null,null,0.2,null,null,null,15,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,0.6,null,null,null,30,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,2,null,null,null,50,null,null,0.6]

{"sheet":"aqi_breaks_singapore","index":7,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,2,1],[0,2,2,15],[4,6,4,23],[8,3,8,4],[21,6,21,23]]}
[null,7,"SINGAPORE AQI Break Points Information"]
[]
[]
[]
[null,"Number of bins",null,"Number of polls",null,null,"Break Points"]
[null,{"$f":"MAX(B11:B20)","v":6},null,{"$f":"MAX(G6:X6)","v":18},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,"AQI",null,null,"ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3","ug/m3"]
[null,null,null,"Low","High","col.code",0,null,null,0,null,null,0,null,null,null,null,0,null,0,null,null,0,0]
[null,1,"Good",0,50,43,12,null,null,50,null,null,80,null,null,null,null,0,null,5000,null,null,118,0]
[null,2,"Moderate",50,100,27,55,null,null,150,null,null,365,null,null,null,null,0,null,10000,null,null,157,0]
[null,3,"Unhealthy",100,200,45,150,null,null,350,null,null,800,null,null,null,null,1130,null,17000,null,null,235,0]
[null,4,"Very Unhealthy",200,300,3,250,null,null,420,null,null,1600,null,null,null,null,2260,null,34000,null,null,785,785]
[null,5,"Hazardous",300,400,13,350,null,null,500,null,null,2100,null,null,null,null,3000,null,46000,null,null,0,980]
[null,6,"Hazardous",400,500,9,500,null,null,600,null,null,2620,null,null,null,null,3750,null,57500,null,null,0,1180]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Break Points"]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,null,null,"PM2.5","PM2.5","PM2.5","PM10","PM10","PM10","SO2","SO2","SO2","NO2","NO2","NO2","CO","CO","CO","Ozone","Ozone","Ozone"]
[null,null,null,null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ppm",null,null,"ppm",null,null,null,"ppm",null,null,"ppm"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.02,null,null,0.03,null,null,null,2,null,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,0.06,null,null,null,9,null,null,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,0.15,null,null,null,12,null,null,0.12]
[null,null,null,null,null,null,null,null,null,null,null,null,0.15,null,null,0.2,null,null,null,15,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,0.6,null,null,null,30,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,2,null,null,null,50,null,null,0.6]

{"sheet":"Equations","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Unit_Conversion","index":9,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Conversion at temperature T [°C] and pressure p [atm] "]
[null,"temp",15,null,"gas constant =",null,null,null,{"$f":"22.414/273.16","v":8.2054473568604486E-2},null,null,null,null,null,null,null,null,"Units"]
[null,"press",1,null,"volume 1 mole =",null,null,null,{"$f":"I4*(C4+273.16)/C5","v":23.644817103529071},null,null,null,null,null,null,null,null,"micro-g/m3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mg/m3"]
[null,null,null,null,"from",null,"to",null,"from",null,"to",null,null,null,null,null,null,"ppm"]
[null,null,"MW",null,"ppm",null,"ug/m3",null,"ppb",null,"ug/m3",null,null,null,null,null,null,"ppb"]
[null,"PM2.5",0,null,1,"ð",0,null,1,"ð",0,"<-- not supported"]
[null,"PM10",0,null,1,"ð",0,null,1,"ð",0,"<-- not supported"]
[null,"SO2",64,null,1,"ð",{"$f":"E11*C11/$I$5*1000","v":2706.7242567271869},null,1,"ð",{"$f":"I11*C11/$I$5","v":2.706724256727187}]
[null,"NO2",38,null,1,"ð",{"$f":"E12*C12/$I$5*1000","v":1607.1175274317673},null,1,"ð",{"$f":"I12*C12/$I$5","v":1.6071175274317673}]
[null,"CO",28,null,1,"ð",1184.1918623181441,null,1,"ð",1.1841918623181442]
[null,"Ozone",48,null,1,"ð",2030.0431925453904,null,1,"ð",2.0300431925453903]

{"sheet":"break_point_tally","index":10,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,12,3,14],[3,15,3,17],[3,18,3,20],[3,21,3,23],[3,3,3,5],[3,6,3,8],[3,9,3,11]]}
[]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,"PM2.5",null,null,"PM10",null,null,"SO2",null,null,"NO2",null,null,"CO",null,null,"Ozone",null,null,"NH3"]
[null,null,null,"24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr","24hr","8hr","1hr"]
[null,1,"USA","x",null,null,"x",null,null,"x",null,null,"x",null,null,null,"x",null,null,"x","x"]
[null,2,"EU","x",null,null,"x",null,null,null,null,"x",null,null,"x",null,null,null,null,null,"x"]
[null,3,"UK","x",null,null,"x",null,null,null,null,"x",null,null,"x",null,null,null,null,"x"]
[null,4,"India","x",null,null,"x",null,null,"x",null,null,"x",null,null,null,"x",null,null,"x"]
[null,5,"China","x",null,null,"x",null,null,"x",null,null,"x",null,null,"x",null,null,null,"x","x"]
[null,6,"S.Korea",null,null,null,"x",null,null,"x",null,null,"x",null,null,null,"x",null,null,"x"]
[null,7,"Singapore","x",null,null,"x",null,null,"x",null,null,null,null,"x",null,"x",null,null,"x","x"]
[null,8]
[null,9]
[null,10]

{"sheet":"Concentrations","index":11,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,1,18,1],[19,1,21,1],[22,1,24,1],[0,1,3,11],[7,1,9,1],[10,1,12,1],[13,1,15,1],[4,1,4,11]]}
[null,"Converting all the pollutant concentrations to micro-g/m3"]
[]
[]
[]
[null,"NOTHING TO CHANGE HERE"]
[null,null,null,"input","input",null,null,null,"input","output"]
[null,null,"reqd.time.avg","conc","Unit",null,"pollname","MW","unit.code","conc - ug/m3","<== used for AQI calculations",null,null,"pollname"]
[null,"PM2.5","24hr",{"$f":"Calculator!D8","v":37.5},{"$f":"Calculator!E8","v":"micro-g/m3"},null,"PM2.5",{"$f":"IF(G8=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G8,Unit_Conversion!$B$9:$B$14,0)))","v":0},{"$f":"MATCH(E8,Unit_Conversion!$R$5:$R$8,0)","v":1},37.5,null,null,1,{"$f":"G8 & \"-\" & C8","v":"PM2.5-24hr"}]
[null,null,"8hr",{"$f":"Calculator!D9","v":0},{"$f":"Calculator!E9","v":"micro-g/m3"},null,"PM2.5",{"$f":"IF(G9=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G9,Unit_Conversion!$B$9:$B$14,0)))","v":0},{"$f":"MATCH(E9,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,2,{"$f":"G9 & \"-\" & C9","v":"PM2.5-8hr"}]
[null,null,"1hr",{"$f":"Calculator!D10","v":0},{"$f":"Calculator!E10","v":"micro-g/m3"},null,"PM2.5",{"$f":"IF(G10=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G10,Unit_Conversion!$B$9:$B$14,0)))","v":0},{"$f":"MATCH(E10,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,3,"PM2.5-1hr"]
[null,"PM10","24hr",{"$f":"Calculator!D11","v":130},{"$f":"Calculator!E11","v":"micro-g/m3"},null,"PM10",{"$f":"IF(G11=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G11,Unit_Conversion!$B$9:$B$14,0)))","v":0},{"$f":"MATCH(E11,Unit_Conversion!$R$5:$R$8,0)","v":1},130,null,null,4,"PM10-24hr"]
[null,null,"8hr",{"$f":"Calculator!D12","v":0},{"$f":"Calculator!E12","v":"micro-g/m3"},null,"PM10",{"$f":"IF(G12=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G12,Unit_Conversion!$B$9:$B$14,0)))","v":0},{"$f":"MATCH(E12,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,5,"PM10-8hr"]
[null,null,"1hr",{"$f":"Calculator!D13","v":0},{"$f":"Calculator!E13","v":"micro-g/m3"},null,"PM10",{"$f":"IF(G13=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G13,Unit_Conversion!$B$9:$B$14,0)))","v":0},{"$f":"MATCH(E13,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,6,"PM10-1hr"]
[null,"SO2","24hr",{"$f":"Calculator!D14","v":54},{"$f":"Calculator!E14","v":"micro-g/m3"},null,"SO2",{"$f":"IF(G14=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G14,Unit_Conversion!$B$9:$B$14,0)))","v":64},{"$f":"MATCH(E14,Unit_Conversion!$R$5:$R$8,0)","v":1},54,null,null,7,"SO2-24hr"]
[null,null,"8hr",{"$f":"Calculator!D15","v":0},{"$f":"Calculator!E15","v":"micro-g/m3"},null,"SO2",{"$f":"IF(G15=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G15,Unit_Conversion!$B$9:$B$14,0)))","v":64},{"$f":"MATCH(E15,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,8,"SO2-8hr"]
[null,null,"1hr",{"$f":"Calculator!D16","v":0},{"$f":"Calculator!E16","v":"micro-g/m3"},null,"SO2",{"$f":"IF(G16=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G16,Unit_Conversion!$B$9:$B$14,0)))","v":64},{"$f":"MATCH(E16,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,9,"SO2-1hr"]
[null,"NO2","24hr",{"$f":"Calculator!D17","v":34},{"$f":"Calculator!E17","v":"micro-g/m3"},null,"NO2",{"$f":"IF(G17=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G17,Unit_Conversion!$B$9:$B$14,0)))","v":38},{"$f":"MATCH(E17,Unit_Conversion!$R$5:$R$8,0)","v":1},34,null,null,10,"NO2-24hr"]
[null,null,"8hr",{"$f":"Calculator!D18","v":0},{"$f":"Calculator!E18","v":"micro-g/m3"},null,"NO2",{"$f":"IF(G18=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G18,Unit_Conversion!$B$9:$B$14,0)))","v":38},{"$f":"MATCH(E18,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,11,"NO2-8hr"]
[null,null,"1hr",{"$f":"Calculator!D19","v":80},{"$f":"Calculator!E19","v":"micro-g/m3"},null,"NO2",{"$f":"IF(G19=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G19,Unit_Conversion!$B$9:$B$14,0)))","v":38},{"$f":"MATCH(E19,Unit_Conversion!$R$5:$R$8,0)","v":1},80,null,null,12,"NO2-1hr"]
[null,"CO","24hr",{"$f":"Calculator!D20","v":0},{"$f":"Calculator!E20","v":"micro-g/m3"},null,"CO",{"$f":"IF(G20=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G20,Unit_Conversion!$B$9:$B$14,0)))","v":28},{"$f":"MATCH(E20,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,13,"CO-24hr"]
[null,null,"8hr",{"$f":"Calculator!D21","v":2000},{"$f":"Calculator!E21","v":"micro-g/m3"},null,"CO",{"$f":"IF(G21=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G21,Unit_Conversion!$B$9:$B$14,0)))","v":28},{"$f":"MATCH(E21,Unit_Conversion!$R$5:$R$8,0)","v":1},2000,null,null,14,"CO-8hr"]
[null,null,"1hr",{"$f":"Calculator!D22","v":10000},{"$f":"Calculator!E22","v":"micro-g/m3"},null,"CO",{"$f":"IF(G22=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G22,Unit_Conversion!$B$9:$B$14,0)))","v":28},{"$f":"MATCH(E22,Unit_Conversion!$R$5:$R$8,0)","v":1},10000,null,null,15,"CO-1hr"]
[null,"Ozone","24hr",{"$f":"Calculator!D23","v":0},{"$f":"Calculator!E23","v":"micro-g/m3"},null,"Ozone",{"$f":"IF(G23=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G23,Unit_Conversion!$B$9:$B$14,0)))","v":48},{"$f":"MATCH(E23,Unit_Conversion!$R$5:$R$8,0)","v":1},0,null,null,16,"Ozone-24hr"]
[null,null,"8hr",{"$f":"Calculator!D24","v":80},{"$f":"Calculator!E24","v":"micro-g/m3"},null,"Ozone",{"$f":"IF(G24=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G24,Unit_Conversion!$B$9:$B$14,0)))","v":48},{"$f":"MATCH(E24,Unit_Conversion!$R$5:$R$8,0)","v":1},80,null,null,17,"Ozone-8hr"]
[null,null,"1hr",{"$f":"Calculator!D25","v":200},{"$f":"Calculator!E25","v":"micro-g/m3"},null,"Ozone",{"$f":"IF(G25=0,0,INDEX(Unit_Conversion!$C$9:$C$14,MATCH(Concentrations!G25,Unit_Conversion!$B$9:$B$14,0)))","v":48},{"$f":"MATCH(E25,Unit_Conversion!$R$5:$R$8,0)","v":1},200,null,null,18,"Ozone-1hr"]

{"sheet":"Country","index":12,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,3,11],[4,1,4,11]]}
[null,"Countries with AQI methodologies, included in this workbook"]
[]
[]
[]
[null,"NOTHING TO CHANGE HERE"]
[]
[null,null,{"$f":"MATCH(Calculator!$E$5,D9:D16,0)","v":1},"<--Selected"]
[null,null,null,"Country's"]
[null,null,1,"USA"]
[null,null,2,"EU"]
[null,null,3,"UK"]
[null,null,4,"India"]
[null,null,5,"China"]
[null,null,6,"S.Korea"]
[null,null,7,"Singapore"]
[null,null,8,"AAD"]