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?