Excel LADZ patreon

Excel LADZ - AFL Model 2024

🕑 Added 2024-03-07 09:54:15 +0000 UTC

Comments

Steve E

I have Excel 2019 and other spreadsheet seem to work without the formula error.

Excel LADZ

No worries mate. The NAME error suggests that Excel doesn't recognise a formula. I've built this file using formulas such as XLOOKUP that can only be recognised by Excel 2019 and later. For example, the version Excel 2016 will not recognise this function and return an error. If you don't have the right version of Excel, I'll make a separate copy of the file that'll work with all versions 👍 This can be up and running within the next week 😃

Steve E

Thank-you for the quick response Unfortunately I am seeing #NAME? and #VALUE!, all over the spreadsheet, do I need to adjust something in Excel settings to fix this? Sorry, I am a bit of an old Lad with an interest in sport not so much IT knowledge.

Excel LADZ

Hi lad, welcome 🔥 To update the data, simply go into the 'Data' tab of Excel and select the "Refresh All" icon. I have the stats in this file connected to the internet via a Power Query. So, once these links are refreshed using the "Refresh All" icon, the new stats will be pulled in. From there, just select the two teams!

Steve E

I am a rookie Lad trying to figure out how to set up the Dockers-Pies game - do I update all pre-game stats manually (copy/paste) or is their an automatic update button I am missing? Please advise what I need to do set a game up correctly, thanks.

👑 Marvellous 👑

Through this app Lad.

Excel LADZ

Hi lad, this might be a feature added to the model as the season progresses 👍 It would just involve grabbing a player's average disposals, and then adjusting that figure based on the strength of their opponent (and their players) in the match. FYI, I'm currently making changes to the AFL Model above that will be live tomorrow. Collating the data at the very start of a season is tricky in Excel, but it'll all be correct before tomorrow's game lad 😃