View Poll Results: is this sheet help you or you need more customize sheet
Yes 149 80.11%
No 26 13.98%
Wanna contact me 12 6.45%
I did not like this 12 6.45%
Multiple Choice Poll. Voters: 186. You may not vote on this poll

HR_Mind
37

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
HR_Mind
37

i guess in last post i forgot to attached sheet. please send me feedback also that it was good for you or not would you like to improve it ????
From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls aTTENdance Master Sheet.xls (545.5 KB, 7376 views)

HR_Mind
37

in status sheet you can see all the details by changing emp code and month :)
From India, New Delhi
kannanmv
256

Greeting Pawan,
You have created a VLOOKUP link to a Masterdata sheet & I do not find the Masterdata sheet for me to make amends either in the employee name or date of joining. Can you kindly enlighten on this please.

From India, Madras
HR_Mind
37

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
kannanmv
256

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
HR_Mind
37

Dear M.V.KANNAN,
of-course this can be end number of, i have just created for 10 as a gift if you want to change it, i will change for you.
just mail me your requirement. what you need to change i ll do for you .

From India, New Delhi
kannanmv
256

Greetings Pawan,
Thank you very much for your voluntary help, I have tried it out and it works well. I wish to appreciate you for the interest evinced by you in helping people with the software developed by you.
Regards

From India, Madras
binil.b
Hi Pawan,
Very useful file, Good Job!!!
But seems like the file is protected and unable to edit.
Could you please help me with this, as I need to include some more data & need to amend some changes.
Regards
Binil

From India, Kochi
HR_Mind
37

Hi binil, Send me your query to me i ll do all amendments according to your convenience.
From India, New Delhi
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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.