Tuesday, December 05, 2017

2017-18 College Bowl Pool Sheets

Ok, everybody! You've all mostly been patient. I apologize that it took me a couple of extra days this year. I've been quite busy with the _real_ job. This season's college football bowl pool files are now ready!

Some noteworthy items:

  • Since we again aren't waiting until after the Army-Navy game, and we don't know Army and Navy's final records, I've simply listed what each of those two teams may have for final records. That's simpler than leaving those cells unprotected, allowing you to edit them, and then dealing with the possibility that you do that AFTER picks are entered and thereby cause the picks for those game to no longer match.
  • The bowl line-up is different then last year. We're down one bowl! No more Poinsettia Bowl. :: Sniff ::
  • Also, three other bowls got a rename: The Miami Beach Bowl is now the Frisco Bowl. The St. Petersburg Bowl is now the Bad Boy Mowers Gasparilla Bowl. O_o And the Russell Athletic Bowl is now the Camping World Bowl.
  • There aren't currently betting lines set on the two games involving Army and Navy, so I just added the spreads for those already available -- check Vegas Insider or similar sites. I did, though, use the first team as the "favorite" for those two games, so that I could do some testing with the "Odds of Winning" functionality, which doesn't work unless favorites are set. This is interesting to know, so that if you find a game has no favorite, at least pick one of the teams and either leave the Spread blank or set it to zero.
  • My wife, son, and I haven't had a chance to make our picks yet, so for those of you who like to use our picks as benchmarks of sorts, you'll have to wait until I update that later.
  • Finally, I did choose to keep the FCS-level Celebration Bowl as part of the line-up. Feel free to have your participants make picks for that game or not, as you like. It ends up being an exciting game, at least.
Without further ado...the files:
For those unfamiliar with the two-file system, the idea is that pool managers can distribute the simple, single person Entry Form version to those in their pool to make their picks and assign confidence points. The participants them email back that file, and the manager can simply copy, paste special... values those picks and points into the Summary file, which is where they manage everything.

As always, the file is protected, but not with a password, so feel free to unprotect the workbook and then unhide some of the sheets running this stuff behind the scenes to see how it works. And if you add some cool hacks/additions, pass them along, so we can all enjoy them.

Final, as also always happens each year, several folks, as they were pinging, pestering, checking-in with me offered to pay me or donate to me for the sheets. This, like the NFL pick 'em sheet and the new NCAA football pick 'em sheet I do, I do for free as a labor of love. That said, if you are so compelled, feel free to PayPal me whatever you like:

$5.00     $10.00     $25.00     $50.00

Really you just have to change that dollar amount in the URL -- https://paypal.me/excelgeek/5.

Enjoy, everyone!