Spreadsheet: 198041d1354642101-chart-needs-to-auto-populate-items-from-master-referance-chart-based-on-job-description-training
Sheet: Empl.specific training achieved

Name | Supervision | Role | Status | First Aid | Fall Pro | Procedural       Fall Pro | Safety Orient | WHMIS | Trailers | Ladder Loader | Fork Lift | [NAME] | Front End Loader | Principles | Leadership | Driver's License Class | Drivers License Expiry | Drivers Abstract | Other | Load Securement | Railings | Column1
[NAME] | Travis | Est. |  | N | 2015-04-01 00:00:00 | Y | Y | Y
[NAME] |  | Driver |  | 2013-06-01 00:00:00 | 2015-10-01 00:00:00 | Y | Y | Y | Y |  |  |  |  |  |  | 5 | 2013-12-01 00:00:00 |  |  | Get cert
[NAME] |  | Roof |  | N | 2015-09-01 00:00:00 | Y | Y | Y
[NAME] | Travis | Est. |  | N | 2015-10-01 00:00:00 | Y | Y | Y
[NAME] | Travis | Est. |  | N | 2015-04-01 00:00:00 | Y | Y | Y
Anomi Desrosiers | Donavan | [NAME] |  | 2015-03-01 00:00:00 | 2014-10-01 00:00:00 |  |  | Y
[NAME] |  |  |  |  |  |  |  | Y
Branden [NAME] | Travis | Est. |  | 2012-04-01 00:00:00 | 2015-04-01 00:00:00 | Y | Y | Y
[NAME] | [NAME] | Eaves |  | 2015-03-01 00:00:00 | 2015-05-01 00:00:00 | Y | Y | Y |  |  |  | Y
Brett Poppelwell | [NAME] | [NAME] |  |  | N | N | Y | Y |  |  | Y |  |  |  |  | 1 | 2013-11-01 00:00:00 |  | Lift truck TtT
[NAME] | Dwight | Sales |  |  |  |  |  | Y
[NAME] | [NAME] | Business |  | N | N | N |  | Y
Chinwendu Nwachi | Ian | Coord | Mat leave | N | N | N |  |  |  |  |  |  |  |  |  |  |  |  | (No Docs) [NAME], N 95Mask
[NAME] |  | Yard |  | N | 2015-10-01 00:00:00 | Y | Y | Y |  |  |  |  | Y |  |  |  |  |  | Mask Fit, SCBA
[NAME] | [NAME] | Est. |  | 2013-05-01 00:00:00 | 2014-12-01 00:00:00 | Y | Y | Y |  |  |  |  |  | Y | Y | 3Q | 2013-09-01 00:00:00 | Y | [NAME], Scaffolding Awareness, Construction Safety Administration, Basic Instructional Techniques
Colin Mullet |  |  |  |  |  |  |  | Y
[NAME] | Travis | Est. |  | N | 2015-04-01 00:00:00 | Y | Y | Y
[NAME] | Lance | Service |  |  | 2015-06-01 00:00:00 | Y | Y | Y
[NAME] |  | Ext |  | N | 2015-05-01 00:00:00 | Y | Y | Y |  |  |  | Y |  |  |  |  |  |  | Aerial TtT (Expires Nov 1, 2014)
[NAME] | Donavan | Service |  | 2015-03-01 00:00:00 | 2015-05-01 00:00:00 | Y | Y | Y
[NAME] | Ian | Ext |  | 2013-12-01 00:00:00 | 2015-05-01 00:00:00 | Y | Y | Y |  |  |  | Y
[NAME] |  | [NAME] |  | 2015-10-01 00:00:00 | Y | Y | Y | Y |  |  | Sort of | Y
[NAME] | Lance | Proj Man |  |  | 2015-06-01 00:00:00 | Y |  | Y
[NAME] | Donavan | Coord |  | N | N | N | Y | Y
Duane Poore |  |  |  | 2015-09-01 00:00:00 | 2015-08-01 00:00:00 | Y | Y | Y | theory
[NAME] | Donavan |  |  |  |  |  |  | Y
[NAME] | Merlin | Sales |  | N | N | N | Y | Y
[NAME] |  | Hot Shot |  | N | 2015-02-01 00:00:00 |  | Y | Y |  |  |  |  |  |  |  | 5 | 2014-08-01 00:00:00 |  |  | Y
[NAME] | Lance | Proj Man |  | 2013-06-01 00:00:00 | 2015-01-01 00:00:00 |  | Y | Y |  |  |  |  |  |  |  | 5 | 2016-08-01 00:00:00
[NAME] | [NAME] | Driver |  | N | N | N | Y | Y |  |  |  |  |  |  |  | 5Q | 2013-02-01 00:00:00
[NAME] | Brett | Mechanic |  | 2015-09-01 00:00:00 |  |  | Y | Y |  |  |  |  |  |  |  |  |  |  | Journeyman mechanic
[NAME] | Lance | Proj Man |  | 2015-03-01 00:00:00 | 2015-05-01 00:00:00 | Y | Y | Y
[NAME] |  | Roof |  | N | 2015-02-01 00:00:00 |  | Y | Y
[NAME] |  | Facility |  | N | N | N |  | Y
[NAME] |  | Manager |  | 2012-04-01 00:00:00 | 2015-06-01 00:00:00 | Y | Y |  |  |  | Y | Y
[NAME] | Ian | Qual |  | N | 2015-02-01 00:00:00 |  | Y | Y |  |  |  | Y
[NAME] | Travis | Sales |  | N | N | N |  | Y
[NAME] |  | Driver |  | N | N | N | Y | y | N | N | N |  |  |  |  | 1 | 2014-11-01 00:00:00
[NAME] | [NAME] | Roof |  | 2015-03-01 00:00:00 | 2015-05-01 00:00:00 | Y | Y | Y
[NAME] |  | Ext |  | N | 2015-05-01 00:00:00 | Y | Y | Y |  |  |  | Y
[NAME] |  |  |  | 2014-11-01 00:00:00 | 2015-09-01 00:00:00 | Y | Y | Y |  |  |  |  |  |  |  |  |  |  | Light duty vehicle, Mobile equipment guiding, [NAME] self-propelled elevating platform (scissor lift), TDG, FLRA HA.
[NAME] | Brennon | Ext |  | 2015-03-01 00:00:00 | 2015-05-01 00:00:00 |  | Y | Y
[NAME] | Brennon | Ext |  | 2015-03-01 00:00:00 | 2013-08-01 00:00:00 | Y | Y | Y
[NAME] | Lance | [NAME] |  | 2012-09-01 00:00:00 | N | N |  | Y |  |  |  |  |  |  |  | 5 | 2013-03-01 00:00:00
[NAME] |  | Facility |  | N | N | N |  | Y
[NAME] | Dwight | Sales |  | N | N | N | Y | Y
[NAME] | Todd | Business |  | 2015-05-01 00:00:00 | N | N | Y | Y
Kyler Toth | [NAME] | Service |  | 2015-03-01 00:00:00 | 2015-06-01 00:00:00 | Y | Y | Y |  |  |  |  |  |  |  |  |  |  | Flat Roof Safety (No Doc), [NAME] T-02,03,04,05,06) PAQ+S
[NAME] | Travis | Scoper |  | 2012-09-01 00:00:00 | 2015-05-01 00:00:00 | Y | Y | Y
Lance Merrifield | [NAME] | Manager |  | Y | 2015-05-01 00:00:00 | Y | Y | Y
0 | Travis | Est. |  | N | 2015-04-01 00:00:00 | Y | Y | Y
[NAME] | Brett | [NAME] |  | 2013-08-01 00:00:00 | N | N | Y | Y |  |  |  |  |  |  |  | 3Q | 2011-09-01 00:00:00 |  | welding
[NAME] |  | Business |  | N | N | N |  | Y
[NAME] |  | Roof |  | N | 2015-01-01 00:00:00 |  | Y | Y
Mariya Glubrecht | Dwight | Sales | temp gone |  | N | N | Y
[NAME] | [NAME] | [NAME] |  | 2015-03-01 00:00:00 | 2015-02-01 00:00:00 | Y | Y | Y |  |  |  |  | Expired |  |  |  |  |  | CSTS, Boat, H2S, Heavy Loader (expired)
[NAME] | Travis | Est. | temp gone | N | 2015-10-01 00:00:00 | Y | Y
[NAME] | Dwight | [NAME] |  | N | N | N |  | Y
[NAME] | Brennon | Ext |  | 2015-03-01 00:00:00 | 2015-11-01 00:00:00 | Y | Y | Y
[NAME] |  | Pres |  | 2012-04-01 00:00:00 | 2015-04-01 00:00:00 | Y | Y | Y
[NAME] | [NAME] | Service |  |  | 2013-08-01 00:00:00 |  | Y | Y |  |  |  |  |  |  |  |  |  |  | Safety 2000 (expired)
[NAME] | Donavan | [NAME] |  | Not documented | 2015-10-01 00:00:00 | Y | Y | Y
[NAME]  Kinnear | Merlin/Nathan | Accounting |  | 2015-03-01 00:00:00 | N | N |  | Y
[NAME] | Merlin | Business |  |  | N | N | Y | Y
Navin Dahal |  | Roof |  | 2015-03-01 00:00:00 | 2015-01-01 00:00:00 |  | Y | Y
[NAME] |  | Coord |  | N | N | N | Y | Y
[NAME] |  | Roof |  | N | 2014-12-01 00:00:00 |  |  | Y
[NAME] | Donavan | Qual |  | 2015-03-01 00:00:00 | 2015-03-01 00:00:00 |  |  | Y |  |  | Y | Y |  | Y | Y |  |  |  | [NAME], [NAME]
[NAME] Diaz |  | [NAME] |  | N | 2015-09-01 00:00:00 | Y | Y | Y
[NAME] | Travis | Est. |  | N | 2015-04-01 00:00:00 | Y |  | Y
[NAME] |  | Service |  |  | 2015-07-01 00:00:00 | Y | Y | Y | Y |  |  | Y |  |  |  | 5 | 2016-07-01 00:00:00 |  |  | Y
[NAME] | Dwight | [NAME] |  | N | N | N | Y | Y
[NAME] | [NAME] | Business |  | N | N | N |  | Y
[NAME] | Dwight | Sales |  | N | N | N |  | Y
[NAME] |  | Business |  | N | N | N |  | Y
[NAME] |  |  |  |  |  |  |  | Y
[NAME] | Nathan | IT |  | N | 2015-04-01 00:00:00 | Y | Y | Y
Teresa Mammel | [NAME] | Business |  | N | N | N | Y | Y
[NAME] | Merlin | HR |  | 2014-05-01 00:00:00 | N | N | Y | Y |  |  |  |  |  | Y
[NAME] |  |  |  | N | 2015-05-01 00:00:00 | Y | Y | Y
[NAME] |  | Hot Shot |  | 2013-04-01 00:00:00 | 2015-10-01 00:00:00 | Y | Y | Y | Y |  |  |  |  |  |  | 5 | 2013-01-01 00:00:00 | Y | CSTS, H2S Alive | Y
[NAME] |  | Est. |  | 2012-04-01 00:00:00 | 2015-04-01 00:00:00 | Y | Y | Y
Trevor [NAME] |  | Roof |  | N | Y |  | Y | Y
[NAME] | [NAME] | Est. |  | N | N | N |  | Y | Y | Y | Y
[NAME] |  | Driver |  | 2012-04-01 00:00:00 | 2015-04-01 00:00:00 | Y |  | Y
[NAME] |  | Roof |  | N | 2013-07-01 00:00:00 |  | Y | Y
Name | Supervision | Role | Column2 | First Aid | Fall Pro | Procedural       Fall Pro | Safety Orient | WHMIS | Trailers | Ladder Loader | Fork Lift | [NAME] | Front End Loader | Principles | Leadership | Driver's License Class | Drivers License Expiry | Drivers Abstract | Other | Load Securement | Railings | Column1
NO LONGER HERE
[NAME] | Dwight | Sales |  | N | N |  | Y | Y
[NAME] |  | [NAME] |  | 41852 | Y |  | Y
Osato (JR) [NAME] |  | Roof |  | 41699 | Y |  | Y | Y
[NAME] |  |  |  |  |  |  | Y | N/A
Amit Mahendru | [NAME] | Business |  | N | N | N |  | N/A
[NAME] | Travis |  |  | N | 42125 | Y |  | N/A
[NAME] | Dwight | Sales |  |  |  |  |  | N/A
[NAME] | Brett | Driver |  | N | N | N | Y | N/A |  |  |  |  |  |  |  | 3Q | 42186 | Y
[NAME] |  | Roof |  | 41913 | 42248 | Y | Y | N/A |  |  | 41944
[NAME] | Jim/Brett | Store/Yard |  | N | N |  | Y | N/A
[NAME] | Dwight | Sales |  | N | N | N |  | N/A
[NAME] |  | Yard |  |  | 42248 |  | Y | N/A |  |  |  |  |  |  |  |  |  |  | CSTS
[NAME] Judge | Travis | Scoper |  |  | 42125 | Y |  | N/A
[NAME] |  | Est. |  | N |  |  |  | N/A
[NAME] | Lance | Proj Man |  | 42064 | 41609 |  |  | Y |  |  | 41579 |  |  |  |  | 1 | 42614
[NAME] |  | Roof |  | N | 41974 |  | Y | N/A
Mitchell Toth |  | [NAME] |  |  | 42125 | Y | Y | N/A
[NAME] |  | Roof |  | N | 42036 |  | Y | N/A
[NAME] |  | Logistics |  |  |  |  | Y | N/A | Y
[NAME] |  | Roof |  | N | 42005 |  | Y | N/A
Reid Tansem |  | Yard |  | N | 42005 |  | Y | N/A
[NAME] |  | Roof |  | N | 42095 |  | Y | N/A
[NAME] | Brett | [NAME] |  | N | 41183 |  | Y | Y |  |  |  |  |  |  |  |  |  |  | Journeyman Mechanic, POST,Plumber, gasfitter
[NAME] | [NAME] | Coord |  | N | N | N |  | N/A
[NAME] |  | Eaves |  | 41365 | 42248 | Y | Y | Y