ELOOR DATA.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Calculation of AQI
2	Date			Station	ELOOR CAAQMS
3	28-December-23			City	ELOOR
4				State	KERALA
5
6	Pollutants		concentration in µg/m3 (except for CO)	Sub-Index			Air Quality Index
7					check
8	PM10	24-hr avg	47.84	48	1
9
10	PM2.5	24-hr avg	21.49	36	1
11							48
12	SO2	24-hr avg	1.52	2	1	AQI =
13
14	NO2	24-hr avg	3.29	4	1
15
16	*CO (mg/m3)	max 8-hr	0.62	31	1
17
18	O3	max 8-hr	30.76	31	1
19
20	NH3	24-hr avg	2.05	1	1
21	* Concentrations of minimum three pollutants are required; one of them should be PM10 or PM2.5
22	* The check displays "1" when a non-zero value is entered
23	Good	Minimal Impact			Poor	Breathing discomfort to people on prolonged exposure
24	(0–50)				(201–300)
25	Satisfactory	Minor breathing discomfort to sensitive people			Very Poor	Respiratory illness to the people on prolonged exposure
26	(51–100)				(301–400)
27	Moderate	Breathing discomfort to the people with lung,			Severe	Respiratory effects even on healthy people
28	(101–200)	heart disease, children and older adults			(>401)
29
30
31					ELOOR CAAQMS DATA 19/12/2023 -28/12/2023
32
33	PARAMETERS	PM10_AQ_AAQMS	PM2.5_AQ_AAQMS	SO2_AQ_AAQMS	CO_AQ_AAQMS	NO_AQ_AAQMS	NO2_AQ_AAQMS	NOx_AQ_AAQMS	NH3_AQ_AAQMS	O3_AQ_AAQMS	WS_AQ_AAQMS	WD_AQ_AAQMS	TC_AQ_AAQMS	RH_AQ_AAQMS	RG_AQ_AAQMS	AQI
34	UNIT	μg/m3	μg/m3	μg/m3	mg/m3	μg/m3	μg/m3	μg/m3	μg/m3	μg/m3	m/s	degre-----	degreC	%	m m
35	DATE
36	19-12-2023	25.89	10.66	3.92	0.62	2.99	4.27	6.85	0.96	29.61	0.51	43.14	32.09	77.9	0	31
37	20-12-2023	25.75	10.52	3.96	0.65	3.03	4.32	6.72	0.96	29.61	0.51	23.86	32.15	80.35	0	33
38	21-12-2023	26.19	10.96	3.95	0.52	3.02	4.27	6.85	0.97	23.58	0.18	58.19	31.58	88.08	0	26
39	22-12-2023	26.37	11.14	3.93	0.75	3	4.29	6.76	0.97	27.57	0.17	102.1	31.74	83.39	0	38
40	23-12-2023	25.37	10.14	3.99	0.79	3.04	4.33	6.84	0.95	30.45	0.44	87.47	31.26	82.05	0	40
41	24-12-2023	25.29	10.06	3.92	0.77	2.99	4.27	6.78	0.95	35.44	0.42	55.54	31.59	76.36	0	39
42	25-12-2023	25.76	10.53	3.92	0.66	2.98	4.3	6.88	0.96	29.36	0.31	6.35	32.16	82.99	0	33
43	26-12-2023	25.99	10.76	3.94	0.75	3	4.29	6.8	0.97	27.31	0.49	29.71	32.49	76.36	0	38
44	27-12-2023	48.87	29.62	8.22	0.77	2.73	3.97	6.56	1.27	32.11	0.48	43.93	33.15	71.76	0	49
45	28-12-2023	47.84	21.49	1.52	0.62	1.98	3.29	5.83	2.05	30.76	0.44	45.53	32.73	74.14	0	48
46	Minimum /result	25.29	10.06	1.52	0.52	1.98	3.29	5.83	0.95	23.58	0.17	6.35	31.26	71.76	0	26
47	Maximum /result	48.87	29.62	8.22	0.79	3.04	4.33	6.88	2.05	35.44	0.51	102.1	33.15	88.08	0	49
48	Average/result	48.87	29.62	8.22	0.79	3.04	4.33	6.88	2.05	35.44	0.51	102.1	33.15	88.08	0	49
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100