Excel Spreadsheet or anything?

[bane221]

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]

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]

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]

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]

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]

I've been forecasting financial results my entire career. I don't know where I'd be without the rand function.

[MatthewV]

you might have money *gasp* and not living like a quail, Quailman!

[mith]

cs, =INT(RAND()*N+1) is shorter