Author Archives: mario

Scripted free routines and colored chits

Scripted free routines and colored chits

After the first couple of events under the new code, GCG RG Technical Coordinator shared the following:

  • For Elite Canada (and for competitions in Ontario) for scripted FREE routines, a decision has been made to have 4 difficulty judges. Each judge will judge with scripts and submit their score independently.

    This capability is built into the scoring program already. Simply enter EVERY submitted score in the first D panel, J1, J2, J3 and J4 respectively, the program will eliminate high-low and average the middle 2 scores if there are 4 judges (and average out if there are only 3 judges). D2 panel in this case will not be used. You can hide the D2 J1 column for data entry if it gets into your way.

  • For all events, do try to use different colored paper for different panels, it make it easier to sort and file.

Good luck to everyone!

IMPORTANT – Music Player issue

IMPORTANT – Music Player issue

In a recent competition in Ontario, they find that every now and then the first second of music (maybe the ding or whatever) may not play using a VLC player under Windows 10. The condition under which the problem can be reproduced are :

  • The VLC player closed
  • The VLC player has not been playing for 15 seconds or more.

Thanks to Serge for reporting and helping to identify the issue. This problem can be avoided by using windows media player as the default player. Under Windows 8, this problem did not show up using the same music and the same version of VLC player.

To all hosts, please change the default player on the music machine and test it. (Click for instructions)

To all coaches, we recommend the following actions:

  • Insert a one second silence before the ding or actual music. This not only solves the current issue but also Bluetooth speaker connect delays as well.
  • Make sure that you submit music in mp3 or file formats defined by host. VLC player accepts almost any music format but Windows media player have a much narrower list.
  • If you have any important start or end note, do make sure that it is using both the left and right channels, we have discovered that some amplifiers have some non-standard way of handling mono single sound channel and the note may not be heard even though it has been played by the player.

Get ready for 2017!

Get ready for 2017!

The scoring program supports more than just the FIG/GCG stream. Other streams that do not calculate the scores like FIG includes Aesthetic Group Gymnastics, Special O, Alberta’s interclub and interclub. The table below summarizes all the differences. (The cell for FIG/GCG, the E-T panel says 5/ded. This means the system supports submission of 5 scores but all the scores that are entered must represent DEDUCTIONS. The system will apply the appropriate calculations to arrive at the total for the event)

Potential # of scores submitted Calculation done by system
Stream Type D1 D2 Artistic / E-A Execution / E-T ExecCalcType DiffCalcType
FIG/GCG 1 1 1 5 10-(EA+ET) D1+D2
SO 4 0 0 4 ET D1
AGG 4 0 4 4 Creative:(10-ET)/2 D1
ABIC 4 0 4 0 NoExec D1
IC 4 4 4 4 10-(EA+ET) D1

Score display shows the scores AFTER applying the calculation rules at the panel level, i.e. Difficulties, Artistic and Execution. Component scores/deductions can only be seen via Apparatus Rank Report.

To facilitate the switching of views from one panel type to another, a view controller has been created and can be invoked via Ctrl-Shift-V. This can be docked alongside the top of the spreadsheet if you have to switch often.

The mail-merge ready judging chits are available via the Tools section on the right hand side.

Do be careful and apply ‘sanity check’ when you receive the first set of scores or when you switch from one stream to another.

Live scores will be updated in the very near future.

Good luck everyone!

Score2u 2017 version 1 highlights

Score2u 2017 version 1 highlights

NET versus DEDUCTIONS

The biggest change for 2017 for the scorer is that both the Difficulty and Execution panels are broken down into 2 sub-panels each – D1 (body) and D2 (apparatus) for Difficulties and E-A (artistic) and E-T (technical) for Execution.

  • For Difficulty scores, the judges submit the final score from their specific perspective.
  • For FIG/GCG streams, for judges within within the Execution sub-panels, judges only submit DEDUCTION score and NOT NET/FINAL score. The scorer will enter the submitted score as DEDUCTIONS (NOT the final score) as is. The final Execution score for FIG/GCG is automatically calculated as “10 minus (E-Artistic deductions + E-Technical deductions)”. To arrive at a score of zero initially for each athletes, the deductions are set to 10 to arrive at to zero (Max of 10 for panel minus 10 points of deductions to arrive at zero).
    Please note that for Special Olympics, for the execution score, the judges will still submit the net/final score.
    Special provisions in the next version will handle AGG creative routines such that the submitted deductions will be netted from 10 and then divided by 2.

A sample of the apparatus sheet as follows (click to expand). Note that each panel is of a different color (cannot be changed at this time) and columns where DEDUCTIONS are to be entered has the word “DED” and net score has the title as “NET”.

A sample of the report as follows (click to expand). Note that the breakdown of the panel shows the scores submitted by judges prior to the net and/or division.

View Control

The apparatus sheet is where all the scores are stored. In the past, not everyone knows how to easily switch between views easier for initial setup, data entry, check score summaries versus report needed by head judge. The View-Control can be brought up by hitting Ctrl-Shift-V and docked on top. It can help you quickly switch from one view to another based on stream (radio buttons) and intention (buttons). If for some reason there is a need that is not met, simply do hide/unhide of columns, the view-control simply makes things easier and will not be a show-stopper even if it is not working.

Yet to complete

As before, mail merge to pre-printed forms (e.g. judging chits) by rotation order is supported. I will be adding merge capability to the GCG set of standard chits in the very near future.

It is very early in the season and more fine-tuning will occur in the next few months. For example, the score display as well as the interface to Live Score are yet to be updated. Do report any bugs or problems you encounter.

2016 Scoring – Interim findings

2016 Scoring – Interim findings

We are a few months into the competitive season and Canadian Nationals is right around the corner. 2016V16 is now being tested.

The following are a few things worth noting when using the scoring system::

  • Turn autoSave OFF – do disable the Autosave, it always comes at a time when you least expected it and with a huge workbook and fragmentation of the disk, it may take a couple of minutes or more before it finishes and during that time, the system will say it is “non-responding”. Sometimes scorers panic and think the system has frozen (when it is not – just too busy). Turn autosave off and control your own destiny by saving after every couple of scores.
  • R1C1 style addressing – we had one case early on in the season when a nothing on a new computer works. On digging around, we found that MS Excel was installed with a rare default of R1C1 style addressing where, columns and rows are not represented as alpha-numeric (e.g C10 to mean column C row 20) but rather as offset from the current cell (e.g. RC(-1) to say one column to the left of the current cell). The column headings therefore will show numbers instead of A, B, C, etc.

    The scoring program depends on alpha-numeric cell references and so please set it up as such (or you will have problems printing).

  • At every major checkpoint, do close the workbook and create a copy into your backup folder with approximate time of day to unique identify the time of the checkpoint. For example: Elite 2016 – Saturday end of day.xlxm.
  • USB stick – at Elite Canada, a bad USB stick corrupted the transfer of the scoring workbook. Always install the score workbook ahead of time and give it a quick test. This seems such a straight forward thing but things can and did go wrong. At the venue, without any extra USB sticks, we had to use the internet to email the program from one computer to another. Extra stress that is not needed.
  • Stable computer – always do a quick test after setup or transport from one computer to another. Excel version, options, etc can give you a nasty surprise.
  • Static/buzzing sound after connecting the PC to the sound system – At Elite Canada, we had to run the power supply to the PC separate from the amplifier to eliminate a nasty hissing static sound. A spare long extension cord is a good thing to have.
  • Music high and lows – some music have a section that goes very soft and another part with very loud booming sound. In theory, the music person should not have to adjust the volume midway. I strongly recommend using a good music softwore to change the gain permanently if the gains differ too much from one section to another.
  • Configuration of the carry over from qualification to finals (Comp A to B) – the scoring system can handle a lot of configurations. For example, for Special Olympics Nationals, the qualification round is only worth 25%. In Elite Canada and Nationals, 100% of the scores from Comp A go into Comp B. The default was set in error to 25% and hence the problem with the cumulative results in the morning. This was corrected later in the afternoon. In V16, this value is displayed with a reminder message when you set the event code to a few of the known events (i.e. CIC, EC, ONPQ and SOC).
  • Number of athletes – currently the default is set at 200 and can be increased if needed.
  • Additional levels – At Planet Invitation, because of the number of athletes, they want to add levels by year (e.g. Junior2001, Junior2002, Junior2003). You can achieve that easily by observing the following steps:
    • If you are doing any manual overrides/inserts, always copy and insert an entire row from an existing row. This will avoid missing hidden cells.
    • Change column H which is the description of the new level. This value shows of on the rank reports.
    • Change column Q which is the start ID for the new level. Simply make sure for your event, ID will stay unique and not overlap.
    • Make sure the display Y/N flag is set properly. If column S is N, it means that the scoring system will not allow display of scores. This is set to N for level 1s as well as for HC right now.
    • The message mode is still an under used feature when people use live scores – do use it at the end of each day, during breaks, before the event and after the event so that people off premise know what is happening. You can also use it to provide a link to video feeds, official event site, etc.
    • It is a good idea to save and reboot the machines every morning before you start (i.e. Both the music computer and the scoring computer)