{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["recibo","base"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"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":"recibo","index":0,"n_rows":59,"n_cols":36,"rows_kept":59,"cut":false,"hidden":false,"merged":[[21,19,21,26],[6,35,11,36],[45,35,52,36],[50,25,50,32],[51,25,51,31],[52,25,52,32],[26,19,26,25],[26,30,26,32],[18,30,18,33],[19,30,19,32],[20,30,20,32],[21,30,21,32],[19,19,19,25],[20,19,20,25],[22,19,22,25],[50,18,50,20],[17,3,17,14],[1,10,4,28],[6,26,6,33],[8,16,8,17],[8,19,8,20],[9,19,9,20],[7,26,7,33],[8,26,8,33],[9,26,9,33],[10,26,10,33],[11,26,11,33],[14,12,14,24],[17,19,17,27],[25,3,25,4],[25,7,25,10],[27,2,28,5],[27,7,28,10],[27,12,28,14],[23,19,23,25],[24,19,24,27],[22,30,22,32],[23,30,23,32],[24,30,24,32],[55,1,56,4],[55,5,56,6],[38,29,38,32],[33,28,33,34],[35,28,35,33],[36,29,36,32],[39,28,40,34],[53,25,53,31],[44,18,44,21],[46,18,46,20],[47,18,47,20],[48,18,48,20],[49,18,49,20],[51,18,51,20],[52,18,52,20],[48,25,48,32],[25,19,25,25],[25,28,25,33],[32,27,32,34],[58,14,59,23],[55,11,56,13],[55,15,56,15],[45,25,45,31],[46,25,46,31],[47,25,47,31],[49,25,49,31]]}
[]
[null,null,null,null,null,null,null,null,null,null,"COMITÉ DE AGUA Y ALCANTARILLADO                                      DEL MUNICIPIO DE TAPACHULA"]
[]
[]
[]
[]
[null,null,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":"base!D1","v":"FECHA LIMITE DE PAGO"},null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!U2,IF(recibo!AA10=base!A3,base!U3,IF(recibo!AA10=base!A4,base!U4,IF(recibo!AA10=base!A5,base!U5,0))))","v":"Nº 1089322 \nFACTURA SERIE J"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!D2,IF(recibo!AA10=base!A3,base!D3,IF(recibo!AA10=base!A4,base!D4,IF(recibo!AA10=base!A5,base!D5,0))))","v":"23.01.14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"base!R1","v":"Nº"},null,{"$f":"IF(recibo!AA10=base!A2,base!R2,IF(recibo!AA10=base!A3,base!R3,IF(recibo!AA10=base!A4,base!R4,IF(recibo!AA10=base!A5,base!R5,9897))))","v":18},null,null,{"$f":"base!S1","v":"MZN"},null,null,{"$f":"IF(recibo!AA10=base!A2,base!S2,IF(recibo!AA10=base!A3,base!S3,IF(recibo!AA10=base!A4,base!S4,IF(recibo!AA10=base!A5,base!S5,1))))","v":32},null,null,null,{"$f":"base!A1","v":"Nº DE CONTRATO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"base!T1","v":"LOTE"},null,null,{"$f":"IF(recibo!AA10=base!A2,base!T2,IF(recibo!AA10=base!A3,base!T3,IF(recibo!AA10=base!A4,base!T4,IF(recibo!AA10=base!A5,base!T5,989))))","v":15},null,null,null,"9350-22837"]
[null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!B2,IF(recibo!AA10=base!A3,base!B3,IF(recibo!AA10=base!A4,base!B4,IF(recibo!AA10=base!A5,base!B5,0))))","v":"ADRIAN MORENO CRUZ"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"base!E1","v":"RUTA PROGRESIVO"}]
[null,null,{"$f":"IF(recibo!AA10=base!A2,base!C2,IF(recibo!AA10=base!A3,base!C3,IF(recibo!AA10=base!A4,base!C4,IF(recibo!AA10=base!A5,base!C5,0))))","v":"COL. CENTRO AV. CENTRAL M-1  L-31\n Nº 11 TAPACHULA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!E2,IF(recibo!AA10=base!A3,base!E3,IF(recibo!AA10=base!A4,base!E4,IF(recibo!AA10=base!A5,base!E5,0))))","v":"305   3450"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CONSUMOS Y FACTURIZACION"]
[]
[]
[null,null,null,"INFORMACION DE CONSUMOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONCEPTO FACTURADO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMPORTE"]
[null,null,{"$f":"(base!H1)","v":"LECTURA ANTERIOR"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!H2,IF(recibo!AA10=base!A3,base!H3,IF(recibo!AA10=base!A4,base!H4,IF(recibo!AA10=base!A5,base!H5,0))))","v":4},null,null,null,null,null,"REZAGO",null,null,null,null,null,null,null,null,null,null,64]
[null,null,{"$f":"(base!I1)","v":"LECTURA ACTUAL "},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!I2,IF(recibo!AA10=base!A3,base!I3,IF(recibo!AA10=base!A4,base!I4,IF(recibo!AA10=base!A5,base!I5,0))))","v":5},null,null,null,null,null,"CONSUMO DE AGUA",null,null,null,null,null,null,null,null,null,null,56]
[null,null,{"$f":"(base!J1)","v":"CONSUMO DEL PERIODO M3"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!J2,IF(recibo!AA10=base!A3,base!J3,IF(recibo!AA10=base!A4,base!J4,IF(recibo!AA10=base!A5,base!J5,0))))","v":9},null,null,null,null,null,"DESCARGA DE DRENAJE",null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RECARGOS",null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(N26,3,61.38)+D26","v":557.42000000000007}]
[null,null,{"$f":"base!K1","v":"PERIODO FACTURADO"},null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!K2,IF(recibo!AA10=base!A3,base!K3,IF(recibo!AA10=base!A4,base!K4,IF(recibo!AA10=base!A5,base!K5,0))))","v":"MEN-14-2013"},null,null,null,null,null,null,{"$f":"(base!G1)","v":"BOMBEROS"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!G2,IF(recibo!AA10=base!A3,base!G3,IF(recibo!AA10=base!A4,base!G4,IF(recibo!AA10=base!A5,base!G5,0))))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CREDITO POR REDONDEO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE20:AG24)-ROUNDDOWN(SUM(AE20:AG24),0)","v":0.42000000000007276}]
[null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!L2,IF(recibo!AA10=base!A3,base!L3,IF(recibo!AA10=base!A4,base!L4,IF(recibo!AA10=base!A5,base!L5,0))))","v":5},null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!M2,IF(recibo!AA10=base!A3,base!M3,IF(recibo!AA10=base!A4,base!M4,IF(recibo!AA10=base!A5,base!M5,0))))","v":70154332},null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!N2,IF(recibo!AA10=base!A3,base!N3,IF(recibo!AA10=base!A4,base!N4,IF(recibo!AA10=base!A5,base!N5,0))))","v":3},null,null,null,null,null,"CARGO POR REDONDEO",null,null,null,null,null,null,null,null,{"$f":"ROUND(AE27,0)-AE27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL A PAGAR",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE20:AG24)-AE25","v":695}]
[null,null,{"$f":"base!L1","v":"ADEUDO                              DE CONVENIO"},null,null,null,null,{"$f":"(base!M1)","v":"NUMERO DE MEDIDOR"},null,null,null,null,{"$f":"(base!N1)","v":"MESES DE ADEUDO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"pesosmn(AE27)","v":" ( SEISCIENTOS NOVENTA Y CINCO PESOS 00/100 M.N.)"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"base!O1","v":"USO DE SERVICIO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!O2,IF(recibo!AA10=base!A3,base!O3,IF(recibo!AA10=base!A4,base!O4,IF(recibo!AA10=base!A5,base!O5,0))))","v":"COMERCIAL"}]
[]
[null,null,null,null,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":"base!P1","v":"NIVEL"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!P2,IF(recibo!AA10=base!A3,base!P3,IF(recibo!AA10=base!A4,base!P4,IF(recibo!AA10=base!A5,base!P5,0))))","v":"ALTA"}]
[]
[null,null,null,null,null,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":"base!Q1","v":"GIR0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(recibo!AA10=base!A2,base!Q2,IF(recibo!AA10=base!A3,base!Q3,IF(recibo!AA10=base!A4,base!Q4,IF(recibo!AA10=base!A5,base!Q5,0))))","v":"EMPRESA"}]
[]
[]
[]
[]
[null,null,null,null,null,null,"HISTORIAL DE CONSUMO",null,null,null,null,null,null,null,null,null,null,null,"IMPORTE",null,null,null,null,null,null,"ESCLUSIVO COAPATAT"]
[null,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":"M24","v":"MEN-14-2013"},null,null,null,null,null,null,null,null,null,{"$f":"AJ7","v":"Nº 1089322 \nFACTURA SERIE J"}]
[null,null,{"$f":"T20","v":"REZAGO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE20","v":64},null,null,null,null,null,null,{"$f":"AA9","v":"Nº DE CONTRATO"}]
[null,null,"CONSUMO DE AGUA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,null,null,null,null,null,null,{"$f":"AA10","v":"9350-22837"}]
[null,null,"DESCARGA DE DRENAJE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,{"$f":"AA11","v":"RUTA PROGRESIVO"}]
[null,null,"RECARGOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,557.42000000000007,null,null,null,null,null,null,{"$f":"AA12","v":"305   3450"}]
[null,null,"BOMBEROS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,{"$f":"H28","v":"NUMERO DE MEDIDOR"}]
[null,null,"CREDITO POR REDONDEO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42000000000007276,null,null,null,null,null,null,{"$f":"H26","v":70154332}]
[null,null,{"$f":"T27","v":"TOTAL A PAGAR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE27","v":695},null,null,null,null,null,null,{"$f":"AA7","v":"FECHA LIMITE DE PAGO"}]
[null,null,null,null,null,null,null,null,{"$f":"S29","v":" ( SEISCIENTOS NOVENTA Y CINCO PESOS 00/100 M.N.)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA8","v":"23.01.14"}]
[]
[null,{"$f":"C28","v":"ADEUDO                              DE CONVENIO"},null,null,null,{"$f":"D26","v":5},null,null,null,null,null,{"$f":"M28","v":"MESES DE ADEUDO"},null,null,null,{"$f":"N26","v":3}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TALÒN DE PAGO"]

{"sheet":"base","index":1,"n_rows":5,"n_cols":21,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Nº DE CONTRATO","NOMBRE","DIRECCION","FECHA LIMITE DE PAGO","RUTA PROGRESIVO","NUMERO DE MEDIDOR","BOMBEROS","LECTURA ANTERIOR","LECTURA ACTUAL ","CONSUMO DEL PERIODO M3","PERIODO FACTURADO","ADEUDO                              DE CONVENIO","NUMERO DE MEDIDOR","MESES DE ADEUDO","USO DE SERVICIO","NIVEL","GIR0","Nº","MZN","LOTE","FACTURA"]
["93762-43946","CARLOS ALBERTO RAMOS BARRON","AV.CENTRO M-13 L-17 \nAV. VIDA ( FRACC. VIDA MEJOR ) TAPACHULA","22.01.14","306   5430",20132529,4,3,4,{"$f":"SUM(H2:I2)","v":7},"MEN-13-2013",5,80132927,2,"DOMESTICO","MEDIA","CASA \nHABITACION",0,34,12,"Nº 1039322 \nFACTURA SERIE J"]
["9350-22837","ADRIAN MORENO CRUZ","COL. CENTRO AV. CENTRAL M-1  L-31\n Nº 11 TAPACHULA","23.01.14","305   3450",95168987,5,4,5,{"$f":"SUM(H3:I3)","v":9},"MEN-14-2013",5,70154332,3,"COMERCIAL","ALTA","EMPRESA",18,32,15,"Nº 1089322 \nFACTURA SERIE J"]
["45871-93536","ERICK MIGUEL MENDEZ GARCIA","COL. IGNACIO ZARAGOZA S/N FRONTERA HIDALGO","24.01.14","308   6465",20759929,2,7,8,15,"MEN-15-2013",5,90654823,1,"DOMESTICO","BAJA","CASA \nHABITACION",20,3,0,"Nº 2079322 \nFACTURA SERIE J"]
["96840-92847","CINTYHA JESUSA PEREZ DE OCA","1RA PONIENTE Nº31 M-13\n COL. SAN ANGEL \nTAPACHULA ","25.01.14","305   3420",8012930,3,2,7,9,"MEN-16-2013",5,55674887,2,"COMERCIAL","ALTA","EMPRESA",32,36,1,"Nº 3039322 \nFACTURA SERIE J"]