Monday, December 03, 2018

2018-19 College Bowl Pool Files Are Ready!

Ok, everybody! This season's college football bowl pool files are now ready!

Some noteworthy items:

  • I'm again not waiting until after the Army-Navy game, so I don't know Army's final record, so I've simply listed them as "Army (10-2 or 9-3)". I've found this to be simpler than leaving that cell unprotected, allowing you to edit it, and then dealing with the possibility that you do that AFTER picks are entered and thereby cause the picks for those game to no longer match.
  • The bowl line-up is essentially the same as last year -- no new bowls and no eliminated bowls.
  • We do have three sponsor/name changes: The Zaxby's Heart of Dallas Bowl is now the Servepro First Responder Bowl. The Motel 6 Cactus Bowl is now the Cheez-It Bowl. And the Foster Farms Bowl has become the Redbox Bowl. You can just feel the tradition building with those...
  • This year, in addition to including the teams' records, I've included their rankings (for those in the top 25).
  • I've updated the sheets with opening betting lines for your convenience, but you should probably update these as we get closer to the games. I use the "VI Consensus" lines from Vegas Insider.
  • Finally, I did choose to keep the FCS-level Celebration Bowl as part of the line-up. Feel free to have your participants make picks for that game or not, as you like. It ends up being an exciting game, at least.
Without further ado...the files:
For those unfamiliar with the two-file system, the idea is that pool managers can distribute the simple, single person Entry Form version to those in their pool to make their picks and assign confidence points. The participants them email back that file, and the manager can simply copy, paste special... values those picks and points into the Summary file, which is where they manage everything.

As always, the file is protected, but not with a password, so feel free to unprotect the workbook and then unhide some of the sheets running this stuff behind the scenes to see how it works. And if you add some cool hacks/additions, pass them along, so we can all enjoy them.

Finally, as also always happens each year, several folks, as they were pinging, pestering, checking-in with me offered to pay me or donate to me for the sheets. This, like the NFL pick 'em sheet I do, I do for free as a labor of love. That said, if you are so compelled, 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/5.

Enjoy, everyone!

21 comments:

Anonymous said...

I think you have an error with the championship game in your sheet.

Anonymous said...

I think you have an error in your championship game formula.

Unknown said...

The playoff games are wrong.

should be cotton and orange bowls not rose and sugar.

this is the best spreadsheet ive ever used though.

Anonymous said...

The spreadsheet has the national championship between the Rose and the Sugar,it should be between the Cotton and the Orange. And the date should be 01/07/19 at 8:00 p.m.

Excel_Geek said...

Opps! I've corrected both the Picks and Summary files so that the proper games are included in the 4 team playoff. I'm not sure how I didn't catch that the first time. Trying to go too fast, I guess. I've also corrected the date and time of the game and formulas driving the participants of the National Championship game.

Let me know what other issues you may find!

Anonymous said...

Line 41 where you make your pick for the National Champion has no drop down choice to select from

Jill L. said...

Have you considered adding a sheet that lists all participants ranked by current points (highest to lowest) to make it easier to see who's ahead based on numerical values along with the group chart that shows it visually? I have some older participants that are not real computer savvy that just want a list and struggle to understand the sheet (or multiple tabs) with in the spreadsheet.

I have tried to add a sheet that does something similar.. but the code is FAR beyond what I know... and I usually end up messing the whole thing up. =;(

I do appreciate you making this available!

Unknown said...

What if i have more than 40 entries?

Excel_Geek said...

@Anonymous RE: Line 41 (in the Picks file)...

I'm not seeing the issue you're apparently seeing. Things appear to be working as designed. Feel free to send me your file or a screen cap of the issue. My name is Eric Hunzeker. My email is comprised of my first initial and last name and is from the main email service provided by Google.

Excel_Geek said...

@Jill...

Not a bad idea. Maybe that's something I'll add for next season.

Excel_Geek said...

@Unknown RE: more than 40 entries...

Sadly at this point you'll simply have to have more than one copy of the file running. Adding more participants is no trivial task AND the size of the file keeps getting bigger and bigger.

Anonymous said...

I am having the same problem with the pick column on Line 41. It is letting me select from who i pick in line 39 and 40, not from the 2 teams from the Orange and Cotton.


Anonymous said...

The drop down for the national championship is still showing the winners of the Rose and Sugar instead of the winners of Cotton and Orange. For example, I pick Clemson and Bama to win, and their names are loaded into the matchup cells for the N.C., but the drop down shows the teams I pick for the Rose and Sugar (ex. Georgia and Ohio St.)

Anonymous said...

I'm having the same problem..."Line 41 where you make your pick for the National Champion has no drop down choice to select from"

Anonymous said...

Hello. The drop down choices for the National Championship game is still set to the Rose and Sugar bowls vs. Cotton and Orange bowls

Excel_Geek said...

@All -- I've corrected the issue with making picks for the National Championship game in both the Picks and the Summary files. Sorry about that mistake. -- eric

Sarah said...

Thanks for the fix - but I still cannot make a selection in the championship game - says it is password protected for that box????

Excel_Geek said...

@Sarah...

Are you sure you're trying to make a selection or pick a favorite? I have the cell to pick the favorite locked down b/c we don't yet actually know who's in that game, so there are no favorites. The actual cell you make your pick in should be fine, right?

Sarah said...

good to go.
Thanks

Nick said...

Hello,

This is the third year that I have used your workbook to manage the college bowl pool. It is simply incredible. One question that I have is, one of my pools is just 10 people. Normally, as I have done for this year as well, I just go through and delete the columns in the first worksheet, the corresponding rows in the second, and the columns and rows in the third and 4th. I was curious if there is a simpler way to do this, perhaps in the hidden worksheets? There is no issue, and it is by no means a pressing concern, as I have gone through the main worksheets and deleted out 11-40 for each. I was just curious! Thank you for doing this yearly, I truly appreciate it!!

-Nick

Excel_Geek said...

@Nick...

Nah...I'd probably be doing just has you do if I wanted to cut down the clutter of all the unused participant slots. Sorry! It's tough to build a spreadsheet as complex as this readily sizeable for anyone's preferences. Most of the time I get requests to add 10, 20, 50 or 100 more!