Monte Carlo Simulation – Fantasy Football playoff predictor

How likely will you make the fantasy football playoffs? It’s week 11 of the Fantasy Football season, which means there’s only three more weeks until the Fantasy Football playoffs. All your hard work up to this point – drafting your team, closely following daily fantasy football podcasts and injury reports, and agonizing over who to play in your Flex spot – rests upon what happens in these next few weeks. Continue reading “Monte Carlo Simulation – Fantasy Football playoff predictor”

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 “A Simple Fantasy Football Auction Draft Spreadsheet”

Use a spreadsheet to check Matthew Berry’s Top 200 Fantasy Football Rankings results from Week 1

“It’s hard to make predictions, especially about the future”  Various

Usually, improvement in prediction-making comes in two steps.  Step 1: Make a Prediction.  Step 2: Evaluate how accurate the prediction was, and learn from it.  Often times, Step 2 can get overlooked as we move on to future predictions and future weeks of fantasy football.  Spreadsheets can help us quickly evaluate how our predictions were, and quickly point out where we might have erred.

Continue reading “Use a spreadsheet to check Matthew Berry’s Top 200 Fantasy Football Rankings results from Week 1”

Fantasy Football Player Combos – an exercise in spreadsheet treasure hunting

In many parts of life, having a combination of two things can lead to better outcomes. Having stocks and bonds means sometimes the stocks do well while at other times the bonds do well, resulting in better overall portfolio performance. Also, the driver of this truck pictured below probably has at least one of his teams doing well.

frontrunner-exc
Source: http://www.sportsgrid.com/mlb/frontrunner-truck/

Continue reading “Fantasy Football Player Combos – an exercise in spreadsheet treasure hunting”

A Simple Fantasy Football Draft Spreadsheet

Fantasy Football Season is here! It’s that time of the year where we sit down on the couch every Sunday to cheer for our group of superstar mercenaries as they help our team embarrass (avoid embarrassment?) those of our friends. Fantasy Football drafts are coming up and this post will hopefully help you with your draft, and of course continue to help you learn how to use spreadsheets. Continue reading “A Simple Fantasy Football Draft Spreadsheet”