Find Jobs
Hire Freelancers

UK Horse Racing Database Calculations of Results and Automatic Import

£20-250 GBP

Завершено
Опублікований about 9 years ago

£20-250 GBP

Оплачується при отриманні
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 проекту: 7664105

Про проект

9 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 5 дні(-в)
4,9 (8 відгуки(-ів))
3,5
3,5
9 фрілансерів(-и) готові виконати цю роботу у середньому за £179 GBP
Аватарка користувача
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 за 5 дні(-в)
5,0 (1 відгук)
1,7
1,7
Аватарка користувача
I have 5 year experience working with databases.
£222 GBP за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
£142 GBP за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 20 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I have more than 10 years of software development experience. I am interested to work in your project.
£150 GBP за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
£155 GBP за 1 день
0,0 (1 відгук)
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
Harrogate, United Kingdom
4,7
5
Спосіб оплати верифіковано
На сайті з бер. 17, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.