Spreadsheet: 115297d1310953247-please-help-with-linking-data-from-one-table-to-another-copy_for_testing-chadoak-delivery-plan
Sheet: Trainees

 | Chadoak
 | Progress Report -
 | Certificate III   in Process Manufacturing |  |  |  |  |  |  |  | Cert III Level
 |  |  |  |  |  |  |  |  | June |  | 2011-07-11 00:00:00 | week1 | 2011-08-11 00:00:00 | week2 | 2011-09-11 00:00:00 | week3 | 2011-10-11 00:00:00 | week4 | 2011-11-11 00:00:00 | week5 | 2011-12-11 00:00:00 | week6 | 2011-01-11 00:00:00 | week6 | 2011-02-11 00:00:00 | week7 | 2011-03-11 00:00:00 | [NAME] | April | week9 | 2011-05-11 00:00:00 | week10
 | Trainer: Eddie Bowen & Bruce Poling |  |  |  |  |  |  |  | Induction & Enrolment |  | MSAPMSUP102A | Communicate in the workplace | TAADEL301A | Provide training through instruction and demonstration of skill | MSAPMOHS200A | Work Safely | MSAPMSUP101A | Clean workplace or  equipment | MSAPMSUP200A | Achieve work outcomes | MSAPMSUP390A | Use structured problem solving tools | MSAPMSUP390A | Use structured problem solving tools | MSACMT251A | Apply quality standards | PMBHAN103C | Shift materials safely by hand | MSACMS200A | Apply competitive manufacturing practices | MSAPMOPS100A | Use equipment | Revision and Post Training Activities
 |  |  |  |  |  |  |  |  |  |  | MSAPMSUP106A | Work in a team |  |  | [NAME] | Follow emergency procedures | MSACMT240A | Apply 5S procedures in a  manufacturing environment | MSAPMSUP210A | Process and record information | MSAPMSUP291A | Participate in continuous improvement | MSAPMSUP291A | Participate in continuous improvement | MSACMT230A | Apply cost factors to work practices | MSAPMSUP205A | Transfer loads | MSACMS201A | Sustain process improvements | MSAPMSUP303A | Identify equipment fault
 |  |  |  |  |  |  |  |  |  |  | MSAPMSUP106A | Manage conflict |  |  |  |  |  |  |  |  |  |  |  |  | MSAPMSUP100A | Apply workplace procedures
 | MEGT    Sign up | Name | Surname | Section/Area/Team |  | Job/Department | Cert III in Process Man. | Cert 4 Comp Man (Manufacturing) | Induction / Enrolment |  | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project) | Training | Assessment     (Project)
 |  | AARON | KUNST | EXCAVATOR OPERATOR |  | Pak |  |  |  | 28_6_11 | 14_7_11
 |  | ANDREW | GRIFFIN | EXCAVATOR OPERATOR |  | ?? |  |  |  | 28_6_11
 |  | BRAD | FOWLER | PLUMBER - unregistered |  | E.T.P
 |  | CHRISTOPHER | DENDLE | [NAME] |  | Maintenance
 |  | CRAIG | HEARN | PLUMBER |  | ??
 |  | Garrick | Beaurrain | Plumber |  | Sync
 |  | MATTHEW | BOOTH | PLUMBER |  | Maintenance
 |  | PHILIP | GILBERT | PLUMBER |  | Maintenance |  |  |  | 28_6_11
 |  | ROSS | [NAME] | EXCAVATOR OPERATOR |  | E.T.P |  |  |  | 29_6_11
 | Certificate IV in Competitive Manufacturing |  |  |  |  |  |  |  | Cert IV Level
 |  |  |  |  |  |  |  |  | 2011-06-11 00:00:00 |  | 2011-07-11 00:00:00 | week1 | 2011-08-11 00:00:00 | week2 | 2011-09-11 00:00:00 | week3 | 2011-10-11 00:00:00 | week4 | 2011-11-11 00:00:00 | week5 | 2011-12-11 00:00:00 | week6 | 2011-01-11 00:00:00 | week6 | 2011-02-11 00:00:00 | week7 | 2011-03-11 00:00:00 | [NAME] | 2011-04-11 00:00:00 | week9
 | Trainers: Eddie Bowen & Bruce Poling |  |  |  |  |  |  |  | Induction & Enrolment |  | MSACMC614A | Develop a communication strategy to support production | MSACMC612A | Manage workplace learning | MSACMT410A | Lead change in a manufacturing environment | MSACMT440A | Lead 5S  in a manufacturing environment | MSACMT451A | Mistake proof a production process | MSAPMSUP390A | Use structured problem solving tools | MSAPMSUP390A | Use structured problem solving tools | MSACMS401A | Ensure process improvements are sustained |  |  | Revision and Post Training Activities
 |  |  |  |  |  |  |  |  |  |  |  |  | BSBFLM511A | Develop a workplace learning environment | MSACMS413A | Lead team culture improvements |  |  |  |  | MSACMS600A | Develop a competitive manufacturing system | MSACMS600A | Develop a competitive manufacturing system
 | MEGT    Sign up | Name | Surname | Section/Area/Team |  | Job/Department | Diploma in Competitive Man. | Cert 4 Comp Man (Manufacturing) | Induction / Enrolment |  | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project)
 |  | ALEXANDER | BOOTH | APPRENTICE 2ND YEAR |  | Maintenance
 |  | [NAME] | CAPPADONA | APPRENTICE 1ST YEAR |  | Paky
 |  | BENJAMIN | SMITH | PLUMBER |  | Paky |  |  |  | 28_6_11 | 14_7_11
 |  | BRADLEY | PYERS | APPRENTICE PLUMBER-3rd YEAR |  | Warligh |  |  |  | 14_7_11
 |  | BRENT | GALLOW | PLUMBER |  | E.T.P |  |  |  | 29_6_11
 |  | [NAME] | Ainsworth | Plumber |  | VCA |  |  |  | 28_6_11
 |  | CHAD | ONSLOW | PLUMBER |  | Syncatron |  |  |  | 29_6_11
 |  | [NAME] | VALHER | PLUMBER |  | Paky
 |  | CRAIG | LEWIS | PLUMBER |  | E.T.P |  |  |  | 29_6_11
 |  | [NAME] | HIRT | APPRENTICE  4TH YEAR | dip | Cat |  |  |  | 28_6_11
 |  | [NAME] | [NAME] | APPRENTICCE 1ST YEAR |  | Lyric
 |  | Drew | RAWLINGS | APPRENTICE -3RD  YEAR |  | VCA |  |  |  | 28_6_11
 |  | EVAN | CORRELJE | PLUMBER |  | Maintenance
 |  | [NAME] | FROILAND | MECHANIC |  | Office |  |  |  | 23_6_11
 |  | GREG | MILES | SITE MANAGER |  | Maintenance
 |  | [NAME] | GRIFFIN | OPERATIONS DIRECTOR |  | Office
 |  | JARED | SHERRARD-SMITH | [NAME]  YR |  | School |  |  |  | 28_6_11
 |  | [NAME] | GARDINER | PLUMBER FOREMAN |  | Corby |  |  |  | 29_6_11
 |  | [NAME] | Hague | Office |  | Office
 |  | MARTIN | LAVIS | APPRENTICE PLUMBER-3rd YR |  | Corby
 |  | MATTHEW | BISHOP | APPRENITCE 1ST YEAR PLUMBER |  | Pak |  |  |  | 28_6_11 | 14_7_11
 |  | MITCHELL | CLYDESDALE | APPRENTICE 4TH YEAR |  | Maintenance |  |  |  |  | 14_7_11
 |  | PAUL | GRIFFIN | MANAGER |  | Office |  |  |  | 28_6_11
 |  | PAUL | JONES | APPRENTICE 1ST YEAR PLUMBER |  | Maintenance
 |  | [NAME] | GRIFFIN | MANAGING DIRECTOR |  | Office |  |  |  | 28_6_11
 |  | [NAME] | ROSS | ESTIMATOR |  | Office |  |  |  | 23_6_11
 |  | RILEY | McCRACKEN | APPRENTICE-2ND  YEAR |  | School |  |  |  | 28_6_11
 |  | Sean | Condon | Plumber |  | Maintenance
 |  | SHANE | GRIFFIN | APPRENTICE PLUMBER 1st YEAR |  | Maintenance
 |  | SHANNON | SMITH | ESTIMATOR |  | Office |  |  |  | 23_6_11
 |  | SHANNON | TAYLOR | CONTRACT ADMINISTRATOR |  | Office |  |  |  | 23_6_11
 |  | [NAME] | HUMPHREY | Apprentice 1ST Year Plumber |  | Paky |  |  |  | 29_6_11 | 14_7_11
 |  | [NAME] | CONDON | APPRENTICE-3RD YEAR |  | FDC
 |  | Wayne | [NAME] | Plumber |  | Maintenance
 |  | WILLIAM (BILL) | PHILIPPZIG | PLUMBER |  | Maintenance
 | Diploma of  Competitive Manufacturing |  |  |  |  |  |  |  | Diploma Level
 |  |  |  |  |  |  |  |  | 2011-06-11 00:00:00 |  | 2011-07-11 00:00:00 | week1 | 2011-08-11 00:00:00 | week2 | 2011-09-11 00:00:00 | week3 | 2011-10-11 00:00:00 | week4 | 2011-11-11 00:00:00 | week5 | 2011-12-11 00:00:00 | week6 | 2012-01-11 00:00:00 | week7 | 2012-02-11 00:00:00 | week7 | 2012-03-11 00:00:00 | [NAME] | 2012-04-11 00:00:00 | week9 | 2012-05-11 00:00:00 | week10 | 2012-06-11 00:00:00 | week11 |  | 2012-07-11 00:00:00
 | Trainers: Eddie Bowen & Bruce Poling |  |  |  |  |  |  |  | Induction & Enrolment |  | MSACMC614A | Develop a communication strategy to support production | MSACMC612A | Manage workplace learning | MSACMT410A | Lead change in a manufacturing environment | MSACMT640A | Manage a 5s system in a manufacturing environment | MSACMT451A | Mistake proof a production process | MSAPMSUP390A | Use structured problem solving tools | MSACMT430A | Improve cost factors in work practices | MSACMT430A | Improve cost factors in work practices | MSACMS200A | Apply competitive manufacturing practices | MSACMT441A | Facilitate continuous improvement in manufacturing | MSACMC611A | Manage People Relationships | MSACMT661A | Establish information collection requirements and processes |  | Revision and Post Training Activities
 |  |  |  |  |  |  |  |  |  |  |  |  | BSBFLM511A | Develop a workplace learning environment | MSACMS413A | Lead team culture improvements |  |  |  |  | MSACMS600A | Develop a competitive manufacturing system | AUM4003A | Interpret customer requirements | AUM4003A | Interpret customer requirements | MSACMT622A | Design a process layout | MSACMC613A | Facilitate  holistic culture improvement in a manufacturing enterprise | BSBMGT401A | Show leadership in the workplace | BSBCUS501B | Manage quality customer service
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MSACMS401A | Ensure process improvements are sustained
 | MEGT    Sign up | Name | Surname | Section/Area/Team |  | Job/Department | Diploma in Competitive Man. | Cert 4 Comp Man (Manufacturing) | Induction / Enrolment |  | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project) | Coaching | Assessment     (Project)
 |  | [NAME] | EWER | PLUMBER |  | MAB
 |  | [NAME] | HARPER | PLUMBER |  | Melb Uni |  |  |  | 29_6_11
 |  | [NAME] | HIRT | PLUMBER |  | MAB |  |  |  | 28_6_11
 |  | [NAME] | MAXWORTHY | PLUMBER |  | Paky |  |  |  | 28_6_11 | 14_7_11
 |  | BRENDON | OATES | PLUMBER |  | Paky |  |  |  | 28_6_11
 |  | [NAME] | Ainsworth | Plumber |  | VCA
 |  | BRIAN | BRANDENBURG | OFFICE AND ACCOUNTING MANAGER |  | Office |  |  |  | 28_6_11
 |  | CONNIE | MILONAS | BUSINESS ADMIN GRADE 3-20 YRS |  | Maintenance |  |  |  | 23_6_11
 |  | [NAME] | CANAIDER | DRAINER PLANT OPERATOR |  | E.T.P ??
 |  | DANIEL | GRIFFIN | PLUMBER |  | YCA |  |  |  | 28_6_11
 |  | DANIEL | HARPER | PLUMBER |  | E.T.P |  |  |  | 29_6_11
 |  | DANIEL | HUTCHINSON | PLUMBER-Unregistered |  | [NAME] |  |  |  | 28_6_11
 |  | [NAME] | GILBERT | PLUMBER |  | Cat
 |  | Dion | ? | Inventory Control |  | Factory
 |  | DOUGLAS | OATEN | PLUMBER |  | Lyric |  |  |  | 29_6_11
 |  | GLENN | MANKS | SUPERVISOR |  | A/L
 |  | [NAME] | LEWIS | PLUMBER - Supervisor |  | Maintenance
 |  | KURT | ROWE | PLUMBER |  | [NAME] |  |  |  | 29_6_11
 |  | MAREE | WOOD | BACKFLOW MANAGER |  | Office |  |  |  | 23_6_11
 |  | MONIQUE | KUREK | [NAME] Officer [NAME] |  | Office
 |  | Nero | Sattambiralalage | IT SUPPORT |  | Office |  |  |  | 23_6_11
 |  | NICHOLAS | O'BRIEN | PLUMBER |  | ?? |  |  |  | 28_6_11
 |  | PAUL | COGAN | PLUMBER & SITE SUPERVISIOR |  | Super |  |  |  | 28_6_11
 |  | [NAME] | DEKA | PLUMBER |  | Lyric |  |  |  | 29_6_11
 |  | Radika | Heenpellage | Accounting |  | Office |  |  |  | 23_6_11
 |  | RAY | WOOD | SUPERVISOR |  | Super |  |  |  | 28_6_11
 |  | [NAME] | Hamshere | Plumber |  | Maintenance
 |  | [NAME] | REID | PLUMBER |  | Warleigh |  |  |  | 28_6_11
 |  | TERRI | DUNN | BUSINESS ADMIN GRADE 5 |  | Office |  |  |  | 23_6_11
 |  | THOMAS | [NAME] | PLUMBER |  | Syncatron |  |  |  | 29_6_11
 |  | [NAME] | WATTS | PLUMBER |  | E.T.P |  |  |  | 29_6_11
 |  | [NAME] | Gissing | [NAME] |  | S/Leave
 |  | TRAVIS | THORGERSEN | DRAFTSMAN |  | Office |  |  |  | 23_6_11
 |  |  | -