Find Jobs
Hire Freelancers

Data extraction from website to Excel sheet

$30-250 USD

已取消
已发布将近 14 年前

$30-250 USD

货到付款
We are looking for long term assistance in extracting data from the "results" section of the Racing Post website ([login to view URL]) and putting it into an Excel sheet. We extract details of about 110 races a month, but this is the long term crude average. In the Winter months numbers are often much less and in the Spring and Summer much more. Over the last 40 months the average race has had 10 runners, but again this varies greatly, with as few as from 2 and as many as 36. For each race we extract four pieces of data: date of race, course race run on, length of race, and going on which race is run. For each runner in the race we extract six pieces of data: horse name, the weight it carried, its Official Rating, its finishing position, the distance it won by (in the case of the winner) or distance it finished behind the winner (in the case of all other runners), and its starting odds. The data is placed in an Excel sheet, sample attached, as follows: Col. A - date of race Col. B - index no. (In the sample the next race would be 1001, then 1002 etc) Col. C - course. For racecourses with short names such as York, Epsom and Redcar, the names in full. For longer ones the first four letters ie Newmarket = Newm., Newbury = Newb. etc Col. D - horse names with, for each race, winner first, second second etc Cols. E and F left blank Col. G - race distance to nearest half furlong (but usually a whole number eg 8, 10 Col. H - weight, always a three or four digit number, eg 10.02 or 9.10 Col. I - the horse's Official Rating (OR), always a two or three digit number Col. J - the going: seven possibilities: good = g, good to firm = g/f, good/soft = g/s, firm = f, soft = s, heavy = h, standard = aw Col. K - finishing position, from 1 to 36. Occasionally two horses dead heat, so for example there may be two finishing 3rd, in which case the next horse counts as finishing 5th Col. L - finishing distance rounded to nearest 0.1. For the first horse this is always a positive number, from 0.1 upwards. For all other runners it is a negative number representing the distance behind the winner (NOT, except for the second horse, the distance behind the horse immediately in front.) Thus a horse finishing sixth, beaten 9 lengths, would be shown as -9.0. The Post site gives some distances in words not numbers. A neck (nk) counts as 0.25, a head (hd) as 0.1, a short head (shd) or nose (nse) as 0.0, EXCEPT where the second was beaten a nose or a short head, when it counts as 0.1. (Thus in a four horse race where the second finished a nose behind the winner, the third a neck behind the second, and the fourth a length behind the third, the col. L entries would be 0.1, -0.1, -0.3 (not -0.4, as the nose or short head only counts as 0.1 when it is the second behind the winner, otherwise it is ignored) and -1.3.) Cols. M, N and O left blank. Col. P - odds expressed to nearest 0.1. Usually the odds are whole numbers, eg 6.0. But some are shown in the Post as fractions, eg 11/4, which is 2.75 rounded to 2.8. For this project we are inviting bids for extracting the relevant data for 40 races likely to involve between 400 and 450 horses (a list of dates and times of which will be sent to the successful bidder and cover the period 30 April to 3 May). But we hope that bidders will be interested in regular work of the same kind. We are happy to clarify anything above which is not clear.
项目 ID: 676111

关于此项目

19提案
远程项目
活跃14 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
19威客以平均价$113 USD来参与此工作竞价
用户头像
Ready to start,send pm for detail
$200 USD 在6天之内
4.6 (68条评论)
6.2
6.2
用户头像
Please check PMB. Thanks.
$75 USD 在1天之内
4.4 (130条评论)
5.8
5.8
用户头像
Dear sir/madam please refer to your PMB. Thank You.
$250 USD 在5天之内
5.0 (3条评论)
4.0
4.0
用户头像
Hi, Pls check PMB
$100 USD 在7天之内
5.0 (14条评论)
4.2
4.2
用户头像
Hello Sir, I am interested. Please see PM for details. Thanks, Ravi
$80 USD 在4天之内
5.0 (2条评论)
3.3
3.3
用户头像
Hi!..Ready to start. Please check PM for details. Thanks
$60 USD 在3天之内
5.0 (5条评论)
2.8
2.8
用户头像
hello sir i want to work with you for long term kindly check pm
$80 USD 在5天之内
4.5 (10条评论)
2.8
2.8
用户头像
Please see the PMB.
$175 USD 在21天之内
5.0 (2条评论)
2.1
2.1
用户头像
View my message. Good luck
$50 USD 在6天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am an Engineering undergraduate with great computer and English skills. So this is very easy task and you won't regret selecting me. I can do this for you for very low cost. Hope to work with you. Thank you. Please check PMB for more details
$40 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi! Well i am interested in your project...please send me full detail of your project asap..
$75 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
sir, i have 70 wpm typing speed and im good with scripting and data entry. hope the bid is fair. best regards, gihan (DataSoft inc.)
$150 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
sir I am interested in your project. I always have a team of numbers of people, So if you please give us this we will helped. my team is working data entry from many days. Finally I am from bangladesh.
$200 USD 在7天之内
0.0 (1条评论)
0.0
0.0
用户头像
Please see PM for details.
$50 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
I would be happy to be a part of it. Count on me Sir. Thanks and God Bless gongs
$120 USD 在30天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I CAN PROVIDE YOU APPLICATION (IN EXCEL) THAT CAN FETCH ALL THE DATA AND SINCE THAT WOULD BE AN APPLICATION, YOU CAN GET UPDATED AT ANY TIME FROM THE SITE. Thanks and Regards, Sumeet.
$65 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Would not mind doing this on a regular....
$50 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi I am interseted in this project and would be pleased to have long term buisness relationship provided i am given a chance to do so.I have gone through the project details and file you attached along with and think that i can do it efficiently within specified time limit. The time limit mentioned in the bid is the maximum ,future work can be completed in short time as my work hours are flexible . Efficiency and punctuality will remain by top priority. I hope you put your faith in me and award me with this project.
$70 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
Harrow, United Kingdom
5.0
34
付款方式已验证
会员自8月 5, 2007起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。