PDA

View Full Version : [SOLVED] Formula to calculate how many circles fit in a larger circle



ioncila
09-22-2014, 10:11 AM
Hi
To calculate this, I'm using a simple formula that divides the area of the larger circle by the area of the smaller.
For example, if I want to know how many Ø63 circles fit in a Ø250 circle, I do this:
=INT((125^2*PI())/((32.5^2*PI()) to result = 14

But I think this is a wrong approach.

May someone clarify me about this, please?

Thank you very much

ioncila

SamT
09-22-2014, 12:17 PM
you can get a closer "ballpark" figure by squaring off the smaller circle (D^2)
=INT((125^2*PI())/((2*32.5)^2))

ioncila
09-22-2014, 02:24 PM
I have edited my last post because formula was not correct. But I guess you understood :)


you can get a closer "ballpark" figure by squaring off the smaller circle (D^2)
=INT((125^2*PI())/((2*32.5)^2))

I have tried that before but not the way you are showing
With a little help of geometry drawings I verified that you are right.

Thank you very much
It was a great help