Spreadsheet: 06c0b80c-b241-4e5a-ba1c-a6357b5e9186
Sheet: BWB Hours

FY2013 Attendance & Time Off Tracking Tool for Biweekly B (Office and Clerical) Staff in Hours
Employee's Name: |  |  |  |  |  | Department: |  |  |  |  |  |  | Daily Schedule (Days, Hours):
HOW TO USE THIS TOOL: Save the spreadsheet to your computer. In orange cells, where denoted, begin by entering your duty time, e.g., 100%, and number of pay periods, e.g., 26. Then, enter sick and/or vacation days carried over from FY2012. You can mark your daily attendance with an X. Use codes listed below to record the amount of time off taken in the daily boxes, e.g., 7.25-V. One full-time day is equivalent to 7.25 hours. For each pay period, you must manually add up and enter the amount of time taken for each category in the corresponding orange box. As you enter time in the [NAME] columns at the end of each pay period, totals and time remaining, i.e., balances, will be calculated with embedded formulas that are based on current policies. If you have questions, contact your senior HR manager.
Legend |  |  |  |  | Time Off Codes |  |  |  |  |  |  |  | Holiday Schedule for FY2013
 | Cells to enter personal information |  |  |  | DF: Death in Family |  | J: Jury Duty |  | P: Paid Time Off |  | R: Religious |  | July 4, 2012 |  |  |  | December 25, 2012
 | Weekend days |  |  |  | D: Disability |  | M: Military Duty |  | PE: Personal |  | S: Sporadic Absence |  | September 3, 2012 |  |  |  | December 31, 2012
 | Holidays |  |  |  | F: Family Leave |  | L: Leave w/o Pay |  | W: Worker's Comp |  | V: Vacation |  | November 22, 2012 |  |  |  | January 1, 2013
 |  |  |  |  | H: Holiday |  |  |  |  |  |  |  | November 23, 2012 |  |  |  | May 27, 2013
1 full-time day=7.25 hours |  |  |  |  |  |  |  |  |  |  |  |  | December 24, 2012
 |  |  | Enter Duty Time (e.g., 100%): |  |  |  |  |  | Enter FY2012 Vacation Hours Carried Over: |  | [NAME]. = |  |  |  |  |  |  | Enter FY2012 Sick Hours Carried Over: |  | Max=
 |  |  | Enter # [NAME] Pays: |  |  |  |  |  | Vacation Hours Accrued Biweekly in FY2013: |  |  |  |  |  |  |  |  | Sick Hours Allocated in FY2013:
 |  |  | Personal Hours in FY2013: |  |  |  |  |  | Total Vacation Hours Projected in FY2013: |  |  |  |  |  |  |  |  | Total Sick Hours Available in FY2013:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary of Time Available & Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vac. Hrs. Avail. | Vac. Hrs. Taken | Vac. Bal. | [NAME]. Taken | [NAME]. Bal. | Prs. Hrs. Taken | Prs. Hrs. Bal.
Days | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU
June-July | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
July | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
July-Aug | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5
August | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Aug-Sept | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2
September | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
Sept-Oct | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
October | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Oct-Nov | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Oct-Nov | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
November | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
Nov-Dec | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
December | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
Subtotals:
FY2013 Attendance & Time Off Tracking Tool for Biweekly B (Office and Clerical) Staff in Days (Page 2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary of Time Available & Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vac. Days Available | Vac. Days Taken | Vac. Bal. | Sick Days Taken | Sick Days Bal. | PE Days Taken | PE Days Bal.
Days | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU
Dec-Jan | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6
January | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Jan-Feb | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3
February | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Feb-Mar | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 1 | 2 | 3
March | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
[NAME] | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
April | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Apr-May | 15 | 16 | 17 | 18 | 19 | 29 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Apr-May | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
May | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
May-June | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
June | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
Total Days Taken
Time Remaining to Carry Over into FY2014 through 6/23/13
Legend |  |  |  |  | Time Off Codes |  |  |  |  |  |  |  | Holiday Schedule for FY2013
 | Cells to enter personal information |  |  |  | DF: Death in Family |  | J: Jury Duty |  | P: Paid Time Off |  | R: Religious |  | July 4, 2012 |  |  |  | December 25, 2012
 | Weekend days |  |  |  | D: Disability |  | M: Military Duty |  | PE: Personal |  | S: Sporadic Absence |  | September 3, 2012 |  |  |  | December 31, 2012
 | Holidays |  |  |  | F: Family Leave |  | L: Leave w/o Pay |  | W: Worker's Comp |  | V: Vacation |  | November 22, 2012 |  |  |  | January 1, 2013
 |  |  |  |  | H: Holiday |  |  |  |  |  |  |  | November 23, 2012 |  |  |  | May 27, 2013
1 full-time day=7.25 hours |  |  |  |  |  |  |  |  |  |  |  |  | December 24, 2012