Monday, December 20, 2021

2021-22 College Bowl Pool Summary File is Ready!

Ok, everybody! The summary file is ready.

Without further ado...the files:

If you have any trouble getting the download links to work, try a couple of things: 1) try opening the link in an icognito tab, 2) try using a different browswer, 3) try right-clicking and opening in a new tab or "saving as...". Honestly, I don't fully understand the underlying issue with Chrome and these download links.
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 -- once I've got that posted -- 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.

We'll see if we can make it through the entire bowl season without changes, cancellations, etc.

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, and I'll put these donations towards website hosting fees:

$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!

Thursday, December 16, 2021

2021-22 College Bowl Pool Entry Form is Ready! (Summary file to come)

Ok, everybody! I've got this season's college football bowl pool Entry Form file finally ready! I'm still working on the modifications necessary to bump up the old version to include this year's 43 total bowl games. (I didn't include the FCS Bowl, which was already played back on the 12th.) I'll try to wrap that up this evening, but since I know many of you pool administrators out there need to get picks in from your participants, here's at least that file. Special shout-out to super fan Kendall for helping get some of the info pulled together for me this year. Thanks, man!

Without further ado...the file:

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 -- once I've got that posted -- 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.

We'll see if we can make it through the entire bowl season without changes, cancellations, etc.

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, and I'll put these donations towards website hosting fees:

$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!