Excel Dice Game

[Jay_hl]

Hi All

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.

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