gurpreet_singhmann
2

Hi all,

Thanks for showing so much interest in my work. I am really excited to see such a response.

Lockwood- Really appreciate it.

Rameshbala- Can i have your email id so that i can send it to you?

Bhavani Prasad - Mailed to you.

Sumit/shreekanth - This is a default format and you will have to make amendments as per your requirements.

Please check thes points:

1) If anyone has not taken leave, it will remain as 0 by default as it is counted as 0 leaves however if someone has taken a leave, you will mark the leave by selcting the type of leave from the drop down menu.

e.g.

Suppose a person has taken leave on 5th of the month, then you will select the drop down menu on 5th infornt of his name and select the type of leave.

This will add up to his monthly total and daily total of the team.

2) Please go through my previously given detailed comments.

3) For other points , kindly be specific what u need to know abt the format.

Bibhutosh Bhadauria - kindly go through the detailed comments i have given with the attachments and confirm which point needs to be clarified on.

subhashmalik - I hope, this file gives u solution. If it doesn't then pls confirm whts more required or how it's required.

Actions required:- Apart from entering monthly details of leaves, now u just have to put the no. of days a person has worked in holidays (any holidays/sun) and then it will add up.Formulas have been amended to reflect the holidays working as planned working days.

====

Thanks

Gurpreet Singh

From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls attendance_tracker_632.xls (39.0 KB, 872 views)

subhashmalik
2

Thanks a tonne for the work you have done it is really useful for all. hoping more from you in future.will keep in touch with you.This is worth more when we pass it on. regards...
From India, New Delhi
divya choubey
12

hi... u hv used planned ,unplanned, uniform etc on this... plz explain wat is the meaning or concept... Regards Divya
From India, Bangalore
paromita26
3

Hey gurpreet....... This a absolutely fabulous!!!!!! Useful doc for tracking attendance.... Thanx a million..... Hats off to you Mr. Guru!!!!! Regards, Paromita Mukherjee
From India, Bangalore
rence_sweet
Dear sir
Please help me how to use this format. it is very nice format , i would like to use in a practical way.
my email id is , you can give me advise on this id also.
Regards with thanks
Hiren

From India, Pune
emmiz
Great Work but i have one confusion in it what if some one present than what he/she select from the sheet plan-1 or what please let me know i am bit confuse

jignesh.amin
1

hi its really very much useful tracker mainly for small organization where attendance are maintain manually. thanx Jignesh J. Amin
From India, Ghaziabad
bushra khalid
Can you plz help me with one thing if someone is present what we are supposed to enter in the sheet i am a bit confused sbout this thing help me because i have to do this. thanx
From Pakistan, Lahore
pramood sanap
hi this is pramod grate information , i got little problem, can u elaborate more on it with eg waiting for reply regards pramod
From Singapore, Singapore
smitar_msm@yahoo.co.in
5

Hi Gurpreet, What does mean Planned and Unplanned. dont you thinh it is unprofessional to write planned and unplanned. Smita
From India, Guwahati
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.