Dice Game in Excel

[jay_hl]

Hi All

I am new to Excel so Hi!

I need to create a game in Excel, and usually quite a competent user, however for this game I just cannot get my head around even how to start or approach it! (Excel 2007 btw!)

So here goes ...

The game is based on 15 rounds/turns of rolling, with each turn having a different criteria to count as a sucess.

Players are weighted in the number of rolls they have. (Player A = 1 per round, Player B = 1 per round, Player C = 2 per round, Player D = 12 per round, Player E = 32 per round).

Each round has a different criteria for a sucess in that particular round. e.g. Round 1 (4 rolls of dice) with sucess being 4 sixes in a row).

I have tried to demonstrate with a link to a excel spreadsheet file. http://uploading.com/files/84eae3af/Dice+Game.xlsx/

If anyone can help that would be amazing. At the moment I cant even see a tunnel, let alone the light at the end!

I have worked out that randbetween(1,6) is a start

Thanks

Jay

 

[jay_hl]

Apologies, I made a typo in the origianl spreadsheet example which might have confused others more than I already have with my explanation.

Heres the new link http://uploading.com/files/af9fc2c6/Dice%2BGame.xlsx/