Note: This is for standard game sheet data, no shot location yet.
There are four outputs that I am looking for.
[x] Goals
[x] Players
[x] Games
[x] Penalties
Other modifications
[x] Remove home team, away team, and rosters from goals sheet
1) GOALS
Summary: a row for each goal scored in the given league. Columns for general description (season, season type, league, game ID, date, home/away team, period, time, scorer, assists) and additional information (score state, strength, situation, on-ice players, in-game players)
Purpose(s): GF%, GF%rel, WOWY and teammate/linemate data
Status: Already more or less complete
2) PLAYERS
Summary: a row for each player in the database. Columns for position, team name, and games played, data gathered from API.
Purpose(s): Need a list of players to begin charting the data from the Goals and Penalties sheet.
Notes: For players that played on multiple teams, only record names once, add additional team names to previous team name, deliminated by slashes. ie., "London Knights/Windsor Spitfires"
3) GAMES
Summary: a row for each game played in the given league. Columns for game ID, date, home/away team, home score, away score, win/loss, in-game players for home/away
Purpose(s): Games played for players, team stats, home/away splits, win/loss splits
Notes: Total time is the length of the game (ie, usually 60 minutes, but sometimes more with OT. Adding the time of the OT goal to 60 minutes should get this settled). 5v5 time is how much time is spent at 5-on-5. Slightly more complicated, requires maneuvering around when penalties were taken and expired and when goals were scored. I believe in you.
4) PENALTIES
Summary: a row for each penalty taken. Columns for game ID, date, player, team, penalty taken, time, manpower situation, score state
Purpose(s): penalty tallies for players for the purposes of counting obstruction type calls, indicative of "chasing the game"
Note: This is for standard game sheet data, no shot location yet.
There are four outputs that I am looking for.
Other modifications
1) GOALS
Summary: a row for each goal scored in the given league. Columns for general description (season, season type, league, game ID, date, home/away team, period, time, scorer, assists) and additional information (score state, strength, situation, on-ice players, in-game players) Purpose(s): GF%, GF%rel, WOWY and teammate/linemate data Status: Already more or less complete
2) PLAYERS
Summary: a row for each player in the database. Columns for position, team name, and games played, data gathered from API. Purpose(s): Need a list of players to begin charting the data from the Goals and Penalties sheet. Notes: For players that played on multiple teams, only record names once, add additional team names to previous team name, deliminated by slashes. ie., "London Knights/Windsor Spitfires"
3) GAMES
Summary: a row for each game played in the given league. Columns for game ID, date, home/away team, home score, away score, win/loss, in-game players for home/away Purpose(s): Games played for players, team stats, home/away splits, win/loss splits Notes: Total time is the length of the game (ie, usually 60 minutes, but sometimes more with OT. Adding the time of the OT goal to 60 minutes should get this settled). 5v5 time is how much time is spent at 5-on-5. Slightly more complicated, requires maneuvering around when penalties were taken and expired and when goals were scored. I believe in you.
4) PENALTIES
Summary: a row for each penalty taken. Columns for game ID, date, player, team, penalty taken, time, manpower situation, score state Purpose(s): penalty tallies for players for the purposes of counting obstruction type calls, indicative of "chasing the game"