Working with OJS

Are all robot scores and judging assessments entered in FLLTools? Then you can also use the Competition Results page. It calculates the same rankings as OJS (Robot Game, Core Values, Innovation Project, Robot Design and Champion's), and you can record the awards there. If you work with OJS, for example because you have to submit the spreadsheet to your operational partner, follow the steps below.

Important before you start

• You can find the spreadsheets for the current season on this web page.
• The spreadsheet is designed for Microsoft Excel. Some functionality may be lost in other programs. Also pay attention to the version of Excel you are using.
• Many columns in the various tabs contain formulas. Be careful not to change or delete these formulas by accident.
• When you copy data into the input tabs, use Paste Special > Values. This prevents the formatting or formulas from being overwritten.

Step 1.

Open the “Team and Program Information” tab. Fill in the team details there. This information automatically appears in the other tabs. You may notice that team names are not visible in the “Robot Game Scores” tab. These cells are hidden on purpose and must not be filled in manually.

Step 2.

Collect the rubric scores from the judges and the Robot Game scores from the referees. Then enter this data in the corresponding tabs of the workbook.

• You can export the Robot Game scores and Gracious Professionalism scores from FLLTools. See the page FLLTools export to OJS.
• Core Values scores (except the referees' Gracious Professionalism scores) must be entered in columns C to L on the “Core Values Input” tab.
• The referees' Gracious Professionalism scores must be entered in columns P–Q on the “Core Values Input” tab.
• When referees hand in paper score sheets, the Robot Game scores must be calculated using the FLLTools score calculator (https://rekenmachine.flltools.nl).

Step 3.

When all data has been entered, go to the “Results and Rankings” tab to see all information together in one overview.

Step 4.

Now you can assign the awards based on the rankings. Use the “Awards and Allocations” document from the judging toolkit for this (you can find it here).