{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SIMULADOR","Hoja2","Hoja3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"SIMULADOR","index":0,"n_rows":18,"n_cols":49,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,12,15,13],[16,8,16,9],[16,10,16,11],[16,12,16,13],[17,8,17,9],[17,10,17,11],[17,12,17,13],[15,10,15,11],[11,2,12,3],[11,4,12,6],[17,4,17,6],[16,4,16,6],[15,8,15,9],[16,2,16,3],[17,2,17,3],[13,2,13,3],[14,2,14,3],[13,4,13,6],[14,4,14,6],[13,12,13,13],[14,12,14,13],[13,8,13,9],[14,8,14,9],[10,8,10,10],[10,11,10,13],[12,10,12,11],[12,12,12,13],[13,10,13,11],[14,10,14,11],[1,2,1,14],[3,2,3,7],[9,2,9,3],[10,2,10,3],[2,7,2,14],[7,7,7,14],[9,8,9,14],[10,4,10,6],[9,4,9,6]]}
[]
[null,null,"SEGURO DE VIDA INSTITUCIONAL\nADMINISTRACIÓN PÚBLICA FEDERAL\n\"SIMULADOR DE POTENCIACIÓN DE PÓLIZA DE VIDA\""]
[]
[null,null,"Instrucciones: Captura la información que se solicta en los campos que se indican"]
[]
[null,null,null,"Campos a llenar",null,"Cálculo en automático","Nota: Recuerda que tú póliza te protege con un suma básica de 40 meses de sueldo"]
[]
[]
[]
[null,null,"Percepción Ordinaria Bruta: \n(Sueldo Base + Compensanción Garantizada)",null,null,null,null,null,"ESTIMACIÓN DE MONTO A INDEMNIZAR POR BENEFICIARIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meses","Porcentaje"]
[null,null,"Meses a Potenciar:",null,null,null,null,null,"Número de Beneficiarios:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,34,2.37,{"$f":"AT11+AU11","v":74}]
[null,null,"Cuota Mensual:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,51,4.03,{"$f":"AT12+AU12","v":91}]
[null,null,null,null,null,null,null,null,null,null,"Porcentaje a Indeminizar",null,"Monto a \nIndeminizar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,68,5.93,108]
[null,null,"Descuento vía Nómina Mensual:",null,null,null,null,null,1]
[null,null,"Descuento vía Nómina quincenal:",null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,3]
[null,null,"TOTAL DE MESES \nA INDEMNIZAR:",null,{"$f":"MESES+40","v":40},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AU15,AU11:AV13,2,0)","v":2.37}]
[null,null,"MONTO TOTAL  \nA INDEMNIZAR:",null,{"$f":"PERCEPCION * MESES2","v":0},null,null,null,5]

{"sheet":"Hoja2","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Meses","Porcentaje"]
[null,40,34,1.98,{"$f":"B3+C3","v":74}]
[null,40,51,3.37,{"$f":"B4+C4","v":91}]
[null,40,68,4.96,108]
[]
[]
[null,"BEN"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}