Spreadsheet: 112157d1308297855-help-counting-information-in-excel-2003-book1
Sheet: Open Items

Reports Received |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ASR | Total EIR
 | Type | Occ. ID | Occurrence Date | Received Date | Reg | Subject | Days Open |  |  |  | Total Records |  |  |  |  |  | Records over 100 days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6
1 | EIR | O3144-10 | 2011-01-14 00:00:00 | 2011-01-14 00:00:00 | LA | [NAME] | 154 |  |  |  | Week | WK COMM | WK END | ASR | EIR | Total Open | Overdue ASR | Overdue EIR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5
2 | ASR | O122-11 | 2011-01-24 00:00:00 | 2011-01-24 00:00:00 | COMP | [NAME] | 144 |  |  |  | 1 | 2011-01-03 00:00:00 | 2011-01-09 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7
3 | EIR | O145-11 | 2011-01-23 00:00:00 | 2011-01-23 00:00:00 | AT | [NAME] | 145 |  |  |  | 2 | 2011-01-10 00:00:00 | 2011-01-16 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2
4 | EIR | O324-11 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | AL | [NAME] | 114 |  |  |  | 3 | 2011-01-17 00:00:00 | 2011-01-23 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6
5 | EIR | O384-11 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | AL | [NAME] | 105 |  |  |  | 4 | 2011-01-24 00:00:00 | 2011-01-30 00:00:00 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7
6 | ASR | O388-11 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | BJ | [NAME] | 105 |  |  |  | 5 | 2011-01-31 00:00:00 | 2011-02-06 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 14
7 | EIR | O412-11 | 2011-03-09 00:00:00 | 2011-03-09 00:00:00 | LO | [NAME] | 100 |  |  |  | 6 | 2011-02-07 00:00:00 | 2011-02-13 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4
8 | EIR | O413-11 | 2011-03-09 00:00:00 | 2011-03-09 00:00:00 | YD | [NAME] | 100 |  |  |  | 7 | 2011-02-14 00:00:00 | 2011-02-20 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5
9 | EIR | O434-11 | 2011-03-14 00:00:00 | 2011-03-14 00:00:00 | BK | [NAME] | 95 |  |  |  | 8 | 2011-02-21 00:00:00 | 2011-02-27 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 4
10 | ASR | O452-11 | 2011-03-13 00:00:00 | 2011-03-13 00:00:00 | COMP | [NAME] | 96 |  |  |  | 9 | 2011-02-28 00:00:00 | 2011-03-06 00:00:00 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2
11 | ASR | O495-11 | 2011-03-17 00:00:00 | 2011-03-17 00:00:00 | EU | [NAME] | 92 |  |  |  | 10 | 2011-03-07 00:00:00 | 2011-03-13 00:00:00 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 3
12 | ASR | O527-11 | 2011-03-24 00:00:00 | 2011-03-24 00:00:00 | YD | [NAME] | 85 |  |  |  | 11 | 2011-03-14 00:00:00 | 2011-03-20 00:00:00 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8
13 | EIR | O537-11 | 2011-03-23 00:00:00 | 2011-03-23 00:00:00 | AL | [NAME] | 86 |  |  |  | 12 | 2011-03-21 00:00:00 | 2011-03-27 00:00:00 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5
14 | EIR | O538-11 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | COMP | [NAME] | 80 |  |  |  | 13 | 2011-03-28 00:00:00 | 2011-04-03 00:00:00 | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1
15 | EIR | O559-11 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | EP | [NAME] | 80 |  |  |  | 14 | 2011-04-04 00:00:00 | 2011-04-10 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6
16 | EIR | O601-11 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | OX | [NAME] | 73 |  |  |  | 15 | 2011-04-11 00:00:00 | 2011-04-17 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2
17 | EIR | O640-11 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | OX | [NAME] | 67 |  |  |  | 16 | 2011-04-18 00:00:00 | 2011-04-24 00:00:00 | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 4
18 | EIR | O713-11 | 2011-04-19 00:00:00 | 2011-04-19 00:00:00 | AN | [NAME] | 59 |  |  |  | 17 | 2011-04-25 00:00:00 | 2011-05-01 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 4
19 | EIR | O721-11 | 2011-04-20 00:00:00 | 2011-04-20 00:00:00 | LO | [NAME] | 58 |  |  |  | 18 | 2011-05-02 00:00:00 | 2011-05-08 00:00:00 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 4
20 | EIR | O722-11 | 2011-04-20 00:00:00 | 2011-04-20 00:00:00 | ON | [NAME] | 58 |  |  |  | 19 | 2011-05-09 00:00:00 | 2011-05-15 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 4
21 | ASR | O726-11 | 2011-04-21 00:00:00 | 2011-04-21 00:00:00 | ON | [NAME] | 57 |  |  |  | 20 | 2011-05-16 00:00:00 | 2011-05-22 00:00:00 | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7
22 | ASR | O789-11 | 2011-05-02 00:00:00 | 2011-05-02 00:00:00 | BN | [NAME] | 46 |  |  |  | 21 | 2011-05-23 00:00:00 | 2011-05-29 00:00:00 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6
23 | ASR | O880-11 | 2011-05-05 00:00:00 | 2011-05-05 00:00:00 | BF | [NAME] | 43 |  |  |  | 22 | 2011-05-30 00:00:00 | 2011-06-05 00:00:00 | 0 | 5 | 65 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
24 | ASR | O882-11 | 2011-05-06 00:00:00 | 2011-05-06 00:00:00 | BJ | [NAME] | 42 |  |  |  | 23 | 2011-06-06 00:00:00 | 2011-06-12 00:00:00 | 2 | 4 | 54 | 2 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
25 | EIR | O919-11 | 2011-05-11 00:00:00 | 2011-05-11 00:00:00 | ZB | [NAME] | 37 |  |  |  | 24 | 2011-06-13 00:00:00 | 2011-06-19 00:00:00 | 1 | 1 | 45 | 2 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
26 | EIR | O1002-11 | 2011-05-18 00:00:00 | 2011-05-18 00:00:00 | BP | [NAME] | 30 |  |  |  | 25 | 2011-06-20 00:00:00 | 2011-06-26 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
27 | ASR | O1082-11 | 2011-05-25 00:00:00 | 2011-05-25 00:00:00 | PH | [NAME] | 23 |  |  |  | 26 | 2011-06-27 00:00:00 | 2011-07-03 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
28 | EIR | O1068-11 | 2011-05-19 00:00:00 | 2011-05-19 00:00:00 | YI | [NAME] | 29 |  |  |  | 27 | 2011-07-04 00:00:00 | 2011-07-10 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
29 | EIR | O1102-11 | 2011-05-26 00:00:00 | 2011-05-26 00:00:00 | AY | [NAME] | 22 |  |  |  | 28 | 2011-07-11 00:00:00 | 2011-07-17 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
30 | ASR | O1092-11 | 2011-05-26 00:00:00 | 2011-05-26 00:00:00 | ZR | [NAME] | 22 |  |  |  | 29 | 2011-07-18 00:00:00 | 2011-07-24 00:00:00 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
31 | EIR | O1103-11 | 2011-05-27 00:00:00 | 2011-05-27 00:00:00 | YE | [NAME] | 21 |  |  |  | 30 | 2011-07-25 00:00:00 | 2011-07-31 00:00:00 | 0 | 0
32 | EIR | O1125-11 | 2011-05-28 00:00:00 | 2011-05-31 00:00:00 | BN | [NAME] | 17 |  |  |  | 31 | 2011-08-01 00:00:00 | 2011-08-07 00:00:00 | 0 | 0
33 | EIR | O1126-11 | 2011-05-25 00:00:00 | 2011-05-31 00:00:00 | BK | [NAME] | 17
34 | EIR | O962-11 | 2011-05-13 00:00:00 | 2011-05-31 00:00:00 | BG | [NAME] | 17
35 | EIR | O1148-11 | 2011-05-29 00:00:00 | 2011-06-01 00:00:00 | ZU | [NAME] | 16
36 | EIR | O1178-11 | 2011-05-31 00:00:00 | 2011-06-03 00:00:00 | BR | [NAME] | 14
37 | EIR | O1180-11 | 2011-06-04 00:00:00 | 2011-06-06 00:00:00 | OO | [NAME] | 11
38 | ASR | O1190-11 | 2011-06-03 00:00:00 | 2011-06-06 00:00:00 | AU | [NAME] | 11
39 | ASR | O1216-11 | 2011-05-27 00:00:00 | 2011-06-07 00:00:00 | 757 | [NAME] | 10
40 | EIR | O1258-11 | 2011-05-25 00:00:00 | 2011-06-08 00:00:00 | ZH | [NAME] | 9
41 | EIR | O1281-11 | 2011-06-08 00:00:00 | 2011-06-08 00:00:00 | BL | [NAME] | 9
42 | EIR | O1307-11 | 2011-06-10 00:00:00 | 2011-06-10 00:00:00 | YH | [NAME] | 7
43 | ASR | O1321-11 | 2011-06-10 00:00:00 | 2011-06-13 00:00:00 | OP | [NAME] | 4
44 | EIR | O1325-11 | 2011-06-13 00:00:00 | 2011-06-13 00:00:00 | ZE | [NAME] | 4
45 | EIR | O848-11 | 2011-05-04 00:00:00 | 2011-05-05 00:00:00 | ZO | [NAME] | 43
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
81