5th May 2007, 10:33 PM
|
|
Member
|
|
Join Date: Jan 2005
Posts: 108
|
|
Quote:
|
Originally Posted by ijuandaQLD
whats the easiest way to configure a market i dont think ill be able to work out the odds and the percentages
|
Hi ijuandaQLd,
I am watching this competition with great interest, but I can't play because I wouldn't be able to get markets in by Friday 6pm.
I used to do this sort of thing, and to make it easier I knocked up the attached. There are probably more elegant devices all over the net to achieve the same thing, if you know where to look (which I don't).
Put your estimate of each starter's fair dividend in column C (my market for the Goodwood is in there at the moment-just overwrite it with yours). Bung in your desired total market percentage in the blue cell (F1), and it will recalculate your market to that percentage in column F.
I used to find it handy for scratchings - just delete the scratched runner's dividend from column C, and your market is recalculated without that runner.
Hope it's of some use.
Cheers,
H. |