Spreadsheet: 767174d1644325460-if-formula-with-3-logic-didnt-work-daily-ro-satrio-2022-02-07-test
Sheet: Stock detail 07 Feb 2022

 |  |  | Report Stock By Branch
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  | 6 | 7 |  |  |  |  | 8 | 9 | 10 |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! |  |  |  |  |  | 38 |  |  |  | 2 | 3 | 4 | 5 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  |  |  |  | 2022-02-07 00:00:00 |  |  |  |  |  | w22 | PDR | W19 |  |  |  |  |  |  | SC | PIM | P07 | P10 | PDR | OP1 | P99 | PDR FIX | PL2 | MKG | TP | BS | KK | MAS | SMS | GI | W13 | SMB | MCP | PCB | PIC | AM | MT | HMJ | CP | PKW | SKA | PKL | PVJ | DPM | DMB | SPM | MCD | PAJ | BWB | Total
SALES PERFORM | Model SKU | Model+color+size | Model | Category | Sub Category | Launch | Solddate | Aging | [NAME] | ABC Stock | Begin Price | Price | Distribution | Transit | Retur | ODC | Disc | Color | Size | From | Qty | To | P01 | P02 | P07 | P10 | PDR | OP1 | P99 | PDR FIX | PL2 | W02 | W06 | W07 | W08 | W10 | W11 | W12 | W13 | W14 | W15 | W17 | W18 | W19 | W20 | W21 | [NAME] | W24 | W25 | W26 | [NAME] | W28 | W29 | W30 | W31 | [NAME] | W35 | Total | Total New | Seasonal | Stock [NAME] | Stock LK | Theme | Launch Name | Mandatory Article | ART STAY DI MAS | Class | Category | Sub-Class Name | Heel Height Range | Main Material Text | [NAME] | sku_theme text | sku_embellishment text | sku_toebox text | sku_closuretype text | sku_category2 text | SKU Material Type Text | Collection | SKU - Product Branding Text
 | [NAME] | PM176210102DWHT41 | PM176210102D | PMSHOES | MENSPORT | 2018 L7 | 2019-03-20 00:00:00 | 151 | Regroup | 0 | 1399000 | 419000 | CHECK |  |  |  | 70 | WHT | 41 |  |  |  | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | Atrium | 0 | 0 | 0 | Atrium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | PM176210102DWHT43 | PM176210102D | PMSHOES | MENSPORT | 2018 L7 | 2019-03-20 00:00:00 | 151 | Regroup | 0 | 1399000 | 419000 | CHECK |  |  |  | 70 | WHT | 43 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Atrium | 0 | 0 | 0 | Atrium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | [NAME] | PM176210124 | PMSHOES | MENSPORT | 2019 L6 | 2019-08-02 00:00:00 | 131 | Regroup | 0 | 1399000 | 399000 | CHECK |  |  |  | 70 | BLK | 40 |  |  |  | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | Atrium | 0 | 0 | Future Street | Atrium | 0 | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | FUTURE STREET | Mixed Material | 0 | 0 | Sneakers | Non-Leather | Main Launch | 0
 | PM176210126WHT | PM176210126WHT40 | PM176210126 | PMSHOES | MENSPORT | 2019 L6 | 2019-10-23 00:00:00 | 120 | Regroup | 0 | 1349000 | 399000 | CHECK |  |  |  | 70 | WHT | 40 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Atrium | 0 | 0 | Future Street | Atrium | 0 | 0 | Casual Sports | Slip On | 0 | 0 | Fabric | Rubber | NON-THEME | Elastic Band | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210126DWHT | PM176210126DWHT40 | PM176210126D | PMSHOES | MENSPORT | 2019 L6 | 2019-10-23 00:00:00 | 120 | Regroup | B | 1349000 | 399000 | CHECK |  |  |  | 70 | WHT | 40 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | Atrium | 0 | 0 | 0 | Atrium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PM176210131RED | PM176210131RED41 | PM176210131 | PMSHOES | MENSPORT | 2019 L7 | 2019-12-14 00:00:00 | 112 | Regroup | A | 1299000 | 399000 | RO |  |  |  | 70 | RED | 41 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | Atrium | 5 | 0 | 0 | Atrium | 0 | Stock OK | Casual Sports | Slip On | 0 | 0 | Fabric | TPR | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210131RED | PM176210131RED42 | PM176210131 | PMSHOES | MENSPORT | 2019 L7 | 2019-12-14 00:00:00 | 112 | Regroup | A | 1299000 | 399000 | RO |  |  |  | 70 | RED | 42 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | Atrium | 1 | 0 | 0 | Atrium | 0 | Stock OK | Casual Sports | Slip On | 0 | 0 | Fabric | TPR | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210131RED | PM176210131RED43 | PM176210131 | PMSHOES | MENSPORT | 2019 L7 | 2019-12-14 00:00:00 | 112 | Regroup | A | 1299000 | 399000 | RO |  |  |  | 70 | RED | 43 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | Atrium | 3 | 0 | 0 | Atrium | 0 | Stock OK | Casual Sports | Slip On | 0 | 0 | Fabric | TPR | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210132BLK | PM176210132BLK39 | PM176210132 | PMSHOES | MENSPORT | 2019 L7 | 2020-04-02 00:00:00 | 97 | Regroup | B | 1199000 | 479000 | RO |  |  |  | 60 | BLK | 39 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | Atrium | 2 | 0 | 0 | Atrium | Mandatory | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210132BLK | PM176210132BLK40 | PM176210132 | PMSHOES | MENSPORT | 2019 L7 | 2020-04-02 00:00:00 | 97 | Regroup | B | 1199000 | 479000 | RO |  |  |  | 60 | BLK | 40 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | Atrium | 2 | 0 | 0 | Atrium | Mandatory | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210132BLK | PM176210132BLK41 | PM176210132 | PMSHOES | MENSPORT | 2019 L7 | 2020-04-02 00:00:00 | 97 | Regroup | B | 1199000 | 479000 | RO |  |  |  | 60 | BLK | 41 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | Atrium | 2 | 0 | 0 | Atrium | Mandatory | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210132BLK | PM176210132BLK42 | PM176210132 | PMSHOES | MENSPORT | 2019 L7 | 2020-04-02 00:00:00 | 97 | Regroup | B | 1199000 | 479000 | RO |  |  |  | 60 | BLK | 42 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | Atrium | 1 | 0 | 0 | Atrium | Mandatory | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210132BLK | PM176210132BLK43 | PM176210132 | PMSHOES | MENSPORT | 2019 L7 | 2020-04-02 00:00:00 | 97 | Regroup | B | 1199000 | 479000 | RO |  |  |  | 60 | BLK | 43 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | Atrium | 3 | 0 | 0 | Atrium | Mandatory | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | PM176210132BLK | PM176210132BLK44 | PM176210132 | PMSHOES | MENSPORT | 2019 L7 | 2020-04-02 00:00:00 | 97 | Regroup | B | 1199000 | 479000 | RO |  |  |  | 60 | BLK | 44 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | Atrium | 2 | 0 | 0 | Atrium | Mandatory | 0 | Casual Sports | Lace-up | 0 | 0 | Fabric | Rubber | POET | Contrast Piping | 0 | 0 | Fashion | Non-Leather | Main Launch | 0
 | FLEXIBLEPLASTICWHT | FLEXIBLEPLASTICWHTXS | FLEXIBLEPLASTIC | OTH PEDRO | OTHPDR | 2021 L2 | 2009-01-01 00:00:00 | 684 | 0 | 0 | 0 | 0 | CHECK |  |  |  | 0 | WHT | XS |  |  |  | 13 | 12 | 0 | 0 | 1000 | 0 | 0 | 1000 | 0 | 13 | 9 | 13 | 13 | 56 | 13 | 11 | 0 | 11 | 12 | 14 | 14 | 11 | 8 | 9 | 12 | 0 | 10 | 14 | 11 | 12 | 0 | 14 | 13 | 9 | 13 | 1340 | 1340 | Terminal 2 | 191 | 149 | 0 | Terminal 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PM215210106BLK | PM215210106BLKM | [NAME] | PMBAGS | MENBAGS | 2021 L2 | 2021-03-26 00:00:00 | 45 | Regroup | C | 2049000 | 2049000 | CHECK |  |  |  | 0 | BLK | M |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 4 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 15 | 15 | Terminal 2 | 4 | 11 | 0 | Terminal 2 | 0 | 0 | Formal | Briefcase | 0 | 0 | [NAME] | 0 | RAMADAN | 0 | 0 | Zipper | 0 | Non-Leather | Main Launch | 0
 | Total | Total | Total |  |  |  |  | #[NAME]! | 0 | 0 | #N/A | #N/A | CHECK |  |  |  |  |  |  |  |  |  | 3387 | 2092 | 118 | 923 | 103208 | 826 | 19 | 102246 | 117 | 3655 | 3792 | 2908 | 3131 | 3236 | 3113 | 3466 | 0 | 3062 | 4738 | 3476 | 5413 | 2901 | 5123 | 3129 | 4168 | 7 | 4504 | 2800 | 3643 | 3430 | 4286 | 4420 | 2632 | 3407 | 3458 | 197626 | 196703 |  | 37751 | 55626 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0