2014 Staff Leave Planner Excel Template (GPLv3)

We’re well into September so it is time to release the 2014 staff leave planner excel template.

(the download link is below)

Here’s all the new features I added to the template:

* Introduced the TOIL column – you can add TOIL days per employee.
This number will not change the allowance but will be used when calculating the remaining days
* Added totals for Holidays and Sickness per month
* Added examples to illustrated the features of the template
* Made improvements to formatting and styling to improve readability

I hope you find this template useful and in case it is too basic for you staff holiday planning needs then you may want to have a look at our advanced staff leave planner.

2014 Free Staff Leave Planner -StaffLeavePlanner_2014
Copyright (C) 2012-2013 Plamen Balkanski (LeaveWizard Limited)
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program.  If not, see http://www.gnu.org/licenses

Hyper Smash

About these ads
Tagged with: , , , , , , ,
Posted in 2014 Staff Leave Planner, Free Excel Leave Planner
8 comments on “2014 Staff Leave Planner Excel Template (GPLv3)
  1. anna says:

    What should we do about entering holidays across bank holidays? I notice that these entries are deducted from the ‘days left’ column. Is there a tweak we can make to a saved download?

    • plamenb says:

      Hi Anna,

      Thank you for your comment. This looks like a useful suggestion which I will make sure we add to the next version.
      In the meantime I have no quick answer for you but I am sure a solution is available.
      If you require more advanced features I would recommend having a look at our online leave planner – it comes with lots of features and competitive pricing plans.


  2. Adrienne says:

    i was using the planner up till yesterday and now it’s not ‘working’ ; it’s not automatically calculating ; and even trying the example doesn’t seem to be either

  3. Adrienne says:

    Having spent a very long time re-doing the planner yesterday; I went into it just now and although the formulas are still there its not calculating again ; WHY IS THIS? It’s very frustrating

  4. Adrienne says:

    and a week later the formulas are not working ; even on the template they are not working

    • plamenb says:

      Hi Adrienne,

      I am sorry that the spreadsheet is not working for you and I understand it can be frustrating.
      Unfortunately we are unable to reproduce the issue with the “vanilla” excel file.

      Because this is a free product we are also unable to support every single case however I would be happy to look at your file in this instance.
      Please get in touch via the contact form on LeaveWizard.com


  5. Andy says:

    Hi, great sheet… One question, why is September 1st not included in the conditional formatting?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

%d bloggers like this: