How Does This All Work

I have been a huge Fantasy Football fan for years now. I have participated in, and have managed several NFL Fantasy Football leagues.

Stats, projections, rankings and advice is very easy to find for NFL Football. Sadly, the pickins are pretty slim for Canadian ‘ball. So I set out to do something about this.

It all starts as soon as a CFL Football game is complete. I have a small app that scrapes the box scores directly from the CFL.ca website. The stats are written to CSV files that are dumped into my Dropbox.

CSVs

 

From there, I have created an Excel sheet that imports all the data from those CSV files, into a master stats spreadsheet.  This master spreadsheet then contains much logic, many maths, to come up with custom Stats, Rankings, Projections, Fantasy Points For and Against, and my Start/Sit Heatmap.

Excel

It is an ever-evolving beast that I continue to tweak and tune as time goes on. All data is from the current season only; naturally as the season goes on the numbers will fine tune themselves.

I hope you enjoy this resource as much as I enjoy putting it all together.

– Davan