If you could find the form i could make this work with the greys, at least i think i could.

Ok new version up now that fixes the issue with the meetings page ,should be fixed let me know.

I will have another version up later that will record those results on a different sheet.

shaun, i get this message whne i open the file:
" excel found unrreadbale content in formratings...
do you want to recover the contents of this workbook.?
if you trust the source of this workbook , click yes."

Any comments.
thank you
aussie

Not sure what that is but does not seam to do any harm, will work on it a bit later meed to sort out a few bugs

I have made an update to fix a few problems and have added a results page.

Shaun
I don't know whether I will use your program ever or not.
But I would like to say it is very noble of you to share.
May Allah bless you and your family and rain rewards on you that you justly deserve.

thanks shaun,
are you having any problems opening cyberhorse ?
this is my message this morning at 8.50AM.

"Run time error '1004'
unable to open
http://formguide.cyberhorse.com.au/.../view-form.html?
Cannot locate the internet server or proxy server.


i then typed in
http://formguide.cyberhorse.com.au/index.php/form/view-form.html

to my browser and it would not open the page ???


am i missing something ?

thanks and cheers
aussie

I see the problem yet again another abbreviation in the name Port is displayed as PT, go to the "Meetings" sheet and change PT to PORT and that should fix it for now

New vweaion fix this issue.

thanks shaun,
what about cyberhorse ???
can you get that web page/site to open

i cant get that to open manually or automatically - do i have to be a subscriber or something,
cheers and thanks again

aussie

Tell me if the form imports with the new version as i had no issues

New update, i have improved the price element and fixed a couple miscalculations, i found with the prices it would change the order of rating, so now it calculates it different to maintain your order.

same message
"cannot locate the internet or proxy server etc"

for cyberhorse.

i have tried their site manually and it will not load...?
is anyone else having this problem?

thanks

aussie

No problem with the site, try clearing your browser cache.

I did find another bug in the unitab ratings so would suggest not to use that form value for now.

thanks shaun
- yes i found out my IP address had been blocked by cyberhorse.
how weird

cheers

aussie

I wonder if the amount we access the site has anything to do with it, well i guess time will tell.

Hi Shaun,

Impressive work,i think you may be able to help me with something,could you please email me at go the halatau at hot mail dot com and ill write you back.

Cheers

I have made an update to solve the issue of the way some races are displayed, also changed the layout a bit so read the instructions for changes, i will fully test tomorrow and let you know if i find bugs.

Form Ratings 2010.xls - Latest Version?
 

Good Day Shaun, (and Kennedy 22384)

I have been absent from this forum for quite a few years. One of my posts was for assistance with downloading race data from the Unitab website, for data analysis and ratings production. Kennedy 22384 responded to my enquiry (22Nov2010). Unfortunately, I have only just read his response now (30Jan2012 !!). I appreciate Kennedy 22384 s efforts in trying to fix my initial problem. I downloaded his attached spreadsheet and have run it. unfortunately it has an error or 2 in the running of the macros.

I followed the thread down and have been interested in your Form Ratings 2010.xls spreadsheet. Am I able to obtain a copy of this spreadsheet, as it looks very good. I'm not sure how many updates you have completed, as the attached copies of the spreadsheet went off the forum after you posted the above referenced thread. I would like to experiment with some rating methods I have. If they seem profitable, I will post a copy onto this forum for all to use.

Please advise. Also, if Kennedy 22384 reads this thread, Thank you for attempting to assist me in my original problem...It was soooo long ago!!.

Kind Regards...

From the Unitab site i can only get data from the main page as i don't have an account.

I can get data from Cyberhorse and i have made many updates to fix issues and stuff.

What version of excel do you have?

Form Ratings 2010.xls
 

Good Morning Shaun,
I am using excel 2007 version.
As stated in my previous response, can I have a copy of your Form Ratings 2010.xls spreadsheet please (latest version).

Kind regards...

gsdanger...

Form Ratings 2010.xls
 

Good Morning Shaun, again,

Further to my last reply (excel version 2007),
I only used unitab for the complete form download. I don't bet with them. I bet with the NSW TAB. So I don't care where the form downloads come from, as long as the spreadsheet works. So if your Form Ratings 2010 spreadsheet extracts form from other souces than Unitab, that's fine. I just want to look at experimenting with your spreadsheet (very good) with some rating and pricing ideas I have.

Hope you can supply me with a copy of your latest version of your spreadsheet.

Kind Regards..

gsdanger....

FOrm Ratings 2010.xls
 

Good Morning Shaun,

I noticed in your quote above, you mention that the link to this spreadsheet is "the link is in my sig".
Where can I access the link please? What does "the link is in my sig" mean?, and where can I access this?

Please respond. Kind Regards... gsdanger...

Here you go, this is my latest sheet it has been reworked from the sheet you had and imports data in a different way.

The sheet also contains the newest ratings idea i was using so feel free to use it or rework it for your own.

Ratings 2012
 

Good Day Shaun,

Thank you very much for this spreadsheet. I have downloaded it and ran it.
Unfortunately, reading the instructions, in particular items 3 and 5, there is a reference to a drop down box? The left column under "Race Venues" is blank. I cannot locate any drop down box on the Racelist sheet... Am I missing something? If so, please indicate where I can locate this drop down box please.

Kind Regards..

gsdanger....

If you have a list of races in the box the drop down box is on the left.

When you first open the sheet go to RaceList sheet and you should see 4 venues already in the boxes, click an empty one and see if you get the list of races.

This is an old race day but if you see the list than you know that part works.

Hi Shaun,

Thanks for your time on this...
I have re-installed the spreadsheet just now and have run it.
I have gone to the Racelist sheet.There are 2 columns under Race Venues.
The right hand one has all the downloaded race venues in it Wanganui, Rockhampton, Hawkesbury, Geraldton and Ballarat. Obviously todays races.
the left hand column is completely blank. I have clicked all the left hand cells. All I get is an indication that the cell is the active cell. No drop down box ! I'm sure the rest of the process won't function without selecting the race venue I want. Any thoughts. Please assist...

Kind Regards...gsdanger

Still the Data Validation issue, no problem try this version, same instruction except a bit different to get the races in the box on the left.

Hi shaun,

Yep... That version worked..Thanks heaps for this..As you know, I have been fiddling around with spreadsheets and ratings for years (over 10). I had it all worked out with the Unitab downloads and my spreadsheet rating sheet. Unfortunately, unitab decided to alter their detailed formguide options. It rendered my download options from them useless.
I have since been looking at re-creating a spreadsheet again, similar to my original Kwikpick.xls spreadsheet. Your effors have been magnificent....
You have saved me countless hourse of frustration with trial and errors with VBA , functions and formulas. A thousand thank yous to you (and a few beers).
I will make a copy of your spreadsheet and use the copy as experimenting with the rating values, and other things. If i manage to create the Eldorado...I will post it here for all to share in....Here's hoping, although your ratings seem to be close to the mark..You never know, another pair of eyes and a bit more grey matter can help us all.
Once again, thank you for this spreadsheet. I will keep you advised of my exploits and results.

Kind Regards......gsdanger

Glad it worked, just about everything i know about excel is used in that sheet from the downloads to the formulas that extract the info.

It has always been a work in progress and some parts of the sheet are still incomplete but as a working ratings it does work.

A lot of info in there has been provided by members of this forum and others, particularly the pricing side of it that i have struggled to get as accurate as possible.

The pricing was provided by a member from this forum the name escapes me at this time but i am sure they know who they are and is contained on other threads.

The original download idea was first posted by Kennedy can't recall his exact user name, he also has some downloads on this site that are a bit more refined but i adapted them to suit my needs and knowledge of excel.

A lot of info was gained from Mr Excel Forums that place has a wealth of information and help, specific racing macros and formulas were obtained from the Gruss forum.

these are just a few places i gained the knowledge to create the program, Google search filled in the rest.

If you are looking at a new source of data to download take a look at centrebet.com they have a great form guide that i was going to use if cyberhorse ever failed on me.

FVRatings 2012 Update
 

Good Day Shaun,
yes, this trying to sort out the form and coming up with workable ratings and prices is always going to be a 'work in progress'situation.

The availability of the criteria values (Tables) sheet is great. Lets the user experiment with different combinations of values.
I guess there is no right or wrong way to rate horses. It all comes down to the users's ideas on which criteria is the most important..
I created my base rating from the average prizemoney of each horse. I know the API is basically this, However, I assigned a base rating to each horse based on the average prizemoney base rating gained from a scale I set-up, from 45 (the worst - catered for low class horses with an average prizemoney of less than 1K, to 60 (the best - catered for the champs of our sport - the Kingston Towns, Octagonals, and Lonhros). the rest of the horses were allocated a rating between these figures (naturally all done authomatically with excel). Then the Plus and Minus of the other form aspects were applied, giving me a final rating for each horse in the race. This was then priced (rating differences converted into the decimal differences and the price calculated from this).
I used these figures for race to race betting at the track, or exotics at home. All worked very well until I had the problem with Unitab re-configuring their website a few years ago. However, with this spreadsheet, I can resume building what I perceive to be a good rating method. As stated before, if I happen to have some long term on-going success, I will share it with all on this forum.

Shaun, with regards to the results sheet, does this update with the results automatically?
Also, the listings of the rated races on this sheet, can they have the race times inserted somewhere and then sorted by race times, to give you a progressive list of events by time, rather than by meeting. Maybe this could be an option, rather than the current meeting by meeting listings. Just a thought. Anyway, once again, thanks for your efforts (and all the other members who have contributed). I'm sure this spreadsheet will mature into an essential tool for rating horses in a quick and efficient manner.

Have good day Shaun.. Talk to you soon.

gsdanger