tag:blogger.com,1999:blog-11238774.post8167531865934859972..comments2024-03-11T05:16:11.252-07:00Comments on Excel_Geek...I'll Do That in Excel for $50: 2011-12 College Football Bowl Pool SpreadsheetExcel_Geekhttp://www.blogger.com/profile/15299063299312360136noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-11238774.post-14975463209625898432011-12-22T16:11:22.400-08:002011-12-22T16:11:22.400-08:00I'll assume you have Excel 2007 or 2010. Save ...I'll assume you have Excel 2007 or 2010. Save it as either .xls ('97 compatible) or .xlsx (2007+ non-macro-enabled). That warning is nothing to worry about.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-25244040293406560732011-12-22T16:05:23.512-08:002011-12-22T16:05:23.512-08:00I added all the info to the master sheet i needed ...I added all the info to the master sheet i needed to and tried to save and it says that some things might be changed etc etc. what file type do i save this in? Thanks again Excel Geek this is amazing!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-19650775036591563502011-12-14T17:16:18.688-08:002011-12-14T17:16:18.688-08:00Unhide column A...Unhide column A...Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-43567399762509874162011-12-14T17:15:42.378-08:002011-12-14T17:15:42.378-08:00Injure column A on the picks page and change all t...Injure column A on the picks page and change all the numbers to 1s.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-25868340692518691122011-12-14T16:57:05.682-08:002011-12-14T16:57:05.682-08:00I am not using confidence points and all games are...I am not using confidence points and all games are worth 1 point. How do I change the maximum points possible to provide a better graph?zcubednoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-31497296136921820522011-12-12T12:49:16.094-08:002011-12-12T12:49:16.094-08:00Hi,
I was having trouble pasting the picks from th...Hi,<br />I was having trouble pasting the picks from the bowl entry from into the master file. Can anyone help with the proper way to do this. Would be so much easier. Thanks.keith addishttps://www.blogger.com/profile/13582579317050004817noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-74191048215207580212011-12-11T15:34:41.572-08:002011-12-11T15:34:41.572-08:00Hey, thanks for this! My wife's stepdad has ru...Hey, thanks for this! My wife's stepdad has run a bowl pool for years, and has always done everything by hand. Now, he doesn't have to! You have done a GREAT job on this.Unknownhttps://www.blogger.com/profile/15974829404258637888noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-52525283474047668022011-12-09T11:26:43.505-08:002011-12-09T11:26:43.505-08:00And so it begins...this is what happens every year...And so it begins...this is what happens every year, and every year i feel like the grumpy old Excel_Geek because I cannot possibly make every variant of a bowl pool that every other person wants. The short answer is that Excel can probably do what you're envisioning, and you're welcome to try to modify the sheet how you see fit. The sheets are protected, but not password protected. Simply unprotect them and start banging away at it. You might learn something.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-61581814798889206902011-12-09T09:14:16.480-08:002011-12-09T09:14:16.480-08:00Is there to make this weighted from only 1 to 10 p...Is there to make this weighted from only 1 to 10 points on each game but if you lose those points wagered get subtracted from your total?R1https://www.blogger.com/profile/13129963732230901262noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-38967481307331308472011-12-09T08:57:56.970-08:002011-12-09T08:57:56.970-08:00How would I or could I adjust your summary spreads...How would I or could I adjust your summary spreadsheet for a 20 game bowl pool instead of 35 games? Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-76928031445970389842011-12-09T04:56:49.959-08:002011-12-09T04:56:49.959-08:00Agrees-with-JMorein, just contact me at ehunzeker ...Agrees-with-JMorein, just contact me at ehunzeker (at) gmail /dot/ c o m and I can make that happen.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-71498017982225805782011-12-08T21:16:41.154-08:002011-12-08T21:16:41.154-08:00Yes, I agree with J Morein. I may have more than ...Yes, I agree with J Morein. I may have more than 40 players interested and would be willing to share the cost to add additional players to the 4 worksheets.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-69614852856115817992011-12-06T12:18:44.685-08:002011-12-06T12:18:44.685-08:00Thank you so much for putting this together! This ...Thank you so much for putting this together! This is the best spreadsheet I have ever seen. I do have one question is there an easy way to add more participants and the spreadsheet still function? Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-9713874170269096942011-12-06T12:02:33.505-08:002011-12-06T12:02:33.505-08:00I am looking to get the spreadsheet expanded to in...I am looking to get the spreadsheet expanded to include more participants. Since I don't make any money off of our pool and don't really want to spend $50 of my own to get it done. I was wondering if anyone else was interested in doing the same? We could possible share the cost between a few people. If you are interested let the Excel-Geek know. They will contact me. Thanks!jmoreinhttps://www.blogger.com/profile/17361206758528181259noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-8088621871280970682011-12-05T21:52:05.905-08:002011-12-05T21:52:05.905-08:00Many thanks for doing this again. This is the 3rd ...Many thanks for doing this again. This is the 3rd year I've used your spreadsheet and it is always lots of fun. Cheers!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-41517062859846505532011-12-05T14:17:08.974-08:002011-12-05T14:17:08.974-08:00Hey! How come nobody told me i had the title to th...Hey! How come nobody told me i had the title to the post wrong!? It was "2010-11 College Football..." instead of "2011-12...". I've got it fix now. @_0Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-17949479497909150322011-12-05T10:17:06.230-08:002011-12-05T10:17:06.230-08:00Will, if anyone wants to donate for the effort, yo...Will, if anyone wants to donate for the effort, you can always send money to my Payal account, which uses my email: ehunzeker {at} g m a i l [dot] com. I'd also like to say that doing so, while very nice and appreciated, is totally unnecessary. This really is a labor of love for me each year.Excel_Geekhttps://www.blogger.com/profile/15299063299312360136noreply@blogger.comtag:blogger.com,1999:blog-11238774.post-70629753720488097572011-12-05T08:37:24.407-08:002011-12-05T08:37:24.407-08:00Thanks so much for putting this together. It is p...Thanks so much for putting this together. It is perfect! Have used it last three years and will always come back as long as you keep doing it.Ronald Durbinnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-91594209301270640482011-12-05T08:36:00.117-08:002011-12-05T08:36:00.117-08:00Thank you so much for putting this together every ...Thank you so much for putting this together every year. I can honestly say that it is perfect. Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11238774.post-82317621572262240922011-12-05T08:24:08.362-08:002011-12-05T08:24:08.362-08:00is there a way to donate a couple bucks for the ef...is there a way to donate a couple bucks for the effort?Willhttps://www.blogger.com/profile/06456431331659336269noreply@blogger.com