Spreadsheet: 473921d1470495709-trying-to-analyze-complex-id-card-data-to-total-overtime-card-reader-raw-data-cmo
Sheet: Sheet1

2014-10-31 18:35:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-31 18:35:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-31 18:04:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-31 10:04:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-31 06:59:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-30 21:03:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-30 20:53:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-30 20:05:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-30 19:17:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-30 18:47:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-30 18:47:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-29 21:43:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-29 21:39:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-29 21:39:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-29 21:39:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-29 20:54:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-29 20:17:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-29 18:11:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-29 06:58:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-29 02:00:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-29 02:00:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-28 19:13:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-28 19:01:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-28 18:15:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-27 19:12:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-27 18:17:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-27 07:59:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-27 06:34:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-27 00:14:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-26 13:21:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-26 13:16:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-26 12:26:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-25 16:58:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-25 11:17:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-25 11:17:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-25 11:17:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-25 10:55:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-25 10:53:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-24 18:57:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-24 18:28:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-24 07:49:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-24 06:58:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-23 20:57:00 | [NAME] energy management 04, 90250227 | 90250227 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-23 20:09:00 | [NAME] energy management 04, 90250227 | 90250227 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-23 15:59:00 |  |  | N - CMO 3rd floor west energy managment | Fire door | Closed
2014-10-23 15:46:00 |  |  | N - CMO 3rd floor west energy managment | Fire door | Opened
2014-10-23 15:46:00 |  |  | N - CMO 3rd floor west energy managment | Fire door | Opened
2014-10-23 15:41:00 |  |  | N - CMO 3rd floor west energy managment | Fire door | Opened
2014-10-23 15:34:00 |  |  | N - CMO 3rd floor west energy managment | Fire door | Opened
2014-10-23 11:45:00 |  |  | N - CMO 3rd floor west energy managment | [NAME] | Alarm actioned by: System engineer
2014-10-23 11:36:00 |  |  | N - CMO 3rd floor west energy managment | ACU online
2014-10-23 11:30:00 |  |  | N - CMO 3rd floor west energy managment | ACU not responding | Alarm actioned by: System engineer
2014-10-22 22:16:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-22 20:41:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-21 20:40:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-21 20:37:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-21 19:40:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-21 18:33:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-20 19:12:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-20 18:37:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-20 14:52:00 |  |  | N - CMO 3rd floor west energy managment | ACU online
2014-10-20 14:47:00 |  |  | N - CMO 3rd floor west energy managment | ACU not responding | Alarm actioned by: System engineer
2014-10-20 14:35:00 |  |  | N - CMO 3rd floor west energy managment | [NAME] | Alarm actioned by: System engineer
2014-10-20 07:40:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-20 05:17:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-20 05:16:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-20 05:16:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-19 16:56:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-19 08:17:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-18 17:57:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-18 17:08:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-18 17:07:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-18 09:00:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-17 19:33:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-17 19:04:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-17 07:06:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-17 06:54:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-16 20:11:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-16 20:00:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-16 19:01:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-16 18:18:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-15 23:30:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-15 21:14:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-15 21:13:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-15 20:52:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-15 20:52:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-15 20:52:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-15 20:51:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-15 19:05:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-15 19:00:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-15 19:00:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-14 22:41:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-14 21:39:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-14 21:37:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-14 21:37:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-14 20:52:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-14 20:18:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-14 19:35:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-14 15:43:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-14 15:43:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-14 15:41:00 |  |  | N - CMO 3rd floor west energy managment | [NAME] | Alarm actioned by: System engineer
2014-10-13 20:26:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-13 20:26:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-13 19:14:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-13 18:18:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-13 14:59:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-12 14:56:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-11 18:02:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-11 07:35:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-11 07:35:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-11 07:34:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-10 20:18:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-10 20:04:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-09 20:55:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-09 20:22:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-09 06:41:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-08 21:27:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-08 20:07:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-08 06:50:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-07 19:53:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-07 19:12:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-06 19:20:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-06 18:55:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-06 18:44:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-06 18:44:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-05 18:00:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-05 12:17:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-05 11:09:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-05 10:42:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-05 10:40:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-05 10:40:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-05 10:40:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-05 10:39:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-04 18:41:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-04 16:35:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-04 16:33:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-04 09:52:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-04 09:19:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-03 18:52:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-03 18:22:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-03 08:46:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-02 18:59:00 | CMO energy management 05, 88096044 | 88096044 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-02 18:59:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-02 08:10:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-02 06:52:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-01 20:59:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | OFF
2014-10-01 20:09:00 | [NAME] energy management 05, 90230688 | 90230688 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON
2014-10-01 19:00:00 |  |  | N - CMO 3rd floor west energy managment | ACU online
2014-10-01 18:59:00 |  |  | N - CMO 3rd floor west energy managment | ACU not responding | Alarm actioned by: System engineer
2014-10-01 18:22:00 |  |  | N - CMO 3rd floor west energy managment | ACU online
2014-10-01 18:20:00 |  |  | N - CMO 3rd floor west energy managment | ACU not responding | Alarm actioned by: System engineer
2014-10-01 06:46:00 | CMO energy management 01, 88082981 | 88082981 | N - CMO 3rd floor west energy managment (In) | Relay toggled | ON