{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1A DE ENERO 2016","Tablas 2015","Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"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 ENERO 2016","index":0,"n_rows":313,"n_cols":38,"rows_kept":313,"cut":false,"hidden":false,"merged":[[3,1,3,36],[4,1,4,36],[208,33,208,36],[209,33,209,36],[2,0,2,36],[267,3,267,4],[267,15,267,23],[267,33,267,36],[208,3,208,4],[209,3,209,4],[209,15,209,23],[208,15,208,23],[266,3,266,4],[266,15,266,23],[266,33,266,36],[292,3,292,4],[292,15,292,23],[292,33,292,36],[293,3,293,4],[293,15,293,23],[293,33,293,36],[311,3,311,4],[311,15,311,23],[311,33,311,36],[312,3,312,4],[312,15,312,23],[312,33,312,36]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,T9:T262)","v":0},38684.353666666626,1740795.9,69631.830000000016,121854.48000000019,0,191486.31000000003,1740795.9,1932282.2099999988,null,{"$f":"SUBTOTAL(9,AD9:AD262)","v":12198},{"$f":"SUBTOTAL(9,AE9:AE262)","v":0},{"$f":"SUBTOTAL(9,AF9:AF241)","v":126392.31245599994},{"$f":"SUBTOTAL(9,AG9:AG262)","v":151415.63999999981},{"$f":"SUBTOTAL(9,AH9:AH262)","v":5327.4600000000009},{"$f":"SUBTOTAL(9,AI9:AI262)","v":1773996.0300000007},null,{"$f":"SUBTOTAL(9,AK9:AK241)","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},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["H. AYUNTAMIENTO DE ETZATLAN, JALISCO"]
[null,"ADMINISTRACION 2015-2018"]
[null,"NOMINA CORRESPONDIENTE A LA PRIMERA QUINCENA DE ENERO DE 2016"]
[null,null,null,"Etzatlán, Jalisco a 15 de Enero 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","nomina","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},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[2,null,null,"COVARRUBIAS VALENCIA JOSE",null,null,null,"REGIDOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"16688/30","v":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,null,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,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,null,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},1235.08,{"$f":"TRUNC(IF(AF11<0.01,-AF11,0),2)","v":0},{"$f":"AB11-AD11-AE11-AG11+AH11","v":8026.76},{"$f":"#REF!","v":{"$error":"#REF!"}},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,null,0,1235.0892240000003,1235.08,0,8026.76,{"$f":"#REF!","v":{"$error":"#REF!"}},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,null,0,1235.0892240000003,1235.08,0,8026.76,{"$f":"#REF!","v":{"$error":"#REF!"}},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,{"$f":"#REF!","v":{"$error":"#REF!"}},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,{"$f":"#REF!","v":{"$error":"#REF!"}},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,{"$f":"#REF!","v":{"$error":"#REF!"}},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,{"$f":"#REF!","v":{"$error":"#REF!"}},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},3003.84,5256.72,0,8260.56,75096,83356.559999999983,0,0,0,11115.803016000002,11115.72,0,72240.840000000011,{"$error":"#REF!"},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,null,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,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,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},{"$f":"#REF!","v":{"$error":"#REF!"}},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},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},{"$f":"#REF!","v":{"$error":"#REF!"}},null,14]
[14,1,1,"MEDINA FLORES EVERARDO",null,null,"2012-10-01","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,null,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},null,null,15]
[15,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(U29*P29,2)","v":2857},{"$f":"TRUNC(U29*P29*0.04,2)","v":114.28},{"$f":"TRUNC(U29*0.07*P29,2)","v":199.99},{"$f":"S29","v":0},{"$f":"TRUNC(X29+W29+(IF(Y29>519,519,Y29))+IF(R29=0,0,R29*U29),2)","v":314.27},{"$f":"TRUNC((IF(R29=0,P29*U29,(P29-R29)*U29))+(IF(Y29<519,0,Y29-519)),2)+T29","v":2857},{"$f":"Z29+AA29","v":3171.27},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":61.408511999999973},{"$f":"TRUNC(IF(AF29>0.01,AF29,0),2)","v":61.4},{"$f":"TRUNC(IF(AF29<0.01,-AF29,0),2)","v":0},{"$f":"AB29-AD29-AE29-AG29+AH29","v":3109.87},null,null,16]
[16,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(U30*P30,2)","v":2857},{"$f":"TRUNC(U30*P30*0.04,2)","v":114.28},{"$f":"TRUNC(U30*0.07*P30,2)","v":199.99},{"$f":"S30","v":0},{"$f":"TRUNC(X30+W30+(IF(Y30>519,519,Y30))+IF(R30=0,0,R30*U30),2)","v":314.27},{"$f":"TRUNC((IF(R30=0,P30*U30,(P30-R30)*U30))+(IF(Y30<519,0,Y30-519)),2)+T30","v":2857},{"$f":"Z30+AA30","v":3171.27},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":61.408511999999973},{"$f":"TRUNC(IF(AF30>0.01,AF30,0),2)","v":61.4},{"$f":"TRUNC(IF(AF30<0.01,-AF30,0),2)","v":0},{"$f":"AB30-AD30-AE30-AG30+AH30","v":3109.87},{"$f":"#REF!","v":{"$error":"#REF!"}},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:V30)","v":26066.5},1042.6599999999999,1824.65,0,2867.3100000000004,26066.5,28933.81,0,0,0,{"$f":"SUM(AF27:AF30)","v":3385.7752560000004},3385.7400000000002,0,25548.07]
[]
[null,null,null,"OFICIALIA MAYOR ADMINISTRATIVA"]
[17,null,null,"LEDESMA MORAN JOSE FEDERICO",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(U34*P34,2)","v":7660.5},{"$f":"TRUNC(U34*P34*0.04,2)","v":306.42},{"$f":"TRUNC(U34*0.07*P34,2)","v":536.23},{"$f":"S34","v":0},{"$f":"TRUNC(X34+W34+(IF(Y34>519,519,Y34))+IF(R34=0,0,R34*U34),2)","v":842.65},{"$f":"TRUNC((IF(R34=0,P34*U34,(P34-R34)*U34))+(IF(Y34<519,0,Y34-519)),2)+T34","v":7660.5},{"$f":"Z34+AA34","v":8503.15},null,null,0,{"$f":"IF(U34>0.01,(AA34-VLOOKUP(AA34,quincenal,1))*VLOOKUP(AA34,quincenal,3)+VLOOKUP(AA34,quincenal,2)-VLOOKUP(AA34,subquincenal,2),0)","v":1089.0936240000001},{"$f":"TRUNC(IF(AF34>0.01,AF34,0),2)","v":1089.0899999999999},{"$f":"TRUNC(IF(AF34<0.01,-AF34,0),2)","v":0},{"$f":"AB34-AD34-AE34-AG34+AH34","v":7414.0599999999995},null,null,18]
[18,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(U35*P35,2)","v":3178},{"$f":"TRUNC(U35*P35*0.04,2)","v":127.12},{"$f":"TRUNC(U35*0.07*P35,2)","v":222.46},0,{"$f":"TRUNC(X35+W35+(IF(Y35>519,519,Y35))+IF(R35=0,0,R35*U35),2)","v":349.58},{"$f":"TRUNC((IF(R35=0,P35*U35,(P35-R35)*U35))+(IF(Y35<519,0,Y35-519)),2)+T35","v":3178},3527.58,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":116.58331199999998},116.58,0,3411,{"$f":"[2]PORTADA!$D$10","v":1},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(V34:V35)","v":10838.5},433.54,758.69,0,1192.23,10838.5,12030.73,0,0,0,1205.6769360000001,1205.6699999999998,0,10825.06,null,null,20]
[]
[null,null,null,"DEPARTAMENTO JURIDICO"]
[19,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(U39*P39,2)","v":10387},{"$f":"TRUNC(U39*P39*0.04,2)","v":415.48},{"$f":"TRUNC(U39*0.07*P39,2)","v":727.09},{"$f":"S39","v":0},{"$f":"TRUNC(X39+W39+(IF(Y39>519,519,Y39))+IF(R39=0,0,R39*U39),2)","v":1142.57},{"$f":"TRUNC((IF(R39=0,P39*U39,(P39-R39)*U39))+(IF(Y39<519,0,Y39-519)),2)+T39","v":10387},{"$f":"Z39+AA39","v":11529.57},null,500,0,{"$f":"IF(U39>0.01,(AA39-VLOOKUP(AA39,quincenal,1))*VLOOKUP(AA39,quincenal,3)+VLOOKUP(AA39,quincenal,2)-VLOOKUP(AA39,subquincenal,2),0)","v":1674.3346080000001},{"$f":"TRUNC(IF(AF39>0.01,AF39,0),2)","v":1674.33},{"$f":"TRUNC(IF(AF39<0.01,-AF39,0),2)","v":0},{"$f":"AB39-AD39-AE39-AG39+AH39","v":9355.24},{"$f":"[2]PORTADA!$D$10","v":1},null,22]
[20,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(U40*P40,2)","v":4052},{"$f":"TRUNC(U40*P40*0.04,2)","v":162.08000000000001},{"$f":"TRUNC(U40*0.07*P40,2)","v":283.64},{"$f":"S40","v":0},{"$f":"TRUNC(X40+W40+(IF(Y40>519,519,Y40))+IF(R40=0,0,R40*U40),2)","v":445.72},{"$f":"TRUNC((IF(R40=0,P40*U40,(P40-R40)*U40))+(IF(Y40<519,0,Y40-519)),2)+T40","v":4052},{"$f":"Z40+AA40","v":4497.72},null,null,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":357.40839999999997},{"$f":"TRUNC(IF(AF40>0.01,AF40,0),2)","v":357.4},{"$f":"TRUNC(IF(AF40<0.01,-AF40,0),2)","v":0},{"$f":"AB40-AD40-AE40-AG40+AH40","v":4140.3200000000006},null,null,23]
[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,500,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":4337.08},null,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(V39:V41)","v":19235.5},769.42000000000007,1346.48,0,2115.9,19235.5,21351.4,0,1000,0,2518.7812960000001,2518.7600000000002,0,17832.64]
[]
[null,null,null,"UNIDAD DE TRANSPARENCIA"]
[22,null,null,"ALDAZ VELEZ LORENZO MIGUEL","HEEG670312","HEER670312MJCRNS06","2007-01-08","DIRECTOR DE TRANSPARENCIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U45*P45,2)","v":6326.5},{"$f":"TRUNC(U45*P45*0.04,2)","v":253.06},{"$f":"TRUNC(U45*0.07*P45,2)","v":442.85},{"$f":"S45","v":0},{"$f":"TRUNC(X45+W45+(IF(Y45>519,519,Y45))+IF(R45=0,0,R45*U45),2)","v":695.91},{"$f":"TRUNC((IF(R45=0,P45*U45,(P45-R45)*U45))+(IF(Y45<519,0,Y45-519)),2)+T45","v":6326.5},{"$f":"Z45+AA45","v":7022.41},null,null,0,{"$f":"IF(U45>0.01,(AA45-VLOOKUP(AA45,quincenal,1))*VLOOKUP(AA45,quincenal,3)+VLOOKUP(AA45,quincenal,2)-VLOOKUP(AA45,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF45>0.01,AF45,0),2)","v":804.15},{"$f":"TRUNC(IF(AF45<0.01,-AF45,0),2)","v":0},{"$f":"AB45-AD45-AE45-AG45+AH45","v":6218.26},{"$f":"#REF!","v":{"$error":"#REF!"}},null,25]
[23,null,null,"MONTERO REYES 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(U46*P46,2)","v":3397.5},{"$f":"TRUNC(U46*P46*0.04,2)","v":135.9},{"$f":"TRUNC(U46*0.07*P46,2)","v":237.82},{"$f":"S46","v":0},{"$f":"TRUNC(X46+W46+(IF(Y46>519,519,Y46))+IF(R46=0,0,R46*U46),2)","v":373.72},{"$f":"TRUNC((IF(R46=0,P46*U46,(P46-R46)*U46))+(IF(Y46<519,0,Y46-519)),2)+T46","v":3397.5},{"$f":"Z46+AA46","v":3771.2200000000003},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":140.464912},{"$f":"TRUNC(IF(AF46>0.01,AF46,0),2)","v":140.46},{"$f":"TRUNC(IF(AF46<0.01,-AF46,0),2)","v":0},{"$f":"AB46-AD46-AE46-AG46+AH46","v":3630.76},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V45:V46)","v":9724},{"$f":"SUM(W45:W46)","v":388.96000000000004},680.67000000000007,0,1069.6300000000001,9724,10793.630000000001,0,0,0,944.6161360000001,944.61,0,9849.02]
[]
[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,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U50*P50,2)","v":2857},{"$f":"TRUNC(U50*P50*0.04,2)","v":114.28},{"$f":"TRUNC(U50*0.07*P50,2)","v":199.99},{"$f":"S50","v":0},{"$f":"TRUNC(X50+W50+(IF(Y50>519,519,Y50))+IF(R50=0,0,R50*U50),2)","v":314.27},{"$f":"TRUNC((IF(R50=0,P50*U50,(P50-R50)*U50))+(IF(Y50<519,0,Y50-519)),2)+T50","v":2857},{"$f":"Z50+AA50","v":3171.27},null,null,0,{"$f":"IF(U50>0.01,(AA50-VLOOKUP(AA50,quincenal,1))*VLOOKUP(AA50,quincenal,3)+VLOOKUP(AA50,quincenal,2)-VLOOKUP(AA50,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF50>0.01,AF50,0),2)","v":61.4},{"$f":"TRUNC(IF(AF50<0.01,-AF50,0),2)","v":0},{"$f":"AB50-AD50-AE50-AG50+AH50","v":3109.87},{"$f":"[2]PORTADA!$D$10","v":1},null,27]
[25,null,null,"PLASCENCIA GARCIA MIREYA ESMERALDA","PAGM780607","PAGM780607MJCLRR03",null,"OFICIAL AUX. DE REGISTRO CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5183/30","v":172.76666666666668},{"$f":"TRUNC(U51*P51,2)","v":2591.5},{"$f":"TRUNC(U51*P51*0.04,2)","v":103.66},{"$f":"TRUNC(U51*0.07*P51,2)","v":181.4},{"$f":"S51","v":0},{"$f":"TRUNC(X51+W51+(IF(Y51>519,519,Y51))+IF(R51=0,0,R51*U51),2)","v":285.06},{"$f":"TRUNC((IF(R51=0,P51*U51,(P51-R51)*U51))+(IF(Y51<519,0,Y51-519)),2)+T51","v":2591.5},{"$f":"Z51+AA51","v":2876.56},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":17.522111999999964},{"$f":"TRUNC(IF(AF51>0.01,AF51,0),2)","v":17.52},{"$f":"TRUNC(IF(AF51<0.01,-AF51,0),2)","v":0},{"$f":"AB51-AD51-AE51-AG51+AH51","v":2859.04},{"$f":"[2]PORTADA!$D$10","v":1},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(V50:V51)","v":5448.5},217.94,381.39,0,599.32999999999993,5448.5,6047.83,0,0,0,78.930623999999938,78.92,0,5968.91]
[]
[null,null,null,"OFICIALIA MAYOR DE CULTURA"]
[26,null,null,"GONZALEZ PEÑA LETICIA","MAM620222",null,null,"DIRECTOR DE CULTURA Y TURISMO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"10341/30","v":344.7},{"$f":"TRUNC(U55*P55,2)","v":5170.5},{"$f":"TRUNC(U55*P55*0.04,2)","v":206.82},{"$f":"TRUNC(U55*0.07*P55,2)","v":361.93},{"$f":"S55","v":0},{"$f":"TRUNC(X55+W55+(IF(Y55>519,519,Y55))+IF(R55=0,0,R55*U55),2)","v":568.75},{"$f":"TRUNC((IF(R55=0,P55*U55,(P55-R55)*U55))+(IF(Y55<519,0,Y55-519)),2)+T55","v":5170.5},{"$f":"Z55+AA55","v":5739.25},null,null,0,{"$f":"IF(U55>0.01,(AA55-VLOOKUP(AA55,quincenal,1))*VLOOKUP(AA55,quincenal,3)+VLOOKUP(AA55,quincenal,2)-VLOOKUP(AA55,subquincenal,2),0)","v":557.22962400000006},{"$f":"TRUNC(IF(AF55>0.01,AF55,0),2)","v":557.22},{"$f":"TRUNC(IF(AF55<0.01,-AF55,0),2)","v":0},{"$f":"AB55-AD55-AE55-AG55+AH55","v":5182.03},{"$f":"[3]PORTADA!$D$10","v":1},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,{"$f":"7203/30","v":240.1},3601.5,144.06,252.1,0,396.16,3601.5,3997.66,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":180.36011199999999},180.36,0,3817.2999999999997,{"$f":"[2]PORTADA!$D$10","v":1},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(U57*P57,2)","v":2307.5},{"$f":"TRUNC(U57*P57*0.04,2)","v":92.3},{"$f":"TRUNC(U57*0.07*P57,2)","v":161.52000000000001},{"$f":"S57","v":0},{"$f":"TRUNC(X57+W57+(IF(Y57>519,519,Y57))+IF(R57=0,0,R57*U57),2)","v":253.82},{"$f":"TRUNC((IF(R57=0,P57*U57,(P57-R57)*U57))+(IF(Y57<519,0,Y57-519)),2)+T57","v":2307.5},{"$f":"Z57+AA57","v":2561.3200000000002},null,null,null,{"$f":"IF(U57>0.01,(AA57-VLOOKUP(AA57,quincenal,1))*VLOOKUP(AA57,quincenal,3)+VLOOKUP(AA57,quincenal,2)-VLOOKUP(AA57,subquincenal,2),0)","v":-27.77708800000002},0,27.77,{"$f":"AB57-AD57-AE57-AG57+AH57","v":2589.09},null,null,33]
[29,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(U58>0.01,(AA58-VLOOKUP(AA58,quincenal,1))*VLOOKUP(AA58,quincenal,3)+VLOOKUP(AA58,quincenal,2)-VLOOKUP(AA58,subquincenal,2),0)","v":384.6884},384.68,0,4302.29,{"$f":"[2]PORTADA!$D$10","v":1},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(V55:V58)","v":15302},612.08000000000004,1071.1199999999999,0,1683.2,15302,16985.2,0,0,0,1094.5010480000001,1122.26,27.77,15890.71]
[]
[null,null,null,"DEPARTAMENTO DE COMUNICACIÓN SOCIAL"]
[30,1,19,"DIAZ PEREZ SAMUEL",null,null,null,"DIRECTOR DE PRENSA Y PUBLICIDAD",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U62*P62,2)","v":6326.5},{"$f":"TRUNC(U62*P62*0.04,2)","v":253.06},{"$f":"TRUNC(U62*0.07*P62,2)","v":442.85},{"$f":"S62","v":0},{"$f":"TRUNC(X62+W62+(IF(Y62>519,519,Y62))+IF(R62=0,0,R62*U62),2)","v":695.91},{"$f":"TRUNC((IF(R62=0,P62*U62,(P62-R62)*U62))+(IF(Y62<519,0,Y62-519)),2)+T62","v":6326.5},{"$f":"Z62+AA62","v":7022.41},null,null,0,{"$f":"IF(U62>0.01,(AA62-VLOOKUP(AA62,quincenal,1))*VLOOKUP(AA62,quincenal,3)+VLOOKUP(AA62,quincenal,2)-VLOOKUP(AA62,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF62>0.01,AF62,0),2)","v":804.15},{"$f":"TRUNC(IF(AF62<0.01,-AF62,0),2)","v":0},{"$f":"AB62-AD62-AE62-AG62+AH62","v":6218.26},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V62:V62)","v":6326.5},253.06,442.85,0,695.91,6326.5,7022.41,0,0,0,804.15122400000007,804.15,0,6218.26]
[]
[null,null,null,"DIRECCION DE EDUCACION"]
[31,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(U66*P66,2)","v":3397.5},{"$f":"TRUNC(U66*P66*0.04,2)","v":135.9},{"$f":"TRUNC(U66*0.07*P66,2)","v":237.82},{"$f":"S66","v":0},{"$f":"TRUNC(X66+W66+(IF(Y66>519,519,Y66))+IF(R66=0,0,R66*U66),2)","v":373.72},{"$f":"TRUNC((IF(R66=0,P66*U66,(P66-R66)*U66))+(IF(Y66<519,0,Y66-519)),2)+T66","v":3397.5},{"$f":"Z66+AA66","v":3771.2200000000003},null,null,0,{"$f":"IF(U66>0.01,(AA66-VLOOKUP(AA66,quincenal,1))*VLOOKUP(AA66,quincenal,3)+VLOOKUP(AA66,quincenal,2)-VLOOKUP(AA66,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF66>0.01,AF66,0),2)","v":140.46},{"$f":"TRUNC(IF(AF66<0.01,-AF66,0),2)","v":0},{"$f":"AB66-AD66-AE66-AG66+AH66","v":3630.76},null,null,41]
[32,null,null,"ESPERICUETA HERNANDEZ 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(U67*P67,2)","v":4060.5},{"$f":"TRUNC(U67*P67*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U67*0.07*P67,2)","v":284.23},{"$f":"S67","v":0},{"$f":"TRUNC(X67+W67+(IF(Y67>519,519,Y67))+IF(R67=0,0,R67*U67),2)","v":446.65},{"$f":"TRUNC((IF(R67=0,P67*U67,(P67-R67)*U67))+(IF(Y67<519,0,Y67-519)),2)+T67","v":4060.5},{"$f":"Z67+AA67","v":4507.1499999999996},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":358.76839999999999},{"$f":"TRUNC(IF(AF67>0.01,AF67,0),2)","v":358.76},{"$f":"TRUNC(IF(AF67<0.01,-AF67,0),2)","v":0},{"$f":"AB67-AD67-AE67-AG67+AH67","v":4148.3899999999994},null,null,42]
[33,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(U68*P68,2)","v":2857},{"$f":"TRUNC(U68*P68*0.04,2)","v":114.28},{"$f":"TRUNC(U68*0.07*P68,2)","v":199.99},{"$f":"S68","v":0},{"$f":"TRUNC(X68+W68+(IF(Y68>519,519,Y68))+IF(R68=0,0,R68*U68),2)","v":314.27},{"$f":"TRUNC((IF(R68=0,P68*U68,(P68-R68)*U68))+(IF(Y68<519,0,Y68-519)),2)+T68","v":2857},{"$f":"Z68+AA68","v":3171.27},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":61.408511999999973},{"$f":"TRUNC(IF(AF68>0.01,AF68,0),2)","v":61.4},{"$f":"TRUNC(IF(AF68<0.01,-AF68,0),2)","v":0},{"$f":"AB68-AD68-AE68-AG68+AH68","v":3109.87},null,null,43]
[34,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(U69*P69,2)","v":3904.3},{"$f":"TRUNC(U69*P69*0.04,2)","v":156.16999999999999},{"$f":"TRUNC(U69*0.07*P69,2)","v":273.3},{"$f":"S69","v":0},{"$f":"TRUNC(X69+W69+(IF(Y69>519,519,Y69))+IF(R69=0,0,R69*U69),2)","v":429.47},{"$f":"TRUNC((IF(R69=0,P69*U69,(P69-R69)*U69))+(IF(Y69<519,0,Y69-519)),2)+T69","v":3904.3},{"$f":"Z69+AA69","v":4333.7700000000004},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":333.77639999999997},{"$f":"TRUNC(IF(AF69>0.01,AF69,0),2)","v":333.77},{"$f":"TRUNC(IF(AF69<0.01,-AF69,0),2)","v":0},{"$f":"AB69-AD69-AE69-AG69+AH69","v":4000.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V66:V69)","v":14219.3},{"$f":"SUM(W66:W69)","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"]
[35,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(U73*P73,2)","v":7486.5},{"$f":"TRUNC(U73*P73*0.04,2)","v":299.45999999999998},{"$f":"TRUNC(U73*0.07*P73,2)","v":524.04999999999995},{"$f":"S73","v":0},{"$f":"TRUNC(X73+W73+(IF(Y73>519,519,Y73))+IF(R73=0,0,R73*U73),2)","v":823.51},{"$f":"TRUNC((IF(R73=0,P73*U73,(P73-R73)*U73))+(IF(Y73<519,0,Y73-519)),2)+T73","v":7486.5},{"$f":"Z73+AA73","v":8310.01},null,null,0,{"$f":"IF(U73>0.01,(AA73-VLOOKUP(AA73,quincenal,1))*VLOOKUP(AA73,quincenal,3)+VLOOKUP(AA73,quincenal,2)-VLOOKUP(AA73,subquincenal,2),0)","v":1051.927224},{"$f":"TRUNC(IF(AF73>0.01,AF73,0),2)","v":1051.92},{"$f":"TRUNC(IF(AF73<0.01,-AF73,0),2)","v":0},{"$f":"AB73-AD73-AE73-AG73+AH73","v":7258.09},null,null,45]
[36,null,null,"HERNANDEZ ENRIQUEZ J. FILEMON",null,null,null,"DIRECTOR DE PROMOCION ECONOMICA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"13813/30","v":460.43333333333334},6906.5,276.26,483.45,0,759.71,6906.5,7666.21,null,null,0,928.0392240000001,928.03,{"$f":"TRUNC(IF(AF74<0.01,-AF74,0),2)","v":0},6738.18,null,null,46]
[37,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(AF75<0.01,-AF75,0),2)","v":0},3442.5299999999997,null,null,47]
[{"$f":"A75+1","v":38},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(AF76<0.01,-AF76,0),2)","v":0},3624.75,{"$f":"[2]PORTADA!$D$10","v":1},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(V73:V76)","v":20994},839.76,1469.5600000000002,0,2309.3200000000002,20994,23303.320000000003,0,0,0,2239.789072,2239.77,0,21063.55]
[]
[null,null,null,"OFICINA DE ENLACE RELACIONES EXTERIORES"]
[{"$f":"A76+1","v":39},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(U80*P80,2)","v":5775},{"$f":"TRUNC(U80*P80*0.04,2)","v":231},{"$f":"TRUNC(U80*0.07*P80,2)","v":404.25},{"$f":"S80","v":0},{"$f":"TRUNC(X80+W80+(IF(Y80>519,519,Y80))+IF(R80=0,0,R80*U80),2)","v":635.25},{"$f":"TRUNC((IF(R80=0,P80*U80,(P80-R80)*U80))+(IF(Y80<519,0,Y80-519)),2)+T80","v":5775},{"$f":"Z80+AA80","v":6410.25},null,null,0,{"$f":"IF(U80>0.01,(AA80-VLOOKUP(AA80,quincenal,1))*VLOOKUP(AA80,quincenal,3)+VLOOKUP(AA80,quincenal,2)-VLOOKUP(AA80,subquincenal,2),0)","v":686.3508240000001},{"$f":"TRUNC(IF(AF80>0.01,AF80,0),2)","v":686.35},{"$f":"TRUNC(IF(AF80<0.01,-AF80,0),2)","v":0},{"$f":"AB80-AD80-AE80-AG80+AH80","v":5723.9},{"$f":"[2]PORTADA!$D$10","v":1},null,51]
[{"$f":"A80+1","v":40},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(U81*P81,2)","v":3304.5},{"$f":"TRUNC(U81*P81*0.04,2)","v":132.18},{"$f":"TRUNC(U81*0.07*P81,2)","v":231.31},{"$f":"S81","v":0},{"$f":"TRUNC(X81+W81+(IF(Y81>519,519,Y81))+IF(R81=0,0,R81*U81),2)","v":363.49},{"$f":"TRUNC((IF(R81=0,P81*U81,(P81-R81)*U81))+(IF(Y81<519,0,Y81-519)),2)+T81","v":3304.5},{"$f":"Z81+AA81","v":3667.99},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":130.34651199999999},{"$f":"TRUNC(IF(AF81>0.01,AF81,0),2)","v":130.34},{"$f":"TRUNC(IF(AF81<0.01,-AF81,0),2)","v":0},{"$f":"AB81-AD81-AE81-AG81+AH81","v":3537.6499999999996},{"$f":"[2]PORTADA!$D$10","v":1},null,52]
[{"$f":"A81+1","v":41},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(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},{"$f":"[2]PORTADA!$D$10","v":1},null,53]
[42,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(U83*P83,2)","v":3381},{"$f":"TRUNC(U83*P83*0.04,2)","v":135.24},{"$f":"TRUNC(U83*0.07*P83,2)","v":236.67},{"$f":"S83","v":0},{"$f":"TRUNC(X83+W83+(IF(Y83>519,519,Y83))+IF(R83=0,0,R83*U83),2)","v":371.91},{"$f":"TRUNC((IF(R83=0,P83*U83,(P83-R83)*U83))+(IF(Y83<519,0,Y83-519)),2)+T83","v":3381},{"$f":"Z83+AA83","v":3752.91},null,0,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":138.66971199999998},{"$f":"TRUNC(IF(AF83>0.01,AF83,0),2)","v":138.66},{"$f":"TRUNC(IF(AF83<0.01,-AF83,0),2)","v":0},{"$f":"AB83-AD83-AE83-AG83+AH83","v":3614.25},{"$f":"[2]PORTADA!$D$10","v":1},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(V80:V83)","v":15765},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":"A83+1","v":43},"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(U87*P87,2)","v":1579},{"$f":"TRUNC(U87*P87*0.04,2)","v":63.16},{"$f":"TRUNC(U87*0.07*P87,2)","v":110.53},{"$f":"S87","v":0},{"$f":"TRUNC(X87+W87+(IF(Y87>519,519,Y87))+IF(R87=0,0,R87*U87),2)","v":173.69},{"$f":"TRUNC((IF(R87=0,P87*U87,(P87-R87)*U87))+(IF(Y87<519,0,Y87-519)),2)+T87","v":1579},{"$f":"Z87+AA87","v":1752.69},null,null,0,{"$f":"IF(U87>0.01,(AA87-VLOOKUP(AA87,quincenal,1))*VLOOKUP(AA87,quincenal,3)+VLOOKUP(AA87,quincenal,2)-VLOOKUP(AA87,subquincenal,2),0)","v":-110.66183999999998},{"$f":"TRUNC(IF(AF87>0.01,AF87,0),2)","v":0},{"$f":"TRUNC(IF(AF87<0.01,-AF87,0),2)","v":110.66},{"$f":"AB87-AD87-AE87-AG87+AH87","v":1863.3500000000001},{"$f":"#REF!","v":{"$error":"#REF!"}},null,55]
[{"$f":"A87+1","v":44},"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(AF88>0.01,AF88,0),2)","v":0},{"$f":"TRUNC(IF(AF88<0.01,-AF88,0),2)","v":129.72999999999999},1551.64,{"$f":"#REF!","v":{"$error":"#REF!"}},null,56]
[{"$f":"A88+1","v":45},"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,null,0,-136.10183999999998,{"$f":"TRUNC(IF(AF89>0.01,AF89,0),2)","v":0},{"$f":"TRUNC(IF(AF89<0.01,-AF89,0),2)","v":136.1},1447.56,{"$f":"#REF!","v":{"$error":"#REF!"}},null,57]
[46,"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(AF90>0.01,AF90,0),2)","v":0},{"$f":"TRUNC(IF(AF90<0.01,-AF90,0),2)","v":123.36},1655.7099999999998,{"$f":"#REF!","v":{"$error":"#REF!"}},null,58]
[47,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(U91*P91,2)","v":1281},{"$f":"TRUNC(U91*P91*0.04,2)","v":51.24},{"$f":"TRUNC(U91*0.07*P91,2)","v":89.67},{"$f":"S91","v":0},{"$f":"TRUNC(X91+W91+(IF(Y91>519,519,Y91))+IF(R91=0,0,R91*U91),2)","v":140.91},{"$f":"TRUNC((IF(R91=0,P91*U91,(P91-R91)*U91))+(IF(Y91<519,0,Y91-519)),2)+T91","v":1281},{"$f":"Z91+AA91","v":1421.91},null,500,0,{"$f":"IF(U91>0.01,(AA91-VLOOKUP(AA91,quincenal,1))*VLOOKUP(AA91,quincenal,3)+VLOOKUP(AA91,quincenal,2)-VLOOKUP(AA91,subquincenal,2),0)","v":-129.73383999999999},0,129.72999999999999,{"$f":"AB91-AD91-AE91-AG91+AH91","v":1051.6400000000001},null,null,59]
[48,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,null,60]
[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,null,0,-85.92583999999998,0,85.92,2059.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(U94*P94,2)","v":2631},{"$f":"TRUNC(U94*P94*0.04,2)","v":105.24},{"$f":"TRUNC(U94*0.07*P94,2)","v":184.17},{"$f":"S94","v":0},{"$f":"TRUNC(X94+W94+(IF(Y94>519,519,Y94))+IF(R94=0,0,R94*U94),2)","v":289.41000000000003},{"$f":"TRUNC((IF(R94=0,P94*U94,(P94-R94)*U94))+(IF(Y94<519,0,Y94-519)),2)+T94","v":2631},{"$f":"Z94+AA94","v":2920.41},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":21.819711999999981},{"$f":"TRUNC(IF(AF94>0.01,AF94,0),2)","v":21.81},{"$f":"TRUNC(IF(AF94<0.01,-AF94,0),2)","v":0},{"$f":"AB94-AD94-AE94-AG94+AH94","v":2898.6},{"$f":"[2]PORTADA!$D$10","v":1},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(V87:V94)","v":12890},515.6,902.29,0,1417.89,12890,14307.89,0,500,0,-779.62916799999994,21.81,801.42,14587.500000000002]
[]
[null,null,null,"ADMIN ISTRACION DE LA HACIENDA MUNICIPAL"]
[{"$f":"A94+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(U98*P98,2)","v":8689},{"$f":"TRUNC(U98*P98*0.04,2)","v":347.56},{"$f":"TRUNC(U98*0.07*P98,2)","v":608.23},{"$f":"S98","v":0},{"$f":"TRUNC(X98+W98+(IF(Y98>519,519,Y98))+IF(R98=0,0,R98*U98),2)","v":955.79},{"$f":"TRUNC((IF(R98=0,P98*U98,(P98-R98)*U98))+(IF(Y98<519,0,Y98-519)),2)+T98","v":8689},{"$f":"Z98+AA98","v":9644.7900000000009},null,null,0,{"$f":"IF(U98>0.01,(AA98-VLOOKUP(AA98,quincenal,1))*VLOOKUP(AA98,quincenal,3)+VLOOKUP(AA98,quincenal,2)-VLOOKUP(AA98,subquincenal,2),0)","v":1308.7812240000001},{"$f":"TRUNC(IF(AF98>0.01,AF98,0),2)","v":1308.78},{"$f":"TRUNC(IF(AF98<0.01,-AF98,0),2)","v":0},{"$f":"AB98-AD98-AE98-AG98+AH98","v":8336.01},{"$f":"#REF!","v":{"$error":"#REF!"}},null,63]
[{"$f":"A98+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(U99*P99,2)","v":5406},{"$f":"TRUNC(U99*P99*0.04,2)","v":216.24},{"$f":"TRUNC(U99*0.07*P99,2)","v":378.42},{"$f":"S99","v":0},{"$f":"TRUNC(X99+W99+(IF(Y99>519,519,Y99))+IF(R99=0,0,R99*U99),2)","v":594.66},{"$f":"TRUNC((IF(R99=0,P99*U99,(P99-R99)*U99))+(IF(Y99<519,0,Y99-519)),2)+T99","v":5406},{"$f":"Z99+AA99","v":6000.66},null,null,0,{"$f":"IF(U99>0.01,(AA99-VLOOKUP(AA99,quincenal,1))*VLOOKUP(AA99,quincenal,3)+VLOOKUP(AA99,quincenal,2)-VLOOKUP(AA99,subquincenal,2),0)","v":607.53242400000011},{"$f":"TRUNC(IF(AF99>0.01,AF99,0),2)","v":607.53},{"$f":"TRUNC(IF(AF99<0.01,-AF99,0),2)","v":0},{"$f":"AB99-AD99-AE99-AG99+AH99","v":5393.13},null,null,64]
[{"$f":"A99+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,{"$f":"4598/30","v":153.26666666666668},{"$f":"TRUNC(U100*P100,2)","v":2299},{"$f":"TRUNC(U100*P100*0.04,2)","v":91.96},{"$f":"TRUNC(U100*0.07*P100,2)","v":160.93},{"$f":"S100","v":0},{"$f":"TRUNC(X100+W100+(IF(Y100>519,519,Y100))+IF(R100=0,0,R100*U100),2)","v":252.89},{"$f":"TRUNC((IF(R100=0,P100*U100,(P100-R100)*U100))+(IF(Y100<519,0,Y100-519)),2)+T100","v":2299},{"$f":"Z100+AA100","v":2551.89},null,null,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":-28.701888000000025},{"$f":"TRUNC(IF(AF100>0.01,AF100,0),2)","v":0},{"$f":"TRUNC(IF(AF100<0.01,-AF100,0),2)","v":28.7},{"$f":"AB100-AD100-AE100-AG100+AH100","v":2580.5899999999997}]
[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(U101*P101,2)","v":3597.5},{"$f":"TRUNC(U101*P101*0.04,2)","v":143.9},{"$f":"TRUNC(U101*0.07*P101,2)","v":251.82},{"$f":"S101","v":0},{"$f":"TRUNC(X101+W101+(IF(Y101>519,519,Y101))+IF(R101=0,0,R101*U101),2)","v":395.72},{"$f":"TRUNC((IF(R101=0,P101*U101,(P101-R101)*U101))+(IF(Y101<519,0,Y101-519)),2)+T101","v":3597.5},{"$f":"Z101+AA101","v":3993.2200000000003},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":179.92491199999998},{"$f":"TRUNC(IF(AF101>0.01,AF101,0),2)","v":179.92},{"$f":"TRUNC(IF(AF101<0.01,-AF101,0),2)","v":0},{"$f":"AB101-AD101-AE101-AG101+AH101","v":3813.3},{"$f":"#REF!","v":{"$error":"#REF!"}},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,{"$f":"5015/30","v":167.16666666666666},{"$f":"TRUNC(U102*P102,2)","v":2507.5},{"$f":"TRUNC(U102*P102*0.04,2)","v":100.3},{"$f":"TRUNC(U102*0.07*P102,2)","v":175.52},{"$f":"S102","v":0},{"$f":"TRUNC(X102+W102+(IF(Y102>519,519,Y102))+IF(R102=0,0,R102*U102),2)","v":275.82},{"$f":"TRUNC((IF(R102=0,P102*U102,(P102-R102)*U102))+(IF(Y102<519,0,Y102-519)),2)+T102","v":2507.5},{"$f":"Z102+AA102","v":2783.32},null,500,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":8.3829119999999762},{"$f":"TRUNC(IF(AF102>0.01,AF102,0),2)","v":8.3800000000000008},{"$f":"TRUNC(IF(AF102<0.01,-AF102,0),2)","v":0},{"$f":"AB102-AD102-AE102-AG102+AH102","v":2274.94},null,null,66]
[56,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(U103*P103,2)","v":4880.5},{"$f":"TRUNC(U103*P103*0.04,2)","v":195.22},{"$f":"TRUNC(U103*0.07*P103,2)","v":341.63},{"$f":"S103","v":0},{"$f":"TRUNC(X103+W103+(IF(Y103>519,519,Y103))+IF(R103=0,0,R103*U103),2)","v":536.85},{"$f":"TRUNC((IF(R103=0,P103*U103,(P103-R103)*U103))+(IF(Y103<519,0,Y103-519)),2)+T103","v":4880.5},{"$f":"Z103+AA103","v":5417.35},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":502.09108800000007},{"$f":"TRUNC(IF(AF103>0.01,AF103,0),2)","v":502.09},{"$f":"TRUNC(IF(AF103<0.01,-AF103,0),2)","v":0},{"$f":"AB103-AD103-AE103-AG103+AH103","v":4915.26},{"$f":"[2]PORTADA!$D$10","v":1},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(V98:V103)","v":27379.5},{"$f":"SUM(W98:W103)","v":1095.1799999999998},1916.5500000000002,0,3011.7299999999996,27379.5,30391.230000000003,0,500,0,2578.0106720000003,2606.7000000000003,28.7,27313.229999999996]
[]
[null,null,null,"DEPARTAMENTO DE INGRESOS"]
[{"$f":"A103+1","v":57},"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(U107*P107,2)","v":3357},{"$f":"TRUNC(U107*P107*0.04,2)","v":134.28},{"$f":"TRUNC(U107*0.07*P107,2)","v":234.99},{"$f":"S107","v":0},{"$f":"TRUNC(X107+W107+(IF(Y107>519,519,Y107))+IF(R107=0,0,R107*U107),2)","v":369.27},{"$f":"TRUNC((IF(R107=0,P107*U107,(P107-R107)*U107))+(IF(Y107<519,0,Y107-519)),2)+T107","v":3357},{"$f":"Z107+AA107","v":3726.27},null,null,0,{"$f":"IF(U107>0.01,(AA107-VLOOKUP(AA107,quincenal,1))*VLOOKUP(AA107,quincenal,3)+VLOOKUP(AA107,quincenal,2)-VLOOKUP(AA107,subquincenal,2),0)","v":136.05851199999998},{"$f":"TRUNC(IF(AF107>0.01,AF107,0),2)","v":136.05000000000001},{"$f":"TRUNC(IF(AF107<0.01,-AF107,0),2)","v":0},{"$f":"AB107-AD107-AE107-AG107+AH107","v":3590.22},{"$f":"[2]PORTADA!$D$10","v":1},null,68]
[{"$f":"A107+1","v":58},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(U108*P108,2)","v":3136.5},{"$f":"TRUNC(U108*P108*0.04,2)","v":125.46},{"$f":"TRUNC(U108*0.07*P108,2)","v":219.55},{"$f":"S108","v":0},{"$f":"TRUNC(X108+W108+(IF(Y108>519,519,Y108))+IF(R108=0,0,R108*U108),2)","v":345.01},{"$f":"TRUNC((IF(R108=0,P108*U108,(P108-R108)*U108))+(IF(Y108<519,0,Y108-519)),2)+T108","v":3136.5},{"$f":"Z108+AA108","v":3481.51},null,null,0,{"$f":"IF(U108>0.01,(AA108-VLOOKUP(AA108,quincenal,1))*VLOOKUP(AA108,quincenal,3)+VLOOKUP(AA108,quincenal,2)-VLOOKUP(AA108,subquincenal,2),0)","v":112.06811199999999},{"$f":"TRUNC(IF(AF108>0.01,AF108,0),2)","v":112.06},{"$f":"TRUNC(IF(AF108<0.01,-AF108,0),2)","v":0},{"$f":"AB108-AD108-AE108-AG108+AH108","v":3369.4500000000003},{"$f":"[2]PORTADA!$D$10","v":1},null,69]
[{"$f":"A108+1","v":59},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(U109*P109,2)","v":3169},{"$f":"TRUNC(U109*P109*0.04,2)","v":126.76},{"$f":"TRUNC(U109*0.07*P109,2)","v":221.83},{"$f":"S109","v":0},{"$f":"TRUNC(X109+W109+(IF(Y109>519,519,Y109))+IF(R109=0,0,R109*U109),2)","v":348.59},{"$f":"TRUNC((IF(R109=0,P109*U109,(P109-R109)*U109))+(IF(Y109<519,0,Y109-519)),2)+T109","v":3169},{"$f":"Z109+AA109","v":3517.59},null,null,0,{"$f":"IF(U109>0.01,(AA109-VLOOKUP(AA109,quincenal,1))*VLOOKUP(AA109,quincenal,3)+VLOOKUP(AA109,quincenal,2)-VLOOKUP(AA109,subquincenal,2),0)","v":115.60411199999996},{"$f":"TRUNC(IF(AF109>0.01,AF109,0),2)","v":115.6},{"$f":"TRUNC(IF(AF109<0.01,-AF109,0),2)","v":0},{"$f":"AB109-AD109-AE109-AG109+AH109","v":3401.9900000000002},null,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(V107:V109)","v":9662.5},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":"A109+1","v":60},"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(U113*P113,2)","v":3397.5},{"$f":"TRUNC(U113*P113*0.04,2)","v":135.9},{"$f":"TRUNC(U113*0.07*P113,2)","v":237.82},{"$f":"S113","v":0},{"$f":"TRUNC(X113+W113+(IF(Y113>519,519,Y113))+IF(R113=0,0,R113*U113),2)","v":373.72},{"$f":"TRUNC((IF(R113=0,P113*U113,(P113-R113)*U113))+(IF(Y113<519,0,Y113-519)),2)+T113","v":3397.5},{"$f":"Z113+AA113","v":3771.2200000000003},null,null,0,{"$f":"IF(U113>0.01,(AA113-VLOOKUP(AA113,quincenal,1))*VLOOKUP(AA113,quincenal,3)+VLOOKUP(AA113,quincenal,2)-VLOOKUP(AA113,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF113>0.01,AF113,0),2)","v":140.46},{"$f":"TRUNC(IF(AF113<0.01,-AF113,0),2)","v":0},{"$f":"AB113-AD113-AE113-AG113+AH113","v":3630.76},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V113)","v":3397.5},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":"A113+1","v":61},"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(U117*P117,2)","v":4060.5},{"$f":"TRUNC(U117*P117*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U117*0.07*P117,2)","v":284.23},{"$f":"S117","v":0},{"$f":"TRUNC(X117+W117+(IF(Y117>519,519,Y117))+IF(R117=0,0,R117*U117),2)","v":446.65},{"$f":"TRUNC((IF(R117=0,P117*U117,(P117-R117)*U117))+(IF(Y117<519,0,Y117-519)),2)+T117","v":4060.5},{"$f":"Z117+AA117","v":4507.1499999999996},null,null,0,{"$f":"IF(U117>0.01,(AA117-VLOOKUP(AA117,quincenal,1))*VLOOKUP(AA117,quincenal,3)+VLOOKUP(AA117,quincenal,2)-VLOOKUP(AA117,subquincenal,2),0)","v":358.76839999999999},{"$f":"TRUNC(IF(AF117>0.01,AF117,0),2)","v":358.76},{"$f":"TRUNC(IF(AF117<0.01,-AF117,0),2)","v":0},{"$f":"AB117-AD117-AE117-AG117+AH117","v":4148.3899999999994},{"$f":"#REF!","v":{"$error":"#REF!"}},null,73]
[{"$f":"A117+1","v":62},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(U118*P118,2)","v":2307.5},{"$f":"TRUNC(U118*P118*0.04,2)","v":92.3},{"$f":"TRUNC(U118*0.07*P118,2)","v":161.52000000000001},{"$f":"S118","v":0},{"$f":"TRUNC(X118+W118+(IF(Y118>519,519,Y118))+IF(R118=0,0,R118*U118),2)","v":253.82},{"$f":"TRUNC((IF(R118=0,P118*U118,(P118-R118)*U118))+(IF(Y118<519,0,Y118-519)),2)+T118","v":2307.5},{"$f":"Z118+AA118","v":2561.3200000000002},null,null,null,{"$f":"IF(U118>0.01,(AA118-VLOOKUP(AA118,quincenal,1))*VLOOKUP(AA118,quincenal,3)+VLOOKUP(AA118,quincenal,2)-VLOOKUP(AA118,subquincenal,2),0)","v":-27.77708800000002},{"$f":"TRUNC(IF(AF118>0.01,AF118,0),2)","v":0},{"$f":"TRUNC(IF(AF118<0.01,-AF118,0),2)","v":27.77},{"$f":"AB118-AD118-AE118-AG118+AH118","v":2589.09},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V117:V118)","v":6368},{"$f":"SUM(W117:W118)","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":"A118+1","v":63},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(U122*P122,2)","v":6326.5},{"$f":"TRUNC(U122*P122*0.04,2)","v":253.06},{"$f":"TRUNC(U122*0.07*P122,2)","v":442.85},{"$f":"S122","v":0},{"$f":"TRUNC(X122+W122+(IF(Y122>519,519,Y122))+IF(R122=0,0,R122*U122),2)","v":695.91},{"$f":"TRUNC((IF(R122=0,P122*U122,(P122-R122)*U122))+(IF(Y122<519,0,Y122-519)),2)+T122","v":6326.5},{"$f":"Z122+AA122","v":7022.41},null,null,0,{"$f":"IF(U122>0.01,(AA122-VLOOKUP(AA122,quincenal,1))*VLOOKUP(AA122,quincenal,3)+VLOOKUP(AA122,quincenal,2)-VLOOKUP(AA122,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF122>0.01,AF122,0),2)","v":804.15},{"$f":"TRUNC(IF(AF122<0.01,-AF122,0),2)","v":0},{"$f":"AB122-AD122-AE122-AG122+AH122","v":6218.26},null,null,75]
[{"$f":"A122+1","v":64},"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(U123*P123,2)","v":4275.5},{"$f":"TRUNC(U123*P123*0.04,2)","v":171.02},{"$f":"TRUNC(U123*0.07*P123,2)","v":299.27999999999997},{"$f":"S123","v":0},{"$f":"TRUNC(X123+W123+(IF(Y123>519,519,Y123))+IF(R123=0,0,R123*U123),2)","v":470.3},{"$f":"TRUNC((IF(R123=0,P123*U123,(P123-R123)*U123))+(IF(Y123<519,0,Y123-519)),2)+T123","v":4275.5},{"$f":"Z123+AA123","v":4745.8},null,null,0,{"$f":"IF(U123>0.01,(AA123-VLOOKUP(AA123,quincenal,1))*VLOOKUP(AA123,quincenal,3)+VLOOKUP(AA123,quincenal,2)-VLOOKUP(AA123,subquincenal,2),0)","v":393.67508800000007},{"$f":"TRUNC(IF(AF123>0.01,AF123,0),2)","v":393.67},{"$f":"TRUNC(IF(AF123<0.01,-AF123,0),2)","v":0},{"$f":"AB123-AD123-AE123-AG123+AH123","v":4352.13},{"$f":"#REF!","v":{"$error":"#REF!"}},null,76]
[{"$f":"A123+1","v":65},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(U124>0.01,(AA124-VLOOKUP(AA124,quincenal,1))*VLOOKUP(AA124,quincenal,3)+VLOOKUP(AA124,quincenal,2)-VLOOKUP(AA124,subquincenal,2),0)","v":-28.701888000000025},{"$f":"TRUNC(IF(AF124>0.01,AF124,0),2)","v":0},{"$f":"TRUNC(IF(AF124<0.01,-AF124,0),2)","v":28.7},2580.5899999999997,null,null,77]
[66,null,null,"ORTEGA CRUZ ERIKA NARSEDALIA",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(U125*P125,2)","v":2299},{"$f":"TRUNC(U125*P125*0.04,2)","v":91.96},{"$f":"TRUNC(U125*0.07*P125,2)","v":160.93},{"$f":"S125","v":0},{"$f":"TRUNC(X125+W125+(IF(Y125>519,519,Y125))+IF(R125=0,0,R125*U125),2)","v":252.89},{"$f":"TRUNC((IF(R125=0,P125*U125,(P125-R125)*U125))+(IF(Y125<519,0,Y125-519)),2)+T125","v":2299},{"$f":"Z125+AA125","v":2551.89},null,null,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":-28.701888000000025},{"$f":"TRUNC(IF(AF125>0.01,AF125,0),2)","v":0},{"$f":"TRUNC(IF(AF125<0.01,-AF125,0),2)","v":28.7},{"$f":"AB125-AD125-AE125-AG125+AH125","v":2580.5899999999997},null,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(V122:V125)","v":15200},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":"A125+1","v":67},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(U129*P129,2)","v":7660.5},{"$f":"TRUNC(U129*P129*0.04,2)","v":306.42},{"$f":"TRUNC(U129*0.07*P129,2)","v":536.23},{"$f":"S129","v":0},{"$f":"TRUNC(X129+W129+(IF(Y129>519,519,Y129))+IF(R129=0,0,R129*U129),2)","v":842.65},{"$f":"TRUNC((IF(R129=0,P129*U129,(P129-R129)*U129))+(IF(Y129<519,0,Y129-519)),2)+T129","v":7660.5},{"$f":"Z129+AA129","v":8503.15},null,null,0,{"$f":"IF(U129>0.01,(AA129-VLOOKUP(AA129,quincenal,1))*VLOOKUP(AA129,quincenal,3)+VLOOKUP(AA129,quincenal,2)-VLOOKUP(AA129,subquincenal,2),0)","v":1089.0936240000001},{"$f":"TRUNC(IF(AF129>0.01,AF129,0),2)","v":1089.0899999999999},{"$f":"TRUNC(IF(AF129<0.01,-AF129,0),2)","v":0},{"$f":"AB129-AD129-AE129-AG129+AH129","v":7414.0599999999995},{"$f":"#REF!","v":{"$error":"#REF!"}},null,79]
[{"$f":"A129+1","v":68},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(U130*P130,2)","v":4611.5},{"$f":"TRUNC(U130*P130*0.04,2)","v":184.46},{"$f":"TRUNC(U130*0.07*P130,2)","v":322.8},{"$f":"S130","v":0},{"$f":"TRUNC(X130+W130+(IF(Y130>519,519,Y130))+IF(R130=0,0,R130*U130),2)","v":507.26},{"$f":"TRUNC((IF(R130=0,P130*U130,(P130-R130)*U130))+(IF(Y130<519,0,Y130-519)),2)+T130","v":4611.5},{"$f":"Z130+AA130","v":5118.76},null,null,0,{"$f":"IF(U130>0.01,(AA130-VLOOKUP(AA130,quincenal,1))*VLOOKUP(AA130,quincenal,3)+VLOOKUP(AA130,quincenal,2)-VLOOKUP(AA130,subquincenal,2),0)","v":453.88628800000004},{"$f":"TRUNC(IF(AF130>0.01,AF130,0),2)","v":453.88},{"$f":"TRUNC(IF(AF130<0.01,-AF130,0),2)","v":0},{"$f":"AB130-AD130-AE130-AG130+AH130","v":4664.88},null,null,80]
[{"$f":"A130+1","v":69},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(U131*P131,2)","v":3565},{"$f":"TRUNC(U131*P131*0.04,2)","v":142.6},{"$f":"TRUNC(U131*0.07*P131,2)","v":249.55},{"$f":"S131","v":0},{"$f":"TRUNC(X131+W131+(IF(Y131>519,519,Y131))+IF(R131=0,0,R131*U131),2)","v":392.15},{"$f":"TRUNC((IF(R131=0,P131*U131,(P131-R131)*U131))+(IF(Y131<519,0,Y131-519)),2)+T131","v":3565},{"$f":"Z131+AA131","v":3957.15},null,null,0,{"$f":"IF(U131>0.01,(AA131-VLOOKUP(AA131,quincenal,1))*VLOOKUP(AA131,quincenal,3)+VLOOKUP(AA131,quincenal,2)-VLOOKUP(AA131,subquincenal,2),0)","v":176.38891199999998},{"$f":"TRUNC(IF(AF131>0.01,AF131,0),2)","v":176.38},{"$f":"TRUNC(IF(AF131<0.01,-AF131,0),2)","v":0},{"$f":"AB131-AD131-AE131-AG131+AH131","v":3780.77},null,null,81]
[70,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(U132*P132,2)","v":2857},{"$f":"TRUNC(U132*P132*0.04,2)","v":114.28},{"$f":"TRUNC(U132*0.07*P132,2)","v":199.99},{"$f":"S132","v":0},{"$f":"TRUNC(X132+W132+(IF(Y132>519,519,Y132))+IF(R132=0,0,R132*U132),2)","v":314.27},{"$f":"TRUNC((IF(R132=0,P132*U132,(P132-R132)*U132))+(IF(Y132<519,0,Y132-519)),2)+T132","v":2857},{"$f":"Z132+AA132","v":3171.27},null,null,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":61.408511999999973},{"$f":"TRUNC(IF(AF132>0.01,AF132,0),2)","v":61.4},{"$f":"TRUNC(IF(AF132<0.01,-AF132,0),2)","v":0},{"$f":"AB132-AD132-AE132-AG132+AH132","v":3109.87},null,null,94]
[71,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(U133*P133,2)","v":4708},{"$f":"TRUNC(U133*P133*0.04,2)","v":188.32},{"$f":"TRUNC(U133*0.07*P133,2)","v":329.56},{"$f":"S133","v":0},{"$f":"TRUNC(X133+W133+(IF(Y133>519,519,Y133))+IF(R133=0,0,R133*U133),2)","v":517.88},{"$f":"TRUNC((IF(R133=0,P133*U133,(P133-R133)*U133))+(IF(Y133<519,0,Y133-519)),2)+T133","v":4708},{"$f":"Z133+AA133","v":5225.88},null,1000,null,{"$f":"IF(U133>0.01,(AA133-VLOOKUP(AA133,quincenal,1))*VLOOKUP(AA133,quincenal,3)+VLOOKUP(AA133,quincenal,2)-VLOOKUP(AA133,subquincenal,2),0)","v":471.17908800000009},{"$f":"TRUNC(IF(AF133>0.01,AF133,0),2)","v":471.17},{"$f":"TRUNC(IF(AF133<0.01,-AF133,0),2)","v":0},{"$f":"AB133-AD133-AE133-AG133+AH133","v":3754.71},null,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(V129:V133)","v":23402},936.07999999999993,1638.1299999999999,0,2574.21,23402,25976.210000000003,0,1000,0,2251.956424,2251.92,0,22724.289999999997]
[null,null,null,"DIRECCION GENERAL  DE OBRAS PUBLICAS"]
[{"$f":"A133+1","v":72},"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(U136*P136,2)","v":7486.5},{"$f":"TRUNC(U136*P136*0.04,2)","v":299.45999999999998},{"$f":"TRUNC(U136*0.07*P136,2)","v":524.04999999999995},{"$f":"S136","v":0},{"$f":"TRUNC(X136+W136+(IF(Y136>519,519,Y136))+IF(R136=0,0,R136*U136),2)","v":823.51},{"$f":"TRUNC((IF(R136=0,P136*U136,(P136-R136)*U136))+(IF(Y136<519,0,Y136-519)),2)+T136","v":7486.5},{"$f":"Z136+AA136","v":8310.01},null,null,0,{"$f":"IF(U136>0.01,(AA136-VLOOKUP(AA136,quincenal,1))*VLOOKUP(AA136,quincenal,3)+VLOOKUP(AA136,quincenal,2)-VLOOKUP(AA136,subquincenal,2),0)","v":1051.927224},{"$f":"TRUNC(IF(AF136>0.01,AF136,0),2)","v":1051.92},{"$f":"TRUNC(IF(AF136<0.01,-AF136,0),2)","v":0},{"$f":"AB136-AD136-AE136-AG136+AH136","v":7258.09},{"$f":"#REF!","v":{"$error":"#REF!"}},null,97]
[{"$f":"A136+1","v":73},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(U137*P137,2)","v":5170.5},{"$f":"TRUNC(U137*P137*0.04,2)","v":206.82},{"$f":"TRUNC(U137*0.07*P137,2)","v":361.93},{"$f":"S137","v":0},{"$f":"TRUNC(X137+W137+(IF(Y137>519,519,Y137))+IF(R137=0,0,R137*U137),2)","v":568.75},{"$f":"TRUNC((IF(R137=0,P137*U137,(P137-R137)*U137))+(IF(Y137<519,0,Y137-519)),2)+T137","v":5170.5},{"$f":"Z137+AA137","v":5739.25},null,null,0,{"$f":"IF(U137>0.01,(AA137-VLOOKUP(AA137,quincenal,1))*VLOOKUP(AA137,quincenal,3)+VLOOKUP(AA137,quincenal,2)-VLOOKUP(AA137,subquincenal,2),0)","v":557.22962400000006},{"$f":"TRUNC(IF(AF137>0.01,AF137,0),2)","v":557.22},{"$f":"TRUNC(IF(AF137<0.01,-AF137,0),2)","v":0},{"$f":"AB137-AD137-AE137-AG137+AH137","v":5182.03},null,null,98]
[{"$f":"A137+1","v":74},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(U138>0.01,(AA138-VLOOKUP(AA138,quincenal,1))*VLOOKUP(AA138,quincenal,3)+VLOOKUP(AA138,quincenal,2)-VLOOKUP(AA138,subquincenal,2),0)","v":331.5684},331.56,0,3986.89,{"$f":"[2]PORTADA!$D$10","v":1},null,99]
[75,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,{"$f":"[2]PORTADA!$D$10","v":1},null,100]
[null,null,null,{"$f":"D135","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(V136:V139)","v":21108},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":"A139+1","v":76},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(U143*P143,2)","v":3397.5},{"$f":"TRUNC(U143*P143*0.04,2)","v":135.9},{"$f":"TRUNC(U143*0.07*P143,2)","v":237.82},{"$f":"S143","v":0},{"$f":"TRUNC(X143+W143+(IF(Y143>519,519,Y143))+IF(R143=0,0,R143*U143),2)","v":373.72},{"$f":"TRUNC((IF(R143=0,P143*U143,(P143-R143)*U143))+(IF(Y143<519,0,Y143-519)),2)+T143","v":3397.5},{"$f":"Z143+AA143","v":3771.2200000000003},null,null,0,{"$f":"IF(U143>0.01,(AA143-VLOOKUP(AA143,quincenal,1))*VLOOKUP(AA143,quincenal,3)+VLOOKUP(AA143,quincenal,2)-VLOOKUP(AA143,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF143>0.01,AF143,0),2)","v":140.46},{"$f":"TRUNC(IF(AF143<0.01,-AF143,0),2)","v":0},{"$f":"AB143-AD143-AE143-AG143+AH143","v":3630.76},null,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(V143:V143)","v":3397.5},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":"A143+1","v":77},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(U147*P147,2)","v":2461.5},{"$f":"TRUNC(U147*P147*0.04,2)","v":98.46},{"$f":"TRUNC(U147*0.07*P147,2)","v":172.3},{"$f":"S147","v":0},{"$f":"TRUNC(X147+W147+(IF(Y147>519,519,Y147))+IF(R147=0,0,R147*U147),2)","v":270.76},{"$f":"TRUNC((IF(R147=0,P147*U147,(P147-R147)*U147))+(IF(Y147<519,0,Y147-519)),2)+T147","v":2461.5},{"$f":"Z147+AA147","v":2732.26},null,null,0,{"$f":"IF(U147>0.01,(AA147-VLOOKUP(AA147,quincenal,1))*VLOOKUP(AA147,quincenal,3)+VLOOKUP(AA147,quincenal,2)-VLOOKUP(AA147,subquincenal,2),0)","v":3.3781119999999873},{"$f":"TRUNC(IF(AF147>0.01,AF147,0),2)","v":3.37},{"$f":"TRUNC(IF(AF147<0.01,-AF147,0),2)","v":0},{"$f":"AB147-AD147-AE147-AG147+AH147","v":2728.8900000000003},{"$f":"[2]PORTADA!$D$10","v":1},null,107]
[{"$f":"A147+1","v":78},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(U148*P148,2)","v":3816},{"$f":"TRUNC(U148*P148*0.04,2)","v":152.63999999999999},{"$f":"TRUNC(U148*0.07*P148,2)","v":267.12},{"$f":"S148","v":0},{"$f":"TRUNC(X148+W148+(IF(Y148>519,519,Y148))+IF(R148=0,0,R148*U148),2)","v":419.76},{"$f":"TRUNC((IF(R148=0,P148*U148,(P148-R148)*U148))+(IF(Y148<519,0,Y148-519)),2)+T148","v":3816},{"$f":"Z148+AA148","v":4235.76},null,null,0,{"$f":"IF(U148>0.01,(AA148-VLOOKUP(AA148,quincenal,1))*VLOOKUP(AA148,quincenal,3)+VLOOKUP(AA148,quincenal,2)-VLOOKUP(AA148,subquincenal,2),0)","v":319.64839999999998},{"$f":"TRUNC(IF(AF148>0.01,AF148,0),2)","v":319.64},{"$f":"TRUNC(IF(AF148<0.01,-AF148,0),2)","v":0},{"$f":"AB148-AD148-AE148-AG148+AH148","v":3916.1200000000003},{"$f":"[2]PORTADA!$D$10","v":1},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(V147:V148)","v":6277.5},251.09999999999997,439.42,0,690.52,6277.5,6968.02,0,0,0,323.02651199999997,323.01,0,6645.01,2,0]
[]
[]
[null,null,null,"DEPARTAMENTO DE ASEO PUBLICO"]
[{"$f":"A148+1","v":79},"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,{"$f":"6130/30","v":204.33333333333334},{"$f":"TRUNC(U153*P153,2)","v":3065},{"$f":"TRUNC(U153*P153*0.04,2)","v":122.6},{"$f":"TRUNC(U153*0.07*P153,2)","v":214.55},{"$f":"S153","v":0},{"$f":"TRUNC(X153+W153+(IF(Y153>519,519,Y153))+IF(R153=0,0,R153*U153),2)","v":337.15},{"$f":"TRUNC((IF(R153=0,P153*U153,(P153-R153)*U153))+(IF(Y153<519,0,Y153-519)),2)+T153","v":3065},{"$f":"Z153+AA153","v":3402.15},null,null,0,{"$f":"IF(U153>0.01,(AA153-VLOOKUP(AA153,quincenal,1))*VLOOKUP(AA153,quincenal,3)+VLOOKUP(AA153,quincenal,2)-VLOOKUP(AA153,subquincenal,2),0)","v":84.038911999999982},{"$f":"TRUNC(IF(AF153>0.01,AF153,0),2)","v":84.03},{"$f":"TRUNC(IF(AF153<0.01,-AF153,0),2)","v":0},{"$f":"AB153-AD153-AE153-AG153+AH153","v":3318.12},{"$f":"#REF!","v":{"$error":"#REF!"}},null,112]
[{"$f":"A153+1","v":80},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},2311,92.44,161.77000000000001,0,254.21,2311,2565.21,null,null,0,{"$f":"IF(U154>0.01,(AA154-VLOOKUP(AA154,quincenal,1))*VLOOKUP(AA154,quincenal,3)+VLOOKUP(AA154,quincenal,2)-VLOOKUP(AA154,subquincenal,2),0)","v":-27.396288000000027},0,27.39,2592.6,{"$f":"[2]PORTADA!$D$10","v":1},null,113]
[{"$f":"A154+1","v":81},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,{"$f":"[2]PORTADA!$D$10","v":1},null,114]
[{"$f":"A155+1","v":82},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,{"$f":"[2]PORTADA!$D$10","v":1},null,115]
[83,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":"S157","v":0},254.21,2311,{"$f":"Z157+AA157","v":2565.21},null,0,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},0,{"$f":"TRUNC(IF(AF157<0.01,-AF157,0),2)","v":27.39},{"$f":"AB157-AD157-AE157-AG157+AH157","v":2592.6},null,null,116]
[84,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,{"$f":"[2]PORTADA!$D$10","v":1},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(V153:V158)","v":14620},584.79999999999995,1023.4,0,1608.2,14620,16228.199999999997,0,0,0,-52.942528000000152,84.03,136.94999999999999,16281.12]
[]
[null,null,null,"DEPARTAMENTO DE PARQUES Y JARDINES"]
[{"$f":"A158+1","v":85},"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(U162*P162,2)","v":3065},{"$f":"TRUNC(U162*P162*0.04,2)","v":122.6},{"$f":"TRUNC(U162*0.07*P162,2)","v":214.55},{"$f":"S162","v":0},{"$f":"TRUNC(X162+W162+(IF(Y162>519,519,Y162))+IF(R162=0,0,R162*U162),2)","v":337.15},{"$f":"TRUNC((IF(R162=0,P162*U162,(P162-R162)*U162))+(IF(Y162<519,0,Y162-519)),2)+T162","v":3065},{"$f":"Z162+AA162","v":3402.15},null,null,0,{"$f":"IF(U162>0.01,(AA162-VLOOKUP(AA162,quincenal,1))*VLOOKUP(AA162,quincenal,3)+VLOOKUP(AA162,quincenal,2)-VLOOKUP(AA162,subquincenal,2),0)","v":84.038911999999982},{"$f":"TRUNC(IF(AF162>0.01,AF162,0),2)","v":84.03},{"$f":"TRUNC(IF(AF162<0.01,-AF162,0),2)","v":0},{"$f":"AB162-AD162-AE162-AG162+AH162","v":3318.12},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V162:V162)","v":3065},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":"A162+1","v":86},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(U166*P166,2)","v":3565},{"$f":"TRUNC(U166*P166*0.04,2)","v":142.6},{"$f":"TRUNC(U166*0.07*P166,2)","v":249.55},{"$f":"S166","v":0},{"$f":"TRUNC(X166+W166+(IF(Y166>519,519,Y166))+IF(R166=0,0,R166*U166),2)","v":392.15},{"$f":"TRUNC((IF(R166=0,P166*U166,(P166-R166)*U166))+(IF(Y166<519,0,Y166-519)),2)+T166","v":3565},{"$f":"Z166+AA166","v":3957.15},null,null,0,{"$f":"IF(U166>0.01,(AA166-VLOOKUP(AA166,quincenal,1))*VLOOKUP(AA166,quincenal,3)+VLOOKUP(AA166,quincenal,2)-VLOOKUP(AA166,subquincenal,2),0)","v":176.38891199999998},{"$f":"TRUNC(IF(AF166>0.01,AF166,0),2)","v":176.38},{"$f":"TRUNC(IF(AF166<0.01,-AF166,0),2)","v":0},{"$f":"AB166-AD166-AE166-AG166+AH166","v":3780.77},{"$f":"[2]PORTADA!$D$10","v":1},null,131]
[{"$f":"A166+1","v":87},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(U167*P167,2)","v":3397.5},{"$f":"TRUNC(U167*P167*0.04,2)","v":135.9},{"$f":"TRUNC(U167*0.07*P167,2)","v":237.82},{"$f":"S167","v":0},{"$f":"TRUNC(X167+W167+(IF(Y167>519,519,Y167))+IF(R167=0,0,R167*U167),2)","v":373.72},{"$f":"TRUNC((IF(R167=0,P167*U167,(P167-R167)*U167))+(IF(Y167<519,0,Y167-519)),2)+T167","v":3397.5},{"$f":"Z167+AA167","v":3771.2200000000003},null,null,0,{"$f":"IF(U167>0.01,(AA167-VLOOKUP(AA167,quincenal,1))*VLOOKUP(AA167,quincenal,3)+VLOOKUP(AA167,quincenal,2)-VLOOKUP(AA167,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF167>0.01,AF167,0),2)","v":140.46},{"$f":"TRUNC(IF(AF167<0.01,-AF167,0),2)","v":0},{"$f":"AB167-AD167-AE167-AG167+AH167","v":3630.76},null,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(V166:V167)","v":6962.5},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":"A167+1","v":88},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(U172*P172,2)","v":2307.5},{"$f":"TRUNC(U172*P172*0.04,2)","v":92.3},{"$f":"TRUNC(U172*0.07*P172,2)","v":161.52000000000001},{"$f":"S172","v":0},{"$f":"TRUNC(X172+W172+(IF(Y172>519,519,Y172))+IF(R172=0,0,R172*U172),2)","v":253.82},{"$f":"TRUNC((IF(R172=0,P172*U172,(P172-R172)*U172))+(IF(Y172<519,0,Y172-519)),2)+T172","v":2307.5},{"$f":"Z172+AA172","v":2561.3200000000002},null,null,0,{"$f":"IF(U172>0.01,(AA172-VLOOKUP(AA172,quincenal,1))*VLOOKUP(AA172,quincenal,3)+VLOOKUP(AA172,quincenal,2)-VLOOKUP(AA172,subquincenal,2),0)","v":-27.77708800000002},{"$f":"TRUNC(IF(AF172>0.01,AF172,0),2)","v":0},{"$f":"TRUNC(IF(AF172<0.01,-AF172,0),2)","v":27.77},{"$f":"AB172-AD172-AE172-AG172+AH172","v":2589.09},null,null,135]
[{"$f":"A172+1","v":89},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(U173>0.01,(AA173-VLOOKUP(AA173,quincenal,1))*VLOOKUP(AA173,quincenal,3)+VLOOKUP(AA173,quincenal,2)-VLOOKUP(AA173,subquincenal,2),0)","v":-110.66183999999998},{"$f":"TRUNC(IF(AF173>0.01,AF173,0),2)","v":0},110.66,1863.3500000000001,{"$f":"[2]PORTADA!$D$10","v":1},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(V172:V173)","v":3886.5},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":"A173+1","v":90},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(U177*P177,2)","v":3779.5},{"$f":"TRUNC(U177*P177*0.04,2)","v":151.18},{"$f":"TRUNC(U177*0.07*P177,2)","v":264.56},{"$f":"S177","v":0},{"$f":"TRUNC(X177+W177+(IF(Y177>519,519,Y177))+IF(R177=0,0,R177*U177),2)","v":415.74},{"$f":"TRUNC((IF(R177=0,P177*U177,(P177-R177)*U177))+(IF(Y177<519,0,Y177-519)),2)+T177","v":3779.5},{"$f":"Z177+AA177","v":4195.24},null,null,0,{"$f":"IF(U177>0.01,(AA177-VLOOKUP(AA177,quincenal,1))*VLOOKUP(AA177,quincenal,3)+VLOOKUP(AA177,quincenal,2)-VLOOKUP(AA177,subquincenal,2),0)","v":313.80839999999995},{"$f":"TRUNC(IF(AF177>0.01,AF177,0),2)","v":313.8},{"$f":"TRUNC(IF(AF177<0.01,-AF177,0),2)","v":0},{"$f":"AB177-AD177-AE177-AG177+AH177","v":3881.4399999999996},{"$f":"[2]PORTADA!$D$10","v":1},null,142]
[{"$f":"A177+1","v":91},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(U178*P178,2)","v":4060.5},{"$f":"TRUNC(U178*P178*0.04,2)","v":162.41999999999999},{"$f":"TRUNC(U178*0.07*P178,2)","v":284.23},{"$f":"S178","v":0},{"$f":"TRUNC(X178+W178+(IF(Y178>519,519,Y178))+IF(R178=0,0,R178*U178),2)","v":446.65},{"$f":"TRUNC((IF(R178=0,P178*U178,(P178-R178)*U178))+(IF(Y178<519,0,Y178-519)),2)+T178","v":4060.5},{"$f":"Z178+AA178","v":4507.1499999999996},null,null,0,{"$f":"IF(U178>0.01,(AA178-VLOOKUP(AA178,quincenal,1))*VLOOKUP(AA178,quincenal,3)+VLOOKUP(AA178,quincenal,2)-VLOOKUP(AA178,subquincenal,2),0)","v":358.76839999999999},{"$f":"TRUNC(IF(AF178>0.01,AF178,0),2)","v":358.76},{"$f":"TRUNC(IF(AF178<0.01,-AF178,0),2)","v":0},{"$f":"AB178-AD178-AE178-AG178+AH178","v":4148.3899999999994},null,null,143]
[{"$f":"A178+1","v":92},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(U179>0.01,(AA179-VLOOKUP(AA179,quincenal,1))*VLOOKUP(AA179,quincenal,3)+VLOOKUP(AA179,quincenal,2)-VLOOKUP(AA179,subquincenal,2),0)","v":358.76839999999999},358.76,0,4148.3899999999994,null,null,144]
[93,null,null,"COVARRUBIAS RUIZ LUIS RICARDO",null,null,null,"ENFERMERO CENTRO DE SALUD SANTA ROSALIA",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,{"$f":"IF(U180>0.01,(AA180-VLOOKUP(AA180,quincenal,1))*VLOOKUP(AA180,quincenal,3)+VLOOKUP(AA180,quincenal,2)-VLOOKUP(AA180,subquincenal,2),0)","v":-129.73383999999999},0,129.72999999999999,1551.64]
[null,null,null,"SERVICIOS MEDICOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V177:V180)","v":13181.5},{"$f":"SUM(W177:W180)","v":527.26},922.68999999999994,0,1449.95,13181.5,14631.449999999999,0,0,0,901.61135999999999,1031.32,129.72999999999999,13729.859999999997,{"$f":"SUM(AJ177:AJ179)","v":1},0]
[]
[]
[null,null,null,"DEPARTAMENTO DE DESARROLLO RURAL"]
[{"$f":"A180+1","v":94},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(U185*P185,2)","v":6326.5},{"$f":"TRUNC(U185*P185*0.04,2)","v":253.06},{"$f":"TRUNC(U185*0.07*P185,2)","v":442.85},{"$f":"S185","v":0},{"$f":"TRUNC(X185+W185+(IF(Y185>519,519,Y185))+IF(R185=0,0,R185*U185),2)","v":695.91},{"$f":"TRUNC((IF(R185=0,P185*U185,(P185-R185)*U185))+(IF(Y185<519,0,Y185-519)),2)+T185","v":6326.5},{"$f":"Z185+AA185","v":7022.41},null,null,0,{"$f":"IF(U185>0.01,(AA185-VLOOKUP(AA185,quincenal,1))*VLOOKUP(AA185,quincenal,3)+VLOOKUP(AA185,quincenal,2)-VLOOKUP(AA185,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF185>0.01,AF185,0),2)","v":804.15},{"$f":"TRUNC(IF(AF185<0.01,-AF185,0),2)","v":0},{"$f":"AB185-AD185-AE185-AG185+AH185","v":6218.26},null,null,146]
[{"$f":"A185+1","v":95},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(U186*P186,2)","v":2857},{"$f":"TRUNC(U186*P186*0.04,2)","v":114.28},{"$f":"TRUNC(U186*0.07*P186,2)","v":199.99},{"$f":"S186","v":0},{"$f":"TRUNC(X186+W186+(IF(Y186>519,519,Y186))+IF(R186=0,0,R186*U186),2)","v":314.27},{"$f":"TRUNC((IF(R186=0,P186*U186,(P186-R186)*U186))+(IF(Y186<519,0,Y186-519)),2)+T186","v":2857},{"$f":"Z186+AA186","v":3171.27},null,null,0,{"$f":"IF(U186>0.01,(AA186-VLOOKUP(AA186,quincenal,1))*VLOOKUP(AA186,quincenal,3)+VLOOKUP(AA186,quincenal,2)-VLOOKUP(AA186,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF186>0.01,AF186,0),2)","v":61.4},{"$f":"TRUNC(IF(AF186<0.01,-AF186,0),2)","v":0},{"$f":"AB186-AD186-AE186-AG186+AH186","v":3109.87},null,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(V185:V186)","v":9183.5},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":"A186+1","v":96},"3","1","MATA COVARRUBIAS ALAN MARCOS","BUHM840914",null,null,"CONTRALOR",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"12653/30","v":421.76666666666665},{"$f":"TRUNC(U191*P191,2)","v":6326.5},{"$f":"TRUNC(U191*P191*0.04,2)","v":253.06},{"$f":"TRUNC(U191*0.07*P191,2)","v":442.85},{"$f":"S191","v":0},{"$f":"TRUNC(X191+W191+(IF(Y191>519,519,Y191))+IF(R191=0,0,R191*U191),2)","v":695.91},{"$f":"TRUNC((IF(R191=0,P191*U191,(P191-R191)*U191))+(IF(Y191<519,0,Y191-519)),2)+T191","v":6326.5},{"$f":"Z191+AA191","v":7022.41},null,null,0,{"$f":"IF(U191>0.01,(AA191-VLOOKUP(AA191,quincenal,1))*VLOOKUP(AA191,quincenal,3)+VLOOKUP(AA191,quincenal,2)-VLOOKUP(AA191,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF191>0.01,AF191,0),2)","v":804.15},{"$f":"TRUNC(IF(AF191<0.01,-AF191,0),2)","v":0},{"$f":"AB191-AD191-AE191-AG191+AH191","v":6218.26},{"$f":"#REF!","v":{"$error":"#REF!"}},null,149]
[{"$f":"A191+1","v":97},null,null,"RODRIGUEZ CASTELLANOS ANGELICA IVETTE","LEPC870628",null,null,"ASISITENTEDE CONTRALORIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5714/30","v":190.46666666666667},{"$f":"TRUNC(U192*P192,2)","v":2857},{"$f":"TRUNC(U192*P192*0.04,2)","v":114.28},{"$f":"TRUNC(U192*0.07*P192,2)","v":199.99},{"$f":"S192","v":0},{"$f":"TRUNC(X192+W192+(IF(Y192>519,519,Y192))+IF(R192=0,0,R192*U192),2)","v":314.27},{"$f":"TRUNC((IF(R192=0,P192*U192,(P192-R192)*U192))+(IF(Y192<519,0,Y192-519)),2)+T192","v":2857},{"$f":"Z192+AA192","v":3171.27},null,null,0,{"$f":"IF(U192>0.01,(AA192-VLOOKUP(AA192,quincenal,1))*VLOOKUP(AA192,quincenal,3)+VLOOKUP(AA192,quincenal,2)-VLOOKUP(AA192,subquincenal,2),0)","v":61.408511999999973},{"$f":"TRUNC(IF(AF192>0.01,AF192,0),2)","v":61.4},{"$f":"TRUNC(IF(AF192<0.01,-AF192,0),2)","v":0},{"$f":"AB192-AD192-AE192-AG192+AH192","v":3109.87},{"$f":"#REF!","v":{"$error":"#REF!"}},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(V191:V192)","v":9183.5},{"$f":"SUM(W191:W192)","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,"DELEGACIONES"]
[{"$f":"A192+1","v":98},"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(U196*P196,2)","v":1778},{"$f":"TRUNC(U196*P196*0.04,2)","v":71.12},{"$f":"TRUNC(U196*0.07*P196,2)","v":124.46},{"$f":"S196","v":0},{"$f":"TRUNC(X196+W196+(IF(Y196>519,519,Y196))+IF(R196=0,0,R196*U196),2)","v":195.58},{"$f":"TRUNC((IF(R196=0,P196*U196,(P196-R196)*U196))+(IF(Y196<519,0,Y196-519)),2)+T196","v":1778},{"$f":"Z196+AA196","v":1973.58},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":-85.92583999999998},0,{"$f":"TRUNC(IF(AF196<0.01,-AF196,0),2)","v":85.92},{"$f":"AB196-AD196-AE196-AG196+AH196","v":2059.5},{"$f":"#REF!","v":{"$error":"#REF!"}},null,151]
[{"$f":"A196+1","v":99},null,null,"CORONA TIZNADO OSIRIS ELVIA",null,null,null,"SECRETARIA DEL REGISTRO CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"3933/30","v":131.1},1966.5,78.66,137.65,0,216.31,1966.5,2182.81,null,null,0,-73.861839999999972,{"$f":"TRUNC(IF(AF197>0.01,AF197,0),2)","v":0},73.86,2256.67]
[{"$f":"A197+1","v":100},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(U198*P198,2)","v":3397.5},{"$f":"TRUNC(U198*P198*0.04,2)","v":135.9},{"$f":"TRUNC(U198*0.07*P198,2)","v":237.82},{"$f":"S198","v":0},{"$f":"TRUNC(X198+W198+(IF(Y198>519,519,Y198))+IF(R198=0,0,R198*U198),2)","v":373.72},{"$f":"TRUNC((IF(R198=0,P198*U198,(P198-R198)*U198))+(IF(Y198<519,0,Y198-519)),2)+T198","v":3397.5},{"$f":"Z198+AA198","v":3771.2200000000003},null,null,0,{"$f":"IF(U198>0.01,(AA198-VLOOKUP(AA198,quincenal,1))*VLOOKUP(AA198,quincenal,3)+VLOOKUP(AA198,quincenal,2)-VLOOKUP(AA198,subquincenal,2),0)","v":140.464912},{"$f":"TRUNC(IF(AF198>0.01,AF198,0),2)","v":140.46},{"$f":"TRUNC(IF(AF198<0.01,-AF198,0),2)","v":0},{"$f":"AB198-AD198-AE198-AG198+AH198","v":3630.76}]
[101,null,null,"LOPEZ REYES LINO","LORL560923","LORL560923HJCPYN00",null,"GUARDARRASTRO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2981/30","v":99.36666666666666},{"$f":"TRUNC(U199*P199,2)","v":1490.5},{"$f":"TRUNC(U199*P199*0.04,2)","v":59.62},{"$f":"TRUNC(U199*0.07*P199,2)","v":104.33},{"$f":"S199","v":0},{"$f":"TRUNC(X199+W199+(IF(Y199>519,519,Y199))+IF(R199=0,0,R199*U199),2)","v":163.95},{"$f":"TRUNC((IF(R199=0,P199*U199,(P199-R199)*U199))+(IF(Y199<519,0,Y199-519)),2)+T199","v":1490.5},{"$f":"Z199+AA199","v":1654.45},null,null,0,{"$f":"IF(U199>0.01,(AA199-VLOOKUP(AA199,quincenal,1))*VLOOKUP(AA199,quincenal,3)+VLOOKUP(AA199,quincenal,2)-VLOOKUP(AA199,subquincenal,2),0)","v":-116.32583999999997},{"$f":"TRUNC(IF(AF199>0.01,AF199,0),2)","v":0},{"$f":"TRUNC(IF(AF199<0.01,-AF199,0),2)","v":116.32},{"$f":"AB199-AD199-AE199-AG199+AH199","v":1770.77},{"$f":"[2]PORTADA!$D$10","v":1},null,155]
[102,null,null,"CERVANTES SANCHEZ GABRIEL","CESG4509243P3","CESG450924HMNRNB03","2004-02-08","ENCARGADO DE CEMENTERIOS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"1880/30","v":62.666666666666664},940,37.6,65.8,0,103.4,940,1043.4000000000001,null,null,0,-151.55784,0,151.55000000000001,1194.95,{"$f":"[2]PORTADA!$D$10","v":1},null,158]
[null,null,null,"DELEGACIONES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V196:V200)","v":9572.5},382.90000000000003,670.06,0,1052.96,9572.5,10625.46,0,0,0,-287.20644799999991,140.46,427.65000000000003,10912.650000000001,{"$error":"#REF!"},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+V31+V36+V42+V47+V52+V59+V63+V70+V77+V84+V95+V104+V110+V114+V119+V126+V134+V140+V144+V149+V159+V163+V168+V174+V181+V187+V193+V201","v":442936.3},17717.45,31005.29,0,48722.74,442936.3,491659.04,0,3000,0,40672.354272000011,42447.789999999994,1775.8200000000002,447987.06999999995]
[]
[]
[]
[]
[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":"A200+1","v":103},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(U219*P219,2)","v":3422.5},{"$f":"TRUNC(U219*P219*0.04,2)","v":136.9},{"$f":"TRUNC(U219*0.07*P219,2)","v":239.57},{"$f":"S219","v":0},{"$f":"TRUNC(X219+W219+(IF(Y219>519,519,Y219))+IF(R219=0,0,R219*U219),2)","v":376.47},{"$f":"TRUNC((IF(R219=0,P219*U219,(P219-R219)*U219))+(IF(Y219<519,0,Y219-519)),2)+T219","v":3422.5},{"$f":"Z219+AA219","v":3798.9700000000003},null,0,0,{"$f":"IF(U219>0.01,(AA219-VLOOKUP(AA219,quincenal,1))*VLOOKUP(AA219,quincenal,3)+VLOOKUP(AA219,quincenal,2)-VLOOKUP(AA219,subquincenal,2),0)","v":143.18491199999997},{"$f":"TRUNC(IF(AF219>0.01,AF219,0),2)","v":143.18},{"$f":"TRUNC(IF(AF219<0.01,-AF219,0),2)","v":0},{"$f":"AB219-AD219-AE219-AG219+AH219","v":3655.7900000000004},null,null,2]
[{"$f":"A219+1","v":104},11,17,"ARVIZU GIL HOMERO JOSE","AIGH730225LE1","AIGH730225HJCRLM08",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,null,0,143.18491199999997,143.18,0,3655.7900000000004,{"$f":"#REF!","v":{"$error":"#REF!"}},null,3]
[{"$f":"A220+1","v":105},"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,null,4]
[106,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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,5]
[107,"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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,6]
[108,null,null,"CASTELLANOS RODRIGUEZ SUSANA LIZETH","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,null,7]
[109,null,null,"CORONA MARTINEZ JESUS 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,null,9]
[110,"11","17","DOMINGUEZ PEREZ NOE","GASR",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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,10]
[111,"11","17","FIGUEROA SANTIAGO JAVIER ANTONIO","CAPV791223","CAPU791223HJCMTC05",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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,11]
[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,{"$f":"TRUNC(IF(AF228<0.01,-AF228,0),2)","v":0},4617.41,null,null,13]
[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},{"$f":"TRUNC(U229*P229,2)","v":4560.5},{"$f":"TRUNC(U229*P229*0.04,2)","v":182.42},{"$f":"TRUNC(U229*0.07*P229,2)","v":319.23},{"$f":"S229","v":0},{"$f":"TRUNC(X229+W229+(IF(Y229>519,519,Y229))+IF(R229=0,0,R229*U229),2)","v":501.65},{"$f":"TRUNC((IF(R229=0,P229*U229,(P229-R229)*U229))+(IF(Y229<519,0,Y229-519)),2)+T229","v":4560.5},{"$f":"Z229+AA229","v":5062.1499999999996},null,null,0,{"$f":"IF(U229>0.01,(AA229-VLOOKUP(AA229,quincenal,1))*VLOOKUP(AA229,quincenal,3)+VLOOKUP(AA229,quincenal,2)-VLOOKUP(AA229,subquincenal,2),0)","v":444.74708800000008},{"$f":"TRUNC(IF(AF229>0.01,AF229,0),2)","v":444.74},{"$f":"TRUNC(IF(AF229<0.01,-AF229,0),2)","v":0},{"$f":"AB229-AD229-AE229-AG229+AH229","v":4617.41},null,null,14]
[114,null,null,"GARCIA GARCIA ROGELIO",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,null,16]
[115,"11","17","GARCIA MAGALLANES FRANCISCO",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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,17]
[116,"11","17","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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,18]
[117,null,null,"GOMEZ MEZA ARMANDO",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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,19]
[118,"11","17","GOMEZ TOVAR JUAN FRANCISCO","GOCB550313","GOCB550313HJCMHN07","2007-01-01","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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,20]
[119,"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,null,0,143.18491199999997,143.18,0,3655.7900000000004,{"$f":"#REF!","v":{"$error":"#REF!"}},null,21]
[120,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,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,null,22]
[121,"11","17","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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,23]
[122,null,null,"INFANTE GUTIERREZ CRISTINA",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,null,0,143.18491199999997,143.18,0,3655.7900000000004,null,null,24]
[123,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,null,25]
[124,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,null,27]
[125,null,null,"MARTINEZ GARCIA MARIA GRACIELA",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,null,28]
[126,null,null,"MEDERO ARRIAGA JESUS ALEJANDRO",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,null,29]
[127,null,null,"MORENO GONZALEZ JOSE ANTONIO",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,566,0,143.18491199999997,143.18,0,3089.7900000000004,null,null,30]
[128,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]
[129,"11","17","REGALADO AQUINO JUAN","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,null,0,143.18491199999997,143.18,0,3655.7900000000004,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[130,"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,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[131,null,null,"RIVERA MORENO JORGE ALBERTO",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,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[132,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]
[133,"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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,31]
[134,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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,32]
[135,"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,0,0,369.5684,369.56,0,4212.5199999999995,{"$f":"#REF!","v":{"$error":"#REF!"}},null,34]
[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(V219:V251)","v":122619.5},4904.7800000000007,8583.2099999999955,0,13487.989999999996,122619.5,136107.49000000002,0,1066,0,7066.1125599999987,7065.9400000000014,0,127975.54999999992]
[]
[null,null,null,"DEPARTAMENTO DE PROTECCION CIVIL"]
[{"$f":"A251+1","v":136},"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(U255*P255,2)","v":6326.5},{"$f":"TRUNC(U255*P255*0.04,2)","v":253.06},{"$f":"TRUNC(U255*0.07*P255,2)","v":442.85},{"$f":"S255","v":0},{"$f":"TRUNC(X255+W255+(IF(Y255>519,519,Y255))+IF(R255=0,0,R255*U255),2)","v":695.91},{"$f":"TRUNC((IF(R255=0,P255*U255,(P255-R255)*U255))+(IF(Y255<519,0,Y255-519)),2)+T255","v":6326.5},{"$f":"Z255+AA255","v":7022.41},null,null,0,{"$f":"IF(U255>0.01,(AA255-VLOOKUP(AA255,quincenal,1))*VLOOKUP(AA255,quincenal,3)+VLOOKUP(AA255,quincenal,2)-VLOOKUP(AA255,subquincenal,2),0)","v":804.15122400000007},{"$f":"TRUNC(IF(AF255>0.01,AF255,0),2)","v":804.15},{"$f":"TRUNC(IF(AF255<0.01,-AF255,0),2)","v":0},{"$f":"AB255-AD255-AE255-AG255+AH255","v":6218.26},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[{"$f":"A255+1","v":137},null,null,"TRINIDAD RAMIREZ JOSE ROMAN","VAML800130","VAML800130HJCRRS04",null,"PARAMEDICO PROTECCIONJ CIVIL",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"6438/30","v":214.6},{"$f":"TRUNC(U256*P256,2)","v":3219},{"$f":"TRUNC(U256*P256*0.04,2)","v":128.76},{"$f":"TRUNC(U256*0.07*P256,2)","v":225.33},{"$f":"S256","v":0},{"$f":"TRUNC(X256+W256+(IF(Y256>519,519,Y256))+IF(R256=0,0,R256*U256),2)","v":354.09},{"$f":"TRUNC((IF(R256=0,P256*U256,(P256-R256)*U256))+(IF(Y256<519,0,Y256-519)),2)+T256","v":3219},{"$f":"Z256+AA256","v":3573.09},null,0,0,{"$f":"IF(U256>0.01,(AA256-VLOOKUP(AA256,quincenal,1))*VLOOKUP(AA256,quincenal,3)+VLOOKUP(AA256,quincenal,2)-VLOOKUP(AA256,subquincenal,2),0)","v":121.04411199999998},{"$f":"TRUNC(IF(AF256>0.01,AF256,0),2)","v":121.04},{"$f":"TRUNC(IF(AF256<0.01,-AF256,0),2)","v":0},{"$f":"AB256-AD256-AE256-AG256+AH256","v":3452.05},{"$f":"#REF!","v":{"$error":"#REF!"}},null,2]
[{"$f":"A256+1","v":138},null,null,"ALVAREZ SANDOVAL GABRIEL",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(U257*P257,2)","v":2582},{"$f":"TRUNC(U257*P257*0.04,2)","v":103.28},{"$f":"TRUNC(U257*0.07*P257,2)","v":180.74},{"$f":"S257","v":0},{"$f":"TRUNC(X257+W257+(IF(Y257>519,519,Y257))+IF(R257=0,0,R257*U257),2)","v":284.02},{"$f":"TRUNC((IF(R257=0,P257*U257,(P257-R257)*U257))+(IF(Y257<519,0,Y257-519)),2)+T257","v":2582},{"$f":"Z257+AA257","v":2866.02},null,null,0,16.488511999999986,{"$f":"TRUNC(IF(AF257>0.01,AF257,0),2)","v":16.48},{"$f":"TRUNC(IF(AF257<0.01,-AF257,0),2)","v":0},{"$f":"AB257-AD257-AE257-AG257+AH257","v":2849.54}]
[{"$f":"A257+1","v":139},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(U258*P258,2)","v":2582},{"$f":"TRUNC(U258*P258*0.04,2)","v":103.28},{"$f":"TRUNC(U258*0.07*P258,2)","v":180.74},{"$f":"S258","v":0},{"$f":"TRUNC(X258+W258+(IF(Y258>519,519,Y258))+IF(R258=0,0,R258*U258),2)","v":284.02},{"$f":"TRUNC((IF(R258=0,P258*U258,(P258-R258)*U258))+(IF(Y258<519,0,Y258-519)),2)+T258","v":2582},{"$f":"Z258+AA258","v":2866.02},null,null,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":16.488511999999986},{"$f":"TRUNC(IF(AF258>0.01,AF258,0),2)","v":16.48},{"$f":"TRUNC(IF(AF258<0.01,-AF258,0),2)","v":0},{"$f":"AB258-AD258-AE258-AG258+AH258","v":2849.54}]
[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(V255:V258)","v":14709.5},588.38,1029.6600000000001,0,1618.04,14709.5,16327.54,0,0,0,958.17236000000003,958.15,0,15369.390000000003]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V259+V252","v":137329},5493.1600000000008,9612.8699999999953,0,15106.029999999995,137329,152435.03000000003,0,1066,0,8024.2849199999982,8024.0900000000011,0,143344.93999999992,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"PENSIONADOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"A258+1","v":140},null,null,"ESPINOZA GONZALEZ ANGELA","EIGA240505KM2","EIGA240505MJCSNN09",null,"PENSIONADO",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"1303/30","v":43.43333333333333},{"$f":"TRUNC(U275*P275,2)","v":651.5},{"$f":"TRUNC(U275*P275*0.04,2)","v":26.06},{"$f":"TRUNC(U275*0.07*P275,2)","v":45.6},{"$f":"S275","v":0},{"$f":"TRUNC(X275+W275+(IF(Y275>519,519,Y275))+IF(R275=0,0,R275*U275),2)","v":71.66},{"$f":"TRUNC((IF(R275=0,P275*U275,(P275-R275)*U275))+(IF(Y275<519,0,Y275-519)),2)+T275","v":651.5},{"$f":"Z275+AA275","v":723.16},null,null,0,{"$f":"IF(U275>0.01,(AA275-VLOOKUP(AA275,quincenal,1))*VLOOKUP(AA275,quincenal,3)+VLOOKUP(AA275,quincenal,2)-VLOOKUP(AA275,subquincenal,2),0)","v":-170.17184},{"$f":"TRUNC(IF(AF275>0.01,AF275,0),2)","v":0},{"$f":"TRUNC(IF(AF275<0.01,-AF275,0),2)","v":170.17},{"$f":"AB275-AD275-AE275-AG275+AH275","v":893.32999999999993},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[{"$f":"A275+1","v":141},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(U276*P276,2)","v":1539},{"$f":"TRUNC(U276*P276*0.04,2)","v":61.56},{"$f":"TRUNC(U276*0.07*P276,2)","v":107.73},{"$f":"S276","v":0},{"$f":"TRUNC(X276+W276+(IF(Y276>519,519,Y276))+IF(R276=0,0,R276*U276),2)","v":169.29},{"$f":"TRUNC((IF(R276=0,P276*U276,(P276-R276)*U276))+(IF(Y276<519,0,Y276-519)),2)+T276","v":1539},{"$f":"Z276+AA276","v":1708.29},null,null,0,{"$f":"IF(U276>0.01,(AA276-VLOOKUP(AA276,quincenal,1))*VLOOKUP(AA276,quincenal,3)+VLOOKUP(AA276,quincenal,2)-VLOOKUP(AA276,subquincenal,2),0)","v":-113.22183999999997},{"$f":"TRUNC(IF(AF276>0.01,AF276,0),2)","v":0},{"$f":"TRUNC(IF(AF276<0.01,-AF276,0),2)","v":113.22},{"$f":"AB276-AD276-AE276-AG276+AH276","v":1821.51},null,null,2]
[{"$f":"A276+1","v":142},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(U277*P277,2)","v":1785},{"$f":"TRUNC(U277*P277*0.04,2)","v":71.400000000000006},{"$f":"TRUNC(U277*0.07*P277,2)","v":124.95},{"$f":"S277","v":0},{"$f":"TRUNC(X277+W277+(IF(Y277>519,519,Y277))+IF(R277=0,0,R277*U277),2)","v":196.35},{"$f":"TRUNC((IF(R277=0,P277*U277,(P277-R277)*U277))+(IF(Y277<519,0,Y277-519)),2)+T277","v":1785},{"$f":"Z277+AA277","v":1981.35},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":-85.477839999999972},{"$f":"TRUNC(IF(AF277>0.01,AF277,0),2)","v":0},{"$f":"TRUNC(IF(AF277<0.01,-AF277,0),2)","v":85.47},{"$f":"AB277-AD277-AE277-AG277+AH277","v":2066.8199999999997}]
[143,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(U278*P278,2)","v":1483},{"$f":"TRUNC(U278*P278*0.04,2)","v":59.32},{"$f":"TRUNC(U278*0.07*P278,2)","v":103.81},{"$f":"S278","v":0},{"$f":"TRUNC(X278+W278+(IF(Y278>519,519,Y278))+IF(R278=0,0,R278*U278),2)","v":163.13},{"$f":"TRUNC((IF(R278=0,P278*U278,(P278-R278)*U278))+(IF(Y278<519,0,Y278-519)),2)+T278","v":1483},{"$f":"Z278+AA278","v":1646.13},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":-116.80583999999998},{"$f":"TRUNC(IF(AF278>0.01,AF278,0),2)","v":0},{"$f":"TRUNC(IF(AF278<0.01,-AF278,0),2)","v":116.8},{"$f":"AB278-AD278-AE278-AG278+AH278","v":1762.93},null,null,3]
[144,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(U279*P279,2)","v":815},{"$f":"TRUNC(U279*P279*0.04,2)","v":32.6},{"$f":"TRUNC(U279*0.07*P279,2)","v":57.05},{"$f":"S279","v":0},{"$f":"TRUNC(X279+W279+(IF(Y279>519,519,Y279))+IF(R279=0,0,R279*U279),2)","v":89.65},{"$f":"TRUNC((IF(R279=0,P279*U279,(P279-R279)*U279))+(IF(Y279<519,0,Y279-519)),2)+T279","v":815},{"$f":"Z279+AA279","v":904.65},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":-159.70783999999998},{"$f":"TRUNC(IF(AF279>0.01,AF279,0),2)","v":0},{"$f":"TRUNC(IF(AF279<0.01,-AF279,0),2)","v":159.69999999999999},{"$f":"AB279-AD279-AE279-AG279+AH279","v":1064.3499999999999},null,null,4]
[145,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(U280*P280,2)","v":1229},{"$f":"TRUNC(U280*P280*0.04,2)","v":49.16},{"$f":"TRUNC(U280*0.07*P280,2)","v":86.03},{"$f":"S280","v":0},{"$f":"TRUNC(X280+W280+(IF(Y280>519,519,Y280))+IF(R280=0,0,R280*U280),2)","v":135.19},{"$f":"TRUNC((IF(R280=0,P280*U280,(P280-R280)*U280))+(IF(Y280<519,0,Y280-519)),2)+T280","v":1229},{"$f":"Z280+AA280","v":1364.19},null,0,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":-133.06183999999996},{"$f":"TRUNC(IF(AF280>0.01,AF280,0),2)","v":0},{"$f":"TRUNC(IF(AF280<0.01,-AF280,0),2)","v":133.06},{"$f":"AB280-AD280-AE280-AG280+AH280","v":1497.25},null,null,5]
[146,"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},1711.5,68.459999999999994,119.8,0,188.26,1711.5,1899.76,null,0,0,-102.18183999999998,0,102.18,2001.94,{"$f":"#REF!","v":{"$error":"#REF!"}},null,6]
[147,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(U282*P282,2)","v":1785},{"$f":"TRUNC(U282*P282*0.04,2)","v":71.400000000000006},{"$f":"TRUNC(U282*0.07*P282,2)","v":124.95},{"$f":"S282","v":0},{"$f":"TRUNC(X282+W282+(IF(Y282>519,519,Y282))+IF(R282=0,0,R282*U282),2)","v":196.35},{"$f":"TRUNC((IF(R282=0,P282*U282,(P282-R282)*U282))+(IF(Y282<519,0,Y282-519)),2)+T282","v":1785},{"$f":"Z282+AA282","v":1981.35},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":-85.477839999999972},{"$f":"TRUNC(IF(AF282>0.01,AF282,0),2)","v":0},{"$f":"TRUNC(IF(AF282<0.01,-AF282,0),2)","v":85.47},{"$f":"AB282-AD282-AE282-AG282+AH282","v":2066.8199999999997},null,null,7]
[148,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(U283*P283,2)","v":1711.5},{"$f":"TRUNC(U283*P283*0.04,2)","v":68.459999999999994},{"$f":"TRUNC(U283*0.07*P283,2)","v":119.8},{"$f":"S283","v":0},{"$f":"TRUNC(X283+W283+(IF(Y283>519,519,Y283))+IF(R283=0,0,R283*U283),2)","v":188.26},{"$f":"TRUNC((IF(R283=0,P283*U283,(P283-R283)*U283))+(IF(Y283<519,0,Y283-519)),2)+T283","v":1711.5},{"$f":"Z283+AA283","v":1899.76},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":-102.18183999999998},{"$f":"TRUNC(IF(AF283>0.01,AF283,0),2)","v":0},{"$f":"TRUNC(IF(AF283<0.01,-AF283,0),2)","v":102.18},{"$f":"AB283-AD283-AE283-AG283+AH283","v":2001.94},null,null,8]
[149,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,null,0,-58.591088000000013,0,58.59,2447.86,{"$f":"#REF!","v":{"$error":"#REF!"}},null,9]
[150,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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,10]
[151,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,{"$f":"#REF!","v":{"$error":"#REF!"}},null,11]
[152,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(U287*P287,2)","v":815},{"$f":"TRUNC(U287*P287*0.04,2)","v":32.6},{"$f":"TRUNC(U287*0.07*P287,2)","v":57.05},{"$f":"S287","v":0},{"$f":"TRUNC(X287+W287+(IF(Y287>519,519,Y287))+IF(R287=0,0,R287*U287),2)","v":89.65},{"$f":"TRUNC((IF(R287=0,P287*U287,(P287-R287)*U287))+(IF(Y287<519,0,Y287-519)),2)+T287","v":815},{"$f":"Z287+AA287","v":904.65},null,null,0,{"$f":"IF(U287>0.01,(AA287-VLOOKUP(AA287,quincenal,1))*VLOOKUP(AA287,quincenal,3)+VLOOKUP(AA287,quincenal,2)-VLOOKUP(AA287,subquincenal,2),0)","v":-159.70783999999998},{"$f":"TRUNC(IF(AF287>0.01,AF287,0),2)","v":0},{"$f":"TRUNC(IF(AF287<0.01,-AF287,0),2)","v":159.69999999999999},{"$f":"AB287-AD287-AE287-AG287+AH287","v":1064.3499999999999},{"$f":"#REF!","v":{"$error":"#REF!"}},null,12]
[153,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,{"$f":"#REF!","v":{"$error":"#REF!"}},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(V275:V288)","v":23047},921.88,1613.27,0,2535.1499999999996,23047,25582.15,0,0,0,-1253.350704,162.19,1415.5000000000002,26835.46]
[]
[]
[]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[2]PORTADA!$D$10","v":1}]
[{"$f":"A288+1","v":154},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(U299*P299,2)","v":2886},{"$f":"TRUNC(U299*P299*0.04,2)","v":115.44},{"$f":"TRUNC(U299*0.07*P299,2)","v":202.02},{"$f":"S299","v":0},{"$f":"TRUNC(X299+W299+(IF(Y299>519,519,Y299))+IF(R299=0,0,R299*U299),2)","v":317.45999999999998},{"$f":"TRUNC((IF(R299=0,P299*U299,(P299-R299)*U299))+(IF(Y299<519,0,Y299-519)),2)+T299","v":2886},{"$f":"Z299+AA299","v":3203.46},null,null,0,{"$f":"IF(U299>0.01,(AA299-VLOOKUP(AA299,quincenal,1))*VLOOKUP(AA299,quincenal,3)+VLOOKUP(AA299,quincenal,2)-VLOOKUP(AA299,subquincenal,2),0)","v":64.563711999999981},{"$f":"TRUNC(IF(AF299>0.01,AF299,0),2)","v":64.56},{"$f":"TRUNC(IF(AF299<0.01,-AF299,0),2)","v":0},{"$f":"AB299-AD299-AE299-AG299+AH299","v":3138.9},{"$f":"[2]PORTADA!$D$10","v":1},null,1]
[{"$f":"A299+1","v":155},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,{"$f":"[2]PORTADA!$D$10","v":1},null,9]
[{"$f":"A300+1","v":156},"2","1","GONZALEZ ESPINOZA JAIME","GOEJ550102","GOEJ550102HJCNSM14",null,"ENCARGADO DE PLANTA TRATADORA DE AGUAS NEGRAS",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"9560/30","v":318.66666666666669},4780,191.2,334.6,0,525.79999999999995,4780,5305.8,null,0,0,484.08148800000004,484.08,0,4821.72,{"$f":"[2]PORTADA!$D$10","v":1},null,12]
[157,"2","2","HERNANDEZ PINEDA JUAN JOSE","HEPJ581212","HEPJ571212HJCRNN00",null,"ENCARGADO  DE BOMBA EN SANTA ROSALIA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"4137/30","v":137.9},2068.5,82.74,144.79,0,227.53,2068.5,2296.0300000000002,null,null,0,-67.333839999999981,0,67.33,2363.36,{"$f":"[2]PORTADA!$D$10","v":1},null,13]
[158,null,null,"MELCHOR CASILLAS SANTIAGO","MECS331205","MECS331205HJCLSN08",null,"ENCARGADO  DE BOMBA EN OCONAHUA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"2981/30","v":99.36666666666666},1490.5,59.62,104.33,0,163.95,1490.5,1654.45,null,null,0,-116.32583999999997,0,116.32,1770.77,{"$f":"[2]PORTADA!$D$10","v":1},null,15]
[159,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(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,null,21]
[160,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(U305*P305,2)","v":2857},{"$f":"TRUNC(U305*P305*0.04,2)","v":114.28},{"$f":"TRUNC(U305*0.07*P305,2)","v":199.99},{"$f":"S305","v":0},{"$f":"TRUNC(X305+W305+(IF(Y305>519,519,Y305))+IF(R305=0,0,R305*U305),2)","v":314.27},{"$f":"TRUNC((IF(R305=0,P305*U305,(P305-R305)*U305))+(IF(Y305<519,0,Y305-519)),2)+T305","v":2857},{"$f":"Z305+AA305","v":3171.27},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":61.408511999999973},{"$f":"TRUNC(IF(AF305>0.01,AF305,0),2)","v":61.4},{"$f":"TRUNC(IF(AF305<0.01,-AF305,0),2)","v":0},{"$f":"AB305-AD305-AE305-AG305+AH305","v":3109.87},null,null,22]
[161,null,null,"VILLA RUBIO GABRIEL","VIRG590520","VIRG590520HJCLBB05",null,"ENCARGADO  DE BOMBA AGUA ZARCA",null,null,null,null,null,null,null,15,"TARJETA",null,0,0,{"$f":"5772/30","v":192.4},2886,115.44,202.02,0,317.45999999999998,2886,3203.46,null,null,0,64.563711999999981,64.56,0,3138.9,{"$f":"[2]PORTADA!$D$10","v":1},null,23]
[162,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":"S307","v":0},263.94,2399.5,{"$f":"Z307+AA307","v":2663.44},null,null,0,{"$f":"IF(U307>0.01,(AA307-VLOOKUP(AA307,quincenal,1))*VLOOKUP(AA307,quincenal,3)+VLOOKUP(AA307,quincenal,2)-VLOOKUP(AA307,subquincenal,2),0)","v":-3.3674880000000087},{"$f":"TRUNC(IF(AF307>0.01,AF307,0),2)","v":0},{"$f":"TRUNC(IF(AF307<0.01,-AF307,0),2)","v":3.36},{"$f":"AB307-AD307-AE307-AG307+AH307","v":2666.8},{"$f":"[2]PORTADA!$D$10","v":1},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(V299:V307)","v":25328},1013.1199999999999,1772.94,0,2786.06,25328,28114.059999999998,0,0,0,657.47648000000004,844.47,187.01,27456.600000000002]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,"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":[[18,0,18,1],[18,4,18,5],[18,8,18,9],[19,0,19,1],[19,4,19,5],[19,8,19,9],[0,0,0,2],[0,4,0,6],[0,8,0,10],[1,0,1,2],[1,4,1,6],[1,8,1,10]]}
["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":[]}