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.”
RogersWillex, Australia.
Top entries from this contest
-
yhf8377 Canada
-
pexelite Singapore
-
ginpasawa Philippines
-
ginpasawa Philippines
-
jaylancer43 India
-
fsac Turkey
-
yhf8377 Canada
-
shahhh69 India
-
markelof Bosnia and Herzegovina
-
nymengr Bangladesh
-
hopkovictoria Ukraine
-
MdFaisalS Bangladesh
-
DominikKrivarics Hungary
-
gladrich United Arab Emirates
-
irfantfq Indonesia
-
graAndWebPro Bangladesh
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!