Visualize data, based on Google Spreadsheet csv-output, using MySQL and PHP

Me and my friends play football every week. Now, I want to find a structured way to post rankings on a website, based on a Google Spreadsheet file I am working in. For live examples of similar previous projects, check out [login to view URL] For sources of the csv-data, see below. Using MySQL and PHP, both tables on [login to view URL] are created. Part of this structure can be used for our next projects: FIRST PART OF PROJECT I would like to create a new table, including all players, which tells me how much points per game the concerning players on average (e.g. point divided by matches, or looking at table; P divided by Gs). However, I want to create two columns: one with these statistics for players, and one for goalkeepers. Which guy played goalkeeper each match, is shown in the csv-database with the results. This data need to be structured first, probably using SQL. SECOND PART OF PROJECT In the same table, but two different columns, I would like to show the goal difference of a player showed as an average per 10 minutes - and as a goalkeeper. I assume this will implicate some new SQL-coding. In the original Google Spreadsheet database (result sheet), the total minutes per game is given - this differs per game. For each player, data of player/goalkeeper needs to be separated. Then total goals scored en total goals against need to be summed, both divided by total number of minutes, and then multiplied by ten (since it is per 10 minutes). SOURCES Source (Google Spreadsheet, csv-output) of the result information: [login to view URL] Source (Google Spreadsheet, csv-output) of the event information: [login to view URL]