{"text_format":"3","workbook":"xlsx","n_sheets":23,"sheets":["MENU","Hoja1","MENU_CONSULTAS","MENU_REPORTES","PARAMETROS","COMUNIDADES","F_USUARIOS","F_SALDOS.PC","F_MEDICIÓN","F_PAGOS","BD_COBROSRNC","RECIBOS","REPORTE_COBROS","REPORTE_IMPAGO","FICHA_MED","BD_SALDOS.PC","BD_MEDICIÓN","BD_RECIBOS","ESTATUS","BD_FICHA","REPORTE_FINAL","REC_TRANSITORIO","BD_USUARIOS"],"not_rendered":{"images":70,"macros":1,"defined_names":40},"read":"whole","date_system":"1900"}

{"sheet":"MENU","index":0,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[4,0,4,9],[4,10,4,12],[4,13,4,15]]}
[{"$f":"IF(PARAMETROS!C5=\"\",\"\",PARAMETROS!C5)","v":""}]
[{"$f":"IF(PARAMETROS!C7=\"\",\"\",PARAMETROS!C7)","v":""}]
["SISTEMA DE EMISIÓN DE RECIBOS"]
["MENÚ PRINCIPAL"]
["EMISIÓN DE RECIBOS",{"$nulls":9},"COBROS",null,null,"OTRAS OPCIONES"]
["PASO 1: PARAMETRIZAR LOS RECIBOS",null,null,"    PASO 3: REGISTRAR LOS USUARIOS",null,null,"          PASO 5: LLENAR DATOS DE MEDICIÓN"]
[]
[]
[]
[]
["PASO 2: DEFINIR LAS COMUNIDADES",null,null,"      PASO 4: ESTABLECER OTROS COBROS",null,null,"          PASO 5: GENERAR LOS RECIBOS EN PDF"]
[]
[]
[{"$nulls":12},"®"]
[]
[]
[]
[]
["® DERECHOS RESERVADOS, UNIVERSIDAD DE EL SALVADOR",{"$nulls":13},"PASSWORD: ADMIN"]

{"sheet":"Hoja1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"MENU_CONSULTAS","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]]}
[{"$f":"IF(PARAMETROS!C5=\"\",\"\",PARAMETROS!C5)","v":""}]
[{"$f":"IF(PARAMETROS!C7=\"\",\"\",PARAMETROS!C7)","v":""}]
["MENÚ DE CONSULTAS"]
{"$rows_empty":8}
[{"$nulls":12},"®"]
[]
[]
[]
[]
[]
["® DERECHOS RESERVADOS, UNIVERSIDAD DE EL SALVADOR"]

{"sheet":"MENU_REPORTES","index":3,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]]}
[{"$f":"IF(PARAMETROS!C5=\"\",\"\",PARAMETROS!C5)","v":""}]
[{"$f":"IF(PARAMETROS!C7=\"\",\"\",PARAMETROS!C7)","v":""}]
["MENÚ DE REPORTES DESCARGABLES"]
{"$rows_empty":8}
[{"$nulls":12},"®"]
[]
[]
[]
[]
[]
["® DERECHOS RESERVADOS, UNIVERSIDAD DE EL SALVADOR"]

{"sheet":"PARAMETROS","index":4,"n_rows":37,"n_cols":5,"rows_kept":37,"merged":[[0,1,0,4],[4,2,4,4],[6,2,6,4],[8,2,8,4],[10,2,10,4],[16,2,16,4],[18,2,18,4],[20,1,20,4]]}
[null,"PARAMETROS GENERALES DEL RECIBO"]
[]
[null,"CORRELATIVO DEL ULTIMO RECIBO EMITIDO"]
[]
[null,"NOMBRE DE LA ASOCIACIÓN: "]
[]
[null,"NOMBRE DEL SISTEMA DE AGUA:"]
[]
[null,"DIRECCIÓN Y TELEFONO DEL SISTEMA:"]
[]
[null,"LUGAR DE PAGO:"]
[]
[null,"PERIODO DE MEDICIÓN DESDE:",null,"HASTA:"]
[]
[null,"MES FACTURADO:"]
[]
[null,"ULTIMO DIA DE PAGO"]
[]
[null,"AVISO:"]
[]
[null,"PLIEGO TARIFARIO"]
[null,"DESDE(MTS)","HASTA(MTS)","CUOTA FIJA","VALOR DEL MT ADICIONAL"]
[]
[]
[]
[]
[]
[]
[null,null,"TIPOS DE SERVICIO DE AGUA"]
[null,1,"USO DOMICILIAR"]
[null,2,"USO EN NEGOCIO"]
[null,3,"SIN USO"]
[null,4,"OTROS"]
[null,5]
[null,6]
[null,7]
[null,8]

{"sheet":"COMUNIDADES","index":5,"n_rows":77,"n_cols":26,"rows_kept":77,"merged":[[0,1,0,14],[2,2,2,3],[2,7,2,8],[2,12,2,13],[3,3,3,4],[3,8,3,9],[3,13,3,14],[4,3,4,4],[4,8,4,9],[4,13,4,14],[5,3,5,4],[5,8,5,9],[5,13,5,14],[6,3,6,4],[6,8,6,9],[6,13,6,14],[7,3,7,4],[7,8,7,9],[7,13,7,14],[8,3,8,4],[8,8,8,9],[8,13,8,14],[9,3,9,4],[9,8,9,9],[9,13,9,14],[10,3,10,4],[10,8,10,9],[10,13,10,14],[11,3,11,4],[11,8,11,9],[11,13,11,14],[12,3,12,4],[12,8,12,9],[12,13,12,14],[13,3,13,4],[13,8,13,9],[13,13,13,14],[16,2,16,3],[16,7,16,8],[16,12,16,13],[17,3,17,4],[17,8,17,9],[17,13,17,14],[18,3,18,4],[18,8,18,9],[18,13,18,14],[19,3,19,4],[19,8,19,9],[19,13,19,14],[20,3,20,4],[20,8,20,9],[20,13,20,14],[21,3,21,4],[21,8,21,9],[21,13,21,14],[22,3,22,4],[22,8,22,9],[22,13,22,14],[23,3,23,4],[23,8,23,9],[23,13,23,14],[24,3,24,4],[24,8,24,9],[24,13,24,14],[25,3,25,4],[25,8,25,9],[25,13,25,14],[26,3,26,4],[26,8,26,9],[26,13,26,14],[27,3,27,4],[27,8,27,9],[27,13,27,14]]}
[null,"FICHA DE CANTONES Y COMUNIDADES"]
[]
[null,"NOMBRE DEL CANTÓN:",null,null,1,null,"NOMBRE DEL CANTÓN:",null,null,2,null,"NOMBRE DEL CANTÓN:",null,null,3]
[null,"COMUNIDADES:","2DO Y 3ER DÍGITO","CODIGO CONSOLIDADO",null,null,"COMUNIDADES:","2DO Y 3ER DÍGITO","CODIGO CONSOLIDADO",null,null,"COMUNIDADES:","2DO Y 3ER DÍGITO","CODIGO CONSOLIDADO",{"$nulls":4},"CANTÓN",null,{"$f":"S5","v":""},{"$f":"S6","v":""},{"$f":"S7","v":""},{"$f":"S8","v":""},{"$f":"S9","v":""},{"$f":"S10","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",\"10\")","v":""},{"$f":"IF(B5=\"\",\"\",CONCATENATE($E$3,C5))","v":""},{"$nulls":3},{"$f":"IF(G5=\"\",\"\",\"20\")","v":""},{"$f":"IF(G5=\"\",\"\",CONCATENATE($J$3,H5))","v":""},{"$nulls":3},{"$f":"IF(L5=\"\",\"\",\"30\")","v":""},{"$f":"IF(L5=\"\",\"\",CONCATENATE($O$3,M5))","v":""},{"$nulls":4},{"$f":"IF(C3=\"\",\"\",C3)","v":""},"CANTON1",{"$f":"IF(B5=\"\",\"\",B5)","v":""},{"$f":"IF(G5=\"\",\"\",G5)","v":""},{"$f":"IF(L5=\"\",\"\",L5)","v":""},{"$f":"IF(B19=\"\",\"\",B19)","v":""},{"$f":"IF(G19=\"\",\"\",G19)","v":""},{"$f":"IF(L19=\"\",\"\",L19)","v":""}]
[null,null,{"$f":"IF(B6=\"\",\"\",\"11\")","v":""},{"$f":"IF(B6=\"\",\"\",CONCATENATE($E$3,C6))","v":""},{"$nulls":3},{"$f":"IF(G6=\"\",\"\",\"21\")","v":""},{"$f":"IF(G6=\"\",\"\",CONCATENATE($J$3,H6))","v":""},{"$nulls":3},{"$f":"IF(L6=\"\",\"\",\"31\")","v":""},{"$f":"IF(L6=\"\",\"\",CONCATENATE($O$3,M6))","v":""},{"$nulls":4},{"$f":"IF(H3=\"\",\"\",H3)","v":""},"CANTON2","","","","","",""]
[null,null,{"$f":"IF(B7=\"\",\"\",\"12\")","v":""},"",{"$nulls":3},{"$f":"IF(G7=\"\",\"\",\"22\")","v":""},"",{"$nulls":3},{"$f":"IF(L7=\"\",\"\",\"32\")","v":""},"",{"$nulls":4},{"$f":"IF(M3=\"\",\"\",M3)","v":""},"CANTON3","","","","","",""]
[null,null,{"$f":"IF(B8=\"\",\"\",\"13\")","v":""},"",{"$nulls":3},{"$f":"IF(G8=\"\",\"\",\"23\")","v":""},"",{"$nulls":3},{"$f":"IF(L8=\"\",\"\",\"33\")","v":""},"",{"$nulls":4},{"$f":"IF(C17=\"\",\"\",C17)","v":""},"CANTON4","","","","","",""]
[null,null,{"$f":"IF(B9=\"\",\"\",\"14\")","v":""},"",{"$nulls":3},{"$f":"IF(G9=\"\",\"\",\"24\")","v":""},"",{"$nulls":3},{"$f":"IF(L9=\"\",\"\",\"34\")","v":""},"",{"$nulls":4},{"$f":"IF(H17=\"\",\"\",H17)","v":""},"CANTON5","","","","","",""]
[null,null,{"$f":"IF(B10=\"\",\"\",\"15\")","v":""},"",{"$nulls":3},{"$f":"IF(G10=\"\",\"\",\"25\")","v":""},"",{"$nulls":3},{"$f":"IF(L10=\"\",\"\",\"35\")","v":""},"",{"$nulls":4},{"$f":"IF(M17=\"\",\"\",M17)","v":""},"CANTON6","","","","","",""]
[null,null,{"$f":"IF(B11=\"\",\"\",\"16\")","v":""},"",{"$nulls":3},{"$f":"IF(G11=\"\",\"\",\"26\")","v":""},"",{"$nulls":3},{"$f":"IF(L11=\"\",\"\",\"36\")","v":""},"",{"$nulls":6},"","","","","",""]
[null,null,{"$f":"IF(B12=\"\",\"\",\"17\")","v":""},"",{"$nulls":3},{"$f":"IF(G12=\"\",\"\",\"27\")","v":""},"",{"$nulls":3},{"$f":"IF(L12=\"\",\"\",\"37\")","v":""},"",{"$nulls":6},"","","","","",""]
[null,null,{"$f":"IF(B13=\"\",\"\",\"18\")","v":""},"",{"$nulls":3},{"$f":"IF(G13=\"\",\"\",\"28\")","v":""},"",{"$nulls":3},{"$f":"IF(L13=\"\",\"\",\"38\")","v":""},"",{"$nulls":6},"","","","","",""]
[null,null,{"$f":"IF(B14=\"\",\"\",\"19\")","v":""},"",{"$nulls":3},{"$f":"IF(G14=\"\",\"\",\"29\")","v":""},"",{"$nulls":3},{"$f":"IF(L14=\"\",\"\",\"39\")","v":""},"",{"$nulls":6},"","","","","",""]
[]
[]
[null,"NOMBRE DEL CANTÓN:",null,null,4,null,"NOMBRE DEL CANTÓN:",null,null,5,null,"NOMBRE DEL CANTÓN:",null,null,6,{"$nulls":3},"CASERIO","CODIGO"]
[null,"COMUNIDADES:","2DO Y 3ER DÍGITO","CODIGO CONSOLIDADO",null,null,"COMUNIDADES:","2DO Y 3ER DÍGITO","CODIGO CONSOLIDADO",null,null,"COMUNIDADES:","2DO Y 3ER DÍGITO","CODIGO CONSOLIDADO",{"$nulls":4},{"$f":"B5","v":0},{"$f":"D5","v":""}]
[null,null,{"$f":"IF(B19=\"\",\"\",\"40\")","v":""},{"$f":"IF(B19=\"\",\"\",CONCATENATE($E$17,C19))","v":""},{"$nulls":3},{"$f":"IF(G19=\"\",\"\",\"50\")","v":""},{"$f":"IF(G19=\"\",\"\",CONCATENATE($J$17,H19))","v":""},{"$nulls":3},{"$f":"IF(L19=\"\",\"\",\"60\")","v":""},{"$f":"IF(L19=\"\",\"\",CONCATENATE($O$17,M19))","v":""},{"$nulls":4},{"$f":"B6","v":0},{"$f":"D6","v":""}]
[null,null,{"$f":"IF(B20=\"\",\"\",\"41\")","v":""},{"$f":"IF(B20=\"\",\"\",CONCATENATE($E$17,C20))","v":""},{"$nulls":3},{"$f":"IF(G20=\"\",\"\",\"51\")","v":""},{"$f":"IF(G20=\"\",\"\",CONCATENATE($J$17,H20))","v":""},{"$nulls":3},{"$f":"IF(L20=\"\",\"\",\"61\")","v":""},{"$f":"IF(L20=\"\",\"\",CONCATENATE($O$17,M20))","v":""},{"$nulls":4},0,""]
[null,null,{"$f":"IF(B21=\"\",\"\",\"42\")","v":""},"",{"$nulls":3},{"$f":"IF(G21=\"\",\"\",\"52\")","v":""},"",{"$nulls":3},{"$f":"IF(L21=\"\",\"\",\"62\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B22=\"\",\"\",\"43\")","v":""},"",{"$nulls":3},{"$f":"IF(G22=\"\",\"\",\"53\")","v":""},"",{"$nulls":3},{"$f":"IF(L22=\"\",\"\",\"63\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B23=\"\",\"\",\"44\")","v":""},"",{"$nulls":3},{"$f":"IF(G23=\"\",\"\",\"54\")","v":""},"",{"$nulls":3},{"$f":"IF(L23=\"\",\"\",\"64\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B24=\"\",\"\",\"45\")","v":""},"",{"$nulls":3},{"$f":"IF(G24=\"\",\"\",\"55\")","v":""},"",{"$nulls":3},{"$f":"IF(L24=\"\",\"\",\"65\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B25=\"\",\"\",\"46\")","v":""},"",{"$nulls":3},{"$f":"IF(G25=\"\",\"\",\"56\")","v":""},"",{"$nulls":3},{"$f":"IF(L25=\"\",\"\",\"66\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B26=\"\",\"\",\"47\")","v":""},"",{"$nulls":3},{"$f":"IF(G26=\"\",\"\",\"57\")","v":""},"",{"$nulls":3},{"$f":"IF(L26=\"\",\"\",\"67\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B27=\"\",\"\",\"48\")","v":""},"",{"$nulls":3},{"$f":"IF(G27=\"\",\"\",\"58\")","v":""},"",{"$nulls":3},{"$f":"IF(L27=\"\",\"\",\"68\")","v":""},"",{"$nulls":4},0,""]
[null,null,{"$f":"IF(B28=\"\",\"\",\"49\")","v":""},"",{"$nulls":3},{"$f":"IF(G28=\"\",\"\",\"59\")","v":""},"",{"$nulls":3},{"$f":"IF(L28=\"\",\"\",\"69\")","v":""},"",{"$nulls":4},{"$f":"G5","v":0},{"$f":"I5","v":""}]
[{"$nulls":18},{"$f":"G6","v":0},{"$f":"I6","v":""}]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},{"$f":"L5","v":0},{"$f":"N5","v":""}]
[{"$nulls":18},{"$f":"L6","v":0},{"$f":"N6","v":""}]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},{"$f":"B19","v":0},{"$f":"D19","v":""}]
[{"$nulls":18},{"$f":"B20","v":0},{"$f":"D20","v":""}]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},{"$f":"G19","v":0},{"$f":"I19","v":""}]
[{"$nulls":18},{"$f":"G20","v":0},{"$f":"I20","v":""}]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},{"$f":"L19","v":0},{"$f":"N19","v":""}]
[{"$nulls":18},{"$f":"L20","v":0},{"$f":"N20","v":""}]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]
[{"$nulls":18},0,""]

{"sheet":"F_USUARIOS","index":6,"n_rows":9,"n_cols":16384,"rows_kept":9,"merged":[[0,0,0,7]]}
["FORMULARIO DE ENTRADA DE USUARIO DEL SERVICIO DE AGUA"]
[]
["NOMBRE:",null,null,"CÓDIGO:",null,null,{"$f":"IFERROR(IF(B7=\"\",\"\",CONCATENATE(XFD5,IF(XFD7+1<10,CONCATENATE(\"00\",XFD7+1),IF(XFD7+1<100,CONCATENATE(\"0\",XFD7+1),XFD7+1)))),CONCATENATE(XFD5,\"001\"))","v":""}]
[{"$nulls":6},"SI LA ADMINISTRACIÓN NO POSEE ",{"$nulls":3},"CODIGO","NOMBRE","CANTON","COMUNIDAD","DIRECIÓN","TIPO SERV.","max"]
["CANTÓN:",null,null,"SERVICIO:",null,null,"CÓDIGOS  PREDEFINIDOS, SE",{"$nulls":3},{"$f":"E3","v":0},{"$f":"B3","v":0},{"$f":"B5","v":0},{"$f":"B7","v":0},{"$f":"E7","v":0},{"$f":"E5","v":0},{"$f":"MID(E3,4,3)","v":""},{"$nulls":16365},"COD. DE COMUNIDAD:",{"$f":"VLOOKUP(B7,COMUNIDADES!$S$18:$T$1048576,2,0)","v":""}]
[{"$nulls":4}," ",null," SUGIERE ADOPCIÓN DE ESTE"]
["COMUNIDAD:",null,null,"DIRECCIÓN:",null,null,"  CODIGO PARA EL USUARIO",{"$nulls":16375},"CORRELATIVO DE USUARIO:",{"$f":"MAX(MAX.CORR)","v":0}]
[]
[{"$nulls":16382},{"$f":"VLOOKUP(B5,COMUNIDADES!$S$5:$T$10,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"F_SALDOS.PC","index":7,"n_rows":16,"n_cols":19,"rows_kept":16,"merged":[[0,0,0,8],[1,0,1,8]]}
["FORMULARIO DE REGISTRO DE OTROS COBROS A FACTURAR"]
["(LLENAR UNICAMENTE LOS CAMPOS DE COLOR BLANCO)"]
[]
["DATOS DEL USUARIO",null,null,"CONCEPTO"]
[{"$nulls":11},"CODIGO","NOMBRE","SALDO DE PERIODOS ANTERIORES","MORA","COSTO POR RECONEXIÓN","ABONO A ACOMETIDA","OTROS","ESPEC. OTROS"]
["CODIGO DE USUARIO:",null,null,"SALDO DE MESES ANTERIORES:",{"$nulls":7},{"$f":"B6","v":0},{"$f":"B8","v":""},{"$f":"E6","v":0},{"$f":"E8","v":0},{"$f":"E10","v":0},{"$f":"E12","v":0},{"$f":"E14","v":0},{"$f":"E16","v":0}]
[]
["NOMBRE DE USUARIO:",{"$f":"IFERROR(VLOOKUP(B6,BD.USUARIO,2,0),\"\")","v":""},null,"MORA"]
[]
[{"$nulls":3},"COSTO POR RECONEXIÓN:"]
[]
[{"$nulls":3},"ABONOS A ACOMETIDA:"]
[]
[{"$nulls":3},"OTROS:"]
[]
[{"$nulls":3},"ESPECIFICAR OTROS:"]

{"sheet":"F_MEDICIÓN","index":8,"n_rows":15,"n_cols":27,"rows_kept":15,"merged":[[0,0,0,8],[1,0,1,8]]}
["FORMULARIO DE REGISTRO DE MEDICIONES Y ELABORACIÓN DE RECIBO"]
["(LLENAR UNICAMENTE LOS CAMPOS DE COLOR BLANCO)"]
["DATOS DEL USUARIO",null,null,"PERIODO",null,null,"MEDICIÓN"]
[]
["CODIGO DE USUARIO:",null,null,"DESDE:",{"$f":"IF(PARAMETROS!C13=\"\",\"\",PARAMETROS!C13)","v":""},null,"LECTURA ANTERIOR:"]
[]
["NOMBRE DE USUARIO:",{"$f":"IFERROR(VLOOKUP(B5,BD.USUARIO,2,0),\"\")","v":""},null,"HASTA:",{"$f":"IF(PARAMETROS!E13=\"\",\"\",PARAMETROS!E13)","v":""},null,"LECTURA ACTUAL:",{"$nulls":5},"CODIGO ","NOMBRE DE USUARIO","CANTÓN","COMUNIDAD O CASERIO","DIRECCIÓN","DESDE","HASTA","MES","LECTURA ANTERIOR","LECTURA ACTUAL","CONSUMO (METROS)","CUOTA FIJA","MONTO POR MTS ADICIONAL","MONTO FACTURADO","TIPO SERV."]
[{"$nulls":12},{"$f":"B5","v":0},{"$f":"B7","v":""},{"$f":"B9","v":""},{"$f":"B11","v":""},{"$f":"B13","v":""},{"$f":"E5","v":""},{"$f":"E7","v":""},{"$f":"E9","v":""},{"$f":"H5","v":0},{"$f":"H7","v":0},{"$f":"H9","v":0},{"$f":"H12","v":0},{"$f":"H13","v":0},{"$f":"H14","v":0},{"$f":"B15","v":""}]
["CANTÓN:",{"$f":"IFERROR(VLOOKUP(B5,BD.USUARIO,3,0),\"\")","v":""},null,"MES:",{"$f":"IF(PARAMETROS!C15=\"\",\"\",PARAMETROS!C15)","v":""},null,"CONSUMO:",{"$f":"H7-H5","v":0},null,"1º EXCESO",{"$f":"_xlfn.IFS(H9<PARAMETROS!C23,0,H9<=(PARAMETROS!B25-1),H9-PARAMETROS!C23,H9>(PARAMETROS!B25-1),(PARAMETROS!B25-PARAMETROS!B24))","v":0},{"$f":"K9*PARAMETROS!E24","v":0}]
[{"$nulls":6},"EXCESO",{"$f":"IF(H9<PARAMETROS!C23,0,H9-PARAMETROS!C23)","v":0},null,"2º EXCESO",{"$f":"_xlfn.IFS(H9<PARAMETROS!B25,0,H9<=(PARAMETROS!B26-1),F_MEDICIÓN!H9-F_MEDICIÓN!K9-PARAMETROS!C23,H9>(PARAMETROS!B26-1),PARAMETROS!B26-PARAMETROS!B25)","v":0},{"$f":"K10*PARAMETROS!E25","v":0}]
["COMUNIDAD O CASERIO:",{"$f":"IFERROR(VLOOKUP(B5,BD.USUARIO,4,0),\"\")","v":""},{"$nulls":7},"3º EXCESO",{"$f":"_xlfn.IFS(H9<PARAMETROS!B26,0,H9<=(PARAMETROS!B27-1),H9-PARAMETROS!C23-F_MEDICIÓN!K9-F_MEDICIÓN!K10,H9>(PARAMETROS!B27-1),PARAMETROS!B27-PARAMETROS!B26)","v":0},{"$f":"K11*PARAMETROS!E26","v":0}]
[{"$nulls":6},"CUOTA FIJA:",{"$f":"PARAMETROS!D23","v":0},null,"4º EXCESO",{"$f":"IF(H9<PARAMETROS!B27,0,H9-PARAMETROS!C23-F_MEDICIÓN!K9-F_MEDICIÓN!K10-F_MEDICIÓN!K11)","v":0},{"$f":"K12*PARAMETROS!E27","v":0}]
["DIRECCIÓN:",{"$f":"IFERROR(VLOOKUP(B5,BD.USUARIO,5,0),\"\")","v":""},{"$nulls":4},"MTS ADICIONALES:",{"$f":"SUM(L9:L12)","v":0}]
[{"$nulls":6},"TOTAL:",{"$f":"H12+H13","v":0}]
["SERVICIO:",{"$f":"IFERROR(VLOOKUP(B5,BD.USUARIO,6,0),\"\")","v":""}]

{"sheet":"F_PAGOS","index":9,"n_rows":16,"n_cols":25,"rows_kept":16,"merged":[[0,0,0,8],[1,0,1,8],[15,3,18,5]]}
["FORMULARIO DE REGISTRO DE RECIBOS COBRADOS"]
["(INSERTE EL NUMERO DE RECIBO, Y FECHA DE PAGO)"]
[]
["DATOS DEL USUARIO",null,null,"CONSUMO DEL MES",null,null,"SALDOS DE PERIODOS ANTERIORES"]
[{"$nulls":11},"RECIBO","CODIGO DE USUARIO","NOMBRE DEL USUARIO","CUOTA DEL MES","MTS ADICIONALES","SALDOS DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL","ESTADO","FECHA DE PAGO O VENCIMIENTO","MESES ATRASADOS"]
["Nº DE RECIBO PAGADO:",null,null,"CUOTA FIJA DEL MES",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,4,FALSE),\"\")","v":""},null,"SALDO DE MESES ANTERIORES:",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,6,FALSE),\"\")","v":""},{"$nulls":3},{"$f":"B6","v":0},{"$f":"B10","v":""},{"$f":"B12","v":""},{"$f":"E6","v":""},{"$f":"E8","v":""},{"$f":"H6","v":""},{"$f":"H8","v":""},{"$f":"H10","v":""},{"$f":"H12","v":""},{"$f":"H14","v":""},{"$f":"SUM(O6:U6)","v":0},"PAGADO",{"$f":"B8","v":"00:00:00"},0]
[]
["FECHA DE PAGO:",null,null,"MTS ADICIONALES",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,5,FALSE),\"\")","v":""},null,"MORA",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,7,FALSE),\"\")","v":""}]
[]
["CODIGO DE USUARIO:",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,2,FALSE),\"\")","v":""},{"$nulls":4},"COSTO POR RECONEXIÓN:",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,8,FALSE),\"\")","v":""}]
[]
["NOMBRE DE USUARIO:",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,3,FALSE),\"\")","v":""},{"$nulls":4},"ABONOS A ACOMETIDA:",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,9,FALSE),\"\")","v":""}]
[null,{"$f":"VLOOKUP(B6,BD_REC.EMITIDOS,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":6},"OTROS:",{"$f":"IFERROR(VLOOKUP(B6,BD_REC.EMITIDOS,10,FALSE),\"\")","v":""}]
[]
[{"$nulls":3},{"$f":"IF(B6=\"\",\"\",IFERROR(B13,\"RECIBO NO EMITIDO, ASEGURESE QUE EL Nº DE RECIBO A INGRESAR ES EL CORRECTO\"))","v":""}]

{"sheet":"BD_COBROSRNC","index":10,"n_rows":2,"n_cols":14,"rows_kept":2,"merged":[[0,0,0,13]]}
["REGISTRO DE RECIBOS COBRADOS"]
["Nº DE RECIBO","COD. USUARIO","NOMBRE DEL USUARIO","CUOTA DEL MES","MTS ADICIONALES","SALDOS DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL","ESTADO","FECHA DE PAGO ","M. A"]

{"sheet":"RECIBOS","index":11,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"REPORTE_COBROS","index":12,"n_rows":26,"n_cols":35,"rows_kept":26,"merged":[[0,0,0,10],[0,11,0,24],[0,25,0,35],[1,11,1,24],[1,25,1,35],[2,11,2,24],[2,25,2,35],[3,23,3,24],[3,34,3,35],[4,23,4,24],[4,34,4,35]]}
["MENÚ DE REPORTE DE RECIBOS COBRADOS",{"$nulls":10},{"$f":"PARAMETROS!$C$5","v":0},{"$nulls":13},{"$f":"L1","v":0}]
[{"$nulls":11},{"$f":"PARAMETROS!$C$7","v":0},{"$nulls":13},{"$f":"L2","v":0}]
[{"$nulls":11},"REPORTE DE RECIBOS COBRADOS (DETALLE)",{"$nulls":13},"REPORTE DE RECIBOS COBRADOS (RESUMEN)"]
[{"$nulls":11},"ESTADO",{"$nulls":10},"PERIODO:",{"$f":"PARAMETROS!$C$15","v":"00:00:00"},{"$nulls":9},"PERIODO:",{"$f":"PARAMETROS!$C$15","v":"00:00:00"}]
[{"$nulls":11},"PAGADO",{"$nulls":10},"EMITIDO:",{"$f":"TODAY()","v":"2021-10-19"},{"$nulls":9},"EMITIDO:",{"$f":"TODAY()","v":"2021-10-19"}]
[]
[{"$nulls":26},"CONCEPTO","CUOTA DEL MES","MTS ADICIONALES","SALDOS DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL GENERAL"]
[{"$nulls":26},"TOTAL",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[{"$nulls":26},"F. ___________________________________",{"$nulls":5},"F. ___________________________________"]
[{"$nulls":26},"ELABORADO POR",{"$nulls":5},"AUTORIZA"]
[{"$nulls":26},"NOMBRE:",{"$nulls":5},"NOMBRE:"]
[{"$nulls":26},"CARGO:",{"$nulls":5},"CARGO:"]
[]
[]
[]
[]
[{"$nulls":29},"F. ___________________________________"]
[{"$nulls":29},"REVISA"]
[{"$nulls":29},"NOMBRE:"]
[{"$nulls":29},"CARGO:"]

{"sheet":"REPORTE_IMPAGO","index":13,"n_rows":26,"n_cols":33,"rows_kept":26,"merged":[[0,0,0,10],[0,11,0,22],[0,23,0,33],[1,11,1,22],[1,23,1,33],[2,11,2,22],[2,23,2,33],[3,21,3,22],[3,32,3,33],[4,21,4,22],[4,32,4,33]]}
["MENÚ DE REPORTE DE RECIBOS NO CANCELADOS",{"$nulls":10},{"$f":"PARAMETROS!$C$5","v":0},{"$nulls":11},{"$f":"L1","v":0}]
[{"$nulls":11},{"$f":"PARAMETROS!$C$7","v":0},{"$nulls":11},{"$f":"L2","v":0}]
[{"$nulls":11},"REPORTE DE RECIBOS NO CANCELADOS (DETALLE)",{"$nulls":11},"REPORTE DE RECIBOS NO CANCELADOS (RESUMEN)"]
[{"$nulls":11},"ESTADO",{"$nulls":8},"PERIODO:",{"$f":"PARAMETROS!$C$15","v":"00:00:00"},{"$nulls":9},"PERIODO:",{"$f":"PARAMETROS!$C$15","v":"00:00:00"}]
[{"$nulls":11},"NO CANCELADO",{"$nulls":8},"EMITIDO:",{"$f":"TODAY()","v":"2021-10-19"},{"$nulls":9},"EMITIDO:",{"$f":"TODAY()","v":"2021-10-19"}]
[]
[{"$nulls":24},"CONCEPTO","CUOTA DEL MES","MTS ADICIONALES","SALDOS DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL GENERAL"]
[]
[{"$nulls":24},"TOTALES",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[{"$nulls":24},"F. ___________________________________",{"$nulls":5},"F. ___________________________________"]
[{"$nulls":24},"ELABORADO POR",{"$nulls":5},"AUTORIZA"]
[{"$nulls":24},"NOMBRE:",{"$nulls":5},"NOMBRE:"]
[{"$nulls":24},"CARGO:",{"$nulls":5},"CARGO:"]
[]
[]
[]
[]
[{"$nulls":27},"F. ___________________________________"]
[{"$nulls":27},"REVISA"]
[{"$nulls":27},"NOMBRE:"]
[{"$nulls":27},"CARGO:"]

{"sheet":"FICHA_MED","index":14,"n_rows":6,"n_cols":10,"rows_kept":6,"merged":[[0,0,0,7],[0,8,0,12],[1,8,1,12],[2,8,2,12]]}
["MENÚ DE ELABORACIÓN DE FICHA DE MEDICIÓN",{"$nulls":7},{"$f":"PARAMETROS!C5","v":0}]
[{"$nulls":8},{"$f":"PARAMETROS!C7","v":0}]
[{"$nulls":8},"FICHA DE LECTURA DE MEDIDORES"]
[]
[{"$nulls":8},"Consumo","Periodo  de medición Desde:_______________ Hasta:_______________"]
[{"$nulls":8},"SI"]

{"sheet":"BD_SALDOS.PC","index":15,"n_rows":2,"n_cols":8,"rows_kept":2,"merged":[[0,0,0,7]]}
["OTROS COBROS A FACTURAR"]
["CODIGO","NOMBRE","SALDO DE PERIODOS ANTERIORES","MORA","COSTO POR RECONEXIÓN","ABONO A ACOMETIDA","OTROS","ESPEC. OTROS"]

{"sheet":"BD_MEDICIÓN","index":16,"n_rows":8,"n_cols":15,"rows_kept":8,"merged":[[0,0,0,14],[1,8,1,9],[1,12,1,13],[2,8,2,13]]}
["DATOS DE MEDICIONES"]
[null,"PERIODO:",{"$nulls":6},{"$f":"PARAMETROS!C15","v":"00:00:00"},{"$nulls":3},"FECHA DE EMISIÓN:",null,{"$f":"TODAY()","v":"2021-10-19"}]
[{"$nulls":8},"RESUMEN"]
[{"$nulls":8},"METROS FACTURADOS",{"$nulls":4},{"$f":"SUM(K9:K1048576)","v":0}]
[{"$nulls":8},"MONTO POR CUOTA FIJA",{"$nulls":4},{"$f":"SUM(L9:L1048576)","v":0}]
[{"$nulls":8},"MONTO POR CONSUMO DE MTS ADICIONALES ",{"$nulls":4},{"$f":"SUM(M9:M1048576)","v":0}]
[]
["CODIGO ","NOMBRE DE USUARIO","CANTÓN","COMUNIDAD O CASERIO","DIRECCIÓN","DESDE","HASTA","MES","LECTURA ANTERIOR","LECTURA ACTUAL","CONSUMO (METROS)","CUOTA FIJA","MONTO POR MTS ADICIONAL","TOTAL CONSUMO DEL MES","TIPO SERV."]

{"sheet":"BD_RECIBOS","index":17,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,0,0,10],[1,3,1,4]]}
["DATOS DE RECIBOS EMITIDOS"]
[null,null,"PERIODO:",{"$f":"PARAMETROS!C15","v":"00:00:00"},{"$nulls":5},"FECHA DE EMISIÓN:",{"$f":"TODAY()","v":"2021-10-19"}]
[null,null,"RESUMEN TOTAL DE MONTOS FACTURADOS","CUOTA FIJA DEL MES","METROS ADICIONALES","SALDO  DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL GENERAL"]
[null,null,"TOTAL",{"$f":"SUM(D7:D1048576)","v":0},{"$f":"SUM(E7:E1048576)","v":0},0,0,0,0,0,{"$f":"SUM(D4:J4)","v":0}]
[]
["Nº RECIBO","CODIGO","NOMBRE","CUOTA FIJA DEL MES","METROS ADICIONALES","SALDO  DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","CONCEPTO OTROS"]

{"sheet":"ESTATUS","index":18,"n_rows":10000,"n_cols":12,"rows_kept":10000,"merged":[[0,0,0,11]]}
["ESTATUS DE PAGO DE USUARIOS"]
["Nº RECIBO","CODIGO","NOMBRE","CONSUM. DEL MES","METROS ADICIONALES","SALDOS DE MESES ANTERIORES","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL ADEUDADO","ESTADO"]
[{"$f":"IF(BD_RECIBOS!A6=\"\",\"\",BD_RECIBOS!A6)","v":"Nº RECIBO"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,2,FALSE),\"\")","v":"CODIGO"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,3,FALSE),\"\")","v":"NOMBRE"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,4,FALSE),\"\")","v":"CUOTA FIJA DEL MES"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,5,FALSE),\"\")","v":"METROS ADICIONALES"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,6,FALSE),\"\")","v":"SALDO  DE OTROS PERIODOS"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,7,FALSE),\"\")","v":"MORA"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,8,FALSE),\"\")","v":"RECONEXIÓN"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,9,FALSE),\"\")","v":"ABONO POR ACOMETIDA"},{"$f":"IFERROR(VLOOKUP(A3,BD_REC.EMITIDOS,10,FALSE),\"\")","v":"OTROS"},{"$f":"IF(A3=\"\",\"\",SUM(D3:J3))","v":0},{"$f":"IF(A3=\"\",\"\",IFERROR(VLOOKUP(A3,BD_COBROIMP,12,FALSE),\"NO CANCELADO\"))","v":"NO CANCELADO"}]
{"$rows_empty":9996}
["."]

{"sheet":"BD_FICHA","index":19,"n_rows":10000,"n_cols":5,"rows_kept":10000,"merged":[[0,0,0,4]]}
["DATOS PARA LAS FICHAS DE MEDICION"]
["Codigo de Usuario","Nombre del Usuario","Lectura del mes anterior","Lectura Actual","Consumo"]
[{"$f":"IF(BD_USUARIOS!A2=\"\",\"\",BD_USUARIOS!A2)","v":"CODIGO"},{"$f":"IFERROR(VLOOKUP(A3,T_USUARIOS,2,FALSE),\"\")","v":"NOMBRE"},{"$f":"IFERROR(VLOOKUP(A3,BD.MEDICION,10,FALSE),\"\")","v":""},null,{"$f":"IF(A3=\"\",\"\",\"SI\")","v":"SI"}]
{"$rows_empty":9996}
["."]

{"sheet":"REPORTE_FINAL","index":20,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,8],[5,3,5,4],[6,3,6,4],[18,0,18,1],[19,0,19,1],[20,0,20,1]]}
[{"$f":"PARAMETROS!C5","v":0}]
[{"$f":"PARAMETROS!C7","v":0}]
[]
["REPORTE DE OPERACIONES DEL MES"]
[]
[null,"PERIODO FACTURADO:",null,{"$f":"PARAMETROS!C15","v":"00:00:00"}]
[null,"PERIODO DE MEDICIÓN DESDE:",null,{"$f":"PARAMETROS!C13","v":"00:00:00"},null,"HASTA:",{"$f":"PARAMETROS!E13","v":"00:00:00"}]
[]
[{"$nulls":6},"FECHA DE EMISIÓN:",null,{"$f":"TODAY()","v":"2021-10-19"}]
[]
["EN CONCEPTO DE:","CUOTA DEL MES","MTS ADICIONALES","SALDOS DE OTROS PERIODOS","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","TOTAL"]
["MONTOS TOTALES FACTURADOS",{"$f":"BD_RECIBOS!D4","v":0},{"$f":"BD_RECIBOS!E4","v":0},{"$f":"BD_RECIBOS!F4","v":0},{"$f":"BD_RECIBOS!G4","v":0},{"$f":"BD_RECIBOS!H4","v":0},{"$f":"BD_RECIBOS!I4","v":0},{"$f":"BD_RECIBOS!J4","v":0},{"$f":"BD_RECIBOS!K4","v":0}]
["MONTOS NO CANCELADOS",{"$f":"REPORTE_IMPAGO!Z9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AA9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AB9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AC9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AD9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AE9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AF9","v":{"$error":"#REF!"}},{"$f":"REPORTE_IMPAGO!AG9","v":{"$error":"#REF!"}}]
["MONTOS TOTALES COBRADOS",{"$f":"REPORTE_COBROS!AB8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AC8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AD8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AE8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AF8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AG8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AH8","v":{"$error":"#REF!"}},{"$f":"REPORTE_COBROS!AI8","v":{"$error":"#REF!"}}]
[]
["PORCENTAJE DE NO CANCELADOS",{"$f":"IF(B12=0,0,B13/B12)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
["PORCENTAJE DE COBROS",{"$f":"IF(B12=0,0,B14/B12)","v":{"v":0,"d":"0.00%"}},{"$f":"IF(C12=0,0,C14/C12)","v":{"v":0,"d":"0.00%"}},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[null,null,{"$f":"BD_MEDICIÓN!N4","v":0}]
["TOTAL DE MTS FACURADOS:",null,{"$f":"CONCATENATE(C18,\" METROS\")","v":"0 METROS"}]
["PRECIO PROMEDIO DE METRO SERVIDO:",null,{"$f":"(B12+C12)/C18","v":{"$error":"#DIV/0!"}}]
[{"$f":"UPPER(CONCATENATE(\"CANTIDAD DE USUARIOS A \",TEXT(D6,\"MMMM\"),\" \",YEAR(D6),\":\"))","v":"CANTIDAD DE USUARIOS A ENERO 1900:"},null,{"$f":"CONCATENATE(D21,\" USUARIOS\")","v":"0 USUARIOS"},{"$f":"MAX(BD_USUARIOS!$G$3:$G$1048576)","v":0}]
[]
["F. ___________________________________",{"$nulls":5},"F. ___________________________________"]
["ELABORADO POR",{"$nulls":5},"AUTORIZA"]
["NOMBRE:",{"$nulls":5},"NOMBRE:"]
["CARGO:",{"$nulls":5},"CARGO:"]
[]
[]
[{"$nulls":3},"F. ___________________________________"]
[{"$nulls":3},"REVISA"]
[{"$nulls":3},"NOMBRE:"]
[{"$nulls":3},"CARGO:"]

{"sheet":"REC_TRANSITORIO","index":21,"n_rows":52,"n_cols":11,"rows_kept":52,"merged":[[0,0,0,5],[1,0,1,5],[1,6,2,6],[2,0,2,5],[6,0,6,3],[6,4,6,6],[7,4,8,6],[8,1,8,3],[9,0,9,6],[10,0,10,1],[10,3,10,6],[11,3,11,4],[11,5,11,6],[12,3,12,4],[12,5,12,6],[13,3,13,4],[13,5,13,6],[14,0,14,1],[14,5,14,6],[15,3,15,4],[15,5,15,6],[16,0,19,0],[16,1,19,2],[16,3,16,4],[16,5,16,6],[17,3,17,4],[17,5,17,6],[18,3,18,4],[18,5,18,6],[19,3,19,4],[19,5,19,6],[20,0,21,4],[24,0,24,5],[25,0,25,5],[25,6,26,6],[26,0,26,5],[30,0,30,3],[30,4,30,6],[31,4,32,6],[32,1,32,3],[33,0,33,6],[34,0,34,1],[34,3,34,6],[35,3,35,4],[35,5,35,6],[36,3,36,4],[36,5,36,6],[37,3,37,4],[37,5,37,6],[38,0,38,1],[38,5,38,6],[39,3,39,4],[39,5,39,6],[40,0,43,0],[40,1,43,2],[40,3,40,4],[40,5,40,6],[41,3,41,4],[41,5,41,6],[42,3,42,4],[42,5,42,6],[43,3,43,4],[43,5,43,6],[44,0,45,4]]}
[{"$f":"PARAMETROS!$C$5","v":0},{"$nulls":5},"RECIBO Nº:"]
[{"$f":"PARAMETROS!$C$7","v":0},{"$nulls":5},{"$f":"IF(MAX(MAXI_RECIBOS)<1,PARAMETROS!$C$3+1,MAX(MAXI_RECIBOS)+1)","v":1}]
[{"$f":"PARAMETROS!$C$9","v":0}]
["CODIGO:",{"$f":"F_MEDICIÓN!B5","v":0},null,null,"CANTÓN:",{"$f":"VLOOKUP(B4,BD.MEDICION,3,0)","v":{"$error":"#N/A"}}]
["USUARIO:",{"$f":"VLOOKUP(B4,BD.MEDICION,2,0)","v":{"$error":"#N/A"}},null,null,"COMUNIDAD:",{"$f":"VLOOKUP(B4,BD.MEDICION,4,0)","v":{"$error":"#N/A"}}]
["EMISIÓN:",{"$f":"TODAY()","v":"2021-10-19"},null,null,"DIRECCIÓN:",{"$f":"VLOOKUP(B4,BD.MEDICION,5,0)","v":{"$error":"#N/A"}}]
["PERIODO DE MEDICIÓN",{"$nulls":3},"FECHA DE VENCIMIENTO:"]
["DESDE:",{"$f":"PARAMETROS!$C$13","v":"00:00:00"},"HASTA:",{"$f":"PARAMETROS!$E$13","v":"00:00:00"},{"$f":"PARAMETROS!$C$17","v":"00:00:00"}]
["MES FACTURADO:",{"$f":"PARAMETROS!$C$15","v":"00:00:00"}]
[{"$f":"CONCATENATE(\"EFECTUAR EL PAGO EN \",PARAMETROS!$C$11,\".\")","v":"EFECTUAR EL PAGO EN ."}]
["INFORMACIÓN DE CONSUMO:",null,null,"DETALLE DE LA FACTURACIÓN"]
["LECT. ANTERIOR:",{"$f":"VLOOKUP(B4,BD.MEDICION,9,0)","v":{"$error":"#N/A"}},null,"CONCEPTO",null,"SUBTOTAL"]
["LECT. ACTUAL:",{"$f":"VLOOKUP(B4,BD.MEDICION,10,0)","v":{"$error":"#N/A"}},null,"CUOTA FIJA DEL MES",null,{"$f":"VLOOKUP(B4,BD.MEDICION,12,FALSE)","v":{"$error":"#N/A"}}]
["CONSUMO:",{"$f":"VLOOKUP(B4,BD.MEDICION,11,0)","v":{"$error":"#N/A"}},null,"METROS ADICIONALES",null,{"$f":"VLOOKUP(B4,BD.MEDICION,13,FALSE)","v":{"$error":"#N/A"}}]
["TIPO DE SERVICIO",null,null,"SALDOS DE MESES ANTERIORES",null,{"$f":"IFERROR(VLOOKUP(B4,BD_SALDOS.PC,3,FALSE),0)","v":0}]
["SERVICIO PARA:",{"$f":"VLOOKUP(B4,BD.MEDICION,15,FALSE)","v":{"$error":"#N/A"}},null,"MORA",null,{"$f":"IFERROR(VLOOKUP(B4,BD_SALDOS.PC,4,FALSE),0)","v":0}]
["SELLO",{"$f":"IF(F15>0,\"SERVICIO EN PROCESO DE SUSPENSIÓN\",\"\")","v":""},null,"RECONEXIÓN",null,{"$f":"IFERROR(VLOOKUP(B4,BD_SALDOS.PC,5,FALSE),0)","v":0}]
[{"$nulls":3},"ABONO POR ACOMETIDA",null,{"$f":"IFERROR(VLOOKUP(B4,BD_SALDOS.PC,6,FALSE),0)","v":0}]
[{"$nulls":3},"OTROS*",null,{"$f":"IFERROR(VLOOKUP(B4,BD_SALDOS.PC,7,FALSE),0)","v":0}]
[{"$nulls":3},"TOTAL",null,{"$f":"SUM(F13:G19)","v":{"$error":"#N/A"}}]
[{"$f":"IF(PARAMETROS!$C$19=\"\",\"\",CONCATENATE(\"AVISO: \",PARAMETROS!$C$19))","v":""},{"$nulls":4},{"$f":"IF(F19=0,\"\",CONCATENATE(\"*OTROS: \",IFERROR(VLOOKUP(B4,BD_SALDOS.PC,8,FALSE),\"\")))","v":""}]
[{"$nulls":6},"ORIGINAL - USUARIO"]
[]
[]
[{"$f":"PARAMETROS!$C$5","v":0},{"$nulls":5},"RECIBO Nº:"]
[{"$f":"PARAMETROS!$C$7","v":0},{"$nulls":5},{"$f":"IF(MAX(MAXI_RECIBOS)<1,PARAMETROS!$C$3+1,MAX(MAXI_RECIBOS)+1)","v":1}]
[{"$f":"PARAMETROS!$C$9","v":0}]
["CODIGO:",{"$f":"B4","v":0},null,null,"CANTÓN:",{"$f":"VLOOKUP(B28,BD.MEDICION,3,0)","v":{"$error":"#N/A"}}]
["USUARIO:",{"$f":"VLOOKUP(B28,BD.MEDICION,2,0)","v":{"$error":"#N/A"}},null,null,"COMUNIDAD:",{"$f":"VLOOKUP(B28,BD.MEDICION,4,0)","v":{"$error":"#N/A"}}]
["EMISIÓN:",{"$f":"TODAY()","v":"2021-10-19"},null,null,"DIRECCIÓN:",{"$f":"VLOOKUP(B28,BD.MEDICION,5,0)","v":{"$error":"#N/A"}}]
["PERIODO DE MEDICIÓN",{"$nulls":3},"FECHA DE VENCIMIENTO:"]
["DESDE:",{"$f":"PARAMETROS!$C$13","v":"00:00:00"},"HASTA:",{"$f":"PARAMETROS!$E$13","v":"00:00:00"},{"$f":"PARAMETROS!$C$17","v":"00:00:00"}]
["MES FACTURADO:",{"$f":"PARAMETROS!$C$15","v":"00:00:00"}]
[{"$f":"CONCATENATE(\"EFECTUAR EL PAGO EN \",PARAMETROS!$C$11,\".\")","v":"EFECTUAR EL PAGO EN ."}]
["INFORMACIÓN DE CONSUMO:",null,null,"DETALLE DE LA FACTURACIÓN"]
["LECT. ANTERIOR:",{"$f":"VLOOKUP(B28,BD.MEDICION,9,0)","v":{"$error":"#N/A"}},null,"CONCEPTO",null,"SUBTOTAL"]
["LECT. ACTUAL:",{"$f":"VLOOKUP(B28,BD.MEDICION,10,0)","v":{"$error":"#N/A"}},null,"CUOTA FIJA DEL MES",null,{"$f":"VLOOKUP(B28,BD.MEDICION,12,FALSE)","v":{"$error":"#N/A"}}]
["CONSUMO:",{"$f":"VLOOKUP(B28,BD.MEDICION,11,0)","v":{"$error":"#N/A"}},null,"METROS ADICIONALES",null,{"$f":"VLOOKUP(B28,BD.MEDICION,13,FALSE)","v":{"$error":"#N/A"}}]
["TIPO DE SERVICIO",null,null,"SALDOS DE MESES ANTERIORES",null,{"$f":"IFERROR(VLOOKUP(B28,BD_SALDOS.PC,3,FALSE),0)","v":0}]
["SERVICIO PARA:",{"$f":"VLOOKUP(B28,BD.MEDICION,15,FALSE)","v":{"$error":"#N/A"}},null,"MORA",null,{"$f":"IFERROR(VLOOKUP(B28,BD_SALDOS.PC,4,FALSE),0)","v":0}]
["SELLO",{"$f":"IF(F39>0,\"SERVICIO EN PROCESO DE SUSPENSIÓN\",\"\")","v":""},null,"RECONEXIÓN",null,{"$f":"IFERROR(VLOOKUP(B28,BD_SALDOS.PC,5,FALSE),0)","v":0}]
[{"$nulls":3},"ABONO POR ACOMETIDA",null,{"$f":"IFERROR(VLOOKUP(B28,BD_SALDOS.PC,6,FALSE),0)","v":0}]
[{"$nulls":3},"OTROS*",null,{"$f":"IFERROR(VLOOKUP(B28,BD_SALDOS.PC,7,FALSE),0)","v":0}]
[{"$nulls":3},"TOTAL",null,{"$f":"SUM(F37:G43)","v":{"$error":"#N/A"}}]
[{"$f":"IF(PARAMETROS!$C$19=\"\",\"\",CONCATENATE(\"AVISO: \",PARAMETROS!$C$19))","v":""},{"$nulls":4},{"$f":"IF(F43=0,\"\",CONCATENATE(\"*OTROS: \",IFERROR(VLOOKUP(B28,BD_SALDOS.PC,8,FALSE),\"\")))","v":""}]
[{"$nulls":6},"COPIA- ADMINISTRACIÓN"]
[]
[]
[]
[]
["Nº RECIBO","CODIGO","NOMBRE","CONSUMO DEL MES","METROS ADICIONALES","SALDOS PENDIENTES","MORA","RECONEXIÓN","ABONO POR ACOMETIDA","OTROS","CONCEPTO OTROS"]
[{"$f":"G2","v":1},{"$f":"B4","v":0},{"$f":"B5","v":{"$error":"#N/A"}},{"$f":"F13","v":{"$error":"#N/A"}},{"$f":"F14","v":{"$error":"#N/A"}},{"$f":"F15","v":0},{"$f":"F16","v":0},{"$f":"F17","v":0},{"$f":"F18","v":0},{"$f":"F43","v":0},{"$f":"(MID(F45,9,25))","v":""}]

{"sheet":"BD_USUARIOS","index":22,"n_rows":2,"n_cols":17,"rows_kept":2}
[null,"                 DATOS DE LOS USUARIOS DEL SERVICIO DE AGUA",{"$nulls":7},{"$f":"UPPER(CONCATENATE(\"USUARIOS A \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"USUARIOS A ENERO 1900"},{"$f":"UPPER(CONCATENATE(\"RECIBOS DE \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"RECIBOS DE ENERO 1900"},{"$f":"UPPER(CONCATENATE(\"MEDICIONES DE \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"MEDICIONES DE ENERO 1900"},{"$f":"UPPER(CONCATENATE(\"MONTOS FACTURADOS DE \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"MONTOS FACTURADOS DE ENERO 1900"},{"$f":"UPPER(CONCATENATE(\"REPORTE DE COBROS DE \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"REPORTE DE COBROS DE ENERO 1900"},{"$f":"UPPER(CONCATENATE(\"REPORTE DE RECIBOS NO CANCELADOS DE \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"REPORTE DE RECIBOS NO CANCELADOS DE ENERO 1900"},"FICHA DE MEDICIÓN PARA EL PROXIMO PERIODO",{"$f":"UPPER(CONCATENATE(\"REPORTE GENERAL DE \",TEXT(PARAMETROS!C15,\"MMMM\"),\" \",YEAR(PARAMETROS!C15)))","v":"REPORTE GENERAL DE ENERO 1900"}]
["CODIGO","NOMBRE","CANTON","COMUNIDAD","DIRECIÓN","TIPO SERV.","CORRELATIVO",null,"USUARIO"]