{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Agent Commissions Calculator","Upline Comp Schedule","Agent Comp Schedule","Captive Comp Schedule","2020 Rates"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":0,"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":"Agent Commissions Calculator","index":0,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,14,10,17],[10,8,10,11],[21,0,22,0],[3,0,3,6],[10,0,10,4],[18,0,19,0],[12,0,13,0],[15,0,16,0],[5,1,5,2]]}
["2020 Agent Commission Calculator"]
[]
[]
["Writing Agent Calculator"]
[]
["Step 1: Select the state for the Beneficiary","Texas",null,{"$f":"VLOOKUP(B6,'2020 Rates'!$A$5:$B$50,2,FALSE)","v":"TX"}]
[]
["Step 2: Select the effective month of the Beneficiary",null,"January",{"$f":"IF(C8=\"December\",1,IF(C8=\"November\",2,IF(C8=\"October\",3,IF(C8=\"September\",4,IF(C8=\"August\",5,IF(C8=\"July\",6,IF(C8=\"June\",7,IF(C8=\"May\",8,IF(C8=\"April\",9,IF(C8=\"March\",10,IF(C8=\"February\",11,12)))))))))))","v":12}]
[]
[]
["Writing Agent Commissions",null,null,null,null,null,null,null,"Overrides",null,null,null,null,null,"Overrides Renewals MONTHLY"]
[null,"Segment","Initial Payment","True-Up Payment","Total Initial Payout",null,"Monthly Renewal Payment",null,"GA Earnings","MGA Earnings","SGA Earnings","FMO Earnings","FMO Payment Received",null,"GA Earnings","MGA Earnings","SGA Earnings","FMO Earnings","FMO Payment Received"]
["New to Medicare/New to Wellcare\nPrior Plan Type = NONE + Cycle Year 1 per CMS \nBeneficiary is in the initial year from an \"unlike\" plan","CCP",{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B$4:$I$25,3,FALSE)/12)*$D$8","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B$4:$I$25,2,FALSE)-C13)","v":{"$error":"#N/A"}},{"$f":"SUM(C13:D13)","v":{"$error":"#N/A"}},null,{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B$4:$I$25,3,FALSE)/12)","v":{"$error":"#N/A"}},null,{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,4,FALSE)/12)*$D$8","v":75},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,5,FALSE)/12)*$D$8","v":25},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,6,FALSE)/12)*$D$8","v":30},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,7,FALSE)/12)*$D$8","v":70},{"$f":"SUM(I13:L13)","v":200},null,{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$6.25 / $2.08"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$2.50 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$2.08 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$5.83 / $2.92"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$16.67 / $7.50"}]
[null,"PDP",{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B$4:$I$25,3,FALSE)/12)*$D$8","v":39},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B$4:$I$25,2,FALSE)-C14)","v":39},{"$f":"SUM(C14:D14)","v":78},null,{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B$4:$I$25,3,FALSE)/12)","v":3.25},null,{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,4,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,5,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,6,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,7,FALSE)/12)*$D$8","v":6},{"$f":"SUM(I14:L14)","v":15},null,{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.23 / $0.23"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.58 / $0.58"}]
[]
["Already in MediCare/New to Wellcare\nPrior Plan Type = MA/MAPD or PDP + Cycle Year 1 per CMS\nBeneficiary is in the initial year from a \"Like plan type\"","CCP",{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B$4:$I$25,3,FALSE)/12)*$D$8","v":{"$error":"#N/A"}},{"$f":"IF(C16=301,300,C16)","v":{"$error":"#N/A"}},{"$f":"SUM(C16:D16)","v":{"$error":"#N/A"}},null,{"$f":"G13","v":{"$error":"#N/A"}},null,{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,4,FALSE)/12)*$D$8","v":75},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,5,FALSE)/12)*$D$8","v":25},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,6,FALSE)/12)*$D$8","v":30},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,7,FALSE)/12)*$D$8","v":70},{"$f":"SUM(I16:L16)","v":200},null,{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$6.25 / $2.08"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$2.50 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$2.08 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$5.83 / $2.92"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$16.67 / $7.50"}]
[null,"PDP",{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B$4:$I$25,3,FALSE)/12)*$D$8","v":39},{"$f":"C17","v":39},{"$f":"SUM(C17:D17)","v":78},null,{"$f":"G14","v":3.25},null,{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,4,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,5,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,6,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,7,FALSE)/12)*$D$8","v":6},{"$f":"SUM(I17:L17)","v":15},null,{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.23 / $0.23"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.58 / $0.58"}]
[]
["Already in MediCare/New to Wellcare\nPrior Plan Type = MA/MAPD or PDP + Cycle Year >1 per CMS\nBeneficiary is in the initial year from a \"Like plan type\" ","CCP",{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B$4:$I$25,3,FALSE)/12)*$D$8","v":{"$error":"#N/A"}},{"$f":"IF(C19=0,0,0)","v":{"$error":"#N/A"}},{"$f":"SUM(C19:D19)","v":{"$error":"#N/A"}},null,{"$f":"G13","v":{"$error":"#N/A"}},null,{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,4,FALSE)/12)*$D$8","v":75},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,5,FALSE)/12)*$D$8","v":25},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,6,FALSE)/12)*$D$8","v":30},{"$f":"(VLOOKUP($D$6,'2020 Rates'!$B:$I,7,FALSE)/12)*$D$8","v":70},{"$f":"SUM(I19:L19)","v":200},null,{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$6.25 / $2.08"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$2.50 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$2.08 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$5.83 / $2.92"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$16.67 / $7.50"}]
[null,"PDP",{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B$4:$I$25,3,FALSE)/12)*$D$8","v":39},0,{"$f":"SUM(C20:D20)","v":39},null,{"$f":"G14","v":3.25},null,{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,4,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,5,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,6,FALSE)/12)*$D$8","v":3},{"$f":"(VLOOKUP(\"PDP\",'2020 Rates'!$B:$I,7,FALSE)/12)*$D$8","v":6},{"$f":"SUM(I20:L20)","v":15},null,{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.23 / $0.23"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.58 / $0.58"}]
[]
["Already in Medicare/Already in WellCare \nPrior Plan Type = plan transfer\nBeneficiary is changing  from one MA plan to another plan.","CCP",{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},null,{"$f":"G13","v":{"$error":"#N/A"}},null,{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},{"$f":"IF($B$6=\"PDP\",\"#N/A\",0)","v":0},null,{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$6.25 / $2.08"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$2.50 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$2.08 / $1.25"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$5.83 / $2.92"},{"$f":"TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP($D$6,'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP($D$6,'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP($D$6,'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$16.67 / $7.50"}]
[null,"PDP",0,0,{"$f":"SUM(C23:D23)","v":0},null,{"$f":"G14","v":3.25},null,0,0,0,0,{"$f":"SUM(I23:L23)","v":0},null,{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12),\"$0.00\")","v":"$0.12 / $0.12"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.23 / $0.23"},{"$f":"TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,8,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,9,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,10,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,11,FALSE)/12),\"$0.00\") & \" / \" & TEXT((VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,12,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,13,FALSE)/12)+(VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,14,FALSE)/12) + (VLOOKUP(\"PDP\",'2020 Rates'!$B:$P,15,FALSE)/12),\"$0.00\")","v":"$0.58 / $0.58"}]

{"sheet":"Upline Comp Schedule","index":1,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[37,1,41,1],[49,1,53,1],[4,1,4,8],[5,1,6,1],[5,2,6,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[7,1,11,1],[13,1,17,1],[19,1,23,1],[25,1,29,1],[31,1,35,1],[43,1,47,1]]}
[]
[]
[]
[]
[null,"2020 Override Commission Rates"]
[null,"State","Hierarchy Level","Initial Commission",null,"First Renewal",null,"Lifetime Renewal"]
[null,null,null,"CCP","PDP","CCP","PDP","CCP","PDP"]
[null,"California","FMO",25,6,25,2.8,25,2.8]
[null,null,"SGA",50,3,50,1.4,50,1.4]
[null,null,"MGA",50,3,50,1.4,50,1.4]
[null,null,"GA",75,3,75,1.4,75,1.4]
[null,null,"Total",{"$f":"SUM(D8:D11)","v":200},{"$f":"SUM(E8:E11)","v":15},200,7,200,7]
[]
[null,"\n Florida","FMO",25,6,25,2.8,15,2.8]
[null,null,"SGA",50,3,50,1.4,15,1.4]
[null,null,"MGA",50,3,50,1.4,15,1.4]
[null,null,"GA",75,3,75,1.4,45,1.4]
[null,null,"Total",{"$f":"SUM(D14:D17)","v":200},{"$f":"SUM(E14:E17)","v":15},200,7,90,7]
[]
[null,"Texas,\nSouth Carolina,\nGeorgia,\nNew York,\nArizona","FMO",70,6,70,2.8,35,2.8]
[null,null,"SGA",30,3,30,1.4,15,1.4]
[null,null,"MGA",25,3,25,1.4,15,1.4]
[null,null,"GA",75,3,75,1.4,25,1.4]
[null,null,"Total",{"$f":"SUM(D20:D23)","v":200},{"$f":"SUM(E20:E23)","v":15},200,7,{"$f":"SUM(H20:H23)","v":90},{"$f":"SUM(I20:I23)","v":7}]
[]
[null,"\n\nHawaii,\nIllinois,\nNew Jersey,\nKentucky\n\n ","FMO",55,6,55,2.8,10,2.8]
[null,null,"SGA",20,3,20,1.4,10,1.4]
[null,null,"MGA",25,3,25,1.4,10,1.4]
[null,null,"GA",50,3,50,1.4,20,1.4]
[null,null,"Total",{"$f":"SUM(D26:D29)","v":150},{"$f":"SUM(E26:E29)","v":15},150,7,{"$f":"SUM(H26:H29)","v":50},{"$f":"SUM(I26:I29)","v":7}]
[]
[null,"Arkansas, \nMississippi, \nTennessee,\nAlabama","FMO",75,6,75,2.8,35,2.8]
[null,null,"SGA",50,3,50,1.4,20,1.4]
[null,null,"MGA",50,3,50,1.4,20,1.4]
[null,null,"GA",25,3,25,1.4,15,1.4]
[null,null,"Total",{"$f":"SUM(D32:D35)","v":200},{"$f":"SUM(E32:E35)","v":15},200,7,{"$f":"SUM(H32:H35)","v":90},{"$f":"SUM(I32:I35)","v":7}]
[]
[null,"\nConnecticut,\nMaine,\nLouisiana,\nNorth Carolina\n ","FMO",55,6,55,2.8,20,2.8]
[null,null,"SGA",20,3,20,1.4,20,1.4]
[null,null,"MGA",25,3,25,1.4,20,1.4]
[null,null,"GA",50,3,50,1.4,40,1.4]
[null,null,"Total",{"$f":"SUM(D38:D41)","v":150},{"$f":"SUM(E38:E41)","v":15},150,7,{"$f":"SUM(H38:H41)","v":100},{"$f":"SUM(I38:I41)","v":7}]
[]
[null,"Ohio, Indiana, Michigan","FMO",50,6,50,2.8,25,2.8]
[null,null,"SGA",50,3,50,1.4,25,1.4]
[null,null,"MGA",25,3,25,1.4,15,1.4]
[null,null,"GA",75,3,75,1.4,25,1.4]
[null,null,"Total",{"$f":"SUM(D44:D47)","v":200},{"$f":"SUM(E44:E47)","v":15},200,7,90,7]
[]
[null,"PDP ONLY States\n ","FMO",0,6,0,2.8,0,2.8]
[null,null,"SGA",0,3,0,1.4,0,1.4]
[null,null,"MGA",0,3,0,1.4,0,1.4]
[null,null,"GA",0,3,0,1.4,0,1.4]
[null,null,"Total",0,{"$f":"SUM(E50:E53)","v":15},{"$f":"SUM(F50:F53)","v":0},7,{"$f":"SUM(H50:H53)","v":0},{"$f":"SUM(I50:I53)","v":7}]

{"sheet":"Agent Comp Schedule","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,1,10,1],[19,1,20,1],[4,1,4,3]]}
[]
[]
[]
[]
[null,"2020 Override Commission Rates"]
[null,"MAPD States","New to MA (2X)","\"Like\" Enrollments and\nRenewals (Lifetime)"]
[null,"California, \nNew Jersey",636,318]
[null,"Connecticut",574,287]
[null,"Arkansas, Alabama, Arizona, Florida, Georgia, Hawaii, Illinois, Indiana, Kentucky, Louisiana, Maine, Michigan, Mississippi, New York, North Carolina, Ohio, South Carolina, Tennessee, Texas",510,255]
[null,"PDP","New to MA (2X)","\"Like\" Enrollments and\nRenewals (Lifetime)"]
[null,null,78,39]
[]
[]
[]
[]
[null,"MAPD States","New to MA (2X)","\"Like\" Enrollments and\nRenewals (Lifetime)"]
[2020,"California, \nNew Jersey",636,318]
[null,"Connecticut",574,287]
[null,"Arkansas, Alabama, Arizona, Florida, Georgia, Hawaii,\nIllinois, Kentucky, Louisiana, Maine, Mississippi, \nNew York, North Carolina\nSouth Carolina, Tennessee, Texas",510,255]
[null,"PDP","New to MA (2X)","\"Like\" Enrollments and\nRenewals (Lifetime)"]
[null,null,78,39]

{"sheet":"Captive Comp Schedule","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,1,10,5],[11,1,12,1],[11,3,11,5],[12,3,12,5],[4,1,4,5],[5,1,6,1],[5,2,6,2],[5,3,5,5],[7,3,9,3],[7,4,9,4],[7,5,9,5]]}
[]
[]
[]
[]
[null,"2020 Captive Commission Rates"]
[null,"MAPD States","Initial\nNew to MA (2X)","Renewals"]
[null,null,null,"Years 1-2","Years 3-4","Year 5"]
[null,"California, \nNew Jersey",636,"$200 per year","$100 per year","$50 per year"]
[null,"Connecticut",574]
[null,"Arkansas, Alabama, Arizona, Florida, Georgia, Hawaii, Illinois, Indiana, Kentucky, Louisiana, Maine, Michigan, Mississippi, New York, North Carolina, Ohio, South Carolina, Tennessee, Texas",510]
[]
[null,"PDP States","Initial\nNew to MA (2X)","Renewals"]
[null,null,78,39]
[]
[]
[null,"Captive Agent  Stipend","Monthly","$1000/$2000"]

{"sheet":"2020 Rates","index":4,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,2,1,3]]}
[null,1,2,3,4,5,6,7]
[null,null,"Agent",null,"GA","MGA","SGA","FMO","GA","MGA","SGA","FMO","GA","MGA","SGA","FMO"]
["State","Abrev","New to MA","First Payment","First Payment","First Payment","First Payment","First Payment","1st Renewal Pymt","1st Renewal Pymt","1st Renewal Pymt","1st Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt","2+ Renewal Pymt",null,"1st total","Lifetime Total"]
["PDP","PDP",78,{"$f":"C4/2","v":39},3,3,3,6,1.4,1.4,1.4,2.8,1.4,1.4,1.4,2.8,null,{"$f":"SUM(I4:L4)","v":6.9999999999999991},{"$f":"SUM(M4:P4)","v":6.9999999999999991}]
["Alabama","AL",510,255,25,50,50,75,25,50,50,75,15,20,20,35,null,200,90]
["Arizona","AZ",510,255,75,25,30,70,75,30,25,70,25,15,15,35,null,200,90]
["Arkansas","AR",510,255,25,50,50,75,25,50,50,75,15,20,20,35,null,200,90]
["California","CA",636,318,75,50,50,25,75,50,50,25,75,50,50,25,null,200,200]
["Connecticut","CT",574,287,50,25,20,55,50,25,20,55,40,20,20,20,null,150,100]
["Florida","FL",510,255,75,50,50,25,75,50,50,25,45,15,15,15,null,200,90]
["Georgia","GA",510,255,75,25,30,70,75,30,25,70,25,15,15,35,null,200,90]
["Hawaii","HI",510,255,50,25,20,55,55,20,25,50,20,10,10,10,null,150,50]
["Illinois","IL",510,255,50,25,20,55,55,20,25,50,20,10,10,10,null,150,50]
["Indiana","IN",510,255,75,25,50,50,75,25,50,50,25,15,25,25,null,200,90]
["Kentucky","KY",510,255,50,25,20,55,55,20,25,50,20,10,10,10,null,150,50]
["Louisiana","LA",510,255,50,25,20,55,50,25,20,55,40,20,20,20,null,150,100]
["Maine","ME",510,255,50,25,20,55,50,25,20,55,40,20,20,20,null,150,100]
["Michigan","MI",510,255,75,25,50,50,75,25,50,50,25,15,25,25,null,200,90]
["Mississippi","MS",510,255,25,50,50,75,25,50,50,75,15,20,20,35,null,{"$f":"SUM(H19:K19)","v":200},{"$f":"SUM(L19:O19)","v":130}]
["New Jersey","NJ",636,318,50,25,20,55,55,20,25,50,20,10,10,10,null,{"$f":"SUM(I20:L20)","v":150},{"$f":"SUM(M20:P20)","v":50}]
["New York","NY",510,255,75,25,30,70,75,30,25,70,25,15,15,35,null,{"$f":"SUM(I21:L21)","v":200},{"$f":"SUM(M21:P21)","v":90}]
["North Carolina","NC",510,255,50,25,20,55,50,25,20,55,40,20,20,20,null,{"$f":"SUM(I22:L22)","v":150},{"$f":"SUM(M22:P22)","v":100}]
["Ohio","OH",510,255,75,25,50,50,75,25,50,50,25,15,25,25,null,{"$f":"SUM(I23:L23)","v":200},{"$f":"SUM(M23:P23)","v":90}]
["South Carolina","SC",510,255,75,25,30,70,75,30,25,70,25,15,15,35,null,{"$f":"SUM(I24:L24)","v":200},{"$f":"SUM(M24:P24)","v":90}]
["Tennessee","TN",510,255,25,50,50,75,25,50,50,75,15,20,20,35,null,{"$f":"SUM(H25:K25)","v":200},{"$f":"SUM(L25:O25)","v":130}]
["Texas","TX",510,255,75,25,30,70,75,30,25,70,25,15,15,35,null,{"$f":"SUM(I26:L26)","v":200},{"$f":"SUM(M26:P26)","v":90}]