Monday, December 03, 2018

2018-19 College Bowl Pool Files Are Ready!

Ok, everybody! This season's college football bowl pool files are now ready!

Some noteworthy items:

  • I'm again not waiting until after the Army-Navy game, so I don't know Army's final record, so I've simply listed them as "Army (10-2 or 9-3)". I've found this to be simpler than leaving that cell unprotected, allowing you to edit it, 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 essentially the same as last year -- no new bowls and no eliminated bowls.
  • We do have three sponsor/name changes: The Zaxby's Heart of Dallas Bowl is now the Servepro First Responder Bowl. The Motel 6 Cactus Bowl is now the Cheez-It Bowl. And the Foster Farms Bowl has become the Redbox Bowl. You can just feel the tradition building with those...
  • This year, in addition to including the teams' records, I've included their rankings (for those in the top 25).
  • I've updated the sheets with opening betting lines for your convenience, but you should probably update these as we get closer to the games. I use the "VI Consensus" lines from Vegas Insider.
  • 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.

Finally, 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 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!

Monday, August 27, 2018

2018-19 NFL Pick 'Em Pool Files Are Ready

Folks, I've completed and released this season's NFL Pick 'Em pool. Like past years, many of you have been diligently pestering me for a few weeks now. The good news was that we don't (yet) have any new team names/cities to deal with this year. Maybe next year? The bad news (for me) was that FootballDB.com decided to significantly change how they display completed games, so I had to rewrite much of my automatic score updating code. Oh well, I believe it's ready to go now. As always, if we get into the season, and something doesn't seem to be working right, just let me know. Like years past, I have created a companion "Picks" sheet to distribute to pool participants, so they can simply email back the file for the admins to copy-paste into the master sheet. Just remember to always copy, paste special... values when moving their picks into the master sheet, so as to not jack up formatting or other stuff.

Without further ado, here are the files:

As also happens each year, several folks, as they were pinging, pestering, checking-in with me offered to pay me or donate to me for the sheet. I remind them that this, like the college bowl pool sheet I do, I do for free. That said, if you just _have to_ do something for me for my efforts, 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/50.

Anyways...please enjoy this year's NFL Pick 'Em. If you encounter a bug or need help with using the sheet, let me know.

Later,

Excel_Geek