Continuing saga of my horse racing project.
I am using Access 2010 and Excel 2010.
I have attached a small database with a table and 2 queries.
'Table1' has the following fields:
MtgDate, Race, Margin (in metres), Rate
For each Race I want to get the average Rate for Top 6 Horses that finish...
Sorry. been away for a week. Yes I think that may be the way to go. I am still getting my head around this task. I have mocked up a small Excel pivot table with 4 horses over 5 races. It takes approx 25 iterations to almost converge. I'll attach the .xlsx
The program I am trying to implement is taken from Bob Wilkins book "Bioenergetics and Racehorse Ratings". As part of the final stages there is a convergence performed on all races for all horses currently running. The average racing life of racehorses is 3 - 5 years so that is what I am working...
Perfect!! Thanks for that. It does exactly what I wanted.
Now my next problem is dealing with the Access limitation of 255 columns but that can wait for now.
Wow. Thanks for the response.
I thought this may need some more information to aid you good folk so, I have created a sample DBase with tables and queries and also include an excel pivot table.
As previously stated I am trying to establish form-lines between horses for each race. I have...
I have slowly built my horse racing database for many years and am now at the stage where I need help with some queries.
Given a race with say 10 horses I want to find all races prior to the current race where at least 2 horses from current race have competed against one another. I want to look...
I have been reading this web site for several years and found it very informative. This is the first forum I have joined so will be feeling my way for a while.
I'm in my 70's now and have been slowly developing my horse racing database program since last century. I purchased a copy of MS-Office...