{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ACTUAL","NORMA 1 AÑO","NORMA 10 AÑOS","ESC 1 1 AÑO","ESC 1 10AÑOS","ESC 2 EN B2 1 AÑO","ESC 2 EN B2 10 AÑOS","ESC 3 MAS EN B2 1 AÑO","ESC 3 MAS EN B2 10 AÑOS","2ORIGINAL","ANALISIS"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":470,"comments":10,"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":"ACTUAL","index":0,"n_rows":79,"n_cols":20,"rows_kept":79,"cut":false,"hidden":false,"merged":[[32,17,32,19],[78,12,78,13],[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[24,17,24,19]]}
[]
[null,"CUADRO 12.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES -CASO ACTUAL"]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",3,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":0.79591548876634455},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":3.24},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":2.3142857142857145},"m2",null,null,null,null,"COSTO TOTAL POZO",{"$f":"+N5*N6","v":502798.30302983971},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",1,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",365,"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":18},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":5840},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.7999999999999999E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":86.095599833876662},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":1.0799999999999998},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":53965.543599833807},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":1.5212776585113299}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":0.46666666666666656},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":1.3212776585113299}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},0.93333333333333313,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},928.9559999999999,0,928.9559999999999,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":1.7457746508811827}]
[null,3,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999,null,null,"D AREA",{"$f":"+G7-S20","v":0.56851106340453184}]
[null,4,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,5,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,6,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,7,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999,null,null,"DATOS BOMBEO EXISTENTE"]
[null,8,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999,null,null,"Q DISEÑO",18,"L/S"]
[null,9,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999,null,null,"TAMAÑO POZO",{"$f":"1.4*1.5*1.5","v":3.1499999999999995},"m3"]
[null,10,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,11,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,12,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,13,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,14,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,15,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999,null,null,"DATOS BOMBEO ALL EXISTENTE"]
[null,16,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999,null,null,"Q DISEÑO",92,"L/S"]
[null,17,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999,null,null,"CDT",6,"m"]
[null,18,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999,null,null,"FRACCION.","2 BOMBAS DEL 100%"]
[null,19,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,20,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,21,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,22,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,23,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,24,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,25,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,26,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,28,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,29,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,30,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":1.0799999999999998},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},2.1599999999999993,{"$f":"+G51/$G$7","v":0.9333333333333329},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,37,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,38,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,39,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,40,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,41,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",928.9559999999999,0,928.9559999999999]
[null,60,1.0799999999999998,1.0799999999999998,1.0799999999999998,0,2.1599999999999993,0.9333333333333329,"","","","",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":53879.447999999931}]

{"sheet":"NORMA 1 AÑO","index":1,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,12,78,13],[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14]]}
[]
[null,"CUADRO 13.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES-CASO NORMATIVO UN AÑO"]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",5,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":1.0438181667894015},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":5.4},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":3.8571428571428577},"m2",null,null,null,null,"COSTO TOTAL POZO",{"$f":"+N5*N6","v":659404.18341010914},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.75,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365","v":365},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":13.5},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":5840},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.3499999999999998E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":112.91167524145705},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.80999999999999983},"M3/MIN",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":71642.523675241377},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":1.9639610121239315}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":0.27999999999999992},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":1.7639610121239315}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},0.55999999999999983,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":3.1115584522932851}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,0.83999999999999975,"","","","",928.9559999999999,0,928.9559999999999,null,null,"D AREA",{"$f":"+G7-S20","v":0.74558440484957256}]
[null,4,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.51,0.90999999999999981,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":"ENCENDIDO BOMBA 1"},"","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,5,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000002,0.98,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,6,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000007,1.05,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,7,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.5100000000000016,0.91000000000000025,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,8,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000024,0.77000000000000057,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,9,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000033,0.63000000000000078,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,10,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000039,0.49000000000000093,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,11,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000039,0.35000000000000098,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,12,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.81000000000000405,0.21000000000000102,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,13,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000000424,7.0000000000001089E-2,"","","","",0,0,0]
[null,14,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000041,0.35000000000000103,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000042,0.630000000000001,"","","","",928.9559999999999,0,928.9559999999999]
[null,16,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.7000000000000046,0.70000000000000107,"ENCENDIDO BOMBA 1","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,17,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.9700000000000051,0.77000000000000124,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,18,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.2400000000000055,0.8400000000000013,"","","","",928.9559999999999,0,928.9559999999999]
[null,19,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.510000000000006,0.91000000000000147,"","","","",928.9559999999999,0,928.9559999999999]
[null,20,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000065,0.98000000000000154,"","","","",928.9559999999999,0,928.9559999999999]
[null,21,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000069,1.0500000000000016,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,22,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.5100000000000078,0.91000000000000192,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,23,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000086,0.77000000000000213,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,24,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000095,0.63000000000000234,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,25,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000101,0.49000000000000254,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,26,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000101,0.35000000000000259,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,27,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.81000000000001027,0.21000000000000263,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,28,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000001045,7.0000000000002699E-2,"","","","",0,0,0]
[null,29,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000103,0.35000000000000264,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,30,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000104,0.63000000000000256,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.7000000000000108,0.70000000000000273,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.9700000000000113,0.77000000000000279,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.80999999999999983},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},3.2400000000000118,{"$f":"+G51/$G$7","v":0.84000000000000297},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.5100000000000122,0.91000000000000303,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000127,0.9800000000000032,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000131,1.0500000000000034,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,37,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.510000000000014,0.91000000000000347,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,38,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000149,0.77000000000000379,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,39,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000157,0.630000000000004,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,40,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000163,0.49000000000000415,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,41,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000163,0.3500000000000042,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,42,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.81000000000001648,0.21000000000000424,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,43,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000001667,7.0000000000004309E-2,"","","","",0,0,0]
[null,44,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000165,0.35000000000000425,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,45,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000166,0.63000000000000422,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.7000000000000171,0.70000000000000429,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.9700000000000175,0.77000000000000446,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.240000000000018,0.84000000000000452,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.5100000000000184,0.91000000000000469,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000189,0.98000000000000476,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000194,1.0500000000000049,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,52,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.5100000000000202,0.91000000000000514,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,53,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000211,0.77000000000000535,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,54,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000219,0.63000000000000556,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,55,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000226,0.49000000000000576,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,56,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000225,0.35000000000000581,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,57,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.8100000000000227,0.21000000000000585,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,58,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000002289,7.0000000000005919E-2,"","","","",0,0,0]
[null,59,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000227,0.35000000000000586,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,60,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000228,0.63000000000000578,"","","","",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":71529.611999999921}]

{"sheet":"NORMA 10 AÑOS","index":2,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 14.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES CASO NORMATIVO -  DIEZ AÑOS."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",5,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":1.0438181667894015},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":5.4},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":3.8571428571428577},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":659404.18341010914},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.75,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365*10","v":3650},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":13.5},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":58400},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.3499999999999998E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":11.291167524145704},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.80999999999999983},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":71540.903167524069},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":1.9639610121239315}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":0.27999999999999992},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":1.7639610121239315}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},0.55999999999999983,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":3.1115584522932851}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,0.83999999999999975,"","","","",928.9559999999999,0,928.9559999999999,null,null,"D AREA",{"$f":"+G7-S20","v":0.74558440484957256}]
[null,4,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.51,0.90999999999999981,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":"ENCENDIDO BOMBA 1"},"","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,5,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000002,0.98,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,6,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000007,1.05,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,7,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.5100000000000016,0.91000000000000025,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,8,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000024,0.77000000000000057,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,9,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000033,0.63000000000000078,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,10,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000039,0.49000000000000093,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,11,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000039,0.35000000000000098,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,12,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.81000000000000405,0.21000000000000102,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,13,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000000424,7.0000000000001089E-2,"","","","",0,0,0]
[null,14,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000041,0.35000000000000103,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000042,0.630000000000001,"","","","",928.9559999999999,0,928.9559999999999]
[null,16,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.7000000000000046,0.70000000000000107,"ENCENDIDO BOMBA 1","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,17,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.9700000000000051,0.77000000000000124,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,18,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.2400000000000055,0.8400000000000013,"","","","",928.9559999999999,0,928.9559999999999]
[null,19,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.510000000000006,0.91000000000000147,"","","","",928.9559999999999,0,928.9559999999999]
[null,20,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000065,0.98000000000000154,"","","","",928.9559999999999,0,928.9559999999999]
[null,21,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000069,1.0500000000000016,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,22,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.5100000000000078,0.91000000000000192,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,23,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000086,0.77000000000000213,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,24,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000095,0.63000000000000234,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,25,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000101,0.49000000000000254,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,26,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000101,0.35000000000000259,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,27,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.81000000000001027,0.21000000000000263,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,28,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000001045,7.0000000000002699E-2,"","","","",0,0,0]
[null,29,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000103,0.35000000000000264,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,30,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000104,0.63000000000000256,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.7000000000000108,0.70000000000000273,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.9700000000000113,0.77000000000000279,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.80999999999999983},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},3.2400000000000118,{"$f":"+G51/$G$7","v":0.84000000000000297},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.5100000000000122,0.91000000000000303,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000127,0.9800000000000032,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000131,1.0500000000000034,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,37,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.510000000000014,0.91000000000000347,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,38,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000149,0.77000000000000379,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,39,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000157,0.630000000000004,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,40,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000163,0.49000000000000415,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,41,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000163,0.3500000000000042,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,42,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.81000000000001648,0.21000000000000424,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,43,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000001667,7.0000000000004309E-2,"","","","",0,0,0]
[null,44,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000165,0.35000000000000425,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,45,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000166,0.63000000000000422,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.7000000000000171,0.70000000000000429,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,2.9700000000000175,0.77000000000000446,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.240000000000018,0.84000000000000452,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.5100000000000184,0.91000000000000469,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,3.7800000000000189,0.98000000000000476,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.80999999999999983,0,4.0500000000000194,1.0500000000000049,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,52,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,3.5100000000000202,0.91000000000000514,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,53,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.9700000000000211,0.77000000000000535,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,54,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,2.4300000000000219,0.63000000000000556,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,55,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.8900000000000226,0.49000000000000576,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,56,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,1.3500000000000225,0.35000000000000581,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,57,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.8100000000000227,0.21000000000000585,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,58,1.0799999999999998,1.0799999999999998,0.80999999999999983,0.80999999999999983,0.27000000000002289,7.0000000000005919E-2,"","","","",0,0,0]
[null,59,1.0799999999999998,1.0799999999999998,0,0,1.3500000000000227,0.35000000000000586,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,60,1.0799999999999998,1.0799999999999998,0,0,2.4300000000000228,0.63000000000000578,"","","","",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":71529.611999999921}]

{"sheet":"ESC 1 1 AÑO","index":3,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 15.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES - ESCENARIO 1, UN AÑO."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",58.343727854881202,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":3.7009288844284636},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":63.011226083271701},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":45.00801863090836},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":2337962.7472873908},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.65345775462050981,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365","v":365},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":11.762239583169176},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":5840},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.1762239583169175E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":400.33608686427925},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.70573437499015046},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":31984.840086864249},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":6.7088015793365328}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":2.399572415876871E-2},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":6.5088015793365326}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},4.7991448317537419E-2,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":42.364497999173743}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,7.1987172476306122E-2,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":2.6435206317346172}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,9.5982896635074838E-2,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.11997862079384354,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,6,1.0799999999999998,1.0799999999999998,0,0,6.4799999999999995,0.14397434495261227,"","","","",0,0,0]
[null,7,1.0799999999999998,1.0799999999999998,0,0,7.56,0.16797006911138096,"","","","",0,0,0]
[null,8,1.0799999999999998,1.0799999999999998,0,0,8.6399999999999988,0.19196579327014968,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,9,1.0799999999999998,1.0799999999999998,0,0,9.7199999999999989,0.21596151742891836,"","","","",0,0,0]
[null,10,1.0799999999999998,1.0799999999999998,0,0,10.799999999999999,0.23995724158768708,"","","","",0,0,0]
[null,11,1.0799999999999998,1.0799999999999998,0,0,11.879999999999999,0.26395296574645583,"","","","",0,0,0]
[null,12,1.0799999999999998,1.0799999999999998,0,0,12.959999999999999,0.28794868990522454,"","","","",0,0,0]
[null,13,1.0799999999999998,1.0799999999999998,0,0,14.04,0.3119444140639932,"","","","",0,0,0]
[null,14,1.0799999999999998,1.0799999999999998,0,0,15.12,0.33594013822276192,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,16.2,0.35993586238153064,"","","","",0,0,0]
[null,16,1.0799999999999998,1.0799999999999998,0,0,17.279999999999998,0.38393158654029935,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,17,1.0799999999999998,1.0799999999999998,0,0,18.359999999999996,0.40792731069906801,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,18,1.0799999999999998,1.0799999999999998,0,0,19.439999999999994,0.43192303485783667,"","","","",0,0,0]
[null,19,1.0799999999999998,1.0799999999999998,0,0,20.519999999999992,0.45591875901660533,"","","","",0,0,0]
[null,20,1.0799999999999998,1.0799999999999998,0,0,21.599999999999991,0.479914483175374,"","","","",0,0,0]
[null,21,1.0799999999999998,1.0799999999999998,0,0,22.679999999999989,0.50391020733414271,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,22,1.0799999999999998,1.0799999999999998,0,0,23.759999999999987,0.52790593149291132,"","","","",0,0,0]
[null,23,1.0799999999999998,1.0799999999999998,0,0,24.839999999999986,0.55190165565168003,"","","","",0,0,0]
[null,24,1.0799999999999998,1.0799999999999998,0,0,25.919999999999984,0.57589737981044875,"","","","",0,0,0]
[null,25,1.0799999999999998,1.0799999999999998,0,0,26.999999999999982,0.59989310396921736,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,26,1.0799999999999998,1.0799999999999998,0,0,28.079999999999981,0.62388882812798607,"","","","",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,28.454265625009828,0.63220436025747262,"ENCENDIDO BOMBA 1",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,28,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,28.828531250019676,0.64051989238695917,"","","","",928.9559999999999,0,928.9559999999999]
[null,29,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,29.202796875029524,0.64883542451644571,"","","","",928.9559999999999,0,928.9559999999999]
[null,30,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,29.577062500039371,0.65715095664593226,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,29.951328125049219,0.66546648877541881,"","","","",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,30.325593750059067,0.67378202090490535,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.70573437499015046},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},30.699859375068915,{"$f":"+G51/$G$7","v":0.6820975530343919},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,31.074125000078762,0.69041308516387845,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,31.448390625088614,0.69872861729336511,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,31.822656250098461,0.70704414942285165,"","","","",928.9559999999999,0,928.9559999999999]
[null,37,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,32.196921875108309,0.7153596815523382,"","","","",928.9559999999999,0,928.9559999999999]
[null,38,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,32.571187500118157,0.72367521368182475,"","","","",928.9559999999999,0,928.9559999999999]
[null,39,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,32.945453125128005,0.73199074581131129,"","","","",928.9559999999999,0,928.9559999999999]
[null,40,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,33.319718750137852,0.74030627794079784,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,41,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,33.6939843751477,0.74862181007028439,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,34.068250000157548,0.75693734219977094,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,34.442515625167395,0.76525287432925748,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,34.816781250177243,0.77356840645874403,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,35.191046875187091,0.78188393858823058,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,35.565312500196939,0.79019947071771712,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,35.939578125206786,0.79851500284720367,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,36.313843750216634,0.80683053497669022,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,36.688109375226482,0.81514606710617676,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,37.062375000236329,0.82346159923566331,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,37.436640625246177,0.83177713136514986,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,37.810906250256025,0.8400926634946364,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,38.185171875265873,0.84840819562412295,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,38.55943750027572,0.8567237277536095,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,38.933703125285568,0.86503925988309616,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,39.307968750295416,0.8733547920125827,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,39.682234375305264,0.88167032414206925,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,40.056500000315111,0.8899858562715558,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,40.430765625324959,0.89830138840104234,"","","","",928.9559999999999,0,928.9559999999999]
[null,60,1.0799999999999998,1.0799999999999998,0.70573437499015046,0,40.805031250334807,0.90661692053052889,"","","","",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":31584.503999999972}]
[null,null,null,null,null,null,null,"B2",null,null,null,{"$f":"+COUNTIF(L18:L78,\"ENCENDIDO BOMBA 2\")","v":0}]

{"sheet":"ESC 1 10AÑOS","index":4,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 16.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES-ESCENARIO 1, DIEZ AÑOS."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",58.824597510427516,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":3.7163794387259954},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":63.530565311261718},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":45.3789752223298},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":2347723.221346905},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.97549248311458736,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365*10","v":3650},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":17.558864696062571},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":58400},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.7558864696062573E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":40.20074009155659},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":1.0535318817637545},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":31624.704740091529},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":6.7363918548678416}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":2.3799567855127771E-2},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":6.5363918548678415}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},4.7599135710255543E-2,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":42.72441848038266}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,7.1398703565383304E-2,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":2.6545567419471396}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,9.5198271420511085E-2,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.11899783927563885,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,6,1.0799999999999998,1.0799999999999998,0,0,6.4799999999999995,0.14279740713076663,"","","","",0,0,0]
[null,7,1.0799999999999998,1.0799999999999998,0,0,7.56,0.1665969749858944,"","","","",0,0,0]
[null,8,1.0799999999999998,1.0799999999999998,0,0,8.6399999999999988,0.19039654284102217,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,9,1.0799999999999998,1.0799999999999998,0,0,9.7199999999999989,0.21419611069614994,"","","","",0,0,0]
[null,10,1.0799999999999998,1.0799999999999998,0,0,10.799999999999999,0.23799567855127771,"","","","",0,0,0]
[null,11,1.0799999999999998,1.0799999999999998,0,0,11.879999999999999,0.2617952464064055,"","","","",0,0,0]
[null,12,1.0799999999999998,1.0799999999999998,0,0,12.959999999999999,0.28559481426153327,"","","","",0,0,0]
[null,13,1.0799999999999998,1.0799999999999998,0,0,14.04,0.30939438211666104,"","","","",0,0,0]
[null,14,1.0799999999999998,1.0799999999999998,0,0,15.12,0.33319394997178881,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,16.2,0.35699351782691657,"","","","",0,0,0]
[null,16,1.0799999999999998,1.0799999999999998,0,0,17.279999999999998,0.38079308568204434,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,17,1.0799999999999998,1.0799999999999998,0,0,18.359999999999996,0.40459265353717205,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,18,1.0799999999999998,1.0799999999999998,0,0,19.439999999999994,0.42839222139229977,"","","","",0,0,0]
[null,19,1.0799999999999998,1.0799999999999998,0,0,20.519999999999992,0.45219178924742753,"","","","",0,0,0]
[null,20,1.0799999999999998,1.0799999999999998,0,0,21.599999999999991,0.47599135710255525,"","","","",0,0,0]
[null,21,1.0799999999999998,1.0799999999999998,0,0,22.679999999999989,0.49979092495768301,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,22,1.0799999999999998,1.0799999999999998,0,0,23.759999999999987,0.52359049281281078,"","","","",0,0,0]
[null,23,1.0799999999999998,1.0799999999999998,0,0,24.839999999999986,0.54739006066793849,"","","","",0,0,0]
[null,24,1.0799999999999998,1.0799999999999998,0,0,25.919999999999984,0.57118962852306621,"","","","",0,0,0]
[null,25,1.0799999999999998,1.0799999999999998,0,0,26.999999999999982,0.59498919637819392,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,26,1.0799999999999998,1.0799999999999998,0,0,28.079999999999981,0.61878876423332163,"","","","",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.106468118236226,0.61937203254439677,"ENCENDIDO BOMBA 1",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,28,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.132936236472471,0.61995530085547179,"","","","",928.9559999999999,0,928.9559999999999]
[null,29,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.159404354708716,0.62053856916654682,"","","","",928.9559999999999,0,928.9559999999999]
[null,30,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.185872472944961,0.62112183747762195,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.212340591181206,0.62170510578869698,"","","","",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.238808709417452,0.622288374099772,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":1.0535318817637545},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},28.265276827653697,{"$f":"+G51/$G$7","v":0.62287164241084703},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.291744945889942,0.62345491072192216,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.318213064126187,0.62403817903299719,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.344681182362432,0.62462144734407221,"","","","",928.9559999999999,0,928.9559999999999]
[null,37,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.371149300598677,0.62520471565514735,"","","","",928.9559999999999,0,928.9559999999999]
[null,38,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.397617418834923,0.62578798396622237,"","","","",928.9559999999999,0,928.9559999999999]
[null,39,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.424085537071168,0.6263712522772974,"","","","",928.9559999999999,0,928.9559999999999]
[null,40,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.450553655307413,0.62695452058837253,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,41,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.477021773543658,0.62753778889944756,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.503489891779903,0.62812105721052258,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.529958010016149,0.62870432552159761,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.556426128252394,0.62928759383267274,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.582894246488639,0.62987086214374777,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.609362364724884,0.63045413045482279,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.635830482961129,0.63103739876589793,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.662298601197374,0.63162066707697295,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.68876671943362,0.63220393538804798,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.715234837669865,0.632787203699123,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.74170295590611,0.63337047201019814,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.768171074142355,0.63395374032127316,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.7946391923786,0.63453700863234819,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.821107310614845,0.63512027694342332,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.847575428851091,0.63570354525449835,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.874043547087336,0.63628681356557337,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.900511665323581,0.63687008187664851,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.926979783559826,0.63745335018772353,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.953447901796071,0.63803661849879856,"","","","",928.9559999999999,0,928.9559999999999]
[null,60,1.0799999999999998,1.0799999999999998,1.0535318817637545,0,28.979916020032316,0.63861988680987358,"","","","",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":31584.503999999972}]
[null,null,null,null,null,null,null,"B2",null,null,null,{"$f":"+COUNTIF(L18:L78,\"ENCENDIDO BOMBA 2\")","v":0}]

{"sheet":"ESC 2 EN B2 1 AÑO","index":5,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 17.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES - ESCENARIO 2, UN AÑO."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",58.353537943633931,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":3.7012447217773796},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":63.021820979124648},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":45.015586413660465},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":2338162.2690774673},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.51011116260563949,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365*1","v":365},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":9.1820009269015106},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":5840},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":9.1820009269015096E-3},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":400.37025155436083},"$/Hora"]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.55092005561409052},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":32913.830251554333},"$",null,null,"Kw CONSUMIDOS PROM.",5.6]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$11*$S$12,0)","v":0},{"$f":"+$S$11*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":6.7093655746024501}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":2.3991690124295754E-2},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$11*$S$12,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":6.5093655746024499}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},4.7983380248591508E-2,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":42.371840183819479}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,7.1975070372887251E-2,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":2.6437462298409855}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,9.5966760497183015E-2,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.11995845062147877,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,6,1.0799999999999998,1.0799999999999998,0,0,6.4799999999999995,0.14395014074577453,"","","","",0,0,0]
[null,7,1.0799999999999998,1.0799999999999998,0,0,7.56,0.16794183087007028,"","","","",0,0,0]
[null,8,1.0799999999999998,1.0799999999999998,0,0,8.6399999999999988,0.19193352099436603,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,9,1.0799999999999998,1.0799999999999998,0,0,9.7199999999999989,0.21592521111866178,"","","","",0,0,0]
[null,10,1.0799999999999998,1.0799999999999998,0,0,10.799999999999999,0.23991690124295753,"","","","",0,0,0]
[null,11,1.0799999999999998,1.0799999999999998,0,0,11.879999999999999,0.26390859136725331,"","","","",0,0,0]
[null,12,1.0799999999999998,1.0799999999999998,0,0,12.959999999999999,0.28790028149154906,"","","","",0,0,0]
[null,13,1.0799999999999998,1.0799999999999998,0,0,14.04,0.31189197161584481,"","","","",0,0,0]
[null,14,1.0799999999999998,1.0799999999999998,0,0,15.12,0.33588366174014056,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,16.2,0.35987535186443631,"","","","",0,0,0]
[null,16,1.0799999999999998,1.0799999999999998,0,0,17.279999999999998,0.38386704198873206,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,17,1.0799999999999998,1.0799999999999998,0,0,18.359999999999996,0.40785873211302776,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,18,1.0799999999999998,1.0799999999999998,0,0,19.439999999999994,0.43185042223732351,"","","","",0,0,0]
[null,19,1.0799999999999998,1.0799999999999998,0,0,20.519999999999992,0.4558421123616192,"","","","",0,0,0]
[null,20,1.0799999999999998,1.0799999999999998,0,0,21.599999999999991,0.4798338024859149,"","","","",0,0,0]
[null,21,1.0799999999999998,1.0799999999999998,0,0,22.679999999999989,0.50382549261021059,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,22,1.0799999999999998,1.0799999999999998,0,0,23.759999999999987,0.5278171827345064,"","","","",0,0,0]
[null,23,1.0799999999999998,1.0799999999999998,0,0,24.839999999999986,0.55180887285880209,"","","","",0,0,0]
[null,24,1.0799999999999998,1.0799999999999998,0,0,25.919999999999984,0.57580056298309779,"","","","",0,0,0]
[null,25,1.0799999999999998,1.0799999999999998,0,0,26.999999999999982,0.59979225310739348,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,26,1.0799999999999998,1.0799999999999998,0,0,28.079999999999981,0.62378394323168929,"","","","",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,28.60907994438589,0.63553720441380623,"ENCENDIDO BOMBA 1",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,28,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,29.138159888771799,0.64729046559592329,"","","","",928.9559999999999,0,928.9559999999999]
[null,29,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,29.667239833157709,0.65904372677804024,"","","","",928.9559999999999,0,928.9559999999999]
[null,30,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,30.196319777543618,0.6707969879601573,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,30.725399721929527,0.68255024914227425,"","","","",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,31.254479666315437,0.6943035103243913,"","","","",{"$f":"IF(E51>0,$S$11*$S$12,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.55092005561409052},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},31.783559610701349,{"$f":"+G51/$G$7","v":0.70605677150650836},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$11*$S$12,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,32.312639555087259,0.71781003268862542,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,32.841719499473164,0.72956329387074226,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,33.37079944385907,0.74131655505285921,"","","","",928.9559999999999,0,928.9559999999999]
[null,37,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,33.899879388244976,0.75306981623497615,"","","","",928.9559999999999,0,928.9559999999999]
[null,38,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,34.428959332630882,0.7648230774170931,"","","","",928.9559999999999,0,928.9559999999999]
[null,39,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,34.958039277016788,0.77657633859921005,"","","","",928.9559999999999,0,928.9559999999999]
[null,40,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,35.487119221402693,0.788329599781327,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,41,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,36.016199165788599,0.80008286096344383,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,36.545279110174505,0.81183612214556078,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,37.074359054560411,0.82358938332767773,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,37.603438998946316,0.83534264450979467,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,38.132518943332222,0.84709590569191162,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,38.661598887718128,0.85884916687402857,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,39.190678832104034,0.87060242805614541,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,39.71975877648994,0.88235568923826235,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,40.248838720875845,0.8941089504203793,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,40.777918665261751,0.90586221160249625,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,41.306998609647657,0.9176154727846132,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,41.836078554033563,0.92936873396673014,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,42.365158498419468,0.94112199514884698,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,42.894238442805374,0.95287525633096393,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,43.42331838719128,0.96462851751308087,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,43.952398331577186,0.97638177869519782,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,44.481478275963092,0.98813503987731477,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,45.010558220348997,0.99988830105943172,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,0.55092005561409052,0,45.539638164734903,1.0116415622415487,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,60,1.0799999999999998,1.0799999999999998,0.55092005561409052,0.55092005561409052,45.517798053506716,1.0111563944814868,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":32513.459999999974}]
[null,null,null,null,null,null,null,"B2",null,null,null,{"$f":"+COUNTIF(L18:L78,\"ENCENDIDO BOMBA 2\")","v":1}]

{"sheet":"ESC 2 EN B2 10 AÑOS","index":6,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 18.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES -  ESCENARIO 2, DIEZ AÑOS."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",56.000627441374682,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":3.6247162062046283},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":60.480677636684653},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":43.200484026203327},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":2289817.4280654993},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.55126156721328168,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365*10","v":3650},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":9.9227082098390706},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":58400},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":9.9227082098390703E-3},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":39.209202535368135},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.59536249259034424},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":33481.625202535339},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":6.5727075110796864}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":2.4999719895381821E-2},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":6.3727075110796862}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},4.9999439790763642E-2,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":40.611401021771449}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,7.4999159686145456E-2,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":2.5890830044318776}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,9.9998879581527284E-2,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.12499859947690911,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,6,1.0799999999999998,1.0799999999999998,0,0,6.4799999999999995,0.14999831937229094,"","","","",0,0,0]
[null,7,1.0799999999999998,1.0799999999999998,0,0,7.56,0.17499803926767277,"","","","",0,0,0]
[null,8,1.0799999999999998,1.0799999999999998,0,0,8.6399999999999988,0.19999775916305457,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,9,1.0799999999999998,1.0799999999999998,0,0,9.7199999999999989,0.22499747905843639,"","","","",0,0,0]
[null,10,1.0799999999999998,1.0799999999999998,0,0,10.799999999999999,0.24999719895381822,"","","","",0,0,0]
[null,11,1.0799999999999998,1.0799999999999998,0,0,11.879999999999999,0.27499691884920002,"","","","",0,0,0]
[null,12,1.0799999999999998,1.0799999999999998,0,0,12.959999999999999,0.29999663874458188,"","","","",0,0,0]
[null,13,1.0799999999999998,1.0799999999999998,0,0,14.04,0.32499635863996368,"","","","",0,0,0]
[null,14,1.0799999999999998,1.0799999999999998,0,0,15.12,0.34999607853534553,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,16.2,0.37499579843072733,"","","","",0,0,0]
[null,16,1.0799999999999998,1.0799999999999998,0,0,17.279999999999998,0.39999551832610913,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,17,1.0799999999999998,1.0799999999999998,0,0,18.359999999999996,0.42499523822149093,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,18,1.0799999999999998,1.0799999999999998,0,0,19.439999999999994,0.44999495811687268,"","","","",0,0,0]
[null,19,1.0799999999999998,1.0799999999999998,0,0,20.519999999999992,0.47499467801225448,"","","","",0,0,0]
[null,20,1.0799999999999998,1.0799999999999998,0,0,21.599999999999991,0.49999439790763628,"","","","",0,0,0]
[null,21,1.0799999999999998,1.0799999999999998,0,0,22.679999999999989,0.52499411780301808,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,22,1.0799999999999998,1.0799999999999998,0,0,23.759999999999987,0.54999383769839982,"","","","",0,0,0]
[null,23,1.0799999999999998,1.0799999999999998,0,0,24.839999999999986,0.57499355759378157,"","","","",0,0,0]
[null,24,1.0799999999999998,1.0799999999999998,0,0,25.919999999999984,0.59999327748916342,"","","","",0,0,0]
[null,25,1.0799999999999998,1.0799999999999998,0,0,26.999999999999982,0.62499299738454517,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,26,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,27.484637507409637,0.63621133251050577,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,27.969275014819292,0.64742966763646637,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,28,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,28.453912522228947,0.65864800276242685,"","","","",928.9559999999999,0,928.9559999999999]
[null,29,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,28.938550029638602,0.66986633788838745,"","","","",928.9559999999999,0,928.9559999999999]
[null,30,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,29.423187537048257,0.68108467301434805,"","","","",928.9559999999999,0,928.9559999999999]
[null,31,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,29.907825044457912,0.69230300814030854,"","","","",928.9559999999999,0,928.9559999999999]
[null,32,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,30.392462551867567,0.70352134326626914,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},0,928.9559999999999]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.59536249259034424},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0},30.877100059277222,{"$f":"+G51/$G$7","v":0.71473967839222974},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":0},928.9559999999999]
[null,34,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,31.361737566686877,0.72595801351819023,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,35,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,31.846375074096532,0.73717634864415083,"","","","",928.9559999999999,0,928.9559999999999]
[null,36,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,32.331012581506187,0.74839468377011142,"","","","",928.9559999999999,0,928.9559999999999]
[null,37,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,32.815650088915838,0.7596130188960718,"","","","",928.9559999999999,0,928.9559999999999]
[null,38,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,33.300287596325489,0.77083135402203229,"","","","",928.9559999999999,0,928.9559999999999]
[null,39,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,33.784925103735141,0.78204968914799278,"","","","",928.9559999999999,0,928.9559999999999]
[null,40,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,34.269562611144792,0.79326802427395327,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,41,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,34.754200118554444,0.80448635939991375,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,35.238837625964095,0.81570469452587424,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,35.723475133373746,0.82692302965183473,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,36.208112640783398,0.83814136477779522,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,36.692750148193049,0.8493596999037557,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,37.177387655602701,0.86057803502971619,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,37.662025163012352,0.87179637015567668,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,38.146662670422003,0.88301470528163717,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,38.631300177831655,0.89423304040759766,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,39.115937685241306,0.90545137553355803,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,39.600575192650957,0.91666971065951852,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,40.085212700060609,0.92788804578547901,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,40.56985020747026,0.9391063809114395,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,41.054487714879912,0.95032471603739999,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,41.539125222289563,0.96154305116336047,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,42.023762729699214,0.97276138628932096,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,42.508400237108866,0.98397972141528145,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,42.993037744518517,0.99519805654124194,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,0.59536249259034424,0,43.477675251928169,1.0064163916672024,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,60,1.0799999999999998,1.0799999999999998,0.59536249259034424,0.59536249259034424,43.366950266747473,1.0038533420237417,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":33442.415999999968}]
[null,null,null,null,null,null,null,"B2",null,null,null,{"$f":"+COUNTIF(L18:L78,\"ENCENDIDO BOMBA 2\")","v":1}]

{"sheet":"ESC 3 MAS EN B2 1 AÑO","index":7,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 19.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES - ESCENARIO 3, UN AÑO."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",9.49048774898381,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":1.4592355580021761},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":10.249726768902514},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":7.3212334063589388},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":921832.99940741155},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.91586963078466532,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365*1","v":365},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":16.485653354123976},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":5840},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.6485653354123976E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":157.84811633688554},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.98913920124743859},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":54966.252116336836},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":2.7057777821467415}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":0.14751612741398926},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":2.5057777821467413}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},0.29503225482797851,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":6.2789222935002416}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,0.44254838224196774,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":1.0423111128586973}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,0.59006450965595703,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.73758063706994637,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,6,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.4908607987525606,0.74999122333450152,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,7,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.5817215975051218,0.76240180959905679,"","","","",928.9559999999999,0,928.9559999999999]
[null,8,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.6725823962576829,0.77481239586361206,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,9,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.763443195010244,0.78722298212816721,"","","","",928.9559999999999,0,928.9559999999999]
[null,10,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.8543039937628052,0.79963356839272248,"","","","",928.9559999999999,0,928.9559999999999]
[null,11,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.9451647925153663,0.81204415465727775,"","","","",928.9559999999999,0,928.9559999999999]
[null,12,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.0360255912679275,0.82445474092183291,"","","","",928.9559999999999,0,928.9559999999999]
[null,13,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.1268863900204886,0.83686532718638817,"","","","",928.9559999999999,0,928.9559999999999]
[null,14,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.2177471887730498,0.84927591345094344,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,15,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.3086079875256109,0.8616864997154986,"","","","",928.9559999999999,0,928.9559999999999]
[null,16,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.3994687862781721,0.87409708598005387,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,17,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.4903295850307332,0.88650767224460914,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,18,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.5811903837832944,0.89891825850916429,"","","","",928.9559999999999,0,928.9559999999999]
[null,19,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.6720511825358555,0.91132884477371956,"","","","",928.9559999999999,0,928.9559999999999]
[null,20,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.7629119812884166,0.92373943103827483,"","","","",928.9559999999999,0,928.9559999999999]
[null,21,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.8537727800409778,0.93615001730282998,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,22,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.9446335787935389,0.94856060356738525,"","","","",928.9559999999999,0,928.9559999999999]
[null,23,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.0354943775461001,0.96097118983194052,"","","","",928.9559999999999,0,928.9559999999999]
[null,24,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.1263551762986603,0.97338177609649557,"","","","",928.9559999999999,0,928.9559999999999]
[null,25,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.2172159750512206,0.98579236236105072,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,26,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.3080767738037808,0.99820294862560577,"","","","",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.3989375725563411,1.0106135348901608,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,28,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,6.5006591700614624,0.88791858000528201,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,29,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,5.6023807675665847,0.76522362512040309,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,30,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,4.7041023650717069,0.64252867023552429,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,31,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,3.8058239625768295,0.51983371535064549,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,32,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,2.9075455600819522,0.39713876046576674,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},928.9559999999999,1857.9119999999998]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.98913920124743859},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0.98913920124743859},2.0092671575870753,{"$f":"+G51/$G$7","v":0.27444380558088805},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":928.9559999999999},1857.9119999999998]
[null,34,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,1.1109887550921984,0.15174885069600932,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,35,1.0799999999999998,1.0799999999999998,0,0,2.1909887550921985,0.29926497810999864,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,36,1.0799999999999998,1.0799999999999998,0,0,3.2709887550921986,0.44678110552398792,"","","","",0,0,0]
[null,37,1.0799999999999998,1.0799999999999998,0,0,4.3509887550921986,0.5942972329379772,"","","","",0,0,0]
[null,38,1.0799999999999998,1.0799999999999998,0,0,5.4309887550921987,0.74181336035196654,"","","","",928.9559999999999,0,928.9559999999999]
[null,39,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.5218495538447598,0.7542239466165217,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,40,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.612710352597321,0.76663453288107697,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,41,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.7035711513498821,0.77904511914563224,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.7944319501024433,0.79145570541018739,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.8852927488550044,0.80386629167474266,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,5.9761535476075656,0.81627687793929793,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.0670143463601267,0.82868746420385309,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.1578751451126879,0.84109805046840835,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.248735943865249,0.85350863673296362,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.3395967426178101,0.86591922299751878,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.4304575413703713,0.87832980926207405,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.5213183401229324,0.89074039552662931,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.6121791388754936,0.90315098179118447,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.7030399376280547,0.91556156805573974,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.7939007363806159,0.92797215432029501,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.884761535133177,0.94038274058485016,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,6.9756223338857382,0.95279332684940543,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.0664831326382993,0.9652039131139607,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.1573439313908596,0.97761449937851574,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.2482047301434198,0.9900250856430709,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,0.98913920124743859,0,7.3390655288959801,1.0024356719076259,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,60,1.0799999999999998,1.0799999999999998,0.98913920124743859,0.98913920124743859,6.4407871264011014,0.87974071702274703,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":54808.403999999951}]
[null,null,null,null,null,null,null,"B2",null,null,null,{"$f":"+COUNTIF(L18:L78,\"ENCENDIDO BOMBA 2\")","v":2}]

{"sheet":"ESC 3 MAS EN B2 10 AÑOS","index":8,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14],[78,12,78,13]]}
[]
[null,"CUADRO 20.  MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES - ESCENARIO 3, DIEZ AÑOS."]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",11.171986912943147,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":1.5879972852712401},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":12.065745865978599},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":8.6183899042704279},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":1003174.7736030917},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",0.86467988489763781,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365*10","v":3650},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":15.56423792815748},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":58400},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.556423792815748E-2},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":17.177650232929654},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":0.93385427568944879},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":56683.493650232878},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":2.9357094379843569}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":0.12531343000214668},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,{"$f":"IF(F20>0,$S$10*$S$11,0)","v":0},{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":2.7357094379843567}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},0.25062686000429335,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":7.484106129076685}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,0.37594029000643997,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":1.1342837751937429}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,0.5012537200085867,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.62656715001073338,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,6,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,5.5461457243105503,0.64352457778249561,"ENCENDIDO BOMBA 1","","","ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,7,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,5.692291448621102,0.66048200555425807,"","","","",928.9559999999999,0,928.9559999999999]
[null,8,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,5.8384371729316538,0.67743943332602041,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,9,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,5.9845828972422055,0.69439686109778276,"","","","",928.9559999999999,0,928.9559999999999]
[null,10,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.1307286215527572,0.7113542888695451,"","","","",928.9559999999999,0,928.9559999999999]
[null,11,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.2768743458633089,0.72831171664130745,"","","","",928.9559999999999,0,928.9559999999999]
[null,12,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.4230200701738607,0.7452691444130698,"","","","",928.9559999999999,0,928.9559999999999]
[null,13,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.5691657944844124,0.76222657218483225,"","","","",928.9559999999999,0,928.9559999999999]
[null,14,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.7153115187949641,0.7791839999565946,"",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,15,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.8614572431055159,0.79614142772835694,"","","","",928.9559999999999,0,928.9559999999999]
[null,16,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.0076029674160676,0.81309885550011929,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,17,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.1537486917266193,0.83005628327188163,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",928.9559999999999,0,928.9559999999999]
[null,18,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.299894416037171,0.84701371104364398,"","","","",928.9559999999999,0,928.9559999999999]
[null,19,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.4460401403477228,0.86397113881540633,"","","","",928.9559999999999,0,928.9559999999999]
[null,20,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.5921858646582745,0.88092856658716878,"","","","",928.9559999999999,0,928.9559999999999]
[null,21,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.7383315889688262,0.89788599435893113,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,22,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.884477313279378,0.91484342213069347,"","","","",928.9559999999999,0,928.9559999999999]
[null,23,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.0306230375899297,0.93180084990245582,"","","","",928.9559999999999,0,928.9559999999999]
[null,24,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.1767687619004814,0.94875827767421816,"","","","",928.9559999999999,0,928.9559999999999]
[null,25,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.3229144862110331,0.96571570544598051,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,26,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.4690602105215849,0.98267313321774297,"","","","",928.9559999999999,0,928.9559999999999]
[null,27,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.6152059348321366,0.99963056098950531,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,28,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.7613516591426883,1.0165879887612677,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,29,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,7.9736431077637917,0.92518941430264567,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,30,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,7.1859345563848951,0.83379083984402369,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,31,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,6.3982260050059985,0.74239226538540171,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,32,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,5.6105174536271019,0.65099369092677972,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":928.9559999999999},928.9559999999999,1857.9119999999998]
[null,33,1.0799999999999998,1.0799999999999998,{"$f":"IF(E50=0,IF(H50<$G$9,0,$C$11),IF(H50<$G$8,0,E50))","v":0.93385427568944879},{"$f":"IF(F50=0,IF(H50<$G$9,0,IF(H50<$G$10,0,$C$11)),IF(H50<$G$8,0,F50))","v":0.93385427568944879},4.8228089022482052,{"$f":"+G51/$G$7","v":0.55959511646815774},"","","","",928.9559999999999,{"$f":"IF(F52>0,$S$10*$S$11,0)","v":928.9559999999999},1857.9119999999998]
[null,34,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,4.0351003508693086,0.46819654200953581,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,35,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,3.2473917994904116,0.37679796755091377,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,36,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,2.4596832481115136,0.28539939309229162,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,37,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,1.6719746967326161,0.19400081863366958,"","","","",0,0,0]
[null,38,1.0799999999999998,1.0799999999999998,0,0,2.7519746967326162,0.31931424863581626,"","","APAGADO BOMBAS","APAGADO BOMBAS",0,0,0]
[null,39,1.0799999999999998,1.0799999999999998,0,0,3.8319746967326163,0.44462767863796299,"","","","",0,0,0]
[null,40,1.0799999999999998,1.0799999999999998,0,0,4.9119746967326163,0.56994110864010972,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,41,1.0799999999999998,1.0799999999999998,0,0,5.9919746967326164,0.69525453864225639,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,42,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.1381204210431672,0.71221196641401863,"ENCENDIDO BOMBA 1","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"ENCENDIDO BOMBA 1",928.9559999999999,0,928.9559999999999]
[null,43,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.284266145353719,0.72916939418578097,"","","","",928.9559999999999,0,928.9559999999999]
[null,44,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.4304118696642707,0.74612682195754332,"","","","",928.9559999999999,0,928.9559999999999]
[null,45,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.5765575939748224,0.76308424972930566,"","","","",928.9559999999999,0,928.9559999999999]
[null,46,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.7227033182853742,0.78004167750106812,"","","","",928.9559999999999,0,928.9559999999999]
[null,47,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,6.8688490425959259,0.79699910527283047,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,48,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.0149947669064776,0.81395653304459281,"","","","",928.9559999999999,0,928.9559999999999]
[null,49,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.1611404912170293,0.83091396081635516,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,50,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.3072862155275811,0.8478713885881175,"","","","",928.9559999999999,0,928.9559999999999]
[null,51,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.4534319398381328,0.86482881635987985,"","","","",928.9559999999999,0,928.9559999999999]
[null,52,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.5995776641486845,0.8817862441316423,"","","","",928.9559999999999,0,928.9559999999999]
[null,53,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.7457233884592362,0.89874367190340465,"","","","",928.9559999999999,0,928.9559999999999]
[null,54,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,7.891869112769788,0.915701099675167,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,55,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.0380148370803397,0.93265852744692934,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",928.9559999999999,0,928.9559999999999]
[null,56,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.1841605613908914,0.94961595521869169,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",928.9559999999999,0,928.9559999999999]
[null,57,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.3303062857014432,0.96657338299045403,"","","","",928.9559999999999,0,928.9559999999999]
[null,58,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.4764520100119949,0.98353081076221649,"","","","",928.9559999999999,0,928.9559999999999]
[null,59,1.0799999999999998,1.0799999999999998,0.93385427568944879,0,8.6225977343225466,1.0004882385339788,"","","","",928.9559999999999,928.9559999999999,1857.9119999999998]
[null,60,1.0799999999999998,1.0799999999999998,0.93385427568944879,0.93385427568944879,7.83488918294365,0.90908966407535685,"","ENCENDIDO BOMBA 2","","ENCENDIDO BOMBA 2",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":56666.315999999948}]
[null,null,null,null,null,null,null,"B2",null,null,null,{"$f":"+COUNTIF(L18:L78,\"ENCENDIDO BOMBA 2\")","v":2}]

{"sheet":"2ORIGINAL","index":9,"n_rows":79,"n_cols":20,"rows_kept":79,"cut":false,"hidden":false,"merged":[[24,17,24,19],[32,17,32,19],[78,12,78,13],[1,1,1,14],[3,1,3,3],[3,5,3,7],[3,12,3,14]]}
[]
[null,"MODELACIÓN   PARA OPTIMIZACIÓN DE LA RED DE BOMBEO AGUAS RESIDUALES"]
[]
[null,"DATOS BOMBEO",null,null,null,"DATOS POZO EYECTOR",null,null,null,null,null,null,"DATOS COSTOS",null,null,null,null,"ELEMENTO","VALOR"]
[null,null,null,null,null,"TIEMPO LLENADO ",30,"MIN",null,null,null,null,"VOL CONCRETO",{"$f":"+G11*$S$21","v":2.6379933184772404},"m3",null,null,"PLACA",{"$f":"152000/0.257","v":591439.68871595326}]
[null,"Q DISEÑO",18,"L/S",null,"VOL EYECTOR",{"$f":"+C6*$G$5*60/1000","v":32.4},"m3",null,null,null,null,"COSTO CONCRETO ",{"$f":"+S8","v":631723.2295719845},"$/m3",null,null,"VIGAS",723730]
[null,"Q DISEÑO",{"$f":"+C6/1000","v":1.7999999999999999E-2},"M3/S",null,"AREA ",{"$f":"+G6/G11","v":23.142857142857142},"m2",null,null,null,null,"COSTO TOTALPOZO",{"$f":"+N5*N6","v":1666481.6587377589},"$",null,null,"MURO",580000]
[null,"FRACCIONAMIENTO",78,null,null,"ALTURA (m)",0.2,"PARADO BOMBAS",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"365","v":365},"dias",null,null,"PROMEDIO ",{"$f":"+AVERAGE(S5:S7)","v":631723.2295719845}]
[null,"Q BOMBEO",{"$f":"$C$8*C6","v":1404},"L/S",null,null,{"$f":"+G8+0.4","v":0.60000000000000009},"ENCENDIDO BOMBA 1",null,null,null,null,"TIEMPO AMORTIZACIÓN",{"$f":"+N8*16","v":5840},"HORAS"]
[null,"Q BOMBEO",{"$f":"C8*C7","v":1.4039999999999999},"L/S",null,null,{"$f":"+G9+0.4","v":1},"ENCENDIDO BOMBA 2",null,null,null,null,"COSTO POZO",{"$f":"N5*N6/N9","v":285.35644841399983},"$/Hora",null,null,"COSTO $/KW",{"$f":"+(208.12+123.65)/2","v":165.88499999999999}]
[null,"Q BOMBEO",{"$f":"+C10*60","v":84.24},"M3/S",null,null,{"$f":"+G10+0.4","v":1.4},"NIVEL ALARMA",null,null,null,null,null,null,null,null,null,"Kw CONSUMIDOS PROM.",5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL",{"$f":"N10+O79","v":1214.3124484139998},"$"]
[]
[]
[null,1,2,3,4,5,6,7,null,null,null,8,9,10,11]
[]
[null,"TIEMPO T (MIN)","Qentrada M3/MIN","VOLUMEN ENTRADA (m3)","VOL SALIDA 1  (m3)","VOL SALIDA 2 (m3)","VOLUMEN ACUMULADO (m3)","ALTURA (m)","OBS","OBS","OBS","OBS","COSTO KW ($) ENCENDIDO BOMBA 1","COSTO KW ($) ENCENDIDO BOMBA 2","COSTO KW ($) ENCENDIDO BOMBAS 1 Y 2"]
[null,0,null,null,0,0,null,null,null,null,null,null,{"$f":"IF(E19>0,$S$10*$S$11,0)","v":0},{"$f":"+$S$10*F19","v":0},{"$f":"SUM(M18:N18)","v":0},null,null,"LADO EXT POZO",{"$f":"SQRT(G7)","v":4.8107023544236389}]
[null,1,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C19*1","v":1.0799999999999998},{"$f":"IF(E18=0,IF(H18<$G$9,0,$C$11),IF(H18<$G$8,0,E18))","v":0},{"$f":"IF(F18=0,IF(H18<$G$9,0,IF(H18<$G$10,0,$C$11)),IF(H18<$G$8,0,F18))","v":0},{"$f":"+D19-E19-F19","v":1.0799999999999998},{"$f":"+G19/$G$7","v":4.6666666666666662E-2},{"$f":"+IF(E18=0,IF(E19>0,\"ENCENDIDO BOMBA 1\",IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F18=0,IF(F19>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F18>0,IF(F19=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I19,J19,K19)","v":""},0,0,{"$f":"SUM(M19:N19)","v":0},null,null,"LADO INT  POZO",{"$f":"+S18-0.2","v":4.6107023544236387}]
[null,2,{"$f":"+$C$7*60","v":1.0799999999999998},{"$f":"+C20*1","v":1.0799999999999998},0,0,{"$f":"+G19+D20-E20-F20","v":2.1599999999999997},9.3333333333333324E-2,{"$f":"+IF(E19=0,IF(E20>0,\"ENCENDIDO BOMBA 1\",IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"))))","v":""},{"$f":"+IF(F19=0,IF(F20>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F19>0,IF(F20=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},{"$f":"+CONCATENATE(I20,J20,K20)","v":""},0,0,0,null,null,"AREA INTERIOR",{"$f":"+S19*S19","v":21.258576201087685}]
[null,3,1.0799999999999998,1.0799999999999998,0,0,3.2399999999999993,0.13999999999999999,"","","","",0,0,0,null,null,"D AREA",{"$f":"+G7-S20","v":1.8842809417694575}]
[null,4,1.0799999999999998,1.0799999999999998,0,0,4.3199999999999994,0.18666666666666665,{"$f":"+IF(E21=0,IF(E22>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,5,1.0799999999999998,1.0799999999999998,0,0,5.3999999999999995,0.23333333333333331,{"$f":"+IF(E22=0,IF(E23>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0]
[null,6,1.0799999999999998,1.0799999999999998,0,0,6.4799999999999995,0.27999999999999997,"","","","",0,0,0]
[null,7,1.0799999999999998,1.0799999999999998,0,0,7.56,0.32666666666666666,"","","","",0,0,0,null,null,"DATOS BOMBEO EXISTENTE"]
[null,8,1.0799999999999998,1.0799999999999998,0,0,8.6399999999999988,0.37333333333333329,"",{"$f":"+IF(F25=0,IF(F26>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0,null,null,"Q DISEÑO",18,"L/S"]
[null,9,1.0799999999999998,1.0799999999999998,0,0,9.7199999999999989,0.42,"","","","",0,0,0,null,null,"TAMAÑO POZO",{"$f":"1.4*1.5*1.5","v":3.1499999999999995},"m3"]
[null,10,1.0799999999999998,1.0799999999999998,0,0,10.799999999999999,0.46666666666666662,"","","","",0,0,0]
[null,11,1.0799999999999998,1.0799999999999998,0,0,11.879999999999999,0.51333333333333331,"","","","",0,0,0]
[null,12,1.0799999999999998,1.0799999999999998,0,0,12.959999999999999,0.55999999999999994,"","","","",0,0,0]
[null,13,1.0799999999999998,1.0799999999999998,0,0,14.04,0.60666666666666669,"","","","",928.9559999999999,0,928.9559999999999]
[null,14,1.0799999999999998,1.0799999999999998,84.24,0,-69.11999999999999,-2.9866666666666664,"ENCENDIDO BOMBA 1",{"$f":"+IF(F31=0,IF(F32>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","ENCENDIDO BOMBA 1",0,0,0]
[null,15,1.0799999999999998,1.0799999999999998,0,0,-68.039999999999992,-2.9399999999999995,"","","","",0,0,0,null,null,"DATOS BOMBEO ALL EXISTENTE"]
[null,16,1.0799999999999998,1.0799999999999998,0,0,-66.959999999999994,-2.8933333333333331,"","",{"$f":"+IF(F33>0,IF(F34=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0,null,null,"Q DISEÑO",92,"L/S"]
[null,17,1.0799999999999998,1.0799999999999998,0,0,-65.88,-2.8466666666666667,{"$f":"+IF(E34=0,IF(E35>0,\"ENCENDIDO BOMBA 1\",\"\"),\"\")","v":""},"","","",0,0,0,null,null,"CDT",6,"m"]
[null,18,1.0799999999999998,1.0799999999999998,0,0,-64.8,-2.8,"","","","",0,0,0,null,null,"FRACCION.","2 BOMBAS DEL 100%"]
[null,19,1.0799999999999998,1.0799999999999998,0,0,-63.72,-2.7533333333333334,"","","","",0,0,0]
[null,20,1.0799999999999998,1.0799999999999998,0,0,-62.64,-2.7066666666666666,"","","","",0,0,0]
[null,21,1.0799999999999998,1.0799999999999998,0,0,-61.56,-2.66,"",{"$f":"+IF(F38=0,IF(F39>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,22,1.0799999999999998,1.0799999999999998,0,0,-60.480000000000004,-2.6133333333333337,"","","","",0,0,0]
[null,23,1.0799999999999998,1.0799999999999998,0,0,-59.400000000000006,-2.5666666666666669,"","","","",0,0,0]
[null,24,1.0799999999999998,1.0799999999999998,0,0,-58.320000000000007,-2.5200000000000005,"","","","",0,0,0]
[null,25,1.0799999999999998,1.0799999999999998,0,0,-57.240000000000009,-2.4733333333333336,"","",{"$f":"+IF(F42>0,IF(F43=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,26,1.0799999999999998,1.0799999999999998,0,0,-56.160000000000011,-2.4266666666666672,"","","","",0,0,0]
[null,27,1.0799999999999998,1.0799999999999998,0,0,-55.080000000000013,-2.3800000000000008,"",{"$f":"+IF(F44=0,IF(F45>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,28,1.0799999999999998,1.0799999999999998,0,0,-54.000000000000014,-2.3333333333333339,"","","","",0,0,0]
[null,29,1.0799999999999998,1.0799999999999998,0,0,-52.920000000000016,-2.2866666666666675,"","","","",0,0,0]
[null,30,1.0799999999999998,1.0799999999999998,0,0,-51.840000000000018,-2.2400000000000007,"","","","",0,0,0]
[null,31,1.0799999999999998,1.0799999999999998,0,0,-50.760000000000019,-2.1933333333333342,"","","","",0,0,0]
[null,32,1.0799999999999998,1.0799999999999998,0,0,-49.680000000000021,-2.1466666666666678,"","","","",{"$f":"IF(E51>0,$S$10*$S$11,0)","v":0},0,0]
[null,33,1.0799999999999998,1.0799999999999998,0,0,-48.600000000000023,-2.100000000000001,"","","","",0,0,0]
[null,34,1.0799999999999998,1.0799999999999998,0,0,-47.520000000000024,-2.0533333333333346,"",{"$f":"+IF(F51=0,IF(F52>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,35,1.0799999999999998,1.0799999999999998,0,0,-46.440000000000026,-2.0066666666666677,"","","","",0,0,0]
[null,36,1.0799999999999998,1.0799999999999998,0,0,-45.360000000000028,-1.9600000000000013,"","","","",0,0,0]
[null,37,1.0799999999999998,1.0799999999999998,0,0,-44.28000000000003,-1.9133333333333347,"","","","",0,0,0]
[null,38,1.0799999999999998,1.0799999999999998,0,0,-43.200000000000031,-1.866666666666668,"","","","",0,0,0]
[null,39,1.0799999999999998,1.0799999999999998,0,0,-42.120000000000033,-1.8200000000000014,"","","","",0,0,0]
[null,40,1.0799999999999998,1.0799999999999998,0,0,-41.040000000000035,-1.7733333333333348,"",{"$f":"+IF(F57=0,IF(F58>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},{"$f":"+IF(F57>0,IF(F58=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,41,1.0799999999999998,1.0799999999999998,0,0,-39.960000000000036,-1.7266666666666683,"","",{"$f":"+IF(F58>0,IF(F59=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,42,1.0799999999999998,1.0799999999999998,0,0,-38.880000000000038,-1.6800000000000017,"","",{"$f":"+IF(F59>0,IF(F60=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,43,1.0799999999999998,1.0799999999999998,0,0,-37.80000000000004,-1.6333333333333351,"","","","",0,0,0]
[null,44,1.0799999999999998,1.0799999999999998,0,0,-36.720000000000041,-1.5866666666666684,"","","","",0,0,0]
[null,45,1.0799999999999998,1.0799999999999998,0,0,-35.640000000000043,-1.5400000000000018,"","","","",0,0,0]
[null,46,1.0799999999999998,1.0799999999999998,0,0,-34.560000000000045,-1.4933333333333354,"","","","",0,0,0]
[null,47,1.0799999999999998,1.0799999999999998,0,0,-33.480000000000047,-1.4466666666666688,"",{"$f":"+IF(F64=0,IF(F65>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,48,1.0799999999999998,1.0799999999999998,0,0,-32.400000000000048,-1.4000000000000021,"","","","",0,0,0]
[null,49,1.0799999999999998,1.0799999999999998,0,0,-31.32000000000005,-1.3533333333333355,"",{"$f":"+IF(F66=0,IF(F67>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,50,1.0799999999999998,1.0799999999999998,0,0,-30.240000000000052,-1.3066666666666689,"","","","",0,0,0]
[null,51,1.0799999999999998,1.0799999999999998,0,0,-29.160000000000053,-1.2600000000000022,"","","","",0,0,0]
[null,52,1.0799999999999998,1.0799999999999998,0,0,-28.080000000000055,-1.2133333333333358,"","","","",0,0,0]
[null,53,1.0799999999999998,1.0799999999999998,0,0,-27.000000000000057,-1.1666666666666692,"","","","",0,0,0]
[null,54,1.0799999999999998,1.0799999999999998,0,0,-25.920000000000059,-1.1200000000000025,"","",{"$f":"+IF(F71>0,IF(F72=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,55,1.0799999999999998,1.0799999999999998,0,0,-24.84000000000006,-1.0733333333333359,"","",{"$f":"+IF(F72>0,IF(F73=0,\"APAGADO BOMBAS\",\"\"),\"\")","v":""},"",0,0,0]
[null,56,1.0799999999999998,1.0799999999999998,0,0,-23.760000000000062,-1.0266666666666693,"",{"$f":"+IF(F73=0,IF(F74>0,\"ENCENDIDO BOMBA 2\",\"\"),\"\")","v":""},"","",0,0,0]
[null,57,1.0799999999999998,1.0799999999999998,0,0,-22.680000000000064,-0.98000000000000276,"","","","",0,0,0]
[null,58,1.0799999999999998,1.0799999999999998,0,0,-21.600000000000065,-0.93333333333333612,"","","","",0,0,0]
[null,59,1.0799999999999998,1.0799999999999998,0,0,-20.520000000000067,-0.8866666666666696,"","","","",0,0,0]
[null,60,1.0799999999999998,1.0799999999999998,0,0,-19.440000000000069,-0.84000000000000297,"","","","",0,0,{"$f":"SUM(M78:N78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"COSTO TOTAL OPERACIÓN BOMBAS POR HORA",null,{"$f":"SUM(O18:O78)","v":928.9559999999999}]

{"sheet":"ANALISIS","index":10,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[39,10,39,13],[45,1,48,1],[49,1,52,1]]}
[null,null,"PARA FRACCIONAMIENTO 75% Y UN AÑO DE AMORTIZACIÓN"]
[null,null,"COMPORTAMIENTO TIEMPO ALMACENAMIENTO -  COSTO"]
[]
[null,null,"T(MIN)","COSTO MÍNIMO"]
[null,null,5,72405.803465673394]
[null,null,10,67708.258931346892]
[null,null,15,63939.670397020367]
[null,null,20,68531.685862693819]
[null,null,25,69407.877328367278]
[null,null,30,60994.508794040754]
[null,null,35,51652.184259714246]
[null,null,40,46025.683725387731]
[null,null,45,45043.963191061208]
[null,null,50,44062.242656734677]
[null,null,55,43080.522122408154]
[null,null,60,42098.801588081624]
[]
[]
[]
[]
[]
[null,null,"PARA 3O MIN DE POZO Y UN AÑO DE AMORTIZACIÓN"]
[null,null,"COMPORTAMIENTO FRACCIONAMIENTO -  COSTO"]
[]
[null,null,"FRACCIONAMIENTO","COSTO MÍNIMO"]
[null,null,0.5,76786.760794040762]
[null,null,0.55000000000000004,74928.848794040765]
[null,null,0.6,72141.980794040763]
[null,null,0.65,69355.11279404076]
[null,null,0.7,65639.288794040767]
[null,null,0.75,60994.508794040754]
[null,null,0.8,52633.904794040769]
[null,null,0.85,48918.080794040776]
[null,null,0.9,48918.080794040776]
[null,null,0.95,48918.080794040776]
[null,null,1,48918.080794040798]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"COMPORTAMIENTO FRACCIONAMIENTO -  COSTO\n"]
[]
[]
[]
[]
[null,"PERIODO DE TIEMPO "," ESCENARIO","ACTUAL (CONSTRUIDO)","1 -LIMITES NORMA","2 - SIN RESTRICCIONES AL ENCENDIDO DE LA BOMBA 2","3 -  RESTRINGENDO A 1 EL ENCENDIDO DE LA BOMBA 2","4 -  RESTRINGENDO A 2 EL ENCENDIDO DE LA BOMBA 2",null,null,"+"]
[null,"1 AÑO","COSTO MÍNIMO",{"$f":"+ACTUAL!N12","v":53965.543599833807},{"$f":"+'NORMA 1 AÑO'!N12","v":71642.523675241377},{"$f":"+'ESC 1 1 AÑO'!N12","v":31984.840086864249},{"$f":"+'ESC 2 EN B2 1 AÑO'!N12","v":32913.830251554333},{"$f":"+'ESC 3 MAS EN B2 1 AÑO'!N12","v":54966.252116336836},null,null,{"$f":"1-(F46/$D$46)","v":0.40730996200022063},{"$f":"1-(G46/$F$46)","v":-2.9044702495530261E-2},{"$f":"1-(H46/$D$46)","v":-1.8543471440286119E-2}]
[null,null,"FRACCIONAMIENTO",{"$f":"+ACTUAL!C8","v":1},{"$f":"+'NORMA 1 AÑO'!C8","v":0.75},{"$f":"+'ESC 1 1 AÑO'!C8","v":0.65345775462050981},{"$f":"+'ESC 2 EN B2 1 AÑO'!C8","v":0.51011116260563949},{"$f":"+'ESC 3 MAS EN B2 1 AÑO'!C8","v":0.91586963078466532}]
[null,null,"TIEMPO LLENADO TANQUE (MIN)",{"$f":"+ACTUAL!G5","v":3},{"$f":"+'NORMA 1 AÑO'!G5","v":5},{"$f":"+'ESC 1 1 AÑO'!G5","v":58.343727854881202},{"$f":"+'ESC 2 EN B2 1 AÑO'!G5","v":58.353537943633931},{"$f":"+'ESC 3 MAS EN B2 1 AÑO'!G5","v":9.49048774898381}]
[null,null,"VER CUADRO No.",12,{"$f":"+D49+1","v":13},{"$f":"+E49+1","v":14},15,{"$f":"+G49+1","v":16}]
[null,"10 AÑOS","COSTO MÍNIMO","-",{"$f":"+'NORMA 10 AÑOS'!N12","v":71540.903167524069},{"$f":"+'ESC 1 10AÑOS'!N12","v":31624.704740091529},{"$f":"+'ESC 2 EN B2 10 AÑOS'!N12","v":33481.625202535339},{"$f":"+'ESC 3 MAS EN B2 10 AÑOS'!N12","v":56683.493650232878}]
[null,null,"FRACCIONAMIENTO","-",{"$f":"+'NORMA 10 AÑOS'!C8","v":0.75},{"$f":"+'ESC 1 10AÑOS'!C8","v":0.97549248311458736},{"$f":"+'ESC 2 EN B2 10 AÑOS'!C8","v":0.55126156721328168},{"$f":"+'ESC 3 MAS EN B2 10 AÑOS'!C8","v":0.86467988489763781}]
[null,null,"TIEMPO LLENADO TANQUE","-",{"$f":"+'NORMA 10 AÑOS'!G5","v":5},{"$f":"+'ESC 1 10AÑOS'!G5","v":58.824597510427516},{"$f":"+'ESC 2 EN B2 10 AÑOS'!G5","v":56.000627441374682},{"$f":"+'ESC 3 MAS EN B2 10 AÑOS'!G5","v":11.171986912943147}]
[null,null,"VER CUADRO No.",null,{"$f":"+H49+1","v":17},{"$f":"+E53+1","v":18},19,{"$f":"+G53+1","v":20}]
[]
[]
[]
[null,null,null,null,{"$f":"1-(E50/$E$46)","v":1.4184384148436813E-3},{"$f":"1-(F50/$F$46)","v":1.1259563774421499E-2},{"$f":"1-(G50/$G$46)","v":-1.7250953372532241E-2},{"$f":"1-(H50/$H$46)","v":-3.1241743211115836E-2}]
[null,null,null,null,null,{"$f":"+F52-F48","v":0.48086965554631433},-2.3529105022592489,{"$f":"+H52-H48","v":1.6814991639593373}]
[null,null,null,null,null,null,null,{"$f":"(H48/$H$52)","v":0.84948969444179534}]