Kapalı

Access database

**_Overview_**

I run a horse racing web site that publishes daily horse racing ratings in the UK - [[url removed, login to view]][1].

Whilst I publish the historic results individually through hyper links in a calendar, I need a database where all of the results can be held and each parameter or group of parameters can be searched and reported upon.

The ratings data is held in excel spreadsheets - one file for each horse racing meeting, with up to 8 sheets in each file ??" one for each race, with the results and odds entered for the winners and places in each race. The ratings are held in three standard templates ??" an old template and a current template for flat racing and one current template for National Hunt racing.

There is approximately 1800 files with on average 6 races in each.

**Requirements.**

Build a database that will hold all of the information that I have currently in separate fields and also add some extra fields based on the data contained in Excel.

Create an easy to load process for existing data and new data.

Create an import process for each historic race to import the full results (possibly screen scraping from the [url removed, login to view]) and match them against the runners in each race. This does not necessarily need to be **fully** automated, but the adding of the data and placing the correct odds in the correct format next to the correct horse must be automated.

Allow the data to be searched on each variable or group of / multiple variables over user defined date ranges, and values (including < = >)

Have the ability to manually override data in case of anomalies

Help with the integration of the database into the existing Front Page web site using the same and look and feel template

## Deliverables

**More information**

**Data Fields**

Split the existing data into variables as follows.

**Existing Variables**

Date

Time of each race

Racecourse

Racecourse type (Flat, all weather or national hunt ??" taken from a list of courses and race distances)

Type of race (this would need to be intelligently captured from the race title. Eg. Handicap, claimer, etc) in line with a set of rules I will provide.

Distance

Horse draw

2 separate ratings scores **by value**

Jockey

Trainer

Results ??" position, odds, favourite flag,

**New variables**

Count number of runners in a race

Place a flag next to each horse type by their font colour (blue, red, black and purple)

Count number of blues, reds, blacks and purples

Intelligently work out the rank position of each horse (which are held in reverse order)

2 separate ratings score **by margin** to the next ranked horse

Race Favourite flag (taken from imported results data)

**Other requirements**

The database must be compatible with microsoft frontpage.

**Reporting Requirements**

A drop down field or entry field for each variable, that will then search the database and present a report

* Number of winning/losing/placed horses

* % of winning/losing horses

* Number of points made / lost

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

I am assuming Access is the best way to go.

The database has to be able to integrate to my MS Frontpage website

I run XP

Beceriler: Mühendislik, Microsoft Access, MySQL, PHP, Yazılım Mimarisi, Yazılım Test Etme

Daha fazlasını gör: work place trainer, web scraping weather data, weather coder, standard templates, red black data, order form format in excel, new hire reporting requirements, new hire reporting form, new hire reporting, national hire, ms new hire reporting, ms access form data entry, ms access data entry form, microsoft web templates, microsoft excel group, microsoft access data entry form, list of website courses, i need an access database, hyper racing, horses for hire

İşveren Hakkında:
( 7 değerlendirme ) United Kingdom

Proje NO: #3787358

Bu iş için 14 freelancer ortalamada $863 teklif veriyor

OpenSourceDev

See private message.

in %bids___i_period_sub_35% gün içinde5950%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
6.0
phosphorvw

See private message.

in %bids___i_period_sub_35% gün içinde212.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(90 Değerlendirme)
5.9
aroy1968

See private message.

in %bids___i_period_sub_35% gün içinde850%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
5.3
advantixvw

See private message.

in %bids___i_period_sub_35% gün içinde340%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(59 Değerlendirme)
5.3
fauziaomer

See private message.

in %bids___i_period_sub_35% gün içinde425%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(58 Değerlendirme)
5.1
shraddhamit

See private message.

in %bids___i_period_sub_35% gün içinde637.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
4.2
ioulaum

See private message.

in %bids___i_period_sub_35% gün içinde93.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
3.6
abdulghafoorvw

See private message.

in %bids___i_period_sub_35% gün içinde382.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
2.6
oruckenaneu

See private message.

in %bids___i_period_sub_35% gün içinde1657.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
2.5
bursuk

See private message.

in %bids___i_period_sub_35% gün içinde42.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.0
knrp9000

See private message.

in %bids___i_period_sub_35% gün içinde595%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.5
craig0201

See private message.

in %bids___i_period_sub_35% gün içinde369.75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
cynnerg

See private message.

in %bids___i_period_sub_35% gün içinde403.75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
2.3
booleanaxis

See private message.

in %bids___i_period_sub_35% gün içinde127.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0