{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Conts","Quote","Calculation Sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":62,"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":"Conts","index":0,"n_rows":32,"n_cols":40,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,36,15,39],[1,36,1,39],[21,11,21,14],[21,16,21,19],[1,16,1,19],[1,11,1,14],[9,16,9,19],[15,16,15,19],[9,11,9,14],[15,11,15,14],[1,26,1,29],[1,31,1,34],[1,21,1,24],[9,21,9,24],[15,21,15,24],[21,21,21,24],[1,1,1,4],[1,6,1,9],[9,6,9,9],[15,1,15,4],[15,6,15,9],[9,1,9,4],[9,31,9,34],[27,11,27,12],[27,1,27,2],[21,1,21,4],[21,6,21,9],[15,31,15,34],[9,26,9,29],[15,26,15,29],[27,16,27,17],[27,21,27,22],[27,26,27,27],[21,26,21,29]]}
[]
[null,"KeyCare Core",null,null,null,null,"KeyCare Plus",null,null,null,null,"Coastal Core",null,null,null,null,"Coastal Saver",null,null,null,null,"Essential Delta Core",null,null,null,null,"Essential Delta Comp",null,null,null,null,"Classic Delta Comp",null,null,null,null,"KeyCare Start"]
[null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income"]
[null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child"]
[null,0,949,949,245,null,0,1207,1207,439,null,0,1946,1462,774,null,0,2087,1570,843,null,0,1681,1265,675,null,0,3831,3619,769,null,0,4022,3808,802,null,0,914,914,550]
[null,8551,1183,1183,292,null,8551,1659,1659,468,null,null,null,null,null,null,"MSA",521,392,210,null,null,null,null,null,null,"MSA",676,638,135,null,"MSA",1340,1269,267,null,9151,1538,1538,601]
[null,13801,1809,1809,410,13801,13801,2450,2450,656,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13801,2394,2394,650]
[]
[]
[null,"Essential Core",null,null,null,null,"Classic Core",null,null,null,null,"Essential Comp",null,null,null,null,"Classic Comp",null,null,null,null,"Classic Delta Core",null,null,null,null,"Executive Plan",null,null,null,null,"Classic Comprehensive Zero MSA"]
[null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income"]
[null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child"]
[null,0,2104,1577,846,null,0,2449,1931,980,null,0,4253,4022,857,null,0,4466,4225,891,null,0,1960,1545,784,null,0,5443,5443,1039,null,0,4466,4225,891]
[null,null,null,null,null,null,null,null,null,null,null,"MSA",750,709,151,null,"MSA",1488,1408,297,null,null,null,null,null,null,"MSA",1814,1814,346,null,"MSA",0,0,0]
[]
[null,"Classic Saver",null,null,null,null,"Essential Priority",null,null,null,null,"Classic Priority",null,null,null,null,"Essential Saver",null,null,null,null,"Essential Delta Saver",null,null,null,null,"THRESHOLD EXEC",null,null,null,null,"Smart Plan Classic",null,null,null,null,"Smart Plan Essential"]
[null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income"]
[null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child"]
[null,0,2468,1947,989,null,0,2787,2191,1114,null,0,2861,2256,1145,null,0,2223,1667,891,null,0,1773,1339,712,null,0,25300,25300,4800,null,0,1954,1542,781,null,0,1400,1400,1400]
[null,"MSA",822,649,329,null,"MSA",491,386,196,null,"MSA",953,752,381,null,"MSA",392,294,157,null,"MSA",312,236,125,null,null,null,null,null,null,"MSA",0,0,0,null,"MSA",0,0,0]
[]
[null,"Classic Smart Comp",null,null,null,null,"THRESHOLD Classic Smart Comp",null,null,null,null,"THRESHOLD PRIOR",null,null,null,null,"Overall ATB Limit - PRIOR",null,null,null,null,"Classic Delta Saver",null,null,null,null,"THRESHOLD CLASSIC,ESSENTIAL,DELTA COMP"]
[null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income",null,null,null,null,"Income"]
[null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child",null,"above:","PM","Adult","Child"]
[null,0,4327,3994,1378,null,0,23900,23900,800,null,0,16900,12700,5600,null,0,14300,10200,5000,null,0,1971,1557,792,null,0,20850,20850,4000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSA",657,519,264]
[]
[null,"Vitality",null,null,null,null,"Vitality Active",null,null,null,null,"Vitality Puple",null,null,null,null,"KeyFit",null,null,null,null,"Vitality Move Enhancer",null,null,null,null,"KeyFit Combo",null,null,null,null,"Vitality Active"]
[null,0,280,null,null,null,0,89,null,null,null,0,429,null,null,null,0,60,null,null,null,0,39,null,null,null,0,310,null,null,null,0,65]
[null,1,340,null,null,null,1,{"$f":"H29+79","v":168},null,null,null,1,495,null,null,null,1,75,null,null,null,1,39,null,null,null,1,375,null,null,null,1,65]
[null,2,395,null,null,null,2,{"$f":"H30+79","v":247},null,null,null,2,539,null,null,null,2,90,null,null,null,2,39,null,null,null,2,420,null,null,null,2,65]
[null,null,{"$f":"VLOOKUP((IF(Children=\"\",0,Children)+IF(Adults=\"\",0,Adults)),Vitality,2)","v":280},null,null,null,null,{"$f":"VLOOKUP((IF(Children=\"\",0,Children)+IF(Adults=\"\",0,Adults)),Vit_Act,2)","v":89},null,null,null,null,{"$f":"VLOOKUP((IF(Children=\"\",0,Children)+IF(Adults=\"\",0,Adults)),Vit_Pur,2)","v":429},null,null,null,null,{"$f":"VLOOKUP((IF(Children=\"\",0,Children)+IF(Adults=\"\",0,Adults)),KeyFit,2)","v":60},null,null,null,null,{"$f":"VLOOKUP(IF(Adults=\"\",0,Adults),Vitality_Move_Enhancer,2)","v":39},null,null,null,null,{"$f":"VLOOKUP((IF(Children=\"\",0,Children)+IF(Adults=\"\",0,Adults)),KeyFit_Combo,2)","v":310},null,null,null,null,{"$f":"VLOOKUP((IF(Children=\"\",0,Children)+IF(Adults=\"\",0,Adults)),Vit_Act2,2)","v":65}]

{"sheet":"Quote","index":1,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Core Contribution Quote:"]
[null,"KeyCare Core","KeyCare Plus","KeyCare Start","Essential Delta Core","Classic Delta Core","Essential Delta Saver","Classic Delta Saver","Coastal Core","Coastal Saver","Essential Core","Classic Core","Essential Delta Comp","Essential Comp","Classic Comp Zero MSA","Classic Delta Comp","Classic Comp","Executive Plan","Classic Saver","Essential Priority","Classic Priority","Classic Smart Comp","Essential Saver","Classic Smart","Essential Smart"]
[null,"KeyCareCore","KeyCarePlus","KeyCareStart","EssenDeltaCore","ClassicDeltaCore","EssenDeltaSaver","ClassicDeltaSaver","CoastalCore","CoastalSaver","EssenCore","ClassicCore","EssenDeltaComp","EssenComp","ClassicCompZeroMSA","ClassicDeltaComp","ClassicComp","ExecPlan","ClassicSaver","EssenPriority","ClassicPriority","ClassicSmart","EssenSaver","Smart_Clas","Smart_Essen"]
[null,{"$f":"IF('Calculation Sheet'!$J$11=\"R 0 - R 8 550\",VLOOKUP(0,INDIRECT(B4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(B4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(0,INDIRECT(B4),4),IF(OR('Calculation Sheet'!$J$11=\"R 8 551 - R 9 150\",'Calculation Sheet'!$J$11=\"R 9 151 - R 13 800\"),VLOOKUP(8551,INDIRECT(B4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(8551,INDIRECT(B4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(8551,INDIRECT(B4),4),IF('Calculation Sheet'!$J$11=\"R 13 801 +\",VLOOKUP(13801,INDIRECT(B4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(13801,INDIRECT(B4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(13801,INDIRECT(B4),4),\"ERROR\")))","v":"ERROR"},{"$f":"IF('Calculation Sheet'!$J$11=\"R 0 - R 8 550\",VLOOKUP(0,INDIRECT(C4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(C4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(0,INDIRECT(C4),4),IF(OR('Calculation Sheet'!$J$11=\"R 8 551 - R 9 150\",'Calculation Sheet'!$J$11=\"R 9 151 - R 13 800\"),VLOOKUP(8551,INDIRECT(C4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(8551,INDIRECT(C4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(8551,INDIRECT(C4),4),IF('Calculation Sheet'!$J$11=\"R 13 801 +\",VLOOKUP(13801,INDIRECT(C4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(13801,INDIRECT(C4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(13801,INDIRECT(C4),4),\"ERROR\")))","v":"ERROR"},{"$f":"IF(OR('Calculation Sheet'!$J$11=\"R 0 - R 8 550\",'Calculation Sheet'!$J$11=\"R 8 551 - R 9 150\"),VLOOKUP(0,INDIRECT(D4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(D4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(0,INDIRECT(D4),4),IF('Calculation Sheet'!$J$11=\"R 9 151 - R 13 800\",VLOOKUP(9151,INDIRECT(D4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(9151,INDIRECT(D4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(9151,INDIRECT(D4),4),IF('Calculation Sheet'!$J$11=\"R 13 801 +\",VLOOKUP(13801,INDIRECT(D4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(13801,INDIRECT(D4),3)+IF(Children=\"\",0,MIN(Children,3))*VLOOKUP(13801,INDIRECT(D4),4),\"ERROR\")))","v":"ERROR"},{"$f":"VLOOKUP(0,INDIRECT(E4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(E4),3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,INDIRECT(E4),4)","v":1681},1960,1773,1971,1946,2087,2104,2449,3831,4253,4466,4022,4466,5443,2468,2787,2861,{"$f":"VLOOKUP(0,INDIRECT(V4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(V4),3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,INDIRECT(V4),4)","v":4327},2223,{"$f":"VLOOKUP(0,INDIRECT(X4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(X4),3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,INDIRECT(X4),4)","v":1954},{"$f":"VLOOKUP(0,INDIRECT(Y4),2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,INDIRECT(Y4),3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,INDIRECT(Y4),4)","v":1400}]
[]
[null,"Savings Quote:"]
[null,"KeyCare Core","KeyCare Plus","KeyCare Start","Essential Delta Core","Classic Delta Core","Essential Delta Saver","Classic Delta Saver","Coastal Core","Coastal Saver","Essential Core","Classic Core","Essential Delta Comp","Essential Comp",{"$f":"O3","v":"Classic Comp Zero MSA"},"Classic Delta Comp","Classic Comp","Executive Plan","Classic Saver","Essential Priority","Classic Priority","Classic Smart Comp","Essential Saver",{"$f":"X3","v":"Classic Smart"},{"$f":"Y3","v":"Essential Smart"}]
[null,"KeyCareCore","KeyCarePlus","KeyCareStart","EssenDeltaCore","ClassicDeltaCore","EssenDeltaSaver","ClassicDeltaSaver","CoastalCore","CoastalSaver","EssenCore","ClassicCore","EssenDeltaComp","EssenComp",{"$f":"O4","v":"ClassicCompZeroMSA"},"ClassicDeltaComp","ClassicComp","ExecPlan","ClassicSaver","EssenPriority","ClassicPriority","ClassicSmart","EssenSaver",{"$f":"X4","v":"Smart_Clas"},{"$f":"Y4","v":"Smart_Essen"}]
[null,"N/A","N/A","N/A","N/A","N/A",{"$f":"(VLOOKUP(\"MSA\",INDIRECT(G4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(G4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(G4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":3744},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(H4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(H4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(H4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":7884},"N/A",{"$f":"(VLOOKUP(\"MSA\",INDIRECT(J4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(J4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(J4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":6252},"N/A","N/A",{"$f":"(VLOOKUP(\"MSA\",INDIRECT(M4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(M4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(M4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":8112},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(N4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(N4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(N4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":9000},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(O4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(O4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(O4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":0},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(P4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(P4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(P4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":16080},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(Q4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(Q4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(Q4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":17856},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(R4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(R4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(R4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":21768},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(S4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(S4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(S4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":9864},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(T4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(T4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(T4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":5892},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(U4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(U4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(U4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":11436},0,{"$f":"(VLOOKUP(\"MSA\",INDIRECT(W4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(W4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(W4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":4704},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(X4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(X4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(X4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":0},{"$f":"(VLOOKUP(\"MSA\",INDIRECT(Y4),2,FALSE)+IF(Adults=\"\",0,Adults)*VLOOKUP(\"MSA\",INDIRECT(Y4),3,FALSE)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(\"MSA\",INDIRECT(Y4),4,FALSE))*IF('Calculation Sheet'!$J$9=\"\",12,VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$V$53,2,FALSE))","v":0}]
[null,"Threshold Quote:"]
[null,"No Threshold","No Threshold","No Threshold","No Threshold","No Threshold","No Threshold","No Threshold","No Threshold","No Threshold","No Threshold","No Threshold",{"$f":"((VLOOKUP(0,THRESHOLD_COMP,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,THRESHOLD_COMP,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,THRESHOLD_COMP,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":20850},{"$f":"((VLOOKUP(0,THRESHOLD_COMP,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,THRESHOLD_COMP,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,THRESHOLD_COMP,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":20850},{"$f":"((VLOOKUP(0,THRESHOLD_COMP,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":20850},{"$f":"((VLOOKUP(0,THRESHOLD_COMP,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,THRESHOLD_COMP,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,THRESHOLD_COMP,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":20850},{"$f":"((VLOOKUP(0,THRESHOLD_COMP,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,THRESHOLD_COMP,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,THRESHOLD_COMP,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":20850},{"$f":"((VLOOKUP(0,Threshold_Exec,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold_Exec,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold_Exec,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":25300},"No Threshold",{"$f":"((VLOOKUP(0,Threshold_P,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold_P,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold_P,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":16900},{"$f":"((VLOOKUP(0,Threshold_P,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold_P,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold_P,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":16900},{"$f":"((VLOOKUP(0,Threshold,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":23900},"No Threshold","No Threshold","No Threshold"]
[null,"SPG:"]
[null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"M12-M10","v":12738},11850,20850,4770,2994,3532,"N/A",{"$f":"T12-T10","v":11008},{"$f":"U12-U10","v":5464},{"$f":"V12-V10","v":23900},"N/A","N/A","N/A"]
[null,"Overall ATB Limit"]
[null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"((VLOOKUP(0,Threshold_P_ATB,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold_P_ATB,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold_P_ATB,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":14300},{"$f":"((VLOOKUP(0,Threshold_P_ATB,2)+IF(Adults=\"\",0,Adults)*VLOOKUP(0,Threshold_P_ATB,3)+MIN(IF(Children=\"\",0,Children),3)*VLOOKUP(0,Threshold_P_ATB,4)))*IF('Calculation Sheet'!$J$9=\"\",12/12,(VLOOKUP('Calculation Sheet'!$J$9,'Calculation Sheet'!$U$42:$W$53,3,FALSE)/12))","v":14300},"N/A","N/A","N/A","N/A"]
[]
[]
[null,"None","Vitality Move","Vitality Active","Vitality Active (Over 30 yo)","Vitality","KeyFit","KeyFit Combo","Vitality Purple"]
[null,0,{"$f":"Conts!W32","v":39},{"$f":"Conts!H32","v":89},{"$f":"Conts!AG32","v":65},{"$f":"Conts!C32","v":280},{"$f":"Conts!R32","v":60},{"$f":"Conts!AB32","v":310},{"$f":"Conts!M32","v":429}]

{"sheet":"Calculation Sheet","index":2,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Q:","Ancillary service fee applicable? (For groups of 35 or fewer members.)"]
[]
[]
[null,"Q:","Select an option for 2020"]
[]
[null,"Q:","Select the date at which you joined the medical scheme"]
[]
[null,{"$f":"IF(OR(Option=\"KeyCare Core\",Option=\"KeyCare Plus\",Option=\"KeyCare Start\"),\"Q:\",\"\")","v":""},{"$f":"IF(OR(Option=\"KeyCare Core\",Option=\"KeyCare Plus\",Option=\"KeyCare Start\"),\"Monthly income?\",\"\")","v":""}]
[]
[null,"Q:","Please indicate the number of adult dependants ?\n"]
[]
[null,"Q:","Please indicate the number of children under 21 "]
[]
[null,"Q:","Which lifestyle product would you like to include?"]
[]
[]
[null,null,null,null,null,null,null,"Annual Threshold =",null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",HLOOKUP(Option,Savings2,5,FALSE))","v":""}]
[]
[null,null,null,null,null,null,null,"Annual MSA =",null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",HLOOKUP(Option,Savings1,3,FALSE))","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(J20=\"N/A\",\"\",\"Self Payment Gap =\")","v":"Self Payment Gap ="},null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",IF(HLOOKUP(Option,Savings3,7,FALSE)<0,0,HLOOKUP(Option,Savings3,7,FALSE)))","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(J20=\"N/A\",\"\",\"Overall ATB Limit =\")","v":"Overall ATB Limit ="},null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",HLOOKUP(Option,Savings4,9,FALSE))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"2020 Contribution"]
[]
[null,null,null,null,null,null,null,"Risk Premium:",null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",HLOOKUP(Option,TotalCore,3,FALSE))","v":""}]
[null,null,null,null,null,null,null,"MSA:",null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",IF(J22=\"N/A\",\"-\",ROUNDDOWN(J22/VLOOKUP($J$9,$U$42:$V$53,2,FALSE),0)))","v":""}]
[]
[]
[null,null,null,null,null,null,null,"Total Medical Scheme Contribution",null,{"$f":"IF(J32=\"\",\"\",SUM(J32:J34))","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(HealthProd=\"none\",HealthProd=\"\"),\"Lifestyle\",HealthProd)&\" Premium:\"","v":"Lifestyle Premium:"},null,{"$f":"IF(OR(Option=\"\",HealthProd=\"\"),\"\",HLOOKUP(HealthProd,Quote!B19:I20,2,FALSE))","v":""}]
[]
[]
[null,null,null,null,null,null,null,"Total Contribution",null,{"$f":"IF(J32=\"\",\"\",SUM(J36:J38))","v":""},null,null,null,null,null,null,2016,null,"Income Band","Vitality List","Date Joined","MSA","ATB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KeyCare Core","Core","R 0 - R 8 550","None","2020-01-01",12,12]
[null,null,"Whilst all reasonable care has been taken, Alexander Forbes will not be held responsible for any errors or omissions herein.",null,null,null,null,null,null,null,null,null,null,null,null,null,"KeyCare Start","Core","R 8 551 - R 9 150","Vitality Move","2020-02-01",11,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KeyCare Plus","Core","R 9 151 - R 13 800","Vitality Active","2020-03-01",10,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coastal Core","Core","R 13 801 +","KeyFit","2020-04-01",9,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Delta Core","Core",null,"KeyFit Combo","2020-05-01",8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Core","Core",null,"Vitality","2020-06-01",7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Delta Core","Core",null,"Vitality Purple","2020-07-01",6,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Core","Core",null,null,"2020-08-01",5,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Smart","Core",null,null,"2020-09-01",4,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Smart","Core",null,null,"2020-10-01",3,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coastal Saver","Core",null,null,"2020-11-01",2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Delta Saver","Core",null,null,"2020-12-01",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Saver","Core"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Delta Saver","Core"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Saver","Core"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Priority","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Priority","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Delta Comp","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential Comp","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Delta Comp","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Comp","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classic Smart Comp","Comp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Executive Plan","Comp"]