View Single Post
  #4  
Old 8th June 2005, 04:44 PM
mickmc mickmc is offline
Member
 
Join Date: Jan 1970
Posts: 36
Default

G'day TS

The form from that page that will fit into a spreadsheet nicely is the field part at the top. What you do is click up towards the top left of that screen near the race number - while holding the mose button down ,drag the mouse down and you will see that the text on the page becomes highlighted. Once you've highlighted the stuff you want you can let go of the mouse button. Now hold down the CTRL key and press the C key. This will copy that text to the clipboard ( nothing seems to happen so you won't get a message saying it's copied.) Now open up an excel spreadsheet and in the A1 square do CTRL + V ( this means hold the CTRL key down and then press the V key ) this should then paste all of the data in and it should be in there own separate cells and columns.

The individual horse form below the field part which has latest runs etc. can also be copied but you will see it doesn't get put in columns as managable as just the field part. The excel boffins on here are prob clever enough to makeup some sort of macro that will automatically format it to a format they prefer. Bit of mucking about involved there to do that though.

Hope this helps.

Mick

Oh one last thing , the new nswtab site , as slow as it is , prob has the other half of the data you don't get from that page. Only prob is you have to have an account and log it to get it. If you have , got to the race in question and click on DFS and then you'll see the field with race starts and placings etc. That coupled with the API and other stuff from that first page could be quite handy. Bit of mucking about though
Reply With Quote