Cutting problem COUNTIF function.xlsxCutting problem ROUNDUP function.xlsxCutting problem COUNTIF function.xlsxCutting problem ROUNDUP function.xlsxHello all,
Currently we are bussy with a project in which we need to find the optimal cutting solution.
We are working for a fictional company that produces steel rolls. Each of the rolls need to subject to certain constraints that can differ by each order.
In this particular example the fictional company has 5 rolls that weight respectively: 6, 15, 22, 26, 28 tons. These rolls need to be cut up to rolls that weigh between 12 to 15 tons. This means that some rolls need to be welded together. Each welded roll can only have one weld joint.
We have succeeded in formulating the constraints that seeks the optimal solution in which the begin rolls can be cut between the bounderies of 12 to 15 tons. But are unable to formulate a constraint for the welding joint (which can only be one in this case).
We have tried to use the function COUNTIF but we found out that the all the IF function are not compatible with the "excel solver". We tried using a different approach which was deviding each individual "changable variable cell" by its own value + 0.01 and rounding the answer up (since you cannot divide by zero, and you only can weld 2 plates together so each column of the changable variable cells will have a zero in them). This approach did also not work.
Our question there for is how to approach the welding problem?
IF you have any questions regarding this problem then please let me know!
Kind regards & Thanks in advance,
Mauzzzzzzz,
Attachment1 with the COUNTIF function:
Attachment2 with the ROUNDUP function:
Bookmarks