Home / Older Versions
Name Modified Size Downloads / Week Status
Parent folder
Totals: 27 Items   69.4 MB 41
Div B 2013-2014 SO Scoring System V9.xls 2014-10-25 3.0 MB 22 weekly downloads
Div C 2013-2014 SO Scoring System V9.xls 2014-10-25 3.0 MB 11 weekly downloads
Div B 2013-2014 SO Scoring System V8.xls 2014-04-23 2.9 MB 33 weekly downloads
Div C 2013-2014 SO Scoring System V8.xls 2014-04-23 2.9 MB 22 weekly downloads
Div C 2012-2013 SO Scoring System V7.xls 2013-03-04 3.0 MB 22 weekly downloads
Div B 2012-2013 SO Scoring System V7.xls 2013-03-04 3.0 MB 33 weekly downloads
Test Data Populated SO Scoring System V7.xls 2013-03-04 3.5 MB 33 weekly downloads
Div B 2012-2013 SO Scoring System V6.xls 2013-01-21 2.9 MB 33 weekly downloads
Div C 2012-2013 SO Scoring System V6.xls 2013-01-21 2.9 MB 33 weekly downloads
Test Data Populated SO Scoring System V6.xls 2013-01-21 3.5 MB 11 weekly downloads
Div C 2012-2013 SO Scoring System V5.xls 2012-12-31 2.9 MB 33 weekly downloads
Div B 2012-2013 SO Scoring System V5.xls 2012-12-31 2.9 MB 33 weekly downloads
Test Data Populated SO Scoring System V5.xls 2012-12-31 3.5 MB 11 weekly downloads
Div C 2012 SO Scoring System V3.xls 2012-10-19 2.9 MB 11 weekly downloads
Div B 2012 SO Scoring System V3.xls 2012-10-19 2.8 MB 11 weekly downloads
Div B 2012-2013 SO Scoring System V4.xls 2012-10-19 2.9 MB 11 weekly downloads
Div C 2012-2013 SO Scoring System V4.xls 2012-10-19 2.9 MB 11 weekly downloads
SO Scoring Guidelines V4.pdf 2012-04-17 229.7 kB 11 weekly downloads
SO Scoring Guidelines V4.docx 2012-04-17 33.5 kB 0
SO Scoring Guidelines V1.pdf 2012-04-06 225.1 kB 11 weekly downloads
SO Scoring Guidelines V1.docx 2012-04-06 30.5 kB 11 weekly downloads
Test Data Populated SO Scoring System V2.xls 2012-02-08 3.5 MB 11 weekly downloads
Test Data Populated SO Scoring System V1.xls 2012-02-08 2.9 MB 11 weekly downloads
Div C 2012 SO Scoring System V2.xls 2012-02-08 2.9 MB 11 weekly downloads
Div C 2012 SO Scoring System V1.xls 2012-02-08 2.6 MB 11 weekly downloads
Div B 2012 SO Scoring System V2.xls 2012-02-08 2.9 MB 0
Div B 2012 SO Scoring System V1.xls 2012-02-08 2.6 MB 0
There are 3 file variations available above: -Division C: pre-populated with current year's events -Division B: pre-populated with current year's events -Test Data: demo pre-populated with old data and settings / errors Current version: 10 NOTE: MS Excel 2008 for Mac does NOT support macros of any type, thus much of the functionality of this system will not be available. Virtually any other version of MS Office for Windows or Mac will work though. Older versions are placed in the Older Versions folder for archiving. The Scoring Guidelines files can help explain to event supervisors the scoring process and provide checklists for use during score counseling. When downloading the files, often you will get a choice to either 'Open With Excel' or 'Save to Disk'. Use the "Save As" option in Excel to first save a copy to your local hard drive somewhere and prevent the file from opening in Read-Only mode (which prevents changes from being made to it). Some systems get a "Compile Error; Can't find project or library" message when opening up the spreadsheet. Go to the 'Common Problems' section of the wiki <http://sourceforge.net/p/soscoring/wiki/Home/> for a simple resolution to this. Be sure to also click on the Mailing Lists link above to subscribe to the email list and recieve prompt notices when updated versions are posted. Change Log: V1 -Initial Release V2 -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 V3 -Improvements to the make blank event sheet macro to include rank sort macro V4 -Updated events for 2012-2013 season V5 -Combined team names / states into 1 cell on event and master score sheets and reduced the overall column width -Updated the row shading on all sheets to be in more readable groups of three instead of alternating lines -Rotated event names 180 degrees on master sheet to improve readability -Added code to print sheet macro to automatically switch between landscape / portrait orientations depending on the size of the Master sheet (Thanks to Connor Duffy for suggesting all of the above) -Added correlation check between overall team rankings and individual event rankings. A warning will now display on event pages if the score sort order is likely incorrect (e.g. low score wins selected instead of high score wins) -Added ability to turn off warning messages on master sheet during printing via a pop up message box when using the print sheet button -Minor formatting changes on the printable medals page V6 -Fixed "Div/O" message on stand alone scoresheet in the sort order box -Added a field to the setup tab to provide tournament specific info such as HQ location, phone number, website, etc -Updated sheet instructions to indicate tier column is optional -Fixed an error on the stand alone scoresheet regarding raw data missing error showing up if extra data was copied to hidden team rows -Fixed row heights of rank-sorted master scoresheet to be uniform -Added feature to unselect by default any events in error state on printable medal list printout and export to PPT function V7 -Added button to toggle gridlines on printable score sheet -Fixed Div/0 error that sometimes showed up in the sort orders box on event pages -Added functionality to copy team ns/dq status from setup page to all events and standalone blank score sheet -Removed extra data links in standalone blank score sheet pointing back to master spreadsheet V8 -Prepopulated with 2013-2014 event names -Created new printable medal sheet print dialog checkbox options for landscape vs. portrait printing and one event per page printing -Fixed minor bug in create standalone blank scoresheet macro that prevented the sort macro from being transferred in some situations -Added the import data from another workbook button on the standalone scoresheets that are created -Added red highlighting of any ns or dq scores on master sheet -Set default low score wins for Bungee Drop, Scrambler, Wheeled Vehicle V9 -Updated change events macro to update printable medals page as well -Fixed bug in one event per page macro on printable medal sheet -Added checkbox option to hide (by default) raw scores / tiers / ties on printable medal sheet to allow for much bigger text on printouts -Added tournament name and division to page header of printable medal sheet -Updated setup sheet to treat teams with blank school names as No Shows, regardless of Compete status setting -Added a manual macro to group set teams as no shows based upon patterns in their team # (e.g. to show different results for big vs. small school teams that compete at the same time) V10 -Prepopulated with 2014-2015 event names -Set default low score wins for Bungee Drop
Source: README.txt, updated 2014-10-25