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

Downloads

  • Excel LADZ - Football Model (US, Japan and Brazil).xlsx
  • Excel LADZ - Legacy Football Model (US, Japan and Brazil).xlsx

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

Content

G'day lads! In this post I've added the MLS (United States), J1 League (Japan) and Série A (Brazil) to the Excel LADZ Poisson Football Model. To add more leagues to this file, follow the steps above in the video!

Attached are the models below. If you do not have access to array formulas in Excel, please download the "Legacy" file. Let me know if you have any questions lads! 🔥

Note: These models currently use data from a single season - the current one. As a result, competitions that have only played a few rounds may be inaccurate due to a lack of data.

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

Hi Lad, it would helpful if you could make a video, showing step-by-step how to add new leagues. The video above misses out several steps to enable me to do this.

Excel LADZ

Hi lads, apologies for the late response. Thanks for reminding me 🔥 I've been working on a YouTube video on Monte Carlo Simulations these last couple days, that will be released within the next 1-2 days 👍 I can do a walkthrough tutorial for the parts explained very quickly or missed in the YouTube video on the topic. All leagues that are on Football Reference are able to be added 😃 Out of interest, what steps are you lads getting confused with?

Iain Moran

Thanks lad, I'd like in particular the steps that start from the Power Query part. But would be delighted to see the full process, step-by-step, if possible.

Matthew Moscatello

I am trying to run some numbers for MLS matches tomorrow. I have downloaded both the football model and the legacy football model and "refreshed all" for the data, and both files are broken and not working.

Excel LADZ

Fixed! Apologies for that. The Football Reference power query slightly changed, so the club names were changed from "Philadelphia" to "Philadelphia Union" for example. Please let me know if you have any more issues mate! Otherwise, please re-download the files from this post 👍

Charles

How do I download the NBA Model