Spreadsheet: 792377d1660863424-optomize-raw-material-alf
Sheet: Blad1 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Som [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | length | Totaal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000 | 15
 |  | 16 | 36 | 36 | 12 | 35 | 4 | <<<<<< wanted quantities |  |  |  |  |  |  | 3600 | 5
minimize |  |  |  |  |  |  |  | <<<<<< deliverd quantities |  |  |  |  |  |  | 4800 | 18
 |  | 845 | 945 | 1000 | 1140 | 1200 | 2400 |  |  |  |  |  |  |  | Eindtotaal | 38
length | waste | 845 | 945 | 1000 | 1140 | 1200 | 2400 | check | [NAME]
3000 | 0 | 0 | 0 | 3 | 0 | 0 | 0 |  | 3
3600 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 1
3600 | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  | 2
4800 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |  | 1
4800 | 0 | 0 | 0 | 0 | 0 | 2 | 1 |  | 0
4800 | 0 | 0 | 0 | 0 | 0 | 4 | 0 |  | 7
3000 | 10 | 1 | 1 | 0 | 0 | 1 | 0 |  | 0
4800 | 10 | 1 | 1 | 3 | 0 | 0 | 0 |  | 2
3000 | 15 | 1 | 0 | 1 | 1 | 0 | 0 |  | 11
3600 | 20 | 2 | 2 | 0 | 0 | 0 | 0 |  | 1
4800 | 20 | 2 | 2 | 0 | 0 | 1 | 0 |  | 0
4800 | 20 | 0 | 4 | 1 | 0 | 0 | 0 |  | 8
4800 | 25 | 2 | 1 | 1 | 1 | 0 | 0 |  | 0
3000 | 55 | 0 | 1 | 2 | 0 | 0 | 0 |  | 0
3600 | 60 | 0 | 0 | 0 | 1 | 0 | 1 |  | 1
3600 | 60 | 0 | 0 | 0 | 1 | 2 | 0 |  | 0
4800 | 60 | 0 | 0 | 0 | 1 | 1 | 1 |  | 0
4800 | 60 | 0 | 0 | 0 | 1 | 3 | 0 |  | 0
3600 | 65 | 3 | 0 | 1 | 0 | 0 | 0 |  | 0
4800 | 65 | 3 | 0 | 1 | 0 | 1 | 0 |  | 0
4800 | 65 | 1 | 2 | 2 | 0 | 0 | 0 |  | 0
3000 | 70 | 1 | 1 | 0 | 1 | 0 | 0 |  | 0
4800 | 75 | 0 | 5 | 0 | 0 | 0 | 0 |  | 0
4800 | 80 | 2 | 2 | 0 | 1 | 0 | 0 |  | 0
3000 | 110 | 2 | 0 | 0 | 0 | 1 | 0 |  | 0
3000 | 110 | 0 | 2 | 1 | 0 | 0 | 0 |  | 0
4800 | 110 | 2 | 0 | 3 | 0 | 0 | 0 |  | 0
3600 | 120 | 0 | 0 | 0 | 2 | 1 | 0 |  | 0
3600 | 120 | 3 | 1 | 0 | 0 | 0 | 0 |  | 0
4800 | 120 | 0 | 0 | 0 | 2 | 0 | 1 |  | 0
4800 | 120 | 0 | 0 | 0 | 2 | 2 | 0 |  | 0
4800 | 120 | 3 | 1 | 0 | 0 | 1 | 0 |  | 0
4800 | 120 | 1 | 3 | 1 | 0 | 0 | 0 |  | 0
4800 | 125 | 3 | 0 | 1 | 1 | 0 | 0 |  | 0
3000 | 155 | 1 | 0 | 2 | 0 | 0 | 0 |  | 1
3000 | 165 | 0 | 3 | 0 | 0 | 0 | 0 |  | 0
4800 | 165 | 2 | 1 | 2 | 0 | 0 | 0 |  | 0
3000 | 170 | 2 | 0 | 0 | 1 | 0 | 0 |  | 0
4800 | 175 | 1 | 4 | 0 | 0 | 0 | 0 |  | 0
3600 | 180 | 0 | 0 | 0 | 3 | 0 | 0 |  | 0
4800 | 180 | 0 | 0 | 0 | 3 | 1 | 0 |  | 0
4800 | 180 | 3 | 1 | 0 | 1 | 0 | 0 |  | 0
3600 | 200 | 0 | 0 | 1 | 0 | 0 | 1 |  | 0
3600 | 200 | 0 | 0 | 1 | 0 | 2 | 0 |  | 0
4800 | 200 | 0 | 0 | 1 | 0 | 1 | 1 |  | 0
4800 | 200 | 0 | 0 | 1 | 0 | 3 | 0 |  | 0
3000 | 210 | 1 | 1 | 1 | 0 | 0 | 0 |  | 0
3600 | 220 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0
4800 | 220 | 4 | 0 | 0 | 0 | 1 | 0 |  | 0
4800 | 220 | 2 | 2 | 1 | 0 | 0 | 0 |  | 0
4800 | 240 | 0 | 0 | 0 | 4 | 0 | 0 |  | 0
3600 | 255 | 0 | 1 | 0 | 0 | 0 | 1 |  | 0
3600 | 255 | 0 | 1 | 0 | 0 | 2 | 0 |  | 0
4800 | 255 | 0 | 1 | 0 | 0 | 1 | 1 |  | 0
4800 | 255 | 0 | 1 | 0 | 0 | 3 | 0 |  | 0
3600 | 260 | 0 | 0 | 1 | 1 | 1 | 0 |  | 0
4800 | 260 | 0 | 0 | 1 | 1 | 0 | 1 |  | 0
4800 | 260 | 0 | 0 | 1 | 1 | 2 | 0 |  | 0
3000 | 265 | 1 | 2 | 0 | 0 | 0 | 0 |  | 0
4800 | 265 | 3 | 0 | 2 | 0 | 0 | 0 |  | 0
4800 | 275 | 2 | 3 | 0 | 0 | 0 | 0 |  | 0
4800 | 280 | 4 | 0 | 0 | 1 | 0 | 0 |  | 0
3000 | 310 | 2 | 0 | 1 | 0 | 0 | 0 |  | 0
3600 | 315 | 0 | 1 | 0 | 1 | 1 | 0 |  | 0
4800 | 315 | 0 | 1 | 0 | 1 | 0 | 1 |  | 0
4800 | 315 | 0 | 1 | 0 | 1 | 2 | 0 |  | 0
3600 | 320 | 0 | 0 | 1 | 2 | 0 | 0 |  | 0
4800 | 320 | 0 | 0 | 1 | 2 | 1 | 0 |  | 0
4800 | 320 | 3 | 1 | 1 | 0 | 0 | 0 |  | 0
3600 | 355 | 1 | 0 | 0 | 0 | 0 | 1 |  | 0
3600 | 355 | 1 | 0 | 0 | 0 | 2 | 0 |  | 0
4800 | 355 | 1 | 0 | 0 | 0 | 1 | 1 |  | 0
4800 | 355 | 1 | 0 | 0 | 0 | 3 | 0 |  | 0
3000 | 365 | 2 | 1 | 0 | 0 | 0 | 0 |  | 0
3600 | 375 | 0 | 1 | 0 | 2 | 0 | 0 |  | 0
4800 | 375 | 0 | 1 | 0 | 2 | 1 | 0 |  | 0
4800 | 375 | 3 | 2 | 0 | 0 | 0 | 0 |  | 0
4800 | 380 | 0 | 0 | 1 | 3 | 0 | 0 |  | 0
3600 | 400 | 0 | 0 | 2 | 0 | 1 | 0 |  | 0
4800 | 400 | 0 | 0 | 2 | 0 | 0 | 1 |  | 0
4800 | 400 | 0 | 0 | 2 | 0 | 2 | 0 |  | 0
3600 | 415 | 1 | 0 | 0 | 1 | 1 | 0 |  | 0
4800 | 415 | 1 | 0 | 0 | 1 | 0 | 1 |  | 0
4800 | 415 | 1 | 0 | 0 | 1 | 2 | 0 |  | 0
4800 | 420 | 4 | 0 | 1 | 0 | 0 | 0 |  | 0
4800 | 435 | 0 | 1 | 0 | 3 | 0 | 0 |  | 0
3600 | 455 | 0 | 1 | 1 | 0 | 1 | 0 |  | 0
4800 | 455 | 0 | 1 | 1 | 0 | 0 | 1 |  | 0
4800 | 455 | 0 | 1 | 1 | 0 | 2 | 0 |  | 0
3600 | 460 | 0 | 0 | 2 | 1 | 0 | 0 |  | 0
4800 | 460 | 0 | 0 | 2 | 1 | 1 | 0 |  | 0
3000 | 465 | 3 | 0 | 0 | 0 | 0 | 0 |  | 0
3600 | 475 | 1 | 0 | 0 | 2 | 0 | 0 |  | 0
4800 | 475 | 1 | 0 | 0 | 2 | 1 | 0 |  | 0
4800 | 475 | 4 | 1 | 0 | 0 | 0 | 0 |  | 0
3600 | 510 | 0 | 2 | 0 | 0 | 1 | 0 |  | 0
4800 | 510 | 0 | 2 | 0 | 0 | 0 | 1 |  | 0
4800 | 510 | 0 | 2 | 0 | 0 | 2 | 0 |  | 0
3600 | 515 | 0 | 1 | 1 | 1 | 0 | 0 |  | 0
4800 | 515 | 0 | 1 | 1 | 1 | 1 | 0 |  | 0
4800 | 520 | 0 | 0 | 2 | 2 | 0 | 0 |  | 0
4800 | 535 | 1 | 0 | 0 | 3 | 0 | 0 |  | 0
3600 | 555 | 1 | 0 | 1 | 0 | 1 | 0 |  | 0
4800 | 555 | 1 | 0 | 1 | 0 | 0 | 1 |  | 0
4800 | 555 | 1 | 0 | 1 | 0 | 2 | 0 |  | 0
3600 | 570 | 0 | 2 | 0 | 1 | 0 | 0 |  | 0
4800 | 570 | 0 | 2 | 0 | 1 | 1 | 0 |  | 0
4800 | 575 | 5 | 0 | 0 | 0 | 0 | 0 |  | 0
4800 | 575 | 0 | 1 | 1 | 2 | 0 | 0 |  | 0
3000 | 600 | 0 | 0 | 0 | 0 | 0 | 1 |  | 0
3000 | 600 | 0 | 0 | 0 | 0 | 2 | 0 |  | 0
3600 | 600 | 0 | 0 | 3 | 0 | 0 | 0 |  | 0
4800 | 600 | 0 | 0 | 3 | 0 | 1 | 0 |  | 0
3600 | 610 | 1 | 1 | 0 | 0 | 1 | 0 |  | 0
4800 | 610 | 1 | 1 | 0 | 0 | 0 | 1 |  | 0
4800 | 610 | 1 | 1 | 0 | 0 | 2 | 0 |  | 0
3600 | 615 | 1 | 0 | 1 | 1 | 0 | 0 |  | 0
4800 | 615 | 1 | 0 | 1 | 1 | 1 | 0 |  | 0
4800 | 630 | 0 | 2 | 0 | 2 | 0 | 0 |  | 0
3600 | 655 | 0 | 1 | 2 | 0 | 0 | 0 |  | 0
4800 | 655 | 0 | 1 | 2 | 0 | 1 | 0 |  | 0
3000 | 660 | 0 | 0 | 0 | 1 | 1 | 0 |  | 0
4800 | 660 | 0 | 0 | 3 | 1 | 0 | 0 |  | 0
3600 | 670 | 1 | 1 | 0 | 1 | 0 | 0 |  | 0
4800 | 670 | 1 | 1 | 0 | 1 | 1 | 0 |  | 0
4800 | 675 | 1 | 0 | 1 | 2 | 0 | 0 |  | 0
3600 | 710 | 2 | 0 | 0 | 0 | 1 | 0 |  | 0
3600 | 710 | 0 | 2 | 1 | 0 | 0 | 0 |  | 0
4800 | 710 | 2 | 0 | 0 | 0 | 0 | 1 |  | 0
4800 | 710 | 2 | 0 | 0 | 0 | 2 | 0 |  | 0
4800 | 710 | 0 | 2 | 1 | 0 | 1 | 0 |  | 0
4800 | 715 | 0 | 1 | 2 | 1 | 0 | 0 |  | 0
3000 | 720 | 0 | 0 | 0 | 2 | 0 | 0 |  | 0
4800 | 730 | 1 | 1 | 0 | 2 | 0 | 0 |  | 0
3600 | 755 | 1 | 0 | 2 | 0 | 0 | 0 |  | 0
4800 | 755 | 1 | 0 | 2 | 0 | 1 | 0 |  | 0
3600 | 765 | 0 | 3 | 0 | 0 | 0 | 0 |  | 0
4800 | 765 | 0 | 3 | 0 | 0 | 1 | 0 |  | 0
3600 | 770 | 2 | 0 | 0 | 1 | 0 | 0 |  | 0
4800 | 770 | 2 | 0 | 0 | 1 | 1 | 0 |  | 0
4800 | 770 | 0 | 2 | 1 | 1 | 0 | 0 |  | 0
3000 | 800 | 0 | 0 | 1 | 0 | 1 | 0 |  | 0
4800 | 800 | 0 | 0 | 4 | 0 | 0 | 0 |  | 0
3600 | 810 | 1 | 1 | 1 | 0 | 0 | 0 |  | 0
4800 | 810 | 1 | 1 | 1 | 0 | 1 | 0 |  | 0
4800 | 815 | 1 | 0 | 2 | 1 | 0 | 0 |  | 0
4800 | 825 | 0 | 3 | 0 | 1 | 0 | 0 |  | 0
4800 | 830 | 2 | 0 | 0 | 2 | 0 | 0 |  | 0