I currently store the past performances of greyhounds in an excel spreadsheet, or number of sheets.
I collect a number of pieces of data about each dog in each race. This data is then processed via formulas in the spreadsheet to deliver a "performance rating". Factors taken into account include the track, distance, starting boxes, class of race, sectional times, winning time, margins from winner, interference, track condition, etc.
These performance ratings are then used as the base for calculating "predictive ratings"for greyhounds in up-coming races, using formulas I have developed in Excel.
I want a database that automates the process, so that results can be pasted into a table, and these would then be processed into records of each dog, and performance ratings calculated. Then, by querying the database from an excel sheet for runners in an upcoming race, after taking into account factors such as class of race, starting box, track, distance, track condition, expected sectional times, etc.
I want to be able to query anything from the database in my excel sheet.