Using Index/Match to Find Values in Autofiltered Range Only

[powerjak]

I need some help with a problem I'm stuck on. I'd really appreciate anyone's help to resolve this quickly.

I have a table consisting of 5-minute interval data for one (1) Month from an electric utility meter. I've set up an Autofilter to allow selecting just the samples associated with a single day from the entire data range. From the Autofiltered one day range (288 samples), I want to use MIN, MAX and Index/Match formulas to determine the values and Date/Time when the Max and Min values occurred. How do I set up the formulas to only return the MIN & MAX Values (and the Date/Time they occurred) within the single day Autofiltered range, rather than from the entire 30-day data range?

Col B = Col A (formatted to only display Date [to allow Autofilter on Date only])

E1 = "Sum kWh"
E2 = kWh =SUBTOTAL(9,$C$5:$C$7492)/12 [This is the sum of Col C, Autofiltered for single date in Col B]
F1 = "kW Min"
F2 = MIN =SUBTOTAL(5,$C$5:$C$7492) [Min of Col C, Autofiltered by Col B]
F3 = Date/Time of MIN =(INDEX($A$5:$C$7492,MATCH(F2,$C$5:$C$7492,0),1)) -- BUT I want the Min Value of the first occurrance only within the 1 day Autofiltered range
G1 = "kW Max"
G2 = MAX =SUBTOTAL(4,$C$5:$C$7492) [Max of Col C, Autofiltered by Col B]
G3 = Date/Time of MAX =(INDEX($A$5:$C$7492,MATCH(G2,$C$5:$C$7492,0),1)) -- BUT I want the Max Value of the first occurrance only within the 1 day Autofiltered range

Data Table Starts on Row 4 (with Titles listed below; Col A, B & C only for table location, not part of titles)
Col A= Date/Time [m/d/yyyy hh:mm]
Col B=Day [m/d/yyyy]
Col C = Readings (kW) [###.###]
Date/Time Day Readings (KW) (These on Row 4)
8/6/2009 0:05 8/6/2009 95.904
8/6/2009 0:10 8/6/2009 95.904
8/6/2009 0:15 8/6/2009 98.496
8/6/2009 0:20 8/6/2009 95.904
8/6/2009 0:25 8/6/2009 98.496
8/6/2009 0:30 8/6/2009 95.904
8/6/2009 0:35 8/6/2009 93.312
8/6/2009 0:40 8/6/2009 95.904
8/6/2009 0:45 8/6/2009 98.496
8/6/2009 0:50 8/6/2009 101.088
8/6/2009 0:55 8/6/2009 95.904
8/6/2009 1:00 8/6/2009 98.496
8/6/2009 1:05 8/6/2009 95.904
8/6/2009 1:10 8/6/2009 95.904
8/6/2009 1:15 8/6/2009 95.904
8/6/2009 1:20 8/6/2009 95.904
8/6/2009 1:25 8/6/2009 95.904
8/6/2009 1:30 8/6/2009 95.904
8/6/2009 1:35 8/6/2009 95.904
8/6/2009 1:40 8/6/2009 95.904
8/6/2009 1:45 8/6/2009 95.904
8/6/2009 1:50 8/6/2009 98.496
8/6/2009 1:55 8/6/2009 101.088
8/6/2009 2:00 8/6/2009 98.496
8/6/2009 2:05 8/6/2009 101.088
8/6/2009 2:10 8/6/2009 98.496
8/6/2009 2:15 8/6/2009 98.496
8/6/2009 2:20 8/6/2009 101.088
8/6/2009 2:25 8/6/2009 98.496
8/6/2009 2:30 8/6/2009 98.496
8/6/2009 2:35 8/6/2009 101.088
8/6/2009 2:40 8/6/2009 95.904
8/6/2009 2:45 8/6/2009 95.904
8/6/2009 2:50 8/6/2009 95.904
8/6/2009 2:55 8/6/2009 95.904
8/6/2009 3:00 8/6/2009 95.904
8/6/2009 3:05 8/6/2009 95.904
8/6/2009 3:10 8/6/2009 95.904
8/6/2009 3:15 8/6/2009 95.904
8/6/2009 3:20 8/6/2009 95.904
8/6/2009 3:25 8/6/2009 95.904
8/6/2009 3:30 8/6/2009 93.312
8/6/2009 3:35 8/6/2009 95.904
8/6/2009 3:40 8/6/2009 95.904
8/6/2009 3:45 8/6/2009 95.904
8/6/2009 3:50 8/6/2009 95.904
8/6/2009 3:55 8/6/2009 93.312
8/6/2009 4:00 8/6/2009 95.904
8/6/2009 4:05 8/6/2009 95.904
8/6/2009 4:10 8/6/2009 98.496
8/6/2009 4:15 8/6/2009 106.272
8/6/2009 4:20 8/6/2009 121.824
8/6/2009 4:25 8/6/2009 108.864
8/6/2009 4:30 8/6/2009 108.864
8/6/2009 4:35 8/6/2009 108.864
8/6/2009 4:40 8/6/2009 108.864
8/6/2009 4:45 8/6/2009 106.272
8/6/2009 4:50 8/6/2009 111.456
8/6/2009 4:55 8/6/2009 108.864
8/6/2009 5:00 8/6/2009 111.456
8/6/2009 5:05 8/6/2009 106.272
8/6/2009 5:10 8/6/2009 108.864
8/6/2009 5:15 8/6/2009 108.864
8/6/2009 5:20 8/6/2009 108.864
8/6/2009 5:25 8/6/2009 108.864
8/6/2009 5:30 8/6/2009 111.456
8/6/2009 5:35 8/6/2009 111.456
8/6/2009 5:40 8/6/2009 114.048
8/6/2009 5:45 8/6/2009 108.864
8/6/2009 5:50 8/6/2009 108.864
8/6/2009 5:55 8/6/2009 111.456
8/6/2009 6:00 8/6/2009 106.272
8/6/2009 6:05 8/6/2009 108.864
8/6/2009 6:10 8/6/2009 111.456
8/6/2009 6:15 8/6/2009 108.864
8/6/2009 6:20 8/6/2009 111.456
8/6/2009 6:25 8/6/2009 114.048
8/6/2009 6:30 8/6/2009 114.048
8/6/2009 6:35 8/6/2009 121.824
8/6/2009 6:40 8/6/2009 124.416
8/6/2009 6:45 8/6/2009 121.824
8/6/2009 6:50 8/6/2009 139.968
8/6/2009 6:55 8/6/2009 145.152
8/6/2009 7:00 8/6/2009 147.744
8/6/2009 7:05 8/6/2009 150.336
8/6/2009 7:10 8/6/2009 171.072
8/6/2009 7:15 8/6/2009 191.808
8/6/2009 7:20 8/6/2009 196.992
8/6/2009 7:25 8/6/2009 199.584
8/6/2009 7:30 8/6/2009 194.4
8/6/2009 7:35 8/6/2009 199.584
8/6/2009 7:40 8/6/2009 204.768
8/6/2009 7:45 8/6/2009 235.872
8/6/2009 7:50 8/6/2009 230.688
8/6/2009 7:55 8/6/2009 181.44
8/6/2009 8:00 8/6/2009 160.704
8/6/2009 8:05 8/6/2009 163.296
8/6/2009 8:10 8/6/2009 178.848
8/6/2009 8:15 8/6/2009 186.624
8/6/2009 8:20 8/6/2009 230.688
8/6/2009 8:25 8/6/2009 246.24
8/6/2009 8:30 8/6/2009 233.28
8/6/2009 8:35 8/6/2009 202.176
8/6/2009 8:40 8/6/2009 212.544
8/6/2009 8:45 8/6/2009 209.952
8/6/2009 8:50 8/6/2009 215.136
8/6/2009 8:55 8/6/2009 222.912
8/6/2009 9:00 8/6/2009 222.912
8/6/2009 9:05 8/6/2009 238.464
8/6/2009 9:10 8/6/2009 251.424
8/6/2009 9:15 8/6/2009 256.608
8/6/2009 9:20 8/6/2009 181.44
8/6/2009 9:25 8/6/2009 194.4
8/6/2009 9:30 8/6/2009 207.36
8/6/2009 9:35 8/6/2009 241.056
8/6/2009 9:40 8/6/2009 254.016
8/6/2009 9:45 8/6/2009 222.912
8/6/2009 9:50 8/6/2009 204.768
8/6/2009 9:55 8/6/2009 212.544
8/6/2009 10:00 8/6/2009 217.728
8/6/2009 10:05 8/6/2009 261.792
8/6/2009 10:10 8/6/2009 277.344
8/6/2009 10:15 8/6/2009 233.28
8/6/2009 10:20 8/6/2009 215.136
8/6/2009 10:25 8/6/2009 222.912
8/6/2009 10:30 8/6/2009 238.464
8/6/2009 10:35 8/6/2009 272.16
8/6/2009 10:40 8/6/2009 295.488
8/6/2009 10:45 8/6/2009 290.304
8/6/2009 10:50 8/6/2009 235.872
8/6/2009 10:55 8/6/2009 233.28
8/6/2009 11:00 8/6/2009 235.872
8/6/2009 11:05 8/6/2009 264.384
8/6/2009 11:10 8/6/2009 298.08
8/6/2009 11:15 8/6/2009 318.816
8/6/2009 11:20 8/6/2009 225.504
8/6/2009 11:25 8/6/2009 233.28
8/6/2009 11:30 8/6/2009 230.688
8/6/2009 11:35 8/6/2009 261.792
8/6/2009 11:40 8/6/2009 290.304
8/6/2009 11:45 8/6/2009 321.408
8/6/2009 11:50 8/6/2009 331.776
8/6/2009 11:55 8/6/2009 235.872
8/6/2009 12:00 8/6/2009 225.504
8/6/2009 12:05 8/6/2009 264.384
8/6/2009 12:10 8/6/2009 300.672
8/6/2009 12:15 8/6/2009 331.776
8/6/2009 12:20 8/6/2009 360.288
8/6/2009 12:25 8/6/2009 344.736
8/6/2009 12:30 8/6/2009 279.936
8/6/2009 12:35 8/6/2009 241.056
8/6/2009 12:40 8/6/2009 261.792
8/6/2009 12:45 8/6/2009 292.896
8/6/2009 12:50 8/6/2009 334.368
8/6/2009 12:55 8/6/2009 378.432
8/6/2009 13:00 8/6/2009 399.168
8/6/2009 13:05 8/6/2009 368.064
8/6/2009 13:10 8/6/2009 375.84
8/6/2009 13:15 8/6/2009 393.984
8/6/2009 13:20 8/6/2009 383.616
8/6/2009 13:25 8/6/2009 393.984
8/6/2009 13:30 8/6/2009 383.616
8/6/2009 13:35 8/6/2009 391.392
8/6/2009 13:40 8/6/2009 386.208
8/6/2009 13:45 8/6/2009 391.392
8/6/2009 13:50 8/6/2009 383.616
8/6/2009 13:55 8/6/2009 393.984
8/6/2009 14:00 8/6/2009 378.432
8/6/2009 14:05 8/6/2009 373.248
8/6/2009 14:10 8/6/2009 357.696
8/6/2009 14:15 8/6/2009 339.552
8/6/2009 14:20 8/6/2009 342.144
8/6/2009 14:25 8/6/2009 313.632
8/6/2009 14:30 8/6/2009 321.408
8/6/2009 14:35 8/6/2009 326.592
8/6/2009 14:40 8/6/2009 360.288
8/6/2009 14:45 8/6/2009 360.288
8/6/2009 14:50 8/6/2009 321.408
8/6/2009 14:55 8/6/2009 316.224
8/6/2009 15:00 8/6/2009 316.224
8/6/2009 15:05 8/6/2009 303.264
8/6/2009 15:10 8/6/2009 311.04
8/6/2009 15:15 8/6/2009 326.592
8/6/2009 15:20 8/6/2009 321.408
8/6/2009 15:25 8/6/2009 298.08
8/6/2009 15:30 8/6/2009 295.488
8/6/2009 15:35 8/6/2009 264.384
8/6/2009 15:40 8/6/2009 274.752
8/6/2009 15:45 8/6/2009 313.632
8/6/2009 15:50 8/6/2009 313.632
8/6/2009 15:55 8/6/2009 313.632
8/6/2009 16:00 8/6/2009 246.24
8/6/2009 16:05 8/6/2009 241.056
8/6/2009 16:10 8/6/2009 243.648
8/6/2009 16:15 8/6/2009 279.936
8/6/2009 16:20 8/6/2009 308.448
8/6/2009 16:25 8/6/2009 344.736
8/6/2009 16:30 8/6/2009 357.696
8/6/2009 16:35 8/6/2009 246.24
8/6/2009 16:40 8/6/2009 233.28
8/6/2009 16:45 8/6/2009 254.016
8/6/2009 16:50 8/6/2009 282.528
8/6/2009 16:55 8/6/2009 321.408
8/6/2009 17:00 8/6/2009 349.92
8/6/2009 17:05 8/6/2009 321.408
8/6/2009 17:10 8/6/2009 235.872
8/6/2009 17:15 8/6/2009 235.872
8/6/2009 17:20 8/6/2009 261.792
8/6/2009 17:25 8/6/2009 287.712
8/6/2009 17:30 8/6/2009 326.592
8/6/2009 17:35 8/6/2009 352.512
8/6/2009 17:40 8/6/2009 331.776
8/6/2009 17:45 8/6/2009 233.28
8/6/2009 17:50 8/6/2009 233.28
8/6/2009 17:55 8/6/2009 259.2
8/6/2009 18:00 8/6/2009 287.712
8/6/2009 18:05 8/6/2009 300.672
8/6/2009 18:10 8/6/2009 272.16
8/6/2009 18:15 8/6/2009 212.544
8/6/2009 18:20 8/6/2009 209.952
8/6/2009 18:25 8/6/2009 215.136
8/6/2009 18:30 8/6/2009 254.016
8/6/2009 18:35 8/6/2009 261.792
8/6/2009 18:40 8/6/2009 266.976
8/6/2009 18:45 8/6/2009 254.016
8/6/2009 18:50 8/6/2009 191.808
8/6/2009 18:55 8/6/2009 207.36
8/6/2009 19:00 8/6/2009 209.952
8/6/2009 19:05 8/6/2009 158.112
8/6/2009 19:10 8/6/2009 158.112
8/6/2009 19:15 8/6/2009 150.336
8/6/2009 19:20 8/6/2009 158.112
8/6/2009 19:25 8/6/2009 160.704
8/6/2009 19:30 8/6/2009 163.296
8/6/2009 19:35 8/6/2009 155.52
8/6/2009 19:40 8/6/2009 147.744
8/6/2009 19:45 8/6/2009 150.336
8/6/2009 19:50 8/6/2009 150.336
8/6/2009 19:55 8/6/2009 147.744
8/6/2009 20:00 8/6/2009 137.376
8/6/2009 20:05 8/6/2009 139.968
8/6/2009 20:10 8/6/2009 137.376
8/6/2009 20:15 8/6/2009 134.784
8/6/2009 20:20 8/6/2009 137.376
8/6/2009 20:25 8/6/2009 139.968
8/6/2009 20:30 8/6/2009 137.376
8/6/2009 20:35 8/6/2009 139.968
8/6/2009 20:40 8/6/2009 142.56
8/6/2009 20:45 8/6/2009 134.784
8/6/2009 20:50 8/6/2009 134.784
8/6/2009 20:55 8/6/2009 137.376
8/6/2009 21:00 8/6/2009 137.376
8/6/2009 21:05 8/6/2009 139.968
8/6/2009 21:10 8/6/2009 139.968
8/6/2009 21:15 8/6/2009 139.968
8/6/2009 21:20 8/6/2009 134.784
8/6/2009 21:25 8/6/2009 137.376
8/6/2009 21:30 8/6/2009 134.784
8/6/2009 21:35 8/6/2009 134.784
8/6/2009 21:40 8/6/2009 139.968
8/6/2009 21:45 8/6/2009 137.376
8/6/2009 21:50 8/6/2009 139.968
8/6/2009 21:55 8/6/2009 134.784
8/6/2009 22:00 8/6/2009 137.376
8/6/2009 22:05 8/6/2009 137.376
8/6/2009 22:10 8/6/2009 139.968
8/6/2009 22:15 8/6/2009 142.56
8/6/2009 22:20 8/6/2009 145.152
8/6/2009 22:25 8/6/2009 150.336
8/6/2009 22:30 8/6/2009 147.744
8/6/2009 22:35 8/6/2009 152.928
8/6/2009 22:40 8/6/2009 152.928
8/6/2009 22:45 8/6/2009 150.336
8/6/2009 22:50 8/6/2009 147.744
8/6/2009 22:55 8/6/2009 145.152
8/6/2009 23:00 8/6/2009 142.56
8/6/2009 23:05 8/6/2009 111.456
8/6/2009 23:10 8/6/2009 106.272
8/6/2009 23:15 8/6/2009 103.68
8/6/2009 23:20 8/6/2009 106.272
8/6/2009 23:25 8/6/2009 106.272
8/6/2009 23:30 8/6/2009 101.088
8/6/2009 23:35 8/6/2009 106.272
8/6/2009 23:40 8/6/2009 103.68
8/6/2009 23:45 8/6/2009 106.272
8/6/2009 23:50 8/6/2009 101.088
8/6/2009 23:55 8/6/2009 103.68
8/7/2009 0:00 8/7/2009 106.272
8/7/2009 0:05 8/7/2009 106.272
8/7/2009 0:10 8/7/2009 103.68
8/7/2009 0:15 8/7/2009 106.272
8/7/2009 0:20 8/7/2009 106.272
8/7/2009 0:25 8/7/2009 106.272
8/7/2009 0:30 8/7/2009 108.864
8/7/2009 0:35 8/7/2009 111.456
8/7/2009 0:40 8/7/2009 111.456
8/7/2009 0:45 8/7/2009 111.456
8/7/2009 0:50 8/7/2009 114.048
8/7/2009 0:55 8/7/2009 108.864
8/7/2009 1:00 8/7/2009 116.64
8/7/2009 1:05 8/7/2009 119.232
8/7/2009 1:10 8/7/2009 108.864
8/7/2009 1:15 8/7/2009 111.456
8/7/2009 1:20 8/7/2009 106.272
8/7/2009 1:25 8/7/2009 108.864
8/7/2009 1:30 8/7/2009 108.864
8/7/2009 1:35 8/7/2009 101.088
8/7/2009 1:40 8/7/2009 106.272
8/7/2009 1:45 8/7/2009 108.864
8/7/2009 1:50 8/7/2009 103.68
8/7/2009 1:55 8/7/2009 106.272
8/7/2009 2:00 8/7/2009 106.272
8/7/2009 2:05 8/7/2009 106.272
8/7/2009 2:10 8/7/2009 106.272
8/7/2009 2:15 8/7/2009 103.68
8/7/2009 2:20 8/7/2009 106.272
8/7/2009 2:25 8/7/2009 106.272
8/7/2009 2:30 8/7/2009 103.68
8/7/2009 2:35 8/7/2009 106.272
8/7/2009 2:40 8/7/2009 106.272
8/7/2009 2:45 8/7/2009 106.272
8/7/2009 2:50 8/7/2009 108.864
8/7/2009 2:55 8/7/2009 103.68
8/7/2009 3:00 8/7/2009 108.864
8/7/2009 3:05 8/7/2009 103.68
8/7/2009 3:10 8/7/2009 106.272
8/7/2009 3:15 8/7/2009 106.272
8/7/2009 3:20 8/7/2009 103.68
8/7/2009 3:25 8/7/2009 108.864
8/7/2009 3:30 8/7/2009 103.68
8/7/2009 3:35 8/7/2009 106.272
8/7/2009 3:40 8/7/2009 106.272
8/7/2009 3:45 8/7/2009 106.272
8/7/2009 3:50 8/7/2009 103.68
8/7/2009 3:55 8/7/2009 103.68
8/7/2009 4:00 8/7/2009 108.864
8/7/2009 4:05 8/7/2009 103.68
8/7/2009 4:10 8/7/2009 103.68
8/7/2009 4:15 8/7/2009 106.272
8/7/2009 4:20 8/7/2009 103.68
8/7/2009 4:25 8/7/2009 111.456
8/7/2009 4:30 8/7/2009 111.456
8/7/2009 4:35 8/7/2009 119.232
8/7/2009 4:40 8/7/2009 127.008
8/7/2009 4:45 8/7/2009 127.008
8/7/2009 4:50 8/7/2009 121.824
8/7/2009 4:55 8/7/2009 119.232
8/7/2009 5:00 8/7/2009 116.64
8/7/2009 5:05 8/7/2009 119.232
8/7/2009 5:10 8/7/2009 116.64
8/7/2009 5:15 8/7/2009 116.64
8/7/2009 5:20 8/7/2009 111.456
8/7/2009 5:25 8/7/2009 116.64
8/7/2009 5:30 8/7/2009 111.456
8/7/2009 5:35 8/7/2009 111.456
8/7/2009 5:40 8/7/2009 114.048
8/7/2009 5:45 8/7/2009 114.048
8/7/2009 5:50 8/7/2009 119.232
8/7/2009 5:55 8/7/2009 111.456
8/7/2009 6:00 8/7/2009 111.456
8/7/2009 6:05 8/7/2009 111.456
8/7/2009 6:10 8/7/2009 111.456
8/7/2009 6:15 8/7/2009 116.64
8/7/2009 6:20 8/7/2009 114.048
8/7/2009 6:25 8/7/2009 119.232
8/7/2009 6:30 8/7/2009 116.64
8/7/2009 6:35 8/7/2009 119.232
8/7/2009 6:40 8/7/2009 132.192
8/7/2009 6:45 8/7/2009 129.6
8/7/2009 6:50 8/7/2009 147.744
8/7/2009 6:55 8/7/2009 155.52
8/7/2009 7:00 8/7/2009 155.52
8/7/2009 7:05 8/7/2009 152.928
8/7/2009 7:10 8/7/2009 176.256
8/7/2009 7:15 8/7/2009 199.584
8/7/2009 7:20 8/7/2009 209.952
8/7/2009 7:25 8/7/2009 220.32
8/7/2009 7:30 8/7/2009 217.728
8/7/2009 7:35 8/7/2009 222.912
8/7/2009 7:40 8/7/2009 264.384
8/7/2009 7:45 8/7/2009 246.24
8/7/2009 7:50 8/7/2009 217.728
8/7/2009 7:55 8/7/2009 204.768
8/7/2009 8:00 8/7/2009 230.688
8/7/2009 8:05 8/7/2009 254.016
8/7/2009 8:10 8/7/2009 254.016
8/7/2009 8:15 8/7/2009 254.016
8/7/2009 8:20 8/7/2009 269.568
8/7/2009 8:25 8/7/2009 298.08
8/7/2009 8:30 8/7/2009 295.488
8/7/2009 8:35 8/7/2009 233.28
8/7/2009 8:40 8/7/2009 220.32
8/7/2009 8:45 8/7/2009 220.32
8/7/2009 8:50 8/7/2009 217.728
8/7/2009 8:55 8/7/2009 233.28
8/7/2009 9:00 8/7/2009 261.792
8/7/2009 9:05 8/7/2009 290.304
8/7/2009 9:10 8/7/2009 349.92
8/7/2009 9:15 8/7/2009 396.576
8/7/2009 9:20 8/7/2009 347.328
8/7/2009 9:25 8/7/2009 272.16
8/7/2009 9:30 8/7/2009 282.528
8/7/2009 9:35 8/7/2009 331.776
8/7/2009 9:40 8/7/2009 360.288
8/7/2009 9:45 8/7/2009 373.248
8/7/2009 9:50 8/7/2009 282.528
8/7/2009 9:55 8/7/2009 287.712
8/7/2009 10:00 8/7/2009 290.304
8/7/2009 10:05 8/7/2009 329.184
8/7/2009 10:10 8/7/2009 347.328
8/7/2009 10:15 8/7/2009 388.8
8/7/2009 10:20 8/7/2009 362.88
8/7/2009 10:25 8/7/2009 254.016
8/7/2009 10:30 8/7/2009 241.056
8/7/2009 10:35 8/7/2009 272.16
8/7/2009 10:40 8/7/2009 313.632
8/7/2009 10:45 8/7/2009 349.92
8/7/2009 10:50 8/7/2009 381.024
8/7/2009 10:55 8/7/2009 259.2
8/7/2009 11:00 8/7/2009 256.608
8/7/2009 11:05 8/7/2009 264.384
8/7/2009 11:10 8/7/2009 300.672
8/7/2009 11:15 8/7/2009 334.368
8/7/2009 11:20 8/7/2009 368.064
8/7/2009 11:25 8/7/2009 334.368
8/7/2009 11:30 8/7/2009 235.872
8/7/2009 11:35 8/7/2009 235.872
8/7/2009 11:40 8/7/2009 266.976
8/7/2009 11:45 8/7/2009 295.488
8/7/2009 11:50 8/7/2009 339.552
8/7/2009 11:55 8/7/2009 352.512
8/7/2009 12:00 8/7/2009 243.648
8/7/2009 12:05 8/7/2009 246.24
8/7/2009 12:10 8/7/2009 266.976
8/7/2009 12:15 8/7/2009 295.488
8/7/2009 12:20 8/7/2009 339.552
8/7/2009 12:25 8/7/2009 381.024
8/7/2009 12:30 8/7/2009 381.024
8/7/2009 12:35 8/7/2009 355.104
8/7/2009 12:40 8/7/2009 339.552
8/7/2009 12:45 8/7/2009 305.856
8/7/2009 12:50 8/7/2009 316.224
8/7/2009 12:55 8/7/2009 326.592
8/7/2009 13:00 8/7/2009 313.632
8/7/2009 13:05 8/7/2009 331.776
8/7/2009 13:10 8/7/2009 316.224
8/7/2009 13:15 8/7/2009 300.672
8/7/2009 13:20 8/7/2009 308.448
8/7/2009 13:25 8/7/2009 303.264
8/7/2009 13:30 8/7/2009 318.816
8/7/2009 13:35 8/7/2009 290.304
8/7/2009 13:40 8/7/2009 305.856
8/7/2009 13:45 8/7/2009 282.528
8/7/2009 13:50 8/7/2009 274.752
8/7/2009 13:55 8/7/2009 313.632
8/7/2009 14:00 8/7/2009 321.408
8/7/2009 14:05 8/7/2009 311.04
8/7/2009 14:10 8/7/2009 243.648
8/7/2009 14:15 8/7/2009 272.16
8/7/2009 14:20 8/7/2009 298.08
8/7/2009 14:25 8/7/2009 342.144
8/7/2009 14:30 8/7/2009 303.264
8/7/2009 14:35 8/7/2009 233.28
8/7/2009 14:40 8/7/2009 233.28
8/7/2009 14:45 8/7/2009 279.936
8/7/2009 14:50 8/7/2009 300.672
8/7/2009 14:55 8/7/2009 344.736
8/7/2009 15:00 8/7/2009 355.104
8/7/2009 15:05 8/7/2009 248.832
8/7/2009 15:10 8/7/2009 235.872
8/7/2009 15:15 8/7/2009 246.24
8/7/2009 15:20 8/7/2009 282.528
8/7/2009 15:25 8/7/2009 313.632
8/7/2009 15:30 8/7/2009 349.92
8/7/2009 15:35 8/7/2009 266.976
8/7/2009 15:40 8/7/2009 233.28
8/7/2009 15:45 8/7/2009 238.464
8/7/2009 15:50 8/7/2009 282.528
8/7/2009 15:55 8/7/2009 308.448
8/7/2009 16:00 8/7/2009 344.736
8/7/2009 16:05 8/7/2009 329.184
8/7/2009 16:10 8/7/2009 225.504
8/7/2009 16:15 8/7/2009 230.688
8/7/2009 16:20 8/7/2009 251.424
8/7/2009 16:25 8/7/2009 282.528
8/7/2009 16:30 8/7/2009 321.408
8/7/2009 16:35 8/7/2009 347.328
8/7/2009 16:40 8/7/2009 241.056
8/7/2009 16:45 8/7/2009 230.688
8/7/2009 16:50 8/7/2009 243.648
8/7/2009 16:55 8/7/2009 279.936
8/7/2009 17:00 8/7/2009 311.04
8/7/2009 17:05 8/7/2009 344.736
8/7/2009 17:10 8/7/2009 235.872
8/7/2009 17:15 8/7/2009 222.912
8/7/2009 17:20 8/7/2009 228.096
8/7/2009 17:25 8/7/2009 266.976
8/7/2009 17:30 8/7/2009 292.896
8/7/2009 17:35 8/7/2009 329.184
8/7/2009 17:40 8/7/2009 233.28
8/7/2009 17:45 8/7/2009 217.728
8/7/2009 17:50 8/7/2009 233.28
8/7/2009 17:55 8/7/2009 277.344
8/7/2009 18:00 8/7/2009 298.08
8/7/2009 18:05 8/7/2009 285.12
8/7/2009 18:10 8/7/2009 207.36
8/7/2009 18:15 8/7/2009 212.544
8/7/2009 18:20 8/7/2009 207.36
8/7/2009 18:25 8/7/2009 209.952
8/7/2009 18:30 8/7/2009 256.608
8/7/2009 18:35 8/7/2009 235.872
8/7/2009 18:40 8/7/2009 248.832
8/7/2009 18:45 8/7/2009 228.096
8/7/2009 18:50 8/7/2009 199.584
8/7/2009 18:55 8/7/2009 209.952
8/7/2009 19:00 8/7/2009 204.768
8/7/2009 19:05 8/7/2009 163.296
8/7/2009 19:10 8/7/2009 163.296
8/7/2009 19:15 8/7/2009 158.112
8/7/2009 19:20 8/7/2009 158.112
8/7/2009 19:25 8/7/2009 158.112
8/7/2009 19:30 8/7/2009 152.928
8/7/2009 19:35 8/7/2009 152.928
8/7/2009 19:40 8/7/2009 152.928
8/7/2009 19:45 8/7/2009 155.52
8/7/2009 19:50 8/7/2009 155.52
8/7/2009 19:55 8/7/2009 152.928
8/7/2009 20:00 8/7/2009 152.928
8/7/2009 20:05 8/7/2009 155.52
8/7/2009 20:10 8/7/2009 158.112
8/7/2009 20:15 8/7/2009 158.112
8/7/2009 20:20 8/7/2009 152.928
8/7/2009 20:25 8/7/2009 155.52
8/7/2009 20:30 8/7/2009 152.928
8/7/2009 20:35 8/7/2009 150.336
8/7/2009 20:40 8/7/2009 152.928
8/7/2009 20:45 8/7/2009 150.336
8/7/2009 20:50 8/7/2009 150.336
8/7/2009 20:55 8/7/2009 152.928
8/7/2009 21:00 8/7/2009 150.336
8/7/2009 21:05 8/7/2009 150.336
8/7/2009 21:10 8/7/2009 147.744
8/7/2009 21:15 8/7/2009 147.744
8/7/2009 21:20 8/7/2009 147.744
8/7/2009 21:25 8/7/2009 150.336
8/7/2009 21:30 8/7/2009 150.336
8/7/2009 21:35 8/7/2009 147.744
8/7/2009 21:40 8/7/2009 152.928
8/7/2009 21:45 8/7/2009 139.968
8/7/2009 21:50 8/7/2009 139.968
8/7/2009 21:55 8/7/2009 139.968
8/7/2009 22:00 8/7/2009 142.56
8/7/2009 22:05 8/7/2009 137.376
8/7/2009 22:10 8/7/2009 139.968
8/7/2009 22:15 8/7/2009 139.968
8/7/2009 22:20 8/7/2009 142.56
8/7/2009 22:25 8/7/2009 139.968
8/7/2009 22:30 8/7/2009 145.152
8/7/2009 22:35 8/7/2009 152.928
8/7/2009 22:40 8/7/2009 150.336
8/7/2009 22:45 8/7/2009 152.928
8/7/2009 22:50 8/7/2009 142.56
8/7/2009 22:55 8/7/2009 142.56
8/7/2009 23:00 8/7/2009 139.968
8/7/2009 23:05 8/7/2009 116.64
8/7/2009 23:10 8/7/2009 108.864
8/7/2009 23:15 8/7/2009 106.272
8/7/2009 23:20 8/7/2009 98.496
8/7/2009 23:25 8/7/2009 101.088
8/7/2009 23:30 8/7/2009 103.68
8/7/2009 23:35 8/7/2009 98.496
8/7/2009 23:40 8/7/2009 98.496
8/7/2009 23:45 8/7/2009 95.904
8/7/2009 23:50 8/7/2009 98.496
8/7/2009 23:55 8/7/2009 101.088
8/8/2009 0:00 8/8/2009 98.496
8/8/2009 0:05 8/8/2009 98.496
8/8/2009 0:10 8/8/2009 95.904
8/8/2009 0:15 8/8/2009 95.904
8/8/2009 0:20 8/8/2009 98.496
8/8/2009 0:25 8/8/2009 103.68
8/8/2009 0:30 8/8/2009 95.904
8/8/2009 0:35 8/8/2009 95.904
8/8/2009 0:40 8/8/2009 95.904
8/8/2009 0:45 8/8/2009 95.904
8/8/2009 0:50 8/8/2009 101.088
8/8/2009 0:55 8/8/2009 98.496
8/8/2009 1:00 8/8/2009 98.496
8/8/2009 1:05 8/8/2009 95.904
8/8/2009 1:10 8/8/2009 95.904
8/8/2009 1:15 8/8/2009 98.496
8/8/2009 1:20 8/8/2009 98.496
8/8/2009 1:25 8/8/2009 98.496
8/8/2009 1:30 8/8/2009 95.904
8/8/2009 1:35 8/8/2009 95.904
8/8/2009 1:40 8/8/2009 101.088
8/8/2009 1:45 8/8/2009 103.68
8/8/2009 1:50 8/8/2009 103.68
8/8/2009 1:55 8/8/2009 101.088
8/8/2009 2:00 8/8/2009 101.088
8/8/2009 2:05 8/8/2009 103.68
8/8/2009 2:10 8/8/2009 103.68
8/8/2009 2:15 8/8/2009 106.272
8/8/2009 2:20 8/8/2009 101.088
8/8/2009 2:25 8/8/2009 101.088
8/8/2009 2:30 8/8/2009 101.088
8/8/2009 2:35 8/8/2009 103.68
8/8/2009 2:40 8/8/2009 101.088
8/8/2009 2:45 8/8/2009 98.496
8/8/2009 2:50 8/8/2009 98.496
8/8/2009 2:55 8/8/2009 98.496
8/8/2009 3:00 8/8/2009 103.68
8/8/2009 3:05 8/8/2009 101.088
8/8/2009 3:10 8/8/2009 98.496
8/8/2009 3:15 8/8/2009 98.496
8/8/2009 3:20 8/8/2009 98.496
8/8/2009 3:25 8/8/2009 98.496
8/8/2009 3:30 8/8/2009 98.496
8/8/2009 3:35 8/8/2009 98.496
8/8/2009 3:40 8/8/2009 95.904
8/8/2009 3:45 8/8/2009 98.496
8/8/2009 3:50 8/8/2009 98.496
8/8/2009 3:55 8/8/2009 103.68
8/8/2009 4:00 8/8/2009 95.904
8/8/2009 4:05 8/8/2009 98.496
8/8/2009 4:10 8/8/2009 101.088
8/8/2009 4:15 8/8/2009 95.904
8/8/2009 4:20 8/8/2009 98.496
8/8/2009 4:25 8/8/2009 98.496
8/8/2009 4:30 8/8/2009 95.904
8/8/2009 4:35 8/8/2009 95.904
8/8/2009 4:40 8/8/2009 95.904
8/8/2009 4:45 8/8/2009 101.088
8/8/2009 4:50 8/8/2009 98.496
8/8/2009 4:55 8/8/2009 95.904
8/8/2009 5:00 8/8/2009 98.496
8/8/2009 5:05 8/8/2009 98.496
8/8/2009 5:10 8/8/2009 103.68
8/8/2009 5:15 8/8/2009 101.088
8/8/2009 5:20 8/8/2009 101.088
8/8/2009 5:25 8/8/2009 101.088
8/8/2009 5:30 8/8/2009 106.272
8/8/2009 5:35 8/8/2009 119.232
8/8/2009 5:40 8/8/2009 129.6
8/8/2009 5:45 8/8/2009 114.048
8/8/2009 5:50 8/8/2009 114.048
8/8/2009 5:55 8/8/2009 116.64
8/8/2009 6:00 8/8/2009 121.824
8/8/2009 6:05 8/8/2009 119.232
8/8/2009 6:10 8/8/2009 111.456
8/8/2009 6:15 8/8/2009 119.232
8/8/2009 6:20 8/8/2009 114.048
8/8/2009 6:25 8/8/2009 134.784
8/8/2009 6:30 8/8/2009 137.376
8/8/2009 6:35 8/8/2009 145.152
8/8/2009 6:40 8/8/2009 139.968
8/8/2009 6:45 8/8/2009 142.56
8/8/2009 6:50 8/8/2009 139.968
8/8/2009 6:55 8/8/2009 137.376
8/8/2009 7:00 8/8/2009 145.152
8/8/2009 7:05 8/8/2009 142.56
8/8/2009 7:10 8/8/2009 142.56
8/8/2009 7:15 8/8/2009 147.744
8/8/2009 7:20 8/8/2009 184.032
8/8/2009 7:25 8/8/2009 199.584
8/8/2009 7:30 8/8/2009 202.176
8/8/2009 7:35 8/8/2009 202.176
8/8/2009 7:40 8/8/2009 199.584
8/8/2009 7:45 8/8/2009 199.584
8/8/2009 7:50 8/8/2009 202.176
8/8/2009 7:55 8/8/2009 199.584
8/8/2009 8:00 8/8/2009 207.36
8/8/2009 8:05 8/8/2009 207.36
8/8/2009 8:10 8/8/2009 204.768
8/8/2009 8:15 8/8/2009 215.136
8/8/2009 8:20 8/8/2009 215.136
8/8/2009 8:25 8/8/2009 215.136
8/8/2009 8:30 8/8/2009 225.504
8/8/2009 8:35 8/8/2009 251.424
8/8/2009 8:40 8/8/2009 238.464
8/8/2009 8:45 8/8/2009 207.36
8/8/2009 8:50 8/8/2009 189.216
8/8/2009 8:55 8/8/2009 202.176
8/8/2009 9:00 8/8/2009 202.176
8/8/2009 9:05 8/8/2009 207.36
8/8/2009 9:10 8/8/2009 215.136
8/8/2009 9:15 8/8/2009 225.504
8/8/2009 9:20 8/8/2009 266.976
8/8/2009 9:25 8/8/2009 282.528
8/8/2009 9:30 8/8/2009 279.936
8/8/2009 9:35 8/8/2009 196.992
8/8/2009 9:40 8/8/2009 194.4
8/8/2009 9:45 8/8/2009 225.504
8/8/2009 9:50 8/8/2009 290.304
8/8/2009 9:55 8/8/2009 336.96
8/8/2009 10:00 8/8/2009 282.528
8/8/2009 10:05 8/8/2009 191.808
8/8/2009 10:10 8/8/2009 217.728
8/8/2009 10:15 8/8/2009 191.808
8/8/2009 10:20 8/8/2009 191.808
8/8/2009 10:25 8/8/2009 186.624
8/8/2009 10:30 8/8/2009 194.4
8/8/2009 10:35 8/8/2009 220.32
8/8/2009 10:40 8/8/2009 277.344
8/8/2009 10:45 8/8/2009 326.592
8/8/2009 10:50 8/8/2009 256.608
8/8/2009 10:55 8/8/2009 222.912
8/8/2009 11:00 8/8/2009 228.096
8/8/2009 11:05 8/8/2009 248.832
8/8/2009 11:10 8/8/2009 282.528
8/8/2009 11:15 8/8/2009 311.04
8/8/2009 11:20 8/8/2009 295.488
8/8/2009 11:25 8/8/2009 230.688
8/8/2009 11:30 8/8/2009 230.688
8/8/2009 11:35 8/8/2009 241.056
8/8/2009 11:40 8/8/2009 285.12
8/8/2009 11:45 8/8/2009 308.448
8/8/2009 11:50 8/8/2009 326.592
8/8/2009 11:55 8/8/2009 228.096
8/8/2009 12:00 8/8/2009 235.872
8/8/2009 12:05 8/8/2009 251.424
8/8/2009 12:10 8/8/2009 300.672
8/8/2009 12:15 8/8/2009 324
8/8/2009 12:20 8/8/2009 370.656
8/8/2009 12:25 8/8/2009 378.432
8/8/2009 12:30 8/8/2009 360.288
8/8/2009 12:35 8/8/2009 300.672
8/8/2009 12:40 8/8/2009 285.12
8/8/2009 12:45 8/8/2009 311.04
8/8/2009 12:50 8/8/2009 324
8/8/2009 12:55 8/8/2009 352.512
8/8/2009 13:00 8/8/2009 324
8/8/2009 13:05 8/8/2009 295.488
8/8/2009 13:10 8/8/2009 215.136
8/8/2009 13:15 8/8/2009 254.016
8/8/2009 13:20 8/8/2009 318.816
8/8/2009 13:25 8/8/2009 373.248
8/8/2009 13:30 8/8/2009 370.656
8/8/2009 13:35 8/8/2009 334.368
8/8/2009 13:40 8/8/2009 243.648
8/8/2009 13:45 8/8/2009 248.832
8/8/2009 13:50 8/8/2009 287.712
8/8/2009 13:55 8/8/2009 313.632
8/8/2009 14:00 8/8/2009 360.288
8/8/2009 14:05 8/8/2009 370.656
8/8/2009 14:10 8/8/2009 311.04
8/8/2009 14:15 8/8/2009 246.24
8/8/2009 14:20 8/8/2009 248.832
8/8/2009 14:25 8/8/2009 295.488
8/8/2009 14:30 8/8/2009 324
8/8/2009 14:35 8/8/2009 362.88
8/8/2009 14:40 8/8/2009 334.368
8/8/2009 14:45 8/8/2009 251.424
8/8/2009 14:50 8/8/2009 259.2
8/8/2009 14:55 8/8/2009 290.304
8/8/2009 15:00 8/8/2009 305.856
8/8/2009 15:05 8/8/2009 331.776
8/8/2009 15:10 8/8/2009 329.184
8/8/2009 15:15 8/8/2009 217.728
8/8/2009 15:20 8/8/2009 220.32
8/8/2009 15:25 8/8/2009 238.464
8/8/2009 15:30 8/8/2009 272.16
8/8/2009 15:35 8/8/2009 311.04
8/8/2009 15:40 8/8/2009 347.328
8/8/2009 15:45 8/8/2009 251.424
8/8/2009 15:50 8/8/2009 217.728
8/8/2009 15:55 8/8/2009 222.912
8/8/2009 16:00 8/8/2009 259.2
8/8/2009 16:05 8/8/2009 292.896
8/8/2009 16:10 8/8/2009 336.96
8/8/2009 16:15 8/8/2009 233.28
8/8/2009 16:20 8/8/2009 222.912
8/8/2009 16:25 8/8/2009 225.504
8/8/2009 16:30 8/8/2009 269.568
8/8/2009 16:35 8/8/2009 292.896
8/8/2009 16:40 8/8/2009 329.184
8/8/2009 16:45 8/8/2009 230.688
8/8/2009 16:50 8/8/2009 222.912
8/8/2009 16:55 8/8/2009 222.912
8/8/2009 17:00 8/8/2009 261.792
8/8/2009 17:05 8/8/2009 282.528
8/8/2009 17:10 8/8/2009 308.448
8/8/2009 17:15 8/8/2009 235.872
8/8/2009 17:20 8/8/2009 220.32
8/8/2009 17:25 8/8/2009 220.32
8/8/2009 17:30 8/8/2009 261.792
8/8/2009 17:35 8/8/2009 279.936
8/8/2009 17:40 8/8/2009 303.264
8/8/2009 17:45 8/8/2009 230.688
8/8/2009 17:50 8/8/2009 217.728
8/8/2009 17:55 8/8/2009 215.136
8/8/2009 18:00 8/8/2009 233.28
8/8/2009 18:05 8/8/2009 235.872
8/8/2009 18:10 8/8/2009 243.648
8/8/2009 18:15 8/8/2009 254.016
8/8/2009 18:20 8/8/2009 186.624
8/8/2009 18:25 8/8/2009 191.808
8/8/2009 18:30 8/8/2009 191.808
8/8/2009 18:35 8/8/2009 194.4
8/8/2009 18:40 8/8/2009 222.912
8/8/2009 18:45 8/8/2009 235.872
8/8/2009 18:50 8/8/2009 228.096
8/8/2009 18:55 8/8/2009 243.648
8/8/2009 19:00 8/8/2009 194.4
8/8/2009 19:05 8/8/2009 147.744
8/8/2009 19:10 8/8/2009 145.152
8/8/2009 19:15 8/8/2009 147.744
8/8/2009 19:20 8/8/2009 150.336
8/8/2009 19:25 8/8/2009 150.336
8/8/2009 19:30 8/8/2009 145.152
8/8/2009 19:35 8/8/2009 145.152
8/8/2009 19:40 8/8/2009 145.152
8/8/2009 19:45 8/8/2009 142.56
8/8/2009 19:50 8/8/2009 145.152
8/8/2009 19:55 8/8/2009 147.744
8/8/2009 20:00 8/8/2009 145.152
8/8/2009 20:05 8/8/2009 134.784
8/8/2009 20:10 8/8/2009 134.784
8/8/2009 20:15 8/8/2009 132.192
8/8/2009 20:20 8/8/2009 132.192
8/8/2009 20:25 8/8/2009 132.192
8/8/2009 20:30 8/8/2009 134.784
8/8/2009 20:35 8/8/2009 134.784
8/8/2009 20:40 8/8/2009 134.784
8/8/2009 20:45 8/8/2009 132.192
8/8/2009 20:50 8/8/2009 132.192
8/8/2009 20:55 8/8/2009 132.192
8/8/2009 21:00 8/8/2009 129.6
8/8/2009 21:05 8/8/2009 129.6
8/8/2009 21:10 8/8/2009 129.6
8/8/2009 21:15 8/8/2009 129.6
8/8/2009 21:20 8/8/2009 132.192
8/8/2009 21:25 8/8/2009 127.008
8/8/2009 21:30 8/8/2009 129.6
8/8/2009 21:35 8/8/2009 127.008
8/8/2009 21:40 8/8/2009 134.784
8/8/2009 21:45 8/8/2009 129.6
8/8/2009 21:50 8/8/2009 129.6
8/8/2009 21:55 8/8/2009 129.6
8/8/2009 22:00 8/8/2009 132.192
8/8/2009 22:05 8/8/2009 108.864
8/8/2009 22:10 8/8/2009 106.272
8/8/2009 22:15 8/8/2009 114.048
8/8/2009 22:20 8/8/2009 111.456
8/8/2009 22:25 8/8/2009 114.048
8/8/2009 22:30 8/8/2009 114.048
8/8/2009 22:35 8/8/2009 116.64
8/8/2009 22:40 8/8/2009 114.048
8/8/2009 22:45 8/8/2009 111.456
8/8/2009 22:50 8/8/2009 114.048
8/8/2009 22:55 8/8/2009 116.64
8/8/2009 23:00 8/8/2009 114.048
8/8/2009 23:05 8/8/2009 108.864
8/8/2009 23:10 8/8/2009 114.048
8/8/2009 23:15 8/8/2009 114.048
8/8/2009 23:20 8/8/2009 106.272
8/8/2009 23:25 8/8/2009 106.272
8/8/2009 23:30 8/8/2009 106.272
8/8/2009 23:35 8/8/2009 103.68
8/8/2009 23:40 8/8/2009 101.088
8/8/2009 23:45 8/8/2009 103.68
8/8/2009 23:50 8/8/2009 106.272
8/8/2009 23:55 8/8/2009 103.68
8/9/2009 0:00 8/9/2009 106.272
8/9/2009 0:05 8/9/2009 106.272
8/9/2009 0:10 8/9/2009 101.088
8/9/2009 0:15 8/9/2009 103.68
8/9/2009 0:20 8/9/2009 103.68
8/9/2009 0:25 8/9/2009 103.68
8/9/2009 0:30 8/9/2009 101.088
8/9/2009 0:35 8/9/2009 103.68
8/9/2009 0:40 8/9/2009 106.272
8/9/2009 0:45 8/9/2009 103.68
8/9/2009 0:50 8/9/2009 101.088
8/9/2009 0:55 8/9/2009 101.088
8/9/2009 1:00 8/9/2009 106.272
8/9/2009 1:05 8/9/2009 106.272
8/9/2009 1:10 8/9/2009 103.68
8/9/2009 1:15 8/9/2009 106.272
8/9/2009 1:20 8/9/2009 103.68
8/9/2009 1:25 8/9/2009 103.68
8/9/2009 1:30 8/9/2009 101.088
8/9/2009 1:35 8/9/2009 106.272
8/9/2009 1:40 8/9/2009 101.088
8/9/2009 1:45 8/9/2009 103.68
8/9/2009 1:50 8/9/2009 103.68
8/9/2009 1:55 8/9/2009 108.864
8/9/2009 2:00 8/9/2009 106.272
8/9/2009 2:05 8/9/2009 106.272
8/9/2009 2:10 8/9/2009 108.864
8/9/2009 2:15 8/9/2009 111.456
8/9/2009 2:20 8/9/2009 108.864
8/9/2009 2:25 8/9/2009 103.68
8/9/2009 2:30 8/9/2009 101.088
8/9/2009 2:35 8/9/2009 95.904
8/9/2009 2:40 8/9/2009 95.904
8/9/2009 2:45 8/9/2009 114.048
8/9/2009 2:50 8/9/2009 108.864
8/9/2009 2:55 8/9/2009 106.272
8/9/2009 3:00 8/9/2009 98.496
8/9/2009 3:05 8/9/2009 98.496
8/9/2009 3:10 8/9/2009 85.536
8/9/2009 3:15 8/9/2009 108.864
8/9/2009 3:20 8/9/2009 116.64
8/9/2009 3:25 8/9/2009 108.864
8/9/2009 3:30 8/9/2009 114.048
8/9/2009 3:35 8/9/2009 114.048
8/9/2009 3:40 8/9/2009 116.64
8/9/2009 3:45 8/9/2009 124.416
8/9/2009 3:50 8/9/2009 114.048
8/9/2009 3:55 8/9/2009 116.64
8/9/2009 4:00 8/9/2009 116.64
8/9/2009 4:05 8/9/2009 114.048
8/9/2009 4:10 8/9/2009 111.456
8/9/2009 4:15 8/9/2009 114.048
8/9/2009 4:20 8/9/2009 116.64
8/9/2009 4:25 8/9/2009 114.048
8/9/2009 4:30 8/9/2009 114.048
8/9/2009 4:35 8/9/2009 114.048
8/9/2009 4:40 8/9/2009 116.64
8/9/2009 4:45 8/9/2009 116.64
8/9/2009 4:50 8/9/2009 111.456
8/9/2009 4:55 8/9/2009 114.048
8/9/2009 5:00 8/9/2009 114.048
8/9/2009 5:05 8/9/2009 116.64
8/9/2009 5:10 8/9/2009 116.64
8/9/2009 5:15 8/9/2009 114.048
8/9/2009 5:20 8/9/2009 114.048
8/9/2009 5:25 8/9/2009 114.048
8/9/2009 5:30 8/9/2009 116.64
8/9/2009 5:35 8/9/2009 119.232
8/9/2009 5:40 8/9/2009 116.64
8/9/2009 5:45 8/9/2009 119.232
8/9/2009 5:50 8/9/2009 116.64
8/9/2009 5:55 8/9/2009 119.232
8/9/2009 6:00 8/9/2009 121.824
8/9/2009 6:05 8/9/2009 116.64
8/9/2009 6:10 8/9/2009 116.64
8/9/2009 6:15 8/9/2009 116.64
8/9/2009 6:20 8/9/2009 121.824
8/9/2009 6:25 8/9/2009 124.416
8/9/2009 6:30 8/9/2009 116.64
8/9/2009 6:35 8/9/2009 121.824
8/9/2009 6:40 8/9/2009 124.416
8/9/2009 6:45 8/9/2009 127.008
8/9/2009 6:50 8/9/2009 124.416
8/9/2009 6:55 8/9/2009 121.824
8/9/2009 7:00 8/9/2009 124.416
8/9/2009 7:05 8/9/2009 129.6
8/9/2009 7:10 8/9/2009 155.52
8/9/2009 7:15 8/9/2009 181.44
8/9/2009 7:20 8/9/2009 189.216
8/9/2009 7:25 8/9/2009 189.216
8/9/2009 7:30 8/9/2009 186.624
8/9/2009 7:35 8/9/2009 184.032
8/9/2009 7:40 8/9/2009 186.624
8/9/2009 7:45 8/9/2009 184.032
8/9/2009 7:50 8/9/2009 207.36
8/9/2009 7:55 8/9/2009 204.768
8/9/2009 8:00 8/9/2009 207.36
8/9/2009 8:05 8/9/2009 204.768
8/9/2009 8:10 8/9/2009 207.36
8/9/2009 8:15 8/9/2009 207.36
8/9/2009 8:20 8/9/2009 209.952
8/9/2009 8:25 8/9/2009 207.36
8/9/2009 8:30 8/9/2009 204.768
8/9/2009 8:35 8/9/2009 209.952
8/9/2009 8:40 8/9/2009 209.952
8/9/2009 8:45 8/9/2009 212.544
8/9/2009 8:50 8/9/2009 202.176
8/9/2009 8:55 8/9/2009 207.36
8/9/2009 9:00 8/9/2009 209.952
8/9/2009 9:05 8/9/2009 209.952
8/9/2009 9:10 8/9/2009 217.728
8/9/2009 9:15 8/9/2009 228.096
8/9/2009 9:20 8/9/2009 264.384
8/9/2009 9:25 8/9/2009 292.896
8/9/2009 9:30 8/9/2009 235.872
8/9/2009 9:35 8/9/2009 215.136
8/9/2009 9:40 8/9/2009 233.28
8/9/2009 9:45 8/9/2009 269.568
8/9/2009 9:50 8/9/2009 303.264
8/9/2009 9:55 8/9/2009 285.12
8/9/2009 10:00 8/9/2009 220.32
8/9/2009 10:05 8/9/2009 225.504
8/9/2009 10:10 8/9/2009 269.568
8/9/2009 10:15 8/9/2009 292.896
8/9/2009 10:20 8/9/2009 311.04
8/9/2009 10:25 8/9/2009 217.728
8/9/2009 10:30 8/9/2009 215.136
8/9/2009 10:35 8/9/2009 254.016
8/9/2009 10:40 8/9/2009 277.344
8/9/2009 10:45 8/9/2009 313.632
8/9/2009 10:50 8/9/2009 220.32
8/9/2009 10:55 8/9/2009 217.728
8/9/2009 11:00 8/9/2009 217.728
8/9/2009 11:05 8/9/2009 248.832
8/9/2009 11:10 8/9/2009 290.304
8/9/2009 11:15 8/9/2009 334.368
8/9/2009 11:20 8/9/2009 277.344
8/9/2009 11:25 8/9/2009 230.688
8/9/2009 11:30 8/9/2009 228.096
8/9/2009 11:35 8/9/2009 254.016
8/9/2009 11:40 8/9/2009 287.712
8/9/2009 11:45 8/9/2009 339.552
8/9/2009 11:50 8/9/2009 305.856
8/9/2009 11:55 8/9/2009 233.28
8/9/2009 12:00 8/9/2009 235.872
8/9/2009 12:05 8/9/2009 241.056
8/9/2009 12:10 8/9/2009 274.752
8/9/2009 12:15 8/9/2009 324
8/9/2009 12:20 8/9/2009 362.88
8/9/2009 12:25 8/9/2009 303.264
8/9/2009 12:30 8/9/2009 228.096
8/9/2009 12:35 8/9/2009 228.096
8/9/2009 12:40 8/9/2009 274.752
8/9/2009 12:45 8/9/2009 308.448
8/9/2009 12:50 8/9/2009 362.88
8/9/2009 12:55 8/9/2009 347.328
8/9/2009 13:00 8/9/2009 274.752
8/9/2009 13:05 8/9/2009 230.688
8/9/2009 13:10 8/9/2009 256.608
8/9/2009 13:15 8/9/2009 290.304
8/9/2009 13:20 8/9/2009 334.368
8/9/2009 13:25 8/9/2009 370.656
8/9/2009 13:30 8/9/2009 342.144
8/9/2009 13:35 8/9/2009 233.28
8/9/2009 13:40 8/9/2009 233.28
8/9/2009 13:45 8/9/2009 269.568
8/9/2009 13:50 8/9/2009 292.896
8/9/2009 13:55 8/9/2009 355.104
8/9/2009 14:00 8/9/2009 355.104
8/9/2009 14:05 8/9/2009 264.384
8/9/2009 14:10 8/9/2009 225.504
8/9/2009 14:15 8/9/2009 233.28
8/9/2009 14:20 8/9/2009 274.752
8/9/2009 14:25 8/9/2009 318.816
8/9/2009 14:30 8/9/2009 362.88
8/9/2009 14:35 8/9/2009 308.448
8/9/2009 14:40 8/9/2009 217.728
8/9/2009 14:45 8/9/2009 220.32
8/9/2009 14:50 8/9/2009 264.384
8/9/2009 14:55 8/9/2009 300.672
8/9/2009 15:00 8/9/2009 360.288
8/9/2009 15:05 8/9/2009 344.736
8/9/2009 15:10 8/9/2009 222.912
8/9/2009 15:15 8/9/2009 212.544
8/9/2009 15:20 8/9/2009 233.28
8/9/2009 15:25 8/9/2009 264.384
8/9/2009 15:30 8/9/2009 316.224
8/9/2009 15:35 8/9/2009 352.512
8/9/2009 15:40 8/9/2009 225.504
8/9/2009 15:45 8/9/2009 209.952
8/9/2009 15:50 8/9/2009 225.504
8/9/2009 15:55 8/9/2009 261.792
8/9/2009 16:00 8/9/2009 308.448
8/9/2009 16:05 8/9/2009 352.512
8/9/2009 16:10 8/9/2009 233.28
8/9/2009 16:15 8/9/2009 215.136
8/9/2009 16:20 8/9/2009 230.688
8/9/2009 16:25 8/9/2009 269.568
8/9/2009 16:30 8/9/2009 308.448
8/9/2009 16:35 8/9/2009 349.92
8/9/2009 16:40 8/9/2009 217.728
8/9/2009 16:45 8/9/2009 215.136
8/9/2009 16:50 8/9/2009 220.32
8/9/2009 16:55 8/9/2009 259.2
8/9/2009 17:00 8/9/2009 295.488
8/9/2009 17:05 8/9/2009 342.144
8/9/2009 17:10 8/9/2009 222.912
8/9/2009 17:15 8/9/2009 212.544
8/9/2009 17:20 8/9/2009 212.544
8/9/2009 17:25 8/9/2009 251.424
8/9/2009 17:30 8/9/2009 285.12
8/9/2009 17:35 8/9/2009 331.776
8/9/2009 17:40 8/9/2009 220.32
8/9/2009 17:45 8/9/2009 209.952
8/9/2009 17:50 8/9/2009 207.36
8/9/2009 17:55 8/9/2009 251.424
8/9/2009 18:00 8/9/2009 290.304
8/9/2009 18:05 8/9/2009 311.04
8/9/2009 18:10 8/9/2009 191.808
8/9/2009 18:15 8/9/2009 189.216
8/9/2009 18:20 8/9/2009 189.216
8/9/2009 18:25 8/9/2009 186.624
8/9/2009 18:30 8/9/2009 189.216
8/9/2009 18:35 8/9/2009 196.992
8/9/2009 18:40 8/9/2009 238.464
8/9/2009 18:45 8/9/2009 254.016
8/9/2009 18:50 8/9/2009 243.648
8/9/2009 18:55 8/9/2009 189.216
8/9/2009 19:00 8/9/2009 189.216
8/9/2009 19:05 8/9/2009 139.968
8/9/2009 19:10 8/9/2009 139.968
8/9/2009 19:15 8/9/2009 129.6
8/9/2009 19:20 8/9/2009 129.6
8/9/2009 19:25 8/9/2009 132.192
8/9/2009 19:30 8/9/2009 134.784
8/9/2009 19:35 8/9/2009 134.784
8/9/2009 19:40 8/9/2009 134.784
8/9/2009 19:45 8/9/2009 129.6
8/9/2009 19:50 8/9/2009 137.376
8/9/2009 19:55 8/9/2009 134.784
8/9/2009 20:00 8/9/2009 139.968
8/9/2009 20:05 8/9/2009 137.376
8/9/2009 20:10 8/9/2009 134.784
8/9/2009 20:15 8/9/2009 132.192
8/9/2009 20:20 8/9/2009 134.784
8/9/2009 20:25 8/9/2009 127.008
8/9/2009 20:30 8/9/2009 124.416
8/9/2009 20:35 8/9/2009 106.272
8/9/2009 20:40 8/9/2009 106.272
8/9/2009 20:45 8/9/2009 108.864
8/9/2009 20:50 8/9/2009 106.272
8/9/2009 20:55 8/9/2009 106.272
8/9/2009 21:00 8/9/2009 106.272
8/9/2009 21:05 8/9/2009 101.088
8/9/2009 21:10 8/9/2009 106.272
8/9/2009 21:15 8/9/2009 103.68
8/9/2009 21:20 8/9/2009 103.68
8/9/2009 21:25 8/9/2009 103.68
8/9/2009 21:30 8/9/2009 101.088
8/9/2009 21:35 8/9/2009 103.68
8/9/2009 21:40 8/9/2009 103.68
8/9/2009 21:45 8/9/2009 103.68
8/9/2009 21:50 8/9/2009 101.088
8/9/2009 21:55 8/9/2009 114.048
8/9/2009 22:00 8/9/2009 106.272
8/9/2009 22:05 8/9/2009 98.496
8/9/2009 22:10 8/9/2009 106.272
8/9/2009 22:15 8/9/2009 108.864
8/9/2009 22:20 8/9/2009 103.68
8/9/2009 22:25 8/9/2009 103.68
8/9/2009 22:30 8/9/2009 103.68
8/9/2009 22:35 8/9/2009 106.272
8/9/2009 22:40 8/9/2009 106.272
8/9/2009 22:45 8/9/2009 106.272
8/9/2009 22:50 8/9/2009 106.272
8/9/2009 22:55 8/9/2009 106.272
8/9/2009 23:00 8/9/2009 103.68
8/9/2009 23:05 8/9/2009 101.088
8/9/2009 23:10 8/9/2009 103.68
8/9/2009 23:15 8/9/2009 101.088
8/9/2009 23:20 8/9/2009 101.088
8/9/2009 23:25 8/9/2009 101.088
8/9/2009 23:30 8/9/2009 101.088
8/9/2009 23:35 8/9/2009 98.496
8/9/2009 23:40 8/9/2009 98.496
8/9/2009 23:45 8/9/2009 95.904
8/9/2009 23:50 8/9/2009 95.904
8/9/2009 23:55 8/9/2009 95.904

 

[barry houdini]

Hello powerjak, if you use the filter date in a formula that would be easier but if you don't want to do that then try this formula in F3

=INDEX($A$5:$A$7492,MATCH(1,INDEX(($C$5:$C$7492=F2)*SUBTOTAL(3,OFFSET($C$5,ROW($C$5:$C$7492)-ROW($C$5),0)),0),0))

same for G3 except replace F2 with G2