2010 Sample Employee Absence Tracker
Download as XLS, PDF
1 like949 views
The document tracks employee absence data for 2010 and 2009, including total vacation and sick days used each month. For Employee 1, it shows they used all 6 of their 2010 vacation days and 0.5 sick days. For Employee 2, it shows they used all 9 of their 2010 vacation days and 2 personal days, with 1 sick day used. The document provides a calendar view of the specific days taken off by each employee in 2010.
2010 Sample Employee Absence Tracker
- 1. Employee absence tracking 2010 2010 2010 2010 2010 2009 2010 2010S Total Total Vacation Personal Vacation Total ick Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Left Used Allotted Allotted Left Allotted Days Employee 1 2 6 5 2 1 8 0.5 1.0 - - 1.0 - - - 1.0 - 1.0 1.0 1.0 Employee 2 0 11 7 2 2 11 1.0 1.0 1.0 1.0 0.5 0.5 1.0 0.5 0.5 1.0 1.0 1.0 2.0 Click on desired name and you will be directed to employee's data entry calendar. Add new employee as needed. 01/04/2010, 12:30:50 2010sampleemployeeabsencetracker-12626081472446-phpapp02.xls
- 2. 1. To record an absence or enter current/prior year vacation allotment: a) Go to the "Total" sheet b) Click on desired employee's name and you will go to employee's data entry calendar ALL OUT OF OFFICE DAYS ARE RECORDED ONLY ON THE EMPLOYEE'S INDIVIDUAL SHEET. 2. Select a letter from the drop-down list or type the following letter to record out of office days: V=Vacation or P=Personal Day. 3. This calendar has been configured to allow the usage of 1/2 days with (V)acation and (P)ersonal. Select an item from the drop-down list or type the appropriate letter, a space, then (am) or (pm); i.e. "V (pm)" for afternoon vacation day. Select from drop-down list or type "VPh" to use 1/2 vacation and personal time for a day. 4. If you have more vacation days or personal days than allotted, a message will appear at the top of the sheet telling you which one (vacation or personal day amounts) you need to check. 5. Just type in Jan 1 date and the entire year will fill out. No need to type in each date. If it is not a leap year, delete February 29th. Legend: H=Holiday; P=Personal; S=Sick; V=Vacation; VPh=1/2 of Vacation & Personal Day P 1/2 Day=Personal (am) or (pm) S 1/2 Day=Sick (am) or (pm) V 1/2 Day= Vacation (am) or (pm) Original Calendar Template Created by: J. Muhr/A. Sykes Calendar Template Modified by: J. Muhr L. Elder 01/04/2010, 12:30:50 2010sampleemployeeabsencetracker-12626081472446-phpapp02.xls
- 3. 1 01/04/2010, 12:30:50 2010sampleemployeeabsencetracker-12626081472446-phpapp02.xls
- 4. 4 2009 Out Of Office Calendar EMPLOYEE: Employee 1 #NAME? YEARS ENTER 2010 ALLOTTED VACATION DAYS: 5 ENTER 2010 PERSONAL DAYS: 2 ENTER HIRE DATE: 11/1/1998 ENTER 2009 VACATION DAYS REMAINING: 1 2010 PERSONAL DAYS USED: 0 TOTAL 2010 VACATION DAYS ALLOTTED: 6 2010 PERSONAL DAYS REMAINING: 2 2010 VACATION DAYS USED: 6 2010 VACATION DAYS REMAINING: 0 2010 SICK DAYS: 0.5 All Vacation Days Used JANUARY FEBRUARY MARCH SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 1 2 3 4 5 6 1 2 3 4 5 6 H 3 4 5 6 7 8 9 7 8 9 10 11 12 13 7 8 9 10 11 12 13 H 10 11 12 13 14 15 16 14 15 16 17 18 19 20 14 15 16 17 18 19 20 V (am) V (pm) 17 18 19 20 21 22 23 21 22 23 24 25 26 27 21 22 23 24 25 26 27 H S (am) 24 25 26 27 28 29 30 28 28 29 30 31 31 APRIL MAY JUNE SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 3 1 1 2 3 4 5 4 5 6 7 8 9 10 2 3 4 5 6 7 8 6 7 8 9 10 11 12 11 12 13 14 15 16 17 9 10 11 12 13 14 15 13 14 15 16 17 18 19 V 18 19 20 21 22 23 24 16 17 18 19 20 21 22 20 21 22 23 24 25 26 25 26 27 28 29 30 23 24 25 26 27 28 29 27 28 29 30 H 30 31 JULY AUGUST SEPTEMBER SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 3 1 2 3 4 5 6 7 1 2 3 4 H 4 5 6 7 8 9 10 8 9 10 11 12 13 14 5 6 7 8 9 10 11 H V (pm) H 11 12 13 14 15 16 17 15 16 17 18 19 20 21 12 13 14 15 16 17 18 18 19 20 21 22 23 24 22 23 24 25 26 27 28 19 20 21 22 23 24 25 V (am) 25 26 27 28 29 30 31 29 30 31 26 27 28 29 30 OCTOBER NOVEMBER DECEMBER SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 1 2 3 4 5 6 1 2 3 4 V 3 4 5 6 7 8 9 7 8 9 10 11 12 13 5 6 7 8 9 10 11 V 10 11 12 13 14 15 16 14 15 16 17 18 19 20 12 13 14 15 16 17 18 17 18 19 20 21 22 23 21 22 23 24 25 26 27 19 20 21 22 23 24 25 H H V H H 24 25 26 27 28 29 30 28 29 30 26 27 28 29 30 31 H H H H H 31 01/04/2010, 12:30:50 2010sampleemployeeabsencetracker-12626081472446-phpapp02.xls
- 5. 5 2009 Out Of Office Calendar EMPLOYEE: Employee 2 #NAME? YEARS ENTER 2010 ALLOTTED VACATION DAYS: 7 ENTER 2010 PERSONAL DAYS: 2 ENTER HIRE DATE: 9/1/1998 ENTER 2009 VACATION DAYS REMAINING: 2 2010 PERSONAL DAYS USED: 2 TOTAL 2010 VACATION DAYS ALLOTTED: 9 2010 PERSONAL DAYS REMAINING: 0 2010 VACATION DAYS USED: 9 2010 VACATION DAYS REMAINING: 0 2010 SICK DAYS: 1 All Vacation & Personal Days Used JANUARY FEBRUARY MARCH SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 1 2 3 4 5 6 1 2 3 4 5 6 H 3 4 5 6 7 8 9 7 8 9 10 11 12 13 7 8 9 10 11 12 13 H S V V 10 11 12 13 14 15 16 14 15 16 17 18 19 20 14 15 16 17 18 19 20 17 18 19 20 21 22 23 21 22 23 24 25 26 27 21 22 23 24 25 26 27 H V 24 25 26 27 28 29 30 28 28 29 30 31 31 APRIL MAY JUNE SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 3 1 1 2 3 4 5 V 4 5 6 7 8 9 10 2 3 4 5 6 7 8 6 7 8 9 10 11 12 V (pm) 11 12 13 14 15 16 17 9 10 11 12 13 14 15 13 14 15 16 17 18 19 P (pm) 18 19 20 21 22 23 24 16 17 18 19 20 21 22 20 21 22 23 24 25 26 25 26 27 28 29 30 23 24 25 26 27 28 29 27 28 29 30 H 30 31 JULY AUGUST SEPTEMBER SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 3 1 2 3 4 5 6 7 1 2 3 4 H 4 5 6 7 8 9 10 8 9 10 11 12 13 14 5 6 7 8 9 10 11 H V (am) V (pm) H P 11 12 13 14 15 16 17 15 16 17 18 19 20 21 12 13 14 15 16 17 18 18 19 20 21 22 23 24 22 23 24 25 26 27 28 19 20 21 22 23 24 25 25 26 27 28 29 30 31 29 30 31 26 27 28 29 30 OCTOBER NOVEMBER DECEMBER SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT 1 2 1 2 3 4 5 6 1 2 3 4 VPh 3 4 5 6 7 8 9 7 8 9 10 11 12 13 5 6 7 8 9 10 11 V V 10 11 12 13 14 15 16 14 15 16 17 18 19 20 12 13 14 15 16 17 18 17 18 19 20 21 22 23 21 22 23 24 25 26 27 19 20 21 22 23 24 25 V H H H H 24 25 26 27 28 29 30 28 29 30 26 27 28 29 30 31 H H H H H 31 01/04/2010, 12:30:50 2010sampleemployeeabsencetracker-12626081472446-phpapp02.xls