{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Lists","Summary","WAG Gymnasts","WAG Coaches & Judges","MAG Gymnasts","MAG Coaches & Judges","Pswd"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":69,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":66,"n_cols":30,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["Lists used on other sheets…",null,null,"Year of Meet: ",2018,null,null,"Meet Name: ","2018 Marian Classic",null,null,null,null,null,"Yes No Reply"]
[null,null,null,null,null,null,null,"Dates: ","February 9-11, 2018",null,null,null,null,null,"Yes"]
["Note: ","Hide this sheet normally, ",null,null,null,null,null,"Deadline: ","Tues. Jan. 16, 2018",null,null,null,null,null,"No"]
[null,"especially before sending the file to clubs.",null,null,null,null,null,"Late Entrry Fee: ",50,null,null,null,null,null,null,null,"Note: Change these age groups within the categories as needed - see Gym Sask guide in November each year for the following season."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year of Competition: ",{"$f":"Year_of_Meet","v":2018},"**  Ages shown are as of end of previous year (aka the start of this year).  "]
[null,"FEES:",null,null,null,null,null,"Invited Gym Clubs…",null,null,null,"Code for",null,"Year Born:",{"$f":"N5-6","v":2012},{"$f":"O6-1","v":2011},{"$f":"P6-1","v":2010},2009,2008,2007,2006,2005,2004,2003,2002,2001,2000,1999,1998,1997]
[null,"Level","$/gymnast","# gymnasts",null,null,"Prov.","Club_Abbr","Club_Name","Club_City",null,"Fees Level","WAG_Categories  ",{"$f":"\"Age at start of \" &$N$5&\":\"","v":"Age at start of 2018:"},{"$f":"$N$5-O6-1","v":5},{"$f":"O7+1","v":6},{"$f":"P7+1","v":7},8,9,10,11,12,13,14,15,16,17,18,19,20]
["WAG","Interclub:  Dev, Masters",null,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E8)","v":0},1,1," SK","Airborne","Airborne Gymnastics Club","Weyburn",null,1,"Interclub: ","Masters","X"]
["WAG","Interclub:  JO 1-2",60,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E9)","v":0},2,2," SK","Battleford","Battlefords Gymnastics Club","North Battleford",null,1,"Interclub: ","Developmental","X"]
["WAG","Prov:  JO 3-8, JO 9(P)",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E10)","v":0},3,3," SK","Calico","Calico Gymnastics Club","Humboldt",null,2,"Interclub: ","JO-1","X"]
["WAG","Nat'l:  JO 9(N), JO 10",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E11)","v":0},4,4," SK","Can-Am","Can-Am Gymnastics Club","Saskatoon",null,2,"Interclub: ","JO-2","X"]
["WAG","Aspire 1-2",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E12)","v":0},5,5," SK","Estevan","Estevan Gymnastics Club","Estevan",null,3,"Provincial: ","JO-3","X","X","2009-2010","2009-2010",2008,2007,"2005-2006","2005-2006","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before"]
["WAG","High Performance",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E13)","v":0},6,6," SK","Explosion","Explosion Gymnastics Club","Lloydminster",null,3,"Provincial: ","JO-4","X","X","X","2008-2009","2008-2009","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before"]
["MAG","Interclub:  Masters",null,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,$E14)","v":0},1,7," SK","Gelico","Gelico Gymnastics Club","Swift Current",null,3,"Provincial: ","JO-5","X","X","X","2009 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before"]
["MAG","Interclub:  JO-1, JO-2, JO-3",null,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,$E15)","v":0},2,8," SK","Gym Adv","Gymnastics Adventure Inc.","Regina",null,3,"Provincial: ","JO-6","X","X","X","2007-2009","2007-2009","2007-2009","2005-2006","2005-2006","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before"]
["MAG","Prov:  JO 4-7",null,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,$E16)","v":0},3,9," SK","Gymtastiks","Gymtastiks Gymnastics Club","Moose Jaw",null,3,"Provincial: ","JO-7","X","X","X","X","2006-2008","2006-2008","2006-2008","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before"]
["MAG","Prov:  P4 - P5",null,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,$E17)","v":0},4,10," SK","Jumpers","Moose Mountain Jumpers Gymnastics Club","Carlyle",null,3,"Provincial: ","JO-8","X","X","X","X","2006-2008","2006-2008","2006-2008","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before"]
["MAG","Nat'l:  Elite 3-4",null,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,$E18)","v":0},5,11," SK","Leapers","Lampman Leapers Gymnastics Club","Lampman",null,3,"Provincial: ","JO-9 (Prov)","X","X","X","X","X","X","X","X","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before"]
["MAG","Nat'l: Open, Jr, Sr",null,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,$E19)","v":0},6,12," SK","Marian","Marian Gymnastics Club","Saskatoon",null,4,"National: ","JO-9 (Nat'l)","X","X","X","X","X","2005-2007","2005-2007","2005-2007","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,13," SK","Outlook","Outlook Gymnastics Club","Outlook",null,4,"National: ","JO-10","X","X","X","X","X","X","2003-2006","2003-2006","2003-2006","2003-2006","2002 & before","2002 & before","2002 & before","2002 & before","2002 & before","2002 & before"]
[null,null,null,null,null,14," SK","PA Aerials","Aerials Gymnastics Club","Prince Albert",null,5,"Aspire: ","Aspire 1 (Prov)","X","X","X",null,null,null,"X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,15," SK","Perf. Bal.","Perfect Balance Gymnastics Club","Hudson Bay",null,5,"Aspire: ","Aspire 2 (Nat'l)","X","X","X","X",null,null,"X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,16," SK","Queen City ","Queen City Gymnastics Club","Regina",null,6,"National: ","HP Novice","X","X","X","X","X",null,null,null,"X","X","X","X","X","X","X","X"]
[null,null,null,null,null,17," SK","Rose","Rosetown Gymnastics Club","Rosetown",null,6,"National: ","HP Junior","X","X","X","X","X","X",null,null,null,null,"X","X","X","X","X","X"]
[null,null,null,null,null,18," SK","Springers-SK","Shamrock Springers Gymnastics Club","Yorkton",null,6,"National: ","HP Senior","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,19," SK","Taiso","Taiso Gymnastics Club","Saskatoon"]
[null,null,null,null,null,20," SK","Tumblers","Tumblers Gymnastics","Martensville"]
[null,null,null,null,null,21," SK","Turn-a-Row","Turn-A-Row Gymnastics Club","Wadena"]
[null,null,null,null,null,22," SK","Twisters","Twisters Gymnastics Club","Tisdale",null,"Code for",null,null,"Ages…  (in competitive year)",null,null,null,"Probably not needed, no sublevels."]
[null,null,null,null,null,23," SK","Zero Gravity","Zero Gravity Gymnastics Club","Gull Lake",null,"Fees Level",null,"MAG_Categories",{"$f":"O7","v":5},{"$f":"P7","v":6},7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null," SK-end","______________","~","~",null,1,"InterClub: ","Masters"]
[null,null,null,null,null,1,"AB","Altadore-AB","Altadore Gymnastics Club","Calgary, AB",null,2,"InterClub: ","JO-1"]
[null,null,null,null,null,2,"AB","Calgary Gym-AB","Calgary Gymnastics Centre","Calgary, AB",null,2,"InterClub: ","JO-2"]
[null,null,null,null,null,3,"AB","Capital City-AB","Capital City Gymnastics Club","Edmonton, AB",null,2,"InterClub: ","JO-3"]
[null,null,null,null,null,4,"AB","Champions-AB","Champions Gymnastics Club","Edmonton, AB",null,3,"Jr. Olympic: ","JO-4"]
[null,null,null,null,null,5,"AB","Dynamix-AB","Dynamix Gymnastics Club","St. Albert",null,3,"Jr. Olympic: ","JO-5"]
[null,null,null,null,null,6,"AB","Exalta-AB","Exalta Gymnastics Club","Red Deer, AB",null,3,"Jr. Olympic: ","JO-6"]
[null,null,null,null,null,7,"AB","Gymtastics-AB","Gymtastics ","Calgary, AB",null,3,"Jr. Olympic: ","JO-7"]
[null,null,null,null,null,8,"AB","Mtn Shadows-AB","Mountain Shadows Gymnastics Club","Okotoks, AB",null,4,"Provincial: ","Prov. Level 4"]
[null,null,null,null,null,9,"AB","Ortona-AB","Ortona Gymnastics Club","Edmonton, AB",null,4,"Provincial: ","Prov. Level 5"]
[null,null,null,null,null,10,"AB","Phoenix-AB","Phoenix Gymnastics Centre","Edmonton",null,5,"Elite: ","Elite 3"]
[null,null,null,null,null,11,"AB","Salta-AB","Salta Gymnastics Club","Medicine Hat, AB",null,5,"Elite: ","Elite 4"]
[null,null,null,null,null,12,"AB","SG Aerials-AB","Spruce Grove Aerials Gymnastics Club","Spruce Grove, AB",null,6,"National: ","Nat'l Open"]
[null,null,null,null,null,13,"AB","Stampede-AB","Stampede City Gymnastics Club","Calgary, AB",null,6,"National: ","Nat'l Junior (14-15)"]
[null,null,null,null,null,14,"AB","Westwind-AB","Westwind Gymnastics Club","Lethbridge, AB",null,6,"National: ","Nat'l Junior (16-17)"]
[null,null,null,null,null,null,"AB-end","______________","~","~",null,6,"National: ","Nat'l Senior (18)"]
[null,null,null,null,null,1,"MB","Eagles-MB","Eagles Gymnastics Club","Brandon, MB",null,6,"National: ","Nat'l Senior (19+)"]
[null,null,null,null,null,2,"MB","Keystone-MB","Keystone Kips Gymnastics Club","Winnipeg, MB"]
[null,null,null,null,null,3,"SK","Tumblers","Tumblers Gymnastics","Martensville"]
[null,null,null,null,null,4,"MB","Panthers-MB","Panthers Gymnastics Club","Winnipeg, MB",null,null,null,"FastCat_Trampoline_Levels"]
[null,null,null,null,null,5,"MB","Springers-MB","Springers Gymnastics Club","Winnipeg, MB",null,null,"FastCat: ","FastCat TRA 1"]
[null,null,null,null,null,null,"MB-end","______________","~","~",null,null,null,"FastCat TRA 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FastCat TRA 3"]
[null,"List of Months"]
[1,"Jan",null,null,null,null,null,null,null,null,null,null,null,"FastCat_Tumbling_Levels"]
[2,"Feb",null,null,null,null,null,null,null,null,null,null,null,"FastCat TUM 1"]
[3,"Mar",null,null,null,null,null,null,null,null,null,null,null,"FastCat TUM 2"]
[4,"Apr",null,null,null,null,null,null,null,null,null,null,null,"FastCat TUM 3"]
[5,"May"]
[6,"Jun",null,null,null,null,null,null,null,null,null,null,null,"FastCat_Double_Mini_Levels"]
[7,"Jul",null,null,null,null,null,null,null,null,null,null,null,"FastCat DMT 1"]
[8,"Aug",null,null,null,null,null,null,null,null,null,null,null,"FastCat DMT 2",null,"IF(ISBLANK(H5),\"\",H5&\"  \"&INDEX(WAG_SubCategories,J5,K5))"]
[9,"Sep",null,null,null,null,null,null,null,null,null,null,null,"FastCat DMT 3","Category & level Formula:"]
[10,"Oct",null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT CHANGE;  reference for future use."]
[11,"Nov",null,null,null,null,null,null,null,null,null,null,null,null,"For use in column 'M' on the WAG sheet once the real levels are known"]
[12,"Dec"]

{"sheet":"Summary","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[19,8,19,10],[14,4,14,5],[16,8,16,10],[0,4,0,6],[14,8,14,10],[15,8,15,10],[17,8,17,10],[18,8,18,10],[18,4,18,5],[15,4,15,5],[12,4,12,5],[5,5,5,6]]}
["Hide",null,null,null,{"$f":"Lists!Meet_Name","v":"2018 Marian Classic"}]
["This",null,null,null,{"$f":"Lists!Meet_Dates","v":"February 9-11, 2018"}]
["Col."]
[null,null,null,null,"MEET REGISTRATION FOR CLUBS"]
[]
[null,null,null,null,"ENTRY DEADLINE: ",{"$f":"Lists!Entry_Deadline","v":"Tues. Jan. 16, 2018"}]
[]
[null,null,null,null,"When completed, email this file to: ","Meet Director"]
[]
[]
[null,null,null,"Choose your club:  "]
["index",null,null,"Abbrev.","Club Name",null,"City"]
[{"$f":"MATCH(D13,Club_Abbr,0)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ISBLANK(This_Clubs_Abbrev),\"\",INDEX(Lists!I8:I52,A13))","v":""},null,{"$f":"IF(ISBLANK(This_Clubs_Name),\"\",INDEX(Club_City,A13))","v":""}]
[null,null,null,"Contact person:  "]
[null,null,null,"Name:",null,null,null,null,"Please make one cheque payable to …"]
[null,null,null,"Address:",null,null,null,null,"MARIAN GYMNASTICS CLUB"]
[null,null,null,"City  /  PC:"]
[null,null,null,null,null,null,null,null,{"$f":"\"Send the cheque by \"&Lists!Entry_Deadline& \" to:\"","v":"Send the cheque by Tues. Jan. 16, 2018 to:"}]
[null,null,null,"Email:",null,null,null,null,"343 Edson Street   ~   Saskatoon SK   ~   S7J 4C8"]
[null,null,null,"Phone #  /  Cell #:"]
[null,null,null,null,null,null,null,null,"Registration is not complete until fees and athlete release forms have been received."]
[null,null,"Fee Summary…","(Based on the WAG & MAG athlete sheets)",null,null,null,null,{"$f":"\"NOTE:    A late entry fee of $\"&Late_Entry_Fee&\" per gymnast will be charged.\"","v":"NOTE:    A late entry fee of $50 per gymnast will be charged."}]
[null,null,"Discipline / Type","# Gymnasts","Fee per gymnast","Amount   ",null,null,"Refunds will be issued only for medical reasons upon receipt of a doctor’s certificate."]
[1,null,"WAG:  Interclub:  Masters, Devel.",{"$f":"INDEX(WAG_NumGymnasts,$A24)","v":0},{"$f":"INDEX(WAG_Fees,$A24)","v":0},{"$f":"Summ_NumGymnasts*Summ_FeesPerGymnast","v":0}]
[2,null,"WAG:  Interclub:  Jr Olympic 1-2",0,60,0]
[3,null,"WAG:  Prov:  Jr Olympic 3-8, JO-9(P)",0,90,0]
[4,null,"WAG:  Nat'l:  Jr Olympic 9(N), JO-10",0,90,0]
[5,null,"WAG:  Nat'l:  Aspire 1-2",0,90,0]
[6,null,"WAG:  Nat'l:  HP  (Novice, Jr, Sr)",0,90,0,{"$f":"SUM(D24:D29)&\"  WAG Gymnasts\"","v":"0  WAG Gymnasts"}]
[1,null,"MAG:  Interclub:  Masters",{"$f":"INDEX(MAG_NumGymnasts,$A30)","v":0},{"$f":"INDEX(MAG_Fees,$A30)","v":0},0]
[2,null,"MAG:  Interclub:  JO 1 - JO 3",0,0,0]
[3,null,"MAG:  Prov.  Jr. Olympic  4-7",0,0,0]
[4,null,"MAG:  InterProv. 3-5",0,0,0]
[5,null,"MAG:  Nat'l Elite 3 & 4",0,0,0]
[6,null,"MAG:  Nat'l (Open, Jr, Sr)",0,0,0,{"$f":"SUM(D30:D35)&\"  MAG Gymnasts\"","v":"0  MAG Gymnasts"}]
[null,null,null,null,"Total Fees:   ",{"$f":"SUM(F24:F35)","v":0}]

{"sheet":"WAG Gymnasts","index":2,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,3,1,7]]}
[null,{"$f":"Lists!Meet_Name","v":"2018 Marian Classic"},null,"CLUB REGISTRATIONS - WAG GYMNASTS",null,null,null,null,null,null,"Hide Col.","Hide Col.","Hide Col.",null,null,"Hide Col."]
[null,{"$f":"Lists!Meet_Dates","v":"February 9-11, 2018"},"Club: ",{"$f":"This_Clubs_FullName","v":""}]
[null,"xx"]
[null,"First Name","Last Name","Club","City","Year Born","Month Born","Category & age group","Category",{"$f":"\"Age at start of \"&Lists!Year_of_Meet","v":"Age at start of 2018"},"Index 1","Index 2","Category Fee Code","Elite Screening","Comment"]
[1,null,null,{"$f":"IF(ISBLANK(C5),\"\",This_Clubs_Abbrev)","v":""},{"$f":"IF(ISBLANK(C5),\"\",Summary!$G$13)","v":""},null,null,{"$f":"IF(ISBLANK(I5),\"\",I5&IF(P5=0,\"\",\"  (\"&P5&\")\"))","v":""},null,{"$f":"IF(F5=0,0,Lists!Year_of_Meet-F5-1)","v":0},{"$f":"IF(ISBLANK(I5),0,MATCH(I5,WAG_CategoryNames,0))","v":0},{"$f":"IF(J5=0,0,MATCH(J5,Lists!WAG_Age_Range,0))","v":0},{"$f":"IF(K5=0,0,INDEX(WAG_Fee_Codes,K5))","v":0},"No",null,{"$f":"IF(K5+L5=0,0,INDEX(Lists!WAG_SubCategories,K5,L5))","v":0}]
[2,null,null,"",{"$f":"IF(ISBLANK(C6),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F6=0,0,Lists!Year_of_Meet-F6-1)","v":0},0,{"$f":"IF(J6=0,0,MATCH(J6,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K6+L6=0,0,INDEX(Lists!WAG_SubCategories,K6,L6))","v":0}]
[3,null,null,"",{"$f":"IF(ISBLANK(C7),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F7=0,0,Lists!Year_of_Meet-F7-1)","v":0},0,{"$f":"IF(J7=0,0,MATCH(J7,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K7+L7=0,0,INDEX(Lists!WAG_SubCategories,K7,L7))","v":0}]
[4,null,null,"",{"$f":"IF(ISBLANK(C8),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F8=0,0,Lists!Year_of_Meet-F8-1)","v":0},0,{"$f":"IF(J8=0,0,MATCH(J8,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K8+L8=0,0,INDEX(Lists!WAG_SubCategories,K8,L8))","v":0}]
[5,null,null,"",{"$f":"IF(ISBLANK(C9),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F9=0,0,Lists!Year_of_Meet-F9-1)","v":0},0,{"$f":"IF(J9=0,0,MATCH(J9,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K9+L9=0,0,INDEX(Lists!WAG_SubCategories,K9,L9))","v":0}]
[6,null,null,"",{"$f":"IF(ISBLANK(C10),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F10=0,0,Lists!Year_of_Meet-F10-1)","v":0},0,{"$f":"IF(J10=0,0,MATCH(J10,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K10+L10=0,0,INDEX(Lists!WAG_SubCategories,K10,L10))","v":0}]
[7,null,null,"",{"$f":"IF(ISBLANK(C11),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F11=0,0,Lists!Year_of_Meet-F11-1)","v":0},0,{"$f":"IF(J11=0,0,MATCH(J11,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K11+L11=0,0,INDEX(Lists!WAG_SubCategories,K11,L11))","v":0}]
[8,null,null,"",{"$f":"IF(ISBLANK(C12),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F12=0,0,Lists!Year_of_Meet-F12-1)","v":0},0,{"$f":"IF(J12=0,0,MATCH(J12,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K12+L12=0,0,INDEX(Lists!WAG_SubCategories,K12,L12))","v":0}]
[9,null,null,"",{"$f":"IF(ISBLANK(C13),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F13=0,0,Lists!Year_of_Meet-F13-1)","v":0},0,{"$f":"IF(J13=0,0,MATCH(J13,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K13+L13=0,0,INDEX(Lists!WAG_SubCategories,K13,L13))","v":0}]
[10,null,null,"",{"$f":"IF(ISBLANK(C14),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F14=0,0,Lists!Year_of_Meet-F14-1)","v":0},0,{"$f":"IF(J14=0,0,MATCH(J14,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K14+L14=0,0,INDEX(Lists!WAG_SubCategories,K14,L14))","v":0}]
[11,null,null,"",{"$f":"IF(ISBLANK(C15),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F15=0,0,Lists!Year_of_Meet-F15-1)","v":0},0,{"$f":"IF(J15=0,0,MATCH(J15,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K15+L15=0,0,INDEX(Lists!WAG_SubCategories,K15,L15))","v":0}]
[12,null,null,"",{"$f":"IF(ISBLANK(C16),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F16=0,0,Lists!Year_of_Meet-F16-1)","v":0},0,{"$f":"IF(J16=0,0,MATCH(J16,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K16+L16=0,0,INDEX(Lists!WAG_SubCategories,K16,L16))","v":0}]
[13,null,null,"",{"$f":"IF(ISBLANK(C17),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F17=0,0,Lists!Year_of_Meet-F17-1)","v":0},0,{"$f":"IF(J17=0,0,MATCH(J17,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K17+L17=0,0,INDEX(Lists!WAG_SubCategories,K17,L17))","v":0}]
[14,null,null,"",{"$f":"IF(ISBLANK(C18),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F18=0,0,Lists!Year_of_Meet-F18-1)","v":0},0,{"$f":"IF(J18=0,0,MATCH(J18,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K18+L18=0,0,INDEX(Lists!WAG_SubCategories,K18,L18))","v":0}]
[15,null,null,"",{"$f":"IF(ISBLANK(C19),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F19=0,0,Lists!Year_of_Meet-F19-1)","v":0},0,{"$f":"IF(J19=0,0,MATCH(J19,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K19+L19=0,0,INDEX(Lists!WAG_SubCategories,K19,L19))","v":0}]
[16,null,null,"",{"$f":"IF(ISBLANK(C20),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F20=0,0,Lists!Year_of_Meet-F20-1)","v":0},0,{"$f":"IF(J20=0,0,MATCH(J20,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K20+L20=0,0,INDEX(Lists!WAG_SubCategories,K20,L20))","v":0}]
[17,null,null,"",{"$f":"IF(ISBLANK(C21),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F21=0,0,Lists!Year_of_Meet-F21-1)","v":0},0,{"$f":"IF(J21=0,0,MATCH(J21,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K21+L21=0,0,INDEX(Lists!WAG_SubCategories,K21,L21))","v":0}]
[18,null,null,"",{"$f":"IF(ISBLANK(C22),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F22=0,0,Lists!Year_of_Meet-F22-1)","v":0},0,{"$f":"IF(J22=0,0,MATCH(J22,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K22+L22=0,0,INDEX(Lists!WAG_SubCategories,K22,L22))","v":0}]
[19,null,null,"",{"$f":"IF(ISBLANK(C23),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F23=0,0,Lists!Year_of_Meet-F23-1)","v":0},0,{"$f":"IF(J23=0,0,MATCH(J23,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K23+L23=0,0,INDEX(Lists!WAG_SubCategories,K23,L23))","v":0}]
[20,null,null,"",{"$f":"IF(ISBLANK(C24),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F24=0,0,Lists!Year_of_Meet-F24-1)","v":0},0,{"$f":"IF(J24=0,0,MATCH(J24,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K24+L24=0,0,INDEX(Lists!WAG_SubCategories,K24,L24))","v":0}]
[21,null,null,"",{"$f":"IF(ISBLANK(C25),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F25=0,0,Lists!Year_of_Meet-F25-1)","v":0},0,{"$f":"IF(J25=0,0,MATCH(J25,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K25+L25=0,0,INDEX(Lists!WAG_SubCategories,K25,L25))","v":0}]
[22,null,null,null,{"$f":"IF(ISBLANK(C26),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F26=0,0,Lists!Year_of_Meet-F26-1)","v":0},0,{"$f":"IF(J26=0,0,MATCH(J26,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K26+L26=0,0,INDEX(Lists!WAG_SubCategories,K26,L26))","v":0}]
[23,null,null,{"$f":"IF(ISBLANK(C27),\"\",This_Clubs_Abbrev)","v":""},{"$f":"IF(ISBLANK(C27),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F27=0,0,Lists!Year_of_Meet-F27-1)","v":0},0,{"$f":"IF(J27=0,0,MATCH(J27,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K27+L27=0,0,INDEX(Lists!WAG_SubCategories,K27,L27))","v":0}]
[24,null,null,"",{"$f":"IF(ISBLANK(C28),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F28=0,0,Lists!Year_of_Meet-F28-1)","v":0},0,{"$f":"IF(J28=0,0,MATCH(J28,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K28+L28=0,0,INDEX(Lists!WAG_SubCategories,K28,L28))","v":0}]
[25,null,null,"",{"$f":"IF(ISBLANK(C29),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F29=0,0,Lists!Year_of_Meet-F29-1)","v":0},0,{"$f":"IF(J29=0,0,MATCH(J29,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K29+L29=0,0,INDEX(Lists!WAG_SubCategories,K29,L29))","v":0}]
[26,null,null,"",{"$f":"IF(ISBLANK(C30),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F30=0,0,Lists!Year_of_Meet-F30-1)","v":0},0,{"$f":"IF(J30=0,0,MATCH(J30,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K30+L30=0,0,INDEX(Lists!WAG_SubCategories,K30,L30))","v":0}]
[27,null,null,"",{"$f":"IF(ISBLANK(C31),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F31=0,0,Lists!Year_of_Meet-F31-1)","v":0},0,{"$f":"IF(J31=0,0,MATCH(J31,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K31+L31=0,0,INDEX(Lists!WAG_SubCategories,K31,L31))","v":0}]
[28,null,null,"",{"$f":"IF(ISBLANK(C32),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F32=0,0,Lists!Year_of_Meet-F32-1)","v":0},0,{"$f":"IF(J32=0,0,MATCH(J32,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K32+L32=0,0,INDEX(Lists!WAG_SubCategories,K32,L32))","v":0}]
[29,null,null,"",{"$f":"IF(ISBLANK(C33),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F33=0,0,Lists!Year_of_Meet-F33-1)","v":0},0,{"$f":"IF(J33=0,0,MATCH(J33,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K33+L33=0,0,INDEX(Lists!WAG_SubCategories,K33,L33))","v":0}]
[30,null,null,"",{"$f":"IF(ISBLANK(C34),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F34=0,0,Lists!Year_of_Meet-F34-1)","v":0},0,{"$f":"IF(J34=0,0,MATCH(J34,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K34+L34=0,0,INDEX(Lists!WAG_SubCategories,K34,L34))","v":0}]
[31,null,null,"",{"$f":"IF(ISBLANK(C35),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F35=0,0,Lists!Year_of_Meet-F35-1)","v":0},0,{"$f":"IF(J35=0,0,MATCH(J35,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K35+L35=0,0,INDEX(Lists!WAG_SubCategories,K35,L35))","v":0}]
[32,null,null,"",{"$f":"IF(ISBLANK(C36),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F36=0,0,Lists!Year_of_Meet-F36-1)","v":0},0,{"$f":"IF(J36=0,0,MATCH(J36,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K36+L36=0,0,INDEX(Lists!WAG_SubCategories,K36,L36))","v":0}]
[33,null,null,"",{"$f":"IF(ISBLANK(C37),\"\",Summary!$G$13)","v":""},null,null,{"$f":"IF(ISBLANK(I37),\"\",I37&IF(P37=0,\"\",\"  (\"&P37&\")\"))","v":""},null,{"$f":"IF(F37=0,0,Lists!Year_of_Meet-F37-1)","v":0},{"$f":"IF(ISBLANK(I37),0,MATCH(I37,WAG_CategoryNames,0))","v":0},{"$f":"IF(J37=0,0,MATCH(J37,Lists!WAG_Age_Range,0))","v":0},{"$f":"IF(K37=0,0,INDEX(WAG_Fee_Codes,K37))","v":0},"No",null,{"$f":"IF(K37+L37=0,0,INDEX(Lists!WAG_SubCategories,K37,L37))","v":0}]
[34,null,null,"",{"$f":"IF(ISBLANK(C38),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F38=0,0,Lists!Year_of_Meet-F38-1)","v":0},0,{"$f":"IF(J38=0,0,MATCH(J38,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K38+L38=0,0,INDEX(Lists!WAG_SubCategories,K38,L38))","v":0}]
[35,null,null,"",{"$f":"IF(ISBLANK(C39),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F39=0,0,Lists!Year_of_Meet-F39-1)","v":0},0,{"$f":"IF(J39=0,0,MATCH(J39,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K39+L39=0,0,INDEX(Lists!WAG_SubCategories,K39,L39))","v":0}]
[36,null,null,"",{"$f":"IF(ISBLANK(C40),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F40=0,0,Lists!Year_of_Meet-F40-1)","v":0},0,{"$f":"IF(J40=0,0,MATCH(J40,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K40+L40=0,0,INDEX(Lists!WAG_SubCategories,K40,L40))","v":0}]
[37,null,null,"",{"$f":"IF(ISBLANK(C41),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F41=0,0,Lists!Year_of_Meet-F41-1)","v":0},0,{"$f":"IF(J41=0,0,MATCH(J41,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K41+L41=0,0,INDEX(Lists!WAG_SubCategories,K41,L41))","v":0}]
[38,null,null,"",{"$f":"IF(ISBLANK(C42),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F42=0,0,Lists!Year_of_Meet-F42-1)","v":0},0,{"$f":"IF(J42=0,0,MATCH(J42,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K42+L42=0,0,INDEX(Lists!WAG_SubCategories,K42,L42))","v":0}]
[39,null,null,"",{"$f":"IF(ISBLANK(C43),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F43=0,0,Lists!Year_of_Meet-F43-1)","v":0},0,{"$f":"IF(J43=0,0,MATCH(J43,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K43+L43=0,0,INDEX(Lists!WAG_SubCategories,K43,L43))","v":0}]
[40,null,null,"",{"$f":"IF(ISBLANK(C44),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F44=0,0,Lists!Year_of_Meet-F44-1)","v":0},0,{"$f":"IF(J44=0,0,MATCH(J44,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K44+L44=0,0,INDEX(Lists!WAG_SubCategories,K44,L44))","v":0}]
[41,null,null,"",{"$f":"IF(ISBLANK(C45),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F45=0,0,Lists!Year_of_Meet-F45-1)","v":0},0,{"$f":"IF(J45=0,0,MATCH(J45,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K45+L45=0,0,INDEX(Lists!WAG_SubCategories,K45,L45))","v":0}]
[42,null,null,"",{"$f":"IF(ISBLANK(C46),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F46=0,0,Lists!Year_of_Meet-F46-1)","v":0},0,{"$f":"IF(J46=0,0,MATCH(J46,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K46+L46=0,0,INDEX(Lists!WAG_SubCategories,K46,L46))","v":0}]
[43,null,null,"",{"$f":"IF(ISBLANK(C47),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F47=0,0,Lists!Year_of_Meet-F47-1)","v":0},0,{"$f":"IF(J47=0,0,MATCH(J47,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K47+L47=0,0,INDEX(Lists!WAG_SubCategories,K47,L47))","v":0}]
[44,null,null,"",{"$f":"IF(ISBLANK(C48),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F48=0,0,Lists!Year_of_Meet-F48-1)","v":0},0,{"$f":"IF(J48=0,0,MATCH(J48,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K48+L48=0,0,INDEX(Lists!WAG_SubCategories,K48,L48))","v":0}]
[45,null,null,"",{"$f":"IF(ISBLANK(C49),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F49=0,0,Lists!Year_of_Meet-F49-1)","v":0},0,{"$f":"IF(J49=0,0,MATCH(J49,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K49+L49=0,0,INDEX(Lists!WAG_SubCategories,K49,L49))","v":0}]
[46,null,null,"",{"$f":"IF(ISBLANK(C50),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F50=0,0,Lists!Year_of_Meet-F50-1)","v":0},0,{"$f":"IF(J50=0,0,MATCH(J50,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K50+L50=0,0,INDEX(Lists!WAG_SubCategories,K50,L50))","v":0}]
[47,null,null,"",{"$f":"IF(ISBLANK(C51),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F51=0,0,Lists!Year_of_Meet-F51-1)","v":0},0,{"$f":"IF(J51=0,0,MATCH(J51,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K51+L51=0,0,INDEX(Lists!WAG_SubCategories,K51,L51))","v":0}]
[48,null,null,"",{"$f":"IF(ISBLANK(C52),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F52=0,0,Lists!Year_of_Meet-F52-1)","v":0},0,{"$f":"IF(J52=0,0,MATCH(J52,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K52+L52=0,0,INDEX(Lists!WAG_SubCategories,K52,L52))","v":0}]
[49,null,null,"",{"$f":"IF(ISBLANK(C53),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F53=0,0,Lists!Year_of_Meet-F53-1)","v":0},0,{"$f":"IF(J53=0,0,MATCH(J53,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K53+L53=0,0,INDEX(Lists!WAG_SubCategories,K53,L53))","v":0}]
[50,null,null,"",{"$f":"IF(ISBLANK(C54),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F54=0,0,Lists!Year_of_Meet-F54-1)","v":0},0,{"$f":"IF(J54=0,0,MATCH(J54,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K54+L54=0,0,INDEX(Lists!WAG_SubCategories,K54,L54))","v":0}]
[51,null,null,"",{"$f":"IF(ISBLANK(C55),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F55=0,0,Lists!Year_of_Meet-F55-1)","v":0},0,{"$f":"IF(J55=0,0,MATCH(J55,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K55+L55=0,0,INDEX(Lists!WAG_SubCategories,K55,L55))","v":0}]
[52,null,null,"",{"$f":"IF(ISBLANK(C56),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F56=0,0,Lists!Year_of_Meet-F56-1)","v":0},0,{"$f":"IF(J56=0,0,MATCH(J56,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K56+L56=0,0,INDEX(Lists!WAG_SubCategories,K56,L56))","v":0}]
[53,null,null,"",{"$f":"IF(ISBLANK(C57),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F57=0,0,Lists!Year_of_Meet-F57-1)","v":0},0,{"$f":"IF(J57=0,0,MATCH(J57,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K57+L57=0,0,INDEX(Lists!WAG_SubCategories,K57,L57))","v":0}]
[54,null,null,"",{"$f":"IF(ISBLANK(C58),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F58=0,0,Lists!Year_of_Meet-F58-1)","v":0},0,{"$f":"IF(J58=0,0,MATCH(J58,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K58+L58=0,0,INDEX(Lists!WAG_SubCategories,K58,L58))","v":0}]
[55,null,null,"",{"$f":"IF(ISBLANK(C59),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F59=0,0,Lists!Year_of_Meet-F59-1)","v":0},0,{"$f":"IF(J59=0,0,MATCH(J59,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K59+L59=0,0,INDEX(Lists!WAG_SubCategories,K59,L59))","v":0}]
[56,null,null,"",{"$f":"IF(ISBLANK(C60),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F60=0,0,Lists!Year_of_Meet-F60-1)","v":0},0,{"$f":"IF(J60=0,0,MATCH(J60,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K60+L60=0,0,INDEX(Lists!WAG_SubCategories,K60,L60))","v":0}]
[57,null,null,"",{"$f":"IF(ISBLANK(C61),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F61=0,0,Lists!Year_of_Meet-F61-1)","v":0},0,{"$f":"IF(J61=0,0,MATCH(J61,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K61+L61=0,0,INDEX(Lists!WAG_SubCategories,K61,L61))","v":0}]
[58,null,null,"",{"$f":"IF(ISBLANK(C62),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F62=0,0,Lists!Year_of_Meet-F62-1)","v":0},0,{"$f":"IF(J62=0,0,MATCH(J62,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K62+L62=0,0,INDEX(Lists!WAG_SubCategories,K62,L62))","v":0}]
[59,null,null,"",{"$f":"IF(ISBLANK(C63),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F63=0,0,Lists!Year_of_Meet-F63-1)","v":0},0,{"$f":"IF(J63=0,0,MATCH(J63,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K63+L63=0,0,INDEX(Lists!WAG_SubCategories,K63,L63))","v":0}]
[60,null,null,"",{"$f":"IF(ISBLANK(C64),\"\",Summary!$G$13)","v":""},null,null,"",null,{"$f":"IF(F64=0,0,Lists!Year_of_Meet-F64-1)","v":0},0,{"$f":"IF(J64=0,0,MATCH(J64,Lists!WAG_Age_Range,0))","v":0},0,"No",null,{"$f":"IF(K64+L64=0,0,INDEX(Lists!WAG_SubCategories,K64,L64))","v":0}]

{"sheet":"WAG Coaches & Judges","index":3,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,2,4,5],[7,3,8,3],[7,4,8,4]]}
[null,{"$f":"Meet_Name","v":"2018 Marian Classic"},null,null,null,null,null,null,null,null,null,null,{"$f":"Meet_Dates","v":"February 9-11, 2018"}]
[null,"CLUB REGISTRATION - WAG COACHES & JUDGES"]
[null,"Indicate names of your coaches and judges and their sessions."]
[]
[null,"Club:  ",{"$f":"This_Clubs_FullName","v":""},null,null,null,null,null,"Please mark sessions with \"X\"."]
[null,null,null,null,null,null,null,"(Sessions & Schedule TBA)"]
[null,null,"Please spell names correctly.",null,null,"Session:",1,{"$f":"G7+1","v":2},{"$f":"H7+1","v":3},4,5,6,7]
[null,null,null,"NCCP\nLevel",null,null,{"$f":"IF(ISBLANK($G$7),\"\",\"Fri\")","v":"Fri"},"Sat","Sat","Sat","Sun","Sun","Sun"]
[null,null,"COACHES",null,null,null,{"$f":"IF(ISBLANK($G$7),\"\",\"Eve.\")","v":"Eve."},"Morn.","Aft.","Eve.","Morn.","Noon"," Afternoon"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[]
[]
[]
[null,null,null,null,null,"Session:",{"$f":"IF(ISBLANK($G$7),\"\",$G$7)","v":1},{"$f":"H7","v":2},3,4,5,6,7]
[null,null,null,null,null,null,{"$f":"G8","v":"Fri"},{"$f":"H8","v":"Sat"},"Sat","Sat","Sun","Sun","Sun"]
[null,null,"JUDGES","Level",null,null,{"$f":"G9","v":"Eve."},{"$f":"H9","v":"Morn."},"Aft.","Eve.","Morn.","Noon"," Afternoon"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]

{"sheet":"MAG Gymnasts","index":4,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":true,"merged":[[2,10,2,11]]}
[null,{"$f":"Meet_Name","v":"2018 Marian Classic"},null,"CLUB REGISTRATION - MEN"]
[null,{"$f":"Meet_Dates","v":"February 9-11, 2018"},"Club:  ",{"$f":"This_Clubs_FullName","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Used to get full cat name (WAG)",null,"Cat.","Elite"]
[null,"First Name","Last Name","Club","City","Birth Year","Birth Month","Category","Category",{"$f":"\"Age in\"&CHAR(13)&Year_of_Meet","v":"Age in\r2018"},"Index 1","Index 2","Level / Fee Code","Screening","Comment"]
[1,null,null,{"$f":"IF(ISBLANK(C5),\"\",This_Clubs_Name)","v":""},{"$f":"IF(ISBLANK(C5),\"\",Summary!$G$13)","v":""},null,null,{"$f":"I5","v":0},null,{"$f":"IF(F5=0,0,Year_of_Meet-F5)","v":0},{"$f":"IF(ISBLANK(I5),\"\",MATCH(I5,MAG_Categories,0))","v":""},{"$f":"IF(J5=0,\"\",MATCH(J5,MAG_Age_Range,0))","v":""},{"$f":"IF(ISBLANK(I5),\"\",INDEX(MAG_Fees_Codes,K5))","v":""},"No"]
[2,null,null,"",{"$f":"IF(ISBLANK(C6),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J6=0,\"\",MATCH(J6,MAG_Age_Range,0))","v":""},"","No"]
[3,null,null,"",{"$f":"IF(ISBLANK(C7),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J7=0,\"\",MATCH(J7,MAG_Age_Range,0))","v":""},"","No"]
[4,null,null,"",{"$f":"IF(ISBLANK(C8),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J8=0,\"\",MATCH(J8,MAG_Age_Range,0))","v":""},"","No"]
[5,null,null,"",{"$f":"IF(ISBLANK(C9),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J9=0,\"\",MATCH(J9,MAG_Age_Range,0))","v":""},"","No"]
[6,null,null,"",{"$f":"IF(ISBLANK(C10),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J10=0,\"\",MATCH(J10,MAG_Age_Range,0))","v":""},"","No"]
[7,null,null,"",{"$f":"IF(ISBLANK(C11),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J11=0,\"\",MATCH(J11,MAG_Age_Range,0))","v":""},"","No"]
[8,null,null,"",{"$f":"IF(ISBLANK(C12),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J12=0,\"\",MATCH(J12,MAG_Age_Range,0))","v":""},"","No"]
[9,null,null,"",{"$f":"IF(ISBLANK(C13),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J13=0,\"\",MATCH(J13,MAG_Age_Range,0))","v":""},"","No"]
[10,null,null,"",{"$f":"IF(ISBLANK(C14),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J14=0,\"\",MATCH(J14,MAG_Age_Range,0))","v":""},"","No"]
[11,null,null,"",{"$f":"IF(ISBLANK(C15),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J15=0,\"\",MATCH(J15,MAG_Age_Range,0))","v":""},"","No"]
[12,null,null,"",{"$f":"IF(ISBLANK(C16),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J16=0,\"\",MATCH(J16,MAG_Age_Range,0))","v":""},"","No"]
[13,null,null,"",{"$f":"IF(ISBLANK(C17),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J17=0,\"\",MATCH(J17,MAG_Age_Range,0))","v":""},"","No"]
[14,null,null,"",{"$f":"IF(ISBLANK(C18),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J18=0,\"\",MATCH(J18,MAG_Age_Range,0))","v":""},"","No"]
[15,null,null,"",{"$f":"IF(ISBLANK(C19),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J19=0,\"\",MATCH(J19,MAG_Age_Range,0))","v":""},"","No"]
[16,null,null,"",{"$f":"IF(ISBLANK(C20),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J20=0,\"\",MATCH(J20,MAG_Age_Range,0))","v":""},"","No"]
[17,null,null,"",{"$f":"IF(ISBLANK(C21),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J21=0,\"\",MATCH(J21,MAG_Age_Range,0))","v":""},"","No"]
[18,null,null,"",{"$f":"IF(ISBLANK(C22),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J22=0,\"\",MATCH(J22,MAG_Age_Range,0))","v":""},"","No"]
[19,null,null,"",{"$f":"IF(ISBLANK(C23),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J23=0,\"\",MATCH(J23,MAG_Age_Range,0))","v":""},"","No"]
[20,null,null,"",{"$f":"IF(ISBLANK(C24),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J24=0,\"\",MATCH(J24,MAG_Age_Range,0))","v":""},"","No"]
[21,null,null,"",{"$f":"IF(ISBLANK(C25),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J25=0,\"\",MATCH(J25,MAG_Age_Range,0))","v":""},"","No"]
[22,null,null,"",{"$f":"IF(ISBLANK(C26),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J26=0,\"\",MATCH(J26,MAG_Age_Range,0))","v":""},"","No"]
[23,null,null,"",{"$f":"IF(ISBLANK(C27),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J27=0,\"\",MATCH(J27,MAG_Age_Range,0))","v":""},"","No"]
[24,null,null,"",{"$f":"IF(ISBLANK(C28),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J28=0,\"\",MATCH(J28,MAG_Age_Range,0))","v":""},"","No"]
[25,null,null,"",{"$f":"IF(ISBLANK(C29),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J29=0,\"\",MATCH(J29,MAG_Age_Range,0))","v":""},"","No"]
[26,null,null,"",{"$f":"IF(ISBLANK(C30),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J30=0,\"\",MATCH(J30,MAG_Age_Range,0))","v":""},"","No"]
[27,null,null,"",{"$f":"IF(ISBLANK(C31),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J31=0,\"\",MATCH(J31,MAG_Age_Range,0))","v":""},"","No"]
[28,null,null,"",{"$f":"IF(ISBLANK(C32),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J32=0,\"\",MATCH(J32,MAG_Age_Range,0))","v":""},"","No"]
[29,null,null,"",{"$f":"IF(ISBLANK(C33),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J33=0,\"\",MATCH(J33,MAG_Age_Range,0))","v":""},"","No"]
[30,null,null,"",{"$f":"IF(ISBLANK(C34),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J34=0,\"\",MATCH(J34,MAG_Age_Range,0))","v":""},"","No"]
[31,null,null,"",{"$f":"IF(ISBLANK(C35),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J35=0,\"\",MATCH(J35,MAG_Age_Range,0))","v":""},"","No"]
[32,null,null,"",{"$f":"IF(ISBLANK(C36),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J36=0,\"\",MATCH(J36,MAG_Age_Range,0))","v":""},"","No"]
[33,null,null,{"$f":"IF(ISBLANK(C37),\"\",This_Clubs_Name)","v":""},{"$f":"IF(ISBLANK(C37),\"\",Summary!$G$13)","v":""},null,null,{"$f":"I37","v":0},null,{"$f":"IF(F37=0,0,Year_of_Meet-F37)","v":0},{"$f":"IF(ISBLANK(I37),\"\",MATCH(I37,MAG_Categories,0))","v":""},{"$f":"IF(J37=0,\"\",MATCH(J37,MAG_Age_Range,0))","v":""},{"$f":"IF(ISBLANK(I37),\"\",INDEX(MAG_Fees_Codes,K37))","v":""},"No"]
[34,null,null,"",{"$f":"IF(ISBLANK(C38),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J38=0,\"\",MATCH(J38,MAG_Age_Range,0))","v":""},"","No"]
[35,null,null,"",{"$f":"IF(ISBLANK(C39),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J39=0,\"\",MATCH(J39,MAG_Age_Range,0))","v":""},"","No"]
[36,null,null,"",{"$f":"IF(ISBLANK(C40),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J40=0,\"\",MATCH(J40,MAG_Age_Range,0))","v":""},"","No"]
[37,null,null,"",{"$f":"IF(ISBLANK(C41),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J41=0,\"\",MATCH(J41,MAG_Age_Range,0))","v":""},"","No"]
[38,null,null,"",{"$f":"IF(ISBLANK(C42),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J42=0,\"\",MATCH(J42,MAG_Age_Range,0))","v":""},"","No"]
[39,null,null,"",{"$f":"IF(ISBLANK(C43),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J43=0,\"\",MATCH(J43,MAG_Age_Range,0))","v":""},"","No"]
[40,null,null,"",{"$f":"IF(ISBLANK(C44),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J44=0,\"\",MATCH(J44,MAG_Age_Range,0))","v":""},"","No"]
[41,null,null,"",{"$f":"IF(ISBLANK(C45),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J45=0,\"\",MATCH(J45,MAG_Age_Range,0))","v":""},"","No"]
[42,null,null,"",{"$f":"IF(ISBLANK(C46),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J46=0,\"\",MATCH(J46,MAG_Age_Range,0))","v":""},"","No"]
[43,null,null,"",{"$f":"IF(ISBLANK(C47),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J47=0,\"\",MATCH(J47,MAG_Age_Range,0))","v":""},"","No"]
[44,null,null,"",{"$f":"IF(ISBLANK(C48),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J48=0,\"\",MATCH(J48,MAG_Age_Range,0))","v":""},"","No"]
[45,null,null,"",{"$f":"IF(ISBLANK(C49),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J49=0,\"\",MATCH(J49,MAG_Age_Range,0))","v":""},"","No"]
[46,null,null,"",{"$f":"IF(ISBLANK(C50),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J50=0,\"\",MATCH(J50,MAG_Age_Range,0))","v":""},"","No"]
[47,null,null,"",{"$f":"IF(ISBLANK(C51),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J51=0,\"\",MATCH(J51,MAG_Age_Range,0))","v":""},"","No"]
[48,null,null,"",{"$f":"IF(ISBLANK(C52),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J52=0,\"\",MATCH(J52,MAG_Age_Range,0))","v":""},"","No"]
[49,null,null,"",{"$f":"IF(ISBLANK(C53),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J53=0,\"\",MATCH(J53,MAG_Age_Range,0))","v":""},"","No"]
[50,null,null,"",{"$f":"IF(ISBLANK(C54),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J54=0,\"\",MATCH(J54,MAG_Age_Range,0))","v":""},"","No"]
[51,null,null,"",{"$f":"IF(ISBLANK(C55),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J55=0,\"\",MATCH(J55,MAG_Age_Range,0))","v":""},"","No"]
[52,null,null,"",{"$f":"IF(ISBLANK(C56),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J56=0,\"\",MATCH(J56,MAG_Age_Range,0))","v":""},"","No"]
[53,null,null,"",{"$f":"IF(ISBLANK(C57),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J57=0,\"\",MATCH(J57,MAG_Age_Range,0))","v":""},"","No"]
[54,null,null,"",{"$f":"IF(ISBLANK(C58),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J58=0,\"\",MATCH(J58,MAG_Age_Range,0))","v":""},"","No"]
[55,null,null,"",{"$f":"IF(ISBLANK(C59),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J59=0,\"\",MATCH(J59,MAG_Age_Range,0))","v":""},"","No"]
[56,null,null,"",{"$f":"IF(ISBLANK(C60),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J60=0,\"\",MATCH(J60,MAG_Age_Range,0))","v":""},"","No"]
[57,null,null,"",{"$f":"IF(ISBLANK(C61),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J61=0,\"\",MATCH(J61,MAG_Age_Range,0))","v":""},"","No"]
[58,null,null,"",{"$f":"IF(ISBLANK(C62),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J62=0,\"\",MATCH(J62,MAG_Age_Range,0))","v":""},"","No"]
[59,null,null,"",{"$f":"IF(ISBLANK(C63),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J63=0,\"\",MATCH(J63,MAG_Age_Range,0))","v":""},"","No"]
[60,null,null,"",{"$f":"IF(ISBLANK(C64),\"\",Summary!$G$13)","v":""},null,null,0,null,0,"",{"$f":"IF(J64=0,\"\",MATCH(J64,MAG_Age_Range,0))","v":""},"","No"]

{"sheet":"MAG Coaches & Judges","index":5,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":true,"merged":[[4,2,4,5],[7,3,8,3],[7,4,8,4]]}
[null,{"$f":"Meet_Name","v":"2018 Marian Classic"},null,null,null,null,null,null,null,null,null,{"$f":"Meet_Dates","v":"February 9-11, 2018"}]
[null,"CLUB REGISTRATION - WAG COACHES & JUDGES"]
[null,"Indicate names of your coaches and judges and their sessions."]
[]
[null,"Club:  ",{"$f":"This_Clubs_FullName","v":""},null,null,null,null,null,"Please mark sessions with \"X\"."]
[null,null,null,null,null,null,null,"(Sessions & Schedule TBA)"]
[null,null,"Please spell names correctly.",null,null,"Session:",1,{"$f":"G7+1","v":2},{"$f":"H7+1","v":3},4,5,6,7]
[null,null,null,"NCCP\nLevel",null,null,{"$f":"IF(ISBLANK($G$7),\"\",\"Fri\")","v":"Fri"},"Sat","Sat","Sat","Sun","Sun","Sun"]
[null,null,"COACHES",null,null,null,{"$f":"IF(ISBLANK($G$7),\"\",\"Eve.\")","v":"Eve."},"Morn.","Aft.","Eve.","Morn.","Aft.","Eve."]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[]
[]
[]
[null,null,null,null,null,"Session:",{"$f":"IF(ISBLANK($G$7),\"\",$G$7)","v":1},{"$f":"H7","v":2},3,4,5,6,7]
[null,null,null,null,null,null,{"$f":"G8","v":"Fri"},"Sat","Sat","Sat","Sun","Sun","Sun"]
[null,null,"JUDGES","Level",null,null,{"$f":"G9","v":"Eve."},"Morn.","Aft.","Eve.","Morn.","Aft.","Eve."]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]

{"sheet":"Pswd","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Password for all sheets:"]
[]
[null,"GymScore-Registration"]
[]
[]
[]
[null,"No Password needed - 2018"]