Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
need help calculating ratios
#7
(02-14-2025, 01:25 AM)SMcNeill Wrote: 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.

Ratio 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!
Reply


Messages In This Thread
need help calculating ratios - by madscijr - 02-13-2025, 09:35 PM
RE: need help calculating ratios - by bplus - 02-13-2025, 09:42 PM
RE: need help calculating ratios - by bplus - 02-13-2025, 09:53 PM
RE: need help calculating ratios - by madscijr - 02-13-2025, 11:00 PM
RE: need help calculating ratios - by Pete - 02-13-2025, 11:55 PM
RE: need help calculating ratios - by SMcNeill - 02-14-2025, 01:25 AM
RE: need help calculating ratios - by SMcNeill - 02-14-2025, 05:48 PM
RE: need help calculating ratios - by madscijr - 02-14-2025, 05:52 PM
RE: need help calculating ratios - by SMcNeill - 02-14-2025, 06:00 PM
RE: need help calculating ratios - by madscijr - 02-14-2025, 06:06 PM



Users browsing this thread: 1 Guest(s)