Spreadsheet: 702960d1604643431-sales-report-that-looks-start-dates-and-expired-dates-sales-test
Sheet: sALES 

Part | Description | Type | May | Jun | Jul | Aug | Sep | Oct | Nov | 2020 Sales
13015201 | 405 LHL SHADOW ATLAS | JLR COVERS | 0 | 0 | 600 | 600 | 1360 | 1520 | 320 | 4400
13015401 | 405 RHL SHADOW ATLAS | JLR COVERS | 0 | 40 | 0 | 360 | 40 | 160 | 0 | 600
14258501 | 405 LHL BRIGHT CHROME | JLR COVERS | 0 | 80 | 120 | 160 | 80 | 240 | 0 | 680
14469401 | 405 COV SHADOW ATLAS | JLR COVERS | 0 | 80 | 2480 | 2680 | 5520 | 8560 | 1920 | 21240
14258101 | 405 LHL SANTORINI BLACK | JLR COVERS | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 80
14258301 | 405 RHL SANTORINI BLACK | JLR COVERS | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 80
14469501 | 405 N/L SANTORINI BLACK | JLR COVERS | 0 | 0 | 160 | 0 | 0 | 0 | 0 | 160
14538301 | 405 COV SANTORINI BLACK | JLR COVERS | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 400
14538401 | 405 COV BRIGHT CHROME | JLR COVERS | 0 | 0 | 0 | 260 | 360 | 1040 | 120 | 1780
14258401 | 405 RHL NOBLE CHROME | JLR COVERS | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 40
13015701 | 405 N/L SHADOW ATLAS | JLR COVERS | 0 | 0 | 400 | 3880 | 3440 | 5480 | 1240 | 14440
14818301 | 405 COV BRIGHT ATLAS | JLR COVERS | 0 | 0 | 0 | 600 | 3400 | 6880 | 1760 | 12640
14818201 | 405 LHL BRIGHT ATLAS | JLR COVERS | 0 | 0 | 0 | 160 | 1000 | 640 | 160 | 1960
14818401 | 405 RHL BRIGHT ATLAS | JLR COVERS | 0 | 0 | 0 | 0 | 240 | 360 | 0 | 600
14818501 | 405 N/L BRIGHT ATLAS | JLR COVERS | 0 | 0 | 0 | 0 | 3240 | 5200 | 1400 | 9840
14469301 | 405 COV NARVIK BLACK | JLR COVERS | 0 | 0 | 0 | 5040 | 3840 | 10120 | 1080 | 20080
13015101 | 405 LHL NARVIK BLACK | JLR COVERS | 0 | 0 | 0 | 1160 | 600 | 2120 | 320 | 4200
13015501 | 405 N/L NARVIK BLACK | JLR COVERS | 0 | 0 | 680 | 4240 | 3560 | 5400 | 1320 | 15200
13015301 | 405 RHL NARVIK BLACK | JLR COVERS | 0 | 0 | 0 | 0 | 0 | 360 | 0 | 360
14469701 | 405 N/L BRIGHT CHROME | JLR COVERS | 0 | 0 | 0 | 0 | 0 | 240 | 240 | 480
14258701 | 405 RHL BRIGHT CHROME | JLR COVERS | 0 | 0 | 0 | 0 | 0 | 80 | 0 | 80
68931923 | 405 LHL PLATINUM ATLAS | JLR COVERS | 0 | 0 | 130 | 280 | 0 | 280 | 280 | 970
68931922 | 405 RHL PLATINUM ATLAS | JLR COVERS | 0 | 0 | 50 | 0 | 280 | 0 | 0 | 330
68931921 | 405 N/L PLATINUM ATLAS | JLR COVERS | 0 | 0 | 140 | 120 | 760 | 280 | 280 | 1580
68931920 | 405 COV PLATINUM ATLAS | JLR COVERS | 0 | 0 | 270 | 240 | 1000 | 500 | 260 | 2270
14040162 | AV ALHG     PRIMER GREY | OES | 0 | 20 | 20 | 0 | 0 | 27 | 0 | 67
14040172 | AV ARHG     PRIMER GREY | OES | 0 | 20 | 0 | 0 | 20 | 0 | 0 | 40
14040182 | AV ALHL     PRIMER GREY | OES | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20
14040231 | EL ARHG     PRIMER GREY | OES | 0 | 0 | 40 | 20 | 20 | 0 | 0 | 80
14095780 | E89 LHL OCA MELBOURNERED | OES | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20
15410604 | L30 RR      OBERON | OES | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 60
15410903 | L30 FRT     OBERON | OES | 0 | 20 | 0 | 0 | 0 | 40 | 0 | 60
15447371 | L30PBWL     PRIMER GREY | OES | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20
15707191 | EL ARHR     COSMOS BLACK | OES | 0 | 0 | 0 | 22 | 0 | 20 | 0 | 42
15533270 | DAI*LHG 211 OBSIDIAN BLK | OES | 0 | 0 | 80 | 0 | 0 | 116 | 0 | 196
15681431 | DAI*LHG 221 OBSIDIAN BLK | OES | 0 | 0 | 120 | 0 | 0 | 302 | 40 | 462
15533470 | DAI*LHG 211 PRIMER GREY | OES | 0 | 0 | 20 | 40 | 60 | 101 | 0 | 221
15573750 | DAI*RHG 211 IRIDIUM SILV | OES | 0 | 0 | 20 | 0 | 0 | 20 | 0 | 40
15573770 | DAI*LHG 211 FLINT GREY | OES | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
15602950 | [NAME] TAG PRIMER GREY | OES | 0 | 0 | 20 | 0 | 0 | 8 | 0 | 28
15533830 | DAI*LHG 211 CUBANITE SIL | OES | 0 | 0 | 20 | 0 | 0 | 26 | 0 | 46
15410902 | L30 FRT     BRUNEL | OES | 0 | 0 | 20 | 0 | 20 | 15 | 0 | 55
15447381 | L30PBWL     SANTORINI | OES | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 20
15484402 | VW *GRP VT  PRIMER SCH'E | OES | 0 | 40 | 0 | 0 | 0 | 20 | 0 | 60
15533490 | DAI*RHG 211 PRIMER GREY | OES | 20 | 0 | 0 | 0 | 0 | 80 | 0 | 100
15533510 | DAI*LHG 211 TANSANITE BL | OES | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
15536450 | DAI*LHG 220 BRILLIANT SI | OES | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 40
15536630 | DAI*RHG 220 OBSIDIAN BLK | OES | 0 | 0 | 20 | 0 | 0 | 12 | 0 | 32
15825750 | 204*RHL KGI PRIMER GREY | OES | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 40
32359503 | L.R. MICRO SWITCH HSG. | OES | 260 | 0 | 0 | 0 | 0 | 250 | 0 | 510
32630501 | L320 BOOT HOUSING | OES | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 250
66001197 | F01 LHL CA  DEEPSEA BLUE | OES | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
66001198 | F01 RHL CA  SOPHISTO GRE | OES | 0 | 0 | 20 | 0 | 0 | 40 | 0 | 60
66001199 | F01 RHN CA  GLACIER SILV | OES | 0 | 0 | 20 | 0 | 20 | 80 | 0 | 120
14268661 | 204ALHN     SELENIT GREY | OES | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20
15685731 | DAI*RHG 221 PRIMER GREY | OES | 0 | 0 | 0 | 80 | 20 | 24 | 0 | 124
15536130 | DAI*LHG 220 BLACK | OES | 0 | 0 | 0 | 20 | 0 | 14 | 0 | 34
14040251 | AV ARHR     PRIMER GREY | OES | 0 | 0 | 0 | 20 | 20 | 61 | 0 | 101
40026204 | PLUG LH X350 | OES | 0 | 0 | 0 | 200 | 0 | 0 | 0 | 200
66001201 | F01 RHN CA  IMPERIAL BLU | OES | 0 | 14 | 40 | 0 | 20 | 68 | 0 | 142
66001202 | F01 LHL CA  IMPERIAL BLU | OES | 0 | 20 | 40 | 0 | 20 | 65 | 0 | 145
66001203 | F01 RHN CA  SPACE GREY | OES | 0 | 20 | 40 | 20 | 0 | 180 | 0 | 260
66001204 | F01 LHL CA  SPACE GREY | OES | 0 | 20 | 40 | 18 | 22 | 180 | 0 | 280
15782302 | F01 LHN STD VIRGIN | OES | 0 | 0 | 1548 | 0 | 0 | 0 | 0 | 1548
66001205 | F01 LHN CA  SOPHISTO GRE | OES | 0 | 20 | 40 | 48 | 0 | 180 | 0 | 288
66001224 | F01 RHN CA  SOPHISTO GRE | OES | 0 | 40 | 60 | 40 | 40 | 320 | 0 | 500
66001226 | F01 LHL CA  SOPHISTO GRE | OES | 0 | 40 | 80 | 40 | 20 | 360 | 0 | 540
66001358 | F01 LHL CA  GLACIER SILV | OES | 0 | 0 | 20 | 0 | 20 | 60 | 0 | 100
66001360 | F01 LHL CA  JATOBA MET. | OES | 0 | 0 | 20 | 0 | 0 | 40 | 0 | 60
66001364 | F01 LHN CA  SPACE GREY | OES | 0 | 0 | 20 | 20 | 0 | 120 | 0 | 160
66001373 | F01 LHN CA  TITAN SILVER | OES | 0 | 0 | 20 | 0 | 0 | 80 | 0 | 100
66001239 | F01 LHN CA  GLACIER SILV | OES | 0 | 0 | 0 | 0 | 20 | 60 | 0 | 80
68970031 | 204=LHL     OBSIDIAN BLK | OES | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 80
32806740 | STRAKIT 292 PRIMER GREY | STARS | 0 | 44 | 0 | 0 | 44 | 22 | 0 | 110
32806320 | STRA205     CAVANSIT BLU | STARS | 0 | 0 | 418 | 110 | 154 | 352 | 0 | 1034
32630502 | L320 BLACK PUSH BUTTON | OES | 250 | 0 | 0 | 0 | 0 | 250 | 0 | 500
15097121 | E36 RR  RAHMEN LACQUER | OES | 0 | 0 | 0 | 0 | 1609 | 978 | 0 | 2587
32806540 | STRA292     PALLADIUM SI | STARS | 0 | 0 | 0 | 0 | 22 | 0 | 0 | 22
68970051 | 204=LHL     IRIDIUM SILV | OES | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 20
15685711 | DAI*LHG 221 PRIMER KG | OES | 0 | 0 | 0 | 0 | 134 | 0 | 0 | 134
60034963 | DAI*RHG 219 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 40 | 131 | 0 | 171
32806300 | STRA205     BLACK | STARS | 0 | 0 | 506 | 110 | 0 | 220 | 154 | 990
32806410 | STRA205     BRILLIANT BL | STARS | 0 | 0 | 308 | 110 | 110 | 110 | 220 | 858
32806400 | STRA205     DIAMOND W'TE | STARS | 0 | 0 | 242 | 0 | 0 | 352 | 198 | 792
32790201 | STR 205     [NAME] CAR'R | STARS | 0 | 0 | 900 | 0 | 0 | 900 | 0 | 1800
32806670 | STRA292     SELENIT GREY | STARS | 0 | 0 | 44 | 0 | 0 | 0 | 0 | 44
32806600 | STRA292     DIAMOND W'TE | STARS | 0 | 0 | 44 | 0 | 0 | 44 | 0 | 88
32790206 | 205       PLATE | STARS | 0 | 600 | 0 | 0 | 0 | 0 | 0 | 600
32806510 | STRA292     OBSIDIAN BLK | STARS | 0 | 0 | 0 | 88 | 0 | 110 | 0 | 198
43023506 | BMW WINDOW ROLLER | OES | 0 | 0 | 0 | 30000 | 10000 | 20000 | 30000 | 90000
66001241 | F01 LHN CA  ORION SILVER | OES | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 20
15456212 | POR*GRP     BLACK LINE | OES | 0 | 0 | 0 | 0 | 80 | 160 | 0 | 240
15536150 | DAI*RHG 220 BLACK | OES | 0 | 0 | 0 | 0 | 20 | 20 | 0 | 40
15533390 | DAI*LHG 211 BLACK | OES | 0 | 0 | 0 | 0 | 20 | 62 | 20 | 102
32790301 | STR 292     [NAME] CAR'R | STARS | 0 | 0 | 0 | 1000 | 0 | 0 | 0 | 1000
14040222 | AV ALHN     PRIMER GREY | OES | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 40
32806350 | STRA205     POLAR WHITE | STARS | 0 | 150 | 2640 | 748 | 770 | 836 | 264 | 5408
67402894 | DAI*RH  203 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 95 | 0 | 95
66001233 | F01 LHL CA  ORION SILVER | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
14077400 | E89 LHL     DEEPSEA BLUE | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
15825730 | 204*LHL KGI PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 60 | 0 | 60
15825810 | 204*RHN KGO PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 58 | 0 | 58
15268301 | E46PRHN  -4 PRIMER BLACK | OES | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 240
15533290 | DAI*RHG 211 OBSIDIAN BLK | OES | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 40
15533850 | DAI*RHG 211 CUBANITE SIL | OES | 0 | 0 | 0 | 0 | 0 | 20 | 20 | 40
15568610 | [NAME] 211 IRIDIUM SILV | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
15573730 | DAI*LHG 211 IRIDIUM SILV | OES | 0 | 0 | 0 | 0 | 0 | 28 | 0 | 28
15718430 | E60ALHL CA  PRIMER.BLACK | OES | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 12
15857270 | DAI*LHG 211 PALLADIUM SI | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
29117000 | E90ALHG SSG PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 16 | 0 | 16
14077640 | E89 LHL OVT ALPINE WHITE | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
67401554 | E8xALHG  CA TITAN SILVER | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
14095460 | E89 LHL OCA ALPINE WHITE | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
14280600 | 204*LHL KG  PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 140 | 0 | 140
15533230 | DAI*LHG 211 BRILLIANT SI | OES | 0 | 0 | 0 | 0 | 0 | 21 | 0 | 21
67402893 | DAI*LH  203 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 146 | 0 | 146
15535170 | DAI*RHG 220 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 32 | 0 | 32
15684530 | DAI*LH  221 OBSIDIAN BLK | OES | 0 | 0 | 0 | 0 | 0 | 60 | 0 | 60
15456601 | POR*    KES PRIMER STRIP | OES | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 40
15456801 | POR*    STD PRIMER STRIP | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
32806500 | STRA292     BLACK | STARS | 0 | 0 | 0 | 0 | 0 | 44 | 0 | 44
72500101 | [NAME]  UPPER FINISHER | QPP | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 240
72500102 | [NAME] | QPP | 0 | 0 | 0 | 0 | 0 | 240 | 0 | 240
72100420 | CON WHT KIT ASSEMBLY | QPP | 0 | 0 | 0 | 0 | 0 | 3160 | 800 | 3960
72100430 | ETH WHT KIT ASSEMBLY | QPP | 0 | 0 | 0 | 0 | 0 | 2640 | 400 | 3040
32806470 | STRA205     SELENIT GREY | STARS | 0 | 418 | 748 | 418 | 66 | 176 | 220 | 2046
32806550 | STRA292     POLAR WHITE | STARS | 66 | 60 | 0 | 66 | 44 | 88 | 0 | 324
66001426 | F01 LHL STD ESTORIL BLUE | OES | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 20
14077262 | E89 LHG     KARMESIN RED | OES | 0 | 0 | 0 | 0 | 10 | 10 | 0 | 20
14095520 | E89 LHL OCA BLK SAPPHIRE | OES | 0 | 0 | 0 | 0 | 20 | 26 | 0 | 46
32806610 | STRA292     BRILLIANT BL | STARS | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
32806750 | STRAKIT 205 PRIMER GREY | STARS | 0 | 22 | 66 | 0 | 66 | 66 | 66 | 286
32806810 | STRA205     GRAPHIT GREY | STARS | 0 | 242 | 704 | 110 | 286 | 550 | 132 | 2024
32806520 | STRA292     CAVANSIT BLU | STARS | 0 | 0 | 0 | 22 | 22 | 0 | 0 | 44
15536610 | DAI*LHG 220 OBSIDIAN BLK | OES | 0 | 0 | 0 | 0 | 20 | 20 | 0 | 40
66001235 | F01 LHL CA  TITAN SILVER | OES | 0 | 0 | 0 | 0 | 20 | 60 | 0 | 80
66001248 | F01 LHL CA  HAVANNA | OES | 0 | 0 | 0 | 0 | 20 | 77 | 0 | 97
8235602 | VTB KEY HEAD HOUSING | VOLVO KEYS | 500 | 6000 | 6000 | 8000 | 3500 | 11000 | 0 | 35000
15268501 | E46ALHG  -4 PRIMER BLACK | OES | 0 | 0 | 0 | 0 | 0 | 80 | 0 | 80
66001228 | F01 RHL CA  SPACE GREY | OES | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 40
60034962 | DAI*LHG 219 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 79 | 0 | 79
8235710 | VTB KEY OVERMOULD | VOLVO KEYS | 5600 | 5600 | 6400 | 8000 | 4800 | 9600 | 0 | 40000
36204205 | COV     PLASTIC COVER | VOLVO KEYS | 1000 | 0 | 0 | 1000 | 0 | 4000 | 0 | 6000
68106001 | HUF MOULD+BLANK (DH KEY) | VOLVO KEYS | 0 | 500 | 1000 | 1000 | 500 | 6400 | 0 | 9400
60034978 | DAI*RHF 203 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 87 | 0 | 87
14061811 | DAI*LHG 221 BLK MAGNETIT | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
66001255 | F01 RHN CA  HAVANNA | OES | 0 | 0 | 0 | 0 | 0 | 80 | 0 | 80
32806310 | STRA205     OBSIDIAN BLK | STARS | 0 | 0 | 0 | 0 | 0 | 132 | 220 | 352
66001316 | F01 RHN CA  JATOBA MET. | OES | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 40
14268140 | 204ALHL     DOLOMIT BR'N | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
15681451 | DAI*RHG 221 OBSIDIAN BLK | OES | 0 | 0 | 0 | 0 | 0 | 140 | 0 | 140
15535150 | DAI*LHG 220 PRIMER GREY | OES | 0 | 0 | 0 | 0 | 0 | 120 | 0 | 120
14077230 | E89ARHN     DEEPSEA BLUE | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
14204610 | [NAME] GREY | OES | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 20
66001232 | F01 RHL CA  IMPERIAL BLU | OES | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 40
32806380 | STRA205     HYACINTH RED | STARS | 0 | 0 | 0 | 0 | 0 | 220 | 132 | 352
72100126 | JOS NAT WALL BRACKET | QPP | 0 | 0 | 0 | 0 | 0 | 6480 | 2688 | 9168
72100127 | JOS NAT WALL BRKT CAP | QPP | 0 | 0 | 0 | 0 | 0 | 6480 | 2688 | 9168
72100125 | JOS CLR SOAP DISH | QPP | 0 | 0 | 0 | 0 | 0 | 3200 | 0 | 3200
72100410 | JOS WHT KIT ASSEMBLY | QPP | 0 | 0 | 0 | 0 | 0 | 2080 | 800 | 2880
72400104 | MAG LH  FRONT CARRIER VM | QPP | 0 | 0 | 0 | 0 | 0 | 1562 | 0 | 1562
72400105 | MAG LH  REAR CARRIER VM | QPP | 0 | 0 | 0 | 0 | 0 | 1562 | 0 | 1562
72400106 | MAG RH  FRONT CARRIER VM | QPP | 0 | 0 | 0 | 0 | 0 | 1562 | 0 | 1562
72400107 | MAG RH  REAR CARRIER VM | QPP | 0 | 0 | 0 | 0 | 0 | 1562 | 0 | 1562
72100112 | AAR WHT LOCATION BODY | QPP | 0 | 0 | 0 | 0 | 1660 | 14350 | 4800 | 20810
72100111 | AAR WHT CAP | QPP | 0 | 0 | 0 | 0 | 3317 | 28400 | 9600 | 41317
72100113 | AAR WHT BRACKET BODY | QPP | 0 | 0 | 0 | 0 | 1660 | 13500 | 9600 | 24760
72400103 | MAG    NPLATE SURR MOULD | QPP | 0 | 0 | 0 | 106 | 1279 | 380 | 490 | 2255
72300101 | TEC     METER HOUSING | QPP | 0 | 0 | 0 | 0 | 3180 | 12780 | 0 | 15960
72400101 | MAG LH  B/WARE MOULD | QPP | 0 | 0 | 0 | 0 | 1908 | 1770 | 0 | 3678
72400102 | MAG RH  B/WARE MOULD | QPP | 0 | 0 | 0 | 0 | 1928 | 1713 | 0 | 3641