{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Portada","Centralización","Lista de Trabajadores","Libro de Remuneraciones","Resumen ","Liquidación 1","Liquidación 2","Liquidación 3","Liquidación 4","Liquidación 5","Tasas","instructivo","Hoja1"],"not_rendered":{"charts":1,"images":25,"macros":1,"external_links":1,"defined_names":18,"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":"Portada","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,1,8,1],[8,4,8,9],[9,4,9,9],[10,4,10,9],[3,4,3,9],[4,4,4,9],[5,4,5,9],[6,4,6,9],[7,4,7,9]]}
[]
[null,null,null,null,"Libro de Remuneraciones "]
[]
[null,null,null,"Nombre / Razón Social","NUBOX"]
[null,null,null,"RUT","11.111.111-1"]
[null,null,null,"Representante Legal","Dayana Huala"]
[null,null,null,"C.I. Representante Legal","1.111.111-1"]
[null,"Antes de comenzar revisa aquí un vídeo con una breve explicación",null,"Dirección","Las Condes"]
[null,null,null,"Teléfono","2-222-222-222"]
[null,null,null,"Mes","Marzo"]
[null,null,null,"Año Comercial",2023]

{"sheet":"Centralización","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[[12,3,12,4],[7,3,7,5],[9,3,9,5],[1,6,1,12],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5]]}
[]
[null,null,null,null,null,null,"CENTRALIZACIÓN DE SUELDOS"]
[null,null,null,"Nombre / Razón Social",null,null,{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"RUT",null,null,{"$f":"+Portada!E5","v":"11.111.111-1"}]
[null,null,null,"Representante Legal",null,null,{"$f":"+Portada!E6","v":"Dayana Huala"}]
[null,null,null,"C.I. Representante Legal",null,null,{"$f":"+Portada!E7","v":"1.111.111-1"}]
[null,null,null,"Dirección",null,null,{"$f":"+Portada!E8","v":"Las Condes"}]
[null,null,null,"Teléfono",null,null,{"$f":"+Portada!E9","v":"2-222-222-222"}]
[null,null,null,"Mes",null,null,{"$f":"+Portada!E10","v":"Marzo"}]
[null,null,null,"Año Comercial",null,null,{"$f":"+Portada!E11","v":2023}]
[]
[]
[null,null,"N° de Cuenta","Nombre de Cuenta",null,"Debe","Haber"]
[null,null,3103001,"Remuneraciones",null,{"$f":"+'Libro de Remuneraciones'!S19","v":100000}]
[null,null,3103016,"Movilización",null,{"$f":"+'Libro de Remuneraciones'!T19","v":0}]
[null,null,3103015,"Colación",null,{"$f":"+'Libro de Remuneraciones'!U19","v":0}]
[null,null,3103018,"Desgaste de Herramientas",null,{"$f":"+'Libro de Remuneraciones'!V19","v":0}]
[null,null,3103019,"Pérdida de Caja",null,{"$f":"+'Libro de Remuneraciones'!W19","v":0}]
[null,null,3103020,"Asignación Familiar",null,{"$f":"+'Libro de Remuneraciones'!X19","v":0}]
[null,null,3103007,"Aporte Patronal",null,{"$f":"+'Libro de Remuneraciones'!AL19","v":2400}]
[null,null,3103018,"Acc. Trabajo",null,{"$f":"+'Libro de Remuneraciones'!AM19","v":950}]
[null,null,2106999,null,"Impuestos x Pagar",null,{"$f":"+'Libro de Remuneraciones'!AJ19","v":25000}]
[null,null,2108003,null,"Aporte Patronal X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AL19","v":2400}]
[null,null,2107003,null,"Acc. Trabajo X pagar",null,{"$f":"+'Libro de Remuneraciones'!AM19","v":950}]
[null,null,2107000,null,"Anticipo de Suelo",null,{"$f":"+'Libro de Remuneraciones'!AH19","v":0}]
[null,null,2107001,null,"AFP X Pagar",null,{"$f":"+'Libro de Remuneraciones'!Z19","v":10562}]
[null,null,2107002,null,"Salud X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AA19","v":7000.0000000000009}]
[null,null,2108001,null,"Seguro de Cesantía X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AB19","v":600}]
[null,null,2106001,null,"Sueldos X Pagar",null,{"$f":"+'Libro de Remuneraciones'!AK19","v":56838}]
[null,null,null,null,null,{"$f":"+F14+F15+F16+F17+F18+F19+F20+F21","v":103350},{"$f":"+G22+G25+G26+G27+G23+G28+G24+G29","v":103350}]

{"sheet":"Lista de Trabajadores","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[[11,2,11,5],[1,5,1,9],[2,3,2,4],[3,3,3,4],[7,3,7,4],[9,3,9,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[8,3,8,4]]}
[]
[null,null,null,null,null,"LISTA DE TRABAJADORES / LIQUIDACIONES DE SUELDOS"]
[null,null,null,"Nombre / Razón Social",null,{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"RUT",null,{"$f":"+Portada!E5","v":"11.111.111-1"}]
[null,null,null,"Representante Legal",null,{"$f":"+Portada!E6","v":"Dayana Huala"}]
[null,null,null,"C.I. Representante Legal",null,{"$f":"+Portada!E7","v":"1.111.111-1"}]
[null,null,null,"Dirección",null,{"$f":"+Portada!E8","v":"Las Condes"}]
[null,null,null,"Teléfono",null,{"$f":"+Portada!E9","v":"2-222-222-222"}]
[null,null,null,"Mes",null,{"$f":"+Portada!E10","v":"Marzo"}]
[null,null,null,"Año Comercial",null,{"$f":"+Portada!E11","v":2023}]
[]
[null,null,"RESUMEN",null,null,null,{"$f":"COUNT(C13:C18)","v":0},{"$f":"SUM(H13:H18)","v":0},{"$f":"SUM(I13:I17)","v":14526},{"$f":"SUM(J13:J17)","v":40474},"Revisar Documentos"]
[null,null,"N° Interno","Nombre","R.U.T","Fecha  Inicio Contrato","Cargo","Sueldo Base","Descuentos Previsionales","Líquido a Pagar","Liquidación de Sueldo"]
[null,null,null,null,null,null,null,null,{"$f":"+'Liquidación 1'!L27","v":3618},{"$f":"+'Liquidación 1'!K51","v":-8618}]
[null,null,null,null,null,null,null,null,{"$f":"+'Liquidación 2'!L27","v":3636},{"$f":"+'Liquidación 2'!K51","v":16364}]
[null,null,null,null,null,null,null,null,{"$f":"+'Liquidación 3'!L27","v":3636},{"$f":"+'Liquidación 3'!K51","v":16364}]
[null,null,null,null,null,null,null,null,{"$f":"+'Liquidación 4'!L27","v":3636},{"$f":"+'Liquidación 4'!K51","v":16364}]
[null,null,null,null,null,null,null,null,{"$f":"+'Liquidación 5'!L27","v":3636},{"$f":"+'Liquidación 5'!K51","v":16364}]

{"sheet":"Libro de Remuneraciones","index":3,"n_rows":19,"n_cols":39,"rows_kept":19,"cut":false,"hidden":true,"merged":[[7,3,7,4],[9,3,9,4],[8,3,8,4],[1,5,1,12],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4]]}
[]
[null,null,null,null,null,"LIBRO DE REMUNERACIONES"]
[null,null,null,"Nombre / Razón Social",null,{"$f":"+'Lista de Trabajadores'!F3","v":"NUBOX"}]
[null,null,null,"RUT",null,{"$f":"+'Lista de Trabajadores'!F4","v":"11.111.111-1"}]
[null,null,null,"Representante Legal",null,{"$f":"+'Lista de Trabajadores'!F5","v":"Dayana Huala"}]
[null,null,null,"C.I. Representante Legal",null,{"$f":"+'Lista de Trabajadores'!F6","v":"1.111.111-1"}]
[null,null,null,"Contador",null,{"$f":"+'Lista de Trabajadores'!F7","v":"Las Condes"}]
[null,null,null,"C.I. Contador",null,{"$f":"+'Lista de Trabajadores'!F8","v":"2-222-222-222"}]
[null,null,null,"Mes",null,{"$f":"+'Lista de Trabajadores'!F9","v":"Marzo"}]
[null,null,null,"Año Comercial",null,{"$f":"+'Lista de Trabajadores'!F10","v":2023}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modificar valor según corresponda"]
[null,null,"N°","Nombre","R.U.T","Fecha de Ingreso","Cargo","Tipo de Contrato","Sistema de Salud","Nombre AFP","Días Trabajados","Sueldo Base","Gratificación Legal","Horas Extras","Horas Sábado","Horas Feriados","Horas Menos","Bonos Imponibles (Producción)","Total Imponible","Bono Movilización","Bono Colación","Bono Desgaste de Herramientas","Bono Pérdida de Caja","Asignación Familiar","Total Haber","AFP","Salud","Seguro de Cesantía","Préstamos Cuota","Descuento de Terceros","Otros Descuentos ","Total Descuentos","Alcance Líquido","Anticipo de Sueldos","Base Imponible Tributable","Impuesto Único","Sueldo Líquido","2,4% Aporte Empleador  Seguro de cesantía","0,95 % ACC."]
[null,null,{"$f":"+'Liquidación 1'!$J$9","v":0},{"$f":"+'Liquidación 1'!$J$10","v":0},{"$f":"+'Liquidación 1'!$J$11","v":0},{"$f":"+'Liquidación 1'!$J$13","v":"00:00:00"},{"$f":"+'Liquidación 1'!$J$12","v":0},{"$f":"+'Liquidación 1'!$J$14","v":"Indefinido"},{"$f":"+'Liquidación 1'!$I$25","v":"Fonasa"},{"$f":"+'Liquidación 1'!$J$23","v":"Uno"},{"$f":"+'Liquidación 1'!$E$17","v":31},{"$f":"+'Liquidación 1'!$G$23","v":0},{"$f":"+'Liquidación 1'!$G$24","v":0},{"$f":"+'Liquidación 1'!$E$51","v":5000},{"$f":"+'Liquidación 1'!$E$52","v":10000},{"$f":"+'Liquidación 1'!$E$53","v":10000},{"$f":"+'Liquidación 1'!$E$54","v":-5000},{"$f":"+'Liquidación 1'!$G$25","v":0},{"$f":"+'Liquidación 1'!$G$27","v":20000},{"$f":"+'Liquidación 1'!$G$31","v":0},{"$f":"+'Liquidación 1'!$G$32","v":0},{"$f":"+'Liquidación 1'!$G$33","v":0},{"$f":"+'Liquidación 1'!$G$34","v":0},{"$f":"+'Liquidación 1'!$G$30","v":0},{"$f":"+'Liquidación 1'!$G$36","v":20000},{"$f":"+'Liquidación 1'!$L$23","v":2098},{"$f":"+'Liquidación 1'!$L$25","v":1400.0000000000002},{"$f":"+'Liquidación 1'!$L$24","v":120},{"$f":"+'Liquidación 1'!$L$30","v":0},{"$f":"+'Liquidación 1'!$L$31","v":0},{"$f":"+'Liquidación 1'!$L$32","v":0},{"$f":"+'Liquidación 1'!$L$36","v":3618},{"$f":"+'Liquidación 1'!$G$36-'Liquidación 1'!$L$36","v":16382},{"$f":"+'Liquidación 1'!$K$50","v":0},{"$f":"+'Liquidación 1'!$G$44","v":16382},{"$f":"+'Liquidación 1'!$G$45","v":25000},{"$f":"+'Liquidación 1'!$K$49","v":-8618},{"$f":"+S14*2.4%","v":480},{"$f":"+S14*0.95%","v":190}]
[null,null,{"$f":"+'Liquidación 2'!$J$9","v":0},{"$f":"+'Liquidación 2'!$J$10","v":0},{"$f":"+'Liquidación 2'!$J$11","v":0},{"$f":"+'Liquidación 2'!$J$13","v":"00:00:00"},{"$f":"+'Liquidación 2'!$J$12","v":0},{"$f":"+'Liquidación 2'!$J$14","v":"Indefinido"},{"$f":"+'Liquidación 2'!$I$25","v":"Fonasa"},{"$f":"+'Liquidación 2'!$J$23","v":"Modelo"},{"$f":"+'Liquidación 2'!$E$17","v":31},{"$f":"+'Liquidación 2'!$G$23","v":0},{"$f":"+'Liquidación 2'!$G$24","v":0},{"$f":"+'Liquidación 2'!$E$51","v":5000},{"$f":"+'Liquidación 2'!$E$52","v":10000},{"$f":"+'Liquidación 2'!$E$53","v":10000},{"$f":"+'Liquidación 2'!$E$54","v":-5000},{"$f":"+'Liquidación 2'!$G$25","v":0},{"$f":"+'Liquidación 2'!$G$27","v":20000},{"$f":"+'Liquidación 2'!$G$31","v":0},{"$f":"+'Liquidación 2'!$G$32","v":0},{"$f":"+'Liquidación 2'!$G$33","v":0},{"$f":"+'Liquidación 2'!$G$34","v":0},{"$f":"+'Liquidación 2'!$G$30","v":0},{"$f":"+'Liquidación 2'!$G$36","v":20000},{"$f":"+'Liquidación 2'!$L$23","v":2116},{"$f":"+'Liquidación 2'!$L$25","v":1400.0000000000002},{"$f":"+'Liquidación 2'!$L$24","v":120},{"$f":"+'Liquidación 2'!$L$30","v":0},{"$f":"+'Liquidación 2'!$L$31","v":0},{"$f":"+'Liquidación 2'!$L$32","v":0},{"$f":"+'Liquidación 2'!$L$36","v":3636},{"$f":"+'Liquidación 2'!$G$36-'Liquidación 2'!$L$36","v":16364},{"$f":"+'Liquidación 2'!$K$50","v":0},{"$f":"+'Liquidación 2'!$G$44","v":16364},{"$f":"+'Liquidación 2'!$G$45","v":0},{"$f":"+'Liquidación 2'!$K$49","v":16364},{"$f":"+S15*2.4%","v":480},{"$f":"+S15*0.95%","v":190}]
[null,null,{"$f":"+'Liquidación 3'!$J$9","v":0},{"$f":"+'Liquidación 3'!$J$10","v":0},{"$f":"+'Liquidación 3'!$J$11","v":0},{"$f":"+'Liquidación 3'!$J$13","v":"00:00:00"},{"$f":"+'Liquidación 3'!$J$12","v":0},{"$f":"+'Liquidación 3'!$J$14","v":"Indefinido"},{"$f":"+'Liquidación 3'!$I$25","v":"Fonasa"},{"$f":"+'Liquidación 3'!$J$23","v":"Modelo"},{"$f":"+'Liquidación 3'!$E$17","v":31},{"$f":"+'Liquidación 3'!$G$23","v":0},{"$f":"+'Liquidación 3'!$G$24","v":0},{"$f":"+'Liquidación 3'!$E$51","v":5000},{"$f":"+'Liquidación 3'!$E$52","v":10000},{"$f":"+'Liquidación 3'!$E$53","v":10000},{"$f":"+'Liquidación 3'!$E$54","v":-5000},{"$f":"+'Liquidación 3'!$G$25","v":0},{"$f":"+'Liquidación 3'!$G$27","v":20000},{"$f":"+'Liquidación 3'!$G$31","v":0},{"$f":"+'Liquidación 3'!$G$32","v":0},{"$f":"+'Liquidación 3'!$G$33","v":0},{"$f":"+'Liquidación 3'!$G$34","v":0},{"$f":"+'Liquidación 3'!$G$30","v":0},{"$f":"+'Liquidación 3'!$G$36","v":20000},{"$f":"+'Liquidación 3'!$L$23","v":2116},{"$f":"+'Liquidación 3'!$L$25","v":1400.0000000000002},{"$f":"+'Liquidación 3'!$L$24","v":120},{"$f":"+'Liquidación 3'!$L$30","v":0},{"$f":"+'Liquidación 3'!$L$31","v":0},{"$f":"+'Liquidación 3'!$L$32","v":0},{"$f":"+'Liquidación 3'!$L$36","v":3636},{"$f":"+'Liquidación 3'!$G$36-'Liquidación 3'!$L$36","v":16364},{"$f":"+'Liquidación 3'!$K$50","v":0},{"$f":"+'Liquidación 3'!$G$44","v":16364},{"$f":"+'Liquidación 3'!$G$45","v":0},{"$f":"+'Liquidación 3'!$K$49","v":16364},{"$f":"+S16*2.4%","v":480},190]
[null,null,{"$f":"+'Liquidación 4'!$J$9","v":0},{"$f":"+'Liquidación 4'!$J$10","v":0},{"$f":"+'Liquidación 4'!$J$11","v":0},{"$f":"+'Liquidación 4'!$J$13","v":"00:00:00"},{"$f":"+'Liquidación 4'!$J$12","v":0},{"$f":"+'Liquidación 4'!$J$14","v":"Indefinido"},{"$f":"+'Liquidación 4'!$I$25","v":"Fonasa"},{"$f":"+'Liquidación 4'!$J$23","v":"Modelo"},{"$f":"+'Liquidación 4'!$E$17","v":31},{"$f":"+'Liquidación 4'!$G$23","v":0},{"$f":"+'Liquidación 4'!$G$24","v":0},{"$f":"+'Liquidación 4'!$E$51","v":5000},{"$f":"+'Liquidación 4'!$E$52","v":10000},{"$f":"+'Liquidación 4'!$E$53","v":10000},{"$f":"+'Liquidación 4'!$E$54","v":-5000},{"$f":"+'Liquidación 4'!$G$25","v":0},{"$f":"+'Liquidación 4'!$G$27","v":20000},{"$f":"+'Liquidación 4'!$G$31","v":0},{"$f":"+'Liquidación 4'!$G$32","v":0},{"$f":"+'Liquidación 4'!$G$33","v":0},{"$f":"+'Liquidación 4'!$G$34","v":0},{"$f":"+'Liquidación 4'!$G$30","v":0},{"$f":"+'Liquidación 4'!$G$36","v":20000},{"$f":"+'Liquidación 4'!$L$23","v":2116},{"$f":"+'Liquidación 4'!$L$25","v":1400.0000000000002},{"$f":"+'Liquidación 4'!$L$24","v":120},{"$f":"+'Liquidación 4'!$L$30","v":0},{"$f":"+'Liquidación 4'!$L$31","v":0},{"$f":"+'Liquidación 4'!$L$32","v":0},{"$f":"+'Liquidación 4'!$L$36","v":3636},{"$f":"+'Liquidación 4'!$G$36-'Liquidación 4'!$L$36","v":16364},{"$f":"+'Liquidación 4'!$K$50","v":0},{"$f":"+'Liquidación 4'!$G$44","v":16364},{"$f":"+'Liquidación 4'!$G$45","v":0},{"$f":"+'Liquidación 4'!$K$49","v":16364},{"$f":"+S17*2.4%","v":480},190]
[null,null,{"$f":"+'Liquidación 5'!$J$9","v":0},{"$f":"+'Liquidación 5'!$J$10","v":0},{"$f":"+'Liquidación 5'!$J$11","v":0},{"$f":"+'Liquidación 5'!$J$13","v":"00:00:00"},{"$f":"+'Liquidación 5'!$J$12","v":0},{"$f":"+'Liquidación 5'!$J$14","v":"Indefinido"},{"$f":"+'Liquidación 5'!$I$25","v":"Fonasa"},{"$f":"+'Liquidación 5'!$J$23","v":"Modelo"},{"$f":"+'Liquidación 5'!$E$17","v":31},{"$f":"+'Liquidación 5'!$G$23","v":0},{"$f":"+'Liquidación 5'!$G$24","v":0},{"$f":"+'Liquidación 5'!$E$51","v":5000},{"$f":"+'Liquidación 5'!$E$52","v":10000},{"$f":"+'Liquidación 5'!$E$53","v":10000},{"$f":"+'Liquidación 5'!$E$54","v":-5000},{"$f":"+'Liquidación 5'!$G$25","v":0},{"$f":"+'Liquidación 5'!$G$27","v":20000},{"$f":"+'Liquidación 5'!$G$31","v":0},{"$f":"+'Liquidación 5'!$G$32","v":0},{"$f":"+'Liquidación 5'!$G$33","v":0},{"$f":"+'Liquidación 5'!$G$34","v":0},{"$f":"+'Liquidación 5'!$G$30","v":0},{"$f":"+'Liquidación 5'!$G$36","v":20000},{"$f":"+'Liquidación 5'!$L$23","v":2116},{"$f":"+'Liquidación 5'!$L$25","v":1400.0000000000002},{"$f":"+'Liquidación 5'!$L$24","v":120},{"$f":"+'Liquidación 5'!$L$30","v":0},{"$f":"+'Liquidación 5'!$L$31","v":0},{"$f":"+'Liquidación 5'!$L$32","v":0},{"$f":"+'Liquidación 5'!$L$36","v":3636},{"$f":"+'Liquidación 5'!$G$36-'Liquidación 5'!$L$36","v":16364},{"$f":"+'Liquidación 5'!$K$50","v":0},{"$f":"+'Liquidación 5'!$G$44","v":16364},{"$f":"+'Liquidación 5'!$G$45","v":0},{"$f":"+'Liquidación 5'!$K$49","v":16364},{"$f":"+S18*2.4%","v":480},190]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L18)","v":0},0,25000,50000,50000,-25000,0,{"$f":"SUM(S14:S18)","v":100000},0,0,0,0,0,100000,10562,7000.0000000000009,{"$f":"SUM(AB14:AB18)","v":600},{"$f":"SUM(AC14:AC18)","v":0},0,0,{"$f":"SUM(AF14:AF18)","v":18162},81838,0,{"$f":"SUM(AI14:AI18)","v":81838},{"$f":"SUM(AJ14:AJ18)","v":25000},56838,2400,950]

{"sheet":"Resumen ","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[[12,2,13,2],[12,3,13,3],[2,4,2,11],[3,4,3,11],[1,4,1,11],[4,4,4,11],[5,4,5,11],[6,4,6,11],[7,4,7,11],[8,4,8,11],[9,4,9,11]]}
[]
[null,null,null,null,"ANÁLISIS DEL GASTOS EN SUELDOS"]
[null,null,null,"Nombre / Razón Social",{"$f":"+Portada!E4:J4","v":"NUBOX"}]
[null,null,null,"RUT",{"$f":"+Portada!E5:J5","v":"11.111.111-1"}]
[null,null,null,"Representante Legal",{"$f":"+Portada!E6:J6","v":"Dayana Huala"}]
[null,null,null,"C.I. Representante Legal",{"$f":"+Portada!E7:J7","v":"1.111.111-1"}]
[null,null,null,"Dirección",{"$f":"+Portada!E8:J8","v":"Las Condes"}]
[null,null,null,"Teléfono",{"$f":"+Portada!E9:J9","v":"2-222-222-222"}]
[null,null,null,"Mes",{"$f":"+Portada!E10:J10","v":"Marzo"}]
[null,null,null,"Año Comercial",{"$f":"+Portada!E11:J11","v":2023}]
[]
[]
[null,null,"DESCRIPCIÓN","MONTOS"]
[]
[null,null,"Cantidad de trabajadores",{"$f":"COUNT('Lista de Trabajadores'!C14:C18)","v":0}]
[null,null,"Sueldo Base",{"$f":"+'Lista de Trabajadores'!H12","v":0}]
[null,null,"Descuentos Previsionales",{"$f":"+'Lista de Trabajadores'!I12","v":14526}]
[null,null,"Monto Líquido a Pagar",{"$f":"+'Lista de Trabajadores'!J12","v":40474}]

{"sheet":"Liquidación 1","index":5,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[49,3,49,4],[3,5,3,11],[10,4,10,6],[21,15,21,28],[22,15,22,28],[23,24,23,26]]}
[]
[]
[]
[null,null,null,null,null,"LIQUIDACION DE SUELDO"]
[null,null,null,null,null,null,null,null,"Año:",{"$f":"+Portada!E10","v":"Marzo"},"Año:",{"$f":"+Portada!E11","v":2023}]
[]
[]
[null,null,null,"EMPRESA   :",{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"R.U.T.    :",{"$f":"+Portada!E5","v":"11.111.111-1"},null,null,null,"N°INTERNO",{"$f":"+'Lista de Trabajadores'!C14","v":0}]
[null,null,null,"DIRECCION :",{"$f":"+Portada!E8","v":"Las Condes"},null,null,null,"TRABAJADOR        :",{"$f":"+'Lista de Trabajadores'!D14","v":0}]
[null,null,null,"FONO      :",{"$f":"+Portada!E9","v":"2-222-222-222"},null,null,null,"RUT               :",{"$f":"+'Lista de Trabajadores'!E14","v":0}]
[null,null,null,null,null,null,null,null,"CARGO        :",{"$f":"+'Lista de Trabajadores'!G14","v":0}]
[null,null,null,null,null,null,null,null,"FECHA DE CONTRATO:",{"$f":"+'Lista de Trabajadores'!F14","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"TIPO DE CONTRATO:","Indefinido"]
[]
[null,null,null,"Días del Mes:",31]
[null,null,null,"Días Trabajados:",31]
[null,null,null,"Tope Gratificacion Mensual"]
[]
[null,null,null,null,"HABERES",null,null,null,null,null,"DESCUENTOS"]
[]
[]
[null,null,null,"SUELDO BASE",{"$f":"+'Lista de Trabajadores'!H14","v":0},"$",{"$f":"+(E23/E16)*E17","v":0},null,"AFP","Uno",{"$f":"VLOOKUP(J23,Tasas!B20:C26,2,0)","v":0.10489999999999999},{"$f":"+G27*K23","v":2098}]
[null,null,null,"GRATIFICACION LEGAL",0.25,"$",{"$f":"+G23*E24","v":0},null,"SEG. CESANTIA",null,6.0000000000000001E-3,{"$f":"+G27*K24","v":120}]
[null,null,null,"BONOS PRODUCCION",null,"$",null,null,"Fonasa",null,7.0000000000000007E-2,{"$f":"+G27*K25","v":1400.0000000000002}]
[]
[null,null,null,"TOTAL IMPONIBLE",null,null,{"$f":"+G23+G24+G25+E51+E52+E53+E54","v":20000},null,null,null,null,{"$f":"+L23+L24+L25","v":3618}]
[]
[]
[null,null,null,"ASIG.FAMILIAR \n(Revisar Indicacores)",null,"$",0,null,"PRESTAMOS CUOTA",null,"$",0]
[null,null,null,"LOCOMOCION",null,"$",0,null,"DESCUENTO DE TERCEROS",null,"$",0]
[null,null,null,"COLACION",null,"$",0,null,"OTROS DESCUENTOS",null,"$",0]
[null,null,null,"DESGASTE DE HERRAMIENTAS",null,"$",0]
[null,null,null,"PÉRDIDA DE CAJA",null,"$",0]
[]
[null,null,null,"TOTAL HABER",null,"$",{"$f":"G27+G31+G32+G30+G33+G34","v":20000},null,"TOTAL DESCUENTOS",null,"$",{"$f":"SUM(L27:L32)","v":3618}]
[]
[]
[null,null,null,"CALCULO IMPUESTO UNICO"]
[]
[null,null,null,"RENTA IMPONIBLE",null,"$",{"$f":"G27","v":20000}]
[null,null,null,"DESCTO.PREVISIONAL",null,"$",{"$f":"L27","v":3618}]
[]
[null,null,null,"BASE IMPONIBLE TRIBUTABLE",null,"$",{"$f":"+G41-G42","v":16382}]
[null,null,null,"IMPUESTO A PAGAR**\n(Revisar Indicacores)",null,"$",25000]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SUELDO LIQUIDO","$",{"$f":"+G36-L36-G45","v":-8618}]
[null,null,null,"Otras Horas",null,null,null,null,"ANTICIPOS","$",0]
[null,null,null,"Horas Extras",5000,null,null,null,"LIQUIDO A PAGAR","$",{"$f":"+K49-K50","v":-8618}]
[null,null,null,"Horas Sábado",10000]
[null,null,null,"Horas Feriados",10000]
[null,null,null,"Horas Menos",-5000]
[]
[null,null,null,null,null,null,null,null,null,"________________________"]
[null,null,null,null,null,null,null,null,null,"RECIBO Y FIRMO CONFORME"]

{"sheet":"Liquidación 2","index":6,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[49,3,49,4],[3,5,3,11],[10,4,10,6],[21,15,21,28],[22,15,22,28],[23,24,23,26]]}
[]
[]
[]
[null,null,null,null,null,"LIQUIDACION DE SUELDO"]
[null,null,null,null,null,null,null,null,"Año:",{"$f":"+Portada!E10","v":"Marzo"},"Año:",{"$f":"+Portada!E11","v":2023}]
[]
[]
[null,null,null,"EMPRESA   :",{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"R.U.T.    :",{"$f":"+Portada!E5","v":"11.111.111-1"},null,null,null,"N°INTERNO",{"$f":"+'Lista de Trabajadores'!C15","v":0}]
[null,null,null,"DIRECCION :",{"$f":"+Portada!E8","v":"Las Condes"},null,null,null,"TRABAJADOR        :",{"$f":"+'Lista de Trabajadores'!D15","v":0}]
[null,null,null,"FONO      :",{"$f":"+Portada!E9","v":"2-222-222-222"},null,null,null,"RUT               :",{"$f":"+'Lista de Trabajadores'!E15","v":0}]
[null,null,null,null,null,null,null,null,"CARGO        :",{"$f":"+'Lista de Trabajadores'!G15","v":0}]
[null,null,null,null,null,null,null,null,"FECHA DE CONTRATO:",{"$f":"+'Lista de Trabajadores'!F15","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"TIPO DE CONTRATO:","Indefinido"]
[]
[null,null,null,"Días del Mes:",31]
[null,null,null,"Días Trabajados:",31]
[null,null,null,"Tope Gratificacion Mensual"]
[]
[null,null,null,null,"HABERES",null,null,null,null,null,"DESCUENTOS"]
[]
[]
[null,null,null,"SUELDO BASE",{"$f":"+'Lista de Trabajadores'!H15","v":0},"$",{"$f":"+(E23/E16)*E17","v":0},null,"AFP","Modelo",{"$f":"VLOOKUP(J23,Tasas!B20:C26,2,0)","v":0.10580000000000001},{"$f":"+G27*K23","v":2116}]
[null,null,null,"GRATIFICACION LEGAL",0.25,"$",{"$f":"+G23*E24","v":0},null,"SEG. CESANTIA",null,6.0000000000000001E-3,{"$f":"+G27*K24","v":120}]
[null,null,null,"BONOS PRODUCCION",null,"$",null,null,"Fonasa",null,7.0000000000000007E-2,{"$f":"+G27*K25","v":1400.0000000000002}]
[]
[null,null,null,"TOTAL IMPONIBLE",null,null,{"$f":"+G23+G24+G25+E51+E52+E53+E54","v":20000},null,null,null,null,{"$f":"+L23+L24+L25","v":3636}]
[]
[]
[null,null,null,"ASIG.FAMILIAR \n(Revisar Indicacores)",null,"$",0,null,"PRESTAMOS CUOTA",null,"$",0]
[null,null,null,"LOCOMOCION",null,"$",0,null,"DESCUENTO DE TERCEROS",null,"$",0]
[null,null,null,"COLACION",null,"$",0,null,"OTROS DESCUENTOS",null,"$",0]
[null,null,null,"DESGASTE DE HERRAMIENTAS",null,"$",0]
[null,null,null,"PÉRDIDA DE CAJA",null,"$",0]
[]
[null,null,null,"TOTAL HABER",null,"$",{"$f":"G27+G31+G32+G30+G33+G34","v":20000},null,"TOTAL DESCUENTOS",null,"$",{"$f":"SUM(L27:L32)","v":3636}]
[]
[]
[null,null,null,"CALCULO IMPUESTO UNICO"]
[]
[null,null,null,"RENTA IMPONIBLE",null,"$",{"$f":"G27","v":20000}]
[null,null,null,"DESCTO.PREVISIONAL",null,"$",{"$f":"L27","v":3636}]
[]
[null,null,null,"BASE IMPONIBLE TRIBUTABLE",null,"$",{"$f":"+G41-G42","v":16364}]
[null,null,null,"IMPUESTO A PAGAR**\n(Revisar Indicacores)",null,"$",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SUELDO LIQUIDO","$",{"$f":"+G36-L36-G45","v":16364}]
[null,null,null,"Otras Horas",null,null,null,null,"ANTICIPOS","$",0]
[null,null,null,"Horas Extras",5000,null,null,null,"LIQUIDO A PAGAR","$",{"$f":"+K49-K50","v":16364}]
[null,null,null,"Horas Sábado",10000]
[null,null,null,"Horas Feriados",10000]
[null,null,null,"Horas Menos",-5000]
[]
[null,null,null,null,null,null,null,null,null,"________________________"]
[null,null,null,null,null,null,null,null,null,"RECIBO Y FIRMO CONFORME"]

{"sheet":"Liquidación 3","index":7,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[49,3,49,4],[3,5,3,11],[10,4,10,6],[21,15,21,28],[22,15,22,28],[23,24,23,26]]}
[]
[]
[]
[null,null,null,null,null,"LIQUIDACION DE SUELDO"]
[null,null,null,null,null,null,null,null,"Año:",{"$f":"+Portada!E10","v":"Marzo"},"Año:",{"$f":"+Portada!E11","v":2023}]
[]
[]
[null,null,null,"EMPRESA   :",{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"R.U.T.    :",{"$f":"+Portada!E5","v":"11.111.111-1"},null,null,null,"N°INTERNO",{"$f":"+'Lista de Trabajadores'!C16","v":0}]
[null,null,null,"DIRECCION :",{"$f":"+Portada!E8","v":"Las Condes"},null,null,null,"TRABAJADOR        :",{"$f":"+'Lista de Trabajadores'!D16","v":0}]
[null,null,null,"FONO      :",{"$f":"+Portada!E9","v":"2-222-222-222"},null,null,null,"RUT               :",{"$f":"+'Lista de Trabajadores'!E16","v":0}]
[null,null,null,null,null,null,null,null,"CARGO        :",{"$f":"+'Lista de Trabajadores'!G16","v":0}]
[null,null,null,null,null,null,null,null,"FECHA DE CONTRATO:",{"$f":"+'Lista de Trabajadores'!F16","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"TIPO DE CONTRATO:","Indefinido"]
[]
[null,null,null,"Días del Mes:",31]
[null,null,null,"Días Trabajados:",31]
[null,null,null,"Tope Gratificacion Mensual"]
[]
[null,null,null,null,"HABERES",null,null,null,null,null,"DESCUENTOS"]
[]
[]
[null,null,null,"SUELDO BASE",{"$f":"+'Lista de Trabajadores'!H16","v":0},"$",{"$f":"+(E23/E16)*E17","v":0},null,"AFP","Modelo",{"$f":"VLOOKUP(J23,Tasas!B20:C26,2,0)","v":0.10580000000000001},{"$f":"+G27*K23","v":2116}]
[null,null,null,"GRATIFICACION LEGAL",0.25,"$",{"$f":"+G23*E24","v":0},null,"SEG. CESANTIA",null,6.0000000000000001E-3,{"$f":"+G27*K24","v":120}]
[null,null,null,"BONOS PRODUCCION",null,"$",null,null,"Fonasa",null,7.0000000000000007E-2,{"$f":"+G27*K25","v":1400.0000000000002}]
[]
[null,null,null,"TOTAL IMPONIBLE",null,null,{"$f":"+G23+G24+G25+E51+E52+E53+E54","v":20000},null,null,null,null,{"$f":"+L23+L24+L25","v":3636}]
[]
[]
[null,null,null,"ASIG.FAMILIAR \n(Revisar Indicacores)",null,"$",0,null,"PRESTAMOS CUOTA",null,"$",0]
[null,null,null,"LOCOMOCION",null,"$",0,null,"DESCUENTO DE TERCEROS",null,"$",0]
[null,null,null,"COLACION",null,"$",0,null,"OTROS DESCUENTOS",null,"$",0]
[null,null,null,"DESGASTE DE HERRAMIENTAS",null,"$",0]
[null,null,null,"PÉRDIDA DE CAJA",null,"$",0]
[]
[null,null,null,"TOTAL HABER",null,"$",{"$f":"G27+G31+G32+G30+G33+G34","v":20000},null,"TOTAL DESCUENTOS",null,"$",{"$f":"SUM(L27:L32)","v":3636}]
[]
[]
[null,null,null,"CALCULO IMPUESTO UNICO"]
[]
[null,null,null,"RENTA IMPONIBLE",null,"$",{"$f":"G27","v":20000}]
[null,null,null,"DESCTO.PREVISIONAL",null,"$",{"$f":"L27","v":3636}]
[]
[null,null,null,"BASE IMPONIBLE TRIBUTABLE",null,"$",{"$f":"+G41-G42","v":16364}]
[null,null,null,"IMPUESTO A PAGAR**\n(Revisar Indicacores)",null,"$",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SUELDO LIQUIDO","$",{"$f":"+G36-L36-G45","v":16364}]
[null,null,null,"Otras Horas",null,null,null,null,"ANTICIPOS","$",0]
[null,null,null,"Horas Extras",5000,null,null,null,"LIQUIDO A PAGAR","$",{"$f":"+K49-K50","v":16364}]
[null,null,null,"Horas Sábado",10000]
[null,null,null,"Horas Feriados",10000]
[null,null,null,"Horas Menos",-5000]
[]
[null,null,null,null,null,null,null,null,null,"________________________"]
[null,null,null,null,null,null,null,null,null,"RECIBO Y FIRMO CONFORME"]

{"sheet":"Liquidación 4","index":8,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[49,3,49,4],[3,5,3,11],[10,4,10,6],[21,15,21,28],[22,15,22,28],[23,24,23,26]]}
[]
[]
[]
[null,null,null,null,null,"LIQUIDACION DE SUELDO"]
[null,null,null,null,null,null,null,null,"Año:",{"$f":"+Portada!E10","v":"Marzo"},"Año:",{"$f":"+Portada!E11","v":2023}]
[]
[]
[null,null,null,"EMPRESA   :",{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"R.U.T.    :",{"$f":"+Portada!E5","v":"11.111.111-1"},null,null,null,"N°INTERNO",{"$f":"+'Lista de Trabajadores'!C17","v":0}]
[null,null,null,"DIRECCION :",{"$f":"+Portada!E8","v":"Las Condes"},null,null,null,"TRABAJADOR        :",{"$f":"+'Lista de Trabajadores'!D17","v":0}]
[null,null,null,"FONO      :",{"$f":"+Portada!E9","v":"2-222-222-222"},null,null,null,"RUT               :",{"$f":"+'Lista de Trabajadores'!E17","v":0}]
[null,null,null,null,null,null,null,null,"CARGO        :",{"$f":"+'Lista de Trabajadores'!G17","v":0}]
[null,null,null,null,null,null,null,null,"FECHA DE CONTRATO:",{"$f":"+'Lista de Trabajadores'!F17","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"TIPO DE CONTRATO:","Indefinido"]
[]
[null,null,null,"Días del Mes:",31]
[null,null,null,"Días Trabajados:",31]
[null,null,null,"Tope Gratificacion Mensual"]
[]
[null,null,null,null,"HABERES",null,null,null,null,null,"DESCUENTOS"]
[]
[]
[null,null,null,"SUELDO BASE",{"$f":"+'Lista de Trabajadores'!H17","v":0},"$",{"$f":"+(E23/E16)*E17","v":0},null,"AFP","Modelo",{"$f":"VLOOKUP(J23,Tasas!B20:C26,2,0)","v":0.10580000000000001},{"$f":"+G27*K23","v":2116}]
[null,null,null,"GRATIFICACION LEGAL",0.25,"$",{"$f":"+G23*E24","v":0},null,"SEG. CESANTIA",null,6.0000000000000001E-3,{"$f":"+G27*K24","v":120}]
[null,null,null,"BONOS PRODUCCION",null,"$",null,null,"Fonasa",null,7.0000000000000007E-2,{"$f":"+G27*K25","v":1400.0000000000002}]
[]
[null,null,null,"TOTAL IMPONIBLE",null,null,{"$f":"+G23+G24+G25+E51+E52+E53+E54","v":20000},null,null,null,null,{"$f":"+L23+L24+L25","v":3636}]
[]
[]
[null,null,null,"ASIG.FAMILIAR \n(Revisar Indicacores)",null,"$",0,null,"PRESTAMOS CUOTA",null,"$",0]
[null,null,null,"LOCOMOCION",null,"$",0,null,"DESCUENTO DE TERCEROS",null,"$",0]
[null,null,null,"COLACION",null,"$",0,null,"OTROS DESCUENTOS",null,"$",0]
[null,null,null,"DESGASTE DE HERRAMIENTAS",null,"$",0]
[null,null,null,"PÉRDIDA DE CAJA",null,"$",0]
[]
[null,null,null,"TOTAL HABER",null,"$",{"$f":"G27+G31+G32+G30+G33+G34","v":20000},null,"TOTAL DESCUENTOS",null,"$",{"$f":"SUM(L27:L32)","v":3636}]
[]
[]
[null,null,null,"CALCULO IMPUESTO UNICO"]
[]
[null,null,null,"RENTA IMPONIBLE",null,"$",{"$f":"G27","v":20000}]
[null,null,null,"DESCTO.PREVISIONAL",null,"$",{"$f":"L27","v":3636}]
[]
[null,null,null,"BASE IMPONIBLE TRIBUTABLE",null,"$",{"$f":"+G41-G42","v":16364}]
[null,null,null,"IMPUESTO A PAGAR**\n(Revisar Indicacores)",null,"$",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SUELDO LIQUIDO","$",{"$f":"+G36-L36-G45","v":16364}]
[null,null,null,"Otras Horas",null,null,null,null,"ANTICIPOS","$",0]
[null,null,null,"Horas Extras",5000,null,null,null,"LIQUIDO A PAGAR","$",{"$f":"+K49-K50","v":16364}]
[null,null,null,"Horas Sábado",10000]
[null,null,null,"Horas Feriados",10000]
[null,null,null,"Horas Menos",-5000]
[]
[null,null,null,null,null,null,null,null,null,"________________________"]
[null,null,null,null,null,null,null,null,null,"RECIBO Y FIRMO CONFORME"]

{"sheet":"Liquidación 5","index":9,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[49,3,49,4],[3,5,3,11],[10,4,10,6],[21,15,21,28],[22,15,22,28],[23,24,23,26]]}
[]
[]
[]
[null,null,null,null,null,"LIQUIDACION DE SUELDO"]
[null,null,null,null,null,null,null,null,"Año:",{"$f":"+Portada!E10","v":"Marzo"},"Año:",{"$f":"+Portada!E11","v":2023}]
[]
[]
[null,null,null,"EMPRESA   :",{"$f":"+Portada!E4","v":"NUBOX"}]
[null,null,null,"R.U.T.    :",{"$f":"+Portada!E5","v":"11.111.111-1"},null,null,null,"N°INTERNO",{"$f":"+'Lista de Trabajadores'!C18","v":0}]
[null,null,null,"DIRECCION :",{"$f":"+Portada!E8","v":"Las Condes"},null,null,null,"TRABAJADOR        :",{"$f":"+'Lista de Trabajadores'!D18","v":0}]
[null,null,null,"FONO      :",{"$f":"+Portada!E9","v":"2-222-222-222"},null,null,null,"RUT               :",{"$f":"+'Lista de Trabajadores'!E18","v":0}]
[null,null,null,null,null,null,null,null,"CARGO        :",{"$f":"+'Lista de Trabajadores'!G18","v":0}]
[null,null,null,null,null,null,null,null,"FECHA DE CONTRATO:",{"$f":"+'Lista de Trabajadores'!F18","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"TIPO DE CONTRATO:","Indefinido"]
[]
[null,null,null,"Días del Mes:",31]
[null,null,null,"Días Trabajados:",31]
[null,null,null,"Tope Gratificacion Mensual"]
[]
[null,null,null,null,"HABERES",null,null,null,null,null,"DESCUENTOS"]
[]
[]
[null,null,null,"SUELDO BASE",{"$f":"+'Lista de Trabajadores'!H18","v":0},"$",{"$f":"+(E23/E16)*E17","v":0},null,"AFP","Modelo",{"$f":"VLOOKUP(J23,Tasas!B20:C26,2,0)","v":0.10580000000000001},{"$f":"+G27*K23","v":2116}]
[null,null,null,"GRATIFICACION LEGAL",0.25,"$",{"$f":"+G23*E24","v":0},null,"SEG. CESANTIA",null,6.0000000000000001E-3,{"$f":"+G27*K24","v":120}]
[null,null,null,"BONOS PRODUCCION",null,"$",null,null,"Fonasa",null,7.0000000000000007E-2,{"$f":"+G27*K25","v":1400.0000000000002}]
[]
[null,null,null,"TOTAL IMPONIBLE",null,null,{"$f":"+G23+G24+G25+E51+E52+E53+E54","v":20000},null,null,null,null,{"$f":"+L23+L24+L25","v":3636}]
[]
[]
[null,null,null,"ASIG.FAMILIAR \n(Revisar Indicacores)",null,"$",0,null,"PRESTAMOS CUOTA",null,"$",0]
[null,null,null,"LOCOMOCION",null,"$",0,null,"DESCUENTO DE TERCEROS",null,"$",0]
[null,null,null,"COLACION",null,"$",0,null,"OTROS DESCUENTOS",null,"$",0]
[null,null,null,"DESGASTE DE HERRAMIENTAS",null,"$",0]
[null,null,null,"PÉRDIDA DE CAJA",null,"$",0]
[]
[null,null,null,"TOTAL HABER",null,"$",{"$f":"G27+G31+G32+G30+G33+G34","v":20000},null,"TOTAL DESCUENTOS",null,"$",{"$f":"SUM(L27:L32)","v":3636}]
[]
[]
[null,null,null,"CALCULO IMPUESTO UNICO"]
[]
[null,null,null,"RENTA IMPONIBLE",null,"$",{"$f":"G27","v":20000}]
[null,null,null,"DESCTO.PREVISIONAL",null,"$",{"$f":"L27","v":3636}]
[]
[null,null,null,"BASE IMPONIBLE TRIBUTABLE",null,"$",{"$f":"+G41-G42","v":16364}]
[null,null,null,"IMPUESTO A PAGAR**\n(Revisar Indicacores)",null,"$",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SUELDO LIQUIDO","$",{"$f":"+G36-L36-G45","v":16364}]
[null,null,null,"Otras Horas",null,null,null,null,"ANTICIPOS","$",0]
[null,null,null,"Horas Extras",5000,null,null,null,"LIQUIDO A PAGAR","$",{"$f":"+K49-K50","v":16364}]
[null,null,null,"Horas Sábado",10000]
[null,null,null,"Horas Feriados",10000]
[null,null,null,"Horas Menos",-5000]
[]
[null,null,null,null,null,null,null,null,null,"________________________"]
[null,null,null,null,null,null,null,null,null,"RECIBO Y FIRMO CONFORME"]

{"sheet":"Tasas","index":10,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":true,"merged":[[58,1,58,6],[1,3,1,8],[10,2,10,4],[13,3,13,4],[13,5,14,6],[17,1,18,1],[17,2,17,3],[26,1,26,4],[17,6,18,6],[17,7,17,8],[23,6,24,7],[23,8,24,8],[25,6,25,8],[30,6,30,7],[40,1,40,2],[40,3,42,4],[30,1,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[43,2,43,4],[46,1,46,6],[47,2,47,3],[36,3,36,4],[37,1,37,4]]}
[]
[null,null,null,"TASAS / INDICADORES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"INDICADORES DIARIOS",null,"(*) Recuerda que hay indicadores que cambian todos los días."]
[null,null,null,"BANCO CENTRAL","¡Pincha aquí!"]
[]
[]
[null,"TASA AFP TRABAJADORES","DEPENDIENTES",null,"INDEPENDIENTES",null,"SEGURO DE CESANTÍA (AFC) TIPO DE CONTRATO","FINANCIAMIENTO"]
[null,null,"TASA AFP","SIS (1) (2)","TASA AFP (3)",null,null,"EMPLEADOR","TRABAJADOR"]
[null,"Capital",0.1144,1.49E-2,0.1293,null,"Plazo Indefinido","2,4% R.I.","0,6% R.I."]
[null,"Cuprum",0.1144,1.49E-2,0.1293,null,"Plazo Fijo","3,0% R.I.","–"]
[null,"Habitat",0.11269999999999999,1.49E-2,0.12759999999999999,null,"Plazo Indefinido 11 años o más (*)","0,8% R.I.","–"]
[null,"PlanVital",0.1116,1.49E-2,0.1265,null,"Trabajador de Casa Particular (**)","3,0% R.I.","–"]
[null,"ProVida",0.1145,1.49E-2,0.12939999999999999,null,"(*) Para revisar más antecedentes sobre el seguro de cesantía, recuerda revisar su plataforma WEB. ",null,"¡Pincha Aquí!"]
[null,"Modelo",0.10580000000000001,1.49E-2,0.1207]
[null,"Uno",0.10489999999999999,1.49E-2,0.1198,null,"¿Qué es el seguro de Cesantía en Chile y quién lo paga?"]
[null,"Leyes Sociales en Chile: ¡claves que debes saber!"]
[]
[]
[]
[null,"ASIGNACIÓN FAMILIAR SEGÚN TRAMO",null,null,null,null,"TOPES LEGALES DE LAS RENTAS IMPONIBLES "]
[null,null,null,null,null,null,"Para afiliados a una AFP (84,3 UF):",3126984]
[null,"TRAMO","MONTO","REQUISITO DE RENTA",null,null,"Para afiliados al IPS (ex INP) (60 UF):",2211390]
[null,"1 (A)",20328,"Renta < ó = $ 539.328",null,null,"Para Seguro de Cesantía (126,6 UF):",4696040]
[null,"2 (B)",12475,"Renta > $ 539.628 < = $ 787.746",null,null,"(*) Recuerda que a partir de enero 2024, se visualizan algunos ajustes ","¡Revisa Acá!"]
[null,"3 (C)",3942,"Renta > $ 787.746 < = $ 1.228.614"]
[null,"4 (D)","–","Renta > $1.228.614"]
[null,"¿Cómo se calcula la asignación familiar en Chile?"]
[]
[]
[null,"DISTRIBUCIÓN DEL 7% SALUD, PARA EMPLEADOR AFILIADO A CCAF (*)",null,"(*) Es importante considerar que FONASA es un7% de su cotización obligatoria, por lo que este desglose aplica sólo para aquellos que pertenecen a una caja de compensación. "]
[null,"CCAF","4.9 % R.I."]
[null,"FONASA","2.1 % R.I."]
[null,"¡Pincha Aquí!","Recuerda revisar que tus trabajadores se encuentren afiliados a FONASA."]
[]
[]
[null,"Monto de Cálculo del Impuesto Único de Segunda Categoría"]
[null,"Períodos","Monto de la renta líquida imponible",null,"Factor","Cantidad a rebajar","Tasa de Impuesto Efectiva, máxima por cada tramo de Renta"]
[null,null,"Desde","Hasta","Revisa en línea !quí!"]
[null,"MENSUAL","-.-",866916,"Exento","-.-","Exento"]
[null,null,866916.01,1926480,0.04,34676.639999999999,2.1999999999999999E-2]
[null,null,1926480.01,3210800,0.08,111735.84,4.5199999999999997E-2]
[null,null,3210800.01,4495120,0.13500000000000001,288329.84000000003,7.0900000000000005E-2]
[null,null,4495120.01,5779440,0.23,715366.24,0.1062]
[null,null,5779440.0099999998,7705920,0.30399999999999999,1143044.8,0.15570000000000001]
[null,null,7705920.0099999998,19906960,0.35,1497517.12,0.27479999999999999]
[null,null,19906960.010000002,"Y MÁS",0.4,2492865.12,"MÁS DE 27,48%"]
[]
[null,"Artículos que te pueden interesar "]
[null,"Revisa nuestros artículos: \n","¿Cómo calcular el Impuesto Único?\n","¿Qué tipos de remuneraciones hay en Chile?","¿Cómo hacer una liquidación de sueldo en Chile?","¿Cómo se pagan las horas extras en Chile?","6 recomendaciones a la hora de realizar el pago de sueldos"]

{"sheet":"instructivo","index":11,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[[22,10,22,17],[12,10,12,17],[16,10,17,17],[18,10,19,17],[20,10,20,17],[13,10,15,17],[18,1,19,8],[16,1,17,8],[33,1,34,8],[24,1,26,8],[20,1,20,8],[27,1,27,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Notas iniciales",null,null,null,null,"Antecedentes importantes de la Planilla de Trabajo"]
[null,"**Al abrir este archivo, recuerda habilitar el contenido para macros.",null,null,null,null,null,null,null,null,"**Esta herramienta de trabajo esta diseñada para una microempresa de no más de 5 trabajadores"]
[null,null,null,null,null,null,null,null,null,null,"** Tiene espacios de trabajo 100% automátizados, otros semi automáticos y algunos que se deberán modificar de manera manual, según correpsonda"]
[]
[]
[null,"** Verificar las opciones avanzadas de tu excel para acceder al formato de trabajo de esta plantilla (Visual Basic).",null,null,null,null,null,null,null,null,"*Libro de Remuneraciones 100% automático. La información deriva de las liquidaciones de sueldos."]
[]
[null,"**Para guardar el archivo en el computador de trabajo, se debe guardar como documento habilitado para macros.",null,null,null,null,null,null,null,null,"** Liquidaciones de sueldos semiautomáticas. Se debe actualizar la información de las listas desplegables, la información manual y dejar sin modificaciones las fórmulas de llenado automático."]
[]
[null,"**Al guardar el documento aparecerá este mensaje, el cual deberás aceptar para respetar fórmulas.",null,null,null,null,null,null,null,null,"** Este Libro de Remuneraciones se puede complementar información que debe ser subida a la Dirección del Trabajo. Sin embargo,  éste está diseñado para cálculos de centralización de gastos de personal y derivar información mensual a un libro diario, para posterior balance general de ser necesario."]
[]
[null,null,null,null,null,null,null,null,null,null,"** Es imortante que actualices los antecedentes en las tasas de indicadores según PREVIRED, cada vez que sea necesario. Así mantendrás al día los % de prevision social."]
[]
[]
[]
[]
[null,"**Al abrir el documento se desplegará este mensaje. Haz clic en no actualizar, para mantener fórmulas."]
[]
[]
[]
[]
[]
[null,"**Recuerda revisar todos los mensajes de ayuda y alerta en las páginas dinámicas con las que se trabajarán en este KIT. "]

{"sheet":"Hoja1","index":12,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[[3,10,6,10],[3,11,3,13],[4,11,4,13],[5,11,5,12]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AFP","TASA COTIZACIÓN OBLIGATORIO AFP"]
[null,"Enero ",null,"Plazo Fijo",null,"Fonasa ",null,"Capital",null,null,null,"TASA AFP TRABAJADORES"]
[null,"Febrero",null,"Plazo Indefinido",null,"Isapre",null,"Cuprum",null,null,null,"DEPENDIENTES",null,"INDEPENDIENTES"]
[null,"Marzo",null,"Part Time",null,null,null,"Habitat",null,null,null,"TASA AFP","SIS (1) (2)","TASA AFP (3)"]
[null,"Abril",null,"Vinculo Laboral",null,null,null,"Modelo",null,null,"Capital",0.1144,1.9400000000000001E-2,0.1338]
[null,"Mayo",null,"Obra",null,null,null,"Provida",null,null,"Cuprum",0.1144,1.9400000000000001E-2,0.1338]
[null,"Junio",null,null,null,null,null,"Uno",null,null,"Habitat",0.11269999999999999,1.9400000000000001E-2,0.1321]
[null,"Julio",null,null,null,null,null,null,null,null,"PlanVital",0.1116,1.9400000000000001E-2,0.13100000000000001]
[null,"Agosto",null,null,null,null,null,null,null,null,"ProVida",0.1145,1.9400000000000001E-2,0.13389999999999999]
[null,"Septiembre",null,null,null,null,null,null,null,null,"Modelo",0.1077,1.9400000000000001E-2,0.12709999999999999]
[null,"Octubre",null,null,null,null,null,null,null,null,"Uno",0.1069,1.9400000000000001E-2,0.1263]
[null,"Noviembre"]
[null,"Diciembre",null,null,null,null,null,"Fijo","Isapre"]
[null,null,null,null,null,null,null,"Indefinido","Fonasa"]