Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of objects in a collection | Excel Programming | |||
Surface chart - number of catergories | Charts and Charting in Excel | |||
Find All Embedded Objects in Workbook | Excel Programming | |||
find picture objects | Excel Programming | |||
Find all running Excel Application objects | Excel Programming |