TPE Tracker Player Sheet
1- Create a new Google Spreadsheet
2- Click on Tools -> Script Editor
3- Click Create script for Spreadsheet
4- Delete the placeholder content and paste the code from this script.
5- Rename the script to ImportJSON.gs and click the save button.
6- Back in the spreadsheet, select the cell A:1 and paste =ImportJSON("http://tpetracker.herokuapp.com/players_json")
Following these steps will create a sheet that imports all the players from the TPE Tracker and it will automatically update everytime you open the sheet. Feel free to ignore the columns J and K (Tpehistorylist First and Tpehistorylist Second). Also for some reason this script duplicates the last player a bunch of times so you will have to manually remove those rows.
Index Stats Sheet
I wrote a tool that parses the game pages on the index and creates a csv file containing all the stats. The following sheet is for S18 stats(regular season + playoffs (including 2 wildcard games)). If you want stats for another season or DSFL or only for playoffs or whatever, feel free to dm me on Discord.
https://docs.google.com/spreadsheets/d/1vZ2...BCN7w5WJtMv9gkQ
1- Create a new Google Spreadsheet
2- Click on Tools -> Script Editor
3- Click Create script for Spreadsheet
4- Delete the placeholder content and paste the code from this script.
5- Rename the script to ImportJSON.gs and click the save button.
6- Back in the spreadsheet, select the cell A:1 and paste =ImportJSON("http://tpetracker.herokuapp.com/players_json")
Following these steps will create a sheet that imports all the players from the TPE Tracker and it will automatically update everytime you open the sheet. Feel free to ignore the columns J and K (Tpehistorylist First and Tpehistorylist Second). Also for some reason this script duplicates the last player a bunch of times so you will have to manually remove those rows.
Index Stats Sheet
I wrote a tool that parses the game pages on the index and creates a csv file containing all the stats. The following sheet is for S18 stats(regular season + playoffs (including 2 wildcard games)). If you want stats for another season or DSFL or only for playoffs or whatever, feel free to dm me on Discord.
https://docs.google.com/spreadsheets/d/1vZ2...BCN7w5WJtMv9gkQ