Sample Data.xlsx

	A	B	C	D	E	F	G	H	I
1	Index	sitename	category	clearoccurrence	firstoccurrence	isSiteDown	acMainsFailure	lowVoltage	Region
2	1	AAB807	Low Voltage	12/13/22 19:33	12/13/22 19:00	no	1/1/70 5:00	1/1/70 5:00	North-1
3	2	AAB807	AC Mains Failure	12/13/22 19:33	12/13/22 19:01	no	1/1/70 5:00	12/13/22 19:00	North-1
4	3	AAB807	Site Down	12/13/22 19:22	12/13/22 19:02	no	12/13/22 19:00	12/13/22 19:01	North-1
5	4	AAB807	AC Mains Failure	12/14/22 12:18	12/14/22 11:03	no	12/13/22 19:01	12/13/22 19:02	North-1
6		AAB807	Low Voltage	12/14/22 12:18	12/14/22 11:04	no	12/13/22 19:02	12/14/22 11:03	North-1
7		AAB807	Site Down	12/14/22 12:06	12/14/22 11:06	yes	12/14/22 11:03	12/14/22 11:04	North-1
8		AAB807	Low Voltage	12/14/22 14:33	12/14/22 14:13	no	12/14/22 11:04	12/14/22 11:06	North-1
9		AAB807	AC Mains Failure	12/14/22 14:33	12/14/22 14:13	no	12/14/22 11:06	12/14/22 14:13	North-1
10		AAB807	Site Down	12/14/22 14:22	12/14/22 14:15	no	12/14/22 14:13	12/14/22 14:13	North-1
11		AAB807	Low Voltage	12/15/22 14:19	12/15/22 14:17	no	12/14/22 14:13	12/14/22 14:15	North-1
12		AAST01	Site Down	12/13/22 11:18	12/13/22 11:10	no	12/14/22 14:15	12/15/22 14:17	North-1
13		AAST01	AC Mains Failure	12/13/22 14:07	12/13/22 12:13	no	12/15/22 14:17	12/13/22 11:10	North-1
14		AAST01	Site Down	12/13/22 12:50	12/13/22 12:48	no	12/13/22 11:10	12/13/22 12:13	North-1
15		AAST01	AC Mains Failure	12/13/22 18:02	12/13/22 17:50	no	12/13/22 12:13	12/13/22 12:48	North-1
16		AAST01	AC Mains Failure	12/13/22 18:46	12/13/22 18:22	no	12/13/22 12:48	12/13/22 17:50	North-1
17		AAST01	AC Mains Failure	12/14/22 8:23	12/13/22 21:02	no	12/13/22 17:50	12/13/22 18:22	North-1
18		AAST01	AC Mains Failure	12/14/22 8:52	12/14/22 8:39	no	12/13/22 18:22	12/13/22 21:02	North-1
19		AAST01	AC Mains Failure	12/14/22 16:22	12/14/22 15:47	no	12/13/22 21:02	12/14/22 8:39	North-1
20		AAST01	AC Mains Failure	12/15/22 10:41	12/15/22 8:57	no	12/14/22 8:39	12/14/22 15:47	North-1
21		AAST01	AC Mains Failure	12/15/22 16:03	12/15/22 15:52	no	12/14/22 15:47	12/15/22 8:57	North-1
22		AAUS01	Site Down	12/13/22 16:56	12/13/22 16:55	no	12/15/22 8:57	12/15/22 15:52	North-1
23		AAUS01	AC Mains Failure	12/14/22 2:38	12/14/22 2:22	no	12/15/22 15:52	12/13/22 16:55	North-1
24		AAUS01	AC Mains Failure	12/14/22 10:18	12/14/22 10:11	no	12/13/22 16:55	12/14/22 2:22	North-1
25		AAUS02	Site Down	12/13/22 16:56	12/13/22 16:55	no	12/14/22 2:22	12/14/22 10:11	North-1
26		ABCH15	Site Down	12/14/22 11:36	12/14/22 11:35	no	12/14/22 10:11	12/13/22 16:55
27		ABCH15	Site Down	12/14/22 15:29	12/14/22 15:28	no	12/13/22 16:55	12/14/22 11:35
28		ABCH15	AC Mains Failure	12/15/22 8:41	12/15/22 6:37	no	12/14/22 11:35	12/14/22 15:28
29		ABCH15	AC Mains Failure		12/15/22 9:44	no	12/14/22 15:28	12/15/22 6:37
30		ABGH04	Site Down	12/15/22 8:41	12/15/22 7:49	no	12/15/22 6:37	12/15/22 9:44	North-1
31		ABGH05	Site Down	12/13/22 15:03	12/13/22 12:08	no	12/15/22 9:44	12/15/22 7:49	North-1
32		ABGH05	Site Down	12/14/22 9:36	12/14/22 8:38	no	12/15/22 7:49	12/13/22 12:08	North-1
33		ABGH05	Site Down	12/14/22 12:52	12/14/22 11:54	no	12/13/22 12:08	12/14/22 8:38	North-1
34		ABGH05	Site Down	12/14/22 17:02	12/14/22 16:58	no	12/14/22 8:38	12/14/22 11:54	North-1
35		ABGH05	Site Down	12/14/22 18:01	12/14/22 17:47	no	12/14/22 11:54	12/14/22 16:58	North-1
36		ABGH05	Site Down	12/15/22 5:59	12/15/22 3:38	no	12/14/22 16:58	12/14/22 17:47	North-1
37		ABGH05	Site Down	12/15/22 8:15	12/15/22 7:42	no	12/14/22 17:47	12/15/22 3:38	North-1
38		ABGH05	Site Down	12/15/22 9:29	12/15/22 9:17	no	12/15/22 3:38	12/15/22 7:42	North-1
39		ABGH05	Site Down	12/15/22 9:57	12/15/22 9:50	no	12/15/22 7:42	12/15/22 9:17	North-1
40		ABGH05	Site Down	12/15/22 10:48	12/15/22 10:44	no	12/15/22 9:17	12/15/22 9:50	North-1
41		ABGH06	AC Mains Failure	12/13/22 13:18	12/13/22 11:58	no	12/15/22 9:50	12/15/22 10:44	North-1
42		ABGH06	Site Down	12/13/22 14:50	12/13/22 12:19	no	12/15/22 10:44	12/13/22 11:58	North-1
43		ABGH09	Site Down	12/13/22 14:20	12/13/22 14:19	no	12/13/22 11:58	12/13/22 12:19	North-1
44		ABGH09	Site Down	12/13/22 15:52	12/13/22 15:51	no	12/13/22 12:19	12/13/22 14:19	North-1
45		ABGH09	Site Down	12/13/22 16:56	12/13/22 16:55	no	12/13/22 14:19	12/13/22 15:51	North-1
46		ABGH10	Site Down	12/13/22 16:46	12/13/22 15:08	no	12/13/22 15:51	12/13/22 16:55	North-1
47		ABGH11	Site Down	12/13/22 12:10	12/13/22 12:04	no	12/13/22 16:55	12/13/22 15:08	North-1
48		ABGH11	AC Mains Failure	12/14/22 9:20	12/14/22 8:38	no	12/13/22 15:08	12/13/22 12:04	North-1
49		ABGH11	Low Voltage	12/14/22 9:21	12/14/22 9:02	no	12/13/22 12:04	12/14/22 8:38	North-1
50		ABGH11	AC Mains Failure	12/14/22 15:19	12/14/22 10:04	no	12/14/22 8:38	12/14/22 9:02	North-1
51		ABGH11	Low Voltage	12/14/22 15:19	12/14/22 10:06	no	12/14/22 9:02	12/14/22 10:04	North-1
52		ABGH11	Site Down	12/14/22 15:07	12/14/22 11:22	yes	12/14/22 10:04	12/14/22 10:06	North-1
53		ABGH11	AC Mains Failure	12/14/22 17:00	12/14/22 16:58	no	12/14/22 10:06	12/14/22 11:22	North-1
54		ABGH11	AC Mains Failure	12/15/22 9:52	12/15/22 9:50	no	12/14/22 11:22	12/14/22 16:58	North-1
55		ABGH11	AC Mains Failure	12/15/22 16:16	12/15/22 16:15	no	12/14/22 16:58	12/15/22 9:50	North-1
56		ABGH13	Site Down	12/13/22 14:20	12/13/22 14:19	no	12/15/22 9:50	12/15/22 16:15	North-1
57		ABGH13	AC Mains Failure	12/13/22 15:30	12/13/22 15:12	no	12/15/22 16:15	12/13/22 14:19	North-1
58		ABGH13	Site Down	12/13/22 15:52	12/13/22 15:51	no	12/13/22 14:19	12/13/22 15:12	North-1
59		ABGH13	Site Down	12/13/22 16:56	12/13/22 16:55	no	12/13/22 15:12	12/13/22 15:51	North-1
60		ABGH13	AC Mains Failure	12/13/22 20:07	12/13/22 20:02	no	12/13/22 15:51	12/13/22 16:55	North-1
61		ABGH13	AC Mains Failure	12/14/22 9:21	12/14/22 8:39	no	12/13/22 16:55	12/13/22 20:02	North-1
62		ABGH13	AC Mains Failure	12/14/22 14:13	12/14/22 10:32	no	12/13/22 20:02	12/14/22 8:39	North-1
63		ABGH13	Site Down	12/14/22 15:18	12/14/22 15:14	no	12/14/22 8:39	12/14/22 10:32	North-1
64		ABGH13	Low Voltage	12/15/22 9:25	12/15/22 5:16	no	12/14/22 10:32	12/14/22 15:14	North-1
65		ABGH13	Site Down	12/15/22 9:13	12/15/22 6:35	no	12/14/22 15:14	12/15/22 5:16	North-1
66		ABGH13	AC Mains Failure	12/15/22 9:55	12/15/22 9:51	no	12/15/22 5:16	12/15/22 6:35	North-1
67		ABGH13	AC Mains Failure	12/15/22 15:03	12/15/22 13:14	no	12/15/22 6:35	12/15/22 9:51	North-1
68		ABGH14	Site Down	12/15/22 5:59	12/15/22 4:50	no	12/15/22 9:51	12/15/22 13:14	North-1
69		ABGH14	Site Down	12/15/22 8:15	12/15/22 8:01	no	12/15/22 13:14	12/15/22 4:50	North-1
70		ABGH17	Site Down	12/14/22 17:28	12/14/22 17:22	no	12/15/22 4:50	12/15/22 8:01	North-1
71		ABGH18	Site Down	12/13/22 12:10	12/13/22 12:04	no	12/15/22 8:01	12/14/22 17:22	North-1
72		ABGH18	AC Mains Failure	12/13/22 14:40	12/13/22 14:35	no	12/14/22 17:22	12/13/22 12:04	North-1
73		ABGH18	AC Mains Failure	12/13/22 18:33	12/13/22 18:25	no	12/13/22 12:04	12/13/22 14:35	North-1
74		ABGH18	AC Mains Failure	12/14/22 9:38	12/14/22 9:37	no	12/13/22 14:35	12/13/22 18:25	North-1
75		ABGH18	Site Down	12/14/22 15:07	12/14/22 11:22	no	12/13/22 18:25	12/14/22 9:37	North-1
76		ABGH18	AC Mains Failure	12/15/22 15:11	12/15/22 9:58	no	12/14/22 9:37	12/14/22 11:22	North-1
77		ABGH18	AC Mains Failure	12/15/22 16:17	12/15/22 16:15	no	12/14/22 11:22	12/15/22 9:58	North-1
78		ABGH19	Site Down	12/14/22 20:09	12/14/22 20:00	no	12/15/22 9:58	12/15/22 16:15	North-1
79		ABGH19	AC Mains Failure		12/14/22 20:14	no	12/15/22 16:15	12/14/22 20:00	North-1
80		ABGH21	Site Down	12/15/22 7:55	12/15/22 7:37	no	12/14/22 20:00	12/14/22 20:14	North-1
81		ABJR01	Low Voltage	12/13/22 15:30	12/13/22 15:21	no	12/14/22 20:14	12/15/22 7:37	North-1
82		ABJR01	Low Voltage	12/13/22 16:53	12/13/22 16:47	no	12/15/22 7:37	12/13/22 15:21	North-1
83		ABJR01	Site Down	12/14/22 7:05	12/14/22 6:00	no	12/13/22 15:21	12/13/22 16:47	North-1
84		ABJR01	Low Voltage	12/15/22 5:57	12/15/22 5:52	no	12/13/22 16:47	12/14/22 6:00	North-1
85		ABJR01	Low Voltage	12/15/22 8:09	12/15/22 8:05	no	12/14/22 6:00	12/15/22 5:52	North-1
86		ABJR01	Low Voltage	12/15/22 10:27	12/15/22 10:24	no	12/15/22 5:52	12/15/22 8:05	North-1
87		ABJR02	AC Mains Failure	12/13/22 13:48	12/13/22 12:41	no	12/15/22 8:05	12/15/22 10:24	North-1
88		ABJR02	Site Down	12/14/22 7:06	12/14/22 6:00	no	12/15/22 10:24	12/13/22 12:41	North-1
89		ABJR02	AC Mains Failure	12/14/22 11:01	12/14/22 10:53	no	12/13/22 12:41	12/14/22 6:00	North-1
90		ABJR02	AC Mains Failure	12/15/22 6:22	12/15/22 5:53	no	12/14/22 6:00	12/14/22 10:53	North-1
91		ABJR02	AC Mains Failure	12/15/22 8:22	12/15/22 8:05	no	12/14/22 10:53	12/15/22 5:53	North-1
92		ABJR04	Site Down	12/14/22 7:06	12/14/22 6:00	no	12/15/22 5:53	12/15/22 8:05	North-1
93		ABJR06	AC Mains Failure	12/13/22 13:44	12/13/22 12:43	no	12/15/22 8:05	12/14/22 6:00	North-1
94		ABJR06	Site Down	12/14/22 7:17	12/14/22 6:00	no	12/14/22 6:00	12/13/22 12:43	North-1
95		ABJR06	AC Mains Failure	12/14/22 10:59	12/14/22 10:55	no	12/13/22 12:43	12/14/22 6:00	North-1
96		ABJR06	AC Mains Failure	12/15/22 6:21	12/15/22 5:55	no	12/14/22 6:00	12/14/22 10:55	North-1
97		ABLR02	Site Down	12/15/22 6:22	12/15/22 5:52	no	12/14/22 10:55	12/15/22 5:55	North-1
98		ABLR02	Site Down	12/15/22 8:22	12/15/22 8:04	no	12/15/22 5:55	12/15/22 5:52	North-1
99		ABM001	Site Down	12/14/22 17:42	12/14/22 17:32	no	12/15/22 5:52	12/15/22 8:04	North-1
100		ABM001	AC Mains Failure	12/15/22 6:35	12/15/22 5:52	no	12/15/22 8:04	12/14/22 17:32	North-1