Spreadsheet: 785605d1656512223-football-league-modelling-formula-to-return-result-of-last-5-games-football-league-modelling-returning-results-of-last-5-games
Sheet: Weekly Data

 |  | MATCH RESULTS
 |  | INPUTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Options:
 |  | Only amend cells in yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Home: | H
 |  |  | 2022-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Away: | A
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | Forfeit: | FF | Forfeit not counted as match played
 |  | Team Home | 11 | 12 | 9 | 10 | 5 | 16 | 11 | 8 | 7 | 8 | 14 | 6 | 20 | 8 | 6 | 15 | 9 | 10 | 15 | 13 | 11 | 15 | 12 | 4
 |  | Team Away | 17 | 12 | 13 | 12 | 6 | 10 | 7 | 10 | 14 | 11 | 13 | 32 | 13 | 20 | 6 | 20 | 4 | 14 | 13 | 8 | 13 | 18 | 10 | 7
 |  | WEEKLY [NAME]
 |  | Player 1 | H | H | FF | H | A | H |  | A | FF | H | A |  |  |  |  |  |  |  |  |  |  |  | A
 |  | Player 2 | H | A | H |  |  |  |  |  | A | H | A | A | H | A |  | H | H | A |  |  | A | H |  | H
 |  | Player 3 | H | H | A |  | H | H |  | A | A |  | H | H |  |  |  |  | H | H | A |  | A |  |  | A
 |  | Player 4 | H | H | H | H |  | FF | A | A |  | H | H | H | H
 |  | Player 5 | H | A | A | A | H | H | H | H | H | A | H | H | H | H |  | A | A | A | FF | H | H | A | H | A
 |  | Player 6 | A | A | A | H | A | H | H | H | H | H |  | H | A | A | A | H | A | A | A | A | H | H | H | A
 |  | Player 7 | A | A | H | A | H | A | A | H |  | A |  | FF | A | H |  |  | H |  | A | H |  | A | H
 |  | Player 8 | A |  |  |  |  | A
 |  | Player 9 | A | H |  | A | A | FF |  |  |  |  |  |  |  |  |  | A | A | H |  |  |  |  | A
 |  | Player 10 | A |  | H | FF |  |  | A |  | A |  |  |  |  |  |  |  |  |  |  |  | H |  |  | A
 |  | Player 11 |  | H | FF | A | A |  | A | H |  | A | FF |  | A | A |  | H |  | H |  | H | H
 |  | Player 12 | FF | A | A |  | A | A | FF | H | H | H | H |  |  |  | H | A | A | A | H | H | A |  |  | H
 |  | Player 13 |  |  | A | H | A |  |  |  | H |  |  |  |  |  |  |  | A |  |  |  |  |  | A | A
 |  | Player 14 |  |  |  | H | H | A |  |  |  |  |  |  |  |  |  |  |  | A | A |  | A | H | A
 |  | Player 15 |  |  |  | H |  |  |  |  |  |  |  |  |  | H | H
 |  | Player 16 |  |  |  | A | H | A | H | A | FF |  | A | A |  |  |  |  |  |  |  | A |  | A
 |  | Player 17 |  |  |  |  |  |  | H |  | A | H | A |  |  |  | H |  |  |  |  | A | A
 |  | Player 18 |  |  |  |  |  | H |  | A | H | A |  | H |  |  |  | H |  | FF | A | A
 |  | Player 19 |  |  |  |  |  |  | H |  | A |  |  | H | A |  |  |  |  |  |  | H | H | A | H
 |  | Player 20 |  |  |  |  |  |  |  |  |  | A | A |  | H | A | H |  | H | H | H |  |  |  | A | H
 |  | Player 21 |  |  |  |  |  |  |  |  |  |  |  |  | A | H | A |  |  | A | A
 |  | Player 22 |  |  |  |  |  |  | FF |  |  |  |  |  | H |  |  |  | H |  | H |  |  |  | A
 |  | Player 23 |  |  |  |  |  |  | A |  | FF | A | H | FF | A | H | FF |  | H | H | H | A |  | H | H | H
 |  | Player 24 |  |  |  |  |  |  |  |  |  |  | A | A
 |  | Player 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | A |  | H | H |  |  | FF
 |  | Total