Hr Professional
Dhanesh Kumar
Recruitment & Payroll
Satish Renikunta
Manager (hr& Admin)
Darshna Sihag
Hr Professional
Administration,office Setup
+8 Others

Thread Started by #ravimurthy

Hi All can any one help me with the leave record format in excel - Needed Urgently thanks
26th December 2008 From India
Dear All the Attached Leave Record Format will help you in Maintaing the leaves of employees annualy. regards dhanesh
27th December 2008 From India, Gurgaon

Attached Files
Membership is required for download. Create An Account First
File Type: xls Leave Record Format.xls (50.5 KB, 9721 views)

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
29th December 2008 From India, Visakhapatnam
Hi Shiv,
This Leave tracker is really great. But I need to do some small changes in it. Can you please provide me the password so that I can arrange it as my need.

30th December 2008
Hi Shiv,
This Leave tracker is really great. But I need to do some small changes in it. Can you please provide me the password so that I can arrange it as my need.

30th December 2008
Hello Sir,
Format which you attached here is really very useful & new also to me. But this sheet is protected via password, could you please advice what is the password, I need to change it as per my company leave policy.
Best regards
5th January 2009 From India, Delhi
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
5th January 2009 From India, Visakhapatnam
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 to change those thing..thnks
7th January 2009 From Philippines
Dear Shiv,
pls provide me password at
Darshna Sihag
8th January 2009 From India, Thana
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
Hi Rohit
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
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
14th January 2009 From India, Visakhapatnam
HI Rohit, Please find attached leave record format. It might Help. Regards Vipin
16th January 2009 From India, New Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls leave record format.xls (50.5 KB, 831 views)

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.
17th January 2009 From India, Hyderabad
Hi Buddy
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
Hello Friends Based on many of the users request I am attaching a new unprotected version of Leave Tracker. Regards, Shiv
19th January 2009 From India, Visakhapatnam

Attached Files
Membership is required for download. Create An Account First
File Type: xls Leave Tracker_New_Unprotected.xls (1.89 MB, 954 views)

Excellent contribution Shiv would be appreciate if u give some guidance how to use this Lovely format......... seeking urs guidance Rekha
31st January 2009 From India, Delhi
Hi Rekha
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
hello Dhanesh,
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.
Omika. :)
3rd March 2009 From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls Leave record for 08-09.xls (132.0 KB, 595 views)

Please help me.I need a leave application form for workers.with our present format it is very difficult to keep tarack of workers with his resume date.if possible please send leave application formats.
I will be thnkful to you
13th March 2009 From India, Mumbai
Hi shiv,
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
Satish Renikunta
27th June 2009 From India, Hyderabad
hello shiv, i was trying your leavetracker and have some questions I havelisted all in attachment
18th January 2010 From India, Visakhapatnam
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
26th August 2010 From India, Chandigarh
Dear Dhanesh Kumar,
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.
Vikas (
29th September 2010 From India, Pune
Hi Friend
You can load analysis tab by going selecting following in excel :
1) Tools
2) Add-Ins
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.
Many Thanks.
19th October 2010 From India, Visakhapatnam
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 @ 2019 Cite.Co™