Grade book.xlsx

	A	B	C	D	E	F	H	I	J	K	M
1	Employee Performance Assessment and Analysis		Safety Test	Company Philosophy Test	Financial Skill Test	Drug Test	Safety Test	Company Philosophy Test	Financial Skill Test	Drug Test	Fire Employee
2		Possible Point	10	20	100	1
3	First Name	Last Name
4	Alex	Martinez	6	18	80	1	60%	90%	80%	100%	FALSE
5	William	Thomas	1	20	95	0	10%	100%	95%	0%	TRUE
6	Emily	Lee	8	8	87	1	80%	40%	87%	100%	TRUE
7	Mia	Jackson	10	17	94	1	100%	85%	94%	100%	FALSE
8	Daniel	Anderson	5	15	99	1	50%	75%	99%	100%	FALSE
9	Alex	Jackson	9	15	95	1	90%	75%	95%	100%	FALSE
10	Matthew	Taylor	6	12	91	1	60%	60%	91%	100%	FALSE
11	Daniel	Martinez	6	15	53	1	60%	75%	53%	100%	FALSE
12	John	Martinez	6	8	53	1	60%	40%	53%	100%	TRUE
13	Laura	Clark	6	17	53	1	60%	85%	53%	100%	FALSE
14	Chris	Thompson	6	12	76	1	60%	60%	76%	100%	FALSE
15	Robert	Robinson	8	19	76	1	80%	95%	76%	100%	FALSE
16	Emma	Walker	10	2	79	1	100%	10%	79%	100%	TRUE
17	William	Brown	11	20	79	1	110%	100%	79%	100%	FALSE
18	Sarah	Thompson	10	15	62	1	100%	75%	62%	100%	FALSE
19	Olivia	Smith	8	12	65	1	80%	60%	65%	100%	FALSE
20	John	Hall	8	12	65	1	80%	60%	65%	100%	FALSE
21	James	Hall	10	6	65	1	100%	30%	65%	100%	TRUE
22	David	Martinez	9	16	92	1	90%	80%	92%	100%	FALSE
23	Robert	Harris	0	7	0	1	0%	35%	0%	100%	TRUE
24
25
26	Max		11	20	99	1	110%	100%	99%	100%
27	Min		0	2	0	0	0%	10%	0%	0%
28	Average		7.15	13.3	72.95	0.95	72%	67%	73%	95%
29
30
31
32
33
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