Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of objects in a collection CK Excel Programming 4 April 14th 08 02:06 AM
Surface chart - number of catergories Captain_Awesome[_2_] Charts and Charting in Excel 1 February 14th 08 02:18 AM
Find All Embedded Objects in Workbook Andibevan Excel Programming 9 February 10th 06 04:18 PM
find picture objects Dave B[_3_] Excel Programming 4 October 21st 05 03:46 AM
Find all running Excel Application objects news.bluewin.ch Excel Programming 3 February 13th 04 10:28 PM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"