Spreadsheet: 675053d1588122263-need-help-calculating-time-ahead-max-end-of-range-and-low-end-of-range-data-for-posting-sab12-
Sheet: Sheet1

Date Application 1st Application Started | 1st Application Number | Time Pending at My Process Starting for 1st Application | Date of Approval | Total Time Pending | Days ahead of average for 1st Application | Date Application 2nd Application Started | 2nd Application Number | Time Pending at My Process Starting for 2nd Application | Date of Approval | Total Time Pending | Days ahead of average for 2nd Application | My process started |  | Low App1 | High App1 | Low App 2 | High App 2 |  | location | Average Processing of App 1 | Average Processing of App 2 | Low App 1 | High App 1 | Low App 2 | High App 2
2019-06-27 00:00:00 | 1 (L1) |  | 2019-12-18 00:00:00 |  |  | 2019-06-27 00:00:00 | 1 (L1) |  | 2019-12-16 00:00:00 |  |  | 2019-12-06 00:00:00 |  |  |  |  |  |  | L1 | 225-258 | 180-225
2019-07-30 00:00:00 | 2 (l2) |  | 2019-12-10 00:00:00 |  |  | 2019-07-30 00:00:00 | 2 (l2) |  | 2019-12-09 00:00:00 |  |  | 2019-12-06 00:00:00 |  |  |  |  |  |  | L2 | 165-225 | 135-195
2019-08-02 00:00:00 | 3 (L3) |  | 2019-12-19 00:00:00 |  |  | 2019-08-02 00:00:00 | 3 (L3) |  | 2019-12-19 00:00:00 |  |  | 2019-12-06 00:00:00 |  |  |  |  |  |  | L3 | 180-240 | 21-150
2019-08-15 00:00:00 | 4 (L4) |  | 2019-12-19 00:00:00 |  |  | 2019-08-15 00:00:00 | 4 (L4) |  | 2019-12-18 00:00:00 |  |  | 2019-12-06 00:00:00 |  |  |  |  |  |  | [NAME] | 180-240 | 180-240
2019-08-19 00:00:00 | 2 (L1) |  | 2019-12-17 00:00:00 |  |  | 2019-08-19 00:00:00 | 2 (L1) |  | 2019-12-17 00:00:00 |  |  | 2019-12-06 00:00:00
2019-08-27 00:00:00 | 3 (l2) |  | 2020-01-13 00:00:00 |  |  | 2019-08-27 00:00:00 | 3 (l2) |  | 2020-01-10 00:00:00 |  |  | 2019-12-06 00:00:00
2019-08-30 00:00:00 | 4 (L3) |  | 2020-01-10 00:00:00 |  |  | 2019-08-30 00:00:00 | 4 (L3) |  | 2020-01-09 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-04 00:00:00 | 5 (L4) |  | 2019-12-18 00:00:00 |  |  | 2019-09-04 00:00:00 | 5 (L4) |  | 2019-12-18 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-11 00:00:00 | 3 (L1) |  | 2019-12-11 00:00:00 |  |  | 2019-09-11 00:00:00 | 3 (L1) |  | 2019-12-10 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-11 00:00:00 | 4 (l2) |  | 2020-02-05 00:00:00 |  |  | 2019-09-11 00:00:00 | 4 (l2) |  | 2020-02-04 00:00:00 |  |  | 2019-12-06 00:00:00
2019-08-06 00:00:00 | 5 (L3) |  | 2019-12-18 00:00:00 |  |  | 2019-09-11 00:00:00 | 5 (L3) |  | 2019-12-30 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-18 00:00:00 | 6 (L4) |  | 2020-02-06 00:00:00 |  |  | 2019-09-18 00:00:00 | 6 (L4) |  | 2020-02-20 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-18 00:00:00 | 4 (L1) |  | 2020-02-06 00:00:00 |  |  | 2019-09-18 00:00:00 | 4 (L1) |  | 2020-02-05 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-23 00:00:00 | 5 (l2) |  | 2020-02-28 00:00:00 |  |  | 2019-09-23 00:00:00 | 5 (l2) |  | 2020-02-27 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-24 00:00:00 | 6 (L3) |  | 2020-02-28 00:00:00 |  |  | 2019-09-24 00:00:00 | 6 (L3) |  | 2020-02-27 00:00:00 |  |  | 2019-12-06 00:00:00
2019-09-25 00:00:00 | 7 (L4) |  | 2020-01-16 00:00:00 |  |  | 2019-09-25 00:00:00 | 7 (L4) |  | 2020-01-15 00:00:00 |  |  | 2019-12-06 00:00:00