Winning Streaks or Loosing Streaks in multi team football schedule

I have been searching for a solution to my problem for quite a long time. I have read other posts from other people with a similar problem however i have not found a way to take theri result and adjust it to fit my own needs.

I have constructed a 5 team football schedule that I will input the final score from every game on a weekly basis and from that my Spreadsheet will compute weather the team won or lost, each teams individual will/loss record, the win/loss record for every game played every week, each teams winning percentage, all 5 teams combined winning percentage, number of games remaining, number of games remaining if said team earns a playoff birth, best possible win/loss record based on their current win/loss record, & worst possible win/loss record based on their current win/loss record.

Now that i have figured out all of that I am wanting to add 4 more formulas to each of my 5 teams.

1. I want to see each teams current winning/loosing streak
2. I want to see each teams current winning/loosing streak for home games
3. I want to see each teams current winning/loosing streak for games away from home (away games and neutral site games, not including playoff games)
4. I want to see each teams current winning/loosing streak for post season games (playoff games)

I have scoured the web trying to find other peoples solutions and turning them into what I need but i have been unable to do that. Winning/loosing streaks seem to be extremely difficult to produce.

Here is a copy of my spreadsheet:

http://dl.dropbox.com/u/13660908/201...ogress%202.xls
(It is also attached below)

Before you download it please note: The only input that is required to make everything work is to simply add the final score for each game (my team on the left and opposing team on the right) everything that I mentioned in the second paragraph of this post is computed automatically.

Please take a look at sheet2 and sheet3 for additional info and what I refer to as "ugly cells" or cells that do a lot of the computing however i choose to keep them out of sight and out of mind. As you can see i am not a huge fan of hiding cells.

Near the bottom of Sheet1 you will see the four locations for the streaks. Until now I have simply figured these manually and would like for these to be computed automatically if possible.