Results 1 to 10 of 10

Best yield from table

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2008
    Location
    uk
    Posts
    18

    Best yield from table

    Hi,

    I have a table with 2 columns for raw material (Length and Width) and i have two seperate cells for product size also called length and width. What i'm trying to do is input my product size which will then return the best fit raw material by the least amount of waste. This would be applicable to multiples. For example:

    Product Size (input)
    lenght Width
    600 300

    Raw Material Size (table)
    Length Width
    500 230
    1220 310
    1000 310
    1900 350
    1850 310

    Result
    Length Width
    1220 310

    The above result would be the correct answer as you would get 2 products from the one sheet of raw material with the least amount of waste. Hope this makes sense

    I would really appreciatre some help/advice. I've attached my workings so far.

    Thanks in advance
    Attached Files Attached Files
    Last edited by sleazyfish; 09-08-2010 at 09:41 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1