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:
- 2017-18_NFL_Weekly_Football_Pool.xlsm
- Updated with Tampa at Miami moved to Week 11: 2017-18_NFL_Weekly_Football_Pool_schedulechange.xlsm
- 2017-18_NFL_Weekly_Football_Pool_Picks.xlsx
$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
26 comments:
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?
@Alonso, you can reach me at e Hunzeker @ gmail l . C o m. No spaces.
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
@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.
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?
@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.
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?
@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.
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?
@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.
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
@Amy... oops. Yes. It should be fixed now.
Thanks a bunch! Game on!
Amy
Hello Excel Geek. How do I update the "PICK" page to send to my participants?
@Rickey... just select the cell with Week 1 in it and select a new week.
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
@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.
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!!
@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!
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.
@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?
HI Excel Greek, I notice that when sorting by total points the rank doesn't change for the person. So as an example Employee A is rank 1 on weekly point but for Total Season Points that same employee is rank 9. I am also not sure how to determine a 2nd place for the total season. My company gives a 1st, 2nd & 3rd place prize to the employees. So for wk 7 I have 2 employees with 65 total points and 4 employees with 62 total points. Is there a way to rank them similar in what you have done with the Weekly pts rank and total.
@Jeannine RE: sorting... see Jimmy's comment and my reply earlier in the comments on this post.
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
Ms excel training in chennai
Will there be one this year?
hey, excel greek wanted to see if you will be doing the football pick em sheet this year?
I hope so
thank you
Post a Comment