Recruitment & Payroll
Manager (hr& Admin)
29th December 2008 From India, Visakhapatnam
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 master change LP into SH. Then add one more column in all the sheets i.e.Jan-Dec at the end and give calculation for sum as SH/4.
Password for file is "shiv".
You may need to change some more validations accordingly.
Thanks & Regards,
11th January 2009 From India, Visakhapatnam
Please make following changes. Unprotect the sheets,password is "shiv".
Now let say if you want to change weekly off from Saturday to Friday in Jan, just copy cell G5:G34 and paste in F5:F34 and again copy data from I5:I34 and paste it to G5:G34. This will change your first weekly off. Similarly do it for all weekoff's in all months.
You can change ML (A11) to CL and change description as Casual Leave instead of Mandatory Leave. Same will be updated in all the sheets automatically.
Please try and let me know.
It will not be possible for me to work on individual request at this point of time as I am kinda busy now a days.
12th January 2009 From India, Visakhapatnam
Why do I always receive the following whenever I open tried 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 Shiv,could email to me the leave record tracker to
13th January 2009 From Singapore, Singapore
Thanks allot. Even I thought of same after uploading the template, while then I realised that all links are intranet links and will not work in internet and will not be an audit issue. But still now I have removed the template and will upload new one.
Thanks & Regards,
19th January 2009 From India, Visakhapatnam
Few points that you need to keep in mond 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 same on regular basis
3) Update blank holidays according to your organisation. This is used all the sheets to calculate net working days.
4) Update taff name in Jan.
5) Let say in Jan end someone has resigned you can use R code for same. In Feb you can replace that individual with new one, select from drop down (as you are updating list of all team members in master sheet)
6) I have considered two days as weekly off's. You can just move it to any other day.
This tracker is very simple to use and understand. Let me know,in case you have specific questions egarding same.
Thanks & Regards,
31st January 2009 From India, Visakhapatnam
I went through your leave record format,its really gud, but I have a query. Is it only for single user or can be used for multiple users. I tried to use it bt every time it over write the single user. I am a bit confused, because if it is for single user then in sheet 2( Leave balance) why u have mention no. of rows for multiple users?
Please guide me so that i can use it in my Organization..
24th February 2009 From India, Ludhiana
I am working for Software company. I am the one who are handling the HR over here. I am Maintaing the Leave records on daily basis Which is very simple & daily basis record format
Please check the attachement through which you will be able to get the exact idea for the same.
3rd March 2009 From India, Mumbai
Thanx once again for wonderful leave tracker.
You have created sheets (Yearly PL)for Monthly PL Record and Monthly Sickness (Yearly SL) Record in Leave Status category but there is no seperate sheet for Casual Leaves. I would like to add the same. Can you please explain me systematically? or make the changes in the leave tracker as per my request and send it to . It will be of great help.
Seeking your advice. please do the needful
27th June 2009 From India, Hyderabad
Sir can you please tell me how to make a excel sheet password protected. I want to know that:
1) No changes can be made in any cell after the final preparation of the sheet.
2) Excel file itself can not be open by any one else except who password protected it.
3) No sheets can be deleted or added after the final preparation.
Thank you very much for the guidance.
29th September 2010 From India, Pune
You can load analysis tab by going selecting following in excel :
3) Select Analysis ToolPak and Analysis ToolPak - VBA
4) Press Ok
5) Close excel and reopen it. Anaysis toolpak will work
Alternatively go to instructions page in Leave Tracker and click on "Load the analysis toolpak" and it will automatically load it for you.
19th October 2010 From India, Visakhapatnam