{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Start Here!!!!","Participants","JudgeInstr","JudgingForms","Rankings","Summary","Lookuptables","AestheticsJudgeForm","Aesthetics Judging","Awards Ceremony","SchoolBase","First","Last","Stats"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start Here!!!!","index":0,"n_rows":167,"n_cols":12,"rows_kept":167,"cut":false,"hidden":false,"merged":[[166,0,166,9],[20,3,20,9],[10,3,10,9],[11,3,11,9],[12,3,12,9],[18,3,18,9],[19,3,19,9]]}
["2019 AISC Student Steel Bridge Competition Score Sheet"]
["Version Date:  11/5/2018"]
[]
["Important:  READ ALL INSTRUCTIONS BEFORE USING THIS SPREADSHEET!"]
[]
[null,"You will need to enable macros in Excel to use this spreadsheet"]
[]
["Your Competition Information:"]
[" Enter the following information for regional events or national finals.  This information prints on the data pages."]
[]
[null,null,"Competition:","Enter Name of Competition Here on the Start Here!!!! Sheet"]
[null,null,"Location:","Enter Name of Host School Here on the Start Here!!!! Sheet"]
[null,null,"Date:","Enter Date of Competition Here on the Start Here!!!! Sheet"]
[]
[null,null,null,"Load Location Determination:","N = ","?",null,"7.1(7): L1 = ",{"$f":"IF($F$15=1,11*12+0,IF($F$15=2,12*12+0,IF($F$15=3,13*12+6,IF($F$15=4,14*12+0,IF($F$15=5,14*12+6,IF($F$15=6,15*12+5,\"---\"))))))","v":"---"},"inches  "]
[null,null,null,"(See Section 7.1.(7) of Rules)",null,null,null,"7.1(7): L2 = ",{"$f":"IF($F$15=1,6*12+0,IF($F$15=2,8*12+0,IF($F$15=3,10*12+0,IF($F$15=4,8*12+4,IF($F$15=5,10*12+8,IF($F$15=6,10*12+5,\"---\"))))))","v":"---"},"inches  "]
[null,null,null,null,null,null,null,"7.1(7):  S = ",{"$f":"IF($F$15=1,11*12+6,IF($F$15=2,11*12+6,IF($F$15=3,0*12+0,IF($F$15=4,0*12+0, IF($F$15=5,0*12+0,IF($F$15=6,11*12+6,\"---\"))))))","v":"---"},"inches  "]
[]
[null,null,"Head Judge Name:","Enter Name of Head Judge on the Start Here!!!! Sheet"]
[null,null,"Email:","Enter the email for the Head Judge on the Start Here!!!! Sheet"]
[null,null,"Phone #:","Enter phone number for the Head Judge on the Start Here!!!! Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["HAVE  YOU  COMPLETED THIS SHEET AND READ THE INSTRUCTIONS?",null,null,null,null,null,null,null,null,null,"Not Yet","<---Change this cell!!!"]

{"sheet":"Participants","index":1,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Start Here!!!!'!A1","v":"2019 AISC Student Steel Bridge Competition Score Sheet"}]
["Participants and Eligibility Requirements (See Rules Section 4: Eligibility)"]
[]
[null,"Competition:",{"$f":"'Start Here!!!!'!D11","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
[null,"Location:",{"$f":"'Start Here!!!!'!D12","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"}]
[null,"Date:",{"$f":"'Start Here!!!!'!D13","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"}]
[null,null,null,null,null,{"$f":"COUNTIF(F9:F58,\"=Yes\")","v":7},"These people receive your team's results and competiton summary: Input on team pages"]
[null,null,"School Name","Spreadsheet Sheet Tab ID","Guest?","Participated in Bridge Comp?","Faculty Advisor Name","Faculty Advisor Email","Faculty Advisor Phone #","Local Contact Name","Local Contact Email","Local Contact Phone #","Local Contact Title"]
[null,1,"University of Snow","Snow","Don't Know","Yes"]
[null,2,"Glacier University","Glacier","Don't Know","Yes","Note: Advisor information is input on the school data sheets"]
[null,3,"Polar State University","Polar St","Don't Know","Yes"]
[null,4,"North Pole City College","NPCC","Don't Know","Yes"]
[null,5,"Ice Ridge University","Ice Ridge","Don't Know","Yes"]
[null,6,"University of Plain Fun","UPF","Don't Know","Yes"]
[null,7,"My University","My U","Don't Know","Yes"]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]

{"sheet":"JudgeInstr","index":2,"n_rows":103,"n_cols":11,"rows_kept":103,"cut":false,"hidden":true,"merged":[[99,1,99,10],[76,0,76,10],[89,0,89,10],[88,0,88,10],[96,1,96,8],[93,1,93,10],[95,1,95,8],[94,1,94,8],[90,0,90,10],[81,1,81,10],[80,1,80,10],[71,1,71,9],[75,0,75,10],[77,0,77,10],[57,1,57,9],[60,1,60,9],[61,1,61,9],[68,1,68,9],[63,1,63,9],[62,1,62,9],[70,1,70,9],[67,1,67,9],[65,1,65,9],[66,1,66,9],[69,1,69,9],[2,1,2,10],[47,0,47,10],[48,0,48,10],[49,0,49,10],[42,1,42,10],[37,1,37,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[31,1,31,9],[32,1,32,9]]}
["2019 AISC Student Steel Bridge Competition Judges Instruction Sheet"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"}]
["General:","The teams should not be allowed to carry their own data/judging forms from station to station.  The host should devise a method to ensure the integrity of the data/judging forms through out the competition process.  At the National Competition a \"marshal\" will be assigned to accompany the bridge through the competition process.  The marshal is responsible to ensure that the bridge is not tampered with between stations, maintain the data/judging forms, and to accompany the team captain to the data entry station after all testing is complete."]
[]
["Erection Area Instructions and Procedures"]
[]
["GIVE NO ADVICE!  OFFER NO OPINIONS!  It is the duty of a judge to enforce rules and record student performance.  If judges start to give advice, the teams will correctly feel that teams are being given unfair advantage.  Please resist the urge to \"help\" the students.  It will only lead to a challenged competition!"]
["ONLY MEET AND/OR DISCUSS THE ENTRY WITH THE TEAM CAPTAIN.  Do not discuss any part of your observations and/or rulings with other team members, faculty advisors, or by-standers. The situation will quickly get out of control if you don't follow this advice!  It is best if you do not allow others to crowd around when discussing ruling with the team captain."]
["ONLY DISCUSS A TEAM'S OWN BRIDGE.  Do not allow bystanders and competing teams to challenge decisions on bridges that belong to other teams.  Judges should review the FAQs posted on the website, the rules, and consult with experts provided by the host when making decisions.  Work hard at being consistent in your decision making.  Judges must be impartial! "]
[]
["As teams set up in the staging yards do the following:"]
[1,"Use the PRE-CONSTRUCTION checklist to check members for compliance to specifications"]
[2,"DO NOT allow teams to fix non-compliant members."]
[3,"Review penalties with the team captain."]
[]
["Meet with the team after checking all members."]
[1,"Identify the team captain who is to advise timer when work is complete."]
[2,"Remind the team of the ground rules (Is tape wet or dry?  Other construction issues.)"]
[3,"Remind the team that safety violations stop the clock."]
[4,"Remind the team to be safe."]
[5,"Answer any final questions"]
[]
["As the team prepares to start, check that Section 10.6 is complied with:"]
[1,"Team members are within the construction site"]
[2,"Team members have required safety equipment."]
[3,"Members, tools, bolts and loose nuts are in contact with the ground"]
[4,"Members, tools, bolts and loose nuts are in their respective designated areas"]
[]
["During Construction:"]
[1,"Clearly and loudly call out accidents/penalties as they occur."]
[2,"Use CONSTRUCTION JUDGING sheet to record accidents/penalties and construction time."]
[3,"Stop construction if any Rule 10.3 safety rule is violated.  Teams must be able to construct the bridge without safety violations."]
[4,"The team captain must signal end of timed construction.  Do not stop the clock until the conditions of Rule 10.9.1 are met. "]
[]
["Post Construction Inspection:"]
[1,"Only judges are allowed to touch the bridge."]
[2,"Use the POST CONSTRUCTION checklist to investigate compliance."]
[3,"Inform team captain of any Rule 9.4 violations."]
[4,"The team must fix (with penalties) all Rule 9.4.1, 9.4.2 and 9.4.3 violations within a 5 minute repair time."]
[5,"The team may fix all Rule 9.4.4 violations within the 5 minute repair time."]
[6,"Inform the Head Judge if any Rule 9.4.1, 9.4.2, and 9.4.3 violations cannot be resolved by the team."]
[7,"A one-time penalty of 5 minutes will be added to the construction time if any tool does not meet Rule 10.2.4."]
[8,"Review the pre-construction, construction, and post-construction checklists with the team captain.  Have the team captian sign the checklists to indicate that he/she understands the judges decisions."]
[9,"Disputes and disqualifications are to be resolved by the head judge(s) and/or rules/appeals committee."]
[]
["Load Area Instructions and Procedures"]
[]
["GIVE NO ADVICE!  OFFER NO OPINIONS!  It is the duty of a judge to enforce rules and record student performance.  If judges start to give advice, the teams will correctly feel that teams are being given unfair advantage.  Please resist the urge to \"help\" the students.  It will only lead to a challenged competition!"]
["ONLY MEET AND/OR DISCUSS THE ENTRY WITH THE TEAM CAPTAIN.  Do not discuss any part of your observations and/or rulings with other team members, faculty advisors, or by-standers.   The situation will quickly get out of control if you don't follow this advice!  It is best if you do not allow others to crowd around when discussing ruling with the team captain."]
["ONLY DISCUSS A TEAM'S OWN BRIDGE.  Do not allow bystanders and competing teams to challenge decisions on bridges that belong to other teams.  Judges should review the FAQs posted on the website, the rules, and consult with experts provided by the host when making decisions.  Work hard at being consistent in your decision making.  Judges must be impartial! "]
["No repairs can be made without the approval and supervision of the head judge(s) and/or rules/appeals committee."]
[]
["Lateral Load Test Procedure (See section 11.4)"]
[1,"Install sway measurement devices per drawings.  Have team captain verify the intial setup."]
[2,"Place one unit of decking and 75 lbs of weight as indicated in Rule 11.4.1."]
[3,"Team provides lateral restraint at floor level according to Rule 11.4."]
[4,"Apply lateral load and determine lateral deflection (11.4.2).  Have team captain verify the results."]
[5,"If lateral motion exceeds 1 inch in the lateral test the bridge may not be vertically loaded.  Involve the head judge/rules committee in the decision to halt load testing."]
[]
["Vertical Load Test Procedure  (See section 11.5)"]
[1,"Install safety supports, grating, sway measurement, and deflection measurement equipment.  See locaton of targets and decking plan in the rule book."]
[2,"Inspect team members for proper safety equipment (See Rule 11.2.1.3)"]
[3,"Uniformly distribute 100 lbs pre-loading on the decking units positioned at L1 and on L2 as specified in the Rule (11.5.3)."]
[4,"Initialize and record initial deflection readings at D1 and D2 (on the LOAD STATION judging form) in the presence of the team captain."]
[5,"Initialize sway measurement device"]
[6,"Begin loading. THE LOADING MUST BE CONTINUOUS!  Once the loading process begins, do not allow teams to stop for any reason other than impending structural failure.  All bridges must be loaded in the same sequence.  NO EXCEPTIONS!"]
[7,"Do not give running updates.  At the national competition, only the officials are allowed to watch the gages during loading."]
[8,"As loads are applied, monitor the sway measurements.  Stop loading if sway exceeds 1 inch in any direction."]
[9,"As loads are applied, monitor the vertical deflection measurements.  Stop loading if deflection exceeds 3 inches at any target."]
[10,"Stop loading if any part of bridge other than the initial bearing points comes into contact with ground or safety supports."]
[11,"After all the load is applied, record readings at targets D1 and D2 in the presence of the team captain.",null,null,null,null,null,null,null,null,"  "]
[12,"Have the team captain sign the load station judging form, indicating that they acknowlege that the correct values have been recorded."]
[]
["Bridge Weight Determination"]
[]
["GIVE NO ADVICE!  OFFER NO OPINIONS!  It is the duty of a judge to enforce rules and record student performance.  If judges start to give advice, the teams will correctly feel that teams are being given unfair advantage.  Please resist the urge to \"help\" the students.  It will only lead to a challenged competition!"]
["ONLY MEET AND/OR DISCUSS THE ENTRY WITH THE TEAM CAPTAIN.  Do not discuss any part of your observations and/or rulings with other team members, faculty advisors, or by-standers.   The situation will quickly get out of control if you don't follow this advice!  It is best if you do not allow others to crowd around when discussing ruling with the team captain."]
["ONLY DISCUSS A TEAM'S OWN BRIDGE.  Do not allow bystanders and competing teams to challenge decisions on bridges that belong to other teams.  Judges should review the FAQs posted on the website, the rules, and consult with experts provided by the host when making decisions.  Work hard at being consistent in your decision making.  Judges must be impartial! "]
[]
["Weighing Procedure"]
["General:","Note that there are a large variety of methods available for determining the weight of the bridge.  The host should devise a method that is fair and accurate to the nearest pound.  "]
[null,"Above all else, the method MUST be consistently applied to all bridges.  DO NOT change procedure during the course of the competition.  If there is a change in procedure that may affect the results, all bridges should be re-weighed."]
[1,"Weigh the bridge.  Allow the team captain to verify the readings on all measurement devices."]
[2,"Record the raw data on the judging forms. "]
[3,"Have the team captain sign the weigh station judging form."]
[]
["Data Entry Proceedure"]
[]
["GIVE NO ADVICE!  OFFER NO OPINIONS!  It is the duty of a judge to enforce rules and record student performance.  If judges start to give advice, the teams will correctly feel that teams are being given unfair advantage.  Please resist the urge to \"help\" the students.  It will only lead to a challenged competition!"]
["ONLY MEET AND/OR DISCUSS THE ENTRY WITH THE TEAM CAPTAIN.  Do not discuss any part of your observations and/or rulings with other team members, faculty advisors, or by-standers.   The situation will quickly get out of control if you don't follow this advice!  It is best if you do not allow others to crowd around when discussing ruling with the team captain."]
["ONLY DISCUSS A TEAM'S OWN BRIDGE.  Do not allow bystanders and competing teams to challenge decisions on bridges that belong to other teams.  Judges should review the FAQs posted on the website, the rules, and consult with experts provided by the host when making decisions.  Work hard at being consistent in your decision making.  Judges must be impartial! "]
[]
["Data Entry Procedure"]
["General:","The data entry official should only meet with the involved team captain and (if applicable) marshal.  More detailed information on this procedure, as done at the national competition, is available from the host guide website:   www.aisc.org/ssbc "]
[1,"In the presence of the team captain, enter the data from the data/judging forms into the scoring spreadsheet."]
[2,"Print out a copy of the team's calculated results (Press <Cntrl><Shft><s> while on the team's scoring sheet) and allow the team captain to verify the calculations.  The data entry official should have a copy of the rules and the official clarifications available for reference.  The host may provide a calculator and/or allow the team captains to provide their own."]
[3,"If there are issues with the data sheets, have the marshal work with the relevant officials to resolve the issue."]
[4,"Have the team captain accept the team results by signing the results calculation form."]
[5,"Print a final copy of the team's calculations.  Give the final copy to the team captain."]
[6,"Email the team's calculations to the Faculty Advisor and Local Contact."]
[7,"Inform captain that results are not final until certified by the judges/rules committee at the end of the"]
[null,"competition."]
[8,"Keep the signed copy of the team results for future reference."]

{"sheet":"JudgingForms","index":3,"n_rows":240,"n_cols":8,"rows_kept":240,"cut":false,"hidden":true,"merged":[[81,1,81,7],[99,1,99,7],[92,1,92,7],[93,1,93,7],[94,1,94,7],[97,1,97,7],[98,1,98,7],[84,1,84,7],[85,1,85,7],[86,1,86,7],[87,1,87,7],[88,1,88,7],[239,0,239,1],[220,0,220,1],[62,0,62,1],[114,0,114,1],[157,0,157,1],[205,0,205,1],[76,1,76,7],[77,1,77,7],[78,1,78,7],[79,1,79,7],[80,1,80,7],[82,1,82,7],[83,1,83,7],[89,1,89,7],[90,1,90,7],[91,1,91,7]]}
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 1/7"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"}]
[]
["School: "]
[]
["Contact Information:"]
[]
[null,"AISC needs the contact information for the Faculty Advisor so as to send CHECKS to each"]
[null,"participating school as well as to issue invitations to the national competition and/or"]
[null,"to  resolve judging disputes.  Please enter contact information here and in the"]
[null,"scoring spreadsheet during data entry.  The Faculty Advisor may also receive"]
[null,"results by email."]
[]
[null,"Faculty Advisor Name: _____________________________________________"]
[null,"Faculty Advisor email: ______________________________________________"]
[null,"Faculty Advisor Phone #: ____________________________________________"]
[]
[null,"Local Contact:  This is a person on your team who is at the competition and who can be"]
[null,"contacted if there are questions about scoring or other issues.  This person may also receive "]
[null,"results by email:"]
[]
[null,"Local Contact Name: _____________________________________________"]
[null,"Local Contact Title (i.e. Team Captain, Faculty Adivsor, etc): ______________________________"]
[null,"Local Contact email: ______________________________________________"]
[null,"Local Contact Phone #: ____________________________________________"]
[]
[]
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 2/7"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"}]
[]
[{"$f":"+A4","v":"School: "}]
[]
["Pre-Construction Check",null,null,null,null,"Station #: _________________"]
[]
["Check and record the following:"]
["Section 8:  Materials & Components"]
[null,null,null,null,null,"Number of"]
[null,null,null,null,null,"Components"]
[null,null,null,null,null,"in Violation"]
[{"$f":"+SchoolBase!A24","v":"   8.2.1: Member fabricated with adhesive, solder, or brazing"}]
[{"$f":"+SchoolBase!A25","v":"   8.2.2.1: Member fails rigidity requirement; loose parts, and/or"}]
[{"$f":"+SchoolBase!A26","v":"   8.2.2.2: Member dimensional violations, and/or"}]
[{"$f":"+SchoolBase!A27","v":"   8.2.2.3: Non-continuous threads, and/or"}]
[{"$f":"+SchoolBase!A28","v":"   8.2.5: Member hole is threaded"}]
["   8.2.3.1: Violates bolt specification: Modified or not commercial"]
["   8.2.3.2: Violates bolt specification: Too long or incomplete threads"]
["   8.2.4.1: Violates nut specification: Modified or not commercial"]
["   8.2.4.2: Violates nut specification: Incomplete threads"]
[]
[{"$f":"+SchoolBase!A34","v":"Check members.  Tape or mark potentially adjustable parts (see 8.2.2.1)"}]
[]
[{"$f":"+SchoolBase!A36","v":"Bridge will not be ranked if the bridge cannot be built without/because:  (Select applicable rule if ruled ineligible)"}]
["Enter a Check for all that are violated."]
["NR",{"$f":"+SchoolBase!B37","v":"   8.1: Member uses material not magnetically attractive"}]
["NR",{"$f":"+SchoolBase!B38","v":"   10.2.3: Illegal tools (external power)"}]
["NR",{"$f":"+SchoolBase!B39","v":"   10.2.4: Illegal tool (weight, size)"}]
["NR",{"$f":"+SchoolBase!B40","v":"   10.2.5: Lubricant on site"}]
[]
[{"$f":"+SchoolBase!A42","v":"TOTAL Number of BUILDERS (10.2.2):"},null,null,null,"1  2  3  4  5  6","Builders "]
[null,null,null,null,"Circle the actual number. "]
["Note: All constructors must have req'd Safety equipment (Section 10.3.2)"]
[]
["Team Captain Signature:"]
[]
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 3/7"]
[{"$f":"+A29","v":"Version Date:  11/5/2018"}]
[]
[{"$f":"+A31","v":"School: "}]
[]
["Construction Judging",null,null,null,null,"Station #: _________________"]
[]
[]
["The following violations stop the clock, workers and materials return to appropriate locations,"]
["   judges advise the team that they need to find another way to do their work."]
[]
["Bridge is not ranked if the bridge cannot be built without/because:  (Check applicable rule if ruled ineligible)"]
["NR",{"$f":"+SchoolBase!B47","v":"   5: Judges deem the bridge unsafe to compete for any reason"}]
["NR",{"$f":"+SchoolBase!B48","v":"   9.2.6: Bridge cannot accommodate local conditions"}]
["NR",{"$f":"+SchoolBase!B49","v":"   10.2.1: Someone other than builders & judges in construction site"}]
["NR",{"$f":"+SchoolBase!B50","v":"   10.2.2: More than six builders"}]
["NR",{"$f":"+SchoolBase!B51","v":"   10.2.3: Illegal tools (external power)"}]
["NR",{"$f":"+SchoolBase!B52","v":"   10.2.4: Illegal tool (weight, size)"}]
["NR",{"$f":"+SchoolBase!B53","v":"   10.2.5: Lubricant on site"}]
["NR",{"$f":"+SchoolBase!B54","v":"   10.3.1: Exposure to personal injury"}]
["NR",{"$f":"+SchoolBase!B55","v":"   10.3.2: Improper wearing of personal protective equipment (See 10.1.5)"}]
["NR",{"$f":"+SchoolBase!B56","v":"   10.3.3: Pouch or clothing being removed/held in hands"}]
["NR",{"$f":"+SchoolBase!B57","v":"   10.3.4: Builder holding nuts, bolts, or tools in mouth"}]
["NR",{"$f":"+SchoolBase!B58","v":"   10.3.5: Items being thrown"}]
["NR",{"$f":"+SchoolBase!B59","v":"   10.3.6: Builder crossing river"}]
["NR",{"$f":"+SchoolBase!B60","v":"   10.3.7: Builder simultaneously touching more than one member"}]
["NR",{"$f":"+SchoolBase!B61","v":"   10.3.8: A builder using the bridge, member, or tool for physical support"}]
["NR",{"$f":"+SchoolBase!B62","v":"   10.3.9: A builder using other builder(s) for support"}]
["NR",{"$f":"+SchoolBase!B63","v":"   10.3.10: Improper sequence of constructing CP"}]
["NR",{"$f":"+SchoolBase!B64","v":"   10.3.11: Builder constructing outside construction zone"}]
["NR",{"$f":"+SchoolBase!B65","v":"   10.3.12: Builder(s) supporting entire weight of construction portion"}]
["NR","   10.3.13: Constructed portion extending beyond site boundary"]
["NR","   10.3.14: Cannot accommodate local conditions"]
["NR",{"$f":"+SchoolBase!B68","v":"   10.4: Intentionally causing an accident"}]
["NR",{"$f":"+SchoolBase!B69","v":"   10.6.2: Adding/removing items or builders to/from site"}]
[]
["Tabulate the following accidents without stopping the clock:"]
[null,null,null,null,null,"During Construction"]
["Section 10.4 Accidents",null,null,null,null,"Number"]
[{"$f":"+SchoolBase!A73","v":"   10.4.1: Builder touches river or floor outside construction boundary"}]
[{"$f":"+SchoolBase!A74","v":"   10.4.2: Item illegally touches river/ground/floor"}]
[{"$f":"+SchoolBase!A75","v":"   10.4.3: Non-CP members touch outside staging yard"}]
[]
[{"$f":"+SchoolBase!A77","v":"   10.4.2: Team demonstrates that bearing surface cannot stay in footing"},null,null,null,null,null,"Enter \"Y\" if rule violated"]
[]
[null,null,null,"(Hr:Min:Sec)"]
["Record the clock time for construction:",null,null,null,"  (See 10.7 and 10.8)"]
["**** Enter \"0:46:00\" if construction was halted due to 10.8.2 time limit ****"]
[]
[]
["Team Captain Signature:"]
[]
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 4/7"]
[{"$f":"+A29","v":"Version Date:  11/5/2018"}]
[]
[{"$f":"+A31","v":"School: "}]
[]
["Post Construction Check",null,null,null,null,"Station #: _________________"]
[]
["Section 9: Structural Specifications"]
[]
["The bridge is not to be ranked if any of the following rules are violated:  (Check all that apply)"]
["NR",{"$f":"+SchoolBase!B87","v":"   3: Bridge is unsuitable for intended purpose"}]
["NR",{"$f":"+SchoolBase!B88","v":"   9.2.1: Bridge does not provide continuous stringers along both sides"}]
["NR",{"$f":"+SchoolBase!B89","v":"   9.2.6: Bridge cannot accommodate local conditions"}]
["NR",{"$f":"+SchoolBase!B90","v":"   9.4: Connections cannot be fixed within five minute limit"}]
["NR",{"$f":"+SchoolBase!B91","v":"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"}]
[]
["Check the rules that are violated.  The number of each violation is not relevant."]
["Record only the greatest violation for each rule."]
[null,null,null,null,"Dimensional Violation"]
[null,null,null,null,"< 1/4\"","> 1/4\" to < 1\"","> 1\" to < 2\"","> 2\" NR"]
[{"$f":"+SchoolBase!A97","v":"   9.3.1: Bridge touches ground outside of footings"},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A98","v":"   9.3.2: Bridge taller than 5'0\""},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A99","v":"   9.3.3: Bridge is wider than 5'0\""},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A100","v":"   9.3.4: River/ground clearance < 7.5\""},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A101","v":"   9.3.5: Stringer elev. not between 19\" and 23\""},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A102","v":"   9.3.6: Stringer < 22 ft"},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A103","v":"   9.3.8: Components extend outside const. zone"},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A104","v":"   9.3.9: Passageway clearance violation"},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A105","v":"   9.3.10: Stringers not in contact with top of rabbet"},null,null,null,null,null,null,"NR"]
[{"$f":"+SchoolBase!A106","v":"   9.3.11: Stringers have holes, splits, etc."},null,null,null,null,null,null,"NR"]
[]
[null,null,null,null,"Number"]
[null,null,null,null,"of"]
[null,null,null,null,"Violations"]
[{"$f":"+SchoolBase!A113","v":"   9.4.1: Members touch but not connected"}]
[{"$f":"+SchoolBase!A114","v":"   9.4.2: Nuts not fully engaged"}]
[{"$f":"+SchoolBase!A115","v":"   9.4.3: Holes are too big or incomplete"}]
[{"$f":"+SchoolBase!A116","v":"   9.4.4: Nut/Bolt head not in contact with member"}]
[]
[{"$f":"+SchoolBase!A118","v":"   9.5: Number of nuts/bolts uninspectable"}]
[{"$f":"+SchoolBase!A119","v":"10.9.2: Illegal disassembled tool (weight, size)"},null,null,null,null,"Enter \"Y\" if rule violated"]
["Team Captain Signature:"]
[]
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 5/7"]
[{"$f":"+A29","v":"Version Date:  11/5/2018"}]
[]
[{"$f":"+A31","v":"School: "}]
[]
["Load Station Data",null,null,null,null,"Station #: _________________"]
[]
["Check for Damage in Transit"]
[]
["The bridge is not ranked if any of the following rules are violated.  Check all that apply."]
[]
["NR",{"$f":"+SchoolBase!B124","v":"   3: Bridge is unsuitable for intended purpose"}]
["NR",{"$f":"+SchoolBase!B125","v":"   5: Judges deem the bridge unsafe to compete for any reason"}]
["NR",{"$f":"+SchoolBase!B126","v":"   9.2.2: Bridge does not provide access for safely placing decking & load"}]
["NR",{"$f":"+SchoolBase!B127","v":"   9.2.3: Decking attached/anchored to bridge"}]
["NR",{"$f":"+SchoolBase!B128","v":"   9.2.4: Decking distorts the bridge"}]
["NR",{"$f":"+SchoolBase!B129","v":"   9.2.5: Bridge is anchored or tied to ground"}]
["NR",{"$f":"+SchoolBase!B130","v":"   9.2.6: Bridge cannot accommodate local conditions"}]
["NR",{"$f":"+SchoolBase!B131","v":"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"}]
["NR",{"$f":"+SchoolBase!B132","v":"   11.2.1.1: Unsafe loading procedure"}]
["NR",{"$f":"+SchoolBase!B133","v":"   11.2.1.3: Competitors not wearing required safety gear"}]
["NR",{"$f":"+SchoolBase!B134","v":"   11.2.3.7: Vertical load cannot be safely placed on bridge"}]
["NR",{"$f":"+SchoolBase!B135","v":"   11.3: Bridge cannot be loaded safely or sway/defl cannot be measured"}]
["NR",{"$f":"+SchoolBase!B136","v":"   11.6: Bridge collapses during unloading"}]
[]
["Lateral Load Test (11.4):  This is a pass/fail requirement"]
[]
[null,{"$f":"+SchoolBase!B140","v":"11.4.2: Lateral Test"},"Pass  /  Fail","circle one","11.2.2.2 Excess 1” horizontal sway."]
[null,"Note: Failing the Lateral Test causes a bridge not to be ranked for any awards"]
[]
[]
["Vertical Load Test (11.5)"]
[]
["Vertical Load Test"]
[null,null,{"$f":"+SchoolBase!D144","v":"D1"},{"$f":"+SchoolBase!E144","v":"D2"}]
[null,{"$f":"+SchoolBase!C145","v":"Initial Reading w/preload on bridge"},null,null,"Please record the signs on each"]
[null,{"$f":"+SchoolBase!C146","v":"End of Loading"},null,null,"number as observed."]
[]
["Watch for DQ situations listed below 11.5.2"]
[]
[null,null,null,{"$f":"+SchoolBase!D150","v":"11.5.2(a): Sway > 1\""},"NR"]
[null,null,null,{"$f":"+SchoolBase!D151","v":"11.5.2(b): Any deflection > 3\" downward"},"NR"]
[null,null,null,{"$f":"+SchoolBase!D152","v":"11.5.2(c): Contact with Safety Support or Ground"},"NR"]
[null,null,null,{"$f":"+SchoolBase!D153","v":"11.5.2(d): Decking or load falls off bridge"},"NR"]
[null,null,null,{"$f":"+SchoolBase!D154","v":"11.5.2(e): Collapse or dangerous imminent collapse"},"NR"]
[]
["Team Captain Signature:"]
[]
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 6/7"]
[{"$f":"+A29","v":"Version Date:  11/5/2018"}]
[]
[{"$f":"+A31","v":"School: "}]
[]
[null,null,null,null,null,"Station #: _________________"]
[null,"Weigh Station Data"]
[]
[null,"Record the readings on the scales",null,null,null,"Note:  if other means are used to"]
[null,null,"Left","Right",null,"weigh the bridge, just include "]
[null,"East End",null,null,null,"the total weight in one of the cells."]
[null,"West End"]
[]
["Team CaptainSignature:"]
[]
[]
["2019 AISC Student Steel Bridge Competition Judging Data Form - page 7/7"]
[{"$f":"+A29","v":"Version Date:  11/5/2018"}]
[]
[{"$f":"+A31","v":"School: "}]
[null,"Team Contract Fine:"]
[null,{"$f":"+SchoolBase!D165","v":"6.2.7: Team Contract Fine"},null,null,null,"Note: For national competition only"]
[]
[null,"Scoring Station Statement:"]
[]
[null,"I have had the opportunity to observe the data entry for our bridge and to verify the resulting scoring"]
[null,"computations for accuracy."]
[]
[null,"I have also received a copy of my team's Score Computation Sheet from the host in hard copy"]
[null,"and/or by email and expect to receive the overall ranking summary form either at the awards"]
[null,"announcement and/or via email within 48 hours of the awards announcement."]
[]
["Team CaptainSignature:"]

{"sheet":"Rankings","index":4,"n_rows":22,"n_cols":24,"rows_kept":22,"cut":false,"hidden":true,"merged":[[13,0,13,2],[13,18,13,20],[13,21,13,23],[13,3,13,5],[13,6,13,8],[13,9,13,11],[13,12,13,14],[13,15,13,17]]}
[]
["Instructions:",null,null,"All team data is input on the school scoring, Aesthetics Judging, or Participants sheets.",null,null,null,null,"DO NOT ALTER ANY CELLS MANUALLY!"]
[null,null,null,"Press \"Rank Teams\" button or <Ctrl><Shift><R> to update the rankings."]
[null,null,null,"Press \"Print Ranks\" button or  <Ctrl><F> to reformat and print the ranking sheet",null,null,null,null,"This page should be released to all participants as soon as possible after the competition."]
[]
[]
[]
["2019 AISC Student Steel Bridge Competition Category Ranking Sheet",null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"2019 AISC Student Steel Bridge Competition Category Ranking Sheet"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A9","v":"Version Date:  11/5/2018"}]
["Competition:",{"$f":"+Summary!B6","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,null,"S = ",{"$f":"+'Start Here!!!!'!F15","v":"?"},null,null,null,"Competition:",{"$f":"+B10","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
["Location:",{"$f":"+Summary!B7","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"},null,null,null,null,null,null,null,null,null,null,"Location:",{"$f":"+B11","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"}]
["Date:",{"$f":"+Summary!B8","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"+B12","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"}]
[]
["Not Ranked",null,null,"Construction Speed",null,null,"Lightness",null,null,"Aesthetics",null,null,"Stiffness",null,null,"Economy",null,null,"Efficiency",null,null,"Overall"]
["School",null,"NR","School","Time","Rank","School","Weight","Rank","School","Score","Rank","School","Agg D","Rank","School","Cc ","Rank","School","Cs","Rank","School","Cc + Cs","Rank"]
[{"$f":"+Summary!A16","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!C16","v":{"$error":"#REF!"}},{"$f":"+Summary!D16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!E16","v":{"$error":"#REF!"}},{"$f":"+Summary!F16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!G16","v":{"$error":"#REF!"}},{"$f":"+Summary!H16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!I16","v":{"$error":"#REF!"}},{"$f":"+Summary!J16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!K16","v":{"$error":"#REF!"}},{"$f":"+Summary!L16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!M16","v":{"$error":"#REF!"}},{"$f":"+Summary!N16","v":{"$error":"#REF!"}},{"$f":"+Summary!A16","v":{"$error":"#REF!"}},{"$f":"+Summary!O16","v":{"$error":"#REF!"}},{"$f":"+Summary!P16","v":{"$error":"#REF!"}}]
[{"$f":"+Summary!A17","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!C17","v":{"$error":"#REF!"}},{"$f":"+Summary!D17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!E17","v":{"$error":"#REF!"}},{"$f":"+Summary!F17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!G17","v":{"$error":"#REF!"}},{"$f":"+Summary!H17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!I17","v":{"$error":"#REF!"}},{"$f":"+Summary!J17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!K17","v":{"$error":"#REF!"}},{"$f":"+Summary!L17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!M17","v":{"$error":"#REF!"}},{"$f":"+Summary!N17","v":{"$error":"#REF!"}},{"$f":"+Summary!A17","v":{"$error":"#REF!"}},{"$f":"+Summary!O17","v":{"$error":"#REF!"}},{"$f":"+Summary!P17","v":{"$error":"#REF!"}}]
[{"$f":"+Summary!A18","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!C18","v":{"$error":"#REF!"}},{"$f":"+Summary!D18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!E18","v":{"$error":"#REF!"}},{"$f":"+Summary!F18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!G18","v":{"$error":"#REF!"}},{"$f":"+Summary!H18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!I18","v":{"$error":"#REF!"}},{"$f":"+Summary!J18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!K18","v":{"$error":"#REF!"}},{"$f":"+Summary!L18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!M18","v":{"$error":"#REF!"}},{"$f":"+Summary!N18","v":{"$error":"#REF!"}},{"$f":"+Summary!A18","v":{"$error":"#REF!"}},{"$f":"+Summary!O18","v":{"$error":"#REF!"}},{"$f":"+Summary!P18","v":{"$error":"#REF!"}}]
[{"$f":"+Summary!A19","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!C19","v":{"$error":"#REF!"}},{"$f":"+Summary!D19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!E19","v":{"$error":"#REF!"}},{"$f":"+Summary!F19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!G19","v":{"$error":"#REF!"}},{"$f":"+Summary!H19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!I19","v":{"$error":"#REF!"}},{"$f":"+Summary!J19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!K19","v":{"$error":"#REF!"}},{"$f":"+Summary!L19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!M19","v":{"$error":"#REF!"}},{"$f":"+Summary!N19","v":{"$error":"#REF!"}},{"$f":"+Summary!A19","v":{"$error":"#REF!"}},{"$f":"+Summary!O19","v":{"$error":"#REF!"}},{"$f":"+Summary!P19","v":{"$error":"#REF!"}}]
[{"$f":"+Summary!A20","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!C20","v":{"$error":"#REF!"}},{"$f":"+Summary!D20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!E20","v":{"$error":"#REF!"}},{"$f":"+Summary!F20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!G20","v":{"$error":"#REF!"}},{"$f":"+Summary!H20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!I20","v":{"$error":"#REF!"}},{"$f":"+Summary!J20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!K20","v":{"$error":"#REF!"}},{"$f":"+Summary!L20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!M20","v":{"$error":"#REF!"}},{"$f":"+Summary!N20","v":{"$error":"#REF!"}},{"$f":"+Summary!A20","v":{"$error":"#REF!"}},{"$f":"+Summary!O20","v":{"$error":"#REF!"}},{"$f":"+Summary!P20","v":{"$error":"#REF!"}}]
[{"$f":"+Summary!A21","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!C21","v":{"$error":"#REF!"}},{"$f":"+Summary!D21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!E21","v":{"$error":"#REF!"}},{"$f":"+Summary!F21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!G21","v":{"$error":"#REF!"}},{"$f":"+Summary!H21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!I21","v":{"$error":"#REF!"}},{"$f":"+Summary!J21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!K21","v":{"$error":"#REF!"}},{"$f":"+Summary!L21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!M21","v":{"$error":"#REF!"}},{"$f":"+Summary!N21","v":{"$error":"#REF!"}},{"$f":"+Summary!A21","v":{"$error":"#REF!"}},{"$f":"+Summary!O21","v":{"$error":"#REF!"}},{"$f":"+Summary!P21","v":{"$error":"#REF!"}}]
[{"$f":"+Summary!A22","v":{"$error":"#REF!"}},null,{"$f":"+Summary!B22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!C22","v":{"$error":"#REF!"}},{"$f":"+Summary!D22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!E22","v":{"$error":"#REF!"}},{"$f":"+Summary!F22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!G22","v":{"$error":"#REF!"}},{"$f":"+Summary!H22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!I22","v":{"$error":"#REF!"}},{"$f":"+Summary!J22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!K22","v":{"$error":"#REF!"}},{"$f":"+Summary!L22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!M22","v":{"$error":"#REF!"}},{"$f":"+Summary!N22","v":{"$error":"#REF!"}},{"$f":"+Summary!A22","v":{"$error":"#REF!"}},{"$f":"+Summary!O22","v":{"$error":"#REF!"}},{"$f":"+Summary!P22","v":{"$error":"#REF!"}}]

{"sheet":"Summary","index":5,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":true,"merged":[[3,0,3,15],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,14,13,15],[13,12,13,13],[13,10,13,11],[13,8,13,9],[13,0,14,0],[13,1,14,1]]}
[null,"Instructions:  This is a intermediate computation sheet.  Press <Cntrl><Shft><r> to update the rankings."]
[null,null,"All team data is input on other sheets"]
[]
["2019 AISC Student Steel Bridge Competition Summary Score Sheet"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"}]
["Competition:",{"$f":"+'Start Here!!!!'!D11","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,null,null,null,null,null,7,"Schools Listed"]
["Location:",{"$f":"+'Start Here!!!!'!D12","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"}]
["Date:",{"$f":"+'Start Here!!!!'!D13","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"}]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[]
[]
[]
["School","Ineligibility","Construction Speed",null,"Lightness",null,"Aesthetics",null,"Stiffness",null,"Economy",null,"Efficency",null,"Overall"]
[null,null,"Time","Rank","Weight","Rank","Score","Rank","Agg D","Rank","Cc","Rank","Cs","Rank","Cc + Cs","Rank",null,null,null,"Lat Test","Speed","Lightness","Stiffness","Economy","Efficency","Overall"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U16+G16/100000000","v":{"$error":"#REF!"}},{"$f":"RANK(C16,C$16:C$22,1)","v":{"$error":"#REF!"}},{"$f":"V16+G16/100000000","v":{"$error":"#REF!"}},{"$f":"RANK(E16,E$16:E$22,1)","v":{"$error":"#REF!"}},{"$f":"IF(B16=\"None\",+'Aesthetics Judging'!A19,9999)","v":{"$error":"#REF!"}},{"$f":"RANK(G16,G$16:G$22,1)","v":{"$error":"#REF!"}},{"$f":"W16+G16/100000000","v":{"$error":"#REF!"}},{"$f":"RANK(I16,I$16:I$22,1)","v":{"$error":"#REF!"}},{"$f":"X16+G16/100000000","v":{"$error":"#REF!"}},{"$f":"RANK(K16,K$16:K$22,1)","v":{"$error":"#REF!"}},{"$f":"Y16+G16/100000000","v":{"$error":"#REF!"}},{"$f":"RANK(M16,M$16:M$22,1)","v":{"$error":"#REF!"}},{"$f":"Z16+G16/100000000","v":{"$error":"#REF!"}},{"$f":"RANK(O16,O$16:O$22,1)","v":{"$error":"#REF!"}},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B16=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B16=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B16=\"None\",T16=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B16=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B16=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B16=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(B17=\"None\",+'Aesthetics Judging'!A20,9999)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B17=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B17=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B17=\"None\",T17=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B17=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B17=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B17=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(B18=\"None\",+'Aesthetics Judging'!A21,9999)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B18=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B18=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B18=\"None\",T18=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B18=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B18=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B18=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(B19=\"None\",+'Aesthetics Judging'!A22,9999)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B19=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B19=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B19=\"None\",T19=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B19=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B19=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B19=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(B20=\"None\",+'Aesthetics Judging'!A23,9999)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B20=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B20=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B20=\"None\",T20=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B20=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B20=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B20=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(B21=\"None\",+'Aesthetics Judging'!A24,9999)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B21=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B21=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B21=\"None\",T21=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B21=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B21=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B21=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(B22=\"None\",+'Aesthetics Judging'!A25,9999)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B22=\"None\",#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B22=\"None\",#REF!,9999)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B22=\"None\",T22=\"Passed\"),#REF!,9999.99)","v":{"$error":"#REF!"}},{"$f":"IF(B22=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B22=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}},{"$f":"IF(B22=\"None\",#REF!,999999999)","v":{"$error":"#REF!"}}]

{"sheet":"Lookuptables","index":6,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"}]
[null,"Disqualification Table"]
[]
[null,null,"Rule that is grounds for declaration of ineligibility"]
[null,0,"None"]
[null,1,"   3:","Bridge is unsuitable for intended purpose. (May be determined after form is printed)",null,null,null,null,null,"   3: Bridge is unsuitable for intended purpose. (May be determined after form is printed)"]
[null,2,"   4:","Did not participate in competition (Construction time = 0 or \"Participants\" page = No) ",null,null,null,null,null,"   4: Did not participate in competition (Construction time = 0 or \"Participants\" page = No) "]
[null,3,"   5:","Judges deem the bridge unsafe to compete for any reason",null,null,null,null,null,"   5: Judges deem the bridge unsafe to compete for any reason"]
[null,4,"   8.1:","Member uses material not magnetically attractive",null,null,null,null,null,"   8.1: Member uses material not magnetically attractive"]
[null,5,"   9.2.1:","Bridge does not provide continuous stringers along both sides",null,null,null,null,null,"   9.2.1: Bridge does not provide continuous stringers along both sides"]
[null,6,"   9.2.2:","Bridge does not provide access for safely placing decking & load",null,null,null,null,null,"   9.2.2: Bridge does not provide access for safely placing decking & load"]
[null,7,"   9.2.3:","Decking attached/anchored to bridge",null,null,null,null,null,"   9.2.3: Decking attached/anchored to bridge"]
[null,8,"   9.2.4:","Decking distorts the bridge",null,null,null,null,null,"   9.2.4: Decking distorts the bridge"]
[null,9,"   9.2.5:","Bridge is anchored or tied to ground",null,null,null,null,null,"   9.2.5: Bridge is anchored or tied to ground"]
[null,10,"   9.2.6:","Bridge cannot accommodate local conditions",null,null,null,null,null,"   9.2.6: Bridge cannot accommodate local conditions"]
[null,11,"   9.3:","Excessive dimensional violation",null,null,null,null,null,"   9.3: Excessive dimensional violation"]
[null,12,"   9.4:","Connections cannot be fixed within five minute limit",null,null,null,null,null,"   9.4: Connections cannot be fixed within five minute limit"]
[null,13,"   10.2.1:","Someone other than builders & judges in construction site",null,null,null,null,null,"   10.2.1: Someone other than builders & judges in construction site"]
[null,14,"   10.2.2:","More than six builders",null,null,null,null,null,"   10.2.2: More than six builders"]
[null,15,"   10.2.3:","Illegal tools (external power)",null,null,null,null,null,"   10.2.3: Illegal tools (external power)"]
[null,16,"   10.2.4:","Illegal tool (weight, size)",null,null,null,null,null,"   10.2.4: Illegal tool (weight, size)"]
[null,17,"   10.2.5:","Lubricant on site",null,null,null,null,null,"   10.2.5: Lubricant on site"]
[null,18,"   10.3.1:","Exposure to personal injury",null,null,null,null,null,"   10.3.1: Exposure to personal injury"]
[null,19,"   10.3.2:","Improper wearing of personal protective equipment (See 10.1.5)",null,null,null,null,null,"   10.3.2: Improper wearing of personal protective equipment (See 10.1.5)"]
[null,20,"   10.3.3:","Pouch or clothing being removed/held in hands",null,null,null,null,null,"   10.3.3: Pouch or clothing being removed/held in hands"]
[null,21,"   10.3.4:","Builder holding nuts, bolts, or tools in mouth",null,null,null,null,null,"   10.3.4: Builder holding nuts, bolts, or tools in mouth"]
[null,22,"   10.3.5:","Items being thrown",null,null,null,null,null,"   10.3.5: Items being thrown"]
[null,23,"   10.3.6:","Builder crossing river",null,null,null,null,null,"   10.3.6: Builder crossing river"]
[null,24,"   10.3.7:","Builder simultaneously touching more than one member",null,null,null,null,null,"   10.3.7: Builder simultaneously touching more than one member"]
[null,25,"   10.3.8:","A builder using the bridge, member, or tool for physical support",null,null,null,null,null,"   10.3.8: A builder using the bridge, member, or tool for physical support"]
[null,26,"   10.3.9:","A builder using other builder(s) for support",null,null,null,null,null,"   10.3.9: A builder using other builder(s) for support"]
[null,27,"   10.3.10:","Improper sequence of constructing CP",null,null,null,null,null,"   10.3.10: Improper sequence of constructing CP"]
[null,28,"   10.3.11:","Builder constructing outside construction zone",null,null,null,null,null,"   10.3.11: Builder constructing outside construction zone"]
[null,29,"   10.3.12:","Builder(s) supporting entire weight of construction portion",null,null,null,null,null,"   10.3.12: Builder(s) supporting entire weight of construction portion"]
[null,30,"   10.3.13:","Constructed portion extending beyond site boundary",null,null,null,null,null,"   10.3.13: Constructed portion extending beyond site boundary"]
[null,31,"   10.3.14:","Cannot accommodate local conditions",null,null,null,null,null,"   10.3.14: Cannot accommodate local conditions"]
[null,32,"   10.4:","Intentionally causing an accident",null,null,null,null,null,"   10.4: Intentionally causing an accident"]
[null,33,"   10.6.2:","Adding/removing items or builders to/from site",null,null,null,null,null,"   10.6.2: Adding/removing items or builders to/from site"]
[null,34,"   10.8.2:","Construction Time Limit Exceeded",null,null,null,null,null,"   10.8.2: Construction Time Limit Exceeded"]
[null,35,"   10.9.2:","Illegal disassembled tool (weight, size)",null,null,null,null,null,"   10.9.2: Illegal disassembled tool (weight, size)"]
[null,36,"   11.1:","Damage affecting strength or stability anytime after construction (including during transport)",null,null,null,null,null,"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"]
[null,37,"   11.2.1.1:","Unsafe loading procedure",null,null,null,null,null,"   11.2.1.1: Unsafe loading procedure"]
[null,38,"   11.2.1.3:","Competitors not wearing required safety gear",null,null,null,null,null,"   11.2.1.3: Competitors not wearing required safety gear"]
[null,39,"   11.2.3.7:","Vertical load cannot be safely placed on bridge",null,null,null,null,null,"   11.2.3.7: Vertical load cannot be safely placed on bridge"]
[null,40,"   11.3:","Bridge cannot be loaded safely or sway/defl cannot be measured",null,null,null,null,null,"   11.3: Bridge cannot be loaded safely or sway/defl cannot be measured"]
[null,41,"   11.4:","Failed lateral load test",null,null,null,null,null,"   11.4: Failed lateral load test"]
[null,42,"   11.5:","Excessive deflection/sway or loading stopped by judges",null,null,null,null,null,"   11.5: Excessive deflection/sway or loading stopped by judges"]
[null,43,"   11.6:","Bridge collapses during unloading",null,null,null,null,null,"   11.6: Bridge collapses during unloading"]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]

{"sheet":"AestheticsJudgeForm","index":7,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["2019 AISC Student Steel Bridge Competition Aesthetics Scoring"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"}]
[]
["Judge Name: ________________________________________"]
[]
["Instructions:"]
["   Score appearance 0 = absent, 1 = least attractive, 10 = most attractive"]
["   Check to ensure that the name on the bridge is per rules section 6.2.1.2"]
["   Assign a score between 0 and 5 to the poster:"]
[null,"with 0 = No Poster,"]
[null,"with 1 = Poor compliance & quality, "]
[null,"with 3 = Fair compliance & quality,"]
[null,"with 5 = Perfect compliance & quality."]
[]
["   All Display Judges must agree on a \"No\" for section 6.2.1.2 and a score of \"0\" for section 6.2.1.3"]
[null,null,"6.2.1.1","6.2.1.2","6.2.1.3"]
["School",null,"Appearance","Name","Poster Score"]
[null,null,"(0-10)","Y/N","(0-5)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+C16","v":"6.2.1.1"},{"$f":"+D16","v":"6.2.1.2"},{"$f":"+E16","v":"6.2.1.3"}]
["School",null,"Appearance","Name","Poster Score"]
[null,null,"(0-10)","Y/N","(0-5)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Aesthetics Judging'!C65","v":0}]
[{"$f":"+'Aesthetics Judging'!C66","v":0}]
[{"$f":"+'Aesthetics Judging'!C67","v":0}]

{"sheet":"Aesthetics Judging","index":8,"n_rows":81,"n_cols":29,"rows_kept":81,"cut":false,"hidden":true,"merged":[[15,15,15,22],[16,3,17,3],[15,26,17,26],[15,27,17,27],[15,28,17,28],[16,15,16,20],[15,12,17,12],[15,13,16,14],[16,4,16,9],[15,24,17,24],[15,25,17,25],[15,4,15,11],[16,11,17,11],[16,22,17,22]]}
["2019 AISC Student Steel Bridge Competition Aethetics Scoring"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"},null,null,null,null,null,null,{"$f":"+'Start Here!!!!'!D11","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,null,null,"Note that, in order to automatically break ties in the categories, the Aesthetics score is included in each of the final"]
[null,null,null,null,null,null,null,{"$f":"+'Start Here!!!!'!D12","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"},null,null,null,null,null,null,"category scores by taking each actual score and adding (Aesthetics score)/100000000 to it."]
[null,"Note that the rules don't provide specific information on how to assign aesthetics",null,null,null,null,null,{"$f":"+'Start Here!!!!'!D13","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,null,null,"This action does not significantly alter the final scores but makes sufficient difference for the ranking function to "]
[null,"rankings.  Each host can devise their own method.",null,null,null,null,null,null,null,null,null,null,null,null,"break all ties."]
[null,"This spreadsheet accepts input from up to six judges who would do three things:"]
[null,1,"Individually score the bridge appearance (see \"Start Here!!!!\" sheet or  www.aisc.org/ssbc)",null,null,null,null,null,"If you decide not to use this sheet to compute aesthetics scores"]
[null,2,"Collectively determine if 6.2.1.2 is satisfied",null,null,null,null,null,"you still need to use this sheet to run the rankings."]
[null,3,"Individually determine a score (0-5) for section 6.2.1.3",null,null,null,null,null,"To do this, unprotect the sheet, enter final rankings in column A by the team names."]
[null,null,"the values are to be input to the cyan colored cells",null,null,null,null,null,"You must still use columns M and O to apply aesthetics penalties."]
[]
[null,null,"Any ties in the final aesthetics ranking may be broken by a vote of the judges OR by using the \"Find & Break Ties\". The spreadsheet then can be altered by manually adding a very small number to the value in column 'Z' to break the tie in the spreadsheet."]
[]
[null,null,"<ctrl><d> prints judges forms.",null,"Score: 0 = No Show, 1 = Least Attractive, 10 = Most Attractive",null,null,null,null,null,null,null,null,"Mult value",1,"Score: 0 = No Poster, 1=Poor, 3 = Fair, 5 = Perfect",null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(K19:K72,\">0\")","v":0},null,null,{"$f":"COUNTIF(N19:N70,\"Y\")","v":0}]
["Final",null,null,null,"Section 6.2.1.1 Appearance Score",null,null,null,null,null,null,null,"Rank without 6.2.1.2","6.2.1.2 School Name",null,"Section 6.2.1.3 Poster Score",null,null,null,null,null,null,null,null,"Adjusted 6.2.1.3","Tie Breaker Score","Ranking Score","Final Rank","Effect of Poster on Rank"]
["Aesthetics",null,null,"DQ","Judges Scoring",null,null,null,null,null,"Average","Std Dev",null,null,null,"Judges Scoring",null,null,null,null,null,"Average","Std Dev"]
["Ranking",null,null,null,"Judge 1","Judge 2","Judge 3","Judge 4","Judge 5","Judge 6",{"$f":"SUMIF(K19:K72,\">0\")/COUNTIF(K19:K72,\">0\")","v":{"$error":"#DIV/0!"}},null,null,"Y/N","Multiplier",{"$f":"E18","v":"Judge 1"},{"$f":"+F18","v":"Judge 2"},{"$f":"+G18","v":"Judge 3"},{"$f":"+H18","v":"Judge 4"},{"$f":"+I18","v":"Judge 5"},{"$f":"+J18","v":"Judge 6"},{"$f":"SUMIF(V19:V72,\">0\")/COUNTIF(V19:V72,\">0\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(AB19 > 0, AB19,\"---\")","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},1,6,6,8.3000000000000007,3,7,{"$f":"IF(D19=\"None\",AVERAGE(E19:J19),-9999)","v":{"$error":"#REF!"}},{"$f":"STDEV(E19:J19)","v":2.7058578430262501},{"$f":"RANK(K19,K$19:K$25,0)","v":{"$error":"#REF!"}},"N",{"$f":"IF(N19=\"Y\",O$14,1)","v":1},1,4,2,4,2,4,{"$f":"IF(D19=\"None\",AVERAGE(P19:U19),-9999)","v":{"$error":"#REF!"}},{"$f":"STDEV(P19:U19)","v":1.3291601358251259},null,{"$f":"V19/Y$14","v":{"$error":"#REF!"}},0,{"$f":"(K19+Y19)*O19*IF(V19<1,0.2,1)+Z19","v":{"$error":"#REF!"}},{"$f":"IF(AA19>0,RANK(AA19,AA$19:AA$25,0),-1)","v":{"$error":"#REF!"}},{"$f":"+AB19-M19","v":{"$error":"#REF!"}}]
[{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},2.5,6,6,8.3000000000000007,3,7,{"$f":"IF(D20=\"None\",AVERAGE(E20:J20),-9999)","v":{"$error":"#REF!"}},{"$f":"STDEV(E20:J20)","v":2.2730302828309776},{"$f":"RANK(K20,K$19:K$25,0)","v":{"$error":"#REF!"}},"N",{"$f":"IF(N20=\"Y\",O$14,1)","v":1},1,4,2,4,2,4,{"$f":"IF(D20=\"None\",AVERAGE(P20:U20),-9999)","v":{"$error":"#REF!"}},{"$f":"STDEV(P20:U20)","v":1.3291601358251259},null,{"$f":"V20/Y$14","v":{"$error":"#REF!"}},0,{"$f":"(K20+Y20)*O20*IF(V20<1,0.2,1)+Z20","v":{"$error":"#REF!"}},{"$f":"IF(AA20>0,RANK(AA20,AA$19:AA$25,0),-1)","v":{"$error":"#REF!"}},{"$f":"+AB20-M20","v":{"$error":"#REF!"}}]
[{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},4,6,6,8.3000000000000007,3,7,{"$error":"#REF!"},1.9395016542057082,{"$error":"#REF!"},"N",1,1,4,2,4,2,4,{"$error":"#REF!"},1.3291601358251259,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},5.5,6,6,8.3000000000000007,3,7,{"$error":"#REF!"},1.7625738755203062,{"$error":"#REF!"},"N",1,1,4,2,4,2,4,{"$error":"#REF!"},1.3291601358251259,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},7,6,6,8.3000000000000007,3,7,{"$error":"#REF!"},1.7893201688537119,{"$error":"#REF!"},"N",1,1,4,2,4,2,4,{"$error":"#REF!"},1.3291601358251259,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},8.5,6,6,8.3000000000000007,3,7,{"$error":"#REF!"},2.0116328359486157,{"$error":"#REF!"},"N",1,1,4,2,4,2,4,{"$error":"#REF!"},1.3291601358251259,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},10,6,6,8.3000000000000007,3,7,{"$error":"#REF!"},2.3752192881219778,{"$error":"#REF!"},"N",1,1,4,2,4,2,4,{"$error":"#REF!"},1.3291601358251259,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sorted by Rank, Aesthetics Std Dev, Poster Std Dev, Name"]
["---",-2999.7000000000003,1.3291601358251259,1.7625738755203062,22,"North Pole City College"]
["---",-2999.7000000000003,1.3291601358251259,1.7893201688537119,23,"Ice Ridge University",null,null,null,-9.9999997473787516E-5]
["---",-2999.7000000000003,1.3291601358251259,1.9395016542057082,21,"Polar State University",null,null,null,-1.9999999494757503E-4]
["---",-2999.7000000000003,1.3291601358251259,2.0116328359486157,24,"University of Plain Fun",null,null,null,-2.9999998514540493E-4]
["---",-2999.7000000000003,1.3291601358251259,2.2730302828309776,20,"Glacier University",null,null,null,-3.9999998989515007E-4]
["---",-2999.7000000000003,1.3291601358251259,2.3752192881219778,25,"My University",null,null,null,-4.9999996554106474E-4]
["---",-2999.7000000000003,1.3291601358251259,2.7058578430262501,19,"University of Snow",null,null,null,-5.9999997029080987E-4]

{"sheet":"Awards Ceremony","index":9,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Final Results"]
[{"$f":"+'Start Here!!!!'!D11","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
[]
["Note ties are broken by the Aesthetics score."]
[]
["Construction Speed"]
[1,{"$f":"Rankings!D16","v":{"$error":"#REF!"}},{"$f":"Rankings!E16","v":{"$error":"#REF!"}},"min"]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},"min"]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},"min"]
[]
["Lightness"]
[1,{"$f":"Rankings!G16","v":{"$error":"#REF!"}},{"$f":"Rankings!H16","v":{"$error":"#REF!"}},"lbs"]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},"lbs"]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},"lbs"]
[]
["Stiffness"]
[1,{"$f":"Rankings!M16","v":{"$error":"#REF!"}},{"$f":"Rankings!N16","v":{"$error":"#REF!"}},"in"]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},"in"]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},"in"]
[]
["Aesthetics"]
[1,{"$f":"Rankings!J16","v":{"$error":"#REF!"}}]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[]
["Economy"]
[1,{"$f":"Rankings!P16","v":{"$error":"#REF!"}},{"$f":"Rankings!Q16","v":{"$error":"#REF!"}}]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[]
["Efficiency"]
[1,{"$f":"Rankings!S16","v":{"$error":"#REF!"}},{"$f":"Rankings!T16","v":{"$error":"#REF!"}}]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[]
["Overall"]
[1,{"$f":"Rankings!V16","v":{"$error":"#REF!"}},{"$f":"Rankings!W16","v":{"$error":"#REF!"}}]
[2,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]
[3,{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}},{"$f":"Rankings!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"SchoolBase","index":10,"n_rows":165,"n_cols":19,"rows_kept":165,"cut":false,"hidden":true,"merged":[[7,5,7,6]]}
["2018 AISC Student Steel Bridge Competition Input from Judging Data Forms",null,null,null,null,null,null,null,null,null,"2019 AISC Student Steel Bridge Competition Team Score Computation Sheet - page 1/2"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"},null,null,null,null,null,null,null,null,null,"Competition:",{"$f":"+Summary!B6","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
["School:",{"$f":"Participants!C10","v":"Glacier University"},null,null,"Instructions:","Input data from judges forms into cyan cells.",null,null,null,null,"Location:",{"$f":"+Summary!B7","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"}]
[null,"Faculty Advisor Name:",null,null,null,"Do not input data into any other cell.",null,null,null,null,"Date:",{"$f":"+Summary!B8","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,{"$f":"+A2","v":"Version Date:  11/5/2018"}]
[null,"Faculty Advisor Email:"]
[null,"Faculty Advisor Phone #:",null,null,null,null,null,null,null,null,"School:",{"$f":"+B3","v":"Glacier University"}]
[null,"Contact name at event:",null,null,null,"Contact's phone # at event:"]
[null,"Contact's email:",null,null,"Contact's Title:"]
["Eligibility Requirements",null,null,null,null,null,null,null,null,null,null,"Guest?","Participated in competition?"]
["See rule 4.4 - Eligibility data entered separately on 'Participants' sheet.",null,null,null,null,null,null,null,null,null,null,{"$f":"Participants!E9","v":"Don't Know"},{"$f":"Participants!F9","v":"Yes"}]
[null,null,null,null,null,null,null,null,null,null,null,"**Data from \"Participants\" sheet"]
["Aesthetics Scores"]
[" --- Aesthetics data is entered separately on the Aesthetics Judging Page"]
["   6.2.1.1:  Average of Appearance Scores",null,null,null,{"$f":"+'Aesthetics Judging'!K19","v":{"$error":"#REF!"}},"(0=Missing, 1=Least Appealing, 10=The Best)",null,null,null,null,"A.  Construction Speed (Rule 6.2.2)",null,null,null,null,"Clock","Clock","Comp. Time"]
["   6.2.1.2:  Name on bridge meets suggested criteria",null,null,null,{"$f":"+'Aesthetics Judging'!N19","v":"N"},null,null,null,null,null,null,null,null,null,null,"(Hr:Min:Sec)","decimal time","decimal time"]
["   6.2.1.3:  Poster meets the specification",null,null,null,{"$f":"'Aesthetics Judging'!V19","v":{"$error":"#REF!"}},"(0=Missing, 1=Very Poor, 5=Excellant)",null,null,null,null,null,"10.8: Time (Hr:Min:Sec)",null,null,"Construction Time",{"$f":"+D80","v":"00:00:00"},{"$f":"(HOUR(P16)*60+MINUTE(P16)+SECOND(P16)/60)","v":0},{"$f":"Q16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.8.1 Overtime Penalty",null,null,{"$f":"IF(Q16>30,IF(Q16<=45,180,0),0)","v":0}]
["Pre-Construction Check",null,null,null,null,null,"Print Score Computation Sheet for",null,null,null,null,null,null,null,"10.8.2 Overtime Penalty",null,null,{"$f":"IF(Q16>45,9999,0)","v":0}]
[null,null,null,null,null,null,"for each team when done!"]
["Section 8:  Materials & Components",null,null,null,null,null,"press <Cntrl><Shft><s>",null,null,null,null,null,null,null,null,"Competition Time before accidents or damage:",null,{"$f":"IF(R18>0,R18,IF(R17>0,R17,R16))","v":0},"minutes"]
[null,null,null,null,null,"Number of"]
[null,null,null,null,null,"Components",null,null,null,null,null,"Section 10.9: Finish"]
[null,null,null,null,null,"in Violation",null,null,null,null,null,null,null,null,null,"Unit Time","Occurred","decimal time"]
["   8.2.1: Member fabricated with adhesive, solder, or brazing",null,null,null,null,null,null,null,null,null,null,null,null,null,"10.9.2: Illegal disassembled tool (weight, size)",5,{"$f":"+E119","v":0},{"$f":"IF(Q24=\"Y\", P24,0)","v":0}]
["   8.2.2.1: Member fails rigidity requirement; loose parts, and/or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total 10.9 Penalty time",{"$f":"SUM(R24)","v":0},"minutes"]
["   8.2.2.2: Member dimensional violations, and/or"]
["   8.2.2.3: Non-continuous threads, and/or",null,null,null,null,null,null,null,null,null,null,"Section 9.4 Penalties:",null,null,null,"Unit Time","Number","decimal time"]
["   8.2.5: Member hole is threaded",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A113","v":"   9.4.1: Members touch but not connected"},5,{"$f":"+E113","v":0},{"$f":"+P28*Q28","v":0}]
["   8.2.3.1: Violates bolt specification: Modified or not commercial",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A114","v":"   9.4.2: Nuts not fully engaged"},5,{"$f":"+E114","v":0},{"$f":"+P29*Q29","v":0}]
["   8.2.3.2: Violates bolt specification: Too long or incomplete threads",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A115","v":"   9.4.3: Holes are too big or incomplete"},5,{"$f":"+E115","v":0},{"$f":"+P30*Q30","v":0}]
["   8.2.4.1: Violates nut specification: Modified or not commercial",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A116","v":"   9.4.4: Nut/Bolt head not in contact with member"},1,{"$f":"+E116","v":0},{"$f":"+P31*Q31","v":0}]
["   8.2.4.2: Violates nut specification: Incomplete threads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total 9.4 Penalty time",{"$f":"SUM(R28:R31)","v":0},"minutes"]
[]
["Check members.  Tape or mark potentially adjustable parts (see 8.2.2.1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Const."]
[null,null,null,null,null,null,null,null,null,null,null,"Section 10.4 Accidents",null,null,null,"Unit Time","Number","decimal time"]
["Bridge will not be ranked if the bridge cannot be built without/because:  (Select applicable rule if ruled ineligible)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A74","v":"   10.4.2: Item illegally touches river/ground/floor"},0.25,{"$f":"+F74","v":0},{"$f":"+P36*Q36","v":0}]
[null,{"$f":"+L118","v":"   8.1: Member uses material not magnetically attractive"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A75","v":"   10.4.3: Non-CP members touch outside staging yard"},0.25,{"$f":"+F75","v":0},{"$f":"+P37*Q37","v":0}]
[null,{"$f":"+L131","v":"   10.2.3: Illegal tools (external power)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total 10.4 Penalty time",{"$f":"SUM(R36:R37)","v":0},"minutes"]
[null,{"$f":"+L132","v":"   10.2.4: Illegal tool (weight, size)"}]
[null,{"$f":"+L133","v":"   10.2.5: Lubricant on site"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Time:",{"$f":"IF(SUM(K112,K114:K159)>0,\"NR\",IF(R20<9999,R20+R25+R32+R38,9999))","v":"NR"},"minutes"]
[]
["TOTAL Number of BUILDERS (10.2.2):",null,null,1,"Builders",null,null,null,null,null,"B.  Lightness (Rule 6.2.3)"]
[]
["Construction Judging",null,null,null,null,null,null,null,null,null,null,"Bridge Weight:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pier 1","Pier 2","Actual Wt"]
["Bridge will not be ranked if the bridge cannot be built without/because:  (Select applicable rule if ruled ineligible)",null,null,null,null,null,null,null,null,null,null,null,null,"Side 1",{"$f":"+D159","v":0},{"$f":"+E159","v":0},{"$f":"+O46+P46","v":0},"lbs"]
[null,{"$f":"+L116","v":"   5: Judges deem the bridge unsafe to compete for any reason"},null,null,null,null,null,null,null,null,null,null,null,"Side 2",{"$f":"+D160","v":0},{"$f":"+E160","v":0},{"$f":"+O47+P47","v":0},"lbs"]
[null,{"$f":"+L125","v":"   9.2.6: Bridge cannot accommodate local conditions"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"+Q46+Q47","v":0},"lbs"]
[null,{"$f":"+L129","v":"   10.2.1: Someone other than builders & judges in construction site"}]
[null,{"$f":"+L130","v":"   10.2.2: More than six builders"},null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 8.2",null,null,"Violations","Penalty","8.2 Weight"]
[null,"   10.2.3: Illegal tools (external power)",null,null,null,null,null,null,null,null,null,null,null,"Non-Compliant Member",{"$f":"SUM(F24:F28)","v":0},35,{"$f":"O51*P51","v":0},"lbs"]
[null,{"$f":"+L132","v":"   10.2.4: Illegal tool (weight, size)"},null,null,null,null,null,null,null,null,null,null,null,"Non-Compliant Nut/Loose Bolt",{"$f":"SUM(F29:F32)","v":0},25,{"$f":"O52*P52","v":0},"lbs"]
[null,"   10.2.5: Lubricant on site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Q51+Q52","v":0},"lbs"]
[null,"   10.3.1: Exposure to personal injury"]
[null,"   10.3.2: Improper wearing of personal protective equipment (See 10.1.5)",null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 9.3"]
[null,"   10.3.3: Pouch or clothing being removed/held in hands",null,null,null,null,null,null,null,null,null,null,null,"< 1/4\"","> 1/4\" to < 1\"","> 1\" to < 2\"","Total"]
[null,"   10.3.4: Builder holding nuts, bolts, or tools in mouth",null,null,null,null,null,null,null,null,null,"Num. of Rules Violated",null,{"$f":"+D107","v":0},{"$f":"+E107","v":0},{"$f":"+F107","v":0},"9.3 Wt"]
[null,"   10.3.5: Items being thrown",null,null,null,null,null,null,null,null,null,"Unit Penalty Weight",null,20,100,200]
[null,"   10.3.6: Builder crossing river",null,null,null,null,null,null,null,null,null,"Penalty Wt.",null,{"$f":"+N57*N58","v":0},{"$f":"+O57*O58","v":0},{"$f":"+P57*P58","v":0},{"$f":"+N59+O59+P59","v":0}]
[null,"   10.3.7: Builder simultaneously touching more than one member"]
[null,"   10.3.8: A builder using the bridge, member, or tool for physical support",null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 9.5",null,null,"Violations","Penalty","9.5 Weight"]
[null,"   10.3.9: A builder using other builder(s) for support",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E118","v":0},25,{"$f":"O62*P62","v":0}]
[null,"   10.3.10: Improper sequence of constructing CP"]
[null,"   10.3.11: Builder constructing outside construction zone",null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 10.4.2",null,null,{"$f":"IF(F77=\"Y\",\"Bridge wouldn't stay in ftg\",\"\")","v":""},null,{"$f":"IF(F77=\"Yes\", 200,0)","v":0}]
[null,"   10.3.12: Builder(s) supporting entire weight of construction portion"]
[null,"   10.3.13: Constructed portion extending beyond site boundary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Weight (with penalties) =",{"$f":"IF(SUM(K112,K114:K159)>0,\"NR\",Q48+Q59+Q62+Q53+Q64)","v":"NR"},"lbs"]
[null,"   10.3.14: Cannot accommodate local conditions"]
[null,"   10.4: Intentionally causing an accident",null,null,null,null,null,null,null,null,"C. Aesthetics (Rule 6.2.1)"]
[null,"   10.6.2: Adding/removing items or builders to/from site",null,null,null,null,null,null,null,null,null,null,"To be announced separately"]
[]
["Section 10.4 Accidents",null,null,null,null,"During Construction",null,null,null,null,"D. Stiffness (Rule 6.2.4)"]
["Only record accidents which occur in the first 30 minutes",null,null,null,null,"Number",null,null,null,null,null,null,null,{"$f":"IF(C140=\"Fail\",\"Failed\",\"Passed\")","v":"Passed"},"Lateral Load Test"]
["   10.4.1: Builder touches river or floor outside construction boundary",null,null,null,null,null,null,null,null,null,null,"Vertical Load Test"]
["   10.4.2: Item illegally touches river/ground/floor",null,null,null,null,null,null,null,null,null,null,null,null,"Gage Reading",{"$f":"+D144","v":"D1"},"D2","Total"]
["   10.4.3: Non-CP members touch outside staging yard",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C145","v":"Initial Reading w/preload on bridge"},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C146","v":"End of Loading"},0,0]
["   10.4.2: Team demonstrates that bearing surface cannot stay in footing",null,null,null,null,null,null,null,null,null,null,null,null,"11.5 Value",{"$f":"ABS(O76-O75)","v":0},{"$f":"ABS(P76-P75)","v":0},{"$f":"SUM(O77:P77)","v":0},"in"]
[]
[null,null,null,"(Hr:Min:Sec)",null,null,null,null,null,null,null,null,null,null,null,null," Aggregate Deflection = ",{"$f":"IF(SUM(K112,K114:K159)>0,\"NR\",ROUND(Q77,2))","v":"NR"},"in"]
[null,null,"10.7 Construction Clock Time","00:00:00",null,null,null,null,null,null,null,null,null,null,null,null,"rounded to nearest 0.01\" (Rule 11.5)"]
[null,null,null,null,null,null,null,null,null,null,"2019 AISC Student Steel Bridge Competition Team Score Computation Sheet - page 2/2"]
["Post-Construction Check",null,null,null,null,null,null,null,null,null,{"$f":"+L2","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L6","v":"Glacier University"}]
["Section 9: Structural Specifications"]
[null,null,null,null,null,null,null,null,null,null,"E. Construction Economy (Rule 6.2.5)"]
["The bridge is not to be ranked if any of the following rules are violated:  (Select all that apply)"]
[null,{"$f":"+L112","v":"   3: Bridge is unsuitable for intended purpose"},null,null,null,null,null,null,null,null,"Cc =",{"$f":"+D42","v":1},"bldrs    x",{"$f":"MAX(0,R40)","v":0},"min. x",60000,"/bldr-min ",{"$f":"+L87*N87*P87","v":0},"w/o penalties"]
[null,{"$f":"+L120","v":"   9.2.1: Bridge does not provide continuous stringers along both sides"},null,null,null,null,null,null,null,null,"10.4.1 Penalty",{"$f":"+F73","v":0},"bldrs    x",{"$f":"+N87","v":0},"min. x",60000,"/bldr-min ",{"$f":"+L88*N88*P88","v":0}]
[null,{"$f":"+L125","v":"   9.2.6: Bridge cannot accommodate local conditions"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.5.2 penalty for excessive deflection",{"$f":"IF(MAX(O77:P77)>2,4000000,0)","v":0}]
[null,{"$f":"+L127","v":"   9.4: Connections cannot be fixed within five minute limit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final  Cc =",{"$f":"IF(SUM(K112,K114:K159)>0,\"NR\",SUM(R87:R89))","v":"NR"}]
[null,{"$f":"+L152","v":"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"},null,null,null,null,null,null,null,null,"F.  Structural Efficiency (Rule 6.2.6)"]
[]
["Select a \"Y\" for all rules violated, the number of violations for each rule is not relevant (Rule 9.3). ",null,null,null,null,null,null,null,null,null,"Cs  =",null,"Rule 6.2.6 Formula Weight",{"$f":"MAX(IF(Q48<=120,R66-Q48,IF(Q48<=200,R66-120,R66-184)),0)","v":{"$error":"#VALUE!"}},"lbs      x",{"$f":"IF(Q48<=120,5000,IF(Q48<=200,5000,25000))","v":5000},"/lb =",{"$f":"N93*P93","v":{"$error":"#VALUE!"}}]
["Record only the largest violation for each rule!",null,null,null,null,null,null,null,null,null,null,null,"Aggregate D ",{"$f":"MAX(0,R79)","v":0},"in       x",3250000,"/in =",{"$f":"+N94*P94","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.5.2 penalty for excessive deflection",{"$f":"IF(MAX(O77,P77)>2,10000000,0)","v":0}]
["   Usability Dimensional Violations",null,null,"< 1/4\"","> 1/4\" to < 1\"","> 1\" to < 2\"","> 2\" NR",null,null,null,null,null,null,null,null,null,"Final Cs  =",{"$f":"IF(SUM(K112,K114:K159)>0,\"NR\",SUM(R93:R95))","v":"NR"}]
["   9.3.1: Bridge touches ground outside of footings",null,null,null,null,null,null,{"$f":"IF(COUNTIF(D97:G97,\"Y\")>1,\"Record only the greatest\",\"\")","v":""}]
["   9.3.2: Bridge taller than 5'0\"",null,null,null,null,null,null,{"$f":"IF(COUNTIF(D98:G98,\"Y\")>1,\"Record only the greatest\",\"\")","v":""},null,null,"G. Overall Performance (Rule 6.2.7)",null,null,null,null,null,"Team Contract Fine",{"$f":"E165","v":0}]
["   9.3.3: Bridge is wider than 5'0\"",null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Overall Performance: Cc + Cs + Team Contract Fine",{"$f":"IF(SUM(K112,K114:K159)>0,\"NR\",R90+R96+R98)","v":"NR"}]
["   9.3.4: River/ground clearance < 7.5\"",null,null,null,null,null,null,""]
["   9.3.5: Stringer elev. not between 19\" and 23\"",null,null,null,null,null,null,"",null,null,"H.  General Compliance with The Problem Statement Intent (Rule 3)"]
["   9.3.6: Stringer < 22 ft",null,null,null,null,null,null,""]
["   9.3.8: Components extend outside const. zone",null,null,null,null,null,null,"",null,null,"The Judges/Rules Committee have the right to terminate the eligibility any bridge if the bridge is not suitable for its intended"]
["   9.3.9: Passageway clearance violation",null,null,null,null,null,null,"",null,null,"purpose as outlined in Rule 3.  This will occur before the final awards are announced and after consulting with the team captain."]
["   9.3.10: Stringers not in contact with top of rabbet",null,null,null,null,null,null,""]
["   9.3.11: Stringers have holes, splits, etc.",null,null,null,null,null,null,"",null,null,"I.  Grounds for Not Ranking:",null,null,{"$f":"IF(OR(C4=\"\",C5=\"\",C6=\"\"),\"WARNING: REQUIRED FACULTY ADVISOR INFORMATION IS MISSING IN CELLS C4-C6\",\"\")","v":"WARNING: REQUIRED FACULTY ADVISOR INFORMATION IS MISSING IN CELLS C4-C6"}]
[null,null,"Total # rules violated:  ",{"$f":"COUNTIF(D97:D106,\"=Y\")","v":0},{"$f":"COUNTIF(E97:E106,\"=Y\")","v":0},{"$f":"COUNTIF(F97:F106,\"=Y\")","v":0},{"$f":"COUNTIF(G97:G106,\"=Y\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K161=0,K161=\"NU\",K161=\"None\"),\"Your bridge was ranked.\",\"Your bridge was not ranked for violating the following rule:\")","v":"Your bridge was not ranked for violating the following rule:"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K161=\"None\",\"\",K161)","v":"   4:"},{"$f":"VLOOKUP(MAX($K$112:$K$159),IETable,3)","v":"Did not participate in competition (Construction time = 0 or \"Participants\" page = No) "}]
[null,null,null,null,"Number"]
[null,null,null,null,"of",null,null,null,null,null,"Index #"]
["Connection Safety and Tool Violations at the end of timed construction",null,null,null,"Violations",null,null,null,null,null,{"$f":"IF(OR(A87=\"NR\", A124 = \"NR\"),1,0)","v":0},"   3: Bridge is unsuitable for intended purpose",null,null,"(May be determined after form is printed)"]
["   9.4.1: Members touch but not connected"]
["   9.4.2: Nuts not fully engaged",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M10=\"Yes\",Q48>0),0,2)","v":2},"   4: Did not participate in competition (Construction time = 0 or \"Participants\" page = No) "]
["   9.4.3: Holes are too big or incomplete"]
["   9.4.4: Nut/Bolt head not in contact with member",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A47=\"NR\", A125=\"NR\"),3,0)","v":0},"   5: Judges deem the bridge unsafe to compete for any reason"]
[]
["   9.5: Number of nuts/bolts uninspectable",null,null,null,null,null,null,null,null,null,{"$f":"IF(A37=\"NR\",4,0)","v":0},"   8.1: Member uses material not magnetically attractive"]
["10.9.2: Illegal disassembled tool (weight, size)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A88=\"NR\",5,0)","v":0},"   9.2.1: Bridge does not provide continuous stringers along both sides"]
["Input from Load Station Judging Form",null,null,null,null,null,null,null,null,null,{"$f":"IF(A126=\"NR\",6,0)","v":0},"   9.2.2: Bridge does not provide access for safely placing decking & load"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A127=\"NR\",7,0)","v":0},"   9.2.3: Decking attached/anchored to bridge"]
["The bridge is not ranked if any of the following rules are violated.  Select all that apply.",null,null,null,null,null,null,null,null,null,{"$f":"IF(A128=\"NR\",8,0)","v":0},"   9.2.4: Decking distorts the bridge"]
[null,{"$f":"+L112","v":"   3: Bridge is unsuitable for intended purpose"},null,null,null,null,null,null,null,null,{"$f":"IF(A129=\"NR\",9,0)","v":0},"   9.2.5: Bridge is anchored or tied to ground"]
[null,{"$f":"+L116","v":"   5: Judges deem the bridge unsafe to compete for any reason"},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A48=\"NR\", A89 = \"NR\",A130=\"NR\"),10,0)","v":0},"   9.2.6: Bridge cannot accommodate local conditions"]
[null,{"$f":"+L121","v":"   9.2.2: Bridge does not provide access for safely placing decking & load"},null,null,null,null,null,null,null,null,{"$f":"IF(G107>0,11,0)","v":0},"   9.3: Excessive dimensional violation"]
[null,{"$f":"+L122","v":"   9.2.3: Decking attached/anchored to bridge"},null,null,null,null,null,null,null,null,{"$f":"IF(A90=\"NR\",12,0)","v":0},"   9.4: Connections cannot be fixed within five minute limit"]
[null,{"$f":"+L123","v":"   9.2.4: Decking distorts the bridge"}]
[null,{"$f":"+L124","v":"   9.2.5: Bridge is anchored or tied to ground"},null,null,null,null,null,null,null,null,{"$f":"IF(A49=\"NR\",13,0)","v":0},"   10.2.1: Someone other than builders & judges in construction site"]
[null,{"$f":"+L125","v":"   9.2.6: Bridge cannot accommodate local conditions"},null,null,null,null,null,null,null,null,{"$f":"IF(A50=\"NR\",14,0)","v":0},"   10.2.2: More than six builders"]
[null,{"$f":"+L152","v":"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A38=\"NR\",A51=\"NR\"),15,0)","v":0},"   10.2.3: Illegal tools (external power)"]
[null,{"$f":"+L153","v":"   11.2.1.1: Unsafe loading procedure"},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A39=\"NR\",A52= \"NR\"),16,0)","v":0},"   10.2.4: Illegal tool (weight, size)"]
[null,{"$f":"+L154","v":"   11.2.1.3: Competitors not wearing required safety gear"},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A40=\"NR\", A53=\"NR\"),17,0)","v":0},"   10.2.5: Lubricant on site"]
[null,{"$f":"+L155","v":"   11.2.3.7: Vertical load cannot be safely placed on bridge"},null,null,null,null,null,null,null,null,{"$f":"IF(A54=\"NR\",18,0)","v":0},"   10.3.1: Exposure to personal injury"]
[null,{"$f":"+L156","v":"   11.3: Bridge cannot be loaded safely or sway/defl cannot be measured"},null,null,null,null,null,null,null,null,{"$f":"IF(A55=\"NR\",19,0)","v":0},"   10.3.2: Improper wearing of personal protective equipment (See 10.1.5)"]
[null,{"$f":"+L159","v":"   11.6: Bridge collapses during unloading"},null,null,null,null,null,null,null,null,{"$f":"IF(A56=\"NR\",20,0)","v":0},"   10.3.3: Pouch or clothing being removed/held in hands"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A57=\"NR\",21,0)","v":0},"   10.3.4: Builder holding nuts, bolts, or tools in mouth"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A58=\"NR\",22,0)","v":0},"   10.3.5: Items being thrown"]
["Lateral Load Test",null,"Sway <= 1\"?",null,null,null,null,null,null,null,{"$f":"IF(A59=\"NR\",23,0)","v":0},"   10.3.6: Builder crossing river"]
[null,"11.4.2: Lateral Test","Pass",null,null,null,null,null,null,null,{"$f":"IF(A60=\"NR\",24,0)","v":0},"   10.3.7: Builder simultaneously touching more than one member"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A61=\"NR\",25,0)","v":0},"   10.3.8: A builder using the bridge, member, or tool for physical support"]
["Vertical Load Test (See Rule 11.5)",null,null,null,null,null,null,null,null,null,{"$f":"IF(A62=\"NR\",26,0)","v":0},"   10.3.9: A builder using other builder(s) for support"]
["Input the actual gauge readings",null,null,null,null,null,null,null,null,null,{"$f":"IF(A63=\"NR\",27,0)","v":0},"   10.3.10: Improper sequence of constructing CP"]
[null,null,null,"D1","D2",null,null,null,null,null,{"$f":"IF(A64=\"NR\",28,0)","v":0},"   10.3.11: Builder constructing outside construction zone"]
[null,null,"Initial Reading w/preload on bridge",0,0,null,null,null,null,null,{"$f":"IF(A65=\"NR\",29,0)","v":0},"   10.3.12: Builder(s) supporting entire weight of construction portion"]
[null,null,"End of Loading",0,0,null,null,null,null,null,{"$f":"IF(A66=\"NR\",30,0)","v":0},"   10.3.13: Constructed portion extending beyond site boundary"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A67=\"NR\",31,0)","v":0},"   10.3.14: Cannot accommodate local conditions"]
["11.5.2 Stop Loading Violations",null,null,null,"Loading",null,null,null,null,null,{"$f":"IF(A68=\"NR\",32,0)","v":0},"   10.4: Intentionally causing an accident"]
[null,null,null,null,11.5,null,null,null,null,null,{"$f":"IF(A69=\"NR\",33,0)","v":0},"   10.6.2: Adding/removing items or builders to/from site"]
[null,null,null,"11.5.2(a): Sway > 1\"","Not Stopped",null,null,null,null,null,{"$f":"IF(Q16>45,34,0)","v":0},"   10.8.2: Construction Time Limit Exceeded"]
[null,null,null,"11.5.2(b): Any deflection > 3\" downward","Not Stopped",{"$f":"IF(MAX(O77:P77)>=3,\"Check for excessive downward deflection!!!\",\"\")","v":""}]
[null,null,null,"11.5.2(c): Contact with Safety Support or Ground","Not Stopped",null,null,null,null,null,{"$f":"IF(OR(A91=\"NR\",A131=\"NR\"),36,0)","v":0},"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"]
[null,null,null,"11.5.2(d): Decking or load falls off bridge","Not Stopped",null,null,null,null,null,{"$f":"IF(A132=\"NR\",37,0)","v":0},"   11.2.1.1: Unsafe loading procedure"]
[null,null,null,"11.5.2(e): Collapse or dangerous imminent collapse","Not Stopped",null,null,null,null,null,{"$f":"IF(A133=\"NR\",38,0)","v":0},"   11.2.1.3: Competitors not wearing required safety gear"]
[null,null,null,null,{"$f":"IF(AND(E150=\"Not Stopped\",E151=\"Not Stopped\",E152=\"Not Stopped\",E153=\"Not Stopped\",E154=\"Not Stopped\"),\"Pass\",\"Fail\")","v":"Pass"},null,null,null,null,null,{"$f":"IF(A134=\"NR\",39,0)","v":0},"   11.2.3.7: Vertical load cannot be safely placed on bridge"]
["Input from Weigh Station Form",null,null,null,null,null,null,null,null,null,{"$f":"IF(A135=\"NR\",40,0)","v":0},"   11.3: Bridge cannot be loaded safely or sway/defl cannot be measured"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C140=\"Fail\",41,0)","v":0},"   11.4: Failed lateral load test"]
[null,"6.2.3 bridge weight ",null,"Left","Right",null,null,null,null,null,{"$f":"IF(E155=\"Fail\",42,0)","v":0},"   11.5: Excessive deflection/sway or loading stopped by judges"]
[null,null,"East End",null,null,null,null,null,null,null,{"$f":"IF(A136=\"NR\",43,0)","v":0},"   11.6: Bridge collapses during unloading"]
[null,null,"West End"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(MAX($K$112:$K$159),IETable,2)","v":"   4:"},"Rule that is grounds for not ranking"]
["Overall Performance - Team Contract Fine"]
[null,"This section is to be determined by the head judge & rules committee per Rule 6.2.7"]
[]
[null,null,null,"6.2.7: Team Contract Fine",0]

{"sheet":"First","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Last","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Stats","index":13,"n_rows":165,"n_cols":29,"rows_kept":165,"cut":false,"hidden":true,"merged":[]}
["2018 AISC Student Steel Bridge Competition Conference Summary",null,null,null,null,null,null,null,null,null,"2019 AISC Student Steel Bridge Competition Team Score Computation Sheet - page 1/2"]
[{"$f":"+'Start Here!!!!'!A2","v":"Version Date:  11/5/2018"},null,null,null,null,null,null,null,null,null,"Competition:",{"$f":"+Summary!B6","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
[null,null,null,null,null,null,null,null,null,null,"Location:",{"$f":"+Summary!B7","v":"Enter Name of Host School Here on the Start Here!!!! Sheet"}]
[null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"+Summary!B8","v":"Enter Date of Competition Here on the Start Here!!!! Sheet"},null,null,null,null,{"$f":"+A2","v":"Version Date:  11/5/2018"}]
[]
[]
[]
[]
["Eligibility Requirements",null,null,null,null,null,null,null,null,null,null,"Guest?","Participated in competition?"]
["See rule 4.4 - Eligibility data entered separately on 'Participants' sheet.",null,null,null,null,null,null,null,null,null,null,{"$f":"sumsif(\"Yes\")","v":0},{"$f":"sumsif(\"Yes\")","v":0}]
[]
["Aesthetics Scores"]
[" --- Aesthetics data is entered separately on the Aesthetics Judging Page"]
["   6.2.1.1:  Average of Appearance Scores",null,null,null,{"$f":"+'Aesthetics Judging'!K19","v":{"$error":"#REF!"}},"(0=Missing, 1=Least Appealing, 10=The Best)",null,null,null,null,"A.  Construction Speed (Rule 6.2.2)",null,null,null,null,"Clock","Clock","Comp. Time"]
["   6.2.1.2:  Name on bridge meets suggested criteria",null,null,null,{"$f":"+'Aesthetics Judging'!N19","v":"N"},null,null,null,null,null,null,null,null,null,null,"(Hr:Min:Sec)","decimal time","decimal time"]
["   6.2.1.3:  Poster meets the specification",null,null,null,{"$f":"'Aesthetics Judging'!V19","v":{"$error":"#REF!"}},"(0=Missing, 1=Very Poor, 5=Excellant)",null,null,null,null,null,"10.8: Time (Hr:Min:Sec)",null,null,"Construction Time",{"$f":"AveTeams()","v":"00:00:00"},{"$f":"(HOUR(P16)*60+MINUTE(P16)+SECOND(P16)/60)","v":0},{"$f":"AveTeams()","v":0},null,null,{"$f":"AveTeamsNum(-5)","v":0},null,{"$f":"AveTeamsNum(-5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.8.1 Overtime Penalty",null,null,{"$f":"AveTeams()","v":0},null,null,{"$f":"AveTeamsNum(-5)","v":0},null,{"$f":"AveTeamsNum(-5)","v":0}]
["Pre-Construction Check",null,null,null,null,null,null,null,null,null,null,null,null,null,"10.8.2 Overtime Penalty",null,null,0,null,null,0,null,0]
[]
["Section 8:  Materials & Components",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Competition Time before accidents or damage:",null,{"$f":"AveTeams()","v":0},"minutes",null,null,null,{"$f":"AveTeamsNum(-5)","v":0}]
[null,null,null,null,"Number of"]
[null,null,null,null,"Components",null,null,null,null,null,null,"Section 10.9: Finish"]
[null,null,null,null,"in Violation",null,null,null,null,null,null,null,null,null,null,"Unit Time","Occurred","decimal time"]
["   8.2.1: Member fabricated with adhesive, solder, or brazing",null,null,null,{"$f":"IF(SUM(First:Last!E24)>0,SUM(First:Last!E24),\"\")","v":""},null,null,null,null,null,null,null,null,null,"10.9.2: Illegal disassembled tool (weight, size)",5,{"$f":"sumsif2(\"*\")","v":0},{"$f":"AveTeams()","v":0}]
["   8.2.2.1: Member fails rigidity requirement; loose parts, and/or",null,null,null,{"$f":"IF(SUM(First:Last!E25)>0,SUM(First:Last!E25),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Total 10.9 Penalty time",{"$f":"AveTeams()","v":0},"minutes"]
["   8.2.2.2: Member dimensional violations, and/or",null,null,null,{"$f":"IF(SUM(First:Last!E26)>0,SUM(First:Last!E26),\"\")","v":""}]
["   8.2.2.3: Non-continuous threads, and/or",null,null,null,{"$f":"IF(SUM(First:Last!E27)>0,SUM(First:Last!E27),\"\")","v":""},null,null,null,null,null,null,"Section 9.4 Penalties:",null,null,null,"Unit Time","Number","decimal time"]
["   8.2.5: Member hole is threaded",null,null,null,{"$f":"IF(SUM(First:Last!E28)>0,SUM(First:Last!E28),\"\")","v":""},"member violations",null,null,null,null,null,null,null,null,{"$f":"+A113","v":"   9.4.1: Members touch but not connected"},5,{"$f":"AveTeams()","v":0},{"$f":"AveTeams()","v":0},null,null,null,{"$f":"AveTeamsNum(-5)","v":0},{"$f":"AveTeamsNum(-5)","v":0}]
["   8.2.3.1: Violates bolt specification: Modified or not commercial",null,null,null,{"$f":"IF(SUM(First:Last!E29)>0,SUM(First:Last!E29),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+A114","v":"   9.4.2: Nuts not fully engaged"},5,{"$f":"AveTeams()","v":0},0,null,null,null,{"$f":"AveTeamsNum(-5)","v":0},0]
["   8.2.3.2: Violates bolt specification: Too long or incomplete threads",null,null,null,{"$f":"IF(SUM(First:Last!E30)>0,SUM(First:Last!E30),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+A115","v":"   9.4.3: Holes are too big or incomplete"},5,0,0,null,null,null,0,0]
["   8.2.4.1: Violates nut specification: Modified or not commercial",null,null,null,{"$f":"IF(SUM(First:Last!E31)>0,SUM(First:Last!E31),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+A116","v":"   9.4.4: Nut/Bolt head not in contact with member"},1,0,0,null,null,null,0,0]
["   8.2.4.2: Violates nut specification: Incomplete threads",null,null,null,{"$f":"IF(SUM(First:Last!E32)>0,SUM(First:Last!E32),\"\")","v":""},"fastener violations",null,null,null,null,null,null,null,null,null,null,"Total 9.4 Penalty time",{"$f":"AveTeams()","v":0},"minutes",null,null,null,{"$f":"AveTeamsNum(-5)","v":0}]
[]
["Check members.  Tape or mark potentially adjustable parts (see 8.2.2.1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Const."]
[null,null,null,null,null,null,null,null,null,null,null,"Section 10.4 Accidents",null,null,null,"Unit Time","Number","decimal time"]
["Bridge will not be ranked if the bridge cannot be built without/because:  (Select applicable rule if ruled ineligible)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A74","v":"   10.4.2: Item illegally touches river/ground/floor"},0.25,{"$f":"AveTeams()","v":0},0,null,null,null,{"$f":"AveTeamsNum(-5)","v":0},0]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L118","v":"   8.1: Member uses material not magnetically attractive"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A75","v":"   10.4.3: Non-CP members touch outside staging yard"},0.25,0,0,null,null,null,0,0]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L131","v":"   10.2.3: Illegal tools (external power)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total 10.4 Penalty time",{"$f":"AveTeams()","v":0},"minutes",null,null,null,{"$f":"AveTeamsNum(-5)","v":0}]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L133","v":"   10.2.5: Lubricant on site"}]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L134","v":"   10.3.1: Exposure to personal injury"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Time:",{"$f":"AveTeams()","v":0},"minutes",null,null,null,{"$f":"AveTeamsNum(-5)","v":0}]
[]
["TOTAL Number of BUILDERS (10.2.2):",null,null,{"$f":"IF(SUM(First:Last!D41)>0,SUM(First:Last!D41),\"\")","v":""},"Builders",null,null,null,null,null,"B.  Lightness (Rule 6.2.3)"]
[]
["Construction Judging",null,null,null,null,null,null,null,null,null,null,"Bridge Weight:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pier 1","Pier 2","Actual Wt"]
["Bridge will not be ranked if the bridge cannot be built without/because:  (Select applicable rule if ruled ineligible)",null,null,null,null,null,null,null,null,null,null,null,null,"Side 1",{"$f":"AveTeams()","v":0},0,0,"lbs",null,null,{"$f":"AveTeamsNum(-6)","v":0},0,0]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L116","v":"   5: Judges deem the bridge unsafe to compete for any reason"},null,null,null,null,null,null,null,null,null,null,null,"Side 2",0,0,0,"lbs",null,null,0,0,0]
[0,{"$f":"+L125","v":"   9.2.6: Bridge cannot accommodate local conditions"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"AveTeams()","v":0},"lbs",null,null,null,null,{"$f":"AveTeamsNum(-6)","v":0}]
[0,{"$f":"+L129","v":"   10.2.1: Someone other than builders & judges in construction site"}]
[0,{"$f":"+L130","v":"   10.2.2: More than six builders"},null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 8.2",null,null,"Violations","Penalty","8.2 Weight"]
[0,"   10.2.3: Illegal tools (external power)",null,null,null,null,null,null,null,null,null,null,null,"Non-Compliant Member",{"$f":"AveTeams()","v":0},null,{"$f":"AveTeams()","v":0},"lbs",null,null,{"$f":"AveTeamsNum(-6)","v":0},null,0]
[0,{"$f":"+L132","v":"   10.2.4: Illegal tool (weight, size)"},null,null,null,null,null,null,null,null,null,null,null,"Non-Compliant Nut/Loose Bolt",0,null,0,"lbs",null,null,0,null,0]
[0,{"$f":"+L133","v":"   10.2.5: Lubricant on site"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AveTeams()","v":0},"lbs",null,null,null,null,{"$f":"AveTeamsNum(-6)","v":0}]
[0,"   10.3.1: Exposure to personal injury"]
[0,"   10.3.2: Improper wearing of personal protective equipment (See 10.1.5)",null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 9.3"]
[0,"   10.3.3: Pouch or clothing being removed/held in hands",null,null,null,null,null,null,null,null,null,null,null,"< 1/4\"","> 1/4\" to < 1\"","> 1\" to < 2\"","Total"]
[0,"   10.3.4: Builder holding nuts, bolts, or tools in mouth",null,null,null,null,null,null,null,null,null,"Num. of Rules Violated",null,{"$f":"AveTeams()","v":0},0,0,"9.3 Wt",null,null,null,{"$f":"AveTeamsNum(-7)","v":0},{"$f":"AveTeamsNum(-7)","v":0},{"$f":"AveTeamsNum(-7)","v":0}]
[0,"   10.3.5: Items being thrown",null,null,null,null,null,null,null,null,null,"Unit Penalty Weight"]
[0,"   10.3.6: Builder crossing river",null,null,null,null,null,null,null,null,null,"Penalty Wt.",null,null,null,null,{"$f":"AveTeams()","v":0},null,null,null,null,null,null,{"$f":"AveTeamsNum(-7)","v":0}]
[0,"   10.3.7: Builder simultaneously touching more than one member"]
[0,"   10.3.8: A builder using the bridge, member, or tool for physical support",null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 9.5",null,null,"Violations","Penalty","9.5 Weight"]
[0,"   10.3.9: A builder using other builder(s) for support",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AveTeams()","v":0},null,{"$f":"AveTeams()","v":0},null,null,null,null,{"$f":"AveTeamsNum(-7)","v":0},null,{"$f":"AveTeamsNum(-7)","v":0}]
[0,"   10.3.10: Improper sequence of constructing CP"]
[0,"   10.3.11: Builder constructing outside construction zone",null,null,null,null,null,null,null,null,null,"Weight Penalties:  Section 10.4.2",null,null,{"$f":"IF(F77=\"Y\",\"Bridge wouldn't stay in ftg\",\"\")","v":""},null,{"$f":"AveTeams()","v":0},null,null,null,null,null,null,{"$f":"AveTeamsNum(-7)","v":0}]
[0,"   10.3.12: Builder(s) supporting entire weight of construction portion"]
[0,"   10.3.13: Constructed portion extending beyond site boundary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Weight (with penalties) =",{"$f":"AveTeams()","v":0},"lbs",null,null,null,null,null,{"$f":"AveTeamsNum(-7)","v":0}]
[0,"   10.3.14: Cannot accommodate local conditions"]
[0,"   10.4: Intentionally causing an accident",null,null,null,null,null,null,null,null,"C. Aesthetics (Rule 6.2.1)"]
[0,"   10.6.2: Adding/removing items or builders to/from site"]
[]
["Section 10.4 Accidents",null,null,null,null,"During Construction",null,null,null,null,"D. Stiffness (Rule 6.2.4)"]
["Only record accidents which occur in the first 30 minutes",null,null,null,null,"Number"]
["   10.4.1: Builder touches river or floor outside construction boundary",null,null,null,null,{"$f":"IF(SUM(First:Last!F71)>0,SUM(First:Last!F71),\"\")","v":""},null,null,null,null,null,"Vertical Load Test"]
["   10.4.2: Item illegally touches river/ground/floor",null,null,null,null,{"$f":"IF(SUM(First:Last!F72)>0,SUM(First:Last!F72),\"\")","v":""},null,null,null,null,null,null,null,"Gage Reading",{"$f":"+D144","v":0},{"$f":"+E144","v":0},"Total"]
["   10.4.3: Non-CP members touch outside staging yard",null,null,null,null,{"$f":"IF(SUM(First:Last!F73)>0,SUM(First:Last!F73),\"\")","v":""},null,null,null,null,null,null,null,"Initial Reading w/preload on bridge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"End of Loading"]
["   10.4.2: Team demonstrates that bearing surface cannot stay in footing",null,null,null,null,{"$f":"sumsif(\"Yes\")","v":0},null,null,null,null,null,null,null,"11.5 Value",null,null,{"$f":"AveTeams()","v":0},"in",null,null,null,null,null,{"$f":"AveTeamsNum(-7)","v":0}]
[]
[null,null,null,"(Hr:Min:Sec)",null,null,null,null,null,null,null,null,null,null,null,null," Aggregate Deflection = ",{"$f":"AveTeams()","v":0},"in",null,null,null,null,null,{"$f":"AveTeamsNum(-7)","v":0}]
[null,null,"10.7 Construction Clock Time",{"$f":"IF(SUM(First:Last!D78)>0,SUM(First:Last!D78),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"2019 AISC Student Steel Bridge Competition Team Score Computation Sheet - page 2/2"]
["Post-Construction Check",null,null,null,null,null,null,null,null,null,{"$f":"+L2","v":"Enter Name of Competition Here on the Start Here!!!! Sheet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L6","v":0}]
["Section 9: Structural Specifications"]
[null,null,null,null,null,null,null,null,null,null,"E. Construction Economy (Rule 6.2.5)"]
["The bridge is not to be ranked if any of the following rules are violated:  (Select all that apply)"]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L112","v":"   3: Bridge is unsuitable for intended purpose"},null,null,null,null,null,null,null,null,"Cc =",{"$f":"AveTeams()","v":0},"bldrs    x",{"$f":"AveTeams()","v":0},"min. x",60000,"/bldr-min ",{"$f":"AveTeams()","v":0},null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0},null,{"$f":"AveTeamsNum(-11)","v":0},null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
[0,{"$f":"+L120","v":"   9.2.1: Bridge does not provide continuous stringers along both sides"},null,null,null,null,null,null,null,null,"10.4.1 Penalty",{"$f":"AveTeams()","v":0},"bldrs    x",{"$f":"AveTeams()","v":0},"min. x",60000,"/bldr-min ",{"$f":"AveTeams()","v":0},null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0},null,{"$f":"AveTeamsNum(-11)","v":0},null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
[0,{"$f":"+L125","v":"   9.2.6: Bridge cannot accommodate local conditions"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.5.2 penalty for excessive deflection",0,null,null,null,null,null,null,null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
[0,{"$f":"+L127","v":"   9.4: Connections cannot be fixed within five minute limit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final  Cc =",{"$f":"AveTeams()","v":0},null,null,null,null,null,null,null,null,null,null,0]
[0,{"$f":"+L152","v":"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"},null,null,null,null,null,null,null,null,"F.  Structural Efficiency (Rule 6.2.6)"]
[]
["Select a \"Y\" for all rules violated, the number of violations for each rule is not relevant (Rule 9.3)",null,null,null,null,null,null,null,null,null,"Cs  =",null,"Total Weight",{"$f":"AveTeams()","v":0},"lbs      x",5000,"/lb =",{"$f":"AveTeams()","v":0},null,null,null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0},null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Aggregate D ",{"$f":"AveTeams()","v":0},"in       x",3250000,"/in =",0,null,null,null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0},null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.5.2 penalty for excessive deflection",0,null,null,null,null,null,null,null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
["   Usability Dimensional Violations",null,null,"< 1/4\"","> 1/4\" to < 1\"","> 1\" to < 2\"","> 2\" NR",null,null,null,null,null,null,null,null,null,"Final Cs  =",{"$f":"AveTeams()","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
["   9.3.1: Bridge touches ground outside of footings",null,null,{"$f":"IF(sumsif(\"Y\")>0,sumsif(\"Y\"),\"\")","v":""},"","","",{"$f":"IF(COUNTIF(D97:G97,\"Y\")>1,\"Record only the greatest\",\"\")","v":""}]
["   9.3.2: Bridge taller than 5'0\"",null,null,"","","","",{"$f":"IF(COUNTIF(D98:G98,\"Y\")>1,\"Record only the greatest\",\"\")","v":""},null,null,"G. Overall Performance (Rule 6.2.7)",null,null,null,null,null,"Team Contract Fine",{"$f":"AveTeams()","v":0}]
["   9.3.3: Bridge is wider than 5'0\"",null,null,"","","","","",null,null,null,null,null,null,null,null,"Overall Performance:  Cc + Cs",{"$f":"AveTeams()","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"AveTeamsNum(-11)","v":0}]
["   9.3.4: River/ground clearance < 7.5\"",null,null,"","","","",""]
["   9.3.5: Stringer elev. not between 19\" and 23\"",null,null,"","","","",""]
["   9.3.6: Stringer < 22 ft",null,null,"","","","",""]
["   9.3.8: Components extend outside const. zone",null,null,"","","",""]
["   9.3.9: Passageway clearance violation",null,null,"","","","",""]
["   9.3.10: Stringers not in contact with top of rabbet",null,null,"","","","",""]
["   9.3.11: Stringers have holes, splits, etc.",null,null,"","","","","",null,null,"I.  Grounds for Not Ranking:"]
[null,null,"Total # rules violated:  ",{"$f":"SUM(D99:D106)","v":0},{"$f":"SUM(E98:E106)","v":0},{"$f":"SUM(F98:F106)","v":0},{"$f":"SUM(G98:G106)","v":0}]
[]
[]
[null,null,null,null,"Number"]
[null,null,null,null,"of",null,null,null,null,null,"Index #"]
["Connection Safety and Tool Violations at the end of timed construction",null,null,null,"Violations",null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   3: Bridge is unsuitable for intended purpose",null,null,"(May be determined after form is printed)"]
["   9.4.1: Members touch but not connected",null,null,null,{"$f":"IF(SUM(First:Last!E110)>0,SUM(First:Last!E110),\"\")","v":""}]
["   9.4.2: Nuts not fully engaged",null,null,null,{"$f":"IF(SUM(First:Last!E111)>0,SUM(First:Last!E111),\"\")","v":""},null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   4: Did not participate in competition (Construction time = 0 or \"Participants\" page = No) "]
["   9.4.3: Holes are too big or incomplete",null,null,null,{"$f":"IF(SUM(First:Last!E112)>0,SUM(First:Last!E112),\"\")","v":""}]
["   9.4.4: Nut/Bolt head not in contact with member",null,null,null,{"$f":"IF(SUM(First:Last!E113)>0,SUM(First:Last!E113),\"\")","v":""},null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   5: Judges deem the bridge unsafe to compete for any reason"]
[]
["   9.5: Number of nuts/bolts uninspectable",null,null,null,{"$f":"IF(SUM(First:Last!E115)>0,SUM(First:Last!E115),\"\")","v":""},null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   8.1: Member uses material not magnetically attractive"]
["10.9.2: Illegal disassembled tool (weight, size)",null,null,null,{"$f":"IF(sumsif(\"Y\")>0,sumsif(\"Y\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   9.2.1: Bridge does not provide continuous stringers along both sides"]
["Input from Load Station Judging Form",null,null,null,null,null,null,null,null,null,0,"   9.2.2: Bridge does not provide access for safely placing decking & load"]
[null,null,null,null,null,null,null,null,null,null,0,"   9.2.3: Decking attached/anchored to bridge"]
["The bridge is not ranked if any of the following rules are violated.  Select all that apply.",null,null,null,null,null,null,null,null,null,0,"   9.2.4: Decking distorts the bridge"]
[{"$f":"sumsif(\"IE\")","v":0},{"$f":"+L112","v":"   3: Bridge is unsuitable for intended purpose"},null,null,null,null,null,null,null,null,0,"   9.2.5: Bridge is anchored or tied to ground"]
[0,{"$f":"+L116","v":"   5: Judges deem the bridge unsafe to compete for any reason"},null,null,null,null,null,null,null,null,0,"   9.2.6: Bridge cannot accommodate local conditions"]
[0,{"$f":"+L121","v":"   9.2.2: Bridge does not provide access for safely placing decking & load"},null,null,null,null,null,null,null,null,0,"   9.3: Excessive dimensional violation"]
[0,{"$f":"+L122","v":"   9.2.3: Decking attached/anchored to bridge"},null,null,null,null,null,null,null,null,0,"   9.4: Connections cannot be fixed within five minute limit"]
[0,{"$f":"+L123","v":"   9.2.4: Decking distorts the bridge"}]
[0,{"$f":"+L124","v":"   9.2.5: Bridge is anchored or tied to ground"},null,null,null,null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   10.2.1: Someone other than builders & judges in construction site"]
[0,{"$f":"+L125","v":"   9.2.6: Bridge cannot accommodate local conditions"},null,null,null,null,null,null,null,null,0,"   10.2.2: More than six builders"]
[0,{"$f":"+L152","v":"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"},null,null,null,null,null,null,null,null,0,"   10.2.3: Illegal tools (external power)"]
[0,{"$f":"+L153","v":"   11.2.1.1: Unsafe loading procedure"},null,null,null,null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   10.2.4: Illegal tool (weight, size)"]
[0,{"$f":"+L154","v":"   11.2.1.3: Competitors not wearing required safety gear"},null,null,null,null,null,null,null,null,0,"   10.2.5: Lubricant on site"]
[0,{"$f":"+L155","v":"   11.2.3.7: Vertical load cannot be safely placed on bridge"},null,null,null,null,null,null,null,null,0,"   10.3.1: Exposure to personal injury"]
[0,{"$f":"+L156","v":"   11.3: Bridge cannot be loaded safely or sway/defl cannot be measured"},null,null,null,null,null,null,null,null,0,"   10.3.2: Improper wearing of personal protective equipment (See 10.1.5)"]
[0,{"$f":"+L159","v":"   11.6: Bridge collapses during unloading"},null,null,null,null,null,null,null,null,0,"   10.3.3: Pouch or clothing being removed/held in hands"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.4: Builder holding nuts, bolts, or tools in mouth"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.5: Items being thrown"]
["Lateral Load Test",null,"Sway <= 1\"?",null,null,null,null,null,null,null,0,"   10.3.6: Builder crossing river"]
[null,"11.4.2: Lateral Test",{"$f":"sumsif(\"Fail\")","v":0},"failed",null,null,null,null,null,null,0,"   10.3.7: Builder simultaneously touching more than one member"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.8: A builder using the bridge, member, or tool for physical support"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.9: A builder using other builder(s) for support"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.10: Improper sequence of constructing CP"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.11: Builder constructing outside construction zone"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.12: Builder(s) supporting entire weight of construction portion"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.13: Constructed portion extending beyond site boundary"]
[null,null,null,null,null,null,null,null,null,null,0,"   10.3.14: Cannot accommodate local conditions"]
["11.5.2 Stop Loading Violations",null,null,null,"Loading",null,null,null,null,null,0,"   10.4: Intentionally causing an accident"]
[null,null,null,null,11.5,null,null,null,null,null,0,"   10.6.2: Adding/removing items or builders to/from site"]
[null,null,null,"11.5.2(a): Sway > 1\"",{"$f":"sumsif(\"Stopped\")","v":0},null,null,null,null,null,0,"   10.8.2: Construction Time Limit Exceeded"]
[null,null,null,"11.5.2(b): Any deflection > 3\" downward",{"$f":"sumsif(\"Stopped\")","v":0},{"$f":"IF(MAX(O77:P77)>=3,\"Check for excessive downward deflection!!!\",\"\")","v":""}]
[null,null,null,"11.5.2(c): Contact with Safety Support or Ground",{"$f":"sumsif(\"Stopped\")","v":0},null,null,null,null,null,{"$f":"sumsif2(\"*\")","v":0},"   11.1: Damage affecting strength or stability anytime after construction (including during transport)"]
[null,null,null,"11.5.2(d): Decking or load falls off bridge",{"$f":"sumsif(\"Stopped\")","v":0},null,null,null,null,null,0,"   11.2.1.1: Unsafe loading procedure"]
[null,null,null,"11.5.2(e): Collapse or dangerous imminent collapse",{"$f":"sumsif(\"Stopped\")","v":0},null,null,null,null,null,0,"   11.2.1.3: Competitors not wearing required safety gear"]
[null,null,null,null,null,null,null,null,null,null,0,"   11.2.3.7: Vertical load cannot be safely placed on bridge"]
["Input from Weigh Station Form",null,null,null,null,null,null,null,null,null,0,"   11.3: Bridge cannot be loaded safely or sway/defl cannot be measured"]
[null,null,null,null,null,null,null,null,null,null,0,"   11.4: Failed lateral load test"]
[null,"6.2.3 bridge weight ",null,"Left","Right",null,null,null,null,null,0,"   11.5: Excessive deflection/sway or loading stopped by judges"]
[null,null,"East End",{"$f":"IF(SUM(First:Last!D155)>0,SUM(First:Last!D155),\"\")","v":""},{"$f":"IF(SUM(First:Last!E155)>0,SUM(First:Last!E155),\"\")","v":""},null,null,null,null,null,0,"   11.6: Bridge collapses during unloading"]
[null,null,"West End",{"$f":"IF(SUM(First:Last!D156)>0,SUM(First:Last!D156),\"\")","v":""},{"$f":"IF(SUM(First:Last!E156)>0,SUM(First:Last!E156),\"\")","v":""},{"$f":"SUM(D159:E160)","v":0}]
[]
["Overall Performance - Team Contract Fine"]
[null,"This section is to be determined by the head judge & rules committee per Rule 6.2.7"]
[]
[null,null,null,"6.2.7: Team Contract Fine",{"$f":"IF(SUM(First:Last!E169)>0,SUM(First:Last!E169),\"\")","v":""}]