{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Auto Fill - F2A, F2B and F3","Members Data Table","Blank - F2A, F2B and F3","Data"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":5,"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":"Auto Fill - F2A, F2B and F3","index":0,"n_rows":189,"n_cols":43,"rows_kept":189,"cut":false,"hidden":false,"merged":[[31,6,31,13],[33,6,33,7],[33,9,33,12],[38,20,38,26],[82,3,82,15],[82,16,82,17],[84,3,84,15],[84,16,84,17],[90,3,90,15],[90,16,90,17],[76,3,76,15],[76,16,76,17],[77,3,77,15],[77,16,77,17],[78,3,78,15],[78,16,78,17],[35,11,35,17],[35,2,35,6],[35,22,35,34],[35,7,35,10],[35,18,35,21],[52,19,52,34],[54,3,54,15],[54,16,54,17],[94,37,95,37],[141,37,143,37],[37,15,38,18],[37,28,38,29],[37,20,37,26],[37,30,37,33],[38,6,38,14],[37,6,37,14],[91,3,91,15],[91,16,91,17],[92,3,92,15],[92,16,92,17],[93,3,93,15],[93,16,93,17],[46,37,48,37],[110,32,110,34],[107,2,109,34],[46,5,46,30],[37,2,37,5],[48,2,48,31],[58,19,58,34],[82,19,82,34],[49,27,49,28],[49,2,49,26],[117,69,117,71],[118,42,118,44],[118,45,118,47],[118,48,118,50],[118,51,118,53],[118,54,118,56],[38,2,38,5],[99,5,99,25],[100,5,100,25],[101,5,101,25],[104,2,104,4],[104,5,104,7],[104,8,104,12],[104,25,104,31],[104,13,104,24],[56,3,56,15],[51,19,51,26],[65,16,65,17],[66,3,66,15],[66,16,66,17],[67,3,67,15],[67,16,67,17],[75,3,75,15],[75,16,75,17],[117,42,117,44],[117,45,117,47],[117,48,117,50],[117,51,117,53],[117,54,117,56],[117,57,117,59],[117,60,117,62],[117,63,117,65],[117,66,117,68],[113,42,113,72],[114,42,114,72],[115,42,115,72],[116,42,116,72],[83,33,83,34],[84,33,84,34],[10,2,10,4],[10,5,10,7],[10,8,10,12],[10,25,10,31],[10,13,10,24],[15,5,15,20],[12,2,12,34],[13,2,13,4],[13,32,13,34],[13,29,13,31],[13,26,13,28],[14,2,14,4],[13,24,13,25],[13,5,13,23],[14,5,14,23],[16,29,16,31],[16,32,16,34],[17,5,17,23],[104,42,104,72],[105,42,105,72],[106,42,106,72],[107,42,107,72],[108,42,108,72],[109,42,109,72],[110,42,110,72],[111,42,111,72],[112,42,112,72],[21,29,21,31],[21,32,21,34],[14,24,14,25],[14,26,14,28],[14,29,14,31],[14,32,14,34],[15,24,15,25],[15,26,15,28],[15,29,15,31],[15,32,15,34],[18,2,18,34],[15,21,15,23],[17,2,17,4],[17,26,17,28],[17,29,17,31],[17,32,17,34],[15,2,15,4],[16,2,16,4],[16,5,16,20],[16,21,16,23],[16,24,16,25],[16,26,16,28],[17,24,17,25],[24,24,24,25],[24,26,24,28],[24,29,24,31],[24,32,24,34],[25,2,25,4],[25,5,25,23],[25,24,25,25],[25,26,25,28],[25,29,25,31],[25,32,25,34],[24,2,24,4],[24,5,24,23],[23,2,23,34],[19,26,19,28],[19,29,19,31],[19,32,19,34],[20,2,20,4],[20,5,20,23],[20,24,20,25],[20,26,20,28],[20,29,20,31],[20,32,20,34],[22,2,22,4],[22,5,22,23],[22,24,22,25],[22,26,22,28],[22,29,22,31],[22,32,22,34],[19,2,19,4],[19,5,19,23],[19,24,19,25],[21,2,21,4],[21,5,21,20],[21,21,21,23],[21,24,21,25],[21,26,21,28],[26,24,26,25],[32,20,32,29],[33,20,33,29],[30,15,30,19],[31,15,31,19],[32,15,32,19],[33,15,33,19],[30,6,30,14],[28,32,28,34],[28,24,28,31],[28,2,28,23],[30,20,30,29],[31,20,31,29],[26,2,26,4],[27,2,27,4],[26,26,26,28],[26,29,26,31],[26,32,26,34],[27,24,27,25],[27,26,27,28],[27,29,27,31],[27,32,27,34],[26,5,26,20],[26,21,26,23],[55,3,55,15],[55,16,55,17],[79,3,79,15],[79,16,79,17],[80,3,80,15],[80,16,80,17],[81,3,81,15],[116,5,116,23],[116,24,116,25],[58,16,58,17],[59,3,59,15],[59,16,59,17],[60,3,60,15],[60,16,60,17],[64,19,64,34],[76,19,76,34],[72,2,72,17],[61,3,61,15],[61,16,61,17],[62,3,62,15],[62,16,62,17],[63,3,63,15],[63,16,63,17],[64,3,64,15],[116,26,116,28],[116,29,116,31],[110,2,110,4],[110,5,110,23],[110,24,110,25],[110,26,110,28],[110,29,110,31],[134,30,134,33],[117,32,117,34],[117,29,117,31],[122,2,122,4],[122,5,122,23],[122,24,122,25],[122,26,122,28],[122,29,122,31],[122,32,122,34],[121,2,121,4],[121,5,121,23],[121,24,121,25],[121,26,121,28],[121,29,121,31],[121,32,121,34],[117,2,117,4],[117,5,117,23],[117,24,117,25],[117,26,117,28],[127,6,127,14],[127,15,127,19],[128,15,128,19],[129,15,129,19],[134,2,134,5],[134,6,134,14],[134,15,135,18],[134,20,134,26],[134,28,135,29],[132,11,132,17],[132,18,132,21],[132,22,132,34],[127,20,127,28],[128,20,128,28],[9,2,9,34],[103,2,103,34],[3,2,3,30],[4,2,4,30],[96,2,96,30],[97,2,97,30],[11,6,11,19],[11,20,11,26],[11,28,11,30],[10,32,10,34],[41,5,42,20],[43,5,44,20],[40,5,40,30],[45,5,45,30],[51,2,51,17],[52,16,52,17],[52,3,52,15],[53,3,53,15],[53,16,53,17],[27,5,27,23],[56,16,56,17],[57,3,57,15],[57,16,57,17],[58,3,58,15],[64,16,64,17],[65,3,65,15],[89,2,89,17],[88,19,88,34],[123,2,123,23],[123,24,123,31],[123,32,123,34],[118,2,120,34],[113,2,115,34],[116,32,116,34],[112,2,112,4],[112,5,112,20],[112,21,112,23],[112,24,112,25],[112,26,112,28],[112,29,112,31],[112,32,112,34],[111,2,111,4],[111,5,111,23],[111,24,111,25],[111,26,111,28],[111,29,111,31],[111,32,111,34],[116,2,116,4],[68,33,68,34],[69,20,69,32],[69,33,69,34],[147,19,147,34],[178,2,178,17],[146,19,146,26],[159,19,159,34],[153,19,153,34],[171,19,171,34],[167,2,167,17],[104,32,104,34],[105,6,105,19],[105,20,105,26],[105,28,105,30],[177,19,177,34],[165,19,165,34],[147,3,147,15],[147,16,147,17],[148,3,148,15],[148,16,148,17],[148,20,148,32],[148,33,148,34],[149,3,149,15],[149,16,149,17],[70,3,70,15],[70,16,70,17],[71,3,71,15],[70,19,70,34],[85,3,85,15],[85,16,85,17],[80,20,80,32],[80,33,80,34],[81,20,81,32],[81,33,81,34],[77,20,77,32],[71,16,71,17],[73,3,73,15],[73,16,73,17],[71,33,71,34],[72,20,72,32],[72,33,72,34],[73,20,73,32],[73,33,73,34],[74,20,74,32],[74,33,74,34],[75,20,75,32],[74,3,74,15],[81,16,81,17],[53,33,53,34],[54,20,54,32],[54,33,54,34],[55,20,55,32],[55,33,55,34],[56,20,56,32],[56,33,56,34],[57,20,57,32],[57,33,57,34],[53,20,53,32],[67,20,67,32],[67,33,67,34],[68,20,68,32],[86,3,86,15],[86,16,86,17],[87,3,87,15],[87,16,87,17],[83,2,83,17],[88,3,88,15],[88,16,88,17],[75,33,75,34],[71,20,71,32],[77,33,77,34],[78,20,78,32],[78,33,78,34],[79,20,79,32],[79,33,79,34],[74,16,74,17],[84,20,84,32],[85,20,85,32],[68,3,68,15],[68,16,68,17],[69,3,69,15],[69,16,69,17],[61,33,61,34],[62,20,62,32],[62,33,62,34],[63,20,63,32],[63,33,63,34],[59,20,59,32],[65,33,65,34],[66,20,66,32],[66,33,66,34],[151,3,151,15],[151,16,151,17],[151,20,151,32],[151,33,151,34],[152,3,152,15],[152,16,152,17],[152,20,152,32],[152,33,152,34],[93,33,93,34],[150,16,150,17],[150,20,150,32],[150,33,150,34],[149,20,149,32],[149,33,149,34],[150,3,150,15],[143,2,143,31],[144,2,144,26],[144,27,144,28],[146,2,146,17],[129,20,129,28],[130,20,130,28],[130,15,130,19],[132,2,132,6],[132,7,132,10],[153,3,153,15],[153,16,153,17],[154,3,154,15],[154,16,154,17],[154,20,154,32],[154,33,154,34],[155,3,155,15],[155,16,155,17],[155,20,155,32],[155,33,155,34],[156,3,156,15],[156,16,156,17],[156,20,156,32],[156,33,156,34],[157,3,157,15],[157,16,157,17],[157,20,157,32],[157,33,157,34],[158,3,158,15],[158,16,158,17],[158,20,158,32],[158,33,158,34],[159,3,159,15],[159,16,159,17],[160,3,160,15],[160,16,160,17],[160,20,160,32],[160,33,160,34],[161,3,161,15],[161,16,161,17],[161,20,161,32],[161,33,161,34],[162,3,162,15],[162,16,162,17],[162,20,162,32],[162,33,162,34],[163,3,163,15],[163,16,163,17],[163,20,163,32],[163,33,163,34],[164,3,164,15],[164,16,164,17],[164,20,164,32],[164,33,164,34],[165,3,165,15],[165,16,165,17],[166,3,166,15],[166,16,166,17],[166,20,166,32],[166,33,166,34],[167,20,167,32],[167,33,167,34],[168,3,168,15],[168,16,168,17],[168,20,168,32],[168,33,168,34],[169,3,169,15],[169,16,169,17],[169,20,169,32],[169,33,169,34],[170,3,170,15],[170,16,170,17],[170,20,170,32],[170,33,170,34],[171,3,171,15],[171,16,171,17],[172,3,172,15],[172,16,172,17],[172,20,172,32],[172,33,172,34],[173,3,173,15],[173,16,173,17],[173,20,173,32],[173,33,173,34],[174,3,174,15],[174,16,174,17],[174,20,174,32],[174,33,174,34],[175,3,175,15],[175,16,175,17],[175,20,175,32],[175,33,175,34],[176,3,176,15],[176,16,176,17],[176,20,176,32],[176,33,176,34],[177,3,177,15],[177,16,177,17],[178,20,178,32],[178,33,178,34],[179,3,179,15],[179,16,179,17],[179,20,179,32],[179,33,179,34],[180,3,180,15],[180,16,180,17],[180,20,180,32],[180,33,180,34],[181,3,181,15],[181,16,181,17],[181,20,181,32],[181,33,181,34],[182,3,182,15],[182,16,182,17],[182,20,182,32],[182,33,182,34],[183,3,183,15],[183,16,183,17],[183,19,183,34],[187,3,187,15],[187,16,187,17],[187,20,187,32],[187,33,187,34],[188,3,188,15],[188,16,188,17],[188,20,188,32],[188,33,188,34],[184,20,184,32],[184,33,184,34],[185,3,185,15],[185,16,185,17],[185,20,185,32],[185,33,185,34],[186,3,186,15],[186,16,186,17],[186,20,186,32],[186,33,186,34],[184,2,184,17],[8,32,8,34],[135,2,135,5],[135,6,135,14],[135,20,135,26],[89,33,89,34],[90,20,90,32],[90,33,90,34],[91,20,91,32],[91,33,91,34],[92,20,92,32],[92,33,92,34],[93,20,93,32],[65,20,65,32],[85,33,85,34],[86,20,86,32],[86,33,86,34],[87,20,87,32],[87,33,87,34],[83,20,83,32],[89,20,89,32],[59,33,59,34],[60,20,60,32],[60,33,60,34],[61,20,61,32],[118,57,118,59],[118,60,118,62],[118,63,118,65],[118,66,118,68],[118,69,118,71],[119,42,119,44],[119,45,119,47],[119,48,119,50],[119,51,119,53],[119,54,119,56],[119,57,119,59],[119,60,119,62],[119,63,119,65],[119,66,119,68],[119,69,119,71],[120,69,120,71],[120,42,120,44],[120,45,120,47],[120,48,120,50],[120,51,120,53],[120,54,120,56],[120,57,120,59],[120,60,120,62],[120,63,120,65],[120,66,120,68]]}
[]
[]
[]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,"Form 2A (To National Council)"]
[null,null,"Forward to "]
[null,null,"National Membership Registrar NAA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Preferred Method "]
[null,null,"PO Box 5119",null,null,null,null,null,null,null,null,null,null,null,null,null,"Email Address"]
[null,null,"Victoria Point QLD 4165",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nationalmembershipregistrar@navalassoc.org.au",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2022-02-01T12:06:41.200"}]
[null,null,"PAYMENT OF MEMBERS’ SUBSCRIPTIONS TO NATIONAL COUNCIL"]
[null,null,"Section",null,null,{"$f":"INDEX(Data!$G$3:$I$80,MATCH(N11,Data!$I$3:$I$80,0),1)","v":"??"},null,null,"Sub-Section",null,null,null,null,"<Pick a Sub-section>",null,null,null,null,null,null,null,null,null,null,null,"Sub-section Code",null,null,null,null,null,null,{"$f":"INDEX(Data!$G$3:$I$80,MATCH(N11,Data!$I$3:$I$80,0),2)","v":"??"}]
[null,null,null,null,null,null,"Sub-section Report for the Month of",null,null,null,null,null,null,null,null,null,null,null,null,null,"<Select Month>",null,null,null,null,null,null,null,"<Year?>"]
[null,null,"A.     Members renewing membership (Only yellow fields are editable, Enter membership data into Form 3)"]
[null,null,{"$f":"Data!O13","v":0},null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17,null,null,{"$f":"IF(ISERROR(AA14*C14),0,AA14*C14)","v":0}]
[null,null,{"$f":"Data!N43","v":""},null,null,"Full Member Couples ($17) + Individual Partners ($8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,"$25 / $8",null,null,{"$f":"Data!O40","v":0}]
[null,null,{"$f":"Data!O150","v":0},null,null,"Overseas Members plus additional WEM Postage (below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17,null,null,{"$f":"IF(ISERROR(C16*AA16+V16),0,C16*AA16+V16)","v":0}]
[null,null,{"$f":"Data!N77","v":0},null,null,"Members in arrears - payments per year from 2012 onwards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!O80","v":""},null,null,"@",null,17,null,null,{"$f":"Data!O78*AA17","v":0}]
[null,null,{"$f":"Data!O136","v":0},null,null,"Restricted Members to receive White Ensign Magazine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,7,null,null,{"$f":"IF(ISERROR(AA18*C18),0,AA18*C18)","v":0},null,null,{"$f":"SUM(AD14:AF18)","v":0}]
[null,null,"B.    New members joining between 1 November and 30 June the following year (N)"]
[null,null,{"$f":"Data!O88","v":0},null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17,null,null,{"$f":"AA20*C20","v":0}]
[null,null,{"$f":"Data!O100","v":0},null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,25,null,null,{"$f":"AA21*C21","v":0}]
[null,null,{"$f":"Data!O151","v":0},null,null,"Overseas Members plus additional WEM Postage (below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17,null,null,{"$f":"C22*AA22+V22","v":0}]
[null,null,{"$f":"Data!O137","v":0},null,null,"Restricted Members to receive White Ensign Magazine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,7,null,null,{"$f":"AA23*C23","v":0},null,null,{"$f":"SUM(AD20:AF23)","v":0},476]
[null,null,"C.     New members joining between 1 July and 31 October (D)"]
[null,null,{"$f":"Data!O89","v":0},null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,8.5,null,null,{"$f":"AA25*C25","v":0}]
[null,null,{"$f":"Data!O101","v":0},null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,12.5,null,null,{"$f":"AA26*C26","v":0}]
[null,null,{"$f":"Data!O152","v":0},null,null,"Overseas Members plus additional WEM Postage (below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,8.5,null,null,{"$f":"C27*AA27+V27","v":0}]
[null,null,{"$f":"Data!O138","v":0},null,null,"Restricted Members to receive White Ensign Magazine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,3.5,null,null,{"$f":"AA28*C28","v":0},null,null,{"$f":"SUM(AD25:AF28)","v":0},476]
[null,null,"The preferred method of payment is a direct deposit into the National Account.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fees Payable",null,null,null,null,null,null,null,{"$f":"SUM(AG28,AG23,AG18)","v":0}]
[]
[null,null,null,null,null,null,"National Account Details:",null,null,null,null,null,null,null,null,"Bank:",null,null,null,null,"Bendigo Bank"]
[null,null,null,null,null,null,"o  Fees Deposited.",null,null,null,null,null,null,null,null,"Name:",null,null,null,null,"Naval Association of Australia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSB:",null,null,null,null,"633 000"]
[null,null,null,null,null,null,"Date:",null,null,"2021-11-01",null,null,null,null,null,"Account #:",null,null,null,null,"186 274 296"]
[]
[null,null,"OR Cheque #",null,null,null,null,null,null,null,null,"Bank Deposit Date:",null,null,null,null,null,null,"2021-12-12",null,null,null,"o  Copy of original bank receipt attached."]
[]
[null,null,"Name:",null,null,null,"Jill Surname",null,null,null,null,null,null,null,null,"Signature:",null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,"2022-01-01"]
[null,null,"Position:",null,null,null,"Membership Registrar (Acting)"]
[]
[null,null,null,null,null,"Overseas Members Additional WEM Postage 2018* (Not applicable for email delivery)"]
[null,null,null,null,null,"Members with postal address in Asia-Pacific Area ADD  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$14.40 for members at Sections A and B."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$7.20 for members at Section C."]
[null,null,null,null,null,"Members with postal address in the Rest of the World ADD ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$22.60 for members at Sections A and B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$11.30 for members at part C."]
[null,null,null,null,null,"These additional charges are to be added to the National Capitation only for affected members."]
[null,null,null,null,null,"*Australia Post Letter Rate >50-250 g  15 November 2014 – Checked Dec 2021.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<"]
[]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,{"$f":"\"Form 3 - \"&N11&\" (\"&AG11&\") - \"&\"Report for \"&U12&\", \"&AC12","v":"Form 3 - <Pick a Sub-section> (??) - Report for <Select Month>, <Year?>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,null,"of",{"$f":"(IF(AND(AD50=\"\",AD145=\"\"),\"\",IF(AD145=\"\",AD50,AD145)))","v":""}]
[]
[null,null,{"$f":"Data!V6","v":"Renewing Members"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Report Printed - \"&TEXT(NOW(),\"mmmm, dd, yyyy\")","v":"Report Printed - February, 01, 2022"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Multiple pages if required"]
[null,null,{"$f":"IF(D53=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V76","v":"Members in Arrears"}]
[null,null,{"$f":"IF(D54=\"\",\"\",C53+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U54=\"\",\"\",1)","v":""}]
[null,null,{"$f":"IF(D55=\"\",\"\",C54+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U55=\"\",\"\",T54+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U56=\"\",\"\",T55+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V88","v":"New Members"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U60=\"\",\"\",1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U61=\"\",\"\",T60+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U62=\"\",\"\",T61+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U64=\"\",\"\",T63+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V100","v":"New Member Couples"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U66=\"\",\"\",1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U67=\"\",\"\",T66+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U68=\"\",\"\",T67+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V112","v":"Resignations Received"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U72=\"\",\"\",1)","v":""}]
[null,null,{"$f":"Data!V34","v":"Full Member Couples"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U73=\"\",\"\",T72+1)","v":""}]
[null,null,{"$f":"IF(D74=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U74=\"\",\"\",T73+1)","v":""}]
[null,null,{"$f":"IF(D75=\"\",\"\",C74+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(D76=\"\",\"\",C75+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V125","v":"Financial Members Transferred"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U78=\"\",\"\",1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U79=\"\",\"\",T78+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U80=\"\",\"\",T79+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(D83=\"\",\"\",C82+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V136","v":"Restricted Members WEM"}]
[null,null,{"$f":"Data!V52","v":"Life Members"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U84=\"\",\"\",1)","v":""}]
[null,null,{"$f":"IF(D85=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U85=\"\",\"\",T84+1)","v":""}]
[null,null,{"$f":"IF(D86=\"\",\"\",C85+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U86=\"\",\"\",T85+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U87=\"\",\"\",T86+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U88=\"\",\"\",T87+1)","v":""}]
[null,null,{"$f":"IF(D89=\"\",\"\",C88+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!V150","v":"Overseas Members"}]
[null,null,{"$f":"Data!V64","v":"Deaths Reported"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U90=\"\",\"\",1)","v":""}]
[null,null,{"$f":"IF(D91=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U91=\"\",\"\",T90+1)","v":""}]
[null,null,{"$f":"IF(D92=\"\",\"\",C91+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U92=\"\",\"\",T91+1)","v":""}]
[null,null,{"$f":"IF(D93=\"\",\"\",C92+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(D94=\"\",\"\",C93+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<"]
[]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,"Form 2B (To State Council)"]
[null,null,"Forward to "]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Suburb:"]
[]
[null,null,"PAYMENT OF MEMBERS’ SUBSCRIPTIONS TO SECTION COUNCIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unprotected data area. - Free Notes or Calculations"]
[null,null,"Section",null,null,{"$f":"F11","v":"??"},null,null,"Sub-Section",null,null,null,null,{"$f":"N11","v":"<Pick a Sub-section>"},null,null,null,null,null,null,null,null,null,null,null,"Sub-section Code",null,null,null,null,null,null,{"$f":"AG11","v":"??"}]
[null,null,null,null,null,null,"Sub-section Report for the Month of",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U12","v":"<Select Month>"},null,null,null,null,null,null,null,2022]
[]
[null,null,"A.     Members renewing membership"]
[]
[]
[null,null,{"$f":"C14","v":0},null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,10,null,null,{"$f":"AA111*C111","v":0}]
[null,null,{"$f":"Data!N43","v":""},null,null,"Full Member Couples ($15) + Single Partners ($5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,"$15 / $5",null,null,{"$f":"Data!O41","v":0}]
[null,null,{"$f":"C17","v":0},null,null,"Members in arrears - payments per year from 2012 onwards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V17","v":""},null,null,"@",null,10,null,null,{"$f":"IF(C113=\"Error\",0,Data!O78*AA113)","v":0},null,null,{"$f":"SUM(AD111:AF113)","v":0}]
[null,null,"B.    New members joining between 1 November and 30 June the following year"]
[]
[]
[null,null,{"$f":"C20","v":0},null,null,"Full Members ($10 + $5 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,15,null,null,{"$f":"AA117*C117","v":0}]
[null,null,{"$f":"C21","v":0},null,null,"Full Member Couples ($15 + $10 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,25,null,null,0,null,null,{"$f":"SUM(AD117:AF118)","v":0}]
[null,null,"C.     New members joining between 1 July and 31 October"]
[]
[]
[null,null,{"$f":"C25","v":0},null,null,"Full Members ($5 + $5 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,10,null,null,{"$f":"AA122*C122","v":0}]
[null,null,{"$f":"C26","v":0},null,null,"Full Member Couples ($7.50 + $10 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17.5,null,null,0,null,null,{"$f":"SUM(AD122:AF123)","v":0}]
[null,null,"The preferred method of payment is a direct deposit into the Section Account.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fees Payable",null,null,null,null,null,null,null,{"$f":"SUM(AG113,AG118,AG123)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"Section Account Details:",null,null,null,null,null,null,null,null,"Bank:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSB:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:"]
[]
[null,null,"OR Cheque #",null,null,null,null,null,null,null,null,"Bank Deposit Date:",null,null,null,null,null,null,null,null,null,null,"o  Copy of original bank receipt attached."]
[]
[null,null,"Name:",null,null,null,{"$f":"G38","v":"Jill Surname"},null,null,null,null,null,null,null,null,"Signature:",null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"AE38","v":"2022-01-01"}]
[null,null,"Position:",null,null,null,{"$f":"G39","v":"Membership Registrar (Acting)"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 3.31 Jan 2022"]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,{"$f":"\"Form 3 - \"&N11&\" (\"&AG11&\") - \"&\"Report for \"&U12&\", \"&AC12","v":"Form 3 - <Pick a Sub-section> (??) - Report for <Select Month>, <Year?>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,null,"of",{"$f":"IF(AD145=\"\",\"\",2)","v":""}]
[]
[null,null,{"$f":"Data!AD6","v":"Renewing Members"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Report Printed - \"&TEXT(NOW(),\"mmmm, dd, yyyy\")","v":"Report Printed - February, 01, 2022"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Multiple pages if required"]
[null,null,{"$f":"IF(D148=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD76","v":"Members in Arrears"}]
[null,null,{"$f":"IF(D149=\"\",\"\",C148+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U149=\"\",\"\",1)","v":""}]
[null,null,{"$f":"IF(D150=\"\",\"\",C149+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U150=\"\",\"\",T149+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U151=\"\",\"\",T150+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD88","v":"New Members"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U155=\"\",\"\",1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U156=\"\",\"\",T155+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U157=\"\",\"\",T156+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD100","v":"New Member Couples"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U161=\"\",\"\",1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U162=\"\",\"\",T161+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U163=\"\",\"\",T162+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD112","v":"Resignations Received"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U167=\"\",\"\",1)","v":""}]
[null,null,{"$f":"Data!AD34","v":"Full Member Couples"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U168=\"\",\"\",T167+1)","v":""}]
[null,null,{"$f":"IF(D169=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U169=\"\",\"\",T168+1)","v":""}]
[null,null,{"$f":"IF(D170=\"\",\"\",C169+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(D171=\"\",\"\",C170+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD125","v":"Financial Members Transferred"}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U173=\"\",\"\",1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U174=\"\",\"\",T173+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U175=\"\",\"\",T174+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD136","v":"Restricted Members WEM"}]
[null,null,{"$f":"Data!AD52","v":"Life Members"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U179=\"\",\"\",1)","v":""}]
[null,null,{"$f":"IF(D180=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U180=\"\",\"\",T179+1)","v":""}]
[null,null,{"$f":"IF(D181=\"\",\"\",C180+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U181=\"\",\"\",T180+1)","v":""}]
[null,null,{"$f":"IF(D182=\"\",\"\",C181+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U182=\"\",\"\",T181+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!AD150","v":"Overseas Members"}]
[null,null,{"$f":"Data!AD64","v":"Deaths Reported"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U185=\"\",\"\",1)","v":""}]
[null,null,{"$f":"IF(D186=\"\",\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U186=\"\",\"\",T185+1)","v":""}]
[null,null,{"$f":"IF(D187=\"\",\"\",C186+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U187=\"\",\"\",T186+1)","v":""}]
[null,null,{"$f":"IF(D188=\"\",\"\",C187+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(D189=\"\",\"\",C188+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Members Data Table","index":1,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,"Validated Data - Members Names Table",null,"Validated Data - Signature Position",{"$f":"'Auto Fill - F2A, F2B and F3'!AG11","v":"??"},"Surname","Given Names","Membership Type","Date"]
[null,"Formated data",null,null,"<<<<<<<","Enter members data in this table",null,null,"2021-01-01",null,"Summary Check"]
[null,{"$f":"IF(F3=\"\",\"\",UPPER(F3)&\",  \"&PROPER(G3)&\" - \"&PROPER(H3))","v":"SURNAME,  Paul - Full"},null,{"$f":"PROPER(G3)&\" \"&PROPER(F3)","v":"Paul Surname"},1,"Surname","paul","Full",null,null,{"$f":"COUNTIF($H$3:$H$100,L3)","v":1},"Full"]
[null,{"$f":"IF(F4=\"\",\"\",UPPER(F4)&\",  \"&PROPER(G4)&\" - \"&PROPER(H4))","v":"SURNAME,  B - Partner"},null,{"$f":"PROPER(G4)&\" \"&PROPER(F4)","v":"B Surname"},{"$f":"IF(ISERROR(IF(F4<>\"\",E3+1,\"\")),ROW(),IF(F4<>\"\",E3+1,\"\"))","v":2},"surname","b","Partner",null,null,1,"Partner"]
[null,"SURNAME,  C - Club",null,"C Surname",{"$f":"IF(ISERROR(IF(F5<>\"\",E4+1,\"\")),ROW(),IF(F5<>\"\",E4+1,\"\"))","v":3},"SURNAME","c","Club",null,null,1,"Club"]
[null,"SURNAME,  D - Social",null,"D Surname",4,"SURNAME","d","Social",null,null,1,"Social"]
[null,"SURNAME,  E - Associate",null,"E Surname",5,"SURNAME","e","Associate",null,null,1,"Associate"]
[null,"SURNAME,  X - Crossed The Bar",null,"X Surname",6,"Surname","X","Crossed the Bar","2021-12-11",null,{"$f":"COUNTIF($H$3:$H$100,L8)","v":1},"Honourary"]
[null,"SURNAME,  G - Honourary",null,"G Surname",7,"SURNAME","g","Honourary",null,null,{"$f":"COUNTIF($H$3:$H$100,L9)","v":1},"Life Member"]
[null,"SURNAME,  Helen Lf - Life Member",null,"Helen Lf Surname",8,"SURNAME","Helen Lf","Life Member",null,null,{"$f":"COUNTIF($H$3:$H$100,L10)","v":1},"Life Subscriber"]
[null,"SURNAME,  I - Life Subscriber",null,"I Surname",9,"SURNAME","i","Life Subscriber",null,null,{"$f":"COUNTIF($H$3:$H$100,L11)","v":1},"Crossed the Bar"]
[null,"",null," ","",null,null,null,null,null,{"$f":"SUM(K3:K11)","v":9},"Check Count"]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null,{"$f":"PROPER(G30)&\" \"&PROPER(F30)","v":" "},""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,{"$f":"IF(F68=\"\",\"\",UPPER(F68)&\",  \"&PROPER(G68)&\" - \"&PROPER(H68))","v":""},null," ",""]
[null,"",null," ",{"$f":"IF(ISERROR(IF(F69<>\"\",E68+1,\"\")),ROW(),IF(F69<>\"\",E68+1,\"\"))","v":""}]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null,{"$f":"PROPER(G94)&\" \"&PROPER(F94)","v":" "},""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null," ",""]
[null,"",null,{"$f":"PROPER(G100)&\" \"&PROPER(F100)","v":" "},""]

{"sheet":"Blank - F2A, F2B and F3","index":2,"n_rows":137,"n_cols":38,"rows_kept":137,"cut":false,"hidden":false,"merged":[[46,37,47,37],[93,37,94,37],[136,37,137,37],[128,2,128,6],[128,7,128,10],[128,11,128,17],[128,18,128,21],[128,22,128,34],[130,4,130,7],[130,9,130,17],[130,18,130,21],[130,22,130,31],[124,15,124,19],[124,20,124,28],[125,15,125,19],[125,20,125,28],[126,15,126,19],[126,20,126,28],[121,2,121,23],[121,24,121,31],[121,32,121,34],[123,6,123,14],[123,15,123,19],[123,20,123,28],[120,2,120,4],[120,5,120,23],[120,24,120,25],[120,26,120,28],[120,29,120,31],[120,32,120,34],[116,2,118,34],[119,2,119,4],[119,5,119,23],[119,24,119,25],[119,26,119,28],[119,29,119,31],[119,32,119,34],[115,2,115,4],[115,5,115,23],[115,24,115,25],[115,26,115,28],[115,29,115,31],[115,32,115,34],[110,32,110,34],[111,2,113,34],[114,2,114,4],[114,5,114,23],[114,24,114,25],[114,26,114,28],[114,29,114,31],[114,32,114,34],[110,2,110,4],[110,5,110,20],[110,21,110,23],[110,24,110,25],[110,26,110,28],[110,29,110,31],[109,2,109,4],[109,5,109,23],[109,24,109,25],[109,26,109,28],[109,29,109,31],[109,32,109,34],[103,6,103,19],[103,20,103,26],[103,28,103,30],[105,2,107,34],[108,2,108,4],[108,5,108,23],[108,24,108,25],[108,26,108,28],[108,29,108,31],[108,32,108,34],[90,20,90,32],[90,33,90,34],[89,3,89,15],[89,16,89,17],[101,2,101,34],[102,2,102,6],[102,7,102,9],[102,10,102,15],[102,16,102,23],[102,24,102,31],[102,32,102,34],[95,2,95,30],[96,2,96,30],[91,20,91,32],[91,33,91,34],[92,20,92,32],[92,33,92,34],[90,3,90,15],[90,16,90,17],[91,3,91,15],[91,16,91,17],[92,3,92,15],[92,16,92,17],[87,19,87,34],[85,20,85,32],[85,33,85,34],[86,20,86,32],[86,33,86,34],[88,20,88,32],[88,33,88,34],[89,20,89,32],[89,33,89,34],[76,3,76,15],[76,16,76,17],[82,2,82,17],[81,19,81,34],[82,20,82,32],[82,33,82,34],[83,20,83,32],[83,33,83,34],[84,20,84,32],[84,33,84,34],[79,3,79,15],[79,16,79,17],[80,3,80,15],[80,16,80,17],[81,3,81,15],[81,16,81,17],[79,20,79,32],[79,33,79,34],[80,20,80,32],[80,33,80,34],[83,3,83,15],[83,16,83,17],[84,3,84,15],[84,16,84,17],[72,33,72,34],[72,3,72,15],[72,16,72,17],[75,19,75,34],[73,20,73,32],[73,33,73,34],[74,20,74,32],[74,33,74,34],[73,3,73,15],[73,16,73,17],[74,3,74,15],[74,16,74,17],[75,3,75,15],[75,16,75,17],[64,3,64,15],[64,16,64,17],[65,3,65,15],[65,16,65,17],[66,3,66,15],[66,16,66,17],[71,2,71,17],[69,19,69,34],[67,3,67,15],[67,16,67,17],[68,3,68,15],[68,16,68,17],[69,3,69,15],[69,16,69,17],[70,3,70,15],[70,16,70,17],[64,20,64,32],[64,33,64,34],[65,20,65,32],[65,33,65,34],[66,20,66,32],[66,33,66,34],[67,20,67,32],[67,33,67,34],[58,3,58,15],[58,16,58,17],[59,3,59,15],[59,16,59,17],[60,3,60,15],[60,16,60,17],[63,19,63,34],[61,3,61,15],[61,16,61,17],[62,3,62,15],[62,16,62,17],[63,3,63,15],[63,16,63,17],[58,20,58,32],[58,33,58,34],[59,20,59,32],[59,33,59,34],[60,20,60,32],[60,33,60,34],[61,20,61,32],[61,33,61,34],[62,20,62,32],[62,33,62,34],[53,3,53,15],[53,16,53,17],[54,3,54,15],[54,16,54,17],[52,20,52,32],[52,33,52,34],[53,20,53,32],[53,33,53,34],[57,19,57,34],[55,3,55,15],[55,16,55,17],[56,3,56,15],[56,16,56,17],[57,3,57,15],[57,16,57,17],[54,20,54,32],[54,33,54,34],[55,20,55,32],[55,33,55,34],[56,20,56,32],[56,33,56,34],[48,2,48,26],[48,27,48,28],[50,2,50,17],[50,19,50,26],[51,19,51,34],[51,3,51,15],[51,16,51,17],[52,3,52,15],[52,16,52,17],[40,5,40,30],[41,5,42,20],[43,5,44,20],[45,5,45,30],[46,5,46,30],[47,2,47,31],[35,2,35,6],[35,7,35,10],[35,11,35,17],[35,18,35,21],[35,22,35,34],[37,4,37,7],[37,9,37,17],[37,18,37,21],[37,22,37,31],[31,15,31,19],[31,20,31,29],[32,15,32,19],[32,20,32,29],[33,15,33,19],[33,20,33,29],[28,2,28,23],[28,24,28,31],[28,32,28,34],[30,6,30,14],[30,15,30,19],[30,20,30,29],[26,32,26,34],[27,2,27,4],[27,5,27,23],[27,24,27,25],[27,26,27,28],[27,29,27,31],[27,32,27,34],[26,2,26,4],[26,5,26,20],[26,21,26,23],[26,24,26,25],[26,26,26,28],[26,29,26,31],[25,2,25,4],[25,5,25,23],[25,24,25,25],[25,26,25,28],[25,29,25,31],[25,32,25,34],[23,2,23,34],[24,2,24,4],[24,5,24,23],[24,24,24,25],[24,26,24,28],[24,29,24,31],[24,32,24,34],[21,32,21,34],[22,2,22,4],[22,5,22,23],[22,24,22,25],[22,26,22,28],[22,29,22,31],[22,32,22,34],[21,2,21,4],[21,5,21,20],[21,21,21,23],[21,24,21,25],[21,26,21,28],[21,29,21,31],[20,2,20,4],[20,5,20,23],[20,24,20,25],[20,26,20,28],[20,29,20,31],[20,32,20,34],[18,2,18,34],[19,2,19,4],[19,5,19,23],[19,24,19,25],[19,26,19,28],[19,29,19,31],[19,32,19,34],[17,2,17,4],[17,5,17,23],[17,24,17,25],[17,26,17,28],[17,29,17,31],[17,32,17,34],[15,32,15,34],[16,2,16,4],[16,5,16,20],[16,21,16,23],[16,24,16,25],[16,26,16,28],[16,29,16,31],[16,32,16,34],[15,2,15,4],[15,5,15,20],[15,21,15,23],[15,24,15,25],[15,26,15,28],[15,29,15,31],[14,2,14,4],[14,5,14,23],[14,24,14,25],[14,26,14,28],[14,29,14,31],[14,32,14,34],[11,6,11,19],[11,20,11,26],[11,28,11,30],[12,2,12,34],[13,2,13,4],[13,5,13,23],[13,24,13,25],[13,26,13,28],[13,29,13,31],[13,32,13,34],[3,2,3,30],[4,2,4,30],[9,2,9,34],[10,2,10,6],[10,7,10,9],[10,10,10,15],[10,16,10,23],[10,24,10,31],[10,32,10,34],[85,3,85,15],[85,16,85,17],[86,3,86,15],[86,16,86,17],[87,3,87,15],[87,16,87,17],[88,2,88,17],[68,20,68,32],[68,33,68,34],[70,20,70,32],[70,33,70,34],[71,20,71,32],[71,33,71,34],[77,3,77,15],[77,16,77,17],[78,3,78,15],[78,16,78,17],[76,20,76,32],[76,33,76,34],[77,20,77,32],[77,33,77,34],[78,20,78,32],[78,33,78,34],[72,20,72,32]]}
[]
[]
[]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,"Form 2A (To National Council)"]
[null,null,"Forward to "]
[null,null,"National Membership Registrar NAA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Preferred Method "]
[null,null,"PO Box 5119",null,null,null,null,null,null,null,null,null,null,null,null,null,"Email Address"]
[null,null,"Victoria Point QLD 4165",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nationalmembershipregistrar@navalassoc.org.au"]
[null,null,"PAYMENT OF MEMBERS’ SUBSCRIPTIONS TO NATIONAL COUNCIL"]
[null,null,"Section",null,null,null,null,null,null,null,"Sub-Section",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-section Code"]
[null,null,null,null,null,null,"Sub-section Report for the Month of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022]
[null,null,"A.     Members renewing membership"]
[null,null,null,null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17]
[null,null,null,null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,25]
[null,null,null,null,null,"Overseas Members plus additional WEM Postage (below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17]
[null,null,null,null,null,"Members in arrears - payments per year from 2012 onwards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17]
[null,null,null,null,null,"Restricted Members to receive White Ensign Magazine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,7]
[null,null,"B.    New members joining between 1 November and 30 June"]
[null,null,null,null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17]
[null,null,null,null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,25]
[null,null,null,null,null,"Overseas Members plus additional WEM Postage (below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17]
[null,null,null,null,null,"Restricted Members to receive White Ensign Magazine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,7]
[null,null,"C.     New members joining between 1 July and 31 October"]
[null,null,null,null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,8.5]
[null,null,null,null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,12.5]
[null,null,null,null,null,"Overseas Members plus additional WEM Postage (below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,8.5]
[null,null,null,null,null,"Restricted Members to receive White Ensign Magazine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,3.5]
[null,null,"The preferred method of payment is a direct deposit into the National Account.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fees Payable"]
[]
[null,null,null,null,null,null,"National Account Details:",null,null,null,null,null,null,null,null,"Bank:",null,null,null,null,"Bendigo Bank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:",null,null,null,null,"Naval Association of Australia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSB:",null,null,null,null,"633 000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:",null,null,null,null,"186 274 296"]
[]
[null,null,"OR Cheque #",null,null,null,null,null,null,null,null,"Bank Deposit Date:",null,null,null,null,null,null,null,null,null,null,"o  Copy of original bank receipt attached."]
[]
[null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[]
[]
[null,null,null,null,null,"Overseas Members Additional WEM Postage 2018* (Not applicable for email delivery)"]
[null,null,null,null,null,"Members with postal address in Asia-Pacific Area ADD  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$14.40 for members at Sections A and B."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$7.20 for members at Section C."]
[null,null,null,null,null,"Members with postal address in the Rest of the World ADD ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$22.60 for members at Sections A and B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$11.30 for members at part C."]
[null,null,null,null,null,"These additional charges are to be added to the National Capitation only for affected members."]
[null,null,null,null,null,"*Australia Post Letter Rate >50-250 g  15 November 2014 – Checked Dec 2021.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<"]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,"Form 3 - EAST GIPPSLAND (V70) - Report for DECEMBER, 2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,null,"of"]
[]
[null,null,"Renewing Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Multiple pages if required"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Members in Arrears"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Members"]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Full Member Couples"]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resignations Received"]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financial Members Transferred"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Restricted Members for WEM"]
[null,null,"Life Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overseas Members"]
[null,null,"Deaths Reported",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<"]
[]
[null,null,"NAVAL  ASSOCIATION  OF  AUSTRALIA"]
[null,null,"Form 2B (To State Council)"]
[null,null,"Forward to "]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Suburb:"]
[null,null,"PAYMENT OF MEMBERS’ SUBSCRIPTIONS TO SECTION COUNCIL"]
[null,null,"Section",null,null,null,null,null,null,null,"Sub-Section",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-section Code"]
[null,null,null,null,null,null,"Sub-section Report for the Month of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022]
[]
[null,null,"A.     Members renewing membership"]
[]
[]
[null,null,null,null,null,"Full Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,10]
[null,null,null,null,null,"Full Member Couples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,15]
[null,null,null,null,null,"Members in arrears - payments per year from 2012 onwards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,10]
[null,null,"B.    New members joining between 1 November and 30 June"]
[]
[]
[null,null,null,null,null,"Full Members ($10 + $5 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,15]
[null,null,null,null,null,"Full Member Couples ($15 + $10 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,25]
[null,null,"C.     New members joining between 1 July and 31 October"]
[]
[]
[null,null,null,null,null,"Full Members ($5 + $5 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,10]
[null,null,null,null,null,"Full Member Couples ($7.50 + $10 Joining Fee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",null,17.5]
[null,null,"The preferred method of payment is a direct deposit into the Section Account.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fees Payable"]
[]
[null,null,null,null,null,null,"Section Account Details:",null,null,null,null,null,null,null,null,"Bank:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSB:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account #:"]
[]
[null,null,"OR Cheque #",null,null,null,null,null,null,null,null,"Bank Deposit Date:",null,null,null,null,null,null,null,null,null,null,"o  Copy of original bank receipt attached."]
[]
[null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.1 Jan 2022"]

{"sheet":"Data","index":3,"n_rows":160,"n_cols":35,"rows_kept":160,"cut":false,"hidden":true,"merged":[[135,29,135,32],[124,29,124,32],[134,29,134,32],[123,29,123,32],[110,21,110,24],[110,29,110,32],[111,21,111,24],[111,29,111,32],[62,21,62,24],[4,21,4,24],[4,29,4,32],[50,21,50,24],[50,29,50,32],[32,29,32,32],[32,21,32,24],[62,29,62,32],[5,21,5,24],[5,29,5,32],[33,21,33,24],[33,29,33,32],[51,21,51,24],[51,29,51,32],[63,29,63,32],[74,21,74,24],[75,21,75,24],[74,29,74,32],[75,29,75,32],[63,21,63,24],[149,21,149,24],[149,29,149,32],[86,21,86,24],[87,21,87,24],[86,29,86,32],[87,29,87,32],[99,21,99,24],[98,29,98,32],[99,29,99,32],[98,21,98,24],[134,21,134,24],[148,21,148,24],[148,29,148,32],[123,21,123,24],[124,21,124,24],[135,21,135,24]]}
["Data Page"]
["Sections",null,"Months",null,"Code",null,"Section","Code","Sub-Section",null,"Year"]
["?",null,"<Select Month>",null,"??",null,"??","??","<Pick a Sub-section>",null,"<Year?>"]
["QLD",null,"JANUARY",null,"A99",null,"ACT","A99","ACT",null,2020]
["NSW",null,"FEBRUARY",null,"N00",null,"SA","S80","ADELAIDE",null,2021,null,null,"Summary from the Form 3's",null,null,"Sheet 1",null,"Sheet 2",null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2",null,null,{"$f":"COUNTBLANK(AG7:AG26)","v":0}]
["ACT",null,"MARCH",null,"N01",null,"WA","W91","ALBANY (City of)",null,2022,null,null,"Paying Full Members",{"$f":"Q6+S6","v":0},"Renewing Members ",{"$f":"Y27","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C52","v":"Renewing Members"},{"$f":"AG27","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C147","v":"Renewing Members"},null,{"$f":"IF(V31=0,\"Renewing Members\",IF(ISERROR(MAX(V7:V26)),\"Please check your data\",\"Renewing Full Members - \"&Y27&\" (\"&Y27+Y28&\")  Others (\"&V29&\")\"))","v":"Renewing Members"},null,null,null,null,null,null,null,{"$f":"IF(AD31=0,\"Renewing Members\",IF(ISERROR(MAX(AD7:AD26)),\"Please check your data\",\"Renewing Full Members - \"&AG27&\" (\"&AG27+AG28&\")  Others (\"&AD29&\")\"))","v":"Renewing Members"}]
["VIC",null,"APRIL",null,"N03",null,"NSW","N01","BALLINA",null,2023,null,null,null,{"$f":"Q7+S7","v":0},"Already Paid",{"$f":"Y28","v":0},null,{"$f":"AG28","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C53","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D53","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q53","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W7)),IF(W7=0,2,3),1)","v":2},{"$f":"IF(X7=\"P\",X7,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(W7,7)=\" - Full\",Z7=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(W7,7)=\" - Full\",Z7<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(W7,7)=\"Partner\",Z7=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(W7,7)=\"Partner\",Z7<>\"P\"),\"UnPaid Partner\",\"\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C148","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D148","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q148","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE7)),IF(AE7=0,2,3),1)","v":2},{"$f":"IF(AF7=\"P\",AF7,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(AE7,7)=\" - Full\",AH7=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(AE7,7)=\" - Full\",AH7<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(AE7,7)=\"Partner\",AH7=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(AE7,7)=\"Partner\",AH7<>\"P\"),\"UnPaid Partner\",\"\"))","v":""}]
["TAS",null,"MAY",null,"N04",null,"QLD","Q54","BAYSIDE",null,2024,null,null,null,{"$f":"Q8+S8","v":0},"Other Members",{"$f":"Y29","v":0},null,{"$f":"AG29","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C54","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D54","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q54","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W8)),IF(W8=0,2,3),1)","v":2},"",{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(W8,7)=\" - Full\",Z8=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(W8,7)=\" - Full\",Z8<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(W8,7)=\"Partner\",Z8=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(W8,7)=\"Partner\",Z8<>\"P\"),\"UnPaid Partner\",\"\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C149","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D149","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q149","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE8)),IF(AE8=0,2,3),1)","v":2},"",{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(AE8,7)=\" - Full\",AH8=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(AE8,7)=\" - Full\",AH8<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(AE8,7)=\"Partner\",AH8=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(AE8,7)=\"Partner\",AH8<>\"P\"),\"UnPaid Partner\",\"\"))","v":""}]
["SA",null,"JUNE",null,"N05",null,"SA","S81","BEACHVALE",null,null,null,null,"Total FM",{"$f":"Q6+S6","v":0},null,{"$f":"Q6+Q7","v":0},null,{"$f":"S6+S7","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C55","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D55","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q55","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C150","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D150","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q150","v":0},2,"",""]
["WA",null,"JULY",null,"N09",null,"QLD","Q65","BEENLEIGH and DISTRICT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C56","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D56","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q56","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C151","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D151","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q151","v":0},2,"",""]
[null,null,"AUGUST",null,"N10",null,"VIC","V68","BOX HILL & DISTRICT",null,null,null,null,"Life Members ",{"$f":"Q11+S11","v":0},null,{"$f":"Q52","v":0},null,{"$f":"S52","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C57","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D57","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q57","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C152","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D152","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q152","v":0},2,"",""]
[null,null,"SEPTEMBER",null,"N11",null,"QLD","Q35","BRIBIE ISLAND",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C58","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D58","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q58","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C153","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D153","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q153","v":0},2,"",""]
[null,null,"OCTOBER",null,"N13",null,"QLD","Q36","BRISBANE",null,null,null,null,"Full Members paying Fees",{"$f":"O6+O11","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C59","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D59","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q59","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C154","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D154","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q154","v":0},2,"",""]
[null,null,"NOVEMBER",null,"N14",null,"QLD","Q41","BUNDAMBA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C60","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D60","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q60","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C155","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D155","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q155","v":0},2,"",""]
[null,null,"DECEMBER",null,"N15",null,"NSW","N04","CAMPBELLTOWN DISTRICT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C61","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D61","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q61","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C156","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D156","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q156","v":0},2,"",""]
[null,null,null,null,"N16",null,"QLD","Q57","CAPRICORNIA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C62","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D62","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q62","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C157","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D157","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q157","v":0},2,"",""]
[null,null,"Positions",null,"N18",null,"NSW","N03","CENTRAL COAST",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C63","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D63","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q63","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C158","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D158","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q158","v":0},2,"",""]
[null,null,"Secretary",null,"N19",null,"QLD","Q56","CORAL COAST",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C64","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D64","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q64","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C159","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D159","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q159","v":0},2,"",""]
[null,null,"Treasurer",null,"N20",null,"VIC","V58","DANDENONG",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C65","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D65","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q65","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C160","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D160","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q160","v":0},2,"",""]
[null,null,"Membership Registrar",null,"N22",null,"QLD","Q39","DARLING DOWNS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C66","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D66","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q66","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C161","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D161","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q161","v":0},2,"",""]
[null,null,"Secretary (Acting )",null,"N23",null,"TAS","T71","Devonport / Ulverstone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C67","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D67","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q67","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C162","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D162","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q162","v":0},2,"",""]
[null,null,"Treasurer (Acting)",null,"N25",null,"VIC","V70","EAST GIPPSLAND",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C68","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D68","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q68","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C163","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D163","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q163","v":0},2,"",""]
[null,null,"Membership Registrar (Acting)",null,"N32",null,"QLD","Q63","eFLEET",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C69","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D69","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q69","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C164","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D164","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q164","v":0},2,"",""]
[null,null,null,null,"N36",null,"SA","S82","ELIZABETH/SALISBURY",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C70","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D70","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q70","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C165","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D165","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q165","v":0},2,"",""]
[null,null,null,null,"Q00",null,"VIC","V59","FOOTSCRAY",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C71","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D71","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q71","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C166","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D166","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q166","v":0},2,"",""]
[null,null,null,null,"Q35",null,"VIC","V60","FRANKSTON",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C72","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D72","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q72","v":0},2,"","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C167","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D167","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q167","v":0},2,"",""]
[null,null,null,null,"Q36",null,"QLD","Q66","FRASER COAST",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y27=0,\"\",Y27)","v":""},"Renewing Full Members",null,{"$f":"COUNTIFS(AA7:AA26,\"UnPaid Full\",Y7:Y26,1)","v":0},null,null,null,null,{"$f":"IF(AG27=0,\"\",AG27)","v":""},"Renewing Full Members",null,{"$f":"COUNTIFS(AI7:AI26,\"UnPaid Full\",AG7:AG26,1)","v":0}]
[null,null,"Membership",null,"Q39",null,"VIC","V61","GEELONG",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y28=0,\"\",Y28)","v":""},"Full Members already paid",null,{"$f":"COUNTIFS(AA7:AA26,\"Paid Full\",Y7:Y26,1)","v":0},null,null,null,null,{"$f":"IF(AG28=0,\"\",AG28)","v":""},"Full Members already paid",null,{"$f":"COUNTIFS(AI7:AI26,\"Paid Full\",AG7:AG26,1)","v":0}]
[null,null,"Full",null,"Q41",null,"TAS","T72","GEORGE TOWN",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y29=0,\"\",Y29)","v":""},"Non Paying Member enteries",null,{"$f":"COUNTIF(Y7:Y26,3)","v":0},null,null,null,null,{"$f":"IF(AG29=0,\"\",AG29)","v":""},"Non Paying Member enteries",null,{"$f":"COUNTIF(AG7:AG26,3)","v":0}]
[null,null,"Partner",null,"Q42",null,"WA","W89","GERALDTON (City of)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y30=0,\"\",Y30)","v":20},"Blank Enteries",null,{"$f":"COUNTIF(W7:W26,0)","v":20},null,null,null,null,{"$f":"IF(AG30=0,\"\",AG30)","v":20},"Blank Enteries",null,{"$f":"COUNTIF(AE7:AE26,0)","v":20}]
[null,null,"Club",null,"Q43",null,"NSW","N09","GERRINGONG",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V7:V26)),\"0\",MAX(V7:V26))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD7:AD26)),\"0\",MAX(AD7:AD26))","v":0},"Active Number of lines"]
[null,null,"Social",null,"Q46",null,"QLD","Q51","GOLD COAST"]
[null,null,"Associate",null,"Q48",null,"QLD","Q55","GREENBANK",null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,"Honourary",null,"Q49",null,"NSW","N10","ILLAWARRA",null,null,null,null,"Full Member Coulpes",{"$f":"Q34+S34","v":0},"Renewing Full Couples",{"$f":"Y45","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C73","v":"Full Member Couples"},{"$f":"AG45","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C168","v":"Full Member Couples"},null,{"$f":"IF(ISERROR(MAX(V35:V44)),\"Data Error\",IF(V49=0,\"Full Member Couples\",IF(OR(IF(Z46>=Z45,\"\",\"Error\")=\"Error\",IF(Z48>=Z47,\"\",\"Error\")=\"Error\"),\"Check your Data\",\"Full Member Couples (\"&V45&\") Partners (\"&V46&\") - [(\"&V47&\") / (\"&V48&\")\")))","v":"Full Member Couples"},null,null,null,null,null,null,null,{"$f":"IF(AD49=0,\"Full Member Couples\",IF(OR(AND(AG45=\"\",AG46=\"\"),AND(AG47=\"\",AG48=\"\")),\"Data Error\",IF(ISERROR(MAX(AD35:AD44)),\"Please check your data\",\"Full Member Couples (\"&AD45&\")  Partners (\"&AD46&\")  [Paid (\"&AD47&\")/(\"&AD48&\")]\")))","v":"Full Member Couples"}]
[null,null,"Life Member",null,"Q50",null,"QLD","Q42","Ipswich - West Moreton",null,null,null,null,25,{"$f":"O34*N35","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C74","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D74","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q74","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W35)),\"\",1)","v":""},{"$f":"IF(X35=\"P\",X35,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(W35,7)=\" - Full\",Z35=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(W35,7)=\" - Full\",Z35<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(W35,7)=\"Partner\",Z35=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(W35,7)=\"Partner\",Z35<>\"P\"),\"UnPaid Partner\",\"\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C169","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D169","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q169","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE35)),\"\",1)","v":""},{"$f":"IF(AF35=\"P\",AF35,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(AE35,7)=\" - Full\",AH35=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(AE35,7)=\" - Full\",AH35<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(AE35,7)=\"Partner\",AH35=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(AE35,7)=\"Partner\",AH35<>\"P\"),\"UnPaid Partner\",\"\"))","v":""}]
[null,null,"Life Subscriber",null,"Q51",null,"TAS","T79","LAUNCESTON SOUTH",null,null,null,null,15,{"$f":"O34*N36","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C75","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D75","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q75","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W36)),\"\",1)","v":""},{"$f":"IF(X36=\"P\",X36,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(W36,7)=\" - Full\",Z36=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(W36,7)=\" - Full\",Z36<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(W36,7)=\"Partner\",Z36=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(W36,7)=\"Partner\",Z36<>\"P\"),\"UnPaid Partner\",\"\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C170","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D170","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q170","v":0},"",{"$f":"IF(AF36=\"P\",AF36,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(AE36,7)=\" - Full\",AH36=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(AE36,7)=\" - Full\",AH36<>\"P\"),\"UnPaid Full\",\"\"),IF(AND(RIGHT(AE36,7)=\"Partner\",AH36=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(AE36,7)=\"Partner\",AH36<>\"P\"),\"UnPaid Partner\",\"\"))","v":""}]
[null,null,"Crossed the Bar",null,"Q52",null,"NSW","N11","LISMORE-CASINO",null,null,null,null,"Full Member Couples",{"$f":"Q37+S37","v":0},"Renewing Partners",{"$f":"Y46","v":0},null,{"$f":"AG46","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C76","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D76","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q76","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C171","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D171","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q171","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE37)),\"\",1)","v":""},"",""]
[null,null,null,null,"Q53",null,"QLD","Q43","LOGAN & DISTRICT",null,null,null,null,8,{"$f":"O37*N38","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C77","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D77","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q77","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C172","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D172","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q172","v":0},"","",""]
[null,null,null,null,"Q54",null,"WA","W98","MANDURAH (City of)",null,null,null,null,5,{"$f":"O37*N39","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C78","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D78","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q78","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C173","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D173","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q173","v":0},"","",""]
[null,null,null,null,"Q55",null,"QLD","Q62","MAROOCHY WATERS",null,null,null,null,"National Fees ",{"$f":"O35+O38","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C79","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D79","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q79","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C174","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D174","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q174","v":0},"","",""]
[null,null,null,null,"Q56",null,"VIC","V64","MELBOURNE",null,null,null,null,"Section Fees",{"$f":"O36+O39","v":0},null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C80","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D80","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q80","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C175","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D175","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q175","v":0},"","",""]
[null,null,null,null,"Q57",null,"SA","S83","MT.GAMBIER",null,null,null,null,{"$f":"O34&\" + \"&O37","v":"0 + 0"},0,"Paid Full Couples",{"$f":"Y47","v":0},null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C81","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D81","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q81","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C176","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D176","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q176","v":0},"","",""]
[null,null,null,null,"Q62",null,"NSW","N14","NAVAL HEALTH SERVICES.",null,null,null,null,{"$f":"IF(AND(VALUE(LEFT(N42,FIND(\"+\",N42)-2))=0,VALUE(RIGHT(N42,FIND(\"+\",N42)-(FIND(\"+\",N42)-1)))=0),\"\",N42)","v":""},0,"Paid Partners",{"$f":"Y48","v":0},null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C82","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D82","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q82","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C177","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D177","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q177","v":0},"","",""]
[null,null,null,null,"Q63",null,"NSW","N13","NAVAL RESERVE ASSOCIATION",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C83","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D83","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q83","v":0},"","","",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C178","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D178","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q178","v":0},"","",""]
[null,null,null,null,"Q64",null,"VIC","V71","NAVY VIETNAM",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y45=0,\"\",Y45)","v":""},"UnPaid Full Couples",null,{"$f":"IF(Z45>Z46,\"\",COUNTIFS(AA35:AA44,\"UnPaid Full\"))","v":0},{"$f":"COUNTIFS(AA35:AA44,\"UnPaid Full\")","v":0},"Full",null,null,{"$f":"IF(AG45=0,\"\",AG45)","v":""},"UnPaid Full Couples",null,{"$f":"IF(AH45>AH46,\"\",COUNTIFS(AI35:AI44,\"UnPaid Full\"))","v":0},{"$f":"COUNTIFS(AI35:AI44,\"UnPaid Full\")","v":0},"Full"]
[null,null,null,null,"Q65",null,"QLD","Q53","NAVY WOMEN (WRANS-RAN) QLD",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y46=0,\"\",Y46)","v":""},"UnPaid Partner",null,{"$f":"IF(Z45>Z46,\"\",COUNTIFS(AA35:AA44,\"UnPaid Partner\")-Y45)","v":0},{"$f":"COUNTIFS(AA35:AA44,\"UnPaid Partner\")","v":0},"Partners",null,null,{"$f":"IF(AG46=0,\"\",AG46)","v":""},"UnPaid Partner",null,{"$f":"IF(AH45>AH46,\"\",COUNTIFS(AI35:AI44,\"UnPaid Partner\")-AG45)","v":0},{"$f":"COUNTIFS(AI35:AI44,\"UnPaid Partner\")","v":0},"Partners"]
[null,null,null,null,"Q66",null,"NSW","N15","NEPEAN BLUE MOUNTAINS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y47=0,\"\",Y47)","v":""},"Paid Full Couples",null,{"$f":"IF(Z47=0,0,COUNTIFS(AA35:AA44,\"Paid Full\"))","v":0},{"$f":"COUNTIFS(AA35:AA44,\"Paid Full\")","v":0},"Full",null,null,{"$f":"IF(AG47=0,\"\",AG47)","v":""},"Paid Full Couples",null,{"$f":"IF(AH47=0,0,COUNTIFS(AI35:AI44,\"Paid Full\"))","v":0},{"$f":"COUNTIFS(AI35:AI44,\"Paid Full\")","v":0},"Full"]
[null,null,null,null,"S00",null,"NSW","N16","NEWCASTLE",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y48=0,\"\",Y48)","v":""},"Paid Partner",null,{"$f":"IF(Z48=0,0,COUNTIFS(AA35:AA44,\"Paid Partner\")-Z47)","v":0},{"$f":"COUNTIFS(AA35:AA44,\"Paid Partner\")","v":0},"Partners",null,null,{"$f":"IF(AG48=0,\"\",AG48)","v":""},"Paid Partner",null,{"$f":"IF(AH48=0,0,COUNTIFS(AI35:AI44,\"Paid Partner\")-AH47)","v":0},{"$f":"COUNTIFS(AI35:AI44,\"Paid Partner\")","v":0},"Partners"]
[null,null,null,null,"S80",null,"NSW","N32","NIRIMBA (NSW)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V35:V44)),\"0\",MAX(V35:V44))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD35:AD44)),\"0\",MAX(AD35:AD44))","v":0},"Active Number of lines"]
[null,null,null,null,"S81",null,"NSW","N00","NSW State Section"]
[null,null,null,null,"S82",null,"NSW","N18","ORANGE",null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,null,null,"S83",null,"NSW","N19","PARRAMATTA MEMORIAL",null,null,null,null,"Life Members ",{"$f":"Q52+S52","v":0},"Sub-section to pay",{"$f":"Y58","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C84","v":"Life Members"},{"$f":"AG58","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C179","v":"Life Members"},null,{"$f":"IF(V61=0,\"Life Members\",IF(ISERROR(MAX(V53:V57)),\"Please check your data\",\"Life members paid for - \"&Y58&\" (\"&Y58+Y59&\")\"))","v":"Life Members"},null,null,null,null,null,null,null,{"$f":"IF(AD61=0,\"Life Members\",IF(ISERROR(MAX(AD53:AD57)),\"Please check your data\",\"Life members paid for - \"&AG58&\" (\"&AG58+AG59&\")\"))","v":"Life Members"}]
[null,null,null,null,"S84",null,"WA","W93","PERTH (City of)",null,null,null,null,null,{"$f":"Q53+S53","v":0},"Paid by other Sub-section",{"$f":"Y59","v":0},null,{"$f":"AG59","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C85","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D85","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q85","v":0},{"$f":"IF(X53='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(X53<>0,2,3))","v":3},null,{"$f":"RIGHT(W53,11)","v":"0"},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C180","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D180","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q180","v":0},{"$f":"IF(AF53='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(AF53<>0,2,3))","v":3},null,{"$f":"RIGHT(AE53,11)","v":"0"}]
[null,null,null,null,"S86",null,"WA","W99","PERTH NORTH",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C86","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D86","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q86","v":0},{"$f":"IF(X54='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(X54<>0,2,3))","v":3},null,{"$f":"RIGHT(W54,11)","v":"0"},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C181","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D181","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q181","v":0},{"$f":"IF(AF54='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(AF54<>0,2,3))","v":3},null,{"$f":"RIGHT(AE54,11)","v":"0"}]
[null,null,null,null,"S88",null,"QLD","Q48","PINE RIVERS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C87","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D87","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q87","v":0},{"$f":"IF(X55='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(X55<>0,2,3))","v":3},null,"0",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C182","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D182","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q182","v":0},{"$f":"IF(AF55='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(AF55<>0,2,3))","v":3},null,"0"]
[null,null,null,null,"S89",null,"SA","S84","PORT ADELAIDE",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C88","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D88","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q88","v":0},{"$f":"IF(X56='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(X56<>0,2,3))","v":3},null,"0",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C183","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D183","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q183","v":0},{"$f":"IF(AF56='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(AF56<>0,2,3))","v":3},null,"0"]
[null,null,null,null,"T00",null,"NSW","N20","PORT MACQUARIE",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C89","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D89","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q89","v":0},{"$f":"IF(X57='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(X57<>0,2,3))","v":3},null,"0",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C184","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D184","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q184","v":0},{"$f":"IF(AF57='Auto Fill - F2A, F2B and F3'!$AG$11,1,IF(AF57<>0,2,3))","v":3},null,"0"]
[null,null,null,null,"T71",null,"NSW","N36","PORT STEPHENS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y58","v":0},"Life Members being paid for",null,{"$f":"COUNTIFS(AA53:AA57,\"Life Member\",Y53:Y57,1)","v":0},null,null,null,null,{"$f":"AG58","v":0},"Life Members being paid for",null,{"$f":"COUNTIFS(AI53:AI57,\"Life Member\",AG53:AG57,1)","v":0}]
[null,null,null,null,"T72",null,"QLD","Q00","QLD State Section",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y59","v":0},"Life members paid by another SS",null,{"$f":"COUNTIFS(AA53:AA57,\"Life Member\",Y53:Y57,2)","v":0},null,null,null,null,{"$f":"AG59","v":0},"Life members paid by another SS",null,{"$f":"COUNTIFS(AI53:AI57,\"Life Member\",AG53:AG57,2)","v":0}]
[null,null,null,null,"T79",null,"QLD","Q49","REDCLIFFE",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y60","v":5},"Error",null,{"$f":"COUNTIFS(Y53:Y57,3,W53:W57,0)","v":5},null,null,null,null,{"$f":"AG60","v":5},"Error",null,{"$f":"COUNTIFS(AG53:AG57,3,AE53:AE57,0)","v":5}]
[null,null,null,null,"V00",null,"SA","S86","Riverland",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V53:V57)),\"0\",MAX(V53:V57))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD53:AD57)),\"0\",MAX(AD53:AD57))","v":0},"Active Number of lines"]
[null,null,null,null,"V58",null,"WA","W97","ROCKINGHAM (City of)"]
[null,null,null,null,"V59",null,"NSW","N22","ROOTY HILL",null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,null,null,"V60",null,"SA","S00","SA State Section",null,null,null,null,"Deaths Reported",{"$f":"Q64+S64","v":0},"Full",{"$f":"Y69","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C90","v":"Deaths Reported"},{"$f":"AG69","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!C185","v":"Deaths Reported"},null,{"$f":"IF(V73=0,\"Deaths Reported\",IF(ISERROR(MAX(V65:V68)),\"Please check your data\",\"Deaths Reported Full (\"&V69&\") LM (\"&V71&\") Part. (\"&V70&\") Other (\"&V72&\")\"))","v":"Deaths Reported"},null,null,null,null,null,null,null,{"$f":"IF(AD73=0,\"Deaths Reported\",IF(ISERROR(MAX(AD65:AD68)),\"Please check your data\",\"Deaths Reported Full (\"&AD69&\") LM (\"&AD71&\") Part. (\"&AD70&\") Other (\"&AD72&\")\"))","v":"Deaths Reported"}]
[null,null,null,null,"V61",null,"QLD","Q50","SANDGATE",null,null,null,null,null,{"$f":"Q65+S65","v":0},"Partner",{"$f":"Y70","v":0},null,{"$f":"AG70","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C91","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D91","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q91","v":0},null,null,{"$f":"IF(V65=\"\",\"\",IF(RIGHT(W65,7)=\" - Full\",\"Full\",IF(RIGHT(W65,11)=\"Life Member\",\"Life Member\",IF(RIGHT(W65,7)=\"Partner\",\"Partner\",\"Other\"))))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C186","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D186","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q186","v":0},null,null,{"$f":"IF(AD65=\"\",\"\",IF(RIGHT(AE65,7)=\" - Full\",\"Full\",IF(RIGHT(AE65,11)=\"Life Member\",\"Life Member\",IF(RIGHT(AE65,7)=\"Partner\",\"Partner\",\"Other\"))))","v":""}]
[null,null,null,null,"V64",null,"NSW","N23","SHOALHAVEN",null,null,null,null,null,{"$f":"Q66+S66","v":0},"Others",{"$f":"Y72","v":0},null,{"$f":"AG72","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C92","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D92","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q92","v":0},null,null,{"$f":"IF(V66=\"\",\"\",IF(RIGHT(W66,7)=\" - Full\",\"Full\",IF(RIGHT(W66,11)=\"Life Member\",\"Life Member\",IF(RIGHT(W66,7)=\"Partner\",\"Partner\",\"Other\"))))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C187","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D187","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q187","v":0},null,null,{"$f":"IF(AD66=\"\",\"\",IF(RIGHT(AE66,7)=\" - Full\",\"Full\",IF(RIGHT(AE66,11)=\"Life Member\",\"Life Member\",IF(RIGHT(AE66,7)=\"Partner\",\"Partner\",\"Other\"))))","v":""}]
[null,null,null,null,"V65",null,"VIC","V67","SOUTH EASTERN",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C93","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D93","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q93","v":0},null,null,"",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C188","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D188","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q188","v":0},null,null,""]
[null,null,null,null,"V67",null,"VIC","V72","SOUTH WEST",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C94","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D94","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q94","v":0},null,null,"",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!C189","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!D189","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!Q189","v":0},null,null,""]
[null,null,null,null,"V68",null,"QLD","Q64","STANTHORPE",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y69=0,\"\",Y69)","v":""},"Full",null,{"$f":"COUNTIF(AA65:AA68,\"Full\")","v":0},null,null,null,null,{"$f":"IF(AG69=0,\"\",AG69)","v":""},"Full",null,{"$f":"COUNTIF(AI65:AI68,\"Full\")","v":0}]
[null,null,null,null,"V70",null,"VIC","V65","SUNRAYSIA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y70=0,\"\",Y70)","v":""},"Partner",null,{"$f":"COUNTIF(AA65:AA68,\"Partner\")","v":0},null,null,null,null,{"$f":"IF(AG70=0,\"\",AG70)","v":""},"Partner",null,{"$f":"COUNTIF(AI65:AI68,\"Partner\")","v":0}]
[null,null,null,null,"V71",null,"QLD","Q52","SUNSHINE COAST",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y71=0,\"\",Y71)","v":""},"Life member",null,{"$f":"COUNTIF(AA65:AA68,\"Life Member\")","v":0},null,null,null,null,{"$f":"IF(AG71=0,\"\",AG71)","v":""},"Life member",null,{"$f":"COUNTIF(AI65:AI68,\"Life Member\")","v":0}]
[null,null,null,null,"V72",null,"NSW","N05","SYDNEY/COUNTRY",null,null,null,null,null,null,null,null,null,null,null,null,"","Others",null,{"$f":"COUNTIF(AA65:AA68,\"Other\")","v":0},null,null,null,null,"","Others",null,{"$f":"COUNTIF(AI65:AI68,\"Other\")","v":0}]
[null,null,null,null,"W00",null,"TAS","T00","TAS State Section",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V65:V68)),\"0\",MAX(V65:V68))","v":0},"Active Number of lines",null,{"$f":"V73-Y70-Y69-Y72","v":0},null,null,null,null,{"$f":"IF(ISERROR(MAX(AD65:AD68)),\"0\",MAX(AD65:AD68))","v":0},"Active Number of lines",null,{"$f":"AD73-AG70-AG69-AG72","v":0}]
[null,null,null,null,"W89",null,"QLD","Q46","TOWNSVILLE & DISTRICT"]
[null,null,null,null,"W91",null,"NSW","N25","TUGGERAH LAKES",null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #1"]
[null,null,null,null,"W93",null,"VIC","V00","VIC State Section",null,null,null,null,"Members in Arrears",{"$f":"Q76+S76","v":0},"Members",{"$f":"Y82","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T53","v":"Members in Arrears"},{"$f":"AG82","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T148","v":"Members in Arrears"},null,{"$f":"IF(V85=0,\"Members in Arrears\",IF(ISERROR(MAX(V77:V81)),\"Please check your data\",\"Members in Arrears (\"&Y84&\")   Periods (\"&U82&\")\"))","v":"Members in Arrears"},null,null,null,null,null,null,null,{"$f":"IF(AD85=0,\"Members in Arrears\",IF(ISERROR(MAX(AD77:AD81)),\"Please check your data\",\"Members in Arrears (\"&AG84&\")   Periods (\"&AC82&\")\"))","v":"Members in Arrears"}]
[null,null,null,null,"W97",null,"SA","S89","W.R.A.N.S. (SA)",null,null,null,null,{"$f":"O76+O77","v":0},{"$f":"Q77+S77","v":0},"Partners",{"$f":"Y83","v":0},null,{"$f":"AG83","v":0},null,{"$f":"IF(AND(OR(AA77=\"Full\",AA77=\"Partner\"),W77<>0),IF(X77=0,0,VALUE(RIGHT(X77,2))-VALUE(LEFT(X77,2))+1),0)","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T54","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U54","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH54","v":0},null,{"$f":"IF(X77=\"P\",X77,\"\")","v":""},{"$f":"IF(V77=\"\",\"\",IF(RIGHT(W77,7)=\" - Full\",\"Full\",IF(RIGHT(W77,7)=\"Partner\",\"Partner\",\"Other\")))","v":""},null,{"$f":"IF(AND(OR(AI77=\"Full\",AI77=\"Partner\"),AE77<>0),IF(AF77=0,0,VALUE(RIGHT(AF77,2))-VALUE(LEFT(AF77,2))+1),0)","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T149","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U149","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH149","v":0},null,{"$f":"IF(AF77=\"P\",AF77,\"\")","v":""},{"$f":"IF(AD77=\"\",\"\",IF(RIGHT(AE77,7)=\" - Full\",\"Full\",IF(RIGHT(AE77,7)=\"Partner\",\"Partner\",\"Other\")))","v":""}]
[null,null,null,null,"W98",null,"WA","W00","WA State Section",null,null,null,null,null,{"$f":"Q78+S78","v":0},"Periods",{"$f":"U82","v":0},null,{"$f":"AC82","v":0},null,{"$f":"IF(AND(OR(AA78=\"Full\",AA78=\"Partner\"),W78<>0),IF(X78=0,0,VALUE(RIGHT(X78,2))-VALUE(LEFT(X78,2))+1),0)","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T55","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U55","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH55","v":0},null,null,{"$f":"IF(V78=\"\",\"\",IF(RIGHT(W78,7)=\" - Full\",\"Full\",IF(RIGHT(W78,7)=\"Partner\",\"Partner\",\"Other\")))","v":""},null,{"$f":"IF(AND(OR(AI78=\"Full\",AI78=\"Partner\"),AE78<>0),IF(AF78=0,0,VALUE(RIGHT(AF78,2))-VALUE(LEFT(AF78,2))+1),0)","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T150","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U150","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH150","v":0},null,null,{"$f":"IF(AD78=\"\",\"\",IF(RIGHT(AE78,7)=\" - Full\",\"Full\",IF(RIGHT(AE78,7)=\"Partner\",\"Partner\",\"Other\")))","v":""}]
[null,null,null,null,"W99",null,"SA","S88","WHYALLA",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"'Auto Fill - F2A, F2B and F3'!T56","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U56","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH56","v":0},null,null,"",null,0,{"$f":"'Auto Fill - F2A, F2B and F3'!T151","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U151","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH151","v":0},null,null,""]
[null,null,null,null,"000",null,"NAT","000","National Council",null,null,null,null,null,{"$f":"IF((Q78+S78)=0,\"\",Data!O78&\" - Year/s\")","v":""},null,null,null,null,null,0,{"$f":"'Auto Fill - F2A, F2B and F3'!T57","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U57","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH57","v":0},null,null,"",null,0,{"$f":"'Auto Fill - F2A, F2B and F3'!T152","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U152","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH152","v":0},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"'Auto Fill - F2A, F2B and F3'!T58","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U58","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH58","v":0},null,null,"",null,0,{"$f":"'Auto Fill - F2A, F2B and F3'!T153","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U153","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH153","v":0},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V85=0,0,SUM(U77:U81))","v":0},{"$f":"IF(Y82=0,\"\",Y82)","v":""},"Full Members",null,{"$f":"COUNTIF(AA77:AA81,\"Full\")","v":0},null,null,null,{"$f":"IF(AD85=0,0,SUM(AC77:AC81))","v":0},{"$f":"IF(AG82=0,\"\",AG82)","v":""},"Full Members",null,{"$f":"COUNTIF(AI77:AI81,\"Full\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y83=0,\"\",Y83)","v":""},"Partner members",null,{"$f":"COUNTIF(AA77:AA81,\"Partner\")","v":0},null,null,null,null,{"$f":"IF(AG83=0,\"\",AG83)","v":""},"Partner members",null,{"$f":"COUNTIF(AI77:AI81,\"Partner\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Paying Members",null,{"$f":"Y82+Y83","v":0},null,null,null,null,"","Paying Members",null,{"$f":"AG82+AG83","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V77:V81)),\"0\",MAX(V77:V81))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD77:AD81)),\"0\",MAX(AD77:AD81))","v":0},"Active Number of lines"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"New Full Members",{"$f":"Q88+S88","v":0},"New Members",{"$f":"Y94","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T59","v":"New Members"},{"$f":"AG94","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T154","v":"New Members"},null,{"$f":"IF(V97=0,\"New Members\",IF(ISERROR(MAX(V89:V93)),\"Please check your data\",IF(MAX(V89:V93)=0,\"New Members\",\"New Members\"&\" - Full \"&V94&\" (\"&V97&\")  Disc (\"&V95&\")  Paid(\"&V96&\")\")))","v":"New Members"},null,null,null,null,null,null,null,{"$f":"IF(AD97=0,\"New Members\",IF(ISERROR(MAX(AD89:AD93)),\"Please check your data\",IF(MAX(AD89:AD93)=0,\"New Members\",\"New Members\"&\" - Full \"&AD94&\" (\"&AD97&\")  Disc (\"&AD95&\")  Paid(\"&AD96&\")\")))","v":"New Members"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"New Discounted",{"$f":"Q89+S89","v":0},"New Discounted Members",{"$f":"Y95","v":0},null,{"$f":"AG95","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T60","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U60","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH60","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W89)),\"\",1)","v":""},{"$f":"IF(X89=\"D\",X89,IF(X89=\"P\",X89,\"\"))","v":""},{"$f":"IF(V89=\"\",\"\",IF(W89=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T155","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U155","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH155","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE89)),\"\",1)","v":""},{"$f":"IF(AF89=\"D\",AF89,IF(AF89=\"P\",AF89,\"\"))","v":""},{"$f":"IF(AD89=\"\",\"\",IF(AE89=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T61","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U61","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH61","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W90)),\"\",1)","v":""},{"$f":"IF(X90=\"D\",X90,IF(X90=\"P\",X90,\"\"))","v":""},{"$f":"IF(V90=\"\",\"\",IF(W90=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T156","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U156","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH156","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE90)),\"\",1)","v":""},{"$f":"IF(AF90=\"D\",AF90,IF(AF90=\"P\",AF90,\"\"))","v":""},{"$f":"IF(AD90=\"\",\"\",IF(AE90=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T62","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U62","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH62","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W91)),\"\",1)","v":""},"",{"$f":"IF(V91=\"\",\"\",IF(W91=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T157","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U157","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH157","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE91)),\"\",1)","v":""},"",{"$f":"IF(AD91=\"\",\"\",IF(AE91=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T63","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U63","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH63","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W92)),\"\",1)","v":""},"",{"$f":"IF(V92=\"\",\"\",IF(W92=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T158","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U158","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH158","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE92)),\"\",1)","v":""},"",{"$f":"IF(AD92=\"\",\"\",IF(AE92=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T64","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U64","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH64","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W93)),\"\",1)","v":""},"",{"$f":"IF(V93=\"\",\"\",IF(W93=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T159","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U159","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH159","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE93)),\"\",1)","v":""},"",{"$f":"IF(AD93=\"\",\"\",IF(AE93=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y94=0,\"\",Y94)","v":""},"New Members",null,{"$f":"IF(ISERROR(MAX(V89:V93)),0,COUNTIFS(Z89:Z93,\"\",AA89:AA93,\"New\"))","v":0},null,null,null,null,{"$f":"IF(AG94=0,\"\",AG94)","v":""},"New Members",null,{"$f":"IF(ISERROR(MAX(AD89:AD93)),0,COUNTIFS(AH89:AH93,\"\",AI89:AI93,\"New\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y95=0,\"\",Y95)","v":""},"New Discounted  Members",null,{"$f":"IF(ISERROR(MAX(V89:V93)),0,COUNTIFS(Z89:Z93,\"D\",AA89:AA93,\"New\"))","v":0},null,null,null,null,{"$f":"IF(AG95=0,\"\",AG95)","v":""},"New Discounted  Members",null,{"$f":"IF(ISERROR(MAX(AD89:AD93)),0,COUNTIFS(AH89:AH93,\"D\",AI89:AI93,\"New\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y96=0,\"\",Y96)","v":""},"New Paid members",null,{"$f":"IF(ISERROR(MAX(V89:V93)),0,COUNTIFS(Z89:Z93,\"P\",AA89:AA93,\"New\"))","v":0},null,null,null,null,{"$f":"IF(AG96=0,\"\",AG96)","v":""},"New Paid members",null,{"$f":"IF(ISERROR(MAX(AD89:AD93)),0,COUNTIFS(AH89:AH93,\"P\",AI89:AI93,\"New\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V89:V93)),\"0\",MAX(V89:V93))","v":0},"Active Number of lines",null,{"$f":"V97-Y94-Y95","v":0},null,null,null,null,{"$f":"IF(ISERROR(MAX(AD89:AD93)),\"0\",MAX(AD89:AD93))","v":0},"Active Number of lines",null,{"$f":"AD97-AG94-AG95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"New Couples",{"$f":"Q100+S100","v":0},"New Couples",{"$f":"Y106","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T65","v":"New Member Couples"},{"$f":"AG106","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T160","v":"New Member Couples"},null,{"$f":"IF(V109=0,\"New Member Couples\",IF(ISERROR(MAX(V101:V105)),\"Please check your data\",IF(MAX(V101:V105)=0,\"New Member Couples\",\"New Member Couples\"&\" - Full \"&V106&\" (\"&V109&\")  Disc (\"&V107&\")  Paid(\"&V108&\")\")))","v":"New Member Couples"},null,null,null,null,null,null,null,{"$f":"IF(AD109=0,\"New Member Couples\",IF(ISERROR(MAX(AD101:AD105)),\"Please check your data\",IF(MAX(AD101:AD105)=0,\"New Member Couples\",\"New Member Couples\"&\" - Full \"&AD106&\" (\"&AD109&\")  Disc (\"&AD107&\")  Paid(\"&AD108&\")\")))","v":"New Member Couples"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Discounted Couples",{"$f":"Q101+S101","v":0},"Discounted New Couples",{"$f":"Y107","v":0},null,{"$f":"AG107","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T66","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U66","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH66","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W101)),\"\",1)","v":""},{"$f":"IF(X101=\"D\",X101,IF(X101=\"P\",X101,\"\"))","v":""},{"$f":"IF(V101=\"\",\"\",IF(W101=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T161","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U161","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH161","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE101)),\"\",1)","v":""},{"$f":"IF(AF101=\"D\",AF101,IF(AF101=\"P\",AF101,\"\"))","v":""},{"$f":"IF(AD101=\"\",\"\",IF(AE101=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T67","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U67","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH67","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W102)),\"\",1)","v":""},{"$f":"IF(X102=\"D\",X102,IF(X102=\"P\",X102,\"\"))","v":""},{"$f":"IF(V102=\"\",\"\",IF(W102=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T162","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U162","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH162","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE102)),\"\",1)","v":""},{"$f":"IF(AF102=\"D\",AF102,IF(AF102=\"P\",AF102,\"\"))","v":""},{"$f":"IF(AD102=\"\",\"\",IF(AE102=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T68","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U68","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH68","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W103)),\"\",1)","v":""},"",{"$f":"IF(V103=\"\",\"\",IF(W103=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T163","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U163","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH163","v":0},"","",{"$f":"IF(AD103=\"\",\"\",IF(AE103=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T69","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U69","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH69","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W104)),\"\",1)","v":""},"",{"$f":"IF(V104=\"\",\"\",IF(W104=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T164","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U164","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH164","v":0},"","",{"$f":"IF(AD104=\"\",\"\",IF(AE104=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T70","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U70","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH70","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W105)),\"\",1)","v":""},"",{"$f":"IF(V105=\"\",\"\",IF(W105=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T165","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U165","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH165","v":0},"","",{"$f":"IF(AD105=\"\",\"\",IF(AE105=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y106=0,\"\",Y106)","v":""},"New Members",null,{"$f":"IF(ISERROR(MAX(V101:V105)),0,COUNTIFS(Z101:Z105,\"\",AA101:AA105,\"New\"))","v":0},null,null,null,null,{"$f":"IF(AG106=0,\"\",AG106)","v":""},"New Members",null,{"$f":"IF(ISERROR(MAX(AD101:AD105)),0,COUNTIFS(AH101:AH105,\"\",AI101:AI105,\"New\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y107=0,\"\",Y107)","v":""},"New Discounted  Members",null,{"$f":"IF(ISERROR(MAX(V101:V105)),0,COUNTIFS(Z101:Z105,\"D\",AA101:AA105,\"New\"))","v":0},null,null,null,null,{"$f":"IF(AG107=0,\"\",AG107)","v":""},"New Discounted  Members",null,{"$f":"IF(ISERROR(MAX(AD101:AD105)),0,COUNTIFS(AH101:AH105,\"D\",AI101:AI105,\"New\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y108=0,\"\",Y108)","v":""},"New Paid members",null,{"$f":"IF(ISERROR(MAX(V101:V105)),0,COUNTIFS(Z101:Z105,\"P\",AA101:AA105,\"New\"))","v":0},null,null,null,null,{"$f":"IF(AG108=0,\"\",AG108)","v":""},"New Paid members",null,{"$f":"IF(ISERROR(MAX(AD101:AD105)),0,COUNTIFS(AH101:AH105,\"P\",AI101:AI105,\"New\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V101:V105)),\"0\",MAX(V101:V105))","v":0},"Active Number of lines",null,{"$f":"V109-Y107-Y106","v":0},null,null,null,null,{"$f":"IF(ISERROR(MAX(AD101:AD105)),\"0\",MAX(AD101:AD105))","v":0},"Active Number of lines",null,{"$f":"AD109-AG107-AG106","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Resignations Received",{"$f":"Q112+S112","v":{"$error":"#VALUE!"}},"Full",{"$f":"Y118","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T71","v":"Resignations Received"},{"$f":"AD118","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!T166","v":"Resignations Received"},null,{"$f":"IF(V122=0,\"Resignations Received\",IF(ISERROR(MAX(V113:V117)),\"Please check your data\",IF(MAX(V113:V117)=0,\"Resignations Received\",\"Resignations Received Full - (\"&V118&\")  Partner (\"&V119&\")  Other (\"&V121&\")\")))","v":"Resignations Received"},null,null,null,null,null,null,null,{"$f":"IF(AD122=0,\"Resignations Received\",IF(ISERROR(MAX(AD113:AD117)),\"Please check your data\",IF(MAX(AD113:AD117)=0,\"Resignations Received\",\"Resignations Received Full - (\"&AD118&\")  Partner (\"&AD119&\")  Other (\"&AD121&\")\")))","v":"Resignations Received"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q113+S113","v":0},"Partner",{"$f":"Y119","v":0},null,{"$f":"AG119","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T72","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U72","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH72","v":"00:00:00"},{"$f":"IF(ISERROR(FIND(\"Full\",W113)),\"\",1)","v":""},{"$f":"IF(X113=\"P\",X113,\"\")","v":""},{"$f":"IF(V113=\"\",\"\",IF(RIGHT(W113,7)=\" - Full\",\"Full\",IF(RIGHT(W113,7)=\"Partner\",\"Partner\",\"Other\")))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T167","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U167","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH167","v":"00:00:00"},{"$f":"IF(ISERROR(FIND(\"Full\",AE113)),\"\",1)","v":""},{"$f":"IF(AF113=\"P\",AF113,\"\")","v":""},{"$f":"IF(AD113=\"\",\"\",IF(RIGHT(AE113,7)=\" - Full\",\"Full\",IF(RIGHT(AE113,7)=\"Partner\",\"Partner\",\"Other\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q114+S114","v":0},"Other",{"$f":"Y121","v":0},null,{"$f":"AG121","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T73","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U73","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH73","v":"00:00:00"},{"$f":"IF(ISERROR(FIND(\"Full\",W114)),\"\",1)","v":""},null,{"$f":"IF(V114=\"\",\"\",IF(RIGHT(W114,7)=\" - Full\",\"Full\",IF(RIGHT(W114,7)=\"Partner\",\"Partner\",\"Other\")))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T168","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U168","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH168","v":"00:00:00"},{"$f":"IF(ISERROR(FIND(\"Full\",AE114)),\"\",1)","v":""},null,{"$f":"IF(AD114=\"\",\"\",IF(RIGHT(AE114,7)=\" - Full\",\"Full\",IF(RIGHT(AE114,7)=\"Partner\",\"Partner\",\"Other\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T74","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U74","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH74","v":"00:00:00"},"",null,"",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T169","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U169","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH169","v":"00:00:00"},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T75","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U75","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH75","v":"00:00:00"},"",null,"",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T170","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U170","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH170","v":"00:00:00"},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T76","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U76","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH76","v":"00:00:00"},"",null,"",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T171","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U171","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH171","v":"00:00:00"},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y118=0,\"\",Y118)","v":""},"Full",null,{"$f":"COUNTIFS(AA113:AA117,\"Full\")","v":0},null,null,null,null,{"$f":"IF(AG118=0,\"\",AG118)","v":""},"Full",null,{"$f":"COUNTIFS(AI113:AI117,\"Full\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y119=0,\"\",Y119)","v":""},"Partner",null,{"$f":"COUNTIFS(AA113:AA117,\"Partner\")","v":0},null,null,null,null,{"$f":"IF(AG119=0,\"\",AG119)","v":""},"Partner",null,{"$f":"COUNTIFS(AI113:AI117,\"Partner\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Resgning members",null,{"$f":"Y118+Y119","v":0},null,null,null,null,"","Resgning members",null,{"$f":"AG118+AG119","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Others",null,{"$f":"COUNTIFS(AA113:AA117,\"Other\")","v":0},null,null,null,null,"","Others",null,{"$f":"COUNTIFS(AI113:AI117,\"Other\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V113:V117)),\"0\",MAX(V113:V117))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD113:AD117)),\"0\",MAX(AD113:AD117))","v":0},"Active Number of lines"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Financial members Transferred",{"$f":"Q125+S125","v":0},"Full",{"$f":"Y131","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T77","v":"Financial Members Transferred"},{"$f":"AG131","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T172","v":"Financial Members Transferred"},null,{"$f":"IF(V133=0,\"Financial Members Transferred\",IF(ISERROR(MAX(V126:V130)),\"Please check your data\",IF(MAX(V126:V130)=0,\"Financial Members Transferred\",\"Financial Members Transferred Full (\"&V131&\")  Other (\"&V132&\")\")))","v":"Financial Members Transferred"},null,null,null,null,null,null,null,{"$f":"IF(AD133=0,\"Financial Members Transferred\",IF(ISERROR(MAX(AD126:AD130)),\"Please check your data\",IF(MAX(AD126:AD130)=0,\"Financial Members Transferred\",\"Financial Members Transferred Full (\"&AD131&\")  Other (\"&AD132&\")\")))","v":"Financial Members Transferred"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q126+S126","v":0},"Other",{"$f":"Y132","v":0},null,{"$f":"AG132","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T78","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U78","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH78","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W126)),\"\",1)","v":""},{"$f":"IF(X126=\"D\",X126,\"\")","v":""},null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T173","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U173","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH173","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE126)),\"\",1)","v":""},{"$f":"IF(AF126=\"D\",AF126,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T79","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U79","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH79","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W127)),\"\",1)","v":""},{"$f":"IF(X127=\"D\",X127,\"\")","v":""},null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T174","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U174","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH174","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE127)),\"\",1)","v":""},{"$f":"IF(AF127=\"D\",AF127,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T80","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U80","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH80","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W128)),\"\",1)","v":""},"",null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T175","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U175","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH175","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE128)),\"\",1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T81","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U81","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH81","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W129)),\"\",1)","v":""},"",{"$f":"IF(V129=\"\",\"\",IF(W129=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T176","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U176","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH176","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE129)),\"\",1)","v":""},"",{"$f":"IF(AD129=\"\",\"\",IF(AE129=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T82","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U82","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH82","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W130)),\"\",1)","v":""},"",{"$f":"IF(V130=\"\",\"\",IF(W130=0,\"\",\"New\"))","v":""},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T177","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U177","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH177","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE130)),\"\",1)","v":""},"",{"$f":"IF(AD130=\"\",\"\",IF(AE130=0,\"\",\"New\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y131=0,\"\",Y131)","v":""},"Members Tx'd",null,{"$f":"COUNTIFS(Y126:Y130,1)","v":0},null,null,null,null,{"$f":"IF(AG131=0,\"\",AG131)","v":""},"Members Tx'd",null,{"$f":"COUNTIFS(AG126:AG130,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Others",null,{"$f":"V133-Y131","v":0},null,null,null,null,null,"Others",null,{"$f":"AD133-AG131","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V126:V130)),\"0\",MAX(V126:V130))","v":0},"Active Number of lines",null,{"$f":"V133-Y132-Y131","v":0},null,null,null,null,{"$f":"IF(ISERROR(MAX(AD126:AD130)),\"0\",MAX(AD126:AD130))","v":0},"Active Number of lines",null,{"$f":"AD133-AG132-AG131","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Restricted (WEM)",{"$f":"Q136+S136","v":0},"Existing",{"$f":"Y144","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T83","v":"Restricted Members WEM"},{"$f":"AG144","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T178","v":"Restricted Members WEM"},null,{"$f":"IF(V147=0,\"Restricted Members WEM\",IF(ISERROR(MAX(V137:V141)),\"Please check your data\",IF(MAX(V137:V141)=0,\"Restricted Members WEM\",\"Restricted Members WEM (\"&V144&\")  New (\"&V143&\")  Disc (\"&V142&\")\")))","v":"Restricted Members WEM"},null,null,null,null,null,null,null,{"$f":"IF(AD147=0,\"Restricted Members WEM\",IF(ISERROR(MAX(AD137:AD141)),\"Please check your data\",IF(MAX(AD137:AD141)=0,\"Restricted Members WEM\",\"Restricted Members WEM (\"&AD144&\")  New (\"&AD143&\")  Disc (\"&AD142&\")\")))","v":"Restricted Members WEM"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q137+S137","v":0},"New",{"$f":"Y143","v":0},null,{"$f":"AG143","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T84","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U84","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH84","v":0},{"$f":"IF(ISERROR(FIND(\"0\",W137)),\"\",1)","v":1},{"$f":"IF(X137=\"N\",\"N\",IF(X137=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(W137,4)=\"Club\",\"Club\",\"Other\")","v":"Other"},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T179","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U179","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH179","v":0},{"$f":"IF(ISERROR(FIND(\"0\",AE137)),\"\",1)","v":1},{"$f":"IF(AF137=\"N\",\"N\",IF(AF137=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(AE137,4)=\"Club\",\"Club\",\"Other\")","v":"Other"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q138+S138","v":0},"Discount",{"$f":"Y142","v":0},null,{"$f":"AG142","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T85","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U85","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH85","v":0},{"$f":"IF(ISERROR(FIND(\"0\",W138)),\"\",1)","v":1},{"$f":"IF(X138=\"N\",\"N\",IF(X138=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(W138,4)=\"Club\",\"Club\",\"Other\")","v":"Other"},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T180","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U180","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH180","v":0},{"$f":"IF(ISERROR(FIND(\"0\",AE138)),\"\",1)","v":1},{"$f":"IF(AF138=\"N\",\"N\",IF(AF138=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(AE138,4)=\"Club\",\"Club\",\"Other\")","v":"Other"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T86","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U86","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH86","v":0},1,"O","Other",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T181","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U181","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH181","v":0},1,"O","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T87","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U87","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH87","v":0},1,"O","Other",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T182","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U182","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH182","v":0},1,"O","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T88","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U88","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH88","v":0},1,"O","Other",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T183","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U183","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH183","v":0},1,"O","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y142=0,\"\",Y142)","v":""},"Discounted WEM",null,{"$f":"COUNTIFS(Z137:Z141,\"D\",AA137:AA141,\"Club\")","v":0},null,null,null,null,{"$f":"IF(AG142=0,\"\",AG142)","v":""},"Discounted WEM",null,{"$f":"COUNTIFS(AH137:AH141,\"D\",AI137:AI141,\"Club\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y143=0,\"\",Y143)","v":""},"New WEM",null,{"$f":"COUNTIFS(Z137:Z141,\"N\",AA137:AA141,\"Club\")","v":0},null,null,null,null,{"$f":"IF(AG143=0,\"\",AG143)","v":""},"New WEM",null,{"$f":"COUNTIFS(AH137:AH141,\"N\",AI137:AI141,\"Club\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y144=0,\"\",Y144)","v":""},"Existing WEM",null,{"$f":"COUNTIFS(Z137:Z141,\"O\",AA137:AA141,\"Club\")","v":0},null,null,null,null,{"$f":"IF(AG144=0,\"\",AG144)","v":""},"Existing WEM",null,{"$f":"COUNTIFS(AH137:AH141,\"O\",AI137:AI141,\"Club\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other enteries",null,{"$f":"COUNTIFS(Z137:Z141,\"O\",AA137:AA141,\"Other\",Y137:Y141,\"\")","v":0},null,null,null,null,null,"Other enteries",null,{"$f":"COUNTIFS(AH137:AH141,\"O\",AI137:AI141,\"Other\")","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error",null,{"$f":"COUNTIFS(Z137:Z141,\"O\",AA137:AA141,\"Other\",Y137:Y141,1)","v":5},null,null,null,null,null,"Error",null,{"$f":"COUNTIFS(AH137:AH141,\"O\",AI137:AI141,\"Other\",AG137:AG141,1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V137:V141)),\"0\",MAX(V137:V141))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD137:AD141)),\"0\",MAX(AD137:AD141))","v":0},"Active Number of lines"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 3 #1",null,null,null,null,null,null,null,"Form 3 #2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Overseas Members",{"$f":"Q150+S150","v":0},"Full Member",{"$f":"Y158","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T89","v":"Overseas Members"},{"$f":"AG158","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!T184","v":"Overseas Members"},null,{"$f":"IF(V160=0,\"Overseas Members\",IF(ISERROR(MAX(V151:V155)),\"Please check your data\",IF(MAX(V151:V155)=0,\"Overseas Members\",\"Overseas Members (\"&V158&\")  New (\"&V157&\")  Disc (\"&V156&\")\")))","v":"Overseas Members"},null,null,null,null,null,null,null,{"$f":"IF(AD160=0,\"Overseas Members\",IF(ISERROR(MAX(AD151:AD155)),\"Please check your data\",IF(MAX(AD151:AD155)=0,\"Overseas Members\",\"Overseas Members (\"&AD158&\")  New (\"&AD157&\")  Disc (\"&AD156&\")\")))","v":"Overseas Members"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q151+S151","v":0},"New Members",{"$f":"Y157","v":0},null,{"$f":"AG157","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T90","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U90","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH90","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W151)),\"\",1)","v":""},{"$f":"IF(X151=\"N\",\"N\",IF(X151=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(W151,4)=\"Full\",\"Full\",\"Other\")","v":"Other"},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T185","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U185","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH185","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE151)),\"\",1)","v":""},{"$f":"IF(AF151=\"N\",\"N\",IF(AF151=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(AE151,4)=\"Full\",\"Full\",\"Other\")","v":"Other"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q152+S152","v":0},"Discounted FM",{"$f":"Y156","v":0},null,{"$f":"AG156","v":0},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T91","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U91","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH91","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W152)),\"\",1)","v":""},{"$f":"IF(X152=\"N\",\"N\",IF(X152=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(W152,4)=\"Full\",\"Full\",\"Other\")","v":"Other"},null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T186","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U186","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH186","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE152)),\"\",1)","v":""},{"$f":"IF(AF152=\"N\",\"N\",IF(AF152=\"D\",\"D\",\"O\"))","v":"O"},{"$f":"IF(RIGHT(AE152,4)=\"Full\",\"Full\",\"Other\")","v":"Other"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T92","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U92","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH92","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W153)),\"\",1)","v":""},"O","Other",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T187","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U187","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH187","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE153)),\"\",1)","v":""},"O","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T93","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U93","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH93","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W154)),\"\",1)","v":""},"O","Other",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T188","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U188","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH188","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE154)),\"\",1)","v":""},"O","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T94","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U99","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH99","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",W155)),\"\",1)","v":""},"O","Other",null,null,{"$f":"'Auto Fill - F2A, F2B and F3'!T189","v":""},{"$f":"'Auto Fill - F2A, F2B and F3'!U189","v":0},{"$f":"'Auto Fill - F2A, F2B and F3'!AH189","v":0},{"$f":"IF(ISERROR(FIND(\"Full\",AE155)),\"\",1)","v":""},"O","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y156=0,\"\",Y156)","v":""},"Discounted",null,{"$f":"IF(ISERROR(MAX(V151:V155)),0,COUNTIFS(Z151:Z155,\"D\",AA151:AA155,\"Full\"))","v":0},{"$f":"IF(X150=\"P\",X150,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(W150,7)=\"Partner\",Z156=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(W150,7)=\" - Full\",Z156=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(W150,7)=\"Partner\",Z156<>\"P\"),\"UnPaid Partner\",\"\"),IF(AND(RIGHT(W150,7)=\" - Full\",Z156<>\"P\"),\"UnPaid Full\",\"\"))","v":""},null,null,{"$f":"IF(AG156=0,\"\",AG156)","v":""},"Discounted",null,{"$f":"IF(ISERROR(MAX(AD151:AD155)),0,COUNTIFS(AH151:AH155,\"D\",AI151:AI155,\"Full\"))","v":0},{"$f":"IF(AF150=\"P\",AF150,\"\")","v":""},{"$f":"_xlfn.CONCAT(IF(AND(RIGHT(AE150,7)=\"Partner\",AH156=\"P\"),\"Paid Partner\",\"\"),IF(AND(RIGHT(AE150,7)=\" - Full\",AH156=\"P\"),\"Paid Full\",\"\"),IF(AND(RIGHT(AE150,7)=\"Partner\",AH156<>\"P\"),\"UnPaid Partner\",\"\"),IF(AND(RIGHT(AE150,7)=\" - Full\",AH156<>\"P\"),\"UnPaid Full\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y157=0,\"\",Y157)","v":""},"New",null,{"$f":"IF(ISERROR(MAX(V151:V155)),0,COUNTIFS(Z151:Z155,\"N\",AA151:AA155,\"Full\"))","v":0},null,null,null,null,{"$f":"IF(AG157=0,\"\",AG157)","v":""},"New",null,{"$f":"IF(ISERROR(MAX(AD151:AD155)),0,COUNTIFS(AH151:AH155,\"N\",AI151:AI155,\"Full\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y158=0,\"\",Y158)","v":""},"Existing",null,{"$f":"IF(ISERROR(MAX(V151:V155)),0,COUNTIFS(Z151:Z155,\"O\",AA151:AA155,\"Full\"))","v":0},null,null,null,null,{"$f":"IF(AG158=0,\"\",AG158)","v":""},"Existing",null,{"$f":"IF(ISERROR(MAX(AD151:AD155)),0,COUNTIFS(AH151:AH155,\"O\",AI151:AI155,\"Full\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error",null,{"$f":"IF(ISERROR(MAX(V151:V155)),0,COUNTIFS(Z151:Z155,\"O\",AA151:AA155,\"Other\"))","v":5},null,null,null,null,null,"Error",null,{"$f":"IF(ISERROR(MAX(AD151:AD155)),0,COUNTIFS(AH151:AH155,\"O\",AI151:AI155,\"Other\"))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(V151:V155)),\"0\",MAX(V151:V155))","v":0},"Active Number of lines",null,null,null,null,null,null,{"$f":"IF(ISERROR(MAX(AD151:AD155)),\"0\",MAX(AD151:AD155))","v":0},"Active Number of lines"]