+- International Simulation Football League (https://forums.sim-football.com)
+-- Forum: Community (https://forums.sim-football.com/forumdisplay.php?fid=5)
+--- Forum: Discussion (https://forums.sim-football.com/forumdisplay.php?fid=33)
+--- Thread: Spreadsheets (/showthread.php?tid=16820)
Spreadsheets - Eco - 12-03-2019
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
Spreadsheets - majesiu - 12-03-2019
Nice job, having data in json format is so much better for stuff like discord bots than scrapping it directly from the web page. The index stat sheet could be a prelude for real career indexes too.
Spreadsheets - 37thchamber - 12-03-2019
(12-03-2019, 08:29 AM)Eco Wrote:I wrote a tool that parses the game pages on the index and creates a csv file containing all the stats.I am going to abuse this like a redheaded, middle step child.
Spreadsheets - Eco - 12-12-2019
S19 Stats
https://docs.google.com/spreadsheets/d/1okP...9T-3MHGhU6OKyq4
Spreadsheets - Eco - 01-02-2020
S19 Total Stats (Season + Playoffs)
NSFL: https://drive.google.com/open?id=1okP0l4cD-...9T-3MHGhU6OKyq4
DSFL: https://drive.google.com/open?id=1A9No37Pqn...vQRTXxRFNUQKi2U