WCA Workbook Assistant versions

Release Notes

Improvement #116
Add support for multiple attempts and groups of multiple blindfolded. See more information here.

Improvement #108
Low severity warning for competitors without WCA IDs who match someone's name and country in the database. Low severity warning also given for competitors who are younger than 5 or older than 90.

Bug fix #107
The database export download now uses HTTPS, as required by the WCA website.

Improvement #67
The validation now checks for common mistakes in the spelling of names.
Improvement #68
The validation now checks that the naming of the rounds is in line with the naming used on the WCA website.
Improvement #94
Database exports that became corrupted while downloading are handled better and are simply ignored.
Improvement #95
The JSON export has been simplified by removing the JSON preview window.
Improvement #96
The name of the exported JSON file now starts with "Results for " so that it does not get mixed up with the TNoodle scrambles.
Bug fix #97
The validation now checks that the country entered for new members exists in the WCA database.
Improvement #99
The validation now checks that the times of multiple blindfolded results are reasonable.
Improvement #100
The competition ID can now be selected from a list of recent competitions instead of having to enter it manually.
Improvement #101
The ISO country codes are now retrieved from the WCA database export instead of separate resource file.

Improvement/bug fix #69, #73, #74, #75, #76, #77, #79, #80 and #92
TNoodle scrambles can be attached to the results.
Improvement/bug fix #48, #70, #72, #88 and #89
Exporting results to JSON is now the main output format and follows version 0.2 of the competition JSON exchange format.
Improvement #40 and #90
The validation and now checks that cutoff rounds are actually combined.
Improvement #87
All file choosers start from the same working directory.

Bug fix #66
Means of 3 for 3x3x3 blindfolded are now calculated correctly if there are less than 3 results.

Improvement #61
Skewb is now recognized as an event.
Improvement #62
The validation now checks that 1 solved cube out of 2 tried cubes is a DNF for multiple blindfolded.
Improvement #63
Mean of 3 rounds for FMC are now handled correctly.
Improvement #64
Mean of 3 results for best of 3 rounds for 3x3x3 blindfolded are now recognized.
Improvement #65
The validation now checks that only the permitted round formats are used.

Bug fix #45
The validation and parsing of dates of birth has been fixed to prevent wrong dates of birth in the database.
Bug fix #57
The application didn't always use the most recently downloaded WCA database export. This has now been fixed.
Improvement #56
The validation now checks the time limit for multiple blindfolded rounds.
Improvement #55
The name of application has been changed to WCA Workbook Assistant.
Improvement #54
Upgraded to Apache POI 3.9.

Bug #51
Detecting whether the WCA database export has to be updated failed if the export counter passed 999. This has now been fixed.

Improvement #46
The validation now also checks that persons in the registrations sheet are distinguishable from each other.
Improvement #47
The validation now also checks that each result can be linked to a person in the registration sheet.
Improvement #49
The validation now also checks that persons inside one round are distinguishable from each other.

Bug fix #42
Updating the WCA database export didn't work if no database export was downloaded previously. This has now been fixed.
Bug fix #43
Rows with only DNS results where not always reported as a validation error in cutoff rounds. This has now been fixed.

Improvement #37
The validation now also checks for wrongly sorted results.
Improvement #38
The validation now also checks for wrongly calculated positions.
Improvement #12
The validation now also checks for wrongly calculated multiple blindfolded scores.
Improvement #9
The validation now also checks for rows with only DNS results.
Improvement #39
Mistakes in names and countries no longer prevent the user from generating database scripts. This is useful when the name or country in the database is wrong.
Improvement #41
The WCA database export can be downloaded directly from the application and the application automatically checks for updates to the database export on startup.
Bug fix #24
Sheets in seconds were sometimes recognized as numbers if the first result happened to be a whole number. This has now been fixed.

Bug fix #15
The validation now checks that all results in a sheet have the expected result format.
Improvement #7
Results can now be exported to JSON for automated uploading.
Improvement #8
The validation now also checks WCA ID's and names based on WCA database exports.
Improvement #26
The validation now also checks for invisible 3rd digits after the decimal point.
Improvement #30
The validation now also checks for duplicate event/round combinations.
Improvement #32
Validation errors now refer to the cell address instead of just the row number.
Improvement #33
Validation errors are now displayed in a table instead of a flat list.
Improvement #36
Validation errors panel now has an option to show all errors in all sheets.
Improvement #34 and #35
Better window icons.

Bug fix #13
The validation kept validating results when the result format was invalid, leading to misleading validation errors. This is now fixed.
Bug fix #17
The Sheets contents pane sometimes didn't show the best and average results. This is now fixed.
Bug fix #22
The recognition of the result format for multiple blindfolded was sometimes incorrect if the round had only DNF results. This is now fixed.
Bug fix #25
Workbooks that contained cell formats with Locale information didn't always open properly. This is now fixed.
Improvement #6
The Persons query now only updates persons who competed in the uploaded competition.
Improvement #27
The Persons query now also returns the persons who still have a missing date of birth or gender.

Bug fix #2
The workbook file used to be locked by the application under Windows, which prevented making changes using Excel and refreshing from the application. This is now fixed.
Bug fix #5
The validation didn't check that non-empty results are formatted correctly for cutoff rounds. This is now fixed.
Improvement #3
The validation now also checks for wrongly calculated best and average results.
Improvement #4
The validation now also checks for rounding of times >10 minutes.