{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Planilla","Nómina Gastos"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"Planilla","index":0,"n_rows":153,"n_cols":37,"rows_kept":153,"cut":false,"hidden":false,"merged":[[89,13,89,16],[88,13,88,16],[64,1,64,4],[35,1,35,17],[90,1,90,6],[72,0,80,0],[78,16,78,17],[82,1,86,6],[65,0,71,0],[68,14,68,17],[69,14,69,17],[79,13,79,15],[79,1,79,6],[83,13,83,16],[90,13,90,16],[89,1,89,6],[88,1,88,6],[82,0,92,0],[92,1,92,6],[78,1,78,6],[82,12,86,12],[81,0,81,25],[85,20,92,25],[87,13,87,16],[86,13,86,16],[82,20,84,25],[52,0,54,0],[52,24,54,25],[55,24,55,25],[38,17,38,20],[39,17,39,20],[32,1,32,6],[70,14,70,17],[71,14,71,17],[71,1,71,6],[62,1,62,4],[40,1,40,7],[52,1,54,4],[52,17,54,17],[63,1,63,4],[59,1,59,4],[40,17,40,20],[33,1,33,6],[56,1,56,4],[59,24,59,25],[57,1,57,4],[58,24,58,25],[68,18,71,25],[63,24,63,25],[42,0,43,25],[15,0,24,0],[20,17,20,19],[6,22,6,24],[30,1,30,6],[8,4,8,5],[15,17,16,19],[18,13,18,16],[6,4,6,19],[8,6,8,19],[17,13,17,16],[7,22,8,24],[18,20,18,25],[6,20,6,21],[15,13,16,16],[19,13,19,16],[10,1,10,3],[15,20,16,25],[18,17,18,19],[19,17,19,19],[10,4,10,6],[10,13,10,16],[22,20,22,25],[21,20,21,25],[22,17,22,19],[24,13,24,25],[29,13,29,16],[28,13,28,16],[25,12,25,17],[23,17,23,19],[30,23,30,25],[21,13,21,16],[22,13,22,16],[25,19,25,25],[0,20,0,23],[19,20,19,25],[20,20,20,25],[0,24,0,25],[10,17,12,17],[10,19,12,25],[0,6,0,19],[1,6,1,19],[2,6,2,19],[2,24,2,25],[2,20,2,23],[17,20,17,25],[17,17,17,19],[1,24,1,25],[1,20,1,23],[14,0,14,25],[5,0,13,0],[24,5,24,6],[27,13,27,16],[33,23,33,25],[30,19,34,22],[78,13,78,15],[30,13,30,16],[31,1,31,6],[31,13,31,16],[26,13,26,16],[72,1,73,6],[46,1,47,6],[52,5,52,6],[78,24,78,25],[73,19,73,23],[75,19,75,23],[74,19,74,23],[62,24,62,25],[64,24,64,25],[77,24,77,25],[73,24,73,25],[77,19,77,23],[65,17,65,25],[31,23,31,25],[35,23,35,25],[76,19,76,23],[32,13,32,16],[4,0,4,25],[25,1,25,6],[15,1,15,4],[12,13,12,16],[26,17,26,18],[67,14,67,25],[76,24,76,25],[61,24,61,25],[52,19,54,19],[52,13,53,16],[61,1,61,4],[55,1,55,4],[57,24,57,25],[56,24,56,25],[58,1,58,4],[60,24,60,25],[75,6,75,10],[23,20,23,25],[20,13,20,16],[21,17,21,19],[23,13,23,16],[25,0,35,0],[92,13,92,16],[91,13,91,16],[39,22,39,24],[40,22,40,24],[38,22,38,24],[51,19,51,25],[49,17,51,17],[91,1,91,6],[82,13,82,19],[38,1,38,7],[87,1,87,6],[60,1,60,4],[85,13,85,16],[84,13,84,16],[74,24,74,25],[75,24,75,25],[53,5,54,5],[52,12,54,12],[53,6,54,6],[45,0,45,25],[49,0,51,0],[49,19,50,25],[52,20,53,23],[47,20,47,24],[49,1,51,16],[34,13,34,16],[34,23,34,25],[34,1,34,6],[36,0,41,0],[39,13,39,15],[39,1,39,7],[26,1,29,6],[40,13,40,15],[32,23,32,25],[26,19,29,25],[48,20,48,24]]}
[null,null,null,null,null,null,"RESOLUCION DE COMETIDOS Y ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"at"]
[null,null,null,null,null,null,"PLANILLA DE VIATICOS Y GASTOS",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA",null,null,null,"N° RESOLUCION"]
["V. 1,0",null,null,null,null,null,"       RIGE A CONTAR DEL 01/12/2025  LEY 21.806                     \nVistos:  Ley N° 18.755 del Servicio Agrícola y Ganadero y,\n facultades delegadas por Director Nacional según corresponda."]
[]
[" SOLICITUD DE ANTICIPO DE VIATICOS NACIONAL"]
[1]
[null,"NOMBRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUT"]
[]
[null,"UNIDAD",null,null,{"$f":"IF(G9=\"\",\"\",+VLOOKUP($G$9,$AD$95:$AE$114,2,0))","v":5100},null,"DIRECCION REGIONAL"]
[]
[null,"C. JURID",null,null,"CONTRATA",null,null,null,null,null,null,null,"G°E.U.","17°",null,null,null,"REGION DE PERTENENCIA",null,"REGIÓN DE VALPARAISO"]
[]
[null,"VALOR VIATICO BASE 100% ASIGNADO SEGÚN TABLA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(N11,$AG$95:$AK$125,2,0),\"\")","v":65829}]
[]
["COMPROMISO PRESUPUESTARIO"]
[2,"CANT. DIAS",null,null,null,"DESDE","HASTA",null,null,null,null,null,"DESGLOSE DE ","SELECCIONAR \nREGION",null,null,null,"LOCALIDADES REGIONALES O\nCOMUNAS DE LA R.METROPOLITANA",null,null,"SELECCIONAR MOTIVO \nDEL COMETIDO"]
[null,1,0.6,0.5,0.4,"dd-mm-aa","dd-mm-aa",null,"100%","60%","50%","40%","VIATICOS"]
[null,null,null,null,null,null,null,null,{"$f":"IF(B18=\"\",\"\",B18*VLOOKUP($N$11,$AG$95:$AK$125,2,0))","v":""},{"$f":"IF(C18=\"\",\"\",C18*VLOOKUP($N$11,$AG$95:$AK$125,3,0))","v":""},{"$f":"IF(D18=\"\",\"\",D18*VLOOKUP($N$11,$AG$95:$AK$125,4,0))","v":""},{"$f":"IF(E18=\"\",\"\",E18*VLOOKUP($N$11,$AG$95:$AK$125,5,0))","v":""},{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,\"Revisar Fechas\",SUM(I18:L18)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",B19*VLOOKUP($N$11,$AG$95:$AK$125,2,0))","v":""},{"$f":"IF(C19=\"\",\"\",C19*VLOOKUP($N$11,$AG$95:$AK$125,3,0))","v":""},{"$f":"IF(D19=\"\",\"\",D19*VLOOKUP($N$11,$AG$95:$AK$125,4,0))","v":""},{"$f":"IF(E19=\"\",\"\",E19*VLOOKUP($N$11,$AG$95:$AK$125,5,0))","v":""},{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,\"Revisar Fechas\",SUM(I19:L19)))","v":""}]
[null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,"","","","",""]
[null,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(B18:B24)","v":0},{"$f":"SUM(C18:C24)","v":0},{"$f":"SUM(D18:D24)","v":0},{"$f":"SUM(E18:E24)","v":0},null,null,null,{"$f":"SUM(I18:I24)","v":0},{"$f":"SUM(J18:J24)","v":0},{"$f":"SUM(K18:K24)","v":0},{"$f":"SUM(L18:L24)","v":0},{"$f":"SUM(M18:M24)","v":0}]
[3,null,null,null,null,null,null,"CLASIFICACION PRESUPUESTARIA",null,null,null,null,"CLASIFICACION PRESUPUESTARIA",null,null,null,null,null,null,"DESCRIPCION DEL COMETIDO"]
[null,"REGISTRO CUENTA PRESUPUESTARIA",null,null,null,null,null,null,null,null,null,null,"PROGRAMA","PROGRAMA",null,null,null,"PROGRAMA"]
[]
[null,null,null,null,null,null,null,"UNID/PROD/SUBPROD/P. ESPECIFICO",null,null,null,null,"PRODUCTO  / SUBPROD \nPRODUCTO ESPECIFICO","PRODUCTO  / SUBPROD \nPRODUCTO ESPECIFICO",null,null,null,"PRODUCTO  / SUBPROD \nPRODUCTO ESPECIFICO"]
[]
[null,"2102004006 Contrata Nacional",null,null,null,null,null,{"$f":"+M25","v":0},null,null,null,null,{"$f":"+M25-N31-R31","v":0},null,null,null,null,null,null,{"$f":"IF(X36<=0,\"Sin Anticipo\",\"Anticipo Solicitado\")","v":"Sin Anticipo"},null,null,null,{"$f":"IF(SUM(M31,N31,R31)=$M$25,SUM(M31,N31,R31),\"Error\")","v":0}]
[null,"2208007001 Pasajes Nacionales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M32,N32,R32,)","v":0}]
[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(M33,N33,R33,)","v":0}]
[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(M34,N34,R34,)","v":0}]
[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(M35,N35,R35,)","v":0}]
[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(X31:Z35)","v":0}]
[4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E7","v":0}]
[null,"NOMBRE,  FIRMA Y TIMBRE JEFA/E ",null,null,null,null,null,null,null,null,null,null,null,"V°B° ANALISTA ",null,null,null,"NOMBRE Y FIRMA FUNCIONARIA/O",null,null,null,null,"V°B° ENC. GESTION, "]
[null," QUE AUTORIZA  EL COMETIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUE REALIZARA COMETIDO",null,null,null,null,"TIMBRE UNIDAD"]
[]
["RENDICION DEL COMETIDO NACIONAL"]
[]
[]
[]
[null,"MODIFICA RESOLUCION Y RINDE GASTOS",null,null,null,null,null,null,null,null,null,null,"N° Días de Días",null,null,null,{"$f":"+$N$66-$B$25","v":0},"N° de Días 1/2 Días",null,{"$f":"+Q66-E25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"N° de Días al 50% ",null,null,null,{"$f":"+P66-D25","v":0}]
[]
[5,"ESPECIFICACION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MESES DE RENDICION",null,"DICIEMBRE"]
[]
[]
["UNIDAD","SUBPROD. Y PRODUCTO ESPECIFICO",null,null,null,"RANGO FECHAS",null,null,null,null,null,null,"CUENTA PRESUPTARIA","CANTIDAD DIAS SOLICITADOS",null,null,null,"REGION",null,"LOCALIDAD VISITADA","VALOR DIAS",null,null,null,"TOTAL $"]
[null,null,null,null,null,"DESDE        dd-mm-aa","HASTA        dd-mm-aa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.6,0.5,0.4,null,null,null,1,0.6,{"$f":"P55","v":0.5},0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(F56=\"\",G56=\"\"),\"\",IF(G56<F56,\"Revisar Fechas\",VLOOKUP($B$31,$AA$136:$AB$142,2,0)))","v":""},null,null,null,null,null,null,null,{"$f":"IF(N56=\"\",\"\",N56*VLOOKUP($N$11,$AG$95:$AK$125,2,0))","v":""},{"$f":"IF(O56=\"\",\"\",O56*VLOOKUP($N$11,$AG$95:$AK$125,3,0))","v":""},{"$f":"IF(P56=\"\",\"\",P56*VLOOKUP($N$11,$AG$95:$AK$125,4,0))","v":""},{"$f":"IF(Q56=\"\",\"\",Q56*VLOOKUP($N$11,$AG$95:$AK$125,5,0))","v":""},{"$f":"SUM(U56:X56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"IF(N57=\"\",\"\",N57*VLOOKUP($N$11,$AG$95:$AK$125,2,0))","v":""},{"$f":"IF(O57=\"\",\"\",O57*VLOOKUP($N$11,$AG$95:$AK$125,3,0))","v":""},{"$f":"IF(P57=\"\",\"\",P57*VLOOKUP($N$11,$AG$95:$AK$125,4,0))","v":""},{"$f":"IF(Q57=\"\",\"\",Q57*VLOOKUP($N$11,$AG$95:$AK$125,5,0))","v":""},{"$f":"SUM(U57:X57)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",{"$f":"IF(O58=\"\",\"\",O58*VLOOKUP($N$11,$AG$95:$AK$125,3,0))","v":""},"","",{"$f":"SUM(U58:X58)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","","",0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N56:N65)","v":0},{"$f":"SUM(O56:O65)","v":0},{"$f":"SUM(P56:P65)","v":0},{"$f":"SUM(Q56:Q65)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI NO PRESENTA GASTOS ASOCIADOS, MARCAR CON UNA \"X\" EL MOTIVO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traslado Vehículo Institucional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traslado Vehículo otros Servicios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastos rendidos por otro funcionario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"X","Otros (detallar brevemente)"]
[7,"NOMBRE, TIMBRE Y FIRMA JEFA/E\nQUE AUTORIZA LA RENDICION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(+) TOTAL ESPECIFICACION",null,null,null,null,{"$f":"SUM(Y56:Z65)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(+) GASTOS SEGÚN NOMINA",null,null,null,null,{"$f":"+'Nómina Gastos'!I42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(=) TOTAL LIQUIDACION",null,null,null,null,{"$f":"SUM(Y74:Z75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(- ) ANTICIPO VIATICO",null,null,null,null,{"$f":"+X36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y78>0,\"SALDO A FAVOR\",IF(Y78<0,\"SALDO EN CONTRA\",IF(Y78=0,\"SIN SALDO\",0)))","v":"SIN SALDO"},null,null,null,null,{"$f":"+Y76-Y77","v":0}]
[null,{"$f":"+E7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E7","v":0}]
[null,"FIRMA FUNCIONARIA/O\nQUE REALIZA COMETIDO",null,null,null,null,null,null,null,null,null,null,null,"V°B° ENC. GESTION",null,null,null,"V°B° ANALISTA"]
[]
["AJUSTE DEL COMPROMISO PRESUPUESTARIO"]
[8,"REGISTRO CUENTA PRESUPUESTARIA",null,null,null,null,null,"CLASIFICACION PRESUPUESTARIA",null,null,null,null,{"$f":"+IF(M93=Y78,\"MONTO A COMPENSAR\",\"FAVOR COMPLETAR DATOS EN LA NOMINA DE GASTOS (VALOR Y SUBPRODUCTO)\")","v":"MONTO A COMPENSAR"},"CLASIFICACION PRESUPUESTARIA",null,null,null,null,null,null,"DESCRIPCION DEL COMETIDO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PROGRAMA",null,null,null,"PROGRAMA",null,"PROGRAMA"]
[]
[null,null,null,null,null,null,null,"UNID/PROD/SUBPROD/P. ESP",null,null,null,null,null,"PRODUCTO  / SUBPROD \nPRODUCTO ESPECIFICO",null,null,null,"PRODUCTO  / SUBPROD \nPRODUCTO ESPECIFICO",null,"PRODUCTO  / SUBPROD \nPRODUCTO ESPECIFICO",{"$f":"T27","v":0}]
[]
[null,{"$f":"$B$31","v":"2102004006 Contrata Nacional"},null,null,null,null,null,null,null,null,null,null,{"$f":"+N88+R88+T88","v":0},{"$f":"-M31+SUMIF(B56:E65,N87,Y56:Z65)","v":0},null,null,null,{"$f":"-N31+SUMIF(B56:E65,R87,Y56:Z65)","v":0},{"$f":"-O31+SUMIF(C56:F65,S87,Z56:AA65)","v":0},{"$f":"-R31+SUMIF(B56:E65,T87,AA56:AB65)","v":0}]
[null,{"$f":"$B$32","v":"2208007001 Pasajes Nacionales"},null,null,null,null,null,null,null,null,null,null,{"$f":"+N89+R89+T89","v":0},{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B89,'Nómina Gastos'!$J$15:$J$33,N$87,'Nómina Gastos'!$D$15:$D$33,N85)-M32","v":0},null,null,null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B89,'Nómina Gastos'!$J$15:$J$33,R$87,'Nómina Gastos'!$D$15:$D$33,R85)-N32","v":0},null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B89,'Nómina Gastos'!$J$15:$J$33,T$87,'Nómina Gastos'!$D$15:$D$33,T85)-R32","v":0}]
[null,"2208007003 Peajes y Flete",null,null,null,null,null,null,null,null,null,null,{"$f":"+N90+R90+T90","v":0},{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B90,'Nómina Gastos'!$J$15:$J$33,N$87,'Nómina Gastos'!$D$15:$D$33,N85)-M33","v":0},null,null,null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B90,'Nómina Gastos'!$J$15:$J$33,R$87,'Nómina Gastos'!$D$15:$D$33,R85)-N33","v":0},{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B90,'Nómina Gastos'!$J$15:$J$33,S$87,'Nómina Gastos'!$D$15:$D$33,S85)-O33","v":0},{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B90,'Nómina Gastos'!$J$15:$J$33,T$87,'Nómina Gastos'!$D$15:$D$33,T85)-R33","v":0}]
[null,"2201001000 Alimentos y Bebidas",null,null,null,null,null,null,null,null,null,null,{"$f":"+N91+R91+T91","v":0},{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B91,'Nómina Gastos'!$J$15:$J$33,N$87,'Nómina Gastos'!$D$15:$D$33,N85)-M34","v":0},null,null,null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B91,'Nómina Gastos'!$J$15:$J$33,R$87,'Nómina Gastos'!$D$15:$D$33,R85)-N34","v":0},null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B91,'Nómina Gastos'!$J$15:$J$33,T$87,'Nómina Gastos'!$D$15:$D$33,T85)-R34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N92+R92+T92","v":0},{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B92,'Nómina Gastos'!$J$15:$J$33,N$87,'Nómina Gastos'!$D$15:$D$33,N85)-M35","v":0},null,null,null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B92,'Nómina Gastos'!$J$15:$J$33,R$87,'Nómina Gastos'!$D$15:$D$33,R85)-N35","v":0},null,{"$f":"+SUMIFS('Nómina Gastos'!$I$15:$I$33,'Nómina Gastos'!$E$15:$E$33,$B92,'Nómina Gastos'!$J$15:$J$33,T$87,'Nómina Gastos'!$D$15:$D$33,T85)-R35","v":0}]
[null,"Total Ajuste del Compromiso",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M88:M92)","v":0},{"$f":"SUM(N88:Q92)","v":0},null,null,null,{"$f":"SUM(R88:R92)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AÑO 2025"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIONES",null,null,"UNIDADES / DEPARTAMENTOS / DIVISIONES",null,null,null,1,0.6,0.5,0.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,"REGIÓN DE TARAPACÁ",null,null,"LABORATORIO REGIONAL",5001,null,"01°",88182,52909,{"$f":"AH95/2","v":44091},35273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE ANTOFAGASTA",null,null,"EL SAUCE",5002,null,"02°",88182,52909,{"$f":"AH96/2","v":44091},35273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE ATACAMA",null,null,"DIRECCION REGIONAL",5100,null,"03°",88182,52909,44091,35273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE COQUIMBO",null,null,"VALPARAISO",5101,null,"04°",88182,52909,44091,35273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE VALPARAISO",null,null,"RAPA NUI",5201,null,"05°",81114,48668,40557,32446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DEL LIBERTADOR GENERAL BERNARDO O'HIGGINS",null,null,"LOS ANDES",5301,null,"06°",81114,48668,40557,32446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DEL MAULE",null,null,"PETORCA",5401,null,"07°",81114,48668,40557,32446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DEL BÍO - BÍO",null,null,"QUILLOTA",5501,null,"08°",81114,48668,40557,32446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE LA ARAUCANÍA",null,null,"SAN ANTONIO",5601,null,"09°",81114,48668,40557,32446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE LOS LAGOS",null,null,"SAN FELIPE",5701,null,"10°",81114,48668,40557,32446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN AYSÉN DEL GENERAL CARLOS IBÁÑEZ DEL CAMPO",null,null,null,null,null,"11°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE MAGALLANES Y LA ANTÁRTICA CHILENA",null,null,null,null,null,"12°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN METROPOLITANA",null,null,null,null,null,"13°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGION DE LOS RÍOS",null,null,null,null,null,"14°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGION DE ÑUBLE",null,null,null,null,null,"15°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIÓN DE ARICA Y PARINACOTA",null,null,null,null,null,"16°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAG CENTRAL",null,null,null,null,null,"17°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABORATORIO LO AGUIRRE",null,null,null,null,null,"18°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALIDAD  JURIDICA",null,null,null,null,null,"20°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLANTA",null,null,null,null,null,"21°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTRATA",null,null,null,null,null,"22°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HONORARIO",null,null,"REGIONES (ACOTADA)","CTA PPTARIA",null,"23°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CÓDIGO DEL TRABAJO",null,null,"ANTOFAGASTA",2101004006,null,"24°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARICA Y PARINACOTA",2102004006,null,"25°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTROS GASTOS / NO VIATICOS",null,null,"ATACAMA",2101004007,null,"26°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2201001000 Alimentos y Bebidas",null,null,"AYSEN",2103001002,null,"27°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2203001000 Bencina",null,null,"COQUIMBO",2103001102,null,"28°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2208007001 Pasajes Nacionales","2208007001 Pasajes Nacionales",null,"EL BIO BIO",2103001202,null,"29°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2208007003 Peajes y Flete","2208007003 Peajes y Flete",null,"EL MAULE",2103004005,null,"30°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2210999000 Seguro Viaje","2210999000 Seguro Viaje",null,"LA ARAUCANIA",2401404001,null,"31°",65829,39497,32914.5,26332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2204011000 Repuestos y Accesorios para Ma","2204011000 Repuestos y Accesorios para Ma",null,"LOS LAGOS",2401601]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2208999001 Otros Gastos","2208999001 Otros Gastos",null,"LOS RIOS",2401601001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2211002000 Capacitación","2211002000 Capacitación",null,"MAGALLANES",2401407001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2401601000 Emergencias Sanitarias","2401601000 Emergencias Sanitarias",null,"ÑUBLE",2403366001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2403240000 Rezagados","2403240000 Rezagados",null,"OHIGGINS",2403368001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2401404001 Suelos Degradados","2401404001 Suelos Degradados",null,"R. METROPOLITANA",2403375001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2409002000 Innovacion Fortalecimiento","2409002000 Innovacion Fortalecimiento",null,"TARAPACA",2403376001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALPARAISO",2403377001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIATICOS (Seleccionar)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2101004006 Planta Nacional",2101004006,"PLANTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2102004006 Contrata Nacional",2102004006,"CONTRATA","MotivoCometidoFuncionatioType"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2103001202 Honorario Temporal",2103001202,"HONORARIO","1.- Visita Inspectiva o de Fiscalización"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2103004005 Código del Trabajo.",2103004005,"CÓDIGO DEL TRABAJO","2.- Practicar Notificación(es)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2401404000 Suelos Degradados",2401404000,null,"3.- Reunión en otra dependencia del servicio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2403240000 Rezagados",2403240000,null,"4.- Asistencia a Curso y/o actividad de capacitación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2409002000 Innovacion Fortalecimiento",2409002000,null,"5.- Reunión fuera del servicio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2401601000 Emergencias Sanitarias",2401601000,null,"6.- Concurrir a citación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.- Otras (ej supervisión, traslados, ceremonias, etc)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROGRAMAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900]

{"sheet":"Nómina Gastos","index":1,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[44,11,44,12],[1,5,3,8],[5,0,5,1],[5,5,5,8],[7,0,7,1],[7,5,7,8],[9,0,9,1],[9,5,9,6],[12,0,13,0],[12,1,13,1],[12,5,13,7],[12,8,13,8],[12,9,13,9],[14,5,14,7],[15,5,15,7],[12,2,13,2],[12,3,13,3],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[33,1,33,8],[34,1,38,8],[40,9,42,9],[44,5,44,7],[63,0,64,2],[63,7,64,9],[62,0,62,2],[62,7,62,9]]}
[]
[null,null,null,null,null,"NOMINA DE GASTOS REEMBOLSABLES"]
[]
[]
[]
["NOMBRE FUNCIONARIO              :",null,null,null,null,{"$f":"+IF(Planilla!E7=\"\",\"\",Planilla!E7)","v":""}]
[]
["UNIDAD FUNCIONARIO          :",null,null,null,null,{"$f":"+IF(Planilla!G9=\"\",\"\",Planilla!G9)","v":"DIRECCION REGIONAL"}]
[]
["N° RESOLUCION ",null,null,null,null,{"$f":"+IF(Planilla!$Y$3=\"\",\"\",CONCATENATE(\"Planilla N°\",Planilla!$Y$3))","v":""},null,{"$f":"+IF(F10=\"\",\"\",\"de fecha \")","v":""},{"$f":"+IF(Planilla!$U$3=\"\",\"\",Planilla!$U$3)","v":""}]
[]
[]
["N° DCTO","FECHA","TIPO GASTO","PROG PRES.",null,"DESCRIPCION",null,null,"VALOR","PROD. ESPEC / SUBPROD"]
[]
["123456","2026-01-02","Alimentos y Bebidas",100,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,$K$46:$L$55,2,0))","v":"2201001000 Alimentos y Bebidas"}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[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(C24=\"\",\"\",VLOOKUP(C24,$K$46:$L$55,2,0))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,"OBSERVACIONES DEL COMETIDO"]
[]
[]
[]
[]
[]
[]
[]
["FECHA",{"$f":"Planilla!U3","v":"00:00:00"},null,null,null,null,null,"TOTAL GASTOS",{"$f":"SUM(I15:I33)","v":0}]
[]
[]
[null,null,null,null,null,"RESUMEN CUENTAS"]
[null,null,null,null,null,"Alimentos y Bebidas",null,{"$f":"+SUMIF($C$15:$C$33,F46,$I$15:$I$33)","v":0},null,null,"Alimentos y Bebidas","2201001000 Alimentos y Bebidas"]
[null,null,null,null,null,"Bencina",null,0,null,null,"Bencina","2203001000 Bencina"]
[null,null,null,null,null,"Pasajes Nacionales",null,0,null,null,"Pasajes Nacionales","2208007001 Pasajes Nacionales"]
[null,null,null,null,null,"Peajes y Flete",null,0,null,null,"Peajes y Flete","2208007003 Peajes y Flete"]
[null,null,null,null,null,"Serv. Alojamiento",null,0,null,null,"Serv. Alojamiento","2208007004 Serv. Alojamiento"]
[null,null,null,null,null,"Repuestos y Accesorios para Ma",null,0,null,null,"Repuestos y Accesorios para Ma","2204011000 Repuestos y Accesorios para Ma"]
[null,null,null,null,null,"Otros Gastos",null,0,null,null,"Otros Gastos","2208999001 Otros Gastos"]
[null,null,null,null,null,"Capacitación",null,0,null,null,"Capacitación","2211002000 Capacitación"]
[null,null,null,null,null,"Emergencias Sanitarias",null,0,null,null,"Rezagados","2403240000 Rezagados"]
[null,null,null,null,null,"Suelos Degradados",null,0,null,null,"Emergencias Sanitarias","2401601000 Emergencias Sanitarias"]
[null,null,null,null,null,"Innovacion Fortalecimiento",null,0,null,null,"Suelos Degradados","2401404001 Suelos Degradados"]
[null,null,null,null,null,"Seguro Viaje",null,0,null,null,"Innovacion Fortalecimiento",2409002000,"Innovacion Fortalecimiento"]
[null,null,null,null,null,null,null,{"$f":"SUM(H46:H57)","v":0},null,null,"Seguro Viaje",2210999000,"Seguro Viaje"]
[]
[]
[]
[]
[{"$f":"Planilla!B72","v":0},null,null,null,null,null,null,{"$f":"Planilla!E7","v":0}]
["NOMBRE Y FIRMA JEFA/E\nQUE AUTORIZA LA RENDICION",null,null,null,null,"50-04-003",null,"FIRMA FUNCIONARIA/O\nQUE REALIZA COMETIDO"]
[null,null,null,null,null,"---"]
[null,null,null,null,null,"50-04-001"]
[null,null,null,null,null,"50-04-004"]