Boy this is a hard one to spell out in a title. Here's what I'm trying to do.
I have a circle. Inside this circle are several rectangles that are all the same size. I also have an array that contains a matrix of these rectangles. The array has several options:
Option 1: Single row, multiple columns
Option 2: Multiple rows, multiple columns
Option 3: Single rectangle stretched across several columns (Diagonal)
Things I know:
1. Size of the Circle
2. Length and width of each rectangle
2. Array configuration (3x2, 2x8, Diagonal x7)
I need a formula that can do the following:
1. Determine how many rectangles can fit into the circle
2. Determine how many times the array will be used to touch each rectangle one time (touching outside the circle is fine, so long as the entire array is not outside the circle).
Hopefully, this makes sense. I'll try to clarify however I can.
NOTE: I have posted this question in two other forums. My apologies for cross-posting; I am new to forums and didn't know the etiquette.
http://www.ozgrid.com/forum/showthread.php?t=90395
http://www.mrexcel.com/forum/showthread.php?t=317460
Bookmarks