Home Creators Posts Import Register Favorites Logout
haven't archived this post yet. have a subscription? use the importer!

Downloads

  • Excel LADZ - Aus Open Model.xlsx

Missing 1 full-res photo, 1 file, as this post has not yet been imported.

Content

G'day LADZ, learn how to predict The Australian Open using Excel! Excel file attached!

Files

Previews only

PREDICT Australian Open with Mathematics | Excel Tutorial

Access the file and become a LAD: https://www.patreon.com/ExcelLADZ SUBSCRIBE to become an official lad. Here's the website where you can import the tennis player ELO Ratings: https://tennisabstract.com/reports/atp_elo_ratings.html Timestamps Intro: 00:00 - 00:12 Raw Data: 00:13 - 2:06 Creating Bracket: 2:07 - 10:22 Simulations: 10:23 - 16:17

Comments

J T

Hi! I am really enjoying all of this information/content so far. Thanks!! Is there any way this can be adopted to WTA on a match by match basis? Basically I'm looking for the probability of each player winning h2h and in a perfect world the expected number of sets the match will go. Thanks for all of this!

Excel LADZ

Hi lad, I'm glad you're enjoying the membership 🔥 With the AO going on right now, I thought about coming up with a formula to extract the Set Win % from the final Match Win %. I'll see if I can come up with a formula for this, and let everybody on Patreon/Discord know if I do 👍 If you use the ELO formula you should be able to come up with H2H probabilities.