Evan Liu
Member
https://dl.dropboxusercontent.com/u/16017198/Ranker.exe
This program, coded by my friend Asa Kaplan (minime12358 on the forums), allows you to choose different combinations of events to sum and rank all competitors by (e.g. all BLD events, all 3x3 events, 2-7, etc). You will need the WCA export for this program to work, which you can download from here: http://worldcubeassociation.org/results/misc/export.html, or by clicking the "Download Information" button on the program's GUI. Extract the files from the zip as well. Save the program preferably in the same folder, but anywhere will technically work.
Here is a screenshot of the GUI:
https://dl.dropboxusercontent.com/u/16017198/ranker1.png
The "Output" text box is for the filename you want to give the output. The default file type is .tsv but others may also work. The "Input Directory" text box is for the directory/folder where the relevant export files are located. The default for this is "./", which means the files are in the same folder as the program. If you saved the program in a different location as the files, you'll have to change the input directory. The check boxes are obviously for the event ranks you want to sum. In the screenshot, I've chosen the BLD events. In the upper right hand corner, you can choose either single or average. If you choose average, the check boxes for the events which do not have averages will disappear. They will reappear if you choose single again. "Output full names" means names instead of WCA IDs will be displayed, which I think most prefer. A command prompt window which shows the progress of the program will also open with the GUI itself; do not close it.
Here is a screenshot of part of the output for summing all the BLD event rankings, viewed in Microsoft Excel.
https://dl.dropboxusercontent.com/u/16017198/ranker2.png
Lastly, the most recent version of the export is dated at July 29, so some values will of course be slightly off.
Enjoy, and do report any issues you encounter!
This program, coded by my friend Asa Kaplan (minime12358 on the forums), allows you to choose different combinations of events to sum and rank all competitors by (e.g. all BLD events, all 3x3 events, 2-7, etc). You will need the WCA export for this program to work, which you can download from here: http://worldcubeassociation.org/results/misc/export.html, or by clicking the "Download Information" button on the program's GUI. Extract the files from the zip as well. Save the program preferably in the same folder, but anywhere will technically work.
Here is a screenshot of the GUI:
https://dl.dropboxusercontent.com/u/16017198/ranker1.png
The "Output" text box is for the filename you want to give the output. The default file type is .tsv but others may also work. The "Input Directory" text box is for the directory/folder where the relevant export files are located. The default for this is "./", which means the files are in the same folder as the program. If you saved the program in a different location as the files, you'll have to change the input directory. The check boxes are obviously for the event ranks you want to sum. In the screenshot, I've chosen the BLD events. In the upper right hand corner, you can choose either single or average. If you choose average, the check boxes for the events which do not have averages will disappear. They will reappear if you choose single again. "Output full names" means names instead of WCA IDs will be displayed, which I think most prefer. A command prompt window which shows the progress of the program will also open with the GUI itself; do not close it.
Here is a screenshot of part of the output for summing all the BLD event rankings, viewed in Microsoft Excel.
https://dl.dropboxusercontent.com/u/16017198/ranker2.png
Lastly, the most recent version of the export is dated at July 29, so some values will of course be slightly off.
Enjoy, and do report any issues you encounter!