View Single Post
  #6  
Old 1st August 2010, 06:51 PM
gsdanger gsdanger is offline
Member
 
Join Date: Jan 1970
Posts: 29
Unhappy Calling OZDOC - Help!!!!

download unitab horse data into excel spreadsheet - problem

--------------------------------------------------------------------------------

Good Evening OZDOC,

I have been having data download problems with the spreadsheet (Tomorrow racing today - 1st attachemnt). I received this spreadshet from you 5 or 6 years ago and have been using this spreadsheet, in concert with a spreadsheet I have created (2nd attachment) to analyse each horses current form and rate, sort and price them according to the rating figures derived from this analysis. I can rate a race in 1 minute. Works well.

Unfortunately, about 12 months ago, I upgraded to Microsoft Office 7 suite, and at the same time upgraded my PC. My PCs operating system is now Windows 7.

I thought this transition to office 7 and windows 7 was the reason for my spreadsheets not functioning. Maybe not. Might be that the unitab site might have been upgraded, or re-configured.

Obviously, you will be familiar with the workings of the first spreadsheet (originally yours), so could you possibly have a look, the attached spreadsheet (tomorrow racing today) and see if you can get it to download the detailed form from the unitab site. Currently, the spreadsheet works in a limited way. It downloads the abbreviated form available but not the detailed form.(the spreadsheet should also be populated to the right of column ‘Z’ also). Obviously the ‘Get external Date’ functions are working, however it seems that there is some sort of limiting factor (maybe with the unitab site) that is precluding the detailed form to be downloaded in it’s entirety.

Normally, when this spreadsheet obtains all the detailed form, I minimise it and open my other spreadsheet (KwikPick Form Analysis). All I have to do then is input all the day and race data on the main page (including the race date), then go to the race I want to rate (hyperlinked to the relevant worksheet). Here I only need to input the following in the ‘red’ area: YYYY/MM/DD/XRXX for example: 2010/07/MR05 and press the ‘Get Data’ Button. All the form is then downloaded into this spreadsheet and assessed. I then press the ‘sort and Price the Selections’ button. The horses are sorted in highest rated order and priced accordingly.

I will be very greatful if you can assist me in getting this spreadsheet functioning correctly. Without it, I'm struggling to find an alternative web site to download appropriate data from, and am slowly dying on the punting vine. Please Help.....

Kind Regards.

gsdanger
Attached Files Tomorrow Racing Today.xls (1.05 MB, 41 views)
__________________
Garry D.
Reply With Quote