DonKampfello
New Member
- Joined
- Apr 18, 2022
- Messages
- 13
- Office Version
- 365
- Platform
- 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
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
Last edited: