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.
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 welcome any questions, comments, or suggestions! Have fun.
How to Play NASCAR Fantasy in Excel
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!
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 ;)
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 ;)
Nick, i like your Nascar spreadsheet. But our 18 players want to choose our own drivers each week? will your spread sheet do that? So the frist week we select a random picking order. then after the first race we take the finishing order and reverse it. that is the picking order for the next race. and so on all throught the year. so each week each player has a diferrent driver
ReplyDeleteHey Nick! I love your spreadsheet so much that I am using it for my league this year and I'm trying to use the same format for an SRX standings that I'm keeping track of on my own. I'm just using the "Race Scores" tab and the "Driver Ranks" tab with 8 drivers. I'm running into an error on the Driver Name formula in the Driver Ranks tab. It's looking for Columns C and D (=VLOOKUP(F2,$C$2:$D$101,2,FALSE) but those columns are hidden (Columns A-D). How do I get around this? I'm not good with formulas but really like your tables and am just using it for my own pleasure of keeping track of the SRX Standings (since their own series doesn't do a good job at it!) Thanks for any help,
ReplyDeleteChad
Are you able to unhide columns C&D?
DeleteNo, they're locked. The unhide is greyed out
ReplyDelete