Spreadsheet: 157196d1337649405-conditional-formatting-copy-of-kyn-fy13
Sheet: 3rd QTR FY13

 | Put New Business in under the month it actually installs
 | December |  |  |  |  |  |  |  | January |  |  |  |  |  |  |  |  | February
 | Account Name | national | garments | chemical | paper | F/S (non paper Chemical) | Total Volume |  |  | Account Name | national | garments | chemical | paper | F/S (non paper Chemical) | Total Volume |  |  | Account Name | national | garments | chemical | paper | F/S (non paper Chemical) | Total Volume
1 |  | n |  |  |  |  |  |  | 1 |  | n |  |  |  |  |  |  | 1 |  | n
2 |  | n |  |  |  |  |  |  | 2 |  | n |  |  |  |  |  |  | 2 |  | n
3 |  | n |  |  |  |  |  |  | 3 |  | n |  |  |  |  |  |  | 3 |  | n
4 |  | n |  |  |  |  |  |  | 4 |  | n |  |  |  |  |  |  | 4 |  | n
5 |  | n |  |  |  |  |  |  | 5 |  | n |  |  |  |  |  |  | 5 |  | n
6 |  | n |  |  |  |  |  |  | 6 |  | n |  |  |  |  |  |  | 6 |  | n
7 |  | n |  |  |  |  |  |  | 7 |  | n |  |  |  |  |  |  | 7 |  | n
8 |  | n |  |  |  |  |  |  | 8 |  | n |  |  |  |  |  |  | 8 |  | n
9 |  | n |  |  |  |  |  |  | 9 |  | n |  |  |  |  |  |  | 9 |  | n
10 |  | n |  |  |  |  |  |  | 10 |  | n |  |  |  |  |  |  | 10 |  | n
11 |  | n |  |  |  |  |  |  | 11 |  | n |  |  |  |  |  |  | 11 |  | n
12 |  | n |  |  |  |  |  |  | 12 |  | n |  |  |  |  |  |  | 12 |  | n
13 |  | n |  |  |  |  |  |  | 13 |  | n |  |  |  |  |  |  | 13 |  | n
14 |  | n |  |  |  |  |  |  | 14 |  | n |  |  |  |  |  |  | 14 |  | n
15 |  | n |  |  |  |  |  |  | 15 |  | n |  |  |  |  |  |  | 15 |  | n
16 |  | n |  |  |  |  |  |  | 16 |  | n |  |  |  |  |  |  | 16 |  | n
17 |  | n |  |  |  |  |  |  | 17 |  | n |  |  |  |  |  |  | 17 |  | n
18 |  | n |  |  |  |  |  |  | 18 |  | n |  |  |  |  |  |  | 18 |  | n
19 |  | n |  |  |  |  |  |  | 19 |  | n |  |  |  |  |  |  | 19 |  | n
20 |  | n |  |  |  |  |  |  | 20 |  | n |  |  |  |  |  |  | 20 |  | n
21 |  | n |  |  |  |  |  |  | 21 |  | n |  |  |  |  |  |  | 21 |  | n
22 |  | n |  |  |  |  |  |  | 22 |  | n |  |  |  |  |  |  | 22 |  | n
23 |  | n |  |  |  |  |  |  | 23 |  | n |  |  |  |  |  |  | 23 |  | n
24 |  | n |  |  |  |  |  |  | 24 |  | n |  |  |  |  |  |  | 24 |  | n
25 |  | n |  |  |  |  |  |  | 25 |  | n |  |  |  |  |  |  | 25 |  | n
26 |  | n |  |  |  |  |  |  | 26 |  | n |  |  |  |  |  |  | 26 |  | n
27 |  | n |  |  |  |  |  |  | 27 |  | n |  |  |  |  |  |  | 27 |  | n
28 |  | n |  |  |  |  |  |  | 28 |  | n |  |  |  |  |  |  | 28 |  | n
29 |  | n |  |  |  |  |  |  | 29 |  | n |  |  |  |  |  |  | 29 |  | n
30 |  | n |  |  |  |  |  |  | 30 |  | n |  |  |  |  |  |  | 30 |  | n
31 |  | n |  |  |  |  |  |  | 31 |  | n |  |  |  |  |  |  | 31 |  | n
32 |  | n |  |  |  |  |  |  | 32 |  | n |  |  |  |  |  |  | 32 |  | n
33 |  | n |  |  |  |  |  |  | 33 |  | n |  |  |  |  |  |  | 33 |  | n
34 |  | n |  |  |  |  |  |  | 34 |  | n |  |  |  |  |  |  | 34 |  | n
35 |  | n |  |  |  |  |  |  | 35 |  | n |  |  |  |  |  |  | 35 |  | n
36 |  | n |  |  |  |  |  |  | 36 |  | n |  |  |  |  |  |  | 36 |  | n
37 |  | n |  |  |  |  |  |  | 37 |  | n |  |  |  |  |  |  | 37 |  | n
38 |  | n |  |  |  |  |  |  | 38 |  | n |  |  |  |  |  |  | 38 |  | n
39 |  | n |  |  |  |  |  |  | 39 |  | n |  |  |  |  |  |  | 39 |  | n
40 |  | n |  |  |  |  |  |  | 40 |  | n |  |  |  |  |  |  | 40 |  | n
41 |  | n |  |  |  |  |  |  | 41 |  | n |  |  |  |  |  |  | 41 |  | n
42 |  | n |  |  |  |  |  |  | 42 |  | n |  |  |  |  |  |  | 42 |  | n
43 |  | n |  |  |  |  |  |  | 43 |  | n |  |  |  |  |  |  | 43 |  | n
44 |  | n |  |  |  |  |  |  | 44 |  | n |  |  |  |  |  |  | 44 |  | n
45 |  | n |  |  |  |  |  |  | 45 |  | n |  |  |  |  |  |  | 45 |  | n
46 |  | n |  |  |  |  |  |  | 46 |  | n |  |  |  |  |  |  | 46 |  | n
47 |  | n |  |  |  |  |  |  | 47 |  | n |  |  |  |  |  |  | 47 |  | n
48 |  | n |  |  |  |  |  |  | 48 |  | n |  |  |  |  |  |  | 48 |  | n
49 |  | n |  |  |  |  |  |  | 49 |  | n |  |  |  |  |  |  | 49 |  | n
50 |  | n |  |  |  |  |  |  | 50 |  | n |  |  |  |  |  |  | 50 |  | n
51 |  | n |  |  |  |  |  |  | 51 |  | n |  |  |  |  |  |  | 51 |  | n
52 |  | n |  |  |  |  |  |  | 52 |  | n |  |  |  |  |  |  | 52 |  | n
53 |  | n |  |  |  |  |  |  | 53 |  | n |  |  |  |  |  |  | 53 |  | n
54 |  | n |  |  |  |  |  |  | 54 |  | n |  |  |  |  |  |  | 54 |  | n
55 |  | n |  |  |  |  |  |  | 55 |  | n |  |  |  |  |  |  | 55 |  | n
56 |  | n |  |  |  |  |  |  | 56 |  | n |  |  |  |  |  |  | 56 |  | n
57 |  | n |  |  |  |  |  |  | 57 |  | n |  |  |  |  |  |  | 57 |  | n
58 |  | n |  |  |  |  |  |  | 58 |  | n |  |  |  |  |  |  | 58 |  | n
59 |  | n |  |  |  |  |  |  | 59 |  | n |  |  |  |  |  |  | 59 |  | n
60 |  | n |  |  |  |  |  |  | 60 |  | n |  |  |  |  |  |  | 60 |  | n
61 |  | n |  |  |  |  |  |  | 61 |  | n |  |  |  |  |  |  | 61 |  | n
62 |  | n |  |  |  |  |  |  | 62 |  | n |  |  |  |  |  |  | 62 |  | n
63 |  | n |  |  |  |  |  |  | 63 |  | n |  |  |  |  |  |  | 63 |  | n
64 |  | n |  |  |  |  |  |  | 64 |  | n |  |  |  |  |  |  | 64 |  | n
65 |  | n |  |  |  |  |  |  | 65 |  | n |  |  |  |  |  |  | 65 |  | n
66 |  | n |  |  |  |  |  |  | 66 |  | n |  |  |  |  |  |  | 66 |  | n
67 |  | n |  |  |  |  |  |  | 67 |  | n |  |  |  |  |  |  | 67 |  | n
68 |  | n |  |  |  |  |  |  | 68 |  | n |  |  |  |  |  |  | 68 |  | n
69 |  | n |  |  |  |  |  |  | 69 |  | n |  |  |  |  |  |  | 69 |  | n
70 |  | n |  |  |  |  |  |  | 70 |  | n |  |  |  |  |  |  | 70 |  | n
71 |  | n |  |  |  |  |  |  | 71 |  | n |  |  |  |  |  |  | 71 |  | n
72 |  | n |  |  |  |  |  |  | 72 |  | n |  |  |  |  |  |  | 72 |  | n
73 |  | n |  |  |  |  |  |  | 73 |  | n |  |  |  |  |  |  | 73 |  | n
74 |  | n |  |  |  |  |  |  | 74 |  | n |  |  |  |  |  |  | 74 |  | n
75 |  | n |  |  |  |  |  |  | 75 |  | n |  |  |  |  |  |  | 75 |  | n
76 |  | n |  |  |  |  |  |  | 76 |  | n |  |  |  |  |  |  | 76 |  | n
77 |  | n |  |  |  |  |  |  | 77 |  | n |  |  |  |  |  |  | 77 |  | n
78 |  | n |  |  |  |  |  |  | 78 |  | n |  |  |  |  |  |  | 78 |  | n
79 |  | n |  |  |  |  |  |  | 79 |  | n |  |  |  |  |  |  | 79 |  | n
80 |  | n |  |  |  |  |  |  | 80 |  | n |  |  |  |  |  |  | 80 |  | n
81 |  | n |  |  |  |  |  |  | 81 |  | n |  |  |  |  |  |  | 81 |  | n
82 |  | n |  |  |  |  |  |  | 82 |  | n |  |  |  |  |  |  | 82 |  | n
83 |  | n |  |  |  |  |  |  | 83 |  | n |  |  |  |  |  |  | 83 |  | n
84 |  | n |  |  |  |  |  |  | 84 |  | n |  |  |  |  |  |  | 84 |  | n
85 |  | n |  |  |  |  |  |  | 85 |  | n |  |  |  |  |  |  | 85 |  | n
86 |  | n |  |  |  |  |  |  | 86 |  | n |  |  |  |  |  |  | 86 |  | n
87 |  | n |  |  |  |  |  |  | 87 |  | n |  |  |  |  |  |  | 87 |  | n
88 |  | n |  |  |  |  |  |  | 88 |  | n |  |  |  |  |  |  | 88 |  | n
89 |  | n |  |  |  |  |  |  | 89 |  | n |  |  |  |  |  |  | 89 |  | n
90 |  | n |  |  |  |  |  |  | 90 |  | n |  |  |  |  |  |  | 90 |  | n
91 |  | n |  |  |  |  |  |  | 91 |  | n |  |  |  |  |  |  | 91 |  | n
92 |  | n |  |  |  |  |  |  | 92 |  | n |  |  |  |  |  |  | 92 |  | n
93 |  | n |  |  |  |  |  |  | 93 |  | n |  |  |  |  |  |  | 93 |  | n
94 |  | n |  |  |  |  |  |  | 94 |  | n |  |  |  |  |  |  | 94 |  | n
95 |  | n |  |  |  |  |  |  | 95 |  | n |  |  |  |  |  |  | 95 |  | n
96 |  | n |  |  |  |  |  |  | 96 |  | n |  |  |  |  |  |  | 96 |  | n
97 |  | n |  |  |  |  |  |  | 97 |  | n |  |  |  |  |  |  | 97 |  | n
98 |  | n |  |  |  |  |  |  | 98 |  | n |  |  |  |  |  |  | 98 |  | n
99 |  | n |  |  |  |  |  |  | 99 |  | n |  |  |  |  |  |  | 99 |  | n
100 |  | n |  |  |  |  |  |  | 100 |  | n |  |  |  |  |  |  | 100 |  | n
 | National Accounts
 | Total |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  | Total
 | Put accounts in the tentative month that they will close
 | Prospective Sales | Competitor | Est. Volume | X-Date | Last Contact |  |  |  |  | Prospective Sales | Competitor | Est. Volume | X-Date | Last Contact |  |  |  |  | Prospective Sales | Competitor | Est. Volume | X-Date | Last Contact
1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  | 20
 |  |  | Total |  |  |  |  |  |  |  | Total
 | Track the business we lost and add info to Cintergy |  |  |  |  |  |  |  |  |  | Qtr Total
 | Missed Business |  | Competitor | Volume | Why | X-Date |  |  |  | Missed Business | Competitor | Volume | Why | X-Date |  |  |  |  | Missed Business | Competitor | Volume | Why | X-Date
1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | 10