{"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 - VARSITY","<-- 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 - VARSITY - May 9th, 2018"}]
["BOYS"]
["Event","Place","School","Contestant(s)","Time/Dist.","Points","Event Type"]
["4X8m RELAY","1st","Snider","Graham","00:09:31.500",{"$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","NS","Haltom","00:09:48.900",{"$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","NS","Lockett",15.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","NS","Jones",15.9,{"$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","Clack",10.7,{"$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","Derrick",11.1,{"$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","Haupert",11.2,{"$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","BL","Keating",11.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","Snider","Jennings","00:04:54",{"$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","Slater","00:05:00.700",{"$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","BL","Bushe","00:05:01.100",{"$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","Pentoha","00:05:07.600",{"$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",null,43.4,{"$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","BL",null,44.2,{"$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","NS",null,44.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","Snider","Mccoy",53.3,{"$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","Graham",55.4,{"$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","Graham",55.5,{"$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",{"$nulls":3},{"$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","BL","Braun",43.6,{"$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","NS","Lockett",45.8,{"$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","NS","Franklin",45.9,{"$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","Snider","Lance",48.9,{"$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","Williams","00:02:07.100",{"$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","Schlegel","00:02:10.600",{"$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","Hill","00:02:13",{"$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","Mendoza","00:02:13.900",{"$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","Clack",22.3,{"$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","BL","Gaston",22.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","NS","White",23.4,{"$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","Brewer",23.5,{"$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","Snider","Agnew","00:10:28.300",{"$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","Snider","Schmucker","00:10:31.100",{"$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","NS","Lehmkhule","00:10:50",{"$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","NS","Francis","00:12:03.800",{"$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:04:23.010",{"$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:36.100",{"$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","Johnson","47' 7\"",{"$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","Holtz","44' 5\"",{"$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","BL","Hendricks","39' 1/2\"",{"$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","Snider","Wright","117' 2\"",{"$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","Snider","Belizaire","116' 4\"",{"$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","NS","Williams","108' 1\"",{"$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","BL","Hendricks","107' 8\"",{"$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","NS","Franklin","5'6\"",{"$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","NS","Collins","5'4\"",{"$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","BL","Gaston"," 20' 11 1/2\"",{"$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","NS","Franklin","19' 8\"",{"$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","Snider","Jones","19' 3 1/2\"",{"$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","NS","Leach","18' 9 1/2\"",{"$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","NS","Harris","9'6\"",{"$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","NS","Adams","9'0\"",{"$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","Rider","Snider","8'0\"",{"$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":22,"n_cols":9,"rows_kept":22,"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 - VARSITY - 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"]
["Snider",70,null,"Field","Franklin","NS",8,null,"You can manually update each table by right-"]
["NS",63,null,null,"Wright","Snider",5,null,"clicking on each table and choosing \"Refresh\""]
["BL",23,null,null,"Harris","NS",5]
["Rider",2,null,null,"Gaston","BL",5]
[{"$nulls":4},"Johnson","Snider",5]
[{"$nulls":3},"Track","Clack","NS",10]
[{"$nulls":4},"Lockett","NS",8]
[{"$nulls":4},"Mccoy","Snider",5]
[{"$nulls":4},"Braun","BL",5]
[{"$nulls":4},"Williams","Snider",5]
[{"$nulls":4},"Agnew","Snider",5]
[{"$nulls":4},"Graham","Snider",2]
[{"$nulls":5},"NS",3]
[{"$nulls":4},"Jennings","Snider",5]
[{"$nulls":3},"Relay","Graham","Snider",5]
[{"$nulls":4},"Haltom","NS",3]

{"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 - VARSITY - May 9th, 2018"}]
["GIRLS"]
["Event","Place","School","Contestant(s)","Time/Dist.","Points","Event Type"]
["4X8m RELAY","1st","BL","McManus","00:10:52.300",{"$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","NS","Curry","00:11:52.900",{"$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","Moore",17,{"$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","Snider","Warfield",17.7,{"$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","Snider","Gentry",18.2,{"$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","NS","Coleman",18.5,{"$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","Wade",12.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","Gorman",12.6,{"$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","Shakoor",13.3,{"$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","BL","Young",13.5,{"$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","McManus","00:05:34",{"$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","BL","Busch","00:05:47.800",{"$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","NS","Curry","00:05:52.400",{"$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","Snider","Galastine","00:06:00.400",{"$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",null,51,{"$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","BL","Javins",55.2,{"$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","Johnson","00:01:01.100",{"$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","BL","Javins","00:01:02.400",{"$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","Benson","00:01:02.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","Jackson","00:01:04.100",{"$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","Snider","Hardy",49.6,{"$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","NS","Coleman",52.4,{"$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","BL","Hawkins","00:02:33.800",{"$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","BL","Hall","00:02:35",{"$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","BL","Heiny","00:02:39.300",{"$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","Nuggent","00:02:42.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","Snider","Foreman",26.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","NS","Lane",27.2,{"$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","Jackson",27.4,{"$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","BL","Javins",27.6,{"$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","BL","McManus","00:11:55.200",{"$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","BL","Busch","00:12:39.300",{"$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","NS","Wilchar","00:12:49.100",{"$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","BL","Mulhullen","00:12:52",{"$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:04:14.300",{"$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:04:14.700",{"$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","BL",null,"00:04:32.800",{"$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","Trotter","36'4\"",{"$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","Weekes","34'0\"",{"$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","BL","Knapke","33'10\"",{"$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","BL","Gladding","25'4\"",{"$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","Snider","Habisch","93' 10\"",{"$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","Snider","Hurt","92' 8\"",{"$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","Snider","Bonner","82' 10\"",{"$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","BL","Knapke","77' 11\"",{"$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","NS","Wichar","4'4\"",{"$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","Snider","Hedrick","4'2\"",{"$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","BL","Young","15' 6 1/2\"",{"$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","NS","Coleman","14' 5 3/4\"",{"$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","NS","Wilchar","14' 3 1/2\"",{"$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","NS","Shakoor","14' 1 1/2\"",{"$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","Snider","Gottfried","6'0\"",{"$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 - VARSITY - 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",69,{"$nulls":6},"clicking on each table and choosing \"Refresh\""]
["NS",37]
["BL",49]