# The Grey Labyrinth is a collection of puzzles, riddles, mind games, paradoxes and other intellectually challenging diversions. Related topics: puzzle games, logic puzzles, lateral thinking puzzles, philosophy, mind benders, brain teasers, word problems, conundrums, 3d puzzles, spatial reasoning, intelligence tests, mathematical diversions, paradoxes, physics problems, reasoning, math, science.

Author Message
bane221
Icarian Member

 Posted: Mon Jul 14, 2003 1:44 am    Post subject: 1 Anyone have a nice spreadsheet or any sorta of simplified something that randomizes your game roles for you? I've been working on an excel macro but I haven't made these things for years.
mole
Subterranean Member

 Posted: Mon Jul 14, 2003 1:56 am    Post subject: 2 I usually have the player names in column B, and the roles in column C. Fill column A with rand() functions, then you can sort the players using the random numbers.
Beartalon
'Party line' kind of guy

 Posted: Mon Jul 14, 2003 3:03 am    Post subject: 3 But don't resort the sheet after you've sent out your role emails. Rand(), auto regenerates, and a sort will change the name/role pairings again.
bane221
Icarian Member

 Posted: Mon Jul 14, 2003 3:06 am    Post subject: 4 Great, thanks a ton Can't believe I didn't think of that, I was trying complicated If and Rand functions and such.
cuban smoker
Daedalian Member

 Posted: Mon Jul 14, 2003 1:49 pm    Post subject: 5 Just copy the column with the rand() entries, and then "paste/special/values" back onto the column (or somewhere else) and the numbers won't regenerate. In other news, the following formula gives a very quick and easy N-die roll: =round(rand()*N+0.5,0)
Quailman
His Postmajesty

 Posted: Mon Jul 14, 2003 1:56 pm    Post subject: 6 I've been forecasting financial results my entire career. I don't know where I'd be without the rand function.
MatthewV
Daedalian Member :_

 Posted: Mon Jul 14, 2003 11:46 pm    Post subject: 7 you might have money *gasp* and not living like a quail, Quailman!
mith
Pitbull of Truth

 Posted: Mon Jul 14, 2003 11:56 pm    Post subject: 8 cs, =INT(RAND()*N+1) is shorter
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year by All usersbane221Beartaloncuban smokerMatthewVmithmoleQuailman Oldest FirstNewest First
 All times are GMT Page 1 of 1

 Jump to: Select a forum Puzzles and Games----------------Grey Labyrinth PuzzlesVisitor Submitted PuzzlesVisitor GamesMafia Games Miscellaneous----------------Off-TopicVisitor Submitted NewsScience, Art, and CulturePoll Tournaments Administration----------------Grey Labyrinth NewsFeature Requests / Site Problems
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum