WCA Workbook Assistant

Download WCA Workbook Assistant v2.3

Last update: April 07, 2015
(version history)

How to process results and scrambles before submitting them to the WCA

Step 1: Open the workbook with the results

Open the workbook using the Open... button or by dragging the workbook file and dropping it on the application window.

Open workbook

Step 2: Add the TNoodle scrambles

Add the TNoodle scrambles using the Add... button or by dragging the TNoodle file and dropping it on the application window. Make sure you use either the .zip file or the .json file generated by TNoodle.

Add scrambles

You can add multiple scramble files in case the scrambles where generated in parts or extra scrambles had to be generated during the competition.

Scrambles added

Step 3: Match the scrambles with the results

The WCA Workbook Assistant automatically links the scrambles with the rounds that were held. In some cases, like when multiple scramble files were generated, the selection needs to be done manually because there are several possible options.

Manually selecting scrambles can be done by double clicking the Scrambles cell in the sheet overview panel.

Match scrambles

It is only possible to select one round from the scramble files for each round for which there are results. If a situation arises where scrambles for a single round were generated as separate rounds in TNoodle, you can use the Edit groups... button to edit the groups in the scramble files and move them from one round to another or delete them.

Edit groups In this example, an extra set scrambles was generated to have two groups for the first round of skewb instead of one group. Extra group The scrambles for the additional group can be dragged and dropped on the round that was generated originally. This moves the two groups together in one round. Group moved

Step 4: Fix any errors reported by the application

The results are checked for data entry mistakes. Rounds that have errors will be marked with a red icon in the sheet overview panel.

Validation errors

When selecting a sheet with errors in the sheet overview panel, the application will list the details in the validation errors panel on the bottom left.

Validation errors detail

Mistakes can be fixed by opening the workbook in a spreadsheet application and editing and saving it from there. The updated workbook can then be loaded again in the WCA Workbook Assistant by pressing the Refresh button. This will only reload the results but will leave all the other changes you made intact, like the scrambles that were added.

Refresh workbook

Step 5: Select the competition ID

Select the correct competition ID by clicking the Select... button next to the Competition ID field.

Select competition id button

A dialog will show up with a list of competitions to choose from.

Select competition id dialog

You can filter the list by typing a part of the name of the competition or the WCA Delegate.

Select competition id filter To start off with, only competitions that took place less than one week ago or that will take place less than one week in the future will be shown. If you need to select a competition outside of this time window, deselect Only show current competitions. Select competition id show all

Step 6: Export the results data to JSON

Save the results data to a JSON file using the Export results JSON... button on the bottom right.

Export json

Step 7: Send the results JSON to the WCA

E-mail the JSON file exported by the WCA Workbook Assistant to results@worldcubeassociation.org