bha ratings

Each week the BHA (British Horse-racing Authority) updates the last 6 performance ratings of 13,500 horses into a csv file/ google sheets (with each horse identified in columns for name etc plus columns for each of the last 6 performances).The data I wish to manipulate is within the 13,500 rows by 6 columns of ratings. A complicating factor is that the 6 data columns mix text (a letter of little interest) and a number (the key data) for each performance (e.g. T:88). I am able (laboriously) to split the text out into columns which I delete and to add a column to identify the best numerical performance (highest performance rating) for each horse. I am then able to add further columns to incorporate a calculation based on the relationship between the individual performances of certain of the horses. SO FAR SO GOOD I HAVE THE SPREADSHEET I WANT. Unfortunately a week later the BHA's new spreadsheet for the past week's 2000+ performance ratings will, inter alia, change all the existing reference points for 13,500 horses into different cells as well as adding new/ deleting old performance data (to give the latest 6 performances only). How, can I create a spreadsheet that manipulates the data as I want but can be updated weekly in line with the next BHA spreadsheet.

Let me know if you have any questions

Skills: Visual Basic, Excel, Algorithm, Mathematics, Data Science

See more: horse racing system freelancer, keywords seo horse racing, great brittan horse racing database, animation horse racing, horse racing database import ratings, british horse racing, free horse racing ratings, todays horse racing ratings, horse racing ratings system, free horse racing speed ratings, horse racing ratings explained, free horse racing ratings software, horse racing ratings free, uk horse racing ratings, horse racing ratings, horse racing ratings uk, best horse racing ratings, horse racing ratings software, horse racing ratings spreadsheet

About the Employer:
( 0 reviews ) Hull, United Kingdom

Project ID: #30978462

7 freelancers are bidding on average £18/hour for this job


Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

£50 GBP / hour
(37 Reviews)

Hello,how are you? I read your job description in detail and feel I can help your project. Because I have much experience for 7+ years in Data Anayze Field. I am very familiar with Python. I think this project is for m More

£13 GBP / hour
(3 Reviews)

⭐⭐⭐⭐⭐⭐Available to start work immediately⭐⭐⭐⭐⭐⭐ Hello Thank you for viewing my proposal I went through your project requirements. I am sure I can help you with this project If you share precise information about thi More

£11 GBP / hour
(6 Reviews)

What you need can be easily done. You need a horse master (each horse in a row). No duplicates. It will keep on growing with each week (adding new horses) automatically. One column will identify "last active date". You More

£13 GBP / hour
(3 Reviews)

Hi! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complete More

£14 GBP / hour
(1 Review)

I am a Professional with 5 years of experience dealing day in and day out with advance macros. I am new to the platform, which is why I don't have many reviews but rest assured I will provide you with a quality product More

£13 GBP / hour
(0 Reviews)

As a Banking professional with over 30 years experience, and a software expert proficient in Java / VBA / Excel / Google Sheets, this is an area of expertise for me. Having done similar projects several times in the pa More

£10 GBP / hour
(0 Reviews)