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 dbc33bcb2d4e4fe87019f89e7e32066d351a0f642b3d08ac634e51834e12f606

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 23a428cc94a1f5a4d8d4e8ae9c902d27ab7b7c20164c6d48d97388c0f62a342b

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 2bebbd9df6d7ff9fbdfefa84e254668a6f364fc2244fcf06ef29d983f677b89c

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 7acf508b1652c18dfe612ccac6b868fb9a9b507d398a029bd583d76807907a8e

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 where generated as separate rounds in TNoodle, you can used 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 1ca7c1b8ac10b39efc0e57243fc54d2a00015b444afd0058ed1079dcdf357a79 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 6d0ae73b851059fe908ca8829cb47af1198ed8ff1a31d4f94522a85f747eb27d 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 a6b0e8fed6b6e30ebcede8f46e50e378d2e49888514c8c8269c5c04aef260a78

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 5db51c5ceeb959f9c717eb601077176802989a483799336b208b6aa64c1d1287

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 76e92de9b1df54b323b1608a471ca13a1c49880d9bf6354760a4219cc0cfc863

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 b82ef66bd6406b4d454693af6aad3a7f2df89f01f4589d2566a02b5667a2e2e0

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 2328b947db710c2ad4e725d17405ac25d8f89632c218a745676695c04371ddcd

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

Select competition id dialog 04310094fc99441cc78b18a5b8a3e020361138693e71f45ef7ec50ff4a96726b

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

Select competition id filter b4fb69615ef927b8427953028f33967b39288e8ed8884b00f68b8deb390369ff 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 75f9c2431c5029f52f07b5b7981287d693c8f2bb9b0cc86a16a0a33320897b83

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 94e3b05fd6641d156ed4b5308bd6d0ecb6a25dc382cc8e00ae98531b2037d934

Step 7: Send the results JSON to the WCA

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