{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["HOW-TO-USE","SETUP","BOYS","BOYS-TEAM","GIRLS","GIRLS-TEAM"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":4},"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":"HOW-TO-USE","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Instructions for Use:"]
[]
["1.","Go to the SETUP worksheet and enter your track meet name and date"]
[]
["2.","Also on the SETUP page, enter the scoring system to be used for the track meet."]
[]
["3.","As events are completed and score cards come in, enter the results in the corresponding areas on the BOYS or GIRLS worksheets."]
[null," - NOTE: In order for the team scoring and outstanding individuals to work, you must use a consistent set of names for the team and for individuals names (for example, Central High School could be entered as CHS under the 'School' column, and a contestant J. Doe must be typed as J. Doe in each event he/she participates in)"]
[]
[null,"** Limitation - Currently, relay events are not tabulated in the outstanding individual tally!"]
[]
["4.","To determine team and outstanding individual scoring, go to the BOYS-TEAM or GIRLS-TEAM workbooks.  The point leaders for teams and individuals should be automatically tabulated and updated (assuming macros are enabled)."]
[]
["5.","Results are set to print out on 2 pages for boys and 2 pages for girls.  Team results should fit on a single page."]

{"sheet":"SETUP","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,0,5,1],[13,0,13,1]]}
["Track Meet Setup"]
[]
["Track Meet Name","[Track Meet Name]","<-- Type here in the yellow boxes"]
["Meet Date","[Date]"]
[]
["Scoring/Points (Individual Events)",null,null,"LHSAA & National Federation Points System"]
["1st",10]
["2nd",8]
["3rd",6]
["4th",4]
["5th",2]
["6th",1]
[]
["Scoring/Points (Relay Events)"]
["1st",10]
["2nd",8]
["3rd",6]
["4th",4]
["5th",2]
["6th",1]

{"sheet":"BOYS","index":2,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[93,0,98,0],[99,0,104,0],[105,0,110,0],[75,0,80,0],[81,0,86,0],[87,0,92,0],[0,0,0,5],[1,0,1,5],[51,0,56,0],[57,0,62,0],[3,0,8,0],[9,0,14,0],[15,0,20,0],[21,0,26,0],[63,0,68,0],[69,0,74,0],[27,0,32,0],[33,0,38,0],[39,0,44,0],[45,0,50,0]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"[Track Meet Name] - [Date]"}]
["BOYS"]
["Event","Place","School","Contestant(s)","Time/Dist.","Points","Event Type"]
["Shot Put","1st",null,null,null,{"$f":"IF(G4=\"Relay\",LOOKUP(B4,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B4,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G5=\"Relay\",LOOKUP(B5,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B5,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G6=\"Relay\",LOOKUP(B6,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B6,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G7=\"Relay\",LOOKUP(B7,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B7,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G8=\"Relay\",LOOKUP(B8,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B8,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G9=\"Relay\",LOOKUP(B9,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B9,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Discus","1st",null,null,null,{"$f":"IF(G10=\"Relay\",LOOKUP(B10,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B10,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G11=\"Relay\",LOOKUP(B11,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B11,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G12=\"Relay\",LOOKUP(B12,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B12,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G13=\"Relay\",LOOKUP(B13,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B13,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G14=\"Relay\",LOOKUP(B14,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B14,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G15=\"Relay\",LOOKUP(B15,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B15,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Long Jump","1st",null,null,null,{"$f":"IF(G16=\"Relay\",LOOKUP(B16,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B16,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G17=\"Relay\",LOOKUP(B17,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B17,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G18=\"Relay\",LOOKUP(B18,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B18,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G19=\"Relay\",LOOKUP(B19,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B19,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G20=\"Relay\",LOOKUP(B20,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B20,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G21=\"Relay\",LOOKUP(B21,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B21,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Triple Jump","1st",null,null,null,{"$f":"IF(G22=\"Relay\",LOOKUP(B22,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B22,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G23=\"Relay\",LOOKUP(B23,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B23,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G24=\"Relay\",LOOKUP(B24,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B24,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G25=\"Relay\",LOOKUP(B25,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B25,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G26=\"Relay\",LOOKUP(B26,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B26,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G27=\"Relay\",LOOKUP(B27,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B27,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["High Jump","1st",null,null,null,{"$f":"IF(G28=\"Relay\",LOOKUP(B28,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B28,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G29=\"Relay\",LOOKUP(B29,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B29,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G30=\"Relay\",LOOKUP(B30,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B30,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G31=\"Relay\",LOOKUP(B31,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B31,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G32=\"Relay\",LOOKUP(B32,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B32,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G33=\"Relay\",LOOKUP(B33,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B33,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Pole Vault","1st",null,null,null,{"$f":"IF(G34=\"Relay\",LOOKUP(B34,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B34,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G35=\"Relay\",LOOKUP(B35,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B35,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G36=\"Relay\",LOOKUP(B36,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B36,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G37=\"Relay\",LOOKUP(B37,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B37,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G38=\"Relay\",LOOKUP(B38,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B38,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G39=\"Relay\",LOOKUP(B39,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B39,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Javelin","1st",null,null,null,{"$f":"IF(G40=\"Relay\",LOOKUP(B40,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B40,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G41=\"Relay\",LOOKUP(B41,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B41,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G42=\"Relay\",LOOKUP(B42,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B42,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G43=\"Relay\",LOOKUP(B43,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B43,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G44=\"Relay\",LOOKUP(B44,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B44,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G45=\"Relay\",LOOKUP(B45,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B45,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["800 M Relay","1st",null,null,null,{"$f":"IF(G46=\"Relay\",LOOKUP(B46,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B46,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Relay"]
[null,"2nd",null,null,null,{"$f":"IF(G47=\"Relay\",LOOKUP(B47,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B47,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Relay"]
[null,"3rd",null,null,null,{"$f":"IF(G48=\"Relay\",LOOKUP(B48,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B48,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Relay"]
[null,"4th",null,null,null,{"$f":"IF(G49=\"Relay\",LOOKUP(B49,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B49,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Relay"]
[null,"5th",null,null,null,{"$f":"IF(G50=\"Relay\",LOOKUP(B50,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B50,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Relay"]
[null,"6th",null,null,null,{"$f":"IF(G51=\"Relay\",LOOKUP(B51,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B51,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Relay"]
["1600 M Run","1st",null,null,null,{"$f":"IF(G52=\"Relay\",LOOKUP(B52,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B52,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G53=\"Relay\",LOOKUP(B53,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B53,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G54=\"Relay\",LOOKUP(B54,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B54,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G55=\"Relay\",LOOKUP(B55,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B55,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G56=\"Relay\",LOOKUP(B56,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B56,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G57=\"Relay\",LOOKUP(B57,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B57,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["110 M Hurdles","1st",null,null,null,{"$f":"IF(G58=\"Relay\",LOOKUP(B58,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B58,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G59=\"Relay\",LOOKUP(B59,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B59,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G60=\"Relay\",LOOKUP(B60,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B60,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G61=\"Relay\",LOOKUP(B61,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B61,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G62=\"Relay\",LOOKUP(B62,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B62,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G63=\"Relay\",LOOKUP(B63,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B63,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["100 M Dash","1st",null,null,null,{"$f":"IF(G64=\"Relay\",LOOKUP(B64,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B64,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G65=\"Relay\",LOOKUP(B65,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B65,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G66=\"Relay\",LOOKUP(B66,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B66,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G67=\"Relay\",LOOKUP(B67,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B67,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G68=\"Relay\",LOOKUP(B68,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B68,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G69=\"Relay\",LOOKUP(B69,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B69,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["800 M Run","1st",null,null,null,{"$f":"IF(G70=\"Relay\",LOOKUP(B70,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B70,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G71=\"Relay\",LOOKUP(B71,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B71,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G72=\"Relay\",LOOKUP(B72,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B72,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G73=\"Relay\",LOOKUP(B73,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B73,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G74=\"Relay\",LOOKUP(B74,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B74,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G75=\"Relay\",LOOKUP(B75,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B75,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["400 M Relay","1st",null,null,null,{"$f":"IF(G76=\"Relay\",LOOKUP(B76,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B76,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Relay"]
[null,"2nd",null,null,null,{"$f":"IF(G77=\"Relay\",LOOKUP(B77,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B77,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Relay"]
[null,"3rd",null,null,null,{"$f":"IF(G78=\"Relay\",LOOKUP(B78,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B78,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Relay"]
[null,"4th",null,null,null,{"$f":"IF(G79=\"Relay\",LOOKUP(B79,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B79,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Relay"]
[null,"5th",null,null,null,{"$f":"IF(G80=\"Relay\",LOOKUP(B80,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B80,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Relay"]
[null,"6th",null,null,null,{"$f":"IF(G81=\"Relay\",LOOKUP(B81,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B81,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Relay"]
["400 M Run","1st",null,null,null,{"$f":"IF(G82=\"Relay\",LOOKUP(B82,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B82,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G83=\"Relay\",LOOKUP(B83,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B83,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G84=\"Relay\",LOOKUP(B84,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B84,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G85=\"Relay\",LOOKUP(B85,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B85,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G86=\"Relay\",LOOKUP(B86,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B86,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G87=\"Relay\",LOOKUP(B87,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B87,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["300 M Hurdles","1st",null,null,null,{"$f":"IF(G88=\"Relay\",LOOKUP(B88,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B88,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G89=\"Relay\",LOOKUP(B89,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B89,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G90=\"Relay\",LOOKUP(B90,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B90,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G91=\"Relay\",LOOKUP(B91,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B91,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G92=\"Relay\",LOOKUP(B92,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B92,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G93=\"Relay\",LOOKUP(B93,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B93,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["200 M Dash","1st",null,null,null,{"$f":"IF(G94=\"Relay\",LOOKUP(B94,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B94,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G95=\"Relay\",LOOKUP(B95,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B95,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G96=\"Relay\",LOOKUP(B96,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B96,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G97=\"Relay\",LOOKUP(B97,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B97,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G98=\"Relay\",LOOKUP(B98,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B98,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G99=\"Relay\",LOOKUP(B99,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B99,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["3200 M Run","1st",null,null,null,{"$f":"IF(G100=\"Relay\",LOOKUP(B100,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B100,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G101=\"Relay\",LOOKUP(B101,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B101,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G102=\"Relay\",LOOKUP(B102,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B102,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G103=\"Relay\",LOOKUP(B103,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B103,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G104=\"Relay\",LOOKUP(B104,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B104,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G105=\"Relay\",LOOKUP(B105,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B105,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["1600 M Relay","1st",null,null,null,{"$f":"IF(G106=\"Relay\",LOOKUP(B106,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B106,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Relay"]
[null,"2nd",null,null,null,{"$f":"IF(G107=\"Relay\",LOOKUP(B107,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B107,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Relay"]
[null,"3rd",null,null,null,{"$f":"IF(G108=\"Relay\",LOOKUP(B108,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B108,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Relay"]
[null,"4th",null,null,null,{"$f":"IF(G109=\"Relay\",LOOKUP(B109,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B109,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Relay"]
[null,"5th",null,null,null,{"$f":"IF(G110=\"Relay\",LOOKUP(B110,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B110,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Relay"]
[null,"6th",null,null,null,{"$f":"IF(G111=\"Relay\",LOOKUP(B111,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20),LOOKUP(B111,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Relay"]

{"sheet":"BOYS-TEAM","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,1],[3,3,3,6]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"[Track Meet Name] - [Date]"}]
["BOYS"]
[]
["TEAM RESULTS",null,null,"OUTSTANDING INDIVIDUALS",null,null,null,null,"Scores should be automatically updated when"]
["Sum of Points",null,null,"Sum of Points",null,null,null,null,"changes are made on the BOYS results sheet"]
["School","Total",null,"Event Type","Contestant(s)","School","Total"]
[null,null,null,null,null,null,null,null,"You can manually update each table by right-"]
[null,null,null,null,null,null,null,null,"clicking on each table and choosing \"Refresh\""]

{"sheet":"GIRLS","index":4,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[99,0,104,0],[105,0,110,0],[63,0,68,0],[69,0,74,0],[75,0,80,0],[81,0,86,0],[87,0,92,0],[93,0,98,0],[27,0,32,0],[33,0,38,0],[39,0,44,0],[45,0,50,0],[51,0,56,0],[57,0,62,0],[0,0,0,5],[1,0,1,5],[3,0,8,0],[9,0,14,0],[15,0,20,0],[21,0,26,0]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"[Track Meet Name] - [Date]"}]
["GIRLS"]
["Event","Place","School","Contestant(s)","Time/Dist.","Points","Event Type"]
["Shot Put","1st",null,null,null,{"$f":"IF(G4=\"Relay\", LOOKUP(B4,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B4,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G5=\"Relay\", LOOKUP(B5,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B5,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G6=\"Relay\", LOOKUP(B6,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B6,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G7=\"Relay\", LOOKUP(B7,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B7,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G8=\"Relay\", LOOKUP(B8,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B8,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G9=\"Relay\", LOOKUP(B9,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B9,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Discus","1st",null,null,null,{"$f":"IF(G10=\"Relay\", LOOKUP(B10,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B10,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G11=\"Relay\", LOOKUP(B11,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B11,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G12=\"Relay\", LOOKUP(B12,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B12,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G13=\"Relay\", LOOKUP(B13,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B13,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G14=\"Relay\", LOOKUP(B14,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B14,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G15=\"Relay\", LOOKUP(B15,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B15,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Long Jump","1st",null,null,null,{"$f":"IF(G16=\"Relay\", LOOKUP(B16,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B16,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G17=\"Relay\", LOOKUP(B17,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B17,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G18=\"Relay\", LOOKUP(B18,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B18,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G19=\"Relay\", LOOKUP(B19,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B19,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G20=\"Relay\", LOOKUP(B20,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B20,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G21=\"Relay\", LOOKUP(B21,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B21,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Triple Jump","1st",null,null,null,{"$f":"IF(G22=\"Relay\", LOOKUP(B22,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B22,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G23=\"Relay\", LOOKUP(B23,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B23,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G24=\"Relay\", LOOKUP(B24,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B24,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G25=\"Relay\", LOOKUP(B25,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B25,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G26=\"Relay\", LOOKUP(B26,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B26,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G27=\"Relay\", LOOKUP(B27,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B27,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["High Jump","1st",null,null,null,{"$f":"IF(G28=\"Relay\", LOOKUP(B28,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B28,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G29=\"Relay\", LOOKUP(B29,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B29,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G30=\"Relay\", LOOKUP(B30,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B30,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G31=\"Relay\", LOOKUP(B31,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B31,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G32=\"Relay\", LOOKUP(B32,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B32,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G33=\"Relay\", LOOKUP(B33,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B33,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Pole Vault","1st",null,null,null,{"$f":"IF(G34=\"Relay\", LOOKUP(B34,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B34,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G35=\"Relay\", LOOKUP(B35,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B35,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G36=\"Relay\", LOOKUP(B36,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B36,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G37=\"Relay\", LOOKUP(B37,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B37,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G38=\"Relay\", LOOKUP(B38,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B38,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G39=\"Relay\", LOOKUP(B39,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B39,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["Javelin","1st",null,null,null,{"$f":"IF(G40=\"Relay\", LOOKUP(B40,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B40,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Field"]
[null,"2nd",null,null,null,{"$f":"IF(G41=\"Relay\", LOOKUP(B41,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B41,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Field"]
[null,"3rd",null,null,null,{"$f":"IF(G42=\"Relay\", LOOKUP(B42,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B42,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Field"]
[null,"4th",null,null,null,{"$f":"IF(G43=\"Relay\", LOOKUP(B43,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B43,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Field"]
[null,"5th",null,null,null,{"$f":"IF(G44=\"Relay\", LOOKUP(B44,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B44,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Field"]
[null,"6th",null,null,null,{"$f":"IF(G45=\"Relay\", LOOKUP(B45,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B45,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Field"]
["800 M Relay","1st",null,null,null,{"$f":"IF(G46=\"Relay\", LOOKUP(B46,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B46,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Relay"]
[null,"2nd",null,null,null,{"$f":"IF(G47=\"Relay\", LOOKUP(B47,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B47,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Relay"]
[null,"3rd",null,null,null,{"$f":"IF(G48=\"Relay\", LOOKUP(B48,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B48,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Relay"]
[null,"4th",null,null,null,{"$f":"IF(G49=\"Relay\", LOOKUP(B49,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B49,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Relay"]
[null,"5th",null,null,null,{"$f":"IF(G50=\"Relay\", LOOKUP(B50,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B50,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Relay"]
[null,"6th",null,null,null,{"$f":"IF(G51=\"Relay\", LOOKUP(B51,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B51,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Relay"]
["1600 M Run","1st",null,null,null,{"$f":"IF(G52=\"Relay\", LOOKUP(B52,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B52,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G53=\"Relay\", LOOKUP(B53,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B53,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G54=\"Relay\", LOOKUP(B54,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B54,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G55=\"Relay\", LOOKUP(B55,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B55,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G56=\"Relay\", LOOKUP(B56,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B56,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G57=\"Relay\", LOOKUP(B57,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B57,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["100 M Hurdles","1st",null,null,null,{"$f":"IF(G58=\"Relay\", LOOKUP(B58,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B58,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G59=\"Relay\", LOOKUP(B59,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B59,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G60=\"Relay\", LOOKUP(B60,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B60,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G61=\"Relay\", LOOKUP(B61,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B61,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G62=\"Relay\", LOOKUP(B62,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B62,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G63=\"Relay\", LOOKUP(B63,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B63,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["100 M Dash","1st",null,null,null,{"$f":"IF(G64=\"Relay\", LOOKUP(B64,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B64,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G65=\"Relay\", LOOKUP(B65,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B65,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G66=\"Relay\", LOOKUP(B66,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B66,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G67=\"Relay\", LOOKUP(B67,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B67,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G68=\"Relay\", LOOKUP(B68,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B68,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G69=\"Relay\", LOOKUP(B69,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B69,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["800 M Run","1st",null,null,null,{"$f":"IF(G70=\"Relay\", LOOKUP(B70,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B70,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G71=\"Relay\", LOOKUP(B71,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B71,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G72=\"Relay\", LOOKUP(B72,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B72,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G73=\"Relay\", LOOKUP(B73,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B73,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G74=\"Relay\", LOOKUP(B74,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B74,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G75=\"Relay\", LOOKUP(B75,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B75,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["400 M Relay","1st",null,null,null,{"$f":"IF(G76=\"Relay\", LOOKUP(B76,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B76,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Relay"]
[null,"2nd",null,null,null,{"$f":"IF(G77=\"Relay\", LOOKUP(B77,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B77,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Relay"]
[null,"3rd",null,null,null,{"$f":"IF(G78=\"Relay\", LOOKUP(B78,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B78,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Relay"]
[null,"4th",null,null,null,{"$f":"IF(G79=\"Relay\", LOOKUP(B79,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B79,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Relay"]
[null,"5th",null,null,null,{"$f":"IF(G80=\"Relay\", LOOKUP(B80,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B80,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Relay"]
[null,"6th",null,null,null,{"$f":"IF(G81=\"Relay\", LOOKUP(B81,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B81,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Relay"]
["400 M Run","1st",null,null,null,{"$f":"IF(G82=\"Relay\", LOOKUP(B82,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B82,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G83=\"Relay\", LOOKUP(B83,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B83,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G84=\"Relay\", LOOKUP(B84,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B84,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G85=\"Relay\", LOOKUP(B85,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B85,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G86=\"Relay\", LOOKUP(B86,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B86,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G87=\"Relay\", LOOKUP(B87,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B87,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["300 M Hurdles","1st",null,null,null,{"$f":"IF(G88=\"Relay\", LOOKUP(B88,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B88,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G89=\"Relay\", LOOKUP(B89,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B89,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G90=\"Relay\", LOOKUP(B90,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B90,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G91=\"Relay\", LOOKUP(B91,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B91,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G92=\"Relay\", LOOKUP(B92,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B92,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G93=\"Relay\", LOOKUP(B93,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B93,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["200 M Dash","1st",null,null,null,{"$f":"IF(G94=\"Relay\", LOOKUP(B94,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B94,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G95=\"Relay\", LOOKUP(B95,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B95,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G96=\"Relay\", LOOKUP(B96,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B96,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G97=\"Relay\", LOOKUP(B97,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B97,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G98=\"Relay\", LOOKUP(B98,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B98,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G99=\"Relay\", LOOKUP(B99,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B99,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["3200 M Run","1st",null,null,null,{"$f":"IF(G100=\"Relay\", LOOKUP(B100,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B100,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Track"]
[null,"2nd",null,null,null,{"$f":"IF(G101=\"Relay\", LOOKUP(B101,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B101,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Track"]
[null,"3rd",null,null,null,{"$f":"IF(G102=\"Relay\", LOOKUP(B102,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B102,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Track"]
[null,"4th",null,null,null,{"$f":"IF(G103=\"Relay\", LOOKUP(B103,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B103,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Track"]
[null,"5th",null,null,null,{"$f":"IF(G104=\"Relay\", LOOKUP(B104,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B104,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Track"]
[null,"6th",null,null,null,{"$f":"IF(G105=\"Relay\", LOOKUP(B105,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B105,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Track"]
["1600 M Relay","1st",null,null,null,{"$f":"IF(G106=\"Relay\", LOOKUP(B106,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B106,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":10},"Relay"]
[null,"2nd",null,null,null,{"$f":"IF(G107=\"Relay\", LOOKUP(B107,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B107,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":8},"Relay"]
[null,"3rd",null,null,null,{"$f":"IF(G108=\"Relay\", LOOKUP(B108,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B108,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":6},"Relay"]
[null,"4th",null,null,null,{"$f":"IF(G109=\"Relay\", LOOKUP(B109,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B109,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":4},"Relay"]
[null,"5th",null,null,null,{"$f":"IF(G110=\"Relay\", LOOKUP(B110,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B110,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":2},"Relay"]
[null,"6th",null,null,null,{"$f":"IF(G111=\"Relay\", LOOKUP(B111,SETUP!$A$15:$A$20,SETUP!$B$15:$B$20), LOOKUP(B111,SETUP!$A$7:$A$12,SETUP!$B$7:$B$12))","v":1},"Relay"]

{"sheet":"GIRLS-TEAM","index":5,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,1],[3,3,3,6]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"[Track Meet Name] - [Date]"}]
["GIRLS"]
[]
["TEAM RESULTS",null,null,"OUTSTANDING INDIVIDUALS",null,null,null,null,"Scores should be automatically updated when"]
["Sum of Points",null,null,"Sum of Points",null,null,null,null,"changes are made on the GIRLS results sheet"]
["School","Total",null,"Event Type","Contestant(s)","School","Total"]
[null,null,null,null,null,null,null,null,"You can manually update each table by right-"]
[null,null,null,null,null,null,null,null,"clicking on each table and choosing \"Refresh\""]