Spreadsheet: 1399a1d7-67a9-4098-af9c-43485dcb64cf
Sheet: Sheet1

FY2012 Attendance & Time Off Tracking Tool for Biweekly B (Office and Clerical) Staff in Hours | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
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 and number of pay periods, e.g., 100%, and number of pay periods, e.g., 26,. Then, enter sick and/or vacation hours carried over from FY2011. 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 FY2012
 | Cells to enter personal information |  |  |  | C: Compelling Reason |  |  | H: Holiday |  | L: Leave w/o Pay |  |  | W: Worker's Comp |  |  | July 4, 2011 |  |  |  | December 26, 2011
 | Weekend days |  |  |  | DF: Death in Family |  |  | J: Jury Duty |  | O: Optional Holiday |  |  | R: Religious |  |  | September 5, 2011 |  |  |  | December 30, 2011
 | Holidays |  |  |  | D: Disability |  |  | [NAME]: Marriage1 |  | P: Paid Time Off |  |  | S: Sporadic Absence |  |  | November 24, 2011 |  |  |  | January 2, 2012
1 full-time day=7.25 hours |  |  |  |  | F: Family Leave |  |  | M: Military Duty |  | PE: Personal |  |  | V: Vacation |  |  | November 25, 2011 |  |  |  | May 28, 2012
 |  |  |  |  | 1 Also applies to commitment ceremonies or civil unions for same-sex couples. |  |  |  |  |  |  |  |  |  |  | December 23, 2011
 |  |  | Enter  Duty Time (e.g., 100%): |  |  |  |  |  |  | Enter Vacation Hours Carried over from FY2011: |  | [NAME]. = | 0 |  |  |  |  |  |  | Enter Sick Hours Carried over from FY2011: |  | [NAME] | 0
 |  |  | Enter # [NAME] Pays: |  |  |  |  |  |  | Vacation Hours Accrued Weekly in FY2012: | 0 |  |  |  |  |  |  |  |  | [NAME] in FY2012: | 0
 |  |  | [NAME] in FY2012: | 0 |  |  |  |  |  | Total Vacation Hours Projected in FY2012: | 0 |  |  |  |  |  |  |  |  | Total Sick Hours Available in FY2012: | 0
 |  |  | Optional Holiday Hours in FY2012: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary of Time Available & Taken by Pay Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vac. Hrs. Available | Vac. Hrs. Taken | Vac. Bal. | [NAME]. Taken | [NAME]. Balance | [NAME]. Taken | [NAME]. Bal. | [NAME]. Taken | OH Bal.
Days | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU
June | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
June-July | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
July | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
July-Aug | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
August | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Aug-Sept | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
September | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Sept-Oct | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
October | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Oct-Nov | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Oct-Nov | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
November | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Nov-Dec | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subtotals: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
FY2012 Attendance & Time Off Tracking Tool for Biweekly B Staff in Hours (Page 2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary of Time Available & Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vac. Hrs. Available | Vac. Hrs. Taken | Vac. Bal. | [NAME]. Taken | [NAME]. Balance | [NAME]. Taken | [NAME]. Bal. | [NAME]. Taken | OH Bal.
Days | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU
December | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dec-Jan | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
January | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Jan-Feb | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
February | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Feb-Mar | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
March | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
April | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
April | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Apr-May | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
May | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
May-June | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
June | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Hours Taken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
Time Remaining to Carry Over into FY2013 through 6/24/12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Legend |  |  |  |  | Time Off Codes |  |  |  |  |  |  |  |  |  |  | Holiday Schedule for FY2012
 | Cells to enter personal information |  |  |  | C: Compelling Reason |  |  | H: Holiday |  | L: Leave w/o Pay |  |  | W: Worker's Comp |  |  | July 4, 2011 |  |  |  | December 26, 2011
 | Weekend days |  |  |  | DF: Death in Family |  |  | J: Jury Duty |  | O: Optional Holiday |  |  | R: Religious |  |  | September 5, 2011 |  |  |  | December 30, 2011
 | Days in different fiscal year |  |  |  | D: Disability |  |  | [NAME]: Marriage1 |  | P: Paid Time Off |  |  | S: Sporadic Absence |  |  | November 24, 2011 |  |  |  | January 2, 2012
 | Holidays |  |  |  | F: Family Leave |  |  | M: Military Duty |  | PE: Personal |  |  | V: Vacation |  |  | November 25, 2011 |  |  |  | May 28, 2012
1 full-time day=7.25 hours |  |  |  |  | 1 Also applies to commitment ceremonies or civil unions for same-sex couples. |  |  |  |  |  |  |  |  |  |  | December 23, 2011