Spreadsheet: 70383d1271163145-calculating-average-duration-employee-turnover
Sheet: Employee data

Employee turnover |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993
 |  |  |  |  |  | Todays date: |  |  |  |  |  |  |  | average term |  |  | ? | ? | ? | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | # starters
 |  |  |  |  |  |  |  |  |  |  |  |  |  | # leavers
 |  |  |  |  |  |  |  |  |  |  | Stability | Stability |  | #total employees
P/R # | SURNAME | FIRST NAME | Company | Start date | Start year | Leaving date | Leaving year |  | Length of employment | Employed term | > 1 Year | >1 yr & current |  | % turnover
 | THOMSON | [NAME] | RCL | 1993-01-25 00:00:00
 | WATSON | [NAME] | RCL | 1994-01-10 00:00:00
 | WIGHT | GEORGE | RCL | 1996-09-02 00:00:00
 | WHITEHEAD | ALAN | RCL | 1997-03-31 00:00:00
 | CARNEY | PAUL | RCL | 1998-08-24 00:00:00
 | STEVENSON | GEORGE | RCL | 1998-09-02 00:00:00 |  | 2008-06-30 00:00:00
 | THOMSON | SHEILA | RCL | 1998-11-16 00:00:00
 | DOLAN | HARRY | RCL | 1998-12-14 00:00:00
 | BISHOP | GEORGE | RCL | 1999-01-18 00:00:00
 | PURVIS | [NAME] | RCL | 1999-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | CBS
 | MURPHY | PETER | RCL | 1999-06-07 00:00:00 |  | 2007-03-16 00:00:00 |  |  |  |  |  |  |  |  | DP
 | BAIN | CHRISTOPHER | RCL | 1999-06-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | ER
 | WATSON | GEORGE | RCL | 1999-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | HB
 | HASTIE | GORDON | RCL | 2000-02-28 00:00:00 |  | 2009-12-03 00:00:00 |  |  |  |  |  |  |  |  | PPH
 | BELL | [NAME] | RCL | 2000-04-10 00:00:00 |  | 2007-12-21 00:00:00 |  |  |  |  |  |  |  |  | RCL
 | WADDELL | GEORGE | RCL | 2000-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | RSL
 | MORAN | PAUL | RCL | 2000-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | TS
 | BEVERIDGE | [NAME] | RCL | 2000-10-16 00:00:00
 | HYSLOP | STEVEN | RCL | 2001-01-08 00:00:00 |  | 2007-09-21 00:00:00
 | DAVISON | WILLIAM | RCL | 2001-01-08 00:00:00
 | CHRISTIE | ANDREW | RCL | 2001-06-21 00:00:00
 | STARK | [NAME] | RCL | 2001-08-01 00:00:00
 | HAY | THOMAS | RCL | 2001-10-16 00:00:00
 | DOYLE | EDWARD | RCL | 2003-05-06 00:00:00 |  | 2007-02-01 00:00:00
 | McGILVRAY | DOUGLAS | RCL | 2003-06-01 00:00:00 |  | 2007-12-31 00:00:00
 | WILSON | [NAME] | RCL | 2003-06-16 00:00:00
 | RENNIE | LOUIS | RCL | 2003-09-01 00:00:00
 | ROBERTSON | IAN | RCL | 2003-09-29 00:00:00
 | MUNN Jnr | GORDON | RCL | 2003-10-27 00:00:00 |  | 2007-11-07 00:00:00
 | PRYDE | WILLIAM | RCL | 2004-01-14 00:00:00
 | GRIEVE | ALEXANDER | RCL | 2004-01-19 00:00:00
 | DEVANEY | [NAME] | RCL | 2004-01-20 00:00:00
 | THOMSON | NEIL | RCL | 2004-01-20 00:00:00 |  | 2008-01-25 00:00:00
 | ROBERTSON | SCOTT | RCL | 2004-01-20 00:00:00 |  | 2008-03-28 00:00:00
 | WILSON | FRASER | RCL | 2004-04-26 00:00:00
 | YOUNG | ALAN | RCL | 2004-05-18 00:00:00
 | INGLIS | [NAME] | RCL | 2004-06-21 00:00:00
 | SHEPHERD | NEIL | RCL | 2004-07-19 00:00:00
 | McKENZIE | DEREK | RCL | 2004-08-05 00:00:00
 | BURT | NEIL | RCL | 2004-10-04 00:00:00
 | ADAMS | GORDON | RCL | 2004-10-18 00:00:00
 | [NAME] | [NAME] | RCL | 2004-12-03 00:00:00 |  | 2009-03-26 00:00:00
 | ORMISTON | GARRY | RCL | 2005-01-24 00:00:00 |  | 2008-03-14 00:00:00
 | WILSON | [NAME] | RCL | 2005-02-28 00:00:00
 | GRANGE | GLENN | RCL | 2005-04-04 00:00:00 |  | 2007-07-27 00:00:00
 | DOWNEY | [NAME] | RCL | 2005-05-09 00:00:00 |  | 2007-12-21 00:00:00
 | GORDON | THOMAS | RCL | 2005-06-27 00:00:00
 | MURRAY | MICHELLE | RCL | 2005-08-15 00:00:00
 | WINSBOROUGH | PETER | RCL | 2005-08-22 00:00:00 |  | 2007-04-18 00:00:00
 | [NAME] | ANNE | RCL | 2005-09-01 00:00:00
 | STEIN | [NAME] | RCL | 2005-09-19 00:00:00 |  | 2008-06-04 00:00:00
 | [NAME] | RODGER | RCL | 2005-09-19 00:00:00 |  | 2007-08-10 00:00:00
 | CORNWALL | RICHARD | RCL | 2005-12-12 00:00:00 |  | 2008-01-11 00:00:00
 | SEMPLE | [NAME] | RCL | 2006-01-09 00:00:00
 | SKELLEY | [NAME] | RCL | 2006-01-16 00:00:00
 | BAJDALSKI | DAWID | RCL | 2006-01-18 00:00:00 |  | 2010-02-03 00:00:00
 | BOINSKI | MACIEJ | RCL | 2006-01-18 00:00:00 |  | 2008-02-08 00:00:00
 | TAYLOR | PETER | RCL | 2006-03-22 00:00:00 |  | 2007-02-13 00:00:00
 | DIGNAN | KENNETH | RCL | 2006-05-02 00:00:00 |  | 2008-03-21 00:00:00
 | McGAIR | [NAME] | RCL | 2006-05-02 00:00:00
 | MYLES | ALLAN | RCL | 2006-05-02 00:00:00 |  | 2008-04-21 00:00:00
 | THOMSON Snr | COLIN | RCL | 2006-05-02 00:00:00
 | THOMSON Jnr | COLIN | RCL | 2006-05-02 00:00:00
 | THOMSON | PETER | RCL | 2006-05-02 00:00:00
 | GREGORY | [NAME] | RCL | 2006-05-05 00:00:00 |  | 2007-08-31 00:00:00
 | CANNON | GARRY | RCL | 2006-05-22 00:00:00
 | THOMSON | [NAME] | RCL | 2006-05-29 00:00:00 |  | 2007-06-12 00:00:00
 | [NAME] | RYAN | RCL | 2006-06-26 00:00:00 |  | 2007-08-27 00:00:00
 | DRUMMOND | RICHARD | RCL | 2006-06-26 00:00:00 |  | 2007-11-09 00:00:00
 | KOSUNEN | VESA | RCL | 2006-06-28 00:00:00 |  | 2007-12-21 00:00:00
 | ROE | [NAME] | RCL | 2006-07-10 00:00:00
 | THACKEREY | SIMON | RCL | 2006-08-03 00:00:00
 | WYRABKIEWICZ | [NAME] | RCL | 2006-08-21 00:00:00 |  | 2008-07-10 00:00:00
 | PACZKOWSKI | PRZEMYSLAW | RCL | 2006-08-21 00:00:00 |  | 2008-07-18 00:00:00
 | LOVATT | STEPHEN | RCL | 2006-09-04 00:00:00 |  | 2008-01-11 00:00:00
 | BROCKIE | THOMAS | RCL | 2006-09-25 00:00:00 |  | 2008-12-17 00:00:00
 | McBRIDE | [NAME] | RCL | 2006-09-27 00:00:00 |  | 2007-03-30 00:00:00
 | [NAME] | [NAME] | RCL | 2006-10-03 00:00:00 |  | 2007-04-06 00:00:00
 | TARLING | [NAME] | RCL | 2006-10-09 00:00:00
 | MORGAN Jnr | DARREN | RCL | 2006-10-16 00:00:00
 | CONNELLY | [NAME] | RCL | 2006-10-23 00:00:00
 | SEARLE | WILLIAM | RCL | 2006-10-23 00:00:00 |  | 2007-02-23 00:00:00
 | [NAME] | [NAME] | RCL | 2006-10-30 00:00:00
 | BROWN | SCOTT | RCL | 2006-11-20 00:00:00 |  | 2008-07-04 00:00:00
 | BIESZK | THOMAS | RCL | 2006-12-01 00:00:00 |  | 2007-05-08 00:00:00
 | BURT | RORY | RCL | 2006-12-04 00:00:00
 | DENHOLM | THOMAS | RCL | 2007-01-15 00:00:00
 | McCABE | [NAME] | RCL | 2007-01-15 00:00:00 |  | 2007-07-20 00:00:00
 | MACKAY | CHRISTOPHER | RCL | 2007-01-15 00:00:00 |  | 2009-10-30 00:00:00
 | MICHALIK | TOMASZ | RCL | 2007-01-15 00:00:00 |  | 2009-05-01 00:00:00
 | SZATKOWKSI | LESZEK | RCL | 2007-01-16 00:00:00
 | DUDA | PIOTR | RCL | 2007-01-16 00:00:00 |  | 2008-09-19 00:00:00
 | DEJA | BRONISLAW | RCL | 2007-01-16 00:00:00 |  | 2007-08-03 00:00:00
 | MORRISON | ANDREW | RCL | 2007-01-29 00:00:00 |  | 2007-06-08 00:00:00
 | LINDSAY | [NAME] | RCL | 2007-01-29 00:00:00 |  | 2008-03-14 00:00:00
 | McMANAMON | [NAME] | RCL | 2007-01-30 00:00:00 |  | 2007-06-06 00:00:00
 | [NAME] | ANDREW | RCL | 2007-02-05 00:00:00 |  | 2007-03-30 00:00:00
 | CARRIE | [NAME] | RCL | 2007-02-12 00:00:00 |  | 2007-08-21 00:00:00
 | WYSE | [NAME] | RCL | 2007-02-19 00:00:00 |  | 2008-03-28 00:00:00
 | WILSON | STUART | RCL | 2007-02-26 00:00:00 |  | 2007-05-11 00:00:00
 | PERRIE | MARK | RCL | 2007-02-26 00:00:00
 | ALLAN | CHRIS | RCL | 2007-02-26 00:00:00
 | KEMP | RYAN | RCL | 2007-03-05 00:00:00 |  | 2007-03-13 00:00:00
 | KEMP | SEAN | RCL | 2007-03-05 00:00:00 |  | 2007-05-04 00:00:00
 | GRAY | WAYNE | RCL | 2007-03-12 00:00:00
 | BUCKLEY | [NAME] | RCL | 2007-03-12 00:00:00 |  | 2007-04-19 00:00:00
 | JONES | GARETH | RCL | 2007-03-19 00:00:00 |  | 2007-08-31 00:00:00
 | [NAME] | [NAME] | RCL | 2007-03-20 00:00:00
 | DAMASZK | RYSZARD | RCL | 2007-03-22 00:00:00
 | KOZLOWSKI | JAROSLAW | RCL | 2007-03-26 00:00:00 |  | 2009-03-13 00:00:00
 | WEJER | MIREK | RCL | 2007-03-26 00:00:00
 | SOBIESIAK | WIELSAW | RCL | 2007-03-26 00:00:00 |  | 2008-06-05 00:00:00
 | DOWNEY | [NAME] | RCL | 2007-04-02 00:00:00 |  | 2007-04-20 00:00:00
 | WILKIE | GRAHAM | RCL | 2007-04-09 00:00:00
 | CURRIE | THOMAS | RCL | 2007-04-09 00:00:00 |  | 2008-11-04 00:00:00
 | KEENAN | WILLIAM | RCL | 2007-04-10 00:00:00 |  | 2007-05-11 00:00:00
 | BROWN | WILLIAM | RCL | 2007-04-16 00:00:00 |  | 2007-05-10 00:00:00
 | CAMPOPIANO | GREG | RCL | 2007-04-23 00:00:00 |  | 2010-01-29 00:00:00
 | CURRIE | DANIEL | RCL | 2007-04-24 00:00:00 |  | 2007-11-10 00:00:00
 | O'HANLON | [NAME] | RCL | 2007-04-30 00:00:00 |  | 2009-07-15 00:00:00
 | DURKIN | SCOTT | RCL | 2007-04-30 00:00:00 |  | 2007-07-20 00:00:00
 | McNEILL | EDWARD | RCL | 2007-04-30 00:00:00
 | CRAIG | GEORGE | RCL | 2007-05-01 00:00:00 |  | 2007-11-16 00:00:00
 | DUNN | ANGUS | RCL | 2007-05-08 00:00:00 |  | 2007-07-20 00:00:00
 | SALMOND | DEAN | RCL | 2007-05-14 00:00:00
 | FORBES | CRAIG | RCL | 2007-05-14 00:00:00 |  | 2008-06-26 00:00:00
 | YOUNG | [NAME] | RCL | 2007-05-21 00:00:00 |  | 2008-11-21 00:00:00
 | SINCLAIR | GILLIAN | RCL | 2007-05-28 00:00:00 |  | 2008-01-11 00:00:00
 | HENDERSON | CRAIG | RCL | 2007-07-02 00:00:00
 | ZLOCM | WALDEMAR | RCL | 2007-07-17 00:00:00 |  | 2008-05-26 00:00:00
 | [NAME] | MAREK | RCL | 2007-07-19 00:00:00
 | WANDS | [NAME] | RCL | 2007-08-06 00:00:00 |  | 2007-10-26 00:00:00
 | McLEAN | KEVIN | RCL | 2007-08-06 00:00:00 |  | 2008-11-14 00:00:00
 | [NAME] | MARCIN | RCL | 2007-08-17 00:00:00 |  | 2008-06-20 00:00:00
 | WALL | [NAME] | RCL | 2007-08-24 00:00:00 |  | 2007-10-19 00:00:00
 | PATERSON | [NAME] | RCL | 2007-08-27 00:00:00 |  | 2008-05-09 00:00:00
 | DEPTULA | MARCIN | RCL | 2007-09-05 00:00:00
 | MLONKA | TOMASZ | RCL | 2007-09-05 00:00:00 |  | 2008-01-25 00:00:00
 | LENNOX | [NAME] | RCL | 2007-09-10 00:00:00
 | RICHARDSON | CRAIG | RCL | 2007-09-11 00:00:00 |  | 2009-06-15 00:00:00
 | DUDA | BARTOSZ | RCL | 2007-09-12 00:00:00 |  | 2008-09-19 00:00:00
 | CLARK | ROSS | RCL | 2007-09-29 00:00:00 |  | 2009-07-17 00:00:00
 | ARNOTT | CLARK | RCL | 2007-10-01 00:00:00 |  | 2010-01-22 00:00:00
 | [NAME] | GORDON | RCL | 2007-10-01 00:00:00 |  | 2008-08-22 00:00:00
 | IRONSIDE | [NAME] | RCL | 2007-10-08 00:00:00 |  | 2007-12-14 00:00:00
 | FERRY | NEIL | RCL | 2007-10-12 00:00:00 |  | 2009-07-17 00:00:00
 | MINTY | GLEN | RCL | 2007-10-15 00:00:00 |  | 2007-11-29 00:00:00
 | HOWDEN | [NAME] | RCL | 2007-10-15 00:00:00 |  | 2007-11-29 00:00:00
 | DRYBURGH | SHAUN | RCL | 2007-10-16 00:00:00 |  | 2007-11-09 00:00:00
 | PHILP | [NAME] | RCL | 2007-10-22 00:00:00 |  | 2007-12-21 00:00:00
 | LOVE | [NAME] | RCL | 2007-11-05 00:00:00 |  | 2007-11-05 00:00:00
 | CARRICK | ALAN | RCL | 2007-11-26 00:00:00 |  | 2008-01-15 00:00:00
 | TURNBULL | [NAME] | RCL | 2007-11-26 00:00:00 |  | 2007-12-14 00:00:00
 | JAFFRAY | LORNA | RCL | 2008-01-07 00:00:00
 | SZATKOWKSI | WOJCIECH | RCL | 2008-01-08 00:00:00
 | DUDA | MARIUSZ | RCL | 2008-01-08 00:00:00 |  | 2008-09-19 00:00:00
 | HYSLOP | STEVEN | RCL | 2008-01-21 00:00:00
 | CLINTON | [NAME] | RCL | 2008-02-12 00:00:00 |  | 2008-02-28 00:00:00
 | PENDER | PAUL | RCL | 2008-02-28 00:00:00 |  | 2008-05-02 00:00:00
 | GORDJI | ROSHEEN | RCL | 2008-03-05 00:00:00 |  | 2008-05-09 00:00:00
 | WEST | WILLIAM | RCL | 2008-03-12 00:00:00 |  | 2008-04-25 00:00:00
 | McPHEE | [NAME] | RCL | 2008-03-18 00:00:00 |  | 2008-04-11 00:00:00
 | SMITH | CHRISTOPHER | RCL | 2008-03-24 00:00:00 |  | 2008-08-29 00:00:00
 | CAMERON | [NAME] | RCL | 2008-03-25 00:00:00
 | MICHALIK | MARIUSZ | RCL | 2008-04-02 00:00:00
 | AFONSO | JAVIER | RCL | 2008-04-02 00:00:00 |  | 2008-07-04 00:00:00
 | MUNN Jnr | GORDON | RCL | 2008-04-07 00:00:00 |  | 2008-08-20 00:00:00
 | SCOTT | GRAHAM | RCL | 2008-04-21 00:00:00
 | HILL | GRAEME | RCL | 2008-04-21 00:00:00 |  | 2009-10-02 00:00:00
 | AITKEN | [NAME] | RCL | 2008-04-28 00:00:00
 | ALLAN | [NAME] | RCL | 2008-05-05 00:00:00 |  | 2008-06-06 00:00:00
 | [NAME] | INDERJEET | RCL | 2008-05-13 00:00:00 |  | 2008-05-20 00:00:00
 | McLAUCHLAN | [NAME] | RCL | 2008-05-17 00:00:00 |  | 2008-11-19 00:00:00
 | LIVINGSTONE | SCOTT | RCL | 2008-05-19 00:00:00 |  | 2009-07-03 00:00:00
 | DEMPSTER | HARRY | RCL | 2008-05-19 00:00:00
 | CROWE | JAY | RCL | 2008-06-09 00:00:00
 | SEMPLE | SCOTT | RCL | 2008-06-30 00:00:00 |  | 2009-07-03 00:00:00
 | [NAME] | WILLIAM | RCL | 2008-07-21 00:00:00 |  | 2009-07-03 00:00:00
 | FRENCH | ANDREW | RCL | 2008-07-28 00:00:00
 | MOON | [NAME] | RCL | 2008-08-09 00:00:00 |  | 2008-09-12 00:00:00
 | SCADE | [NAME] | RCL | 2008-09-15 00:00:00 |  | 2008-09-19 00:00:00
 | McGUINESS | ROSS | RCL | 2008-09-15 00:00:00 |  | 2008-09-19 00:00:00
 | [NAME] | RONNIE | RCL | 2008-09-15 00:00:00 |  | 2009-02-01 00:00:00
 | YOUNG | SIMON | RCL | 2008-09-22 00:00:00 |  | 2008-11-28 00:00:00
 | [NAME] | ALLAN | RCL | 2008-11-17 00:00:00 |  | 2009-05-15 00:00:00
 | KULIN | ANDRZEJ | RCL | 2009-03-02 00:00:00
 | MEJER | LESZEK | RCL | 2009-03-02 00:00:00 |  | 2009-03-20 00:00:00
 | WINSBOROUGH | ANDREW | RCL | 2009-04-06 00:00:00 |  | 2009-05-19 00:00:00
 | CAMERON | WILLIAM | RCL | 2009-04-20 00:00:00 |  | 2009-07-25 00:00:00
 | GRANT | CHRISTOPHER | RCL | 2009-04-30 00:00:00 |  | 2009-07-03 00:00:00
 | [NAME] | ALEXANDER | RCL | 2009-05-13 00:00:00 |  | 2009-08-06 00:00:00
 | BONNER | [NAME] | RCL | 2009-05-25 00:00:00 |  | 2009-08-28 00:00:00
 | COWAN | COLIN | RCL | 2009-06-01 00:00:00
 | DOWNEY | [NAME] | RCL | 2009-08-24 00:00:00 |  | 2010-01-11 00:00:00
 | MUIR | KEVIN | RCL | 2009-12-14 00:00:00
 | CROOKSTON | WILLIAM | RCL | 2009-12-22 00:00:00
 | SMITH | WILLIAM | RCL | 2010-02-02 00:00:00 |  | 2010-03-26 00:00:00
 | DOWNEY | [NAME] | RCL | 2010-03-24 00:00:00