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.