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

21 comments:

Alonso Gonzalez said...

Hey how can i contact you privately, for questions and stuff? Your sheet looks amazing, I cannot believe it! Do you have an email or twitter account so that I can write to you?

Excel_Geek said...

@Alonso, you can reach me at e Hunzeker @ gmail l . C o m. No spaces.

Joshua Tapia said...

thank you, my office loves these poll sheet and look forward to it, this year we will be using the yearly accumulated total for a grand prize. I was wondering if you had a rule sheet to pass out as well

Excel_Geek said...

@Joshua, I don't currently have a "rule sheet" and I'm not totally clear on what you're envisioning. Are you looking for something that lays out how your particular pool will be ran?

Feel free to elaborate.

Tomas Pessenda said...

Phenomenal sheet! Just a quick question on points: Can you explain how the "game pts," "tie-break pts," and "tie-break pts miss." is calculated and what it's referencing?

Excel_Geek said...

@Tomas -- I replied to your email as well, but you enter the scores in the points fields for each team for each game to determine the winner of each game. Tie-break points is the guess each participant makes for the total combined score of the tie-break game, which for all weeks with 16 games is game 16 -- typically the Monday night game. Tie-break miss is how many points each participant's guess was off by vs. the actual combined score.

Note that the version of the sheet I had initially posted didn't have the last game of each week set as Game 16 (even for weeks with <16 games) to make this work properly. this is now fixed.

ebridge07 said...

Thank you for making this! For the Picks spreadsheet: I notice that it only lists week 1 picks. Will a new one be available each week to send out to people to complete? Or does it automatically update to week 2?

Excel_Geek said...

@ebridge07... select the merged cells where it says "Week 1". You'll see that's a picklist of all of the weeks. Simply pick the week you want to create picks for and the games update.

Jeannine Marchette said...

Love this sheet!! One quick question, given the recent changes with the rescheduling of the Tampa/Miami game will you post an updated sheet or provide instruction on how to change the sheets? or will the sheet automatically update?

Excel_Geek said...

@Jeannine...

Great question! I've gone ahead and posted an update on this post with a modified file that takes this schedule change into account. You could also make this change to the previous file yourself. Simple go to the Schedule tab, unprotect it (it not password protected), and make the changes. Then reprotect the sheet so as to not accidentally jack it up later.

Amy S. said...

Hi Excel Geek. Thanks so much for continuing to create and share this workbook. We love it! Quick question ... when I clicked on the link for the updated file (with TB/Miami moved to Wk 11), the original file opens for me with TB/Miami on Wk 1 yet. Is it possible the link remains to the original file and not "... schedulechange.xlsm"? Or am I simply accessing the wrong link? Any advice you can lend will be most appreciated.

Thanks much!
Amy

Excel_Geek said...

@Amy... oops. Yes. It should be fixed now.

Amy S. said...

Thanks a bunch! Game on!

Amy

Rickey Dash said...

Hello Excel Geek. How do I update the "PICK" page to send to my participants?

Excel_Geek said...

@Rickey... just select the cell with Week 1 in it and select a new week.

Anonymous said...

Hey this excel sheet has been amazing thank you for doing it! Question week 1 i had no problem saving it filling it in and then sending it out to the people participating in it then week 2 i was able to fill it in but it wouldn't save so i finally had to take a photo of everyones picks could you please tell me what i might be doing wrong do fill out and save so that i might be able to send it out via email as an attachment ... thank you

Excel_Geek said...

@Anonymous... I'm not sure. If you sent out the "picks" file to your participants, they should just be able to switch it from Week 1 to Week 2, make their picks, save as "week2 picks.xlsx" or whatever and send that to you to copy-paste special... values onto the "master" sheet.

Jimmy Sandison said...

Is there a way to sort all players names alphabetically without messing up all the data on all the past weeks for the total season points? For example, Adam Bobby Charles and Edward all play weeks 1-3 but then David joins in week 4. I have to add David to the bottom of the players list on week 1 so that he shows up on week 4's roster. Is there a way to sort Week 1 players alphabetically so it is easier to find people's names in future weeks? I run a pool of about 60-100 players a week and not everyone competes on every week but I still track overall season points for everyone. Last year I had a list of nearly 200 people and only had about 60-90 average every week. Searching thru the list made it very time consuming to enter in everyone's picks.

Thank you!!

Excel_Geek said...

@Jimmy... yeah...no. The sheet really isn't set up for your sort of situation. Its actually not set up well for pools that do picks each week and not all at the beginning of the year. I may have to see what can be done for next year. Sorry, not much I can do for you for this year. Best of luck!

Anonymous said...

FYI for future years and for people to be aware of with this years sheet that I just noticed, if the Monday night game does not land on "Game 16" column then the "TIEB-BREAK PTS MISS" column does not calculate correctly. For example Week 5 was the first week with bye's so there were only 14 games played leaving game 15 and game 16 blank. In order to have the tie-break pts miss column correctly mark the winner you need to fill in the score in Game 16 column.

Excel_Geek said...

@Anonymous... yes, that's how I've got the files arranged. The Monday night game (or latest Monday night game for weeks with more than one) is always Game 16. You can control this yourself, too, on the Schedule tab. Do you have a version where that's not the case?