AQI与浓度数据相互转化

SO2:
1.浓度转AQI
=IF(E3<=0.05,(50-0)/(0.05-0)*(E3-0)+0,IF(E3<=0.15,(100-50)/(0.15-0.05)*(E3-0.05)+50,IF(E3< =0.475,(150-100)/(0.475-0.150)*(E3-0.150)+100,IF(E3<=0.8,(200-150)/(0.8-0.475)*(E3-0.475)+ 150,IF(E3<=1.6,(300-200)/(1.6-0.8)*(E3-1.6)+200,IF(E3<=2.1,(400-300)/(2.1-1.6)*(E3-1.6)+300 ,IF(E3<=2.62,(500-400)/(2.62-2.1)*(E3-2.1)+400)))))))
2.AQI转浓度
=IF(G2<=50,(0.05-0)*(G2-0)/(50-0)+0,IF(G2<=100,(0.15-0.05)*(G2-0.05)/(100-50)+0.05,IF(G2 <=150,(0.475-0.150)*(G2-0.150)/(150-100)+100,IF(G2<=200,(0.8-0.475)*(G2-0.475)/(200-150) +150,IF(G2<=300,(1.6-0.8)*(G2-1.6)/(300-200)+0.800,IF(G2<=400,(2.1-1.6)*(G2-1.6)/(400-300) +1.600,IF(G2<=500,(2.62-2.1)*( G2-2.1)/(500-400)+2.100)))))))
NO2:
1.浓度转AQI
=IF(F3<=0.04,(50-0)/(0.04-0)*(F3-0)+0,IF(F3<=0.08,(100-50)/(0.08-0.04)*(F3-0.04)+50,
IF(F3<=0.18,(150-100)/(0.18-0.08)*(F3-0.08)+100,IF(F3<=0.28,(200-150)/(0.28-0.18)*(F3-0.18) +150,IF(F3<=0.565,(300-200)/(0.565-0.28)*(F3-0.28)+200,IF(F3<=0.75,(400-300)/(0.75-0.565)* (F3-0.565)+300,IF(F3<=0.94,(500-400)/(0.94-0.75)*(F3-0.75)+400)))))))
2.AQI转浓度
=IF(I2<=50,(0.04-0)*(I2-0)/(50-0)+0,IF(I2<=100,(0.08-0.04)*(I2-0.04)/(100-50)+0.04,IF(I2<=15 0,(0.18-0.08)*(I2-0.08)/(150-100)+0.08,IF(I2<=200,(0.28-0.18)*(I2-0.18)/(200-150)+0.180,IF(I2 <=300,(0.565-0.28)*(I2-0.28)/(300-200)+0.280,IF(I2<=400,(0.75-0.565)*(I2-0.565)/(400-300)+0. 565,IF(I2<=500,(0.94-0.75)*( I2-0.75)/(500-400)+0.750)))))))
PM10
1.浓度转AQI：
=IF(F3<=0.05,(50-0)/(0.05-0)*(F3-0)+0,IF(F3<=0.15,(100-50)/(0.15-0.05)*(F3-0.05)+50,IF(F3< =0.25,(150-100)/(0.25-0.15)*(F3-0.15)+100,IF(F3<=0.35,(200-150)/(0.35-0.25)*(F3-0.25)+150,I F(F3<=0.42,(300-200)/(0.42-0.35)*(F3-0.35)+200,IF(F3<=0.50,(400-300)/(0.50-0.42)*(F3-0.42)+ 300,IF(F3<=0.60,(500-400)/(0.60-0.50)*(F3-0.50)+400)))))))
2.AQI转浓度
=IF(E2<=50,(0.05-0)*(E2-0)/(50-0)+0,IF(E2<=100,(0.15-0.05)*(E2-0.05)/(100-50)+0.050,IF(E2< =150,(0.25-0.15)*(E2-0.15)/(150-100)+0.150,IF(E2<=200,(0.35-0.25)*(E2-0.25)/(200-150)+0.25 0,IF(E2<=300,(0.42-0.35)*(E2-0.35)/(300-200)+0.350,IF(E2<=400,(0.50-0.42)*(E2-0.42)/(400-3 00)+0.420,IF(E2<=500,(0.60-0.50)*( E2-0.50)/(500-400)+0.500)))))))
CO
1.浓度转AQI：
=IF(F3<=2,(50-0)/(2-0)*(F3-0)+0,IF(F3<=4,(100-50)/(4-2)*(F3-2)+50,I F(F3<=14,(150-100)/(14-4)*(F3-4)+100,I F(F3<=24,(200-150)/(24-14)*(F3-14)+150,IF(F3<=36,(300-200)/(36-24)*(F3-24) +200,IF(F3<=48,(400-300)/(48-36)*(F3-36)+300,IF(F3<=60,(500-400)/(60-48)*(F3-48)+400))))) ))
2.AQI转浓度
=IF(K2<=50,(2-0)*(K2-0)/(50-0)+0,IF(K2<=100,(4-2)*(K2-2)/(100-50)+2,I F(K2<=150,(14-4)*(
K2-4)/(150-100)+4,I F(K2<=200,(24-14)*( K2-14)/(200-100)+14,IF(K2<=300,(36-24)*(K2-24)/(3 00-200)+24,IF(K2<=400,(48-36)*(K2-36)/(400-300)+36,IF(K2<=500,(60-48)*(K2-48)/(500-400) +48)))))))
O3
1.浓度转AQI：
=IF(F3<=0.100,(50-0)/(0.100-0)*(F3-0)+0,IF(F3<=0.160,(100-50)/(0.160-0.100)*(F3-0.100)+50,I F(F3<=0.215,(150-100)/(0.215-0.160)*(F3-0.160)+100,IF(F3<=0.800,(200-150)/(0.800-0.215)*(F 3-0.215)+150))))
2. AQI转浓度：
=IF(M2<=50,(0.100-0)*(M2-0)/(50-0)+0,IF(M2<=100,(0.160-0.100)*(M2-0.100)/(100-50)+0.100 ,IF(M2<=150,(0.215-0.160)*(M2-0.160)/(200-150)+0.160,IF(M2<=0.800,(0.800-0.215)*(M2-0.2 15)/(300-200)+0.215))))
PM2.5
1.浓度转AQI
=IF(F3<=0.035,(50-0)/(0.035-0)*(F3-0)+0,IF(F3<=0.075,(100-50)/(0.075-0.035)*(F3-0.035)+50,I F(F3<=0.115,(150-100)/(0.115-0.075)*(F3-0.075)+100,IF(F3<=0.150,(200-150)/(0.150-0.115)*(F 3-0.115)+150,IF(F3<=0.250,(300-200)/(0.250-0.150)*(F3-0.150)+200,IF(F3<=0.350,(400-300)/(0 .350-0.250)*(F3-0.250)+300,IF(F3<=0.500,(500-400)/(0.500-0.350)*(F3-0.350)+400)))))))
2.AQI转浓度
=IF(C2<=50,(0.035-0)*( C2-0)/(50-0)+0,IF(C2<=100,(0.075-0.035)*( C2-0.035)/(100-50)+0.035, IF(C2<=150,(0.115-0.075)*(C2-0.075)/(150-100)+0.075,IF(C2<=200,(0.150-0.115)*(C2-0.115)/( 200-150)+0.115,IF(C2<=300,(0.250-0.150)*(C2-0.150)/(300-100)+0.150,IF(C2<=400,(0.350-0.2 50)*(C2-0.250)/(400-300)+0.250,IF(C2<=500,(0.500-0.350)*( C2-0.350)/(500-400)+0.350)))))))。