Find Jobs
Hire Freelancers

UK Horse Racing Database Calculations of Results and Automatic Import

£20-250 GBP

Completed
Posted about 9 years ago

£20-250 GBP

Paid on delivery
I have an Access database that I wish to populate with UK and Ireland horse racing results. If this project is taken up you can either use my existing database or create your own in Access or MS SQL. The data is extracted each day using Helium Scraper. This is saved to a [login to view URL] (Access) file containing 2 tables. I have the option to save as CSV or XML so there are some good options for data import. There are occasions when I have a further csv file which are for results scraped using another method for overseas horse racing. It contains the same fields as the Helium Scraper output. So import is compatible. For each horse racing result I need a calculation performing. This is first done by creating a Base Rating. This is done by awarding points based on the Type of race, prize money, number of runners etc. You will be referencing a set of tables (columns) which is in a spreadsheet. The calculation is a fixed formula. Preferably these references should be placed in the database as a table rather than spreadsheet being used. The base rating should be allowed to be manually amended before committing to the next step. The second part is to rate each horse from this Base Rating. This is based on weight carried and distance beaten and other items .Again these calculations are done by referencing tables (columns) in the spreadsheet The ratings should once again be allowed to be manually amended before committing to the database. Carrying out the calculations and updating the database is the KEY to this project, as is making the import and actual calculation as automated as possible. There are a number of Tables which will need linking to the results Horse Table - each horse is a unique entry. Sire Table - Each father is linked to the Horse (table) it Sires Dam Table - Each mother is linked to each horse (table) it gives birth to. Trainer Table - Jockey Table - Course Table - There is a requirement to record winning times for each course. This will contain Distance of race, Going, Time recorded This is part one of 3 stages to the overall project. The payment will be for this phase 1. Phase 2 will be around using the winning times to create speed figures Phase 3 will be way of extracting the data including populating race cards where 'race entry' details will have been scraped from a website. So I am looking for Phase 1 of this project to be carried out.
Project ID: 7664105

About the project

9 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi. I am professional database developer. I understand what do you want to achieve. My suggestion is to take MYSQL server and create the database. We can handle import of XML or CSV file through SSIS (compatible Microsoft tool, not free) or better schedule Java job for free to do the extraction. If you want to chat more, feel free to contact. Thanks
£166 GBP in 5 days
4.9 (8 reviews)
3.5
3.5
9 freelancers are bidding on average £179 GBP for this job
User Avatar
This can be done using Sql server inbuilt SSIS tool which can import csv files or import access db , do the custom calulations , Apply business logic to it to provide info in a user specified format
£246 GBP in 5 days
5.0 (1 review)
1.7
1.7
User Avatar
I have 5 year experience working with databases.
£222 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My proposal is make a .NET program which imports your data to MS SQL database. If you want I can do a Windows GUI application which imports the CSV or XML file and allows you to edit Base Rating directly in it. I have a license of DevExpress components which makes the application look really professional and easy-to-use. I have done similar project before - import of Bar Association - including scraping. But as you can see I am new to freelancer so I don't have any reviews. If you agree I can make some smaller part of the project (for instance milestone 1) so that you can verify my skills. You have mentioned a spreadsheet of formulas. Could you give some example of how such a formula looks like? I assume that Horse Table, Sire Table, ... already exist with data imported.
£211 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£142 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I'm Delphi developer. I can write application that will run on Windows OS, only one exe, for database I would use SQL server express (it's free). I done many projects so I know that good app can't be developed in few days, so I wrote 20 days. regards Davor
£222 GBP in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 10 years of software development experience. I am interested to work in your project.
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£155 GBP in 1 day
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Harrogate, United Kingdom
4.7
5
Payment method verified
Member since Mar 17, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.