Spreadsheet: 683530d1592814796-sum-ifs-using-week-numbers-wk
Sheet: Sheet2

 |  |  | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47
 |  |  | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00
Part no. | Description 1 | Description 2 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00 | 2020-10-02 00:00:00 | 2020-10-09 00:00:00 | 2020-10-16 00:00:00 | 2020-10-23 00:00:00 | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
32806300 | STRA205     BLACK | DAIMLER STAR | 0 | 0 | 220 | 0 | 0 | 50 | 220 | 0 | 0 | 0 | 220
32806320 | STRA205     CAVANSIT BLU | DAIMLER STAR | 22 | 22 | 0 | 22 | 22 | 22 | 132 | 0 | 0 | 0 | 88
32806400 | STRA205     DIAMOND W'TE | DAIMLER STAR | 0 | 0 | 0 | 220 | 0 | 0 | 220 | 0 | 0 | 0 | 220
32806410 | STRA205     BRILLIANT BL | DAIMLER STAR | 0 | 22 | 22 | 44 | 0 | 22 | 176 | 0 | 66 | 0 | 132
32806470 | STRA205     SELENIT GREY | DAIMLER STAR | 0 | 220 | 0 | 0 | 0 | 220 | 440 | 66 | 0 | 0 | 220
32806750 | STRAKIT 205 PRIMER GREY | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22
32806810 | STRA205     MB7831 GRAPH | DAIMLER STAR | 66 | 0 | 22 | 66 | 0 | 66 | 198 | 0 | 0 | 0 | 132
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL205STR |  | 88 | 264 | 264 | 352 | 22 | 380 | 1386 | 66 | 66 | 0 | 1034
14538401 | 405 COV BRIGHT CHROME | JLR HANDLE COVER BRI | 120 | 80 | 280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405HDL |  | 120 | 80 | 280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533230 | DAI*LHG 211 BRILLIANT SI | DAIMLER Cust. Huf D | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533270 | DAI*LHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
15533470 | DAI*LHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0
15533490 | DAI*RHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
15533510 | DAI*LHG 211 TANSANITE BL | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
15533830 | DAI*LHG 211 CUBANITE SIL | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0
15534230 | [NAME] 211 BRILLIANT SI | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
15568610 | [NAME] 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15573730 | DAI*LHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
15573750 | DAI*RHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15681431 | DAI*LHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0
15681451 | DAI*RHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0
15685731 | DAI*RHG 221 PRIMER KG | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0
60034962 | DAI*LHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
60034963 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
60034978 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEDAI |  | 100 | 80 | 20 | 0 | 40 | 80 | 100 | 20 | 20 | 100 | 0
8235602 | VTB KEY HEAD HOUSING | VOLVO TRUCK & BUS | 1500 | 1500 | 2000 | 1000 | 1500 | 1500 | 2000 | 1500 | 1000 | 1000 | 2000
36204205 | COV     PLASTIC COVER |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 0
68106001 | HUF MOULD+BLANK (DH KEY) | VOLVO TRUCK & BUS | 0 | 500 | 0 | 500 | 0 | 1000 | 500 | 0 | 0 | 500 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 1500 | 2000 | 2000 | 1500 | 1500 | 2500 | 2500 | 2500 | 1000 | 1500 | 2000
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp |  | 1808 | 2424 | 2564 | 1852 | 1562 | 2960 | 3986 | 2586 | 1086 | 1600 | 3034
15093003 | BMW RAHMEN RHF | BMW SPARES E36 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1905-02-22 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL010 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1905-02-22 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E34/36 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1905-02-22 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | Sum |  | 1808 | 2424 | 2564 | 1852 | 1562 | 2960 | 3986 | 4466 | 1086 | 1600 | 3034
 | Sum Total |  | 1808 | 2424 | 2564 | 1852 | 1562 | 2960 | 3986 | 4466 | 1086 | 1600 | 3034
hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 2 | 2020-06-02 00:00:00
Page: | 2 | APT L | imited |  |  |  |  | Time: 0 | 08:29:31
 |  |  | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00
Part no. | Description 1 | Description 2 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00 | 2020-10-02 00:00:00 | 2020-10-09 00:00:00 | 2020-10-16 00:00:00 | 2020-10-23 00:00:00 | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
67402235 | E8xALHG  CA MINERAL GREY | Huf D NON-CONDUCTIVE | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL025 |  | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14095460 | E89ALHL OCA ALPINE WHITE | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
14095520 | E89ALHL OCA BLK SAPPHIRE | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
14204180 | E89ALHL OCA MINERALWHITE | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE89 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E89 HDL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0
14258501 | 405 LHL BRIGHT CHROME | JLR CAP BRI | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405LHL |  | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp JLR L538 |  | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15410902 | L30 FRT     BRUNEL | JLR L322 LOCKING CAP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL30 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
14469301 | 405 COV NARVIK BLACK | JLR HANDLE COVER NAR | 760 | 1640 | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14469401 | 405 COV SHADOW ATLAS | JLR HANDLE COVER SHA | 560 | 1320 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14818301 | 405 COV BRIGHT ATLAS | JLR HANDLE COVER ATL | 880 | 1160 | 1600 | 440 | 360 | 360 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405HDL |  | 2200 | 4120 | 4000 | 440 | 360 | 360 | 0 | 0 | 0 | 0 | 0
13015101 | 405 LHL NARVIK BLACK | JLR CAP NAR | 160 | 120 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13015201 | 405 LHL SHADOW ATLAS | JLR CAP SHA | 80 | 40 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14818201 | 405 LHL BRIGHT ATLAS | JLR CAP ATL | 160 | 80 | 400 | 120 | 80 | 40 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405LHL |  | 400 | 240 | 1160 | 120 | 80 | 40 | 00:00:00 | 0 | 0 | 0 | 0
13015501 | 405 N/L NARVIK BLACK | JLR CAP NAR | 560 | 440 | 1920 | 0 | 0 | 0 | 00:00:00 | 0 | 0 | 0 | 0
13015701 | 405 N/L SHADOW ATLAS | JLR CAP SHA | 1901-02-03 00:00:00 | 1900-10-06 00:00:00 | 1903-12-10 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
14818501 | 405 N/L BRIGHT ATLAS | JLR CAP ATL | 1901-08-22 00:00:00 | 1901-03-15 00:00:00 | 1903-07-03 00:00:00 | 1900-11-15 00:00:00 | 1900-11-15 00:00:00 | 1900-06-08 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405NL |  | 1560 | 1160 | 4640 | 320 | 320 | 160 | 00:00:00 | 0 | 0 | 0 | 0
 | Sum |  | 4160 | 5544 | 9840 | 880 | 760 | 560 | 0 | 20 | 0 | 60 | 0
 | Sum Total |  | 5968 | 7968 | 12404 | 2732 | 2322 | 3520 | 3986 | 4486 | 1086 | 1660 | 3034
hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 2 | 2020-06-02 00:00:00
Page: | 3 | APT L | imited |  |  |  |  | Time: 0 | 08:29:31
 |  |  | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00
Part no. | Description 1 | Description 2 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00 | 2020-10-02 00:00:00 | 2020-10-09 00:00:00 | 2020-10-16 00:00:00 | 2020-10-23 00:00:00 | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
13015401 | 405 RHL SHADOW ATLAS | JLR CAP SHA | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14818401 | 405 RHL BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405RHL |  | 0 | 0 | 80 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp L405 |  | 4160 | 5520 | 9880 | 880 | 840 | 560 | 0 | 0 | 0 | 0 | 0
66001198 | F01 RHL CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
66001199 | F01 RHN CA  GLACIER SILV | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0
66001201 | F01 RHN CA  IMPERIAL BLU | BMW L6 DOOR SET | 20 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001202 | F01 LHL CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20 | 0
66001203 | F01 RHN CA  SPACE GREY | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0
66001204 | F01 LHL CA  SPACE GREY | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0
66001205 | F01 LHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0
66001224 | F01 RHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0
66001226 | F01 LHL CA  SOPHISTO GRE | BMW L6 DOOR SET | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20
66001241 | F01 LHN CA  ORION SILVER | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 20 | 00:00:00 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEF01 |  | 40 | 80 | 20 | 20 | 60 | 140 | 20 | 20 | 20 | 100 | 40
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 40 | 80 | 20 | 20 | 60 | 140 | 20 | 20 | 20 | 100 | 40
8235710 | VTB KEY OVERMOULD | VOLVO TRUCK & BUS | 0 | 1600 | 1600 | 1600 | 1600 | 1600 | 3200 | 0 | 1600 | 0 | 3200
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 0 | 1600 | 1600 | 1600 | 1600 | 1600 | 3200 | 0 | 1600 | 0 | 3200
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp VOLVO LS |  | 0 | 1600 | 1600 | 1600 | 1600 | 1600 | 3200 | 0 | 1600 | 0 | 3200
14268320 | 204ALHL     DIAMANT SILV | BR204 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group OM03 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
68970031 | 204=LHL     OBSIDIAN BLK | BR204 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80
68970051 | 204=LHL     IRIDIUM SILV | BR204 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE204 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp W204 |  | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 0 | 20 | 0 | 100
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Total |  | 1916-06-12 00:00:00 | 1926-05-31 00:00:00 | 1938-08-12 00:00:00 | 1911-11-30 00:00:00 | 1911-02-13 00:00:00 | 1914-05-26 00:00:00 | 1919-09-23 00:00:00 | 1912-05-02 00:00:00 | 1907-06-18 00:00:00 | 1904-10-25 00:00:00 | 1917-06-13 00:00:00