University Programs

Official Scoring Spreadsheet

Please click below to download the official scoring spreadsheet for the 2019 Student Steel Bridge Competition. It is strongly encouraged for the Regional Event hosts to run sample data sets to check the computations and verify the sorts and printing several weeks before your Event. If you notice any discrepancies, please e-mail universityprograms@aisc.org.


Student Steel Bridge Competition
2019 Official Scoring Spreadsheet

DOWNLOAD

Release date: November 5, 2018

Scoring Spreadsheet Instructions

This spreadsheet is to be used for scoring the 2019 AISC Student Steel Bridge Competition Regional Events and National Finals.

  1. Check the SSBC website for any updated versions of the spreadsheet at www.aisc.org/ssbc.
  2. READ ALL THE INSTRUCTIONS.
  3. Enter the competition information listed above in the cyan colored cells.  This information will then appear where needed throughout the system.
  4. Indicate that you have read the rules and press the button at the bottom of this page to prepare to enter participant information.
  5. Input the names of the participating school in the indicated cells on the "Participants" sheet.  You can enter the full name of each school then a short version for the tabs of each school's score sheet.  Once you have entered all of the schools that are competing, press the “Create School Sheets” button located at the top of the page.  An individual sheet will then be created for each school having the “Spreadsheet Sheet Tab ID” as its name.
  6. Print out a copy of the judge’s instructions for each judge.  Press <Ctrl><Q>
  7. Print out a copy of the Aesthetics Judging Form for each aesthetics judge.  Press <Ctrl><D>
  8. Print out a copy of the judges scoring forms for each participating school or a generic form.  Press <Ctrl><P>. This form will be used by the judges during the competition.
  9. Enter the number S above, after the dice has been rolled.  The location of the grating is then computed and shown in the light green cells above.  Give this information to the loading judges.
  10. At the conclusion of aesthetics judging, you can either use the entire aesthetics judging sheet OR just input your local judges ranking by each school's name in column A.  YOU HAVE TO INPUT DATA IN THIS SHEET FOR THE AESTHETICS RANKINGS TO BREAK ANY TIES!
  11. 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 school's sheet.
  12. Immediately after entering the scoring data for one school, print out the team score computation sheet (press <Ctrl><Shift><S>) and let the team captain verify the calculations.
  13. Print a copy of the team score computation sheet for the team captain to take with them.  Let the captain know that the computation may change if a consistency check is made and a data entry error is found later.
  14. Save the spreadsheet after each team data entry!
  15. 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!
  16. Print out the final ranking sheets by pressing <Ctrl><F>.
  17. Email the spreadsheet ASAP to universityprograms@aisc.org after the competition.  The Rules Committee uses this information to resolve appeals and to issue invitations to the National Finals. Nobody from your Regional Event will go to the Nationals Finals if this spreadsheet is not sent!
  18. There is a sheet labeled 'Awards Ceremony' which has a summary of the top three finishers in each category. It appears after running the ranking macro <Ctrl><Shift><R>. This is a useful form for the awards ceremony.
  19. After the Awards Ceremony, email a copy of the final ranking sheets to the faculty advisors and team captains.
  20. The tab labeled 'Stats' contains some statistical information about your competition which you might find useful. The Rules Committee uses this information in analyzing the effectiveness of the rules.