All regions are now required to use the scoring spreadsheet provided by the
national rules committee. The completed spreadsheet must be emailed to the
Rules Committee at AFTBQ@uaa.alaska.edu
before any teams can be invited to the National competition.
As much as we'd like the spreadsheet to be perfect on first release, that
goal is still elusive. This means that you need to contact the above email
address ASAP when you discover a problem. During the regional
competitions, your ASCE National CSA Representative will have a phone number to
contact for quick replies.
It is strongly suggested that you run some sample data sets to check the
computations and to verify the sorts and printing SEVERAL WEEKS before your
regional. Don't wait to the last minute to learn how to use this complex
spreadsheet.
Also, you should do a last minute check of this website to see that you have
the latest version. Hosts can ask to be added to an email distribution list for
spreadsheet updates by sending their request to the above email address.
Click on the following link to download the latest version:
This year's spreadsheet is different than prior years in a number of ways.
Most importantly there are MORE macros that lead you through the set up and
usage phases. We went this route as last year a significant number of
regions did not appear to understand how the program worked and tried to force
their way around the controls that were in place. It is hoped that this new
version will help to guide users in the proper way to go.
-----------------<0>-----------------
Three videos will help you with the
spreadsheet. The first shows how to set up the spreadsheet for the
competition. The next illustrates how to print out judging forms. The
third is a quick tutorial on entering data and printing a summary page
for each team.
-----------------<0>-----------------
Setting Up the Spreadsheet
-----------------<0>-----------------
Printing the Judging Forms
-----------------<0>-----------------
Entering Data and Printing Results
-----------------<0>-----------------
Determining the Final Rankings
-----------------<0>-----------------
INSTRUCTIONS FOR USING THE SPREADSHEET
Note: You must allow Macros to run this spreadsheet.
It has been checked out in both 2003 and 2007 MS Excel.
Check the host guide website for any updated versions of the spreadsheet
at www.nssbc.info
Enter the competition information listed above in the cyan colored
cells. This information will then appear where needed throughout the system.
READ ALL THE INSTRUCTIONS.
Indicate that you've read the rules and press the button at the bottom
of this page to prepare to enter participant information.
Input the names of the participating ASCE student chapters in the
indicated cells on the "Participants" sheet. You can enter the full name of
each chapter then a short version for the tabs of each chapter's scoresheet.
Print out a copy of the judges instructions for each judge. Press
<ctrl><Q> to do this.
Print out a copy of the Display Judging Form for each Display Judge.
Press <ctrl><D>
Print out a copy of the judges scoring forms for each participating ASCE
student chapter or a generic form. Press <cntrl><P> to do this. This form
will be used by the judges during the competition.
Enter the number 'S' on the 'Start Here!!!!' page of the spreadsheet,
after the dice has been rolled. The location of the grating is then computed
and shown in the light green cells. Give this information to the loading
judges.
At the conclusion of Display judging, you can either use the entire
display judging sheet OR just input your local judges ranking by each
chapter's name in the Judge 1 column. YOU HAVE TO INPUT DATA IN THIS SHEET
FOR THE DISPLAY RANKINGS TO BREAK ANY TIES AND TO APPLY ANY DISPLAY
PENALTIES!!!!!
As teams complete their part in the competition, the scorer inputs the
data from scoring forms into the cyan colored cells on the left side of each
chapter's sheet.
Immediately after entering the scoring data for one ASCE chapter print
out the computation sheet (press <ctrl><shift><S>) and let the team captain
verify the calculations.
Save the spreadsheet after each team data entry!!!!
After inputting the team data, update the team rankings by pressing
<ctrl><shift><R>. You MUST update the rankings using the macro to get
accurate results!!!!
Print out the final ranking sheets by pressing <ctrl><F>. When you do
this you will be prompted to email the results to the national rules
committee. If you are connected to the internet then please do so!
If you did not email the spreadsheet when prompted, then do so AS SOON AS POSSIBLE to
AFTBQ@uaa.alaska.edu after the competition. The rules committee uses this
information to resolve appeals and to issue invitations to the national
competition! Nobody from your regional will go to Nationals if this
spreadsheet is not sent!
