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

 |  |  | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
 |  |  | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00
Part no. | Description 1 | Description 2 | 2020-06-26 00:00:00 | 2020-07-03 00:00:00 | 2020-07-10 00:00:00 | 2020-07-17 00:00:00 | 2020-07-24 00:00:00 | 2020-07-31 00:00:00 | 2020-08-07 00:00:00 | 2020-08-14 00:00:00 | 2020-08-21 00:00:00 | 2020-08-28 00:00:00 | 2020-09-04 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
32806300 | STRA205     BLACK | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 0 | 0
32806320 | STRA205     CAVANSIT BLU | DAIMLER STAR | 0 | 0 | 0 | 22 | 22 | 0 | 0 | 44 | 44 | 22 | 44
32806350 | STRA205     POLAR WHITE | DAIMLER STAR | 220 | 220 | 220 | 220 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32806410 | STRA205     BRILLIANT BL | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44 | 44 | 44
32806470 | STRA205     SELENIT GREY | DAIMLER STAR | 0 | 220 | 0 | 0 | 220 | 0 | 0 | 0 | 0 | 220 | 0
32806750 | STRAKIT 205 PRIMER GREY | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 0 | 0
32806810 | STRA205     MB7831 GRAPH | DAIMLER STAR | 132 | 66 | 66 | 0 | 66 | 0 | 0 | 0 | 66 | 66 | 66
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL205STR |  | 352 | 506 | 286 | 242 | 308 | 0 | 0 | 44 | 244 | 352 | 154
14538401 | 405 COV BRIGHT CHROME | JLR HANDLE COVER BRI | 0 | 0 | 0 | 0 | 0 | 120 | 120 | 120 | 40 | 200 | 120
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405HDL |  | 0 | 0 | 0 | 0 | 0 | 120 | 120 | 120 | 40 | 200 | 120
15533270 | DAI*LHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 40
15533470 | DAI*LHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 40
15533510 | DAI*LHG 211 TANSANITE BL | DAIMLER Cust. Huf D | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533830 | DAI*LHG 211 CUBANITE SIL | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
15536450 | DAI*LHG 220 BRILLIANT SI | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
15536610 | DAI*LHG 220 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
15536630 | DAI*RHG 220 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15573730 | DAI*LHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
15602950 | [NAME] TAG PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0
15681431 | DAI*LHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEDAI |  | 20 | 20 | 0 | 20 | 20 | 40 | 20 | 40 | 0 | 20 | 100
15456212 | POR*GRP     BLACK LINE | PORSCHE Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEPOR |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40
8235602 | VTB KEY HEAD HOUSING | VOLVO TRUCK & BUS | 0 | 0 | 0 | 1000 | 2500 | 500 | 1500 | 1500 | 1500 | 2000 | 1500
68106001 | HUF MOULD+BLANK (DH KEY) | VOLVO TRUCK & BUS | 500 | 0 | 0 | 0 | 0 | 500 | 500 | 0 | 500 | 500 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 500 | 0 | 0 | 1000 | 2500 | 1000 | 2000 | 1500 | 2000 | 2500 | 1500
15484402 | VW *GRP VT  PRIMER SCH'E | VW Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVW |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp |  | 872 | 526 | 286 | 1262 | 2828 | 1160 | 00:00:00 | 1704 | 2284 | 3092 | 1914
15268100 | [NAME]  -4 PRIMER BLACK | E46/4 | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group BM104 |  | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 | Sum |  | 2020-05-21 00:00:00 | 2020-06-09 00:00:00 | 2020-10-12 00:00:00 | 2020-06-15 00:00:00 | 2020-09-28 00:00:00 | 2020-10-31 00:00:00 | 00:00:00 | 2020-08-30 00:00:00 | 2020-04-02 00:00:00 | 2020-06-18 00:00:00 | 2020-03-28 00:00:00
 | Sum Total |  | 872 | 526 | 286 | 1262 | 2828 | 1400 | 2140 | 1704 | 2284 | 3092 | 1914
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:17:26
Part no. | Description 1 | Description 2 | 2020-06-26 00:00:00 | 2020-07-03 00:00:00 | 2020-07-10 00:00:00 | 2020-07-17 00:00:00 | 2020-07-24 00:00:00 | 2020-07-31 00:00:00 | 2020-08-07 00:00:00 | 2020-08-14 00:00:00 | 2020-08-21 00:00:00 | 2020-08-28 00:00:00 | 2020-09-04 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 0 | 0 | 0 | 0
14077640 | E89ALHL OVT ALPINE WHITE | E89 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
14095520 | E89ALHL OCA BLK SAPPHIRE | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE89 |  | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E89 HDL |  | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0
14258501 | 405 LHL BRIGHT CHROME | JLR CAP BRI | 0 | 0 | 0 | 0 | 80 | 0 | 40 | 0 | 0 | 80 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405LHL |  | 0 | 0 | 0 | 0 | 80 | 0 | 40 | 0 | 0 | 80 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp JLR L538 |  | 0 | 0 | 0 | 0 | 80 | 0 | 40 | 0 | 0 | 80 | 0
15410902 | L30 FRT     BRUNEL | JLR L322 LOCKING CAP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL30 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
14469301 | 405 COV NARVIK BLACK | JLR HANDLE COVER NAR | 0 | 0 | 0 | 0 | 0 | 0 | 280 | 1040 | 400 | 1280 | 760
14469401 | 405 COV SHADOW ATLAS | JLR HANDLE COVER SHA | 0 | 240 | 200 | 0 | 840 | 1200 | 760 | 760 | 280 | 960 | 640
14818301 | 405 COV BRIGHT ATLAS | JLR HANDLE COVER ATL | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 680 | 480 | 1360 | 960
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405HDL |  | 0 | 240 | 200 | 0 | 840 | 1200 | 1080 | 2480 | 1160 | 3600 | 2360
13015101 | 405 LHL NARVIK BLACK | JLR CAP NAR | 0 | 0 | 0 | 0 | 0 | 0 | 120 | 160 | 0 | 360 | 200
13015201 | 405 LHL SHADOW ATLAS | JLR CAP SHA | 0 | 160 | 40 | 0 | 120 | 360 | 80 | 160 | 0 | 240 | 120
14818201 | 405 LHL BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 160
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405LHL |  | 0 | 160 | 40 | 0 | 120 | 360 | 200 | 320 | 0 | 600 | 480
13015501 | 405 N/L NARVIK BLACK | JLR CAP NAR | 0 | 0 | 0 | 0 | 0 | 680 | 800 | 840 | 240 | 1120 | 560
13015701 | 405 N/L SHADOW ATLAS | JLR CAP SHA | 0 | 0 | 120 | 0 | 360 | 1240 | 520 | 560 | 200 | 800 | 360
14818501 | 405 N/L BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 680
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405NL |  | 0 | 0 | 120 | 0 | 360 | 1920 | 1320 | 1400 | 440 | 2320 | 1600
13015401 | 405 RHL SHADOW ATLAS | JLR CAP SHA | 0 | 0 | 0 | 0 | 40 | 120 | 0 | 40 | 0 | 40 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405RHL |  | 0 | 0 | 0 | 0 | 40 | 120 | 00/01/1900 | 40 | 0 | 40 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp L405 |  | 00-Jan | 2020-02-03 00:00:00 | 2020-12-25 00:00:00 | 00-Jan | 2020-09-21 00:00:00 | 2020-11-08 00:00:00 | 2020-02-12 00:00:00 | 2020-08-10 00:00:00 | 2020-05-18 00:00:00 | 2020-12-16 00:00:00 | 2020-02-26 00:00:00
 | Sum |  | 00-Jan | 2020-02-03 00:00:00 | 2020-12-25 00:00:00 | 00-Jan | 2020-12-30 00:00:00 | 2020-11-08 00:00:00 | 2020-03-24 00:00:00 | 2020-08-10 00:00:00 | 2020-06-27 00:00:00 | 2020-03-06 00:00:00 | 2020-02-26 00:00:00
 | Sum Total |  | 872 | 926 | 646 | 1262 | 4288 | 5000 | 00:00:00 | 5944 | 3924 | 9732 | 6354
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:17:26
 |  |  | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00
Part no. | Description 1 | Description 2 | 2020-06-26 00:00:00 | 2020-07-03 00:00:00 | 2020-07-10 00:00:00 | 2020-07-17 00:00:00 | 2020-07-24 00:00:00 | 2020-07-31 00:00:00 | 2020-08-07 00:00:00 | 2020-08-14 00:00:00 | 2020-08-21 00:00:00 | 2020-08-28 00:00:00 | 2020-09-04 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
66001197 | F01 LHL CA  DEEPSEA BLUE | BMW L6 DOOR SET | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
66001199 | F01 RHN CA  GLACIER SILV | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
66001201 | F01 RHN CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
66001202 | F01 LHL CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001203 | F01 RHN CA  SPACE GREY | BMW L6 DOOR SET | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0
66001204 | F01 LHL CA  SPACE GREY | BMW L6 DOOR SET | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0
66001205 | F01 LHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0
66001224 | F01 RHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20
66001226 | F01 LHL CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEF01 |  | 100 | 40 | 20 | 20 | 100 | 40 | 40 | 20 | 80 | 20 | 40
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 100 | 40 | 20 | 20 | 100 | 40 | 40 | 20 | 80 | 20 | 40
8235710 | VTB KEY OVERMOULD | VOLVO TRUCK & BUS | 0 | 0 | 0 | 1600 | 1600 | 1600 | 0 | 1600 | 1600 | 1600 | 3200
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 0 | 0 | 0 | 1600 | 1600 | 00:00:00 | 00/01/1900 | 1600 | 1600 | 1600 | 3200
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp VOLVO LS |  | 0 | 0 | 0 | 1600 | 1600 | 1600 | 0 | 1600 | 1600 | 1600 | 3200
68970031 | 204=LHL     OBSIDIAN BLK | BR204 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE204 |  | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp W204 |  | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Total |  | 1052 | 966 | 666 | 2882 | 5988 | 6640 | 4820 | 7564 | 5604 | 11352 | 9674