Spreadsheet: 269749d1381265548-flip-rows-and-columns-and-conditional-formatting-please-help-tech-service-staff-training-completed-9-24-13
Sheet: TSC Completed Training Courses

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WBT COURSES
 |  | VRV |  |  |  |  | CONTROLS |  |  |  | Residential/Light Commercial |  |  |  | ALTHERMA |  | Basics |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | P-h Chart |  | Basic Work |  |  |  |  |  |  |  |  |  |  |  | Test Run |  |  | Troubleshooting |  |  |  |  |  |  |  |  |  |  | Installation |  |  |  |  |  |  |  |  | Product Knowledge |  |  |  |  |  |  | New Refrigerants |  | [NAME]
 |  | VRV Install & Commissioning | VRV Service & Troubleshooting | VRV Service Checker | VRV Product & Applications | Applications: Selection Tools | Controls Product & Applications | Controls Install & Commissioning | iTM | Controls Integrator | RLC Install & Start Up | RLC Install & Commissioning | RA Service & Troubleshooting | RLC Product & Applications | Altherma Product & Applications | Altherma Install & Commissioning | Introduction to Air Conditioning | Classification of Air Conditioning Systems | Principles of Refrigeration | 4 Components of Refrigeration Cycle & How it Works | 4 Components of Refrigeration Cycle & 4-way Valves | Basic Knowledge of Heat and Pressure | Standard Operation State | Impact of Various Changes on Operation State | Simple Heat Load Calculation | Model Selection of Air Conditioners | The Basic Knowledge of Analog Relays | Refrigerant Types and Nomenclature | Air-Cooled and Water-Cooled Air Conditioners | Primary Electrical Components of Air Conditioners | Primary Electronic Components of Air Conditioners | The Primary Components of the Refrigeration Cycle Other than the Four Principle Components | The Primary Safety Devices of the Refrigerant Cycle | The Basics of Ventilation: Ventilation Methods and Required Ventilation Volume | How to read [NAME] | Utilization: Mixture of Air | Utilization: Heating, Humidifying, Cooling, & Dehumidifying | Introduction to P-h Chart | P-h Chart and Coefficient of Performance | How to Use Testers and Clamp Meters | How to Use Megger Testers and Thermometers | How to Use Gauge Manifolds | Flaring Procedures | Procedures for Refrigerant Pipe Bending | Setting of Acetylene Welders | Flare Connection and Handling of the Service Ports & Stop Valves | [NAME] | Procedures for Additional Refrigerant Charge (Sky Air) | Pump Down Procedures | Procedures for Refrigerant Recovery | Air Tightness Test | Inspections Prior to Test Run | How to Run Test Run Data – Sky Air Edition | How to Run Test Run Data – VRV Edition | Wired Remote Controller: How to Use “Inspection” Mode | Wireless Remote Controller: How to Use “Inspection” Mode | Wired Remote Controller: How to Use the Service Mode | Wired Remote Controller: Malfunction Codes | Methods of Diagnosing Malfunction Codes: A3 and AF | Methods of Diagnosing Malfunction Codes: Malfunction Code: A0 (with related functions) | Methods of Diagnosing Malfunction Codes: E3 and JA | Methods of Diagnosing Malfunction Codes: E4 and JC | Methods of Diagnosing Malfunction Codes: E6 and J2 | Methods of Diagnosing Malfunction Codes: C4 | Malfunction Diagnosis using Outdoor PCB | Pre-Installation Checks | Installation Flow and Precautions | Examples of VRV Installation Problems (Indoor Units) | Key Points of VRV Refrigerant Piping Installation | Key Points of Drain Piping Installation (VRV and Sky Air) | Remote Control Wiring | Overview of VRV Control Wiring and Wiring Precautions | Indoor Unit Installation Points | Key Points for VRV Outdoor Unit Installation | Principles of Reluctance DC Motors | Principles of Inverter Control | Why are Inverter ACs Energy Efficient? | VRV System Features | Duct Design Procedures for the Ceiling Mounted Built-in Type | The Basics of Sound | Soundproofing Plans for AC Equipment | Flourocarbons and the Earth’s Environment | Properties of New Refrigerant & Key Points for Use | Customer Satisfaction for Service Engineer
Internal Support Call Center | [NAME] | 2013-02-26 00:00:00 | 2013-02-28 00:00:00 |  |  |  | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-06 00:00:00 |  |  |  | 2013-04-11 00:00:00 | 2013-04-09 00:00:00 |  |  |  |  |  |  | 2013-03-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-28 00:00:00 | 2013-03-28 00:00:00 |  | 2013-06-05 00:00:00 |  |  |  |  |  | 2013-04-27 00:00:00 |  | 2013-05-29 00:00:00 |  |  |  |  |  |  | 2013-03-27 00:00:00 |  | 2013-05-13 00:00:00
 | [NAME] | 2010-11-03 00:00:00 | 2010-11-05 00:00:00 |  |  |  |  |  | 2012-12-11 00:00:00 |  |  |  |  |  |  |  | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 | 2012-06-12 00:00:00 | 2012-05-31 00:00:00 | 2012-06-13 00:00:00 | 2012-06-07 00:00:00 | 2012-06-13 00:00:00 | 2012-06-13 00:00:00 | 2012-06-15 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-27 00:00:00 |  | 2012-07-04 00:00:00 | 2012-07-06 00:00:00 | 2012-07-07 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-28 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 2012-06-30 00:00:00
 | [NAME] | 2013-02-26 00:00:00 | 2013-02-28 00:00:00 | 2013-08-14 00:00:00 |  |  |  | 2013-08-28 00:00:00 | 2013-08-29 00:00:00 |  |  | 2013-04-10 00:00:00 | 2013-04-11 00:00:00 | 2013-04-09 00:00:00 |  |  | 2013-03-21 00:00:00 | 2013-03-21 00:00:00 | 2013-03-26 00:00:00 | 2013-03-20 00:00:00 | 2013-03-20 00:00:00 | 2013-03-20 00:00:00 | 2013-03-26 00:00:00 |  |  | 2013-04-08 00:00:00 |  |  |  | 2013-04-08 00:00:00 | 2013-04-08 00:00:00 |  |  | 2013-04-08 00:00:00 |  |  |  |  |  |  | 2013-04-01 00:00:00 | 2013-03-20 00:00:00 | 2013-04-01 00:00:00 | 2013-04-01 00:00:00 | N/A | N/A | N/A | 2013-04-03 00:00:00 | 2013-04-01 00:00:00 | N/A | 2013-04-01 00:00:00 | 2013-03-20 00:00:00 |  |  |  | 2013-03-21 00:00:00 | 2013-03-21 00:00:00 | 2013-04-04 00:00:00 | 2013-03-21 00:00:00 | 2013-03-21 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-22 00:00:00 | 2013-04-03 00:00:00 | 2013-03-25 00:00:00 | 2013-04-01 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-25 00:00:00 | 2013-03-25 00:00:00 | 2013-03-25 00:00:00 | 2013-03-25 00:00:00 | 2013-03-25 00:00:00 | 2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-04-01 00:00:00 |  | 2013-04-05 00:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-05 00:00:00 | 2013-09-04 00:00:00 | 2013-09-06 00:00:00 | 2013-08-28 00:00:00 | 2013-08-28 00:00:00 | 2013-09-04 00:00:00 | 2013-09-04 00:00:00 | 2013-09-05 00:00:00 | 2013-09-05 00:00:00 | 2013-08-29 00:00:00 | 2013-09-05 00:00:00 | 2013-09-10 00:00:00 | 2013-09-04 00:00:00 | 2013-09-04 00:00:00 |  | 2013-09-16 00:00:00 | 2013-09-10 00:00:00 | 2013-08-28 00:00:00 | 2013-09-04 00:00:00 | 2013-09-11 00:00:00 | 2013-09-16 00:00:00 | 2013-01-06 00:00:00 | 2013-09-16 00:00:00 | 2013-09-05 00:00:00 | 2013-09-11 00:00:00 | 2013-09-03 00:00:00 | 2013-09-03 00:00:00 | 2013-09-10 00:00:00 | 2013-09-10 00:00:00 | 2013-09-03 00:00:00 | 2013-08-30 00:00:00 | 2013-09-06 00:00:00 | 2013-09-06 00:00:00 | 2013-09-09 00:00:00 | 2013-09-06 00:00:00 | 2013-08-29 00:00:00 | 2013-09-09 00:00:00 | 2013-09-11 00:00:00 | 2013-08-28 00:00:00 | 2013-08-28 00:00:00 | 2013-09-09 00:00:00 | 2013-08-28 00:00:00 | 2013-09-09 00:00:00 | 2013-09-16 00:00:00 | 2013-09-10 00:00:00 | 2013-09-05 00:00:00 | 2013-09-05 00:00:00 | 2013-08-29 00:00:00 | 2013-09-04 00:00:00 | 2013-09-05 00:00:00 | 2013-09-16 00:00:00 | 2013-09-05 00:00:00 | 2013-09-05 00:00:00 | 2013-09-16 00:00:00 | 2013-09-10 00:00:00 | 2013-09-16 00:00:00 | 2013-09-10 00:00:00 | 2013-09-04 00:00:00 | 2013-09-09 00:00:00 | 2013-09-09 00:00:00 | 2013-09-09 00:00:00 | 2013-08-30 00:00:00 | 2013-09-05 00:00:00 | 2013-09-05 00:00:00 | 2013-09-05 00:00:00 | 2013-09-05 00:00:00 | 2013-09-04 00:00:00 | 2013-09-04 00:00:00
 | [NAME] | 2013-02-26 00:00:00 | 2013-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-20 00:00:00 | 2013-03-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-20 00:00:00 |  | 2013-03-21 00:00:00 |  |  | 2013-03-21 00:00:00 |  |  | 2013-03-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-03-21 00:00:00 | 2013-03-22 00:00:00 | 2013-03-22 00:00:00 | 2013-03-26 00:00:00 | 2013-03-26 00:00:00 | 2013-03-21 00:00:00
 | [NAME] |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00 |  |  |  |  | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 |  |  | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 |  |  |  |  |  |  |  | 2012-03-01 00:00:00 |  |  |  |  |  |  | 2012-03-01 00:00:00 | 2012-03-01 00:00:00
 | Ricardo Berrios | 2012-12-12 00:00:00 | 2012-12-14 00:00:00 |  |  |  | 2013-02-05 00:00:00 |  | 2013-02-06 00:00:00 |  |  | 2012-09-26 00:00:00 | 2012-09-27 00:00:00
 | Esteban Diaz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-06 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-08 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00
 | Crystal [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-11 00:00:00 |  | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-06 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-07 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00 | 2013-05-09 00:00:00
Field Service Managers | [NAME] | 2012-09-11 00:00:00 | 2012-08-16 00:00:00 | 2012-08-17 00:00:00 |  |  | 2012-08-21 00:00:00 | 2012-08-22 00:00:00 | 2013-01-01 00:00:00 | 2013-05-09 00:00:00 | 2012-11-01 00:00:00 | 2012-11-01 00:00:00 | 2012-11-01 00:00:00 | 2013-05-08 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 |  | 2013-05-08 00:00:00 |  | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 | 2013-05-07 00:00:00 |  |  |  |  |  |  | 2013-05-07 00:00:00 |  |  |  |  | 2013-05-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-07 00:00:00 |  |  | 2013-05-09 00:00:00
 | [NAME]
 | Marco Verdugo |  |  |  |  |  |  |  | 2013-02-06 00:00:00 |  |  |  |  |  |  |  | 2013-05-12 00:00:00 |  |  | 2013-04-04 00:00:00 | 2013-04-04 00:00:00 | 2013-04-29 00:00:00 | 2013-04-29 00:00:00 |  |  |  |  | 2013-04-08 00:00:00 |  | 2013-04-07 00:00:00 |  |  |  | 2013-04-02 00:00:00 |  |  |  |  |  | 2013-03-26 00:00:00 |  |  |  |  |  | 2013-04-07 00:00:00 |  |  |  |  |  |  |  | 2013-05-12 00:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-14 00:00:00 | 2012-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-14 00:00:00 | 2012-03-14 00:00:00 | 2012-03-14 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 |  |  |  |  |  | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 |  |  |  |  |  |  | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 |  |  |  | 2012-03-15 00:00:00 | 2012-03-21 00:00:00
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 |  |  | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-02-09 00:00:00 | 2012-01-18 00:00:00 |  |  |  |  |  | 2012-02-09 00:00:00 |  |  |  |  | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 2012-02-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 |  |  |  |  |  |  | 2012-02-09 00:00:00 | 2012-02-09 00:00:00 | 2012-02-09 00:00:00 | 2012-02-09 00:00:00 |  |  |  | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
 | [NAME] | 2008-06-12 00:00:00 | 2008-04-12 00:00:00 | 2010-02-19 00:00:00 | 2008-06-28 00:00:00 | 2009-05-01 00:00:00 | 2013-01-24 00:00:00 | 2013-01-24 00:00:00 | 2013-01-25 00:00:00 | 2013-01-24 00:00:00 | 2009-07-08 00:00:00 | 2009-07-08 00:00:00 | 2012-10-29 00:00:00 | 2009-07-08 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00 | 2012-06-24 00:00:00 | 2012-06-24 00:00:00 | 2012-06-24 00:00:00 | 2012-07-04 00:00:00 | 2012-07-04 00:00:00 |  |  |  |  |  | 2012-07-05 00:00:00 | 2012-07-05 00:00:00 |  |  |  |  |  |  | 2012-07-12 00:00:00 | 2012-07-12 00:00:00 |  | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 | 2012-07-12 00:00:00 | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 | 2012-07-20 00:00:00 | 2012-07-20 00:00:00 |  | 2012-07-20 00:00:00 |  |  |  | 2012-07-20 00:00:00 |  |  |  |  | 2012-05-13 00:00:00 | 2012-05-13 00:00:00 | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 |  |  |  |  |  |  |  | 2012-05-19 00:00:00 | 2012-05-19 00:00:00 | 2012-05-19 00:00:00 |  |  |  |  | 2012-06-23 00:00:00 |  | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 |  |  |  | 2012-06-26 00:00:00 | 2012-06-27 00:00:00