Cutting Stock Optimization in Excel

Stav: Closed
Odměna: $100
Přijatých návrhů: 16
Vítěz: yhf8377

Winner

Instrukce k soutěži

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.

Doporučené dovednosti

Winner

Zadejte podobnou soutěž

Zpětná vazba od zaměstnavatele

“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.”

RogersWillex, Australia.

Nejlepší návrhy této soutěže

yhf8377 Canada

0
pexelite Singapore

0
ginpasawa Philippines

0
ginpasawa Philippines

0
jaylancer43 India

0
fsac Turkey

0
yhf8377 Canada

0
shahhh69 India

0
markelof Bosnia and Herzegovina

0
nymengr Bangladesh

0
hopkovictoria Ukraine

0
MdFaisalS Bangladesh

0
DominikKrivarics Hungary

0
gladrich United Arab Emirates

0
irfantfq Indonesia

0
graAndWebPro Bangladesh

0

Zobrazit více příspěvků

Veřejná nástěnka k vyjasnění projektu

irfantfq
- Před 5 let
Hello, CH.
Please check my new comment in entry #2 .

Thanks.
- Před 5 let
dullbenz
- Před 5 let
Hello, as we are to submit the entries as images, how will the testing go
- Před 5 let
1. Pořadatel soutěže
  - Před 5 let
  The site limits the submission file types, I have seen/used videos, spreadsheets and apps through attachments and links provided with submissions.
  - Před 5 let
irfantfq
- Před 5 let
Hello, CH.
Please rate and review entry #2 , so I'll know that it's what you want or not.

Thanks.
- Před 5 let
sayalikale28
- Před 5 let
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?
- Před 5 let
1. Pořadatel soutěže
  - Před 5 let
  We are looking for one optimal solution so that we can send cutting profiles to workers at a saw.
  - Před 5 let
AbdullahAltay
- Před 5 let
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?
- Před 5 let
1. Pořadatel soutěže
  - Před 5 let
  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.
  - Před 5 let
kanshowen
- Před 5 let
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
- Před 5 let
idrisakano
- Před 5 let
Kindly give some more time pls by extending the due date, if you could see to increaing the prize. Thanks #extended , #increaseprize
- Před 5 let
idrisakano
- Před 5 let
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
- Před 5 let
idrisakano
- Před 5 let
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.
- Před 5 let
ebeD1
- Před 5 let
I don't understand what exactly you need me to do. Can you please make your instructions a little bit clearer?
- Před 5 let
1. Pořadatel soutěže
  - Před 5 let
  Hi Ebenezer. Thanks for the feedback,I've updated the details.
  - Před 5 let