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
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
1 Attachment(s) [Login To View]