tag:blogger.com,1999:blog-11238774.post7510038362899189144..comments2024-03-11T05:16:11.252-07:00Comments on Excel_Geek...I'll Do That in Excel for $50: 2022-23 NFL Pick 'Em Pool Files Are Ready!Excel_Geekhttp://www.blogger.com/profile/15299063299312360136noreply@blogger.comBlogger38125tag:blogger.com,1999:blog-11238774.post-74347754962921436192023-09-10T14:01:34.609-07:002023-09-10T14:01:34.609-07:00IS THERE SOMEWHERE IT SHOWS THE TOTAL SCORE FOR TH...IS THERE SOMEWHERE IT SHOWS THE TOTAL SCORE FOR THE WEEK FOR THE GAMES?<br />(ADD THE TOTAL OF THE CORRECT GAMES) Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-25673571520780016952023-09-07T08:34:57.102-07:002023-09-07T08:34:57.102-07:00This year's files are out! (https://blog.excel...This year's files are out! (https://blog.excelgeek.com/2023/09/2023-24-nfl-pick-em-pool-files-are-ready.html) Sorry for the delay, and thanks to those of you who'd jumped in to help folks out when it looked as though I wouldn't come through. Sorry for the last-minute delivery.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-22395651389137283472023-09-07T07:05:01.665-07:002023-09-07T07:05:01.665-07:00 I THINK THIS IS HOW YOU UP... I THINK THIS IS HOW YOU UPDATE THE SHEET <br /><br />THE VERY LAST SHEET IS THE SCHEDULE. I THINK YOU JUST HAVE TO UPDATE THE TEAMS AND IT CHANGES IT ON THE MASTER. IM NOT SURE IF IT WILL STILL PULL SCORES OR IF YOU WILL HAVE TO INPUT THE SCORES MANUALLY EACH WEEK BUT I BELIEVE THIS WILL WORK I WILL REPORT BACK AFTER WEEK ONE AND TELL EVERYONE MY FINDINGSjosh Thttps://www.blogger.com/profile/15875238794073279099noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-81455815280484326512023-09-06T09:32:19.608-07:002023-09-06T09:32:19.608-07:00To the anonyomous poster who updated the old sheet...To the anonyomous poster who updated the old sheet with the new schedule, would you be willing to share what you are working with some of us? armstrongtj [@] gmail if so.<br /><br />Thanks!T.J. in Ohiohttps://www.blogger.com/profile/02295616739928134454noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-29645358872394654272023-09-06T07:29:31.233-07:002023-09-06T07:29:31.233-07:00Hey there! Just wondering if you were going to do...Hey there! Just wondering if you were going to do one for this year (23-24)<br /><br />Thank you!Todd DuBreyhttps://www.blogger.com/profile/02333078563222422529noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-46173389279757640502023-09-05T15:14:22.559-07:002023-09-05T15:14:22.559-07:00I can’t access the schedule to update for this yea...I can’t access the schedule to update for this year season. Are you putting out a 2023 season?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-49023614891632558322023-09-05T14:15:43.237-07:002023-09-05T14:15:43.237-07:00Hello,
I updated the new schedule into the old 202...Hello,<br />I updated the new schedule into the old 2022-2023 sheet. Will there be any other changes to the new sheet? It looked like I needed to change the year in the “score parsing sheet” to retrieve scores, so I did. Will it work? Thanks for this sheet; used to use a lot but then not at all for the last 4 yrs. If you want the new schedule sheet, let me know how I can get it to you. It tools some time to type in, but I’m sure you have some automated populating system. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-62806571620066948662023-08-28T11:48:47.115-07:002023-08-28T11:48:47.115-07:00Will there be a new spreadsheet for the 23-24 seas...Will there be a new spreadsheet for the 23-24 season?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-63587537260663590602023-08-27T11:53:15.658-07:002023-08-27T11:53:15.658-07:00When are you coming out with the NFL 23-24 Spreads...When are you coming out with the NFL 23-24 Spreadsheets?Coachhttps://www.blogger.com/profile/10044108908913145455noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-59826009802323417212023-08-25T07:16:28.375-07:002023-08-25T07:16:28.375-07:00Are you doing this again this year?Are you doing this again this year?Shanehttps://www.blogger.com/profile/11134794384581091750noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-72042319653684198402023-08-21T09:40:21.669-07:002023-08-21T09:40:21.669-07:00Will you be posting a 2023-2024 Pickem Sheet? Thi...Will you be posting a 2023-2024 Pickem Sheet? This is an epic file that has helped me manage our friendly pickem group.T.J. in Ohiohttps://www.blogger.com/profile/02295616739928134454noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-14508500988629098982023-01-25T14:36:57.176-08:002023-01-25T14:36:57.176-08:00@Kage RE: changing how much a game is worth in the...@Kage RE: changing how much a game is worth in the playoffs...<br /><br />If you've got your settings set to "Use Confidence Points" = No, then all the games are worth one point. You could switch that setting to yes, then set "Confidence Points Type" = "Pool of Points" then set the "Confidence Points Pool" to the sum of the value of the points you'd like to award for each game. Should still work after changing mid-way through the season. Good luck!Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-65520331427470237752023-01-25T08:36:49.994-08:002023-01-25T08:36:49.994-08:00Can I change how much a game is worth points wise ...Can I change how much a game is worth points wise on the playoff games?Kagehttps://www.blogger.com/profile/08727322953381974834noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-73972626408311769402022-12-05T08:14:04.816-08:002022-12-05T08:14:04.816-08:00When can we start pestering you about 2022-2023 co...When can we start pestering you about 2022-2023 college bowl games?Anonymoushttps://www.blogger.com/profile/07381703685097554846noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-82684084960814013372022-09-20T07:07:36.862-07:002022-09-20T07:07:36.862-07:00Hello i cant seem t find he update scores tab. Hello i cant seem t find he update scores tab. Dannynoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-19716133293738404432022-09-09T05:55:11.822-07:002022-09-09T05:55:11.822-07:00@Unwise RE: unprotecting... I'm not sure what ...@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.<br /><br />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.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-31642656539531318742022-09-08T19:26:22.936-07:002022-09-08T19:26:22.936-07:00Hello i tried to unprotect it and its asking for a...Hello i tried to unprotect it and its asking for a password. ALso, how can i email the actual picks.<br /><br />Thanksunwise1https://www.blogger.com/profile/04824276296365966041noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-17049725276542488252022-09-07T11:35:57.274-07:002022-09-07T11:35:57.274-07:00@Unknown RE: Favorites row being greyed out... Tha...@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!Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-13338817722663438922022-09-07T09:07:13.615-07:002022-09-07T09:07:13.615-07:00Realized i asked this question on last years post ...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.Anonymoushttps://www.blogger.com/profile/00092810093342269418noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-78960902922987753122022-09-02T09:49:12.832-07:002022-09-02T09:49:12.832-07:00Got, thanks. Appreciate your help on this.Got, thanks. Appreciate your help on this.Andrewhttps://www.blogger.com/profile/13900674199525692530noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-68000257359738046642022-09-01T17:05:06.959-07:002022-09-01T17:05:06.959-07:00@Andrew RE: displaying standings... I'm not su...@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. Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-76692992246531630812022-09-01T09:48:26.547-07:002022-09-01T09:48:26.547-07:00Got it, thanks and I see where it is tracking the ...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?Andrewhttps://www.blogger.com/profile/13900674199525692530noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-82155790110241971652022-09-01T09:19:01.312-07:002022-09-01T09:19:01.312-07:00@Andrew RE: unprotecting the schedule sheet... Jus...@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. Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-72709161629548609272022-09-01T08:34:35.107-07:002022-09-01T08:34:35.107-07:00Got my spreadsheets mixed up on my last post. Go ...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.Andrewhttps://www.blogger.com/profile/13900674199525692530noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-6400285353913908902022-08-31T18:55:46.756-07:002022-08-31T18:55:46.756-07:00I was actually able to download it but I have run ...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?Andrewhttps://www.blogger.com/profile/13900674199525692530noreply@blogger.com