Tag Archives: sports analysis

A Simple Fantasy Football Auction Draft Spreadsheet

Last year, we demonstrated how someone can make a fantasy football draft spreadsheet to help make the best decision in each round of a traditional snake draft.  While most leagues use snake draft, eventually you might be faced with a league where someone suggests an auction draft.  They might cite something like this article to make their case.  At  first you might feel intimidated, but once you remember that every auction round is just a data driven decision, and that spreadsheets are great at solving data driven decisions, you can build something to give yourself the best chance to succeed! Continue reading

What would the Lakers’ record be if Kobe Bryant was an average shooting guard?

The Lakers are off to a rough start this year – through 9 games they are 1-8, good enough for last place in the Western Conference. In this spreadsheet problem solving example, we’ll use spreadsheets to answer a pertinent question – if the legendary Kobe Bryant played like an average shooting guard, how would the Lakers have fared this year? Continue reading