View Full Version : Excel Help - Market Framing

Dennis G
30th March 2009, 06:03 PM
Hi Guys,
I got a problem with re-adjusting markets to take scratchings into account.

It seemed so easy, but when I sat down to do it I realised I had not clue one what I was doing. I went to an Excel help site, but realised it would be easier to explain to the racing mob.

What I want to do is write a template for up to 20 horses (the max I expect to encounter), so Column A = TAB No, Col B = Original Market, Col C = Adjusted Market after Scratchings.

My first problem was establishing the market percentage of Col A.
It went something like - =SUM(100/B1+100/B2+100/B3+100/B4+.....100/B20) which apart from being incredibly cumbersome doesn't take blank cells into account and there returns a #Div/0! error. So I started playing around with conditional functions and, and..... I've got a headache....

Surely one of you very charitable souls can point me in the right direction, I'd REALLY appreciate it.


30th March 2009, 06:27 PM
have a look at http://forums.ozmium.com.au/showthread.php?t=17865 post #5 it has a excel spread sheet that might have something in it that you can use. not exactly what you want but may help.

Chrome Prince
31st March 2009, 12:18 PM
I've quickly put together...

Market Maker Deluxe :D

Simply delete the rating of any scratching and the market will recalculate to 100%

Hope this helps.

Dennis G
1st April 2009, 04:12 PM
Thanks Chrome, certainly a professional looking job ;) but you misconstrued what I meant, or more likely I didn't explain very well.

What I wanted was to put in a column for paper prices and have it auto recalculate the odds after scratchings.

I finally got it done - very messy, took 6 columns although 3 of them can be 'hidden'. I knew there was a way cause I can sit down with a calculator and pencil and achieve the result. There may be a more efficient way but it works.

I have attached the file in case anyone else wants it.

Market Adjuster Gold :p

Note: In this example 3 & 10 are scratched.

Chrome Prince
1st April 2009, 04:44 PM
Looks good, great job.