{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1A DE SEPTIEMBRE 2016","Tablas 2015","Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":28,"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":"1A DE SEPTIEMBRE 2016","index":0,"n_rows":309,"n_cols":37,"rows_kept":309,"cut":false,"hidden":false,"merged":[[307,3,307,4],[307,15,307,23],[307,33,307,35],[308,3,308,4],[308,15,308,23],[308,33,308,35],[293,3,293,4],[293,15,293,23],[293,33,293,35],[294,3,294,4],[294,15,294,23],[294,33,294,35],[269,3,269,4],[269,15,269,23],[269,33,269,35],[211,3,211,4],[212,3,212,4],[212,15,212,23],[211,15,211,23],[268,3,268,4],[268,15,268,23],[268,33,268,35],[3,1,3,35],[4,1,4,35],[211,33,211,35],[212,33,212,35],[2,0,2,35]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,T9:T264)","v":0},39169.324696666619,1651046.0400000003,66041.73000000001,115571.97000000018,0,181613.70000000004,1651046.0400000003,1832659.7399999988,null,{"$f":"SUBTOTAL(9,AD9:AD264)","v":18000},{"$f":"SUBTOTAL(9,AE9:AE264)","v":0},{"$f":"SUBTOTAL(9,AF9:AF243)","v":{"$error":"#N/A"}},{"$f":"SUBTOTAL(9,AG9:AG264)","v":144412.37999999983},{"$f":"SUBTOTAL(9,AH9:AH264)","v":5366.579999999999},{"$f":"SUBTOTAL(9,AI9:AI264)","v":1675613.9100000011},{"$f":"SUBTOTAL(9,AJ9:AJ243)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC(U2*P2,2)","v":0},{"$f":"TRUNC(U2*P2*0.04,2)","v":0},{"$f":"TRUNC(U2*0.07*P2,2)","v":0},{"$f":"S2","v":0},{"$f":"TRUNC(X2+W2+(IF(Y2>519,519,Y2))+IF(R2=0,0,R2*U2),2)","v":0},{"$f":"TRUNC((IF(R2=0,P2*U2,(P2-R2)*U2))+(IF(Y2<519,0,Y2-519)),2)+T2","v":0},{"$f":"Z2+AA2","v":0},{"$f":"W2","v":0},null,null,{"$f":"IF(U2>0.01,(AA2-VLOOKUP(AA2,quincenal,1))*VLOOKUP(AA2,quincenal,3)+VLOOKUP(AA2,quincenal,2)-VLOOKUP(AA2,subquincenal,2),0)","v":0},{"$f":"TRUNC(IF(AF2>0.01,AF2,0),2)","v":0},{"$f":"TRUNC(IF(AF2<0.01,-AF2,0),2)","v":0},{"$f":"AB2-AD2-AE2-AG2+AH2-W2","v":0}]
["H. AYUNTAMIENTO DE ETZATLAN, JALISCO"]
[null,"ADMINISTRACION 2015-2018"]
[null,"NOMINA CORRESPONDIENTE A LA 2DA QUINCENA DE SEPTIEMBRE DE 2016"]
[null,null,null,"Etzatlán, Jalisco a 30 de Septiembre de 2016."]
[null,"CAPITULO","PARTIDA","NOMBRE","RFC","CURP","FECHA DE INGRESO","CARGO",null,null,null,null,null,null,null,"DIAS LABORADOS","PAGO CON","DIAS CON INCAPACIDAD","TIEMPO EXTRA","OTROS INGRESOS","SUELDO POR DIA PROPUESTO","SUELDO BASE ","FONDO DE AHORRO","APOYO EDUCACIONAL","TIEMPO EXTRA","SUB TOTAL EXENTO","SUB TOTAL GRAVADO","SUB TOTAL A PAGAR","FONDO DE AHORRO ","PRESTAMOS","OTRAS DEDUCCIONES","CALCULO","I.S.R.","SUBSIDIO AL EMPLEO","TOTAL A PAGAR","FIRMA DE RECIBIDO"]
[null,null,null,"SALA DE REGIDORES"]
[1,1,1,"GOMEZ ALVARADO MA MAGDALENA","FEGC520708","FEGC520708HJCRMR08","2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"16688/30","v":556.26666666666665},{"$f":"TRUNC(U9*P9,2)","v":8344},{"$f":"TRUNC(U9*P9*0.04,2)","v":333.76},{"$f":"TRUNC(U9*0.07*P9,2)","v":584.08000000000004},{"$f":"S9","v":0},{"$f":"TRUNC(X9+W9+(IF(Y9>519,519,Y9))+IF(R9=0,0,R9*U9),2)","v":917.84},{"$f":"TRUNC((IF(R9=0,P9*U9,(P9-R9)*U9))+(IF(Y9<519,0,Y9-519)),2)+T9","v":8344},{"$f":"Z9+AA9","v":9261.84},null,null,0,{"$f":"IF(U9>0.01,(AA9-VLOOKUP(AA9,quincenal,1))*VLOOKUP(AA9,quincenal,3)+VLOOKUP(AA9,quincenal,2)-VLOOKUP(AA9,subquincenal,2),0)","v":1235.0892240000003},{"$f":"TRUNC(IF(AF9>0.01,AF9,0),2)","v":1235.08},{"$f":"TRUNC(IF(AF9<0.01,-AF9,0),2)","v":0},{"$f":"AB9-AD9-AE9-AG9+AH9","v":8026.76},null,1]
[2,null,null,"COVARRUBIAS VALENCIA JOSE",null,null,null,"REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,{"$f":"TRUNC(U10*P10,2)","v":8344},{"$f":"TRUNC(U10*P10*0.04,2)","v":333.76},{"$f":"TRUNC(U10*0.07*P10,2)","v":584.08000000000004},{"$f":"S10","v":0},{"$f":"TRUNC(X10+W10+(IF(Y10>519,519,Y10))+IF(R10=0,0,R10*U10),2)","v":917.84},{"$f":"TRUNC((IF(R10=0,P10*U10,(P10-R10)*U10))+(IF(Y10<519,0,Y10-519)),2)+T10","v":8344},{"$f":"Z10+AA10","v":9261.84},null,0,0,{"$f":"IF(U10>0.01,(AA10-VLOOKUP(AA10,quincenal,1))*VLOOKUP(AA10,quincenal,3)+VLOOKUP(AA10,quincenal,2)-VLOOKUP(AA10,subquincenal,2),0)","v":1235.0892240000003},{"$f":"TRUNC(IF(AF10>0.01,AF10,0),2)","v":1235.08},{"$f":"TRUNC(IF(AF10<0.01,-AF10,0),2)","v":0},{"$f":"AB10-AD10-AE10-AG10+AH10","v":8026.76},null,2]
[3,1,1,"BARAJAS DE LA TORRE ABIGAIL",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,{"$f":"TRUNC(U11*P11,2)","v":8344},{"$f":"TRUNC(U11*P11*0.04,2)","v":333.76},{"$f":"TRUNC(U11*0.07*P11,2)","v":584.08000000000004},{"$f":"S11","v":0},{"$f":"TRUNC(X11+W11+(IF(Y11>519,519,Y11))+IF(R11=0,0,R11*U11),2)","v":917.84},{"$f":"TRUNC((IF(R11=0,P11*U11,(P11-R11)*U11))+(IF(Y11<519,0,Y11-519)),2)+T11","v":8344},{"$f":"Z11+AA11","v":9261.84},null,0,0,{"$f":"IF(U11>0.01,(AA11-VLOOKUP(AA11,quincenal,1))*VLOOKUP(AA11,quincenal,3)+VLOOKUP(AA11,quincenal,2)-VLOOKUP(AA11,subquincenal,2),0)","v":1235.0892240000003},{"$f":"TRUNC(IF(AF11>0.01,AF11,0),2)","v":1235.08},{"$f":"TRUNC(IF(AF11<0.01,-AF11,0),2)","v":0},{"$f":"AB11-AD11-AE11-AG11+AH11","v":8026.76},null,3]
[4,1,1,"MELCHOR NAVARRO OBED",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,8344,333.76,584.08000000000004,0,917.84,8344,9261.84,null,0,0,1235.0892240000003,1235.08,0,8026.76,null,4]
[5,1,1,"GOMEZ RICO LUZ ELENA",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,8344,333.76,584.08000000000004,0,917.84,8344,9261.84,null,0,0,1235.0892240000003,1235.08,0,8026.76,null,5]
[6,1,1,"GUTIERREZ GARCIA GERARDO",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,8344,333.76,584.08000000000004,0,917.84,8344,9261.84,null,null,0,1235.0892240000003,1235.08,0,8026.76,null,6]
[7,1,1,"ROBLEDO ORTIZ EDGAR ANTONIO",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,8344,333.76,584.08000000000004,0,917.84,8344,9261.84,null,null,null,1235.0892240000003,1235.08,0,8026.76,null,7]
[8,1,1,"SIERRA ROMERO DOLORES EDITH",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,8344,333.76,584.08000000000004,0,917.84,8344,9261.84,null,null,null,1235.0892240000003,1235.08,0,8026.76,null,8]
[9,1,1,"VELEZ FREGOSO LUIS MANUEL",null,null,"2012-10-01","REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,556.26666666666665,8344,333.76,584.08000000000004,0,917.84,8344,9261.84,null,0,null,1235.0892240000003,1235.08,0,8026.76,null,9]
[null,null,null,"SALA DE REGIDORES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V9:V17)","v":75096},{"$f":"SUM(W9:W17)","v":3003.84},5256.72,0,8260.56,75096,83356.559999999983,0,0,0,11115.803016000002,11115.72,0,72240.840000000011,0]
[]
[null,null,null,"PRESIDENCIA MUNICIPAL"]
[10,null,null,"RON RAMOS EDUARDO",null,null,null,"PRESIDENTE MUNICIPAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"29592/30","v":986.4},{"$f":"TRUNC(U21*P21,2)","v":14796},{"$f":"TRUNC(U21*P21*0.04,2)","v":591.84},{"$f":"TRUNC(U21*0.07*P21,2)","v":1035.72},{"$f":"S21","v":0},{"$f":"TRUNC(X21+W21+(IF(Y21>519,519,Y21))+IF(R21=0,0,R21*U21),2)","v":1627.56},{"$f":"TRUNC((IF(R21=0,P21*U21,(P21-R21)*U21))+(IF(Y21<519,0,Y21-519)),2)+T21","v":14796},{"$f":"Z21+AA21","v":16423.560000000001},null,0,0,{"$f":"IF(U21>0.01,(AA21-VLOOKUP(AA21,quincenal,1))*VLOOKUP(AA21,quincenal,3)+VLOOKUP(AA21,quincenal,2)-VLOOKUP(AA21,subquincenal,2),0)","v":2711.331408},{"$f":"TRUNC(IF(AF21>0.01,AF21,0),2)","v":2711.33},{"$f":"TRUNC(IF(AF21<0.01,-AF21,0),2)","v":0},{"$f":"AB21-AD21-AE21-AG21+AH21","v":13712.230000000001},null,10]
[11,null,null,"BAROCIO FIGUEROA ANTONIO","FEPM871023ND1","FEPM871023MJCRRR07",null,"SECRETARIO PARTICULAR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U22*P22,2)","v":6326.5},{"$f":"TRUNC(U22*P22*0.04,2)","v":253.06},{"$f":"TRUNC(U22*0.07*P22,2)","v":442.85},{"$f":"S22","v":0},{"$f":"TRUNC(X22+W22+(IF(Y22>519,519,Y22))+IF(R22=0,0,R22*U22),2)","v":695.91},{"$f":"TRUNC((IF(R22=0,P22*U22,(P22-R22)*U22))+(IF(Y22<519,0,Y22-519)),2)+T22","v":6326.5},{"$f":"Z22+AA22","v":7022.41},null,null,0,{"$f":"IF(U22>0.01,(AA22-VLOOKUP(AA22,quincenal,1))*VLOOKUP(AA22,quincenal,3)+VLOOKUP(AA22,quincenal,2)-VLOOKUP(AA22,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF22>0.01,AF22,0),2)","v":804.15},{"$f":"TRUNC(IF(AF22<0.01,-AF22,0),2)","v":0},{"$f":"AB22-AD22-AE22-AG22+AH22","v":6218.26},null,11]
[12,null,null,"BECERRA GONZALEZ MARISOL","FEPM871023ND1","FEPM871023MJCRRR07",null,"SECRETARIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8121/30","v":270.7},{"$f":"TRUNC(U23*P23,2)","v":4060.5},{"$f":"TRUNC(U23*P23*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U23*0.07*P23,2)","v":284.23},{"$f":"S23","v":0},{"$f":"TRUNC(X23+W23+(IF(Y23>519,519,Y23))+IF(R23=0,0,R23*U23),2)","v":446.65},{"$f":"TRUNC((IF(R23=0,P23*U23,(P23-R23)*U23))+(IF(Y23<519,0,Y23-519)),2)+T23","v":4060.5},{"$f":"Z23+AA23","v":4507.1499999999996},null,null,0,{"$f":"IF(U23>0.01,(AA23-VLOOKUP(AA23,quincenal,1))*VLOOKUP(AA23,quincenal,3)+VLOOKUP(AA23,quincenal,2)-VLOOKUP(AA23,subquincenal,2),0)","v":358.76839999999999},{"$f":"TRUNC(IF(AF23>0.01,AF23,0),2)","v":358.76},{"$f":"TRUNC(IF(AF23<0.01,-AF23,0),2)","v":0},{"$f":"AB23-AD23-AE23-AG23+AH23","v":4148.3899999999994},null,12]
[null,null,null,"PRESIDENCIA MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V21:V23)","v":25183},{"$f":"SUM(W21:W23)","v":1007.32},1762.8000000000002,0,2770.12,25183,27953.120000000003,0,0,0,3874.2510320000001,3874.24,0,24078.880000000001]
[]
[null,null,null,"SECRETARIA GENERAL Y SINDICATURA"]
[13,1,5,"FREGOSO BARBOZA MARTIN DANIEL",null,null,null,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"21439/30","v":714.63333333333333},{"$f":"TRUNC(U27*P27,2)","v":10719.5},{"$f":"TRUNC(U27*P27*0.04,2)","v":428.78},{"$f":"TRUNC(U27*0.07*P27,2)","v":750.36},{"$f":"S27","v":0},{"$f":"TRUNC(X27+W27+(IF(Y27>519,519,Y27))+IF(R27=0,0,R27*U27),2)","v":1179.1400000000001},{"$f":"TRUNC((IF(R27=0,P27*U27,(P27-R27)*U27))+(IF(Y27<519,0,Y27-519)),2)+T27","v":10719.5},{"$f":"Z27+AA27","v":11898.64},null,0,0,{"$f":"IF(U27>0.01,(AA27-VLOOKUP(AA27,quincenal,1))*VLOOKUP(AA27,quincenal,3)+VLOOKUP(AA27,quincenal,2)-VLOOKUP(AA27,subquincenal,2),0)","v":1752.5386080000003},{"$f":"TRUNC(IF(AF27>0.01,AF27,0),2)","v":1752.53},{"$f":"TRUNC(IF(AF27<0.01,-AF27,0),2)","v":0},{"$f":"AB27-AD27-AE27-AG27+AH27","v":10146.109999999999},null,14]
[14,null,null,"MATA COVARRUBIAS ALAN MARCOS",null,null,null,"SECRETARIO GENERAL ",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"19266/30","v":642.20000000000005},{"$f":"TRUNC(U28*P28,2)","v":9633},{"$f":"TRUNC(U28*P28*0.04,2)","v":385.32},{"$f":"TRUNC(U28*0.07*P28,2)","v":674.31},{"$f":"S28","v":0},{"$f":"TRUNC(X28+W28+(IF(Y28>519,519,Y28))+IF(R28=0,0,R28*U28),2)","v":1059.6300000000001},{"$f":"TRUNC((IF(R28=0,P28*U28,(P28-R28)*U28))+(IF(Y28<519,0,Y28-519)),2)+T28","v":9633},{"$f":"Z28+AA28","v":10692.630000000001},null,0,0,{"$f":"IF(U28>0.01,(AA28-VLOOKUP(AA28,quincenal,1))*VLOOKUP(AA28,quincenal,3)+VLOOKUP(AA28,quincenal,2)-VLOOKUP(AA28,subquincenal,2),0)","v":1510.4196240000001},{"$f":"TRUNC(IF(AF28>0.01,AF28,0),2)","v":1510.41},{"$f":"TRUNC(IF(AF28<0.01,-AF28,0),2)","v":0},{"$f":"AB28-AD28-AE28-AG28+AH28","v":9182.2200000000012}]
[15,null,null,"IBARRA FLORES MILAGROS SARAHI",null,null,null,"SECRETARIA EN SINDICATURA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(U29*P29,2)","v":1709.65},{"$f":"TRUNC(U29*P29*0.04,2)","v":68.38},{"$f":"TRUNC(U29*0.07*P29,2)","v":119.67},{"$f":"S29","v":0},{"$f":"TRUNC(X29+W29+(IF(Y29>519,519,Y29))+IF(R29=0,0,R29*U29),2)","v":188.05},{"$f":"TRUNC((IF(R29=0,P29*U29,(P29-R29)*U29))+(IF(Y29<519,0,Y29-519)),2)+T29","v":1709.65},{"$f":"Z29+AA29","v":1897.7},null,null,0,{"$f":"IF(U29>0.01,(AA29-VLOOKUP(AA29,quincenal,1))*VLOOKUP(AA29,quincenal,3)+VLOOKUP(AA29,quincenal,2)-VLOOKUP(AA29,subquincenal,2),0)","v":-102.30023999999997},{"$f":"TRUNC(IF(AF29>0.01,AF29,0),2)","v":0},{"$f":"TRUNC(IF(AF29<0.01,-AF29,0),2)","v":102.3},{"$f":"AB29-AD29-AE29-AG29+AH29","v":2000}]
[16,null,null,"REYNAGA LOPEZ NAHSDHELLY ALEJANDRA ",null,null,null,"AUXILIAR JURIDICO ",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8104/30","v":270.13333333333333},{"$f":"TRUNC(U30*P30,2)","v":4052},{"$f":"TRUNC(U30*P30*0.04,2)","v":162.08000000000001},{"$f":"TRUNC(U30*0.07*P30,2)","v":283.64},{"$f":"S30","v":0},{"$f":"TRUNC(X30+W30+(IF(Y30>519,519,Y30))+IF(R30=0,0,R30*U30),2)","v":445.72},{"$f":"TRUNC((IF(R30=0,P30*U30,(P30-R30)*U30))+(IF(Y30<519,0,Y30-519)),2)+T30","v":4052},{"$f":"Z30+AA30","v":4497.72},null,null,0,{"$f":"IF(U30>0.01,(AA30-VLOOKUP(AA30,quincenal,1))*VLOOKUP(AA30,quincenal,3)+VLOOKUP(AA30,quincenal,2)-VLOOKUP(AA30,subquincenal,2),0)","v":357.40839999999997},{"$f":"TRUNC(IF(AF30>0.01,AF30,0),2)","v":357.4},{"$f":"TRUNC(IF(AF30<0.01,-AF30,0),2)","v":0},{"$f":"AB30-AD30-AE30-AG30+AH30","v":4140.3200000000006},null,16]
[17,null,null,"CARDENAS GUEVARA JORGE RAFAEL",null,null,null,"AUXILIAR ADMINISTRATIVO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U31*P31,2)","v":2857},{"$f":"TRUNC(U31*P31*0.04,2)","v":114.28},{"$f":"TRUNC(U31*0.07*P31,2)","v":199.99},{"$f":"S31","v":0},{"$f":"TRUNC(X31+W31+(IF(Y31>519,519,Y31))+IF(R31=0,0,R31*U31),2)","v":314.27},{"$f":"TRUNC((IF(R31=0,P31*U31,(P31-R31)*U31))+(IF(Y31<519,0,Y31-519)),2)+T31","v":2857},{"$f":"Z31+AA31","v":3171.27},null,null,0,{"$f":"IF(U31>0.01,(AA31-VLOOKUP(AA31,quincenal,1))*VLOOKUP(AA31,quincenal,3)+VLOOKUP(AA31,quincenal,2)-VLOOKUP(AA31,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF31>0.01,AF31,0),2)","v":61.4},{"$f":"TRUNC(IF(AF31<0.01,-AF31,0),2)","v":0},{"$f":"AB31-AD31-AE31-AG31+AH31","v":3109.87},null,17]
[null,null,null,"SECRETARIA GENERAL Y SINDICATURA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V27:V31)","v":28971.15},{"$f":"SUM(W27:W31)","v":1158.8399999999999},2027.97,0,3186.8100000000009,28971.15,32157.960000000003,0,0,0,{"$f":"SUM(AF27:AF31)","v":3579.4749040000002},3681.7400000000002,102.3,28578.52]
[]
[null,null,null,"OFICIALIA MAYOR ADMINISTRATIVA"]
[18,null,null,"ALDAZ VELEZ LORENZO MIGUEL",null,null,null,"OFICIAL MAYOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"15321/30","v":510.7},{"$f":"TRUNC(U35*P35,2)","v":7660.5},{"$f":"TRUNC(U35*P35*0.04,2)","v":306.42},{"$f":"TRUNC(U35*0.07*P35,2)","v":536.23},{"$f":"S35","v":0},{"$f":"TRUNC(X35+W35+(IF(Y35>519,519,Y35))+IF(R35=0,0,R35*U35),2)","v":842.65},{"$f":"TRUNC((IF(R35=0,P35*U35,(P35-R35)*U35))+(IF(Y35<519,0,Y35-519)),2)+T35","v":7660.5},{"$f":"Z35+AA35","v":8503.15},null,0,0,{"$f":"IF(U35>0.01,(AA35-VLOOKUP(AA35,quincenal,1))*VLOOKUP(AA35,quincenal,3)+VLOOKUP(AA35,quincenal,2)-VLOOKUP(AA35,subquincenal,2),0)","v":1089.0936240000001},{"$f":"TRUNC(IF(AF35>0.01,AF35,0),2)","v":1089.0899999999999},{"$f":"TRUNC(IF(AF35<0.01,-AF35,0),2)","v":0},{"$f":"AB35-AD35-AE35-AG35+AH35","v":7414.0599999999995},null,18]
[19,null,null,"VENTURA PEREZ HERLINDA AURORA","VEPH840722PR4","VEPH840722MJCNRR04",null,"SECRETARIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6356/30","v":211.86666666666667},{"$f":"TRUNC(U36*P36,2)","v":3178},{"$f":"TRUNC(U36*P36*0.04,2)","v":127.12},{"$f":"TRUNC(U36*0.07*P36,2)","v":222.46},0,{"$f":"TRUNC(X36+W36+(IF(Y36>519,519,Y36))+IF(R36=0,0,R36*U36),2)","v":349.58},{"$f":"TRUNC((IF(R36=0,P36*U36,(P36-R36)*U36))+(IF(Y36<519,0,Y36-519)),2)+T36","v":3178},3527.58,null,0,0,{"$f":"IF(U36>0.01,(AA36-VLOOKUP(AA36,quincenal,1))*VLOOKUP(AA36,quincenal,3)+VLOOKUP(AA36,quincenal,2)-VLOOKUP(AA36,subquincenal,2),0)","v":116.58331199999998},116.58,0,3411,null,19]
[null,null,null,"OFICIALIA MAYOR ADMINISTRATIVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V35:V36)","v":10838.5},{"$f":"SUM(W35:W36)","v":433.54},758.69,0,1192.23,10838.5,12030.73,0,0,0,1205.6769360000001,1205.6699999999998,0,10825.06,null,20]
[]
[null,null,null,"DEPARTAMENTO JURIDICO"]
[20,1,7,"FREGOSO MEDRANO CARLOS ALEJANDRO ",null,null,null,"DIRECTOR JURIDICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"20774/30","v":692.4666666666667},{"$f":"TRUNC(U40*P40,2)","v":10387},{"$f":"TRUNC(U40*P40*0.04,2)","v":415.48},{"$f":"TRUNC(U40*0.07*P40,2)","v":727.09},{"$f":"S40","v":0},{"$f":"TRUNC(X40+W40+(IF(Y40>519,519,Y40))+IF(R40=0,0,R40*U40),2)","v":1142.57},{"$f":"TRUNC((IF(R40=0,P40*U40,(P40-R40)*U40))+(IF(Y40<519,0,Y40-519)),2)+T40","v":10387},{"$f":"Z40+AA40","v":11529.57},null,0,0,{"$f":"IF(U40>0.01,(AA40-VLOOKUP(AA40,quincenal,1))*VLOOKUP(AA40,quincenal,3)+VLOOKUP(AA40,quincenal,2)-VLOOKUP(AA40,subquincenal,2),0)","v":1674.3346080000001},{"$f":"TRUNC(IF(AF40>0.01,AF40,0),2)","v":1674.33},{"$f":"TRUNC(IF(AF40<0.01,-AF40,0),2)","v":0},{"$f":"AB40-AD40-AE40-AG40+AH40","v":9855.24},null,22]
[21,null,null,"CARRILLO MUÑOZ CESAR OMAR","CARH770717","CARH770717HJCRDG01",null,"JUEZ MUNICIPAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9593/30","v":319.76666666666665},{"$f":"TRUNC(U41*P41,2)","v":4796.5},{"$f":"TRUNC(U41*P41*0.04,2)","v":191.86},{"$f":"TRUNC(U41*0.07*P41,2)","v":335.75},{"$f":"S41","v":0},{"$f":"TRUNC(X41+W41+(IF(Y41>519,519,Y41))+IF(R41=0,0,R41*U41),2)","v":527.61},{"$f":"TRUNC((IF(R41=0,P41*U41,(P41-R41)*U41))+(IF(Y41<519,0,Y41-519)),2)+T41","v":4796.5},{"$f":"Z41+AA41","v":5324.11},null,0,0,{"$f":"IF(U41>0.01,(AA41-VLOOKUP(AA41,quincenal,1))*VLOOKUP(AA41,quincenal,3)+VLOOKUP(AA41,quincenal,2)-VLOOKUP(AA41,subquincenal,2),0)","v":487.03828800000008},{"$f":"TRUNC(IF(AF41>0.01,AF41,0),2)","v":487.03},{"$f":"TRUNC(IF(AF41<0.01,-AF41,0),2)","v":0},{"$f":"AB41-AD41-AE41-AG41+AH41","v":4837.08},null,23]
[22,null,null,"NAVARRO SEGURA KAREN LIZBETH","CARH770717","CARH770717HJCRDG01",null,"SECRETARIA DE JUEZ MUNICIPAL",null,null,null,null,null,null,null,15,"TARJETA",null,null,null,88.483339999999998,{"$f":"TRUNC(U42*P42,2)","v":1327.25},{"$f":"TRUNC(U42*P42*0.04,2)","v":53.09},{"$f":"TRUNC(U42*0.07*P42,2)","v":92.9},{"$f":"S42","v":0},{"$f":"TRUNC(X42+W42+(IF(Y42>519,519,Y42))+IF(R42=0,0,R42*U42),2)","v":145.99},{"$f":"TRUNC((IF(R42=0,P42*U42,(P42-R42)*U42))+(IF(Y42<519,0,Y42-519)),2)+T42","v":1327.25},{"$f":"Z42+AA42","v":1473.24},null,500,0,{"$f":"IF(U42>0.01,(AA42-VLOOKUP(AA42,quincenal,1))*VLOOKUP(AA42,quincenal,3)+VLOOKUP(AA42,quincenal,2)-VLOOKUP(AA42,subquincenal,2),0)","v":-126.77383999999998},{"$f":"TRUNC(IF(AF42>0.01,AF42,0),2)","v":0},{"$f":"TRUNC(IF(AF42<0.01,-AF42,0),2)","v":126.77},{"$f":"AB42-AD42-AE42-AG42+AH42-0.01","v":1100},null,24]
[null,null,null,"DEPARTAMENTO JURIDICO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V40:V42)","v":16510.75},660.43000000000006,1155.7400000000002,0,1816.1699999999998,16510.75,18326.920000000002,0,500,0,2034.5990560000002,2161.3599999999997,126.77,15792.32]
[]
[null,null,null,"UNIDAD DE TRANSPARENCIA"]
[22,null,null,null,"HEEG670312","HEER670312MJCRNS06","2007-01-08","DIRECTOR DE TRANSPARENCIA",null,null,null,null,null,null,null,null,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U46*P46,2)","v":0},{"$f":"TRUNC(U46*P46*0.04,2)","v":0},{"$f":"TRUNC(U46*0.07*P46,2)","v":0},{"$f":"S46","v":0},{"$f":"TRUNC(X46+W46+(IF(Y46>519,519,Y46))+IF(R46=0,0,R46*U46),2)","v":0},{"$f":"TRUNC((IF(R46=0,P46*U46,(P46-R46)*U46))+(IF(Y46<519,0,Y46-519)),2)+T46","v":0},{"$f":"Z46+AA46","v":0},null,null,0,{"$f":"IF(U46>0.01,(AA46-VLOOKUP(AA46,quincenal,1))*VLOOKUP(AA46,quincenal,3)+VLOOKUP(AA46,quincenal,2)-VLOOKUP(AA46,subquincenal,2),0)","v":{"$error":"#N/A"}},null,null,null,null,25]
[23,null,null,"REYES MONTERO HECTOR CARLOS","PAGM780607","PAGM780607MJCLRR03",null,"AUXILIAR DE TRANSPARENCIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6795/30","v":226.5},{"$f":"TRUNC(U47*P47,2)","v":3397.5},{"$f":"TRUNC(U47*P47*0.04,2)","v":135.9},{"$f":"TRUNC(U47*0.07*P47,2)","v":237.82},{"$f":"S47","v":0},{"$f":"TRUNC(X47+W47+(IF(Y47>519,519,Y47))+IF(R47=0,0,R47*U47),2)","v":373.72},{"$f":"TRUNC((IF(R47=0,P47*U47,(P47-R47)*U47))+(IF(Y47<519,0,Y47-519)),2)+T47","v":3397.5},{"$f":"Z47+AA47","v":3771.2200000000003},null,null,0,{"$f":"IF(U47>0.01,(AA47-VLOOKUP(AA47,quincenal,1))*VLOOKUP(AA47,quincenal,3)+VLOOKUP(AA47,quincenal,2)-VLOOKUP(AA47,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF47>0.01,AF47,0),2)","v":140.46},{"$f":"TRUNC(IF(AF47<0.01,-AF47,0),2)","v":0},{"$f":"AB47-AD47-AE47-AG47+AH47","v":3630.76},null,26]
[null,null,null,"UNIDAD DE TRANSPARENCIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V46:V47)","v":3397.5},{"$f":"SUM(W46:W47)","v":135.9},237.82,0,373.72,3397.5,3771.2200000000003,0,0,0,{"$error":"#N/A"},140.46,0,3630.76]
[]
[null,null,null,"DIRECCION DE REGISTRO CIVIL"]
[24,null,null,"NAVARRO HERNANDEZ ALMA SAGRARIO","HEEG670312","HEER670312MJCRNS06","2007-01-08","JEFE OFICIAL DE REGISTRO CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,217.79390000000001,{"$f":"TRUNC(U51*P51,2)","v":3266.9},{"$f":"TRUNC(U51*P51*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(U51*0.07*P51,2)","v":228.68},{"$f":"S51","v":0},{"$f":"TRUNC(X51+W51+(IF(Y51>519,519,Y51))+IF(R51=0,0,R51*U51),2)","v":359.35},{"$f":"TRUNC((IF(R51=0,P51*U51,(P51-R51)*U51))+(IF(Y51<519,0,Y51-519)),2)+T51","v":3266.9},{"$f":"Z51+AA51","v":3626.25},null,null,0,{"$f":"IF(U51>0.01,(AA51-VLOOKUP(AA51,quincenal,1))*VLOOKUP(AA51,quincenal,3)+VLOOKUP(AA51,quincenal,2)-VLOOKUP(AA51,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(AF51>0.01,AF51,0),2)","v":126.25},{"$f":"TRUNC(IF(AF51<0.01,-AF51,0),2)","v":0},{"$f":"AB51-AD51-AE51-AG51+AH51","v":3500},null,27]
[25,null,null,null,"PAGM780607","PAGM780607MJCLRR03",null,"OFICIAL AUX. DE REGISTRO CIVIL",null,null,null,null,null,null,null,0,"TARJETA",null,0,0,{"$f":"5183/30","v":172.76666666666668},{"$f":"TRUNC(U52*P52,2)","v":0},{"$f":"TRUNC(U52*P52*0.04,2)","v":0},{"$f":"TRUNC(U52*0.07*P52,2)","v":0},{"$f":"S52","v":0},{"$f":"TRUNC(X52+W52+(IF(Y52>519,519,Y52))+IF(R52=0,0,R52*U52),2)","v":0},{"$f":"TRUNC((IF(R52=0,P52*U52,(P52-R52)*U52))+(IF(Y52<519,0,Y52-519)),2)+T52","v":0},{"$f":"Z52+AA52","v":0},null,null,0,{"$f":"IF(U52>0.01,(AA52-VLOOKUP(AA52,quincenal,1))*VLOOKUP(AA52,quincenal,3)+VLOOKUP(AA52,quincenal,2)-VLOOKUP(AA52,subquincenal,2),0)","v":{"$error":"#N/A"}},null,null,{"$f":"AB52-AD52-AE52-AG52+AH52","v":0},null,28]
[null,null,null,"DIRECCION DE REGISTRO CIVIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V51:V52)","v":3266.9},{"$f":"SUM(W51:W52)","v":130.66999999999999},228.68,0,359.35,3266.9,3626.25,0,0,0,{"$error":"#N/A"},126.25,0,3500]
[]
[null,null,null,"OFICIALIA MAYOR DE CULTURA"]
[26,null,null,"DIAZ PEREZ SAMUEL","MAM620222",null,null,"DIRECTOR DE CULTURA Y TURISMO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U56*P56,2)","v":6326.5},{"$f":"TRUNC(U56*P56*0.04,2)","v":253.06},{"$f":"TRUNC(U56*0.07*P56,2)","v":442.85},{"$f":"S56","v":0},{"$f":"TRUNC(X56+W56+(IF(Y56>519,519,Y56))+IF(R56=0,0,R56*U56),2)","v":695.91},{"$f":"TRUNC((IF(R56=0,P56*U56,(P56-R56)*U56))+(IF(Y56<519,0,Y56-519)),2)+T56","v":6326.5},{"$f":"Z56+AA56","v":7022.41},null,null,0,{"$f":"IF(U56>0.01,(AA56-VLOOKUP(AA56,quincenal,1))*VLOOKUP(AA56,quincenal,3)+VLOOKUP(AA56,quincenal,2)-VLOOKUP(AA56,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF56>0.01,AF56,0),2)","v":804.15},{"$f":"TRUNC(IF(AF56<0.01,-AF56,0),2)","v":0},{"$f":"AB56-AD56-AE56-AG56+AH56","v":6218.26},null,31]
[27,null,null,"PARRA RON CARLOS ENRIQUE","PARC480708","PARC480708HJCRNR08","2004-01-01","CRONISTA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,295.625,{"$f":"TRUNC(U57*P57,2)","v":4434.37},{"$f":"TRUNC(U57*P57*0.04,2)","v":177.37},{"$f":"TRUNC(U57*0.07*P57,2)","v":310.39999999999998},{"$f":"S57","v":0},{"$f":"TRUNC(X57+W57+(IF(Y57>519,519,Y57))+IF(R57=0,0,R57*U57),2)","v":487.77},{"$f":"TRUNC((IF(R57=0,P57*U57,(P57-R57)*U57))+(IF(Y57<519,0,Y57-519)),2)+T57","v":4434.37},{"$f":"Z57+AA57","v":4922.1399999999994},null,null,0,{"$f":"IF(U57>0.01,(AA57-VLOOKUP(AA57,quincenal,1))*VLOOKUP(AA57,quincenal,3)+VLOOKUP(AA57,quincenal,2)-VLOOKUP(AA57,subquincenal,2),0)","v":422.14459200000005},{"$f":"TRUNC(IF(AF57>0.01,AF57,0),2)","v":422.14},{"$f":"TRUNC(IF(AF57<0.01,-AF57,0),2)","v":0},{"$f":"AB57-AD57-AE57-AG57+AH57","v":4499.9999999999991},null,32]
[28,null,null,"GONZALEZ JUAREZ ALEJANDRA AMANDA",null,null,null,"SECRETARIA DE CASA DE LA CULTURA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4615/30","v":153.83333333333334},{"$f":"TRUNC(U58*P58,2)","v":2307.5},{"$f":"TRUNC(U58*P58*0.04,2)","v":92.3},{"$f":"TRUNC(U58*0.07*P58,2)","v":161.52000000000001},{"$f":"S58","v":0},{"$f":"TRUNC(X58+W58+(IF(Y58>519,519,Y58))+IF(R58=0,0,R58*U58),2)","v":253.82},{"$f":"TRUNC((IF(R58=0,P58*U58,(P58-R58)*U58))+(IF(Y58<519,0,Y58-519)),2)+T58","v":2307.5},{"$f":"Z58+AA58","v":2561.3200000000002},null,0,null,{"$f":"IF(U58>0.01,(AA58-VLOOKUP(AA58,quincenal,1))*VLOOKUP(AA58,quincenal,3)+VLOOKUP(AA58,quincenal,2)-VLOOKUP(AA58,subquincenal,2),0)","v":-27.77708800000002},0,27.77,{"$f":"AB58-AD58-AE58-AG58+AH58","v":2589.09},null,33]
[28,null,null,"ARCINIEGA RODRIGUEZ ANTONIO",null,null,null,"ENCARGADO DE  EQUIPO DE SONIDO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8445/30","v":281.5},4222.5,168.9,295.57,0,464.47,4222.5,4686.97,null,null,0,{"$f":"IF(U59>0.01,(AA59-VLOOKUP(AA59,quincenal,1))*VLOOKUP(AA59,quincenal,3)+VLOOKUP(AA59,quincenal,2)-VLOOKUP(AA59,subquincenal,2),0)","v":384.6884},384.68,0,4302.29,null,37]
[null,null,null,"OFICIALIA MAYOR DE CULTURA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V56:V59)","v":17290.87},{"$f":"SUM(W56:W59)","v":691.63},1210.3399999999999,0,1901.9699999999998,17290.87,19192.84,0,0,0,1583.207128,1610.97,27.77,17609.64]
[]
[null,null,null,"DEPARTAMENTO DE COMUNICACIÓN SOCIAL"]
[30,1,19,null,null,null,null,null,null,null,null,null,null,null,null,null,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},null,null,null,{"$f":"S63","v":0},{"$f":"TRUNC(X63+W63+(IF(Y63>519,519,Y63))+IF(R63=0,0,R63*U63),2)","v":0},{"$f":"TRUNC((IF(R63=0,P63*U63,(P63-R63)*U63))+(IF(Y63<519,0,Y63-519)),2)+T63","v":0},{"$f":"Z63+AA63","v":0},null,null,null,{"$f":"IF(U63>0.01,(AA63-VLOOKUP(AA63,quincenal,1))*VLOOKUP(AA63,quincenal,3)+VLOOKUP(AA63,quincenal,2)-VLOOKUP(AA63,subquincenal,2),0)","v":{"$error":"#N/A"}},null,null,null,null,38]
[null,null,null,"DEPARTAMENTO DE COMUNICACIÓN SOCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V63:V63)","v":0},0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,0,0]
[]
[null,null,null,"DIRECCION DE EDUCACION"]
[30,null,null,"MARISCAL MORALES ILIANA PATRICIA",null,null,null,"SUBDIRECTORA DE TALLERES DE CAPACITACION",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6795/30","v":226.5},{"$f":"TRUNC(U67*P67,2)","v":3397.5},{"$f":"TRUNC(U67*P67*0.04,2)","v":135.9},{"$f":"TRUNC(U67*0.07*P67,2)","v":237.82},{"$f":"S67","v":0},{"$f":"TRUNC(X67+W67+(IF(Y67>519,519,Y67))+IF(R67=0,0,R67*U67),2)","v":373.72},{"$f":"TRUNC((IF(R67=0,P67*U67,(P67-R67)*U67))+(IF(Y67<519,0,Y67-519)),2)+T67","v":3397.5},{"$f":"Z67+AA67","v":3771.2200000000003},null,null,0,{"$f":"IF(U67>0.01,(AA67-VLOOKUP(AA67,quincenal,1))*VLOOKUP(AA67,quincenal,3)+VLOOKUP(AA67,quincenal,2)-VLOOKUP(AA67,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF67>0.01,AF67,0),2)","v":140.46},{"$f":"TRUNC(IF(AF67<0.01,-AF67,0),2)","v":0},{"$f":"AB67-AD67-AE67-AG67+AH67","v":3630.76},null,41]
[31,null,null,"HERNANDEZ ESPERICUETA EFRAIN",null,null,null,"DIRECTOR DE TALLERES DE CAPACITACION",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8121/30","v":270.7},{"$f":"TRUNC(U68*P68,2)","v":4060.5},{"$f":"TRUNC(U68*P68*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U68*0.07*P68,2)","v":284.23},{"$f":"S68","v":0},{"$f":"TRUNC(X68+W68+(IF(Y68>519,519,Y68))+IF(R68=0,0,R68*U68),2)","v":446.65},{"$f":"TRUNC((IF(R68=0,P68*U68,(P68-R68)*U68))+(IF(Y68<519,0,Y68-519)),2)+T68","v":4060.5},{"$f":"Z68+AA68","v":4507.1499999999996},null,null,0,{"$f":"IF(U68>0.01,(AA68-VLOOKUP(AA68,quincenal,1))*VLOOKUP(AA68,quincenal,3)+VLOOKUP(AA68,quincenal,2)-VLOOKUP(AA68,subquincenal,2),0)","v":358.76839999999999},{"$f":"TRUNC(IF(AF68>0.01,AF68,0),2)","v":358.76},{"$f":"TRUNC(IF(AF68<0.01,-AF68,0),2)","v":0},{"$f":"AB68-AD68-AE68-AG68+AH68","v":4148.3899999999994},null,42]
[32,null,null,"MADRID ZAINES DELIA CAROLINA",null,null,null,"SECRETARIA DE DIRECTOR DE EDUCACION",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U69*P69,2)","v":2857},{"$f":"TRUNC(U69*P69*0.04,2)","v":114.28},{"$f":"TRUNC(U69*0.07*P69,2)","v":199.99},{"$f":"S69","v":0},{"$f":"TRUNC(X69+W69+(IF(Y69>519,519,Y69))+IF(R69=0,0,R69*U69),2)","v":314.27},{"$f":"TRUNC((IF(R69=0,P69*U69,(P69-R69)*U69))+(IF(Y69<519,0,Y69-519)),2)+T69","v":2857},{"$f":"Z69+AA69","v":3171.27},null,null,0,{"$f":"IF(U69>0.01,(AA69-VLOOKUP(AA69,quincenal,1))*VLOOKUP(AA69,quincenal,3)+VLOOKUP(AA69,quincenal,2)-VLOOKUP(AA69,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF69>0.01,AF69,0),2)","v":61.4},{"$f":"TRUNC(IF(AF69<0.01,-AF69,0),2)","v":0},{"$f":"AB69-AD69-AE69-AG69+AH69","v":3109.87},null,43]
[33,null,null,"GAVILANES NAVARRO JOSE RICARDO",null,null,null,"CHIOFER CAMION ESTUDIANTES",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,260.28699999999998,{"$f":"TRUNC(U70*P70,2)","v":3904.3},{"$f":"TRUNC(U70*P70*0.04,2)","v":156.16999999999999},{"$f":"TRUNC(U70*0.07*P70,2)","v":273.3},{"$f":"S70","v":0},{"$f":"TRUNC(X70+W70+(IF(Y70>519,519,Y70))+IF(R70=0,0,R70*U70),2)","v":429.47},{"$f":"TRUNC((IF(R70=0,P70*U70,(P70-R70)*U70))+(IF(Y70<519,0,Y70-519)),2)+T70","v":3904.3},{"$f":"Z70+AA70","v":4333.7700000000004},null,null,0,{"$f":"IF(U70>0.01,(AA70-VLOOKUP(AA70,quincenal,1))*VLOOKUP(AA70,quincenal,3)+VLOOKUP(AA70,quincenal,2)-VLOOKUP(AA70,subquincenal,2),0)","v":333.77639999999997},{"$f":"TRUNC(IF(AF70>0.01,AF70,0),2)","v":333.77},{"$f":"TRUNC(IF(AF70<0.01,-AF70,0),2)","v":0},{"$f":"AB70-AD70-AE70-AG70+AH70","v":4000.0000000000005},null,44]
[null,null,null,"DIRECCION DE EDUCACION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V67:V70)","v":14219.3},{"$f":"SUM(W67:W70)","v":568.77},995.33999999999992,0,1564.11,14219.3,15783.41,0,0,0,894.4182239999999,894.39,0,14889.02]
[]
[null,null,null,"DEPARTAMENTO DE PROMOCION Y DESARROLLO ECONOMICO"]
[34,null,null,"RODRIGUEZ ARQUIETA FAUSTO RAFAEL",null,null,null,"DIRECTOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"14973/30","v":499.1},{"$f":"TRUNC(U74*P74,2)","v":7486.5},{"$f":"TRUNC(U74*P74*0.04,2)","v":299.45999999999998},{"$f":"TRUNC(U74*0.07*P74,2)","v":524.04999999999995},{"$f":"S74","v":0},{"$f":"TRUNC(X74+W74+(IF(Y74>519,519,Y74))+IF(R74=0,0,R74*U74),2)","v":823.51},{"$f":"TRUNC((IF(R74=0,P74*U74,(P74-R74)*U74))+(IF(Y74<519,0,Y74-519)),2)+T74","v":7486.5},{"$f":"Z74+AA74","v":8310.01},null,0,0,{"$f":"IF(U74>0.01,(AA74-VLOOKUP(AA74,quincenal,1))*VLOOKUP(AA74,quincenal,3)+VLOOKUP(AA74,quincenal,2)-VLOOKUP(AA74,subquincenal,2),0)","v":1051.927224},{"$f":"TRUNC(IF(AF74>0.01,AF74,0),2)","v":1051.92},{"$f":"TRUNC(IF(AF74<0.01,-AF74,0),2)","v":0},{"$f":"AB74-AD74-AE74-AG74+AH74","v":7258.09},null,45]
[35,null,null,null,null,null,null,"DIRECTOR DE PROMOCION ECONOMICA",null,null,null,null,null,null,null,0,"TARJETA",null,0,0,{"$f":"13813/30","v":460.43333333333334},0,0,0,0,0,0,0,null,null,0,{"$error":"#N/A"},0,0,0,null,46]
[36,null,null,"PLASCENCIA GARCIA OSCARI","PAGO721112","PAGO721112HJCLRS01",null,"AUXILIAR ADMINISTRATIVO DE PROMOCION ECONOMICA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6419/30","v":213.96666666666667},3209.5,128.38,224.66,0,353.04,3209.5,3562.54,null,null,0,120.01051199999998,120.01,{"$f":"TRUNC(IF(AF76<0.01,-AF76,0),2)","v":0},3442.5299999999997,null,47]
[37,null,null,"ULLOA MARTINEZ MARCELA GUADALUPE","UOMM730612","UOMM730612MJCLRR02","1998-01-01","AUXILIAR ADMINISTRATIVO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6783/30","v":226.1},3391.5,135.66,237.4,0,373.06,3391.5,3764.56,null,null,0,139.81211199999998,139.81,{"$f":"TRUNC(IF(AF77<0.01,-AF77,0),2)","v":0},3624.75,null,49]
[null,null,null,"DEPARTAMENTO DE PROMOCION Y DESARROLLO ECONOMICO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V74:V77)","v":14087.5},{"$f":"SUM(W74:W77)","v":563.5},986.1099999999999,0,1549.61,14087.5,15637.109999999999,0,0,0,{"$error":"#N/A"},1311.74,0,14325.369999999999]
[]
[null,null,null,"OFICINA DE ENLACE RELACIONES EXTERIORES"]
[38,null,null,"GUTIERREZ REYES CAROL","GURC680410","GURC680410MJCTYR00","2001-01-02","JEFE ADMINISTRADOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"11550/30","v":385},{"$f":"TRUNC(U81*P81,2)","v":5775},{"$f":"TRUNC(U81*P81*0.04,2)","v":231},{"$f":"TRUNC(U81*0.07*P81,2)","v":404.25},{"$f":"S81","v":0},{"$f":"TRUNC(X81+W81+(IF(Y81>519,519,Y81))+IF(R81=0,0,R81*U81),2)","v":635.25},{"$f":"TRUNC((IF(R81=0,P81*U81,(P81-R81)*U81))+(IF(Y81<519,0,Y81-519)),2)+T81","v":5775},{"$f":"Z81+AA81","v":6410.25},null,null,0,{"$f":"IF(U81>0.01,(AA81-VLOOKUP(AA81,quincenal,1))*VLOOKUP(AA81,quincenal,3)+VLOOKUP(AA81,quincenal,2)-VLOOKUP(AA81,subquincenal,2),0)","v":686.3508240000001},{"$f":"TRUNC(IF(AF81>0.01,AF81,0),2)","v":686.35},{"$f":"TRUNC(IF(AF81<0.01,-AF81,0),2)","v":0},{"$f":"AB81-AD81-AE81-AG81+AH81","v":5723.9},null,51]
[39,null,null,"FREGOSO HURTADO ALEJANDRA","FEHA831218","FEHA831218MJCRRL07","2007-04-10","AUX. ADMINISTRATIVO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6609/30","v":220.3},{"$f":"TRUNC(U82*P82,2)","v":3304.5},{"$f":"TRUNC(U82*P82*0.04,2)","v":132.18},{"$f":"TRUNC(U82*0.07*P82,2)","v":231.31},{"$f":"S82","v":0},{"$f":"TRUNC(X82+W82+(IF(Y82>519,519,Y82))+IF(R82=0,0,R82*U82),2)","v":363.49},{"$f":"TRUNC((IF(R82=0,P82*U82,(P82-R82)*U82))+(IF(Y82<519,0,Y82-519)),2)+T82","v":3304.5},{"$f":"Z82+AA82","v":3667.99},null,null,0,{"$f":"IF(U82>0.01,(AA82-VLOOKUP(AA82,quincenal,1))*VLOOKUP(AA82,quincenal,3)+VLOOKUP(AA82,quincenal,2)-VLOOKUP(AA82,subquincenal,2),0)","v":130.34651199999999},{"$f":"TRUNC(IF(AF82>0.01,AF82,0),2)","v":130.34},{"$f":"TRUNC(IF(AF82<0.01,-AF82,0),2)","v":0},{"$f":"AB82-AD82-AE82-AG82+AH82","v":3537.6499999999996},null,52]
[{"$f":"A82+1","v":40},null,null,"LOPEZ MARTINEZ YVETTE AMALIA MARGARITA","LOMY681017","LOMY681017MJCPRV08","2001-01-01","SUPERVISOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6609/30","v":220.3},{"$f":"TRUNC(U83*P83,2)","v":3304.5},{"$f":"TRUNC(U83*P83*0.04,2)","v":132.18},{"$f":"TRUNC(U83*0.07*P83,2)","v":231.31},{"$f":"S83","v":0},{"$f":"TRUNC(X83+W83+(IF(Y83>519,519,Y83))+IF(R83=0,0,R83*U83),2)","v":363.49},{"$f":"TRUNC((IF(R83=0,P83*U83,(P83-R83)*U83))+(IF(Y83<519,0,Y83-519)),2)+T83","v":3304.5},{"$f":"Z83+AA83","v":3667.99},null,null,0,{"$f":"IF(U83>0.01,(AA83-VLOOKUP(AA83,quincenal,1))*VLOOKUP(AA83,quincenal,3)+VLOOKUP(AA83,quincenal,2)-VLOOKUP(AA83,subquincenal,2),0)","v":130.34651199999999},{"$f":"TRUNC(IF(AF83>0.01,AF83,0),2)","v":130.34},{"$f":"TRUNC(IF(AF83<0.01,-AF83,0),2)","v":0},{"$f":"AB83-AD83-AE83-AG83+AH83","v":3537.6499999999996},null,53]
[41,null,null,"ESTRADA GOMEZ JUAN CARLOS","EAGJ510220NR1","EAGJ510220HJCSMN09",null,"MENSAJERO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6762/30","v":225.4},{"$f":"TRUNC(U84*P84,2)","v":3381},{"$f":"TRUNC(U84*P84*0.04,2)","v":135.24},{"$f":"TRUNC(U84*0.07*P84,2)","v":236.67},{"$f":"S84","v":0},{"$f":"TRUNC(X84+W84+(IF(Y84>519,519,Y84))+IF(R84=0,0,R84*U84),2)","v":371.91},{"$f":"TRUNC((IF(R84=0,P84*U84,(P84-R84)*U84))+(IF(Y84<519,0,Y84-519)),2)+T84","v":3381},{"$f":"Z84+AA84","v":3752.91},null,0,0,{"$f":"IF(U84>0.01,(AA84-VLOOKUP(AA84,quincenal,1))*VLOOKUP(AA84,quincenal,3)+VLOOKUP(AA84,quincenal,2)-VLOOKUP(AA84,subquincenal,2),0)","v":138.66971199999998},{"$f":"TRUNC(IF(AF84>0.01,AF84,0),2)","v":138.66},{"$f":"TRUNC(IF(AF84<0.01,-AF84,0),2)","v":0},{"$f":"AB84-AD84-AE84-AG84+AH84","v":3614.25},null,54]
[null,null,null,"OFICINA DE ENLACE RELACIONES EXTERIORES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V81:V84)","v":15765},{"$f":"SUM(W81:W84)","v":630.6},1103.54,0,1734.14,15765,17499.14,0,0,0,1085.7135599999999,1085.69,0,16413.449999999997]
[]
[null,null,null,"AGENCIAS MUNICIPALES"]
[{"$f":"A84+1","v":42},"2","2","GOMEZ HERNANDEZ FRANCISCO JAVIER",null,null,null,"AGENTE MUNICIPAL STA. ROSALIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3158/30","v":105.26666666666667},{"$f":"TRUNC(U88*P88,2)","v":1579},{"$f":"TRUNC(U88*P88*0.04,2)","v":63.16},{"$f":"TRUNC(U88*0.07*P88,2)","v":110.53},{"$f":"S88","v":0},{"$f":"TRUNC(X88+W88+(IF(Y88>519,519,Y88))+IF(R88=0,0,R88*U88),2)","v":173.69},{"$f":"TRUNC((IF(R88=0,P88*U88,(P88-R88)*U88))+(IF(Y88<519,0,Y88-519)),2)+T88","v":1579},{"$f":"Z88+AA88","v":1752.69},null,0,0,{"$f":"IF(U88>0.01,(AA88-VLOOKUP(AA88,quincenal,1))*VLOOKUP(AA88,quincenal,3)+VLOOKUP(AA88,quincenal,2)-VLOOKUP(AA88,subquincenal,2),0)","v":-110.66183999999998},{"$f":"TRUNC(IF(AF88>0.01,AF88,0),2)","v":0},{"$f":"TRUNC(IF(AF88<0.01,-AF88,0),2)","v":110.66},{"$f":"AB88-AD88-AE88-AG88+AH88","v":1863.3500000000001},null,55]
[{"$f":"A88+1","v":43},"2","2","BERNAL LOPEZ JUAN MANUEL","PALR",null,null,"AGENTE MUNICIPAL SAN RAFAEL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2562/30","v":85.4},1281,51.24,89.67,0,140.91,1281,1421.91,null,null,0,-129.73383999999999,{"$f":"TRUNC(IF(AF89>0.01,AF89,0),2)","v":0},{"$f":"TRUNC(IF(AF89<0.01,-AF89,0),2)","v":129.72999999999999},1551.64,null,56]
[{"$f":"A89+1","v":44},"2","2","GONZALEZ RUIZ JOSE ANGEL","GORA710130M39","GORA710130HJCNZN08",null,"AGENTE MUNICIPAL SAN SEBASTIAN",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2363/30","v":78.766666666666666},1181.5,47.26,82.7,0,129.96,1181.5,1311.46,null,500,0,-136.10183999999998,{"$f":"TRUNC(IF(AF90>0.01,AF90,0),2)","v":0},{"$f":"TRUNC(IF(AF90<0.01,-AF90,0),2)","v":136.1},947.56000000000006,null,57]
[45,"2","2","SIERRA LLAMAS JUAN JOSE","SILJ660418","SILJ660418HJCRLN17",null,"AGENTE MUNICIPAL DE PUERTA DE PERICOS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2761/30","v":92.033333333333331},1380.5,55.22,96.63,0,151.85,1380.5,1532.35,null,null,0,-123.36583999999998,{"$f":"TRUNC(IF(AF91>0.01,AF91,0),2)","v":0},{"$f":"TRUNC(IF(AF91<0.01,-AF91,0),2)","v":123.36},1655.7099999999998,null,58]
[46,null,null,"NAVARRO AYON RAUL JAIME",null,null,null,"AGENTE MUNICIPAL DE LA MAZATA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2562/30","v":85.4},{"$f":"TRUNC(U92*P92,2)","v":1281},{"$f":"TRUNC(U92*P92*0.04,2)","v":51.24},{"$f":"TRUNC(U92*0.07*P92,2)","v":89.67},{"$f":"S92","v":0},{"$f":"TRUNC(X92+W92+(IF(Y92>519,519,Y92))+IF(R92=0,0,R92*U92),2)","v":140.91},{"$f":"TRUNC((IF(R92=0,P92*U92,(P92-R92)*U92))+(IF(Y92<519,0,Y92-519)),2)+T92","v":1281},{"$f":"Z92+AA92","v":1421.91},null,500,0,{"$f":"IF(U92>0.01,(AA92-VLOOKUP(AA92,quincenal,1))*VLOOKUP(AA92,quincenal,3)+VLOOKUP(AA92,quincenal,2)-VLOOKUP(AA92,subquincenal,2),0)","v":-129.73383999999999},0,129.72999999999999,{"$f":"AB92-AD92-AE92-AG92+AH92","v":1051.6400000000001},null,59]
[47,null,null,"PEREZ LLAMAS SAMUEL",null,null,null,"AGENTE MUNICIPAL DE LA QUEBRADA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3556/30","v":118.53333333333333},1778,71.12,124.46,0,195.58,1778,1973.58,null,null,0,-85.92583999999998,0,85.92,2059.5,null,60]
[48,null,null,"HERNANDEZ BAILON VICENTE",null,null,null,"AGENTE MUNICIPAL DE LA EMBOCADA",null,null,null,null,null,null,null,0,"TARJETA",null,0,0,{"$f":"3556/30","v":118.53333333333333},{"$f":"TRUNC(U94*P94,2)","v":0},{"$f":"TRUNC(U94*P94*0.04,2)","v":0},{"$f":"TRUNC(U94*0.07*P94,2)","v":0},{"$f":"S94","v":0},{"$f":"TRUNC(X94+W94+(IF(Y94>519,519,Y94))+IF(R94=0,0,R94*U94),2)","v":0},{"$f":"TRUNC((IF(R94=0,P94*U94,(P94-R94)*U94))+(IF(Y94<519,0,Y94-519)),2)+T94","v":0},{"$f":"Z94+AA94","v":0},null,null,0,{"$f":"IF(U94>0.01,(AA94-VLOOKUP(AA94,quincenal,1))*VLOOKUP(AA94,quincenal,3)+VLOOKUP(AA94,quincenal,2)-VLOOKUP(AA94,subquincenal,2),0)","v":{"$error":"#N/A"}},0,0,{"$f":"AB94-AD94-AE94-AG94+AH94","v":0}]
[49,null,null,"MURILLO HERNANDEZ MARIANO",null,null,null,"AGENTE MUNICIPAL DE LA EMBOCADA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3556/30","v":118.53333333333333},1778,71.12,124.46,0,195.58,1778,1973.58,null,500,0,-85.92583999999998,{"$f":"TRUNC(IF(AF95>0.01,AF95,0),2)","v":0},{"$f":"TRUNC(IF(AF95<0.01,-AF95,0),2)","v":85.92},1559.5]
[50,null,null,"LOPEZ SILVA CARLOS DAMIAN","GOHV780710","GOHV780710HJCMRL00","2007-02-01","CHOFER RECOLECTOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5262/30","v":175.4},{"$f":"TRUNC(U96*P96,2)","v":2631},{"$f":"TRUNC(U96*P96*0.04,2)","v":105.24},{"$f":"TRUNC(U96*0.07*P96,2)","v":184.17},{"$f":"S96","v":0},{"$f":"TRUNC(X96+W96+(IF(Y96>519,519,Y96))+IF(R96=0,0,R96*U96),2)","v":289.41000000000003},{"$f":"TRUNC((IF(R96=0,P96*U96,(P96-R96)*U96))+(IF(Y96<519,0,Y96-519)),2)+T96","v":2631},{"$f":"Z96+AA96","v":2920.41},null,null,0,{"$f":"IF(U96>0.01,(AA96-VLOOKUP(AA96,quincenal,1))*VLOOKUP(AA96,quincenal,3)+VLOOKUP(AA96,quincenal,2)-VLOOKUP(AA96,subquincenal,2),0)","v":21.819711999999981},{"$f":"TRUNC(IF(AF96>0.01,AF96,0),2)","v":21.81},{"$f":"TRUNC(IF(AF96<0.01,-AF96,0),2)","v":0},{"$f":"AB96-AD96-AE96-AG96+AH96","v":2898.6},null,62]
[null,null,null,"AGENCIAS MUNICIPALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V88:V96)","v":12890},{"$f":"SUM(W88:W96)","v":515.6},902.29,0,1417.89,12890,14307.89,0,1500,0,{"$error":"#N/A"},21.81,801.42,13587.500000000002]
[]
[null,null,null,"ADMIN ISTRACION DE LA HACIENDA MUNICIPAL"]
[{"$f":"A96+1","v":51},"3","1","CAMARENA GONZALEZ RUBIO MARIO",null,null,null,"ENCARGADO DE HACIENDA PUBLICA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"17378/30","v":579.26666666666665},{"$f":"TRUNC(U100*P100,2)","v":8689},{"$f":"TRUNC(U100*P100*0.04,2)","v":347.56},{"$f":"TRUNC(U100*0.07*P100,2)","v":608.23},{"$f":"S100","v":0},{"$f":"TRUNC(X100+W100+(IF(Y100>519,519,Y100))+IF(R100=0,0,R100*U100),2)","v":955.79},{"$f":"TRUNC((IF(R100=0,P100*U100,(P100-R100)*U100))+(IF(Y100<519,0,Y100-519)),2)+T100","v":8689},{"$f":"Z100+AA100","v":9644.7900000000009},null,0,0,{"$f":"IF(U100>0.01,(AA100-VLOOKUP(AA100,quincenal,1))*VLOOKUP(AA100,quincenal,3)+VLOOKUP(AA100,quincenal,2)-VLOOKUP(AA100,subquincenal,2),0)","v":1308.7812240000001},{"$f":"TRUNC(IF(AF100>0.01,AF100,0),2)","v":1308.78},{"$f":"TRUNC(IF(AF100<0.01,-AF100,0),2)","v":0},{"$f":"AB100-AD100-AE100-AG100+AH100","v":8336.01},null,63]
[{"$f":"A100+1","v":52},null,null,"PEREZ JAIME ARTURO","PEJA600718","PEXJ600718HJCRXM09","2009-01-05","AUXILIAR CONTABLE",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"10812/30","v":360.4},{"$f":"TRUNC(U101*P101,2)","v":5406},{"$f":"TRUNC(U101*P101*0.04,2)","v":216.24},{"$f":"TRUNC(U101*0.07*P101,2)","v":378.42},{"$f":"S101","v":0},{"$f":"TRUNC(X101+W101+(IF(Y101>519,519,Y101))+IF(R101=0,0,R101*U101),2)","v":594.66},{"$f":"TRUNC((IF(R101=0,P101*U101,(P101-R101)*U101))+(IF(Y101<519,0,Y101-519)),2)+T101","v":5406},{"$f":"Z101+AA101","v":6000.66},null,null,0,{"$f":"IF(U101>0.01,(AA101-VLOOKUP(AA101,quincenal,1))*VLOOKUP(AA101,quincenal,3)+VLOOKUP(AA101,quincenal,2)-VLOOKUP(AA101,subquincenal,2),0)","v":607.53242400000011},{"$f":"TRUNC(IF(AF101>0.01,AF101,0),2)","v":607.53},{"$f":"TRUNC(IF(AF101<0.01,-AF101,0),2)","v":0},{"$f":"AB101-AD101-AE101-AG101+AH101","v":5393.13},null,64]
[{"$f":"A101+1","v":53},null,null,"VALENZUELA PARRA PERLA PATRICIA",null,null,null,"SECRETARIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,165.506,{"$f":"TRUNC(U102*P102,2)","v":2482.59},{"$f":"TRUNC(U102*P102*0.04,2)","v":99.3},{"$f":"TRUNC(U102*0.07*P102,2)","v":173.78},{"$f":"S102","v":0},{"$f":"TRUNC(X102+W102+(IF(Y102>519,519,Y102))+IF(R102=0,0,R102*U102),2)","v":273.08},{"$f":"TRUNC((IF(R102=0,P102*U102,(P102-R102)*U102))+(IF(Y102<519,0,Y102-519)),2)+T102","v":2482.59},{"$f":"Z102+AA102","v":2755.67},null,0,0,{"$f":"IF(U102>0.01,(AA102-VLOOKUP(AA102,quincenal,1))*VLOOKUP(AA102,quincenal,3)+VLOOKUP(AA102,quincenal,2)-VLOOKUP(AA102,subquincenal,2),0)","v":5.6727039999999818},{"$f":"TRUNC(IF(AF102>0.01,AF102,0),2)","v":5.67},{"$f":"TRUNC(IF(AF102<0.01,-AF102,0),2)","v":0},{"$f":"AB102-AD102-AE102-AG102+AH102","v":2750}]
[54,null,null,"ARQUIETA GONZALEZ IRENE MAGALI",null,null,null,"ENCARGADO DEL DEPTO DE ADQUISICIONES",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"7195/30","v":239.83333333333334},{"$f":"TRUNC(U103*P103,2)","v":3597.5},{"$f":"TRUNC(U103*P103*0.04,2)","v":143.9},{"$f":"TRUNC(U103*0.07*P103,2)","v":251.82},{"$f":"S103","v":0},{"$f":"TRUNC(X103+W103+(IF(Y103>519,519,Y103))+IF(R103=0,0,R103*U103),2)","v":395.72},{"$f":"TRUNC((IF(R103=0,P103*U103,(P103-R103)*U103))+(IF(Y103<519,0,Y103-519)),2)+T103","v":3597.5},{"$f":"Z103+AA103","v":3993.2200000000003},null,null,0,{"$f":"IF(U103>0.01,(AA103-VLOOKUP(AA103,quincenal,1))*VLOOKUP(AA103,quincenal,3)+VLOOKUP(AA103,quincenal,2)-VLOOKUP(AA103,subquincenal,2),0)","v":179.92491199999998},{"$f":"TRUNC(IF(AF103>0.01,AF103,0),2)","v":179.92},{"$f":"TRUNC(IF(AF103<0.01,-AF103,0),2)","v":0},{"$f":"AB103-AD103-AE103-AG103+AH103","v":3813.3},null,65]
[55,null,null,"GOMEZ ESQUIVEL JULIO ISRAEL",null,null,null,"CAPTURISTA EN TESORERIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(U104*P104,2)","v":2747.28},{"$f":"TRUNC(U104*P104*0.04,2)","v":109.89},{"$f":"TRUNC(U104*0.07*P104,2)","v":192.3},{"$f":"S104","v":0},{"$f":"TRUNC(X104+W104+(IF(Y104>519,519,Y104))+IF(R104=0,0,R104*U104),2)","v":302.19},{"$f":"TRUNC((IF(R104=0,P104*U104,(P104-R104)*U104))+(IF(Y104<519,0,Y104-519)),2)+T104","v":2747.28},{"$f":"Z104+AA104","v":3049.4700000000003},null,500,0,{"$f":"IF(U104>0.01,(AA104-VLOOKUP(AA104,quincenal,1))*VLOOKUP(AA104,quincenal,3)+VLOOKUP(AA104,quincenal,2)-VLOOKUP(AA104,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(AF104>0.01,AF104,0),2)","v":49.47},{"$f":"TRUNC(IF(AF104<0.01,-AF104,0),2)","v":0},{"$f":"AB104-AD104-AE104-AG104+AH104","v":2500.0000000000005},null,66]
[56,null,null,"GALLEGOS PEREZ JOSE FRANCISCO",null,null,null,"AUXILIAR CONTABLE",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,183.15199999999999,2747.28,109.89,192.3,0,302.19,2747.28,3049.4700000000003,null,500,0,{"$f":"IF(U105>0.01,(AA105-VLOOKUP(AA105,quincenal,1))*VLOOKUP(AA105,quincenal,3)+VLOOKUP(AA105,quincenal,2)-VLOOKUP(AA105,subquincenal,2),0)","v":49.470976000000007},49.47,0,2500.0000000000005]
[57,null,null,"MARTINEZ PAREDES ANNA VERONICA","MAPA820618","MAPA820618MJCRRN00","2007-01-31","AUXILIAR CONTABLE",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9761/30","v":325.36666666666667},{"$f":"TRUNC(U106*P106,2)","v":4880.5},{"$f":"TRUNC(U106*P106*0.04,2)","v":195.22},{"$f":"TRUNC(U106*0.07*P106,2)","v":341.63},{"$f":"S106","v":0},{"$f":"TRUNC(X106+W106+(IF(Y106>519,519,Y106))+IF(R106=0,0,R106*U106),2)","v":536.85},{"$f":"TRUNC((IF(R106=0,P106*U106,(P106-R106)*U106))+(IF(Y106<519,0,Y106-519)),2)+T106","v":4880.5},{"$f":"Z106+AA106","v":5417.35},null,null,0,{"$f":"IF(U106>0.01,(AA106-VLOOKUP(AA106,quincenal,1))*VLOOKUP(AA106,quincenal,3)+VLOOKUP(AA106,quincenal,2)-VLOOKUP(AA106,subquincenal,2),0)","v":502.09108800000007},{"$f":"TRUNC(IF(AF106>0.01,AF106,0),2)","v":502.09},{"$f":"TRUNC(IF(AF106<0.01,-AF106,0),2)","v":0},{"$f":"AB106-AD106-AE106-AG106+AH106","v":4915.26},null,67]
[null,null,null,"ADMIN ISTRACION DE LA HACIENDA MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V100:V106)","v":30550.149999999998},{"$f":"SUM(W100:W106)","v":1222},2138.48,0,3360.48,30550.149999999998,33910.630000000005,0,1000,0,2702.9443040000006,2702.93,0,30207.699999999997]
[]
[null,null,null,"DEPARTAMENTO DE INGRESOS"]
[{"$f":"A106+1","v":58},"11","17","ARIAS RAMOS MARIA DEL SOCORRO","AIRS650514","AIRS650514MJCRMC06",null,"CAJERA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6714/30","v":223.8},{"$f":"TRUNC(U110*P110,2)","v":3357},{"$f":"TRUNC(U110*P110*0.04,2)","v":134.28},{"$f":"TRUNC(U110*0.07*P110,2)","v":234.99},{"$f":"S110","v":0},{"$f":"TRUNC(X110+W110+(IF(Y110>519,519,Y110))+IF(R110=0,0,R110*U110),2)","v":369.27},{"$f":"TRUNC((IF(R110=0,P110*U110,(P110-R110)*U110))+(IF(Y110<519,0,Y110-519)),2)+T110","v":3357},{"$f":"Z110+AA110","v":3726.27},null,null,0,{"$f":"IF(U110>0.01,(AA110-VLOOKUP(AA110,quincenal,1))*VLOOKUP(AA110,quincenal,3)+VLOOKUP(AA110,quincenal,2)-VLOOKUP(AA110,subquincenal,2),0)","v":136.05851199999998},{"$f":"TRUNC(IF(AF110>0.01,AF110,0),2)","v":136.05000000000001},{"$f":"TRUNC(IF(AF110<0.01,-AF110,0),2)","v":0},{"$f":"AB110-AD110-AE110-AG110+AH110","v":3590.22},null,68]
[{"$f":"A110+1","v":59},null,null,"CABRALES GONZALEZ JOSE MANUEL","CAGM680912","CAGM680912HJCBNN06","2007-01-01","RECAUDADOR DE PISO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6273/30","v":209.1},{"$f":"TRUNC(U111*P111,2)","v":3136.5},{"$f":"TRUNC(U111*P111*0.04,2)","v":125.46},{"$f":"TRUNC(U111*0.07*P111,2)","v":219.55},{"$f":"S111","v":0},{"$f":"TRUNC(X111+W111+(IF(Y111>519,519,Y111))+IF(R111=0,0,R111*U111),2)","v":345.01},{"$f":"TRUNC((IF(R111=0,P111*U111,(P111-R111)*U111))+(IF(Y111<519,0,Y111-519)),2)+T111","v":3136.5},{"$f":"Z111+AA111","v":3481.51},null,null,0,{"$f":"IF(U111>0.01,(AA111-VLOOKUP(AA111,quincenal,1))*VLOOKUP(AA111,quincenal,3)+VLOOKUP(AA111,quincenal,2)-VLOOKUP(AA111,subquincenal,2),0)","v":112.06811199999999},{"$f":"TRUNC(IF(AF111>0.01,AF111,0),2)","v":112.06},{"$f":"TRUNC(IF(AF111<0.01,-AF111,0),2)","v":0},{"$f":"AB111-AD111-AE111-AG111+AH111","v":3369.4500000000003},null,69]
[{"$f":"A111+1","v":60},null,null,"BERNAL RUIZ LAURO",null,null,null,"NOTIFICADOR",null,null,null,null,null,null,null,15,null,null,null,null,{"$f":"6338/30","v":211.26666666666668},{"$f":"TRUNC(U112*P112,2)","v":3169},{"$f":"TRUNC(U112*P112*0.04,2)","v":126.76},{"$f":"TRUNC(U112*0.07*P112,2)","v":221.83},{"$f":"S112","v":0},{"$f":"TRUNC(X112+W112+(IF(Y112>519,519,Y112))+IF(R112=0,0,R112*U112),2)","v":348.59},{"$f":"TRUNC((IF(R112=0,P112*U112,(P112-R112)*U112))+(IF(Y112<519,0,Y112-519)),2)+T112","v":3169},{"$f":"Z112+AA112","v":3517.59},null,null,0,{"$f":"IF(U112>0.01,(AA112-VLOOKUP(AA112,quincenal,1))*VLOOKUP(AA112,quincenal,3)+VLOOKUP(AA112,quincenal,2)-VLOOKUP(AA112,subquincenal,2),0)","v":115.60411199999996},{"$f":"TRUNC(IF(AF112>0.01,AF112,0),2)","v":115.6},{"$f":"TRUNC(IF(AF112<0.01,-AF112,0),2)","v":0},{"$f":"AB112-AD112-AE112-AG112+AH112","v":3401.9900000000002},null,70]
[null,null,null,"DEPARTAMENTO DE INGRESOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V110:V112)","v":9662.5},{"$f":"SUM(W110:W112)","v":386.5},676.37,0,1062.8699999999999,9662.5,10725.37,0,0,0,363.73073599999992,363.71000000000004,0,10361.66]
[]
[null,null,null,"INSTITUTO DE LA MUJER"]
[{"$f":"A112+1","v":61},"3","7","MEDINA FLORES MIRIAM CONCEPCION","LEGJ",null,null,"ENCARGADA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6795/30","v":226.5},{"$f":"TRUNC(U116*P116,2)","v":3397.5},{"$f":"TRUNC(U116*P116*0.04,2)","v":135.9},{"$f":"TRUNC(U116*0.07*P116,2)","v":237.82},{"$f":"S116","v":0},{"$f":"TRUNC(X116+W116+(IF(Y116>519,519,Y116))+IF(R116=0,0,R116*U116),2)","v":373.72},{"$f":"TRUNC((IF(R116=0,P116*U116,(P116-R116)*U116))+(IF(Y116<519,0,Y116-519)),2)+T116","v":3397.5},{"$f":"Z116+AA116","v":3771.2200000000003},null,null,0,{"$f":"IF(U116>0.01,(AA116-VLOOKUP(AA116,quincenal,1))*VLOOKUP(AA116,quincenal,3)+VLOOKUP(AA116,quincenal,2)-VLOOKUP(AA116,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF116>0.01,AF116,0),2)","v":140.46},{"$f":"TRUNC(IF(AF116<0.01,-AF116,0),2)","v":0},{"$f":"AB116-AD116-AE116-AG116+AH116","v":3630.76},null,72]
[null,null,null,"DEPARTAMENTO DE EGRESOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V116)","v":3397.5},{"$f":"SUM(W116)","v":135.9},237.82,0,373.72,3397.5,3771.2200000000003,0,0,0,140.464912,140.46,0,3630.76]
[]
[null,null,null,"DEPARTAMENTO DE  INFORMATICA"]
[{"$f":"A116+1","v":62},"3","12","ILLAN ARIAS CESAR","DIME",null,null,"DIRECTOR DE IDE SISTEMAS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8121/30","v":270.7},{"$f":"TRUNC(U120*P120,2)","v":4060.5},{"$f":"TRUNC(U120*P120*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U120*0.07*P120,2)","v":284.23},{"$f":"S120","v":0},{"$f":"TRUNC(X120+W120+(IF(Y120>519,519,Y120))+IF(R120=0,0,R120*U120),2)","v":446.65},{"$f":"TRUNC((IF(R120=0,P120*U120,(P120-R120)*U120))+(IF(Y120<519,0,Y120-519)),2)+T120","v":4060.5},{"$f":"Z120+AA120","v":4507.1499999999996},null,0,0,{"$f":"IF(U120>0.01,(AA120-VLOOKUP(AA120,quincenal,1))*VLOOKUP(AA120,quincenal,3)+VLOOKUP(AA120,quincenal,2)-VLOOKUP(AA120,subquincenal,2),0)","v":358.76839999999999},{"$f":"TRUNC(IF(AF120>0.01,AF120,0),2)","v":358.76},{"$f":"TRUNC(IF(AF120<0.01,-AF120,0),2)","v":0},{"$f":"AB120-AD120-AE120-AG120+AH120","v":4148.3899999999994},null,73]
[{"$f":"A120+1","v":63},null,null,"BERNAL ESTRADA EDGAR FERNANDO",null,null,null,"DIRECTOR DE IDE INFORMATICA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4615/30","v":153.83333333333334},{"$f":"TRUNC(U121*P121,2)","v":2307.5},{"$f":"TRUNC(U121*P121*0.04,2)","v":92.3},{"$f":"TRUNC(U121*0.07*P121,2)","v":161.52000000000001},{"$f":"S121","v":0},{"$f":"TRUNC(X121+W121+(IF(Y121>519,519,Y121))+IF(R121=0,0,R121*U121),2)","v":253.82},{"$f":"TRUNC((IF(R121=0,P121*U121,(P121-R121)*U121))+(IF(Y121<519,0,Y121-519)),2)+T121","v":2307.5},{"$f":"Z121+AA121","v":2561.3200000000002},null,0,null,{"$f":"IF(U121>0.01,(AA121-VLOOKUP(AA121,quincenal,1))*VLOOKUP(AA121,quincenal,3)+VLOOKUP(AA121,quincenal,2)-VLOOKUP(AA121,subquincenal,2),0)","v":-27.77708800000002},{"$f":"TRUNC(IF(AF121>0.01,AF121,0),2)","v":0},{"$f":"TRUNC(IF(AF121<0.01,-AF121,0),2)","v":27.77},{"$f":"AB121-AD121-AE121-AG121+AH121","v":2589.09},null,74]
[null,null,null,"DEPARTAMENTO DE COMPUTO E INFORMATICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V120:V121)","v":6368},{"$f":"SUM(W120:W121)","v":254.71999999999997},445.75,0,700.47,6368,7068.4699999999993,0,0,0,330.99131199999999,358.76,27.77,6737.48]
[]
[null,null,null,"DEPARTAMENTO DE IMPUESTO PREDIAL Y CATASTRO"]
[{"$f":"A121+1","v":64},null,null,"ROBLES VENEGAS OSCAR HUMBERTO",null,null,null,"DIRECTOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U125*P125,2)","v":6326.5},{"$f":"TRUNC(U125*P125*0.04,2)","v":253.06},{"$f":"TRUNC(U125*0.07*P125,2)","v":442.85},{"$f":"S125","v":0},{"$f":"TRUNC(X125+W125+(IF(Y125>519,519,Y125))+IF(R125=0,0,R125*U125),2)","v":695.91},{"$f":"TRUNC((IF(R125=0,P125*U125,(P125-R125)*U125))+(IF(Y125<519,0,Y125-519)),2)+T125","v":6326.5},{"$f":"Z125+AA125","v":7022.41},null,0,0,{"$f":"IF(U125>0.01,(AA125-VLOOKUP(AA125,quincenal,1))*VLOOKUP(AA125,quincenal,3)+VLOOKUP(AA125,quincenal,2)-VLOOKUP(AA125,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF125>0.01,AF125,0),2)","v":804.15},{"$f":"TRUNC(IF(AF125<0.01,-AF125,0),2)","v":0},{"$f":"AB125-AD125-AE125-AG125+AH125","v":6218.26},null,75]
[{"$f":"A125+1","v":65},"3","13","CASTELLANOS LOPEZ FRANCISCO JAVIER","CAPB801105","CAPB801105MJCMRR06","2007-01-01","SUB-DIRECTOR DE CATASTRO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8551/30","v":285.03333333333336},{"$f":"TRUNC(U126*P126,2)","v":4275.5},{"$f":"TRUNC(U126*P126*0.04,2)","v":171.02},{"$f":"TRUNC(U126*0.07*P126,2)","v":299.27999999999997},{"$f":"S126","v":0},{"$f":"TRUNC(X126+W126+(IF(Y126>519,519,Y126))+IF(R126=0,0,R126*U126),2)","v":470.3},{"$f":"TRUNC((IF(R126=0,P126*U126,(P126-R126)*U126))+(IF(Y126<519,0,Y126-519)),2)+T126","v":4275.5},{"$f":"Z126+AA126","v":4745.8},null,null,0,{"$f":"IF(U126>0.01,(AA126-VLOOKUP(AA126,quincenal,1))*VLOOKUP(AA126,quincenal,3)+VLOOKUP(AA126,quincenal,2)-VLOOKUP(AA126,subquincenal,2),0)","v":393.67508800000007},{"$f":"TRUNC(IF(AF126>0.01,AF126,0),2)","v":393.67},{"$f":"TRUNC(IF(AF126<0.01,-AF126,0),2)","v":0},{"$f":"AB126-AD126-AE126-AG126+AH126","v":4352.13},null,76]
[{"$f":"A126+1","v":66},null,null,"GARCIA LOPEZ MARIA ESMERALDA","HEBC",null,null,"SECRETARIA EN CATASTRO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4598/30","v":153.26666666666668},2299,91.96,160.93,0,252.89,2299,2551.89,null,null,null,{"$f":"IF(U127>0.01,(AA127-VLOOKUP(AA127,quincenal,1))*VLOOKUP(AA127,quincenal,3)+VLOOKUP(AA127,quincenal,2)-VLOOKUP(AA127,subquincenal,2),0)","v":-28.701888000000025},{"$f":"TRUNC(IF(AF127>0.01,AF127,0),2)","v":0},{"$f":"TRUNC(IF(AF127<0.01,-AF127,0),2)","v":28.7},2580.5899999999997,null,77]
[67,null,null,"ORTEGA CRUZ ERIKA NARCEDALIA",null,null,null,"SECRETARIA EN CATASTRO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4598/30","v":153.26666666666668},{"$f":"TRUNC(U128*P128,2)","v":2299},{"$f":"TRUNC(U128*P128*0.04,2)","v":91.96},{"$f":"TRUNC(U128*0.07*P128,2)","v":160.93},{"$f":"S128","v":0},{"$f":"TRUNC(X128+W128+(IF(Y128>519,519,Y128))+IF(R128=0,0,R128*U128),2)","v":252.89},{"$f":"TRUNC((IF(R128=0,P128*U128,(P128-R128)*U128))+(IF(Y128<519,0,Y128-519)),2)+T128","v":2299},{"$f":"Z128+AA128","v":2551.89},null,null,0,{"$f":"IF(U128>0.01,(AA128-VLOOKUP(AA128,quincenal,1))*VLOOKUP(AA128,quincenal,3)+VLOOKUP(AA128,quincenal,2)-VLOOKUP(AA128,subquincenal,2),0)","v":-28.701888000000025},{"$f":"TRUNC(IF(AF128>0.01,AF128,0),2)","v":0},{"$f":"TRUNC(IF(AF128<0.01,-AF128,0),2)","v":28.7},{"$f":"AB128-AD128-AE128-AG128+AH128","v":2580.5899999999997},null,78]
[null,null,null,"DEPARTAMENTO DE IMPUESTO PREDIAL Y CATASTRO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V125:V128)","v":15200},{"$f":"SUM(W125:W128)","v":608.00000000000011},1063.99,0,1671.9899999999998,15200,16871.989999999998,0,0,0,1140.422536,1197.82,57.4,15731.57]
[]
[null,null,null,"ADMINISTRACION DE LOS SERVICIOS PUBLICOS MUNICIPALES"]
[{"$f":"A128+1","v":68},null,null,"MARISCAL MORALES JESUS RICARDO","HEAM740507","HEAM740507HJCRGN04","2008-05-01","DIRECTOR DE SERVICIOS ´PÚBLICOS  MUNICIPALES",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"15321/30","v":510.7},{"$f":"TRUNC(U132*P132,2)","v":7660.5},{"$f":"TRUNC(U132*P132*0.04,2)","v":306.42},{"$f":"TRUNC(U132*0.07*P132,2)","v":536.23},{"$f":"S132","v":0},{"$f":"TRUNC(X132+W132+(IF(Y132>519,519,Y132))+IF(R132=0,0,R132*U132),2)","v":842.65},{"$f":"TRUNC((IF(R132=0,P132*U132,(P132-R132)*U132))+(IF(Y132<519,0,Y132-519)),2)+T132","v":7660.5},{"$f":"Z132+AA132","v":8503.15},null,0,0,{"$f":"IF(U132>0.01,(AA132-VLOOKUP(AA132,quincenal,1))*VLOOKUP(AA132,quincenal,3)+VLOOKUP(AA132,quincenal,2)-VLOOKUP(AA132,subquincenal,2),0)","v":1089.0936240000001},{"$f":"TRUNC(IF(AF132>0.01,AF132,0),2)","v":1089.0899999999999},{"$f":"TRUNC(IF(AF132<0.01,-AF132,0),2)","v":0},{"$f":"AB132-AD132-AE132-AG132+AH132","v":7414.0599999999995},null,79]
[{"$f":"A132+1","v":69},null,null,"CERVANTES VELAZCO ISAIAS","IAOR",null,null,"ENCARGADO DE MANTENIMIENTO A VEHICULOS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9223/30","v":307.43333333333334},{"$f":"TRUNC(U133*P133,2)","v":4611.5},{"$f":"TRUNC(U133*P133*0.04,2)","v":184.46},{"$f":"TRUNC(U133*0.07*P133,2)","v":322.8},{"$f":"S133","v":0},{"$f":"TRUNC(X133+W133+(IF(Y133>519,519,Y133))+IF(R133=0,0,R133*U133),2)","v":507.26},{"$f":"TRUNC((IF(R133=0,P133*U133,(P133-R133)*U133))+(IF(Y133<519,0,Y133-519)),2)+T133","v":4611.5},{"$f":"Z133+AA133","v":5118.76},null,0,0,{"$f":"IF(U133>0.01,(AA133-VLOOKUP(AA133,quincenal,1))*VLOOKUP(AA133,quincenal,3)+VLOOKUP(AA133,quincenal,2)-VLOOKUP(AA133,subquincenal,2),0)","v":453.88628800000004},{"$f":"TRUNC(IF(AF133>0.01,AF133,0),2)","v":453.88},{"$f":"TRUNC(IF(AF133<0.01,-AF133,0),2)","v":0},{"$f":"AB133-AD133-AE133-AG133+AH133","v":4664.88},null,80]
[{"$f":"A133+1","v":70},null,null,"HERNANDEZ AGUIRRE JOSE MANUEL",null,null,null,"OPERADOR DE MAQUINARIA",null,null,null,null,null,null,null,15,null,null,null,null,{"$f":"7130/30","v":237.66666666666666},{"$f":"TRUNC(U134*P134,2)","v":3565},{"$f":"TRUNC(U134*P134*0.04,2)","v":142.6},{"$f":"TRUNC(U134*0.07*P134,2)","v":249.55},{"$f":"S134","v":0},{"$f":"TRUNC(X134+W134+(IF(Y134>519,519,Y134))+IF(R134=0,0,R134*U134),2)","v":392.15},{"$f":"TRUNC((IF(R134=0,P134*U134,(P134-R134)*U134))+(IF(Y134<519,0,Y134-519)),2)+T134","v":3565},{"$f":"Z134+AA134","v":3957.15},null,500,0,{"$f":"IF(U134>0.01,(AA134-VLOOKUP(AA134,quincenal,1))*VLOOKUP(AA134,quincenal,3)+VLOOKUP(AA134,quincenal,2)-VLOOKUP(AA134,subquincenal,2),0)","v":176.38891199999998},{"$f":"TRUNC(IF(AF134>0.01,AF134,0),2)","v":176.38},{"$f":"TRUNC(IF(AF134<0.01,-AF134,0),2)","v":0},{"$f":"AB134-AD134-AE134-AG134+AH134","v":3280.77},null,81]
[71,null,null,"ACEVEDO OCHOA J. GUADALUPE",null,null,null,"ALMACENISTA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U135*P135,2)","v":2857},{"$f":"TRUNC(U135*P135*0.04,2)","v":114.28},{"$f":"TRUNC(U135*0.07*P135,2)","v":199.99},{"$f":"S135","v":0},{"$f":"TRUNC(X135+W135+(IF(Y135>519,519,Y135))+IF(R135=0,0,R135*U135),2)","v":314.27},{"$f":"TRUNC((IF(R135=0,P135*U135,(P135-R135)*U135))+(IF(Y135<519,0,Y135-519)),2)+T135","v":2857},{"$f":"Z135+AA135","v":3171.27},null,null,0,{"$f":"IF(U135>0.01,(AA135-VLOOKUP(AA135,quincenal,1))*VLOOKUP(AA135,quincenal,3)+VLOOKUP(AA135,quincenal,2)-VLOOKUP(AA135,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF135>0.01,AF135,0),2)","v":61.4},{"$f":"TRUNC(IF(AF135<0.01,-AF135,0),2)","v":0},{"$f":"AB135-AD135-AE135-AG135+AH135","v":3109.87},null,94]
[72,null,null,"ARQUIETA VADILLO ARTURO","AUVA551030FJ0","AUVA551030HJCRDR15",null,"PINTOR GENERAL",null,null,null,null,null,null,null,15,"SOBRE",null,0,0,{"$f":"9416/30","v":313.86666666666667},{"$f":"TRUNC(U136*P136,2)","v":4708},{"$f":"TRUNC(U136*P136*0.04,2)","v":188.32},{"$f":"TRUNC(U136*0.07*P136,2)","v":329.56},{"$f":"S136","v":0},{"$f":"TRUNC(X136+W136+(IF(Y136>519,519,Y136))+IF(R136=0,0,R136*U136),2)","v":517.88},{"$f":"TRUNC((IF(R136=0,P136*U136,(P136-R136)*U136))+(IF(Y136<519,0,Y136-519)),2)+T136","v":4708},{"$f":"Z136+AA136","v":5225.88},null,0,null,{"$f":"IF(U136>0.01,(AA136-VLOOKUP(AA136,quincenal,1))*VLOOKUP(AA136,quincenal,3)+VLOOKUP(AA136,quincenal,2)-VLOOKUP(AA136,subquincenal,2),0)","v":471.17908800000009},{"$f":"TRUNC(IF(AF136>0.01,AF136,0),2)","v":471.17},{"$f":"TRUNC(IF(AF136<0.01,-AF136,0),2)","v":0},{"$f":"AB136-AD136-AE136-AG136+AH136","v":4754.71},null,96]
[null,null,null,"ADMINISTRACION DE LOS SERVICIOS PUBLICOS MUNICIPALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V132:V136)","v":23402},{"$f":"SUM(W132:W136)","v":936.07999999999993},1638.1299999999999,0,2574.21,23402,25976.210000000003,0,500,0,2251.956424,2251.92,0,23224.289999999997]
[null,null,null,"DIRECCION GENERAL  DE OBRAS PUBLICAS"]
[{"$f":"A136+1","v":73},"4","1","DAVALOS SALCEDO MIGUEL CARLOS",null,null,null,"DIRECTOR DE OBRAS PÚBLICAS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"14973/30","v":499.1},{"$f":"TRUNC(U139*P139,2)","v":7486.5},{"$f":"TRUNC(U139*P139*0.04,2)","v":299.45999999999998},{"$f":"TRUNC(U139*0.07*P139,2)","v":524.04999999999995},{"$f":"S139","v":0},{"$f":"TRUNC(X139+W139+(IF(Y139>519,519,Y139))+IF(R139=0,0,R139*U139),2)","v":823.51},{"$f":"TRUNC((IF(R139=0,P139*U139,(P139-R139)*U139))+(IF(Y139<519,0,Y139-519)),2)+T139","v":7486.5},{"$f":"Z139+AA139","v":8310.01},null,0,0,{"$f":"IF(U139>0.01,(AA139-VLOOKUP(AA139,quincenal,1))*VLOOKUP(AA139,quincenal,3)+VLOOKUP(AA139,quincenal,2)-VLOOKUP(AA139,subquincenal,2),0)","v":1051.927224},{"$f":"TRUNC(IF(AF139>0.01,AF139,0),2)","v":1051.92},{"$f":"TRUNC(IF(AF139<0.01,-AF139,0),2)","v":0},{"$f":"AB139-AD139-AE139-AG139+AH139","v":7258.09},null,97]
[{"$f":"A139+1","v":74},null,null,"GUTIERREZ MARTINEZ JORGE",null,null,null,"SUB DIRECTOR DE OBRAS PÚBLICAS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"10341/30","v":344.7},{"$f":"TRUNC(U140*P140,2)","v":5170.5},{"$f":"TRUNC(U140*P140*0.04,2)","v":206.82},{"$f":"TRUNC(U140*0.07*P140,2)","v":361.93},{"$f":"S140","v":0},{"$f":"TRUNC(X140+W140+(IF(Y140>519,519,Y140))+IF(R140=0,0,R140*U140),2)","v":568.75},{"$f":"TRUNC((IF(R140=0,P140*U140,(P140-R140)*U140))+(IF(Y140<519,0,Y140-519)),2)+T140","v":5170.5},{"$f":"Z140+AA140","v":5739.25},null,null,0,{"$f":"IF(U140>0.01,(AA140-VLOOKUP(AA140,quincenal,1))*VLOOKUP(AA140,quincenal,3)+VLOOKUP(AA140,quincenal,2)-VLOOKUP(AA140,subquincenal,2),0)","v":557.22962400000006},{"$f":"TRUNC(IF(AF140>0.01,AF140,0),2)","v":557.22},{"$f":"TRUNC(IF(AF140<0.01,-AF140,0),2)","v":0},{"$f":"AB140-AD140-AE140-AG140+AH140","v":5182.03},null,98]
[{"$f":"A140+1","v":75},null,null,"FLORES IÑIGUEZ JUAN RAYMUNDO","FOIJ8508313Z1","FOIJ850831HJCLXN07","2007-01-01","SUB-DIRECTOR DESARROLLO URBANO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"7781/30","v":259.36666666666667},3890.5,155.62,272.33,0,427.95,3890.5,4318.45,null,null,0,{"$f":"IF(U141>0.01,(AA141-VLOOKUP(AA141,quincenal,1))*VLOOKUP(AA141,quincenal,3)+VLOOKUP(AA141,quincenal,2)-VLOOKUP(AA141,subquincenal,2),0)","v":331.5684},331.56,0,3986.89,null,99]
[76,null,null,"RENTERIA MENDEZ FRANCISCO","REMF850816I26","REMF850816HJCNNR00","2008-03-05","AUXILIAR DE DIRECCIÓN",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9121/30","v":304.03333333333336},4560.5,182.42,319.23,0,501.65,4560.5,5062.1499999999996,null,null,0,444.74708800000008,444.74,0,4617.41,null,100]
[null,null,null,{"$f":"D138","v":"DIRECCION GENERAL  DE OBRAS PUBLICAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V139:V142)","v":21108},{"$f":"SUM(W139:W142)","v":844.31999999999994},1477.54,0,2321.86,21108,23429.86,0,0,0,2385.4723360000003,2385.44,0,21044.42]
[]
[null,null,null,"DEPARTAMENTO DE CEMENTERIOS"]
[{"$f":"A142+1","v":77},null,null,"ILLAN RUIZ FERNANDO","RIOA520619","RIOA520619HJCVRD05",null,"ADMINISTRADOR DE CEMENTERIOS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6795/30","v":226.5},{"$f":"TRUNC(U146*P146,2)","v":3397.5},{"$f":"TRUNC(U146*P146*0.04,2)","v":135.9},{"$f":"TRUNC(U146*0.07*P146,2)","v":237.82},{"$f":"S146","v":0},{"$f":"TRUNC(X146+W146+(IF(Y146>519,519,Y146))+IF(R146=0,0,R146*U146),2)","v":373.72},{"$f":"TRUNC((IF(R146=0,P146*U146,(P146-R146)*U146))+(IF(Y146<519,0,Y146-519)),2)+T146","v":3397.5},{"$f":"Z146+AA146","v":3771.2200000000003},null,null,0,{"$f":"IF(U146>0.01,(AA146-VLOOKUP(AA146,quincenal,1))*VLOOKUP(AA146,quincenal,3)+VLOOKUP(AA146,quincenal,2)-VLOOKUP(AA146,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF146>0.01,AF146,0),2)","v":140.46},{"$f":"TRUNC(IF(AF146<0.01,-AF146,0),2)","v":0},{"$f":"AB146-AD146-AE146-AG146+AH146","v":3630.76},null,103]
[null,null,null,"DEPARTAMENTO DE CEMENTERIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V146:V146)","v":3397.5},{"$f":"SUM(W146:W146)","v":135.9},237.82,0,373.72,3397.5,3771.2200000000003,0,0,0,140.464912,140.46,0,3630.76]
[]
[null,null,null,"DEPARTAMENTO DE RASTRO"]
[{"$f":"A146+1","v":78},null,null,"LOPEZ VILLEGAS J. JESUS","LOVJ470602UN7","LOVJ470602HJCPLS07",null,"GUARDA RASTRO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4923/30","v":164.1},{"$f":"TRUNC(U150*P150,2)","v":2461.5},{"$f":"TRUNC(U150*P150*0.04,2)","v":98.46},{"$f":"TRUNC(U150*0.07*P150,2)","v":172.3},{"$f":"S150","v":0},{"$f":"TRUNC(X150+W150+(IF(Y150>519,519,Y150))+IF(R150=0,0,R150*U150),2)","v":270.76},{"$f":"TRUNC((IF(R150=0,P150*U150,(P150-R150)*U150))+(IF(Y150<519,0,Y150-519)),2)+T150","v":2461.5},{"$f":"Z150+AA150","v":2732.26},null,null,0,{"$f":"IF(U150>0.01,(AA150-VLOOKUP(AA150,quincenal,1))*VLOOKUP(AA150,quincenal,3)+VLOOKUP(AA150,quincenal,2)-VLOOKUP(AA150,subquincenal,2),0)","v":3.3781119999999873},{"$f":"TRUNC(IF(AF150>0.01,AF150,0),2)","v":3.37},{"$f":"TRUNC(IF(AF150<0.01,-AF150,0),2)","v":0},{"$f":"AB150-AD150-AE150-AG150+AH150","v":2728.8900000000003},null,107]
[{"$f":"A150+1","v":79},null,null,"FREGOSO BARBOZA CARLOS RAFAEL","PARR",null,null,"VETERINARIO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"7632/30","v":254.4},{"$f":"TRUNC(U151*P151,2)","v":3816},{"$f":"TRUNC(U151*P151*0.04,2)","v":152.63999999999999},{"$f":"TRUNC(U151*0.07*P151,2)","v":267.12},{"$f":"S151","v":0},{"$f":"TRUNC(X151+W151+(IF(Y151>519,519,Y151))+IF(R151=0,0,R151*U151),2)","v":419.76},{"$f":"TRUNC((IF(R151=0,P151*U151,(P151-R151)*U151))+(IF(Y151<519,0,Y151-519)),2)+T151","v":3816},{"$f":"Z151+AA151","v":4235.76},null,0,0,{"$f":"IF(U151>0.01,(AA151-VLOOKUP(AA151,quincenal,1))*VLOOKUP(AA151,quincenal,3)+VLOOKUP(AA151,quincenal,2)-VLOOKUP(AA151,subquincenal,2),0)","v":319.64839999999998},{"$f":"TRUNC(IF(AF151>0.01,AF151,0),2)","v":319.64},{"$f":"TRUNC(IF(AF151<0.01,-AF151,0),2)","v":0},{"$f":"AB151-AD151-AE151-AG151+AH151","v":3916.1200000000003},null,108]
[null,null,null,"DEPARTAMENTO DE RASTRO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V150:V151)","v":6277.5},{"$f":"SUM(W150:W151)","v":251.09999999999997},439.42,0,690.52,6277.5,6968.02,0,0,0,323.02651199999997,323.01,0,6645.01,0]
[]
[]
[null,null,null,"DEPARTAMENTO DE ASEO PUBLICO"]
[{"$f":"A151+1","v":80},"5","7","NAVARRO HERNANDEZ SOSTENES","HUAB811011","HUAB810114HJCRGR01","2007-02-01","SUPERVISOR DE ASEO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,224.452,{"$f":"TRUNC(U156*P156,2)","v":3366.78},{"$f":"TRUNC(U156*P156*0.04,2)","v":134.66999999999999},{"$f":"TRUNC(U156*0.07*P156,2)","v":235.67},{"$f":"S156","v":0},{"$f":"TRUNC(X156+W156+(IF(Y156>519,519,Y156))+IF(R156=0,0,R156*U156),2)","v":370.34},{"$f":"TRUNC((IF(R156=0,P156*U156,(P156-R156)*U156))+(IF(Y156<519,0,Y156-519)),2)+T156","v":3366.78},{"$f":"Z156+AA156","v":3737.1200000000003},null,null,0,{"$f":"IF(U156>0.01,(AA156-VLOOKUP(AA156,quincenal,1))*VLOOKUP(AA156,quincenal,3)+VLOOKUP(AA156,quincenal,2)-VLOOKUP(AA156,subquincenal,2),0)","v":137.12257600000001},{"$f":"TRUNC(IF(AF156>0.01,AF156,0),2)","v":137.12},{"$f":"TRUNC(IF(AF156<0.01,-AF156,0),2)","v":0},{"$f":"AB156-AD156-AE156-AG156+AH156","v":3600.0000000000005},null,112]
[{"$f":"A156+1","v":81},null,null,"HUERTA AGUILA BERNARDINO","HUAB811011","HUAB810114HJCRGR01","2007-02-01","RECOLECTOR ASEO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4622/30","v":154.06666666666666},{"$f":"TRUNC(U157*P157,2)","v":2311},{"$f":"TRUNC(U157*P157*0.04,2)","v":92.44},{"$f":"TRUNC(U157*0.07*P157,2)","v":161.77000000000001},{"$f":"S157","v":0},{"$f":"TRUNC(X157+W157+(IF(Y157>519,519,Y157))+IF(R157=0,0,R157*U157),2)","v":254.21},{"$f":"TRUNC((IF(R157=0,P157*U157,(P157-R157)*U157))+(IF(Y157<519,0,Y157-519)),2)+T157","v":2311},{"$f":"Z157+AA157","v":2565.21},null,null,0,{"$f":"IF(U157>0.01,(AA157-VLOOKUP(AA157,quincenal,1))*VLOOKUP(AA157,quincenal,3)+VLOOKUP(AA157,quincenal,2)-VLOOKUP(AA157,subquincenal,2),0)","v":-27.396288000000027},{"$f":"TRUNC(IF(AF157>0.01,AF157,0),2)","v":0},{"$f":"TRUNC(IF(AF157<0.01,-AF157,0),2)","v":27.39},{"$f":"AB157-AD157-AE157-AG157+AH157","v":2592.6},null,113]
[{"$f":"A157+1","v":82},null,null,"GRACIA GOMEZ JAVIER","GAGJ731114","GAGJ731114HJCRMV00","2004-01-01","RECOLECTOR ASEO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4622/30","v":154.06666666666666},2311,92.44,161.77000000000001,0,254.21,2311,2565.21,null,null,0,-27.396288000000027,0,27.39,2592.6,null,114]
[{"$f":"A158+1","v":83},null,null,"FREGOZO ALVARADO ALFONSO","FEAA650918","FEAA650818HJCRLL05","2003-01-01","RECOLECTOR ASEO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,154.06666666666666,2311,92.44,161.77000000000001,0,254.21,2311,2565.21,null,null,0,-27.396288000000027,0,27.39,2592.6,null,115]
[84,null,null,"TELLEZ GOMEZ VICENTE",null,null,null,"RECOLECTOR ASEO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,154.06666666666666,2311,92.44,161.77000000000001,{"$f":"S160","v":0},254.21,2311,{"$f":"Z160+AA160","v":2565.21},null,0,0,{"$f":"IF(U160>0.01,(AA160-VLOOKUP(AA160,quincenal,1))*VLOOKUP(AA160,quincenal,3)+VLOOKUP(AA160,quincenal,2)-VLOOKUP(AA160,subquincenal,2),0)","v":-27.396288000000027},0,{"$f":"TRUNC(IF(AF160<0.01,-AF160,0),2)","v":27.39},{"$f":"AB160-AD160-AE160-AG160+AH160","v":2592.6},null,116]
[85,null,null,"CISNEROS VAZQUEZ RAMIRO","CIVR540430","CIVR540430HJCSZM04","2007-01-01","RECOLECTOR ASEO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4622/30","v":154.06666666666666},2311,92.44,161.77000000000001,0,254.21,2311,2565.21,null,null,0,-27.396288000000027,0,27.39,2592.6,null,121]
[null,null,null,"DEPARTAMENTO DE ASEO PUBLICO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V156:V161)","v":14921.78},{"$f":"SUM(W156:W161)","v":596.86999999999989},1044.52,0,1641.39,14921.78,16563.169999999998,0,0,0,0.14113599999987514,137.12,136.94999999999999,16563]
[]
[null,null,null,"DEPARTAMENTO DE PARQUES Y JARDINES"]
[{"$f":"A161+1","v":86},"5","8","NAVARRO HUERTA ISIDRO","HUCR450811","HUCR450831HJCRRM08","2004-01-01","SUPERVISOR DE PARQUES Y JARDINES",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6130/30","v":204.33333333333334},{"$f":"TRUNC(U165*P165,2)","v":3065},{"$f":"TRUNC(U165*P165*0.04,2)","v":122.6},{"$f":"TRUNC(U165*0.07*P165,2)","v":214.55},{"$f":"S165","v":0},{"$f":"TRUNC(X165+W165+(IF(Y165>519,519,Y165))+IF(R165=0,0,R165*U165),2)","v":337.15},{"$f":"TRUNC((IF(R165=0,P165*U165,(P165-R165)*U165))+(IF(Y165<519,0,Y165-519)),2)+T165","v":3065},{"$f":"Z165+AA165","v":3402.15},null,null,0,{"$f":"IF(U165>0.01,(AA165-VLOOKUP(AA165,quincenal,1))*VLOOKUP(AA165,quincenal,3)+VLOOKUP(AA165,quincenal,2)-VLOOKUP(AA165,subquincenal,2),0)","v":84.038911999999982},{"$f":"TRUNC(IF(AF165>0.01,AF165,0),2)","v":84.03},{"$f":"TRUNC(IF(AF165<0.01,-AF165,0),2)","v":0},{"$f":"AB165-AD165-AE165-AG165+AH165","v":3318.12},null,122]
[null,null,null,"VERTEDERO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V165:V165)","v":3065},{"$f":"SUM(W165:W165)","v":122.6},214.55,0,337.15,3065,3402.15,0,0,0,84.038911999999982,84.03,0,3318.12]
[]
[null,null,null,"DEPARTAMENTO DE ALUMBRADO PUBLICO"]
[{"$f":"A165+1","v":87},null,null,"RUIZ HERNANDEZ CELESTINO","RUHC540519","RUHC540519HJCZRL03","2004-01-01","JEFE DE ALUMBRADO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"7130/30","v":237.66666666666666},{"$f":"TRUNC(U169*P169,2)","v":3565},{"$f":"TRUNC(U169*P169*0.04,2)","v":142.6},{"$f":"TRUNC(U169*0.07*P169,2)","v":249.55},{"$f":"S169","v":0},{"$f":"TRUNC(X169+W169+(IF(Y169>519,519,Y169))+IF(R169=0,0,R169*U169),2)","v":392.15},{"$f":"TRUNC((IF(R169=0,P169*U169,(P169-R169)*U169))+(IF(Y169<519,0,Y169-519)),2)+T169","v":3565},{"$f":"Z169+AA169","v":3957.15},null,null,0,{"$f":"IF(U169>0.01,(AA169-VLOOKUP(AA169,quincenal,1))*VLOOKUP(AA169,quincenal,3)+VLOOKUP(AA169,quincenal,2)-VLOOKUP(AA169,subquincenal,2),0)","v":176.38891199999998},{"$f":"TRUNC(IF(AF169>0.01,AF169,0),2)","v":176.38},{"$f":"TRUNC(IF(AF169<0.01,-AF169,0),2)","v":0},{"$f":"AB169-AD169-AE169-AG169+AH169","v":3780.77},null,131]
[{"$f":"A169+1","v":88},null,null,"LARES RODRIGUEZ JOSE ANGEL",null,null,null,"ENCARGADO DE ALUMBRADO PUBLICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6795/30","v":226.5},{"$f":"TRUNC(U170*P170,2)","v":3397.5},{"$f":"TRUNC(U170*P170*0.04,2)","v":135.9},{"$f":"TRUNC(U170*0.07*P170,2)","v":237.82},{"$f":"S170","v":0},{"$f":"TRUNC(X170+W170+(IF(Y170>519,519,Y170))+IF(R170=0,0,R170*U170),2)","v":373.72},{"$f":"TRUNC((IF(R170=0,P170*U170,(P170-R170)*U170))+(IF(Y170<519,0,Y170-519)),2)+T170","v":3397.5},{"$f":"Z170+AA170","v":3771.2200000000003},null,null,0,{"$f":"IF(U170>0.01,(AA170-VLOOKUP(AA170,quincenal,1))*VLOOKUP(AA170,quincenal,3)+VLOOKUP(AA170,quincenal,2)-VLOOKUP(AA170,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF170>0.01,AF170,0),2)","v":140.46},{"$f":"TRUNC(IF(AF170<0.01,-AF170,0),2)","v":0},{"$f":"AB170-AD170-AE170-AG170+AH170","v":3630.76},null,132]
[null,null,null,"DEPARTAMENTO DE ALUMBRADO PUBLICO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V169:V170)","v":6962.5},{"$f":"SUM(W169:W170)","v":278.5},487.37,0,765.87,6962.5,7728.3700000000008,0,0,0,316.85382399999997,316.84000000000003,0,7411.5300000000007]
[]
[]
[null,null,null,"DEPARTAMENTO DE DEPORTES"]
[{"$f":"A170+1","v":89},5,14,"ACOSTA GONZALEZ MIGUEL",null,null,null,"ENCARGADO DE LA UNIDAD DEPORTIVA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4615/30","v":153.83333333333334},{"$f":"TRUNC(U175*P175,2)","v":2307.5},{"$f":"TRUNC(U175*P175*0.04,2)","v":92.3},{"$f":"TRUNC(U175*0.07*P175,2)","v":161.52000000000001},{"$f":"S175","v":0},{"$f":"TRUNC(X175+W175+(IF(Y175>519,519,Y175))+IF(R175=0,0,R175*U175),2)","v":253.82},{"$f":"TRUNC((IF(R175=0,P175*U175,(P175-R175)*U175))+(IF(Y175<519,0,Y175-519)),2)+T175","v":2307.5},{"$f":"Z175+AA175","v":2561.3200000000002},null,0,0,{"$f":"IF(U175>0.01,(AA175-VLOOKUP(AA175,quincenal,1))*VLOOKUP(AA175,quincenal,3)+VLOOKUP(AA175,quincenal,2)-VLOOKUP(AA175,subquincenal,2),0)","v":-27.77708800000002},{"$f":"TRUNC(IF(AF175>0.01,AF175,0),2)","v":0},{"$f":"TRUNC(IF(AF175<0.01,-AF175,0),2)","v":27.77},{"$f":"AB175-AD175-AE175-AG175+AH175","v":2589.09},null,135]
[{"$f":"A175+1","v":90},null,null,"CABRALES MEZA CECILIO","GOES781103IAA","GOES781103MJCDNL05","2009-01-01","VIGILANTE EN EL DOMO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3158/30","v":105.26666666666667},1579,63.16,110.53,0,173.69,1579,1752.69,null,null,0,{"$f":"IF(U176>0.01,(AA176-VLOOKUP(AA176,quincenal,1))*VLOOKUP(AA176,quincenal,3)+VLOOKUP(AA176,quincenal,2)-VLOOKUP(AA176,subquincenal,2),0)","v":-110.66183999999998},{"$f":"TRUNC(IF(AF176>0.01,AF176,0),2)","v":0},110.66,1863.3500000000001,null,141]
[null,null,null,"DEPARTAMENTO DE DEPORTES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V175:V176)","v":3886.5},{"$f":"SUM(W175:W176)","v":155.45999999999998},272.05,0,427.51,3886.5,4314.01,0,0,0,-138.438928,0,138.43,4452.4400000000005]
[]
[null,null,null,"SERVICIOS MEDICOS"]
[{"$f":"A176+1","v":91},null,null,"MARTINEZ VALDIVIA FRANCISCO","MAVF520525","MAVF520525HJCRLR02","2004-01-01","MEDICO MUNICIPAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"7559/30","v":251.96666666666667},{"$f":"TRUNC(U180*P180,2)","v":3779.5},{"$f":"TRUNC(U180*P180*0.04,2)","v":151.18},{"$f":"TRUNC(U180*0.07*P180,2)","v":264.56},{"$f":"S180","v":0},{"$f":"TRUNC(X180+W180+(IF(Y180>519,519,Y180))+IF(R180=0,0,R180*U180),2)","v":415.74},{"$f":"TRUNC((IF(R180=0,P180*U180,(P180-R180)*U180))+(IF(Y180<519,0,Y180-519)),2)+T180","v":3779.5},{"$f":"Z180+AA180","v":4195.24},null,null,0,{"$f":"IF(U180>0.01,(AA180-VLOOKUP(AA180,quincenal,1))*VLOOKUP(AA180,quincenal,3)+VLOOKUP(AA180,quincenal,2)-VLOOKUP(AA180,subquincenal,2),0)","v":313.80839999999995},{"$f":"TRUNC(IF(AF180>0.01,AF180,0),2)","v":313.8},{"$f":"TRUNC(IF(AF180<0.01,-AF180,0),2)","v":0},{"$f":"AB180-AD180-AE180-AG180+AH180","v":3881.4399999999996},null,142]
[{"$f":"A180+1","v":92},null,null,"LEAL FRANCISCO JAVIER","MAVF520525","MAVF520525HJCRLR02","2004-01-01","PEDIATRA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8121/30","v":270.7},{"$f":"TRUNC(U181*P181,2)","v":4060.5},{"$f":"TRUNC(U181*P181*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U181*0.07*P181,2)","v":284.23},{"$f":"S181","v":0},{"$f":"TRUNC(X181+W181+(IF(Y181>519,519,Y181))+IF(R181=0,0,R181*U181),2)","v":446.65},{"$f":"TRUNC((IF(R181=0,P181*U181,(P181-R181)*U181))+(IF(Y181<519,0,Y181-519)),2)+T181","v":4060.5},{"$f":"Z181+AA181","v":4507.1499999999996},null,null,0,{"$f":"IF(U181>0.01,(AA181-VLOOKUP(AA181,quincenal,1))*VLOOKUP(AA181,quincenal,3)+VLOOKUP(AA181,quincenal,2)-VLOOKUP(AA181,subquincenal,2),0)","v":358.76839999999999},{"$f":"TRUNC(IF(AF181>0.01,AF181,0),2)","v":358.76},{"$f":"TRUNC(IF(AF181<0.01,-AF181,0),2)","v":0},{"$f":"AB181-AD181-AE181-AG181+AH181","v":4148.3899999999994},null,143]
[{"$f":"A181+1","v":93},null,null,"ROBLES GONZALEZ CLAUDIA SUSANA","MAVF520525","MAVF520525HJCRLR02","2004-01-01","MEDICO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8121/30","v":270.7},4060.5,162.41999999999999,284.23,0,446.65,4060.5,4507.1499999999996,null,null,0,{"$f":"IF(U182>0.01,(AA182-VLOOKUP(AA182,quincenal,1))*VLOOKUP(AA182,quincenal,3)+VLOOKUP(AA182,quincenal,2)-VLOOKUP(AA182,subquincenal,2),0)","v":358.76839999999999},358.76,0,4148.3899999999994,null,144]
[94,null,null,"ESQUIVEL REYES VICTORIA GUADALUPE",null,null,null,"ENFERMEROA CENTRO DE SALUD SANTA ROSALIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,82.109899999999996,1231.6400000000001,49.26,86.21,0,135.47,1231.6400000000001,1367.1100000000001,null,null,0,{"$f":"IF(U183>0.01,(AA183-VLOOKUP(AA183,quincenal,1))*VLOOKUP(AA183,quincenal,3)+VLOOKUP(AA183,quincenal,2)-VLOOKUP(AA183,subquincenal,2),0)","v":-132.89287999999999},0,132.88999999999999,1500]
[null,null,null,"SERVICIOS MEDICOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V180:V183)","v":13132.14},{"$f":"SUM(W180:W183)","v":525.28},919.23,0,1444.51,13132.14,{"$f":"SUM(AB180:AB183)","v":14576.65},0,0,0,898.45231999999999,1031.32,132.88999999999999,13678.219999999998,{"$f":"SUM(AJ180:AJ182)","v":0}]
[]
[]
[null,null,null,"DEPARTAMENTO DE DESARROLLO RURAL"]
[{"$f":"A183+1","v":95},1,19,"PARRA AGUAYO JORGE","MENV711022","MENV711022HJCNVC07",null,"ENCARGADO DE DESARROLLO RURAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U188*P188,2)","v":6326.5},{"$f":"TRUNC(U188*P188*0.04,2)","v":253.06},{"$f":"TRUNC(U188*0.07*P188,2)","v":442.85},{"$f":"S188","v":0},{"$f":"TRUNC(X188+W188+(IF(Y188>519,519,Y188))+IF(R188=0,0,R188*U188),2)","v":695.91},{"$f":"TRUNC((IF(R188=0,P188*U188,(P188-R188)*U188))+(IF(Y188<519,0,Y188-519)),2)+T188","v":6326.5},{"$f":"Z188+AA188","v":7022.41},null,0,0,{"$f":"IF(U188>0.01,(AA188-VLOOKUP(AA188,quincenal,1))*VLOOKUP(AA188,quincenal,3)+VLOOKUP(AA188,quincenal,2)-VLOOKUP(AA188,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF188>0.01,AF188,0),2)","v":804.15},{"$f":"TRUNC(IF(AF188<0.01,-AF188,0),2)","v":0},{"$f":"AB188-AD188-AE188-AG188+AH188","v":6218.26},null,146]
[{"$f":"A188+1","v":96},null,null,"MONTES COLIMA DIANA ROCIO","PAGO721112","PAGO721112HJCLRS01",null,"AUXILIAR DE DESARROLLO RURAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U189*P189,2)","v":2857},{"$f":"TRUNC(U189*P189*0.04,2)","v":114.28},{"$f":"TRUNC(U189*0.07*P189,2)","v":199.99},{"$f":"S189","v":0},{"$f":"TRUNC(X189+W189+(IF(Y189>519,519,Y189))+IF(R189=0,0,R189*U189),2)","v":314.27},{"$f":"TRUNC((IF(R189=0,P189*U189,(P189-R189)*U189))+(IF(Y189<519,0,Y189-519)),2)+T189","v":2857},{"$f":"Z189+AA189","v":3171.27},null,null,0,{"$f":"IF(U189>0.01,(AA189-VLOOKUP(AA189,quincenal,1))*VLOOKUP(AA189,quincenal,3)+VLOOKUP(AA189,quincenal,2)-VLOOKUP(AA189,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF189>0.01,AF189,0),2)","v":61.4},{"$f":"TRUNC(IF(AF189<0.01,-AF189,0),2)","v":0},{"$f":"AB189-AD189-AE189-AG189+AH189","v":3109.87},null,147]
[null,null,null,"DEPARTAMENTO DE DESARROLLO RURAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V188:V189)","v":9183.5},{"$f":"SUM(W188:W189)","v":367.34000000000003},642.84,0,1010.18,9183.5,10193.68,0,0,0,865.55973600000004,865.55,0,9328.130000000001]
[]
[]
[null,null,null,"CONTRALORIA"]
[{"$f":"A189+1","v":97},"3","1","MEDINA FLORES EVERARDO","BUHM840914",null,null,"CONTRALOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,442.72,{"$f":"TRUNC(U194*P194,2)","v":6640.8},{"$f":"TRUNC(U194*P194*0.04,2)","v":265.63},{"$f":"TRUNC(U194*0.07*P194,2)","v":464.85},{"$f":"S194","v":0},{"$f":"TRUNC(X194+W194+(IF(Y194>519,519,Y194))+IF(R194=0,0,R194*U194),2)","v":730.48},{"$f":"TRUNC((IF(R194=0,P194*U194,(P194-R194)*U194))+(IF(Y194<519,0,Y194-519)),2)+T194","v":6640.8},{"$f":"Z194+AA194","v":7371.2800000000007},null,0,0,{"$f":"IF(U194>0.01,(AA194-VLOOKUP(AA194,quincenal,1))*VLOOKUP(AA194,quincenal,3)+VLOOKUP(AA194,quincenal,2)-VLOOKUP(AA194,subquincenal,2),0)","v":871.28570400000012},{"$f":"TRUNC(IF(AF194>0.01,AF194,0),2)","v":871.28},{"$f":"TRUNC(IF(AF194<0.01,-AF194,0),2)","v":0},{"$f":"AB194-AD194-AE194-AG194+AH194","v":6500.0000000000009},null,149]
[{"$f":"A194+1","v":98},null,null,"RODRIGUEZ CASTELLANOS ANGELICA IVETTE","LEPC870628",null,null,"AUXILIAR DE   CONTRALORIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U195*P195,2)","v":2857},{"$f":"TRUNC(U195*P195*0.04,2)","v":114.28},{"$f":"TRUNC(U195*0.07*P195,2)","v":199.99},{"$f":"S195","v":0},{"$f":"TRUNC(X195+W195+(IF(Y195>519,519,Y195))+IF(R195=0,0,R195*U195),2)","v":314.27},{"$f":"TRUNC((IF(R195=0,P195*U195,(P195-R195)*U195))+(IF(Y195<519,0,Y195-519)),2)+T195","v":2857},{"$f":"Z195+AA195","v":3171.27},null,null,0,{"$f":"IF(U195>0.01,(AA195-VLOOKUP(AA195,quincenal,1))*VLOOKUP(AA195,quincenal,3)+VLOOKUP(AA195,quincenal,2)-VLOOKUP(AA195,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF195>0.01,AF195,0),2)","v":61.4},{"$f":"TRUNC(IF(AF195<0.01,-AF195,0),2)","v":0},{"$f":"AB195-AD195-AE195-AG195+AH195","v":3109.87}]
[{"$f":"A195+1","v":99},null,null,"GUTIERREZ SIORDIA LORENA",null,null,null,"SECRETARIA DE SECRETARIA GENERAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U196*P196,2)","v":2857},{"$f":"TRUNC(U196*P196*0.04,2)","v":114.28},{"$f":"TRUNC(U196*0.07*P196,2)","v":199.99},{"$f":"S196","v":0},{"$f":"TRUNC(X196+W196+(IF(Y196>519,519,Y196))+IF(R196=0,0,R196*U196),2)","v":314.27},{"$f":"TRUNC((IF(R196=0,P196*U196,(P196-R196)*U196))+(IF(Y196<519,0,Y196-519)),2)+T196","v":2857},{"$f":"Z196+AA196","v":3171.27},null,null,0,{"$f":"IF(U196>0.01,(AA196-VLOOKUP(AA196,quincenal,1))*VLOOKUP(AA196,quincenal,3)+VLOOKUP(AA196,quincenal,2)-VLOOKUP(AA196,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF196>0.01,AF196,0),2)","v":61.4},{"$f":"TRUNC(IF(AF196<0.01,-AF196,0),2)","v":0},{"$f":"AB196-AD196-AE196-AG196+AH196","v":3109.87},null,150]
[null,null,null,"CONTRALORIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V194:V196)","v":12354.8},{"$f":"SUM(W194:W196)","v":494.18999999999994},864.83,0,1359.02,12354.8,13713.820000000002,0,0,0,994.10272800000007,994.07999999999993,0,12719.740000000002]
[]
[null,null,null,"DELEGACIONES"]
[{"$f":"A196+1","v":100},"2","1","ARVIZU BACILIO ALONSO CANUTO",null,null,null,"DELEGADO MUNICIPAL DE  OCONAHUA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3556/30","v":118.53333333333333},{"$f":"TRUNC(U200*P200,2)","v":1778},{"$f":"TRUNC(U200*P200*0.04,2)","v":71.12},{"$f":"TRUNC(U200*0.07*P200,2)","v":124.46},{"$f":"S200","v":0},{"$f":"TRUNC(X200+W200+(IF(Y200>519,519,Y200))+IF(R200=0,0,R200*U200),2)","v":195.58},{"$f":"TRUNC((IF(R200=0,P200*U200,(P200-R200)*U200))+(IF(Y200<519,0,Y200-519)),2)+T200","v":1778},{"$f":"Z200+AA200","v":1973.58},null,null,0,{"$f":"IF(U200>0.01,(AA200-VLOOKUP(AA200,quincenal,1))*VLOOKUP(AA200,quincenal,3)+VLOOKUP(AA200,quincenal,2)-VLOOKUP(AA200,subquincenal,2),0)","v":-85.92583999999998},0,{"$f":"TRUNC(IF(AF200<0.01,-AF200,0),2)","v":85.92},{"$f":"AB200-AD200-AE200-AG200+AH200","v":2059.5},null,151]
[{"$f":"A200+1","v":101},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TARJETA",null,0,0,{"$f":"3933/30","v":131.1},null,null,null,0,0,0,0,null,null,null,{"$error":"#N/A"},null,null,0]
[{"$f":"A200+1","v":101},null,null,"BRAMBILA MELCHOR ADRIAN",null,null,null,"ENCARGADO DE OBRAS ´PUBLICAS EN OCONAHUA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6795/30","v":226.5},{"$f":"TRUNC(U202*P202,2)","v":3397.5},{"$f":"TRUNC(U202*P202*0.04,2)","v":135.9},{"$f":"TRUNC(U202*0.07*P202,2)","v":237.82},{"$f":"S202","v":0},{"$f":"TRUNC(X202+W202+(IF(Y202>519,519,Y202))+IF(R202=0,0,R202*U202),2)","v":373.72},{"$f":"TRUNC((IF(R202=0,P202*U202,(P202-R202)*U202))+(IF(Y202<519,0,Y202-519)),2)+T202","v":3397.5},{"$f":"Z202+AA202","v":3771.2200000000003},null,null,0,{"$f":"IF(U202>0.01,(AA202-VLOOKUP(AA202,quincenal,1))*VLOOKUP(AA202,quincenal,3)+VLOOKUP(AA202,quincenal,2)-VLOOKUP(AA202,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF202>0.01,AF202,0),2)","v":140.46},{"$f":"TRUNC(IF(AF202<0.01,-AF202,0),2)","v":0},{"$f":"AB202-AD202-AE202-AG202+AH202","v":3630.76}]
[{"$f":"A202+1","v":102},null,null,null,"LORL560923","LORL560923HJCPYN00",null,"GUARDARRASTRO",null,null,null,null,null,null,null,0,"TARJETA",null,0,0,82.109899999999996,{"$f":"TRUNC(U203*P203,2)","v":0},{"$f":"TRUNC(U203*P203*0.04,2)","v":0},{"$f":"TRUNC(U203*0.07*P203,2)","v":0},{"$f":"S203","v":0},{"$f":"TRUNC(X203+W203+(IF(Y203>519,519,Y203))+IF(R203=0,0,R203*U203),2)","v":0},{"$f":"TRUNC((IF(R203=0,P203*U203,(P203-R203)*U203))+(IF(Y203<519,0,Y203-519)),2)+T203","v":0},{"$f":"Z203+AA203","v":0},null,null,0,{"$f":"IF(U203>0.01,(AA203-VLOOKUP(AA203,quincenal,1))*VLOOKUP(AA203,quincenal,3)+VLOOKUP(AA203,quincenal,2)-VLOOKUP(AA203,subquincenal,2),0)","v":{"$error":"#N/A"}},null,null,{"$f":"AB203-AD203-AE203-AG203+AH203","v":0},null,155]
[103,null,null,"ALVAREZ SANDOVAL RUBEN","CESG4509243P3","CESG450924HMNRNB03","2004-02-08","ENCARGADO DE CEMENTERIOS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,62.989989999999999,{"$f":"TRUNC(U204*P204,2)","v":944.84},{"$f":"TRUNC(U204*P204*0.04,2)","v":37.79},{"$f":"TRUNC(U204*0.07*P204,2)","v":66.13},{"$f":"S204","v":0},{"$f":"TRUNC(X204+W204+(IF(Y204>519,519,Y204))+IF(R204=0,0,R204*U204),2)","v":103.92},{"$f":"TRUNC((IF(R204=0,P204*U204,(P204-R204)*U204))+(IF(Y204<519,0,Y204-519)),2)+T204","v":944.84},{"$f":"Z204+AA204","v":1048.76},null,null,0,{"$f":"IF(U204>0.01,(AA204-VLOOKUP(AA204,quincenal,1))*VLOOKUP(AA204,quincenal,3)+VLOOKUP(AA204,quincenal,2)-VLOOKUP(AA204,subquincenal,2),0)","v":-151.24807999999999},{"$f":"TRUNC(IF(AF204>0.01,AF204,0),2)","v":0},{"$f":"TRUNC(IF(AF204<0.01,-AF204,0),2)","v":151.24},{"$f":"AB204-AD204-AE204-AG204+AH204","v":1200},null,158]
[104,null,null,"DELEGACIONES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V200:V204)","v":6120.34},{"$f":"SUM(W200:W204)","v":244.81},428.40999999999997,0,673.22,6120.34,6793.56,0,0,0,{"$error":"#N/A"},140.46,237.16000000000003,6890.26,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V18+V24+V32+V37+V43+V48+V53+V60+V64+V71+V78+V85+V97+V107+V113+V117+V122+V129+V137+V143+V147+V152+V162+V166+V171+V177+V184+V190+V197+V205","v":426506.18000000005},17060.21,29855.16,0,46915.37,426506.18000000005,473421.55,0,3500,0,{"$error":"#N/A"},40663.950000000004,1788.8600000000004,431046.44999999995]
[]
[]
[]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",null,null,null,null,null,null,null,null,null,null,null,"L.C.P. MARTIN DANIEL FREGOSO BARBOZA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ING. MARIO CAMARENA GONZALEZ RUBIO"]
[null,null,null,"PRESIDENTE MUNICIPAL  ",null,null,null,null,null,null,null,null,null,null,null,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DIRECCION DE SEGURIDAD PUBLICA"]
[{"$f":"A204+1","v":104},null,null,"AGUIRRE REYES RAUL ANTONIO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6845/30","v":228.16666666666666},{"$f":"TRUNC(U222*P222,2)","v":3422.5},{"$f":"TRUNC(U222*P222*0.04,2)","v":136.9},{"$f":"TRUNC(U222*0.07*P222,2)","v":239.57},{"$f":"S222","v":0},{"$f":"TRUNC(X222+W222+(IF(Y222>519,519,Y222))+IF(R222=0,0,R222*U222),2)","v":376.47},{"$f":"TRUNC((IF(R222=0,P222*U222,(P222-R222)*U222))+(IF(Y222<519,0,Y222-519)),2)+T222","v":3422.5},{"$f":"Z222+AA222","v":3798.9700000000003},null,0,0,{"$f":"IF(U222>0.01,(AA222-VLOOKUP(AA222,quincenal,1))*VLOOKUP(AA222,quincenal,3)+VLOOKUP(AA222,quincenal,2)-VLOOKUP(AA222,subquincenal,2),0)","v":143.18491199999997},{"$f":"TRUNC(IF(AF222>0.01,AF222,0),2)","v":143.18},{"$f":"TRUNC(IF(AF222<0.01,-AF222,0),2)","v":0},{"$f":"AB222-AD222-AE222-AG222+AH222","v":3655.7900000000004},null,1]
[{"$f":"A222+1","v":105},11,17,"ARVIZU GIL HOMERO JOSE","AIGH730225LE1","AIGH730225HJCRLM08",null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,{"$f":"AK222+1","v":2}]
[{"$f":"A223+1","v":106},"11","17","CAMPERO MARTINEZ JUAN DANIEL","ROMP450629DNA","ROMP450629HJCSCB04",null,"POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,{"$f":"AK223+1","v":3}]
[{"$f":"A224+1","v":107},11,17,"CARRILLO MURILLO SALVADOR","CAMS620429F91","CAMS620429HNTRRL00",null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,{"$f":"AK224+1","v":4}]
[108,"11","17","CASTAÑEDA ARANDAS EFREN",null,null,null,"OFICIAL DE PREVENCION SOCIAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,5]
[109,null,null,"CORONA MARTINEZ JOSE MARIANO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,6]
[110,null,null,"CASTRO DOMINGUEZ ZAIRA EVANGELINA",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,{"$f":"TRUNC(U228*P228,2)","v":3422.5},{"$f":"TRUNC(U228*P228*0.04,2)","v":136.9},{"$f":"TRUNC(U228*0.07*P228,2)","v":239.57},{"$f":"S228","v":0},{"$f":"TRUNC(X228+W228+(IF(Y228>519,519,Y228))+IF(R228=0,0,R228*U228),2)","v":376.47},{"$f":"TRUNC((IF(R228=0,P228*U228,(P228-R228)*U228))+(IF(Y228<519,0,Y228-519)),2)+T228","v":3422.5},{"$f":"Z228+AA228","v":3798.9700000000003},null,500,0,{"$f":"IF(U228>0.01,(AA228-VLOOKUP(AA228,quincenal,1))*VLOOKUP(AA228,quincenal,3)+VLOOKUP(AA228,quincenal,2)-VLOOKUP(AA228,subquincenal,2),0)","v":143.18491199999997},{"$f":"TRUNC(IF(AF228>0.01,AF228,0),2)","v":143.18},{"$f":"TRUNC(IF(AF228<0.01,-AF228,0),2)","v":0},{"$f":"AB228-AD228-AE228-AG228+AH228","v":3155.7900000000004},null,7]
[111,null,null,"FIGUEROA GARCIA JOSE DE JESUS",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,500,0,143.18491199999997,143.18,0,3155.7900000000004,null,8]
[null,null,null,"FIGUEROA SANTIAGO JOSE ALBERTO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,{"$f":"TRUNC(U230*P230,2)","v":3422.5},{"$f":"TRUNC(U230*P230*0.04,2)","v":136.9},{"$f":"TRUNC(U230*0.07*P230,2)","v":239.57},{"$f":"S230","v":0},{"$f":"TRUNC(X230+W230+(IF(Y230>519,519,Y230))+IF(R230=0,0,R230*U230),2)","v":376.47},{"$f":"TRUNC((IF(R230=0,P230*U230,(P230-R230)*U230))+(IF(Y230<519,0,Y230-519)),2)+T230","v":3422.5},{"$f":"Z230+AA230","v":3798.9700000000003},null,0,0,{"$f":"IF(U230>0.01,(AA230-VLOOKUP(AA230,quincenal,1))*VLOOKUP(AA230,quincenal,3)+VLOOKUP(AA230,quincenal,2)-VLOOKUP(AA230,subquincenal,2),0)","v":143.18491199999997},{"$f":"TRUNC(IF(AF230>0.01,AF230,0),2)","v":143.18},{"$f":"TRUNC(IF(AF230<0.01,-AF230,0),2)","v":0},{"$f":"AB230-AD230-AE230-AG230+AH230","v":3655.7900000000004}]
[{"$f":"A229+1","v":112},null,null,"GARCIA FIGUEROA GUSTAVO ","HEAS",null,null,"COMANDANTE",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9121/30","v":304.03333333333336},4560.5,182.42,319.23,0,501.65,4560.5,5062.1499999999996,null,null,0,444.74708800000008,444.74,0,4617.41,null,{"$f":"AK229+1","v":9}]
[113,null,null,"GARCIA FIGUEROA JOSE MANUEL",null,null,null,"COMANDANTE",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9121/30","v":304.03333333333336},4560.5,182.42,319.23,0,501.65,4560.5,5062.1499999999996,null,null,0,444.74708800000008,444.74,0,4617.41,null,10]
[114,"11","17","GARCIA GARCIA ROGELIO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6845/30","v":228.16666666666666},3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,11]
[115,"11","17","GARCIA MAGALLANES FRANCISCO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6845/30","v":228.16666666666666},3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,12]
[116,null,null,"GAYTAN PEREZ LUIS GABRIEL",null,null,null,"SUB DIRECTOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"10948/30","v":364.93333333333334},5474,218.96,383.18,0,602.14,5474,6076.14,null,null,0,622.05722400000013,622.04999999999995,0,5454.09,null,13]
[117,"11","17","AGUIRRE MERCADO JOVANNY MISSAEL","GOCB550313","GOCB550313HJCMHN07","2007-01-01","POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6845/30","v":228.16666666666666},3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,14]
[118,"11","17","GONZALEZ CAMPOS JOSE MANUEL",null,null,null,"POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,500,0,143.18491199999997,143.18,0,3155.7900000000004,null,15]
[119,null,null,"HERNANDEZ ARIAS SEBASTIAN","RUGE",null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,500,0,143.18491199999997,143.18,0,3155.7900000000004,null,16]
[120,"11","17","HERNANDEZ PALACIOS ANGEL FERNANDO",null,null,null,"POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,17]
[121,null,null,"HERNANDEZ PALACIOS REFUGIO GUADALUPE","DENL910517","DENL910517HJCLVS07",null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,18]
[{"$f":"A239+1","v":121},null,null,"MANCILLAS MORA MARTIN","MAMM741224","MAMM741224HCJNRR00",null,"POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,19]
[122,null,null,"MARQUEZ CERVANTES ALBERTO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,20]
[123,null,null,"MARTINEZ GARCIA JOSE ENRIQUE",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,21]
[124,null,null,null,null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,null,"TARJETA",null,0,0,228.16666666666666,0,0,0,0,0,0,0,null,0,0,{"$error":"#N/A"},null,null,0,null,22]
[125,null,null,null,null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,0,"TARJETA",null,0,0,228.16666666666666,0,0,0,0,0,0,0,null,0,0,{"$error":"#N/A"},0,0,0,null,23]
[126,null,null,"RAMIREZ ALVAREZ ANAHI",null,null,null,"POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,24]
[127,"11","17","RENDON SEGUNDO DELFINO","REAJ700624U14","REAJ700624HJCGQN05",null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,25]
[128,"11","17","REYES HERNANDEZ MOISES","REHM541231","REHM641231HJCYRS02",null,"POLICIA EN LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,26]
[129,null,null,"RODRIGUEZ OLMEDO JOSE RAFAEL",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,0,0,143.18491199999997,143.18,0,3655.7900000000004,null,27]
[null,null,null,"ROSAS FLORES ALVARO",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,{"$f":"TRUNC(U250*P250,2)","v":3422.5},{"$f":"TRUNC(U250*P250*0.04,2)","v":136.9},{"$f":"TRUNC(U250*0.07*P250,2)","v":239.57},{"$f":"S250","v":0},{"$f":"TRUNC(X250+W250+(IF(Y250>519,519,Y250))+IF(R250=0,0,R250*U250),2)","v":376.47},{"$f":"TRUNC((IF(R250=0,P250*U250,(P250-R250)*U250))+(IF(Y250<519,0,Y250-519)),2)+T250","v":3422.5},{"$f":"Z250+AA250","v":3798.9700000000003},null,0,0,{"$f":"IF(U250>0.01,(AA250-VLOOKUP(AA250,quincenal,1))*VLOOKUP(AA250,quincenal,3)+VLOOKUP(AA250,quincenal,2)-VLOOKUP(AA250,subquincenal,2),0)","v":143.18491199999997},{"$f":"TRUNC(IF(AF250>0.01,AF250,0),2)","v":143.18},{"$f":"TRUNC(IF(AF250<0.01,-AF250,0),2)","v":0},{"$f":"AB250-AD250-AE250-AG250+AH250","v":3655.7900000000004}]
[{"$f":"A249+1","v":130},"11","17","SALAS CARRANZA FRANCISCO CARLOS",null,null,null,"POLICIA DE LINEA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,228.16666666666666,3422.5,136.9,239.57,0,376.47,3422.5,3798.9700000000003,null,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,{"$f":"AK249+1","v":28}]
[131,null,null,"TORRES MORAN CARLOS",null,null,null,"DIRECTOR DE SEGURIDAD PUBLICA MUNICIPAL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"16133/30","v":537.76666666666665},8066.5,322.66000000000003,564.65,0,887.31,8066.5,8953.81,null,null,0,1175.8152239999999,1175.81,0,7778,null,29]
[132,"11","17","VILLANE VALLARTA EFREN OSWALDO","VIVE",null,null,"AUXILIAR ADMINISTRATIVO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"8256/30","v":275.2},4128,165.12,288.95999999999998,0,454.08,4128,4582.08,null,500,0,369.5684,369.56,0,3712.52,null,30]
[null,null,null,"DIRECCION DE SEGURIDAD PUBLICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V222:V253)","v":112352},{"$f":"SUM(W222:W253)","v":4494.0800000000017},7864.4999999999964,0,12358.579999999998,112352,124710.58000000002,0,2500,0,{"$error":"#N/A"},6636.4000000000005,0,115574.17999999995]
[]
[null,null,null,"DEPARTAMENTO DE PROTECCION CIVIL"]
[{"$f":"A253+1","v":133},"11","18","DE LATORRE GARCIA MIGUEL RAFAEL","GAHJ",null,null,"DIRECTOR DE PROTECCION CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U257*P257,2)","v":6326.5},{"$f":"TRUNC(U257*P257*0.04,2)","v":253.06},{"$f":"TRUNC(U257*0.07*P257,2)","v":442.85},{"$f":"S257","v":0},{"$f":"TRUNC(X257+W257+(IF(Y257>519,519,Y257))+IF(R257=0,0,R257*U257),2)","v":695.91},{"$f":"TRUNC((IF(R257=0,P257*U257,(P257-R257)*U257))+(IF(Y257<519,0,Y257-519)),2)+T257","v":6326.5},{"$f":"Z257+AA257","v":7022.41},null,0,0,{"$f":"IF(U257>0.01,(AA257-VLOOKUP(AA257,quincenal,1))*VLOOKUP(AA257,quincenal,3)+VLOOKUP(AA257,quincenal,2)-VLOOKUP(AA257,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF257>0.01,AF257,0),2)","v":804.15},{"$f":"TRUNC(IF(AF257<0.01,-AF257,0),2)","v":0},{"$f":"AB257-AD257-AE257-AG257+AH257","v":6218.26},null,1]
[{"$f":"A257+1","v":134},null,null,"TRINIDAD RAMIREZ JOSE ROMAN","VAML800130","VAML800130HJCRRS04",null,"PARAMEDICO PROTECCIONJ CIVIL",null,null,null,null,null,null,null,0,"TARJETA",null,0,0,{"$f":"6438/30","v":214.6},{"$f":"TRUNC(U258*P258,2)","v":0},{"$f":"TRUNC(U258*P258*0.04,2)","v":0},{"$f":"TRUNC(U258*0.07*P258,2)","v":0},{"$f":"S258","v":0},{"$f":"TRUNC(X258+W258+(IF(Y258>519,519,Y258))+IF(R258=0,0,R258*U258),2)","v":0},{"$f":"TRUNC((IF(R258=0,P258*U258,(P258-R258)*U258))+(IF(Y258<519,0,Y258-519)),2)+T258","v":0},{"$f":"Z258+AA258","v":0},null,0,0,{"$f":"IF(U258>0.01,(AA258-VLOOKUP(AA258,quincenal,1))*VLOOKUP(AA258,quincenal,3)+VLOOKUP(AA258,quincenal,2)-VLOOKUP(AA258,subquincenal,2),0)","v":{"$error":"#N/A"}},0,0,{"$f":"AB258-AD258-AE258-AG258+AH258","v":0},null,{"$f":"AK257+1","v":2}]
[{"$f":"A258+1","v":135},null,null,"GARCIA MONTES SAUL MARGARITO",null,null,null,"PARAMEDICO PROTECCIONJ CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5164/30","v":172.13333333333333},{"$f":"TRUNC(U259*P259,2)","v":2582},{"$f":"TRUNC(U259*P259*0.04,2)","v":103.28},{"$f":"TRUNC(U259*0.07*P259,2)","v":180.74},{"$f":"S259","v":0},{"$f":"TRUNC(X259+W259+(IF(Y259>519,519,Y259))+IF(R259=0,0,R259*U259),2)","v":284.02},{"$f":"TRUNC((IF(R259=0,P259*U259,(P259-R259)*U259))+(IF(Y259<519,0,Y259-519)),2)+T259","v":2582},{"$f":"Z259+AA259","v":2866.02},null,null,0,16.488511999999986,{"$f":"TRUNC(IF(AF259>0.01,AF259,0),2)","v":16.48},{"$f":"TRUNC(IF(AF259<0.01,-AF259,0),2)","v":0},{"$f":"AB259-AD259-AE259-AG259+AH259","v":2849.54},null,{"$f":"AK258+1","v":3}]
[{"$f":"A259+1","v":136},null,null,"LOPEZ GOMEZ GABRIEL ALEJANDRO",null,null,null,"PARAMEDICO PROTECCIONJ CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5164/30","v":172.13333333333333},{"$f":"TRUNC(U260*P260,2)","v":2582},{"$f":"TRUNC(U260*P260*0.04,2)","v":103.28},{"$f":"TRUNC(U260*0.07*P260,2)","v":180.74},{"$f":"S260","v":0},{"$f":"TRUNC(X260+W260+(IF(Y260>519,519,Y260))+IF(R260=0,0,R260*U260),2)","v":284.02},{"$f":"TRUNC((IF(R260=0,P260*U260,(P260-R260)*U260))+(IF(Y260<519,0,Y260-519)),2)+T260","v":2582},{"$f":"Z260+AA260","v":2866.02},null,null,0,{"$f":"IF(U260>0.01,(AA260-VLOOKUP(AA260,quincenal,1))*VLOOKUP(AA260,quincenal,3)+VLOOKUP(AA260,quincenal,2)-VLOOKUP(AA260,subquincenal,2),0)","v":16.488511999999986},{"$f":"TRUNC(IF(AF260>0.01,AF260,0),2)","v":16.48},{"$f":"TRUNC(IF(AF260<0.01,-AF260,0),2)","v":0},{"$f":"AB260-AD260-AE260-AG260+AH260","v":2849.54},null,4]
[null,null,null,"DEPARTAMENTO DE PROTECCION CIVIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V257:V260)","v":11490.5},{"$f":"SUM(W257:W260)","v":459.62},804.33,0,1263.9499999999998,11490.5,12754.45,0,0,0,{"$error":"#N/A"},837.11,0,11917.34]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V261+V254","v":123842.5},4953.7000000000016,8668.8299999999963,0,13622.529999999999,123842.5,137465.03000000003,0,2500,0,{"$error":"#N/A"},7473.51,0,127491.51999999995]
[]
[]
[]
[]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",null,null,null,null,null,null,null,null,null,null,null,"L.C.P. MARTIN DANIEL FREGOSO BARBOZA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ING. MARIO CAMARENA GONZALEZ RUBIO"]
[null,null,null,"PRESIDENTE MUNICIPAL  ",null,null,null,null,null,null,null,null,null,null,null,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]
[]
[]
[]
[]
[]
[null,null,null,"PENSIONADOS"]
[{"$f":"A260+1","v":137},null,null,"DE LA ROSA MACIAS PABLO","ROMP450629DNA","ROMP450629HJCSCB04",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3078/30","v":102.6},{"$f":"TRUNC(U277*P277,2)","v":1539},{"$f":"TRUNC(U277*P277*0.04,2)","v":61.56},{"$f":"TRUNC(U277*0.07*P277,2)","v":107.73},{"$f":"S277","v":0},{"$f":"TRUNC(X277+W277+(IF(Y277>519,519,Y277))+IF(R277=0,0,R277*U277),2)","v":169.29},{"$f":"TRUNC((IF(R277=0,P277*U277,(P277-R277)*U277))+(IF(Y277<519,0,Y277-519)),2)+T277","v":1539},{"$f":"Z277+AA277","v":1708.29},null,null,0,{"$f":"IF(U277>0.01,(AA277-VLOOKUP(AA277,quincenal,1))*VLOOKUP(AA277,quincenal,3)+VLOOKUP(AA277,quincenal,2)-VLOOKUP(AA277,subquincenal,2),0)","v":-113.22183999999997},{"$f":"TRUNC(IF(AF277>0.01,AF277,0),2)","v":0},{"$f":"TRUNC(IF(AF277<0.01,-AF277,0),2)","v":113.22},{"$f":"AB277-AD277-AE277-AG277+AH277","v":1821.51},null,2]
[{"$f":"A277+1","v":138},null,null,"DIAZ ORTIZ LUIS",null,null,null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3570/30","v":119},{"$f":"TRUNC(U278*P278,2)","v":1785},{"$f":"TRUNC(U278*P278*0.04,2)","v":71.400000000000006},{"$f":"TRUNC(U278*0.07*P278,2)","v":124.95},{"$f":"S278","v":0},{"$f":"TRUNC(X278+W278+(IF(Y278>519,519,Y278))+IF(R278=0,0,R278*U278),2)","v":196.35},{"$f":"TRUNC((IF(R278=0,P278*U278,(P278-R278)*U278))+(IF(Y278<519,0,Y278-519)),2)+T278","v":1785},{"$f":"Z278+AA278","v":1981.35},null,null,0,{"$f":"IF(U278>0.01,(AA278-VLOOKUP(AA278,quincenal,1))*VLOOKUP(AA278,quincenal,3)+VLOOKUP(AA278,quincenal,2)-VLOOKUP(AA278,subquincenal,2),0)","v":-85.477839999999972},{"$f":"TRUNC(IF(AF278>0.01,AF278,0),2)","v":0},{"$f":"TRUNC(IF(AF278<0.01,-AF278,0),2)","v":85.47},{"$f":"AB278-AD278-AE278-AG278+AH278","v":2066.8199999999997}]
[139,null,null,"DIAZ ROMERO J FELIX","DIRF401208","DIRF401210HJCZML05","2001-01-01","PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2966/30","v":98.86666666666666},{"$f":"TRUNC(U279*P279,2)","v":1483},{"$f":"TRUNC(U279*P279*0.04,2)","v":59.32},{"$f":"TRUNC(U279*0.07*P279,2)","v":103.81},{"$f":"S279","v":0},{"$f":"TRUNC(X279+W279+(IF(Y279>519,519,Y279))+IF(R279=0,0,R279*U279),2)","v":163.13},{"$f":"TRUNC((IF(R279=0,P279*U279,(P279-R279)*U279))+(IF(Y279<519,0,Y279-519)),2)+T279","v":1483},{"$f":"Z279+AA279","v":1646.13},null,null,0,{"$f":"IF(U279>0.01,(AA279-VLOOKUP(AA279,quincenal,1))*VLOOKUP(AA279,quincenal,3)+VLOOKUP(AA279,quincenal,2)-VLOOKUP(AA279,subquincenal,2),0)","v":-116.80583999999998},{"$f":"TRUNC(IF(AF279>0.01,AF279,0),2)","v":0},{"$f":"TRUNC(IF(AF279<0.01,-AF279,0),2)","v":116.8},{"$f":"AB279-AD279-AE279-AG279+AH279","v":1762.93},null,3]
[140,null,null,"ESQUIVEL CLARO EULALIA",null,null,null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"1630/30","v":54.333333333333336},{"$f":"TRUNC(U280*P280,2)","v":815},{"$f":"TRUNC(U280*P280*0.04,2)","v":32.6},{"$f":"TRUNC(U280*0.07*P280,2)","v":57.05},{"$f":"S280","v":0},{"$f":"TRUNC(X280+W280+(IF(Y280>519,519,Y280))+IF(R280=0,0,R280*U280),2)","v":89.65},{"$f":"TRUNC((IF(R280=0,P280*U280,(P280-R280)*U280))+(IF(Y280<519,0,Y280-519)),2)+T280","v":815},{"$f":"Z280+AA280","v":904.65},null,null,0,{"$f":"IF(U280>0.01,(AA280-VLOOKUP(AA280,quincenal,1))*VLOOKUP(AA280,quincenal,3)+VLOOKUP(AA280,quincenal,2)-VLOOKUP(AA280,subquincenal,2),0)","v":-159.70783999999998},{"$f":"TRUNC(IF(AF280>0.01,AF280,0),2)","v":0},{"$f":"TRUNC(IF(AF280<0.01,-AF280,0),2)","v":159.69999999999999},{"$f":"AB280-AD280-AE280-AG280+AH280","v":1064.3499999999999},null,4]
[141,null,null,"GARCIA FRANCISCO",null,null,null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2458/30","v":81.933333333333337},{"$f":"TRUNC(U281*P281,2)","v":1229},{"$f":"TRUNC(U281*P281*0.04,2)","v":49.16},{"$f":"TRUNC(U281*0.07*P281,2)","v":86.03},{"$f":"S281","v":0},{"$f":"TRUNC(X281+W281+(IF(Y281>519,519,Y281))+IF(R281=0,0,R281*U281),2)","v":135.19},{"$f":"TRUNC((IF(R281=0,P281*U281,(P281-R281)*U281))+(IF(Y281<519,0,Y281-519)),2)+T281","v":1229},{"$f":"Z281+AA281","v":1364.19},null,0,0,{"$f":"IF(U281>0.01,(AA281-VLOOKUP(AA281,quincenal,1))*VLOOKUP(AA281,quincenal,3)+VLOOKUP(AA281,quincenal,2)-VLOOKUP(AA281,subquincenal,2),0)","v":-133.06183999999996},{"$f":"TRUNC(IF(AF281>0.01,AF281,0),2)","v":0},{"$f":"TRUNC(IF(AF281<0.01,-AF281,0),2)","v":133.06},{"$f":"AB281-AD281-AE281-AG281+AH281","v":1497.25},null,5]
[142,"11","17","GIL RIVERA JOSE LUIS","GIRL700926","GIRL700926HJCLVS01","2007-01-01","PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3423/30","v":114.1},{"$f":"TRUNC(U282*P282,2)","v":1711.5},{"$f":"TRUNC(U282*P282*0.04,2)","v":68.459999999999994},{"$f":"TRUNC(U282*0.07*P282,2)","v":119.8},{"$f":"S282","v":0},{"$f":"TRUNC(X282+W282+(IF(Y282>519,519,Y282))+IF(R282=0,0,R282*U282),2)","v":188.26},{"$f":"TRUNC((IF(R282=0,P282*U282,(P282-R282)*U282))+(IF(Y282<519,0,Y282-519)),2)+T282","v":1711.5},{"$f":"Z282+AA282","v":1899.76},null,0,0,{"$f":"IF(U282>0.01,(AA282-VLOOKUP(AA282,quincenal,1))*VLOOKUP(AA282,quincenal,3)+VLOOKUP(AA282,quincenal,2)-VLOOKUP(AA282,subquincenal,2),0)","v":-102.18183999999998},{"$f":"TRUNC(IF(AF282>0.01,AF282,0),2)","v":0},{"$f":"TRUNC(IF(AF282<0.01,-AF282,0),2)","v":102.18},{"$f":"AB282-AD282-AE282-AG282+AH282","v":2001.94},null,6]
[143,null,null,"GOMEZ CHAVEZ BENIGNO","GUJJ351120F83","GUJJ351120HJCVR 03",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3570/30","v":119},{"$f":"TRUNC(U283*P283,2)","v":1785},{"$f":"TRUNC(U283*P283*0.04,2)","v":71.400000000000006},{"$f":"TRUNC(U283*0.07*P283,2)","v":124.95},{"$f":"S283","v":0},{"$f":"TRUNC(X283+W283+(IF(Y283>519,519,Y283))+IF(R283=0,0,R283*U283),2)","v":196.35},{"$f":"TRUNC((IF(R283=0,P283*U283,(P283-R283)*U283))+(IF(Y283<519,0,Y283-519)),2)+T283","v":1785},{"$f":"Z283+AA283","v":1981.35},null,0,0,{"$f":"IF(U283>0.01,(AA283-VLOOKUP(AA283,quincenal,1))*VLOOKUP(AA283,quincenal,3)+VLOOKUP(AA283,quincenal,2)-VLOOKUP(AA283,subquincenal,2),0)","v":-85.477839999999972},{"$f":"TRUNC(IF(AF283>0.01,AF283,0),2)","v":0},{"$f":"TRUNC(IF(AF283<0.01,-AF283,0),2)","v":85.47},{"$f":"AB283-AD283-AE283-AG283+AH283","v":2066.8199999999997},null,7]
[144,null,null,"GUIZAR CARRILLO FRANCISCO JAVIER",null,null,null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3423/30","v":114.1},{"$f":"TRUNC(U284*P284,2)","v":1711.5},{"$f":"TRUNC(U284*P284*0.04,2)","v":68.459999999999994},{"$f":"TRUNC(U284*0.07*P284,2)","v":119.8},{"$f":"S284","v":0},{"$f":"TRUNC(X284+W284+(IF(Y284>519,519,Y284))+IF(R284=0,0,R284*U284),2)","v":188.26},{"$f":"TRUNC((IF(R284=0,P284*U284,(P284-R284)*U284))+(IF(Y284<519,0,Y284-519)),2)+T284","v":1711.5},{"$f":"Z284+AA284","v":1899.76},null,0,0,{"$f":"IF(U284>0.01,(AA284-VLOOKUP(AA284,quincenal,1))*VLOOKUP(AA284,quincenal,3)+VLOOKUP(AA284,quincenal,2)-VLOOKUP(AA284,subquincenal,2),0)","v":-102.18183999999998},{"$f":"TRUNC(IF(AF284>0.01,AF284,0),2)","v":0},{"$f":"TRUNC(IF(AF284<0.01,-AF284,0),2)","v":102.18},{"$f":"AB284-AD284-AE284-AG284+AH284","v":2001.94},null,8]
[145,null,null,"HERNANDEZ RAMIREZ SALVADOR","HERS421229UE7","HERS421229HJCRML04",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4305/30","v":143.5},2152.5,86.1,150.66999999999999,0,236.77,2152.5,2389.27,null,500,0,-58.591088000000013,0,58.59,1947.86,null,9]
[146,null,null,"HERNANDEZ SANTIAGO JOSE DE JESUS","HESJ410605JD8","HESJ410605HJCRNS07",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2586/30","v":86.2},1293,51.72,90.51,0,142.22999999999999,1293,1435.23,null,null,0,-128.96583999999996,0,128.96,1564.19,null,10]
[147,null,null,"MENDEZ FRANCO MIGUEL","MEFM351006CE0","MEFM351006HJCNRG07",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6082/30","v":202.73333333333332},3041,121.64,212.87,0,334.51,3041,3375.51,null,0,0,81.427711999999985,81.42,0,3294.09,null,11]
[148,null,null,"OCHOA FLORES MARIA DE JESUS","MERL260819Q10","MERL260819HJCZGS06",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"1630/30","v":54.333333333333336},{"$f":"TRUNC(U288*P288,2)","v":815},{"$f":"TRUNC(U288*P288*0.04,2)","v":32.6},{"$f":"TRUNC(U288*0.07*P288,2)","v":57.05},{"$f":"S288","v":0},{"$f":"TRUNC(X288+W288+(IF(Y288>519,519,Y288))+IF(R288=0,0,R288*U288),2)","v":89.65},{"$f":"TRUNC((IF(R288=0,P288*U288,(P288-R288)*U288))+(IF(Y288<519,0,Y288-519)),2)+T288","v":815},{"$f":"Z288+AA288","v":904.65},null,null,0,{"$f":"IF(U288>0.01,(AA288-VLOOKUP(AA288,quincenal,1))*VLOOKUP(AA288,quincenal,3)+VLOOKUP(AA288,quincenal,2)-VLOOKUP(AA288,subquincenal,2),0)","v":-159.70783999999998},{"$f":"TRUNC(IF(AF288>0.01,AF288,0),2)","v":0},{"$f":"TRUNC(IF(AF288<0.01,-AF288,0),2)","v":159.69999999999999},{"$f":"AB288-AD288-AE288-AG288+AH288","v":1064.3499999999999},null,12]
[149,null,null,"SANCHEZ SANCHEZ RAYMUNDO","SASR4910255R8","SASR491025HJCNNY01",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6070/30","v":202.33333333333334},3035,121.4,212.45,0,333.85,3035,3368.85,null,null,0,80.774911999999972,80.77,0,3288.08,null,14]
[null,null,null,"PENSIONADOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V277:V289)","v":22395.5},895.81999999999994,1567.67,0,2463.4899999999998,22395.5,24858.990000000005,0,500,0,-1083.178864,162.19,1245.3300000000002,25442.129999999997]
[]
[]
[]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",null,null,null,null,null,null,null,null,null,null,null,"L.C.P. MARTIN DANIEL FREGOSO BARBOZA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ING. MARIO CAMARENA GONZALEZ RUBIO"]
[null,null,null,"PRESIDENTE MUNICIPAL  ",null,null,null,null,null,null,null,null,null,null,null,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]
[]
[]
[]
[null,null,null,"AGUA POTABLE Y ALCANTRILLADO"]
[{"$f":"A289+1","v":150},null,null,"BAILON SIERRA ENRIQUE","BASE740304","BASE740304HJCLRN02",null,"ENCARGADO GENERAL DE ALCANTARILLADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5772/30","v":192.4},{"$f":"TRUNC(U300*P300,2)","v":2886},{"$f":"TRUNC(U300*P300*0.04,2)","v":115.44},{"$f":"TRUNC(U300*0.07*P300,2)","v":202.02},{"$f":"S300","v":0},{"$f":"TRUNC(X300+W300+(IF(Y300>519,519,Y300))+IF(R300=0,0,R300*U300),2)","v":317.45999999999998},{"$f":"TRUNC((IF(R300=0,P300*U300,(P300-R300)*U300))+(IF(Y300<519,0,Y300-519)),2)+T300","v":2886},{"$f":"Z300+AA300","v":3203.46},null,null,0,{"$f":"IF(U300>0.01,(AA300-VLOOKUP(AA300,quincenal,1))*VLOOKUP(AA300,quincenal,3)+VLOOKUP(AA300,quincenal,2)-VLOOKUP(AA300,subquincenal,2),0)","v":64.563711999999981},{"$f":"TRUNC(IF(AF300>0.01,AF300,0),2)","v":64.56},{"$f":"TRUNC(IF(AF300<0.01,-AF300,0),2)","v":0},{"$f":"AB300-AD300-AE300-AG300+AH300","v":3138.9},null,1]
[{"$f":"A300+1","v":151},null,null,"GARCIA MEDINA RAMON","GAMR560716","GAMR560716HJCRDM02",null,"ENCARGADO GENERAL DE BOMBAS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6207/30","v":206.9},3103.5,124.14,217.24,0,341.38,3103.5,3444.88,null,null,0,108.47771199999997,108.47,0,3336.4100000000003,null,9]
[{"$f":"#REF!+1","v":{"$error":"#REF!"}},"2","2","BARAJAS REYES VICTORINO","HEPJ581212","HEPJ571212HJCRNN00",null,"ENCARGADO  DE BOMBA EN SANTA ROSALIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,82.109899999999996,1231.6400000000001,49.26,86.21,0,135.47,1231.6400000000001,1367.1100000000001,null,null,0,-132.89287999999999,0,132.88999999999999,1500,null,13]
[{"$f":"A302+1","v":{"$error":"#REF!"}},null,null,"GONZALEZ BERNAL ENRIQUE MARTIN",null,null,null,"ENCARGADO DEL AGUA POTABLE",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U303*P303,2)","v":2857},{"$f":"TRUNC(U303*P303*0.04,2)","v":114.28},{"$f":"TRUNC(U303*0.07*P303,2)","v":199.99},{"$f":"S303","v":0},{"$f":"TRUNC(X303+W303+(IF(Y303>519,519,Y303))+IF(R303=0,0,R303*U303),2)","v":314.27},{"$f":"TRUNC((IF(R303=0,P303*U303,(P303-R303)*U303))+(IF(Y303<519,0,Y303-519)),2)+T303","v":2857},{"$f":"Z303+AA303","v":3171.27},null,0,0,{"$f":"IF(U303>0.01,(AA303-VLOOKUP(AA303,quincenal,1))*VLOOKUP(AA303,quincenal,3)+VLOOKUP(AA303,quincenal,2)-VLOOKUP(AA303,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF303>0.01,AF303,0),2)","v":61.4},{"$f":"TRUNC(IF(AF303<0.01,-AF303,0),2)","v":0},{"$f":"AB303-AD303-AE303-AG303+AH303","v":3109.87},null,21]
[{"$error":"#REF!"},null,null,"PONCE FRANCO JOSE SALVADOR",null,null,null,"ENCARGADO  DE BOMBA AGUA ZARCA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U304*P304,2)","v":2857},{"$f":"TRUNC(U304*P304*0.04,2)","v":114.28},{"$f":"TRUNC(U304*0.07*P304,2)","v":199.99},{"$f":"S304","v":0},{"$f":"TRUNC(X304+W304+(IF(Y304>519,519,Y304))+IF(R304=0,0,R304*U304),2)","v":314.27},{"$f":"TRUNC((IF(R304=0,P304*U304,(P304-R304)*U304))+(IF(Y304<519,0,Y304-519)),2)+T304","v":2857},{"$f":"Z304+AA304","v":3171.27},null,null,0,{"$f":"IF(U304>0.01,(AA304-VLOOKUP(AA304,quincenal,1))*VLOOKUP(AA304,quincenal,3)+VLOOKUP(AA304,quincenal,2)-VLOOKUP(AA304,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF304>0.01,AF304,0),2)","v":61.4},{"$f":"TRUNC(IF(AF304<0.01,-AF304,0),2)","v":0},{"$f":"AB304-AD304-AE304-AG304+AH304","v":3109.87},null,22]
[{"$f":"A304+1","v":{"$error":"#REF!"}},null,null,"SANCHEZ GARCIA VICTOR MANUEL",null,null,null,"FONTANERO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4799/30","v":159.96666666666667},2399.5,95.98,167.96,{"$f":"S305","v":0},263.94,2399.5,{"$f":"Z305+AA305","v":2663.44},null,null,0,{"$f":"IF(U305>0.01,(AA305-VLOOKUP(AA305,quincenal,1))*VLOOKUP(AA305,quincenal,3)+VLOOKUP(AA305,quincenal,2)-VLOOKUP(AA305,subquincenal,2),0)","v":-3.3674880000000087},{"$f":"TRUNC(IF(AF305>0.01,AF305,0),2)","v":0},{"$f":"TRUNC(IF(AF305<0.01,-AF305,0),2)","v":3.36},{"$f":"AB305-AD305-AE305-AG305+AH305","v":2666.8},null,24]
[null,null,null,"AGUA POTABLE Y ALCANTRILLADO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V300:V305)","v":15334.64},613.38,1073.4100000000001,0,1686.79,15334.64,17021.43,0,0,0,159.5980799999999,295.83,136.25,16861.849999999999]
[]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",null,null,null,null,null,null,null,null,null,null,null,"L.C.P. MARTIN DANIEL FREGOSO BARBOZA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ING. MARIO CAMARENA GONZALEZ RUBIO"]
[null,null,null,"PRESIDENTE MUNICIPAL  ",null,null,null,null,null,null,null,null,null,null,null,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]

{"sheet":"Tablas 2015","index":1,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,4,0,6],[0,8,0,10],[1,0,1,2],[1,4,1,6],[1,8,1,10],[18,0,18,1],[18,4,18,5],[18,8,18,9],[19,0,19,1],[19,4,19,5],[19,8,19,9]]}
["TARIFA MENSUAL ISR",null,null,null,"TARIFA QUINCENAL ISR",null,null,null,"TARIFA SEMANAL ISR",null,null,null,0.01,496.07,0,1.92]
[2015,null,null,null,2015,null,null,null,2015,null,null,null,496.08,4210.41,9.52,6.4]
["Lim. Inferior","Cuota Fija","%",null,"Lim. Inferior","Cuota Fija","%",null,"Lim. Inferior","Cuota Fija","%",null,4210.42,7399.42,247.24,10.88]
[0.01,0,1.9199999999999998E-2,null,0.01,0,1.9199999999999998E-2,null,0.01,0,1.9199999999999998E-2,null,7399.43,8601.5,594.21,16]
[496.08,9.52,6.4000000000000001E-2,null,244.81,4.6500000000000004,6.4000000000000001E-2,null,114.25,2.17,6.4000000000000001E-2,null,8601.51,10298.35,786.54,17.920000000000002]
[4210.42,247.24,0.10879999999999999,null,2077.5100000000002,121.95,0.10879999999999999,null,969.51,56.91,0.10879999999999999,null,10298.36,20770.29,1090.6099999999999,21.36]
[7399.43,594.21,0.16,null,3651.01,293.25,0.16,null,1703.81,136.85,0.16,null,20770.3,32736.83,3327.42,23.52]
[8601.51,786.54,0.1792,null,4244.1099999999997,388.05,0.1792,null,1980.59,181.09,0.1792,null,32736.84,62500,6141.95,30]
[10298.36,1090.6099999999999,0.21360000000000001,null,5081.41,538.20000000000005,0.21360000000000001,null,2371.33,251.16,0.21360000000000001,null,62500.01,83333.33,15070.9,32]
[20770.3,3327.42,0.23519999999999999,null,10248.459999999999,1641.75,0.23519999999999999,null,4782.62,766.15,0.23519999999999999,null,83333.34,250000,21737.57,34]
[32736.84,6141.95,0.3,null,16153.06,3030.6,0.3,null,7538.1,1414.28,0.3,null,250000.01,"En adelante",78404.23,35]
[62500.01,15070.9,0.32,null,30838.81,7436.25,0.32,null,14391.45,3470.25,0.32]
[83333.34,21737.57,0.34,null,41118.46,10725.75,0.34,null,19188.62,5005.3500000000004,0.34]
[250000.01,78404.23,0.35,null,123355.21,38686.35,0.35,null,57565.77,18053.63,0.35]
[]
[]
[null,null,null,null,null,null,null,null," "]
[]
["SUBSIDIO PARA EL EMPLEO",null,null,null,"SUBSIDIO PARA EL EMPLEO",null,null,null,"SUBSIDIO PARA EL EMPLEO"]
[{"$f":"+A2","v":2015},null,null,null,{"$f":"+E2","v":2015},null,null,null,{"$f":"+I2","v":2015},null,null,0.01,1768.96,407.02]
["Para","SE",null,null,"Para","SE",null,null,"Para","SE",null,1768.97,2653.38,406.83]
["Ingresos","Mensual",null,null,"Ingresos","Quincenal",null,null,"Ingresos","Semanal",null,2653.39,3472.84,406.62]
[0.01,407.02,null,null,0.01,200.85,null,null,0.01,93.73,null,3472.85,3537.87,392.77]
[1768.97,406.83,null,null,872.86,200.7,null,null,407.34,93.66,null,3537.88,4446.1499999999996,382.46]
[2653.39,406.62,null,null,1309.21,200.7,null,null,610.97,93.66,null,4446.16,4717.18,354.23]
[3472.85,392.77,null,null,1713.61,193.8,null,null,799.69,90.44,null,4717.1899999999996,5335.42,324.87]
[3537.88,382.46,null,null,1745.71,188.7,null,null,814.67,88.06,null,5335.43,6224.67,294.63]
[4446.16,354.23,null,null,2193.7600000000002,174.75,null,null,1023.76,81.55,null,6224.68,7113.9,253.54]
[4717.1899999999996,324.87,null,null,2327.56,160.35,null,null,1086.2,74.83,null,7113.91,7382.33,217.61]
[5335.43,294.63,null,null,2632.66,145.35,null,null,1228.58,67.83,null,7382.34,"En adelante",0]
[6224.68,253.54,null,null,3071.41,125.1,null,null,1433.33,58.38]
[7113.91,217.61,null,null,3510.16,107.4,null,null,1638.08,50.12]
[7382.34,0,null,null,3642.61,0,null,null,1699.89,0]
[]
[]
[]
["CAPITULO","PARTIDA","CONCEC",null,"DEPENDENCIA"]
[1,1,1,"SALA DE REGIDORES"]
[1,2,2,"PRESIDENCIA MUNICIPAL"]
[1,5,3,"SECRETARIA GENERAL Y SINDICATURA"]
[1,6,4,"OFICIALIA MAYOR"]
[1,7,5,"DEPARTAMENTO JURIDICO"]
[1,14,6,"REGISTRO CIVIL"]
[1,16,7,"OFICIALIA MAYOR DE CULTURA"]
[1,19,8,"PARTICIPACION CIUDADANA"]
[1,23,9,"RELACIONES EXTERIORES"]
["2","1",10,"DELEGACIONES"]
["2","2",11,"AGENCIAS"]
["3","1",12,"HACIENDA MUNICIPAL"]
["3","3",13,"DEPTO. DE INGRESOS"]
["3","7",14,"DEPTO. DE EGRESOS"]
["3","12",15,"DEPTO. DE INFORMATICA"]
["3","13",16,"DEPTO. DE IMPUESTO PREDIAL Y CATASTRO"]
["4","1",17,"DIRECCION GENERAL DE OBRAS PUBLICAS"]
["4","3",18,"DEPTO. DE SERVICIOS PUBLICOS"]
["4","4",19,"DEPTO. DE CONSTRUCCION"]
["5","2",20,"DEPTO. DE CEMENTERIOS"]
["5","3",21,"DEPTO. RASTRO"]
["5","5",22,"DEPTO. MERCADOS"]
["5","7",23,"DEPTO. DE ASEO PUBLICO"]
["5","8",24,"DEPTO. DE PARQUES Y JARDINES"]
["5","9",25,"VERTEDERO"]
["5","10",26,"DEPTO. DE ALUMBRADO PUBLICO"]
["5","11",27,"DEPTO. DE AGUA DRENAJE Y ALCANTARILLADO"]
["5","14",28,"DIR. DE TURISMO Y DEPORTES"]
["5","15",29,"SERVICIO MEDICO"]
["5","26",30,"INSPECCION AGRICOLA Y GANADERA"]
["11","17",31,"SEGURIDAD PUBLICA"]
["11","18",32,"PROTECCION CIVIL"]

{"sheet":"Hoja1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}