Results 1 to 2 of 2

Optimize number of cuts of various lengths from a given length

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2017
    Location
    Orange, CA
    MS-Off Ver
    2010
    Posts
    14

    Optimize number of cuts of various lengths from a given length

    I need some help in finding the best way to determine how many cuts of a variety of sizes can be achieved from a longer length. The goal would be to have the remainder of the longer length as close to zero as possible.

    For example...

    I have a board at 563.625" long
    There are four possible chop lengths to come from that board... 78.3125", 62.625", 86.625" and 55.5"
    How many chops of each length can I achieve from 563.625"

    Note: I do not have to use all chop sizes from the length of the board. I am looking for varying combinations with minimal loss.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Raw Material Length selection to optimize wastage
    By Jeff_badz2 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-12-2022, 12:48 PM
  2. [SOLVED] number of consecutive lengths in a month of all year
    By Rohith A N in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-17-2021, 08:16 PM
  3. Replies: 1
    Last Post: 09-19-2013, 08:32 AM
  4. Optimize Cut Lengths
    By opister in forum Excel General
    Replies: 26
    Last Post: 08-26-2011, 07:09 AM
  5. Optimize Rod Cut Lengths
    By Ari88 in forum Excel General
    Replies: 0
    Last Post: 08-25-2011, 10:40 AM
  6. 0 as first number (cannot be text and # lengths very)
    By saveonusedtires in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-18-2011, 04:13 PM

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