£500k Christmas Special Games

**Joined:** Fri Feb 24, 2006 10:04 pm **Warnings:** 0

So how might a game develop with the special board that is set to appear for the Christmas specials - £500,000 top prize with the £15,000 box removed? I've set up my spreadsheet to generate some games, with offers based on Bother's Bar "fair deal" benchmarks and a bit of random variation.

Game 1

Contestant's box: 22

Round 1

3: £5
14: £50
5: 50p
6: £500
8: £10,000

No all-blue round but still a great start!

Offer 1: £14,000 - No Deal

Round 2

9: £5,000
13: £1,000
15: £750

We can afford to lose those kind of reds.

Offer 2: £32,000. Great offer but this is a fantastic board - No Deal.

Round 3

18: 1p :banana:

1: £500,000 The half-million goes.
19: £100,000

Bad round, but still a strong £250k board!

Offer 3: £22,000 - No Deal

Round 4

2: £1
10: £250
11: £50,000

Could have done without that last one, but just about back on track.

Offer 4: £27,000 - No Deal

Round 5

20: £3,000
21: £10
4: £35,000

Again ending with one of the Power 6, but we can afford that one!

Offer 5: £41,000
That's big money, but... the quarter million's still there, with £75k and £20k as backup. After plenty of consideration... No Deal!

Round 6

7: £20,000
16: £75,000
17: £250,000 :cry:

The 10% disaster scenario is hit.

Offer 6: £30 - No Deal and No Swap

Box 22 opened to reveal... £100 (Box 12 contains 10p)

Dramatic game but not the outcome we all wanted to see!

Power5 wrote:

So how might a game develop with the special board that is set to appear for the Christmas specials - £500,000 top prize with the £15,000 box removed? I've set up my spreadsheet to generate some games, with offers based on Bother's Bar "fair deal" benchmarks and a bit of random variation.

Game 1

Contestant's box: 22

Round 1

3: £5
14: £50
5: 50p
6: £500
8: £10,000

No all-blue round but still a great start!

Offer 1: £14,000 - No Deal

Round 2

9: £5,000
13: £1,000
15: £750

We can afford to lose those kind of reds.

Offer 2: £32,000. Great offer but this is a fantastic board - No Deal.

Round 3

18: 1p :banana:

1: £500,000 The half-million goes.
19: £100,000

Bad round, but still a strong £250k board!

Offer 3: £22,000 - No Deal

Round 4

2: £1
10: £250
11: £50,000

Could have done without that last one, but just about back on track.

Offer 4: £27,000 - No Deal

Round 5

20: £3,000
21: £10
4: £35,000

Again ending with one of the Power 6, but we can afford that one!

Offer 5: £41,000
That's big money, but... the quarter million's still there, with £75k and £20k as backup. After plenty of consideration... No Deal!

Round 6

7: £20,000
16: £75,000
17: £250,000 :cry:

The 10% disaster scenario is hit.

Offer 6: £30 - No Deal and No Swap

Box 22 opened to reveal... £100 (Box 12 contains 10p)

Dramatic game but not the outcome we all wanted to see!

How do you set up a spreadsheet to make a game?

**Joined:** Fri Feb 24, 2006 10:04 pm **Warnings:** 0

wakey1512 wrote:

How do you set up a spreadsheet to make a game?

Well... same way you write a spreadsheet to do anything else, really. Write formulas, macros etc. to make it do what you want... if you know how to do that you're OK, if you don't then I guess you just have to learn if you're interested!

**Posted:** Fri Nov 17, 2006 11:41 pm **Author:** wakey1512 **Post subject:**

No, i meant making a full working game on excel...

**Posted:** Fri Nov 17, 2006 11:43 pm **Author:** Tugger **Post subject:**

I have a script of a basic uk game and i can easily edit that to £500,000!

**Joined:** Fri Feb 24, 2006 10:04 pm **Warnings:** 0

Game 2

Contestant's box: 5

Round 1

16: 1p
2: 10p
4: £250
19: £100
20: £75,000

First hit to the Power 6 but not a bad opening!

Offer 1: £13,000 - No Deal

Round 2

9: £50
10: £250,000
11: £50,000

The big one's looking rather isolated already...

Offer 2: £17,000- No Deal.

Round 3

1: £5
7: £500
8: £100,000

And we have a half-million one-box game!

Offer 3: £19,000 - No Deal

Round 4

21: £5,000
14: £3,000
3: 50p

Good recovery round there.

Offer 4: £32,000 - No Deal Still not walking money with that double jackpot in play!

Round 5

17: £1
15: £750
6: £10

All-blue round and all-red final five!

Offer 5: £69,000

Chasing the half-million is still a temptation, but there's not a lot of backup. The sweep is unanimous and the contestant agrees...Deal!

Round 6

12: £20,000
13: £10,000
22: £1,000

Would have been the perfect round...

Proveout Offer 6: £210,000

Box 5 opened to reveal... £500,000 (Box 18 contains £35,000)

So it was there all along, if we had gone all the way it would have been half a million. But £69,000 is still life-changing money!

**Posted:** Fri Nov 17, 2006 11:51 pm **Author:** wakey1512 **Post subject:**

wakey1512 wrote:

No, i meant making a full working game on excel...

**Joined:** Fri Feb 24, 2006 10:04 pm **Warnings:** 0

wakey1512 wrote:

No, i meant making a full working game on excel...

Well, exactly as I said really. Write something to sort/select the boxes, and something to generate the offers. Not sure how much more I can explain as it depends how well you know your way round Excel!

**Posted:** Sat Nov 18, 2006 12:05 am **Author:** Tugger **Post subject:**

I've got a full working game with the new £500,000!

**Posted:** Sat Nov 18, 2006 12:46 am **Author:** Tugger **Post subject:**

My box is 13

Round 1

4 - £1,000
12 - £100
9 - £1
15 - £35,000
5 - £75,000

Offer - £13,100

No Deal

Round 2

2 - £5
1 - £10
7 - £5,000

Offer - £25,400

No Deal

Round 3

18 - 50p
20 - £500,000

17 - 10p

Offer - £20,600

No Deal

Round 4

6 - £3,000
16 - £50
8 - £750!!

Offer - £35,800

Remaining - 1p, £250, £500, £10,000, £20,000, £50,000, £100,000, £250,000.

Deal!

Round 5

10 - 1p!!

14 - £20,000

Squashdown:

Code:

               £10,000
               £50,000
£250          £100,000
£500          £250,000

3 - £250!!

Offer - £66,400

Round 6

19 - £100,000
22 - £250,000!!
11 - £500

Offer - £28,500

My box 13 held...

£50,000!!

I'll have Wakey on my back now!

21 - £10,000

**Posted:** Sat Nov 18, 2006 12:56 am **Author:** wakey1512 **Post subject:**

You. Fool

**Joined:** Sat Jan 28, 2006 8:00 pm **Warnings:** 0

Except Box 4 contained the anti-red, so you won more than he would.

Two amazing games there.

Here's a couple of games I've done in the same way as my Contestant Challenge, using percentage-of-the-mean benchmarks from Bother's Bar though with significant (12%) variance. The use of the mean as a basis may lead to odd offers.

Code:

GAME ONE
Player has Box 9.

ROUND 1
5 - 1p | 20 - £20,000 | 2 - £1,000 | 19 - £5 | 22 - £10,000
OFFER: £16,700 | NO DEAL

ROUND 2
6 - £35,000 | 18 - £75,000 | 11 - £50
OFFER: £31,000 | NO DEAL

ROUND 3
15 - 50p | 3 - £5,000 | 4 - £1
OFFER: £41,500 | NO DEAL

ROUND 4
16 - £750 | 12 - £100 | 10 - 10p
OFFER: £55,900 | NO DEAL

ROUND 5
14 - £250,000 | 17 - £50,000 | 7 - £500
OFFER: £68,600 | DEAL

ROUND 6 (proveout)
8 - £500,000 | 21 - £100,000 | 1 - £3,000
HYPOTHETICAL OFFER: £91

Box 9 had £10

Code:

GAME TWO
Player has Box 13

ROUND 1
1 - £10 | 2 - £500 | 3 - £100,000 | 4 - £5 | 5 - £75,000
OFFER: £13,000 | NO DEAL

ROUND 2
22 - £750 | 21 - £35,000 | 20 - £10,000
OFFER: £23,900 | NO DEAL

ROUND 3
6 - 10p | 7 - £1 | 8 - 50p
OFFER: £42,800 | NO DEAL

ROUND 4
19 - 1p | 18 - £50,000 | 17 - £500,000
OFFER: £18,300 | NO DEAL

ROUND 5
9 - £50 | 10 - £250 | 11 - £250,000
OFFER: £3,600 | NO DEAL

ROUND 6
16 - £100 | 15 - £1,000 | 14 - £5,000
OFFER: £8,800 | NO DEAL

SWAP for Box 12
Box 12 contains £20,000

**Posted:** Sat Nov 18, 2006 1:10 am **Author:** Tugger **Post subject:**

Here's a picture from my game of an incredible board!

**Posted:** Sat Nov 18, 2006 1:12 am **Author:** Tugger **Post subject:**

KP wrote:

Except Box 4 contained the anti-red, so you won more than he would.

Two amazing games there.

Here's a couple of games I've done in the same way as my Contestant Challenge, using percentage-of-the-mean benchmarks from Bother's Bar though with significant (12%) variance. The use of the mean as a basis may lead to odd offers.

Code:

GAME ONE
Player has Box 9.

ROUND 1
5 - 1p | 20 - £20,000 | 2 - £1,000 | 19 - £5 | 22 - £10,000
OFFER: £16,700 | NO DEAL

ROUND 2
6 - £35,000 | 18 - £75,000 | 11 - £50
OFFER: £31,000 | NO DEAL

ROUND 3
15 - 50p | 3 - £5,000 | 4 - £1
OFFER: £41,500 | NO DEAL

ROUND 4
16 - £750 | 12 - £100 | 10 - 10p
OFFER: £55,900 | NO DEAL

ROUND 5
14 - £250,000 | 17 - £50,000 | 7 - £500
OFFER: £68,600 | DEAL

ROUND 6 (proveout)
8 - £500,000 | 21 - £100,000 | 1 - £3,000
HYPOTHETICAL OFFER: £91

Box 9 had £10

That looked similar to my game which I posted above this post!

**Posted:** Sat Nov 18, 2006 3:51 pm **Author:** Tugger **Post subject:**

The Sara Dream Scenario:

Main DOND Site	Play DOND Games	DOND TV Guide	DOND Stats		FAQs	Hall of Fame
Ebay Watch	DOND Merchandise	Be a Contestant	DOND Amazon Store	DOND Blog	Privacy Policy	Contact Us

£500k Christmas Special Games

Who is online