Generate unique combinations based on Dynamic Inputs. VBA Loop?.

DonKampfello

New Member
Joined
Apr 18, 2022
Messages
13
Office Version
  1. 365
Platform
  1. Windows
Dear MrExcel users

Link to a copy my spreadsheet:
My Combination Calculator

I own a small business that makes sustainable sewage piping.
The pipes a made from rolls of stiched glass-material that is procured in bulk with the width of 3,8 - 4 meters and lenght of 200 meters, depending on the supplier.

I cut these big rolls with industrial machinery in 31 different widths, sew them together and apply a hardening epoxy coat, according to the dimension requested from the costumer.

I have allready developed a Solver myself for finding the optimal cutting sequence for minimal waste of material. However, I need a tool that can calculate new cutting combinations in case I want to alter the widths of each dimension with a procentage change.
I seek a VBA loop or another method to help me generate new cutting combinations that I can insert into my solver. Is this possible? - I hope you can help me out.

Inputs to be concidered:
Blue - "B1": Possible procentage change in cutting width.
Red - "B2": Different basisroll widths in bulk delivered from the supplier (3,8m - 4m).
Yellow - "F2:AJ2": horizonal list of cutting widths and thier corresponding Pipe Dimension (Ø).

The green table: This is where I would like the macro to output the unique combinations. The existing data in the table is calculated manually, which is a very unfeasible process, hence this thread. The data is there to showcase the output im looking for.

Any suggestion in what kind of VBA loop that is needed for this taks, would be very appreaciated. Thanks


Link to a copy my spreadsheet:
My Combination Calculator

udklip combi.PNG
 
Last edited:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

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