Spreadsheet: 710645d1609166753-looping-through-data-outputting-flag-y-n-based-on-date-logic-and-field-values-sample1214_2
Sheet: Sheet1

ID: | Mod TSP 1 | STATUS1 | OStatus 1 | Mod TSP 2 | STATUS2 | OStatus 2 |  |  | EXPECTED VALUE - REVIEW1 | EXPECTED VALUE - HOLD1 | HOLD1 | Review1
1735 | 2016-11-11 10:19:00 | Available | For Review | 2016-11-11 10:21:00 | In Process | Available |  |  | N
1735 | 2016-11-11 10:21:00 | In Process | Available | 2016-11-11 11:00:00 | Complete | In Process |  |  | N
1735 | 2016-11-11 11:00:00 | Complete | In Process | 2016-11-15 16:08:00 | In Process | Complete |  |  | N
1735 | 2016-11-15 16:08:00 | In Process | Complete | 2016-11-15 16:14:00 | Complete | In Process |  |  | N | N
1735 | 2016-11-15 16:14:00 | Complete | In Process | 2016-11-15 16:08:00 | In Process | Complete |  |  | N | N
1737 | 2016-11-10 18:21:00 | Available | For Review | 2016-11-11 06:37:00 | In Process | Available |  |  | N | N
1737 | 2016-11-10 18:21:00 | For Review | [NAME] | 2016-11-10 18:21:00 | Available | For Review |  |  | N | N
1737 | 2016-11-11 06:37:00 | In Process | Available | 2016-11-22 12:27:00 | Complete | In Process |  |  | N | N
1738 | 2016-11-10 19:31:00 | Pending Assignment | [NAME] | 2016-11-14 07:55:00 | For Review | Pending Assignment |  |  | Y | N
1738 | 2016-11-14 07:55:00 | For Review | Pending Assignment | 2016-11-15 08:12:00 | Available | For Review |  |  | Y | N
1738 | 2016-11-15 08:12:00 | Available | For Review | 2016-11-15 16:58:00 | For Review | Available |  |  | Y | N
1738 | 2016-11-15 16:58:00 | For Review | Available | 2016-11-18 15:29:00 | Available | For Review |  |  | Y | N
1738 | 2016-11-18 15:29:00 | Available | For Review | 2016-11-22 18:08:00 | In Process | Available |  |  | Y | N
1738 | 2016-11-22 18:08:00 | In Process | Available | 2016-12-01 11:27:00 | On Hold - Customer | In Process |  |  | Y | N
1738 | 2016-12-01 11:27:00 | On Hold - Customer | In Process | 2016-12-13 08:21:00 | In Process | On Hold - Customer |  |  | Y | N
1738 | 2016-12-13 08:21:00 | In Process | On Hold - Customer | 2016-12-21 16:17:00 | Complete | In Process |  |  | Y | N
1739 | 2016-11-10 22:17:00 | For Review | [NAME] | 2016-11-10 22:17:00 | Available | For Review |  |  | N | Y
1739 | 2016-11-10 22:17:00 | Available | For Review | 2016-11-14 08:02:00 | In Process | Available |  |  | N | Y
1739 | 2016-11-14 08:02:00 | In Process | Available | 2016-11-17 12:47:00 | Available | In Process |  |  | N | Y
1739 | 2016-11-17 12:47:00 | Available | In Process | 2016-11-21 08:04:00 | In Process | Available |  |  | N | Y
1739 | 2016-11-21 08:04:00 | In Process | Available | 2016-12-22 09:01:00 | On Hold - Customer | In Process |  |  | N | Y
1739 | 2016-12-22 09:01:00 | On Hold - Customer | In Process | 2016-12-29 14:13:00 | In Process | On Hold - Customer |  |  | N | Y
1739 | 2016-12-29 14:13:00 | In Process | On Hold - Customer | 2016-12-29 14:22:00 | Complete | In Process |  |  | N | Y
1745 | 2016-11-11 12:45:00 | Available | For Review | 2016-11-11 12:50:00 | In Process | Available |  |  | N | Y
1745 | 2016-11-11 12:45:00 | For Review | [NAME] | 2016-11-11 12:45:00 | Available | For Review |  |  | N | Y
1745 | 2016-11-11 12:50:00 | In Process | Available | 2016-11-22 08:42:00 | On Hold - Customer | In Process |  |  | N | Y
1745 | 2016-11-22 08:42:00 | On Hold - Customer | In Process | 2016-11-23 11:57:00 | In Process | On Hold - Customer |  |  | N | Y
1745 | 2016-11-23 11:57:00 | In Process | On Hold - Customer | 2016-12-07 11:12:00 | Complete | In Process |  |  | N | Y
1746 | 2016-11-14 09:41:00 | Available | For Review | 2016-11-14 09:43:00 | In Process | Available |  |  | N | N
1746 | 2016-11-14 09:43:00 | In Process | Available | 2016-11-23 07:05:00 | Complete | In Process |  |  | N | N
2517 | 2016-11-13 19:08:00 | Available | For Review | 2016-11-14 15:25:00 | On Hold - Customer | Available |  |  | N | Y
2517 | 2016-11-14 15:25:00 | On Hold - Customer | Available | 2016-12-12 14:10:00 | In Process | On Hold - Customer |  |  | N | Y
2517 | 2016-12-12 14:10:00 | In Process | On Hold - Customer | 2017-01-09 09:00:00 | On Hold - Customer | In Process |  |  | N | Y
2517 | 2017-01-09 09:00:00 | On Hold - Customer | In Process | 2017-01-30 15:52:00 | In Process | On Hold - Customer |  |  | N | Y
2517 | 2017-01-30 15:52:00 | In Process | On Hold - Customer | 2017-01-30 16:00:00 | Complete | In Process |  |  | N | Y
1008 | 2019-12-19 17:56:00 | Pending Assignment | [NAME] | 2019-12-20 10:54:00 | For Review | Pending Assignment |  |  | N | Y
1008 | 2019-12-20 10:54:00 | Available | For Review | 2019-12-20 10:55:00 | In Process | Available |  |  | N | Y
1008 | 2019-12-20 10:54:00 | For Review | Pending Assignment | 2019-12-20 10:54:00 | Available | For Review |  |  | N | Y
1008 | 2019-12-20 10:55:00 | In Process | Available | 2019-12-20 15:23:00 | On Hold - Customer | In Process |  |  | N | Y
1008 | 2019-12-20 15:23:00 | On Hold - Customer | In Process | 2019-12-25 21:31:00 | On Hold - Waiting | On Hold - Customer |  |  | N | Y
1008 | 2019-12-25 21:31:00 | On Hold - Waiting | On Hold - Customer | 2020-01-09 12:45:00 | In Process | On Hold - Waiting |  |  | N | Y
1008 | 2020-01-09 12:45:00 | In Process | On Hold - Waiting | 2020-01-09 12:52:00 | Complete | In Process |  |  | N | Y