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

Launch | 2014 L3 | 27 |  | 1900-01-01 00:00:00 | 2022-02-07 00:00:00 |  |  |  |  |  |  |  | 36526 | Sum of P01 | Sum of P02 | Sum of P07 | Sum of PDR | Sum of OP1 | Sum of PDR FIX | Sum of W02 | Sum of W06 | Sum of W07 | Sum of W08 | Sum of W10 | Sum of W11 | Sum of W12 | Sum of W14 | Sum of W15 | Sum of W17 | Sum of W18 | Sum of W19 | Sum of W20 | Sum of W21 | Sum of W22 | Sum of W24 | Sum of W25 | Sum of W26 | Sum of W27 | Sum of W28 | Sum of W29 | Sum of W30 | Sum of W31 | Sum of W34 | Sum of W35 |  |  |  |  |  |  |  | AI | AJ | AN | AO | AQ |  | AU | AV | AX | AY |  | AZ | BB | BD
 |  |  |  |  |  |  |  |  |  |  | W15 | PDR |  | SC | PIM | P07 | PDR | OP1 | PDR FIX | MKG | TP | BS | KK | MAS | SMS | GI | SMB | MCP | PCB | PIC | AM | MT | HMJ | CP | PKW | SKA | PKL | PVJ | DPM | DMB | SPM | MCD | PAJ | BWB
Model SKU | Category | Sub Category | Launch | Launch-1 | solddate | Begin Price | Price | Theme | Sales Last Month | Stock Total | TRANSIT | RETUR | Disc | Sum of P01 | Sum of P02 | Sum of P07 | Sum of PDR | Sum of OP1 | Sum of PDR FIX | Sum of W02 | Sum of W06 | Sum of W07 | Sum of W08 | Sum of W10 | Sum of W11 | Sum of W12 | Sum of W14 | Sum of W15 | Sum of W17 | Sum of W18 | Sum of W19 | Sum of W20 | Sum of W21 | Sum of W22 | Sum of W24 | Sum of W25 | Sum of W26 | Sum of W27 | Sum of W28 | Sum of W29 | Sum of W30 | Sum of W31 | Sum of W34 | Sum of W35 | Total | DISPLAYED (Launch) | NOT YET DISPLAY (LEWAT LAUNCH) | NOT YET DISPLAY (MASUK LAUNCH) |  |  | Disc | P01 | P02 | P07 | PDR | W02 | W06 | W07 | W08 | W10 | W11 | W12 | W14 | W15 | W17 | W18 | W19 | W20 | W21 | [NAME] | W24 | W25 | W26 | [NAME] | W28 | W29 | W30 | W31 | [NAME] | W35 | Total | DISPLAYED | NOT YET DISPLAY (LEWAT) | NOT YET DISPLAY (MASIH MASUK)
[NAME] | PMSHOES | MENSPORT | 2018 L7 | Atrium | 2019-03-20 00:00:00 | 1399000 | 419000 | 0 | 0 | 0 | 0 | 0 | 70 | 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 | 0 | 0 | 0 | 0 | [NAME] | MENSPORT70 | 70 | 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 | 0 | 0 | [NAME] | MENSPORT70
[NAME] | PMSHOES | MENSPORT | 2019 L6 | Atrium | 2019-08-02 00:00:00 | 1399000 | 399000 | 0 | 0 | 0 | 0 | 0 | 70 | 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 | 0 | 0 | 0 | 0 | [NAME] | MENSPORT70 | 70 | 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 | 0 | 0 | [NAME] | MENSPORT70
PM176210126DWHT | PMSHOES | MENSPORT | 2019 L6 | Atrium | 2019-10-23 00:00:00 | 1349000 | 399000 | 0 | 1 | 0 | 0 | 0 | 70 | 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 | 0 | 0 | 0 | 0 | [NAME] | MENSPORT70 | 70 | 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 | 0 | 0 | [NAME] | MENSPORT70
PM176210126WHT | PMSHOES | MENSPORT | 2019 L6 | Atrium | 2019-10-23 00:00:00 | 1349000 | 399000 | 0 | 0 | 0 | 0 | 0 | 70 | 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 | 0 | 0 | 0 | 0 | [NAME] | MENSPORT70 | 70 | 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 | 0 | 0 | [NAME] | MENSPORT70
PM176210131RED | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2019-12-14 00:00:00 | 1299000 | 399000 | 0 | 13 | 9 | 0 | 0 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | [NAME] | MENSPORT70 | 70 | 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 | 1 | 0 | 0 | 0 | [NAME] | MENSPORT70
PM176210132BLK | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-04-02 00:00:00 | 1199000 | 479000 | 0 | 9 | 12 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | PMSHOES60 | MENSPORT60 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | PMSHOES60 | MENSPORT60
PM176210132DBLK | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-04-02 00:00:00 | 1199000 | 449000 | 0 | 0 | 2 | 0 | 0 | 60 | 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 | 0 | 2 | 0 | 0 | 0 | PMSHOES60 | MENSPORT60 | 60 | 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 | 0 | 1 | 0 | 0 | 0 | PMSHOES60 | MENSPORT60
PM176210132MGRN | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-04-02 00:00:00 | 1199000 | 479000 | 0 | 16 | 53 | 0 | 0 | 60 | 0 | 0 | 0 | 14 | 0 | 14 | 0 | 0 | 4 | 0 | 9 | 10 | 0 | 7 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 14 | 0 | 0 | PMSHOES60 | MENSPORT60 | 60 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | PMSHOES60 | MENSPORT60
PM176210133BLK | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-01-24 00:00:00 | 1299000 | 909000 | 0 | 1 | 11 | 0 | 0 | 30 | 0 | 0 | 0 | 9 | 0 | 9 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 9 | 0 | 0 | PMSHOES30 | MENSPORT30 | 30 | 0 | 0 | 0 | 1 | 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 | 1 | 1 | 0 | 0 | PMSHOES30 | MENSPORT30
PM176210135BLK | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-02-26 00:00:00 | 1399000 | 699000 | 0 | 6 | 1 | 0 | 0 | 50 | 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 | 1 | 0 | 0 | 0 | PMSHOES50 | [NAME] | 50 | 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 | 1 | 0 | 0 | 0 | PMSHOES50 | [NAME]
PM176210135DWHT | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2019-12-21 00:00:00 | 1399000 | 299000 | 0 | 0 | 1 | 0 | 0 | 80 | 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 | 0 | 1 | 0 | 0 | 0 | PMSHOES80 | MENSPORT80 | 80 | 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 | 0 | 1 | 0 | 0 | 0 | PMSHOES80 | MENSPORT80
PM176210135NVY | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-02-26 00:00:00 | 1399000 | 699000 | 0 | 2 | 5 | 0 | 0 | 50 | 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 | 5 | 0 | 0 | 0 | PMSHOES50 | [NAME] | 50 | 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 | 1 | 0 | 0 | 0 | PMSHOES50 | [NAME]
PM176210135WHT | PMSHOES | MENSPORT | 2019 L7 | Atrium | 2020-02-26 00:00:00 | 1399000 | 699000 | 0 | 1 | 6 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | PMSHOES50 | [NAME] | 50 | 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 | 1 | 0 | 0 | 0 | PMSHOES50 | [NAME]
PM176210138BLK | PMSHOES | MENSPORT | 2020 L2 | Atrium | 2020-06-15 00:00:00 | 1349000 | 939000 | 0 | 2 | 3 | 0 | 0 | 30 | 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 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | PMSHOES30 | MENSPORT30 | 30 | 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 | 0 | 1 | 0 | 0 | 0 | PMSHOES30 | MENSPORT30
PM176210138LGRY | PMSHOES | MENSPORT | 2020 L2 | Atrium | 2020-06-15 00:00:00 | 1349000 | 939000 | 0 | 0 | 2 | 0 | 0 | 30 | 0 | 0 | 0 | 1 | 0 | 1 | 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 | 3 | 1 | 0 | 0 | PMSHOES30 | MENSPORT30 | 30 | 0 | 0 | 0 | 1 | 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 | 1 | 1 | 0 | 0 | PMSHOES30 | MENSPORT30
PM176210138WHT | PMSHOES | MENSPORT | 2020 L2 | Atrium | 2020-06-15 00:00:00 | 1349000 | 939000 | 0 | 0 | 3 | 0 | 0 | 30 | 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 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | PMSHOES30 | MENSPORT30 | 30 | 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 | 0 | 1 | 0 | 0 | 0 | PMSHOES30 | MENSPORT30
PM176210141BLK | PMSHOES | MENSPORT | 2020 L2 | Atrium | 2020-02-07 00:00:00 | 1399000 | 559000 | 0 | 12 | 11 | 0 | 0 | 60 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 3 | 0 | 0 | PMSHOES60 | MENSPORT60 | 60 | 0 | 0 | 0 | 1 | 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 | 1 | 1 | 0 | 0 | PMSHOES60 | MENSPORT60