ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find the max number of objects to be placed on a surface (https://www.excelbanter.com/excel-discussion-misc-queries/450235-find-max-number-objects-placed-surface.html)

John[_149_]

Find the max number of objects to be placed on a surface
 
Hello to everybody,
is there an Excel formula to find the max objects can I fit on a certain area?

For example:
Obj Dim 1 = 22 cm
Obj Dim 2 = 30 cm

Area Dim 1 = 80 cm
Area Dim 2 = 120 cm

With
=Max(Int(80/22)*int(120/30);Int(80/30)*int(120/22)) the result is 12 pieces

However I can fit 13 pieces like:

(30+30+30+30) * 22 - first row (120cm - 4 pieces)
(30+30+30+30) * 22 - second row (120cm - 4 pieces)

then I rotate the object of 90°

(22+22+22+22+22) * 30 - third row (110 cm - 5 pieces)

I hope I have been able to explain my question and hope You guys can help me.
Regards
Gimmy


All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com