{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Entrada de Datos","Cotizacion","optimo","primera","supremo"],"not_rendered":{"charts":0,"images":14,"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":"Entrada de Datos","index":0,"n_rows":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[[71,0,74,6],[71,7,74,13],[61,0,61,13],[63,0,63,3],[63,4,63,9],[63,10,63,13],[69,0,69,13],[44,0,44,13],[48,10,53,13],[48,5,53,9],[48,0,53,4],[47,3,47,4],[35,4,35,9],[35,0,35,3],[37,6,37,8],[39,6,39,8],[36,11,36,13],[39,0,39,3],[37,0,37,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tipo de Cotización","Diners Club"]
["Nombre del asegurado titular:",null,null,null,"John Doe",null,null,null,null,null,null,null,null,null,null,null,"Renovación",false]
[null,null,null,null,null,null,null,null,null,null,null,"Tipo de Cotización",null,null,null,null,"Nuevo Negocio","Discount (%)"]
["Número de adultos en la póliza:",null,null,null,1,null,"Edad del asegurado titular:",null,null,40,null,null,null,null,null,null,2,8.33]
[]
["Número total de dependientes en la póliza:",null,null,null,0,null,"Edad del-la cónyuge:",null,null,0]
[]
[]
[]
[]
["Selecciona la Cobetura Máxima (Requerido)"]
[]
[]
["\n\n\n",null,null,null,null,null,null,"\n\n\n"]
["Límite Máximo: USD 35.000\nDeducible Annual: USD 100",null,null,null,null,"Límite Máximo: USD 55.000\nDeducible Annual: USD 100",null,null,null,null,"Límite Máximo: USD 125.000\nDeducible Annual: USD 100\n",null,null,null,null,null,"Cobertura\nSelection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Selecciona la cobertura Ambulatoria y Hospitalaria (Requerido)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Network\nSelection"]
["Base",null,null,null,"Plus",null,null,null,null,null,"Completa",null,null,null,null,null,3]
[]
[]
[]
[]
[]
["Selecciona entre las Coberturas Opcionales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dental"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Cobertura Opcional\nOdontológica",null,null,null,null,null,null,"Cobertura Opcional\nViajero"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Viajero"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product Discount (%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R36=TRUE,IF(AND(Q50=2,Q64=3),((1-Q80/100)*(1-R38/100)),1-(Q80/100)),1-(Q80/100))","v":0.91}]

{"sheet":"Cotizacion","index":1,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,2,48,11],[50,3,57,11],[43,7,44,8],[43,9,44,10],[43,11,44,12],[45,7,45,8],[45,9,45,10],[45,11,45,12],[31,7,31,11],[32,7,32,11],[33,7,33,11],[36,7,37,12],[38,7,40,12],[34,7,34,11],[28,2,28,4],[30,2,30,4],[24,2,24,5],[25,2,26,12],[22,4,22,10],[28,7,28,11],[29,7,29,11],[30,7,30,11],[32,2,32,4],[40,3,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[34,2,34,4],[36,2,36,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cotización de Seguro Médico Nacional: Mi Bupa"]
[]
[null,null,"Tu plan incluye:"]
[null,null,"Los valores de coberturas máximas, beneficios ambulatorios, hospitalarios y las coberturas adicionales de tu elección"]
[]
[]
[null,null,"Cantidad de Asegurados:",null,null,{"$f":"'Entrada de Datos'!E38+'Entrada de Datos'!E40","v":1},null,"Tarifa del Asegurado Titular (USD):",null,null,null,null,{"$f":"IF('Entrada de Datos'!Q50=1,\n    IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!J38,optimo!A3:E45,5,TRUE),\n        IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!J38,optimo!A3:E45,4,TRUE),\n            VLOOKUP('Entrada de Datos'!J38,optimo!A3:E45,3,TRUE))),\n    IF('Entrada de Datos'!Q50=2,\n        IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!J38,supremo!A3:E45,5,TRUE),\n            IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!J38,supremo!A3:E45,4,TRUE),\n                VLOOKUP('Entrada de Datos'!J38,supremo!A3:E45,3,TRUE))),\n        IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!J38,primera!A3:E45,5,TRUE),\n            IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!J38,primera!A3:E45,4,TRUE),\n                VLOOKUP('Entrada de Datos'!J38,primera!A3:E45,3,TRUE)))))","v":1852}]
[null,null,null,null,null,null,null,"Tarifa del Cónyuge (USD):",null,null,null,null,{"$f":"IF('Entrada de Datos'!Q50=1,\n    IF('Entrada de Datos'!E38=1, 0,\n        IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!J40, optimo!A3:E45, 5, TRUE),\n            IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!J40, optimo!A3:E45, 4, TRUE),\n                VLOOKUP('Entrada de Datos'!J40, optimo!A3:E45, 3, TRUE)))),\n    IF('Entrada de Datos'!E38=1, 0,\n        IF('Entrada de Datos'!Q50=2,\n            IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!J40, supremo!A3:E45, 5, TRUE),\n                IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!J40, supremo!A3:E45, 4, TRUE),\n                    VLOOKUP('Entrada de Datos'!J40, supremo!A3:E45, 3, TRUE))),\n            IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!J40, primera!A3:E45, 5, TRUE),\n                IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!J40, primera!A3:E45, 4, TRUE),\n                    VLOOKUP('Entrada de Datos'!J40, primera!A3:E45, 3, TRUE))))))","v":0}]
[null,null,"Módulo de Coberturas Máximas:",null,null,{"$f":"IF('Entrada de Datos'!Q50=1,\"Optim@\",IF('Entrada de Datos'!Q50=2,\"Suprem@\",\"Primer@\"))","v":"Suprem@"},null,"Tarifa del dependiente (USD):",null,null,null,null,{"$f":"IF('Entrada de Datos'!Q50=1,\n    IF('Entrada de Datos'!E40=0, 0,\n        IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!E40, optimo!A43:E45, 5, TRUE),\n            IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!E40, optimo!A43:E45, 4, TRUE),\n                VLOOKUP('Entrada de Datos'!E40, optimo!A43:E45, 3, TRUE)))),\n    IF('Entrada de Datos'!E40=0, 0,\n        IF('Entrada de Datos'!Q50=2,\n            IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!E40, supremo!A43:E45, 5, TRUE),\n                IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!E40, supremo!A43:E45, 4, TRUE),\n                    VLOOKUP('Entrada de Datos'!E40, supremo!A43:E45, 3, TRUE))),\n            IF('Entrada de Datos'!Q64=1, VLOOKUP('Entrada de Datos'!E40, primera!A43:E45, 5, TRUE),\n                IF('Entrada de Datos'!Q64=2, VLOOKUP('Entrada de Datos'!E40, primera!A43:E45, 4, TRUE),\n                    VLOOKUP('Entrada de Datos'!E40, primera!A43:E45, 3, TRUE))))))","v":0}]
[null,null,null,null,null,null,null,"Plan Dental (USD):",null,null,null,null,{"$f":"IF('Entrada de Datos'!Q71=TRUE,29.64,0)","v":0}]
[null,null,"Módulo ambulatorio y hospitalario:",null,null,{"$f":"IF('Entrada de Datos'!Q64=1,\"Base\",IF('Entrada de Datos'!Q64=2,\"Plus\",IF('Entrada de Datos'!Q64=3,\"Completa\",\"Error\")))","v":"Completa"},null,"Plan Viajero (USD):",null,null,null,null,{"$f":"IF('Entrada de Datos'!Q75=TRUE, 58.68, 0)","v":0}]
[null,null,null,null,null,null,null,"Subtotal (USD)",null,null,null,null,{"$f":"(IF('Entrada de Datos'!Q38=1,SUM(M29:M31),SUM(M29:M31)*'Entrada de Datos'!Q82))+M32+M33","v":1685.3200000000002}]
[null,null,"Cobertura Opcional Odontológica",null,null,{"$f":"IF('Entrada de Datos'!Q71=TRUE,\"Sí\",\"No\")","v":"No"},null,"Contribución Superintendencia de Bancos (3.5%)",null,null,null,null,{"$f":"M34*0.035","v":58.986200000000011}]
[null,null,null,null,null,null,null,"Contribución Seguro Social Campesino (0.5%)",null,null,null,null,{"$f":"M34*0.005","v":8.4266000000000005}]
[null,null,"Cobertura opcional viajero",null,null,{"$f":"IF('Entrada de Datos'!Q75=TRUE, \"Sí\", \"No\")","v":"No"},null,"Total Prima Annual (USD)"]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(M34:M36)","v":1752.7328000000002}]
[]
[null,null,"Nombre:",{"$f":"+'Entrada de Datos'!$E$36","v":"John Doe"}]
[null,null,"Edad del Titular",null,{"$f":"'Entrada de Datos'!J38","v":40}]
[null,null,"Edad del Cónyuge:",null,{"$f":"IF('Entrada de Datos'!E38=2,'Entrada de Datos'!J40,\"N/A\")","v":"N/A"}]
[null,null,"No. de dependientes:",null,{"$f":"'Entrada de Datos'!E40","v":0},null,null,"Pago Semestral (USD)\n(2 cuotas/año)",null,"Pago Trimestral (USD)\n(4 cuotas/año)",null,"Pago Mensual (USD)\n(12 cuotas/año)"]
[]
[null,null,null,null,null,null,null,{"$f":"H39/2","v":876.36640000000011},null,{"$f":"H39/4","v":438.18320000000006},null,{"$f":"H39/12","v":146.06106666666668}]
[]
[]
[null,null,"¿Necesitas ayuda con el proceso de contratación de tu póliza Mi Bupa?"]
[]
[null,null,null,"La presente cotización es de carácter informativo, no vinculante y en ningún momento expresa consentimiento ni compromiso legal para suministrarle cobertura de seguro. Las primas del seguro pueden variar al momento de la suscripción de la póliza. La emisión de una póliza de seguro de Bupa está sujeta a todas las evaluaciones de riesgo, a la recepción de toda la información y pagos de prima requeridos."]

{"sheet":"optimo","index":2,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,null,"Completa","Plus","Base"]
[null,null,"Annual","Annual","Annual"]
[18,"18-31",1315,1140,1046]
[32,"32-49",1590,1374,1258]
[50,"50-60",2003,1738,1573]
[61,"61-64",2633,2288,2087]
[65,"65",2811,2435,2215]
[66,"66",2863,2487,2254]
[67,"67",2913,2526,2293]
[68,"68",2965,2578,2344]
[69,"69",3017,2629,2384]
[70,"70",3083,2668,2423]
[71,"71",3134,2720,2474]
[72,"72",3186,2772,2514]
[73,"73",3237,2811,2552]
[74,"74",3289,2863,2590]
[75,75,3342,2902,2642]
[76,76,3458,3004,2720]
[77,77,3561,3095,2811]
[78,78,3665,3186,2889]
[79,79,3782,3276,2979]
[80,80,3884,3380,3070]
[81,81,4432,3857,3497]
[82,82,4561,3957,3597]
[83,83,4676,4058,3683]
[84,84,4791,4173,3784]
[85,85,4921,4274,3871]
[86,86,5035,4374,3971]
[87,87,5151,4475,4072]
[88,88,5281,4576,4159]
[89,89,5665,4924,4473]
[90,90,5786,5031,4563]
[91,91,5922,5136,4668]
[92,92,6042,5243,4759]
[93,93,6163,5363,4866]
[94,94,6300,5469,4970]
[95,95,6726,5840,5302]
[96,96,6853,5950,5413]
[97,97,6996,6078,5508]
[98,98,7121,6189,5618]
[99,99,7249,6300,5714]
[100,100,7391,6410,5825]
[1,"1 Child   ",961,844,763]
[2,"2 Children",1681,1477,1335]
[3,"3+Children",2401,2109,1907]

{"sheet":"primera","index":3,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,null,"Completa","Plus","Base"]
[null,null,"Annual","Annual","Annual"]
[18,"18-31",1161,933,852]
[32,"32-49",1584,1263,1151]
[50,"50-60",1983,1571,1433]
[61,"61-64",2223,1774,1610]
[65,"65",2261,1793,1646]
[66,"66",2325,1851,1690]
[67,"67",2387,1910,1734]
[68,"68",2451,1955,1779]
[69,"69",2516,2013,1836]
[70,"70",2595,2057,1881]
[71,"71",2659,2116,1925]
[72,"72",2723,2175,1983]
[73,"73",2785,2218,2028]
[74,"74",2849,2277,2072]
[75,75,2914,2322,2116]
[76,76,3057,2439,2218]
[77,77,3183,2542,2322]
[78,78,3312,2644,2410]
[79,79,3252,2585,2364]
[80,80,3370,2697,2447]
[81,81,3491,2793,2544]
[82,82,3626,2890,2628]
[83,83,3744,2987,2724]
[84,84,3865,3084,2820]
[85,85,4001,3195,2903]
[86,86,4119,3291,3002]
[87,87,4240,3388,3084]
[88,88,4375,3484,3180]
[89,89,4493,3581,3263]
[90,90,4614,3693,3360]
[91,91,4749,3790,3444]
[92,92,4868,3886,3540]
[93,93,4989,3982,3636]
[94,94,5124,4079,3719]
[95,95,5242,4188,3815]
[96,96,5363,4286,3899]
[97,97,5498,4384,3996]
[98,98,5616,4481,4079]
[99,99,5737,4577,4175]
[100,100,5873,4688,4272]
[1,"1 Child   ",907,717,657]
[2,"2 Children",1586,1254,1149]
[3,"3+Children",2266,1792,1642]

{"sheet":"supremo","index":4,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,null,"Completa","Plus","Base"]
[null,null,"Annual","Annual","Annual"]
[18,"18-31",1640,1444,1345]
[32,"32-49",1852,1630,1509]
[50,"50-60",2435,2127,1990]
[61,"61-64",3101,2713,2535]
[65,"65",3126,2737,2563]
[66,"66",3220,2818,2631]
[67,"67",3301,2885,2697]
[68,"68",3380,2966,2764]
[69,"69",3462,3032,2832]
[70,"70",3556,3112,2898]
[71,"71",3637,3180,2966]
[72,"72",3716,3261,3032]
[73,"73",3797,3329,3100]
[74,"74",3891,3408,3166]
[75,75,3971,3475,3247]
[76,76,4078,3569,3329]
[77,77,4199,3677,3422]
[78,78,4307,3770,3515]
[79,79,4414,3864,3609]
[80,80,4535,3971,3702]
[81,81,5158,4517,4204]
[82,82,5277,4621,4308]
[83,83,5411,4741,4413]
[84,84,5531,4844,4517]
[85,85,5649,4949,4621]
[86,86,5784,5054,4711]
[87,87,5903,5173,4816]
[88,88,6022,5277,4919]
[89,89,6465,5650,5274]
[90,90,6590,5776,5385]
[91,91,6714,5885,5478]
[92,92,6856,5994,5587]
[93,93,6981,6120,5698]
[94,94,7105,6230,5807]
[95,95,7592,6641,6198]
[96,96,7724,6756,6313]
[97,97,7854,6887,6412]
[98,98,8002,7001,6527]
[99,99,8133,7117,6641]
[100,100,8263,7248,6756]
[1,"1 Child   ",1286,1132,1047]
[2,"2 Children",2251,1981,1832]
[3,"3+Children",3215,2829,2617]