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.
Regards,
Shiv
From India, Visakhapatnam
5Please 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.
Regards,
Shiv
From India, Visakhapatnam
Guys,
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
From Singapore, Singapore
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
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
From India, Visakhapatnam
From India, Visakhapatnam
HI Rohit, Please find attached leave record format. It might Help. Regards Vipin
From India, New Delhi
From India, New Delhi
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
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,
Shiv
From India, Visakhapatnam
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,
Shiv
From India, Visakhapatnam
Hello Friends Based on many of the users request I am attaching a new unprotected version of Leave Tracker. Regards, Shiv
From India, Visakhapatnam
From India, Visakhapatnam
Excellent contribution Shiv would be appreciate if u give some guidance how to use this Lovely format......... seeking urs guidance Rekha
From India, Delhi
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,
Shiv
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,
Shiv
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..
Regards--
saloni:icon1:
From India, Ludhiana
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..
Regards--
saloni:icon1:
From India, Ludhiana
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.
Leave record format.xls
Format of leave record (year).pdf