Spreadsheet

All ASCE student conferences are now required to use the scoring spreadsheet provided below 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 ASCE student conference 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 ASCE student conference. 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:

2011NSSBCScoreSheet_v00.xls
Release Date: Coming Soon

This year's spreadsheet continues to use VBA macros to lead you through the set up and usage phases. We have gone this route as significant number of ASCE student conferences did not appear to understand how the spreadsheet worked before instituting the programming 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 usage of the spreadsheet. If you have to force the programming at all, please contact AFTBQ@uaa.alaska.edu as soon as possible.

-----------------<0>-----------------

Four 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. Finally, the fourth video shows the proper procedure for running the ranking macro and printing the results for dissemination to the participating teams.

-----------------<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 ASCE student conference will go to Nationals if this spreadsheet is not sent!