Spreadsheet: 70384d1271163734-calculating-average-duration-employee-turnover
Sheet: Employee data

Employee turnover |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993
 |  |  | Todays date: |  |  |  |  |  |  |  | average term |  |  | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  | # starters
 |  |  |  |  |  |  |  |  |  |  | # leavers
 |  |  |  |  |  |  |  | Stability | Stability |  | #total employees
P/R # | Start date | Start year | Leaving date | Leaving year |  | Length of employment | Employed term | > 1 Year | >1 yr & current |  | % turnover
 | 1993-01-25 00:00:00
 | 1994-01-10 00:00:00
 | 1996-09-02 00:00:00
 | 1997-03-31 00:00:00
 | 1998-08-24 00:00:00
 | 1998-09-02 00:00:00 |  | 2008-06-30 00:00:00
 | 1998-11-16 00:00:00
 | 1998-12-14 00:00:00
 | 1999-01-18 00:00:00
 | 1999-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | CBS
 | 1999-06-07 00:00:00 |  | 2007-03-16 00:00:00 |  |  |  |  |  |  |  |  | DP
 | 1999-06-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | ER
 | 1999-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | HB
 | 2000-02-28 00:00:00 |  | 2009-12-03 00:00:00 |  |  |  |  |  |  |  |  | PPH
 | 2000-04-10 00:00:00 |  | 2007-12-21 00:00:00 |  |  |  |  |  |  |  |  | RCL
 | 2000-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | RSL
 | 2000-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | TS
 | 2000-10-16 00:00:00
 | 2001-01-08 00:00:00 |  | 2007-09-21 00:00:00
 | 2001-01-08 00:00:00
 | 2001-06-21 00:00:00
 | 2001-08-01 00:00:00
 | 2001-10-16 00:00:00
 | 2003-05-06 00:00:00 |  | 2007-02-01 00:00:00
 | 2003-06-01 00:00:00 |  | 2007-12-31 00:00:00
 | 2003-06-16 00:00:00
 | 2003-09-01 00:00:00
 | 2003-09-29 00:00:00
 | 2003-10-27 00:00:00 |  | 2007-11-07 00:00:00
 | 2004-01-14 00:00:00
 | 2004-01-19 00:00:00
 | 2004-01-20 00:00:00
 | 2004-01-20 00:00:00 |  | 2008-01-25 00:00:00
 | 2004-01-20 00:00:00 |  | 2008-03-28 00:00:00
 | 2004-04-26 00:00:00
 | 2004-05-18 00:00:00
 | 2004-06-21 00:00:00
 | 2004-07-19 00:00:00
 | 2004-08-05 00:00:00
 | 2004-10-04 00:00:00
 | 2004-10-18 00:00:00
 | 2004-12-03 00:00:00 |  | 2009-03-26 00:00:00
 | 2005-01-24 00:00:00 |  | 2008-03-14 00:00:00
 | 2005-02-28 00:00:00
 | 2005-04-04 00:00:00 |  | 2007-07-27 00:00:00
 | 2005-05-09 00:00:00 |  | 2007-12-21 00:00:00
 | 2005-06-27 00:00:00
 | 2005-08-15 00:00:00
 | 2005-08-22 00:00:00 |  | 2007-04-18 00:00:00
 | 2005-09-01 00:00:00
 | 2005-09-19 00:00:00 |  | 2008-06-04 00:00:00
 | 2005-09-19 00:00:00 |  | 2007-08-10 00:00:00
 | 2005-12-12 00:00:00 |  | 2008-01-11 00:00:00
 | 2006-01-09 00:00:00
 | 2006-01-16 00:00:00
 | 2006-01-18 00:00:00 |  | 2010-02-03 00:00:00
 | 2006-01-18 00:00:00 |  | 2008-02-08 00:00:00
 | 2006-03-22 00:00:00 |  | 2007-02-13 00:00:00
 | 2006-05-02 00:00:00 |  | 2008-03-21 00:00:00
 | 2006-05-02 00:00:00
 | 2006-05-02 00:00:00 |  | 2008-04-21 00:00:00
 | 2006-05-02 00:00:00
 | 2006-05-02 00:00:00
 | 2006-05-02 00:00:00
 | 2006-05-05 00:00:00 |  | 2007-08-31 00:00:00
 | 2006-05-22 00:00:00
 | 2006-05-29 00:00:00 |  | 2007-06-12 00:00:00
 | 2006-06-26 00:00:00 |  | 2007-08-27 00:00:00
 | 2006-06-26 00:00:00 |  | 2007-11-09 00:00:00
 | 2006-06-28 00:00:00 |  | 2007-12-21 00:00:00
 | 2006-07-10 00:00:00
 | 2006-08-03 00:00:00
 | 2006-08-21 00:00:00 |  | 2008-07-10 00:00:00
 | 2006-08-21 00:00:00 |  | 2008-07-18 00:00:00
 | 2006-09-04 00:00:00 |  | 2008-01-11 00:00:00
 | 2006-09-25 00:00:00 |  | 2008-12-17 00:00:00
 | 2006-09-27 00:00:00 |  | 2007-03-30 00:00:00
 | 2006-10-03 00:00:00 |  | 2007-04-06 00:00:00
 | 2006-10-09 00:00:00
 | 2006-10-16 00:00:00
 | 2006-10-23 00:00:00
 | 2006-10-23 00:00:00 |  | 2007-02-23 00:00:00
 | 2006-10-30 00:00:00
 | 2006-11-20 00:00:00 |  | 2008-07-04 00:00:00
 | 2006-12-01 00:00:00 |  | 2007-05-08 00:00:00
 | 2006-12-04 00:00:00
 | 2007-01-15 00:00:00
 | 2007-01-15 00:00:00 |  | 2007-07-20 00:00:00
 | 2007-01-15 00:00:00 |  | 2009-10-30 00:00:00
 | 2007-01-15 00:00:00 |  | 2009-05-01 00:00:00
 | 2007-01-16 00:00:00
 | 2007-01-16 00:00:00 |  | 2008-09-19 00:00:00
 | 2007-01-16 00:00:00 |  | 2007-08-03 00:00:00
 | 2007-01-29 00:00:00 |  | 2007-06-08 00:00:00
 | 2007-01-29 00:00:00 |  | 2008-03-14 00:00:00
 | 2007-01-30 00:00:00 |  | 2007-06-06 00:00:00
 | 2007-02-05 00:00:00 |  | 2007-03-30 00:00:00
 | 2007-02-12 00:00:00 |  | 2007-08-21 00:00:00
 | 2007-02-19 00:00:00 |  | 2008-03-28 00:00:00
 | 2007-02-26 00:00:00 |  | 2007-05-11 00:00:00
 | 2007-02-26 00:00:00
 | 2007-02-26 00:00:00
 | 2007-03-05 00:00:00 |  | 2007-03-13 00:00:00
 | 2007-03-05 00:00:00 |  | 2007-05-04 00:00:00
 | 2007-03-12 00:00:00
 | 2007-03-12 00:00:00 |  | 2007-04-19 00:00:00
 | 2007-03-19 00:00:00 |  | 2007-08-31 00:00:00
 | 2007-03-20 00:00:00
 | 2007-03-22 00:00:00
 | 2007-03-26 00:00:00 |  | 2009-03-13 00:00:00
 | 2007-03-26 00:00:00
 | 2007-03-26 00:00:00 |  | 2008-06-05 00:00:00
 | 2007-04-02 00:00:00 |  | 2007-04-20 00:00:00
 | 2007-04-09 00:00:00
 | 2007-04-09 00:00:00 |  | 2008-11-04 00:00:00
 | 2007-04-10 00:00:00 |  | 2007-05-11 00:00:00
 | 2007-04-16 00:00:00 |  | 2007-05-10 00:00:00
 | 2007-04-23 00:00:00 |  | 2010-01-29 00:00:00
 | 2007-04-24 00:00:00 |  | 2007-11-10 00:00:00
 | 2007-04-30 00:00:00 |  | 2009-07-15 00:00:00
 | 2007-04-30 00:00:00 |  | 2007-07-20 00:00:00
 | 2007-04-30 00:00:00
 | 2007-05-01 00:00:00 |  | 2007-11-16 00:00:00
 | 2007-05-08 00:00:00 |  | 2007-07-20 00:00:00
 | 2007-05-14 00:00:00
 | 2007-05-14 00:00:00 |  | 2008-06-26 00:00:00
 | 2007-05-21 00:00:00 |  | 2008-11-21 00:00:00
 | 2007-05-28 00:00:00 |  | 2008-01-11 00:00:00
 | 2007-07-02 00:00:00
 | 2007-07-17 00:00:00 |  | 2008-05-26 00:00:00
 | 2007-07-19 00:00:00
 | 2007-08-06 00:00:00 |  | 2007-10-26 00:00:00
 | 2007-08-06 00:00:00 |  | 2008-11-14 00:00:00
 | 2007-08-17 00:00:00 |  | 2008-06-20 00:00:00
 | 2007-08-24 00:00:00 |  | 2007-10-19 00:00:00
 | 2007-08-27 00:00:00 |  | 2008-05-09 00:00:00
 | 2007-09-05 00:00:00
 | 2007-09-05 00:00:00 |  | 2008-01-25 00:00:00
 | 2007-09-10 00:00:00
 | 2007-09-11 00:00:00 |  | 2009-06-15 00:00:00
 | 2007-09-12 00:00:00 |  | 2008-09-19 00:00:00
 | 2007-09-29 00:00:00 |  | 2009-07-17 00:00:00
 | 2007-10-01 00:00:00 |  | 2010-01-22 00:00:00
 | 2007-10-01 00:00:00 |  | 2008-08-22 00:00:00
 | 2007-10-08 00:00:00 |  | 2007-12-14 00:00:00
 | 2007-10-12 00:00:00 |  | 2009-07-17 00:00:00
 | 2007-10-15 00:00:00 |  | 2007-11-29 00:00:00
 | 2007-10-15 00:00:00 |  | 2007-11-29 00:00:00
 | 2007-10-16 00:00:00 |  | 2007-11-09 00:00:00
 | 2007-10-22 00:00:00 |  | 2007-12-21 00:00:00
 | 2007-11-05 00:00:00 |  | 2007-11-05 00:00:00
 | 2007-11-26 00:00:00 |  | 2008-01-15 00:00:00
 | 2007-11-26 00:00:00 |  | 2007-12-14 00:00:00
 | 2008-01-07 00:00:00
 | 2008-01-08 00:00:00
 | 2008-01-08 00:00:00 |  | 2008-09-19 00:00:00
 | 2008-01-21 00:00:00
 | 2008-02-12 00:00:00 |  | 2008-02-28 00:00:00
 | 2008-02-28 00:00:00 |  | 2008-05-02 00:00:00
 | 2008-03-05 00:00:00 |  | 2008-05-09 00:00:00
 | 2008-03-12 00:00:00 |  | 2008-04-25 00:00:00
 | 2008-03-18 00:00:00 |  | 2008-04-11 00:00:00
 | 2008-03-24 00:00:00 |  | 2008-08-29 00:00:00
 | 2008-03-25 00:00:00
 | 2008-04-02 00:00:00
 | 2008-04-02 00:00:00 |  | 2008-07-04 00:00:00
 | 2008-04-07 00:00:00 |  | 2008-08-20 00:00:00
 | 2008-04-21 00:00:00
 | 2008-04-21 00:00:00 |  | 2009-10-02 00:00:00
 | 2008-04-28 00:00:00
 | 2008-05-05 00:00:00 |  | 2008-06-06 00:00:00
 | 2008-05-13 00:00:00 |  | 2008-05-20 00:00:00
 | 2008-05-17 00:00:00 |  | 2008-11-19 00:00:00
 | 2008-05-19 00:00:00 |  | 2009-07-03 00:00:00
 | 2008-05-19 00:00:00
 | 2008-06-09 00:00:00
 | 2008-06-30 00:00:00 |  | 2009-07-03 00:00:00
 | 2008-07-21 00:00:00 |  | 2009-07-03 00:00:00
 | 2008-07-28 00:00:00
 | 2008-08-09 00:00:00 |  | 2008-09-12 00:00:00
 | 2008-09-15 00:00:00 |  | 2008-09-19 00:00:00
 | 2008-09-15 00:00:00 |  | 2008-09-19 00:00:00
 | 2008-09-15 00:00:00 |  | 2009-02-01 00:00:00
 | 2008-09-22 00:00:00 |  | 2008-11-28 00:00:00
 | 2008-11-17 00:00:00 |  | 2009-05-15 00:00:00
 | 2009-03-02 00:00:00
 | 2009-03-02 00:00:00 |  | 2009-03-20 00:00:00
 | 2009-04-06 00:00:00 |  | 2009-05-19 00:00:00
 | 2009-04-20 00:00:00 |  | 2009-07-25 00:00:00
 | 2009-04-30 00:00:00 |  | 2009-07-03 00:00:00
 | 2009-05-13 00:00:00 |  | 2009-08-06 00:00:00
 | 2009-05-25 00:00:00 |  | 2009-08-28 00:00:00
 | 2009-06-01 00:00:00
 | 2009-08-24 00:00:00 |  | 2010-01-11 00:00:00
 | 2009-12-14 00:00:00
 | 2009-12-22 00:00:00
 | 2010-02-02 00:00:00 |  | 2010-03-26 00:00:00
 | 2010-03-24 00:00:00