Employee Attendance Spreadsheet
The directions below will serve as guidance in filling out the attached calendar. Should you have any difficulties, please direct further questions to your supervisor. Steps for completing the Calendar: 1 2 3 Click the "Calendar" tab below. Fill in your name and the total number of days in your contract. On the first line in every box, fill in your attendance with the amount in the first cell and the key code in the second cell (using the key below). ex. One sick day = 1 S One personal day = 1 P
4
If you take leave for a portion of the day, place the remaining portion of the day on the second line of the box. ex. 1/2 professional day 1/2 on-duty = 0.5 0.5 X O 1/4 on-duty 3/4 sick day = 0.25 0.75 O S
5
To save the spreadsheet: Click File; then Save As…; rename the file with your name; and save the calendar to an appropriate folder on your computer. On or before the Friday of the first full week of the month, please email the spreadsheet to:
6
S P X O H C V N
= = = = = = = = =
Key Sick Leave Personal Leave Professional Leave On Duty Holdiay Calamity Vacation Leave Non-Contract Central Office Closed to the public
EMPLOYEE NAME: AUG 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 30 31 S P X O H C V N
CONTRACT DAYS % DAYS PRESENT TOTAL DAYS YTD
TOTAL NUMBER OF CONTRACT DAYS OCT NOV DEC JAN FEB MAR APR MAY JUN JUL
SEPT
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0