Build Up Excel File For Portuguese Soccer League?

I am trying to build up an excel file for the Portuguese Soccer League.

It has 18 teams.

Problem 1:

I already figured out a way for the untie criteria to be used during the regular season, that is, for the first 33 days (rounds) - criteria d) to f).

d) Biggest difference between Goals For and Goals Against on all the games they have played;

e) Most wins on all the games they have played;

f) Most Goals For on all the games they have played.

For the last round (34th round), the criteria are more complex. They include the first three criteria that concern the games played between the tied teams.

a) The most points won by the tied teams on the games played between each other;

b) The biggest difference between Goals For and Goals Against between the clubs that are tied on the games they have played between each other;

c) The most goals scored on the away games on the games the tied teams played between each other;

To summarize:

- For the day-to-day standings the criteria that applies is d) to f).

- For the final standingsthe criteria that applies is a) to f).

Problem 2:

I created a sheet named "Evolution" from which I want to extract streaks information: for example current streak, longest win streak, longest draw streak, longest loss streak, longest non-winning streak, longest non-losing streak if possible for home, away and global games.