{"text_format":"1","workbook":"xlsx","n_sheets":85,"sheets":["INDICE","A-OSE-ACT","B-OSE-ACT","C-OSE-ACT","A-MDEO-600","B-MDEO-600","C-MDEO-600","A-400-AG-CENTRO","B-400-AG-CENTRO","C-400-AG-CENTRO","A-CAN-401","B-CAN-401","C-CAN-401","A-LP-402","B-LP-402","C-LP-402","A-SAT-403","B-SAT-403","C-SAT-403","A-CC-404","B-CC-404","C-CC-404","A-FDA-405","B-FDA-405","C-FDA-405","A-DUR-406","B-DUR-406","C-DUR-406","A-300-AG-LITORAL SUR","B-300-AG-LITORAL SUR","C-300-AG-LITORAL SUR","A-SJ-301","B-SJ-301","C-SJ-301","A-COL-302","B-COL-302","C-COL-302","A-FLO-303","B-FLO-303","C-FLO-303","A-SOR-304","B-SOR-304","C-SOR-304","A-100-AG-LITORAL NORTE","B-100-AG-LITORAL NORTE","C-100-AG-LITORAL NORTE","A-PAY-101","B-PAY-101","C-PAY-101","A-RN-102","B-RN-102","C-RN-102","A-SAL-103","B-SAL-103","C-SAL-103","A-ART-104","B-ART-104","C-ART-104","A-200-AG-NORESTE","B-200-AG-NORESTE","C-200-AG-NORESTE","A-RIV-201","B-RIV-201","C-RIV-201","A-TAC-202","B-TAC-202","C-TAC-202","A-CL-204","B-CL-204","C-CL-204","A-500-AG-SURESTE","B-500-AG-SURESTE","C-500-AG-SURESTE","A-ROC-502","B-ROC-502","C-ROC-502","A-TT-203","B-TT-203","C-TT-203","A-LAV-503","B-LAV-503","C-LAV-503","A-UGD-501","B-UGD-501","C-UGD-501"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":6,"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":"INDICE","index":0,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["ESTADO DE RENDIMIENTO ECONOMICO -2014"]
[]
[null,"EMPRESA"]
[]
[null,"MONTEVIDEO"]
[]
[null,"AMBITO GEOGRAFICO CENTRO"]
[null,"CANELONES"]
[null,"LAS PIEDRAS"]
[null,"SISTEMA ATLANTIDA"]
[null,"CIUDAD DE LA COSTA"]
[null,"FLORIDA"]
[null,"DURAZNO"]
[]
[null,"AMBITO GEOGRAFICO LITORAL SUR"]
[null,"SAN JOSE"]
[null,"COLONIA"]
[null,"FLORES"]
[null,"SORIANO"]
[]
[null,"AMBITO GEOGRAFICO LITORAL NORTE"]
[null,"PAYSANDU"]
[null,"RIO NEGRO"]
[null,"SALTO"]
[null,"ARTIGAS"]
[]
[null,"AMBITO GEOGRAFICO NORESTE"]
[null,"RIVERA "]
[null,"TACUAREMBO"]
[null,"CERRO LARGO"]
[]
[null,"AMBITO GEOGRAFICO SURESTE"]
[null,"TREINTA Y TRES"]
[null,"ROCHA"]
[null,"LAVALLEJA"]
[]
[null,"U.G.D."]

{"sheet":"A-OSE-ACT","index":1,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["EMPRESA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",4176678291,184343367,596633017,4957654675,null,null,4957654675]
["       Ingresos Fijos",1773423626,119976260,368210240,2261610126,null,null,2261610126]
["    INGRESOS DE EXPLOTACION",5950101917,304319627,964843257,7219264801,null,null,7219264801]
["       Ingresos Alcantarillado",null,null,null,null,976450489,null,976450489]
["       Ingresos Upas",null,null,null,null,null,3462490,3462490]
["       Otros Ingresos",244160896,18001360,65402385,327564641,1215740,10466291,339246672]
["   TOTAL ING. DE EXPLOTACION",6194262813,322320987,1030245642,7546829442,977666229,13928781,8538424452]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",1028705589,58208085,207335647,1294249321,161331613,0,1455580934]
["       Costo Operativo Fijo",1585661303,215926441,509365850,2310953594,605573891,0,2916527485]
["    TOTAL OPERATIVO",2614366892,274134526,716701497,3605202915,766905504,0,4372108419]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",1146801116,104699859,347944587,1599445562,192292328,0,1791737890]
["       Comercial Asignados",472790125,27718783,88598496,589107404,66211769,0,655319173]
["       Comercialización Upas",0,0,0,0,0,5858215,5858215]
["    TOTAL COMERCIALIZACION",1619591241,132418642,436543083,2188552966,258504097,5858215,2452915278]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",323614235,39535765,97402624,460552624,63653670,0,524206294]
["       Administ. Asignados",790464564,44334948,141709319,976508831,116119998,0,1092628829]
["       Gastos Fiscales",329384137,16619574,53121715,399125426,53391384,0,452516810]
["    TOTAL ADMINISTRACION",1443462936,100490287,292233658,1836186881,233165052,0,2069351933]
["    TOTAL NO OPERATIVO",3063054177,232908929,728776741,4024739847,491669149,5858215,4522267211]
["  COSTO DE EXPLOTACION",5677421069,507043455,1445478238,7629942762,1258574653,5858215,8894375630]
["  RESULTADO DE EXPLOTACION",516841744,-184722468,-415232596,-83113320,-280908424,8070566,-355951178]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",89464310,5156133,16480721,111101164,12769133,0,123870297]
["       Gtos. Div. y Extraor",13820037,795226,2541810,17157073,1975942,0,19133015]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",75644273,4360907,13938911,93944091,10793191,0,104737282]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",225003774,11028169,35249714,271281657,37348148,0,308629805]
["       Gastos Financieros",880541177,51596292,164919000,1097056469,123391134,0,1220447603]
["   RESULTADO FINANCIERO",-655537403,-40568123,-129669286,-825774812,-86042986,0,-911817798]
["    I.R.A.E.",-728363365,-37900684,-121143258,-887407307,-114960616,null,-1002367923]
[" RESULTADO NETO",665311979,-183029000,-409819713,72463266,-241197603,8070566,-160663771]

{"sheet":"B-OSE-ACT","index":2,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[57,0,57,1]]}
["   "]
[]
["E    M    P    R    E    S   A "]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",962373813.39109993,161546032.64637744,1123919846.0374775]
[]
[null,"MATERIALES Y SUMINISTROS",560750206.3819952,30992780.42323108,591742986.80522633]
[]
[null,"ENERGIA Y FLUÍDOS",699755653.39646637,90236587.028644085,789992240.42511046]
[]
[null,"SERVICIOS CONTRATADOS",320859406.24175549,182777841.01085034,503637247.2526058]
[]
[null,"GASTOS VARIOS",170766175.36215177,15227414.206684276,185993589.56883603]
[]
[null,"AMORTIZACIÓN",890697660.22653162,286124848.68421268,1176822508.9107442]
[]
[]
[null,"TOTAL",3605202915,766905504,4372108419]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","COMERC. UPAS","ADM.ASIGNADOS","COM.ASIGNADOS"]
[]
[null,"RETRIBUCIONES AL PERSONAL",741905041.82737696,226297509.27318588,3275728.4599999995,806123906.81878722,255787582.89317283]
[]
[null,"MATERIALES Y SUMINISTROS",93637614.510468274,10709637.182373581,1424918.6216046331,25920320.345081169,15550432.799116241]
[]
[null,"ENERGIA Y FLUÍDOS",6316162.3588344529,87795969.701426536,24278.31687937224,12750259.250329372,1900256.8093283968]
[]
[null,"SERVICIOS CONTRATADOS",571065042.95441568,95441474.615918025,476956.98401325999,260800920.24259382,330952335.36781931]
[]
[null,"GASTOS VARIOS",215045685.95934635,39288250.226799145,494668.59136750625,-95870576.596596569,39193150.595812276]
[]
[null,"AMORTIZACIÓN",163768342.38955829,64673453.000296839,161664.02613522857,82903998.93980509,11935414.534750946]
[]
[]
[]
[null,"TOTAL",1791737890,524206294,5858215,1092628829.0000002,655319173]
[]
[]
[null,"FISCALES",null,null,452516810]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,8894375630]

{"sheet":"C-OSE-ACT","index":3,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["E M P R E S A "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",882.3,573.32791274546685,887.65]
[]
[null,"MATERIALES Y SUMINISTROS",514.1,109.99357780036512,95.67]
[]
[null,"ENERGIA Y FLUÍDOS",641.54,320.25022989982602,86.28]
[]
[null,"SERVICIOS CONTRATADOS",294.16000000000003,648.67973769595073,611.04999999999995]
[]
[null,"GASTOS VARIOS",156.56,54.042191322268515,233.17]
[]
[null,"AMORTIZACIÓN",816.59,1015.4589351000737,209.44]
[]
[]
[]
[null,"TOTAL",3305.25,2721.7525845639511,2123.2599999999998]
[]
[]
[null,"2.CONEXIONES (promedio anual)",1090751,281769]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.01,1.29,0]
[]
[null,"3.2 FINANCIERO",3.95]
[]
[null,"3.3 TOTAL",0.99,1.23]
[]
[]
[null,"4.M3 ELEVADOS",346481580]
[]
[null,"5.M3 FACTURADOS",164745130]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.74]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.86]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",46.31]
[]
[null,"6.4 TOTAL/M3FACT",47.69]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",30.09]
[]
[null,"7.2 FIJO/CONEXIONES",172.79]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT7",45.81]
[]
[null,"7.4 TOTAL/M3FACT",48.13]

{"sheet":"A-MDEO-600","index":4,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["MONTEVIDEO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",2542338741,0,0,2542338741,null,null,2542338741]
["       Ingresos Fijos",904507606,0,0,904507606,null,null,904507606]
["    INGRESOS DE EXPLOTACION",3446846347,0,0,3446846347,null,null,3446846347]
["       Ingresos Alcantarillado",null,null,null,null,0,null,0]
["       Ingresos Upas",null,null,null,null,null,3462490,3462490]
["       Otros Ingresos",95452974,0,0,95452974,0,10464570,105917544]
["   TOTAL ING. DE EXPLOTACION",3542299321,0,0,3542299321,0,13927060,3556226381]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",675118280,0,0,675118280,0,0,675118280]
["       Costo Operativo Fijo",756459430,0,0,756459430,0,0,756459430]
["    TOTAL OPERATIVO",1431577710,0,0,1431577710,0,0,1431577710]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",533283340,0,0,533283340,0,0,533283340]
["       Comercial Asignados",304628702,0,0,304628702,0,0,304628702]
["       Comercialización Upas",0,0,0,0,0,5858215,5858215]
["    TOTAL COMERCIALIZACION",837912042,0,0,837912042,0,5858215,843770257]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",108171645,0,0,108171645,0,0,108171645]
["       Administ. Asignados",487239942,0,0,487239942,0,0,487239942]
["       Gastos Fiscales",182648689,0,0,182648689,0,0,182648689]
["    TOTAL ADMINISTRACION",778060276,0,0,778060276,0,0,778060276]
["    TOTAL NO OPERATIVO",1615972318,0,0,1615972318,0,5858215,1621830533]
["  COSTO DE EXPLOTACION",3047550028,0,0,3047550028,0,5858215,3053408243]
["  RESULTADO DE EXPLOTACION",494749293,0,0,494749293,0,8068845,502818138]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",56665764,0,0,56665764,0,0,56665764]
["       Gtos. Div. y Extraor",8739518,0,0,8739518,0,0,8739518]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",47926246,0,0,47926246,0,0,47926246]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",121199288,0,0,121199288,0,0,121199288]
["       Gastos Financieros",567041916,0,0,567041916,0,0,567041916]
["   RESULTADO FINANCIERO",-445842628,0,0,-445842628,0,0,-445842628]
["    I.R.A.E.",-416527540,0,0,-416527540,0,null,-416527540]
[" RESULTADO NETO",513360451,0,0,513360451,0,8068845,521429296]

{"sheet":"B-MDEO-600","index":5,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["M O N T E V I D E O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",287564612.78154635,0,287564612.78154635]
[]
[null,"MATERIALES Y SUMINISTROS",341865378.81899476,0,341865378.81899476]
[]
[null,"ENERGIA Y FLUÍDOS",390899461.18737137,0,390899461.18737137]
[]
[null,"SERVICIOS CONTRATADOS",126497586.31620373,0,126497586.31620373]
[]
[null,"GASTOS VARIOS",67629266.657520384,0,67629266.657520384]
[]
[null,"AMORTIZACIÓN",217121404.23836359,0,217121404.23836359]
[]
[]
[null,"TOTAL",1431577710,0,1431577710,null,0.69057169887038372]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",161146166.76000002,42349655.649999999,203495822.41000003]
[]
[null,"MATERIALES Y SUMINISTROS",28869879.439999998,2719282.4600000004,31589161.899999999]
[]
[null,"ENERGIA Y FLUÍDOS",2216766.8199999998,35820801.950000003,38037568.770000003]
[]
[null,"SERVICIOS CONTRATADOS",157122609.23000002,20372099.030000001,177494708.26000002]
[]
[null,"GASTOS VARIOS",77658522.589999989,4674147.16,82332669.749999985]
[]
[null,"AMORTIZACIÓN",106269395.16000003,2235658.7499999953,108505053.91000003]
[]
[]
[]
[null,"TOTAL",533283340,108171645,641454985,null,0.30942830112961628]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,2073032695]

{"sheet":"C-MDEO-600","index":6,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["M O N T E V I D E O"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",816.74,null,577.97]
[]
[null,"MATERIALES Y SUMINISTROS",970.97,null,89.72]
[]
[null,"ENERGIA Y FLUÍDOS",1110.24,null,108.03]
[]
[null,"SERVICIOS CONTRATADOS",359.28,null,504.12]
[]
[null,"GASTOS VARIOS",192.08,null,233.84]
[]
[null,"AMORTIZACIÓN",616.66999999999996,null,308.18]
[]
[]
[]
[null,"TOTAL",4065.9799999999996,null,1821.8600000000001]
[]
[]
[null,"2.CONEXIONES (promedio anual)",352087]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",0.86,null,0]
[]
[null,"3.3 TOTAL",0.86]
[]
[]
[null,"4.M3 ELEVADOS",176838800]
[]
[null,"5.M3 FACTURADOS",78995569.999999985]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.82]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.5500000000000007]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",38.58]
[]
[null,"6.4 TOTAL/M3FACT",40.590000000000003]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",32.18]
[]
[null,"7.2 FIJO/CONEXIONES",214.08]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",44.84]
[]
[null,"7.4 TOTAL/M3FACT",47.09]

{"sheet":"A-400-AG-CENTRO","index":7,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["AMBITO GEOGRAFICO CENTRO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",601717054,5969765,128980583,736667402,null,null,736667402]
["       Ingresos Fijos",298204970,3994848,110472216,412672034,null,null,412672034]
["    INGRESOS DE EXPLOTACION",899922024,9964613,239452799,1149339436,null,null,1149339436]
["       Ingresos Alcantarillado",null,null,null,null,172008074,null,172008074]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",57470010,457597,19124252,77051859,814463,0,77866322]
["   TOTAL ING. DE EXPLOTACION",957392034,10422210,258577051,1226391295,172822537,0,1399213832]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",73223074,2070505,35818359,111111938,36200965,0,147312903]
["       Costo Operativo Fijo",272279724,18025294,116917659,407222677,190530292,0,597752969]
["    TOTAL OPERATIVO",345502798,20095799,152736018,518334615,226731257,0,745065872]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",289835962,5906994,99836831,395579787,44693654,0,440273441]
["       Comercial Asignados",82333272,896283,22236967,105466522,14862297,0,120328819]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",372169234,6803277,122073798,501046309,59555951,0,560602260]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",81512546,1316820,21070736,103900102,11625261,0,115525363]
["       Administ. Asignados",131688375,1433565,35567030,168688970,23771578,0,192460548]
["       Gastos Fiscales",49365224,537392,13332797,63235413,8911107,0,72146520]
["    TOTAL ADMINISTRACION",262566145,3287777,69970563,335824485,44307946,0,380132431]
["    TOTAL NO OPERATIVO",634735379,10091054,192044361,836870794,103863897,0,940734691]
["  COSTO DE EXPLOTACION",980238177,30186853,344780379,1355205409,330595154,0,1685800563]
["  RESULTADO DE EXPLOTACION",-22846143,-19764643,-86203328,-128814114,-157772617,0,-286586731]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",15315294,166723,4136426,19618443,2764623,0,22383066]
["       Gtos. Div. y Extraor",2362066,25714,637958,3025738,426386,0,3452124]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",12953228,141009,3498468,16592705,2338237,0,18930942]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",32757038,356594,8847179,41960811,5913100,0,47873911]
["       Gastos Financieros",153256787,1668360,41392331,196317478,27664975,0,223982453]
["   RESULTADO FINANCIERO",-120499749,-1311766,-32545152,-154356667,-21751875,0,-176108542]
["    I.R.A.E.",-112576638,-1225514,-30405240,-144207392,-20321644,null,-164529036]
[" RESULTADO NETO",-17816026,-19709886,-84844772,-122370684,-156864611,0,-279235295]

{"sheet":"B-400-AG-CENTRO","index":8,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["AMBITO GEOGRAFICO CENTRO"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",159734948.97207922,56955483.15187192,216690432.12395114]
[]
[null,"MATERIALES Y SUMINISTROS",42564772.238472924,8707417.945813721,51272190.184286647]
[]
[null,"ENERGIA Y FLUÍDOS",52356898.181982122,19213251.656849291,71570149.83883141]
[]
[null,"SERVICIOS CONTRATADOS",43346813.020673946,48314383.250809424,91661196.271483362]
[]
[null,"GASTOS VARIOS",23401897.413963888,7389797.7338006767,30791695.147764564]
[]
[null,"AMORTIZACIÓN",196929285.66282785,86150923.120854974,283080208.78368282]
[]
[]
[null,"TOTAL",518334615.49000001,226731256.86000001,745065872.3499999,null,0.57274663965360295]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",191691589.36767387,53564262.786695272,245255852.15436915]
[]
[null,"MATERIALES Y SUMINISTROS",25775442.681177087,1529665.5824882775,27305108.263665363]
[]
[null,"ENERGIA Y FLUÍDOS",1052849.265851602,14855725.033605779,15908574.299457381]
[]
[null,"SERVICIOS CONTRATADOS",136289398.87737319,27016939.771175355,163306338.64854854]
[]
[null,"GASTOS VARIOS",64802014.872047402,7927890.6070910431,72729905.479138449]
[]
[null,"AMORTIZACIÓN",20662145.935876887,10630879.788944267,31293025.724821154]
[]
[]
[]
[null,"TOTAL",440273441.00000006,115525363.56999999,555798804.57000005,null,0.42725336034639694]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,1300864676.9200001]

{"sheet":"C-400-AG-CENTRO","index":9,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["A M B I T O   G E O G R A F I C O  C E N T R O "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",688.49,1113.1727382365273,1057.0999999999999]
[]
[null,"MATERIALES Y SUMINISTROS",183.46,170.18309285280409,117.69]
[]
[null,"ENERGIA Y FLUÍDOS",225.67,375.5155214863538,68.569999999999993]
[]
[null,"SERVICIOS CONTRATADOS",186.83,944.28580574239072,703.88]
[]
[null,"GASTOS VARIOS",100.87,144.43071892505964,313.48]
[]
[null,"AMORTIZACIÓN",848.8,1683.7862429562197,134.88]
[]
[]
[]
[null,"TOTAL",2234.12,4431.3741201993544,2395.6]
[]
[]
[null,"2.CONEXIONES (promedio anual)",232008,51165]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.1100000000000001,1.91,0]
[]
[null,"3.3 TOTAL",1.1000000000000001,1.86]
[]
[]
[null,"4.M3 ELEVADOS",56546970]
[]
[null,"5.M3 FACTURADOS",26631320]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",1.96]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",4.17]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",50.89]
[]
[null,"6.4 TOTAL/M3FACT",52.96]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",27.66]
[]
[null,"7.2 FIJO/CONEXIONES",148.22]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",46.05]
[]
[null,"7.4 TOTAL/M3FACT",48.36]

{"sheet":"A-CAN-401","index":10,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["CANELONES","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",80380067,0,29741286,110121353,null,null,110121353]
["       Ingresos Fijos",35400585,0,18465215,53865800,null,null,53865800]
["    INGRESOS DE EXPLOTACION",115780652,0,48206501,163987153,null,null,163987153]
["       Ingresos Alcantarillado",null,null,null,null,36626087,null,36626087]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",5141891,0,3506199,8648090,16939,0,8665029]
["   TOTAL ING. DE EXPLOTACION",120922543,0,51712700,172635243,36643026,0,209278269]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",23406963,0,7784789,31191752,14102342,0,45294094]
["       Costo Operativo Fijo",95151655,0,37410379,132562034,68574766,0,201136800]
["    TOTAL OPERATIVO",118558618,0,45195168,163753786,82677108,0,246430894]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",43103378,0,23035701,66139079,10885419,0,77024498]
["       Comercial Asignados",10399030,0,4447160,14846190,3151207,0,17997397]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",53502408,0,27482861,80985269,14036626,0,95021895]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",14966820,0,7998705,22965525,3779753,0,26745278]
["       Administ. Asignados",16632782,0,7113033,23745815,5040214,0,28786029]
["       Gastos Fiscales",6235030,0,2666420,8901450,1889395,0,10790845]
["    TOTAL ADMINISTRACION",37834632,0,17778158,55612790,10709362,0,66322152]
["    TOTAL NO OPERATIVO",91337040,0,45261019,136598059,24745988,0,161344047]
["  COSTO DE EXPLOTACION",209895658,0,90456187,300351845,107423096,0,407774941]
["  RESULTADO DE EXPLOTACION",-88973115,0,-38743487,-127716602,-70780070,0,-198496672]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1934384,0,827242,2761626,586174,0,3347800]
["       Gtos. Div. y Extraor",298339,0,127585,425924,90405,0,516329]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1636045,0,699657,2335702,495769,0,2831471]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",4137348,0,1769343,5906691,1253736,0,7160427]
["       Gastos Financieros",19356961,0,8278032,27634993,5865719,0,33500712]
["   RESULTADO FINANCIERO",-15219613,0,-6508689,-21728302,-4611983,0,-26340285]
["    I.R.A.E.",-14218892,0,-6080729,-20299621,-4308735,null,-24608356]
[" RESULTADO NETO",-88337791,0,-38471790,-126809581,-70587549,0,-197397130]

{"sheet":"B-CAN-401","index":11,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["C A N E L O N E S"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",47836993.744438119,18660782.205729883,66497775.950167999]
[]
[null,"MATERIALES Y SUMINISTROS",10420770.318695748,4242403.5347816478,14663173.853477396]
[]
[null,"ENERGIA Y FLUÍDOS",15716198.847829178,6938058.2135623731,22654257.061391551]
[]
[null,"SERVICIOS CONTRATADOS",17783455.30445531,19049349.318173274,36832804.622628585]
[]
[null,"GASTOS VARIOS",6925952.7510513831,4208268.0157721201,11134220.766823504]
[]
[null,"AMORTIZACIÓN",65070415.03353025,29578246.711980697,94648661.745510951]
[]
[]
[null,"TOTAL",163753786,82677108,246430894,null,0.70368481590854748]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",36709765.818884984,13433397.46670712,50143163.285592102]
[]
[null,"MATERIALES Y SUMINISTROS",3109186.2250113469,624749.17713666381,3733935.4021480107]
[]
[null,"ENERGIA Y FLUÍDOS",218663.5288451009,4045945.062807485,4264608.5916525861]
[]
[null,"SERVICIOS CONTRATADOS",20649497.181961831,4006894.4667437458,24656391.648705576]
[]
[null,"GASTOS VARIOS",11580145.030509358,2503499.6551973512,14083644.685706709]
[]
[null,"AMORTIZACIÓN",4757240.2147873752,2130792.1714076358,6888032.3861950114]
[]
[]
[]
[null,"TOTAL",77024498,26745278,103769776,null,0.29631518409145247]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,350200670]

{"sheet":"C-CAN-401","index":12,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["C A N E L O N E S "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1447.54,1715.4607653732196,1517.33]
[]
[null,"MATERIALES Y SUMINISTROS",315.33,389.99848637448503,112.99]
[]
[null,"ENERGIA Y FLUÍDOS",475.57,637.80641786747321,129.05000000000001]
[]
[null,"SERVICIOS CONTRATADOS",538.13,1751.181220644721,746.1]
[]
[null,"GASTOS VARIOS",209.58,386.86045373893364,426.17]
[]
[null,"AMORTIZACIÓN",1969.03,2719.0886846829103,208.43]
[]
[]
[]
[null,"TOTAL",4955.18,7600.3960286817419,3140.0699999999997]
[]
[]
[null,"2.CONEXIONES (promedio anual)",33047,10878]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.74,2.93,0]
[]
[null,"3.3 TOTAL",1.7,2.83]
[]
[]
[null,"4.M3 ELEVADOS",6360120]
[]
[null,"5.M3 FACTURADOS",3741370]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",4.9000000000000004]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.34]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",80.28]
[]
[null,"6.4 TOTAL/M3FACT",82.35]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",29.43]
[]
[null,"7.2 FIJO/CONEXIONES",135.83000000000001]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",46.14]
[]
[null,"7.4 TOTAL/M3FACT",48.46]

{"sheet":"A-LP-402","index":13,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["LAS PIEDRAS","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",147233749,0,0,147233749,null,null,147233749]
["       Ingresos Fijos",75146631,0,0,75146631,null,null,75146631]
["    INGRESOS DE EXPLOTACION",222380380,0,0,222380380,null,null,222380380]
["       Ingresos Alcantarillado",null,null,null,null,29857113,null,29857113]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",15317895,0,0,15317895,63054,0,15380949]
["   TOTAL ING. DE EXPLOTACION",237698275,0,0,237698275,29920167,0,267618442]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",2845525,0,0,2845525,927613,0,3773138]
["       Costo Operativo Fijo",30749556,0,0,30749556,14729084,0,45478640]
["    TOTAL OPERATIVO",33595081,0,0,33595081,15656697,0,49251778]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",80428887,0,0,80428887,5525302,0,85954189]
["       Comercial Asignados",20441445,0,0,20441445,2573058,0,23014503]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",100870332,0,0,100870332,8098360,0,108968692]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",18882685,0,0,18882685,1297202,0,20179887]
["       Administ. Asignados",32695175,0,0,32695175,4115491,0,36810666]
["       Gastos Fiscales",12256242,0,0,12256242,1542749,0,13798991]
["    TOTAL ADMINISTRACION",63834102,0,0,63834102,6955442,0,70789544]
["    TOTAL NO OPERATIVO",164704434,0,0,164704434,15053802,0,179758236]
["  COSTO DE EXPLOTACION",198299515,0,0,198299515,30710499,0,229010014]
["  RESULTADO DE EXPLOTACION",39398760,0,0,39398760,-790332,0,38608428]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",3802433,0,0,3802433,478630,0,4281063]
["       Gtos. Div. y Extraor",586446,0,0,586446,73819,0,660265]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",3215987,0,0,3215987,404811,0,3620798]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",8132814,0,0,8132814,1023714,0,9156528]
["       Gastos Financieros",38050112,0,0,38050112,4789541,0,42839653]
["   RESULTADO FINANCIERO",-29917298,0,0,-29917298,-3765827,0,-33683125]
["    I.R.A.E.",-27950173,0,0,-27950173,-3518216,null,-31468389]
[" RESULTADO NETO",40647622,0,0,40647622,-633132,0,40014490]

{"sheet":"B-LP-402","index":14,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["L A S   P I E D R A S"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",6141179.0361216217,5333213.7460671142,11474392.782188736]
[]
[null,"MATERIALES Y SUMINISTROS",231775.8884116236,229849.76388364061,461625.65229526418]
[]
[null,"ENERGIA Y FLUÍDOS",2579017.6538145454,178116.5779464638,2757134.231761009]
[]
[null,"SERVICIOS CONTRATADOS",3137847.2712840606,4665099.3025783822,7802946.5738624427]
[]
[null,"GASTOS VARIOS",1440815.2405604084,674054.07560562785,2114869.3161660363]
[]
[null,"AMORTIZACIÓN",20064445.909807742,4576363.5339187719,24640809.443726514]
[]
[]
[null,"TOTAL",33595081,15656697,49251778,null,0.31696436150487678]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",35142503.250611871,12391757.834487788,47534261.08509966]
[]
[null,"MATERIALES Y SUMINISTROS",2860597.4111322137,77277.577479413711,2937874.9886116274]
[]
[null,"ENERGIA Y FLUÍDOS",232269.04590469255,1771419.7114642202,2003688.7573689127]
[]
[null,"SERVICIOS CONTRATADOS",27640755.680236228,4026869.1850812249,31667624.865317453]
[]
[null,"GASTOS VARIOS",16825312.739422239,564376.64850811579,17389689.387930356]
[]
[null,"AMORTIZACIÓN",3252750.8726927526,1348186.0429792313,4600936.9156719837]
[]
[]
[]
[null,"TOTAL",85954189,20179887,106134076.00000001,null,0.68303563849512339]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,155385854]
[]
[]
[null,null,null,null,null,null,0]

{"sheet":"C-LP-402","index":15,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["L A S     P I E D R A S "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",123.76,782.34028840650058,957.91]
[]
[null,"MATERIALES Y SUMINISTROS",4.67,33.717143007721958,59.2]
[]
[null,"ENERGIA Y FLUÍDOS",51.97,26.128293669717443,40.380000000000003]
[]
[null,"SERVICIOS CONTRATADOS",63.23,684.33318212973188,638.16]
[]
[null,"GASTOS VARIOS",29.04,98.878403345405289,350.44]
[]
[null,"AMORTIZACIÓN",404.34,671.31634647480882,92.72]
[]
[]
[]
[null,"TOTAL",677.01,2296.7136570338862,2138.81]
[]
[]
[null,"2.CONEXIONES (promedio anual)",49623,6817]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",0.83,1.03,0]
[]
[null,"3.3 TOTAL",0.84,1.02]
[]
[]
[null,"4.M3 ELEVADOS",19175180]
[]
[null,"5.M3 FACTURADOS",5368190]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",0.15]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",0.53]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",36.94]
[]
[null,"6.4 TOTAL/M3FACT",38.93]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",27.43]
[]
[null,"7.2 FIJO/CONEXIONES",126.2]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",44.28]
[]
[null,"7.4 TOTAL/M3FACT",46.5]

{"sheet":"A-SAT-403","index":16,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["SISTEMA ATLANTIDA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",82396031,0,88425082,170821113,null,null,170821113]
["       Ingresos Fijos",37404081,0,84198679,121602760,null,null,121602760]
["    INGRESOS DE EXPLOTACION",119800112,0,172623761,292423873,null,null,292423873]
["       Ingresos Alcantarillado",null,null,null,null,19534792,null,19534792]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",7988037,0,14788233,22776270,0,0,22776270]
["   TOTAL ING. DE EXPLOTACION",127788149,0,187411994,315200143,19534792,0,334734935]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",6260801,0,23550202,29811003,1317536,0,31128539]
["       Costo Operativo Fijo",23654913,0,59864891,83519804,7571157,0,91090961]
["    TOTAL OPERATIVO",29915714,0,83415093,113330807,8888693,0,122219500]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",41030708,0,69248379,110279087,4893279,0,115172366]
["       Comercial Asignados",10989455,0,16116953,27106408,1679942,0,28786350]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",52020163,0,85365332,137385495,6573221,0,143958716]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",6896007,0,11638535,18534542,822411,0,19356953]
["       Administ. Asignados",17577140,0,25778344,43355484,2686992,0,46042476]
["       Gastos Fiscales",6589036,0,9663372,16252408,1007257,0,17259665]
["    TOTAL ADMINISTRACION",31062183,0,47080251,78142434,4516660,0,82659094]
["    TOTAL NO OPERATIVO",83082346,0,132445583,215527929,11089881,0,226617810]
["  COSTO DE EXPLOTACION",112998060,0,215860676,328858736,19978574,0,348837310]
["  RESULTADO DE EXPLOTACION",14790089,0,-28448682,-13658593,-443782,0,-14102375]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",2044213,0,2998008,5042221,312497,0,5354718]
["       Gtos. Div. y Extraor",315277,0,462381,777658,48196,0,825854]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1728936,0,2535627,4264563,264301,0,4528864]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",4372254,0,6412276,10784530,668380,0,11452910]
["       Gastos Financieros",20455989,0,30000417,50456406,3127078,0,53583484]
["   RESULTADO FINANCIERO",-16083735,0,-23588141,-39671876,-2458698,0,-42130574]
["    I.R.A.E.",-15026196,0,-22037171,-37063367,-2297033,null,-39360400]
[" RESULTADO NETO",15461486,0,-27464025,-12002539,-341146,0,-12343685]

{"sheet":"B-SAT-403","index":17,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["S I S T E M A   A T L A N T I D A "]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",25574557.922728095,3841367.3320899438,29415925.254818037]
[]
[null,"MATERIALES Y SUMINISTROS",13050396.273025179,126631.15510743501,13177027.428132614]
[]
[null,"ENERGIA Y FLUÍDOS",13148846.56097272,262252.44994104514,13411099.010913765]
[]
[null,"SERVICIOS CONTRATADOS",9084797.2240809314,1404742.3484964394,10489539.57257737]
[]
[null,"GASTOS VARIOS",6840788.6308227777,133147.04672586796,6973935.677548646]
[]
[null,"AMORTIZACIÓN",45631420.388370283,3120552.667639269,48751973.056009553]
[]
[]
[null,"TOTAL",113330807,8888693,122219500,null,0.47602750608952166]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",47108576.92049662,9391073.6478431523,56499650.568339773]
[]
[null,"MATERIALES Y SUMINISTROS",9154120.7261556275,321352.37099437846,9475473.0971500054]
[]
[null,"ENERGIA Y FLUÍDOS",209232.19277400803,2522993.789493999,2732225.982268007]
[]
[null,"SERVICIOS CONTRATADOS",39742883.984379649,3608695.5657838266,43351579.550163478]
[]
[null,"GASTOS VARIOS",14055630.935306223,1543318.3013406429,15598949.236646866]
[]
[null,"AMORTIZACIÓN",4901921.2408878729,1969519.3245440011,6871440.5654318742]
[]
[]
[]
[null,"TOTAL",115172366,19356953,134529319,null,0.52397249391047829]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,256748819]
[]
[]
[]
[null,null,null,null,null,null,0]

{"sheet":"C-SAT-403","index":18,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["S I S T E M A     A T L A N T I D A"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",{"$f":"ROUND(+'B-SAT-403'!C14/'C-SAT-403'!$C$31,2)","v":409.97},{"$f":"+'B-SAT-403'!D14/'C-SAT-403'!$D$31","v":694.01397147063119},{"$f":"ROUND((+'B-SAT-403'!C37+'B-SAT-403'!D37)/$C$31,2)","v":905.7}]
[]
[null,"MATERIALES Y SUMINISTROS",{"$f":"ROUND(+'B-SAT-403'!C16/'C-SAT-403'!$C$31,2)","v":209.2},{"$f":"+'B-SAT-403'!D16/'C-SAT-403'!$D$31","v":22.878257471984647},{"$f":"ROUND((+'B-SAT-403'!C39+'B-SAT-403'!D39)/$C$31,2)","v":151.88999999999999}]
[]
[null,"ENERGIA Y FLUÍDOS",{"$f":"ROUND(+'B-SAT-403'!C18/'C-SAT-403'!$C$31,2)","v":210.78},{"$f":"+'B-SAT-403'!D18/'C-SAT-403'!$D$31","v":47.380749763513123},{"$f":"ROUND((+'B-SAT-403'!C41+'B-SAT-403'!D41)/$C$31,2)","v":43.8}]
[]
[null,"SERVICIOS CONTRATADOS",{"$f":"ROUND(+'B-SAT-403'!C20/'C-SAT-403'!$C$31,2)","v":145.63},{"$f":"+'B-SAT-403'!D20/'C-SAT-403'!$D$31","v":253.79265555491227},{"$f":"ROUND((+'B-SAT-403'!C43+'B-SAT-403'!D43)/$C$31,2)","v":694.94}]
[]
[null,"GASTOS VARIOS",{"$f":"ROUND(+'B-SAT-403'!C22/'C-SAT-403'!$C$31,2)","v":109.66},{"$f":"+'B-SAT-403'!D22/'C-SAT-403'!$D$31","v":24.055473663210108},{"$f":"ROUND((+'B-SAT-403'!C45+'B-SAT-403'!D45)/$C$31,2)","v":250.06}]
[]
[null,"AMORTIZACIÓN",{"$f":"ROUND(+'B-SAT-403'!C24/'C-SAT-403'!$C$31,2)","v":731.48},{"$f":"+'B-SAT-403'!D24/'C-SAT-403'!$D$31","v":563.785486475026},{"$f":"ROUND((+'B-SAT-403'!C47+'B-SAT-403'!D47)/$C$31,2)","v":110.15}]
[]
[]
[]
[null,"TOTAL",{"$f":"+SUM(C14:C24)","v":1816.72},{"$f":"+SUM(D14:D24)","v":1605.9065943992773},{"$f":"+SUM(E14:E24)","v":2156.54}]
[]
[]
[null,"2.CONEXIONES (promedio anual)",{"$f":"+'[5]CONEX-ERE'!$K$8","v":62382},{"$f":"+'[5]CONEX-ERE'!$J$8","v":5535}]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",{"$f":"ROUND(+'A-SAT-403'!E31/(('A-SAT-403'!E13)),2)","v":1.04},{"$f":"ROUND(+'A-SAT-403'!F31/('A-SAT-403'!F13),2)","v":1.02},0]
[]
[null,"3.3 TOTAL",{"$f":"ROUND(+('A-SAT-403'!E31+'A-SAT-403'!E35+'A-SAT-403'!E39+'A-SAT-403'!E41)/((+'A-SAT-403'!E13+'A-SAT-403'!E34+'A-SAT-403'!E38)),2)","v":1.04},{"$f":"ROUND(+('A-SAT-403'!F31+'A-SAT-403'!F35+'A-SAT-403'!F39+'A-SAT-403'!F41)/((+'A-SAT-403'!F13+'A-SAT-403'!F34+'A-SAT-403'!F38)),2)","v":1.02}]
[]
[]
[null,"4.M3 ELEVADOS",{"$f":"+'[5]metros elevados-facturados'!$G$62+'[5]metros elevados-facturados'!$G$68","v":12121740}]
[]
[null,"5.M3 FACTURADOS",{"$f":"+'[5]metros elevados-facturados'!$H$62+'[5]metros elevados-facturados'!$H$68","v":6232860}]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",{"$f":"+ROUND((+'A-SAT-403'!E16/'C-SAT-403'!C41),2)","v":2.46}]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",{"$f":"+ROUND((+'A-SAT-403'!E16/'C-SAT-403'!C43),2)","v":4.78}]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",{"$f":"ROUND((+'A-SAT-403'!E31/'C-SAT-403'!C43),2)","v":52.76}]
[]
[null,"6.4 TOTAL/M3FACT",{"$f":"ROUND((+'A-SAT-403'!E31+'A-SAT-403'!E35+'A-SAT-403'!E39+'A-SAT-403'!E41)/C43,2)","v":55.04}]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",{"$f":"ROUND((+'A-SAT-403'!E7)/('C-SAT-403'!C43),2)","v":27.41}]
[]
[null,"7.2 FIJO/CONEXIONES",{"$f":"ROUND((+'A-SAT-403'!E8/12)/'C-SAT-403'!C31,2)","v":162.44}]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",{"$f":"ROUND((+'A-SAT-403'!E13)/'C-SAT-403'!C43,2)","v":50.57}]
[]
[null,"7.4 TOTAL/M3FACT",{"$f":"ROUND(((+'A-SAT-403'!E13+'A-SAT-403'!E34+'A-SAT-403'!E38))/C43,2)","v":53.11}]

{"sheet":"A-CC-404","index":19,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["CIUDAD DE LA COSTA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",180395284,0,0,180395284,null,null,180395284]
["       Ingresos Fijos",92213274,0,0,92213274,null,null,92213274]
["    INGRESOS DE EXPLOTACION",272608558,0,0,272608558,null,null,272608558]
["       Ingresos Alcantarillado",null,null,null,null,13418908,null,13418908]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",20166015,0,0,20166015,705661,0,20871676]
["   TOTAL ING. DE EXPLOTACION",292774573,0,0,292774573,14124569,0,306899142]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",1395194,0,0,1395194,2716556,0,4111750]
["       Costo Operativo Fijo",27068627,0,0,27068627,25809709,0,52878336]
["    TOTAL OPERATIVO",28463821,0,0,28463821,28526265,0,56990086]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",63384275,0,0,63384275,1927199,0,65311474]
["       Comercial Asignados",25177866,0,0,25177866,1214677,0,26392543]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",88562141,0,0,88562141,3141876,0,91704017]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",25995023,0,0,25995023,790379,0,26785402]
["       Administ. Asignados",40270867,0,0,40270867,1942821,0,42213688]
["       Gastos Fiscales",15096096,0,0,15096096,728294,0,15824390]
["    TOTAL ADMINISTRACION",81361986,0,0,81361986,3461494,0,84823480]
["    TOTAL NO OPERATIVO",169924127,0,0,169924127,6603370,0,176527497]
["  COSTO DE EXPLOTACION",198387948,0,0,198387948,35129635,0,233517583]
["  RESULTADO DE EXPLOTACION",94386625,0,0,94386625,-21005066,0,73381559]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",4683482,0,0,4683482,225949,0,4909431]
["       Gtos. Div. y Extraor",722330,0,0,722330,34848,0,757178]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",3961152,0,0,3961152,191101,0,4152253]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",10017242,0,0,10017242,483270,0,10500512]
["       Gastos Financieros",46866580,0,0,46866580,2261024,0,49127604]
["   RESULTADO FINANCIERO",-36849338,0,0,-36849338,-1777754,0,-38627092]
["    I.R.A.E.",-34426417,0,0,-34426417,-1660862,null,-36087279]
[" RESULTADO NETO",95924856,0,0,95924856,-20930857,0,74993999]

{"sheet":"B-CC-404","index":20,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["C I U D A D   D E   L A    C O S T A "]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",2233738.1044201707,747432.03025921329,2981170.1346793841]
[]
[null,"MATERIALES Y SUMINISTROS",169841.12145403688,72579.64447578277,242420.76592981967]
[]
[null,"ENERGIA Y FLUÍDOS",1130093.2613799835,2538718.4626657516,3668811.7240457349]
[]
[null,"SERVICIOS CONTRATADOS",3324759.80492868,9333138.0669412129,12657897.871869892]
[]
[null,"GASTOS VARIOS",439209.95959038206,461867.78687961557,901077.74646999757]
[]
[null,"AMORTIZACIÓN",21166178.748226747,15372529.008778421,36538707.75700517]
[]
[]
[null,"TOTAL",28463821,28526265,56990086,null,0.38226069694813419]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",20931760.536976032,11015397.727541776,31947158.264517806]
[]
[null,"MATERIALES Y SUMINISTROS",4325863.66090714,58122.986233037598,4383986.6471401779]
[]
[null,"ENERGIA Y FLUÍDOS",81140.755159508873,1509973.4522419968,1591114.2074015057]
[]
[null,"SERVICIOS CONTRATADOS",27158158.91977632,9196425.43405894,36354584.353835262]
[]
[null,"GASTOS VARIOS",9583659.3096535597,1902252.9099360567,11485912.219589617]
[]
[null,"AMORTIZACIÓN",3230890.8175274362,3103229.489988192,6334120.3075156286]
[]
[]
[]
[null,"TOTAL",65311474,26785402,92096876,null,0.61773930305186575]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,149086962]

{"sheet":"C-CC-404","index":21,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["C I U D A D   D E   LA   C O S T A "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",52.57,289.36586537329202,751.82]
[]
[null,"MATERIALES Y SUMINISTROS",4,28.098971922486555,103.17]
[]
[null,"ENERGIA Y FLUÍDOS",26.59,982.85654768321785,37.44]
[]
[null,"SERVICIOS CONTRATADOS",78.239999999999995,3613.2938702830866,855.54]
[]
[null,"GASTOS VARIOS",10.34,178.81060274085002,270.3]
[]
[null,"AMORTIZACIÓN",498.11,5951.4243162130933,149.06]
[]
[]
[]
[null,"TOTAL",669.85,11043.850174216026,2167.33]
[]
[]
[null,"2.CONEXIONES (promedio anual)",42493,2583]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",0.68,2.4900000000000002,0]
[]
[null,"3.3 TOTAL",0.69,2.41]
[]
[]
[null,"4.M3 ELEVADOS",11941390]
[]
[null,"5.M3 FACTURADOS",6352360]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",0.12]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",0.22]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",31.23]
[]
[null,"6.4 TOTAL/M3FACT",33.299999999999997]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",28.4]
[]
[null,"7.2 FIJO/CONEXIONES",180.84]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",46.09]
[]
[null,"7.4 TOTAL/M3FACT",48.4]

{"sheet":"A-FDA-405","index":22,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["FLORIDA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",{"$f":"ROUND(+'[6]A-FDA-405'!B3*-1,0)","v":51825959},{"$f":"ROUND(+'[6]A-FDA-405'!C3*-1,0)","v":3168470},{"$f":"ROUND(+'[6]A-FDA-405'!D3*-1,0)","v":10814214},{"$f":"+D7+C7+B7","v":65808643},null,null,{"$f":"+E7","v":65808643}]
["       Ingresos Fijos",{"$f":"ROUND(+'[6]A-FDA-405'!B4*-1,0)","v":27827970},{"$f":"ROUND(+'[6]A-FDA-405'!C4*-1,0)","v":2289391},{"$f":"ROUND(+'[6]A-FDA-405'!D4*-1,0)","v":7808321},{"$f":"+D8+C8+B8","v":37925682},null,null,{"$f":"+E8","v":37925682}]
["    INGRESOS DE EXPLOTACION",{"$f":"+B8+B7","v":79653929},{"$f":"+C8+C7","v":5457861},{"$f":"+D8+D7","v":18622535},{"$f":"+E8+E7","v":103734325},null,null,{"$f":"+E9","v":103734325}]
["       Ingresos Alcantarillado",null,null,null,null,{"$f":"ROUND(+'[6]A-FDA-405'!F8*-1,0)","v":39163424},null,{"$f":"+F10","v":39163424}]
["       Ingresos Upas",null,null,null,null,null,{"$f":"ROUND(+'[6]A-FDA-405'!G9*-1,0)","v":0},{"$f":"+G11","v":0}]
["       Otros Ingresos",{"$f":"ROUND(+'[6]A-FDA-405'!B10*-1,0)","v":3987279},{"$f":"ROUND(+'[6]A-FDA-405'!C10*-1,0)","v":242049},{"$f":"ROUND(+'[6]A-FDA-405'!D10*-1,0)","v":829821},{"$f":"+D12+C12+B12","v":5059149},{"$f":"ROUND(+'[6]A-FDA-405'!F10*-1,0)","v":28809},{"$f":"ROUND(+'[6]A-FDA-405'!G10*-1,0)","v":0},{"$f":"+G12+F12+E12","v":5087958}]
["   TOTAL ING. DE EXPLOTACION",{"$f":"+B12+B9","v":83641208},{"$f":"+C12+C9","v":5699910},{"$f":"+D12+D9","v":19452356},{"$f":"+E12+E9","v":108793474},{"$f":"+F12+F10","v":39192233},{"$f":"+G12+G11","v":0},{"$f":"+H12+H11+H10+H9","v":147985707}]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",{"$f":"ROUND(+'[6]A-FDA-405'!B14,0)","v":21292827},{"$f":"ROUND(+'[6]A-FDA-405'!C14,0)","v":2037500},{"$f":"ROUND(+'[6]A-FDA-405'!D14,0)","v":4483369},{"$f":"+D16+C16+B16","v":27813696},{"$f":"ROUND(+'[6]A-FDA-405'!F14,0)","v":11394065},0,{"$f":"+F16+E16","v":39207761}]
["       Costo Operativo Fijo",{"$f":"ROUND(+'[6]A-FDA-405'!B15,0)","v":47335017},{"$f":"ROUND(+'[6]A-FDA-405'!C15,0)","v":14740465},{"$f":"ROUND(+'[6]A-FDA-405'!D15,0)","v":19642389},{"$f":"+D17+C17+B17","v":81717871},{"$f":"ROUND(+'[6]A-FDA-405'!F15,0)","v":47495944},0,{"$f":"+F17+E17","v":129213815}]
["    TOTAL OPERATIVO",{"$f":"+B17+B16","v":68627844},{"$f":"+C17+C16","v":16777965},{"$f":"+D17+D16","v":24125758},{"$f":"+E17+E16","v":109531567},{"$f":"+F17+F16","v":58890009},0,{"$f":"+H17+H16","v":168421576}]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",{"$f":"ROUND(+'[6]A-FDA-405'!B19,0)","v":28674057},{"$f":"ROUND(+'[6]A-FDA-405'!C19,0)","v":3758834},{"$f":"ROUND(+'[6]A-FDA-405'!D19,0)","v":7552751},{"$f":"+D21+C21+B21","v":39985642},{"$f":"ROUND(+'[6]A-FDA-405'!F19,0)","v":11999869},0,{"$f":"+F21+E21","v":51985511}]
["       Comercial Asignados",{"$f":"ROUND(+'[6]A-FDA-405'!B20,0)","v":7192931},{"$f":"ROUND(+'[6]A-FDA-405'!C20,0)","v":490178},{"$f":"ROUND(+'[6]A-FDA-405'!D20,0)","v":1672853},{"$f":"+D22+C22+B22","v":9355962},{"$f":"ROUND(+'[6]A-FDA-405'!F20,0)","v":3370432},0,{"$f":"+F22+E22","v":12726394}]
["       Comercialización Upas",0,0,0,0,0,{"$f":"ROUND(+'[6]A-FDA-405'!G21,0)","v":0},{"$f":"+G23","v":0}]
["    TOTAL COMERCIALIZACION",{"$f":"+B22+B21","v":35866988},{"$f":"+C22+C21","v":4249012},9225604,{"$f":"+E22+E21","v":49341604},{"$f":"+F22+F21","v":15370301},{"$f":"+G23","v":0},{"$f":"+G24+F24+E24","v":64711905}]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",{"$f":"ROUND(+'[6]A-FDA-405'!B24,0)","v":5442279},{"$f":"ROUND(+'[6]A-FDA-405'!C24,0)","v":713419},{"$f":"ROUND(+'[6]A-FDA-405'!D24,0)","v":1433497},{"$f":"+D26+C26+B26","v":7589195},{"$f":"ROUND(+'[6]A-FDA-405'!F24,0)","v":2277551},0,{"$f":"+F26+E26","v":9866746}]
["       Administ. Asignados",{"$f":"ROUND(+'[6]A-FDA-405'!B25,0)","v":11504770},{"$f":"ROUND(+'[6]A-FDA-405'!C25,0)","v":784017},{"$f":"ROUND(+'[6]A-FDA-405'!D25,0)","v":2675653},{"$f":"+D27+C27+B27","v":14964440},{"$f":"ROUND(+'[6]A-FDA-405'!F25,0)","v":5390855},0,{"$f":"+F27+E27","v":20355295}]
["       Gastos Fiscales",{"$f":"ROUND(+'[6]A-FDA-405'!B26,0)","v":4312723},{"$f":"ROUND(+'[6]A-FDA-405'!C26,0)","v":293900},{"$f":"ROUND(+'[6]A-FDA-405'!D26,0)","v":1003006},5609629,{"$f":"ROUND(+'[6]A-FDA-405'!F26,0)","v":2020837},0,{"$f":"+F28+E28","v":7630466}]
["    TOTAL ADMINISTRACION",{"$f":"+B28+B27+B26","v":21259772},{"$f":"+C28+C27+C26","v":1791336},{"$f":"+D28+D27+D26","v":5112156},{"$f":"+E28+E27+E26","v":28163264},{"$f":"+F28+F27+F26","v":9689243},0,{"$f":"+E29+F29","v":37852507}]
["    TOTAL NO OPERATIVO",{"$f":"+B29+B24","v":57126760},{"$f":"+C29+C24","v":6040348},14337760,{"$f":"+D30+C30+B30","v":77504868},{"$f":"+F29+F24","v":25059544},{"$f":"ROUND(+'[6]A-FDA-405'!G28,0)","v":0},{"$f":"+H29+H24","v":102564412}]
["  COSTO DE EXPLOTACION",{"$f":"+B30+B18","v":125754604},{"$f":"+C30+C18","v":22818313},38463518,187036435,83949553,0,270985988]
["  RESULTADO DE EXPLOTACION",{"$f":"+B13-B31","v":-42113396},{"$f":"+C13-C31","v":-17118403},-19011162,-78242961,-44757320,0,-123000281]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",{"$f":"ROUND(+'[6]A-FDA-405'!B32*-1,0)","v":1337999},{"$f":"ROUND(+'[6]A-FDA-405'!C32*-1,0)","v":91181},{"$f":"ROUND(+'[6]A-FDA-405'!D32*-1,0)","v":311177},{"$f":"+D34+C34+B34","v":1740357},{"$f":"ROUND(+'[6]A-FDA-405'!F32*-1,0)","v":626954},0,{"$f":"+F34+E34","v":2367311}]
["       Gtos. Div. y Extraor",{"$f":"ROUND(+'[6]A-FDA-405'!B33,0)","v":206359},{"$f":"ROUND(+'[6]A-FDA-405'!C33,0)","v":14063},{"$f":"ROUND(+'[6]A-FDA-405'!D33,0)","v":47993},{"$f":"+D35+C35+B35","v":268415},{"$f":"ROUND(+'[6]A-FDA-405'!F33,0)","v":96695},0,{"$f":"+F35+E35","v":365110}]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",{"$f":"+B34-B35","v":1131640},{"$f":"+C34-C35","v":77118},263184,{"$f":"+E34-E35","v":1471942},{"$f":"+F34-F35","v":530259},0,{"$f":"+H34-H35","v":2002201}]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",{"$f":"ROUND(+'[6]A-FDA-405'!B36*-1,0)","v":2861773},{"$f":"ROUND(+'[6]A-FDA-405'!C36*-1,0)","v":195022},{"$f":"ROUND(+'[6]A-FDA-405'!D36*-1,0)","v":665560},{"$f":"+D38+C38+B38","v":3722355},{"$f":"ROUND(+'[6]A-FDA-405'!F36*-1,0)","v":1340957},0,{"$f":"+F38+E38","v":5063312}]
["       Gastos Financieros",{"$f":"ROUND(+'[6]A-FDA-405'!B37,0)","v":13389064},{"$f":"ROUND(+'[6]A-FDA-405'!C37,0)","v":912426},{"$f":"ROUND(+'[6]A-FDA-405'!D37,0)","v":3113882},{"$f":"+D39+C39+B39","v":17415372},{"$f":"ROUND(+'[6]A-FDA-405'!F37,0)","v":6273789},0,{"$f":"+F39+E39","v":23689161}]
["   RESULTADO FINANCIERO",{"$f":"+B38-B39","v":-10527291},{"$f":"+C38-C39","v":-717404},{"$f":"+D38-D39","v":-2448322},-13693017,-4932832,0,-18625849]
["    I.R.A.E.",{"$f":"ROUND(+'[6]A-FDA-405'!B39,0)","v":-9835100},{"$f":"ROUND(+'[6]A-FDA-405'!C39,0)","v":-670234},{"$f":"ROUND(+'[6]A-FDA-405'!D39,0)","v":-2287340},{"$f":"+D41+C41+B41","v":-12792674},{"$f":"ROUND(+'[6]A-FDA-405'!F39,0)","v":-4608488},null,{"$f":"+F41+E41","v":-17401162}]
[" RESULTADO NETO",{"$f":"+B32+B36+B40-B41","v":-41673947},{"$f":"+C32+C36+C40-C41","v":-17088455},{"$f":"+D32+D36+D40-D41","v":-18908960},-77671362,-44551405,{"$f":"+G32+G36+G40-G41","v":0},{"$f":"+H32+H36+H40-H41","v":-122222767}]

{"sheet":"B-FDA-405","index":23,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["F LO R I D A"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",52890908.36347349,21105795.372230578,73996703.735704064]
[]
[null,"MATERIALES Y SUMINISTROS",11507514.319494646,3248788.6126675005,14756302.932162147]
[]
[null,"ENERGIA Y FLUÍDOS",11004448.884335702,5408130.5470794309,16412579.431415133]
[]
[null,"SERVICIOS CONTRATADOS",6841159.9305050392,6724589.3069174569,13565749.237422496]
[]
[null,"GASTOS VARIOS",3331031.5184308775,1249194.4638130339,4580225.9822439114]
[]
[null,"AMORTIZACIÓN",23956503.98376026,21153510.697291989,45110014.681052253]
[]
[]
[null,"TOTAL",109531567,58890009,168421576,null,0.73139693644653059]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",26032472.456925564,3126084.6878806446,29158557.144806206]
[]
[null,"MATERIALES Y SUMINISTROS",3845830.2416365403,199624.50514639664,4045454.7467829371]
[]
[null,"ENERGIA Y FLUÍDOS",194466.79710810565,2732266.6327999951,2926733.429908101]
[]
[null,"SERVICIOS CONTRATADOS",12005673.128245514,1824848.8619770287,13830521.990222543]
[]
[null,"GASTOS VARIOS",7643607.22683053,920957.91366137844,8564565.1404919084]
[]
[null,"AMORTIZACIÓN",2263461.1492537451,1062963.3985345578,3326424.5477883029]
[]
[]
[]
[null,"TOTAL",51985511,9866746,61852257,null,0.26860306355346941]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,230273833]

{"sheet":"C-FDA-405","index":24,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["F L O R I D A "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",2209.77,1469.1490583482234,1218.24]
[]
[null,"MATERIALES Y SUMINISTROS",480.78,226.14427207764865,169.02]
[]
[null,"ENERGIA Y FLUÍDOS",459.76,376.45346979531053,122.28]
[]
[null,"SERVICIOS CONTRATADOS",285.82,468.09058241107175,577.84]
[]
[null,"GASTOS VARIOS",139.16999999999999,86.954925784006264,357.83]
[]
[null,"AMORTIZACIÓN",1000.9,1472.4704647982728,138.97999999999999]
[]
[]
[]
[null,"TOTAL",4576.2000000000007,4099.2627732145338,2584.19]
[]
[]
[null,"2.CONEXIONES (promedio anual)",23935,14366]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.72,2.14,0]
[]
[null,"3.3 TOTAL",1.68,2.08]
[]
[]
[null,"4.M3 ELEVADOS",3526900]
[]
[null,"5.M3 FACTURADOS",2617220]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",7.89]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",10.63]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",71.459999999999994]
[]
[null,"6.4 TOTAL/M3FACT",73.33]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",25.14]
[]
[null,"7.2 FIJO/CONEXIONES",132.04]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",41.57]
[]
[null,"7.4 TOTAL/M3FACT",43.66]

{"sheet":"A-DUR-406","index":25,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["DURAZNO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",59485963,2801295,0,62287258,null,null,62287258]
["       Ingresos Fijos",30212428,1705458,0,31917886,null,null,31917886]
["    INGRESOS DE EXPLOTACION",89698391,4506753,0,94205144,null,null,94205144]
["       Ingresos Alcantarillado",null,null,null,null,33407750,null,33407750]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",4868893,215548,0,5084441,0,0,5084441]
["   TOTAL ING. DE EXPLOTACION",94567284,4722301,0,99289585,33407750,0,132697335]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",18021765,33005,0,18054770,5742853,0,23797623]
["       Costo Operativo Fijo",48319957,3284829,0,51604786,26349632,0,77954418]
["    TOTAL OPERATIVO",66341722,3317834,0,69659556,32092485,0,101752041]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",33214657,2148160,0,35362817,9462586,0,44825403]
["       Comercial Asignados",8132545,406106,0,8538651,2872981,0,11411632]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",41347202,2554266,0,43901468,12335567,0,56237035]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",9329732,603401,0,9933133,2657965,0,12591098]
["       Administ. Asignados",13007641,649548,0,13657189,4595205,0,18252394]
["       Gastos Fiscales",4876096,243492,0,5119588,1722577,0,6842165]
["    TOTAL ADMINISTRACION",27213469,1496441,0,28709910,8975747,0,37685657]
["    TOTAL NO OPERATIVO",68560671,4050707,0,72611378,21311314,0,93922692]
["  COSTO DE EXPLOTACION",134902393,7368541,0,142270934,53403799,0,195674733]
["  RESULTADO DE EXPLOTACION",-40335109,-2646240,0,-42981349,-19996049,0,-62977398]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1512783,75542,0,1588325,534420,0,2122745]
["       Gtos. Div. y Extraor",233315,11651,0,244966,82423,0,327389]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1279468,63891,0,1343359,451997,0,1795356]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",3235607,161573,0,3397180,1143042,0,4540222]
["       Gastos Financieros",15138081,755933,0,15894014,5347824,0,21241838]
["   RESULTADO FINANCIERO",-11902474,-594360,0,-12496834,-4204782,0,-16701616]
["    I.R.A.E.",-11119862,-555280,0,-11675142,-3928309,null,-15603451]
[" RESULTADO NETO",-39838253,-2621429,0,-42459682,-19820525,0,-62280207]

{"sheet":"B-DUR-406","index":26,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["D U R A Z N O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",25057571.800897762,7266892.4654951822,32324464.266392946]
[]
[null,"MATERIALES Y SUMINISTROS",7184474.3173916945,787165.23489771294,7971639.5522894077]
[]
[null,"ENERGIA Y FLUÍDOS",8778292.9736499935,3887975.4056542255,12666268.379304219]
[]
[null,"SERVICIOS CONTRATADOS",3174793.4854199323,7137464.9077026537,10312258.393122585]
[]
[null,"GASTOS VARIOS",4424099.3135080589,663266.34500441095,5087365.6585124694]
[]
[null,"AMORTIZACIÓN",21040324.109132573,12349720.641245816,33390044.750378389]
[]
[]
[null,"TOTAL",69659556,32092485,101752041.00000001,null,0.63927230670995283]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",25766510.383778781,4206551.4222347923,29973061.806013573]
[]
[null,"MATERIALES Y SUMINISTROS",2479844.4163342169,248538.96549838729,2728383.3818326043]
[]
[null,"ENERGIA Y FLUÍDOS",117076.94606018587,2273126.3847980835,2390203.3308582692]
[]
[null,"SERVICIOS CONTRATADOS",9092429.9827736486,4353206.2575305887,13445636.240304237]
[]
[null,"GASTOS VARIOS",5113659.630325486,493485.17844749795,5607144.808772984]
[]
[null,"AMORTIZACIÓN",2255881.640727683,1016189.7914906506,3272071.4322183337]
[]
[]
[]
[null,"TOTAL",44825403,12591098,57416501,null,0.36072769329004722]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,159168542]

{"sheet":"C-DUR-406","index":27,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["D U R A Z N O"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1220.6500000000001,661.46845671720212,1460.11]
[]
[null,"MATERIALES Y SUMINISTROS",349.98,71.651668932979518,132.91]
[]
[null,"ENERGIA Y FLUÍDOS",427.63,353.90273126290055,116.44]
[]
[null,"SERVICIOS CONTRATADOS",154.66,649.68732092687549,654.99]
[]
[null,"GASTOS VARIOS",215.52,60.373779811069632,273.14999999999998]
[]
[null,"AMORTIZACIÓN",1024.96,1124.1325906832164,159.4]
[]
[]
[]
[null,"TOTAL",3393.4,2921.2165483342442,2797]
[]
[]
[null,"2.CONEXIONES (promedio anual)",20528,10986]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.43,1.6,0]
[]
[null,"3.3 TOTAL",1.41,1.56]
[]
[]
[null,"4.M3 ELEVADOS",3421640]
[]
[null,"5.M3 FACTURADOS",2319320]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.28]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.78]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",61.34]
[]
[null,"6.4 TOTAL/M3FACT",63.27]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26.86]
[]
[null,"7.2 FIJO/CONEXIONES",129.57]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.81]
[]
[null,"7.4 TOTAL/M3FACT",44.96]

{"sheet":"A-300-AG-LITORAL SUR","index":28,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["AMBITO GEOGRAFICO LITORAL SUR","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",246587945,81693298,69238102,397519345,null,null,397519345]
["       Ingresos Fijos",120825423,48372860,40311632,209509915,null,null,209509915]
["    INGRESOS DE EXPLOTACION",367413368,130066158,109549734,607029260,null,null,607029260]
["       Ingresos Alcantarillado",null,null,null,null,163508858,null,163508858]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",17261267,8731052,8104506,34096825,102615,0,34199440]
["   TOTAL ING. DE EXPLOTACION",384674635,138797210,117654240,641126085,163611473,0,804737558]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",78937678,19673293,24383737,122994708,16587639,0,139582347]
["       Costo Operativo Fijo",139565665,67711793,47608447,254885905,93037998,0,347923903]
["    TOTAL OPERATIVO",218503343,87385086,71992184,377880613,109625637,0,487506250]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",81316810,34789347,28751836,144857993,28993931,0,173851924]
["       Comercial Asignados",33081037,11936206,10117964,55135207,14070169,0,69205376]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",114397847,46725553,38869800,199993200,43064100,0,243057300]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",27296861,10686601,9507737,47491199,9632732,0,57123931]
["       Administ. Asignados",52911634,19091426,16183230,88186290,22504604,0,110690894]
["       Gastos Fiscales",19834664,7156687,6066510,33057861,8436165,0,41494026]
["    TOTAL ADMINISTRACION",100043159,36934714,31757477,168735350,40573501,0,209308851]
["    TOTAL NO OPERATIVO",214441006,83660267,70627277,368728550,83637601,0,452366151]
["  COSTO DE EXPLOTACION",432944349,171045353,142619461,746609163,193263238,0,939872401]
["  RESULTADO DE EXPLOTACION",-48269714,-32248143,-24965221,-105483078,-29651765,0,-135134843]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",6153595,2220323,1882102,10256020,2617274,0,12873294]
["       Gtos. Div. y Extraor",949065,342439,290275,1581779,403660,0,1985439]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",5204530,1877884,1591827,8674241,2213614,0,10887855]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",13161590,4748928,4025524,21936042,5597944,0,27533986]
["       Gastos Financieros",61577699,22218291,18833780,102629770,26190492,0,128820262]
["   RESULTADO FINANCIERO",-48416109,-17469363,-14808256,-80693728,-20592548,0,-101286276]
["    I.R.A.E.",-45232648,-16320716,-13834582,-75387946,-19238545,null,-94626491]
[" RESULTADO NETO",-46248645,-31518906,-24347068,-102114619,-28792154,0,-130906773]

{"sheet":"B-300-AG-LITORAL SUR","index":29,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["AMBITO GEORAFICO LITORAL SUR"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",103188716.55045716,15255838.04031875,118444554.59077591]
[]
[null,"MATERIALES Y SUMINISTROS",44944284.691888407,1332760.3005305647,46277044.992418975]
[]
[null,"ENERGIA Y FLUÍDOS",53313671.101033323,9509068.4603606015,62822739.561393924]
[]
[null,"SERVICIOS CONTRATADOS",42878641.076961994,40978803.907726124,83857444.984688118]
[]
[null,"GASTOS VARIOS",18309197.986800402,1254233.7519461515,19563431.738746554]
[]
[null,"AMORTIZACIÓN",115246101.59285872,41294932.539117821,156541034.13197654]
[]
[]
[null,"TOTAL",377880613,109625637,487506250.00000006,null,0.67852246647117254]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",86383198.279113248,35862898.858185597,122246097.13729885]
[]
[null,"MATERIALES Y SUMINISTROS",9025033.2817523852,866253.61944534781,9891286.9011977334]
[]
[null,"ENERGIA Y FLUÍDOS",567004.72652092762,8574129.7153798565,9141134.4419007841]
[]
[null,"SERVICIOS CONTRATADOS",50866768.757052943,6750830.0631292174,57617598.82018216]
[]
[null,"GASTOS VARIOS",19202639.112075303,2167039.2800674057,21369678.392142709]
[]
[null,"AMORTIZACIÓN",7807279.8434851775,2902779.4637925858,10710059.307277763]
[]
[]
[]
[null,"TOTAL",173851923.99999997,57123931.000000007,230975855.00000003,null,0.32147753352882741]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,718482105.00000012]

{"sheet":"C-300-AG-LITORAL SUR","index":30,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["A M B I T O   G E O G R A F I C O  L I T O R A L   S U R"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",776.46,296.06314968888876,919.86]
[]
[null,"MATERIALES Y SUMINISTROS",338.19,25.864276437162854,74.430000000000007]
[]
[null,"ENERGIA Y FLUÍDOS",401.17,184.53819131674595,68.78]
[]
[null,"SERVICIOS CONTRATADOS",322.64999999999998,795.25711556067699,433.55]
[]
[null,"GASTOS VARIOS",137.77000000000001,24.340347220907674,160.80000000000001]
[]
[null,"AMORTIZACIÓN",867.19,801.39208094699723,80.59]
[]
[]
[]
[null,"TOTAL",2843.4300000000003,2127.4551611713796,1738.0099999999998]
[]
[]
[null,"2.CONEXIONES (promedio anual)",132896,51529]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.1599999999999999,1.18,0]
[]
[null,"3.3 TOTAL",1.1499999999999999,1.17]
[]
[]
[null,"4.M3 ELEVADOS",24467280]
[]
[null,"5.M3 FACTURADOS",14120980]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.03]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.7100000000000009]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",52.87]
[]
[null,"6.4 TOTAL/M3FACT",54.91]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",28.15]
[]
[null,"7.2 FIJO/CONEXIONES",131.37]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",45.4]
[]
[null,"7.4 TOTAL/M3FACT",47.68]

{"sheet":"A-SJ-301","index":31,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["SAN JOSE","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",48451350,46888526,3106627,98446503,null,null,98446503]
["       Ingresos Fijos",27026860,26008118,2098060,55133038,null,null,55133038]
["    INGRESOS DE EXPLOTACION",75478210,72896644,5204687,153579541,null,null,153579541]
["       Ingresos Alcantarillado",null,null,null,null,43281910,null,43281910]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",3598726,6362563,1484121,11445410,89780,0,11535190]
["   TOTAL ING. DE EXPLOTACION",79076936,79259207,6688808,165024951,43371690,0,208396641]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",19837938,10649473,1257444,31744855,7542416,0,39287271]
["       Costo Operativo Fijo",35258854,38748765,6412563,80420182,46746963,0,127167145]
["    TOTAL OPERATIVO",55096792,49398238,7670007,112165037,54289379,0,166454416]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",15888418,19307092,1361700,36557210,7385489,0,43942699]
["       Comercial Asignados",6800415,6816090,575220,14191725,3729855,0,17921580]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",22688833,26123182,1936920,50748935,11115344,0,61864279]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",4641335,5640001,397781,10679117,2157454,0,12836571]
["       Administ. Asignados",10876958,10902029,920039,22699026,5965735,0,28664761]
["       Gastos Fiscales",4077380,4086778,344890,8509048,2236339,0,10745387]
["    TOTAL ADMINISTRACION",19595673,20628808,1662710,41887191,10359528,0,52246719]
["    TOTAL NO OPERATIVO",42284506,46751990,3599630,92636126,21474872,0,114110998]
["  COSTO DE EXPLOTACION",97381298,96150228,11269637,204801163,75764251,0,280565414]
["  RESULTADO DE EXPLOTACION",-18304362,-16891021,-4580829,-39776212,-32392561,0,-72168773]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1264985,1267900,107000,2639885,693812,0,3333697]
["       Gtos. Div. y Extraor",195098,195547,16503,407148,107006,0,514154]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1069887,1072353,90497,2232737,586806,0,2819543]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",2705607,2711843,228857,5646307,1483957,0,7130264]
["       Gastos Financieros",12658427,12687604,1070727,26416758,6942826,0,33359584]
["   RESULTADO FINANCIERO",-9952820,-9975761,-841870,-20770451,-5458869,0,-26229320]
["    I.R.A.E.",-9298402,-9319834,-786515,-19404751,-5099937,null,-24504688]
[" RESULTADO NETO",-17888893,-16474595,-4545687,-38909175,-32164687,0,-71073862]

{"sheet":"B-SJ-301","index":32,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["S AN  J O S E"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",25828443.816177443,5548545.4684505807,31376989.284628022]
[]
[null,"MATERIALES Y SUMINISTROS",9719162.468063049,387029.76171448547,10106192.229777534]
[]
[null,"ENERGIA Y FLUÍDOS",17421256.636743285,5046418.3925114665,22467675.029254749]
[]
[null,"SERVICIOS CONTRATADOS",11144897.338398565,23722987.746265125,34867885.084663689]
[]
[null,"GASTOS VARIOS",3994742.3379223268,512837.70651499508,4507580.0444373218]
[]
[null,"AMORTIZACIÓN",44056534.40269535,19071559.924543351,63128094.327238701]
[]
[]
[null,"TOTAL",112165037,54289379,166454416.00000003,null,0.74565097670787905]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",17810450.536664855,8244510.2910477165,26054960.827712573]
[]
[null,"MATERIALES Y SUMINISTROS",2167154.894805951,214440.38501393079,2381595.279819882]
[]
[null,"ENERGIA Y FLUÍDOS",192626.11177510355,1978224.8474711196,2170850.9592462233]
[]
[null,"SERVICIOS CONTRATADOS",14120833.803490974,989304.80247703404,15110138.605968008]
[]
[null,"GASTOS VARIOS",7298670.3384217536,753130.29073834955,8051800.6291601034]
[]
[null,"AMORTIZACIÓN",2352963.3148413706,656960.3832518491,3009923.6980932197]
[]
[]
[]
[null,"TOTAL",43942699,12836571,56779270.000000015,null,0.25434902329212089]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,223233686.00000006]

{"sheet":"C-SJ-301","index":33,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
["º"," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["S A N    J O S E "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",679.43,361.2334289355847,685.39]
[]
[null,"MATERIALES Y SUMINISTROS",255.67,25.197250111620146,62.65]
[]
[null,"ENERGIA Y FLUÍDOS",458.27,328.54286409579862,57.11]
[]
[null,"SERVICIOS CONTRATADOS",293.17,1544.4653480641357,397.48]
[]
[null,"GASTOS VARIOS",105.08,33.387871517903328,211.81]
[]
[null,"AMORTIZACIÓN",1158.93,1241.6380159207911,79.180000000000007]
[]
[]
[]
[null,"TOTAL",2950.55,3534.4647786458336,1493.6200000000001]
[]
[]
[null,"2.CONEXIONES (promedio anual)",38015,15360]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.24,1.75,0]
[]
[null,"3.3 TOTAL",1.22,1.71]
[]
[]
[null,"4.M3 ELEVADOS",7743110]
[]
[null,"5.M3 FACTURADOS",3676350]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",4.0999999999999996]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.6300000000000008]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",55.71]
[]
[null,"6.4 TOTAL/M3FACT",57.73]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26.78]
[]
[null,"7.2 FIJO/CONEXIONES",120.86]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",44.89]
[]
[null,"7.4 TOTAL/M3FACT",47.14]

{"sheet":"A-COL-302","index":34,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["COLONIA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",111058102,20413350,43182079,174653531,null,null,174653531]
["       Ingresos Fijos",49340848,12892879,23870131,86103858,null,null,86103858]
["    INGRESOS DE EXPLOTACION",160398950,33306229,67052210,260757389,null,null,260757389]
["       Ingresos Alcantarillado",null,null,null,null,48547296,null,48547296]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",8095479,1588195,4557239,14240913,8842,0,14249755]
["   TOTAL ING. DE EXPLOTACION",168494429,34894424,71609449,274998302,48556138,0,323554440]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",26092295,4384864,15165975,45643134,3209788,0,48852922]
["       Costo Operativo Fijo",51009768,9813888,22779297,83602953,12381627,0,95984580]
["    TOTAL OPERATIVO",77102063,14198752,37945272,129246087,15591415,0,144837502]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",31352677,8909809,17178922,57441408,7110849,0,64552257]
["       Comercial Asignados",14490091,3000831,6158230,23649152,4175704,0,27824856]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",45842768,11910640,23337152,81090560,11286553,0,92377113]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",10857992,3085626,5949368,19892986,2462614,0,22355600]
["       Administ. Asignados",23176250,4799695,9849812,37825757,6678851,0,44504608]
["       Gastos Fiscales",8687941,1799233,3692340,14179514,2503661,0,16683175]
["    TOTAL ADMINISTRACION",42722183,9684554,19491520,71898257,11645126,0,83543383]
["    TOTAL NO OPERATIVO",88564951,21595194,42828672,152988817,22931679,0,175920496]
["  COSTO DE EXPLOTACION",165667014,35793946,80773944,282234904,38523094,0,320757998]
["  RESULTADO DE EXPLOTACION",2827415,-899522,-9164495,-7236602,10033044,0,2796442]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",2695386,558203,1145528,4399117,776747,0,5175864]
["       Gtos. Div. y Extraor",415707,86091,176674,678472,119797,0,798269]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",2279679,472112,968854,3720645,656950,0,4377595]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",5765014,1193908,2450108,9409030,1661342,0,11070372]
["       Gastos Financieros",26972143,5585807,11463051,44021001,7772738,0,51793739]
["   RESULTADO FINANCIERO",-21207129,-4391899,-9012943,-34611971,-6111396,0,-40723367]
["    I.R.A.E.",-19812716,-4103123,-8420324,-32336163,-5709560,null,-38045723]
[" RESULTADO NETO",3712681,-716186,-8788260,-5791765,10288158,0,4496393]

{"sheet":"B-COL-302","index":35,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["C O L O N I A"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",33263253.32715594,864220.42563139892,34127473.752787337]
[]
[null,"MATERIALES Y SUMINISTROS",14847728.06924925,389198.53462872579,15236926.603877977]
[]
[null,"ENERGIA Y FLUÍDOS",19074695.625736926,817393.45447502926,19892089.080211956]
[]
[null,"SERVICIOS CONTRATADOS",18244265.686511192,5292669.0103250165,23536934.696836211]
[]
[null,"GASTOS VARIOS",6425124.1405206788,251764.37877956618,6676888.5193002447]
[]
[null,"AMORTIZACIÓN",37391020.150826022,7976169.1961602625,45367189.346986286]
[]
[]
[null,"TOTAL",129246087,15591414.999999998,144837502.00000003,null,0.62498555580567206]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",32356293.242744911,15483042.386500549,47839335.62924546]
[]
[null,"MATERIALES Y SUMINISTROS",3942797.2223445051,388554.89464605,4331352.1169905551]
[]
[null,"ENERGIA Y FLUÍDOS",190116.37318406554,3355653.8059405372,3545770.1791246026]
[]
[null,"SERVICIOS CONTRATADOS",18364761.347907715,1341487.9140618576,19706249.261969574]
[]
[null,"GASTOS VARIOS",7037664.2303369297,677070.93004708237,7714735.1603840124]
[]
[null,"AMORTIZACIÓN",2660624.5834818794,1109790.0688039225,3770414.6522858022]
[]
[]
[]
[null,"TOTAL",64552257,22355600,86907857,null,0.37501444419432789]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,231745359.00000003]

{"sheet":"C-COL-302","index":36,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["C O L O N I A"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",630.98,66.213639720456555,907.47]
[]
[null,"MATERIALES Y SUMINISTROS",281.64999999999998,29.819072527484355,82.16]
[]
[null,"ENERGIA Y FLUÍDOS",361.83,62.62591591135682,67.260000000000005]
[]
[null,"SERVICIOS CONTRATADOS",346.08,405.50635996973767,373.81]
[]
[null,"GASTOS VARIOS",121.88,19.289333341983312,146.34]
[]
[null,"AMORTIZACIÓN",709.28,611.10704843397662,71.52]
[]
[]
[]
[null,"TOTAL",2451.6999999999998,1194.5613699049954,1648.56]
[]
[]
[null,"2.CONEXIONES (promedio anual)",52717,13052]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.03,0.79,0]
[]
[null,"3.3 TOTAL",1.02,0.8]
[]
[]
[null,"4.M3 ELEVADOS",8407810]
[]
[null,"5.M3 FACTURADOS",5733080]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.43]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.96]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",49.23]
[]
[null,"6.4 TOTAL/M3FACT",51.39]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",30.46]
[]
[null,"7.2 FIJO/CONEXIONES",136.11000000000001]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",47.97]
[]
[null,"7.4 TOTAL/M3FACT",50.38]

{"sheet":"A-FLO-303","index":37,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["FLORES","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",30626189,0,1471937,32098126,null,null,32098126]
["       Ingresos Fijos",16752525,0,992812,17745337,null,null,17745337]
["    INGRESOS DE EXPLOTACION",47378714,0,2464749,49843463,null,null,49843463]
["       Ingresos Alcantarillado",null,null,null,null,22776406,null,22776406]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",1942740,0,53333,1996073,1094,0,1997167]
["   TOTAL ING. DE EXPLOTACION",49321454,0,2518082,51839536,22777500,0,74617036]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",14116109,0,342050,14458159,4138852,0,18597011]
["       Costo Operativo Fijo",23624236,0,2818648,26442884,18444238,0,44887122]
["    TOTAL OPERATIVO",37740345,0,3160698,40901043,22583090,0,63484133]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",15125801,0,1056932,16182733,6373852,0,22556585]
["       Comercial Asignados",4241519,0,216549,4458068,1958807,0,6416875]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",19367320,0,1273481,20640801,8332659,0,28973460]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",6143581,0,429289,6572870,2588840,0,9161710]
["       Administ. Asignados",6784120,0,346360,7130480,3133024,0,10263504]
["       Gastos Fiscales",2543122,0,129838,2672960,1174458,0,3847418]
["    TOTAL ADMINISTRACION",15470823,0,905487,16376310,6896322,0,23272632]
["    TOTAL NO OPERATIVO",34838143,0,2178968,37017111,15228981,0,52246092]
["  COSTO DE EXPLOTACION",72578488,0,5339666,77918154,37812071,0,115730225]
["  RESULTADO DE EXPLOTACION",-23257034,0,-2821584,-26078618,-15034571,0,-41113189]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",788989,0,40282,829271,364370,0,1193641]
["       Gtos. Div. y Extraor",121685,0,6213,127898,56196,0,184094]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",667304,0,34069,701373,308174,0,1009547]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",1687527,0,86156,1773683,779329,0,2553012]
["       Gastos Financieros",7895248,0,403088,8298336,3646162,0,11944498]
["   RESULTADO FINANCIERO",-6207721,0,-316932,-6524653,-2866833,0,-9391486]
["    I.R.A.E.",-5799551,0,-296093,-6095644,-2678333,null,-8773977]
[" RESULTADO NETO",-22997900,0,-2808354,-25806254,-14914897,0,-40721151]

{"sheet":"B-FLO-303","index":38,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["F L O R E S"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",13173735.645877065,5610729.1264396971,18784464.772316761]
[]
[null,"MATERIALES Y SUMINISTROS",5505467.1294277944,324905.21434449102,5830372.3437722856]
[]
[null,"ENERGIA Y FLUÍDOS",4748580.6623290638,3221940.8145446619,7970521.4768737257]
[]
[null,"SERVICIOS CONTRATADOS",4979885.9426573562,7534066.9206749387,12513952.863332294]
[]
[null,"GASTOS VARIOS",2947509.4828541856,336090.21198089753,3283599.6948350831]
[]
[null,"AMORTIZACIÓN",9545864.136854535,5555357.7120153122,15101221.848869847]
[]
[]
[null,"TOTAL",40901043,22583090,63484132.999999993,null,0.66683312950799944]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",13293691.63166682,5837441.1438957294,19131132.775562551]
[]
[null,"MATERIALES Y SUMINISTROS",1069246.064256557,79512.832163209358,1148758.8964197664]
[]
[null,"ENERGIA Y FLUÍDOS",58217.916261161197,979089.25748739857,1037307.1737485598]
[]
[null,"SERVICIOS CONTRATADOS",5396268.5798354251,1754545.9183953302,7150814.4982307553]
[]
[null,"GASTOS VARIOS",1815576.0094706472,173498.7111790074,1989074.7206496545]
[]
[null,"AMORTIZACIÓN",923584.79850939161,337622.13687932474,1261206.9353887164]
[]
[]
[]
[null,"TOTAL",22556585.000000004,9161710,31718295.000000007,null,0.33316687049200056]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,95202428]

{"sheet":"C-FLO-303","index":39,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["F L O R E S"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1250.5899999999999,676.15438978545399,1816.13]
[]
[null,"MATERIALES Y SUMINISTROS",522.64,39.154641400878646,109.05]
[]
[null,"ENERGIA Y FLUÍDOS",450.79,388.27920155997373,98.47]
[]
[null,"SERVICIOS CONTRATADOS",472.74,907.93768627078077,678.83]
[]
[null,"GASTOS VARIOS",279.81,40.502556276319297,188.82]
[]
[null,"AMORTIZACIÓN",906.2,669.4815271168128,119.73]
[]
[]
[]
[null,"TOTAL",3882.7700000000004,2721.5100024102194,3011.03]
[]
[]
[null,"2.CONEXIONES (promedio anual)",10534,8298]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.5,1.66,0]
[]
[null,"3.3 TOTAL",1.47,1.62]
[]
[]
[null,"4.M3 ELEVADOS",2120330]
[]
[null,"5.M3 FACTURADOS",1230640]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",6.82]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",11.75]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",63.32]
[]
[null,"6.4 TOTAL/M3FACT",65.209999999999994]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26.08]
[]
[null,"7.2 FIJO/CONEXIONES",140.38]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.12]
[]
[null,"7.4 TOTAL/M3FACT",44.24]

{"sheet":"A-SOR-304","index":40,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["SORIANO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",56452304,14391422,21477460,92321186,null,null,92321186]
["       Ingresos Fijos",27705189,9471862,13350628,50527679,null,null,50527679]
["    INGRESOS DE EXPLOTACION",84157493,23863284,34828088,142848865,null,null,142848865]
["       Ingresos Alcantarillado",null,null,null,null,48903246,null,48903246]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",3624323,780294,2009813,6414430,2898,0,6417328]
["   TOTAL ING. DE EXPLOTACION",87781816,24643578,36837901,149263295,48906144,0,198169439]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",18891336,4638955,7618267,31148558,1696582,0,32845140]
["       Costo Operativo Fijo",29672808,19149140,15597939,64419887,15465170,0,79885057]
["    TOTAL OPERATIVO",48564144,23788095,23216206,95568445,17161752,0,112730197]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",18949914,6572446,9154283,34676643,8123741,0,42800384]
["       Comercial Asignados",7549012,2119285,3167966,12836263,4205804,0,17042067]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",26498926,8691731,12322249,47512906,12329545,0,59842451]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",5653953,1960975,2731299,10346227,2423824,0,12770051]
["       Administ. Asignados",12074306,3389701,5067019,20531026,6726994,0,27258020]
["       Gastos Fiscales",4526222,1270677,1899443,7696342,2521708,0,10218050]
["    TOTAL ADMINISTRACION",22254481,6621353,9697761,38573595,11672526,0,50246121]
["    TOTAL NO OPERATIVO",48753407,15313084,22020010,86086501,24002071,0,110088572]
["  COSTO DE EXPLOTACION",97317551,39101179,45236216,181654946,41163823,0,222818769]
["  RESULTADO DE EXPLOTACION",-9535735,-14457601,-8398315,-32391651,7742321,0,-24649330]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1404235,394220,589292,2387747,782346,0,3170093]
["       Gtos. Div. y Extraor",216574,60800,90886,368260,120661,0,488921]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1187661,333420,498406,2019487,661685,0,2681172]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",3003443,843177,1260404,5107024,1673317,0,6780341]
["       Gastos Financieros",14051881,3944879,5896914,23893674,7828766,0,31722440]
["   RESULTADO FINANCIERO",-11048438,-3101702,-4636510,-18786650,-6155449,0,-24942099]
["    I.R.A.E.",-10321980,-2897759,-4331650,-17551389,-5750716,null,-23302105]
[" RESULTADO NETO",-9074532,-14328124,-8204769,-31607425,7999273,0,-23608152]

{"sheet":"B-SOR-304","index":41,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["S O R I A N O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",30923283.761246707,3232343.0197970727,34155626.781043783]
[]
[null,"MATERIALES Y SUMINISTROS",14871927.025148313,231626.78984286258,15103553.814991176]
[]
[null,"ENERGIA Y FLUÍDOS",12069138.176224044,423315.79882944206,12492453.975053485]
[]
[null,"SERVICIOS CONTRATADOS",8509592.1093948819,4429080.2304610433,12938672.339855924]
[]
[null,"GASTOS VARIOS",4941822.0255032117,153541.45467069276,5095363.4801739044]
[]
[null,"AMORTIZACIÓN",24252681.902482837,8691844.7063988876,32944526.608881727]
[]
[]
[null,"TOTAL",95568445,17161752,112730197,null,0.66981446035211556]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",22922762.868036684,6297905.0367415939,29220667.904778279]
[]
[null,"MATERIALES Y SUMINISTROS",1845835.100345372,183745.50762215778,2029580.6079675297]
[]
[null,"ENERGIA Y FLUÍDOS",126044.3253005974,2261161.8044808013,2387206.1297813989]
[]
[null,"SERVICIOS CONTRATADOS",12984905.025818832,2665491.4281949955,15650396.454013828]
[]
[null,"GASTOS VARIOS",3050728.5338459695,563339.34810296621,3614067.8819489358]
[]
[null,"AMORTIZACIÓN",1870108.1466525488,798407.87485748471,2668516.0215100334]
[]
[]
[]
[null,"TOTAL",42800384.000000007,12770051.000000002,55570435,null,0.33018553964788439]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,168300632]

{"sheet":"C-SOR-304","index":42,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["S O R I A N O "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",977.66,218.12153450280536,923.83]
[]
[null,"MATERIALES Y SUMINISTROS",470.18,15.630392728447438,64.17]
[]
[null,"ENERGIA Y FLUÍDOS",381.57,28.565746597573526,75.47]
[]
[null,"SERVICIOS CONTRATADOS",269.04000000000002,298.87848238484668,494.8]
[]
[null,"GASTOS VARIOS",156.24,10.361121173540237,114.26]
[]
[null,"AMORTIZACIÓN",766.76,586.53382187724458,84.37]
[]
[]
[]
[null,"TOTAL",3021.45,1158.0910992644579,1756.9]
[]
[]
[null,"2.CONEXIONES (promedio anual)",31630,14819]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.22,0.84,0]
[]
[null,"3.3 TOTAL",1.2,0.84]
[]
[]
[null,"4.M3 ELEVADOS",6196030]
[]
[null,"5.M3 FACTURADOS",3480910]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.03]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.9499999999999993]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",52.19]
[]
[null,"6.4 TOTAL/M3FACT",54.11]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26.52]
[]
[null,"7.2 FIJO/CONEXIONES",133.12]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.88]
[]
[null,"7.4 TOTAL/M3FACT",45.03]

{"sheet":"A-100-AG-LITORAL NORTE","index":43,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["AMBITO GEOGRAFICO LITORAL NORTE","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",142212470,40992015,181088690,364293175,null,null,364293175]
["       Ingresos Fijos",69945589,22503584,94554899,187004072,null,null,187004072]
["    INGRESOS DE EXPLOTACION",212158059,63495599,275643589,551297247,null,null,551297247]
["       Ingresos Alcantarillado",null,null,null,null,225454479,null,225454479]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",15415153,3410161,16888704,35714018,120285,1721,35836024]
["   TOTAL ING. DE EXPLOTACION",227573212,66905760,292532293,587011265,225574764,1721,812587750]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",39704635,14217975,59894540,113817150,18080362,0,131897512]
["       Costo Operativo Fijo",73572805,56082768,122681145,252336718,43518008,0,295854726]
["    TOTAL OPERATIVO",113277440,70300743,182575685,366153868,61598370,0,427752238]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",53185932,24479597,84047714,161713243,46042747,0,207755990]
["       Comercial Asignados",19570715,5753725,25157031,50481471,19398854,0,69880325]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",72756647,30233322,109204745,212194714,65441601,0,277636315]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",13865685,5670300,23236434,42772419,12371784,0,55144203]
["       Administ. Asignados",31302482,9202824,40237542,80742848,31027597,0,111770445]
["       Gastos Fiscales",11734172,3449807,15083604,30267583,11631127,0,41898710]
["    TOTAL ADMINISTRACION",56902339,18322931,78557580,153782850,55030508,0,208813358]
["    TOTAL NO OPERATIVO",129658986,48556253,187762325,365977564,120472109,0,486449673]
["  COSTO DE EXPLOTACION",242936426,118856996,370338010,732131432,182070479,0,914201911]
["  RESULTADO DE EXPLOTACION",-15363214,-51951236,-77805717,-145120167,43504285,1721,-101614161]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",3640463,1070284,4679606,9390353,3608495,0,12998848]
["       Gtos. Div. y Extraor",561466,165069,721732,1448267,556535,0,2004802]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",3078997,905215,3957874,7942086,3051960,0,10994046]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",7786386,2289171,10008952,20084509,7718010,0,27802519]
["       Gastos Financieros",36429319,10710097,46827797,93967213,36109412,0,130076625]
["   RESULTADO FINANCIERO",-28642933,-8420926,-36818845,-73882704,-28391402,0,-102274106]
["    I.R.A.E.",-26759599,-7867232,-34397928,-69024759,-26524608,null,-95549367]
[" RESULTADO NETO",-14167551,-51599715,-76268760,-142036026,44689451,1721,-97344854]

{"sheet":"B-100-AG-LITORAL NORTE","index":44,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["AMBITO GEOGRAFICO LITORAL NORTE"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",112359121.50328676,9030459.6867012549,121389581.18998802]
[]
[null,"MATERIALES Y SUMINISTROS",46387601.188082755,990675.40927207214,47378276.597354829]
[]
[null,"ENERGIA Y FLUÍDOS",55263719.356015258,5458104.4943236541,60721823.850338914]
[]
[null,"SERVICIOS CONTRATADOS",37364270.813368633,19381663.656225521,56745934.469594151]
[]
[null,"GASTOS VARIOS",18526236.143934987,826458.58465147321,19352694.728586461]
[]
[null,"AMORTIZACIÓN",96252918.995311603,25911008.168826021,122163927.16413763]
[]
[]
[null,"TOTAL",366153868,61598369.999999993,427752238,null,0.61934515655096567]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",21432410.533402745,102995753.1213963,124428163.65479904]
[]
[null,"MATERIALES Y SUMINISTROS",1565887.6411061364,9425127.8071761411,10991015.448282277]
[]
[null,"ENERGIA Y FLUÍDOS",10053537.663065074,633226.41224799375,10686764.075313067]
[]
[null,"SERVICIOS CONTRATADOS",11925094.571927316,64211032.472874686,76136127.04480201]
[]
[null,"GASTOS VARIOS",3726853.0824258998,18535801.259733908,22262654.342159808]
[]
[null,"AMORTIZACIÓN",6440419.5080728307,11955048.92657098,18395468.434643812]
[]
[]
[]
[null,"TOTAL",55144203,207755990.00000003,262900193,null,0.38065484344903433]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,690652431]

{"sheet":"C-100-AG-LITORAL NORTE","index":45,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["A M B I T O   G E O G R A F I C O  L I T O R A L   N O R T E "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",942.99,129.8898177133257,1044.28]
[]
[null,"MATERIALES Y SUMINISTROS",389.31,14.249401778839999,92.24]
[]
[null,"ENERGIA Y FLUÍDOS",463.81,78.506767365566631,89.69]
[]
[null,"SERVICIOS CONTRATADOS",313.58,278.77659018792821,638.98]
[]
[null,"GASTOS VARIOS",155.47999999999999,11.887385430232341,186.84]
[]
[null,"AMORTIZACIÓN",807.82,372.69156217746422,154.38999999999999]
[]
[]
[]
[null,"TOTAL",3072.9900000000002,886.00152465335714,2206.42]
[]
[]
[null,"2.CONEXIONES (promedio anual)",119152,69524]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.25,0.81,0]
[]
[null,"3.3 TOTAL",1.23,0.81]
[]
[]
[null,"4.M3 ELEVADOS",31619880]
[]
[null,"5.M3 FACTURADOS",14763090]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.6]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.71]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",49.59]
[]
[null,"6.4 TOTAL/M3FACT",51.38]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",24.68]
[]
[null,"7.2 FIJO/CONEXIONES",130.79]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",39.76]
[]
[null,"7.4 TOTAL/M3FACT",41.76]

{"sheet":"A-PAY-101","index":46,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["PAYSANDU","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",110135058,12852504,0,122987562,null,null,122987562]
["       Ingresos Fijos",54322882,7095539,0,61418421,null,null,61418421]
["    INGRESOS DE EXPLOTACION",164457940,19948043,0,184405983,null,null,184405983]
["       Ingresos Alcantarillado",null,null,null,null,74191042,null,74191042]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",13054315,847175,0,13901490,13860,0,13915350]
["   TOTAL ING. DE EXPLOTACION",177512255,20795218,0,198307473,74204902,0,272512375]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",27463398,5191972,0,32655370,9367089,0,42022459]
["       Costo Operativo Fijo",52337147,20117739,0,72454886,4797092,0,77251978]
["    TOTAL OPERATIVO",79800545,25309711,0,105110256,14164181,0,119274437]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",34229291,5202541,0,39431832,11688102,0,51119934]
["       Comercial Asignados",15265601,1788336,0,17053937,6381432,0,23435369]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",49494892,6990877,0,56485769,18069534,0,74555303]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",9906548,1505705,0,11412253,3382739,0,14794992]
["       Administ. Asignados",24416644,2860363,0,27277007,10206815,0,37483822]
["       Gastos Fiscales",9152920,1072247,0,10225167,3826167,0,14051334]
["    TOTAL ADMINISTRACION",43476112,5438315,0,48914427,17415721,0,66330148]
["    TOTAL NO OPERATIVO",92971004,12429192,0,105400196,35485255,0,140885451]
["  COSTO DE EXPLOTACION",172771549,37738903,0,210510452,49649436,0,260159888]
["  RESULTADO DE EXPLOTACION",4740706,-16943685,0,-12202979,24555466,0,12352487]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",2839644,332659,0,3172303,1187048,0,4359351]
["       Gtos. Div. y Extraor",437956,51306,0,489262,183077,0,672339]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",2401688,281353,0,2683041,1003971,0,3687012]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",6073558,711506,0,6785064,2538911,0,9323975]
["       Gastos Financieros",28415693,3328844,0,31744537,11878525,0,43623062]
["   RESULTADO FINANCIERO",-22342135,-2617338,0,-24959473,-9339614,0,-34299087]
["    I.R.A.E.",-20873093,-2445243,0,-23318336,-8725515,null,-32043851]
[" RESULTADO NETO",5673352,-16834427,0,-11161075,24945338,0,13784263]

{"sheet":"B-PAY-101","index":47,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["P AY S AN D U"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",33539071.805892255,183053.66,33722125.465892255]
[]
[null,"MATERIALES Y SUMINISTROS",12877832.726873325,163605.72999999998,13041438.456873326]
[]
[null,"ENERGIA Y FLUÍDOS",17273300.163309917,1414237.34,18687537.503309917]
[]
[null,"SERVICIOS CONTRATADOS",6302087.5263604363,8715701.7100000009,15017789.236360438]
[]
[null,"GASTOS VARIOS",6396624.8589180177,127035.03000000001,6523659.888918018]
[]
[null,"AMORTIZACIÓN",28721338.918646049,3560547.53,32281886.44864605]
[]
[]
[null,"TOTAL",105110256,14164181,119274437.00000001,null,0.64406742950997675]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",23868972.346553732,3808228.946923024,27677201.293476757]
[]
[null,"MATERIALES Y SUMINISTROS",2418400.608414324,568083.32120811415,2986483.9296224383]
[]
[null,"ENERGIA Y FLUÍDOS",63371.11635009163,2714621.7300157393,2777992.8463658309]
[]
[null,"SERVICIOS CONTRATADOS",16745405.049427208,5138305.0179883633,21883710.067415573]
[]
[null,"GASTOS VARIOS",4398373.1362681976,837236.07877000165,5235609.215038199]
[]
[null,"AMORTIZACIÓN",3625411.74298645,1728516.905094757,5353928.6480812067]
[]
[]
[]
[null,"TOTAL",51119934.000000007,14794992,65914926.000000007,null,0.35593257049002319]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,185189363.00000003]

{"sheet":"C-PAY-101","index":48,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["P  A Y S A N D U "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",894.49,8.2356440365321451,738.16]
[]
[null,"MATERIALES Y SUMINISTROS",343.45,7.3606753048094653,79.650000000000006]
[]
[null,"ENERGIA Y FLUÍDOS",460.68,63.627000494893601,74.09]
[]
[null,"SERVICIOS CONTRATADOS",168.08,392.12227066180776,583.64]
[]
[null,"GASTOS VARIOS",170.6,5.7153475502766913,139.63]
[]
[null,"AMORTIZACIÓN",766,160.19019795743915,142.79]
[]
[]
[]
[null,"TOTAL",2803.3,637.25113600575878,1757.96]
[]
[]
[null,"2.CONEXIONES (promedio anual)",37495,22227]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.06,0.67,0]
[]
[null,"3.3 TOTAL",1.05,0.68]
[]
[]
[null,"4.M3 ELEVADOS",10898900]
[]
[null,"5.M3 FACTURADOS",4862090]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",6.72]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",43.3]
[]
[null,"6.4 TOTAL/M3FACT",45.13]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",25.3]
[]
[null,"7.2 FIJO/CONEXIONES",136.5]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",40.79]
[]
[null,"7.4 TOTAL/M3FACT",42.83]

{"sheet":"A-RN-102","index":49,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["RIO NEGRO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",32077411,22991186,2557940,57626537,null,null,57626537]
["       Ingresos Fijos",15622707,12508750,1531637,29663094,null,null,29663094]
["    INGRESOS DE EXPLOTACION",47700118,35499936,4089577,87289631,null,null,87289631]
["       Ingresos Alcantarillado",null,null,null,null,32261968,null,32261968]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",2360838,2139312,187095,4687245,2180,0,4689425]
["   TOTAL ING. DE EXPLOTACION",50060956,37639248,4276672,91976876,32264148,0,124241024]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",12241237,7610958,318364,20170559,2828698,0,22999257]
["       Costo Operativo Fijo",21235658,26576392,3226556,51038606,9082784,0,60121390]
["    TOTAL OPERATIVO",33476895,34187350,3544920,71209165,11911482,0,83120647]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",18956641,16092029,2010010,37058680,9974349,0,47033029]
["       Comercial Asignados",4305114,3236879,367783,7909776,2774634,0,10684410]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",23261755,19328908,2377793,44968456,12748983,0,57717439]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",3959137,3360857,419795,7739789,2083165,0,9822954]
["       Administ. Asignados",6885837,5177243,588252,12651332,4437903,0,17089235]
["       Gastos Fiscales",2581252,1940762,220515,4742529,1663610,0,6406139]
["    TOTAL ADMINISTRACION",13426226,10478862,1228562,25133650,8184678,0,33318328]
["    TOTAL NO OPERATIVO",36687981,29807770,3606355,70102106,20933661,0,91035767]
["  COSTO DE EXPLOTACION",70164876,63995120,7151275,141311271,32845143,0,174156414]
["  RESULTADO DE EXPLOTACION",-20103920,-26355872,-2874603,-49334395,-580995,0,-49915390]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",800820,602111,68413,1471344,516127,0,1987471]
["       Gtos. Div. y Extraor",123510,92863,10551,226924,79602,0,306526]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",677310,509248,57862,1244420,436525,0,1680945]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",1712829,1287822,146326,3146977,1103913,0,4250890]
["       Gastos Financieros",8013626,6025191,684599,14723416,5164760,0,19888176]
["   RESULTADO FINANCIERO",-6300797,-4737369,-538273,-11576439,-4060847,0,-15637286]
["    I.R.A.E.",-5886506,-4425878,-502880,-10815264,-3793837,null,-14609101]
[" RESULTADO NETO",-19840901,-26158115,-2852134,-48851150,-411480,0,-49262630]

{"sheet":"B-RN-102","index":50,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
[" R I O  N E G R O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",25019448.14957289,3865229.1429245472,28884677.292497437]
[]
[null,"MATERIALES Y SUMINISTROS",6936064.7933701146,215093.0403488861,7151157.8337190012]
[]
[null,"ENERGIA Y FLUÍDOS",11189279.845517103,1968392.4230796071,13157672.268596709]
[]
[null,"SERVICIOS CONTRATADOS",6967587.1243806984,1712918.2792436699,8680505.4036243688]
[]
[null,"GASTOS VARIOS",4632203.5186292026,332172.56566695101,4964376.0842961539]
[]
[null,"AMORTIZACIÓN",16464581.568529991,3817676.5487363399,20282258.117266331]
[]
[]
[null,"TOTAL",71209165,11911482.000000002,83120647,null,0.5938180323386838]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",22703769.158237271,3016777.2087528706,25720546.366990142]
[]
[null,"MATERIALES Y SUMINISTROS",2122301.7335643508,416692.34244018496,2538994.0760045359]
[]
[null,"ENERGIA Y FLUÍDOS",168707.31348570072,2405324.3602314517,2574031.6737171523]
[]
[null,"SERVICIOS CONTRATADOS",15625285.951533435,1922747.8013312602,17548033.752864696]
[]
[null,"GASTOS VARIOS",4879764.8168194052,492833.46621236764,5372598.2830317728]
[]
[null,"AMORTIZACIÓN",1533200.0263598498,1568578.8210318643,3101778.8473917143]
[]
[]
[]
[null,"TOTAL",47033029.000000015,9822954,56855983.000000022,null,0.40618196766131609]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,139976630.00000003]

{"sheet":"C-RN-102","index":51,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["R I O    N E G R O "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1344.91,386.02108687951136,1382.6]
[]
[null,"MATERIALES Y SUMINISTROS",372.85,21.481378243172486,136.47999999999999]
[]
[null,"ENERGIA Y FLUÍDOS",601.48,196.58368351938552,138.37]
[]
[null,"SERVICIOS CONTRATADOS",374.54,171.06943765541496,943.29]
[]
[null,"GASTOS VARIOS",249,33.17413019743843,288.8]
[]
[null,"AMORTIZACIÓN",885.05,381.2720012719804,166.74]
[]
[]
[]
[null,"TOTAL",3827.83,1189.6017177669032,3056.2799999999997]
[]
[]
[null,"2.CONEXIONES (promedio anual)",18603,10013]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.54,1.02,0]
[]
[null,"3.3 TOTAL",1.51,1.01]
[]
[]
[null,"4.M3 ELEVADOS",3848630]
[]
[null,"5.M3 FACTURADOS",2231570]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.24]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",9.0399999999999991]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",63.32]
[]
[null,"6.4 TOTAL/M3FACT",65.180000000000007]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",25.82]
[]
[null,"7.2 FIJO/CONEXIONES",132.88]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",41.22]
[]
[null,"7.4 TOTAL/M3FACT",43.29]

{"sheet":"A-SAL-103","index":52,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["SALTO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",0,0,109953765,109953765,null,null,109953765]
["       Ingresos Fijos",0,0,58489836,58489836,null,null,58489836]
["    INGRESOS DE EXPLOTACION",0,0,168443601,168443601,null,null,168443601]
["       Ingresos Alcantarillado",null,null,null,null,82018196,null,82018196]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",0,0,10498999,10498999,65619,1721,10566339]
["   TOTAL ING. DE EXPLOTACION",0,0,178942600,178942600,82083815,1721,261028136]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",0,0,39129984,39129984,532830,0,39662814]
["       Costo Operativo Fijo",0,0,73062396,73062396,13084531,0,86146927]
["    TOTAL OPERATIVO",0,0,112192380,112192380,13617361,0,125809741]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",0,0,44886360,44886360,15995928,0,60882288]
["       Comercial Asignados",0,0,15388607,15388607,7058999,0,22447606]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",0,0,60274967,60274967,23054927,0,83329894]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",0,0,13441538,13441538,4790094,0,18231632]
["       Administ. Asignados",0,0,24613387,24613387,11290552,0,35903939]
["       Gastos Fiscales",0,0,9226671,9226671,4232421,0,13459092]
["    TOTAL ADMINISTRACION",0,0,47281596,47281596,20313067,0,67594663]
["    TOTAL NO OPERATIVO",0,0,107556563,107556563,43367994,0,150924557]
["  COSTO DE EXPLOTACION",0,0,219748943,219748943,56985355,0,276734298]
["  RESULTADO DE EXPLOTACION",0,0,-40806343,-40806343,25098460,1721,-15706162]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",0,0,2862525,2862525,1313085,0,4175610]
["       Gtos. Div. y Extraor",0,0,441485,441485,202516,0,644001]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",0,0,2421040,2421040,1110569,0,3531609]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",0,0,6122497,6122497,2808487,0,8930984]
["       Gastos Financieros",0,0,28644659,28644659,13139760,0,41784419]
["   RESULTADO FINANCIERO",0,0,-22522162,-22522162,-10331273,0,-32853435]
["    I.R.A.E.",0,0,-21041283,-21041283,-9651971,null,-30693254]
[" RESULTADO NETO",0,0,-39866182,-39866182,25529727,1721,-14334734]

{"sheet":"B-SAL-103","index":53,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["S A  L T O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",26018655.793233268,-635590.72442790878,25383065.068805359]
[]
[null,"MATERIALES Y SUMINISTROS",18843648.91787285,216918.07402999283,19060566.991902843]
[]
[null,"ENERGIA Y FLUÍDOS",15464108.407878859,273608.57398146251,15737716.981860321]
[]
[null,"SERVICIOS CONTRATADOS",15709415.255087085,3471077.4803291773,19180492.735416263]
[]
[null,"GASTOS VARIOS",3131392.3769268529,116933.04529917988,3248325.4222260327]
[]
[null,"AMORTIZACIÓN",33025159.249001104,10174414.550788091,43199573.799789198]
[]
[]
[null,"TOTAL",112192380.00000003,13617360.999999996,125809741,null,0.61393467394670442]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",30188039.253494728,8990265.8404292576,39178305.093923986]
[]
[null,"MATERIALES Y SUMINISTROS",2490481.4154842431,338238.53823716257,2828719.9537214055]
[]
[null,"ENERGIA Y FLUÍDOS",74406.013291852723,2703496.4825031497,2777902.4957950022]
[]
[null,"SERVICIOS CONTRATADOS",18085956.073571708,2898738.0681759124,20984694.14174762]
[]
[null,"GASTOS VARIOS",5416625.2314208467,1329384.3956497787,6746009.6270706253]
[]
[null,"AMORTIZACIÓN",4626780.0127366222,1971508.6750047409,6598288.6877413634]
[]
[]
[]
[null,"TOTAL",60882288,18231632,79113920,null,0.38606532605329552]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,204923661]

{"sheet":"C-SAL-103","index":54,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["S A L T O "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",697.89,-23.920466840838085,1050.8599999999999]
[]
[null,"MATERIALES Y SUMINISTROS",505.44,8.1637151040605485,75.87]
[]
[null,"ENERGIA Y FLUÍDOS",414.79,10.297262955156468,74.510000000000005]
[]
[null,"SERVICIOS CONTRATADOS",421.37,130.6340551853215,562.86]
[]
[null,"GASTOS VARIOS",83.99,4.4007769861570845,180.95]
[]
[null,"AMORTIZACIÓN",885.82,382.91425052832381,176.98]
[]
[]
[]
[null,"TOTAL",3009.2999999999997,512.4895939181813,2122.0299999999997]
[]
[]
[null,"2.CONEXIONES (promedio anual)",37282,26571]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.23,0.69,0]
[]
[null,"3.3 TOTAL",1.21,0.7]
[]
[]
[null,"4.M3 ELEVADOS",10760130]
[]
[null,"5.M3 FACTURADOS",4586350]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.64]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.5299999999999994]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",47.91]
[]
[null,"6.4 TOTAL/M3FACT",49.67]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",23.97]
[]
[null,"7.2 FIJO/CONEXIONES",130.74]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",39.020000000000003]
[]
[null,"7.4 TOTAL/M3FACT",40.98]

{"sheet":"A-ART-104","index":55,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["ARTIGAS","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",0,5148325,68576984,73725309,null,null,73725309]
["       Ingresos Fijos",0,2899296,34533426,37432722,null,null,37432722]
["    INGRESOS DE EXPLOTACION",0,8047621,103110410,111158031,null,null,111158031]
["       Ingresos Alcantarillado",null,null,null,null,36983273,null,36983273]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",0,423673,6202610,6626283,38626,0,6664909]
["   TOTAL ING. DE EXPLOTACION",0,8471294,109313020,117784314,37021899,0,154806213]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",0,1415045,20446192,21861237,5351745,0,27212982]
["       Costo Operativo Fijo",0,9388636,46392193,55780829,16553602,0,72334431]
["    TOTAL OPERATIVO",0,10803681,66838385,77642066,21905347,0,99547413]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",0,3185027,37151344,40336371,8384368,0,48720739]
["       Comercial Asignados",0,728510,9400641,10129151,3183789,0,13312940]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",0,3913537,46551985,50465522,11568157,0,62033679]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",0,803738,9375101,10178839,2115786,0,12294625]
["       Administ. Asignados",0,1165219,15035903,16201122,5092327,0,21293449]
["       Gastos Fiscales",0,436798,5636418,6073216,1908930,0,7982146]
["    TOTAL ADMINISTRACION",0,2405755,30047422,32453177,9117043,0,41570220]
["    TOTAL NO OPERATIVO",0,6319292,76599407,82918699,20685200,0,103603899]
["  COSTO DE EXPLOTACION",0,17122973,143437792,160560765,42590547,0,203151312]
["  RESULTADO DE EXPLOTACION",0,-8651679,-34124772,-42776451,-5568648,0,-48345099]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",0,135514,1748668,1884182,592235,0,2476417]
["       Gtos. Div. y Extraor",0,20900,269696,290596,91340,0,381936]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",0,114614,1478972,1593586,500895,0,2094481]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",0,289844,3740130,4029974,1266699,0,5296673]
["       Gastos Financieros",0,1356062,17498539,18854601,5926368,0,24780969]
["   RESULTADO FINANCIERO",0,-1066218,-13758409,-14824627,-4659669,0,-19484296]
["    I.R.A.E.",0,-996112,-12853765,-13849877,-4353286,null,-18203163]
[" RESULTADO NETO",0,-8607171,-33550444,-42157615,-5374136,0,-47531751]

{"sheet":"B-ART-104","index":56,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["A R T I G A S "]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",27781945.754588351,5617767.6082046172,33399713.362792969]
[]
[null,"MATERIALES Y SUMINISTROS",7730054.7499664687,395058.56489319319,8125113.3148596622]
[]
[null,"ENERGIA Y FLUÍDOS",11337030.939309387,1801866.1572625847,13138897.096571971]
[]
[null,"SERVICIOS CONTRATADOS",8385180.9075404182,5481966.1866526715,13867147.09419309]
[]
[null,"GASTOS VARIOS",4366015.3894609129,250317.9436853423,4616333.3331462555]
[]
[null,"AMORTIZACIÓN",18041838.259134468,8358370.5393015919,26400208.798436061]
[]
[]
[null,"TOTAL",77642066.000000015,21905347,99547413,null,0.61999060342609791]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",26234972.363110576,5617138.5372975925,31852110.900408167]
[]
[null,"MATERIALES Y SUMINISTROS",2393944.0497132256,242873.43922067466,2636817.4889339004]
[]
[null,"ENERGIA Y FLUÍDOS",326741.96912034869,2230095.0903147329,2556837.0594350817]
[]
[null,"SERVICIOS CONTRATADOS",13754385.398342337,1965303.6844317794,15719689.082774118]
[]
[null,"GASTOS VARIOS",3841038.0752254594,1067399.1417937519,4908437.2170192115]
[]
[null,"AMORTIZACIÓN",2169657.1444880562,1171815.1069414685,3341472.2514295247]
[]
[]
[]
[null,"TOTAL",48720739.000000007,12294625,61015364.000000015,null,0.38000939657390215]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,160562777]

{"sheet":"C-ART-104","index":57,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["A R T I G A S "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1077.99,524.38790331416192,1235.92]
[]
[null,"MATERIALES Y SUMINISTROS",299.94,36.876557910313934,102.31]
[]
[null,"ENERGIA Y FLUÍDOS",439.9,168.19435800080134,99.21]
[]
[null,"SERVICIOS CONTRATADOS",325.36,511.71158281085332,609.95000000000005]
[]
[null,"GASTOS VARIOS",169.41,23.365811974735582,190.46]
[]
[null,"AMORTIZACIÓN",700.06,780.20820865318694,129.66]
[]
[]
[]
[null,"TOTAL",3012.66,2044.7444226640532,2367.5099999999998]
[]
[]
[null,"2.CONEXIONES (promedio anual)",25772,10713]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.36,1.1499999999999999,0]
[]
[null,"3.3 TOTAL",1.34,1.1399999999999999]
[]
[]
[null,"4.M3 ELEVADOS",6112220]
[]
[null,"5.M3 FACTURADOS",3083080]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.58]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.09]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",52.08]
[]
[null,"6.4 TOTAL/M3FACT",53.8]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",23.91]
[]
[null,"7.2 FIJO/CONEXIONES",121.04]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",38.200000000000003]
[]
[null,"7.4 TOTAL/M3FACT",40.119999999999997]

{"sheet":"A-200-AG-NORESTE","index":58,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["AMBITO GEOGRAFICO NORESTE","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",76177178,11015264,194576493,281768935,null,null,281768935]
["       Ingresos Fijos",42690839,6586356,104986429,154263624,null,null,154263624]
["    INGRESOS DE EXPLOTACION",118868017,17601620,299562922,436032559,null,null,436032559]
["       Ingresos Alcantarillado",null,null,null,null,125860909,null,125860909]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",6258214,638046,18880017,25776277,71457,0,25847734]
["   TOTAL ING. DE EXPLOTACION",125126231,18239666,318442939,461808836,125932366,0,587741202]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",31711337,5035669,76605705,113352711,29253419,0,142606130]
["       Costo Operativo Fijo",63930779,21818878,177174294,262923951,108596178,0,371520129]
["    TOTAL OPERATIVO",95642116,26854547,253779999,376276662,137849597,0,514126259]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",64419037,9773272,119211216,193403525,40869451,0,234272976]
["       Comercial Asignados",10760537,1568565,27385280,39714382,10829862,0,50544244]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",75179574,11341837,146596496,233117907,51699313,0,284817220]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",10781426,1708826,32865607,45355859,9596622,0,54952481]
["       Administ. Asignados",17210996,2508849,43801527,63521372,17321879,0,80843251]
["       Gastos Fiscales",6451782,940477,16419613,23811872,6493348,0,30305220]
["    TOTAL ADMINISTRACION",34444204,5158152,93086747,132689103,33411849,0,166100952]
["    TOTAL NO OPERATIVO",109623778,16499989,239683243,365807010,85111162,0,450918172]
["  COSTO DE EXPLOTACION",205265894,43354536,493463242,742083672,222960759,0,965044431]
["  RESULTADO DE EXPLOTACION",-80139663,-25114870,-175020303,-280274836,-97028393,0,-377303229]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",2001630,291778,5094096,7387504,2014526,0,9402030]
["       Gtos. Div. y Extraor",308710,45001,785659,1139370,310699,0,1450069]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1692920,246777,4308437,6248134,1703827,0,7951961]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",4281177,624068,10895482,15800727,4308759,0,20109486]
["       Gastos Financieros",20029876,2919757,50975504,73925137,20158920,0,94084057]
["   RESULTADO FINANCIERO",-15748699,-2295689,-40080022,-58124410,-15850161,0,-73974571]
["    I.R.A.E.",-14713190,-2144743,-37444677,-54302610,-14807980,null,-69110590]
[" RESULTADO NETO",-79482252,-25019039,-173347211,-277848502,-96366747,0,-374215249]

{"sheet":"B-200-AG-NORESTE","index":59,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["AMBITO GEOGRAFICO NORESTE"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",133892117.50666566,29529262.003982317,163421379.51064798]
[]
[null,"MATERIALES Y SUMINISTROS",30840044.675686218,5833832.4804784618,36673877.156164676]
[]
[null,"ENERGIA Y FLUÍDOS",64645129.946017519,16954904.884575665,81600034.830593184]
[]
[null,"SERVICIOS CONTRATADOS",36350170.878687665,31352001.464305267,67702172.342992932]
[]
[null,"GASTOS VARIOS",16833380.231238991,1392855.3292083465,18226235.560447339]
[]
[null,"AMORTIZACIÓN",93715818.761703953,52786740.837449946,146502559.59915391]
[]
[]
[null,"TOTAL",376276662,137849597,514126259,null,0.63997654920052471]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",25882163.856487174,89397489.187200248,115279653.04368742]
[]
[null,"MATERIALES Y SUMINISTROS",1200207.4976535304,8655171.7133066244,9855379.2109601554]
[]
[null,"ENERGIA Y FLUÍDOS",9863994.9427367207,656713.50973439822,10520708.452471118]
[]
[null,"SERVICIOS CONTRATADOS",6873082.1992425453,103611980.89704204,110485063.09628458]
[]
[null,"GASTOS VARIOS",3927085.0368566164,23457880.601860769,27384965.638717387]
[]
[null,"AMORTIZACIÓN",7205947.4670234118,8493740.0908559095,15699687.557879321]
[]
[]
[]
[null,"TOTAL",54952480.999999993,234272975.99999994,289225457,null,0.36002345079947523]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,803351716]

{"sheet":"C-200-AG-NORESTE","index":60,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["A M B I T O   G E O G R A F I C O  N O R E S T E"]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1343.18,701.07459648580993,1156.46]
[]
[null,"MATERIALES Y SUMINISTROS",309.38,138.50504464573746,98.87]
[]
[null,"ENERGIA Y FLUÍDOS",648.51,402.53810267273661,105.54]
[]
[null,"SERVICIOS CONTRATADOS",364.66,744.34951244789329,1108.3599999999999]
[]
[null,"GASTOS VARIOS",168.87,33.068740009694835,274.72000000000003]
[]
[null,"AMORTIZACIÓN",940.14,1253.2464586289161,157.5]
[]
[]
[]
[null,"TOTAL",3774.7399999999993,3272.7824548907884,2901.45]
[]
[]
[null,"2.CONEXIONES (promedio anual)",99683,42120]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.61,1.77,0]
[]
[null,"3.3 TOTAL",1.57,1.73]
[]
[]
[null,"4.M3 ELEVADOS",22859160]
[]
[null,"5.M3 FACTURADOS",10810280]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",4.96]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",10.49]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",68.650000000000006]
[]
[null,"6.4 TOTAL/M3FACT",70.569999999999993]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26.06]
[]
[null,"7.2 FIJO/CONEXIONES",128.96]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.72]
[]
[null,"7.4 TOTAL/M3FACT",44.86]

{"sheet":"A-RIV-201","index":61,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["RIVERA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",0,6196016,87680975,93876991,null,null,93876991]
["       Ingresos Fijos",0,3721565,47506218,51227783,null,null,51227783]
["    INGRESOS DE EXPLOTACION",0,9917581,135187193,145104774,null,null,145104774]
["       Ingresos Alcantarillado",null,null,null,null,40184299,null,40184299]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",0,405668,9343078,9748746,28144,0,9776890]
["   TOTAL ING. DE EXPLOTACION",0,10323249,144530271,154853520,40212443,0,195065963]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",0,2678134,39530079,42208213,9035859,0,51244072]
["       Costo Operativo Fijo",0,5063179,86831417,91894596,54296686,0,146191282]
["    TOTAL OPERATIVO",0,7741313,126361496,134102809,63332545,0,197435354]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",0,5046793,56242238,61289031,12738235,0,74027266]
["       Comercial Asignados",0,887773,12429234,13317007,3458168,0,16775175]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",0,5934566,68671472,74606038,16196403,0,90802441]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",0,950640,10594080,11544720,2399440,0,13944160]
["       Administ. Asignados",0,1419953,19880003,21299956,5531184,0,26831140]
["       Gastos Fiscales",0,532289,7452296,7984585,2073441,0,10058026]
["    TOTAL ADMINISTRACION",0,2902882,37926379,40829261,10004065,0,50833326]
["    TOTAL NO OPERATIVO",0,8837448,106597851,115435299,26200468,0,141635767]
["  COSTO DE EXPLOTACION",0,16578761,232959347,249538108,89533013,0,339071121]
["  RESULTADO DE EXPLOTACION",0,-6255512,-88429076,-94684588,-49320570,0,-144005158]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",0,165139,2312035,2477174,643274,0,3120448]
["       Gtos. Div. y Extraor",0,25469,356583,382052,99212,0,481264]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",0,139670,1955452,2095122,544062,0,2639184]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",0,353209,4945083,5298292,1375863,0,6674155]
["       Gastos Financieros",0,1652518,23136024,24788542,6437102,0,31225644]
["   RESULTADO FINANCIERO",0,-1299309,-18190941,-19490250,-5061239,0,-24551489]
["    I.R.A.E.",0,-1213878,-16994848,-18208726,-4728451,null,-22937177]
[" RESULTADO NETO",0,-6201273,-87669717,-93870990,-49109296,0,-142980286]

{"sheet":"B-RIV-201","index":62,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["R I V E R A "]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",36447555.977463283,11199070.83873531,47646626.816198595]
[]
[null,"MATERIALES Y SUMINISTROS",6144434.2636014801,1403100.9357943272,7547535.1993958075]
[]
[null,"ENERGIA Y FLUÍDOS",27512634.208467811,4795119.0297089992,32307753.238176811]
[]
[null,"SERVICIOS CONTRATADOS",26623937.509235252,24008873.413824193,50632810.923059449]
[]
[null,"GASTOS VARIOS",4803784.396783106,738749.38821321784,5542533.7849963242]
[]
[null,"AMORTIZACIÓN",32570462.644449085,21187631.39372395,53758094.038173035]
[]
[]
[null,"TOTAL",134102809,63332545,197435354,null,0.69176826843426775]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",29662583.680430949,5354616.8396946462,35017200.520125598]
[]
[null,"MATERIALES Y SUMINISTROS",2582253.7025803952,268699.94026280585,2850953.6428432008]
[]
[null,"ENERGIA Y FLUÍDOS",143650.87930358667,3095845.2186676329,3239496.0979712196]
[]
[null,"SERVICIOS CONTRATADOS",29078415.9666753,1700617.3683635402,30779033.335038841]
[]
[null,"GASTOS VARIOS",9887153.3342707809,1183475.5139309464,11070628.848201727]
[]
[null,"AMORTIZACIÓN",2673208.4367389935,2340905.119080428,5014113.555819422]
[]
[]
[]
[null,"TOTAL",74027266,13944160,87971426,null,0.30823173156573225]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,285406780]

{"sheet":"C-RIV-201","index":63,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["R I V E R A "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1135.54,839.38471284180116,1090.98]
[]
[null,"MATERIALES Y SUMINISTROS",191.43,105.16421344583475,88.82]
[]
[null,"ENERGIA Y FLUÍDOS",857.17,359.40031702211058,100.93]
[]
[null,"SERVICIOS CONTRATADOS",829.48,1799.4958337448804,958.94]
[]
[null,"GASTOS VARIOS",149.66,55.37021347723114,344.91]
[]
[null,"AMORTIZACIÓN",1014.75,1588.0401284458064,156.22]
[]
[]
[]
[null,"TOTAL",4178.03,4746.8554189776651,2740.7999999999997]
[]
[]
[null,"2.CONEXIONES (promedio anual)",32097,13342]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.61,2.23,0]
[]
[null,"3.3 TOTAL",1.58,2.16]
[]
[]
[null,"4.M3 ELEVADOS",8219879.9999999991]
[]
[null,"5.M3 FACTURADOS",3623540]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.13]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",11.65]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",68.87]
[]
[null,"6.4 TOTAL/M3FACT",70.790000000000006]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",25.91]
[]
[null,"7.2 FIJO/CONEXIONES",133]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.74]
[]
[null,"7.4 TOTAL/M3FACT",44.88]

{"sheet":"A-TAC-202","index":64,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["TACUAREMBO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",2644611,0,91092275,93736886,null,null,93736886]
["       Ingresos Fijos",1840225,0,48241764,50081989,null,null,50081989]
["    INGRESOS DE EXPLOTACION",4484836,0,139334039,143818875,null,null,143818875]
["       Ingresos Alcantarillado",null,null,null,null,41981186,null,41981186]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",168133,0,8150668,8318801,43313,0,8362114]
["   TOTAL ING. DE EXPLOTACION",4652969,0,147484707,152137676,42024499,0,194162175]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",1743911,0,28666809,30410720,9011329,0,39422049]
["       Costo Operativo Fijo",9924634,0,59647025,69571659,24914939,0,94486598]
["    TOTAL OPERATIVO",11668545,0,88313834,99982379,33926268,0,133908647]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",1725495,0,46894198,48619693,10343978,0,58963671]
["       Comercial Asignados",400143,0,12683309,13083452,3614000,0,16697452]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",2125638,0,59577507,61703145,13957978,0,75661123]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",724611,0,19692935,20417546,4343891,0,24761437]
["       Administ. Asignados",640011,0,20286383,20926394,5780430,0,26706824]
["       Gastos Fiscales",239917,0,7604634,7844551,2166875,0,10011426]
["    TOTAL ADMINISTRACION",1604539,0,47583952,49188491,12291196,0,61479687]
["    TOTAL NO OPERATIVO",3730177,0,107161459,110891636,26249174,0,137140810]
["  COSTO DE EXPLOTACION",15398722,0,195475293,210874015,60175442,0,271049457]
["  RESULTADO DE EXPLOTACION",-10745753,0,-47990586,-58736339,-18150943,0,-76887282]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",74433,0,2359296,2433729,672261,0,3105990]
["       Gtos. Div. y Extraor",11480,0,363872,375352,103682,0,479034]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",62953,0,1995424,2058377,568579,0,2626956]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",159201,0,5046169,5205370,1437862,0,6643232]
["       Gastos Financieros",744835,0,23608962,24353797,6727171,0,31080968]
["   RESULTADO FINANCIERO",-585634,0,-18562793,-19148427,-5289309,0,-24437736]
["    I.R.A.E.",-547128,0,-17342251,-17889379,-4941525,null,-22830904]
[" RESULTADO NETO",-10721306,0,-47215704,-57937010,-17930148,0,-75867158]

{"sheet":"B-TAC-202","index":65,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["T A C U A R E M B O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",38112615.546448588,11536887.597141517,49649503.143590108]
[]
[null,"MATERIALES Y SUMINISTROS",11234031.496217426,2944675.1848946167,14178706.681112044]
[]
[null,"ENERGIA Y FLUÍDOS",16817372.679485977,5054215.6823176667,21871588.361803643]
[]
[null,"SERVICIOS CONTRATADOS",2599970.8289098982,1521457.3700846294,4121428.1989945276]
[]
[null,"GASTOS VARIOS",4409880.0691529904,411467.56931760919,4821347.6384705994]
[]
[null,"AMORTIZACIÓN",26808508.379785117,12457564.596243961,39266072.976029076]
[]
[]
[null,"TOTAL",99982379.000000015,33926268,133908647,null,0.61529355591001955]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",23829939.820935663,13873362.218495326,37703302.039430991]
[]
[null,"MATERIALES Y SUMINISTROS",2849886.4458621633,350038.93569303578,3199925.3815551992]
[]
[null,"ENERGIA Y FLUÍDOS",124700.78864691184,3281172.1169806914,3405872.9056276032]
[]
[null,"SERVICIOS CONTRATADOS",23561471.592323408,2786757.5778035801,26348229.170126989]
[]
[null,"GASTOS VARIOS",6039637.0740396418,1567345.5727715916,7606982.6468112338]
[]
[null,"AMORTIZACIÓN",2558035.2781922147,2902760.5782557772,5460795.8564479919]
[]
[]
[]
[null,"TOTAL",58963670.999999993,24761437,83725108.000000015,null,0.3847064440899805]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,217633755]

{"sheet":"C-TAC-202","index":66,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["T A C U A R E M B O "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1175.1500000000001,836.00634761895049,1162.53]
[]
[null,"MATERIALES Y SUMINISTROS",346.39,213.38225977497223,98.67]
[]
[null,"ENERGIA Y FLUÍDOS",518.54,366.24751321142514,105.02]
[]
[null,"SERVICIOS CONTRATADOS",80.17,110.25053406410358,812.41]
[]
[null,"GASTOS VARIOS",135.97,29.816490530261536,234.55]
[]
[null,"AMORTIZACIÓN",826.61,902.72207219159134,168.38]
[]
[]
[]
[null,"TOTAL",3082.83,2458.4252173913042,2581.5600000000004]
[]
[]
[null,"2.CONEXIONES (promedio anual)",32432,13800]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.39,1.43,0]
[]
[null,"3.3 TOTAL",1.36,1.41]
[]
[]
[null,"4.M3 ELEVADOS",7639480]
[]
[null,"5.M3 FACTURADOS",3604650]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.98]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",8.44]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",58.5]
[]
[null,"6.4 TOTAL/M3FACT",60.4]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26]
[]
[null,"7.2 FIJO/CONEXIONES",128.68]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.21]
[]
[null,"7.4 TOTAL/M3FACT",44.33]

{"sheet":"A-CL-204","index":67,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["CERRO LARGO","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",73532568,4819249,15803244,94155061,null,null,94155061]
["       Ingresos Fijos",40850615,2864790,9238449,52953854,null,null,52953854]
["    INGRESOS DE EXPLOTACION",114383183,7684039,25041693,147108915,null,null,147108915]
["       Ingresos Alcantarillado",null,null,null,null,43695424,null,43695424]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",6090080,232378,1386272,7708730,0,0,7708730]
["   TOTAL ING. DE EXPLOTACION",120473263,7916417,26427965,154817645,43695424,0,198513069]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",29967427,2357536,8408816,40733779,11206230,0,51940009]
["       Costo Operativo Fijo",54006144,16755701,30695853,101457698,29384550,0,130842248]
["    TOTAL OPERATIVO",83973571,19113237,39104669,142191477,40590780,0,182782257]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",62693542,4726479,16074779,83494800,17787239,0,101282039]
["       Comercial Asignados",10360394,680791,2272737,13313922,3757693,0,17071615]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",73053936,5407270,18347516,96808722,21544932,0,118353654]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",10056815,758185,2578591,13393591,2853290,0,16246881]
["       Administ. Asignados",16570985,1088896,3635141,21295022,6010265,0,27305287]
["       Gastos Fiscales",6211865,408187,1362681,7982733,2253027,0,10235760]
["    TOTAL ADMINISTRACION",32839665,2255268,7576413,42671346,11116582,0,53787928]
["    TOTAL NO OPERATIVO",105893601,7662538,25923929,139480068,32661514,0,172141582]
["  COSTO DE EXPLOTACION",189867172,26775775,65028598,281671545,73252294,0,354923839]
["  RESULTADO DE EXPLOTACION",-69393909,-18859358,-38600633,-126853900,-29556870,0,-156410770]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1927196,126639,422763,2476598,698989,0,3175587]
["       Gtos. Div. y Extraor",297231,19532,65202,381965,107805,0,489770]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1629965,107107,357561,2094633,591184,0,2685817]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",4121975,270857,904227,5297059,1495034,0,6792093]
["       Gastos Financieros",19285040,1267241,4230519,24782800,6994646,0,31777446]
["   RESULTADO FINANCIERO",-15163065,-996384,-3326292,-19485741,-5499612,0,-24985353]
["    I.R.A.E.",-14166060,-930864,-3107578,-18204502,-5138004,null,-23342506]
[" RESULTADO NETO",-68760949,-18817771,-38461786,-126040506,-29327294,0,-155367800]

{"sheet":"B-CL-204","index":68,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["C E R R O   L A R G O"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",59331945.982753798,6793303.5681054918,66125249.550859287]
[]
[null,"MATERIALES Y SUMINISTROS",13461578.915867312,1486056.3597895179,14947635.275656831]
[]
[null,"ENERGIA Y FLUÍDOS",20315123.058063731,7105570.1725489981,27420693.230612729]
[]
[null,"SERVICIOS CONTRATADOS",7126262.5405425113,5821670.6803964442,12947933.220938955]
[]
[null,"GASTOS VARIOS",7619715.7653028974,242638.37167751946,7862354.1369804172]
[]
[null,"AMORTIZACIÓN",34336850.737469755,19141540.847482033,53478391.584951788]
[]
[]
[null,"TOTAL",142191477,40590780,182782257,null,0.60864287112430715]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",35904965.685833648,6654184.7982972041,42559150.484130852]
[]
[null,"MATERIALES Y SUMINISTROS",3223031.5648640646,581468.62169768882,3804500.1865617535]
[]
[null,"ENERGIA Y FLUÍDOS",388361.84178389976,3486977.6070883963,3875339.4488722961]
[]
[null,"SERVICIOS CONTRATADOS",50972093.33804334,2385707.2530754246,53357800.591118768]
[]
[null,"GASTOS VARIOS",7531090.1935503464,1176263.9501540787,8707354.1437044255]
[]
[null,"AMORTIZACIÓN",3262496.3759247009,1962278.769687207,5224775.1456119083]
[]
[]
[]
[null,"TOTAL",101282039,16246881,117528920.00000001,null,0.39135712887569291]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,300311177]

{"sheet":"C-CL-204","index":69,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["C E R R O    L A R G O "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1687.77,453.55211430801791,1210.6500000000001]
[]
[null,"MATERIALES Y SUMINISTROS",382.93,99.215940698993052,108.22]
[]
[null,"ENERGIA Y FLUÍDOS",577.89,474.4004655193616,110.24]
[]
[null,"SERVICIOS CONTRATADOS",202.72,388.6814448121541,1517.83]
[]
[null,"GASTOS VARIOS",216.75,16.19965093320333,247.69]
[]
[null,"AMORTIZACIÓN",976.76,1277.9770895634954,148.63]
[]
[]
[]
[null,"TOTAL",4044.8199999999997,2710.0267058352256,3343.26]
[]
[]
[null,"2.CONEXIONES (promedio anual)",35154,14978]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.82,1.68,0]
[]
[null,"3.3 TOTAL",1.78,1.64]
[]
[]
[null,"4.M3 ELEVADOS",6999800]
[]
[null,"5.M3 FACTURADOS",3582090]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.82]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",11.37]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",78.63]
[]
[null,"6.4 TOTAL/M3FACT",80.58]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",26.28]
[]
[null,"7.2 FIJO/CONEXIONES",125.53]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",43.22]
[]
[null,"7.4 TOTAL/M3FACT",45.39]

{"sheet":"A-500-AG-SURESTE","index":70,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["AMBITO GEOGRAFICO SURESTE","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",154894049,44673025,22749149,222316223,null,null,222316223]
["       Ingresos Fijos",91570063,38518612,17885064,147973739,null,null,147973739]
["    INGRESOS DE EXPLOTACION",246464112,83191637,40634213,370289962,null,null,370289962]
["       Ingresos Alcantarillado",null,null,null,null,81974984,null,81974984]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",14193181,4764504,2404906,21362591,11016,0,21373607]
["   TOTAL ING. DE EXPLOTACION",260657293,87956141,43039119,391652553,81986000,0,473638553]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",49718948,17210643,10633306,77562897,16501591,0,94064488]
["       Costo Operativo Fijo",130143803,52287708,44984305,227415816,73346811,0,300762627]
["    TOTAL OPERATIVO",179862751,69498351,55617611,304978713,89848402,0,394827115]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",80120475,29750649,16096990,125968114,19134430,0,145102544]
["       Comercial Asignados",22415862,7564004,3701254,33681120,7050587,0,40731707]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",102536337,37314653,19798244,159649234,26185017,0,185834251]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",55740918,20153218,10722110,86616246,13043918,0,99660164]
["       Administ. Asignados",35853165,12098284,5919990,53871439,11277097,0,65148536]
["       Gastos Fiscales",13440059,4535211,2219191,20194461,4227377,0,24421838]
["    TOTAL ADMINISTRACION",105034142,36786713,18861291,160682146,28548392,0,189230538]
["    TOTAL NO OPERATIVO",207570479,74101366,38659535,320331380,54733409,0,375064789]
["  COSTO DE EXPLOTACION",387433230,143599717,94277146,625310093,144581811,0,769891904]
["  RESULTADO DE EXPLOTACION",-126775937,-55643576,-51238027,-233657540,-62595811,0,-296253351]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",4169706,1407025,688491,6265222,1311523,0,7576745]
["       Gtos. Div. y Extraor",643090,217003,106186,966279,202275,0,1168554]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",3526616,1190022,582305,5298943,1109248,0,6408191]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",8918354,3009408,1472577,13400339,2805139,0,16205478]
["       Gastos Financieros",41725331,14079787,6889588,62694706,13124103,0,75818809]
["   RESULTADO FINANCIERO",-32806977,-11070379,-5417011,-49294367,-10318964,0,-59613331]
["    I.R.A.E.",-30649850,-10342479,-5060831,-46053160,-9640470,null,-55693630]
[" RESULTADO NETO",-125406448,-55181454,-51011902,-231599804,-62165057,0,-293764861]

{"sheet":"B-500-AG-SURESTE","index":71,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["AMBITO GEOGRAFICO SURESTE"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",116493751.3173628,29192038.091738775,145685789.40910158]
[]
[null,"MATERIALES Y SUMINISTROS",22017510.918717153,2908544.4026948037,24926055.321411956]
[]
[null,"ENERGIA Y FLUÍDOS",44415668.733350307,9180592.0847411864,53596260.818091497]
[]
[null,"SERVICIOS CONTRATADOS",18350679.17859035,8294060.833225077,26644740.011815429]
[]
[null,"GASTOS VARIOS",12902704.281791788,3244138.6770817833,16146842.95887357]
[]
[null,"AMORTIZACIÓN",90798398.570187613,37029027.910518363,127827426.48070598]
[]
[]
[null,"TOTAL",304978713,89848402,394827115,null,0.61731300405635126]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",86849934.291993275,32129805.068415131,118979739.36040841]
[]
[null,"MATERIALES Y SUMINISTROS",6006250.5270560263,1478446.9616802898,7484697.4887363166]
[]
[null,"ENERGIA Y FLUÍDOS",361148.72447953199,9277982.2366391066,9639130.9611186385]
[]
[null,"SERVICIOS CONTRATADOS",34473462.740072802,12219745.230443588,46693207.970516391]
[]
[null,"GASTOS VARIOS",9152506.7936289888,12374126.350358171,21526633.14398716]
[]
[null,"AMORTIZACIÓN",8259240.9227693994,32180058.152463723,40439299.075233124]
[]
[]
[]
[null,"TOTAL",145102544,99660164,244762708.00000003,null,0.38268699594364874]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,639589823]

{"sheet":"C-500-AG-SURESTE","index":72,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["A M B I T O   G E O G R A F I C O  S U R E S T E "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1389.31,1063.7722502637846,1418.96]
[]
[null,"MATERIALES Y SUMINISTROS",262.58,105.988791002653,89.26]
[]
[null,"ENERGIA Y FLUÍDOS",529.70000000000005,334.54529862040619,114.96]
[]
[null,"SERVICIOS CONTRATADOS",218.85,302.23966304296613,556.87]
[]
[null,"GASTOS VARIOS",153.88,118.21801170037837,256.73]
[]
[null,"AMORTIZACIÓN",1082.8699999999999,1349.3560203526843,482.28]
[]
[]
[]
[null,"TOTAL",3637.19,3274.1200349828723,2919.0600000000004]
[]
[]
[null,"2.CONEXIONES (promedio anual)",83850,27442]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.6,1.76,0]
[]
[null,"3.3 TOTAL",1.56,1.72]
[]
[]
[null,"4.M3 ELEVADOS",13464320]
[]
[null,"5.M3 FACTURADOS",8008800]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.76]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",9.68]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",78.08]
[]
[null,"6.4 TOTAL/M3FACT",80.28]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",27.76]
[]
[null,"7.2 FIJO/CONEXIONES",147.06]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",48.9]
[]
[null,"7.4 TOTAL/M3FACT",51.36]

{"sheet":"A-ROC-502","index":73,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["ROCHA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",47194061,41090630,11576878,99861569,null,null,99861569]
["       Ingresos Fijos",29582976,36386218,11911922,77881116,null,null,77881116]
["    INGRESOS DE EXPLOTACION",76777037,77476848,23488800,177742685,null,null,177742685]
["       Ingresos Alcantarillado",null,null,null,null,23980243,null,23980243]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",5744918,4557607,1709338,12011863,9871,0,12021734]
["   TOTAL ING. DE EXPLOTACION",82521955,82034455,25198138,189754548,23990114,0,213744662]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",14772394,16204678,6330130,37307202,1808352,0,39115554]
["       Costo Operativo Fijo",41433288,40582645,25168450,107184383,22135453,0,129319836]
["    TOTAL OPERATIVO",56205682,56787323,31498580,144491585,23943805,0,168435390]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",31570738,28024783,11143908,70739429,7033238,0,77772667]
["       Comercial Asignados",14178918,7054754,2166976,23400648,2063088,0,25463736]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",45749656,35079537,13310884,94140077,9096326,0,103236403]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",20512263,18208371,7240463,45961097,4569664,0,50530761]
["       Administ. Asignados",22678544,11283762,3465980,37428286,3299817,0,40728103]
["       Gastos Fiscales",8501368,4229876,1299271,14030515,1236983,0,15267498]
["    TOTAL ADMINISTRACION",51692175,33722009,12005714,97419898,9106464,0,106526362]
["    TOTAL NO OPERATIVO",97441831,68801546,25316598,191559975,18202790,0,209762765]
["  COSTO DE EXPLOTACION",153647513,125588869,56815178,336051560,42146595,0,378198155]
["  RESULTADO DE EXPLOTACION",-71125558,-43554414,-31617040,-146297012,-18156481,0,-164453493]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",2637504,1312296,403092,4352892,383767,0,4736659]
["       Gtos. Div. y Extraor",406780,202394,62169,671343,59188,0,730531]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",2230724,1109902,340923,3681549,324579,0,4006128]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",5641211,2806798,862151,9310160,820818,0,10130978]
["       Gastos Financieros",26392920,13131859,4033651,43558430,3840274,0,47398704]
["   RESULTADO FINANCIERO",-20751709,-10325061,-3171500,-34248270,-3019456,0,-37267726]
["    I.R.A.E.",-19387240,-9646167,-2962968,-31996375,-2820920,null,-34817295]
[" RESULTADO NETO",-70259303,-43123406,-31484649,-144867358,-18030438,0,-162897796]

{"sheet":"B-ROC-502","index":74,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["R O C H A "]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",53354743.904959299,8681578.4943474345,62036322.399306729]
[]
[null,"MATERIALES Y SUMINISTROS",10250735.669912688,659652.53028291056,10910388.200195599]
[]
[null,"ENERGIA Y FLUÍDOS",23057275.45322853,893493.66861845425,23950769.121846985]
[]
[null,"SERVICIOS CONTRATADOS",5369573.5763527378,1797686.8909836547,7167260.467336392]
[]
[null,"GASTOS VARIOS",5443912.8612277061,1120459.4409724367,6564372.3022001423]
[]
[null,"AMORTIZACIÓN",47015343.534319028,10790933.974795109,57806277.509114139]
[]
[]
[null,"TOTAL",144491585,23943805,168435389.99999997,null,0.56762169215083957]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",44182906.310545839,16633317.2504707,60816223.561016537]
[]
[null,"MATERIALES Y SUMINISTROS",2905452.2170165395,818188.08843586221,3723640.3054524017]
[]
[null,"ENERGIA Y FLUÍDOS",186309.72177143098,4584043.7260221792,4770353.4477936104]
[]
[null,"SERVICIOS CONTRATADOS",21361856.526132278,4372769.0048882794,25734625.531020559]
[]
[null,"GASTOS VARIOS",4974992.030220421,7296198.3782940265,12271190.408514448]
[]
[null,"AMORTIZACIÓN",4161150.1943134977,16826244.551888954,20987394.74620245]
[]
[]
[]
[null,"TOTAL",77772667,50530761,128303427.99999999,null,0.43237830784916048]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,296738817.99999994]

{"sheet":"C-ROC-502","index":75,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["R O C H A "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1382.89,1131.5926087522726,1576.28]
[]
[null,"MATERIALES Y SUMINISTROS",265.69,85.981820944070719,96.51]
[]
[null,"ENERGIA Y FLUÍDOS",597.62,116.46163563848465,123.64]
[]
[null,"SERVICIOS CONTRATADOS",139.16999999999999,234.31789507086219,667.01]
[]
[null,"GASTOS VARIOS",141.1,146.04528688378997,318.05]
[]
[null,"AMORTIZACIÓN",1218.58,1406.5346682475376,543.97]
[]
[]
[]
[null,"TOTAL",3745.05,3120.933915537018,3325.46]
[]
[]
[null,"2.CONEXIONES (promedio anual)",38582,7672]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.77,1.76,0]
[]
[null,"3.3 TOTAL",1.71,1.72]
[]
[]
[null,"4.M3 ELEVADOS",5960870]
[]
[null,"5.M3 FACTURADOS",3415040]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",6.26]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",10.92]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",98.4]
[]
[null,"6.4 TOTAL/M3FACT",101.99]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",29.24]
[]
[null,"7.2 FIJO/CONEXIONES",168.22]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",55.56]
[]
[null,"7.4 TOTAL/M3FACT",59.57]

{"sheet":"A-TT-203","index":76,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["TREINTA Y TRES","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",49918095,0,6589261,56507356,null,null,56507356]
["       Ingresos Fijos",29531167,0,3129162,32660329,null,null,32660329]
["    INGRESOS DE EXPLOTACION",79449262,0,9718423,89167685,null,null,89167685]
["       Ingresos Alcantarillado",null,null,null,null,28990529,null,28990529]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",4649025,0,350799,4999824,1146,0,5000970]
["   TOTAL ING. DE EXPLOTACION",84098287,0,10069222,94167509,28991675,0,123159184]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",15611303,0,1823030,17434333,7778329,0,25212662]
["       Costo Operativo Fijo",35812653,0,6640949,42453602,25927727,0,68381329]
["    TOTAL OPERATIVO",51423956,0,8463979,59887935,33706056,0,93593991]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",24733488,0,2666044,27399532,6554184,0,33953716]
["       Comercial Asignados",7232238,0,865927,8098165,2493210,0,10591375]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",31965726,0,3531971,35497697,9047394,0,44545091]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",8390568,0,904427,9294995,2223436,0,11518431]
["       Administ. Asignados",11567640,0,1385012,12952652,3987778,0,16940430]
["       Gastos Fiscales",4336291,0,519191,4855482,1494874,0,6350356]
["    TOTAL ADMINISTRACION",24294499,0,2808630,27103129,7706088,0,34809217]
["    TOTAL NO OPERATIVO",56260225,0,6340601,62600826,16753482,0,79354308]
["  COSTO DE EXPLOTACION",107684181,0,14804580,122488761,50459538,0,172948299]
["  RESULTADO DE EXPLOTACION",-23585894,0,-4735358,-28321252,-21467863,0,-49789115]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1345311,0,161076,1506387,463777,0,1970164]
["       Gtos. Div. y Extraor",207486,0,24843,232329,71528,0,303857]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1137825,0,136233,1274058,392249,0,1666307]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",2877411,0,344517,3221928,991946,0,4213874]
["       Gastos Financieros",13462232,0,1611854,15074086,4640911,0,19714997]
["   RESULTADO FINANCIERO",-10584821,0,-1267337,-11852158,-3648965,0,-15501123]
["    I.R.A.E.",-9888846,0,-1184007,-11072853,-3409037,null,-14481890]
[" RESULTADO NETO",-23144044,0,-4682455,-27826499,-21315542,0,-49142041]

{"sheet":"B-TT-203","index":77,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["T R E I N T A   Y   T R E S"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",22866812.110268686,8486548.8669214826,31353360.977190167]
[]
[null,"MATERIALES Y SUMINISTROS",5399514.6119687166,982512.08088106604,6382026.6928497823]
[]
[null,"ENERGIA Y FLUÍDOS",9657031.4526810739,4334012.5475770868,13991044.000258161]
[]
[null,"SERVICIOS CONTRATADOS",2368225.1617381368,3213967.9658937105,5582193.1276318468]
[]
[null,"GASTOS VARIOS",2970109.7342944127,680023.30939519079,3650133.0436896035]
[]
[null,"AMORTIZACIÓN",16626241.929048982,16008991.229331464,32635233.158380445]
[]
[]
[null,"TOTAL",59887935,33706056,93593991,null,0.67301783414737526]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",22167057.700936884,3041940.8049478927,25208998.505884778]
[]
[null,"MATERIALES Y SUMINISTROS",1502514.2558946821,160699.19216832219,1663213.4480630043]
[]
[null,"ENERGIA Y FLUÍDOS",79109.240770278862,1894485.2828206418,1973594.5235909207]
[]
[null,"SERVICIOS CONTRATADOS",5966350.7664470915,3911506.8204828319,9877857.5869299229]
[]
[null,"GASTOS VARIOS",2480975.8965509171,720134.52519067097,3201110.421741588]
[]
[null,"AMORTIZACIÓN",1757708.1394001457,1789664.3743896408,3547372.5137897865]
[]
[]
[]
[null,"TOTAL",33953716,11518431,45472147.000000007,null,0.3269821658526248]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,139066138]

{"sheet":"C-TT-203","index":78,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["T R E I N T A   Y   T R E S "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1058.01,820.74940685894421,1166.3800000000001]
[]
[null,"MATERIALES Y SUMINISTROS",249.83,95.020510723507357,76.95]
[]
[null,"ENERGIA Y FLUÍDOS",446.82,419.15014966896393,91.32]
[]
[null,"SERVICIOS CONTRATADOS",109.57,310.82862339397587,457.03]
[]
[null,"GASTOS VARIOS",137.41999999999999,65.766277504370478,148.11000000000001]
[]
[null,"AMORTIZACIÓN",769.27,1548.2583393937587,164.13]
[]
[]
[]
[null,"TOTAL",2770.92,3259.7733075435208,2103.92]
[]
[]
[null,"2.CONEXIONES (promedio anual)",21613,10340]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.3,1.74,0]
[]
[null,"3.3 TOTAL",1.28,1.7]
[]
[]
[null,"4.M3 ELEVADOS",3550910]
[]
[null,"5.M3 FACTURADOS",2194730]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",4.91]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.94]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",55.81]
[]
[null,"6.4 TOTAL/M3FACT",57.74]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",25.75]
[]
[null,"7.2 FIJO/CONEXIONES",125.93]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",42.91]
[]
[null,"7.4 TOTAL/M3FACT",45.06]

{"sheet":"A-LAV-503","index":79,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["LAVALLEJA","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",57781894,3582394,4583010,65947298,null,null,65947298]
["       Ingresos Fijos",32455921,2132394,2843980,37432295,null,null,37432295]
["    INGRESOS DE EXPLOTACION",90237815,5714788,7426990,103379593,null,null,103379593]
["       Ingresos Alcantarillado",null,null,null,null,29004212,null,29004212]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",3799238,206898,344767,4350903,0,0,4350903]
["   TOTAL ING. DE EXPLOTACION",94037053,5921686,7771757,107730496,29004212,0,136734708]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",19335249,1005965,2480147,22821361,6914912,0,29736273]
["       Costo Operativo Fijo",52897861,11705062,13174905,77777828,25283633,0,103061461]
["    TOTAL OPERATIVO",72233110,12711027,15655052,100599189,32198545,0,132797734]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",23816249,1725866,2287038,27829153,5547007,0,33376160]
["       Comercial Asignados",1004706,509250,668351,2182307,2494289,0,4676596]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",24820955,2235116,2955389,30011460,8041296,0,38052756]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",26838087,1944847,2577220,31360154,6250819,0,37610973]
["       Administ. Asignados",1606982,814522,1068998,3490502,3989502,0,7480004]
["       Gastos Fiscales",602400,305335,400729,1308464,1495521,0,2803985]
["    TOTAL ADMINISTRACION",29047469,3064704,4046947,36159120,11735842,0,47894962]
["    TOTAL NO OPERATIVO",53868424,5299820,7002336,66170580,19777138,0,85947718]
["  COSTO DE EXPLOTACION",126101534,18010847,22657388,166769769,51975683,0,218745452]
["  RESULTADO DE EXPLOTACION",-32064481,-12089161,-14885631,-59039273,-22971471,0,-82010744]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",186891,94729,124324,405944,463979,0,869923]
["       Gtos. Div. y Extraor",28824,14610,19174,62608,71559,0,134167]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",158067,80119,105150,343336,392420,0,735756]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",399731,202610,265910,868251,992375,0,1860626]
["       Gastos Financieros",1870180,947928,1244082,4062190,4642918,0,8705108]
["   RESULTADO FINANCIERO",-1470449,-745318,-978172,-3193939,-3650543,0,-6844482]
["    I.R.A.E.",-1373763,-696312,-913856,-2983931,-3410512,null,-6394443]
[" RESULTADO NETO",-32003100,-12058048,-14844797,-58905945,-22819082,0,-81725027]

{"sheet":"B-LAV-503","index":80,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["L A V A L L E  J  A"]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",40272195.302134819,12023910.730469864,52296106.032604679]
[]
[null,"MATERIALES Y SUMINISTROS",6367260.6368357465,1266379.7915308273,7633640.4283665735]
[]
[null,"ENERGIA Y FLUÍDOS",11701361.827440701,3953085.8685456463,15654447.695986347]
[]
[null,"SERVICIOS CONTRATADOS",10612880.440499473,3282405.9763477119,13895286.416847184]
[]
[null,"GASTOS VARIOS",4488681.6862696707,1443655.9267141558,5932337.6129838265]
[]
[null,"AMORTIZACIÓN",27156809.106819592,10229106.706391796,37385915.813211389]
[]
[]
[null,"TOTAL",100599189,32198545,132797734,null,0.65165650401312669]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",20499970.280510534,12454547.012996532,32954517.293507066]
[]
[null,"MATERIALES Y SUMINISTROS",1598284.0541448048,499559.68107610533,2097843.73522091]
[]
[null,"ENERGIA Y FLUÍDOS",95729.761937822172,2799453.2277962854,2895182.9897341076]
[]
[null,"SERVICIOS CONTRATADOS",7145255.4474934377,3935469.4050724758,11080724.852565914]
[]
[null,"GASTOS VARIOS",1696538.8668576498,4357793.4468734739,6054332.3137311237]
[]
[null,"AMORTIZACIÓN",2340381.5890557566,13564150.226185128,15904531.815240884]
[]
[]
[]
[null,"TOTAL",33376160.000000004,37610973,70987133.000000015,null,0.34834349598687331]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,203784867]

{"sheet":"C-LAV-503","index":81,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["L A V A L L E J A "]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",1702.48,1275.0700668578859,1393.13]
[]
[null,"MATERIALES Y SUMINISTROS",269.17,134.29266081981203,88.69]
[]
[null,"ENERGIA Y FLUÍDOS",494.67,419.20316739614486,122.39]
[]
[null,"SERVICIOS CONTRATADOS",448.65,348.08122760845299,468.43]
[]
[null,"GASTOS VARIOS",189.76,153.09182679895608,255.94]
[]
[null,"AMORTIZACIÓN",1148.04,1084.7409020563941,672.35]
[]
[]
[]
[null,"TOTAL",4252.7700000000004,3414.479851537646,3000.9300000000003]
[]
[]
[null,"2.CONEXIONES (promedio anual)",23655,9430]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",1.55,1.79,0]
[]
[null,"3.3 TOTAL",1.54,1.75]
[]
[]
[null,"4.M3 ELEVADOS",3952540]
[]
[null,"5.M3 FACTURADOS",2399030]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",5.77]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",9.51]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",69.52]
[]
[null,"6.4 TOTAL/M3FACT",69.989999999999995]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",27.49]
[]
[null,"7.2 FIJO/CONEXIONES",131.87]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",44.91]
[]
[null,"7.4 TOTAL/M3FACT",45.44]

{"sheet":"A-UGD-501","index":82,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
["U.G.D.","ESTADO DE RENDIMIENTO ECONÓMICO (a valores históricos)",null,null,null,null,"PERÍODO ENERO-DICIEMBRE-2014"]
[]
["CONCEPTO","AGUA POTABLE"]
[null,"USINA","PERFORACIÓN","MIXTO","SUB-TOTAL","SANEAMIENTO","OTROS INGRESOS","TOTAL"]
["   INGRESOS",0,0,0,0,0,0,0]
["       Ingresos Variables",412750854,0,0,412750854,null,null,412750854]
["       Ingresos Fijos",245679136,0,0,245679136,null,null,245679136]
["    INGRESOS DE EXPLOTACION",658429990,0,0,658429990,null,null,658429990]
["       Ingresos Alcantarillado",null,null,null,null,207643185,null,207643185]
["       Ingresos Upas",null,null,null,null,null,0,0]
["       Otros Ingresos",38110097,0,0,38110097,95904,0,38206001]
["   TOTAL ING. DE EXPLOTACION",696540087,0,0,696540087,207739089,0,904279176]
["   COSTOS DE EXPLOTACION",0,0,0,0,0,0,0]
["   OPERATIVO",0,0,0,0,0,0,0]
["       Costo Operativo Var",80291637,0,0,80291637,44707637,0,124999274]
["       Costo Operativo Fijo",149709097,0,0,149709097,96544604,0,246253701]
["    TOTAL OPERATIVO",230000734,0,0,230000734,141252241,0,371252975]
["   NO OPERATIVO",0,0,0,0,0,0,0]
["   COMERCIALIZACION",0,0,0,0,0,0,0]
["       Comercial Propios",44639560,0,0,44639560,12558115,0,57197675]
["       Comercial Asignados",0,0,0,0,0,0,0]
["       Comercialización Upas",0,0,0,0,0,0,0]
["    TOTAL COMERCIALIZACION",44639560,0,0,44639560,12558115,0,57197675]
["    ADMINISTRACION",0,0,0,0,0,0,0]
["       Administración Propios",26245154,0,0,26245154,7383353,0,33628507]
["       Administ. Asignados",34257970,0,0,34257970,10217243,0,44475213]
["       Gastos Fiscales",45909547,0,0,45909547,13692260,0,59601807]
["    TOTAL ADMINISTRACION",106412671,0,0,106412671,31292856,0,137705527]
["    TOTAL NO OPERATIVO",151052231,0,0,151052231,43850971,0,194903202]
["  COSTO DE EXPLOTACION",381052965,0,0,381052965,185103212,0,566156177]
["  RESULTADO DE EXPLOTACION",315487122,0,0,315487122,22635877,0,338122999]
["  DIVERSOS Y EXTRAORDINARIOS",0,0,0,0,0,0,0]
["       Ingresos Div. y Extr",1517858,0,0,1517858,452692,0,1970550]
["       Gtos. Div. y Extraor",256122,0,0,256122,76387,0,332509]
[" RESULTADOS DIV. Y EXTRAORDINARIOS",1261736,0,0,1261736,376305,0,1638041]
["   FINANCIEROS",0,0,0,0,0,0,0]
["       Ingresos Financieros",36899941,0,0,36899941,11005196,0,47905137]
["       Gastos Financieros",480249,0,0,480249,143232,0,623481]
["   RESULTADO FINANCIERO",36419692,0,0,36419692,10861964,0,47281656]
["    I.R.A.E.",-81903900,0,0,-81903900,-24427369,null,-106331269]
[" RESULTADO NETO",435072450,0,0,435072450,58301515,0,493373965]

{"sheet":"B-UGD-501","index":83,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,2,4,6],[8,2,8,6],[31,2,31,6],[55,0,55,1]]}
["   "]
[]
["U . G . D."]
[]
[null,null,"C   O   S   T   O   S              T    O   T   A    L   E   S "]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O   S      O   P   E   R   A   T    I    V   O   S"]
[]
[]
[null,null,"AGUA ","ALCANTARILLADO","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",49140544.759701937,21582951.6717644,70723496.431466341]
[]
[null,"MATERIALES Y SUMINISTROS",32130613.850152984,11219549.884441452,43350163.734594434]
[]
[null,"ENERGIA Y FLUÍDOS",38861104.890696429,29920665.447793689,68781770.338490114]
[]
[null,"SERVICIOS CONTRATADOS",16071244.957269127,34456927.898558915,50528172.855828039]
[]
[null,"GASTOS VARIOS",13163492.646901287,1119930.1299958471,14283422.776897134]
[]
[null,"AMORTIZACIÓN",80633732.855278254,42952215.4374457,123585948.29272395]
[]
[]
[null,"TOTAL",230000733.96000001,141252240.47000003,371252974.43000001,null,0.80344021090299089,null,-3.9999991655349731E-2,-0.52999997138977051]
[]
[]
[]
[]
[null,"C   O   N   C   E   P   T   O ","C   O   S   T   O      D   E      A   D   M   I   N   I   S   T   R   A   T   I   V    O    -    C   O   M   E   R   C   I    A   L"]
[]
[]
[null,null,"COMERCIALIZACION","ADMINISTRACION","TOTAL"]
[]
[null,"RETRIBUCIONES AL PERSONAL",23440910.820000004,15076312.520000003,38517223.340000004]
[]
[null,"MATERIALES Y SUMINISTROS",5880709.0599999996,1349893.4200000002,7230602.4799999995]
[]
[null,"ENERGIA Y FLUÍDOS",828452.9,-650201.84000000008,178251.05999999994]
[]
[null,"SERVICIOS CONTRATADOS",24489789.979999997,10283683.75,34773473.729999997]
[]
[null,"GASTOS VARIOS",2236320.7300000004,4491108.7100000009,6727429.4400000013]
[]
[null,"AMORTIZACIÓN",321490.92999999993,3077710.44,3399201.37]
[]
[]
[]
[null,"TOTAL",57197674.419999994,33628507,90826181.420000002,null,0.19655978909700911,null,-0.58000000566244125,0]
[]
[]
[]
[]
["C  O  S  T  O    D  E    E  X  P  L  O  T  A  C  I  O  N ",null,null,null,null,null,462079155.85000002]
[]
[]
[]
[null,null,null,null,null,null,-1.1499999761581421]

{"sheet":"C-UGD-501","index":84,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[4,0,4,5],[8,2,8,3]]}
[null," "]
[]
["COBERTURAS,COSTOS E INGRESOS PROMEDIO"]
[]
["U . G . D ."]
[]
[]
[]
[null,"1.  COMPOSICION DEL COSTO PROPIO POR CONEXIÓN","OPERATIVOS",0,"ADMISTRATIVO-COMERCIAL"]
[]
[null,null,"AGUA","ALCANTARILLADO"]
[null,null,"($/conex.agua)","($/conex.desague)","($/conex.agua)"]
[]
[null,"RETRIBUCIONES AL PERSONAL",691.39,539.7222154033459,541.91999999999996]
[]
[null,"MATERIALES Y SUMINISTROS",452.07,280.56590273428822,101.73]
[]
[null,"ENERGIA Y FLUÍDOS",546.76,748.22239735411461,2.5099999999999998]
[]
[null,"SERVICIOS CONTRATADOS",226.12,861.66015400632466,489.25]
[]
[null,"GASTOS VARIOS",185.21,28.005954887490237,94.65]
[]
[null,"AMORTIZACIÓN",1134.49,1074.1007636461452,47.83]
[]
[]
[]
[null,"TOTAL",3236.04,3532.2773880317091,1277.8899999999999]
[]
[]
[null,"2.CONEXIONES (promedio anual)",71075,39989]
[]
[]
[null,"3.COBERTURAS COSTO/INGRESO"]
[]
[null,"3.1 COSTO DE EXPLOTACION/ INGRESO DE EXPLOT.",0.55000000000000004,0.89,0]
[]
[null,"3.3 TOTAL",0.41,0.73]
[]
[]
[null,"4.M3 ELEVADOS",20685170]
[]
[null,"5.M3 FACTURADOS",11415090]
[]
[]
[null,"6. COSTO PROMEDIO"]
[]
[null,"6.1 COSTO VARIABLE/ M3ELEVADOS",3.88]
[]
[null,"6.2 COSTO VARIABLE / M3FACTURADOS",7.03]
[]
[null,"6.3 COSTO EXPLOTACION/M3FACT",33.380000000000003]
[]
[null,"6.4 TOTAL/M3FACT",26.27]
[]
[]
[null,"7. INGRESOS PROMEDIO"]
[]
[null,"7.1 VARIABLE/M3 FACT",36.159999999999997]
[]
[null,"7.2 FIJO/CONEXIONES",288.05]
[]
[null,"7.3 INGRESO EXPLOTACION/M3FACT",61.02]
[]
[null,"7.4 TOTAL/M3FACT",64.38]