Results 1 to 2 of 2
  1. #1
    blindmanson is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2020
    Posts
    1

    best fit scenario


    Hi, I manufacture products of various lengths, which are cut from a 5m length item. eg 5m length has a 1.2m and a 2.8m cut from it, leaving a surplus of 1.0m. I could have a length .9m which fits the 1.0 surplus, however, if a need a 0.6m length,then its best to use a fresh 5m length as 0.4m would be unsuitable to leave as waste. How can I incorporate this in vba code for it to work in access. I was told it was a "Best fit" scenario, but cant find anything on google, unless I have used the wrong search term. Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,930
    Check out youtube for best fit bin packing

    Here's a link to firstfit and first fit decreasing algorithms.

    Instead off packing into a bin, you are cutting from a given length of stock.

    I found a link to a similar question that may be of some help.
    Good luck.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Which approach is best in my scenario
    By OBTech in forum Database Design
    Replies: 3
    Last Post: 08-16-2018, 10:08 AM
  2. Please help with this scenario
    By irfanparbatani in forum Macros
    Replies: 5
    Last Post: 08-14-2014, 04:43 PM
  3. Comfusing Scenario
    By WAWA in forum Database Design
    Replies: 1
    Last Post: 04-30-2010, 10:49 AM
  4. Scenario help
    By RadBrad in forum Access
    Replies: 3
    Last Post: 08-02-2009, 10:35 PM
  5. Can I UseTabs in This Scenario?
    By skyrise in forum Forms
    Replies: 0
    Last Post: 03-06-2009, 11:10 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums