Spreadsheet: 827007d1682429706-match-multiple-values-and-return-sum-of-multiple-columns-joboperations_sample
Sheet: Item_Matrix

Customer: | Item: | Product Code: | Desc:
A220 | 1201000-001 | 1040 | ICCP OVERHEAD ASSEMBLY | Operation | 1 | 7 | 10 | 20 | 25 | 30 | 40 | 50 | 60
 | 1201000-001 | 1040 |  | WC | STOCK | CSCSER | CSCSER | QCTC | CSCSER | CSCSER | CSCSER | CSCSER | TRANS
 | 1201000-001 | 1040 |  | Run Duration | 0 | 0.4 | 7.45 | 8 | 1 | 0.365 | 5.65 | 0.65 | 0
A220 | 1201000-002 | 1040 | ICCP OVERHEAD ASSEMBLY | Operation | 1 | 7 | 10 | 20 | 25 | 30 | 40 | 50 | 60
 | 1201000-002 | 1040 |  | WC | STOCK | CSCSER | CSCSER | QCTC | CSCSER | CSCSER | CSCSER | CSCSER | TRANS
 | 1201000-002 | 1040 |  | Run Duration | 0 | 0.4 | 7.45 | 8 | 1 | 0.365 | 5.65 | 0.65 | 0
A220 | 1202300-001 | 1040 | ICCP PARKING BRAKE PANEL | Operation | 1 | 10 | 20 | 30 | 40 | 50 | 60
 | 1202300-001 | 1040 |  | WC | STOCK | CSCSER | QCTC | CSCSER | CSCSER | CSCSER | TRANS
 | 1202300-001 | 1040 |  | Run Duration | 0 | 2.33 | 8 | 0.22 | 2.47 | 0.38 | 0
A220 | 1202600-001 | 1040 | ICCP PEDESTAL BLANK PANEL | Operation | 1 | 10 | 30 | 40 | 50 | 60
 | 1202600-001 | 1040 |  | WC | STOCK | CSCSER | CSCSER | CSCSER | CSCSER | TRANS
 | 1202600-001 | 1040 |  | Run Duration | 0 | 0.53 | 0.06 | 0.7 | 0.28 | 0
A220 | 1203500-001 | 1040 | ICCP LEFT/RIGHT LIGHT PANEL | Operation | 1 | 10 | 20 | 30 | 40 | 50 | 60
 | 1203500-001 | 1040 |  | WC | STOCK | CSCSER | QCTC | CSCSER | CSCSER | CSCSER | TRANS
 | 1203500-001 | 1040 |  | Run Duration | 0 | 1.5 | 8 | 0.095 | 0.5 | 0.3 | 0
EMBRAER (LEGACY) | 430100-001 | 1040 | CCP, PRESS, EMB | Operation | 1 | 10 | 20 | 30
 | 430100-001 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430100-001 | 1040 |  | Run Duration | 0 | 5.22 | 0.33 | 0
EMBRAER (LEGACY) | 430200-003 | 1040 | PANEL AIR COND/PNEUMATIC | Operation | 1 | 10 | 20 | 30
 | 430200-003 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430200-003 | 1040 |  | Run Duration | 0 | 3.5 | 0.5 | 0
EMBRAER (LEGACY) | 430300-003 | 1040 | CCP, ELECTRICAL, EMB | Operation | 1 | 10 | 20 | 30
 | 430300-003 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430300-003 | 1040 |  | Run Duration | 0 | 23.3 | 0.5 | 0
EMBRAER (LEGACY) | 430400-001 | 1040 | CCP, HEATERS, EMB | Operation | 1 | 10 | 20 | 30
 | 430400-001 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430400-001 | 1040 |  | Run Duration | 0 | 6.3 | 0.33 | 0
EMBRAER (LEGACY) | 430500-001 | 1040 | CCP, HYDRAULIC, EMB | Operation | 1 | 10 | 20 | 30
 | 430500-001 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430500-001 | 1040 |  | Run Duration | 0 | 3 | 0.33 | 0
EMBRAER (LEGACY) | 430700-001 | 1040 | CCP, APU CTRL, EMB | Operation | 1 | 10 | 20 | 30
 | 430700-001 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430700-001 | 1040 |  | Run Duration | 0 | 4.5 | 0.33 | 0
EMBRAER (LEGACY) | 430800-002 | 1040 | CCP, PAX CAB, EMB | Operation | 1 | 10 | 20 | 30
 | 430800-002 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430800-002 | 1040 |  | Run Duration | 0 | 2.5 | 0.33 | 0
EMBRAER (LEGACY) | 430900-001 | 1040 | CCP, COCKPIT LTS, EMB | Operation | 1 | 10 | 20 | 30
 | 430900-001 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430900-001 | 1040 |  | Run Duration | 0 | 8.25 | 0.33 | 0
EMBRAER (LEGACY) | 430900-002 | 1040 | PANEL COCKPIT LIGHTS | Operation | 1 | 10 | 20 | 30
 | 430900-002 | 1040 |  | WC | STOCK | EMBLEG | [NAME] | TRANS
 | 430900-002 | 1040 |  | Run Duration | 0 | 1.75 | 0.33 | 0
EMBRAER (KC390) | 441000-003 | 1040 | CCP, OXYGEN, [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441000-003 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441000-003 | 1040 |  | Run Duration | 0 | 2.52 | 0.2 | 0.33 | 0.25 | 0
EMBRAER (KC390) | 441100-004 | 1040 | CCP,ELECTRICAL [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441100-004 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441100-004 | 1040 |  | Run Duration | 0 | 22.15 | 0.3 | 0.5 | 0.25 | 0
EMBRAER (KC390) | 441200-001 | 1040 | CCP, [NAME], [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441200-001 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441200-001 | 1040 |  | Run Duration | 0 | 17.25 | 0.2 | 0.33 | 0.25 | 0
EMBRAER (KC390) | 441300-003 | 1040 | CCP, FLIGHT DECK LIGHTS, [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441300-003 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441300-003 | 1040 |  | Run Duration | 0 | 12.11 | 0.2 | 0.33 | 0.25 | 0
EMBRAER (KC390) | 441400-001 | 1040 | CCP, SGNS/ELEC/EMRLT, [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441400-001 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441400-001 | 1040 |  | Run Duration | 0 | 2.35 | 0.2 | 0.33 | 0.25 | 0
EMBRAER (KC390) | 441500-002 | 1040 | CCP, SILENCE ZEROIZE, [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441500-002 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441500-002 | 1040 |  | Run Duration | 0 | 1.5 | 0.2 | 0.33 | 0.25 | 0
EMBRAER (KC390) | 441600-003 | 1040 | CCP,FUEL,[NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441600-003 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441600-003 | 1040 |  | Run Duration | 0 | 19.15 | 0.3 | 0.5 | 0.25 | 0
EMBRAER (KC390) | 441700-001 | 1040 | CCP, HYDRAULIC, [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441700-001 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441700-001 | 1040 |  | Run Duration | 0 | 6.5 | 0.2 | 0.33 | 0.25 | 0
EMBRAER (KC390) | 441900-003 | 1040 | PANEL CCP, MISSION SYSTEM, [NAME] | Operation | 1 | 10 | 15 | 20 | 25 | 30
 | 441900-003 | 1040 |  | WC | STOCK | EMBKC | QCCPA2 | [NAME] | EMBKC | TRANS
 | 441900-003 | 1040 |  | Run Duration | 0 | 4.55 | 0.3 | 0.33 | 0.25 | 0
GULFSTREAM | 1401100-001 | 1040 | SWITCH PANEL (SP) | Operation | 1 | 10 | 20 | 25 | 40 | 50 | 60
 | 1401100-001 | 1040 |  | WC | STOCK | NPI | QCTC | NPI | QCNPI | NPI | TRANS
 | 1401100-001 | 1040 |  | Run Duration | 0 | 8.62 | 16 | 1 | 1.92 | 0.25 | 0
GULFSTREAM | 1401200-001 | 1040 | CIRCUIT BREAKER PANEL (CBP) | Operation | 1 | 10 | 25 | 40 | 50 | 60
 | 1401200-001 | 1040 |  | WC | STOCK | NPI | NPI | QCNPI | NPI | TRANS
 | 1401200-001 | 1040 |  | Run Duration | 0 | 3 | 0.5 | 1.58 | 0.15 | 0
GULFSTREAM | 1401400-001 | 1040 | DIMMING/ANNUNCIATION BOX (DAB) | Operation | 1 | 5 | 10 | 20 | 25 | 30 | 40 | 50 | 60
 | 1401400-001 | 1040 |  | WC | STOCK | [NAME] | CPA01 | QCTC | CPA01 | CPA01 | [NAME] | CPA01 | TRANS
 | 1401400-001 | 1040 |  | Run Duration | 0 | 0.25 | 1.48 | 0 | 0 | 0.58 | 0.5 | 0.1 | 0
GULFSTREAM | 1401500-001 | 1040 | PANEL SWITCH | Operation | 1 | 10 | 20 | 25 | 40 | 50 | 60
 | 1401500-001 | 1040 |  | WC | STOCK | NPI | QCTC | NPI | QCNPI | NPI | TRANS
 | 1401500-001 | 1040 |  | Run Duration | 0 | 8.62 | 0 | 0 | 1.92 | 0.25 | 0
GULFSTREAM | 1401600-002 | 1040 | PANEL CIRCUIT BREAKER | Operation | 1 | 10 | 25 | 40 | 50 | 60
 | 1401600-002 | 1040 |  | WC | STOCK | NPI | NPI | QCNPI | NPI | TRANS
 | 1401600-002 | 1040 |  | Run Duration | 0 | 3 | 0.5 | 1.58 | 0.15 | 0