Spreadsheet: 266518d1379640402-conditional-formatting-to-identify-expiration-dates-in-a-training-log-19-09-2013_excelforum_training-log-draft
Sheet: Matrix

Subject | Approximate Course Length (hours)1 | Repeat or [NAME] (years) | Office |  |  |  |  | Operations/Field |  |  |  |  |  |  |  |  |  |  |  |  | Shop / Warehouse
 |  |  | Management & Supervision (Office Mgs, Supervisors, PMs, PEs, etc.) | Safety Staff (Safety Managers and [NAME]) | Administrative Support | Functional Support (HR, Sales, Accounting, etc.) | Engineering, Estimating, Purchasing | Management & Field Managers (Project Mgrs, Superintendants, etc.) | Site Safety Staff (Safety Managers and [NAME]) | Foremen | Plumbers | Pipe Fitters | Sheet Metal Mechanics | PBS Technicians | Equipment Operators | Welders | Iron Workers | Laborers | 1st Year Apprentices | Shop - Metals | Shop - Plumbing | Shop - Piping | Shop - Sheetmetal | Shop - Industrial | Shop - Warehouse | Comments
General Safety Training2
Safety Orientation | 4 | 0 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
01 Medical Treatment | 0.25 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
02 RKMI Philosophy | 0.25 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
03 ISO 2000 | 0.5 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
04 Ladders | 0.5 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
05 Planning (Pre-Task cards) | 0.25 | 2 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
06 Fall Protection | 0.75 | 2 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
07 Scissor [NAME] | 0.5 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
08 HAZCOM | 0.5 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
09 Fire Safety | 0.5 | 3 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
Defensive Driving Course | 4 | 1 |  |  |  |  |  |  |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  | Required for employees meeting designated motor vehicle operator definition
First Aid/CPR Training | 8 | 1 | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
OSHA 10-hour Training | 10 |  |  |  |  |  |  |  | R |  | R | R | R |  | R | R | R | R | R | R | R | R | R | R | R
OSHA 30-hour Training | 30 |  | R | R |  |  |  | R | R | R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available via computer based safety training
Site-Specific Safety Training
RKMI Orientation (Induction) | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required by Project
Aerial Lift (Boom / JLG) | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required to use equipment
Airborne Lead Exposure | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If exposure is possible
Asbestos Awareness | 0.5 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If exposure is possible
Backhoe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required to use equipment
Confined Space Operations | 2 | 1 |  |  |  |  |  | R | R | R | R | R | R | R |  | R | R |  |  |  |  |  |  |  |  | Required for CS work
Construction Ergonomics | 2 | 1 |  |  |  |  |  | R | R | R | R | R | R | R | R | R | R | R
Electrical Safety (Arc Flash / Arc Blast) | 2 | 1 |  |  |  |  |  |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  |  | Required for electrical work
Fall Protection | 1 | 1 |  |  |  |  |  | R | R | R | R | R | R | R | R | R | R | R
Fire Protection / Fire Watch | 1 | 1 |  | R |  |  |  |  | R |  | R | R |  |  |  | R |  |  |  |  | R | R |  | R
Forklift Operator (Mast or Extend) | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  | Required to use equipment
Frontend Loader | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | R
Handtools | 0.5 | 1 |  |  |  |  |  |  |  | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
Hearing Conservation | varies | 1
Job Hazard Analysis
[NAME] | varies | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required by project
Ladders/Stairways | 1 | 1
Lead Awareness | 0.5 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If exposure is possible
Lock-out/Tag-out | 1 | 1 |  |  |  |  |  |  |  |  | R | R | R | R | R | R
Mini X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
Pipe Testing Procedures | 2 | 1 |  |  |  |  |  |  |  |  | R | R |  | R |  |  |  |  |  |  | R | R
Qualified Rigger | 12 | 3 |  |  |  |  |  |  |  | R | R | R | R | R | R | R | R
[NAME] | 4 | 3 |  |  |  |  |  |  |  |  | R | R | R | R | R | R | R
Respirator [NAME]. Evaluation | 0.5 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If exposure is possible
Respiratory Protection | 0.75 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If exposure is possible
[NAME] | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If [NAME] work is done
Skidsteer | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | R
Scissor Lift | 1 |  |  |  |  |  |  |  |  |  | R | R | R | R | R | R | R
Trenching and Excavation | 2 | 1 |  |  |  |  |  |  |  |  | R |  |  |  | R
Notes
R = Required training
For blank matrix boxes, determine training based on job assignment, scope of work, facility or site hazards, work experience of personnel, and local regulations.
1In order to achieve the training objectives, details of class content and duration should be determined by the instructor based on site & facility-specific hazards, scope of work, work experience of audience, etc.
2Basic requirements for HSE training by job function.
3This training is required, as appropriate for the specific job function and site exposure.  Site personnel must complete the same site-specific HSE training as that specified above for craft and supervisors.
4Mgmt. of Change tng. is usually provided by client.