{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PlanillaAguinaldodeNavidad","_Boletas","OVTPLA-A01"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"PlanillaAguinaldodeNavidad","index":0,"n_rows":27,"n_cols":40,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,36,8,40],[26,24,26,26],[26,6,26,12],[26,17,26,21],[1,7,1,8],[2,7,2,8],[3,7,3,8]]}
["NOMBRE O RAZÓN SOCIAL",null,null,null,null,null,null,"CURTIEMBRE GALARZA SRL"]
["Nº EMPLEADOR MINISTERIO DE TRABAJO",null,null,null,null,null,null,6515165]
["Nº DE NIT",null,null,null,null,null,null,10023023025]
["Nº DE EMPLEADOR (Caja de Salud)",null,null,null,null,null,null,5545]
[]
["PLANILLA DE PAGO DE AGUINALDO DE NAVIDAD 2018"]
["(En Bolivianos)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Casillas que sirven solo para cálculo. NO BORRAR. Eso sí, completar lo que no está sombreado"]
[]
[]
["Nº","Tipo de documento de identidad","Número de documento de identidad","Extensión del documento de identidad","AFP a la que aporta","NUA/CUA","Apellido Paterno","Apellido Materno","Apellido de casada","Primer nombre","Otros nombres","País de nacionalidad","Fecha de nacimiento","Sexo","Jubilado","Clasificación laboral","Cargo","Fecha de ingreso","Modalidad de contrato","Fecha de retiro","Promedio del haber básico (A)","Promedio del bono de antigüedad\n(B)","Promedio del bono de producción\n(C)","Promedio del subsidio de frontera\n(D)","Promedio trabajo extraordinario y nocturno\n(E)","Promedio pago dominical y domingo trabajado\n(F)","Promedio otros bonos\n(G)","Promedio total ganado\n(H=A+B+C+D+E+F+G)","Meses trabajados\n(I)","Total ganado después de duodécimas\n(J=H*I/12)","Sucursal o ubicación adicional","FIRMA DEL\nEMPLEADO",null,null,null,null,"Nombre Completo","Fecha de Inicio de Cálculo ","Fecha Final de Cálculo","Meses duodécimas"]
[1,1,32154687,"LP",2,null,"Rodriguez","Flores",null,"Jaime",".","Bolivia","1979-08-15",1,0,null,"Limpieza","2014-02-18",1,null,4800,0,0,0,0,0,0,{"$f":"+U11+V11+W11+X11+Y11+Z11+AA11","v":4800},{"$f":"AN11","v":12},{"$f":"IF(AN11>2.999,AB11*AC11/12,0)","v":4800},null,null,null,null,null,null,{"$f":"CONCATENATE(G11,\" \",H11,\", \",J11)","v":"Rodriguez Flores, Jaime"},"2018-01-01","2018-12-31",{"$f":"(DAYS360(AL11,AM11,0))/30","v":12}]
[2,1,68451651,"TJA",1,null,"Perlacios","Blanca",null,"Juana",null,"Bolivia","1990-01-15",0,0,null,"Gerente propietario","2015-10-08",1,null,4600,0,0,0,0,0,0,{"$f":"+U12+V12+W12+X12+Y12+Z12+AA12","v":4600},{"$f":"AN12","v":12},{"$f":"IF(AN12>2.999,AB12*AC12/12,0)","v":4600},null,null,null,null,null,null,{"$f":"CONCATENATE(G12,\" \",H12,\", \",J12)","v":"Perlacios Blanca, Juana"},"2018-01-01","2018-12-31",{"$f":"(DAYS360(AL12,AM12,0))/30","v":12}]
[3,1,2642346,"LP",2,null,"Perez","Paredes",null,"Juancito",null,"Bolivia","29/02/1994",0,0,null,"Coordinador","2017-01-01",1,null,12600,0,0,0,0,0,0,{"$f":"+U13+V13+W13+X13+Y13+Z13+AA13","v":12600},12,12600,null,null,null,null,null,null,"Perez Paredes, Juancito","2018-01-01","2018-12-31",12]
[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,0,0,0,null,null,null,null,null,null," , ",null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null," , ",null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null," , ",null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null," , ",null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null," , ",null,null,0]
[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,0,0,0,null,null,null,null,null,null," , ",null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null," , ",null,null,0]
["TOTALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U11:U20)","v":22000},0,0,0,0,0,0,22000,36,22000]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"NOMBRE DEL EMPLEADOR O REPRESENTANTE LEGAL",null,null,null,null,null,null,null,null,null,null,"Nº DE DOCUMENTO DE IDENTIDAD",null,null,null,null,null,null,"FIRMA",null,null,null,"FECHA: "]

{"sheet":"_Boletas","index":1,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[43,2,43,4],[43,6,43,8],[51,6,52,8],[54,1,54,10],[59,3,59,4],[59,7,59,8],[36,1,36,10],[12,2,12,4],[12,6,12,8],[20,6,21,8],[23,1,23,10],[28,3,28,4],[28,7,28,8],[33,1,33,3],[33,8,33,9],[35,1,35,10],[5,1,5,10],[1,3,1,4],[32,3,32,4],[2,1,2,3],[2,8,2,9],[4,1,4,10]]}
[null,"EMPRESA:",null,{"$f":"PlanillaAguinaldodeNavidad!H1","v":"CURTIEMBRE GALARZA SRL"}]
[null,"NIT: ",null,{"$f":"PlanillaAguinaldodeNavidad!H3","v":10023023025}]
[null,"SUCRE - BOLIVIA",null,null,null,null,null,null,"DPTO. ADM Y FIN"]
[]
[null,"RECIBO DE PAGO AGUINALDO DE NAVIDAD"]
[null,"(Expresado en bolivianos)",null,null,null,null,null,null,null,null,null,null,13]
[]
[null,null,"NOMBRE",{"$f":"PROPER(M8)","v":"Perez Paredes, Juancito"},null,null,"PROM. TOT. GANADO 3 ULTIMOS",null,{"$f":"M12","v":12600},null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!ak\" & $M$6)","v":"Perez Paredes, Juancito"}]
[null,null,"C.I. ",{"$f":"M9","v":2642346},null,null,"MESES TRABAJADOS",null,{"$f":"M13","v":12},null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!c\" & $M$6)","v":2642346}]
[null,null,"CARGO",{"$f":"PROPER(M10)","v":"Coordinador"},null,null,"MES",null,"AGUINALDO",null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!q\" & $M$6)","v":"Coordinador"}]
[null,null,"F-INGRESO",{"$f":"M11","v":"2017-01-01"},null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!r\" & $M$6)","v":42736}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!ab\" & $M$6)","v":12600}]
[null,null,"INGRESOS",null,null,null,"EGRESOS",null,null,null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!ac\" & $M$6)","v":12}]
[null,null,"AGUINALDO",null,{"$f":"M14","v":12600},null,null,null,null,null,null,null,{"$f":"INDIRECT(\"PlanillaAguinaldodeNavidad!ad\" & $M$6)","v":12600}]
[]
[]
[]
[]
[null,null,"TOTAL INGRESOS",null,{"$f":"SUM(E14:E17)","v":12600},null,"TOTAL EGRESOS",null,{"$f":"SUM(I14:I17)","v":0}]
[]
[null,null,"LIQUIDO PAGABLE ( I - E )",null,{"$f":"E19-I19","v":12600}]
[]
[]
[null,{"$f":"TODAY()","v":"2018-12-06"}]
[]
[]
[]
[]
[null,null,null,"RECIBI CONFORME",null,null,null,"JEFE DPTO. ADM Y FIN"]
[]
[]
[null,"EMPRESA:",null,{"$f":"D1","v":"CURTIEMBRE GALARZA SRL"}]
[null,"NIT: ",null,{"$f":"D2","v":10023023025}]
[null,{"$f":"B3","v":"SUCRE - BOLIVIA"},null,null,null,null,null,null,{"$f":"+I3","v":"DPTO. ADM Y FIN"}]
[]
[null,{"$f":"+B5","v":"RECIBO DE PAGO AGUINALDO DE NAVIDAD"}]
[null,"(Expresado en bolivianos)"]
[]
[null,null,"NOMBRE",{"$f":"D8","v":"Perez Paredes, Juancito"},null,null,"PROM. TOT. GANADO 3 ULTIMOS",null,{"$f":"M12","v":12600}]
[null,null,"C.I. ",{"$f":"M9","v":2642346},null,null,"MESES TRABAJADOS",null,{"$f":"+I9","v":12}]
[null,null,"CARGO",{"$f":"D10","v":"Coordinador"},null,null,"MES",null,{"$f":"I10","v":"AGUINALDO"}]
[null,null,"F-INGRESO",{"$f":"M11","v":"2017-01-01"}]
[]
[null,null,"INGRESOS",null,null,null,"EGRESOS"]
[null,null,"SALARIO GANADO",null,{"$f":"M14","v":12600}]
[]
[]
[]
[]
[null,null,"TOTAL INGRESOS",null,{"$f":"SUM(E45:E48)","v":12600},null,"TOTAL EGRESOS",null,{"$f":"SUM(I45:I48)","v":0}]
[]
[null,null,"LIQUIDO PAGABLE ( I - E )",null,{"$f":"E50-I50","v":12600}]
[]
[]
[null,{"$f":"B24","v":"2018-12-06"}]
[]
[]
[]
[]
[null,null,null,"RECIBI CONFORME",null,null,null,{"$f":"+H29","v":"JEFE DPTO. ADM Y FIN"}]

{"sheet":"OVTPLA-A01","index":2,"n_rows":2,"n_cols":31,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
["Nº","Tipo de documento de identidad","Número de documento de identidad","Extensión del documento de identidad","AFP a la que aporta","NUA/CUA","Apellido Paterno","Apellido Materno","Apellido de casada","Primer nombre","Otros nombres","País de nacionalidad","Fecha de nacimiento","Sexo","Jubilado","Clasificación laboral","Cargo","Fecha de ingreso","Modalidad de contrato","Fecha de retiro","Promedio haber básico","Promedio bono de antigüedad","Promedio bono de producción","Promedio subsidio de frontera","Promedio trabajo extraordinario y nocturno","Promedio pago dominical y domingo trabajado","Promedio otros bonos","Promedio total ganado","Meses trabajados","Total ganado después de duodécimas","Sucursal o ubicación adicional"]