Spreadsheet: 73385d1274039593-how-to-expand-arrays-in-the-formula-packaging-1-
Sheet: Values

DIFFICULTY FACTORS
 |  |  |  | PRODUCT CODE | TASKS
 |  |  |  |  | CARAMEL | TOPPING | CUTTING | BOATING | PACKING | REWRAPING | [NAME]
 |  |  |  | [NAME] |  |  | 1 |  | 2
 |  |  |  | BHSCCB |  | 5 | 1 |  | 2 |  |  |  |  |  |  | BLACK
 |  |  |  | BHSCFJ |  | 2 | 1 |  | 2 |  | 1 |  |  |  |  | ORANGE
 |  |  |  | BHSCS | 1 | 3 | 2 |  | 2 |  |  |  |  |  |  | YELLOW
 | DS1 |  |  | [NAME] |  |  | 1 |  | 3 |  |  |  |  |  |  | PINK
 | DS2 |  |  | BHSHCT |  | 2 | 1 |  | 1 |  | 2 |  |  |  |  | BLUE
 | NS1 |  |  | BJ |  |  | 1 |  | 2 | 3 |  |  |  |  |  | GREEN
 | NS2 |  |  | BOOBFJ |  |  | 1 |  | 1 |  |  |  |  |  |  | RED
 |  |  |  | BOOCCB |  |  | 1 |  | 1 | 2
 |  |  |  | BOOCCB2 |  |  | 1 |  | 2 | 2
 |  |  |  | BOOCFJ |  | 1 | 2 |  | 1
 |  |  |  | BOOCRS2 |  |  | 2 |  | 2
 |  |  |  | [NAME] |  |  | 1 |  | 1
 |  |  |  | BOOYFJ |  | 2 | 1 |  | 1
 |  |  |  | CB |  |  | 1 |  | 2
 |  |  |  | ENRAB |  |  | 1 |  | 2
 |  |  |  | ENRBAAB |  |  | 1 |  | 2
 |  |  |  | ENRBAABGG |  |  | 1 |  | 2
 |  |  |  | ENRBACH |  |  | 1 |  | 2
 |  |  |  | ENRBACR |  |  | 1 |  | 2
 |  |  |  | ENRBACR1 |  |  | 1 |  | 2
 |  |  |  | ENRBACRGG |  |  | 1 |  | 2
 |  |  |  | ENRCR |  |  | 1 |  | 2
 |  |  |  | ENRESP |  |  | 1 |  | 3
 |  |  |  | FOOGKPAK
 |  |  |  | GUTIF | 1 | 1 | 2 |  | 3 | 2
 |  |  |  | GUTIF-FR | 1 | 1 | 2 |  | 3
 |  |  |  | GUTIF-L | 1 | 1 | 2 |  | 3
 |  |  |  | GUTIF-P | 1 | 1 | 2 |  | 3
 |  |  |  | GUTIF-SAMP | 1 | 1 | 2 |  | 3
 |  |  |  | HACB1 |  |  | 1 |  | 1 |  | 2
 |  |  |  | KCCB |  |  | 1 |  | 2
 |  |  |  | KCCBAVE |  |  | 1 |  | 2
 |  |  |  | KCCBBN |  |  | 1 |  | 2
 |  |  |  | KCCBDE |  |  | 1 |  | 2
 |  |  |  | KCCBEST |  |  | 1 |  | 2
 |  |  |  | KCCBFM-FRA |  |  | 1 |  | 2
 |  |  |  | KCCBNL |  |  | 1 |  | 2
 |  |  |  | KCCBPR |  |  | 1 |  | 2
 |  |  |  | KCCBSP |  |  | 1 |  | 2
 |  |  |  | [NAME] |  |  | 1 |  | 2
 |  |  |  | KCCBWT1 |  |  | 1 |  | 2 | 2
 |  |  |  | [NAME] |  | 1 | 1 |  | 2
 |  |  |  | KCCNFJBP
 |  |  |  | KCCNFJBP |  | 1 | 1 |  | 2 |  | 2
 |  |  |  | KCFJ |  |  | 1 |  | 2
 |  |  |  | [NAME] |  | 1 | 1 |  | 2 |  | 2
 |  |  |  | [NAME] |  |  | 1 |  | 1
 |  |  |  | KCHC |  | 1 | 1 |  | 2
 |  |  |  | KCHCBN |  | 1 | 1 |  | 2
 |  |  |  | KCHCDE |  | 1 | 1 |  | 2
 |  |  |  | KCHCDE |  | 1 | 1 |  | 2
 |  |  |  | KCHCENR |  | 1 | 1 |  | 1
 |  |  |  | KCHCFM-FRA |  | 1 | 1 |  | 2
 |  |  |  | KCHCHEM |  | 1 | 1 |  | 2 | 3
 |  |  |  | KCHCNER |  | 1 | 1 |  | 2
 |  |  |  | KCHCNL |  | 1 | 1 |  | 1
 |  |  |  | KCHCSP |  | 1 | 1 |  | 2
 |  |  |  | KCMB |  |  | 2 |  | 2
 |  |  |  | KCMBENR |  |  | 2 |  | 2
 |  |  |  | KCMBNL |  |  | 2 |  | 2
 |  |  |  | KCNSB | 1 | 3 | 1 |  | 2
 |  |  |  | KCNSBNL |  |  | 1 |  | 1
 |  |  |  | KCOB
 |  |  |  | KCS | 1 | 1 | 2 |  | 2
 |  |  |  | KCSBN | 1 | 1 | 1 |  | 2
 |  |  |  | KCSDE | 1 | 1 | 1 |  | 2
 |  |  |  | KCSNL | 1 | 1 | 1 |  | 1
 |  |  |  | KCSSP | 1 | 1 | 1 |  | 2
 |  |  |  | KCST | 1 | 3
 |  |  |  | KCSWEB | 1 | 1 | 1 |  | 2
 |  |  |  | KCSWT2 | 1 | 1 | 2 |  | 2
 |  |  |  | KDFMB |  |  | 1 |  | 1
 |  |  |  | KFJ1 |  |  | 1 |  | 2
 |  |  |  | KFJDE |  |  | 1 |  | 2
 |  |  |  | KFJDE |  |  | 1 |  | 2
 |  |  |  | KFJNL |  |  | 1 |  | 1
 |  |  |  | KFJWT1 |  |  | 1 |  | 2
 |  |  |  | KFJWT2 |  |  | 1 |  | 2 | 2
 |  |  |  | KGDFSB |  |  | 1 |  | 2
 |  |  |  | KHJ |  |  | 1 |  | 2 | 2
 |  |  |  | KHJ1 |  |  | 1 |  | 2
 |  |  |  | KHJ1 |  |  | 1 |  | 2
 |  |  |  | [NAME] |  |  | 1 |  | 2
 |  |  |  | KHJENR |  |  | 1 |  | 2
 |  |  |  | KHJFM-FRA |  |  | 1 |  | 2
 |  |  |  | KHJNL |  |  | 1 |  | 1
 |  |  |  | KHJWEB |  |  | 1 |  | 2
 |  |  |  | KHMJ |  |  | 1 |  | 1
 |  |  |  | KHMJENR |  |  | 1 |  | 1
 |  |  |  | KPBS |  |  | 1 |  | 2
 |  |  |  | KPBSDE |  |  | 1 |  | 2 | 2
 |  |  |  | KPBSDE |  |  | 1 |  | 2 | 2
 |  |  |  | KPBSNL
 |  |  |  | KPBSWEB |  |  | 1 |  | 2
 |  |  |  | KPCP
 |  |  |  | KSB |  |  | 1 |  | 2
 |  |  |  | KSBNL |  | 1 | 1 |  | 1
 |  |  |  | [NAME]) |  | 1 | 2 |  | 2 |  | 3
 |  |  |  | [NAME] (TRIAL) |  | 1 | 2 |  | 2 |  | 3
 |  |  |  | KWFCNB
 |  |  |  | MONCBPS |  |  | 1 | 3 | 3
 |  |  |  | MONCCB |  |  | 1 |  | 2
 |  |  |  | MONCCNJ | 1 | 3 | 1 |  | 2
 |  |  |  | MONCS | 1 | 1 | 1 |  | 2
 |  |  |  | MONESB |  |  | 1 |  | 2
 |  |  |  | MONESB |  |  | 1 |  | 2
 |  |  |  | MONFSJ |  |  | 1 |  | 2
 |  |  |  | MONPB |  |  | 1 |  | 2
 |  |  |  | MONPBPS |  |  | 1 | 3 | 3
 |  |  |  | MSBNCSQ |  |  | 1 | 3 | 3
 |  |  |  | MSCBPS4 |  |  | 1 | 3 | 3 |  | 1
 |  |  |  | MSCCBB |  |  | 1 |  | 2
 |  |  |  | MSCRASFJ |  |  | 1 |  | 2 | 2
 |  |  |  | MSCRCB |  |  | 1 |  | 2 | 2
 |  |  |  | MSCRCCFJ |  | 2 | 2
 |  |  |  | MSCRCS1 | 1 | 2 | 1 |  | 2
 |  |  |  | MSCRCS2 | 1 | 2 | 1 |  | 2
 |  |  |  | MSCRRR1 |  | 1 | 2 |  | 2
 |  |  |  | MSCRWCB |  |  |  |  | 2 | 2
 |  |  |  | MSFTGASFJ |  | 1 | 2 |  | 2
 |  |  |  | MSFTGCBD2 |  | 1 | 1 |  | 1 | 2
 |  |  |  | MSFTGCDFJ2 |  | 1 | 2 |  | 1 | 2
 |  |  |  | MSFTGCSD2 | 1 | 1 | 1 |  | 1 | 2
 |  |  |  | MSFTGDFNB |  |  | 1 |  | 1
 |  |  |  | MSFTGRR1
 |  |  |  | MSFTGRR2 |  | 1 | 2 |  | 2
 |  |  |  | MSFTGSB |  |  | 1 |  | 1
 |  |  |  | MSFTGSBB |  |  | 1 |  | 1
 |  |  |  | MSMCS | 1 | 2 | 2 | 3 | 2 | 2
 |  |  |  | MSMEB |  |  | 2 | 3 | 3 | 3 | 1
 |  |  |  | MSMTB |  |  | 2 | 3 | 3 | 3
 |  |  |  | MSRCMT
 |  |  |  | MSRFPS3 |  | 1 | 1 | 2 | 3 | 2
 |  |  |  | [NAME] |  |  | 1 | 2 | 2
 |  |  |  | MSSCCS1 | 1 | 3 | 1 |  | 2
 |  |  |  | MSSCRR1 |  | 1 | 1 |  | 2
 |  |  |  | MSVINS (TRIAL) | 0 | 1 | 1 | 3 | 3 |  | 0
 |  |  |  | [NAME] |  | 3 | 2 | 3 | 3
 |  |  |  | MSXVS |  | 3 | 2 | 3 | 3 |  | 3
 |  |  |  | NERKPAK
 |  |  |  | PBB3 |  |  | 1 |  | 2
 |  |  |  | PCHC1 |  | 1 | 2 |  | 2
 |  |  |  | PD | 1 | 1 | 1 | 1 | 1
 |  |  |  | PGDFSB |  |  | 2 |  | 2
 |  |  |  | PMB |  |  | 3 |  | 3
 |  |  |  | PPOWB1 |  |  | 1 |  | 2
 |  |  |  | PSCBAR1 | 1 | 3 | 1 |  | 2
 |  |  |  | PSCBBITE |  |  | 2 |  | 3
 |  |  |  | PWFCNCB |  |  | 1 |  | 2
 |  |  |  | PXMS2 |  | 1 | 3 |  | 3
 |  |  |  | REPCCC1 | 1 | 2 | 1 |  | 3
 |  |  |  | REPICSB | 1 | 3 | 1 |  | 3
 |  |  |  | RFCXM2 | 1 | 3 | 1 |  | 2 | 2
 |  |  |  | SAIBBSB | 1 | 3 | 1 |  | 1
 |  |  |  | [NAME] |  |  | 1 |  | 1
 |  |  |  | SAIBRC |  | 1 | 1 |  | 1
 |  |  |  | SAIFTGJFJ1 |  |  | 1 |  | 2 | 3
 |  |  |  | STAABC
 |  |  |  | STABAN |  |  | 2 |  | 3
 |  |  |  | STABCFJ
 |  |  |  | STABFW2 |  |  | 1 |  | 1
 |  |  |  | STABFW3 |  |  | 1 |  | 1
 |  |  |  | STACR1 |  |  | 2 |  | 3
 |  |  |  | STACR2 |  |  | 2 |  | 3
 |  |  |  | STACS1 | 1 | 3 | 1 |  | 1
 |  |  |  | STACS3 | 1 | 3 | 1 |  | 1
 |  |  |  | STACS4 | 1 | 3 | 1 |  | 1
 |  |  |  | STACSQ2 |  |  | 1 |  | 1
 |  |  |  | STACSQ3 |  |  | 1 |  | 1
 |  |  |  | STACSQ4 |  |  | 1 |  | 1
 |  |  |  | STACSQ5 |  |  | 1 |  | 1
 |  |  |  | STAEB1 |  |  | 1 | 2 | 1 |  | 2
 |  |  |  | STAFCC |  |  | 2 |  | 1
 |  |  |  | [NAME] |  |  | 2 |  | 1
 |  |  |  | STAGB2 |  |  | 1 |  | 1
 |  |  |  | STAGB3 |  |  | 1 |  | 1
 |  |  |  | STAGFB |  |  | 2 |  | 1
 |  |  |  | STAGKPAK |  |  |  |  | 1
 |  |  |  | STAMS1P |  |  |  |  | 0 |  | 1
 |  |  |  | STAMS1S |  |  |  |  | 0 |  | 2
 |  |  |  | STAMS3P |  |  |  |  | 0 |  | 1.2
 |  |  |  | STAMS3S |  |  |  |  | 0 |  | 2
 |  |  |  | STAPBS |  |  | 1 | 2 | 1
 |  |  |  | STARR2 |  | 1 | 1 |  | 1
 |  |  |  | STARR4 |  | 1 | 1 |  | 1
 |  |  |  | TRIAL | 1 | 3 | 1 |  | 1 |  | 1
 |  |  |  | WAITROSE PATISERIES |  |  |  |  | 2 | 2
 |  |  |  | WEBXCBL
 |  |  |  | WETGR |  |  |  |  | 1 |  | 1
 |  |  |  | WTABFJ |  |  | 1 |  | 1
 |  |  |  | WTABFJNL1 |  |  | 1 |  | 3
 |  |  |  | WTCAPS2 |  |  |  |  |  |  | 1
 |  |  |  | WTCBPS1 |  |  | 1 | 2 | 3
 |  |  |  | WTCS |  | 1 | 1 |  | 2 | 2
 |  |  |  | WTCSPS1 | 1 | 1 | 1 | 2 | 3
 |  |  |  | WTCSPS2 | 1 | 1 | 1 | 3 | 3
 |  |  |  | WTHJPS1 |  |  | 1 | 2 | 3
 |  |  |  | WTHJPS2 |  |  | 1 | 3 | 3
 |  |  |  | WTRM
 |  |  |  | WTSB2 |  | 1 | 1 |  | 1
 |  |  |  | WTSBNL |  | 1 | 1 |  | 1
 |  |  |  | WTTF1 |  | 1 | 2 |  | 1
 |  |  |  | WTTFNL |  | 1 | 2 |  | 2
 |  |  |  | WTTFPS1 |  |  | 1 | 3 | 3
 |  |  |  | WTWB |  |  | 1 |  | 1 | 3
 |  |  |  | WTWBNL |  |  | 1 |  | 1
 |  |  |  | WTFNFJ |  |  | 1 |  | 2 | 3
 |  |  |  | WTMS | 1 | 1 | 1 |  | 2 | 3
 |  |  |  | IYGJ |  | 1 | 1 |  | 2 | 3
 |  |  |  | Orange
 |  |  |  | Yellow
 |  |  |  | Pink
 |  |  |  | Blue
 |  |  |  | Green
 |  |  |  | Red
 |  |  |  | Black