Spreadsheet: 157202d1337653881-conditional-formatting-copy-of-kyn-fy13-rev2
Sheet: 2nd QTR FY13

 | Put New Business in under the month it actually installs
 | September |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  |  | November
On [NAME] | Account Name | national | garments | chemical | paper | F/S (non paper Chemical) | Total Volume |  | On [NAME] | Account Name | national | garments | chemical | paper | F/S (non paper Chemical) | Total Volume |  | On [NAME] | Account Name | national | garments | chemical | paper | F/S (non paper Chemical) | Total Volume
y |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
y |  | n |  |  |  |  |  |  | y |  | n |  |  |  |  |  |  | y |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
y |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | y |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | y |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | y |  | n |  |  |  |  |  |  | n |  | n
y |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | y |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | y |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
y |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
n |  | n |  |  |  |  |  |  | n |  | n |  |  |  |  |  |  | n |  | n
 | National Accounts
 | 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