Excel zarządzanie 03 Analiza klientów i daty ROZW


Overview

Arkusz4
analiza klientów
Zmiany w czasie
Stopy procentowe
Zwroty
daty


Sheet 1: Arkusz4







dawno 140.171852088471










średnio











ostatnio 38.7081479115287






















mało 620.247777043501
często 37.863755940998







średnio

średnio








dużo 1389.72182849128
rzadko 69.2986560067941














































średnia 1005.0 89.4 53.6








odchylenie 384.7 50.7 15.7













dużo ostatnio często

Dane



Dane





ID klienta Suma z wartość Minimum z ile do dziś Średnia z ile miedzy
ID klienta Suma z wartość Minimum z ile do dziś Średnia z ile miedzy
value recency frequency
1.00 182.333031884652 57 93.9
1 182.33 zł 57 93.9
mało średnio rzadko
2.00 408.819189984157 55 46.5909090909091
2 408.82 zł 55 46.6
mało średnio średnio
3.00 377.095536072156 143 44.95
3 377.10 zł 143 45.0
mało dawno średnio
4.00 1017.59780002423 79 53.7222222222222
4 1,017.60 zł 79 53.7
średnio średnio średnio
5.00 1358.17449212176 42 46.7727272727273
5 1,358.17 zł 42 46.8
średnio średnio średnio
6.00 1132.4343621084 202 43.1
6 1,132.43 zł 202 43.1
średnio dawno średnio
7.00 864.534016018806 54 61.9375
7 864.53 zł 54 61.9
średnio średnio średnio
8.00 1104.3270992543 56 56.4705882352941
8 1,104.33 zł 56 56.5
średnio średnio średnio
9.00 1376.35544269142 82 41.4583333333333
9 1,376.36 zł 82 41.5
średnio średnio średnio
10.00 1300.19423714562 78 45.3333333333333
10 1,300.19 zł 78 45.3
średnio średnio średnio
11.00 678.370134992147 91 79
11 678.37 zł 91 79.0
średnio średnio rzadko
12.00 1327.88951410868 51 43.695652173913
12 1,327.89 zł 51 43.7
średnio średnio średnio
13.00 1152.86617010825 55 53.4736842105263
13 1,152.87 zł 55 53.5
średnio średnio średnio
14.00 1253.91384322844 117 45.4761904761905
14 1,253.91 zł 117 45.5
średnio średnio średnio
15.00 619.165897255225 42 97.5
15 619.17 zł 42 97.5
mało średnio rzadko
16.00 946.480606619734 334 49.8666666666667
16 946.48 zł 334 49.9
średnio dawno średnio
17.00 1278.34990997748 113 42.4545454545455
17 1,278.35 zł 113 42.5
średnio średnio średnio
18.00 1601.41076098873 62 35.3928571428571
18 1,601.41 zł 62 35.4
dużo średnio często
19.00 862.535842946163 74 63.8666666666667
19 862.54 zł 74 63.9
średnio średnio średnio
20.00 587.971240797269 104 90.6
20 587.97 zł 104 90.6
mało średnio rzadko
21.00 1225.23438868389 51 48.7619047619048
21 1,225.23 zł 51 48.8
średnio średnio średnio
22.00 1469.18493505109 72 36.9166666666667
22 1,469.18 zł 72 36.9
dużo średnio często
23.00 1311.59879280342 55 43.3478260869565
23 1,311.60 zł 55 43.3
średnio średnio średnio
24.00 1114.44314719054 97 48.1
24 1,114.44 zł 97 48.1
średnio średnio średnio
25.00 985.054707824238 142 54.7647058823529
25 985.05 zł 142 54.8
średnio dawno średnio
26.00 940.670708990074 163 58.0666666666667
26 940.67 zł 163 58.1
średnio dawno średnio
27.00 1034.28339750331 91 58.75
27 1,034.28 zł 91 58.8
średnio średnio średnio
28.00 1276.18705583605 76 46.7619047619048
28 1,276.19 zł 76 46.8
średnio średnio średnio
29.00 1189.91646225484 41 51.65
29 1,189.92 zł 41 51.7
średnio średnio średnio
30.00 1443.05818571171 56 39.1923076923077
30 1,443.06 zł 56 39.2
dużo średnio średnio
31.00 1249.36849935177 73 43.1739130434783
31 1,249.37 zł 73 43.2
średnio średnio średnio
32.00 1237.42549625298 41 46.0454545454545
32 1,237.43 zł 41 46.0
średnio średnio średnio
33.00 559.755422070157 80 81.5555555555556
33 559.76 zł 80 81.6
mało średnio rzadko
34.00 902.745344520154 93 60.625
34 902.75 zł 93 60.6
średnio średnio średnio
35.00 1126.67482021934 158 46.3157894736842
35 1,126.67 zł 158 46.3
średnio dawno średnio
36.00 1154.49240148242 62 41.4285714285714
36 1,154.49 zł 62 41.4
średnio średnio średnio
37.00 1037.48026369969 88 54.0555555555556
37 1,037.48 zł 88 54.1
średnio średnio średnio
38.00 1211.97445046979 107 46.3333333333333
38 1,211.97 zł 107 46.3
średnio średnio średnio
39.00 973.061059083411 51 57.4705882352941
39 973.06 zł 51 57.5
średnio średnio średnio
40.00 1548.55528128341 54 36.1481481481481
40 1,548.56 zł 54 36.1
dużo średnio często
41.00 1097.01481116696 63 60.75
41 1,097.01 zł 63 60.8
średnio średnio średnio
42.00 1416.22867565246 58 40.28
42 1,416.23 zł 58 40.3
dużo średnio średnio
43.00 261.337080814483 114 56.5882352941176
43 261.34 zł 114 56.6
mało średnio średnio
44.00 378.171502909408 51 40.68
44 378.17 zł 51 40.7
mało średnio średnio
45.00 286.943815997638 85 47.5
45 286.94 zł 85 47.5
mało średnio średnio
46.00 151.657495298914 153 67.7272727272727
46 151.66 zł 153 67.7
mało dawno średnio
47.00 1133.49222950208 66 50.65
47 1,133.49 zł 66 50.7
średnio średnio średnio
48.00 1581.55472950304 116 32.7142857142857
48 1,581.55 zł 116 32.7
dużo średnio często
49.00 1032.78179886147 110 50.8947368421053
49 1,032.78 zł 110 50.9
średnio średnio średnio
50.00 488.07405005311 114 96.25
50 488.07 zł 114 96.3
mało średnio rzadko
Suma końcowa 50249.2401383695 41 49.8715789473684









Sheet 2: analiza klientów

Poniżej przedstawiono dane nt klientów. Przeprowadź poniższe analizy:
















a) "wyciągnij" składowe daty: rok, miesiąc, dzień







b) utwórz znacznik dla kwartałów z oznaczeniem roku (np..Q1'2008)







c) przygotuj tabelę przestawną dla zamówień klientów w kolejnych latach (np. Jakie zamówienia składał klient nr 17 w kolejnych latach? )







d) posortuj dane i policz ile jest dni pomiędzy zamówieniamy danego klienta







e) policz ile dni minęło od ostatniego zamówienia każdego klienta







f) policz ogólne statystyki dla d), e) i wartości: średnią i odchylenie standardowe







g) policz podstawowe statystyki dla każdego klienta (jak w f) i nazwij je: niskie dla średnia-odchylenie, średnie dla (średnia - odchylenie, średnia + odchylenie), wysokie dla średnia + odchylenie







UWAGA! Można przyjąć dowolne kryteria klasyfikowania klientów - dotyczy to szczególnie dat!







h) wykonaj analizę RFV (recency, frequency, value) - znajdź najlepszych klientów i policz ich




















































a) 3/16/2008
rok 2008






miesiąc 3






dzień 16












b)

kwartał Q1






znacznik Q1'2008 2008'Q1











d) 9/22/2009 20.00






10/31/2007 2.00 -681




3/16/2008 2.00 136 136




10/5/2007 42.00 -161




8/3/2008 42.00 298 298












e)

DZIŚ 8/25/2022




9/22/2009 20.00 4653













f) średnia 21.60






odchylenie 20.02














g) niski 1.58






wysoki 41.62















9/22/2009 20.00 21.54 średni




10/31/2007 2.00 50.97 wysoki




3/16/2008 2.00 63.61 wysoki




10/5/2007 42.00 49.70 wysoki




8/3/2008 42.00 29.71 średni





























6/16/2020
Lp Data ID klienta wartość rok mies dzień ile miedzy ile do dziś
983 4/14/2007 1.00 11.83 2007 4 14.00 4812
288 4/17/2007 1.00 12.47 2007 4 17.00 3 4809
29 5/23/2007 1.00 9.94 2007 5 23.00 36 4773
454 5/23/2008 1.00 14.22 2008 5 23.00 366 4407
286 9/30/2008 1.00 19.38 2008 9 30.00 130 4277
309 10/19/2008 1.00 22.32 2008 10 19.00 19 4258
568 1/12/2009 1.00 12.87 2009 1 12.00 85 4173
225 5/11/2009 1.00 12.28 2009 5 11.00 119 4054
770 11/2/2009 1.00 24.70 2009 11 2.00 175 3879
796 11/4/2009 1.00 20.59 2009 11 4.00 2 3877
670 11/8/2009 1.00 21.74 2009 11 8.00 4 3873
284 1/20/2007 2.00 23.05 2007 1 20.00 4896
954 1/27/2007 2.00 21.60 2007 1 27.00 7 4889
563 2/13/2007 2.00 22.98 2007 2 13.00 17 4872
511 5/19/2007 2.00 13.43 2007 5 19.00 95 4777
660 5/19/2007 2.00 16.62 2007 5 19.00 0 4777
604 5/24/2007 2.00 19.97 2007 5 24.00 5 4772
766 5/26/2007 2.00 17.73 2007 5 26.00 2 4770
493 7/4/2007 2.00 17.54 2007 7 4.00 39 4731
202 8/14/2007 2.00 25.40 2007 8 14.00 41 4690
516 9/21/2007 2.00 27.81 2007 9 21.00 38 4652
94 10/23/2007 2.00 23.47 2007 10 23.00 32 4620
440 11/9/2007 2.00 12.97 2007 11 9.00 17 4603
706 1/10/2008 2.00 13.06 2008 1 10.00 62 4541
246 3/12/2008 2.00 20.10 2008 3 12.00 62 4479
1 3/16/2008 2.00 7.18 2008 3 16.00 4 4475
324 4/7/2008 2.00 20.78 2008 4 7.00 22 4453
74 6/23/2008 2.00 20.58 2008 6 23.00 77 4376
231 7/25/2008 2.00 17.03 2008 7 25.00 32 4344
636 8/29/2008 2.00 12.48 2008 8 29.00 35 4309
79 3/14/2009 2.00 15.65 2009 3 14.00 197 4112
667 9/1/2009 2.00 8.83 2009 9 1.00 171 3941
883 11/8/2009 2.00 10.63 2009 11 8.00 68 3873
951 11/10/2009 2.00 19.93 2009 11 10.00 2 3871
895 2/27/2007 3.00 15.71 2007 2 27.00 4858
638 3/5/2007 3.00 24.08 2007 3 5.00 6 4852
427 7/23/2007 3.00 21.49 2007 7 23.00 140 4712
641 8/20/2007 3.00 14.32 2007 8 20.00 28 4684
855 8/26/2007 3.00 15.64 2007 8 26.00 6 4678
321 9/19/2007 3.00 24.26 2007 9 19.00 24 4654
450 10/10/2007 3.00 17.06 2007 10 10.00 21 4633
158 10/31/2007 3.00 14.82 2007 10 31.00 21 4612
151 1/30/2008 3.00 20.65 2008 1 30.00 91 4521
989 2/24/2008 3.00 5.43 2008 2 24.00 25 4496
970 7/27/2008 3.00 20.30 2008 7 27.00 154 4342
230 9/21/2008 3.00 18.05 2008 9 21.00 56 4286
727 10/3/2008 3.00 15.29 2008 10 3.00 12 4274
980 10/16/2008 3.00 24.84 2008 10 16.00 13 4261
521 1/24/2009 3.00 17.71 2009 1 24.00 100 4161
728 2/23/2009 3.00 27.56 2009 2 23.00 30 4131
977 2/26/2009 3.00 13.73 2009 2 26.00 3 4128
380 2/28/2009 3.00 18.17 2009 2 28.00 2 4126
644 6/24/2009 3.00 21.96 2009 6 24.00 116 4010
160 7/9/2009 3.00 15.42 2009 7 9.00 15 3995
290 8/14/2009 3.00 10.59 2009 8 14.00 36 3959
922 2/23/2007 4.00 78.30 2007 2 23.00 4862
719 6/25/2007 4.00 93.99 2007 6 25.00 122 4740
931 9/25/2007 4.00 65.03 2007 9 25.00 92 4648
419 11/21/2007 4.00 36.71 2007 11 21.00 57 4591
334 12/13/2007 4.00 22.42 2007 12 13.00 22 4569
58 3/9/2008 4.00 52.88 2008 3 9.00 87 4482
187 3/22/2008 4.00 52.16 2008 3 22.00 13 4469
449 4/19/2008 4.00 36.13 2008 4 19.00 28 4441
664 9/1/2008 4.00 68.63 2008 9 1.00 135 4306
80 3/28/2009 4.00 30.59 2009 3 28.00 208 4098
64 5/14/2009 4.00 43.19 2009 5 14.00 47 4051
866 6/10/2009 4.00 59.37 2009 6 10.00 27 4024
768 6/20/2009 4.00 50.08 2009 6 20.00 10 4014
553 7/7/2009 4.00 54.01 2009 7 7.00 17 3997
296 7/17/2009 4.00 43.43 2009 7 17.00 10 3987
417 10/10/2009 4.00 60.91 2009 10 10.00 85 3902
116 10/11/2009 4.00 34.94 2009 10 11.00 1 3901
17 10/15/2009 4.00 52.65 2009 10 15.00 4 3897
216 10/17/2009 4.00 82.18 2009 10 17.00 2 3895
675 1/29/2007 5.00 73.67 2007 1 29.00 4887
556 3/22/2007 5.00 73.43 2007 3 22.00 52 4835
948 5/22/2007 5.00 60.88 2007 5 22.00 61 4774
47 6/27/2007 5.00 68.52 2007 6 27.00 36 4738
317 7/1/2007 5.00 53.30 2007 7 1.00 4 4734
592 8/7/2007 5.00 45.29 2007 8 7.00 37 4697
698 9/2/2007 5.00 65.59 2007 9 2.00 26 4671
40 10/21/2007 5.00 46.98 2007 10 21.00 49 4622
772 11/19/2007 5.00 76.50 2007 11 19.00 29 4593
577 3/6/2008 5.00 67.13 2008 3 6.00 108 4485
128 3/14/2008 5.00 50.56 2008 3 14.00 8 4477
821 7/27/2008 5.00 53.46 2008 7 27.00 135 4342
824 9/18/2008 5.00 61.70 2008 9 18.00 53 4289
918 11/2/2008 5.00 53.87 2008 11 2.00 45 4244
629 11/15/2008 5.00 77.16 2008 11 15.00 13 4231
986 11/22/2008 5.00 26.23 2008 11 22.00 7 4224
617 4/12/2009 5.00 39.03 2009 4 12.00 141 4083
293 9/4/2009 5.00 54.82 2009 9 4.00 145 3938
412 9/18/2009 5.00 46.96 2009 9 18.00 14 3924
238 10/1/2009 5.00 60.88 2009 10 1.00 13 3911
882 10/31/2009 5.00 48.74 2009 10 31.00 30 3881
32 11/15/2009 5.00 67.45 2009 11 15.00 15 3866
399 11/23/2009 5.00 86.02 2009 11 23.00 8 3858
921 2/5/2007 6.00 61.16 2007 2 5.00 4880
915 2/20/2007 6.00 33.48 2007 2 20.00 15 4865
256 2/27/2007 6.00 55.24 2007 2 27.00 7 4858
285 4/12/2007 6.00 70.25 2007 4 12.00 44 4814
952 4/23/2007 6.00 59.52 2007 4 23.00 11 4803
987 12/3/2007 6.00 38.42 2007 12 3.00 224 4579
130 12/6/2007 6.00 87.49 2007 12 6.00 3 4576
326 12/8/2007 6.00 48.74 2007 12 8.00 2 4574
496 12/14/2007 6.00 78.70 2007 12 14.00 6 4568
695 12/17/2007 6.00 44.17 2007 12 17.00 3 4565
755 4/20/2008 6.00 18.01 2008 4 20.00 125 4440
862 8/14/2008 6.00 63.48 2008 8 14.00 116 4324
108 9/24/2008 6.00 55.11 2008 9 24.00 41 4283
498 10/7/2008 6.00 47.58 2008 10 7.00 13 4270
938 12/1/2008 6.00 39.83 2008 12 1.00 55 4215
771 1/3/2009 6.00 61.98 2009 1 3.00 33 4182
302 2/4/2009 6.00 58.70 2009 2 4.00 32 4150
428 3/2/2009 6.00 45.98 2009 3 2.00 26 4124
609 3/23/2009 6.00 88.32 2009 3 23.00 21 4103
576 6/11/2009 6.00 9.76 2009 6 11.00 80 4023
78 6/16/2009 6.00 66.50 2009 6 16.00 5 4018
654 2/24/2007 7.00 57.08 2007 2 24.00 4861
527 3/19/2007 7.00 56.39 2007 3 19.00 23 4838
775 6/19/2007 7.00 63.67 2007 6 19.00 92 4746
832 7/24/2007 7.00 52.52 2007 7 24.00 35 4711
120 9/8/2007 7.00 60.00 2007 9 8.00 46 4665
605 11/19/2007 7.00 57.68 2007 11 19.00 72 4593
8 12/5/2007 7.00 67.09 2007 12 5.00 16 4577
328 4/16/2008 7.00 28.59 2008 4 16.00 133 4444
650 8/25/2008 7.00 55.32 2008 8 25.00 131 4313
132 3/8/2009 7.00 44.16 2009 3 8.00 195 4118
59 4/9/2009 7.00 63.29 2009 4 9.00 32 4086
753 5/29/2009 7.00 44.53 2009 5 29.00 50 4036
438 6/19/2009 7.00 61.19 2009 6 19.00 21 4015
565 8/4/2009 7.00 28.97 2009 8 4.00 46 3969
858 9/13/2009 7.00 50.44 2009 9 13.00 40 3929
929 9/22/2009 7.00 34.09 2009 9 22.00 9 3920
431 11/11/2009 7.00 39.52 2009 11 11.00 50 3870
780 3/25/2007 8.00 60.36 2007 3 25.00 4832
146 3/27/2007 8.00 69.54 2007 3 27.00 2 4830
223 7/17/2007 8.00 73.54 2007 7 17.00 112 4718
458 8/14/2007 8.00 52.17 2007 8 14.00 28 4690
694 10/22/2007 8.00 56.41 2007 10 22.00 69 4621
465 11/13/2007 8.00 74.48 2007 11 13.00 22 4599
579 12/8/2007 8.00 65.15 2007 12 8.00 25 4574
676 4/3/2008 8.00 73.13 2008 4 3.00 117 4457
459 4/21/2008 8.00 25.95 2008 4 21.00 18 4439
736 7/27/2008 8.00 48.67 2008 7 27.00 97 4342
996 7/30/2008 8.00 47.70 2008 7 30.00 3 4339
217 9/27/2008 8.00 57.51 2008 9 27.00 59 4280
548 12/7/2008 8.00 69.93 2008 12 7.00 71 4209
484 2/8/2009 8.00 48.75 2009 2 8.00 63 4146
100 5/2/2009 8.00 50.15 2009 5 2.00 83 4063
763 8/30/2009 8.00 61.82 2009 8 30.00 120 3943
958 10/19/2009 8.00 93.15 2009 10 19.00 50 3893
793 11/9/2009 8.00 75.93 2009 11 9.00 21 3872
612 1/23/2007 9.00 57.51 2007 1 23.00 4893
437 3/14/2007 9.00 48.78 2007 3 14.00 50 4843
542 3/14/2007 9.00 45.37 2007 3 14.00 0 4843
432 5/28/2007 9.00 38.67 2007 5 28.00 75 4768
67 6/18/2007 9.00 53.23 2007 6 18.00 21 4747
373 7/15/2007 9.00 90.33 2007 7 15.00 27 4720
494 8/19/2007 9.00 66.98 2007 8 19.00 35 4685
822 10/4/2007 9.00 49.39 2007 10 4.00 46 4639
36 11/13/2007 9.00 36.44 2007 11 13.00 40 4599
125 2/20/2008 9.00 81.10 2008 2 20.00 99 4500
634 4/30/2008 9.00 57.39 2008 4 30.00 70 4430
999 4/30/2008 9.00 43.84 2008 4 30.00 0 4430
460 6/26/2008 9.00 77.34 2008 6 26.00 57 4373
50 7/6/2008 9.00 50.35 2008 7 6.00 10 4363
765 7/12/2008 9.00 46.61 2008 7 12.00 6 4357
170 8/29/2008 9.00 63.31 2008 8 29.00 48 4309
325 12/11/2008 9.00 34.97 2008 12 11.00 104 4205
597 1/19/2009 9.00 56.88 2009 1 19.00 39 4166
712 2/17/2009 9.00 67.22 2009 2 17.00 29 4137
903 3/17/2009 9.00 76.53 2009 3 17.00 28 4109
923 4/5/2009 9.00 33.16 2009 4 5.00 19 4090
783 6/22/2009 9.00 38.15 2009 6 22.00 78 4012
70 7/3/2009 9.00 78.01 2009 7 3.00 11 4001
441 8/28/2009 9.00 40.50 2009 8 28.00 56 3945
263 10/14/2009 9.00 44.30 2009 10 14.00 47 3898
253 3/11/2007 10.00 48.85 2007 3 11.00 4846
534 5/30/2007 10.00 74.76 2007 5 30.00 80 4766
911 9/7/2007 10.00 62.83 2007 9 7.00 100 4666
413 9/23/2007 10.00 38.89 2007 9 23.00 16 4650
157 11/4/2007 10.00 49.64 2007 11 4.00 42 4608
741 11/24/2007 10.00 54.95 2007 11 24.00 20 4588
601 12/31/2007 10.00 45.37 2007 12 31.00 37 4551
397 2/11/2008 10.00 90.52 2008 2 11.00 42 4509
472 3/28/2008 10.00 56.63 2008 3 28.00 46 4463
446 4/1/2008 10.00 54.68 2008 4 1.00 4 4459
569 4/2/2008 10.00 49.30 2008 4 2.00 1 4458
837 4/29/2008 10.00 78.81 2008 4 29.00 27 4431
863 6/3/2008 10.00 58.30 2008 6 3.00 35 4396
311 8/9/2008 10.00 69.58 2008 8 9.00 67 4329
688 9/8/2008 10.00 70.96 2008 9 8.00 30 4299
7 10/12/2008 10.00 87.45 2008 10 12.00 34 4265
347 10/17/2008 10.00 49.10 2008 10 17.00 5 4260
104 2/16/2009 10.00 62.05 2009 2 16.00 122 4138
4 5/15/2009 10.00 49.70 2009 5 15.00 88 4050
267 6/10/2009 10.00 40.55 2009 6 10.00 26 4024
283 8/5/2009 10.00 44.05 2009 8 5.00 56 3968
401 10/18/2009 10.00 63.23 2009 10 18.00 74 3894
165 3/2/2007 11.00 53.19 2007 3 2.00 4855
54 8/24/2007 11.00 57.42 2007 8 24.00 175 4680
920 9/17/2007 11.00 52.86 2007 9 17.00 24 4656
607 10/14/2008 11.00 44.22 2008 10 14.00 393 4263
124 10/22/2008 11.00 55.20 2008 10 22.00 8 4255
622 10/31/2008 11.00 47.50 2008 10 31.00 9 4246
200 12/18/2008 11.00 54.36 2008 12 18.00 48 4198
889 1/21/2009 11.00 68.30 2009 1 21.00 34 4164
37 5/21/2009 11.00 48.11 2009 5 21.00 120 4044
616 6/28/2009 11.00 35.59 2009 6 28.00 38 4006
799 7/31/2009 11.00 68.15 2009 7 31.00 33 3973
114 8/5/2009 11.00 33.28 2009 8 5.00 5 3968
457 10/5/2009 11.00 60.19 2009 10 5.00 61 3907
71 2/13/2007 12.00 53.12 2007 2 13.00 4872
358 3/9/2007 12.00 41.69 2007 3 9.00 24 4848
113 3/21/2007 12.00 60.47 2007 3 21.00 12 4836
709 3/27/2007 12.00 49.37 2007 3 27.00 6 4830
274 4/29/2007 12.00 68.36 2007 4 29.00 33 4797
555 7/29/2007 12.00 58.32 2007 7 29.00 91 4706
994 8/4/2007 12.00 57.43 2007 8 4.00 6 4700
201 8/20/2007 12.00 70.63 2007 8 20.00 16 4684
26 12/31/2007 12.00 85.88 2007 12 31.00 133 4551
189 2/2/2008 12.00 53.21 2008 2 2.00 33 4518
409 4/1/2008 12.00 50.18 2008 4 1.00 59 4459
339 4/29/2008 12.00 76.03 2008 4 29.00 28 4431
122 5/5/2008 12.00 30.72 2008 5 5.00 6 4425
297 5/8/2008 12.00 50.33 2008 5 8.00 3 4422
393 5/27/2008 12.00 45.66 2008 5 27.00 19 4403
946 7/11/2008 12.00 67.93 2008 7 11.00 45 4358
701 7/12/2008 12.00 49.41 2008 7 12.00 1 4357
12 8/3/2008 12.00 33.14 2008 8 3.00 22 4335
647 9/28/2008 12.00 47.66 2008 9 28.00 56 4279
960 10/23/2008 12.00 44.74 2008 10 23.00 25 4254
942 4/5/2009 12.00 65.91 2009 4 5.00 164 4090
797 6/18/2009 12.00 47.34 2009 6 18.00 74 4016
547 7/27/2009 12.00 50.26 2009 7 27.00 39 3977
857 11/14/2009 12.00 70.09 2009 11 14.00 110 3867
674 1/29/2007 13.00 58.07 2007 1 29.00 4887
984 2/18/2007 13.00 71.37 2007 2 18.00 20 4867
545 2/23/2007 13.00 76.21 2007 2 23.00 5 4862
363 3/17/2007 13.00 48.99 2007 3 17.00 22 4840
447 4/7/2007 13.00 55.91 2007 4 7.00 21 4819
916 10/15/2007 13.00 54.39 2007 10 15.00 191 4628
352 10/29/2007 13.00 63.16 2007 10 29.00 14 4614
536 1/15/2008 13.00 60.04 2008 1 15.00 78 4536
621 3/30/2008 13.00 56.92 2008 3 30.00 75 4461
786 5/9/2008 13.00 45.39 2008 5 9.00 40 4421
224 10/25/2008 13.00 76.51 2008 10 25.00 169 4252
890 11/24/2008 13.00 20.51 2008 11 24.00 30 4222
788 12/2/2008 13.00 56.92 2008 12 2.00 8 4214
265 12/9/2008 13.00 40.90 2008 12 9.00 7 4207
99 1/10/2009 13.00 53.20 2009 1 10.00 32 4175
608 2/4/2009 13.00 42.89 2009 2 4.00 25 4150
969 4/7/2009 13.00 65.33 2009 4 7.00 62 4088
501 8/28/2009 13.00 70.56 2009 8 28.00 143 3945
566 9/15/2009 13.00 69.43 2009 9 15.00 18 3927
278 11/10/2009 13.00 66.17 2009 11 10.00 56 3871
177 1/28/2007 14.00 61.54 2007 1 28.00 4888
531 2/4/2007 14.00 65.59 2007 2 4.00 7 4881
35 3/13/2007 14.00 61.88 2007 3 13.00 37 4844
13 3/28/2007 14.00 58.37 2007 3 28.00 15 4829
476 5/9/2007 14.00 53.10 2007 5 9.00 42 4787
84 6/1/2007 14.00 64.50 2007 6 1.00 23 4764
215 6/10/2007 14.00 60.80 2007 6 10.00 9 4755
314 7/1/2007 14.00 42.42 2007 7 1.00 21 4734
141 10/27/2007 14.00 49.47 2007 10 27.00 118 4616
241 12/16/2007 14.00 33.09 2007 12 16.00 50 4566
643 3/27/2008 14.00 44.57 2008 3 27.00 102 4464
260 5/3/2008 14.00 61.13 2008 5 3.00 37 4427
9 5/26/2008 14.00 62.68 2008 5 26.00 23 4404
899 7/8/2008 14.00 51.00 2008 7 8.00 43 4361
119 11/12/2008 14.00 66.31 2008 11 12.00 127 4234
72 1/29/2009 14.00 66.05 2009 1 29.00 78 4156
327 3/8/2009 14.00 44.47 2009 3 8.00 38 4118
665 6/11/2009 14.00 56.93 2009 6 11.00 95 4023
851 6/14/2009 14.00 42.93 2009 6 14.00 3 4020
897 6/30/2009 14.00 65.48 2009 6 30.00 16 4004
448 8/12/2009 14.00 84.27 2009 8 12.00 43 3961
368 9/9/2009 14.00 57.34 2009 9 9.00 28 3933
242 3/24/2007 15.00 40.52 2007 3 24.00 4833
155 5/4/2007 15.00 63.30 2007 5 4.00 41 4792
896 7/31/2007 15.00 42.21 2007 7 31.00 88 4704
550 8/25/2007 15.00 91.24 2007 8 25.00 25 4679
539 8/29/2007 15.00 50.27 2007 8 29.00 4 4675
18 11/4/2007 15.00 39.51 2007 11 4.00 67 4608
842 12/3/2007 15.00 59.72 2007 12 3.00 29 4579
49 1/13/2008 15.00 72.78 2008 1 13.00 41 4538
773 7/19/2008 15.00 50.75 2008 7 19.00 188 4350
38 7/22/2009 15.00 63.18 2009 7 22.00 368 3982
319 11/23/2009 15.00 45.68 2009 11 23.00 124 3858
816 1/18/2007 16.00 35.21 2007 1 18.00 4898
205 6/11/2007 16.00 72.79 2007 6 11.00 144 4754
907 6/12/2007 16.00 64.60 2007 6 12.00 1 4753
692 7/21/2007 16.00 67.04 2007 7 21.00 39 4714
357 9/5/2007 16.00 74.51 2007 9 5.00 46 4668
894 10/26/2007 16.00 56.64 2007 10 26.00 51 4617
11 10/28/2007 16.00 57.33 2007 10 28.00 2 4615
473 12/4/2007 16.00 58.63 2007 12 4.00 37 4578
271 2/11/2008 16.00 73.98 2008 2 11.00 69 4509
105 3/6/2008 16.00 70.60 2008 3 6.00 24 4485
935 6/6/2008 16.00 58.68 2008 6 6.00 92 4393
273 8/25/2008 16.00 68.80 2008 8 25.00 80 4313
389 10/20/2008 16.00 54.88 2008 10 20.00 56 4257
109 12/14/2008 16.00 24.95 2008 12 14.00 55 4202
570 1/7/2009 16.00 62.00 2009 1 7.00 24 4178
758 2/4/2009 16.00 45.84 2009 2 4.00 28 4150
836 2/22/2007 17.00 44.88 2007 2 22.00 4863
21 3/11/2007 17.00 62.48 2007 3 11.00 17 4846
653 4/20/2007 17.00 49.78 2007 4 20.00 40 4806
537 6/5/2007 17.00 40.48 2007 6 5.00 46 4760
154 12/2/2007 17.00 65.36 2007 12 2.00 180 4580
41 1/27/2008 17.00 53.90 2008 1 27.00 56 4524
239 2/8/2008 17.00 96.44 2008 2 8.00 12 4512
228 2/18/2008 17.00 62.65 2008 2 18.00 10 4502
19 4/15/2008 17.00 64.34 2008 4 15.00 57 4445
902 5/7/2008 17.00 51.76 2008 5 7.00 22 4423
329 6/4/2008 17.00 46.95 2008 6 4.00 28 4395
31 8/16/2008 17.00 62.98 2008 8 16.00 73 4322
492 9/3/2008 17.00 66.87 2008 9 3.00 18 4304
804 9/21/2008 17.00 46.46 2008 9 21.00 18 4286
252 10/2/2008 17.00 38.88 2008 10 2.00 11 4275
571 11/13/2008 17.00 85.39 2008 11 13.00 42 4233
221 12/30/2008 17.00 70.81 2008 12 30.00 47 4186
703 2/13/2009 17.00 45.86 2009 2 13.00 45 4141
499 5/13/2009 17.00 26.35 2009 5 13.00 89 4052
580 6/5/2009 17.00 42.11 2009 6 5.00 23 4029
234 6/26/2009 17.00 54.73 2009 6 26.00 21 4008
143 7/19/2009 17.00 55.78 2009 7 19.00 23 3985
806 9/13/2009 17.00 43.13 2009 9 13.00 56 3929
183 2/16/2007 18.00 62.33 2007 2 16.00 4869
304 4/5/2007 18.00 44.94 2007 4 5.00 48 4821
333 5/4/2007 18.00 93.21 2007 5 4.00 29 4792
504 7/7/2007 18.00 42.39 2007 7 7.00 64 4728
388 8/6/2007 18.00 58.27 2007 8 6.00 30 4698
173 8/26/2007 18.00 59.93 2007 8 26.00 20 4678
66 10/4/2007 18.00 47.59 2007 10 4.00 39 4639
39 11/5/2007 18.00 47.08 2007 11 5.00 32 4607
65 11/10/2007 18.00 45.71 2007 11 10.00 5 4602
590 11/14/2007 18.00 55.25 2007 11 14.00 4 4598
115 12/13/2007 18.00 39.62 2007 12 13.00 29 4569
669 3/26/2008 18.00 64.22 2008 3 26.00 104 4465
530 5/2/2008 18.00 84.42 2008 5 2.00 37 4428
392 5/22/2008 18.00 42.19 2008 5 22.00 20 4408
981 5/27/2008 18.00 64.14 2008 5 27.00 5 4403
847 7/18/2008 18.00 69.51 2008 7 18.00 52 4351
898 9/25/2008 18.00 57.65 2008 9 25.00 69 4282
710 10/10/2008 18.00 40.22 2008 10 10.00 15 4267
538 11/13/2008 18.00 45.53 2008 11 13.00 34 4233
870 11/15/2008 18.00 37.64 2008 11 15.00 2 4231
926 12/16/2008 18.00 52.49 2008 12 16.00 31 4200
147 2/22/2009 18.00 50.71 2009 2 22.00 68 4132
748 2/28/2009 18.00 58.00 2009 2 28.00 6 4126
468 5/4/2009 18.00 46.34 2009 5 4.00 65 4061
193 6/10/2009 18.00 44.08 2009 6 10.00 37 4024
408 6/27/2009 18.00 45.25 2009 6 27.00 17 4007
904 7/20/2009 18.00 51.64 2009 7 20.00 23 3984
106 7/26/2009 18.00 75.26 2009 7 26.00 6 3978
876 11/3/2009 18.00 75.80 2009 11 3.00 100 3878
591 3/9/2007 19.00 56.67 2007 3 9.00 4848
683 5/4/2007 19.00 80.95 2007 5 4.00 56 4792
98 6/26/2007 19.00 71.15 2007 6 26.00 53 4739
639 10/31/2007 19.00 68.51 2007 10 31.00 127 4612
976 12/26/2007 19.00 55.92 2007 12 26.00 56 4556
940 1/7/2008 19.00 39.10 2008 1 7.00 12 4544
702 4/27/2008 19.00 46.76 2008 4 27.00 111 4433
313 8/13/2008 19.00 46.31 2008 8 13.00 108 4325
25 1/6/2009 19.00 60.53 2009 1 6.00 146 4179
107 2/1/2009 19.00 64.92 2009 2 1.00 26 4153
213 2/2/2009 19.00 31.08 2009 2 2.00 1 4152
45 3/26/2009 19.00 67.07 2009 3 26.00 52 4100
196 7/7/2009 19.00 50.45 2009 7 7.00 103 3997
998 9/6/2009 19.00 45.91 2009 9 6.00 61 3936
696 10/14/2009 19.00 44.70 2009 10 14.00 38 3898
191 10/22/2009 19.00 32.50 2009 10 22.00 8 3890
144 3/31/2007 20.00 40.83 2007 3 31.00 4826
164 5/10/2007 20.00 46.23 2007 5 10.00 40 4786
732 6/24/2007 20.00 55.49 2007 6 24.00 45 4741
55 7/19/2007 20.00 76.55 2007 7 19.00 25 4716
708 8/14/2007 20.00 47.24 2007 8 14.00 26 4690
415 2/3/2008 20.00 51.84 2008 2 3.00 173 4517
526 9/13/2008 20.00 55.49 2008 9 13.00 223 4294
910 11/30/2008 20.00 54.79 2008 11 30.00 78 4216
323 12/2/2008 20.00 39.53 2008 12 2.00 2 4214
813 7/17/2009 20.00 69.84 2009 7 17.00 227 3987
14 9/22/2009 20.00 50.15 2009 9 22.00 67 3920
672 1/25/2007 21.00 68.42 2007 1 25.00 4891
505 5/20/2007 21.00 62.77 2007 5 20.00 115 4776
852 5/20/2007 21.00 59.35 2007 5 20.00 0 4776
982 7/23/2007 21.00 67.21 2007 7 23.00 64 4712
620 8/4/2007 21.00 24.14 2007 8 4.00 12 4700
685 10/29/2007 21.00 55.99 2007 10 29.00 86 4614
110 12/13/2007 21.00 72.75 2007 12 13.00 45 4569
838 1/27/2008 21.00 51.54 2008 1 27.00 45 4524
502 4/22/2008 21.00 53.70 2008 4 22.00 86 4438
506 6/8/2008 21.00 72.62 2008 6 8.00 47 4391
478 6/19/2008 21.00 50.41 2008 6 19.00 11 4380
659 6/29/2008 21.00 33.18 2008 6 29.00 10 4370
280 8/27/2008 21.00 54.78 2008 8 27.00 59 4311
619 9/24/2008 21.00 76.68 2008 9 24.00 28 4283
416 12/26/2008 21.00 24.45 2008 12 26.00 93 4190
825 1/24/2009 21.00 41.40 2009 1 24.00 29 4161
226 5/1/2009 21.00 65.19 2009 5 1.00 97 4064
623 6/22/2009 21.00 36.75 2009 6 22.00 52 4012
972 7/28/2009 21.00 46.52 2009 7 28.00 36 3976
944 9/9/2009 21.00 70.79 2009 9 9.00 43 3933
112 9/12/2009 21.00 66.74 2009 9 12.00 3 3930
785 11/14/2009 21.00 69.85 2009 11 14.00 63 3867
843 5/22/2007 22.00 50.35 2007 5 22.00 4774
474 8/9/2007 22.00 48.27 2007 8 9.00 79 4695
174 9/5/2007 22.00 42.84 2007 9 5.00 27 4668
411 9/16/2007 22.00 59.43 2007 9 16.00 11 4657
387 10/3/2007 22.00 39.40 2007 10 3.00 17 4640
258 10/10/2007 22.00 45.75 2007 10 10.00 7 4633
965 11/16/2007 22.00 62.27 2007 11 16.00 37 4596
480 11/27/2007 22.00 74.30 2007 11 27.00 11 4585
930 12/18/2007 22.00 51.31 2007 12 18.00 21 4564
139 1/17/2008 22.00 62.57 2008 1 17.00 30 4534
594 3/19/2008 22.00 63.46 2008 3 19.00 62 4472
932 3/25/2008 22.00 88.50 2008 3 25.00 6 4466
42 5/20/2008 22.00 54.76 2008 5 20.00 56 4410
237 6/11/2008 22.00 47.71 2008 6 11.00 22 4388
118 6/17/2008 22.00 73.84 2008 6 17.00 6 4382
257 6/17/2008 22.00 75.74 2008 6 17.00 0 4382
829 11/17/2008 22.00 34.63 2008 11 17.00 153 4229
452 12/9/2008 22.00 84.26 2008 12 9.00 22 4207
908 1/6/2009 22.00 81.53 2009 1 6.00 28 4179
95 3/13/2009 22.00 65.74 2009 3 13.00 66 4113
887 4/9/2009 22.00 59.54 2009 4 9.00 27 4086
586 4/14/2009 22.00 48.71 2009 4 14.00 5 4081
662 7/13/2009 22.00 45.70 2009 7 13.00 90 3991
917 7/24/2009 22.00 53.85 2009 7 24.00 11 3980
232 10/24/2009 22.00 54.71 2009 10 24.00 92 3888
175 2/17/2007 23.00 67.08 2007 2 17.00 4868
81 3/28/2007 23.00 69.06 2007 3 28.00 39 4829
729 4/3/2007 23.00 43.03 2007 4 3.00 6 4823
197 4/26/2007 23.00 63.02 2007 4 26.00 23 4800
336 5/15/2007 23.00 72.83 2007 5 15.00 19 4781
208 9/15/2007 23.00 37.80 2007 9 15.00 123 4658
519 10/16/2007 23.00 52.76 2007 10 16.00 31 4627
803 10/30/2007 23.00 61.97 2007 10 30.00 14 4613
587 11/17/2007 23.00 90.13 2007 11 17.00 18 4595
961 1/5/2008 23.00 56.58 2008 1 5.00 49 4546
168 1/22/2008 23.00 59.29 2008 1 22.00 17 4529
140 1/27/2008 23.00 70.02 2008 1 27.00 5 4524
355 7/22/2008 23.00 47.94 2008 7 22.00 177 4347
206 9/22/2008 23.00 39.69 2008 9 22.00 62 4285
839 11/20/2008 23.00 50.90 2008 11 20.00 59 4226
725 1/30/2009 23.00 21.43 2009 1 30.00 71 4155
559 2/1/2009 23.00 32.88 2009 2 1.00 2 4153
436 2/5/2009 23.00 31.44 2009 2 5.00 4 4149
699 3/7/2009 23.00 62.21 2009 3 7.00 30 4119
384 4/21/2009 23.00 65.76 2009 4 21.00 45 4074
414 8/7/2009 23.00 73.95 2009 8 7.00 108 3966
184 10/14/2009 23.00 62.01 2009 10 14.00 68 3898
152 10/23/2009 23.00 38.60 2009 10 23.00 9 3889
445 11/10/2009 23.00 41.22 2009 11 10.00 18 3871
434 2/10/2007 24.00 56.98 2007 2 10.00 4875
687 3/8/2007 24.00 40.64 2007 3 8.00 26 4849
85 3/15/2007 24.00 30.78 2007 3 15.00 7 4842
111 9/7/2007 24.00 41.15 2007 9 7.00 176 4666
711 11/16/2007 24.00 37.34 2007 11 16.00 70 4596
162 2/27/2008 24.00 49.81 2008 2 27.00 103 4493
878 6/8/2008 24.00 60.64 2008 6 8.00 102 4391
810 6/16/2008 24.00 74.20 2008 6 16.00 8 4383
77 7/21/2008 24.00 64.80 2008 7 21.00 35 4348
627 9/10/2008 24.00 61.50 2008 9 10.00 51 4297
739 9/27/2008 24.00 37.86 2008 9 27.00 17 4280
310 10/30/2008 24.00 52.87 2008 10 30.00 33 4247
418 3/6/2009 24.00 36.60 2009 3 6.00 127 4120
308 3/14/2009 24.00 71.20 2009 3 14.00 8 4112
973 3/29/2009 24.00 58.09 2009 3 29.00 15 4097
27 5/4/2009 24.00 56.24 2009 5 4.00 36 4061
398 6/2/2009 24.00 60.86 2009 6 2.00 29 4032
603 6/21/2009 24.00 54.86 2009 6 21.00 19 4013
840 7/22/2009 24.00 65.07 2009 7 22.00 31 3982
61 8/10/2009 24.00 56.16 2009 8 10.00 19 3963
831 9/29/2009 24.00 46.80 2009 9 29.00 50 3913
488 1/27/2007 25.00 97.47 2007 1 27.00 4889
933 3/28/2007 25.00 48.89 2007 3 28.00 60 4829
233 6/9/2007 25.00 45.14 2007 6 9.00 73 4756
312 8/23/2007 25.00 31.29 2007 8 23.00 75 4681
865 8/24/2007 25.00 47.39 2007 8 24.00 1 4680
466 11/8/2007 25.00 62.09 2007 11 8.00 76 4604
979 3/1/2008 25.00 41.67 2008 3 1.00 114 4490
845 7/3/2008 25.00 91.18 2008 7 3.00 124 4366
145 8/7/2008 25.00 49.68 2008 8 7.00 35 4331
294 9/5/2008 25.00 49.81 2008 9 5.00 29 4302
962 10/16/2008 25.00 57.68 2008 10 16.00 41 4261
856 11/3/2008 25.00 45.10 2008 11 3.00 18 4243
991 12/25/2008 25.00 35.41 2008 12 25.00 52 4191
275 1/30/2009 25.00 52.46 2009 1 30.00 36 4155
268 2/22/2009 25.00 64.50 2009 2 22.00 23 4132
564 4/2/2009 25.00 50.55 2009 4 2.00 39 4093
295 5/30/2009 25.00 77.06 2009 5 30.00 58 4035
381 8/15/2009 25.00 37.69 2009 8 15.00 77 3958
593 3/7/2007 26.00 58.83 2007 3 7.00 4850
470 3/20/2007 26.00 56.22 2007 3 20.00 13 4837
400 4/22/2007 26.00 59.28 2007 4 22.00 33 4804
782 4/29/2007 26.00 70.94 2007 4 29.00 7 4797
827 7/10/2007 26.00 61.91 2007 7 10.00 72 4725
479 10/31/2007 26.00 71.39 2007 10 31.00 113 4612
22 1/2/2008 26.00 57.57 2008 1 2.00 63 4549
341 3/15/2008 26.00 63.38 2008 3 15.00 73 4476
968 3/18/2008 26.00 57.40 2008 3 18.00 3 4473
464 4/11/2008 26.00 25.87 2008 4 11.00 24 4449
812 10/3/2008 26.00 50.13 2008 10 3.00 175 4274
509 10/29/2008 26.00 79.59 2008 10 29.00 26 4248
250 11/5/2008 26.00 53.22 2008 11 5.00 7 4241
663 1/8/2009 26.00 82.96 2009 1 8.00 64 4177
572 2/27/2009 26.00 38.84 2009 2 27.00 50 4127
161 7/25/2009 26.00 53.15 2009 7 25.00 148 3979
658 3/10/2007 27.00 68.36 2007 3 10.00 4847
86 3/17/2007 27.00 40.06 2007 3 17.00 7 4840
740 3/22/2007 27.00 61.58 2007 3 22.00 5 4835
272 5/21/2007 27.00 37.74 2007 5 21.00 60 4775
172 6/27/2007 27.00 25.37 2007 6 27.00 37 4738
535 6/28/2007 27.00 64.66 2007 6 28.00 1 4737
817 7/25/2007 27.00 56.95 2007 7 25.00 27 4710
2 10/31/2007 27.00 50.97 2007 10 31.00 98 4612
613 12/15/2007 27.00 66.29 2007 12 15.00 45 4567
853 9/2/2008 27.00 62.53 2008 9 2.00 262 4305
721 9/9/2008 27.00 79.99 2008 9 9.00 7 4298
248 11/14/2008 27.00 54.25 2008 11 14.00 66 4232
618 1/20/2009 27.00 60.81 2009 1 20.00 67 4165
978 3/20/2009 27.00 67.20 2009 3 20.00 59 4106
508 5/9/2009 27.00 94.71 2009 5 9.00 50 4056
483 9/17/2009 27.00 69.80 2009 9 17.00 131 3925
403 10/5/2009 27.00 73.01 2009 10 5.00 18 3907
482 2/11/2007 28.00 52.44 2007 2 11.00 4874
818 3/23/2007 28.00 56.57 2007 3 23.00 40 4834
848 5/29/2007 28.00 67.88 2007 5 29.00 67 4767
330 9/4/2007 28.00 57.36 2007 9 4.00 98 4669
243 10/12/2007 28.00 66.90 2007 10 12.00 38 4631
136 12/5/2007 28.00 46.42 2007 12 5.00 54 4577
523 1/15/2008 28.00 42.88 2008 1 15.00 41 4536
423 1/20/2008 28.00 62.55 2008 1 20.00 5 4531
779 4/17/2008 28.00 68.32 2008 4 17.00 88 4443
697 7/30/2008 28.00 43.77 2008 7 30.00 104 4339
24 8/4/2008 28.00 87.09 2008 8 4.00 5 4334
266 9/3/2008 28.00 48.34 2008 9 3.00 30 4304
171 10/3/2008 28.00 56.09 2008 10 3.00 30 4274
305 10/4/2008 28.00 53.66 2008 10 4.00 1 4273
97 10/8/2008 28.00 39.71 2008 10 8.00 4 4269
835 3/6/2009 28.00 50.26 2009 3 6.00 149 4120
966 3/25/2009 28.00 58.99 2009 3 25.00 19 4101
543 5/4/2009 28.00 57.36 2009 5 4.00 40 4061
767 5/11/2009 28.00 78.28 2009 5 11.00 7 4054
567 7/7/2009 28.00 48.92 2009 7 7.00 57 3997
270 8/14/2009 28.00 73.70 2009 8 14.00 38 3959
967 10/20/2009 28.00 58.72 2009 10 20.00 67 3892
299 1/26/2007 29.00 73.29 2007 1 26.00 4890
207 3/25/2007 29.00 70.93 2007 3 25.00 58 4832
53 4/10/2007 29.00 57.72 2007 4 10.00 16 4816
429 4/12/2007 29.00 50.74 2007 4 12.00 2 4814
510 6/17/2007 29.00 64.41 2007 6 17.00 66 4748
20 7/25/2007 29.00 47.32 2007 7 25.00 38 4710
877 11/15/2007 29.00 34.52 2007 11 15.00 113 4597
561 1/2/2008 29.00 60.61 2008 1 2.00 48 4549
148 1/23/2008 29.00 29.65 2008 1 23.00 21 4528
44 1/31/2008 29.00 54.43 2008 1 31.00 8 4520
757 8/25/2008 29.00 50.08 2008 8 25.00 207 4313
374 9/23/2008 29.00 82.90 2008 9 23.00 29 4284
726 11/12/2008 29.00 39.45 2008 11 12.00 50 4234
451 12/24/2008 29.00 58.05 2008 12 24.00 42 4192
864 4/1/2009 29.00 87.34 2009 4 1.00 98 4094
914 5/13/2009 29.00 60.61 2009 5 13.00 42 4052
1000 6/3/2009 29.00 43.70 2009 6 3.00 21 4031
730 7/18/2009 29.00 52.49 2009 7 18.00 45 3986
69 11/5/2009 29.00 65.86 2009 11 5.00 110 3876
390 11/10/2009 29.00 53.81 2009 11 10.00 5 3871
89 11/24/2009 29.00 51.99 2009 11 24.00 14 3857
343 1/25/2007 30.00 43.22 2007 1 25.00 4891
635 2/17/2007 30.00 50.83 2007 2 17.00 23 4868
893 4/26/2007 30.00 34.18 2007 4 26.00 68 4800
15 7/5/2007 30.00 34.51 2007 7 5.00 70 4730
820 8/20/2007 30.00 43.79 2007 8 20.00 46 4684
735 9/18/2007 30.00 73.33 2007 9 18.00 29 4655
385 11/28/2007 30.00 71.60 2007 11 28.00 71 4584
211 3/23/2008 30.00 40.84 2008 3 23.00 116 4468
477 3/29/2008 30.00 36.32 2008 3 29.00 6 4462
121 3/31/2008 30.00 56.28 2008 3 31.00 2 4460
396 4/4/2008 30.00 42.95 2008 4 4.00 4 4456
203 5/26/2008 30.00 85.88 2008 5 26.00 52 4404
402 7/7/2008 30.00 51.89 2008 7 7.00 42 4362
512 12/8/2008 30.00 71.06 2008 12 8.00 154 4208
657 2/7/2009 30.00 48.26 2009 2 7.00 61 4147
823 3/13/2009 30.00 57.80 2009 3 13.00 34 4113
425 4/1/2009 30.00 53.37 2009 4 1.00 19 4094
500 4/10/2009 30.00 39.15 2009 4 10.00 9 4085
405 5/31/2009 30.00 45.66 2009 5 31.00 51 4034
885 7/26/2009 30.00 47.76 2009 7 26.00 56 3978
846 7/31/2009 30.00 72.49 2009 7 31.00 5 3973
557 8/29/2009 30.00 58.40 2009 8 29.00 29 3944
637 9/15/2009 30.00 53.38 2009 9 15.00 17 3927
956 10/6/2009 30.00 28.93 2009 10 6.00 21 3906
762 10/14/2009 30.00 97.34 2009 10 14.00 8 3898
924 10/23/2009 30.00 82.72 2009 10 23.00 9 3889
361 11/9/2009 30.00 21.13 2009 11 9.00 17 3872
990 2/3/2007 31.00 49.96 2007 2 3.00 4882
156 7/24/2007 31.00 77.27 2007 7 24.00 171 4711
331 8/6/2007 31.00 42.10 2007 8 6.00 13 4698
769 8/25/2007 31.00 50.77 2007 8 25.00 19 4679
386 10/9/2007 31.00 57.80 2007 10 9.00 45 4634
950 10/24/2007 31.00 71.27 2007 10 24.00 15 4619
367 12/1/2007 31.00 34.13 2007 12 1.00 38 4581
214 12/30/2007 31.00 47.74 2007 12 30.00 29 4552
720 4/1/2008 31.00 46.43 2008 4 1.00 93 4459
746 4/14/2008 31.00 58.89 2008 4 14.00 13 4446
682 4/27/2008 31.00 43.44 2008 4 27.00 13 4433
738 4/30/2008 31.00 54.80 2008 4 30.00 3 4430
854 5/19/2008 31.00 47.30 2008 5 19.00 19 4411
778 6/15/2008 31.00 30.03 2008 6 15.00 27 4384
560 10/27/2008 31.00 52.69 2008 10 27.00 134 4250
754 11/29/2008 31.00 44.87 2008 11 29.00 33 4217
844 12/4/2008 31.00 53.99 2008 12 4.00 5 4212
277 12/15/2008 31.00 64.22 2008 12 15.00 11 4201
28 1/11/2009 31.00 39.80 2009 1 11.00 27 4174
595 2/26/2009 31.00 61.73 2009 2 26.00 46 4128
943 7/3/2009 31.00 83.04 2009 7 3.00 127 4001
453 7/25/2009 31.00 32.63 2009 7 25.00 22 3979
185 7/30/2009 31.00 47.30 2009 7 30.00 5 3974
860 10/23/2009 31.00 57.15 2009 10 23.00 85 3889
467 2/15/2007 32.00 34.04 2007 2 15.00 4870
583 4/4/2007 32.00 55.52 2007 4 4.00 48 4822
801 4/5/2007 32.00 44.64 2007 4 5.00 1 4821
934 7/3/2007 32.00 71.82 2007 7 3.00 89 4732
287 9/15/2007 32.00 74.38 2007 9 15.00 74 4658
971 10/10/2007 32.00 69.52 2007 10 10.00 25 4633
880 10/31/2007 32.00 54.60 2007 10 31.00 21 4612
743 12/2/2007 32.00 50.89 2007 12 2.00 32 4580
632 12/7/2007 32.00 54.14 2007 12 7.00 5 4575
335 1/2/2008 32.00 64.66 2008 1 2.00 26 4549
131 2/26/2008 32.00 88.57 2008 2 26.00 55 4494
689 3/3/2008 32.00 68.33 2008 3 3.00 6 4488
833 3/3/2008 32.00 37.29 2008 3 3.00 0 4488
481 4/13/2008 32.00 60.33 2008 4 13.00 41 4447
584 5/1/2008 32.00 54.65 2008 5 1.00 18 4429
487 8/6/2008 32.00 54.62 2008 8 6.00 97 4332
23 10/12/2008 32.00 47.71 2008 10 12.00 67 4265
520 12/10/2008 32.00 24.75 2008 12 10.00 59 4206
828 7/6/2009 32.00 38.99 2009 7 6.00 208 3998
589 8/6/2009 32.00 62.97 2009 8 6.00 31 3967
16 9/20/2009 32.00 30.52 2009 9 20.00 45 3922
928 11/15/2009 32.00 46.52 2009 11 15.00 56 3866
939 11/24/2009 32.00 47.95 2009 11 24.00 9 3857
60 10/13/2007 33.00 59.77 2007 10 13.00 4630
346 11/19/2007 33.00 55.42 2007 11 19.00 37 4593
135 12/22/2007 33.00 50.23 2007 12 22.00 33 4560
491 2/24/2008 33.00 45.09 2008 2 24.00 64 4496
133 4/11/2008 33.00 77.98 2008 4 11.00 47 4449
300 1/11/2009 33.00 67.77 2009 1 11.00 275 4174
645 5/3/2009 33.00 62.73 2009 5 3.00 112 4062
671 7/10/2009 33.00 36.19 2009 7 10.00 68 3994
282 9/7/2009 33.00 40.99 2009 9 7.00 59 3935
874 10/16/2009 33.00 63.59 2009 10 16.00 39 3896
691 2/6/2007 34.00 31.83 2007 2 6.00 4879
420 2/15/2007 34.00 41.95 2007 2 15.00 9 4870
717 5/20/2007 34.00 58.00 2007 5 20.00 94 4776
522 8/1/2007 34.00 45.39 2007 8 1.00 73 4703
815 12/19/2007 34.00 43.09 2007 12 19.00 140 4563
359 1/24/2008 34.00 49.23 2008 1 24.00 36 4527
700 2/17/2008 34.00 92.54 2008 2 17.00 24 4503
10 6/30/2008 34.00 59.80 2008 6 30.00 134 4369
379 7/9/2008 34.00 50.88 2008 7 9.00 9 4360
985 7/12/2008 34.00 56.58 2008 7 12.00 3 4357
345 8/9/2008 34.00 69.19 2008 8 9.00 28 4329
350 11/3/2008 34.00 56.92 2008 11 3.00 86 4243
394 2/28/2009 34.00 54.13 2009 2 28.00 117 4126
764 4/12/2009 34.00 47.80 2009 4 12.00 43 4083
776 6/24/2009 34.00 52.21 2009 6 24.00 73 4010
430 7/7/2009 34.00 26.86 2009 7 7.00 13 3997
581 10/3/2009 34.00 66.35 2009 10 3.00 88 3909
30 3/3/2007 35.00 67.27 2007 3 3.00 4854
679 3/16/2007 35.00 52.86 2007 3 16.00 13 4841
34 4/6/2007 35.00 62.60 2007 4 6.00 21 4820
188 8/9/2007 35.00 69.04 2007 8 9.00 125 4695
588 9/17/2007 35.00 65.08 2007 9 17.00 39 4656
262 11/14/2007 35.00 44.52 2007 11 14.00 58 4598
718 12/9/2007 35.00 46.84 2007 12 9.00 25 4573
937 1/20/2008 35.00 31.44 2008 1 20.00 42 4531
750 3/31/2008 35.00 57.59 2008 3 31.00 71 4460
62 5/19/2008 35.00 92.51 2008 5 19.00 49 4411
628 5/28/2008 35.00 65.92 2008 5 28.00 9 4402
633 6/23/2008 35.00 57.03 2008 6 23.00 26 4376
871 8/5/2008 35.00 62.26 2008 8 5.00 43 4333
957 10/6/2008 35.00 36.11 2008 10 6.00 62 4271
421 11/16/2008 35.00 58.52 2008 11 16.00 41 4230
533 5/28/2009 35.00 61.53 2009 5 28.00 193 4037
869 6/13/2009 35.00 45.80 2009 6 13.00 16 4021
43 7/9/2009 35.00 38.89 2009 7 9.00 26 3995
375 7/16/2009 35.00 73.00 2009 7 16.00 7 3988
289 7/30/2009 35.00 37.86 2009 7 30.00 14 3974
789 6/17/2007 36.00 59.94 2007 6 17.00 4748
210 7/12/2007 36.00 38.86 2007 7 12.00 25 4723
927 8/2/2007 36.00 52.82 2007 8 2.00 21 4702
103 9/20/2007 36.00 49.82 2007 9 20.00 49 4653
993 9/24/2007 36.00 31.48 2007 9 24.00 4 4649
625 10/25/2007 36.00 60.82 2007 10 25.00 31 4618
192 3/7/2008 36.00 66.82 2008 3 7.00 134 4484
378 4/6/2008 36.00 37.30 2008 4 6.00 30 4454
514 4/28/2008 36.00 43.85 2008 4 28.00 22 4432
959 7/19/2008 36.00 52.46 2008 7 19.00 82 4350
651 7/25/2008 36.00 68.07 2008 7 25.00 6 4344
573 7/28/2008 36.00 45.60 2008 7 28.00 3 4341
881 9/21/2008 36.00 70.62 2008 9 21.00 55 4286
179 9/25/2008 36.00 42.44 2008 9 25.00 4 4282
906 11/3/2008 36.00 63.19 2008 11 3.00 39 4243
686 12/18/2008 36.00 48.86 2008 12 18.00 45 4198
529 1/13/2009 36.00 75.42 2009 1 13.00 26 4172
486 1/17/2009 36.00 52.31 2009 1 17.00 4 4168
631 1/27/2009 36.00 37.72 2009 1 27.00 10 4158
652 5/30/2009 36.00 63.27 2009 5 30.00 123 4035
463 8/4/2009 36.00 63.49 2009 8 4.00 66 3969
199 11/3/2009 36.00 29.32 2009 11 3.00 91 3878
792 2/8/2007 37.00 24.52 2007 2 8.00 4877
705 3/23/2007 37.00 69.43 2007 3 23.00 43 4834
892 9/1/2007 37.00 27.33 2007 9 1.00 162 4672
209 10/5/2007 37.00 74.75 2007 10 5.00 34 4638
366 11/1/2007 37.00 76.97 2007 11 1.00 27 4611
489 2/14/2008 37.00 55.42 2008 2 14.00 105 4506
819 3/11/2008 37.00 17.62 2008 3 11.00 26 4480
677 4/19/2008 37.00 55.54 2008 4 19.00 39 4441
176 5/7/2008 37.00 33.36 2008 5 7.00 18 4423
975 6/11/2008 37.00 68.95 2008 6 11.00 35 4388
382 7/26/2008 37.00 80.18 2008 7 26.00 45 4343
574 9/2/2008 37.00 41.97 2008 9 2.00 38 4305
255 10/23/2008 37.00 42.79 2008 10 23.00 51 4254
544 11/23/2008 37.00 62.21 2008 11 23.00 31 4223
73 12/18/2008 37.00 75.22 2008 12 18.00 25 4198
166 12/23/2008 37.00 63.03 2008 12 23.00 5 4193
117 7/3/2009 37.00 50.07 2009 7 3.00 192 4001
316 8/29/2009 37.00 55.36 2009 8 29.00 57 3944
648 10/8/2009 37.00 62.75 2009 10 8.00 40 3904
528 1/20/2007 38.00 48.70 2007 1 20.00 4896
811 1/30/2007 38.00 49.76 2007 1 30.00 10 4886
138 2/24/2007 38.00 88.54 2007 2 24.00 25 4861
690 4/21/2007 38.00 67.45 2007 4 21.00 56 4805
178 8/5/2007 38.00 53.05 2007 8 5.00 106 4699
777 9/12/2007 38.00 60.78 2007 9 12.00 38 4661
254 12/10/2007 38.00 53.21 2007 12 10.00 89 4572
391 12/22/2007 38.00 69.78 2007 12 22.00 12 4560
337 1/6/2008 38.00 82.84 2008 1 6.00 15 4545
562 5/10/2008 38.00 44.56 2008 5 10.00 125 4420
912 8/4/2008 38.00 83.39 2008 8 4.00 86 4334
575 8/9/2008 38.00 58.94 2008 8 9.00 5 4329
126 10/6/2008 38.00 39.71 2008 10 6.00 58 4271
127 10/22/2008 38.00 50.17 2008 10 22.00 16 4255
802 2/6/2009 38.00 61.14 2009 2 6.00 107 4148
167 3/6/2009 38.00 43.41 2009 3 6.00 28 4120
661 7/8/2009 38.00 33.45 2009 7 8.00 124 3996
656 7/20/2009 38.00 14.29 2009 7 20.00 12 3984
88 8/4/2009 38.00 44.17 2009 8 4.00 15 3969
82 8/19/2009 38.00 84.61 2009 8 19.00 15 3954
462 9/7/2009 38.00 52.73 2009 9 7.00 19 3935
356 9/19/2009 38.00 27.28 2009 9 19.00 12 3923
433 3/13/2007 39.00 40.07 2007 3 13.00 4844
859 5/1/2007 39.00 44.68 2007 5 1.00 49 4795
247 8/30/2007 39.00 68.81 2007 8 30.00 121 4674
552 10/2/2007 39.00 37.57 2007 10 2.00 33 4641
181 1/23/2008 39.00 44.65 2008 1 23.00 113 4528
269 5/24/2008 39.00 46.11 2008 5 24.00 122 4406
596 6/2/2008 39.00 45.19 2008 6 2.00 9 4397
298 9/3/2008 39.00 49.74 2008 9 3.00 93 4304
578 10/3/2008 39.00 49.30 2008 10 3.00 30 4274
901 10/18/2008 39.00 61.27 2008 10 18.00 15 4259
919 11/3/2008 39.00 48.48 2008 11 3.00 16 4243
745 11/19/2008 39.00 47.12 2008 11 19.00 16 4227
716 1/14/2009 39.00 66.52 2009 1 14.00 56 4171
354 1/26/2009 39.00 69.50 2009 1 26.00 12 4159
747 3/5/2009 39.00 72.20 2009 3 5.00 38 4121
733 4/11/2009 39.00 53.06 2009 4 11.00 37 4084
715 5/31/2009 39.00 58.90 2009 5 31.00 50 4034
787 11/14/2009 39.00 69.89 2009 11 14.00 167 3867
76 3/11/2007 40.00 43.40 2007 3 11.00 4846
734 3/26/2007 40.00 50.55 2007 3 26.00 15 4831
159 3/29/2007 40.00 44.99 2007 3 29.00 3 4828
826 5/14/2007 40.00 55.19 2007 5 14.00 46 4782
680 6/11/2007 40.00 68.94 2007 6 11.00 28 4754
322 7/20/2007 40.00 81.38 2007 7 20.00 39 4715
281 9/29/2007 40.00 66.75 2007 9 29.00 71 4644
495 1/22/2008 40.00 42.29 2008 1 22.00 115 4529
87 2/23/2008 40.00 56.33 2008 2 23.00 32 4497
212 2/29/2008 40.00 84.41 2008 2 29.00 6 4491
925 4/15/2008 40.00 45.02 2008 4 15.00 46 4445
349 4/30/2008 40.00 51.76 2008 4 30.00 15 4430
541 4/30/2008 40.00 73.37 2008 4 30.00 0 4430
57 5/13/2008 40.00 70.20 2008 5 13.00 13 4417
46 6/12/2008 40.00 66.91 2008 6 12.00 30 4387
129 7/7/2008 40.00 58.64 2008 7 7.00 25 4362
798 8/18/2008 40.00 53.14 2008 8 18.00 42 4320
891 11/23/2008 40.00 55.19 2008 11 23.00 97 4223
624 12/12/2008 40.00 58.38 2008 12 12.00 19 4204
68 1/17/2009 40.00 35.91 2009 1 17.00 36 4168
251 2/14/2009 40.00 60.65 2009 2 14.00 28 4140
872 3/8/2009 40.00 19.37 2009 3 8.00 22 4118
395 5/13/2009 40.00 55.05 2009 5 13.00 66 4052
410 5/22/2009 40.00 32.73 2009 5 22.00 9 4043
307 8/7/2009 40.00 51.56 2009 8 7.00 77 3966
610 8/9/2009 40.00 72.38 2009 8 9.00 2 3964
142 8/13/2009 40.00 40.10 2009 8 13.00 4 3960
955 11/11/2009 40.00 53.97 2009 11 11.00 90 3870
909 3/6/2007 41.00 58.79 2007 3 6.00 4851
760 3/25/2007 41.00 83.10 2007 3 25.00 19 4832
353 4/29/2007 41.00 85.18 2007 4 29.00 35 4797
149 6/15/2007 41.00 75.96 2007 6 15.00 47 4750
681 7/31/2007 41.00 68.69 2007 7 31.00 46 4704
75 8/15/2007 41.00 71.67 2007 8 15.00 15 4689
276 10/25/2007 41.00 66.04 2007 10 25.00 71 4618
693 12/9/2007 41.00 27.71 2007 12 9.00 45 4573
469 12/30/2007 41.00 40.27 2007 12 30.00 21 4552
92 6/28/2008 41.00 59.55 2008 6 28.00 181 4371
6 12/29/2008 41.00 45.16 2008 12 29.00 184 4187
91 4/4/2009 41.00 61.73 2009 4 4.00 96 4091
849 5/25/2009 41.00 70.42 2009 5 25.00 51 4040
279 5/26/2009 41.00 71.24 2009 5 26.00 1 4039
807 8/8/2009 41.00 81.59 2009 8 8.00 74 3965
888 10/4/2009 41.00 72.64 2009 10 4.00 57 3908
642 11/2/2009 41.00 57.29 2009 11 2.00 29 3879
666 2/4/2007 42.00 58.36 2007 2 4.00 4881
737 2/21/2007 42.00 75.33 2007 2 21.00 17 4864
646 4/26/2007 42.00 46.12 2007 4 26.00 64 4800
490 5/21/2007 42.00 27.67 2007 5 21.00 25 4775
426 5/25/2007 42.00 46.27 2007 5 25.00 4 4771
222 7/24/2007 42.00 64.33 2007 7 24.00 60 4711
3 10/5/2007 42.00 63.61 2007 10 5.00 73 4638
713 10/16/2007 42.00 57.31 2007 10 16.00 11 4627
781 12/9/2007 42.00 47.29 2007 12 9.00 54 4573
532 2/24/2008 42.00 84.77 2008 2 24.00 77 4496
93 3/24/2008 42.00 66.83 2008 3 24.00 29 4467
684 4/7/2008 42.00 36.25 2008 4 7.00 14 4453
913 4/28/2008 42.00 48.85 2008 4 28.00 21 4432
518 5/5/2008 42.00 59.60 2008 5 5.00 7 4425
5 5/9/2008 42.00 29.71 2008 5 9.00 4 4421
808 7/16/2008 42.00 59.93 2008 7 16.00 68 4353
342 7/31/2008 42.00 75.33 2008 7 31.00 15 4338
306 11/27/2008 42.00 51.08 2008 11 27.00 119 4219
195 12/19/2008 42.00 53.01 2008 12 19.00 22 4197
606 12/28/2008 42.00 47.05 2008 12 28.00 9 4188
261 3/11/2009 42.00 63.19 2009 3 11.00 73 4115
949 3/14/2009 42.00 53.34 2009 3 14.00 3 4112
649 5/10/2009 42.00 36.94 2009 5 10.00 57 4055
471 5/29/2009 42.00 54.92 2009 5 29.00 19 4036
614 9/5/2009 42.00 66.58 2009 9 5.00 99 3937
752 11/7/2009 42.00 42.56 2009 11 7.00 63 3874
867 1/24/2007 43.00 19.20 2007 1 24.00 4892
546 3/28/2007 43.00 17.49 2007 3 28.00 63 4829
668 6/22/2007 43.00 16.48 2007 6 22.00 86 4743
90 6/26/2007 43.00 10.77 2007 6 26.00 4 4739
48 10/1/2007 43.00 18.67 2007 10 1.00 97 4642
988 12/19/2007 43.00 10.77 2007 12 19.00 79 4563
424 12/28/2007 43.00 12.02 2007 12 28.00 9 4554
163 5/13/2008 43.00 11.53 2008 5 13.00 137 4417
240 5/15/2008 43.00 16.20 2008 5 15.00 2 4415
169 5/23/2008 43.00 17.57 2008 5 23.00 8 4407
759 8/14/2008 43.00 17.36 2008 8 14.00 83 4324
964 10/10/2008 43.00 22.50 2008 10 10.00 57 4267
291 12/30/2008 43.00 8.57 2008 12 30.00 81 4186
900 6/12/2009 43.00 12.79 2009 6 12.00 164 4022
186 7/25/2009 43.00 9.80 2009 7 25.00 43 3979
102 8/30/2009 43.00 15.95 2009 8 30.00 36 3943
101 9/12/2009 43.00 14.05 2009 9 12.00 13 3930
507 9/12/2009 43.00 9.60 2009 9 12.00 0 3930
841 2/1/2007 44.00 19.26 2007 2 1.00 4884
236 2/19/2007 44.00 13.56 2007 2 19.00 18 4866
220 3/25/2007 44.00 12.78 2007 3 25.00 34 4832
365 4/16/2007 44.00 11.08 2007 4 16.00 22 4810
364 5/5/2007 44.00 13.03 2007 5 5.00 19 4791
814 5/14/2007 44.00 12.56 2007 5 14.00 9 4782
318 5/17/2007 44.00 9.16 2007 5 17.00 3 4779
707 6/13/2007 44.00 15.47 2007 6 13.00 27 4752
153 6/23/2007 44.00 3.58 2007 6 23.00 10 4742
630 1/21/2008 44.00 15.79 2008 1 21.00 212 4530
795 3/17/2008 44.00 8.70 2008 3 17.00 56 4474
850 6/29/2008 44.00 19.60 2008 6 29.00 104 4370
180 10/16/2008 44.00 17.41 2008 10 16.00 109 4261
377 10/21/2008 44.00 17.42 2008 10 21.00 5 4256
485 1/12/2009 44.00 20.15 2009 1 12.00 83 4173
722 4/2/2009 44.00 15.61 2009 4 2.00 80 4093
800 4/18/2009 44.00 9.23 2009 4 18.00 16 4077
602 6/17/2009 44.00 12.39 2009 6 17.00 60 4017
360 8/4/2009 44.00 10.55 2009 8 4.00 48 3969
936 8/27/2009 44.00 16.17 2009 8 27.00 23 3946
995 9/6/2009 44.00 13.93 2009 9 6.00 10 3936
830 10/4/2009 44.00 17.90 2009 10 4.00 28 3908
344 10/22/2009 44.00 33.87 2009 10 22.00 18 3890
497 10/29/2009 44.00 10.40 2009 10 29.00 7 3883
33 11/14/2009 44.00 16.11 2009 11 14.00 16 3867
134 11/14/2009 44.00 12.45 2009 11 14.00 0 3867
315 3/6/2007 45.00 12.45 2007 3 6.00 4851
673 4/25/2007 45.00 17.21 2007 4 25.00 50 4801
723 6/18/2007 45.00 15.84 2007 6 18.00 54 4747
455 7/12/2007 45.00 11.89 2007 7 12.00 24 4723
259 8/7/2007 45.00 13.37 2007 8 7.00 26 4697
406 11/23/2007 45.00 19.38 2007 11 23.00 108 4589
774 11/26/2007 45.00 5.66 2007 11 26.00 3 4586
953 2/22/2008 45.00 14.79 2008 2 22.00 88 4498
235 7/21/2008 45.00 15.50 2008 7 21.00 150 4348
370 9/24/2008 45.00 16.95 2008 9 24.00 65 4283
794 10/12/2008 45.00 18.00 2008 10 12.00 18 4265
834 11/10/2008 45.00 9.14 2008 11 10.00 29 4236
219 12/30/2008 45.00 10.71 2008 12 30.00 50 4186
963 1/14/2009 45.00 17.84 2009 1 14.00 15 4171
443 3/26/2009 45.00 7.34 2009 3 26.00 71 4100
150 4/25/2009 45.00 17.52 2009 4 25.00 30 4070
724 6/6/2009 45.00 7.57 2009 6 6.00 42 4028
442 7/30/2009 45.00 13.14 2009 7 30.00 54 3974
974 8/8/2009 45.00 12.20 2009 8 8.00 9 3965
704 9/13/2009 45.00 19.02 2009 9 13.00 36 3929
422 10/11/2009 45.00 11.43 2009 10 11.00 28 3901
204 7/21/2007 46.00 9.34 2007 7 21.00 4714
761 8/23/2007 46.00 16.84 2007 8 23.00 33 4681
194 9/5/2007 46.00 15.79 2007 9 5.00 13 4668
198 9/21/2007 46.00 9.12 2007 9 21.00 16 4652
791 9/21/2007 46.00 8.42 2007 9 21.00 0 4652
439 8/9/2008 46.00 15.00 2008 8 9.00 323 4329
756 12/9/2008 46.00 13.23 2008 12 9.00 122 4207
525 12/27/2008 46.00 9.70 2008 12 27.00 18 4189
229 1/19/2009 46.00 13.52 2009 1 19.00 23 4166
600 6/10/2009 46.00 16.88 2009 6 10.00 142 4024
554 7/16/2009 46.00 11.67 2009 7 16.00 36 3988
513 8/4/2009 46.00 12.14 2009 8 4.00 19 3969
56 1/21/2007 47.00 68.01 2007 1 21.00 4895
52 2/11/2007 47.00 27.15 2007 2 11.00 21 4874
742 5/1/2007 47.00 68.67 2007 5 1.00 79 4795
551 6/25/2007 47.00 66.35 2007 6 25.00 55 4740
444 7/13/2007 47.00 38.12 2007 7 13.00 18 4722
524 8/12/2007 47.00 63.62 2007 8 12.00 30 4692
517 9/13/2007 47.00 52.98 2007 9 13.00 32 4660
338 10/4/2007 47.00 45.67 2007 10 4.00 21 4639
372 11/27/2007 47.00 59.89 2007 11 27.00 54 4585
227 12/4/2007 47.00 56.08 2007 12 4.00 7 4578
905 4/10/2008 47.00 53.03 2008 4 10.00 128 4450
123 5/26/2008 47.00 50.58 2008 5 26.00 46 4404
456 7/18/2008 47.00 60.40 2008 7 18.00 53 4351
340 7/20/2008 47.00 40.82 2008 7 20.00 2 4349
558 8/13/2008 47.00 58.24 2008 8 13.00 24 4325
714 10/9/2008 47.00 37.93 2008 10 9.00 57 4268
63 12/6/2008 47.00 39.95 2008 12 6.00 58 4210
784 2/2/2009 47.00 47.71 2009 2 2.00 58 4152
182 7/22/2009 47.00 58.96 2009 7 22.00 170 3982
790 8/20/2009 47.00 58.66 2009 8 20.00 29 3953
369 10/30/2009 47.00 80.66 2009 10 30.00 71 3882
362 3/9/2007 48.00 76.51 2007 3 9.00 4848
301 4/14/2007 48.00 46.33 2007 4 14.00 36 4812
320 4/16/2007 48.00 38.57 2007 4 16.00 2 4810
611 4/21/2007 48.00 35.96 2007 4 21.00 5 4805
751 5/11/2007 48.00 58.33 2007 5 11.00 20 4785
376 5/13/2007 48.00 77.80 2007 5 13.00 2 4783
515 6/1/2007 48.00 33.08 2007 6 1.00 19 4764
997 6/11/2007 48.00 43.83 2007 6 11.00 10 4754
868 6/22/2007 48.00 58.83 2007 6 22.00 11 4743
245 9/6/2007 48.00 42.97 2007 9 6.00 76 4667
96 12/16/2007 48.00 70.56 2007 12 16.00 101 4566
348 1/12/2008 48.00 55.91 2008 1 12.00 27 4539
51 2/1/2008 48.00 60.31 2008 2 1.00 20 4519
941 3/16/2008 48.00 40.55 2008 3 16.00 44 4475
549 3/22/2008 48.00 73.05 2008 3 22.00 6 4469
873 3/29/2008 48.00 50.04 2008 3 29.00 7 4462
879 5/26/2008 48.00 50.89 2008 5 26.00 58 4404
303 7/26/2008 48.00 60.62 2008 7 26.00 61 4343
371 8/27/2008 48.00 33.17 2008 8 27.00 32 4311
861 9/9/2008 48.00 50.40 2008 9 9.00 13 4298
884 10/5/2008 48.00 38.25 2008 10 5.00 26 4272
475 11/16/2008 48.00 58.97 2008 11 16.00 42 4230
945 12/2/2008 48.00 65.24 2008 12 2.00 16 4214
540 2/13/2009 48.00 67.18 2009 2 13.00 73 4141
332 3/2/2009 48.00 72.12 2009 3 2.00 17 4124
947 3/9/2009 48.00 61.80 2009 3 9.00 7 4117
137 5/17/2009 48.00 66.59 2009 5 17.00 69 4048
615 9/2/2009 48.00 34.13 2009 9 2.00 108 3940
805 9/10/2009 48.00 59.56 2009 9 10.00 8 3932
383 1/23/2007 49.00 43.20 2007 1 23.00 4893
585 3/14/2007 49.00 45.36 2007 3 14.00 50 4843
582 5/4/2007 49.00 46.57 2007 5 4.00 51 4792
461 5/20/2007 49.00 63.79 2007 5 20.00 16 4776
809 8/13/2007 49.00 72.91 2007 8 13.00 85 4691
626 9/25/2007 49.00 23.03 2007 9 25.00 43 4648
292 10/23/2007 49.00 89.70 2007 10 23.00 28 4620
598 11/23/2007 49.00 65.22 2007 11 23.00 31 4589
731 12/3/2007 49.00 56.44 2007 12 3.00 10 4579
599 3/21/2008 49.00 65.65 2008 3 21.00 109 4470
503 4/4/2008 49.00 43.96 2008 4 4.00 14 4456
249 7/27/2008 49.00 57.96 2008 7 27.00 114 4342
749 8/26/2008 49.00 43.44 2008 8 26.00 30 4312
640 12/23/2008 49.00 54.73 2008 12 23.00 119 4193
244 4/15/2009 49.00 45.37 2009 4 15.00 113 4080
407 5/14/2009 49.00 37.81 2009 5 14.00 29 4051
435 6/19/2009 49.00 46.19 2009 6 19.00 36 4015
264 7/3/2009 49.00 23.58 2009 7 3.00 14 4001
655 8/19/2009 49.00 48.47 2009 8 19.00 47 3954
875 9/16/2009 49.00 59.40 2009 9 16.00 28 3926
404 8/4/2007 50.00 52.30 2007 8 4.00 4700
83 1/14/2008 50.00 69.01 2008 1 14.00 163 4537
992 4/19/2008 50.00 70.97 2008 4 19.00 96 4441
218 6/15/2008 50.00 34.19 2008 6 15.00 57 4384
678 3/1/2009 50.00 36.98 2009 3 1.00 259 4125
190 3/24/2009 50.00 83.29 2009 3 24.00 23 4102
351 8/24/2009 50.00 14.01 2009 8 24.00 153 3949
886 9/5/2009 50.00 64.43 2009 9 5.00 12 3937
744 9/12/2009 50.00 62.89 2009 9 12.00 7 3930

Sheet 3: Zmiany w czasie

Poniżej przedstawiono te same dane co w poprzedniej zakładce:


a) pokaż trend sprzedaży w kolejnych miesiącach


b) pokaż trend sprzedaży w kolejnych kwartałach


c) pokaż całkowitą wartość sprzedaży zależną od daty pierwszego nabycia (wg miesięcy)



# znajdź najwcześniejszą datę dla każdego klienta


# znajdź całkowitą sprzedaż dla każdego klienta


# wykorzystaj tabelę przestawną













Lp Data ID klienta wartość
1 3/16/2008 2.00 21.54
2 10/31/2007 27.00 50.97
3 10/5/2007 42.00 63.61
4 5/15/2009 10.00 49.70
5 5/9/2008 42.00 29.71
6 12/29/2008 41.00 45.16
7 10/12/2008 10.00 87.45
8 12/5/2007 7.00 67.09
9 5/26/2008 14.00 62.68
10 6/30/2008 34.00 59.80
11 10/28/2007 16.00 57.33
12 8/3/2008 12.00 33.14
13 3/28/2007 14.00 58.37
14 9/22/2009 20.00 50.15
15 7/5/2007 30.00 34.51
16 9/20/2009 32.00 30.52
17 10/15/2009 4.00 52.65
18 11/4/2007 15.00 39.51
19 4/15/2008 17.00 64.34
20 7/25/2007 29.00 47.32
21 3/11/2007 17.00 62.48
22 1/2/2008 26.00 57.57
23 10/12/2008 32.00 47.71
24 8/4/2008 28.00 87.09
25 1/6/2009 19.00 60.53
26 12/31/2007 12.00 85.88
27 5/4/2009 24.00 56.24
28 1/11/2009 31.00 39.80
29 5/23/2007 1.00 29.81
30 3/3/2007 35.00 67.27
31 8/16/2008 17.00 62.98
32 11/15/2009 5.00 67.45
33 11/14/2009 44.00 64.46
34 4/6/2007 35.00 62.60
35 3/13/2007 14.00 61.88
36 11/13/2007 9.00 36.44
37 5/21/2009 11.00 48.11
38 7/22/2009 15.00 63.18
39 11/5/2007 18.00 47.08
40 10/21/2007 5.00 46.98
41 1/27/2008 17.00 53.90
42 5/20/2008 22.00 54.76
43 7/9/2009 35.00 38.89
44 1/31/2008 29.00 54.43
45 3/26/2009 19.00 67.07
46 6/12/2008 40.00 66.91
47 6/27/2007 5.00 68.52
48 10/1/2007 43.00 74.69
49 1/13/2008 15.00 72.78
50 7/6/2008 9.00 50.35
51 2/1/2008 48.00 60.31
52 2/11/2007 47.00 27.15
53 4/10/2007 29.00 57.72
54 8/24/2007 11.00 57.42
55 7/19/2007 20.00 76.55
56 1/21/2007 47.00 68.01
57 5/13/2008 40.00 70.20
58 3/9/2008 4.00 52.88
59 4/9/2009 7.00 63.29
60 10/13/2007 33.00 59.77
61 8/10/2009 24.00 56.16
62 5/19/2008 35.00 92.51
63 12/6/2008 47.00 39.95
64 5/14/2009 4.00 43.19
65 11/10/2007 18.00 45.71
66 10/4/2007 18.00 47.59
67 6/18/2007 9.00 53.23
68 1/17/2009 40.00 35.91
69 11/5/2009 29.00 65.86
70 7/3/2009 9.00 78.01
71 2/13/2007 12.00 53.12
72 1/29/2009 14.00 66.05
73 12/18/2008 37.00 75.22
74 6/23/2008 2.00 61.73
75 8/15/2007 41.00 71.67
76 3/11/2007 40.00 43.40
77 7/21/2008 24.00 64.80
78 6/16/2009 6.00 66.50
79 3/14/2009 2.00 46.96
80 3/28/2009 4.00 30.59
81 3/28/2007 23.00 69.06
82 8/19/2009 38.00 84.61
83 1/14/2008 50.00 69.01
84 6/1/2007 14.00 64.50
85 3/15/2007 24.00 30.78
86 3/17/2007 27.00 40.06
87 2/23/2008 40.00 56.33
88 8/4/2009 38.00 44.17
89 11/24/2009 29.00 51.99
90 6/26/2007 43.00 43.10
91 4/4/2009 41.00 61.73
92 6/28/2008 41.00 59.55
93 3/24/2008 42.00 66.83
94 10/23/2007 2.00 70.42
95 3/13/2009 22.00 65.74
96 12/16/2007 48.00 70.56
97 10/8/2008 28.00 39.71
98 6/26/2007 19.00 71.15
99 1/10/2009 13.00 53.20
100 5/2/2009 8.00 50.15
101 9/12/2009 43.00 56.21
102 8/30/2009 43.00 63.79
103 9/20/2007 36.00 49.82
104 2/16/2009 10.00 62.05
105 3/6/2008 16.00 70.60
106 7/26/2009 18.00 75.26
107 2/1/2009 19.00 64.92
108 9/24/2008 6.00 55.11
109 12/14/2008 16.00 24.95
110 12/13/2007 21.00 72.75
111 9/7/2007 24.00 41.15
112 9/12/2009 21.00 66.74
113 3/21/2007 12.00 60.47
114 8/5/2009 11.00 33.28
115 12/13/2007 18.00 39.62
116 10/11/2009 4.00 34.94
117 7/3/2009 37.00 50.07
118 6/17/2008 22.00 73.84
119 11/12/2008 14.00 66.31
120 9/8/2007 7.00 60.00
121 3/31/2008 30.00 56.28
122 5/5/2008 12.00 30.72
123 5/26/2008 47.00 50.58
124 10/22/2008 11.00 55.20
125 2/20/2008 9.00 81.10
126 10/6/2008 38.00 39.71
127 10/22/2008 38.00 50.17
128 3/14/2008 5.00 50.56
129 7/7/2008 40.00 58.64
130 12/6/2007 6.00 87.49
131 2/26/2008 32.00 88.57
132 3/8/2009 7.00 44.16
133 4/11/2008 33.00 77.98
134 11/14/2009 44.00 49.79
135 12/22/2007 33.00 50.23
136 12/5/2007 28.00 46.42
137 5/17/2009 48.00 66.59
138 2/24/2007 38.00 88.54
139 1/17/2008 22.00 62.57
140 1/27/2008 23.00 70.02
141 10/27/2007 14.00 49.47
142 8/13/2009 40.00 40.10
143 7/19/2009 17.00 55.78
144 3/31/2007 20.00 40.83
145 8/7/2008 25.00 49.68
146 3/27/2007 8.00 69.54
147 2/22/2009 18.00 50.71
148 1/23/2008 29.00 29.65
149 6/15/2007 41.00 75.96
150 4/25/2009 45.00 70.08
151 1/30/2008 3.00 61.94
152 10/23/2009 23.00 38.60
153 6/23/2007 44.00 14.34
154 12/2/2007 17.00 65.36
155 5/4/2007 15.00 63.30
156 7/24/2007 31.00 77.27
157 11/4/2007 10.00 49.64
158 10/31/2007 3.00 44.47
159 3/29/2007 40.00 44.99
160 7/9/2009 3.00 46.26
161 7/25/2009 26.00 53.15
162 2/27/2008 24.00 49.81
163 5/13/2008 43.00 46.14
164 5/10/2007 20.00 46.23
165 3/2/2007 11.00 53.19
166 12/23/2008 37.00 63.03
167 3/6/2009 38.00 43.41
168 1/22/2008 23.00 59.29
169 5/23/2008 43.00 70.29
170 8/29/2008 9.00 63.31
171 10/3/2008 28.00 56.09
172 6/27/2007 27.00 25.37
173 8/26/2007 18.00 59.93
174 9/5/2007 22.00 42.84
175 2/17/2007 23.00 67.08
176 5/7/2008 37.00 33.36
177 1/28/2007 14.00 61.54
178 8/5/2007 38.00 53.05
179 9/25/2008 36.00 42.44
180 10/16/2008 44.00 69.64
181 1/23/2008 39.00 44.65
182 7/22/2009 47.00 58.96
183 2/16/2007 18.00 62.33
184 10/14/2009 23.00 62.01
185 7/30/2009 31.00 47.30
186 7/25/2009 43.00 39.20
187 3/22/2008 4.00 52.16
188 8/9/2007 35.00 69.04
189 2/2/2008 12.00 53.21
190 3/24/2009 50.00 83.29
191 10/22/2009 19.00 32.50
192 3/7/2008 36.00 66.82
193 6/10/2009 18.00 44.08
194 9/5/2007 46.00 63.18
195 12/19/2008 42.00 53.01
196 7/7/2009 19.00 50.45
197 4/26/2007 23.00 63.02
198 9/21/2007 46.00 36.47
199 11/3/2009 36.00 29.32
200 12/18/2008 11.00 54.36
201 8/20/2007 12.00 70.63
202 8/14/2007 2.00 76.20
203 5/26/2008 30.00 85.88
204 7/21/2007 46.00 37.38
205 6/11/2007 16.00 72.79
206 9/22/2008 23.00 39.69
207 3/25/2007 29.00 70.93
208 9/15/2007 23.00 37.80
209 10/5/2007 37.00 74.75
210 7/12/2007 36.00 38.86
211 3/23/2008 30.00 40.84
212 2/29/2008 40.00 84.41
213 2/2/2009 19.00 31.08
214 12/30/2007 31.00 47.74
215 6/10/2007 14.00 60.80
216 10/17/2009 4.00 82.18
217 9/27/2008 8.00 57.51
218 6/15/2008 50.00 34.19
219 12/30/2008 45.00 42.82
220 3/25/2007 44.00 51.13
221 12/30/2008 17.00 70.81
222 7/24/2007 42.00 64.33
223 7/17/2007 8.00 73.54
224 10/25/2008 13.00 76.51
225 5/11/2009 1.00 36.85
226 5/1/2009 21.00 65.19
227 12/4/2007 47.00 56.08
228 2/18/2008 17.00 62.65
229 1/19/2009 46.00 54.08
230 9/21/2008 3.00 54.16
231 7/25/2008 2.00 51.08
232 10/24/2009 22.00 54.71
233 6/9/2007 25.00 45.14
234 6/26/2009 17.00 54.73
235 7/21/2008 45.00 62.02
236 2/19/2007 44.00 54.26
237 6/11/2008 22.00 47.71
238 10/1/2009 5.00 60.88
239 2/8/2008 17.00 96.44
240 5/15/2008 43.00 64.79
241 12/16/2007 14.00 33.09
242 3/24/2007 15.00 40.52
243 10/12/2007 28.00 66.90
244 4/15/2009 49.00 45.37
245 9/6/2007 48.00 42.97
246 3/12/2008 2.00 60.29
247 8/30/2007 39.00 68.81
248 11/14/2008 27.00 54.25
249 7/27/2008 49.00 57.96
250 11/5/2008 26.00 53.22
251 2/14/2009 40.00 60.65
252 10/2/2008 17.00 38.88
253 3/11/2007 10.00 48.85
254 12/10/2007 38.00 53.21
255 10/23/2008 37.00 42.79
256 2/27/2007 6.00 55.24
257 6/17/2008 22.00 75.74
258 10/10/2007 22.00 45.75
259 8/7/2007 45.00 53.48
260 5/3/2008 14.00 61.13
261 3/11/2009 42.00 63.19
262 11/14/2007 35.00 44.52
263 10/14/2009 9.00 44.30
264 7/3/2009 49.00 23.58
265 12/9/2008 13.00 40.90
266 9/3/2008 28.00 48.34
267 6/10/2009 10.00 40.55
268 2/22/2009 25.00 64.50
269 5/24/2008 39.00 46.11
270 8/14/2009 28.00 73.70
271 2/11/2008 16.00 73.98
272 5/21/2007 27.00 37.74
273 8/25/2008 16.00 68.80
274 4/29/2007 12.00 68.36
275 1/30/2009 25.00 52.46
276 10/25/2007 41.00 66.04
277 12/15/2008 31.00 64.22
278 11/10/2009 13.00 66.17
279 5/26/2009 41.00 71.24
280 8/27/2008 21.00 54.78
281 9/29/2007 40.00 66.75
282 9/7/2009 33.00 40.99
283 8/5/2009 10.00 44.05
284 1/20/2007 2.00 69.14
285 4/12/2007 6.00 70.25
286 9/30/2008 1.00 58.14
287 9/15/2007 32.00 74.38
288 4/17/2007 1.00 37.41
289 7/30/2009 35.00 37.86
290 8/14/2009 3.00 31.77
291 12/30/2008 43.00 34.29
292 10/23/2007 49.00 89.70
293 9/4/2009 5.00 54.82
294 9/5/2008 25.00 49.81
295 5/30/2009 25.00 77.06
296 7/17/2009 4.00 43.43
297 5/8/2008 12.00 50.33
298 9/3/2008 39.00 49.74
299 1/26/2007 29.00 73.29
300 1/11/2009 33.00 67.77
301 4/14/2007 48.00 46.33
302 2/4/2009 6.00 58.70
303 7/26/2008 48.00 60.62
304 4/5/2007 18.00 44.94
305 10/4/2008 28.00 53.66
306 11/27/2008 42.00 51.08
307 8/7/2009 40.00 51.56
308 3/14/2009 24.00 71.20
309 10/19/2008 1.00 66.96
310 10/30/2008 24.00 52.87
311 8/9/2008 10.00 69.58
312 8/23/2007 25.00 31.29
313 8/13/2008 19.00 46.31
314 7/1/2007 14.00 42.42
315 3/6/2007 45.00 49.80
316 8/29/2009 37.00 55.36
317 7/1/2007 5.00 53.30
318 5/17/2007 44.00 36.62
319 11/23/2009 15.00 45.68
320 4/16/2007 48.00 38.57
321 9/19/2007 3.00 72.77
322 7/20/2007 40.00 81.38
323 12/2/2008 20.00 39.53
324 4/7/2008 2.00 62.33
325 12/11/2008 9.00 34.97
326 12/8/2007 6.00 48.74
327 3/8/2009 14.00 44.47
328 4/16/2008 7.00 28.59
329 6/4/2008 17.00 46.95
330 9/4/2007 28.00 57.36
331 8/6/2007 31.00 42.10
332 3/2/2009 48.00 72.12
333 5/4/2007 18.00 93.21
334 12/13/2007 4.00 22.42
335 1/2/2008 32.00 64.66
336 5/15/2007 23.00 72.83
337 1/6/2008 38.00 82.84
338 10/4/2007 47.00 45.67
339 4/29/2008 12.00 76.03
340 7/20/2008 47.00 40.82
341 3/15/2008 26.00 63.38
342 7/31/2008 42.00 75.33
343 1/25/2007 30.00 43.22
344 10/22/2009 44.00 135.47
345 8/9/2008 34.00 69.19
346 11/19/2007 33.00 55.42
347 10/17/2008 10.00 49.10
348 1/12/2008 48.00 55.91
349 4/30/2008 40.00 51.76
350 11/3/2008 34.00 56.92
351 8/24/2009 50.00 14.01
352 10/29/2007 13.00 63.16
353 4/29/2007 41.00 85.18
354 1/26/2009 39.00 69.50
355 7/22/2008 23.00 47.94
356 9/19/2009 38.00 27.28
357 9/5/2007 16.00 74.51
358 3/9/2007 12.00 41.69
359 1/24/2008 34.00 49.23
360 8/4/2009 44.00 42.20
361 11/9/2009 30.00 21.13
362 3/9/2007 48.00 76.51
363 3/17/2007 13.00 48.99
364 5/5/2007 44.00 52.10
365 4/16/2007 44.00 44.32
366 11/1/2007 37.00 76.97
367 12/1/2007 31.00 34.13
368 9/9/2009 14.00 57.34
369 10/30/2009 47.00 80.66
370 9/24/2008 45.00 67.81
371 8/27/2008 48.00 33.17
372 11/27/2007 47.00 59.89
373 7/15/2007 9.00 90.33
374 9/23/2008 29.00 82.90
375 7/16/2009 35.00 73.00
376 5/13/2007 48.00 77.80
377 10/21/2008 44.00 69.68
378 4/6/2008 36.00 37.30
379 7/9/2008 34.00 50.88
380 2/28/2009 3.00 54.51
381 8/15/2009 25.00 37.69
382 7/26/2008 37.00 80.18
383 1/23/2007 49.00 43.20
384 4/21/2009 23.00 65.76
385 11/28/2007 30.00 71.60
386 10/9/2007 31.00 57.80
387 10/3/2007 22.00 39.40
388 8/6/2007 18.00 58.27
389 10/20/2008 16.00 54.88
390 11/10/2009 29.00 53.81
391 12/22/2007 38.00 69.78
392 5/22/2008 18.00 42.19
393 5/27/2008 12.00 45.66
394 2/28/2009 34.00 54.13
395 5/13/2009 40.00 55.05
396 4/4/2008 30.00 42.95
397 2/11/2008 10.00 90.52
398 6/2/2009 24.00 60.86
399 11/23/2009 5.00 86.02
400 4/22/2007 26.00 59.28
401 10/18/2009 10.00 63.23
402 7/7/2008 30.00 51.89
403 10/5/2009 27.00 73.01
404 8/4/2007 50.00 52.30
405 5/31/2009 30.00 45.66
406 11/23/2007 45.00 77.54
407 5/14/2009 49.00 37.81
408 6/27/2009 18.00 45.25
409 4/1/2008 12.00 50.18
410 5/22/2009 40.00 32.73
411 9/16/2007 22.00 59.43
412 9/18/2009 5.00 46.96
413 9/23/2007 10.00 38.89
414 8/7/2009 23.00 73.95
415 2/3/2008 20.00 51.84
416 12/26/2008 21.00 24.45
417 10/10/2009 4.00 60.91
418 3/6/2009 24.00 36.60
419 11/21/2007 4.00 36.71
420 2/15/2007 34.00 41.95
421 11/16/2008 35.00 58.52
422 10/11/2009 45.00 45.72
423 1/20/2008 28.00 62.55
424 12/28/2007 43.00 48.09
425 4/1/2009 30.00 53.37
426 5/25/2007 42.00 46.27
427 7/23/2007 3.00 64.48
428 3/2/2009 6.00 45.98
429 4/12/2007 29.00 50.74
430 7/7/2009 34.00 26.86
431 11/11/2009 7.00 39.52
432 5/28/2007 9.00 38.67
433 3/13/2007 39.00 40.07
434 2/10/2007 24.00 56.98
435 6/19/2009 49.00 46.19
436 2/5/2009 23.00 31.44
437 3/14/2007 9.00 48.78
438 6/19/2009 7.00 61.19
439 8/9/2008 46.00 60.02
440 11/9/2007 2.00 38.91
441 8/28/2009 9.00 40.50
442 7/30/2009 45.00 52.58
443 3/26/2009 45.00 29.36
444 7/13/2007 47.00 38.12
445 11/10/2009 23.00 41.22
446 4/1/2008 10.00 54.68
447 4/7/2007 13.00 55.91
448 8/12/2009 14.00 84.27
449 4/19/2008 4.00 36.13
450 10/10/2007 3.00 51.18
451 12/24/2008 29.00 58.05
452 12/9/2008 22.00 84.26
453 7/25/2009 31.00 32.63
454 5/23/2008 1.00 42.65
455 7/12/2007 45.00 47.55
456 7/18/2008 47.00 60.40
457 10/5/2009 11.00 60.19
458 8/14/2007 8.00 52.17
459 4/21/2008 8.00 25.95
460 6/26/2008 9.00 77.34
461 5/20/2007 49.00 63.79
462 9/7/2009 38.00 52.73
463 8/4/2009 36.00 63.49
464 4/11/2008 26.00 25.87
465 11/13/2007 8.00 74.48
466 11/8/2007 25.00 62.09
467 2/15/2007 32.00 34.04
468 5/4/2009 18.00 46.34
469 12/30/2007 41.00 40.27
470 3/20/2007 26.00 56.22
471 5/29/2009 42.00 54.92
472 3/28/2008 10.00 56.63
473 12/4/2007 16.00 58.63
474 8/9/2007 22.00 48.27
475 11/16/2008 48.00 58.97
476 5/9/2007 14.00 53.10
477 3/29/2008 30.00 36.32
478 6/19/2008 21.00 50.41
479 10/31/2007 26.00 71.39
480 11/27/2007 22.00 74.30
481 4/13/2008 32.00 60.33
482 2/11/2007 28.00 52.44
483 9/17/2009 27.00 69.80
484 2/8/2009 8.00 48.75
485 1/12/2009 44.00 80.59
486 1/17/2009 36.00 52.31
487 8/6/2008 32.00 54.62
488 1/27/2007 25.00 97.47
489 2/14/2008 37.00 55.42
490 5/21/2007 42.00 27.67
491 2/24/2008 33.00 45.09
492 9/3/2008 17.00 66.87
493 7/4/2007 2.00 52.62
494 8/19/2007 9.00 66.98
495 1/22/2008 40.00 42.29
496 12/14/2007 6.00 78.70
497 10/29/2009 44.00 41.60
498 10/7/2008 6.00 47.58
499 5/13/2009 17.00 26.35
500 4/10/2009 30.00 39.15
501 8/28/2009 13.00 70.56
502 4/22/2008 21.00 53.70
503 4/4/2008 49.00 43.96
504 7/7/2007 18.00 42.39
505 5/20/2007 21.00 62.77
506 6/8/2008 21.00 72.62
507 9/12/2009 43.00 38.42
508 5/9/2009 27.00 94.71
509 10/29/2008 26.00 79.59
510 6/17/2007 29.00 64.41
511 5/19/2007 2.00 40.28
512 12/8/2008 30.00 71.06
513 8/4/2009 46.00 48.56
514 4/28/2008 36.00 43.85
515 6/1/2007 48.00 33.08
516 9/21/2007 2.00 83.44
517 9/13/2007 47.00 52.98
518 5/5/2008 42.00 59.60
519 10/16/2007 23.00 52.76
520 12/10/2008 32.00 24.75
521 1/24/2009 3.00 53.12
522 8/1/2007 34.00 45.39
523 1/15/2008 28.00 42.88
524 8/12/2007 47.00 63.62
525 12/27/2008 46.00 38.79
526 9/13/2008 20.00 55.49
527 3/19/2007 7.00 56.39
528 1/20/2007 38.00 48.70
529 1/13/2009 36.00 75.42
530 5/2/2008 18.00 84.42
531 2/4/2007 14.00 65.59
532 2/24/2008 42.00 84.77
533 5/28/2009 35.00 61.53
534 5/30/2007 10.00 74.76
535 6/28/2007 27.00 64.66
536 1/15/2008 13.00 60.04
537 6/5/2007 17.00 40.48
538 11/13/2008 18.00 45.53
539 8/29/2007 15.00 50.27
540 2/13/2009 48.00 67.18
541 4/30/2008 40.00 73.37
542 3/14/2007 9.00 45.37
543 5/4/2009 28.00 57.36
544 11/23/2008 37.00 62.21
545 2/23/2007 13.00 76.21
546 3/28/2007 43.00 69.96
547 7/27/2009 12.00 50.26
548 12/7/2008 8.00 69.93
549 3/22/2008 48.00 73.05
550 8/25/2007 15.00 91.24
551 6/25/2007 47.00 66.35
552 10/2/2007 39.00 37.57
553 7/7/2009 4.00 54.01
554 7/16/2009 46.00 46.70
555 7/29/2007 12.00 58.32
556 3/22/2007 5.00 73.43
557 8/29/2009 30.00 58.40
558 8/13/2008 47.00 58.24
559 2/1/2009 23.00 32.88
560 10/27/2008 31.00 52.69
561 1/2/2008 29.00 60.61
562 5/10/2008 38.00 44.56
563 2/13/2007 2.00 68.95
564 4/2/2009 25.00 50.55
565 8/4/2009 7.00 28.97
566 9/15/2009 13.00 69.43
567 7/7/2009 28.00 48.92
568 1/12/2009 1.00 38.60
569 4/2/2008 10.00 49.30
570 1/7/2009 16.00 62.00
571 11/13/2008 17.00 85.39
572 2/27/2009 26.00 38.84
573 7/28/2008 36.00 45.60
574 9/2/2008 37.00 41.97
575 8/9/2008 38.00 58.94
576 6/11/2009 6.00 9.76
577 3/6/2008 5.00 67.13
578 10/3/2008 39.00 49.30
579 12/8/2007 8.00 65.15
580 6/5/2009 17.00 42.11
581 10/3/2009 34.00 66.35
582 5/4/2007 49.00 46.57
583 4/4/2007 32.00 55.52
584 5/1/2008 32.00 54.65
585 3/14/2007 49.00 45.36
586 4/14/2009 22.00 48.71
587 11/17/2007 23.00 90.13
588 9/17/2007 35.00 65.08
589 8/6/2009 32.00 62.97
590 11/14/2007 18.00 55.25
591 3/9/2007 19.00 56.67
592 8/7/2007 5.00 45.29
593 3/7/2007 26.00 58.83
594 3/19/2008 22.00 63.46
595 2/26/2009 31.00 61.73
596 6/2/2008 39.00 45.19
597 1/19/2009 9.00 56.88
598 11/23/2007 49.00 65.22
599 3/21/2008 49.00 65.65
600 6/10/2009 46.00 67.52
601 12/31/2007 10.00 45.37
602 6/17/2009 44.00 49.56
603 6/21/2009 24.00 54.86
604 5/24/2007 2.00 59.91
605 11/19/2007 7.00 57.68
606 12/28/2008 42.00 47.05
607 10/14/2008 11.00 44.22
608 2/4/2009 13.00 42.89
609 3/23/2009 6.00 88.32
610 8/9/2009 40.00 72.38
611 4/21/2007 48.00 35.96
612 1/23/2007 9.00 57.51
613 12/15/2007 27.00 66.29
614 9/5/2009 42.00 66.58
615 9/2/2009 48.00 34.13
616 6/28/2009 11.00 35.59
617 4/12/2009 5.00 39.03
618 1/20/2009 27.00 60.81
619 9/24/2008 21.00 76.68
620 8/4/2007 21.00 24.14
621 3/30/2008 13.00 56.92
622 10/31/2008 11.00 47.50
623 6/22/2009 21.00 36.75
624 12/12/2008 40.00 58.38
625 10/25/2007 36.00 60.82
626 9/25/2007 49.00 23.03
627 9/10/2008 24.00 61.50
628 5/28/2008 35.00 65.92
629 11/15/2008 5.00 77.16
630 1/21/2008 44.00 63.16
631 1/27/2009 36.00 37.72
632 12/7/2007 32.00 54.14
633 6/23/2008 35.00 57.03
634 4/30/2008 9.00 57.39
635 2/17/2007 30.00 50.83
636 8/29/2008 2.00 37.45
637 9/15/2009 30.00 53.38
638 3/5/2007 3.00 72.25
639 10/31/2007 19.00 68.51
640 12/23/2008 49.00 54.73
641 8/20/2007 3.00 42.97
642 11/2/2009 41.00 57.29
643 3/27/2008 14.00 44.57
644 6/24/2009 3.00 65.88
645 5/3/2009 33.00 62.73
646 4/26/2007 42.00 46.12
647 9/28/2008 12.00 47.66
648 10/8/2009 37.00 62.75
649 5/10/2009 42.00 36.94
650 8/25/2008 7.00 55.32
651 7/25/2008 36.00 68.07
652 5/30/2009 36.00 63.27
653 4/20/2007 17.00 49.78
654 2/24/2007 7.00 57.08
655 8/19/2009 49.00 48.47
656 7/20/2009 38.00 14.29
657 2/7/2009 30.00 48.26
658 3/10/2007 27.00 68.36
659 6/29/2008 21.00 33.18
660 5/19/2007 2.00 49.87
661 7/8/2009 38.00 33.45
662 7/13/2009 22.00 45.70
663 1/8/2009 26.00 82.96
664 9/1/2008 4.00 68.63
665 6/11/2009 14.00 56.93
666 2/4/2007 42.00 58.36
667 9/1/2009 2.00 26.49
668 6/22/2007 43.00 65.92
669 3/26/2008 18.00 64.22
670 11/8/2009 1.00 65.23
671 7/10/2009 33.00 36.19
672 1/25/2007 21.00 68.42
673 4/25/2007 45.00 68.83
674 1/29/2007 13.00 58.07
675 1/29/2007 5.00 73.67
676 4/3/2008 8.00 73.13
677 4/19/2008 37.00 55.54
678 3/1/2009 50.00 36.98
679 3/16/2007 35.00 52.86
680 6/11/2007 40.00 68.94
681 7/31/2007 41.00 68.69
682 4/27/2008 31.00 43.44
683 5/4/2007 19.00 80.95
684 4/7/2008 42.00 36.25
685 10/29/2007 21.00 55.99
686 12/18/2008 36.00 48.86
687 3/8/2007 24.00 40.64
688 9/8/2008 10.00 70.96
689 3/3/2008 32.00 68.33
690 4/21/2007 38.00 67.45
691 2/6/2007 34.00 31.83
692 7/21/2007 16.00 67.04
693 12/9/2007 41.00 27.71
694 10/22/2007 8.00 56.41
695 12/17/2007 6.00 44.17
696 10/14/2009 19.00 44.70
697 7/30/2008 28.00 43.77
698 9/2/2007 5.00 65.59
699 3/7/2009 23.00 62.21
700 2/17/2008 34.00 92.54
701 7/12/2008 12.00 49.41
702 4/27/2008 19.00 46.76
703 2/13/2009 17.00 45.86
704 9/13/2009 45.00 76.10
705 3/23/2007 37.00 69.43
706 1/10/2008 2.00 39.18
707 6/13/2007 44.00 61.90
708 8/14/2007 20.00 47.24
709 3/27/2007 12.00 49.37
710 10/10/2008 18.00 40.22
711 11/16/2007 24.00 37.34
712 2/17/2009 9.00 67.22
713 10/16/2007 42.00 57.31
714 10/9/2008 47.00 37.93
715 5/31/2009 39.00 58.90
716 1/14/2009 39.00 66.52
717 5/20/2007 34.00 58.00
718 12/9/2007 35.00 46.84
719 6/25/2007 4.00 93.99
720 4/1/2008 31.00 46.43
721 9/9/2008 27.00 79.99
722 4/2/2009 44.00 62.46
723 6/18/2007 45.00 63.35
724 6/6/2009 45.00 30.26
725 1/30/2009 23.00 21.43
726 11/12/2008 29.00 39.45
727 10/3/2008 3.00 45.88
728 2/23/2009 3.00 82.67
729 4/3/2007 23.00 43.03
730 7/18/2009 29.00 52.49
731 12/3/2007 49.00 56.44
732 6/24/2007 20.00 55.49
733 4/11/2009 39.00 53.06
734 3/26/2007 40.00 50.55
735 9/18/2007 30.00 73.33
736 7/27/2008 8.00 48.67
737 2/21/2007 42.00 75.33
738 4/30/2008 31.00 54.80
739 9/27/2008 24.00 37.86
740 3/22/2007 27.00 61.58
741 11/24/2007 10.00 54.95
742 5/1/2007 47.00 68.67
743 12/2/2007 32.00 50.89
744 9/12/2009 50.00 62.89
745 11/19/2008 39.00 47.12
746 4/14/2008 31.00 58.89
747 3/5/2009 39.00 72.20
748 2/28/2009 18.00 58.00
749 8/26/2008 49.00 43.44
750 3/31/2008 35.00 57.59
751 5/11/2007 48.00 58.33
752 11/7/2009 42.00 42.56
753 5/29/2009 7.00 44.53
754 11/29/2008 31.00 44.87
755 4/20/2008 6.00 18.01
756 12/9/2008 46.00 52.91
757 8/25/2008 29.00 50.08
758 2/4/2009 16.00 45.84
759 8/14/2008 43.00 69.45
760 3/25/2007 41.00 83.10
761 8/23/2007 46.00 67.37
762 10/14/2009 30.00 97.34
763 8/30/2009 8.00 61.82
764 4/12/2009 34.00 47.80
765 7/12/2008 9.00 46.61
766 5/26/2007 2.00 53.18
767 5/11/2009 28.00 78.28
768 6/20/2009 4.00 50.08
769 8/25/2007 31.00 50.77
770 11/2/2009 1.00 74.09
771 1/3/2009 6.00 61.98
772 11/19/2007 5.00 76.50
773 7/19/2008 15.00 50.75
774 11/26/2007 45.00 22.63
775 6/19/2007 7.00 63.67
776 6/24/2009 34.00 52.21
777 9/12/2007 38.00 60.78
778 6/15/2008 31.00 30.03
779 4/17/2008 28.00 68.32
780 3/25/2007 8.00 60.36
781 12/9/2007 42.00 47.29
782 4/29/2007 26.00 70.94
783 6/22/2009 9.00 38.15
784 2/2/2009 47.00 47.71
785 11/14/2009 21.00 69.85
786 5/9/2008 13.00 45.39
787 11/14/2009 39.00 69.89
788 12/2/2008 13.00 56.92
789 6/17/2007 36.00 59.94
790 8/20/2009 47.00 58.66
791 9/21/2007 46.00 33.67
792 2/8/2007 37.00 24.52
793 11/9/2009 8.00 75.93
794 10/12/2008 45.00 71.99
795 3/17/2008 44.00 34.79
796 11/4/2009 1.00 61.77
797 6/18/2009 12.00 47.34
798 8/18/2008 40.00 53.14
799 7/31/2009 11.00 68.15
800 4/18/2009 44.00 36.91
801 4/5/2007 32.00 44.64
802 2/6/2009 38.00 61.14
803 10/30/2007 23.00 61.97
804 9/21/2008 17.00 46.46
805 9/10/2009 48.00 59.56
806 9/13/2009 17.00 43.13
807 8/8/2009 41.00 81.59
808 7/16/2008 42.00 59.93
809 8/13/2007 49.00 72.91
810 6/16/2008 24.00 74.20
811 1/30/2007 38.00 49.76
812 10/3/2008 26.00 50.13
813 7/17/2009 20.00 69.84
814 5/14/2007 44.00 50.24
815 12/19/2007 34.00 43.09
816 1/18/2007 16.00 35.21
817 7/25/2007 27.00 56.95
818 3/23/2007 28.00 56.57
819 3/11/2008 37.00 17.62
820 8/20/2007 30.00 43.79
821 7/27/2008 5.00 53.46
822 10/4/2007 9.00 49.39
823 3/13/2009 30.00 57.80
824 9/18/2008 5.00 61.70
825 1/24/2009 21.00 41.40
826 5/14/2007 40.00 55.19
827 7/10/2007 26.00 61.91
828 7/6/2009 32.00 38.99
829 11/17/2008 22.00 34.63
830 10/4/2009 44.00 71.61
831 9/29/2009 24.00 46.80
832 7/24/2007 7.00 52.52
833 3/3/2008 32.00 37.29
834 11/10/2008 45.00 36.56
835 3/6/2009 28.00 50.26
836 2/22/2007 17.00 44.88
837 4/29/2008 10.00 78.81
838 1/27/2008 21.00 51.54
839 11/20/2008 23.00 50.90
840 7/22/2009 24.00 65.07
841 2/1/2007 44.00 77.05
842 12/3/2007 15.00 59.72
843 5/22/2007 22.00 50.35
844 12/4/2008 31.00 53.99
845 7/3/2008 25.00 91.18
846 7/31/2009 30.00 72.49
847 7/18/2008 18.00 69.51
848 5/29/2007 28.00 67.88
849 5/25/2009 41.00 70.42
850 6/29/2008 44.00 78.40
851 6/14/2009 14.00 42.93
852 5/20/2007 21.00 59.35
853 9/2/2008 27.00 62.53
854 5/19/2008 31.00 47.30
855 8/26/2007 3.00 46.91
856 11/3/2008 25.00 45.10
857 11/14/2009 12.00 70.09
858 9/13/2009 7.00 50.44
859 5/1/2007 39.00 44.68
860 10/23/2009 31.00 57.15
861 9/9/2008 48.00 50.40
862 8/14/2008 6.00 63.48
863 6/3/2008 10.00 58.30
864 4/1/2009 29.00 87.34
865 8/24/2007 25.00 47.39
866 6/10/2009 4.00 59.37
867 1/24/2007 43.00 76.81
868 6/22/2007 48.00 58.83
869 6/13/2009 35.00 45.80
870 11/15/2008 18.00 37.64
871 8/5/2008 35.00 62.26
872 3/8/2009 40.00 19.37
873 3/29/2008 48.00 50.04
874 10/16/2009 33.00 63.59
875 9/16/2009 49.00 59.40
876 11/3/2009 18.00 75.80
877 11/15/2007 29.00 34.52
878 6/8/2008 24.00 60.64
879 5/26/2008 48.00 50.89
880 10/31/2007 32.00 54.60
881 9/21/2008 36.00 70.62
882 10/31/2009 5.00 48.74
883 11/8/2009 2.00 31.89
884 10/5/2008 48.00 38.25
885 7/26/2009 30.00 47.76
886 9/5/2009 50.00 64.43
887 4/9/2009 22.00 59.54
888 10/4/2009 41.00 72.64
889 1/21/2009 11.00 68.30
890 11/24/2008 13.00 20.51
891 11/23/2008 40.00 55.19
892 9/1/2007 37.00 27.33
893 4/26/2007 30.00 34.18
894 10/26/2007 16.00 56.64
895 2/27/2007 3.00 47.12
896 7/31/2007 15.00 42.21
897 6/30/2009 14.00 65.48
898 9/25/2008 18.00 57.65
899 7/8/2008 14.00 51.00
900 6/12/2009 43.00 51.15
901 10/18/2008 39.00 61.27
902 5/7/2008 17.00 51.76
903 3/17/2009 9.00 76.53
904 7/20/2009 18.00 51.64
905 4/10/2008 47.00 53.03
906 11/3/2008 36.00 63.19
907 6/12/2007 16.00 64.60
908 1/6/2009 22.00 81.53
909 3/6/2007 41.00 58.79
910 11/30/2008 20.00 54.79
911 9/7/2007 10.00 62.83
912 8/4/2008 38.00 83.39
913 4/28/2008 42.00 48.85
914 5/13/2009 29.00 60.61
915 2/20/2007 6.00 33.48
916 10/15/2007 13.00 54.39
917 7/24/2009 22.00 53.85
918 11/2/2008 5.00 53.87
919 11/3/2008 39.00 48.48
920 9/17/2007 11.00 52.86
921 2/5/2007 6.00 61.16
922 2/23/2007 4.00 78.30
923 4/5/2009 9.00 33.16
924 10/23/2009 30.00 82.72
925 4/15/2008 40.00 45.02
926 12/16/2008 18.00 52.49
927 8/2/2007 36.00 52.82
928 11/15/2009 32.00 46.52
929 9/22/2009 7.00 34.09
930 12/18/2007 22.00 51.31
931 9/25/2007 4.00 65.03
932 3/25/2008 22.00 88.50
933 3/28/2007 25.00 48.89
934 7/3/2007 32.00 71.82
935 6/6/2008 16.00 58.68
936 8/27/2009 44.00 64.69
937 1/20/2008 35.00 31.44
938 12/1/2008 6.00 39.83
939 11/24/2009 32.00 47.95
940 1/7/2008 19.00 39.10
941 3/16/2008 48.00 40.55
942 4/5/2009 12.00 65.91
943 7/3/2009 31.00 83.04
944 9/9/2009 21.00 70.79
945 12/2/2008 48.00 65.24
946 7/11/2008 12.00 67.93
947 3/9/2009 48.00 61.80
948 5/22/2007 5.00 60.88
949 3/14/2009 42.00 53.34
950 10/24/2007 31.00 71.27
951 11/10/2009 2.00 59.78
952 4/23/2007 6.00 59.52
953 2/22/2008 45.00 59.15
954 1/27/2007 2.00 64.80
955 11/11/2009 40.00 53.97
956 10/6/2009 30.00 28.93
957 10/6/2008 35.00 36.11
958 10/19/2009 8.00 93.15
959 7/19/2008 36.00 52.46
960 10/23/2008 12.00 44.74
961 1/5/2008 23.00 56.58
962 10/16/2008 25.00 57.68
963 1/14/2009 45.00 71.37
964 10/10/2008 43.00 89.99
965 11/16/2007 22.00 62.27
966 3/25/2009 28.00 58.99
967 10/20/2009 28.00 58.72
968 3/18/2008 26.00 57.40
969 4/7/2009 13.00 65.33
970 7/27/2008 3.00 60.91
971 10/10/2007 32.00 69.52
972 7/28/2009 21.00 46.52
973 3/29/2009 24.00 58.09
974 8/8/2009 45.00 48.78
975 6/11/2008 37.00 68.95
976 12/26/2007 19.00 55.92
977 2/26/2009 3.00 41.20
978 3/20/2009 27.00 67.20
979 3/1/2008 25.00 41.67
980 10/16/2008 3.00 74.52
981 5/27/2008 18.00 64.14
982 7/23/2007 21.00 67.21
983 4/14/2007 1.00 35.49
984 2/18/2007 13.00 71.37
985 7/12/2008 34.00 56.58
986 11/22/2008 5.00 26.23
987 12/3/2007 6.00 38.42
988 12/19/2007 43.00 43.06
989 2/24/2008 3.00 16.30
990 2/3/2007 31.00 49.96
991 12/25/2008 25.00 35.41
992 4/19/2008 50.00 70.97
993 9/24/2007 36.00 31.48
994 8/4/2007 12.00 57.43
995 9/6/2009 44.00 55.72
996 7/30/2008 8.00 47.70
997 6/11/2007 48.00 43.83
998 9/6/2009 19.00 45.91
999 4/30/2008 9.00 43.84
1000 6/3/2009 29.00 43.70

Sheet 4: Stopy procentowe
































realna stopa procentowa




Podstawową stopą procentową na rynku finansowym jest WIBOR. Dane można pozyskać ze strony www.money.pl.
















Poniżej wklejone zostały dane WIBOR 3M dla okresu 2008-2010. Dodatkowo wklejona została stopa inflacji z GUS.




























































Zadanie Wykorzystaj funkcje wbudowane, żeby przekształić daty to formati "rok-miesiąc", zarówno dla inflacji, jak i WIBOR.













Wykorzystaj tabelę przestawną, żeby zagregować dane
















Porównaj na wykresie obie stopy procentowe. Wyznacz realną stopę procentową





































































Rok Miesiąc Stopa inflacji
Data WIBOR





2008  1  104,0
2010.02.12 4.17





2008  2 104,2
2010.02.11 4.17





2008  3 104,1
2010.02.10 4.17





2008  4 104,0
2010.02.09 4.19











2008  5 104,4
2010.02.08 4.19











2008  6 104,6
2010.02.05 4.2











2008  7 104,8
2010.02.04 4.2


Przekształcanie daty







2008  8 104,8
2010.02.03 4.2


2010.02.12







2008  9 104,5
2010.02.02 4.2











2008  10 104,2
2010.02.01 4.2


2010







2008  11 103,7
2010.01.29 4.19


02







2008  12 103,3
2010.01.28 4.2











2009 1  102,8
2010.01.27 4.2


2010-02







2009 2  103,3
2010.01.26 4.22











2009 3  103,6
2010.01.25 4.22











2009 4  104,0
2010.01.22 4.22











2009 5  103,6
2010.01.21 4.22











2009 6  103,5
2010.01.20 4.22











2009 7  103,6
2010.01.19 4.23











2009 8  103,7
2010.01.18 4.24











2009 9  103,4
2010.01.15 4.25











2009 10  103,1
2010.01.14 4.26











2009 11  103,3
2010.01.13 4.25











2009 12  103,5
2010.01.12 4.26











2010 1  103,5
2010.01.11 4.27











2010 2  102,9
2010.01.08 4.26















2010.01.07 4.25















2010.01.06 4.25















2010.01.05 4.26















2010.01.04 4.27















2009.12.31 4.27















2009.12.30 4.27















2009.12.29 4.26















2009.12.28 4.26















2009.12.24 4.27















2009.12.23 4.26















2009.12.22 4.26















2009.12.21 4.25















2009.12.18 4.24















2009.12.17 4.25















2009.12.16 4.25















2009.12.15 4.23















2009.12.14 4.23















2009.12.11 4.22















2009.12.10 4.21















2009.12.09 4.2















2009.12.08 4.2















2009.12.07 4.2















2009.12.04 4.2















2009.12.03 4.2















2009.12.02 4.19















2009.12.02 4.19















2009.12.01 4.19















2009.11.30 4.19















2009.11.27 4.19















2009.11.26 4.2















2009.11.25 4.19















2009.11.24 4.19















2009.11.23 4.19















2009.11.20 4.19















2009.11.19 4.19















2009.11.18 4.19















2009.11.17 4.19















2009.11.16 4.2















2009.11.13 4.19















2009.11.10 4.19















2009.11.09 4.19















2009.11.06 4.19















2009.11.05 4.19















2009.11.04 4.19















2009.11.03 4.19















2009.11.02 4.19















2009.10.30 4.18















2009.10.29 4.18















2009.10.28 4.18















2009.10.27 4.18















2009.10.26 4.18















2009.10.23 4.18















2009.10.22 4.18















2009.10.21 4.18















2009.10.20 4.18















2009.10.19 4.18















2009.10.16 4.19















2009.10.15 4.19















2009.10.14 4.19















2009.10.13 4.19















2009.10.12 4.19















2009.10.09 4.19















2009.10.08 4.18















2009.10.07 4.18















2009.10.06 4.18















2009.10.05 4.19















2009.10.02 4.19















2009.10.01 4.18















2009.09.30 4.18















2009.09.29 4.18















2009.09.28 4.18















2009.09.25 4.16















2009.09.24 4.18















2009.09.23 4.18















2009.09.22 4.17















2009.09.21 4.17















2009.09.21 4.17















2009.09.18 4.18















2009.09.17 4.19















2009.09.16 4.2















2009.09.15 4.18















2009.09.14 4.18















2009.09.11 4.18















2009.09.10 4.18















2009.09.09 4.18















2009.09.08 4.16















2009.09.07 4.17















2009.09.04 4.18















2009.09.03 4.17















2009.09.02 4.17















2009.09.01 4.18















2009.08.31 4.18















2009.08.28 4.17















2009.08.27 4.16















2009.08.26 4.17















2009.08.25 4.16















2009.08.24 4.15















2009.08.21 4.16















2009.08.20 4.16















2009.08.19 4.16















2009.08.18 4.16















2009.08.17 4.16















2009.08.14 4.16















2009.08.13 4.15















2009.08.12 4.15















2009.08.11 4.15















2009.08.10 4.15















2009.08.07 4.15















2009.08.06 4.16















2009.08.05 4.16















2009.08.04 4.16















2009.08.03 4.16















2009.07.31 4.17















2009.07.30 4.17















2009.07.29 4.16















2009.07.28 4.17















2009.07.27 4.17















2009.07.24 4.18















2009.07.23 4.17















2009.07.22 4.18















2009.07.21 4.2















2009.07.20 4.21















2009.07.17 4.22















2009.07.16 4.24















2009.07.15 4.27















2009.07.14 4.29















2009.07.13 4.29















2009.07.13 4.29















2009.07.10 4.29















2009.07.09 4.31















2009.07.07 4.33















2009.07.06 4.36















2009.07.03 4.38















2009.07.02 4.41















2009.07.01 4.43















2009.06.30 4.44















2009.06.29 4.45















2009.06.26 4.47















2009.06.25 4.48















2009.06.24 4.62















2009.06.23 4.63















2009.06.22 4.64















2009.06.17 4.62















2009.06.16 4.62















2009.06.15 4.63















2009.06.12 4.63















2009.06.10 4.62















2009.06.09 4.64















2009.06.08 4.63















2009.06.05 4.63















2009.06.04 4.63















2009.06.03 4.64















2009.06.02 4.63















2009.06.01 4.62















2009.05.29 4.62















2009.05.28 4.64















2009.05.27 4.62















2009.05.26 4.61















2009.05.25 4.59















2009.05.22 4.58















2009.05.21 4.57















2009.05.20 4.56















2009.05.19 4.55















2009.05.18 4.53















2009.05.14 4.52















2009.05.13 4.49















2009.05.12 4.47















2009.05.11 4.46















2009.05.08 4.45















2009.05.07 4.43















2009.05.06 4.42















2009.05.05 4.38















2009.05.04 4.32















2009.04.30 4.3















2009.04.29 4.29















2009.04.28 4.28















2009.04.27 4.27















2009.04.24 4.26















2009.04.24 4.26















2009.04.23 4.24















2009.04.22 4.24















2009.04.21 4.23















2009.04.20 4.22















2009.04.17 4.22















2009.04.16 4.21















2009.04.15 4.19















2009.04.14 4.16















2009.04.10 4.15















2009.04.09 4.14















2009.04.08 4.14















2009.04.07 4.14















2009.04.06 4.14















2009.04.03 4.16















2009.04.02 4.16















2009.04.01 4.16















2009.03.31 4.17















2009.03.30 4.14















2009.03.27 4.14















2009.03.26 4.14















2009.03.25 4.21















2009.03.24 4.23















2009.03.23 4.26















2009.03.20 4.27















2009.03.19 4.26















2009.03.18 4.27















2009.03.17 4.28















2009.03.16 4.3















2009.03.13 4.33















2009.03.12 4.33















2009.03.11 4.35















2009.03.10 4.37















2009.03.09 4.37















2009.03.06 4.38















2009.03.05 4.4















2009.03.04 4.44















2009.03.03 4.46















2009.03.02 4.48















2009.02.27 4.51















2009.02.26 4.53















2009.02.25 4.6















2009.02.24 4.63















2009.02.23 4.68















2009.02.20 4.69















2009.02.19 4.7















2009.02.18 4.7















2009.02.17 4.7















2009.02.16 4.69















2009.02.13 4.69















2009.02.12 4.68















2009.02.12 4.68















2009.02.11 4.7















2009.02.10 4.71















2009.02.09 4.72















2009.02.06 4.74















2009.02.05 4.74















2009.02.04 4.76















2009.02.03 4.78















2009.02.02 4.8















2009.01.30 4.86















2009.01.29 4.88















2009.01.28 4.93















2009.01.27 5.15















2009.01.26 5.31















2009.01.23 5.36















2009.01.22 5.43















2009.01.21 5.51















2009.01.20 5.55















2009.01.19 5.56















2009.01.16 5.57















2009.01.15 5.63















2009.01.14 5.65















2009.01.13 5.68















2009.01.12 5.72















2009.01.09 5.76















2009.01.08 5.77















2009.01.07 5.81















2009.01.06 5.82















2009.01.05 5.84















2009.01.02 5.84















2008.12.31 5.88















2008.12.30 5.86















2008.12.29 5.9















2008.12.24 5.92















2008.12.23 6.41















2008.12.22 6.44















2008.12.19 6.45















2008.12.18 6.46















2008.12.17 6.48















2008.12.16 6.48















2008.12.15 6.49















2008.12.12 6.49















2008.12.11 6.48















2008.12.10 6.48















2008.12.09 6.48















2008.12.08 6.53















2008.12.05 6.54















2008.12.04 6.54















2008.12.03 6.55















2008.12.02 6.54















2008.12.01 6.55















2008.12.01 6.55















2008.11.28 6.56















2008.11.27 6.56















2008.11.26 6.63















2008.11.25 6.69















2008.11.24 6.69















2008.11.21 6.71















2008.11.20 6.72















2008.11.19 6.72















2008.11.18 6.71















2008.11.17 6.73















2008.11.14 6.76















2008.11.13 6.77















2008.11.12 6.79















2008.11.10 6.82















2008.11.07 6.83















2008.11.06 6.83















2008.11.05 6.84















2008.11.04 6.85















2008.11.03 6.84















2008.10.31 6.85















2008.10.30 6.86















2008.10.29 6.86















2008.10.28 6.85















2008.10.27 6.86















2008.10.24 6.87















2008.10.23 6.85















2008.10.22 6.81















2008.10.21 6.81















2008.10.20 6.8















2008.10.17 6.82















2008.10.16 6.81















2008.10.15 6.8















2008.10.14 6.8















2008.10.13 6.81















2008.10.10 6.82















2008.10.09 6.8















2008.10.08 6.75















2008.10.07 6.74















2008.10.06 6.72















2008.10.03 6.7















2008.10.02 6.67















2008.10.01 6.67















2008.09.30 6.63















2008.09.29 6.59















2008.09.26 6.59















2008.09.25 6.59















2008.09.24 6.59















2008.09.23 6.59















2008.09.22 6.59















2008.09.19 6.61















2008.09.19 6.61















2008.09.18 6.62















2008.09.17 6.6















2008.09.16 6.59















2008.09.15 6.54















2008.09.12 6.54















2008.09.11 6.53















2008.09.10 6.52















2008.09.09 6.51















2008.09.08 6.51















2008.09.05 6.52















2008.09.04 6.51















2008.09.03 6.5















2008.09.02 6.51















2008.09.01 6.5















2008.08.29 6.5















2008.08.28 6.49















2008.08.27 6.46















2008.08.26 6.47















2008.08.25 6.46















2008.08.22 6.49















2008.08.21 6.5















2008.08.20 6.54















2008.08.19 6.54















2008.08.18 6.53















2008.08.14 6.53















2008.08.11 6.54















2008.08.08 6.54















2008.08.06 6.54















2008.08.05 6.55















2008.08.04 6.55















2008.08.01 6.55















2008.07.31 6.56















2008.07.30 6.56















2008.07.29 6.57















2008.07.28 6.59















2008.07.25 6.58















2008.07.24 6.58















2008.07.23 6.61















2008.07.22 6.61















2008.07.21 6.61















2008.07.18 6.61















2008.07.17 6.61















2008.07.16 6.6















2008.07.15 6.61















2008.07.14 6.65















2008.07.11 6.64















2008.07.10 6.65















2008.07.09 6.65















2008.07.08 6.66















2008.07.07 6.66















2008.07.07 6.66















2008.07.04 6.66















2008.07.03 6.66















2008.07.02 6.67















2008.07.01 6.66















2008.06.30 6.65















2008.06.27 6.64















2008.06.26 6.63















2008.06.25 6.6















2008.06.24 6.59















2008.06.23 6.58















2008.06.20 6.58















2008.06.19 6.57















2008.06.18 6.58















2008.06.17 6.57















2008.06.16 6.58















2008.06.13 6.58















2008.06.12 6.59















2008.06.11 6.58















2008.06.10 6.57















2008.06.09 6.57















2008.06.06 6.57















2008.06.05 6.53















2008.06.04 6.51















2008.06.03 6.51















2008.06.02 6.51















2008.05.30 6.48















2008.05.29 6.47















2008.05.27 6.47















2008.05.26 6.47















2008.05.23 6.45















2008.05.21 6.44















2008.05.20 6.43















2008.05.19 6.4















2008.05.16 6.41















2008.05.15 6.41















2008.05.14 6.41















2008.05.13 6.4















2008.05.12 6.4















2008.05.09 6.4















2008.05.08 6.39















2008.05.07 6.39















2008.05.06 6.33















2008.05.05 6.33















2008.04.30 6.34















2008.04.28 6.31















2008.04.25 6.32















2008.04.24 6.32















2008.04.23 6.32















2008.04.22 6.31















2008.04.21 6.3















2008.04.21 6.3















2008.04.18 6.31















2008.04.17 6.32















2008.04.16 6.28















2008.04.15 6.3















2008.04.14 6.3















2008.04.11 6.31















2008.04.10 6.31















2008.04.09 6.31















2008.04.08 6.28















2008.04.07 6.27















2008.04.04 6.27















2008.04.03 6.23















2008.04.02 6.2















2008.04.01 6.18















2008.03.31 6.15















2008.03.28 6.14















2008.03.27 6.06















2008.03.26 6.06















2008.03.25 6.05















2008.03.24 6.05















2008.03.21 6.05















2008.03.20 6.04















2008.03.19 6.04















2008.03.18 6.03















2008.03.17 6.03















2008.03.14 6.01















2008.03.13 6.03















2008.03.12 6.01















2008.03.11 5.99















2008.03.10 6















2008.03.07 5.99















2008.03.06 5.95















2008.03.05 5.95















2008.03.04 5.95















2008.03.03 5.93















2008.02.29 5.94















2008.02.28 5.92















2008.02.27 5.85















2008.02.26 5.85















2008.02.23 5.83















2008.02.22 5.83















2008.02.21 5.83















2008.02.20 5.8















2008.02.19 5.77















2008.02.18 5.71















2008.02.15 5.67















2008.02.14 5.67















2008.02.13 5.67















2008.02.12 5.67















2008.02.11 5.67















2008.02.11 5.67















2008.02.08 5.66















2008.02.07 5.66















2008.02.06 5.65















2008.02.05 5.65















2008.02.04 5.65















2008.02.01 5.65















2008.01.31 5.65















2008.01.30 5.63















2008.01.29 5.64















2008.01.28 5.63















2008.01.25 5.64















2008.01.24 5.65















2008.01.23 5.65















2008.01.22 5.66















2008.01.21 5.66















2008.01.18 5.65















2008.01.17 5.65















2008.01.16 5.65















2008.01.15 5.65















2008.01.14 5.65















2008.01.11 5.65















2008.01.10 5.66















2008.01.09 5.65















2008.01.08 5.64















2008.01.07 5.64















2008.01.04 5.62















2008.01.03 5.62















2008.01.02 5.6












Sheet 5: Zwroty

Pobierz ze strony www.parkiet.com dane dotyczące kursów walutowych: EURO, CHF, GBP, USD. Połącz notowania datami korzystajac z komendy WYSZUKAJ.PIONOWO. Narysuj na wspólnym wykresie średnie kursy miesięczne - dodaj korytarz odchylenia standarowego miesięcznego.















Data dzienna EURO CHF GBP USD






















































































Sheet 6: daty









Klient w banku dnia 20.03.2010 zakłada lokatę 5000 zł na 4 miesiące oprocentowaną na 5% w skali roku






a) wprowadź datę w formacie Excela - wykorzystaj komednę DATA()






b) wyznacz datę likwidacji lokaty - wykorzystaj funkcję EDATE()






c) sprawdź, ile dni jest między tymi datami - wykorzystaj funkcję DNI.360()






d) sprawdź, jaka to część roku - wykorzystaj komendę YEARFRAC()






e) wypisz w osobnych komórkach rok, miesiąc i dzień zakończenia lokaty - wykorzystaj funkcje ROK(), MIESIĄC(), DZIEŃ()






f) nalicz odsetki w sposób prosty, oblicz podatek uwzględniając zaokrąglenia, podaj kwotę do wypłaty.






g) sprawdź, ile dni minęło od momentu rozpoczęcia lokaty do dziś - wykorzystaj funkcję DZIŚ()






h) dla daty rozpoczęcia i zakończenia sprawdź, jakie to dni tygodnia - wykorzystaj funkcję DZIEŃ.TYG()






Całość ma wyglądać jak kalkulator finansowy :-)














Informacje o depozycie

Rozliczenie depozytu



Depozyt

depozyt + odsetki BT

data dziś
Oprocentowanie

podstawa opodatkowania



Długość (mies)

podatek






depozyt + odsetki AT











Rozpoczęcie depozytu

Zakończenie depozytu

Trwanie depozytu
Dzień

Dzień

Ile dni między datami
Miesiąc

Miesiąc

Część roku
Rok

Rok

Ile dni do dziś








Data rozpoczęcia

Data zakończenia











Dzień tygodnia

Dzień tygodnia




Wyszukiwarka

Podobne podstrony:
Excel zarządzanie 03 Analiza klientów i daty ROZW
Kopia Excel zarządzanie 03 Analiza klientów i daty
Excel zarządzanie 03 Analiza klientów i daty
Excel zarzadzanie 05 Analiza taksonomiczna id 166577
Excel zarządzanie 05 Analiza taksonomiczna
Analiza klientów WYKŁAD 4, ZARZĄDZANIE, marketing, ćwiczenia
Analiza klientów. wykład 2, ZARZĄDZANIE, marketing, ćwiczenia
03. Analiza strategiczna zaj3 fol, Zarzadzanie Projektami
Excel zarządzanie 06 rozw zad 2 2
Kopia Excel zarządzanie 06 rozw zad 2
Excel zarządzanie 06 rozw zad 2
Excel zarządzanie 04 Zapasy ROZW
zarzadzanie strategiczne analiza swot
Koncepcje zarządzania$ 03 2012
Lab 03 Analiza obwodu elektrycz Nieznany
BOS2 (3), Materiały AGH- zarządzanie finansami, analiza i controling
Metody organizacji i zarządzania, BCG, Analiza i projektowanie portfela produkcji za pomocą macierzy

więcej podobnych podstron