Help w/ Finding Cut Optimization in Excel

[m3ko]

Hello everyone,

Wondering if there is a solution in excel to help make things quicker and simpler.
Often times, I need to determine how many materials I need to make certain quantities of smaller items.
I would first have to find out the total material required and then the distribution.
Is there a way in Excel, both with just formulae (Solver?) or using VBA?
Including an illustration of what I need help with below.

Also, where do folks usually go to learn about all this?
Thank you so much everyone.
All the best.

It would be nice to be able to just enter the sizes and quantities I need, and it'll auto calcualte how many bars are required and the distribution.

FULL BAR

CUT

CUT

CUT

CUT

CUT

CUT

CUT

CUT

REMAINING

Size:

38.79​

37.04​

29.04​

26.79​

Bar #

1​

2​

3​

4​

5​

6​

7​

8​

Qty:

14​

42​

28​

14​

1​

240​

38.79​

38.79​

38.79​

38.79​

38.79​

38.79​

7.26​

6​

2​

240​

38.79​

38.79​

38.79​

38.79​

38.79​

38.79​

7.26​

6​

3​

240​

38.79​

38.79​

37.04​

37.04​

29.04​

29.04​

29.04​

1.22​

2​

2​

3​

4​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

5​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

6​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

7​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

8​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

9​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

10​

240​

37.04​

37.04​

37.04​

37.04​

37.04​

26.79​

26.79​

1.22​

5​

2​

11​

240​

37.04​

37.04​

37.04​

37.04​

29.04​

29.04​

29.04​

4.72​

4​

3​

12​

240​

37.04​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

28.72​

1​

3​

13​

240​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

7.68​

8​

14​

240​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

29.04​

7.68​

8​

15​

240​

29.04​

29.04​

29.04​

152.88​

3​

 

[NdNoviceHlp]

Hi *m3ko and Welcome to the Board! Perhaps this link will help. Dave

Optimizing Cutting Length

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

www.mrexcel.com

 

[m3ko]

Hi *m3ko and Welcome to the Board! Perhaps this link will help. Dave

Optimizing Cutting Length

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

www.mrexcel.com

Thanks so much for the link.
I really apologize - need to also be better at searching the forums as well.
Will go through your linked thread and give it a go. Could I leave this open until I have it working in the meantime? Not sure yet if this might be too complex for me.
Thank you again!

 

[m3ko]

Thanks again Dave,
will close this thread and continue off from:

Optimizing Cutting Length

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

www.mrexcel.com

 

[NdNoviceHlp]

You are welcome. I hope that the linked routine will work for you. Thanks for posting your outcome. Dave