{"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":53,"comments":2,"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":150,"n_cols":39,"rows_kept":150,"cut":false,"hidden":true,"merged":[]}
["Lists used on other sheets…",null,null,"Year of Meet: ",2018,null,null,"Meet Name: ","2018 Can-Am Personal Best"]
[null,null,null,null,null,null,null,"Meet Dates: ","April 6-8, 2018"]
["Note: ","PROTECT & HIDE this sheet normally, ",null,null,null,null,null,"Entry Deadline: ","Mon. March 5, 2018"]
[null,"especially before sending the file to clubs.",null,null,null,null,null,"Late Entrry Fee: ",40]
[]
[null,"FEES:","Basic Fee",null,null,null,null,"Host Name: ","Can-Am Gymnastics Club"]
[null,"Level","$/gymnast","# gymnasts",null,null,null,"Host Addr: ","3702 Mitchelmore Ave."]
["WAG","WAG: Development, Masters",null,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E8)","v":0},"~",null,null,"Host City: ","Saskatoon, SK"]
["WAG","Jr. Olympic 1-2",60,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E9)","v":0},1,null,null,"Host Postal Code: ","S7P 0B9"]
["WAG","Jr. Olympic 3-7",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E10)","v":0},2,null,null,"Host Phone #: ","(306) 931-4031"]
["WAG","Jr. Olympic 8-10",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E11)","v":0},3]
["WAG","Aspire 1-2",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E12)","v":0},4]
["WAG","H.P.  (3-4 Events)",90,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E13)","v":0},5]
["WAG","H.P.  (1-2 Events)",45,{"$f":"COUNTIF('WAG Gymnasts'!$M$5:$M$64,$E14)","v":0},6]
["WAG","~","~","~",7]
["WAG","Registered for Western Trials",20,{"$f":"COUNTIF(WAG_Westerns_Trials,\"Yes\")","v":0},8]
["WAG","Registered for National Trials",20,{"$f":"COUNTIF(WAG_Natls_Trials,\"Yes\")","v":0},9,null,null,null,"List of Months","Yes No Reply"]
["MAG","MAG: Developmental",0,{"$f":"COUNTIF('MAG Gymnasts'!$N$5:$N$64,$E18)","v":0},1,null,null,1,"Jan","Yes"]
["MAG","MAG:  Interclub:  JO-1, JO-2",0,{"$f":"COUNTIF('MAG Gymnasts'!$N$5:$N$64,$E19)","v":0},2,null,null,2,"Feb","No"]
["MAG","MAG:  Prov:  JO 3-4",0,{"$f":"COUNTIF('MAG Gymnasts'!$N$5:$N$64,$E20)","v":0},3,null,null,3,"Mar"]
["MAG","MAG:  Prov:  P4 - P5",0,{"$f":"COUNTIF('MAG Gymnasts'!$N$5:$N$64,$E21)","v":0},4,null,null,4,"Apr"]
["MAG","MAG:  Nat'l:  Elite 3-4",0,{"$f":"COUNTIF('MAG Gymnasts'!$N$5:$N$64,$E22)","v":0},5,null,null,5,"May"]
["MAG","MAG:  Nat'l: Open, Jr, Sr",0,{"$f":"COUNTIF('MAG Gymnasts'!$N$5:$N$64,$E23)","v":0},6,null,null,6,"Jun"]
[null,null,null,null,null,null,null,7,"Jul"]
[null,"Note:  when fee is $0, that row is greyed out ",null,null,null,null,null,8,"Aug"]
[null,"on the 'Summary' sheet for fees.",null,null,null,null,null,9,"Sep"]
[null,null,null,null,null,null,null,10,"Oct"]
[null,"The summary sheet will use these labels too.",null,null,null,null,null,11,"Nov"]
[null,null,null,null,null,null,null,12,"Dec"]
[null,null,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).  "]
[null,null,null,null,null,null,null,null,null,null,null,"Code for",null,"Year Born:",{"$f":"N31-4","v":2014},{"$f":"O32-1","v":2013},{"$f":"P32-1","v":2012},{"$f":"Q32-1","v":2011},2010,2009,2008,2007,2006,2005,2004,2003,2002,2001,2000,1999,1998,{"$f":"AE32-1","v":1997},{"$f":"AF32-1","v":1996},{"$f":"AG32-1","v":1995},{"$f":"AH32-1","v":1994},{"$f":"AI32-1","v":1993},{"$f":"AJ32-1","v":1992},{"$f":"AK32-1","v":1991},{"$f":"AL32-1","v":1990}]
[null,null,null,null,null,null,null,null,null,".",null,"Fees Level","WAG_Categories  ",{"$f":"\"Age at start of \" &$N$31&\":\"","v":"Age at start of 2018:"},{"$f":"$N$31-O32-1","v":3},{"$f":"O33+1","v":4},{"$f":"P33+1","v":5},6,7,8,9,10,11,12,13,14,15,16,17,18,19,{"$f":"AE33+1","v":20},{"$f":"AF33+1","v":21},{"$f":"AG33+1","v":22},{"$f":"AH33+1","v":23},{"$f":"AI33+1","v":24},{"$f":"AJ33+1","v":25},{"$f":"AK33+1","v":26},{"$f":"AL33+1","v":27}]
[null,null,null,null,null,null,null,null,null,"JO-1",3,0,"Interclub: ","Masters","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"JO-2",4,0,"Interclub: ","Developmental",null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"~",5,1,"Interclub: ","JO-1","X","X","X"]
[null,null,null,null,null,null,null,null,null,"JO-3",6,1,"Interclub: ","JO-2","X","X","X"]
[null,null,null,null,null,null,null,null,null,"JO-4",7,99,"~","~"]
[null,null,null,null,null,null,null,null,null,"JO-5",8,2,"Provincial: ","JO-3","X","X","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","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before"]
[null,null,null,null,null,null,null,null,null,"JO-6",9,2,"Provincial: ","JO-4","X","X","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","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before","2007 & before"]
[null,null,null,null,null,null,null,null,null,"JO-7",10,2,"Provincial: ","JO-5","X","X","X","X","X","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before","2009 & before"]
[null,null,null,null,null,null,null,null,null,"~",11,2,"Provincial: ","JO-6","X","X","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","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before"]
[null,null,null,null,null,null,null,null,null,"JO-8",12,2,"Provincial: ","JO-7","X","X","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","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before"]
[null,null,null,null,null,null,null,null,null,"JO-9",13,99,"~","~"]
[null,null,null,null,null,null,null,null,null,"JO-10",14,3,"Provincial: ","JO-8","X","X","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","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before","2005 & before"]
[null,null,null,null,null,null,null,null,null,"Aspire 1",15,3,"Provincial: ","JO-9","X","X","X","X","X","X","X","2005-2007","2005-2007","2005-2009","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before","2004 & before"]
[null,null,null,null,null,null,null,null,null,"Aspire 2",16,3,"Provincial: ","JO-10","X","X","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","2002 & before","2002 & before","2002 & before","2002 & before","2002 & before","2002 & before","2002 & before"]
[null,null,null,null,null,null,null,null,null,"~",17,4,"Aspire: ","Aspire 1","X","X","X","X","X",null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"HP Novice  (3-4 events)",18,4,"Aspire: ","Aspire 2","X","X","X","X","X","X",null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"HP Junior   (3-4 events)",19,99,"~","~"]
[null,null,null,null,null,null,null,null,null,"HP Senior   (3-4 events)",20,5,"National: ","HP Novice  (3-4 events)","X","X","X","X","X","X","X",null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"HP Novice   (1-2 events)",21,5,"National: ","HP Junior   (3-4 events)","X","X","X","X","X","X","X","X",null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"HP Junior   (1-2 events)",22,5,"National: ","HP Senior   (3-4 events)","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,"HP Senior   (1-2 events)",23,6,"National: ","HP Novice   (1-2 events)","X","X","X","X","X","X","X",null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,6,"National: ","HP Junior   (1-2 events)","X","X","X","X","X","X","X","X",null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,6,"National: ","HP Senior   (1-2 events)","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,99,"~","~"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Code for",null,null,"**  Ages shown are as of end of previous year (aka the start of this year).  ",null,null,null,null,null,"Probably not needed, no sublevels."]
[null,null,null,null,null,null,null,null,null,"MAG_PopUpList_Categories",null,"Fees Level",null,"MAG_Categories",{"$f":"O33","v":3},{"$f":"P33","v":4},5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,{"$f":"AM33","v":27}]
[null,null,null,null,null,null,null,null,null,"-- No Categories Available --",0,0,"InterClub: ","Masters","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,0,"InterClub: ","Developmental",null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,0,"InterClub: ","JO-1","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,0,"InterClub: ","JO-2","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,0,"InterClub: ","JO-3","X","X","X"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Jr. Olympic: ","JO-4"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Jr. Olympic: ","JO-5"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Jr. Olympic: ","JO-6"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Jr. Olympic: ","JO-7"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Provincial: ","Prov. Level 3"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Provincial: ","Prov. Level 4"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Provincial: ","Prov. Level 5"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Elite: ","Elite 3"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Elite: ","Elite 4"]
[null,null,null,null,null,null,null,null,null,null,null,0,"National: ","Nat'l Open"]
[null,null,null,null,null,null,null,null,null,null,null,0,"National: ","Nat'l Junior (14-15)"]
[null,null,null,null,null,null,null,null,null,null,null,0,"National: ","Nat'l Junior (16-17)"]
[null,null,null,null,null,null,null,null,null,null,null,0,"National: ","Nat'l Senior (18)"]
[null,null,null,null,null,null,null,null,null,null,null,0,"National: ","Nat'l Senior (19+)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF(ISBLANK(H5),\"\",H5&\"  \"&INDEX(WAG_SubCategories,J5,K5))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category & level Formula:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT CHANGE;  reference for future use."]
[null,null,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"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Invited Gym Clubs…"]
[]
[null,null,null,null,null,null,"Prov.","Club_Abbr","Club_Name","Club_City"]
[null,null,null,null,null,1," SK","Airborne","Airborne Gymnastics Club","Weyburn"]
[null,null,null,null,null,2," SK","Battleford","Battlefords Gymnastics Club","North Battleford"]
[null,null,null,null,null,3," SK","Calico","Calico Gymnastics Club","Humboldt"]
[null,null,null,null,null,4," SK","Can-Am","Can-Am Gymnastics Club","Saskatoon"]
[null,null,null,null,null,5," SK","Estevan","Estevan Gymnastics Club","Estevan"]
[null,null,null,null,null,6," SK","Explosion","Explosion Gymnastics Club","Lloydminster"]
[null,null,null,null,null,7," SK","Gelico","Gelico Gymnastics Club","Swift Current"]
[null,null,null,null,null,8," SK","Gym Adv","Gymnastics Adventure Inc.","Regina"]
[null,null,null,null,null,9," SK","Gymtastiks","Gymtastiks Gymnastics Club","Moose Jaw"]
[null,null,null,null,null,10," SK","Jumpers","Moose Mountain Jumpers Gymnastics Club","Carlyle"]
[null,null,null,null,null,11," SK","Leapers","Lampman Leapers Gymnastics Club","Lampman"]
[null,null,null,null,null,12," SK","Marian","Marian Gymnastics Club","Saskatoon"]
[null,null,null,null,null,13," SK","Outlook","Outlook Gymnastics Club","Outlook"]
[null,null,null,null,null,14," SK","PA Aerials","Aerials Gymnastics Club","Prince Albert"]
[null,null,null,null,null,15," SK","Perf. Bal.","Perfect Balance Gymnastics Club","Hudson Bay"]
[null,null,null,null,null,16," SK","Queen City ","Queen City Gymnastics Club","Regina"]
[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,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,null,null,null,null,23," SK","Zero Gravity","Zero Gravity Gymnastics Club","Gull Lake"]
[null,null,null,null,null,null," SK-end","______________","~","~"]
[null,null,null,null,null,1,"AB","Altadore-AB","Altadore Gymnastics Club","Calgary, AB"]
[null,null,null,null,null,2,"AB","Calgary Gym-AB","Calgary Gymnastics Centre","Calgary, AB"]
[null,null,null,null,null,3,"AB","Capital City-AB","Capital City Gymnastics Club","Edmonton, AB"]
[null,null,null,null,null,4,"AB","Champions-AB","Champions Gymnastics Club","Edmonton, AB"]
[null,null,null,null,null,5,"AB","Dynamix-AB","Dynamix Gymnastics Club","St. Albert"]
[null,null,null,null,null,6,"AB","Exalta-AB","Exalta Gymnastics Club","Red Deer, AB"]
[null,null,null,null,null,7,"AB","Gymtastics-AB","Gymtastics ","Calgary, AB"]
[null,null,null,null,null,8,"AB","Mtn Shadows-AB","Mountain Shadows Gymnastics Club","Okotoks, AB"]
[null,null,null,null,null,9,"AB","Ortona-AB","Ortona Gymnastics Club","Edmonton, AB"]
[null,null,null,null,null,10,"AB","Phoenix-AB","Phoenix Gymnastics Centre","Edmonton"]
[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,null,null,14,"AB","Westwind-AB","Westwind Gymnastics Club","Lethbridge, AB"]
[null,null,null,null,null,null,"AB-end","______________","~","~"]
[null,null,null,null,null,1,"MB","Eagles-MB","Eagles Gymnastics Club","Brandon, MB"]
[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,null,null,4,"MB","Springers-MB","Springers Gymnastics Club","Winnipeg, MB"]
[null,null,null,null,null,5,"MB-end","______________","~","~"]
[null,null,null,null,null,null,"SK","Tumblers","Tumblers Gymnastics","Martensville"]

{"sheet":"Summary","index":1,"n_rows":41,"n_cols":9,"rows_kept":41,"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":"Meet_Name","v":"2018 Can-Am Personal Best"}]
["This",null,null,null,{"$f":"Meet_Dates","v":"April 6-8, 2018"}]
["Col.",null,null,null,null,null,"Version 2:  Feb. 6"]
[null,null,null,null,"MEET REGISTRATION FOR CLUBS"]
[]
[null,null,null,null,"ENTRY DEADLINE: ",{"$f":"Entry_Deadline","v":"Mon. March 5, 2018"}]
[]
[null,null,null,null,"When completed, email this file to: ","Can-Am Meet Director (Alex)"]
[]
[]
[null,null,null,"Choose your club:  "]
["index",null,null,"Abbrev.","Club Name",null,"City"]
[{"$f":"MATCH(D13,Club_Abbr,0)","v":11},null,"Start here -----> ","Leapers",{"$f":"IF(ISBLANK(This_Clubs_Abbrev),\"\",INDEX(Lists!I106:I150,A13))","v":"Lampman Leapers Gymnastics Club"},null,{"$f":"IF(ISBLANK(This_Clubs_Name),\"\",INDEX(Club_City,A13))","v":"Lampman"}]
[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,{"$f":"Host_Name","v":"Can-Am Gymnastics Club"}]
[null,null,null,"City  /  PC:",null,null,null,null,{"$f":"\"Send the cheque by \"&Entry_Deadline& \" to:\"","v":"Send the cheque by Mon. March 5, 2018 to:"}]
[null,null,null,null,null,null,null,null,{"$f":"Host_Addr & \"  ~  \" & Host_City & \"  ~  \" & Host_Postal_Code","v":"3702 Mitchelmore Ave.  ~  Saskatoon, SK  ~  S7P 0B9"}]
[null,null,null,"Email:",null,null,null,null,{"$f":"\"Phone:  \" & Host_Phone","v":"Phone:  (306) 931-4031"}]
[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,null,null,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 $40 per gymnast will be charged."}]
[null,null,"Fee Summary…","(Based on the WAG & MAG athlete sheets)",null,null,null,null,"Refunds will be issued only for medical reasons upon receipt of a doctor’s certificate."]
[null,null,"Discipline / Type","# Gymnasts","Basic Fee/Gymnast","Basic Amount   "]
[1,1,{"$f":"INDEX(WAG_Levels,$A25)","v":"WAG: Development, Masters"},{"$f":"INDEX(WAG_NumGymnasts,$A25)","v":0},{"$f":"INDEX(WAG_Fees,$A25)","v":0},{"$f":"Summ_NumGymnasts*Summ_FeesPerGymnast","v":0}]
[2,2,"Jr. Olympic 1-2",0,60,0]
[3,3,"Jr. Olympic 3-7",0,90,0]
[4,4,"Jr. Olympic 8-10",0,90,0]
[5,5,"Aspire 1-2",0,90,0]
[6,6,"H.P.  (3-4 Events)",0,90,0]
[7,7,"H.P.  (1-2 Events)",0,45,0,{"$f":"\" Total # of Gymnasts: \" & SUM(D26:D31)","v":" Total # of Gymnasts: 0"}]
[8,8,"~","~","~","~",{"$f":"SUM(D25:D34)","v":0}]
[9,9,"Registered for Western Trials",0,20,0]
[10,9,"Registered for National Trials",0,20,0]
[1,10,{"$f":"INDEX(MAG_Levels,$A35)","v":"MAG: Developmental"},{"$f":"INDEX(MAG_NumGymnasts,$A35)","v":0},{"$f":"INDEX(MAG_Fees,$A35)","v":0},0]
[2,11,"MAG:  Interclub:  JO-1, JO-2",0,0,0]
[3,12,"MAG:  Prov:  JO 3-4",0,0,0]
[4,13,"MAG:  Prov:  P4 - P5",0,0,0]
[5,14,"MAG:  Nat'l:  Elite 3-4",0,0,0,{"$f":"SUM(D35:D40)","v":0}]
[6,15,"MAG:  Nat'l: Open, Jr, Sr",0,0,0,{"$f":"G39&\"  MAG Gymnast\"& IF(G39=1,\"\",\"s\") &\" ($\"&SUM(F35:F40)&\")\"","v":"0  MAG Gymnasts ($0)"}]
[null,12,null,null,"Total Fees:   ",{"$f":"SUM(F25:F40)","v":0}]

{"sheet":"WAG Gymnasts","index":2,"n_rows":64,"n_cols":17,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,3,1,7]]}
[null,{"$f":"Meet_Name","v":"2018 Can-Am Personal Best"},null,"CLUB REGISTRATIONS - WAG GYMNASTS",null,null,null,null,null,null,"Hide Col.","Hide Col.","Hide Col.",null,null,null,"Hide Col."]
[null,{"$f":"Meet_Dates","v":"April 6-8, 2018"},"Club: ",{"$f":"This_Clubs_FullName","v":"Lampman Leapers Gymnastics Club"}]
[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"},"Category - Index 1","YOB  - Index 2","Category Fee Code","Western Trials","Nat'l Trials","Comment","Age sub-cat"]
[1,null,null,{"$f":"IF(ISBLANK(C5),\"\",This_Clubs_Abbrev)","v":""},{"$f":"IF(ISBLANK(C5),\"\",This_Clubs_City)","v":""},null,null,{"$f":"IF(ISBLANK(I5),\"\",I5&IF(Q5=0,\"\",\"  (\"&Q5&\")\"))","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(F5=0,0,MATCH(F5,List_of_BirthYears,0))","v":0},{"$f":"IF(K5=0,0,INDEX(WAG_Fee_Codes,K5))","v":0},"No","No",null,{"$f":"IF(K5+L5=0,0,INDEX(WAG_SubCategories,K5,L5))","v":0}]
[2,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[3,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[4,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[5,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[6,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[7,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[8,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[9,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[10,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[11,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[12,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[13,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[14,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[15,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[16,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[17,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[18,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[19,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[20,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[21,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[22,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[23,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[24,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[25,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[26,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[27,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[28,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[29,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[30,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[31,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[32,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[33,null,null,{"$f":"IF(ISBLANK(C37),\"\",This_Clubs_Abbrev)","v":""},{"$f":"IF(ISBLANK(C37),\"\",This_Clubs_City)","v":""},null,null,{"$f":"IF(ISBLANK(I37),\"\",I37&IF(Q37=0,\"\",\"  (\"&Q37&\")\"))","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(F37=0,0,MATCH(F37,List_of_BirthYears,0))","v":0},{"$f":"IF(K37=0,0,INDEX(WAG_Fee_Codes,K37))","v":0},"No","No",null,{"$f":"IF(K37+L37=0,0,INDEX(WAG_SubCategories,K37,L37))","v":0}]
[34,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[35,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[36,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[37,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[38,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[39,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[40,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[41,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[42,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[43,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[44,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[45,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[46,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[47,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[48,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[49,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[50,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[51,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[52,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[53,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[54,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[55,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[56,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[57,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[58,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[59,null,null,"","",null,null,"",null,0,0,0,0,"No","No",null,0]
[60,null,null,"","",null,null,"",null,0,0,0,0,"No","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":"2018 Can-Am Personal Best"},null,null,null,null,null,null,null,null,null,null,{"$f":"Meet_Dates","v":"April 6-8, 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":"Lampman Leapers Gymnastics Club"},null,null,null,null,null,"Please mark sessions with \"X\" if known."]
[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":23,"rows_kept":64,"cut":false,"hidden":true,"merged":[[2,10,2,11]]}
[null,{"$f":"Meet_Name","v":"2018 Can-Am Personal Best"},null,"CLUB REGISTRATION - MEN"]
[null,{"$f":"Meet_Dates","v":"April 6-8, 2018"},"Club:  ",{"$f":"This_Clubs_FullName","v":"Lampman Leapers Gymnastics Club"}]
[null,null,null,null,null,null,null,null,null,null,"Used to get full cat name (WAG)",null,null,"Cat."]
[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"},"Cat:\nIndex 1","Age:\nIndex 2",null,"Fee Code\nfor level","misc","Comment","YOB & Month","Age in years","Birth Month","Years (YY)","12-M","Months (MM)","Age for sorting"]
[7,null,null,{"$f":"IF(ISBLANK(C5),\"\",This_Clubs_Name)","v":""},{"$f":"IF(ISBLANK(C5),\"\",Summary!$G$13)","v":""},null,null,{"$f":"T(I5)","v":""},null,{"$f":"IF(F5=0,0,Year_of_Meet-F5)","v":0},{"$f":"IF(ISBLANK(I5),\"\",MATCH(I5,MAG_Categories,0))","v":""},{"$f":"IF(R5=0,\"\",MATCH(R5,MAG_Age_Range,0))","v":""},null,"No",null,null,{"$f":"(F5)+ (S5/100)","v":0},{"$f":"IF(F5=0,0,Year_of_Meet-F5)","v":0},{"$f":"IF(G5=\"\",0,MATCH(G5,List_of_Months,0))","v":0},{"$f":"IF(R5<10,\"0\",\"\")&R5","v":"00"},{"$f":"12-S5","v":12},{"$f":"IF(12-U5<10,\"0\",\"\")&(12-U5)","v":"00"},{"$f":"R5+(S5/100)","v":0}]
[1,null,null,"",{"$f":"IF(ISBLANK(C6),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[4,null,null,"",{"$f":"IF(ISBLANK(C7),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[2,null,null,"",{"$f":"IF(ISBLANK(C8),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[6,null,null,"",{"$f":"IF(ISBLANK(C9),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[5,null,null,"",{"$f":"IF(ISBLANK(C10),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[3,null,null,"",{"$f":"IF(ISBLANK(C11),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[8,null,null,"",{"$f":"IF(ISBLANK(C12),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[9,null,null,"",{"$f":"IF(ISBLANK(C13),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[10,null,null,"",{"$f":"IF(ISBLANK(C14),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[11,null,null,"",{"$f":"IF(ISBLANK(C15),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[12,null,null,"",{"$f":"IF(ISBLANK(C16),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[13,null,null,"",{"$f":"IF(ISBLANK(C17),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[14,null,null,"",{"$f":"IF(ISBLANK(C18),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[15,null,null,"",{"$f":"IF(ISBLANK(C19),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[16,null,null,"",{"$f":"IF(ISBLANK(C20),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[17,null,null,"",{"$f":"IF(ISBLANK(C21),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[18,null,null,"",{"$f":"IF(ISBLANK(C22),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[19,null,null,"",{"$f":"IF(ISBLANK(C23),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[20,null,null,"",{"$f":"IF(ISBLANK(C24),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[21,null,null,"",{"$f":"IF(ISBLANK(C25),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[22,null,null,"",{"$f":"IF(ISBLANK(C26),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[23,null,null,"",{"$f":"IF(ISBLANK(C27),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[24,null,null,"",{"$f":"IF(ISBLANK(C28),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[25,null,null,"",{"$f":"IF(ISBLANK(C29),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[26,null,null,"",{"$f":"IF(ISBLANK(C30),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[27,null,null,"",{"$f":"IF(ISBLANK(C31),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[28,null,null,"",{"$f":"IF(ISBLANK(C32),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[29,null,null,"",{"$f":"IF(ISBLANK(C33),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[30,null,null,"",{"$f":"IF(ISBLANK(C34),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[31,null,null,"",{"$f":"IF(ISBLANK(C35),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[32,null,null,"",{"$f":"IF(ISBLANK(C36),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[33,null,null,{"$f":"IF(ISBLANK(C37),\"\",This_Clubs_Name)","v":""},{"$f":"IF(ISBLANK(C37),\"\",Summary!$G$13)","v":""},null,null,{"$f":"T(I37)","v":""},null,{"$f":"IF(F37=0,0,Year_of_Meet-F37)","v":0},{"$f":"IF(ISBLANK(I37),\"\",MATCH(I37,MAG_Categories,0))","v":""},{"$f":"IF(R37=0,\"\",MATCH(R37,MAG_Age_Range,0))","v":""},null,"No",null,null,{"$f":"(F37)+ (S37/100)","v":0},{"$f":"IF(F37=0,0,Year_of_Meet-F37)","v":0},{"$f":"IF(G37=\"\",0,MATCH(G37,List_of_Months,0))","v":0},{"$f":"IF(R37<10,\"0\",\"\")&R37","v":"00"},{"$f":"12-S37","v":12},{"$f":"IF(12-U37<10,\"0\",\"\")&(12-U37)","v":"00"},{"$f":"R37+(S37/100)","v":0}]
[34,null,null,"",{"$f":"IF(ISBLANK(C38),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[35,null,null,"",{"$f":"IF(ISBLANK(C39),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[36,null,null,"",{"$f":"IF(ISBLANK(C40),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[37,null,null,"",{"$f":"IF(ISBLANK(C41),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[38,null,null,"",{"$f":"IF(ISBLANK(C42),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[39,null,null,"",{"$f":"IF(ISBLANK(C43),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[40,null,null,"",{"$f":"IF(ISBLANK(C44),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[41,null,null,"",{"$f":"IF(ISBLANK(C45),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[42,null,null,"",{"$f":"IF(ISBLANK(C46),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[43,null,null,"",{"$f":"IF(ISBLANK(C47),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[44,null,null,"",{"$f":"IF(ISBLANK(C48),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[45,null,null,"",{"$f":"IF(ISBLANK(C49),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[46,null,null,"",{"$f":"IF(ISBLANK(C50),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[47,null,null,"",{"$f":"IF(ISBLANK(C51),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[48,null,null,"",{"$f":"IF(ISBLANK(C52),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[49,null,null,"",{"$f":"IF(ISBLANK(C53),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[50,null,null,"",{"$f":"IF(ISBLANK(C54),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[51,null,null,"",{"$f":"IF(ISBLANK(C55),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[52,null,null,"",{"$f":"IF(ISBLANK(C56),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[53,null,null,"",{"$f":"IF(ISBLANK(C57),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[54,null,null,"",{"$f":"IF(ISBLANK(C58),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[55,null,null,"",{"$f":"IF(ISBLANK(C59),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[56,null,null,"",{"$f":"IF(ISBLANK(C60),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[57,null,null,"",{"$f":"IF(ISBLANK(C61),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[58,null,null,"",{"$f":"IF(ISBLANK(C62),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[59,null,null,"",{"$f":"IF(ISBLANK(C63),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]
[60,null,null,"",{"$f":"IF(ISBLANK(C64),\"\",Summary!$G$13)","v":""},null,null,"",null,0,"","",null,"No",null,null,0,0,0,"00",12,"00",0]

{"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 Can-Am Personal Best"},null,null,null,null,null,null,null,null,null,{"$f":"Meet_Dates","v":"April 6-8, 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":"Lampman Leapers Gymnastics Club"},null,null,null,null,null,"Please mark sessions with \"X\" if known."]
[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:",1,{"$f":"G28+1","v":2},{"$f":"H28+1","v":3},{"$f":"I28+1","v":4},{"$f":"J28+1","v":5},{"$f":"K28+1","v":6},{"$f":"L28+1","v":7}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK($G$7),\"\",\"Fri\")","v":"Fri"},"Sat","Sat","Sat","Sun","Sun","Sun"]
[null,null,"JUDGES","Level",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]

{"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"]