Optimizing Cutting Length

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.
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
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
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
 
Upvote 0
Seems like a search of this Board has some potential solutions. HTH Dave
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
The name of the worksheet is wshCuts. Trial changing the sheet name. Dave
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

Forum statistics

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

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