Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linerar/integer programming problem
Hello, from maths pygmy.
I can describe this problem in words, but not put it into any mathematical form. Can someone help by suggesting a method for solving it with xl spreadsheet? A client of mine sells lengths of aluminium window parts at 6.5 m length. He has customers who want to buy it at various lengths, in various quantities, and want to reduce the amount of wastage. E.g.: 30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work out the smallest amount of 6.5 m lengths to buy to achieve this? (i.e. the least amount of wastage) Sorry for the lameness of the question, but he's a good client and thinks I'm a whizz with computers just because I design his web-site. I hate to disappoint. -- Ben (check my email address before sending) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linerar/integer programming problem
Well, i'm not really shure ....
but what about the formular: int(quantity * length / 6,5) + 1 = count of 6,5 pieces. Implement this formular in your spreadsheet. Does it meet your ideas ? Manfred -----Original Message----- Hello, from maths pygmy. I can describe this problem in words, but not put it into any mathematical form. Can someone help by suggesting a method for solving it with xl spreadsheet? A client of mine sells lengths of aluminium window parts at 6.5 m length. He has customers who want to buy it at various lengths, in various quantities, and want to reduce the amount of wastage. E.g.: 30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work out the smallest amount of 6.5 m lengths to buy to achieve this? (i.e. the least amount of wastage) Sorry for the lameness of the question, but he's a good client and thinks I'm a whizz with computers just because I design his web- site. I hate to disappoint. -- Ben (check my email address before sending) . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
linerar/integer programming problem
http://www.woodbin.com/docs/software...m#2D%20cutting
http://www.delphiforfun.org/Programs/CutList.htm -- John johnf202 at hotmail dot com "ben h" wrote in message ... Hello, from maths pygmy. I can describe this problem in words, but not put it into any mathematical form. Can someone help by suggesting a method for solving it with xl spreadsheet? A client of mine sells lengths of aluminium window parts at 6.5 m length. He has customers who want to buy it at various lengths, in various quantities, and want to reduce the amount of wastage. E.g.: 30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work out the smallest amount of 6.5 m lengths to buy to achieve this? (i.e. the least amount of wastage) Sorry for the lameness of the question, but he's a good client and thinks I'm a whizz with computers just because I design his web-site. I hate to disappoint. -- Ben (check my email address before sending) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
linerar/integer programming problem
Hi ben,
PLUS 1D - Bar nesting software for 1D stock cutting applications like cutting of pipes, bars, channels, extrusions, lengths etc, would be perfect for the job. There is a demo verison, that should be sufficient for small problems. http://www.nirvanatec.com/downloadcenter.html hope it helps, cheers, s.shrikanth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Binary integer non-linear programming excel solver premium | Excel Worksheet Functions | |||
Binary integer non-linear programming excel solver | Excel Discussion (Misc queries) | |||
Binary integer non-linear programming excel solver | Excel Worksheet Functions | |||
Binary integer non-linear programming excel solver premium | Excel Worksheet Functions | |||
Problem with Solver and Integer constraints | Excel Worksheet Functions |