bfb314159265
New Member
- Joined
- Feb 14, 2011
- Messages
- 4
OK this question might be a little complicated and confusing but I'll do my best...
Basically I have a spreadsheet of soccer goals. This includes the time each goal was scored, the resulting differential in the game from the goal, and the result of the game.
I want to use this data to find winning percentages for every time and goal differential throughout the game. For example, I want to count all the wins losses, and draws for the 33rd minute when the team is up by 2 goals.
Here's an example of one game:
Result---Time1---Diff.---Time2---Diff---Time3---Diff
L---------12------(-1)-----49-------(-2)---87------(-1)
This entry would mean the team lost, gave up goals in the 12 and 49 minute, and scored one in the 87th. Based on this entry I want to add a loss to the minutes 0-11 for differential=0, 12-48 for differential=-1, 49-86 for differential=-2, and 87-90 for differential=-1. I have a bunch of rows of data from games like this and I am looking to do this same process for each game.
After this I can take the record of all the wins, losses, and draws for a certain minute and differential and then calculate the winning percentage.
I know it's a pretty confusing question but thanks for the help in advance.
Basically I have a spreadsheet of soccer goals. This includes the time each goal was scored, the resulting differential in the game from the goal, and the result of the game.
I want to use this data to find winning percentages for every time and goal differential throughout the game. For example, I want to count all the wins losses, and draws for the 33rd minute when the team is up by 2 goals.
Here's an example of one game:
Result---Time1---Diff.---Time2---Diff---Time3---Diff
L---------12------(-1)-----49-------(-2)---87------(-1)
This entry would mean the team lost, gave up goals in the 12 and 49 minute, and scored one in the 87th. Based on this entry I want to add a loss to the minutes 0-11 for differential=0, 12-48 for differential=-1, 49-86 for differential=-2, and 87-90 for differential=-1. I have a bunch of rows of data from games like this and I am looking to do this same process for each game.
After this I can take the record of all the wins, losses, and draws for a certain minute and differential and then calculate the winning percentage.
I know it's a pretty confusing question but thanks for the help in advance.