Microsoft Excel Anyone? 2

So I have been going Excel crazy recently by trying to compile stats, keep score and just record wins and losses over several seasons for teams. So I’m going to focus this for anyone who is some what resourceful with Excel and wants to help me out.

My dilemma is that I have a column that is counting the streak of the said team. For example, let’s say if the team wins 5 in a row, loses 2 in a row and then wins one… the column will say the following:

W1, W2, W3, W4, W5, L1, L2, W1

Now that is a relatively small scope of what i have. I have recorded data of over 130 games so far, and I am trying to figure out a way to automatically calculate what is the longest winning streak, losing streak, etc.

I can provide the Excel sheet if someone wants to give it a try. Any help or suggestions of further stats to determine from the given data would also be greatly appreciated. Just leave your email in the comments or contact me directly and I can send you the file.

The Streak Comes To An End

So it took a month and nearly three weeks (44 games) into the season but my streak came to an abrupt halt this past Saturday when the first game of the Subway Series took place. I had every intention to catch the end of the game because I was scheduled for an Actuary Exam from about 12:30 to 3, which would have left just enough time for me to get back from the test to see the last inning or two. As it turns out, the examination site had a few technical difficulties which had threatened to delay the test to another day – which would have meant my streak was still intact. However, after an hour of just waiting and seeing when I can reschedule or who knows what, they informed me I had to take the test then. Granted, I wasn’t thinking at the time that since the test now began at 1:30 instead of 12:30 and is scheduled to finish at 4:30… there was no way that I would be able to see/hear the game.

As it turned out, I took nearly the entire 3 hours to take the test and as I was walking out of the facility, I still hadn’t gotten a text message telling me a score from the game. I still had hopes that the game might have gone into extreme extra innings that by the time I would get back, somehow someway the game would still be on. That hope however, was quickly dashed when I got a text message telling me that the New York Mets had defeated the New York Yankees by a score of 7 to 4.

Well it was good while it lasted and ironically it comes a day or two before I head off to Norway. At the end of the streak, here is where everything is so far…

36 games on YES (81.82%)
3 games on RADIO (8.82%)
2 games on ESPN (4.55%)
1 game on MLB.TV (2.27%)
1 game on FOX (2.27%)

After catching yesterday’s game, I currently stand at 44 out of 45 games (97.78%) which isn’t all too bad in itself. Hopefully, it’ll stay that high over the course of the year – especially with the next two weeks guaranteed to take a toll on that mark.

As for the Jays, I’m at 31 (67.39%) out of 46 games with 28 of them on MLB.TV (60.87%), 2 on YES (4.35%) and 1 on ESPN (2.17%).

Weekend Forecast

I’m gonna head down to Washington DC for the weekend with a couple of roommates and a friend, hopefully the weather cooperates (like the 70 degrees today for the entire weekend would be nice). We’ll see how that goes. Anyways, so much going on in the world of sports. NHL Playoffs started yesterday, Masters Tournament started today and Yankees/Red Sox weekend series starts tomorrow night. Another hurdle towards the consecutive games streak comes into play tomorrow as I may be on the road during the game but I can always resort that radio although I would like the use that a little as possible.

NHL Playoffs started yesterday and from what I remember correctly my friend Rusty from High School was at the Devils/Rangers game handing out towels and whatnot to the fans in attendance. I haven’t talked to him since the game but I probably will tonight to ask him how it went. I’m sure he would have preferred a Devils victory but it’s only game 1. The Pens on the other hand looked pretty good, albeit it was against the shorthanded Senators who have really been short handed with a string of injuries and especially after their 15-2 start to the season this year. There have been rumors about the Penguins tanking their last game of the season so they secured a series with Ottawa instead of the Flyers and who knows to the truth about that statement but the Senators are really over-matched in this series.

I know some games have already been played but here are my predictions anyways. (more…)

Streak in Jeopardy? 3

So I am currently sitting in my apartment looking at a boxed up television that is packed and ready to be shipped to the Sullivan residence. The package puts a local blackout in effect for any Yankee, Mets and possibly Phillies games so this afternoon’s Yankee game in Kansas City is not looking too promising. So far I am 7 for 7 in the games played this season with the Yankees going 4-3 in that stretch. Royals starting the season well with a 3 game sweet of the Tigers… hopefully they can pull off the same stuff against the Yanks.

I have several scenarios lying on the table right now. I could transport the new TV that is coming into the apartment but that requires carrying an 80 pound set down a block from CPA and then up 5 flights of stairs. Another option is finding some broadcast somewhere to catch an inning or so and the rest on the radio. The last option is to go out somewhere to catch the game and keep my streak alive.

I wonder, does listening to the entire game on the radio qualify as keeping the streak intact? What do you think?

Any other suggestions?

So far it has been an even split on people suggesting listening to the game on the radio counts just as much as watching it on TV while others saying either its just not the same to my initial goal was to “watch” the games.