Thank you lad 🙏 The spread is included in this video within the Green cells (O1 & O4), where the favourite gets the minus number and the underdog gets the plus number. In other models, you would calculate the spread by finding the expected final score difference between the two teams.
Great but doesn't work on Excel 2016 without a subscription. Geography not an option. Not sure if it can be done with Google sheets, Open Office or some other free spreadsheet option.
Hi lad, unfortunately you're right. It doesn't much matter though. As long as you type in the latitude and longitude manually, then your model will continue working with the Home Advantage formula (after changing XLOOKUP to VLOOKUP) 👍
Hi lad, the second link in the description is the methodology of how FiveThirtyEight made the model (which this video follows, except for the rolling Quarterback rating adjustment). To download this spreadsheet, click on the first link in the description. This will take you to the Excel LADZ Patreon page where you can download the spreadsheet 👍