{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["HOW-TO-USE","SETUP","BOYS","BOYS-TEAM","GIRLS","GIRLS-TEAM"],"not_rendered":{"images":1,"macros":1,"defined_names":6,"comments":1,"pivot_tables":4},"read":"whole","date_system":"1900"}

{"sheet":"HOW-TO-USE","index":0,"n_rows":14,"n_cols":2,"rows_kept":14}
["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,"merged":[[5,0,5,1],[13,0,13,1]]}
["Track Meet Setup"]
[]
["Track Meet Name","North Side, Snider, Luers - RESERVE","<-- Type here in the yellow boxes"]
["Meet Date","May 9th, 2018"]
[]
["Scoring/Points (Individual Events)",null,null,"IHSAA & National Federation Points System"]
["1st",5]
["2nd",3]
["3rd",2]
["4th",1]
["5th"]
["6th"]
[]
["Scoring/Points (Relay Events)"]
["1st",5]
["2nd",3]
["3rd"]
["4th"]
["5th"]
["6th"]

{"sheet":"BOYS","index":2,"n_rows":111,"n_cols":7,"rows_kept":111,"merged":[[0,0,0,5],[1,0,1,5],[3,0,8,0],[9,0,14,0],[15,0,20,0],[21,0,26,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],[63,0,68,0],[69,0,74,0],[75,0,80,0],[81,0,86,0],[87,0,92,0],[93,0,98,0],[99,0,104,0],[105,0,110,0]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"North Side, Snider, Luers - RESERVE - May 9th, 2018"}]
["BOYS"]
["Event","Place","School","Contestant(s)","Time/Dist.","Points","Event Type"]
["4X8m RELAY","1st","NS","DeLong","00:10:00",{"$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":5},"Relay"]
[null,"2nd",{"$nulls":3},{"$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":3},"Relay"]
[null,"3rd",{"$nulls":3},{"$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":0},"Relay"]
[null,"4th",{"$nulls":3},{"$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":0},"Relay"]
[null,"5th",{"$nulls":3},{"$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":0},"Relay"]
[null,"6th",{"$nulls":3},{"$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":0},"Relay"]
["110 HURDLES","1st",{"$nulls":3},{"$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":5},"Track"]
[null,"2nd",{"$nulls":3},{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["100m DASH","1st","NS","White",11.4,{"$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":5},"Track"]
[null,"2nd","Snider","Brewer",11.5,{"$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":3},"Track"]
[null,"3rd","NS","Leach",11.6,{"$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":2},"Track"]
[null,"4th","Snider","Hubie",11.9,{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["1600m RUN","1st","Snider","Wyatt","00:05:16.900",{"$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":5},"Track"]
[null,"2nd","Snider","Griffin","00:05:20",{"$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":3},"Track"]
[null,"3rd","Snider","Golden","00:05:24",{"$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":2},"Track"]
[null,"4th","BL","Steigmeyer","00:05:28",{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["4X100m RELAY","1st","Snider","Brewer",45.8,{"$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":5},"Relay"]
[null,"2nd",{"$nulls":3},{"$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":3},"Relay"]
[null,"3rd",{"$nulls":3},{"$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":0},"Relay"]
[null,"4th",{"$nulls":3},{"$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":0},"Relay"]
[null,"5th",{"$nulls":3},{"$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":0},"Relay"]
[null,"6th",{"$nulls":3},{"$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":0},"Relay"]
["400m DASH","1st","NS","Leach",53.1,{"$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":5},"Track"]
[null,"2nd","Snider","Milledge",53.3,{"$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":3},"Track"]
[null,"3rd","Snider","Rider","01:01:00",{"$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":2},"Track"]
[null,"4th","Snider","Eley","01:03:00",{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["300m HURDLES","1st",{"$nulls":3},{"$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":5},"Track"]
[null,"2nd",{"$nulls":3},{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["800m RUN","1st","Snider","Wunderlich","00:02:22",{"$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":5},"Track"]
[null,"2nd","Snider","Corbin","00:02:22.300",{"$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":3},"Track"]
[null,"3rd","NS","Aung","00:02:26.200",{"$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":2},"Track"]
[null,"4th","Snider","Maynard","00:02:26.500",{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["200m DASH","1st","NS","Redman",24.7,{"$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":5},"Track"]
[null,"2nd","NS","Taylor",24.8,{"$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":3},"Track"]
[null,"3rd","Snider","Thomas",24.9,{"$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":2},"Track"]
[null,"4th","Snider","Williams",25.2,{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["3200m RUN","1st",{"$nulls":3},{"$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":5},"Track"]
[null,"2nd",{"$nulls":3},{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["4X400M RELAY","1st","NS",null,"00:03:51.900",{"$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":5},"Relay"]
[null,"2nd","Snider",null,"00:03:52.200",{"$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":3},"Relay"]
[null,"3rd",{"$nulls":3},{"$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":0},"Relay"]
[null,"4th",{"$nulls":3},{"$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":0},"Relay"]
[null,"5th",{"$nulls":3},{"$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":0},"Relay"]
[null,"6th",{"$nulls":3},{"$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":0},"Relay"]
["SHOT","1st","Snider","Gianini","36' 1\"",{"$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":5},"Field"]
[null,"2nd","NS","Lambert","34' 7\"",{"$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":3},"Field"]
[null,"3rd","Snider","McCarter","33' 7\"",{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["DISC","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["HIGH JUMP","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["LONG JUMP","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["POLE VAULT","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["THROWERS RELAY","1st",{"$nulls":3},0,"SUPLEMENT"]
[null,"2nd",{"$nulls":3},0,"SUPLEMENT"]
[null,"3rd",{"$nulls":3},0,"SUPLEMENT"]
[null,"4th",{"$nulls":3},0,"SUPLEMENT"]
[null,"5th",{"$nulls":3},0,"SUPLEMENT"]
[null,"6th",{"$nulls":3},0,"SUPLEMENT"]
["Extra","1st",{"$nulls":3},0,"SUPLEMENT"]
[null,"2nd",{"$nulls":3},0,"SUPLEMENT"]
[null,"3rd",{"$nulls":3},0,"SUPLEMENT"]
[null,"4th",{"$nulls":3},0,"SUPLEMENT"]
[null,"5th",{"$nulls":3},0,"SUPLEMENT"]
[null,"6th",{"$nulls":3},0,"SUPLEMENT"]

{"sheet":"BOYS-TEAM","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,1],[3,3,3,6]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"North Side, Snider, Luers - RESERVE - May 9th, 2018"}]
["BOYS"]
[]
["TEAM RESULTS",null,null,"OUTSTANDING INDIVIDUALS",{"$nulls":4},"Scores should be automatically updated when"]
["Sum of Points",null,null,"Sum of Points",{"$nulls":4},"changes are made on the BOYS results sheet"]
["School","Total",null,"Event Type","Contestant(s)","School","Total"]
[{"$nulls":8},"You can manually update each table by right-"]
["Snider",47,{"$nulls":6},"clicking on each table and choosing \"Refresh\""]
["NS",35]
["BL",1]

{"sheet":"GIRLS","index":4,"n_rows":111,"n_cols":7,"rows_kept":111,"merged":[[0,0,0,5],[1,0,1,5],[3,0,8,0],[9,0,14,0],[15,0,20,0],[21,0,26,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],[63,0,68,0],[69,0,74,0],[75,0,80,0],[81,0,86,0],[87,0,92,0],[93,0,98,0],[99,0,104,0],[105,0,110,0]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"North Side, Snider, Luers - RESERVE - May 9th, 2018"}]
["GIRLS"]
["Event","Place","School","Contestant(s)","Time/Dist.","Points","Event Type"]
["4X8m RELAY","1st",{"$nulls":3},{"$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":5},"Relay"]
[null,"2nd",{"$nulls":3},{"$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":3},"Relay"]
[null,"3rd",{"$nulls":3},{"$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":0},"Relay"]
[null,"4th",{"$nulls":3},{"$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":0},"Relay"]
[null,"5th",{"$nulls":3},{"$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":0},"Relay"]
[null,"6th",{"$nulls":3},{"$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":0},"Relay"]
["110 HURDLES","1st","Snider","Weekes",21.2,{"$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":5},"Track"]
[null,"2nd",{"$nulls":3},{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["100m DASH","1st","Snider","Diaz",13.5,{"$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":5},"Track"]
[null,"2nd","Snider","Reid",14.7,{"$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":3},"Track"]
[null,"3rd","Snider","Hammersmith",16.6,{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["1600m RUN","1st","BL","Shafer","*6:00.6",{"$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":5},"Track"]
[null,"2nd","NS","Matteson","00:08:23.400",{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["4X100m RELAY","1st","Snider","Davis",57.3,{"$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":5},"Relay"]
[null,"2nd",{"$nulls":3},{"$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":3},"Relay"]
[null,"3rd",{"$nulls":3},{"$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":0},"Relay"]
[null,"4th",{"$nulls":3},{"$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":0},"Relay"]
[null,"5th",{"$nulls":3},{"$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":0},"Relay"]
[null,"6th",{"$nulls":3},{"$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":0},"Relay"]
["400m DASH","1st","NS","Springer","00:01:04.300",{"$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":5},"Track"]
[null,"2nd","NS","Belch-Watson","00:01:09.200",{"$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":3},"Track"]
[null,"3rd","NS","Wilson","00:01:09.900",{"$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":2},"Track"]
[null,"4th","Snider","Moore","00:01:10.500",{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["300m HURDLES","1st",{"$nulls":3},{"$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":5},"Track"]
[null,"2nd",{"$nulls":3},{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["800m RUN","1st","Snider","Nikoh","00:02:47",{"$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":5},"Track"]
[null,"2nd","NS","Mancia","NT",{"$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":3},"Track"]
[null,"3rd","Luers","Allen","NT",{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["200m DASH","1st","Snider","Diaz",28.4,{"$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":5},"Track"]
[null,"2nd","Snider","Milledge",28.5,{"$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":3},"Track"]
[null,"3rd","Snider","Reid",30.7,{"$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":2},"Track"]
[null,"4th","NS","Wilson",30.9,{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["3200m RUN","1st",{"$nulls":3},{"$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":5},"Track"]
[null,"2nd",{"$nulls":3},{"$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":3},"Track"]
[null,"3rd",{"$nulls":3},{"$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":2},"Track"]
[null,"4th",{"$nulls":3},{"$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":1},"Track"]
[null,"5th",{"$nulls":3},{"$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":0},"Track"]
[null,"6th",{"$nulls":3},{"$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":0},"Track"]
["4X400M RELAY","1st","Snider",null,"00:04:54.500",{"$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":5},"Relay"]
[null,"2nd",{"$nulls":3},{"$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":3},"Relay"]
[null,"3rd",{"$nulls":3},{"$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":0},"Relay"]
[null,"4th",{"$nulls":3},{"$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":0},"Relay"]
[null,"5th",{"$nulls":3},{"$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":0},"Relay"]
[null,"6th",{"$nulls":3},{"$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":0},"Relay"]
["SHOT","1st","Snider","White","27'2\"",{"$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":5},"Field"]
[null,"2nd","Snider","Wilder","26'4\"",{"$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":3},"Field"]
[null,"3rd","NS","Matson","22'11\"",{"$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":2},"Field"]
[null,"4th","NS","Freema","21'7\"",{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["DISC","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["HIGH JUMP","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["LONG JUMP","1st","NS","Wilson","11' 1 1/4\"",{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["POLE VAULT","1st",{"$nulls":3},{"$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":5},"Field"]
[null,"2nd",{"$nulls":3},{"$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":3},"Field"]
[null,"3rd",{"$nulls":3},{"$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":2},"Field"]
[null,"4th",{"$nulls":3},{"$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":1},"Field"]
[null,"5th",{"$nulls":3},{"$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":0},"Field"]
[null,"6th",{"$nulls":3},{"$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":0},"Field"]
["THROWERS RELAY","1st",{"$nulls":3},0,"SUPLEMENT"]
[null,"2nd",{"$nulls":3},0,"SUPLEMENT"]
[null,"3rd",{"$nulls":3},0,"SUPLEMENT"]
[null,"4th",{"$nulls":3},0,"SUPLEMENT"]
[null,"5th",{"$nulls":3},0,"SUPLEMENT"]
[null,"6th",{"$nulls":3},0,"SUPLEMENT"]
["Extra","1st",{"$nulls":3},0,"SUPLEMENT"]
[null,"2nd",{"$nulls":3},0,"SUPLEMENT"]
[null,"3rd",{"$nulls":3},0,"SUPLEMENT"]
[null,"4th",{"$nulls":3},0,"SUPLEMENT"]
[null,"5th",{"$nulls":3},0,"SUPLEMENT"]
[null,"6th",{"$nulls":3},0,"SUPLEMENT"]

{"sheet":"GIRLS-TEAM","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,1],[3,3,3,6]]}
[{"$f":"CONCATENATE(SETUP!B3, \" - \", SETUP!B4)","v":"North Side, Snider, Luers - RESERVE - May 9th, 2018"}]
["GIRLS"]
[]
["TEAM RESULTS",null,null,"OUTSTANDING INDIVIDUALS",{"$nulls":4},"Scores should be automatically updated when"]
["Sum of Points",null,null,"Sum of Points",{"$nulls":4},"changes are made on the GIRLS results sheet"]
["School","Total",null,"Event Type","Contestant(s)","School","Total"]
[{"$nulls":8},"You can manually update each table by right-"]
["Snider",49,{"$nulls":6},"clicking on each table and choosing \"Refresh\""]
["NS",25]
["BL",7]