Find Jobs
Hire Freelancers

UK Horse Racing Database Calculations of Results and Automatic Import

£20-250 GBP

Complété
Publié il y a presque 9 ans

£20-250 GBP

Payé lors de la livraison
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.
N° de projet : 7664105

Concernant le projet

9 propositions
Projet à distance
Actif à il y a 9 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
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 en 5 jours
4,9 (8 commentaires)
3,5
3,5
9 freelances proposent en moyenne £179 GBP pour ce travail
Avatar de l'utilisateur
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 en 5 jours
5,0 (1 commentaire)
1,7
1,7
Avatar de l'utilisateur
I have 5 year experience working with databases.
£222 GBP en 5 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
£142 GBP en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 20 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I have more than 10 years of software development experience. I am interested to work in your project.
£150 GBP en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
£155 GBP en 1 jour
0,0 (1 commentaire)
0,0
0,0

À propos du client

Drapeau de UNITED KINGDOM
Harrogate, United Kingdom
4,7
5
Méthode de paiement vérifiée
Membre depuis mars 17, 2015

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.