Spreadsheet: 271550d1381971873-accrual-vacation-schedule-to-forecast-note-the-year-employee-vacation-1-4-weeks-is-eligibl-017-annual-leave-entitlement-2
Sheet: Annual Leave

Date of Recruitment | Full Years Service to Date | Leave Entitlement  (weeks) | Next Anniversary of Recruitment | Increased Annual Leave due |  |  | [NAME] (weeks) |  |  |  | Recruitment Date Generator
1996-12-12 00:00:00 | 16 | 3 | 2013-12-12 00:00:00 |  |  |  | 4 |  |  |  | 1 | 2 | 2003 | 2003-02-01 00:00:00 | 1996-12-12 00:00:00
1997-01-21 00:00:00 | 16 | 3 | 2014-01-21 00:00:00 |  |  |  |  |  |  |  | 9 | 6 | 2009 | 2009-06-09 00:00:00 | 1997-01-21 00:00:00
1997-10-23 00:00:00 | 15 | 3 | 2013-10-23 00:00:00 | in 0 weeks |  |  |  |  |  |  | 24 | 5 | 1997 | 1997-05-24 00:00:00 | 1997-10-23 00:00:00
1998-05-01 00:00:00 | 15 | 3 | 2014-05-01 00:00:00 |  |  |  |  |  |  |  | 13 | 1 | 1995 | 1995-01-13 00:00:00 | 1998-05-01 00:00:00
1998-11-05 00:00:00 | 14 | 3 | 2013-11-05 00:00:00 | in 2 weeks |  |  |  |  |  |  | 18 | 2 | 1996 | 1996-02-18 00:00:00 | 1998-11-05 00:00:00
1998-12-10 00:00:00 | 14 | 3 | 2013-12-10 00:00:00 |  |  |  |  |  |  |  | 7 | 3 | 1996 | 1996-03-07 00:00:00 | 1998-12-10 00:00:00
1999-11-06 00:00:00 | 13 | 3 | 2013-11-06 00:00:00 | in 2 weeks |  |  |  |  |  |  | 23 | 2 | 2009 | 2009-02-23 00:00:00 | 1999-11-06 00:00:00
1999-12-02 00:00:00 | 13 | 3 | 2013-12-02 00:00:00 |  |  |  |  |  |  |  | 10 | 12 | 2003 | 2003-12-10 00:00:00 | 1999-12-02 00:00:00
2000-03-15 00:00:00 | 13 | 3 | 2014-03-15 00:00:00 |  |  |  |  |  |  |  | 13 | 2 | 2008 | 2008-02-13 00:00:00 | 2000-03-15 00:00:00
2001-09-12 00:00:00 | 12 | 3 | 2014-09-12 00:00:00 |  |  |  |  |  |  |  | 17 | 8 | 2002 | 2002-08-17 00:00:00 | 2001-09-12 00:00:00
2001-09-25 00:00:00 | 12 | 3 | 2014-09-25 00:00:00 |  |  |  |  |  |  |  | 25 | 10 | 1998 | 1998-10-25 00:00:00 | 2001-09-25 00:00:00
2002-03-15 00:00:00 | 11 | 3 | 2014-03-15 00:00:00 |  |  |  |  |  |  |  | 5 | 2 | 2011 | 2011-02-05 00:00:00 | 2002-03-15 00:00:00
2004-01-13 00:00:00 | 9 | 3 | 2014-01-13 00:00:00 |  |  |  |  |  |  |  | 23 | 10 | 2001 | 2001-10-23 00:00:00 | 2004-01-13 00:00:00
2004-03-21 00:00:00 | 9 | 3 | 2014-03-21 00:00:00 |  |  |  |  |  |  |  | 6 | 6 | 2001 | 2001-06-06 00:00:00 | 2004-03-21 00:00:00
2008-08-17 00:00:00 | 5 | 2 | 2014-08-17 00:00:00 |  |  |  |  |  |  |  | 10 | 2 | 1997 | 1997-02-10 00:00:00 | 2008-08-17 00:00:00
2009-04-22 00:00:00 | 4 | 2 | 2014-04-22 00:00:00 |  |  |  |  |  |  |  | 25 | 6 | 2002 | 2002-06-25 00:00:00 | 2009-04-22 00:00:00
2009-07-08 00:00:00 | 4 | 2 | 2014-07-08 00:00:00 |  |  |  |  |  |  |  | 21 | 1 | 1998 | 1998-01-21 00:00:00 | 2009-07-08 00:00:00
2009-08-28 00:00:00 | 4 | 2 | 2014-08-28 00:00:00 |  |  |  |  |  |  |  | 15 | 5 | 2002 | 2002-05-15 00:00:00 | 2009-08-28 00:00:00
2011-03-13 00:00:00 | 2 | 1 | 2014-03-13 00:00:00 |  |  |  |  |  |  |  | 20 | 2 | 2012 | 2012-02-20 00:00:00 | 2011-03-13 00:00:00
2011-11-27 00:00:00 | 1 | 1 | 2013-11-27 00:00:00 |  |  |  |  |  |  |  | 27 | 12 | 2000 | 2000-12-27 00:00:00 | 2011-11-27 00:00:00
2012-03-14 00:00:00 | 1 | 1 | 2014-03-14 00:00:00 |  |  |  |  |  |  |  | 4 | 11 | 2004 | 2004-11-04 00:00:00 | 2012-03-14 00:00:00
Previous Version
Date of Recruitment | Full Years Service to Date | Leave Entitlement  (weeks)
2013-06-02 00:00:00 | 0 | 0
2012-06-02 00:00:00 | 1 | 1
2011-06-03 00:00:00 | 2 | 1
2010-06-03 00:00:00 | 3 | 2
2009-06-03 00:00:00 | 4 | 2
2008-06-03 00:00:00 | 5 | 2
2007-06-04 00:00:00 | 6 | 2
2006-06-04 00:00:00 | 7 | 3
2005-06-04 00:00:00 | 8 | 3
2004-06-04 00:00:00 | 9 | 3
2003-06-05 00:00:00 | 10 | 3
2002-06-05 00:00:00 | 11 | 3
2001-06-05 00:00:00 | 12 | 3
2000-06-05 00:00:00 | 13 | 3
1999-06-06 00:00:00 | 14 | 3
1998-06-06 00:00:00 | 15 | 3
1997-06-06 00:00:00 | 16 | 3
1996-06-06 00:00:00 | 17 | 3
1995-06-07 00:00:00 | 18 | 4
1994-06-07 00:00:00 | 19 | 4
1993-06-07 00:00:00 | 20 | 4