【无标题】

2401_83851554

已于 2024-03-28 20:49:32 修改

阅读量335

点赞数 3

文章标签：算法

于 2024-03-28 20:42:06 首次发布

本文链接：https://blog.csdn.net/2401_83851554/article/details/137123588

版权

各类空气污染物IAQI函数计算公式
臭氧，8h滑动平均：=ROUNDUP(IF(D3:D33<100,50*D3:D33/100,IF(D3:D33<160,50*(D3:D33-100)/60+50,IF(D3:D33<215,50*(D3:D33-160)/55+100,IF(D3:D33<265,50*(D3:D33-215)/ 50+150,IF(D3:D33<800,100*(D3:D33-265)/ 535+200))))),0)
PM10，24h平均：=ROUNDUP(IF(E3:E33<50,50*E3:E33/50,IF(E3:E33<150,50*(E3:E33-50)/100+50,IF(E3:E33<250,50*(E3:E33-150)/100+100,IF(E3:E33<350,50*(E3:E33-250)/100+150,IF(E3:E33<420,100*(E3:E33-350)/70+200,IF(E3:E33<500,100*(E3:E33-420)/80+300,IF(E3:E33<600,100*(E3:E33-500)/100+400))))
PM2.5，24h平均：=ROUNDUP(IF(F3:F33<35,50*F3:F33/35,IF(F3:F33<75,50*(F3:F33-35)/40+50,IF(F3:F33<115,50*(F3:F33-75)/40+100,IF(F3:F33<150,50*(F3:F33-115)/35+150,IF(F3:F33<250,100*(F3:F33-150)/100+200,IF(F3:F33<350,100*(F3:F33-250)/100+300,IF(F3:F33<500,100*(F3:F33-350)/150+400))))))),0)
SO2，24h平均：=ROUNDUP(IF(G3:G33<50,50*G3:G33/50,IF(G3:G33<150,50*(G3:G33-50)/100+50,IF(G3:G33<475,50*(G3:G33-150)/325+100,IF(G3:G33<800,50*(G3:G33-475)/325+150,IF(G3:G33<1600,100*(G3:G33-800)/ 800+200,IF(G3:G33<2100,100*(G3:G33-1600)/500+300,IF(G3:G33<2620,100*(G3:G33-2100)/520+400))))
NO2，24h平均：=ROUNDUP(IF(H3:H33<40,50*H3:H33/40,IF(H3:H33<80,50*(H3:H33-40)/40+50,IF(H3:H33<180,50*(H3:H33-80)/100+100,IF(H3:H33<280,50*(H3:H33-180)/100+150,IF(H3:H33<565,100*(H3:H33-280)/ 285+200,IF(H3:H33<750,100*(H3:H33-565)/185+300,IF(H3:H33<940,100*(H3:H33-750)/ 190+400))))))),0)
CO，24h平均：=ROUNDUP(IF(I3:I33<2,50*I3:I33/2,IF(I3:I33<4,50*(I3:I33-2)/2+50,IF(I3:I33<14,50*(I3:I33-4)/10+100,IF(I3:I33<24,50*(I3:I33-14)/10+150,IF(I3:I33<36,100*(I3:I33-24)/12+200,IF(I3:I33<48,100*(I3:I33-36)/12+300,IF(I3:I33<60,100*(I3:I33-48)/12+400))))))),0)