Find Jobs
Hire Freelancers

UK Horse Racing Database Calculations of Results and Automatic Import

£20-250 GBP

Opravljeno
Objavljeno pred približno 9 leti

£20-250 GBP

Plačilo ob dostavi
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.
ID projekta: 7664105

Več o projektu

9 ponudb
Projekt na daljavo
Aktivno pred 9 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
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 v 5 dneh
4,9 (8 ocen)
3,5
3,5
9 freelancerjev je oddalo ponudbo s povprečno vrednostjo £179 GBP za to delo
Avatar uporabnika
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 v 5 dneh
5,0 (1 ocena)
1,7
1,7
Avatar uporabnika
I have 5 year experience working with databases.
£222 GBP v 5 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
£142 GBP v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 20 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I have more than 10 years of software development experience. I am interested to work in your project.
£150 GBP v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
£155 GBP v 1 dnevu
0,0 (1 ocena)
0,0
0,0

O stranki

Zastava UNITED KINGDOM
Harrogate, United Kingdom
4,7
5
Plačilna metoda je verificirana
Član(ica) od mar. 17, 2015

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.