it has popped up a while this last year, I wanted a try, and wanted to know how to do it

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.

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]

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.

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

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.

simple question: How exactly step by step to create a DOND[UK] game on excel. Please answer.

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.

Fantastic! thanks tom