3G_Court_Security_Officer_Monthly_Activity_Report_MAR_NFL.xlsx

XLSX spreadsheet 762 KB Posted Mar 30, 2017

Attached to: Court Security Officer Services - 8(a) Set-Aside
Solicitation number: DJM-17-A32-R-0001
Issued by: Department of Justice US Marshals Service

About this file

From the source

J.3(G) Court Security Officer Monthly Activity Report MAR N/FL

View the file

Other files

File	Type	Posted
Questions_and_Answers_-_A0001.pdf	PDF	Apr 14, 2017
1D_D17_N-FL_Circuit_Price_Summary_Sheets_-_A0001.xlsx	XLSX spreadsheet	Apr 14, 2017
1G_Table_for_Body_Armor_Kits_-_A0001.xlsx	XLSX spreadsheet	Apr 14, 2017
J_-_SECTION_J_-_A0001.pdf	PDF	Apr 14, 2017
C-_SECTION_C_-_A0001.pdf	PDF	Apr 14, 2017
DJM-17-A32-R-0001_0001.pdf	PDF	Apr 14, 2017
7(D)_Lesson_Plan_Format_and_Overview_-_A0001.pdf	PDF	Apr 14, 2017
1A_CBAs_Central_Illinois_-_A0001.pdf	PDF	Apr 14, 2017
L_-_SECTION_L_-_A0001.pdf	PDF	Apr 14, 2017
2G_Form_CSO009_Notification_of_a_Court_Security_Officers_Official_Performance_Date.pdf	PDF	Mar 30, 2017
1A_CBAs_Central_Illinois.pdf	PDF	Mar 30, 2017
2J_Form_FD258_FBI_Applicant_Fingerprint_Card.pdf	PDF	Mar 30, 2017
1G_Table_for_Body_Armor_Kits.xlsx	XLSX spreadsheet	Mar 30, 2017
9_-_Special_Standards_of_Responsibility.pdf	PDF	Mar 30, 2017
2D_Form_CSO006_Certification_of_Court_Security_Officer_Performance_Standards.pdf	PDF	Mar 30, 2017
7A_CSO_Semi_Auto_Handgun_Qualification_Course_Effective_012001.pdf	PDF	Mar 30, 2017
3E_Standard_Form_1034_SAMPLE.pdf	PDF	Mar 30, 2017
4A_USMS_Policy_Directive_14.15_Use_of_Force_Effective_04122013.pdf	PDF	Mar 30, 2017
1E_Pricing_Template_D17_D26.xlsx	XLSX spreadsheet	Mar 30, 2017
3G_Court_Security_Officer_Monthly_Activity_Report_MAR_CIL.xlsx	XLSX spreadsheet	Mar 30, 2017
4E_SSO_Uniform_Standard.pdf	PDF	Mar 30, 2017
2K_Form_CSO012_Request_to_Reevaluate_Court_Security_Officers_Medical_Qualification.pdf	PDF	Mar 30, 2017
7D_Lesson_Plan_Format_and_Overview.pdf	PDF	Mar 30, 2017
1F_Table_for_StartUp_Costs.xlsx	XLSX spreadsheet	Mar 30, 2017
7B_In_House_Phase_I_Orientation_Training_Program.pdf	PDF	Mar 30, 2017
2C_Form_CSO005_Court_Security_Officer_Preliminary_Background_Check_Form.pdf	PDF	Mar 30, 2017
2B_Form_CSO004_Acknowledgement_of_Conditions_of_Court_Security_Officer_Eligibility.pdf	PDF	Mar 30, 2017
8A_Past_Performance_Information_Brief.pdf	PDF	Mar 30, 2017
7F_Certified_Training_and_Weapons_Qualification_Instructors.pdf	PDF	Mar 30, 2017
1A_CBAs_Northern_Florida.pdf	PDF	Mar 30, 2017
DJM-17-A32-R-0001.pdf	PDF	Mar 30, 2017
7E_Example_Lesson_Plan.pdf	PDF	Mar 30, 2017
3F_Standard_Form_1035_Continuation_Sheet_SAMPLE.pdf	PDF	Mar 30, 2017
3A_Form_CSO002_Court_Facility_Monthly_Statistical_Summary_Report.pdf	PDF	Mar 30, 2017
1D_D26_C-IL_Circuit_Price_Summary_Sheets.xlsx	XLSX spreadsheet	Mar 30, 2017
8B_Past_Performance_Rating_Guidelines.pdf	PDF	Mar 30, 2017
4C_DOJ_Policy_Statement_Use_of_Force.pdf	PDF	Mar 30, 2017
4B_USMS_Policy_Directive_14.16_Less_than_Lethal_Devices_Effective_03172016.pdf	PDF	Mar 30, 2017
2E_Form_CSO007_Certificate_of_Compliance_The_Lautenberg_Amendment.pdf	PDF	Mar 30, 2017
3B_Form_CSO003_Court_Facility_Incident_Report.pdf	PDF	Mar 30, 2017
1D_D17_N-FL_Circuit_Price_Summary_Sheets.xlsx	XLSX spreadsheet	Mar 30, 2017
2L_DOJ555_USDOJ_Disclosure.pdf	PDF	Mar 30, 2017
2I_Form_CSO014_Court_Security_Officer_Weapons_Qualification_Record.pdf	PDF	Mar 30, 2017
6_List_of_Government_Acronyms.pdf	PDF	Mar 30, 2017
2H_Form_CSO229_Certification_of_Medical_Examination_for_Court_Security_Officers.pdf	PDF	Mar 30, 2017
3C_Form_CSO010__Court_Security_Officer_Travel_Authorization.pdf	PDF	Mar 30, 2017
2F_Form_CSO008_InDistrict_Phase_I_Orientation_Certification.pdf	PDF	Mar 30, 2017
2A_Form_CSO001_Court_Security_Officer_Staffing_Notification.pdf	PDF	Mar 30, 2017
3D_Form_CSO011_Court_Security_Officer_CSO_Travel_Expense_Reimbursement.pdf	PDF	Mar 30, 2017
1C_Shift_Differential_Hours.pdf	PDF	Mar 30, 2017

Show 40 more

Latest 50 of 55 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

NFL-11-Cover

COURT SECURITY OFFICER MONTHLY ACTIVITY REPORT
Northern DISTRICT OF Florida	N/FL-17

CONTRACTOR'S INFORMATION:					REPORTING PERIOD
	Name	APPS		Month		Year
	Address	7700 Chevy Chase Drive
	City	Austin			DATE SUBMITTED
	State	Texas		Month	Day	Year
	Zip Code	78752
	Office Telephone Number	512-380-9700			CIRCUIT
	Fax Telephone Number	512-380-9714			11th
	Internet Address	www.aeps.us
CONTRACTOR'S INFORMATION:					CONTRACT #
					DJMS-12-D-0463
	Contract Manager:	George Devers
	Assistant Contract Manager:	Jerry Lemke		CONTRACT PERFORMANCE PERIOD
	District Supervisor:	Don Porter	Facility M		10/01/16 - 09/30/17

CONTRACTOR'S SIGNATURE

I hereby certify that the information provided in this report is true and accurate to the best of my knowledge.

Tara Devers - Contract Administrator
NAME AND TITLE OF AUTHORIZED COMPANY OFFICIAL	(TYPE OR PRINT)

	DATE:
SIGNATURE OF AUTHORIZED COMPANY OFFICIAL

http://www.aeps.us/ Position Totals

District			Number of Authorized Positions			Monthly Activity
No.	District				Fiscal Year	Current	Authorized	Comments
		Full-time	Shared	Total	Enhancements	Vacancies	Transfers
	A	0	0	0
	D	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	O	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	N	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	AF	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	AH	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	AK	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	AD	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
12	Central District of California	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	0.0

&"Times New Roman,Bold"USMS 09/00

NFL-11-Staffing

													District #	Facility	CSO ID	Name (Last)	Name (First)	M.I.	Status (FT/ST)	Position	Start Date	Birth MM/YY	Last Med Exam Date	Uniform Issue Date	Body Armor Expire Date	Weapons Qual Date	Orient Ph I Comp Date	Orient Ph II Comp Date	Annual Trg Comp Date	Notes
STAFFING INFORMATION												N/FL-17	17																		LAFT1
Reporting Period:			0		Authorized # of CSO Positions		Authorized Bodies			Actual # of CSOs On-Board		Actual Bodies	17																		AFT2
Facility		Facility Address		Full-time (FT)	Shared (ST)	Total		Facility	Full-time (FT)	Shared (ST)	Total		17																		AFT3
A	110 East Park Ave, Tallahassee							A					17																		AFT4
B	100 North Palafox Street, Pensacola							B					17																		AFT5
C	30 West Government Street, Panama City							C					17																		LBFT1
D	401 Southeast First Avenue, Gainesville							D					17																		BFT2
M	111 North Adams Street, Tallahassee							M					17																		BFT3
T	25 West Government Street, Pensacola							T					17																		BFT4
M	District Supervisor							M					17																		BST1
													17																		BST2
													17																		BST3
			Totals:	0	0	0	0						17																		BST4
													17																		LCFT1
													17																		CFT02
													17																		CFT03
													17
													17
													17
													17
													17
													17
Additional Notes:													17																		CFT04
													17																		CFT05
													17
													17																		CFT06
													17																		CST1
													17																		CST2
													17																		LDFT1
													17																		DFT2
													17																		DFT3
													17																		DFT4
													17																		DFT5
													17																		DFT6
													17																		DFT7
													17																		DST2
													17																		DST3
													17																		DST4
													17																		DST5
													17																		DST6
													17																		LLFT1
													17																		LFT2
													17
													17																		LFT3
													17																		LFT4
													17																		LFT5
													17																		LFT6
													17																		LFT7
													17																		LFT8
													17																		LST1
													17
													17
													17																		LST5
													17																		NFT2
													17																		LST6
													17
													17																		MFT2
													17
													17																		MFT4
													17
													17																		MFT5
													17																		MFT6
													17
													17
													17																		MFT7
													17
													17
													17																		MFT9
													17																		MST1
													17																		MST3
													17																		MST4
													17
													17																		MST9
													17																		MS10

NFL-11-Vacancies

SECTION III - VACANCIES	SECTION III - VACANCIES								N/FL-17
Contract Number:	Code	Facility Code	Name of Person Departing	Status (FT/S)	Vacancy Date	Applicant	Reason for Vacancy	Replacement Package Due:	Replacement Package Sent:
	17
	17
	17
	17
	17
	17
	17
	17
	17
	17
	17
	17

NFL-11-CSO Reg Hrs

TOTALS:

Facility

Position

Status

Name (Last)

Name (First)

M.I.

CALENDAR DAYS

MONTHLY HOURS WORKED (REGULAR) REPORT: C/SSO

Regular Hrs

DISTRICT:

N/FL-17

CSO

Vacant

0.00

AFT2

CSO

0.00

Month:

12/31/99

AFT3

CSO

0.00

Year:

AFT3

CSO

0.00

AFT4

CSO

0.00

AFT4

CSO

0.00

CSO

0.00

BFT2

CSO

0.00

MONTHLY C/SSO REGULAR HOURS SUMMARY

BFT2

CSO

0.00

FACILITY

ERROR:#REF!

Total

BFT3

CSO

0.00

HOURS:

0.00

BFT4

CSO

0.00

BST1

CSO

0.00

BST2

CSO

0.00

BST2

CSO

0.00

BST3

CSO

0.00

BST3

CSO

0.00

BST3

CSO

0.00

BST4

CSO

0.00

CFT03

CSO

0.00

CFT5

CSO

0.00

CFT6

CSO

0.00

CST1

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CST2

CSO

0.00

DFT2

CSO

0.00

DFT3

CSO

0.00

DFT5

CSO

0.00

CSO

0.00

CSO

0.00

DFT6

CSO

0.00

DFT7

CSO

0.00

DST1

CSO

0.00

DST2

CSO

0.00

DST3

CSO

0.00

DST4

CSO

0.00

DST5

CSO

0.00

DST6

CSO

0.00

LFT2

CSO

0.00

LFT3

CSO

0.00

LFT4

CSO

0.00

LFT5

CSO

0.00

LFT6

CSO

0.00

LFT7

CSO

0.00

LFT8

CSO

0.00

LFT9

CSO

0.00

LST1

CSO

0.00

LST2

CSO

0.00

CSO

0.00

LST2

CSO

0.00

LST3

CSO

0.00

LST4

CSO

0.00

LST4

CSO

0.00

LST6

CSO

0.00

MFT2

CSO

0.00

CSO

0.00

MFT3

CSO

0.00

MFT4

CSO

0.00

MFT5

CSO

0.00

MFT6

CSO

0.00

CSO

0.00

MFT8

CSO

0.00

MFT9

CSO

0.00

MST1

CSO

0.00

MST1

CSO

MST2

CSO

MST3

CSO

MST4

CSO

MST4

CSO

MST6

CSO

MST8

CSO

MST9

CSO

MS10

CSO

NST1

CSO

NST2

CSO

	0.00
Total:

NFL-11-CSO OT Hrs

TOTALS:

Totals:

Facility

Position

Status

Name (Last)

Name (First)

M.I.

CALENDAR DAYS

MONTHLY HOURS WORKED (OVERTIME-OT) REPORT: C/SSO

Regular Hrs

DISTRICT:

N/FL-17

CSO

Vacant

0.00

DISTRICT:

N/FL-17

CSO

0.00

Month:

12/31/99

CSO

0.00

Year:

CSO

0.00

CSO

0.00

MONTHLY C/SSO OVERTIME (OT) HOURS SUMMARY

CSO

0.00

FACILITY

ERROR:#REF!

Total

CSO

0.00

HOURS:

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

Armston

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

CSO

0.00

Total:

0.00

Total Reg Hours

NFL-11-Lead Reg Hrs

																																					Totals:
Facility	Position	Status	Name (Last)	Name (First)	M.I.																CALENDAR DAYS																	MONTHLY HOURS WORKED (REGULAR) REPORT: Lead C/SSO
						1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28				Regular Hrs
B	LCSO	FT																																			0.00	DISTRICT:	N/FL-17
D	LCSO	FT																																			0.00	Month:	12/31/99
C	LCSO	FT																																			0.00	Year:	0
A	LCSO	FT																																			0.00
T	LCSO	FT																																			0.00	MONTHLY LEAD REGULAR HOURS SUMMARY
M	LCSO	FT																																			0.00	FACILITY		A	B	C	D	ERROR:#REF!	M	T	Total
																																					0.00	HOURS:		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
					Total:	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
																																					Total Reg Hours

NFL-11-Lead OT Hrs

																																					TOTALS:
Facility	Position	Status	Name (Last)	Name (First)	M.I.																CALENDAR DAYS																	MONTHLY HOURS WORKED (OVERTIME-OT) REPORT: Lead C/SSO
						1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29			Regular Hrs
B	LCSO	FT																																			0.00	DISTRICT:	N/FL-17
D	LCSO	FT																																			0.00	Month:	12/31/99
C	LCSO	FT																																			0.00	Year:	0
A	LCSO	FT																																			0.00
M	LCSO	FT																																			0.00	MONTHLY LEAD REGULAR HOURS SUMMARY
T	LCSO	FT																																			0.00	FACILITY		A	B	C	D	ERROR:#REF!	M	T	Total
																																					0.00	HOURS:		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
																																					0.00
					Total:	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
																																					Total Reg Hours

NFL-11-DS Reg Hrs

																																					TOTALS:
Facility	Position	Status	Name (Last)	Name (First)	M.I.																CALENDAR DAYS																	MONTHLY HOURS WORKED (REGULAR) REPORT: District Supervisor (DS)
						1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28				Regular Hrs
M	DS	FT																																			0.00	DISTRICT:	N/FL-17
																																					0.00	Month:
																																					0.00	Year:	0
					Total:	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
																																					Total Reg Hours

NFL-11-DS OT Hrs

																																					TOTALS:
Facility	Position	Status	Name (Last)	Name (First)	M.I.																CALENDAR DAYS																	MONTHLY HOURS WORKED (OVERTIME-OT) REPORT: District Supervisor (DS)
						1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28				Regular Hrs
M	DS	FT																																			0.00	DISTRICT:	N/FL-17
																																					0.00	Month:
																																					0.00	Year:
					Total:	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
																																					Total Reg Hours

NFL-11-Monthly Hrs Summary

Facility

Position

Total:

MONTHLY HOURS WORKED (REGULAR+OT) SUMMARY

CSO

CSO (OT)

District:

N/FL-17

DS (Reg)

DS (OT)

Lead (Reg)

Lead (OT)

C/SSO (Reg)

C/SSO (OT)

Total

LCSO

Month:

0.00

LCSO (OT)

Year:

DS (OT)

Sub-Total

CSO

CSO (OT)

LCSO

LCSO (OT)

Sub-Total

CSO

CSO (OT)

LCSO

LCSO (OT)

Sub-Total

CSO

CSO (OT)

LCSO

LCSO (OT)

Sub-Total

CSO

CSO (OT)

LCSO

LCSO (OT)

Sub-Total

CSO

CSO (OT)

LCSO

LCSO (OT)

Sub-Total

0.00

Total: 0.00

11th Circuit-Workhours Summary

	CIRCUIT WORKHOURS INFORMATION (Summary)
				Month	Year
Judicial Circuit:		11th	Reporting Period:
Fiscal Year:		0

FY 14 ACTUAL HOURS WORKED (By Month) - 11th CIRCUIT
District	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Cum Hrs Worked
A
B
C
D
M
T
													- 0
													- 0
													- 0
													- 0
													- 0
													- 0
													- 0
TOTAL:	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	- 0	- 0

				1080				1899
FY 14 ACTUAL HOURS WORKED (FY Total) - 11th CIRCUIT								**Authorized Hrs	Difference
District	District #	Dist Supv	CSO Positions	*Contract Hours	Cumulative Hours Worked			on Contract	(Auth vs Worked)
A	17	0	0	0		- 0		0.00	0.00
B	17	0	0	0		- 0		0.00	0.00
C	17	0	0	0		- 0		0.00	0.00
D	17	0	0	0		- 0		0.00	0.00
M	17	1	0	0		- 0		0.00	0.00
T	17	0	0	0		- 0		0.00	0.00
				0		- 0			0.00
				0		- 0			0.00
				0		- 0			0.00
				0		- 0			0.00
				0		- 0			0.00
				0		- 0			0.00
TOTAL:		1	0	0		- 0	TOTAL	0.00	0.00

T:\Accounts Receivable\ Billing\ Marshals Billing\ USMS Reports\ (Month & Year)\ (Month) WorkHours Reports for COs.xls &"Times New Roman,Bold"&D

11th Circuit-Billing Summary

	CIRCUIT BILLING INFORMATION (Summary)										37	586.9
						Month		Year			37	392.06
Judicial Circuit:	11th				Reporting Period:						0.0001	0.0002	0.0003	0.0004	0.0005
Fiscal Year:	0								$ 83,079.30	A	$ 80,144.80	$ 2,934.50	$ - 0	$ - 0	$ - 0	5	0
									$ 214,546.17	B	$ 205,733.15	$ 8,813.02	$ - 0	$ - 0	$ - 0	7	12
Total Monthly Billing									$ 115,615.77	C	$ 111,310.25	$ 4,305.52	$ - 0	$ - 0	$ - 0	6	2
	A	B	C	D	M	T	TOTAL		$ 169,364.76	D	$ 157,247.25	$ 6,460.66	$ 5,656.85	$ - 0	$ - 0	7	6
October									$ 250,451.28	M	$ 241,833.10	$ 8,618.18	$ - 0	$ - 0	$ - 0	6	13
November									$ 132,137.04	T	$ 127,047.40	$ 5,089.64	$ - 0	$ - 0	$ - 0	6	4
December																37	37
January											$ 923,315.95	$ 36,221.52	$ 5,656.85	$ - 0	$ - 0
February
March
April							$ - 0
May							$ - 0
June							$ - 0
July							$ - 0
August							$ - 0
September							$ - 0
SUB-TOTAL:	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

*Authorized Funding to Date:

Difference (Actual vs Auth):
	1443

T:\Accounts Receivable\ Billing\ Marshals Billing\ USMS Reports\ (Month & Year)\ (Month) Billing Data Reports for COs.xls &"Times New Roman,Bold"&D

Summary-internal only-

Tab Summary

This tab is for internal use only and will be deleted before it is sent to the government. Please use this section to add any notes in regards to what you're adding to the new template.

The government asked us to delete all the notes from the pages, so that is why all the original "How-TO' notes were removed from each tab.

IMPORTANT: Please add your notes to the "Corrections Needed" box for each section (to the right)

Cover Tab-

If you need to change the month/day, you only have to do it on this tab. Formulas correspond to every tab in the workbook….so if the month is right on this page, it's right on every page.

List Corrections Needed for Present	Notes on Corrections
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
List Corrections Needed for the Future	Notes on Corrections
Example: Employee retiring late June that needs to be removed for the July MAR,
(but not for the June MAR because he/she would still have hours listed for that month)
1
2
3
4
5
6
7
8
9

Staffing
The square is the only part you need to fill in. Everything else is a formula that calculates the total.
You have complete freedom to populate the staffing info to the right as needed
	List Corrections Needed	Notes on Corrections
	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20

Vacancies	List Corrections Needed	Notes on Corrections
Change anything. Please add notes here if you would like explain anything further---->	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17

Hrs Tabs (CSO Reg, CSO OT, Lead Reg, Lead OT, DS Reg, ES OT)

the original template said "List every C/SSO on a separate line. If a C/SSO works at different facilities during the same month, list that individual on multiple lines."

Lines are unlocked at the bottom so that you may add additional lines for the employees that work at different facilities.

	List Corrections Needed		Notes on Corrections
	1	Remove George Dobos from facility 17C, he resigned effective 02/10/17
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
Monthly Hours Summary
This entire sheet is locked because nothing has to be changed. It's just an auto-fill sheet relying on information from the tabs previously stated above.

	List Corrections Needed		Notes on Corrections
	1	Remove George Dobos from facility 17C, he resigned effective 02/10/17
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
26th Circuit-Workhours Summary
Cells for the past month are locked, but May-Sep are unlocked.
	List Corrections Needed		Notes on Corrections
	1		historical data
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17

	List Corrections Needed	Notes on Corrections
26th Circuit-Billing Summary	1	historical data
To be filled in by corporate.	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17

image1.png image2.png image3.png image4.png image5.png image6.png image7.png

File details come from the government source that posted it. Updated Nov 14, 2017.