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 ClubELO Model (Patreon)

Published:
2024-07-12 06:47:17
Imported:
2026-06
haven't archived this post yet. have a subscription? use the importer!

Downloads

  • Excel LADZ - 2024 ClubELO Model.xlsx
  • Excel LADZ - 2024 ClubELO Model (Legacy).xlsx

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

Content

G'day lads! Attached is the 2024 update to the ClubELO Model seen in the video above 🔥

Now, the model is connected to the ClubELO Website through a Power Query. By going into the 'Data' tab and selecting the "Refresh All" icon, this connection is refreshed, and live data is brought into the model. This means the inefficient copy/paste method is no longer!

I managed to do this by writing blank power code in the Power Query Editor. This code can get very complicated, and is entirely different to having "Excel skills". Therefore, I use ChatGPT to be able to generate this code! I'm looking forward to diving deeper into this topic in the future 📈

Both a 'Normal' and 'Legacy' model is attached below 💪 The 'Legacy' version is for those without a version of Excel that can handle array functions (i.e. pre - Excel 2019).

Please let me know if you have any questions below!

Files

Previews only

EASIEST Model to PREDICT Football Matches With ELO | Excel Beginner Tutorial

Access the file and become a LAD: https://www.patreon.com/ExcelLADZ SUBSCRIBE to become an official LAD. Link to Football Club ELO Ratings Upcoming Games API: api.clubelo.com/Fixtures Timestamps Intro: 00:00 - 00:12 Import Data: 00:13 - 2:28 Compiling Data: 2:29 - 9:30 Results: 9:31 - 21:36

Comments

Mike Sherratt

its not working dude wont update would i be better copying the data as the data is there but the games page isnt showing neither is the dashboard

Excel LADZ
>>145004417

Hi Mike, welcome 🔥 Apologies for that. If you'd like, you can send me images of your error over Discord so I can have a look at what's causing it. Could I ask what version of Excel you are using? If you haven't already, try using the 'Legacy' version, which is the second file attached to the post. Please let me know if you have any more questions lad 😃

mkendrick999

I was able to get the data to refresh just fine... My only confusion is how to get the actual dashboard to work properly. It is saying that there are no games available?

Excel LADZ
>>146276783

Hi lad, welcome 😃 Firstly, I would suggest downloading the 'Legacy' version of the file. Older versions of Excel (prior to 2019) don't have the ability to recognise array functions like XLOOKUP that are used in the normal model. The 'Legacy' model uses older functions to make the model compatible with nearly every computer. Secondly, make sure you refresh the PivotTable in the "Games" worksheet. This will get the updated data, and sort it into a drop down list for you to select from in cell G9 of the "Dashboard" worksheet. Tomorrow I'm dropping a quick how-to-use tutorial on this model, so please let me know if that helps lad 🙏