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

[wayneg]

this should be easy, but on deeper reader i think itll be hard to accomplish... i could create it but i dont think it will have the desired effects of what you are looking for. (and it will take time)

[wayneg]

i just been looking into it and created this so far for you, but i rolled like nearly 1500 times and it didnt roll me 4 x 6's

[brokenbiscuits]

Well, the odds of rolling 4 sixes would be (6 x 6 x 6 x 6)=1296/1. So you've been a little unlucky, but nothing out of the ordinary.

Doesn't sound like a particularly fun game to me!!

[wayneg]

thats what i thought, add if ypou only allowed 1 go of 4 dice then itll take a while to get past the first step

[ChemistB]

Here's a rough start on what you may be looking for. There's a long way to go.
I put in formulas for each of the 15 rounds that check your rolls and either give 0 or 1 point.
I made the assumption that it might not always be weighed with each player the way you stated so I wrote a macro that inserts the proper number or rows depending on what you put in for the # of throws per player (Col B). Click on Setup button.

I had started to write VBA for each Round but then wasn't sure what direction you were going to go in. Will people actually be throwing dice and you'll be entering the results or do you want it simulated in the little squares in my setup or would you prefer something like what wayneg set up on a separate page and just transfer the final values into page 1. Also, if someone has multiple rolls, do they continue to amass points in a particular round or do they stop when they've achieved the goal for that round?

Anyway, spreadsheet attached. I'm going to be away for about 5 days so will get back to you then.

[ChemistB]

Updated version with all the buttons working (although maybe not the way you want them to).

[wayneg]

i take it he didnt stay around to find out his answer ????