Spreadsheet: 66429d1267088674-first-sort-then-use-subtotals-order-plan-new
Sheet: Order

DATE | ORDER# | CUSTOMER | SHADE | ARTICLE |  |  |  | "BRAND" | CONES TO PRODUCE | REQD KILOS | PLANNED KILOS | LOT #
. | . | . |  | TEX | LENGTH | QUALITY | COUNT
25.02.10 | 26995+6+7+8 | ATRACO | SP-27603 |  | 5000Y | SSP | 40/2 | BOAT | 320 | 42.56 | 43.5 | 127881
 |  |  | SP-27603 |  | 3000Y | SSP | 20/2 | BOAT | 257 | 43.176 | 43.5 | 127882
 |  |  | SP-22008 |  | 5000Y | SSP | 40/2 | BOAT | 309 | 41.097 | 42 | 127883
 |  |  | SP-21494 |  | 5000Y | SSP | 40/2 | BOAT | 4714 | 626.962 | 627 | 127884A-C
 |  |  | SF-524 |  | 5000Y | SSP | 40/2 | BOAT | 5795 | 770.735 | 771 | 127885A-D
 |  |  | SF-397 |  | 3000Y | SSP | 20/2 | BOAT | 198 | 33.264 | 34.5 | 127886
 |  |  | SF-397 |  | 5000Y | SSP | 40/2 | BOAT | 392 | 52.136 | 52.5 | 127887
 |  |  | SP-22008 |  | 3000Y | SSP | 20/2 | BOAT | 221 | 37.128 | 37.5 | 127888
 |  |  | SP-21494 |  | 3000Y | SSP | 20/2 | BOAT | 3618 | 607.8240000000001 | 607.5 | 127889A-C
 |  |  | SP-17956 |  | 2000Y | SSP | 20/3 | BOAT | 6540 | 1079.1 | 1080 | 127890A-E
 |  |  | SF-219 |  | 3000Y | SSP | 20/2 | BOAT | 1439 | 241.752 | 243 | 127891A-B
 |  |  | SP-5222 |  | 5000Y | SSP | 40/2 | BOAT | 227 | 30.191 | 30 | 127892
 |  |  | SF-219 |  | 5000Y | SSP | 40/2 | BOAT | 1890 | 251.37 | 252 | 127893A-B
 |  |  | SF-394 |  | 5000Y | SSP | 40/2 | BOAT | 2431 | 323.323 | 324 | 127894A-B
 |  |  | SF-790 |  | 5000Y | SSP | 40/2 | BOAT | 3019 | 401.527 | 402 | 127895A-B
 |  |  | SF-790 |  | 3000Y | SSP | 20/2 | BOAT | 1949 | 327.432 | 328.5 | 127896A-B
 |  |  | SF-394 |  | 3000Y | SSP | 20/2 | BOAT | 1557 | 261.576 | 262.5 | 127897
 |  |  | B001 |  | 3000Y | SSP | 20/2 | BOAT | 189 | 31.752 | 45 | 127898
 |  |  | SP-5222 |  | 2000Y | SSP | 20/3 | BOAT | 3702 | 610.83 | 615 | 127899A-C
 |  |  | SF-840 |  | 3000Y | SSP | 20/2 | BOAT | 3034 | 509.712 | 510 | 127900A-C
 |  |  | SP-23568 |  | 5000Y | SSP | 40/2 | BOAT | 1974 | 262.542 | 262.5 | 127901A-B
 |  |  | SF-154 |  | 5000Y | SSP | 40/2 | BOAT | 312 | 41.496 | 42 | 127902
 |  |  | SF-840 |  | 5000Y | SSP | 40/2 | BOAT | 1356 | 180.348 | 181.5 | 127903
 |  |  | SP-17956 |  | 5000Y | SSP | 40/2 | BOAT | 1363 | 181.279 | 181.5 | 127904
 |  |  | SF-837 |  | 5000Y | SSP | 40/2 | BOAT | 2634 | 350.322 | 351 | 127905A-B
 |  |  | SP-23568 |  | 3000Y | SSP | 20/2 | BOAT | 2275 | 382.2 | 382.5 | 127906A-B
 |  |  | SF-837 |  | 3000Y | SSP | 20/2 | BOAT | 2013 | 338.184 | 339 | 127907A-B
 |  |  | SP-27602 |  | 5000Y | SSP | 40/2 | BOAT | 953 | 126.749 | 127.5 | 127908
 |  |  | SP-27601 |  | 5000Y | SSP | 40/2 | BOAT | 764 | 101.612 | 102 | 127909
 |  |  | SP-26433 |  | 5000Y | SSP | 40/2 | BOAT | 385 | 51.20500000000001 | 52.5 | 127910
 |  |  | SF-839 |  | 5000Y | SSP | 40/2 | BOAT | 577 | 76.741 | 78 | 127911
 |  |  | SF-249 |  | 5000Y | SSP | 40/2 | BOAT | 1145 | 152.285 | 153 | 127912
25.02.10 | 26971 | MALIBAN | SP-26691 |  | 3000M | SSP | 60/2 | SILVER FALCON | 201 | 12.462 | 13.5 | 127913 | NAVY
 |  |  | SP-26684 |  | 3000M | SSP | 60/2 | SILVER FALCON | 347 | 21.514 | 22.5 | 127914 | STRING
 |  |  | SP-26687 |  | 3000M | SSP | 60/2 | SILVER FALCON | 225 | 13.95 | 15 | 127915 | KHAKI
 |  |  | SP-26688 |  | 3000M | SSP | 60/2 | SILVER FALCON | 224 | 13.888 | 15 | 127916 | BLACK
 |  |  | SP-26684 |  | 3000M | PP | 45/2 | SILVER FALCON | 189 | 15.498 | 16.5 | 127917 | STRING
 |  |  | SP-26691 |  | 3000M | PP | 45/2 | SILVER FALCON | 116 | 9.512 | 10.5 | 127918 | NAVY
 |  |  | SP-26687 |  | 3000M | PP | 45/2 | SILVER FALCON | 122 | 10.004 | 10.5 | 127919 | KHAKI
 |  |  | SP-26688 |  | 3000M | PP | 45/2 | SILVER FALCON | 112 | 9.184000000000001 | 10.5 | 127920 | BLACK
25.02.10 | 27000 | YUNUS | AS-28063 |  | 5000M | SSP | 40/3 | SILVER FALCON | 60 | 13.5 | 13.5 | 127921 | C-7932
25.02.10 | 26974 | US APP | SF-2583 |  | 5000M | SSP | 40/2 | BOAT | 4 | 0.58 | 1.5 | 127922 | G-977
 |  |  | SP-28071 |  | 5000M | SSP | 40/2 | BOAT | 4 | 0.58 | 1.5 | 127923 | DULL GREY
 |  |  | SF-2583 |  | 3000M | SSP | 20/2 | BOAT | 4 | 0.736 | 1.5 | 127924 | G-977
 |  |  | SF-2583 | TEX150 | 2000M | SSP | 12/3 | BOAT | 10 | 3.09 | 4.5 | 127925 | G-977
 |  |  | SP-28071 | TEX150 | 2000M | SSP | 12/3 | BOAT | 8 | 2.472 | 3 | 127926 | DULL GREY
25.02.10 | 26968 | US APP | SF-507 |  | 3000M | SSP | 20/2 | BOAT | 116 | 21.344 | 22.5 | 127927
 |  |  | SF-507 | TEX150 | 2000M | SSP | 12/3 | BOAT | 298 | 92.082 | 93 | 127928
25.02.10 | 26993 | AMBATTUR B | [NAME] | TEX24 | 5000M | PP | 45/2 | PLAIN STICKER | 16 | 2.176 | 3 | 127929
 |  |  | AS-25023 | TEX27 | 5000M | SSP | 60/3 | PLAIN STICKER | 62 | 9.61 | 10.5 | 127930
 |  |  | AS-25023 | TEX30 | 5000M | PP | 40/2 | PLAIN STICKER | 13 | 1.976 | 3 | 127931
 |  |  | AS-27155 | TEX27 | 5000M | SSP | 60/3 | PLAIN STICKER | 500 | 77.5 | 78 | 127932
 |  |  | AS-27155 | TEX30 | 5000M | PP | 40/2 | PLAIN STICKER | 321 | 48.792 | 49.5 | 127933
 |  |  | AS-27155 | TEX60 | 3000M | PP | 29/3 | PLAIN STICKER | 4 | 0.796 | 1.5 | 127934
 |  |  | AS-27155 | TEX80 | 3000M | PP | 16/2 | PLAIN STICKER | 134 | 30.284 | 30 | 127935
 |  |  | AS-27157 | TEX27 | 5000M | SSP | 60/3 | PLAIN STICKER | 2249 | 348.595 | 349.5 | 127936A-B
 |  |  | AS-27157 | TEX30 | 5000M | PP | 40/2 | PLAIN STICKER | 1092 | 165.984 | 166.5 | 127937
 |  |  | AS-27157 | TEX60 | 3000M | PP | 29/3 | PLAIN STICKER | 119 | 23.681 | 24 | 127938
 |  |  | AS-27157 | TEX80 | 3000M | PP | 16/2 | PLAIN STICKER | 221 | 49.946 | 51 | 127939
 |  |  | AS-27977 | TEX27 | 5000M | SSP | 60/3 | PLAIN STICKER | 2039 | 316.045 | 316.5 | 127940A-B
 |  |  | AS-27977 | TEX30 | 5000M | PP | 40/2 | PLAIN STICKER | 814 | 123.728 | 124.5 | 127941
 |  |  | AS-27977 | TEX60 | 3000M | PP | 29/3 | PLAIN STICKER | 167 | 33.233 | 34.5 | 127942
 |  |  | [NAME] | TEX24 | 5000M | PP | 45/2 | PLAIN STICKER | 9 | 1.224 | 1.5 | 127943
 |  |  | AS-28158 | TEX27 | 5000M | SSP | 60/3 | PLAIN STICKER | 12 | 1.86 | 3 | 127944
 |  |  | AS-28158 | TEX30 | 5000M | PP | 40/2 | PLAIN STICKER | 6 | 0.9119999999999999 | 1.5 | 127945
 |  |  | AS-28159 | TEX30 | 5000M | PP | 40/2 | PLAIN STICKER | 6 | 0.9119999999999999 | 1.5 | 127946
25.02.10 | 26999 | CENTURY | AS-26863 | TKT80 | 5000M | CP | 29/2 | SILVER FALCON | 50 | 10.4 | 10.5 | 127947
 |  |  | AS-26864 | TKT80 | 5000M | CP | 29/2 | SILVER FALCON | 50 | 10.4 | 10.5 | 127948
 |  |  | SF-WHT | TKT80 | 5000M | CP | 29/2 | SILVER FALCON | 50 | 10.4 | 10.5 | 127949
 |  |  | AS-27223 | TKT80 | 5000M | CP | 29/2 | SILVER FALCON | 50 | 10.4 | 10.5 | 127950
 |  |  | AS-26866 | TKT80 | 5000M | CP | 29/2 | SILVER FALCON | 50 | 10.4 | 10.5 | 127951
 |  |  | AS-26865 | TKT80 | 5000M | CP | 29/2 | SILVER FALCON | 50 | 10.4 | 10.5 | 127952
 |  |  |  |  |  |  |  |  |  |  |  | 127953
 |  |  |  |  |  |  |  |  |  |  |  | 127954