Greg's Project Cleanv4.xlsx

	B	C	D	E	F	G	H	I
1
2
3	Month Year Order	Month Year String	Count of DateFirstPurchase	90 Day Counter by Customer	measure 3	% 90 Day	Following 3 Months Counter by Customer	% Following 3 Months
4	200107	Jul 01	146
5	200108	Aug 01	156
6	200109	Sep 01	146
7	200110	Oct 01	161
8	200111	Nov 01	169
9	200112	Dec 01	235
10	200201	Jan 02	188
11	200202	Feb 02	171
12	200203	Mar 02	199
13	200204	Apr 02	207
14	200205	May 02	214
15	200206	Jun 02	214
16	200207	Jul 02	253
17	200208	Aug 02	281
18	200209	Sep 02	198
19	200210	Oct 02	229
20	200211	Nov 02	193
21	200212	Dec 02	330
22	200301	Jan 03	244
23	200302	Feb 03	272
24	200303	Mar 03	272
25	200304	Apr 03	294	4	4	1.36%	12	4.08%
26	200305	May 03	335	16	16	4.78%	19	5.67%
27	200306	Jun 03	321	27	28	8.41%	36	11.21%
28	200307	Jul 03	202				2	0.99%
29	200308	Aug 03	1210	157	160	12.98%	153	12.64%
30	200309	Sep 03	1112	111	111	9.98%	109	9.80%
31	200310	Oct 03	1132	94	94	8.30%	93	8.22%
32	200311	Nov 03	1094	97	97	8.87%	103	9.41%
33	200312	Dec 03	1210	88	88	7.27%	92	7.60%
34	200401	Jan 04	1039	84	84	8.08%	75	7.22%
35	200402	Feb 04	1013	79	80	7.80%	77	7.60%
36	200403	Mar 04	1056	63	63	5.97%	69	6.53%
37	200404	Apr 04	1088	59	59	5.42%	65	5.97%
38	200405	May 04	1190	64	64	5.38%	56	4.71%
39	200406	Jun 04	1144	26	26	2.27%	18	1.57%
40	200407	Jul 04	566	9	9	1.59%
41	Grand Total		18484	978	983	5.29%	979	5.30%
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100