doctorhifi
New Member
- Joined
- Aug 13, 2013
- Messages
- 19
Let’s say I have endless sheets of wood that each measure 48” wide x 96” long.
And out of those sheets I am trying to cut strips that are various widths but always the same length so I am always cutting the sheets along the long dimension.
The quantity of strips as well as the width of each strip will vary but there would never be more than 100 strips needed.
Example:
I need (4) strips that are 24.5” wide
I need (3) strips that are 17.33” wide
I need (3) strips that are 36” wide
I need (2) strips that are 6” wide
Etc, etc.
-I am trying to create a VBA formula that would look at all of the quantities and widths of strips and determine how many 48x96 sheets I would need in total.
-It would need to look at all the strips and group them together in order to reduce waste.
-It would need to report which strips were coming from each sheet, something like this:
Sheet #1= (1 of 4) @ 24.5” + (1 of 3) @ 17.33” + (1 of 2) @ 6”
Sheet #2= (2 of 4) @ 24.5” + (2 of 3) @ 17.33” + (2 of 2) @ 6”
Sheet #3= (3 of 4) @ 24.5” + (3 of 3) @ 17.33”
Sheet #4= (4 of 4) @ 24.5”
Sheet #5= (1 of 3) @ 36” W
Sheet #6= (2 of 3) @ 36” W
Sheet #7= (3 of 3) @ 36” W
Total sheets needed= 7
I've been unable to figure out how to do this using the Solver plug-in and would actually prefer to not use Solver if possible.
My VBA skills are embarrassing so I don't even have the start of a subroutine to share.
Thanks
And out of those sheets I am trying to cut strips that are various widths but always the same length so I am always cutting the sheets along the long dimension.
The quantity of strips as well as the width of each strip will vary but there would never be more than 100 strips needed.
Example:
I need (4) strips that are 24.5” wide
I need (3) strips that are 17.33” wide
I need (3) strips that are 36” wide
I need (2) strips that are 6” wide
Etc, etc.
-I am trying to create a VBA formula that would look at all of the quantities and widths of strips and determine how many 48x96 sheets I would need in total.
-It would need to look at all the strips and group them together in order to reduce waste.
-It would need to report which strips were coming from each sheet, something like this:
Sheet #1= (1 of 4) @ 24.5” + (1 of 3) @ 17.33” + (1 of 2) @ 6”
Sheet #2= (2 of 4) @ 24.5” + (2 of 3) @ 17.33” + (2 of 2) @ 6”
Sheet #3= (3 of 4) @ 24.5” + (3 of 3) @ 17.33”
Sheet #4= (4 of 4) @ 24.5”
Sheet #5= (1 of 3) @ 36” W
Sheet #6= (2 of 3) @ 36” W
Sheet #7= (3 of 3) @ 36” W
Total sheets needed= 7
I've been unable to figure out how to do this using the Solver plug-in and would actually prefer to not use Solver if possible.
My VBA skills are embarrassing so I don't even have the start of a subroutine to share.
Thanks