{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1A DE NOVIEMBRE DEFINITIVA","Tablas 2015"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"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 NOVIEMBRE DEFINITIVA","index":0,"n_rows":417,"n_cols":31,"rows_kept":417,"cut":false,"hidden":false,"merged":[[415,3,415,4],[415,8,415,16],[415,26,415,29],[416,3,416,4],[416,8,416,16],[416,26,416,29],[399,0,399,29],[400,1,400,29],[401,1,401,29],[358,3,358,4],[358,8,358,16],[358,26,358,29],[359,3,359,4],[359,8,359,16],[359,26,359,29],[392,3,392,4],[392,8,392,16],[392,26,392,29],[393,3,393,4],[393,8,393,16],[393,26,393,29],[333,3,333,4],[333,8,333,16],[333,26,333,29],[275,3,275,4],[276,3,276,4],[276,8,276,16],[275,8,275,16],[332,3,332,4],[332,8,332,16],[332,26,332,29],[3,1,3,29],[4,1,4,29],[275,26,275,29],[276,26,276,29],[2,0,2,29]]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,M9:M328)","v":0},46551.457233333364,2049246.5400000007,81968.939999999886,143445.92999999988,0,225414.87000000037,2049246.5400000007,2274661.41,null,{"$f":"SUBTOTAL(9,W9:W328)","v":0},{"$f":"SUBTOTAL(9,X9:X328)","v":0},{"$f":"SUBTOTAL(9,Y9:Y312)","v":{"$error":"#N/A"}},{"$f":"SUBTOTAL(9,Z9:Z328)","v":140652.47999999989},{"$f":"SUBTOTAL(9,AA9:AA328)","v":14997.869999999999},{"$f":"SUBTOTAL(9,AB9:AB328)","v":2149006.7999999975},null,{"$f":"SUBTOTAL(9,AD9:AD312)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC(N2*I2,2)","v":0},{"$f":"TRUNC(N2*I2*0.04,2)","v":0},{"$f":"TRUNC(N2*0.07*I2,2)","v":0},{"$f":"L2","v":0},{"$f":"TRUNC(Q2+P2+(IF(R2>519,519,R2))+IF(K2=0,0,K2*N2),2)","v":0},{"$f":"TRUNC((IF(K2=0,I2*N2,(I2-K2)*N2))+(IF(R2<519,0,R2-519)),2)+M2","v":0},{"$f":"S2+T2","v":0},{"$f":"P2","v":0},null,null,{"$f":"IF(N2>0.01,(T2-VLOOKUP(T2,quincenal,1))*VLOOKUP(T2,quincenal,3)+VLOOKUP(T2,quincenal,2)-VLOOKUP(T2,subquincenal,2),0)","v":0},{"$f":"TRUNC(IF(Y2>0.01,Y2,0),2)","v":0},{"$f":"TRUNC(IF(Y2<0.01,-Y2,0),2)","v":0},{"$f":"U2-W2-X2-Z2+AA2-P2","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["H. AYUNTAMIENTO DE ETZATLAN, JALISCO"]
[null,"ADMINISTRACION 2012-2015"]
[null,"NOMINA CORRESPONDIENTE A LA PRIMERA QUINCENA DE NOVIEMBRE DE 2015"]
[null,null,null,"Etzatlán, Jalisco a 15 de Noviembre de 2015."]
[null,"CAPITULO","PARTIDA","NOMBRE","RFC","CURP","FECHA DE INGRESO","CARGO","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",15,"TARJETA",null,0,0,{"$f":"8023/15","v":534.86666666666667},{"$f":"TRUNC(N9*I9,2)","v":8023},{"$f":"TRUNC(N9*I9*0.04,2)","v":320.92},{"$f":"TRUNC(N9*0.07*I9,2)","v":561.61},{"$f":"L9","v":0},{"$f":"TRUNC(Q9+P9+(IF(R9>519,519,R9))+IF(K9=0,0,K9*N9),2)","v":882.53},{"$f":"TRUNC((IF(K9=0,I9*N9,(I9-K9)*N9))+(IF(R9<519,0,R9-519)),2)+M9","v":8023},{"$f":"S9+T9","v":8905.5300000000007},null,null,0,{"$f":"IF(N9>0.01,(T9-VLOOKUP(T9,quincenal,1))*VLOOKUP(T9,quincenal,3)+VLOOKUP(T9,quincenal,2)-VLOOKUP(T9,subquincenal,2),0)","v":1166.5236240000002},{"$f":"TRUNC(IF(Y9>0.01,Y9,0),2)","v":1166.52},{"$f":"TRUNC(IF(Y9<0.01,-Y9,0),2)","v":0},{"$f":"U9-W9-X9-Z9+AA9","v":7739.01},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[null,null,null,"COVARRUBIAS VALENCIA JOSE",null,null,null,"REGIDOR",15,"TARJETA",null,0,0,{"$f":"8023/15","v":534.86666666666667},{"$f":"TRUNC(N10*I10,2)","v":8023},{"$f":"TRUNC(N10*I10*0.04,2)","v":320.92},{"$f":"TRUNC(N10*0.07*I10,2)","v":561.61},{"$f":"L10","v":0},{"$f":"TRUNC(Q10+P10+(IF(R10>519,519,R10))+IF(K10=0,0,K10*N10),2)","v":882.53},{"$f":"TRUNC((IF(K10=0,I10*N10,(I10-K10)*N10))+(IF(R10<519,0,R10-519)),2)+M10","v":8023},{"$f":"S10+T10","v":8905.5300000000007},null,null,0,{"$f":"IF(N10>0.01,(T10-VLOOKUP(T10,quincenal,1))*VLOOKUP(T10,quincenal,3)+VLOOKUP(T10,quincenal,2)-VLOOKUP(T10,subquincenal,2),0)","v":1166.5236240000002},{"$f":"TRUNC(IF(Y10>0.01,Y10,0),2)","v":1166.52},{"$f":"TRUNC(IF(Y10<0.01,-Y10,0),2)","v":0},{"$f":"U10-W10-X10-Z10+AA10","v":7739.01},null,null,2]
[3,1,1,"BARAJAS DE LA TORRE ABIGAIL",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,{"$f":"TRUNC(N11*I11,2)","v":8023},{"$f":"TRUNC(N11*I11*0.04,2)","v":320.92},{"$f":"TRUNC(N11*0.07*I11,2)","v":561.61},{"$f":"L11","v":0},{"$f":"TRUNC(Q11+P11+(IF(R11>519,519,R11))+IF(K11=0,0,K11*N11),2)","v":882.53},{"$f":"TRUNC((IF(K11=0,I11*N11,(I11-K11)*N11))+(IF(R11<519,0,R11-519)),2)+M11","v":8023},{"$f":"S11+T11","v":8905.5300000000007},null,null,0,{"$f":"IF(N11>0.01,(T11-VLOOKUP(T11,quincenal,1))*VLOOKUP(T11,quincenal,3)+VLOOKUP(T11,quincenal,2)-VLOOKUP(T11,subquincenal,2),0)","v":1166.5236240000002},1166.52,{"$f":"TRUNC(IF(Y11<0.01,-Y11,0),2)","v":0},{"$f":"U11-W11-X11-Z11+AA11","v":7739.01},{"$f":"#REF!","v":{"$error":"#REF!"}},null,3]
[4,1,1,"MELCHOR NAVARRO OBED",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,8023,320.92,561.61,0,882.53,8023,8905.5300000000007,null,null,0,1166.5236240000002,1166.52,0,7739.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,4]
[5,1,1,"GOMEZ RICO LUZ ELENA",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,8023,320.92,561.61,0,882.53,8023,8905.5300000000007,null,null,0,1166.5236240000002,1166.52,0,7739.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,5]
[6,1,1,"GUTIERREZ GARCIA GERARDO",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,8023,320.92,561.61,0,882.53,8023,8905.5300000000007,null,null,0,1166.5236240000002,1166.52,0,7739.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,6]
[7,1,1,"ROBLEDO ORTIZ EDGAR ANTONIO",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,8023,320.92,561.61,0,882.53,8023,8905.5300000000007,null,null,null,1166.5236240000002,1166.52,0,7739.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,7]
[8,1,1,"SIERRA ROMERO DOLORES EDITH",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,8023,320.92,561.61,0,882.53,8023,8905.5300000000007,null,null,null,1166.5236240000002,1166.52,0,7739.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,8]
[9,1,1,"VELEZ FREGOSO LUIS MANUEL",null,null,"2012-10-01","REGIDOR",15,"TARJETA",null,0,0,534.86666666666667,8023,320.92,561.61,0,882.53,8023,8905.5300000000007,null,0,null,1166.5236240000002,1166.52,0,7739.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,9]
[null,1,1,null,"BAGV780611","BAGV780611MJCRTR04",null,"SECRETARIA SALA  DE REGIDORES",0,"TARJETA",null,0,0,172.16,{"$f":"TRUNC(N18*I18,2)","v":0},0,0,0,0,0,0,null,null,0,null,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},null,2658.44]
[null,null,null,"SALA DE REGIDORES",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O9:O18)","v":72207},{"$f":"SUM(P9:P18)","v":2888.28},5054.49,0,7942.7699999999986,72207,80149.77,0,0,0,10498.712616000001,10498.680000000002,0,69651.090000000011,{"$error":"#REF!"},0]
[]
[null,null,null,"PRESIDENCIA MUNICIPAL"]
[null,null,null,"RON RAMOS EDUARDO",null,null,null,"PRESIDENTE MUNICIPAL",15,"TARJETA",null,0,0,{"$f":"14227/15","v":948.4666666666667},{"$f":"TRUNC(N22*I22,2)","v":14227},{"$f":"TRUNC(N22*I22*0.04,2)","v":569.08000000000004},{"$f":"TRUNC(N22*0.07*I22,2)","v":995.89},{"$f":"L22","v":0},{"$f":"TRUNC(Q22+P22+(IF(R22>519,519,R22))+IF(K22=0,0,K22*N22),2)","v":1564.97},{"$f":"TRUNC((IF(K22=0,I22*N22,(I22-K22)*N22))+(IF(R22<519,0,R22-519)),2)+M22","v":14227},{"$f":"S22+T22","v":15791.97},null,null,0,{"$f":"IF(N22>0.01,(T22-VLOOKUP(T22,quincenal,1))*VLOOKUP(T22,quincenal,3)+VLOOKUP(T22,quincenal,2)-VLOOKUP(T22,subquincenal,2),0)","v":2577.5026080000002},{"$f":"TRUNC(IF(Y22>0.01,Y22,0),2)","v":2577.5},{"$f":"TRUNC(IF(Y22<0.01,-Y22,0),2)","v":0},{"$f":"U22-W22-X22-Z22+AA22","v":13214.47},null,null,10]
[null,null,null,"BAROCIO FIGUEROA ANTONIO","FEPM871023ND1","FEPM871023MJCRRR07",null,"SECRETARIO PARTICULAR",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N23*I23,2)","v":6083.01},{"$f":"TRUNC(N23*I23*0.04,2)","v":243.32},{"$f":"TRUNC(N23*0.07*I23,2)","v":425.81},{"$f":"L23","v":0},{"$f":"TRUNC(Q23+P23+(IF(R23>519,519,R23))+IF(K23=0,0,K23*N23),2)","v":669.13},{"$f":"TRUNC((IF(K23=0,I23*N23,(I23-K23)*N23))+(IF(R23<519,0,R23-519)),2)+M23","v":6083.01},{"$f":"S23+T23","v":6752.14},null,null,0,{"$f":"IF(N23>0.01,(T23-VLOOKUP(T23,quincenal,1))*VLOOKUP(T23,quincenal,3)+VLOOKUP(T23,quincenal,2)-VLOOKUP(T23,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y23>0.01,Y23,0),2)","v":752.14},{"$f":"TRUNC(IF(Y23<0.01,-Y23,0),2)","v":0},{"$f":"U23-W23-X23-Z23+AA23","v":6000},null,null,11]
[null,null,null,"BECERRA GONZALEZ MARISOL","FEPM871023ND1","FEPM871023MJCRRR07",null,"SECRETARIA",15,"TARJETA",null,0,0,260.28699999999998,{"$f":"TRUNC(N24*I24,2)","v":3904.3},{"$f":"TRUNC(N24*I24*0.04,2)","v":156.16999999999999},{"$f":"TRUNC(N24*0.07*I24,2)","v":273.3},{"$f":"L24","v":0},{"$f":"TRUNC(Q24+P24+(IF(R24>519,519,R24))+IF(K24=0,0,K24*N24),2)","v":429.47},{"$f":"TRUNC((IF(K24=0,I24*N24,(I24-K24)*N24))+(IF(R24<519,0,R24-519)),2)+M24","v":3904.3},{"$f":"S24+T24","v":4333.7700000000004},null,null,0,{"$f":"IF(N24>0.01,(T24-VLOOKUP(T24,quincenal,1))*VLOOKUP(T24,quincenal,3)+VLOOKUP(T24,quincenal,2)-VLOOKUP(T24,subquincenal,2),0)","v":333.77639999999997},{"$f":"TRUNC(IF(Y24>0.01,Y24,0),2)","v":333.77},{"$f":"TRUNC(IF(Y24<0.01,-Y24,0),2)","v":0},{"$f":"U24-W24-X24-Z24+AA24","v":4000.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},null,12]
[11,1,2,"FREGOSO PARRA MARTHA","FEPM871023ND1","FEPM871023MJCRRR07",null,"SECRETARIA PARTICULAR",15,"TARJETA",null,0,0,{"$f":"3349/15","v":223.26666666666668},{"$f":"TRUNC(N25*I25,2)","v":3349},{"$f":"TRUNC(N25*I25*0.04,2)","v":133.96},{"$f":"TRUNC(N25*0.07*I25,2)","v":234.43},{"$f":"L25","v":0},{"$f":"TRUNC(Q25+P25+(IF(R25>519,519,R25))+IF(K25=0,0,K25*N25),2)","v":368.39},{"$f":"TRUNC((IF(K25=0,I25*N25,(I25-K25)*N25))+(IF(R25<519,0,R25-519)),2)+M25","v":3349},{"$f":"S25+T25","v":3717.39},null,null,0,{"$f":"IF(N25>0.01,(T25-VLOOKUP(T25,quincenal,1))*VLOOKUP(T25,quincenal,3)+VLOOKUP(T25,quincenal,2)-VLOOKUP(T25,subquincenal,2),0)","v":135.18811199999996},{"$f":"TRUNC(IF(Y25>0.01,Y25,0),2)","v":135.18},{"$f":"TRUNC(IF(Y25<0.01,-Y25,0),2)","v":0},{"$f":"U25-W25-X25-Z25+AA25","v":3582.21},{"$f":"[2]PORTADA!$D$10","v":1},null,13]
[null,null,null,"PRESIDENCIA MUNICIPAL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O22:O25)","v":27563.31},{"$f":"SUM(P22:P25)","v":1102.53},1929.43,0,3031.9599999999996,27563.31,30595.27,0,0,0,3798.6088799999998,3798.5899999999997,0,26796.68]
[]
[null,null,null,"SECRETARIA GENERAL Y SINDICATURA"]
[13,1,5,"FREGOSO BARBOZA MARTIN DANIEL",null,null,null,"SINDICO MUNICIPAL",15,"TARJETA",null,0,0,{"$f":"10307/15","v":687.13333333333333},{"$f":"TRUNC(N29*I29,2)","v":10307},{"$f":"TRUNC(N29*I29*0.04,2)","v":412.28},{"$f":"TRUNC(N29*0.07*I29,2)","v":721.49},{"$f":"L29","v":0},{"$f":"TRUNC(Q29+P29+(IF(R29>519,519,R29))+IF(K29=0,0,K29*N29),2)","v":1133.77},{"$f":"TRUNC((IF(K29=0,I29*N29,(I29-K29)*N29))+(IF(R29<519,0,R29-519)),2)+M29","v":10307},{"$f":"S29+T29","v":11440.77},null,0,0,{"$f":"IF(N29>0.01,(T29-VLOOKUP(T29,quincenal,1))*VLOOKUP(T29,quincenal,3)+VLOOKUP(T29,quincenal,2)-VLOOKUP(T29,subquincenal,2),0)","v":1655.5186080000003},{"$f":"TRUNC(IF(Y29>0.01,Y29,0),2)","v":1655.51},{"$f":"TRUNC(IF(Y29<0.01,-Y29,0),2)","v":0},{"$f":"U29-W29-X29-Z29+AA29","v":9785.26},{"$f":"#REF!","v":{"$error":"#REF!"}},null,14]
[14,1,1,"MEDINA FLORES EVERARDO",null,null,"2012-10-01","SECRETARIO GENERAL",15,"TARJETA",null,0,0,617.49400000000003,{"$f":"TRUNC(N30*I30,2)","v":9262.41},{"$f":"TRUNC(N30*I30*0.04,2)","v":370.49},{"$f":"TRUNC(N30*0.07*I30,2)","v":648.36},{"$f":"L30","v":0},{"$f":"TRUNC(Q30+P30+(IF(R30>519,519,R30))+IF(K30=0,0,K30*N30),2)","v":1018.85},{"$f":"TRUNC((IF(K30=0,I30*N30,(I30-K30)*N30))+(IF(R30<519,0,R30-519)),2)+M30","v":9262.41},{"$f":"S30+T30","v":10281.26},null,null,0,{"$f":"IF(N30>0.01,(T30-VLOOKUP(T30,quincenal,1))*VLOOKUP(T30,quincenal,3)+VLOOKUP(T30,quincenal,2)-VLOOKUP(T30,subquincenal,2),0)","v":1431.2616},{"$f":"TRUNC(IF(Y30>0.01,Y30,0),2)","v":1431.26},{"$f":"TRUNC(IF(Y30<0.01,-Y30,0),2)","v":0},{"$f":"U30-W30-X30-Z30+AA30","v":8850},null,null,15]
[15,null,null,"GUTIERREZ SIORDIA LORENA",null,null,null,"SECRETARIA DE SECRETARIA GENERAL",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N31*I31,2)","v":2747.28},{"$f":"TRUNC(N31*I31*0.04,2)","v":109.89},{"$f":"TRUNC(N31*0.07*I31,2)","v":192.3},{"$f":"L31","v":0},{"$f":"TRUNC(Q31+P31+(IF(R31>519,519,R31))+IF(K31=0,0,K31*N31),2)","v":302.19},{"$f":"TRUNC((IF(K31=0,I31*N31,(I31-K31)*N31))+(IF(R31<519,0,R31-519)),2)+M31","v":2747.28},{"$f":"S31+T31","v":3049.4700000000003},null,null,0,{"$f":"IF(N31>0.01,(T31-VLOOKUP(T31,quincenal,1))*VLOOKUP(T31,quincenal,3)+VLOOKUP(T31,quincenal,2)-VLOOKUP(T31,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y31>0.01,Y31,0),2)","v":49.47},{"$f":"TRUNC(IF(Y31<0.01,-Y31,0),2)","v":0},{"$f":"U31-W31-X31-Z31+AA31","v":3000.0000000000005},null,null,16]
[16,null,null,"CARDENAS GUEVARA JORGE RAFAEL",null,null,null,"AUXILIAR ADMINISTRATIVO",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N32*I32,2)","v":2747.28},{"$f":"TRUNC(N32*I32*0.04,2)","v":109.89},{"$f":"TRUNC(N32*0.07*I32,2)","v":192.3},{"$f":"L32","v":0},{"$f":"TRUNC(Q32+P32+(IF(R32>519,519,R32))+IF(K32=0,0,K32*N32),2)","v":302.19},{"$f":"TRUNC((IF(K32=0,I32*N32,(I32-K32)*N32))+(IF(R32<519,0,R32-519)),2)+M32","v":2747.28},{"$f":"S32+T32","v":3049.4700000000003},null,null,0,{"$f":"IF(N32>0.01,(T32-VLOOKUP(T32,quincenal,1))*VLOOKUP(T32,quincenal,3)+VLOOKUP(T32,quincenal,2)-VLOOKUP(T32,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y32>0.01,Y32,0),2)","v":49.47},{"$f":"TRUNC(IF(Y32<0.01,-Y32,0),2)","v":0},{"$f":"U32-W32-X32-Z32+AA32","v":3000.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},null,17]
[null,null,null,"SECRETARIA GENERAL Y SINDICATURA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O29:O32)","v":25063.969999999998},1002.55,1754.4499999999998,0,2757,25063.969999999998,27820.97,0,0,0,{"$f":"SUM(Y29:Y32)","v":3185.7221600000003},3185.7099999999996,0,24635.260000000002]
[]
[null,null,null,"OFICIALIA MAYOR ADMINISTRATIVA"]
[null,null,null,"LEDESMA MORAN JOSE FEDERICO",null,null,null,"OFICIAL MAYOR",15,"TARJETA",null,0,0,491.06200000000001,{"$f":"TRUNC(N36*I36,2)","v":7365.93},{"$f":"TRUNC(N36*I36*0.04,2)","v":294.63},{"$f":"TRUNC(N36*0.07*I36,2)","v":515.61},{"$f":"L36","v":0},{"$f":"TRUNC(Q36+P36+(IF(R36>519,519,R36))+IF(K36=0,0,K36*N36),2)","v":810.24},{"$f":"TRUNC((IF(K36=0,I36*N36,(I36-K36)*N36))+(IF(R36<519,0,R36-519)),2)+M36","v":7365.93},{"$f":"S36+T36","v":8176.17},null,null,0,{"$f":"IF(N36>0.01,(T36-VLOOKUP(T36,quincenal,1))*VLOOKUP(T36,quincenal,3)+VLOOKUP(T36,quincenal,2)-VLOOKUP(T36,subquincenal,2),0)","v":1026.1734720000002},{"$f":"TRUNC(IF(Y36>0.01,Y36,0),2)","v":1026.17},{"$f":"TRUNC(IF(Y36<0.01,-Y36,0),2)","v":0},{"$f":"U36-W36-X36-Z36+AA36","v":7150},null,null,18]
[null,null,null,"VENTURA PEREZ HERLINDA AURORA","VEPH840722PR4","VEPH840722MJCNRR04",null,"SECRETARIA",15,"TARJETA",null,0,0,{"$f":"3056/15","v":203.73333333333332},{"$f":"TRUNC(N37*I37,2)","v":3056},{"$f":"TRUNC(N37*I37*0.04,2)","v":122.24},{"$f":"TRUNC(N37*0.07*I37,2)","v":213.92},0,{"$f":"TRUNC(Q37+P37+(IF(R37>519,519,R37))+IF(K37=0,0,K37*N37),2)","v":336.16},{"$f":"TRUNC((IF(K37=0,I37*N37,(I37-K37)*N37))+(IF(R37<519,0,R37-519)),2)+M37","v":3056},3392.16,null,0,0,{"$f":"IF(N37>0.01,(T37-VLOOKUP(T37,quincenal,1))*VLOOKUP(T37,quincenal,3)+VLOOKUP(T37,quincenal,2)-VLOOKUP(T37,subquincenal,2),0)","v":83.059711999999962},83.05,0,3309.1099999999997,{"$f":"[2]PORTADA!$D$10","v":1},null,19]
[20,null,null,"BARAJAS DE LA TORRE ANA MARIA","GOTG850723",null,null,"ATENCIO CIUDADANA",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N38*I38,2)","v":1709.65},{"$f":"TRUNC(N38*I38*0.04,2)","v":68.38},{"$f":"TRUNC(N38*0.07*I38,2)","v":119.67},{"$f":"L38","v":0},{"$f":"TRUNC(Q38+P38+(IF(R38>519,519,R38))+IF(K38=0,0,K38*N38),2)","v":188.05},{"$f":"TRUNC((IF(K38=0,I38*N38,(I38-K38)*N38))+(IF(R38<519,0,R38-519)),2)+M38","v":1709.65},{"$f":"S38+T38","v":1897.7},null,null,0,{"$f":"IF(N38>0.01,(T38-VLOOKUP(T38,quincenal,1))*VLOOKUP(T38,quincenal,3)+VLOOKUP(T38,quincenal,2)-VLOOKUP(T38,subquincenal,2),0)","v":-102.30023999999997},{"$f":"TRUNC(IF(Y38>0.01,Y38,0),2)","v":0},{"$f":"TRUNC(IF(Y38<0.01,-Y38,0),2)","v":102.3},{"$f":"U38-W38-X38-Z38+AA38","v":2000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,20]
[22,null,null,"HERNANDEZ SANCHEZ ROSA ELIZABETH",null,null,null,"CONSERJE",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N39*I39,2)","v":1709.65},{"$f":"TRUNC(N39*I39*0.04,2)","v":68.38},{"$f":"TRUNC(N39*0.07*I39,2)","v":119.67},{"$f":"L39","v":0},{"$f":"TRUNC(Q39+P39+(IF(R39>519,519,R39))+IF(K39=0,0,K39*N39),2)","v":188.05},{"$f":"TRUNC((IF(K39=0,I39*N39,(I39-K39)*N39))+(IF(R39<519,0,R39-519)),2)+M39","v":1709.65},{"$f":"S39+T39","v":1897.7},null,null,0,{"$f":"IF(N39>0.01,(T39-VLOOKUP(T39,quincenal,1))*VLOOKUP(T39,quincenal,3)+VLOOKUP(T39,quincenal,2)-VLOOKUP(T39,subquincenal,2),0)","v":-102.30023999999997},{"$f":"TRUNC(IF(Y39>0.01,Y39,0),2)","v":0},{"$f":"TRUNC(IF(Y39<0.01,-Y39,0),2)","v":102.3},{"$f":"U39-W39-X39-Z39+AA39","v":2000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,21]
[null,null,null,"OFICIALIA MAYOR ADMINISTRATIVA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36:O39)","v":13841.23},553.63,968.86999999999989,0,1522.5,13841.23,15363.730000000001,0,0,0,904.6327040000001,1109.22,204.6,14459.11]
[]
[null,null,null,"DEPARTAMENTO JURIDICO"]
[23,1,7,"FREGOSO MEDRANO CARLOS ALEJANDRO ",null,null,null,"DIRECTOR JURIDICO",15,"TARJETA",null,0,0,665.83500000000004,{"$f":"TRUNC(N43*I43,2)","v":9987.52},{"$f":"TRUNC(N43*I43*0.04,2)","v":399.5},{"$f":"TRUNC(N43*0.07*I43,2)","v":699.12},{"$f":"L43","v":0},{"$f":"TRUNC(Q43+P43+(IF(R43>519,519,R43))+IF(K43=0,0,K43*N43),2)","v":1098.6199999999999},{"$f":"TRUNC((IF(K43=0,I43*N43,(I43-K43)*N43))+(IF(R43<519,0,R43-519)),2)+M43","v":9987.52},{"$f":"S43+T43","v":11086.14},null,null,0,{"$f":"IF(N43>0.01,(T43-VLOOKUP(T43,quincenal,1))*VLOOKUP(T43,quincenal,3)+VLOOKUP(T43,quincenal,2)-VLOOKUP(T43,subquincenal,2),0)","v":1586.1450960000002},{"$f":"TRUNC(IF(Y43>0.01,Y43,0),2)","v":1586.14},{"$f":"TRUNC(IF(Y43<0.01,-Y43,0),2)","v":0},{"$f":"U43-W43-X43-Z43+AA43","v":9500},{"$f":"[2]PORTADA!$D$10","v":1},null,22]
[24,null,null,"REYNAGA LOPEZ NAHSDHELLY ALEJANDRA ",null,null,null,"AUXILIAR JURIDICO ",15,"TARJETA",null,0,0,{"$f":"3896/15","v":259.73333333333335},{"$f":"TRUNC(N44*I44,2)","v":3896},{"$f":"TRUNC(N44*I44*0.04,2)","v":155.84},{"$f":"TRUNC(N44*0.07*I44,2)","v":272.72000000000003},{"$f":"L44","v":0},{"$f":"TRUNC(Q44+P44+(IF(R44>519,519,R44))+IF(K44=0,0,K44*N44),2)","v":428.56},{"$f":"TRUNC((IF(K44=0,I44*N44,(I44-K44)*N44))+(IF(R44<519,0,R44-519)),2)+M44","v":3896},{"$f":"S44+T44","v":4324.5600000000004},null,null,0,{"$f":"IF(N44>0.01,(T44-VLOOKUP(T44,quincenal,1))*VLOOKUP(T44,quincenal,3)+VLOOKUP(T44,quincenal,2)-VLOOKUP(T44,subquincenal,2),0)","v":332.44839999999999},{"$f":"TRUNC(IF(Y44>0.01,Y44,0),2)","v":332.44},{"$f":"TRUNC(IF(Y44<0.01,-Y44,0),2)","v":0},{"$f":"U44-W44-X44-Z44+AA44","v":3992.1200000000003},null,null,23]
[null,null,null,"CARRILLO MUÑOZ CESAR OMAR","CARH770717","CARH770717HJCRDG01",null,"JUEZ MUNICIPAL",15,"TARJETA",null,0,0,{"$f":"4612/15","v":307.46666666666664},{"$f":"TRUNC(N45*I45,2)","v":4612},{"$f":"TRUNC(N45*I45*0.04,2)","v":184.48},{"$f":"TRUNC(N45*0.07*I45,2)","v":322.83999999999997},{"$f":"L45","v":0},{"$f":"TRUNC(Q45+P45+(IF(R45>519,519,R45))+IF(K45=0,0,K45*N45),2)","v":507.32},{"$f":"TRUNC((IF(K45=0,I45*N45,(I45-K45)*N45))+(IF(R45<519,0,R45-519)),2)+M45","v":4612},{"$f":"S45+T45","v":5119.32},null,null,0,{"$f":"IF(N45>0.01,(T45-VLOOKUP(T45,quincenal,1))*VLOOKUP(T45,quincenal,3)+VLOOKUP(T45,quincenal,2)-VLOOKUP(T45,subquincenal,2),0)","v":453.97588800000005},{"$f":"TRUNC(IF(Y45>0.01,Y45,0),2)","v":453.97},{"$f":"TRUNC(IF(Y45<0.01,-Y45,0),2)","v":0},{"$f":"U45-W45-X45-Z45+AA45","v":4665.3499999999995},null,null,24]
[null,null,null,"DEPARTAMENTO JURIDICO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O43:O45)","v":18495.52},739.82,1294.68,0,2034.4999999999998,18495.52,20530.02,0,0,0,2372.5693840000004,2372.5500000000002,0,18157.47]
[]
[null,null,null,"UNIDAD DE TRANSPARENCIA"]
[null,null,null,"ALDAZ VELEZ LORENZO MIGUEL","HEEG670312","HEER670312MJCRNS06","2007-01-08","DIRECTOR DE TRANSPARENCIA",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N49*I49,2)","v":6083.01},{"$f":"TRUNC(N49*I49*0.04,2)","v":243.32},{"$f":"TRUNC(N49*0.07*I49,2)","v":425.81},{"$f":"L49","v":0},{"$f":"TRUNC(Q49+P49+(IF(R49>519,519,R49))+IF(K49=0,0,K49*N49),2)","v":669.13},{"$f":"TRUNC((IF(K49=0,I49*N49,(I49-K49)*N49))+(IF(R49<519,0,R49-519)),2)+M49","v":6083.01},{"$f":"S49+T49","v":6752.14},null,null,0,{"$f":"IF(N49>0.01,(T49-VLOOKUP(T49,quincenal,1))*VLOOKUP(T49,quincenal,3)+VLOOKUP(T49,quincenal,2)-VLOOKUP(T49,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y49>0.01,Y49,0),2)","v":752.14},{"$f":"TRUNC(IF(Y49<0.01,-Y49,0),2)","v":0},{"$f":"U49-W49-X49-Z49+AA49","v":6000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,25]
[null,null,null,"MONTERO REYES HECTOR CARLOS","PAGM780607","PAGM780607MJCLRR03",null,"AUXILIAR DE TRANSPARENCIA",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N50*I50,2)","v":3266.9},{"$f":"TRUNC(N50*I50*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N50*0.07*I50,2)","v":228.68},{"$f":"L50","v":0},{"$f":"TRUNC(Q50+P50+(IF(R50>519,519,R50))+IF(K50=0,0,K50*N50),2)","v":359.35},{"$f":"TRUNC((IF(K50=0,I50*N50,(I50-K50)*N50))+(IF(R50<519,0,R50-519)),2)+M50","v":3266.9},{"$f":"S50+T50","v":3626.25},null,null,0,{"$f":"IF(N50>0.01,(T50-VLOOKUP(T50,quincenal,1))*VLOOKUP(T50,quincenal,3)+VLOOKUP(T50,quincenal,2)-VLOOKUP(T50,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y50>0.01,Y50,0),2)","v":126.25},{"$f":"TRUNC(IF(Y50<0.01,-Y50,0),2)","v":0},{"$f":"U50-W50-X50-Z50+AA50","v":3500},{"$f":"#REF!","v":{"$error":"#REF!"}},null,26]
[null,null,null,"UNIDAD DE TRANSPARENCIA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O49:O50)","v":9349.91},{"$f":"SUM(P49:P50)","v":373.99},654.49,0,1028.48,9349.91,10378.39,0,0,0,878.3973920000002,878.39,0,9500]
[]
[null,null,null,"DIRECCION DE REGISTRO CIVIL"]
[null,null,null,"HERNANDEZ ENRIQUEZ ROSA GUADALUPE","HEEG670312","HEER670312MJCRNS06","2007-01-08","JEFE OFICIAL DE REGISTRO CIVIL",15,"TARJETA",null,0,0,{"$f":"4459/15","v":297.26666666666665},{"$f":"TRUNC(N54*I54,2)","v":4459},{"$f":"TRUNC(N54*I54*0.04,2)","v":178.36},{"$f":"TRUNC(N54*0.07*I54,2)","v":312.13},{"$f":"L54","v":0},{"$f":"TRUNC(Q54+P54+(IF(R54>519,519,R54))+IF(K54=0,0,K54*N54),2)","v":490.49},{"$f":"TRUNC((IF(K54=0,I54*N54,(I54-K54)*N54))+(IF(R54<519,0,R54-519)),2)+M54","v":4459},{"$f":"S54+T54","v":4949.49},null,null,0,{"$f":"IF(N54>0.01,(T54-VLOOKUP(T54,quincenal,1))*VLOOKUP(T54,quincenal,3)+VLOOKUP(T54,quincenal,2)-VLOOKUP(T54,subquincenal,2),0)","v":426.55828800000006},{"$f":"TRUNC(IF(Y54>0.01,Y54,0),2)","v":426.55},{"$f":"TRUNC(IF(Y54<0.01,-Y54,0),2)","v":0},{"$f":"U54-W54-X54-Z54+AA54","v":4522.9399999999996},{"$f":"[2]PORTADA!$D$10","v":1},null,27]
[null,null,null,"PLASCENCIA GARCIA MIREYA ESMERALDA","PAGM780607","PAGM780607MJCLRR03",null,"OFICIAL AUX. DE REGISTRO CIVIL",15,"TARJETA",null,0,0,{"$f":"2492/15","v":166.13333333333333},{"$f":"TRUNC(N55*I55,2)","v":2492},{"$f":"TRUNC(N55*I55*0.04,2)","v":99.68},{"$f":"TRUNC(N55*0.07*I55,2)","v":174.44},{"$f":"L55","v":0},{"$f":"TRUNC(Q55+P55+(IF(R55>519,519,R55))+IF(K55=0,0,K55*N55),2)","v":274.12},{"$f":"TRUNC((IF(K55=0,I55*N55,(I55-K55)*N55))+(IF(R55<519,0,R55-519)),2)+M55","v":2492},{"$f":"S55+T55","v":2766.12},null,null,0,{"$f":"IF(N55>0.01,(T55-VLOOKUP(T55,quincenal,1))*VLOOKUP(T55,quincenal,3)+VLOOKUP(T55,quincenal,2)-VLOOKUP(T55,subquincenal,2),0)","v":6.6965119999999843},{"$f":"TRUNC(IF(Y55>0.01,Y55,0),2)","v":6.69},{"$f":"TRUNC(IF(Y55<0.01,-Y55,0),2)","v":0},{"$f":"U55-W55-X55-Z55+AA55","v":2759.43},{"$f":"[2]PORTADA!$D$10","v":1},null,28]
[null,null,null,"GONZALEZ MARTINEZ KARINA",null,null,null,"SECRETARIA EN REGISTRO CIVIL",15,"TARJETA",null,0,0,147.9015,{"$f":"TRUNC(N56*I56,2)","v":2218.52},{"$f":"TRUNC(N56*I56*0.04,2)","v":88.74},{"$f":"TRUNC(N56*0.07*I56,2)","v":155.29},{"$f":"L56","v":0},{"$f":"TRUNC(Q56+P56+(IF(R56>519,519,R56))+IF(K56=0,0,K56*N56),2)","v":244.03},{"$f":"TRUNC((IF(K56=0,I56*N56,(I56-K56)*N56))+(IF(R56<519,0,R56-519)),2)+M56","v":2218.52},{"$f":"S56+T56","v":2462.5500000000002},null,null,null,{"$f":"IF(N56>0.01,(T56-VLOOKUP(T56,quincenal,1))*VLOOKUP(T56,quincenal,3)+VLOOKUP(T56,quincenal,2)-VLOOKUP(T56,subquincenal,2),0)","v":-37.458112000000028},{"$f":"TRUNC(IF(Y56>0.01,Y56,0),2)","v":0},{"$f":"TRUNC(IF(Y56<0.01,-Y56,0),2)","v":37.450000000000003},{"$f":"U56-W56-X56-Z56+AA56","v":2500},null,null,29]
[28,1,14,"NAVARRO HERNANDEZ ALMA SAGRARIO",null,null,null,"ASISTENTE DE REGISTRO CIVIL",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N57*I57,2)","v":2747.28},{"$f":"TRUNC(N57*I57*0.04,2)","v":109.89},{"$f":"TRUNC(N57*0.07*I57,2)","v":192.3},{"$f":"L57","v":0},{"$f":"TRUNC(Q57+P57+(IF(R57>519,519,R57))+IF(K57=0,0,K57*N57),2)","v":302.19},{"$f":"TRUNC((IF(K57=0,I57*N57,(I57-K57)*N57))+(IF(R57<519,0,R57-519)),2)+M57","v":2747.28},{"$f":"S57+T57","v":3049.4700000000003},null,null,0,{"$f":"IF(N57>0.01,(T57-VLOOKUP(T57,quincenal,1))*VLOOKUP(T57,quincenal,3)+VLOOKUP(T57,quincenal,2)-VLOOKUP(T57,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y57>0.01,Y57,0),2)","v":49.47},{"$f":"TRUNC(IF(Y57<0.01,-Y57,0),2)","v":0},{"$f":"U57-W57-X57-Z57+AA57","v":3000.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},null,30]
[null,null,null,"DIRECCION DE REGISTRO CIVIL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O54:O57)","v":11916.800000000001},{"$f":"SUM(P54:P57)","v":476.67},834.16000000000008,0,1310.83,11916.800000000001,13227.630000000001,0,0,0,445.26766400000002,482.71000000000004,37.450000000000003,12782.369999999999]
[]
[null,null,null,"OFICIALIA MAYOR DE CULTURA"]
[null,null,null,"GONZALEZ PEÑA LETICIA","MAM620222",null,null,"DIRECTOR DE CULTURA Y TURISMO",15,"TARJETA",null,0,0,331.43599999999998,{"$f":"TRUNC(N61*I61,2)","v":4971.54},{"$f":"TRUNC(N61*I61*0.04,2)","v":198.86},{"$f":"TRUNC(N61*0.07*I61,2)","v":348},{"$f":"L61","v":0},{"$f":"TRUNC(Q61+P61+(IF(R61>519,519,R61))+IF(K61=0,0,K61*N61),2)","v":546.86},{"$f":"TRUNC((IF(K61=0,I61*N61,(I61-K61)*N61))+(IF(R61<519,0,R61-519)),2)+M61","v":4971.54},{"$f":"S61+T61","v":5518.4},null,null,0,{"$f":"IF(N61>0.01,(T61-VLOOKUP(T61,quincenal,1))*VLOOKUP(T61,quincenal,3)+VLOOKUP(T61,quincenal,2)-VLOOKUP(T61,subquincenal,2),0)","v":518.40545600000007},{"$f":"TRUNC(IF(Y61>0.01,Y61,0),2)","v":518.4},{"$f":"TRUNC(IF(Y61<0.01,-Y61,0),2)","v":0},{"$f":"U61-W61-X61-Z61+AA61","v":5000},{"$f":"[3]PORTADA!$D$10","v":1},null,31]
[null,null,null,"PARRA RON CARLOS ENRIQUE","PARC480708","PARC480708HJCRNR08","2004-01-01","CRONISTA",15,"TARJETA",null,0,0,{"$f":"3463/15","v":230.86666666666667},3463,138.52000000000001,242.41,0,380.93,3463,3843.93,null,null,0,{"$f":"IF(N62>0.01,(T62-VLOOKUP(T62,quincenal,1))*VLOOKUP(T62,quincenal,3)+VLOOKUP(T62,quincenal,2)-VLOOKUP(T62,subquincenal,2),0)","v":147.59131199999999},147.59,0,3696.3399999999997,{"$f":"[2]PORTADA!$D$10","v":1},null,32]
[null,null,null,"GARCIA GONZALEZ JAIRO ESAUD",null,null,null,"AUXILIAR DE DIRECCION DE CULTURA Y TURISMO",15,"TARJETA",null,0,0,165.506,{"$f":"TRUNC(N63*I63,2)","v":2482.59},{"$f":"TRUNC(N63*I63*0.04,2)","v":99.3},{"$f":"TRUNC(N63*0.07*I63,2)","v":173.78},{"$f":"L63","v":0},{"$f":"TRUNC(Q63+P63+(IF(R63>519,519,R63))+IF(K63=0,0,K63*N63),2)","v":273.08},{"$f":"TRUNC((IF(K63=0,I63*N63,(I63-K63)*N63))+(IF(R63<519,0,R63-519)),2)+M63","v":2482.59},{"$f":"S63+T63","v":2755.67},null,null,0,{"$f":"IF(N63>0.01,(T63-VLOOKUP(T63,quincenal,1))*VLOOKUP(T63,quincenal,3)+VLOOKUP(T63,quincenal,2)-VLOOKUP(T63,subquincenal,2),0)","v":5.6727039999999818},{"$f":"TRUNC(IF(Y63>0.01,Y63,0),2)","v":5.67},{"$f":"TRUNC(IF(Y63<0.01,-Y63,0),2)","v":0},{"$f":"U63-W63-X63-Z63+AA63","v":2750}]
[null,null,null,"GONZALEZ JUAREZ ALEJANDRA AMANDA",null,null,null,"SECRETARIA DE CASA DE LA CULTURA",15,"TARJETA",null,0,0,147.9015,{"$f":"TRUNC(N64*I64,2)","v":2218.52},{"$f":"TRUNC(N64*I64*0.04,2)","v":88.74},{"$f":"TRUNC(N64*0.07*I64,2)","v":155.29},{"$f":"L64","v":0},{"$f":"TRUNC(Q64+P64+(IF(R64>519,519,R64))+IF(K64=0,0,K64*N64),2)","v":244.03},{"$f":"TRUNC((IF(K64=0,I64*N64,(I64-K64)*N64))+(IF(R64<519,0,R64-519)),2)+M64","v":2218.52},{"$f":"S64+T64","v":2462.5500000000002},null,null,null,{"$f":"IF(N64>0.01,(T64-VLOOKUP(T64,quincenal,1))*VLOOKUP(T64,quincenal,3)+VLOOKUP(T64,quincenal,2)-VLOOKUP(T64,subquincenal,2),0)","v":-37.458112000000028},0,37.450000000000003,{"$f":"U64-W64-X64-Z64+AA64","v":2500},null,null,33]
[null,null,null,"GALLEGOS PEREZ DIEGO ARMANDO",null,null,null,"ENCARGADO DE LA CULTURA DEL AGUA",15,"TARJETA",null,0,0,172.83099999999999,{"$f":"TRUNC(N65*I65,2)","v":2592.46},{"$f":"TRUNC(N65*I65*0.04,2)","v":103.69},{"$f":"TRUNC(N65*0.07*I65,2)","v":181.47},{"$f":"L65","v":0},{"$f":"TRUNC(Q65+P65+(IF(R65>519,519,R65))+IF(K65=0,0,K65*N65),2)","v":285.16000000000003},{"$f":"TRUNC((IF(K65=0,I65*N65,(I65-K65)*N65))+(IF(R65<519,0,R65-519)),2)+M65","v":2592.46},{"$f":"S65+T65","v":2877.62},null,null,null,{"$f":"IF(N65>0.01,(T65-VLOOKUP(T65,quincenal,1))*VLOOKUP(T65,quincenal,3)+VLOOKUP(T65,quincenal,2)-VLOOKUP(T65,subquincenal,2),0)","v":17.626559999999984},{"$f":"TRUNC(IF(Y65>0.01,Y65,0),2)","v":17.62},{"$f":"TRUNC(IF(Y65<0.01,-Y65,0),2)","v":0},{"$f":"U65-W65-X65-Z65+AA65","v":2860},null,null,34]
[null,null,null,"ESPARZA ZAVALZA INDALECIO",null,null,null,"MAESTRO DE MUSICA",15,"TARJETA",null,0,0,154.56,{"$f":"TRUNC(N66*I66,2)","v":2318.4},{"$f":"TRUNC(N66*I66*0.04,2)","v":92.73},{"$f":"TRUNC(N66*0.07*I66,2)","v":162.28},{"$f":"L66","v":0},{"$f":"TRUNC(Q66+P66+(IF(R66>519,519,R66))+IF(K66=0,0,K66*N66),2)","v":255.01},{"$f":"TRUNC((IF(K66=0,I66*N66,(I66-K66)*N66))+(IF(R66<519,0,R66-519)),2)+M66","v":2318.4},{"$f":"S66+T66","v":2573.41},null,null,null,{"$f":"IF(N66>0.01,(T66-VLOOKUP(T66,quincenal,1))*VLOOKUP(T66,quincenal,3)+VLOOKUP(T66,quincenal,2)-VLOOKUP(T66,subquincenal,2),0)","v":-26.59116800000001},0,26.59,{"$f":"U66-W66-X66-Z66+AA66","v":2600},null,null,35]
[null,null,null,"CARRILLO DIAZ ANTONIO SALVADOR",null,null,null,"INTENDENTE",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N67*I67,2)","v":1709.65},{"$f":"TRUNC(N67*I67*0.04,2)","v":68.38},{"$f":"TRUNC(N67*0.07*I67,2)","v":119.67},{"$f":"L67","v":0},{"$f":"TRUNC(Q67+P67+(IF(R67>519,519,R67))+IF(K67=0,0,K67*N67),2)","v":188.05},{"$f":"TRUNC((IF(K67=0,I67*N67,(I67-K67)*N67))+(IF(R67<519,0,R67-519)),2)+M67","v":1709.65},{"$f":"S67+T67","v":1897.7},null,null,0,{"$f":"IF(N67>0.01,(T67-VLOOKUP(T67,quincenal,1))*VLOOKUP(T67,quincenal,3)+VLOOKUP(T67,quincenal,2)-VLOOKUP(T67,subquincenal,2),0)","v":-102.30023999999997},0,102.3,{"$f":"U67-W67-X67-Z67+AA67","v":2000},null,null,36]
[null,null,null,"ARCINIEGA RODRIGUEZ ANTONIO",null,null,null,"ENCARGADO DE  EQUIPO DE SONIDO",15,"TARJETA",null,0,0,{"$f":"4060/15","v":270.66666666666669},4060,162.4,284.2,0,446.6,4060,4506.6000000000004,null,null,0,{"$f":"IF(N68>0.01,(T68-VLOOKUP(T68,quincenal,1))*VLOOKUP(T68,quincenal,3)+VLOOKUP(T68,quincenal,2)-VLOOKUP(T68,subquincenal,2),0)","v":358.6884},358.68,0,4147.92,{"$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,{"$f":"SUM(O61:O68)","v":23816.160000000003},{"$f":"SUM(P61:P68)","v":952.61999999999989},1667.1,0,2619.7199999999998,23816.160000000003,26435.879999999997,0,0,0,881.63491199999999,1047.96,166.34,25554.260000000002]
[]
[null,null,null,"DEPARTAMENTO DE PRENSA Y PUBLICIDAD"]
[35,1,19,"DIAZ PEREZ SAMUEL",null,null,null,"DIRECTOR DE PRENSA Y PUBLICIDAD",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N72*I72,2)","v":6083.01},{"$f":"TRUNC(N72*I72*0.04,2)","v":243.32},{"$f":"TRUNC(N72*0.07*I72,2)","v":425.81},{"$f":"L72","v":0},{"$f":"TRUNC(Q72+P72+(IF(R72>519,519,R72))+IF(K72=0,0,K72*N72),2)","v":669.13},{"$f":"TRUNC((IF(K72=0,I72*N72,(I72-K72)*N72))+(IF(R72<519,0,R72-519)),2)+M72","v":6083.01},{"$f":"S72+T72","v":6752.14},null,null,0,{"$f":"IF(N72>0.01,(T72-VLOOKUP(T72,quincenal,1))*VLOOKUP(T72,quincenal,3)+VLOOKUP(T72,quincenal,2)-VLOOKUP(T72,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y72>0.01,Y72,0),2)","v":752.14},{"$f":"TRUNC(IF(Y72<0.01,-Y72,0),2)","v":0},{"$f":"U72-W72-X72-Z72+AA72","v":6000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,38]
[36,null,null,"GOMEZ SANTIAGO MARIA DOLORES",null,null,null,"SECRETARIA DE COMUNICACIÓN SOCIAL",15,"TARJETA",null,0,0,101.23,{"$f":"TRUNC(N73*I73,2)","v":1518.45},{"$f":"TRUNC(N73*I73*0.04,2)","v":60.73},{"$f":"TRUNC(N73*0.07*I73,2)","v":106.29},{"$f":"L73","v":0},{"$f":"TRUNC(Q73+P73+(IF(R73>519,519,R73))+IF(K73=0,0,K73*N73),2)","v":167.02},{"$f":"TRUNC((IF(K73=0,I73*N73,(I73-K73)*N73))+(IF(R73<519,0,R73-519)),2)+M73","v":1518.45},{"$f":"S73+T73","v":1685.47},null,0,0,{"$f":"IF(N73>0.01,(T73-VLOOKUP(T73,quincenal,1))*VLOOKUP(T73,quincenal,3)+VLOOKUP(T73,quincenal,2)-VLOOKUP(T73,subquincenal,2),0)","v":-114.53703999999998},{"$f":"TRUNC(IF(Y73>0.01,Y73,0),2)","v":0},{"$f":"TRUNC(IF(Y73<0.01,-Y73,0),2)","v":114.53},{"$f":"U73-W73-X73-Z73+AA73","v":1800},{"$f":"#REF!","v":{"$error":"#REF!"}},null,39]
[null,null,null,"VAZQUEZ PEREZ LUIS ENRIQUE",null,null,null,"AUXILIAR DE COMUNICACIÓN SOCIAL (FOTOGRAFO Y VIDEO)",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N74*I74,2)","v":2747.28},{"$f":"TRUNC(N74*I74*0.04,2)","v":109.89},{"$f":"TRUNC(N74*0.07*I74,2)","v":192.3},{"$f":"L74","v":0},{"$f":"TRUNC(Q74+P74+(IF(R74>519,519,R74))+IF(K74=0,0,K74*N74),2)","v":302.19},{"$f":"TRUNC((IF(K74=0,I74*N74,(I74-K74)*N74))+(IF(R74<519,0,R74-519)),2)+M74","v":2747.28},{"$f":"S74+T74","v":3049.4700000000003},null,null,0,{"$f":"IF(N74>0.01,(T74-VLOOKUP(T74,quincenal,1))*VLOOKUP(T74,quincenal,3)+VLOOKUP(T74,quincenal,2)-VLOOKUP(T74,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y74>0.01,Y74,0),2)","v":49.47},{"$f":"TRUNC(IF(Y74<0.01,-Y74,0),2)","v":0},{"$f":"U74-W74-X74-Z74+AA74","v":3000.0000000000005},null,null,40]
[null,null,null,"DEPARTAMENTO DE PRENSA Y PUBLICIDAD",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O72:O74)","v":10348.74},{"$f":"SUM(P72:P74)","v":413.94},724.40000000000009,0,1138.3399999999999,10348.74,11487.080000000002,0,0,0,687.07569600000033,801.61,114.53,10800]
[]
[null,null,null,"DIRECCION DE EDUCACION"]
[37,null,null,"MARISCAL MORALES ILIANA PATRICIA",null,null,null,"SUBDIRECTORA DE TALLERES DE CAPACITACION",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N78*I78,2)","v":3266.9},{"$f":"TRUNC(N78*I78*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N78*0.07*I78,2)","v":228.68},{"$f":"L78","v":0},{"$f":"TRUNC(Q78+P78+(IF(R78>519,519,R78))+IF(K78=0,0,K78*N78),2)","v":359.35},{"$f":"TRUNC((IF(K78=0,I78*N78,(I78-K78)*N78))+(IF(R78<519,0,R78-519)),2)+M78","v":3266.9},{"$f":"S78+T78","v":3626.25},null,null,0,{"$f":"IF(N78>0.01,(T78-VLOOKUP(T78,quincenal,1))*VLOOKUP(T78,quincenal,3)+VLOOKUP(T78,quincenal,2)-VLOOKUP(T78,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y78>0.01,Y78,0),2)","v":126.25},{"$f":"TRUNC(IF(Y78<0.01,-Y78,0),2)","v":0},{"$f":"U78-W78-X78-Z78+AA78","v":3500},null,null,41]
[null,null,null,"ESPERICUETA HERNANDEZ EFRAIN",null,null,null,"TALLERES DE CAPACITACION",15,"TARJETA",null,0,0,260.28699999999998,{"$f":"TRUNC(N79*I79,2)","v":3904.3},{"$f":"TRUNC(N79*I79*0.04,2)","v":156.16999999999999},{"$f":"TRUNC(N79*0.07*I79,2)","v":273.3},{"$f":"L79","v":0},{"$f":"TRUNC(Q79+P79+(IF(R79>519,519,R79))+IF(K79=0,0,K79*N79),2)","v":429.47},{"$f":"TRUNC((IF(K79=0,I79*N79,(I79-K79)*N79))+(IF(R79<519,0,R79-519)),2)+M79","v":3904.3},{"$f":"S79+T79","v":4333.7700000000004},null,null,0,{"$f":"IF(N79>0.01,(T79-VLOOKUP(T79,quincenal,1))*VLOOKUP(T79,quincenal,3)+VLOOKUP(T79,quincenal,2)-VLOOKUP(T79,subquincenal,2),0)","v":333.77639999999997},{"$f":"TRUNC(IF(Y79>0.01,Y79,0),2)","v":333.77},{"$f":"TRUNC(IF(Y79<0.01,-Y79,0),2)","v":0},{"$f":"U79-W79-X79-Z79+AA79","v":4000.0000000000005},null,null,42]
[null,null,null,"MADRID ZAINES DELIA CAROLINA",null,null,null,"SECRETARIA DE DIRECTOR DE EDUCACION",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N80*I80,2)","v":2747.28},{"$f":"TRUNC(N80*I80*0.04,2)","v":109.89},{"$f":"TRUNC(N80*0.07*I80,2)","v":192.3},{"$f":"L80","v":0},{"$f":"TRUNC(Q80+P80+(IF(R80>519,519,R80))+IF(K80=0,0,K80*N80),2)","v":302.19},{"$f":"TRUNC((IF(K80=0,I80*N80,(I80-K80)*N80))+(IF(R80<519,0,R80-519)),2)+M80","v":2747.28},{"$f":"S80+T80","v":3049.4700000000003},null,null,0,{"$f":"IF(N80>0.01,(T80-VLOOKUP(T80,quincenal,1))*VLOOKUP(T80,quincenal,3)+VLOOKUP(T80,quincenal,2)-VLOOKUP(T80,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y80>0.01,Y80,0),2)","v":49.47},{"$f":"TRUNC(IF(Y80<0.01,-Y80,0),2)","v":0},{"$f":"U80-W80-X80-Z80+AA80","v":3000.0000000000005},null,null,43]
[37,null,null,"GAVILANES NAVARRO JOSE RICARDO",null,null,null,"CHIOFER CAMION ESTUDIANTES",6,"TARJETA",null,0,0,191.14279999999999,{"$f":"TRUNC(N81*I81,2)","v":1146.8499999999999},{"$f":"TRUNC(N81*I81*0.04,2)","v":45.87},{"$f":"TRUNC(N81*0.07*I81,2)","v":80.27},{"$f":"L81","v":0},{"$f":"TRUNC(Q81+P81+(IF(R81>519,519,R81))+IF(K81=0,0,K81*N81),2)","v":126.14},{"$f":"TRUNC((IF(K81=0,I81*N81,(I81-K81)*N81))+(IF(R81<519,0,R81-519)),2)+M81","v":1146.8499999999999},{"$f":"S81+T81","v":1272.99},null,null,0,{"$f":"IF(N81>0.01,(T81-VLOOKUP(T81,quincenal,1))*VLOOKUP(T81,quincenal,3)+VLOOKUP(T81,quincenal,2)-VLOOKUP(T81,subquincenal,2),0)","v":-138.31943999999999},{"$f":"TRUNC(IF(Y81>0.01,Y81,0),2)","v":0},{"$f":"TRUNC(IF(Y81<0.01,-Y81,0),2)","v":138.31},{"$f":"U81-W81-X81-Z81+AA81","v":1411.3},{"$f":"#REF!","v":{"$error":"#REF!"}},null,44]
[null,null,null,"DIRECCION DE EDUCACION",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O78:O81)","v":11065.330000000002},{"$f":"SUM(P78:P81)","v":442.59999999999997},774.55,0,1217.1500000000001,11065.330000000002,12282.480000000001,0,0,0,371.18356799999998,509.49,138.31,11911.3]
[]
[null,null,null,"DEPARTAMENTO DE PROMOCION Y DESARROLLO ECONOMICO"]
[38,null,null,"RODRIGUEZ ARQUIETA FAUSTO RAFAEL",null,null,null,"DIRECTOR",15,"TARJETA",null,0,0,479.90589999999997,{"$f":"TRUNC(N85*I85,2)","v":7198.58},{"$f":"TRUNC(N85*I85*0.04,2)","v":287.94},{"$f":"TRUNC(N85*0.07*I85,2)","v":503.9},{"$f":"L85","v":0},{"$f":"TRUNC(Q85+P85+(IF(R85>519,519,R85))+IF(K85=0,0,K85*N85),2)","v":791.84},{"$f":"TRUNC((IF(K85=0,I85*N85,(I85-K85)*N85))+(IF(R85<519,0,R85-519)),2)+M85","v":7198.58},{"$f":"S85+T85","v":7990.42},null,null,0,{"$f":"IF(N85>0.01,(T85-VLOOKUP(T85,quincenal,1))*VLOOKUP(T85,quincenal,3)+VLOOKUP(T85,quincenal,2)-VLOOKUP(T85,subquincenal,2),0)","v":990.42751200000009},{"$f":"TRUNC(IF(Y85>0.01,Y85,0),2)","v":990.42},{"$f":"TRUNC(IF(Y85<0.01,-Y85,0),2)","v":0},{"$f":"U85-W85-X85-Z85+AA85","v":7000},null,null,45]
[null,null,null,"HERNANDEZ ENRIQUEZ J. FILEMON",null,null,null,"DIRECTOR DE PROMOCION ECONOMICA",15,"TARJETA",null,0,0,442.72,6640.8,265.63,464.85,0,730.48,6640.8,7371.2800000000007,null,null,0,871.28570400000012,871.28,{"$f":"TRUNC(IF(Y86<0.01,-Y86,0),2)","v":0},6500.0000000000009,null,null,46]
[null,null,null,"PLASCENCIA GARCIA OSCARI","PAGO721112","PAGO721112HJCLRS01",null,"AUXILIAR ADMINISTRATIVO DE DESARROLLO RURAL",15,"TARJETA",null,0,0,{"$f":"3086/15","v":205.73333333333332},3086,123.44,216.02,0,339.46,3086,3425.46,null,null,0,106.57371199999997,106.57,{"$f":"TRUNC(IF(Y87<0.01,-Y87,0),2)","v":0},3318.89,null,null,47]
[null,null,null,"MARTINEZ MARTINEZ SALVADOR TAURINO JONATHAN","MAMS900118M80","MAMS900118HJCRRL02","2007-01-01","AYUDANTE",15,"TARJETA",null,0,0,{"$f":"2788/15","v":185.86666666666667},2788,111.52,195.16,0,306.68,2788,3094.68,null,null,0,53.90131199999999,53.9,0,3040.7799999999997,{"$f":"[2]PORTADA!$D$10","v":1},null,48]
[null,null,null,"ULLOA MARTINEZ MARCELA GUADALUPE","UOMM730612","UOMM730612MJCLRR02","1998-01-01","AUXILIAR ADMINISTRATIVO",15,"TARJETA",null,0,0,{"$f":"3261/15","v":217.4},3261,130.44,228.27,0,358.71,3261,3619.71,null,null,0,125.61371199999999,125.61,{"$f":"TRUNC(IF(Y89<0.01,-Y89,0),2)","v":0},3494.1,{"$f":"[2]PORTADA!$D$10","v":1},null,49]
[null,null,null,"GONZALEZ MARTINEZ ERIKA DELFINA","FEIA870704","FEIA870704MJCRXN02",null,"SECRETARIA",15,"TARJETA",null,0,0,{"$f":"2658/15","v":177.2},2658,106.32,186.06,0,292.38,2658,2950.38,null,0,0,39.757311999999985,39.75,{"$f":"TRUNC(IF(Y90<0.01,-Y90,0),2)","v":0},2910.63,{"$f":"[2]PORTADA!$D$10","v":1},null,50]
[null,null,null,"DEPARTAMENTO DE PROMOCION Y DESARROLLO ECONOMICO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O85:O90)","v":25632.38},{"$f":"SUM(P85:P90)","v":1025.29},1794.26,0,2819.55,25632.38,28451.93,0,0,0,2187.559264,2187.5299999999997,0,26264.399999999998]
[]
[null,null,null,"OFICINA DE ENLACE RELACIONES EXTERIORES"]
[null,null,null,"GUTIERREZ REYES CAROL","GURC680410","GURC680410MJCTYR00","2001-01-02","JEFE ADMINISTRADOR",9,"TARJETA",null,0,0,370.2,{"$f":"TRUNC(N94*I94,2)","v":3331.8},{"$f":"TRUNC(N94*I94*0.04,2)","v":133.27000000000001},{"$f":"TRUNC(N94*0.07*I94,2)","v":233.22},{"$f":"L94","v":0},{"$f":"TRUNC(Q94+P94+(IF(R94>519,519,R94))+IF(K94=0,0,K94*N94),2)","v":366.49},{"$f":"TRUNC((IF(K94=0,I94*N94,(I94-K94)*N94))+(IF(R94<519,0,R94-519)),2)+M94","v":3331.8},{"$f":"S94+T94","v":3698.29},null,null,0,{"$f":"IF(N94>0.01,(T94-VLOOKUP(T94,quincenal,1))*VLOOKUP(T94,quincenal,3)+VLOOKUP(T94,quincenal,2)-VLOOKUP(T94,subquincenal,2),0)","v":133.31675199999998},{"$f":"TRUNC(IF(Y94>0.01,Y94,0),2)","v":133.31},{"$f":"TRUNC(IF(Y94<0.01,-Y94,0),2)","v":0},{"$f":"U94-W94-X94-Z94+AA94","v":3564.98},{"$f":"[2]PORTADA!$D$10","v":1},null,51]
[null,null,null,"FREGOSO HURTADO ALEJANDRA","FEHA831218","FEHA831218MJCRRL07","2007-04-10","AUX. ADMINISTRATIVO",15,"TARJETA",null,0,0,211.816,{"$f":"TRUNC(N95*I95,2)","v":3177.24},{"$f":"TRUNC(N95*I95*0.04,2)","v":127.08},{"$f":"TRUNC(N95*0.07*I95,2)","v":222.4},{"$f":"L95","v":0},{"$f":"TRUNC(Q95+P95+(IF(R95>519,519,R95))+IF(K95=0,0,K95*N95),2)","v":349.48},{"$f":"TRUNC((IF(K95=0,I95*N95,(I95-K95)*N95))+(IF(R95<519,0,R95-519)),2)+M95","v":3177.24},{"$f":"S95+T95","v":3526.72},null,null,0,{"$f":"IF(N95>0.01,(T95-VLOOKUP(T95,quincenal,1))*VLOOKUP(T95,quincenal,3)+VLOOKUP(T95,quincenal,2)-VLOOKUP(T95,subquincenal,2),0)","v":116.50062399999996},{"$f":"TRUNC(IF(Y95>0.01,Y95,0),2)","v":116.5},{"$f":"TRUNC(IF(Y95<0.01,-Y95,0),2)","v":0},{"$f":"U95-W95-X95-Z95+AA95","v":3410.22},{"$f":"[2]PORTADA!$D$10","v":1},null,52]
[null,null,null,"LOPEZ MARTINEZ YVETTE AMALIA MARGARITA","LOMY681017","LOMY681017MJCPRV08","2001-01-01","SUPERVISOR",15,"TARJETA",null,0,0,211.816,{"$f":"TRUNC(N96*I96,2)","v":3177.24},{"$f":"TRUNC(N96*I96*0.04,2)","v":127.08},{"$f":"TRUNC(N96*0.07*I96,2)","v":222.4},{"$f":"L96","v":0},{"$f":"TRUNC(Q96+P96+(IF(R96>519,519,R96))+IF(K96=0,0,K96*N96),2)","v":349.48},{"$f":"TRUNC((IF(K96=0,I96*N96,(I96-K96)*N96))+(IF(R96<519,0,R96-519)),2)+M96","v":3177.24},{"$f":"S96+T96","v":3526.72},null,null,0,{"$f":"IF(N96>0.01,(T96-VLOOKUP(T96,quincenal,1))*VLOOKUP(T96,quincenal,3)+VLOOKUP(T96,quincenal,2)-VLOOKUP(T96,subquincenal,2),0)","v":116.50062399999996},{"$f":"TRUNC(IF(Y96>0.01,Y96,0),2)","v":116.5},{"$f":"TRUNC(IF(Y96<0.01,-Y96,0),2)","v":0},{"$f":"U96-W96-X96-Z96+AA96","v":3410.22},{"$f":"[2]PORTADA!$D$10","v":1},null,53]
[null,null,null,"ESTRADA GOMEZ JUAN CARLOS","EAGJ510220NR1","EAGJ510220HJCSMN09",null,"MENSAJERO",15,"TARJETA",null,0,0,216.7235,{"$f":"TRUNC(N97*I97,2)","v":3250.85},{"$f":"TRUNC(N97*I97*0.04,2)","v":130.03},{"$f":"TRUNC(N97*0.07*I97,2)","v":227.55},{"$f":"L97","v":0},{"$f":"TRUNC(Q97+P97+(IF(R97>519,519,R97))+IF(K97=0,0,K97*N97),2)","v":357.58},{"$f":"TRUNC((IF(K97=0,I97*N97,(I97-K97)*N97))+(IF(R97<519,0,R97-519)),2)+M97","v":3250.85},{"$f":"S97+T97","v":3608.43},null,0,0,{"$f":"IF(N97>0.01,(T97-VLOOKUP(T97,quincenal,1))*VLOOKUP(T97,quincenal,3)+VLOOKUP(T97,quincenal,2)-VLOOKUP(T97,subquincenal,2),0)","v":124.50939199999996},{"$f":"TRUNC(IF(Y97>0.01,Y97,0),2)","v":124.5},{"$f":"TRUNC(IF(Y97<0.01,-Y97,0),2)","v":0},{"$f":"U97-W97-X97-Z97+AA97","v":3483.93},{"$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,{"$f":"SUM(O94:O97)","v":12937.13},517.46,905.56999999999994,0,1423.03,12937.13,14360.16,0,0,0,490.8273919999998,490.81,0,13869.35]
[]
[null,null,null,"AGENCIAS MUNICIPALES"]
[46,"2","2","GOMEZ HERNANDEZ FRANCISCO JAVIER",null,null,null,"AGENTE MUNICIPAL STA. ROSALIA",15,"TARJETA",null,0,0,101.23,{"$f":"TRUNC(N101*I101,2)","v":1518.45},{"$f":"TRUNC(N101*I101*0.04,2)","v":60.73},{"$f":"TRUNC(N101*0.07*I101,2)","v":106.29},{"$f":"L101","v":0},{"$f":"TRUNC(Q101+P101+(IF(R101>519,519,R101))+IF(K101=0,0,K101*N101),2)","v":167.02},{"$f":"TRUNC((IF(K101=0,I101*N101,(I101-K101)*N101))+(IF(R101<519,0,R101-519)),2)+M101","v":1518.45},{"$f":"S101+T101","v":1685.47},null,null,0,{"$f":"IF(N101>0.01,(T101-VLOOKUP(T101,quincenal,1))*VLOOKUP(T101,quincenal,3)+VLOOKUP(T101,quincenal,2)-VLOOKUP(T101,subquincenal,2),0)","v":-114.53703999999998},{"$f":"TRUNC(IF(Y101>0.01,Y101,0),2)","v":0},{"$f":"TRUNC(IF(Y101<0.01,-Y101,0),2)","v":114.53},{"$f":"U101-W101-X101-Z101+AA101","v":1800},{"$f":"#REF!","v":{"$error":"#REF!"}},null,55]
[47,"2","2","BERNAL LOPEZ JUAN MANUEL","PALR",null,null,"AGENTE MUNICIPAL SAN RAFAEL",15,"TARJETA",null,0,0,82.109700000000004,1231.6400000000001,49.26,86.21,0,135.47,1231.6400000000001,1367.1100000000001,null,null,0,-132.89287999999999,{"$f":"TRUNC(IF(Y102>0.01,Y102,0),2)","v":0},{"$f":"TRUNC(IF(Y102<0.01,-Y102,0),2)","v":132.88999999999999},1500,{"$f":"#REF!","v":{"$error":"#REF!"}},null,56]
[48,"2","2","GONZALEZ RUIZ JOSE ANGEL","GORA710130M39","GORA710130HJCNZN08",null,"AGENTE MUNICIPAL SAN SEBASTIAN",15,"TARJETA",null,0,0,75.735900000000001,1136.03,45.44,79.52,0,124.96,1136.03,1260.99,null,null,0,-139.01191999999998,{"$f":"TRUNC(IF(Y103>0.01,Y103,0),2)","v":0},{"$f":"TRUNC(IF(Y103<0.01,-Y103,0),2)","v":139.01},1400,{"$f":"#REF!","v":{"$error":"#REF!"}},null,57]
[49,"2","2","SIERRA LLAMAS JUAN JOSE","SILJ660418","SILJ660418HJCRLN17",null,"AGENTE MUNICIPAL DE PUERTA DE PERICOS",15,"TARJETA",null,0,0,88.483400000000003,1327.25,53.09,92.9,0,145.99,1327.25,1473.24,null,null,0,-126.77383999999998,{"$f":"TRUNC(IF(Y104>0.01,Y104,0),2)","v":0},{"$f":"TRUNC(IF(Y104<0.01,-Y104,0),2)","v":126.77},1600.01,{"$f":"#REF!","v":{"$error":"#REF!"}},null,58]
[null,null,null,"NAVARRO AYON RAUL JAIME",null,null,null,"AGENTE MUNICIPAL DE LA MAZATA",15,"TARJETA",null,0,0,82.109700000000004,{"$f":"TRUNC(N105*I105,2)","v":1231.6400000000001},{"$f":"TRUNC(N105*I105*0.04,2)","v":49.26},{"$f":"TRUNC(N105*0.07*I105,2)","v":86.21},{"$f":"L105","v":0},{"$f":"TRUNC(Q105+P105+(IF(R105>519,519,R105))+IF(K105=0,0,K105*N105),2)","v":135.47},{"$f":"TRUNC((IF(K105=0,I105*N105,(I105-K105)*N105))+(IF(R105<519,0,R105-519)),2)+M105","v":1231.6400000000001},{"$f":"S105+T105","v":1367.1100000000001},null,null,0,{"$f":"IF(N105>0.01,(T105-VLOOKUP(T105,quincenal,1))*VLOOKUP(T105,quincenal,3)+VLOOKUP(T105,quincenal,2)-VLOOKUP(T105,subquincenal,2),0)","v":-132.89287999999999},0,132.88999999999999,{"$f":"U105-W105-X105-Z105+AA105","v":1500},null,null,59]
[null,null,null,"PEREZ LLAMAS SAMUEL",null,null,null,"AGENTE MUNICIPAL DE LA QUEBRADA",15,"TARJETA",null,0,0,113.977,1709.65,68.38,119.67,0,188.05,1709.65,1897.7,null,null,0,-102.30023999999997,0,102.3,2000,null,null,60]
[54,null,null,"SANCHEZ NAVARRO ARTURO",null,null,null,"ASEO LA MAZATA",15,"TARJETA",null,null,null,90.65,{"$f":"TRUNC(N107*I107,2)","v":1359.75},{"$f":"TRUNC(N107*I107*0.04,2)","v":54.39},{"$f":"TRUNC(N107*0.07*I107,2)","v":95.18},{"$f":"L107","v":0},{"$f":"TRUNC(Q107+P107+(IF(R107>519,519,R107))+IF(K107=0,0,K107*N107),2)","v":149.57},{"$f":"TRUNC((IF(K107=0,I107*N107,(I107-K107)*N107))+(IF(R107<519,0,R107-519)),2)+M107","v":1359.75},{"$f":"S107+T107","v":1509.32},null,null,0,{"$f":"IF(N107>0.01,(T107-VLOOKUP(T107,quincenal,1))*VLOOKUP(T107,quincenal,3)+VLOOKUP(T107,quincenal,2)-VLOOKUP(T107,subquincenal,2),0)","v":-124.69383999999998},{"$f":"TRUNC(IF(Y107>0.01,Y107,0),2)","v":0},{"$f":"TRUNC(IF(Y107<0.01,-Y107,0),2)","v":124.69},{"$f":"U107-W107-X107-Z107+AA107","v":1634.01},null,null,61]
[null,null,null,"LOPEZ SILVA CARLOS DAMIAN","GOHV780710","GOHV780710HJCMRL00","2007-02-01","CHOFER RECOLECTOR",15,"TARJETA",null,0,0,{"$f":"2530/15","v":168.66666666666666},{"$f":"TRUNC(N108*I108,2)","v":2530},{"$f":"TRUNC(N108*I108*0.04,2)","v":101.2},{"$f":"TRUNC(N108*0.07*I108,2)","v":177.1},{"$f":"L108","v":0},{"$f":"TRUNC(Q108+P108+(IF(R108>519,519,R108))+IF(K108=0,0,K108*N108),2)","v":278.3},{"$f":"TRUNC((IF(K108=0,I108*N108,(I108-K108)*N108))+(IF(R108<519,0,R108-519)),2)+M108","v":2530},{"$f":"S108+T108","v":2808.3},null,null,0,{"$f":"IF(N108>0.01,(T108-VLOOKUP(T108,quincenal,1))*VLOOKUP(T108,quincenal,3)+VLOOKUP(T108,quincenal,2)-VLOOKUP(T108,subquincenal,2),0)","v":10.830911999999984},{"$f":"TRUNC(IF(Y108>0.01,Y108,0),2)","v":10.83},{"$f":"TRUNC(IF(Y108<0.01,-Y108,0),2)","v":0},{"$f":"U108-W108-X108-Z108+AA108","v":2797.4700000000003},{"$f":"[2]PORTADA!$D$10","v":1},null,62]
[null,null,null,"AGENCIAS MUNICIPALES",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O101:O108)","v":12044.41},{"$f":"SUM(P101:P108)","v":481.75},843.08,0,1324.83,12044.41,13369.240000000002,0,0,0,-862.27172799999994,10.83,873.07999999999993,14231.490000000002]
[]
[null,null,null,"ADMIN ISTRACION DE LA HACIENDA MUNICIPAL"]
[56,"3","1","CAMARENA GONZALEZ RUBIO MARIO",null,null,null,"ENCARGADO DE HACIENDA PUBLICA",15,"TARJETA",null,0,0,{"$f":"8355/15","v":557},{"$f":"TRUNC(N112*I112,2)","v":8355},{"$f":"TRUNC(N112*I112*0.04,2)","v":334.2},{"$f":"TRUNC(N112*0.07*I112,2)","v":584.85},{"$f":"L112","v":0},{"$f":"TRUNC(Q112+P112+(IF(R112>519,519,R112))+IF(K112=0,0,K112*N112),2)","v":919.05},{"$f":"TRUNC((IF(K112=0,I112*N112,(I112-K112)*N112))+(IF(R112<519,0,R112-519)),2)+M112","v":8355},{"$f":"S112+T112","v":9274.0499999999993},null,null,0,{"$f":"IF(N112>0.01,(T112-VLOOKUP(T112,quincenal,1))*VLOOKUP(T112,quincenal,3)+VLOOKUP(T112,quincenal,2)-VLOOKUP(T112,subquincenal,2),0)","v":1237.4388240000001},{"$f":"TRUNC(IF(Y112>0.01,Y112,0),2)","v":1237.43},{"$f":"TRUNC(IF(Y112<0.01,-Y112,0),2)","v":0},{"$f":"U112-W112-X112-Z112+AA112","v":8036.619999999999},{"$f":"#REF!","v":{"$error":"#REF!"}},null,63]
[null,null,null,"PEREZ JAIME ARTURO","PEJA600718","PEXJ600718HJCRXM09","2009-01-05","AUXILIAR CONTABLE",15,"TARJETA",null,0,0,{"$f":"5198/15","v":346.53333333333336},{"$f":"TRUNC(N113*I113,2)","v":5198},{"$f":"TRUNC(N113*I113*0.04,2)","v":207.92},{"$f":"TRUNC(N113*0.07*I113,2)","v":363.86},{"$f":"L113","v":0},{"$f":"TRUNC(Q113+P113+(IF(R113>519,519,R113))+IF(K113=0,0,K113*N113),2)","v":571.78},{"$f":"TRUNC((IF(K113=0,I113*N113,(I113-K113)*N113))+(IF(R113<519,0,R113-519)),2)+M113","v":5198},{"$f":"S113+T113","v":5769.78},null,null,0,{"$f":"IF(N113>0.01,(T113-VLOOKUP(T113,quincenal,1))*VLOOKUP(T113,quincenal,3)+VLOOKUP(T113,quincenal,2)-VLOOKUP(T113,subquincenal,2),0)","v":563.10362400000008},{"$f":"TRUNC(IF(Y113>0.01,Y113,0),2)","v":563.1},{"$f":"TRUNC(IF(Y113<0.01,-Y113,0),2)","v":0},{"$f":"U113-W113-X113-Z113+AA113","v":5206.6799999999994},null,null,64]
[null,null,null,"VALENZUELA PARRA PERLA PATRICIA",null,null,null,"SECRETARIA",15,"TARJETA",null,0,0,147.369,{"$f":"TRUNC(N114*I114,2)","v":2210.5300000000002},{"$f":"TRUNC(N114*I114*0.04,2)","v":88.42},{"$f":"TRUNC(N114*0.07*I114,2)","v":154.72999999999999},{"$f":"L114","v":0},{"$f":"TRUNC(Q114+P114+(IF(R114>519,519,R114))+IF(K114=0,0,K114*N114),2)","v":243.15},{"$f":"TRUNC((IF(K114=0,I114*N114,(I114-K114)*N114))+(IF(R114<519,0,R114-519)),2)+M114","v":2210.5300000000002},{"$f":"S114+T114","v":2453.6800000000003},null,null,0,{"$f":"IF(N114>0.01,(T114-VLOOKUP(T114,quincenal,1))*VLOOKUP(T114,quincenal,3)+VLOOKUP(T114,quincenal,2)-VLOOKUP(T114,subquincenal,2),0)","v":-38.327424000000008},{"$f":"TRUNC(IF(Y114>0.01,Y114,0),2)","v":0},{"$f":"TRUNC(IF(Y114<0.01,-Y114,0),2)","v":38.32},{"$f":"U114-W114-X114-Z114+AA114","v":2492.0000000000005}]
[null,null,null,"ARQUIETA GONZALEZ IRENE MAGALI",null,null,null,"ENCARGADO DEL DEPTO DE ADQUISICIONES",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N115*I115,2)","v":3266.9},{"$f":"TRUNC(N115*I115*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N115*0.07*I115,2)","v":228.68},{"$f":"L115","v":0},{"$f":"TRUNC(Q115+P115+(IF(R115>519,519,R115))+IF(K115=0,0,K115*N115),2)","v":359.35},{"$f":"TRUNC((IF(K115=0,I115*N115,(I115-K115)*N115))+(IF(R115<519,0,R115-519)),2)+M115","v":3266.9},{"$f":"S115+T115","v":3626.25},null,null,0,{"$f":"IF(N115>0.01,(T115-VLOOKUP(T115,quincenal,1))*VLOOKUP(T115,quincenal,3)+VLOOKUP(T115,quincenal,2)-VLOOKUP(T115,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y115>0.01,Y115,0),2)","v":126.25},{"$f":"TRUNC(IF(Y115<0.01,-Y115,0),2)","v":0},{"$f":"U115-W115-X115-Z115+AA115","v":3500},{"$f":"#REF!","v":{"$error":"#REF!"}},null,65]
[null,null,null,"GOMEZ ESQUIVEL JULIO ISRAEL",null,null,null,"CAPTURISTA EN TESORERIA",15,"TARJETA",null,0,0,147.9014,{"$f":"TRUNC(N116*I116,2)","v":2218.52},{"$f":"TRUNC(N116*I116*0.04,2)","v":88.74},{"$f":"TRUNC(N116*0.07*I116,2)","v":155.29},{"$f":"L116","v":0},{"$f":"TRUNC(Q116+P116+(IF(R116>519,519,R116))+IF(K116=0,0,K116*N116),2)","v":244.03},{"$f":"TRUNC((IF(K116=0,I116*N116,(I116-K116)*N116))+(IF(R116<519,0,R116-519)),2)+M116","v":2218.52},{"$f":"S116+T116","v":2462.5500000000002},null,null,0,{"$f":"IF(N116>0.01,(T116-VLOOKUP(T116,quincenal,1))*VLOOKUP(T116,quincenal,3)+VLOOKUP(T116,quincenal,2)-VLOOKUP(T116,subquincenal,2),0)","v":-37.458112000000028},{"$f":"TRUNC(IF(Y116>0.01,Y116,0),2)","v":0},{"$f":"TRUNC(IF(Y116<0.01,-Y116,0),2)","v":37.450000000000003},{"$f":"U116-W116-X116-Z116+AA116","v":2500},null,null,66]
[null,null,null,"MARTINEZ PAREDES ANNA VERONICA","MAPA820618","MAPA820618MJCRRN00","2007-01-31","AUXILIAR CONTABLE",15,"TARJETA",null,0,0,{"$f":"4693/15","v":312.86666666666667},{"$f":"TRUNC(N117*I117,2)","v":4693},{"$f":"TRUNC(N117*I117*0.04,2)","v":187.72},{"$f":"TRUNC(N117*0.07*I117,2)","v":328.51},{"$f":"L117","v":0},{"$f":"TRUNC(Q117+P117+(IF(R117>519,519,R117))+IF(K117=0,0,K117*N117),2)","v":516.23},{"$f":"TRUNC((IF(K117=0,I117*N117,(I117-K117)*N117))+(IF(R117<519,0,R117-519)),2)+M117","v":4693},{"$f":"S117+T117","v":5209.2299999999996},null,null,0,{"$f":"IF(N117>0.01,(T117-VLOOKUP(T117,quincenal,1))*VLOOKUP(T117,quincenal,3)+VLOOKUP(T117,quincenal,2)-VLOOKUP(T117,subquincenal,2),0)","v":468.4910880000001},{"$f":"TRUNC(IF(Y117>0.01,Y117,0),2)","v":468.49},{"$f":"TRUNC(IF(Y117<0.01,-Y117,0),2)","v":0},{"$f":"U117-W117-X117-Z117+AA117","v":4740.74},{"$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,{"$f":"SUM(O112:O117)","v":25941.95},{"$f":"SUM(P112:P117)","v":1037.6699999999998},1815.92,0,2853.59,25941.95,28795.539999999997,0,0,0,2319.5036319999999,2395.2700000000004,75.77000000000001,26476.04]
[]
[null,null,null,"DEPARTAMENTO DE INGRESOS"]
[61,"11","17","ARIAS RAMOS MARIA DEL SOCORRO","AIRS650514","AIRS650514MJCRMC06",null,"CAJERA",15,"TARJETA",null,0,0,{"$f":"3228/15","v":215.2},{"$f":"TRUNC(N121*I121,2)","v":3228},{"$f":"TRUNC(N121*I121*0.04,2)","v":129.12},{"$f":"TRUNC(N121*0.07*I121,2)","v":225.96},{"$f":"L121","v":0},{"$f":"TRUNC(Q121+P121+(IF(R121>519,519,R121))+IF(K121=0,0,K121*N121),2)","v":355.08},{"$f":"TRUNC((IF(K121=0,I121*N121,(I121-K121)*N121))+(IF(R121<519,0,R121-519)),2)+M121","v":3228},{"$f":"S121+T121","v":3583.08},null,null,0,{"$f":"IF(N121>0.01,(T121-VLOOKUP(T121,quincenal,1))*VLOOKUP(T121,quincenal,3)+VLOOKUP(T121,quincenal,2)-VLOOKUP(T121,subquincenal,2),0)","v":122.02331199999998},{"$f":"TRUNC(IF(Y121>0.01,Y121,0),2)","v":122.02},{"$f":"TRUNC(IF(Y121<0.01,-Y121,0),2)","v":0},{"$f":"U121-W121-X121-Z121+AA121","v":3461.06},{"$f":"[2]PORTADA!$D$10","v":1},null,68]
[null,null,null,"CABRALES GONZALEZ JOSE MANUEL","CAGM680912","CAGM680912HJCBNN06","2007-01-01","RECAUDADOR DE PISO",15,"TARJETA",null,0,0,{"$f":"3016/15","v":201.06666666666666},{"$f":"TRUNC(N122*I122,2)","v":3016},{"$f":"TRUNC(N122*I122*0.04,2)","v":120.64},{"$f":"TRUNC(N122*0.07*I122,2)","v":211.12},{"$f":"L122","v":0},{"$f":"TRUNC(Q122+P122+(IF(R122>519,519,R122))+IF(K122=0,0,K122*N122),2)","v":331.76},{"$f":"TRUNC((IF(K122=0,I122*N122,(I122-K122)*N122))+(IF(R122<519,0,R122-519)),2)+M122","v":3016},{"$f":"S122+T122","v":3347.76},null,null,0,{"$f":"IF(N122>0.01,(T122-VLOOKUP(T122,quincenal,1))*VLOOKUP(T122,quincenal,3)+VLOOKUP(T122,quincenal,2)-VLOOKUP(T122,subquincenal,2),0)","v":78.707711999999987},{"$f":"TRUNC(IF(Y122>0.01,Y122,0),2)","v":78.7},{"$f":"TRUNC(IF(Y122<0.01,-Y122,0),2)","v":0},{"$f":"U122-W122-X122-Z122+AA122","v":3269.0600000000004},{"$f":"[2]PORTADA!$D$10","v":1},null,69]
["LAURO",null,null,"BERNAL RUIZ LAURO",null,null,null,"NOTIFICADOR",15,null,null,null,null,203.12799999999999,{"$f":"TRUNC(N123*I123,2)","v":3046.92},{"$f":"TRUNC(N123*I123*0.04,2)","v":121.87},{"$f":"TRUNC(N123*0.07*I123,2)","v":213.28},{"$f":"L123","v":0},{"$f":"TRUNC(Q123+P123+(IF(R123>519,519,R123))+IF(K123=0,0,K123*N123),2)","v":335.15},{"$f":"TRUNC((IF(K123=0,I123*N123,(I123-K123)*N123))+(IF(R123<519,0,R123-519)),2)+M123","v":3046.92},{"$f":"S123+T123","v":3382.07},null,null,0,{"$f":"IF(N123>0.01,(T123-VLOOKUP(T123,quincenal,1))*VLOOKUP(T123,quincenal,3)+VLOOKUP(T123,quincenal,2)-VLOOKUP(T123,subquincenal,2),0)","v":82.071808000000004},{"$f":"TRUNC(IF(Y123>0.01,Y123,0),2)","v":82.07},{"$f":"TRUNC(IF(Y123<0.01,-Y123,0),2)","v":0},{"$f":"U123-W123-X123-Z123+AA123","v":3300},null,null,70]
[null,null,null,"GODOY TAMAYO JULIAN",null,null,null,"NOTIFICADOR",15,"TARJETA",null,0,0,133.09739999999999,{"$f":"TRUNC(N124*I124,2)","v":1996.46},{"$f":"TRUNC(N124*I124*0.04,2)","v":79.849999999999994},{"$f":"TRUNC(N124*0.07*I124,2)","v":139.75},{"$f":"L124","v":0},{"$f":"TRUNC(Q124+P124+(IF(R124>519,519,R124))+IF(K124=0,0,K124*N124),2)","v":219.6},{"$f":"TRUNC((IF(K124=0,I124*N124,(I124-K124)*N124))+(IF(R124<519,0,R124-519)),2)+M124","v":1996.46},{"$f":"S124+T124","v":2216.06},null,null,0,{"$f":"IF(N124>0.01,(T124-VLOOKUP(T124,quincenal,1))*VLOOKUP(T124,quincenal,3)+VLOOKUP(T124,quincenal,2)-VLOOKUP(T124,subquincenal,2),0)","v":-71.944399999999973},{"$f":"TRUNC(IF(Y124>0.01,Y124,0),2)","v":0},{"$f":"TRUNC(IF(Y124<0.01,-Y124,0),2)","v":71.94},{"$f":"U124-W124-X124-Z124+AA124","v":2288}]
[null,null,null,"GONZALEZ ARQUIETA CESAR ARMANDO","MAGG",null,null,"INSPECTOR TESORERIA",15,"TARJETA",null,0,0,147.9014,{"$f":"TRUNC(N125*I125,2)","v":2218.52},{"$f":"TRUNC(N125*I125*0.04,2)","v":88.74},{"$f":"TRUNC(N125*0.07*I125,2)","v":155.29},{"$f":"L125","v":0},{"$f":"TRUNC(Q125+P125+(IF(R125>519,519,R125))+IF(K125=0,0,K125*N125),2)","v":244.03},{"$f":"TRUNC((IF(K125=0,I125*N125,(I125-K125)*N125))+(IF(R125<519,0,R125-519)),2)+M125","v":2218.52},{"$f":"S125+T125","v":2462.5500000000002},null,null,0,{"$f":"IF(N125>0.01,(T125-VLOOKUP(T125,quincenal,1))*VLOOKUP(T125,quincenal,3)+VLOOKUP(T125,quincenal,2)-VLOOKUP(T125,subquincenal,2),0)","v":-37.458112000000028},{"$f":"TRUNC(IF(Y125>0.01,Y125,0),2)","v":0},{"$f":"TRUNC(IF(Y125<0.01,-Y125,0),2)","v":37.450000000000003},{"$f":"U125-W125-X125-Z125+AA125","v":2500},null,null,71]
[null,null,null,"DEPARTAMENTO DE INGRESOS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O121:O125)","v":13505.900000000001},{"$f":"SUM(P121:P125)","v":540.22},945.4,0,1485.62,13505.900000000001,14991.52,0,0,0,173.40031999999997,282.78999999999996,109.39,14818.12]
[]
[null,null,null,"DEPARTAMENTO DE EGRESOS"]
[63,"3","7",null,"LEGJ",null,null,"COORDINADOR DE EGRESOS",0,"TARJETA",null,0,0,{"$f":"5198/15","v":346.53333333333336},{"$f":"TRUNC(N129*I129,2)","v":0},{"$f":"TRUNC(N129*I129*0.04,2)","v":0},{"$f":"TRUNC(N129*0.07*I129,2)","v":0},{"$f":"L129","v":0},{"$f":"TRUNC(Q129+P129+(IF(R129>519,519,R129))+IF(K129=0,0,K129*N129),2)","v":0},{"$f":"TRUNC((IF(K129=0,I129*N129,(I129-K129)*N129))+(IF(R129<519,0,R129-519)),2)+M129","v":0},{"$f":"S129+T129","v":0},null,null,0,{"$f":"IF(N129>0.01,(T129-VLOOKUP(T129,quincenal,1))*VLOOKUP(T129,quincenal,3)+VLOOKUP(T129,quincenal,2)-VLOOKUP(T129,subquincenal,2),0)","v":{"$error":"#N/A"}},null,null,{"$f":"U129-W129-X129-Z129+AA129","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},null,72]
[null,null,null,"DEPARTAMENTO DE EGRESOS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O129)","v":0},0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,0,0]
[]
[null,null,null,"DEPARTAMENTO DE  INFORMATICA"]
[64,"3","12","ILLAN ARIAS CESAR","DIME",null,null,"DIRECTOR DE IDE NFORMATICA Y SISTEMAS",15,"TARJETA",null,0,0,260.28699999999998,{"$f":"TRUNC(N133*I133,2)","v":3904.3},{"$f":"TRUNC(N133*I133*0.04,2)","v":156.16999999999999},{"$f":"TRUNC(N133*0.07*I133,2)","v":273.3},{"$f":"L133","v":0},{"$f":"TRUNC(Q133+P133+(IF(R133>519,519,R133))+IF(K133=0,0,K133*N133),2)","v":429.47},{"$f":"TRUNC((IF(K133=0,I133*N133,(I133-K133)*N133))+(IF(R133<519,0,R133-519)),2)+M133","v":3904.3},{"$f":"S133+T133","v":4333.7700000000004},null,null,0,{"$f":"IF(N133>0.01,(T133-VLOOKUP(T133,quincenal,1))*VLOOKUP(T133,quincenal,3)+VLOOKUP(T133,quincenal,2)-VLOOKUP(T133,subquincenal,2),0)","v":333.77639999999997},{"$f":"TRUNC(IF(Y133>0.01,Y133,0),2)","v":333.77},{"$f":"TRUNC(IF(Y133<0.01,-Y133,0),2)","v":0},{"$f":"U133-W133-X133-Z133+AA133","v":4000.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},null,73]
[null,null,null,"BERNAL ESTRADA EDGAR FERNANDO",null,null,null,"AUXILIAR DEL DEPARTAMENTO DE NFORMATICA",15,"TARJETA",null,0,0,147.9015,{"$f":"TRUNC(N134*I134,2)","v":2218.52},{"$f":"TRUNC(N134*I134*0.04,2)","v":88.74},{"$f":"TRUNC(N134*0.07*I134,2)","v":155.29},{"$f":"L134","v":0},{"$f":"TRUNC(Q134+P134+(IF(R134>519,519,R134))+IF(K134=0,0,K134*N134),2)","v":244.03},{"$f":"TRUNC((IF(K134=0,I134*N134,(I134-K134)*N134))+(IF(R134<519,0,R134-519)),2)+M134","v":2218.52},{"$f":"S134+T134","v":2462.5500000000002},null,null,null,{"$f":"IF(N134>0.01,(T134-VLOOKUP(T134,quincenal,1))*VLOOKUP(T134,quincenal,3)+VLOOKUP(T134,quincenal,2)-VLOOKUP(T134,subquincenal,2),0)","v":-37.458112000000028},{"$f":"TRUNC(IF(Y134>0.01,Y134,0),2)","v":0},{"$f":"TRUNC(IF(Y134<0.01,-Y134,0),2)","v":37.450000000000003},{"$f":"U134-W134-X134-Z134+AA134","v":2500},{"$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,{"$f":"SUM(O133:O134)","v":6122.82},{"$f":"SUM(P133:P134)","v":244.90999999999997},428.59000000000003,0,673.5,6122.82,6796.3200000000006,0,0,0,296.31828799999994,333.77,37.450000000000003,6500]
[]
[null,null,null,"DEPARTAMENTO DE IMPUESTO PREDIAL Y CATASTRO"]
[null,null,null,"ROBLES VENEGAS OSCAR HUMBERTO",null,null,null,"DIRECTOR",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N138*I138,2)","v":6083.01},{"$f":"TRUNC(N138*I138*0.04,2)","v":243.32},{"$f":"TRUNC(N138*0.07*I138,2)","v":425.81},{"$f":"L138","v":0},{"$f":"TRUNC(Q138+P138+(IF(R138>519,519,R138))+IF(K138=0,0,K138*N138),2)","v":669.13},{"$f":"TRUNC((IF(K138=0,I138*N138,(I138-K138)*N138))+(IF(R138<519,0,R138-519)),2)+M138","v":6083.01},{"$f":"S138+T138","v":6752.14},null,null,0,{"$f":"IF(N138>0.01,(T138-VLOOKUP(T138,quincenal,1))*VLOOKUP(T138,quincenal,3)+VLOOKUP(T138,quincenal,2)-VLOOKUP(T138,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y138>0.01,Y138,0),2)","v":752.14},{"$f":"TRUNC(IF(Y138<0.01,-Y138,0),2)","v":0},{"$f":"U138-W138-X138-Z138+AA138","v":6000},null,null,75]
[66,"3","13","CASTELLANOS LOPEZ FRANCISCO JAVIER","CAPB801105","CAPB801105MJCMRR06","2007-01-01","SUB-DIRECTOR DE CATASTRO",15,"TARJETA",null,0,0,274.0419,{"$f":"TRUNC(N139*I139,2)","v":4110.62},{"$f":"TRUNC(N139*I139*0.04,2)","v":164.42},{"$f":"TRUNC(N139*0.07*I139,2)","v":287.74},{"$f":"L139","v":0},{"$f":"TRUNC(Q139+P139+(IF(R139>519,519,R139))+IF(K139=0,0,K139*N139),2)","v":452.16},{"$f":"TRUNC((IF(K139=0,I139*N139,(I139-K139)*N139))+(IF(R139<519,0,R139-519)),2)+M139","v":4110.62},{"$f":"S139+T139","v":4562.78},null,null,0,{"$f":"IF(N139>0.01,(T139-VLOOKUP(T139,quincenal,1))*VLOOKUP(T139,quincenal,3)+VLOOKUP(T139,quincenal,2)-VLOOKUP(T139,subquincenal,2),0)","v":366.78759999999994},{"$f":"TRUNC(IF(Y139>0.01,Y139,0),2)","v":366.78},{"$f":"TRUNC(IF(Y139<0.01,-Y139,0),2)","v":0},{"$f":"U139-W139-X139-Z139+AA139","v":4196},{"$f":"#REF!","v":{"$error":"#REF!"}},null,76]
[63,3,13,null,"GOME840310","GOME840310MJCNRR06","2009-01-01","SECRETARIA",0,"TARJETA",null,0,0,170.38,0,0,0,0,0,0,0,null,0,0,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[67,null,null,"GARCIA LOPEZ MARIA ESMERALDA","HEBC",null,null,"SECRETARIA EN CATASTRO",15,"TARJETA",null,0,0,147.369,2210.5300000000002,88.42,154.72999999999999,0,243.15,2210.5300000000002,2453.6800000000003,null,null,null,{"$f":"IF(N141>0.01,(T141-VLOOKUP(T141,quincenal,1))*VLOOKUP(T141,quincenal,3)+VLOOKUP(T141,quincenal,2)-VLOOKUP(T141,subquincenal,2),0)","v":-38.327424000000008},{"$f":"TRUNC(IF(Y141>0.01,Y141,0),2)","v":0},{"$f":"TRUNC(IF(Y141<0.01,-Y141,0),2)","v":38.32},2492.0000000000005,null,null,77]
[null,null,null,"ORTEGA CRUZ ERIKA NARSEDALIA",null,null,null,"SECRETARIA EN CATASTRO",15,"TARJETA",null,0,0,147.369,{"$f":"TRUNC(N142*I142,2)","v":2210.5300000000002},{"$f":"TRUNC(N142*I142*0.04,2)","v":88.42},{"$f":"TRUNC(N142*0.07*I142,2)","v":154.72999999999999},{"$f":"L142","v":0},{"$f":"TRUNC(Q142+P142+(IF(R142>519,519,R142))+IF(K142=0,0,K142*N142),2)","v":243.15},{"$f":"TRUNC((IF(K142=0,I142*N142,(I142-K142)*N142))+(IF(R142<519,0,R142-519)),2)+M142","v":2210.5300000000002},{"$f":"S142+T142","v":2453.6800000000003},null,null,0,{"$f":"IF(N142>0.01,(T142-VLOOKUP(T142,quincenal,1))*VLOOKUP(T142,quincenal,3)+VLOOKUP(T142,quincenal,2)-VLOOKUP(T142,subquincenal,2),0)","v":-38.327424000000008},{"$f":"TRUNC(IF(Y142>0.01,Y142,0),2)","v":0},{"$f":"TRUNC(IF(Y142<0.01,-Y142,0),2)","v":38.32},{"$f":"U142-W142-X142-Z142+AA142","v":2492.0000000000005},null,null,78]
[null,null,null,"DEPARTAMENTO DE IMPUESTO PREDIAL Y CATASTRO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O138:O142)","v":14614.690000000002},584.58000000000004,1023.01,0,1607.5900000000001,14614.690000000002,16222.28,0,0,0,1042.274512,1118.92,76.64,15180]
[]
[null,null,null,"ADMINISTRACION DE LOS SERVICIOS PUBLICOS MUNICIPALES"]
[69,null,null,"MARISCAL MORALES JESUS RICARDO","HEAM740507","HEAM740507HJCRGN04","2008-05-01","DIRECTOR DE SERVICIOS ´PÚBLICOS  MUNICIPALES",15,"TARJETA",null,0,0,491.06200000000001,{"$f":"TRUNC(N146*I146,2)","v":7365.93},{"$f":"TRUNC(N146*I146*0.04,2)","v":294.63},{"$f":"TRUNC(N146*0.07*I146,2)","v":515.61},{"$f":"L146","v":0},{"$f":"TRUNC(Q146+P146+(IF(R146>519,519,R146))+IF(K146=0,0,K146*N146),2)","v":810.24},{"$f":"TRUNC((IF(K146=0,I146*N146,(I146-K146)*N146))+(IF(R146<519,0,R146-519)),2)+M146","v":7365.93},{"$f":"S146+T146","v":8176.17},null,null,0,{"$f":"IF(N146>0.01,(T146-VLOOKUP(T146,quincenal,1))*VLOOKUP(T146,quincenal,3)+VLOOKUP(T146,quincenal,2)-VLOOKUP(T146,subquincenal,2),0)","v":1026.1734720000002},{"$f":"TRUNC(IF(Y146>0.01,Y146,0),2)","v":1026.17},{"$f":"TRUNC(IF(Y146<0.01,-Y146,0),2)","v":0},{"$f":"U146-W146-X146-Z146+AA146","v":7150},{"$f":"#REF!","v":{"$error":"#REF!"}},null,79]
[70,null,null,"CERVANTES VELAZCO ISAIAS","IAOR",null,null,"ENCARGADO DE MANTENIMIENTO A VEHICULOS",15,"TARJETA",null,0,0,295.625,{"$f":"TRUNC(N147*I147,2)","v":4434.37},{"$f":"TRUNC(N147*I147*0.04,2)","v":177.37},{"$f":"TRUNC(N147*0.07*I147,2)","v":310.39999999999998},{"$f":"L147","v":0},{"$f":"TRUNC(Q147+P147+(IF(R147>519,519,R147))+IF(K147=0,0,K147*N147),2)","v":487.77},{"$f":"TRUNC((IF(K147=0,I147*N147,(I147-K147)*N147))+(IF(R147<519,0,R147-519)),2)+M147","v":4434.37},{"$f":"S147+T147","v":4922.1399999999994},null,null,0,{"$f":"IF(N147>0.01,(T147-VLOOKUP(T147,quincenal,1))*VLOOKUP(T147,quincenal,3)+VLOOKUP(T147,quincenal,2)-VLOOKUP(T147,subquincenal,2),0)","v":422.14459200000005},{"$f":"TRUNC(IF(Y147>0.01,Y147,0),2)","v":422.14},{"$f":"TRUNC(IF(Y147<0.01,-Y147,0),2)","v":0},{"$f":"U147-W147-X147-Z147+AA147","v":4499.9999999999991},null,null,80]
[null,null,null,"HERNANDEZ AGUIRRE JOSE MANUEL",null,null,null,"OPERADOR DE MAQUINARIA",15,null,null,null,null,228.53,{"$f":"TRUNC(N148*I148,2)","v":3427.95},{"$f":"TRUNC(N148*I148*0.04,2)","v":137.11000000000001},{"$f":"TRUNC(N148*0.07*I148,2)","v":239.95},{"$f":"L148","v":0},{"$f":"TRUNC(Q148+P148+(IF(R148>519,519,R148))+IF(K148=0,0,K148*N148),2)","v":377.06},{"$f":"TRUNC((IF(K148=0,I148*N148,(I148-K148)*N148))+(IF(R148<519,0,R148-519)),2)+M148","v":3427.95},{"$f":"S148+T148","v":3805.0099999999998},null,null,0,{"$f":"IF(N148>0.01,(T148-VLOOKUP(T148,quincenal,1))*VLOOKUP(T148,quincenal,3)+VLOOKUP(T148,quincenal,2)-VLOOKUP(T148,subquincenal,2),0)","v":143.77787199999997},{"$f":"TRUNC(IF(Y148>0.01,Y148,0),2)","v":143.77000000000001},{"$f":"TRUNC(IF(Y148<0.01,-Y148,0),2)","v":0},{"$f":"U148-W148-X148-Z148+AA148","v":3661.24},null,null,81]
[80,null,null,"JUAREZ FLORES HUGO",null,null,null,"CHOFER   ",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N149*I149,2)","v":2747.28},{"$f":"TRUNC(N149*I149*0.04,2)","v":109.89},{"$f":"TRUNC(N149*0.07*I149,2)","v":192.3},{"$f":"L149","v":0},{"$f":"TRUNC(Q149+P149+(IF(R149>519,519,R149))+IF(K149=0,0,K149*N149),2)","v":302.19},{"$f":"TRUNC((IF(K149=0,I149*N149,(I149-K149)*N149))+(IF(R149<519,0,R149-519)),2)+M149","v":2747.28},{"$f":"S149+T149","v":3049.4700000000003},null,null,0,{"$f":"IF(N149>0.01,(T149-VLOOKUP(T149,quincenal,1))*VLOOKUP(T149,quincenal,3)+VLOOKUP(T149,quincenal,2)-VLOOKUP(T149,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y149>0.01,Y149,0),2)","v":49.47},{"$f":"TRUNC(IF(Y149<0.01,-Y149,0),2)","v":0},{"$f":"U149-W149-X149-Z149+AA149","v":3000.0000000000005},null,null,82]
[null,null,null,"GARCIA MARTINEZ FRANCISCO RIGOBERTO",null,null,null,"AUX ILIAR DE LIMPIEZA PLAZA DE TOROS",15,"TARJETA",null,null,null,147.9015,2218.52,88.74,155.29,0,244.03,2218.52,2462.5500000000002,null,null,0,-37.458112000000028,{"$f":"TRUNC(IF(Y150>0.01,Y150,0),2)","v":0},{"$f":"TRUNC(IF(Y150<0.01,-Y150,0),2)","v":37.450000000000003},2500,null,null,84]
[null,null,null,"DOMINGUEZ HECTOR FREDDI","BECR460228","BECR460207HJCRHS07","2004-01-01","CHOFER ",15,"TARJETA",null,0,0,217.7938,3266.9,130.66999999999999,228.68,0,359.35,3266.9,3626.25,null,null,0,126.25563199999996,{"$f":"TRUNC(IF(Y151>0.01,Y151,0),2)","v":126.25},{"$f":"TRUNC(IF(Y151<0.01,-Y151,0),2)","v":0},3500,null,null,85]
[null,null,null,"DELGADO PACHECO RICARDO",null,null,null,"AYUDANTE",15,"TARJETA",null,0,0,183.15199999999999,2747.28,109.89,192.3,0,302.19,2747.28,3049.4700000000003,null,null,0,49.470976000000007,{"$f":"TRUNC(IF(Y152>0.01,Y152,0),2)","v":49.47},{"$f":"TRUNC(IF(Y152<0.01,-Y152,0),2)","v":0},3000.0000000000005,null,null,86]
[null,null,null,"JUAREZ JIMENEZ ALFREDO","BECR460228","BECR460207HJCRHS07","2004-01-01","CHOFER ",15,"TARJETA",null,0,0,147.9015,2218.52,88.74,155.29,0,244.03,2218.52,2462.5500000000002,null,null,null,-37.458112000000028,{"$f":"TRUNC(IF(Y153>0.01,Y153,0),2)","v":0},{"$f":"TRUNC(IF(Y153<0.01,-Y153,0),2)","v":37.450000000000003},2500,null,null,87]
[null,null,null,"MOJARRO BERUMEN ENRIQUE",null,null,null,"EMPEDRADOR",15,"TARJETA",null,0,0,{"$f":"2866/15","v":191.06666666666666},{"$f":"TRUNC(N154*I154,2)","v":2866},{"$f":"TRUNC(N154*I154*0.04,2)","v":114.64},{"$f":"TRUNC(N154*0.07*I154,2)","v":200.62},{"$f":"L154","v":0},{"$f":"TRUNC(Q154+P154+(IF(R154>519,519,R154))+IF(K154=0,0,K154*N154),2)","v":315.26},{"$f":"TRUNC((IF(K154=0,I154*N154,(I154-K154)*N154))+(IF(R154<519,0,R154-519)),2)+M154","v":2866},{"$f":"S154+T154","v":3181.26},null,null,null,{"$f":"IF(N154>0.01,(T154-VLOOKUP(T154,quincenal,1))*VLOOKUP(T154,quincenal,3)+VLOOKUP(T154,quincenal,2)-VLOOKUP(T154,subquincenal,2),0)","v":62.387711999999993},{"$f":"TRUNC(IF(Y154>0.01,Y154,0),2)","v":62.38},{"$f":"TRUNC(IF(Y154<0.01,-Y154,0),2)","v":0},{"$f":"U154-W154-X154-Z154+AA154","v":3118.88},null,null,88]
[null,null,null,"FERREL ALCANTAR EDMUNDO",null,null,null,"EMPEDRADOR",15,"TARJETA",null,0,0,{"$f":"2866/15","v":191.06666666666666},2866,114.64,200.62,0,315.26,2866,3181.26,null,null,null,62.387711999999993,62.38,0,3118.88,null,null,89]
[null,null,null,"NAVARRO GUTIERREZ MOISES EDMUNDO",null,null,null,"AYUDANTE",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,null,{"$f":"IF(N156>0.01,(T156-VLOOKUP(T156,quincenal,1))*VLOOKUP(T156,quincenal,3)+VLOOKUP(T156,quincenal,2)-VLOOKUP(T156,subquincenal,2),0)","v":-37.079488000000026},0,37.07,2503.4900000000002,null,null,90]
[null,null,null,"GALLEGOS RIVAS ADRIAN",null,null,null,"AYUDANTE",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,null,-37.079488000000026,0,37.07,2503.4900000000002,null,null,91]
[null,null,null,"RAMIREZ GARCIA J. JESUS",null,null,null,"AYUDANTE",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,null,-37.079488000000026,0,37.07,2503.4900000000002,null,null,92]
[null,null,null,"ORENDAIN BERNAL ROBERTO",null,null,null,"AYUDANTE",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,null,-37.079488000000026,0,37.07,2503.4900000000002,null,null,93]
[null,null,null,"ACEVEDO OCHOA J. GUADALUPE",null,null,null,"ALMACENISTA",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N160*I160,2)","v":2747.28},{"$f":"TRUNC(N160*I160*0.04,2)","v":109.89},{"$f":"TRUNC(N160*0.07*I160,2)","v":192.3},{"$f":"L160","v":0},{"$f":"TRUNC(Q160+P160+(IF(R160>519,519,R160))+IF(K160=0,0,K160*N160),2)","v":302.19},{"$f":"TRUNC((IF(K160=0,I160*N160,(I160-K160)*N160))+(IF(R160<519,0,R160-519)),2)+M160","v":2747.28},{"$f":"S160+T160","v":3049.4700000000003},null,null,0,{"$f":"IF(N160>0.01,(T160-VLOOKUP(T160,quincenal,1))*VLOOKUP(T160,quincenal,3)+VLOOKUP(T160,quincenal,2)-VLOOKUP(T160,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y160>0.01,Y160,0),2)","v":49.47},{"$f":"TRUNC(IF(Y160<0.01,-Y160,0),2)","v":0},{"$f":"U160-W160-X160-Z160+AA160","v":3000.0000000000005},null,null,94]
[null,null,null,"GONZALEZ AZPEITIA ALVARO",null,null,null,"AYUDANTE",15,"TARJETA",null,0,0,{"$f":"1989/15","v":132.6},{"$f":"TRUNC(N161*I161,2)","v":1989},{"$f":"TRUNC(N161*I161*0.04,2)","v":79.56},{"$f":"TRUNC(N161*0.07*I161,2)","v":139.22999999999999},{"$f":"L161","v":0},{"$f":"TRUNC(Q161+P161+(IF(R161>519,519,R161))+IF(K161=0,0,K161*N161),2)","v":218.79},{"$f":"TRUNC((IF(K161=0,I161*N161,(I161-K161)*N161))+(IF(R161<519,0,R161-519)),2)+M161","v":1989},{"$f":"S161+T161","v":2207.79},null,null,null,{"$f":"IF(N161>0.01,(T161-VLOOKUP(T161,quincenal,1))*VLOOKUP(T161,quincenal,3)+VLOOKUP(T161,quincenal,2)-VLOOKUP(T161,subquincenal,2),0)","v":-72.421839999999975},{"$f":"TRUNC(IF(Y161>0.01,Y161,0),2)","v":0},{"$f":"TRUNC(IF(Y161<0.01,-Y161,0),2)","v":72.42},{"$f":"U161-W161-X161-Z161+AA161","v":2280.21},null,null,95]
[null,null,null,"ARQUIETA VADILLO ARTURO","AUVA551030FJ0","AUVA551030HJCRDR15",null,"PINTOR GENERAL",15,"SOBRE",null,0,0,{"$f":"4527/15","v":301.8},4527,181.08,316.89,{"$f":"L162","v":0},497.97,4527,{"$f":"S162+T162","v":5024.97},null,null,null,{"$f":"IF(N162>0.01,(T162-VLOOKUP(T162,quincenal,1))*VLOOKUP(T162,quincenal,3)+VLOOKUP(T162,quincenal,2)-VLOOKUP(T162,subquincenal,2),0)","v":438.74388800000008},{"$f":"TRUNC(IF(Y162>0.01,Y162,0),2)","v":438.74},{"$f":"TRUNC(IF(Y162<0.01,-Y162,0),2)","v":0},{"$f":"U162-W162-X162-Z162+AA162","v":4586.2300000000005},null,null,96]
[null,null,null,"ADMINISTRACION DE LOS SERVICIOS PUBLICOS MUNICIPALES",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O146:O162)","v":52310.03},{"$f":"SUM(P146:P162)","v":2092.3700000000008},3661.64,0,5754.01,52310.03,58064.04,0,0,0,2134.6277919999998,2430.2400000000002,295.59999999999997,55929.399999999994]
[null,null,null,"DIRECCION GENERAL  DE OBRAS PUBLICAS"]
[83,"4","1","DAVALOS SALCEDO MIGUEL CARLOS",null,null,null,"DIRECTOR DE OBRAS PÚBLICAS",15,"TARJETA",null,0,0,479.90589999999997,{"$f":"TRUNC(N165*I165,2)","v":7198.58},{"$f":"TRUNC(N165*I165*0.04,2)","v":287.94},{"$f":"TRUNC(N165*0.07*I165,2)","v":503.9},{"$f":"L165","v":0},{"$f":"TRUNC(Q165+P165+(IF(R165>519,519,R165))+IF(K165=0,0,K165*N165),2)","v":791.84},{"$f":"TRUNC((IF(K165=0,I165*N165,(I165-K165)*N165))+(IF(R165<519,0,R165-519)),2)+M165","v":7198.58},{"$f":"S165+T165","v":7990.42},null,null,0,{"$f":"IF(N165>0.01,(T165-VLOOKUP(T165,quincenal,1))*VLOOKUP(T165,quincenal,3)+VLOOKUP(T165,quincenal,2)-VLOOKUP(T165,subquincenal,2),0)","v":990.42751200000009},{"$f":"TRUNC(IF(Y165>0.01,Y165,0),2)","v":990.42},{"$f":"TRUNC(IF(Y165<0.01,-Y165,0),2)","v":0},{"$f":"U165-W165-X165-Z165+AA165","v":7000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,97]
[null,null,null,"GUTIERREZ MARTINEZ JORGE",null,null,null,"SUB DIRECTOR DE OBRAS PÚBLICAS",15,"TARJETA",null,0,0,331.43599999999998,{"$f":"TRUNC(N166*I166,2)","v":4971.54},{"$f":"TRUNC(N166*I166*0.04,2)","v":198.86},{"$f":"TRUNC(N166*0.07*I166,2)","v":348},{"$f":"L166","v":0},{"$f":"TRUNC(Q166+P166+(IF(R166>519,519,R166))+IF(K166=0,0,K166*N166),2)","v":546.86},{"$f":"TRUNC((IF(K166=0,I166*N166,(I166-K166)*N166))+(IF(R166<519,0,R166-519)),2)+M166","v":4971.54},{"$f":"S166+T166","v":5518.4},null,null,0,{"$f":"IF(N166>0.01,(T166-VLOOKUP(T166,quincenal,1))*VLOOKUP(T166,quincenal,3)+VLOOKUP(T166,quincenal,2)-VLOOKUP(T166,subquincenal,2),0)","v":518.40545600000007},{"$f":"TRUNC(IF(Y166>0.01,Y166,0),2)","v":518.4},{"$f":"TRUNC(IF(Y166<0.01,-Y166,0),2)","v":0},{"$f":"U166-W166-X166-Z166+AA166","v":5000},null,null,98]
[null,null,null,"FLORES IÑIGUEZ JUAN RAYMUNDO","FOIJ8508313Z1","FOIJ850831HJCLXN07","2007-01-01","SUB-DIRECTOR DESARROLLO URBANO",15,"TARJETA",null,0,0,{"$f":"3741/15","v":249.4},3741,149.63999999999999,261.87,0,411.51,3741,4152.51,null,null,0,{"$f":"IF(N167>0.01,(T167-VLOOKUP(T167,quincenal,1))*VLOOKUP(T167,quincenal,3)+VLOOKUP(T167,quincenal,2)-VLOOKUP(T167,subquincenal,2),0)","v":307.64839999999998},307.64,0,3844.8700000000003,{"$f":"[2]PORTADA!$D$10","v":1},null,99]
[null,null,null,"RENTERIA MENDEZ FRANCISCO","REMF850816I26","REMF850816HJCNNR00","2008-03-05","AUXILIAR DE DIRECCIÓN",15,"TARJETA",null,0,0,{"$f":"4385/15","v":292.33333333333331},4385,175.4,306.95,0,482.35,4385,4867.3500000000004,null,null,0,413.29748800000004,413.29,0,4454.0600000000004,{"$f":"[2]PORTADA!$D$10","v":1},null,100]
[null,null,null,"RENTERIA LOPEZ JUAN CARLOS",null,null,null,"AUXILIAR DE DESARROLLO URBANO",15,null,null,null,null,{"$f":"2411.14/15","v":160.74266666666665},{"$f":"TRUNC(N169*I169,2)","v":2411.14},{"$f":"TRUNC(N169*I169*0.04,2)","v":96.44},{"$f":"TRUNC(N169*0.07*I169,2)","v":168.77},{"$f":"L169","v":0},{"$f":"TRUNC(Q169+P169+(IF(R169>519,519,R169))+IF(K169=0,0,K169*N169),2)","v":265.20999999999998},{"$f":"TRUNC((IF(K169=0,I169*N169,(I169-K169)*N169))+(IF(R169<519,0,R169-519)),2)+M169","v":2411.14},{"$f":"S169+T169","v":2676.35},null,null,0,{"$f":"IF(N169>0.01,(T169-VLOOKUP(T169,quincenal,1))*VLOOKUP(T169,quincenal,3)+VLOOKUP(T169,quincenal,2)-VLOOKUP(T169,subquincenal,2),0)","v":-2.1010560000000282},{"$f":"TRUNC(IF(Y169>0.01,Y169,0),2)","v":0},{"$f":"TRUNC(IF(Y169<0.01,-Y169,0),2)","v":2.1},{"$f":"U169-W169-X169-Z169+AA169","v":2678.45},null,null,101]
[null,null,null,"NOLASCO VALLE ARTURO","NOVA",null,null,"CHOFER   ",15,"TARJETA",null,0,0,{"$f":"2866/15","v":191.06666666666666},2866,114.64,200.62,0,315.26,2866,3181.26,null,0,0,{"$f":"IF(N170>0.01,(T170-VLOOKUP(T170,quincenal,1))*VLOOKUP(T170,quincenal,3)+VLOOKUP(T170,quincenal,2)-VLOOKUP(T170,subquincenal,2),0)","v":62.387711999999993},62.38,0,3118.88,{"$f":"[2]PORTADA!$D$10","v":1},null,102]
[null,null,null,{"$f":"D164","v":"DIRECCION GENERAL  DE OBRAS PUBLICAS"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O165:O170)","v":25573.26},{"$f":"SUM(P165:P170)","v":1022.92},1790.1100000000001,0,2813.0299999999997,25573.26,28386.29,0,0,0,2290.0655120000006,2292.13,2.1,26096.260000000002]
[]
[null,null,null,"DEPARTAMENTO DE CEMENTERIOS"]
[null,null,null,"ILLAN RUIZ FERNANDO","RIOA520619","RIOA520619HJCVRD05",null,"ADMINISTRADOR DE CEMENTERIOS",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N174*I174,2)","v":3266.9},{"$f":"TRUNC(N174*I174*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N174*0.07*I174,2)","v":228.68},{"$f":"L174","v":0},{"$f":"TRUNC(Q174+P174+(IF(R174>519,519,R174))+IF(K174=0,0,K174*N174),2)","v":359.35},{"$f":"TRUNC((IF(K174=0,I174*N174,(I174-K174)*N174))+(IF(R174<519,0,R174-519)),2)+M174","v":3266.9},{"$f":"S174+T174","v":3626.25},null,null,0,{"$f":"IF(N174>0.01,(T174-VLOOKUP(T174,quincenal,1))*VLOOKUP(T174,quincenal,3)+VLOOKUP(T174,quincenal,2)-VLOOKUP(T174,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y174>0.01,Y174,0),2)","v":126.25},{"$f":"TRUNC(IF(Y174<0.01,-Y174,0),2)","v":0},{"$f":"U174-W174-X174-Z174+AA174","v":3500},null,null,103]
[null,null,null,"MURILLO SUAREZ HECTOR","RIOA520619","RIOA520619HJCVRD05",null,"AYUDANTE DE CEMENTERIOS",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N175*I175,2)","v":1709.65},{"$f":"TRUNC(N175*I175*0.04,2)","v":68.38},{"$f":"TRUNC(N175*0.07*I175,2)","v":119.67},{"$f":"L175","v":0},{"$f":"TRUNC(Q175+P175+(IF(R175>519,519,R175))+IF(K175=0,0,K175*N175),2)","v":188.05},{"$f":"TRUNC((IF(K175=0,I175*N175,(I175-K175)*N175))+(IF(R175<519,0,R175-519)),2)+M175","v":1709.65},{"$f":"S175+T175","v":1897.7},null,null,0,{"$f":"IF(N175>0.01,(T175-VLOOKUP(T175,quincenal,1))*VLOOKUP(T175,quincenal,3)+VLOOKUP(T175,quincenal,2)-VLOOKUP(T175,subquincenal,2),0)","v":-102.30023999999997},0,{"$f":"TRUNC(IF(Y175<0.01,-Y175,0),2)","v":102.3},{"$f":"U175-W175-X175-Z175+AA175","v":2000},null,null,104]
[null,null,null,"HERNANDEZ BAILON JUAN ALFREDO",null,null,null,null,15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N176*I176,2)","v":1709.65},{"$f":"TRUNC(N176*I176*0.04,2)","v":68.38},{"$f":"TRUNC(N176*0.07*I176,2)","v":119.67},{"$f":"L176","v":0},{"$f":"TRUNC(Q176+P176+(IF(R176>519,519,R176))+IF(K176=0,0,K176*N176),2)","v":188.05},{"$f":"TRUNC((IF(K176=0,I176*N176,(I176-K176)*N176))+(IF(R176<519,0,R176-519)),2)+M176","v":1709.65},{"$f":"S176+T176","v":1897.7},null,null,0,{"$f":"IF(N176>0.01,(T176-VLOOKUP(T176,quincenal,1))*VLOOKUP(T176,quincenal,3)+VLOOKUP(T176,quincenal,2)-VLOOKUP(T176,subquincenal,2),0)","v":-102.30023999999997},0,{"$f":"TRUNC(IF(Y176<0.01,-Y176,0),2)","v":102.3},{"$f":"U176-W176-X176-Z176+AA176","v":2000},null,null,105]
[91,"5","2","FAJARDO LOPEZ JORGE ANTONIO","RIOA520619","RIOA520619HJCVRD05",null,"ADMINISTRADOR DE CEMENTERIOS",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N177*I177,2)","v":1709.65},{"$f":"TRUNC(N177*I177*0.04,2)","v":68.38},{"$f":"TRUNC(N177*0.07*I177,2)","v":119.67},{"$f":"L177","v":0},{"$f":"TRUNC(Q177+P177+(IF(R177>519,519,R177))+IF(K177=0,0,K177*N177),2)","v":188.05},{"$f":"TRUNC((IF(K177=0,I177*N177,(I177-K177)*N177))+(IF(R177<519,0,R177-519)),2)+M177","v":1709.65},{"$f":"S177+T177","v":1897.7},null,null,0,{"$f":"IF(N177>0.01,(T177-VLOOKUP(T177,quincenal,1))*VLOOKUP(T177,quincenal,3)+VLOOKUP(T177,quincenal,2)-VLOOKUP(T177,subquincenal,2),0)","v":-102.30023999999997},0,{"$f":"TRUNC(IF(Y177<0.01,-Y177,0),2)","v":102.3},{"$f":"U177-W177-X177-Z177+AA177","v":2000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,106]
[null,null,null,"DEPARTAMENTO DE CEMENTERIOS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O174:O177)","v":8395.85},335.80999999999995,587.69000000000005,0,923.5,8395.85,9319.35,0,0,0,-180.64508799999996,126.25,306.89999999999998,9500]
[]
[null,null,null,"DEPARTAMENTO DE RASTRO"]
[null,null,null,"LOPEZ VILLEGAS J. JESUS","LOVJ470602UN7","LOVJ470602HJCPLS07",null,"GUARDA RASTRO",15,"TARJETA",null,0,0,{"$f":"2367/15","v":157.80000000000001},{"$f":"TRUNC(N181*I181,2)","v":2367},{"$f":"TRUNC(N181*I181*0.04,2)","v":94.68},{"$f":"TRUNC(N181*0.07*I181,2)","v":165.69},{"$f":"L181","v":0},{"$f":"TRUNC(Q181+P181+(IF(R181>519,519,R181))+IF(K181=0,0,K181*N181),2)","v":260.37},{"$f":"TRUNC((IF(K181=0,I181*N181,(I181-K181)*N181))+(IF(R181<519,0,R181-519)),2)+M181","v":2367},{"$f":"S181+T181","v":2627.37},null,null,0,{"$f":"IF(N181>0.01,(T181-VLOOKUP(T181,quincenal,1))*VLOOKUP(T181,quincenal,3)+VLOOKUP(T181,quincenal,2)-VLOOKUP(T181,subquincenal,2),0)","v":-6.9034880000000101},{"$f":"TRUNC(IF(Y181>0.01,Y181,0),2)","v":0},{"$f":"TRUNC(IF(Y181<0.01,-Y181,0),2)","v":6.9},{"$f":"U181-W181-X181-Z181+AA181","v":2634.27},{"$f":"[2]PORTADA!$D$10","v":1},null,107]
[null,null,null,"FREGOSO BARBOZA CARLOS RAFAEL","PARR",null,null,"VETERINARIO",15,"TARJETA",null,0,0,{"$f":"3669/15","v":244.6},{"$f":"TRUNC(N182*I182,2)","v":3669},{"$f":"TRUNC(N182*I182*0.04,2)","v":146.76},{"$f":"TRUNC(N182*0.07*I182,2)","v":256.83},{"$f":"L182","v":0},{"$f":"TRUNC(Q182+P182+(IF(R182>519,519,R182))+IF(K182=0,0,K182*N182),2)","v":403.59},{"$f":"TRUNC((IF(K182=0,I182*N182,(I182-K182)*N182))+(IF(R182<519,0,R182-519)),2)+M182","v":3669},{"$f":"S182+T182","v":4072.59},null,null,0,{"$f":"IF(N182>0.01,(T182-VLOOKUP(T182,quincenal,1))*VLOOKUP(T182,quincenal,3)+VLOOKUP(T182,quincenal,2)-VLOOKUP(T182,subquincenal,2),0)","v":296.12839999999994},{"$f":"TRUNC(IF(Y182>0.01,Y182,0),2)","v":296.12},{"$f":"TRUNC(IF(Y182<0.01,-Y182,0),2)","v":0},{"$f":"U182-W182-X182-Z182+AA182","v":3776.4700000000003},{"$f":"[2]PORTADA!$D$10","v":1},null,108]
[null,null,null,"MARTINEZ TORRES JUSTINO","MATJ",null,null,"AUXILIAR DE MENTENIMIENTO",15,"TARJETA",null,0,0,{"$f":"1591/15","v":106.06666666666666},{"$f":"TRUNC(N183*I183,2)","v":1591},{"$f":"TRUNC(N183*I183*0.04,2)","v":63.64},{"$f":"TRUNC(N183*0.07*I183,2)","v":111.37},{"$f":"L183","v":0},{"$f":"TRUNC(Q183+P183+(IF(R183>519,519,R183))+IF(K183=0,0,K183*N183),2)","v":175.01},{"$f":"TRUNC((IF(K183=0,I183*N183,(I183-K183)*N183))+(IF(R183<519,0,R183-519)),2)+M183","v":1591},{"$f":"S183+T183","v":1766.01},null,null,0,{"$f":"IF(N183>0.01,(T183-VLOOKUP(T183,quincenal,1))*VLOOKUP(T183,quincenal,3)+VLOOKUP(T183,quincenal,2)-VLOOKUP(T183,subquincenal,2),0)","v":-109.89383999999998},{"$f":"TRUNC(IF(Y183>0.01,Y183,0),2)","v":0},{"$f":"TRUNC(IF(Y183<0.01,-Y183,0),2)","v":109.89},{"$f":"U183-W183-X183-Z183+AA183","v":1875.9},null,null,109]
[null,null,null,"DEPARTAMENTO DE RASTRO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O181:O183)","v":7627},{"$f":"SUM(P181:P183)","v":305.08},533.89,0,838.97,7627,8465.9699999999993,0,0,0,179.33107199999992,296.12,116.79,8286.64,2,0]
[]
[null,null,null,"DEPARTAMENTO DE MERCADOS"]
[null,null,null,"GONZALEZ JARA J. REFUGIO JAVIER","GOJR670808","GOJR670808HJCNRF13","2007-03-17","VELADOR DEPTO DE MERCADOS",15,"TARJETA",null,0,0,{"$f":"1577/15","v":105.13333333333334},{"$f":"TRUNC(N187*I187,2)","v":1577},{"$f":"TRUNC(N187*I187*0.04,2)","v":63.08},{"$f":"TRUNC(N187*0.07*I187,2)","v":110.39},{"$f":"L187","v":0},{"$f":"TRUNC(Q187+P187+(IF(R187>519,519,R187))+IF(K187=0,0,K187*N187),2)","v":173.47},{"$f":"TRUNC((IF(K187=0,I187*N187,(I187-K187)*N187))+(IF(R187<519,0,R187-519)),2)+M187","v":1577},{"$f":"S187+T187","v":1750.47},null,null,0,{"$f":"IF(N187>0.01,(T187-VLOOKUP(T187,quincenal,1))*VLOOKUP(T187,quincenal,3)+VLOOKUP(T187,quincenal,2)-VLOOKUP(T187,subquincenal,2),0)","v":-110.78983999999998},{"$f":"TRUNC(IF(Y187>0.01,Y187,0),2)","v":0},{"$f":"TRUNC(IF(Y187<0.01,-Y187,0),2)","v":110.78},{"$f":"U187-W187-X187-Z187+AA187","v":1861.25},{"$f":"[2]PORTADA!$D$10","v":1},null,110]
[null,null,null,"MARTINEZ GONZALEZ JOSE DE JESUS","MAGJ401015","MAGJ401015HJCRNC00","2004-01-01","VELADOR DEPTO DE MERCADOS",15,"TARJETA",null,0,0,{"$f":"1577/15","v":105.13333333333334},{"$f":"TRUNC(N188*I188,2)","v":1577},{"$f":"TRUNC(N188*I188*0.04,2)","v":63.08},{"$f":"TRUNC(N188*0.07*I188,2)","v":110.39},{"$f":"L188","v":0},{"$f":"TRUNC(Q188+P188+(IF(R188>519,519,R188))+IF(K188=0,0,K188*N188),2)","v":173.47},{"$f":"TRUNC((IF(K188=0,I188*N188,(I188-K188)*N188))+(IF(R188<519,0,R188-519)),2)+M188","v":1577},{"$f":"S188+T188","v":1750.47},null,null,0,{"$f":"IF(N188>0.01,(T188-VLOOKUP(T188,quincenal,1))*VLOOKUP(T188,quincenal,3)+VLOOKUP(T188,quincenal,2)-VLOOKUP(T188,subquincenal,2),0)","v":-110.78983999999998},{"$f":"TRUNC(IF(Y188>0.01,Y188,0),2)","v":0},{"$f":"TRUNC(IF(Y188<0.01,-Y188,0),2)","v":110.78},{"$f":"U188-W188-X188-Z188+AA188","v":1861.25},{"$f":"[2]PORTADA!$D$10","v":1},null,111]
[null,null,null,"DEPARTAMENTO DE MERCADOS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O187:O188)","v":3154},{"$f":"SUM(P187:P188)","v":126.16},220.78,0,346.94,3154,3500.94,0,0,0,-221.57967999999997,0,221.56,3722.5]
[]
[null,null,null,"DEPARTAMENTO DE ASEO PUBLICO"]
[97,"5","7","NAVARRO HERNANDEZ SOSTENES","HUAB811011","HUAB810114HJCRGR01","2007-02-01","SUPERVISOR DE ASEO PUBLICO",15,"TARJETA",null,0,0,196.46899999999999,{"$f":"TRUNC(N192*I192,2)","v":2947.03},{"$f":"TRUNC(N192*I192*0.04,2)","v":117.88},{"$f":"TRUNC(N192*0.07*I192,2)","v":206.29},{"$f":"L192","v":0},{"$f":"TRUNC(Q192+P192+(IF(R192>519,519,R192))+IF(K192=0,0,K192*N192),2)","v":324.17},{"$f":"TRUNC((IF(K192=0,I192*N192,(I192-K192)*N192))+(IF(R192<519,0,R192-519)),2)+M192","v":2947.03},{"$f":"S192+T192","v":3271.2000000000003},null,null,0,{"$f":"IF(N192>0.01,(T192-VLOOKUP(T192,quincenal,1))*VLOOKUP(T192,quincenal,3)+VLOOKUP(T192,quincenal,2)-VLOOKUP(T192,subquincenal,2),0)","v":71.203776000000005},{"$f":"TRUNC(IF(Y192>0.01,Y192,0),2)","v":71.2},{"$f":"TRUNC(IF(Y192<0.01,-Y192,0),2)","v":0},{"$f":"U192-W192-X192-Z192+AA192","v":3200.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},null,112]
[null,null,null,"HUERTA AGUILA BERNARDINO","HUAB811011","HUAB810114HJCRGR01","2007-02-01","RECOLECTOR ASEO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,{"$f":"IF(N193>0.01,(T193-VLOOKUP(T193,quincenal,1))*VLOOKUP(T193,quincenal,3)+VLOOKUP(T193,quincenal,2)-VLOOKUP(T193,subquincenal,2),0)","v":-37.079488000000026},0,37.07,2503.4900000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,113]
[null,null,null,"GRACIA GOMEZ JAVIER","GAGJ731114","GAGJ731114HJCRMV00","2004-01-01","RECOLECTOR ASEO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,114]
[null,null,null,"FREGOZO ALVARADO ALFONSO","FEAA650918","FEAA650818HJCRLL05","2003-01-01","RECOLECTOR ASEO PUBLICO",15,"TARJETA",null,0,0,148.13333333333333,2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,115]
[null,null,null,"TELLEZ GOMEZ VICENTE",null,null,null,"RECOLECTOR ASEO PUBLICO",15,"TARJETA",null,0,0,148.13333333333333,2222,88.88,155.54,{"$f":"L196","v":0},244.42,2222,{"$f":"S196+T196","v":2466.42},null,0,0,{"$f":"IF(N196>0.01,(T196-VLOOKUP(T196,quincenal,1))*VLOOKUP(T196,quincenal,3)+VLOOKUP(T196,quincenal,2)-VLOOKUP(T196,subquincenal,2),0)","v":-37.079488000000026},0,{"$f":"TRUNC(IF(Y196<0.01,-Y196,0),2)","v":37.07},{"$f":"U196-W196-X196-Z196+AA196","v":2503.4900000000002},null,null,116]
[null,null,null,"MARTINEZ VEJAR JUAN JOSE","MAVJ710822","MAVJ710822HJCRJN04","2004-01-01","CHOFER ASEO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2659/15","v":177.26666666666668},2659,106.36,186.13,{"$f":"L197","v":0},292.49,2659,{"$f":"S197+T197","v":2951.49},null,null,0,{"$f":"IF(N197>0.01,(T197-VLOOKUP(T197,quincenal,1))*VLOOKUP(T197,quincenal,3)+VLOOKUP(T197,quincenal,2)-VLOOKUP(T197,subquincenal,2),0)","v":39.866111999999987},39.86,{"$f":"TRUNC(IF(Y197<0.01,-Y197,0),2)","v":0},{"$f":"U197-W197-X197-Z197+AA197","v":2911.6299999999997},{"$f":"[2]PORTADA!$D$10","v":1},null,117]
[null,null,null,"HERNANDEZ RICO JUAN JOSE","MATM450918","MATM451028HJCRRG08","2004-01-01","CHOFER ASEO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2745/15","v":183},2745,109.8,192.15,0,301.95,2745,3046.95,null,null,0,49.22291199999998,{"$f":"TRUNC(IF(Y198>0.01,Y198,0),2)","v":49.22},{"$f":"TRUNC(IF(Y198<0.01,-Y198,0),2)","v":0},2997.73,{"$f":"[2]PORTADA!$D$10","v":1},null,118]
[null,null,null,"RICO ARCE VICTOR","BECR460228","BECR460207HJCRHS07","2004-01-01","CHOFER ASEO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2745/15","v":183},2745,109.8,192.15,0,301.95,2745,3046.95,null,null,0,49.22291199999998,{"$f":"TRUNC(IF(Y199>0.01,Y199,0),2)","v":49.22},{"$f":"TRUNC(IF(Y199<0.01,-Y199,0),2)","v":0},2997.73,null,null,119]
[null,null,null,"MENDEZ GARCIA MIGUEL ANGEL","MEGM851109","MEGM851109HJCNRG03","2009-01-16","AUX. DE LIMPIEZA GRAL. ",15,"TARJETA",null,0,0,{"$f":"2745/15","v":183},2745,109.8,192.15,0,301.95,2745,3046.95,null,null,0,49.22291199999998,49.22,0,2997.73,{"$f":"[2]PORTADA!$D$10","v":1},null,120]
[null,null,null,"CISNEROS VAZQUEZ RAMIRO","CIVR540430","CIVR540430HJCSZM04","2007-01-01","RECOLECTOR ASEO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,{"$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,{"$f":"SUM(O192:O201)","v":24951.03},{"$f":"SUM(P192:P201)","v":998.03999999999985},1746.5700000000002,0,2744.61,24951.03,27695.64,0,0,0,73.341183999999799,258.72000000000003,185.35,27622.27]
[]
[null,null,null,"DEPARTAMENTO DE PARQUES Y JARDINES"]
[107,"5","8","NAVARRO HUERTA ISIDRO","HUCR450811","HUCR450831HJCRRM08","2004-01-01","SUPERVISOR DE PARQUES Y JARDINES",15,"TARJETA",null,0,0,196.46899999999999,{"$f":"TRUNC(N205*I205,2)","v":2947.03},{"$f":"TRUNC(N205*I205*0.04,2)","v":117.88},{"$f":"TRUNC(N205*0.07*I205,2)","v":206.29},{"$f":"L205","v":0},{"$f":"TRUNC(Q205+P205+(IF(R205>519,519,R205))+IF(K205=0,0,K205*N205),2)","v":324.17},{"$f":"TRUNC((IF(K205=0,I205*N205,(I205-K205)*N205))+(IF(R205<519,0,R205-519)),2)+M205","v":2947.03},{"$f":"S205+T205","v":3271.2000000000003},null,null,0,{"$f":"IF(N205>0.01,(T205-VLOOKUP(T205,quincenal,1))*VLOOKUP(T205,quincenal,3)+VLOOKUP(T205,quincenal,2)-VLOOKUP(T205,subquincenal,2),0)","v":71.203776000000005},{"$f":"TRUNC(IF(Y205>0.01,Y205,0),2)","v":71.2},{"$f":"TRUNC(IF(Y205<0.01,-Y205,0),2)","v":0},{"$f":"U205-W205-X205-Z205+AA205","v":3200.0000000000005},{"$f":"#REF!","v":{"$error":"#REF!"}},null,122]
[null,null,null,"HUERTA CORTES RAMON","HUCR450811","HUCR450831HJCRRM08","2004-01-01","JARDINERO",15,"TARJETA",null,0,0,{"$f":"2307/15","v":153.80000000000001},2307,92.28,161.49,0,253.77,2307,2560.77,null,null,0,{"$f":"IF(N206>0.01,(T206-VLOOKUP(T206,quincenal,1))*VLOOKUP(T206,quincenal,3)+VLOOKUP(T206,quincenal,2)-VLOOKUP(T206,subquincenal,2),0)","v":-27.831488000000036},0,27.83,2588.6,{"$f":"[2]PORTADA!$D$10","v":1},null,123]
[null,null,null,"SILVA PINTO J ASUNCIÓN","SIPA400815","SIPA400815HJCLNS02","2004-01-01","JARDINERO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,124]
[null,null,null,"MILLAN GARCIA J. JESUS",null,null,null,"JARDINERO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,null,null,125]
[null,null,null,"MARTINEZ CRUZ JUAN",null,null,null,"JARDINERO",15,"TARJETA",null,0,0,148.13333333333333,2222,88.88,155.54,0,244.42,2222,2466.42,null,0,0,-37.079488000000026,0,37.07,2503.4900000000002,null,null,126]
[null,null,null,"ACOSTA MURILLO JOAQUIN",null,null,null,"JARDINERO",15,"TARJETA",null,0,0,148.13333333333333,2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,null,null,127]
[null,null,null,"REGALADO BAÑUELOS FRANCISCO","REBF441211","REBF441211HJCGXR05","2005-01-01","BARRENDERO",15,"TARJETA",null,0,0,148.13333333333333,2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,{"$f":"TRUNC(IF(Y211>0.01,Y211,0),2)","v":0},37.07,2503.4900000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,128]
[null,null,null,"RUIZ MUÑOZ LUIS","RUML530529GL7","RUML530529HJCZXS03","2006-01-01","VIGILANTE",15,"TARJETA",null,0,0,{"$f":"2118/15","v":141.19999999999999},2118,84.72,148.26,{"$f":"L212","v":0},232.98,2118,{"$f":"S212+T212","v":2350.98},null,0,0,{"$f":"IF(N212>0.01,(T212-VLOOKUP(T212,quincenal,1))*VLOOKUP(T212,quincenal,3)+VLOOKUP(T212,quincenal,2)-VLOOKUP(T212,subquincenal,2),0)","v":-62.344688000000005},{"$f":"TRUNC(IF(Y212>0.01,Y212,0),2)","v":0},{"$f":"TRUNC(IF(Y212<0.01,-Y212,0),2)","v":62.34},{"$f":"U212-W212-X212-Z212+AA212","v":2413.3200000000002},null,null,129]
[null,null,null,"AYALA RODRIGUEZ MIGUEL ANGEL","AARM690504","AARM690504HJCYDG04","2004-01-01","PODADOR",15,"TARJETA",null,0,0,{"$f":"2758/15","v":183.86666666666667},2758,110.32,193.06,0,303.38,2758,3061.38,null,null,0,50.63731199999998,{"$f":"TRUNC(IF(Y213>0.01,Y213,0),2)","v":50.63},0,3010.75,{"$f":"[2]PORTADA!$D$10","v":1},null,130]
[null,null,null,"VERTEDERO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O205:O213)","v":21240.03},{"$f":"SUM(P205:P213)","v":849.59999999999991},1486.7999999999997,0,2336.4,21240.03,23576.43,0,0,0,-153.7325280000002,121.83000000000001,275.52,23730.12]
[]
[null,null,null,"DEPARTAMENTO DE ALUMBRADO PUBLICO"]
[null,null,null,"RUIZ HERNANDEZ CELESTINO","RUHC540519","RUHC540519HJCZRL03","2004-01-01","JEFE DE ALUMBRADO PUBLICO",15,"TARJETA",null,0,0,{"$f":"3428/15","v":228.53333333333333},{"$f":"TRUNC(N217*I217,2)","v":3428},{"$f":"TRUNC(N217*I217*0.04,2)","v":137.12},{"$f":"TRUNC(N217*0.07*I217,2)","v":239.96},{"$f":"L217","v":0},{"$f":"TRUNC(Q217+P217+(IF(R217>519,519,R217))+IF(K217=0,0,K217*N217),2)","v":377.08},{"$f":"TRUNC((IF(K217=0,I217*N217,(I217-K217)*N217))+(IF(R217<519,0,R217-519)),2)+M217","v":3428},{"$f":"S217+T217","v":3805.08},null,null,0,{"$f":"IF(N217>0.01,(T217-VLOOKUP(T217,quincenal,1))*VLOOKUP(T217,quincenal,3)+VLOOKUP(T217,quincenal,2)-VLOOKUP(T217,subquincenal,2),0)","v":143.783312},{"$f":"TRUNC(IF(Y217>0.01,Y217,0),2)","v":143.78},{"$f":"TRUNC(IF(Y217<0.01,-Y217,0),2)","v":0},{"$f":"U217-W217-X217-Z217+AA217","v":3661.2999999999997},{"$f":"[2]PORTADA!$D$10","v":1},null,131]
[null,null,null,"LARES RODRIGUEZ JOSE ANGEL",null,null,null,"ENCARGADO DE ALUMBRADO PUBLICO",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N218*I218,2)","v":3266.9},{"$f":"TRUNC(N218*I218*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N218*0.07*I218,2)","v":228.68},{"$f":"L218","v":0},{"$f":"TRUNC(Q218+P218+(IF(R218>519,519,R218))+IF(K218=0,0,K218*N218),2)","v":359.35},{"$f":"TRUNC((IF(K218=0,I218*N218,(I218-K218)*N218))+(IF(R218<519,0,R218-519)),2)+M218","v":3266.9},{"$f":"S218+T218","v":3626.25},null,null,0,{"$f":"IF(N218>0.01,(T218-VLOOKUP(T218,quincenal,1))*VLOOKUP(T218,quincenal,3)+VLOOKUP(T218,quincenal,2)-VLOOKUP(T218,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y218>0.01,Y218,0),2)","v":126.25},{"$f":"TRUNC(IF(Y218<0.01,-Y218,0),2)","v":0},{"$f":"U218-W218-X218-Z218+AA218","v":3500},null,null,132]
[null,null,null,"HERNANDEZ ALCARAZ ALVARO",null,null,null,"AUXILIARDE ALUMBRADO PUBLICO",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N219*I219,2)","v":3266.9},{"$f":"TRUNC(N219*I219*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N219*0.07*I219,2)","v":228.68},{"$f":"L219","v":0},{"$f":"TRUNC(Q219+P219+(IF(R219>519,519,R219))+IF(K219=0,0,K219*N219),2)","v":359.35},{"$f":"TRUNC((IF(K219=0,I219*N219,(I219-K219)*N219))+(IF(R219<519,0,R219-519)),2)+M219","v":3266.9},{"$f":"S219+T219","v":3626.25},null,null,0,{"$f":"IF(N219>0.01,(T219-VLOOKUP(T219,quincenal,1))*VLOOKUP(T219,quincenal,3)+VLOOKUP(T219,quincenal,2)-VLOOKUP(T219,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y219>0.01,Y219,0),2)","v":126.25},{"$f":"TRUNC(IF(Y219<0.01,-Y219,0),2)","v":0},{"$f":"U219-W219-X219-Z219+AA219","v":3500},null,null,133]
[null,null,null,"ROJAS HUERTA CARLOS ALFREDO",null,null,null,"AUXILIARDE ALUMBRADO PUBLICO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},{"$f":"TRUNC(N220*I220,2)","v":2222},{"$f":"TRUNC(N220*I220*0.04,2)","v":88.88},{"$f":"TRUNC(N220*0.07*I220,2)","v":155.54},{"$f":"L220","v":0},{"$f":"TRUNC(Q220+P220+(IF(R220>519,519,R220))+IF(K220=0,0,K220*N220),2)","v":244.42},{"$f":"TRUNC((IF(K220=0,I220*N220,(I220-K220)*N220))+(IF(R220<519,0,R220-519)),2)+M220","v":2222},{"$f":"S220+T220","v":2466.42},null,null,0,{"$f":"IF(N220>0.01,(T220-VLOOKUP(T220,quincenal,1))*VLOOKUP(T220,quincenal,3)+VLOOKUP(T220,quincenal,2)-VLOOKUP(T220,subquincenal,2),0)","v":-37.079488000000026},{"$f":"TRUNC(IF(Y220>0.01,Y220,0),2)","v":0},{"$f":"TRUNC(IF(Y220<0.01,-Y220,0),2)","v":37.07},{"$f":"U220-W220-X220-Z220+AA220","v":2503.4900000000002},null,null,134]
[null,null,null,"DEPARTAMENTO DE ALUMBRADO PUBLICO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O217:O220)","v":12183.8},{"$f":"SUM(P217:P220)","v":487.33999999999992},852.8599999999999,0,1340.2000000000003,12183.8,13524,0,0,0,359.21508799999987,396.28,37.07,13164.789999999999]
[]
[]
[null,null,null,"DEPARTAMENTO DE DEPORTES"]
[120,5,14,"ACOSTA GONZALEZ MIGUEL",null,null,null,"ENCARGADO DE LA UNIDAD DEPORTIVA",15,"TARJETA",null,0,0,147.9014,{"$f":"TRUNC(N225*I225,2)","v":2218.52},{"$f":"TRUNC(N225*I225*0.04,2)","v":88.74},{"$f":"TRUNC(N225*0.07*I225,2)","v":155.29},{"$f":"L225","v":0},{"$f":"TRUNC(Q225+P225+(IF(R225>519,519,R225))+IF(K225=0,0,K225*N225),2)","v":244.03},{"$f":"TRUNC((IF(K225=0,I225*N225,(I225-K225)*N225))+(IF(R225<519,0,R225-519)),2)+M225","v":2218.52},{"$f":"S225+T225","v":2462.5500000000002},null,null,0,{"$f":"IF(N225>0.01,(T225-VLOOKUP(T225,quincenal,1))*VLOOKUP(T225,quincenal,3)+VLOOKUP(T225,quincenal,2)-VLOOKUP(T225,subquincenal,2),0)","v":-37.458112000000028},{"$f":"TRUNC(IF(Y225>0.01,Y225,0),2)","v":0},{"$f":"TRUNC(IF(Y225<0.01,-Y225,0),2)","v":37.450000000000003},{"$f":"U225-W225-X225-Z225+AA225","v":2500},null,null,135]
[121,null,null,"GONZALEZ FLORES RAMON",null,null,null,"AUXILIAR DE MANTENIMIENTO DE LA UNIDAD DEPORTIVA",15,"TARJETA",null,0,0,113.977,1709.65,68.38,119.67,0,188.05,1709.65,1897.7,null,null,0,-102.30023999999997,0,102.3,2000,null,null,136]
[null,null,null,"RODRIGUEZ ARQUIETA DANIEL ORLANDO",null,null,null,"JARDINERO EN LA UNIDAD DEPORTIVA",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N227*I227,2)","v":1709.65},{"$f":"TRUNC(N227*I227*0.04,2)","v":68.38},{"$f":"TRUNC(N227*0.07*I227,2)","v":119.67},{"$f":"L227","v":0},{"$f":"TRUNC(Q227+P227+(IF(R227>519,519,R227))+IF(K227=0,0,K227*N227),2)","v":188.05},{"$f":"TRUNC((IF(K227=0,I227*N227,(I227-K227)*N227))+(IF(R227<519,0,R227-519)),2)+M227","v":1709.65},{"$f":"S227+T227","v":1897.7},null,null,0,{"$f":"IF(N227>0.01,(T227-VLOOKUP(T227,quincenal,1))*VLOOKUP(T227,quincenal,3)+VLOOKUP(T227,quincenal,2)-VLOOKUP(T227,subquincenal,2),0)","v":-102.30023999999997},0,{"$f":"TRUNC(IF(Y227<0.01,-Y227,0),2)","v":102.3},{"$f":"U227-W227-X227-Z227+AA227","v":2000},null,null,137]
[null,null,null,"MORA SANCHEZ EUSTACIO",null,null,null,"JARDINERO EN LA UNIDAD DEPORTIVA",15,"TARJETA",null,0,0,113.977,1709.65,68.38,119.67,0,188.05,1709.65,1897.7,null,null,0,-102.30023999999997,0,102.3,2000,null,null,138]
[null,null,null,"BERNAL PRECIADO JUAN JOSE",null,null,null,"JARDINERO",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,0,0,-37.079488000000026,{"$f":"TRUNC(IF(Y229>0.01,Y229,0),2)","v":0},37.07,2503.4900000000002,null,null,139]
[null,null,null,"OCHOA FLORES RAMON",null,null,null,"AUXILIAR DE MANTENIMIENTO DEL DEPTO. DE DEPORTES",15,"TARJETA",null,0,0,{"$f":"1989/15","v":132.6},1989,79.56,139.22999999999999,0,218.79,1989,2207.79,null,null,0,{"$f":"IF(N230>0.01,(T230-VLOOKUP(T230,quincenal,1))*VLOOKUP(T230,quincenal,3)+VLOOKUP(T230,quincenal,2)-VLOOKUP(T230,subquincenal,2),0)","v":-72.421839999999975},0,72.42,2280.21,null,null,140]
[null,null,null,"ILLAN LARA SAYDA",null,null,null,"NUTRIOLOGA EN EL DOMO POLIDEPORTIVO",7,"TARJETA",null,0,0,113.977,797.83,31.91,55.84,0,87.75,797.83,885.58,null,null,0,-160.80671999999998,0,160.80000000000001,1046.3800000000001]
[null,null,null,"GODINA ENRIQUEZ SILVIA","GOES781103IAA","GOES781103MJCDNL05","2009-01-01","CONSERJE DOMO POLIDEPORTIVO",15,"TARJETA",null,0,0,{"$f":"2106/15","v":140.4},2106,84.24,147.41999999999999,0,231.66,2106,2337.66,null,null,0,-63.650288000000003,{"$f":"TRUNC(IF(Y232>0.01,Y232,0),2)","v":0},63.65,2401.31,{"$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,{"$f":"SUM(O225:O232)","v":14462.3},{"$f":"SUM(P225:P232)","v":578.47},1012.3299999999999,0,1590.8000000000002,14462.3,16053.1,0,0,0,-678.31716800000004,0,678.29000000000008,16731.390000000003]
[]
[null,null,null,"SERVICIOS MEDICOS"]
[null,null,null,"MARTINEZ VALDIVIA FRANCISCO","MAVF520525","MAVF520525HJCRLR02","2004-01-01","MEDICO MUNICIPAL",15,"TARJETA",null,0,0,{"$f":"3634/15","v":242.26666666666668},{"$f":"TRUNC(N236*I236,2)","v":3634},{"$f":"TRUNC(N236*I236*0.04,2)","v":145.36000000000001},{"$f":"TRUNC(N236*0.07*I236,2)","v":254.38},{"$f":"L236","v":0},{"$f":"TRUNC(Q236+P236+(IF(R236>519,519,R236))+IF(K236=0,0,K236*N236),2)","v":399.74},{"$f":"TRUNC((IF(K236=0,I236*N236,(I236-K236)*N236))+(IF(R236<519,0,R236-519)),2)+M236","v":3634},{"$f":"S236+T236","v":4033.74},null,null,0,{"$f":"IF(N236>0.01,(T236-VLOOKUP(T236,quincenal,1))*VLOOKUP(T236,quincenal,3)+VLOOKUP(T236,quincenal,2)-VLOOKUP(T236,subquincenal,2),0)","v":183.89611199999999},{"$f":"TRUNC(IF(Y236>0.01,Y236,0),2)","v":183.89},{"$f":"TRUNC(IF(Y236<0.01,-Y236,0),2)","v":0},{"$f":"U236-W236-X236-Z236+AA236","v":3849.85},{"$f":"[2]PORTADA!$D$10","v":1},null,142]
[null,null,null,"LEAL FRANCISCO JAVIER","MAVF520525","MAVF520525HJCRLR02","2004-01-01","PEDIATRA",15,"TARJETA",null,0,0,260.28699999999998,{"$f":"TRUNC(N237*I237,2)","v":3904.3},{"$f":"TRUNC(N237*I237*0.04,2)","v":156.16999999999999},{"$f":"TRUNC(N237*0.07*I237,2)","v":273.3},{"$f":"L237","v":0},{"$f":"TRUNC(Q237+P237+(IF(R237>519,519,R237))+IF(K237=0,0,K237*N237),2)","v":429.47},{"$f":"TRUNC((IF(K237=0,I237*N237,(I237-K237)*N237))+(IF(R237<519,0,R237-519)),2)+M237","v":3904.3},{"$f":"S237+T237","v":4333.7700000000004},null,null,0,{"$f":"IF(N237>0.01,(T237-VLOOKUP(T237,quincenal,1))*VLOOKUP(T237,quincenal,3)+VLOOKUP(T237,quincenal,2)-VLOOKUP(T237,subquincenal,2),0)","v":333.77639999999997},{"$f":"TRUNC(IF(Y237>0.01,Y237,0),2)","v":333.77},{"$f":"TRUNC(IF(Y237<0.01,-Y237,0),2)","v":0},{"$f":"U237-W237-X237-Z237+AA237","v":4000.0000000000005},null,null,143]
[null,null,null,"ROBLES GONZALEZ CLAUDIA SUSANA","MAVF520525","MAVF520525HJCRLR02","2004-01-01","MEDICO MUNICIPAL",15,"TARJETA",null,0,0,260.28699999999998,3904.3,156.16999999999999,273.3,0,429.47,3904.3,4333.7700000000004,null,null,0,{"$f":"IF(N238>0.01,(T238-VLOOKUP(T238,quincenal,1))*VLOOKUP(T238,quincenal,3)+VLOOKUP(T238,quincenal,2)-VLOOKUP(T238,subquincenal,2),0)","v":333.77639999999997},333.77,0,4000.0000000000005,null,null,144]
[null,null,null,"SERVICIOS MEDICOS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O236:O238)","v":11442.6},457.69999999999993,800.98,0,1258.68,11442.6,12701.28,0,0,0,851.44891199999995,851.43,0,11849.85,1,0]
[]
[null,null,null,"INSPECCION AGRICOLA Y GANADERA"]
[null,null,null,"MORAN MARROQUIN GRICELDA ELIZABETH",null,null,null,"SECRETARIADEL DEPTO DE INSPECCION AGRICOLA Y GANADERA",15,"TARJETA",null,0,0,{"$f":"2107/15","v":140.46666666666667},{"$f":"TRUNC(N242*I242,2)","v":2107},{"$f":"TRUNC(N242*I242*0.04,2)","v":84.28},{"$f":"TRUNC(N242*0.07*I242,2)","v":147.49},{"$f":"L242","v":0},{"$f":"TRUNC(Q242+P242+(IF(R242>519,519,R242))+IF(K242=0,0,K242*N242),2)","v":231.77},{"$f":"TRUNC((IF(K242=0,I242*N242,(I242-K242)*N242))+(IF(R242<519,0,R242-519)),2)+M242","v":2107},{"$f":"S242+T242","v":2338.77},null,null,0,{"$f":"IF(N242>0.01,(T242-VLOOKUP(T242,quincenal,1))*VLOOKUP(T242,quincenal,3)+VLOOKUP(T242,quincenal,2)-VLOOKUP(T242,subquincenal,2),0)","v":-63.541488000000015},{"$f":"TRUNC(IF(Y242>0.01,Y242,0),2)","v":0},{"$f":"TRUNC(IF(Y242<0.01,-Y242,0),2)","v":63.54},{"$f":"U242-W242-X242-Z242+AA242","v":2402.31},{"$f":"[2]PORTADA!$D$10","v":1},null,145]
[null,null,null,"INSPECCION AGRICOLA Y GANADERA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O242)","v":2107},{"$f":"SUM(P242)","v":84.28},147.49,0,231.77,2107,2338.77,0,0,0,-63.541488000000015,0,63.54,2402.31,1,0]
[]
[null,null,null,"DEPARTAMENTO DE DESARROLLO RURAL"]
[129,1,19,"PARRA AGUAYO JORGE","MENV711022","MENV711022HJCNVC07",null,"ENCARGADO DE DESARROLLO RURAL",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N246*I246,2)","v":6083.01},{"$f":"TRUNC(N246*I246*0.04,2)","v":243.32},{"$f":"TRUNC(N246*0.07*I246,2)","v":425.81},{"$f":"L246","v":0},{"$f":"TRUNC(Q246+P246+(IF(R246>519,519,R246))+IF(K246=0,0,K246*N246),2)","v":669.13},{"$f":"TRUNC((IF(K246=0,I246*N246,(I246-K246)*N246))+(IF(R246<519,0,R246-519)),2)+M246","v":6083.01},{"$f":"S246+T246","v":6752.14},null,null,0,{"$f":"IF(N246>0.01,(T246-VLOOKUP(T246,quincenal,1))*VLOOKUP(T246,quincenal,3)+VLOOKUP(T246,quincenal,2)-VLOOKUP(T246,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y246>0.01,Y246,0),2)","v":752.14},{"$f":"TRUNC(IF(Y246<0.01,-Y246,0),2)","v":0},{"$f":"U246-W246-X246-Z246+AA246","v":6000},null,null,146]
[null,null,null,"MONTES COLIMA DIANA ROCIO","PAGO721112","PAGO721112HJCLRS01",null,"AUXILIAR DE DESARROLLO RURAL",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N247*I247,2)","v":2747.28},{"$f":"TRUNC(N247*I247*0.04,2)","v":109.89},{"$f":"TRUNC(N247*0.07*I247,2)","v":192.3},{"$f":"L247","v":0},{"$f":"TRUNC(Q247+P247+(IF(R247>519,519,R247))+IF(K247=0,0,K247*N247),2)","v":302.19},{"$f":"TRUNC((IF(K247=0,I247*N247,(I247-K247)*N247))+(IF(R247<519,0,R247-519)),2)+M247","v":2747.28},{"$f":"S247+T247","v":3049.4700000000003},null,null,0,{"$f":"IF(N247>0.01,(T247-VLOOKUP(T247,quincenal,1))*VLOOKUP(T247,quincenal,3)+VLOOKUP(T247,quincenal,2)-VLOOKUP(T247,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y247>0.01,Y247,0),2)","v":49.47},{"$f":"TRUNC(IF(Y247<0.01,-Y247,0),2)","v":0},{"$f":"U247-W247-X247-Z247+AA247","v":3000.0000000000005},null,null,147]
[130,null,null,"VELAZCO SIORDIA ANA KAREN","PAGO721112","PAGO721112HJCLRS01",null,"SECRETARIADE DESARROLLO RURAL",15,"TARJETA",null,0,0,147.9015,{"$f":"TRUNC(N248*I248,2)","v":2218.52},{"$f":"TRUNC(N248*I248*0.04,2)","v":88.74},{"$f":"TRUNC(N248*0.07*I248,2)","v":155.29},{"$f":"L248","v":0},{"$f":"TRUNC(Q248+P248+(IF(R248>519,519,R248))+IF(K248=0,0,K248*N248),2)","v":244.03},{"$f":"TRUNC((IF(K248=0,I248*N248,(I248-K248)*N248))+(IF(R248<519,0,R248-519)),2)+M248","v":2218.52},{"$f":"S248+T248","v":2462.5500000000002},null,null,0,{"$f":"IF(N248>0.01,(T248-VLOOKUP(T248,quincenal,1))*VLOOKUP(T248,quincenal,3)+VLOOKUP(T248,quincenal,2)-VLOOKUP(T248,subquincenal,2),0)","v":-37.458112000000028},{"$f":"TRUNC(IF(Y248>0.01,Y248,0),2)","v":0},{"$f":"TRUNC(IF(Y248<0.01,-Y248,0),2)","v":37.450000000000003},{"$f":"U248-W248-X248-Z248+AA248","v":2500},null,null,148]
[null,null,null,"DEPARTAMENTO DE DESARROLLO RURAL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O246:O248)","v":11048.810000000001},441.95,773.4,0,1215.3499999999999,11048.810000000001,12264.16,0,0,0,764.15462400000024,801.61,37.450000000000003,11500]
[]
[]
[null,null,null,"CONTRALORIA"]
[131,"3","1","MATA COVARRUBIAS ALAN MARCOS","BUHM840914",null,null,"CONTRALOR",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N253*I253,2)","v":6083.01},{"$f":"TRUNC(N253*I253*0.04,2)","v":243.32},{"$f":"TRUNC(N253*0.07*I253,2)","v":425.81},{"$f":"L253","v":0},{"$f":"TRUNC(Q253+P253+(IF(R253>519,519,R253))+IF(K253=0,0,K253*N253),2)","v":669.13},{"$f":"TRUNC((IF(K253=0,I253*N253,(I253-K253)*N253))+(IF(R253<519,0,R253-519)),2)+M253","v":6083.01},{"$f":"S253+T253","v":6752.14},null,null,0,{"$f":"IF(N253>0.01,(T253-VLOOKUP(T253,quincenal,1))*VLOOKUP(T253,quincenal,3)+VLOOKUP(T253,quincenal,2)-VLOOKUP(T253,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y253>0.01,Y253,0),2)","v":752.14},{"$f":"TRUNC(IF(Y253<0.01,-Y253,0),2)","v":0},{"$f":"U253-W253-X253-Z253+AA253","v":6000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,149]
[132,null,null,"RODRIGUEZ CASTELLANOS ANGELICA IVETTE","LEPC870628",null,null,"ASISITENTEDE CONTRALORIA",15,"TARJETA",null,0,0,183.1515,{"$f":"TRUNC(N254*I254,2)","v":2747.27},{"$f":"TRUNC(N254*I254*0.04,2)","v":109.89},{"$f":"TRUNC(N254*0.07*I254,2)","v":192.3},{"$f":"L254","v":0},{"$f":"TRUNC(Q254+P254+(IF(R254>519,519,R254))+IF(K254=0,0,K254*N254),2)","v":302.19},{"$f":"TRUNC((IF(K254=0,I254*N254,(I254-K254)*N254))+(IF(R254<519,0,R254-519)),2)+M254","v":2747.27},{"$f":"S254+T254","v":3049.46},null,null,0,{"$f":"IF(N254>0.01,(T254-VLOOKUP(T254,quincenal,1))*VLOOKUP(T254,quincenal,3)+VLOOKUP(T254,quincenal,2)-VLOOKUP(T254,subquincenal,2),0)","v":49.469887999999997},{"$f":"TRUNC(IF(Y254>0.01,Y254,0),2)","v":49.46},{"$f":"TRUNC(IF(Y254<0.01,-Y254,0),2)","v":0},{"$f":"U254-W254-X254-Z254+AA254","v":3000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,150]
[null,null,null,"CONTRALORIA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O253:O254)","v":8830.2800000000007},{"$f":"SUM(P253:P254)","v":353.21},618.11,0,971.31999999999994,8830.2800000000007,9801.6,0,0,0,801.61164800000017,801.6,0,9000]
[]
[null,null,null,"DELEGACIONES"]
[133,"2","1","ARVIZU BACILIO ALONSO CANUTO",null,null,null,"DELEGADO MUNICIPAL DE  OCONAHUA",15,"TARJETA",null,0,0,113.977,{"$f":"TRUNC(N258*I258,2)","v":1709.65},{"$f":"TRUNC(N258*I258*0.04,2)","v":68.38},{"$f":"TRUNC(N258*0.07*I258,2)","v":119.67},{"$f":"L258","v":0},{"$f":"TRUNC(Q258+P258+(IF(R258>519,519,R258))+IF(K258=0,0,K258*N258),2)","v":188.05},{"$f":"TRUNC((IF(K258=0,I258*N258,(I258-K258)*N258))+(IF(R258<519,0,R258-519)),2)+M258","v":1709.65},{"$f":"S258+T258","v":1897.7},null,null,0,{"$f":"IF(N258>0.01,(T258-VLOOKUP(T258,quincenal,1))*VLOOKUP(T258,quincenal,3)+VLOOKUP(T258,quincenal,2)-VLOOKUP(T258,subquincenal,2),0)","v":-102.30023999999997},0,{"$f":"TRUNC(IF(Y258<0.01,-Y258,0),2)","v":102.3},{"$f":"U258-W258-X258-Z258+AA258","v":2000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,151]
[null,null,null,"CORONA TIZNADO OSIRIS ELVIA",null,null,null,"SECRETARIA DEL REGISTRO CIVIL",15,"TARJETA",null,0,0,126.06699999999999,1891,75.64,132.37,0,208.01,1891,2099.0100000000002,null,null,0,-78.69383999999998,{"$f":"TRUNC(IF(Y259>0.01,Y259,0),2)","v":0},78.69,2177.7000000000003]
[null,null,null,"BRAMBILA MELCHOR ADRIAN",null,null,null,"ENCARGADO DE OBRAS ´PUBLICAS EN OCONAHUA",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N260*I260,2)","v":3266.9},{"$f":"TRUNC(N260*I260*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N260*0.07*I260,2)","v":228.68},{"$f":"L260","v":0},{"$f":"TRUNC(Q260+P260+(IF(R260>519,519,R260))+IF(K260=0,0,K260*N260),2)","v":359.35},{"$f":"TRUNC((IF(K260=0,I260*N260,(I260-K260)*N260))+(IF(R260<519,0,R260-519)),2)+M260","v":3266.9},{"$f":"S260+T260","v":3626.25},null,null,0,{"$f":"IF(N260>0.01,(T260-VLOOKUP(T260,quincenal,1))*VLOOKUP(T260,quincenal,3)+VLOOKUP(T260,quincenal,2)-VLOOKUP(T260,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y260>0.01,Y260,0),2)","v":126.25},{"$f":"TRUNC(IF(Y260<0.01,-Y260,0),2)","v":0},{"$f":"U260-W260-X260-Z260+AA260","v":3500}]
[null,null,null,"HERNANDEZ NARANJO VICTOR MANUEL","HENV720810","HENV700810HJCRRC03","2004-02-08","RECOLECTOR",15,"TARJETA",null,0,0,{"$f":"1882/15","v":125.46666666666667},{"$f":"TRUNC(N261*I261,2)","v":1882},{"$f":"TRUNC(N261*I261*0.04,2)","v":75.28},{"$f":"TRUNC(N261*0.07*I261,2)","v":131.74},{"$f":"L261","v":0},{"$f":"TRUNC(Q261+P261+(IF(R261>519,519,R261))+IF(K261=0,0,K261*N261),2)","v":207.02},{"$f":"TRUNC((IF(K261=0,I261*N261,(I261-K261)*N261))+(IF(R261<519,0,R261-519)),2)+M261","v":1882},{"$f":"S261+T261","v":2089.02},null,null,0,{"$f":"IF(N261>0.01,(T261-VLOOKUP(T261,quincenal,1))*VLOOKUP(T261,quincenal,3)+VLOOKUP(T261,quincenal,2)-VLOOKUP(T261,subquincenal,2),0)","v":-79.269839999999974},{"$f":"TRUNC(IF(Y261>0.01,Y261,0),2)","v":0},{"$f":"TRUNC(IF(Y261<0.01,-Y261,0),2)","v":79.260000000000005},{"$f":"U261-W261-X261-Z261+AA261","v":2168.2800000000002},{"$f":"[2]PORTADA!$D$10","v":1},null,152]
[null,null,null,"TIZNADO CHAVEZ LUIS RAMON","TICL781119J37","TICL781119HJCZHS05","2009-01-16","RECOLECTOR",15,"TARJETA",null,0,0,{"$f":"1882/15","v":125.46666666666667},1882,75.28,131.74,0,207.02,1882,2089.02,null,null,0,-79.269839999999974,0,79.260000000000005,2168.2800000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,153]
[null,null,null,"ORTIZ HERNANDEZ FRANCISCO JAVIER","OIHF661005","OIHF661005HJCRRR01","2004-02-08","RECOLECTOR",15,"TARJETA",null,0,0,125.46666666666667,1882,75.28,131.74,0,207.02,1882,2089.02,null,0,0,-79.269839999999974,0,79.260000000000005,2168.2800000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,154]
[null,null,null,"LOPEZ REYES LINO","LORL560923","LORL560923HJCPYN00",null,"GUARDARRASTRO",15,"TARJETA",null,0,0,{"$f":"1433/15","v":95.533333333333331},1433,57.32,100.31,0,157.63,1433,1590.63,null,null,0,-120.00583999999998,0,120,1710.63,{"$f":"[2]PORTADA!$D$10","v":1},null,155]
[null,null,null,"LOPEZ MARTINEZ LEOPOLDO",null,null,null,"AUX. DE LIMPIEZA",15,"TARJETA",null,0,0,{"$f":"1281/15","v":85.4},1281,51.24,89.67,0,140.91,1281,1421.91,null,null,0,-129.73383999999999,0,129.72999999999999,1551.64,{"$f":"[2]PORTADA!$D$10","v":1},null,156]
[null,null,null,"MELCHOR MARTINEZ RAFAEL ",null,null,null,"ENCARGADO UNIDAD DEPORTIVA",15,"TARJETA",null,0,0,{"$f":"1383/15","v":92.2},1383,55.32,96.81,{"$f":"L266","v":0},152.13,1383,{"$f":"S266+T266","v":1535.13},null,null,0,{"$f":"IF(N266>0.01,(T266-VLOOKUP(T266,quincenal,1))*VLOOKUP(T266,quincenal,3)+VLOOKUP(T266,quincenal,2)-VLOOKUP(T266,subquincenal,2),0)","v":-123.20583999999998},0,{"$f":"TRUNC(IF(Y266<0.01,-Y266,0),2)","v":123.2},{"$f":"U266-W266-X266-Z266+AA266","v":1658.3300000000002},{"$f":"[2]PORTADA!$D$10","v":1},null,157]
[null,null,null,"CERVANTES SANCHEZ GABRIEL","CESG4509243P3","CESG450924HMNRNB03","2004-02-08","ENCARGADO DE CEMENTERIOS",15,"TARJETA",null,0,0,{"$f":"904/15","v":60.266666666666666},904,36.159999999999997,63.28,0,99.44,904,1003.44,null,null,0,-153.86183999999997,0,153.86000000000001,1157.3000000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,158]
[null,null,null,"DELEGACIONES",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O258:O267)","v":17514.55},{"$f":"SUM(P258:P267)","v":700.56999999999994},1226.01,0,1926.58,17514.55,19441.13,0,0,0,-819.35532799999987,126.25,945.56000000000006,20260.440000000002,{"$error":"#REF!"},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O19+O26+O33+O40+O46+O51+O58+O69+O75+O82+O91+O98+O109+O118+O126+O130+O135+O143+O163+O171+O178+O189+O184+O202+O214+O221+O233+O239+O243+O249+O255+O268","v":555307.79000000015},{"$f":"P19+P26+P33+P40+P46+P51+P58+P69+P75+P82+P91+P98+P109+P118+P126+P130+P135+P143+P163+P171+P178+P189+P184+P202+P214+P221+P233+P239+P243+P249+P255+P268","v":22212.010000000002},38871.11,0,61083.12000000001,555307.79000000015,616390.91,0,0,0,{"$error":"#N/A"},40007.290000000008,4999.29,581382.90999999992]
[]
[]
[]
[]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",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,"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"]
[null,null,null,"ARAGON CORTES JOSE ALBERTO",null,null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N286*I286,2)","v":3291},{"$f":"TRUNC(N286*I286*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N286*0.07*I286,2)","v":230.37},{"$f":"L286","v":0},{"$f":"TRUNC(Q286+P286+(IF(R286>519,519,R286))+IF(K286=0,0,K286*N286),2)","v":362.01},{"$f":"TRUNC((IF(K286=0,I286*N286,(I286-K286)*N286))+(IF(R286<519,0,R286-519)),2)+M286","v":3291},{"$f":"S286+T286","v":3653.01},null,0,0,{"$f":"IF(N286>0.01,(T286-VLOOKUP(T286,quincenal,1))*VLOOKUP(T286,quincenal,3)+VLOOKUP(T286,quincenal,2)-VLOOKUP(T286,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y286>0.01,Y286,0),2)","v":128.87},0,{"$f":"U286-W286-X286-Z286+AA286","v":3524.1400000000003},null,null,1]
[145,11,17,"ARVIZU GIL HOMERO JOSE","AIGH730225LE1","AIGH730225HJCRLM08",null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N287*I287,2)","v":3291},{"$f":"TRUNC(N287*I287*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N287*0.07*I287,2)","v":230.37},{"$f":"L287","v":0},{"$f":"TRUNC(Q287+P287+(IF(R287>519,519,R287))+IF(K287=0,0,K287*N287),2)","v":362.01},{"$f":"TRUNC((IF(K287=0,I287*N287,(I287-K287)*N287))+(IF(R287<519,0,R287-519)),2)+M287","v":3291},{"$f":"S287+T287","v":3653.01},null,null,0,{"$f":"IF(N287>0.01,(T287-VLOOKUP(T287,quincenal,1))*VLOOKUP(T287,quincenal,3)+VLOOKUP(T287,quincenal,2)-VLOOKUP(T287,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y287>0.01,Y287,0),2)","v":128.87},{"$f":"TRUNC(IF(Y287<0.01,-Y287,0),2)","v":0},{"$f":"U287-W287-X287-Z287+AA287","v":3524.1400000000003},{"$f":"#REF!","v":{"$error":"#REF!"}},null,2]
[146,"11","17","CAMPERO MARTINEZ JUAN DANIEL","ROMP450629DNA","ROMP450629HJCSCB04",null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,null,null,3]
[147,11,17,"CARRILLO MURILLO SALVADOR","CAMS620429F91","CAMS620429HNTRRL00",null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,4]
[null,null,null,"CASTELLANOS RODRIGUEZ SUSANA LIZETH","CAMS620429F91","CAMS620429HNTRRL00",null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,null,null,5]
[148,null,null,"TORRES MORAN CARLOS",null,null,null,"DIRECTOR DE SEGURIDAD PUBLICA MUNICIPAL",15,"TARJETA",null,0,0,517.09199999999998,7756.38,310.25,542.94000000000005,0,853.19,7756.38,8609.57,null,null,0,1109.5735920000002,1109.57,0,7500,{"$f":"#REF!","v":{"$error":"#REF!"}},null,6]
[151,"11","17","HERNANDEZ PALACIOS REFUGIO GUADALUPE","DENL910517","DENL910517HJCLVS07",null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,{"$f":"TRUNC(IF(Y292>0.01,Y292,0),2)","v":128.87},{"$f":"TRUNC(IF(Y292<0.01,-Y292,0),2)","v":0},3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,7]
[152,"11","17","DOMINGUEZ PEREZ NOE","GASR",null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N293*I293,2)","v":3291},{"$f":"TRUNC(N293*I293*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N293*0.07*I293,2)","v":230.37},{"$f":"L293","v":0},{"$f":"TRUNC(Q293+P293+(IF(R293>519,519,R293))+IF(K293=0,0,K293*N293),2)","v":362.01},{"$f":"TRUNC((IF(K293=0,I293*N293,(I293-K293)*N293))+(IF(R293<519,0,R293-519)),2)+M293","v":3291},{"$f":"S293+T293","v":3653.01},null,null,0,{"$f":"IF(N293>0.01,(T293-VLOOKUP(T293,quincenal,1))*VLOOKUP(T293,quincenal,3)+VLOOKUP(T293,quincenal,2)-VLOOKUP(T293,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y293>0.01,Y293,0),2)","v":128.87},{"$f":"TRUNC(IF(Y293<0.01,-Y293,0),2)","v":0},{"$f":"U293-W293-X293-Z293+AA293","v":3524.1400000000003},{"$f":"#REF!","v":{"$error":"#REF!"}},null,8]
[155,"11","17","FIGUEROA SANTIAGO JAVIER ANTONIO","CAPV791223","CAPU791223HJCMTC05",null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,9]
[157,"11","17","FRANCO ARVIZU FERNANDO","HEAS",null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,10]
[null,null,null,"GARCIA FIGUEROA GUSTAVO ","HEAS",null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,{"$f":"TRUNC(IF(Y296<0.01,-Y296,0),2)","v":0},3524.1400000000003,null,null,11]
[158,"11","17","GARCIA FIGUEROA NORBERTO","AARG",null,null,"COMANDANTE",15,"TARJETA",null,0,0,{"$f":"4385/15","v":292.33333333333331},4385,175.4,306.95,0,482.35,4385,4867.3500000000004,null,null,0,413.29748800000004,413.29,0,4454.0600000000004,{"$f":"#REF!","v":{"$error":"#REF!"}},null,12]
[159,"11","17","GARCIA MAGALLANES FRANCISCO",null,null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,13]
[160,"11","17","GAYTAN PEREZ LUIS GABRIEL",null,null,null,"COMANDANTE",15,"TARJETA",null,0,0,{"$f":"4385/15","v":292.33333333333331},4385,175.4,306.95,0,482.35,4385,4867.3500000000004,null,null,0,413.29748800000004,413.29,0,4454.0600000000004,{"$f":"#REF!","v":{"$error":"#REF!"}},null,14]
[null,null,null,"RIVERA MORENO JORGE ALBERTO",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,15]
[null,null,null,"ORNELAS RODRIGUEZ MAYRA SOL",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,null,null,16]
[null,null,null,"GOMEZ MEZA ARMANDO",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,17]
[161,"11","17","GOMEZ TOVAR JUAN FRANCISCO","GOCB550313","GOCB550313HJCMHN07","2007-01-01","POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,18]
[162,"11","17","GONZALEZ CAMPOS JOSE MANUEL",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,19]
[null,null,null,"HERNANDEZ ARIAS SEBASTIAN","RUGE",null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,null,null,20]
[null,null,null,"RODRIGUEZ OLMEDO JOSE RAFAEL",null,null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,null,null,21]
[null,null,null,"INFANTE GUTIERREZ CRISTINA",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,null,null,22]
[167,"11","17","CASTAÑEDA ARANDAS EFREN",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,{"$f":"TRUNC(IF(Y308>0.01,Y308,0),2)","v":128.87},{"$f":"TRUNC(IF(Y308<0.01,-Y308,0),2)","v":0},3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,23]
[null,null,null,"MANCILLAS MORA MARTIN","MAMM741224","MAMM741224HCJNRR00",null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,null,null,24]
[168,"11","17","SALAS CARRANZA FRANCISCO CARLOS",null,null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,25]
[null,null,null,"GARCIA FIGUEROA JOSE MANUEL",null,null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,null,null,27]
[172,"11","17","REGALADO AQUINO JUAN","REAJ700624U14","REAJ700624HJCGQN05",null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,28]
[173,"11","17","REYES HERNANDEZ MOISES","REHM541231","REHM641231HJCYRS02",null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,29]
[174,"11","17","ROJAS PARRA GUILLERMO ALEJANDRO","RUGE",null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,30]
[null,null,null,"RAMIREZ ALVAREZ ANAHI",null,null,null,"POLICIA EN LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,null,0,128.877712,{"$f":"TRUNC(IF(Y315>0.01,Y315,0),2)","v":128.87},{"$f":"TRUNC(IF(Y315<0.01,-Y315,0),2)","v":0},3524.1400000000003,null,null,31]
[175,"11","17","ROSAS MACIEL JUAN ALVARO",null,null,null,"POLICIA DE LINEA",15,"TARJETA",null,0,0,219.4,3291,131.63999999999999,230.37,0,362.01,3291,3653.01,null,0,0,128.877712,128.87,0,3524.1400000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,32]
[181,"11","17","VILLANE VALLARTA EFREN OSWALDO","VIVE",null,null,"AUXILIAR ADMINISTRATIVO",15,"TARJETA",null,0,0,{"$f":"3969/15","v":264.60000000000002},3969,158.76,277.83,0,436.59,3969,4405.59,null,0,0,344.12839999999994,344.12,0,4061.4700000000003,{"$f":"#REF!","v":{"$error":"#REF!"}},null,34]
[null,null,null,"DIRECCION DE SEGURIDAD PUBLICA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O286:O317)","v":112643.38},4505.7299999999987,7885.029999999997,0,12390.760000000006,112643.38,125034.13999999993,0,0,0,5888.8729040000044,5888.6299999999974,0,119145.51]
[]
[null,null,null,"DEPARTAMENTO DE PROTECCION CIVIL"]
[183,"11","18","DE LATORRE GARCIA MIGUEL RAFAEL","GAHJ",null,null,"DIRECTOR DE PROTECCION CIVIL",15,"TARJETA",null,0,0,405.53410000000002,{"$f":"TRUNC(N321*I321,2)","v":6083.01},{"$f":"TRUNC(N321*I321*0.04,2)","v":243.32},{"$f":"TRUNC(N321*0.07*I321,2)","v":425.81},{"$f":"L321","v":0},{"$f":"TRUNC(Q321+P321+(IF(R321>519,519,R321))+IF(K321=0,0,K321*N321),2)","v":669.13},{"$f":"TRUNC((IF(K321=0,I321*N321,(I321-K321)*N321))+(IF(R321<519,0,R321-519)),2)+M321","v":6083.01},{"$f":"S321+T321","v":6752.14},null,null,0,{"$f":"IF(N321>0.01,(T321-VLOOKUP(T321,quincenal,1))*VLOOKUP(T321,quincenal,3)+VLOOKUP(T321,quincenal,2)-VLOOKUP(T321,subquincenal,2),0)","v":752.1417600000002},{"$f":"TRUNC(IF(Y321>0.01,Y321,0),2)","v":752.14},{"$f":"TRUNC(IF(Y321<0.01,-Y321,0),2)","v":0},{"$f":"U321-W321-X321-Z321+AA321","v":6000},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[184,null,null,"TRINIDAD RAMIREZ JOSE ROMAN","VAML800130","VAML800130HJCRRS04",null,"CHOFER PROTECCION CIVIL",15,"TARJETA",null,0,0,{"$f":"3016/15","v":201.06666666666666},{"$f":"TRUNC(N322*I322,2)","v":3016},{"$f":"TRUNC(N322*I322*0.04,2)","v":120.64},{"$f":"TRUNC(N322*0.07*I322,2)","v":211.12},{"$f":"L322","v":0},{"$f":"TRUNC(Q322+P322+(IF(R322>519,519,R322))+IF(K322=0,0,K322*N322),2)","v":331.76},{"$f":"TRUNC((IF(K322=0,I322*N322,(I322-K322)*N322))+(IF(R322<519,0,R322-519)),2)+M322","v":3016},{"$f":"S322+T322","v":3347.76},null,0,0,{"$f":"IF(N322>0.01,(T322-VLOOKUP(T322,quincenal,1))*VLOOKUP(T322,quincenal,3)+VLOOKUP(T322,quincenal,2)-VLOOKUP(T322,subquincenal,2),0)","v":78.707711999999987},{"$f":"TRUNC(IF(Y322>0.01,Y322,0),2)","v":78.7},{"$f":"TRUNC(IF(Y322<0.01,-Y322,0),2)","v":0},{"$f":"U322-W322-X322-Z322+AA322","v":3269.0600000000004},{"$f":"#REF!","v":{"$error":"#REF!"}},null,2]
[185,"11",18,"SUAREZ GUEVARA ALEJANDRO","SUGA700224UD9","SUGA700224HJCRVL07",null,"CHOFER PROTECCION CIVIL",15,"TARJETA",null,0,0,{"$f":"3016/15","v":201.06666666666666},{"$f":"TRUNC(N323*I323,2)","v":3016},{"$f":"TRUNC(N323*I323*0.04,2)","v":120.64},{"$f":"TRUNC(N323*0.07*I323,2)","v":211.12},{"$f":"L323","v":0},{"$f":"TRUNC(Q323+P323+(IF(R323>519,519,R323))+IF(K323=0,0,K323*N323),2)","v":331.76},{"$f":"TRUNC((IF(K323=0,I323*N323,(I323-K323)*N323))+(IF(R323<519,0,R323-519)),2)+M323","v":3016},{"$f":"S323+T323","v":3347.76},null,0,0,78.707711999999987,{"$f":"TRUNC(IF(Y323>0.01,Y323,0),2)","v":78.7},{"$f":"TRUNC(IF(Y323<0.01,-Y323,0),2)","v":0},{"$f":"U323-W323-X323-Z323+AA323","v":3269.0600000000004},{"$f":"#REF!","v":{"$error":"#REF!"}},null,3]
[186,"11",18,"HERNANDEZ ULLOA FRANCISCO JAVIER","LEME710921LM9","LEME710921MNTDLM01",null,"CHOFER PROTECCION CIVIL",15,"TARJETA",null,0,0,{"$f":"3016/15","v":201.06666666666666},{"$f":"TRUNC(N324*I324,2)","v":3016},{"$f":"TRUNC(N324*I324*0.04,2)","v":120.64},{"$f":"TRUNC(N324*0.07*I324,2)","v":211.12},{"$f":"L324","v":0},{"$f":"TRUNC(Q324+P324+(IF(R324>519,519,R324))+IF(K324=0,0,K324*N324),2)","v":331.76},{"$f":"TRUNC((IF(K324=0,I324*N324,(I324-K324)*N324))+(IF(R324<519,0,R324-519)),2)+M324","v":3016},{"$f":"S324+T324","v":3347.76},null,0,0,78.707711999999987,{"$f":"TRUNC(IF(Y324>0.01,Y324,0),2)","v":78.7},{"$f":"TRUNC(IF(Y324<0.01,-Y324,0),2)","v":0},{"$f":"U324-W324-X324-Z324+AA324","v":3269.0600000000004},{"$f":"#REF!","v":{"$error":"#REF!"}},null,4]
[null,null,null,"DEPARTAMENTO DE PROTECCION CIVIL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O321:O324)","v":15131.01},605.24,1059.17,0,1664.41,15131.01,16795.420000000002,0,0,0,988.26489600000025,988.24000000000012,0,15807.180000000004]
[]
[null,null,null,null,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,{"$f":"O325+O318","v":127774.39},5110.9699999999984,8944.1999999999971,0,14055.170000000006,127774.39,141829.55999999994,0,0,0,6877.137800000005,6876.8699999999972,0,134952.69,{"$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,{"$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,{"$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,{"$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,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",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,"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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[188,null,null,"ESPINOZA GONZALEZ ANGELA","EIGA240505KM2","EIGA240505MJCSNN09",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"626.5/15","v":41.766666666666666},{"$f":"TRUNC(N341*I341,2)","v":626.5},{"$f":"TRUNC(N341*I341*0.04,2)","v":25.06},{"$f":"TRUNC(N341*0.07*I341,2)","v":43.85},{"$f":"L341","v":0},{"$f":"TRUNC(Q341+P341+(IF(R341>519,519,R341))+IF(K341=0,0,K341*N341),2)","v":68.91},{"$f":"TRUNC((IF(K341=0,I341*N341,(I341-K341)*N341))+(IF(R341<519,0,R341-519)),2)+M341","v":626.5},{"$f":"S341+T341","v":695.41},null,null,0,{"$f":"IF(N341>0.01,(T341-VLOOKUP(T341,quincenal,1))*VLOOKUP(T341,quincenal,3)+VLOOKUP(T341,quincenal,2)-VLOOKUP(T341,subquincenal,2),0)","v":-171.77184},{"$f":"TRUNC(IF(Y341>0.01,Y341,0),2)","v":0},{"$f":"TRUNC(IF(Y341<0.01,-Y341,0),2)","v":171.77},{"$f":"U341-W341-X341-Z341+AA341","v":867.18},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[189,null,null,"DE LA ROSA MACIAS PABLO","ROMP450629DNA","ROMP450629HJCSCB04",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1480/15","v":98.666666666666671},{"$f":"TRUNC(N342*I342,2)","v":1480},{"$f":"TRUNC(N342*I342*0.04,2)","v":59.2},{"$f":"TRUNC(N342*0.07*I342,2)","v":103.6},{"$f":"L342","v":0},{"$f":"TRUNC(Q342+P342+(IF(R342>519,519,R342))+IF(K342=0,0,K342*N342),2)","v":162.80000000000001},{"$f":"TRUNC((IF(K342=0,I342*N342,(I342-K342)*N342))+(IF(R342<519,0,R342-519)),2)+M342","v":1480},{"$f":"S342+T342","v":1642.8},null,null,0,{"$f":"IF(N342>0.01,(T342-VLOOKUP(T342,quincenal,1))*VLOOKUP(T342,quincenal,3)+VLOOKUP(T342,quincenal,2)-VLOOKUP(T342,subquincenal,2),0)","v":-116.99783999999998},{"$f":"TRUNC(IF(Y342>0.01,Y342,0),2)","v":0},{"$f":"TRUNC(IF(Y342<0.01,-Y342,0),2)","v":116.99},{"$f":"U342-W342-X342-Z342+AA342","v":1759.79},null,null,2]
[null,null,null,"DIAZ ROMERO J FELIX","DIRF401208","DIRF401210HJCZML05","2001-01-01","PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1426/15","v":95.066666666666663},{"$f":"TRUNC(N343*I343,2)","v":1426},{"$f":"TRUNC(N343*I343*0.04,2)","v":57.04},{"$f":"TRUNC(N343*0.07*I343,2)","v":99.82},{"$f":"L343","v":0},{"$f":"TRUNC(Q343+P343+(IF(R343>519,519,R343))+IF(K343=0,0,K343*N343),2)","v":156.86000000000001},{"$f":"TRUNC((IF(K343=0,I343*N343,(I343-K343)*N343))+(IF(R343<519,0,R343-519)),2)+M343","v":1426},{"$f":"S343+T343","v":1582.8600000000001},null,null,0,{"$f":"IF(N343>0.01,(T343-VLOOKUP(T343,quincenal,1))*VLOOKUP(T343,quincenal,3)+VLOOKUP(T343,quincenal,2)-VLOOKUP(T343,subquincenal,2),0)","v":-120.45383999999997},{"$f":"TRUNC(IF(Y343>0.01,Y343,0),2)","v":0},{"$f":"TRUNC(IF(Y343<0.01,-Y343,0),2)","v":120.45},{"$f":"U343-W343-X343-Z343+AA343","v":1703.3100000000002},null,null,3]
[190,null,null,"ESQUIVEL CLARO EULALIA",null,null,null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"783.5/15","v":52.233333333333334},{"$f":"TRUNC(N344*I344,2)","v":783.5},{"$f":"TRUNC(N344*I344*0.04,2)","v":31.34},{"$f":"TRUNC(N344*0.07*I344,2)","v":54.84},{"$f":"L344","v":0},{"$f":"TRUNC(Q344+P344+(IF(R344>519,519,R344))+IF(K344=0,0,K344*N344),2)","v":86.18},{"$f":"TRUNC((IF(K344=0,I344*N344,(I344-K344)*N344))+(IF(R344<519,0,R344-519)),2)+M344","v":783.5},{"$f":"S344+T344","v":869.68000000000006},null,null,0,{"$f":"IF(N344>0.01,(T344-VLOOKUP(T344,quincenal,1))*VLOOKUP(T344,quincenal,3)+VLOOKUP(T344,quincenal,2)-VLOOKUP(T344,subquincenal,2),0)","v":-161.72384},{"$f":"TRUNC(IF(Y344>0.01,Y344,0),2)","v":0},{"$f":"TRUNC(IF(Y344<0.01,-Y344,0),2)","v":161.72},{"$f":"U344-W344-X344-Z344+AA344","v":1031.4000000000001},null,null,4]
[null,null,null,"GARCIA FRANCISCO",null,null,null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1181.5/15","v":78.766666666666666},{"$f":"TRUNC(N345*I345,2)","v":1181.5},{"$f":"TRUNC(N345*I345*0.04,2)","v":47.26},{"$f":"TRUNC(N345*0.07*I345,2)","v":82.7},{"$f":"L345","v":0},{"$f":"TRUNC(Q345+P345+(IF(R345>519,519,R345))+IF(K345=0,0,K345*N345),2)","v":129.96},{"$f":"TRUNC((IF(K345=0,I345*N345,(I345-K345)*N345))+(IF(R345<519,0,R345-519)),2)+M345","v":1181.5},{"$f":"S345+T345","v":1311.46},null,0,0,{"$f":"IF(N345>0.01,(T345-VLOOKUP(T345,quincenal,1))*VLOOKUP(T345,quincenal,3)+VLOOKUP(T345,quincenal,2)-VLOOKUP(T345,subquincenal,2),0)","v":-136.10183999999998},{"$f":"TRUNC(IF(Y345>0.01,Y345,0),2)","v":0},{"$f":"TRUNC(IF(Y345<0.01,-Y345,0),2)","v":136.1},{"$f":"U345-W345-X345-Z345+AA345","v":1447.56},null,null,5]
[191,"11","17","GIL RIVERA JOSE LUIS","GIRL700926","GIRL700926HJCLVS01","2007-01-01","PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1645.5/15","v":109.7},1645.5,65.819999999999993,115.18,0,181,1645.5,1826.5,null,0,0,-106.40583999999998,0,106.4,1932.9,{"$f":"#REF!","v":{"$error":"#REF!"}},null,6]
[193,null,null,"GOMEZ CHAVEZ BENIGNO","GUJJ351120F83","GUJJ351120HJCVR 03",null,"PENSIONADO",15,"TARJETA",null,0,0,114.417,{"$f":"TRUNC(N347*I347,2)","v":1716.25},{"$f":"TRUNC(N347*I347*0.04,2)","v":68.650000000000006},{"$f":"TRUNC(N347*0.07*I347,2)","v":120.13},{"$f":"L347","v":0},{"$f":"TRUNC(Q347+P347+(IF(R347>519,519,R347))+IF(K347=0,0,K347*N347),2)","v":188.78},{"$f":"TRUNC((IF(K347=0,I347*N347,(I347-K347)*N347))+(IF(R347<519,0,R347-519)),2)+M347","v":1716.25},{"$f":"S347+T347","v":1905.03},null,0,0,{"$f":"IF(N347>0.01,(T347-VLOOKUP(T347,quincenal,1))*VLOOKUP(T347,quincenal,3)+VLOOKUP(T347,quincenal,2)-VLOOKUP(T347,subquincenal,2),0)","v":-94.97784},{"$f":"TRUNC(IF(Y347>0.01,Y347,0),2)","v":0},{"$f":"TRUNC(IF(Y347<0.01,-Y347,0),2)","v":94.97},{"$f":"U347-W347-X347-Z347+AA347","v":2000},null,null,7]
[192,null,null,"GUIZAR CARRILLO FRANCISCO JAVIER",null,null,null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1645.5/15","v":109.7},{"$f":"TRUNC(N348*I348,2)","v":1645.5},{"$f":"TRUNC(N348*I348*0.04,2)","v":65.819999999999993},{"$f":"TRUNC(N348*0.07*I348,2)","v":115.18},{"$f":"L348","v":0},{"$f":"TRUNC(Q348+P348+(IF(R348>519,519,R348))+IF(K348=0,0,K348*N348),2)","v":181},{"$f":"TRUNC((IF(K348=0,I348*N348,(I348-K348)*N348))+(IF(R348<519,0,R348-519)),2)+M348","v":1645.5},{"$f":"S348+T348","v":1826.5},null,0,0,{"$f":"IF(N348>0.01,(T348-VLOOKUP(T348,quincenal,1))*VLOOKUP(T348,quincenal,3)+VLOOKUP(T348,quincenal,2)-VLOOKUP(T348,subquincenal,2),0)","v":-106.40583999999998},{"$f":"TRUNC(IF(Y348>0.01,Y348,0),2)","v":0},{"$f":"TRUNC(IF(Y348<0.01,-Y348,0),2)","v":106.4},{"$f":"U348-W348-X348-Z348+AA348","v":1932.9},null,null,8]
[194,null,null,"HERNANDEZ RAMIREZ SALVADOR","HERS421229UE7","HERS421229HJCRML04",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"2069.5/15","v":137.96666666666667},2069.5,82.78,144.86000000000001,0,227.64,2069.5,2297.14,null,null,0,-67.269839999999974,0,67.260000000000005,2364.4,{"$f":"#REF!","v":{"$error":"#REF!"}},null,9]
[195,null,null,"HERNANDEZ SANTIAGO JOSE DE JESUS","HESJ410605JD8","HESJ410605HJCRNS07",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1243.5/15","v":82.9},1243.5,49.74,87.04,0,136.78,1243.5,1380.28,null,null,0,-132.13383999999996,0,132.13,1512.4099999999999,{"$f":"#REF!","v":{"$error":"#REF!"}},null,10]
[196,null,null,"MENDEZ FRANCO MIGUEL","MEFM351006CE0","MEFM351006HJCNRG07",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"2924/15","v":194.93333333333334},2924,116.96,204.68,0,321.64,2924,3245.64,null,0,0,68.698111999999981,68.69,0,3176.95,{"$f":"#REF!","v":{"$error":"#REF!"}},null,11]
[197,null,null,"OCHOA FLORES MARIA DE JESUS","MERL260819Q10","MERL260819HJCZGS06",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"783.5/15","v":52.233333333333334},{"$f":"TRUNC(N352*I352,2)","v":783.5},{"$f":"TRUNC(N352*I352*0.04,2)","v":31.34},{"$f":"TRUNC(N352*0.07*I352,2)","v":54.84},{"$f":"L352","v":0},{"$f":"TRUNC(Q352+P352+(IF(R352>519,519,R352))+IF(K352=0,0,K352*N352),2)","v":86.18},{"$f":"TRUNC((IF(K352=0,I352*N352,(I352-K352)*N352))+(IF(R352<519,0,R352-519)),2)+M352","v":783.5},{"$f":"S352+T352","v":869.68000000000006},null,null,0,{"$f":"IF(N352>0.01,(T352-VLOOKUP(T352,quincenal,1))*VLOOKUP(T352,quincenal,3)+VLOOKUP(T352,quincenal,2)-VLOOKUP(T352,subquincenal,2),0)","v":-161.72384},{"$f":"TRUNC(IF(Y352>0.01,Y352,0),2)","v":0},{"$f":"TRUNC(IF(Y352<0.01,-Y352,0),2)","v":161.72},{"$f":"U352-W352-X352-Z352+AA352","v":1031.4000000000001},{"$f":"#REF!","v":{"$error":"#REF!"}},null,12]
[199,null,null,"ROJAS GARCIA FELIPE","ROGF340501T63","ROGF340501HJCJRL01",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"1243.5/15","v":82.9},1243.5,49.74,87.04,0,136.78,1243.5,1380.28,null,null,0,-132.13383999999996,0,132.13,1512.4099999999999,{"$f":"#REF!","v":{"$error":"#REF!"}},null,13]
[200,null,null,"SANCHEZ SANCHEZ RAYMUNDO","SASR4910255R8","SASR491025HJCNNY01",null,"PENSIONADO",15,"TARJETA",null,0,0,{"$f":"2918.5/15","v":194.56666666666666},2918.5,116.74,204.29,0,321.02999999999997,2918.5,3239.5299999999997,null,null,0,68.099711999999982,68.09,0,3171.4399999999996,{"$f":"#REF!","v":{"$error":"#REF!"}},null,14]
[null,null,null,"PENSIONADOS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O341:O354)","v":21687.25},867.49000000000012,1518.0499999999997,0,2385.54,21687.25,24072.789999999997,0,0,0,-1371.3022559999997,136.78,1508.04,25444.05]
[]
[]
[]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",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,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]
[]
[]
[]
[2,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,{"$f":"[2]PORTADA!$D$10","v":1}]
[202,null,null,"BAILON SIERRA ENRIQUE","BASE740304","BASE740304HJCLRN02",null,"ENCARGADO GENERAL DE ALCANTARILLADO",15,"TARJETA",null,0,0,{"$f":"2775/15","v":185},{"$f":"TRUNC(N365*I365,2)","v":2775},{"$f":"TRUNC(N365*I365*0.04,2)","v":111},{"$f":"TRUNC(N365*0.07*I365,2)","v":194.25},{"$f":"L365","v":0},{"$f":"TRUNC(Q365+P365+(IF(R365>519,519,R365))+IF(K365=0,0,K365*N365),2)","v":305.25},{"$f":"TRUNC((IF(K365=0,I365*N365,(I365-K365)*N365))+(IF(R365<519,0,R365-519)),2)+M365","v":2775},{"$f":"S365+T365","v":3080.25},null,null,0,{"$f":"IF(N365>0.01,(T365-VLOOKUP(T365,quincenal,1))*VLOOKUP(T365,quincenal,3)+VLOOKUP(T365,quincenal,2)-VLOOKUP(T365,subquincenal,2),0)","v":52.48691199999999},{"$f":"TRUNC(IF(Y365>0.01,Y365,0),2)","v":52.48},{"$f":"TRUNC(IF(Y365<0.01,-Y365,0),2)","v":0},{"$f":"U365-W365-X365-Z365+AA365","v":3027.77},{"$f":"[2]PORTADA!$D$10","v":1},null,1]
[203,"11","17","CARRILLO MUÑOZ SERGIO",null,null,null,"AUXILIAR DE ALCANTARILLADO EN ETZATLAN",15,"TARJETA",null,0,0,{"$f":"2222/15","v":148.13333333333333},2222,88.88,155.54,0,244.42,2222,2466.42,null,null,0,-37.079488000000026,0,37.07,2503.4900000000002,{"$f":"[2]PORTADA!$D$10","v":1},null,2]
[204,null,null,"DE LA ROSA MACIAS SALVADOR","ROMS500801","ROMS500801HJCSCL00",null,"AUXILIAR DE FONTANERO OCONAHUA",15,"TARJETA",null,0,0,{"$f":"1496/15","v":99.733333333333334},1496,59.84,104.72,0,164.56,1496,1660.56,null,null,0,-115.97383999999998,0,115.97,1776.53,{"$f":"[2]PORTADA!$D$10","v":1},null,3]
[205,null,null,"DELGADO DELGADO JOSE ANTONIO","DEDA550605","DEDA550605HNTLLN09",null,"AUXILIAR DE ALCANTARILLADO EN OCONAHUA",15,"TARJETA",null,0,0,{"$f":"1585/15","v":105.66666666666667},1585,63.4,110.95,0,174.35,1585,1759.35,null,null,0,-110.27783999999998,0,110.27,1869.62,{"$f":"[2]PORTADA!$D$10","v":1},null,4]
[206,null,null,"FLORES HARRIS JESUS","FOHJ730517","FOHJ730517HJCLRS08",null,"AUXILIAR OPERATIVO PLANTA TRATADORA",15,"TARJETA",null,0,0,{"$f":"2775/15","v":185},2775,111,194.25,0,305.25,2775,3080.25,null,null,0,52.48691199999999,52.48,0,3027.77,{"$f":"[2]PORTADA!$D$10","v":1},null,5]
[207,null,null,"GARCIA GARCIA SALVADOR","GAGS520228","GAGS361031HJCRRB04",null,"AUXILIAR OPERATIVO",15,"TARJETA",null,0,0,{"$f":"2775/15","v":185},2775,111,194.25,0,305.25,2775,3080.25,null,null,0,52.48691199999999,52.48,0,3027.77,{"$f":"[2]PORTADA!$D$10","v":1},null,6]
[208,null,null,"GARCIA MEDINA FRANCISCO JAVIER","GAMJ641203",null,null,"FONTANERO",15,"TARJETA",null,0,0,217.7938,{"$f":"TRUNC(N371*I371,2)","v":3266.9},{"$f":"TRUNC(N371*I371*0.04,2)","v":130.66999999999999},{"$f":"TRUNC(N371*0.07*I371,2)","v":228.68},{"$f":"L371","v":0},{"$f":"TRUNC(Q371+P371+(IF(R371>519,519,R371))+IF(K371=0,0,K371*N371),2)","v":359.35},{"$f":"TRUNC((IF(K371=0,I371*N371,(I371-K371)*N371))+(IF(R371<519,0,R371-519)),2)+M371","v":3266.9},{"$f":"S371+T371","v":3626.25},null,null,0,{"$f":"IF(N371>0.01,(T371-VLOOKUP(T371,quincenal,1))*VLOOKUP(T371,quincenal,3)+VLOOKUP(T371,quincenal,2)-VLOOKUP(T371,subquincenal,2),0)","v":126.25563199999996},{"$f":"TRUNC(IF(Y371>0.01,Y371,0),2)","v":126.25},{"$f":"TRUNC(IF(Y371<0.01,-Y371,0),2)","v":0},{"$f":"U371-W371-X371-Z371+AA371","v":3500},{"$f":"[2]PORTADA!$D$10","v":1},null,7]
[209,null,null,"GARCIA MEDINA JOSE DE JESUS","GAMJ521114","GAMJ521114HJCRDS00",null,"ELECTRICISTA",15,"TARJETA",null,0,0,{"$f":"3282/15","v":218.8},3282,131.28,229.74,0,361.02,3282,3643.02,null,null,0,127.89851199999995,127.89,0,3515.13,{"$f":"[2]PORTADA!$D$10","v":1},null,8]
[210,null,null,"GARCIA MEDINA RAMON","GAMR560716","GAMR560716HJCRDM02",null,"ENCARGADO GENERAL DE BOMBAS",15,"TARJETA",null,0,0,{"$f":"2984/15","v":198.93333333333334},2984,119.36,208.88,0,328.24,2984,3312.24,null,null,0,75.226111999999972,75.22,0,3237.02,{"$f":"[2]PORTADA!$D$10","v":1},null,9]
[211,null,null,"GARCIA MENDEZ HECTOR MIGUEL","GAMH851007","GAMH851007HJCRNC04",null,"FONTANERO",15,"TARJETA",null,0,0,{"$f":"2822/15","v":188.13333333333333},2822,112.88,197.54,0,310.42,2822,3132.42,null,0,0,57.600511999999981,57.6,0,3074.82,{"$f":"[2]PORTADA!$D$10","v":1},null,10]
[212,null,null,"GARCIA MEZA LUIS ALBERTO",null,null,null,"FONTANERO",15,"TARJETA",null,0,0,{"$f":"2822/15","v":188.13333333333333},2822,112.88,197.54,0,310.42,2822,3132.42,null,null,0,57.600511999999981,57.6,0,3074.82,{"$f":"[2]PORTADA!$D$10","v":1},null,11]
[213,"2","1","GONZALEZ ESPINOZA JAIME","GOEJ550102","GOEJ550102HJCNSM14",null,"ENCARGADO DE PLANTA TRATADORA DE AGUAS NEGRAS",15,"TARJETA",null,0,0,{"$f":"4596/15","v":306.39999999999998},4596,183.84,321.72000000000003,0,505.56,4596,5101.5600000000004,null,0,0,451.10868800000009,451.1,0,4650.46,{"$f":"[2]PORTADA!$D$10","v":1},null,12]
[214,"2","2","HERNANDEZ PINEDA JUAN JOSE","HEPJ581212","HEPJ571212HJCRNN00",null,"ENCARGADO  DE BOMBA EN SANTA ROSALIA",15,"TARJETA",null,0,0,{"$f":"1989/15","v":132.6},1989,79.56,139.22999999999999,0,218.79,1989,2207.79,null,null,0,-72.421839999999975,0,72.42,2280.21,{"$f":"[2]PORTADA!$D$10","v":1},null,13]
[215,null,null,"LEMUS SANCHEZ J. VENTURA",null,null,null,"AUXILIAR DE ALCANTARILLADO EN ETZATLAN",15,"TARJETA",null,0,0,{"$f":"2563/15","v":170.86666666666667},2563,102.52,179.41,0,281.93,2563,2844.93,null,null,0,14.421311999999972,14.42,0,2830.5099999999998,{"$f":"[2]PORTADA!$D$10","v":1},null,14]
[216,null,null,"MELCHOR CASILLAS SANTIAGO","MECS331205","MECS331205HJCLSN08",null,"ENCARGADO  DE BOMBA EN OCONAHUA",15,"TARJETA",null,0,0,{"$f":"1433/15","v":95.533333333333331},1433,57.32,100.31,0,157.63,1433,1590.63,null,null,0,-120.00583999999998,0,120,1710.63,{"$f":"[2]PORTADA!$D$10","v":1},null,15]
[217,null,null,"MENDEZ GARCIA JOSE GUADALUPE","MEGG780207","MEGG780207HJCNRD06",null,"FONTANERO",15,"TARJETA",null,0,0,{"$f":"2822/15","v":188.13333333333333},2822,112.88,197.54,0,310.42,2822,3132.42,null,null,0,57.600511999999981,57.6,0,3074.82,{"$f":"[2]PORTADA!$D$10","v":1},null,16]
[218,null,null,"MEZA RAMOS EUSEBIO","MERE520708","MERE491216HJCZMS01",null,"AUXILIAR OPERATIVO",15,"TARJETA",null,0,0,{"$f":"2775/15","v":185},2775,111,194.25,0,305.25,2775,3080.25,null,null,0,52.48691199999999,52.48,0,3027.77,{"$f":"[2]PORTADA!$D$10","v":1},null,17]
[219,null,null,"NAVARRO RODRIGUEZ BERTHA ALICIA","NARB840203","NARB840203MJCVDR03",null,"AUXILIAR ADMINISTRATIVO",15,"TARJETA",null,0,0,{"$f":"2622/15","v":174.8},2622,104.88,183.54,0,288.42,2622,2910.42,null,null,0,20.84051199999999,20.84,0,2889.58,{"$f":"[2]PORTADA!$D$10","v":1},null,18]
[220,null,null,"RUIZ CASTRO PEDRO","RUCP730628","RUCP730629HJCZSD07",null,"AUXILIAR OPERATIVO",15,"TARJETA",null,0,0,{"$f":"2775/15","v":185},2775,111,194.25,0,305.25,2775,3080.25,null,null,0,52.48691199999999,52.48,0,3027.77,{"$f":"[2]PORTADA!$D$10","v":1},null,19]
[221,null,null,"SANTIAGO LOPEZ SABINO","SALS481230","SALS481230HJCNPB00",null,"AUXILIAR DE FONTANERO OCONAHUA",15,"TARJETA",null,0,0,{"$f":"1496/15","v":99.733333333333334},1496,59.84,104.72,0,164.56,1496,1660.56,null,null,0,-115.97383999999998,0,115.97,1776.53,{"$f":"[2]PORTADA!$D$10","v":1},null,20]
[null,null,null,"GONZALEZ BERNAL ENRIQUE MARTIN",null,null,null,"ENCARGADO DEL AGUA POTABLE",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N385*I385,2)","v":2747.28},{"$f":"TRUNC(N385*I385*0.04,2)","v":109.89},{"$f":"TRUNC(N385*0.07*I385,2)","v":192.3},{"$f":"L385","v":0},{"$f":"TRUNC(Q385+P385+(IF(R385>519,519,R385))+IF(K385=0,0,K385*N385),2)","v":302.19},{"$f":"TRUNC((IF(K385=0,I385*N385,(I385-K385)*N385))+(IF(R385<519,0,R385-519)),2)+M385","v":2747.28},{"$f":"S385+T385","v":3049.4700000000003},null,null,0,{"$f":"IF(N385>0.01,(T385-VLOOKUP(T385,quincenal,1))*VLOOKUP(T385,quincenal,3)+VLOOKUP(T385,quincenal,2)-VLOOKUP(T385,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y385>0.01,Y385,0),2)","v":49.47},{"$f":"TRUNC(IF(Y385<0.01,-Y385,0),2)","v":0},{"$f":"U385-W385-X385-Z385+AA385","v":3000.0000000000005},null,null,21]
[null,null,null,"PONCE FRANCO JOSE SALVADOR",null,null,null,"ENCARGADO  DE BOMBA AGUA ZARCA",15,"TARJETA",null,0,0,183.15199999999999,{"$f":"TRUNC(N386*I386,2)","v":2747.28},{"$f":"TRUNC(N386*I386*0.04,2)","v":109.89},{"$f":"TRUNC(N386*0.07*I386,2)","v":192.3},{"$f":"L386","v":0},{"$f":"TRUNC(Q386+P386+(IF(R386>519,519,R386))+IF(K386=0,0,K386*N386),2)","v":302.19},{"$f":"TRUNC((IF(K386=0,I386*N386,(I386-K386)*N386))+(IF(R386<519,0,R386-519)),2)+M386","v":2747.28},{"$f":"S386+T386","v":3049.4700000000003},null,null,0,{"$f":"IF(N386>0.01,(T386-VLOOKUP(T386,quincenal,1))*VLOOKUP(T386,quincenal,3)+VLOOKUP(T386,quincenal,2)-VLOOKUP(T386,subquincenal,2),0)","v":49.470976000000007},{"$f":"TRUNC(IF(Y386>0.01,Y386,0),2)","v":49.47},{"$f":"TRUNC(IF(Y386<0.01,-Y386,0),2)","v":0},{"$f":"U386-W386-X386-Z386+AA386","v":3000.0000000000005},null,null,22]
[223,null,null,"VILLA RUBIO GABRIEL","VIRG590520","VIRG590520HJCLBB05",null,"ENCARGADO  DE BOMBA AGUA ZARCA",15,"TARJETA",null,0,0,{"$f":"2775/15","v":185},2775,111,194.25,0,305.25,2775,3080.25,null,null,0,52.48691199999999,52.48,0,3027.77,{"$f":"[2]PORTADA!$D$10","v":1},null,23]
[224,null,null,"SANCHEZ GARCIA VICTOR MANUEL",null,null,null,"FONTANERO",15,"TARJETA",null,0,0,{"$f":"2307/15","v":153.80000000000001},2307,92.28,161.49,{"$f":"L388","v":0},253.77,2307,{"$f":"S388+T388","v":2560.77},null,null,0,{"$f":"IF(N388>0.01,(T388-VLOOKUP(T388,quincenal,1))*VLOOKUP(T388,quincenal,3)+VLOOKUP(T388,quincenal,2)-VLOOKUP(T388,subquincenal,2),0)","v":-27.831488000000036},{"$f":"TRUNC(IF(Y388>0.01,Y388,0),2)","v":0},{"$f":"TRUNC(IF(Y388<0.01,-Y388,0),2)","v":27.83},{"$f":"U388-W388-X388-Z388+AA388","v":2588.6},{"$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,{"$f":"SUM(O365:O388)","v":62452.46},2498.09,4371.6499999999996,0,6869.74,62452.46,69322.2,0,0,0,802.85155199999974,1402.34,599.53000000000009,68519.39]
[]
[null,null,null,null,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,"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,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[148,null,null,"ACOSTA GUTIERREZ JUAN ANTONIO","AOGJ700101","AOGJ700101HJCCTN06",null,"VELADOR",15,"SOBRE",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N405*I405,2)","v":3291},{"$f":"TRUNC(N405*I405*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N405*0.07*I405,2)","v":230.37},{"$f":"L405","v":0},{"$f":"TRUNC(Q405+P405+(IF(R405>519,519,R405))+IF(K405=0,0,K405*N405),2)","v":362.01},{"$f":"TRUNC((IF(K405=0,I405*N405,(I405-K405)*N405))+(IF(R405<519,0,R405-519)),2)+M405","v":3291},{"$f":"S405+T405","v":3653.01},null,null,0,{"$f":"IF(N405>0.01,(T405-VLOOKUP(T405,quincenal,1))*VLOOKUP(T405,quincenal,3)+VLOOKUP(T405,quincenal,2)-VLOOKUP(T405,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y405>0.01,Y405,0),2)","v":128.87},{"$f":"TRUNC(IF(Y405<0.01,-Y405,0),2)","v":0},{"$f":"U405-W405-X405-Z405+AA405","v":3524.1400000000003},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1]
[152,"11","17","CHAVEZ VAZQUEZ JUAN PABLO","VARJ",null,null,"CASA DE LA CULTURA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N406*I406,2)","v":3291},{"$f":"TRUNC(N406*I406*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N406*0.07*I406,2)","v":230.37},{"$f":"L406","v":0},{"$f":"TRUNC(Q406+P406+(IF(R406>519,519,R406))+IF(K406=0,0,K406*N406),2)","v":362.01},{"$f":"TRUNC((IF(K406=0,I406*N406,(I406-K406)*N406))+(IF(R406<519,0,R406-519)),2)+M406","v":3291},{"$f":"S406+T406","v":3653.01},null,null,0,{"$f":"IF(N406>0.01,(T406-VLOOKUP(T406,quincenal,1))*VLOOKUP(T406,quincenal,3)+VLOOKUP(T406,quincenal,2)-VLOOKUP(T406,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y406>0.01,Y406,0),2)","v":128.87},{"$f":"TRUNC(IF(Y406<0.01,-Y406,0),2)","v":0},{"$f":"U406-W406-X406-Z406+AA406","v":3524.1400000000003},{"$f":"[4]PORTADA!$D$10","v":1},null,2]
[null,null,null,"HERNANDEZ RAMIREZ RUBEN","HERR820117","HERR820117HCSRMB01","2007-01-01","CASA DE LA CULTURA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N407*I407,2)","v":3291},{"$f":"TRUNC(N407*I407*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N407*0.07*I407,2)","v":230.37},{"$f":"L407","v":0},{"$f":"TRUNC(Q407+P407+(IF(R407>519,519,R407))+IF(K407=0,0,K407*N407),2)","v":362.01},{"$f":"TRUNC((IF(K407=0,I407*N407,(I407-K407)*N407))+(IF(R407<519,0,R407-519)),2)+M407","v":3291},{"$f":"S407+T407","v":3653.01},null,0,0,{"$f":"IF(N407>0.01,(T407-VLOOKUP(T407,quincenal,1))*VLOOKUP(T407,quincenal,3)+VLOOKUP(T407,quincenal,2)-VLOOKUP(T407,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y407>0.01,Y407,0),2)","v":128.87},{"$f":"TRUNC(IF(Y407<0.01,-Y407,0),2)","v":0},{"$f":"U407-W407-X407-Z407+AA407","v":3524.1400000000003},{"$f":"[4]PORTADA!$D$10","v":1},null,3]
[163,"11","17","HURTADO GRAJEDA PORFIRIO","HUGP501018195","HUGP501018HJCRRR00","2007-04-12","VELADOR EN CASA DE SALUD EN SANTA ROSALIA",15,"TARJETA",null,0,0,{"$f":"3291/15","v":219.4},{"$f":"TRUNC(N408*I408,2)","v":3291},{"$f":"TRUNC(N408*I408*0.04,2)","v":131.63999999999999},{"$f":"TRUNC(N408*0.07*I408,2)","v":230.37},{"$f":"L408","v":0},{"$f":"TRUNC(Q408+P408+(IF(R408>519,519,R408))+IF(K408=0,0,K408*N408),2)","v":362.01},{"$f":"TRUNC((IF(K408=0,I408*N408,(I408-K408)*N408))+(IF(R408<519,0,R408-519)),2)+M408","v":3291},{"$f":"S408+T408","v":3653.01},null,null,0,{"$f":"IF(N408>0.01,(T408-VLOOKUP(T408,quincenal,1))*VLOOKUP(T408,quincenal,3)+VLOOKUP(T408,quincenal,2)-VLOOKUP(T408,subquincenal,2),0)","v":128.877712},{"$f":"TRUNC(IF(Y408>0.01,Y408,0),2)","v":128.87},{"$f":"TRUNC(IF(Y408<0.01,-Y408,0),2)","v":0},{"$f":"U408-W408-X408-Z408+AA408","v":3524.1400000000003},null,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O405:O410)","v":13164},526.55999999999995,921.48,0,1448.04,13164,14612.04,0,0,0,515.51084800000001,515.48,0,14096.560000000001,{"$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,{"$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,{"$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,{"$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,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"L.A.F. EDUARDO RON RAMOS",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,"SINDICO MUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCARGADO DE LA HACIENDA PUBLICA"]

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