Quick Working Stats

While there is some down time at work, I pulled up a file I created when I started work here which has been breaking down the data of how much I am working and when. By no means am I complaining of the hours I work because the things I have learned so far and people I get to work with have taught me a tremendous amount in a very short time span but I am a math major and we do these types of things so here is a quick snapshot:

Time In Time Out Avg/Day Avg/Week
Jul-10 8:33 17:06 8:32 42:42
Aug-10 8:09 17:40 9:30 47:33
Sep-10 8:10 17:31 9:21 46:46
Oct-10 8:12 18:15 10:03 50:15
Nov-10 8:09 18:07 9:57 49:49
Dec-10 8:10 17:21 9:10 45:53
Jan-11 8:09 18:15 10:06 50:30
Time In Time Out Avg/Day Avg/Week
Q3 2010 8:17 17:26 9:08 45:41
Q4 2010 8:10 17:54 9:43 48:37
Q1 2011 8:09 18:15 10:06 50:30

Just interesting to note that following the very first month, the time that I can into work got pulled back half an hour and the time I left pushed forward one half. A fantastic start for January so far and we’re barely half way through since I was here unexpectedly until almost 10PM last week which did well to push that average up near record levels although I don’t think (and hope) it won’t sustain during the next two weeks as lots of things are progressing steadily.

The end of December was kind of nice with people going on vacation and not a lot of things on my plate before the year but I still averaged leaving at pretty high 5:21PM leave time given those numbers includes a 1:30PM, 2:00PM and 3:00PM dismissal in consecutive weeks leading up to the new year.

Monday 9:40
Tuesday 9:17
Wednesday 9:49
Thursday 9:23
Friday 9:19

One surprising note was that initially hit me what that Friday HAD to be the day which I worked the longest but the average per day just didn’t show that. It just turns out that if I take away those “early dismissal” prior to long weekends, the Friday average jumps a whole 41 minutes to 10 hours per every Friday which includes a 13+ hour day this past Friday.

With that, I’m off to lunch.

Random Stats

Just some random stats as I approach lunch time on a day where I have been reading the BioCommand User Manual pretty much the entire morning.

I have had 166 total posts now, and here is the categorical breakdown so far.

ABG 13
Grab Bag 36
Math 4
Politics 41
Sports 83
Stevens 10
Video Games 5

As for tags, you can always notice the tag cloud in the right sidebar but here are some numbers on there.

Obama leads the way with 25 tags followed by my two favorite topics in the world of Clinton and Yankees with 13 each. The Giants with their remarkable Super Bowl run have a total of 12 and ESPN with 8 tags rounds off the top 5.

Interesting tags that appear in the top 40 or so are Super Tuesday with 5 (didn’t know I wrote so much about that day), Patriots and March Madness with 7 and 6 each.

Referrals regarding material from friends surprisingly enough comes out even at 4 a piece for 4 different people – Cindy, Joe, Krishna and Rusty.

Okay Lunch Time… I’m out.

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.