+ Reply to Thread
Results 1 to 1 of 1

Cut optimizer variation - help

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    Grand Forks BC Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cut optimizer variation - help

    I am in the flooring business and have created a spreadsheet that has been a work in progress. I use it to calculate material quantities needed for quoting projects
    This sheet was initially for one type of product that is one length. I am trying to make it adaptable to different lengths of material that will be cut into specific lengths. I want to determine how many lengths to order.

    J44 is the start point. This is where the length of the material to be cut is entered. All material to be cut is the same length.
    J50 is the number of pieces needed cut to the length enter in J51. The number of pieces to order is displayed in K32
    Where I get stuck is when additional pieces are needed D53 (the length) & F53 (the number of pieces)
    I have looked at some cut optimizer formulas but they are all to complex for what I need.

    I just noticed that some of the formulas are point to the wrong cells. I changed the layout and forgot to correct the cells in some of the formulas. If you see this before I repost the corrected sheet my apologies.
    Hard surface2.xlsx
    Last edited by ernieprommer; 03-17-2014 at 02:11 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 08-30-2014, 01:41 PM
  2. Round Robin Optimizer with Flexibility for tardiness
    By taninu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2013, 01:29 AM
  3. LOOK UP with variation
    By dcthunna in forum Excel General
    Replies: 2
    Last Post: 07-18-2011, 11:07 AM
  4. IF(AND) variation
    By JO505 in forum Excel General
    Replies: 6
    Last Post: 06-08-2011, 08:29 AM
  5. Solver error when running an optimizer
    By jerseyguy1996 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2009, 10:17 AM

Tags for this Thread

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