I run a horse racing web site that publishes daily horse racing ratings in the UK - [[url removed, login to view]].
Whilst I publish the historic results individually through hyper links in a calendar, I need a database where all of the results can be held and each parameter or group of parameters can be searched and reported upon.
The ratings data is held in excel spreadsheets - one file for each horse racing meeting, with up to 8 sheets in each file ??" one for each race, with the results and odds entered for the winners and places in each race. The ratings are held in three standard templates ??" an old template and a current template for flat racing and one current template for National Hunt racing.
There is approximately 1800 files with on average 6 races in each.
Build a database that will hold all of the information that I have currently in separate fields and also add some extra fields based on the data contained in Excel.
Create an easy to load process for existing data and new data.
Create an import process for each historic race to import the full results (possibly screen scraping from the [url removed, login to view]) and match them against the runners in each race. This does not necessarily need to be **fully** automated, but the adding of the data and placing the correct odds in the correct format next to the correct horse must be automated.
Allow the data to be searched on each variable or group of / multiple variables over user defined date ranges, and values (including < = >)
Have the ability to manually override data in case of anomalies
Help with the integration of the database into the existing Front Page web site using the same and look and feel template
Split the existing data into variables as follows.
Time of each race
Racecourse type (Flat, all weather or national hunt ??" taken from a list of courses and race distances)
Type of race (this would need to be intelligently captured from the race title. Eg. Handicap, claimer, etc) in line with a set of rules I will provide.
2 separate ratings scores **by value**
Results ??" position, odds, favourite flag,
Count number of runners in a race
Place a flag next to each horse type by their font colour (blue, red, black and purple)
Count number of blues, reds, blacks and purples
Intelligently work out the rank position of each horse (which are held in reverse order)
2 separate ratings score **by margin** to the next ranked horse
Race Favourite flag (taken from imported results data)
The database must be compatible with microsoft frontpage.
A drop down field or entry field for each variable, that will then search the database and present a report
* Number of winning/losing/placed horses
* % of winning/losing horses
* Number of points made / lost
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
I am assuming Access is the best way to go.
The database has to be able to integrate to my MS Frontpage website
I run XP