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 👍
G'day lads, comment down below if you have any questions 🔥
Thnks for tour hard work and sharing with us.
Gr8 spreadshett...as in NFL everything is based on "Spreads" antwat to incoperate spreads in model?...Thanks
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) 👍
@@excel_ladz Thanks. Couldn't get it to work for some reason but downloaded the Legacy version and it worked.
Do you have a NCAA Football ELO model?
how do you get the win probability percentage to equal the point spread in excel??
🎉
I couldn't finished since I'm using spreadsheet on my gmail account . The geography part not working
do you have a link we can just take the format or do we have to manually do it
Where in the FiveThirtyEight website is the download link?
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 👍
evaluate the money line bet..
can you explain like im 5