![]() |
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