Hi All can any one help me with the leave record format in excel - Needed Urgently thanks
From India
Acknowledge(0)
Amend(0)
From India
Acknowledge(0)Amend(0)
Dear All the Attached Leave Record Format will help you in Maintaing the leaves of employees annualy. regards dhanesh
From India, Gurgaon
Acknowledge(0)Amend(0)
5From India, Gurgaon
Acknowledge(0)Amend(0)
Hi Buddy I have prepared a new Leave Tracker just now for next year and I think it can be very useful for you and all other members of community. Regards, Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Hi Shiv,
This Leave tracker is really great. However, I need to make some small changes to it. Could you please provide me with the password so that I can customize it to suit my needs?
Thanks,
Sanchita
sanchitasen1@gmail.com
Acknowledge(0)Amend(0)
This Leave tracker is really great. However, I need to make some small changes to it. Could you please provide me with the password so that I can customize it to suit my needs?
Thanks,
Sanchita
sanchitasen1@gmail.com
Acknowledge(0)Amend(0)
Hi Shiv,
This leave tracker is really great. However, I need to make some small changes to it. Could you please provide me with the password so that I can customize it to suit my needs?
Thanks,
Sanchita
Acknowledge(0)Amend(0)
This leave tracker is really great. However, I need to make some small changes to it. Could you please provide me with the password so that I can customize it to suit my needs?
Thanks,
Sanchita
Acknowledge(0)Amend(0)
Hello Sir,
The format you attached here is really very useful and new to me. However, this sheet is protected via a password. Could you please advise what the password is? I need to change it as per my company's leave policy.
Best regards,
Lav--
From India, Delhi
Acknowledge(0)Amend(0)
The format you attached here is really very useful and new to me. However, this sheet is protected via a password. Could you please advise what the password is? I need to change it as per my company's leave policy.
Best regards,
Lav--
From India, Delhi
Acknowledge(0)Amend(0)
Hi Luv All the neccessary fields are unprotected so that users can make changes. Still if you want to make changes , password is "shiv". Regards, Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Sir shiv, I would like to change the Opening Balance to hours like 10.25 or 11.50 cause sometimes they file a leave for 2 hrs only and not half day...how to change those thing..thnks
From Philippines
Acknowledge(0)Amend(0)
From Philippines
Acknowledge(0)Amend(0)
Dear Shiv,
Please provide me with the password at https://www.citehr.com/misc.php?do=email_dev&email=ZGV3LnNpaGFnQG dtYWlsLmNvbQ==
Regards,
Darshna Sihag
From India, Thana
Acknowledge(0)Amend(0)
Please provide me with the password at https://www.citehr.com/misc.php?do=email_dev&email=ZGV3LnNpaGFnQG dtYWlsLmNvbQ==
Regards,
Darshna Sihag
From India, Thana
Acknowledge(0)Amend(0)
Dear,
You need to add one or two more criteria, i.e., similar to HD, you may add Short Leave (SH) or you can use some other codes which I have used, i.e., you may change LP into SH. You need to unprotect all the sheets, then in the master sheet, change LP into SH. Then add one more column in all the sheets, i.e., Jan-Dec at the end and calculate the sum as SH/4.
The password for the file is "shiv." You may need to change some more validations accordingly.
Thanks & Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
You need to add one or two more criteria, i.e., similar to HD, you may add Short Leave (SH) or you can use some other codes which I have used, i.e., you may change LP into SH. You need to unprotect all the sheets, then in the master sheet, change LP into SH. Then add one more column in all the sheets, i.e., Jan-Dec at the end and calculate the sum as SH/4.
The password for the file is "shiv." You may need to change some more validations accordingly.
Thanks & Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Hi Rohit,
Please make the following changes: unprotect the sheets, the password is "shiv."
Now, let's say you want to change the weekly off from Saturday to Friday in January. Just copy cell G5:G34 and paste it in F5:F34. Then, copy the data from I5:I34 and paste it to G5:G34. This will change your first weekly off. Similarly, do this for all week offs in all months.
You can change ML (A11) to CL and modify the description to Casual Leave instead of Mandatory Leave. The same changes will be updated in all the sheets automatically.
Please try this and let me know. Unfortunately, I am currently quite busy, so it will not be possible for me to work on individual requests at this time.
Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Please make the following changes: unprotect the sheets, the password is "shiv."
Now, let's say you want to change the weekly off from Saturday to Friday in January. Just copy cell G5:G34 and paste it in F5:F34. Then, copy the data from I5:I34 and paste it to G5:G34. This will change your first weekly off. Similarly, do this for all week offs in all months.
You can change ML (A11) to CL and modify the description to Casual Leave instead of Mandatory Leave. The same changes will be updated in all the sheets automatically.
Please try this and let me know. Unfortunately, I am currently quite busy, so it will not be possible for me to work on individual requests at this time.
Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Guys,
Why do I always receive the following whenever I try to open the file:
"You can only download ONE file in TWO minutes. Please wait for 2 mins for your next turn to download. The System Will Automatically Retry In 60 Seconds. You can retry yourself by clicking here."
By the way, could you email me the leave record tracker to wavebrembo@hotmail.com?
From Singapore, Singapore
Acknowledge(0)Amend(0)
Why do I always receive the following whenever I try to open the file:
"You can only download ONE file in TWO minutes. Please wait for 2 mins for your next turn to download. The System Will Automatically Retry In 60 Seconds. You can retry yourself by clicking here."
By the way, could you email me the leave record tracker to wavebrembo@hotmail.com?
From Singapore, Singapore
Acknowledge(0)Amend(0)
Friends I have already shared password for same. It is "shiv". I am trying to attach another unprotected copy, while not able to. Will attach it soon? Regards, Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
From India, Visakhapatnam
Acknowledge(0)Amend(0)
HI Rohit, Please find attached leave record format. It might Help. Regards Vipin
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Mr Shiv.. I can easily make out that u work for my company. Please delete all the links relating to the company. It will be an audit issue considering the department u r working for.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi Buddy,
Thanks a lot. Even I thought the same after uploading the template, but then I realized that all the links are intranet links and will not work on the internet, so it will not be an audit issue. However, I have still removed the template and will upload a new one.
Thanks & Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Thanks a lot. Even I thought the same after uploading the template, but then I realized that all the links are intranet links and will not work on the internet, so it will not be an audit issue. However, I have still removed the template and will upload a new one.
Thanks & Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Hello Friends Based on many of the users request I am attaching a new unprotected version of Leave Tracker. Regards, Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Excellent contribution Shiv would be appreciate if u give some guidance how to use this Lovely format......... seeking urs guidance Rekha
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi Rekha,
Few points that you need to keep in mind while using the tracker are:
1) Update only white cells.
2) Use the master tab to update details of all individuals in your team during the year. Keep on updating the same on a regular basis.
3) Update blank holidays according to your organization. This is used on all the sheets to calculate net working days.
4) Update staff names in January.
5) Let's say at the end of January, someone has resigned; you can use the "R" code for the same. In February, you can replace that individual with a new one by selecting from the drop-down menu (as you are updating the list of all team members in the master sheet).
6) I have considered two days as weekly offs. You can simply move it to any other day.
This tracker is very simple to use and understand. Let me know in case you have specific questions regarding the same.
Thanks & Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Few points that you need to keep in mind while using the tracker are:
1) Update only white cells.
2) Use the master tab to update details of all individuals in your team during the year. Keep on updating the same on a regular basis.
3) Update blank holidays according to your organization. This is used on all the sheets to calculate net working days.
4) Update staff names in January.
5) Let's say at the end of January, someone has resigned; you can use the "R" code for the same. In February, you can replace that individual with a new one by selecting from the drop-down menu (as you are updating the list of all team members in the master sheet).
6) I have considered two days as weekly offs. You can simply move it to any other day.
This tracker is very simple to use and understand. Let me know in case you have specific questions regarding the same.
Thanks & Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Hello Dhanesh,
I went through your leave record format, it's really good, but I have a query. Is it only for a single user or can it be used for multiple users? I tried to use it but every time it overwrites the single user. I am a bit confused because if it is for a single user, then why have you mentioned the number of rows for multiple users in sheet 2 (Leave balance)?
Please guide me so that I can use it in my organization.
Regards,
Saloni:icon1:
From India, Ludhiana
Acknowledge(0)Amend(0)
I went through your leave record format, it's really good, but I have a query. Is it only for a single user or can it be used for multiple users? I tried to use it but every time it overwrites the single user. I am a bit confused because if it is for a single user, then why have you mentioned the number of rows for multiple users in sheet 2 (Leave balance)?
Please guide me so that I can use it in my organization.
Regards,
Saloni:icon1:
From India, Ludhiana
Acknowledge(0)Amend(0)
Hello,
I work for a software company and I am responsible for handling the HR duties here. I maintain leave records on a daily basis, which is very simple with a daily record format.
Please check the attachment, which will give you a clear idea of the process.
Thanks, Omika :)
From India, Mumbai
Acknowledge(0)Amend(0)
I work for a software company and I am responsible for handling the HR duties here. I maintain leave records on a daily basis, which is very simple with a daily record format.
Please check the attachment, which will give you a clear idea of the process.
Thanks, Omika :)
From India, Mumbai
Acknowledge(0)Amend(0)
Please help me. I need a leave application form for workers. With our present format, it is very difficult to keep track of workers with their resume date. If possible, please send leave application formats.
I will be thankful to you.
Regards,
Jyoti
From India, Mumbai
Acknowledge(0)Amend(0)
I will be thankful to you.
Regards,
Jyoti
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Shiv,
Thank you once again for the wonderful leave tracker. You have created sheets (Yearly PL) for Monthly PL Record and Monthly Sickness (Yearly SL) Record in the Leave Status category, but there is no separate sheet for Casual Leaves. I would like to add the same. Can you please explain it to me systematically or make the changes in the leave tracker as per my request and send it to rensat_2000@yahoo.com? It would be of great help.
Seeking your advice. Please do the needful.
Thanks,
Satish Renikunta
From India, Hyderabad
Acknowledge(0)Amend(0)
Thank you once again for the wonderful leave tracker. You have created sheets (Yearly PL) for Monthly PL Record and Monthly Sickness (Yearly SL) Record in the Leave Status category, but there is no separate sheet for Casual Leaves. I would like to add the same. Can you please explain it to me systematically or make the changes in the leave tracker as per my request and send it to rensat_2000@yahoo.com? It would be of great help.
Seeking your advice. Please do the needful.
Thanks,
Satish Renikunta
From India, Hyderabad
Acknowledge(0)Amend(0)
hello shiv, i was trying your leavetracker and have some questions I havelisted all in attachment
From India, Visakhapatnam
Acknowledge(0)Amend(0)
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Dear Dhanesh, Can u pls attached this sheet again after removing the password or else request u to pls provide the password, so that i can open the file. Thanks in advance. Regards, Shiwani
From India, Chandigarh
Acknowledge(0)Amend(0)
From India, Chandigarh
Acknowledge(0)Amend(0)
Dear Dhanesh Kumar,
Sir, could you please tell me how to make an Excel sheet password protected? I want to ensure the following:
1) No changes can be made in any cell after the final preparation of the sheet.
2) The Excel file itself cannot be opened by anyone else except the one who password-protected it.
3) No sheets can be deleted or added after the final preparation.
Thank you very much for the guidance.
Regards,
Vikas (vikas_2003@hotmail.com)
From India, Pune
Acknowledge(0)Amend(0)
Sir, could you please tell me how to make an Excel sheet password protected? I want to ensure the following:
1) No changes can be made in any cell after the final preparation of the sheet.
2) The Excel file itself cannot be opened by anyone else except the one who password-protected it.
3) No sheets can be deleted or added after the final preparation.
Thank you very much for the guidance.
Regards,
Vikas (vikas_2003@hotmail.com)
From India, Pune
Acknowledge(0)Amend(0)
[QUOTE=narendarmhril;1299877]
Hi,
Thanks for sharing the Leave Tracker. Could you please help me with loading the Analysis ToolPak?
You can load the Analysis ToolPak by following these steps in Excel:
1) Go to Tools
2) Select Add-Ins
3) Check Analysis ToolPak and Analysis ToolPak - VBA
4) Click Ok
5) Close Excel and reopen it. The Analysis ToolPak should be functional.
Alternatively, you can visit the instructions page in the Leave Tracker and click on "Load the Analysis ToolPak," which will automatically load it for you.
Many thanks.
Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Hi,
Thanks for sharing the Leave Tracker. Could you please help me with loading the Analysis ToolPak?
You can load the Analysis ToolPak by following these steps in Excel:
1) Go to Tools
2) Select Add-Ins
3) Check Analysis ToolPak and Analysis ToolPak - VBA
4) Click Ok
5) Close Excel and reopen it. The Analysis ToolPak should be functional.
Alternatively, you can visit the instructions page in the Leave Tracker and click on "Load the Analysis ToolPak," which will automatically load it for you.
Many thanks.
Regards,
Shiv
From India, Visakhapatnam
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Leave card format.xls