This complete attendance sheet.
you just need to enter or alter data in last sheet and this will give you customize sheet according to you.
you can enter 10 ppl employee code name date of joining.
enter opening balance , and enter daily attendance month wise.
here H means holiday like sun, sat
P for present
EL for earn leave
SL seek leave
COR comp off raise
COA comp avail.
for more stuff you can contact me
on " pawankmr.hr (@) gmail.com "
From India, New Delhi
37you just need to enter or alter data in last sheet and this will give you customize sheet according to you.
you can enter 10 ppl employee code name date of joining.
enter opening balance , and enter daily attendance month wise.
here H means holiday like sun, sat
P for present
EL for earn leave
SL seek leave
COR comp off raise
COA comp avail.
for more stuff you can contact me
on " pawankmr.hr (@) gmail.com "
From India, New Delhi
Dear M.V.KANNAN,
please alter the insert data sheet ..
all the things in will be automatically update in master sheet and status update.
then you have to just update leave record in monthly sheet ...
in status sheet you can change the employee code by drop down menu and you will get updated data for that employee
same in status sheet you will get updated data by changing month (drop down )
hope it will clear to you...
for any other clarification you can mail me ...
From India, New Delhi
please alter the insert data sheet ..
all the things in will be automatically update in master sheet and status update.
then you have to just update leave record in monthly sheet ...
in status sheet you can change the employee code by drop down menu and you will get updated data for that employee
same in status sheet you will get updated data by changing month (drop down )
hope it will clear to you...
for any other clarification you can mail me ...
From India, New Delhi
Greetings Pawan,
Thanks for the clarification. It works well. Earlier you had mentioned that data can be entered for 10 persons. Just wanted one last clarification as to whether this number can exceed 10 persons. In other words can data be entered for more than 10 persons.
From India, Madras
Thanks for the clarification. It works well. Earlier you had mentioned that data can be entered for 10 persons. Just wanted one last clarification as to whether this number can exceed 10 persons. In other words can data be entered for more than 10 persons.
From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Attendance sheet.xls