- This topic has 4 replies, 4 voices, and was last updated 9 years, 8 months ago by
.
-
Posts
-
Hi All
I used to download racecards into Excel using the “Data” “Download from the web” but the RP has long since prevented this being possible and now I can’t do it with ATR or Sporting Life as I can’t find the Cheltenham cards. Does anyone know a source?You can still load cards into Excel from the Post’s site.
If you copy a card (for technical reasons, better under Mozilla Firefox or Google Chrome than Internet Explorer) and paste it into a blank Excel sheet, using “paste special”, “text” rather than simply “paste”, you’ll see all the data is there, albeit not lined up well and some not in the form you’d expect (weights change to dates, etc). It is a relatively simple matter for an Excel expert to code up an Excel sheet and create a small application, so that when you paste the data in, what you want (which of course you have to specify clearly to the expert) appears in the form you want it on another Excel sheet.
If you Google freelance Excel expert or similar you’ll find various websites from which experts can be hired, and one of those will create a bespoke application for you for very little money.
Over the years I’ve commissioned several such experts from one of the main freelancer sites and, with one exception, they’ve been excellent. (And as you don’t pay fees until the project is complete, you can’t get ripped off.) For the last several years I’ve solely used one chap, based in Indonesia, who charges $20 US an hour and who is the best I’ve come across. He’s done dozens of projects successfully for me as I’ve developed my race analysis application. I don’t know whether it is permissible within the forum’s rules for me to post his name, but if it is and you’d like it I will.
I’m pretty sure that such experts could equally easily create applications for downloading cards from the other sites you mention, but the Post suits me best.
Ricky
Nowadays I have one application for holding my Flat database, adding each day’s results to it, downloading the card of any race I wish to analyse and producing the analysis of the race, and a virtually identical one for the NH. I use Excel because I’m familiar with it and (under Windows 7 64 bit) it works very quickly. I’d have to put in a lot of time to become as proficient with, say, Access as I am with Excel and have yet to be convinced that there would be any significant gain in speed of operation.
We’ve been sending out results and declarations daily to our Access database and software for over twenty years.
All the information can be exported to Excel or anything else.
Download the full system for free from http://www.simplesoftware.co.uk/ssr1.htm to see if it what you need.
Mick Johnson
- You must be logged in to reply to this topic.