Try this, should be what you need.

Attached Files

Neurals Low Div.xlsm (443.5 KB, 324 views)

Thanks Shaun. I tried it on Caulfield today. It has listed all races and the lowest DIV prices twice (see below)
Venue Race No Runner
CAULFIELD 1 1 Rockshaft
CAULFIELD 2 8 Syntonic
CAULFIELD 3 8 Neriani
CAULFIELD 4 3 Ariarni
CAULFIELD 5 4 Launay
CAULFIELD 6 1 Pinwheel
CAULFIELD 7 7 Base
CAULFIELD 8 5 Oforawesome
CAULFIELD 1 1 Rockshaft
CAULFIELD 2 8 Syntonic
CAULFIELD 3 8 Neriani
CAULFIELD 4 3 Ariarni
CAULFIELD 5 4 Launay
CAULFIELD 6 1 Pinwheel
CAULFIELD 7 7 Base
CAULFIELD 8 5 Oforawesome

Is it possible to either list the actual DIV price next to all the selections but before the horse name:

Venue Race No DIV Runner
CAULFIELD 1 1 1.80 Rockshaft
CAULFIELD 2 8 3.10 Syntonic
CAULFIELD 3 8 3.10 Neriani
CAULFIELD 4 3 2.10 Ariarni
CAULFIELD 5 4 3.40 Launay
CAULFIELD 6 1 2.20 Pinwheel
CAULFIELD 7 7 2.05 Base
CAULFIELD 8 5 4.60 Oforawesome

Or (preferably) list only the DIV price that is over 3.00+

Venue Race No DIV Runner
CAULFIELD 2 8 3.10 Syntonic
CAULFIELD 3 8 3.10 Neriani
CAULFIELD 5 4 3.40 Launay
CAULFIELD 8 5 4.60 Oforawesom

And finally after all that, can the above be placed on the same sheet as the CP/FR Barrier 5 / Top Neural / 100 rater sheet thereby only having to go through all the races only once? Big ask I know.

Sure will look at that, Caulfield listed twice because i had already run it on that meeting to test it.

I added a min price option for the div, what ever you put in there the price must be higher for the selection or it won't been shown.

Attached Files

Neurals & Unitab Update.xlsm (523.0 KB, 333 views)

Thanks Shaun but it hasn't picked up all the picks.

It picked up races 5 and 8 at Caulfield where there is only one selection that is in the 3.00 range but hasn't picked up races 2 and 3 where there are more than one selection in the 3.00 range in each race. This might have something to do with it?

Sorry about this but can you take a look at this when you get a chance?

So do you want it to pick 1 selection or more than one in a range, right now it will look at your min and if a runner is under that it ignores the race, other wise it will find the next highest price and if there are 2 the same it will select the highest TAB number.

Just one selection that is the lowest DIV but 3.00 or higher. The excel sheet has picked the right horses at Caulfield races 5 and 8 but hasn't picked any horses in races 2 and 3 where there are more than one horse in the 3.00-3.90 range for each race.

I need the sheet to pick up the lower DIV of the horses in that range on those races but, at the same time, pick the highest TAB number should 2 or more horses have the same DIV. I hope that makes sense. Thanks for doing it, Shaun.

Sorry Shaun I just did the selections for tomorrow and on just about every race it is spot on and picking them as you said. The only problem is it has missed out on some races (see below) where the valid horses should of been selected but weren't.

GAWLER races 4 & 5
Geraldton races 1,2,3 & 7
Sunshine Coast races 2,3,4 & 7
Wangaratta races 5 & 6

Other than those it made all the other right selections so it is nearly awesome but not quite there yet...lol. You've nearly made me lazy by only running the excel sheet but it still seems to have some sort of bug.

Of course the next thing will be to pick out the venue numbers automatically so I don't need to visit the R&S site at all and all I'll have to do is make sure the date is right, press one button and BANG, out spit my selections...lol

I found the problem, i won't repost but tell you how to fix, on the "Neural's" sheet select columns U to W right click and select unhide in the formula at U1 change it to this =SUM(AA1:AA3) you can re hide that column if you want, be sure to save it.

Thanks very very much Shaun. I take it you meant the formula at V1 which worked a treat.

Now you'll have to work on that automatic 1 click sheet...lol

Only kidding, thanks Shaun.