{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["FACTORES","TITULAR","CONYUGE","DEPENDIENTE","VALORES","CuadroEspecificacionesTARIFARIO","COTIZACION","IMPRESION","TARIFARIO","Instrucciones","Cotizador","CAMBIOS ME"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":27,"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":436,"n_cols":23,"rows_kept":436,"cut":false,"hidden":true,"merged":[[31,11,31,12],[31,8,31,9],[35,3,35,4],[0,2,0,3],[4,4,4,5],[8,4,8,5],[35,1,35,2],[0,0,0,1],[0,4,0,5],[6,2,6,3],[14,2,14,3]]}
["DEDUCIBLE",null,"COASEGURO",null,"EMERGENCIA EN EL EXTRANJERO",null,null,null,"DED CERO POR ACC","COSTO",null,null,"RPF","FIJO","CAPTURA","% CALCULO"]
["NUEVOS",null,0,1.1499999999999999,null,null,null,null,null,null,null,null,"SEMESTRAL",4.7300000000000002E-2,{"$f":"+COTIZACION!H36","v":4.7300000000000002E-2},{"$f":"IF(O2=0,1+N2,1+O2)","v":1.0472999999999999}]
[6000,1,0.05,1.0900000000000001,null,null,null,null,null,null,null,null,"TRIMESTRAL",7.0000000000000007E-2,{"$f":"+COTIZACION!H37","v":6.9900000000000004E-2},{"$f":"IF(O3=0,1+N3,1+O3)","v":1.0699000000000001}]
[8000,0.94,0.1,1,null,null,null,null,null,null,null,null,"MENSUAL",0.1,{"$f":"+COTIZACION!H38","v":9.9900000000000003E-2},{"$f":"IF(O4=0,1+N4,1+O4)","v":1.0999000000000001}]
[10000,0.88,0.15,0.98,"COBERTURA EN EL EXTRANJERO",null,null,null,5500,617.75994436717667,null,541.66999999999996,{"$f":"(J5/L5)-1","v":0.14047287899860939}]
[15000,0.75900000000000001,0.2,0.92,null,null,null,null,6000,655.21307371349099,null,574.51,{"$f":"(J6/L6)-1","v":0.14047287899860916}]
[20000,0.65400000000000003,"Catálogo",null,null,null,null,null,7000,686.84979137691244,null,602.25,0.14047287899860916]
[25000,0.56699999999999995,null,null,null,null,null,null,8000,714.26675938803908,null,626.29,0.14047287899860939]
[30000,0.52,null,null,"FORMA DE PAGO",null,null,null,9000,738.47899860917948,null,647.52,0.14047287899860939]
[40000,0.45700000000000002,null,null,"A = ANUAL",0,null,null,10000,760.10236439499317,null,666.48,0.14047287899860939]
[50000,0.40899999999999997,null,null,"S = SEMESTRAL",4.7300000000000002E-2,null,null,15000,843.36828929068156,null,739.49,0.14047287899860916]
[null,null,null,null,"T = TRIMESTRAL",7.0000000000000007E-2,null,null,20000,902.45618915159946,null,791.3,0.14047287899860916]
[null,null,null,null,"M = MENSUAL",0.1,null,null,25000,948.26898470097376,null,831.47,0.14047287899860939]
[null,null,null,null,null,null,null,null,30000,1510.8186369958278,null,1324.73,0.14047287899860939]
[null,null,"Topes de COASEGURO",null,null,null,null,null,35000,1559.3571627260087,null,1367.29,0.14047287899860939]
[null,null,0,"NA",null,null,null,null,40000,1601.3721835883175,null,1404.13,0.14047287899860939]
[null,null,0.05,"NA",null,null,null,null,45000,1638.4489568845622,null,1436.64,0.14047287899860939]
[null,null,0.1,"$30,000",null,null,null,null,50000,1671.5910987482616,null,1465.7,0.14047287899860916]
[null,null,0.15,"NA"]
[null,null,0.2,"NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"ZONA","FACTOR"]
[null,null,null,null,null,1,0.52]
[null,null,null,null,null,2,0.56999999999999995]
["G.M.M. INDIVIDUAL/FAMILIAR",null,null,null,null,3,0.67,null,"SUMA ASEGURADA",null,null,"ENFERMEDADES GRAVES"]
["SUMA ASEGURADA",null,1000000,null,null,4,0.8,null,200000,0.82,null,10000,133.19373983979378,116.76,{"$f":"(M33/N33)-1","v":0.14074802877521209}]
["DEDUCIBLE",null,6000,null,null,5,1,null,250000,0.84,null,20000,{"$f":"ROUND(L34/$L$33*$M$33,2)","v":266.39},233.52,{"$f":"(M34/N34)-1","v":0.14075882151421704}]
["COASEGURO",null,0.1,null,null,null,null,null,300000,0.86,null,30000,{"$f":"ROUND(L35/$L$33*$M$33,2)","v":399.58},350.28,{"$f":"(M35/N35)-1","v":0.14074454721936736}]
[null,"BÁSICAS",null,"SA PARTO O CESAREA",null,"ZONA",{"$f":"+COTIZACION!D15","v":4},{"$f":"+VLOOKUP(G36,J228:K233,2,FALSE)","v":"B"},350000,0.88,null,40000,532.77,467.04,{"$f":"(M36/N36)-1","v":0.14073741007194229}]
[{"$f":"VLOOKUP(CONCATENATE(COTIZACION!D8,COTIZACION!D9),COTIZACION!H244:I246,2,0)","v":1},"250,000      a",10000000,15000,null,"FACTOR",{"$f":"VLOOKUP(G36,F30:G35,2,FALSE)","v":0.8},null,400000,0.9,null,50000,665.97,583.79999999999995,{"$f":"(M37/N37)-1","v":0.14075025693730736}]
["E D A D","HOMBRES","MUJERES","HOMBRES","MUJERES","HOMBRES","MUJERES",null,450000,0.91,null,75000,998.95,875.7,{"$f":"(M38/N38)-1","v":0.14074454721936736}]
[0,{"$f":"IF($A$37=$C$130,ROUND(C132*(1-DESC),2),ROUND(E132*(1-DESC),2))","v":5775.22},{"$f":"IF($A$37=$C$130,ROUND(D132*(1-DESC),2),ROUND(F132*(1-DESC),2))","v":5799.42},{"$f":"B39","v":5775.22},{"$f":"C39","v":5799.42},{"$f":"ROUND(D39*$G$37,2)","v":4620.18},4639.54,null,500000,0.92,null,100000,1331.94,1167.5999999999999,{"$f":"(M39/N39)-1","v":0.14075025693730736}]
[1,5775.22,5799.42,{"$f":"B40","v":5775.22},{"$f":"C40","v":5799.42},4620.18,4639.54,null,550000,0.93,null,150000,1997.91,1751.4,0.14075025693730736]
[{"$f":"+A40+1","v":2},5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,600000,0.94,null,200000,2663.87,2335.1999999999998,0.14074597464885241]
[{"$f":"+A41+1","v":3},5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,650000,0.95,null,250000,3329.84,2919,0.1407468311065434]
[4,5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,700000,0.96,null,300000,3995.81,3502.8,0.14074740207833725]
[5,5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,750000,0.97,null,350000,4661.78,4086.6,0.14074780991533298]
[6,5775.22,5799.42,5775.22,5799.42,{"$f":"ROUND(D45*$G$37,2)","v":4620.18},{"$f":"ROUND(E45*$G$37,2)","v":4639.54},null,1000000,1,null,400000,5327.75,4670.3999999999996,0.14074811579307989]
[7,5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,2000000,1.08,null,450000,5993.72,5254.2,0.1407483536979941]
[8,5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,3000000,1.1299999999999999,null,500000,6659.69,5838,0.14074854402192516]
[9,5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,4000000,1.1599999999999999,null,550000,7325.66,6421.8,0.1407486997415055]
[10,5775.22,5799.42,5775.22,5799.42,4620.18,4639.54,null,5000000,1.18,null,600000,7991.62,7005.6,0.14074740207833725]
[11,5840.59,5796.53,5840.59,5796.53,4672.47,4637.22,null,6000000,1.2,null,650000,8657.59,7589.4,0.14074762168287358]
[12,5818.87,5852.15,5818.87,5852.15,4655.1000000000004,4681.72,null,7000000,1.22,null,700000,9323.56,8173.2,0.14074780991533298]
[13,5775.75,5815.74,5775.75,5815.74,4620.6000000000004,4652.59,null,8000000,1.24,null,750000,9989.5300000000007,8757,0.14074797305013131]
[14,5619.55,5702.5,5619.55,5702.5,4495.6400000000003,4562,null,9000000,1.25,null,800000,{"$f":"ROUND(L53/$L$33*$M$33,2)","v":10655.5},9340.7999999999993,0.14074811579307989]
[15,5640.36,5609.18,5640.36,5609.18,4512.29,4487.34,null,10000000,1.26,null,850000,{"$f":"ROUND(L54/$L$33*$M$33,2)","v":11321.47},9924.6,0.14074824174274014]
[16,5544.76,5185.7299999999996,5544.76,5185.7299999999996,4435.8100000000004,4148.58,null,20000000,1.34,null,900000,{"$f":"ROUND(L55/$L$33*$M$33,2)","v":11987.44},10508.4,0.1407483536979941]
[17,5580.31,5270.89,5580.31,5270.89,4464.25,4216.71,null,30000000,1.39]
[18,5736.82,5108.3500000000004,5736.82,5108.3500000000004,4589.46,4086.68,null,40000000,1.42]
[19,5927.72,5183.3100000000004,5927.72,5183.3100000000004,4742.18,4146.6499999999996,null,50000000,1.45]
[20,6143.42,6137.94,6143.42,6137.94,4914.74,4910.3500000000004,null,60000000,1.46]
[21,6635.99,7927.31,6635.99,7927.31,5308.79,6341.85,null,70000000,1.48]
[22,6925.76,8305.2199999999993,6925.76,8305.2199999999993,5540.61,6644.18,null,100000000,1.53]
[23,7385.39,8692.98,7385.39,8692.98,5908.31,6954.38]
[24,7685.16,9099.44,7685.16,9099.44,6148.13,7279.55]
[25,7985.79,9520.7099999999991,7985.79,9520.7099999999991,6388.63,7616.57]
[26,8514.92,9890.15,8514.92,9890.15,6811.94,7912.12]
[27,8891.67,10341.98,8891.67,10341.98,7113.34,8273.58]
[28,9404.1,10824.18,9404.1,10824.18,7523.28,8659.34]
[29,9879.58,11310.78,9879.58,11310.78,7903.66,9048.6200000000008]
[30,10321.9,11845.85,10321.9,11845.85,8257.52,9476.68]
[31,10746.97,12395.33,10746.97,12395.33,8597.58,9916.26]
[32,{"$f":"IF($A$37=$C$130,ROUND(C164*(1-DESC),2),ROUND(E164*(1-DESC),2))","v":11407.85},{"$f":"IF($A$37=$C$130,ROUND(D164*(1-DESC),2),ROUND(F164*(1-DESC),2))","v":12953.61},11407.85,12953.61,9126.2800000000007,10362.89]
[33,11810.3,13522.61,11810.3,{"$f":"C72","v":13522.61},9448.24,10818.09]
[34,12471.01,14131.82,12471.01,14131.82,9976.81,11305.46]
[35,13159.76,14777.37,13159.76,14777.37,10527.81,11821.9]
[36,13722.32,15439.07,13722.32,15439.07,10977.86,12351.26]
[37,14470.51,16177.24,14470.51,16177.24,11576.41,12941.79]
[38,15242.11,16888.78,15242.11,16888.78,{"$f":"ROUND(D77*$G$37,2)","v":12193.69},13511.02]
[39,16074.31,17654.27,16074.31,17654.27,12859.45,14123.42]
[40,16639.62,18447.52,16639.62,18447.52,13311.7,14758.02]
[41,17258.75,19279.53,17258.75,19279.53,13807,15423.62]
[42,17928.43,20145.38,17928.43,20145.38,14342.74,16116.3]
[43,18644.36,21046.09,18644.36,21046.09,14915.49,16836.87]
[44,19446.63,22113.24,19446.63,22113.24,15557.3,17690.59]
[45,20321.05,22904.92,20321.05,22904.92,16256.84,18323.939999999999]
[46,21279.71,23766.68,21279.71,23766.68,17023.77,19013.34]
[47,22332.32,24978.27,22332.32,24978.27,17865.86,19982.62]
[48,23476.86,25982.21,23476.86,25982.21,18781.490000000002,20785.77]
[49,24731.91,27064.99,24731.91,27064.99,19785.53,21651.99]
[50,26111.56,28213.77,26111.56,28213.77,20889.25,22571.02]
[51,27601.360000000001,29444.11,27601.360000000001,29444.11,22081.09,23555.29]
[52,29229.15,30766.47,29229.15,30766.47,23383.32,24613.18]
[53,30983.19,32186.83,30983.19,32186.83,24786.55,25749.46]
[54,32886.54,33700.5,32886.54,33700.5,26309.23,26960.400000000001]
[55,34934.28,35523.65,34934.28,35523.65,27947.42,28418.92]
[56,37144.980000000003,37925.97,37144.980000000003,37925.97,29715.98,30340.78]
[57,39535.25,39369.449999999997,39535.25,39369.449999999997,31628.2,31495.56]
[58,41233.01,40941.64,41233.01,40941.64,32986.410000000003,32753.31]
[59,43910.59,41611.519999999997,43910.59,41611.519999999997,35128.47,33289.22]
[60,46534.35,45012.21,46534.35,45012.21,37227.480000000003,36009.769999999997]
[61,49046.86,46917.18,49046.86,46917.18,39237.49,37533.74]
[62,51693.9,48924.25,51693.9,48924.25,41355.120000000003,39139.4]
[63,54447.12,51015.78,54447.12,51015.78,43557.7,40812.620000000003]
[64,{"$f":"IF($A$37=$C$130,ROUND(C196*(1-DESC),2),ROUND(E196*(1-DESC),2))","v":57354.080000000002},{"$f":"IF($A$37=$C$130,ROUND(D196*(1-DESC),2),ROUND(F196*(1-DESC),2))","v":53249.120000000003},57354.080000000002,53249.120000000003,45883.26,42599.3]
[65,60318.52,55505.47,{"$f":"B104","v":60318.52},{"$f":"C104","v":55505.47},48254.82,{"$f":"ROUND(E104*$G$37,2)","v":44404.38}]
[66,63487.47,57987.56,63487.47,57987.56,50789.98,46390.05]
[{"$f":"+A105+1","v":67},66795.02,60369.72,66795.02,60369.72,53436.02,48295.78]
[68,70192.320000000007,62988.92,70192.320000000007,62988.92,56153.86,50391.14]
[69,73770.53,65802.880000000005,73770.53,65802.880000000005,59016.42,52642.3]
[70,77445.990000000005,68558.83,77445.990000000005,68558.83,{"$f":"ROUND(D109*$G$37,2)","v":61956.79},54847.06]
[71,81187.28,71446.83,81187.28,71446.83,64949.82,57157.46]
[72,85065.87,74532.710000000006,85065.87,74532.710000000006,68052.7,59626.17]
[73,89031.67,77555.11,89031.67,77555.11,71225.34,62044.09]
[74,93319.46,80637.95,93319.46,80637.95,74655.570000000007,64510.36]
[75,97359.19,83957.73,97359.19,83957.73,77887.350000000006,67166.179999999993]
[76,102292.15,87602.12,102292.15,87602.12,81833.72,70081.7]
[77,107562.79,91510.91,107562.79,91510.91,86050.23,73208.73]
[78,113041.97,95582.97,113041.97,95582.97,90433.58,76466.38]
[79,119056.43,99668,119056.43,{"$f":"C118","v":99668},95245.14,{"$f":"ROUND(E118*$G$37,2)","v":79734.399999999994}]
[80,124890.64,103980.12,124890.64,103980.12,99912.51,83184.100000000006]
[81,131744.09,108349.3,131744.09,108349.3,105395.27,86679.44]
[82,138857.41,112540.04,138857.41,112540.04,111085.93,90032.03]
[83,146270.28,117312.15,146270.28,117312.15,117016.22,93849.72]
[84,154030.12,121942.33,{"$f":"B123","v":154030.12},121942.33,123224.1,{"$f":"ROUND(E123*$G$37,2)","v":97553.86}]
[85,162192.71,126703.3,{"$f":"B124","v":162192.71},126703.3,129754.17,{"$f":"ROUND(E124*$G$37,2)","v":101362.64}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarifa 2015-2016"]
[]
[null,null,0,"Nueva",1,"Renovada",null,null,null,null,null,null,null,null,"Nueva",null,"Renovada"]
["E D A D","Auxiliar por zona","HOMBRES","MUJERES","HOMBRES","MUJERES",null,null,null,null,null,null,null,"E D A D","HOMBRES","MUJERES","HOMBRES","MUJERES"]
[0,{"$f":"+CONCATENATE(A132,$H$36)","v":"0B"},{"$f":"+VLOOKUP(B132,$B$226:$F$436,4,FALSE)","v":5775.2151256540801},{"$f":"+VLOOKUP(B132,$B$226:$F$436,5,FALSE)","v":5799.4212124277701},{"$f":"+VLOOKUP(B132,$B$226:$F$436,2,FALSE)","v":5775.2151256540801},{"$f":"+VLOOKUP(B132,$B$226:$F$436,3,FALSE)","v":5799.4212124277701},null,null,null,null,null,null,null,0,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[1,{"$f":"+CONCATENATE(A133,$H$36)","v":"1B"},{"$f":"+VLOOKUP(B133,$B$226:$F$436,4,FALSE)","v":5775.2151256540801},{"$f":"+VLOOKUP(B133,$B$226:$F$436,5,FALSE)","v":5799.4212124277701},{"$f":"+VLOOKUP(B133,$B$226:$F$436,2,FALSE)","v":5775.2151256540801},{"$f":"+VLOOKUP(B133,$B$226:$F$436,3,FALSE)","v":5799.4212124277701},null,null,null,null,null,null,null,1,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[{"$f":"+A133+1","v":2},{"$f":"+CONCATENATE(A134,$H$36)","v":"2B"},5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,2,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[{"$f":"+A134+1","v":3},{"$f":"+CONCATENATE(A135,$H$36)","v":"3B"},5775.2151256540801,5799.4212124277701,5775.2151256540756,5799.4212124277701,null,null,null,null,null,null,null,3,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[4,{"$f":"+CONCATENATE(A136,$H$36)","v":"4B"},5775.2151256540801,5799.4212124277701,5775.2151256540756,5799.4212124277701,null,null,null,null,null,null,null,4,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[5,{"$f":"+CONCATENATE(A137,$H$36)","v":"5B"},5775.2151256540801,5799.4212124277701,5775.2151256540756,5799.4212124277701,null,null,null,null,null,null,null,5,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[6,{"$f":"+CONCATENATE(A138,$H$36)","v":"6B"},5775.2151256540801,5799.4212124277701,5775.2151256540756,5799.4212124277701,null,null,null,null,null,null,null,6,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[7,{"$f":"+CONCATENATE(A139,$H$36)","v":"7B"},5775.2151256540801,5799.4212124277701,5775.2151256540756,5799.4212124277701,null,null,null,null,null,null,null,7,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[8,{"$f":"+CONCATENATE(A140,$H$36)","v":"8B"},5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,8,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[9,{"$f":"+CONCATENATE(A141,$H$36)","v":"9B"},5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,9,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[10,"10B",5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,10,4311.7297297297309,4329.801801801802,4311.7297297297309,4329.801801801802]
[11,"11B",5840.5932802601892,5796.5251701417865,5840.5932802601892,5796.5251701417865,null,null,null,null,null,null,null,11,4360.5405405405409,4327.6396396396403,4360.5405405405409,4327.6396396396403]
[12,"12B",5818.8729631153028,5852.1533157184131,5818.8729631153028,5852.1533157184131,null,null,null,null,null,null,null,12,4344.3243243243251,4369.1711711711714,4344.3243243243251,4369.1711711711714]
[13,"13B",5775.7460667398427,5815.7355839721531,5775.7460667398427,5815.7355839721531,null,null,null,null,null,null,null,13,4312.126126126127,4341.9819819819832,4312.126126126127,4341.9819819819832]
[14,"14B",5619.5528527823881,5702.50033059014,5619.5528527823881,5702.50033059014,null,null,null,null,null,null,null,14,4195.5135135135142,4257.4414414414423,4195.5135135135142,4257.4414414414423]
[15,"15B",5640.3560898700443,5609.1753679242747,5640.3560898700443,5609.1753679242747,null,null,null,null,null,null,null,15,4211.0450450450453,4187.7657657657664,4211.0450450450453,4187.7657657657664]
[16,"16B",5544.7625607468253,5185.7257183418378,5544.7625607468253,5185.7257183418378,null,null,null,null,null,null,null,16,4139.6756756756758,3871.6216216216221,4139.6756756756758,3871.6216216216221]
[17,"17B",5580.3114798072902,5270.8934952355121,5580.3114798072902,5270.8934952355121,null,null,null,null,null,null,null,17,4166.2162162162167,3935.2072072072074,4166.2162162162167,3935.2072072072074]
[18,"18B",5736.8184316790612,5108.3531219346069,5736.8184316790612,5108.3531219346069,null,null,null,null,null,null,null,18,4283.0630630630631,3813.8558558558566,4283.0630630630631,3813.8558558558566]
[19,"19B",5927.7158856969036,5183.3123497701836,5927.7158856969036,5183.3123497701836,null,null,null,null,null,null,null,19,4425.5855855855862,3869.8198198198202,4425.5855855855862,3869.8198198198202]
[20,"20B",6143.4227686313525,6137.9444219736961,6143.4227686313525,6137.9444219736961,null,null,null,null,null,null,null,20,4586.6306306306315,4582.5405405405409,4586.6306306306315,4582.5405405405409]
[21,"21B",6635.9912941059611,7927.3124157409429,6635.9912941059611,7927.3124157409429,null,null,null,null,null,null,null,21,4954.3783783783783,5918.4684684684689,4954.3783783783783,5918.4684684684689]
[22,"22B",6925.7644585044754,8305.2218003762664,6925.7644585044754,8305.2218003762664,null,null,null,null,null,null,null,22,5170.7207207207211,6200.6126126126137,5170.7207207207211,6200.6126126126137]
[23,"23B",7385.3905029760053,8692.977728783937,7385.3905029760053,8692.977728783937,null,null,null,null,null,null,null,23,5513.8738738738739,6490.1081081081093,5513.8738738738739,6490.1081081081093]
[24,"24B",7685.1550132611674,9099.437263621925,7685.1550132611674,9099.437263621925,null,null,null,null,null,null,null,24,5737.6756756756758,6793.5675675675684,5737.6756756756758,6793.5675675675684]
[25,"25B",7985.7883362321236,9520.7148814898737,7985.7883362321236,9520.7148814898737,null,null,null,null,null,null,null,25,5962.126126126127,7108.0900900900906,5962.126126126127,7108.0900900900906]
[26,"26B",8514.9193955672945,9890.1533424386889,8514.9193955672945,9890.1533424386889,null,null,null,null,null,null,null,26,6357.1711711711723,7383.9099099099103,6357.1711711711723,7383.9099099099103]
[27,"27B",8891.6703632882218,10341.984206423778,8891.6703632882218,10341.984206423778,null,null,null,null,null,null,null,27,6638.4504504504512,7721.2432432432443,6638.4504504504512,7721.2432432432443]
[28,"28B",9404.1009121075476,10824.175247040277,9404.1009121075476,10824.175247040277,null,null,null,null,null,null,null,28,7021.0270270270275,8081.2432432432443,7021.0270270270275,8081.2432432432443]
[29,"29B",9879.5827880948473,11310.782752142901,9879.5827880948473,11310.782752142901,null,null,null,null,null,null,null,29,7376.0180180180187,8444.5405405405418,7376.0180180180187,8444.5405405405418]
[30,"30B",10321.904979907617,11845.850698164344,10321.904979907617,11845.850698164344,null,null,null,null,null,null,null,30,7706.2522522522531,8844.0180180180196,7706.2522522522531,8844.0180180180196]
[31,"31B",10746.971586433063,12395.326454558557,10746.971586433063,12395.326454558557,null,null,null,null,null,null,null,31,8023.6036036036048,9254.2522522522522,8023.6036036036048,9254.2522522522522]
[32,"32B",11407.84843609483,12953.611006239307,11407.84843609483,12953.611006239307,null,null,null,null,null,null,null,32,8517.0090090090089,9671.063063063064,8517.0090090090089,9671.063063063064]
[33,"33B",11810.301779103875,13522.610914378207,11810.301779103875,13522.610914378207,null,null,null,null,null,null,null,33,8817.4774774774778,10095.873873873876,8817.4774774774778,10095.873873873876]
[34,"34B",12471.00969296563,14131.817542920864,12471.00969296563,14131.817542920864,null,null,null,null,null,null,null,34,9310.7567567567585,10550.702702702705,9310.7567567567585,10550.702702702705]
[35,"35B",13159.760949630005,14777.369502152629,13159.760949630005,14777.369502152629,null,null,null,null,null,null,null,35,9824.9729729729734,11032.666666666668,9824.9729729729734,11032.666666666668]
[36,"36B",13722.317163682585,15439.066897128761,13722.317163682585,15439.066897128761,null,null,null,null,null,null,null,36,10244.972972972973,11526.684684684687,10244.972972972973,11526.684684684687]
[37,"37B",14470.509688266802,16177.243942140614,14470.509688266802,16177.243942140614,null,null,null,null,null,null,null,37,10803.567567567568,12077.801801801803,10803.567567567568,12077.801801801803]
[38,"38B",15242.111887996067,16888.777398121405,15242.111887996067,16888.777398121405,null,null,null,null,null,null,null,38,11379.639639639641,12609.027027027028,11379.639639639641,12609.027027027028]
[39,"39B",16074.313772559562,17654.273775364378,16074.313772559562,17654.273775364378,null,null,null,null,null,null,null,39,12000.954954954956,13180.540540540542,12000.954954954956,13180.540540540542]
[40,"40B",16639.621226783835,18447.523891181379,16639.621226783835,18447.523891181379,null,null,null,null,null,null,null,40,12423.009009009011,13772.774774774776,12423.009009009011,13772.774774774776]
[41,"41B",17258.746800155983,19279.532706259146,17258.746800155983,19279.532706259146,null,null,null,null,null,null,null,41,12885.243243243245,14393.945945945949,12885.243243243245,14393.945945945949]
[42,"42B",17928.432445104292,20145.376948711506,17928.432445104292,20145.376948711506,null,null,null,null,null,null,null,42,13385.225225225227,15040.37837837838,13385.225225225227,15040.37837837838]
[43,"43B",18644.358231885501,21046.094367024256,18644.358231885501,21046.094367024256,null,null,null,null,null,null,null,43,13919.729729729732,15712.846846846847,13919.729729729732,15712.846846846847]
[44,"44B",19446.634346160481,22113.237682038296,19446.634346160481,22113.237682038296,null,null,null,null,null,null,null,44,14518.702702702705,16509.56756756757,14518.702702702705,16509.56756756757]
[45,"45B",20321.046047042215,22904.919108283717,20321.046047042215,22904.919108283717,null,null,null,null,null,null,null,45,15171.531531531535,17100.630630630632,15171.531531531535,17100.630630630632]
[46,"46B",21279.708444760385,23766.68475784998,21279.708444760385,23766.68475784998,null,null,null,null,null,null,null,46,15887.261261261263,17744.018018018021,15887.261261261263,17744.018018018021]
[47,"47B",22332.323280973054,24978.268181877505,22332.323280973054,24978.268181877505,null,null,null,null,null,null,null,47,16673.135135135137,18648.576576576575,16673.135135135137,18648.576576576575]
[48,"48B",23476.863326080034,25982.205373999914,23476.863326080034,25982.205373999914,null,null,null,null,null,null,null,48,17527.639639639641,19398.10810810811,17527.639639639641,19398.10810810811]
[49,"49B",24731.911518083049,27064.987317358264,24731.911518083049,27064.987317358264,null,null,null,null,null,null,null,49,18464.64864864865,20206.504504504508,18464.64864864865,20206.504504504508]
[50,"50B",26111.56192944057,28213.774891151352,26111.56192944057,28213.774891151352,null,null,null,null,null,null,null,50,19494.684684684686,21064.180180180185,19494.684684684686,21064.180180180185]
[51,"51B",27601.358482408396,29444.110188980634,27601.358482408396,29444.110188980634,null,null,null,null,null,null,null,51,20606.954954954959,21982.738738738743,20606.954954954959,21982.738738738743]
[52,"52B",29229.151450303398,30766.467230447084,29229.151450303398,30766.467230447084,null,null,null,null,null,null,null,52,21822.252252252256,22970.000000000004,21822.252252252256,22970.000000000004]
[53,"53B",30983.187728181627,32186.831169608409,30983.187728181627,32186.831169608409,null,null,null,null,null,null,null,53,23131.801801801805,24030.432432432433,23131.801801801805,24030.432432432433]
[54,"54B",32886.539119588102,33700.495937749889,32886.539119588102,33700.495937749889,null,null,null,null,null,null,null,54,24552.828828828831,25160.522522522526,24552.828828828831,25160.522522522526]
[55,"55B",34934.282352636641,35523.651091520303,34934.282352636641,35523.651091520303,null,null,null,null,null,null,null,55,26081.657657657659,26521.67567567568,26081.657657657659,26521.67567567568]
[56,"56B",37144.976231643275,37925.966435116265,37144.976231643275,37925.966435116265,null,null,null,null,null,null,null,56,27732.144144144149,28315.225225225229,27732.144144144149,28315.225225225229]
[57,"57B",39535.248866066671,39369.450445194037,39535.248866066671,39369.450445194037,null,null,null,null,null,null,null,57,29516.702702702707,29392.91891891892,29516.702702702707,29392.91891891892]
[58,"58B",41233.005388853933,40941.639401198139,41233.005388853933,40941.639401198139,null,null,null,null,null,null,null,58,30784.234234234238,30566.702702702707,30784.234234234238,30566.702702702707]
[59,"59B",43910.589551732774,41611.518115632171,43910.589551732774,41611.518115632171,null,null,null,null,null,null,null,59,32783.2972972973,31066.828828828831,32783.2972972973,31066.828828828831]
[60,"60B",58578.537828159511,56662.428330682887,46534.352480313632,45012.209421570507,null,null,null,null,null,null,null,60,43731.05882352942,42300.611764705885,34739.626168224306,33603.289719626169]
[61,"61B",61741.344551886868,59060.449105858257,49046.862494489586,46917.179196242541,null,null,null,null,null,null,null,61,46092.211764705884,44090.823529411769,36615.308411214959,35025.420560747669]
[62,"62B",65073.497861296077,61587.000567132753,51693.900170188492,48924.252786974612,null,null,null,null,null,null,null,62,48579.788235294123,45976.988235294128,38591.420560747669,36523.775700934588]
[63,"63B",68539.319302080097,64219.862475737376,54447.122810063622,51015.778602221275,null,null,null,null,null,null,null,63,51167.152941176479,47942.517647058834,40646.803738317765,38085.17757009346]
[64,"64B",72198.661687603788,67031.242728154029,57354.07704155441,53249.118055075625,null,null,null,null,null,null,null,64,53898.988235294128,50041.317647058837,42816.95327102804,39752.448598130846]
[65,{"$f":"+CONCATENATE(A197,$H$36)","v":"65B"},{"$f":"+VLOOKUP(B197,$B$226:$F$436,4,FALSE)","v":75930.369559955259},{"$f":"+VLOOKUP(B197,$B$226:$F$436,5,FALSE)","v":69871.588086143267},{"$f":"+VLOOKUP(B197,$B$226:$F$436,2,FALSE)","v":60318.517874730816},{"$f":"+VLOOKUP(B197,$B$226:$F$436,3,FALSE)","v":55505.467171235323},null,null,null,null,null,null,null,65,56684.847058823543,52161.741176470598,45030.018691588797,41436.897196261692]
[66,"66B",79919.51702133505,72996.100355821967,63487.466792649342,57987.556357428672,null,null,null,null,null,null,null,66,59662.894117647069,54494.305882352957,47395.757009345798,43289.869158878515]
[{"$f":"+A198+1","v":67},"67B",84083.148513672364,75994.824011419871,66795.024520207036,60369.720009071854,null,null,null,null,null,null,null,67,62771.200000000004,56732.964705882361,49864.97196261683,45068.242990654209]
[68,"68B",88359.740765935916,79291.929227905552,70192.31743088369,62988.91574179411,null,null,null,null,null,null,null,68,65963.835294117656,59194.37647058825,52401.177570093467,47023.570093457951]
[69,"69B",92864.082586064163,82834.213504510146,73770.532895471551,65802.879886760391,null,null,null,null,null,null,null,69,69326.49411764706,61838.823529411777,55072.448598130846,49124.299065420571]
[70,"70B",97490.840586871418,86303.470414834301,77445.994858729639,68558.831637952477,null,null,null,null,null,null,null,70,72780.541176470593,64428.752941176484,57816.317757009354,51181.719626168233]
[71,"71B",102200.45959154199,89938.953621991881,81187.280983935212,71446.832316535612,null,null,null,null,null,null,null,71,76296.447058823542,67142.776470588244,60609.327102803749,53337.719626168233]
[72,"72B",107082.92368757291,93823.524129846206,85065.873957417716,74532.70608445727,null,null,null,null,null,null,null,72,79941.388235294129,70042.752941176484,63504.84112149533,55641.439252336451]
[73,"73B",112075.1652185433,97628.196332339765,89031.673304450305,77555.109235970856,null,null,null,null,null,null,null,73,83668.282352941183,72883.082352941186,66465.457943925241,57897.775700934588]
[74,"74B",117472.72911911519,101508.95315382385,93319.457711446623,80637.953439953519,null,null,null,null,null,null,null,74,87697.764705882379,75780.211764705891,69666.448598130853,60199.233644859822]
[75,"75B",122558.04350836185,105687.96546391895,97359.193441222029,83957.729574141209,null,null,null,null,null,null,null,75,91494.141176470614,78900.000000000015,72682.261682242999,62677.570093457951]
[76,"76B",128767.76501545697,110275.60954087898,102292.14977863406,87602.119728735648,null,null,null,null,null,null,null,76,96129.929411764722,82324.847058823536,76364.897196261692,65398.242990654209]
[77,"77B",135402.57072152686,115196.08442833599,107562.78982551197,91510.908190734204,null,null,null,null,null,null,null,77,101083.05882352944,85998.164705882373,80299.62616822432,68316.299065420579]
[78,"78B",142299.89042576228,120322.08864488869,113041.96902981117,95582.967615098474,null,null,null,null,null,null,null,78,106232.16470588236,89824.917647058828,84390.03738317758,71356.242990654209]
[79,"79B",149871.03493090827,125464.4192212745,119056.42961801124,99667.996577647966,null,null,null,null,null,null,null,79,111884.30588235296,93663.85882352943,88880.056074766369,74405.869158878515]
[80,"80B",157215.2808560573,130892.61868508524,124890.64367069973,103980.11764703038,null,null,null,null,null,null,null,80,117367.05882352943,97716.211764705891,93235.514018691596,77625.028037383192]
[81,"81B",165842.56434121684,136392.64782854778,131744.09316825637,108349.29967688376,null,null,null,null,null,null,null,81,123807.64705882355,101822.18823529413,98351.869158878515,80886.785046728983]
[82,"82B",174796.97386635255,141668.04769299398,138857.40914616789,112540.03788695787,null,null,null,null,null,null,null,82,130492.44705882356,105760.4705882353,103662.22429906543,84015.327102803742]
[83,"83B",184128.46557110813,147675.29712370352,146270.27638826345,117312.15192069906,null,null,null,null,null,null,null,83,137458.7529411765,110245.10588235296,109196.20560747666,87577.887850467305]
[84,"84B",193896.73467850254,153503.87062025507,154030.11633338989,121942.32712824002,null,null,null,null,null,null,null,84,144751.12941176473,114596.35294117648,114989.21495327105,91034.485981308419]
[85,"85B",204172.00344665977,159497.09451018131,162192.71301837458,126703.29937724683,null,null,null,null,null,null,null,85,152422.00000000003,119070.51764705885,121082.89719626169,94588.728971962628]
[86,"86B",204172.00344665977,159497.09451018131,162192.71301837458,126703.29937724683,null,null,null,null,null,null,null,86,152422.00000000003,119070.51764705885,121082.89719626169,94588.728971962628]
[87,"87B",204172.00344665977,159497.09451018131,162192.71301837458,126703.29937724683,null,null,null,null,null,null,null,87,152422.00000000003,119070.51764705885,121082.89719626169,94588.728971962628]
[88,"88B",204172.00344665977,159497.09451018131,162192.71301837458,126703.29937724683,null,null,null,null,null,null,null,88,152422.00000000003,119070.51764705885,121082.89719626169,94588.728971962628]
[89,"89B",{"$f":"+VLOOKUP(B221,$B$226:$F$436,4,FALSE)","v":204172.00344665977},159497.09451018131,162192.71301837458,126703.29937724683,null,null,null,null,null,null,null,89,152422.00000000003,119070.51764705885,121082.89719626169,94588.728971962628]
[90,"90B",204172.00344665977,159497.09451018131,162192.71301837458,126703.29937724683,null,null,null,null,null,null,null,90,152422.00000000003,119070.51764705885,121082.89719626169,94588.728971962628]
[]
[]
[]
[null,null,null,"Tarifas de zona 1, 2, 3 y 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarifas de zona 1, 2, 3 y 5"]
[null,"A","Renovada","Renovada","Nueva","Nueva",null,null,null,null,null,null,null,null,null,null,null,null,null,"Renovada","Renovada","Nueva","Nueva"]
["E D A D","Indicador","HOMBRES","MUJERES","HOMBRES","MUJERES",null,null,"Nombre de Zona","Zona","Auxiliar",null,null,null,null,null,null,null,null,"HOMBRES","MUJERES","HOMBRES","MUJERES"]
[0,{"$f":"+CONCATENATE(A229,$B$227)","v":"0A"},6143.4316732013212,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,"Zona 1",1,"A",null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[1,"1A",6143.4316732013212,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,"Zona 2",2,"A",null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[2,"2A",6143.4316732013212,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,"Zona 3",3,"A",null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[3,"3A",6143.4316732013158,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,"Zona 4",4,"B",null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[4,"4A",6143.4316732013158,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,"Zona 5",5,"A",null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[5,"5A",6143.4316732013158,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[6,"6A",6143.4316732013158,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[7,"7A",6143.4316732013158,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[8,"8A",6143.4316732013212,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[9,"9A",6143.4316732013212,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[10,{"$f":"+CONCATENATE(A239,$B$227)","v":"10A"},6143.4316732013212,6169.1810932548124,6143.4316732013212,6169.1810932548124,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.2031657512644,5411.7913320157104,5389.2031657512644,5411.7913320157104]
[11,"11A",6212.9782125083111,6166.100404913419,6212.9782125083111,6166.100404913419,null,null,null,null,null,null,null,null,null,null,null,null,null,5450.2114832092766,5409.0888594815797,5450.2114832092766,5409.0888594815797]
[12,"12A",6189.8730499478497,6225.2752934710461,6189.8730499478497,6225.2752934710461,null,null,null,null,null,null,null,null,null,null,null,null,null,5429.9429392032926,5460.9988527413507,5429.9429392032926,5460.9988527413507]
[13,"13A",6143.996466063908,6186.5356375780057,6143.996466063908,6186.5356375780057,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.6986190491871,5427.0152606246511,5389.6986190491871,5427.0152606246511]
[14,"14A",5977.8446748513416,6066.0807234294616,5977.8446748513416,6066.0807234294616,null,null,null,null,null,null,null,null,null,null,null,null,null,5243.9452670417077,5321.3485845401174,5243.9452670417077,5321.3485845401174]
[15,"15A",5999.974286103693,5966.8055416280085,5999.974286103693,5966.8055416280085,null,null,null,null,null,null,null,null,null,null,null,null,null,5263.3580280785482,5234.2614071277367,5263.3580280785482,5234.2614071277367]
[16,"16A",5898.285898434815,5516.3575613103731,5898.285898434815,5516.3575613103731,null,null,null,null,null,null,null,null,null,null,null,null,null,5174.1539138477656,4839.114881428839,5174.1539138477656,4839.114881428839]
[17,"17A",5936.1013478254381,5606.9554709502299,5936.1013478254381,5606.9554709502299,null,null,null,null,null,null,null,null,null,null,null,null,null,5207.3267642042274,4918.5900945367503,5207.3267642042274,4918.5900945367503]
[18,"18A",6102.586880274991,5434.0518377894377,6102.586880274991,5434.0518377894377,null,null,null,null,null,null,null,null,null,null,null,null,null,5353.3728840695721,4766.9138235586315,5353.3728840695721,4766.9138235586315]
[19,"19A",6305.6555867786092,5513.7903210258773,6305.6555867786092,5513.7903210258773,null,null,null,null,null,null,null,null,null,null,null,null,null,5531.5108652777262,4836.8628209837298,5531.5108652777262,4836.8628209837298]
[20,"20A",6535.1155234068465,6529.2878879610398,6535.1155234068465,6529.2878879610398,null,null,null,null,null,null,null,null,null,null,null,null,null,5732.8000278616064,5727.6878506512066,5732.8000278616064,5727.6878506512066]
[21,"21A",7059.0892654724394,8432.742524497613,7059.0892654724394,8432.742524497613,null,null,null,null,null,null,null,null,null,null,null,null,null,6192.4455647084351,7397.4555470731257,6192.4455647084351,7397.4555470731257]
[22,"22A",7367.3378064318531,8834.7466806468146,7367.3378064318531,8834.7466806468146,null,null,null,null,null,null,null,null,null,null,null,null,null,6462.8504623527224,7750.1056921728095,6462.8504623527224,7750.1056921728095]
[23,"23A",7856.2687186140793,9247.2251771567553,7856.2687186140793,9247.2251771567553,null,null,null,null,null,null,null,null,null,null,null,null,null,6891.755374123808,8111.944243888538,6891.755374123808,8111.944243888538]
[24,"24A",8175.1456343513046,9679.5997858715382,8175.1456343513046,9679.5997858715382,null,null,null,null,null,null,null,null,null,null,null,null,null,7171.4838020108482,8491.2362640538613,7171.4838020108482,8491.2362640538613]
[25,"25A",8494.9467565909472,10127.737249933127,8494.9467565909472,10127.737249933127,null,null,null,null,null,null,null,null,null,null,null,null,null,7452.0229716581271,8884.3559353521614,7452.0229716581271,8884.3559353521614]
[26,"26A",9057.8141889666531,10520.730392683745,9057.8141889666531,10520.730392683745,null,null,null,null,null,null,null,null,null,null,null,null,null,7945.7872242483636,9229.1013482895087,7945.7872242483636,9229.1013482895087]
[27,"27A",9458.5860697792941,11001.369118747052,9458.5860697792941,11001.369118747052,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.3563803343932,9650.7321048228914,8297.3563803343932,9650.7321048228914]
[28,"28A",10003.688199386292,11514.303727589317,10003.688199386292,11514.303727589317,null,null,null,null,null,null,null,null,null,null,null,null,null,8775.5363746444764,10100.693781755752,8775.5363746444764,10100.693781755752]
[29,"29A",10509.485880237657,12031.936386152205,10509.485880237657,12031.936386152205,null,null,null,null,null,null,null,null,null,null,null,null,null,9219.2373235399318,10554.776729303161,9219.2373235399318,10554.776729303161]
[30,"30A",10980.009679580047,12601.119229627775,10980.009679580047,12601.119229627775,null,null,null,null,null,null,null,null,null,null,null,null,null,9631.9949619195831,11054.081050588371,9631.9949619195831,11054.081050588371]
[31,"31A",11432.177710888296,13185.62849760178,11432.177710888296,13185.62849760178,null,null,null,null,null,null,null,null,null,null,null,null,null,10028.650368116705,11566.830172730879,10028.650368116705,11566.830172730879]
[32,"32A",12135.190790394627,13779.508192614192,12135.190790394627,13779.508192614192,null,null,null,null,null,null,null,null,null,null,null,null,null,10645.354600405462,12087.799315498036,10645.354600405462,12087.799315498036]
[33,"33A",12563.303780237147,14384.786434489772,12563.303780237147,14384.786434489772,null,null,null,null,null,null,null,null,null,null,null,null,null,11020.908200231906,12618.767606641484,11020.908200231906,12618.767606641484]
[34,"34A",13266.137152923568,15032.834899505051,13266.137152923568,15032.834899505051,null,null,null,null,null,null,null,null,null,null,null,null,null,11637.454788289511,13187.255224800452,11637.454788289511,13187.255224800452]
[35,"35A",13998.801857715825,15719.546003204834,13998.801857715825,15719.546003204834,null,null,null,null,null,null,null,null,null,null,null,null,null,12280.170318719283,13789.658873262766,12280.170318719283,13789.658873262766]
[36,"36A",14597.225568031798,16423.431944407894,14597.225568031798,16423.431944407894,null,null,null,null,null,null,null,null,null,null,null,null,null,12805.125608474285,14407.128806102866,12805.125608474285,14407.128806102866]
[37,"37A",15393.121401031189,17208.67373022663,15393.121401031189,17208.67373022663,null,null,null,null,null,null,null,null,null,null,null,null,null,13503.309387667105,15095.966534448478,13503.309387667105,15095.966534448478]
[38,"38A",16213.919464790193,17965.573183304528,16213.919464790193,17965.573183304528,null,null,null,null,null,null,null,null,null,null,null,null,null,14223.338153177485,15759.941515480084,14223.338153177485,15759.941515480084]
[39,"39A",17099.180932092881,18779.876129143748,17099.180932092881,18779.876129143748,null,null,null,null,null,null,null,null,null,null,null,null,null,14999.916156464562,16474.272568064334,14999.916156464562,16474.272568064334]
[40,"40A",17700.531296333185,19623.702338254683,17700.531296333185,19623.702338254683,null,null,null,null,null,null,null,null,null,null,null,null,null,15527.438795126991,17214.50231576735,15527.438795126991,17214.50231576735]
[41,"41A",18359.131118917736,20508.758426334611,18359.131118917736,20508.758426334611,null,null,null,null,null,null,null,null,null,null,null,null,null,16105.182381715358,17990.900154218816,16105.182381715358,17990.900154218816]
[42,"42A",19071.514625462478,21429.807223203177,19071.514625462478,21429.807223203177,null,null,null,null,null,null,null,null,null,null,null,null,null,16730.106634628766,18798.871880110721,16730.106634628766,18798.871880110721]
[43,"43A",19833.086455858167,22387.952642182696,19833.086455858167,22387.952642182696,null,null,null,null,null,null,null,null,null,null,null,null,null,17398.180365670476,19639.385879434449,17398.180365670476,19639.385879434449]
[44,"44A",20686.514143633103,23523.134951181062,20686.514143633103,23523.134951181062,null,null,null,null,null,null,null,null,null,null,null,null,null,18146.83281943819,20635.201967052933,18146.83281943819,20635.201967052933]
[45,"45A",21616.67664351163,24365.292454107064,21616.67664351163,24365.292454107064,null,null,null,null,null,null,null,null,null,null,null,null,null,18962.799359910237,21373.96787546662,18962.799359910237,21373.96787546662]
[46,"46A",22636.461501721897,25282.002614894831,22636.461501721897,25282.002614894831,null,null,null,null,null,null,null,null,null,null,null,null,null,19857.385330521043,22178.133619206292,19857.385330521043,22178.133619206292]
[47,"47A",23756.18902420759,26570.834254920261,23756.18902420759,26570.834254920261,null,null,null,null,null,null,null,null,null,null,null,null,null,20839.644014259964,23308.735524464562,20839.644014259964,23308.735524464562]
[48,"48A",24973.702729129731,27638.780540867676,24973.702729129731,27638.780540867676,null,null,null,null,null,null,null,null,null,null,null,null,null,21907.6836803531,24245.570149025625,21907.6836803531,24245.570149025625]
[49,"49A",26308.770366678928,28790.598566909568,26308.770366678928,28790.598566909568,null,null,null,null,null,null,null,null,null,null,null,null,null,23078.845194227793,25255.979588328417,23078.845194227793,25255.979588328417]
[50,"50A",27776.384620116645,30012.630614732418,27776.384620116645,30012.630614732418,null,null,null,null,null,null,null,null,null,null,null,null,null,24366.280588883488,26327.982880804946,24366.280588883488,26327.982880804946]
[51,"51A",29361.167720138761,31321.409711768381,29361.167720138761,31321.409711768381,null,null,null,null,null,null,null,null,null,null,null,null,null,25756.500022253978,27476.083295721721,25756.500022253978,27476.083295721721]
[52,"52A",31092.745619628338,32728.077680852166,31092.745619628338,32728.077680852166,null,null,null,null,null,null,null,null,null,null,null,null,null,27275.492271875824,28710.054775410517,27275.492271875824,28710.054775410517]
[53,"53A",32958.615858399891,34239.001277889329,32958.615858399891,34239.001277889329,null,null,null,null,null,null,null,null,null,null,null,null,null,28912.28980338134,30035.482429775206,28912.28980338134,30035.482429775206]
[54,"54A",34983.321253573209,35849.174384325102,34983.321253573209,35849.174384325102,null,null,null,null,null,null,null,null,null,null,null,null,null,30688.422314625779,31447.974740947822,30688.422314625779,31447.974740947822]
[55,"55A",37161.624634967899,37788.570384844628,37161.624634967899,37788.570384844628,null,null,null,null,null,null,null,null,null,null,null,null,null,32599.29560230111,33149.27128360128,32599.29560230111,33149.27128360128]
[56,"56A",39513.268080371759,40344.052708837444,39513.268080371759,40344.052708837444,null,null,null,null,null,null,null,null,null,null,null,null,null,34662.228011230232,35391.017291872085,34662.228011230232,35391.017291872085]
[57,"57A",42055.939875344928,41879.570467800069,42055.939875344928,41879.570467800069,null,null,null,null,null,null,null,null,null,null,null,null,null,36892.736237879937,36738.019685300926,36892.736237879937,36738.019685300926]
[58,"58A",43861.942070682053,43551.999151134878,43861.942070682053,43551.999151134878,null,null,null,null,null,null,null,null,null,null,null,null,null,38477.015719805509,38205.124462267449,38477.015719805509,38205.124462267449]
[59,"59A",46710.243821524462,44264.588036902373,46710.243821524462,44264.588036902373,null,null,null,null,null,null,null,null,null,null,null,null,null,40975.63174244549,38830.228880016468,40975.63174244549,38830.228880016468]
[60,"60A",49501.800896874011,47882.592320535972,62314.0317172414,60275.733862321766,null,null,null,null,null,null,null,null,null,null,null,null,null,43423.491006798606,42003.10452027007,54662.512208558241,52874.496278457627]
[61,"61A",52174.531123984321,49909.040083836677,65678.527414897893,62826.67398788852,null,null,null,null,null,null,null,null,null,null,null,null,null,45768.037566272418,43780.725427613506,57613.882583425257,55112.207302995819]
[62,"62A",54990.367705022065,52044.10271989301,69223.168758086584,65514.341070924143,null,null,null,null,null,null,null,null,null,null,null,null,null,48238.118497429576,45653.624423124566,60723.278579117214,57469.856626756809]
[63,"63A",57919.160557603864,54269.00301308636,72910.002113689581,68315.097910591066,null,null,null,null,null,null,null,null,null,null,null,null,null,50807.285836610012,47605.329939329451,63957.406876673791,59926.70945303826]
[64,"64A",61011.488309332206,56644.760255590147,76802.697048218193,71305.757027625252,null,null,null,null,null,null,null,null,null,null,null,null,null,53519.90767832828,49689.368729536669,67372.119077425014,62550.146518357935]
[65,{"$f":"+CONCATENATE(A294,$B$227)","v":"65A"},64164.968524975957,59044.994464269141,80772.372143205022,74327.228325609365,null,null,null,null,null,null,null,null,null,null,null,null,null,56286.173092982543,51794.878967273587,70854.35906998979,65200.612347038492]
[66,"66A",67535.998098311713,61685.363958079259,85015.903488462965,77650.987570758603,null,null,null,null,null,null,null,null,null,null,null,null,null,59243.275051077988,54111.038357271245,74576.828593709943,68116.248285035574]
[67,"67A",71054.475424363336,64219.435767444134,89445.045534198522,80840.936789606159,null,null,null,null,null,null,null,null,null,null,null,null,null,62329.719700712463,56333.952320619319,78462.117740896836,70914.504685956083]
[68,"68A",74668.410255063354,67005.654953066405,93994.351732844443,84348.295058565971,null,null,null,null,null,null,null,null,null,null,null,null,null,65499.900659320141,58778.052566626306,82452.816124085351,73991.195583870765]
[69,"69A",78474.804887267121,69999.06273485499,98785.930858089167,88116.467207405687,null,null,null,null,null,null,null,null,null,null,null,null,null,68838.909343552965,61403.90078905705,86656.038820707836,77296.675110930635]
[70,"70A",82384.647328637846,72930.758731411857,103707.73251957941,91806.955108953742,null,null,null,null,null,null,null,null,null,null,null,null,null,72268.663514407439,63975.614796116417,90973.494071077599,80534.009213934769]
[71,"71A",86364.511471939579,76002.924281405038,108717.67914702983,95674.26938953338,null,null,null,null,null,null,null,null,null,null,null,null,null,75759.841445387661,66670.550146235153,95368.270995958577,83926.457242907767]
[72,"72A",90490.438381840591,79285.581086765509,113911.49302184641,99806.555015104808,null,null,null,null,null,null,null,null,null,null,null,null,null,79379.147143781127,69550.130599538985,99924.338169230381,87551.340872360845]
[73,"73A",94709.132727202144,82500.719818944155,119222.08472718386,103853.84730149439,null,null,null,null,null,null,null,null,null,null,null,null,null,83079.829394672866,72370.483501713621,104582.84406152938,91101.667466863015]
[74,"74A",99270.344792925986,85780.153868148802,124963.84579815391,107982.07604578734,null,null,null,null,null,null,null,null,null,null,null,null,null,87080.971727427241,75247.236920032592,109619.57617452608,94722.992358158692]
[75,"75A",103567.69036909853,89311.628756217266,130373.44552345345,112427.57972841468,null,null,null,null,null,null,null,null,null,null,null,null,null,90850.647650304993,78345.083165308475,114364.9329245016,98622.634102211858]
[76,"76A",108815.21632427,93188.417971229588,136979.1546670222,117307.77321084193,null,null,null,null,null,null,null,null,null,null,null,null,null,95453.831615208386,81745.842704623981,120159.52920973291,102903.59022817371]
[77,"77A",114421.95973624758,97346.465905295234,144037.05519739405,122542.02178666576,null,null,null,null,null,null,null,null,null,null,null,null,null,100372.1248432596,85393.325297164149,126350.79244975034,107495.12713878311]
[78,"78A",120250.54063600879,101678.19642524596,151374.20997709339,127994.90608825082,null,null,null,null,null,null,null,null,null,null,null,null,null,105485.01620675669,89193.164047855622,132787.02040144664,112278.45356612415]
[79,"79A",126648.53727011106,106023.72353766547,159428.15868119863,133465.15786506125,null,null,null,null,null,null,null,null,null,null,null,null,null,111097.40493340627,93005.105311953434,139852.02738675851,117077.01492210609]
[80,"80A",132854.79323011628,110610.82419002947,167240.7397132052,139239.50809803704,null,null,null,null,null,null,null,null,null,null,null,null,null,116541.59676041908,97028.957380288732,146705.30415723345,122142.33458459871]
[81,"81A",140145.28024459345,115258.6245223861,176418.17630789999,145090.26851641544,null,null,null,null,null,null,null,null,null,null,null,null,null,122936.88726647264,101106.05583482653,154755.84632367731,127274.6820508993]
[82,"82A",147712.20516106446,119716.60185373013,185943.59943804584,150702.07527469553,null,null,null,null,null,null,null,null,null,null,null,null,null,129574.67195523632,105016.63959236321,163111.6458730622,132197.41689862189]
[83,"83A",155597.78342173566,124793.02875481082,195870.15089559671,157092.40090311479,null,null,null,null,null,null,null,null,null,null,null,null,null,136491.98264861933,109469.73369988825,171819.31933414435,137803.07653985932]
[84,"84A",163852.46048246761,129718.46553483905,206261.33260734155,163292.65661444442,null,null,null,null,null,null,null,null,null,null,null,null,null,143733.07062150873,113790.37771378345,180934.57125295803,143242.00488676268]
[85,"85A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[86,"86A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[87,"87A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[88,"88A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[89,"89A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[90,"90A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[91,"91A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[92,"92A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[93,"93A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[94,"94A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[95,"95A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[96,"96A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[97,"97A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[98,"98A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[99,"99A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[100,"100A",172535.57767148479,134783.04015088384,217191.84483351614,169668.0623075832,null,null,null,null,null,null,null,null,null,null,null,null,null,151349.99069990686,118233.07487446332,190522.92946929453,148834.57660667738]
[]
[]
[]
[null,null,"B","Tarifa de zona 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Tarifa de zona 4"]
[null,"B","Renovada","Renovada","Nueva","Nueva",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"HOMBRES","MUJERES","HOMBRES","MUJERES"]
[0,{"$f":"+CONCATENATE(A336,$B$334)","v":"0B"},5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[1,{"$f":"+CONCATENATE(A337,$B$334)","v":"1B"},5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[2,"2B",5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[3,"3B",5775.2151256540756,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[4,"4B",5775.2151256540756,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[5,"5B",5775.2151256540756,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[6,"6B",5775.2151256540756,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[7,"7B",5775.2151256540756,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[8,"8B",5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[9,"9B",5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[10,"10B",5775.2151256540801,5799.4212124277701,5775.2151256540801,5799.4212124277701,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.1162671012671,5087.3502553248945,5066.1162671012671,5087.3502553248945]
[11,"11B",5840.5932802601892,5796.5251701417865,5840.5932802601892,5796.5251701417865,null,null,null,null,null,null,null,null,null,null,null,null,null,5123.4670887341772,5084.8097981097062,5123.4670887341772,5084.8097981097062]
[12,"12B",5818.8729631153028,5852.1533157184131,5818.8729631153028,5852.1533157184131,null,null,null,null,null,null,null,null,null,null,null,null,null,5104.4136596202543,5133.6077471181434,5104.4136596202543,5133.6077471181434]
[13,"13B",5775.7460667398427,5815.7355839721531,5775.7460667398427,5815.7355839721531,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.5820175907174,5101.661497637132,5066.5820175907174,5101.661497637132]
[14,"14B",5619.5528527823881,5702.50033059014,5619.5528527823881,5702.50033059014,null,null,null,null,null,null,null,null,null,null,null,null,null,4929.5666917848121,5002.3296205232082,4929.5666917848121,5002.3296205232082]
[15,"15B",5640.3560898700443,5609.1753679242747,5640.3560898700443,5609.1753679242747,null,null,null,null,null,null,null,null,null,null,null,null,null,4947.8156427805907,4920.4633867637149,4947.8156427805907,4920.4633867637149]
[16,"16B",5544.7625607468253,5185.7257183418378,5544.7625607468253,5185.7257183418378,null,null,null,null,null,null,null,null,null,null,null,null,null,4863.9593842025324,4549.0062009493677,4863.9593842025324,4549.0062009493677]
[17,"17B",5580.3114798072902,5270.8934952355121,5580.3114798072902,5270.8934952355121,null,null,null,null,null,null,null,null,null,null,null,null,null,4895.1434965189883,4623.7168135527427,4895.1434965189883,4623.7168135527427]
[18,"18B",5736.8184316790612,5108.3531219346069,5736.8184316790612,5108.3531219346069,null,null,null,null,null,null,null,null,null,null,null,null,null,5032.4340385232072,4481.1336523502114,5032.4340385232072,4481.1336523502114]
[19,"19B",5927.7158856969036,5183.3123497701836,5927.7158856969036,5183.3123497701836,null,null,null,null,null,null,null,null,null,null,null,null,null,5199.8925099578064,4546.8891532700427,5199.8925099578064,4546.8891532700427]
[20,"20B",6143.4227686313525,6137.9444219736961,6143.4227686313525,6137.9444219736961,null,null,null,null,null,null,null,null,null,null,null,null,null,5389.1142315358666,5384.308533303798,5389.1142315358666,5384.308533303798]
[21,"21B",6635.9912941059611,7927.3124157409429,6635.9912941059611,7927.3124157409429,null,null,null,null,null,null,null,null,null,null,null,null,null,5821.203662886076,6953.9723646624479,5821.203662886076,6953.9723646624479]
[22,"22B",6925.7644585044754,8305.2218003762664,6925.7644585044754,8305.2218003762664,null,null,null,null,null,null,null,null,null,null,null,null,null,6075.3975777426167,7285.4808607679342,6075.3975777426167,7285.4808607679342]
[23,"23B",7385.3905029760053,8692.977728783937,7385.3905029760053,8692.977728783937,null,null,null,null,null,null,null,null,null,null,null,null,null,6478.5893082700422,7625.6269114050647,6478.5893082700422,7625.6269114050647]
[24,"24B",7685.1550132611674,9099.437263621925,7685.1550132611674,9099.437263621925,null,null,null,null,null,null,null,null,null,null,null,null,null,6741.547800518988,7982.1800815569613,6741.547800518988,7982.1800815569613]
[25,"25B",7985.7883362321236,9520.7148814898737,7985.7883362321236,9520.7148814898737,null,null,null,null,null,null,null,null,null,null,null,null,null,7005.2684299324901,8351.7319244599166,7005.2684299324901,8351.7319244599166]
[26,"26B",8514.9193955672945,9890.1533424386889,8514.9193955672945,9890.1533424386889,null,null,null,null,null,null,null,null,null,null,null,null,null,7469.4311336244727,8675.8095832109702,7469.4311336244727,8675.8095832109702]
[27,"27B",8891.6703632882218,10341.984206423778,8891.6703632882218,10341.984206423778,null,null,null,null,null,null,null,null,null,null,null,null,null,7799.9234468438826,9072.163249734178,7799.9234468438826,9072.163249734178]
[28,"28B",9404.1009121075476,10824.175247040277,9404.1009121075476,10824.175247040277,null,null,null,null,null,null,null,null,null,null,null,null,null,8249.4361805949393,9495.1493760632929,8249.4361805949393,9495.1493760632929]
[29,"29B",9879.5827880948473,11310.782752142901,9879.5827880948473,11310.782752142901,null,null,null,null,null,null,null,null,null,null,null,null,null,8666.5369143755288,9922.0096996455704,8666.5369143755288,9922.0096996455704]
[30,"30B",10321.904979907617,11845.850698164344,10321.904979907617,11845.850698164344,null,null,null,null,null,null,null,null,null,null,null,null,null,9054.5494130421957,10391.380340628695,9054.5494130421957,10391.380340628695]
[31,"31B",10746.971586433063,12395.326454558557,10746.971586433063,12395.326454558557,null,null,null,null,null,null,null,null,null,null,null,null,null,9427.4250208016911,10873.389756257386,9427.4250208016911,10873.389756257386]
[32,"32B",11407.84843609483,12953.611006239307,11407.84843609483,12953.611006239307,null,null,null,null,null,null,null,null,null,null,null,null,null,10007.157357308019,11363.126395915611,10007.157357308019,11363.126395915611]
[33,"33B",11810.301779103875,13522.610914378207,11810.301779103875,13522.610914378207,null,null,null,null,null,null,null,null,null,null,null,null,null,10360.196228312236,11862.262727270045,10360.196228312236,11862.262727270045]
[34,"34B",12471.00969296563,14131.817542920864,12471.00969296563,14131.817542920864,null,null,null,null,null,null,null,null,null,null,null,null,null,10939.780371481014,12396.669072962028,10939.780371481014,12396.669072962028]
[35,"35B",13159.760949630005,14777.369502152629,13159.760949630005,14777.369502152629,null,null,null,null,null,null,null,null,null,null,null,null,null,11543.964608683544,12962.958156704643,11543.964608683544,12962.958156704643]
[36,"36B",13722.317163682585,15439.066897128761,13722.317163682585,15439.066897128761,null,null,null,null,null,null,null,null,null,null,null,null,null,12037.448422734178,13543.410289421945,12037.448422734178,13543.410289421945]
[37,"37B",14470.509688266802,16177.243942140614,14470.509688266802,16177.243942140614,null,null,null,null,null,null,null,null,null,null,null,null,null,12693.775544278482,14190.951663097048,12693.775544278482,14190.951663097048]
[38,"38B",15242.111887996067,16888.777398121405,15242.111887996067,16888.777398121405,null,null,null,null,null,null,null,null,null,null,null,null,null,13370.638028312238,14815.120830392407,13370.638028312238,14815.120830392407]
[39,"39B",16074.313772559562,17654.273775364378,16074.313772559562,17654.273775364378,null,null,null,null,null,null,null,null,null,null,null,null,null,14100.659579573841,15486.627183797469,14100.659579573841,15486.627183797469]
[40,"40B",16639.621226783835,18447.523891181379,16639.621226783835,18447.523891181379,null,null,null,null,null,null,null,null,null,null,null,null,null,14596.556827978906,16182.479585514771,14596.556827978906,16182.479585514771]
[41,"41B",17258.746800155983,19279.532706259146,17258.746800155983,19279.532706259146,null,null,null,null,null,null,null,null,null,null,null,null,null,15139.664239632915,16912.331772962025,15139.664239632915,16912.331772962025]
[42,"42B",17928.432445104292,20145.376948711506,17928.432445104292,20145.376948711506,null,null,null,null,null,null,null,null,null,null,null,null,null,15727.123800168776,17671.864968873419,15727.123800168776,17671.864968873419]
[43,"43B",18644.358231885501,21046.094367024256,18644.358231885501,21046.094367024256,null,null,null,null,null,null,null,null,null,null,null,null,null,16355.145994240511,18461.989503751054,16355.145994240511,18461.989503751054]
[44,"44B",19446.634346160481,22113.237682038296,19446.634346160481,22113.237682038296,null,null,null,null,null,null,null,null,null,null,null,null,null,17058.916154278482,19398.105646594944,17058.916154278482,19398.105646594944]
[45,"45B",20321.046047042215,22904.919108283717,20321.046047042215,22904.919108283717,null,null,null,null,null,null,null,null,null,null,null,null,null,17825.964869451484,20092.581967320679,17825.964869451484,20092.581967320679]
[46,"46B",21279.708444760385,23766.68475784998,21279.708444760385,23766.68475784998,null,null,null,null,null,null,null,null,null,null,null,null,null,18666.919719109708,20848.537352654013,18666.919719109708,20848.537352654013]
[47,"47B",22332.323280973054,24978.268181877505,22332.323280973054,24978.268181877505,null,null,null,null,null,null,null,null,null,null,null,null,null,19590.291234924054,21911.358799105488,19590.291234924054,21911.358799105488]
[48,"48B",23476.863326080034,25982.205373999914,23476.863326080034,25982.205373999914,null,null,null,null,null,null,null,null,null,null,null,null,null,20594.301096843883,22792.029463227849,20594.301096843883,22792.029463227849]
[49,"49B",24731.911518083049,27064.987317358264,24731.911518083049,27064.987317358264,null,null,null,null,null,null,null,null,null,null,null,null,null,21695.250572000001,23741.864075033762,21695.250572000001,23741.864075033762]
[50,"50B",26111.56192944057,28213.774891151352,26111.56192944057,28213.774891151352,null,null,null,null,null,null,null,null,null,null,null,null,null,22905.503218839665,24749.599940869204,22905.503218839665,24749.599940869204]
[51,"51B",27601.358482408396,29444.110188980634,27601.358482408396,29444.110188980634,null,null,null,null,null,null,null,null,null,null,null,null,null,24212.377921763717,25828.870847789036,24212.377921763717,25828.870847789036]
[52,"52B",29229.151450303398,30766.467230447084,29229.151450303398,30766.467230447084,null,null,null,null,null,null,null,null,null,null,null,null,null,25640.305410991565,26988.864782721525,25640.305410991565,26988.864782721525]
[53,"53B",30983.187728181627,32186.831169608409,30983.187728181627,32186.831169608409,null,null,null,null,null,null,null,null,null,null,null,null,null,27178.975664324898,28234.832023911396,27178.975664324898,28234.832023911396]
[54,"54B",32886.539119588102,33700.495937749889,32886.539119588102,33700.495937749889,null,null,null,null,null,null,null,null,null,null,null,null,null,28848.627657578065,29562.644328383965,28848.627657578065,29562.644328383965]
[55,"55B",34934.282352636641,35523.651091520303,34934.282352636641,35523.651091520303,null,null,null,null,null,null,null,null,null,null,null,null,null,30644.942613485237,31161.946827253174,30644.942613485237,31161.946827253174]
[56,"56B",37144.976231643275,37925.966435116265,37144.976231643275,37925.966435116265,null,null,null,null,null,null,null,null,null,null,null,null,null,32584.200628700433,33269.298428206755,32584.200628700433,33269.298428206755]
[57,"57B",39535.248866066671,39369.450445194037,39535.248866066671,39369.450445194037,null,null,null,null,null,null,null,null,null,null,null,null,null,34680.988161734182,34535.546986164562,34680.988161734182,34535.546986164562]
[58,"58B",41233.005388853933,40941.639401198139,41233.005388853933,40941.639401198139,null,null,null,null,null,null,null,null,null,null,null,null,null,36170.288863185662,35914.697696860771,36170.288863185662,35914.697696860771]
[59,"59B",43910.589551732774,41611.518115632171,43910.589551732774,41611.518115632171,null,null,null,null,null,null,null,null,null,null,null,null,null,38519.11092244304,36502.326621210974,38519.11092244304,36502.326621210974]
[60,"60B",46534.352480313632,45012.209421570507,58578.537828159511,56662.428330682887,null,null,null,null,null,null,null,null,null,null,null,null,null,40817.923153208103,39482.765036927223,51382.562086979611,49701.833634720162]
[61,"61B",49046.862494489586,46917.179196242541,61741.344551886868,59060.449105858257,null,null,null,null,null,null,null,null,null,null,null,null,null,43021.788367056004,41153.722205712205,54156.83947382342,51805.273835425956]
[62,"62B",51693.900170188492,48924.252786974612,65073.497861296077,61587.000567132753,null,null,null,null,null,null,null,null,null,null,null,null,null,45343.655432382278,42914.240429834768,57079.660367822391,54021.455599909656]
[63,"63B",54447.122810063622,51015.778602221275,68539.319302080097,64219.862475737376,null,null,null,null,null,null,null,null,null,null,null,null,null,47758.663359819089,44748.836495951859,60119.729170595798,56330.888294904107]
[64,"64B",57354.07704155441,53249.118055075625,72198.661687603788,67031.242728154029,null,null,null,null,null,null,null,null,null,null,null,null,null,50308.517996371331,46707.825356927235,63329.546183667444,58796.909566955466]
[65,{"$f":"+CONCATENATE(A401,$B$334)","v":"65B"},60318.517874730816,55505.467171235323,75930.369559955259,69871.588086143267,null,null,null,null,null,null,null,null,null,null,null,null,null,52908.797395811067,48686.99730026046,66602.839074726871,61288.337777974913]
[66,"66B",63487.466792649342,57987.556357428672,79919.51702133505,72996.100355821967,null,null,null,null,null,null,null,null,null,null,null,null,null,55688.462449982857,50864.1786783469,70101.946848801948,64029.024924507285]
[67,"67B",66795.024520207036,60369.720009071854,84083.148513672364,75994.824011419871,null,null,null,null,null,null,null,null,null,null,null,null,null,58589.709162405998,52953.709695508296,73754.104475028696,66659.37573434574]
[68,"68B",70192.31743088369,62988.91574179411,88359.740765935916,79291.929227905552,null,null,null,null,null,null,null,null,null,null,null,null,null,61569.667699824196,55251.155011561554,77505.346398602211,69551.453955730438]
[69,"69B",73770.532895471551,65802.879886760391,92864.082586064163,82834.213504510146,null,null,null,null,null,null,null,null,null,null,null,null,null,64708.323683507566,57719.442762502294,81456.360401591868,72658.592653973479]
[70,"70B",77445.994858729639,68558.831637952477,97490.840586871418,86303.470414834301,null,null,null,null,null,null,null,null,null,null,null,null,null,67932.280093608613,60136.844548455963,85514.752588424963,75701.674902173967]
[71,"71B",81187.280983935212,71446.832316535612,102200.45959154199,89938.953621991881,null,null,null,null,null,null,null,null,null,null,null,null,null,71213.974614176186,62670.073947418568,89645.826867257085,78890.563674985722]
[72,"72B",85065.873957417716,74532.70608445727,107082.92368757291,93823.524129846206,null,null,null,null,null,null,null,null,null,null,null,null,null,74616.108768748498,65376.869069856642,93928.513391248125,82297.941064407773]
[73,"73B",89031.673304450305,77555.109235970856,112075.1652185433,97628.196332339765,null,null,null,null,null,null,null,null,null,null,null,null,null,78094.736585836959,68027.990510273958,98307.49193746534,85635.235112933078]
[74,"74B",93319.457711446623,80637.953439953519,117472.72911911519,101508.95315382385,null,null,null,null,null,null,null,null,null,null,null,null,null,81855.795783906622,70732.128230138245,103042.00175150602,89039.267301468164]
[75,"75B",97359.193441222029,83957.729574141209,122558.04350836185,105687.96546391895,null,null,null,null,null,null,null,null,null,null,null,null,null,85399.277400998006,73644.092400875423,107502.61978713867,92704.916316396135]
[76,"76B",102292.14977863406,87602.119728735648,128767.76501545697,110275.60954087898,null,null,null,null,null,null,null,null,null,null,null,null,null,89726.253537257726,76840.793963091754,112949.5191586656,96728.999459421379]
[77,"77B",107562.78982551197,91510.908190734204,135402.57072152686,115196.08442833599,null,null,null,null,null,null,null,null,null,null,null,null,null,94349.431231471826,80269.414295382841,118769.28402079397,101045.02740712899]
[78,"78B",113041.96902981117,95582.967615098474,142299.89042576228,120322.08864488869,null,null,null,null,null,null,null,null,null,null,null,null,null,99155.53046318148,83841.24886059601,124819.31481835785,105541.33680098559]
[79,"79B",119056.42961801124,99667.996577647966,149871.03493090827,125464.4192212745,null,null,null,null,null,null,null,null,null,null,null,null,null,104431.15539426883,87424.459744265565,131460.39561396194,110051.96697219311]
[80,"80B",124890.64367069973,103980.11764703038,157215.2808560573,130892.61868508524,null,null,null,null,null,null,null,null,null,null,null,null,null,109548.67585321904,91206.866010944403,137902.45077993456,114813.34897848291]
[81,"81B",131744.09316825637,108349.29967688376,165842.56434121684,136392.64782854778,null,null,null,null,null,null,null,null,null,null,null,null,null,115560.22560120374,95039.323686430071,145469.93105092706,119637.73687585903]
[82,"82B",138857.40914616789,112540.03788695787,174796.97386635255,141668.04769299398,null,null,null,null,null,null,null,null,null,null,null,null,null,121799.7189964049,98715.258154120005,153324.35214841558,124265.08967636283]
[83,"83B",146270.27638826345,117312.15192069906,184128.46557110813,147675.29712370352,null,null,null,null,null,null,null,null,null,null,null,null,null,128301.96581633852,102901.15037191758,161509.53343939086,129534.38929170801]
[84,"84B",154030.11633338989,121942.32712824002,193896.73467850254,153503.87062025507,null,null,null,null,null,null,null,null,null,null,null,null,null,135108.56209798576,106962.53998483311,170077.83699393505,134646.96209855462]
[85,"85B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[86,"86B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[87,"87B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[88,"88B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[89,"89B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[90,"90B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[91,"91B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[92,"92B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[93,"93B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[94,"94B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[95,"95B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[96,"96B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[97,"97B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[98,"98B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[99,"99B",162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]
[100,{"$f":"+CONCATENATE(A436,$B$334)","v":"100B"},162192.71301837458,126703.29937724683,204172.00344665977,159497.09451018131,null,null,null,null,null,null,null,null,null,null,null,null,null,142268.43918791175,111138.65911052052,179090.85874243008,139903.95911559643]

{"sheet":"TITULAR","index":1,"n_rows":112,"n_cols":20,"rows_kept":112,"cut":false,"hidden":true,"merged":[[24,13,30,13],[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],[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,"Prima riesgo dental incremental",101,null,null,"Prima riesgo visión opcional",114.67]
[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":"CHIHUAHUA, NUEVO LEON, TAMAULIPAS"},null,null,null,null,"Gastos",0.57455000000000001,null,null,"Gastos",0.51313999999999993]
[null,"REGIÓN:",null,null,{"$f":"+COTIZACION!D15","v":4},{"$f":"IF(E3>7,\"NO PROCEDE\",\" \")","v":" "},"FACTORES",null,null,null,null,null,null,null,{"$f":"+O1/(1-O2)","v":237.39569867199435},null,null,null,{"$f":"+S1/(1-S2)","v":235.529721069712}]
[]
[null,"SUMA ASEGURADA:",null,null,{"$f":"+COTIZACION!D11","v":10000000},null,{"$f":"VLOOKUP(E5,FACTORES!$I$33:$J$124,2)","v":1.26},null,null,null,null,null,null,"Asistencias",102.24]
[null,"DEDUCIBLE:",null,null,{"$f":"+COTIZACION!D12","v":10000},null,{"$f":"VLOOKUP(E6,FACTORES!$A$2:$B$29,2,0)","v":0.88},null,null,null,null,null,null,"Gastos",0.48549999999999999]
[null,"ELIMINACION DEDUCIBLE",null,null,{"$f":"+COTIZACION!D16","v":"SI"},null,{"$f":"IF(H7=\"SI\",VLOOKUP(E6,FACTORES!I5:J18,2,0),0)","v":760.10236439499317},{"$f":"+IF(COTIZACION!D12>50000,\"NO\",COTIZACION!D16)","v":"SI"},null,null,null,null,null,null,{"$f":"+O5/(1-O6)","v":198.71720116618076}]
[null,"COASEGURO:",null,null,{"$f":"+COTIZACION!D13","v":0.1},null,{"$f":"VLOOKUP(E8,FACTORES!$C$2:$D$6,2)","v":1}]
[null,"CATALOGO:"]
[null,"SUMA ASEGURADA PARTO O CESAREA",null,null,{"$f":"+COTIZACION!D17","v":15000}]
[null,"SEGURO DE ENFERMEDADES GRAVES",null,null,{"$f":"+COTIZACION!D19","v":10000},null,{"$f":"IF(E11=\"NO\",0,IF(SUM(COTIZACION!A27:A34)>=1,VLOOKUP(E11,FACTORES!$L$33:$M$55,2,0)*(1-DESC),0))","v":0}]
[null,"COBERTURA DE VISION",null,null,{"$f":"+COTIZACION!D18","v":"SI"},null,{"$f":"IF(E12=\"NO\",0,G23)","v":235.53}]
[null,null,null,null,null,"ZONA",null,null,null,null,"Comisión",0.26500000000000001,null,null,"Comisión",0.26500000000000001,null,null,"A"]
[null,"EMERGENCIA EXTRANJERO:",null,null,null,null,null,null,null,null,"G administración",0.1,null,null,"G administración",0.1,null,null,"S"]
[null,"COBER TOTAL EXTRANJERO:",null,null,null,null,null,null,null,null,"Utilidad",0.14845,null,null,"Utilidad",0.22600000000000001]
[null,"ZONA",null,null,null,null,{"$f":"+COTIZACION!D15","v":4},null,null,null,"B"]
[null,"FORMA DE PAGO:",null,null,{"$f":"+COTIZACION!C21","v":0},null,0,null,null,null,"C",null,493.82519999999994,"PaQ Adicional",{"$f":"+SUM(O18:O31)","v":288.108},{"$f":"+P13+P14+P15","v":0.59099999999999997},617.90039999999999]
[null,"PARTO",null,null,null,0.17,{"$f":"(433.18*(1-DESC))*1.14*0+K18*(1-DESC)","v":562.98},"*BUSCARV(G16,FACTORES!$F$30:$G$35,2,0)",null,null,{"$f":"ROUND(M18,2)","v":562.98},{"$f":"240.28*1.14","v":273.91919999999999},{"$f":"L18/(1-L13-L14-L15)","v":562.98263282293692},"Legrado",0,{"$f":"1-P17","v":0.40900000000000003},null,null,493.82519999999994,{"$f":"(M18/S18)-1","v":0.14004435744254651}]
[null,"DENTAL",null,null,null,0.14000000000000001,{"$f":"288*0+181.98*0+208.25*0+K19*(1-DESC)","v":237.4},null,null,null,{"$f":"ROUND(O3,2)","v":237.4},null,{"$f":"(M18/M17)-1","v":0.14004435744254651},"Donacion de organos",48.98,null,null,null,208.25,{"$f":"(K19/S19)-1","v":0.1399759903961586}]
[null,"PAQ_ADIC",null,null,null,0.17,{"$f":"(528.12*(1-DESC))*1.17*0+K20*(1-DESC)","v":704.42},null,null,null,{"$f":"ROUND(M21,2)","v":704.42},null,null,"Donacion de organos",0,null,null,null,617.90039999999999,0.14002191939024478]
[null,"ASIST_IKE",null,null,null,0.14000000000000001,{"$f":"153.74*0+174.32*0+K21*(1-DESC)","v":198.72},"Nuevo 153.74","Anterior 125.5",null,{"$f":"ROUND(O7,2)","v":198.72},null,{"$f":"+O17/P18","v":704.42053789731051},"Renta",8.16,null,{"$f":"(M21/Q17)-1","v":0.14002278991454054},null,174.32,0.13997246443322631]
[null,"EDUCA",null,null,null,null,{"$f":"88*(1-DESC)*0","v":0},null,null,null,null,null,617.90039999999999,"Enfermedades catastroficas",0,null,null,null,0]
[null,"VISION",null,null,null,null,{"$f":"206.61*0+K23*(1-DESC)","v":235.53},null,null,null,{"$f":"ROUND(S3,2)","v":235.53},null,{"$f":"(M21/M22)-1","v":0.14002278991454054},"Transtornos",0,null,null,null,206.61,0.13997386380136478]
[null,null,null,"PRIMA BASE ",null,"PRIMA TARIFA ",null,"R P FRAC",{"$f":"G17","v":0},"PRIMA TOTAL",null,null,null,"Lente intracular",0]
[null,null,null,"REGIONALIZADA",null,"REGIONALIZADA",null,"DER POLIZA",700,"IVA",{"$f":"+COTIZACION!D20","v":0.16},null,null,"terapia",10.39]
[null,"EDAD",null,"HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER",null,null,null,13.5]
[null,0,null,{"$f":"FACTORES!F39","v":4620.18},{"$f":"FACTORES!G39","v":4639.54},{"$f":"ROUND(D27*$G$5*$G$6*$G$8,2)+ADIC+DENTAL+ENFGVES+IKE+CVISION+DEDXACC","v":7259.0323643949923},{"$f":"ROUND(E27*$G$5*$G$6*$G$8,2)+ADIC+DENTAL+ENFGVES+IKE+CVISION+DEDXACC","v":7280.4923643949924},{"$f":"(F27*(1+$I$24))+$I$25","v":7959.0323643949923},{"$f":"(G27*(1+$I$24))+$I$25","v":7980.4923643949924},{"$f":"H27*(1+$K$25)","v":9232.4775426981905},{"$f":"I27*(1+$K$25)","v":9257.3711426981899},null,null,null,13.5]
[null,{"$f":"+B27+1","v":1},null,{"$f":"FACTORES!F40","v":4620.18},{"$f":"FACTORES!G40","v":4639.54},7259.0323643949923,7280.4923643949924,{"$f":"(F28*(1+$I$24))+$I$25","v":7959.0323643949923},{"$f":"(G28*(1+$I$24))+$I$25","v":7980.4923643949924},{"$f":"H28*(1+$K$25)","v":9232.4775426981905},{"$f":"I28*(1+$K$25)","v":9257.3711426981899},null,null,null,20.5]
[null,{"$f":"+B28+1","v":2},null,{"$f":"FACTORES!F41","v":4620.18},{"$f":"FACTORES!G41","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899,null,null,null,56]
[null,3,null,{"$f":"FACTORES!F42","v":4620.18},{"$f":"FACTORES!G42","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899,null,null,null,7.8E-2]
[null,4,null,{"$f":"FACTORES!F43","v":4620.18},{"$f":"FACTORES!G43","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899,null,null,null,117]
[null,5,null,{"$f":"FACTORES!F44","v":4620.18},{"$f":"FACTORES!G44","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899]
[null,6,null,{"$f":"FACTORES!F45","v":4620.18},{"$f":"FACTORES!G45","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899]
[null,7,null,{"$f":"FACTORES!F46","v":4620.18},{"$f":"FACTORES!G46","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899]
[null,8,null,{"$f":"FACTORES!F47","v":4620.18},{"$f":"FACTORES!G47","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899]
[null,9,null,{"$f":"FACTORES!F48","v":4620.18},{"$f":"FACTORES!G48","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899]
[null,10,null,{"$f":"FACTORES!F49","v":4620.18},{"$f":"FACTORES!G49","v":4639.54},7259.0323643949923,7280.4923643949924,7959.0323643949923,7980.4923643949924,9232.4775426981905,9257.3711426981899]
[null,11,null,{"$f":"FACTORES!F50","v":4672.47},{"$f":"FACTORES!G50","v":4637.22},7317.0023643949926,7277.9223643949927,8017.0023643949926,7977.9223643949927,9299.7227426981899,9254.3899426981916]
[null,12,null,{"$f":"FACTORES!F51","v":4655.1000000000004},{"$f":"FACTORES!G51","v":4681.72},7297.7423643949924,7327.2623643949928,7997.7423643949924,8027.2623643949928,9277.3811426981902,9311.624342698191]
[null,13,null,{"$f":"FACTORES!F52","v":4620.6000000000004},{"$f":"FACTORES!G52","v":4652.59},7259.4923643949924,7294.9623643949926,7959.4923643949924,7994.9623643949926,9233.0111426981912,9274.1563426981902]
[null,14,null,{"$f":"FACTORES!F53","v":4495.6400000000003},{"$f":"FACTORES!G53","v":4562},7120.9423643949931,7194.522364394993,7820.9423643949931,7894.522364394993,9072.2931426981922,9157.645942698191]
[null,15,null,{"$f":"FACTORES!F54","v":4512.29},{"$f":"FACTORES!G54","v":4487.34},7139.4023643949922,7111.7323643949931,7839.4023643949922,7811.7323643949931,9093.7067426981903,9061.6095426981919]
[null,16,null,{"$f":"FACTORES!F55","v":4435.8100000000004},{"$f":"FACTORES!G55","v":4148.58},7054.6023643949929,6736.1223643949925,7754.6023643949929,7436.1223643949925,8995.3387426981917,8625.9019426981904]
[null,17,null,{"$f":"FACTORES!F56","v":4464.25},{"$f":"FACTORES!G56","v":4216.71},7086.1323643949927,6811.6623643949924,7786.1323643949927,7511.6623643949924,9031.9135426981902,8713.5283426981914]
[null,18,null,{"$f":"FACTORES!F57","v":4589.46},{"$f":"FACTORES!G57","v":4086.68},{"$f":"ROUND(D45*$G$5*$G$6*$G$8,2)+ADIC+DENTAL+ENFGVES+IKE+CVISION+DEDXACC","v":7224.9623643949926},{"$f":"ROUND(E45*$G$5*$G$6*$G$8,2)+ADIC+DENTAL+ENFGVES+IKE+CVISION+PARTO+DEDXACC","v":7230.4623643949935},7924.9623643949926,7930.4623643949935,9192.9563426981913,9199.3363426981923]
[null,19,null,{"$f":"FACTORES!F58","v":4742.18},{"$f":"FACTORES!G58","v":4146.6499999999996},7394.3023643949928,7296.9623643949935,8094.3023643949928,7996.9623643949935,9389.3907426981914,9276.4763426981917]
[null,20,null,{"$f":"FACTORES!F59","v":4914.74},{"$f":"FACTORES!G59","v":4910.3500000000004},7585.6323643949927,8143.7523643949926,8285.6323643949927,8843.7523643949935,9611.3335426981903,10258.752742698192]
[null,21,null,{"$f":"FACTORES!F60","v":5308.79},{"$f":"FACTORES!G60","v":6341.85},8022.562364394993,9730.9923643949933,8722.562364394993,10430.992364394993,10118.172342698192,12099.951142698192]
[null,22,null,{"$f":"FACTORES!F61","v":5540.61},{"$f":"FACTORES!G61","v":6644.18},8279.6023643949939,10066.222364394993,8979.6023643949939,10766.222364394993,10416.338742698192,12488.817942698191]
[null,23,null,{"$f":"FACTORES!F62","v":5908.31},{"$f":"FACTORES!G62","v":6954.38},8687.3023643949928,10410.172364394994,9387.3023643949928,11110.172364394994,10889.270742698191,12887.799942698191]
[null,24,null,{"$f":"FACTORES!F63","v":6148.13},{"$f":"FACTORES!G63","v":7279.55},8953.2223643949947,10770.722364394993,9653.2223643949947,11470.722364394993,11197.737942698193,13306.037942698191]
[null,25,null,{"$f":"FACTORES!F64","v":6388.63},{"$f":"FACTORES!G64","v":7616.57},9219.8823643949945,11144.402364394993,9919.8823643949945,11844.402364394993,11507.063542698193,13739.506742698191]
[null,26,null,{"$f":"FACTORES!F65","v":6811.94},{"$f":"FACTORES!G65","v":7912.12},9689.2523643949935,11472.112364394992,10389.252364394993,12172.112364394992,12051.532742698191,14119.650342698191]
[null,27,null,{"$f":"FACTORES!F66","v":7113.34},{"$f":"FACTORES!G66","v":8273.58},10023.442364394994,11872.902364394993,10723.442364394994,12572.902364394993,12439.193142698192,14584.566742698191]
[null,28,null,{"$f":"FACTORES!F67","v":7523.28},{"$f":"FACTORES!G67","v":8659.34},10477.982364394993,12300.632364394993,11177.982364394993,13000.632364394993,12966.45954269819,15080.73354269819]
[null,29,null,{"$f":"FACTORES!F68","v":7903.66},{"$f":"FACTORES!G68","v":9048.6200000000008},10899.752364394993,12732.262364394994,11599.752364394993,13432.262364394994,13455.712742698192,15581.424342698192]
[null,30,null,{"$f":"FACTORES!F69","v":8257.52},{"$f":"FACTORES!G69","v":9476.68},11292.112364394994,13206.892364394993,11992.112364394994,13906.892364394993,13910.850342698192,16131.995142698192]
[null,31,null,{"$f":"FACTORES!F70","v":8597.58},{"$f":"FACTORES!G70","v":9916.26},11669.172364394994,13694.302364394993,12369.172364394994,14394.302364394993,14348.239942698192,16697.39074269819]
[null,32,null,{"$f":"FACTORES!F71","v":9126.2800000000007},{"$f":"FACTORES!G71","v":10362.89},12255.392364394993,14189.522364394994,12955.392364394993,14889.522364394994,15028.25514269819,17271.845942698194]
[null,33,null,{"$f":"FACTORES!F72","v":9448.24},{"$f":"FACTORES!G72","v":10818.09},12612.382364394993,14694.252364394993,13312.382364394993,15394.252364394993,15442.363542698191,17857.332742698192]
[null,34,null,{"$f":"FACTORES!F73","v":9976.81},{"$f":"FACTORES!G73","v":11305.46},13198.462364394994,15234.642364394993,13898.462364394994,15934.642364394993,16122.216342698193,18484.185142698192]
[null,35,null,{"$f":"FACTORES!F74","v":10527.81},{"$f":"FACTORES!G74","v":11821.9},13809.412364394993,15807.272364394994,14509.412364394993,16507.272364394994,16830.918342698191,19148.43594269819]
[null,36,null,{"$f":"FACTORES!F75","v":10977.86},{"$f":"FACTORES!G75","v":12351.26},14308.422364394994,16394.232364394993,15008.422364394994,17094.232364394993,17409.769942698193,19829.309542698189]
[null,37,null,{"$f":"FACTORES!F76","v":11576.41},{"$f":"FACTORES!G76","v":12941.79},14972.092364394994,17049.012364394992,15672.092364394994,17749.012364394992,18179.627142698191,20588.854342698189]
[null,38,null,{"$f":"FACTORES!F77","v":12193.69},{"$f":"FACTORES!G77","v":13511.02},15656.532364394994,17680.172364394992,16356.532364394994,18380.172364394992,18973.577542698193,21320.999942698189]
[null,39,null,{"$f":"FACTORES!F78","v":12859.45},{"$f":"FACTORES!G78","v":14123.42},16394.732364394993,18359.202364394991,17094.732364394993,19059.202364394991,19829.889542698191,22108.674742698189]
[null,40,null,{"$f":"FACTORES!F79","v":13311.7},{"$f":"FACTORES!G79","v":14758.02},16896.182364394994,19062.842364394994,17596.182364394994,19762.842364394994,20411.571542698191,22924.897142698192]
[null,41,null,{"$f":"FACTORES!F80","v":13807},{"$f":"FACTORES!G80","v":15423.62},17445.372364394992,19800.86236439499,18145.372364394992,20500.86236439499,21048.63194269819,23781.000342698186]
[null,42,null,{"$f":"FACTORES!F81","v":14342.74},{"$f":"FACTORES!G81","v":16116.3},18039.402364394991,20568.902364394991,18739.402364394991,21268.902364394991,21737.706742698188,24671.92674269819]
[null,43,null,{"$f":"FACTORES!F82","v":14915.49},{"$f":"FACTORES!G82","v":16836.87},18674.472364394991,21367.872364394992,19374.472364394991,22067.872364394992,22474.387942698188,25598.731942698189]
[null,44,null,{"$f":"FACTORES!F83","v":15557.3},{"$f":"FACTORES!G83","v":17690.59},19386.102364394992,22314.482364394993,20086.102364394992,23014.482364394993,23299.878742698191,26696.799542698191]
[null,45,null,{"$f":"FACTORES!F84","v":16256.84},{"$f":"FACTORES!G84","v":18323.939999999999},20161.752364394993,23016.732364394993,20861.752364394993,23716.732364394993,24199.632742698192,27511.409542698191]
[null,46,null,{"$f":"FACTORES!F85","v":17023.77},{"$f":"FACTORES!G85","v":19013.34},21012.132364394991,23781.142364394993,21712.132364394991,24481.142364394993,25186.073542698188,28398.125142698191]
[null,47,null,{"$f":"FACTORES!F86","v":17865.86},{"$f":"FACTORES!G86","v":19982.62},21945.84236439499,24855.882364394991,22645.84236439499,25555.882364394991,26269.177142698187,29644.823542698188]
[null,48,null,{"$f":"FACTORES!F87","v":18781.490000000002},{"$f":"FACTORES!G87","v":20785.77},22961.09236439499,25746.41236439499,23661.09236439499,26446.41236439499,27446.867142698185,30677.838342698185]
[null,49,null,{"$f":"FACTORES!F88","v":19785.53},{"$f":"FACTORES!G88","v":21651.99},24074.372364394992,26706.882364394991,24774.372364394992,27406.882364394991,28738.271942698189,31791.983542698188]
[null,50,null,{"$f":"FACTORES!F89","v":20889.25},{"$f":"FACTORES!G89","v":22571.02},{"$f":"ROUND(D77*$G$5*$G$6*$G$8,2)+ADIC+DENTAL+ENFGVES+IKE+CVISION+DEDXACC","v":25298.172364394992},27725.902364394991,25998.172364394992,28425.902364394991,30157.87994269819,32974.046742698185]
[null,51,null,{"$f":"FACTORES!F90","v":22081.09},{"$f":"FACTORES!G90","v":23555.29},26619.68236439499,28817.262364394992,27319.68236439499,29517.262364394992,31690.831542698186,34240.024342698191]
[null,52,null,{"$f":"FACTORES!F91","v":23383.32},{"$f":"FACTORES!G91","v":24613.18},28063.602364394992,29990.242364394991,28763.602364394992,30690.242364394991,33365.778742698189,35600.681142698188]
[null,53,null,{"$f":"FACTORES!F92","v":24786.55},{"$f":"FACTORES!G92","v":25749.46},29619.502364394993,31250.152364394991,30319.502364394993,31950.152364394991,35170.622742698193,37062.17674269819]
[null,54,null,{"$f":"FACTORES!F93","v":26309.23},{"$f":"FACTORES!G93","v":26960.400000000001},31307.84236439499,32592.84236439499,32007.84236439499,33292.842364394994,37129.097142698185,38619.697142698191]
[null,55,null,{"$f":"FACTORES!F94","v":27947.42},{"$f":"FACTORES!G94","v":28418.92},33124.272364394994,{"$f":"ROUND(E82*$G$5*$G$6*$G$8,2)+ADIC+DENTAL+ENFGVES+IKE+CVISION+DEDXACC","v":33647.072364394997},33824.272364394994,34347.072364394997,39236.155942698191,39842.603942698195]
[null,56,null,{"$f":"FACTORES!F95","v":29715.98},{"$f":"FACTORES!G95","v":30340.78},35085.252364394997,35778.032364394996,35785.252364394997,36478.032364394996,41510.892742698197,42314.517542698195]
[null,57,null,{"$f":"FACTORES!F96","v":31628.2},{"$f":"FACTORES!G96","v":31495.56},37205.522364394994,37058.452364394994,37905.522364394994,37758.452364394994,43970.405942698191,43799.804742698194]
[null,58,null,{"$f":"FACTORES!F97","v":32986.410000000003},{"$f":"FACTORES!G97","v":32753.31},38711.502364394997,38453.042364394998,39411.502364394997,39153.042364394998,45717.342742698194,45417.529142698193]
[null,59,null,{"$f":"FACTORES!F98","v":35128.47},{"$f":"FACTORES!G98","v":33289.22},41086.622364394992,39047.262364394992,41786.622364394992,39747.262364394992,48472.481942698185,46106.824342698186]
[null,60,null,{"$f":"FACTORES!F99","v":37227.480000000003},{"$f":"FACTORES!G99","v":36009.769999999997},43414.002364394997,42063.802364394993,44114.002364394997,42763.802364394993,51172.242742698196,49606.010742698185]
[null,61,null,{"$f":"FACTORES!F100","v":39237.49},{"$f":"FACTORES!G100","v":37533.74},45642.702364394994,43753.582364394999,46342.702364394994,44453.582364394999,53757.53474269819,51566.155542698194]
[null,62,null,{"$f":"FACTORES!F101","v":41355.120000000003},{"$f":"FACTORES!G101","v":39139.4},47990.732364394993,45533.942364394992,48690.732364394993,46233.942364394992,56481.249542698191,53631.37314269819]
[null,63,null,{"$f":"FACTORES!F102","v":43557.7},{"$f":"FACTORES!G102","v":40812.620000000003},50432.952364394994,47389.202364394994,51132.952364394994,48089.202364394994,59314.224742698192,55783.474742698192]
[null,64,null,{"$f":"FACTORES!F103","v":45883.26},{"$f":"FACTORES!G103","v":42599.3},53011.532364394996,49370.272364394994,53711.532364394996,50070.272364394994,62305.377542698188,58081.515942698192]
[null,65,null,{"$f":"FACTORES!F104","v":48254.82},{"$f":"FACTORES!G104","v":44404.38},55641.112364394998,51371.752364394997,{"$f":"(F92*(1+$I$24))+$I$25","v":56341.112364394998},{"$f":"(G92*(1+$I$24))+$I$25","v":52071.752364394997},{"$f":"H92*(1+$K$25)","v":65355.690342698195},{"$f":"I92*(1+$K$25)","v":60403.232742698194}]
[null,{"$f":"+B92+1","v":66},null,{"$f":"FACTORES!F105","v":50789.98},{"$f":"FACTORES!G105","v":46390.05},58452.102364394996,53573.462364394996,59152.102364394996,54273.462364394996,68616.438742698185,62957.216342698193]
[null,67,null,{"$f":"FACTORES!F106","v":53436.02},{"$f":"FACTORES!G106","v":48295.78},61386.032364394996,55686.532364394996,62086.032364394996,56386.532364394996,72019.797542698187,65408.377542698188]
[null,68,null,{"$f":"FACTORES!F107","v":56153.86},{"$f":"FACTORES!G107","v":50391.14},64399.572364394997,58009.872364394992,65099.572364394997,58709.872364394992,75515.503942698197,68103.451942698186]
[null,69,null,{"$f":"FACTORES!F108","v":59016.42},{"$f":"FACTORES!G108","v":52642.3},67573.582364394984,60505.952364394994,68273.582364394984,61205.952364394994,79197.355542698177,70998.904742698185]
[null,70,null,{"$f":"FACTORES!F109","v":61956.79},{"$f":"FACTORES!G109","v":54847.06},70833.862364394983,62950.592364394994,71533.862364394983,63650.592364394994,82979.28034269817,73834.687142698182]
[null,71,null,{"$f":"FACTORES!F110","v":64949.82},{"$f":"FACTORES!G110","v":57157.46},74152.532364394981,65512.362364394998,74852.532364394981,66212.362364394998,86828.937542698171,76806.340342698197]
[null,72,null,{"$f":"FACTORES!F111","v":68052.7},{"$f":"FACTORES!G111","v":59626.17},77593.002364394983,68249.672364394981,78293.002364394983,68949.672364394981,90819.882742698173,79981.619942698177]
[null,73,null,{"$f":"FACTORES!F112","v":71225.34},{"$f":"FACTORES!G112","v":62044.09},81110.832364394984,70930.662364394986,81810.832364394984,71630.662364394986,94900.565542698168,83091.568342698185]
[null,74,null,{"$f":"FACTORES!F113","v":74655.570000000007},{"$f":"FACTORES!G113","v":64510.36},84914.272364394987,73665.262364394977,85614.272364394987,74365.262364394977,99312.555942698178,86263.704342698169]
[null,75,null,{"$f":"FACTORES!F114","v":77887.350000000006},{"$f":"FACTORES!G114","v":67166.179999999993},88497.662364394986,76610.032364394981,89197.662364394986,77310.032364394981,103469.28834269817,89679.637542698169]
[null,76,null,{"$f":"FACTORES!F115","v":81833.72},{"$f":"FACTORES!G115","v":70081.7},92873.402364394977,79842.762364394977,93573.402364394977,80542.762364394977,108545.14674269817,93429.604342698163]
[null,77,null,{"$f":"FACTORES!F116","v":86050.23},{"$f":"FACTORES!G116","v":73208.73},97548.672364394981,83310.012364394977,98248.672364394981,84010.012364394977,113968.45994269817,97451.614342698173]
[null,78,null,{"$f":"FACTORES!F117","v":90433.58},{"$f":"FACTORES!G117","v":76466.38},102408.92236439498,86922.092364394979,103108.92236439498,87622.092364394979,119606.34994269817,101641.62714269817]
[null,79,null,{"$f":"FACTORES!F118","v":95245.14},{"$f":"FACTORES!G118","v":79734.399999999994},107743.98236439498,90545.672364394981,108443.98236439498,91245.672364394981,125795.01954269817,105844.97994269818]
[null,80,null,{"$f":"FACTORES!F119","v":99912.51},{"$f":"FACTORES!G119","v":83184.100000000006},112919.16236439499,94370.70236439498,113619.16236439499,95070.70236439498,131798.22834269819,110282.01474269817]
[null,81,null,{"$f":"FACTORES!F120","v":105395.27},{"$f":"FACTORES!G120","v":86679.44},118998.45236439498,98246.332364394984,119698.45236439498,98946.332364394984,138850.20474269817,114777.74554269818]
[null,82,null,{"$f":"FACTORES!F121","v":111085.93},{"$f":"FACTORES!G121","v":90032.03},125308.25236439498,101963.68236439498,126008.25236439498,102663.68236439498,146169.57274269816,119089.87154269817]
[null,83,null,{"$f":"FACTORES!F122","v":117016.22},{"$f":"FACTORES!G122","v":93849.72},131883.75236439498,106196.74236439499,132583.75236439498,106896.74236439499,153797.15274269818,124000.22114269818]
[null,84,null,{"$f":"FACTORES!F123","v":123224.1},{"$f":"FACTORES!G123","v":97553.86},138767.052364395,110303.89236439498,{"$f":"(F111*(1+$I$24))+$I$25","v":139467.052364395},{"$f":"(G111*(1+$I$24))+$I$25","v":111003.89236439498},{"$f":"H111*(1+$K$25)","v":161781.78074269817},{"$f":"I111*(1+$K$25)","v":128764.51514269818}]
[null,85,null,{"$f":"FACTORES!F124","v":129754.17},{"$f":"FACTORES!G124","v":101362.64},146007.59236439501,114527.07236439498,{"$f":"(F112*(1+$I$24))+$I$25","v":146707.59236439501},{"$f":"(G112*(1+$I$24))+$I$25","v":115227.07236439498},{"$f":"H112*(1+$K$25)","v":170180.80714269821},{"$f":"I112*(1+$K$25)","v":133663.40394269818}]

{"sheet":"CONYUGE","index":2,"n_rows":106,"n_cols":15,"rows_kept":106,"cut":false,"hidden":true,"merged":[[19,1,19,2],[149,18,149,19],[149,16,149,17],[134,15,134,18],[133,15,133,22],[17,12,17,13],[1,8,7,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":"CHIHUAHUA, NUEVO LEON, TAMAULIPAS"}]
[null,"REGIÓN:",null,null,{"$f":"+COTIZACION!D15","v":4},{"$f":"IF(E3>7,\"NO PROCEDE\",\" \")","v":" "},"FACTORES"]
[]
[null,"SUMA ASEGURADA:",null,null,{"$f":"+COTIZACION!D11","v":10000000},null,{"$f":"+TITULAR!G5","v":1.26}]
[null,"DEDUCIBLE:",null,null,{"$f":"+COTIZACION!D12","v":10000},null,{"$f":"+TITULAR!G6","v":0.88}]
[null,"COASEGURO:",null,null,{"$f":"+COTIZACION!D13","v":0.1},null,{"$f":"+TITULAR!G8","v":1}]
[null,"CATALOGO:"]
[null,"SUMA ASEGURADA PARTO O CESAREA"]
[null,null,null,null,null,"ZONA",null,null,null,null,null,null,null,null,"A"]
[null,"EMERGENCIA EXTRANJERO:",null,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,"COBER TOTAL EXTRANJERO:",null,null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,null,null,null,"B"]
[null,"FORMA DE PAGO:",null,null,{"$f":"+COTIZACION!C21","v":0},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!D20","v":0.16},null,"IVA",{"$f":"+COTIZACION!D20","v":0.16}]
[null,"EDAD",null,"HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER",null,"HOMBRE","MUJER"]
[null,0,null,{"$f":"FACTORES!F39","v":4620.18},{"$f":"FACTORES!G39","v":4639.54},{"$f":"ROUND(D21*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":6498.9299999999994},{"$f":"ROUND(E21*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":6520.3899999999994},{"$f":"(F21*(1+$I$18))+$I$19","v":6498.9299999999994},{"$f":"(G21*(1+$I$18))+$I$19","v":6520.3899999999994},{"$f":"H21*(1+$K$19)","v":7538.7587999999987},{"$f":"I21*(1+$K$19)","v":7563.652399999999},null,{"$f":"(D21*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997},{"$f":"(E21*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997}]
[null,{"$f":"+B21+1","v":1},null,{"$f":"FACTORES!F40","v":4620.18},{"$f":"FACTORES!G40","v":4639.54},6498.9299999999994,6520.3899999999994,{"$f":"(F22*(1+$I$18))+$I$19","v":6498.9299999999994},{"$f":"(G22*(1+$I$18))+$I$19","v":6520.3899999999994},{"$f":"H22*(1+$K$19)","v":7538.7587999999987},{"$f":"I22*(1+$K$19)","v":7563.652399999999},null,1596.2411999999997,1596.2411999999997]
[null,{"$f":"+B22+1","v":2},null,{"$f":"FACTORES!F41","v":4620.18},{"$f":"FACTORES!G41","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,3,null,{"$f":"FACTORES!F42","v":4620.18},{"$f":"FACTORES!G42","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,4,null,{"$f":"FACTORES!F43","v":4620.18},{"$f":"FACTORES!G43","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,5,null,{"$f":"FACTORES!F44","v":4620.18},{"$f":"FACTORES!G44","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,6,null,{"$f":"FACTORES!F45","v":4620.18},{"$f":"FACTORES!G45","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,7,null,{"$f":"FACTORES!F46","v":4620.18},{"$f":"FACTORES!G46","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,8,null,{"$f":"FACTORES!F47","v":4620.18},{"$f":"FACTORES!G47","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,9,null,{"$f":"FACTORES!F48","v":4620.18},{"$f":"FACTORES!G48","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,10,null,{"$f":"FACTORES!F49","v":4620.18},{"$f":"FACTORES!G49","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999,null,1596.2411999999997,1596.2411999999997]
[null,11,null,{"$f":"FACTORES!F50","v":4672.47},{"$f":"FACTORES!G50","v":4637.22},6556.9,6517.82,6556.9,6517.82,7606.003999999999,7560.6711999999989,null,1596.2411999999997,1596.2411999999997]
[null,12,null,{"$f":"FACTORES!F51","v":4655.1000000000004},{"$f":"FACTORES!G51","v":4681.72},6537.6399999999994,6567.16,6537.6399999999994,6567.16,7583.6623999999993,7617.9055999999991,null,1596.2411999999997,1596.2411999999997]
[null,13,null,{"$f":"FACTORES!F52","v":4620.6000000000004},{"$f":"FACTORES!G52","v":4652.59},6499.3899999999994,6534.86,6499.3899999999994,6534.86,7539.2923999999985,7580.4375999999993,null,1596.2411999999997,1596.2411999999997]
[null,14,null,{"$f":"FACTORES!F53","v":4495.6400000000003},{"$f":"FACTORES!G53","v":4562},6360.84,6434.42,6360.84,6434.42,7378.5743999999995,7463.9271999999992,null,1596.2411999999997,1596.2411999999997]
[null,15,null,{"$f":"FACTORES!F54","v":4512.29},{"$f":"FACTORES!G54","v":4487.34},6379.2999999999993,6351.63,6379.2999999999993,6351.63,7399.9879999999985,7367.8907999999992,null,1596.2411999999997,1596.2411999999997]
[null,16,null,{"$f":"FACTORES!F55","v":4435.8100000000004},{"$f":"FACTORES!G55","v":4148.58},6294.5,5976.0199999999995,6294.5,5976.0199999999995,7301.62,6932.1831999999986,null,1596.2411999999997,1596.2411999999997]
[null,17,null,{"$f":"FACTORES!F56","v":4464.25},{"$f":"FACTORES!G56","v":4216.71},6326.03,6051.5599999999995,6326.03,6051.5599999999995,7338.1947999999993,7019.8095999999987,null,1596.2411999999997,1596.2411999999997]
[null,18,null,{"$f":"FACTORES!F57","v":4589.46},{"$f":"FACTORES!G57","v":4086.68},{"$f":"ROUND(D39*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":6464.86},{"$f":"ROUND(E39*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+PARTO+CVISION","v":6470.36},6464.86,6470.36,7499.2375999999995,7505.6175999999987,null,1596.2411999999997,1596.2411999999997]
[null,19,null,{"$f":"FACTORES!F58","v":4742.18},{"$f":"FACTORES!G58","v":4146.6499999999996},6634.2,6536.86,6634.2,6536.86,7695.6719999999996,7582.757599999999,null,1596.2411999999997,1596.2411999999997]
[null,20,null,{"$f":"FACTORES!F59","v":4914.74},{"$f":"FACTORES!G59","v":4910.3500000000004},6825.53,7383.6500000000005,6825.53,7383.6500000000005,7917.6147999999994,8565.0339999999997,null,1596.2411999999997,1596.2411999999997]
[null,21,null,{"$f":"FACTORES!F60","v":5308.79},{"$f":"FACTORES!G60","v":6341.85},7262.46,8970.8900000000012,7262.46,8970.8900000000012,8424.4535999999989,10406.232400000001,null,1596.2411999999997,1596.2411999999997]
[null,22,null,{"$f":"FACTORES!F61","v":5540.61},{"$f":"FACTORES!G61","v":6644.18},7519.5,9306.119999999999,7519.5,9306.119999999999,8722.619999999999,10795.099199999999,null,1596.2411999999997,1596.2411999999997]
[null,23,null,{"$f":"FACTORES!F62","v":5908.31},{"$f":"FACTORES!G62","v":6954.38},7927.2,9650.07,7927.2,9650.07,9195.5519999999997,11194.081199999999,null,1596.2411999999997,1596.2411999999997]
[null,24,null,{"$f":"FACTORES!F63","v":6148.13},{"$f":"FACTORES!G63","v":7279.55},8193.1200000000008,10010.619999999999,8193.1200000000008,10010.619999999999,9504.0192000000006,11612.319199999998,null,1596.2411999999997,1596.2411999999997]
[null,25,null,{"$f":"FACTORES!F64","v":6388.63},{"$f":"FACTORES!G64","v":7616.57},8459.7800000000007,10384.299999999999,8459.7800000000007,10384.299999999999,9813.3448000000008,12045.787999999999,null,1596.2411999999997,1596.2411999999997]
[null,26,null,{"$f":"FACTORES!F65","v":6811.94},{"$f":"FACTORES!G65","v":7912.12},8929.15,10712.009999999998,8929.15,10712.009999999998,10357.813999999998,12425.931599999998,null,1596.2411999999997,1596.2411999999997]
[null,27,null,{"$f":"FACTORES!F66","v":7113.34},{"$f":"FACTORES!G66","v":8273.58},9263.34,11112.8,9263.34,11112.8,10745.474399999999,12890.847999999998,null,1596.2411999999997,1596.2411999999997]
[null,28,null,{"$f":"FACTORES!F67","v":7523.28},{"$f":"FACTORES!G67","v":8659.34},9717.8799999999992,11540.529999999999,9717.8799999999992,11540.529999999999,11272.740799999998,13387.014799999997,null,1596.2411999999997,1596.2411999999997]
[null,29,null,{"$f":"FACTORES!F68","v":7903.66},{"$f":"FACTORES!G68","v":9048.6200000000008},10139.65,11972.16,10139.65,11972.16,11761.993999999999,13887.705599999999,null,1596.2411999999997,1596.2411999999997]
[null,30,null,{"$f":"FACTORES!F69","v":8257.52},{"$f":"FACTORES!G69","v":9476.68},10532.01,12446.789999999999,10532.01,12446.789999999999,12217.131599999999,14438.276399999997,null,1596.2411999999997,1596.2411999999997]
[null,31,null,{"$f":"FACTORES!F70","v":8597.58},{"$f":"FACTORES!G70","v":9916.26},10909.07,12934.199999999999,10909.07,12934.199999999999,12654.521199999999,15003.671999999997,null,1596.2411999999997,1596.2411999999997]
[null,32,null,{"$f":"FACTORES!F71","v":9126.2800000000007},{"$f":"FACTORES!G71","v":10362.89},11495.289999999999,13429.42,11495.289999999999,13429.42,13334.536399999997,15578.127199999999,null,{"$f":"(D53*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997},{"$f":"(E53*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997}]
[null,33,null,{"$f":"FACTORES!F72","v":9448.24},{"$f":"FACTORES!G72","v":10818.09},11852.279999999999,13934.15,11852.279999999999,13934.15,13748.644799999998,16163.613999999998,null,1596.2411999999997,1596.2411999999997]
[null,34,null,{"$f":"FACTORES!F73","v":9976.81},{"$f":"FACTORES!G73","v":11305.46},12438.36,14474.539999999999,12438.36,14474.539999999999,14428.497599999999,16790.466399999998,null,1596.2411999999997,1596.2411999999997]
[null,35,null,{"$f":"FACTORES!F74","v":10527.81},{"$f":"FACTORES!G74","v":11821.9},13049.31,15047.17,13049.31,15047.17,15137.199599999998,17454.717199999999,null,1596.2411999999997,1596.2411999999997]
[null,36,null,{"$f":"FACTORES!F75","v":10977.86},{"$f":"FACTORES!G75","v":12351.26},13548.32,15634.13,13548.32,15634.13,15716.051199999998,18135.590799999998,null,1596.2411999999997,1596.2411999999997]
[null,37,null,{"$f":"FACTORES!F76","v":11576.41},{"$f":"FACTORES!G76","v":12941.79},14211.99,16288.91,14211.99,16288.91,16485.9084,18895.135599999998,null,1596.2411999999997,1596.2411999999997]
[null,38,null,{"$f":"FACTORES!F77","v":12193.69},{"$f":"FACTORES!G77","v":13511.02},14896.43,16920.07,14896.43,16920.07,17279.858799999998,19627.281199999998,null,1596.2411999999997,1596.2411999999997]
[null,39,null,{"$f":"FACTORES!F78","v":12859.45},{"$f":"FACTORES!G78","v":14123.42},15634.63,17599.099999999999,15634.63,17599.099999999999,18136.170799999996,20414.955999999998,null,1596.2411999999997,1596.2411999999997]
[null,40,null,{"$f":"FACTORES!F79","v":13311.7},{"$f":"FACTORES!G79","v":14758.02},16136.08,18302.740000000002,16136.08,18302.740000000002,18717.852799999997,21231.178400000001,null,1596.2411999999997,1596.2411999999997]
[null,41,null,{"$f":"FACTORES!F80","v":13807},{"$f":"FACTORES!G80","v":15423.62},16685.27,19040.759999999998,16685.27,19040.759999999998,19354.913199999999,22087.281599999998,null,1596.2411999999997,1596.2411999999997]
[null,42,null,{"$f":"FACTORES!F81","v":14342.74},{"$f":"FACTORES!G81","v":16116.3},17279.3,19808.8,17279.3,19808.8,20043.987999999998,22978.207999999999,null,1596.2411999999997,1596.2411999999997]
[null,43,null,{"$f":"FACTORES!F82","v":14915.49},{"$f":"FACTORES!G82","v":16836.87},17914.37,20607.77,17914.37,20607.77,20780.669199999997,23905.013199999998,null,1596.2411999999997,1596.2411999999997]
[null,44,null,{"$f":"FACTORES!F83","v":15557.3},{"$f":"FACTORES!G83","v":17690.59},18626,21554.38,18626,21554.38,21606.16,25003.0808,null,1596.2411999999997,1596.2411999999997]
[null,45,null,{"$f":"FACTORES!F84","v":16256.84},{"$f":"FACTORES!G84","v":18323.939999999999},19401.650000000001,22256.63,19401.650000000001,22256.63,22505.914000000001,25817.6908,null,1596.2411999999997,1596.2411999999997]
[null,46,null,{"$f":"FACTORES!F85","v":17023.77},{"$f":"FACTORES!G85","v":19013.34},20252.03,23021.040000000001,20252.03,23021.040000000001,23492.354799999997,26704.4064,null,1596.2411999999997,1596.2411999999997]
[null,47,null,{"$f":"FACTORES!F86","v":17865.86},{"$f":"FACTORES!G86","v":19982.62},21185.739999999998,24095.78,21185.739999999998,24095.78,24575.458399999996,27951.104799999997,null,1596.2411999999997,1596.2411999999997]
[null,48,null,{"$f":"FACTORES!F87","v":18781.490000000002},{"$f":"FACTORES!G87","v":20785.77},22200.989999999998,24986.309999999998,22200.989999999998,24986.309999999998,25753.148399999995,28984.119599999995,null,1596.2411999999997,1596.2411999999997]
[null,49,null,{"$f":"FACTORES!F88","v":19785.53},{"$f":"FACTORES!G88","v":21651.99},23314.27,25946.78,23314.27,25946.78,27044.553199999998,30098.264799999997,null,1596.2411999999997,1596.2411999999997]
[null,50,null,{"$f":"FACTORES!F89","v":20889.25},{"$f":"FACTORES!G89","v":22571.02},{"$f":"ROUND(D71*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":24538.07},26965.8,24538.07,26965.8,28464.161199999999,31280.327999999998,null,1596.2411999999997,1596.2411999999997]
[null,51,null,{"$f":"FACTORES!F90","v":22081.09},{"$f":"FACTORES!G90","v":23555.29},25859.579999999998,28057.16,25859.579999999998,28057.16,29997.112799999995,32546.305599999996,null,1596.2411999999997,1596.2411999999997]
[null,52,null,{"$f":"FACTORES!F91","v":23383.32},{"$f":"FACTORES!G91","v":24613.18},27303.5,29230.14,27303.5,29230.14,31672.059999999998,33906.962399999997,null,1596.2411999999997,1596.2411999999997]
[null,53,null,{"$f":"FACTORES!F92","v":24786.55},{"$f":"FACTORES!G92","v":25749.46},28859.4,30490.05,28859.4,30490.05,33476.904000000002,35368.457999999999,null,1596.2411999999997,1596.2411999999997]
[null,54,null,{"$f":"FACTORES!F93","v":26309.23},{"$f":"FACTORES!G93","v":26960.400000000001},30547.739999999998,31832.739999999998,30547.739999999998,31832.739999999998,35435.378399999994,36925.978399999993,null,1596.2411999999997,1596.2411999999997]
[null,55,null,{"$f":"FACTORES!F94","v":27947.42},{"$f":"FACTORES!G94","v":28418.92},32364.17,{"$f":"ROUND(E76*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":32886.97},32364.17,32886.97,37542.437199999993,38148.885199999997,null,1596.2411999999997,1596.2411999999997]
[null,56,null,{"$f":"FACTORES!F95","v":29715.98},{"$f":"FACTORES!G95","v":30340.78},34325.15,35017.93,34325.15,35017.93,39817.173999999999,40620.798799999997,null,1596.2411999999997,1596.2411999999997]
[null,57,null,{"$f":"FACTORES!F96","v":31628.2},{"$f":"FACTORES!G96","v":31495.56},36445.42,36298.35,36445.42,36298.35,42276.687199999993,42106.085999999996,null,1596.2411999999997,1596.2411999999997]
[null,58,null,{"$f":"FACTORES!F97","v":32986.410000000003},{"$f":"FACTORES!G97","v":32753.31},37951.4,37692.94,37951.4,37692.94,44023.623999999996,43723.810400000002,null,1596.2411999999997,1596.2411999999997]
[null,59,null,{"$f":"FACTORES!F98","v":35128.47},{"$f":"FACTORES!G98","v":33289.22},40326.519999999997,38287.159999999996,40326.519999999997,38287.159999999996,46778.763199999994,44413.105599999995,null,1596.2411999999997,1596.2411999999997]
[null,60,null,{"$f":"FACTORES!F99","v":37227.480000000003},{"$f":"FACTORES!G99","v":36009.769999999997},42653.9,41303.699999999997,42653.9,41303.699999999997,49478.523999999998,47912.291999999994,null,1596.2411999999997,1596.2411999999997]
[null,61,null,{"$f":"FACTORES!F100","v":39237.49},{"$f":"FACTORES!G100","v":37533.74},44882.6,42993.48,44882.6,42993.48,52063.815999999992,49872.436800000003,null,1596.2411999999997,1596.2411999999997]
[null,62,null,{"$f":"FACTORES!F101","v":41355.120000000003},{"$f":"FACTORES!G101","v":39139.4},47230.63,44773.84,47230.63,44773.84,54787.530799999993,51937.654399999992,null,1596.2411999999997,1596.2411999999997]
[null,63,null,{"$f":"FACTORES!F102","v":43557.7},{"$f":"FACTORES!G102","v":40812.620000000003},49672.85,46629.1,49672.85,46629.1,57620.505999999994,54089.755999999994,null,1596.2411999999997,1596.2411999999997]
[null,64,null,{"$f":"FACTORES!F103","v":45883.26},{"$f":"FACTORES!G103","v":42599.3},52251.43,48610.17,52251.43,48610.17,60611.658799999997,56387.797199999994,null,{"$f":"(D85*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997},{"$f":"(E85*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997}]
[null,65,null,{"$f":"FACTORES!F104","v":48254.82},{"$f":"FACTORES!G104","v":44404.38},54881.01,50611.65,{"$f":"(F86*(1+$I$18))+$I$19","v":54881.01},{"$f":"(G86*(1+$I$18))+$I$19","v":50611.65},{"$f":"H86*(1+$K$19)","v":63661.971599999997},{"$f":"I86*(1+$K$19)","v":58709.513999999996},null,1596.2411999999997,1596.2411999999997]
[null,{"$f":"+B86+1","v":66},null,{"$f":"FACTORES!F105","v":50789.98},{"$f":"FACTORES!G105","v":46390.05},57692,52813.36,57692,52813.36,66922.720000000001,61263.497599999995,null,1596.2411999999997,1596.2411999999997]
[null,67,null,{"$f":"FACTORES!F106","v":53436.02},{"$f":"FACTORES!G106","v":48295.78},60625.93,54926.43,60625.93,54926.43,70326.078799999988,63714.658799999997,null,1596.2411999999997,1596.2411999999997]
[null,68,null,{"$f":"FACTORES!F107","v":56153.86},{"$f":"FACTORES!G107","v":50391.14},63639.47,57249.77,63639.47,57249.77,73821.785199999998,66409.733199999988,null,1596.2411999999997,1596.2411999999997]
[null,69,null,{"$f":"FACTORES!F108","v":59016.42},{"$f":"FACTORES!G108","v":52642.3},66813.48,59745.85,66813.48,59745.85,77503.636799999993,69305.185999999987,null,1596.2411999999997,1596.2411999999997]
[null,70,null,{"$f":"FACTORES!F109","v":61956.79},{"$f":"FACTORES!G109","v":54847.06},70073.759999999995,62190.49,70073.759999999995,62190.49,81285.561599999986,72140.968399999998,null,1596.2411999999997,1596.2411999999997]
[null,71,null,{"$f":"FACTORES!F110","v":64949.82},{"$f":"FACTORES!G110","v":57157.46},73392.429999999993,64752.26,73392.429999999993,64752.26,85135.218799999988,75112.621599999999,null,1596.2411999999997,1596.2411999999997]
[null,72,null,{"$f":"FACTORES!F111","v":68052.7},{"$f":"FACTORES!G111","v":59626.17},76832.899999999994,67489.569999999992,76832.899999999994,67489.569999999992,89126.16399999999,78287.901199999993,null,1596.2411999999997,1596.2411999999997]
[null,73,null,{"$f":"FACTORES!F112","v":71225.34},{"$f":"FACTORES!G112","v":62044.09},80350.73,70170.559999999998,80350.73,70170.559999999998,93206.846799999985,81397.849599999987,null,1596.2411999999997,1596.2411999999997]
[null,74,null,{"$f":"FACTORES!F113","v":74655.570000000007},{"$f":"FACTORES!G113","v":64510.36},84154.17,72905.159999999989,84154.17,72905.159999999989,97618.837199999994,84569.985599999985,null,1596.2411999999997,1596.2411999999997]
[null,75,null,{"$f":"FACTORES!F114","v":77887.350000000006},{"$f":"FACTORES!G114","v":67166.179999999993},87737.56,75849.929999999993,87737.56,75849.929999999993,101775.56959999999,87985.918799999985,null,1596.2411999999997,1596.2411999999997]
[null,76,null,{"$f":"FACTORES!F115","v":81833.72},{"$f":"FACTORES!G115","v":70081.7},92113.299999999988,79082.659999999989,92113.299999999988,79082.659999999989,106851.42799999999,91735.88559999998,null,1596.2411999999997,1596.2411999999997]
[null,77,null,{"$f":"FACTORES!F116","v":86050.23},{"$f":"FACTORES!G116","v":73208.73},96788.569999999992,82549.909999999989,96788.569999999992,82549.909999999989,112274.74119999999,95757.895599999974,null,1596.2411999999997,1596.2411999999997]
[null,78,null,{"$f":"FACTORES!F117","v":90433.58},{"$f":"FACTORES!G117","v":76466.38},101648.81999999999,86161.989999999991,101648.81999999999,86161.989999999991,117912.63119999999,99947.908399999986,null,1596.2411999999997,1596.2411999999997]
[null,79,null,{"$f":"FACTORES!F118","v":95245.14},{"$f":"FACTORES!G118","v":79734.399999999994},106983.87999999999,89785.569999999992,106983.87999999999,89785.569999999992,124101.30079999998,104151.26119999998,null,1596.2411999999997,1596.2411999999997]
[null,80,null,{"$f":"FACTORES!F119","v":99912.51},{"$f":"FACTORES!G119","v":83184.100000000006},112159.06,93610.599999999991,112159.06,93610.599999999991,130104.50959999999,108588.29599999999,null,1596.2411999999997,1596.2411999999997]
[null,81,null,{"$f":"FACTORES!F120","v":105395.27},{"$f":"FACTORES!G120","v":86679.44},118238.34999999999,97486.23,118238.34999999999,97486.23,137156.48599999998,113084.02679999999,null,1596.2411999999997,1596.2411999999997]
[null,82,null,{"$f":"FACTORES!F121","v":111085.93},{"$f":"FACTORES!G121","v":90032.03},124548.15,101203.57999999999,124548.15,101203.57999999999,144475.85399999999,117396.15279999998,null,1596.2411999999997,1596.2411999999997]
[null,83,null,{"$f":"FACTORES!F122","v":117016.22},{"$f":"FACTORES!G122","v":93849.72},131123.65,105436.64,131123.65,105436.64,152103.43399999998,122306.5024,null,1596.2411999999997,1596.2411999999997]
[null,84,null,{"$f":"FACTORES!F123","v":123224.1},{"$f":"FACTORES!G123","v":97553.86},138006.95000000001,109543.79,{"$f":"(F105*(1+$I$18))+$I$19","v":138006.95000000001},{"$f":"(G105*(1+$I$18))+$I$19","v":109543.79},{"$f":"H105*(1+$K$19)","v":160088.06200000001},{"$f":"I105*(1+$K$19)","v":127070.79639999998},null,{"$f":"(D105*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997},{"$f":"(E105*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997}]
[null,85,null,{"$f":"FACTORES!F124","v":129754.17},{"$f":"FACTORES!G124","v":101362.64},145247.49000000002,113766.96999999999,{"$f":"(F106*(1+$I$18))+$I$19","v":145247.49000000002},{"$f":"(G106*(1+$I$18))+$I$19","v":113766.96999999999},{"$f":"H106*(1+$K$19)","v":168487.08840000001},{"$f":"I106*(1+$K$19)","v":131969.68519999998},null,{"$f":"(D106*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997},{"$f":"(E106*$G$5*$G$6*$G$7*$G$11*$G$12*$G$8+(ADIC+DENTAL+CVISION+IKE)*(1-DESC))*(1+IVA)","v":1596.2411999999997}]

{"sheet":"DEPENDIENTE","index":3,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":true,"merged":[[28,17,29,18],[1,8,7,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],[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":"CHIHUAHUA, NUEVO LEON, TAMAULIPAS"}]
[null,"REGIÓN:",null,null,{"$f":"+COTIZACION!D15","v":4},{"$f":"IF(E3>7,\"NO PROCEDE\",\" \")","v":" "},"FACTORES"]
[]
[null,"SUMA ASEGURADA:",null,null,{"$f":"+COTIZACION!D11","v":10000000},null,{"$f":"+TITULAR!G5","v":1.26}]
[null,"DEDUCIBLE:",null,null,{"$f":"+COTIZACION!D12","v":10000},null,{"$f":"+TITULAR!G6","v":0.88}]
[null,"COASEGURO:",null,null,{"$f":"+COTIZACION!D13","v":0.1},null,{"$f":"+TITULAR!G8","v":1}]
[null,"CATALOGO:"]
[null,null,null,null,null,"ZONA",null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,"EMERGENCIA EXTRANJERO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,"COBER TOTAL EXTRANJERO:",null,null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,null,null,null,"B"]
[null,"FORMA DE PAGO:",null,null,{"$f":"+COTIZACION!C21","v":0},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!D20","v":0.16}]
[null,"EDAD",null,"HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER","HOMBRE","MUJER"]
[null,0,null,{"$f":"FACTORES!F39","v":4620.18},{"$f":"FACTORES!G39","v":4639.54},{"$f":"ROUND(D21*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":6498.9299999999994},{"$f":"ROUND(E21*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":6520.3899999999994},{"$f":"(F21*(1+$I$18))+$I$19","v":6498.9299999999994},{"$f":"(G21*(1+$I$18))+$I$19","v":6520.3899999999994},{"$f":"H21*(1+$K$19)","v":7538.7587999999987},{"$f":"I21*(1+$K$19)","v":7563.652399999999}]
[null,{"$f":"+B21+1","v":1},null,{"$f":"FACTORES!F40","v":4620.18},{"$f":"FACTORES!G40","v":4639.54},6498.9299999999994,6520.3899999999994,{"$f":"(F22*(1+$I$18))+$I$19","v":6498.9299999999994},{"$f":"(G22*(1+$I$18))+$I$19","v":6520.3899999999994},{"$f":"H22*(1+$K$19)","v":7538.7587999999987},{"$f":"I22*(1+$K$19)","v":7563.652399999999}]
[null,{"$f":"+B22+1","v":2},null,{"$f":"FACTORES!F41","v":4620.18},{"$f":"FACTORES!G41","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,3,null,{"$f":"FACTORES!F42","v":4620.18},{"$f":"FACTORES!G42","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,4,null,{"$f":"FACTORES!F43","v":4620.18},{"$f":"FACTORES!G43","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,5,null,{"$f":"FACTORES!F44","v":4620.18},{"$f":"FACTORES!G44","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,6,null,{"$f":"FACTORES!F45","v":4620.18},{"$f":"FACTORES!G45","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,7,null,{"$f":"FACTORES!F46","v":4620.18},{"$f":"FACTORES!G46","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,8,null,{"$f":"FACTORES!F47","v":4620.18},{"$f":"FACTORES!G47","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,9,null,{"$f":"FACTORES!F48","v":4620.18},{"$f":"FACTORES!G48","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,10,null,{"$f":"FACTORES!F49","v":4620.18},{"$f":"FACTORES!G49","v":4639.54},6498.9299999999994,6520.3899999999994,6498.9299999999994,6520.3899999999994,7538.7587999999987,7563.652399999999]
[null,11,null,{"$f":"FACTORES!F50","v":4672.47},{"$f":"FACTORES!G50","v":4637.22},6556.9,6517.82,6556.9,6517.82,7606.003999999999,7560.6711999999989]
[null,12,null,{"$f":"FACTORES!F51","v":4655.1000000000004},{"$f":"FACTORES!G51","v":4681.72},6537.6399999999994,6567.16,6537.6399999999994,6567.16,7583.6623999999993,7617.9055999999991]
[null,13,null,{"$f":"FACTORES!F52","v":4620.6000000000004},{"$f":"FACTORES!G52","v":4652.59},6499.3899999999994,6534.86,6499.3899999999994,6534.86,7539.2923999999985,7580.4375999999993]
[null,14,null,{"$f":"FACTORES!F53","v":4495.6400000000003},{"$f":"FACTORES!G53","v":4562},6360.84,6434.42,6360.84,6434.42,7378.5743999999995,7463.9271999999992]
[null,15,null,{"$f":"FACTORES!F54","v":4512.29},{"$f":"FACTORES!G54","v":4487.34},6379.2999999999993,6351.63,6379.2999999999993,6351.63,7399.9879999999985,7367.8907999999992]
[null,16,null,{"$f":"FACTORES!F55","v":4435.8100000000004},{"$f":"FACTORES!G55","v":4148.58},6294.5,5976.0199999999995,6294.5,5976.0199999999995,7301.62,6932.1831999999986]
[null,17,null,{"$f":"FACTORES!F56","v":4464.25},{"$f":"FACTORES!G56","v":4216.71},6326.03,6051.5599999999995,6326.03,6051.5599999999995,7338.1947999999993,7019.8095999999987]
[null,18,null,{"$f":"FACTORES!F57","v":4589.46},{"$f":"FACTORES!G57","v":4086.68},{"$f":"ROUND(D39*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+CVISION","v":6464.86},{"$f":"ROUND(E39*$G$5*$G$6*$G$7,2)+ADIC+DENTAL+IKE+PARTO+CVISION","v":6470.36},6464.86,6470.36,7499.2375999999995,7505.6175999999987]
[null,19,null,{"$f":"FACTORES!F58","v":4742.18},{"$f":"FACTORES!G58","v":4146.6499999999996},6634.2,6536.86,6634.2,6536.86,7695.6719999999996,7582.757599999999]
[null,20,null,{"$f":"FACTORES!F59","v":4914.74},{"$f":"FACTORES!G59","v":4910.3500000000004},6825.53,7383.6500000000005,6825.53,7383.6500000000005,7917.6147999999994,8565.0339999999997]
[null,21,null,{"$f":"FACTORES!F60","v":5308.79},{"$f":"FACTORES!G60","v":6341.85},7262.46,8970.8900000000012,7262.46,8970.8900000000012,8424.4535999999989,10406.232400000001]
[null,22,null,{"$f":"FACTORES!F61","v":5540.61},{"$f":"FACTORES!G61","v":6644.18},7519.5,9306.119999999999,7519.5,9306.119999999999,8722.619999999999,10795.099199999999]
[null,23,null,{"$f":"FACTORES!F62","v":5908.31},{"$f":"FACTORES!G62","v":6954.38},7927.2,9650.07,7927.2,9650.07,9195.5519999999997,11194.081199999999]
[null,24,null,{"$f":"FACTORES!F63","v":6148.13},{"$f":"FACTORES!G63","v":7279.55},8193.1200000000008,10010.619999999999,8193.1200000000008,10010.619999999999,9504.0192000000006,11612.319199999998]

{"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, PUEBLA, QUINTANA ROO, TABASCO, TLAXCALA, VERACRUZ, YUCATAN"]
[2,"HIDALGO, NAYARIT"]
[3,"AGUASCALIENTES, COAHUILA, COLIMA, DURANGO, GUANAJUATO, JALISCO, MICHOACAN, ZACATECAS"]
[4,"CHIHUAHUA, NUEVO LEON, TAMAULIPAS"]
[5,"BAJA CALIFORNIA, BAJA CALIFORNIA SUR, MORELOS, 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-01-26"}]
[]
[null,null,null,null,null,null,null,null,"REGIÓN",{"$f":"TITULAR!E3","v":4}]
[]
[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!S26","v":0}]
[null,null,null,null,null,"Accidente",null,0]
[]
[null,{"$f":"+COTIZACION!L29","v":0},{"$f":"+COTIZACION!M29","v":0},null,null,null,null,{"$f":"+TITULAR!E9","v":0}]
[null,{"$f":"+COTIZACION!L30","v":0},{"$f":"+COTIZACION!M30","v":0},null,null,null,null,{"$f":"+COTIZACION!R30","v":0},{"$f":"+COTIZACION!S30","v":0}]
[]
[]
[null,{"$f":"+COTIZACION!L33","v":0},{"$f":"+COTIZACION!M33","v":0},null,null,null,null,{"$f":"+COTIZACION!R33","v":0}]
[null,{"$f":"+COTIZACION!L34","v":0},{"$f":"+COTIZACION!M34","v":0},null,null,null,null,{"$f":"+COTIZACION!R34","v":0}]
[null,{"$f":"+COTIZACION!L35","v":0},{"$f":"+COTIZACION!M35","v":0},null,null,null,null,{"$f":"+COTIZACION!R35","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,{"$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,null,null,{"$f":"+COTIZACION!R40","v":0}]
[null,{"$f":"+COTIZACION!L41","v":0},{"$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,{"$f":"+COTIZACION!M46","v":0},null,null,null,null,{"$f":"FACTORES!D37","v":15000}]
[null,{"$f":"+COTIZACION!L47","v":0},{"$f":"+COTIZACION!M47","v":0}]
[null,null,{"$f":"+COTIZACION!M48","v":0},null,null,null,null,{"$f":"+COTIZACION!R48","v":0}]
[null,{"$f":"+COTIZACION!L49","v":0},{"$f":"+COTIZACION!M49","v":0}]
[null,null,{"$f":"+COTIZACION!M50","v":0},null,null,null,null,{"$f":"+COTIZACION!R50","v":0}]
[null,{"$f":"+COTIZACION!L51","v":0},{"$f":"+COTIZACION!M51","v":0},null,null,null,null,{"$f":"+COTIZACION!R51","v":0}]
[null,null,{"$f":"+COTIZACION!M52","v":0}]
[null,{"$f":"+COTIZACION!L53","v":0},{"$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,{"$f":"+COTIZACION!M55","v":0}]
[null,null,{"$f":"+COTIZACION!M56","v":0}]
[null,null,{"$f":"+COTIZACION!M57","v":0}]
[null,null,{"$f":"+COTIZACION!M58","v":0},null,null,null,null,{"$f":"+COTIZACION!R58","v":0}]
[null,{"$f":"+COTIZACION!L59","v":0},{"$f":"+COTIZACION!M59","v":0},null,null,null,null,{"$f":"+COTIZACION!R59","v":0}]
[null,{"$f":"+COTIZACION!L60","v":0},{"$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,null,null,{"$f":"+COTIZACION!R66","v":0}]
[null,{"$f":"+COTIZACION!L67","v":0},{"$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,"-","En atención en Hospiten aplica deducible y coaseguro "]

{"sheet":"COTIZACION","index":6,"n_rows":363,"n_cols":13,"rows_kept":363,"cut":false,"hidden":true,"merged":[[40,1,40,5],[36,8,38,9],[38,2,38,4],[1,1,1,2],[2,1,2,2],[31,8,31,9],[16,1,16,2],[6,1,6,3]]}
[]
[]
[]
[]
[]
[]
[null,"DATOS DE LA PÓLIZA"]
[null,"Tipo de Póliza",null,"RENOVADA",{"$f":"+IF(AND(D8=\"NUEVA\",D9=\"ANTES DEL 01/10/2016\"),\"NO ES VÁLIDA, RECONSIDERAR SU PRIMERA EMISIÓN\",CONCATENATE(\"APLICA PARA AQUELLA PÓLIZA \",D8,\" CON PRIMER VIGENCIA EMITIDA \",D9))","v":"APLICA PARA AQUELLA PÓLIZA RENOVADA CON PRIMER VIGENCIA EMITIDA ANTES DEL 01/10/2016"}]
[null,"Primera vigencia emitida en Seguros Banorte",null,"ANTES DEL 01/10/2016",{"$f":"+IF(IFERROR(FACTORES!A37,\"VALIDAR INICIO DE VIGENCIA\")=0,\"\",\"VALIDAR INICIO DE VIGENCIA\")","v":"VALIDAR INICIO DE VIGENCIA"}]
[null,"TIPO DE COTIZACIÓN",null,"INDIVIDUAL"]
[null,"Suma Asegurada",null,10000000]
[null,"Deducible",null,10000,{"$f":"+IF(D8=\"NUEVA \",IF(D12<10000,\"Deducible no permitido para pólizas nuevas\",\"\"),\"\")","v":""}]
[null,{"$f":"+CONCATENATE(\"Coaseguro con tope a \",VLOOKUP(D13,FACTORES!C16:D20,2,FALSE))","v":"Coaseguro con tope a $30,000"},null,0.1]
[null,"Estado",null,"NUEVO LEÓN"]
[null,"Región",null,{"$f":"+VLOOKUP(D14,C310:D341,2,0)","v":4}]
[null,"Eliminación de deducible por accidente",null,"SI"]
[null,"Suma Asegurada Parto o Cesárea",null,15000]
[null,"Cobertura de Visión Incremental",null,"SI"]
[null,"Cobertura de Indemnización por Enfermedad Grave",null,10000,{"$f":"IF(AND(D19<>\"NO\",SUM(A27:A34)<1),\"NO CUMPLE CON LOS LIMITES DE EDAD\",\"\")","v":"NO CUMPLE CON LOS LIMITES DE EDAD"}]
[null,"IVA",null,0.16]
[null,null,null,null,null,null,null,"DESCUENTO",null,null,null,null,"DESCUENTO"]
[]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[]
[]
[null,"ASEGURADO","NOMBRE","SEXO","EDAD",null,"Forma de Pago","Primer Recibo","Recibos Subsecuentes","Total"]
[{"$f":"IF($D$8=\"NUEVA \",IF(AND(E27>=18,E27<60),1,0),IF(AND(E27>=18,E27<65),1,0))","v":0},"Titular",null,"H",0,{"$f":"IF(AND(D8=\"NUEVA \",D12<10000),\"DEDUCIBLE INVÁLIDO\",IF(D8=\"NUEVA \",IF(E27>64,\"EDAD NO PERMITIDA\",IF(D10=\"FAMILIAR\",IF(E27<18,\"EDAD NO PERMIDITA\",\"\"),\"\")),IF(D10=\"FAMILIAR\",IF(E27<18,\"EDAD NO PERMIDITA\",\"\"),\"\")))","v":""},"ANUAL",{"$f":"+IMPRESION!K86","v":9232.4775426981905},0,{"$f":"+H27","v":9232.4775426981905}]
[{"$f":"IF($D$8=\"NUEVA \",IF(AND(E28>=18,E28<60),1,0),IF(AND(E28>=18,E28<65),1,0))","v":0},{"$f":"IF(D10=\"FAMILIAR\",\"Cónyuge\",\"\")","v":""},null,null,null,{"$f":"IF($D$8=\"NUEVA \",IF(E28>64,\"EDAD NO PERMITIDA\",\" \"),\" \")","v":" "},"SEMESTRAL",{"$f":"IF((IMPRESION!K81*RSEM/2+DER)*(1+$D$20)<1000,0,(IMPRESION!K81*RSEM/2+DER)*(1+$D$20))","v":5221.3830652339066},{"$f":"IF(H28=0,0,(IMPRESION!K81*RSEM/2)*(1+$D$20))","v":4409.3830652339075},{"$f":"+I28+H28","v":9630.7661304678149}]
[0,{"$f":"IF($D$10=\"FAMILIAR\",\"Dependiente 1\",\"\")","v":""},null,null,null,{"$f":"IF($D$8=\"NUEVA \",IF(E29>69,\"EDAD NO PERMITIDA\",\" \"),\" \")","v":" "},"TRIMESTRAL",{"$f":"IF((IMPRESION!K81*RTRIM/4+DER)*(1+$D$20)<1000,0,(IMPRESION!K81*RTRIM/4+DER)*(1+$D$20))","v":3064.2672307331982},{"$f":"IF(H29=0,0,(IMPRESION!K81*RTRIM/4)*(1+$D$20))","v":2252.2672307331986},{"$f":"+I29*3+H29","v":9821.0689229327945}]
[0,{"$f":"IF($D$10=\"FAMILIAR\",\"Dependiente 2\",\"\")","v":""},null,null,null," ","MENSUAL",{"$f":"IF((IMPRESION!K81*RMES/12+DER)*(1+$D$20)<1000,0,(IMPRESION!K81*RMES/12+DER)*(1+$D$20))","v":1583.8069374344784},{"$f":"IF(H30=0,0,(IMPRESION!K81*RMES/12)*(1+$D$20))","v":771.80693743447841},{"$f":"+I30*11+H30","v":10073.68324921374}]
[0,{"$f":"IF($D$10=\"FAMILIAR\",\"Dependiente 3\",\"\")","v":""},null,null,null," "]
[0,{"$f":"IF($D$10=\"FAMILIAR\",\"Dependiente 4\",\"\")","v":""},null,null,null," "]
[0,{"$f":"IF($D$10=\"FAMILIAR\",\"Dependiente 5\",\"\")","v":""},null,null,null," "]
[0,{"$f":"IF($D$10=\"FAMILIAR\",\"Dependiente 6\",\"\")","v":""},null,null,null," ","RECARGOS POR PAGO FRACCIONADO"]
[null,null,null,null,null,null,"Forma de Pago","%"]
[null,"AGENTE",null,null,null,null,"SEMESTRAL",4.7300000000000002E-2]
[null,null,null,null,null,null,"TRIMESTRAL",6.9900000000000004E-2,"FAVOR de Verificar si estos factores son los vigentes"]
[null,null,null,null,null,null,"MENSUAL",9.9900000000000003E-2]
[null,"Agente"]
[]
[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,null,"FORMA DE PAGO",null,null,"FP"]
[null,null,3500]
[null,null,4000,null,null,null,null,"A",{"$f":"IF(H27=0,\"NO APLICA\",\"ANUAL\")","v":"ANUAL"},null,{"$f":"IF(C21=\"ANUAL\",1,IF(C21=\"SEMESTRAL\",2,IF(C21=\"TRIMESTRAL\",4,IF(C21=\"MENSUAL\",12,1))))","v":1}]
[null,null,4500,null,null,null,null,"S",{"$f":"IF(H28=0,\"NO APLICA\",\"SEMESTRAL\")","v":"SEMESTRAL"}]
[null,null,5500,null,0.1,null,null,"T",{"$f":"IF(H29=0,\"NO APLICA\",\"TRIMESTRAL\")","v":"TRIMESTRAL"},null,"IVA"]
[null,null,6000,null,0.15,null,null,"M",{"$f":"IF(H30=0,\"NO APLICA\",\"MENSUAL\")","v":"MENSUAL"},null,0.11]
[null,null,8000,null,0.2,null,null,"COBERTURA EN EL EXT",null,null,0.16]
[null,null,10000,null,null,null,null,"S","SI"]
[null,null,15000,null,null,null,null,"N","NO"]
[null,null,20000]
[null,null,25000,null,null,null,null,"DEDUCIBLE CERO POR ACC"]
[null,null,30000,null,null,null,"Catalogo","S","SI"]
[null,null,40000,null,null,null,null,"N","NO"]
[null,null,50000]
[null,null,60000]
[null,null,70000,null,null,null,null,"Tipo de Póliza"]
[null,null,80000,null,null,null,null,"NUEVA ",0]
[null,null,90000,null,null,null,null,"RENOVADA",1]
[null,null,100000,null,null,null,null,"ANTES DEL 01/10/2016",1]
[null,null,200000,null,null,null,null,"A PARTIR DEL 01/10/2016",0]
[null,null,300000]
[null,null,400000,null,null,null,null,{"$f":"+CONCATENATE(H239,H242)","v":"NUEVA A PARTIR DEL 01/10/2016"},0]
[null,null,500000,null,null,null,null,{"$f":"+CONCATENATE(H240,H241)","v":"RENOVADAANTES DEL 01/10/2016"},1]
[null,null,600000,null,null,null,null,{"$f":"+CONCATENATE(H240,H242)","v":"RENOVADAA PARTIR DEL 01/10/2016"},0]
[null,null,700000]
[null,null,800000]
[null,null,900000]
[null,null,1000000]
[]
[null,null,null,null,null,null,0]
[null,"INC EN PARTO O CESAREA","PARTO O CESAREA",null,null,null,0.15,25800,{"$f":"+Base","v":25800}]
[null,"SI",20000,null,null,null,0.25]
[null,"NO",30000,null,null,null,0.5]
[null,null,40000,null,null,null,0.75]
[null,null,50000,null,null,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+A263","v":1}]
[{"$f":"1+A264","v":2},null,"TITULAR","CÓNYUGE"]
[3,null,"H",{"$f":"IF((IF(C28=\"\",\" \",D27))=\"H\",\"M\",IF((IF(C28=\"\",\"\",D27))=\"M\",\"H\",IF((IF(C28=\"\",\"\",D27))=\"\",\"\")))","v":""}]
[4,null,"M"]
[5]
[6]
[7,null,"SUMA ASEGURADA",null,null,null,null,"ENF GVES"]
[8,null,200000,null,"TIPO DE COTIZACIÓN",null,null,"NO"]
[9,null,250000,null,"INDIVIDUAL",null,null,10000]
[10,null,300000,null,"FAMILIAR",null,null,20000]
[11,null,350000,null,null,null,null,30000]
[12,null,400000,null,null,null,null,40000]
[13,null,450000,null,null,null,null,50000]
[14,null,500000,null,null,null,null,75000]
[15,null,550000,null,null,null,null,100000]
[16,null,600000,null,null,null,null,150000]
[17,null,650000,null,null,null,null,200000]
[18,null,700000,null,null,null,null,250000]
[19,null,750000,null,null,null,null,300000]
[20,null,1000000,null,null,null,null,350000]
[21,null,2000000,null,null,null,null,400000]
[22,null,3000000,null,null,null,null,450000]
[23,null,4000000,null,null,null,null,500000]
[24,null,5000000,null,null,null,null,550000]
[25,null,6000000,null,null,null,null,600000]
[26,null,7000000,null,null,null,null,650000]
[27,null,8000000,null,null,null,null,700000]
[28,null,9000000,null,null,null,null,750000]
[29,null,10000000,null,null,null,null,800000]
[30,null,20000000,null,null,null,null,850000]
[31,null,30000000]
[32,null,40000000]
[33,null,50000000]
[34,null,70000000]
[35,null,100000000]
[36,null,18000000]
[37,null,20000000]
[38,null,22000000]
[39,null,24000000]
[40,null,26000000]
[41,null,30000000]
[42]
[43]
[44]
[45]
[46,null,"Estado","REGIÓN","Anterior"]
[47,null,"AGUASCALIENTES",3,2]
[48,null,"BAJA CALIFORNIA",2,3]
[49,null,"BAJA CALIFORNIA SUR",3,3]
[50,null,"CAMPECHE",1,1]
[51,null,"CHIAPAS",2,1]
[52,null,"CHIHUAHUA",4,3]
[53,null,"COAHUILA",4,2]
[54,null,"COLIMA",3,2]
[55,null,"CIUDAD DE MÉXICO",5,4]
[56,null,"DURANGO",3,2]
[57,null,"ESTADO DE MÉXICO",5,4]
[58,null,"GUANAJUATO",2,2]
[59,null,"GUERRERO",2,1]
[60,null,"HIDALGO",3,1]
[61,null,"JALISCO",3,2]
[62,null,"MICHOACÁN",3,2]
[63,null,"MORELOS",4,3]
[64,null,"NAYARIT",2,1]
[65,null,"NUEVO LEÓN",4,3]
[{"$f":"1+A328","v":66},null,"OAXACA",1,1]
[{"$f":"1+A329","v":67},null,"PUEBLA",2,1]
[{"$f":"1+A330","v":68},null,"QUERÉTARO",3,3]
[{"$f":"1+A331","v":69},null,"QUINTANA ROO",2,1]
[{"$f":"1+A332","v":70},null,"SAN LUIS POTOSÍ",4,3]
[71,null,"SINALOA",3,3]
[72,null,"SONORA",4,3]
[73,null,"TABASCO",2,1]
[74,null,"TAMAULIPAS",4,3]
[75,null,"TLAXCALA",1,1]
[76,null,"VERACRUZ",2,1]
[77,null,"YUCATÁN",1,1]
[78,null,"ZACATECAS",3,2]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[{"$f":"1+A353","v":91}]
[{"$f":"1+A354","v":92}]
[{"$f":"1+A355","v":93}]
[{"$f":"1+A356","v":94}]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"IMPRESION","index":7,"n_rows":224,"n_cols":11,"rows_kept":224,"cut":false,"hidden":true,"merged":[[84,4,84,5],[86,2,86,3],[99,1,100,11],[6,1,7,10],[8,1,9,10],[94,2,94,10],[97,2,98,10],[89,2,89,3],[88,2,88,3],[11,1,11,10],[70,2,71,6],[70,7,71,7],[70,8,71,8],[86,4,86,6],[70,9,71,9],[57,2,57,10],[69,2,69,10],[84,2,84,3]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-01-26"}]
[null,{"$f":"+\"Apreciable  \"&COTIZACION!C27","v":"Apreciable  "}]
[]
[null,{"$f":"+\"Agradecemos de antemano su preferencia y esperamos que la presente propuesta de Gastos Médicos \"&COTIZACION!D10&\" cumpla sus expectativas.\"","v":"Agradecemos de antemano su preferencia y esperamos que la presente propuesta de Gastos Médicos INDIVIDUAL cumpla sus expectativas."}]
[]
[]
[null,"CUADRO DE COBERTURAS"]
[null,"-","Tipo de Hospital",null,null,null,null,null,"Hospitales del Plan"]
[]
[null,"-","Suma Asegurada",null,null,null,null,null,{"$f":"+COTIZACION!D11","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":"+TITULAR!E6","v":10000},"M.N."]
[]
[null,"-","Coaseguro",null,null,null,"Enfermedad",null,{"$f":"+CONCATENATE(TITULAR!E8*100,\"% con tope de \",VLOOKUP(COTIZACION!D13,FACTORES!C16:D20,2,FALSE)&\" M.N.\")","v":"10% con tope de $30,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,"-","Base de Honorarios Quirúrgicos",null,null,null,null,null,"Catálogo del Plan"]
[null,"-","Honorarios por visita intrahospitalaria",null,null,null,null,null,"Catálogo del Plan"]
[null,"-","Honorarios por consulta",null,null,null,null,null,"Catálogo del Plan"]
[null,"-","Honorarios por enfermera máximo 3 turnos por día durante 30 días",null,null,null,null,null,"Catálogo del Plan"]
[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 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,50000,{"$f":"IF(I33=\"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,150,{"$f":"IF(I34=\"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,15000,{"$f":"IF(I36=\"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 del Plan"]
[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(I40=\"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,"-","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 escoliosis, 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,"-","Cobertura Sin Límite de Edad (de acuerdo a la cláusula de edad)",null,null,null,null,null,"Incluido"]
[null,"-","Cobertura de Visión",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,null,"Coberturas Adicionales"]
[null,"-","Cobertura de Indemnización por Enfermedad Grave",null,null,null,null,null,{"$f":"IF(OR(COTIZACION!D19=\"NO\",SUM(COTIZACION!A27:A34)<=0),\"Excluido\",COTIZACION!D19)","v":"Excluido"},{"$f":"IF(I59=\"EXCLUIDO\",\"\",\"M.N.\")","v":""}]
[null,"-","Cobertura de Visión Incremental",null,null,null,null,null,{"$f":"IF(COTIZACION!D18=\"SI\",\"Incluido\",\"Excluido\")","v":"Incluido"}]
[null,"-","Eliminación de deducible por accidente",null,null,null,null,null,{"$f":"+IF(COTIZACION!D16=\"SI\",\"Incluido\",\"Excluido\")","v":"Incluido"}]
[]
[null,null,"Se cobrara doble deducible y coaseguro de póliza, a los asegurados que se atiendan en Hospiten México S.A de C.V"]
[null,null,"Si el asegurado desea tratarse en hospitales o con médicos que no sean de la red del plan, se le aplicará el deducible contratado y un coaseguro"]
[null,null,"del 20% sin tope de coaseguro, solo aplica pago vía reembolso."]
[null,null,"Si el asegurado se atiende con médico y hospital de red, se descuenta 3,000 de deducible y 5 puntos de coaseguro, siempre que la atención sea dentro de la misma "]
[null,null,"zona de tarifa contratada o en una zona menor."]
[null,null,"Si la atención se da con médicos y hospitales de la red del plan, pero en una zona diferente a la de contratación, se aplicará 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(H73<>\"\",H73>69),1,0)","v":0},null,{"$f":"IF(COTIZACION!C27=\"\",\"\",COTIZACION!C27)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!E27=\"\",\"\",COTIZACION!E27)","v":0},{"$f":"IF(COTIZACION!D27=\"\",\"\",COTIZACION!D27)","v":"H"},{"$f":"IF(COTIZACION!C27=\"\",\"\",COTIZACION!B27)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H73=\"\",\"\",IF(I73=\"H\",VLOOKUP(H73,TITULAR!$B$27:$G$112,5,0),IF(I73=\"M\",VLOOKUP(H73,TITULAR!$B$27:$G$112,6,0),\"\")))),\"\")","v":7259.0323643949923}]
[{"$f":"IF(AND(H74<>\"\",H74>69),1,0)","v":0},null,{"$f":"IF(COTIZACION!C28=\"\",\"\",COTIZACION!C28)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E28=\"\",\"\",COTIZACION!E28))","v":""},{"$f":"IF(COTIZACION!D28=\"\",\"\",COTIZACION!D28)","v":""},{"$f":"IF(COTIZACION!C28=\"\",\"\",COTIZACION!B28)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H74=\"\",\"\",IF(I74=\"H\",VLOOKUP(H74,CONYUGE!$B$21:$G$112,5,0),IF(I74=\"M\",VLOOKUP(H74,CONYUGE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[{"$f":"IF(AND(H75<>\"\",H75>69),1,0)","v":0},null,{"$f":"IF(COTIZACION!C29=\"\",\"\",COTIZACION!C29)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E29=\"\",\"\",COTIZACION!E29))","v":""},{"$f":"IF(COTIZACION!D29=\"\",\"\",COTIZACION!D29)","v":""},{"$f":"IF(COTIZACION!C29=\"\",\"\",COTIZACION!B29)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H75=\"\",\"\",IF(I75=\"H\",VLOOKUP(H75,DEPENDIENTE!$B$21:$G$112,5,0),IF(I75=\"M\",VLOOKUP(H75,DEPENDIENTE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[0,null,{"$f":"IF(COTIZACION!C30=\"\",\"\",COTIZACION!C30)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E30=\"\",\"\",COTIZACION!E30))","v":""},{"$f":"IF(COTIZACION!D30=\"\",\"\",COTIZACION!D30)","v":""},{"$f":"IF(COTIZACION!C30=\"\",\"\",COTIZACION!B30)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H76=\"\",\"\",IF(I76=\"H\",VLOOKUP(H76,DEPENDIENTE!$B$21:$G$112,5,0),IF(I76=\"M\",VLOOKUP(H76,DEPENDIENTE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[0,null,{"$f":"IF(COTIZACION!C31=\"\",\"\",COTIZACION!C31)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E31=\"\",\"\",COTIZACION!E31))","v":""},{"$f":"IF(COTIZACION!D31=\"\",\"\",COTIZACION!D31)","v":""},{"$f":"IF(COTIZACION!C31=\"\",\"\",COTIZACION!B31)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H77=\"\",\"\",IF(I77=\"H\",VLOOKUP(H77,DEPENDIENTE!$B$21:$G$112,5,0),IF(I77=\"M\",VLOOKUP(H77,DEPENDIENTE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[0,null,{"$f":"IF(COTIZACION!C32=\"\",\"\",COTIZACION!C32)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E32=\"\",\"\",COTIZACION!E32))","v":""},{"$f":"IF(COTIZACION!D32=\"\",\"\",COTIZACION!D32)","v":""},{"$f":"IF(COTIZACION!C32=\"\",\"\",COTIZACION!B32)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H78=\"\",\"\",IF(I78=\"H\",VLOOKUP(H78,DEPENDIENTE!$B$21:$G$112,5,0),IF(I78=\"M\",VLOOKUP(H78,DEPENDIENTE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[0,null,{"$f":"IF(COTIZACION!C33=\"\",\"\",COTIZACION!C33)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E33=\"\",\"\",COTIZACION!E33))","v":""},{"$f":"IF(COTIZACION!D33=\"\",\"\",COTIZACION!D33)","v":""},{"$f":"IF(COTIZACION!C33=\"\",\"\",COTIZACION!B33)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H79=\"\",\"\",IF(I79=\"H\",VLOOKUP(H79,DEPENDIENTE!$B$21:$G$112,5,0),IF(I79=\"M\",VLOOKUP(H79,DEPENDIENTE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[0,null,{"$f":"IF(COTIZACION!C34=\"\",\"\",COTIZACION!C34)","v":""},null,null,null,null,{"$f":"IF(COTIZACION!$D$10=\"INDIVIDUAL\",\"\",IF(COTIZACION!E34=\"\",\"\",COTIZACION!E34))","v":""},{"$f":"IF(COTIZACION!D34=\"\",\"\",COTIZACION!D34)","v":""},{"$f":"IF(COTIZACION!C34=\"\",\"\",COTIZACION!B34)","v":""},{"$f":"IFERROR(IF(COTIZACION!F27<>\"\",\"\",IF(H80=\"\",\"\",IF(I80=\"H\",VLOOKUP(H80,DEPENDIENTE!$B$21:$G$112,5,0),IF(I80=\"M\",VLOOKUP(H80,DEPENDIENTE!$B$21:$G$112,6,0),\"\")))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Prima Total Anual",null,{"$f":"IF(COTIZACION!D8=\"NUEVA \",IF(A100=0,SUM(K73:K80),0),SUM(K73:K80))","v":7259.0323643949923}]
[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(K81=0,0,+TITULAR!I25)","v":700}]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"+K81+K83","v":7959.0323643949923}]
[null,null,"REGIÓN DE TARIFA:",null,{"$f":"+COTIZACION!D14","v":"NUEVO LEÓN"},null,null,null,"I.V.A.",null,{"$f":"+K84*TITULAR!K25","v":1273.4451783031989}]
[null,null,null,null,null,null,null,null,"Prima Total Anual",null,{"$f":"SUM(K84:K85)","v":9232.4775426981905}]
[null,null,"AGENTE:",null,{"$f":"IF(COTIZACION!C39=\"\",\"\",COTIZACION!C39)","v":""}]
[]
[null,null,"Forma de pago",null,"Primer recibo","Recibos subsecuentes","Total"]
[null,null,{"$f":"+COTIZACION!G27","v":"ANUAL"},null,{"$f":"IF(K81=0,0,(K81/(1+K82)+DER)*(1+COTIZACION!$D$20))","v":9232.4775426981905},0,{"$f":"+F90+E90","v":9232.4775426981905}]
[null,null,{"$f":"\"SEMESTRAL    (Recargo \"&COTIZACION!H36*100&\"%)\"","v":"SEMESTRAL    (Recargo 4.73%)"},null,{"$f":"+COTIZACION!H28","v":5221.3830652339066},{"$f":"+COTIZACION!I28","v":4409.3830652339075},{"$f":"+F91+E91","v":9630.7661304678149}]
[null,null,{"$f":"\"TRIMESTRAL  (Recargo \"&COTIZACION!H37*100&\"%)\"","v":"TRIMESTRAL  (Recargo 6.99%)"},null,{"$f":"+COTIZACION!H29","v":3064.2672307331982},{"$f":"+COTIZACION!I29","v":2252.2672307331986},{"$f":"+F92*3+E92","v":9821.0689229327945}]
[null,null,{"$f":"\"MENSUAL        (Recargo \"&COTIZACION!H38*100&\"%)\"","v":"MENSUAL        (Recargo 9.99%)"},null,{"$f":"+COTIZACION!H30","v":1583.8069374344784},{"$f":"+COTIZACION!I30","v":771.80693743447841},{"$f":"+F93*11+E93","v":10073.68324921374}]
[]
[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(A73:A80)","v":0},{"$f":"+CONCATENATE(\"EN SEGUROS BANORTE ESTA COTIZACIÓN \",COTIZACION!E8)","v":"EN SEGUROS BANORTE ESTA COTIZACIÓN APLICA PARA AQUELLA PÓLIZA RENOVADA CON PRIMER VIGENCIA EMITIDA ANTES DEL 01/10/2016"}]
[]
[null,null,"Tarifa Esencial 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":98,"n_cols":12,"rows_kept":98,"cut":false,"hidden":true,"merged":[[6,9,6,10],[6,1,6,2],[95,1,95,11],[70,1,70,3],[12,1,13,3],[12,5,13,7],[12,9,13,11],[76,1,77,3]]}
[]
[]
[]
[]
[]
[]
[null,"Tipo de póliza",null,{"$f":"+COTIZACION!D8","v":"RENOVADA"},null,null,null,null,null,"Región de tarifa",null,{"$f":"+COTIZACION!D15","v":4}]
[]
[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,"Prima Total Titular",null,null,null,"Prima Total Cónyuge",null,null,null,"Prima Total Dependiente"]
[]
[null,"EDAD","HOMBRE","MUJER",null,"EDAD","HOMBRE","MUJER",null,"EDAD","HOMBRE","MUJER"]
[null,"18",{"$f":"IFERROR(TITULAR!J45,0)","v":9192.9563426981913},{"$f":"IFERROR(TITULAR!K45,0)","v":9199.3363426981923},null,"18",{"$f":"IFERROR(+CONYUGE!J39,0)","v":7499.2375999999995},{"$f":"IFERROR(+CONYUGE!K39,0)","v":7505.6175999999987},null,"0 - 5",{"$f":"IFERROR(DEPENDIENTE!J26,0)","v":7538.7587999999987},{"$f":"IFERROR(DEPENDIENTE!K26,0)","v":7563.652399999999}]
[null,{"$f":"+B16+1","v":19},{"$f":"IFERROR(TITULAR!J46,0)","v":9389.3907426981914},{"$f":"IFERROR(TITULAR!K46,0)","v":9276.4763426981917},null,{"$f":"+F16+1","v":19},{"$f":"IFERROR(+CONYUGE!J40,0)","v":7695.6719999999996},{"$f":"IFERROR(+CONYUGE!K40,0)","v":7582.757599999999},null,6,{"$f":"IFERROR(DEPENDIENTE!J27,0)","v":7538.7587999999987},{"$f":"IFERROR(DEPENDIENTE!K27,0)","v":7563.652399999999}]
[null,{"$f":"+B17+1","v":20},{"$f":"IFERROR(TITULAR!J47,0)","v":9611.3335426981903},{"$f":"IFERROR(TITULAR!K47,0)","v":10258.752742698192},null,{"$f":"+F17+1","v":20},{"$f":"IFERROR(+CONYUGE!J41,0)","v":7917.6147999999994},{"$f":"IFERROR(+CONYUGE!K41,0)","v":8565.0339999999997},null,{"$f":"+J17+1","v":7},{"$f":"IFERROR(DEPENDIENTE!J28,0)","v":7538.7587999999987},{"$f":"IFERROR(DEPENDIENTE!K28,0)","v":7563.652399999999}]
[null,21,{"$f":"IFERROR(TITULAR!J48,0)","v":10118.172342698192},{"$f":"IFERROR(TITULAR!K48,0)","v":12099.951142698192},null,21,{"$f":"IFERROR(+CONYUGE!J42,0)","v":8424.4535999999989},{"$f":"IFERROR(+CONYUGE!K42,0)","v":10406.232400000001},null,{"$f":"+J18+1","v":8},{"$f":"IFERROR(DEPENDIENTE!J29,0)","v":7538.7587999999987},{"$f":"IFERROR(DEPENDIENTE!K29,0)","v":7563.652399999999}]
[null,22,{"$f":"IFERROR(TITULAR!J49,0)","v":10416.338742698192},{"$f":"IFERROR(TITULAR!K49,0)","v":12488.817942698191},null,22,{"$f":"IFERROR(+CONYUGE!J43,0)","v":8722.619999999999},{"$f":"IFERROR(+CONYUGE!K43,0)","v":10795.099199999999},null,9,{"$f":"IFERROR(DEPENDIENTE!J30,0)","v":7538.7587999999987},{"$f":"IFERROR(DEPENDIENTE!K30,0)","v":7563.652399999999}]
[null,23,{"$f":"IFERROR(TITULAR!J50,0)","v":10889.270742698191},{"$f":"IFERROR(TITULAR!K50,0)","v":12887.799942698191},null,23,{"$f":"IFERROR(+CONYUGE!J44,0)","v":9195.5519999999997},{"$f":"IFERROR(+CONYUGE!K44,0)","v":11194.081199999999},null,10,{"$f":"IFERROR(DEPENDIENTE!J31,0)","v":7538.7587999999987},{"$f":"IFERROR(DEPENDIENTE!K31,0)","v":7563.652399999999}]
[null,24,{"$f":"IFERROR(TITULAR!J51,0)","v":11197.737942698193},{"$f":"IFERROR(TITULAR!K51,0)","v":13306.037942698191},null,24,{"$f":"IFERROR(+CONYUGE!J45,0)","v":9504.0192000000006},{"$f":"IFERROR(+CONYUGE!K45,0)","v":11612.319199999998},null,11,{"$f":"IFERROR(DEPENDIENTE!J32,0)","v":7606.003999999999},{"$f":"IFERROR(DEPENDIENTE!K32,0)","v":7560.6711999999989}]
[null,25,{"$f":"IFERROR(TITULAR!J52,0)","v":11507.063542698193},{"$f":"IFERROR(TITULAR!K52,0)","v":13739.506742698191},null,25,{"$f":"IFERROR(+CONYUGE!J46,0)","v":9813.3448000000008},{"$f":"IFERROR(+CONYUGE!K46,0)","v":12045.787999999999},null,12,{"$f":"IFERROR(DEPENDIENTE!J33,0)","v":7583.6623999999993},{"$f":"IFERROR(DEPENDIENTE!K33,0)","v":7617.9055999999991}]
[null,26,{"$f":"IFERROR(TITULAR!J53,0)","v":12051.532742698191},{"$f":"IFERROR(TITULAR!K53,0)","v":14119.650342698191},null,26,{"$f":"IFERROR(+CONYUGE!J47,0)","v":10357.813999999998},{"$f":"IFERROR(+CONYUGE!K47,0)","v":12425.931599999998},null,13,{"$f":"IFERROR(DEPENDIENTE!J34,0)","v":7539.2923999999985},{"$f":"IFERROR(DEPENDIENTE!K34,0)","v":7580.4375999999993}]
[null,27,{"$f":"IFERROR(TITULAR!J54,0)","v":12439.193142698192},{"$f":"IFERROR(TITULAR!K54,0)","v":14584.566742698191},null,27,{"$f":"IFERROR(+CONYUGE!J48,0)","v":10745.474399999999},{"$f":"IFERROR(+CONYUGE!K48,0)","v":12890.847999999998},null,14,{"$f":"IFERROR(DEPENDIENTE!J35,0)","v":7378.5743999999995},{"$f":"IFERROR(DEPENDIENTE!K35,0)","v":7463.9271999999992}]
[null,28,{"$f":"IFERROR(TITULAR!J55,0)","v":12966.45954269819},{"$f":"IFERROR(TITULAR!K55,0)","v":15080.73354269819},null,28,{"$f":"IFERROR(+CONYUGE!J49,0)","v":11272.740799999998},{"$f":"IFERROR(+CONYUGE!K49,0)","v":13387.014799999997},null,15,{"$f":"IFERROR(DEPENDIENTE!J36,0)","v":7399.9879999999985},{"$f":"IFERROR(DEPENDIENTE!K36,0)","v":7367.8907999999992}]
[null,29,{"$f":"IFERROR(TITULAR!J56,0)","v":13455.712742698192},{"$f":"IFERROR(TITULAR!K56,0)","v":15581.424342698192},null,29,{"$f":"IFERROR(+CONYUGE!J50,0)","v":11761.993999999999},{"$f":"IFERROR(+CONYUGE!K50,0)","v":13887.705599999999},null,16,{"$f":"IFERROR(DEPENDIENTE!J37,0)","v":7301.62},{"$f":"IFERROR(DEPENDIENTE!K37,0)","v":6932.1831999999986}]
[null,30,{"$f":"IFERROR(TITULAR!J57,0)","v":13910.850342698192},{"$f":"IFERROR(TITULAR!K57,0)","v":16131.995142698192},null,30,{"$f":"IFERROR(+CONYUGE!J51,0)","v":12217.131599999999},{"$f":"IFERROR(+CONYUGE!K51,0)","v":14438.276399999997},null,17,{"$f":"IFERROR(DEPENDIENTE!J38,0)","v":7338.1947999999993},{"$f":"IFERROR(DEPENDIENTE!K38,0)","v":7019.8095999999987}]
[null,31,{"$f":"IFERROR(TITULAR!J58,0)","v":14348.239942698192},{"$f":"IFERROR(TITULAR!K58,0)","v":16697.39074269819},null,31,{"$f":"IFERROR(+CONYUGE!J52,0)","v":12654.521199999999},{"$f":"IFERROR(+CONYUGE!K52,0)","v":15003.671999999997},null,18,{"$f":"IFERROR(DEPENDIENTE!J39,0)","v":7499.2375999999995},{"$f":"IFERROR(DEPENDIENTE!K39,0)","v":7505.6175999999987}]
[null,32,{"$f":"IFERROR(TITULAR!J59,0)","v":15028.25514269819},{"$f":"IFERROR(TITULAR!K59,0)","v":17271.845942698194},null,32,{"$f":"IFERROR(+CONYUGE!J53,0)","v":13334.536399999997},{"$f":"IFERROR(+CONYUGE!K53,0)","v":15578.127199999999},null,19,{"$f":"IFERROR(DEPENDIENTE!J40,0)","v":7695.6719999999996},{"$f":"IFERROR(DEPENDIENTE!K40,0)","v":7582.757599999999}]
[null,33,{"$f":"IFERROR(TITULAR!J60,0)","v":15442.363542698191},{"$f":"IFERROR(TITULAR!K60,0)","v":17857.332742698192},null,33,{"$f":"IFERROR(+CONYUGE!J54,0)","v":13748.644799999998},{"$f":"IFERROR(+CONYUGE!K54,0)","v":16163.613999999998},null,20,{"$f":"IFERROR(DEPENDIENTE!J41,0)","v":7917.6147999999994},{"$f":"IFERROR(DEPENDIENTE!K41,0)","v":8565.0339999999997}]
[null,34,{"$f":"IFERROR(TITULAR!J61,0)","v":16122.216342698193},{"$f":"IFERROR(TITULAR!K61,0)","v":18484.185142698192},null,34,{"$f":"IFERROR(+CONYUGE!J55,0)","v":14428.497599999999},{"$f":"IFERROR(+CONYUGE!K55,0)","v":16790.466399999998},null,21,{"$f":"IFERROR(DEPENDIENTE!J42,0)","v":8424.4535999999989},{"$f":"IFERROR(DEPENDIENTE!K42,0)","v":10406.232400000001}]
[null,35,{"$f":"IFERROR(TITULAR!J62,0)","v":16830.918342698191},{"$f":"IFERROR(TITULAR!K62,0)","v":19148.43594269819},null,35,{"$f":"IFERROR(+CONYUGE!J56,0)","v":15137.199599999998},{"$f":"IFERROR(+CONYUGE!K56,0)","v":17454.717199999999},null,22,{"$f":"IFERROR(DEPENDIENTE!J43,0)","v":8722.619999999999},{"$f":"IFERROR(DEPENDIENTE!K43,0)","v":10795.099199999999}]
[null,36,{"$f":"IFERROR(TITULAR!J63,0)","v":17409.769942698193},{"$f":"IFERROR(TITULAR!K63,0)","v":19829.309542698189},null,36,{"$f":"IFERROR(+CONYUGE!J57,0)","v":15716.051199999998},{"$f":"IFERROR(+CONYUGE!K57,0)","v":18135.590799999998},null,23,{"$f":"IFERROR(DEPENDIENTE!J44,0)","v":9195.5519999999997},{"$f":"IFERROR(DEPENDIENTE!K44,0)","v":11194.081199999999}]
[null,37,{"$f":"IFERROR(TITULAR!J64,0)","v":18179.627142698191},{"$f":"IFERROR(TITULAR!K64,0)","v":20588.854342698189},null,37,{"$f":"IFERROR(+CONYUGE!J58,0)","v":16485.9084},{"$f":"IFERROR(+CONYUGE!K58,0)","v":18895.135599999998},null,24,{"$f":"IFERROR(DEPENDIENTE!J45,0)","v":9504.0192000000006},{"$f":"IFERROR(DEPENDIENTE!K45,0)","v":11612.319199999998}]
[null,38,{"$f":"IFERROR(TITULAR!J65,0)","v":18973.577542698193},{"$f":"IFERROR(TITULAR!K65,0)","v":21320.999942698189},null,38,{"$f":"IFERROR(+CONYUGE!J59,0)","v":17279.858799999998},{"$f":"IFERROR(+CONYUGE!K59,0)","v":19627.281199999998}]
[null,39,{"$f":"IFERROR(TITULAR!J66,0)","v":19829.889542698191},{"$f":"IFERROR(TITULAR!K66,0)","v":22108.674742698189},null,39,{"$f":"IFERROR(+CONYUGE!J60,0)","v":18136.170799999996},{"$f":"IFERROR(+CONYUGE!K60,0)","v":20414.955999999998}]
[null,40,{"$f":"IFERROR(TITULAR!J67,0)","v":20411.571542698191},{"$f":"IFERROR(TITULAR!K67,0)","v":22924.897142698192},null,40,{"$f":"IFERROR(+CONYUGE!J61,0)","v":18717.852799999997},{"$f":"IFERROR(+CONYUGE!K61,0)","v":21231.178400000001}]
[null,41,{"$f":"IFERROR(TITULAR!J68,0)","v":21048.63194269819},{"$f":"IFERROR(TITULAR!K68,0)","v":23781.000342698186},null,41,{"$f":"IFERROR(+CONYUGE!J62,0)","v":19354.913199999999},{"$f":"IFERROR(+CONYUGE!K62,0)","v":22087.281599999998}]
[null,42,{"$f":"IFERROR(TITULAR!J69,0)","v":21737.706742698188},{"$f":"IFERROR(TITULAR!K69,0)","v":24671.92674269819},null,42,{"$f":"IFERROR(+CONYUGE!J63,0)","v":20043.987999999998},{"$f":"IFERROR(+CONYUGE!K63,0)","v":22978.207999999999}]
[null,43,{"$f":"IFERROR(TITULAR!J70,0)","v":22474.387942698188},{"$f":"IFERROR(TITULAR!K70,0)","v":25598.731942698189},null,43,{"$f":"IFERROR(+CONYUGE!J64,0)","v":20780.669199999997},{"$f":"IFERROR(+CONYUGE!K64,0)","v":23905.013199999998}]
[null,44,{"$f":"IFERROR(TITULAR!J71,0)","v":23299.878742698191},{"$f":"IFERROR(TITULAR!K71,0)","v":26696.799542698191},null,44,{"$f":"IFERROR(+CONYUGE!J65,0)","v":21606.16},{"$f":"IFERROR(+CONYUGE!K65,0)","v":25003.0808}]
[null,45,{"$f":"IFERROR(TITULAR!J72,0)","v":24199.632742698192},{"$f":"IFERROR(TITULAR!K72,0)","v":27511.409542698191},null,45,{"$f":"IFERROR(+CONYUGE!J66,0)","v":22505.914000000001},{"$f":"IFERROR(+CONYUGE!K66,0)","v":25817.6908}]
[null,46,{"$f":"IFERROR(TITULAR!J73,0)","v":25186.073542698188},{"$f":"IFERROR(TITULAR!K73,0)","v":28398.125142698191},null,46,{"$f":"IFERROR(+CONYUGE!J67,0)","v":23492.354799999997},{"$f":"IFERROR(+CONYUGE!K67,0)","v":26704.4064}]
[null,47,{"$f":"IFERROR(TITULAR!J74,0)","v":26269.177142698187},{"$f":"IFERROR(TITULAR!K74,0)","v":29644.823542698188},null,47,{"$f":"IFERROR(+CONYUGE!J68,0)","v":24575.458399999996},{"$f":"IFERROR(+CONYUGE!K68,0)","v":27951.104799999997}]
[null,48,{"$f":"IFERROR(TITULAR!J75,0)","v":27446.867142698185},{"$f":"IFERROR(TITULAR!K75,0)","v":30677.838342698185},null,48,{"$f":"IFERROR(+CONYUGE!J69,0)","v":25753.148399999995},{"$f":"IFERROR(+CONYUGE!K69,0)","v":28984.119599999995}]
[null,49,{"$f":"IFERROR(TITULAR!J76,0)","v":28738.271942698189},{"$f":"IFERROR(TITULAR!K76,0)","v":31791.983542698188},null,49,{"$f":"IFERROR(+CONYUGE!J70,0)","v":27044.553199999998},{"$f":"IFERROR(+CONYUGE!K70,0)","v":30098.264799999997}]
[null,50,{"$f":"IFERROR(TITULAR!J77,0)","v":30157.87994269819},{"$f":"IFERROR(TITULAR!K77,0)","v":32974.046742698185},null,50,{"$f":"IFERROR(+CONYUGE!J71,0)","v":28464.161199999999},{"$f":"IFERROR(+CONYUGE!K71,0)","v":31280.327999999998}]
[null,51,{"$f":"IFERROR(TITULAR!J78,0)","v":31690.831542698186},{"$f":"IFERROR(TITULAR!K78,0)","v":34240.024342698191},null,51,{"$f":"IFERROR(+CONYUGE!J72,0)","v":29997.112799999995},{"$f":"IFERROR(+CONYUGE!K72,0)","v":32546.305599999996}]
[null,52,{"$f":"IFERROR(TITULAR!J79,0)","v":33365.778742698189},{"$f":"IFERROR(TITULAR!K79,0)","v":35600.681142698188},null,52,{"$f":"IFERROR(+CONYUGE!J73,0)","v":31672.059999999998},{"$f":"IFERROR(+CONYUGE!K73,0)","v":33906.962399999997}]
[null,53,{"$f":"IFERROR(TITULAR!J80,0)","v":35170.622742698193},{"$f":"IFERROR(TITULAR!K80,0)","v":37062.17674269819},null,53,{"$f":"IFERROR(+CONYUGE!J74,0)","v":33476.904000000002},{"$f":"IFERROR(+CONYUGE!K74,0)","v":35368.457999999999}]
[null,54,{"$f":"IFERROR(TITULAR!J81,0)","v":37129.097142698185},{"$f":"IFERROR(TITULAR!K81,0)","v":38619.697142698191},null,54,{"$f":"IFERROR(+CONYUGE!J75,0)","v":35435.378399999994},{"$f":"IFERROR(+CONYUGE!K75,0)","v":36925.978399999993}]
[null,55,{"$f":"IFERROR(TITULAR!J82,0)","v":39236.155942698191},{"$f":"IFERROR(TITULAR!K82,0)","v":39842.603942698195},null,55,{"$f":"IFERROR(+CONYUGE!J76,0)","v":37542.437199999993},{"$f":"IFERROR(+CONYUGE!K76,0)","v":38148.885199999997}]
[null,56,{"$f":"IFERROR(TITULAR!J83,0)","v":41510.892742698197},{"$f":"IFERROR(TITULAR!K83,0)","v":42314.517542698195},null,56,{"$f":"IFERROR(+CONYUGE!J77,0)","v":39817.173999999999},{"$f":"IFERROR(+CONYUGE!K77,0)","v":40620.798799999997}]
[null,57,{"$f":"IFERROR(TITULAR!J84,0)","v":43970.405942698191},{"$f":"IFERROR(TITULAR!K84,0)","v":43799.804742698194},null,57,{"$f":"IFERROR(+CONYUGE!J78,0)","v":42276.687199999993},{"$f":"IFERROR(+CONYUGE!K78,0)","v":42106.085999999996}]
[null,58,{"$f":"IFERROR(TITULAR!J85,0)","v":45717.342742698194},{"$f":"IFERROR(TITULAR!K85,0)","v":45417.529142698193},null,58,{"$f":"IFERROR(+CONYUGE!J79,0)","v":44023.623999999996},{"$f":"IFERROR(+CONYUGE!K79,0)","v":43723.810400000002}]
[null,59,{"$f":"IFERROR(TITULAR!J86,0)","v":48472.481942698185},{"$f":"IFERROR(TITULAR!K86,0)","v":46106.824342698186},null,59,{"$f":"IFERROR(+CONYUGE!J80,0)","v":46778.763199999994},{"$f":"IFERROR(+CONYUGE!K80,0)","v":44413.105599999995}]
[null,60,{"$f":"IFERROR(TITULAR!J87,0)","v":51172.242742698196},{"$f":"IFERROR(TITULAR!K87,0)","v":49606.010742698185},null,60,{"$f":"IFERROR(+CONYUGE!J81,0)","v":49478.523999999998},{"$f":"IFERROR(+CONYUGE!K81,0)","v":47912.291999999994}]
[null,61,{"$f":"IFERROR(TITULAR!J88,0)","v":53757.53474269819},{"$f":"IFERROR(TITULAR!K88,0)","v":51566.155542698194},null,61,{"$f":"IFERROR(+CONYUGE!J82,0)","v":52063.815999999992},{"$f":"IFERROR(+CONYUGE!K82,0)","v":49872.436800000003}]
[null,62,{"$f":"IFERROR(TITULAR!J89,0)","v":56481.249542698191},{"$f":"IFERROR(TITULAR!K89,0)","v":53631.37314269819},null,62,{"$f":"IFERROR(+CONYUGE!J83,0)","v":54787.530799999993},{"$f":"IFERROR(+CONYUGE!K83,0)","v":51937.654399999992}]
[null,63,{"$f":"IFERROR(TITULAR!J90,0)","v":59314.224742698192},{"$f":"IFERROR(TITULAR!K90,0)","v":55783.474742698192},null,63,{"$f":"IFERROR(+CONYUGE!J84,0)","v":57620.505999999994},{"$f":"IFERROR(+CONYUGE!K84,0)","v":54089.755999999994}]
[null,64,{"$f":"IFERROR(TITULAR!J91,0)","v":62305.377542698188},{"$f":"IFERROR(TITULAR!K91,0)","v":58081.515942698192},null,64,{"$f":"IFERROR(+CONYUGE!J85,0)","v":60611.658799999997},{"$f":"IFERROR(+CONYUGE!K85,0)","v":56387.797199999994}]
[null,65,{"$f":"IFERROR(TITULAR!J92,0)","v":65355.690342698195},{"$f":"IFERROR(TITULAR!K92,0)","v":60403.232742698194},null,65,{"$f":"IFERROR(+CONYUGE!J86,0)","v":63661.971599999997},{"$f":"IFERROR(+CONYUGE!K86,0)","v":58709.513999999996}]
[null,66,{"$f":"IFERROR(TITULAR!J93,0)","v":68616.438742698185},{"$f":"IFERROR(TITULAR!K93,0)","v":62957.216342698193},null,66,{"$f":"IFERROR(+CONYUGE!J87,0)","v":66922.720000000001},{"$f":"IFERROR(+CONYUGE!K87,0)","v":61263.497599999995}]
[null,67,{"$f":"IFERROR(TITULAR!J94,0)","v":72019.797542698187},{"$f":"IFERROR(TITULAR!K94,0)","v":65408.377542698188},null,67,{"$f":"IFERROR(+CONYUGE!J88,0)","v":70326.078799999988},{"$f":"IFERROR(+CONYUGE!K88,0)","v":63714.658799999997}]
[null,68,{"$f":"IFERROR(TITULAR!J95,0)","v":75515.503942698197},{"$f":"IFERROR(TITULAR!K95,0)","v":68103.451942698186},null,68,{"$f":"IFERROR(+CONYUGE!J89,0)","v":73821.785199999998},{"$f":"IFERROR(+CONYUGE!K89,0)","v":66409.733199999988}]
[null,69,{"$f":"IFERROR(TITULAR!J96,0)","v":79197.355542698177},{"$f":"IFERROR(TITULAR!K96,0)","v":70998.904742698185},null,69,{"$f":"IFERROR(+CONYUGE!J90,0)","v":77503.636799999993},{"$f":"IFERROR(+CONYUGE!K90,0)","v":69305.185999999987}]
[]
[]
[]
[]
[]
[null,"SUMA ASEGURADA:",null,{"$f":"+D9","v":10000000}]
[null,"DEDUCIBLE:",null,{"$f":"+D10","v":10000}]
[null,"COASEGURO:",null,{"$f":"+D11","v":0.1}]
[]
[null,"Prima Total Titular Menor de Edad"]
[]
[null,"EDAD","HOMBRE","MUJER"]
[null,"0 - 5",{"$f":"IFERROR(TITULAR!J32,0)","v":9232.4775426981905},{"$f":"IFERROR(TITULAR!K32,0)","v":9257.3711426981899}]
[null,6,{"$f":"IFERROR(TITULAR!J33,0)","v":9232.4775426981905},{"$f":"IFERROR(TITULAR!K33,0)","v":9257.3711426981899}]
[null,{"$f":"+B81+1","v":7},{"$f":"IFERROR(TITULAR!J34,0)","v":9232.4775426981905},{"$f":"IFERROR(TITULAR!K34,0)","v":9257.3711426981899}]
[null,{"$f":"+B82+1","v":8},{"$f":"IFERROR(TITULAR!J35,0)","v":9232.4775426981905},{"$f":"IFERROR(TITULAR!K35,0)","v":9257.3711426981899}]
[null,9,{"$f":"IFERROR(TITULAR!J36,0)","v":9232.4775426981905},{"$f":"IFERROR(TITULAR!K36,0)","v":9257.3711426981899}]
[null,10,{"$f":"IFERROR(TITULAR!J37,0)","v":9232.4775426981905},{"$f":"IFERROR(TITULAR!K37,0)","v":9257.3711426981899}]
[null,11,{"$f":"IFERROR(TITULAR!J38,0)","v":9299.7227426981899},{"$f":"IFERROR(TITULAR!K38,0)","v":9254.3899426981916}]
[null,12,{"$f":"IFERROR(TITULAR!J39,0)","v":9277.3811426981902},{"$f":"IFERROR(TITULAR!K39,0)","v":9311.624342698191}]
[null,13,{"$f":"IFERROR(TITULAR!J40,0)","v":9233.0111426981912},{"$f":"IFERROR(TITULAR!K40,0)","v":9274.1563426981902}]
[null,14,{"$f":"IFERROR(TITULAR!J41,0)","v":9072.2931426981922},{"$f":"IFERROR(TITULAR!K41,0)","v":9157.645942698191}]
[null,15,{"$f":"IFERROR(TITULAR!J42,0)","v":9093.7067426981903},{"$f":"IFERROR(TITULAR!K42,0)","v":9061.6095426981919}]
[null,16,{"$f":"IFERROR(TITULAR!J43,0)","v":8995.3387426981917},{"$f":"IFERROR(TITULAR!K43,0)","v":8625.9019426981904}]
[null,17,{"$f":"IFERROR(TITULAR!J44,0)","v":9031.9135426981902},{"$f":"IFERROR(TITULAR!K44,0)","v":8713.5283426981914}]
[]
[]
[]
[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!C102","v":"Tarifa Esencial Vig: Marzo 01, 2018"}]

{"sheet":"Instrucciones","index":9,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[[36,1,36,8],[37,1,37,8],[38,1,38,8],[20,1,20,8],[9,1,9,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[16,1,16,8],[18,1,18,8],[17,1,17,8],[19,1,19,8],[39,1,39,8],[40,1,40,8],[27,1,27,8],[21,1,21,8],[23,1,23,8],[25,1,25,8],[24,1,24,8],[26,1,26,8],[29,1,29,8],[22,1,22,8],[28,1,28,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-01-26"}]
[]
[]
[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 ESTADO donde radica el cliente."]
[null," (El cotizador le asignará la Región que le corresponda)"]
[null,"6. Seleccione si desea COBERTURA DE ELIMINACION DE DEDUCIBLE POR ACCIDENTE  (\"SI\", \" NO\")"]
[null,"7. Seleccione si desea COBERTURA DE VISION  (\"SI\", \" NO\")"]
[null,"8. Seleccione si desea COBERTURA DE INDEMNIZACION POR ENFERMEDADES GRAVES , la SUMA ASEGURADA"]
[null,"9. Indique el IVA que corresponde a su región (16%)"]
[null,"10. Llene el NOMBRE, SEXO y EDAD del Titular, Cónyuge y Dependientes (si fuera el caso)"]
[null,"11. Vaya al FORMATO DE IMPRESIÓN para obtener la COTIZACIÓN"]
[null,"12. 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 ME","index":11,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["CAMBIOS MEDICO ESENCIAL"]
[]
["HOJA FACTORES (TABLAS DE CALCULO)"]
["Tabla de Deducible"]
["Tabla de Enfermedades Graves"]
["Tabla de Tarifas"]
["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, Cvisión)"]
["Se elimina la cobertura de Educasystem (maestro a domicilio)"]
["Se agrega costo por cobertura de parto y cesárea (mujeres edades de 18 a 54 años ya sean titulares, cónyuge o dependientes)"]
["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"]
["Se elimina de cuadro de coberturas la cobertura de Servicio de Maestro a Domicilio",null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro del botón de “Cuadro de Especificaciones” en el paso 2 del cotizador."]
["Se MODIFICA en el cuadro de coberturas la Cobertura de Dental para agregar Visión",null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro de la cotización. "]
["Modificación de la leyenda de beneficio por pago directo y una leyenda en NOTAS",null,null,null,null,null,null,"ü  Cuadro de especificaciones dentro del kit de impresión de la póliza.  "]
[null,null,null,null,null,null,null,"ü  Cuadro de especificaciones en el botón “Cuadro de Especificaciones” del Tarifario."]
[null,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."]