I’ve just uploaded to the project website (https://sourceforge.net/projects/soscoring/files/) version “2” of the Science Olympiad Scoring system. I’ve incorporated several new features / changes based upon feedback received from various tournaments over the past month. These include the following:
-Added copying of sort order selection to import data macro auto function
-Added a note about sort order selection to import data macro manual function
-Added ability to set arbitrary Team #s on setup sheet, including no team #s at all if desired
-Changed Printable Medals List so that blanks are displayed instead of error messages when data is missing
-Added option to change Printable Medals List order to either 1st rank shown on top row or last rank shown on top row
-Added option to change PPT Presentation List order to either 1st rank shown on top row or last rank shown on top row
-Added option to select an image file to set as the PPT Presentation background
-Added option to select which events to create PPT slides for
-Added option to select which events to print out from Printable Medals List
-Added code to automatically check SourceForge project website for updated scoring system each time spreadsheet is opened up
-Added additional automatic tie breaking for teams on Master sheet which should break ties in almost all cases now
-Set default score order to low score wins for Mousetrap Vehicle and Gravity Vehicle
As always, if you have additional feedback / suggestions please let me know.
Alan Chalker, Ph.D.