Thursday, 9 August 2007

Annual Leave Spreadsheet

This is something I did years ago and the other day someone asked if I still had a copy I could let them have.

I think it's fun sometimes to understand how something works (I draw the line at cars - I just drive them!) and therefore...

Click the images for a larger view.

This is the spreadsheet as seen for a single user. The blue squares representing a day's leave have a value of 1, but you could make the text colour the same as the background so all you see is a square. Equations in the columns to the right add up the number of coloured squares for the month and then deduct it from your allocation.

For a manager to keep track of a team's annual leave it's a case of adding more rows for each month (a different colour for each team member can be good) and ensuring the equations match the relevant line as leave is taken month by month.


Equations

B16: =B5
Then copy that down to B17:B25, B27:B36 etc. You will only have to enter staff names once now as it will automatically copy down from the first month into all other months.

AI5: =SUM(C5:AG5)
Then copy that down to AI6:AI14, AI16:AI25 etc. It adds all the taken leave for the row.

AJ5: =AK5+AL5-AI5
Then copy down to AJ6:AJ14 only. It adds the initial leave allocation (AK5) plus any leave brought forward from the previous year (AL5) and then takes off any leave taken during the current month (AI5)

AJ16: =AJ5-AI16
Then copy down to AJ17:AJ25, AJ27:AJ36 etc. It ensures that each month's remaining leave is based on the remaining allocation from the end of the preceding month.

Using the Spreadsheet

That's it! Fairly simple. Note that the coloured square in C1 has a value of 1 and the coloured and patterned square in C2 has a value of 0.5 to enable half day leave to be calculated.

When you add leave for anyone, copy and paste from either C1 or C2, rather than change the colour of cells to match - as that would not give them a value to be included in the calculations.

The coloured boxes for Sick Leave and Allowed Leave of Absence do not have a value as they would not be counted against annual leave allocations.

Every year you have to create a new blank and move the weekends (grey boxes) to match the dates of the new year.

Have a go! If you're desperate or have trouble getting it right, email me - bispham2[at]hotmail.com and I'll send it as an attachment.

239 comments:

1 – 200 of 239   Newer›   Newest»
Elminster13 said...

A very useful spreadsheet which was just what I was looking for. Thank you very much John.

Papalamour said...

A textbook example of a leave sheet. After several hours of banging head against desk when i tried to format a sheet to take into account that we would be employing several new members of staff. I found this!!!
And it works in NeoOffice too:))

Ta John

Nahla said...

an amazing spreadsheet, well organized, easily managed, and great endeavor.

Keep going on, it’s amazing job what you’re doing. All the best for you John :)

Lee said...

A fantastically organised sheet that is incredibly flexible and just what was needed. Thank you very much John.

stephiej said...

Thanks so much John. It's so simple and easy to customize and I didn't have to start from scratch! With only 4 staff this file is exactly what we need to keep track of our annual leave.

Shilpi said...

Thanks so much John. It's a really simple yet fantastically organised spreadsheet. The file is exactly what I was looking for to keep track of the team leaves.

Marc said...

Hi John,

Many thanks for the Spreadsheet. It will make keeping track of A/L so much easier.

Marc

Kate said...

Hi John
This is excellent and I’ll use it to maintain the leave for Don Adan Coffee Shop, just a small operation but it will allow the owner who is not hugely computer literate to track the leave her end.

Thanks again, much appreciated.
Kate
Sydney, Australia

Anna Kuznietsova,Ukraine said...

Dear John - thabnk you for sharing this great spreadsheet! Out of all the tools i found - yours was the only one that perfectly suited my purpose – to coordinate vacation schedules for our team
Everything else was aimed at specific HR department needs, calculations etc

Leanne Berry said...

Hi John

Thank you so much for emailing me your spreadsheet....I dont even have to tweak it to start using it...it has saved me hours of time..you are a gem..cheers Lee from Australia

Estelle said...

Hi John,Thank you for sending me your spreadsheet so quickly. It is just the sort of thing I was looking for and I'm sure the Team will think it's marvelous. It's a nine hour differnce at the moment between Australia and England, so not quite the middle of the night. Estelle :o)

Anonymous said...

Hi John, thanks for the super fast response to the request for the spreadsheet. Its exactly what I needed and has saved me a hugh headache with excel date formulae.

All the best

Don

Anonymous said...

Hi John,

Your spreadsheet was fantastic. Thanks very much.

Anonymous said...

Many thanks John.
I'm helping a friend running a small panel and this is exactly what we needed.

Cheers,
Kevin
Melbourne, Australia

draling said...

Thanks a million, John.
The spreadsheet was very user friendly.
I absolutely love it.

Anonymous said...

Thanks John, this spreadsheet is amazing and certainly very useful for my company. Saved me a lot of work! Kind regards

Anonymous said...

Thanks John, the annual leave spreadsheet is very useful and just what we need at our company. All the best!

Anonymous said...

Great post John, much appreciated, Ady

Anonymous said...

Thanks John, this spreadhseet is amazing and you are very generous to share it with us that need it!

Mr P said...

A simple yet intuitive spreadsheet that is easy to maintain! Thanks John, this was just what I was looking for. Kind regards, Mr P.

Bruno F said...

Thank you kindly John that spreadsheet is fantastic great use of Excel thank you very much

bruno said...

Thanks for the spreadsheet its great, excelent use of Excel thanks alot. Bruno

George said...

Just got this now. Looks very good. Thank you

Anonymous said...

Hi John and thanks for such a quick response.

This is excellent!

Simple to use, visually straightforward and works a treat!

Many thanks

Tracy

Dan said...

Thank you for sending me the Annual Leave spreadsheet. Its meets my needs exactly.

Thanks again.

Dave said...

Hi John

Many thanks for sharing this leave sheet. Your time spent creating this will certainly benefit me and the team I work with

Thanks again

khoohc1@gmail.com said...

Hi John,

Your spreadsheet is great and can be used universally. I am located in Malaysia and this is exactly what I am looking for. I am also using it for all my staff to plan their annual leave for the whole year. Have also create an individual version.

Thanks for your willingness to share.

Cheers.
Khoo Hai Chew (Malaysia)

Joclyn-Australia said...

This spreadsheet is perfect for seeing at a glance who is taking leave and when and who needs to take leave. There is no mucking about - fabulous!Thank you for providing us with your spreadsheet John and for your quick response.

Gail (Australia) said...

Hi John,
Thank you so much. Your spreadsheet is simple and easily changed to suit my requirements. With only three staff, you have made it easy for me to monitor annual leave. You are wonderful for sharing... much appreciated.

Anonymous said...

Hi John

Thanks for sharing this spreadsheet with me. its going to make the annual leave process a lot smoother going forward ......

Thanks again
Stuart

J Bonner said...

Thanks very much for the spreadsheet. I had devised something similar but was having difficulties with the formulas. Seeing how you've made things work has been a great help.

Anonymous said...

Your spreadsheet is wonderful thanks for providing it its made such a headache go away!!
Out of curiosity can I ask you how does it work that when you add a name to the first month it gets added to all?

again thanks for great work! and kindness

Juan

John Burke said...

For each member of staff the rows for following months each have a formula added so the name cell = the first name cell (ie of the first month). Therefore when you add a name to the first month it is automatically added to all other months.

John

Anonymous said...

Just amazing - helped me no end

Anonymous said...

Thank you so much John - you have helped me so much and made the hours of trying that i have done seem so simple. Your fast response has just been amazing.

Vanessa said...

I 'googled' simple annual leave spreadsheet and found a link to this one. Easily adapted and easy to use - it is everything I needed. Thanks John
Vanessa
Brisbane,Australia

Teddy said...

Hi John,

Thank you so much for sharing this useful spreadsheet. It has got everything I need to keep track and maintain the annual leaves of my team members.

It has saved me hours of time to create one. Well, we don't need to re-invent the wheel, rite? :))

Cheers,
Teddy (Singapore)

Faisal said...

Many thanks for providing this resource on the internet. A lot fo effort has gone into this and has save a huge amount of time.

Bryan said...

Thank you, John, for the copy of the spreadsheet! This will come in very handy for me.

tom said...

Does what it says on the tin- brilliant

Thanks John

Kate said...

Thanks very much for sending the spreadsheet. Having set it up it is exactly what we need to check our annual leave is spread over the year and much more convenient than the huge old manual holiday boards!

Lynn Polkey said...

After spending quite a bit of time trying (and failing!) to do this myself I searched online and found this. John very kindly emailed it to me and I'm delighted to say it does EXACTLY what I needed it do perfectly.
Thanks John!

sabra said...

Thank you so much John. Takes all the stress out of excel for this 'excel dummy'. Now I can track leave far more efficiently and at a glance

zero2here said...

Thanks so much for providing such an excellent resource to the public. This template was easily adapted to our needs. Very user-friendly and easy to customize. And your speedy response simply made my day. THANKS!!!! :)

Paul said...

Thanks John! Easy to work out leave balances etc. and see everything at a glance. I'll post it up at work and take pleasure in denying my staff their leave applications (kidding, slightly).

fran (melbourne) said...

Thank you so much. I can now see at a glance whether anyones schedules clashes with anothers. I have just over forty staff on it and it looks beautiful. Thank you again and I look forward to seeing what else you can do to help .

John Burke said...

Thanks to all who have commented. Inresponse to Fran from Melbourne, this blog was mainly to be based around project management and e-learning which is my work focus.

However I have created another blog Computer Basics for Free which has a similar function to this post.

The spreadsheet has gone literally around the world and each week brings three new requests for it on average. Slightly more interest than I'd dared to hope!

Damian said...

Dear John, thank you so much for making your Annual Leave Spreadsheet available. I am the manager of a small NGO youth service, I manage 12 staff on 28 hrs per week with no admin support. Be able to access tools like yours for free makes a world of difference to my job. Thank you again.

Sally, London said...

Thank you John for the excellent spreadsheet. It's very easy to use and add to and creates a very clear table for others to read. We are a small charity so being able to use your ready-made sheet saved us lots of time and resources.

jerry said...

very nice spreadsheet, I would like to download it, is there a download link here ??

thank you

zvonko said...

Hello John

I got the spreadsheet, thank you very much, very nice of you to share it around for free, I am going to use it at my work for tracking annual leave and sickies for approx. 40 ppl. I am planning to do some minor changes i.e. translating it into croatian language and including some additional conditional formatting, thanks again ...

zvonko, (makarska, croatia)

Lucy said...

Thanks so much John! This spreadsheet is amazing and exactly what I was looking for. It is very organized and has all little details that I needed.

Thanks again!

N. Gonzales said...

Dear John:

Thank you again for the spreadsheet. It will be very useful a I manage leave schedules of the office. Much appreciated.

Anonymous said...

Dear John, thanks for this, really helpful. Sean

Anonymous said...

would it be possible to get a copy of your amazing spreadsheet please?

John Burke said...

Yes, by emailing me at the address given at the end of the blog post.

Robert B said...

Hi John. I would really love a copy of your annual leave spreadsheet but I'm struggling to get hold of your contact details. The link to your website appears to be broken, but maybe I'm just being really thick. Can you help please?

Robert.

John Burke said...

At the foot of this blog post it gives my email address - j.burke[at]northumbria.ac.uk

Thanks for the heads up about the broken link though - that web site has gone as it was provided by my previous ISP.

John

Michael said...

Hi John,
An easy to use Annual Leave spreadsheet.It has all the features I require. Brilliant!

Best wishes
Michael

Robert B said...

Lovely little spreadsheet - nice and simple to use and maintain. Thanks John.

Anonymous said...

Thanks John!

Fantastic spreadsheet! so simple to use!

great system!

Lee

Stuart said...

The simplicity of the spreadsheet is what makes it so great. This takes all the hard work out of monitoring staff leave.
Many thanks John.

Roy said...

John, Just what I was looking for. Fantastic leave sheet.
Much appreciated.
Many thanks..

Anna Martin said...

That's great, thanks, John. My office will be astounded when I blind them with technology! I've now created one for 2010 and you could publish it on the web if you wanted.

Katja Conrad / Namibia said...

Dear John,

Thank You so much for sending me your spreadsheet. It is brilliant. You saved me a lot of time - and now after inspection of the formulars I understend, after all... So I am not as stupid as I thought ;o)

Thank You very much indeed !!!

Angie B said...

Thanks again John, excellent spreadsheet - quick and easy to use. Much appreciated

sheena said...

John
Thank you so much for the spreadsheet you sent me, it will help me a great deal.

All the best.

:o)

Anonymous said...

Thank you SO much for emailing me this spreadsheet. It's hugely appreciated as I am the first (and only so far!) employee at my new place of work, so we are still finding our feet and this will be no end of assistance.

Thanks once again.
S

adam said...

This is brilliant John,
Thank you so much... saved me a load of time and work.
I have to monitor the annual leave of 25 sales reps and this will be a big help, fantastic work!!!

Anonymous said...

Thanks this is just what was needed. Thanks very much

toblask said...

Great, thanks very much for the spreadsheet John, got it running already and very helpfull it is.
Thanks

Tom

Norm's Place said...

Great work, John. Much appreciated you response to my request. Thank you very much.

chery said...

Thanks, the best!

Rushdhi said...

This is the kind of spreadsheet that I was looking for. Its really great!. Will be implementing it begining Jan 2010.
Many Thanks for sending it to me.

Rushdhi.

Anonymous said...

Thanks very much for the spreadsheet John. Very very cool

Anonymous said...

Thanks John, your spreadsheet has helped me immensely...I manage 11 staff and have been manually recording their annual leave to date... which has proved not only time consuming but from the correct data your spreadsheet has now shown me I have been awarding more days than actually due!

thanks again, Fen

Anonymous said...

This spreadsheet is very helpful. I have been pondering the best way to set something like this up and found that John already had. Thanks for sharing and saving me a lot of time!

Eve said...

Thanks so much John. Fantastic, intuitive spreadsheet. Really kind of you to share.

Best Wishes,

Eve

everiley said...

John- thanks so much for sending me this attachment so quickly. Fantastic, intuitive spreadsheet design. Really kind of you to share.

All the best

Eve

K.Ramakrishnan said...

Thanks John, the spreadsheet saved me a lot of work.

Jay (Malaysia) said...

A very user friendly tool to track leave and staff performance. Well I actually find it useful in even tracking my staffs discipline at work....absenteeism, overtime,punctuality. Great work John!!)

Anonymous said...

John, you are a star! Thank you so much for this. It also helps me learn a bit more about the workings of formulas in Excel.

Monica

Carol , Nairobi, Kenya. said...

Dear John, just to say thanks a million for this great tool. I found it to be quite ingenious, with clear demacations on full day leave or half day leave,lie day, etc.

Quite useful and it has just skyrocketed my career as a Human Resources Officer for a small firm.. I cant thank you enough. And to think it also comes with a user manual that is just too handy. It provides continuous education for users on how to manipulate data on an exel spreadsheet.

Well done John and May success be yours on your Education Project.

Carol, Nairobi, Kenya.

Kathryn said...

Thank you so much for your generosity in sharing your work, and also for your speedy reply!

Just what our organisation neededboofla.

Thanks again,

Kathryn.

diana said...

this is what i've been looking for...
thank you so much for responding immediately to my request..u're awesome John..:)

cheers,
Diane

graham lyle said...

Absolutely brilliant makes my life so much easier and works straight out the box. thanks so much john

livinginparadise said...

It's so rare that someone makes something so useful available for free! Your spreadsheet seems to have been a great help to many people. Count me among them. Thanks, John.

Mark said...

Thank You John for sharing such a good thing. I love the holiday remaining function and how intuitive it is to use.

JoeyC said...

Thanks John for sharing this. It is so easy to use, it's complicated to do for a lot of people but you made it easy for everyone. All the best!!!

Shah V said...

Awesome! 3 years after posting John is still helping people (ie-me) and taking the time to reply to emails.
Finding free stuff is easy; finding USEFUL free stuff isn't. Thanks John!

Anonymous said...

Very very helpful - much appreciated - solved a lot of problems. Thanks very much :-)

Anonymous said...

John the cibernetic angel, thanks a lot for sharing this with us!!!

I wish you all the best.

Kris said...

I've used this spreadsheet for a long time at my previous workplace and couldn't wait to start using it in my new office!

Thanks for sending it John!

Steven said...

John

Thank you for your prompt response to my request, the spreadsheet is wonderful, very user freindly.

Thank you and much appreciated.

Keep up the good work

Steven
Port Moresby
Papua New Guinea

Steven said...

I requested this from John and whilst waiting gave it a go and created it myself ! Thanks a million for a simple but effective spreadsheet that will save no end of time. Regards Steve

Anonymous said...

Thankyou so much for the speedy reply! Just what I was looking for and will save me from lots of hours sitting at the computer!

All the best,

Vicky.

Helen said...

Thanks John. Apart from being incredibly useful, this spreadsheet has really helped my understanding of Excel. The gift that keeps on giving.

Marius said...

Thank you John for a quick response and a simple yet effective spreadsheed.

It seems a rare thing nowadays that a complete stranger would do something to make life easier and not try to sell it. Thank you again.

Marius
South Africa

Anonymous said...

Hi John,

Thanks a lot for your prompt response and help. This excel is very helpful and make our life easy.

It's very generous of you to share this.

Lee said...

Hi John

Thanks for prompt supply of the spreadsheet - I have added a few extra coloured squares to cover other types of absence to track such as flexi leave - but this was easy as you've done all the hard work already. The spreadsheet not only looks visually pleasing but is simple to use.

Many thanks for sharing it
Best wishes
Lee

Anonymous said...

Hi John,
Thank you so much for the spreadsheet. Starting up an Autism early intervention centre with minimum funding has been quite stressful. But having this easy to use spreadsheet is already making life easier for us IT/Admin novices.

Barbara/Australia

Claire said...

Thanks for sending this to me so quickly John - I work in education too and hope that it does what it says on the can. I'm going to have a quick play with it now, many thanks again,
Claire

Anonymous said...

OMG This is the best thing sinced sliced bread!!!!!
Fantastic John - thank you so much for making this available.
Winging my way through a new job - used this as one of my tasks - bosses are most impressed - THANKS!
I owe you a beer or two!
Michelle :-)

Anonymous said...

Hi John!

This is the absolute BEST A/L spreadsheet I have seen! Thank you so much for sharing it with me. I truly appreciate it!

I'll be watching this space to see what you come up with next...

Best From Dubai

Heather

Lorraine said...

Hi John

Thanks so much for sending the spreadsheet through. Just what I've been looking for. Thanks for sharing!

Rasha said...

Dear John,
I am proud to write on your web page.

Thank you for e-mailing me the "Annual Leave Spreadsheet" you saved my time, you are a life saver.

Thank God we have such a craetive person like you. Excellent Job.

Kind Regards
Rasha Oct. 2010

Anonymous said...

Hi John,

I just wanted to thank you for sending me a copy of the spread sheet. Being in Australia, I actually received your email late last night. I'm happy to say, that after staying up most of the night playing with the spread sheet, that I reluctantly dragged myself off to bed at 2am!

You have done such an amazing job. Thank you for being so kind as to share this with others.

I really appreciate this.

Thanks so much.
Karen
Karen

Anonymous said...

A very useful spreadsheet John. Thanks very much. I did follow the instructions and work it out myself which I was able to easily. I just didn't have the creativity to create it in the first place so having a template made it much easier.

Nicki, Hull

Anonymous said...

thanks a million for sending on a very useful spreadsheet, very clever, thanks again,
JH

Paul Stovell said...

John,
Thank you very much! I have made changes to cover the idiosyncrasies of my particular setup and it works perfectly. It has made life so much easier!

Thanks again

Paul

christine said...

Thank you so much for this very useful spreadsheet John. It will save us hours of work.
Christine

Anonymous said...

Hi John

Is it possible to obtain a copy of your spreadsheet? I have looked at the formula's you discuss in your blog to try ane create the sheet myself but I cannot fathom how you are counting the "coloured cells".
We also wish to track long service leave acruals so I will need to add to your sheet accordingly.

John Burke said...

Email me please. Though the coloured cells also hold the value 1

John said...

What a fantastic tool you have created John! Thank you so much for making it available, it has made life SO mcuh easier!
Keep up the great work and Thank You!

Anonymous said...

Hi John

Thanks for a great spreadsheet. Very helpful and logical.

Regards,
Guy

p.s. did you know there is a famous radio dj in South Africa called John Burkes

John Burke said...

There are, perhaps sadly, a great many John Burkes in the world. There used to be 9 in the Blackpool phone book alone many years ago - I've conquered the urge to keep up to date with that now! :-)

Presidents of cycling clubs, musicians all over the place, and possibly my favourite John Burke I've never met has a sea lion act in a German circus. We are legion...

For anyone who remembers a story in the Blackpool news several years ago; I am not the one who got thumped by his mistress's husband after being found in bed and unable to run away because he'd taken his wooden leg off...

Anonymous said...

Thanks very much, this would have taken me days to create... you are a champ

Anonymous said...

Many thanks for the spreadsheet John, simple to use yet sufficiently thoruough to capture all the details needed.

Very responsive on the e-mail as well!

Thanks,

Dan

Emma said...

Hi John

thanks so much for the spreadsheet - it has saved me so much time and hassle - really appreciate the quick response too.
emma

Anonymous said...

So quick response on email.
Template very usefull.
Thx a lot.

Ged said...

It's just the spreadsheet for the job - thanks John!

Anonymous said...

I had been looking for an excel sheet for long to track leave for my staff and your sheet was the best solution to what i needed, many thanks John
brgds surjeet

Caz said...

The spreadsheet is awesome, easy to use and a time saver. Thank you for allowing us to use this spreadsheet.
Carolyn.

Anonymous said...

Thank you so much John, you are a lifesaver! ;)

Naod said...

Great Work!Can i get the copy.
Many thanks

John Burke said...

You can get a copy by emailing me at the address shown in the left hand column of the blog.

John

Anthea said...

Thank you so much for sending me the annual leave spread sheet,it is perfect for us. It would have taken so much time to develop our own.....Thank you John.

Ashleigh said...

Thanks John. An easy to use spreadsheet that I have our whole office using now!

novicejory said...

This looks ideal. Could you email me a copy please. Thank you very much.

Jory

John Burke said...

You need to email me at the address shown in the left hand column. That way I will get your email address so I can send it. :-)

Peter said...

A useful template, easily adapted if required as there are no macros or unusual functions. Adapted it for my own use and running it with Libre Office (Open Office).

Anonymous said...

Thanks for the Spreadsheet John! you have saved us so much time with keeping track of everynes annual leave, very much appreciated!

Jasmine, Australia

CMcK_Pacon said...

Hi John
Thanks for the brilliant spreadsheet - really appreciate you sendin it on and has been a great help already in assigning Annual Leave. Many Thanks

Anonymous said...

Hi John, many thanks for giving me a template (a bit too hard to start from scratch for my knowledge!).
Simple system, efficient works fine for me. We are 6 staff and the entire year can be printed on 2 A4 sheets.
All the best. Chris

Ian C said...

Thanks John for sending a copy of your Annual Leave template. It works a treat!

brenb said...

John

I can't thank you enough for taking time out to send me your annual leave spreadsheet and the speed with which you replied. It is so clear and easy to use. Only wish I'd come across it sooner!

Brenda

Priscilla Lim said...

Thank you so much for taking time in sending me the useful spreadsheet. I greatly appreciate the assistance you have provided me.

Well done, John.

Danny Bhoy said...

Hi John,

Than you so much for the help with this spreadsheet. Such a life saver!. Works a charm and and its very easy to use.

Thanks
Dan

JaneHutch said...

Thank you for this fantastic, easy to use spreadsheet. I emailed for some help and within no time you emailed me the spreadsheet. You have helped me enormously. You rolled what I had in three seperate sheets into one.

thalton said...

Thanks for the spreadsheet.

You made my life easier and the spreadsheet is easy to use.

Fara said...

Thank you John. The spreadsheet helps me a lot in my work.

Brian said...

Thanks John. This is a really useful spreadsheet, and easy to use.
Much obliged.

Jenn said...

Simple and easy to use. Exactly what we needed for our small office. Thank you!

Emma said...

aedrompsThanks so much John. Just what I was looking for. Simple and clear. Much appreciated. Emma

Rakesh Hirani said...

This Annual Leave spreadsheet is amazing.

we have customised it slightly to manage the leave in hours instead of days which wasn't that diffcult to do.

very useful spreadsheet indeed!

thanks John! :D

Anonymous said...

This spreadsheet is a life saver!! I tried in vain on my own to get the formulas to work correctly. Unfortunatly, my excel skills were failing on me, so John took pity on me and forwarded his version and now I am rocking out leave tracking at my office!

Thanks JOHN!!!!

John Burke said...

Ah yes - this is the right attitude! Don't just monitor leave - rock out that tracking!!! :-)

rdanos said...

Thanks John! I have been trying to figure out how to create this type of sheet and was struggling.You saved me ☺

Paul F said...

Thanks very much for the template, John. This will save me lots of time and headaches in tracking people's annual leave....

Mark H said...

A great little spreadsheet! Just what we needed to track leave in our SME. We adapted slightly to also note Overtime Worked, but adding a cell with -1 or -0.5 for full or half days. Really good and well worth downloading. Thanks John!

Shaukat said...

Thanks alot John, really appreciate your quick response and that is exaclty what i was looking for.

Belinda Bell said...

Thanks for this John, can't believe how hard it was to find one that was useful. It's great. Thanks also for mailing me as an attachment.

Scott Waddell said...

Thank you so much, very simple to use it helped me out so much.

Great work

Adam said...

Awesome spreadsheet, does exactly what we need and very easy to use.

Thanks for sending this through John, good job!

Austin said...

Thank you so much for giving me the spreadsheet to work with. Very generous of you indeed. Has same me loads of time and brain power! Many thanks, Austin

Rebecca said...

Thanks John. What a great, easily customisable spreadsheet you have created. You've certainly made my work life much easier!

EHeath said...

Please help. I would love to try out your spreadsheet for a new job I have started as Administrator.

Thanks
EHeath

John Burke said...

@EHeath You need to email me - the address is in the article or in the left hand column. Otherwise I won't know where to send it.

John

Jacintha said...

Thank you so much John for sending me the spreadsheet so quickly! It is so simple and saved me a lot of time trying to get one done.

With gratitude from Singapore,
Jacintha

Anonymous said...

Thank you so much John its fantastic and has given me a few browny points in the office

Jacki

Anonymous said...

Hi John

Thank you very much for sending me the spreadsheet so quickly which is much appreciated. The spreadsheet is so easy to use and does exactly what I needed it for. Great piece of work that is beneficial to a lot of people and all the best. Thank you once again... B Iqbal :-)

Jennifer said...

~*Thank you SO much!*~ The spreadsheet is exactly what I need to help me in the office. Simply brilliant! Thank you , thank you! Jennifer

N Carroll said...

Thanks John,Exactly what I've been looking for and will make my life a lot easier.Really appreciated.

Anonymous said...

Thanks John, excellent spreadsheet and very helpful. Denise

CL said...

Thank you so much John, this is going to make my planning so much easier.

How do i organise it to be able to print a separate sheet for each employee detailing their annual leave plan individualy.

John Burke said...

@CL You could simply select the rows for other members of staff then do a [right-click] and "hide".

Print out for the member of staff then select a range of rows above and below the hidden rows and then [right-click] and "unhide" to bring them back.

Alternatively if you were going to print them on a regular basis, create a separate sheet for each person. Take my sheet and keep the top row for each month but delete the rest of the rows in each month. Then re-save the sheet for each member of staff.

John

Anonymous said...

Thanks so much John, Really appreciate your help. The spreadsheet is a great help to me :-)
Thanks for sharing your knowledge with everyone.

Lisa

Anonymous said...

Hi John,

I have been looking for something like this, would you please email me a copy at sawan_202@yahoo.com

Thanks
Sawan

Anonymous said...

A clean, simple and well thought-out solution to a matter that can be a real 'time-eater'. Easily expandable and very user-friendly.

John Burke said...

Have spotted the request from sawan_202 but ploease note, instructions for contacting me are given both in the post and in the blog's side panel. Please email me for a copy of the spreadsheet.

I read every comment (obviously, as I have to approve them!) but even with the best will in the world, I do read my email a little more regularly!
John

Anonymous said...

Thanks a lot John, much appreciated for your quick response

regards
Sawan

Liv said...

love the spreadsheet - extremely useful and exactly what i was looking for and thanks for the quick response!

Anonymous said...

Hi John
Superb, this really does "exactly what it sais on the tin"
Many thanks for the quick response and for creating something so simple and easy to use.
I run a small construction company with 5 employees and keeping track of days off, sick days etc. had become a nightmare, i trawled the web but only found dodgy sites or expensive sign up to stuff.
This really does keep it simple and from someone who comes across so genuine.
All the best John, your a star

Julie said...

Thanks John For the swift delivery, this is exactly what i need, and so easy to use.

Anonymous said...

The spreadsheet already become a valuable tool for me to manage my team's annual leave.

The best thing about this spreadsheet is that John has followed a very sound methodology.

K.I.S.S

Anonymous said...

I chanced upon this spreadsheet through a Google search, and have found it be the most simple and functional Annual Leave template around. John shows that it doesn't have to be an insurmountable task. Thank you Mr. Burke!

John Burke said...

You're very welcome - I normally only get called "Mr Burke" when I'm in trouble with the wife... :-)

Julie said...

Thanks so much for this - it's really comprehensive(and has saved me a looot of time!)

Cheers!
Julie

Dan/David said...

This is fantastic. The spreadsheet is exactly what I was looking for and does a great job tracking annual leave for all our staff.

Many thanks for the incredibly speedy response and giving up your time to help so many people with their excel woes.

Go John!

Anonymous said...

Thanks John, for being so generous with your spreadsheet and for responding so quickly to my email. I am extremely grateful - you have saved me an enormous amount of time!

Anonymous said...

An act of kindness - very grateful and will be most helpful

Jane said...

Absolutley perfect for what I need and such a quick response. Can't thank you enough!

DaveShaw64 said...

The spreadsheet is fantastic-clear, easy to use and does exactly what I want it too!! When you look at other ones on the web that you have to pay for it shows how good it really is!! Thanks John

Anonymous said...

Thank you very much for emailing me your spreadsheet, you saved me from big problems...
Extraordinary work! Simply brilliant.

Cheers,
Mandy

Adriana said...

Thank you so much for your kindness, time and the speediness in replying. So much appreciated.

Anonymous said...

Thank you for the quick response in sending the spreadsheet. It is really amazing that there is still someone out-there who would share his hard work for free! I am really thankful and wish you all the best!

Natalya Price said...

John, thank you very much indeed for the spreadsheet - it is really useful, very well done to you for producing such a great project! And a HUGE thank you for sharing it with us!

Best wishes,
Natalya.

FunnyNappy said...

is it possible to have a copy of it?
Thanks very much.

Allison said...

Hi John

Thanks very much for the spreadsheet. Easy to use and understand...it's exactly what I've been looking for.

John Burke said...

@FunnyNappy instructions for contacting me are given both in the post and in the blog's side panel. Please email me for a copy of the spreadsheet.

Rosemary said...

It provides good overview and application. Its simple to use and very useful. Thanks a lot

Anonymous said...

Dear John

I think your spreadsheet is amazing and user-friendly. Thank you so much for sharing the spreadsheet with me and others, very kind of you.

Anonymous said...

Great stuff, and fairly easy to amend for a April to April business year too!

Anonymous said...

Thanks John. Simple to use and make changes to - I need leave without pay as a separate type, and may add study leave too.

Have added 2013 for planning purposes too. Very easy to update.

Anonymous said...

Thanks John

Top Spreadsheet very useful and great for me to track everyones leave !!

Top Man.

EricS said...

this is a well organized spreadsheet just nice for a small office, very easy to read.
Thanks John!

anna said...

Excellent work!!Simple to use and very organized!
Thank you

Jez said...

This has saved me a lot of time and effort. As simple to use (and modify if required) tool. Brilliant. Thanks John.

Anonymous said...

Pestide
This sheet is incredibly organized, and so easy to customize. This saved me so much time and was excatly the type of spreadsheet I was looking for. Thank you so much for your generosity in sharing!!
All the best!!

Vana said...

Thank you so much for your generosity in sharing this brilliant spreadsheet! It was exactly what I was looking for: easy to use, organized and customizable.
All the best to you John : )

«Oldest ‹Older   1 – 200 of 239   Newer› Newest»