I have collected some tennis points data for 2020 and wanted to anlyse this data looking at certain scores but havent for the life of me any idea on how to do this and hoping someone here would know an excel formula. Im sure its probably quite easy but after days and days asking google i havent been able to find what im looking for.
For example lets look at the age old strategy of 15-40. If I have all the scoring seqeunces of a match how can i find out using excel [or any other application] how many times the score was 15-40 that went to 40-40?
I did this using conditional formating were each score in my query would be highlighted a colour and works fine but when you look at a years data i am just overwhelmed because id have to count the instances manually
Here is an example of the data if i was looking at 15-40 and the score goes to deuce.
[0-0*] [15-0*] [30-0*] [30-15*] [40-15*] [40-30*] [40-40*]
Any help on this would be great as I'm running out of words to type into google
How To Analyse Tennis Points Data
-
- Posts: 82
- Joined: Tue May 01, 2018 1:33 pm
Thanks Atho, I'll give this a try.
Maybe I should have included the data in my first post. I have attached a sample 100 rows of data
You do not have the required permissions to view the files attached to this post.
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Why not simply count the number of times the sequence 15-40 ? ? 40-40 occurs, should be able to do it with a bit of regex /15-40.*?40-40/
-
- Posts: 3
- Joined: Thu Jul 30, 2020 10:03 pm
Here you go. I made an excel with the formulas you need!
I am very new to betfair and am also looking at tennis.
I have no clue how to go about collecting data like you have. Can you give me some pointers on how to go about collecting data like this?
Thanks!
I am very new to betfair and am also looking at tennis.
I have no clue how to go about collecting data like you have. Can you give me some pointers on how to go about collecting data like this?
Thanks!
You do not have the required permissions to view the files attached to this post.