{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculation","Results"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Calculation","index":0,"n_rows":74,"n_cols":29,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,20,1,21]]}
[" ",null,null,"           'A' TECH",null,"           'B' TECH",null,"           'C' TECH",null," 'D' TECH",null,"           SOLO",null,"          DUET",null,"          TRIO",null,"          TEAM",null,null,"           FINISH"]
["INSTITUTION","Abbr.",null,"PLC","PTS","PLC","PTS","PLC","PTS","PLC","PTS","PLC","PTS","PLC","PTS","PLC","PTS","PLC","PTS",null,"Total Points"]
[]
["Lindenwood University","LWU","  ",null,{"$f":"HLOOKUP(D4,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F4,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H4,$C$55:$O$63,4)","v":0},null,{"$f":"HLOOKUP(J4,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L4,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N4,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P4,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R4,$C$55:$O$63,9)","v":0},null,null,null,null,"INSTRUCTIONS",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L5,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N5,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P5,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R5,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E4+G4+I4+K4+M4+M5+O4+O5+Q4+Q5+S4+S5)","v":0},null,"1.  Update meet name and location in header"]
[null,null,null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null,null," ",null,"2.  Unprotect sheet - see review tools"]
["Boston University Synchro","BUS",null,null,{"$f":"HLOOKUP(D7,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F7,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H7,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J7,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L7,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N7,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P7,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R7,$C$55:$O$63,9)","v":0},null,null," ",null,"3.  Edit institutions names as needed"]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L8,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N8,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P8,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R8,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E7+G7+I7+K7+M7+M8+O7+O8+Q7+Q8+S7+S8)","v":0},null,"4.  Protect sheet - see review tools"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.  Enter Institution's finish place from finals for each event they are counting (PLC) column"]
["Penn State Synchro","PSS",null,null,{"$f":"HLOOKUP(D10,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F10,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H10,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J10,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L10,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N10,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P10,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R10,$C$55:$O$63,9)","v":0},null,null," ",null,"6.  Total points for each Institution is linked to results tab for sorting"]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L11,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N11,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P11,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R11,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E10+G10+I10+K10+M10+M11+O10+O11+Q10+Q11+S10+S11)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null,null," "]
["The Ohio State University","OSU",null,2,{"$f":"HLOOKUP(D13,$C$55:$O$63,2)","v":11},null,{"$f":"HLOOKUP(F13,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H13,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J13,$C$55:$O$63,5)","v":0},2,{"$f":"HLOOKUP(L13,$C$55:$O$63,6)","v":12},3,{"$f":"HLOOKUP(N13,$C$55:$O$63,7)","v":11},3,{"$f":"HLOOKUP(P13,$C$55:$O$63,8)","v":12},2,{"$f":"HLOOKUP(R13,$C$55:$O$63,9)","v":16},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L14,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N14,$C$55:$O$63,7)","v":0},4,{"$f":"HLOOKUP(P14,$C$55:$O$63,8)","v":11},4,{"$f":"HLOOKUP(R14,$C$55:$O$63,9)","v":13},null,null,{"$f":"(E13+G13+I13+K13+M13+M14+O13+O14+Q13+Q14+S13+S14)","v":86}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO 4.4   "]
["Northern Arizona University Synchro","NAU",null,null,{"$f":"HLOOKUP(D16,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F16,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H16,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J16,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L16,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N16,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P16,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R16,$C$55:$O$63,9)","v":0},null,null," ",null,"Entry Rules: An institution may select a maximum of 7 events to receive placement "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L17,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N17,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P17,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R17,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E16+G16+I16+K16+M16+M17+O16+O17+Q16+Q17+S16+S17)","v":0},null,"points for the Overall Institution Awards.  See Rule CO 5.1.3. Those 7 events must "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"include at least 1 of the Technical Categories A, B, C or D.   "]
["Stanford University","SUS",null,1,{"$f":"HLOOKUP(D19,$C$55:$O$63,2)","v":12},null,{"$f":"HLOOKUP(F19,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H19,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J19,$C$55:$O$63,5)","v":0},1,{"$f":"HLOOKUP(L19,$C$55:$O$63,6)","v":14},1,{"$f":"HLOOKUP(N19,$C$55:$O$63,7)","v":15},1,{"$f":"HLOOKUP(P19,$C$55:$O$63,8)","v":16},1,{"$f":"HLOOKUP(R19,$C$55:$O$63,9)","v":18},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L20,$C$55:$O$63,6)","v":0},2,{"$f":"HLOOKUP(N20,$C$55:$O$63,7)","v":13},2,{"$f":"HLOOKUP(P20,$C$55:$O$63,8)","v":14},null,{"$f":"HLOOKUP(R20,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E19+G19+I19+K19+M19+M20+O19+O20+Q19+Q20+S19+S20)","v":102}]
[]
["University of Arizona","UAZ",null,null,{"$f":"HLOOKUP(D22,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F22,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H22,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J22,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L22,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N22,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P22,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R22,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L23,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N23,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P23,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R23,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E22+G22+I22+K22+M22+M23+O22+O23+Q22+Q23+S22+S23)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null," "]
["University of Florida Gator Synchro","GTR",null,null,{"$f":"HLOOKUP(D25,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F25,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H25,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J25,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L25,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N25,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P25,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R25,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L26,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N26,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P26,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R26,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E25+G25+I25+K25+M25+M26+O25+O26+Q25+Q26+S25+S26)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["College of William & Mary","MSC",null,null,{"$f":"HLOOKUP(D28,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F28,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H28,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J28,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L28,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N28,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P28,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R28,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L29,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N29,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P29,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R29,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E28+G28+I28+K28+M28+M29+O28+O29+Q28+Q29+S28+S29)","v":0}]
[]
["University of the Incarnate Word","UIW",null,3,{"$f":"HLOOKUP(D31,$C$55:$O$63,2)","v":10},null,{"$f":"HLOOKUP(F31,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H31,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J31,$C$55:$O$63,5)","v":0},3,{"$f":"HLOOKUP(L31,$C$55:$O$63,6)","v":10},4,{"$f":"HLOOKUP(N31,$C$55:$O$63,7)","v":10},5,{"$f":"HLOOKUP(P31,$C$55:$O$63,8)","v":10},3,{"$f":"HLOOKUP(R31,$C$55:$O$63,9)","v":14}]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L32,$C$55:$O$63,6)","v":0},5,{"$f":"HLOOKUP(N32,$C$55:$O$63,7)","v":9},null,{"$f":"HLOOKUP(P32,$C$55:$O$63,8)","v":0},5,{"$f":"HLOOKUP(R32,$C$55:$O$63,9)","v":12},null,null,{"$f":"(E31+G31+I31+K31+M31+M32+O31+O32+Q31+Q32+S31+S32)","v":75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Colorado State Synchro","CSU",null,null,{"$f":"HLOOKUP(D34,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F34,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H34,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J34,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L34,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N34,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P34,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R34,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L35,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N35,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P35,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R35,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E34+G34+I34+K34+M34+M35+O34+O35+Q34+Q35+S34+S35)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null," "]
["University of Michigan","MSS",null,null,{"$f":"HLOOKUP(D37,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F37,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H37,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J37,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L37,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N37,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P37,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R37,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L38,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N38,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P38,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R38,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E37+G37+I37+K37+M37+M38+O37+O38+Q37+Q38+S37+S38)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null," "]
["University of Minnesota","UMN",null,null,{"$f":"HLOOKUP(D40,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F40,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H40,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J40,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L40,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N40,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P40,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R40,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L41,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N41,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P41,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R41,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E40+G40+I40+K40+M40+M41+O40+O41+Q40+Q41+S40+S41)","v":0}]
[]
["University of Pennsylvania","UOP",null,null,{"$f":"HLOOKUP(D43,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F43,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H43,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J43,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L43,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N43,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P43,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R43,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L44,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N44,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P44,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R44,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E43+G43+I43+K43+M43+M44+O43+O44+Q43+Q44+S43+S44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["University of Richmond","URV",null,null,{"$f":"HLOOKUP(D46,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F46,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H46,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J46,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L46,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N46,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P46,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R46,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L47,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N47,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P47,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R47,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E46+G46+I46+K46+M46+M47+O46+O47+Q46+Q47+S46+S47)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null," "]
["Wheaton College","WCT",null,null,{"$f":"HLOOKUP(D49,$C$55:$O$63,2)","v":0},null,{"$f":"HLOOKUP(F49,$C$55:$O$63,3)","v":0},null,{"$f":"HLOOKUP(H49,$C$55:$Q$63,4)","v":0},null,{"$f":"HLOOKUP(J49,$C$55:$O$63,5)","v":0},null,{"$f":"HLOOKUP(L49,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N49,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P49,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R49,$C$55:$O$63,9)","v":0},null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"HLOOKUP(L50,$C$55:$O$63,6)","v":0},null,{"$f":"HLOOKUP(N50,$C$55:$O$63,7)","v":0},null,{"$f":"HLOOKUP(P50,$C$55:$O$63,8)","v":0},null,{"$f":"HLOOKUP(R50,$C$55:$O$63,9)","v":0},null,null,{"$f":"(E49+G49+I49+K49+M49+M50+O49+O50+Q49+Q50+S49+S50)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"check-sum",null,null,{"$f":"SUM(E4:E51)","v":33},null,{"$f":"SUM(G4:G51)","v":0},null,{"$f":"SUM(I4:I51)","v":0},null,{"$f":"SUM(K4:K51)","v":0},null,{"$f":"SUM(M4:M51)","v":36},null,{"$f":"SUM(O4:O51)","v":58},null,{"$f":"SUM(Q4:Q51)","v":63},null,{"$f":"SUM(S4:S51)","v":73},null,null,{"$f":"SUM(V4:V51)","v":263}]
[]
["Event         Place",null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[" 'A' Tech",{"$f":"SUM(D56:O56)","v":96},0,12,11,10,9,8.5,8,7.5,7,6.5,6,5.5,5]
[" 'B' Tech",{"$f":"SUM(D57:O57)","v":72},0,10,9,8,7,6.5,6,5.5,5,4.5,4,3.5,3]
[" 'C' Tech",48,0,8,7,6,5,4.5,4,3.5,3,2.5,2,1.5,1]
["'D' Tech",40.5,0,6.5,6,5.5,4.5,4,3.5,3,2.5,2,1.5,1,0.5]
[" Solo ",81,0,14,12,10,9,8,7,6,5,4,3,2,1]
["Duet",93,0,15,13,11,10,9,8,7,6,5,4,3,2]
[" Trio",105,0,16,14,12,11,10,9,8,7,6,5,4,3]
[" Team",129,0,18,16,14,13,12,11,10,9,8,7,6,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E53,G53,I53,K53,M53,O53,Q53,S53)","v":263}]

{"sheet":"Results","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["INSTITUTION",null,"PLACE",null,"TOTAL POINTS"]
[{"$f":"Calculation!$A$19","v":"Stanford University"},null,1,null,{"$f":"Calculation!$V$20","v":102},null,null,"INSTRUCTIONS"]
[{"$f":"Calculation!$A$13","v":"The Ohio State University"},null,2,null,{"$f":"Calculation!$V$14","v":86}]
[{"$f":"Calculation!$A$31","v":"University of the Incarnate Word"},null,3,null,{"$f":"Calculation!$V$32","v":75},null,null,"2.  Unprotect sheet - see review tools"]
[{"$f":"Calculation!$A$4","v":"Lindenwood University"},null,3,null,{"$f":"Calculation!$V$5","v":0},null,null,"1.  Update meet name and location in header"]
[{"$f":"Calculation!$A$49","v":"Wheaton College"},null,5,null,{"$f":"Calculation!$V$50","v":0},null,null,"3.  Sort by total points, high to low"]
[{"$f":"Calculation!$A$22","v":"University of Arizona"},null,6,null,{"$f":"Calculation!$V$23","v":0},null,null,"4.  Enter places numbers 1 - 6, Trophies 1-3, Plaques 4-6"]
[{"$f":"Calculation!$A$25","v":"University of Florida Gator Synchro"},null,7,null,{"$f":"Calculation!$V$26","v":0},null,null,"5.  Protect sheet - see review tools"]
[{"$f":"Calculation!$A$40","v":"University of Minnesota"},null,8,null,{"$f":"Calculation!$V$41","v":0}]
[{"$f":"Calculation!$A$7","v":"Boston University Synchro"},null,9,null,{"$f":"Calculation!$V$8","v":0}]
[{"$f":"Calculation!$A$37","v":"University of Michigan"},null,"10T",null,{"$f":"Calculation!$V$38","v":0}]
[{"$f":"Calculation!$A$16","v":"Northern Arizona University Synchro"},null,"10T",null,{"$f":"Calculation!$V$17","v":0}]
[{"$f":"Calculation!$A$10","v":"Penn State Synchro"},null,"12T",null,{"$f":"Calculation!$V$11","v":0}]
[{"$f":"Calculation!$A$34","v":"Colorado State Synchro"},null,"12T",null,{"$f":"Calculation!$V$35","v":0}]
[{"$f":"Calculation!$A$28","v":"College of William & Mary"},null,"14T",null,{"$f":"Calculation!$V$29","v":0}]
[{"$f":"Calculation!$A$43","v":"University of Pennsylvania"},null,"14T",null,{"$f":"Calculation!$V$44","v":0}]
[{"$f":"Calculation!$A$46","v":"University of Richmond"},null,16,null,{"$f":"Calculation!$V$47","v":0}]