Spreadsheet: 866661d1713551303-trying-to-stop-duplicates-with-data-validation-omf-review-assignments-edit
Sheet: Completed Assignments

[NAME] # | Received |  | Assigned |  | Assigned To | Review Completion Date
 | Date | Time | Date | Time |  |  | NOTES | Time to Process (total days) | Adjusted Time to Process  ( business days only)
[PHONE] | 2024-02-07 00:00:00 | 08:39:00 | 2024-02-07 00:00:00 | 12:09:00 | Jola | 2024-02-07 00:00:00 | Amendment 2. |  | 0
2000814091 | 2024-02-07 00:00:00 | 08:51:00 | 2024-02-07 00:00:00 | 12:11:00 | Leah | 2024-02-12 00:00:00 | New Contract Packet |  | 3
2000815350 | 2024-02-11 00:00:00 | 21:10:00 | 2024-02-12 00:00:00 | 13:00:00 | [NAME] | 2024-02-12 00:00:00 | New Contract Packet |  | 0
2000814081 | 2024-02-01 00:00:00 | 18:52:00 | 2024-02-02 00:00:00 | 14:38:00 | Jola | 2024-02-06 00:00:00 | PO errors |  | 2
2000739568 | 2024-02-16 00:00:00 | 09:23:00 | 2024-02-16 00:00:00 | 09:23:00 | [NAME] | 2024-02-16 00:00:00 | Amendment 1 |  | 0
2000815353 | 2024-02-11 00:00:00 | 22:00:00 | 2024-02-12 00:00:00 | 14:00:00 | Leah | 2024-02-19 00:00:00 |  |  | 4
2000739568 | 2024-02-16 00:00:00 | 09:23:00 | 2024-02-16 00:00:00 | 09:53:00 | [NAME] | 2024-02-16 00:00:00 | Amendment 1 - emergency extension. Major error resolved - Board Resolution. |  | 0
2000816207 | 2024-02-29 00:00:00 | 13:04:00 | 2024-02-29 00:00:00 | 15:53:00 | [NAME] | 2024-03-01 00:00:00 |  |  | 1
2000817221 | 2024-02-14 00:00:00 | 21:02:00 | 2024-02-15 00:00:00 | 07:22:00 | Leah | 2024-02-19 00:00:00 |  |  | 2
2000817301 | 2024-02-14 00:00:00 | 07:35:00 | 2024-02-15 00:00:00 | 08:20:00 | [NAME] | 2024-02-21 00:00:00 |  |  | 4
2000683487 | 2024-02-15 00:00:00 | 14:11:00 | 2024-02-15 00:00:00 | 15:09:00 | Leah | 2024-02-16 00:00:00 | Amendment 6 - assigned as group w/all MCO packets |  | 1
2000683488 | 2024-02-15 00:00:00 | 14:12:00 | 2024-02-15 00:00:00 | 15:09:00 | Leah | 2024-02-16 00:00:00 | Amendment 6 - assigned as group w/all MCO packets |  | 1
2000683489 | 2024-02-15 00:00:00 | 14:12:00 | 2024-02-15 00:00:00 | 15:10:00 | Leah | 2024-02-16 00:00:00 | Amendment 6 - assigned as group w/all MCO packets |  | 1
2000683510 | 2024-02-15 00:00:00 | 14:12:00 | 2024-02-15 00:00:00 | 15:10:00 | Leah | 2024-02-17 00:00:00 | Amendment 6 - assigned as group w/all MCO packets |  | 2
2000683511 | 2024-02-15 00:00:00 | 14:13:00 | 2024-02-15 00:00:00 | 15:11:00 | Leah | 2024-02-17 00:00:00 | Amendment 6 - assigned as group w/all MCO packets |  | 2
2000683512 | 2024-02-15 00:00:00 | 14:13:00 | 2024-02-15 00:00:00 | 15:12:00 | Leah | 2024-02-17 00:00:00 | Amendment 6 - assigned as group w/all MCO packets |  | 2
2000745172 | 2024-02-20 00:00:00 | 08:59:00 | 2024-02-20 00:00:00 | 09:23:00 | Leah | 2024-02-26 00:00:00 | Amendment 1 |  | 4
2000818642 | 2024-02-21 00:00:00 | 08:37:00 | 2024-02-21 00:00:00 | 09:20:00 | Leah | 2024-02-23 00:00:00 | [NAME] has pre-approval |  | 2
2000814762 | 2024-02-21 00:00:00 | 09:20:00 | 2024-02-21 00:00:00 | 09:22:00 | Leah | 2024-02-23 00:00:00 |  |  | 2
2000815471 | 2024-02-21 00:00:00 | 13:49:00 | 2024-02-21 00:00:00 | 14:43:00 | Leah | 2024-02-23 00:00:00 |  |  | 2
2000816804 | 2024-02-22 00:00:00 | 08:25:00 | 2024-02-22 00:00:00 | 15:14:00 | Leah | 2024-02-26 00:00:00 |  |  | 2
2000816302 | 2024-02-29 00:00:00 | 12:56:00 | 2024-02-29 00:00:00 | 15:50:00 | Leah | 2024-03-03 00:00:00 |  |  | 3
2000790197 | 2024-02-28 00:00:00 | 08:19:00 | 2024-02-28 00:00:00 | 08:23:00 | Leah | 2024-03-01 00:00:00 |  |  | 2
2000816207 | 2024-02-29 00:00:00 | 13:04:00 | 2024-02-29 00:00:00 | 15:52:00 | [NAME] | 2024-03-04 00:00:00 |  |  | 2
2000814770 | 2024-02-29 00:00:00 | 14:11:00 | 2024-02-29 00:00:00 | 15:55:00 | Leah | 2024-03-03 00:00:00 |  |  | 3
2000820595 | 2024-02-28 00:00:00 | 13:56:00 | 2024-02-28 00:00:00 | 14:00:00 | Leah | 2024-03-03 00:00:00 |  |  | 2
1000301376 | 2024-02-29 00:00:00 | 09:47:00 | 2024-02-29 00:00:00 | 10:40:00 | Leah | 2024-03-03 00:00:00 | Emergency Pre-Approval Packet. Returned by Legal for major errors. |  | 3
1000315255 | 2024-02-15 00:00:00 | 08:28:00 | 2024-02-15 00:00:00 | 09:46:00 | Leah | 2024-02-16 00:00:00 | Note: emergency pre-approval request |  | 1
2000816338 | 2024-02-27 00:00:00 | 08:47:00 | 2024-02-27 00:00:00 | 09:32:00 | Leah | 2024-03-06 00:00:00 | Reassigned to Stephanie 3/6/24 |  | 6
2000817486 | 2024-03-01 00:00:00 | 15:29:00 | 2024-03-04 00:00:00 | 07:23:00 | Leah | 2024-03-06 00:00:00 | Reassigned to [NAME] on 3/6/24. |  | 2
2000817484 | 2024-03-01 00:00:00 | 15:30:00 | 2024-03-04 00:00:00 | 07:24:00 | Leah | 2024-03-06 00:00:00 | Reassigned to [NAME] on 3/6/24. |  | 2
1000316707 | 2024-03-06 00:00:00 | 14:15:00 | 2024-03-06 00:00:00 | 16:23:00 | [NAME] | 2024-03-07 00:00:00 | also [PHONE] |  | 1
2000819745 | 2024-03-06 00:00:00 | 10:36:00 | 2024-03-06 00:00:00 | 10:40:00 | [NAME] | 2024-03-07 00:00:00 |  |  | 1
1000316219 | 2024-03-06 00:00:00 | 14:30:00 | 2024-03-06 00:00:00 | 16:21:00 | [NAME] | 2024-03-08 00:00:00 | Not a pre-approval; OAAS delayed shopping cart approval. |  | 2
2000822352 | 2024-03-05 00:00:00 | 21:58:00 | 2024-03-06 00:00:00 | 08:02:00 | Leah | 2024-03-08 00:00:00 | Reassigned to Steph 3/6/24 8:36am |  | 2
1000309604 | 2024-03-08 00:00:00 | 10:09:00 | 2024-03-08 00:00:00 | 10:09:00 | [NAME] | 2024-03-08 00:00:00 | Not a pre-approval; Shopping cart budget errors delaying PO. |  | 0
2000821683 | 2024-03-08 00:00:00 | 10:32:00 | 2024-03-08 00:00:00 | 12:30:00 | [NAME] | 2024-03-08 00:00:00 | Supporting documentation error. |  | 0
2000815560 | 2024-02-27 00:00:00 | 08:43:00 | 2024-02-27 00:00:00 | 09:31:00 | Leah | 2024-03-07 00:00:00 |  |  | 7
N/A - MOU | 2024-02-28 00:00:00 | 07:53:00 | 2024-02-28 00:00:00 | 08:22:00 | Leah | 2024-03-01 00:00:00 | Capital Area Human Services District (CAHSD) MOU |  | 2
2000820308 | 2024-03-12 00:00:00 | 07:45:00 | 2024-03-12 00:00:00 | 10:35:00 | [NAME] | 2024-03-12 00:00:00 |  |  | 0
2000819919 | 2024-03-12 00:00:00 | 12:04:00 | 2024-03-12 00:00:00 | 12:55:00 | [NAME] | 2024-03-12 00:00:00 |  |  | 0
2000821911 | 2024-03-12 00:00:00 | 10:55:00 | 2024-03-12 00:00:00 | 12:54:00 | [NAME] | 2024-03-12 00:00:00 |  |  | 0
2000820352 | 2024-03-11 00:00:00 | 13:21:00 | 2024-03-11 00:00:00 | 13:57:00 | [NAME] | 2024-03-11 00:00:00 |  |  | 0
2000821848 | 2024-03-12 00:00:00 | 15:54:00 | 2024-03-12 00:00:00 | 20:45:00 | [NAME] | 2024-03-12 00:00:00 |  |  | 0
2000823919 | 2024-03-12 00:00:00 | 15:56:00 | 2024-03-12 00:00:00 | 20:43:00 | [NAME] | 2024-03-12 00:00:00 |  |  | 0
2000822996 | 2024-03-08 00:00:00 | 15:23:00 | 2024-03-11 00:00:00 | 13:54:00 | Leah | 2024-03-12 00:00:00 |  |  | 1
2000823331 | 2024-03-08 00:00:00 | 13:34:00 | 2024-03-08 00:00:00 | 14:00:00 | [NAME] | 2024-03-15 00:00:00 |  |  | 5
2000821989 | 2024-03-14 00:00:00 | 14:06:00 | 2024-03-14 00:00:00 | 15:31:00 | [NAME] | 2024-03-15 00:00:00 |  |  | 1
2000820371 | 2024-03-08 00:00:00 | 12:57:00 | 2024-03-08 00:00:00 | 14:34:00 | [NAME] | 2024-03-08 00:00:00 |  |  | 0
2000819764 | 2024-03-12 00:00:00 | 15:49:00 | 2024-03-12 00:00:00 | 20:44:00 | Leah | 2024-03-15 00:00:00 |  |  | 3
2000821788 | 2024-03-15 00:00:00 | 09:27:00 | 2024-03-15 00:00:00 | 10:48:00 | [NAME] | 2024-03-15 00:00:00 |  |  | 0
2000821787 | 2024-03-15 00:00:00 | 09:02:00 | 2024-03-15 00:00:00 | 10:42:00 | [NAME] | 2024-03-15 00:00:00 |  |  | 0
2000821623 | 2024-03-15 00:00:00 | 09:12:00 | 2024-03-15 00:00:00 | 10:44:00 | [NAME] | 2024-03-16 00:00:00 |  |  | 1
2000818793 | 2024-03-07 00:00:00 | 14:10:00 | 2024-03-11 00:00:00 | 08:00:00 | Leah | 2024-03-11 00:00:00 |  |  | 0
1000317205 | 2024-03-12 00:00:00 | 15:17:00 | 2024-03-12 00:00:00 | 20:45:00 | [NAME] | 2024-03-12 00:00:00 | Returned for Fee Schedule not adding up |  | 0
2000821800 | 2024-03-15 00:00:00 | 09:45:00 | 2024-03-15 00:00:00 | 10:49:00 | [NAME] | 2024-03-16 00:00:00 | Returned for major corrections |  | 1
2000763509A1 | 2024-03-15 00:00:00 | 13:19:00 | 2024-03-15 00:00:00 | 14:02:00 | [NAME] | 2024-03-16 00:00:00 | Returned for major corrections |  | 1
2000730959A1 | 2024-03-18 00:00:00 | 14:45:00 | 2024-03-18 00:00:00 | 20:25:00 | [NAME] | 2024-03-18 00:00:00 |  |  | 0
2000821504 | 2024-03-20 00:00:00 | 12:11:00 | 2024-03-20 00:00:00 | 13:35:00 | [NAME] | 2024-03-20 00:00:00 | No issues. |  | 0
2000823000 | 2024-03-06 00:00:00 | 13:55:00 | 2024-03-18 00:00:00 | 18:46:00 | [NAME] | 2024-03-21 00:00:00 | CF1, Supporting Docs, SOW, PO |  | 3
2000776293A1 | 2023-03-18 00:00:00 | 13:34:00 | 2024-03-18 00:00:00 | 20:25:00 | [NAME] | 2024-03-22 00:00:00 | Supporting documentation error. |  | 4
2000821997 | 2024-03-13 00:00:00 | 14:07:00 | 2024-03-13 00:00:00 | 15:32:00 | Leah | 2024-03-18 00:00:00 |  |  | 3
2000822000 | 2024-03-14 00:00:00 | 15:25:00 | 2024-03-14 00:00:00 | 15:32:00 | Leah | 2024-03-19 00:00:00 |  |  | 3
2000754956 | 2024-03-12 00:00:00 | 13:21:00 | 2024-03-12 00:00:00 | 15:31:00 | Leah | 2024-03-14 00:00:00 |  |  | 2
2000819431 | 2024-03-11 00:00:00 | 14:13:00 | 2024-03-12 00:00:00 | 10:36:00 | [NAME]
2000822043 | 2024-03-20 00:00:00 | 10:37:00 | 2024-03-20 00:00:00 | 10:50:00 | Leah | 2024-03-26 00:00:00 |  |  | 4
2000685889 | 2024-03-20 00:00:00 | 16:54:00 | 2024-03-21 00:00:00 | 07:15:00 | Leah | 2024-03-25 00:00:00 |  |  | 2
1000317690 | 2024-03-22 00:00:00 | 13:41:00 | 2024-03-05 00:00:00 | 13:07:00 | [NAME] |  |  |  | 5
2000827017 | 2024-03-22 00:00:00 | 15:01:00 | 2024-03-25 00:00:00 | 13:08:00 | leah | 2024-03-25 00:00:00 |  |  | 0
2000824595 | 2024-03-25 00:00:00 | 12:59:00 | 2024-03-25 00:00:00 | 13:43:00 | Leah | 2024-03-26 00:00:00 |  |  | 1
2000749405 | 2024-03-25 00:00:00 | 13:14:00 | 2024-03-25 00:00:00 | 16:12:00 | Leah | 2024-03-26 00:00:00 |  |  | 1
2000822060 | 2024-03-25 00:00:00 | 13:58:00 | 2024-03-25 00:00:00 | 16:13:00 | Leah | 2024-03-28 00:00:00 |  |  | 3
2000824590 | 2024-03-25 00:00:00 | 15:35:00 | 2024-03-25 00:00:00 | 16:14:00 | [NAME] | 2024-04-02 00:00:00 | Reassigned and routed directly to Legal. |  | 6
2000739546A1 | 2024-03-18 00:00:00 | 13:50:00 | 2024-03-18 00:00:00 | 20:45:00 | [NAME] | 2024-03-25 00:00:00 | No issues. |  | 5
2000733442A1 | 2024-03-18 00:00:00 | 13:54:00 | 2024-03-18 00:00:00 | 20:45:00 | [NAME] | 2024-03-25 00:00:00 | No issues. |  | 5
2000735509A1 | 2024-03-18 00:00:00 | 14:01:00 | 2024-03-18 00:00:00 | 20:45:00 | [NAME] | 2024-03-25 00:00:00 | No issues. |  | 5
2000734946A1 | 2024-03-18 00:00:00 | 14:26:00 | 2024-03-18 00:00:00 | 20:45:00 | [NAME] | 2024-03-25 00:00:00 | No issues. |  | 5
2000748825A1 | 2024-03-18 00:00:00 | 14:32:00 | 2024-03-18 00:00:00 | 20:45:00 | [NAME] | 2024-03-25 00:00:00 | No issues. |  | 5
2000781245 | 2024-04-01 00:00:00 | 09:27:00 | 2024-04-02 00:00:00 | 08:32:00 | [NAME] |  |  |  | 5
2000506234 | 2024-04-01 00:00:00 | 14:40:00 | 2024-04-02 00:00:00 | 08:33:00 | Leah | 2024-04-04 00:00:00 |  |  | 2
2000506243 | 2024-04-01 00:00:00 | 14:41:00 | 2024-04-02 00:00:00 | 08:35:00 | Leah | 2024-04-04 00:00:00 |  |  | 2
MOU - EatMoveGrow | 2024-04-01 00:00:00 | 09:16:00 | 2024-04-01 00:00:00 | 13:04:00 | [NAME] | 2024-04-01 00:00:00 |  |  | 0
2000814659 | 2024-04-04 00:00:00 | 13:40:00 | 2024-04-04 00:00:00 | 19:04:00 | [NAME] | 2024-04-09 00:00:00 | CF1, Supporting Docs |  | 5
20008290982 | 2024-04-16 00:00:00 | 11:33:00 | 2024-04-16 00:00:00 | 14:55:00 | [NAME] | 2024-04-16 00:00:00 | None. |  | 0