{"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":0,"defined_names":30,"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":64,"n_cols":30,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Lists used on other sheets…",null,null,"Year of Meet: ",2018,null,null,"Title: ","QUEEN CITY INVITATIONAL 2018",null,null,null,null,null,"Yes No Reply"]
[null,null,null,null,null,null,null,"Dates: ","January 19-21, 2018",null,null,null,null,null,"Yes"]
["Note: ","Hide this sheet normally, ",null,null,null,null,null,"Deadline: ","Tues. Nov. 28, 2017",null,null,null,null,null,"No"]
[null,"especially before sending the file to clubs.",null,null,null,null,null,null,null,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).    Nat'l levels use age as of Dec 31 in current 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","Dev:  JO 1-2",60,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,1)","v":0},null,1," SK"," Queen City ","Queen City Gymnastics Club","Regina",null,1,"Development:  ","JO-1","X",null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X"]
["WAG","Prov:  JO 3-8",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,2)","v":0},null,2," SK","Airborne","Airborne Gymnastics Club","Weyburn",null,1,"Development:  ","JO-2","X",null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X"]
["WAG","Nat'l:  JO 9-10",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,3)","v":0},null,3," SK","Battleford","Battlefords Gymnastics Club","North Battleford",null,2,"Provincial: ","JO-3","X","X"]
["WAG","Aspire 1-2",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,4)","v":0},null,4," SK","Calico","Calico Gymnastics Club","Humboldt",null,2,"Provincial: ","JO-4","X","X","X"]
["WAG","High Performance",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,5)","v":0},null,5," SK","Can-Am","Can-Am Gymnastics Club","Saskatoon",null,2,"Provincial: ","JO-5","X","X","X"]
["MAG","JO 3",50,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,6)","v":0},null,6," SK","Estevan","Estevan Gymnastics Club","Estevan",null,2,"Provincial: ","JO-6","X","X","X"]
["MAG","JO 4-7",90,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,7)","v":0},null,7," SK","Explosion","Explosion Gymnastics Club","Lloydminster",null,2,"Provincial: ","JO-7","X","X","X","X"]
["MAG","Prov 4-5",90,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,8)","v":0},null,8," SK","Gelico","Gelico Gymnastics Club","Swift Current",null,2,"Provincial: ","JO-8","X","X","X","X"]
["MAG","Elite 3-4",90,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,9)","v":0},null,9," SK","Gym Adv","Gymnastics Adventure Inc.","Regina",null,3,"National: ","JO-9","X","X","X","X","X"]
["MAG","Nat'l",90,{"$f":"COUNTIF('MAG Gymnasts'!$M$5:$M$64,10)","v":0},null,10," SK","Gymtastiks","Gymtastiks Gymnastics Club","Moose Jaw",null,3,"National: ","JO-10","X","X","X","X","X","X"]
[null,null,null,null,null,11," SK","Jumpers","Moose Mountain Jumpers Gymnastics Club","Carlyle",null,4,"Aspire: ","Aspire 1","X","X","X",null,null,null,"X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,12," SK","Leapers","Lampman Leapers Gymnastics Club","Lampman",null,4,"Aspire: ","Aspire 2","X","X","X","X",null,null,null,"X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,13," SK","Marian","Marian Gymnastics Club","Saskatoon",null,5,"High Performance:  ","HP Novice","X","X","X","X","X",null,null,null,"X","X","X","X","X","X","X","X"]
[null,null,null,null,null,14," SK","Outlook","Outlook Gymnastics Club","Outlook",null,5,"High Performance:  ","HP Junior","X","X","X","X","X","X",null,null,null,null,"X","X","X","X","X","X"]
[null,null,null,null,null,15," SK","PA Aerials","Aerials Gymnastics Club","Prince Albert",null,5,"High Performance:  ","HP Senior","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,16," SK","Perf. Bal.","Perfect Balance Gymnastics Club","Hudson Bay"]
[null,null,null,null,null,17," SK","Rose","Rosetown Gymnastics Club","Rosetown"]
[null,null,null,null,null,18," SK","Springers-SK","Shamrock Springers Gymnastics Club","Yorkton"]
[null,null,null,null,null,19," SK","Taiso","Taiso Gymnastics Club","Saskatoon",null,"Code for",null,null,"Ages…  (in competitive year)",null,null,null,"Probably not needed, no sublevels.  May be used to check valid ages for some like HP ARGO, etc."]
[null,null,null,null,null,20,"SK","Tumblers","Tumblers Gymnastics","Martensville",null,"Fees Level",null,"MAG_Categories",6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,null,null,null,null,20," SK","Turn-a-Row","Turn-A-Row Gymnastics Club","Wadena",null,6,"Developmental: ","JO-3"]
[null,null,null,null,null,21," SK","Twisters","Twisters Gymnastics Club","Tisdale",null,7,"Jr. Olympic: ","JO-4"]
[null,null,null,null,null,22," SK","Zero Gravity","Zero Gravity Gymnastics Club","Gull Lake",null,7,"Jr. Olympic: ","JO-5"]
[null,null,null,null,null,null," SK-end","______________","~","~",null,7,"Jr. Olympic: ","JO-6"]
[null,null,null,null,null,1,"AB","Altadore-AB","Altadore Gymnastics Club","Calgary, AB",null,7,"Jr. Olympic: ","JO-7"]
[null,null,null,null,null,2,"AB","Calgary Gym-AB","Calgary Gymnastics Centre","Calgary, AB",null,8,"Provincial: ","Prov. Level 3 (12 & up)"]
[null,null,null,null,null,3,"AB","Capital City-AB","Capital City Gymnastics Club","Edmonton, AB",null,8,"Provincial: ","Prov. Level 4"]
[null,null,null,null,null,4,"AB","Champions-AB","Champions Gymnastics Club","Edmonton, AB",null,8,"Provincial: ","Prov. Level 5"]
[null,null,null,null,null,5,"AB","Dynamix-AB","Dynamix Gymnastics Club","St. Albert",null,9,"Elite: ","Elite 3"]
[null,null,null,null,null,6,"AB","Exalta-AB","Exalta Gymnastics Club","Red Deer, AB",null,9,"Elite: ","Elite 4"]
[null,null,null,null,null,7,"AB","Gymtastics-AB","Gymtastics ","Calgary, AB",null,10,"National: ","Nat'l Open"]
[null,null,null,null,null,8,"AB","Mtn Shadows-AB","Mountain Shadows Gymnastics Club","Okotoks, AB",null,10,"National: ","Nat'l Junior 14-15"]
[null,null,null,null,null,9,"AB","Ortona-AB","Ortona Gymnastics Club","Edmonton, AB",null,10,"National: ","Nat'l Junior 16-17"]
[null,null,null,null,null,10,"AB","Phoenix-AB","Phoenix Gymnastics Centre","Edmonton",null,10,"National: ","Nat'l Senior"]
[null,null,null,null,null,11,"AB","Salta-AB","Salta Gymnastics Club","Medicine Hat, AB"]
[null,null,null,null,null,12,"AB","SG Aerials-AB","Spruce Grove Aerials Gymnastics Club","Spruce Grove, AB"]
[null,null,null,null,null,13,"AB","Stampede-AB","Stampede City Gymnastics Club","Calgary, AB",null,null,null,"FastCat_Trampoline_Levels"]
[null,null,null,null,null,14,"AB","Westwind-AB","Westwind Gymnastics Club","Lethbridge, AB",null,null,"FastCat: ","FastCat TRA 1"]
[null,null,null,null,null,null,"AB-end","______________","~","~",null,null,null,"FastCat TRA 2"]
[null,null,null,null,null,1,"MB","Eagles-MB","Eagles Gymnastics Club","Brandon, MB",null,null,null,"FastCat TRA 3"]
[null,null,null,null,null,2,"MB","Keystone-MB","Keystone Kips Gymnastics Club","Winnipeg, MB"]
[null,null,null,null,null,3,"MB","Panthers-MB","Panthers Gymnastics Club","Winnipeg, MB",null,null,null,"FastCat_Tumbling_Levels"]
[null,null,null,null,null,4,"MB","Springers-MB","Springers Gymnastics Club","Winnipeg, MB",null,null,null,"FastCat TUM 1"]
[null,null,null,null,null,null,"MB-end","______________","~","~",null,null,null,"FastCat TUM 2"]
[null,"List of Months",null,null,null,null,null,null,null,null,null,null,null,"FastCat TUM 3"]
[1,"Jan"]
[2,"Feb",null,null,null,null,null,null,null,null,null,null,null,"FastCat_Double_Mini_Levels"]
[3,"Mar",null,null,null,null,null,null,null,null,null,null,null,"FastCat DMT 1"]
[4,"Apr",null,null,null,null,null,null,null,null,null,null,null,"FastCat DMT 2",null,"IF(ISBLANK(H5),\"\",H5&\"  \"&INDEX(WAG_SubCategories,J5,K5))"]
[5,"May",null,null,null,null,null,null,null,null,null,null,null,"FastCat DMT 3","Category & level Formula:"]
[6,"Jun",null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT CHANGE;  reference for future use."]
[7,"Jul",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"]
[8,"Aug"]
[9,"Sep"]
[10,"Oct"]
[11,"Nov"]
[12,"Dec"]

{"sheet":"Summary","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"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!I1","v":"QUEEN CITY INVITATIONAL 2018"}]
["This",null,null,null,{"$f":"Meet_Dates","v":"January 19-21, 2018"}]
["Col."]
[null,null,null,null,"MEET REGISTRATION FOR CLUBS"]
[]
[null,null,null,null,"ENTRY DEADLINE: ",{"$f":"Lists!I3","v":"Tues. Nov. 28, 2017"}]
[]
[null,null,null,null,"When completed, email this file to: ","QCGC Meet Director"]
[]
[]
[null,null,null,"Choose your club:  "]
[null,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_Name),\"\",INDEX(Club_Name,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,"QUEEN CITY GYMNASTICS CLUB"]
[null,null,null,"City  /  PC:",null,null,null,null,{"$f":"\"Send the cheque by \"&Entry_Deadline& \" to:\"","v":"Send the cheque by Tues. Nov. 28, 2017 to:"}]
[null,null,null,null,null,null,null,null,"455 Maxwell Crescent   ~   Regina, SK   ~   S4N 5X9"]
[null,null,null,"Email:",null,null,null,null,"Phone:  (306) 539-9630    (Meet Director - Sherie Franklin)"]
[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,"NOTE:    A late 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."]
[null,null,"WAG:  Dev:  Jr Olympic 1-2",{"$f":"Lists!D8","v":0},{"$f":"Lists!C8","v":60},{"$f":"D24*E24","v":0}]
[null,null,"WAG:  Prov:  Jr Olympic 3-8",{"$f":"Lists!D9","v":0},{"$f":"Lists!C9","v":90},{"$f":"D25*E25","v":0}]
[null,null,"WAG:  Nat'l:  Jr Olympic 9-10",{"$f":"Lists!D10","v":0},{"$f":"Lists!C10","v":90},{"$f":"D26*E26","v":0}]
[null,null,"WAG:  Aspire 1-2",{"$f":"Lists!D11","v":0},{"$f":"Lists!C11","v":90},0]
[null,null,"WAG: HP  (Novice, Jr, Sr)",{"$f":"Lists!D12","v":0},{"$f":"Lists!C12","v":90},{"$f":"D28*E28","v":0}]
[null,null,"MAG:  Dev:  JO 3",{"$f":"Lists!D13","v":0},{"$f":"Lists!C13","v":50},{"$f":"D29*E29","v":0}]
[null,null,"MAG:  Jr. Olympic  4-7",{"$f":"Lists!D14","v":0},{"$f":"Lists!C14","v":90},0]
[null,null,"MAG:  Prov. 3-5",{"$f":"Lists!D15","v":0},{"$f":"Lists!C15","v":90},0]
[null,null,"MAG:  Elite 3 & 4",{"$f":"Lists!D16","v":0},{"$f":"Lists!C16","v":90},0]
[null,null,"MAG:  Nat'l (Open, Jr, Sr)",{"$f":"Lists!D17","v":0},{"$f":"Lists!C17","v":90},0]
[null,null,null,null,"Total Fees:   ",{"$f":"SUM(F24:F33)","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":"Meet_Name","v":"QUEEN CITY INVITATIONAL 2018"},null,"CLUB REGISTRATIONS - WAG GYMNASTS",null,null,null,null,null,null,"Hide Col.","Hide Col.","Hide Col.",null,null,"Hide Col."]
[null,{"$f":"Meet_Dates","v":"January 19-21, 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 \"&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,Year_of_Meet-F5-1)","v":0},{"$f":"IF(ISBLANK(I5),0,MATCH(I5,WAG_Categories,0))","v":0},{"$f":"IF(J5=0,0,MATCH(J5,WAG_Age_Range,0))","v":0},{"$f":"IF(K5=0,0,INDEX(Lists!$L$8:$L$22,K5))","v":0},"No",null,{"$f":"IF(K5+L5=0,0,INDEX(WAG_SubCategories,K5,L5))","v":0}]
[2,null,null,"",{"$f":"IF(ISBLANK(C6),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K6=0,0,INDEX(Lists!$L$8:$L$22,K6))","v":0},"No",null,0]
[3,null,null,"",{"$f":"IF(ISBLANK(C7),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K7=0,0,INDEX(Lists!$L$8:$L$22,K7))","v":0},"No",null,0]
[4,null,null,"",{"$f":"IF(ISBLANK(C8),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K8=0,0,INDEX(Lists!$L$8:$L$22,K8))","v":0},"No",null,0]
[5,null,null,"",{"$f":"IF(ISBLANK(C9),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K9=0,0,INDEX(Lists!$L$8:$L$22,K9))","v":0},"No",null,0]
[6,null,null,"",{"$f":"IF(ISBLANK(C10),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K10=0,0,INDEX(Lists!$L$8:$L$22,K10))","v":0},"No",null,0]
[7,null,null,"",{"$f":"IF(ISBLANK(C11),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K11=0,0,INDEX(Lists!$L$8:$L$22,K11))","v":0},"No",null,0]
[8,null,null,"",{"$f":"IF(ISBLANK(C12),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K12=0,0,INDEX(Lists!$L$8:$L$22,K12))","v":0},"No",null,0]
[9,null,null,"",{"$f":"IF(ISBLANK(C13),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K13=0,0,INDEX(Lists!$L$8:$L$22,K13))","v":0},"No",null,0]
[10,null,null,"",{"$f":"IF(ISBLANK(C14),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K14=0,0,INDEX(Lists!$L$8:$L$22,K14))","v":0},"No",null,0]
[11,null,null,"",{"$f":"IF(ISBLANK(C15),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K15=0,0,INDEX(Lists!$L$8:$L$22,K15))","v":0},"No",null,0]
[12,null,null,"",{"$f":"IF(ISBLANK(C16),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K16=0,0,INDEX(Lists!$L$8:$L$22,K16))","v":0},"No",null,0]
[13,null,null,"",{"$f":"IF(ISBLANK(C17),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K17=0,0,INDEX(Lists!$L$8:$L$22,K17))","v":0},"No",null,0]
[14,null,null,"",{"$f":"IF(ISBLANK(C18),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K18=0,0,INDEX(Lists!$L$8:$L$22,K18))","v":0},"No",null,0]
[15,null,null,"",{"$f":"IF(ISBLANK(C19),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K19=0,0,INDEX(Lists!$L$8:$L$22,K19))","v":0},"No",null,0]
[16,null,null,"",{"$f":"IF(ISBLANK(C20),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K20=0,0,INDEX(Lists!$L$8:$L$22,K20))","v":0},"No",null,0]
[17,null,null,"",{"$f":"IF(ISBLANK(C21),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K21=0,0,INDEX(Lists!$L$8:$L$22,K21))","v":0},"No",null,0]
[18,null,null,"",{"$f":"IF(ISBLANK(C22),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K22=0,0,INDEX(Lists!$L$8:$L$22,K22))","v":0},"No",null,0]
[19,null,null,"",{"$f":"IF(ISBLANK(C23),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K23=0,0,INDEX(Lists!$L$8:$L$22,K23))","v":0},"No",null,0]
[20,null,null,"",{"$f":"IF(ISBLANK(C24),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K24=0,0,INDEX(Lists!$L$8:$L$22,K24))","v":0},"No",null,0]
[21,null,null,"",{"$f":"IF(ISBLANK(C25),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K25=0,0,INDEX(Lists!$L$8:$L$22,K25))","v":0},"No",null,0]
[22,null,null,null,{"$f":"IF(ISBLANK(C26),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K26=0,0,INDEX(Lists!$L$8:$L$22,K26))","v":0},"No",null,0]
[23,null,null,{"$f":"IF(ISBLANK(C27),\"\",This_Clubs_Abbrev)","v":""},{"$f":"IF(ISBLANK(C27),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K27=0,0,INDEX(Lists!$L$8:$L$22,K27))","v":0},"No",null,0]
[24,null,null,"",{"$f":"IF(ISBLANK(C28),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K28=0,0,INDEX(Lists!$L$8:$L$22,K28))","v":0},"No",null,0]
[25,null,null,"",{"$f":"IF(ISBLANK(C29),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K29=0,0,INDEX(Lists!$L$8:$L$22,K29))","v":0},"No",null,0]
[26,null,null,"",{"$f":"IF(ISBLANK(C30),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K30=0,0,INDEX(Lists!$L$8:$L$22,K30))","v":0},"No",null,0]
[27,null,null,"",{"$f":"IF(ISBLANK(C31),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K31=0,0,INDEX(Lists!$L$8:$L$22,K31))","v":0},"No",null,0]
[28,null,null,"",{"$f":"IF(ISBLANK(C32),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K32=0,0,INDEX(Lists!$L$8:$L$22,K32))","v":0},"No",null,0]
[29,null,null,"",{"$f":"IF(ISBLANK(C33),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K33=0,0,INDEX(Lists!$L$8:$L$22,K33))","v":0},"No",null,0]
[30,null,null,"",{"$f":"IF(ISBLANK(C34),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K34=0,0,INDEX(Lists!$L$8:$L$22,K34))","v":0},"No",null,0]
[31,null,null,"",{"$f":"IF(ISBLANK(C35),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K35=0,0,INDEX(Lists!$L$8:$L$22,K35))","v":0},"No",null,0]
[32,null,null,"",{"$f":"IF(ISBLANK(C36),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K36=0,0,INDEX(Lists!$L$8:$L$22,K36))","v":0},"No",null,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,Year_of_Meet-F37-1)","v":0},{"$f":"IF(ISBLANK(I37),0,MATCH(I37,WAG_Categories,0))","v":0},{"$f":"IF(J37=0,0,MATCH(J37,WAG_Age_Range,0))","v":0},{"$f":"IF(K37=0,0,INDEX(Lists!$L$8:$L$22,K37))","v":0},"No",null,{"$f":"IF(K37+L37=0,0,INDEX(WAG_SubCategories,K37,L37))","v":0}]
[34,null,null,"",{"$f":"IF(ISBLANK(C38),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K38=0,0,INDEX(Lists!$L$8:$L$22,K38))","v":0},"No",null,0]
[35,null,null,"",{"$f":"IF(ISBLANK(C39),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K39=0,0,INDEX(Lists!$L$8:$L$22,K39))","v":0},"No",null,0]
[36,null,null,"",{"$f":"IF(ISBLANK(C40),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K40=0,0,INDEX(Lists!$L$8:$L$22,K40))","v":0},"No",null,0]
[37,null,null,"",{"$f":"IF(ISBLANK(C41),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K41=0,0,INDEX(Lists!$L$8:$L$22,K41))","v":0},"No",null,0]
[38,null,null,"",{"$f":"IF(ISBLANK(C42),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K42=0,0,INDEX(Lists!$L$8:$L$22,K42))","v":0},"No",null,0]
[39,null,null,"",{"$f":"IF(ISBLANK(C43),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K43=0,0,INDEX(Lists!$L$8:$L$22,K43))","v":0},"No",null,0]
[40,null,null,"",{"$f":"IF(ISBLANK(C44),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K44=0,0,INDEX(Lists!$L$8:$L$22,K44))","v":0},"No",null,0]
[41,null,null,"",{"$f":"IF(ISBLANK(C45),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K45=0,0,INDEX(Lists!$L$8:$L$22,K45))","v":0},"No",null,0]
[42,null,null,"",{"$f":"IF(ISBLANK(C46),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K46=0,0,INDEX(Lists!$L$8:$L$22,K46))","v":0},"No",null,0]
[43,null,null,"",{"$f":"IF(ISBLANK(C47),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K47=0,0,INDEX(Lists!$L$8:$L$22,K47))","v":0},"No",null,0]
[44,null,null,"",{"$f":"IF(ISBLANK(C48),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K48=0,0,INDEX(Lists!$L$8:$L$22,K48))","v":0},"No",null,0]
[45,null,null,"",{"$f":"IF(ISBLANK(C49),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K49=0,0,INDEX(Lists!$L$8:$L$22,K49))","v":0},"No",null,0]
[46,null,null,"",{"$f":"IF(ISBLANK(C50),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K50=0,0,INDEX(Lists!$L$8:$L$22,K50))","v":0},"No",null,0]
[47,null,null,"",{"$f":"IF(ISBLANK(C51),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K51=0,0,INDEX(Lists!$L$8:$L$22,K51))","v":0},"No",null,0]
[48,null,null,"",{"$f":"IF(ISBLANK(C52),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K52=0,0,INDEX(Lists!$L$8:$L$22,K52))","v":0},"No",null,0]
[49,null,null,"",{"$f":"IF(ISBLANK(C53),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K53=0,0,INDEX(Lists!$L$8:$L$22,K53))","v":0},"No",null,0]
[50,null,null,"",{"$f":"IF(ISBLANK(C54),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K54=0,0,INDEX(Lists!$L$8:$L$22,K54))","v":0},"No",null,0]
[51,null,null,"",{"$f":"IF(ISBLANK(C55),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K55=0,0,INDEX(Lists!$L$8:$L$22,K55))","v":0},"No",null,0]
[52,null,null,"",{"$f":"IF(ISBLANK(C56),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K56=0,0,INDEX(Lists!$L$8:$L$22,K56))","v":0},"No",null,0]
[53,null,null,"",{"$f":"IF(ISBLANK(C57),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K57=0,0,INDEX(Lists!$L$8:$L$22,K57))","v":0},"No",null,0]
[54,null,null,"",{"$f":"IF(ISBLANK(C58),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K58=0,0,INDEX(Lists!$L$8:$L$22,K58))","v":0},"No",null,0]
[55,null,null,"",{"$f":"IF(ISBLANK(C59),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K59=0,0,INDEX(Lists!$L$8:$L$22,K59))","v":0},"No",null,0]
[56,null,null,"",{"$f":"IF(ISBLANK(C60),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K60=0,0,INDEX(Lists!$L$8:$L$22,K60))","v":0},"No",null,0]
[57,null,null,"",{"$f":"IF(ISBLANK(C61),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K61=0,0,INDEX(Lists!$L$8:$L$22,K61))","v":0},"No",null,0]
[58,null,null,"",{"$f":"IF(ISBLANK(C62),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K62=0,0,INDEX(Lists!$L$8:$L$22,K62))","v":0},"No",null,0]
[59,null,null,"",{"$f":"IF(ISBLANK(C63),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K63=0,0,INDEX(Lists!$L$8:$L$22,K63))","v":0},"No",null,0]
[60,null,null,"",{"$f":"IF(ISBLANK(C64),\"\",Summary!$G$13)","v":""},null,null,"",null,0,0,0,{"$f":"IF(K64=0,0,INDEX(Lists!$L$8:$L$22,K64))","v":0},"No",null,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":"QUEEN CITY INVITATIONAL 2018"},null,null,null,null,null,null,null,null,null,null,{"$f":"Meet_Dates","v":"January 19-21, 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":false,"merged":[[2,10,2,11]]}
[null,{"$f":"Meet_Name","v":"QUEEN CITY INVITATIONAL 2018"},null,"CLUB REGISTRATION - MEN"]
[null,{"$f":"Meet_Dates","v":"January 19-21, 2018"},"Club:  ",{"$f":"This_Clubs_FullName","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Used to get full cat name",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","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":false,"merged":[[4,2,4,5],[7,3,8,3],[7,4,8,4]]}
[null,{"$f":"Meet_Name","v":"QUEEN CITY INVITATIONAL 2018"},null,null,null,null,null,null,null,null,null,{"$f":"Meet_Dates","v":"January 19-21, 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,"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":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Password for all sheets:"]
[]
[null,"GymScore-Registration"]