Answered step by step
Verified Expert Solution
Link Copied!

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 N 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 C refers to the height of the box.
N, total number of boxes is less than 10.
All 3 dimensions of the boxes are all integers less than 100cm.
Some of the sizes of different boxes can be same in terms of width or
length or height.
Here are 2 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 E2.
For the first input above, you can't put the 2nd box into the 1st or vice versa
because of the sizes. But you can put 4th box into the 1st or 2nd one to create
intertwined boxes. Also you can put 3rd box into the 4th one. In this case you
have 3 toys in total and your output should be 3.
1st>4th>3thor2nd>4th>3th
For the second input, 4th>1st>3rd>5th
The highest number of boxes used to create a set of boxes is 4. So, the correct
output should be 4.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

=+(f2-tf1) du 0, since the integrand is nonnegative.

Answered: 1 week ago