Okay and Actual Relevant Comment, here's another way to do randomizers and put them online. I do it in excel for pairing generators, but it's also can be done in gdocs.
1) Make a list of things, one on each line. 2) In the column to the left of this, have numbers from 1 to wherever it goes. I fancy this up and have it autogenerated by using the ROW() formula and then subtract to get to 1, so if the list starts on row 2, the formula is ROW()-1 3) Made a random formula to pick a number. I go fancy and tell it to get a random number between the smallest number in col A and the biggest number in column A so I don't have to know what my biggest and smallest numberss are. RANDBETWEEN(Min(A:A),Max(A:A)) does the trick. 4) Find whatever value is in column B for that using vlookup. =VLOOKUP(E3,A2:B12,2,false) , where E3 is the cell with the random number (or just put the randomzation in the vlookiup: =VLOOKUP(RANDBETWEEN(min(A:A),max(A:A)),A2:B12,2,false) )
no subject
1) Make a list of things, one on each line.
2) In the column to the left of this, have numbers from 1 to wherever it goes. I fancy this up and have it autogenerated by using the ROW() formula and then subtract to get to 1, so if the list starts on row 2, the formula is ROW()-1
3) Made a random formula to pick a number. I go fancy and tell it to get a random number between the smallest number in col A and the biggest number in column A so I don't have to know what my biggest and smallest numberss are. RANDBETWEEN(Min(A:A),Max(A:A)) does the trick.
4) Find whatever value is in column B for that using vlookup.
=VLOOKUP(E3,A2:B12,2,false) , where E3 is the cell with the random number (or just put the randomzation in the vlookiup:
=VLOOKUP(RANDBETWEEN(min(A:A),max(A:A)),A2:B12,2,false) )
Quick'n'dirty gdocs version: https://docs.google.com/spreadsheets/d/10Ew-Ho0SUJznENvfGVxDU0401yVwM2Pwf82eLV_Xcrk/edit?usp=sharing There's prettier ways to do it, but this is the 8am version ;)