Spreadsheet: 713316d1610643879-how-to-split-a-quantity-across-time-periods-example-for-volume-split
Sheet: Table1

Retailer | Brand | Product SKU | Shipping Start Date | Shipping End Date | Volume | Shipping Month | Shipping Year | Shipping MonthYear | Shipment Start Month | Shipments 2nd Month
Walmart | E | E1 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 417 | 2 | 2019 | 22019 | 345 | 72
7-Eleven | C | C2 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 333 | 2 | 2019 | 22019 | 276 | 57
Costco | B | B1 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 417 | 2 | 2019 | 22019 | 345 | 72
Walmart | C | C1 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 333 | 2 | 2019 | 22019 | 276 | 57
7-Eleven | C | [NAME] | 2019-03-19 00:00:00 | 2019-04-21 00:00:00 | 411.84 | 3 | 2019 | 32019 | 144 | 268
Costco | E | E3 | 2019-11-21 00:00:00 | 2019-12-17 00:00:00 | 524.16 | 11 | 2019 | 112019 | 180 | 344
7-Eleven | E | E1 | 2019-11-21 00:00:00 | 2019-12-17 00:00:00 | 65.56 | 11 | 2019 | 112019 | 27 | 39
Costco | B | B2 | 2019-04-22 00:00:00 | 2019-05-26 00:00:00 | 332.28 | 4 | 2019 | 42019 | 80 | 252
Whole Foods | C | C2 | 2019-04-22 00:00:00 | 2019-05-26 00:00:00 | 146.16 | 4 | 2019 | 42019 | 32 | 114
7-Eleven | E | E3 | 2019-11-11 00:00:00 | 2019-12-08 00:00:00 | 14.04 | 11 | 2019 | 112019 | 19 | -5
7-Eleven | D | D2 | 2019-11-11 00:00:00 | 2019-12-08 00:00:00 | 5.04 | 11 | 2019 | 112019 | 0 | 5
Amazon | C | [NAME] | 2019-03-05 00:00:00 | 2019-04-07 00:00:00 | 262.08 | 3 | 2019 | 32019 | 208 | 54
Amazon | D | D1 | 2019-04-02 00:00:00 | 2019-05-05 00:00:00 | 105.84 | 4 | 2019 | 42019 | 84 | 22
Walmart | D | D2 | 2019-04-02 00:00:00 | 2019-05-05 00:00:00 | 346.32 | 4 | 2019 | 42019 | 280 | 66
Whole Foods | D | D2 | 2019-08-06 00:00:00 | 2019-09-08 00:00:00 | 267.12 | 8 | 2019 | 82019 | 200 | 67
Walmart | C | C2 | 2019-08-06 00:00:00 | 2019-09-08 00:00:00 | 372.6 | 8 | 2019 | 82019 | 275 | 98
7-Eleven | E | E3 | 2019-06-24 00:00:00 | 2019-07-29 00:00:00 | 534.24 | 6 | 2019 | 62019 | 90 | 444
Walmart | E | E3 | 2019-06-24 00:00:00 | 2019-07-29 00:00:00 | 98.28 | 6 | 2019 | 62019 | 18 | 80
Amazon | A | A2 | 2019-06-11 00:00:00 | 2019-07-14 00:00:00 | 186.48 | 6 | 2019 | 62019 | 114 | 72
Whole Foods | D | D2 | 2019-06-11 00:00:00 | 2019-07-14 00:00:00 | 341.64 | 6 | 2019 | 62019 | 190 | 152
Costco | A | A3 | 2019-05-07 00:00:00 | 2019-06-10 00:00:00 | 47 | 5 | 2019 | 52019 | 24 | 23
Whole Foods | C | C2 | 2019-05-07 00:00:00 | 2019-06-10 00:00:00 | 715.68 | 5 | 2019 | 52019 | 504 | 212
Amazon | E | E2 | 2019-03-12 00:00:00 | 2019-04-08 00:00:00 | 98.28 | 3 | 2019 | 32019 | 76 | 22
Whole Foods | D | D1 | 2019-03-12 00:00:00 | 2019-04-08 00:00:00 | 378 | 3 | 2019 | 32019 | 266 | 112
Whole Foods | A | A1 | 2019-08-27 00:00:00 | 2019-09-23 00:00:00 | 2238.36 | 8 | 2019 | 82019 | 332 | 1906
7-Eleven | D | D1 | 2019-08-27 00:00:00 | 2019-09-23 00:00:00 | 74.88 | 8 | 2019 | 82019 | 12 | 63
Costco | E | E2 | 2019-11-25 00:00:00 | 2019-12-22 00:00:00 | 290.16 | 11 | 2019 | 112019 | 55 | 235
Amazon | C | C1 | 2019-11-25 00:00:00 | 2019-12-22 00:00:00 | 216.72 | 11 | 2019 | 112019 | 40 | 177
Whole Foods | A | A3 | 2020-01-21 00:00:00 | 2020-02-23 00:00:00 | 308.88 | 1 | 2020 | 12020 | 90 | 219
7-Eleven | E | E1 | 2020-04-20 00:00:00 | 2020-05-24 00:00:00 | 314 | 4 | 2020 | 42020 | 90 | 224
Amazon | E | E2 | 2020-04-20 00:00:00 | 2020-05-24 00:00:00 | 307 | 4 | 2020 | 42020 | 90 | 217
Amazon | D | D1 | 2020-05-15 00:00:00 | 2020-06-01 00:00:00 | 461 | 5 | 2020 | 52020 | 432 | 29
Walmart | C | [NAME] | 2020-05-15 00:00:00 | 2020-06-01 00:00:00 | 93 | 5 | 2020 | 52020 | 80 | 13
7-Eleven | C | C1 | 2020-05-12 00:00:00 | 2020-06-14 00:00:00 | 183 | 5 | 2020 | 52020 | 114 | 69
Costco | C | C2 | 2020-05-12 00:00:00 | 2020-06-14 00:00:00 | 202 | 5 | 2020 | 52020 | 114 | 88
7-Eleven | A | A3 | 2020-01-28 00:00:00 | 2020-02-24 00:00:00 | 221.76 | 1 | 2020 | 12020 | 24 | 198
Costco | B | B1 | 2020-01-28 00:00:00 | 2020-02-24 00:00:00 | 145.08 | 1 | 2020 | 12020 | 15 | 130
Amazon | A | A1 | 2020-06-16 00:00:00 | 2020-07-13 00:00:00 | 650 | 6 | 2020 | 62020 | 336 | 314
7-Eleven | D | D1 | 2020-06-16 00:00:00 | 2020-07-13 00:00:00 | 70 | 6 | 2020 | 62020 | 42 | 28
Walmart | B | B3 | 2020-07-07 00:00:00 | 2020-08-10 00:00:00 | 1000 | 7 | 2020 | 72020 | 696 | 304
7-Eleven | A | A2 | 2020-07-07 00:00:00 | 2020-08-10 00:00:00 | 50 | 7 | 2020 | 72020 | 24 | 26
Costco | A | A2 | 2020-07-27 00:00:00 | 2020-08-16 00:00:00 | 450 | 7 | 2020 | 72020 | 88 | 362
Walmart | D | D3 | 2020-07-27 00:00:00 | 2020-08-16 00:00:00 | 350 | 7 | 2020 | 72020 | 72 | 278
Amazon | E | E3 | 2020-07-21 00:00:00 | 2020-08-24 00:00:00 | 100 | 7 | 2020 | 72020 | 30 | 70
Amazon | E | E3 | 2020-07-21 00:00:00 | 2020-08-24 00:00:00 | 700 | 7 | 2020 | 72020 | 210 | 490
Costco | C | C2 | 2020-07-28 00:00:00 | 2020-08-30 00:00:00 | 350 | 7 | 2020 | 72020 | 33 | 317
Walmart | D | D3 | 2020-07-28 00:00:00 | 2020-08-30 00:00:00 | 200 | 7 | 2020 | 72020 | 18 | 182
Amazon | E | E1 | 2020-08-04 00:00:00 | 2020-09-06 00:00:00 | 350 | 8 | 2020 | 82020 | 297 | 53
Walmart | C | [NAME] | 2020-08-04 00:00:00 | 2020-09-06 00:00:00 | 350 | 8 | 2020 | 82020 | 297 | 53
Amazon | A | A3 | 2020-08-24 00:00:00 | 2020-09-28 00:00:00 | 1200 | 8 | 2020 | 82020 | 238 | 962
Whole Foods | A | A1 | 2020-08-24 00:00:00 | 2020-09-28 00:00:00 | 100 | 8 | 2020 | 82020 | 21 | 79
7-Eleven | B | B2 | 2020-03-17 00:00:00 | 2020-04-19 00:00:00 | 237 | 3 | 2020 | 32020 | 98 | 139
Walmart | C | C2 | 2020-03-17 00:00:00 | 2020-04-19 00:00:00 | 239 | 3 | 2020 | 32020 | 98 | 141
Whole Foods | A | A1 | 2020-04-02 00:00:00 | 2020-05-10 00:00:00 | 257 | 4 | 2020 | 42020 | 196 | 61
Whole Foods | A | A2 | 2020-04-02 00:00:00 | 2020-05-10 00:00:00 | 383 | 4 | 2020 | 42020 | 280 | 103
Walmart | C | [NAME] | 2020-03-24 00:00:00 | 2020-04-27 00:00:00 | 610 | 3 | 2020 | 32020 | 126 | 484
Amazon | B | B3 | 2020-03-24 00:00:00 | 2020-04-27 00:00:00 | 112 | 3 | 2020 | 32020 | 21 | 91
Walmart | E | E2 | 2020-06-16 00:00:00 | 2020-07-19 00:00:00 | 250 | 6 | 2020 | 62020 | 112 | 138
Costco | B | B1 | 2020-06-16 00:00:00 | 2020-07-19 00:00:00 | 300 | 6 | 2020 | 62020 | 126 | 174
Costco | C | [NAME] | 2020-08-03 00:00:00 | 2020-09-07 00:00:00 | 700 | 8 | 2020 | 82020 | 560 | 140
Walmart | E | E1 | 2020-08-03 00:00:00 | 2020-09-07 00:00:00 | 30 | 8 | 2020 | 82020 | 28 | 2
Amazon | D | D2 | 2020-07-29 00:00:00 | 2020-08-25 00:00:00 | 1581.84 | 7 | 2020 | 72020 | 118 | 1464
Amazon | D | D1 | 2020-08-31 00:00:00 | 2020-09-27 00:00:00 | 300 | 8 | 2020 | 82020 | 0 | 300
Amazon | B | B2 | 2020-08-31 00:00:00 | 2020-09-27 00:00:00 | 250 | 8 | 2020 | 82020 | 0 | 250
7-Eleven | B | B2 | 2019-05-06 00:00:00 | 2019-06-11 00:00:00 | 44 | 5 | 2019 | 52019 | 25 | 19
7-Eleven | D | D2 | 2019-04-01 00:00:00 | 2019-05-05 00:00:00 | 0.75 | 4 | 2019 | 42019 | 0 | 1