{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["2015 Dues Schedule","Projected 2016 Dues Schedule","2014 Dues Schedule","2013 Dues Schedule","Affiliate","2023","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"2015 Dues Schedule","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[12,0,12,12],[22,0,22,12],[10,0,10,12],[0,0,0,12],[1,0,1,12],[3,0,3,12],[21,0,21,12]]}
["2015 Dues Schedule"]
["One Time Application Fee and Membership dues must be paid at time of application - $200"]
["Maryland Office - REALTOR Fees"]
["PRIMARY MARYLAND REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",265,{"$f":"ROUNDUP(SUM(B6/12)*11,2)","v":242.92},{"$f":"ROUNDUP(SUM(B6/12)*10,2)","v":220.84},{"$f":"ROUNDUP(SUM(B6/12)*9,2)","v":198.75},{"$f":"ROUNDUP(SUM(B6/12)*8,0)","v":177},{"$f":"ROUNDUP(SUM(B6/12)*7,2)","v":154.59},{"$f":"ROUNDUP(SUM(B6/12)*6,2)","v":132.5},{"$f":"ROUNDUP(SUM(B6/12)*5,2)","v":110.42},{"$f":"ROUNDUP(SUM(B6/12)*4,2)","v":88.34},{"$f":"ROUNDUP(SUM(B6/12)*3,2)","v":66.25},{"$f":"ROUNDUP(SUM(B6/12)*2,2)","v":44.169999999999995},{"$f":"ROUNDUP(SUM(B6/12)*1,2)","v":22.09}]
["State MD",219,219,219,219,122,122,122,122,122,122,122,122]
["NAR Image Campaign Assessment",35,35,35,35,35,35,35,35,35,35,35,35]
["National",120,{"$f":"ROUNDUP(SUM((B9)/12)*11,2)","v":110},{"$f":"ROUNDUP(SUM((B9)/12)*10,2)","v":100},{"$f":"ROUNDUP(SUM((B9)/12)*9,2)","v":90},{"$f":"ROUNDUP(SUM((B9)/12)*8,2)","v":80},{"$f":"ROUNDUP(SUM((B9)/12)*7,2)","v":70},{"$f":"ROUNDUP(SUM((B9)/12)*6,2)","v":60},{"$f":"ROUNDUP(SUM((B9)/12)*5,2)","v":50},{"$f":"ROUNDUP(SUM((B9)/12)*4,2)","v":40},{"$f":"ROUNDUP(SUM((B9)/12)*3,2)","v":30},{"$f":"ROUNDUP(SUM((B9)/12)*2,2)","v":20},{"$f":"ROUNDUP(SUM((B9)/12)*1,2)","v":10}]
["Total MD",{"$f":" SUM(B6:B9)","v":639},{"$f":" SUM(C6:C9)","v":606.91999999999996},{"$f":" SUM(D6:D9)","v":574.84},542.75,414,381.59000000000003,349.5,317.42,285.34000000000003,253.25,221.17,189.09]
["The non-deductible portion of MAR 2015 dues attributive to lobbying is $46, the non-deductible portion of NAR 2015 dues is $44.00"]
["Pennsylvania Office - REALTOR Fees"]
["PRIMARY PENNSYLVANIA REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",265,{"$f":"ROUNDUP(SUM(B15/12)*11,2)","v":242.92},{"$f":"ROUNDUP(SUM(B15/12)*10,2)","v":220.84},{"$f":"ROUNDUP(SUM(B15/12)*9,2)","v":198.75},{"$f":"ROUNDUP(SUM(B15/12)*8,0)","v":177},{"$f":"ROUNDUP(SUM(B15/12)*7,2)","v":154.59},{"$f":"ROUNDUP(SUM(B15/12)*6,2)","v":132.5},{"$f":"ROUNDUP(SUM(B15/12)*5,2)","v":110.42},{"$f":"ROUNDUP(SUM(B15/12)*4,2)","v":88.34},{"$f":"ROUNDUP(SUM(B15/12)*3,2)","v":66.25},{"$f":"ROUNDUP(SUM(B15/12)*2,2)","v":44.169999999999995},{"$f":"ROUNDUP(SUM(B15/12)*1,2)","v":22.09}]
["State PA",130,{"$f":"ROUNDUP(SUM(B16/12)*11,2)","v":119.17},{"$f":"ROUNDUP(SUM(B16/12)*10,2)","v":108.34},{"$f":"ROUNDUP(SUM(B16/12)*9,2)","v":97.5},{"$f":"ROUNDUP(SUM(B16/12)*8,2)","v":86.67},{"$f":"ROUNDUP(SUM(B16/12)*7,2)","v":75.84},{"$f":"ROUNDUP(SUM(B16/12)*6,2)","v":65},{"$f":"ROUNDUP(SUM(B16/12)*5,2)","v":54.169999999999995},{"$f":"ROUNDUP(SUM(B16/12)*4,2)","v":43.339999999999996},{"$f":"ROUNDUP(SUM(B16/12)*3,2)","v":32.5},{"$f":"ROUNDUP(SUM(B16/12)*2,2)","v":21.67},{"$f":"ROUNDUP(SUM(B16/12)*1,2)","v":10.84}]
["NAR Image Campaign Assessment",35,35,35,35,35,35,35,35,35,35,35,35]
["National",120,{"$f":"ROUNDUP(SUM((B18)/12)*11,2)","v":110},{"$f":"ROUNDUP(SUM((B18)/12)*10,2)","v":100},{"$f":"ROUNDUP(SUM((B18)/12)*9,2)","v":90},{"$f":"ROUNDUP(SUM((B18)/12)*8,2)","v":80},{"$f":"ROUNDUP(SUM((B18)/12)*7,2)","v":70},{"$f":"ROUNDUP(SUM((B18)/12)*6,2)","v":60},{"$f":"ROUNDUP(SUM((B18)/12)*5,2)","v":50},{"$f":"ROUNDUP(SUM((B18)/12)*4,2)","v":40},{"$f":"ROUNDUP(SUM((B18)/12)*3,2)","v":30},{"$f":"ROUNDUP(SUM((B18)/12)*2,2)","v":20},{"$f":"ROUNDUP(SUM((B18)/12)*1,2)","v":10}]
["Sub-Total PA",{"$f":"SUM(B15:B18)","v":550},507.09,464.18,421.25,378.67,335.43,292.5,249.59,206.68,163.75,120.84,77.930000000000007]
["PAR Cap. Inv Fee for New Members Only",65,65,65,65,65,65,65,65,65,65,65,65]
["Total PA",{"$f":"SUM(B19+B20)","v":615},572.08999999999992,529.18000000000006,486.25,443.67,400.43,357.5,314.59000000000003,271.68,228.75,185.84,142.93]
["The non-deductible portion of PAR 2015 dues attributive to lobbying is $11.00, the non-deductible portion of NAR 2015 dues is $44.00"]
["SECONDARY REALTOR MEMBERSHIP DUES SCHEDULE"]
["Pen-Mar Secondary Membership without SentriLock Card Service"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",215,{"$f":"ROUNDUP(SUM(B26/12)*11,2)","v":197.09},{"$f":"ROUNDUP(SUM(B26/12)*10,2)","v":179.17},{"$f":"ROUNDUP(SUM(B26/12)*9,2)","v":161.25},{"$f":"ROUNDUP(SUM(B26/12)*8,0)","v":144},{"$f":"ROUNDUP(SUM(B26/12)*7,2)","v":125.42},{"$f":"ROUNDUP(SUM(B26/12)*6,2)","v":107.5},{"$f":"ROUNDUP(SUM(B26/12)*5,2)","v":89.59},{"$f":"ROUNDUP(SUM(B26/12)*4,2)","v":71.67},{"$f":"ROUNDUP(SUM(B26/12)*3,2)","v":53.75},{"$f":"ROUNDUP(SUM(B26/12)*2,2)","v":35.839999999999996},{"$f":"ROUNDUP(SUM(B26/12)*1,2)","v":17.920000000000002}]
[]
["Pen-Mar Secondary Membership  with SentriLock Card Service"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",265,{"$f":"ROUNDUP(SUM(B30/12)*11,2)","v":242.92},{"$f":"ROUNDUP(SUM(B30/12)*10,2)","v":220.84},{"$f":"ROUNDUP(SUM(B30/12)*9,2)","v":198.75},{"$f":"ROUNDUP(SUM(B30/12)*8,0)","v":177},{"$f":"ROUNDUP(SUM(B30/12)*7,2)","v":154.59},{"$f":"ROUNDUP(SUM(B30/12)*6,2)","v":132.5},{"$f":"ROUNDUP(SUM(B30/12)*5,2)","v":110.42},{"$f":"ROUNDUP(SUM(B30/12)*4,2)","v":88.34},{"$f":"ROUNDUP(SUM(B30/12)*3,2)","v":66.25},{"$f":"ROUNDUP(SUM(B30/12)*2,2)","v":44.169999999999995},{"$f":"ROUNDUP(SUM(B30/12)*1,2)","v":22.09}]
[]
["Secondary State Membership"]
["PAR Secondary",130,{"$f":"ROUNDUP(SUM(B33/12)*11,2)","v":119.17},{"$f":"ROUNDUP(SUM(B33/12)*10,2)","v":108.34},{"$f":"ROUNDUP(SUM(B33/12)*9,2)","v":97.5},{"$f":"ROUNDUP(SUM(B33/12)*8,2)","v":86.67},{"$f":"ROUNDUP(SUM(B33/12)*7,2)","v":75.84},{"$f":"ROUNDUP(SUM(B33/12)*6,2)","v":65},{"$f":"ROUNDUP(SUM(B33/12)*5,2)","v":54.169999999999995},{"$f":"ROUNDUP(SUM(B33/12)*4,2)","v":43.339999999999996},{"$f":"ROUNDUP(SUM(B33/12)*3,2)","v":32.5},{"$f":"ROUNDUP(SUM(B33/12)*2,2)","v":21.67},{"$f":"ROUNDUP(SUM(B33/12)*1,2)","v":10.84}]
["MAR Secondary",136,{"$f":"B34","v":136},{"$f":"B34","v":136},{"$f":"B34","v":136},80.5,80.5,80.5,80.5,80.5,80.5,80.5,80.5]
[]
["SentriLock Lockbox Service (optional)"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["SentriLock Lockbox Service",125,{"$f":"ROUNDUP(SUM(B38/12)*11,2)","v":114.59},{"$f":"ROUNDUP(SUM(B38/12)*10,2)","v":104.17},{"$f":"ROUNDUP(SUM(B38/12)*9,2)","v":93.75},{"$f":"ROUNDUP(SUM(B38/12)*8,0)","v":84},{"$f":"ROUNDUP(SUM(B38/12)*7,2)","v":72.92},{"$f":"ROUNDUP(SUM(B38/12)*6,2)","v":62.5},{"$f":"ROUNDUP(SUM(B38/12)*5,2)","v":52.089999999999996},{"$f":"ROUNDUP(SUM(B38/12)*4,2)","v":41.669999999999995},{"$f":"ROUNDUP(SUM(B38/12)*3,2)","v":31.25},{"$f":"ROUNDUP(SUM(B38/12)*2,2)","v":20.84},{"$f":"ROUNDUP(SUM(B38/12)*1,2)","v":10.42}]
[]
["NOTE: The application fee is a one-time fee unless you drop membership for over one year.  ",{"$nulls":6},"New Firm Fee: (one time fee)",null,null,350]
["       Reinstatement fee of $100.00 is applied for  after 30 days from termination of membership up to one year.",{"$nulls":6},"New Branch Fee: (one time fee)",null,null,100]
["        Primary State Membership is determined by the state in which office is located. ",{"$nulls":6},"Member/Office License Change Fee",null,null,10]
[null,"If PA license hangs with office located in MD, State Membership would be Maryland and visa versa."]
["revised: Oct 27, 2014"]

{"sheet":"Projected 2016 Dues Schedule","index":1,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[22,0,22,12],[0,0,0,12],[1,0,1,12],[3,0,3,12],[10,0,10,12],[12,0,12,12],[21,0,21,12]]}
["2017 Dues Schedule"]
["One Time Application Fee and Membership dues must be paid at time of application - $250"]
["Maryland Office - REALTOR Fees"]
["PRIMARY MARYLAND REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",305,279.58,254.17,228.75,203.33,177.92,152.5,127.08,101.67,76.25,50.83,25.42]
["State MD",227,227,227,227,126,126,126,126,126,126,126,126]
["NAR Image Campaign Assessment",35,35,35,35,35,35,35,35,35,35,35,35]
["National",120,{"$f":"ROUNDUP(SUM((B9)/12)*11,2)","v":110},{"$f":"ROUNDUP(SUM((B9)/12)*10,2)","v":100},{"$f":"ROUNDUP(SUM((B9)/12)*9,2)","v":90},{"$f":"ROUNDUP(SUM((B9)/12)*8,2)","v":80},{"$f":"ROUNDUP(SUM((B9)/12)*7,2)","v":70},{"$f":"ROUNDUP(SUM((B9)/12)*6,2)","v":60},{"$f":"ROUNDUP(SUM((B9)/12)*5,2)","v":50},{"$f":"ROUNDUP(SUM((B9)/12)*4,2)","v":40},{"$f":"ROUNDUP(SUM((B9)/12)*3,2)","v":30},{"$f":"ROUNDUP(SUM((B9)/12)*2,2)","v":20},{"$f":"ROUNDUP(SUM((B9)/12)*1,2)","v":10}]
["Total MD",{"$f":" SUM(B6:B9)","v":687},{"$f":" SUM(C6:C9)","v":651.57999999999993},{"$f":" SUM(D6:D9)","v":616.16999999999996},580.75,444.33000000000004,408.91999999999996,373.5,338.08,302.67,267.25,231.82999999999998,196.42000000000002]
["The non-deductible portion of MAR 2016 dues attributive to lobbying is $45, the non-deductible portion on NAR 2017 dues is $50"]
["Pennsylvania Office - REALTOR Fees"]
["PRIMARY PENNSYLVANIA REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",305,279.58,254.17,228.75,203.33,177.92,152.5,127.08,101.67,76.25,50.83,25.42]
["State PA",130,{"$f":"ROUNDUP(SUM(B16/12)*11,2)","v":119.17},{"$f":"ROUNDUP(SUM(B16/12)*10,2)","v":108.34},{"$f":"ROUNDUP(SUM(B16/12)*9,2)","v":97.5},{"$f":"ROUNDUP(SUM(B16/12)*8,2)","v":86.67},{"$f":"ROUNDUP(SUM(B16/12)*7,2)","v":75.84},{"$f":"ROUNDUP(SUM(B16/12)*6,2)","v":65},{"$f":"ROUNDUP(SUM(B16/12)*5,2)","v":54.169999999999995},{"$f":"ROUNDUP(SUM(B16/12)*4,2)","v":43.339999999999996},{"$f":"ROUNDUP(SUM(B16/12)*3,2)","v":32.5},{"$f":"ROUNDUP(SUM(B16/12)*2,2)","v":21.67},{"$f":"ROUNDUP(SUM(B16/12)*1,2)","v":10.84}]
["NAR Image Campaign Assessment",35,35,35,35,35,35,35,35,35,35,35,35]
["National",120,{"$f":"ROUNDUP(SUM((B18)/12)*11,2)","v":110},{"$f":"ROUNDUP(SUM((B18)/12)*10,2)","v":100},{"$f":"ROUNDUP(SUM((B18)/12)*9,2)","v":90},{"$f":"ROUNDUP(SUM((B18)/12)*8,2)","v":80},{"$f":"ROUNDUP(SUM((B18)/12)*7,2)","v":70},{"$f":"ROUNDUP(SUM((B18)/12)*6,2)","v":60},{"$f":"ROUNDUP(SUM((B18)/12)*5,2)","v":50},{"$f":"ROUNDUP(SUM((B18)/12)*4,2)","v":40},{"$f":"ROUNDUP(SUM((B18)/12)*3,2)","v":30},{"$f":"ROUNDUP(SUM((B18)/12)*2,2)","v":20},{"$f":"ROUNDUP(SUM((B18)/12)*1,2)","v":10}]
["Sub-Total PA",{"$f":"SUM(B15:B18)","v":590},543.75,497.51,451.25,405,358.76,312.5,266.25,220.01,173.75,127.5,81.260000000000005]
["PAR Cap. Inv Fee for New Members Only",65,65,65,65,65,65,65,65,65,65,65,65]
["Total PA",{"$f":"SUM(B19+B20)","v":655},608.75,562.51,516.25,470,423.76,377.5,331.25,285.01,238.75,192.5,146.26]
["The non-deductible portion of PAR 2016 dues attributive to lobbying is $11.00, the non-deductible portion of NAR 2016 dues is $50"]
["SECONDARY REALTOR MEMBERSHIP DUES SCHEDULE"]
["Pen-Mar Secondary Membership without SentriLock Card Service"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",255,233.75,212.5,191.25,170,148.75,127.5,106.25,85,63.75,42.5,{"$f":"ROUNDUP(SUM(B26/12)*1,2)","v":21.25}]
[]
["Pen-Mar Secondary Membership  with SentriLock Card Service"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",305,279.58,254.17,228.75,203.33,177.92,152.5,127.08,101.67,76.25,50.83,25.42]
[]
["Secondary State Membership"]
["PAR Secondary",130,{"$f":"ROUNDUP(SUM(B33/12)*11,2)","v":119.17},{"$f":"ROUNDUP(SUM(B33/12)*10,2)","v":108.34},{"$f":"ROUNDUP(SUM(B33/12)*9,2)","v":97.5},{"$f":"ROUNDUP(SUM(B33/12)*8,2)","v":86.67},{"$f":"ROUNDUP(SUM(B33/12)*7,2)","v":75.84},{"$f":"ROUNDUP(SUM(B33/12)*6,2)","v":65},{"$f":"ROUNDUP(SUM(B33/12)*5,2)","v":54.169999999999995},{"$f":"ROUNDUP(SUM(B33/12)*4,2)","v":43.339999999999996},{"$f":"ROUNDUP(SUM(B33/12)*3,2)","v":32.5},{"$f":"ROUNDUP(SUM(B33/12)*2,2)","v":21.67},{"$f":"ROUNDUP(SUM(B33/12)*1,2)","v":10.84}]
["MAR Secondary",140,140,{"$f":"B34","v":140},{"$f":"B34","v":140},82.5,82.5,82.5,82.5,82.5,82.5,82.5,82.5]
[]
["NOTE: The application fee is a one-time fee unless you drop membership for over one year.  ",{"$nulls":6},"New Firm Fee: (one time fee)",null,null,350]
["       Reinstatement fee of $100.00 is applied for  after 30 days from termination of membership up to one year.",{"$nulls":6},"New Branch Fee: (one time fee)",null,null,100]
["        Primary State Membership is determined by the state in which office is located. ",{"$nulls":6},"Member/Office License Change Fee",null,null,20]
[null,"If PA license hangs with office located in MD, State Membership would be Maryland and visa versa."]
["revised: July 29, 2016"]

{"sheet":"2014 Dues Schedule","index":2,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,0,22,12],[0,0,0,12],[1,0,1,12],[3,0,3,12],[10,0,10,12],[12,0,12,12],[21,0,21,12]]}
["2014 Dues Schedule"]
["One Time Application Fee and Membership dues must be paid at time of application - $160"]
["Maryland Office - REALTOR Fees"]
["PRIMARY MARYLAND REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B6/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B6/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B6/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B6/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B6/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B6/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B6/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B6/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B6/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B6/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B6/12)*1,2)","v":16.25}]
["State MD",215,215,215,215,120,120,120,120,120,120,120,120]
["NAR Image Campaign Assessment",35,35,35,35,35,35,35,35,35,35,35,35]
["National",120,{"$f":"ROUNDUP(SUM((B9)/12)*11,2)","v":110},{"$f":"ROUNDUP(SUM((B9)/12)*10,2)","v":100},{"$f":"ROUNDUP(SUM((B9)/12)*9,2)","v":90},{"$f":"ROUNDUP(SUM((B9)/12)*8,2)","v":80},{"$f":"ROUNDUP(SUM((B9)/12)*7,2)","v":70},{"$f":"ROUNDUP(SUM((B9)/12)*6,2)","v":60},{"$f":"ROUNDUP(SUM((B9)/12)*5,2)","v":50},{"$f":"ROUNDUP(SUM((B9)/12)*4,2)","v":40},{"$f":"ROUNDUP(SUM((B9)/12)*3,2)","v":30},{"$f":"ROUNDUP(SUM((B9)/12)*2,2)","v":20},{"$f":"ROUNDUP(SUM((B9)/12)*1,2)","v":10}]
["Total MD",{"$f":" SUM(B6:B9)","v":565},{"$f":" SUM(C6:C9)","v":538.75},{"$f":" SUM(D6:D9)","v":512.5},486.25,365,338.75,312.5,286.25,260,233.75,207.5,181.25]
["The non-deductible portion of MAR 2014 dues attributive to lobbying is $46."]
["Pennsylvania Office - REALTOR Fees"]
["PRIMARY PENNSYLVANIA REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B15/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B15/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B15/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B15/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B15/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B15/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B15/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B15/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B15/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B15/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B15/12)*1,2)","v":16.25}]
["State PA",130,{"$f":"ROUNDUP(SUM(B16/12)*11,2)","v":119.17},{"$f":"ROUNDUP(SUM(B16/12)*10,2)","v":108.34},{"$f":"ROUNDUP(SUM(B16/12)*9,2)","v":97.5},{"$f":"ROUNDUP(SUM(B16/12)*8,2)","v":86.67},{"$f":"ROUNDUP(SUM(B16/12)*7,2)","v":75.84},{"$f":"ROUNDUP(SUM(B16/12)*6,2)","v":65},{"$f":"ROUNDUP(SUM(B16/12)*5,2)","v":54.169999999999995},{"$f":"ROUNDUP(SUM(B16/12)*4,2)","v":43.339999999999996},{"$f":"ROUNDUP(SUM(B16/12)*3,2)","v":32.5},{"$f":"ROUNDUP(SUM(B16/12)*2,2)","v":21.67},{"$f":"ROUNDUP(SUM(B16/12)*1,2)","v":10.84}]
["NAR Image Campaign Assessment",35,35,35,35,35,35,35,35,35,35,35,35]
["National",120,{"$f":"ROUNDUP(SUM((B18)/12)*11,2)","v":110},{"$f":"ROUNDUP(SUM((B18)/12)*10,2)","v":100},{"$f":"ROUNDUP(SUM((B18)/12)*9,2)","v":90},{"$f":"ROUNDUP(SUM((B18)/12)*8,2)","v":80},{"$f":"ROUNDUP(SUM((B18)/12)*7,2)","v":70},{"$f":"ROUNDUP(SUM((B18)/12)*6,2)","v":60},{"$f":"ROUNDUP(SUM((B18)/12)*5,2)","v":50},{"$f":"ROUNDUP(SUM((B18)/12)*4,2)","v":40},{"$f":"ROUNDUP(SUM((B18)/12)*3,2)","v":30},{"$f":"ROUNDUP(SUM((B18)/12)*2,2)","v":20},{"$f":"ROUNDUP(SUM((B18)/12)*1,2)","v":10}]
["Sub-Total PA",{"$f":"SUM(B15:B18)","v":480},442.92,405.84000000000003,368.75,331.67,294.59000000000003,257.5,220.42,183.34,146.25,109.17,72.09]
["PAR Cap. Inv Fee for New Members Only",65,65,65,65,65,65,65,65,65,65,65,65]
["Total PA",{"$f":"SUM(B19+B20)","v":545},507.92,470.84000000000003,433.75,396.67,359.59000000000003,322.5,285.41999999999996,248.34,211.25,174.17000000000002,137.09]
["The non-deductible portion of PAR 2014 dues attributive to lobbying is $11.00"]
["SECONDARY REALTOR MEMBERSHIP DUES SCHEDULE"]
["Pen-Mar Secondary Membership"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B26/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B26/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B26/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B26/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B26/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B26/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B26/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B26/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B26/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B26/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B26/12)*1,2)","v":16.25}]
[]
["Secondary State Membership"]
["PAR Secondary",130,{"$f":"ROUNDUP(SUM(B29/12)*11,2)","v":119.17},{"$f":"ROUNDUP(SUM(B29/12)*10,2)","v":108.34},{"$f":"ROUNDUP(SUM(B29/12)*9,2)","v":97.5},{"$f":"ROUNDUP(SUM(B29/12)*8,2)","v":86.67},{"$f":"ROUNDUP(SUM(B29/12)*7,2)","v":75.84},{"$f":"ROUNDUP(SUM(B29/12)*6,2)","v":65},{"$f":"ROUNDUP(SUM(B29/12)*5,2)","v":54.169999999999995},{"$f":"ROUNDUP(SUM(B29/12)*4,2)","v":43.339999999999996},{"$f":"ROUNDUP(SUM(B29/12)*3,2)","v":32.5},{"$f":"ROUNDUP(SUM(B29/12)*2,2)","v":21.67},{"$f":"ROUNDUP(SUM(B29/12)*1,2)","v":10.84}]
["MAR Secondary",134,{"$f":"B30","v":134},{"$f":"B30","v":134},{"$f":"B30","v":134},79.5,79.5,79.5,79.5,79.5,79.5,79.5,79.5]
[]
["NOTE: The application fee is a one-time fee unless you drop membership for over one year.  ",{"$nulls":6},"New Firm Fee: (one time fee)",null,null,350]
["       Reinstatement fee of $80.00 is applied for  after 30 days from termination of membership up to one year.",{"$nulls":6},"New Branch Fee: (one time fee)",null,null,100]
["        Primary State Membership is determined by the state in which office is located. ",{"$nulls":6},"Member/Office License Change Fee",null,null,10]
[null,"If PA license hangs with office located in MD, State Membership would be Maryland and visa versa."]
["revised: March 2014"]

{"sheet":"2013 Dues Schedule","index":3,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,0,38,12],[7,0,7,12],[14,0,14,12],[1,0,1,12],[9,0,9,12],[16,0,16,12],[27,0,27,12]]}
[{"$nulls":5},2013]
["PRIMARY MARYLAND REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B4/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B4/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B4/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B4/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B4/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B4/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B4/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B4/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B4/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B4/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B4/12)*1,2)","v":16.25}]
["State MD",181,{"$f":"B5","v":181},{"$f":"B5","v":181},{"$f":"B5","v":181},{"$f":"ROUNDUP(SUM(B5/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B5/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B5/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B5/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B5/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B5/2),2)","v":90.5},0,0]
["National",{"$f":"SUM(120+35)","v":155},{"$f":"ROUNDUP(SUM((B6-35)/12)*11,2)+35","v":145},{"$f":"ROUNDUP(SUM((B6-35)/12)*10,2)+35","v":135},{"$f":"ROUNDUP(SUM((B6-35)/12)*9,2)+35","v":125},{"$f":"ROUNDUP(SUM((B6-35)/12)*8,2)+35","v":115},{"$f":"ROUNDUP(SUM((B6-35)/12)*7,2)+35","v":105},{"$f":"ROUNDUP(SUM((B6-35)/12)*6,2)+35","v":95},{"$f":"ROUNDUP(SUM((B6-35)/12)*5,2)+35","v":85},{"$f":"ROUNDUP(SUM((B6-35)/12)*4,2)+35","v":75},{"$f":"ROUNDUP(SUM((B6-35)/12)*3,2)+35","v":65},{"$f":"ROUNDUP(SUM((B6-35)/12)*2,2)+35","v":55},{"$f":"ROUNDUP(SUM((B6-35)/12)*1,2)+35","v":45}]
["Total MD",{"$f":" SUM(B4+B5+B6)","v":531},504.75,478.5,452.25,335.5,309.25,283,256.75,230.5,204.25,87.5,61.25]
["Primary Members can join the PA Association as Secondary State Member for $105"]
[]
["PRIMARY PENNSYLVANIA REALTOR MEMBERSHIP DUES SCHEDULE"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B11/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B11/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B11/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B11/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B11/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B11/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B11/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B11/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B11/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B11/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B11/12)*1,2)","v":16.25}]
["State PA",105,{"$f":"ROUNDUP(SUM(B12/12)*11,2)","v":96.25},{"$f":"ROUNDUP(SUM(B12/12)*10,2)","v":87.5},{"$f":"ROUNDUP(SUM(B12/12)*9,2)","v":78.75},{"$f":"ROUNDUP(SUM(B12/12)*8,2)","v":70},{"$f":"ROUNDUP(SUM(B12/12)*7,2)","v":61.25},{"$f":"ROUNDUP(SUM(B12/12)*6,2)","v":52.5},{"$f":"ROUNDUP(SUM(B12/12)*5,2)","v":43.75},{"$f":"ROUNDUP(SUM(B12/12)*4,2)","v":35},{"$f":"ROUNDUP(SUM(B12/12)*3,2)","v":26.25},{"$f":"ROUNDUP(SUM(B12/12)*2,2)","v":17.5},{"$f":"ROUNDUP(SUM(B12/12)*1,2)","v":8.75}]
["National",{"$f":"SUM(120+35)","v":155},{"$f":"ROUNDUP(SUM((B13-35)/12)*11,2)+35","v":145},{"$f":"ROUNDUP(SUM((B13-35)/12)*10,2)+35","v":135},{"$f":"ROUNDUP(SUM((B13-35)/12)*9,2)+35","v":125},{"$f":"ROUNDUP(SUM((B13-35)/12)*8,2)+35","v":115},{"$f":"ROUNDUP(SUM((B13-35)/12)*7,2)+35","v":105},{"$f":"ROUNDUP(SUM((B13-35)/12)*6,2)+35","v":95},{"$f":"ROUNDUP(SUM((B13-35)/12)*5,2)+35","v":85},{"$f":"ROUNDUP(SUM((B13-35)/12)*4,2)+35","v":75},{"$f":"ROUNDUP(SUM((B13-35)/12)*3,2)+35","v":65},{"$f":"ROUNDUP(SUM((B13-35)/12)*2,2)+35","v":55},{"$f":"ROUNDUP(SUM((B13-35)/12)*1,2)+35","v":45}]
["Total PA",{"$f":"SUM(B11:B13)","v":455},{"$f":"SUM(C11:C13)","v":420},385,350,315,280,245,210,175,140,105,70]
["Primary Members can join the MD Association as Secondary State Member for $105."]
[]
["SECONDARY OUT-OF-STATE REALTOR MEMBERSHIP DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B19/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B19/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B19/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B19/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B19/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B19/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B19/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B19/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B19/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B19/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B19/12)*1,2)","v":16.25}]
["State MD",105,{"$f":"B20","v":105},{"$f":"B20","v":105},{"$f":"B20","v":105},{"$f":"ROUNDUP(SUM(B20/2),2)","v":52.5},{"$f":"ROUNDUP(SUM(B20/2),2)","v":52.5},{"$f":"ROUNDUP(SUM(B20/2),2)","v":52.5},{"$f":"ROUNDUP(SUM(B20/2),2)","v":52.5},{"$f":"ROUNDUP(SUM(B20/2),2)","v":52.5},{"$f":"ROUNDUP(SUM(B20/2),2)","v":52.5},0,0]
["Total MD",{"$f":"SUM(B19:B20)","v":300},{"$f":"SUM(C19:C20)","v":283.75},267.5,251.25,182.5,166.25,150,133.75,117.5,101.25,32.5,16.25]
[]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B24/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B24/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B24/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B24/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B24/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B24/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B24/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B24/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B24/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B24/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B24/12)*1,2)","v":16.25}]
["State PA",105,{"$f":"ROUNDUP(SUM(B25/12)*11,2)","v":96.25},{"$f":"ROUNDUP(SUM(B25/12)*10,2)","v":87.5},{"$f":"ROUNDUP(SUM(B25/12)*9,2)","v":78.75},{"$f":"ROUNDUP(SUM(B25/12)*8,2)","v":70},{"$f":"ROUNDUP(SUM(B25/12)*7,2)","v":61.25},{"$f":"ROUNDUP(SUM(B25/12)*6,2)","v":52.5},{"$f":"ROUNDUP(SUM(B25/12)*5,2)","v":43.75},{"$f":"ROUNDUP(SUM(B25/12)*4,2)","v":35},{"$f":"ROUNDUP(SUM(B25/12)*3,2)","v":26.25},{"$f":"ROUNDUP(SUM(B25/12)*2,2)","v":17.5},{"$f":"ROUNDUP(SUM(B25/12)*1,2)","v":8.75}]
["Total PA",{"$f":"SUM(B24:B25)","v":300},{"$f":"SUM(C24:C25)","v":275},250,225,200,175,150,125,100,75,50,25]
[]
["PRIMARY AFFILIATE (not required to join state)"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B30/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B30/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B30/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B30/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B30/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B30/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B30/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B30/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B30/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B30/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B30/12)*1,2)","v":16.25}]
["State MD",181,{"$f":"B31","v":181},{"$f":"B31","v":181},{"$f":"B31","v":181},{"$f":"ROUNDUP(SUM(B31/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B31/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B31/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B31/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B31/2),2)","v":90.5},{"$f":"ROUNDUP(SUM(B31/2),2)","v":90.5},0,0]
["Total MD",{"$f":"SUM(B30+B31)","v":376},359.75,343.5,327.25,220.5,204.25,188,171.75,155.5,139.25,32.5,16.25]
[]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["LOCAL",195,{"$f":"ROUNDUP(SUM(B35/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B35/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B35/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B35/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B35/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B35/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B35/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B35/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B35/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B35/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B35/12)*1,2)","v":16.25}]
["State PA",60,{"$f":"B36","v":60},{"$f":"C36","v":60},60,60,60,60,60,60,60,60,60]
["Total PA",{"$f":"SUM(B35:B36)","v":255},{"$f":"SUM(C35:C36)","v":238.75},222.5,206.25,190,173.75,157.5,141.25,125,108.75,92.5,76.25]
[]
["Primary Affiliates have the option not to belong to State; however, PMRAR encourages Affiliates to join the State to receive their benefits as well."]
[]
["Reinstatement fee of $80.00 is applied for  after 30 days from termination of membership up to one year."]
["One Time Application Fee: (Membership dues must be paid at time of submittal of application)",{"$nulls":11},160]
[null,"NOTE: The application fee is a one-time fee unless you drop membership for over one year.  "]
["Firm Fee: (one time fee)",{"$nulls":11},350]
["Branch Fee: (one time fee)",{"$nulls":11},100]
["Member/Office License Change Fee",{"$nulls":11},10]
[]
["Brokers Assessment of non-members: For those agents joining a “REALTOR” member office, "]
["who do not join the Association, an assessment is due from the Broker and must be paid as soon as that agent joins the office. "]
["A non-member is not permitted to use the term REALTOR, the “R” logo or receive any of the benefits from any of the REALTOR Associations. "]
["An assessment is equal to a REALTOR member's dues at the time the non-member should have been added to the roster."]

{"sheet":"Affiliate","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,12],[9,0,9,12]]}
["INDIVIDUAL AFFILIATE MEMBERS BENEFIT PRICING"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["Bronze",195,{"$f":"ROUNDUP(SUM(B3/12)*11,2)","v":178.75},{"$f":"ROUNDUP(SUM(B3/12)*10,2)","v":162.5},{"$f":"ROUNDUP(SUM(B3/12)*9,2)","v":146.25},{"$f":"ROUNDUP(SUM(B3/12)*8,0)","v":130},{"$f":"ROUNDUP(SUM(B3/12)*7,2)","v":113.75},{"$f":"ROUNDUP(SUM(B3/12)*6,2)","v":97.5},{"$f":"ROUNDUP(SUM(B3/12)*5,2)","v":81.25},{"$f":"ROUNDUP(SUM(B3/12)*4,2)","v":65},{"$f":"ROUNDUP(SUM(B3/12)*3,2)","v":48.75},{"$f":"ROUNDUP(SUM(B3/12)*2,2)","v":32.5},{"$f":"ROUNDUP(SUM(B3/12)*1,2)","v":16.25}]
["Silver",350,320.83999999999997,291.67,262.5,234,204.17,175,145.84,116.67,87.5,58.339999999999996,29.17]
["Gold",500,458.34,416.67,375,334,291.67,250,208.34,166.67,125,83.34,41.669999999999995]
["Platinum",1000,{"$f":"ROUNDUP(SUM(B6/12)*11,2)","v":916.67},{"$f":"ROUNDUP(SUM(B6/12)*10,2)","v":833.34},{"$f":"ROUNDUP(SUM(B6/12)*9,2)","v":750},{"$f":"ROUNDUP(SUM(B6/12)*8,0)","v":667},{"$f":"ROUNDUP(SUM(B6/12)*7,2)","v":583.34},{"$f":"ROUNDUP(SUM(B6/12)*6,2)","v":500},{"$f":"ROUNDUP(SUM(B6/12)*5,2)","v":416.67},{"$f":"ROUNDUP(SUM(B6/12)*4,2)","v":333.34},{"$f":"ROUNDUP(SUM(B6/12)*3,2)","v":250},{"$f":"ROUNDUP(SUM(B6/12)*2,2)","v":166.67},{"$f":"ROUNDUP(SUM(B6/12)*1,2)","v":83.34}]
[]
["Optional State Membership  MAR"]
[]
["CORPORATE AFFILIATE MEMBERS BENEFIT PRICING"]
[null,"Jan","Feb","March","April","May","June","July","August","Sept","October","Nov","Dec"]
["Bronze",350,{"$f":"ROUNDUP(SUM(B12/12)*11,2)","v":320.83999999999997},{"$f":"ROUNDUP(SUM(B12/12)*10,2)","v":291.67},{"$f":"ROUNDUP(SUM(B12/12)*9,2)","v":262.5},{"$f":"ROUNDUP(SUM(B12/12)*8,0)","v":234},{"$f":"ROUNDUP(SUM(B12/12)*7,2)","v":204.17},{"$f":"ROUNDUP(SUM(B12/12)*6,2)","v":175},{"$f":"ROUNDUP(SUM(B12/12)*5,2)","v":145.84},{"$f":"ROUNDUP(SUM(B12/12)*4,2)","v":116.67},{"$f":"ROUNDUP(SUM(B12/12)*3,2)","v":87.5},{"$f":"ROUNDUP(SUM(B12/12)*2,2)","v":58.339999999999996},{"$f":"ROUNDUP(SUM(B12/12)*1,2)","v":29.17}]
["Silver",750,687.5,625,562.5,500,437.5,375,312.5,250,187.5,125,62.5]
["Gold",1000,916.67,833.34,750,667,583.34,500,416.67,333.34,250,166.67,83.34]
["Platinum",1500,{"$f":"ROUNDUP(SUM(B15/12)*11,2)","v":1375},{"$f":"ROUNDUP(SUM(B15/12)*10,2)","v":1250},{"$f":"ROUNDUP(SUM(B15/12)*9,2)","v":1125},{"$f":"ROUNDUP(SUM(B15/12)*8,0)","v":1000},{"$f":"ROUNDUP(SUM(B15/12)*7,2)","v":875},{"$f":"ROUNDUP(SUM(B15/12)*6,2)","v":750},{"$f":"ROUNDUP(SUM(B15/12)*5,2)","v":625},{"$f":"ROUNDUP(SUM(B15/12)*4,2)","v":500},{"$f":"ROUNDUP(SUM(B15/12)*3,2)","v":375},{"$f":"ROUNDUP(SUM(B15/12)*2,2)","v":250},{"$f":"ROUNDUP(SUM(B15/12)*1,2)","v":125}]
[]
["Optional State Membership  PAR",60]

{"sheet":"2023","index":5,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,0,25,12],[0,0,0,12],[1,0,1,12],[4,0,4,12],[11,0,11,12],[14,0,14,12],[23,0,23,12]]}
["2024 Dues Schedule"]
[" ~ An application fee of $250 must be paid along with REALTOR® membership dues, at the time of application ~"]
[]
["Maryland - Prorated REALTOR® Dues Fees (for those primarily licensed in MD)"]
["PRIMARY MARYLAND REALTOR® MEMBERSHIP PRORATED DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec"]
["Local (Pen-Mar) Dues",360,330,300,270,240,210,180,150,120,90,60,30]
["State (MD) Dues",232,232,232,232,116,116,116,116,116,116,116,116]
["NAR Consumer Advertising Campaign ",45,45,45,45,45,45,45,45,45,45,45,45]
["National (NAR) Dues",156,143,130,117,104,91,78,65,52,39,26,13]
["Total MD",{"$f":" SUM(B7:B10)","v":793},{"$f":" SUM(C7:C10)","v":750},707,664,505,462,419,376,333,290,247,204]
["*The non-deductible portion of MR 2023 dues attributive to lobbying is $21, the non-deductible portion of NAR 2023 dues is $51.00"]
[]
["Pennsylvania - Prorated REALTOR® Dues Fees (for those primarily licensed in PA)"]
["PRIMARY PENNSYLVANIA REALTOR® MEMBERSHIP PRORATED DUES SCHEDULE"]
[null,"Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec"]
["Local (Pen-Mar) Dues",360,330,300,270,240,210,180,150,120,90,60,30]
["State (PA) Dues",150,137.5,{"$f":"ROUNDUP(SUM(B18/12)*10,2)","v":125},{"$f":"ROUNDUP(SUM(B18/12)*9,2)","v":112.5},{"$f":"ROUNDUP(SUM(B18/12)*8,2)","v":100},{"$f":"ROUNDUP(SUM(B18/12)*7,2)","v":87.5},{"$f":"ROUNDUP(SUM(B18/12)*6,2)","v":75},{"$f":"ROUNDUP(SUM(B18/12)*5,2)","v":62.5},{"$f":"ROUNDUP(SUM(B18/12)*4,2)","v":50},{"$f":"ROUNDUP(SUM(B18/12)*3,2)","v":37.5},{"$f":"ROUNDUP(SUM(B18/12)*2,2)","v":25},{"$f":"ROUNDUP(SUM(B18/12)*1,2)","v":12.5}]
["NAR Consumer Advertising Campaign ",45,45,45,45,45,45,45,45,45,45,45,45]
["National (NAR) Dues",156,143,130,117,104,91,78,65,52,39,26,13]
["Total PA (Renewing Members)",{"$f":"SUM(B17:B20)","v":711},{"$f":"SUM(C17:C20)","v":655.5},600,544.5,489,433.5,378,322.5,267,211.5,156,100.5]
["*PA Capital Investment Fee (one-time fee, New Members only)",100,100,100,100,100,100,100,100,100,100,100,100]
["Total PA (New Members)",{"$f":"SUM(B21+B22)","v":811},755.5,700,644.5,589,533.5,478,422.5,367,311.5,256,200.5]
["*The non-deductible portion of PAR 2023 dues attributive to lobbying is $7.50, the non-deductible portion of NAR 2023 dues is $51.00"]
[]
["Secondary REALTOR® Membership Prorated Dues Fees (only applies to those who have a primary membership at another local REALTOR Board)"]
["*One Time Application Fee of $125 will be added to Dues","Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec"]
["Total Secondary Member Dues",360,330,300,270,240,210,180,150,120,90,60,30]
[]
["Affiliate Membership Dues Fees (A one-time application fee of $125 must be paid by all new Affiliate Members at time of application)"]
[null,"Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec"]
["Individual Affiliate Membership",150,137.5,125,112.5,100,87.5,75,62.5,50,37.5,25,12.5]
["Added Members to Affiliate Company (per person)",75,75,75,75,75,75,75,75,75,75,75,75]
["*Affiliates are non-REALTOR® members of the association"]

{"sheet":"Sheet1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}