Excel LADZ
Excel LADZ
  • 36
  • 368 359
Build an NBA Player Prop Model in Excel: Predict Points, Rebounds, & Assists!
Download here: www.patreon.com/posts/excel-ladz-nba-119341792
Need a spreadsheet built? Visit: www.excelladz.com
Building the Model (Part 1): www.patreon.com/posts/how-i-built-nba-119750634
Building the Model (Part 2): www.patreon.com/posts/how-i-built-nba-119825661
Building the Model (Part 3): www.patreon.com/posts/how-i-built-nba-120023499
The following links are to the datasets I used in the model. Shoutout to Basketball Reference and TeamRankings!
2024-25 NBA Player Stats: www.basketball-reference.com/leagues/NBA_2025_per_game.html
2024-25 NBA Assists Stats: www.teamrankings.com/nba/stat/opponent-assists-per-game
2024-25 NBA Team Stats: www.teamrankings.com/nba/stat/opponent-points-per-game
2024-25 PACE: www.teamrankings.com/nba/stat/possessions-per-game
2024-25 Offensive Reb %: www.teamrankings.com/nba/stat/offensive-rebounding-pct
2024-25 Defensive Reb %: www.teamrankings.com/nba/stat/defensive-rebounding-pct
Переглядів: 1 362

Відео

How These 5 Excel Skills Helped Me Ace University Assignments
Переглядів 697Місяць тому
Download the file here: www.patreon.com/posts/5-essential-117384378 Need a spreadsheet built? Visit: www.excelladz.com Introduction: 0:00 - 0:39 #1 - Lookup Functions: 0:40 - 3:22 #2 - Data Cleaning & Analysis: 3:23 - 7:02 #3 - Tables & Pivot Tables: 7:03 - 9:31 #4 - Charts & Visualisation: 9:32 - 10:22 #5 - Dynamic Arrays: 10:23 - 13:34
ANALYSE Basketball Games for Win %, Over/Under and Spread Betting using EXCEL! | Team-Based Tutorial
Переглядів 3 тис.2 місяці тому
Download: www.patreon.com/posts/excel-ladz-2024-116432682 Need a spreadsheet built? Visit: www.excelladz.com Basketball Reference: www.basketball-reference.com/leagues/NBA_2025.html
NFL Betting Model in Excel: Predict Spread, Moneyline & Totals!
Переглядів 6 тис.4 місяці тому
Download: www.patreon.com/posts/excel-ladz-2024-111333965 Need a spreadsheet built? Visit: www.excelladz.com NFL Scoring Stats: www.nfl.com/stats/team-stats/offense/scoring/2024/reg/all NFL Receiving Defense: www.nfl.com/stats/team-stats/defense/receiving/2024/reg/all NFL Rushing Defense: www.nfl.com/stats/team-stats/defense/rushing/2024/reg/all NFL Standings: www.nfl.com/standings/ NFL Fixture...
Master Sports Betting with Monte Carlo Simulations!
Переглядів 5 тис.7 місяців тому
Learn Sports Modelling: www.patreon.com/ExcelLADZ Download MLS File: www.patreon.com/posts/master-sports-107168517 Need a spreadsheet built? Visit: www.excelladz.com Football Reference: fbref.com/en/
ANALYSE Football Matches for Win %, Over/Under and Correct Score using EXCEL! | Tutorial
Переглядів 13 тис.8 місяців тому
Download: www.patreon.com/posts/analyse-football-103833026 Need a spreadsheet built? Visit: www.excelladz.com EPL Football Reference Stats: fbref.com/en/comps/9/Premier-League-Stats LaLiga Football Reference Stats: fbref.com/en/comps/12/La-Liga-Stats Ligue 1 Football Reference Stats: fbref.com/en/comps/13/Ligue-1-Stats Bundesliga Football Reference Stats: fbref.com/en/comps/20/Bundesliga-Stats ...
PREDICT NHL Matches With Excel | Tutorial
Переглядів 3,7 тис.10 місяців тому
Download: www.patreon.com/posts/99755288 Need a spreadsheet built? Visit: www.excelladz.com Hockey Reference: www.hockey-reference.com/leagues/NHL_2024_standings.html
Project NBA Player Rebounds With Excel | Tutorial
Переглядів 4,7 тис.11 місяців тому
Download: www.patreon.com/posts/excel-ladz-nba-98513859 Need a spreadsheet built? Visit: www.excelladz.com Basketball Reference NBA Player Per Game Stats: www.basketball-reference.com/leagues/NBA_2024_per_game.html TeamRankings Team PACE: www.teamrankings.com/nba/stat/possessions-per-game TeamRankings Team Offensive Rebound %: www.teamrankings.com/nba/stat/offensive-rebounding-pct TeamRankings ...
I Used Excel to PREDICT UFC Fights | 72% Accuracy!
Переглядів 3,9 тис.Рік тому
Download: www.patreon.com/posts/95847094?pr=true Need a spreadsheet built? Visit: www.excelladz.com UFC Dataset: www.kaggle.com/code/nisdotexe/ufc-fighter-data-data-wrangling-final-project/input?select=raw_fighter_details.csv UFC Stats: ufcstats.com/statistics/events/completed Logistic Regression Tutorial: ua-cam.com/video/xKA-fOCENaY/v-deo.html
PREDICT NBA Games on Excel | Live Win Probability + Overtime
Переглядів 3,5 тис.Рік тому
Download: www.patreon.com/posts/95560092?pr=true Need a spreadsheet built? Visit: www.excelladz.com Time Stamps 0:20 - 1:56: BINOM.INV Change 1:57 - 7:30: Overtime Adjustment 7:31 - 23:25: Live Win Probability
PREDICT Corners Using Shots & Possession | Linear Regression on Excel
Переглядів 3,7 тис.Рік тому
Download: www.patreon.com/posts/94652720?pr=true Need a spreadsheet built? Visit: www.excelladz.com FBref (EPL Live Stats): fbref.com/en/comps/9/Premier-League-Stats Kaggle 2022-23 EPL Dataset: www.kaggle.com/datasets/afnanurrahim/premier-league-2022-23
PREDICT NFL Games | FiveThirtyEight ELO Model
Переглядів 5 тис.Рік тому
Download Free: www.patreon.com/posts/nfl-538-elo-90455360 Need a spreadsheet built? Visit: www.excelladz.com FiveThirtyEight NFL Model: fivethirtyeight.com/methodology/how-our-nfl-predictions-work/ ELO Site: www.aussportstipping.com/sports/nfl/elo_ratings/ Home Advantage Formula: ua-cam.com/video/o1tGI8G1vH4/v-deo.html
Create Fixture List & League Table in Excel | Tutorial
Переглядів 30 тис.Рік тому
Download here: www.patreon.com/posts/excel-ladz-table-89532234 Need a spreadsheet built? Visit: www.excelladz.com
Predict the NBA In-Season Tournament... With Excel! | Part 2
Переглядів 1,2 тис.Рік тому
Download: www.patreon.com/c/ExcelLADZ Need a spreadsheet built? Visit: www.excelladz.com NBA Stats: www.basketball-reference.com
I Simulated the EPL Season 1,000 Times... Using Excel!
Переглядів 10 тис.Рік тому
Download here: www.patreon.com/posts/87375673 Need a spreadsheet built? Visit: www.excelladz.com Website I got the fixtures from: fixturedownload.com
I Predicted the Women's World Cup... Using Excel?
Переглядів 1,4 тис.Рік тому
I Predicted the Women's World Cup... Using Excel?
Predict the NBA In-Season Tournament... With Excel! | Part 1
Переглядів 1,9 тис.Рік тому
Predict the NBA In-Season Tournament... With Excel! | Part 1
PREDICT 2025 MLB Matches With Excel | Tutorial
Переглядів 12 тис.Рік тому
PREDICT 2025 MLB Matches With Excel | Tutorial
PREDICT Football Matches with the POISSON Distribution | Excel Beginner Tutorial
Переглядів 28 тис.Рік тому
PREDICT Football Matches with the POISSON Distribution | Excel Beginner Tutorial
PREDICT NBA Games on Excel | Adjusting Player Minutes
Переглядів 4 тис.Рік тому
PREDICT NBA Games on Excel | Adjusting Player Minutes
PREDICT NBA Games on Excel | Account for Player Trades
Переглядів 3,2 тис.Рік тому
PREDICT NBA Games on Excel | Account for Player Trades
PREDICT Super Bowl Passing Touchdowns | Excel
Переглядів 1,5 тис.Рік тому
PREDICT Super Bowl Passing Touchdowns | Excel
EASIEST Model to PREDICT Football Matches With ELO | Excel Beginner Tutorial
Переглядів 34 тис.2 роки тому
EASIEST Model to PREDICT Football Matches With ELO | Excel Beginner Tutorial
PREDICT Australian Open with Mathematics | Excel Tutorial
Переглядів 2,3 тис.2 роки тому
PREDICT Australian Open with Mathematics | Excel Tutorial
PREDICT NBA Games With Probability | Excel Tutorial
Переглядів 47 тис.2 роки тому
PREDICT NBA Games With Probability | Excel Tutorial
PREDICT Football Matches With POSSESSION | Excel Tutorial
Переглядів 33 тис.2 роки тому
PREDICT Football Matches With POSSESSION | Excel Tutorial
Predict the FIFA World Cup 2022 With Probability | Excel Tutorial
Переглядів 7 тис.2 роки тому
Predict the FIFA World Cup 2022 With Probability | Excel Tutorial
Excel Power Query for Mac Tutorial | Currency Converter Example
Переглядів 3,1 тис.2 роки тому
Excel Power Query for Mac Tutorial | Currency Converter Example
How to Create a Sports League Table | Beginner Excel Tutorial
Переглядів 62 тис.2 роки тому
How to Create a Sports League Table | Beginner Excel Tutorial
Beginner PivotTable Tutorial | Analysing Rugby Statistics
Переглядів 2,8 тис.2 роки тому
Beginner PivotTable Tutorial | Analysing Rugby Statistics

КОМЕНТАРІ

  • @fplbenchwarmers6144
    @fplbenchwarmers6144 3 дні тому

    This video is superb! Your brain works fast and clear. Thank you

  • @excel_ladz
    @excel_ladz 3 дні тому

    Need a spreadsheet built? Visit: www.excelladz.com

  • @excel_ladz
    @excel_ladz 3 дні тому

    Need a spreadsheet built? Visit: www.excelladz.com

  • @excel_ladz
    @excel_ladz 3 дні тому

    Need a spreadsheet built? Visit: www.excelladz.com

  • @excel_ladz
    @excel_ladz 3 дні тому

    Need a spreadsheet built? Visit: www.excelladz.com

  • @noah-cr9nq
    @noah-cr9nq 3 дні тому

    How you would insert data to also include positions like Utah is 25th in the league against SGs

  • @muratergin7851
    @muratergin7851 3 дні тому

    Brother, I'm having trouble with the upper and lower parts. Always gives 100%. What do you think could be wrong? Because as the number of matches played increases, the Away x_points: values ​​in the simulation tab increase and become too many. upside down never changes.

  • @TRACK8REMIX
    @TRACK8REMIX 4 дні тому

    Sorry to many errors come back when trying this

  • @rox_solo
    @rox_solo 5 днів тому

    This video is great! I am currently recreating in google sheets but having issues with formula for pace adj. Mine is returning a value of about 10 which has to be high for an adj. Not sure what I did for that to be calculated.

  • @SliderX08
    @SliderX08 6 днів тому

    Hey Mate, question for you, Why am I getting scores of 200 plus when the simulations are run ?

    • @excel_ladz
      @excel_ladz 6 днів тому

      G’day mate, I would check that the sum of xMP for each team is exactly equal to 240 👍

    • @SliderX08
      @SliderX08 6 днів тому

      Will do thanks. I may be back

  • @Matt-qf4wr
    @Matt-qf4wr 6 днів тому

    I’m using this as a template for an online darts league. I’ve tried adding to the spreadsheet a 3dart avg, 9dart average, 60,80,100,120,140,180s best check out and best leg. But constantly come across issues when ranking them by points as the sort by option isn’t working. But this is an amazing template works great just trying to put in a bit extra. How can I do this

  • @sjouanny
    @sjouanny 8 днів тому

    Thanks mate for this. But please learn how to pronounce 'Poisson' - it is like 'pwa-sonn', not 'poy-sahn' as you say it.

  • @jairo1197
    @jairo1197 10 днів тому

    Nice work! Would really like to know how accurate is it…

  • @KenFletcherAU
    @KenFletcherAU 11 днів тому

    Is there a possibility to get the actual player stats from said game imported live, rather than simulating that in the live window probability tab? May be a bit difficult finding said particular game and scrapping that data, but could be universal somewhere or another.

    • @excel_ladz
      @excel_ladz 11 днів тому

      Hey mate, the simulations are required for the portion of the game left unplayed. You could import the player stats through an API or web scraping. Then if a game is mid-way, combine a player's stats so far with the simulations for the rest of the game to get a simulated outcome.

  • @becca1927
    @becca1927 11 днів тому

    Works really well up the sort part, for some reason i cant sort via Pts, GD & GF it will only work if i sort by 1 of them

  • @ReidellInvestments
    @ReidellInvestments 12 днів тому

    Hey man excellent video. What do you do about rank if 2 players have the same exact minutes played.

    • @ReidellInvestments
      @ReidellInvestments 12 днів тому

      i have two starts with the same MP. Both rank 2. So one of them is coming back as #1 bench. even though he is a starter

    • @excel_ladz
      @excel_ladz 12 днів тому

      Thanks mate. Try giving a player an insignificant increase to their xMP. For example, 32.00001 minutes and 32 minutes. This separates the ranks, but doesn’t have any material impact on the model 👍

  • @KenFletcherAU
    @KenFletcherAU 12 днів тому

    Hey brother are you on discord? I’d love to reach out and touch base with you in regards to a current project I’m working on for the nrl??

    • @excel_ladz
      @excel_ladz 12 днів тому

      Hey mate, my name is excel_ladz on Discord. Go the Eels 💙 💛 😂

    • @KenFletcherAU
      @KenFletcherAU 11 днів тому

      @ added mate cheers 🍻

  • @li-ch8hv
    @li-ch8hv 14 днів тому

    Hey brother, I am still your Chinese fan, I have a suggestion: Can you please add the selection of Asian tennis disc to the Excel sheet of this video? (e.g. : the home team conceded 0.75 goals 1 goals 2 goals and the visiting team conceded 0.75 goals 1 goals 2 goals) or the exact number of goals! (I know you work hard) is a little advice, see if you have similar ideas, you are really great!❤

  • @younggarrett93
    @younggarrett93 17 днів тому

    Hey brother this looks really great. I'm considering giving it a try and recommending it to some of my friends if it has some success. But just one question/suggestion...If it's not too much trouble would it be possible highlight or in someway distinguish the cells that we're supposed to manually enter data into, as opposed to the cells that should fill automatically? From what I can tell the data we'd manually input would be: the players name, the opposition, the expected minutes, home/away (yes/no), and then just the Line. If that's correct then no worries I can highlight them myself once I download. If I'm wrong or missing something then I do think it could be very helpful to some of us excel and calculation novices lol. Anyways thanks for the hard work. I've been looking for some betting software that might give me an extra edge, and I think this might work.

    • @excel_ladz
      @excel_ladz 17 днів тому

      Hey mate, thanks for watching! Yes, you're right. Pretty much everything without a formula already in it 👍 I recommend joining, you might get some new ideas in the Discord we have too!

  • @excel_ladz
    @excel_ladz 18 днів тому

    Need a spreadsheet built? Visit: www.excelladz.com Building the Model (Part 1): www.patreon.com/posts/how-i-built-nba-119750634 Building the Model (Part 2): www.patreon.com/posts/how-i-built-nba-119825661 Building the Model (Part 3): www.patreon.com/posts/how-i-built-nba-120023499

  • @TRACK8REMIX
    @TRACK8REMIX 20 днів тому

    great video how do you get your raw data in like it is

    • @excel_ladz
      @excel_ladz 19 днів тому

      Power Query from the website ‘Football Reference’. Link should be in the description 👍

  • @JustAStockYote
    @JustAStockYote 20 днів тому

    Downloading the model do you have like instructions how to work everything? Or what’s all it come with

    • @excel_ladz
      @excel_ladz 19 днів тому

      G’day, lad! Yes, the model comes with instructions on how to use. All you need to do is select the “Refresh All” icon to update the data then you’re set! 🔥

  • @Idkfa17
    @Idkfa17 21 день тому

    is it actually profitable? which should be the only question for a model?

  • @franknarua8877
    @franknarua8877 25 днів тому

    can you please send me a format for rugby sevens tournament with 50 teams to participate in pools of 4 or 5 in a pool. id be very glad. ive got your "Create Fixtures List & League Table In Excel | Tutorial. Thank you.....

  • @dramuhfn
    @dramuhfn 26 днів тому

    can you make a video on how to account for injured players. or even account for teams that are playing back to back, 2 days rest, ect.

    • @excel_ladz
      @excel_ladz 26 днів тому

      Hi mate, there’s a video on how to adjust for injuries on the channel 👍 Check it out 🔥

  • @GilbertBita
    @GilbertBita 26 днів тому

    Is it me or my excel doesn’t allow me to fill the formulae down the cells. I have repeat the process for each formula down each cell. Any one got any ideas? Cheers

  • @paulkerrison3342
    @paulkerrison3342 27 днів тому

    Excellent tutorial, thank you. You got a new sub and I look forward to going through your other videos.

  • @bartproffitt5240
    @bartproffitt5240 Місяць тому

    Ran into a problem where MEM doesn't have a SF on their team.... Is there a work around?

  • @MyOpion
    @MyOpion Місяць тому

    in the spread threshold cell do you always use the home team points spread or the away team points spread

  • @thebeautifulgame7510
    @thebeautifulgame7510 Місяць тому

    worked for me. thank you!

  • @gk-vigilant9113
    @gk-vigilant9113 Місяць тому

    YOU DEMOSTRATE A WAY OF ANALYTICS WE SEE IN BETTING COMPANIES AND CONGRATS BUT NOT GIVE US A WAY TO BET A PURE MIND BETTING, I WILL GIVE AN EXAMPLE TELL US WHAT TO PLAY WITH LINEAR REGRESSION NOT TO GIVE US PERCENTAGES COMPANIES DO THIS ,YOU SAY TO US THE MECHANISM NOT THE PREDICTION OF YOUR VIEW LIKE SD

  • @keithbribac
    @keithbribac Місяць тому

    around the 22 minute mark, how is it done on google sheets?

  • @championmenace
    @championmenace Місяць тому

    Who came up with this and can I marry them (JOKING... UNLESS 👀)

    • @excel_ladz
      @excel_ladz Місяць тому

      Best comment I’ve seen in a while 😂 Glad I could help lad

  • @danielquirk-b2e
    @danielquirk-b2e Місяць тому

    @excel_lads would it be possible for you to create a significant strikes, total strikes and total takedowns model for UFC?

  • @josephdiaz1956
    @josephdiaz1956 Місяць тому

    is the raw data always updated ?

    • @josephdiaz1956
      @josephdiaz1956 Місяць тому

      i mean your excel file thats going to be downloaded is that will automatically updated the raw data?

    • @excel_ladz
      @excel_ladz Місяць тому

      @@josephdiaz1956 Yes 👍 The spreadsheet is connected to the internet, so when you select "Refresh All" in the 'Data' tab, the Raw Data updates automatically 🔥

  • @TheSupajee
    @TheSupajee Місяць тому

    Extremely useful guide! Do you know how to add a Head-To-Head Tie Breaker to this table? My league uses Points->Head-To-Head->Goal Differential->Goals Scored.

  • @Lowereastcred
    @Lowereastcred Місяць тому

    Is this actually profitable?

  • @cooperiswatching4294
    @cooperiswatching4294 Місяць тому

    For some reason the pts. simulated column has multiple #spill! errors. Any help or suggestions? Thanks in advance

  • @Guma93
    @Guma93 Місяць тому

    Hi! This looks really good! Watched many of your tutorials and they are all amazing! I’m just wondering, do you not factor in goalie save %? Or is it already calculated in the “Def Rating”, if you understand my question..

    • @excel_ladz
      @excel_ladz Місяць тому

      Thanks for watching, lad 🔥 The average goalie save % is factored in as an average. If a team’s goalie has a higher save %, then the team’s DEF Rating will inevitably be lower (a good thing) as the team concedes relatively fewer goals. It’s not directly factored in, but the DEF Rating is a result of a team’s average save % among other factors 👍

  • @richielavey1565
    @richielavey1565 Місяць тому

    72% seems very impressive, but I’m a little confused where you got the data from. You said it was from the ufc stats website, which is what I’m using for my model as well, however you don’t say where exactly. If you’re using data from the ufc fighter’s page, this is updated after every fight so if the fight already happened you are using data from the future relative to the fight you’re trying to predict. While 72% is pretty good, I’d argue we can do a bit better if we allow ourselves to use data from the future.

  • @shartmartin3066
    @shartmartin3066 Місяць тому

    thank you for doing a very basic tutorial. this is what most people need

  • @showbiz83
    @showbiz83 Місяць тому

    How do you become a member

    • @excel_ladz
      @excel_ladz Місяць тому

      G’day, mate! Check out the first link in the description of the video 🔥 By becoming a member, you can download any model you like and ask me any questions about Excel and sports modelling 😃

  • @showbiz83
    @showbiz83 Місяць тому

    How can i reach you

  • @jcwillette
    @jcwillette Місяць тому

    Is there a simple way we can set up a button to download the 538 data each week? It would be a great addition to the already excellent spreadsheet.

    • @excel_ladz
      @excel_ladz 3 дні тому

      Thanks for watching mate! I tried, but on my Mac I couldn't establish the Power Query 😢

  • @een4een
    @een4een Місяць тому

    Well done! Thank you!

  • @DomenicoSorbello
    @DomenicoSorbello Місяць тому

    Thanks chief lad, I just aced my university exam using this video.

  • @jaydenkouchoo2938
    @jaydenkouchoo2938 Місяць тому

    Thankyou for this content lad!

    • @excel_ladz
      @excel_ladz Місяць тому

      @@jaydenkouchoo2938 Thanks for watching, lad! 🔥

  • @cerealbawxtv
    @cerealbawxtv Місяць тому

    Is this model available for download? 👀

    • @excel_ladz
      @excel_ladz Місяць тому

      Yep! See the first link in the description 🔥

  • @carshowclassics7257
    @carshowclassics7257 Місяць тому

    will this work as well in Apple Numbers?

  • @peterappelgren
    @peterappelgren Місяць тому

    Waited for this 15 years, SUPER!!