Spreadsheet: 472241d1469510208-problem-with-using-an-array-formula-for-vlookup-test-array
Sheet: FEM

V05 To V06 | FOP NO. | FOP DESCRIPTION | TIME H320 | TIME H330 | PART NO. | PART DESCRIPTION | H320 |  | H330 |  | design      parameter | setup parameter | Station NO. | Operator NO. (12 U/H) | Comment
 |  |  |  |  |  |  | 1.5MT LUXI | 1.5AT LUXI | 1.5MT CIF | 1.5AT LUXI
 | A1-EXTERIOR-076 | Install CAGE-NUT to BRACKET ASSY FRONTEND | 26 | 26 | 1001182 | CAGE-NUT-M6 | 3 | 3 | 3 | 3 |  |  | FEM | OP-01-02-03
 | A1-EXTERIOR-02 | Install BUMPER BEAM UNIT ASSY FR | 81 | 81 | 1001008 | ASSY-BOLT-M6*20 | 4 | 4 | 4 | 4 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 |  |  |  |  | 3106840 | BUMPER BEAM UNIT ASSY FR | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 3106830 | BRACKET ASSY FRONTEND | 1 | 1 | 1 | 1 |  |  | FEM
 | A1-POWERTRAIN-001 | Pre-install ENGINE-COOLING-MODULE-ASSEMBLY and CONDENSER-ASSY | 52.2 | 52.2 | 3481866 | ENGINE-COOLING-MODULE-ASSEMBLY | 1 |  | 1 |  |  |  | FEM
 |  |  |  |  | 3481867 | ENGINE-COOLING-MODULE-ASSEMBLY |  | 1 |  | 1 |  |  | FEM
 |  |  |  |  | 3492156 | CONDENSER-ASSY | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1001413 | [NAME]*16 | 4 | 4 | 4 | 4 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 | A1-POWERTRAIN-002 | Install INSERT-FIX-RADIATOR and BRACKET-UPPER | 24.6 | 24.6 | 3481000 | BRACKET-UPPER | 2 | 2 | 2 | 2 |  |  | FEM
 |  |  |  |  | 3481276 | INSERT-FIX-RADIATOR | 2 | 2 | 2 | 2 |  |  | FEM
 | A1-POWERTRAIN-003 | Install ENGINE-COOLING-MODULE-ASSEMBLY to BRACKET ASSY FRONTEND | 61 | 61 | 1007226 | BOLT M6X18 | 4 | 4 | 4 | 4 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 | A1-POWERTRAIN-004 | Install COOLING-FAN-ASSEMBLY | 42 | 42 | 1001413 | ASSY-BOLT-M6*16 | 4 | 4 | 4 | 4 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 |  |  |  |  | 3481007 | COOLING-FAN-ASSEMBLY | 1 | 1 | 1 | 1 |  |  | FEM
 | A1-12-POWERTRAIN-12 | Install RAW-AIR-DUCT-ASSY | 49.2 | 49.2 | 3480944 | RAW-AIR-DUCT-ASSY | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1007010 | ASS-BOLT-M6*25 | 2 | 2 | 2 | 2 | T=(8.5±1)N.m | T=(8.5±0.85)N.m | FEM
 | [NAME] | Install TUBE-SURGE-TANK-RADIATOR | 23.4 | 23.4 | 3481943 | TUBE-SURGE-TANK-RADIATOR | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1007245 | CLAMP-DIAM-22.5 | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1001173 | CLAMP-DIAM20.5 | 1 | 1 | 1 | 1 |  |  | FEM
 | A1-EE-117 | Install AIR-DISCHARGE-TUBE-ASSY to CONDENSER-ASSY | 20.4 | 20.4 | 3493150 | AIR-DISCHARGE-TUBE-ASSY | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1001507 | ASS-BOLT-M6×25 | 1 | 1 | 1 | 1 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 | A1-POWERTRAIN-201 | Install TUBE-OIL-COOLER-IN and TUBE-OIL-COOLER-OUT to ENGINE-COOLING-MODULE | 52.2 | 52.2 | 3481913 | TUBE-OIL-COOLER-IN |  | 1 |  | 1 |  |  | FEM
 |  |  |  |  | 3481914 | TUBE-OIL-COOLER-OUT |  | 1 |  | 1 |  |  | FEM
 |  |  |  |  | 1001307 | RUBBER-CLAMP |  | 1 |  | 1 |  |  | FEM
 |  |  |  |  | 1001248 | CLAMP-DIAM |  | 2 |  | 2 |  |  | FEM
 | A2-13-POWERTRAIN-308 | [NAME] to ENGINE-COOLING-MODULE-ASSEMBLY | 34.2 | 34.2 | 3481005 | HOSE-THERM.HOUSING-RADIATOR | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1001590 | CLAMP-37 | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1007324 | TIE-LOCKING | 2 | 2 | 2 | 2 |  |  | FEM
 |  |  |  |  | 1001170 | CLAMP-DIAM-14 | 1 | 1 | 1 | 1 |  |  | FEM
 | A1-12-CHASSIS-073 | Pre-install HOOD-RELEASE-CABLE to LATCH-HOOD | 18 | 18 | 3459725 | LATCH-HOOD | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 3459726 | HOOD-RELEASE-CABLE | 1 | 1 | 1 | 1 |  |  | FEM
 | A1-12-CHASSIS-071 | INSTALL LATCH HOOD | 21 | 21 | 1001413 | ASSY-BOLT-M6*16 | 1 | 1 | 1 | 1 |  |  | FEM
 | A1-EXTERIOR-01 | Install FRONTEND CENTER BEAM ASSY | 30 | 30 | 3106835 | FRONTEND CENTER BEAM ASSY | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1001008 | ASSY-BOLT-M6*20 | 4 | 4 | 4 | 4 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 | A1-12-EXTERIOR-007 | Install FR BUMPER SUPPORT | 109.2 | 109.2 | 3106828 | FR BUMPER SUPPORT | 1 | 1 | 1 | 1 |  |  | FEM
 |  |  |  |  | 1001412 | SPECIAL SCREW M6*22 | 13 | 13 | 13 | 13 | T=(8.5±1)N.m | (8.5±0.9)N.m | FEM
 | ??????? | Install hood lock | 5.4 | 5.4 | 1001417 |  |  |  |  |  |  |  | FEM
NEW | No FOP | Transfer the FEM preparation table next the FEM installation station | 54 | 54 |  |  |  |  |  |  |  |  | FEM
NEW | No FOP | Transfer the FEM preparation table to FEM sub assy station | 54 | 54 |  |  |  |  |  |  |  |  | FEM
 |  |  | 12.63 | 12.63