Optimizing Cutting Length

S

silentwolf

Well-known Member
Joined
May 14, 2008
Messages
1,216
Office Version
  1. 2016
Hi guys,

I have been looking into threads about cutting length here in the forum but not really found exactly what I am after or the issue I am having to get startet with a cutting optimizing tool.

Following situation:
There are different Profiles and different materials which need to be cut to size for several Projects.

On YouTube I found a good video of a similar issue.. but it misses a few things what would be required in my situation.


Stock Items like offcuts:
There are different lenght in Stock like offcuts from previous projects. For example: 3 pieces of 3250 mm of ProfileA, 25 pieces of 2000mm of ProfilB, and 30 pieces of full lenght of 6000mm of ProfileA and so on..

There are several projects to be cut to length :
Project_001:
12 pieces 1250mm ProfileA
10 pieces 1830mm ProfileB

Project_002:
5 pieces 2000mm ProfileA
8 pieces 1200mm ProfileB

And of course there is a cutting blade thikness of 5mm that needs to be taken to account

So is there a way of putting it all into Excel for the Stock Items and Cutting length of each Profile to optimize those cutting length?

Perhaps with Solver or via Code?

Great would be if it could work via VBA and with a GUI ..

Just not sure how to go about take all those variables into account to solve this situation.

Maybe someone could give some ideas on how to go about it?

For the Data I did also try to use Access but I guess for the calculations I would need Excel or Excel Solver or OpenSolver ?


Many thanks

Albert
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
Hi guys,

I have looked further into my issue and came accross Dynamic programming which looks promising for the issue descriped above.

Maybe I be able to put something together with that approach )

Cheers
 
Upvote 0
silentwolf said:
Hi guys,

I have been looking into threads about cutting length here in the forum but not really found exactly what I am after or the issue I am having to get startet with a cutting optimizing tool.

Following situation:
There are different Profiles and different materials which need to be cut to size for several Projects.

On YouTube I found a good video of a similar issue.. but it misses a few things what would be required in my situation.


Stock Items like offcuts:
There are different lenght in Stock like offcuts from previous projects. For example: 3 pieces of 3250 mm of ProfileA, 25 pieces of 2000mm of ProfilB, and 30 pieces of full lenght of 6000mm of ProfileA and so on..

There are several projects to be cut to length :
Project_001:
12 pieces 1250mm ProfileA
10 pieces 1830mm ProfileB

Project_002:
5 pieces 2000mm ProfileA
8 pieces 1200mm ProfileB

And of course there is a cutting blade thikness of 5mm that needs to be taken to account

So is there a way of putting it all into Excel for the Stock Items and Cutting length of each Profile to optimize those cutting length?

Perhaps with Solver or via Code?

Great would be if it could work via VBA and with a GUI ..

Just not sure how to go about take all those variables into account to solve this situation.

Maybe someone could give some ideas on how to go about it?

For the Data I did also try to use Access but I guess for the calculations I would need Excel or Excel Solver or OpenSolver ?


Many thanks

Albert
Click to expand...
I've been thinking about this.

How many projects do you have on the go at the same time?

Is there a minimum length that you need to leave as an offcut?

How small a length is it likely that you may use in the future?

Are you able to mark offcuts so that you can easily find the right one?
 
Upvote 0
Hi,
there are about 4 to five projects that need to be managed for a day.

What I have been thinking of is to put the stock present in a database to track it.
If the orders come in I like to check if there are those lenght in stock..

The oders for future project are not known but it is likely that below 1000mm are not able to be used for future projects.

The offcuts I would also keep in the database with a StockLocation so I could use it again easily.

But for the calculation I did try different things one way of thinking about it was to keep create objects for StockItems and an object for OrderItems.

So two classes representing, ProfileType, Lenght, Amount one clsStockItems, clsOrderItems

Keep the StockItems in a database and create arrays to fill the Klass Object and the same for OrdterItems Object.

And then somehow compare those two arrays to find the Profile and Length with the least amout of offcut.

Not sure if that would be a way of going about it.. Talked to a friend of mine which is a programmer and he thought about that way of doing it.
 
Upvote 0
Seems like a search of this Board has some potential solutions. HTH Dave
www.mrexcel.com

Optimized Cut List

I managed to find this nice simple cut list optimizer macro that someone made. It was on another forum site, and I can't find the original post to save my life. Original file was called BoardFeet. I'm not that well versed in VBA code, but I'm trying to figure out a way to output the cut...
www.mrexcel.com www.mrexcel.com
 
Upvote 0
NdNoviceHlp said:
Seems like a search of this Board has some potential solutions. HTH Dave
www.mrexcel.com

Optimized Cut List

I managed to find this nice simple cut list optimizer macro that someone made. It was on another forum site, and I can't find the original post to save my life. Original file was called BoardFeet. I'm not that well versed in VBA code, but I'm trying to figure out a way to output the cut...
www.mrexcel.com www.mrexcel.com
Click to expand...
Hi Dave,

yes I did not forget to search the board and found also different threads.

I have seen this one before but can not quite understand what you need to fill out in what worksheet to get the solutions.

InpStock seams to be a named list.

VBA Code: 
    'Make sure cuts have been entered
    If rLastEntry.Address = "$A$1" Then
        Exit Sub
    Else
        Set rInputCuts = wksCuts.Range("A2", rLastEntry.Address).Resize(, 2)
        lRowCount = rInputCuts.Rows.Count
    End If

What is that suppose to mean and what worksheet should I put it into

Currently I got following:
I did create a worksheet with worksheet Name "Cuts" and codeName wksCuts. and update the code accordingly

In Range A of that worksheet I have StockSizes from A1: A6 in the same worksheet I have in Range B1:B6 Required Sizes. No headers!

I have difficulties to understand the code without seeing what information need to be inserted into the worksheets to make this Code run.

Maybe someone could spot what this code does and what Info need to be inserted into what Worksheet.

Cheers
 
Upvote 0
NdNoviceHlp said:
The name of the worksheet is wshCuts. Trial changing the sheet name. Dave
Click to expand...
Hi Dave,

well as I am always calling my worksheets wks I changed it to wksCuts

And of course the code too!

However but what I am suppose to insert into the worksheet?

in wksCuts range "A" all the Sizes needet? And where the sizes I have?

And what does 'Make sure cuts have been entered mean in Range A1

it is difficult not seeing any data just code ..
 
Upvote 0
http://dailydoseofexcel.com/archives/author/****-kusleika/page/120/
Scroll down and it shows where to put the input info and you can down load the file if you want. Dave
edit replace the **** with "D"I"C"K" without the parenthesis in the URL
 
Upvote 0
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
Optimized Cut List
Replies
9
Views
7K
Cuprian
C
S
  • Question
Stock Length Cut Optimizer
Replies
4
Views
9K
J.Ty.
J.Ty.
cmondeau
  • Question
1D Optimization Using VBA
2
Replies
12
Views
11K
cmondeau
cmondeau
B
  • Question
Interesting puzzle: optimum stock lengths
Replies
3
Views
405
shg
shg

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top