data sample.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	CaseNo	Status	CaseType L1	CaseType L2	CaseType L3	AuthorityNotified	InvestigationLevel	RiskArea Int	_Calculated_ProcessingDays	_Calculated_InvestigationStatus	_Calculated_InvestigationStart	_Calculated_InvestigationLevelCheck	_Calculated_SimplifiedInvestigationCheck	_Calculated_CausesCheck	_Calculated_ActionMitigateCausesCheck	_Calculated_FirstApprovalDate	_Calculated_LastApprovalDate	_Calculated_MOCPersonnelApprovalCheck	_Calculated_AuthorityNotifiedCheck	ChecklistCategory	_Calculated_QualityCheck	_Calculated_InvolvedPersonsCheck	ToENo	CaseDateAndTime	_Calculated_AllActionsClosed	_Calculated_InvestigationLeaderCheck	_Calculated_ToeCheck
2	27088	Registered	HSE Incident	Accident	Accident	Authority not Notified	Level 3	3	10	On time		Investigation Level correct	Not applicable	All causes selected	Missing action for cause				Authority Notified correct			Involved Persons Added		7/21/24 0:00	All actions closed	Team Leader not defined	ToE not required
3	27060	Approved	Quality incident	Near miss	Near miss	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Can be simplified Investigation			7/22/24 16:49	7/22/24 16:49		Authority Notified correct			Involved Persons Added		7/21/24 0:00	All actions closed	Team Leader defined	ToE not required
4	27047	Approved	Quality incident	Near miss	Near miss	Authority not Notified	Level 1	3		Concluded		Investigation Level correct	Not applicable			7/21/24 20:14	7/21/24 20:14		Authority Notified correct			Involved Persons Added		7/20/24 0:00	All actions closed	Team Leader not defined	Mandatory ToE pending
5	27029	Approved	Quality incident	Accident	Accident		Level 3	3		Concluded		Investigation Level Incorrect	Simplified Investigation Incorrect			7/24/24 6:43	7/24/24 6:43		Authority Notified correct		Quality Check	Involved Persons Added		7/20/24 0:00	All actions closed	Team Leader defined	ToE not required
6	27026	Processing	HSE Incident	Near miss	Near miss	Authority not Notified	Level 3	3	12	On time		Investigation Level correct	Not applicable	Selected causes incomplete	Waiting for causes				Authority Notified correct			No Involved Persons added		7/18/24 0:00	All actions closed	Team Leader not defined	ToE not required
7	27010	Registered	Quality incident	Accident	Accident	Authority not Notified	Level 2	3	13	On time		Investigation Level correct	Not applicable	Selected causes incomplete	Missing action for cause				Authority Notified correct			Involved Persons Added		7/18/24 0:00	All actions closed	Team Leader defined	Mandatory ToE pending
8	27006	Registered	Quality incident	Accident	Accident	Authority not Notified	Level 3	3	13	On time		Investigation Level correct	Simplified Investigation Correct	Selected causes incomplete	Waiting for causes				Authority Notified correct			Involved Persons Added		7/18/24 0:00	All actions closed	Team Leader not defined	ToE not required
9	26956	Processing	HSE Incident	Near miss	Near miss		Level 1	1	16	Due this week		Investigation Level correct	Not applicable	Selected causes incomplete	Missing action for cause				Authority Notified correct			Involved Persons Added		7/16/24 0:00	All actions closed	Team Leader defined	Mandatory ToE pending
10	26951	Processing	Quality incident	Accident	Accident	Authority not Notified	Level 2	3	16	Due this week		Investigation Level correct	Not applicable	All causes selected	Actions to mitigate cause correct				Error on Authority Notified		Quality Check	Involved Persons Added		7/16/24 0:00	All actions closed	Team Leader defined	Mandatory ToE pending
11	26922	Processing	Quality incident	Near miss	Near miss	Authority not Notified	Level 3	3	18	Due this week		Investigation Level correct	Can be simplified Investigation	Selected causes incomplete	Waiting for causes				Authority Notified correct			Involved Persons Added		7/13/24 0:00		Team Leader defined	ToE not required
12	26900	Registered	Quality incident	Accident	Accident	Authority not Notified	Level 3	3	18	Due this week		Investigation Level correct	Simplified Investigation Correct	Selected causes incomplete	Waiting for causes				Authority Notified correct			Involved Persons Added		7/12/24 0:00	All actions closed	Team Leader not defined	ToE not required
13	26878	Approved	Quality incident	Near miss	Near miss	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Can be simplified Investigation			7/15/24 6:43	7/15/24 6:43		Authority Notified correct			Involved Persons Added		7/13/24 0:00	All actions closed	Team Leader defined	ToE not required
14	26874	Registered	HSE Incident	Accident	Accident	Authority Notified	Level 2	3	19	Due this week		Investigation Level correct	Not applicable	All causes selected	Missing action for cause				Authority Notified correct			Involved Persons Added		7/13/24 0:00	All actions closed	Team Leader not defined	Mandatory ToE pending
15	26765	Approved	HSE Incident	Near miss	Near miss	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Not applicable			7/8/24 19:58	7/8/24 19:58		Error on Authority Notified		Quality Check	Involved Persons Added		7/7/24 0:00		Team Leader defined	ToE not required
16	26763	Processing	HSE Incident	Accident	Accident	Authority not Notified	Level 3	3	25	Overdue		Investigation Level correct	Not applicable	All causes selected	Missing action for cause				Authority Notified correct			Involved Persons Added		7/7/24 0:00	All actions closed	Team Leader defined	ToE not required
17	26762	Approved	Quality incident	Near miss	Near miss	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Can be simplified Investigation			7/17/24 12:09	7/17/24 12:09		Authority Notified correct			Involved Persons Added		7/7/24 0:00	All actions closed	Team Leader not defined	ToE not required
18	26738	Processing	HSE Incident	Accident	Accident	Authority not Notified	Level 3	3	26	Overdue		Investigation Level correct	Not applicable	Selected causes incomplete	Missing action for cause				Authority Notified correct			Involved Persons Added		7/6/24 0:00	All actions closed	Team Leader defined	ToE not required
19	26710	Processing	HSE Incident	Accident	Accident	Authority not Notified	Level 3	3	28	Overdue		Investigation Level correct	Not applicable	Selected causes incomplete	Waiting for causes				Authority Notified correct			Involved Persons Added		7/4/24 0:00	All actions closed	Team Leader defined	ToE not required
20	26645	Approved	Quality incident	Accident	Accident	Authority Notified	Level 2	2		Concluded		Investigation Level correct	Not applicable			7/11/24 6:03	7/11/24 6:03		Authority Notified correct			Involved Persons Added		6/30/24 0:00	All actions closed	Team Leader defined	Mandatory ToE pending
21	26634	Processing	Quality incident	Accident	Accident	Authority not Notified	Level 3	3	31	Overdue		Investigation Level correct	Simplified Investigation Incorrect						Authority Notified correct			No Involved Persons added		6/30/24 0:00	All actions closed	Team Leader not defined	ToE not required
22	26628	Approved	Quality incident	Accident	Accident	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Simplified Investigation Incorrect			7/1/24 14:19	7/1/24 14:19		Authority Notified correct			Involved Persons Added		6/30/24 0:00	All actions closed	Team Leader defined	ToE not required
23	26608	Processing	Quality incident	Near miss	Near miss	Authority not Notified	Level 3	3	33	Overdue		Investigation Level correct	Simplified Investigation Correct						Authority Notified correct		Quality Check	Involved Persons Added		6/12/24 0:00	All actions closed	Team Leader defined	ToE not required
24	26576	Processing	HSE Incident	Near miss	Near miss	Authority not Notified	Level 3	3	34	Overdue		Investigation Level correct	Not applicable	All causes selected	Missing action for cause				Authority Notified correct			Involved Persons Added		6/28/24 0:00		Team Leader defined	ToE not required
25	26561	Processing	Quality incident	Accident	Accident	Authority not Notified	Level 3	3	35	Overdue		Investigation Level correct	Simplified Investigation Incorrect						Authority Notified correct			Involved Persons Added		6/24/24 0:00	All actions closed	Team Leader defined	ToE not required
26	26560	Approved	Quality incident	Accident	Accident	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Simplified Investigation Incorrect			6/27/24 10:50	6/27/24 10:50		Authority Notified correct			Involved Persons Added		6/26/24 0:00	All actions closed	Team Leader not defined	ToE not required
27	26559	Approved	Quality incident	Accident	Accident	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Simplified Investigation Correct			6/27/24 10:58	6/27/24 10:58		Authority Notified correct			Involved Persons Added		6/26/24 0:00	All actions closed	Team Leader defined	ToE not required
28	26558	Approved	Quality incident	Near miss	Near miss	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Simplified Investigation Correct			6/27/24 11:03	6/27/24 11:03		Authority Notified correct			Involved Persons Added		6/22/24 0:00	All actions closed	Team Leader defined	ToE not required
29	26547	Processing	HSE Incident	Near miss	Near miss	Authority not Notified	Level 3	3	37	Overdue		Investigation Level correct	Not applicable	Selected causes incomplete	Missing action for cause				Authority Notified correct			Involved Persons Added		6/24/24 0:00	All actions closed	Team Leader defined	ToE not required
30	26492	Processing	HSE Incident	Accident	Accident	Authority not Notified	Level 3	3	40	Overdue		Investigation Level correct	Not applicable	All causes selected	Actions to mitigate cause correct				Error on Authority Notified		Quality Check	Involved Persons Added		6/17/24 0:00		Team Leader defined	ToE not required
31	26445	Processing	Quality incident	Accident	Accident	Authority not Notified	Level 3	3	42	Overdue		Investigation Level correct	Simplified Investigation Correct	All causes selected	Actions to mitigate cause correct				Authority Notified correct			Involved Persons Added		6/20/24 0:00	All actions closed	Team Leader defined	ToE not required
32	26436	Approved	HSE Incident	Accident	Accident		Level 3	3		Concluded		Investigation Level correct	Not applicable			7/6/24 6:41	7/6/24 6:41		Authority Notified correct		Quality Check	Involved Persons Added	2024/013	6/19/24 0:00	All actions closed	Team Leader defined	Optional ToE issued
33	26388	Approved	HSE Incident	Accident	Accident	Authority not Notified	Level 3	3		Concluded		Investigation Level correct	Not applicable			6/23/24 8:02	6/23/24 8:02		Authority Notified correct			Involved Persons Added		6/17/24 0:00	All actions closed	Team Leader defined	ToE not required
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100