Re: Last 6 matches home and away soccer form table
In D column We have Home Teams ------- In F column We have Away Teams!!!
So there are many rows which contain Home and Away Teams… on the right of these,
in Q, R, S, T columns, there are some calculations about their results:
“ score or not, under over goals, both teams score… “
I want count in last six occurences, about last six league rounds, like shown in column B, as follows:
How many times a Home Team has scored or not ( column N) … so this for other Q, R, S, T
How many times an Away Team has scored or not ( column O) … so this for other Q, R, S, T
!!!!!!!!!!!!!!! All this about ONLY LAST SIX LEAGUE ROUNDS !!!!!!!!!!!!!!!!!!!!
For example in Italy Serie A league championship, like in column B,
from the first last round, the 19th, until the sixth last round, the 14th round…
by covering and taking always the last six occurences…
Z9: Inter played _4 games in home_ by scoring 4 times, like shown in Z:Z … ( 4 scored Yes)
Z9: Inter played _2 games away_ by scoring only 1 time and not scoring also 1 time ( 1 scored Yes & 1 Not)
By following these rules I want calculate what I explained, about all the observable league teams in Y:Y
In other leagues, expecially English leagues, when I refresh query web about new league championship results, I find postponed or abandoned games of previous league rounds which are replayed.
These replayed games are assorted, mixed to very last 6 played rounds…
According to my ideas They are calculated like lasts by me… and sometimes, by counting last six occurences of a Team, covering last six league rounds, we should find a Team which played also 5 times like Home and only 1 Away.
Hope I’ll be able to be helped,
[Blocked Image: http://i44.tinypic.com/oggm4i.jpg]