Spreadsheet: 169520d1342914593-excel-2007-attendance-and-resource-allocation-spreadsheet-estate-attendence-wage-sheet-with-salary-pf-calculation
Sheet: jan 2013

Present |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Paid Leave |  |  | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLS CHANGE THE DAYS AS PER MONTH
Absent |  |  | A
Holiday |  |  | H
Sunday / Weekly Off |  |  | W
 |  |  |  |  |  |  |  | Please change the attendance cycle as per your cycle
Sl No. | Emp No | Emp. Name | DOJ | Designation | Location | Reporting Manager | DOL | 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 | This Month | Previous | total | Leave | W/O | Holiday | Tot. Days | Days Payable | Wage | HRA | CONV. | GROSS | EA. BASIC | EA. HRA | EA. CON | GROSS | ADVAN. | Prev Debit | EPF | FPF | T. DEDU | PAYABLE
 |  |  |  | XYZ
1 |  | Muthamma |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
2 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
3 |  | Soorie |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
4 |  | Subhadra |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
5 |  | Suseela |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
6 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
7 |  | Selvam |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
8 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
9 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
10 |  | Vellachi |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
11 |  | Devani |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
12 |  | Suresh Kumar |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
13 |  | Chandran |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
14 |  | M Girija |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
15 |  | Suma |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
16 |  | Santhakumari |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
17 |  | K Sunil |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
18 |  | Rajappan |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
19 |  | Suharabhanu |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
20 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
21 |  | Ravi |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
22 |  | Kaliamma |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
23 |  | Ravi Kumar |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
24 |  | Bindhu |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
25 |  | Rajesh |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
26 |  | Sumathy |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | CASUALS
27 |  | K Vinu |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
28 |  | Vellamkari |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
29 |  | satheesh |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
30 |  | Beena |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
31 |  | Sujatha |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
32 |  | Subhash |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
33 |  | Sindhu |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
34 |  | Sudheesh |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
35 |  | Palani |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
36 |  | Saji |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
37 |  | T Suresh |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W |  |  |  |  |  |  | W
 |  | Total