Spreadsheet: 98403d1297311738-setting-expiry-date-with-conditional-formatting-records-for-data-input
Sheet: POLE INSP & ASSISTANTS

POLE INSPECTORS |  |  |  |  |  |  |  |  |  | Government
NAME | DESIGNATION | BUNDLED POLE | OPERATIONAL | FIRST AID | BLUE CARD | DRIVERS | SUBSTATION | TRAFFIC | PESTICIDE | PEST | WP CARD
 |  | INSPECTION | SAFETY INDUC. |  |  |  | ENTRY | MANAGEMENT |  | TECHNICIAN
[NAME] | Assistant Pole Inspector | 2011-01-21 00:00:00 | 2010-11-10 00:00:00 | Waiting Cert | 247929 | 2011-11-18 00:00:00 | NO |  | NO |  | Submitted 03/02/11
ANDREW O'HEHIR | Assistant Pole Inspector | 2011-01-21 00:00:00 | 2010-12-07 00:00:00 | Waiting Cert | 279444 | 2011-08-04 00:00:00 | NO |  | NO |  | Submitted 03/02/11
CAMERON SELLECK | Pole Inspector | 2010-08-06 00:00:00 | 2010-08-18 00:00:00 | Waiting Cert | 327463 | 2011-08-31 00:00:00 | 2013-01-25 00:00:00 |  | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Submitted 03/02/11
[NAME] | Assistant Pole Inspector | 2011-01-21 00:00:00 | 2009-11-13 00:00:00 | 12/03/2011 | 206758 | 2012-01-16 00:00:00 |  |  |  |  | Submitted 03/02/11
[NAME] | Assistant Pole Inspector | 2011-01-21 00:00:00 | 2010-12-07 00:00:00 | 31/12/2011 | 393739 | ID |  |  |  |  | Submitted 07/02/11
DANIEL FRYER | Pole Inspector | 2011-01-14 00:00:00 | 2010-11-10 00:00:00 | 30/11/2011 | 255184 | 2013-09-19 00:00:00 | 2013-01-25 00:00:00 |  | NO |  | Received - Sub sent 01/02
DARREN HOLDWAY | Pole Inspector | 2011-01-14 00:00:00 | 2010-11-10 00:00:00 | 30/11/2011 | 303954 | 2014-06-16 00:00:00 | 2013-01-25 00:00:00 |  | NO |  | Received - Sub sent 01/02
[NAME] | Pole Inspector | 2010-08-06 00:00:00 | 2010-08-25 00:00:00 | 2011-08-12 00:00:00 | 350386 | IRISH ONLY | 2013-01-25 00:00:00 |  | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Submitted 03/02/11
[NAME] | Assistant Pole Inspector | Course Awaiting date | 2011-01-17 00:00:00 | Waiting Cert | 400599 | 2011-07-30 00:00:00 | Course 17/02/2011 |  |  |  | Submitted 03/02/11
DYLAN NIKICH | Assistant Pole Inspector | 2011-01-21 00:00:00 | 2010-12-07 00:00:00 | 31/12/2011 | 403625 | ID |  |  |  |  | Submitted 07/02/11
GARTH PAUSIN | Pole Inspector | 2010-08-13 00:00:00 | 2010-08-25 00:00:00 | 2011-08-30 00:00:00 | 402630 | 16/06/2013 | 2013-01-25 00:00:00 |  | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Submitted 03/02/11
GEOFF SEEBECK | Pole Inspector | 2011-01-14 00:00:00 | 2010-11-10 00:00:00 | 2011-10-12 00:00:00 | 383897 | 2011-10-06 00:00:00 | 2013-01-25 00:00:00 |  | NO |  | Received - Sub sent 01/02
JACK WOODRUFF | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | YES | 2011-05-10 00:00:00 |  |  |  |  | Submitted 03/02/11
JAKE TATTERSALL | Assistant Pole Inspector | 2011-01-14 00:00:00 | 2010-11-10 00:00:00 | Waiting Cert | 388127 | 2012-10-12 00:00:00 | 2013-01-25 00:00:00 |  | NO |  | Submitted 03/02/11
[NAME] | Assistant Pole Inspector | 2011-01-14 00:00:00 | 2010-11-25 00:00:00 | 2011-11-12 00:00:00 | 201439 | 2011-11-17 00:00:00 | NO |  | NO |  | Received
JARRED USHER | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | Will Apply 13/01 | 2011-11-16 00:00:00 |  |  |  |  | To apply
JOEL COSTIN | Pole Inspector | 2010-06-18 00:00:00 | 2008-12-11 00:00:00 | Waiting Cert | 272416 | 2011-02-07 00:00:00 | 2011-07-07 00:00:00 |  | 2009-05-09 00:00:00 | 2011-06-30 00:00:00 | Received
JOEL LACKEY | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | 386149 | 2011-06-25 00:00:00 |  |  |  |  | Submitted 03/02/11
JUSTIN WILLETT | Pole Inspector | 2010-08-06 00:00:00 | 2010-08-18 00:00:00 | 2011-08-14 00:00:00 | 406180 | 2011-06-04 00:00:00 | 2013-01-25 00:00:00 |  | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Submitted 03/02/11
KIERAN LANGMEAD | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | 347827 | 2011-02-21 00:00:00 |  |  |  |  | Submitted 03/02/11
[NAME] | Pole Inspector | 2010-10-15 00:00:00 | 2010-09-03 00:00:00 | 2011-09-06 00:00:00 | 362037 | Revoked | 2013-01-25 00:00:00 |  | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Submitted 03/02/11
[NAME] | Pole Inspector | 2010-06-25 00:00:00 | 2010-01-22 00:00:00 | Waiting Cert | 300285 | 01/11/2013 SA ONLY | 21/06/2012 | 2013-06-30 00:00:00 | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Received
MARK PEEL | Assistant Pole Inspector | 2011-01-21 00:00:00 | 2010-12-07 00:00:00 | Waiting Cert | 395282 | 15/08/2015 |  |  |  |  | Submitted 03/02/11
MARK MARSHALL | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | To Submit | 2014-04-05 00:00:00 |  |  |  |  | To apply
MATTHEW EVANS | Pole Inspector | 2010-06-01 00:00:00 | 2008-12-11 00:00:00 | Waiting Cert | 227459 | 2013-05-07 00:00:00 | 28/06/2012 | 2013-06-30 00:00:00 | 2009-05-09 00:00:00 | 2011-06-30 00:00:00 | Received
MATTHEW MORRIS | Pole Inspector | 2010-06-18 00:00:00 | 2010-06-10 00:00:00 | Waiting Cert | 287453 | 2015-11-02 00:00:00 | 2012-06-21 00:00:00 | 2013-06-30 00:00:00 | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Received
[NAME] PRETORIUS | Assistant Pole Inspector |  | COURSE 18/02/2011
PAERANGI WILSON | Pole Inspector | 2010-06-18 00:00:00 | 2008-04-23 00:00:00 | Waiting Cert | 218259 | 20/06/2014 | 2011-07-07 00:00:00 | 2013-06-30 00:00:00 | 2009-08-09 00:00:00 | 2011-06-30 00:00:00 | Received
PHILLIP LEI | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | 2011-07-11 00:00:00 | 409128 | 2015-09-03 00:00:00 |  |  |  |  | Submitted 07/02/11
RIAN GADSDON | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | 2012-01-31 00:00:00 | 287851 | 2011-12-07 00:00:00 |  |  |  |  | Submitted 03/02/11
REECE MORVINSON | Assistant Pole Inspector | NO | 2009-10-02 00:00:00 | Waiting Cert | 322298 | NO | NO |  | NO |  | Received
ROWYN BARTLETT |  | Course Awaiting date | COURSE 18/02/2011 | Waiting Cert | 226634 | 2011-02-11 00:00:00 | Course 17/02/2011 |  | NO | NO | To apply
RYAN MIKKELSEN | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | 378764 | Test on  29/01/2011 |  |  |  |  | To apply
SHANE BROOKES | Pole Inspector | 2010-09-24 00:00:00 | 2010-09-30 00:00:00 | 2011-09-30 00:00:00 | 185816 | 2011-05-22 00:00:00 | 2013-01-25 00:00:00 |  | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | Submitted 03/02/11
SPENCER TATE |  |  | COURSE 18/02/2011 | Waiting Cert | 153807 | 2013-04-25 00:00:00 | 2011-07-07 00:00:00 |  |  |  | To apply
[NAME] | Assistant Pole Inspector | 2011-01-14 00:00:00 | 2010-11-10 00:00:00 | 2011-11-30 00:00:00 | 386466 | 2011-01-18 00:00:00 | NO |  | NO |  | Received
[NAME] | Assistant Pole Inspector |  | 2011-01-17 00:00:00 | Waiting Cert | 406438 | 2012-02-07 00:00:00 |  |  |  |  | Submitted 03/02/11
ANDOR VARGA | Pole Inspector | 2010-06-29 00:00:00 | COURSE 18/02/2011 | 2012-01-31 00:00:00 | 254688 | 2013-09-17 00:00:00 |  |  | 2009-05-09 00:00:00 |  | To apply
[NAME] | Pole Inspector | 2010-06-29 00:00:00 | 2008-04-23 00:00:00 | Waiting Cert | 211485 | 2014-06-01 00:00:00 | 2013-01-25 00:00:00 | PHOTO O/S | 2009-05-09 00:00:00 |  | To apply