Monday, February 12, 2018

2018 NASCAR Fantasy League Manager Spreadsheet

2018 is now the fith(!) year in a row that I’ve made the NASCAR Fantasy League spreadsheet available for download (and I'm not even a NASCAR fan). This NASCAR fantasy game is based on Total Driver Points according to NASCAR’S scoring system. In order for your drivers to score they must be running for Monster Cup Points. Drivers may run in more than one NASCAR division but can only score points in one division.



How to Play NASCAR Fantasy in Excel


At the beginning of the year (first race is Daytona on February 18th) participants choose ten race car drivers as follows: three from Group 1 & 2 and two from Group 3 & 4. In Group 3, you may write in any driver that is not listed in one of the groups AND drove for points in the 2017 season. In Group 4, you may write in any driver that is rookie for the 2018 season. These will be their 10 drivers for the entire year - no changing after the entry deadline. All players also submit the three drivers that they think will place 1st, 2nd, and 3rd in the NASCAR standings at the end of the year. They don’t need to have these drivers in their picks, just who they think is going to finish on top. This is used as a tie-breaker. Drivers are listed in the order of their Monster Cup point total for 2017 season. Monster Cup points (including Chase points) will be from Nascar.com and driver point totals will be accumulated for each of the 36 races.



The fantasy league manager manually enters each player’s picks into the spreadsheet at the beginning of the year (or uses the new entry form to copy and paste entries). Players keep the same drivers all year long. After each race, the manager then goes to ESPN.com and enters the amount of points that each driver earned during the race into that driver’s column. The spreadsheet then automatically adds and ranks each player according to their driver’s scores.


I used many of the same formulas found in the leaderboard of my NCAA Bowl Prediction Pool sheet. This NASCAR fantasy manager template can currently handle up to one hundred drivers and one hundred participants without needing to modify a single formula!

2018 NASCAR Fantasy League Manager Download


The beauty of this fantasy racing league manager is you will not have to change or modify any formulas yourself (unless you want to of course). Instructions are included within the Excel file and shows you exactly how to add more players or drivers. If you enjoy using this NASCAR sheet I would really appreciate it if you would share it with friends, family, and coworkers.

2018 NASCAR Fantasy League manager spreadsheet download

To be notified when any updates are made to the file or to get a notification when next year's template is available, download using this link(requires an email address). You will be given the download link instantly and one will be sent to your email if you want to download it later.

Download now by entering your email (which will only be used to send you an update if we add a new feature or alert you when next year's sheet is available). Enter a zero for free download or make a donation to my children's future college education fund ;)

I welcome any questions, comments, or suggestions! Have fun.