oops...that "not", should have been "now"

I can see it on the search results on the main screen, under "last run", but how can you somehow extract that information to a separate list to export to excel,

Paul

Hi Paul,
It's quite easy but looks complicated when I outline it step by step.

Step by step assuming you've done the search and have the results.
You should automatically now be in Browse Mode and not Find Mode.
Select the Last Run tab.
Go to File menu...Export Records.
A dialogue box will pop up for you to save the data and in what format.
If you have Excel 2007 or 2010, save the data as an xlsx and name it something.

Another dialogue box will pop up called Specify Field Order For Export.
On the right hand side bottom is a window called Field export order.
Click the Clear All button next to it, so the window is blank.
Select the fields you want to export by highlighting each field you want on the left hand side window and clicking the button Move.

For example you will probably want Last Run Date, Last Run Venue, Last Run Distance, Last Run Time, Last Run Going.

When you've moved all those fields to the second window, hit the Export button.
The Excel workbook is now saved under the name you gave it in the location you saved it.

Open the workbook, select the top left part of the sheet above the row 1 and to the left of column A. This will highlight the entire sheet.
Select Data Filter in 2010, or Data, Filter, AutoFilter in 2007 or less Excel.
You can now filter for each going and distance.

Let me know if you require any further help.
Once you get the hang of it, it will only take a minute or two.

__________________
RaceCensus - powerful system testing software.
Now with over 420,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Here's an example Paul.

This is Excel 2010 file.

Attached Files

Canberra.xlsx (70.8 KB, 564 views)

__________________
RaceCensus - powerful system testing software.
Now with over 420,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

CP, thanks very much for that, I'm just printing out your instructions now, and shall see how I go figuring this out. Most interesting indeed,

Paul

CP, one question at this stage. At times in the File Menu, Export Records is greyed out. What should I be clicking on to rectify that,

Paul

Paul,
If it is greyed out, either you are still in Find mode, or you hit enter instead of pressing the Search button.
The search button activates a script and rolls through a number of hidden processes.
You can correct a problem by hitting the Modify search button and then hitting the search button again.
It should be active then.

__________________
RaceCensus - powerful system testing software.
Now with over 420,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Thanks CP for your help in this. It has allowed me to fill in a lot of gaps with times around the countryside. Initially I tried to use the times in R&S but they are "best times" for all tracks/distances/going, and I did find mistakes sprinkled here and there.

I've now "obtained" par times for tracks based on the average of the 10 best times and my list is expanding with the info you supplied. I spent a week setting up an excel spreadsheet where I can copy and paste form and rate the last 3 races with a couple of other small factors thrown in.

I really only intended to do this for saturdays racing at sydney and melbourne, however yesterday I decided to rate the Coffs Harbour meeting (I usually go to it). Race 5, a 1600m race it threw up the winner rated on top, paid $18.60,.....then in the CUP Erinsea was rated on top, run 3rd. In the last race a 1000m sprint, just for interest sake I backed the top 3 raters, with Auld Leng Sein, being the top rated horse and winning at around 60/1. Musta been a fluke,.!!!!

Something that I noticed in a heap of the "last 3 starts" at various local tracks was the odd distances,....1403,......1410,....even 1401,....and the list goes on. I'm not sure why tracks have to persistantly do this. It does throw out my VLOOKUP formulas, such a pain. It seems to happen at a fair few of the melbourne tracks also, not so much in the sydney tracks, they seem very stable.

Paul

The odds distances I find come about from the change in rail positions. The position can affect the times at each distance too.

But what can you do about it, nothing really. All I do is say for a 1410, I just divide my time by 1400 and multiply by 1410. And add that time to my VLOOKUP table so that the formulas can pick it up,

Paul