Spreadsheet: 539809d1506373775-conditional-formatting-not-working-on-cell-that-has-formula-ot-tracker-bvj-
Sheet: OT Commitment

 | OT Requirements Dump (BluePrint) |  |  |  |  |  |  |  |  |  |  | OT Requirements |  |  |  |  |  |  |  |  |  | Seating per 30 mins. Interval |  |  |  |  |  |  |  |  |  | Commitment
 |  | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  | 2017-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sun | Sun | Mon | Mon | Tue | Tue | Wed | Wed | Thu | Thu | Fri | Fri | Sat | Sat
 |  |  |  |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
 | 12:00 AM-12:30 AM |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  | 00:00:00 |  |  |  |  |  |  |  |  | 04:00:00 | 04:30:00 |  |  |  |  |  |  |  |  | 04:00:00 | 04:30:00 |  |  |  |  |  |  |  |  | Advisor 1 |  |  | 10:00:00 | 10:30:00
 | 12:30 AM-01:00 AM |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | 04:30:00 | 05:00:00 |  |  |  |  |  |  |  |  | 04:30:00 | 05:00:00 |  |  |  |  |  |  |  |  | Advisor 2
 | 01:00 AM-01:30 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 05:00:00 | 05:30:00 |  |  |  |  |  |  |  |  | 05:00:00 | 05:30:00 |  |  |  |  |  |  |  |  | Advisor 3
 | 01:30 AM-02:00 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 05:30:00 | 06:00:00 |  |  |  |  |  |  |  |  | 05:30:00 | 06:00:00 |  |  |  |  |  |  |  |  | Advisor 4
 | 02:00 AM-02:30 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 06:00:00 | 06:30:00 |  |  |  |  |  |  |  |  | 06:00:00 | 06:30:00 |  |  |  |  |  |  |  |  | Advisor 5
 | 02:30 AM-03:00 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 06:30:00 | 07:00:00 |  |  |  |  |  |  |  |  | 06:30:00 | 07:00:00 |  |  |  |  |  |  |  |  | Advisor 6
 | 03:00 AM-03:30 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 07:30:00 |  |  |  |  |  |  |  |  | 07:00:00 | 07:30:00 |  |  |  |  |  |  |  |  | Advisor 7
 | 03:30 AM-04:00 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 08:00:00 |  |  |  |  |  |  |  |  | 07:30:00 | 08:00:00 |  |  |  |  |  |  |  |  | Advisor 8
 | 04:00 AM-04:30 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 08:30:00 |  |  |  |  |  |  |  |  | 08:00:00 | 08:30:00 |  |  |  |  |  |  |  |  | Advisor 9
 | 04:30 AM-05:00 AM |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 08:30:00 | 09:00:00 |  |  |  |  |  |  |  |  | 08:30:00 | 09:00:00 |  |  |  |  |  |  |  |  | Advisor 10
 | 05:00 AM-05:30 AM |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 09:30:00 |  |  |  |  |  |  |  |  | 09:00:00 | 09:30:00 |  |  |  |  |  |  |  |  | Advisor 11
 | 05:30 AM-06:00 AM |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 09:30:00 | 10:00:00 |  |  |  |  |  |  |  |  | 09:30:00 | 10:00:00 |  |  |  |  |  |  |  |  | Advisor 12
 | 06:00 AM-06:30 AM |  | 2 | 0 | 0 | 0 | 0 | 0 | 2 |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 10:30:00 |  | 200 |  |  |  |  |  |  | 10:00:00 | 10:30:00 |  | 2 |  |  |  |  |  |  | Advisor 13
 | 06:30 AM-07:00 AM |  | 2 | 0 | 0 | 0 | 0 | 0 | 2 |  |  |  |  |  |  |  |  |  |  | 10:30:00 | 11:00:00 |  |  |  |  |  |  |  |  | 10:30:00 | 11:00:00 |  |  |  |  |  |  |  |  | Advisor 14
 | 07:00 AM-07:30 AM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 11:00:00 | 11:30:00 |  |  |  |  |  |  |  |  | 11:00:00 | 11:30:00 |  |  |  |  |  |  |  |  | Advisor 15
 | 07:30 AM-08:00 AM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 12:00:00 |  |  |  |  |  |  |  |  | 11:30:00 | 12:00:00 |  |  |  |  |  |  |  |  | Advisor 16
 | 08:00 AM-08:30 AM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 12:30:00 |  |  |  |  |  |  |  |  | 12:00:00 | 12:30:00 |  |  |  |  |  |  |  |  | Advisor 17
 | 08:30 AM-09:00 AM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 12:30:00 | 13:00:00 |  |  |  |  |  |  |  |  | 12:30:00 | 13:00:00 |  |  |  |  |  |  |  |  | Advisor 18
 | 09:00 AM-09:30 AM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 13:30:00 |  |  |  |  |  |  |  |  | 13:00:00 | 13:30:00 |  |  |  |  |  |  |  |  | Advisor 19
 | 09:30 AM-10:00 AM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 13:30:00 | 14:00:00 |  |  |  |  |  |  |  |  | 13:30:00 | 14:00:00 |  |  |  |  |  |  |  |  | Advisor 20
 | 10:00 AM-10:30 AM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 14:30:00 |  |  |  |  |  |  |  |  | 14:00:00 | 14:30:00
 | 10:30 AM-11:00 AM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 14:30:00 | 15:00:00 |  |  |  |  |  |  |  |  | 14:30:00 | 15:00:00
 | 11:00 AM-11:30 AM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00 |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00
 | 11:30 AM-12:00 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 16:00:00 |  |  |  |  |  |  |  |  | 15:30:00 | 16:00:00
 | 12:00 PM-12:30 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 16:30:00 |  |  |  |  |  |  |  |  | 16:00:00 | 16:30:00
 | 12:30 PM-01:00 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 16:30:00 | 17:00:00 |  |  |  |  |  |  |  |  | 16:30:00 | 17:00:00
 | 01:00 PM-01:30 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 17:00:00 | 17:30:00 |  |  |  |  |  |  |  |  | 17:00:00 | 17:30:00
 | 01:30 PM-02:00 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 18:00:00 |  |  |  |  |  |  |  |  | 17:30:00 | 18:00:00
 | 02:00 PM-02:30 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 18:00:00 | 18:30:00 |  |  |  |  |  |  |  |  | 18:00:00 | 18:30:00
 | 02:30 PM-03:00 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 18:30:00 | 19:00:00 |  |  |  |  |  |  |  |  | 18:30:00 | 19:00:00
 | 03:00 PM-03:30 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 19:00:00 | 19:30:00 |  |  |  |  |  |  |  |  | 19:00:00 | 19:30:00
 | 03:30 PM-04:00 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 19:30:00 | 20:00:00 |  |  |  |  |  |  |  |  | 19:30:00 | 20:00:00
 | 04:00 PM-04:30 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 20:00:00 | 20:30:00 |  |  |  |  |  |  |  |  | 20:00:00 | 20:30:00
 | 04:30 PM-05:00 PM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 20:30:00 | 21:00:00 |  |  |  |  |  |  |  |  | 20:30:00 | 21:00:00
 | 05:00 PM-05:30 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 21:00:00 | 21:30:00 |  |  |  |  |  |  |  |  | 21:00:00 | 21:30:00
 | 05:30 PM-06:00 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 21:30:00 | 22:00:00 |  |  |  |  |  |  |  |  | 21:30:00 | 22:00:00
 | 06:00 PM-06:30 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 22:30:00 |  |  |  |  |  |  |  |  | 22:00:00 | 22:30:00
 | 06:30 PM-07:00 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 22:30:00 | 23:00:00 |  |  |  |  |  |  |  |  | 22:30:00 | 23:00:00
 | 07:00 PM-07:30 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 23:30:00 |  |  |  |  |  |  |  |  | 23:00:00 | 23:30:00
 | 07:30 PM-08:00 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 23:30:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | 23:30:00 | 1900-01-01 00:00:00
 | 08:00 PM-08:30 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:30:00
 | 08:30 PM-09:00 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 |  |  |  |  |  |  |  |  | 1900-01-01 00:30:00 | 1900-01-01 01:00:00
 | 09:00 PM-09:30 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00 | 1900-01-01 01:30:00
 | 09:30 PM-10:00 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:30:00 | 1900-01-01 02:00:00 |  |  |  |  |  |  |  |  | 1900-01-01 01:30:00 | 1900-01-01 02:00:00
 | 10:00 PM-10:30 PM |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00 | 1900-01-01 02:30:00 |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00 | 1900-01-01 02:30:00
 | 10:30 PM-11:00 PM |  | 5 | 0 | 0 | 0 | 0 | 0 | 5 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:30:00 | 1900-01-01 03:00:00 |  |  |  |  |  |  |  |  | 1900-01-01 02:30:00 | 1900-01-01 03:00:00
 | 11:00 PM-11:30 PM |  | 5 | 0 | 0 | 0 | 0 | 0 | 5 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 | 1900-01-01 03:30:00 |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 | 1900-01-01 03:30:00
 | 11:30 PM-12:00 AM |  | 5 | 0 | 0 | 0 | 0 | 0 | 5 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:30:00 | 04:00:00 |  |  |  |  |  |  |  |  | 1900-01-01 03:30:00 | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1 | E2 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Usable Seats |  | 139 | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Online HC