Optimization

G

Guest

I would like to make a function what is optimising the lenght of line segment.
Example: I have aluminium rail 3000mm and I have different ordered lenghts what I need to cut from whole rail. So, to get maximum usefullness I need to calculate the best way how to cut it.

Please give anybody some suggestion about my problem.

See you,
 
D

Dana DeLouis

Using Excel's Solver might be one way. Check out "CutStock" here.

http://www.solver.com/proframe.htm

Good luck. :>) HTH
Dana DeLouis


daddy said:
I would like to make a function what is optimising the lenght of line segment.
Example: I have aluminium rail 3000mm and I have different ordered lenghts
Click to expand...
what I need to cut from whole rail. So, to get maximum usefullness I need to
calculate the best way how to cut it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to have a formula 1
Text function 3
re-arrange data in date order 1
How to Determine group of numbers best fit into 1 number 1
to calculate numbers upwards to the nearest 300 and then to group 4
Date formula resulting in Year, Months & days 3
Validation Rule and Calculating Average HELP 2
Dynamic programming in Excel 0

Top