{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Datos de entrada","Bombas coincidentes","Linea de impulsión","Pozo humedo","Optimización","K accesorios","Datos curvas","Prop. Agua","Tuberías","Base de datos","APU"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":20,"comments":2,"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":"Datos de entrada","index":0,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[23,2,23,4],[24,2,24,4],[16,2,16,4],[17,2,17,4],[39,2,39,6],[38,2,38,4],[28,2,28,4],[2,1,2,7],[4,2,4,6],[35,2,35,4],[36,2,36,4],[37,2,37,4],[19,2,19,6],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[6,2,6,6],[25,2,25,4],[26,2,26,4],[27,2,27,4],[7,2,7,4],[20,2,21,4],[22,2,22,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4]]}
[]
[]
[null,"DATOS DE ENTRADA"]
[]
[null,null,"Ingresar los siguientes datos:"]
[]
[null,null,"DATOS DE ENTRADA"]
[null,null,"Caudal de diseño",null,null,20,"m3/hr"]
[null,null,"Cota terreno",null,null,45,"msnm"]
[null,null,"Cota Batea afluente a la EBAR",null,null,43.63,"msnm"]
[null,null,"Cota del Nivel de Entrega",null,null,47,"msnm"]
[null,null,"Longitud  entre salida de EBAR y descarga",null,null,50,"m"]
[null,null,"Temperatura del liquido",null,null,15,"ºC"]
[null,null,"Tiempo del ciclo requerido",null,null,15,"min"]
[null,null,"Valor por kW",null,null,800,"$/kW.hr"]
[null,null,"Periodo de diseño",null,null,20,"años"]
[null,null,"Tasa Aumento del costo energético",null,null,0.05]
[null,null,"Tasa de descuento",null,null,0.12,"EA"]
[]
[null,null,"Cantidad de accesorios por tubería de impulsión"]
[null,null,"Accesorios",null,null,"Impulsión 1","impulsión 2"]
[null,null,null,null,null,"Cant","Cant"]
[null,null,"Válvula de globo",null,null,0,0]
[null,null,"Válvula de mariposa",null,null,0,0]
[null,null,"Válvula de Cheque",null,null,1,0]
[null,null,"Válvula de compuerta",null,null,1,0]
[null,null,"Codo 90 radio corto",null,null,0,3]
[null,null,"Codo 90 radio medio",null,null,0,0]
[null,null,"Codo 90 gran radio",null,null,1,0]
[null,null,"Codo 45",null,null,0,2]
[null,null,"Te, en sentido recto",null,null,2,1]
[null,null,"Te, a través de la salida lateral",null,null,0,0]
[null,null,"Uniones",null,null,1,0]
[null,null,"ye de 45°, en sentido recto",null,null,0,0]
[null,null,"ye de 45°, en sentido lateral",null,null,0,0]
[null,null,"Entrada recta a tope",null,null,0,0]
[null,null,"Entrada con boca acampanada",null,null,0,0]
[null,null,"Entrada con tubo entrante",null,null,0,0]
[null,null,"Salida tubería",null,null,0,1]
[null,null,"Nota: impulsión 1 se refiere a la tubería dentro de la estación de bombeo, incluida la cámara de válvulas; impulsión 2 se refiere a la tubería desde la estación de bombeo hasta el punto de descarga."]

{"sheet":"Bombas coincidentes","index":1,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,15,12,21],[14,7,15,7],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,5,15,5],[12,6,12,9],[9,2,9,4],[12,2,12,3],[1,0,1,13],[4,6,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[3,2,3,10],[9,6,9,8],[10,6,10,8]]}
[]
["BOMBAS DISPONIBLES PARA LOS DATOS SUMINISTRADOS"]
[]
[null,null,"INFORMACIÓN DEL PUNTO BOMBEO"]
[null,null,"Caudal",{"$f":"Q/3.6","v":5.5555555555555554},"l/s",null,"Pérdidas por fricción Impulsión 1",null,null,{"$f":"'Linea de impulsión'!D24","v":0.24598152373760285},"m"]
[null,null,"Caudal",{"$f":"'Datos de entrada'!F8","v":20},"m3/hr",null,"Pérdidas menores Impulsión 1",null,null,{"$f":"'Linea de impulsión'!D27","v":0.65876514574120215},"m"]
[null,null,"Altura Geométrica",{"$f":"'Datos de entrada'!F11-'Pozo humedo'!D17","v":4.8500000000000014},"m",null,"Pérdidas por fricción Impulsión 2",null,null,{"$f":"'Linea de impulsión'!H24","v":1.0138713652268347},"m"]
[null,null,"Altura Total",{"$f":"D7+'Linea de impulsión'!D29+'Linea de impulsión'!H29","v":7.1316940630021595},"m",null,"Pérdidas menores Impulsión 2",null,null,{"$f":"'Linea de impulsión'!H27","v":0.36307602829651825},"m"]
[]
[null,null,"VALIDACIÓN DE LAS POSIBLES BOMBAS ",null,null,null,"Peso específico ",null,null,{"$f":"VLOOKUP('Linea de impulsión'!D7,'Prop. Agua'!$A$3:$B$16,2,FALSE)","v":9.798},"kN/m3"]
[null,null,null,null,null,null,"Potencia útil",null,null,{"$f":"J10*(Q/3600)*H","v":0.38820188016275087},"kW"]
[]
[null,null,"No. De opciones",null,{"$f":"COUNTIF('Base de datos'!W:W,\"OK\")","v":19},null,null,null,null,null,null,null,null,null,null,"GRAFICA DE LA CURVA DEL SISTEMA VS CURVA DE LA BOMBA",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(\"X\",$B$17:$M$56,2,FALSE),\"\")","v":"DRV/A50-155-1.8M"}]
[]
[null,"Graficar","Modelo","Empresa","f Sólidos","Conexión","f Descarga","Motor","Potencia","Velocidad","Sumergencia","f Impulsor","Eficiencia"]
[null,null,null,null,"[mm]",null,"DN [mm]",null,"[kW]","[R.P.M]","[mm]","[mm]"," [%]"]
[null,"X","DRV/A50-155-1.8M","EBARA",50,"Bridado",50,"Monofásico",1.8,2900,339,110,74.552999999999997]
[null,null,"DRV/A50-140-1.8M","EBARA",50,"Bridado",50,"Monofásico",1.8,2900,339,110,69.257999999999996]
[null,null,"DRV/A50-140-1.4","EBARA",50,"Bridado",50,"Trifásico",1.4,2900,339,110,69.257999999999996]
[null,null,"DRV/A65-119-2.3","EBARA",65,"Bridado",65,"Trifásico",2.2999999999999998,2900,367,110,66.082999999999998]
[null,null,"FEKA 2500.4T","DAB",62,"Bridado",65,"Trifásico",1.4,2900,400,110,65.769000000000005]
[null,null,"ARS 50-14MI/1,4","BOMBAS IDEAL",25,"Bridado",50,"Trifásico",1,2850,297,110,65.504000000000005]
[null,null,"AS0630 S13/4D","ABS",60,"Brida DN",65,"Trifásico",1.3,1450,348,186,64.158999999999992]
[null,null,"FEKA 3030.2T","DAB",67,"Bridado",80,"Trifásico",2.2999999999999998,2900,400,110,64.106999999999999]
[null,null,"FEKA 1400 M","DAB",38,"Roscado",50,"Monofásico",1.1000000000000001,2900,400,110,62.569000000000003]
[null,null,"AS0840 S12/2W","ABS",30,"Brida DN",80,"Monofásico",1.2,2900,305,118,62.511000000000003]
[null,null,"ARS 80-18V/1,7","BOMBAS IDEAL",50,"Bridado",80,"Trifásico",1,1450,420,110,61.814999999999998]
[null,null,"ARS 50-16V/1,8","BOMBAS IDEAL",50,"Roscado",50,"Trifásico",1.3,2850,339,110,54.322000000000003]
[null,null,"AS0840 S12/2D","ABS",30,"Brida DN",80,"Trifásico",1.2,2900,305,118,52.511000000000003]
[null,null,"ARS 65-18V/1,7","BOMBAS IDEAL",50,"Roscado",65,"Trifásico",1.2,1450,383,110,52.108999999999995]
[null,null,"DRV/A65-182-1.4","EBARA",50,"Bridado",65,"Trifásico",1.3,2900,383,110,51.445999999999998]
[null,null,"DRV/A80-182-1.4","EBARA",50,"Bridado",80,"Trifásico",1.4,2900,418,110,51.011799999999987]
[null,null,"DRV/A65-182-1.2M","EBARA",50,"Bridado",65,"Monofásico",1.2,2900,383,110,50.667599999999993]
[null,null,"DRV/A80-182-1.2M","EBARA",50,"Bridado",80,"Monofásico",1.2,2900,418,110,50.499699999999997]
[null,null,"AS0830 S13/4D","ABS",60,"Brida DN",80,"Trifásico",1.3,1450,305,186,48.78]

{"sheet":"Linea de impulsión","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,7,8,8],[8,3,8,4],[1,1,1,9],[4,2,4,4],[11,2,11,4],[11,6,11,8],[7,3,7,4]]}
[]
[null,"DIMENSIONAMIENTO LÍNEA DE IMPULSIÓN"]
[]
[]
[null,null,"DATOS DE ENTRADA TUBERÍA DE IMPULSIÓN"]
[null,null,"Longitud ",{"$f":"'Datos de entrada'!F12","v":50},"m"]
[null,null,"Temperatura",{"$f":"'Datos de entrada'!F13","v":15},"ºC"]
[]
[null,null,"Material impulsión 1",{"$f":"Optimización!O3","v":"HD"},null,null,"Material impulsión 2",{"$f":"Optimización!O4","v":"GRP"}]
[null,null,"Longitud impulsión 1",{"$f":"'Pozo humedo'!D20","v":3.3999999999999986},"m",null,"longitud impulsión 2",{"$f":"D6","v":50},"m"]
[]
[null,null,"PÉRDIDAS POR FRICCIÓN IMPULSIÓN 1",null,null,null,"PÉRDIDAS POR FRICCIÓN IMPULSIÓN 2"]
[null,null,"Caudal de diseño",{"$f":"Q/3.6","v":5.5555555555555554},"l/s",null,"Caudal de diseño",{"$f":"Q/3.6","v":5.5555555555555554},"l/s"]
[null,null,"Velocidad mínima",1.6,"m/s",null,"Velocidad mínima",1.1000000000000001,"m/s"]
[null,null,"Velocidad máxima",2.4,"m/s",null,"Velocidad máxima",2.4,"m/s"]
[null,null,"Diámetro máximo",{"$f":"1.128*SQRT(($D$13/1000)/D14)*1000","v":66.46803743153545},"mm",null,"Diámetro máximo",{"$f":"1.128*SQRT(($H$13/1000)/H14)*1000","v":80.163469349709516},"mm"]
[null,null,"Diámetro mínimo",{"$f":"1.128*SQRT(($D$13/1000)/D15)*1000","v":54.270925303824818},"mm",null,"Diámetro mínimo",{"$f":"1.128*SQRT(($H$13/1000)/H15)*1000","v":54.270925303824818},"mm"]
[null,null,"Diámetro",{"$f":"Optimización!P3","v":2.5},"plg",null,"Diámetro",{"$f":"Optimización!P4","v":3},"plg"]
[null,null,"Rugosidad absoluta \"ε\"",{"$f":"VLOOKUP(D9,Tuberías!$B$3:$C$8,2,FALSE)","v":0.25},"mm",null,"Rugosidad absoluta \"ε\"",{"$f":"VLOOKUP(H9,Tuberías!$B$3:$C$8,2,FALSE)","v":0.03},"mm"]
[null,null,"Velocidad en la impulsión",{"$f":"(D13/1000)/(PI()*(D18*0.0254)^2/4)","v":1.7542446590133198},"m/s",null,"Velocidad en la impulsión",{"$f":"(H13/1000)/(PI()*(H18*0.0254)^2/4)","v":1.2182254576481393},"m/s"]
[null,null,"u",{"$f":"VLOOKUP(D7,'Prop. Agua'!$A$3:$H$16,6,FALSE)","v":1.139E-6},"m2/s",null,"u",{"$f":"VLOOKUP(D7,'Prop. Agua'!$A$3:$H$16,6,FALSE)","v":1.139E-6},"m2/s"]
[null,null,"Re",{"$f":"D20*($D$18*0.0254)/$D$21","v":97800.294861585426},"-",null,"Re",{"$f":"H20*($H$18*0.0254)/$H$21","v":81500.245717987884},"-"]
[null,null,"Coeficiente de fricción \"f\"",{"$f":"ffriccion(D19/1000,D22,D18*0.0254)","v":2.9289770773005701E-2},"-",null,"Coeficiente de fricción \"f\"",{"$f":"ffriccion(H19/1000,H22,H18*0.0254)","v":2.042732439733054E-2},"-"]
[null,null,"Pérdidas por fricción",{"$f":"D23*D10/(D18*0.0254)*D20^2/(2*9.81)","v":0.24598152373760285},"m",null,"Pérdidas por fricción",{"$f":"H23*H10/(H18*0.0254)*H20^2/(2*9.81)","v":1.0138713652268347},"m"]
[]
[null,null,"Suma de K de accesorio",{"$f":"SUM('K accesorios'!C3:C19)","v":4.2},null,null,"Suma de K de accesorio",{"$f":"SUM('K accesorios'!D3:D19)","v":4.8}]
[null,null,"Pérdidas locales",{"$f":"D26*'Linea de impulsión'!D20^2/(2*9.81)","v":0.65876514574120215},"m",null,"Pérdidas locales",{"$f":"H26*'Linea de impulsión'!H20^2/(2*9.81)","v":0.36307602829651825},"m"]
[]
[null,null,"Pérdidas de energía",{"$f":"D24+D27","v":0.904746669478805},"m",null,"Pérdidas de energía",{"$f":"H24+H27","v":1.3769473935233529},"m"]

{"sheet":"Pozo humedo","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,16],[4,2,4,4]]}
[]
[null,"DIMENSIONAMIENTO POZO HÚMEDO DEL BOMBEO DE AGUA RESIDUAL"]
[]
[]
[null,null,"DATOS DE ENTRADA DEL POZO HÚMEDO"]
[null,null,"Tiempo del ciclo",{"$f":"'Datos de entrada'!F14","v":15},"min"]
[null,null,"(CT) Cota terreno",{"$f":"'Datos de entrada'!F9","v":45},"msnm",null,null,null,null,null,"CT:",{"$f":"D7","v":45}]
[null,null,"(CAF) Cota Batea entrada afluente",{"$f":"'Datos de entrada'!F10","v":43.63},"msnm"]
[null,null,"Sumergencia mínima de la bomba",{"$f":"IFERROR(IF(VLOOKUP(\"X\",'Bombas coincidentes'!$B$17:$M$35,10,FALSE)/1000>0.5,VLOOKUP(\"X\",'Bombas coincidentes'!$B$17:$M$35,10,FALSE)/1000,0.5),0.5)","v":0.5},"m"]
[]
[null,null,"POZO HÚMEDO",null,null,null,null,"CAF:",{"$f":"D8","v":43.63}]
[null,null,"Volumen Requerido",{"$f":"Vol(Q,D6)","v":1.25},"m3",null,null,null,null,null,"NMax",{"$f":"D15","v":43.4}]
[null,null,"Diámetro",{"$f":"Dpozo(D12)","v":1.2},"m",null,null,null,null,null,"NA",{"$f":"D16","v":43.35}]
[null,null,"h3 (altura útil)",{"$f":"ROUNDUP(hpozo(D12,D13),1)","v":1.2000000000000002},"m"]
[null,null,"(NMax) Nivel de Alarma Aguas Máximas",{"$f":"ROUND(D8-0.2,1)","v":43.4},"msnm"]
[null,null,"(NA) Nivel de Arranque",{"$f":"D15-0.05","v":43.35},"msnm",null,null,null,null,null,"NP",{"$f":"D17","v":42.15}]
[null,null,"(NP) Nivel de Parada",{"$f":"D16-D14","v":42.15},"msnm",null,null,null,null,null,"NMin",{"$f":"D18","v":42.1}]
[null,null,"(NMin) Nivel de Alarma Aguas Mínimas",{"$f":"D17-0.05","v":42.1},"msnm"]
[null,null,"(CF) Cota fondo pozo",{"$f":"D18-D9","v":41.6},"msnm",null,null,null,null,null,"CF",{"$f":"D19","v":41.6}]
[null,null,"Altura total del pozo húmedo",{"$f":"D7-D19","v":3.3999999999999986},"m"]

{"sheet":"Optimización","index":4,"n_rows":82,"n_cols":34,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,13,1,14],[1,17,1,18],[1,1,1,5],[11,2,11,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[8,9,11,9],[3,1,3,2],[13,17,13,24],[5,21,5,22],[2,21,2,22],[3,21,3,22],[4,21,4,22],[13,8,13,15],[14,1,15,1],[15,8,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[15,23,16,23],[15,24,16,24],[15,17,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,22,16,22],[68,27,68,33],[9,27,9,33],[67,27,67,32],[81,27,81,32],[1,26,1,34],[2,27,3,33],[10,32,11,32],[10,33,11,33],[10,27,11,27],[12,27,12,33],[4,27,4,32],[5,27,6,27],[10,28,11,28],[10,29,11,29],[10,30,11,30],[10,31,11,31]]}
[]
[null,"OPTIMIZACIÓN",null,null,null,null,null,null,"mm","in",1,2,null,"No. De opciones",null,{"$f":"COUNT(C17:C56)","v":19},null,"COSTOS",null,null,null,null,null,null,null,null,"PRESUPUESTO PRELIMINAR"]
[null,null,null,null,null,null,null,null,32,1.25,{"$f":"IF(AND(I3>'Linea de impulsión'!$D$17,I3<'Linea de impulsión'!$D$16),\"1\",\"\")","v":""},{"$f":"IF(AND(I3>'Linea de impulsión'!$H$17,I3<'Linea de impulsión'!$H$16),\"1\",\"\")","v":""},null,"Impulsión 1","HD",2.5,null,"BOMBA",{"$f":"VLOOKUP(N6,$B$17:$G$56,6,FALSE)","v":3700000},null,null,"Potencia útil",null,{"$f":"'Bombas coincidentes'!J11","v":0.38820188016275087},"kW",null,null,"Nota: El presente presupuesto es una base para determinar el costo del proyecto óptimo por lo cual no tiene en cuenta los costos de excavación, demoliciones o reparaciones y por lo tanto no se debe tomar como presupuesto final del proyecto. "]
[null,null,null,null,null,null,null,null,40,1.5,{"$f":"IF(AND(I4>'Linea de impulsión'!$D$17,I4<'Linea de impulsión'!$D$16),\"1\",\"\")","v":""},{"$f":"IF(AND(I4>'Linea de impulsión'!$H$17,I4<'Linea de impulsión'!$H$16),\"1\",\"\")","v":""},null,"Impulsión 2","GRP",3,null,"ENERGÍA",{"$f":"VLOOKUP(N6,$B$17:$G$56,5,FALSE)","v":21664964.107299998},null,null,"Tiempo del ciclo requerido",null,{"$f":"'Datos de entrada'!F14","v":15},"min"]
[null,null,null,null,null,null,null,null,50,2,{"$f":"IF(AND(I5>'Linea de impulsión'!$D$17,I5<'Linea de impulsión'!$D$16),\"1\",\"\")","v":""},{"$f":"IF(AND(I5>'Linea de impulsión'!$H$17,I5<'Linea de impulsión'!$H$16),\"1\",\"\")","v":""},null,"BOMBA",null,null,null,"TUBERÍA 1",{"$f":"P30","v":95144.39999999998},null,null,"Horas de bombeo en 1 año",null,{"$f":"(((60/X4)*(X4/2))/60)*24*365","v":4380},"hr/año",null,null,"COSTOS DE LA BOMBA ÓPTIMA"]
[null,null,null,null,null,null,null,null,65,2.5,{"$f":"IF(AND(I6>'Linea de impulsión'!$D$17,I6<'Linea de impulsión'!$D$16),\"1\",\"\")","v":"1"},{"$f":"IF(AND(I6>'Linea de impulsión'!$H$17,I6<'Linea de impulsión'!$H$16),\"1\",\"\")","v":"1"},null,"DRV/A50-155-1.8M",null,null,null,"TUBERÍA 2",{"$f":"Y30","v":224640},null,null,"Horas de bombeo en el periodo",null,{"$f":"X5*'Datos de entrada'!F16","v":87600},"hr/periodo",null,null,"MODELO","EFICIENCIA","POTENCIA","COSTO ENERGÍA","COSTO ENERGÍA (VPN)","COSTO DE ADQUISICIÓN"]
[null,null,"Bomba Óptima",null,"DRV/A50-155-1.8M",null,null,null,80,3,{"$f":"IF(AND(I7>'Linea de impulsión'!$D$17,I7<'Linea de impulsión'!$D$16),\"1\",\"\")","v":""},{"$f":"IF(AND(I7>'Linea de impulsión'!$H$17,I7<'Linea de impulsión'!$H$16),\"1\",\"\")","v":"1"},null,null,null,null,null,"TOTAL",{"$f":"SUM(S3:S6)","v":25684748.507299997},null,null,null,null,null,null,null,null,null," [%]","kW","$/año","$/periodo","$"]
[null,null,"Material impulsión 1",null,"HD",null,null,null,100,4,{"$f":"IF(AND(I8>'Linea de impulsión'!$D$17,I8<'Linea de impulsión'!$D$16),\"1\",\"\")","v":""},{"$f":"IF(AND(I8>'Linea de impulsión'!$H$17,I8<'Linea de impulsión'!$H$16),\"1\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E7","v":"DRV/A50-155-1.8M"},{"$f":"VLOOKUP(AB8,$B$17:$G$56,2,FALSE)","v":74.552999999999997},{"$f":"VLOOKUP(AB8,$B$17:$G$56,3,FALSE)","v":0.52070591413189393},{"$f":"VLOOKUP(AB8,$B$17:$G$56,4,FALSE)","v":1824553.5231181562},{"$f":"VLOOKUP(AB8,$B$17:$G$56,5,FALSE)","v":21664964.107299998},{"$f":"VLOOKUP(AB8,$B$17:$G$56,6,FALSE)","v":3700000}]
[null,null,"Material impulsión 2",null,"GRP",null,null,null,null,"MATERIALES POR TUBERÍA DE IMPULSIÓN","ACERO","PVC"]
[null,null,"Diámetro impulsión 1",null,2.5,null,null,null,null,null,"HD","GRP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COSTOS DE LAS TUBERÍAS ÓPTIMAS"]
[null,null,"Diámetro impulsión 2",null,3,null,null,null,null,null,null,"CCP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESCRIPCIÓN","UNIDAD","CANTIDAD","VALOR UNITARIO\nSUMINISTROS","VALOR UNITARIO\nINSTALACIÓN","VALOR UNITARIO \nTOTAL","VALOR TOTAL"]
[null,null,"Costo Total del proyecto",null,25684748.507300001,null,null,null,null,null,null,"PEAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMPULSIÓN 1"]
[null,null,null,null,null,null,null,null,"IMPULSIÓN 1",null,null,null,null,null,null,null,null,"IMPULSIÓN 2",null,null,null,null,null,null,null,null,null,{"$f":"J18","v":"Tubería 2.5\""},{"$f":"K18","v":"ml"},{"$f":"L18","v":3.3999999999999986},6003,6003,12006,40820.39999999998]
[null,"Modelo","Eficiencia","Potencia","Costo energía","Costo energía (VPN)","Costo de adquisición",null,"MATERIAL",{"$f":"'Linea de impulsión'!D9","v":"HD"},{"$f":"HLOOKUP(J15,APU!$A$2:$G$3,2,FALSE)","v":7},null,"DIÁMETRO",{"$f":"'Linea de impulsión'!D18","v":2.5},null,null,null,"MATERIAL",{"$f":"'Linea de impulsión'!H9","v":"GRP"},{"$f":"HLOOKUP(S15,APU!$A$2:$G$3,2,FALSE)","v":3},null,"DIÁMETRO",{"$f":"'Linea de impulsión'!H18","v":3}]
[null,null," [%]","kW","$/año","$/periodo","$",null,"ÍTEM",null,"UNIDAD","CANTIDAD","VALOR UNITARIO\nSUMINISTROS","VALOR UNITARIO\nINSTALACIÓN","VALOR UNITARIO \nTOTAL","VALOR TOTAL",null,"ÍTEM",null,"UNIDAD","CANTIDAD","VALOR UNITARIO\nSUMINISTROS","VALOR UNITARIO\nINSTALACIÓN","VALOR UNITARIO \nTOTAL","VALOR TOTAL"]
[null,{"$f":"IF('Bombas coincidentes'!C17=\"\",\"\",'Bombas coincidentes'!C17)","v":"DRV/A50-155-1.8M"},{"$f":"IF(B17=\"\",\"\",'Bombas coincidentes'!M17)","v":74.552999999999997},{"$f":"IF(C17=\"\",\"\",$X$3/(C17/100))","v":0.52070591413189393},{"$f":"IF(D17=\"\",\"\",D17*'Datos de entrada'!$F$15*$X$5)","v":1824553.5231181562},{"$f":"IF(E17=\"\",\"\",VPN(E17,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":21664964.107299998},{"$f":"IF(F17=\"\",\"\",VLOOKUP(B17,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":3700000}]
[null,{"$f":"IF('Bombas coincidentes'!C18=\"\",\"\",'Bombas coincidentes'!C18)","v":"DRV/A50-140-1.8M"},{"$f":"IF(B18=\"\",\"\",'Bombas coincidentes'!M18)","v":69.257999999999996},{"$f":"IF(C18=\"\",\"\",$X$3/(C18/100))","v":0.56051557966263954},{"$f":"IF(D18=\"\",\"\",D18*'Datos de entrada'!$F$15*$X$5)","v":1964046.5911378891},{"$f":"IF(E18=\"\",\"\",VPN(E18,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":23321321.278099999},{"$f":"IF(F18=\"\",\"\",VLOOKUP(B18,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":3600000},null,"Tubería",{"$f":"CONCATENATE(I18,\" \",$N$15,\"\"\"\")","v":"Tubería 2.5\""},"ml",{"$f":"'Linea de impulsión'!D10","v":3.3999999999999986},{"$f":"VLOOKUP(J18,APU!$A$4:$G$51,$K$15,FALSE)","v":6003},{"$f":"VLOOKUP(J18,APU!$I$4:$O$51,$K$15,FALSE)","v":6003},{"$f":"M18+N18","v":12006},{"$f":"O18*L18","v":40820.39999999998},null,"Tubería",{"$f":"CONCATENATE(R18,\" \",$W$15,\"\"\"\")","v":"Tubería 3\""},"ml",{"$f":"'Linea de impulsión'!H10","v":50},{"$f":"VLOOKUP(S18,APU!$A$4:$G$51,$T$15,FALSE)","v":2004},{"$f":"VLOOKUP(S18,APU!$I$4:$O$51,$T$15,FALSE)","v":2004},{"$f":"V18+W18","v":4008},{"$f":"X18*U18","v":200400}]
[null,{"$f":"IF('Bombas coincidentes'!C19=\"\",\"\",'Bombas coincidentes'!C19)","v":"DRV/A50-140-1.4"},{"$f":"IF(B19=\"\",\"\",'Bombas coincidentes'!M19)","v":69.257999999999996},0.56051557966263954,{"$f":"IF(D19=\"\",\"\",D19*'Datos de entrada'!$F$15*$X$5)","v":1964046.5911378891},{"$f":"IF(E19=\"\",\"\",VPN(E19,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":23321321.278099999},{"$f":"IF(F19=\"\",\"\",VLOOKUP(B19,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":3800000},null,"Codo 90 radio corto",{"$f":"CONCATENATE(I19,\" \",$N$15,\"\"\"\")","v":"Codo 90 radio corto 2.5\""},"un",{"$f":"'Datos de entrada'!F27","v":0},{"$f":"VLOOKUP(J19,APU!$A$4:$G$51,$K$15,FALSE)","v":6009},{"$f":"VLOOKUP(J19,APU!$I$4:$O$51,$K$15,FALSE)","v":6009},12018,0,null,"Codo 90 radio corto",{"$f":"CONCATENATE(R19,\" \",$W$15,\"\"\"\")","v":"Codo 90 radio corto 3\""},"un",{"$f":"'Datos de entrada'!G27","v":3},{"$f":"VLOOKUP(S19,APU!$A$4:$G$51,$T$15,FALSE)","v":2010},{"$f":"VLOOKUP(S19,APU!$I$4:$O$51,$T$15,FALSE)","v":2010},4020,12060]
[null,{"$f":"IF('Bombas coincidentes'!C20=\"\",\"\",'Bombas coincidentes'!C20)","v":"DRV/A65-119-2.3"},{"$f":"IF(B20=\"\",\"\",'Bombas coincidentes'!M20)","v":66.082999999999998},0.58744590917898831,{"$f":"IF(D20=\"\",\"\",D20*'Datos de entrada'!$F$15*$X$5)","v":2058410.4657631752},{"$f":"IF(E20=\"\",\"\",VPN(E20,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":24441809.075599998},{"$f":"IF(F20=\"\",\"\",VLOOKUP(B20,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4200000},null,"Codo 90 radio medio","Codo 90 radio medio 2.5\"","un",{"$f":"'Datos de entrada'!F28","v":0},{"$f":"VLOOKUP(J20,APU!$A$4:$G$51,$K$15,FALSE)","v":6015},{"$f":"VLOOKUP(J20,APU!$I$4:$O$51,$K$15,FALSE)","v":6015},12030,0,null,"Codo 90 radio medio","Codo 90 radio medio 3\"","un",{"$f":"'Datos de entrada'!G28","v":0},{"$f":"VLOOKUP(S20,APU!$A$4:$G$51,$T$15,FALSE)","v":2016},{"$f":"VLOOKUP(S20,APU!$I$4:$O$51,$T$15,FALSE)","v":2016},4032,0]
[null,{"$f":"IF('Bombas coincidentes'!C21=\"\",\"\",'Bombas coincidentes'!C21)","v":"FEKA 2500.4T"},{"$f":"IF(B21=\"\",\"\",'Bombas coincidentes'!M21)","v":65.769000000000005},0.5902505438166169,{"$f":"IF(D21=\"\",\"\",D21*'Datos de entrada'!$F$15*$X$5)","v":2068237.9055334255},{"$f":"IF(E21=\"\",\"\",VPN(E21,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":24558501.2557},{"$f":"IF(F21=\"\",\"\",VLOOKUP(B21,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4300000},null,"Codo 90 gran radio","Codo 90 gran radio 2.5\"","un",{"$f":"'Datos de entrada'!F29","v":1},{"$f":"VLOOKUP(J21,APU!$A$4:$G$51,$K$15,FALSE)","v":6021},{"$f":"VLOOKUP(J21,APU!$I$4:$O$51,$K$15,FALSE)","v":6021},12042,12042,null,"Codo 90 gran radio","Codo 90 gran radio 3\"","un",{"$f":"'Datos de entrada'!G29","v":0},{"$f":"VLOOKUP(S21,APU!$A$4:$G$51,$T$15,FALSE)","v":2022},{"$f":"VLOOKUP(S21,APU!$I$4:$O$51,$T$15,FALSE)","v":2022},4044,0]
[null,{"$f":"IF('Bombas coincidentes'!C22=\"\",\"\",'Bombas coincidentes'!C22)","v":"ARS 50-14MI/1,4"},{"$f":"IF(B22=\"\",\"\",'Bombas coincidentes'!M22)","v":65.504000000000005},0.59263843454254828,{"$f":"IF(D22=\"\",\"\",D22*'Datos de entrada'!$F$15*$X$5)","v":2076605.0746370892},{"$f":"IF(E22=\"\",\"\",VPN(E22,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":24657854.010200001},{"$f":"IF(F22=\"\",\"\",VLOOKUP(B22,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4800000},null,"Codo 45","Codo 45 2.5\"","un",{"$f":"'Datos de entrada'!F30","v":0},{"$f":"VLOOKUP(J22,APU!$A$4:$G$51,$K$15,FALSE)","v":6027},{"$f":"VLOOKUP(J22,APU!$I$4:$O$51,$K$15,FALSE)","v":6027},12054,0,null,"Codo 45","Codo 45 3\"","un",{"$f":"'Datos de entrada'!G30","v":2},{"$f":"VLOOKUP(S22,APU!$A$4:$G$51,$T$15,FALSE)","v":2028},{"$f":"VLOOKUP(S22,APU!$I$4:$O$51,$T$15,FALSE)","v":2028},4056,8112]
[null,{"$f":"IF('Bombas coincidentes'!C23=\"\",\"\",'Bombas coincidentes'!C23)","v":"AS0630 S13/4D"},{"$f":"IF(B23=\"\",\"\",'Bombas coincidentes'!M23)","v":64.158999999999992},0.60506223626108724,{"$f":"IF(D23=\"\",\"\",D23*'Datos de entrada'!$F$15*$X$5)","v":2120138.0758588496},{"$f":"IF(E23=\"\",\"\",VPN(E23,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":25174770.011100002},{"$f":"IF(F23=\"\",\"\",VLOOKUP(B23,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":3600000},null,"Tee","Tee 2.5\"","un",{"$f":"'Datos de entrada'!F31+'Datos de entrada'!F32","v":2},{"$f":"VLOOKUP(J23,APU!$A$4:$G$51,$K$15,FALSE)","v":6033},{"$f":"VLOOKUP(J23,APU!$I$4:$O$51,$K$15,FALSE)","v":6033},12066,24132,null,"Tee","Tee 3\"","un",{"$f":"'Datos de entrada'!G31+'Datos de entrada'!G32","v":1},{"$f":"VLOOKUP(S23,APU!$A$4:$G$51,$T$15,FALSE)","v":2034},{"$f":"VLOOKUP(S23,APU!$I$4:$O$51,$T$15,FALSE)","v":2034},4068,4068]
[null,{"$f":"IF('Bombas coincidentes'!C24=\"\",\"\",'Bombas coincidentes'!C24)","v":"FEKA 3030.2T"},{"$f":"IF(B24=\"\",\"\",'Bombas coincidentes'!M24)","v":64.106999999999999},0.60555302878429951,{"$f":"IF(D24=\"\",\"\",D24*'Datos de entrada'!$F$15*$X$5)","v":2121857.8128601853},{"$f":"IF(E24=\"\",\"\",VPN(E24,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":25195190.371399999},{"$f":"IF(F24=\"\",\"\",VLOOKUP(B24,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4800000},null,"Uniones","Uniones 2.5\"","un",{"$f":"'Datos de entrada'!F33","v":1},{"$f":"VLOOKUP(J24,APU!$A$4:$G$51,$K$15,FALSE)","v":6039},{"$f":"VLOOKUP(J24,APU!$I$4:$O$51,$K$15,FALSE)","v":6039},12078,12078,null,"Uniones","Uniones 3\"","un",{"$f":"'Datos de entrada'!G33","v":0},{"$f":"VLOOKUP(S24,APU!$A$4:$G$51,$T$15,FALSE)","v":2040},{"$f":"VLOOKUP(S24,APU!$I$4:$O$51,$T$15,FALSE)","v":2040},4080,0]
[null,{"$f":"IF('Bombas coincidentes'!C25=\"\",\"\",'Bombas coincidentes'!C25)","v":"FEKA 1400 M"},{"$f":"IF(B25=\"\",\"\",'Bombas coincidentes'!M25)","v":62.569000000000003},0.62043804465909769,{"$f":"IF(D25=\"\",\"\",D25*'Datos de entrada'!$F$15*$X$5)","v":2174014.9084854783},{"$f":"IF(E25=\"\",\"\",VPN(E25,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":25814509.886999998},{"$f":"IF(F25=\"\",\"\",VLOOKUP(B25,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":3400000},null,"Yee","Yee 2.5\"","un",{"$f":"'Datos de entrada'!F34+'Datos de entrada'!F35","v":0},{"$f":"VLOOKUP(J25,APU!$A$4:$G$51,$K$15,FALSE)","v":6045},{"$f":"VLOOKUP(J25,APU!$I$4:$O$51,$K$15,FALSE)","v":6045},12090,0,null,"Yee","Yee 3\"","un",{"$f":"'Datos de entrada'!G34+'Datos de entrada'!G35","v":0},{"$f":"VLOOKUP(S25,APU!$A$4:$G$51,$T$15,FALSE)","v":2046},{"$f":"VLOOKUP(S25,APU!$I$4:$O$51,$T$15,FALSE)","v":2046},4092,0]
[null,{"$f":"IF('Bombas coincidentes'!C26=\"\",\"\",'Bombas coincidentes'!C26)","v":"AS0840 S12/2W"},{"$f":"IF(B26=\"\",\"\",'Bombas coincidentes'!M26)","v":62.511000000000003},0.62101370984746818,{"$f":"IF(D26=\"\",\"\",D26*'Datos de entrada'!$F$15*$X$5)","v":2176032.0393055286},{"$f":"IF(E26=\"\",\"\",VPN(E26,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":25838461.536499999},{"$f":"IF(F26=\"\",\"\",VLOOKUP(B26,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":5200000},null,"Válvula de globo","Válvula de globo 2.5\"","un",{"$f":"'Datos de entrada'!F23","v":0},{"$f":"VLOOKUP(J26,APU!$Q$3:$S$26,2,FALSE)","v":1003},{"$f":"VLOOKUP(J26,APU!$Q$3:$S$26,3,FALSE)","v":2003},3006,0,null,"Válvula de globo","Válvula de globo 3\"","un",{"$f":"'Datos de entrada'!G23","v":0},{"$f":"VLOOKUP(S26,APU!$Q$3:$S$26,2,FALSE)","v":1004},{"$f":"VLOOKUP(S26,APU!$Q$3:$S$26,3,FALSE)","v":2004},3008,0]
[null,{"$f":"IF('Bombas coincidentes'!C27=\"\",\"\",'Bombas coincidentes'!C27)","v":"ARS 80-18V/1,7"},{"$f":"IF(B27=\"\",\"\",'Bombas coincidentes'!M27)","v":61.814999999999998},0.62800595351088062,{"$f":"IF(D27=\"\",\"\",D27*'Datos de entrada'!$F$15*$X$5)","v":2200532.8611021256},{"$f":"IF(E27=\"\",\"\",VPN(E27,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":26129387.189300001},{"$f":"IF(F27=\"\",\"\",VLOOKUP(B27,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4300000},null,"Válvula de mariposa","Válvula de mariposa 2.5\"","un",{"$f":"'Datos de entrada'!F24","v":0},{"$f":"VLOOKUP(J27,APU!$Q$3:$S$26,2,FALSE)","v":1009},{"$f":"VLOOKUP(J27,APU!$Q$3:$S$26,3,FALSE)","v":2009},3018,0,null,"Válvula de mariposa","Válvula de mariposa 3\"","un",{"$f":"'Datos de entrada'!G24","v":0},{"$f":"VLOOKUP(S27,APU!$Q$3:$S$26,2,FALSE)","v":1010},{"$f":"VLOOKUP(S27,APU!$Q$3:$S$26,3,FALSE)","v":2010},3020,0]
[null,{"$f":"IF('Bombas coincidentes'!C28=\"\",\"\",'Bombas coincidentes'!C28)","v":"ARS 50-16V/1,8"},{"$f":"IF(B28=\"\",\"\",'Bombas coincidentes'!M28)","v":54.322000000000003},0.71463105217545531,{"$f":"IF(D28=\"\",\"\",D28*'Datos de entrada'!$F$15*$X$5)","v":2504067.2068227953},{"$f":"IF(E28=\"\",\"\",VPN(E28,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":29733589.873300001},{"$f":"IF(F28=\"\",\"\",VLOOKUP(B28,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":3100000},null,"Válvula de Cheque","Válvula de Cheque 2.5\"","un",{"$f":"'Datos de entrada'!F25","v":1},{"$f":"VLOOKUP(J28,APU!$Q$3:$S$26,2,FALSE)","v":1015},{"$f":"VLOOKUP(J28,APU!$Q$3:$S$26,3,FALSE)","v":2015},3030,3030,null,"Válvula de Cheque","Válvula de Cheque 3\"","un",{"$f":"'Datos de entrada'!G25","v":0},{"$f":"VLOOKUP(S28,APU!$Q$3:$S$26,2,FALSE)","v":1016},{"$f":"VLOOKUP(S28,APU!$Q$3:$S$26,3,FALSE)","v":2016},3032,0]
[null,{"$f":"IF('Bombas coincidentes'!C29=\"\",\"\",'Bombas coincidentes'!C29)","v":"AS0840 S12/2D"},{"$f":"IF(B29=\"\",\"\",'Bombas coincidentes'!M29)","v":52.511000000000003},0.73927725650387688,{"$f":"IF(D29=\"\",\"\",D29*'Datos de entrada'!$F$15*$X$5)","v":2590427.5067895846},{"$f":"IF(E29=\"\",\"\",VPN(E29,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":30759042.279100001},{"$f":"IF(F29=\"\",\"\",VLOOKUP(B29,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":5400000},null,"Válvula de compuerta","Válvula de compuerta 2.5\"","un",{"$f":"'Datos de entrada'!F26","v":1},{"$f":"VLOOKUP(J29,APU!$Q$3:$S$26,2,FALSE)","v":1021},{"$f":"VLOOKUP(J29,APU!$Q$3:$S$26,3,FALSE)","v":2021},3042,3042,null,"Válvula de compuerta","Válvula de compuerta 3\"","un",{"$f":"'Datos de entrada'!G26","v":0},{"$f":"VLOOKUP(S29,APU!$Q$3:$S$26,2,FALSE)","v":1022},{"$f":"VLOOKUP(S29,APU!$Q$3:$S$26,3,FALSE)","v":2022},3044,0]
[null,{"$f":"IF('Bombas coincidentes'!C30=\"\",\"\",'Bombas coincidentes'!C30)","v":"ARS 65-18V/1,7"},{"$f":"IF(B30=\"\",\"\",'Bombas coincidentes'!M30)","v":52.108999999999995},0.74498048353019808,{"$f":"IF(D30=\"\",\"\",D30*'Datos de entrada'!$F$15*$X$5)","v":2610411.6142898141},{"$f":"IF(E30=\"\",\"\",VPN(E30,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":30996335.932700001},{"$f":"IF(F30=\"\",\"\",VLOOKUP(B30,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4100000},null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(P18:P29)","v":95144.39999999998},null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(Y18:Y29)","v":224640}]
[null,{"$f":"IF('Bombas coincidentes'!C31=\"\",\"\",'Bombas coincidentes'!C31)","v":"DRV/A65-182-1.4"},{"$f":"IF(B31=\"\",\"\",'Bombas coincidentes'!M31)","v":51.445999999999998},0.75458126999718311,{"$f":"IF(D31=\"\",\"\",D31*'Datos de entrada'!$F$15*$X$5)","v":2644052.77007013},{"$f":"IF(E31=\"\",\"\",VPN(E31,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":31395794.9914},{"$f":"IF(F31=\"\",\"\",VLOOKUP(B31,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":5600000}]
[null,{"$f":"IF('Bombas coincidentes'!C32=\"\",\"\",'Bombas coincidentes'!C32)","v":"DRV/A80-182-1.4"},{"$f":"IF(B32=\"\",\"\",'Bombas coincidentes'!M32)","v":51.011799999999987},0.76100408172766099,{"$f":"IF(D32=\"\",\"\",D32*'Datos de entrada'!$F$15*$X$5)","v":2666558.3023737241},{"$f":"IF(E32=\"\",\"\",VPN(E32,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":31663028.340999998},{"$f":"IF(F32=\"\",\"\",VLOOKUP(B32,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":6000000}]
[null,{"$f":"IF('Bombas coincidentes'!C33=\"\",\"\",'Bombas coincidentes'!C33)","v":"DRV/A65-182-1.2M"},{"$f":"IF(B33=\"\",\"\",'Bombas coincidentes'!M33)","v":50.667599999999993},0.766173807645815,{"$f":"IF(D33=\"\",\"\",D33*'Datos de entrada'!$F$15*$X$5)","v":2684673.0219909358},{"$f":"IF(E33=\"\",\"\",VPN(E33,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":31878124.661800001},{"$f":"IF(F33=\"\",\"\",VLOOKUP(B33,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":5300000}]
[null,{"$f":"IF('Bombas coincidentes'!C34=\"\",\"\",'Bombas coincidentes'!C34)","v":"DRV/A80-182-1.2M"},{"$f":"IF(B34=\"\",\"\",'Bombas coincidentes'!M34)","v":50.499699999999997},0.76872116104204768,{"$f":"IF(D34=\"\",\"\",D34*'Datos de entrada'!$F$15*$X$5)","v":2693598.9482913348},{"$f":"IF(E34=\"\",\"\",VPN(E34,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":31984112.1653},{"$f":"IF(F34=\"\",\"\",VLOOKUP(B34,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":5900000}]
[null,{"$f":"IF('Bombas coincidentes'!C35=\"\",\"\",'Bombas coincidentes'!C35)","v":"AS0830 S13/4D"},{"$f":"IF(B35=\"\",\"\",'Bombas coincidentes'!M35)","v":48.78},0.79582181255176476,{"$f":"IF(D35=\"\",\"\",D35*'Datos de entrada'!$F$15*$X$5)","v":2788559.631181384},{"$f":"IF(E35=\"\",\"\",VPN(E35,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":33111686.5339},{"$f":"IF(F35=\"\",\"\",VLOOKUP(B35,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":4800000}]
[null,{"$f":"IF('Bombas coincidentes'!C36=\"\",\"\",'Bombas coincidentes'!C36)","v":""},{"$f":"IF(B36=\"\",\"\",'Bombas coincidentes'!M36)","v":""},"",{"$f":"IF(D36=\"\",\"\",D36*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E36=\"\",\"\",VPN(E36,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F36=\"\",\"\",VLOOKUP(B36,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C37=\"\",\"\",'Bombas coincidentes'!C37)","v":""},{"$f":"IF(B37=\"\",\"\",'Bombas coincidentes'!M37)","v":""},"",{"$f":"IF(D37=\"\",\"\",D37*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E37=\"\",\"\",VPN(E37,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F37=\"\",\"\",VLOOKUP(B37,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C38=\"\",\"\",'Bombas coincidentes'!C38)","v":""},{"$f":"IF(B38=\"\",\"\",'Bombas coincidentes'!M38)","v":""},"",{"$f":"IF(D38=\"\",\"\",D38*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E38=\"\",\"\",VPN(E38,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F38=\"\",\"\",VLOOKUP(B38,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C39=\"\",\"\",'Bombas coincidentes'!C39)","v":""},{"$f":"IF(B39=\"\",\"\",'Bombas coincidentes'!M39)","v":""},"",{"$f":"IF(D39=\"\",\"\",D39*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E39=\"\",\"\",VPN(E39,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F39=\"\",\"\",VLOOKUP(B39,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C40=\"\",\"\",'Bombas coincidentes'!C40)","v":""},{"$f":"IF(B40=\"\",\"\",'Bombas coincidentes'!M40)","v":""},"",{"$f":"IF(D40=\"\",\"\",D40*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E40=\"\",\"\",VPN(E40,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F40=\"\",\"\",VLOOKUP(B40,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C41=\"\",\"\",'Bombas coincidentes'!C41)","v":""},{"$f":"IF(B41=\"\",\"\",'Bombas coincidentes'!M41)","v":""},"",{"$f":"IF(D41=\"\",\"\",D41*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E41=\"\",\"\",VPN(E41,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F41=\"\",\"\",VLOOKUP(B41,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C42=\"\",\"\",'Bombas coincidentes'!C42)","v":""},{"$f":"IF(B42=\"\",\"\",'Bombas coincidentes'!M42)","v":""},"",{"$f":"IF(D42=\"\",\"\",D42*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E42=\"\",\"\",VPN(E42,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F42=\"\",\"\",VLOOKUP(B42,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C43=\"\",\"\",'Bombas coincidentes'!C43)","v":""},{"$f":"IF(B43=\"\",\"\",'Bombas coincidentes'!M43)","v":""},"",{"$f":"IF(D43=\"\",\"\",D43*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E43=\"\",\"\",VPN(E43,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F43=\"\",\"\",VLOOKUP(B43,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C44=\"\",\"\",'Bombas coincidentes'!C44)","v":""},{"$f":"IF(B44=\"\",\"\",'Bombas coincidentes'!M44)","v":""},"",{"$f":"IF(D44=\"\",\"\",D44*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E44=\"\",\"\",VPN(E44,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F44=\"\",\"\",VLOOKUP(B44,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C45=\"\",\"\",'Bombas coincidentes'!C45)","v":""},{"$f":"IF(B45=\"\",\"\",'Bombas coincidentes'!M45)","v":""},"",{"$f":"IF(D45=\"\",\"\",D45*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E45=\"\",\"\",VPN(E45,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F45=\"\",\"\",VLOOKUP(B45,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C46=\"\",\"\",'Bombas coincidentes'!C46)","v":""},{"$f":"IF(B46=\"\",\"\",'Bombas coincidentes'!M46)","v":""},"",{"$f":"IF(D46=\"\",\"\",D46*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E46=\"\",\"\",VPN(E46,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F46=\"\",\"\",VLOOKUP(B46,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C47=\"\",\"\",'Bombas coincidentes'!C47)","v":""},{"$f":"IF(B47=\"\",\"\",'Bombas coincidentes'!M47)","v":""},"",{"$f":"IF(D47=\"\",\"\",D47*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E47=\"\",\"\",VPN(E47,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F47=\"\",\"\",VLOOKUP(B47,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C48=\"\",\"\",'Bombas coincidentes'!C48)","v":""},{"$f":"IF(B48=\"\",\"\",'Bombas coincidentes'!M48)","v":""},"",{"$f":"IF(D48=\"\",\"\",D48*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E48=\"\",\"\",VPN(E48,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F48=\"\",\"\",VLOOKUP(B48,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C49=\"\",\"\",'Bombas coincidentes'!C49)","v":""},{"$f":"IF(B49=\"\",\"\",'Bombas coincidentes'!M49)","v":""},"",{"$f":"IF(D49=\"\",\"\",D49*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E49=\"\",\"\",VPN(E49,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F49=\"\",\"\",VLOOKUP(B49,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C50=\"\",\"\",'Bombas coincidentes'!C50)","v":""},{"$f":"IF(B50=\"\",\"\",'Bombas coincidentes'!M50)","v":""},"",{"$f":"IF(D50=\"\",\"\",D50*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E50=\"\",\"\",VPN(E50,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F50=\"\",\"\",VLOOKUP(B50,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C51=\"\",\"\",'Bombas coincidentes'!C51)","v":""},{"$f":"IF(B51=\"\",\"\",'Bombas coincidentes'!M51)","v":""},"",{"$f":"IF(D51=\"\",\"\",D51*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E51=\"\",\"\",VPN(E51,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F51=\"\",\"\",VLOOKUP(B51,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C52=\"\",\"\",'Bombas coincidentes'!C52)","v":""},{"$f":"IF(B52=\"\",\"\",'Bombas coincidentes'!M52)","v":""},"",{"$f":"IF(D52=\"\",\"\",D52*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E52=\"\",\"\",VPN(E52,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F52=\"\",\"\",VLOOKUP(B52,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C53=\"\",\"\",'Bombas coincidentes'!C53)","v":""},{"$f":"IF(B53=\"\",\"\",'Bombas coincidentes'!M53)","v":""},"",{"$f":"IF(D53=\"\",\"\",D53*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E53=\"\",\"\",VPN(E53,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F53=\"\",\"\",VLOOKUP(B53,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C54=\"\",\"\",'Bombas coincidentes'!C54)","v":""},{"$f":"IF(B54=\"\",\"\",'Bombas coincidentes'!M54)","v":""},"",{"$f":"IF(D54=\"\",\"\",D54*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E54=\"\",\"\",VPN(E54,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F54=\"\",\"\",VLOOKUP(B54,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C55=\"\",\"\",'Bombas coincidentes'!C55)","v":""},{"$f":"IF(B55=\"\",\"\",'Bombas coincidentes'!M55)","v":""},"",{"$f":"IF(D55=\"\",\"\",D55*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E55=\"\",\"\",VPN(E55,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F55=\"\",\"\",VLOOKUP(B55,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,{"$f":"IF('Bombas coincidentes'!C56=\"\",\"\",'Bombas coincidentes'!C56)","v":""},{"$f":"IF(B56=\"\",\"\",'Bombas coincidentes'!M56)","v":""},"",{"$f":"IF(D56=\"\",\"\",D56*'Datos de entrada'!$F$15*$X$5)","v":""},{"$f":"IF(E56=\"\",\"\",VPN(E56,'Datos de entrada'!$F$17,'Datos de entrada'!$F$18,'Datos de entrada'!$F$16))","v":""},{"$f":"IF(F56=\"\",\"\",VLOOKUP(B56,'Base de datos'!$C$4:$AI$113,33,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J19","v":"Codo 90 radio corto 2.5\""},"un",0,6009,6009,12018,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J20","v":"Codo 90 radio medio 2.5\""},{"$f":"K20","v":"un"},{"$f":"L20","v":0},{"$f":"M20","v":6015},{"$f":"N20","v":6015},{"$f":"O20","v":12030},{"$f":"P20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codo 90 gran radio 2.5\"","un",1,6021,6021,12042,12042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codo 45 2.5\"","un",0,6027,6027,12054,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tee 2.5\"","un",2,6033,6033,12066,24132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uniones 2.5\"","un",1,6039,6039,12078,12078]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yee 2.5\"","un",0,6045,6045,12090,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de globo 2.5\"","un",0,1003,2003,3006,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de mariposa 2.5\"","un",0,1009,2009,3018,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de Cheque 2.5\"","un",1,1015,2015,3030,3030]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de compuerta 2.5\"","un",1,1021,2021,3042,3042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL IMPULSIÓN 1",null,null,null,null,null,{"$f":"SUM(AH14:AH67)","v":95144.39999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMPULSIÓN 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S18","v":"Tubería 3\""},"ml",50,2004,2004,4008,200400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codo 90 radio corto 3\"","un",3,2010,2010,4020,12060]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S20","v":"Codo 90 radio medio 3\""},{"$f":"T20","v":"un"},{"$f":"U20","v":0},{"$f":"V20","v":2016},{"$f":"W20","v":2016},{"$f":"X20","v":4032},{"$f":"Y20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codo 90 gran radio 3\"","un",0,2022,2022,4044,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codo 45 3\"","un",2,2028,2028,4056,8112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tee 3\"","un",1,2034,2034,4068,4068]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uniones 3\"","un",0,2040,2040,4080,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yee 3\"","un",0,2046,2046,4092,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de globo 3\"","un",0,1004,2004,3008,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de mariposa 3\"","un",0,1010,2010,3020,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de Cheque 3\"","un",0,1016,2016,3032,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Válvula de compuerta 3\"","un",0,1022,2022,3044,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL IMPULSIÓN 2",null,null,null,null,null,{"$f":"SUM(AH70:AH81)","v":224640}]

{"sheet":"K accesorios","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,0,1,0]]}
["Accesorios","K","Impulsion 1","Impulsion 2"]
[null,null,"K*Cant","K*Cant"]
["Válvula de globo",10,{"$f":"B3*'Datos de entrada'!F23","v":0},{"$f":"B3*'Datos de entrada'!G23","v":0}]
["Válvula de mariposa",5,{"$f":"B4*'Datos de entrada'!F24","v":0},{"$f":"B4*'Datos de entrada'!G24","v":0}]
["Válvula de Cheque",2.5,{"$f":"B5*'Datos de entrada'!F25","v":2.5},{"$f":"B5*'Datos de entrada'!G25","v":0}]
["Válvula de compuerta",0.2,{"$f":"B6*'Datos de entrada'!F26","v":0.2},{"$f":"B6*'Datos de entrada'!G26","v":0}]
["Codo 90 radio corto",0.9,{"$f":"B7*'Datos de entrada'!F27","v":0},{"$f":"B7*'Datos de entrada'!G27","v":2.7}]
["Codo 90 radio medio",0.8,{"$f":"B8*'Datos de entrada'!F28","v":0},{"$f":"B8*'Datos de entrada'!G28","v":0}]
["Codo 90 gran radio",0.6,{"$f":"B9*'Datos de entrada'!F29","v":0.6},{"$f":"B9*'Datos de entrada'!G29","v":0}]
["Codo 45",0.4,{"$f":"B10*'Datos de entrada'!F30","v":0},{"$f":"B10*'Datos de entrada'!G30","v":0.8}]
["Te, en sentido recto",0.3,{"$f":"B11*'Datos de entrada'!F31","v":0.6},{"$f":"B11*'Datos de entrada'!G31","v":0.3}]
["Te, a través de la salida lateral",1.8,{"$f":"B12*'Datos de entrada'!F32","v":0},{"$f":"B12*'Datos de entrada'!G32","v":0}]
["Uniones",0.3,{"$f":"B13*'Datos de entrada'!F33","v":0.3},{"$f":"B13*'Datos de entrada'!G33","v":0}]
["ye de 45°, en sentido recto",0.3,{"$f":"B14*'Datos de entrada'!F34","v":0},{"$f":"B14*'Datos de entrada'!G34","v":0}]
["ye de 45°, en sentido lateral",0.8,{"$f":"B15*'Datos de entrada'!F35","v":0},{"$f":"B15*'Datos de entrada'!G35","v":0}]
["Entrada recta a tope",0.5,{"$f":"B16*'Datos de entrada'!F36","v":0},{"$f":"B16*'Datos de entrada'!G36","v":0}]
["Entrada con boca acampanada",0.1,{"$f":"B17*'Datos de entrada'!F37","v":0},{"$f":"B17*'Datos de entrada'!G37","v":0}]
["Entrada con tubo entrante",0.9,{"$f":"B18*'Datos de entrada'!F38","v":0},{"$f":"B18*'Datos de entrada'!G38","v":0}]
["Salida tubería",1,{"$f":"B19*'Datos de entrada'!F39","v":0},{"$f":"B19*'Datos de entrada'!G39","v":1}]
["Bibliografia : Tabla B.6.11 RAS"]

{"sheet":"Datos curvas","index":6,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":true,"merged":[[12,20,12,22],[11,19,11,23],[0,0,0,11],[11,1,11,12],[11,13,11,14],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[3,2,3,4],[4,9,4,11],[5,9,5,11],[6,9,6,11],[13,1,14,1],[57,6,57,7],[22,24,22,25],[13,2,13,7],[13,8,13,13],[13,24,13,25],[14,24,14,25],[13,20,13,21],[13,15,13,16]]}
["CURVA DEL SISTEMA Y CURVA DE LA BOMBA"]
[]
[]
[null,null,"Datos",null,null,"Impulsión 1","Impulsión 2"]
[null,null,"Longitud tubería [m]",null,null,{"$f":"'Linea de impulsión'!D10","v":3.3999999999999986},{"$f":"'Linea de impulsión'!H10","v":50},null,null,"Nivel de Entrega",null,null,{"$f":"'Datos de entrada'!F11","v":47},"msnm"]
[null,null,"Diametro [pulg]",null,null,{"$f":"'Linea de impulsión'!D18","v":2.5},{"$f":"'Linea de impulsión'!H18","v":3},null,null,"(NA) Nivel de Arranque",null,null,{"$f":"'Pozo humedo'!D16","v":43.35},"msnm"]
[null,null,"Rugosidad absoluta \"ε\" [mm]",null,null,{"$f":"'Linea de impulsión'!D19","v":0.25},{"$f":"'Linea de impulsión'!H19","v":0.03},null,null,"(NP) Nivel de Parada",null,null,{"$f":"'Pozo humedo'!D17","v":42.15},"msnm"]
[null,null,"u [m2/s]",null,null,{"$f":"'Linea de impulsión'!D21","v":1.139E-6},{"$f":"'Linea de impulsión'!H21","v":1.139E-6}]
[null,null,"SK [m]",null,null,{"$f":"'Linea de impulsión'!D26","v":4.2},{"$f":"'Linea de impulsión'!H26","v":4.8}]
[]
[]
[null,"CURVA DEL SISTEMA EBAR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURVA DE LA BOMBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"X\",'Bombas coincidentes'!$B$17:$C$56,2,FALSE)","v":"DRV/A50-155-1.8M"}]
[null,"Q","IMPULSION 1",null,null,null,null,null,"IMPULSION 2",null,null,null,null,null,null,"Curva del sistema",null,null,null,null,"Q",null,"H"]
[null,null,"Vel","Pérdidas locales","Re"," \"f\"","Pérdidas por fricción","Pérdidas de energía","Vel","Pérdidas locales","Re"," \"f\"","Pérdidas por fricción","Pérdidas de energía",null,"HDT min","HDT max",null,null,null,"[m3/h]","[L/s]","[m]"]
[null,"L/s","m/s","m",null,null,"m","m","m/s","m",null,null,"m","m",null,"m","m",null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,2,FALSE)","v":2.4},{"$f":"U16/3.6","v":0.66666666666666663},{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,9,FALSE)","v":14}]
[null,{"$f":"(Q/3.6)/7*0","v":0},{"$f":"(B17/1000)/(PI()*($F$6*0.0254)^2/4)","v":0},{"$f":"$F$9*C17^2/(2*9.81)","v":0},{"$f":"C17*($F$6*0.0254)/$F$8","v":0},0,{"$f":"F17*$F$5/($F$6*0.0254)*C17^2/(2*9.81)","v":0},{"$f":"D17+G17","v":0},{"$f":"(B17/1000)/(PI()*($G$6*0.0254)^2/4)","v":0},{"$f":"$G$9*I17^2/(2*9.81)","v":0},{"$f":"I17*($G$6*0.0254)/$G$8","v":0},0,{"$f":"L17*$G$5/($G$6*0.0254)*I17^2/(2*9.81)","v":0},{"$f":"J17+M17","v":0},null,{"$f":"$M$5-$M$7+H17+N17","v":4.8500000000000014},{"$f":"$M$5-$M$6+H17+N17","v":3.6499999999999986},null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,3,FALSE)","v":6},{"$f":"U17/3.6","v":1.6666666666666665},{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,10,FALSE)","v":12.7}]
[null,{"$f":"(Q/3.6)/7*1","v":0.79365079365079361},0.25060637985904571,1.3444186647779639E-2,13971.470694512207,{"$f":"ffriccion($F$7/1000,E18,$F$6*0.0254)","v":3.4373935219247836E-2},5.8914159845566668E-3,1.9335602632336305E-2,0.17403220823544843,7.4097148631942465E-3,11642.892245426838,{"$f":"ffriccion($G$7/1000,K18,$G$6*0.0254)","v":3.0232627611714875E-2},3.0623243406597292E-2,3.8032958269791542E-2,null,4.9073685609021291,3.7073685609021263,null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,4,FALSE)","v":9},2.5,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,11,FALSE)","v":11.8}]
[null,{"$f":"(Q/3.6)/7*2","v":1.5873015873015872},0.50121275971809143,5.3776746591118557E-2,27942.941389024414,3.1666291115383459E-2,2.1709390264322153E-2,7.5486136855440714E-2,0.34806441647089686,2.9638859452776986E-2,23285.784490853675,2.5775516468849916E-2,0.10443417950882837,0.13407303896160536,null,5.0595591758170473,3.8595591758170449,null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,5,FALSE)","v":12},3.333333333333333,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,12,FALSE)","v":10.5}]
[null,{"$f":"(Q/3.6)/7*3","v":2.3809523809523809},0.75181913957713697,0.12099767983001669,41914.412083536605,3.0618472934812388E-2,4.7229839629439677E-2,0.16822751945945635,0.52209662470634532,6.6687433768748222E-2,34928.676736280519,2.3708747230989764E-2,0.21613565052310574,0.28282308429185399,null,5.3010506037513121,4.1010506037513093,null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,6,FALSE)","v":18},5,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,13,FALSE)","v":8.5}]
[null,{"$f":"(Q/3.6)/7*4","v":3.1746031746031744},1.0024255194361829,0.21510698636447423,55885.882778048828,3.0056806061801201E-2,8.2423916399567851E-2,0.29753090276404209,0.69612883294179373,0.11855543781110794,46571.568981707351,2.2448178402988853E-2,0.36381146361387273,0.48236690142498068,null,5.6298978041890244,4.4298978041890216,null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,7,FALSE)","v":24},6.6666666666666661,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,14,FALSE)","v":6.4}]
[null,{"$f":"(Q/3.6)/7*5","v":3.9682539682539679},1.2530318992952285,0.33610466619449092,69857.353472561022,2.9705643365792643E-2,0.12728270784281179,0.46338737403730268,0.87016104117724213,0.18524287157985614,58214.461227134183,2.1577416046702873E-2,0.5464050893706951,0.73164796095055129,null,6.0450353349878547,4.8450353349878519,null,null,null,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,8,FALSE)","v":36},10,{"$f":"VLOOKUP($U$13,'Base de datos'!$C$4:$S$113,15,FALSE)","v":3}]
[null,{"$f":"(Q/3.6)/7*6","v":4.7619047619047619},1.5036382791542739,0.48399071932006676,83828.82416707321,2.9465034472100683E-2,0.18180251585453591,0.66579323517460265,1.0441932494126906,0.26674973507499289,69857.353472561037,2.0930829340931972E-2,0.76324545898861185,1.0299951940636047,null,6.5457884292382085,5.3457884292382056]
[null,{"$f":"(Q/3.6)/7*7","v":5.5555555555555554},1.7542446590133198,0.65876514574120215,97800.294861585426,2.9289770773005701E-2,0.24598152373760285,0.904746669478805,1.2182254576481393,0.36307602829651825,81500.245717987884,2.042732439733054E-2,1.0138713652268347,1.3769473935233529,null,7.1316940630021595,5.9316940630021566]
[null,{"$f":"(Q/3.6)/7*8","v":6.3492063492063489},2.0048510388723657,0.86042794545789691,111771.76555609766,2.9156372506119469E-2,0.3198187332370252,1.1802466786949222,1.3922576658835875,0.47422175124443178,93143.137963414702,2.0021766084656962E-2,1.297949061635006,1.7721708128794378,null,7.8024174915743609,6.6024174915743581]
[null,{"$f":"(Q/3.6)/7*9","v":7.1428571428571423},2.2554574187314111,1.0889791184701505,125743.23625060986,2.9051419626488596E-2,0.4033135498295608,1.4922926682997113,1.5662898741190359,0.60018690391873397,104786.03020884153,1.9686726858496765E-2,1.6152279693644687,2.2154148732832026,null,8.557707541582916,7.3577075415829132]
[null,{"$f":"(Q/3.6)/7*10","v":7.9365079365079358},2.506063798590457,1.3444186647779637,139714.70694512204,2.896668020236776E-2,0.49646559718949973,1.8408842619674635,1.7403220823544843,0.74097148631942455,116428.92245426837,1.9404434374704571E-2,1.9655146243182116,2.7064861106376359,null,9.397370372605101,8.1973703726050982]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1000000]

{"sheet":"Prop. Agua","index":7,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["PROPIEDADES FÍSICAS DEL AGUA"]
["Temperatura (ºC)","Peso específico (kN/m3)","Densidad (kg/m3)","Módulo de elasticidad (kN/m2)","Viscosidad dinámica (N*s/m2)","Viscosidad cinemática (m2/s)","Tensión superficial (N/m)","Presión de vapor (kN/m2)"]
[0,9.8049999999999997,999.9,{"$f":"1.98 * 10^6","v":1980000},{"$f":"1.781 * 10^-3","v":1.781E-3},{"$f":"1.785 * 10^-6","v":1.7849999999999999E-6},7.6499999999999999E-2,0.61]
[5,9.8070000000000004,1000,{"$f":"2.05 * 10^6","v":2049999.9999999998},{"$f":"1.518 * 10^-3","v":1.518E-3},{"$f":"1.519 * 10^-6","v":1.5189999999999998E-6},7.4899999999999994E-2,0.87]
[10,9.8040000000000003,999.7,{"$f":"2.1 * 10^6","v":2100000},{"$f":"1.307 * 10^-3","v":1.307E-3},{"$f":"1.306 * 10^-6","v":1.3060000000000001E-6},7.4200000000000002E-2,1.23]
[15,9.798,999.1,{"$f":"2.15 * 10^6","v":2150000},{"$f":"1.139 * 10^-3","v":1.139E-3},{"$f":"1.139 * 10^-6","v":1.139E-6},7.3499999999999996E-2,1.7]
[20,9.7889999999999997,998.2,{"$f":"2.17 * 10^6","v":2170000},{"$f":"1.002 * 10^-3","v":1.0020000000000001E-3},{"$f":"1.003 * 10^-6","v":1.0029999999999998E-6},7.2800000000000004E-2,2.34]
[25,9.7769999999999992,997,{"$f":"2.22 * 10^6","v":2220000},{"$f":"0.89 * 10^-3","v":8.9000000000000006E-4},{"$f":"0.893 * 10^-6","v":8.9299999999999996E-7},7.1999999999999995E-2,3.17]
[30,9.7639999999999993,995.7,{"$f":"2.25 * 10^6","v":2250000},{"$f":"0.798 * 10^-3","v":7.980000000000001E-4},{"$f":"0.8 * 10^-6","v":7.9999999999999996E-7},7.1199999999999999E-2,4.24]
[40,9.73,992.2,{"$f":"2.28 * 10^6","v":2280000},{"$f":"0.653 * 10^-3","v":6.5300000000000004E-4},{"$f":"0.658 * 10^-6","v":6.5799999999999999E-7},6.9599999999999995E-2,7.38]
[50,9.6890000000000001,988,{"$f":"2.29 * 10^6","v":2290000},{"$f":"0.547 * 10^-3","v":5.4700000000000007E-4},{"$f":"0.553 * 10^-6","v":5.5300000000000004E-7},6.7900000000000002E-2,12.33]
[60,9.6419999999999995,983.2,{"$f":"2.28 * 10^6","v":2280000},{"$f":"0.466 * 10^-3","v":4.6600000000000005E-4},{"$f":"0.474 * 10^-6","v":4.7399999999999993E-7},6.6199999999999995E-2,19.920000000000002]
[70,9.5890000000000004,977.8,{"$f":"2.25 * 10^6","v":2250000},{"$f":"0.404 * 10^-3","v":4.0400000000000001E-4},{"$f":"0.413 * 10^-6","v":4.1299999999999995E-7},6.4399999999999999E-2,31.16]
[80,9.5299999999999994,971.8,{"$f":"2.2 * 10^6","v":2200000},{"$f":"0.354 * 10^-3","v":3.5399999999999999E-4},{"$f":"0.364 * 10^-6","v":3.6399999999999998E-7},6.2600000000000003E-2,47.34]
[90,9.4659999999999993,965.3,{"$f":"2.14 * 10^6","v":2140000},{"$f":"0.315 * 10^-3","v":3.1500000000000001E-4},{"$f":"0.326 * 10^-6","v":3.2599999999999998E-7},6.08E-2,70.099999999999994]
[100,9.3989999999999991,958.4,{"$f":"2.07 * 10^6","v":2069999.9999999998},{"$f":"0.282 * 10^-3","v":2.8199999999999997E-4},{"$f":"0.294 * 10^-6","v":2.9399999999999996E-7},5.8900000000000001E-2,101.33]
["Bibliografia : Tabla A.1 Metcalf & Eddy"]

{"sheet":"Tuberías","index":8,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,0,0,2],[10,0,10,1]]}
["RUGOSIDAD ABSOLUTA DE MATERIALES"]
["Material","SIMBOLO","ε (mm)"]
["Plástico (PE, PVC)","PVC",1.5E-3]
["Poliéster reforzado con fibra de vidrio","GRP",0.03]
["Acero comercial","ACERO",0.45]
["Hierro Ductil","HD",0.25]
["Concreto","CCP",0.12]
["Polietileno","PEAD",7.0000000000000001E-3]
["Bibliografia : tabla 9.5 EPM"]
[]
["DIAMETROS"]
["mm","pulg"]
[32,1.25]
[40,1.5]
[50,2]
[65,2.5]
[80,3]
[100,4]

{"sheet":"Base de datos","index":9,"n_rows":113,"n_cols":35,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,25,2,25],[1,27,2,27],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,18],[2,3,2,9],[2,10,2,16]]}
[1,2,3,4,5,6,7,8,9,{"$f":"I1+1","v":10},{"$f":"J1+1","v":11},12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"W1+1","v":24},{"$f":"X1+1","v":25},{"$f":"Y1+1","v":26},{"$f":"Z1+1","v":27},{"$f":"AA1+1","v":28},{"$f":"AB1+1","v":29},{"$f":"AC1+1","v":30},{"$f":"AD1+1","v":31},{"$f":"AE1+1","v":32},{"$f":"AF1+1","v":33},{"$f":"AG1+1","v":34},35]
["FABRICANTE","SERIE","IDENTIFICACION","CURVA CARACTERÍSTICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALIDACIÓN DE LA CURVA",null,null,null,"PASO DE SÓLIDOS","TIPO DE CONEXIÓN","DIÁMETRO DESCARGA","MOTOR","POTENCIA EJE DEL MOTOR","VELOCIDAD","SUMERGENCIA MÍNIMA","f IMPULSOR","ECUACIÓN","EFICIENCIA","COSTO DE ADQUISICIÓN"]
[null,null,null,"Q [m3/h]",null,null,null,null,null,null,"H [m]",null,null,null,null,null,null,"ECUACIÓN","R²",null,"Q [m3/h]","H [m]","VALIDACIÓN",null,"[mm]",null,"DN [mm]",null,"[kW]","[R.P.M]","[mm]","[mm]","EFICIENCIA"," [%]"," [%]"]
["ABS","AS","AS0530 S12/2W",0,5,10,15,20,25,26.53,12.27,10.78,9.3699999999999992,7.72,6.07,3.84,3.22,"H=-0.0033*Q^2-0.2478*Q+12.202",0.999,null,{"$f":"Q","v":20},{"$f":"-0.0033*Q^2-0.2478*Q+12.202","v":5.9260000000000002},{"$f":"IF(AND(V4>H-1,V4<H+1,V4>Q4),\"OK\",\"\")","v":""},null,40,"Roscado",50,"Monofásico",1.2,2900,331,110,"e=-0.0437*Q^2+1.7589*Q+33.614",{"$f":"-0.0437*Q^2+1.7589*Q+33.614","v":51.311999999999998},3000000]
["ABS","AS","AS0530 S12/2D",0,5,10,15,20,25,26.53,12.27,10.78,9.3699999999999992,7.72,6.07,3.84,3.22,"H=-0.0033*Q^2-0.2478*Q+12.202",0.999,null,20,{"$f":"-0.0033*Q^2-0.2478*Q+12.202","v":5.9260000000000002},"",null,40,"Roscado",50,"Trifásico",1.2,2900,331,110,"e=-0.0507*Q^2+1.8918*Q+38.34",{"$f":"-0.0507*Q^2+1.8918*Q+38.34","v":55.896000000000001},{"$f":"AI4+100000","v":3100000}]
["ABS","AS","AS0530 S17/2D",0,5,10,15,20,25,30,16.11,14.13,12.4,10.73,8.8800000000000008,6.89,5.07,"H=-0.0004*Q^2-0.3529*Q+16.027",0.99960000000000004,null,20,{"$f":"-0.0004*Q^2-0.3529*Q+16.027","v":8.8090000000000011},"",null,40,"Roscado",50,"Trifásico",1.7,2900,331,125,"e=-0.0476*Q^2+1.8571*Q+43.333",{"$f":"-0.0476*Q^2+1.8571*Q+43.333","v":61.434999999999988},{"$f":"AI5+100000","v":3200000}]
["ABS","AS","AS0530 S26/2D",0,5,10,15,20,25,35,21.24,19.079999999999998,17.059999999999999,15.43,13.65,11.51,6.05,"H=-0.0029*Q^2-0.3178*Q+20.935",0.99670000000000003,null,20,{"$f":"-0.0029*Q^2-0.3178*Q+20.935","v":13.418999999999997},"",null,40,"Roscado",50,"Trifásico",2.6,2900,331,142,"e=-0.0383*Q^2+1.664*Q+48.781",{"$f":"-0.0383*Q^2+1.664*Q+48.781","v":66.741},3300000]
["ABS","AS","AS0630 S10/4W",0,8.1199999999999992,15,20,25,30,35,5.36,4.51,3.58,2.97,2.36,1.87,1.3,"H=0.0002*Q^2-0.1239*Q+5.4062",0.99870000000000003,null,20,{"$f":"0.0002*Q^2-0.1239*Q+5.4062","v":3.0082000000000004},"",null,60,"Brida DN",65,"Monofásico",1,1450,348,130,"e=-0.0283*Q^2+1.3957*Q+53.084",{"$f":"-0.0283*Q^2+1.3957*Q+53.084","v":69.677999999999997},3400000]
["ABS","AS","AS0630 S10/4W",0,8.1199999999999992,20,30,40,50,53.9,7.79,6.88,5.56,4.63,3.57,2.4700000000000002,1.97,"H=-3E-05*Q^2-0.1047*Q+7.7531",0.99939999999999996,null,20,{"$f":"-0.00003*Q^2-0.1047*Q+7.7531","v":5.6471},"",null,60,"Brida DN",65,"Monofásico",1,1450,348,160,"e=-0.011*Q^2+0.8783*Q+34.006",{"$f":"-0.011*Q^2+0.8783*Q+34.006","v":47.171999999999997},3500000]
["ABS","AS","AS0630 S13/4D",0,8.1199999999999992,15,20,25,30,35,5.36,4.51,3.58,2.97,2.36,1.87,1.3,"H=0.0002*Q^2-0.1239*Q+5.4062",0.99870000000000003,null,20,{"$f":"0.0002*Q^2-0.1239*Q+5.4062","v":3.0082000000000004},"",null,60,"Brida DN",65,"Trifásico",1.3,1450,348,130,"e=-0.0283*Q^2+1.3957*Q+38.084",{"$f":"-0.0283*Q^2+1.3957*Q+38.084","v":54.677999999999997},3600000]
["ABS","AS","AS0630 S13/4D",0,8.1199999999999992,20,30,40,50,53.9,7.79,6.88,5.56,4.63,3.57,2.4700000000000002,1.97,"H=-3E-05*Q^2-0.1047*Q+7.7531",0.99939999999999996,null,20,{"$f":"-0.00003*Q^2-0.1047*Q+7.7531","v":5.6471},"",null,60,"Brida DN",65,"Trifásico",1.3,1450,348,160,"e=-0.0129*Q^2+0.9487*Q+43.723",{"$f":"-0.0129*Q^2+0.9487*Q+43.723","v":57.536999999999999},3700000]
["ABS","AS","AS0630 S13/4D",0,8.1199999999999992,15,25,30,35,46.04,9.83,8.8699999999999992,8.08,6.96,6.41,5.71,4.3899999999999997,"H=-0.0001*Q^2-0.1108*Q+9.8063",0.99960000000000004,null,20,{"$f":"-0.0001*Q^2-0.1108*Q+9.8063","v":7.5503},"OK",null,60,"Brida DN",65,"Trifásico",1.3,1450,348,186,"e=-0.0199*Q^2+1.1872*Q+48.375",{"$f":"-0.0199*Q^2+1.1872*Q+48.375","v":64.158999999999992},3800000]
["ABS","AS","AS0630 S22/4D",0,8.1199999999999992,25,35,50,60,69.09,11.39,10.51,9.08,8.0399999999999991,6.37,5.09,4,"H=-0.0003*Q^2-0.082*Q+11.317",0.99950000000000006,null,20,{"$f":"-0.0003*Q^2-0.082*Q+11.317","v":9.5570000000000004},"",null,60,"Brida DN",65,"Trifásico",2.2000000000000002,1450,348,205,"e=-0.0084*Q^2+0.7623*Q+54.138",{"$f":"-0.0084*Q^2+0.7623*Q+54.138","v":66.024000000000001},3900000]
["ABS","AS","AS0631 S12/2W",0,8.86,15,20,30,35,40.29,12.46,11.21,9.5399999999999991,8.18,4.93,2.75,0.52,"H=-0.0042*Q^2-0.1302*Q+12.52",0.99950000000000006,null,20,{"$f":"-0.0042*Q^2-0.1302*Q+12.52","v":8.2360000000000007},"",null,40,"Brida DN",65,"Monofásico",1.2,2900,346,128,"e=-0.0197*Q^2+1.1895*Q+33.326",{"$f":"-0.0197*Q^2+1.1895*Q+33.326","v":49.236000000000004},4000000]
["ABS","AS","AS0631 S12/2D",0,8.86,15,20,30,35,40.29,12.46,11.21,9.5399999999999991,8.18,4.93,2.75,0.52,"H=-0.0042*Q^2-0.1302*Q+12.52",0.99950000000000006,null,20,{"$f":"-0.0042*Q^2-0.1302*Q+12.52","v":8.2360000000000007},"",null,40,"Brida DN",65,"Trifásico",1.2,2900,346,128,"e=-0.0234*Q^2+1.2956*Q+37.965",{"$f":"-0.0234*Q^2+1.2956*Q+37.965","v":54.51700000000001},4100000]
["ABS","AS","AS0631 S17/2W",0,8.58,15,25,35,45,52.26,17.149999999999999,15.15,13.26,10.23,7.13,3.82,1.27,"H=-0.001*Q^2-0.2513*Q+17.239",0.99980000000000002,null,20,{"$f":"-0.001*Q^2-0.2513*Q+17.239","v":11.812999999999999},"",null,40,"Brida DN",65,"Monofásico",1.65,2900,346,142,"e=-0.0166*Q^2+1.1161*Q+43.302",{"$f":"-0.0166*Q^2+1.1161*Q+43.302","v":58.984000000000002},4200000]
["ABS","AS","AS0631 S17/2D",0,8.58,15,25,35,45,52.26,17.149999999999999,15.15,13.26,10.23,7.13,3.82,1.27,"H=-0.001*Q^2-0.2513*Q+17.239",0.99980000000000002,null,20,{"$f":"-0.001*Q^2-0.2513*Q+17.239","v":11.812999999999999},"",null,40,"Brida DN",65,"Trifásico",1.7,2900,346,142,"e=-0.0166*Q^2+1.1161*Q+48.302",{"$f":"-0.0166*Q^2+1.1161*Q+48.302","v":63.984000000000002},4300000]
["ABS","AS","AS0631 S30/2D",0,9.07,20,40,50,60,68.34,22.27,19.8,16.149999999999999,10.34,7,3.87,1.21,"H=-0.0002*Q^2-0.2946*Q+22.32",0.99980000000000002,null,20,{"$f":"-0.0002*Q^2-0.2946*Q+22.32","v":16.347999999999999},"",null,40,"Brida DN",65,"Trifásico",3,2900,346,151,"e=-0.0091*Q^2+0.806*Q+53.919",{"$f":"-0.0091*Q^2+0.806*Q+53.919","v":66.399000000000001},4400000]
["ABS","AS","AS0641 S30/2D",0,9.0399999999999991,20,30,40,60,69.42,28.07,24.83,21.09,17.93,14.14,7.14,3.6,"H=-0.0002*Q^2-0.3348*Q+27.983",0.99980000000000002,null,20,{"$f":"-0.0002*Q^2-0.3348*Q+27.983","v":21.207000000000001},"",null,45,"Brida DN",65,"Trifásico",3,2900,346,143,"e=-0.0088*Q^2+0.8124*Q+33.987",{"$f":"-0.0088*Q^2+0.8124*Q+33.987","v":46.715000000000003},4500000]
["ABS","AS","AS0830 S10/4W",0,8.1199999999999992,15,20,25,30,35,5.36,4.51,3.58,2.97,2.36,1.87,1.3,"H=0.0002*Q^2-0.1239*Q+5.4062",0.99870000000000003,null,20,{"$f":"0.0002*Q^2-0.1239*Q+5.4062","v":3.0082000000000004},"",null,60,"Brida DN",80,"Monofásico",1,1450,305,130,"e=-0.0283*Q^2+1.3957*Q+38.084",{"$f":"-0.0283*Q^2+1.3957*Q+38.084","v":54.677999999999997},4600000]
["ABS","AS","AS0830 S10/4W",0,8.1199999999999992,20,30,40,50,53.9,7.79,6.88,5.56,4.63,3.57,2.4700000000000002,1.97,"H=-3E-05*Q^2-0.1047*Q+7.7531",0.99939999999999996,null,20,{"$f":"-0.00003*Q^2-0.1047*Q+7.7531","v":5.6471},"",null,60,"Brida DN",80,"Monofásico",1,1450,305,160,"e=-0.0129*Q^2+0.9487*Q+43.723",{"$f":"-0.0129*Q^2+0.9487*Q+43.723","v":57.536999999999999},4700000]
["ABS","AS","AS0830 S13/4D",0,8.1199999999999992,15,20,25,30,35,5.36,4.51,3.58,2.97,2.36,1.87,1.3,"H=0.0002*Q^2-0.1239*Q+5.4062",0.99870000000000003,null,20,{"$f":"0.0002*Q^2-0.1239*Q+5.4062","v":3.0082000000000004},"",null,60,"Brida DN",80,"Trifásico",1.3,1450,305,130,"e=-0.0283*Q^2+1.3957*Q+48.084",{"$f":"-0.0283*Q^2+1.3957*Q+48.084","v":64.677999999999997},4800000]
["ABS","AS","AS0830 S13/4D",0,8.1199999999999992,20,30,40,50,53.9,7.79,6.88,5.56,4.63,3.57,2.4700000000000002,1.97,"H=-3E-05*Q^2-0.1047*Q+7.7531",0.99939999999999996,null,20,{"$f":"-0.00003*Q^2-0.1047*Q+7.7531","v":5.6471},"",null,60,"Brida DN",80,"Trifásico",1.3,1450,305,160,"e=-0.0129*Q^2+0.9487*Q+53.723",{"$f":"-0.0129*Q^2+0.9487*Q+53.723","v":67.537000000000006},4900000]
["ABS","AS","AS0830 S13/4D",0,8.1199999999999992,15,25,30,35,46.04,9.83,8.8699999999999992,8.08,6.96,6.41,5.71,4.3899999999999997,"H=-0.0001*Q^2-0.1108*Q+9.8063",0.99960000000000004,null,20,{"$f":"-0.0001*Q^2-0.1108*Q+9.8063","v":7.5503},"OK",null,60,"Brida DN",80,"Trifásico",1.3,1450,305,186,"e=-0.0165*Q^2+1.0821*Q+33.738",{"$f":"-0.0165*Q^2+1.0821*Q+33.738","v":48.78},5000000]
["ABS","AS","AS0830 S22/4D",0,8.1199999999999992,25,35,50,60,69.09,11.39,10.51,9.08,8.0399999999999991,6.37,5.09,4,"H=-0.0003*Q^2-0.082*Q+11.317",0.99950000000000006,null,20,{"$f":"-0.0003*Q^2-0.082*Q+11.317","v":9.5570000000000004},"",null,60,"Brida DN",80,"Trifásico",2.2000000000000002,1450,305,205,"e=-0.0084*Q^2+0.7623*Q+39.138",{"$f":"-0.0084*Q^2+0.7623*Q+39.138","v":51.024000000000001},5100000]
["ABS","AS","AS0840 S12/2W",0,9.89,15,20,25,30,33.950000000000003,8.0399999999999991,5.62,4.67,3.69,2.86,1.89,1.1499999999999999,"H=0.0011*Q^2-0.2381*Q+7.9869",0.99890000000000001,null,20,{"$f":"0.0011*Q^2-0.2381*Q+7.9869","v":3.6649000000000003},"",null,30,"Brida DN",80,"Monofásico",1.2,2900,305,110,"e=-0.0264*Q^2+1.3346*Q+43.024",{"$f":"-0.0264*Q^2+1.3346*Q+43.024","v":59.155999999999999},5200000]
["ABS","AS","AS0840 S12/2W",0,10.119999999999999,20,30,35,45,52.28,12.44,10,7.72,5.76,4.72,2.69,1.48,"H=0.0007*Q^2-0.2447*Q+12.421",0.99980000000000002,null,20,{"$f":"0.0007*Q^2-0.2447*Q+12.421","v":7.8069999999999995},"OK",null,30,"Brida DN",80,"Monofásico",1.2,2900,305,118,"e=-0.0142*Q^2+0.9989*Q+48.213",{"$f":"-0.0142*Q^2+0.9989*Q+48.213","v":62.511000000000003},5300000]
["ABS","AS","AS0840 S12/2D",0,9.89,15,20,25,30,33.950000000000003,8.0399999999999991,5.62,4.67,3.69,2.86,1.89,1.1499999999999999,"H=0.0011*Q^2-0.2381*Q+7.9869",0.99890000000000001,null,20,{"$f":"0.0011*Q^2-0.2381*Q+7.9869","v":3.6649000000000003},"",null,30,"Brida DN",80,"Trifásico",1.2,2900,305,110,"e=-0.0264*Q^2+1.3346*Q+53.024",{"$f":"-0.0264*Q^2+1.3346*Q+53.024","v":69.156000000000006},5400000]
["ABS","AS","AS0840 S12/2D",0,10.119999999999999,20,30,35,45,52.28,12.44,10,7.72,5.76,4.72,2.69,1.48,"H=0.0007*Q^2-0.2447*Q+12.421",0.99980000000000002,null,20,{"$f":"0.0007*Q^2-0.2447*Q+12.421","v":7.8069999999999995},"OK",null,30,"Brida DN",80,"Trifásico",1.2,2900,305,118,"e=-0.0142*Q^2+0.9989*Q+38.213",{"$f":"-0.0142*Q^2+0.9989*Q+38.213","v":52.511000000000003},5500000]
["ABS","AS","AS0840 S17/2D",0,10,15,25,35,45,54.16,15.95,13.41,12.1,9.57,7.34,4.99,2.85,"H=0.0004*Q^2-0.2602*Q+15.944",0.99990000000000001,null,20,{"$f":"0.0004*Q^2-0.2602*Q+15.944","v":10.900000000000002},"",null,30,"Brida DN",80,"Trifásico",1.7,2900,305,128,"e=-0.0157*Q^2+1.0878*Q+43.136",{"$f":"-0.0157*Q^2+1.0878*Q+43.136","v":58.612000000000002},5600000]
["ABS","AS","AS0840 S26/2D",0,9.66,15,30,50,60,67.319999999999993,22.63,17.71,15.86,11.86,7.67,5.2,3.06,"H=0.0017*Q^2-0.3854*Q+21.874",0.99209999999999998,null,20,{"$f":"0.0017*Q^2-0.3854*Q+21.874","v":14.845999999999998},"",null,30,"Brida DN",80,"Trifásico",2.6,2900,305,142,"e=-0.0108*Q^2+0.9141*Q+48.673",{"$f":"-0.0108*Q^2+0.9141*Q+48.673","v":62.635000000000005},5700000]
["ABS","AS","AS0841 S13/4D",0,10,20,30,40,50,59.14,4.66,4.17,3.63,3.03,2.4,1.73,1.08,"H=-0.0002*Q^2-0.0478*Q+4.665",1,null,20,{"$f":"-0.0002*Q^2-0.0478*Q+4.665","v":3.629},"",null,80,"Brida DN",80,"Trifásico",1.3,1450,445,152,"e=-0.0121*Q^2+0.9349*Q+53.31",{"$f":"-0.0121*Q^2+0.9349*Q+53.31","v":67.168000000000006},5800000]
["BOMBAS IDEAL","ARS","ARS 40-10V/0,5",0,4,6,8,10,12,14.1,7.3,5.85,5,4.0999999999999996,3.1,2.06,0.9,"H=-0.0087*Q^2-0.3316*Q+7.3054",1,null,20,{"$f":"-0.0087*Q^2-0.3316*Q+7.3054","v":-2.8065999999999987},"",null,30,"Roscado",32,"Trifásico",0.3,2850,280,110,"e=-0.1343*Q^2+3.0536*Q+33.262",{"$f":"-0.1343*Q^2+3.0536*Q+33.262","v":40.613999999999997},3000000]
["BOMBAS IDEAL","ARS","ARS 50-16V/1,8",0,10,15,20,25,30,36.299999999999997,12.4,10,8.5,7,5.3,3.5,1.1000000000000001,"H=-0.0025*Q^2-0.2216*Q+12.417",0.99990000000000001,null,20,{"$f":"-0.0025*Q^2-0.2216*Q+12.417","v":6.9850000000000003},"OK",null,50,"Roscado",50,"Trifásico",1.3,2850,339,110,"e=-0.0262*Q^2+1.3443*Q+37.916",{"$f":"-0.0262*Q^2+1.3443*Q+37.916","v":54.322000000000003},3100000]
["BOMBAS IDEAL","ARS","ARS 50-16V/2,5",0,10,15,20,25,30,37.25,15.6,12.3,10.65,9,7.3,5.6,3.1,"H=-0.0003*Q^2-0.3248*Q+15.592",1,null,20,{"$f":"-0.0003*Q^2-0.3248*Q+15.592","v":8.9760000000000009},"",null,50,"Roscado",50,"Trifásico",1.8,2850,339,110,"e=-0.0259*Q^2+1.3407*Q+42.901",{"$f":"-0.0259*Q^2+1.3407*Q+42.901","v":59.355000000000004},3200000]
["BOMBAS IDEAL","ARS","ARS 80-16V/2,5",0,10,20,30,40,50,54.6,8.1999999999999993,6.8,5.6,4.2,2.8,1.3,0.75,"H=-0.0002*Q^2-0.1281*Q+8.1731",0.99960000000000004,null,{"$f":"Q","v":20},{"$f":"-0.0002*Q^2-0.1281*Q+8.1731","v":5.5311000000000003},{"$f":"IF(AND(V36>H-1,V36<H+1,V36>Q36),\"OK\",\"\")","v":""},null,60,"Bridado",80,"Trifásico",1.7,2850,420,110,"e=-0.0127*Q^2+0.9506*Q+48.292",{"$f":"-0.0127*Q^2+0.9506*Q+48.292","v":62.224000000000004},3300000]
["BOMBAS IDEAL","ARS","ARS 80-17V/5,5",0,10,20,30,40,50,66.400000000000006,17.5,14.9,12.3,9.8000000000000007,7.5,5,1.2,"H=0.0003*Q^2-0.2625*Q+17.487",0.99990000000000001,null,20,{"$f":"0.0003*Q^2-0.2625*Q+17.487","v":12.356999999999999},"",null,50,"Bridado",80,"Trifásico",3.1,2850,449,110,"e=-0.0104*Q^2+0.868*Q+53.602",{"$f":"-0.0104*Q^2+0.868*Q+53.602","v":66.801999999999992},3400000]
["BOMBAS IDEAL","ARS","ARS 80-17V/4",0,10,20,30,40,50,60,15.2,12.8,10.4,8.1,5.9,3.6,1.5,"H=0.0003*Q^2-0.2443*Q+15.202",1,null,20,{"$f":"0.0003*Q^2-0.2443*Q+15.202","v":10.436},"",null,50,"Bridado",80,"Trifásico",2.7,2850,449,110,"e=-0.0101*Q^2+0.8536*Q+33.69",{"$f":"-0.0101*Q^2+0.8536*Q+33.69","v":46.721999999999994},3500000]
["BOMBAS IDEAL","ARS","ARS 80B-18 V/7,5E",0,10,20,30,40,50,62.3,20.3,19.399999999999999,18.399999999999999,17.3,16.2,15.1,13.7,"H=-0.0002*Q^2-0.0948*Q+20.334",0.99980000000000002,null,20,{"$f":"-0.0002*Q^2-0.0948*Q+20.334","v":18.358000000000001},"",null,80,"Bridado",80,"Trifásico",5.5,2850,570,110,"e=-0.0114*Q^2+0.9086*Q+38.415",{"$f":"-0.0114*Q^2+0.9086*Q+38.415","v":52.027000000000001},3600000]
["BOMBAS IDEAL","ARS","ARS 80-19V/10",0,10,20,30,40,50,65.8,28.5,26.5,24.5,22.3,20,17.5,13.7,"H=-0.0005*Q^2-0.1935*Q+28.512",0.99990000000000001,null,20,{"$f":"-0.0005*Q^2-0.1935*Q+28.512","v":24.442},"",null,70,"Bridado",80,"Trifásico",7,2850,449,110,"e=-0.0105*Q^2+0.8741*Q+43.573",{"$f":"-0.0105*Q^2+0.8741*Q+43.573","v":56.855000000000004},3700000]
["BOMBAS IDEAL","ARS","ARS 80-20V/22",0,10,20,30,40,50,60.08,46.7,45,43.2,41.2,39.1,37,34.700000000000003,"H=-0.0005*Q^2-0.1673*Q+46.719",1,null,20,{"$f":"-0.0005*Q^2-0.1673*Q+46.719","v":43.173000000000002},"",null,50,"Bridado",80,"Trifásico",15.7,2850,640,110,"e=-0.0119*Q^2+0.9279*Q+48.336",{"$f":"-0.0119*Q^2+0.9279*Q+48.336","v":62.134},3800000]
["BOMBAS IDEAL","ARS","ARS 65-18V/1",0,10,20,25,30,40,44.2,6.7,5.5,4.2,3.5,2.7,1,0.3,"H=-0.0008*Q^2-0.1076*Q+6.689",0.99990000000000001,null,20,{"$f":"-0.0008*Q^2-0.1076*Q+6.689","v":4.2170000000000005},"",null,50,"Roscado",65,"Trifásico",0.8,1450,383,110,"e=-0.0176*Q^2+1.0998*Q+53.177",{"$f":"-0.0176*Q^2+1.0998*Q+53.177","v":68.13300000000001},3900000]
["BOMBAS IDEAL","ARS","ARS 65-18V/1,5",0,10,20,25,30,40,46.3,8,6.7,5.3,4.6500000000000004,3.8,2.2000000000000002,1.1000000000000001,"H=-0.0006*Q^2-0.121*Q+7.9886",0.99980000000000002,null,20,{"$f":"-0.0006*Q^2-0.121*Q+7.9886","v":5.3285999999999998},"",null,50,"Roscado",65,"Trifásico",0.9,1450,383,110,"e=-0.0146*Q^2+1.0104*Q+33.436",{"$f":"-0.0146*Q^2+1.0104*Q+33.436","v":47.804000000000002},4000000]
["BOMBAS IDEAL","ARS","ARS 65-18V/1,7",0,10,20,30,40,50,51.5,9.6,8.1,6.6,4.9000000000000004,3.1,1.3,1,"H=-0.0005*Q^2-0.1423*Q+9.5968",0.99990000000000001,null,20,{"$f":"-0.0005*Q^2-0.1423*Q+9.5968","v":6.5507999999999997},"OK",null,50,"Roscado",65,"Trifásico",1.2,1450,383,110,"e=-0.0125*Q^2+0.9344*Q+38.421",{"$f":"-0.0125*Q^2+0.9344*Q+38.421","v":52.108999999999995},4100000]
["BOMBAS IDEAL","ARS","ARS 80-18V/1,5",0,10,20,30,40,50,57,6.9,6.1,5.3,4.4000000000000004,3.3,2.0499999999999998,1.05,"H=-0.0007*Q^2-0.0624*Q+6.8539",0.99960000000000004,null,20,{"$f":"-0.0007*Q^2-0.0624*Q+6.8539","v":5.3259000000000007},"",null,50,"Bridado",80,"Trifásico",1.2,1450,420,110,"e=-0.0124*Q^2+0.9468*Q+43.276",{"$f":"-0.0124*Q^2+0.9468*Q+43.276","v":57.252000000000002},4200000]
["BOMBAS IDEAL","ARS","ARS 80-18V/1,7",0,10,20,30,50,60,64.8,8.1999999999999993,7.3,6.3,5.2,3,1.8,1.2,"H=-0.0003*Q^2-0.0917*Q+8.2174",0.99990000000000001,null,20,{"$f":"-0.0003*Q^2-0.0917*Q+8.2174","v":6.263399999999999},"OK",null,50,"Bridado",80,"Trifásico",1,1450,420,110,"e=-0.0101*Q^2+0.8729*Q+48.397",{"$f":"-0.0101*Q^2+0.8729*Q+48.397","v":61.814999999999998},4300000]
["BOMBAS IDEAL","ARS","ARS 80A-19V/1",0,10,20,30,40,50,55.4,4.8,4.5,4.0999999999999996,3.6,2.8,2,1.4,"H=-0.0008*Q^2-0.0177*Q+4.782",0.99929999999999997,null,20,{"$f":"-0.0008*Q^2-0.0177*Q+4.782","v":4.1080000000000005},"",null,75,"Bridado",80,"Trifásico",0.8,1450,530,110,"e=-0.0126*Q^2+0.9507*Q+53.28",{"$f":"-0.0126*Q^2+0.9507*Q+53.28","v":67.254000000000005},4400000]
["BOMBAS IDEAL","ARS","ARS 80A-19V/1,5",0,10,20,30,50,70,72.400000000000006,6.2,5.9,5.6,5.0999999999999996,3.8,2,1.8,"H=-0.0006*Q^2-0.0186*Q+6.1832",0.99980000000000002,null,20,{"$f":"-0.0006*Q^2-0.0186*Q+6.1832","v":5.5712000000000002},"",null,75,"Bridado",80,"Trifásico",1.1000000000000001,1450,530,110,"e=-0.0079*Q^2+0.7835*Q+33.807",{"$f":"-0.0079*Q^2+0.7835*Q+33.807","v":46.317},4500000]
["BOMBAS IDEAL","ARS","ARS 100A-26V/7,5E",0,10,20,30,40,50,53.5,20,19.3,18.7,18,17.3,16.5,16.3,"H=-0.0001*Q^2-0.0623*Q+19.98",0.99950000000000006,null,20,{"$f":"-0.0001*Q^2-0.0623*Q+19.98","v":18.693999999999999},"",null,100,"Bridado",100,"Trifásico",5.5,1450,629,110,"e=-0.0127*Q^2+0.9479*Q+38.323",{"$f":"-0.0127*Q^2+0.9479*Q+38.323","v":52.201000000000001},4600000]
["BOMBAS IDEAL","ARS","ARS 50-14MI/2",0,2.5,5,7.5,10,15,17.899999999999999,25,23.8,22.5,21.3,20,17,15.1,"H=-0.0059*Q^2-0.4436*Q+24.958",0.99980000000000002,null,20,{"$f":"-0.0059*Q^2-0.4436*Q+24.958","v":13.725999999999999},"",null,25,"Bridado",50,"Trifásico",1.5,2850,297,110,"e=-0.1538*Q^2+3.4169*Q+43.557",{"$f":"-0.1538*Q^2+3.4169*Q+43.557","v":50.375},4700000]
["BOMBAS IDEAL","ARS","ARS 50-14MI/1,4",0,5,7.5,10,15,20,24.8,17.2,15,13.8,12.7,10.6,8,5.8,"H=-0.0011*Q^2-0.4332*Q+17.18",0.99960000000000004,null,20,{"$f":"-0.0011*Q^2-0.4332*Q+17.18","v":8.0760000000000005},"OK",null,25,"Bridado",50,"Trifásico",1,2850,297,110,"e=-0.076*Q^2+2.3971*Q+47.962",{"$f":"-0.076*Q^2+2.3971*Q+47.962","v":65.504000000000005},4800000]
["BOMBAS IDEAL","ARS","ARS 50-14MI/1",0,2.5,5,7.5,10,15,18.8,13,11.6,10.3,9.1,7.9,5.4,3.1,"H=-0.0013*Q^2-0.4914*Q+12.898",0.99909999999999999,null,20,{"$f":"-0.0013*Q^2-0.4914*Q+12.898","v":2.5500000000000007},"",null,25,"Bridado",50,"Trifásico",0.8,2850,297,110,"e=-0.143*Q^2+3.2879*Q+53.747",{"$f":"-0.143*Q^2+3.2879*Q+53.747","v":62.305},4900000]
["BOMBAS IDEAL","ARS","ARS 80-14MI/3",0,5,10,15,20,25,30,24,22,20,18,16.100000000000001,14.2,12,"H=-0.0001*Q^2-0.3921*Q+23.971",0.99980000000000002,null,20,{"$f":"-0.0001*Q^2-0.3921*Q+23.971","v":16.088999999999999},"",null,40,"Bridado",80,"Trifásico",2.2000000000000002,2850,530,110,"e=-0.0405*Q^2+1.7071*Q+33.69",{"$f":"-0.0405*Q^2+1.7071*Q+33.69","v":51.632000000000005},5000000]
["BOMBAS IDEAL","ARS","ARS 80-15MI/4",0,5,10,15,20,25,27.6,26.4,24.5,22.6,20.5,18.399999999999999,16.3,15,"H=-0.0016*Q^2-0.3666*Q+26.393",0.99990000000000001,null,20,{"$f":"-0.0016*Q^2-0.3666*Q+26.393","v":18.420999999999999},"",null,40,"Bridado",80,"Trifásico",3,2850,530,110,"e=-0.0506*Q^2+1.9016*Q+38.282",{"$f":"-0.0506*Q^2+1.9016*Q+38.282","v":56.073999999999998},5100000]
["BOMBAS IDEAL","ARS","ARS 80-15MI/2",0,5,10,15,20,25,27.8,15.5,14,12.5,11,9.5,8.1999999999999993,7.2,"H=0.0002*Q^2-0.3026*Q+15.5",0.99960000000000004,null,20,{"$f":"0.0002*Q^2-0.3026*Q+15.5","v":9.5280000000000005},"",null,30,"Bridado",80,"Trifásico",1.5,2850,530,110,"e=-0.0505*Q^2+1.9009*Q+43.278",{"$f":"-0.0505*Q^2+1.9009*Q+43.278","v":61.095999999999997},5200000]
["BOMBAS IDEAL","ARS","ARS 65-13M/2",0,10,15,20,30,40,44.39,19.5,16.100000000000001,14.2,12.3,8.1,3.4,1.25,"H=-0.0021*Q^2-0.3184*Q+19.489",1,null,20,{"$f":"-0.0021*Q^2-0.3184*Q+19.489","v":12.281000000000001},"",null,30,"Roscado",65,"Trifásico",1.3,2850,383,110,"e=-0.0211*Q^2+1.2537*Q+47.794",{"$f":"-0.0211*Q^2+1.2537*Q+47.794","v":64.427999999999997},5300000]
["BOMBAS IDEAL","ARS","ARS 65-14M/3",0,10,20,30,40,50,58.3,19.899999999999999,17.5,14.9,12,8.9,5.6,2.6,"H=-0.0012*Q^2-0.227*Q+19.898",1,null,20,{"$f":"-0.0012*Q^2-0.227*Q+19.898","v":14.878},"",null,40,"Roscado",65,"Trifásico",2,2850,383,110,"e=-0.0122*Q^2+0.9404*Q+53.292",{"$f":"-0.0122*Q^2+0.9404*Q+53.292","v":67.22},5400000]
["BOMBAS IDEAL","ARS","ARS 65-14M/2,5",0,10,20,30,40,50,53.1,18.100000000000001,15,11.9,8.6999999999999993,5.4,2.1,1,"H=-0.0003*Q^2-0.3029*Q+18.088",1,null,20,{"$f":"-0.0003*Q^2-0.3029*Q+18.088","v":11.91},"",null,40,"Roscado",65,"Trifásico",1.8,2850,383,110,"e=-0.0127*Q^2+0.9461*Q+38.338",{"$f":"-0.0127*Q^2+0.9461*Q+38.338","v":52.18},5500000]
["BOMBAS IDEAL","ARS","ARS 80-22M/21",0,10,20,30,40,50,55.8,65.400000000000006,62.5,59.5,56.3,53,49.6,47.6,"H=-0.0006*Q^2-0.2847*Q+65.41",1,null,20,{"$f":"-0.0006*Q^2-0.2847*Q+65.41","v":59.475999999999999},"",null,40,"Bridado",80,"Trifásico",15.2,2850,608,110,"e=-0.0126*Q^2+0.9502*Q+43.276",{"$f":"-0.0126*Q^2+0.9502*Q+43.276","v":57.240000000000009},5600000]
["DAB","FEKA","FEKA GL 500 M-A",0,3,6,9,12,15,null,8,6.9,5.8,4.5999999999999996,3.2,1.8,null,"H=-0.0054*Q^2-0.332*Q+7.9821",0.99980000000000002,null,20,{"$f":"-0.0054*Q^2-0.332*Q+7.9821","v":-0.81790000000000074},"",null,30,"Roscado",40,"Monofásico",0.4,2900,400,110,"e=-0.1885*Q^2+5.0655*Q+28.393",{"$f":"-0.1885*Q^2+5.0655*Q+28.393","v":54.302999999999997},3000000]
["DAB","FEKA","FEKA GL 650 M-A",0,3,6,9,12,15,18,10,8.6999999999999993,7.4,6,4.75,3.3,1.6,"H=-0.0032*Q^2-0.4018*Q+9.9595",0.99939999999999996,null,20,{"$f":"-0.0032*Q^2-0.4018*Q+9.9595","v":0.64350000000000129},"",null,30,"Roscado",40,"Monofásico",0.4,2900,400,110,"e=-0.2447*Q^2+5.7738*Q+32.381",{"$f":"-0.2447*Q^2+5.7738*Q+32.381","v":49.977000000000004},3100000]
["DAB","FEKA","FEKA GL 750 M-A (NA)",0,3,6,9,12,18,24,7.2,6.8,6.2,5.5,4.8,3.3,1.6,"H=-0.0029*Q^2-0.1676*Q+7.2609",0.99950000000000006,null,20,{"$f":"-0.0029*Q^2-0.1676*Q+7.2609","v":2.7489000000000008},"",null,46,"Roscado",50,"Monofásico",0.6,2900,400,110,"e=-0.1641*Q^2+4.8038*Q+38.74",{"$f":"-0.1641*Q^2+4.8038*Q+38.74","v":69.175999999999988},3200000]
["DAB","FEKA","FEKA GL 1000 M-A (NA)",0,3,6,9,15,24,30,11.2,10.8,10,9.1,7,3.5,1.8,"H=-0.0024*Q^2-0.2596*Q+11.469",0.99570000000000003,null,20,{"$f":"-0.0024*Q^2-0.2596*Q+11.469","v":5.3169999999999993},"",null,46,"Roscado",50,"Monofásico",1.1000000000000001,2900,400,110,"e=-0.1153*Q^2+4.0934*Q+44.927",{"$f":"-0.1153*Q^2+4.0934*Q+44.927","v":80.674999999999997},3300000]
["DAB","FEKA","FEKA 1400 M",0,6,9,12,15,24,30,13.9,12,11,9.9,8.9,5.7,3.4,"H=-0.0011*Q^2-0.3167*Q+13.912",0.99990000000000001,null,20,{"$f":"-0.0011*Q^2-0.3167*Q+13.912","v":7.1380000000000008},"OK",null,38,"Roscado",50,"Monofásico",1.1000000000000001,2900,400,110,"e=-0.0991*Q^2+3.7729*Q+26.751",{"$f":"-0.0991*Q^2+3.7729*Q+26.751","v":62.569000000000003},3400000]
["DAB","FEKA","FEKA 1800 T",0,6,9,12,15,24,30,15.5,13.7,12.8,11.8,10.7,7.3,4.5,"H=-0.0032*Q^2-0.267*Q+15.465",0.99980000000000002,null,20,{"$f":"-0.0032*Q^2-0.267*Q+15.465","v":8.8449999999999989},"",null,38,"Roscado",50,"Trifásico",1.5,2900,400,110,"e=-0.0991*Q^2+3.7729*Q+31.751",{"$f":"-0.0991*Q^2+3.7729*Q+31.751","v":67.569000000000003},3500000]
["DAB","FEKA","FEKA 2015.2 MA (MNA)",0,3,6,12,18,24,36,12.5,11.5,10.5,8,5.8,3.6,null,"H=-0.0002*Q^2-0.3714*Q+12.583",0.99929999999999997,null,20,{"$f":"-0.0002*Q^2-0.3714*Q+12.583","v":5.0750000000000002},"",null,42,"Bridado",50,"Monofásico",1.1000000000000001,2900,400,110,"e=-0.073*Q^2+3.1002*Q+41.757",{"$f":"-0.073*Q^2+3.1002*Q+41.757","v":74.561000000000007},3600000]
["DAB","FEKA","FEKA 2015.2 TNA",0,3,6,12,18,24,36,12.5,11.5,10.5,8,5.8,3.6,null,"H=-0.0002*Q^2-0.3714*Q+12.583",0.99929999999999997,null,20,{"$f":"-0.0002*Q^2-0.3714*Q+12.583","v":5.0750000000000002},"",null,42,"Bridado",50,"Trifásico",1.1000000000000001,2900,400,110,"e=-0.073*Q^2+3.1002*Q+46.757",{"$f":"-0.073*Q^2+3.1002*Q+46.757","v":79.561000000000007},3700000]
["DAB","FEKA","FEKA 2025.2 TNA",0,3,6,12,18,24,36,17.5,16.5,15.6,13.6,11.6,9,3.8,"H=-0.0026*Q^2-0.2859*Q+17.44",0.99970000000000003,null,{"$f":"Q","v":20},{"$f":"-0.0026*Q^2-0.2859*Q+17.44","v":10.682000000000002},{"$f":"IF(AND(V68>H-1,V68<H+1,V68>Q68),\"OK\",\"\")","v":""},null,42,"Bridado",50,"Trifásico",1.8,2900,400,110,"e=-0.073*Q^2+3.1002*Q+31.757",{"$f":"-0.073*Q^2+3.1002*Q+31.757","v":64.561000000000007},3800000]
["DAB","FEKA","FEKA 2030.2 TNA",0,3,6,12,18,24,36,21,19.8,18.5,16,13.8,11,6,"H=-0.0004*Q^2-0.4029*Q+20.983",0.99970000000000003,null,20,{"$f":"-0.0004*Q^2-0.4029*Q+20.983","v":12.765000000000001},"",null,42,"Bridado",50,"Trifásico",2.2000000000000002,2900,400,110,"e=-0.073*Q^2+3.1002*Q+36.757",{"$f":"-0.073*Q^2+3.1002*Q+36.757","v":69.561000000000007},3900000]
["DAB","FEKA","FEKA 2508.4M-NA",0,3,6,12,18,24,36,5.4,5.0999999999999996,4.8,4.0999999999999996,3.4,2.6,1,"H=-0.0006*Q^2-0.1026*Q+5.4139",0.99990000000000001,null,20,{"$f":"-0.0006*Q^2-0.1026*Q+5.4139","v":3.1219000000000001},"",null,62,"Bridado",65,"Monofásico",0.6,2900,400,110,"e=-0.073*Q^2+3.1002*Q+41.757",{"$f":"-0.073*Q^2+3.1002*Q+41.757","v":74.561000000000007},{"$f":"AI69+100000","v":4000000}]
["DAB","FEKA","FEKA 2508.4T",0,3,6,12,18,24,36,5.4,5.0999999999999996,4.8,4.0999999999999996,3.4,2.6,1,"H=-0.0006*Q^2-0.1026*Q+5.4139",0.99990000000000001,null,20,{"$f":"-0.0006*Q^2-0.1026*Q+5.4139","v":3.1219000000000001},"",null,62,"Bridado",65,"Trifásico",0.6,2900,400,110,"e=-0.073*Q^2+3.1002*Q+46.757",{"$f":"-0.073*Q^2+3.1002*Q+46.757","v":79.561000000000007},4100000]
["DAB","FEKA","FEKA 2515.4T",0,3,12,18,24,36,48,6.2,6.1,5.5,5,4.5,3.1,1.4,"H=-0.0011*Q^2-0.0452*Q+6.2163",0.99980000000000002,null,20,{"$f":"-0.0011*Q^2-0.0452*Q+6.2163","v":4.872300000000001},"",null,62,"Bridado",65,"Trifásico",1.1000000000000001,2900,400,110,"e=-0.0391*Q^2+2.2581*Q+31.247",{"$f":"-0.0391*Q^2+2.2581*Q+31.247","v":60.769000000000005},4200000]
["DAB","FEKA","FEKA 2500.4T",0,3,12,18,24,36,48,8,7.8,7.2,6.7,6.3,5.4,4.4000000000000004,"H=-0.0002*Q^2-0.0671*Q+8.0016",0.99970000000000003,null,20,{"$f":"-0.0002*Q^2-0.0671*Q+8.0016","v":6.5795999999999992},"OK",null,62,"Bridado",65,"Trifásico",1.4,2900,400,110,"e=-0.0391*Q^2+2.2581*Q+36.247",{"$f":"-0.0391*Q^2+2.2581*Q+36.247","v":65.769000000000005},4300000]
["DAB","FEKA","FEKA 2515.2T",0,3,6,12,18,24,36,9.3000000000000007,8.8000000000000007,8.4,7.6,6.5,5.3,3,"H=-0.0011*Q^2-0.1353*Q+9.2755",0.99909999999999999,null,20,{"$f":"-0.0011*Q^2-0.1353*Q+9.2755","v":6.1294999999999993},"",null,62,"Bridado",65,"Trifásico",1.1000000000000001,2900,400,110,"e=-0.073*Q^2+3.1002*Q+41.757",{"$f":"-0.073*Q^2+3.1002*Q+41.757","v":74.561000000000007},4400000]
["DAB","FEKA","FEKA 2500.2T",0,3,12,18,24,36,48,14,13.5,12,11,10,7.5,4,"H=-0.0016*Q^2-0.1249*Q+13.892",0.99839999999999995,null,20,{"$f":"-0.0016*Q^2-0.1249*Q+13.892","v":10.754},"",null,62,"Bridado",65,"Trifásico",1.8,2900,400,110,"e=-0.0391*Q^2+2.2581*Q+46.247",{"$f":"-0.0391*Q^2+2.2581*Q+46.247","v":75.769000000000005},4500000]
["DAB","FEKA","FEKA 2700.2T",0,3,12,18,24,36,48,16.5,15.5,13.6,12.5,11.4,9,5.5,"H=-0.0007*Q^2-0.1873*Q+16.212",0.99560000000000004,null,20,{"$f":"-0.0007*Q^2-0.1873*Q+16.212","v":12.186},"",null,62,"Bridado",65,"Trifásico",2.1800000000000002,2900,400,110,"e=-0.0391*Q^2+2.2581*Q+31.247",{"$f":"-0.0391*Q^2+2.2581*Q+31.247","v":60.769000000000005},4600000]
["DAB","FEKA","FEKA 3030.4T",0,12,24,36,48,60,72,6,5.6,5.0999999999999996,4.4000000000000004,3.8,3.1,2.4,"H=-0.0002*Q^2-0.0372*Q+6.0381",0.999,null,20,{"$f":"-0.0002*Q^2-0.0372*Q+6.0381","v":5.2141000000000002},"",null,80,"Bridado",80,"Trifásico",1.8,2900,400,110,"e=-0.0153*Q^2+1.4435*Q+32.381",{"$f":"-0.0153*Q^2+1.4435*Q+32.381","v":55.131},4700000]
["DAB","FEKA","FEKA 3030.2T",0,12,18,24,36,48,60,12,9.5,8.3000000000000007,7,5,3.2,1.8,"H=0.001*Q^2-0.2315*Q+12.058",0.99970000000000003,null,20,{"$f":"0.001*Q^2-0.2315*Q+12.058","v":7.8280000000000003},"OK",null,67,"Bridado",80,"Trifásico",2.2999999999999998,2900,400,110,"e=-0.024*Q^2+1.8437*Q+36.833",{"$f":"-0.024*Q^2+1.8437*Q+36.833","v":64.106999999999999},4800000]
["DAB","FEKA","FEKA 3040.2T",0,12,18,24,36,48,60,15.4,13.2,12,10.8,8,5.4,3,"H=-0.0003*Q^2-0.1951*Q+15.505",0.99909999999999999,null,20,{"$f":"-0.0003*Q^2-0.1951*Q+15.505","v":11.483000000000001},"",null,67,"Bridado",80,"Trifásico",2.9,2900,400,110,"e=-0.024*Q^2+1.8437*Q+41.833",{"$f":"-0.024*Q^2+1.8437*Q+41.833","v":69.106999999999999},4900000]
["DAB","FEKA","FEKA 3000.2T",0,12,24,36,48,60,72,18.7,17.5,15.3,12.6,9.4,6.2,4,"H=-0.0009*Q^2-0.1506*Q+19.081",0.99429999999999996,null,20,{"$f":"-0.0009*Q^2-0.1506*Q+19.081","v":15.709},"",null,67,"Bridado",80,"Trifásico",3.6,2900,400,110,"e=-0.0153*Q^2+1.4435*Q+27.381",{"$f":"-0.0153*Q^2+1.4435*Q+27.381","v":50.131},5000000]
["DAB","FEKA","FEKA RC 3500.2T",0,12,18,24,36,48,60,28,25.5,24.3,23,20.6,18,15.6,"H=2E-06*Q^2-0.2072*Q+28",0.99990000000000001,null,20,{"$f":"0.000002*Q^2-0.2072*Q+28","v":23.8568},"",null,50,"Bridado",80,"Trifásico",4.5,2900,400,110,"e=-0.024*Q^2+1.8437*Q+31.833",{"$f":"-0.024*Q^2+1.8437*Q+31.833","v":59.106999999999992},5100000]
["DAB","FEKA","FEKA RC 3700.2T",0,12,24,36,48,60,72,32.9,29.4,26.8,24.8,22.8,20.100000000000001,16,"H=-0.0003*Q^2-0.1973*Q+32.331",0.98880000000000001,null,20,{"$f":"-0.0003*Q^2-0.1973*Q+32.331","v":28.265000000000004},"",null,50,"Bridado",80,"Trifásico",5.4,2900,400,110,"e=-0.0153*Q^2+1.4435*Q+37.381",{"$f":"-0.0153*Q^2+1.4435*Q+37.381","v":60.131},5200000]
["EBARA","DRV","DRV/A32-090-0.5M",2.4,3.6,4.8,6,9,12,null,7,6.5,6.1,5.6,4.2,2.6,null,"H=-0.0117*Q^2-0.2868*Q+7.732",0.99980000000000002,null,20,{"$f":"-0.0117*Q^2-0.2868*Q+7.732","v":-2.6840000000000002},"",null,30,"Roscado",32,"Monofásico",0.5,2900,203,110,"e=-0.8304*Q^2+14.804*Q+11.972",{"$f":"-0.8304*Q^2+14.804*Q+11.972","v":-24.10800000000004},3000000]
["EBARA","DRV","DRV/A32-090-0.5",2.4,3.6,4.8,6,9,12,null,6.8,5.9,5.4,4.8,3.2,1.6,null,"H=0.0019*Q^2-0.5568*Q+8.0302",0.99809999999999999,null,20,{"$f":"0.0019*Q^2-0.5568*Q+8.0302","v":-2.3457999999999988},"",null,30,"Roscado",32,"Trifásico",0.5,2900,203,110,"e=-0.9034*Q^2+15.575*Q+8.1338",{"$f":"-0.9034*Q^2+15.575*Q+8.1338","v":-41.726200000000013},3100000]
["EBARA","DRV","DRV/A50-120-1.1M",2.4,3.6,6,9,12,18,24,8.5,8.1,7.3,6.3,5.3,3.4,1.6,"H=0.0011*Q^2-0.3496*Q+9.3443",1,null,20,{"$f":"0.0011*Q^2-0.3496*Q+9.3443","v":2.7923},"",null,48,"Bridado",50,"Monofásico",1.1000000000000001,2900,358,110,"e=-0.1646*Q^2+5.0489*Q+36.499",{"$f":"-0.1646*Q^2+5.0489*Q+36.499","v":71.637},3200000]
["EBARA","DRV","DRV/A50-120-1.4",2.4,3.6,6,9,12,18,24,9.3000000000000007,8.9,8.1999999999999993,7.2,6.3,4.4000000000000004,2.5,"H=-0.0001*Q^2-0.3113*Q+10.041",0.99990000000000001,null,20,{"$f":"-0.0001*Q^2-0.3113*Q+10.041","v":3.7749999999999995},"",null,48,"Bridado",50,"Trifásico",1.4,2900,358,110,"e=-0.1646*Q^2+5.0489*Q+36.499",{"$f":"-0.1646*Q^2+5.0489*Q+36.499","v":71.637},3300000]
["EBARA","DRV","DRV/A50-135-1.4",2.4,6,9,12,18,24,33,11.5,10.3,9.4,8.4,6.4,4.5,1.4,"H=-0.0004*Q^2-0.3151*Q+12.24",0.99990000000000001,null,20,{"$f":"-0.0004*Q^2-0.3151*Q+12.24","v":5.7780000000000005},"",null,48,"Bridado",50,"Trifásico",1.4,2900,358,110,"e=-0.0858*Q^2+3.6368*Q+36.26",{"$f":"-0.0858*Q^2+3.6368*Q+36.26","v":74.676000000000002},3400000]
["EBARA","DRV","DRV/A50-130-1.1M",2.4,6,9,12,18,24,33,10.5,9.8000000000000007,9,8.1,6.2,4.3,1.2,"H=-0.0021*Q^2-0.2352*Q+11.194",0.99939999999999996,null,20,{"$f":"-0.0021*Q^2-0.2352*Q+11.194","v":5.6500000000000012},"",null,50,"Bridado",50,"Monofásico",1.1000000000000001,2900,339,110,"e=-0.1196*Q^2+5.229*Q+16.776",{"$f":"-0.1196*Q^2+5.229*Q+16.776","v":73.516000000000005},3500000]
["EBARA","DRV","DRV/A50-140-1.8M",2.4,6,9,12,18,24,36,12,11,10.199999999999999,9.4,6.8,5.8,1,"H=-0.0015*Q^2-0.2667*Q+12.661",0.99390000000000001,null,20,{"$f":"-0.0015*Q^2-0.2667*Q+12.661","v":6.7270000000000003},"OK",null,50,"Bridado",50,"Monofásico",1.8,2900,339,110,"e=-0.0571*Q^2+2.638*Q+39.338",{"$f":"-0.0571*Q^2+2.638*Q+39.338","v":69.257999999999996},3600000]
["EBARA","DRV","DRV/A50-155-1.8M",2.4,6,9,12,18,24,36,14,12.7,11.8,10.5,8.5,6.4,3,"H=0.0016*Q^2-0.3921*Q+15.013",0.99929999999999997,null,20,{"$f":"0.0016*Q^2-0.3921*Q+15.013","v":7.8109999999999991},"OK",null,50,"Bridado",50,"Monofásico",1.8,2900,339,110,"e=-0.0708*Q^2+3.2442*Q+37.989",{"$f":"-0.0708*Q^2+3.2442*Q+37.989","v":74.552999999999997},3700000]
["EBARA","DRV","DRV/A50-140-1.4",2.4,6,9,12,18,24,36,12.2,11.5,10.6,9.9,8,6,1,"H=-0.0037*Q^2-0.1931*Q+12.71",0.99980000000000002,null,20,{"$f":"-0.0037*Q^2-0.1931*Q+12.71","v":7.3680000000000003},"OK",null,50,"Bridado",50,"Trifásico",1.4,2900,339,110,"e=-0.0571*Q^2+2.638*Q+39.338",{"$f":"-0.0571*Q^2+2.638*Q+39.338","v":69.257999999999996},3800000]
["EBARA","DRV","DRV/A50-155-2.4",2.4,6,9,12,18,24,36,14.6,13.4,12.4,11.6,9.5,7.7,3.6,"H=-0.0004*Q^2-0.3115*Q+15.308",0.99970000000000003,null,20,{"$f":"-0.0004*Q^2-0.3115*Q+15.308","v":8.9179999999999993},"",null,50,"Bridado",50,"Trifásico",2.4,2900,339,110,"e=-0.0763*Q^2+3.0947*Q+39.356",{"$f":"-0.0763*Q^2+3.0947*Q+39.356","v":70.72999999999999},3900000]
["EBARA","DRV","DRV/A65-108-1.9M",6,12,18,24,30,36,48,9.1999999999999993,7.8,6.5,5,3.9,2.8,1,"H=0.0014*Q^2-0.2744*Q+10.851",0.99939999999999996,null,20,{"$f":"0.0014*Q^2-0.2744*Q+10.851","v":5.9230000000000009},"",null,65,"Bridado",65,"Monofásico",1.9,2900,367,110,"e=-0.0417*Q^2+2.7497*Q+27.769",{"$f":"-0.0417*Q^2+2.7497*Q+27.769","v":66.082999999999998},4000000]
["EBARA","DRV","DRV/A65-108-2.3",6,12,18,24,30,36,48,9.4,7.9,6.4,5.0999999999999996,3.9,2.9,1,"H=0.0016*Q^2-0.286*Q+11.064",0.99990000000000001,null,20,{"$f":"0.0016*Q^2-0.286*Q+11.064","v":5.984},"",null,65,"Bridado",65,"Trifásico",2.2999999999999998,2900,367,110,"e=-0.0335*Q^2+2.2237*Q+31.136",{"$f":"-0.0335*Q^2+2.2237*Q+31.136","v":62.210000000000008},4100000]
["EBARA","DRV","DRV/A65-119-2.3",6,12,18,24,30,36,48,10.8,9.1999999999999993,7.6,6.3,4.8,3.5,1.3,"H=0.0012*Q^2-0.2938*Q+12.532",0.99970000000000003,null,20,{"$f":"0.0012*Q^2-0.2938*Q+12.532","v":7.1359999999999992},"OK",null,65,"Bridado",65,"Trifásico",2.2999999999999998,2900,367,110,"e=-0.0417*Q^2+2.7497*Q+27.769",{"$f":"-0.0417*Q^2+2.7497*Q+27.769","v":66.082999999999998},4200000]
["EBARA","DRV","DRV/A65-105-3.2",6,12,18,30,42,54,60,11.5,10,8.8000000000000007,6.6,4.3,2.2999999999999998,1.2,"H=0.0005*Q^2-0.2211*Q+12.695",0.99950000000000006,null,20,{"$f":"0.0005*Q^2-0.2211*Q+12.695","v":8.4730000000000008},"",null,65,"Bridado",65,"Trifásico",3.2,2900,399,110,"e=-0.034*Q^2+2.4213*Q+30.195",{"$f":"-0.034*Q^2+2.4213*Q+30.195","v":65.021000000000001},4300000]
["EBARA","DRV","DRV/A65-112-4.1",6,12,18,30,42,54,60,14.3,13.1,11.9,9.6,7.5,5.9,3.6,"H=-0.0001*Q^2-0.1798*Q+15.274",0.99219999999999997,null,20,{"$f":"-0.0001*Q^2-0.1798*Q+15.274","v":11.638},"",null,65,"Bridado",65,"Trifásico",4.0999999999999996,2900,426,110,"e=-0.0211*Q^2+1.6968*Q+35.037",{"$f":"-0.0211*Q^2+1.6968*Q+35.037","v":60.533000000000001},4400000]
["EBARA","DRV","DRV/A80-155-1.8M",6,12,18,24,30,36,48,8,7.1,6.1,5.3,4.3,3.5,1.9,"H=0.0004*Q^2-0.1664*Q+9.0062",0.99960000000000004,null,20,{"$f":"0.0004*Q^2-0.1664*Q+9.0062","v":5.8382000000000005},"",null,60,"Bridado",80,"Monofásico",1.8,2900,418,110,"e=-0.0417*Q^2+2.7497*Q+27.769",{"$f":"-0.0417*Q^2+2.7497*Q+27.769","v":66.082999999999998},4500000]
["EBARA","DRV","DRV/A80-155-2.4",6,12,18,24,30,36,48,8,7.1,6.1,5.3,4.3,3.5,1.9,"H=0.0004*Q^2-0.1664*Q+9.0062",0.99960000000000004,null,20,{"$f":"0.0004*Q^2-0.1664*Q+9.0062","v":5.8382000000000005},"",null,60,"Bridado",80,"Trifásico",2.4,2900,418,110,"e=-0.0335*Q^2+2.2237*Q+31.136",{"$f":"-0.0335*Q^2+2.2237*Q+31.136","v":62.210000000000008},4600000]
["EBARA","DRV","DRV/A80-145-3.2",6,12,18,30,42,54,60,14,12.2,11,8,5.5,2.5,1.5,"H=0.0004*Q^2-0.2572*Q+15.422",0.999,null,{"$f":"Q","v":20},{"$f":"0.0004*Q^2-0.2572*Q+15.422","v":10.438000000000001},{"$f":"IF(AND(V100>H-1,V100<H+1,V100>Q100),\"OK\",\"\")","v":""},null,50,"Bridado",80,"Trifásico",3.2,2900,447,110,"e=-0.034*Q^2+2.4213*Q+30.195",{"$f":"-0.034*Q^2+2.4213*Q+30.195","v":65.021000000000001},4700000]
["EBARA","DRV","DRV/A80-155-3.2",6,12,18,30,42,54,60,16.5,14,13,9.8000000000000007,7,4,2.5,"H=0.0004*Q^2-0.2799*Q+17.817",0.99739999999999995,null,20,{"$f":"0.0004*Q^2-0.2799*Q+17.817","v":12.379000000000001},"",null,50,"Bridado",80,"Trifásico",3.2,2900,447,110,"e=-0.026*Q^2+2.088*Q+32.673",{"$f":"-0.026*Q^2+2.088*Q+32.673","v":64.033000000000015},4800000]
["EBARA","DRV","DRV/A80-185-7.4",15,24,30,36,42,48,54,25.5,23.6,22.3,20.9,19.5,18,16.5,"H=-0.0007*Q^2-0.1833*Q+28.404",1,null,20,{"$f":"-0.0007*Q^2-0.1833*Q+28.404","v":24.457999999999998},"",null,70,"Bridado",80,"Trifásico",7.4,2900,565,110,"e=-0.0439*Q^2+3.672*Q-5.1804",{"$f":"-0.0439*Q^2+3.672*Q-5.1804","v":50.699599999999997},4900000]
["EBARA","DRV","DRV/A80-200-18.2",15,24,30,36,42,48,54,44,42.5,41,40,38,37.5,35.5,"H=-0.0008*Q^2-0.1596*Q+46.639",0.99070000000000003,null,20,{"$f":"-0.0008*Q^2-0.1596*Q+46.639","v":43.127000000000002},"",null,50,"Bridado",80,"Trifásico",18.2,2900,630,110,"e=-0.0361*Q^2+3.0251*Q+3.5407",{"$f":"-0.0361*Q^2+3.0251*Q+3.5407","v":49.602700000000006},5000000]
["EBARA","DRV","DRV/A65-145-1.0M",15,24,30,36,42,null,null,4.8,3.5,2.7,1.9,0.8,null,null,"H=-0.0006*Q^2-0.1091*Q+6.5529",0.99809999999999999,null,20,{"$f":"-0.0006*Q^2-0.1091*Q+6.5529","v":4.1309000000000005},"",null,50,"Bridado",65,"Monofásico",1,2900,383,110,"e=-0.0421*Q^2+3.5728*Q-3.9927",{"$f":"-0.0421*Q^2+3.5728*Q-3.9927","v":50.6233},5100000]
["EBARA","DRV","DRV/A65-165-1.0M",15,24,30,36,42,48,null,6.1,4.8,3.8,2.7,1.8,0.5,null,"H=-0.0009*Q^2-0.1138*Q+8.0069",0.999,null,20,{"$f":"-0.0009*Q^2-0.1138*Q+8.0069","v":5.3709000000000007},"",null,50,"Bridado",65,"Monofásico",1,2900,383,110,"e=-0.0632*Q^2+4.6806*Q-16.886",{"$f":"-0.0632*Q^2+4.6806*Q-16.886","v":51.445999999999998},5200000]
["EBARA","DRV","DRV/A65-182-1.2M",15,24,30,36,42,48,null,7.2,5.8,4.7,3.9,2.5,1.3,null,"H=-0.0011*Q^2-0.107*Q+9.0353",0.998,null,20,{"$f":"-0.0011*Q^2-0.107*Q+9.0353","v":6.4552999999999994},"OK",null,50,"Bridado",65,"Monofásico",1.2,2900,383,110,"e=-0.0433*Q^2+3.6355*Q-4.7224",{"$f":"-0.0433*Q^2+3.6355*Q-4.7224","v":50.667599999999993},5300000]
["EBARA","DRV","DRV/A65-145-1.1",15,24,30,36,42,null,null,4.8,3.5,2.7,1.9,0.8,null,null,"H=-0.0006*Q^2-0.1091*Q+6.5529",0.99809999999999999,null,20,{"$f":"-0.0006*Q^2-0.1091*Q+6.5529","v":4.1309000000000005},"",null,50,"Bridado",65,"Trifásico",1,2900,383,110,"e=-0.0353*Q^2+2.9931*Q+3.8363",{"$f":"-0.0353*Q^2+2.9931*Q+3.8363","v":49.578300000000006},5400000]
["EBARA","DRV","DRV/A65-165-1.1",15,24,30,36,42,48,null,6.1,4.8,3.8,2.7,1.8,0.5,null,"H=-0.0009*Q^2-0.1138*Q+8.0069",0.999,null,20,{"$f":"-0.0009*Q^2-0.1138*Q+8.0069","v":5.3709000000000007},"",null,50,"Bridado",65,"Trifásico",1,2900,383,110,"e=-0.0433*Q^2+3.6355*Q-4.7224",{"$f":"-0.0433*Q^2+3.6355*Q-4.7224","v":50.667599999999993},5500000]
["EBARA","DRV","DRV/A65-182-1.4",15,24,30,36,42,48,null,7.2,5.8,4.7,3.9,2.5,1.3,null,"H=-0.0011*Q^2-0.107*Q+9.0353",0.998,null,20,{"$f":"-0.0011*Q^2-0.107*Q+9.0353","v":6.4552999999999994},"OK",null,50,"Bridado",65,"Trifásico",1.3,2900,383,110,"e=-0.0632*Q^2+4.6806*Q-16.886",{"$f":"-0.0632*Q^2+4.6806*Q-16.886","v":51.445999999999998},5600000]
["EBARA","DRV","DRV/A80-165-1.0M",15,24,30,36,42,48,54,5.8,4.8,4.2,3.7,2.9,2.1,1.5,"H=-0.0003*Q^2-0.0879*Q+7.1643",0.99770000000000003,null,20,{"$f":"-0.0003*Q^2-0.0879*Q+7.1643","v":5.2862999999999998},"",null,50,"Bridado",80,"Monofásico",1,2900,418,110,"e=-0.0439*Q^2+3.672*Q-5.1804",{"$f":"-0.0439*Q^2+3.672*Q-5.1804","v":50.699599999999997},5700000]
["EBARA","DRV","DRV/A80-165-1.4",15,24,30,36,42,48,54,5.8,4.8,4.2,3.7,2.9,2.1,1.5,"H=-0.0003*Q^2-0.0879*Q+7.1643",0.99770000000000003,null,20,{"$f":"-0.0003*Q^2-0.0879*Q+7.1643","v":5.2862999999999998},"",null,50,"Bridado",80,"Trifásico",1.4,2900,418,110,"e=-0.0361*Q^2+3.0251*Q+3.5407",{"$f":"-0.0361*Q^2+3.0251*Q+3.5407","v":49.602700000000006},5800000]
["EBARA","DRV","DRV/A80-182-1.2M",15,24,30,36,42,48,60,6.7,5.9,5.3,4.4000000000000004,3.9,3.1,1.8,"H=-0.0002*Q^2-0.0961*Q+8.2481",0.99719999999999998,null,20,{"$f":"-0.0002*Q^2-0.0961*Q+8.2481","v":6.2461000000000002},"OK",null,50,"Bridado",80,"Monofásico",1.2,2900,418,110,"e=-0.0354*Q^2+3.1694*Q+1.2717",{"$f":"-0.0354*Q^2+3.1694*Q+1.2717","v":50.499699999999997},5900000]
["EBARA","DRV","DRV/A80-182-1.4",15,24,30,36,42,48,60,6.7,5.9,5.3,4.4000000000000004,3.9,3.1,1.8,"H=-0.0002*Q^2-0.0961*Q+8.2481",0.99719999999999998,null,20,{"$f":"-0.0002*Q^2-0.0961*Q+8.2481","v":6.2461000000000002},"OK",null,50,"Bridado",80,"Trifásico",1.4,2900,418,110,"e=-0.0432*Q^2+3.4993*Q-1.6942",{"$f":"-0.0432*Q^2+3.4993*Q-1.6942","v":51.011799999999987},6000000]

{"sheet":"APU","index":10,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,8,0,14],[0,16,0,18],[0,0,0,6]]}
["SUMINISTROS",null,null,null,null,null,null,null,"INSTALACIÓN",null,null,null,null,null,null,null,"VÁLVULAS"]
["Ítem","PVC","GRP","CCP","PEAD","ACERO","HD",null,"Ítem","PVC","GRP","CCP","PEAD","ACERO","HD",null,"ITEM","SUMINISTRO","INSTALACIÓN"]
[1,2,3,4,5,6,7,null,1,2,3,4,5,6,7,null,"Válvula de globo 1.25\"",1000,2000]
["Tubería 1.25\"",10000,2000,3000,4000,5000,6000,null,"Tubería 1.25\"",10000,2000,3000,4000,5000,6000,null,"Válvula de globo 1.5\"",{"$f":"R3+1","v":1001},{"$f":"S3+1","v":2001}]
["Tubería 1.5\"",{"$f":"B4+1","v":10001},{"$f":"C4+1","v":2001},{"$f":"D4+1","v":3001},{"$f":"E4+1","v":4001},{"$f":"F4+1","v":5001},{"$f":"G4+1","v":6001},null,"Tubería 1.5\"",{"$f":"J4+1","v":10001},{"$f":"K4+1","v":2001},{"$f":"L4+1","v":3001},{"$f":"M4+1","v":4001},{"$f":"N4+1","v":5001},{"$f":"O4+1","v":6001},null,"Válvula de globo 2\"",{"$f":"R4+1","v":1002},{"$f":"S4+1","v":2002}]
["Tubería 2\"",10002,2002,3002,4002,5002,{"$f":"G5+1","v":6002},null,"Tubería 2\"",10002,2002,3002,4002,5002,{"$f":"O5+1","v":6002},null,"Válvula de globo 2.5\"",1003,2003]
["Tubería 2.5\"",10003,2003,3003,4003,5003,6003,null,"Tubería 2.5\"",10003,2003,3003,4003,5003,6003,null,"Válvula de globo 3\"",1004,2004]
["Tubería 3\"",10004,2004,3004,4004,5004,6004,null,"Tubería 3\"",10004,2004,3004,4004,5004,6004,null,"Válvula de globo 4\"",1005,2005]
["Tubería 4\"",10005,2005,3005,4005,5005,6005,null,"Tubería 4\"",10005,2005,3005,4005,5005,6005,null,"Válvula de mariposa 1.25\"",1006,2006]
["Codo 90 radio corto 1.25\"",10006,2006,3006,4006,5006,6006,null,"Codo 90 radio corto 1.25\"",10006,2006,3006,4006,5006,6006,null,"Válvula de mariposa 1.5\"",1007,2007]
["Codo 90 radio corto 1.5\"",10007,2007,3007,4007,5007,6007,null,"Codo 90 radio corto 1.5\"",10007,2007,3007,4007,5007,6007,null,"Válvula de mariposa 2\"",1008,2008]
["Codo 90 radio corto 2\"",10008,2008,3008,4008,5008,6008,null,"Codo 90 radio corto 2\"",10008,2008,3008,4008,5008,6008,null,"Válvula de mariposa 2.5\"",1009,2009]
["Codo 90 radio corto 2.5\"",10009,2009,3009,4009,5009,6009,null,"Codo 90 radio corto 2.5\"",10009,2009,3009,4009,5009,6009,null,"Válvula de mariposa 3\"",1010,2010]
["Codo 90 radio corto 3\"",10010,2010,3010,4010,5010,6010,null,"Codo 90 radio corto 3\"",10010,2010,3010,4010,5010,6010,null,"Válvula de mariposa 4\"",1011,2011]
["Codo 90 radio corto 4\"",10011,2011,3011,4011,5011,6011,null,"Codo 90 radio corto 4\"",10011,2011,3011,4011,5011,6011,null,"Válvula de Cheque 1.25\"",1012,2012]
["Codo 90 radio medio 1.25\"",10012,2012,3012,4012,5012,6012,null,"Codo 90 radio medio 1.25\"",10012,2012,3012,4012,5012,6012,null,"Válvula de Cheque 1.5\"",1013,2013]
["Codo 90 radio medio 1.5\"",10013,2013,3013,4013,5013,6013,null,"Codo 90 radio medio 1.5\"",10013,2013,3013,4013,5013,6013,null,"Válvula de Cheque 2\"",1014,2014]
["Codo 90 radio medio 2\"",10014,2014,3014,4014,5014,6014,null,"Codo 90 radio medio 2\"",10014,2014,3014,4014,5014,6014,null,"Válvula de Cheque 2.5\"",1015,2015]
["Codo 90 radio medio 2.5\"",10015,2015,3015,4015,5015,6015,null,"Codo 90 radio medio 2.5\"",10015,2015,3015,4015,5015,6015,null,"Válvula de Cheque 3\"",1016,2016]
["Codo 90 radio medio 3\"",10016,2016,3016,4016,5016,6016,null,"Codo 90 radio medio 3\"",10016,2016,3016,4016,5016,6016,null,"Válvula de Cheque 4\"",1017,2017]
["Codo 90 radio medio 4\"",10017,2017,3017,4017,5017,6017,null,"Codo 90 radio medio 4\"",10017,2017,3017,4017,5017,6017,null,"Válvula de compuerta 1.25\"",1018,2018]
["Codo 90 gran radio 1.25\"",10018,2018,3018,4018,5018,6018,null,"Codo 90 gran radio 1.25\"",10018,2018,3018,4018,5018,6018,null,"Válvula de compuerta 1.5\"",1019,2019]
["Codo 90 gran radio 1.5\"",10019,2019,3019,4019,5019,6019,null,"Codo 90 gran radio 1.5\"",10019,2019,3019,4019,5019,6019,null,"Válvula de compuerta 2\"",1020,2020]
["Codo 90 gran radio 2\"",10020,2020,3020,4020,5020,6020,null,"Codo 90 gran radio 2\"",10020,2020,3020,4020,5020,6020,null,"Válvula de compuerta 2.5\"",1021,2021]
["Codo 90 gran radio 2.5\"",10021,2021,3021,4021,5021,6021,null,"Codo 90 gran radio 2.5\"",10021,2021,3021,4021,5021,6021,null,"Válvula de compuerta 3\"",1022,2022]
["Codo 90 gran radio 3\"",10022,2022,3022,4022,5022,6022,null,"Codo 90 gran radio 3\"",10022,2022,3022,4022,5022,6022,null,"Válvula de compuerta 4\"",1023,2023]
["Codo 90 gran radio 4\"",10023,2023,3023,4023,5023,6023,null,"Codo 90 gran radio 4\"",10023,2023,3023,4023,5023,6023]
["Codo 45 1.25\"",10024,2024,3024,4024,5024,6024,null,"Codo 45 1.25\"",10024,2024,3024,4024,5024,6024]
["Codo 45 1.5\"",10025,2025,3025,4025,5025,6025,null,"Codo 45 1.5\"",10025,2025,3025,4025,5025,6025]
["Codo 45 2\"",10026,2026,3026,4026,5026,6026,null,"Codo 45 2\"",10026,2026,3026,4026,5026,6026]
["Codo 45 2.5\"",10027,2027,3027,4027,5027,6027,null,"Codo 45 2.5\"",10027,2027,3027,4027,5027,6027]
["Codo 45 3\"",10028,2028,3028,4028,5028,6028,null,"Codo 45 3\"",10028,2028,3028,4028,5028,6028]
["Codo 45 4\"",10029,2029,3029,4029,5029,6029,null,"Codo 45 4\"",10029,2029,3029,4029,5029,6029]
["Tee 1.25\"",10030,2030,3030,4030,5030,6030,null,"Tee 1.25\"",10030,2030,3030,4030,5030,6030]
["Tee 1.5\"",10031,2031,3031,4031,5031,6031,null,"Tee 1.5\"",10031,2031,3031,4031,5031,6031]
["Tee 2\"",10032,2032,3032,4032,5032,6032,null,"Tee 2\"",10032,2032,3032,4032,5032,6032]
["Tee 2.5\"",10033,2033,3033,4033,5033,6033,null,"Tee 2.5\"",10033,2033,3033,4033,5033,6033]
["Tee 3\"",10034,2034,3034,4034,5034,6034,null,"Tee 3\"",10034,2034,3034,4034,5034,6034]
["Tee 4\"",10035,2035,3035,4035,5035,6035,null,"Tee 4\"",10035,2035,3035,4035,5035,6035]
["Uniones 1.25\"",10036,2036,3036,4036,5036,6036,null,"Uniones 1.25\"",10036,2036,3036,4036,5036,6036]
["Uniones 1.5\"",10037,2037,3037,4037,5037,6037,null,"Uniones 1.5\"",10037,2037,3037,4037,5037,6037]
["Uniones 2\"",10038,2038,3038,4038,5038,6038,null,"Uniones 2\"",10038,2038,3038,4038,5038,6038]
["Uniones 2.5\"",10039,2039,3039,4039,5039,6039,null,"Uniones 2.5\"",10039,2039,3039,4039,5039,6039]
["Uniones 3\"",10040,2040,3040,4040,5040,6040,null,"Uniones 3\"",10040,2040,3040,4040,5040,6040]
["Uniones 4\"",10041,2041,3041,4041,5041,6041,null,"Uniones 4\"",10041,2041,3041,4041,5041,6041]
["Yee 1.25\"",10042,2042,3042,4042,5042,6042,null,"Yee 1.25\"",10042,2042,3042,4042,5042,6042]
["Yee 1.5\"",10043,2043,3043,4043,5043,6043,null,"Yee 1.5\"",10043,2043,3043,4043,5043,6043]
["Yee 2\"",10044,2044,3044,4044,5044,6044,null,"Yee 2\"",10044,2044,3044,4044,5044,6044]
["Yee 2.5\"",10045,2045,3045,4045,5045,6045,null,"Yee 2.5\"",10045,2045,3045,4045,5045,6045]
["Yee 3\"",10046,2046,3046,4046,5046,6046,null,"Yee 3\"",10046,2046,3046,4046,5046,6046]
["Yee 4\"",10047,2047,3047,4047,5047,6047,null,"Yee 4\"",10047,2047,3047,4047,5047,6047]