You need to have a file called "icpcgp.xlsx" in the same folder as the script (File name can be edited in line 81). The format of which can be seen in the sample file attached. Running the script generates a csv File which contains the following modifications:
- A column which contains the rank of the team (sorted according to team rating).
- Each member of the team has a corresponding html code which assignes color and title to the member according to max rating.
- A column which contains the team ratings with html code to assign the corresponding color and title.
The generated csv file can be converted into a table supported by Codeforces latex through the following link: https://www.tablesgenerator.com/markdown_tables