tag:blogger.com,1999:blog-11238774.post8879402615850551539..comments2024-03-11T05:16:11.252-07:00Comments on Excel_Geek...I'll Do That in Excel for $50: 2015-16 NCAA Football Bowl Pool Files Are ReadyExcel_Geekhttp://www.blogger.com/profile/15299063299312360136noreply@blogger.comBlogger38125tag:blogger.com,1999:blog-11238774.post-8982283691858845842015-12-24T04:25:48.001-08:002015-12-24T04:25:48.001-08:00Wow, Joe, that's quite a list. Feel to reach o...Wow, Joe, that's quite a list. Feel to reach out to me via email, too. 1a and 1b are pretty easy. 2 and 3 involve a total rework. 4 we'd have to talk about. If sharing the file easy is what you're after, I have some ideas. If you want this to BE a Google spreadsheet, you're crazy. :)Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-31027827187113725062015-12-23T22:01:27.096-08:002015-12-23T22:01:27.096-08:00Super Awesome Sheet! I thought I was an excel gee...Super Awesome Sheet! I thought I was an excel geek, I bow down to your skills!<br /><br />I will be running the office pool starting next year and am moving from their old system of pen and paper to show them the way of spreadsheets and shared updates. I have a couple of requests and would be willing to pay for a custom sheet if needed, let me know if that is the best route.<br /><br />1. Straight Pick 'em, figured out the "1" in each column. Would like to add a line for total score tiebreaker on the second to last or last bowl game. User picks a total score for the game and closest to the score breaks the tie.<br /><br />2. As previously requested, an easy way to add more than 40 users.<br /><br />3. Ability to sort the users on the sheet alphabetically or by top score.<br /><br />4. Put the sheet on google docs or smartsheet so there is an easy way to share the data with users "real time". I tried with both and it doesn't look like this will work due to the complicated features/formulas being used and not yet supported by them. Maybe a pipe dream. I haven't played with Excel 2016's sharing yet so not sure if it would work for this.<br /><br />5. Also when doing a straight pick 'em, changing the scale of the group chart to be closer to the total number of bowl games.<br /><br />Again, awesome sheet, if you do nothing else it will be so much easier than their old system. Thanks!!!Joehttps://www.blogger.com/profile/05980574548468964341noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-67273967298395498352015-12-23T21:54:25.585-08:002015-12-23T21:54:25.585-08:00Super Awesome Sheet! I thought I was an excel gee...Super Awesome Sheet! I thought I was an excel geek, I bow down to your skills!<br /><br />I will be running the office pool starting next year and am moving from their old system of pen and paper to show them the way of spreadsheets and shared updates. I have a couple of requests and would be willing to pay for a custom sheet if needed, let me know if that is the best route.<br /><br />1. Straight Pick 'em, figured out the "1" in each column. Would like to add a line for total score tiebreaker on the second to last or last bowl game. User picks a total score for the game and closest to the score breaks the tie.<br /><br />2. As previously requested, an easy way to add more than 40 users.<br /><br />3. Ability to sort the users on the sheet alphabetically or by top score.<br /><br />4. Put the sheet on google docs or smartsheet so there is an easy way to share the data with users "real time". I tried with both and it doesn't look like this will work due to the complicated features/formulas being used and not yet supported by them. Maybe a pipe dream. I haven't played with Excel 2016's sharing yet so not sure if it would work for this.<br /><br />Again, awesome sheet, if you do nothing else it will be so much easier than their old system. Thanks!!!Joehttps://www.blogger.com/profile/05980574548468964341noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-17022595024891473032015-12-22T05:54:55.969-08:002015-12-22T05:54:55.969-08:00@Anonymous RE: scenarios...
I'm working on it...@Anonymous RE: scenarios...<br /><br />I'm working on it. It's sort of a complicated thing to try to implement AND try to keep the file size manageable. I'll keep you posted.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-83623814148729774002015-12-21T22:15:12.458-08:002015-12-21T22:15:12.458-08:00Any update on whether scenarios will be put in the...Any update on whether scenarios will be put in the spreadsheet?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-30926582445168324662015-12-21T18:20:28.436-08:002015-12-21T18:20:28.436-08:00@Steve, read the rest of the comments, too, but yo...@Steve, read the rest of the comments, too, but you can just enter 1 in the points for every game if you want. Also, the point spreads are just informational. Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-33000861910655090282015-12-21T18:16:27.065-08:002015-12-21T18:16:27.065-08:00Is there a straight up version of the Bowl Pool?Is there a straight up version of the Bowl Pool?Stevehttps://www.blogger.com/profile/03466117848864766470noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-63063919421264568092015-12-20T16:24:46.628-08:002015-12-20T16:24:46.628-08:00@Anonymous RE: Bowl Ranking...that tries to repres...@Anonymous RE: Bowl Ranking...that tries to represent which bowls, from a relative perspective, have the most confidence points being wagered on them. Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-23189565549593050642015-12-19T19:45:02.277-08:002015-12-19T19:45:02.277-08:00On the GAME CHARTS sheet, what is the Bowl Ranking...On the GAME CHARTS sheet, what is the Bowl Ranking calculation? Mine's showing the Div/0 error on all.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-17219297562595205862015-12-19T13:08:30.414-08:002015-12-19T13:08:30.414-08:00@Tony, I'm glad you like it. Adding more parti...@Tony, I'm glad you like it. Adding more participants isn't super easy. You might be better off just having two files if you're not proficient in Excel. Certainly that's not ideal either, but it could get you through. If you want to dig into it, though, unprotect the Picks sheet and make the column/row headers visible again. Then head all the way to the 40th participant and unhide the three columns to the right of the two columns that are visible. You'll need to copy those five columns and paste them to the right of the last one. Then you'll have to unhide a sheet called summary_chart_data and make some modifications there. Then, if you want them updated, you'll have to dig into the Game Charts and Individual Charts sheets. Again, not super straightforward. I'd recommend just having some folks 41-46 in a second file.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-3043915175790872692015-12-19T12:34:06.204-08:002015-12-19T12:34:06.204-08:00This is great stuff! Thanks so much! I'll be d...This is great stuff! Thanks so much! I'll be donating for sure. AND you saved me from having to track and IT guy down to help me out.<br /><br />Quick question: I need to add 5-6 participants (total pool is up to 46 participants now). How do I do that without losing the formula? Thanks much!<br /><br />Best,<br />TonyTonynoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-83599563815862971152015-12-19T12:03:42.233-08:002015-12-19T12:03:42.233-08:00@PoolBoy, cool use of the spreadsheet, though I th...@PoolBoy, cool use of the spreadsheet, though I think it'd take a few modifications to handle pushes. Maybe that's something I'll consider adding support for next year. For this year, you can always make any tweaks you like. The sheets are protected, but not with a password.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-70777324877611585802015-12-19T10:51:51.005-08:002015-12-19T10:51:51.005-08:00Great spreadsheet! I'm going to have players ...Great spreadsheet! I'm going to have players pick against the spread for their picks. How would you recommend handling a push? Just count it as zero? Another option would be to give everyone half of their wager?<br /><br />What do you all think? Also wondering how to handle the selection using the spreadsheet in the event of a push against the spread.PoolBoyhttps://www.blogger.com/profile/06809378079633166914noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-32758293892576684142015-12-19T08:54:56.577-08:002015-12-19T08:54:56.577-08:00Yes, thanks very much!Yes, thanks very much!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-42945911649260179862015-12-19T08:52:37.026-08:002015-12-19T08:52:37.026-08:00@Tim O'Brien, what you could do is unprotect t...@Tim O'Brien, what you could do is unprotect the sheet (it's not password protected), and then change the data validation used for everyone's Championship game picks to reference the list of four teams in the semis. You'll have to create that list somewhere -- add a new tab is you like -- since Data Validation only likes the values to be in one column or row. Make sense?Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-54385274776556852772015-12-19T08:43:13.919-08:002015-12-19T08:43:13.919-08:00Is there a way to have the points be ONE and autom...Is there a way to have the points be ONE and automatically fill in each participants<br />cell when you choose the winner, or do you have to manually put in the points with each game?<br />MikeyBnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-16593622465040677202015-12-18T12:08:26.789-08:002015-12-18T12:08:26.789-08:00Awesome spreadsheet! Quick Q about the National C...Awesome spreadsheet! Quick Q about the National Championship picks. In our pool, we allow the players to pick any of the 4 teams from the semis. Because the Nat'l Championship has no spread (and no teams as of yet), you play a no-line pic'em from among the 4 teams. Tying the player's semi picks to the Nat'l Championship doesn't work for our pool because the player may pick a team based on the spread and that team may cover, but not get into the Nat'l Championship. Is there any way to unlock that command so that you can pick any of the 4 semi teams? Great job!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-28320283339096021082015-12-18T12:00:40.167-08:002015-12-18T12:00:40.167-08:00@Kendall, mine is doing the same thing.
@Kendall, mine is doing the same thing. <br /><br />Anonymoushttps://www.blogger.com/profile/05624330933108359276noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-89498607304612558452015-12-18T11:51:06.534-08:002015-12-18T11:51:06.534-08:00Hi, great sheet! Only Q I have is: for the Natio...Hi, great sheet! Only Q I have is: for the National Championship Game. Because the semi-finals are on the spread, and the Nat'l Championship has no line, our pool allows you to pick any of the 4 teams in the semis to win the Nat'l Championship since a team could win the semi game but fail to cover the spread, and thus you could pick a team that loses the game, but covers with the spread, and that team would not be eligible to be in the Nat'l Championship. Is there any way to change the command so that all 4 teams are eligible to be picked from rather than the 2 semi teams that the player chose with the spread?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-1116200905781198832015-12-18T07:54:36.096-08:002015-12-18T07:54:36.096-08:00@Chris Moseley RE: Using for straight pick pool......@Chris Moseley RE: Using for straight pick pool...yup, just enter a 1 for all games' confidence points. It'll highlight them all yellow -- this is a way for those using confidence points to know when they've entered duplicate values -- but it'll work just fine.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-59829136763977587082015-12-18T07:43:42.767-08:002015-12-18T07:43:42.767-08:00This is awesome!! Thank you!! I'm assuming if ...This is awesome!! Thank you!! I'm assuming if you don't want to use confidence points then you can simply put 1s instead...?chris moseleyhttps://www.blogger.com/profile/04517419032694646164noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-42573655731453191852015-12-17T11:55:57.263-08:002015-12-17T11:55:57.263-08:00@Kendall, not sure. You can always email me your f...@Kendall, not sure. You can always email me your file, and I can take a look. I use gmail, and my email is my first initial and last name. Eric Hunzeker.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-89018164722659745292015-12-17T10:35:09.473-08:002015-12-17T10:35:09.473-08:00For some reason, when I put entries in the summary...For some reason, when I put entries in the summary sheet, the "GAME CHARTS" tab works correctly, but the "INDIVIDUAL CHARTS" and "GROUP CHART" tabs do not input any information, even if I pick winners. Am I doing something wrong here?Kendallhttps://www.blogger.com/profile/10661439847840306893noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-45117525248052100832015-12-15T08:48:07.125-08:002015-12-15T08:48:07.125-08:00Good question, @Anonymous RE: point spreads. Curre...Good question, @Anonymous RE: point spreads. Currently they ARE there just as an FYI. It doesn't impact the picks. They're still straight picks -- winner vs. loser. I put them in there to get ready for some future features -- one being the ability to pick vs. the spread vs. just winners and losers, and the second a feature to probablistically determine which participants are most likely to win, given the results of the games that are complete, the games remaining, and the point spreads of those games. Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-90621802753231122942015-12-15T08:34:37.431-08:002015-12-15T08:34:37.431-08:00Forgive my ignorance - haven't played / used o...Forgive my ignorance - haven't played / used our pool since you started putting in points spread. Is the point spread a simple FYI or does the math impact an outcome i.e., if the "dog" loses by less than the spread does it now become a winner ? Anonymousnoreply@blogger.com