Sunday, August 14, 2022

2022-23 NFL Pick 'Em Pool Files Are Ready!

Folks, I've completed and released this season's NFL Pick 'Em pool. I actually got this done before too many of you had to pester me! All I had to do to make this year's version from last year's was to update to the 2022-2023 schedule. Seems too easy. I did test the automatic score pulling feature, and it seems to be good, but, as always, just let me know if things don't seem to be working.

Like years past, there's also 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:

Remember, this NFL pick 'em sheet, 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

24 comments:

Unknown said...

I cant seem to download from the link, can you check it to make sure it works?

Excel_Geek said...

@Anonymous RE: can't seem to download from the link...

Try opening the link in an incognito window or using the "save link as..." option. Should be fine. Sometimes Google outsmarts itself thinking there's a security issue because the one file has embedded macros.

Andrew said...

I am having the same problem...getting a message that says the file is not safe to download and won't let me download it. What is an "incognito window" because it won't let me save link as either.

Excel_Geek said...

@Andrew RE: download issues...

If you're using Chrome as your browser, right click on the download link and select "Save link as..." You'll get a "... can't be downloaded securely" message. Use the menu in that pop-up and select "Keep." It should download, and it is a safe file to download.

Unknown said...

Can you do one for college football? Please. Ready to pay if you will.

Excel_Geek said...

@Unknown RE: college football... I'd consider it. Would I just get to pick the 10 or 20 or however many games each week? There are so many games.

Unknown said...

I believe you did one in the past. In that one you had it where I could pick the games. Example: Week 1 : I inputed the home and away team for first game. and so on for the rest of the 16 games.

I downloaded it from excel_geek.

Unknown said...

It was published August 11, 2017. The one I used for so long.

Excel_Geek said...

@Unknown RE: college football pick 'em... Is the issue that the automated score updating no longer works?

Unknown said...

Automated scoring and some new teams are not listed.

Andrew said...

Looking for a confidence pool spreadsheet that would only include the Thursday Night games where the player would have to pick the winners of each Thursday night game before the season starts. The assigned confidence points would be awarded if the player picked the correct winner.
I could enter the schedule myself and could possibly work with the Monday night game and Sunday night game. Is this even possible?

Excel_Geek said...

@Andrew RE: confidence pool for Thursday night games... Anything's possible, but if you're actually asking if I could build a custom one for you, I don't think I'll have time before the season gets rolling, for sure. I think you could get pretty close using my standard NFL pick 'em pool, though. You'd just enter all of the Thursday games as the games in Week 1 (you'd only get 16 weeks worth of games, though) and then opt to use confidence points. ~\_O_/~

Andrew said...

Thanks for getting back to me...I'll try to download it again but the last time I tried it wouldn't let me do it and can't remember the reason why. And I think you're right in that it may be too late to get it set up.

Andrew said...

I was actually able to download it but I have run into some errors because I have Excel 2010 and I noticed that the requirement is Excel 2016. Can the macros be opened for editing, not that I can probably fix the problem but I could at least give it a shot. I also assume that I would then be able to change the schedule?

Andrew said...

Got my spreadsheets mixed up on my last post. Go this one downloaded but I can't make any changes to the schedule on the schedule tab as it says it is closed. How do I get it opened to enter the Thursday Night Games in Week 1.

Excel_Geek said...

@Andrew RE: unprotecting the schedule sheet... Just go to the Review menu when you're on that sheet and select Unprotect Sheet. There's no password.

Andrew said...

Got it, thanks and I see where it is tracking the point totals for the season which is what I would need. I assume that if I wanted to display standings I would save the spreadsheet as a web page?

Excel_Geek said...

@Andrew RE: displaying standings... I'm not sure what you're envisioning by "display standings". You could always sort by points in the sheet, hide a bunch of columns and snip a picture of the current standings and save as an image.

Andrew said...

Got, thanks. Appreciate your help on this.

Unknown said...

Realized i asked this question on last years post instead of this year. The "Favorites" row doesnt show the text when favorite is opted for and spread put in. It shows it in the formula bar though so I know it is there. I assume the color is the same for the text and background fill but it can't be changed. Sorry for the double posts but any help is appreciated.

Excel_Geek said...

@Unknown RE: Favorites row being greyed out... That's by design. Go to the Settings tab and select to use "Vs. Spreads" vs. "Straight Picks" in the Pick Type field, and that row will come to life for you. Enjoy!

unwise1 said...

Hello i tried to unprotect it and its asking for a password. ALso, how can i email the actual picks.

Thanks

Excel_Geek said...

@Unwise RE: unprotecting... I'm not sure what you're seeing. The individual sheets are protected, but not with a password. The workbook is protected, but not with a password, and the VBA (macros) project is not protected.

RE: emailing picks... What do you mean? How it's envisioned to work is that a participant in the pool will make their picks in the "picks" version of the file and then email that file to the pool administrator to input (copy-paste special values, always) into the "master" file.

Danny said...

Hello i cant seem t find he update scores tab.