Spreadsheet: 674838d1588053444-figure-out-occurence-of-overlapping-date-and-time-pump_reliability_trending
Sheet: Pump Reliability Trending

Pump ID | Out of Service  Start Time  ([NAME] hh:[NAME]) | Out of Service  End Time  ([NAME] hh:[NAME]) | OOS Time (hh:[NAME]) | Overlap?  (TRUE/FALSE) | Maximum Overlapping Pump OOS Events | Maximum Simultaneous Overlapping Pump OOS Events |  | Cumulative Time with ONE (1) Pump OOS (hh:[NAME]) |  | Cumulative Time with TWO (2) Pumps Simultaneously OOS (hh:[NAME]) |  | Cumulative Time with THREE (3) Pumps Simultaneously OOS (hh:[NAME]) |  | Cumulative Time with FOUR (4) Pumps Simultaneously OOS (hh:[NAME]) |  | Cumulative Time with FIVE (5) Pumps Simultaneously OOS (hh:[NAME])
Pump 2 | 2017-01-03 08:31:00 | 2017-01-03 17:11:00
Pump 2 | 2017-01-04 08:52:00 | 2017-01-04 12:25:00
Pump 5 | 2017-01-31 00:00:00 | 2017-03-03 00:00:00
Pump 3 | 2017-02-14 10:24:00 | 2017-02-14 16:51:00
Pump 4 | 2017-02-14 10:24:00 | 2017-02-14 16:51:00
Pump 6 | 2017-03-02 00:00:00 | 2017-04-17 00:00:00 |  |  |  |  |  | OOS = Out of Service
Pump 5 | 2017-03-16 08:48:00 | 2017-03-16 14:13:00
Pump 4 | 2017-04-02 16:10:00 | 2017-05-18 13:40:00
Pump 6 | 2017-04-15 08:48:00 | 2017-04-30 14:13:00
Pump 4 | 2017-04-27 09:50:00 | 2017-05-18 13:40:00
Pump 5 | 2017-05-21 16:00:00 | 2017-05-24 13:19:00
Pump 5 | 2017-06-01 08:30:00 | 2017-06-07 15:45:00
Pump 6 | 2017-06-20 16:00:00 | 2017-07-08 13:19:00
Pump 6 | 2017-07-01 08:30:00 | 2017-07-22 15:45:00
Pump 5 | 2017-07-06 08:20:00 | 2017-10-31 08:20:00
Pump 6 | 2017-08-05 08:20:00 | 2017-12-15 08:20:00
Pump 4 | 2017-08-10 00:00:00 | 2017-09-14 00:00:00
Pump 5 | 2017-11-25 07:32:00 | 2017-11-25 13:16:00
Pump 5 | 2017-12-04 13:42:00 | 2017-12-04 14:04:00
Pump 5 | 2017-12-06 00:15:00 | 2017-12-07 12:45:00
Pump 5 | 2017-12-10 12:00:00 | 2017-12-14 10:14:00
Pump 5 | 2017-12-13 14:41:00 | 2017-12-13 15:14:00
Pump 6 | 2017-12-25 07:32:00 | 2018-01-09 13:16:00
Pump 6 | 2018-01-03 13:42:00 | 2018-01-18 14:04:00
Pump 6 | 2018-01-05 00:15:00 | 2018-01-21 12:45:00
Pump 6 | 2018-01-09 12:00:00 | 2018-01-28 10:14:00
Pump 6 | 2018-01-12 14:41:00 | 2018-01-27 15:14:00
Pump 4 | 2018-02-28 12:35:00 | 2018-02-28 22:43:00
Pump 5 | 2018-02-28 20:35:00 | 2018-02-28 20:53:00
Pump 5 | 2018-02-28 20:56:00 | 2018-02-28 21:13:00
Pump 5 | 2018-03-06 20:25:00 | 2018-03-10 12:22:00
Pump 5 | 2018-03-12 19:59:00 | 2018-03-12 20:47:00
Pump 3 | 2018-03-21 13:25:00 | 2018-03-21 16:34:00
Pump 5 | 2018-03-25 11:15:00 | 2018-04-04 13:00:00
Pump 6 | 2018-03-30 20:35:00 | 2018-04-14 20:53:00
Pump 6 | 2018-03-30 20:56:00 | 2018-04-14 21:13:00
Pump 6 | 2018-04-05 20:25:00 | 2018-04-24 12:22:00
Pump 6 | 2018-04-11 19:59:00 | 2018-04-26 20:47:00
Pump 6 | 2018-04-24 11:15:00 | 2018-05-19 13:00:00
Pump 5 | 2018-05-08 08:50:00 | 2018-05-10 07:20:00
Pump 5 | 2018-05-21 03:13:00 | 2018-05-28 10:46:00
Pump 1 | 2018-06-05 08:30:00 | 2018-06-05 11:22:00
Pump 5 | 2018-06-06 07:00:00 | 2018-06-06 07:55:00
Pump 6 | 2018-06-07 08:50:00 | 2018-06-24 07:20:00
Pump 5 | 2018-06-12 10:55:00 | 2018-06-12 12:41:00
Pump 6 | 2018-06-20 03:13:00 | 2018-07-12 10:46:00
Pump 6 | 2018-07-06 07:00:00 | 2018-07-21 07:55:00
Pump 6 | 2018-07-12 10:55:00 | 2018-07-27 12:41:00
Pump 5 | 2018-11-08 10:48:00 | 2018-11-21 16:13:00
Pump 5 | 2018-12-04 12:55:00 | 2018-12-06 23:30:00
Pump 6 | 2018-12-08 10:48:00 | 2019-01-05 16:13:00
Pump 5 | 2018-12-10 10:23:00 | 2018-12-10 11:27:00
Pump 6 | 2019-01-03 12:55:00 | 2019-01-20 23:30:00
Pump 1 | 2019-01-08 14:46:00 | 2019-01-22 05:30:00
Pump 2 | 2019-01-08 14:46:00 | 2019-01-22 05:30:00
Pump 3 | 2019-01-08 14:46:00 | 2019-01-22 05:30:00
Pump 4 | 2019-01-08 14:46:00 | 2019-01-22 05:30:00
Pump 6 | 2019-01-09 10:23:00 | 2019-01-24 11:27:00
Pump 5 | 2019-01-13 01:38:00 | 2019-01-16 09:08:00
Pump 4 | 2019-01-25 17:25:00 | 2019-01-25 22:10:00
Pump 1 | 2019-01-25 22:16:00 | 2019-01-27 08:00:00
Pump 2 | 2019-01-25 22:16:00 | 2019-01-27 08:00:00
Pump 3 | 2019-01-25 22:16:00 | 2019-01-27 08:00:00
Pump 4 | 2019-01-25 22:16:00 | 2019-01-27 08:00:00
Pump 5 | 2019-02-01 00:34:00 | 2019-02-01 01:48:00
Pump 5 | 2019-02-01 01:49:00 | 2019-02-01 02:30:00
Pump 3 | 2019-02-02 13:20:00 | 2019-02-02 15:47:00
Pump 5 | 2019-02-04 20:25:00 | 2019-02-04 22:09:00
Pump 2 | 2019-02-07 11:36:00 | 2019-02-10 04:40:00
Pump 6 | 2019-02-12 01:38:00 | 2019-03-02 09:08:00
Pump 5 | 2019-02-13 12:31:00 | 2019-02-13 13:27:00
Pump 6 | 2019-03-03 00:34:00 | 2019-03-18 01:48:00
Pump 6 | 2019-03-03 01:49:00 | 2019-03-18 02:30:00
Pump 4 | 2019-03-06 11:02:00 | 2019-03-07 14:03:00
Pump 6 | 2019-03-06 20:25:00 | 2019-03-21 22:09:00
Pump 6 | 2019-03-15 12:31:00 | 2019-03-30 13:27:00
Pump 5 | 2019-04-12 21:47:00 | 2019-04-13 04:25:00
Pump 5 | 2019-04-15 13:50:00 | 2019-04-15 14:27:00
Pump 5 | 2019-04-16 10:48:00 | 2019-07-08 00:00:00
Pump 5 | 2019-04-17 13:50:00 | 2019-04-18 13:46:00
Pump 6 | 2019-05-12 21:47:00 | 2019-05-28 04:25:00
Pump 6 | 2019-05-15 13:50:00 | 2019-05-30 14:27:00
Pump 6 | 2019-05-16 10:48:00 | 2019-08-22 00:00:00
Pump 6 | 2019-05-17 13:50:00 | 2019-06-02 13:46:00
Pump 5 | 2019-05-24 08:35:00 | 2019-05-24 16:09:00
Pump 5 | 2019-05-25 12:25:00 | 2019-06-22 00:00:00
Pump 1 | 2019-06-03 09:25:00 | 2019-06-03 13:30:00
Pump 6 | 2019-06-23 08:35:00 | 2019-07-08 16:09:00
Pump 6 | 2019-06-24 12:25:00 | 2019-08-06 00:00:00
Pump 5 | 2019-06-26 00:00:00 | 2019-07-03 00:00:00
Pump 5 | 2019-06-26 00:00:00 | 2019-07-09 00:00:00
Pump 6 | 2019-07-26 00:00:00 | 2019-08-17 00:00:00
Pump 6 | 2019-07-26 00:00:00 | 2019-08-23 00:00:00
Pump 5 | 2019-09-04 09:05:00 | 2019-09-14 16:02:00
Pump 5 | 2019-09-09 13:15:00 | 2019-11-25 12:56:00
Pump 6 | 2019-10-04 09:05:00 | 2019-10-29 16:02:00
Pump 6 | 2019-10-09 13:15:00 | 2020-01-09 12:56:00
Pump 5 | 2019-11-18 12:50:00 | 2019-11-18 13:30:00
Pump 5 | 2019-12-04 08:06:00 | 2019-12-04 09:30:00
Pump 1 | 2019-12-05 08:23:00 | 2019-12-05 10:37:00
Pump 2 | 2019-12-05 08:23:00 | 2019-12-05 10:37:00
Pump 3 | 2019-12-05 08:23:00 | 2019-12-05 10:37:00
Pump 4 | 2019-12-05 08:23:00 | 2019-12-05 10:37:00
Pump 5 | 2019-12-09 02:23:00 | 2019-12-11 13:45:00
Pump 6 | 2019-12-18 12:50:00 | 2020-01-02 13:30:00
Pump 6 | 2020-01-03 08:06:00 | 2020-01-18 09:30:00
Pump 6 | 2020-01-08 02:23:00 | 2020-01-25 13:45:00
Pump 3 | 2020-02-05 08:29:00 | 2020-02-05 16:24:00
Pump 4 | 2020-02-05 08:29:00 | 2020-02-05 16:24:00