Mafia spreadsheets.

[BlueSin]

I would like to see some spreadsheet example to have an idea to do it my own way. Anyone mind to send her/his to my mailbox? or juz tell me the formulas u used.

[Thoth]

*points to Shadyforce's link 2 post above yours *

[BlueSin]

by the way, how to assign roles randomly with excel?

[jeep]

One of many possible ways:

In column A, put all players in some order (doesn't matter)
In column B, put all roles in some order (doesnt' matter)
In column C, next to each role, put

Code: Select all

=rand()

Highlight Columns B and C
Select Data->Sort
Sort By:Column C Ascending (leave all other criteria blank)

Then you have a randomly assigned list. However, realize that =rand() will change everytime you do something , so only sort once, then delete that column (or copy the values and sort based on those... )

There are many other possible ways to do this, but that is pretty easy and straightforward.

-JEEP

[indentureddjinn]

use for modding
I like to write stuff down for playing

[Cadmium]

I've read about the =rand() function when first looking at mafia games at the GL. But for some reason, it doesn't work in the Excel I use.

I always use =aselect(). This produces a random number between 0 and 1.

[PolarBoy]

Crap, I wish I had known that sooner. I've been doing this manually with sequences generated by Random.org(Great site for random numbers). Thanks for the tip JEEP.

[Fishbulb]

However, realize that =rand() will change everytime you do something

Actually, you can turn that off in the Options menu so it will only recalculate when you hit F9.

[PolarBoy]

This board is so educational.

[Corsato]

I've been doing this manually with sequences generated by Random.org(Great site for random numbers). Thanks for the tip JEEP.

Actually, I still use random.org for randomly assign roles. But then again, I usually have a txt-files and a fancy texteditor to copy-paste and organize everything. The excel sheet comes in later .

[shadyforce]

I have works at home so I don't excel, just MSdatabase. I use anything from random.org to a sequency of dice rolls and coin tosses, to drawing lots or names in a hat, lol.

[PolarBoy]

Occasionally when I need a random number and I'm on my dial-up connection at home, I ask the nearest person for a random number within a range. Be careful with this on though, as the numbers you get can actually be somewhat predictable. People seem to have a tendency to be somewhere near the top, but not too near. Sometime ask a friend for a number between 1 and 4 inclusive and they'll probably pick 3. I just tried it out on Foolster41 and he did.

[shadyforce]

Lol, yeah that's true.

You could always have a simple program that does it for you. A few lines of C++ code should do it.

Code: Select all

#include <iostream>
#include <time.h>
#include <stdlib.h>

int main()
{
  int x, y;

  cout << "Input the lower limit: " << endl;
  cin >> x;

  cout << "Input the upper limit: " << endl;
  cin >> y;

  srand(time()+getpid());

  cout << "The random number is: " << rand()%(y-x)+x; << endl;

  return(0);
}

My C++ is a little rusty (it's been 2 whole weeks since my test ) but I reckon that should do it.

[willows_weep]

I use it to hold my fantasy games. It holds the numerous possibilities for a choice etc, names, twisted affairs, keeps track of my numbers and tons of other fun things. I am even taking it to PPT. Just because I like to see my plans in different settings.