Excel box loading problem

[buitenhek]

Question: Can this application be done in Excel without using macros?

How many larger boxes are needed?
Designated size of all larger boxes = example 4 sq-units each (2x2)

Have the following
1. 4 smaller boxes 1x1
2. 4 smaller boxes 1x0.5
3. 12 smaller boxes 0.5x0.5
4. 17 smaller boxes 0.25x0.25

Answer: 3 larger boxes (2x2) with .75 sq-units (.25x3) remaining

The number & size of smaller boxes vary with every application. The larger box size varies with application but is known.

I am looking for optimal fill potential and number of larger box count. If this is possible in Excel (no macros)please steer (nudge) me in the right direction.

Any help is appreciated.


Regards
Peter Buitenhek
ProfitDeveloper.com

 

[SkipVought]

Peter,


you seem to be using rectangles
[tt]
4 * 1 * 1 = 4
4 * 1 * .5 = 2
12 * .5 * .5 = 3
17 * .25 * .25 = 1.0625
[/tt]
The SUM of the ares is 10.0625
[tt]
=INT([the sum]/4)
=MOD([the sum],4)
[/tt]
the results are 2 + 2.0625 or 3 rectangles with 0.515625 of a rectangle remaining.





Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}