Spreadsheet: 55526d1255629503-formula-to-count-multiple-ifs-and-take-an-average-703475_sam_d
Sheet: Sheet1

Item No. | Company | Query Raised | Query Arrived | Number of Rejections | COMMENTS | Added to internal system F | Answered and sent back to Company G | Company Internal Lag H (D-C) | Overal Company Lag Time Due to Query Deficencies I (F-C) | Lag Time Per Rejection J ((F-D)/E) | Process Time K (G-F) | KEY
1 | Company A | 2009-05-21 00:00:00 | 2009-07-01 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 41 | 53 | 12 | 7 | Company A:39995
2 | Company B | 2009-05-26 00:00:00 | 2009-05-27 00:00:00 | 0 |  | 2009-05-27 00:00:00 | 2009-06-02 00:00:00 | 1 | 1 | 0 | 6 | Company B:39934
3 | Company A | 2009-06-15 00:00:00 | 2009-06-30 00:00:00 | 0 |  | 2009-06-30 00:00:00 | 2009-07-13 00:00:00 | 15 | 15 | 0 | 13 | Company A:39965
4 | Company A | 2009-06-16 00:00:00 | 2009-07-09 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 23 | 27 | 4 | 7 | Company A:39995
5 | Company A | 2009-06-17 00:00:00 | 2009-07-14 00:00:00 | 1 |  | 2009-07-14 00:00:00 | 2009-07-20 00:00:00 | 27 | 27 | 0 | 6 | Company A:39995
6 | Company A | 2009-06-18 00:00:00 | 2009-07-01 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 13 | 25 | 12 | 7 | Company A:39995
7 | Company C | 2009-06-24 00:00:00 | 2009-06-30 00:00:00 | 0 |  | 2009-06-30 00:00:00 | 2009-07-09 00:00:00 | 6 | 6 | 0 | 9 | Company C:39965
8 | Company C | 2009-06-30 00:00:00 | 2009-06-30 00:00:00 | 0 |  | 2009-06-30 00:00:00 | 2009-07-08 00:00:00 | 0 | 0 | 0 | 8 | Company C:39965
9 | Company C | 2009-06-30 00:00:00 | 2009-07-01 00:00:00 | 0 |  | 2009-07-01 00:00:00 | 2009-07-13 00:00:00 | 1 | 1 | 0 | 12 | Company C:39995
10 | Company A | 2009-07-01 00:00:00 | 2009-07-09 00:00:00 | 0 |  | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 8 | 12 | 0 | 7 | Company A:39995
11 | Company B | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 0 |  | 2009-07-02 00:00:00 | 2009-07-08 00:00:00 | 1 | 1 | 0 | 6 | Company B:39995
12 | Company A | 2009-07-04 00:00:00 | 2009-07-09 00:00:00 | 2 |  | 2009-07-17 00:00:00 | 2009-07-27 00:00:00 | 5 | 13 | 4 | 10 | Company A:39995
13 | Company C | 2009-07-08 00:00:00 | 2009-07-09 00:00:00 | 0 |  | 2009-07-09 00:00:00 | 2009-07-16 00:00:00 | 1 | 1 | 0 | 7 | Company C:39995
14 | Company A | 2009-07-09 00:00:00 | 2009-07-28 00:00:00 | 1 | Lack of corrective action | 2009-07-30 00:00:00 | 2009-09-02 00:00:00 | 19 | 21 | 2 | 34 | Company A:39995
15 | Company C | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 0 |  | 2009-07-09 00:00:00 | 2009-07-14 00:00:00 | 0 | 0 | 0 | 5 | Company C:39995
16 | Company B | 2009-07-10 00:00:00 | 2009-07-10 00:00:00 | 1 |  | 2009-07-13 00:00:00 | 2009-07-14 00:00:00 | 0 | 3 | 3 | 1 | Company B:39995
17 | Company A | 2009-07-14 00:00:00 | 2009-08-07 00:00:00 | 0 |  | 2009-08-10 00:00:00 | 2009-08-13 00:00:00 | 24 | 27 | 0 | 3 | Company A:40026
18 | Company C | 2009-07-15 00:00:00 | 2009-07-15 00:00:00 | 0 |  | 2009-07-16 00:00:00 | 2009-07-23 00:00:00 | 0 | 1 | 0 | 7 | Company C:39995
19 | Company A | 2009-07-16 00:00:00 | 2009-08-05 00:00:00 | 0 |  | 2009-08-05 00:00:00 | 2009-08-05 00:00:00 | 20 | 20 | 0 | 0 | Company A:40026
20 | Company B | 2009-07-16 00:00:00 | 2009-07-17 00:00:00 | 1 |  | 2009-07-17 00:00:00 | 2009-07-22 00:00:00 | 1 | 1 | 0 | 5 | Company B:39995
21 | Company C | 2009-07-16 00:00:00 | 2009-07-27 00:00:00 | 1 | To be Concession not Prod Per | 2009-07-28 00:00:00 | 2009-07-28 00:00:00 | 11 | 12 | 1 | 0 | Company C:39995
22 | Company A | 2009-07-23 00:00:00 | 2009-07-29 00:00:00 | 1 | Lack of corrective action | 2009-07-30 00:00:00 | 2009-09-02 00:00:00 | 6 | 7 | 1 | 34 | Company A:39995
23 | Company C | 2009-07-23 00:00:00 | 2009-07-24 00:00:00 | 0 |  | 2009-07-27 00:00:00 | 2009-07-29 00:00:00 | 1 | 4 | 0 | 2 | Company C:39995
24 | Company C | 2009-07-23 00:00:00 | 2009-07-24 00:00:00 | 0 |  | 2009-07-27 00:00:00 | 2009-07-29 00:00:00 | 1 | 4 | 0 | 2 | Company C:39995
25 | Company A | 2009-07-24 00:00:00 | 2009-09-24 00:00:00 | 1 | Centre positions req'd, centre line, instl pos'ns. | 2009-09-30 00:00:00 | 2009-10-12 00:00:00 | 62 | 68 | 6 | 12 | Company A:40057
26 | Company C | 2009-07-24 00:00:00 | 2009-07-24 00:00:00 | 0 |  | 2009-07-27 00:00:00 | 2009-07-31 00:00:00 | 0 | 3 | 0 | 4 | Company C:39995
27 | Company C | 2009-07-28 00:00:00 | 2009-07-28 00:00:00 | 0 |  | 2009-08-04 00:00:00 | 2009-08-05 00:00:00 | 0 | 7 | 0 | 1 | Company C:39995
28 | Company A | 2009-07-29 00:00:00 | 2009-07-31 00:00:00 | 1 | Lack of corrective action | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2 | 2 | 0 | 0 | Company A:39995
29 | Company A | 2009-07-29 00:00:00 | 2009-07-31 00:00:00 | 1 | Lack of corrective action | 2009-07-31 00:00:00 | 2009-08-04 00:00:00 | 2 | 2 | 0 | 4 | Company A:39995
30 | Company A | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 1 | Lack of corrective action | 2009-07-31 00:00:00 | 2009-08-04 00:00:00 | 0 | 0 | 0 | 4 | Company A:39995