Keep Track of Leave Taken for 2010
The 2010 update to our annual Holiday Leave Tracker tool now comes in two versions:
- Personal Leave Tracking
- Small Department Leave Tracking
with a choice of starting dates (January 2010 or April 2010) for both.
The Small Department Leave Tracking tool is currently available for up to 12 employees, with a front summary sheet for easy overview.
Download
Click on the relevant link below to download your required Leave Tracker Tool:
Personal Leave Tracker Tool (Jan 2010 to Dec 2010)
Personal Leave Tracker Tool (Apr2010 to Mar 2011)
Small Department Leave Tracking Tool (Jan 2010 to Dec 2010)
Small Department Leave Tracking Tool (Apr 2010 to Mar 2011)
Instructions
- Download the Leave Tracking tool most appropriate for your needs
- Open the spreadsheet and, if prompted to do so, ‘enable macros’
- Fill in the green cells for a) Carry Over and b) Annual Entitlement
- When taking a day off or a day ill, simply click on the drop downs in each day and select
- Everything else is calculated for you
If you are using the Department Leave Tracking tool, enter the names of your staff in the front summary sheet and select their names in drop downs in each worksheet.
If you are interested in learning how to develop your own interactive assessment tools in Excel, get in touch with Adam Blackwood (a.blackwood@kent.ac.uk) and we may be able to provide training for you.