{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PARAMETROS","COTIZADOR LIH"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"PARAMETROS","index":0,"n_rows":71,"n_cols":39,"rows_kept":71,"cut":false,"hidden":true,"merged":[[0,11,0,12],[0,13,0,14],[0,9,0,10],[0,5,0,6],[0,0,1,0],[0,1,0,2],[0,3,0,4],[0,7,0,8]]}
["Edad","PLATA PLUS",null,"BRONCE",null,"Plan III Int Q2M",null,"Plan IV C.A. Q1.5M",null,"Plan V C.A. Q1M",null,"Health Access - $5K",null,"Health Access - $10K",null,null,"FRECUENCIA DE PAGO",null,"FECHAS",null,null,"Edades","PLAN A - Q50,000","PLAN B - Q100,000","PLAN C - Q150,000","PLAN D - Q200,000","PLAN E - Q250,000","PLAN F - Q300,000","PLAN CONFIO - Q50,000 ","PLAN CONFIO - Q75,000",null,null,"Básico"]
[null,"Hombre","Mujer","Hombre","Mujer","Hombre","Mujer","Hombre","Mujer","Hombre","Mujer","Hombre","Mujer","Hombre","Mujer",null,"MENSUAL",null,{"$f":"+TODAY()-36500","v":"1924-01-20"},null,null,18,27,51,75.5,99,123,146.5,21.5,30.75,null,null,"Productos 1 - Selección Básico","Plan A","Plan B","Plan C"]
["0 - 17",3132,3132,2472,2472,2856,2856,2484,2484,2400,2400,503.64,503.64,449.40000000000003,449.40000000000003,null,"SEMESTRAL",null,{"$f":"+TODAY()","v":"2023-12-26"},null,null,19,27.306187023641556,51.416407148646954,76.116445876918533,99.8083197591382,124.00427606438383,147.6961499466035,21.755155853034626,31.132733779551941,null,null,"Muerte Accidental y desmembración",40000,40000,40000]
[18,4116,6024,3192,5088,4344,6756,3804,5232,3444,4620,656.64,962.16000000000008,585.96,858.59999999999991,null,"ANUAL",null,{"$f":"+DATE(YEAR($S$3)-25,MONTH($S$3),DAY($S$3)+1)","v":"1998-12-27"},{"$f":"DATEDIF(S4,TODAY(),\"y\")","v":24},null,20,27.615846287781132,51.836214197557531,76.737924939521434,100.62323932467049,125.01675188822698,148.90206627337605,22.013205239817609,31.519807859726416,null,null,"Enfermedades Graves",80000,120000,160000]
[19,4308,6252,3336,5280,4368,6792,3816,5244,3456,4632,686.88,998.52,612.84,891.12000000000012,null,null,null,{"$f":"+DATE(YEAR($S$3)-18,MONTH($S$3),DAY($S$3))","v":"2005-12-26"},null,null,21,27.929017168529221,52.259448906393956,77.36447828299498,101.44481258300003,126.03749442130307,150.11782872130814,22.274180973774353,31.911271460661528]
[20,4500,6492,3504,5472,4392,6828,3852,5268,3468,4656,718.56000000000006,1036.44,641.16,924.83999999999992,null,null,null,null,null,null,22,28.245739488531662,52.686139261471851,77.996147338061277,102.27309386050419,127.06657116002035,151.34351768246327,22.538116240443053,32.307174360664582,null,null,"Opcional"]
[21,4716,6744,3672,5688,4404,6864,3864,5304,3492,4680,751.68000000000006,1075.8000000000002,670.68000000000006,959.87999999999988,null,null,null,null,null,null,23,28.566053522033453,53.116313477610795,78.632973873717944,103.10813792712683,128.10405015188485,152.57921420529374,22.805044601694544,32.707566902541814,null,null,"Renta Diaria x Hospt Acc o Enf, Deducibel 1 día",400,800,1200]
[22,4932,6996,3852,5904,4428,6888,3876,5328,3516,4704,786.24,1116.3600000000001,701.52,996.36,null,"PLAN DENTAL","ANUAL",null,null,null,24,29,54,79,104,129,154,23.166666666666664,33.25]
[23,5160,7260,4044,6120,4464,6936,3900,5352,3528,4728,822.48,1158.72,733.92,1033.92,null,"PANAMEDIC",{"$f":"12*42","v":504},null,null,null,25,29.19405134434907,54.292753700651652,79.486305352480514,104.58496945078807,129.7785136790902,154.97192708802072,23.328376120290891,33.492564180436339]
[24,5184,7656,4236,6336,4476,6960,3912,5388,3540,4752,827.76,1221.8399999999999,738.59999999999991,1090.32,null,"HEALTH ACCESS",{"$f":"12*8","v":96},null,null,null,26,29.389401168844469,54.587094525918943,79.97560428592115,105.17322918290645,130.56172568026199,155.94998821671956,23.491167640703729,33.73675146105559,null,null,"Básico","PLAN A - Q80k","PLAN B - Q120k","PLAN C - Q160k","PLAN A Q80k + RENTA Q400"," PLAN B Q120k + RENTA Q800","PLAN C Q160k + RENTA Q1.200"]
[25,5340,7824,4368,6480,4584,7068,4020,5484,3600,4836,852.59999999999991,1249.44,760.68000000000006,1114.92,null,null,null,null,null,null,27,29.586058162169579,54.883031080183464,80.467915228099699,105.76479770322118,131.34966435784111,156.93422209934513,23.65504846847465,33.982572702711977,null,null,"Titular",49.6,58.4,68,56,70.400000000000006,86.4]
[26,5508,8004,4512,6636,4716,7176,4104,5580,3648,4908,878.04,1277.76,783.59999999999991,1140.1200000000001,null,null,null,null,null,null,28,29.784031071147467,55.180572014474265,80.963256720231001,106.3596936226939,132.1423582372712,157.92466769347379,23.82002589262289,34.230038838934334,null,null,"Titular + Esposa",89.2,105.12,122.4,100.8,126.72,155.52000000000001]
[27,5664,8184,4644,6792,4836,7284,4200,5676,3708,4992,904.44,1306.8000000000002,807.12000000000012,1166.1600000000001,null,null,null,null,null,null,29,29.983328701129899,55.47972602672079,81.461647417665205,106.95793565696749,132.93983601614678,158.92136420255142,23.986107250941583,34.479160876412372,null,null,"Titular + Esposa + Hijos",156.47999999999999,175.52,194.4,169.6,200.32,232.32]
[28,5832,8376,4788,6948,4968,7380,4296,5772,3744,5088,931.56,1336.44,831.24,1192.56,null,null,null,null,null,null,30,30.183959916389011,55.780501862007121,81.963106090590401,107.55954262695482,133.74212656525202,159.92435107744538,24.153299930324181,34.729949895486271]
[29,6012,8568,4932,7116,5088,7488,4392,5892,3804,5172,959.52,1366.8000000000002,856.08,1219.68,null,null,null,null,null,null,31,30.385933640511549,56.082908312827655,82.467651624739531,108.16453345943083,134.549258929606,160.93366801800579,24.321611367092956,34.982417050639441,null,null,"Básico",{"$f":"+AH10","v":"PLAN A - Q80k"},{"$f":"+AI10","v":"PLAN B - Q120k"},"PLAN C - Q160k","PLAN A Q80k + RENTA Q400"," PLAN B Q120k + RENTA Q800","PLAN C Q160k + RENTA Q1.200"]
[30,6192,8760,5088,7284,5220,7608,4488,5988,3864,5256,988.19999999999993,1397.8799999999999,881.64,1247.28,null,null,null,null,null,null,32,30.58925885679578,56.386954219344091,82.97530302210167,108.77292718762803,135.36126232951409,161.9493549746372,24.49104904732982,35.236573570994729,null,null,"Titular",49.6,58.4,68,56,70.400000000000006,86.4]
[31,6372,8952,5244,7452,5352,7716,4596,6096,3912,5352,1017.72,1429.56,908.16000000000008,1275.5999999999999,null,null,null,null,null,null,33,30.793944608651053,56.692648469643871,83.48607940163761,109.38474295183531,136.17816616162602,162.97145214987958,24.661620507209211,35.492430760813818,null,null,"Adicional Cónyuge",{"$f":"+AH12-AH$11","v":39.6},{"$f":"+AI12-AI$11","v":46.720000000000006},54.400000000000006,44.8,56.319999999999993,69.12]
[32,6564,9156,5412,7632,5496,7824,4704,6204,3972,5436,1048.44,1461.96,935.40000000000009,1304.6399999999999,null,null,null,null,null,null,34,30.999999999999996,57,83.999999999999986,110,137,164,24.833333333333332,35.75,null,null,"Adicional Hijos",{"$f":"+AH13-AH$11","v":106.88},{"$f":"+AI13-AI$11","v":117.12},126.4,113.6,129.91999999999999,145.91999999999999]
[33,6768,9372,5580,7800,5640,7944,4812,6324,4032,5532,1079.76,1495.1999999999998,963.48,1334.16,null,null,null,null,null,null,35,31.902488293849196,58.689047449192621,86.375989921022722,113.16274804245198,140.84940284516335,168.74144723981135,25.585406911540996,36.878110367311493]
[34,6972,9576,5748,7992,5772,8064,4920,6432,4104,5640,1112.1600000000001,1529.16,992.28,1364.4,null,null,null,null,null,null,36,32.831250301264035,60.428145447255858,88.819186129007363,116.41643222290429,144.80696556086937,173.61997571089046,26.359375251053365,38.039062876580047]
[35,7176,9792,5928,8172,5928,8172,5040,6540,4152,5724,1145.4000000000001,1563.96,1022.04,1395.3600000000001,null,null,null,null,null,null,37,33.787050916403516,62.218777112644069,91.33148959372123,119.76366716037916,148.87572720488021,178.63954860485703,27.155875763669599,39.233813645504398,null,null,"Básico"]
[36,7476,10032,6192,8364,6096,8376,5172,6756,4332,5916,1194.24,1602.3600000000001,1065.5999999999999,1429.8000000000002,null,null,null,null,null,null,38,34.770677301427419,64.06246951218786,93.91485505499115,123.20714265009153,153.05881222588917,183.80424369420854,27.975564417856184,40.463346626784272,null,null,"Productos 1 - Selección Básico","Plan A","Plan B","Plan C"]
[37,7800,10284,6456,8556,6276,8556,5304,6972,4536,6108,1245,1641.72,1110.96,1464.96,null,null,null,null,null,null,39,35.782939534774073,65.960794963390356,96.571292543621738,126.74962582493407,157.359432862821,189.11825664499827,28.819116278978392,41.728674418467591,null,null,"Muerte Accidental y desmembración",5000,5000,5000]
[38,8136,10536,6744,8760,6444,8760,5436,7200,4728,6324,1297.92,1682.16,1158.1200000000001,1501.08,null,null,null,null,null,null,40,36.824671278311079,67.915372375313723,99.302868945333444,130.39396337910981,161.78089161154676,194.58590442528708,29.687226065259235,43.030839097888851,null,null,"Enfermedades Graves",10000,15000,20000]
[39,8472,10800,7044,8964,6636,8964,5580,7428,4932,6528,1353.1200000000001,1723.56,1207.44,1537.92,null,null,null,null,null,null,41,37.896730463908519,69.927868629199523,102.11170960893766,134.14308385569925,166.32658376090848,200.21162881213752,30.580608719923767,44.370913079885646]
[40,8832,11064,7356,9168,6828,9168,5724,7656,5148,6744,1410.84,1765.92,1258.8000000000002,1575.84,null,null,null,null,null,null,42,38.999999999999993,72,104.99999999999999,138,171,206,31.499999999999996,45.749999999999993,null,null,"Opcional"]
[41,9216,11328,7680,9384,7020,9384,5868,7908,5388,6972,1470.72,1809.48,1312.32,1614.72,null,null,null,null,null,null,43,40.986957977447936,75.78139347462718,110.41248716371443,145.20690526540542,179.8379836033707,216.31414832303,33.15579831453995,48.233697471809926,null,null,"Renta Diaria x Hospt Acc o Enf, Deducibel 1 día",50,100,150]
[42,9600,11616,8016,9600,7212,9600,6012,8160,5616,7200,1533.3600000000001,1854.12,1368.1200000000001,1654.44,null,null,null,null,null,null,44,43.075146775514959,79.761383291059232,116.10397449216578,152.79018359968424,189.13275056448089,227.1447124500865,34.895955646262465,50.843933469393704]
[43,10056,11892,8376,9840,7920,10032,6516,8376,6024,7380,1606.08,1898.3999999999999,1433.16,1693.92,null,null,null,null,null,null,45,45.269723865652161,83.950399600837684,122.08884374545222,160.76949069161773,198.90790932675745,238.5175486394175,36.724769888043468,53.58715483206521]
[44,10536,12168,8760,10092,8688,10476,7068,8580,6468,7560,1682.28,1943.6399999999999,1501.1999999999998,1734.2400000000002,null,null,null,null,null,null,46,47.576109480311729,88.359420340323098,128.38221802740458,169.16550872771893,209.1882885151237,250.45980773802174,38.646757900259772,56.470136850389657,null,null,"Básico","PLAN A - $10k","PLAN B - $15k","PLAN C - $20k","PLAN A $10k + RENTA $50","PLAN B $15k + RENTA $100","PLAN C $20k + RENTA $150"]
[45,11040,12468,9156,10344,9540,10944,7656,8796,6948,7752,1762.1999999999998,1990.08,1572.3600000000001,1775.7599999999998,null,null,null,null,null,null,47,49.999999999999993,93,135,178,220,263,40.666666666666657,59.499999999999986,null,null,"Titular",6.2,7.3,8.5,7,8.8000000000000007,10.8]
[46,11556,12756,9576,10596,10476,11448,8304,9012,7452,7956,1845.96,2037.48,1647,1818,null,null,null,null,null,null,48,53.480518786253434,99.289723413140791,144.24427482080679,190.05329019764736,235.00788281433569,280.97055923031905,43.567098988544529,63.850648482816794,null,null,"Titular + Esposa",11.16,13.14,15.3,12.6,15.84,19.440000000000001]
[47,12108,13068,10008,10860,11496,11952,9000,9240,8004,8148,1933.44,2086.1999999999998,1725.2400000000002,1861.44,null,null,null,null,null,null,49,57.20331779293614,106.00482984363437,154.12156161911432,202.92277030871441,251.03956811307515,300.16903100455608,46.669431494113446,68.504147241170173,null,null,"Titular + Esposa + Hijos",19.559999999999999,21.94,24.3,21.2,25.04,29.04]
[48,13164,13992,10836,11580,12240,12624,9756,9732,8664,8568,2101.8000000000002,2235,1875.3600000000001,1994.3999999999999,null,null,null,null,null,null,50,61.185262237222936,113.17408855517751,164.67520659258841,216.66370872580137,268.16489729490456,320.6793175094034,49.987718531019127,73.481577796528683]
[49,14304,15000,11736,12336,13008,13320,10560,10236,9396,9000,2284.8000000000002,2394.48,2038.8000000000002,2136.7200000000003,null,null,null,null,null,null,51,65.444391330392904,120.82821451804169,175.95152411788487,231.33511634698468,286.45847617454228,342.5910538943503,53.53699277532742,78.805489162991122,null,null,"Básico",{"$f":"+AH30","v":"PLAN A - $10k"},{"$f":"+AI30","v":"PLAN B - $15k"},"PLAN C - $20k","PLAN A $10k + RENTA $50","PLAN B $15k + RENTA $100","PLAN C $20k + RENTA $150"]
[50,15552,16068,12708,13140,13836,14052,11448,10764,10176,9444,2315.88,2422.8000000000002,2066.2799999999997,2161.6799999999998,null,null,null,null,null,null,52,69.999999999999986,129,188,247,306,366,57.333333333333314,84.499999999999972,null,null,"Titular",{"$f":"+AH31","v":6.2},{"$f":"+AI31","v":7.3},8.5,7,8.8000000000000007,10.8]
[51,16908,17208,13764,13992,14712,14820,12396,11328,11016,9936,2517.48,2595.48,2246.2799999999997,2316,null,null,null,null,null,null,53,75.325618570790084,138.79517125410334,202.26471998753044,265.73426760082901,329.20381474178208,393.53378004514076,61.771348808991732,91.157023213487591,null,null,"Adicional Cónyuge",{"$f":"+AH32-AH$31","v":4.96},{"$f":"+AI32-AI$31","v":5.8400000000000007},6.8000000000000007,5.6,7.0399999999999991,8.64]
[52,18384,18444,14904,14904,15648,15648,13416,11916,11916,10440,2736.84,2780.64,2442,2481.12,null,null,null,null,null,null,54,81.056411615316534,149.3341051430688,217.61179229592602,285.88947764108906,354.16716222399214,423.13889627491051,66.547009679430431,98.320514519145647,null,null,"Adicional Hijos",{"$f":"+AH33-AH$31","v":13.36},14.64,15.8,14.2,16.239999999999998,18.239999999999998]
[53,19344,18912,15684,15300,16476,15912,13788,12240,12216,10716,2879.88,2852.52,2569.6799999999998,2545.3200000000002,null,null,null,null,null,null,55,87.223204915032767,160.67327672411247,234.12334167404313,307.57340467910279,381.02346686408418,454.97117304697895,71.686004095860625,106.02900614379095]
[54,20352,19404,16500,15708,17328,16176,14172,12564,12516,11004,3030.48,2925.96,2704.08,2610.96,null,null,null,null,null,null,56,93.859169485023187,172.87344929365213,251.88772418215561,330.90199767568737,409.9162705810312,489.19815721516255,77.215974570852651,114.32396185627897]
[55,21420,19908,17364,16128,18228,16440,14556,12900,12828,11292,3188.88,3001.56,2845.44,2678.3999999999996,null,null,null,null,null,null,57,100.99999999999997,186,271,356,441,526,83.166666666666643,123.24999999999996]
[56,22536,20412,18276,16560,19188,16728,14964,13248,13140,11580,3355.68,3079.2000000000003,2994.2400000000002,2747.52,null,null,null,null,null,null,58,109.16774832318549,200.8366112233459,292.50516155005727,384.32098515428873,475.98950283185479,568.24652355683975,89.973123602654567,133.45968540398184]
[57,23712,20940,19224,16992,20184,17004,15384,13596,13452,11904,3531.24,3158.6400000000003,3150.84,2818.32,null,null,null,null,null,null,59,117.99601261340959,216.85669036385687,315.71686174695611,414.89499896057032,513.7551174741867,613.88614360158545,97.330010511174663,144.49501576676201]
[58,25488,21936,20664,17820,21660,17784,16668,14412,14700,12600,3794.2799999999997,3309.12,3385.56,2952.6000000000004,null,null,null,null,null,null,60,127.53820800118932,234.15463878380334,340.7705226914041,447.90127734863489,554.51710418108678,663.19138205573358,105.2818400009911,156.42276000148664]
[59,27384,22992,22200,18672,23220,18600,18048,15276,16056,13356,4077,3466.7999999999997,3637.7999999999997,3093.3599999999997,null,null,null,null,null,null,61,137.85206923429624,252.83238793314896,367.81231288319782,483.53331506317892,598.51319893631592,716.45664887077271,113.87672436191352,169.31508654287026]
[60,29424,24084,23856,19584,24900,19452,19548,16176,17520,14160,4698.72,3846,4192.5599999999995,3431.76,null,null,null,null,null,null,62,148.99999999999994,273,397,522,646,774,123.1666666666666,183.24999999999989]
[61,31608,25224,25632,20520,26700,20340,21180,17148,19128,15012,5048.6400000000003,4029.24,4504.7999999999993,3595.2000000000003,null,null,null,null,null,null,63,180.97505435012218,330.74059126402585,480.50854441374139,632.09267205641265,781.8608769077797,938.89833509820971,149.81254529176849,223.21881793765272]
[62,33960,26436,27540,21516,28620,21276,22944,18168,20892,15900,5424.72,4221.24,4840.5599999999995,3766.68,null,null,null,null,null,null,64,219.81188118811872,400.69354838709677,581.58302583025829,765.40449438202245,946.29478458049891,1138.9277566539924,182.1765676567656,271.76485148514837]
[63,40644,29688,32964,24204,30696,22260,24852,19248,22800,16836,6492.12,4742.28,5792.88,4231.4400000000005]
[64,48648,33360,39444,27228,32916,23292,26916,20400,24900,17844,7769.52,5327.64,6932.88,4753.7999999999993]
[65,0,0,0,0,35496,24504,29592,21780,27624,19056,8554.2000000000007,5865.72,7623.9600000000009,5227.7999999999993]
[null,null,null,null,null,null,null,null,null,null,null,9338.64,6403.68,8314.92,5701.5599999999995]
[null,null,null,null,null,null,null,null,null,null,null,10123.32,6941.64,9005.880000000001,6175.4400000000005]
[null,null,null,null,null,null,null,null,null,null,null,11233.32,7702.7999999999993,10009.08,6863.16]
[null,null,null,null,null,null,null,null,null,null,null,12343.079999999998,8463.84,10989.84,7535.88]
[null,null,null,null,null,null,null,null,null,null,null,13453.199999999999,9225,11970.72,8208.48]
[null,null,null,null,null,null,null,null,null,null,null,14563.079999999998,9986.0399999999991,12973.800000000001,8896.32]
[null,null,null,null,null,null,null,null,null,null,null,15672.84,10747.2,13954.800000000001,9568.7999999999993]
[null,null,null,null,null,null,null,null,null,null,null,16400.28,11245.68,14623.560000000001,10027.56]
[null,null,null,null,null,null,null,null,null,null,null,17146.439999999999,11757.599999999999,15269.880000000001,10470.719999999999]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]
[null,null,null,null,null,null,null,null,null,null,null,17873.760000000002,12256.2,15916.439999999999,10914]

{"sheet":"COTIZADOR LIH","index":1,"n_rows":51,"n_cols":29,"rows_kept":51,"cut":false,"hidden":false,"merged":[[45,11,45,15],[46,11,46,15],[21,13,21,14],[20,13,20,14],[19,13,19,14],[44,11,44,12],[44,13,44,15],[9,10,9,15],[44,1,44,6],[14,1,14,2],[15,1,15,2],[16,1,16,2],[24,5,24,6],[19,5,19,6],[9,1,9,3],[9,4,9,6],[13,1,13,2],[18,1,18,3],[37,1,37,2],[38,1,38,3],[38,5,38,6],[46,1,46,6],[47,1,47,6],[45,1,45,6],[39,5,39,6],[40,5,40,6],[39,1,39,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLATA PLUS",null,null,null,{"$f":"IF($D$14=\"\",\"\",IF(OR($D$14=$S$1,$D$14=$S$2),AC1,AC7))","v":""},{"$f":"+IF($D$14=\"\",\"\",IF($Y$2=1,AA1,AB1))","v":""},null,null,"PLAN A - Q80k","PLAN A - $10k","PLAN A - Q50,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRONCE","MENSUAL","M","Sí",{"$f":"IF($D$14=\"\",\"\",IF(OR($D$14=$S$1,$D$14=$S$2),AC2,AC8))","v":""},{"$f":"+IF($D$14=\"\",\"\",IF($Y$2=1,AA2,AB2))","v":""},{"$f":"+IF(D14=\"\",1,IF(OR(D14=S6,D14=S7),2,1))","v":1},null,"PLAN B - Q120k","PLAN B - $15k","PLAN B - Q100,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTERNACIONAL III","SEMESTRAL","F","No",{"$f":"IF($D$14=\"\",\"\",IF(OR($D$14=$S$1,$D$14=$S$2),AC3,\"\"))","v":""},"",null,null,"PLAN C - Q160k","PLAN C - $20k","PLAN C - Q150,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C.A. IV","ANUAL",null,null,{"$f":"IF($D$14=\"\",\"\",IF(OR($D$14=$S$1,$D$14=$S$2),AC4,\"\"))","v":""},"",null,null,"PLAN A Q80k + RENTA Q400","PLAN A $10k + RENTA $50","PLAN D - Q200,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C.A. V",null,null,null,"","",null,null,"PLAN B Q120k + RENTA Q800","PLAN B $15k + RENTA $100","PLAN E - Q250,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEALTH ACCESS - $5K",null,null,null,"","",null,null,"PLAN C Q160k + RENTA Q1.200","PLAN C $20k + RENTA $150","PLAN F - Q300,000"]
[null,"La presente cotización es de carácter ilustrativo; por lo tanto, no constituye oferta formal de la Compañía",null,null,null,null,null,null,null,"La presente cotización es de carácter ilustrativo; por lo tanto, no constituye oferta formal de la Compañía",null,null,null,null,null,null,null,null,"HEALTH ACCESS - $10K",null,null,null,null,null,null,null,null,null,"VIDA - Q50,000 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIDA - Q75,000"]
[null,"V 1 2024"]
[null,"Cotización especialmente diseñada para:",null,null,null,null,null,null,null,null,"Primas Mensuales de todos los planes"]
[null,null,null,null,null,null,null,null,null,null,"Gastos Médicos, Dental y EG","PLATA PLUS","BRONCE","INTERNACIONAL III","C.A. IV","C.A. V"]
[null,null,null,null,null,null,null,null,null,null,"Asegurado Titular"]
[null,null,null,null,null,null,null,null,null,null,"Dependiente Conyuge"]
[null,"Plan Salud:",null,null,null,"Frecuencia de Pago:","Mensual",null,null,null,"Dependientes Hijos"]
[null,"Plan Vida - Adicional",null,""]
[null,"Plan Dental - Opcional",null,null,null,null,null,null,null,null,"Prima Mensual Gasto Médico (Sin IVA)"]
[null,"Plan Enf. Graves - Opcional",null,null,null,null,null,null,null,null,"Prima Mensual Gasto Médico (Con IVA)"]
[null,null,null,null,null,"Cantidad de Asegurados"]
[null,"Ingreso de Datos"]
[null,"Parentesco","Sexo","Fecha Nacimiento",null,"Primas del Plan",null,null,null,null,"Planes Vida:","PLATA PLUS / BRONCE",null,"Planes Vida:",null,"INTERNATIONA III / C.A.IV / C.A. V"]
[null,"Titular",null,null,null,"Asegurado Titular",null,null,null,null,"PLAN A - Q50,000",null,null,"VIDA A - Q50,000"]
[null,"Conyuge",null,null,null,"Dependiente Conyuge",null,null,null,null,"PLAN B - Q100,000",null,null,"VIDA B - Q75,000"]
[null,"Hijo(a)",null,null,null,"Dependientes Hijos",null,null,null,null,"PLAN C - Q150,000",null,null,"*Solo Vida Básico (Sin IVA)"]
[null,"Hijo(a)",null,null,null,null,null,null,null,null,"PLAN D - Q200,000"]
[null,"Hijo(a)",null,null,null,"Primas Coberturas Adicionales",null,null,null,null,"PLAN E - Q250,000"]
[null,"Hijo(a)",null,null,null,"Asegurado Titular",null,null,null,null,"PLAN F - Q300,000"]
[null,"Hijo(a)",null,null,null,"Dependiente Conyuge",null,null,null,null,"*Vida y Anexos (Sin IVA)"]
[null,"",null,null,null,"Dependientes Hijos"]
[null,"",null,null,null,null,null,null,null,null,"Beneficios ","PLATA PLUS","BRONCE","INTERNACIONAL III","C.A. IV","C.A. V"]
[null,"",null,null,null,"Prima Mensual Total (Sin IVA)",null,null,null,null,"Cobertura Geográfica","Mundial","Centroamérica","Mundial","Centroamérica","Centroamérica"]
[null,"",null,null,null,"Prima Mensual Total (Con IVA)",null,null,null,null,"Máximo Vitalicio (MV)",7000000,3000000,2000000,1500000,1000000]
[null,null,null,null,null,null,null,null,null,null,"Deducible Local",1400,1400,1500,1250,800]
[null,null,null,null,null,null,null,null,null,null,"Deducible Internacional",1400,"N/A",1500,"N/A","N/A"]
[null,null,null,null,null,null,null,null,null,null,"Límite de Co-aseguro Local",50000,50000,50000,50000,50000]
[null,null,null,null,null,null,null,null,null,null,"Medicina Preventiva (Tit y Cony)",650,650,650,650,650]
[null,null,null,null,null,null,null,null,null,null,"Medicina Preventiva (Hijos)",200,200,200,200,200]
[null,null,null,null,null,null,null,null,null,null,"Ayuda Oftalmológica (Tit)",850,850,500,400,400]
[null,"Intermediario:",null,null,null,"Tomador de Póliza:",null,null,null,null,"Máximo Vitalicio para SIDA",1400000,600000,175000,130000,65000]
[null,"Nombre:",null,null,null,"Nombre:",null,null,null,null,"Limite Diario CyA",1750,1250,1250,1250,1250]
[null,"Fecha Oferta:",null,null,null,"Fecha Aceptación:",null,null,null,null,"Limite Diario UCI","URA","URA",3000,2500,2500]
[null,null,null,null,null,"Firma:",null,null,null,null,"Trasplante de Órganos",1250000,1000000,"URA","URA","URA"]
[null,null,null,null,null,null,null,null,null,null,"Maternidad en C. A. y Colombia","C.C.O.I","C.C.O.I",18500,18000,17000]
[null,null,null,null,null,null,null,null,null,null,"Complicaciones Recién Nacido",250000,250000,150000,150000,150000]
[null,null,null,null,null,null,null,null,null,null,"Control de Niño Sano",6000,6000,6000,6000,6000]
[null,null,null,null,null,null,null,null,null,null,"Cobertura de Vida","Adicional: desde Q50 000 hasta Q300 000",null,"Adicional: Q50 000 - Q75 000"]
[null,"Pan-American Life de Guatemala | Avenida La Reforma 9-00, Zona 9 - Edificio Plaza Panamericana, Nivel 10",null,null,null,null,null,null,null,null,"Cobertura Dental","Opcional: Plan Dental de Q8.000 con deducible de Q300"]
[null,"Ciudad de Guatemala, Guatemala | Tel (502) 2338-9800   | Fax (502) 2338-9898 | www.palig.com ",null,null,null,null,null,null,null,null,"Cobertura Enf Graves","Opcional: Desde Q80 000 hasta Q160 000 Enf. Graves + Q40 000 MyDA, Opcional 2: Renta diaria por Hospitalización (Deducible 1 día) desde Q400 hasta Q1 200"]
[null,null,null,null,null,null,null,null,null,null,"AC = Año Calendario, MV = Máximo Vitalicio"]
[]
[]
[null,null,null,4,null,null,null,8,null,null,10,null,null,null,null,15]