Friday, August 11, 2017

NEW THIS YEAR! College Football Pick 'Em Pool!

Hey everyone! I recently had a person approach me to convert my NFL Pick 'Em Pool into a college football pick 'em pool. What a great idea! It was no easy feat, however, since for the college football pool, I had to allow the pool administrator to pick the games each week that he or she wanted to include in the pool, whereas for the NFL pool, the schedule is the schedule. Also, for this particular person, I needed to support the way they handled the bowl season. The result is pretty cool, though.


Here's how the pool works: at the beginning of the season the pool administrator determines the games that will be involved each week -- up to a maximum of 16 games each week -- and sends out the picks sheets for the entire season. All participants make their picks for the entire season at the beginning. They also can optionally have people answer some tie-breaker questions, though no scoring for these is accounted for in the master spreadsheet. Then the participants send their picks sheets in.

I wrote a macro that enables the pool admin to automatically pull in the picks from the participants' sheets, so that they won't have to manually key them in. They simply need to save the unprocessed picks sheets into a user-definable directory and click a button. Once they're processed, the pool administrator can move those picks files to a "processed" directory. What a time saver if you've got a couple hundred participants, right? I'll have ot figure out if I can do something similar for the NFL Pick 'Em...

I also adapted the automatic score updating from FootballDB.com, so as long as you've picked games tracked by that website, you can use that feature. 

Because the system is based off of the old NFL Pick 'Em pool file, you'll still have the choice to go straight picks vs. picking against the spread, and the choice of how to allocate points for correct picks. 


I can already anticipate, since my readers truly are the nicest, most appreciative people on the planet, that some of you will be offering to pay me or donate to me for the sheet. This, like the college bowl pool and NFL pick 'em sheets I do, I do for free -- because I enjoy them. That said, if you just _have to_ do something for me for my efforts, feel free to PayPal me whatever you like. It does help to cover my hosting costs, etc.:

$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 inaugural NCAA Football Pick 'Em pool. We're bound to run into a bug or snag or learning curve or two along the way, so when you do, just let me know, and I'll do my best to help resolve any issues.

Later,

Excel_Geek

Thursday, August 10, 2017

2017-18 NFL Pick 'Em Pool Files Are Ready!

Folks, I've completed and release this season's NFL Pick 'Em pool. Like past years, many of you have diligently been pestering me for weeks now. I had to wait a bit into the preseason, however, so that I could see how FootballDB.com was going to treat our now TWO teams from Los Angeles, so that my automatic score updater will work. Again this year, 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. 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