Hi Alan,
Hope you had a great weekend.
Had a bit of time to go through the sheet and it's excellent.
One scenario I still would be after would be the following. I have attached a spreadsheet with it and the 2 lines in yellow are the two game states I try to differentiate. If I look at the data I see that if a FT result was 2:1 and one team reached once a two goal lead, it never reached draw game state (1:1), how would it be possible to get this data now for many games into a dashboard format. So that it's not necessary to browse manually through x amount of games?
So that it takes all games were team 1 scored the first goal and then tells me how often they scored the 2nd goal or conceded the first goal.
Is it easier if I add a second sheet on how this dashboard would look or do you have an idea in mind?
Thanks,
Alex
Bookmarks