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

hfrmxx2.p | 1.7 | 22.23 Huf Gross R | 48 | 49 | 50 | 51 | 52 | 53 | 1
 |  |  | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2020-01-04 00:00:00
Part no. | Description 1 | Description 2 | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2020-01-01 00:00:00 | 2020-01-08 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | ---------
32806300 | STRA205     BLACK | DAIMLER STAR | 0 | 0 | 0 | 220 | 0 | 0 | 0
32806310 | STRA205     OBSIDIAN BLK | DAIMLER STAR | 0 | 0 | 0 | 22 | 0 | 0 | 0
32806320 | STRA205     CAVANSIT BLU | DAIMLER STAR | 0 | 0 | 0 | 154 | 0 | 0 | 0
32806400 | STRA205     DIAMOND W'TE | DAIMLER STAR | 0 | 0 | 0 | 220 | 0 | 0 | 0
32806410 | STRA205     BRILLIANT BL | DAIMLER STAR | 0 | 0 | 0 | 242 | 0 | 0 | 0
32806470 | STRA205     SELENIT GREY | DAIMLER STAR | 0 | 0 | 0 | 660 | 0 | 0 | 0
32806810 | STRA205     MB7831 GRAPH | DAIMLER STAR | 0 | 0 | 0 | 198 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL205STR |  | 0 | 0 | 0 | 1716 | 0 | 0 | 0
15322501 | DAI*RHG LUX PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
15533230 | DAI*LHG 211 BRILLIANT SI | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533270 | DAI*LHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 40 | 0 | 0 | 0 | 0 | 0
15533290 | DAI*RHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533470 | DAI*LHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 40 | 0 | 0 | 0 | 0 | 0
15533490 | DAI*RHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0
15534270 | [NAME] 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
15535150 | DAI*LHG 220 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 20
15535170 | DAI*RHG 220 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
15536130 | DAI*LHG 220 BLACK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0
15536610 | DAI*LHG 220 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 20
15568610 | [NAME] 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0
15573730 | DAI*LHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
15573770 | DAI*LHG 211 FLINT GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0
15602950 | [NAME] TAG PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
15681431 | DAI*LHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 60 | 0 | 0 | 0 | 0
15681451 | DAI*RHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
15685731 | DAI*RHG 221 PRIMER KG | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0
60034962 | DAI*LHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 40 | 0 | 0 | 0 | 0
60034963 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D | 20 | 0 | 0 | 0 | 0 | 0 | 0
60034978 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 20 | 0 | 0 | 0 | 0 | 0
67402893 | DAI*LH      PRIMER FOND | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0
67402894 | DAI*RH      PRIMER FOND | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 160 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEDAI |  | 20 | 100 | 240 | 0 | 0 | 180 | 40
14205210 | E89ALHL OCA ESTORILBLAU2 | [NAME] | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE89 |  | 0 | 0 | 0 | 0 | 0 | 20 | 00:00:00
14061811 | DAI*LHG 221 BLK MAGNETIT | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL012 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
15681591 | DAI*LHG 221 CARNEOL RED | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL013 |  | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | Sum |  | 1900-01-20 00:00:00 | 1900-04-09 00:00:00 | 1900-08-27 00:00:00 | 1904-09-11 00:00:00 | 00:00:00 | 1900-08-07 00:00:00 | 1900-02-09 00:00:00
 | Sum Total |  | 20 | 100 | 240 | 1716 | 0 | 220 | 40
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:42:44
 |  |  | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2020-01-04 00:00:00
Part no. | Description 1 | Description 2 | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2020-01-01 00:00:00 | 2020-01-08 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | ---------
15456212 | POR*GRP     BLACK LINE | PORSCHE Cust. Huf D | 0 | 0 | 40 | 0 | 0 | 0 | 20
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEPOR |  | 0 | 0 | 40 | 0 | 0 | 0 | 20
8235602 | VTB KEY HEAD HOUSING | VOLVO TRUCK & BUS | 500 | 1000 | 2000 | 0 | 0 | 1000 | 1500
36204205 | COV     PLASTIC COVER |  | 0 | 0 | 0 | 0 | 0 | 0 | 1000
68106001 | HUF MOULD+BLANK (DH KEY) | VOLVO TRUCK & BUS | 1000 | 500 | 0 | 0 | 0 | 0 | 500
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 1500 | 1500 | 2000 | 0 | 0 | 1000 | 3000
15484402 | VW *GRP VT  PRIMER SCH'E | VW Cust. Huf D | 40 | 0 | 0 | 0 | 0 | 0 | 0
15484415 | VW *CAP LOC PRIMER GREY | VW Cust. Huf D | 40 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVW |  | 80 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp |  | 1600 | 1600 | 2280 | 1716 | 0 | 1220 | 3060
15268501 | E46ALHG  -4 PRIMER BLACK | E46/4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group BM102 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
15268100 | [NAME]  -4 PRIMER BLACK | E46/4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group BM104 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
15268301 | E46PRHN  -4 PRIMER BLACK | E46/4 | 0 | 0 | 0 | 0 | 0 | 0 | 260
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE46 |  | 0 | 0 | 0 | 0 | 0 | 0 | 260
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 260
14095290 | E89ARHN OCA ALPINE WHITE | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
14095520 | E89ALHL OCA BLK SAPPHIRE | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
14204680 | E89ALHL OCA MINERAL GREY | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE89 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E89 HDL |  | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00
29117000 | E90ALHG SSG PRIMER GREY | E90 | 0 | 0 | 0 | 0 | 0 | 160 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE90 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1900-06-08 00:00:00 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E90 HDL |  | 0 | 0 | 0 | 0 | 0 | 160 | 00:00:00
 | Sum |  | 1904-04-28 00:00:00 | 1904-02-08 00:00:00 | 1905-08-01 00:00:00 | 00:00:00 | 00:00:00 | 1903-03-05 00:00:00 | 1908-12-23 00:00:00
 | Sum Total |  | 1904-05-18 00:00:00 | 1904-05-18 00:00:00 | 1906-03-29 00:00:00 | 1904-09-11 00:00:00 | 00:00:00 | 1903-10-11 00:00:00 | 1909-02-01 00:00:00
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:42:45
 |  |  | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2020-01-04 00:00:00
Part no. | Description 1 | Description 2 | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2020-01-01 00:00:00 | 2020-01-08 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | ---------
15410902 | L30 FRT     BRUNEL | JLR L322 LOCKING CAP | 0 | 0 | 20 | 0 | 0 | 0 | 0
15410903 | L30 FRT     OBERON | JLR L322 LOCKING CAP | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL30 |  | 0 | 0 | 20 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 20 | 0 | 0 | 0 | 0
66001197 | F01 LHL CA  DEEPSEA BLUE | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 0
66001199 | F01 RHN CA  GLACIER SILV | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 0
66001201 | F01 RHN CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 0 | 20 | 0 | 0 | 0 | 0
66001202 | F01 LHL CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 0
66001203 | F01 RHN CA  SPACE GREY | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001204 | F01 LHL CA  SPACE GREY | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001205 | F01 LHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001224 | F01 RHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 20 | 20 | 0 | 20 | 0 | 0 | 20
66001226 | F01 LHL CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 40 | 0 | 0 | 0 | 20 | 0
66001232 | F01 RHL CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 20 | 0 | 0 | 0 | 0 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEF01 |  | 20 | 200 | 20 | 20 | 0 | 20 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 20 | 200 | 20 | 20 | 0 | 20 | 80
8235710 | VTB KEY OVERMOULD | VOLVO TRUCK & BUS | 0 | 1600 | 1600 | 0 | 0 | 1600 | 1600
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 0 | 1600 | 1600 | 0 | 0 | 1600 | 1600
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp VOLVO LS |  | 0 | 1600 | 1600 | 0 | 0 | 1600 | 1600
14280600 | 204*LHL KG  PRIMER GREY | 9999 BR204 KG DAIMLER | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE204 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp W204 |  | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00
32806500 | STRA292     BLACK | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE292STR |  | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp W222 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Total |  | 1620 | 3400 | 3920 | 1736 | 0 | 3000 | 1913-09-08 00:00:00
 |  | End of | Report
hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 2 | 2020-06-02 00:00:00
Page: | 4 | APT L | imited |  |  |  |  | Time: 0 | 08:42:45
[NAME] | iteria:                        R | eport Submitted By: | [NAME]
 | Order: | To:
I | tem Number: | To:
De | sign Group: | To:
 | Item Type: | To:
 | Group: | To:
 | Due Date: 21/11/20
Print z | ero values: no
Pric | e/Quantity: Quantity
 | Currency:
 | Interval: WEEKS
Customer | Items Only: yes
Sum | mary Level: 3 0 = None
 | 1 = Design Group
 | 2 = Group
 | 3 = [NAME]
 |  | Outpu | t: EMail
 |  | Batch I | D: