A B C D F G H I K L M
1       6-minute Average Opacity vs 3-minute Aggregate in 60 Minutes    
2 3 minute aggregate in 60 minutes   6 minute averages (24 readings)   6 minute averages (24 readings)
3 Reading Opacity >=20? 6-min avg. Reading Opacity >=20? 6-min avg. Reading Opacity >=20?
4 1 0 0   1 0 0   1 10 1
5 2 0 0   2 0 0   2 10 1
6 3 0 0   3 0 0   3 10 1
7 4 20 1   4 0 0   4 10 1
8 5 20 1   5 100 1   5 20 1
9 6 20 1   6 100 1   6 20 1
10 7 20 1   7 100 1   7 20 1
11 8 20 1   8 100 1   8 20 1
12 9 20 1   9 100 1   9 20 1
13 10 0 0   10 0 0   10 20 1
14 11 0 0   11 0 0   11 60 1
15 12 0 0   12 0 0   12 20 1
16 13 0 0   13 0 0   13 20 1
17 14 0 0   14 0 0   14 20 1
18 15 0 0   15 0 0   15 60 1
19 16 0 0   16 0 0   16 20 1
20 17 0 0   17 0 0   17 20 1
21 18 0 0   18 0 0   18 20 1
22 19 0 0   19 0 0   19 20 1
23 20 0 0   20 0 0   20 20 1
24 21 0 0   21 0 0   21 40 1
25 22 0 0   22 0 0   22 20 1
26 23 0 0   23 0 0   23 10 1
27 24 0 0 5.0 24 0 0   24 10 1
28 25 20 1 5.8 Minutes >=20% 1.25   Minutes >=20% 5.4
29 26 20 1 6.7 6-minute average 20.8   6-minute average 21.7
30 27 20 1 7.5 DEQ Violation? no   DEQ Violation? yes
31 28 20 1 7.5 EPA violation? yes   EPA violation? yes
32 29 20 1 7.5              
33 30 20 1 7.5              
34 Minutes >=20% 3                
35 6-min avg >20% 0                
36 DEQ Violation? yes                
37 EPA violation? no                

Sheet1