Hi all,....I am looking for a form guide from the internet, free of course where I can copy and paste the following data to excel. A lot of form guides show the form all clustered together which I cant copy and paste into different cells. Racenet for example.

www.ozeform.com comes close but it doesnt give me the "going".

The form that I want is:

Last Start Beaten Margin
Weight Last Start
Last start Venue/Distance and Going

I've been using ozeform and doing the "going" manually from other form guides.

Or if any of you excel experts have better ways of extracting this form.

Thanks, Paul

and,.......the "time" of the last start, nearly forgot,...!

Paul, Unitab members form can provide the details you have mentioned - copy & paste into excel.

Thanks Stugots, I am assuming you have to be a member,.?

Paul

What version excel do you have.

Thanks Stugots for that. I joined up with Unitab today and at this stage their formguide seems to be quite good.

Shaun, I have Excel 2010.

Sitting here now redoing my spreadsheet to match up with the Unitab formguide. As you could have guessed from my questions I endeavour to give every horse in the field a rating arising from its last start finishing position/weight variation/time outside the "best" time for that distance, at that track on that going.

My VLookup table has now around 1600 times and grows every time I find a runner that raced somewhere that I didnt previously have. Concentrating on Sydney saturdays only.

Last saturday it rated 3 winners on top (R1 $11.00, R3 $4.00 and R4 $6.50). Every horse gets a kilogram rating with all times/margins etc, converted to kgs.

Hopefully with the Unitab formguide it might make my task much easier to do the copying and pasting, it was rather messy before.

Have you ever tried using web queries to get the data in to excel.

Hi Shaun, no,..cant say that I have, I'd have to do some reading as to what they are exactly,..!

Currently trying to work out how to convert the "time" in the Unitab site to seconds, which is currently shown as: "2-30.3" etc. I've got all my times in seconds so that I can subtract one from the other,..any thoughts.

And briefly what are web queries,

Paul

You can play around with this, if you have this "2-30.3" in A1 then put this formula in B1 =LEFT(A1,1)*60+MID(A1,3,2)+RIGHT(A1)
and would give you the result 150.3 sec


I haven't used Excel for programming for, well never, but it should give you a start.

Good luck

oops
that should be =LEFT(A1,1)*60+MID(A1,3,2)+RIGHT(A1)/10

missed the cut by that much " "