Find Jobs
Hire Freelancers

Access or MS SQL database project

$30-250 USD

진행 중
게시됨 약 9년 전

$30-250 USD

제출할때 지불됩니다
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 this database or create your own in Access or MS SQL. The data is extracted each day using Helium Scraper. I currently save this as an access .mdb database file which consists of two tables. It is possible to save the data as CSV or XML. There are occasions when I have a further csv file which are results scraped using another method. It contains the same fields as the Helium Scraper output. There is initial data which is apart from the daily results is also a CSV. This has every horse that is training, plus sire and Dam information. This would be input for updates every week and has several thousand records of which a small number would be added to the database. When the daily results are input there needs to be a number of calculations on each individual race result. Which is the main reason for out sourcing these tasks. (a) The first of these takes the prize money, race type and associated items (no more than 5)to form a base rating for the race. This figure should be allowed to be manually overwritten if required by myself. After that has been done then a numerical rating for each runner needs to calculated. This is based on the weight the horse carried and the distance beaten. Again if any figure needs amending manually this should be in built. (b) The second calculation is based around the winning time of the race. This would be based upon each race course and the individual distance of races held. The average of the last 6 winning times and the average class of those races. These two figures would form the basis for a ‘speed figure’ calculation. Again the weight and distance beaten would form that part of calculation for each horse. The information that is held in the database would then need to be queried for the current days race cards. The race cards will be scraped from the internet site and saved as CSV files to work with Finally the information that forms part of the initial ratings, paragraph (a) I need to be able to amend the base that the calculations are taken from. This information is from several years work that is not for public knowledge.
프로젝트 ID: 7320579

프로젝트 정보

18 제안서
원격근무 프로젝트
활동 중 9년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
A proposal has not yet been provided
$110 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I am excited about this project because it has many similarities to a project I developed for tracking athletes, selecting teams, weighting recent performance against personal bests. I have been working with Access since it was first released. I advise against MS SQL (personal edition) - only the Enterprise edition is solid, and would be overkill. Good open source SQL solutions if you want to go down that line in the future. But you seem comfortable in Access and I would recommend sticking with it. Some interesting edge cases - what if there isn't 6 race results to calculate an average - use the 5 (or 4) and flag it as such? Your decision of course. You seem knowledgeable, so I would provide well commented code you could make small tweaks yourself. For your test question, I would ensure the data had the placing as a field (even if that is derived from data order). Fractional lengths would need to be converted to decimals (trivial if required). Final result would be: "ID","Race","Name","Place","Distance Beaten","Adjusted Weight" 1,1,"Horse A",1.00,0.00,110.00 2,1,"Horse B",2.00,2.00,116.00 3,1,"Horse C",3.00,1.00,119.00 4,1,"Horse D",4.00,1.50,123.50 5,1,"Horse E",5.00,1.75,128.75 6,1,"Horse F",6.00,4.00,140.75 7,1,"Horse G",7.00,0.50,142.25 8,1,"Horse H",8.00,2.00,148.25 Code can be viewed at [login to view URL] This is my first project with Freelancer. I'm looking to impress you, and build a long-term relationship, if you need additional work done.
$111 USD 7일에
0.0 (1 건의 리뷰)
0.0
0.0
18 이 프로젝트에 프리랜서들의 평균 입찰은 $196 USD입니다.
사용자 아바타
Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, AWR, ADDM, Asmcmd, Asmca, Tkprof I Can do your work easily. Let me know when we can discuss.
$300 USD 7일에
4.7 (12 건의 리뷰)
4.2
4.2
사용자 아바타
Hi. I am professional database developer. I will satisfy all your requirements for this project in 5 days. If you like my offer, feel free to contact me. Thanks
$111 USD 5일에
4.9 (6 건의 리뷰)
3.0
3.0
사용자 아바타
please send details, i can implement it in Access in 3-4 days .
$250 USD 10일에
5.0 (1 건의 리뷰)
2.8
2.8
사용자 아바타
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
$277 USD 7일에
5.0 (1 건의 리뷰)
1.7
1.7
사용자 아바타
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Regards, Hardik Shah
$200 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Dear Sir, I have been designing and developing databases for a long time and can accomplish this task with ease. I have skimmed your requirements and have understood most of them. Please give me a chance to work with you Also you can message me so that we can talk more about it Waiting for your reply Thanks
$200 USD 6일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
We are an innovative technology company with ample experience in the areas you mentioned. We will be delighted to find out more about the specifics of your project and take it to the next step. Our initial bid is $250, subject to confirming scope and required functionality, in hopes of establishing a long term relationship.
$250 USD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
$155 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello, I'm developing for/with my customers MS Access applications since mor than 25 years. Selecting me for this project you'll get a very professional development yof your requirments. Based on the project description I'll write some extensions on your existing access application - two calcualtions (perhaps as report if needed) and two forms to enter the figures for each calculation. Additionally I'll provide a table to store the predefined figures for later use. If you want some screenshots of my previous project pls. let me know. Best regards, Paul Goldbeck
$300 USD 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
10 years of experience in Business Intelligence and Databases (Data integration,Data Quality,Database Design,DBA,...)
$222 USD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Field of interest : IT Education : Master's in Computer Application Technology : JAVA, Oracle Database, MS Access, My Sql. OS : Windows, Unix Others : Excel.
$155 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi Chris, If I'm understanding your requirements correctly your Adjusted Weight for the sample race would be calculated as per the below table (currently done in Excel). Name Lengths behind Distance Beaten Adjusted Weight a 0 0 110 b 2 2 104 c 1 3 101 d 1.5 4.5 96.5 e 1.75 6.25 91.25 f 4 10.25 79.25 g 0.5 10.75 77.75 h 2 12.75 71.75 As a matter of interest, is the 110 a fixed weighting used for the winner of any race or is it an on-going stored figure against horse A that has been calculated from previous races? Personally I'd use SQL Server from preference however could use Access if desired by yourself. I'd use a series of work / temp tables, rank() and self joins to calculate the values based on the previous record. I prefer to use set based logic rather than cursors as it is more efficient. Regards Mike.
$300 USD 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I am strong in SQL server , Database designing and development, I Have 3 years strong experience in Database development in SQL server and Ms Access.
$155 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
La propuesta todavía no ha sido proveída
$80 USD 15일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello I read your job posting and I have all the required skills. Having worked with Access and MSSql databases for over five years, I am the best candidate for the task. I am also a Certified Microsoft Professional, having done all the database and Microsoft Office development tests at Microsoft. I am fully available for the job. My payment rate is also negotiable. Thank you Duncan Professional database developer
$222 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I am working access,vb, sql developer at leasing company ,8 years experience, i has master degree of IT.....
$155 USD 2일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED KINGDOM)
Harrogate, United Kingdom
4.7
5
결제 수단 확인
3월 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)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.