need help calculating ratios

[madscijr]

For ratio 1:1 with 16 items, it should be 4 rows, 4 columns, but it calculates 8 rows, 8 columns. 
For ratio 3:4 and 12 items, it should output 4 rows, 3 columns, but we get 5.142857 rows, 6.857143 rows.

SQR(Num * Ratio)
SQR(16 * 1/1) = 4
SQR(12 * 3/4) = 3, SQR(12 * 4 /3) = 4

Has no one had a chance to try this amazing formula which I intuited while sitting in the dark with no power over the last two days, playing around on my phone?   It seems to work for me.

Ratio 1:10 with 10 items:
SQR(10 * 1 /10) = 1, SQR(10 * 10 / 1) = 10   It's a 1x10 set of rows and columns.

Ration 1:10 with 40 items:
SQR(10 * 1/40) = SQR(4) = 2
SQR(10 * 40/ 1) = SQR(400) = 20
It's a 2 x 20 set of rows and columns.

Just swap your ratio to toggle between rows and columns.

And don't ask me *why* this works.  I has no idea.  I just noticed the pattern here while in the dark and twiddling my thumbs with nothing else to ponder on.  LOL!

Sorry, been a little busy, basement got flooded, big mess. 
I don't suppose you have any routines for cleaning that up and restoring waterlogged Stones records? LoL
I have this bookmarked and will try out all this code just as soon as I am able...
Thanks again!