- 36
- 368 359
Excel LADZ
Australia
Приєднався 21 тра 2020
This channel will provide tutorials on sports related topics on using Microsoft Excel. From analysing data to simulating entire sporting seasons, Excel LADZ provides punters with easy-to-learn Microsoft Excel models so as to gain an upper hand on the bookies. Comment on any video with suggestions or ideas, and we will get back to you as soon as possible.
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
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
This video is superb! Your brain works fast and clear. Thank you
Need a spreadsheet built? Visit: www.excelladz.com
Need a spreadsheet built? Visit: www.excelladz.com
Need a spreadsheet built? Visit: www.excelladz.com
Need a spreadsheet built? Visit: www.excelladz.com
How you would insert data to also include positions like Utah is 25th in the league against SGs
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.
Sorry to many errors come back when trying this
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.
Hey Mate, question for you, Why am I getting scores of 200 plus when the simulations are run ?
G’day mate, I would check that the sum of xMP for each team is exactly equal to 240 👍
Will do thanks. I may be back
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
Thanks mate for this. But please learn how to pronounce 'Poisson' - it is like 'pwa-sonn', not 'poy-sahn' as you say it.
Nice work! Would really like to know how accurate is it…
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.
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.
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
Hey man excellent video. What do you do about rank if 2 players have the same exact minutes played.
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
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 👍
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??
Hey mate, my name is excel_ladz on Discord. Go the Eels 💙 💛 😂
@ added mate cheers 🍻
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!❤
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.
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!
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
great video how do you get your raw data in like it is
Power Query from the website ‘Football Reference’. Link should be in the description 👍
Downloading the model do you have like instructions how to work everything? Or what’s all it come with
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! 🔥
is it actually profitable? which should be the only question for a model?
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.....
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.
Hi mate, there’s a video on how to adjust for injuries on the channel 👍 Check it out 🔥
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
Excellent tutorial, thank you. You got a new sub and I look forward to going through your other videos.
Ran into a problem where MEM doesn't have a SF on their team.... Is there a work around?
in the spread threshold cell do you always use the home team points spread or the away team points spread
worked for me. thank you!
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
around the 22 minute mark, how is it done on google sheets?
Who came up with this and can I marry them (JOKING... UNLESS 👀)
Best comment I’ve seen in a while 😂 Glad I could help lad
@excel_lads would it be possible for you to create a significant strikes, total strikes and total takedowns model for UFC?
is the raw data always updated ?
i mean your excel file thats going to be downloaded is that will automatically updated the raw data?
@@josephdiaz1956 Yes 👍 The spreadsheet is connected to the internet, so when you select "Refresh All" in the 'Data' tab, the Raw Data updates automatically 🔥
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.
Is this actually profitable?
For some reason the pts. simulated column has multiple #spill! errors. Any help or suggestions? Thanks in advance
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..
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 👍
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.
thank you for doing a very basic tutorial. this is what most people need
Thanks for watching!
How do you become a member
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 😃
How can i reach you
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.
Thanks for watching mate! I tried, but on my Mac I couldn't establish the Power Query 😢
Well done! Thank you!
Thanks chief lad, I just aced my university exam using this video.
Bang 💥
Thankyou for this content lad!
@@jaydenkouchoo2938 Thanks for watching, lad! 🔥
Is this model available for download? 👀
Yep! See the first link in the description 🔥
will this work as well in Apple Numbers?
Waited for this 15 years, SUPER!!