{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["TAR","Calculo","Presentación","DATOS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":20,"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":"TAR","index":0,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["PRIMAS DE TARIFA REGISTRO 2011  AP ESCOLAR"]
[]
["RIESGO","MA","POA","TOTAL",null,null,"M.A.","POA",null,"RGM","P.N. TOTAL DE RGM "]
["AP ESCOLAR",0.68,0.05,0.56000000000000005,null,"Anual",{"$f":"+G6*1.2","v":0.68399999999999994},{"$f":"+H6*1.2","v":4.8000000000000001E-2},{"$f":"+I6*1.2","v":1.4039999999999999},{"$f":"+J6*1.2","v":80.027999999999992},{"$f":"+J4*Presentación!$G$21","v":79947.971999999994}]
["*Cuotas al Millar de Suma Asegurada",null,null,null,null,"Semestral",{"$f":"+G4*Calculo!$M$26/365","v":{"$error":"#VALUE!"}},{"$f":"+H4*Calculo!$M$26/365","v":{"$error":"#VALUE!"}},{"$f":"+I4*Calculo!$M$26/365","v":{"$error":"#VALUE!"}},{"$f":"+J4*Calculo!$M$26/365","v":{"$error":"#VALUE!"}},{"$f":"+J5*Presentación!$G$21","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Ciclo Escolar",0.56999999999999995,0.04,1.17,{"$f":"VLOOKUP(Presentación!$F$21,$A$11:$O$72,$R$11,FALSE)","v":66.69},{"$f":"+J6*Presentación!$G$21","v":66623.31}]
["RGMA",null,1.2]
["*Prima en Pesos Mexicanos"]
["DEDUCIBLE",0,100,200,300,400,500,600,700,750,800,900,1000,1500,2000]
["Suma Asegurada","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa","*Prima de Tarifa"]
[1000,{"$f":"32.16","v":32.159999999999997},30.23,29.27,28.3,27.34,26.37,25.41,24.44,24.12,23.8,22.83,22.19,18.329999999999998,15.44,null,null,{"$f":"VLOOKUP(Presentación!D16,$Q$12:$R$25,2,FALSE)","v":11}]
[2000,{"$f":"42.43","v":42.43},39.880000000000003,38.61,37.340000000000003,36.07,34.79,33.520000000000003,32.25,31.82,31.4,30.13,29.28,24.19,20.37,null,0,2]
[3000,48.44,45.53,44.08,42.63,41.17,39.72,38.270000000000003,36.81,36.33,35.85,34.39,33.42,27.61,23.25,null,100,3]
[4000,52.7,49.54,47.96,46.38,44.8,43.21,41.63,40.049999999999997,39.53,39,37.42,36.36,30.04,25.3,null,200,4]
[5000,56.01,52.65,50.97,49.29,47.61,45.93,44.25,42.57,42.01,41.45,39.770000000000003,38.65,31.93,26.88,null,300,5]
[6000,58.71,55.19,53.43,51.66,49.9,48.14,46.38,44.62,44.03,43.45,41.68,40.51,33.46,28.18,null,400,6]
[7000,60.99,57.33,55.5,53.67,51.84,50.01,48.18,46.35,45.74,45.13,43.3,42.08,34.76,29.28,null,500,7]
[8000,62.97,59.19,57.3,55.41,53.52,51.64,49.75,47.86,47.23,46.6,44.71,43.45,35.89,30.23,null,600,8]
[9000,64.709999999999994,60.83,58.89,56.94,55,53.06,51.12,49.18,48.53,47.89,45.94,44.65,36.880000000000003,31.06,null,700,9]
[10000,66.28,62.3,60.31,58.33,56.34,54.35,52.36,50.37,49.71,49.05,47.06,45.73,37.78,31.81,null,750,10]
[11000,67.69,63.63,61.6,59.57,57.54,55.51,53.48,51.44,50.77,50.09,48.06,46.71,38.58,32.49,null,800,11]
[12000,68.98,64.84,62.77,60.7,58.63,56.56,54.49,52.42,51.74,51.05,48.98,47.6,39.32,33.11,null,900,12]
[13000,70.16,65.95,63.85,61.74,59.64,57.53,55.43,53.32,52.62,51.92,49.81,48.41,39.99,33.68,null,1000,13]
[14000,71.260000000000005,66.98,64.849999999999994,62.71,60.57,58.43,56.3,54.16,53.45,52.73,50.59,49.17,40.619999999999997,34.200000000000003,null,1500,14]
[15000,72.28,67.94,65.77,63.61,61.44,59.27,57.1,54.93,54.21,53.49,51.32,49.87,41.2,34.69,null,2000,15]
[16000,73.239999999999995,68.849999999999994,66.650000000000006,64.45,62.25,60.06,57.86,55.66,54.93,54.2,52,50.54,41.75,35.159999999999997]
[17000,74.14,69.69,67.47,65.239999999999995,63.02,60.79,58.57,56.35,55.61,54.86,52.64,51.16,42.26,35.590000000000003]
[18000,74.98,70.48,68.23,65.98,63.73,61.48,59.23,56.98,56.24,55.49,53.24,51.74,42.74,35.99]
[19000,75.78,71.23,68.959999999999994,66.69,64.41,62.14,59.87,57.59,56.84,56.08,53.8,52.29,43.19,36.369999999999997]
[20000,76.540000000000006,71.95,69.650000000000006,67.36,65.06,62.76,60.47,58.17,57.41,56.64,54.34,52.81,43.63,36.74]
[21000,77.27,72.63,70.319999999999993,68,65.680000000000007,63.36,61.04,58.73,57.95,57.18,54.86,53.32,44.04,37.090000000000003]
[22000,77.959999999999994,73.28,70.94,68.599999999999994,66.27,63.93,61.59,59.25,58.47,57.69,55.35,53.79,44.44,37.42]
[23000,78.62,73.900000000000006,71.540000000000006,69.19,66.83,64.47,62.11,59.75,58.97,58.18,55.82,54.25,44.81,37.74]
[24000,79.25,74.5,72.12,69.739999999999995,67.36,64.989999999999995,62.61,60.23,59.44,58.65,56.27,54.68,45.17,38.04]
[25000,79.849999999999994,75.06,72.66,70.27,67.87,65.48,63.08,60.69,59.89,59.09,56.69,55.1,45.51,38.33]
[26000,80.430000000000007,75.599999999999994,73.19,70.78,68.37,65.95,63.54,61.13,60.32,59.52,57.11,55.5,45.85,38.61]
[27000,80.989999999999995,76.13,73.7,71.27,68.84,66.41,63.98,61.55,60.74,59.93,57.5,55.88,46.16,38.880000000000003]
[28000,81.53,76.64,74.19,71.75,69.3,66.849999999999994,64.41,61.96,61.15,60.33,57.89,56.26,46.47,39.130000000000003]
[29000,82.05,77.13,74.67,72.2,69.739999999999995,67.28,64.819999999999993,62.36,61.54,60.72,58.26,56.61,46.77,39.380000000000003]
[30000,82.55,77.599999999999994,75.12,72.64,70.17,67.69,65.209999999999994,62.74,61.91,61.09,58.61,56.96,47.05,39.619999999999997]
[31000,83.04,78.06,75.569999999999993,73.08,70.58,68.09,65.599999999999994,63.11,62.28,61.45,58.96,57.3,47.33,39.86]
[32000,83.51,78.5,75.989999999999995,73.489999999999995,70.98,68.48,65.97,63.47,62.63,61.8,59.29,57.62,47.6,40.08]
[33000,83.96,78.92,76.400000000000006,73.88,71.37,68.849999999999994,66.33,63.81,62.97,62.13,59.61,57.93,47.86,40.299999999999997]
[34000,84.41,79.349999999999994,76.81,74.28,71.75,69.22,66.680000000000007,64.150000000000006,63.31,62.46,59.93,58.24,48.11,40.520000000000003]
[35000,84.84,79.75,77.2,74.66,72.11,69.569999999999993,67.02,64.48,63.63,62.78,60.24,58.54,48.36,40.72]
[36000,85.25,80.14,77.58,75.02,72.459999999999994,69.91,67.349999999999994,64.790000000000006,63.94,63.09,60.53,58.82,48.59,40.92]
[37000,85.66,80.52,77.95,75.38,72.81,70.239999999999995,67.67,65.099999999999994,64.25,63.39,60.82,59.11,48.83,41.12]
[38000,86.05,80.89,78.31,75.72,73.14,70.56,67.98,65.400000000000006,64.540000000000006,63.68,61.1,59.37,49.05,41.3]
[39000,86.44,81.25,78.66,76.069999999999993,73.47,70.88,68.290000000000006,65.69,64.83,63.97,61.37,59.64,49.27,41.49]
[40000,86.81,81.599999999999994,79,76.39,73.790000000000006,71.180000000000007,68.58,65.98,65.11,64.239999999999995,61.64,59.9,49.48,41.67]
[41000,87.18,81.95,79.33,76.72,74.099999999999994,71.489999999999995,68.87,66.260000000000005,65.39,64.510000000000005,61.9,60.15,49.69,41.85]
[42000,87.54,82.29,79.66,77.040000000000006,74.41,71.78,69.16,66.53,65.66,64.78,62.15,60.4,49.9,42.02]
[43000,87.89,82.62,79.98,77.34,74.709999999999994,72.069999999999993,69.430000000000007,66.8,65.92,65.040000000000006,62.4,60.64,50.1,42.19]
[44000,88.23,82.94,80.290000000000006,77.64,75,72.349999999999994,69.7,67.05,66.17,65.290000000000006,62.64,60.88,50.29,42.35]
[45000,88.56,83.25,80.59,77.930000000000007,75.28,72.62,69.959999999999994,67.31,66.42,65.53,62.88,61.11,50.48,42.51]
[46000,88.88,83.55,80.88,78.209999999999994,75.55,72.88,70.22,67.55,66.66,65.77,63.1,61.33,50.66,42.66]
[47000,89.2,83.85,81.17,78.5,75.819999999999993,73.14,70.47,67.790000000000006,66.900000000000006,66.010000000000005,63.33,61.55,50.84,42.82]
[48000,89.51,84.14,81.45,78.77,76.08,73.400000000000006,70.709999999999994,68.03,67.13,66.239999999999995,63.55,61.76,51.02,42.96]
[49000,89.82,84.43,81.739999999999995,79.040000000000006,76.349999999999994,73.650000000000006,70.959999999999994,68.260000000000005,67.37,66.47,63.77,61.98,51.2,43.11]
[50000,90.12,84.71,82.01,79.31,76.599999999999994,73.900000000000006,71.19,68.489999999999995,67.59,66.69,63.99,62.18,51.37,43.26]
[51000,90.41,84.99,82.27,79.56,76.849999999999994,74.14,71.42,68.709999999999994,67.81,66.900000000000006,64.19,62.38,51.53,43.4]
[52000,90.7,85.26,82.54,79.819999999999993,77.099999999999994,74.37,71.650000000000006,68.930000000000007,68.03,67.12,64.400000000000006,62.58,51.7,43.54]
[53000,90.98,85.52,82.79,80.06,77.33,74.599999999999994,71.87,69.14,68.239999999999995,67.33,64.599999999999994,62.78,51.86,43.67]
[54000,91.26,85.78,83.05,80.31,77.569999999999993,74.83,72.099999999999994,69.36,68.45,67.53,64.790000000000006,62.97,52.02,43.8]
[55000,91.53,86.04,83.29,80.55,77.8,75.05,72.31,69.56,68.650000000000006,67.73,64.989999999999995,63.16,52.17,43.93]
[56000,91.8,86.29,83.54,80.78,78.03,75.28,72.52,69.77,68.849999999999994,67.930000000000007,65.180000000000007,63.34,52.33,44.06]
[57000,92.06,86.54,83.77,81.010000000000005,78.25,75.489999999999995,72.73,69.97,69.05,68.12,65.36,63.52,52.47,44.19]
[58000,92.32,86.78,84.01,81.239999999999995,78.47,75.7,72.930000000000007,70.16,69.239999999999995,68.319999999999993,65.55,63.7,52.62,44.31]
[59000,92.57,87.02,84.24,81.459999999999994,78.680000000000007,75.91,73.13,70.349999999999994,69.430000000000007,68.5,65.72,63.87,52.76,44.43]
[60000,92.82,87.25,84.47,81.680000000000007,78.900000000000006,76.11,73.33,70.540000000000006,69.62,68.69,65.900000000000006,64.05,52.91,44.55]
[100000,100.39,94.37,91.35,88.34,85.33,82.32,79.31,76.3,75.290000000000006,74.290000000000006,71.28,69.27,57.22,48.19]
[150000,106.4,100.02,96.82,93.63,90.44,87.25,84.06,80.86,79.8,78.739999999999995,75.540000000000006,73.42,60.65,51.07]

{"sheet":"Calculo","index":1,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":true,"merged":[[13,8,13,10],[1,16,7,18],[28,0,28,1],[24,0,24,1],[11,0,11,3],[25,0,25,1],[26,0,26,1],[27,0,27,1],[23,0,23,1]]}
["BENEFICIO","Cuotas Anual","Cuotas Ciclo Escolar","Cuotas Semestral","Cuotas de Riesgo Semestral","Cuotas de Riesgo Anual","Cuotas de Riesgo Ciclo Escolar",null,"PR",37.06,null,null,null,null,"LLAVE DE LLENADO DE INFORMACION"]
["MA",{"$f":"TAR!G4","v":0.68399999999999994},{"$f":"PNMA*J7","v":0.61653698630136977},{"$f":"+TAR!G5","v":{"$error":"#VALUE!"}},{"$f":"ROUND(D2*(1-SUM($B$8:$B$10)),5)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B2*(1-SUM($B$8:$B$10)),5)","v":0.33516000000000001},{"$f":"ROUND(C2*(1-SUM($B$8:$B$10)),3)","v":0.30199999999999999},null,"Asistencias ",{"$f":"+J1/(1-C11)","v":107.42028985507248},null,null,null,null,{"$f":"IF(DATOS!E6=\"\",1,IF(DATOS!E6=\"NOMBRE DEL CONTRATANTE\",1,0))","v":0},null,{"$f":"IF(Calculo!O13=1,\"INFORMACION INCOMPLETA, SE DEBERA LLENAR LA INFORMACION REQUERIDA EN LA HOJA DE DATOS DE ESTE COTIZADOR.\",\"\")","v":""}]
["PO",{"$f":"TAR!H4","v":4.8000000000000001E-2},{"$f":"PNPO*J7","v":4.3265753424657535E-2},{"$f":"TAR!H5","v":{"$error":"#VALUE!"}},{"$f":"ROUND(D3*(1-SUM($B$8:$B$10)),5)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B3*(1-SUM($B$8:$B$10)),5)","v":2.3519999999999999E-2},{"$f":"ROUND(C3*(1-SUM($B$8:$B$10)),3)","v":2.1000000000000001E-2},null,null,null,null,null,null,null,{"$f":"IF(DATOS!E8=\"\",1,IF(DATOS!E8=\"NUMERO DE ALUMNOS\",1,0))","v":0}]
["RGM",{"$f":"TAR!J4/DATOS!E18*1000","v":1.6005599999999998},{"$f":"PNRGM*J7","v":1.4426965479452052},{"$f":"TAR!J5/DATOS!E18*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"ROUND(B4*(1-SUM($B$8:$B$10)),5)","v":0.78427000000000002},{"$f":"ROUND(C4*(1-SUM($B$8:$B$10)),3)","v":0.70699999999999996},null,"2018-08-20","2019-07-15","2018-07-02","2019-01-02",null,null,{"$f":"IF(DATOS!E10=\"\",1,0)","v":0}]
["CUD",{"$f":"G10","v":95.652173913043484},{"$f":"G10*M27/365","v":86.217986896962486},{"$f":"G10*M26/365","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"ROUND(B5*(1-SUM($B$8:$B$10)),5)","v":46.869570000000003},{"$f":"ROUND(C5*(1-SUM($B$8:$B$10)),3)","v":42.247},null,"Ciclo",{"$f":"+J4-I4","v":329},null,null,null,null,{"$f":"IF(DATOS!E10=\"Ciclo Escolar\",0,IF(DATOS!E12=\"\",1,0))","v":0}]
["SBAPE0714",null,null,null,null,null,null,null,365,{"$f":"I6/2","v":182.5},{"$f":"L4-K4+0.5","v":184.5},null,null,null,{"$f":"IF(DATOS!E14=\"\",1,IF(DATOS!E14=\"SUMA ASEGURADA MUERTE ACCIDENTAL\",1,0))","v":0}]
["PARÁMETROS","ACTUALES","NUEVOS PARAMETROS","Maximos",null,null,null,null,null,{"$f":"J5/K7","v":0.90136986301369859},365,null,null,null,{"$f":"IF(DATOS!E16=\"\",1,IF(DATOS!E16=\"SUMA ASEGURADA PARA PÉRDIDAS ORGÁNICAS\",1,0))","v":0}]
["ADMON",0.15,0.15,0.15,0.15,null,"Urgencias Dentales Anual",null,null,{"$f":"M26/K7","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(DATOS!E18=\"\",1,IF(DATOS!E18=\"SUMA ASEGURADA REEMBOLSO DE GASTOS MÉDICOS POR ACCIDENTE\",1,0))","v":0}]
["ADQUISICIÓN",0.3,0.35499999999999998,0.3,0.39800000000000002,null,"Neto","Riesgo",null,null,null,null,null,null,{"$f":"IF(DATOS!E20=\"\",1,IF(DATOS!E20=\"DEDUCIBLE EN REEMBOLSO DE GASTOS MÉDICOS\",1,0))","v":0}]
["UTILIDAD",0.06,0.15,0.15,0.15,null,{"$f":"+H10/(1-C11)","v":95.652173913043484},33,null,null,null,null,null,null,{"$f":"IF(DATOS!E22=\"\",1,IF(DATOS!E22=\"NUMERO DE AGENTE\",1,0))","v":0}]
[null,{"$f":"SUM(GSTS1)","v":0.51},{"$f":"SUM(C8:C10)","v":0.65500000000000003},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DATOS!E24=\"\",1,IF(DATOS!E24=\"NOMBRE DEL AGENTE\",1,0))","v":0}]
["El monto de los recibos puede variar dependiendo de la vigencia que soliciten.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DATOS!E26=\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(O2:O12)","v":0}]
["Cuotas nuevos gastos",null,null,null,null,null,null,null,"CALCULO DE PRESENTACION"]
["BENEFICIO","Cuotas Anual","Cuotas Ciclo Escolar","Cuotas Semestral","Cuotas de Riesgo Semestral","Cuotas de Riesgo Anual","Cuotas de Riesgo Ciclo Escolar",null,null,"Suma asegurada","Participntes","Suma asegurada Total","Prima Neta","Cuotas",null,"ANUAL","AÑO ESCOLAR","SEMESTRAL"]
["MA",{"$f":"F2/(1-$C$11)","v":0.97147826086956535},{"$f":"G2/(1-$C$11)","v":0.8753623188405798},{"$f":"E2/(1-$C$11)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(D16*(1-SUM($C$8:$C$10)),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B16*(1-SUM($C$8:$C$10)),2)","v":0.34},{"$f":"ROUND(C16*(1-SUM($C$8:$C$10)),2)","v":0.3},null,"M.A.",{"$f":"DATOS!$E$14","v":130000},{"$f":"Presentación!D13","v":999},{"$f":"J16*K16","v":129870000},{"$f":"B16*L16/1000","v":126165.88173913045},{"$f":"ROUND(M16/Presentación!H19*1000,4)","v":0.97150000000000003},{"$f":"ROUND(N16*J16/1000,2)","v":126.3},{"$f":"O16*K16","v":126173.7},{"$f":"P16*$J$7","v":113729.17068493149},{"$f":"P16*$J$8","v":{"$error":"#VALUE!"}}]
["PO",{"$f":"F3/(1-$C$11)","v":6.8173913043478265E-2},{"$f":"G3/(1-$C$11)","v":6.0869565217391314E-2},{"$f":"E3/(1-$C$11)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(D17*(1-SUM($C$8:$C$10)),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(B17*(1-SUM($C$8:$C$10)),2)","v":0.02},0.02,null,"P.O.",{"$f":"DATOS!$E$16","v":130000},{"$f":"Presentación!D13","v":999},{"$f":"J17*K17","v":129870000},{"$f":"B17*L17/1000","v":8853.746086956522},{"$f":"ROUND(M17/Presentación!H20*1000,4)","v":6.8199999999999997E-2},{"$f":"ROUND(N17*J17/1000,2)","v":8.8699999999999992},{"$f":"O17*K17","v":8861.1299999999992},{"$f":"P17*$J$7","v":7987.1555342465745},{"$f":"P17*$J$8","v":{"$error":"#VALUE!"}}]
["RGM",2.2732463768115942,{"$f":"G4/(1-$C$11)","v":2.0492753623188404},{"$error":"#VALUE!"},{"$f":"ROUND(D18*(1-SUM($C$8:$C$10)),2)","v":{"$error":"#VALUE!"}},0.78,0.71,null,"RGM",{"$f":"DATOS!$E$18","v":50000},{"$f":"Presentación!D13","v":999},{"$f":"J18*K18","v":49950000},113548.65652173915,{"$f":"ROUND(M18/Presentación!H21*1000,4)","v":2.2732000000000001},{"$f":"ROUND(N18*J18/1000,2)","v":113.66},113546.34,102347.24893150684,{"$error":"#VALUE!"}]
["CUD",{"$f":"F5/(1-$C$11)","v":135.85382608695653},122.45507246376812,{"$error":"#VALUE!"},{"$f":"ROUND(D19*(1-SUM($C$8:$C$10)),2)","v":{"$error":"#VALUE!"}},46.87,42.25,null,"CUD",{"$f":"DATOS!$E$26","v":"NO"},{"$f":"Presentación!D13","v":999},null,{"$f":"IF(J19=\"SI\",IF(DATOS!E10=\"Anual\",K19*B19,IF(DATOS!E10=\"Semestral\",K19*D19,K19*C19)))","v":false}]
[null,{"$f":"1-C16/B2","v":-0.27976947198915192},{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(M18=\"#NA\",\"#NA\",P20),2)","v":248581.17},null,null,{"$f":"IF(DATOS!$E$10=\"ANUAL\",SUM(P16:P18),IF(DATOS!E10=\"CICLO ESCOLAR\",SUM(Calculo!Q16:Q18),SUM(Calculo!R16:R18)))","v":248581.16999999998}]
[null,-0.26811594202898559,{"$error":"#VALUE!"}]
[null,-0.28034897930651814,{"$error":"#VALUE!"}]
[null,null,"CONTADO","SEMESTRAL","TRIMESTRAL","MENSUAL"]
["Prima Neta Total ",null,{"$f":"IF(Calculo!O13=1,\"INFO. INCOMPLETA\",PNETA)","v":248581.17},{"$f":"+C24","v":248581.17},{"$f":"+D24","v":248581.17},{"$f":"+E24","v":248581.17},null,null,null,"Vigencia de la póliza","Inicio","Fin","Dias"]
["Rec. x Pago Fracc.",null,0,{"$f":"D24*4.73%","v":11757.889341000002},{"$f":"E24*7%","v":17400.681900000003},{"$f":"F24*10%","v":24858.117000000002},null,null,null,"Anual",{"$f":"IF(DATOS!E10=\"Anual\",DATOS!$E$12,\"\")","v":"2018-07-02"},{"$f":"IFERROR(K25+365,\"\")","v":"2019-07-02"}]
["Derecho de Póliza ",null,200,300,300,300,null,null,null,"Semestral",{"$f":"+IF(DATOS!E10=\"Semestral\",DATOS!E12,\"\")","v":""},{"$f":"IFERROR(EDATE(K26,6),\"\")","v":""},{"$f":"+L26-K26","v":{"$error":"#VALUE!"}}]
[0.16,null,{"$f":"(C24+C25+C26)*$A$27","v":39804.987200000003},{"$f":"(D24+D25+D26)*$A$27","v":41702.249494560005},{"$f":"(E24+E25+E26)*$A$27","v":42605.096303999999},{"$f":"(F24+F25+F26)*$A$27","v":43798.285920000002},null,null,null,"Ciclo Escolar","2018-08-20","2019-07-15",{"$f":"+L27-K27","v":329}]
["Prima Total ",null,{"$f":"SUM(C24:C27)","v":288586.15720000002},{"$f":"SUM(D24:D27)","v":302341.30883555999},{"$f":"SUM(E24:E27)","v":308886.94820400001},{"$f":"SUM(F24:F27)","v":317537.57292000001}]
["Prima por Aseg. ",null,{"$f":"C28/Presentación!$D$13","v":288.87503223223223},{"$f":"D28/Presentación!$D$13","v":302.64395278834832},{"$f":"E28/Presentación!$D$13","v":309.19614434834835},{"$f":"F28/Presentación!$D$13","v":317.85542834834837}]
[]
[null,null,"Desglose de Pagos"]
[null,null,"CONTADO","SEMESTRAL","TRIMESTRAL","MENSUAL"]
[null,null,"Único Pago de","Primer Pago de","Primer Pago de","Primer Pago de"]
[null,null,{"$f":"C28","v":288586.15720000002},{"$f":"((((D24/2)*1.0473)+300)*(1+$A$27))","v":151344.65441778},{"$f":"((((E24/4)*1.07)+300)*(1+$A$27))","v":77482.737051000004},{"$f":"((((F24/12)*1.1)+300)*(1+$A$27))","v":26780.46441}]
[null,null,null,"Segundo Pago de","3 Pagos de","11 Pagos de"]
[null,null,null,{"$f":"((((D24/2)*1.0473))*(1+$A$27))","v":150996.65441778},{"$f":"((((E24/4))*1.07)*(1+$A$27))","v":77134.737051000004},{"$f":"((((F24/12))*1.1)*(1+$A$27))","v":26432.46441}]
[]
[null,null,"Comisión del Agente"]
[null,null,0.2]
[null,null,"Participación en el Cuaderno de Bonos y Concursos"]
[null,null,"SI"]
[]
[]
[]
[{"$f":"+Presentación!H19","v":129870000},{"$f":"B16","v":0.97147826086956535},{"$f":"+B45*(1-$C$11)","v":0.33516000000000001},{"$f":"+A45*B45/1000","v":126165.88173913045}]
[{"$f":"+Presentación!H20","v":129870000},{"$f":"B17","v":6.8173913043478265E-2},{"$f":"+B46*(1-$C$11)","v":2.3519999999999999E-2},{"$f":"+A46*B46/1000","v":8853.746086956522}]
[{"$f":"+Presentación!H21","v":49950000},2.2732463768115942,{"$f":"+B47*(1-$C$11)","v":0.78426999999999991},{"$f":"+A47*B47/1000","v":113548.65652173915}]
[null,135.85382608695653,{"$f":"+B48*(1-$C$11)","v":46.869569999999996},{"$f":"SUM(D45:D47)","v":248568.28434782612}]
[]
[{"$f":"+C50/Presentación!D13","v":140.11137835337652},{"$f":"+A45","v":129870000},{"$f":"+B50*D50/1000","v":139971.26697502314},{"$f":"+B45/J5*365","v":1.0777798334875117},{"$f":"+D50*(1-$C$11)","v":0.37183404255319152}]
[{"$f":"+C51/Presentación!D13","v":9.8323774283071259},{"$f":"+A46","v":129870000},{"$f":"+B51*D51/1000","v":9822.5450508788181},{"$f":"+B46/J5*365","v":7.5633672525439413E-2},{"$f":"+D51*(1-$C$11)","v":2.6093617021276595E-2}]
[{"$f":"+C52/Presentación!D13","v":126.09953306021761},{"$f":"+A47","v":49950000},{"$f":"+B52*D52/1000","v":125973.43352715739},{"$f":"+B47/J5*365","v":2.5219906612043523},{"$f":"+D52*(1-$C$11)","v":0.8700867781155015}]
[null,null,{"$f":"SUM(C50:C52)","v":275767.24555305933}]
[null,null,{"$f":"+C53/365*J5","v":248568.28434782609}]
[null,null,{"$f":"+F62*Presentación!D13","v":0},{"$f":"+C55+C54","v":248568.28434782609}]
[]
[]
["Anuales",null,null,"ciclo","anual","Asistencias anuales","Asistencias ciclo"]
[6,23,6,19,{"$f":"+D59/J5*365","v":21.079027355623101},{"$f":"+E59/(1-$C$11)","v":61.098630016298848},{"$f":"+F59/365*J5","v":55.072463768115952}]
[7,21,7,18.059999999999999,{"$f":"+D60/J5*365","v":20.036170212765956},{"$f":"+E60/(1-$C$11)","v":58.075855689176691},{"$f":"+F60/365*J5","v":52.347826086956523}]
[null,{"$f":"+B60+B59","v":44},null,{"$f":"+D60+D59","v":37.06},{"$f":"+E60+E59","v":41.115197568389057},{"$f":"+F60+F59","v":119.17448570547555},{"$f":"+G60+G59","v":107.42028985507247}]
[null,{"$f":"+B61/(1-C11)","v":127.53623188405798}]

{"sheet":"Presentación","index":2,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[[14,3,14,5],[15,1,15,2],[30,1,30,2],[28,1,28,2],[15,3,15,5],[22,3,22,4],[24,1,24,2],[29,1,29,2],[26,1,26,2],[24,5,24,6],[51,1,51,8],[34,1,34,2],[36,1,37,8],[41,1,41,8],[33,1,33,2],[45,1,45,8],[43,1,43,8],[39,1,39,8],[47,1,47,8],[44,1,44,8],[32,1,32,2],[25,1,25,2],[27,1,27,2],[13,1,13,2],[2,5,2,9],[4,8,4,9],[5,1,5,2],[9,1,9,2],[10,1,10,2],[10,3,10,5],[11,1,11,2],[12,1,12,2],[6,1,7,8],[12,3,12,5],[13,3,13,5],[14,1,14,2]]}
[]
[]
[null,null,null,null,null,"Cotización Accidentes Personales ESCOLAR 2018-2019"]
[]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-07-20"}]
[null,"NOMBRE DEL CLIENTE"]
[null,{"$f":"IF(DATOS!$E$6=\"NOMBRE DEL CONTRATANTE\",\"Ingrese el Nombre del Contratante\",DATOS!$E$6)","v":"SEGUROS BANORTE"}]
[]
[]
[null,"CONDICIONES"]
[null,"Póliza Nueva"]
[null,"Periodo Cubierto",null,{"$f":"+IF(DATOS!E10=\"Anual\",Calculo!K25,IF(DATOS!E10=\"Semestral\",Calculo!K26,Calculo!K27))","v":"2018-07-02"},{"$f":"+IF(DATOS!E10=\"Anual\",Calculo!L25,IF(DATOS!E10=\"Semestral\",Calculo!L26,Calculo!L27))","v":"2019-07-02"}]
[null,"No de Alumnos",null,{"$f":"IF(DATOS!$E$8=\"\",\"Ingresar el numero de alumnos\",DATOS!$E$8)","v":999}]
[null,"Ramo",null,30069]
[null,"Participación de Dividendos",null,"Sin Participación"]
[null,"Deducible en  Reembolso de Gastos Médicos",null,{"$f":"IF(DATOS!$E$20=\"\",\"Ingresar Deducible en Reembolso de G.M.\",IF(DATOS!$E$20=\"DEDUCIBLE EN REEMBOLSO DE GASTOS MÉDICOS\",\"Ingresar Deducible en Reembolso de G.M.\",DATOS!$E$20))","v":800}]
[]
[null,"Clave de Cobertura","Nombre de Cobertura","Edad Min.","Edad Max.","Regla de Suma Asegurada","No. de Aseg. por Cobertura","Suma Asegurada Total"]
[null,"MA","1 Muerte Accidental","3 Meses","70 Años",{"$f":"IF(DATOS!$E$14=\"SUMA ASEGURADA MUERTE ACCIDENTAL\",\"\",DATOS!E14)","v":130000},{"$f":"D13","v":999},{"$f":"IFERROR(G19*F19,\"\")","v":129870000}]
[null,"POA","2 Pérdidas Orgánicas \"A\"","3 Meses","70 Años",{"$f":"IF(DATOS!$E$16=\"SUMA ASEGURADA PARA PÉRDIDAS ORGÁNICAS\",\"\",DATOS!$E$16)","v":130000},{"$f":"G19","v":999},{"$f":"IFERROR(F20*G20,\"\")","v":129870000}]
[null,"RGM","11 Reembolso de Gastos Médicos por Accidente*","3 Meses","70 Años",{"$f":"IFERROR(IF(DATOS!$E$18>$F$19*0.5,\"S.A. INVALIDA\",DATOS!$E$18),\"\")","v":50000},{"$f":"G20","v":999},{"$f":"IFERROR(IF(F21>(F19*0.5),\"S.A  INVALIDA\",G21*F21),\"\")","v":49950000}]
[]
[null,"CUD","12 Cobertura de Urgencia Dental",{"$f":"IF(DATOS!$E$27=\"COBERTURA DE URGENCIAS DENTALES\",\"EXCLUIDA\",IF(DATOS!$E$26=\"SI\",\"AMPARADA\",\"EXCLUIDA\"))","v":"EXCLUIDA"}]
[]
[null,"COSTO DE COTIZACIÓN",null,null,null,"Forma de Pago",null,"Primer Recibo","Recibos Subsecuentes","Total"]
[null,"Prima Neta Total ",null,{"$f":"Calculo!C24","v":248581.17},null,"ANUAL",null,{"$f":"+D30","v":288586.15720000002},0,{"$f":"+I26+H26","v":288586.15720000002}]
[null,"Prima Neta por Asegurado",null,{"$f":"D26/D13","v":248.83},null,"SEMESTRAL    (Recargo 4.73%)",null,{"$f":"IF(J26<1000,\"\",(D26/2*(1+4.73%)+D28)*1.16)","v":151228.65441778},{"$f":"IF(J26<1000,\"\",(D26/2*(1+4.73%))*1.16)","v":150996.65441778},{"$f":"IFERROR(I27+H27,\"\")","v":302225.30883555999}]
[null,"Derecho de Póliza ",null,{"$f":"Calculo!C26","v":200},null,"TRIMESTRAL  (Recargo 7%)",null,{"$f":"IF(J26<1000,\"\",(D26/4*(1+7%)+D28)*1.16)","v":77366.737051000004},{"$f":"IF(J26<1000,\"\",(D26/4*(1+7%))*1.16)","v":77134.737051000004},{"$f":"IFERROR(I28*3+H28,\"\")","v":308770.94820400001}]
[null,"I.V.A. (16%)",null,{"$f":"Calculo!C27","v":39804.987200000003},null,"MENSUAL        (Recargo 10%) ",null,{"$f":"IF(J26<1000,\"\",(D26/12*(1+10%)+D28)*1.16)","v":26664.46441},{"$f":"IF(J26<1000,\"\",(D26/12*(1+10%))*1.16)","v":26432.46441},{"$f":"IFERROR(I29*11+H29,\"\")","v":317421.57292000001}]
[null,"Prima Total ",null,{"$f":"Calculo!C28","v":288586.15720000002}]
[null,"Prima Total por Asegurado",null,{"$f":"Calculo!C29","v":288.87503223223223}]
[]
[null,"Datos del Agente"]
[null,{"$f":"+DATOS!E22","v":211}]
[null,{"$f":"+DATOS!E24","v":"AGENTE"}]
[]
[null,"El presente ha sido elaborado con las bases enviadas para su cálculo, por lo que sólo es una propuesta de cotización, ya que para la emisión de la póliza se considerará, número de participantes, edad real o R.F.C.,  puesto y descripción de actividad, de lo contrario no será responsabilidad de la Compañía la aceptación del mismo."]
[]
[]
[null,"* Para la presente cotizaciòn aplica PAGO DIRECTO en Hospitales de convenio con Seguros Banorte para este producto (estancia mayor a 24 hrs)."]
[]
[null,"La presente cotización tiene una vigencia de 30 días."]
[]
[null,"La cobertura de Gastos Funerarios aplica para participantes de 3 meses a 11 años de edad."]
[null,"La cobertura de Muerte Accidental aplica para participantes de 12 a 70 años de edad."]
[null,"Se ofrece pago fraccionado exclusivamente para aquellas pólizas que rebasen los $1,000 pesos de Prima Total."]
[]
[null,"La protección que otorga este cobertura es exclusivamente para la actividad escolar.  La actividad escolar comprende desde el momento en que los asegurados inicien el viaje ininterrumpido de su casa a la escuela por cualquier medio de transporte, excepto en motocicleta o motoneta, su estancia en el edificio y/o predio de la escuela y el viaje ininterrumpido de regreso a su domicilio. Así mismo las excursiones, eventos deportivos y otras actividades, siempre que se encuentren organizadas y supervisadas por la autoridad de la escuela."]
[]
[null,"ESTA COTIZACION NO ES VÁLIDA PARA PÓLIZAS DE RENOVACIÓN"]
[]
[null,"* La presente cotización incluye la cobertura de asistencias."]
[null,"Tarifa vig. a partir del 01 de julio de 2018"]
[null,"Favor de anexar la presente cotización a su solicitud de Emisión.",null,null,null,null,null,null,null,null,"Ave. Hidalgo # 250 Pte. Zona Centro C.P.64000"]
[null,null,null,null,null,null,null,null,null,null,"Monterrey, Nuevo León T. 8122-0200"]
[null,{"$f":"CONCATENATE(B59,B60)","v":"000/1.1,0.9715/1.2,0.0682/1.11,2.2732/1.12,0000/R.1,0.3352/R.2,0.0235/R.11,0.7843/R.12,0"},null,null,null,null,null,null,null,null,"ESPACIO SB"]
[]
[]
[null,{"$f":"IFERROR(CONCATENATE(\"000/1.1,\",ROUND(Calculo!B45,4),\"/1.2,\",ROUND(Calculo!B46,4),\"/1.11,\",ROUND(Calculo!B47,4),\"/1.12,\",IF(D23=\"AMPARADA\",ROUND(Calculo!$B$19,4),0)),\"\")","v":"000/1.1,0.9715/1.2,0.0682/1.11,2.2732/1.12,0"}]
[null,{"$f":"IFERROR(CONCATENATE(\"000/R.1,\",ROUND(Calculo!C45,4),\"/R.2,\",ROUND(Calculo!C46,4),\"/R.11,\",ROUND(Calculo!C47,4),\"/R.12,\",IF(D23=\"AMPARADA\",ROUND(Calculo!$C$48,4),0)),\"\")","v":"000/R.1,0.3352/R.2,0.0235/R.11,0.7843/R.12,0"}]

{"sheet":"DATOS","index":3,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,2,13,3],[11,2,11,3],[5,2,5,3],[3,1,3,8],[7,2,7,3],[7,4,7,8],[9,2,9,3],[9,4,9,8],[27,2,27,8],[5,4,5,8],[11,4,11,8],[13,4,13,8],[15,4,15,8],[17,4,17,8],[19,2,19,3],[21,2,21,3],[23,2,23,3],[19,4,19,8],[21,4,21,8],[23,4,23,8],[25,2,25,3],[25,4,25,8],[17,2,17,3],[15,2,15,3]]}
[]
[null,null,null,null,null,null,null,"FOLIO:"]
[]
[null,"Cotización Accidentes Personales ESCOLAR 2018-2019 (Registro de Información)",null,null,null,null,null,null,null,null,null,null,null,null,null,"S.A. M.A.","S.A. RGM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10000,5000]
[null,"1.-","*Especifique el Nombre del Contratante:",null,"SEGUROS BANORTE",null,null,null,null,null,null,null,null,null,null,20000,10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30000,15000]
[null,"2.-","*Especifique el Numero de Alumnos:",null,999,null,null,null,null,null,null,null,null,null,null,40000,20000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000,25000]
[null,"3.-","*Especifique vigencia:",null,"Anual",null,null,null,null,null,null,null,null,null,null,60000,30000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70000,35000]
[null,"4.-","*Especifique fecha de inicio de vigencia:",null,"2018-07-02",null,null,null,null,null,null,null,null,null,null,80000,40000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90000,45000]
[null,"5.-","*Especifique la Suma Asegurada para Cobertura de Muerte Accidental",null,130000,null,null,null,null,null,null,null,null,null,null,100000,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110000,55000]
[null,"6.- ","*Suma Asegurada para Cobertura de Pérdidas Orgánicas",null,{"$f":"IF($E$14=\"SUMA ASEGURADA MUERTE ACCIDENTAL\",\"SUMA ASEGURADA PARA PÉRDIDAS ORGÁNICAS\",$E$14)","v":130000},null,null,null,null,null,null,null,null,null,null,120000,60000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130000,100000]
[null,"7.-",{"$f":"IF(Presentación!$F$21=\"S.A. INVALIDA\",\"LA SUMA ASEGURADA DE LA COBERTURA DE REEMBOLSO DE G.M. NO DEBE SER MAYOR AL 50% DE LA S.A. DE LA COBERTURA DE MUERTE ACCIDENTAL\",\"*Especifique la Suma Asegurada para Cobertura de Reembolso de Gastos Médicos por Accidente\")","v":"*Especifique la Suma Asegurada para Cobertura de Reembolso de Gastos Médicos por Accidente"},null,50000,null,null,null,null,null,null,null,null,null,null,140000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150000]
[null,"8.-","*Seleccione el Deducible en Reembolso de Gastos Médicos",null,800,null,null,null,null,null,null,null,null,null,null,160000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170000]
[null,"9.-","*Especifique el Numero de Agente",null,211,null,null,null,null,null,null,null,null,null,null,180000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190000]
[null,"10.- ","*Especifique el Nombre del Agente",null,"AGENTE",null,null,null,null,null,null,null,null,null,null,200000]
[]
[null,"11.- ","*Especifique si desea contratar la Cobertura Opcional de Urgencias Dentales.",null,"NO"]
[]
[null,null,{"$f":"IF(Calculo!O13=1,\"*DATOS REQUERIDOS PARA GENERAR PROPUESTA\",IF(C18=\"LA SUMA ASEGURADA DE LA COBERTURA DE REEMBOLSO DE G.M. NO DEBE SER MAYOR AL 50% DE LA S.A. DE LA COBERTURA DE MUERTE ACCIDENTAL\",\"LA S.A. DE REEMBOLSO DE G.M. POR ACCIDENTE NO ES VALIDA\",\"LA PROPUESTA ESTA LISTA PARA SU IMPRESION EN PDF\"))","v":"LA PROPUESTA ESTA LISTA PARA SU IMPRESION EN PDF"}]