Cutting Stock Optimization in Excel

  • Status: Closed
  • Prize: $100
  • Entries Received: 16
  • Winner: yhf8377

Contest Brief

I have a simple process automation task that I'd like solved.

Attached you will find a cutting list with 3 material types, the various lengths that need to be cut, and the length that each material is available in.
I need to automate the process for determining cutting profiles to eliminate waste.
This is known as the Cutting Stock Problem: https://en.wikipedia.org/wiki/Cutting_stock_problem

The best entries will allow for different materials and lengths.

EDIT: Some entries have performed well and have begun testing with a more complex cutting list, please see attached.
EDIT: In response to some queries, submissions that can import a spreadsheet, calculate, then export to a spreadsheet are also within the bounds of the contest.

Recommended Skills

Employer Feedback

“Frank over-delivered in every respect. In a tough competition, Frank produced stand-out work with incredible follow-through. I'll be actively seeking to work with him again.”

Profile image RogersWillex, Australia.

Top entries from this contest

View More Entries

Public Clarification Board

  • irfantfq
    irfantfq
    • 5 years ago

    Hello, CH.
    Please check my new comment in entry #2 .

    Thanks.

    • 5 years ago
  • dullbenz
    dullbenz
    • 5 years ago

    Hello, as we are to submit the entries as images, how will the testing go

    • 5 years ago
    1. RogersWillex
      Contest Holder
      • 5 years ago

      The site limits the submission file types, I have seen/used videos, spreadsheets and apps through attachments and links provided with submissions.

      • 5 years ago
  • irfantfq
    irfantfq
    • 5 years ago

    Hello, CH.
    Please rate and review entry #2 , so I'll know that it's what you want or not.

    Thanks.

    • 5 years ago
  • sayalikale28
    sayalikale28
    • 5 years ago

    Hello, as there will be more than one combination for waste minimization, i want to know the exact requirement.Is it one automated excel sheet that will provide you more than one optimal solution? or you want only one optimal solution?

    • 5 years ago
    1. RogersWillex
      Contest Holder
      • 5 years ago

      We are looking for one optimal solution so that we can send cutting profiles to workers at a saw.

      • 5 years ago
  • AbdullahAltay
    AbdullahAltay
    • 5 years ago

    Hello, do you have unlimited material? Or do you want to cut the minimum material? What I understand is, it doesn't matter how many materials are cut. It is important only minimal waste. If so, why did you give various quantity to cut?

    • 5 years ago
    1. RogersWillex
      Contest Holder
      • 5 years ago

      Hi Abdullah. In practice, we are always able to source more material, the objective is to optimise cutting profiles to use the overall material efficiently. We use materials in various applications at one time, resulting in varied lengths to be cut from the same bar.

      • 5 years ago
  • kanshowen
    kanshowen
    • 5 years ago

    Hi, What is the Maximum width of the master roll . As one of your width say 6000 mm . As per link max width 5600 mm . requesting your clarification

    • 5 years ago
  • idrisakano
    idrisakano
    • 5 years ago

    Kindly give some more time pls by extending the due date, if you could see to increaing the prize. Thanks #extended , #increaseprize

    • 5 years ago
  • idrisakano
    idrisakano
    • 5 years ago

    Hi sir, may i humbly request #increaseprize

    The task is more challenging and interesting than i expected. I should have a good and flexible solution for your long term use by tomorrow.

    Thank you

    • 5 years ago
  • idrisakano
    idrisakano
    • 5 years ago

    Hi,
    I can make for you a perfect excel workbook that simplifies and automate the task. You should get my entry by 10:00 GMT when i am fully online.

    • 5 years ago
  • ebeD1
    ebeD1
    • 5 years ago

    I don't understand what exactly you need me to do. Can you please make your instructions a little bit clearer?

    • 5 years ago
    1. RogersWillex
      Contest Holder
      • 5 years ago

      Hi Ebenezer. Thanks for the feedback,I've updated the details.

      • 5 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!