tag:blogger.com,1999:blog-8248602997859916869.post2516052592910867079..comments2015-09-07T19:00:51.081-04:00Comments on Mathlete's Revenge: NFL Football Weekly Pool Pick Em Spreadsheet Masterpiece - 2011Mikehttp://www.blogger.com/profile/13360530423646515256noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-8248602997859916869.post-37344793743474621532015-06-16T02:30:20.210-04:002015-06-16T02:30:20.210-04:00Spread love everywhere you go. Let no one ever com...<a href="http://www.ufgop.org/pdf/Spread" rel="nofollow">Spread</a> love everywhere you go. Let no one ever come to you without leaving happier. #motherteresa. See the link below for more info. <br /><br /><br />#spread <br />www.ufgop.orgAnonymoushttps://www.blogger.com/profile/07720547920308398294noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-32534399021837070572013-08-02T12:41:34.107-04:002013-08-02T12:41:34.107-04:00I’m not that much of a internet reader to be hones...I’m not that much of a internet reader to be honest but your sites really nice, keep it up!<br />I'll go ahead and bookmark your site to come back in the future. Many thanks<br /><br />my homepage - <a href="http://www.kidantidrug.org/modules.php?name=Your_Account&op=userinfo&username=ShayDelat" rel="nofollow">Amino Prime Reviews</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-47368985160937870412012-09-24T15:13:36.247-04:002012-09-24T15:13:36.247-04:00Thanks, Anonymous.
Click the Spreadsheets tab at ...Thanks, Anonymous.<br /><br />Click the Spreadsheets tab at the top of this blog and you'll find 2012 spreadsheets! That's where I post the new sheets each year.<br /><br />I have not incorporated the assigning points but I've played in a format like that. I'll have to give that feature some thought.<br /><br />~MikeMikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-66041698866762051142012-09-24T15:07:20.819-04:002012-09-24T15:07:20.819-04:00Hi Mike: Yhis is freekin aswsome!!Do you have thi...Hi Mike: Yhis is freekin aswsome!!Do you have this available for the 2012 NFL season? Also, I am in a league where you must assign points to each game (1-16 based on how many games are played that week, of course if there was a bye that week it would be 1-15 or 1-14, etc.? Let me know. Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-52233606614097768152011-10-17T22:30:30.335-04:002011-10-17T22:30:30.335-04:00Best comment ever! :-)Best comment ever! :-)Mikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-75907140193528898292011-10-16T22:29:44.081-04:002011-10-16T22:29:44.081-04:00Well done - I like the color scheme. I've don...Well done - I like the color scheme. I've done a few spreadsheet in my day but never have the patience to make them look as attractive as this one.<br /><br />Yes I realize I just implied your spreadsheet is attractive ;)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-25822781934326180332011-09-07T14:05:04.235-04:002011-09-07T14:05:04.235-04:00I had this last year and was looking for it, was g...I had this last year and was looking for it, was getting ready to look into tapscan to hunt you down, LOL. So relieved i found it for my hubby.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-63208644816154464622011-09-01T00:21:15.709-04:002011-09-01T00:21:15.709-04:00Sorry, you're correct and this is not designed...Sorry, you're correct and this is not designed for tracking multiple pickers on one sheet. It's really designed for the individual. Sites like Yahoo Fantasy does host Pick Em leagues for free, and it would track everyone. ~MikeMikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-73229653852041596762011-08-31T23:17:15.634-04:002011-08-31T23:17:15.634-04:00So this is not designed to enter multiple pickers ...So this is not designed to enter multiple pickers on one sheet?<br /><br />I have 3 people at work that want in on this and I want to have them all on the same spreadsheet...<br /><br />Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-8095112226956274322010-10-16T06:26:09.297-04:002010-10-16T06:26:09.297-04:00Thanks for posting such a good information. I was ...Thanks for posting such a good information. I was looking for that type of information but didn't find.nfl poolshttp://www.bestdamnpools.comnoreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-56915380169256917112009-10-19T00:25:09.460-04:002009-10-19T00:25:09.460-04:00Thanks again, Josh. I play in non-spread pools and...Thanks again, Josh. I play in non-spread pools and hadn't considered the spread pools. I've posted a spread version on Media Fire and added a link to this post above. Let me know if it works for you!<br /><br />MikeMikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-62916327458273332712009-10-18T20:52:51.318-04:002009-10-18T20:52:51.318-04:00Aw snap! It does not take the spread into account....Aw snap! It does not take the spread into account. I should have mentioned that. I track the spread for who is favored by how many points. I'm sure I could update the formulas to account for spread. I'll post a new spread-based sheet this week.<br /><br />Thanks!<br />MikeMikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-44559949509690581162009-10-18T15:01:26.030-04:002009-10-18T15:01:26.030-04:00So, the function is not taking into account the sp...So, the function is not taking into account the spread??Josh C Fullerhttps://www.blogger.com/profile/13519204943245546824noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-70863954908885016822009-10-18T09:57:33.983-04:002009-10-18T09:57:33.983-04:00Thanks, Josh! The first version had a glitch and I...Thanks, Josh! The first version had a glitch and I uploaded a second "-Corrected" XLS. It's been working fine for me.<br /><br />Here's how it's designed: To pick the away team, copy the block with a dot in Column C. To pick the home team, copy the block with a to in Column G. You can actually use any character - I'm just checking to see if Column C or G is blank. For this to work, your choice column needs a character in it, and the other needs to be blank.<br /><br />In Column A, I compare the scores based on which team you picked (Column C or Column G). If you picked Away (character in Column C), and Column E> Column I, you get a check. Otherwise it stays X.<br /><br /><br />If you picked home (character in Column G), and Column I > Column Eyou get a checkmark. To pick the home team, copy the block with a dot in Column G. If the score in Column E < score in Column I, you get the checkmark.<br /><br />Column M gives a "1" for checkmarks. Top left corner gets total results from totals in Columns M & N.<br /><br />I'm sure there are better ways to do this. I'm a hack so this logic worked for me. :-). You can send me your spreadsheet and I can look at it too. Or you might want to start with a clean (-Corrected) one and see if that works.<br /><br />Good luck!<br />MikeMikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-36887279992294976372009-10-18T03:11:03.881-04:002009-10-18T03:11:03.881-04:00This spreadsheet is awesome!! I did run across a g...This spreadsheet is awesome!! I did run across a glitch maybe. Some of the picks I made were wrong but they are still showing up as correct, and vis versa. Let me know if you have any thoughts.Josh C Fullerhttps://www.blogger.com/profile/13519204943245546824noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-85669174172104509712009-09-18T12:13:40.224-04:002009-09-18T12:13:40.224-04:00Thanks, Daniel! If the away team is favored, I jus...Thanks, Daniel! If the away team is favored, I just enter the spread and it shows as positive. If the home team is favored, I include the dash to make it negative number for the spread. For example, this week Atlanta is favored over Carolina by 6 points, so I entered -6. I get my odds from this site every week: http://www.sportingnews.com/nfl/odds.<br /><br />Good luck!Mikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-51206142346047714042009-09-18T12:08:24.051-04:002009-09-18T12:08:24.051-04:00Very Nice! How do we get the odds column to work.Very Nice! How do we get the odds column to work.Unknownhttps://www.blogger.com/profile/08365320236741861703noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-88049257044289425212009-09-13T08:41:05.177-04:002009-09-13T08:41:05.177-04:00You're quite welcome, Teddy. I appreciate your...You're quite welcome, Teddy. I appreciate your note! :-)<br /><br />~MikeMikehttps://www.blogger.com/profile/13360530423646515256noreply@blogger.comtag:blogger.com,1999:blog-8248602997859916869.post-71950686687677350692009-09-12T20:37:44.183-04:002009-09-12T20:37:44.183-04:00This is a great spreadsheet. Thanks for making it...This is a great spreadsheet. Thanks for making it available on the internetUnknownhttps://www.blogger.com/profile/04642181456239704708noreply@blogger.com