Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume that we have N boxes ( rectangular prism ) with various dimensions: width, length and height. You will have an input file which demonstrates
Assume that we have boxes rectangular prism with various dimensions:
width, length and height. You will have an input file which demonstrates all
three parameters of these boxes: Column A refers to the width, Column B refers
to the length and Column refers to the height of the box.
total number of boxes is less than
All dimensions of the boxes are all integers less than
Some of the sizes of different boxes can be same in terms of width or
length or height.
Here are example input data:
To create a set of intertwined boxes, you can put one box into another which
has a greater width, length and height If one of these is smaller or equal, you
can't In addition, you can just put the boxes into each other vertically. You
can't rotate the box in order to lay down the box. Height should always be the
vertical dimension.
Write a VBA code in Excel which calculates the highest number of boxes
which can be put into each other with the given data. Create a "Calculate"
button and show your answer in Cell E
For the first input above, you can't put the box into the or vice versa
because of the sizes. But you can put box into the or one to create
intertwined boxes. Also you can put box into the one. In this case you
have toys in total and your output should be
For the second input,
The highest number of boxes used to create a set of boxes is So the correct
output should be
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started