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

 |  |  | 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 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00
Part no. | Description 1 | Description 2 | 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 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
43023506 | BMW WINDOW ROLLER | BMW WINDOW LATCH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20000 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group ESBMW |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20000 | 0 | 0 | 0
32806300 | STRA205     BLACK | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 138 | 0 | 0 | 220 | 0 | 0
32806320 | STRA205     CAVANSIT BLU | DAIMLER STAR | 0 | 22 | 22 | 0 | 0 | 44 | 44 | 22 | 44 | 0 | 44
32806350 | STRA205     POLAR WHITE | DAIMLER STAR | 220 | 0 | 0 | 0 | 220 | 440 | 220 | 440 | 440 | 242 | 220
32806400 | STRA205     DIAMOND W'TE | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 0 | 0 | 0
32806410 | STRA205     BRILLIANT BL | DAIMLER STAR | 0 | 0 | 0 | 0 | 22 | 44 | 44 | 44 | 22 | 22 | 44
32806470 | STRA205     SELENIT GREY | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 220 | 0 | 0 | 0 | 0
32806750 | STRAKIT 205 PRIMER GREY | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66 | 0 | 0 | 0
32806810 | STRA205     GRAPHIT GREY | DAIMLER STAR | 0 | 0 | 0 | 0 | 0 | 44 | 0 | 132 | 0 | 0 | 66
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL205STR |  | 220 | 22 | 22 | 0 | 242 | 710 | 528 | 726 | 726 | 264 | 374
32806670 | STRA292     SELENIT GREY | DAIMLER STAR | 0 | 0 | 0 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE292STR |  | 0 | 0 | 0 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15533270 | DAI*LHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
15533470 | DAI*LHG 211 PRIMER GREY | DAIMLER Cust. Huf D | 0 | 20 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0
15533830 | DAI*LHG 211 CUBANITE SIL | DAIMLER Cust. Huf D | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15536610 | DAI*LHG 220 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0
15568610 | [NAME] 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
15573730 | DAI*LHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
15573750 | DAI*RHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0
15573770 | DAI*LHG 211 FLINT GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15602950 | [NAME] TAG PRIMER GREY | DAIMLER Cust. Huf D | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15681431 | DAI*LHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 0
60034963 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEDAI |  | 40 | 80 | 20 | 20 | 0 | 60 | 20 | 0 | 40 | 80 | 20
15456212 | POR*GRP     BLACK LINE | PORSCHE Cust. Huf D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEPOR |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0
8235602 | VTB KEY HEAD HOUSING | VOLVO TRUCK & BUS | 500 | 1000 | 1500 | 1500 | 500 | 2000 | 2000 | 1000 | 2500 | 2500 | 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 | 0 | 500 | 500 | 0 | 0 | 500 | 500 | 0 | 500 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 500 | 1000 | 2000 | 2000 | 500 | 2000 | 2500 | 2500 | 2500 | 3000 | 2000
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp |  | 760 | 1102 | 2042 | 2064 | 742 | 2770 | 3048 | 23266 | 3266 | 3344 | 2394
14077400 | E89 LHL     DEEPSEA BLUE | BMW DOOR SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0
 | Sum |  | 760 | 1102 | 2042 | 2064 | 742 | 2770 | 3048 | 23266 | 3286 | 3344 | 2394
 | Sum Total |  | 760 | 1102 | 2042 | 2064 | 742 | 2770 | 3048 | 23266 | 3286 | 3344 | 2394
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:25:25
 |  |  | 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 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00
Part no. | Description 1 | Description 2 | 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 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
14077640 | E89 LHL OVT ALPINE WHITE | BMW DOOR SET | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0
14095520 | E89 LHL OCA BLK SAPPHIRE | BMW DOOR SET | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEE89 |  | 0 | 0 | 0 | 0 | 20 | 20 | 0 | 0 | 20 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp E89 HDL |  | 0 | 0 | 0 | 0 | 20 | 20 | 0 | 0 | 20 | 0 | 0
15410902 | L30 FRT     BRUNEL | JLR L322 LOCKING CAP | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEL30 |  | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14469301 | 405 COV NARVIK BLACK | JLR HANDLE COVER NAR | 0 | 0 | 0 | 0 | 920 | 1000 | 920 | 40 | 0 | 2520 | 1440
14469401 | 405 COV SHADOW ATLAS | JLR HANDLE COVER SHA | 40 | 80 | 200 | 560 | 440 | 760 | 480 | 240 | 200 | 1160 | 1040
14538401 | 405 COV BRIGHT CHROME | JLR HANDLE COVER BRI | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 280 | 200
14818301 | 405 COV BRIGHT ATLAS | JLR HANDLE COVER ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1400 | 1400
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405HDL |  | 40 | 80 | 200 | 560 | 1360 | 1760 | 1440 | 280 | 200 | 5360 | 4080
13015101 | 405 LHL NARVIK BLACK | JLR CAP NAR | 0 | 0 | 0 | 120 | 200 | 320 | 160 | 0 | 0 | 440 | 320
13015201 | 405 LHL SHADOW ATLAS | JLR CAP SHA | 0 | 40 | 80 | 160 | 40 | 120 | 80 | 0 | 0 | 280 | 240
14258501 | 405 LHL BRIGHT CHROME | JLR CAP BRI | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 40 | 40
14818201 | 405 LHL BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 160
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405LHL |  | 00:00:00 | 1900-02-09 00:00:00 | 80 | 280 | 240 | 440 | 280 | 0 | 0 | 760 | 760
13015501 | 405 N/L NARVIK BLACK | JLR CAP NAR | 00:00:00 | 00:00:00 | 240 | 840 | 720 | 840 | 560 | 0 | 0 | 1920 | 1240
13015701 | 405 N/L SHADOW ATLAS | JLR CAP SHA | 0 | 0 | 120 | 440 | 280 | 560 | 400 | 120 | 0 | 1080 | 800
14818501 | 405 N/L BRIGHT ATLAS | JLR CAP ATL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 440 | 1200
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405NL |  | 0 | 0 | 360 | 1280 | 1000 | 1400 | 960 | 120 | 0 | 3440 | 3240
13015401 | 405 RHL SHADOW ATLAS | JLR CAP SHA | 0 | 0 | 80 | 40 | 0 | 40 | 0 | 0 | 0 | 80 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group PL405RHL |  | 0 | 0 | 80 | 40 | 0 | 40 | 0 | 0 | 0 | 80 | 80
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp L405 |  | 40 | 120 | 720 | 2160 | 2600 | 3640 | 2680 | 400 | 200 | 9640 | 8160
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 | 20 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001203 | F01 RHN CA  SPACE GREY | BMW L6 DOOR SET | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20
66001204 | F01 LHL CA  SPACE GREY | BMW L6 DOOR SET | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 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
 | Sum |  | 100 | 160 | 760 | 2180 | 2660 | 3680 | 2740 | 420 | 240 | 9640 | 8220
 | Sum Total |  | 860 | 1262 | 2802 | 4244 | 3402 | 6450 | 5788 | 23686 | 3526 | 12984 | 10614
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:25:25
 |  |  | 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 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00
Part no. | Description 1 | Description 2 | 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 | 2020-09-11 00:00:00 | 2020-09-18 00:00:00 | 2020-09-25 00:00:00
-------- | ------------------------------- | ------------------------ | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | ---------
66001226 | F01 LHL CA  SOPHISTO GRE | BMW L6 DOOR SET | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00 | 1900-01-20 00:00:00 | 00:00:00
66001358 | F01 LHL CA  GLACIER SILV | BMW L6 DOOR SET | 00:00:00 | 00:00:00 | 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
66001364 | F01 LHN CA  SPACE GREY | BMW L6 DOOR SET | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEF01 |  | 60 | 40 | 60 | 40 | 40 | 40 | 60 | 40 | 60 | 40 | 60
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | [NAME] |  | 60 | 40 | 60 | 40 | 40 | 40 | 60 | 40 | 60 | 40 | 60
8235710 | VTB KEY OVERMOULD | VOLVO TRUCK & BUS | 0 | 3200 | 1600 | 0 | 3200 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VEVOLKEY |  | 0 | 3200 | 1600 | 0 | 3200 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp VOLVO LS |  | 0 | 3200 | 1600 | 0 | 3200 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
32806600 | STRA292     DIAMOND W'TE | DAIMLER STAR | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Group VE292STR |  | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | DsnGp W222 |  | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -------------- |  | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | ------- | -------
 | Total |  | 860 | 4482 | 4422 | 4286 | 6602 | 8070 | 1920-03-23 00:00:00 | 25306 | 5146 | 14624 | 12214
 |  | 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:25:25
[NAME] | iteria:                        R | eport Submitted By: | [NAME]
 | Order: | To:
I | tem Number: | To:
De | sign Group: | To:
 | Item Type: | To:
 | Group: | To:
 | Due Date: 13/07/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: