CSHP - Google Sheets

	A	B	C	D	E	F	H
1	Status	Rank	Name	Call-sign	Job	Date Acquired

2	Command Staff						* Leadership and Above Must be able to reach a minimum of 15 hours of shift work per week. *
3	Active	Colonel	M. Modez	5H-01	Dept. Head	12/22/2019
4	Active	Lieutenant Colonel	A.Whiskey	5H-02	Dept. Head	11/22/2019	Expectations Designed for your Rank
5	Active	Major	G. Mitchell	5H-03	Chief Of Staff	12/22/2019	Command Staff: Address internal concerns, handle promotions reports, lead by example.
6	Active	Deputy Major	C. Shilts	5H-04	Human Resources	12/22/2019	Management ~ Manage Supervisors & squad leaders, review applications, transfer requests
7	Vacant	Captain	R. Kusik	5H-05	Human Resources	12/22/2019	Supervisors ~ It is your job to keep the officers in check when on duty
8	Active	Captain	J. Manny	5H-06	Head Of Leadership	12/22/2019
9
10	Management
11	Active	Lieutenant	L. Scaletta	5H-07	Manager	12/22/2019	Cars designated for your rank
12	Active	Lieutenant	J. Lynch	5H-08	Manager	12/23/2019	Lieutenant + ~ All BELOW
13	Vacant	Lieutenant		5H-09	Manager		First Sergeant ~ Porsche, Corvette SEE HEAD FOR CODE
14	Vacant	Lieutenant		5H-10	Manager		Sergeant ~ Silverado pr12
15	Active	First Sergeant	A. Hawk	5H-11	Shift Manager	12/22/2019	Master Trooper ~ Tahoe Hwaycar10, Ram 2500 Leo9
16	Active	First Sergeant	Y. Ofek	5H-12	Shift Manager	12/22/2019	Senior Trooper ~ Viper vipergts2, Expedition leo4 , Camaro Camaro2
17	Vacant	First Sergeant		5H-13	Shift Manager		Trooper ~Tahoe mce1 , Interceptor Leo5 , , Crown vic Tstcar5,
18	Vacant	First Sergeant		5H-14	Shift Manager		Cadet & Probationary Trooper ~2015 Charger chgr , impala police3 ,
19	Vacant	First Sergeant		5H-15	Shift Manager		You may drive vehicles from your rank or below
20	Vacant	First Sergeant		5H-16	Shift Manager
21
22	Supervisors
23	Active	Sergeant	L. Myatt	5H-17	Shift Supervisor
24	Active	Sergeant	A. Mendes	5H-18	Shift Supervisor	12/22/2019
25	Active	Sergeant	M. Walker	5H-19	Shift Supervisor	11/23/2019
26	Active	Sergeant	J. Black	5H-20	Shift Supervisor	12/4/2019
27	Active	Sergeant	Z. Allan	5H-21	Shift Supervisor	12/22/2019
28	Vacant	Sergeant		5H-22	Shift Supervisor
29	Patrol
30
31	Inactive	Master Trooper	J. Appleseed	5H-23	R.A.C	11/17/2019
32	Active	Master Trooper	J. Smith	5H-24	R.A.C	11/23/2019
33	Active	Master Trooper	C. Clown	5H-25	R.A.C	12/10/2019
34	Vacant	Master Trooper	L. Cole	5H-26	R.A.C	12/22/2019
35	Vacant	Master Trooper		5H-27	R.A.C
36	Vacant	Master Trooper		5H-28	R.A.C
37	Vacant	Master Trooper		5H-29	R.A.C
38	Vacant	Master Trooper		5H-30	R.A.C
39	Vacant	Master Trooper		5H-31	R.A.C
40					C
41	Active	Senior Trooper	J. Gabe	5H-32	Patrol Troop	11/23/2019
42	Active	Senior Trooper	T. Oak	5H-33	Patrol Troop	12/22/2019
43	Active	Senior Trooper	J. Gardner	5H-34	Patrol Troop	12/22/2019
44	Vacant	Senior Trooper		5H-35	Patrol Troop
45	Vacant	Senior Trooper		5H-36	Patrol Troop
46	Active	Senior Trooper		5H-37	Patrol Troop	11/22/2019
47	Vacant	Senior Trooper		5H-38	Patrol Troop		Command Staff [6/6]
48	Active	Senior Trooper	J. Play	5H-39	Patrol Troop	11/22/2019	Management [4/10]
49	Vacant	Senior Trooper		5H-40	Patrol Troop		Supervisors [5/6]
50	Vacant	Senior Trooper		5H-41	Patrol Troop		Patrol [34/72]
51	Vacant	Senior Trooper		5H-42	Patrol Troop
52
53	Active	Trooper	S. Matthew	5H-43	Patrol Troop	12/22/2019
54	LOA	Trooper	K. Alamanas	5H-44	Patrol Troop	11/23/2019
55	Active	Trooper	G. Jenkins	5H-45	Patrol Troop	11/8/2019
56	Active	Trooper	C. Niles	5H-46	Patrol Troop	11/24/2019
57	Active	Trooper	K. Brown	5H-47	Patrol Troop	11/18/2019
58	Active	Trooper		5H-48	Patrol Troop
59	Inactive	Trooper	B. Stolen	5H-49	Patrol Troop	11/28/2019
60	Active	Trooper	J. Blackwell	5H-50	Patrol Troop	11/29/2019
61	Active	Trooper	J. Manny	5H-51	Patrol Troop	11/30/2019
62	Active	Trooper	S. Hale	5H-52	Patrol Troop	12/192019/
63	Inactive	Trooper	J. Renoldo	5H-53	Patrol Troop	12/1/2019
64	Active	Trooper	R. Banks	5H-54	Patrol Troop	11/16/2019
65	Active	Trooper	O. Monkey	5H-55	Patrol Troop	11/18/2019
66	Active	Trooper	A. Fairley	5H-56	Patrol Troop	12/7/2019
67	Active	Trooper	M. Conwell	5H-57	Patrol Troop	12/21/2019
68	Vacant	Trooper		5H-58	Patrol Troop
69	Vacant	Trooper		5H-59	Patrol Troop
70
71	Vacant	Probationary Trooper		6H-01	Needs Ridealong	12/9/2019
72	Vacant	Probationary Trooper		6H-02	Needs Ridealong
73	Active	Probationary Trooper	J. Dias	6H-03	Needs Ridealong	12/13/2019
74	Vacant	Probationary Trooper		6H-04	Needs Ridealong	12/13/2019
75	Active	Probationary Trooper	J. Shane	6H-05	Needs Ridealong	12/15/2019
76	Vacant	Probationary Trooper		6H-06	Needs Ridealong
77	Vacant	Probationary Trooper		6H-07	Needs Ridealong
78	Active	Probationary Trooper		6H-08	Needs Ridealong	12/15/2019
79	Vacant	Probationary Trooper		6H-09	Needs Ridealong
80	Vacant	Probationary Trooper		6H-10	Needs Ridealong
81	Vacant	Probationary Trooper		6H-11	Needs Ridealong
82	Vacant	Probationary Trooper		6H-12	Needs Ridealong
83	Vacant	Probationary Trooper		6H-13	Needs Ridealong
84	Vacant	Probationary Trooper		6H-14	Needs Ridealong
85
86	Active	Trooper Cadet	J.Venture	HC-01	Needs Training	12/19/2019
87	Active	Trooper Cadet	A. Kusik	HC-02	Needs Training	11/21/2019
88	Active	Trooper Cadet	J. Davies	HC-03	Needs Training	12/17/2019
89	Active	Trooper Cadet	B.Peisley	HC-04	Needs Training	12/19/2019
90	Active	Trooper Cadet	T. Brass	HC-05	Needs Training	11/13/2019
91	Active	Trooper Cadet	A. Pendragon	HC-06	Needs Training	12/10/2019
92	Vacant	Trooper Cadet	J.Complex	HC-07	Needs Training	12/19/2019
93	Vacant	Trooper Cadet	C.Toms	HC-08	Needs Training	12/22/2019
94	Vacant	Trooper Cadet	B.Smith	HC-09	Needs Training	12/22/2019
95	Vacant	Trooper Cadet		HC-10	Needs Training
96	Vacant	Trooper Cadet	S.Wrath	HC-11	Needs Training	11/25/2019
97	Vacant	Trooper Cadet		HC-12	Needs Training
98	Vacant	Trooper Cadet		HC-13	Needs Training
99	Vacant	Trooper Cadet		HC-14	Needs Training
100	Vacant	Trooper Cadet		HC-15	Needs Training