Spreadsheet: 883094d1731579458-formula-simplification-help-request-formula-simplification
Sheet: Data - Durations

 | Campaign Start Date | Campaign Length | Product | Campaign Amt (kg)
 | 2024-02-20 11:55:00 |  | Product 233 | 19450
 |  |  | Product 658 | 2550
 |  |  | Product 233 | 63750
 |  |  | Product 658 | 31150
 |  |  | Product 233 | 7300
 | 2024-02-23 00:06:00 |  | Product 233 | 27600
 |  |  | Product 658 | 23850
 |  |  | Product 233 | 20500
 |  |  | Product 658 | 19150
 |  |  | Product 602 | 4750
 |  |  | Product 359 | 12450
 |  |  | Product 247 | 15150
 |  |  | Product 359 | 800
 |  |  | Product 247 | 107200
 |  |  | Product 457 | 63000
 |  |  | Product 212 | 99000
 |  |  | Product 368 | 153000
 |  |  | Product 433 | 100000
 |  |  | Product 291 | 144700
 |  |  | Product 164 | 3450
 |  |  | Product 311 | 11850
 |  |  | Product 164 | 192850
 |  |  | Product 697 | 25600
 |  |  | Product 159 | 28850
 |  |  | Product 624 | 1550
 | 2024-03-11 04:59:00 |  | Product 233 | 7550
 | 2024-03-11 14:43:00 |  | Product 233 | 8500
 |  |  | Product 369 | 675
 |  |  | Product 233 | 1875
 |  |  | Product 369 | 4975
 |  |  | Product 658 | 30500
 |  |  | Product 697 | 32200
 |  |  | Product 159 | 6350
 |  |  | Product 697 | 15675
 | 2024-03-15 22:17:00 |  | Product 233 | 6775
 | 2024-03-16 12:54:00 |  | Product 233 | 55550
 |  |  | Product 369 | 625
 |  |  | Product 658 | 7575
 |  |  | Product 697 | 108750
 |  |  | Product 159 | 371150
 |  |  | Product 697 | 2190
 |  |  | Product 178 | 750
 |  |  | Product 367 | 35650
 |  |  | Product 178 | 1450
 |  |  | Product 367 | 5350
 |  |  | Product 171 | 251050
 |  |  | Product 555 | 11450
 |  |  | Product 189 | 400
 |  |  | Product 572 | 63000
 |  |  | Product 377 | 68200
 |  |  | Product 531 | 2500
 |  |  | Product 377 | 80800
 |  |  | Product 91 | 33000
 |  |  | Product 696 | 1500
 |  |  | Product 91 | 84600
 |  |  | Product 535 | 243800
 |  |  | Product 134 | 12096
 |  |  | Product 433 | 127000
 |  |  | Product 291 | 167900
 |  |  | Product 589 | 18000
 |  |  | Product 164 | 125100
 |  |  | Product 474 | 289500
 |  |  | Product 216 | 71250
 |  |  | Product 655 | 7850
 | 2024-04-18 17:06:00 |  | Product 233 | 28300
 |  |  | Product 369 | 3450
 |  |  | Product 658 | 23650
 |  |  | Product 295 | 3200
 | 2024-04-19 17:59:00 |  | Product 233 | 19600
 |  |  | Product 369 | 14950
 |  |  | Product 233 | 13000
 |  |  | Product 369 | 10250
 |  |  | Product 658 | 11700
 |  |  | Product 295 | 7650
 |  |  | Product 655 | 750
 |  |  | Product 295 | 30350
 |  |  | Product 216 | 73600
 |  |  | Product 523 | 12550
 |  |  | Product 240 | 900
 |  |  | Product 256 | 97000
 |  |  | Product 287 | 204300
 |  |  | Product 442 | 219500
 |  |  | Product 655 | 50000
 |  |  | Product 555 | 16400
 |  |  | Product 189 | 1850
 |  |  | Product 572 | 63000
 |  |  | Product 377 | 74550
 |  |  | Product 531 | 500
 |  |  | Product 377 | 14300
 |  |  | Product 693 | 49750
 |  |  | Product 377 | 209150
 |  |  | Product 91 | 20150
 |  |  | Product 696 | 5350
 |  |  | Product 68 | 13500
 |  |  | Product 91 | 94200
 |  |  | Product 535 | 414150
 |  |  | Product 178 | 7150
 |  |  | Product 367 | 38800
 |  |  | Product 171 | 34100
 |  |  | Product 367 | 250
 |  |  | Product 171 | 109900
 |  |  | Product 283 | 42550
 |  |  | Product 212 | 27000
 |  |  | Product 368 | 46000
 |  |  | Product 163 | 550
 |  |  | Product 368 | 121850
 |  |  | Product 314 | 11290
 |  |  | Product 452 | 99400
 |  |  | Product 238 | 11757.56782277
 |  |  | Product 207 | 54000
 |  |  | Product 164 | 212950
 |  |  | Product 327 | 17100
 |  |  | Product 681 | 75750
 | 2024-06-14 01:30:00 |  | Product 233 | 20400
 |  |  | Product 369 | 12500
 |  |  | Product 658 | 22500
 |  |  | Product 233 | 5850
 |  |  | Product 658 | 2400
 |  |  | Product 233 | 3800
 |  |  | Product 658 | 92450
 |  |  | Product 233 | 11300
 |  |  | Product 658 | 9650
 |  |  | Product 233 | 26400
 | 2024-06-18 07:22:00 |  | Product 233 | 39100
 |  |  | Product 369 | 11200
 |  |  | Product 233 | 7150
 |  |  | Product 658 | 9800
 |  |  | Product 233 | 10950
 |  |  | Product 223 | 250000
 |  |  | Product 189 | 550000
 |  |  | Product 217 | 54650
 |  |  | Product 327 | 5500
 |  |  | Product 681 | 5650
 |  |  | Product 474 | 150000
 |  |  | Product 216 | 184150
 |  |  | Product 178 | 11200
 |  |  | Product 367 | 4100
 |  |  | Product 171 | 226450
 |  |  | Product 602 | 7150
 |  |  | Product 247 | 18750
 |  |  | Product 359 | 1750
 |  |  | Product 247 | 100950
 |  |  | Product 287 | 94100
 |  |  | Product 84 | 750
 |  |  | Product 287 | 141700
 |  |  | Product 84 | 13650
 |  |  | Product 287 | 6900
 |  |  | Product 442 | 178100
 |  |  | Product 307 | 227800
 |  |  | Product 555 | 12850
 |  |  | Product 189 | 650
 |  |  | Product 572 | 63000
 |  |  | Product 377 | 276065
 |  |  | Product 91 | 54000
 |  |  | Product 206 | 18000
 |  |  | Product 535 | 9000
 | 2024-07-26 16:26:00 |  | Product 174 | 19000
 |  |  | Product 118 | 18150
 |  |  | Product 535 | 277250
 |  |  | Product 134 | 19700
 |  |  | Product 515 | 950
 |  |  | Product 433 | 100000
 |  |  | Product 291 | 137100
 |  |  | Product 589 | 54000
 |  |  | Product 212 | 18000
 |  |  | Product 368 | 27000
 |  |  | Product 212 | 152500
 |  |  | Product 65 | 35000
 |  |  | Product 368 | 371000
 | 2024-08-13 19:43:00 |  | Product 163 | 3350
 | 2024-08-15 13:38:00 |  | Product 233 | 71750
 |  |  | Product 369 | 7700
 |  |  | Product 658 | 35300
 |  |  | Product 283 | 37050
 |  |  | Product 366 | 350
 |  |  | Product 283 | 4600
 |  |  | Product 212 | 27000
 |  |  | Product 368 | 96150
 |  |  | Product 555 | 14350
 |  |  | Product 189 | 34650
 |  |  | Product 555 | 44400
 |  |  | Product 189 | 43950
 |  |  | Product 555 | 14700
 |  |  | Product 572 | 30000
 |  |  | Product 377 | 138900
 |  |  | Product 429 | 12500
 |  |  | Product 164 | 146300
 |  |  | Product 474 | 8550
 |  |  | Product 681 | 350
 |  |  | Product 474 | 152900
 |  |  | Product 681 | 7900
 |  |  | Product 474 | 57050
 |  |  | Product 681 | 27250
 |  |  | Product 327 | 15750
 | 2024-08-31 13:54:00 |  | Product 233 | 27200
 |  |  | Product 369 | 5625
 |  |  | Product 658 | 11925
 |  |  | Product 233 | 2975
 |  |  | Product 658 | 2950
 |  |  | Product 233 | 2700
 |  |  | Product 658 | 12475
 |  |  | Product 233 | 800
 |  |  | Product 658 | 81000
 |  |  | Product 189 | 83600
 |  |  | Product 117 | 28300
 |  |  | Product 189 | 149250
 |  |  | Product 117 | 4350
 |  |  | Product 223 | 551100
 |  |  | Product 117 | 12650
 |  |  | Product 223 | 146350
 |  |  | Product 117 | 6100
 |  |  | Product 223 | 124100
 |  |  | Product 327 | 9350
 |  |  | Product 681 | 1300
 |  |  | Product 474 | 59000
 |  |  | Product 655 | 9900
 |  |  | Product 570 | 1000
 |  |  | Product 291 | 68350
 |  |  | Product 377 | 11400
 |  |  | Product 155 | 600
 |  |  | Product 176 | 192950
 |  |  | Product 555 | 11506.73124216
 |  |  | Product 572 | 18000
 |  |  | Product 377 | 18000
 |  |  | Product 91 | 301000
 |  |  | Product 377 | 338350
 |  |  | Product 206 | 18000
 |  |  | Product 535 | 91800
 |  |  | Product 602 | 5600
 |  |  | Product 359 | 350
 |  |  | Product 602 | 9500
 |  |  | Product 247 | 95400
 |  |  | Product 287 | 209900
 |  |  | Product 442 | 103500
 |  |  | Product 327 | 4700
 | 2024-10-08 12:14:00 |  | Product 233 | 27500
 |  |  | Product 369 | 5514
 |  |  | Product 658 | 44500
 |  |  | Product 327 | 9500
 |  |  | Product 681 | 1500
 |  |  | Product 327 | 14700
 |  |  | Product 474 | 301150
 |  |  | Product 216 | 201800
 |  |  | Product 314 | 16100
 |  |  | Product 112 | 850
 |  |  | Product 452 | 121850
 |  |  | Product 314 | 19950
 |  |  | Product 112 | 9450
 |  |  | Product 314 | 40600
 |  |  | Product 452 | 80850
 |  |  | Product 420 | 10573.2381447
 |  |  | Product 360 | 31600
 |  |  | Product 507 | 2400
 | 2024-10-19 10:04:28 |  | Product 338 | 20100
 |  |  | Product 109 | 36750
 |  |  | Product 590 | 168700
 |  |  | Product 389 | 33720
 |  |  | Product 178 | 7950
 |  |  | Product 367 | 2850
 |  |  | Product 171 | 185750
 |  |  | Product 550 | 8400
 |  |  | Product 606 | 15955.11161475
 |  |  | Product 307 | 228900
 |  |  | Product 664 | 20150
 |  |  | Product 195 | 164900
 |  |  | Product 134 | 21100
 |  |  | Product 433 | 162000
 |  |  | Product 291 | 210300
 |  |  | Product 164 | 216500
 | 2024-12-10 05:00:00 |  | Product 233 | 20000
 |  |  | Product 369 | 10000
 |  |  | Product 658 | 63000
 |  |  | Product 240 | 10000
 |  |  | Product 84 | 5000
 |  |  | Product 287 | 140000
 |  |  | Product 442 | 100000
 |  |  | Product 606 | 8000
 |  |  | Product 307 | 200000
 |  |  | Product 555 | 14000
 |  |  | Product 189 | 1500
 |  |  | Product 572 | 63000
 |  |  | Product 377 | 125000
 |  |  | Product 429 | 10000
 |  |  | Product 164 | 100000
 |  |  | Product 474 | 100000
 | 2024-12-28 18:02:23 |  | Product 369 | 7700
 |  |  | Product 658 | 35300
 |  |  | Product 283 | 37050
 |  |  | Product 366 | 350
 |  |  | Product 283 | 4600
 |  |  | Product 212 | 27000
 |  |  | Product 368 | 96150
 |  |  | Product 555 | 14350
 |  |  | Product 189 | 34650
 |  |  | Product 555 | 44400
 |  |  | Product 189 | 43950
 |  |  | Product 555 | 14700
 |  |  | Product 572 | 30000
 |  |  | Product 377 | 138900
 |  |  | Product 429 | 12500
 |  |  | Product 164 | 146300
 |  |  | Product 474 | 8550
 | 2025-01-08 18:17:40 |  | Product 681 | 350
 |  |  | Product 474 | 152900
 |  |  | Product 681 | 7900
 |  |  | Product 474 | 57050
 |  |  | Product 681 | 27250
 |  |  | Product 327 | 15750