Spreadsheet: 708934d1608098152-looping-through-data-outputting-flag-y-n-based-on-date-logic-and-field-values-sample1215
Sheet: Sheet1

ID: | Mod TSP 1 | STATUS1 | OStatus 1 | Mod TSP 2 | STATUS2 | OStatus 2 |  |  | Expected Review1 | Expected Review 2 | Review1 | Review2
1735 | 2016-11-11 10:19:00 | Available | For Review | 2016-11-11 10:21:00 | In Process | Available |  |  | N | N
1735 | 2016-11-11 10:21:00 | In Process | Available | 2016-11-11 11:00:00 | Complete | In Process |  |  | N | N
1735 | 2016-11-11 11:00:00 | Complete | In Process | 2016-11-15 16:08:00 | In Process | Complete |  |  | N | 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
3708 | 2016-10-28 14:13:00 | Pending Assignment | [NAME] | 2016-11-01 14:09:00 | For Review | Pending Assignment |  |  | N | N
3708 | 2016-11-01 14:09:00 | For Review | Pending Assignment | 2016-11-02 09:48:00 | Available | For Review |  |  | N | N
3708 | 2016-11-02 09:48:00 | In Process | Available | 2016-11-16 20:59:00 | Complete | In Process |  |  | N | N
3708 | 2016-11-02 09:48:00 | Available | For Review | 2016-11-02 09:48:00 | In Process | Available |  |  | N | N
4092 | 2016-11-07 07:03:00 | Pending Assignment | [NAME] | 2016-11-07 12:26:00 | For Review | Pending Assignment | 0.2083333333333333 |  | N | N
4092 | 2016-11-07 12:26:00 | For Review | Pending Assignment | 2016-11-11 13:46:00 | Available | For Review | 4.041666666666667 |  | N | N
4092 | 2016-11-11 13:46:00 | Available | For Review | 2016-11-14 09:48:00 | In Process | Available | 2.833333333333333 |  | N | N
4092 | 2016-11-14 09:48:00 | In Process | Available | 2016-12-14 12:39:00 | Complete | In Process | 30.125 |  | N | N