{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["FACTORES","TITULAR","CONYUGE","DEPENDIENTE","VALORES","CuadroEspecificacionesTARIFARIO","COTIZACION","IMPRESION","TARIFARIO","Instrucciones","Cotizador","CAMBIOS"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":31,"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":"FACTORES","index":0,"n_rows":445,"n_cols":23,"rows_kept":445,"cut":false,"hidden":true,"merged":[[128,4,128,5],[128,2,128,3],[31,12,31,13],[31,9,31,10],[0,2,0,3],[4,5,4,6],[8,5,8,6],[35,1,35,2],[0,0,0,1],[0,5,0,6],[6,2,6,3],[14,5,14,6],[21,5,21,6]]}
["DEDUCIBLE",null,"COASEGURO",null,"TOPES COA","EMERGENCIA EN EL EXTRANJERO",null,null,null,"DED CERO POR ACC","COSTO",null,null,"RPF","FIJO","CAPTURA","% CALCULO",null,"FACTORES PRIMA DE TARIFA"]
[null,null,0,1.1399999999999999,null,"SI",1.05,null,null,null,null,null,null,"SEMESTRAL",4.7300000000000002E-2,{"$f":"+COTIZACION!H39","v":4.7300000000000002E-2},{"$f":"IF(P2=0,1+O2,1+P2)","v":1.0472999999999999},null,0.26500000000000001,0.26500000000000001,null,null,"ADQUISICIÓN"]
[6000,1,0.05,1.07,"$30,000","NO",1,null,null,null,null,null,null,"TRIMESTRAL",7.0000000000000007E-2,{"$f":"+COTIZACION!H40","v":6.9900000000000004E-2},{"$f":"IF(P3=0,1+O3,1+P3)","v":1.0699000000000001},null,0.15,0.1,null,null,"AMINISTRACIÓN"]
[7000,0.97,0.1,1,"$35,000",null,null,null,null,null,null,null,null,"MENSUAL",0.1,{"$f":"+COTIZACION!H41","v":9.9900000000000003E-2},{"$f":"IF(P4=0,1+O4,1+P4)","v":1.0999000000000001},null,0.15,0.08,null,null,"UTILIDAD"]
[8000,0.94,0.15,0.97,"$40,000","COBERTURA EN EL EXTRANJERO",null,null,null,5500,617.75994436717667,null,{"$f":"+K5*(1-0.18)","v":506.56315438108493},null,null,null,{"$f":"M5/(1-$O$17-$P$19)","v":704.5384622824547},{"$f":"(Q5/K5)-1","v":0.14047287899860939},{"$f":"+SUM(S2:S4)","v":0.56500000000000006},{"$f":"+SUM(T2:T4)","v":0.44500000000000001}]
[9000,0.91,0.2,0.93,"$50,000","ZONA A ",3.3,null,null,6000,655.21307371349099,null,537.2747204450626,null,null,null,747.25274053555302,{"$f":"(Q6/K6)-1","v":0.14047287899860916}]
[10000,0.88,"Catálogo",null,null,"ZONA B",2.4,null,null,7000,686.84979137691244,null,563.21682892906824,"BASE DE CATALOGO",null,null,783.3335590112215,{"$f":"(Q7/K7)-1","v":0.14047287899860939},"DEDUCIBLE CONDICIONADO A POLIZA NUEVA O RENOVADA"]
[15000,0.75900000000000001,0,1,null,"ZONA C",1.9,null,null,8000,714.26675938803908,null,585.69874269819206,"ZONA","MONTO",null,814.60186745228384,0.14047287899860916,{"$f":"+IF(COTIZACION!D$7=COTIZACION!$G$241,\"FAVOR DE SELECCIONAR\",FACTORES!A5)","v":"FAVOR DE SELECCIONAR"},{"$f":"+IF(S8<>8000,\"\",B5)","v":""}]
[20000,0.65400000000000003,0.15,1.0900000000000001,null,"FORMA DE PAGO",null,null,null,9000,738.47899860917948,null,605.55277885952728,1,0.627,{"$f":"+O9*$O$14","v":32854.800000000003},842.21526962382097,0.14047287899860939,{"$f":"+IF(COTIZACION!D$7=COTIZACION!$G$241,\"FAVOR DE SELECCIONAR\",FACTORES!A6)","v":"FAVOR DE SELECCIONAR"},{"$f":"+IF(S9<>9000,\"\",B6)","v":""}]
[25000,0.56699999999999995,0.25,1.1100000000000001,null,"A = ANUAL",0,null,null,10000,760.10236439499317,null,623.28393880389444,2,0.627,{"$f":"+O10*$O$14","v":32854.800000000003},866.87613185520786,0.14047287899860916,10000,0.88]
[30000,0.52,0.5,1.2,null,"S = SEMESTRAL",4.7300000000000002E-2,null,null,15000,843.36828929068156,null,691.5619972183589,3,0.73699999999999999,{"$f":"+O11*$O$14","v":38618.800000000003},961.83866094347559,0.14047287899860939,15000,0.76]
[35000,0.48599999999999999,0.75,1.28,null,"T = TRIMESTRAL",7.0000000000000007E-2,null,null,20000,902.45618915159946,null,740.01407510431159,4,0.82399999999999995,{"$f":"+O12*$O$14","v":43177.599999999999},1029.226808211838,0.14047287899860916,20000,0.66]
[40000,0.45700000000000002,1,1.38,null,"M = MENSUAL",0.1,null,null,25000,948.26898470097376,null,777.5805674547986,5,1,{"$f":"+O13*$O$14","v":52400},1081.4750590470078,0.14047287899860939,25000,0.59]
[45000,0.432,null,null,null,"RENOVADA",null,null,null,30000,1510.8186369958278,null,1238.8712823365788,"BASE",52400,null,1723.0476805793865,0.14047287899860916,30000,0.53]
[50000,0.40899999999999997,null,null,"+utilidad","PARTO Y CESAREA",null,null,null,35000,1559.3571627260087,null,1278.6728734353273,null,null,null,1778.4045527612343,0.14047287899860939,35000,0.49]
[60000,0.36899999999999999,null,null,null,20000,1826.2968052215731,1063,{"$f":"1-(H16/G16)","v":0.41794784015348874},40000,1601.3721835883175,null,1313.1251905424206,null,null,null,1826.3215445652581,0.14047287899860939,40000,0.45]
[70000,0.33500000000000002,null,null,null,30000,2063.745019920319,2331,{"$f":"1-(H17/G17)","v":-0.12949999999999995},45000,1638.4489568845622,null,1343.5281446453412,null,0.26500000000000001,null,1868.606598950405,0.14047287899860939,45000,0.42]
[75000,0.32,null,null,null,40000,8330.1669919757096,7682,{"$f":"1-(H18/G18)","v":7.7809603649011683E-2},50000,1671.5910987482616,null,1370.7047009735747,null,0.1,null,1906.4043128978788,{"$f":"(Q18/K18)-1","v":0.14047287899860939},50000,0.39]
[80000,0.30599999999999999,null,null,null,50000,8724.214466010968,null,null,null,null,null,null,"UT",0.1,1.6E-2,null,null,60000,0.34499999999999997]
[90000,0.28100000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70000,0.3]
[100000,0.25800000000000001,null,null,null,"NUEVO",null,null,null,null,null,null,null,null,null,null,null,null,75000,0.28999999999999998]
[300000,0,null,null,null,"PARTO Y CESAREA",null,null,null,null,null,null,null,null,null,null,null,null,80000,0.27]
[400000,0,null,null,0.1,20000,1826.2968052215731,1063,null,null,null,null,null,null,null,null,null,null,90000,0.23499999999999999]
[500000,0,null,null,0.08,30000,4791.8593894542082,2331,{"$f":"+H24/G24","v":0.4864500000000001},{"$f":"+G24/2","v":2395.9296947271041},null,null,null,null,null,null,null,null,100000,0.215]
[600000,0,null,null,null,40000,17323.441199684294,7682,{"$f":"1-I24","v":0.51354999999999995},{"$f":"+G25/2","v":8661.7205998421468},null,null,null,null,null,null,null,null,300000,0]
[700000,0,null,null,null,50000,18111.715944254964,null,{"$f":"+H25/G25","v":0.44344538197988043},{"$f":"+G26/2","v":9055.8579721274818},null,0.26500000000000001,null,null,null,null,null,null,400000,0]
[800000,0,null,null,null,null,null,null,{"$f":"1-I26","v":0.55655461802011952},null,null,0.1,null,null,null,null,null,null,500000,0]
[900000,0,null,null,null,null,null,null,null,null,null,0.08,null,null,null,null,null,null,600000,0]
[1000000,0,null,null,null,"ZONA","FACTOR",null,null,null,null,{"$f":"1/(1-SUM(L26:L28))","v":1.801801801801802},null,null,null,null,null,null,700000,0]
[null,null,null,null,null,1,0.52,null,null,null,null,null,null,null,null,null,null,null,800000,0]
[null,null,null,null,null,2,0.56999999999999995,null,null,null,null,null,null,null,null,null,null,null,900000,0]
["G.M.M. INDIVIDUAL/FAMILIAR",null,null,null,null,3,0.67,null,null,"SUMA ASEGURADA",null,null,"ENFERMEDADES GRAVES",null,null,null,null,null,1000000,0]
["SUMA ASEGURADA",null,1000000,null,null,4,0.8,null,null,200000,0.82,null,10000,133.19373983979378,null,0.14074802877521209]
["DEDUCIBLE",null,6000,null,null,5,1,null,null,300000,0.86,null,20000,{"$f":"ROUND(M34/$M$33*$N$33,2)","v":266.39}]
["COASEGURO",null,0.1,null,null,null,null,null,null,400000,0.9,null,30000,399.58]
[null,"BÁSICAS",null,null,null,"ZONA",{"$f":"+COTIZACION!D14","v":5},{"$f":"+VLOOKUP(G36,I238:J242,2,FALSE)","v":"B"},null,500000,0.92,null,40000,532.77]
[{"$f":"+IF(COTIZACION!A7+COTIZACION!A8=2,1,0)","v":0},"250,000      a",10000000,null,null,"FACTOR",{"$f":"VLOOKUP(G36,F30:G35,2,FALSE)","v":1},null,null,600000,0.94,null,50000,665.97]
["E D A D","HOMBRES","MUJERES","HOMBRES","MUJERES","HOMBRES","MUJERES",null,null,700000,0.96,null,75000,998.95]
[0,{"$f":"IF($A$37=$C$130,ROUND(C132*(1-DESC),2),ROUND(E132*(1-DESC),2))","v":6985.42},{"$f":"IF($A$37=$C$130,ROUND(D132*(1-DESC),2),ROUND(F132*(1-DESC),2))","v":6989.76},{"$f":"B39","v":6985.42},{"$f":"C39","v":6989.76},{"$f":"ROUND(D39*$G$37,2)","v":6985.42},{"$f":"ROUND(E39*$G$37,2)","v":6989.76},null,null,800000,0.97,null,100000,1331.94]
[1,6985.42,6989.76,{"$f":"B40","v":6985.42},{"$f":"C40","v":6989.76},6985.42,6989.76,null,null,1000000,1,null,150000,1997.91]
[{"$f":"+A40+1","v":2},6985.42,6989.76,{"$f":"B41","v":6985.42},{"$f":"C41","v":6989.76},6985.42,6989.76,null,null,2000000,1.08,null,200000,2663.87]
[{"$f":"+A41+1","v":3},6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,3000000,1.1299999999999999,null,250000,3329.84]
[4,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,4000000,1.1599999999999999,null,300000,3995.81]
[5,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,5000000,1.18,null,350000,4661.78]
[6,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,6000000,1.2,null,400000,5327.75]
[7,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,7000000,1.22,null,450000,5993.72]
[8,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,8000000,1.24,null,500000,{"$f":"ROUND(M47/$M$33*$N$33,2)","v":6659.69}]
[9,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,9000000,1.25,null,550000,7325.66]
[10,6985.42,6989.76,6985.42,6989.76,6985.42,6989.76,null,null,10000000,1.26,null,600000,7991.62]
[11,6946.01,6882.92,6946.01,6882.92,6946.01,6882.92,null,null,11000000,1.27,null,650000,8657.59]
[12,6913.99,6977.01,6913.99,6977.01,6913.99,6977.01,null,null,12000000,1.28,null,700000,9323.56]
[13,6866.26,6931.11,6866.26,6931.11,6866.26,6931.11,null,null,13000000,1.29,null,750000,9989.5300000000007]
[14,6687.98,6789.98,6687.98,6789.98,6687.98,6789.98,null,null,14000000,1.3,null,800000,{"$f":"ROUND(M53/$M$33*$N$33,2)","v":10655.5}]
[15,6715.22,6679.78,6715.22,6679.78,6715.22,6679.78,null,null,15000000,1.31,null,850000,{"$f":"ROUND(M54/$M$33*$N$33,2)","v":11321.47}]
[16,6589.64,6426.46,6589.64,6426.46,6589.64,6426.46,null,null,16000000,1.32,null,900000,{"$f":"ROUND(M55/$M$33*$N$33,2)","v":11987.44}]
[17,6625.9,6528.29,6625.9,6528.29,6625.9,6528.29,null,null,18000000,1.33]
[18,6819.73,6168.12,6819.73,6168.12,6819.73,6168.12,null,null,20000000,1.34]
[19,7051.24,6259.8,7051.24,6259.8,7051.24,6259.8,null,null,22000000,1.35]
[20,7265.19,7264.01,7265.19,7264.01,7265.19,7264.01,null,null,24000000,1.36]
[21,7647.45,9419.34,7647.45,9419.34,7647.45,9419.34,null,null,26000000,1.37]
[22,7990.45,9874.5499999999993,7990.45,9874.5499999999993,7990.45,9874.5499999999993,null,null,28000000,1.38]
[23,8517.9500000000007,10347.18,8517.9500000000007,10347.18,8517.9500000000007,10347.18,null,null,30000000,1.39]
[24,8872.17,10840.06,8872.17,10840.06,8872.17,10840.06,null,null,40000000,1.42]
[25,9222.6,11348.45,9222.6,11348.45,9222.6,11348.45,null,null,50000000,1.45]
[26,9848.7000000000007,11892.2,9848.7000000000007,11892.2,9848.7000000000007,11892.2,null,null,60000000,1.46]
[27,10282.52,12441.62,10282.52,12441.62,10282.52,12441.62,null,null,70000000,1.48]
[28,10892.86,13032.79,10892.86,13032.79,10892.86,13032.79,null,null,100000000,1.53]
[29,11459.63,13634.28,11459.63,13634.28,11459.63,13634.28]
[30,11991.45,14281.28,11991.45,14281.28,11991.45,14281.28]
[31,12489.54,14949.02,12489.54,14949.02,12489.54,14949.02]
[32,{"$f":"IF($A$37=$C$130,ROUND(C164*(1-DESC),2),ROUND(E164*(1-DESC),2))","v":13255.86},{"$f":"IF($A$37=$C$130,ROUND(D164*(1-DESC),2),ROUND(F164*(1-DESC),2))","v":15637.63},13255.86,15637.63,{"$f":"ROUND(D71*$G$37,2)","v":13255.86},{"$f":"ROUND(E71*$G$37,2)","v":15637.63}]
[33,13735.79,16208.65,{"$f":"B72","v":13735.79},16208.65,13735.79,16208.65]
[34,14520.09,16958.52,14520.09,{"$f":"C73","v":16958.52},14520.09,16958.52]
[35,15336.16,17747.21,15336.16,17747.21,15336.16,17747.21]
[36,16004.34,18562.48,16004.34,18562.48,16004.34,18562.48]
[37,16884,19442.080000000002,16884,19442.080000000002,16884,19442.080000000002]
[38,17812.78,20325.439999999999,17812.78,20325.439999999999,17812.78,20325.439999999999]
[39,18805.88,21259.279999999999,18805.88,21259.279999999999,18805.88,21259.279999999999]
[40,19473.18,22230.240000000002,19473.18,22230.240000000002,19473.18,22230.240000000002]
[41,20204.39,23249.33,20204.39,23249.33,20204.39,23249.33]
[42,21001.95,24312.41,21001.95,24312.41,21001.95,24312.41]
[43,21864.959999999999,25420.98,21864.959999999999,25420.98,21864.959999999999,25420.98]
[44,22819.46,26700.38,22819.46,26700.38,22819.46,26700.38]
[45,23857.66,27964.35,23857.66,27964.35,23857.66,27964.35]
[46,25004.76,29044.86,25004.76,29044.86,25004.76,29044.86]
[47,26257.33,30538.05,26257.33,30538.05,26257.33,30538.05]
[48,27630.6,31787.82,27630.6,31787.82,27630.6,31787.82]
[49,29133.77,33137.160000000003,29133.77,33137.160000000003,29133.77,33137.160000000003]
[50,30772.28,34564.14,30772.28,34564.14,30772.28,34564.14]
[51,32536.15,36102.97,32536.15,36102.97,32536.15,36102.97]
[52,34459.83,37751.29,34459.83,37751.29,34459.83,37751.29]
[53,36562.410000000003,39519.4,36562.410000000003,39519.4,36562.410000000003,39519.4]
[54,38838.239999999998,41399.589999999997,38838.239999999998,41399.589999999997,38838.239999999998,41399.589999999997]
[55,41263.480000000003,43358.49,41263.480000000003,43358.49,41263.480000000003,43358.49]
[56,43907.07,46001.58,43907.07,46001.58,43907.07,46001.58]
[57,46743.42,47794.59,46743.42,47794.59,46743.42,47794.59]
[58,48777.47,49728.61,48777.47,49728.61,48777.47,49728.61]
[59,51975.72,50587,51975.72,50587,51975.72,50587]
[60,69402.740000000005,68905.960000000006,69402.740000000005,68905.960000000006,69402.740000000005,68905.960000000006]
[61,73238.990000000005,71930.13,73238.990000000005,71930.13,73238.990000000005,71930.13]
[62,77145.19,75041.95,77145.19,75041.95,77145.19,75041.95]
[63,81435.78,78314.67,81435.78,78314.67,81435.78,78314.67]
[64,{"$f":"IF($A$37=$C$130,ROUND(C196*(1-DESC),2),ROUND(E196*(1-DESC),2))","v":85761.32},{"$f":"IF($A$37=$C$130,ROUND(D196*(1-DESC),2),ROUND(F196*(1-DESC),2))","v":81793.429999999993},85761.32,81793.429999999993,{"$f":"ROUND(D103*$G$37,2)","v":85761.32},{"$f":"ROUND(E103*$G$37,2)","v":81793.429999999993}]
[65,90339.87,85386.07,{"$f":"B104","v":90339.87},85386.07,90339.87,85386.07]
[66,95132.5,89184.03,95132.5,{"$f":"C105","v":89184.03},95132.5,89184.03]
[{"$f":"+A105+1","v":67},100077.75999999999,93035.05,100077.75999999999,93035.05,100077.75999999999,93035.05]
[68,105302.25,97108.85,105302.25,97108.85,105302.25,97108.85]
[69,110507.49,101417.29,110507.49,101417.29,110507.49,101417.29]
[70,116051.9,105828.44,116051.9,105828.44,116051.9,105828.44]
[71,121870.68,110273.55,121870.68,110273.55,121870.68,110273.55]
[72,127707.53,115114.48,127707.53,115114.48,127707.53,115114.48]
[73,133881.18,119998.29,133881.18,119998.29,133881.18,119998.29]
[74,140095.79,124966.98,140095.79,124966.98,140095.79,124966.98]
[75,146539.84,130076.54,146539.84,130076.54,146539.84,130076.54]
[76,154118.04,135852.78,154118.04,135852.78,154118.04,135852.78]
[77,161925.42000000001,142014.06,161925.42000000001,142014.06,161925.42000000001,142014.06]
[78,170229.8,148405.04999999999,170229.8,148405.04999999999,170229.8,148405.04999999999]
[79,179655.48,154794.95000000001,179655.48,154794.95000000001,179655.48,154794.95000000001]
[80,188656.95,161504.35999999999,188656.95,161504.35999999999,188656.95,161504.35999999999]
[81,198972.08,168271.8,198972.08,168271.8,198972.08,168271.8]
[82,209490.34,175111.75,209490.34,175111.75,209490.34,175111.75]
[83,220555.07,182858.71,220555.07,182858.71,220555.07,182858.71]
[84,232613.37,190414.64,232613.37,190414.64,232613.37,190414.64]
[85,244552.46,197720.65,244552.46,197720.65,244552.46,197720.65]
[]
[]
[]
[]
[null,null,"Renovada",null,"Nueva",null,null,null,null,null,null,null,"Tarifa 2015-2016"]
[null,null,1,"Renovada",0,"Nueva",null,null,null,null,null,null,null,1,"Renovada",0,"Nueva"]
["E D A D","Auxiliar por zona","HOMBRES","MUJERES","HOMBRES","MUJERES",null,null,{"$f":"AVERAGE(I132:J217)","v":0.69767441860465118},null,null,null,"E D A D","HOMBRES","MUJERES","HOMBRES","MUJERES"]
[0,{"$f":"+CONCATENATE(A132,$H$36)","v":"0B"},{"$f":"+VLOOKUP($B132,$B$237:$F$445,2,FALSE)","v":6985.4160371232028},{"$f":"+VLOOKUP($B132,$B$237:$F$445,3,FALSE)","v":6989.7589500996564},{"$f":"+VLOOKUP($B132,$B$237:$F$445,4,FALSE)","v":6985.4160371232028},{"$f":"+VLOOKUP($B132,$B$237:$F$445,5,FALSE)","v":6989.7589500996564},{"$f":"+B39","v":6985.42},{"$f":"+C39","v":6989.76},{"$f":"IF(ROUND(C132,2)=G132,1,0)","v":1},1,null,null,0,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[1,"1B",{"$f":"+VLOOKUP($B133,$B$237:$F$445,2,FALSE)","v":6985.4160371232028},{"$f":"+VLOOKUP($B133,$B$237:$F$445,3,FALSE)","v":6989.7589500996564},{"$f":"+VLOOKUP($B133,$B$237:$F$445,4,FALSE)","v":6985.4160371232028},{"$f":"+VLOOKUP($B133,$B$237:$F$445,5,FALSE)","v":6989.7589500996564},{"$f":"+B40","v":6985.42},{"$f":"+C40","v":6989.76},1,1,null,null,1,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[{"$f":"+A133+1","v":2},"2B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,1,1,null,null,{"$f":"+M133+1","v":2},5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[{"$f":"+A134+1","v":3},"3B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,1,1,null,null,3,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[4,"4B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,1,1,null,null,4,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[5,"5B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,1,1,null,null,5,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[6,"6B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,{"$f":"IF(ROUND(C138,2)=G138,1,0)","v":1},{"$f":"IF(ROUND(D138,2)=H138,1,0)","v":1},null,null,6,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[7,"7B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,{"$f":"IF(ROUND(C139,2)=G139,1,0)","v":1},{"$f":"IF(ROUND(D139,2)=H139,1,0)","v":1},null,null,7,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[8,"8B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,{"$f":"IF(ROUND(C140,2)=G140,1,0)","v":1},{"$f":"IF(ROUND(D140,2)=H140,1,0)","v":1},null,null,8,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[9,"9B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,{"$f":"IF(ROUND(C141,2)=G141,1,0)","v":1},{"$f":"IF(ROUND(D141,2)=H141,1,0)","v":1},null,null,9,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[10,"10B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,6985.42,6989.76,1,1,null,null,10,5283.5845045045053,5286.8693693693704,5283.5845045045053,5286.8693693693704]
[11,"11B",6946.0061024301258,6882.916040303674,6946.0061024301258,6882.916040303674,6946.01,6882.92,1,1,null,null,11,5347.1475675675683,5298.5798198198208,5347.1475675675683,5298.5798198198208]
[12,"12B",6913.9909696429932,6977.0087084273064,6913.9909696429932,6977.0087084273064,6913.99,6977.01,1,1,null,null,12,5322.5018018018027,5371.0138738738751,5322.5018018018027,5371.0138738738751]
[13,"13B",6866.2575638308508,6931.1074939493683,6866.2575638308508,6931.1074939493683,6866.26,6931.11,1,1,null,null,13,5285.7558558558567,5335.6783783783794,5285.7558558558567,5335.6783783783794]
[14,"14B",6687.9805254567164,6789.9805456542772,6687.9805254567164,6789.9805456542772,6687.98,6789.98,1,1,null,null,14,5148.515315315316,5227.0365765765773,5148.515315315316,5227.0365765765773]
[15,"15B",6715.2223176626367,6679.7838800142299,6715.2223176626367,6679.7838800142299,6715.22,6679.78,1,1,null,null,15,5169.4864864864876,5142.205405405407,5169.4864864864876,5142.205405405407]
[16,"16B",6589.6448879275622,6426.4593202798924,6589.6448879275622,6426.4593202798924,6589.64,6426.46,1,1,null,null,16,5072.8149549549553,4947.1920720720718,5072.8149549549553,4947.1920720720718]
[17,"17B",6625.9029901202193,6528.290586012462,6625.9029901202193,6528.290586012462,6625.9,6528.29,1,1,null,null,17,5100.7270270270274,5025.5834234234244,5100.7270270270274,5025.5834234234244]
[18,"18B",6819.7295470543695,6168.1203421572118,6819.7295470543695,6168.1203421572118,6819.73,6168.12,1,1,null,null,18,5249.9378378378378,4748.3185585585588,5249.9378378378378,4748.3185585585588]
[19,"19B",7051.2365652432572,6259.802232209523,7051.2365652432572,6259.802232209523,7051.24,6259.8,1,1,null,null,19,5428.1556756756763,4818.8967567567579,5428.1556756756763,4818.8967567567579]
[20,"20B",7265.1931190729301,7264.0118378179841,7265.1931190729301,7264.0118378179841,7265.19,7264.01,1,1,null,null,20,5592.8628828828832,5591.9535135135138,5592.8628828828832,5591.9535135135138]
[21,"21B",7647.446090061474,9419.3438647011626,7647.446090061474,9419.3438647011626,7647.45,9419.34,1,1,null,null,21,5887.1273873873879,7251.1628828828834,5887.1273873873879,7251.1628828828834]
[22,"22B",7990.4515940489227,9874.5469801278632,7990.4515940489227,9874.5469801278632,7990.45,9874.5499999999993,1,1,null,null,22,6151.1785585585585,7601.5855855855871,6151.1785585585585,7601.5855855855871]
[23,"23B",8517.9539438345146,10347.180021010203,8517.9539438345146,10347.180021010203,8517.9500000000007,10347.18,1,1,null,null,23,6557.2583783783793,7965.4261261261281,6557.2583783783793,7965.4261261261281]
[24,"24B",8872.1695658536028,10840.063597691636,8872.1695658536028,10840.063597691636,8872.17,10840.06,1,1,null,null,24,6829.9392792792805,8344.855855855858,6829.9392792792805,8344.855855855858]
[25,"25B",9222.6002663007184,11348.448477371656,9222.6002663007184,11348.448477371656,9222.6,11348.45,1,1,null,null,25,7099.7064864864878,8736.2187387387403,7099.7064864864878,8736.2187387387403]
[26,"26B",9848.7034392033092,11892.199471357942,9848.7034392033092,11892.199471357942,9848.7000000000007,11892.2,1,1,null,null,26,7581.6908108108128,9154.8070270270291,7581.6908108108128,9154.8070270270291]
[27,"27B",10282.522953137392,12441.615793811832,10282.522953137392,12441.615793811832,10282.52,12441.62,1,1,null,null,27,7915.6520720720728,9577.7565765765776,7915.6520720720728,9577.7565765765776]
[28,"28B",10892.859637453545,13032.786792460995,10892.859637453545,13032.786792460995,10892.86,13032.79,1,1,null,null,28,8385.4990990990991,10032.849549549552,8385.4990990990991,10032.849549549552]
[29,"29B",11459.633562020947,13634.275921255401,11459.633562020947,13634.275921255401,11459.63,13634.28,1,1,null,null,29,8821.8108108108117,10495.885585585587,8821.8108108108117,10495.885585585587]
[30,"30B",11991.4512045542,14281.28054003634,11991.4512045542,14281.28054003634,11991.45,14281.28,1,1,null,null,30,9231.212612612615,10993.960180180184,9231.212612612615,10993.960180180184]
[31,"31B",12489.542061869681,14949.017850230626,12489.542061869681,14949.017850230626,12489.54,14949.02,1,1,null,null,31,9614.6509909909928,11507.995135135136,9614.6509909909928,11507.995135135136]
[32,{"$f":"+CONCATENATE(A164,$H$36)","v":"32B"},13255.85608740026,15637.632498522551,13255.85608740026,15637.632498522551,13255.86,15637.63,1,1,null,null,32,10204.571891891894,12038.101801801804,10204.571891891894,12038.101801801804]
[33,"33B",13735.793785838698,16208.649392495476,13735.793785838698,16208.649392495476,13735.79,16208.65,1,1,null,null,33,10574.035675675676,12477.679819819821,10574.035675675676,12477.679819819821]
[34,"34B",14520.092215781326,16958.521911579646,14520.092215781326,16958.521911579646,14520.09,16958.52,1,1,null,null,{"$f":"+M165+1","v":34},11177.801261261262,13054.943783783785,11177.801261261262,13054.943783783785]
[35,"35B",15336.16470070395,17747.207957612081,15336.16470070395,17747.207957612081,15336.16,17747.21,1,1,null,null,35,11806.027027027028,13662.08702702703,11806.027027027028,13662.08702702703]
[36,"36B",16004.335950951085,18562.48488577117,16004.335950951085,18562.48488577117,16004.34,18562.48,1,1,null,null,36,12320.396036036038,14289.700360360363,12320.396036036038,14289.700360360363]
[37,"37B",16884.004761395136,19442.081372873086,16884.004761395136,19442.081372873086,16884,19442.080000000002,1,1,null,null,37,12997.57927927928,14966.82792792793,12997.57927927928,14966.82792792793]
[38,"38B",17812.781121151987,20325.438673766257,17812.781121151987,20325.438673766257,17812.78,20325.439999999999,1,1,null,null,38,13712.566306306309,15646.850630630632,13712.566306306309,15646.850630630632]
[39,"39B",18805.877039851661,21259.277667472888,18805.877039851661,21259.277667472888,18805.88,21259.279999999999,1,1,null,null,39,14477.067567567568,16365.734954954958,14477.067567567568,16365.734954954958]
[40,"40B",19473.180409993114,22230.242643477843,19473.180409993114,22230.242643477843,19473.18,22230.240000000002,1,1,null,null,40,14990.76846846847,17113.199459459465,14990.76846846847,17113.199459459465]
[41,"41B",20204.393506805271,23249.326749786345,20204.393506805271,23249.326749786345,20204.39,23249.33,1,1,null,null,41,15553.668108108113,17897.70684684685,15553.668108108113,17897.70684684685]
[42,"42B",21001.951216140162,24312.407555896447,21001.951216140162,24312.407555896447,21001.95,24312.41,1,1,null,null,42,16167.640900900906,18716.083603603605,16167.640900900906,18716.083603603605]
[43,"43B",21864.961550111391,25420.979744212367,21864.961550111391,25420.979744212367,21864.959999999999,25420.98,1,1,null,null,43,16832.000180180181,19569.480360360361,16832.000180180181,19569.480360360361]
[44,"44B",22819.460911889229,26700.37966666204,22819.460911889229,26700.37966666204,22819.46,26700.38,1,1,null,null,44,17566.789189189192,20554.383063063065,17566.789189189192,20554.383063063065]
[45,"45B",23857.662488303307,27964.35060945525,23857.662488303307,27964.35060945525,23857.66,27964.35,1,1,null,null,45,18366.013513513517,21527.408288288287,18366.013513513517,21527.408288288287]
[46,"46B",25004.758910198918,29044.861341021016,25004.758910198918,29044.861341021016,25004.76,29044.86,1,1,null,null,46,19249.066846846847,22359.202882882888,19249.066846846847,22359.202882882888]
[47,"47B",26257.326872714799,30538.049062835365,26257.326872714799,30538.049062835365,26257.33,30538.05,1,1,null,null,47,20213.313873873874,23508.682882882884,20213.313873873874,23508.682882882884]
[48,"48B",27630.602493261686,31787.820522788512,27630.602493261686,31787.820522788512,27630.6,31787.82,1,1,null,null,48,21270.483603603607,24470.777117117119,21270.483603603607,24470.777117117119]
[49,"49B",29133.770836291296,33137.15711708719,29133.770836291296,33137.15711708719,29133.77,33137.160000000003,1,1,null,null,49,22427.646846846848,25509.518198198202,22427.646846846848,25509.518198198202]
[50,"50B",30772.280260244846,34564.144873063087,30772.280260244846,34564.144873063087,30772.28,34564.14,1,1,null,null,50,23688.99783783784,26608.036396396401,23688.99783783784,26608.036396396401]
[51,"51B",32536.150143907042,36102.968623767527,32536.150143907042,36102.968623767527,32536.15,36102.97,1,1,null,null,51,25046.85333333334,27792.647747747749,25046.85333333334,27792.647747747749]
[52,"52B",34459.83050591706,37751.289914471337,34459.83050591706,37751.289914471337,34459.83,37751.29,1,1,null,null,52,26527.733513513518,29061.552072072074,26527.733513513518,29061.552072072074]
[53,"53B",36562.414708599747,39519.402767539068,36562.414708599747,39519.402767539068,36562.410000000003,39519.4,1,1,null,null,53,28146.336756756758,30422.673873873875,28146.336756756758,30422.673873873875]
[54,"54B",38838.237423487517,41399.592693142455,38838.237423487517,41399.592693142455,38838.239999999998,41399.589999999997,1,1,null,null,54,29898.301801801805,31870.074414414416,29898.301801801805,31870.074414414416]
[55,"55B",41263.480163235727,43358.494522774476,41263.480163235727,43358.494522774476,41263.480000000003,43358.49,1,1,null,null,55,31765.292792792796,33378.068648648659,31765.292792792796,33378.068648648659]
[56,"56B",43907.067072903403,46001.575169047173,43907.067072903403,46001.575169047173,43907.07,46001.58,1,1,null,null,56,33800.368648648655,35412.754774774781,33800.368648648655,35412.754774774781]
[57,"57B",46743.419797153838,47794.591359591621,46743.419797153838,47794.591359591621,46743.42,47794.59,1,1,null,null,57,35983.838738738741,36793.04756756757,35983.838738738741,36793.04756756757]
[58,"58B",48777.465579268915,49728.613959527604,48777.465579268915,49728.613959527604,48777.47,49728.61,1,1,null,null,58,37549.680000000008,38281.889369369375,37549.680000000008,38281.889369369375]
[59,"59B",51975.724307585959,50586.995599601905,51975.724307585959,50586.995599601905,51975.72,50587,1,1,null,null,59,40011.751171171178,38942.685405405406,40011.751171171178,38942.685405405406]
[60,"60B",55133.016027916048,54738.376764412329,69402.737823376665,68905.956632848465,69402.740000000005,68905.960000000006,0,0,null,null,60,42437.212897196274,42133.449532710285,53420.962117647076,53038.577647058832]
[61,"61B",58180.502560084533,57140.753911089167,73238.985575635816,71930.125511606355,73238.990000000005,71930.13,0,0,null,null,61,44782.936822429918,43982.617196261686,56373.814588235306,55366.353411764714]
[62,"62B",61283.56574604343,59612.764452974145,77145.194527372325,75041.950546685097,77145.19,75041.95,0,0,null,null,62,47171.439439252339,45885.383364485984,59380.51788235295,57761.600235294121]
[63,"63B",64691.975371909393,62212.586291379856,81435.78076228594,78314.66744914875,81435.78,78314.67,0,0,null,null,63,49794.974579439266,47886.528971962623,62683.085647058841,60280.68941176471]
[64,{"$f":"+CONCATENATE(A196,$H$36)","v":"64B"},68128.148312675126,64976.086627717385,85761.316111249878,81793.426696067778,85761.32,81793.429999999993,0,0,null,null,64,52439.879813084117,50013.661869158888,66012.554588235304,62958.374352941195]
[65,"65B",{"$f":"+VLOOKUP($B197,$B$237:$F$445,2,FALSE)","v":71765.317648517303},{"$f":"+VLOOKUP($B197,$B$237:$F$445,3,FALSE)","v":67830.055351435614},{"$f":"+VLOOKUP($B197,$B$237:$F$445,4,FALSE)","v":90339.87045166298},{"$f":"+VLOOKUP($B197,$B$237:$F$445,5,FALSE)","v":85386.069677689535},{"$f":"+B104","v":90339.87},{"$f":"+C104","v":85386.07},{"$f":"IF(ROUND(C197,2)=G197,1,0)","v":0},{"$f":"IF(ROUND(D197,2)=H197,1,0)","v":0},null,null,65,55239.496822429923,52210.430467289727,69536.778352941197,65723.718352941185]
[66,"66B",75572.543541119609,70847.127297191342,95132.495987056449,89184.030832934994,95132.5,89184.03,0,0,null,null,{"$f":"+M197+1","v":66},58170.010467289729,54532.743551401873,73225.777882352952,68647.10070588236]
[{"$f":"+A198+1","v":67},"67B",79501.027587446501,73906.344455204904,100077.76413949145,93035.045373022629,100077.75999999999,93035.05,0,0,null,null,67,61193.859439252352,56887.496822429923,77032.270117647073,71611.319529411776]
[68,"68B",83651.318009026945,77142.546492705849,105302.24737606918,97108.852643759121,105302.25,97108.85,0,0,null,null,68,64388.438130841139,59378.479626168242,81053.680941176484,74747.027294117666]
[69,"69B",87786.326101414787,80565.137919966539,110507.49285707511,101417.2912639579,110507.49,101417.29,0,0,null,null,69,67571.25364485984,62012.930841121502,85060.284000000029,78063.336470588241]
[70,"70B",92190.763408307757,84069.318476239132,116051.90217281094,105828.436199501,116051.9,105828.44,0,0,null,null,70,70961.455327102827,64710.183177570099,89327.949647058849,81458.701176470597]
[71,"71B",96813.155243161862,87600.486975553897,121870.67777668613,110273.55419275611,121870.68,110273.55,0,0,null,null,71,74519.42186915889,67428.208785046736,93806.801647058848,84880.215764705892]
[72,"72B",101449.90396337862,91446.081269107846,127707.52616566484,115114.47877405339,127707.53,115114.48,0,0,null,null,72,78088.439252336466,70388.255514018703,98299.564705882367,88606.39223529413]
[73,"73B",106354.20599844509,95325.741900403737,133881.17696274852,119998.28686286118,133881.18,119998.29,0,0,null,null,73,81863.398878504682,73374.523925233661,103051.57270588237,92365.577176470615]
[74,"74B",111291.04863953378,99272.834871312094,140095.79064035427,124966.9803674164,140095.79,124966.98,0,0,null,null,74,85663.405794392544,76412.696635514032,107835.11082352944,96190.100470588251]
[75,"75B",116410.15369114034,103331.83150966345,146539.84052884724,130076.54084157637,146539.84,130076.54,0,0,null,null,75,89603.704485981332,79537.004299065447,112795.25152941179,100123.05247058827]
[76,"76B",122430.21582923863,107920.43213872513,154118.03639680627,135852.7792805128,154118.04,135852.78,0,0,null,null,76,94237.491588785051,83068.96093457946,118628.37176470589,104569.16258823533]
[77,"77B",128632.34028189165,112814.90445959734,161925.41659014596,142014.05620208132,161925.42000000001,142014.06,0,0,null,null,77,99011.41644859816,86836.354392523383,124637.90070588239,109311.64611764708]
[78,"78B",135229.27908201618,117891.86429894609,170229.79837383211,148405.05270573209,170229.8,148405.04999999999,0,0,null,null,78,104089.23943925236,90744.212897196267,131029.9837647059,114230.95035294119]
[79,"79B",142716.97007450709,122967.94871845566,179655.47997614427,154794.94721029126,179655.48,154794.95000000001,0,0,null,null,79,109852.69588785048,94651.397570093468,138285.15835294122,119149.40635294119]
[80,"80B",149867.67445290339,128297.85486733749,188656.9548995372,161504.35848006015,188656.95,161504.35999999999,0,0,null,null,80,115356.76560747666,98753.954953271037,145213.81082352943,124313.80211764706]
[81,"81B",158061.92930359664,133673.85812375118,198972.07571158637,168271.797873428,198972.08,168271.8,0,0,null,null,81,121664.08130841123,102891.99439252338,153153.60823529414,129522.8635294118]
[82,"82B",166417.56154864444,139107.46400558311,209490.34218476416,175111.74880702817,209490.34,175111.75,0,0,null,null,82,128095.61308411218,107074.37196261685,161249.77176470592,134787.73882352945]
[83,"83B",175207.30198594535,145261.59043905349,220555.07426466071,182858.70796445556,220555.07,182858.71,0,0,null,null,83,134861.28841121498,111811.35158878507,169766.56305882358,140750.76023529415]
[84,"84B",184786.32095025372,151263.96909640028,232613.36872561352,190414.64345076276,232613.37,190414.64,0,0,null,null,84,142234.49046728975,116431.52728971966,179048.12329411769,146566.7461176471]
[85,"85B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,244552.46,197720.65,0,0,null,null,85,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[86,"86B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,86,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[87,"87B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,87,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[88,"88B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,88,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[89,"89B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,89,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[90,"90B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,90,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[91,"91B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,91,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[92,"92B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,92,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[93,"93B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,93,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[94,"94B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,94,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[95,"95B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,95,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[96,{"$f":"+CONCATENATE(A228,$H$36)","v":"96B"},194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,96,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[97,"97B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,97,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[98,"98B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,98,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[99,"99B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,99,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[100,"100B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,100,149534.80317757014,120898.87794392525,188237.9287058824,152190.35223529415]
[]
[]
[null,null,null,"Tarifas de zona 1 y 2",null,null,null,null,null,null,null,null,null,"Tarifas de zona 1 y 2",null,null,"Tarifa 2017 - 2018"]
[null,"A","Renovada","Renovada","Nueva","Nueva",null,null,null,null,null,null,"Renovada","Renovada","Nueva","Nueva"]
["E D A D","Auxiliar por zona","HOMBRES","MUJERES","HOMBRES","MUJERES",null,"Nombre de Zona","Zona","Auxiliar",null,null,"HOMBRES","MUJERES","HOMBRES","MUJERES"]
[0,{"$f":"+CONCATENATE(A238,$B$236)","v":"0A"},7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,"Zona 1",1,"A",null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[1,{"$f":"+CONCATENATE(A239,$B$236)","v":"1A"},7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,"Zona 2",2,"A",null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[2,"2A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,"Zona 3",3,"B",null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[3,"3A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,"Zona 4",4,"B",null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[4,"4A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,"Zona 5",5,"B",null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[5,"5A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,null,null,null,null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[6,"6A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,null,null,null,null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[7,"7A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,null,null,null,null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[8,"8A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,null,null,null,null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[9,"9A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,null,null,null,null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[10,"10A",7228.090626519639,7232.584413061496,7228.090626519639,7232.584413061496,null,null,null,null,null,null,6340.3653325526066,6344.3072101346825,6340.3653325526066,6344.3072101346825]
[11,"11A",7315.0466655358232,7248.6046351400983,7315.0466655358232,7248.6046351400983,null,null,null,null,null,null,6416.6417772905133,6358.3598923623085,6416.6417772905133,6358.3598923623085]
[12,"12A",7281.3305721596207,7347.6964366817556,7281.3305721596207,7347.6964366817556,null,null,null,null,null,null,6387.0665601775381,6445.2816336213027,6387.0665601775381,6445.2816336213027]
[13,"13A",7231.06109558968,7299.3564955761158,7231.06109558968,7299.3564955761158,null,null,null,null,null,null,6342.9709804458425,6402.8786114954701,6342.9709804458425,6402.8786114954701]
[14,"14A",7043.3122171883115,7150.7314875758966,7043.3122171883115,7150.7314875758966,null,null,null,null,null,null,6178.2806712964057,6272.5071348543861,6178.2806712964057,6272.5071348543861]
[15,"15A",7072.0013629075211,7034.6800848480216,7072.0013629075211,7034.6800848480216,null,null,null,null,null,null,6203.4463304362125,6170.7087030596513,6203.4463304362125,6170.7087030596513]
[16,"16A",6939.7520177293281,6767.8964182839109,6939.7520177293281,6767.8964182839109,null,null,null,null,null,null,6087.4393229501502,5936.690343554269,6087.4393229501502,5936.690343554269]
[17,"17A",6977.9365090228594,6875.1379682997849,6977.9365090228594,6875.1379682997849,null,null,null,null,null,null,6120.9341471503876,6030.7609136485544,6120.9341471503876,6030.7609136485544]
[18,"18A",7182.0610502462532,6495.831917817507,7182.0610502462532,6495.831917817507,null,null,null,null,null,null,6299.9889254548461,5698.0397211275795,6299.9889254548461,5698.0397211275795]
[19,"19A",7425.8680116104651,6592.3848569061356,7425.8680116104651,6592.3848569061356,null,null,null,null,null,null,6513.8524871535692,5782.7344129051744,6513.8524871535692,5782.7344129051744]
[20,"20A",7651.1920543166361,7649.9480117146531,7651.1920543166361,7649.9480117146531,null,null,null,null,null,null,6711.5031286277081,6710.4118743818217,6711.5031286277081,6710.4118743818217]
[21,"21A",8053.754084868644,9919.7925992191704,8053.754084868644,9919.7925992191704,null,null,null,null,null,null,7064.6240943982939,8701.483192731559,7064.6240943982939,8701.483192731559]
[22,"22A",8414.9834346853659,10399.180607599788,8414.9834346853659,10399.180607599788,null,null,null,null,null,null,7381.4886946117058,9121.9946758092719,7381.4886946117058,9121.9946758092719]
[23,"23A",8970.5119280322706,10896.924591515788,8970.5119280322706,10896.924591515788,null,null,null,null,null,null,7868.7893916365674,9558.6077266374959,7868.7893916365674,9558.6077266374959]
[24,"24A",9343.5469882555699,11415.99502003722,9343.5469882555699,11415.99502003722,null,null,null,null,null,null,8196.0097719384848,10013.92799310947,8196.0097719384848,10013.92799310947]
[25,"25A",9712.5960344276173,11951.390334131615,9712.5960344276173,11951.390334131615,null,null,null,null,null,null,8519.733684554607,10483.568187746838,8519.733684554607,10483.568187746838]
[26,"26A",10371.964002103336,12524.030760411919,10371.964002103336,12524.030760411919,null,null,null,null,null,null,9098.1207053686776,10985.879198276325,9098.1207053686776,10985.879198276325]
[27,"27A",10828.832300525593,13102.637513456835,10828.832300525593,13102.637513456835,null,null,null,null,null,null,9498.8782595463817,11493.423775087098,9498.8782595463817,11493.423775087098]
[28,"28A",11471.596107758513,13725.217364188191,11471.596107758513,13725.217364188191,null,null,null,null,null,null,10062.7003767521,12039.540848915702,10062.7003767521,12039.540848915702]
[29,"29A",12068.482670465233,14358.663546218499,12068.482670465233,14358.663546218499,null,null,null,null,null,null,10586.279709828948,12595.189694524688,10586.279709828948,12595.189694524688]
[30,"30A",12628.555727603052,15040.043451361966,12628.555727603052,15040.043451361966,null,null,null,null,null,null,11077.566825425512,13192.885234342486,11077.566825425512,13192.885234342486]
[31,"31A",13153.110099023021,15743.257573601461,13153.110099023021,15743.257573601461,null,null,null,null,null,null,11537.697518777308,13809.733399700308,11537.697518777308,13809.733399700308]
[32,"32A",13960.138306966808,16468.458244684178,13960.138306966808,16468.458244684178,null,null,null,null,null,null,12245.609737429528,14445.867813567047,12245.609737429528,14445.867813567047]
[33,"33A",14465.575044115476,17069.813205308223,14465.575044115476,17069.813205308223,null,null,null,null,null,null,12688.970748186388,14973.366753731154,12688.970748186388,14973.366753731154]
[34,"34A",15291.543165958847,17859.526371322358,15291.543165958847,17859.526371322358,null,null,null,null,null,null,13413.496755969842,15666.090494920232,13413.496755969842,15666.090494920232]
[35,"35A",16150.973494933112,18690.115222830245,16150.973494933112,18690.115222830245,null,null,null,null,null,null,14167.375275918133,16394.669732759838,14167.375275918133,16394.669732759838]
[36,"36A",16854.644612414162,19548.707727195011,16854.644612414162,19548.707727195011,null,null,null,null,null,null,14784.624310182611,17147.813326379262,14784.624310182611,17147.813326379262]
[37,"37A",17781.050132899287,20475.037081806549,17781.050132899287,20475.037081806549,null,null,null,null,null,null,15597.252395450196,17960.374600162409,15597.252395450196,17960.374600162409]
[38,"38A",18759.172281552583,21405.327061844804,18759.172281552583,21405.327061844804,null,null,null,null,null,null,16455.245478653884,18776.410071136539,16455.245478653884,18776.410071136539]
[39,"39A",19805.03128045264,22388.780821649463,19805.03128045264,22388.780821649463,null,null,null,null,null,null,17372.656242021279,19639.079958251161,17372.656242021279,19639.079958251161]
[40,"40A",20507.788407450596,23411.333063230737,20507.788407450596,23411.333063230737,null,null,null,null,null,null,17989.103538472456,20536.046407379326,17989.103538472456,20536.046407379326]
[41,"41A",21277.850778078307,24484.560999374426,21277.850778078307,24484.560999374426,null,null,null,null,null,null,18664.589916675508,21477.464764156197,18664.589916675508,21477.464764156197]
[42,"42A",22117.782643413328,25604.123175285869,22117.782643413328,25604.123175285869,null,null,null,null,null,null,19401.364696606663,22459.526773968599,19401.364696606663,22459.526773968599]
[43,"43A",23026.644624348035,26771.593685685941,23026.644624348035,26771.593685685941,null,null,null,null,null,null,20198.60386995778,23483.613207495,20198.60386995778,23483.613207495]
[44,"44A",24031.856435375132,28118.967989507528,24031.856435375132,28118.967989507528,null,null,null,null,null,null,21080.359571127989,24665.508367273316,21080.359571127989,24665.508367273316]
[45,"45A",25125.217550771336,29450.093573629725,25125.217550771336,29450.093573629725,null,null,null,null,null,null,22039.438430292361,25833.150410370672,22039.438430292361,25833.150410370672]
[46,"46A",26333.259083170775,30588.011725076572,26333.259083170775,30588.011725076572,null,null,null,null,null,null,23099.113114531505,26831.313987933601,23099.113114531505,26831.313987933601]
[47,"47A",27652.375847890169,32160.53235123261,27652.375847890169,32160.53235123261,null,null,null,null,null,null,24256.221213581852,28210.703895722352,24256.221213581852,28210.703895722352]
[48,"48A",29098.61345563264,33476.704035506489,29098.61345563264,33476.704035506489,null,null,null,null,null,null,25524.837680165841,29365.22861737428,25524.837680165841,29365.22861737428]
[49,"49A",30681.644972344209,34897.730739090402,30681.644972344209,34897.730739090402,null,null,null,null,null,null,26913.447572807581,30611.730482607978,26913.447572807581,30611.730482607978]
[50,"50A",32407.208227168747,36400.534202286311,32407.208227168747,36400.534202286311,null,null,null,null,null,null,28427.084023335061,31929.965611637526,28427.084023335061,31929.965611637526]
[51,"51A",34264.792329550692,38021.115494678153,34264.792329550692,38021.115494678153,null,null,null,null,null,null,30056.527046895269,33351.513566109155,30056.527046895269,33351.513566109155]
[52,"52A",36290.677623943819,39757.011919686505,36290.677623943819,39757.011919686505,null,null,null,null,null,null,31833.601180577403,34874.21410802591,31833.601180577403,34874.21410802591]
[53,"53A",38504.971900976096,41619.064419985792,38504.971900976096,41619.064419985792,null,null,null,null,null,null,33775.944656274136,36507.576738673386,33775.944656274136,36507.576738673386]
[54,"54A",40901.708833882927,43599.148635726291,40901.708833882927,43599.148635726291,null,null,null,null,null,null,35878.323907704173,38244.47489971108,35878.323907704173,38244.47489971108]
[55,"55A",43455.804461628388,45662.126710558165,43455.804461628388,45662.126710558165,null,null,null,null,null,null,38118.73568599132,40054.086226316467,38118.73568599132,40054.086226316467]
[56,"56A",46239.844861744525,48445.63394955916,46239.844861744525,48445.63394955916,null,null,null,null,null,null,40560.851335808751,42495.734195742785,40560.851335808751,42495.734195742785]
[57,"57A",49226.89270360471,50333.912898998198,49226.89270360471,50333.912898998198,null,null,null,null,null,null,43181.041862158811,44152.102247533097,43181.041862158811,44152.102247533097]
[58,"58A",51369.007121097449,52370.689913314818,51369.007121097449,52370.689913314818,null,null,null,null,null,null,45060.070321099382,45938.730423490437,45060.070321099382,45938.730423490437]
[59,"59A",54737.188994406097,53274.677278339717,54737.188994406097,53274.677278339717,null,null,null,null,null,null,48014.58551559702,46731.693661837271,48014.58551559702,46731.693661837271]
[60,"60A",57922.822760237475,57508.214205128097,72914.612180534226,72392.693175867142,null,null,null,null,null,null,50807.851377131294,50444.171417422127,63958.118792388799,63500.309901931389]
[61,"61A",61124.516318551563,60032.154952352037,76944.97936570608,75569.889175313729,null,null,null,null,null,null,53616.263721593394,52658.082968322407,67493.41433188814,66287.233854241131]
[62,"62A",64384.598786071692,62629.252640723396,81048.84788364319,78839.176853616518,null,null,null,null,null,null,56475.892751977248,54936.165200413583,71093.182640724306,69154.937369932391]
[63,"63A",67965.478644945309,65360.629053686534,85556.543705989985,82277.497749934802,null,null,null,null,null,null,59616.913907353483,57332.031980236665,75047.173977492028,72170.910845709674]
[64,"64A",71575.526680785028,68263.966322565233,90100.957115811747,85932.287017817434,null,null,null,null,null,null,62783.520355876921,59878.736740560242,79033.37268328038,75376.762720469967]
[65,{"$f":"+CONCATENATE(A303,$B$236)","v":"65A"},75396.741806804683,71262.349804134414,94911.19262738945,89706.722694616255,null,null,null,null,null,null,66135.355106860952,62508.812676841953,83252.741134519107,78687.564193201048]
[66,"66A",79396.618586151002,74432.089755970315,99946.331631978333,93696.865928103813,null,null,null,null,null,null,69643.905540825246,65289.196447910326,87669.386974921188,82187.576705016545]
[67,"67A",83523.889349219666,77646.107525993517,105141.83718078237,97742.747120956541,null,null,null,null,null,null,73264.201471346139,68108.419154972478,92226.700675694519,85736.480583318291]
[68,"68A",87884.190196374344,81046.065854766479,110630.68648249474,102022.69466423546,null,null,null,null,null,null,77088.903149281177,71090.742343394886,97041.325140859815,89490.699185214733]
[69,"69A",92228.43540737922,84641.845133766023,116099.32457164208,106549.14622721136,null,null,null,null,null,null,80899.521391078437,74244.832743108462,101838.22104523993,93461.14239426596]
[70,"70A",96855.743323139948,88323.342064354292,121924.28865383498,111183.50118689303,null,null,null,null,null,null,84958.432225472148,77474.111634935849,106947.67350735904,97526.234646330995]
[71,"71A",101712.03456690312,92033.192565164543,128037.5023371604,115853.54828791303,null,null,null,null,null,null,89218.199135978488,80728.26127568743,112309.96832411412,101622.63478233592]
[72,"72A",106583.40917425061,96073.379239525326,134169.7033134684,120939.43033681421,null,null,null,null,null,null,93491.196639517773,84272.170123784934,117688.91812268706,106083.7906264116]
[73,"73A",111735.87566358599,100149.35605535266,140655.74936474941,126070.36585791453,null,null,null,null,null,null,98010.757999630034,87847.472818068505,123378.24830541664,110584.46578274507]
[74,"74A",116922.5293585366,104296.17738027965,147184.8310748637,131290.48211399908,null,null,null,null,null,null,102560.30716729596,91484.917809942126,129105.32784589021,115163.36712545657]
[75,"75A",122300.66819362422,108560.56485272593,153954.95878491519,136658.59340284325,null,null,null,null,null,null,107277.82032700149,95225.487668068701,135043.84441163714,119872.08447627471]
[76,"76A",128625.35378771767,113381.35500902857,161916.62182689164,142727.11748195361,null,null,null,null,null,null,112825.61082405542,99454.114280339112,142027.53362557563,125195.17915289744]
[77,"77A",135141.31430085294,118523.49438705972,170119.06623754432,149200.16352253399,null,null,null,null,null,null,118541.18091463977,103964.61706368842,149222.42773960537,130873.10618605482]
[78,"78A",142072.06731255591,123857.35540396004,178843.66120521742,155914.55327322023,null,null,null,null,null,null,124620.5923136288,108643.29128740015,156875.33385362683,136762.73138531545]
[79,"79A",149938.64580740687,129190.29670356862,188746.29531050046,162627.78526213934,null,null,null,null,null,null,131520.87672599859,113321.15876763425,165561.5742315512,142651.34103690431]
[80,"80A",157451.18570021779,134789.90346250348,198203.25729321534,169676.70200573967,null,null,null,null,null,null,138110.61099911368,118232.93575674962,173856.88678711958,148834.40148202601]
[81,"81A",166060.08116003801,140437.93990625686,209040.33746028313,176786.58317611163,null,null,null,null,null,null,145662.02959717394,123187.19355241487,183362.79019879544,155070.9377659811]
[82,"82A",174838.51993317838,146146.49374780574,220090.84273941279,183972.64507076723,null,null,null,null,null,null,153362.16559287923,128194.53506890722,193055.90256985975,161374.29708674207]
[83,"83A",184073.03337246642,152612.02747571759,231715.46553945783,192111.61105766802,null,null,null,null,null,null,161462.35415422733,133865.87256710461,203252.61052355682,168513.51017270816]
[84,"84A",194136.76392197324,158918.13478051819,244383.92634883689,200049.88731194651,null,null,null,null,null,null,170289.90263499378,139397.3668459107,214364.9362581686,175476.68532367586]
[85,"85A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[86,"86A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[87,"87A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[88,"88A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[89,"89A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[90,"90A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[91,"91A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[92,"92A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[93,"93A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[94,"94A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[95,"95A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[96,"96A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[97,"97A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[98,"98A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[99,"99A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,null,null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[100,"100A",204101.00733815235,165015.65020355579,256927.15041390943,207725.58319741726,{"$f":"+E288/E338-1","v":-0.87386615943484069},null,null,null,null,null,179030.18452129586,144745.89170399358,225367.40875033705,182209.53426267428]
[]
[]
[]
[null,null,"B","Tarifa de zona 3, 4 y 5",null,null,null,null,null,null,null,null,"B","Tarifa de zona 3, 4 y 5",null,null,"Tarifa 2017 - 2018"]
[null,"B","Renovada","Renovada","Nueva","Nueva",null,null,null,null,null,null,"Renovada","Renovada","Nueva","Nueva"]
["E D A D","Indicador","HOMBRES","MUJERES","HOMBRES","MUJERES",null,null,null,null,null,null,"HOMBRES","MUJERES","HOMBRES","MUJERES"]
[0,{"$f":"+CONCATENATE(A345,$B$343)","v":"0B"},6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[1,{"$f":"+CONCATENATE(A346,$B$343)","v":"1B"},6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[2,"2B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[3,"3B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[4,"4B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[5,"5B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[6,"6B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[7,"7B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[8,"8B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[9,"9B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[10,"10B",6985.4160371232028,6989.7589500996564,6985.4160371232028,6989.7589500996564,null,null,null,null,null,null,6127.31999161965,6131.1294164786823,6127.31999161965,6131.1294164786823]
[11,"11B",6946.0061024301258,6882.916040303674,6946.0061024301258,6882.916040303674,null,null,null,null,null,null,6093.217788867194,6037.8735402182992,6093.217788867194,6037.8735402182992]
[12,"12B",6913.9909696429932,6977.0087084273064,6913.9909696429932,6977.0087084273064,null,null,null,null,null,null,6065.1332790445986,6120.4140837707018,6065.1332790445986,6120.4140837707018]
[13,"13B",6866.2575638308508,6931.1074939493683,6866.2575638308508,6931.1074939493683,null,null,null,null,null,null,6023.2602900018737,6080.1483407720416,6023.2602900018737,6080.1483407720416]
[14,"14B",6687.9805254567164,6789.9805456542772,6687.9805254567164,6789.9805456542772,null,null,null,null,null,null,5866.8710203195751,5956.3480994305701,5866.8710203195751,5956.3480994305701]
[15,"15B",6715.2223176626367,6679.7838800142299,6715.2223176626367,6679.7838800142299,null,null,null,null,null,null,5890.7682312378993,5859.6807090698157,5890.7682312378993,5859.6807090698157]
[16,"16B",6589.6448879275622,6426.4593202798924,6589.6448879275622,6426.4593202798924,null,null,null,null,null,null,5780.6084332967084,5637.4577955036757,5780.6084332967084,5637.4577955036757]
[17,"17B",6625.9029901202193,6528.290586012462,6625.9029901202193,6528.290586012462,null,null,null,null,null,null,5812.4149865897689,5726.7868387948238,5812.4149865897689,5726.7868387948238]
[18,"18B",6819.7295470543695,6168.1203421572118,6819.7295470543695,6168.1203421572118,null,null,null,null,null,null,5982.4446996723482,5410.836103290625,5982.4446996723482,5410.836103290625]
[19,"19B",7051.2365652432572,6259.802232209523,7051.2365652432572,6259.802232209523,null,null,null,null,null,null,6185.5286965295654,5491.2618494166272,6185.5286965295654,5491.2618494166272]
[20,"20B",7265.1931190729301,7264.0118378179841,7265.1931190729301,7264.0118378179841,null,null,null,null,null,null,6373.2169681225869,6372.1807173836505,6373.2169681225869,6372.1807173836505]
[21,"21B",7647.446090061474,9419.3438647011626,7647.446090061474,9419.3438647011626,null,null,null,null,null,null,6708.5392480526116,8262.8942084825321,6708.5392480526116,8262.8942084825321]
[22,"22B",7990.4515940489227,9874.5469801278632,7990.4515940489227,9874.5469801278632,null,null,null,null,null,null,7009.4326258808378,8662.2102585354278,7009.4326258808378,8662.2102585354278]
[23,"23B",8517.9539438345146,10347.180021010203,8517.9539438345146,10347.180021010203,null,null,null,null,null,null,7472.171450751478,9076.8162939811973,7472.171450751478,9076.8162939811973]
[24,"24B",8872.1695658536028,10840.063597691636,8872.1695658536028,10840.063597691636,null,null,null,null,null,null,7782.8986366124673,9509.1866278087273,7782.8986366124673,9509.1866278087273]
[25,"25B",9222.6002663007184,11348.448477371656,9222.6002663007184,11348.448477371656,null,null,null,null,null,null,8090.3055905140072,9955.155109088013,8090.3055905140072,9955.155109088013]
[26,"26B",9848.7034392033092,11892.199471357942,9848.7034392033092,11892.199471357942,null,null,null,null,null,null,8639.5396301244182,10432.14766861259,8639.5396301244182,10432.14766861259]
[27,"27B",10282.522953137392,12441.615793811832,10282.522953137392,12441.615793811832,null,null,null,null,null,null,9020.0974270051411,10914.110002089204,9020.0974270051411,10914.110002089204]
[28,"28B",10892.859637453545,13032.786792460995,10892.859637453545,13032.786792460995,null,null,null,null,null,null,9555.5006914468922,11432.700626991076,9555.5006914468922,11432.700626991076]
[29,"29B",11459.633562020947,13634.275921255401,11459.633562020947,13634.275921255401,null,null,null,null,null,null,10052.689566393592,11960.342584877939,10052.689566393592,11960.342584877939]
[30,"30B",11991.4512045542,14281.28054003634,11991.4512045542,14281.28054003634,null,null,null,null,null,null,10519.213878657489,12527.911918175239,10519.213878657489,12527.911918175239]
[31,"31B",12489.542061869681,14949.017850230626,12489.542061869681,14949.017850230626,null,null,null,null,null,null,10956.152174926045,13113.668509339577,10956.152174926045,13113.668509339577]
[32,"32B",13255.85608740026,15637.632498522551,13255.85608740026,15637.632498522551,null,null,null,null,null,null,11628.382832855892,13717.739246216546,11628.382832855892,13717.739246216546]
[33,"33B",13735.793785838698,16208.649392495476,13735.793785838698,16208.649392495476,null,null,null,null,null,null,12049.396704503652,14218.650164633709,12049.396704503652,14218.650164633709]
[34,"34B",14520.092215781326,16958.521911579646,14520.092215781326,16958.521911579646,null,null,null,null,null,null,12737.403751234444,14876.457904115505,12737.403751234444,14876.457904115505]
[35,"35B",15336.16470070395,17747.207957612081,15336.16470070395,17747.207957612081,null,null,null,null,null,null,13453.283828045194,15568.313882162351,13453.283828045194,15568.313882162351]
[36,"36B",16004.335950951085,18562.48488577117,16004.335950951085,18562.48488577117,null,null,null,null,null,null,14039.421082746288,16283.496075822386,14039.421082746288,16283.496075822386]
[37,"37B",16884.004761395136,19442.081372873086,16884.004761395136,19442.081372873086,null,null,null,null,null,null,14811.089515665473,17055.10106481878,14811.089515665473,17055.10106481878]
[38,"38B",17812.781121151987,20325.438673766257,17812.781121151987,20325.438673766257,null,null,null,null,null,null,15625.836372160438,17830.005137800363,15625.836372160438,17830.005137800363]
[39,"39B",18805.877039851661,21259.277667472888,18805.877039851661,21259.277667472888,null,null,null,null,null,null,16497.006023991755,18649.193068890767,16497.006023991755,18649.193068890767]
[40,"40B",19473.180409993114,22230.242643477843,19473.180409993114,22230.242643477843,null,null,null,null,null,null,17082.381951619343,19500.948880347736,17082.381951619343,19500.948880347736]
[41,"41B",20204.393506805271,23249.326749786345,20204.393506805271,23249.326749786345,null,null,null,null,null,null,17723.821159020805,20394.916048435643,17723.821159020805,20394.916048435643]
[42,"42B",21001.951216140162,24312.407555896447,21001.951216140162,24312.407555896447,null,null,null,null,null,null,18423.459591596806,21327.478269555359,18423.459591596806,21327.478269555359]
[43,"43B",21864.961550111391,25420.979744212367,21864.961550111391,25420.979744212367,null,null,null,null,null,null,19180.514774299561,22299.946718111249,19180.514774299561,22299.946718111249]
[44,"44B",22819.460911889229,26700.37966666204,22819.460911889229,26700.37966666204,null,null,null,null,null,null,20017.826519334216,23422.269712301862,20017.826519334216,23422.269712301862]
[45,"45B",23857.662488303307,27964.35060945525,23857.662488303307,27964.35060945525,null,null,null,null,null,null,20928.564031013484,24531.058002963509,20928.564031013484,24531.058002963509]
[46,"46B",25004.758910198918,29044.861341021016,25004.758910198918,29044.861341021016,null,null,null,null,null,null,21934.826942443244,25478.910209476111,21934.826942443244,25478.910209476111]
[47,"47B",26257.326872714799,30538.049062835365,26257.326872714799,30538.049062835365,null,null,null,null,null,null,23033.612241278021,26788.77343943989,23033.612241278021,26788.77343943989]
[48,"48B",27630.602493261686,31787.820522788512,27630.602493261686,31787.820522788512,null,null,null,null,null,null,24238.285447252667,27885.105573260047,24238.285447252667,27885.105573260047]
[49,"49B",29133.770836291296,33137.15711708719,29133.770836291296,33137.15711708719,null,null,null,null,null,null,25556.903938561743,29068.778840790539,25556.903938561743,29068.778840790539]
[50,"50B",30772.280260244846,34564.144873063087,30772.280260244846,34564.144873063087,null,null,null,null,null,null,26994.247157388945,30320.569733425375,26994.247157388945,30320.569733425375]
[51,"51B",32536.150143907042,36102.968623767527,32536.150143907042,36102.968623767527,null,null,null,null,null,null,28541.559842388953,31670.46607867091,28541.559842388953,31670.46607867091]
[52,"52B",34459.83050591706,37751.289914471337,34459.83050591706,37751.289914471337,null,null,null,null,null,null,30229.062448785036,33116.416523023552,30229.062448785036,33116.416523023552]
[53,"53B",36562.414708599747,39519.402767539068,36562.414708599747,39519.402767539068,null,null,null,null,null,null,32073.50417219428,34667.451251494029,32073.50417219428,34667.451251494029]
[54,"54B",38838.237423487517,41399.592693142455,38838.237423487517,41399.592693142455,null,null,null,null,null,null,34069.915238664638,36316.802912317842,34069.915238664638,36316.802912317842]
[55,"55B",41263.480163235727,43358.494522774476,41263.480163235727,43358.494522774476,null,null,null,null,null,null,36197.401449623292,38035.202709113648,36197.401449623292,38035.202709113648]
[56,"56B",43907.067072903403,46001.575169047173,43907.067072903403,46001.575169047173,null,null,null,null,null,null,38516.424863491018,40353.782015521814,38516.424863491018,40353.782015521814]
[57,"57B",46743.419797153838,47794.591359591621,46743.419797153838,47794.591359591621,null,null,null,null,null,null,41004.547479573703,41926.662601406992,41004.547479573703,41926.662601406992]
[58,"58B",48777.465579268915,49728.613959527604,48777.465579268915,49728.613959527604,null,null,null,null,null,null,42788.865512150391,43623.23768876234,42788.865512150391,43623.23768876234]
[59,"59B",51975.724307585959,50586.995599601905,51975.724307585959,50586.995599601905,null,null,null,null,null,null,45594.46151788428,44376.232460406412,45594.46151788428,44376.232460406412]
[60,"60B",55133.016027916048,54738.376764412329,69402.737823376665,68905.956632848465,null,null,null,null,null,null,48360.684223645621,48014.520959243549,60877.567199177422,60441.808736930121]
[61,"61B",58180.502560084533,57140.753911089167,73238.985575635816,71930.125511606355,null,null,null,null,null,null,51033.829001057944,50121.799155627989,64242.584742508217,63094.500113555223]
[62,"62B",61283.56574604343,59612.764452974145,77145.194527372325,75041.950546685097,null,null,null,null,null,null,53755.723605666433,52290.157243512935,67668.969715368323,65824.080294775122]
[63,"63B",64691.975371909393,62212.586291379856,81435.78076228594,78314.66744914875,null,null,null,null,null,null,56745.457044843351,54570.626770179406,71432.516515273397,68694.788993049355]
[64,"64B",68128.148312675126,64976.086627717385,85761.316111249878,81793.426696067778,null,null,null,null,null,null,59759.543458002125,56994.669145258042,75226.719411837999,71746.230571089545]
[65,{"$f":"+CONCATENATE(A410,$B$343)","v":"65B"},71765.317648517303,67830.055351435614,90339.87045166298,85386.069677689535,null,null,null,null,null,null,62949.936626943352,59498.067112131692,79242.861400975773,74897.56683527166]
[66,"66B",75572.543541119609,70847.127297191342,95132.495987056449,89184.030832934994,null,null,null,null,null,null,66289.497246427709,62144.533316244931,83446.778886679589,78229.000762802461]
[67,"67B",79501.027587446501,73906.344455204904,100077.76413949145,93035.045373022629,null,null,null,null,null,null,69735.42112524921,64827.967773655015,87784.588945901909,81606.971197424544]
[68,"68B",83651.318009026945,77142.546492705849,105302.24737606918,97108.852643759121,null,null,null,null,null,null,73375.905520531407,67666.646955295611,92367.316361139528,85180.367343725055]
[69,"69B",87786.326101414787,80565.137919966539,110507.49285707511,101417.2912639579,null,null,null,null,null,null,77002.984810315495,70668.820156857837,96933.169114161879,88959.573609221057]
[70,"70B",92190.763408307757,84069.318476239132,116051.90217281094,105828.436199501,null,null,null,null,null,null,80866.397645804929,73742.560386464174,101796.52409530735,92828.870133549019]
[71,"71B",96813.155243161862,87600.486975553897,121870.67777668613,110273.55419275611,null,null,null,null,null,null,84920.992296860277,76839.973461950212,106900.54324428296,96727.966593278485]
[72,"72B",101449.90396337862,91446.081269107846,127707.52616566484,115114.47877405339,null,null,null,null,null,null,88988.180287614407,80213.189452685212,112020.41518558518,100974.25025220372]
[73,"73B",106354.20599844509,95325.741900403737,133881.17696274852,119998.28686286118,null,null,null,null,null,null,93290.056352858883,83616.287200684499,117435.71799712825,105258.14977027343]
[74,"74B",111291.04863953378,99272.834871312094,140095.79064035427,124966.9803674164,null,null,null,null,null,null,97620.475858779435,87078.534153958695,122886.9519634047,109616.50769968919]
[75,"75B",116410.15369114034,103331.83150966345,146539.84052884724,130076.54084157637,null,null,null,null,null,null,102110.76934794869,90638.938950111275,128539.43906153539,114098.42903131655]
[76,"76B",122430.21582923863,107920.43213872513,154118.03639680627,135852.7792805128,null,null,null,null,null,null,107391.34975225459,94663.893179680599,135186.75792342637,119165.1361203038]
[77,"77B",128632.34028189165,112814.90445959734,161925.41659014596,142014.05620208132,null,null,null,null,null,null,112831.62862287962,98957.1469757585,142035.10897233084,124569.58501654303]
[78,"78B",135229.27908201618,117891.86429894609,170229.79837383211,148405.05270573209,null,null,null,null,null,null,118618.2243352201,103410.4722116309,149319.41181021821,130175.53560758241]
[79,"79B",142716.97007450709,122967.94871845566,179655.47997614427,154794.94721029126,null,null,null,null,null,null,125186.15559928767,107863.02956093629,157587.2782249857,135780.51956494336]
[80,"80B",149867.67445290339,128297.85486733749,188656.9548995372,161504.35848006015,null,null,null,null,null,null,131458.49441429399,112538.23013543831,165483.04590975834,141665.77205284586]
[81,"81B",158061.92930359664,133673.85812375118,198972.07571158637,168271.797873428,null,null,null,null,null,null,138646.19789639267,117253.86542259675,174531.09617545901,147601.92470844535]
[82,"82B",166417.56154864444,139107.46400558311,209490.34218476416,175111.74880702817,null,null,null,null,null,null,145975.45578221307,122020.02764586356,183757.33845525645,153601.68186008709]
[83,"83B",175207.30198594535,145261.59043905349,220555.07426466071,182858.70796445556,null,null,null,null,null,null,153685.49764679899,127418.20439300098,193462.92056714703,160397.0337653071]
[84,"84B",184786.32095025372,151263.96909640028,232613.36872561352,190414.64345076276,null,null,null,null,null,null,162087.86604018908,132683.27348865356,204040.0196035321,167024.82662689334]
[85,"85B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[86,"86B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[87,"87B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[88,"88B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[89,"89B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[90,"90B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[91,"91B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[92,"92B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[93,"93B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[94,"94B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[95,"95B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[96,"96B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[97,"97B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[98,"98B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[99,"99B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]
[100,"100B",194270.64449995788,157067.80253422042,244552.4583705352,197720.64554307747,null,null,null,null,null,null,170407.17104664631,137774.18591091136,214512.55649401352,173433.38697020605]

{"sheet":"TITULAR","index":1,"n_rows":112,"n_cols":19,"rows_kept":112,"cut":false,"hidden":true,"merged":[[228,22,228,23],[228,20,228,21],[151,19,151,26],[213,19,213,22],[156,19,156,26],[212,19,212,26],[25,1,25,2],[1,8,8,9],[14,8,16,9],[24,5,24,6],[24,3,24,4],[23,9,23,10],[23,3,23,4],[23,5,23,6]]}
[null,"GASTOS MÉDICOS MAYORES INDIVIDUAL/FAMILIAR",null,null,null,null,null,null,"REGION COBERTURA BASICA"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(E3,VALORES!$A$6:$B$11,2,FALSE)),\"REGION NO VALIDA\",VLOOKUP(E3,VALORES!$A$6:$B$11,2,FALSE))","v":"BAJA CALIFORNIA, BAJA CALIFORNIA SUR, MORELOS, QUINTANA ROO, QUERETARO, SAN LUIS POTOSI, SINALOA, SONORA"},null,null,null,"Prima riesgo dental incremental",101,null,null,"Prima riesgo visión opcional",114.67]
[null,"REGIÓN:",null,null,{"$f":"+COTIZACION!D14","v":5},{"$f":"IF(E3>7,\"NO PROCEDE\",\" \")","v":" "},"FACTORES",null,null,null,null,null,"Gastos",0.57455000000000001,null,null,"Gastos",0.51313999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N2/(1-N3)","v":237.39569867199435},null,null,null,{"$f":"+R2/(1-R3)","v":235.529721069712}]
[null,"SUMA ASEGURADA:",null,null,{"$f":"+COTIZACION!D10","v":10000000},null,{"$f":"VLOOKUP(E5,FACTORES!$J$33:$K$124,2)","v":1.26}]
[null,"DEDUCIBLE:",null,null,{"$f":"+COTIZACION!D11","v":10000},null,{"$f":"VLOOKUP(E6,FACTORES!$A$2:$B$29,2,0)","v":0.88},null,null,null,null,null,"Asistencias",102.24]
[null,"ELIMINACION DEDUCIBLE",null,null,{"$f":"+COTIZACION!D15","v":"SI"},null,{"$f":"IF(H7=\"SI\",VLOOKUP(E6,FACTORES!$J$1:$K$21,2,0),0)","v":760.10236439499317},{"$f":"IF(VALUE(COTIZACION!D11)>50000,\"NO\",COTIZACION!D15)","v":"SI"},null,null,null,null,"Gastos",0.48549999999999999]
[null,"COASEGURO:",null,null,{"$f":"+COTIZACION!D12","v":0.1},null,{"$f":"VLOOKUP(E8,FACTORES!$C$2:$D$6,2)","v":1},null,null,null,null,null,null,{"$f":"+N6/(1-N7)","v":198.71720116618076}]
[null,"CATALOGO:",null,null,{"$f":"+COTIZACION!D25","v":0},null,{"$f":"VLOOKUP($E$9,FACTORES!$C$8:$D$13,2,FALSE)","v":1}]
[null,"SUMA ASEGURADA PARTO O CESAREA",null,null,{"$f":"+COTIZACION!D17","v":40000},{"$f":"+COTIZACION!D16","v":"SI"},{"$f":"IF(F10=\"NO\",20000,E10)","v":40000}]
[null,"SEGURO DE ENFERMEDADES GRAVES",null,null,{"$f":"+COTIZACION!D19","v":10000},null,{"$f":"IF(E11=\"NO\",0,IF(SUM(COTIZACION!A30:A37)>=1,VLOOKUP(E11,FACTORES!$M$33:$N$55,2,0)*(1-DESC),0))","v":133.19373983979378}]
[null,"COBERTURA DE VISION",null,null,{"$f":"+COTIZACION!D18","v":"SI"},null,{"$f":"IF(E12=\"NO\",0,G23)","v":235.529721069712},null,null,null,null,null,"PaQ Adicional",{"$f":"+SUM(N13:N26)","v":432.67},0.51110999999999995]
[null,null,null,null,null,"ZONA",null,null,null,null,null,null,null,20,{"$f":"1-O12","v":0.48889000000000005},null,null,null,"A"]
[null,"EMERGENCIA EXTRANJERO:",null,null,{"$f":"+COTIZACION!D21","v":"SI"},null,{"$f":"IF(E14=\"SI\",FACTORES!$G$2,FACTORES!$G$3)","v":1.05},null,"ZONA COBERTURAS ADICIONALES",null,null,null,{"$f":"+N12/O13","v":885.00480680725718},33,null,null,null,null,"S"]
[null,"COBER TOTAL EXTRANJERO:",null,null,{"$f":"+COTIZACION!D20","v":"SI"},{"$f":"+COTIZACION!D22","v":"B"},{"$f":"IF(E15=\"SI\",(IF(F15=\"A\",FACTORES!G6,IF(F15=\"B\",FACTORES!G7,IF(F15=\"C\",FACTORES!G8,\"NO PROCEDE\")))),1)","v":2.4},null,{"$f":"IF(F14=F15,VLOOKUP(F14,VALORES!$A$31:$B$33,2,FALSE),\"ZONAS DIFERENTES\")","v":"ZONAS DIFERENTES"},null,"A",null,null,98]
[null,null,null,null,null,null,{"$f":"+COTIZACION!D14","v":5},null,null,null,"B",null,null,16]
[null,"FORMA DE PAGO:",null,null,{"$f":"+COTIZACION!#REF!","v":{"$error":"#REF!"}},"Costos",0,null,null,null,"C",null,null,16.3]
[null,"PARTO",null,null,null,null,{"$f":"(IF(COTIZACION!A16=\"NO\",+FACTORES!G16,IF(AND(COTIZACION!A7=1,COTIZACION!A8=1),VLOOKUP(E10,FACTORES!$F$16:$G$19,2,0)*(1-DESC),VLOOKUP(E10,FACTORES!$F$23:$G$26,2,0)*(1-DESC))))","v":17323.441199684294},"*BUSCARV(G16,FACTORES!$F$30:$G$35,2,0)","=(SI(COTIZACION!A16=\"NO\",+FACTORES!G16,SI(COTIZACION!D7=FACTORES!F14,BUSCARV(G10,FACTORES!$F$16:$G$19,2,0)*(1-DESC),BUSCARV(G10,FACTORES!$F$23:$G$26,2,0)*(1-DESC))))",null,null,null,null,14]
[null,"DENTAL",null,null,null,{"$f":"ROUND(N4,2)","v":237.4},{"$f":"281*0+181.98*0+F19*(1-DESC)","v":237.4},null,null,null,{"$f":"+F19/DENTAL-1","v":0},null,null,3.9]
[null,"PAQ_ADIC",null,null,null,null,{"$f":"611*0+701.81*0+(684*1.135*0)+(M14)*(1-DESC)","v":885.00480680725718},null,null,null,null,null,null,10.39]
[null,"ASIST_IKE",null,null,null,{"$f":"ROUND(N8,2)","v":198.72},{"$f":"122.5*0+153.74*0+F21*(1-DESC)","v":198.72},153.74,"125.5 (anterior)",null,{"$f":"F21/IKE-1","v":0},null,null,13.3]
[null,"EDUCA",null,null,null,null,{"$f":"88*(1-DESC)*0","v":0},null,null,null,null,null,null,13.5]
[null,"VISION",null,null,null,null,{"$f":"206.61*0+R4*(1-DESC)","v":235.529721069712},null,null,null,null,null,null,20.5]
[null,null,null,"PRIMA BASE ",null,"PRIMA TARIFA ",null,"R P FRAC",{"$f":"G17","v":0},"PRIMA TOTAL",null,null,null,56]
[null,null,null,"REGIONALIZADA",null,"REGIONALIZADA",null,"DER POLIZA",700,"IVA",{"$f":"+COTIZACION!D26","v":0.16},null,null,0.78]
[null,"EDAD",null,"HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER",null,null,117]
[null,0,null,{"$f":"FACTORES!F39","v":6985.42},{"$f":"FACTORES!G39","v":6989.76},{"$f":"ROUND(D27*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},{"$f":"ROUND(E27*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21980.570632111758},{"$f":"(F27*(1+$I$24))+$I$25","v":22668.44063211176},{"$f":"(G27*(1+$I$24))+$I$25","v":22680.570632111758},{"$f":"H27*(1+$K$25)","v":26295.391133249639},{"$f":"I27*(1+$K$25)","v":26309.461933249637}]
[null,{"$f":"+B27+1","v":1},null,{"$f":"FACTORES!F40","v":6985.42},{"$f":"FACTORES!G40","v":6989.76},{"$f":"ROUND(D28*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,{"$f":"(F28*(1+$I$24))+$I$25","v":22668.44063211176},{"$f":"(G28*(1+$I$24))+$I$25","v":22680.570632111758},{"$f":"H28*(1+$K$25)","v":26295.391133249639},{"$f":"I28*(1+$K$25)","v":26309.461933249637}]
[null,{"$f":"+B28+1","v":2},null,{"$f":"FACTORES!F41","v":6985.42},{"$f":"FACTORES!G41","v":6989.76},{"$f":"ROUND(D29*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,3,null,{"$f":"FACTORES!F42","v":6985.42},{"$f":"FACTORES!G42","v":6989.76},{"$f":"ROUND(D30*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,4,null,{"$f":"FACTORES!F43","v":6985.42},{"$f":"FACTORES!G43","v":6989.76},{"$f":"ROUND(D31*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,5,null,{"$f":"FACTORES!F44","v":6985.42},{"$f":"FACTORES!G44","v":6989.76},{"$f":"ROUND(D32*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,6,null,{"$f":"FACTORES!F45","v":6985.42},{"$f":"FACTORES!G45","v":6989.76},{"$f":"ROUND(D33*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,7,null,{"$f":"FACTORES!F46","v":6985.42},{"$f":"FACTORES!G46","v":6989.76},{"$f":"ROUND(D34*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,8,null,{"$f":"FACTORES!F47","v":6985.42},{"$f":"FACTORES!G47","v":6989.76},{"$f":"ROUND(D35*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,9,null,{"$f":"FACTORES!F48","v":6985.42},{"$f":"FACTORES!G48","v":6989.76},{"$f":"ROUND(D36*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21968.44063211176},21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,10,null,{"$f":"FACTORES!F49","v":6985.42},{"$f":"FACTORES!G49","v":6989.76},21968.44063211176,21980.570632111758,22668.44063211176,22680.570632111758,26295.391133249639,26309.461933249637]
[null,11,null,{"$f":"FACTORES!F50","v":6946.01},{"$f":"FACTORES!G50","v":6882.92},{"$f":"ROUND(D38*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21858.320632111758},21682.040632111759,22558.320632111758,22382.040632111759,26167.651933249635,25963.167133249637,{"$f":"+F38/F37-1","v":-5.0126452689153167E-3}]
[null,12,null,{"$f":"FACTORES!F51","v":6913.99},{"$f":"FACTORES!G51","v":6977.01},{"$f":"ROUND(D39*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21768.85063211176},21944.94063211176,22468.85063211176,22644.94063211176,26063.866733249641,26268.131133249641]
[null,13,null,{"$f":"FACTORES!F52","v":6866.26},{"$f":"FACTORES!G52","v":6931.11},{"$f":"ROUND(D40*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21635.49063211176},21816.69063211176,22335.49063211176,22516.69063211176,25909.169133249641,26119.36113324964]
[null,14,null,{"$f":"FACTORES!F53","v":6687.98},{"$f":"FACTORES!G53","v":6789.98},{"$f":"ROUND(D41*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21137.340632111758},21422.35063211176,21837.340632111758,22122.35063211176,25331.315133249638,25661.926733249638]
[null,15,null,{"$f":"FACTORES!F54","v":6715.22},{"$f":"FACTORES!G54","v":6679.78},{"$f":"ROUND(D42*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21213.460632111757},21114.430632111758,21913.460632111757,21814.430632111758,25419.614333249636,25304.739533249638]
[null,16,null,{"$f":"FACTORES!F55","v":6589.64},{"$f":"FACTORES!G55","v":6426.46},20862.560632111759,20406.610632111759,21562.560632111759,21106.610632111759,25012.570333249638,24483.66833324964]
[null,17,null,{"$f":"FACTORES!F56","v":6625.9},{"$f":"FACTORES!G56","v":6528.29},20963.880632111759,{"$f":"ROUND(E44*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":20691.140632111757},21663.880632111759,21391.140632111757,25130.101533249639,24813.723133249638]
[null,18,null,{"$f":"FACTORES!F57","v":6819.73},{"$f":"FACTORES!G57","v":6168.12},{"$f":"ROUND(D45*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":21505.480632111758},{"$f":"ROUND(E45*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+PARTO+CVISION","v":37008.201831796054},22205.480632111758,37708.201831796054,25758.357533249637,43741.514124883419,21337.458333249637,39743.884278671903,{"$f":"IF(J45=L45,1,0)","v":0},{"$f":"IF(K45=M45,1,0)","v":0}]
[null,19,null,{"$f":"FACTORES!F58","v":7051.24},{"$f":"FACTORES!G58","v":6259.8},22152.360632111759,37264.371831796052,22852.360632111759,37964.371831796052,26508.738333249639,44038.67132488342]
[null,20,null,{"$f":"FACTORES!F59","v":7265.19},{"$f":"FACTORES!G59","v":7264.01},22750.17063211176,40070.311831796047,23450.17063211176,40770.311831796047,27202.197933249641,47293.56172488341]
[null,21,null,{"$f":"FACTORES!F60","v":7647.45},{"$f":"FACTORES!G60","v":9419.34},23818.270632111758,46092.68183179605,24518.270632111758,46792.68183179605,28441.193933249637,54279.510924883412]
[null,22,null,{"$f":"FACTORES!F61","v":7990.45},{"$f":"FACTORES!G61","v":9874.5499999999993},24776.67063211176,47364.621831796052,25476.67063211176,48064.621831796052,29552.937933249639,55754.961324883414]
[null,23,null,{"$f":"FACTORES!F62","v":8517.9500000000007},{"$f":"FACTORES!G62","v":10347.18},26250.60063211176,48685.231831796053,26950.60063211176,49385.231831796053,31262.696733249639,57286.86892488342]
[null,24,null,{"$f":"FACTORES!F63","v":8872.17},{"$f":"FACTORES!G63","v":10840.06},27240.35063211176,50062.43183179605,27940.35063211176,50762.43183179605,32410.806733249639,58884.420924883416]
[null,25,null,{"$f":"FACTORES!F64","v":9222.6},{"$f":"FACTORES!G64","v":11348.45},28219.520632111758,51482.961831796049,28919.520632111758,52182.961831796049,33546.643933249637,60532.235724883409]
[null,26,null,{"$f":"FACTORES!F65","v":9848.7000000000007},{"$f":"FACTORES!G65","v":11892.2},29968.950632111759,53002.29183179605,30668.950632111759,53702.29183179605,35575.982733249635,62294.658524883416]
[null,27,null,{"$f":"FACTORES!F66","v":10282.52},{"$f":"FACTORES!G66","v":12441.62},31181.120632111757,54537.471831796058,31881.120632111757,55237.471831796058,36982.099933249636,64075.467324883422]
[null,28,null,{"$f":"FACTORES!F67","v":10892.86},{"$f":"FACTORES!G67","v":13032.79},32886.520632111758,56189.30183179606,33586.520632111758,56889.30183179606,38960.363933249639,65991.590124883427]
[null,29,null,{"$f":"FACTORES!F68","v":11459.63},{"$f":"FACTORES!G68","v":13634.28},34470.17063211176,57869.971831796058,35170.17063211176,58569.971831796058,40797.397933249638,67941.167324883427]
[null,30,null,{"$f":"FACTORES!F69","v":11991.45},{"$f":"FACTORES!G69","v":14281.28},35956.17063211176,59677.80183179606,36656.17063211176,60377.80183179606,42521.15793324964,70038.250124883431]
[null,31,null,{"$f":"FACTORES!F70","v":12489.54},{"$f":"FACTORES!G70","v":14949.02},37347.92063211176,61543.581831796058,38047.92063211176,62243.581831796058,44135.587933249641,72202.554924883429]
[null,32,null,{"$f":"FACTORES!F71","v":13255.86},{"$f":"FACTORES!G71","v":15637.63},39489.160632111758,63467.68183179605,40189.160632111758,64167.68183179605,46619.426333249634,74434.51092488342]
[null,33,null,{"$f":"FACTORES!F72","v":13735.79},{"$f":"FACTORES!G72","v":16208.65},40830.160632111758,65063.211831796049,41530.160632111758,65763.211831796041,48174.986333249639,76285.325724883398]
[null,34,null,{"$f":"FACTORES!F73","v":14520.09},{"$f":"FACTORES!G73","v":16958.52},43021.640632111761,67158.48183179606,43721.640632111761,67858.48183179606,50717.103133249642,78715.838924883428]
[null,35,null,{"$f":"FACTORES!F74","v":15336.16},{"$f":"FACTORES!G74","v":17747.21},45301.880632111759,69362.221831796065,46001.880632111759,70062.221831796065,53362.181533249634,81272.177324883436]
[null,36,null,{"$f":"FACTORES!F75","v":16004.34},{"$f":"FACTORES!G75","v":18562.48},47168.890632111761,71640.23183179606,47868.890632111761,72340.23183179606,55527.91313324964,83914.66892488343]
[null,37,null,{"$f":"FACTORES!F76","v":16884},{"$f":"FACTORES!G76","v":19442.080000000002},49626.820632111761,74097.98183179606,50326.820632111761,74797.98183179606,58379.111933249638,86765.658924883421]
[null,38,null,{"$f":"FACTORES!F77","v":17812.78},{"$f":"FACTORES!G77","v":20325.439999999999},52221.99063211176,76566.251831796064,52921.99063211176,77266.251831796064,61389.509133249638,89628.852124883429]
[null,39,null,{"$f":"FACTORES!F78","v":18805.88},{"$f":"FACTORES!G78","v":21259.279999999999},54996.890632111761,79175.561831796062,55696.890632111761,79875.561831796062,64608.393133249636,92655.651724883428]
[null,40,null,{"$f":"FACTORES!F79","v":19473.18},{"$f":"FACTORES!G79","v":22230.240000000002},56861.440632111757,81888.59183179606,57561.440632111757,82588.59183179606,66771.27113324964,95802.766524883424]
[null,41,null,{"$f":"FACTORES!F80","v":20204.39},{"$f":"FACTORES!G80","v":23249.33},58904.570632111761,84736.11183179605,59604.570632111761,85436.11183179605,69141.301933249633,99105.889724883411]
[null,42,null,{"$f":"FACTORES!F81","v":21001.95},{"$f":"FACTORES!G81","v":24312.41},61133.090632111758,87706.541831796043,61833.090632111758,88406.541831796043,71726.385133249642,102551.58852488341]
[null,43,null,{"$f":"FACTORES!F82","v":21864.959999999999},{"$f":"FACTORES!G82","v":25420.98},63544.500632111762,90804.081831796051,64244.500632111762,91504.081831796051,74523.620733249641,106144.73492488341]
[null,44,null,{"$f":"FACTORES!F83","v":22819.46},{"$f":"FACTORES!G83","v":26700.38},66211.540632111763,94378.951831796046,66911.540632111763,95078.951831796046,77617.387133249635,110291.5841248834]
[null,45,null,{"$f":"FACTORES!F84","v":23857.66},{"$f":"FACTORES!G84","v":27964.35},69112.450632111751,97910.711831796056,69812.450632111751,98610.711831796056,80982.442733249627,114388.42572488342]
[null,46,null,{"$f":"FACTORES!F85","v":25004.76},{"$f":"FACTORES!G85","v":29044.86},72317.650632111749,100929.84183179605,73017.650632111749,101629.84183179605,84700.474733249619,117890.6165248834]
[null,47,null,{"$f":"FACTORES!F86","v":26257.33},{"$f":"FACTORES!G86","v":30538.05},75817.550632111757,105102.08183179605,76517.550632111757,105802.08183179605,88760.358733249639,122730.41492488341]
[null,48,null,{"$f":"FACTORES!F87","v":27630.6},{"$f":"FACTORES!G87","v":31787.82},79654.710632111746,108594.15183179604,80354.710632111746,109294.15183179604,93211.46433324962,126781.2161248834]
[null,49,null,{"$f":"FACTORES!F88","v":29133.77},{"$f":"FACTORES!G88","v":33137.160000000003},83854.830632111756,112364.45183179605,84554.830632111756,113064.45183179605,98083.603533249625,131154.7641248834]
[null,50,null,{"$f":"FACTORES!F89","v":30772.28},{"$f":"FACTORES!G89","v":34564.14},{"$f":"ROUND(D77*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":88433.12063211175},116351.68183179604,89133.12063211175,117051.68183179604,103394.41993324962,135779.95092488339]
[null,51,null,{"$f":"FACTORES!F90","v":32536.15},{"$f":"FACTORES!G90","v":36102.97},93361.680632111747,120651.44183179605,94061.680632111747,121351.44183179605,109111.54953324962,140767.67252488341]
[null,52,null,{"$f":"FACTORES!F91","v":34459.83},{"$f":"FACTORES!G91","v":37751.29},98736.780632111753,125257.14183179605,99436.780632111753,125957.14183179605,115346.66553324963,146110.28452488341]
[null,53,null,{"$f":"FACTORES!F92","v":36562.410000000003},{"$f":"FACTORES!G92","v":39519.4},104611.76063211175,130197.55183179605,105311.76063211175,130897.55183179605,122161.64233324962,151841.1601248834]
[null,54,null,{"$f":"FACTORES!F93","v":38838.239999999998},{"$f":"FACTORES!G93","v":41399.589999999997},110970.83063211176,135451.13183179602,111670.83063211176,136151.13183179602,129538.16353324962,157935.31292488339]
[null,55,null,{"$f":"FACTORES!F94","v":41263.480000000003},{"$f":"FACTORES!G94","v":43358.49},117747.38063211174,{"$f":"ROUND(E82*$G$5*$G$6*$G$8*$G$14*$G$15*$G$9,2)+ADIC+DENTAL+DEDXACC+ENFGVES+IKE+CVISION","v":123601.20063211175},118447.38063211174,124301.20063211175,137398.96153324962,144189.39273324961]
[null,56,null,{"$f":"FACTORES!F95","v":43907.07},{"$f":"FACTORES!G95","v":46001.58},125134.03063211175,130986.46063211175,125834.03063211175,131686.46063211176,145967.47553324961,152756.29433324962]
[null,57,null,{"$f":"FACTORES!F96","v":46743.42},{"$f":"FACTORES!G96","v":47794.59},133059.29063211175,135996.45063211175,133759.29063211175,136696.45063211175,155160.77713324962,158567.88273324963]
[null,58,null,{"$f":"FACTORES!F97","v":48777.47},{"$f":"FACTORES!G97","v":49728.61},138742.79063211175,141400.44063211174,139442.79063211175,142100.44063211174,161753.63713324961,164836.51113324962]
[null,59,null,{"$f":"FACTORES!F98","v":51975.72},{"$f":"FACTORES!G98","v":50587},147679.26063211175,143798.93063211176,148379.26063211175,144498.93063211176,172119.94233324961,167618.75953324963]
[null,60,null,{"$f":"FACTORES!F99","v":69402.740000000005},{"$f":"FACTORES!G99","v":68905.960000000006},196373.42063211175,194985.33063211176,197073.42063211175,195685.33063211176,228605.16793324961,226994.98353324961]
[null,61,null,{"$f":"FACTORES!F100","v":73238.990000000005},{"$f":"FACTORES!G100","v":71930.13},207092.58063211176,203435.39063211175,207792.58063211176,204135.39063211175,241039.39353324962,236797.05313324963,{"$f":"+F88","v":207092.58063211176}]
[null,62,null,{"$f":"FACTORES!F101","v":77145.19},{"$f":"FACTORES!G101","v":75041.95},218007.19063211174,212130.37063211176,218707.19063211174,212830.37063211176,253700.3411332496,246883.22993324962]
[null,63,null,{"$f":"FACTORES!F102","v":81435.78},{"$f":"FACTORES!G102","v":78314.67},229995.85063211175,221274.92063211175,230695.85063211175,221974.92063211175,267607.18673324963,257490.9079332496]
[null,64,null,{"$f":"FACTORES!F103","v":85761.32},{"$f":"FACTORES!G103","v":81793.429999999993},242082.17063211175,230995.19063211174,242782.17063211175,231695.19063211174,281627.31793324964,268766.42113324959]
[null,65,null,{"$f":"FACTORES!F104","v":90339.87},{"$f":"FACTORES!G104","v":85386.07},254875.45063211175,241033.66063211174,{"$f":"(F92*(1+$I$24))+$I$25","v":255575.45063211175},{"$f":"(G92*(1+$I$24))+$I$25","v":241733.66063211174},{"$f":"H92*(1+$K$25)","v":296467.52273324959},{"$f":"I92*(1+$K$25)","v":280411.0463332496}]
[null,{"$f":"+B92+1","v":66},null,{"$f":"FACTORES!F105","v":95132.5},{"$f":"FACTORES!G105","v":89184.03},268266.90063211176,251645.83063211176,268966.90063211176,252345.83063211176,312001.60473324964,292721.16353324964]
[null,67,null,{"$f":"FACTORES!F106","v":100077.75999999999},{"$f":"FACTORES!G106","v":93035.05},282084.83063211176,262406.25063211174,282784.83063211176,263106.25063211174,328030.40353324963,305203.25073324959]
[null,68,null,{"$f":"FACTORES!F107","v":105302.25},{"$f":"FACTORES!G107","v":97108.85},296682.97063211177,273789.17063211172,297382.97063211177,274489.17063211172,344964.24593324965,318407.43793324957]
[null,69,null,{"$f":"FACTORES!F108","v":110507.49},{"$f":"FACTORES!G108","v":101417.29},311227.33063211176,285827.71063211176,311927.33063211176,286527.71063211176,361835.70353324962,332372.1443332496]
[null,70,null,{"$f":"FACTORES!F109","v":116051.9},{"$f":"FACTORES!G109","v":105828.44},326719.38063211174,298153.24063211173,327419.38063211174,298853.24063211173,379806.48153324961,346669.75913324958]
[null,71,null,{"$f":"FACTORES!F110","v":121870.68},{"$f":"FACTORES!G110","v":110273.55},342978.08063211176,310573.66063211177,343678.08063211176,311273.66063211177,398666.57353324961,361077.44633324962]
[null,72,null,{"$f":"FACTORES!F111","v":127707.53},{"$f":"FACTORES!G111","v":115114.48},359287.27063211176,324100.07063211175,359987.27063211176,324800.07063211175,417585.2339332496,376768.0819332496]
[null,73,null,{"$f":"FACTORES!F112","v":133881.18},{"$f":"FACTORES!G112","v":119998.29},376537.53063211177,337746.29063211178,377237.53063211177,338446.29063211178,437595.53553324961,392597.69713324966]
[null,74,null,{"$f":"FACTORES!F113","v":140095.79},{"$f":"FACTORES!G113","v":124966.98},393902.24063211173,351629.69063211174,394602.24063211173,352329.69063211174,457738.59913324955,408702.44113324961]
[null,75,null,{"$f":"FACTORES!F114","v":146539.84},{"$f":"FACTORES!G114","v":130076.54},411908.05063211173,365906.70063211175,412608.05063211173,366606.70063211175,478625.33873324958,425263.77273324959]
[null,76,null,{"$f":"FACTORES!F115","v":154118.04},{"$f":"FACTORES!G115","v":135852.78},433082.88063211174,382046.53063211177,433782.88063211174,382746.53063211177,503188.14153324958,443985.97553324961]
[null,77,null,{"$f":"FACTORES!F116","v":161925.42000000001},{"$f":"FACTORES!G116","v":142014.06},454898.07063211175,399262.23063211178,455598.07063211175,399962.23063211178,528493.76193324954,463956.18753324961]
[null,78,null,{"$f":"FACTORES!F117","v":170229.8},{"$f":"FACTORES!G117","v":148405.04999999999},478101.97063211177,417119.78063211177,478801.97063211177,417819.78063211177,555410.28593324963,484670.94553324964]
[null,79,null,{"$f":"FACTORES!F118","v":179655.48},{"$f":"FACTORES!G118","v":154794.95000000001},504438.98063211178,434974.28063211177,505138.98063211178,435674.28063211177,585961.21753324964,505382.16553324962]
[null,80,null,{"$f":"FACTORES!F119","v":188656.95},{"$f":"FACTORES!G119","v":161504.35999999999},529590.67063211184,453721.56063211174,530290.67063211184,454421.56063211174,615137.17793324974,527129.01033324958]
[null,81,null,{"$f":"FACTORES!F120","v":198972.08},{"$f":"FACTORES!G120","v":168271.8},558412.96063211188,472630.98063211178,559112.96063211188,473330.98063211178,648571.03433324979,549063.93753324961]
[null,82,null,{"$f":"FACTORES!F121","v":209490.34},{"$f":"FACTORES!G121","v":175111.75},587802.83063211187,491743.00063211174,588502.83063211187,492443.00063211174,682663.28353324975,571233.88073324959]
[null,83,null,{"$f":"FACTORES!F122","v":220555.07},{"$f":"FACTORES!G122","v":182858.71},618719.63063211192,513389.37063211174,619419.63063211192,514089.37063211174,718526.77153324976,596343.66993324959]
[null,84,null,{"$f":"FACTORES!F123","v":232613.37},{"$f":"FACTORES!G123","v":190414.64},652412.65063211182,534501.97063211189,{"$f":"(F111*(1+$I$24))+$I$25","v":653112.65063211182},{"$f":"(G111*(1+$I$24))+$I$25","v":535201.97063211189},{"$f":"H111*(1+$K$25)","v":757610.6747332497},{"$f":"I111*(1+$K$25)","v":620834.28593324975}]
[null,85,null,{"$f":"FACTORES!F124","v":244552.46},{"$f":"FACTORES!G124","v":197720.65},685772.56063211185,554916.24063211191,{"$f":"(F112*(1+$I$24))+$I$25","v":686472.56063211185},{"$f":"(G112*(1+$I$24))+$I$25","v":555616.24063211191},{"$f":"H112*(1+$K$25)","v":796308.17033324973},{"$f":"I112*(1+$K$25)","v":644514.83913324971}]

{"sheet":"CONYUGE","index":2,"n_rows":106,"n_cols":15,"rows_kept":106,"cut":false,"hidden":true,"merged":[[149,18,149,19],[149,16,149,17],[71,15,71,22],[134,15,134,18],[76,15,76,22],[133,15,133,22],[17,12,17,13],[19,1,19,2],[1,8,7,9],[11,8,13,9],[18,5,18,6],[18,3,18,4],[17,9,17,10],[17,3,17,4],[17,5,17,6]]}
[null,null,"GASTOS MÉDICOS MAYORES INDIVIDUAL/FAMILIAR",null,null,null,null,null,"REGION COBERTURA BASICA"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(E3,VALORES!$A$6:$B$11,2,FALSE)),\"REGION NO VALIDA\",VLOOKUP(E3,VALORES!$A$6:$B$11,2,FALSE))","v":"BAJA CALIFORNIA, BAJA CALIFORNIA SUR, MORELOS, QUINTANA ROO, QUERETARO, SAN LUIS POTOSI, SINALOA, SONORA"}]
[null,"REGIÓN:",null,null,{"$f":"+COTIZACION!D14","v":5},{"$f":"IF(E3>7,\"NO PROCEDE\",\" \")","v":" "},"FACTORES"]
[]
[null,"SUMA ASEGURADA:",null,null,{"$f":"+COTIZACION!D10","v":10000000},null,{"$f":"+TITULAR!G5","v":1.26}]
[null,"DEDUCIBLE:",null,null,{"$f":"+COTIZACION!D11","v":10000},null,{"$f":"+TITULAR!G6","v":0.88}]
[null,"COASEGURO:",null,null,{"$f":"+COTIZACION!D12","v":0.1},null,{"$f":"+TITULAR!G8","v":1}]
[null,"CATALOGO:",null,null,{"$f":"+COTIZACION!$D$25","v":0},null,{"$f":"+TITULAR!G9","v":1}]
[null,"SUMA ASEGURADA PARTO O CESAREA",null,null,{"$f":"+COTIZACION!D17","v":40000}]
[null,null,null,null,null,"ZONA",null,null,null,null,null,null,null,null,"A"]
[null,"EMERGENCIA EXTRANJERO:",null,null,{"$f":"+COTIZACION!D21","v":"SI"},null,{"$f":"+TITULAR!G14","v":1.05},null,"ZONA COBERTURAS ADICIONALES",null,null,null,null,null,"S"]
[null,"COBER TOTAL EXTRANJERO:",null,null,{"$f":"+COTIZACION!D20","v":"SI"},{"$f":"+COTIZACION!D22","v":"B"},{"$f":"+TITULAR!G15","v":2.4},{"$f":"G12*G11*G8*G7*G6*G5","v":2.7941760000000002},{"$f":"IF(F11=F12,VLOOKUP(F11,VALORES!$A$31:$B$33,2,FALSE),\"ZONAS DIFERENTES\")","v":"ZONAS DIFERENTES"},null,"A"]
[null,null,null,null,null,null,null,null,null,null,"B"]
[null,"FORMA DE PAGO:",null,null,{"$f":"+COTIZACION!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+TITULAR!G17","v":0},null,null,null,"C"]
[]
[]
[]
[null,null,null,"PRIMA BASE ",null,"PRIMA TARIFA ",null,"R P FRAC",{"$f":"G14","v":0},"PRIMA TOTAL",null,null,"TARIFA CONYUGUE"]
[null,null,null,"REGIONALIZADA",null,"REGIONALIZADA",null,"DER POLIZA",0,"IVA",{"$f":"+COTIZACION!D26","v":0.16},null,"IVA",{"$f":"+COTIZACION!D26","v":0.16}]
[null,"EDAD",null,"HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER",null,"HOMBRE","MUJER"]
[null,0,null,{"$f":"FACTORES!F39","v":6985.42},{"$f":"FACTORES!G39","v":6989.76},{"$f":"ROUND(D21*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":21075.144527876975},{"$f":"ROUND(E21*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":21087.274527876973},{"$f":"(F21*(1+$I$18))+$I$19","v":21075.144527876975},{"$f":"(G21*(1+$I$18))+$I$19","v":21087.274527876973},{"$f":"H21*(1+$K$19)","v":24447.167652337288},{"$f":"I21*(1+$K$19)","v":24461.238452337286},null,{"$f":"(D21*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":24447.171032484479},{"$f":"(E21*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":24461.238032138888}]
[null,{"$f":"+B21+1","v":1},null,{"$f":"FACTORES!F40","v":6985.42},{"$f":"FACTORES!G40","v":6989.76},21075.144527876975,21087.274527876973,{"$f":"(F22*(1+$I$18))+$I$19","v":21075.144527876975},{"$f":"(G22*(1+$I$18))+$I$19","v":21087.274527876973},{"$f":"H22*(1+$K$19)","v":24447.167652337288},{"$f":"I22*(1+$K$19)","v":24461.238452337286},null,{"$f":"(D22*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":24447.171032484479},24461.238032138888]
[null,{"$f":"+B22+1","v":2},null,{"$f":"FACTORES!F41","v":6985.42},{"$f":"FACTORES!G41","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,3,null,{"$f":"FACTORES!F42","v":6985.42},{"$f":"FACTORES!G42","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,4,null,{"$f":"FACTORES!F43","v":6985.42},{"$f":"FACTORES!G43","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,5,null,{"$f":"FACTORES!F44","v":6985.42},{"$f":"FACTORES!G44","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,6,null,{"$f":"FACTORES!F45","v":6985.42},{"$f":"FACTORES!G45","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,7,null,{"$f":"FACTORES!F46","v":6985.42},{"$f":"FACTORES!G46","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,8,null,{"$f":"FACTORES!F47","v":6985.42},{"$f":"FACTORES!G47","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,9,null,{"$f":"FACTORES!F48","v":6985.42},{"$f":"FACTORES!G48","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,10,null,{"$f":"FACTORES!F49","v":6985.42},{"$f":"FACTORES!G49","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286,null,24447.171032484479,24461.238032138888]
[null,11,null,{"$f":"FACTORES!F50","v":6946.01},{"$f":"FACTORES!G50","v":6882.92},20965.024527876973,20788.744527876974,20965.024527876973,20788.744527876974,24319.428452337288,24114.94365233729,null,24319.433600138884,24114.943506084481]
[null,12,null,{"$f":"FACTORES!F51","v":6913.99},{"$f":"FACTORES!G51","v":6977.01},20875.554527876975,21051.644527876975,20875.554527876975,21051.644527876975,24215.64325233729,24419.90765233729,null,24215.648962135681,24419.912169098887]
[null,13,null,{"$f":"FACTORES!F52","v":6866.26},{"$f":"FACTORES!G52","v":6931.11},20742.194527876974,20923.394527876975,20742.194527876974,20923.394527876975,24060.94565233729,24271.137652337289,null,24060.944378378881,24271.139062154882]
[null,14,null,{"$f":"FACTORES!F53","v":6687.98},{"$f":"FACTORES!G53","v":6789.98},20244.044527876973,20529.054527876975,20244.044527876973,20529.054527876975,23483.091652337287,23813.703252337291,null,23483.095369534083,23813.70227385408]
[null,15,null,{"$f":"FACTORES!F54","v":6715.22},{"$f":"FACTORES!G54","v":6679.78},20320.164527876972,20221.134527876973,20320.164527876972,20221.134527876973,23571.390852337285,23456.516052337287,null,23571.386860452483,23456.517167422087]
[null,16,null,{"$f":"FACTORES!F55","v":6589.64},{"$f":"FACTORES!G55","v":6426.46},19969.264527876974,19513.314527876973,19969.264527876974,19513.314527876973,23164.346852337287,22635.444852337288,null,23164.351418839688,22635.445196810881]
[null,17,null,{"$f":"FACTORES!F56","v":6625.9},{"$f":"FACTORES!G56","v":6528.29},20070.584527876974,19797.844527876972,20070.584527876974,19797.844527876972,23281.878052337288,22965.499652337287,null,23281.878932081287,22965.501089623682]
[null,18,null,{"$f":"FACTORES!F57","v":6819.73},{"$f":"FACTORES!G57","v":6168.12},{"$f":"ROUND(D39*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":20612.184527876972},{"$f":"ROUND(E39*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8,2)+ADIC+DENTAL+IKE+PARTO+CVISION","v":36114.905727561265},20612.184527876972,36114.905727561265,23910.134052337286,41893.290643971064,null,23910.129287614083,21798.102180516482]
[null,19,null,{"$f":"FACTORES!F58","v":7051.24},{"$f":"FACTORES!G58","v":6259.8},21259.064527876973,36371.075727561263,21259.064527876973,36371.075727561263,24660.514852337288,42190.447843971066,null,24660.509723095678,22095.259445105286]
[null,20,null,{"$f":"FACTORES!F59","v":7265.19},{"$f":"FACTORES!G59","v":7264.01},21856.874527876975,39177.015727561266,21856.874527876975,39177.015727561266,25353.97445233729,45445.338243971062,null,25353.973911127683,25350.149243018881]
[null,21,null,{"$f":"FACTORES!F60","v":7647.45},{"$f":"FACTORES!G60","v":9419.34},22924.974527876973,45199.385727561261,22924.974527876973,45199.385727561261,26592.970452337286,52431.287443971058,null,26592.971903729282,32336.100018391688]
[null,22,null,{"$f":"FACTORES!F61","v":7990.45},{"$f":"FACTORES!G61","v":9874.5499999999993},23883.374527876975,46471.325727561263,23883.374527876975,46471.325727561263,27704.714452337288,53906.737843971059,null,27704.718650609284,33811.546772465277]
[null,23,null,{"$f":"FACTORES!F62","v":8517.9500000000007},{"$f":"FACTORES!G62","v":10347.18},25357.304527876975,47791.935727561264,25357.304527876975,47791.935727561264,29414.473252337288,55438.645443971065,null,29414.474945009282,35343.455999806079]
[null,24,null,{"$f":"FACTORES!F63","v":8872.17},{"$f":"FACTORES!G63","v":10840.06},26347.054527876975,49169.135727561261,26347.054527876975,49169.135727561261,30562.583252337288,57036.197443971061,null,30562.588451364481,36941.000421386881]
[null,25,null,{"$f":"FACTORES!F64","v":9222.6},{"$f":"FACTORES!G64","v":11348.45},27326.224527876973,50589.66572756126,27326.224527876973,50589.66572756126,31698.420452337286,58684.012243971054,null,31698.417642353284,38588.816539889282]
[null,26,null,{"$f":"FACTORES!F65","v":9848.7000000000007},{"$f":"FACTORES!G65","v":11892.2},29075.654527876974,52108.995727561261,29075.654527876974,52108.995727561261,33727.759252337288,60446.435043971062,null,33727.760610929283,40351.243051889287]
[null,27,null,{"$f":"FACTORES!F66","v":10282.52},{"$f":"FACTORES!G66","v":12441.62},30287.824527876972,53644.175727561269,30287.824527876972,53644.175727561269,35133.876452337288,62227.243843971068,null,35133.877152420486,42132.047418276488]
[null,28,null,{"$f":"FACTORES!F67","v":10892.86},{"$f":"FACTORES!G67","v":13032.79},31993.224527876973,55296.005727561271,31993.224527876973,55296.005727561271,37112.140452337284,64143.366643971072,null,37112.138113034882,44048.173728343681]
[null,29,null,{"$f":"FACTORES!F68","v":11459.63},{"$f":"FACTORES!G68","v":13634.28},33576.874527876971,56976.675727561269,33576.874527876971,56976.675727561269,38949.174452337284,66092.943843971065,null,38949.178065598069,45997.749678142092]
[null,30,null,{"$f":"FACTORES!F69","v":11991.45},{"$f":"FACTORES!G69","v":14281.28},35062.874527876971,58784.505727561271,35062.874527876971,58784.505727561271,40672.934452337286,68190.026643971069,null,40672.93653476928,48094.834649662094]
[null,31,null,{"$f":"FACTORES!F70","v":12489.54},{"$f":"FACTORES!G70","v":14949.02},36454.624527876971,60650.28572756127,36454.624527876971,60650.28572756127,42287.364452337286,70354.331443971067,null,42287.367838423685,50259.143025060483]
[null,32,null,{"$f":"FACTORES!F71","v":13255.86},{"$f":"FACTORES!G71","v":15637.63},38595.864527876969,62574.385727561261,38595.864527876969,62574.385727561261,44771.202852337279,72586.287443971058,null,{"$f":"(D53*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":44771.198063114891},{"$f":"(E53*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":52491.096166078074}]
[null,33,null,{"$f":"FACTORES!F72","v":13735.79},{"$f":"FACTORES!G72","v":16208.65},39936.864527876969,64169.91572756126,39936.864527876969,64169.91572756126,46326.762852337284,74437.10224397105,null,46326.768372823688,54341.911406321298]
[null,34,null,{"$f":"FACTORES!F73","v":14520.09},{"$f":"FACTORES!G73","v":16958.52},42128.344527876972,66265.185727561271,42128.344527876972,66265.185727561271,48868.879652337288,76867.615443971066,null,48868.876167511677,56772.423164580476]
[null,35,null,{"$f":"FACTORES!F74","v":15336.16},{"$f":"FACTORES!G74","v":17747.21},44408.58452787697,68468.925727561276,44408.58452787697,68468.925727561276,51513.958052337279,79423.953843971074,null,51513.958289162882,59328.760021130882]
[null,36,null,{"$f":"FACTORES!F75","v":16004.34},{"$f":"FACTORES!G75","v":18562.48},46275.594527876972,70746.935727561271,46275.594527876972,70746.935727561271,53679.689652337285,82066.445443971068,null,53679.692811991685,61971.24914745408]
[null,37,null,{"$f":"FACTORES!F76","v":16884},{"$f":"FACTORES!G76","v":19442.080000000002},48733.524527876973,73204.685727561271,48733.524527876973,73204.685727561271,56530.888452337284,84917.435443971073,null,56530.885649777279,64822.247510590081]
[null,38,null,{"$f":"FACTORES!F77","v":17812.78},{"$f":"FACTORES!G77","v":20325.439999999999},51328.694527876971,75672.955727561275,51328.694527876971,75672.955727561275,59541.285652337283,87780.628643971068,null,59541.288400702077,67685.432951767682]
[null,39,null,{"$f":"FACTORES!F78","v":18805.88},{"$f":"FACTORES!G78","v":21259.279999999999},54103.594527876972,78282.265727561273,54103.594527876972,78282.265727561273,62760.169652337281,90807.428243971066,null,62760.167975998091,70712.236398142064]
[null,40,null,{"$f":"FACTORES!F79","v":19473.18},{"$f":"FACTORES!G79","v":22230.240000000002},55968.144527876968,80995.295727561272,55968.144527876968,80995.295727561272,64923.047652337278,93954.543043971062,null,64923.050203966079,73859.354827735689]
[null,41,null,{"$f":"FACTORES!F80","v":20204.39},{"$f":"FACTORES!G80","v":23249.33},58011.274527876973,83842.815727561261,58011.274527876973,83842.815727561261,67293.078452337286,97257.666243971049,null,67293.080346199669,77162.474338750093]
[null,42,null,{"$f":"FACTORES!F81","v":21001.95},{"$f":"FACTORES!G81","v":24312.41},60239.794527876969,86813.245727561254,60239.794527876969,86813.245727561254,69878.16165233728,100703.36504397105,null,69878.16703844929,80608.176180362876]
[null,43,null,{"$f":"FACTORES!F82","v":21864.959999999999},{"$f":"FACTORES!G82","v":25420.98},62651.204527876973,89910.785727561262,62651.204527876973,89910.785727561262,72675.397252337279,104296.51144397106,null,72675.393160970882,84201.322218814079]
[null,44,null,{"$f":"FACTORES!F83","v":22819.46},{"$f":"FACTORES!G83","v":26700.38},65318.244527876966,93485.655727561258,65318.244527876966,93485.655727561258,75769.163652337273,108443.36064397106,null,75769.160711690885,88348.169997118079]
[null,45,null,{"$f":"FACTORES!F84","v":23857.66},{"$f":"FACTORES!G84","v":27964.35},68219.154527876963,97017.415727561267,68219.154527876963,97017.415727561267,79134.219252337265,112540.20224397106,null,79134.220398602876,92445.005378033282]
[null,46,null,{"$f":"FACTORES!F85","v":25004.76},{"$f":"FACTORES!G85","v":29044.86},71424.35452787696,100036.54572756126,71424.35452787696,100036.54572756126,82852.251252337272,116042.39304397105,null,82852.251574538866,95947.202105354881]
[null,47,null,{"$f":"FACTORES!F86","v":26257.33},{"$f":"FACTORES!G86","v":30538.05},74924.254527876968,104208.78572756126,74924.254527876968,104208.78572756126,86912.135252337277,120882.19144397105,null,86912.136772030091,100786.99547262526]
[null,48,null,{"$f":"FACTORES!F87","v":27630.6},{"$f":"FACTORES!G87","v":31787.82},78761.414527876957,107700.85572756125,78761.414527876957,107700.85572756125,91363.240852337258,124932.99264397104,null,91363.240139633257,104837.80518646848]
[null,49,null,{"$f":"FACTORES!F88","v":29133.77},{"$f":"FACTORES!G88","v":33137.160000000003},82961.534527876967,111471.15572756126,82961.534527876967,111471.15572756126,96235.380052337277,129306.54064397105,null,96235.381123620478,109211.34558132286]
[null,50,null,{"$f":"FACTORES!F89","v":30772.28},{"$f":"FACTORES!G89","v":34564.14},{"$f":"ROUND(D71*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":87539.824527876961},115458.38572756125,87539.824527876961,115458.38572756125,101546.19645233727,133931.72744397103,null,101546.19209222209,113836.53617275966]
[null,51,null,{"$f":"FACTORES!F90","v":32536.15},{"$f":"FACTORES!G90","v":36102.97},92468.384527876959,119758.14572756126,92468.384527876959,119758.14572756126,107263.32605233726,138919.44904397105,null,107263.32542872128,118824.25992349249]
[null,52,null,{"$f":"FACTORES!F91","v":34459.83},{"$f":"FACTORES!G91","v":37751.29},97843.484527876964,124363.84572756126,97843.484527876964,124363.84572756126,113498.44205233727,144262.06104397104,null,113498.44199443008,124166.8674973037]
[null,53,null,{"$f":"FACTORES!F92","v":36562.410000000003},{"$f":"FACTORES!G92","v":39519.4},103718.46452787696,129304.25572756126,103718.46452787696,129304.25572756126,120313.41885233727,149992.93664397104,null,120313.41714036289,129897.74370904127]
[null,54,null,{"$f":"FACTORES!F93","v":38838.239999999998},{"$f":"FACTORES!G93","v":41399.589999999997},110077.53452787697,134557.83572756124,110077.53452787697,134557.83572756124,127689.94005233728,156087.08944397102,null,127689.93783701565,135991.89856623166]
[null,55,null,{"$f":"FACTORES!F94","v":41263.480000000003},{"$f":"FACTORES!G94","v":43358.49},116854.08452787696,{"$f":"ROUND(E76*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":122707.90452787696},116854.08452787696,122707.90452787696,135550.73805233726,142341.16925233728,null,135550.73282361406,142341.17175125566]
[null,56,null,{"$f":"FACTORES!F95","v":43907.07},{"$f":"FACTORES!G95","v":46001.58},124240.73452787696,130093.16452787696,124240.73452787696,130093.16452787696,144119.25205233728,150908.07085233726,null,144119.25347254844,150908.07177811008]
[null,57,null,{"$f":"FACTORES!F96","v":46743.42},{"$f":"FACTORES!G96","v":47794.59},132165.99452787696,135103.15452787696,132165.99452787696,135103.15452787696,153312.55365233726,156719.65925233727,null,153312.55634576446,156719.65496943166]
[null,58,null,{"$f":"FACTORES!F97","v":48777.47},{"$f":"FACTORES!G97","v":49728.61},137849.49452787696,140507.14452787695,137849.49452787696,140507.14452787695,159905.41365233727,162988.28765233725,null,159905.40902941246,162988.28599975488]
[null,59,null,{"$f":"FACTORES!F98","v":51975.72},{"$f":"FACTORES!G98","v":50587},146785.96452787696,142905.63452787697,146785.96452787696,142905.63452787697,170271.71885233728,165770.53605233727,null,170271.71816413247,165770.53757425729]
[null,60,null,{"$f":"FACTORES!F99","v":69402.740000000005},{"$f":"FACTORES!G99","v":68905.960000000006},195480.12452787696,194092.03452787697,195480.12452787696,194092.03452787697,226756.94445233725,225146.76005233725,null,226756.94496533572,225146.7596915309]
[null,61,null,{"$f":"FACTORES!F100","v":73238.990000000005},{"$f":"FACTORES!G100","v":71930.13},206199.28452787697,202542.09452787697,206199.28452787697,202542.09452787697,239191.17005233726,234948.82965233727,null,239191.16787413572,234948.8330428781]
[null,62,null,{"$f":"FACTORES!F101","v":77145.19},{"$f":"FACTORES!G101","v":75041.95},217113.89452787695,211237.07452787698,217113.89452787695,211237.07452787698,251852.11765233724,245035.00645233729,null,251852.11581192765,245035.0014448493]
[null,63,null,{"$f":"FACTORES!F102","v":81435.78},{"$f":"FACTORES!G102","v":78314.67},229102.55452787696,220381.62452787696,229102.55452787696,220381.62452787696,265758.96325233724,255642.68445233727,null,265758.96559238207,255642.68603216446]
[null,64,null,{"$f":"FACTORES!F103","v":85761.32},{"$f":"FACTORES!G103","v":81793.429999999993},241188.87452787696,230101.89452787695,241188.87452787696,230101.89452787695,279779.09445233725,266918.19765233726,null,{"$f":"(D85*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":279779.09685622848},{"$f":"(E85*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":266918.196566206}]
[null,65,null,{"$f":"FACTORES!F104","v":90339.87},{"$f":"FACTORES!G104","v":85386.07},253982.15452787696,240140.36452787695,{"$f":"(F86*(1+$I$18))+$I$19","v":253982.15452787696},{"$f":"(G86*(1+$I$18))+$I$19","v":240140.36452787695},{"$f":"H86*(1+$K$19)","v":294619.29925233725},{"$f":"I86*(1+$K$19)","v":278562.82285233727},null,294619.29530499643,278562.81998518849]
[null,{"$f":"+B86+1","v":66},null,{"$f":"FACTORES!F105","v":95132.5},{"$f":"FACTORES!G105","v":89184.03},267373.604527877,250752.53452787697,267373.604527877,250752.53452787697,310153.38125233731,290872.94005233725,null,310153.37930353725,290872.93565510208]
[null,67,null,{"$f":"FACTORES!F106","v":100077.75999999999},{"$f":"FACTORES!G106","v":93035.05},281191.534527877,261512.95452787695,281191.534527877,261512.95452787695,326182.18005233729,303355.02725233726,null,326182.17439821886,303355.03174014523]
[null,68,null,{"$f":"FACTORES!F107","v":105302.25},{"$f":"FACTORES!G107","v":97108.85},295789.67452787701,272895.87452787696,295789.67452787701,272895.87452787696,343116.02245233732,316559.21445233724,null,343116.02209969732,316559.21219915332]
[null,69,null,{"$f":"FACTORES!F108","v":110507.49},{"$f":"FACTORES!G108","v":101417.29},310334.034527877,284934.414527877,310334.034527877,284934.414527877,359987.48005233728,330523.92085233732,null,359987.47585109569,330523.91818786366]
[null,70,null,{"$f":"FACTORES!F109","v":116051.9},{"$f":"FACTORES!G109","v":105828.44},325826.08452787698,297259.94452787697,325826.08452787698,297259.94452787697,377958.25805233727,344821.53565233725,null,377958.26238424133,344821.53236424766]
[null,71,null,{"$f":"FACTORES!F110","v":121870.68},{"$f":"FACTORES!G110","v":110273.55},342084.784527877,309680.36452787701,342084.784527877,309680.36452787701,396818.35005233728,359229.22285233729,null,396818.349077566,359229.21919230535]
[null,72,null,{"$f":"FACTORES!F111","v":127707.53},{"$f":"FACTORES!G111","v":115114.48},358393.974527877,323206.77452787699,358393.974527877,323206.77452787699,415737.01045233727,374919.85845233727,null,415737.00505286217,374919.85528377403]
[null,73,null,{"$f":"FACTORES!F112","v":133881.18},{"$f":"FACTORES!G112","v":119998.29},375644.23452787701,336852.99452787702,375644.23452787701,336852.99452787702,435747.31205233728,390749.47365233733,null,435747.31206124608,390749.47592482372]
[null,74,null,{"$f":"FACTORES!F113","v":140095.79},{"$f":"FACTORES!G113","v":124966.98},393008.94452787697,350736.39452787698,393008.94452787697,350736.39452787698,455890.37565233727,406854.21765233728,null,455890.38043042377,406854.21337017411]
[null,75,null,{"$f":"FACTORES!F114","v":146539.84},{"$f":"FACTORES!G114","v":130076.54},411014.75452787697,365013.40452787699,411014.75452787697,365013.40452787699,476777.11525233724,423415.54925233725,null,476777.11985967169,423415.5448803436]
[null,76,null,{"$f":"FACTORES!F115","v":154118.04},{"$f":"FACTORES!G115","v":135852.78},432189.58452787698,381153.23452787701,432189.58452787698,381153.23452787701,501339.91805233725,442137.75205233728,null,501339.91635298362,442137.749047102]
[null,77,null,{"$f":"FACTORES!F116","v":161925.42000000001},{"$f":"FACTORES!G116","v":142014.06},454004.77452787699,398368.93452787702,454004.77452787699,398368.93452787702,526645.53845233726,462107.96405233734,null,526645.5411828846,462107.96186522685]
[null,78,null,{"$f":"FACTORES!F117","v":170229.8},{"$f":"FACTORES!G117","v":148405.04999999999},477208.67452787701,416226.48452787701,477208.67452787701,416226.48452787701,553562.06245233724,482822.72205233731,null,553562.0643603052,482822.72087934526]
[null,79,null,{"$f":"FACTORES!F118","v":179655.48},{"$f":"FACTORES!G118","v":154794.95000000001},503545.68452787702,434080.98452787701,503545.68452787702,434080.98452787701,584112.99405233725,503533.94205233728,null,584112.99461433419,503533.94693732937]
[null,80,null,{"$f":"FACTORES!F119","v":188656.95},{"$f":"FACTORES!G119","v":161504.35999999999},528697.37452787696,452828.26452787698,528697.37452787696,452828.26452787698,613288.95445233723,525280.7868523373,null,613288.95668324933,525280.78291687486]
[null,81,null,{"$f":"FACTORES!F120","v":198972.08},{"$f":"FACTORES!G120","v":168271.8},557519.664527877,471737.68452787702,557519.664527877,471737.68452787702,646722.81085233728,547215.71405233734,null,646722.81155539001,547215.70829502528]
[null,82,null,{"$f":"FACTORES!F121","v":209490.34},{"$f":"FACTORES!G121","v":175111.75},586909.534527877,490849.70452787698,586909.534527877,490849.70452787698,680815.06005233724,569385.6572523372,null,680815.06035375176,569385.65628721716]
[null,83,null,{"$f":"FACTORES!F122","v":220555.07},{"$f":"FACTORES!G122","v":182858.71},617826.33452787704,512496.07452787698,617826.33452787704,512496.07452787698,716678.54805233737,594495.4464523372,null,716678.55184822844,594495.44514497078]
[null,84,null,{"$f":"FACTORES!F123","v":232613.37},{"$f":"FACTORES!G123","v":190414.64},651519.35452787695,533608.67452787701,{"$f":"(F105*(1+$I$18))+$I$19","v":651519.35452787695},{"$f":"(G105*(1+$I$18))+$I$19","v":533608.67452787701},{"$f":"H105*(1+$K$19)","v":755762.4512523372},{"$f":"I105*(1+$K$19)","v":618986.06245233724},null,{"$f":"(D105*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":755762.44630275643},{"$f":"(E105*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":618986.05913083989}]
[null,85,null,{"$f":"FACTORES!F124","v":244552.46},{"$f":"FACTORES!G124","v":197720.65},684879.26452787698,554022.94452787703,{"$f":"(F106*(1+$I$18))+$I$19","v":684879.26452787698},{"$f":"(G106*(1+$I$18))+$I$19","v":554022.94452787703},{"$f":"H106*(1+$K$19)","v":794459.94685233722},{"$f":"I106*(1+$K$19)","v":642666.61565233732},null,{"$f":"(D106*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":794459.95204097102},{"$f":"(E106*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":642666.62137624132}]

{"sheet":"DEPENDIENTE","index":3,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":true,"merged":[[1,8,7,9],[10,8,12,9],[18,5,18,6],[145,22,145,23],[145,20,145,21],[68,19,68,26],[130,19,130,22],[73,19,73,26],[129,19,129,26],[28,17,29,18],[19,1,19,2],[18,3,18,4],[17,9,17,10],[17,3,17,4],[17,5,17,6]]}
[null,null,"GASTOS MÉDICOS MAYORES INDIVIDUAL/FAMILIAR",null,null,null,null,null,"REGION COBERTURA BASICA"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(E3,VALORES!$A$6:$B$11,2,FALSE)),\"REGION NO VALIDA\",VLOOKUP(E3,VALORES!$A$6:$B$11,2,FALSE))","v":"BAJA CALIFORNIA, BAJA CALIFORNIA SUR, MORELOS, QUINTANA ROO, QUERETARO, SAN LUIS POTOSI, SINALOA, SONORA"}]
[null,"REGIÓN:",null,null,{"$f":"+COTIZACION!D14","v":5},{"$f":"IF(E3>7,\"NO PROCEDE\",\" \")","v":" "},"FACTORES"]
[]
[null,"SUMA ASEGURADA:",null,null,{"$f":"+COTIZACION!D10","v":10000000},null,{"$f":"+TITULAR!G5","v":1.26}]
[null,"DEDUCIBLE:",null,null,{"$f":"+COTIZACION!D11","v":10000},null,{"$f":"+TITULAR!G6","v":0.88}]
[null,"COASEGURO:",null,null,{"$f":"+COTIZACION!D12","v":0.1},null,{"$f":"+TITULAR!G8","v":1}]
[null,"CATALOGO:",null,null,{"$f":"COTIZACION!$D$25","v":0},null,{"$f":"+TITULAR!G9","v":1}]
[null,null,null,null,null,"ZONA",null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,"EMERGENCIA EXTRANJERO:",null,null,{"$f":"+COTIZACION!D21","v":"SI"},null,{"$f":"+TITULAR!G14","v":1.05},null,"ZONA COBERTURAS ADICIONALES",null,null,null,null,null,null,null,null,null,"S"]
[null,"COBER TOTAL EXTRANJERO:",null,null,{"$f":"+COTIZACION!D20","v":"SI"},{"$f":"+COTIZACION!D22","v":"B"},{"$f":"+TITULAR!G15","v":2.4},null,{"$f":"IF(F10=F11,VLOOKUP(F10,VALORES!$A$31:$B$33,2,FALSE),\"ZONAS DIFERENTES\")","v":"ZONAS DIFERENTES"},null,"A"]
[null,null,null,null,null,null,null,null,null,null,"B"]
[null,"FORMA DE PAGO:",null,null,{"$f":"+COTIZACION!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+TITULAR!G17","v":0},null,null,null,"C"]
[]
[]
[]
[]
[null,null,null,"PRIMA BASE ",null,"PRIMA TARIFA ",null,"R P FRAC",{"$f":"G13","v":0},"PRIMA TOTAL"]
[null,null,null,"REGIONALIZADA",null,"REGIONALIZADA",null,"DER POLIZA",0,"IVA",{"$f":"+COTIZACION!D26","v":0.16}]
[null,"EDAD",null,"HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER"]
[null,0,null,{"$f":"FACTORES!F39","v":6985.42},{"$f":"FACTORES!G39","v":6989.76},{"$f":"ROUND(D21*$G$5*$G$6*$G$7*$G$10*$G$11*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":21075.144527876975},{"$f":"ROUND(E21*$G$5*$G$6*$G$7*$G$10*$G$11*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":21087.274527876973},{"$f":"(F21*(1+$I$18))+$I$19","v":21075.144527876975},{"$f":"(G21*(1+$I$18))+$I$19","v":21087.274527876973},{"$f":"H21*(1+$K$19)","v":24447.167652337288},{"$f":"I21*(1+$K$19)","v":24461.238452337286}]
[null,{"$f":"+B21+1","v":1},null,{"$f":"FACTORES!F40","v":6985.42},{"$f":"FACTORES!G40","v":6989.76},21075.144527876975,21087.274527876973,{"$f":"(F22*(1+$I$18))+$I$19","v":21075.144527876975},{"$f":"(G22*(1+$I$18))+$I$19","v":21087.274527876973},{"$f":"H22*(1+$K$19)","v":24447.167652337288},{"$f":"I22*(1+$K$19)","v":24461.238452337286}]
[null,{"$f":"+B22+1","v":2},null,{"$f":"FACTORES!F41","v":6985.42},{"$f":"FACTORES!G41","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,3,null,{"$f":"FACTORES!F42","v":6985.42},{"$f":"FACTORES!G42","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,4,null,{"$f":"FACTORES!F43","v":6985.42},{"$f":"FACTORES!G43","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,5,null,{"$f":"FACTORES!F44","v":6985.42},{"$f":"FACTORES!G44","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,6,null,{"$f":"FACTORES!F45","v":6985.42},{"$f":"FACTORES!G45","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,7,null,{"$f":"FACTORES!F46","v":6985.42},{"$f":"FACTORES!G46","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,8,null,{"$f":"FACTORES!F47","v":6985.42},{"$f":"FACTORES!G47","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,9,null,{"$f":"FACTORES!F48","v":6985.42},{"$f":"FACTORES!G48","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,10,null,{"$f":"FACTORES!F49","v":6985.42},{"$f":"FACTORES!G49","v":6989.76},21075.144527876975,21087.274527876973,21075.144527876975,21087.274527876973,24447.167652337288,24461.238452337286]
[null,11,null,{"$f":"FACTORES!F50","v":6946.01},{"$f":"FACTORES!G50","v":6882.92},20965.024527876973,20788.744527876974,20965.024527876973,20788.744527876974,24319.428452337288,24114.94365233729]
[null,12,null,{"$f":"FACTORES!F51","v":6913.99},{"$f":"FACTORES!G51","v":6977.01},20875.554527876975,21051.644527876975,20875.554527876975,21051.644527876975,24215.64325233729,24419.90765233729]
[null,13,null,{"$f":"FACTORES!F52","v":6866.26},{"$f":"FACTORES!G52","v":6931.11},20742.194527876974,20923.394527876975,20742.194527876974,20923.394527876975,24060.94565233729,24271.137652337289]
[null,14,null,{"$f":"FACTORES!F53","v":6687.98},{"$f":"FACTORES!G53","v":6789.98},20244.044527876973,20529.054527876975,20244.044527876973,20529.054527876975,23483.091652337287,23813.703252337291]
[null,15,null,{"$f":"FACTORES!F54","v":6715.22},{"$f":"FACTORES!G54","v":6679.78},20320.164527876972,20221.134527876973,20320.164527876972,20221.134527876973,23571.390852337285,23456.516052337287]
[null,16,null,{"$f":"FACTORES!F55","v":6589.64},{"$f":"FACTORES!G55","v":6426.46},19969.264527876974,19513.314527876973,19969.264527876974,19513.314527876973,23164.346852337287,22635.444852337288]
[null,17,null,{"$f":"FACTORES!F56","v":6625.9},{"$f":"FACTORES!G56","v":6528.29},20070.584527876974,19797.844527876972,20070.584527876974,19797.844527876972,23281.878052337288,22965.499652337287]
[null,18,null,{"$f":"FACTORES!F57","v":6819.73},{"$f":"FACTORES!G57","v":6168.12},{"$f":"ROUND(D39*$G$5*$G$6*$G$7*$G$10*$G$11*$G$8,2)+ADIC+DENTAL+IKE+CVISION","v":20612.184527876972},{"$f":"ROUND(E39*$G$5*$G$6*$G$7*$G$10*$G$11*$G$8,2)+ADIC+DENTAL+IKE+PARTO+CVISION","v":36114.905727561265},20612.184527876972,36114.905727561265,23910.134052337286,41893.290643971064]
[null,19,null,{"$f":"FACTORES!F58","v":7051.24},{"$f":"FACTORES!G58","v":6259.8},21259.064527876973,36371.075727561263,21259.064527876973,36371.075727561263,24660.514852337288,42190.447843971066]
[null,20,null,{"$f":"FACTORES!F59","v":7265.19},{"$f":"FACTORES!G59","v":7264.01},21856.874527876975,39177.015727561266,21856.874527876975,39177.015727561266,25353.97445233729,45445.338243971062]
[null,21,null,{"$f":"FACTORES!F60","v":7647.45},{"$f":"FACTORES!G60","v":9419.34},22924.974527876973,45199.385727561261,22924.974527876973,45199.385727561261,26592.970452337286,52431.287443971058]
[null,22,null,{"$f":"FACTORES!F61","v":7990.45},{"$f":"FACTORES!G61","v":9874.5499999999993},23883.374527876975,46471.325727561263,23883.374527876975,46471.325727561263,27704.714452337288,53906.737843971059]
[null,23,null,{"$f":"FACTORES!F62","v":8517.9500000000007},{"$f":"FACTORES!G62","v":10347.18},25357.304527876975,47791.935727561264,25357.304527876975,47791.935727561264,29414.473252337288,55438.645443971065]
[null,24,null,{"$f":"FACTORES!F63","v":8872.17},{"$f":"FACTORES!G63","v":10840.06},26347.054527876975,49169.135727561261,26347.054527876975,49169.135727561261,30562.583252337288,57036.197443971061]

{"sheet":"VALORES","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["COTIZACIÓN"]
["R = RENOVACIÓN"]
["N = NUEVA"]
[]
["NO.","REGIÓN"]
[1,"CAMPECHE, CHIAPAS, GUERRERO, OAXACA, TABASCO, TLAXCALA, VERACRUZ, YUCATAN"]
[2,"HIDALGO, NAYARIT, PUEBLA"]
[3,"AGUASCALIENTES, COAHUILA, COLIMA, DURANGO, GUANAJUATO, JALISCO, MICHOACAN, ZACATECAS"]
[4,"CHIHUAHUA, NUEVO LEON, TAMAULIPAS"]
[5,"BAJA CALIFORNIA, BAJA CALIFORNIA SUR, MORELOS, QUINTANA ROO, QUERETARO, SAN LUIS POTOSI, SINALOA, SONORA"]
[6,"DISTRITO FEDERAL, EDO. DE MEXICO"]
[]
["SUMA ASEGURADA",null,"DEDUCIBLE",null,"COASEGURO",null,"FORMA DE PAGO","FORMA DE PAGO"]
[500000,null,4000,null,0,null,"A","ANUAL"]
[750000,null,4500,null,0.05,null,"S","SEMESTRAL"]
[1000000,null,5000,null,0.1]
[{"$f":"+A16+1000000","v":2000000},null,6000,null,0.15]
[{"$f":"+A17+1000000","v":3000000},null,7000,null,0.2]
[4000000,null,8000,null,0.25]
[5000000,null,9000,null,0.3]
[6000000,null,10000,null,0.35]
[7000000,null,20000,null,0.4]
[8000000,null,50000]
[9000000]
[]
[]
[]
[]
[]
["ZONA"," EMERGENCIA EN EL EXTRANJERO"]
["A","CIUDADES A 20 KM. DE LA FRANJA FRONTERIZA CON LOS E.U.A."]
["B","BAJA CALIFORNIA, BAJA CALIFORNIA SUR, SONORA, CHIHUAHUA, COAHUILA, NUEVO LEÓN, CAMPECHE, YUCATÁN Y QUINTANA ROO"]
["C"," EL RESTO DEL PAÍS (EXCEPTO ZONA A Y ZONA B)"]
[]
[" COBERTURA EN EL EXTRANJERO"]
[" ZONA A = CIUDADES A 20 KM. DE LA FRANJA FRONTERIZA CON LOS E.U.A."]
[" ZONA B = BAJA CALIFORNIA, BAJA CALIFORNIA SUR, SONORA, CHIHUAHUA, COAHUILA, NUEVO LEÓN, CAMPECHE, YUCATÁN Y QUINTANA ROO"]
[" ZONA C = EL RESTO DEL PAÍS"]

{"sheet":"CuadroEspecificacionesTARIFARIO","index":5,"n_rows":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":true,"merged":[[8,2,8,9],[13,1,13,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-02-08"}]
[]
[null,null,null,null,null,null,null,null,"REGIÓN",{"$f":"TITULAR!E3","v":5}]
[]
[null,"CUADRO DE COBERTURAS"]
[null,"-","Tipo de Hospital",null,null,null,null,"Todos los hospitales"]
[]
[null,"-","Suma Asegurada",null,null,null,null,{"$f":"+TITULAR!E5","v":10000000},{"$f":"IF(H17<>\"SIN LÍMITE\",\"M.N.\",\"\")","v":"M.N."}]
[]
[null,"-","Deducible",null,null,"Enfermedad",null,{"$f":"+TITULAR!E6","v":10000},"M.N."]
[null,null,null,null,null,"Accidente",null,0,"M.N."]
[]
[null,"-","Coaseguro",null,null,"Enfermedad",null,{"$f":"+TITULAR!E8","v":0.1},{"$f":"+COTIZACION!S29","v":0}]
[null,null,null,null,null,"Accidente",null,0]
[]
[null,{"$f":"+COTIZACION!L32","v":0},{"$f":"+COTIZACION!M32","v":0},null,null,null,null,{"$f":"+TITULAR!E9","v":0}]
[null,{"$f":"+COTIZACION!L33","v":0},{"$f":"+COTIZACION!M33","v":0},null,null,null,null,{"$f":"+COTIZACION!R33","v":0},{"$f":"+COTIZACION!S33","v":0}]
[]
[]
[null,{"$f":"+COTIZACION!L36","v":0},{"$f":"+COTIZACION!M36","v":0},null,null,null,null,{"$f":"+COTIZACION!R36","v":0}]
[null,{"$f":"+COTIZACION!L37","v":0},{"$f":"+COTIZACION!M37","v":0},null,null,null,null,{"$f":"+COTIZACION!R37","v":0}]
[null,{"$f":"+COTIZACION!L38","v":0},{"$f":"+COTIZACION!M38","v":0},null,null,null,null,{"$f":"+COTIZACION!R38","v":0}]
[null,{"$f":"+COTIZACION!L39","v":0},{"$f":"+COTIZACION!M39","v":0},null,null,null,null,{"$f":"+COTIZACION!R39","v":0}]
[null,{"$f":"+COTIZACION!L40","v":0},{"$f":"+COTIZACION!M40","v":0}]
[null,null,{"$f":"+COTIZACION!M41","v":0},null,null,null,null,{"$f":"+COTIZACION!R41","v":0}]
[null,{"$f":"+COTIZACION!L42","v":0},{"$f":"+COTIZACION!M42","v":0},null,null,null,null,{"$f":"+COTIZACION!R42","v":0}]
[null,{"$f":"+COTIZACION!L43","v":0},{"$f":"+COTIZACION!M43","v":0},null,null,null,null,{"$f":"+COTIZACION!R43","v":0}]
[null,{"$f":"+COTIZACION!L44","v":0},{"$f":"+COTIZACION!M44","v":0},null,null,null,null,{"$f":"+COTIZACION!R44","v":0}]
[null,{"$f":"+COTIZACION!L45","v":0},{"$f":"+COTIZACION!M45","v":0},null,null,null,null,{"$f":"+COTIZACION!R45","v":0}]
[null,{"$f":"+COTIZACION!L46","v":0},{"$f":"+COTIZACION!M46","v":0},null,null,null,null,{"$f":"+COTIZACION!R46","v":0}]
[null,{"$f":"+COTIZACION!L47","v":0},{"$f":"+COTIZACION!M47","v":0},null,null,null,null,{"$f":"+COTIZACION!R47","v":0}]
[null,{"$f":"+COTIZACION!L48","v":0},{"$f":"+COTIZACION!M48","v":0}]
[null,null,{"$f":"+COTIZACION!M49","v":0},null,null,null,null,{"$f":"FACTORES!D37","v":0}]
[null,{"$f":"+COTIZACION!L50","v":0},{"$f":"+COTIZACION!M50","v":0}]
[null,null,{"$f":"+COTIZACION!M51","v":0},null,null,null,null,{"$f":"+COTIZACION!R51","v":0}]
[null,{"$f":"+COTIZACION!L52","v":0},{"$f":"+COTIZACION!M52","v":0}]
[null,null,{"$f":"+COTIZACION!M53","v":0},null,null,null,null,{"$f":"+COTIZACION!R53","v":0}]
[null,{"$f":"+COTIZACION!L54","v":0},{"$f":"+COTIZACION!M54","v":0},null,null,null,null,{"$f":"+COTIZACION!R54","v":0}]
[null,null,{"$f":"+COTIZACION!M55","v":0}]
[null,{"$f":"+COTIZACION!L56","v":0},{"$f":"+COTIZACION!M56","v":0},null,null,null,null,{"$f":"+COTIZACION!R56","v":0}]
[null,{"$f":"+COTIZACION!L57","v":0},{"$f":"+COTIZACION!M57","v":0}]
[null,null,{"$f":"+COTIZACION!M58","v":0}]
[null,null,{"$f":"+COTIZACION!M59","v":0}]
[null,null,{"$f":"+COTIZACION!M60","v":0}]
[null,null,{"$f":"+COTIZACION!M61","v":0},null,null,null,null,{"$f":"+COTIZACION!R61","v":0}]
[null,{"$f":"+COTIZACION!L62","v":0},{"$f":"+COTIZACION!M62","v":0},null,null,null,null,{"$f":"+COTIZACION!R62","v":0}]
[null,{"$f":"+COTIZACION!L63","v":0},{"$f":"+COTIZACION!M63","v":0}]
[null,null,{"$f":"+COTIZACION!M64","v":0},null,null,null,null,{"$f":"+COTIZACION!R64","v":0}]
[null,{"$f":"+COTIZACION!L65","v":0},{"$f":"+COTIZACION!M65","v":0},null,null,null,null,{"$f":"+COTIZACION!R65","v":0}]
[null,{"$f":"+COTIZACION!L66","v":0},{"$f":"+COTIZACION!M66","v":0}]
[null,null,{"$f":"+COTIZACION!M67","v":0},null,null,null,null,{"$f":"+COTIZACION!R67","v":0}]
[null,{"$f":"+COTIZACION!L68","v":0},{"$f":"+COTIZACION!M68","v":0},null,null,null,null,{"$f":"+COTIZACION!R68","v":0}]
[null,{"$f":"+COTIZACION!L69","v":0},{"$f":"+COTIZACION!M69","v":0},null,null,null,null,{"$f":"+COTIZACION!R69","v":0}]
[null,{"$f":"+COTIZACION!L70","v":0},{"$f":"+COTIZACION!M70","v":0},null,null,null,null,{"$f":"+COTIZACION!R70","v":0}]
[null,{"$f":"+COTIZACION!L71","v":0},{"$f":"+COTIZACION!M71","v":0},null,null,null,null,{"$f":"+COTIZACION!R71","v":0}]
[null,{"$f":"+COTIZACION!L72","v":0},{"$f":"+COTIZACION!M72","v":0},null,null,null,null,{"$f":"+COTIZACION!R72","v":0}]
[null,{"$f":"+COTIZACION!L73","v":0},{"$f":"+COTIZACION!M73","v":0},null,null,null,null,{"$f":"+COTIZACION!R73","v":0}]
[null,{"$f":"+COTIZACION!L74","v":0},{"$f":"+COTIZACION!M74","v":0},null,null,null,null,{"$f":"+COTIZACION!R74","v":0}]
[null,{"$f":"+COTIZACION!L75","v":0},{"$f":"+COTIZACION!M75","v":0},null,null,null,null,{"$f":"+COTIZACION!R75","v":0}]
[null,{"$f":"+COTIZACION!L76","v":0},{"$f":"+COTIZACION!M76","v":0},null,null,null,null,{"$f":"+COTIZACION!R76","v":0}]
[null,{"$f":"+COTIZACION!L77","v":0},{"$f":"+COTIZACION!M77","v":0},null,null,null,null,{"$f":"+COTIZACION!R77","v":0}]
[null,"-","En atención en Hospiten aplica deducible y coaseguro "]

{"sheet":"COTIZACION","index":6,"n_rows":366,"n_cols":11,"rows_kept":366,"cut":false,"hidden":true,"merged":[[92,14,92,15],[90,14,90,15],[104,12,104,19],[105,12,106,19],[96,13,96,15],[94,12,94,13],[91,14,91,15],[5,1,5,2],[22,5,23,7],[10,12,10,19],[79,12,79,15],[17,11,18,19],[41,2,41,4],[38,8,40,9],[14,1,14,2],[21,5,21,7],[43,1,43,5]]}
[]
[]
[]
[]
[]
[null,"DATOS DE LA PÓLIZA"]
[{"$f":"+VLOOKUP(D7,G241:H242,2,FALSE)","v":0},"Tipo de Póliza",null,"NUEVA",{"$f":"+IF(AND(D7=\"NUEVA\",D8=\"ANTES DEL 01/10/2016\"),\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",CONCATENATE(\"APLICA PARA AQUELLA PÓLIZA \",D7,\" CON PRIMER VIGENCIA EMITIDA \",D8))","v":"APLICA PARA AQUELLA PÓLIZA NUEVA CON PRIMER VIGENCIA EMITIDA A PARTIR DEL 01/10/2016"}]
[{"$f":"+VLOOKUP(D8,G243:H244,2,FALSE)","v":0},"Primera vigencia emitida en Seguros Banorte",null,"A PARTIR DEL 01/10/2016"]
[null,"TIPO DE COTIZACIÓN",null,"FAMILIAR"]
[null,"Suma Asegurada",null,10000000]
[null,"Deducible",null,10000,{"$f":"+IF(D7=\"NUEVA\",IF(D11<10000,\"Deducible no permitido para pólizas nuevas\",\"\"),\"\")","v":""}]
[null,{"$f":"+\"Coaseguro \"&CONCATENATE(\"con tope de \",VLOOKUP(IMPRESION!I19,FACTORES!C3:E6,3,FALSE))","v":"Coaseguro con tope de $35,000"},null,0.1]
[null,"Estado",null,"CIUDAD DE MÉXICO"]
[null,"Región",null,{"$f":"+VLOOKUP(D13,$C$316:$D$347,2,0)","v":5}]
[{"$f":"IF(AND(D15=\"SI\",D11>50000),\"EL LIMITE ES $50,000\",\" \")","v":" "},"Eliminación de Deducible por Accidente",null,"SI",{"$f":"+IF(AND(D15=\"si\",D11>50000),\"El deducible límite es $50,000\",\"\")","v":""}]
[{"$f":"IF(D11>50000,\"NO\",D16)","v":"SI"},"Incremento en Parto o Cesárea",null,"SI"]
[null,"Suma Asegurada Parto o Cesárea",null,40000,{"$f":"IF(D7=\"NUEVA\",IF(D17=50000,\"SUMA ASEGURADA NO PERMITIDA PARA PÓLIZAS NUEVAS\",IF(D16=\"SI\",IF(D11<60000,\"DEFINA LA SUMA ASEGURADA\",\"ESTA COBERTURA NO APLICA CON DEDUCIBLE MAYOR A $50,000\"),\"\")),IF(D16=\"SI\",IF(D11<60000,\"DEFINA LA SUMA ASEGURADA\",\"ESTA COBERTURA NO APLICA CON DEDUCIBLE MAYOR A $50,000\"),\"\"))","v":"DEFINA LA SUMA ASEGURADA"}]
[null,"Cobertura de Visión Incremental",null,"SI"]
[null,"Cobertura de Indemnización por Enfermedad Grave",null,10000,{"$f":"IF(AND(D19<>\"NO\",SUM(A30:A37)<1),\"NO CUMPLE CON LOS LIMITES DE EDAD\",\"\")","v":""}]
[null,"Cobertura Total en el Extranjero",null,"SI",{"$f":"IF(D20=\"SI\",\"DEFINA LA ZONA COBERTURA TOTAL EN EL EXTRANJERO\",\"\")","v":"DEFINA LA ZONA COBERTURA TOTAL EN EL EXTRANJERO"}]
[null,"Emergencia en el Extranjero",null,"SI"]
[null,"Zona CoberturaTotal en el Extranjero",null,"B",null,{"$f":"\"ZONA \"&D22&\" incluye:\"","v":"ZONA B incluye:"}]
[null,null,null,null,null,{"$f":"IF(D20=\"SI\",VLOOKUP(D22,VALORES!$A$31:$B$33,2,FALSE),\" \")","v":"BAJA CALIFORNIA, BAJA CALIFORNIA SUR, SONORA, CHIHUAHUA, COAHUILA, NUEVO LEÓN, CAMPECHE, YUCATÁN Y QUINTANA ROO"}]
[]
[null,"Inc THQ",null,0]
[null,"IVA ",null,0.16]
[null,null,null,null,null,null,null,null,"DESCUENTO",0]
[]
[null,null,"NOMBRE","NOMBRE"]
[{"$f":"IF($D$7=\"NUEVA\",IF(AND(E30>=18,E30<60),1,0),IF(AND(E30>=18,E30<65),1,0))","v":1},"Titular",null,"M",29,{"$f":"IF(AND(D7=\"NUEVA\",D11<10000),\"DEDUCIBLE INVÁLIDO\",IF(D7=\"NUEVA\",IF(E30>64,\"EDAD NO PERMITIDA\",IF(D9=\"FAMILIAR\",IF(E30<18,\"EDAD NO PERMIDITA\",\"\"),\"\")),IF(D9=\"FAMILIAR\",IF(E30<18,\"EDAD NO PERMIDITA\",\"\"),\"\")))","v":""},"ANUAL",{"$f":"+IMPRESION!K91","v":67941.167324883427},0,{"$f":"+H30","v":67941.167324883427}]
[{"$f":"IF($D$7=\"NUEVA\",IF(AND(E31>=18,E31<60),1,0),IF(AND(E31>=18,E31<65),1,0))","v":0},{"$f":"IF(D9=\"FAMILIAR\",\"Cónyuge\",\"\")","v":"Cónyuge"},null,null,null,{"$f":"IF($D$7=\"NUEVA\",IF(E31>64,\"EDAD NO PERMITIDA\",\"\"),\"\")","v":""},"SEMESTRAL",{"$f":"IF((IMPRESION!K86*RSEM/2+DER)*(1+$D$26)<1000,0,(IMPRESION!K86*RSEM/2+DER)*(1+$D$26))","v":35964.188469675202},{"$f":"IF(H31=0,0,(IMPRESION!K86*RSEM/2)*(1+$D$26))","v":35152.188469675202},{"$f":"+I31+H31","v":71116.376939350404}]
[0,{"$f":"IF($D$9=\"FAMILIAR\",\"Dependiente 1\",\"\")","v":"Dependiente 1"},null,null,null,{"$f":"IF($D$7=\"NUEVA\",IF(E32>69,\"EDAD NO PERMITIDA\",\"\"),\"\")","v":""},"TRIMESTRAL",{"$f":"IF((IMPRESION!K86*RTRIM/4+DER)*(1+$D$26)<1000,0,(IMPRESION!K86*RTRIM/4+DER)*(1+$D$26))","v":18767.374030223196},{"$f":"IF(H32=0,0,(IMPRESION!K86*RTRIM/4)*(1+$D$26))","v":17955.374030223196},{"$f":"+I32*3+H32","v":72633.496120892785}]
[0,{"$f":"IF($D$9=\"FAMILIAR\",\"Dependiente 2\",\"\")","v":"Dependiente 2"},null,null,null,"","MENSUAL",{"$f":"IF((IMPRESION!K86*RMES/12+DER)*(1+$D$26)<1000,0,(IMPRESION!K86*RMES/12+DER)*(1+$D$26))","v":6964.9475950532742},{"$f":"IF(H33=0,0,(IMPRESION!K86*RMES/12)*(1+$D$26))","v":6152.9475950532742},{"$f":"+I33*11+H33","v":74647.371140639298}]
[0,{"$f":"IF($D$9=\"FAMILIAR\",\"Dependiente 3\",\"\")","v":"Dependiente 3"},null,null,null,""]
[0,{"$f":"IF($D$9=\"FAMILIAR\",\"Dependiente 4\",\"\")","v":"Dependiente 4"},null,null,null,""]
[0,{"$f":"IF($D$9=\"FAMILIAR\",\"Dependiente 5\",\"\")","v":"Dependiente 5"},null,null,null,""]
[0,{"$f":"IF($D$9=\"FAMILIAR\",\"Dependiente 6\",\"\")","v":"Dependiente 6"},null,null,null,"","RECARGOS POR PAGO FRACCIONADO"]
[]
[null,null,null,null,null,null,"SEMESTRAL",4.7300000000000002E-2,"FAVOR de Verificar si estos factores son los vigentes"]
[null,null,null,null,null,null,"TRIMESTRAL",6.9900000000000004E-2]
[null,null,null,null,null,null,"MENSUAL",9.9900000000000003E-2]
[]
[]
[null,"NOTA: LAS COTIZACIONES EN EDADES DE 65 A 79 AÑOS SOLO SON VALIDAS PARA RENOVACION\n          LA EDAD DE CONTRATACION DE LA COBERTURA DE ENFERMEDADES GRAVES ES DE 18 A 59 AÑOS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NO.","REGIÓN"]
[1,"OAXACA, TABASCO, VERACRUZ, CAMPECHE, YUCATAN, CHIAPAS, GUERRERO"]
[2,"PUEBLA, TLAXCALA, HIDALGO, NAYARIT"]
[3,"AGUASCALIENTES, GUANAJUATO, JALISCO, MICHOACAN, COLIMA,ZACATECAS"]
[4,"COAHUILA, TAMAULIPAS, NUEVO LEON, DURANGO, CHIHUAHUA"]
[5,"SAN LUIS POTOSI, BAJA CALIFORNIA NORTE, BAJA CALIFORNIA SUR, SINALOA, SONORA, QUERETARO, MORELOS, QUINTANA ROO"]
[6,"DISTRITO FEDERAL, EDO. DE MEXICO"]
[]
[null,null,"DEDUCIBLE",null,"COASEGURO",null,"FORMA DE PAGO",null,null,null,"FP"]
[null,null,3500]
[null,null,4000,null,null,null,"A",{"$f":"IF(H30=0,\"NO APLICA\",\"ANUAL\")","v":"ANUAL"},null,null,{"$f":"IF(#REF!=\"ANUAL\",1,IF(#REF!=\"SEMESTRAL\",2,IF(#REF!=\"TRIMESTRAL\",4,IF(#REF!=\"MENSUAL\",12,1))))","v":{"$error":"#REF!"}}]
[null,null,4500,null,null,null,"S",{"$f":"IF(H31=0,\"NO APLICA\",\"SEMESTRAL\")","v":"SEMESTRAL"}]
[null,null,5500,null,0.1,null,"T",{"$f":"IF(H32=0,\"NO APLICA\",\"TRIMESTRAL\")","v":"TRIMESTRAL"},null,null,"IVA"]
[null,null,6000,null,0.15,null,"M",{"$f":"IF(H33=0,\"NO APLICA\",\"MENSUAL\")","v":"MENSUAL"},null,null,0.11]
[null,null,7000,null,0.2,null,"COBERTURA EN EL EXT",null,null,null,0.16]
[null,null,8000,null,null,null,"S","SI"]
[null,null,9000,null,null,null,"N","NO"]
[null,null,10000]
[null,null,15000,null,null,null,"DEDUCIBLE CERO POR ACC"]
[null,null,20000,null,null,"Catalogo","S","SI"]
[null,null,25000,null,null,null,"N","NO"]
[null,null,30000]
[null,null,35000,null,null,null,"Tipo de Póliza"]
[null,null,40000,null,null,null,"NUEVA",0]
[null,null,45000,null,null,null,"RENOVADA",1]
[null,null,50000,null,null,null,"ANTES DEL 01/10/2016",1]
[null,null,75000,null,null,null,"A PARTIR DEL 01/10/2016",0]
[null,null,100000]
[null,null,300000]
[null,null,400000]
[null,null,500000]
[null,null,600000]
[null,null,700000]
[null,null,800000]
[null,null,900000]
[null,null,1000000]
[]
[null,null,null,null,null,0]
[null,"INC EN PARTO O CESAREA","PARTO O CESAREA","PARTO O CESAREA",null,0.15,49400,{"$f":"+Base","v":49400}]
[null,"SI",20000,20000,null,0.25]
[null,"NO",30000,30000,null,0.5]
[null,null,40000,40000,null,0.75]
[null,null,50000,{"$f":"+IF(E7=H241,\" \",50000)","v":50000},null,1]
[]
["ZONA"," EMERGENCIA EN EL EXTRANJERO"]
["A","CIUDADES A 20 KM. DE LA FRANJA FRONTERIZA CON LOS E.U.A."]
["B","BAJA CALIFORNIA, BAJA CALIFORNIA SUR, SONORA, CHIHUAHUA, COAHUILA, NUEVO LEÓN, CAMPECHE, YUCATÁN Y QUINTANA ROO"]
["C"," EL RESTO DEL PAÍS   (EXCEPTO ZONA A Y ZONA B)"]
[0]
[{"$f":"1+A266","v":1}]
[{"$f":"1+A267","v":2},null,"TITULAR","CÓNYUGE"]
[3,null,"H",{"$f":"IF((IF(C31=\"\",\" \",D30))=\"H\",\"M\",IF((IF(C31=\"\",\"\",D30))=\"M\",\"H\",IF((IF(C31=\"\",\"\",D30))=\"\",\"\")))","v":""}]
[4,null,"M"]
[5]
[6]
[7,null,"SUMA ASEGURADA",null,null,null,"ENF GVES"]
[8,null,200000,null,"TIPO DE COTIZACIÓN",null,"NO"]
[9,null,300000,null,"INDIVIDUAL",null,10000]
[10,null,400000,null,"FAMILIAR",null,20000]
[11,null,500000,null,null,null,30000]
[12,null,600000,null,null,null,40000]
[13,null,700000,null,null,null,50000]
[14,null,800000,null,null,null,75000]
[15,null,1000000,null,null,null,100000]
[16,null,2000000,null,null,null,150000]
[17,null,3000000,null,null,null,200000]
[18,null,4000000,null,null,null,250000]
[19,null,5000000,null,null,null,300000]
[20,null,6000000,null,null,null,350000]
[21,null,7000000,null,null,null,400000]
[22,null,8000000,null,null,null,450000]
[23,null,9000000,null,null,null,500000]
[24,null,10000000,null,null,null,550000]
[25,null,20000000,null,null,null,600000]
[26,null,30000000,null,null,null,650000]
[27,null,40000000,null,null,null,700000]
[28,null,50000000,null,null,null,750000]
[29,null,70000000,null,null,null,800000]
[30,null,100000000,null,null,null,850000]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49,null,"Estado","REGIÓN"]
[50,null,"AGUASCALIENTES",3,3,2,{"$f":"+F316-D316","v":-1}]
[51,null,"BAJA CALIFORNIA",2,5,3,{"$f":"+F317-D317","v":1}]
[52,null,"BAJA CALIFORNIA SUR",3,5,3,0]
[53,null,"CAMPECHE",1,1,1,0]
[54,null,"CHIAPAS",2,1,1,-1]
[55,null,"CHIHUAHUA",4,4,3,-1]
[56,null,"COAHUILA",4,3,2,-2]
[57,null,"COLIMA",3,3,2,-1]
[58,null,"CIUDAD DE MÉXICO",5,6,4,-1]
[59,null,"DURANGO",3,3,2,-1]
[60,null,"ESTADO DE MÉXICO",5,6,4,-1]
[61,null,"GUANAJUATO",2,3,2,0]
[62,null,"GUERRERO",2,1,1,-1]
[63,null,"HIDALGO",3,2,1,-2]
[64,null,"JALISCO",3,3,2,-1]
[65,null,"MICHOACÁN",3,3,2,-1]
[{"$f":"1+A331","v":66},null,"MORELOS",4,5,3,-1]
[{"$f":"1+A332","v":67},null,"NAYARIT",2,2,1,-1]
[{"$f":"1+A333","v":68},null,"NUEVO LEÓN",4,4,3,-1]
[{"$f":"1+A334","v":69},null,"OAXACA",1,1,1,0]
[{"$f":"1+A335","v":70},null,"PUEBLA",2,2,1,-1]
[71,null,"QUERÉTARO",3,5,3,0]
[72,null,"QUINTANA ROO",4,5,1,-3]
[73,null,"SAN LUIS POTOSÍ",4,5,3,-1]
[74,null,"SINALOA",3,5,3,0]
[75,null,"SONORA",4,5,3,-1]
[76,null,"TABASCO",2,1,1,-1]
[77,null,"TAMAULIPAS",4,4,3,-1]
[78,null,"TLAXCALA",1,2,1,0]
[79,null,"VERACRUZ",2,1,1,-1]
[80,null,"YUCATÁN",1,1,1,0]
[81,null,"ZACATECAS",3,3,2,-1]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[{"$f":"1+A356","v":91}]
[{"$f":"1+A357","v":92}]
[{"$f":"1+A358","v":93}]
[{"$f":"1+A359","v":94}]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"IMPRESION","index":7,"n_rows":230,"n_cols":11,"rows_kept":230,"cut":false,"hidden":true,"merged":[[104,2,105,11],[8,1,9,10],[74,2,74,10],[99,2,99,10],[102,2,103,10],[93,2,93,3],[11,1,11,10],[91,4,91,6],[75,2,76,6],[75,7,76,7],[75,8,76,8],[75,9,76,9],[94,2,94,3]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-02-08"}]
[null,{"$f":"\"Apreciable  \"&COTIZACION!C30","v":"Apreciable  "}]
[]
[null,{"$f":"+\"Agradecemos de antemano su preferencia y esperamos que la presente propuesta de Gastos Médicos \"&COTIZACION!D9&\" cumpla sus expectativas.\"","v":"Agradecemos de antemano su preferencia y esperamos que la presente propuesta de Gastos Médicos FAMILIAR cumpla sus expectativas."}]
[]
[]
[null,"CUADRO DE COBERTURAS"]
[null,"-","Tipo de Hospital",null,null,null,null,null,"Todos los hospitales"]
[]
[null,"-","Suma Asegurada",null,null,null,null,null,{"$f":"+CuadroEspecificacionesTARIFARIO!H17","v":10000000},{"$f":"IF(I15<>\"SIN LÍMITE\",\"M.N.\",\"\")","v":"M.N."}]
[]
[null,"-","Deducible por Accidente y Enfermedad",null,null,null,null,null,{"$f":"+CuadroEspecificacionesTARIFARIO!H19","v":10000},"M.N."]
[]
[null,"-","Coaseguro",null,null,null,"Enfermedad",null,{"$f":"+CuadroEspecificacionesTARIFARIO!H22","v":0.1},{"$f":"+CONCATENATE(\"Con tope de \",VLOOKUP(I19,FACTORES!C3:E6,3,FALSE)&\" M.N.\")","v":"Con tope de $35,000 M.N."}]
[null,null,null,null,null,null,"Accidente",null,0]
[]
[null,"-","Incremento al Catálogo",null,null,null,null,null,{"$f":"+TITULAR!E9","v":0}]
[null,"-",{"$f":"IF(I22=0,\"Base de Honorarios Quirúrgicos\",\"Base de Honorarios Quirúrgicos (incluye el incremento de \"&I22*100&\"% seleccionado) \")","v":"Base de Honorarios Quirúrgicos"},null,null,null,null,null,{"$f":"VLOOKUP(COTIZACION!$D$14,FACTORES!$N$8:$O$13,2,0)*FACTORES!$O$14*(1+TITULAR!$E$9)","v":52400},"M.N."]
[null,"-","Honorarios por visita intrahospitalaria",null,null,null,null,null,"Catálogo"]
[null,"-","Honorarios por consulta",null,null,null,null,null,"Catálogo"]
[null,"-","Honorarios por enfermera máximo 3 turnos por día durante 30 días",null,null,null,null,null,"Catálogo"]
[null,"-","Habitación Hospital",null,null,null,null,null,"Privado Estándar"]
[null,"-","Sala de operación y recuperación, medicamentos, consumo de oxígeno,"]
[null,null,"servicios de terapia, tratamiento de diálisis y transfusiones de sangre",null,null,null,null,null,"Incluido"]
[null,"-","Renta de aparatos ortopédicos y prótesis",null,null,null,null,null,"Incluido"]
[null,"-","Ambulancia Aérea",null,null,null,null,null,"Incluida"]
[null,"-","Ambulancia Terrestre",null,null,null,null,null,"Incluida"]
[null,"-","Reinstalación automática de Suma Asegurada",null,null,null,null,null,"Incluida"]
[null,"-","Gastos por donación de órganos",null,null,null,null,null,{"$f":"IF(I17<0,\"Excluido\",100000)","v":100000},{"$f":"IF(I34=\"Excluido\",\"\",\"M.N\")","v":"M.N"}]
[null,"-","Renta diaria por hospitalización en un Centro de Asistencia Social máximo 30 días",null,null,null,null,null,{"$f":"IF(I17<0,\"Excluido\",300)","v":300},{"$f":"IF(I35=\"Excluido\",\"\",\"M.N\")","v":"M.N"}]
[null,"-","Gastos por Parto o Cesárea del Titular, Cónyuge o hija asegurada con periodo de"]
[null,null,"espera de 10 meses sin deducible, ni coaseguro",null,null,null,null,null,{"$f":"IF(COTIZACION!E17=\"SUMA ASEGURADA NO PERMITIDA PARA PÓLIZAS NUEVAS\",\"EXCLUIDO \",IF(I17>50000,\"Excluido\",IF(COTIZACION!D16=\"NO\",\"$20,000\",COTIZACION!D17)))","v":40000},{"$f":"IF(I37=\"Excluido\",\"\",\"M.N\")","v":"M.N"}]
[null,"-","Complicaciones del Embarazo y del Parto del Titular, Cónyuge o hija asegurada, "]
[null,null,"con periodo  de espera de 10 meses, con deducible y coaseguro",null,null,null,null,null,"Catálogo"]
[null,"-","Prematurez siempre que el nacimiento ocurra después de 10 meses de",null,null,null,null,null,"Suma Asegurada "]
[null,null,"alta de la madre",null,null,null,null,null,"Básica",{"$f":"IF(I41=\"Excluido\",\"\",\"Por Evento\")","v":"Por Evento"}]
[null,"-","Preexistencia Declarada, con periodo de espera de 2 años, no aplica reconocimiento",null,null,null,null,null,"Incluida"]
[null,null,"de antigüedad"]
[null,"-","Circuncisión, con periodo de espera de 1 año, no aplica reconocimiento de antigüedad",null,null,null,null,null,"Incluida"]
[null,"-","Padecimientos congénitos para nacidos dentro de la vigencia, dados de alta dentro"]
[null,null,"de los 30 días posteriores al nacimiento y que la madre asegurada cumpla con el"]
[null,null,"periodo de espera de 10 meses. Para los nacidos fuera de vigencia aplica periodo de"]
[null,null,"espera de 12 meses.",null,null,null,null,null,"Incluido"]
[null,"-","Legrado",null,null,null,null,null,{"$f":"IF(I17<0,\"Excluido\",10000)","v":10000},{"$f":"IF(I49=\"Excluido\",\"\",\"M.N\")","v":"M.N"}]
[null,"-","SIDA, siempre que el asegurado se encuentre cubierto en Seguros Banorte al"]
[null,null,"menos 4 años ininterrumpidos",null,null,null,null,null,"Incluido"]
[null,"-","Terapia Psicológica o Psiquiátrica",null,null,null,null,null,"Incluido"]
[null,"-","Xifósis, lordósis y escoleosis, con periodo de espera de 2 años"]
[null,null,"no aplica reconocimiento de antigüedad",null,null,null,null,null,"Incluido"]
[null,"-","Reconocimiento de Antigüedad, previa comprobación",null,null,null,null,null,"Incluido"]
[null,"-","Incremento de Catálogo de Honorarios para enfermedades catastróficas",null,null,null,null,null,"Incluida"]
[null,"-","Trastornos Visuales, con periodo de espera de 18 meses",null,null,null,null,null,{"$f":"IF(I17<0,\"Excluido\",12000)","v":12000},{"$f":"IF(I57=\"Excluido\",\"\",\"M.N\")","v":"M.N"}]
[null,"-","Lente intraocular, con periodo de espera de 12 meses",null,null,null,null,null,{"$f":"IF(I17<0,\"Excluido\",3000)","v":3000},{"$f":"IF(I58=\"Excluido\",\"\",\"M.N\")","v":"M.N"}]
[null,"-","Cobertura Sin Límite de Edad (de acuerdo a la cláusula de edad)",null,null,null,null,null,"Incluido"]
[null,"-","Cobertura Integral Dental y Visión",null,null,null,null,null,"Incluido"]
[null,"-","Servicios de Asistencia",null,null,null,null,null,"Incluido"]
[]
[null,"-","Emergencia Extranjero con suma asegurada de 50,000 Dlls, deducible de 50 Dlls y coaseguro 0%",null,null,null,null,null,{"$f":"IF(COTIZACION!D21=\"si\",\"Incluido\",\"Excluido\")","v":"Incluido"}]
[null,"-","Cobertura Total en el Extranjero",null,null,null,null,null,{"$f":"IF(COTIZACION!D20=\"si\",\"Incluido\",\"Excluido\")","v":"Incluido"}]
[null,"-","Cobertura de Eliminación de Deducible por Accidente",null,null,null,null,null,{"$f":"IF(AND(COTIZACION!D15=\"si\",COTIZACION!D11<=50000),\"Incluido\",\"Excluido\")","v":"Incluido"}]
[null,"-","Cobertura de Indemnización por Enfermedad Grave",null,null,null,null,null,{"$f":"IF(OR(COTIZACION!D19=\"NO\",SUM(COTIZACION!A30:A37)<=0),\"Excluido\",COTIZACION!D19)","v":10000},{"$f":"IF(I66=\"EXCLUIDO\",\"\",\"M.N.\")","v":"M.N."}]
[null,"-","Cobertura de Visión Incremental",null,null,null,null,null,{"$f":"IF(COTIZACION!D18=\"SI\",\"Incluido\",\"Excluido\")","v":"Incluido"}]
[]
[null,"Se cobrará doble deducible y coaseguro de póliza, a los Asegurados que se atiendan en Hospiten México S.A de C.V"]
[null,"Se puede otorgar pago directo en la atención con médicos y hospitales en convenio, teniendo una disminución de $1,500 en el deducible y 5 puntos "]
[null,"porcentuales de coaseguro, siempre que la atención sea dentro de la misma zona de tarifa contratada o una zona menor (este beneficio no aplica  "]
[null,"para los siguientes hospitales: ABC Observatorio,  ABC Santa Fe, Ángeles del Pedregal, Ángeles Lomas, Ángeles Acoxpa,"]
[null,"Star Médica Lomas Verdes y Médica Sur, para estos hospitales aplica pago directo con deducible y coaseguro contratado)."]
[]
[null,null,"PARTICIPANTES"]
[null,null,"Nombre",null,null,null,null,"Edad","Sexo","Parentesco","Prima Neta"]
[null,null,null,null,null,null,null,null,null,null,"Anual"]
[{"$f":"IF(AND(H78<>\"\",H78>64),1,0)","v":0},null,{"$f":"IF(COTIZACION!C30=\"\",\"\",COTIZACION!C30)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!E30=\"\",\"\",COTIZACION!E30)","v":29},{"$f":"IF(COTIZACION!D30=\"\",\"\",COTIZACION!D30)","v":"M"},{"$f":"IF(COTIZACION!C30=\"\",\"\",COTIZACION!B30)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F30=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H78=\"\",\"\",IF(I78=\"H\",VLOOKUP(H78,TITULAR!$B$21:$G$106,5,0),VLOOKUP(H78,TITULAR!$B$21:$G$106,6,0)))))))","v":57869.971831796058}]
[{"$f":"IF(AND(H79<>\"\",H79>64),1,0)","v":0},null,{"$f":"IF(COTIZACION!C31=\"\",\"\",COTIZACION!C31)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E31=\"\",\"\",COTIZACION!E31))","v":""},{"$f":"IF(COTIZACION!D31=\"\",\"\",COTIZACION!D31)","v":""},{"$f":"IF(COTIZACION!C31=\"\",\"\",COTIZACION!B31)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F31=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H79=\"\",\"\",IF(I79=\"H\",VLOOKUP(H79,CONYUGE!$B$21:$G$106,5,0),IF(I79=\"M\",VLOOKUP(H79,CONYUGE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[0,null,{"$f":"IF(COTIZACION!C32=\"\",\"\",COTIZACION!C32)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E32=\"\",\"\",COTIZACION!E32))","v":""},{"$f":"IF(COTIZACION!D32=\"\",\"\",COTIZACION!D32)","v":""},{"$f":"IF(COTIZACION!C32=\"\",\"\",COTIZACION!B32)","v":""},{"$f":"IF(COTIZACION!$E$7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!$F$30<>\"\",\"\",IF(COTIZACION!F32=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H80=\"\",\"\",IF(I80=\"H\",VLOOKUP(H80,DEPENDIENTE!$B$21:$G$106,5,0),IF(I80=\"M\",VLOOKUP(H80,DEPENDIENTE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[0,null,{"$f":"IF(COTIZACION!C33=\"\",\"\",COTIZACION!C33)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E33=\"\",\"\",COTIZACION!E33))","v":""},{"$f":"IF(COTIZACION!D33=\"\",\"\",COTIZACION!D33)","v":""},{"$f":"IF(COTIZACION!C33=\"\",\"\",COTIZACION!B33)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F33=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H81=\"\",\"\",IF(I81=\"H\",VLOOKUP(H81,DEPENDIENTE!$B$21:$G$106,5,0),IF(I81=\"M\",VLOOKUP(H81,DEPENDIENTE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[0,null,{"$f":"IF(COTIZACION!C34=\"\",\"\",COTIZACION!C34)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E34=\"\",\"\",COTIZACION!E34))","v":""},{"$f":"IF(COTIZACION!D34=\"\",\"\",COTIZACION!D34)","v":""},{"$f":"IF(COTIZACION!C34=\"\",\"\",COTIZACION!B34)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F34=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H82=\"\",\"\",IF(I82=\"H\",VLOOKUP(H82,DEPENDIENTE!$B$21:$G$106,5,0),IF(I82=\"M\",VLOOKUP(H82,DEPENDIENTE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[0,null,{"$f":"IF(COTIZACION!C35=\"\",\"\",COTIZACION!C35)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E35=\"\",\"\",COTIZACION!E35))","v":""},{"$f":"IF(COTIZACION!D35=\"\",\"\",COTIZACION!D35)","v":""},{"$f":"IF(COTIZACION!C35=\"\",\"\",COTIZACION!B35)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F35=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H83=\"\",\"\",IF(I83=\"H\",VLOOKUP(H83,DEPENDIENTE!$B$21:$G$106,5,0),IF(I83=\"M\",VLOOKUP(H83,DEPENDIENTE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[0,null,{"$f":"IF(COTIZACION!C36=\"\",\"\",COTIZACION!C36)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E36=\"\",\"\",COTIZACION!E36))","v":""},{"$f":"IF(COTIZACION!D36=\"\",\"\",COTIZACION!D36)","v":""},{"$f":"IF(COTIZACION!C36=\"\",\"\",COTIZACION!B36)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F36=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H84=\"\",\"\",IF(I84=\"H\",VLOOKUP(H84,DEPENDIENTE!$B$21:$G$106,5,0),IF(I84=\"M\",VLOOKUP(H84,DEPENDIENTE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[0,null,{"$f":"IF(COTIZACION!C37=\"\",\"\",COTIZACION!C37)","v":""},null,null,null,null,{"$f":"+IF(COTIZACION!D9=\"INDIVIDUAL\",\"\",IF(COTIZACION!E37=\"\",\"\",COTIZACION!E37))","v":""},{"$f":"IF(COTIZACION!D37=\"\",\"\",COTIZACION!D37)","v":""},{"$f":"IF(COTIZACION!C37=\"\",\"\",COTIZACION!B37)","v":""},{"$f":"IF(COTIZACION!E7=\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",\"\",IF(COTIZACION!F30<>\"\",\"\",IF(COTIZACION!F37=\"EDAD NO PERMITIDA\",\"EDAD NO PERMITIDA\",IF($I$37=\"EXCLUIDO \",0,IF(H85=\"\",\"\",IF(I85=\"H\",VLOOKUP(H85,DEPENDIENTE!$B$21:$G$106,5,0),IF(I85=\"M\",VLOOKUP(H85,DEPENDIENTE!$B$21:$G$106,6,0),\"\")))))))","v":""}]
[null,null,null,null,null,null,null,null,"Prima Total Anual",null,{"$f":"IF(COTIZACION!D7=\"NUEVA\",IF(IMPRESION!A105=0,SUM(K78:K85),0),SUM(K78:K85))","v":57869.971831796058}]
[null,null,null,null,null,null,null,null,"Recargo por Pago Fracc.",null,{"$f":"+TITULAR!G17","v":0}]
[null,null,null,null,null,null,null,null,"Derecho de Póliza",null,{"$f":"IF(K86=0,0,IF(I37=\"EXCLUIDO \",0,+TITULAR!I25))","v":700}]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"+K86+K88","v":58569.971831796058}]
[null,null,null,null,{"$f":"COTIZACION!D13","v":"CIUDAD DE MÉXICO"},null,null,null,"I.V.A.",null,{"$f":"+K89*TITULAR!K25","v":9371.195493087369}]
[null,null,null,null,null,null,null,null,"Prima Total Anual",null,{"$f":"SUM(K89:K90)","v":67941.167324883427}]
[null,null,null,null,{"$f":"IF(COTIZACION!C42=\"\",\"\",COTIZACION!C42)","v":""}]
[]
[]
[null,null,{"$f":"+COTIZACION!G30","v":"ANUAL"},null,{"$f":"IF(COTIZACION!F30<>\"\",0,IF(K86=0,0,IF(I37=\"EXCLUIDO \",0,(K86/(1+K87)+DER)*(1+COTIZACION!$D$26))))","v":67941.167324883427},0,{"$f":"+F95+E95","v":67941.167324883427}]
[null,null,{"$f":"\"SEMESTRAL    (Recargo \"&COTIZACION!H39*100&\"%)\"","v":"SEMESTRAL    (Recargo 4.73%)"},null,{"$f":"+COTIZACION!H31","v":35964.188469675202},{"$f":"+COTIZACION!I31","v":35152.188469675202},{"$f":"+F96+E96","v":71116.376939350404}]
[null,null,{"$f":"\"TRIMESTRAL  (Recargo \"&COTIZACION!H40*100&\"%)\"","v":"TRIMESTRAL  (Recargo 6.99%)"},null,{"$f":"+COTIZACION!H32","v":18767.374030223196},{"$f":"+COTIZACION!I32","v":17955.374030223196},{"$f":"+F97*3+E97","v":72633.496120892785}]
[null,null,{"$f":"\"MENSUAL        (Recargo \"&COTIZACION!H41*100&\"%)\"","v":"MENSUAL        (Recargo 9.99%)"},null,{"$f":"+COTIZACION!H33","v":6964.9475950532742},{"$f":"+COTIZACION!I33","v":6152.9475950532742},{"$f":"+F98*11+E98","v":74647.371140639298}]
[]
[null,null,"Notas:"]
[null,null,"*Este producto cuenta con exclusiones y limitaciones, las cuales pueden ser consultadas en las Condiciones Generales del producto en la página"]
[null,null,"   www.segurosbanorte.com.mx"]
[null,null,"* Esta cotización tiene una validez de 15 días a partir de su fecha de elaboración. La edad limite de aceptación es hasta los 64 años.\n* El recargo por pago fraccionado está sujeto a cambio sin previo aviso."]
[]
[{"$f":"SUM(A78:A85)","v":0},null,{"$f":"+CONCATENATE(\"EN SEGUROS BANORTE ESTA COTIZACIÓN \",COTIZACION!E7)","v":"EN SEGUROS BANORTE ESTA COTIZACIÓN APLICA PARA AQUELLA PÓLIZA NUEVA CON PRIMER VIGENCIA EMITIDA A PARTIR DEL 01/10/2016"}]
[]
[null,"Tarifa Total Vig: Marzo 01, 2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FP"]
[{"$f":"IF(#REF!=\"ANUAL\",1,IF(#REF!=\"SEMESTRAL\",2,IF(#REF!=\"TRIMESTRAL\",4,IF(#REF!=\"MENSUAL\",12,1))))","v":{"$error":"#REF!"}}]
[]
["IVA"]
[0.1]
[0.15]

{"sheet":"TARIFARIO","index":8,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":true,"merged":[[10,7,11,9],[92,1,92,11],[18,10,19,11],[18,6,19,7],[18,2,19,3],[74,2,75,3]]}
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+COTIZACION!D7","v":"NUEVA"},null,null,null,null,null,null,"REGION",{"$f":"+COTIZACION!D14","v":5}]
[]
[null,null,"COBERTURAS OPCIONALES"]
[null,null,"Suma Asegurada para Parto y Cesárea",null,null,{"$f":"IF(COTIZACION!D11>50000,\"No incluido\",IF(COTIZACION!D16=\"si\",COTIZACION!D17,\"$20,000 Cobertura Básica\"))","v":40000},null,"Cobertura Total en el Extranjero",null,null,{"$f":"IF(COTIZACION!D20=\"SI\",\"Incluido\"&\" con Zona \"&COTIZACION!D22,\"No Incluido\")","v":"Incluido con Zona B"}]
[null,null,"Eliminación de Deducible por Accidente",null,null,{"$f":"IF(COTIZACION!D11>50000,\"No incluido\",IF(COTIZACION!D15=\"SI\",\"Incluido\",\"No Incluido\"))","v":"Incluido"},null,"Cobertura de Indemnización por Enfermedad Grave",null,null,{"$f":"IF(AND(COTIZACION!D19<>\"NO\",COTIZACION!E19=\"\"),COTIZACION!D19,\"No Incluido\")","v":10000}]
[null,null,"Emergencia en el Extranjero",null,null,{"$f":"IF(COTIZACION!D21=\"SI\",\"Incluido\",\"No Incluido\")","v":"Incluido"}]
[]
[]
[null,"SUMA ASEGURADA:",null,{"$f":"TITULAR!E5","v":10000000},null,"SUMA ASEGURADA:",null,{"$f":"CONYUGE!E5","v":10000000},null,"SUMA ASEGURADA:",null,{"$f":"DEPENDIENTE!E5","v":10000000}]
[null,"DEDUCIBLE:",null,{"$f":"TITULAR!E6","v":10000},null,"DEDUCIBLE:",null,{"$f":"CONYUGE!E6","v":10000},null,"DEDUCIBLE:",null,{"$f":"DEPENDIENTE!E6","v":10000}]
[null,"COASEGURO:",null,{"$f":"TITULAR!E8","v":0.1},null,"COASEGURO:",null,{"$f":"CONYUGE!E7","v":0.1},null,"COASEGURO:",null,{"$f":"DEPENDIENTE!E7","v":0.1}]
[]
[null,null,null,null,null,null,"PRIMA TOTAL CONYUGE"]
[]
[null,"EDAD","HOMBRE","MUJER",null,"EDAD","HOMBRE","MUJER",null,"EDAD","HOMBRE","MUJER"]
[null,"18",{"$f":"+TITULAR!J45","v":25758.357533249637},{"$f":"+TITULAR!K45","v":43741.514124883419},null,"18",{"$f":"+CONYUGE!J39","v":23910.134052337286},{"$f":"+CONYUGE!K39","v":41893.290643971064},null,"0 - 5",{"$f":"+DEPENDIENTE!J26","v":24447.167652337288},{"$f":"+DEPENDIENTE!K26","v":24461.238452337286}]
[null,{"$f":"+B22+1","v":19},{"$f":"+TITULAR!J46","v":26508.738333249639},{"$f":"+TITULAR!K46","v":44038.67132488342},null,{"$f":"+F22+1","v":19},{"$f":"+CONYUGE!J40","v":24660.514852337288},{"$f":"+CONYUGE!K40","v":42190.447843971066},null,6,{"$f":"+DEPENDIENTE!J27","v":24447.167652337288},{"$f":"+DEPENDIENTE!K27","v":24461.238452337286}]
[null,{"$f":"+B23+1","v":20},{"$f":"+TITULAR!J47","v":27202.197933249641},{"$f":"+TITULAR!K47","v":47293.56172488341},null,{"$f":"+F23+1","v":20},{"$f":"+CONYUGE!J41","v":25353.97445233729},{"$f":"+CONYUGE!K41","v":45445.338243971062},null,{"$f":"+J23+1","v":7},{"$f":"+DEPENDIENTE!J28","v":24447.167652337288},{"$f":"+DEPENDIENTE!K28","v":24461.238452337286}]
[null,21,{"$f":"+TITULAR!J48","v":28441.193933249637},{"$f":"+TITULAR!K48","v":54279.510924883412},null,21,{"$f":"+CONYUGE!J42","v":26592.970452337286},{"$f":"+CONYUGE!K42","v":52431.287443971058},null,{"$f":"+J24+1","v":8},{"$f":"+DEPENDIENTE!J29","v":24447.167652337288},{"$f":"+DEPENDIENTE!K29","v":24461.238452337286}]
[null,22,{"$f":"+TITULAR!J49","v":29552.937933249639},{"$f":"+TITULAR!K49","v":55754.961324883414},null,22,{"$f":"+CONYUGE!J43","v":27704.714452337288},{"$f":"+CONYUGE!K43","v":53906.737843971059},null,9,{"$f":"+DEPENDIENTE!J30","v":24447.167652337288},{"$f":"+DEPENDIENTE!K30","v":24461.238452337286}]
[null,23,{"$f":"+TITULAR!J50","v":31262.696733249639},{"$f":"+TITULAR!K50","v":57286.86892488342},null,23,{"$f":"+CONYUGE!J44","v":29414.473252337288},{"$f":"+CONYUGE!K44","v":55438.645443971065},null,10,{"$f":"+DEPENDIENTE!J31","v":24447.167652337288},{"$f":"+DEPENDIENTE!K31","v":24461.238452337286}]
[null,24,{"$f":"+TITULAR!J51","v":32410.806733249639},{"$f":"+TITULAR!K51","v":58884.420924883416},null,24,{"$f":"+CONYUGE!J45","v":30562.583252337288},{"$f":"+CONYUGE!K45","v":57036.197443971061},null,11,{"$f":"+DEPENDIENTE!J32","v":24319.428452337288},{"$f":"+DEPENDIENTE!K32","v":24114.94365233729}]
[null,25,{"$f":"+TITULAR!J52","v":33546.643933249637},{"$f":"+TITULAR!K52","v":60532.235724883409},null,25,{"$f":"+CONYUGE!J46","v":31698.420452337286},{"$f":"+CONYUGE!K46","v":58684.012243971054},null,12,{"$f":"+DEPENDIENTE!J33","v":24215.64325233729},{"$f":"+DEPENDIENTE!K33","v":24419.90765233729}]
[null,26,{"$f":"+TITULAR!J53","v":35575.982733249635},{"$f":"+TITULAR!K53","v":62294.658524883416},null,26,{"$f":"+CONYUGE!J47","v":33727.759252337288},{"$f":"+CONYUGE!K47","v":60446.435043971062},null,13,{"$f":"+DEPENDIENTE!J34","v":24060.94565233729},{"$f":"+DEPENDIENTE!K34","v":24271.137652337289}]
[null,27,{"$f":"+TITULAR!J54","v":36982.099933249636},{"$f":"+TITULAR!K54","v":64075.467324883422},null,27,{"$f":"+CONYUGE!J48","v":35133.876452337288},{"$f":"+CONYUGE!K48","v":62227.243843971068},null,14,{"$f":"+DEPENDIENTE!J35","v":23483.091652337287},{"$f":"+DEPENDIENTE!K35","v":23813.703252337291}]
[null,28,{"$f":"+TITULAR!J55","v":38960.363933249639},{"$f":"+TITULAR!K55","v":65991.590124883427},null,28,{"$f":"+CONYUGE!J49","v":37112.140452337284},{"$f":"+CONYUGE!K49","v":64143.366643971072},null,15,{"$f":"+DEPENDIENTE!J36","v":23571.390852337285},{"$f":"+DEPENDIENTE!K36","v":23456.516052337287}]
[null,29,{"$f":"+TITULAR!J56","v":40797.397933249638},{"$f":"+TITULAR!K56","v":67941.167324883427},null,29,{"$f":"+CONYUGE!J50","v":38949.174452337284},{"$f":"+CONYUGE!K50","v":66092.943843971065},null,16,{"$f":"+DEPENDIENTE!J37","v":23164.346852337287},{"$f":"+DEPENDIENTE!K37","v":22635.444852337288}]
[null,30,{"$f":"+TITULAR!J57","v":42521.15793324964},{"$f":"+TITULAR!K57","v":70038.250124883431},null,30,{"$f":"+CONYUGE!J51","v":40672.934452337286},{"$f":"+CONYUGE!K51","v":68190.026643971069},null,17,{"$f":"+DEPENDIENTE!J38","v":23281.878052337288},{"$f":"+DEPENDIENTE!K38","v":22965.499652337287}]
[null,31,{"$f":"+TITULAR!J58","v":44135.587933249641},{"$f":"+TITULAR!K58","v":72202.554924883429},null,31,{"$f":"+CONYUGE!J52","v":42287.364452337286},{"$f":"+CONYUGE!K52","v":70354.331443971067},null,18,{"$f":"+DEPENDIENTE!J39","v":23910.134052337286},{"$f":"+DEPENDIENTE!K39","v":41893.290643971064}]
[null,32,{"$f":"+TITULAR!J59","v":46619.426333249634},{"$f":"+TITULAR!K59","v":74434.51092488342},null,32,{"$f":"+CONYUGE!J53","v":44771.202852337279},{"$f":"+CONYUGE!K53","v":72586.287443971058},null,19,{"$f":"+DEPENDIENTE!J40","v":24660.514852337288},{"$f":"+DEPENDIENTE!K40","v":42190.447843971066}]
[null,33,{"$f":"+TITULAR!J60","v":48174.986333249639},{"$f":"+TITULAR!K60","v":76285.325724883398},null,33,{"$f":"+CONYUGE!J54","v":46326.762852337284},{"$f":"+CONYUGE!K54","v":74437.10224397105},null,20,{"$f":"+DEPENDIENTE!J41","v":25353.97445233729},{"$f":"+DEPENDIENTE!K41","v":45445.338243971062}]
[null,34,{"$f":"+TITULAR!J61","v":50717.103133249642},{"$f":"+TITULAR!K61","v":78715.838924883428},null,34,{"$f":"+CONYUGE!J55","v":48868.879652337288},{"$f":"+CONYUGE!K55","v":76867.615443971066},null,21,{"$f":"+DEPENDIENTE!J42","v":26592.970452337286},{"$f":"+DEPENDIENTE!K42","v":52431.287443971058}]
[null,35,{"$f":"+TITULAR!J62","v":53362.181533249634},{"$f":"+TITULAR!K62","v":81272.177324883436},null,35,{"$f":"+CONYUGE!J56","v":51513.958052337279},{"$f":"+CONYUGE!K56","v":79423.953843971074},null,22,{"$f":"+DEPENDIENTE!J43","v":27704.714452337288},{"$f":"+DEPENDIENTE!K43","v":53906.737843971059}]
[null,36,{"$f":"+TITULAR!J63","v":55527.91313324964},{"$f":"+TITULAR!K63","v":83914.66892488343},null,36,{"$f":"+CONYUGE!J57","v":53679.689652337285},{"$f":"+CONYUGE!K57","v":82066.445443971068},null,23,{"$f":"+DEPENDIENTE!J44","v":29414.473252337288},{"$f":"+DEPENDIENTE!K44","v":55438.645443971065}]
[null,37,{"$f":"+TITULAR!J64","v":58379.111933249638},{"$f":"+TITULAR!K64","v":86765.658924883421},null,37,{"$f":"+CONYUGE!J58","v":56530.888452337284},{"$f":"+CONYUGE!K58","v":84917.435443971073},null,24,{"$f":"+DEPENDIENTE!J45","v":30562.583252337288},{"$f":"+DEPENDIENTE!K45","v":57036.197443971061}]
[null,38,{"$f":"+TITULAR!J65","v":61389.509133249638},{"$f":"+TITULAR!K65","v":89628.852124883429},null,38,{"$f":"+CONYUGE!J59","v":59541.285652337283},{"$f":"+CONYUGE!K59","v":87780.628643971068}]
[null,39,{"$f":"+TITULAR!J66","v":64608.393133249636},{"$f":"+TITULAR!K66","v":92655.651724883428},null,39,{"$f":"+CONYUGE!J60","v":62760.169652337281},{"$f":"+CONYUGE!K60","v":90807.428243971066}]
[null,40,{"$f":"+TITULAR!J67","v":66771.27113324964},{"$f":"+TITULAR!K67","v":95802.766524883424},null,40,{"$f":"+CONYUGE!J61","v":64923.047652337278},{"$f":"+CONYUGE!K61","v":93954.543043971062}]
[null,41,{"$f":"+TITULAR!J68","v":69141.301933249633},{"$f":"+TITULAR!K68","v":99105.889724883411},null,41,{"$f":"+CONYUGE!J62","v":67293.078452337286},{"$f":"+CONYUGE!K62","v":97257.666243971049}]
[null,42,{"$f":"+TITULAR!J69","v":71726.385133249642},{"$f":"+TITULAR!K69","v":102551.58852488341},null,42,{"$f":"+CONYUGE!J63","v":69878.16165233728},{"$f":"+CONYUGE!K63","v":100703.36504397105}]
[null,43,{"$f":"+TITULAR!J70","v":74523.620733249641},{"$f":"+TITULAR!K70","v":106144.73492488341},null,43,{"$f":"+CONYUGE!J64","v":72675.397252337279},{"$f":"+CONYUGE!K64","v":104296.51144397106}]
[null,44,{"$f":"+TITULAR!J71","v":77617.387133249635},{"$f":"+TITULAR!K71","v":110291.5841248834},null,44,{"$f":"+CONYUGE!J65","v":75769.163652337273},{"$f":"+CONYUGE!K65","v":108443.36064397106}]
[null,45,{"$f":"+TITULAR!J72","v":80982.442733249627},{"$f":"+TITULAR!K72","v":114388.42572488342},null,45,{"$f":"+CONYUGE!J66","v":79134.219252337265},{"$f":"+CONYUGE!K66","v":112540.20224397106}]
[null,46,{"$f":"+TITULAR!J73","v":84700.474733249619},{"$f":"+TITULAR!K73","v":117890.6165248834},null,46,{"$f":"+CONYUGE!J67","v":82852.251252337272},{"$f":"+CONYUGE!K67","v":116042.39304397105}]
[null,47,{"$f":"+TITULAR!J74","v":88760.358733249639},{"$f":"+TITULAR!K74","v":122730.41492488341},null,47,{"$f":"+CONYUGE!J68","v":86912.135252337277},{"$f":"+CONYUGE!K68","v":120882.19144397105}]
[null,48,{"$f":"+TITULAR!J75","v":93211.46433324962},{"$f":"+TITULAR!K75","v":126781.2161248834},null,48,{"$f":"+CONYUGE!J69","v":91363.240852337258},{"$f":"+CONYUGE!K69","v":124932.99264397104}]
[null,49,{"$f":"+TITULAR!J76","v":98083.603533249625},{"$f":"+TITULAR!K76","v":131154.7641248834},null,49,{"$f":"+CONYUGE!J70","v":96235.380052337277},{"$f":"+CONYUGE!K70","v":129306.54064397105}]
[null,50,{"$f":"+TITULAR!J77","v":103394.41993324962},{"$f":"+TITULAR!K77","v":135779.95092488339},null,50,{"$f":"+CONYUGE!J71","v":101546.19645233727},{"$f":"+CONYUGE!K71","v":133931.72744397103}]
[null,51,{"$f":"+TITULAR!J78","v":109111.54953324962},{"$f":"+TITULAR!K78","v":140767.67252488341},null,51,{"$f":"+CONYUGE!J72","v":107263.32605233726},{"$f":"+CONYUGE!K72","v":138919.44904397105}]
[null,52,{"$f":"+TITULAR!J79","v":115346.66553324963},{"$f":"+TITULAR!K79","v":146110.28452488341},null,52,{"$f":"+CONYUGE!J73","v":113498.44205233727},{"$f":"+CONYUGE!K73","v":144262.06104397104}]
[null,53,{"$f":"+TITULAR!J80","v":122161.64233324962},{"$f":"+TITULAR!K80","v":151841.1601248834},null,53,{"$f":"+CONYUGE!J74","v":120313.41885233727},{"$f":"+CONYUGE!K74","v":149992.93664397104}]
[null,54,{"$f":"+TITULAR!J81","v":129538.16353324962},{"$f":"+TITULAR!K81","v":157935.31292488339},null,54,{"$f":"+CONYUGE!J75","v":127689.94005233728},{"$f":"+CONYUGE!K75","v":156087.08944397102}]
[null,55,{"$f":"+TITULAR!J82","v":137398.96153324962},{"$f":"+TITULAR!K82","v":144189.39273324961},null,55,{"$f":"+CONYUGE!J76","v":135550.73805233726},{"$f":"+CONYUGE!K76","v":142341.16925233728}]
[null,56,{"$f":"+TITULAR!J83","v":145967.47553324961},{"$f":"+TITULAR!K83","v":152756.29433324962},null,56,{"$f":"+CONYUGE!J77","v":144119.25205233728},{"$f":"+CONYUGE!K77","v":150908.07085233726}]
[null,57,{"$f":"+TITULAR!J84","v":155160.77713324962},{"$f":"+TITULAR!K84","v":158567.88273324963},null,57,{"$f":"+CONYUGE!J78","v":153312.55365233726},{"$f":"+CONYUGE!K78","v":156719.65925233727}]
[null,58,{"$f":"+TITULAR!J85","v":161753.63713324961},{"$f":"+TITULAR!K85","v":164836.51113324962},null,58,{"$f":"+CONYUGE!J79","v":159905.41365233727},{"$f":"+CONYUGE!K79","v":162988.28765233725}]
[null,59,{"$f":"+TITULAR!J86","v":172119.94233324961},{"$f":"+TITULAR!K86","v":167618.75953324963},null,59,{"$f":"+CONYUGE!J80","v":170271.71885233728},{"$f":"+CONYUGE!K80","v":165770.53605233727}]
[null,60,{"$f":"+TITULAR!J87","v":228605.16793324961},{"$f":"+TITULAR!K87","v":226994.98353324961},null,60,{"$f":"+CONYUGE!J81","v":226756.94445233725},{"$f":"+CONYUGE!K81","v":225146.76005233725}]
[null,61,{"$f":"+TITULAR!J88","v":241039.39353324962},{"$f":"+TITULAR!K88","v":236797.05313324963},null,61,{"$f":"+CONYUGE!J82","v":239191.17005233726},{"$f":"+CONYUGE!K82","v":234948.82965233727}]
[null,62,{"$f":"+TITULAR!J89","v":253700.3411332496},{"$f":"+TITULAR!K89","v":246883.22993324962},null,62,{"$f":"+CONYUGE!J83","v":251852.11765233724},{"$f":"+CONYUGE!K83","v":245035.00645233729}]
[null,63,{"$f":"+TITULAR!J90","v":267607.18673324963},{"$f":"+TITULAR!K90","v":257490.9079332496},null,63,{"$f":"+CONYUGE!J84","v":265758.96325233724},{"$f":"+CONYUGE!K84","v":255642.68445233727}]
[null,64,{"$f":"+TITULAR!J91","v":281627.31793324964},{"$f":"+TITULAR!K91","v":268766.42113324959},null,64,{"$f":"+CONYUGE!J85","v":279779.09445233725},{"$f":"+CONYUGE!K85","v":266918.19765233726}]
[]
[]
[null,"SUMA ASEGURADA:",null,{"$f":"+D15","v":10000000}]
[null,"DEDUCIBLE:",null,{"$f":"+D16","v":10000}]
[null,"COASEGURO:",null,{"$f":"+D17","v":0.1}]
[]
[]
[]
[null,"EDAD","HOMBRE","MUJER"]
[null,"0 - 5",{"$f":"+TITULAR!J32","v":26295.391133249639},{"$f":"+TITULAR!K32","v":26309.461933249637}]
[null,6,{"$f":"+TITULAR!J33","v":26295.391133249639},{"$f":"+TITULAR!K33","v":26309.461933249637}]
[null,{"$f":"+B79+1","v":7},{"$f":"+TITULAR!J34","v":26295.391133249639},{"$f":"+TITULAR!K34","v":26309.461933249637}]
[null,{"$f":"+B80+1","v":8},{"$f":"+TITULAR!J35","v":26295.391133249639},{"$f":"+TITULAR!K35","v":26309.461933249637}]
[null,9,{"$f":"+TITULAR!J36","v":26295.391133249639},{"$f":"+TITULAR!K36","v":26309.461933249637}]
[null,10,{"$f":"+TITULAR!J37","v":26295.391133249639},{"$f":"+TITULAR!K37","v":26309.461933249637}]
[null,11,{"$f":"+TITULAR!J38","v":26167.651933249635},{"$f":"+TITULAR!K38","v":25963.167133249637}]
[null,12,{"$f":"+TITULAR!J39","v":26063.866733249641},{"$f":"+TITULAR!K39","v":26268.131133249641}]
[null,13,{"$f":"+TITULAR!J40","v":25909.169133249641},{"$f":"+TITULAR!K40","v":26119.36113324964}]
[null,14,{"$f":"+TITULAR!J41","v":25331.315133249638},{"$f":"+TITULAR!K41","v":25661.926733249638}]
[null,15,{"$f":"+TITULAR!J42","v":25419.614333249636},{"$f":"+TITULAR!K42","v":25304.739533249638}]
[null,16,{"$f":"+TITULAR!J43","v":25012.570333249638},{"$f":"+TITULAR!K43","v":24483.66833324964}]
[null,17,{"$f":"+TITULAR!J44","v":25130.101533249639},{"$f":"+TITULAR!K44","v":24813.723133249638}]
[]
[]
[null,"Nota: Esta cotización tiene una validez de 15 días apartir de su fecha de elaboración.  La edad limite de aceptación es hasta los 64 años. Incluyen I.V.A. Y derechos de póliza, no incluye recargo por pago fraccionado"]
[]
[null,{"$f":"+IMPRESION!B107","v":"Tarifa Total Vig: Marzo 01, 2018"}]

{"sheet":"Instrucciones","index":9,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":true,"merged":[[22,1,22,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[27,1,27,8],[26,1,26,8],[29,1,29,8],[30,1,30,8],[33,1,33,8],[34,1,34,8],[28,1,28,8],[36,1,36,8],[32,1,32,8],[37,1,37,8],[43,1,43,8],[51,1,51,8],[35,1,35,8],[38,1,38,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[44,1,44,8],[9,1,9,8],[16,1,16,8],[18,1,18,8],[19,1,19,8],[21,1,21,8],[11,1,11,8],[13,1,13,8],[20,1,20,8],[12,1,12,8],[17,1,17,8]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-02-08"}]
[]
[]
[null,"INSTRUCCIONES"]
[]
[null,"Seguros Banorte elaboró para ti esta herramienta de sencilla utilización de la que . . . "]
[null," ¡Estamos seguros, te será de gran utilidad!"]
[]
[]
[]
[null,"1. Seleccione el TIPO DE COTIZACIÓN (Individual o Familiar)"]
[null,"2. Seleccione la fecha de PRIMER VIGENCIA en Seguros Banorte de la póliza a cotizar"]
[null,"3. Seleccione la SUMA ASEGURADA deseada"]
[null,"4. Seleccione el DEDUCIBLE deseado"]
[null,"5. Seleccione el COASEGURO deseado"]
[null,"6. Seleccione el ESTADO donde radica el cliente."]
[null," (El cotizador le asignará la Región que le corresponda)"]
[null,"7. Seleccione si desea COBERTURA DE ELIMINACION DE DEDUCIBLE POR ACCIDENTE  (\"SI\", \" NO\")"]
[null,"8. Seleccione si desea INCREMENTO EN SUMA ASEGURADA POR PARTO O CESÁREA (\"SI\", \"NO\")"]
[null,"9. Seleccione la SUMA ASEGURADA POR PARTO O CESÁREA"]
[null," (La base de suma asegurada es de $20,000)"]
[null,"10. Seleccione si desea COBERTURA DE VISION  (\"SI\", \" NO\")"]
[null,"11. Seleccione si desea COBERTURA DE INDEMNIZACION POR ENFERMEDADES GRAVES , la SUMA ASEGURADA"]
[null,"12. Seleccione si desea COBERTURA TOTAL EN EL EXTRANJERO  (\"SI\", \" NO\")"]
[null,"13. Seleccione si desea EMERGENCIA EN EL EXTRANJERO  (\"SI\", \" NO\")"]
[]
[null,"14. Si eligió la COBERTURA TOTAL EN EL EXTRANJERO"]
[null," deberá especificar la ZONA COBERTURA TOTAL EN EL EXTRANJERO a la que pertenece el cliente:"]
[null,"          A: Deberá elegir la opción A si reside hasta 20 kms de la franja fronteriza con los Estados Unidos de América"]
[null,"          B:  Deberá elegir la opción B si reside en alguna de las siguientes ciudades: BAJA CALIFORNIA NORTE, "]
[null,"               BAJA CALIFORNIA SUR, SONORA, CHIHUAHUA, COAHUILA, NUEVO LEÓN, CAMPECHE, YUCATÁN, "]
[null,"              QUINTANA ROO."]
[null,"          C:  Resto del país, excepto ZONA A Y ZONA B"]
[]
[null,"15. Si desea incrementar la base de honorarios quirúrgicos deberá indicar el porcentaje deseado en INC THQ"]
[null,"16. Indique el IVA que corresponde a su región (16%)"]
[null,"17. Llene el NOMBRE, SEXO y EDAD del Titular, Cónyuge y Dependientes (si fuera el caso)"]
[null,"18. Vaya al FORMATO DE IMPRESIÓN para obtener la COTIZACIÓN"]
[null,"19. Si desea obtener las Tarifas por Edad, después de haber efectuado una COTIZACIÓN podrá consultarlas en TARIFARIO"]

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

{"sheet":"CAMBIOS","index":11,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["CAMBIOS MEDICO TOTAL"]
[]
["HOJA FACTORES (TABLAS DE CALCULO)"]
["Tabla de Deducible"]
["Tabla de Eliminación de Deducible por Accidente"]
["Nueva Tabla de parto y cesárea"]
["Tabla de Enfermedades Graves"]
["Tabla de Tarifas"]
["Se agrega tabla de Base de honorarios"]
["Se modifica tabla de factores por región a quedar 4"]
[]
["HOJA TITULAR DEL COTIZADOR (CALCULO TARIFA)"]
["Modificación de costos cobertura Adicionales (dental, PAQ_ADIC, ASIST_IKE, CVISION)"]
["Se elimina la cobertura de Educasystem (maestro a domicilio)"]
["Se agrega costo por cobertura de parto y cesárea (amarrado a la tabla que se encuentra en factores)"]
["Modificación de costo de Derecho de Póliza a 700 pesos"]
[]
["HOJA COTIZACION (COTIZADOR)"]
["Se deja deducible mínimo en 6,000"]
["se modifica Querétaro a zona 4"]
["se modifican la tabla de estados por zona (sólo hay 4 zonas)"]
[]
["HOJA IMPRESIÓN (formato Cotización y Cuadro de especificaciones)",null,null,null,null,null,null,"CUADRO DE ESPECIFICACIONES IMPLICA"]
["Modificación de la cobertura de enfermedades catastróficas",null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro del botón de “Cuadro de Especificaciones” en el paso 2 del cotizador."]
["Se elimina de cuadro de coberturas la cobertura de Servicio de Maestro a Domicilio",null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro de la cotización. "]
["Se MODIFICA en el cuadro de coberturas la Cobertura de Dental para agregar Visión (REVISAR LAS AYUDAS PARA ESPECIFICAR ALCANCES Y EVITAR CONFUSION CON LA OPCIONAL)",null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro del kit de impresión de la póliza.  "]
["Modificación de base de honorarios quirúrgicos y fórmula para calcularlo",null,null,null,null,null,null,"ü  Cuadro de especificaciones en el botón “Cuadro de Especificaciones” del Tarifario."]
["Modificación de la leyenda de beneficio por pago directo y una leyenda en NOTAS",null,null,null,null,null,null,"ü  Cuadro de especificaciones generado dentro del Tarifario."]
[null,null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro de renovaciones Aviso de Renovación de Póliza"]
["MODULOS A IMPACTAR EN ESPACIO"]
["Tarifa de Línea"]
["Tarifa de Empleados"]
["Tarifario"]
["Renovación"]
[]
["CAMBIO EN NUMERO DE REGISTRO"]
["Solicitud "]
["Carátula"]
["Cuadro de Especificaciones"]
[]
["SABE"]
["Aplicar los cambios en la integración"]
["Considerar la nueva cobertura adicional para cobertura de parto y cesárea (adicional 17)"]
["No integrar la cobertura de educasystem (maestro a domicilio)"]
[]
["MODIFICACION EN CARTAS"]
["Cartas de Bienvenida"]
["Carta de Aviso de Renovación"]
["Carta de Renovación"]
[]
["MODIFICACION DE FORMATOS, TAMAÑO DE LETRA Y FORMATOS"]
["Solicitud"]
["carátula"]
["cuadro de especificaciones."]