Spreadsheet: 713269d1610629458-how-to-split-a-quantity-across-time-periods-example-for-volume-split
Sheet: Database

Retailer | Brand | Product SKU | Shipping Start Date | Shipping End Date | Volume | Shipping Month | Shipping Year | Shipping MonthYear
Walmart | E | E1 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 417
7-Eleven | C | C2 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 333
Costco | B | B1 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 417
Walmart | C | C1 | 2019-02-05 00:00:00 | 2019-03-04 00:00:00 | 333
7-Eleven | C | [NAME] | 2019-03-19 00:00:00 | 2019-04-21 00:00:00 | 411.84
Costco | E | E3 | 2019-11-21 00:00:00 | 2019-12-17 00:00:00 | 524.16
7-Eleven | E | E1 | 2019-11-21 00:00:00 | 2019-12-17 00:00:00 | 65.56
Costco | B | B2 | 2019-04-22 00:00:00 | 2019-05-26 00:00:00 | 332.28
Whole Foods | C | C2 | 2019-04-22 00:00:00 | 2019-05-26 00:00:00 | 146.16
7-Eleven | E | E3 | 2019-11-11 00:00:00 | 2019-12-08 00:00:00 | 14.04
7-Eleven | D | D2 | 2019-11-11 00:00:00 | 2019-12-08 00:00:00 | 5.04
Amazon | C | [NAME] | 2019-03-05 00:00:00 | 2019-04-07 00:00:00 | 262.08
Amazon | D | D1 | 2019-04-02 00:00:00 | 2019-05-05 00:00:00 | 105.84
Walmart | D | D2 | 2019-04-02 00:00:00 | 2019-05-05 00:00:00 | 346.32
Whole Foods | D | D2 | 2019-08-06 00:00:00 | 2019-09-08 00:00:00 | 267.12
Walmart | C | C2 | 2019-08-06 00:00:00 | 2019-09-08 00:00:00 | 372.6
7-Eleven | E | E3 | 2019-06-24 00:00:00 | 2019-07-29 00:00:00 | 534.24
Walmart | E | E3 | 2019-06-24 00:00:00 | 2019-07-29 00:00:00 | 98.28
Amazon | A | A2 | 2019-06-11 00:00:00 | 2019-07-14 00:00:00 | 186.48
Whole Foods | D | D2 | 2019-06-11 00:00:00 | 2019-07-14 00:00:00 | 341.64
Costco | A | A3 | 2019-05-07 00:00:00 | 2019-06-10 00:00:00 | 47
Whole Foods | C | C2 | 2019-05-07 00:00:00 | 2019-06-10 00:00:00 | 715.68
Amazon | E | E2 | 2019-03-12 00:00:00 | 2019-04-08 00:00:00 | 98.28
Whole Foods | D | D1 | 2019-03-12 00:00:00 | 2019-04-08 00:00:00 | 378
Whole Foods | A | A1 | 2019-08-27 00:00:00 | 2019-09-23 00:00:00 | 2238.36
7-Eleven | D | D1 | 2019-08-27 00:00:00 | 2019-09-23 00:00:00 | 74.88
Costco | E | E2 | 2019-11-25 00:00:00 | 2019-12-22 00:00:00 | 290.16
Amazon | C | C1 | 2019-11-25 00:00:00 | 2019-12-22 00:00:00 | 216.72
Whole Foods | A | A3 | 2020-01-21 00:00:00 | 2020-02-23 00:00:00 | 308.88
7-Eleven | E | E1 | 2020-04-20 00:00:00 | 2020-05-24 00:00:00 | 314
Amazon | E | E2 | 2020-04-20 00:00:00 | 2020-05-24 00:00:00 | 307
Amazon | D | D1 | 2020-05-15 00:00:00 | 2020-06-01 00:00:00 | 461
Walmart | C | [NAME] | 2020-05-15 00:00:00 | 2020-06-01 00:00:00 | 93
7-Eleven | C | C1 | 2020-05-12 00:00:00 | 2020-06-14 00:00:00 | 183
Costco | C | C2 | 2020-05-12 00:00:00 | 2020-06-14 00:00:00 | 202
7-Eleven | A | A3 | 2020-01-28 00:00:00 | 2020-02-24 00:00:00 | 221.76
Costco | B | B1 | 2020-01-28 00:00:00 | 2020-02-24 00:00:00 | 145.08
Amazon | A | A1 | 2020-06-16 00:00:00 | 2020-07-13 00:00:00 | 650
7-Eleven | D | D1 | 2020-06-16 00:00:00 | 2020-07-13 00:00:00 | 70
Walmart | B | B3 | 2020-07-07 00:00:00 | 2020-08-10 00:00:00 | 1000
7-Eleven | A | A2 | 2020-07-07 00:00:00 | 2020-08-10 00:00:00 | 50
Costco | A | A2 | 2020-07-27 00:00:00 | 2020-08-16 00:00:00 | 450
Walmart | D | D3 | 2020-07-27 00:00:00 | 2020-08-16 00:00:00 | 350
Amazon | E | E3 | 2020-07-21 00:00:00 | 2020-08-24 00:00:00 | 100
Amazon | E | E3 | 2020-07-21 00:00:00 | 2020-08-24 00:00:00 | 700
Costco | C | C2 | 2020-07-28 00:00:00 | 2020-08-30 00:00:00 | 350
Walmart | D | D3 | 2020-07-28 00:00:00 | 2020-08-30 00:00:00 | 200
Amazon | E | E1 | 2020-08-04 00:00:00 | 2020-09-06 00:00:00 | 350
Walmart | C | [NAME] | 2020-08-04 00:00:00 | 2020-09-06 00:00:00 | 350
Amazon | A | A3 | 2020-08-24 00:00:00 | 2020-09-28 00:00:00 | 1200
Whole Foods | A | A1 | 2020-08-24 00:00:00 | 2020-09-28 00:00:00 | 100
7-Eleven | B | B2 | 2020-03-17 00:00:00 | 2020-04-19 00:00:00 | 237
Walmart | C | C2 | 2020-03-17 00:00:00 | 2020-04-19 00:00:00 | 239
Whole Foods | A | A1 | 2020-04-02 00:00:00 | 2020-05-10 00:00:00 | 257
Whole Foods | A | A2 | 2020-04-02 00:00:00 | 2020-05-10 00:00:00 | 383
Walmart | C | [NAME] | 2020-03-24 00:00:00 | 2020-04-27 00:00:00 | 610
Amazon | B | B3 | 2020-03-24 00:00:00 | 2020-04-27 00:00:00 | 112
Walmart | E | E2 | 2020-06-16 00:00:00 | 2020-07-19 00:00:00 | 250
Costco | B | B1 | 2020-06-16 00:00:00 | 2020-07-19 00:00:00 | 300
Costco | C | [NAME] | 2020-08-03 00:00:00 | 2020-09-07 00:00:00 | 700
Walmart | E | E1 | 2020-08-03 00:00:00 | 2020-09-07 00:00:00 | 30
Amazon | D | D2 | 2020-07-29 00:00:00 | 2020-08-25 00:00:00 | 1581.84
Amazon | D | D1 | 2020-08-31 00:00:00 | 2020-09-27 00:00:00 | 300
Amazon | B | B2 | 2020-08-31 00:00:00 | 2020-09-27 00:00:00 | 250
7-Eleven | B | B2 | 2019-05-06 00:00:00 | 2019-06-11 00:00:00 | 44
7-Eleven | D | D2 | 2019-04-01 00:00:00 | 2019-05-05 00:00:00 | 0.75