Deal or No Deal Fansite and Forum: Welcome to DOND, the home of Deal or No Deal fans.

Deal Or No Deal
Deal or No Deal Fansite and Forum: Welcome to DOND, the home of Deal or No Deal fans.
It is currently Tue Dec 03, 2024 7:08 pm Last visit was: Tue Dec 03, 2024 7:08 pm



Watch NEW Deal or No Deal, ITV1, Mon-Fri at 4pm.



New user? Register to join in! Returning user? Login (or reset your password).

Deal or No Deal forum index » DoND Activities, Games & Quizzes Forums » Other DoND Games & Discussion » Online Games DiscussionsAll times are UTC [ DST ]



 [ 9 posts ] 
Author Message

Aaron Brock

PostPosted: Tue Mar 20, 2007 4:30 pm    Author: Aaron Brock    Post subject: How do you make a DoND game on Excel?

Joined: Wed Feb 01, 2006 6:19 pm
Warnings: 0
it has popped up a while this last year, I wanted a try, and wanted to know how to do it

_________________
Eurovision enthusiast and fellow member of #teambat.


Top
 Profile  

KP

PostPosted: Tue Mar 20, 2007 5:08 pm    Author: KP    Post subject:
International Forums Moderator
User avatar

Joined: Sat Jan 28, 2006 8:00 pm
Warnings: 0
Simplest way to do it:

1. Put the board values in column A (or split them between A and B for visual red/blue effect, makes no difference).
2. Below those values, have a cell to calculate the mean of the remaining values. For a UK board put into two columns this will be =AVERAGE(A1:B11).
3. Below that, you can put six percentages, though it might be easier to put them in as decimals... multiply this by the mean and you have benchmarks for each offer. I'd set values of approximately this for sensible Banker behaviour: 0.25, 0.4, 0.55, 0.65, 0.7, 0.8. For 2007 nutty behaviour: 0.3, 0.55, 0.75, 0.9, 0.95, 1.

I've created a rather more complex version that I could send you if you want, which produces offers that vary dependent upon the volatility of the board and even the predicted cautiousness of the player.

_________________
Champion of RTaB S6, creator of unorthodox DoND rulesets, and founder member of #teambat.
Creator of the first DoND Live offer to be accepted.
"Why regret what could not be?" (A Heart Full of Love, from Les Misérables)
I introduced utility theory to the forums. Blame me.
In your choices, beware of words leading you astray. Think in a balanced way about potential gains and losses.


Top
 Profile  

daniel123

PostPosted: Tue Mar 20, 2007 6:13 pm    Author: daniel123    Post subject:
Forum Games Moderator
User avatar

Joined: Sat Jun 10, 2006 11:59 am
Location: Here
Warnings: 0
what about microsoft works version of excel?

right, just done No.1, onto the average. But of course, this is my first time and i need some more detailed instructions for no. 2 - its just come up with, in A12, when i did the average, 25,712.091.

edited

PLEASE can i have some detailed insructions, step by step like that post, on how to make a game on excel.

ps - can you send me the game plz?

[by PM or email]

_________________
81st member of the Pat M fan club. Still flying the flag for the class of '06...

Like Tom Hanks and his football on that island in 'Cast Away', it looks like it's just me and the bots here now. But that's alright, we're having a grand old time. Aren't we, Wilson? WILSOOOON?!

A few of us who were once part of the furniture, once stalwarts of the grand and extravagant, exuberant and thriving forum, have receded back into the walls, still faintly visible, still here as poignant, reminding relics of an era gone by; but most of us have vanished, forever immersed in the mists of time.


Top
 Profile  

daniel123

PostPosted: Tue Mar 20, 2007 8:40 pm    Author: daniel123    Post subject:
Forum Games Moderator
User avatar

Joined: Sat Jun 10, 2006 11:59 am
Location: Here
Warnings: 0
i want exactly how to make a DOND game on excel, no beating round the bush, NO DELETING MY POSTS :? :? just a simple step by step guide of how to make a uk dond game on excel.

_________________
81st member of the Pat M fan club. Still flying the flag for the class of '06...

Like Tom Hanks and his football on that island in 'Cast Away', it looks like it's just me and the bots here now. But that's alright, we're having a grand old time. Aren't we, Wilson? WILSOOOON?!

A few of us who were once part of the furniture, once stalwarts of the grand and extravagant, exuberant and thriving forum, have receded back into the walls, still faintly visible, still here as poignant, reminding relics of an era gone by; but most of us have vanished, forever immersed in the mists of time.


Top
 Profile  

Aaron Brock

PostPosted: Tue Mar 20, 2007 9:19 pm    Author: Aaron Brock    Post subject:

Joined: Wed Feb 01, 2006 6:19 pm
Warnings: 0
KP wrote:
Simplest way to do it:

1. Put the board values in column A (or split them between A and B for visual red/blue effect, makes no difference).
2. Below those values, have a cell to calculate the mean of the remaining values. For a UK board put into two columns this will be =AVERAGE(A1:B11).
3. Below that, you can put six percentages, though it might be easier to put them in as decimals... multiply this by the mean and you have benchmarks for each offer. I'd set values of approximately this for sensible Banker behaviour: 0.25, 0.4, 0.55, 0.65, 0.7, 0.8. For 2007 nutty behaviour: 0.3, 0.55, 0.75, 0.9, 0.95, 1.

I've created a rather more complex version that I could send you if you want, which produces offers that vary dependent upon the volatility of the board and even the predicted cautiousness of the player.


So how much offer differ should i put for both sets of benchmarks?

_________________
Eurovision enthusiast and fellow member of #teambat.


Top
 Profile  

KP

PostPosted: Tue Mar 20, 2007 9:35 pm    Author: KP    Post subject:
International Forums Moderator
User avatar

Joined: Sat Jan 28, 2006 8:00 pm
Warnings: 0
I didn't set an offer variation into Excel though you can do it (awkwardly). I'd say 10% or so as a general rule.

_________________
Champion of RTaB S6, creator of unorthodox DoND rulesets, and founder member of #teambat.
Creator of the first DoND Live offer to be accepted.
"Why regret what could not be?" (A Heart Full of Love, from Les Misérables)
I introduced utility theory to the forums. Blame me.
In your choices, beware of words leading you astray. Think in a balanced way about potential gains and losses.


Top
 Profile  

daniel123

PostPosted: Tue Mar 20, 2007 9:36 pm    Author: daniel123    Post subject:
Forum Games Moderator
User avatar

Joined: Sat Jun 10, 2006 11:59 am
Location: Here
Warnings: 0
simple question: How exactly step by step to create a DOND[UK] game on excel. Please answer.

_________________
81st member of the Pat M fan club. Still flying the flag for the class of '06...

Like Tom Hanks and his football on that island in 'Cast Away', it looks like it's just me and the bots here now. But that's alright, we're having a grand old time. Aren't we, Wilson? WILSOOOON?!

A few of us who were once part of the furniture, once stalwarts of the grand and extravagant, exuberant and thriving forum, have receded back into the walls, still faintly visible, still here as poignant, reminding relics of an era gone by; but most of us have vanished, forever immersed in the mists of time.


Top
 Profile  

Tom22

PostPosted: Tue Mar 20, 2007 9:49 pm    Author: Tom22    Post subject:

Joined: Sat Jun 17, 2006 12:12 pm
Warnings: 0
That isnt a game you exactly play as such but its quite good at offers and randomizing boxes, you need to change column G to completely white
and go Data - Sort - and work from there to randomize.
Image

_________________
Image
1ST. Capello's Cupakes 1288
2nd. Stubbsy's Sizzlers 1286
3rd. Toms Shrews III 1221
Top Scorer this week - dondsters 147 Worst scorer this week - Adium United 33
Bottom - Hammond's Heroes 766
(After Gameweek 22)


Top
 Profile  

Aaron Brock

PostPosted: Tue Mar 20, 2007 10:08 pm    Author: Aaron Brock    Post subject:

Joined: Wed Feb 01, 2006 6:19 pm
Warnings: 0
Fantastic! thanks tom ;)

_________________
Eurovision enthusiast and fellow member of #teambat.


Top
 Profile  
Display posts from previous:  Sort by  
 [ 9 posts ] 
Deal or No Deal forum index » DoND Activities, Games & Quizzes Forums » Other DoND Games & Discussion » Online Games DiscussionsAll times are UTC [ DST ]


Who is online

Users browsing this forum: Bot and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  

Deal Or No Deal

[ View who is online ]

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Copyright ©2023 dond.co.uk All rights reserved

www.dond.co.uk is not responsible for the content posted by private individuals on this website. The views expressed herein are solely the opinions of the individuals that produced them and not necessarily the views of the owner, or of the admins, or of the moderators of this website.


Admin Zone Directory