Home
Creators
Search Recent Missing Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Excel LADZ - 2024-25 European Football Model! (Patreon)

Published:
2024-08-18 11:49:25
Imported:
2026-06
haven't archived this post yet. have a subscription? use the importer!

Downloads

  • Excel Ladz - European Football Poisson Model 2024-25.xlsx
  • Excel Ladz - European Football Poisson Model 2024-25 (Legacy).xlsx

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

Content

G'day lads! Attached to this post is the 'Excel LADZ - 2024-25 European Football Model'. This model covers the EPL, LaLiga, Serie A, Ligue 1 and the Bundesliga! The model calculates an xG figure for a potential matchup, and then uses the Poisson Probability Distribution to find probabilities for the:

  • Moneyline

  • Over/Under Goals

  • Exact Goals

  • Double Chance

  • Win/Draw/Win

How-to-Use

As soon as you open the file lads, go to the 'Data' tab and select the "Refresh All" icon. This will update the spreadsheet's connection with Football Reference and bring in the newest stats 🔥

To select a matchup, first select the league from the dropdown list in the cell A3 of the "Dashboard" worksheet. Then, select your two teams in cells G1 & G3 👍

Please let me know if you have anymore questions lads! I'll drop an article detailing the slight changes I've made to this model to make it better in the next week or so 😀

Files

Previews only

ANALYSE Football Matches for Win %, Over/Under and Correct Score using EXCEL! | Tutorial

Download: https://www.patreon.com/posts/analyse-football-103833026 EPL Football Reference Stats: https://fbref.com/en/comps/9/Premier-League-Stats LaLiga Football Reference Stats: https://fbref.com/en/comps/12/La-Liga-Stats Ligue 1 Football Reference Stats: https://fbref.com/en/comps/13/Ligue-1-Stats Bundesliga Football Reference Stats: https://fbref.com/en/comps/20/Bundesliga-Stats Serie A Football Reference Stats: https://fbref.com/en/comps/11/Serie-A-Stats

Comments

Iain Moran

This is great, Lad, thank you. Though I hope you'll be showing us how we can add our own leagues to this too. I have been asking for this for quite some time....

Excel LADZ
>>146886401

Hi lad, I'm glad you like it 🔥 Yes, apologies for that. Perhaps in the next week I can do an "uncut" video of me adding a league like the Championship to this file. Although my explanations might not be as polished as in a YouTube video, it may provide a better insight into the 'workings' of the model and my thoughts behind it. Would you prefer that, or a rigorous written explanation instead lad? Let me know what you think 👍

Iain Moran
>>146886401

Thanks Lad, yes, an uncut video showing you adding a league. No need for it to be polished. I think that would be clearer than a written explanation.

Excel LADZ
>>147361579

Hi mate, thanks for the comment! I'll look into that problem, and fix it tomorrow if I can find anything wrong 👍

Excel LADZ
>>147361579

Hi mate, Borussia Mönchengladbach are known as 'Gladbach' by the model. As all the data comes from the website Football Reference, whatever they label the teams is what they appear as in the model 👍 I've just fixed a tiny formula error relating to something else in the model, so I suggest re-downloading the model lad 😃

Matthew Moscatello

Do you have any videos how we can create this type of model from scratch?

Will

I get a message saying unable to open stats website and cannot download the information you requested.

Excel LADZ
>>148268225

Hi Will, welcome 🔥 That's most unusual, however there are some steps to try to get to the bottom of the problem. Firstly, you may see there are two files attached to the post. I recommend trying to Download the 'Legacy' version and refreshing that data. There also may be a horizontal, yellow bar across the top of the spreadsheet when you first open the model warning that 'External Data Connections have been disabled'. If that occurs, you must select the "Enable All" beside it. This will allow Excel to grab data from the website Football Reference - where this model pulls its data from. If those two things don't work, please send me a screenshot of your problem 👍 You can message me via the discord group or email at: ladz.excel@gmail.com. Of course, if we still can't get to the bottom of your problem, I can offer you a full refund 😃 Please let me know if any of this helped lad!

Julio R.L

Hello boy, a question why you use the value of 10% for the house