Tuesday, September 30, 2014

Back to Football: Week Four Return

What's up Kansas City! My long lost, estranged boyfriend threw 13 touchdown passes yesterday to beat the apparently pathetic Patriots 41-14 last night.

I've updated my potential earning calculations to only pay out $4 for successfully picking the 'favorite' to win and $7 to pick the 'upset.' After running my numbers, I realized that bookies actually have to make money on taking bets. These new numbers, when applied to the 2012 season, create the following numbers.

0%-$2-13%-$2119%$144-20%-$325.
FavoriteUpsetGutIdeal
Always betting on the 'Favorite' for every game would nearly mean you break even. Betting on the 'Upset' would cost you $211, and betting on teams I liked would have been the worst of all. The next addition to my calculation will probably be a column where I define the 'odds' and increase the payout for a successful 'Upset' pick by that number. Perhaps it could be the difference in wins between the teams.
I also added some conditional formatting to indicate which teams were Good, Bad, and Mediocre in 2013. This should help me make better picks, unless it doesn't. 

Sunday, September 28, 2014

Back to Football: Week Four Later

Football watching with other people was good. We had tons of food and could talk about the teams.

Here is the table for this week with some annotations about what is in each cell and some of the calculations going on. In addition to what goes on here, the numbers are also captured in two different charts that track the average accuracy of each type of pick and potential earnings over an entire season. If a team appears in the 'Win' column on a particular week, that information is logged in the 'Master' sheet for the appropriate week so the 'V Ws' and 'H Ws' columns display the updated Wins for those teams next week. Ties will be considered to be a half win and half loss and will have to be entered manually as needed.
  • Ranks picks the Home team (H) if their Wins (Ws) are greater than or equal to those of the Visitor (V).
  • Gut is subjective - based on who I think (or just feel, in my gut) will win.
  • Ideal is determined by the ordering of teams in the 'Master' sheet based on how much I "like" the team.

ROI for Weeks 1-3 on my Gut picks.
13 games were played this week and 47 games played in Weeks 1-3.

This is where I do the betting calculation. The percent is the ROI for this week only.
$53.0047Correct789-$1$18$30$46
19%13Percent54%62%69%-1%23%38%59%
VHWinV WsH WsRanksGutIdealFav. $Upset $Gut $Ideal $
NYGWASNYG11WAS0NYG1NYG1-$6$10$10$10
CARBALBAL22BAL1CAR0CAR0$5-$6-$6-$6
GBCHIGB12CHI0GB1GB1-$6$10$10$10
BUFHOUHOU22HOU1HOU1HOU1$5-$6$5$5
TENINDIND11IND1IND1IND1$5-$6$5$5
DETNYJDET21DET1DET1DET1$5-$6$5$5
MIAOAKMIA10MIA1OAK0OAK0$5-$6-$6-$6
TBPITTB02PIT0PIT0TB1-$6$10-$6$10
JAXSDSD02SD1SD1SD1$5-$6$5$5
ATLMINMIN21ATL0ATL0MIN1-$6$10-$6$10
PHISFSF31PHI0SF1SF1-$6$10$10$10
NODALDAL12DAL1NO0NO0$5-$6-$6-$6
NEKCKC21NE0KC1NE0-$6$10$10-$6
The numbers indicate how many wins the Visitor and Home teams have prior to these games, as logged in the 'Master' sheet. This identifies the favorite, but early in the season, it's not real reliable. The colors identify the team as 'Good', 'Mediocre', or 'Bad'. 
If the team identified in these columns matches the team in the Win column, a 1 is marked in the adjacent numbered column. The Correct number is the sum of that numbered column. That is divided by the number of games played this week to get the Percent.

Regardless of whether Kansas City wins tomorrow, I'll be more than 50% correct this week. Here is a detailed break-down of my decisions for Gut picks and my reaction to the results.
  • The Giants annihilated that Washington team on Thursday, which put a smile on my face, certainly. Despite their similar record and that Home Field advantage, the Giants are just a better team. 
  • I originally picked Baltimore for their game with Carolina, but decided to make what turned out to be the wrong decision for my Gut pick. I'm definitely sure that I was underestimating Baltimore. The Vashda Nerada of the NFL deserves a little more respect. 
  • Early in the week, I had a crisis of faith about the Packer game in Chicago, especially after our loss to Detroit. However, I made the decision that regardless of other factors, I'm just going with Green Bay for my pick. I'd rather be completely happy about a Packer win and completely sad about their loss. 
  • The Texans got it done in a nailbiter, thank goodness. I believe that Buffalo's early wins were to weaker teams and gave the advantage to Houston. 
  • I seem to remember that the Colts blew some other team out of the water last week and the Titans got blown out of the water themselves last week, so IND was an easy and obvious choice. 
  • Detroit beat the Packers, who beat the Jets, ergo, Detroit would beat the Jets. This came to pass. 
  • So Oakland sucks - everyone knows this - but Miami also sucks these days. I figured that, being at the Coliseum, Oakland had a good chance of pulling through and getting themselves a win. Unfortunately, I had no idea that the game would be in -*--ing London this week, where Miami kicked some Raider ass. 
  • Pittsburgh was an obvious choice again, and after four failed attempts to overcome a 4-point deficit with less than 2 minutes to go at the end of the game, I figured that TB would have one more loss. Something happened - I'm in, perhaps, too much shock to really investigate it - and Tampa Bay didn't lose. I still don't get it, but it apparently happened. 
  • With Jacksonville at San Diego, I picked the Bolts and the Bolts won. Easy peasy, lemon squeezy.
  • Atlanta is a consistently good team and Minnesota is a mixed bag, so I went with Atlanta (because I had no idea that they went 4-12 last year - oops). However, our Scandinavian friends prevailed in the end, which was far less disappointing than my previous wrong picks. 
  • I learned that, despite the difference in current records, SF winning this week was not that much of an upset, but that game was certainly stressful. The 49ers consistently look like shit, but they are also capable of pulling off plays that end up looking like artwork. Some of those plays are half crap - a shit throw from Mr. Arm Tattoo that ends in a brilliant catch for a first down - and some are picture perfect. 
  • I also underestimated Dallas this year, but I'm certainly not alone. It could be the Fort Worth magic, it could be that New Orleans isn't as good as it used to be, but I called the game before the half. This was another disappointment, but it wasn't very shocking.
  • As it happens, Alex Smith went to the Kansas City Insinuation-that-Native-Americans-only-exist-in-the-past, which won't improve their ranking in my Ideal teams, but will make me more likely to pick them. They are playing New England, but in Kansas City, so I'm going to take a risk and predict a KC win. 

Back to Football: Week Four

Today is the first day since the first game of the season that I have actually turned on my TV and tuned into a game. It also turns out that I have the NFL Network so I can toggle back and forth between the BUF at HOU game and highlights from all current games as necessary. FOX isn't playing any games right now, which doesn't make any sense. Even if Houston is playing on one network, that doesn't mean that the Houston market doesn't care about the NFC games going on. Or maybe it does - I haven't done the research, but I do see a lot of Texans memorabilia around here.

I've also made significant updates to my 2014 Football chart over the last week. Along with analysis of whether the favorite, my picked, or my ideal team wins on a given week and the accuracy of these predictors through a season, I have identified potential earnings (or loss) for picking the favorite, the upset, my gut pick, or my ideal team on a given week and through an entire season. I did a little research about sports betting and made a simplistic, but relatively accurate calculation for winnings.
Each bet costs $6, and if the pick is wrong, I lose that. If I pick the Favorite and that team wins, I get the $6 back and another $5. If I pick an upset and the Favorite loses, I get the $6 back and another $10.
If the home team's number of wins this season is greater than or equal to the visiting team's wins, it is considered the favorite. 
 I picked these numbers based on information that said that if there is no favorite, to win $100 on a straight bet, you need to bet $110. Sports betting is more complicated than I thought it was, so I need to do more research. This calculation will work for now, and I'll refine it as a I learn more.

Now that the 2014 workbook is in order, I decided to update the 2012 workbook. This would give me two years as data-points. The information I'm looking for is if it is more profitable to simply pick the favorites or upsets consistently than to go with my gut picks.
As of Week 3, with my current calculation, I would have lost $18 by picking the Favorites. If I picked my Ideal teams, I would have made $42, my Gut picks would have got me $53, and picking Upsets would have earned $86 on the season. That's an ROI of -6%, 15%, 19%, and 30%, respectively, on the season. 
So there is that. Then, on the NFL Network, there was much excitement over some youth league running through the banner at the opening of the game, but all I could see were the girls looking bored in their cheerleader uniforms and all I could think about was the gender segregation. I wrote about it on Facebook and included my opinions about whether Cheerleading is a sport (spoiler, I don't think it is).
Post: When your little boys are playing a sport and your little girls are the cheerleaders, children learn that men act and women react to that. When they see men playing a sport and women as the cheerleaders, they see that men are supposed to act and women are supposed to react to that.
We can't change society in an instant, though we are, in many ways, moving in the right direction, but we need to pay attention to what our kids see, hear, and what we encourage them to do.
[My] Comment 1: I have a lot of respect for cheerleading - my high school cheer & stunt team brought home several high profile championships and were really fun to watch - but it should not be considered a sport in terms of Title IX. Yes, it can be competitive, but so is Debate, and things like Band competitions, and neither are considered sports. Cheerleading is much more like performance art than sport.
Of course, that also brings up questions about figure skating and gymnastics, which are also more like performance arts than sports. I do need to do more research about the definition of sport to have a fully crafted argument to back up my current opinion. Right now, I consider a sport to be something that involves direct competition rather than being ranked based on a rating of your performance and skill. 
[My] Comment 2: I know that intended, stated purpose of pairing cheerleading with football is to provide a way to get girls involved, but the result (which is often also the unstated intent) is regressive. In the first place, children should not be playing tackle football, and for two, we need to grow up and work on desegregating this game. 
I've gotten some likes for the Post and on Comment 1 from women without children so far. No dialog yet though. I'd really like to hear from parents, since they're the ones that I am really talking to in the Post. But now, right now, at 1:41pm Central time, I believe that I am late to go to a friend's house and watch football with other people. More later.

Saturday, September 20, 2014

Back to Football: Week Three

Last week, I spent copious time working on my 2014 spreadsheet, which now connects everywhere. I just have to input my picks, then record the winners, and everything gets updated.

The 2014 Season Spreadsheet

Spending time with my spreadsheet instead of watching people babble about football means that my picks last week were pretty bad - 40%. I asked a few people this weekend about their thoughts and learned that Denver looks good for the Super Bowl, the AFC West is the strongest division, the Panthers may surprise everyone, and people have figured the Seahawks out.

I'm still gunning for a Houston-Cincinnati Super Bowl, with Houston winning. The Bengals could pull it out, however, but only if Esiason comes out of the announcers' booth and kicks a game-winning field goal.

Allegedly, this would never happen, but as the Ancient Oracle of Football, I must point out that they are both undefeated this year. As it turns out, the Texans are in the AFC, so it really couldn't happen. Oh well.

I successfully picked Atlanta for the Thursday game, but I'm sure everyone saw that coming. This week, the winners will win and the losers will lose, unless the losers play each other, in which case, who cares? They're losers. 
I miss Alex Smith


Thursday, September 4, 2014

Back to Football: PACKERS!

I was sitting at Tacos, seeing a few Packers posts on Facebook, so I asked, "Packers?" and a friend responded with, "Packers!!"

Indeed, Packers.



So I went home before the game began, but chatted with some guys outside a nearby addiction recovery center. A somewhat bitter 49ers fan explained that the Seahawks were "young killers" who were both "deadly" and "hungry".

I got home in time to see the opener and my absolute new favorite part of the game - the rosters. I listen for two things: players from OSU saying the all important definite article before their college name and strange things. Russell Wilson is from "a whole pack of badgers" and, I believe, Sam Shields, is from "The U".

First and 10 at the 2 minute warning of the first half, and I think the Seahawks will win. The young killers are just hungrier. Time to reprise my old spreadsheet.

Just checking in to say that I heard one of the commentators say "ameoba this".