{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DATOS","PRIMAS","cuadros"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":24,"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":"DATOS","index":0,"n_rows":188,"n_cols":18,"rows_kept":188,"cut":false,"hidden":false,"merged":[[8,1,8,2],[15,1,15,2],[22,1,22,2],[1,1,1,2],[19,1,19,2]]}
[]
[null,"COTIZACIÓN PARA POTENCIACIÓN Y/O INCLUSIÓN DE ASCENDIENTES"]
[null,"RECUERDA:  El monto de la suma que elijas potenciar será la misma para todos tus dependientes económicos"]
[null,"(cónyuge/CB/PMS*, hijos y/o ascendientes)."]
[null,null,null,null,null,null,null,null,null,null,"SELECCIONAR"]
[null,"Secretaría, Organismo Autónomo o Entidad","SECRETARIA, ORGANISMO AUTÓNOMO O ENTIDAD",null,null,null,"G*","G",333,"Secretario de Estado","G - Secretario de Estado"]
[null,"Número de Póliza",{"$f":"IFERROR(VLOOKUP(C6,$B$42:$C$188,2,FALSE),\"\")","v":""},null,null,null,"H","H",295,"Subsecretario de Estado","H - Subsecretario de Estado"]
[null,null,null,null,null,null,"I","I",295,"Oficial Mayor","I - Oficial Mayor"]
[null,"INFORMACIÓN DEL TITULAR",null,null,null,null,"J","J",295,"Jefe de Unidad","J - Jefe de Unidad"]
[null,"Nombre del Asegurado Titular",null,null,null,null,"K","K",259,"Director General","K - Director General"]
[null,"Nivel o Puesto","SELECCIONAR",null,null,{"$f":"VLOOKUP(LEFT((selec),1),$H$6:$H$15,1,0)","v":{"$error":"#N/A"}},"L","L",222,"Director General Adjunto","L - Director General Adjunto"]
[null,"Suma Asegurada Básica (Actual)",{"$f":"IFERROR(CONCATENATE(VLOOKUP(LEFT(C11),$H$6:$I$15,2,FALSE),\" UMAM\",\"   EQUIVALENTE A: $\",TEXT(ROUND(VLOOKUP(LEFT(C11),$H$6:$I$15,2,FALSE)*cuadros!$M$81,0),\"0,000\"),\" PESOS\"),\"Seleccionar Nivel o Puesto\")","v":"Seleccionar Nivel o Puesto"},null,null,null,"M","M",185,"Director de Área","M - Director de Área"]
[null,"Suma Asegurada de Potenciación solicitada","ESCOGER OPCIÓN",null,null,null,"N","N",148,"Subdirector de Área","N - Subdirector de Área"]
[null,"Suma Asegurada Potenciada",{"$f":"IFERROR(CONCATENATE( \"SUMA ASEGURADA DE POTENCIACIÓN EQUIVALE A: \",TEXT(C13*cuadros!$M$81,\"$000,000.00\"),\"  PESOS\"),\"\")","v":""},null,null,null,"O","O",111,"Jefe de Departamento","O - Jefe de Departamento"]
[null,null,null,null,null,null,"P","P",74,"Personal de Enlace  ","P - Personal de Enlace  "]
[null,"INDICAR NÚMERO"]
[null,"Cónyuge / CB / PMS*","INDICAR"]
[null,"Hijos hasta 25 años","INDICAR NÚMERO",null,null,null,null,null,null,"ESCOGER OPCIÓN","AÑO FISCAL"]
[null,null,null,null,null,null,null,null,null,74,2017]
[null,"SUMA ASEGURADA PARA ASCENDIENTES",null,null,null,"Si","INDICAR NÚMERO",null,null,111,2018]
[null,"Suma Asegurada","INDICAR SUMA ASEGURADA",null,null,"No",1,"INDICAR EDAD",null,148,2019]
[null,null,null,null,null,null,2,"Hasta 50 años",null,185]
[null,"INDICAR EDAD",null,null,null,null,3,"De 51 a 55 años"]
[null,"Padre","INDICAR EDAD",null,null,"Si",4,"De 56 a 60 años",null,111,2018]
[null,"Madre","INDICAR EDAD",null,null,"No",5,"De 61 a 65 años",null,148,2019]
[null,null,"Formato de fecha:            DD/MM/AAAA",null,null,null,6,"De 66 a 70 años",null,185]
[null,"Fecha de solicitud",null,null,null,null,7,"De 71 a 75 años",null,222]
[null,"Presentar primas para el año fiscal:",{"$f":"+IF(C27=\"\",\"\",YEAR(C27))","v":""},null,null,null,8,"De 76 a 80 años",null,259]
[null,"*CB Concubina    PMS Pareja del Mismo Sexo",{"$f":"+IF(OR(C27<D33,C27>D34),\"FECHA NO VÁLIDA\",\"\")","v":"FECHA NO VÁLIDA"},null,null,null,9,"De 81 a 85 años",null,295]
[null,null,null,null,null,null,10,null,null,333]
[null,null,null,null,null,null,null,null,null,444]
[null,null,null,null,null,null,null,null,null,592]
[null,null,null,"2017-11-16",null,null,null,null,null,740]
[null,null,null,"2018-06-30",null,null,null,null,null,850]
[null,null,null,null,null,null,null,null,null,1000]
[null,null,null,null,null,null,"SA",null,null,"Sin Límite"]
[null,null,null,null,null,null,333]
[null,null,null,null,null,null,295]
[null,null,null,null,null,null,295]
[null,null,null,null,null,null,295,"SELECCIONAR","P","O","N","M","L","K","H","I","J","G"]
[null,"SECRETARIA, ORGANISMO AUTÓNOMO O ENTIDAD","POLIZA ORIGINAL",null,null,null,259,"G",74,111,148,185,222,259,295,295,295,333]
[null,"PRESIDENCIA DE LA REPUBLICA","GM6001",null,null,null,222,"H",111,148,185,222,259,295,333,333,333,444]
[null,"SECRETARIA DE GOBERNACION ","GM6002",null,null,null,185,"I",148,185,222,259,295,333,444,444,444,592]
[null,"SECRETARIA DE RELACIONES EXTERIORES","GM6003",null,null,null,148,"J",185,222,259,295,333,444,592,592,592,740]
[null,"SECRETARIA DE HACIENDA Y CREDITO PUBLICO","GM6004",null,null,null,111,"K",222,259,295,333,444,592,740,740,740,850]
[null,"SECRETARIA DE AGRICULTURA, GANADERIA, DESARROLLO RURAL, PESCA Y ALIMENTACION","GM6005",null,null,null,74,"L",259,295,333,444,592,740,850,850,850,1000]
[null,"SECRETARIA DE COMUNICACIONES Y TRANSPORTES","GM6006",null,null,null,null,"M",295,333,444,592,740,850,1000,1000,1000,34219]
[null,"SECRETARIA DE ECONOMIA ","GM6007",null,null,null,null,"N",333,444,592,740,850,1000,34219,34219,34219]
[null,"SECRETARIA DE EDUCACION PUBLICA","GM6008",null,null,null,null,"O",444,592,740,850,1000,34219]
[null,"SECRETARIA DE SALUD","GM6009",null,null,null,null,"P",592,740,850,1000,34219]
[null,"SECRETARIA DE MARINA","GM6010",null,null,null,null,null,740,850,1000,34219]
[null,"SECRETARIA DEL TRABAJO Y PREVISION SOCIAL ","GM6011",null,null,null,null,null,850,1000,34219]
[null,"SECRETARIA DE DESARROLLO AGRARIO, TERRITORIAL Y URBANO","GM6012",null,null,null,null,null,1000,34219]
[null,"SECRETARIA DE MEDIO AMBIENTE Y RECURSOS NATURALES","GM6013",null,null,null,null,null,34219]
[null,"PROCURADURIA GENERAL DE LA REPUBLICA ","GM6014"]
[null,"SECRETARIA DE ENERGIA ","GM6015"]
[null,"SECRETARIA DE DESARROLLO SOCIAL","GM6016"]
[null,"SECRETARIA DE TURISMO","GM6017"]
[null,"SECRETARIA DE LA FUNCIÓN PUBLICA ","GM6018"]
[null,"TRIBUNAL SUPERIOR AGRARIO","GM6019"]
[null,"CONSEJERIA JURIDICA DEL EJECUTIVO FEDERAL","GM6020"]
[null,"COMISION REGULADORA DE ENERGIA","GM6021"]
[null,"COMISION NACIONAL DE HIDROCARBUROS","GM6022"]
[null,"SECRETARIA DE GOBERNACION ORGANO ADMINISTRATIVO DESCONCENTRADO PREVENCION Y READAPTACION SOCIAL","GM6023"]
[null,"SECRETARIA DE GOBERNACION ORGANO ADMINISTRATIVO DESCONCENTRADO POLICIA FEDERAL","GM6024"]
[null,"SERVICIO DE PROTECCION FEDERAL","GM6025"]
[null,"COMISION NACIONAL BANCARIA Y DE VALORES","GM6026"]
[null,"COMISION NACIONAL DE SEGUROS Y FIANZAS","GM6027"]
[null,"COMISION NACIONAL DEL SISTEMA DE AHORRO PARA EL RETIRO","GM6028"]
[null,"SERVICIO DE ADMINISTRACION TRIBUTARIA","GM6029"]
[null,"SERVICIO NACIONAL DE SANIDAD, INOCUIDAD Y CALIDAD AGROALIMENTARIA","GM6030"]
[null,"SERVICIO NACIONAL DE INSPECCION Y CERTIFICACION DE SEMILLAS","GM6031"]
[null,"COLEGIO SUPERIOR AGROPECUARIO DEL ESTADO DE GUERRERO","GM6032"]
[null,"AGENCIA DE SERVICIOS A LA COMERCIALIZACION Y DESARROLLO DE MERCADOS AGROPECUARIOS","GM6033"]
[null,"SERVICIO DE INFORMACION AGROALIMENTARIA Y PESQUERA","GM6034"]
[null,"COMISION NACIONAL DE ACUACULTURA Y PESCA","GM6035"]
[null,"INSTITUTO MEXICANO DEL TRANSPORTE","GM6036"]
[null,"SERVICIOS A LA NAVEGACION EN EL ESPACIO AEREO MEXICANO","GM6037"]
[null,"COMISION FEDERAL DE MEJORA REGULATORIA","GM6038"]
[null,"UNIVERSIDAD PEDAGOGICA NACIONAL","GM6039"]
[null,"INSTITUTO POLITECNICO NACIONAL","GM6040"]
[null,"ADMINISTRACION FEDERAL DE SERVICIOS EDUCATIVOS EN EL DISTRITO FEDERAL","GM6041"]
[null,"SECRETARIA DE CULTURA","GM6042"]
[null,"PROCURADURIA FEDERAL DE LA DEFENSA DEL TRABAJO","GM6043"]
[null,"COMITE NACIONAL MIXTO DE PROTECCION AL SALARIO","GM6044"]
[null,"REGISTRO AGRARIO NACIONAL","GM6045"]
[null,"COMISION NACIONAL DEL AGUA","GM6046"]
[null,"PROCURADURIA FEDERAL DE PROTECCION AL AMBIENTE","GM6047"]
[null,"SECRETARIA DE MEDIO AMBIENTE Y RECURSOS NATURALES COMISION NACIONAL DE AREAS NATURALES PROTEGIDAS","GM6048"]
[null,"AGENCIA NACIONAL DE SEGURIDAD INDUSTRIAL Y DE PROTECCION AL MEDIO AMBIENTE DEL SECTOR HIDROCARBUROS","GM6049"]
[null,"COMISION NACIONAL DE SEGURIDAD NUCLEAR Y SALVAGUARDIAS","GM6050"]
[null,"COMISION NACIONAL PARA EL USO EFICIENTE DE LA ENERGIA","GM6051"]
[null,"INSTITUTO NACIONAL DE DESARROLLO SOCIAL","GM6052"]
[null,"COORDINACION NACIONAL DE PROSPERA PROGRAMA NACIONAL DE INCLUSION SOCIAL","GM6053"]
[null,"INSTITUTO NACIONAL DE LA ECONOMIA SOCIAL","GM6054"]
[null,"INSTITUTO DE ADMINISTRACION Y AVALUOS Y BIENES NACIONALES","GM6055"]
[null,"TALLERES GRAFICOS DE MEXICO","GM6056"]
[null,"ARCHIVO GENERAL DE LA NACION","GM6057"]
[null,"CONSEJO NACIONAL PARA PREVENIR LA DISCRIMINACION","GM6058"]
[null,"FINANCIERA NACIONAL DE DESARROLLO AGROPECUARIO, RURAL, FORESTAL Y PESQUERO","GM6059"]
[null,"INSTITUTO DE SEGURIDAD SOCIAL PARA LAS FUERZAS ARMADAS MEXICANAS","GM6060"]
[null,"COMISION NACIONAL DE LAS ZONAS ARIDAS","GM6062"]
[null,"INSTITUTO NACIONAL DE INVESTIGACIONES FORESTALES, AGRICOLAS Y PECUARIAS","GM6063"]
[null,"INSTITUTO NACIONAL DE PESCA","GM6064"]
[null,"INSTITUTO NACIONAL PARA EL DESARROLLO DE CAPACIDADES DEL SECTOR RURAL, A.C.","GM6065"]
[null,"FIDEICOMISO DE RIESGO COMPARTIDO","GM6066"]
[null,"FONDO DE EMPRESAS EXPROPIADAS DEL SECTOR AZUCARERO","GM6067"]
[null,"CAMINOS Y PUENTES FEDERALES DE INGRESOS Y SERVICIOS CONEXOS","GM6068"]
[null,"GRUPO AEROPORTUARIO DE LA CIUDAD DE MEXICO S.A. DE C.V.","GM6069"]
[null,"CENTRO NACIONAL DE METROLOGIA","GM6070"]
[null,"PROCURADURIA FEDERAL DEL CONSUMIDOR ","GM6071"]
[null,"FIDEICOMISO DE FOMENTO MINERO","GM6072"]
[null,"PROMEXICO","GM6073"]
[null,"COMISION  DE OPERACION  Y  FOMENTO DE ACTIVIDADES ACADEMICAS DEL IPN","GM6074"]
[null,"COMISION NACIONAL DE CULTURA FISICA Y DEPORTE","GM6075"]
[null,"COMISION NACIONAL DE LOS LIBROS DE TEXTO GRATUITOS","GM6076"]
[null,"INSTITUTO NACIONAL PARA LA EDUCACION DE LOS ADULTOS","GM6077"]
[null,"INSTITUTO NACIONAL DE LENGUAS INDIGENAS","GM6078"]
[null,"INSTITUTO MEXICANO DE CINEMATOGRAFIA","GM6079"]
[null,"INSTITUTO NACIONAL DE LA INFRAESTRUCTURA FISICA EDUCATIVA","GM6080"]
[null,"PATRONATO DE OBRAS E INSTALACIONES DEL INSTITUTO POLITECNICO NACIONAL","GM6081"]
[null,"ESTUDIOS CHURUBUSCO AZTECA, S.A.","GM6082"]
[null,"TELEVISION METROPOLITANA, S.A. DE C.V. ","GM6083"]
[null,"FIDEICOMISO DE LOS SISTEMAS NORMALIZADO DE COMPETENCIA LABORAL Y CERTIFICACION DE COMPETENCIA LABORAL","GM6084"]
[null,"BANCO NACIONAL DE OBRAS Y SERVICIOS PUBLICOS, S.N.C. FIDEICOMISO PARA LA CINETECA NACIONAL","GM6085"]
[null,"CENTRO REGIONAL DE ALTA ESPECIALIDAD DE CHIAPAS","GM6086"]
[null,"INSTITUTO NACIONAL DE PSIQUIATRIA RAMON DE LA FUENTE MUÑIZ","GM6087"]
[null,"HOSPITAL JUAREZ DE MEXICO","GM6088"]
[null,"HOSPITAL GENERAL DR. MANUEL GEA GONZALEZ","GM6089"]
[null,"HOSPITAL GENERAL DE MEXICO DR EDUARDO LICEAGA","GM6090"]
[null,"HOSPITAL INFANTIL DE MEXICO FEDERICO GOMEZ","GM6091"]
[null,"HOSPITAL REGIONAL DE ALTA ESPECIALIDAD DEL BAJIO","GM6092"]
[null,"HOSPITAL REGIONAL DE ALTA ESPECIALIDAD DE OAXACA","GM6093"]
[null,"HOSPITAL REGIONAL DE ALTA ESPECIALIDAD DE LA PENINSULA DE YUCATAN","GM6094"]
[null,"HOSPITAL REGIONAL DE ALTA ESPECIALIDAD DE CIUDAD VICTORIA BICENTENARIO 2010","GM6095"]
[null,"HOSPITAL REGIONAL DE ALTA ESPECIALIDAD DE IXTAPALUCA","GM6096"]
[null,"INSTITUTO NACIONAL DE CANCEROLOGIA","GM6097"]
[null,"INSTITUTO NACIONAL DE CARDIOLOGIA IGNACIO CHAVEZ","GM6098"]
[null,"INSTITUTO NACIONAL DE ENFERMEDADES RESPIRATORIAS ISMAEL COSIO VILLEGAS","GM6099"]
[null,"INSTITUTO NACIONAL DE GERIATRIA","GM6100"]
[null,"INSTITUTO NACIONAL DE CIENCIAS MEDICAS Y NUTRICION SALVADOR ZUBIRAN","GM6101"]
[null,"INSTITUTO NACIONAL DE MEDICINA GENOMICA","GM6102"]
[null,"INSTITUTO NACIONAL DE NEUROLOGIA Y NEUROCIRUGIA MANUEL VELASCO SUAREZ","GM6103"]
[null,"INSTITUTO NACIONAL DE PEDIATRIA","GM6104"]
[null,"INSTITUTO NACIONAL DE PERINATOLOGIA ISIDRO ESPINOSA DE LOS REYES","GM6105"]
[null,"INSTITUTO NACIONAL DE REHABILITACION","GM6106"]
[null,"INSTITUTO NACIONAL DE SALUD PUBLICA","GM6107"]
[null,"SISTEMA NACIONAL PARA EL DESARROLLO INTEGRAL DE LA FAMILIA","GM6108"]
[null,"CENTROS DE INTEGRACION JUVENIL, A.C.","GM6109"]
[null,"COMISION NACIONAL DE SALARIOS MINIMOS ","GM6110"]
[null,"COMISION NACIONAL DE VIVIENDA","GM6111"]
[null,"PROCURADURIA AGRARIA","GM6112"]
[null,"FIDEICOMISO FONDO NACIONAL DE HABITACIONES POPULARES","GM6113"]
[null,"COMISION NACIONAL FORESTAL","GM6114"]
[null,"INSTITUTO MEXICANO DE TECNOLOGIA DEL AGUA","GM6115"]
[null,"INSTITUTO NACIONAL DE ECOLOGIA Y CAMBIO CLIMATICO","GM6116"]
[null,"INSTITUTO NACIONAL DE CIENCIAS PENALES","GM6117"]
[null,"CENTRO NACIONAL DE CONTROL DEL GAS NATURAL","GM6118"]
[null,"INSTITUTO NACIONAL DE LAS PERSONAS ADULTAS MAYORES","GM6119"]
[null,"CONSEJO NACIONAL DE EVALUACION DE LA POLITICA DE DESARROLLO SOCIAL","GM6120"]
[null,"DICONSA, S.A. DE C.V.","GM6121"]
[null,"FONDO NACIONAL PARA EL FOMENTO DE LAS ARTESANIAS","GM6122"]
[null,"FONATUR CONSTRUCTORA, S.A. DE C.V.","GM6123"]
[null,"CONSEJO DE PROMOCION TURISTICA DE MEXICO, S.A. DE C.V.","GM6124"]
[null,"FONATUR MANTENIMIENTO TURISTICO, S.A. DE. C.V.","GM6125"]
[null,"FONATUR OPERADORA PORTUARIA, S.A. DE C.V.","GM6126"]
[null,"FONDO NACIONAL DE FOMENTO AL TURISMO","GM6127"]
[null,"COMISION NACIONAL PARA EL DESARROLLO DE LOS PUEBLOS INDIGENAS","GM6128"]
[null,"NOTIMEX, AGENCIA DE NOTICIAS DEL ESTADO MEXICANO","GM6129"]
[null,"PROCURADURIA DE LA DEFENSA DEL CONTRIBUYENTE","GM6130"]
[null,"COMISION EJECUTIVA DE ATENCION A VICTIMAS","GM6131"]
[null,"SISTEMA PUBLICO DE RADIODIFUSION DEL ESTADO MEXICANO","GM6132"]
[null,"INSTITUTO NACIONAL DE LAS MUJERES","GM6133"]
[null,"INSTITUTO NACIONAL DE ESTADISTICA Y GEOGRAFIA","GM6134"]
[null,"COMISION FEDERAL DE COMPETENCIA ECONOMICA","GM6135"]
[null," INSTITUTO NACIONAL PARA LA EVALUACION DE LA EDUCACION","GM6136"]
[null,"INSTITUTO FEDERAL DE TELECOMUNICACIONES","GM6137"]
[null,"INSTITUTO NACIONAL DE TRANSPARENCIA, ACCESO A LA INFORMACION Y PROTECCION DE DATOS PERSONALES","GM6138"]
[null,"AGENCIA REGULADORA DE TRANSPORTE FERROVIARIO","GM6139"]
[null,"RADIO EDUCACION","GM6140"]
[null,"SECRETARIA DE CULTURA (Colect INDAUTOR)","GM6141"]
[null,"SECRETARIA DE CULTURA (Colect INEHRM)","GM6142"]
[null,"CONSEJO NACIONAL PARA EL DESARROLLO Y LA INCLUSION DE LAS PERSONAS CON DISCAPACIDAD","GM6143"]
[null,"AUTORIDAD FEDERAL PARA EL DESARROLLO DE LAS ZONAS ECONOMICAS ESPECIALES","GM6144"]
[null,"SECRETARIA EJECUTIVA DEL SISTEMA NACIONAL ANTICORRUPCION","GM6145"]
[null,"AGENCIA ESPACIAL MEXICANA","GM6146"]
[null,"CENTRO NACIONAL DE CONTROL DE ENERGIA","GM6147"]
[null,"ORGANISMO PROMOTOR DE INVERSIONES EN TELECOMUNICACIONES","GM6148"]

{"sheet":"PRIMAS","index":1,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":false,"merged":[[50,7,50,9],[49,7,49,9],[14,7,14,8],[15,7,15,8],[14,1,14,2],[15,1,15,2],[48,7,48,9],[47,7,47,9],[16,1,16,2]]}
[]
[]
[]
[]
[null,{"$f":"DATOS!C6","v":"SECRETARIA, ORGANISMO AUTÓNOMO O ENTIDAD"}]
[null,{"$f":"DATOS!C7","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(B11=\"\",\"REGRESA Y REVISA LAS OPCIONES\",\"\"),\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"TITULAR:  \",DATOS!C10)","v":"TITULAR:  "}]
[null,{"$f":"CONCATENATE(\"NIVEL Y PUESTO:  \",DATOS!C11)","v":"NIVEL Y PUESTO:  SELECCIONAR"},null,null,null,{"$f":"IF(Q15=0,\"SELECCIONA EL BOTON DE BORRAR\",\"\")","v":""}]
[]
[null,{"$f":"IFERROR(IF(Q15<D15,\"\",IF(AND(D26>0,D32>0),\"POTENCIACIÓN  E INCLUSIÓN DE ASCENDIENTES\",IF(D26>0,\"POTENCIACIÓN\",\"INCLUSIÓN DE ASCENDIENTES\"))),\"\")","v":"POTENCIACIÓN"},null,null,null,null,{"$f":"IFERROR(CONCATENATE(\"PRIMAS CORRESPONDIENTES AL AÑO FISCAL \",YEAR(J15)),\"\")","v":""}]
[]
[null,"Condiciones Solilcitadas"]
[]
[null,"S.A. Básica:",null,{"$f":"IFERROR(VALUE(LEFT(DATOS!C12,3)),\"\")","v":""},"(1)",{"$f":"IFERROR(D15*cuadros!$M$81,\"\")","v":""},null,"Fecha Inicio:",null,{"$f":"IF(OR(DATOS!C29=\"FECHA NO VÁLIDA\",DATOS!C27=\"DD/MM/AAAA\"),\"REVISAR FECHA O AÑO FISCAL EN DATOS\",IF(DATOS!C28=YEAR(DATOS!C27),DATOS!C27,IF(DATOS!C28=2017,DATE(2017,1,1),DATE(2017,1,1))))","v":"REVISAR FECHA O AÑO FISCAL EN DATOS"},null,null,null,null,null,null,{"$f":"DATOS!C13","v":"ESCOGER OPCIÓN"}]
[null,"S.A. Potenciada:",null,{"$f":"IF(Q15<D15,\"REVISAR\",IF(Q15=D15,\"NO APLICA\", Q15))","v":"ESCOGER OPCIÓN"},null,{"$f":"IFERROR(IF(Q15<=D15,\" \",IF(Q15=\"SIN LÍMITE\",\"SIN LÍMITE\",Q15*cuadros!M81)),\"\")","v":""},null,"Fecha Término:",null,{"$f":"+IF(DATOS!C28=2017,DATE(2017,12,31),IF(DATOS!C28=2018,DATE(2018,12,31),DATE(2019,5,15)))","v":"2019-05-15"},null,null,null,null,null,null,{"$f":"DATOS!C21","v":"INDICAR SUMA ASEGURADA"}]
[null,"S.A. Potenciada de Ascendientes:",null,{"$f":"IF(R20<2,\"\",Q17)","v":""},null,{"$f":"IFERROR(D17*cuadros!$M$81,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"DATOS!C21","v":"INDICAR SUMA ASEGURADA"},{"$f":"IF(Q17=\"INDICAR SUMA ASEGURADA\",\"0\",\"1\")","v":"0"}]
[null,null,{"$f":"IFERROR(IF(OR(cuadros!M77=1,cuadros!M77=16),\" \",CONCATENATE(\"Días quincena incompleta (primera):   \",cuadros!M79)),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(CONCATENATE(\"Número de Quincenas completas:     \",cuadros!M78),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"DATOS!C24","v":"INDICAR EDAD"},{"$f":"IF(Q18=\"INDICAR EDAD\",\"0\",\"1\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATOS!C25","v":"INDICAR EDAD"},{"$f":"IF(Q19=\"INDICAR EDAD\",\"0\",\"1\")","v":"0"}]
[null,"POTENCIACIÓN:  Prima por Asegurado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R17+R18+R19","v":0}]
[]
[null,"Parentesco",null,"Número de\nAsegurados",null,{"$f":"IFERROR(IF(cuadros!M79=0,\"\",\"Descuento Primera Quincena\"),\"\")","v":""},null,{"$f":"IFERROR(IF(cuadros!M79=0,\"Descuento Quincenal\",\"Descuento Quincenas subsecuentes\"),\"\")","v":""},null,"Prima por el Periodo de vigencia"]
[null,"Titular",null,{"$f":"IF(Q15<=D15,\"\",1)","v":1},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",IF(cuadros!M79=0,\"\",H23/15*cuadros!M79)),\"\")","v":""},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",VLOOKUP($D$15,cuadros!$A$15:$N$22,VLOOKUP($Q$15,cuadros!$A$72:$B$85,2))),\"\")","v":""},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",IF(cuadros!M79=0,H23*cuadros!M78,F23+(H23*cuadros!O78))),\"\")","v":""},null,null,null,null,null,null,"Edad"]
[null,{"$f":"CONCATENATE(\"Cónyuge /CB / PMS \")","v":"Cónyuge /CB / PMS "},null,{"$f":"IF(Q15<=D15,\"\",IF(OR(Q24=0,Q24=Q40,Q24=Q41),0,1))","v":0},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",IF(cuadros!M79=0,\"\",H24/15*cuadros!M79)),\"\")","v":""},null,{"$f":"IF(OR(D24=0,D24=\"\"),0,IF(Q15<=D15,0,VLOOKUP(D15,cuadros!$A$25:$N$33,VLOOKUP($Q$15,cuadros!$A$72:$B$85,2))))","v":0},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",IF(cuadros!M79=0,H24*cuadros!M78,F24+(H24*cuadros!O78))),\"\")","v":""},null,null,null,null,null,null,{"$f":"DATOS!C17","v":"INDICAR"}]
[null,"Hijos hasta 25 años",null,{"$f":"IF(Q15<=D15,\"\",IF(OR(Q25=0,Q25=S40),0,Q25))","v":0},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",IF(cuadros!M79=0,\"\",H25/15*cuadros!M79)),\"\")","v":""},null,{"$f":"IF(Q15<=D15,\"\",(IF(D25>0,VLOOKUP(D15,cuadros!$A$46:$N$53,VLOOKUP($Q$15,cuadros!$A$72:$B$85,2)),0))*D25)","v":0},null,{"$f":"IFERROR(IF(Q15<=D15,\"\",IF(cuadros!M79=0,H25*cuadros!M78,F25+(H25*cuadros!O78))),\"\")","v":""},null,null,null,null,null,null,{"$f":"DATOS!C18","v":"INDICAR NÚMERO"}]
[null,"POTENCIACIÓN",null,{"$f":"SUM(D23:D25)","v":1},null,{"$f":"IFERROR(IF(cuadros!M79=0,\"\",SUM(F23:F25)),\"\")","v":""},null,{"$f":"SUM(H23:H25)","v":0},null,{"$f":"SUM(J23:J25)","v":0}]
[]
[null,"INCLUSIÓN DE ASCENDIENTES:  Prima por Asegurado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATOS!$C$21","v":"INDICAR SUMA ASEGURADA"}]
[]
[null,{"$f":"CONCATENATE(\"Padre del Titular (\",Q30,\")\")","v":"Padre del Titular (INDICAR EDAD)"},null,{"$f":"IF(OR(Q15<D15,Q30=0,Q30=R40,Q30=R41),0,1)","v":0},null,{"$f":"IFERROR(IF(D30=\"\",0,IF(cuadros!M79=0,0,H30/15*cuadros!M79)),\"\")","v":""},null,{"$f":"IF(D30=\"\",\"\",IF(Q30=R48,VLOOKUP(Q28,ASCENDIENTES,2),IF(Q30=R49,VLOOKUP(Q28,ASCENDIENTES,3),IF(Q30=R50,VLOOKUP(Q28,ASCENDIENTES,4),IF(Q30=R51,VLOOKUP(Q28,ASCENDIENTES,5),IF(Q30=R52,VLOOKUP(Q28,ASCENDIENTES,6),IF(Q30=R53,VLOOKUP(Q28,ASCENDIENTES,7),IF(Q30=R54,VLOOKUP(Q28,ASCENDIENTES,8),IF(Q30=R55,VLOOKUP(Q28,ASCENDIENTES,9),)))))))))","v":0},null,{"$f":"IFERROR(IF(D30=\"\",\"\",IF(cuadros!M79=0,H30*cuadros!M78,F30+(H30*cuadros!O78))),0)","v":0},null,null,null,null,null,null,{"$f":"DATOS!C24","v":"INDICAR EDAD"}]
[null,{"$f":"CONCATENATE(\"Madre del Titular (\",Q31,\")\")","v":"Madre del Titular (INDICAR EDAD)"},null,{"$f":"IF(OR(Q15<D15,Q31=0,Q31=R40,Q31=R41),0,1)","v":0},null,{"$f":"IFERROR(IF(D31=\"\",0,IF(cuadros!M79=0,0,H31/15*cuadros!M79)),\"\")","v":""},null,{"$f":"IF(D31=\"\",\"\",IF(Q31=R48,VLOOKUP(Q28,ASCENDIENTES,2),IF(Q31=R49,VLOOKUP(Q28,ASCENDIENTES,3),IF(Q31=R50,VLOOKUP(Q28,ASCENDIENTES,4),IF(Q31=R51,VLOOKUP(Q28,ASCENDIENTES,5),IF(Q31=R52,VLOOKUP(Q28,ASCENDIENTES,6),IF(Q31=R53,VLOOKUP(Q28,ASCENDIENTES,7),IF(Q31=R54,VLOOKUP(Q28,ASCENDIENTES,8),IF(Q31=R55,VLOOKUP(Q28,ASCENDIENTES,9),)))))))))","v":0},null,{"$f":"IFERROR(IF(D31=\"\",\"\",IF(cuadros!M79=0,H31*cuadros!M78,F31+(H31*cuadros!O78))),0)","v":0},null,null,null,null,null,null,{"$f":"DATOS!C25","v":"INDICAR EDAD"}]
[null,"ASCENDIENTES",null,{"$f":"SUM(D30:D31)","v":0},null,{"$f":"IFERROR(IF(cuadros!M79=0,\"\",SUM(F30:F31)),\"\")","v":""},null,{"$f":"SUM(H30:H31)","v":0},null,{"$f":"IF(U15=H15,J30+J31,SUM(J30:J31))","v":0}]
[]
[null,"Resumen:"]
[]
[null,null,"Número de Asegurados:",null,null,null,null,null,null,{"$f":"D26+D32","v":1}]
[null,null,{"$f":"IFERROR(IF(cuadros!M79=0,\"\",\"Descuento Primera Quincena\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(IF(cuadros!M79=0,\"\",F26+F32),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(cuadros!M79=0,\"Descuento Quincenal\",\"Descuento Quincenas subsecuentes\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"H26+H32","v":0}]
[null,"**",{"$f":"IFERROR(CONCATENATE(\"Prima Total a cargo del Asegurado Titular \",\": \"),\"\")","v":"Prima Total a cargo del Asegurado Titular : "},null,null,null,null,null,null,{"$f":"J26+J32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDICAR","INDICAR EDAD","INDICAR Número"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No se solicita"]
[null,"Para que surta efectos la Potenciación y/o inclusión de ascendientes, es importante presentar esta hoja al área de Recursos Humanos"]
[null,"para la  autorización del descuento en nómina."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(DATOS!C10=\"\",\"\",DATOS!C10)","v":""},null,null,null,null,null,null,null,null,null,"Hasta 50 años"]
[null,null,null,null,null,null,null,"Nombre y firma del Titular",null,null,null,null,null,null,null,null,null,"De 51 a 55 años"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De 56 a 60 años"]
[null,null,null,null,null,null,null,"Fecha de aceptación",null,null,null,null,null,null,null,null,null,"De 61 a 65 años"]
[null,"Notas:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De 66 a 70 años"]
[null,"Los costos presentados incluyen I.V.A. (16%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De 71 a 75 años"]
[null,{"$f":"CONCATENATE(\"(1)  UMAM =  \",\"\"&TEXT(2450.24,\"$#,##0.00\")&\"\",\" (vigente en 2018)\")","v":"(1)  UMAM =  $2,450.24 (vigente en 2018)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De 76 a 80 años"]
[null,"*CB Concubina    PMS Pareja del Mismo Sexo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De 81 a 85 años"]
[null,"**La Prima Total a cargo del Asegurado Titular pudiera tener variación en centavos"]

{"sheet":"cuadros","index":2,"n_rows":95,"n_cols":22,"rows_kept":95,"cut":false,"hidden":true,"merged":[]}
[]
["NIVELES"]
[74,"P","Personal de Enlace"]
[111,"O","Jefe de Departamento"]
[148,"N","Subdirector de Área"]
[185,"M","Director de Área"]
[222,"L","Director General Adjunto"]
[259,"K","Director General"]
[266.39999999999998,"CS","Conyuge Supérstite"]
[295,"H, I, J","Subsecretario, Oficial Mayor, Jefe de Unidad"]
[333,"G","Secretario de Estado"]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["titulares",111,148,185,222,259,295,333,444,592,740,850,1000,34219]
[74,13.919999999999998,24.36,33.64,41.76,47.559999999999995,51.04,55.679999999999993,85.839999999999989,96.279999999999987,106.72,151.95999999999998,160.07999999999998,397.88]
[111,"",10.44,19.72,27.839999999999996,33.64,37.119999999999997,59.16,71.92,84.679999999999993,93.96,147.32,155.44,393.23999999999995,null,440.8,null,{"$f":"+P16/15*6","v":176.32}]
[148,"","",9.2799999999999994,18.559999999999999,24.36,28.999999999999996,52.199999999999996,66.11999999999999,78.88,89.32,153.11999999999998,162.39999999999998,380.47999999999996]
[185,"","","",9.2799999999999994,16.239999999999998,20.88,45.239999999999995,60.319999999999993,75.399999999999991,85.839999999999989,160.07999999999998,168.2,382.79999999999995]
[222,"","","","",6.9599999999999991,11.6,35.96,51.04,64.959999999999994,75.399999999999991,154.28,162.39999999999998,359.59999999999997]
[259,"","","","","",4.6399999999999997,30.159999999999997,44.08,57.999999999999993,69.599999999999994,149.63999999999999,157.76,339.88]
[295,"","","","","","",17.399999999999999,26.68,35.96,44.08,97.44,103.24,215.76]
[333,"","","","","","","",24.36,33.64,40.599999999999994,95.11999999999999,99.759999999999991,212.27999999999997]
[]
["Conyuges <=70",111,148,185,222,259,295,333,444,592,740,850,1000,34219]
[74,13.919999999999998,25.52,33.64,41.76,47.559999999999995,52.199999999999996,55.679999999999993,69.599999999999994,81.199999999999989,89.32,126.44,133.39999999999998,332.91999999999996]
[111,"",11.6,19.72,27.839999999999996,33.64,38.279999999999994,41.76,55.679999999999993,67.28,75.399999999999991,118.32,125.27999999999999,329.44,null,351.48,null,{"$f":"+P26/15*6","v":140.59200000000001}]
[148,"","",8.1199999999999992,18.559999999999999,24.36,28.999999999999996,33.64,46.4,59.16,69.599999999999994,117.16,125.27999999999999,293.47999999999996]
[185,"","","",9.2799999999999994,16.239999999999998,20.88,25.52,40.599999999999994,54.519999999999996,63.8,118.32,125.27999999999999,284.2]
[222,"","","","",6.9599999999999991,11.6,16.239999999999998,31.319999999999997,44.08,54.519999999999996,110.19999999999999,115.99999999999999,257.52]
[259,"","","","","",4.6399999999999997,9.2799999999999994,24.36,38.279999999999994,47.559999999999995,102.08,107.88,233.16]
[266.39999999999998,"","","","","",4.6399999999999997,6.9599999999999991,22.04,34.799999999999997,45.239999999999995,98.6,104.39999999999999,221.55999999999997]
[295,"","","","","","",3.4799999999999995,12.76,22.04,28.999999999999996,63.8,68.44,142.67999999999998]
[333,"","","","","","","",9.2799999999999994,18.559999999999999,25.52,59.16,62.639999999999993,134.56]
[]
["Conyuge>70",111,148,185,222,259,295,333,444,592,740,850,1000,34219]
[74,13.919999999999998,25.52,33.64,41.76,47.559999999999995,52.199999999999996,55.679999999999993,69.599999999999994,81.199999999999989,89.32,126.44,133.39999999999998,332.91999999999996]
[111,"",11.6,19.72,27.839999999999996,33.64,38.279999999999994,41.76,55.679999999999993,67.28,75.399999999999991,118.32,125.27999999999999,329.44]
[148,"","",8.1199999999999992,18.559999999999999,24.36,28.999999999999996,33.64,46.4,59.16,69.599999999999994,117.16,125.27999999999999,293.47999999999996]
[185,"","","",9.2799999999999994,16.239999999999998,20.88,25.52,40.599999999999994,54.519999999999996,63.8,118.32,125.27999999999999,284.2]
[222,"","","","",6.9599999999999991,11.6,16.239999999999998,31.319999999999997,44.08,54.519999999999996,110.19999999999999,115.99999999999999,257.52]
[259,"","","","","",4.6399999999999997,9.2799999999999994,24.36,38.279999999999994,47.559999999999995,102.08,107.88,233.16]
[295,"","","","","","",3.4799999999999995,12.76,22.04,28.999999999999996,63.8,68.44,142.67999999999998]
[333,"","","","","","","",9.2799999999999994,18.559999999999999,25.52,59.16,62.639999999999993,134.56]
[]
["HIJOS",111,148,185,222,259,295,333,444,592,740,850,1000,34219]
[74,3.4799999999999995,5.8,39.44,51.04,60.319999999999993,62.639999999999993,64.959999999999994,70.759999999999991,75.399999999999991,81.199999999999989,85.839999999999989,92.8,288.83999999999997]
[111,"",3.4799999999999995,35.96,48.72,56.839999999999996,59.16,62.639999999999993,67.28,71.92,77.72,83.52,91.64,271.44,null,183.28]
[148,"","",34.799999999999997,48.72,57.999999999999993,60.319999999999993,63.8,69.599999999999994,74.239999999999995,81.199999999999989,87,97.44,185.6,null,183.28,{"$f":"+SUM(P16:P48)","v":1158.8399999999999}]
[185,"","","",15.079999999999998,24.36,27.839999999999996,30.159999999999997,35.96,41.76,48.72,53.36,60.319999999999993,126.44,null,{"$f":"+P48+P47","v":366.56},null,{"$f":"+P49/15*6","v":146.62400000000002}]
[222,"","","","",10.44,12.76,16.239999999999998,22.04,27.839999999999996,33.64,38.279999999999994,42.919999999999995,102.08]
[259,"","","","","",2.3199999999999998,5.8,11.6,18.559999999999999,24.36,31.319999999999997,33.64,88.16]
[295,"","","","","","",1.1599999999999999,5.8,10.44,15.079999999999998,19.72,22.04,54.519999999999996]
[333,"","","","","","","",3.4799999999999995,8.1199999999999992,12.76,17.399999999999999,19.72,49.879999999999995]
[]
[]
["S.A.","Hasta 50 años","De 51 a 55 años","De 56 a 60 años","De 61 a 65 años","De 66 a 70 años","De 71 a 75 años","De 76 a 80 años","De 81 a 85 años"]
[74,294.64,327.12,359.59999999999997,392.08,499.96,757.4799999999999,1295.7199999999998,2557.7999999999997]
[111,308.56,343.35999999999996,378.15999999999997,411.79999999999995,525.48,795.76,1359.52,2685.3999999999996]
[148,320.15999999999997,354.96,390.91999999999996,426.88,545.20000000000005,828.2399999999999,1414.04,2793.2799999999997]
[185,330.59999999999997,366.56,403.67999999999995,440.79999999999995,561.44000000000005,850.28,1454.6399999999999,2873.3199999999997,null,null,null,null,null,null,null,null,null,{"$f":"+G70","v":2810.68},{"$f":"+B70","v":1425.6399999999999}]
[222,338.71999999999997,377,414.11999999999995,452.4,576.52,874.64,1495.24,2953.3599999999997,null,null,null,null,null,null,null,null,null,null,{"$f":"+T60+S60","v":4236.32},null,{"$f":"+T61/15*6","v":1694.528}]
[259,344.52,382.79999999999995,421.08,459.35999999999996,585.79999999999995,890.87999999999988,1523.08,3004.3999999999996]
[295,350.32,389.76,428.03999999999996,467.47999999999996,595.08000000000004,901.31999999999994,1541.6399999999999,3043.8399999999997]
[333,353.79999999999995,393.23999999999995,432.67999999999995,472.11999999999995,603.20000000000005,914.07999999999993,1562.52,3085.6]
[444,366.56,408.32,448.91999999999996,489.52,624.08000000000004,945.4,1617.04,3193.4799999999996]
[592,378.15999999999997,419.91999999999996,462.84,504.59999999999997,643.79999999999995,976.71999999999991,1670.3999999999999,3299.04]
[740,388.59999999999997,431.52,474.43999999999994,517.36,660.04,1001.0799999999999,1709.84,3379.08]
[850,520.83999999999992,578.83999999999992,636.83999999999992,694.83999999999992,773.72,1026.5999999999999,2083.3599999999997,4118,null,null,null,null,"Año","Mes"]
[1000,532.43999999999994,591.59999999999991,650.76,709.92,789.96,1048.6399999999999,2097.2799999999997,4930,null,null,"Inicio",{"$f":"+PRIMAS!J15","v":"REVISAR FECHA O AÑO FISCAL EN DATOS"},null,null,null,1,"01"]
[34219,1425.6399999999999,1584.56,1743.4799999999998,1901.2399999999998,2118.16,2810.68,4118,5800,null,null,"Final",{"$f":"+PRIMAS!J16","v":"2019-05-15"},{"$f":"+YEAR(M70)-YEAR(M69)","v":{"$error":"#VALUE!"}},{"$f":"+MONTH(M70)-MONTH(M69)","v":{"$error":"#VALUE!"}},{"$f":"+N70*12+O70+1","v":{"$error":"#VALUE!"}},2,"02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"03"]
[111,2,null,null,null,null,"2017-11-01",{"$f":"+CONCATENATE(YEAR(G72),MONTH(G72))","v":"201711"},11,15,null,null,{"$f":"+CONCATENATE(YEAR(M69),VLOOKUP(MONTH(M69),Q69:R80,2,0))","v":{"$error":"#VALUE!"}},null,null,null,4,"04"]
[148,3,null,null,null,null,{"$f":"+G72+30","v":"2017-12-01"},{"$f":"+CONCATENATE(YEAR(G73),MONTH(G73))","v":"201712"},12,31,null,"mes inicio",{"$f":"+N70*12+O70+1","v":{"$error":"#VALUE!"}},null,null,null,5,"05"]
[185,4,null,null,null,null,{"$f":"+G73+31","v":"2018-01-01"},{"$f":"+CONCATENATE(YEAR(G74),0,MONTH(G74))","v":"201801"},1,31,null,"meses completos",{"$f":"+O70","v":{"$error":"#VALUE!"}},null,null,null,6,"06"]
[222,5,null,null,null,null,{"$f":"+G74+31","v":"2018-02-01"},"201802",2,28,null,"Q x meses completos",{"$f":"M74*2","v":{"$error":"#VALUE!"}},null,null,null,7,"07"]
[259,6,null,null,null,null,{"$f":"+G75+28","v":"2018-03-01"},"201803",3,31,null,"días mes inicio",{"$f":"VLOOKUP(M72,$H$72:$J$90,3,0)","v":{"$error":"#VALUE!"}},null,null,null,8,"08"]
[295,7,null,null,null,null,{"$f":"+G76+31","v":"2018-04-01"},"201804",4,30,null,"día inicio",{"$f":"IF(PRIMAS!J15=\"\",\"\",DAY(PRIMAS!J15))","v":{"$error":"#VALUE!"}},null,null,null,9,"09"]
[333,8,null,null,null,null,{"$f":"+G77+30","v":"2018-05-01"},"201805",5,31,null,"QUINCENAS TOTALES",{"$f":"M75+IF(M77<16,1,0)+IF(OR(M77=1,M77=16),1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(DATOS!C28=2017,M78-1,M78)","v":{"$error":"#VALUE!"}},{"$f":"M78+1","v":{"$error":"#VALUE!"}},null,10,"10"]
[444,9,null,null,null,null,{"$f":"+G78+31","v":"2018-06-01"},"201806",6,30,null,"DÍAS Q INCOMPLETA",{"$f":"IF(OR(M77=1,M77=16),0,IF(M77<16,16-M77,M76-M77+1))","v":{"$error":"#VALUE!"}},null,null,null,11,"11"]
[592,10,null,null,null,null,"2018-07-01","201807",7,31,null,null,null,null,null,null,12,"12"]
[740,11,null,null,null,null,{"$f":"+G80+31","v":"2018-08-01"},"201808",8,31,null,"UMAM",2450.2399999999998]
[850,12,null,null,null,null,{"$f":"+G81+31","v":"2018-09-01"},"201809",9,30]
[1000,13,null,null,null,null,"2018-10-01","201810",10,31]
[34219,14,null,null,null,null,{"$f":"+G83+31","v":"2018-11-01"},"201811",11,15]
["titulares",1,null,null,null,null,"2018-12-01","201812",12,31]
[null,null,null,null,null,null,{"$f":"+G85+31","v":"2019-01-01"},{"$f":"+CONCATENATE(YEAR(G86),0,MONTH(G86))","v":"201901"},1,31]
[null,null,null,null,null,null,{"$f":"+G86+31","v":"2019-02-01"},{"$f":"+CONCATENATE(YEAR(G87),0,MONTH(G87))","v":"201902"},2,28]
[null,null,null,null,null,null,{"$f":"+G87+28","v":"2019-03-01"},{"$f":"+CONCATENATE(YEAR(G88),0,MONTH(G88))","v":"201903"},3,31]
[null,null,null,null,null,null,{"$f":"+G88+31","v":"2019-04-01"},{"$f":"+CONCATENATE(YEAR(G89),0,MONTH(G89))","v":"201904"},4,30]
[null,null,null,null,null,null,"2019-05-01",{"$f":"+CONCATENATE(YEAR(G90),0,MONTH(G90))","v":"201905"},5,15]
[]
[]
[null,2012]
[null,2013]
[null,2014]