INSTRUCTIONS TO USE ATTENDANCE FORMAT
PLEASE MARK THE ATTENDANCE BELOW MENTONED OPTIONS ONLY.
P - PRESENT
PL - PREVILAGE LEAVE
SL - SICK LEAVE
CL - CASUAL LEAVE
OD - ON DUTY
PH - PAID HOLIDAY
A - ABSENT
LWP - LOSS WITHOUT PAY
P/PL - HALF DAY PREVILAGE LEAVE
P/SL - HALF DAY SICK LEAVE
P/CL - HALF DAY CASUAL LEAVE
P/OD - HALF DAY ON DUTY
P/A - HALF DAY ABSENT
P/LWP - HALF DAY LOSS WITHOUT PAY
OFF - WEEKLY OFF
NJ - NEW JOINEE (SHOW THE OPTION TILL DOJ)
LFT - LEFT THE JOB (SHOW THE OPTION AFTER LEFT THE JOB)
P,PL,SL,CL,OD,PH,A,LWP,OFF,P/PL,P/SL,P/CL,P/OD,P/A,P/LWP,T
- PROVIDE THE COMPANY LOGO, COMPANY NAME, ADDRESS & UNIT (IF ANY) DETAILS
- ONLY CHANGE THE MONTH AND THE YEAR FOR ATTENDANCE - DATE, DAY & LEAVE BALANCE FOR PREVIOUS MONTH HE
- NEED TO PROVIDE THE PREVIOUS MONTH LEAVE BALANCES ACCORDINGLY
- CANNOT CHAGE THE COLUMNS
OR PREVIOUS MONTH HEAD WILL CALCULATE AUTOMATICALLY
COMPANY NAME
COMPANY
LOGO ADDRESS
UNIT (IF ANY) ATTENDANCE FOR THE MONTH OF August 2012
DAYS WRKD
Sl. EMP. EMPLOYEE DESIGNATION DEPARTMENT DATE OF
PRESENT
Wed
Mon
Wed
Mon
Wed
Mon
Wed
Mon
Wed
ABSENT
Thu
Thu
Thu
Thu
Thu
Tue
Tue
Tue
Tue
Sun
Sun
Sun
Sun
No. No. NAMES JOINED
Sat
Sat
Sat
Sat
Fri
Fri
Fri
Fri
Fri
LWP
OFF
OD
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
PH
PL
CL
SL
1 1 AAA KKK VVV 01.01.2010 P P P/OD OD OFF P P P P P P/PL OFF PL PL PH P P P OFF PL P P LFT LFT LFT LFT LFT LFT LFT LFT LFT 12.5 1.5 14 3.5 0 0 1 3 0 0
2 2 BBB LLL WWW 01.01.2011 P P P P OFF P P P P P/OD OD OFF P P/SL PH SL SL P OFF P P P P P P OFF P LFT LFT LFT LFT 18 1.5 19.5 0 2.5 0 1 4 0 0
3 3 CCC MMM XXX 01.01.2012 P P P P OFF P P P P P P OFF P P PH P P/OD OD OFF CL CL P P P P/CL OFF P P P P P 22 1.5 23.5 0 0 2.5 1 4 0 0
4 4 DDD NNN YYY 01.07.2012 P P P P OFF P P P P P P OFF P P PH P P P OFF P P P P P/OD OD OFF P/A P P A A 22 1.5 23.5 0 0 0 1 4 0 2.5
5 5 EEE OOO ZZZ 10.08.2012 NJ NJ NJ NJ NJ NJ NJ NJ NJ P P OFF P P PH P P P OFF P P P P LWP LWP OFF P P/LWP P P/OD OD 14 1.5 15.5 0 0 0 1 3 2.5 0
6 0 0 0 0 0 0 0 0 0 0
7 0 0 0 0 0 0 0 0 0 0
8 0 0 0 0 0 0 0 0 0 0
9 0 0 0 0 0 0 0 0 0 0
10 0 0 0 0 0 0 0 0 0 0
11 0 0 0 0 0 0 0 0 0 0
12 0 0 0 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0 0 0 0
15 0 0 0 0 0 0 0 0 0 0
16 0 0 0 0 0 0 0 0 0 0
17 0 0 0 0 0 0 0 0 0 0
18 0 0 0 0 0 0 0 0 0 0
19 0 0 0 0 0 0 0 0 0 0
20 0 0 0 0 0 0 0 0 0 0
21 0 0 0 0 0 0 0 0 0 0
22 0 0 0 0 0 0 0 0 0 0
23 0 0 0 0 0 0 0 0 0 0
24 0 0 0 0 0 0 0 0 0 0
25 0 0 0 0 0 0 0 0 0 0
26 0 0 0 0 0 0 0 0 0 0
27 0 0 0 0 0 0 0 0 0 0
28 0 0 0 0 0 0 0 0 0 0
29 0 0 0 0 0 0 0 0 0 0
30 0 0 0 0 0 0 0 0 0 0
31 0 0 0 0 0 0 0 0 0 0
32 0 0 0 0 0 0 0 0 0 0
33 0 0 0 0 0 0 0 0 0 0
34 0 0 0 0 0 0 0 0 0 0
35 0 0 0 0 0 0 0 0 0 0
36 0 0 0 0 0 0 0 0 0 0
37 0 0 0 0 0 0 0 0 0 0
38 0 0 0 0 0 0 0 0 0 0
39 0 0 0 0 0 0 0 0 0 0
40 0 0 0 0 0 0 0 0 0 0
41 0 0 0 0 0 0 0 0 0 0
42 0 0 0 0 0 0 0 0 0 0
43 0 0 0 0 0 0 0 0 0 0
44 0 0 0 0 0 0 0 0 0 0
45 0 0 0 0 0 0 0 0 0 0
46 0 0 0 0 0 0 0 0 0 0
47 0 0 0 0 0 0 0 0 0 0
48 0 0 0 0 0 0 0 0 0 0
49 0 0 0 0 0 0 0 0 0 0
50 0 0 0 0 0 0 0 0 0 0
51 0 0 0 0 0 0 0 0 0 0
52 0 0 0 0 0 0 0 0 0 0
53 0 0 0 0 0 0 0 0 0 0
54 0 0 0 0 0 0 0 0 0 0
55 0 0 0 0 0 0 0 0 0 0
56 0 0 0 0 0 0 0 0 0 0
57 0 0 0 0 0 0 0 0 0 0
58 0 0 0 0 0 0 0 0 0 0
59 0 0 0 0 0 0 0 0 0 0
60 0 0 0 0 0 0 0 0 0 0
61 0 0 0 0 0 0 0 0 0 0
62 0 0 0 0 0 0 0 0 0 0
63 0 0 0 0 0 0 0 0 0 0
64 0 0 0 0 0 0 0 0 0 0
65 0 0 0 0 0 0 0 0 0 0
66 0 0 0 0 0 0 0 0 0 0
67 0 0 0 0 0 0 0 0 0 0
68 0 0 0 0 0 0 0 0 0 0
69 0 0 0 0 0 0 0 0 0 0
70 0 0 0 0 0 0 0 0 0 0
71 0 0 0 0 0 0 0 0 0 0
72 0 0 0 0 0 0 0 0 0 0
73 0 0 0 0 0 0 0 0 0 0
74 0 0 0 0 0 0 0 0 0 0
75 0 0 0 0 0 0 0 0 0 0
76 0 0 0 0 0 0 0 0 0 0
77 0 0 0 0 0 0 0 0 0 0
78 0 0 0 0 0 0 0 0 0 0
79 0 0 0 0 0 0 0 0 0 0
80 0 0 0 0 0 0 0 0 0 0
81 0 0 0 0 0 0 0 0 0 0
82 0 0 0 0 0 0 0 0 0 0
83 0 0 0 0 0 0 0 0 0 0
84 0 0 0 0 0 0 0 0 0 0
85 0 0 0 0 0 0 0 0 0 0
86 0 0 0 0 0 0 0 0 0 0
87 0 0 0 0 0 0 0 0 0 0
88 0 0 0 0 0 0 0 0 0 0
89 0 0 0 0 0 0 0 0 0 0
90 0 0 0 0 0 0 0 0 0 0
91 0 0 0 0 0 0 0 0 0 0
92 0 0 0 0 0 0 0 0 0 0
93 0 0 0 0 0 0 0 0 0 0
94 0 0 0 0 0 0 0 0 0 0
95 0 0 0 0 0 0 0 0 0 0
96 0 0 0 0 0 0 0 0 0 0
97 0 0 0 0 0 0 0 0 0 0
98 0 0 0 0 0 0 0 0 0 0
99 0 0 0 0 0 0 0 0 0 0
100 0 0 0 0 0 0 0 0 0 0
Leave Leave
PYBL DAYS/
bal. as Jul '12 bal. as Aug '12
on on REMARKS
OT HRS
PL SL CL PL SL CL
21.5 15 3.5 2 11.5 3.5 2 DOL - 23.08.2012
27 14 3 2.5 14 0.5 2.5 DOL - 28.08.2012
31 13 2.5 3 13 2.5 0.5
28.5 12 2 3.5 12 2 3.5
19.5 11 1.5 4 11 1.5 4
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 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 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 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 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 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 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
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 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 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 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 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 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 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
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 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 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 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 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
