Kapalı

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

Beceriler: Visual Basic, Excel, Algoritma, Matematik, Veri Bilimi

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Hull, United Kingdom

Proje NO: #30978462

Bu iş için 7 freelancer ortalamada £18/saat teklif veriyor

suyashdhoot

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 Daha Fazla

£50 GBP / saat tutarından itibaren
(37 Değerlendirme)
6.0
demydkasilov

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 Daha Fazla

£13 GBP / saat tutarından itibaren
(3 Değerlendirme)
3.8
sramireddy065

⭐⭐⭐⭐⭐⭐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 Daha Fazla

£11 GBP / saat tutarından itibaren
(6 Değerlendirme)
2.8
aruls1962

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 Daha Fazla

£13 GBP / saat tutarından itibaren
(3 Değerlendirme)
2.7
varimaxanalytic

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 Daha Fazla

£14 GBP / saat tutarından itibaren
(1 Yorum)
1.1
ankite

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 Daha Fazla

£13 GBP / saat tutarından itibaren
(0 Değerlendirme)
0.0
atulcpaul

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 Daha Fazla

£10 GBP / saat tutarından itibaren
(0 Değerlendirme)
0.0