Power Query - Tennis Serve Stats

Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Power Query - Tennis Serve Stats

* Serve Leaders
* Return Leaders
* Under Pressure Leaders

Tennis Serve Stats.xlsx

Screenshot 2021-01-30 092550.png

To update, simply select your table and go to Data Tab > Refresh

Design the tables however you wish :)
You do not have the required permissions to view the files attached to this post.
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

Nice piece of work :)
Do like power query, means I have to code that little bit less :lol:
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Revised copy with H2H and Service Games stats

Tennis Serve Stats with H2H.xlsx

Select each player from the drop-down lists.

Screenshot 2021-02-09 193741.png

Select a cell in the Table below the player name and select Refresh from the Data Tab

Note: the H2H may fail on some cells as the Player probably doesn't exist on one of the other tables in the other worksheets. I can only use what is available on the website. I'll try and resolve.
You do not have the required permissions to view the files attached to this post.
jemplex
Posts: 1
Joined: Mon Jul 07, 2014 8:53 am

Awesome work.
I have a question which might be silly apologies in advance.
how do I chance this to look at WTA not ATP. WTA website is structured differently.

Cheers
Post Reply

Return to “Excel Power Query”