Spreadsheet: 686595d1594705677-sum-product-bassed-on-a-month-criteria-test
Sheet: Sheet1

hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 1 | 2020-07-03 00:00:00
Page: | 1 | APT L | imited |  |  |  |  | Time: 1 | 01:53:31
 |  |  | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2020-01-04 00:00:00 | 2020-01-11 00:00:00 | 2020-01-18 00:00:00 | 2020-01-25 00:00:00 | 2020-02-01 00:00:00 | 2020-02-08 00:00:00 | 2020-02-15 00:00:00 | 2020-02-22 00:00:00
Part no. | Description 1 | Description 2 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2020-01-01 00:00:00 | 2020-01-08 00:00:00 | 2020-01-15 00:00:00 | 2020-01-22 00:00:00 | 2020-01-29 00:00:00 | 2020-02-05 00:00:00 | 2020-02-12 00:00:00 | 2020-02-19 00:00:00 | 2020-02-26 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
43023506 | BMW WINDOW ROLLER | BMW WINDOW LATCH | 0 | 0 | 0 | 20000 | 0 | 0 | 0 | 10000 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group ESBMW |  | 0 | 0 | 0 | 20000 | 0 | 0 | 0 | 10000 | 0 | 0 | 0
32806300 | STRA205     BLACK | DAIMLER STAR | 220 | 0 | 0 | 0 | 0 | 156 | 0 | 0 | 50 | 0 | 0
32806310 | STRA205     OBSIDIAN BLK | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 330 | 0 | 0 | 0 | 198 | 0
32806320 | STRA205     CAVANSIT BLU | DAIMLER STAR | 110 | 0 | 0 | 0 | 0 | 132 | 0 | 0 | 0 | 44 | 0
32806350 | STRA205     POLAR WHITE | DAIMLER STAR | 1144 | 0 | 0 | 0 | 0 | 902 | 0 | 0 | 0 | 682 | 0
32806400 | STRA205     DIAMOND W'TE | DAIMLER STAR | 220 | 0 | 0 | 0 | 0 | 220 | 0 | 0 | 0 | 44 | 0
32806410 | STRA205     BRILLIANT BL | DAIMLER STAR | 198 | 0 | 0 | 0 | 0 | 198 | 0 | 0 | 0 | 88 | 0
32806470 | STRA205     SELENIT GREY | DAIMLER STAR | 506 | 0 | 0 | 0 | 0 | 440 | 0 | 0 | 0 | 154 | 0
32806750 | STRAKIT 205 PRIMER GREY | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44 | 0
32806810 | STRA205     GRAPHIT GREY | DAIMLER STAR | 132 | 0 | 0 | 0 | 0 | 132 | 0 | 0 | 0 | 66 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL205STR |  | 2530 | 0 | 0 | 0 | 0 | 2510 | 0 | 0 | 50 | 1320 | 0
32806670 | STRA292     SELENIT GREY | DAIMLER STAR | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE292STR |  | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533230 | DAI*LHG 211 BRILLIANT SI | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533270 | DAI*LHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0
15533290 | DAI*RHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
15533470 | DAI*LHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0
15535150 | DAI*LHG 220 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
15535170 | DAI*RHG 220 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
15568610 | [NAME] 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0
15573730 | DAI*LHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20
15681431 | DAI*LHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0
15684530 | DAI*LH  221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
15685731 | DAI*RHG 221 PRIMER KG | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
15864971 | DAI*LHG 221 PALLADIUM SI | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
60034962 | DAI*LHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0
60034963 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
67402893 | DAI*LH      PRIMER FOND | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 140 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEDAI |  | 0 | 0 | 80 | 0 | 60 | 160 | 80 | 80 | 60 | 40 | 20
15536470 | DAI*RHG 220 BRILLANT SIL | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL013 |  | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
15456212 | POR*GRP     BLACK LINE | PORSCHE Cust. Huf D | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEPOR |  | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8235602 | VTB KEY HEAD HOUSING | VOLVO TRUCK & BUS | 0 | 0 | 1000 | 1500 | 1000 | 1000 | 1000 | 1000 | 500 | 0 | 500
 | Sum |  | 2552 | 0 | 1080 | 21520 | 1080 | 3670 | 1080 | 11080 | 610 | 1360 | 520
 | Sum Total |  | 2552 | 0 | 1080 | 21520 | 1080 | 3670 | 1080 | 11080 | 610 | 1360 | 520
hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 1 | 2020-07-03 00:00:00
Page: | 2 | APT L | imited |  |  |  |  | Time: 1 | 01:53:32
 |  |  | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2020-01-04 00:00:00 | 2020-01-11 00:00:00 | 2020-01-18 00:00:00 | 2020-01-25 00:00:00 | 2020-02-01 00:00:00 | 2020-02-08 00:00:00 | 2020-02-15 00:00:00 | 2020-02-22 00:00:00
Part no. | Description 1 | Description 2 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2020-01-01 00:00:00 | 2020-01-08 00:00:00 | 2020-01-15 00:00:00 | 2020-01-22 00:00:00 | 2020-01-29 00:00:00 | 2020-02-05 00:00:00 | 2020-02-12 00:00:00 | 2020-02-19 00:00:00 | 2020-02-26 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
36204205 | COV     PLASTIC COVER |  | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 0 | 0
68106001 | HUF MOULD+BLANK (DH KEY) | VOLVO TRUCK & BUS | 0 | 0 | 500 | 500 | 500 | 0 | 1000 | 500 | 0 | 0 | 500
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 0 | 0 | 1500 | 2000 | 1500 | 1000 | 3000 | 1500 | 500 | 0 | 1000
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp |  | 2552 | 0 | 1580 | 22020 | 1580 | 3670 | 3080 | 11580 | 610 | 1360 | 1020
15093003 | BMW RAHMEN RHF | BMW SPARES E36 | 0 | 0 | 0 | 0 | 1880 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL010 |  | 0 | 0 | 0 | 0 | 1880 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E34/36 |  | 0 | 0 | 0 | 0 | 1880 | 0 | 0 | 0 | 0 | 0 | 0
15268501 | E46ALHG  -4 PRIMER BLACK | E46/4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group BM102 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0
15268301 | E46PRHN  -4 PRIMER BLACK | E46/4 | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE46 |  | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 0 | 60 | 0
15718430 | E60ALHL CA  PRIMER.BLACK | E60 CA | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE46 |  | 00:00:00 | 00:00:00 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E60 CA |  | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14095520 | E89 LHL OCA BLK SAPPHIRE | BMW DOOR SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
14204680 | E89 LHL OCA MINERAL GREY | BMW DOOR SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE89 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E89 HDL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0
29117000 | E90ALHG SSG PRIMER GREY | E90 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE90 |  | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E90 HDL |  | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0
 | Sum |  | 0 | 0 | 500 | 660 | 2380 | 0 | 2400 | 540 | 0 | 60 | 500
 | Sum Total |  | 2552 | 0 | 1580 | 22180 | 3460 | 3670 | 3480 | 11620 | 610 | 1420 | 1020
hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 1 | 2020-07-03 00:00:00
Page: | 3 | APT L | imited |  |  |  |  | Time: 1 | 01:53:32
 |  |  | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2020-01-04 00:00:00 | 2020-01-11 00:00:00 | 2020-01-18 00:00:00 | 2020-01-25 00:00:00 | 2020-02-01 00:00:00 | 2020-02-08 00:00:00 | 2020-02-15 00:00:00 | 2020-02-22 00:00:00
Part no. | Description 1 | Description 2 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2020-01-01 00:00:00 | 2020-01-08 00:00:00 | 2020-01-15 00:00:00 | 2020-01-22 00:00:00 | 2020-01-29 00:00:00 | 2020-02-05 00:00:00 | 2020-02-12 00:00:00 | 2020-02-19 00:00:00 | 2020-02-26 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
15410604 | L30 RR      OBERON | JLR L322 NON-LOCK CAP | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
15410902 | L30 FRT     BRUNEL | JLR L322 LOCKING CAP | 00:00:00 | 00:00:00 | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
15447381 | L30PBWL     SANTORINI | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL30 |  | 0 | 0 | 0 | 20 | 0 | 0 | 20 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 0 | 20 | 0 | 0 | 20 | 0 | 20 | 0 | 0
66001199 | F01 RHN CA  GLACIER SILV | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
66001201 | F01 RHN CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20 | 0
66001202 | F01 LHL CA  IMPERIAL BLU | BMW L6 DOOR SET | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20 | 0 | 0
66001203 | F01 RHN CA  SPACE GREY | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0
66001204 | F01 LHL CA  SPACE GREY | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0
66001205 | F01 LHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20
66001224 | F01 RHN CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20
66001226 | F01 LHL CA  SOPHISTO GRE | BMW L6 DOOR SET | 0 | 0 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0
66001358 | F01 LHL CA  GLACIER SILV | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
66001364 | F01 LHN CA  SPACE GREY | BMW L6 DOOR SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0
66001373 | F01 LHN CA  TITAN SILVER | BMW L6 DOOR SET | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEF01 |  | 0 | 0 | 60 | 40 | 60 | 40 | 80 | 40 | 60 | 60 | 40
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 0 | 60 | 40 | 60 | 40 | 1900-03-20 00:00:00 | 40 | 60 | 60 | 40
8235710 | VTB KEY OVERMOULD | VOLVO TRUCK & BUS | 0 | 0 | 1600 | 1600 | 0 | 1600 | 1904-05-18 00:00:00 | 0 | 1600 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 0 | 0 | 1600 | 1600 | 0 | 1600 | 1600 | 0 | 1600 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp VOLVO LS |  | 0 | 0 | 1600 | 1600 | 0 | 1600 | 1600 | 0 | 1600 | 0 | 0
32806510 | STRA292     OBSIDIAN BLK | DAIMLER STAR | 0 | 0 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32806600 | STRA292     DIAMOND W'TE | DAIMLER STAR | 0 | 0 | 0 | 0 | 44 | 0 | 00:00:00 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE292STR |  | 0 | 0 | 110 | 0 | 44 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp W222 |  | 0 | 0 | 110 | 0 | 44 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Total |  | 2552 | 0 | 3350 | 23840 | 3564 | 5310 | 5180 | 11660 | 2290 | 1480 | 1060
 |  | End of | Report
hfrmxx2.p | 1.7 | 22.23 Huf Gross R | eqs. Summ | ary [NAME]. |  |  |  | Date: 1 | 2020-07-03 00:00:00
Page: | 4 | APT L | imited |  |  |  |  | Time: 1 | 01:53:32
[NAME] | iteria:                        R | eport Submitted By: | [NAME]
 | Order: | To:
I | tem Number: | To:
De | sign Group: | To:
 | Item Type: | To:
 | Group: | To:
 | Due Date: 12/12/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: