chemmiah
New member
- Joined
- Sep 14, 2020
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
[FONT="]Hi all,[/FONT]
[FONT="]
[/FONT]
[FONT="]I am working on a long term pet project of mine of analyzing trends in CFB. I have data in chart form (see attached). In the Scores Tab you will see the scores laid out in tabular form. On the next tab "List", I would like it to calculate what the win percentage of the last 20 games (W/(W+D+L)), but since the team can be in the home or away column i am racking my brain to come up with a efficient way to do so. I am willing to add more columns to the scores table if need be or create unique identifiers.[/FONT]
[FONT="]
[/FONT]
[FONT="]Also, I would like to calculate the current Streak, so if it is a 3 game win streak it would report: W3 or if it was a 2 game draw streak it would report as D2, and so on.....[/FONT]
[FONT="]
[/FONT]
[FONT="]Let me know if this is possible. Thanks![/FONT]
[FONT="]
[/FONT]
[FONT="]I am working on a long term pet project of mine of analyzing trends in CFB. I have data in chart form (see attached). In the Scores Tab you will see the scores laid out in tabular form. On the next tab "List", I would like it to calculate what the win percentage of the last 20 games (W/(W+D+L)), but since the team can be in the home or away column i am racking my brain to come up with a efficient way to do so. I am willing to add more columns to the scores table if need be or create unique identifiers.[/FONT]
[FONT="]
[/FONT]
[FONT="]Also, I would like to calculate the current Streak, so if it is a 3 game win streak it would report: W3 or if it was a 2 game draw streak it would report as D2, and so on.....[/FONT]
[FONT="]
[/FONT]
[FONT="]Let me know if this is possible. Thanks![/FONT]