How To Analyse Tennis Points Data

Post Reply
captainbang
Posts: 82
Joined: Tue May 01, 2018 1:33 pm

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 :lol:
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Try this =IF(AND(x="15-40",y="30-40",z="40-40"),1,0)

This will return a 1 if those 3 conditions are met with x,y,z being your cell references.

Otherwise pop a block of the data on here so we can have a look
captainbang
Posts: 82
Joined: Tue May 01, 2018 1:33 pm

Atho55 wrote:
Wed Mar 11, 2020 12:36 pm
Try this =IF(AND(x="15-40",y="30-40",z="40-40"),1,0)

This will return a 1 if those 3 conditions are met with x,y,z being your cell references.

Otherwise pop a block of the data on here so we can have a look
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.
spreadbetting
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/
Trading96
Posts: 470
Joined: Thu Mar 16, 2017 4:47 pm

I would suggest finding a better way to display the data, maybe for this purpose putting all the points for each game in it's own cell would be best.

Then do a countif formula.
vinny2cool
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!
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Betfair Data”