View Poll Results: is this sheet help you or you need more customize sheet
Yes 100 77.52%
No 21 16.28%
Wanna contact me 10 7.75%
I did not like this 9 6.98%
Multiple Choice Poll. Voters: 129. You may not vote on this poll

Kannanmv
Hr & Administration
HR_Mind
Hr Professional
Mandarsandeep
Managing Director
Omkar Kamthe
Mis Executive
+3 Others

Thread Started by #HR_Mind

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 "
5th January 2014 From India, New Delhi
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 ????
5th January 2014 From India, New Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls aTTENdance Master Sheet.xls (545.5 KB, 5771 views)

in status sheet you can see all the details by changing emp code and month :)
5th January 2014 From India, New Delhi
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.
7th January 2014 From India, Madras
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 ...
7th January 2014 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.
8th January 2014 From India, Madras
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 .
8th January 2014 From India, New Delhi
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
8th January 2014 From India, Madras
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
25th January 2014 From India, Kochi
Hi binil, Send me your query to me i ll do all amendments according to your convenience.
25th January 2014 From India, New Delhi
Hi Pawan, Thank you for your quick reply.
Our is a Manufacturing co. & also with Sales & Service staff at branches
(all over permanent + probation Emp = ~ 100)
And the types of Leave's are:-
1. CL/SL - Casual Leave
2. EL - Earned Leave
3. OT - Over Time
4. CO - Comp Off
5. SPL - Spl Leave
6. H- Holidays
7. P - Present
8. OD - Out Duty
9. LOP
COA, COR column not needed.
Regards
Binil
25th January 2014 From India, Kochi
Hi Pawan, Please find the model attached Regards Binil
30th January 2014 From India, Kochi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sample Req..xls (176.5 KB, 332 views)

Dear HR_Mind, It is getting Hang when I am trying to save data after putting anywhere. Please suggest if it needs some special configuration on my system to run.
23rd June 2014 From India, New Delhi
Dear Pragmatik India,
no any special configuration require,
i have prepared that one in office 2010. please try on that.
or do one thing go on file and do save as 2003 mode you will get better view(if you are not using windows 7)
for any kind of help you can mail me your queries at .
i will reply in sat on sun.
25th June 2014 From India, New Delhi
hello dear Pawan, this attendance sheet so great, but i need edit it , so could you please unprotected this sheet ?
5th March 2017 From Iraq, Sulaymaniyah
Sir please give me a Password small changes in my attendance list & leave Please My Mail.ID : rsprince.m6@gmail.com Raghavendra D
15th May 2017 From India, undefined
Hi pawan, very useful file, good job Could you please help me for unprotected the sheet which is to be add some more data. Regards, Sameer Chakrawarti
31st May 2017 From India, Jabalpur
sheets is password protected can u help me out with the password
16th July 2017 From India, Delhi
good job would appreciate
if the password shared, as it was protected.
26th July 2017 From India, Mumbai
Dear Sir the sheet is too good to calculate the attendance. Thanks for creating this. But it is a password protected sheet/workbook because of which we are not able to add more then 10 people. Please help
18th August 2017 From India, Ambala
hello sir,
Thank For uploading such a perfect file. its very useful.
can you just explain what is
1. ODK
2. ODU
3. ODG
4. ODL
5. COA
6. COR
7. SP1, SP2, Sp3, SP4, Sp5
as well as how to change the year of this attendance. i have change the current year 2019
8th January 2019 From India, Mumbai
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™