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

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
Panel Bulkhead |  |  | 4.48 | 4.48
 | A1-IP-050 | Install PANEL-BULKHEAD on the IP sub-assembly car & Tables Transportation | 146.52 | 146.52 | 3411590 | PANEL-BULKHEAD(4A91AT) |  | 1 |  | 1 |  |  | IP-01 | OP-01
 |  |  |  |  | 3411584 | PANEL-BULKHEAD(4A91MT | 1 |  | 1 |  |  |  | IP-01
 | A1-IP-002 | Install INSULATION-BULKHEAD | 54.88 | 54.88 | 3469007 | INSULATION-BULKHEAD | 1 | 1 | 1 | 1 |  |  | IP-01
 |  |  |  |  | 1000068 | CLIP | 4 | 4 | 4 | 4 |  |  | IP-01
 | A1-CHASSIS-019 (01) | Install brake pedal vacuum booster | 67.4 | 67.4 | 3495020 | PEDAL-BRAKE-WITH-BRKT-ASSY(A1-AT?A2-AT) |  | 1 |  | 1 | T=(18-23)N.m | (20±2)N.m | IP-01
 |  |  |  |  | 3495014 | PEDAL-BRAKE-WITH-BRKT-ASSY(A1-MT?A2-MT) | 1 |  | 1 |  |  |  | IP-01
 |  |  |  |  | 3469011 | INSULATION-HEAT | 1 | 1 | 1 | 1 |  |  | IP-01
 |  |  |  |  | 3497030 | BRAKE-BOOSTER-WITH-CYL-AND-TANK(A1?A2) | 1 | 1 | 1 | 1 | T=(18-26)N.m | 23N.m 3% | IP-01
Booster |  |  | 4.755 | 4.755
 | A1-CHASSIS-019 (02) | Install brake pedal vacuum booster | 117 | 117 | 1001126 | HEX-FLANGE-NUT-M8 | 6 | 6 | 6 | 6 |  |  | IP-01 | OP-02
 |  |  |  |  | 1001188 | PIN-AXLE | 1 | 1 | 1 | 1 |  |  | IP-01
 |  |  |  |  | 1001187 | PIN-CLIP | 1 | 1 | 1 | 1 |  |  | IP-01
 | [NAME] | Install PEDAL-CLUTCH-ASSYCYLINDER-ASSY-CLUTCH-MASTER | 112.72 | 112.72 | 3495017 | PEDAL-CLUTCH-ASSY(A1-MT?A2-MT) | 1 |  | 1 |  | T=(18-23)N.m | (20±2)N.m | IP-01
 |  |  |  |  | 3496031 | CYLINDER-ASSY-CLUTCH-MASTER | 1 |  | 1 |  | T=(12-18)N.m | (15±1.5)N.m | IP-01
 |  |  |  |  | 1001126 | HEX-FLANGE-NUT-M8 | 3 |  | 3 |  | T=(18-26)N.m | 23N.m 3% | IP-01
 |  |  |  |  | 1001139 | PT-HEX-FLANGE-NUT-M8 | 1 |  | 1 |  |  |  | IP-01
 | A1-CHASSIS-159 | Install ONE-WAY-VALVE | 23.48 | 23.48 | 3014189 | ONE-WAY-VALVE | 1 | 1 | 1 | 1 |  |  | IP-01
 | A1-POWERTRAIN-063 | Install CUTCH-MASTER-CYLINDER | 32.1 | 32.1 | 3496034 | CUTCH-MASTER-CYLINDER | 1 |  | 1 |  | T=(13-18)N.m | 15.5N.m 3% | IP-01
Air Conditionar & Wiring Harness |  |  | 8.81 | 8.81
 | A1-EE-074 | Install AIR-CONDITION-THREE-ELE-PART | 90.76 | 90.76 | 3493238 | AIR-CONDITION-THREE-ELE-PART(A1?A2) | 1 | 1 |  | 1 | T=(8.5±1)N.m | T=(8.5±0.9)N.m | IP-02-03 | OP-03-04
 |  |  |  |  | 3493140 | AIR-CONDITION-THREE-ELE-PART(A1?A2 |  |  | 1 |  |  |  | IP-02-03
 |  |  |  |  | 1004167 | NUT M6 | 5 | 5 | 5 | 5 |  |  | IP-02-03
 | A1-POWERTRAIN-059 | HOSE-CLUTCH-MASTER connect BRAKE-BOOSTER-WITH-CYL-AND-TANK | 49.72 | 49.72 | 3496033 | HOSE-CLUTCH-MASTER | 1 |  | 1 |  |  |  | IP-02-03
 |  |  |  |  | 1001170 | CLAMP-DIAM14 | 2 |  | 2 |  |  |  | IP-02-03
 | A1-IP-099 | Install PANEL-BULKHEAD locating pin | 11.36 | 11.36 |  | locating pin | 2 | 2 | 2 | 2 |  | (8.5±0.9)N.m | IP-02-03
 | A1-BODY-025 | clutch connect BRAKEBOOSTER | 15 | 15 |  |  |  |  |  |  |  |  | IP-02-03
 | A1-12-EE-062 | Install WIRING-HARNESS-MAIN | 361.76 |  | 3472422 | WIRING-HARNESS-MAIN(1.5MT) | 1 |  |  |  |  |  | IP-02-03
 |  |  |  |  | 3472424 | WIRING-HARNESS-MAIN(1.5AT) |  | 1 |  |  |  |  | IP-02-03
 |  |  |  |  | 1001134 | ASS-NUT-M6 | 2 | 2 |  |  |  |  | IP-02-03
 |  |  |  |  | 1001043 | BOLT-M5X12 | 2 | 2 |  |  |  |  | IP-02-03
 |  |  |  |  | 1001129 | PT-HEX-FLANGE-NUT-M6 | 5 | 5 |  |  |  |  | IP-02-03
 | A2-13-EE-062 | Install WIRING-HARNESS-MAIN |  | 361.76 | 3972502-E | WIRING-HARNESS-MAIN(1.5MT comfortable) |  |  | 1 |  |  |  | IP-02-03
 |  |  |  |  | 3972501-IR | WIRING-HARNESS-MAIN(1.5AT luxurious) |  |  |  | 1 |  |  | IP-02-03
 |  |  |  |  | 1001134 | ASS-NUT-M6 |  |  | 2 | 2 |  |  | IP-02-03
 |  |  |  |  | 1001043 | BOLT-M5X12 |  |  | 2 | 2 |  |  | IP-02-03
 |  |  |  |  | 1001129 | PT-HEX-FLANGE-NUT-M6 |  |  | 5 | 5 |  |  | IP-02-03
Immobilizer |  |  | 4.786166666666667 | 4.786166666666667
 | A1-EE-030 | Install WIRING-HARNESS-ELECTRIC-AIR-CONDITION | 68 | 68 | 3472003-IR | WIRING-HARNESS-ELECTRIC-AIR-CONDITION | 1 | 1 |  | 1 |  |  | IP-04 | OP-05
 | A1-CHASSIS-119 | Install ACCELERATOR-PEDAL-SENSOR-ASSY | 26.48 | 26.48 | 3094575 | ACCELERATOR-PEDAL-SENSOR-ASSY | 1 | 1 | 1 | 1 | T=(9±1)N.m | (9±0.9)N.m | IP-04
 |  |  |  |  | 1001129 | PT-HEX-FLANGE-NUT-M6 | 3 | 3 | 3 | 3 |  |  | IP-04
 | A1-CHASSIS-017 | Install BRKT-PEDAL-CLUTCH | 28.36 | 28.36 | 3495007 | BRKT-PEDAL-CLUTCH | 1 |  | 1 |  | T=(18-23)N.m | T=(20±2)N.m | IP-04
 |  |  |  |  | 1001126 | HEX-FLANGE-NUT-M8 | 2 |  | 2 |  |  |  | IP-04
 | A1-IP-001 | Install ASSY CCB | 32.33 | 32.33 | 3110419 | ASSY CCB(1.5AT?1.5MT) | 1 | 1 | 1 | 1 |  |  | IP-04
 | A1-EE-225 | Install AT engine TCU-Bracket to PANEL-BULKHEAD | 17.6 | 17.6 | 3486038 | TCU-Bracket-TCU |  | 1 |  | 1 | T=(7±1)N.m | (7±0.7)N.m | IP-04
 |  |  |  |  | 1001125 | HEX-FLANGE-NUT-M6 |  | 1 |  | 1 |  |  | IP-04
 | A1-12-ASS-107 | Install IMMOBILIZER-ECU-DIESEL | 23.8 | 23.8 | 3090282 | IMMOBILIZER-ECU-DIESEL(1.5MT,1.5AT) | 1 | 1 | 1 | 1 | T=(7±1)N.m | (7±0.7)N.m | IP-04
 |  |  |  |  | 1001125 | HEX-FLANGE-NUT-M6 | 2 | 2 | 2 | 2 |  |  | IP-04
 | A1-12-ASS-106 | Install IMMOBILIZER-WINDING-ILLUME | 28.44 | 28.44 | 3974012 | IMMOBILIZER-WINDING-ILLUME | 1 | 1 | 1 | 1 | T=(2.5±0.5)N.m | (2.5±0.3)N.m | IP-04
 |  |  |  |  | 1001104 | ASSY SEREW ST X HEAD-M4X8 | 1 | 1 | 1 | 1 |  |  | IP-04
 | A1-IP-104 | Install IGNITION-SWITCH-WITH-BOLTS | 7.48 | 7.48 | 3476040 | IGNITION-SWITCH-WITH-BOLTS | 1 | 1 | 1 | 1 |  |  | IP-04
 | A2-13-ASS-002 | Install IGNITION-SWITCH-WITH-BOLTS | 54.68 | 54.68 | 3276009 | IGNITION-SWITCH-WITH-BOLTS(comfort) | 1 | 1 | 1 |  | T=(20±3)N.m | (20±2)N.m | IP-04
 |  |  |  |  | 3976009 | IGNITION-SWITCH-WITH-BOLTS-no key(luxury) |  |  |  | 1 |  |  | IP-04
ASSY BODY IP |  |  | 4.361999999999999 | 4.359333333333333
 | A1-EE-088 | Install AIR-DUCT-SIDE-LH | 28.36 | 28.36 | 3489142 | AIR-DUCT-SIDE-LH | 1 | 1 | 1 | 1 | T=(2.5±0.5)N.m | (2.5±0.3)N.m | IP-05 | OP-06
 |  |  |  |  | 1007001 | SCREW-ST-X-HEAD-ST4.2x13 | 1 | 1 | 1 | 1 |  |  | IP-05
 | A1-EE-089 | Install AIR-DUCT-SIDE-RH | 28.36 | 28.36 | 3489143 | AIR-DUCT-SIDE-RH | 1 | 1 | 1 | 1 | T=(2.5±0.5)N.m | (2.5±0.3)N.m | IP-05
 |  |  |  |  | 1007001 | SCREW-ST-X-HEAD-ST4.2x13 | 1 | 1 | 1 | 1 |  |  | IP-05
 | A1-EE-021 | Install AIR-DUCT-SIDE-CENTER | 20.04 | 20.04 | 3489132 | AIR-DUCT-SIDE-CENTER | 1 | 1 | 1 | 1 |  |  | IP-05
 |  |  |  |  | 1001109 | ASSY SEREW ST X HEAD-ST4.2X16 | 2 | 2 | 2 | 2 |  |  | IP-05
 | A1-EE-090 | Install AIR-DUCT-SIDE-CENTER | 43.6 | 43.6 | 3489140 | AIR-DUCT-SIDE-CENTER | 1 | 1 | 1 | 1 | T=(2.5±0.5)N.m | (2.5±0.3)N.m | IP-05
 |  |  |  |  | 1007001 | SCREW-ST-X-HEAD-ST4.2x13 | 4 | 4 | 4 | 4 |  |  | IP-05
 | A1-12-POWERTRAIN-214 | Install STEERING-COLUMN-ASSY-EPS | 122.4 | 122.24 | 3438103 | STEERING-COLUMN-ASSY-EPS | 1 | 1 | 1 | 1 | T=(20±2)N.m | (20±2)N.m | IP-05
 |  |  |  |  | 1001126 | HEX-FLANGE-NUT-M8 | 4 | 4 | 4 | 4 | T=(25±2)N.m | 25N.m3% | IP-05
 | A1-IP-009 | Install ASSY BEZEL INSTR CLUSTER | 18.96 |  | 3414026 | ASSY BEZEL INSTR CLUSTER | 1 | 1 |  |  |  |  | IP-05
 | A2-13-IP-009 | Install ASSY BEZEL INSTR CLUSTER |  | 18.96 | 3107080 | ASSY BEZEL INSTR CLUSTER |  |  | 1 | 1 |  |  | IP-05
Odometer |  |  | 4.889333333333334 | 4.889333333333334
 | A1-12-IP-025 | Install ASSY-BASE-PANEL-CENTER-CONSOLE | 89.8 | 89.8 | 3107090 | ASSY-BASE-PANEL-CENTER-CONSOLE | 1 | 1 | 1 | 1 | T=(4±0.6)N.m | (4±0.4)N.m | IP-06 | OP-07
 |  |  |  |  | 1001111 | ASSY SEREW ST X HEAD-ST4.2X19 | 10 | 10 | 10 | 10 |  |  | IP-06
 | A1-12-EE-079 | Install INSTRUMENT-CLUSTER | 78.44 | 78.44 | 3475031-A8 | INSTRUMENT-CLUSTER | 1 |  | 1 |  | T=(4±0.6)N.m | (4±0.4)N.m | IP-06
 |  |  |  |  | 3475032-A8 | INSTRUMENT-CLUSTER |  | 1 |  | 1 |  |  | IP-06
 |  |  |  |  | 1007001 | SCREW-ST-X-HEAD-ST4.2x13 | 4 | 4 | 4 | 4 |  |  | IP-06
 | A1-12-IP-003 | Install PANEL-COVERPLATE-ABOVE | 8.36 | 8.36 | 3107139-A8 | PANEL-COVERPLATE-ABOVE | 1 | 1 | 1 | 1 |  |  | IP-06
 | A1-12-IP-012 | Install ASSY BODY IP-LH | 116.76 | 116.76 | 3107054-A8 | ASSY BODY IP(A1) | 1 | 1 | 1 | 1 | T=(4±0.6)N.m | (4±0.4)N.m | IP-06
 |  |  |  |  | 1001111 | ASSY SEREW ST X HEAD-ST4.2X19ST4.2×19 | 14 | 14 | 14 | 14 | T=(8.5±1)N.m | (8.5±0.9)N.m | IP-06
 |  |  |  |  | 1001413 | ASS-BOLTM6*16 | 1 | 1 | 1 | 1 |  |  | IP-06
Airbag |  |  | 3.377333333333333 | 3.377333333333333
 | A1-12-IP-026 | Install ASSY BODY IP-RH | 71.64 | 71.64 | 1001111 | ASSY SEREW ST X HEAD-ST4.2X19 | 10 | 10 | 10 | 10 | T=(4±0.6)N.m | (4±0.4)N.m | IP-07 | OP-08
 | A1-12-EE-045 | Install MULTFUNCTION-SWITCH | 34.2 | 34.2 | 3476998 | MULTFUNCTION-SWITCH |  |  | 1 | 1 | T=(4±0.6)N.m | T=(4±0.4)Nm | IP-07
 |  |  |  |  | 3476999 | MULTFUNCTION-SWITCH | 1 | 1 |  |  |  |  | IP-07
 | A1-SAFE-10 | Install PASSENGER-AIRBAG | 96.8 | 96.8 | 3491014-TE | PASSENGER-AIRBAG | 1 | 1 | 1 | 1 | T=(21±2.1)N.m | T=(21±2.1)N.m | IP-07
 |  |  |  |  | 1001019 | ASS-BOLTM6*25 | 2 | 2 | 2 | 2 | T=(24±2.4)N.m | 24N.m 3% | IP-07
 |  |  | 35.45983333333334 | 35.45716666666667