I a math question, that I hope someone can help me with.
I have 342 Squares sized at 11 x 11 cm and need to calculate how to pack them in a circle and find out how large the circle must be to pack them all in and my math skills are coming to a short here, so wonder if anyone here have a good hint to how I can solve this, without having to cut out 342 pieces of paper and start packing them.
Hopefully there is somehow an easy formular that can be used to determine this issue.
btw. the squares cannot be rotated to fit into the circle.
Bonus question is if it possible to get Excel to graphically show how to place them within the circle.
Best Answer
The following
Excel VBA
code created the image to demonstrate how to assemble an Excel graphics by addingShape
objects to the active worksheet: