{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["PANEL","cia","parametros","personal","otros","destajo","comisiones","horas extras","data","LIQUID","Reporte","Detalle"],"not_rendered":{"charts":0,"images":18,"macros":1,"external_links":0,"defined_names":33,"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":"PANEL","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"cia","index":1,"n_rows":16,"n_cols":22,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,1,0,3]]}
[null,"DATOS DE LA EMPRESA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MONTH($V$1)=Q1,DAY($V$1),0)","v":0},{"$f":"IF(mesi>\"\",MONTH(mesi),\"\")","v":5},{"$f":"IF(MONTH($U$1)=Q1,DAY($U$1),0)","v":1},{"$f":"IF(R1>0,(30-R1)+1,0)","v":30},null,"2015-05-01","00:00:00"]
[null,"EMPRESA",":","ARCHIVO EXCEL E.I.R.L.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MONTH($V$1)=Q2,DAY($V$1),0)","v":0},{"$f":"IF(AND(Q1>0,Q1<12),Q1+1,IF(AND(Q1>0,Q1=12),1,\"\"))","v":6},{"$f":"IF(MONTH($U$1)=Q2,DAY($U$1),0)","v":0},{"$f":"IF(R2>0,(30-R2)+1,IF(AND(R2=0,S1>0,P2=0,P1=0),30,IF(AND(R2=0,P2>0),P2,0)))","v":30}]
[null,"R.U.C.",":","20123456789",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(Q2>0,Q2<12),Q2+1,IF(AND(Q2>0,Q2=12),1,\"\"))","v":7},{"$f":"IF(MONTH($U$1)=Q3,DAY($U$1),0)","v":0},30]
[null,"DIRECCION",":","AV. LIMA",null,null,null,null,null,null,null,"01","LE / DNI",null,"Soltero",0,{"$f":"IF(AND(Q3>0,Q3<12),Q3+1,IF(AND(Q3>0,Q3=12),1,\"\"))","v":8},0,30]
[null,"NUMERO",":","3707",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(Q4>0,Q4<12),Q4+1,IF(AND(Q4>0,Q4=12),1,\"\"))","v":9},0,30]
[null,"REFERENCIA",":","LIMA",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(Q5>0,Q5<12),Q5+1,IF(AND(Q5>0,Q5=12),1,\"\"))","v":10},0,30]
[null,"DISTRITO",":","LIMA",null,null,null,null,null,null,null,"02","C. E.",null,"Soltera",null,null,null,{"$f":"SUM(S1:S6)","v":180}]
[null,"REPRESENTANTE LEGAL",":","GONZALES ARRIETA GABRIEL",null,null,null,null,null,null,null,"03","C. M / P",null,"Conviviente",null,null,"Saldo de días periodo anterior",10]
[null,"D. N. I. N°",":","09494258",null,null,null,null,null,null,null,null,null,null,"Casado",null,null,null,{"$f":"SUM(S7:S8)","v":190}]
[{"$f":"MONTH(mesi)","v":5},"MES DE INICIO",":","MAYO - 2015"]
[null,"FECHA DE INICIO",":","2015-05-01"]
[null,"MES FINAL",":","OCTUBRE - 2015"]
[null,"FECHA FIN",":","2015-10-31"]
[null,"TOTAL DIAS DEL PERIODO",":","180"]
[null,"FECHA DE DEPÓSITO",":","2015-11-15"]
[null,"FECHA ENTREGA CONSTAN",":","2015-11-15"]

{"sheet":"parametros","index":2,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":true,"merged":[[8,3,8,4],[14,3,14,4],[0,0,0,1],[6,0,6,1],[1,3,6,4]]}
["PERSONAL"]
["N°","TIPO DOCUMTO.",null,"En  el  caso  de  comisionistas,  destajeros  y, en  general,  de  trabajadores  que   perciban remuneración  principal  imprecisa,  la  remuneración   computable  se  establece en base al promedio de las comisiones, destajo o  remuneración  principal  imprecisa  percibidas por el trabajador  en  el  semestre respectivo. Si el período a liquidarse fuese inferior a seis meses, la  remuneración  computable  se  establecerá  en  base  al  promedio  diario de lo percibido durante dicho período. Base Legal Art. 17 D.S. N.º 001-97-TR."]
["1","DNI"]
["4","CARNET DE EXTRANJERÍA"]
["7","PASAPORTE"]
[]
["OTROS INGRESOS"]
[1,"Movilidad"]
[2,"……",null,"MONEDA"]
[3,"……",null,"N°","                  DESCRIPCIÓN"]
[4,"……",null,"1","NUEVOS SOLES"]
[null,null,null,"2","DÓLARES AMERICANOS"]
[null,null,null,"9","OTRA MONEDA (ESPECIFICAR)"]
[]
[null,null,null,"BANCOS"]
[null,null,null,"N°","DESCRIPCIÓN"]
[null,null,null,"00","OTROS (ESPECIFICAR)"]
[null,null,null,"02","DE CRÉDITO DEL PERÚ"]
[null,null,null,"03","INTERBANK"]
[null,null,null,"05","LATINO"]
[null,null,null,"07","CITYBANK N.A."]
[null,null,null,"08","STANDARD CHARTERED                 "]
[null,null,null,"09","WIESE SUDAMERIS"]
[null,null,null,"11","CONTINENTAL"]
[null,null,null,"12","DE LIMA"]
[null,null,null,"16","MERCANTIL"]
[null,null,null,"18","NACIÓN"]
[null,null,null,"22","SANTANDER CENTRAL HISPANO - PERÚ"]
[null,null,null,"23","DE COMERCIO"]
[null,null,null,"25","REPUBLICA"]
[null,null,null,"26","NBK BANK"]
[null,null,null,"29","BANCOSUR"]
[null,null,null,"35","FINANCIERO DEL PERÚ"]
[null,null,null,"37","DEL PROGRESO"]
[null,null,null,"38","INTERAMERICANO FINANZAS"]
[null,null,null,"39","BANEX"]
[null,null,null,"40","NUEVO MUNDO"]
[null,null,null,"41","SUDAMERICANO"]
[null,null,null,"42","DEL LIBERTADOR"]
[null,null,null,"43","DEL TRABAJO"]
[null,null,null,"44","SOLVENTA"]
[null,null,null,"45","SERBANCO"]
[null,null,null,"46","BANK OF BOSTON"]
[null,null,null,"47","ORIÓN"]
[null,null,null,"48","DEL PAÍS"]
[null,null,null,"49","MI BANCO"]
[null,null,null,"50","DE PARIS"]
[null,null,null,"51","BANQUE BNP PARIBAS - ANDES"]
[null,null,null,"52","MIBANCO BANCO DE LA MICROEMPRESA - MIBANCO"]
[null,null,null,"53","BANCO DE LA NACIÓN"]
[null,null,null,"54","CORPORACIÓN FINANCIERA DE DESARROLLO - COFIDE"]
[null,null,null,"55","FINANCIERA CMR"]
[null,null,null,"56","FINANCIERA VOLVO FINANCE DEL PERÚ"]
[null,null,null,"57","CAJA MUNICIPAL DE AHORRO Y CRÉDITO AREQUIPA"]
[null,null,null,"58","CAJA MUNICIPAL DE AHORRO Y CRÉDITO CHINCHA"]
[null,null,null,"59","CAJA MUNICIPAL DE AHORRO Y CRÉDITO CUSCO"]
[null,null,null,"60","CAJA MUNICIPAL DE AHORRO Y CRÉDITO DEL SANTA"]
[null,null,null,"61","CAJA MUNICIPAL DE AHORRO Y CRÉDITO HUANCAYO"]
[null,null,null,"62","CAJA MUNICIPAL DE AHORRO Y CRÉDITO ICA"]
[null,null,null,"63","CAJA MUNICIPAL DE AHORRO Y CRÉDITO MAYNAS"]
[null,null,null,"64","CAJA MUNICIPAL DE AHORRO Y CRÉDITO PAITA"]
[null,null,null,"65","CAJA MUNICIPAL DE AHORRO Y CRÉDITO PISCO"]
[null,null,null,"66","CAJA MUNICIPAL DE AHORRO Y CRÉDITO PIURA"]
[null,null,null,"67","CAJA MUNICIPAL DE AHORRO Y CRÉDITO SULLANA"]
[null,null,null,"68","CAJA MUNICIPAL DE AHORRO Y CRÉDITO TACNA"]
[null,null,null,"69","CAJA MUNICIPAL DE AHORRO Y CRÉDITO TRUJILLO"]
[null,null,null,"70","CAJA MUNICIPAL DE CRÉDITO POPULAR LIMA"]
[null,null,null,"71","CAJA RURAL DE AHORRO Y CRÉDITO CAJAMARCA"]
[null,null,null,"72","CAJA RURAL DE AHORRO Y CRÉDITO DEL SUR"]
[null,null,null,"73","CAJA RURAL DE AHORRO Y CRÉDITO CHAVÍN"]
[null,null,null,"74","CAJA RURAL DE AHORRO Y CRÉDITO CRUZ DE CHALPÓN"]
[null,null,null,"75","CAJA RURAL DE AHORRO Y CRÉDITO LOS LIBERTADORES DE AYACUCHO"]
[null,null,null,"76","CAJA RURAL DE AHORRO Y CRÉDITO LOS ANDES"]
[null,null,null,"77","CAJA RURAL DE AHORRO Y CRÉDITO NOR PERÚ"]
[null,null,null,"78","CAJA RURAL DE AHORRO Y CRÉDITO PROFINANZAS"]
[null,null,null,"79","CAJA RURAL DE AHORRO Y CRÉDITO PRYMERA"]
[null,null,null,"80","CAJA RURAL DE AHORRO Y CRÉDITO QUILLABAMBA - CREDINKA"]
[null,null,null,"81","CAJA RURAL DE AHORRO Y CRÉDITO DE LA REGIÓN DE SAN MARTÍN"]
[null,null,null,"82","CAJA RURAL DE AHORRO Y CRÉDITO SEÑOR DE LUREN"]
[null,null,null,"99","BANCOS DEL EXTERIOR"]

{"sheet":"personal","index":3,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,8,2,8],[1,9,2,9],[0,1,0,12],[1,1,1,3],[1,5,2,5],[1,6,2,6]]}
["x","DATOS PERSONALES"]
["x","APELLIDOS Y NOMBRES",null,null,"NÚMERO","FECHA DE INGRESO","CARGO","TIPO","Jornal","Remuneración","ENTIDAD","NÚMERO DE"]
["Cod","PATERNO","MATERNO","NOMBRES","DOCUMENTO",null,null,"DOC",null,null,"FINANCIERA","CUENTA","MONEDA"]

{"sheet":"otros","index":4,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,7,1,7],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6]]}
[null,"DATOS PERSONALES","Asignac. Familiar",{"$f":"IF(parametros!B8>\"\",parametros!B8,\"\")","v":"Movilidad"},{"$f":"IF(parametros!B9>\"\",parametros!B9,\"\")","v":"……"},{"$f":"IF(parametros!B10>\"\",parametros!B10,\"\")","v":"……"},{"$f":"IF(parametros!B11>\"\",parametros!B11,\"\")","v":"……"},"Última Gratificación"]
["Cod","APELLIDOS Y NOMBRES"]

{"sheet":"destajo","index":5,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":true,"merged":[[6,18,6,19],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,15,2,15],[1,14,2,14],[0,1,1,1],[0,2,0,15],[1,2,1,3],[1,4,1,5],[1,6,1,7]]}
[null,"DATOS PERSONALES","Destajo"]
[null,null,{"$f":"IF(mesi>\"\",MONTH(mesi),\"\")","v":5},null,{"$f":"IF(AND(C2>0,C2<12),C2+1,IF(AND(C2>0,C2=12),1,\"\"))","v":6},null,{"$f":"IF(AND(E2>0,E2<12),E2+1,IF(AND(E2>0,E2=12),1,\"\"))","v":7},null,{"$f":"IF(AND(G2>0,G2<12),G2+1,IF(AND(G2>0,G2=12),1,\"\"))","v":8},null,{"$f":"IF(AND(I2>0,I2<12),I2+1,IF(AND(I2>0,I2=12),1,\"\"))","v":9},null,{"$f":"IF(AND(K2>0,K2<12),K2+1,IF(AND(K2>0,K2=12),1,\"\"))","v":10},null,"Tipo","Promedio"]
["Cod","APELLIDOS Y NOMBRES","Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días"]

{"sheet":"comisiones","index":6,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,15,2,15],[0,1,1,1],[0,2,0,15],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,2,14]]}
[null,"DATOS PERSONALES","Comisiones"]
[null,null,{"$f":"IF(mesi>\"\",MONTH(mesi),\"\")","v":5},null,{"$f":"IF(AND(C2>0,C2<12),C2+1,IF(AND(C2>0,C2=12),1,\"\"))","v":6},null,{"$f":"IF(AND(E2>0,E2<12),E2+1,IF(AND(E2>0,E2=12),1,\"\"))","v":7},null,{"$f":"IF(AND(G2>0,G2<12),G2+1,IF(AND(G2>0,G2=12),1,\"\"))","v":8},null,{"$f":"IF(AND(I2>0,I2<12),I2+1,IF(AND(I2>0,I2=12),1,\"\"))","v":9},null,{"$f":"IF(AND(K2>0,K2<12),K2+1,IF(AND(K2>0,K2=12),1,\"\"))","v":10},null,"Tipo","Promedio"]
["Cod","APELLIDOS Y NOMBRES","Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días"]

{"sheet":"horas extras","index":7,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,2,0,8]]}
[null,"DATOS PERSONALES","Horas Extras"]
["Cod","APELLIDOS Y NOMBRES",{"$f":"IF(mesi>\"\",MONTH(mesi),\"\")","v":5},{"$f":"IF(AND(C2>0,C2<12),C2+1,IF(AND(C2>0,C2=12),1,\"\"))","v":6},{"$f":"IF(AND(D2>0,D2<12),D2+1,IF(AND(D2>0,D2=12),1,\"\"))","v":7},{"$f":"IF(AND(E2>0,E2<12),E2+1,IF(AND(E2>0,E2=12),1,\"\"))","v":8},{"$f":"IF(AND(F2>0,F2<12),F2+1,IF(AND(F2>0,F2=12),1,\"\"))","v":9},{"$f":"IF(AND(G2>0,G2<12),G2+1,IF(AND(G2>0,G2=12),1,\"\"))","v":10},"Promedio"]

{"sheet":"data","index":8,"n_rows":3,"n_cols":40,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,2,1,4]]}
[null,"DATOS GENERALES",null,null,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":"SUM(AC4:AC50000)","v":0}]
[null,null,"Básico",null,null,null,null,null,null,null,null,"Asignac.",null,null,null,null,null,"Total",null,"Días",null,"FECHA DE","Cant.","Cant.","Tasa","Tasa"]
["Cod","Apellidos y Nombres","Jornal","Días T","Remunerac.","Básico","Destajo","Comisión","Horas Extras",{"$f":"IF(detalle1>\"\",detalle1,\"\")","v":"Movilidad"},"Gratificac.","A. Familiar",{"$f":"IF(detalle2>\"\",detalle2,\"\")","v":"……"},{"$f":"IF(detalle3>\"\",detalle3,\"\")","v":"……"},{"$f":"IF(detalle4>\"\",detalle4,\"\")","v":"……"},"Remu. Comput.","x","T. Días","Faltas","D. Compu.","Periodo","DEPÓSITO","Meses","Días","Factor Mes","Factor Días","Importe Meses","Importe Días","Total CTS","Tipo Doc","Num Doc","Paterno","Materno","Nombres","Banco","Cuenta","Moneda","F Inicio","Importe Grati","Fecha Cese"]

{"sheet":"LIQUID","index":9,"n_rows":48,"n_cols":33,"rows_kept":48,"cut":false,"hidden":true,"merged":[[11,8,11,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[29,23,29,24],[6,1,6,11],[6,16,6,26],[22,23,22,24],[23,23,23,24],[24,23,24,24],[25,23,25,24],[28,8,28,9],[9,1,9,11],[26,23,26,24],[27,23,27,24],[29,8,29,9],[9,16,9,26],[11,23,11,24],[19,23,19,24],[24,8,24,9],[20,23,20,24],[21,23,21,24],[26,8,26,9],[27,8,27,9],[28,23,28,24],[25,8,25,9],[23,8,23,9]]}
[]
[]
[]
[]
[null,null,null,null,null,null,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":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!$A$4:$AN$1048576,40,0))","v":""}]
[null,"LIQUIDACIÓN DE DEPÓSITO SEMESTRAL DE CTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIQUIDACIÓN DE DEPÓSITO SEMESTRAL DE CTS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L15>0,L15/30,0)","v":0},{"$f":"INT(AD6)","v":0}]
[null,{"$f":"CONCATENATE(mesi,\"   -   \",mesf)","v":"MAYO - 2015   -   OCTUBRE - 2015"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(mesi,\"   -   \",mesf)","v":"MAYO - 2015   -   OCTUBRE - 2015"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,personal!$A$4:$M$1048576,5,0))","v":""},{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,personal!$A$4:$M$1048576,6,0))","v":""},null,{"$f":"TEXT(AD7,\"0#######\")","v":""}]
[]
[]
[null,{"$f":"CONCATENATE(cia,\" con R.U.C. N° \",ruc,\", con domicilio en \",direccion,\" N° \", numero,\" - \",referencia,\" - \",distrito,\", debidamente representada por su Gerente General el Sr. \",gerente,\", identificado con D.N.I. N° \",TEXT(dni,\"00######\"),\", en aplicación del artículo 24° del TUO del D. Leg. N° 650 - Ley de Compensación por Tiempo de Servicios aprobado mediante el D.S. N° 001-97-TR, otorga a \",LIQUID!AC7,\"  identificado con DNI Nº \",TEXT(LIQUID!AG7,\"00######\"),\", la presente constancia del depósito de su Compensación por Tiempo de Servicios realizado, el día \",TEXT(LIQUID!AC10,\"dd/mm/yyyy\"),\", en la cuenta CTS Nº \",LIQUID!AD10,\" - \",LIQUID!AD12,\", del Banco \",LIQUID!AC12,\", por los siguientes montos y períodos:\")","v":"ARCHIVO EXCEL E.I.R.L. con R.U.C. N° 20123456789, con domicilio en AV. LIMA N° 3707 - LIMA - LIMA, debidamente representada por su Gerente General el Sr. GONZALES ARRIETA GABRIEL, identificado con D.N.I. N° 09494258, en aplicación del artículo 24° del TUO del D. Leg. N° 650 - Ley de Compensación por Tiempo de Servicios aprobado mediante el D.S. N° 001-97-TR, otorga a   identificado con DNI Nº , la presente constancia del depósito de su Compensación por Tiempo de Servicios realizado, el día , en la cuenta CTS Nº  - , del Banco , por los siguientes montos y períodos:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10>\"\",B10,\"\")","v":"ARCHIVO EXCEL E.I.R.L. con R.U.C. N° 20123456789, con domicilio en AV. LIMA N° 3707 - LIMA - LIMA, debidamente representada por su Gerente General el Sr. GONZALES ARRIETA GABRIEL, identificado con D.N.I. N° 09494258, en aplicación del artículo 24° del TUO del D. Leg. N° 650 - Ley de Compensación por Tiempo de Servicios aprobado mediante el D.S. N° 001-97-TR, otorga a   identificado con DNI Nº , la presente constancia del depósito de su Compensación por Tiempo de Servicios realizado, el día , en la cuenta CTS Nº  - , del Banco , por los siguientes montos y períodos:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,PERSONALDATA,22,0))","v":""},{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,personal!$A$4:$M$1048576,12,0))","v":""}]
[]
[null,"1.-","Período(s) que se liquida(n):",null,null,null,null,"Del",{"$f":"IF(AE7>=fechai,AE7,IF(AE7<fechai,fechai,\"\"))","v":""},null,"al",{"$f":"IF(AE5>0,AE5,fechaf)","v":""},null,null,null,null,"1.-","Período(s) que se liquida(n):",null,null,null,null,"Del",{"$f":"IF(I12>0,I12,\"\")","v":""},null,"al",{"$f":"IF(L12>0,L12,\"\")","v":""},null,{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,personal!$A$4:$M$1048576,11,0))","v":""},{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,personal!$A$4:$M$1048576,13,0))","v":""}]
[null,null,null,null,null,null,null,"Total días:",null,null,":",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,18,0))","v":""},null,null,null,null,null,null,null,null,null,null,"Total días:",null,null,":",{"$f":"IF(L13>0,L13,\"\")","v":""}]
[null,null,null,null,null,null,null,"Faltas",null,null,":",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,19,0))","v":""},null,null,null,null,null,null,null,null,null,null,"Faltas",null,null,":",{"$f":"IF(L14>=0,L14,\"\")","v":""}]
[null,null,null,null,null,null,null,"Días computables",null,null,":",{"$f":"IF(AC6=\"\",0,VLOOKUP(AC6,data!A$4:AC$1048576,20,0))","v":0},null,null,null,null,null,null,null,null,null,null,"Días computables",null,null,":",{"$f":"IF(L15>0,L15,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"Meses",null,null,":",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,23,0))","v":""},null,null,null,null,null,null,null,null,null,null,"Meses",null,null,":",{"$f":"IF(L17>0,L17,\"\")","v":""}]
[null,null,null,null,null,null,null,"Días",null,null,":",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,24,0))","v":""},null,null,null,null,null,null,null,null,null,null,"Días",null,null,":",{"$f":"IF(L18>=0,L18,\"\")","v":""}]
[null,"2.-","Remuneración Computable",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.-","Remuneración Computable"]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!F3)","v":"-  Básico"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,6,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E20>0,E20,\"\")","v":"-  Básico"},null,null,"S/.",{"$f":"IF(I20>=0,I20,0)","v":""}]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!G3)","v":"-  Destajo"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,7,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  Destajo",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!H3)","v":"-  Comisión"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,8,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  Comisión",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!I3)","v":"-  Horas Extras"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,9,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  Horas Extras",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!L2,\" \",data!L3)","v":"-  Asignac. A. Familiar"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,12,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  Asignac. A. Familiar",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!K3)","v":"-  Gratificac."},null,null,"S/.",{"$f":"ROUND(IF(AC6=\"\",0,VLOOKUP(AC6,data!A$4:AC$1048576,11,0)),2)","v":0},null,null,null,null,null,null,null,null,null,null,"-  Gratificac.",null,null,"S/.",0]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!J3)","v":"-  Movilidad"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,10,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  Movilidad",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!M3)","v":"-  ……"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,13,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  ……",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!N3)","v":"-  ……"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,14,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  ……",null,null,"S/.",""]
[null,null,null,null,{"$f":"CONCATENATE(\"-  \",data!O3)","v":"-  ……"},null,null,"S/.",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,15,0))","v":""},null,null,null,null,null,null,null,null,null,null,"-  ……",null,null,"S/.",""]
[null,null,null,null,"TOTAL REMUNERACIÓN",null,null,"S/.",{"$f":"SUM(I20:I29)","v":0},null,null,null,null,null,null,null,null,null,null,"TOTAL REMUNERACIÓN",null,null,"S/.",{"$f":"SUM(X20:X29)","v":0}]
[]
[null,"3.-","Cálculo de la C. T. S.",null,null,null,null,null,null,null,null,null,null,null,null,null,"3.-","Cálculo de la C. T. S."]
[null,null,null,"Meses    :",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,23,0))","v":""},"x (",{"$f":"I30","v":0},"÷  12 )",null,null,"=",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,27,0))","v":""},null,null,null,null,null,null,"Meses    :",{"$f":"IF(E33>=0,E33,0)","v":""},"x (",{"$f":"X30","v":0},"÷  12 )",null,null,"=",{"$f":"IF(L33>=0,L33,0)","v":""}]
[null,null,null,"Días       :",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,24,0))","v":""},"x ((",{"$f":"I30","v":0},"÷  12  ) ÷ 30 )",null,null,"=",{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,data!A$4:AC$1048576,28,0))","v":""},null,null,null,null,null,null,"Días       :",{"$f":"IF(E34>=0,E34,0)","v":""},"x ((",{"$f":"X30","v":0},"÷  12  ) ÷ 30 )",null,null,"=",{"$f":"IF(L34>=0,L34,0)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"S/.",{"$f":"SUM(L33:Q34)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"S/.",{"$f":"SUM(AA33:AF34)","v":0}]
[]
[null,null,"MONTO DEPOSITADO :",null,null,"S/.",{"$f":"L35","v":0},null,null,null,null,null,null,null,null,null,null,"MONTO DEPOSITADO :",null,null,"S/.",{"$f":"AA35","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Estando conforme con la presente liquidación, firmo el, \",DAY(fconstancia),\" de \",TEXT(fconstancia,\"mmmm\"),\" de \",YEAR(fconstancia))","v":"Estando conforme con la presente liquidación, firmo el, 15 de noviembre de 2015"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Estando conforme con la presente liquidación, firmo  el, \",TEXT(fconstancia,\"dd\"),\" de \",TEXT(fconstancia,\"mmmm\"),\" de \",TEXT(fconstancia,\"yyyy\"))","v":"Estando conforme con la presente liquidación, firmo  el, 15 de noviembre de 2015"}]
[]
[]
[]
[]
[]
[]
[null,"________________________",null,null,null,null,"____________________________",null,null,null,null,null,null,null,null,null,"________________________",null,null,null,null,"____________________________"]
[null,{"$f":"IF(cia>\"\",cia,\"\")","v":"ARCHIVO EXCEL E.I.R.L."},null,null,null,null,{"$f":"IF(AC7>\"\",AC7,\"\")","v":""},null,null,null,null,"Huella digital",null,null,null,null,{"$f":"IF(B47>=0,B47,0)","v":"ARCHIVO EXCEL E.I.R.L."},null,null,null,null,{"$f":"IF(G47>=0,G47,0)","v":""},null,null,null,null,"Huella digital"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"DNI \",TEXT(AG7,\"00######\"))","v":"DNI "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G48>=0,G48,0)","v":"DNI "}]

{"sheet":"Reporte","index":10,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["CAMPO",null,"Moneda","Banco",null,{"$f":"IF(cia>\"\",cia,\"\")","v":"ARCHIVO EXCEL E.I.R.L."}]
["DATO",null,"NUEVOS SOLES","CAJA RURAL DE AHORRO Y CRÉDITO QUILLABAMBA - CREDINKA",null,null,null,{"$f":"SUM(H5:H999999)","v":0}]
[]
["Cod","Tipo Doc","Num Doc","Paterno","Materno","Nombres","Cuenta","Total CTS"]

{"sheet":"Detalle","index":11,"n_rows":6,"n_cols":26,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["CAMPO",null,"Moneda","Banco",null,{"$f":"IF(cia>\"\",cia,\"\")","v":"ARCHIVO EXCEL E.I.R.L."}]
["DATO",null,"NUEVOS SOLES","CONTINENTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z5:Z999999)","v":950}]
[]
["Cod","Tipo Doc","Num Doc","Apellidos y Nombres","Básico","Destajo","Comisión","Horas Extras","Gratificac.","A. Familiar",{"$f":"data!J3","v":"Movilidad"},{"$f":"data!M3","v":"……"},{"$f":"data!N3","v":"……"},{"$f":"data!O3","v":"……"},"Remu. Comput.","T. Días","Faltas","D. Compu.","Periodo","Meses","Días","Factor Mes","Factor Días","Importe Meses","Importe Días","Total CTS"]
[1,1,"00471273","FLORES JUSTO, MERY",750,0,0,0,125,75,null,null,null,null,950,180,0,180,"01/11/2014 - 30/04/2015",6,0,79.17,2.64,475,0,475]
[2,1,"00400475","JARANDILLA GARATE, AVELINO",750,0,0,0,125,75,null,null,null,null,950,180,0,180,"01/11/2014 - 30/04/2015",6,0,79.17,2.64,475,0,475]