{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Prevision","Matriz","Información","Explicacion Procedimiento"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Prevision","index":0,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,"si no","uf / pesos"]
[]
[]
["N°","CÓDIGO","Cliente","NOMBRE COMPLETO","RUT","SIST. PREVIS.","NOMBRE AFP","Renta tope","Renta Imponible  UF / Pesos","APV TOPE 50 UF","Tipo Contrato","SISTEMA SALUD","NOMBRE SALUD","UF/Pesos/NA","Valor Plan","RENTA TOPE SI/NO","RENTA TOPE Seg Ces. UF / $","COMISION","Monto para la comision","Modalidad Gratificación","Cargas Fam. Aut.","Base Imponible A. Familiares","Renta Tope2","Renta Imponible UF/Pesos","Renta IMPON. SEG. CES.","TIPO TRABAJADOR","TIENE MOV. PERSONAL"]
[1,null,null,"CANIUQUEO CATRIMAN GUILLERMO ANTONIO",null,"AFP","CAPITAL",null,null,null,"Indefinido","ISAPRE","BANMEDICA","UF",3.5]
[2,null,null,"FIGUEROA RAMIREZ GUILLERMO IVAN",null,"AFP","CUPRUM",null,null,null,"Por Obra","ISAPRE","ING SANTA MARIA","Pesos",89000]
[3,null,null,"MAMANI CHINO COLIN ",null,"AFP","HABITAT",null,null,null,"Fijo","FONASA","FONASA","NA",7.0000000000000007E-2]
[4,null,null,"MARQUEZ NUÑEZ STEFAN PATRICIO",null,"INP","INP",null,null,null,"Fijo","FONASA","FONASA","NA",7.0000000000000007E-2]
[5,null,null,"ANTIMAN MILLAPÍ ABELARDO VICTOR",null,"INP","INP",null,null,null,"Fijo","FONASA","FONASA","NA",7.0000000000000007E-2]
[6,null,null,"ANTIO PARRA JULIO ANIBAL",null,"AFP","MODELO",null,null,null,"Fijo","FONASA","FONASA","NA",7.0000000000000007E-2]
[7,null,null,"ARANGUIZ ALVAREZ JOSE MOISES",null,"AFP","UNO",null,null,null,"Por Obra","ISAPRE","CONSALUD","UF",4.2]
[8,null,null,"AREVALO SEGOVIA HECTOR GIAN",null,"AFP","INP",null,null,null,"Por Obra","ISAPRE","COLMENA","Pesos",120000]
[9,null,null,"ARIAS QUEULOPAN ALONSO LUIS",null,"AFP","CAPITAL",null,null,null,"Indefinido","FONASA","FONASA","NA",7.0000000000000007E-2]
[10,null,null,"AVILA SAAVEDRA CESAR IVAN",null,"AFP","CUPRUM",null,null,null,"Indefinido","FONASA","FONASA","NA",7.0000000000000007E-2]
[11,null,null,"AZAGRA RIOS VICTOR RAUL",null,"AFP","HABITAT",null,null,null,"Indefinido","FONASA","FONASA","NA",7.0000000000000007E-2]
[12,null,null,"VILLEGAS AVENDAÑO PATRICIO ALEXIS ",null,"AFP","PLANVITAL",null,null,null,"INDEF 11 años o más","FONASA","FONASA","NA",7.0000000000000007E-2]
[13,null,null,"VILLEGAS AVENDAÑO PATRICIO ALEXIS",null,"AFP","PROVIDA",null,null,null,"Casa particular","FONASA","FONASA","NA",7.0000000000000007E-2]
[14,null,null,"ZUÑIGA GAMBOA LUIS MARIO",null,"AFP","MODELO",null,null,null,"Por Obra","FONASA","FONASA","NA",7.0000000000000007E-2]
[15,null,null,"ZUÑIGA ULLOA MAURICIO ANTONIO",null,"AFP","UNO",null,null,null,"Fijo","FONASA","FONASA","NA",7.0000000000000007E-2]

{"sheet":"Matriz","index":1,"n_rows":21,"n_cols":69,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,55,5,55],[4,56,5,56],[4,57,5,57],[3,51,3,66],[4,63,5,63],[4,1,5,1],[4,0,5,0],[4,66,5,66],[4,59,5,59],[4,60,5,60],[4,61,5,61],[4,62,5,62],[4,64,5,64],[4,65,5,65],[4,58,5,58],[4,49,5,49],[4,26,5,26],[4,51,5,51],[4,52,5,52],[4,53,5,53],[4,54,5,54]]}
[]
[]
[]
[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,null,null,null,null,null,null,null,49,null,"Itemes"]
["N°","Nombre",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,null,null,null,null,null,"Base Calculo",null,"Nombre AFP"," AFP $","S.I.S   ","Seguro Cesantia Trabaj.","Seguro Cesantia Empleador","Nombre Salud","Monto Cotizacion Obligatoria Salud","Adic. Plan a Pagar","TOTAL SALUD","ACHS  ","IMPUESTO UNICO","Cargas Familiares","Otros Descuentos","CCAF","CCAF CREDITO","TOTAL Itemes","Mes","OCTUBRE"]
[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,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,"Dia Inic.",1]
[1,"CANIUQUEO CATRIMAN GUILLERMO ANTONIO",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,null,null,null,null,null,900000,null,"CAPITAL",null,null,null,null,"BANMEDICA",null,null,null,null,null,null,null,null,null,null,"Dia Term."]
[2,"FIGUEROA RAMIREZ GUILLERMO IVAN",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,null,null,null,null,null,850000,null,"CUPRUM",null,null,null,null,"ING SANTA MARIA"]
[3,"MAMANI CHINO COLIN ",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,null,null,null,null,null,380000,null,"HABITAT",null,null,null,null,"FONASA",null,null,null,null,null,null,null,null,null,null,"Inicio dia"]
[4,"MARQUEZ NUÑEZ STEFAN PATRICIO",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,null,null,null,null,null,1700000,null,"INP",null,null,null,null,"FONASA",null,null,null,null,null,null,null,null,null,null,"Termino dia"]
[5,"ANTIMAN MILLAPÍ ABELARDO VICTOR",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,null,null,null,null,null,3200000,null,"INP",null,null,null,null,"FONASA",null,null,null,null,null,null,null,null,null,null,"Linea",1]
[6,"ANTIO PARRA JULIO ANIBAL",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,null,null,null,null,null,4500000,null,"MODELO",null,null,null,null,"FONASA",null,null,null,null,null,null,null,null,null,null,"N° Cliente","1CL"]
[7,"ARANGUIZ ALVAREZ JOSE MOISES",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,null,null,null,null,null,6700000,null,"UNO",null,null,null,null,"CONSALUD",null,null,null,null,null,null,null,null,null,null,"Inicio Trabaj.",1]
[8,"AREVALO SEGOVIA HECTOR GIAN",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,null,null,null,null,null,16500000,null,"INP",null,null,null,null,"COLMENA"]
[9,"ARIAS QUEULOPAN ALONSO LUIS",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,null,null,null,null,null,18500000,null,"CAPITAL",null,null,null,null,"FONASA"]
[10,"AVILA SAAVEDRA CESAR IVAN",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,null,null,null,null,null,380000,null,"CUPRUM",null,null,null,null,"FONASA"]
[11,"AZAGRA RIOS VICTOR RAUL",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,null,null,null,null,null,380000,null,"HABITAT",null,null,null,null,"FONASA"]
[12,"VILLEGAS AVENDAÑO PATRICIO ALEXIS ",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,null,null,null,null,null,450000,null,"PLANVITAL",null,null,null,null,"FONASA"]
[13,"VILLEGAS AVENDAÑO PATRICIO ALEXIS",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,null,null,null,null,null,450000,null,"PROVIDA",null,null,null,null,"FONASA"]
[14,"ZUÑIGA GAMBOA LUIS MARIO",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,null,null,null,null,null,450000,null,"MODELO",null,null,null,null,"FONASA"]
[15,"ZUÑIGA ULLOA MAURICIO ANTONIO",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,null,null,null,null,null,450000,null,"UNO",null,null,null,null,"FONASA",31500.000000000004,null,31500.000000000004,15659.999999999998,370395,null,null,null,null,489510]

{"sheet":"Información","index":2,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,19,16,20],[15,15,15,17],[8,19,8,20],[0,15,0,17],[8,15,8,17],[0,19,0,20]]}
[null,null,null,null,null,null,null,null,null,"SIST. PREV.",null,"AFP","Dependientes","Independientes",null,"SEGURO CESANTÍA",null,null,null,"Antecedentes Generales Remuneración"]
[null,null,null,null,null,null,null,null,null,"AFP",null,"CAPITAL",0.1144,null,null,"Tipo Contrato","Trabajador","Empleador",null,"U . T . M .",50021]
[null,null,null,null,null,null,null,null,null,"INP",null,"CUPRUM",0.1144,null,null,"FIJO",0,0.03,null,"U . F .",28597.46]
[null,null,null,null,null,null,null,null,null,"SIN INSTITUCION",null,"HABITAT",0.11269999999999999,null,null,"INDEFINIDO",6.0000000000000001E-3,2.4E-2,null,"I . M . M .",320500]
[null,null,null,null,null,null,null,null,null,null,null,"PLANVITAL",0.1116,null,null,"POR OBRA",0,0.03,null,"Mto. Fijo Grat.",20000]
[null,null,null,null,null,null,null,null,null,null,null,"PROVIDA",0.1145,null,null,"INDEF 11 años o más",0,8.0000000000000002E-3,null,"Periodo","E N E R O    2 0 2 1"]
[null,null,null,null,null,null,null,null,null,"SIS",null,"MODELO",0.1077,null,null,"Casa particular",0,0.03,null,"Hora Extra","Según Factor 0,0077777"]
[null,null,null,null,null,null,null,null,null,2.3E-2,null,"UNO",0.1069]
[null,null,null,null,null,null,null,null,null,null,null,"INP",0.18840000000000001,null,null,"Asignación Familiar",null,null,null,"Topes Previsionales U.F."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tramo","Desde","Monto",null,"Tope A.F.P.",80.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",0,13155,null,"Tope A.F.C.",120.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",336045,8073,null,"Tope Salud",80.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",490844,2551,null,"Accid. Trab.",79.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",765550,0,null,"Tope INP",60]
[null,null,null,null,null,null,null,null,null,"SIST. SALUD"]
[null,null,null,null,null,null,null,null,null,"FONASA",null,"NOMBRE ISAPRE",null,null,null,"Impuesto Único"]
[null,null,null,null,null,null,null,null,null,"ISAPRE",null,"BANMEDICA",null,null,null,"DESDE","FACTOR","Cant. Rebajar",null,"Accidentes Laborales"]
[null,null,null,null,null,null,null,null,null,"SIN INSTITUCION",null,"ING SANTA MARIA",null,null,null,0,0,0,null,"% FIJO",9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,"MAS VIDA",null,null,null,688203.01,0.04,27173.88,null,"% ADICIONAL",2.53E-2]
[null,null,null,null,null,null,null,null,null,"Planes Salud",null,"CRUZ BLANCA",null,null,null,1529340.01,0.08,87560.28,null,"Total",{"$f":"U18+U19","v":3.4799999999999998E-2}]
[null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,"CONSALUD",null,null,null,2548900.0099999998,0.13500000000000001,225945.78]
[null,null,null,null,null,null,null,null,null,"UF",null,"COLMENA",null,null,null,3568460.01,0.23,560587.07999999996]
[null,null,null,null,null,null,null,null,null,"$",null,"FONASA",null,null,null,4588020.01,0.30399999999999999,895731.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6117360.0099999998,0.35,1173509.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15803180.01,0.4,1953500.04]

{"sheet":"Explicacion Procedimiento","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}