{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["informacion tecnica","SECTORIZACION ","Tazas","Pivotes","Enrollador","CALCULADORA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"informacion tecnica","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["BUSCARV","O.D.","Espesor","I.D.","Velocidad","O.D.","Espesor","I.D."]
[{"$f":"MIN(IF(A3:A20<>0, A3:A20))","v":110},"mm","mm","mm","m/s","mm","mm","mm","-"]
[{"$f":" IF(AND(E3<2,E3>1),B3,0)","v":0},20,"-","-","-",76,0.7,{"$f":"+F3-2*G3","v":74.599999999999994},"TUBO GALVANIZADO HK 76 BAUER "]
[{"$f":" IF(AND(E4<2,E4>1),B4,0)","v":0},25,"-","-","-",89,0.7,87.6,"TUBO GALVANIZADO HK 89 BAUER "]
[0,32,1.8,{"$f":"+B5-2*C5","v":28.4},{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D5/1000)^2)","v":16.882302092392298},108,0.85,106.3,"TUBO GALVANIZADO HK 108 BAUER "]
[0,40,2.1,{"$f":"+B6-2*C6","v":35.799999999999997},{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D6/1000)^2)","v":10.624348159888839},133,1,131,"TUBO GALVANIZADO HK 133 BAUER "]
[0,50,2.7,44.6,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D7/1000)^2)","v":6.845396838685641},159,1,157,"TUBO GALVANIZADO HK 159 BAUER "]
[0,63,3.3,56.4,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D8/1000)^2)","v":4.2806541344876798},194,1.1000000000000001,191.8,"TUBO GALVANIZADO HK 194 BAUER "]
[0,75,3.9,67.2,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D9/1000)^2)","v":3.0152949563403326},null,null,null,"PE100 Ø160 PN10 HDPE PIPE"]
[0,90,4.7,80.599999999999994,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D10/1000)^2)","v":2.0960337135934481},null,null,null,"PE100 Ø140 PN10 HDPE PIPE"]
[110,110,4.5999999999999996,100.8,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D11/1000)^2)","v":1.3401310917068148},null,null,null,"PE100 Ø125 PN10 HDPE PIPE"]
[125,125,5.2,114.6,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D12/1000)^2)","v":1.0368098443664686},null,null,null,"PE100 Ø110 PN10 HDPE PIPE"]
[0,140,5.8,128.4,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D13/1000)^2)","v":0.82592060294202829}]
[0,160,6.7,146.6,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D14/1000)^2)","v":0.63357846408729412}]
[0,180,7.4,165.2,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D15/1000)^2)","v":0.49893992957541855}]
[0,200,8.1999999999999993,183.6,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D16/1000)^2)","v":0.40394570392085466}]
[0,250,10.199999999999999,229.6,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D17/1000)^2)","v":0.25830010333908859}]
[0,315,12.9,289.2,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D18/1000)^2)","v":0.16280651130461396}]
[0,355,14.4,326.2,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D19/1000)^2)","v":0.12796772052180236}]
[{"$f":" IF(AND(E20<2,E20>1),B20,0)","v":0},400,16.2,367.6,{"$f":"(MAX('SECTORIZACION '!$N$7:$N$21 )/3600)/(PI()/4*(D20/1000)^2)","v":0.10076677095881713}]

{"sheet":"SECTORIZACION ","index":1,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[[24,0,24,1],[4,16,4,17],[2,0,2,4]]}
[]
["Nombre Proyecto"]
["Matias Leon"]
[]
["Nº ","CULTIVO","Informacion","AREA PROYECTO","AREA SECTOR","  DISTRIBUCION PLANTAS",null,"LINEAS DE RIEGO","ESPC. EMISOR","DESC. EMISOR","PRECIPITACION","LAMINA A REPONER","TIEMPO RIEGO","CAUDAL","CAUDAL","Ø TUBERIA ESTIM. ","CUBICACION ",null,"PLANTAS","Tiempo"]
["SECTORES",null,null,"HA","HA","                      M       x       M",null,null,"M","L/H","MM/H","MM","HR","M3/H","LPS","MM","N° EMISORES","M LINEA",null,"H"]
[3,"Frutilla",null,0.68,{"$f":"IFERROR(D7/A7,\"\")","v":0.22666666666666668},0.8,0.3,1,0.2,2.2000000000000002,{"$f":"IFERROR((G7/I7*J7*H7)/(F7*G7),\"\")","v":13.75},5,{"$f":"IFERROR((L7/K7)*A7,\"\")","v":1.0909090909090908},{"$f":"IFERROR(1*((E7*10000)/ ((F7/H7)*I7)*J7/1000),\"\")","v":31.166666666666668},{"$f":"IFERROR(N7/3.6,\"\")","v":8.6574074074074083},{"$f":"IF(O7<>\"\",'informacion tecnica'!$A$2,\"\")","v":110},{"$f":"IFERROR((((E7/1)*10000)/(F7/H7*I7))*1,\"\")","v":14166.666666666666},{"$f":"IFERROR((((E7/1)*10000)/(F7/H7*I7))*I7,\"\")","v":2833.3333333333335},{"$f":"IFERROR(((E7/1)*10000)/(F7*G7),\"\")","v":9444.4444444444453},{"$f":"IFERROR(M7,\"\")","v":1.0909090909090908},{"$f":"IFERROR(A7*Q7,\"\")","v":42500},{"$f":"IFERROR(A7*R7,\"\")","v":8500},{"$f":"IFERROR(A7*S7,\"\")","v":28333.333333333336}]
[3,"Frutilla",null,0.64,{"$f":"IFERROR(D8/A8,\"\")","v":0.21333333333333335},0.8,0.3,1,0.2,2.2000000000000002,{"$f":"IFERROR((G8/I8*J8*H8)/(F8*G8),\"\")","v":13.75},5,{"$f":"IFERROR((L8/K8)*A8,\"\")","v":1.0909090909090908},{"$f":"IFERROR(1*((E8*10000)/ ((F8/H8)*I8)*J8/1000),\"\")","v":29.333333333333332},{"$f":"IFERROR(N8/3.6,\"\")","v":8.148148148148147},{"$f":"IF(O8<>\"\",'informacion tecnica'!$A$2,\"\")","v":110},{"$f":"IFERROR((((E8/A8)*10000)/(F8/H8*I8))*1*1.02,\"\")","v":4533.3333333333321},{"$f":"IFERROR((((E8/A8)*10000)/(F8/H8*I8))*I8*1.02,\"\")","v":906.66666666666652},{"$f":"IFERROR(((E8/1)*10000)/(F8*G8),\"\")","v":8888.8888888888905},{"$f":"IFERROR(M8,\"\")","v":1.0909090909090908},{"$f":"IFERROR(A8*Q8,\"\")","v":13599.999999999996},{"$f":"IFERROR(A8*R8,\"\")","v":2719.9999999999995},{"$f":"IFERROR(A8*S8,\"\")","v":26666.666666666672}]
[3,"Frutilla",null,0.84,0.27999999999999997,0.8,0.3,1,0.2,2.2000000000000002,13.75,5,1.0909090909090908,38.499999999999986,10.694444444444441,{"$f":"IF(O9<>\"\",'informacion tecnica'!$A$2,\"\")","v":110},5949.9999999999991,1189.9999999999998,11666.666666666666,1.0909090909090908,17849.999999999996,3569.9999999999991,35000]
[null,null,null,null,"",null,null,null,null,null,"",null,{"$f":"IFERROR(L10/K10,\"\")","v":""},"","",{"$f":"IF(O10<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O11<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O12<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O13<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O14<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O15<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O16<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O17<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O18<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O19<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O20<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[null,null,null,null,"",null,null,null,null,null,"",null,"","","",{"$f":"IF(O21<>\"\",'informacion tecnica'!$A$2,\"\")","v":""},"","","","","","",""]
[{"$f":"SUM(A7:A21)","v":9},null,"TOTAL",{"$f":"_xlfn.AGGREGATE(9,6,D7:D21)","v":2.16},"HA",null,null,null,null,null,null,"TOTAL",{"$f":"_xlfn.AGGREGATE(9,6,T7:T21)","v":3.2727272727272725},"HR-DIA",null,"TOTAL ",{"$f":"_xlfn.AGGREGATE(9,6,U7:U21)","v":73950},{"$f":"_xlfn.AGGREGATE(9,6,V7:V21)","v":14790},{"$f":"_xlfn.AGGREGATE(9,6,W7:W21)","v":90000}]
["NOTA: Esta planilla es para uso personal o profesional. Un adecuado criterio ingenieril debe primar siempre al momento de interpretar y/o aplicar los resultados obtenidos."]
[]
["Summary",null,null,null,null,"Pump"]
[null,"Area","Flow",null,null,"Caudal","Presion","Eficiencia","Pot. Abs","Pot. Max","Pot. Motor","Reserva de"]
["#","HA","M3/H",null,null,"M3/H","M.C.A.","55%-85%","KW","HP","HP comercial","Potencia"]
[1,3.28,80,null,null,37,39,0.8,{"$f":"IFERROR(0.736*((1000*F28/3600*G28)/(75*H28)),0)","v":4.9168888888888898},{"$f":"1.25*I28/0.745","v":8.2498135719612247},7.5,{"$f":"IFERROR((K28*0.745-I28)/I28,0)","v":0.13638931573714169}]
[2,3.28,83.3,null,null,"NOTA: Reserva de potencia Norma ISO 5199. "]
[3,3.04,77.2]
[4,2.56,65]
[5,2.56,65]
[6,0,0]
[7,0,0]
[8,0,0]
[9,0,0]
[10,0,0]
[]
[null,{"$f":"SUM(B28:B38)","v":14.72},null,null,null,null,null,null,null,null,null,"Desarrollado por Boris Torres  | Ingeniero Civil Agricola | Email btorres@sewingenieria.cl | Tel. Móvil +56 9 6594 1162"]

{"sheet":"Tazas","index":2,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[21,1,21,3],[25,3,25,5],[2,0,2,4],[12,1,12,3],[12,6,12,8],[13,1,13,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[5,1,5,3],[11,1,11,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[10,1,10,3],[9,1,9,3]]}
[]
["Nombre Proyecto",null,null,null,null,null,null,null,null,null,null,null,"Rotator® R2000WF/R2000LP"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MagicDrive"]
[]
["ANTECEDENTES "]
["Aspersor","Rotator® R2000WF/R2000LP",null,null,null,null,null,null,null,null,null,null,"R2000LP  #14 GREEN  GREEN  MR40PSI"]
["Distribucion CUADRADA",15,null,null,"M",null,null,null,null,null,null,null,"R2000LP  #16 RED  RED  MR35PSI"]
["CONFIGURACION","R2000WF  #16 RED  RED  MR40PSI",null,null,null,null,null,null,null,null,null,null,"R2000LP  #18 GOLD  GOLD  MR35PSI"]
["Caudal Aspersor",{"$f":"IF(B8=\"R2000LP  #14 GREEN  GREEN  MR40PSI\",517.84,IF(B8=\"R2000LP  #16 RED  RED  MR35PSI\",613.24,IF(B8=\"R2000LP  #18 GOLD  GOLD  MR35PSI\",781.31,IF(B8=\"R2000LP  #16 RED  RED  MR40PSI\",656.39,IF(B8=\"R2000WF  #16 RED  RED  MR40PSI\",656.39,IF(B8=\"R2000WF  #18 GOLD  GOLD  MR40PSI\",835.82,IF(B8=\"ROTOR AZUL 24° BOQUILLA ROJA 3.2MM MPR40PSI\",651.93,IF(B8=\"ROTOR AZUL 24° BOQUILLA ROJA 3.2MM MPR35PSI\",600.19))))))))","v":656.39},null,null,"LPH",null,null,null,null,null,null,null,"R2000LP  #16 RED  RED  MR40PSI"]
["Radio Aspersor",{"$f":"IF(B8=\"R2000LP  #14 GREEN  GREEN  MR40PSI\",11,IF(B8=\"R2000LP  #16 RED  RED  MR35PSI\",10.36,IF(B8=\"R2000LP  #18 GOLD  GOLD  MR35PSI\",12.19,IF(B8=\"R2000LP  #16 RED  RED  MR40PSI\",10.36,IF(B8=\"R2000WF  #16 RED  RED  MR40PSI\",12.8,IF(B8=\"R2000WF  #18 GOLD  GOLD  MR40PSI\",12.8,IF(B8=\"ROTOR AZUL 24° BOQUILLA ROJA 3.2MM MPR40PSI\",11.5,IF(B8=\"ROTOR AZUL 24° BOQUILLA ROJA 3.2MM MPR35PSI\",11.5))))))))","v":12.8},null,null,"M",null,null,null,null,null,null,null,"R2000WF  #16 RED  RED  MR40PSI"]
["Emisores ",{"$f":"214+173+127","v":514},null,null,null,null,null,null,null,null,null,null,"R2000WF  #18 GOLD  GOLD  MR40PSI"]
["SUPERFICIE",{"$f":"(B7*B7)/10000*6*2*B11","v":138.78},null,null,"HA",null,null,null,null,null,null,null,"ROTOR AZUL 24° BOQUILLA ROJA 3.2MM MPR40PSI"]
["CAUDAL ",{"$f":"1.01*B11*B9/3600","v":94.655084611111107},null,null,"LPS",null,null,null,null,null,null,null,"ROTOR AZUL 24° BOQUILLA ROJA 3.2MM MPR35PSI"]
["CAUDAL ",{"$f":"B13*3.6","v":340.75830459999997},null,null,"M3H"]
[]
["NOTA: Se considera una Frecuencia de Riego 6 dias, y 2 posturas diarias."]
[]
["ANTECEDENTES AGRONOMICOS"]
["Lamina Bruta a Reponer    ",30,null,null,"MM"]
["Precipitación",{"$f":"B9/(B7*B7)","v":2.9172888888888888},null,null,"MM/H"]
["Tiempo de Riego por Postura",{"$f":"B19/B20","v":10.283520468014443},null,null,"H/DIA"]
["Tiempo de riego diario total",{"$f":"2*B21","v":20.567040936028885},null,null,"H/DIA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Desarrollado por Boris Torres  | Ingeniero Civil Agricola | Email btorres@sewingenieria.cl | Tel. Móvil +56 9 6594 1162"]

{"sheet":"Pivotes","index":3,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
["Nombre Proyecto"]
[]
[]
["ANTECEDENTES PIVOTE"]
["Equipo","Eco Pivot","Eco Pivot","Pivot"]
["Longitud Estructural,                                        m",222,252,280,0,0,0]
["Area Bajo la Estructura,                                   Ha  ",{"$f":"((PI()*(B7)^2)/10000)*B12","v":15.483025233951937},19.950369987356623,24.630086404143977,0,0,0]
["Area Adicional,                                                 Ha ",0,0,0,0,0,0]
["Alcance Aspersor Final,                                    m",0,0,26,0,0,0]
["Area Aspersor Final ,                                        Ha ",{"$f":"(PI()*((B7+B10)^2 - B7^2))/10000","v":0},0,4.7865305670094083,0,0,0]
["Numero de Campo a Regar ",1,1,1,0,0,0]
["Area Total Irrigada,                                          Ha ",{"$f":"(((PI()*(B7)^2)/10000)*B12 + (((PI()*(B7+B10)^2)/10000) - ((PI()*(B7)^2)/10000))*B12)+B9","v":15.483025233951937},19.950369987356623,29.416616971153388,0,0,0]
[]
["ANTECEDENTES AGRONOMICOS"]
["Lamina Bruta a Reponer,                       mm/dia",15,15,10,0,0,0]
["Tiempo de Riego ,                                       h/dia",24,24,24,0,0,0]
["Dias disponibles                                        semana",7,7,0,0,0,0]
["Lamina Bruta a Reponer,                   mm/semana",{"$f":"B18*B16","v":105},{"$f":"7*C16","v":105},{"$f":"7*D16","v":70},{"$f":"7*E16","v":0},{"$f":"7*F16","v":0},{"$f":"7*G16","v":0}]
["Capacidad de Aplicación Bruta,                     l/s",{"$f":"IFERROR(2.78*(B13*B16)/B17,0)","v":26.90175634399149},34.663767853032134,34.074247991586006,0,0,0]
["Capacidad de Aplicación Bruta,              m^3/h ",{"$f":"IFERROR(B20*3.6,0)","v":96.84632283836936},124.78956427091569,122.66729276970962,0,0,0]
["Capacidad de Aplicación Bruta,      GPM (USA)",{"$f":"IFERROR(B21*4.402868,0)","v":426.40157574272558},549.43197926235803,540.08789798238581,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Desarrollado por Boris Torres  | Ingeniero Civil Agricola | Email btorres@sewingenieria.cl | Tel. Móvil +56 9 6594 1162"]

{"sheet":"Enrollador","index":4,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
["Nombre Proyecto"]
["Enrollador Modelo RAINSTAR T42 90-300"]
[]
["ANTECEDENTES AGRONOMICO"]
["Lamina a Reponer,                                          mm",25," (*)"]
["Frecuencia de Riego",6]
[]
["ANTECEDENTES ENROLLADOR"]
["Diametro Tubo",90]
["Longitud PE-Pipe,                                              m",300," (*)"]
["Boquilla,                                    ",26]
["Presion boquilla,                                              bar",4]
["Alcance Aspersor,                                              m",47," (*)"]
["Caudal Aspersor,                                           m3/h",51.9," (*)"]
["Presion base Enrollador,                                bar",5.6]
["Porcentaje de Traslape",0.85," (*)"]
["Ancho Banda regada por Aspersor,               m",{"$f":"ROUND(B17*2*B14,0)","v":80}]
["Precipitacion,                                                  mm/h",{"$f":"IFERROR((B15*1000)/(PI()*((90/100*B14)^2)*220/360),\"\")","v":15.108333761278455}]
["Velocidad de avance del carro,                    m/h",{"$f":"IFERROR((B15*1000)/(B6*B18),\"\")","v":25.95}]
["Tiempo de recorrido por postura,                   h",{"$f":"IFERROR(B11/B20,\"\")","v":11.560693641618498}]
["Superficie regada por postura,                      HA",{"$f":"IFERROR(((B11+B18*0.5)*B18)/10000,\"\")","v":2.72}]
["(*) Obligatorio"]
[]
[]
["ANTECEDENTES OPERACIÓN"]
["N° Posturas Maximas",{"$f":"IFERROR(ROUNDDOWN((23*$B$7)/B21,0),\"\")","v":11}]
["Superficie Total,                                                HA",{"$f":"IFERROR(B22*B27,\"\")","v":29.92}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Desarrollado por Boris Torres  | Ingeniero Civil Agricola | Email btorres@sewingenieria.cl | Tel. Móvil +56 9 6594 1162"]

{"sheet":"CALCULADORA","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1]]}
[]
["Nombre Proyecto"]
["Actualizado"]
[]
["Tramo","Tubo","Cota Inicial, m","Cota Final, m","Caudal, m3/h","Longitud, m","Velocidad, m/s","Perdida Lineales, m.c.a.","Presion de Servicio, m.c.a.","Altura Manometrica, m.c.a."]
[1,"PE100 Ø110 PN10 HDPE PIPE",0,0,155,100,{"$f":"IF(B6<>\"-\",   (E6/3600)/(PI()/4*((IF(B6=\"TUBO GALVANIZADO HK 76 BAUER \",74.6,IF(B6=\"TUBO GALVANIZADO HK 89 BAUER \",87.6,IF(B6=\"TUBO GALVANIZADO HK 108 BAUER \",106.3,IF(B6=\"TUBO GALVANIZADO HK 133 BAUER \",131,IF(B6=\"TUBO GALVANIZADO HK 159 BAUER \",157,IF(B6=\"TUBO GALVANIZADO HK 194 BAUER \",191.8,IF(B6=\"PE100 Ø160 PN10 HDPE PIPE\",141,IF(B6=\"PE100 Ø140 PN10 HDPE PIPE\",123.4,IF(B6=\"PE100 Ø125 PN10 HDPE PIPE\",110.2,IF(B6=\"PE100 Ø110 PN10 HDPE PIPE\",96.8,0)))))))))))/1000)^2),0)","v":5.8504409656396277},{"$f":"IF(B6<>\"-\",(1.131*10^12*E6^1.852*125^-1.852*(IF(B6=\"TUBO GALVANIZADO HK 76 BAUER \",74.6,IF(B6=\"TUBO GALVANIZADO HK 89 BAUER \",87.6,IF(B6=\"TUBO GALVANIZADO HK 108 BAUER \",106.3,IF(B6=\"TUBO GALVANIZADO HK 133 BAUER \",131,IF(B6=\"TUBO GALVANIZADO HK 159 BAUER \",157,IF(B6=\"TUBO GALVANIZADO HK 194 BAUER \",191.8,IF(B6=\"PE100 Ø160 PN10 HDPE PIPE\",141,IF(B6=\"PE100 Ø140 PN10 HDPE PIPE\",140,IF(B6=\"PE100 Ø125 PN10 HDPE PIPE\",123.4,IF(B6=\"PE100 Ø110 PN10 HDPE PIPE\",96.8,0)))))))))))^-4.87)/1000*F6,0)","v":35.914231335153183},10,{"$f":"H6+(D6-C6)+I6","v":45.914231335153183}]
[null,"TUBO GALVANIZADO HK 108 BAUER ",0,0,120,0,{"$f":"IF(B7<>\"-\",   (E7/3600)/(PI()/4*((IF(B7=\"TUBO GALVANIZADO HK 76 BAUER \",74.6,IF(B7=\"TUBO GALVANIZADO HK 89 BAUER \",87.6,IF(B7=\"TUBO GALVANIZADO HK 108 BAUER \",106.3,IF(B7=\"TUBO GALVANIZADO HK 133 BAUER \",131,IF(B7=\"TUBO GALVANIZADO HK 159 BAUER \",157,IF(B7=\"TUBO GALVANIZADO HK 194 BAUER \",191.8,IF(B7=\"PE100 Ø160 PN10 HDPE PIPE\",141,IF(B7=\"PE100 Ø140 PN10 HDPE PIPE\",123.4,IF(B7=\"PE100 Ø125 PN10 HDPE PIPE\",110.2,IF(B7=\"PE100 Ø110 PN10 HDPE PIPE\",96.8,0)))))))))))/1000)^2),0)","v":3.7559719034627288},{"$f":"IF(B7<>\"-\",(1.131*10^12*E7^1.852*125^-1.852*(IF(B7=\"TUBO GALVANIZADO HK 76 BAUER \",74.6,IF(B7=\"TUBO GALVANIZADO HK 89 BAUER \",87.6,IF(B7=\"TUBO GALVANIZADO HK 108 BAUER \",106.3,IF(B7=\"TUBO GALVANIZADO HK 133 BAUER \",131,IF(B7=\"TUBO GALVANIZADO HK 159 BAUER \",157,IF(B7=\"TUBO GALVANIZADO HK 194 BAUER \",191.8,IF(B7=\"PE100 Ø160 PN10 HDPE PIPE\",141,IF(B7=\"PE100 Ø140 PN10 HDPE PIPE\",140,IF(B7=\"PE100 Ø125 PN10 HDPE PIPE\",123.4,IF(B7=\"PE100 Ø110 PN10 HDPE PIPE\",96.8,0)))))))))))^-4.87)/1000*F7,0)","v":0},0,{"$f":"H7+(D7-C7)+I7","v":0}]
[null,"PE100 Ø110 PN10 HDPE PIPE",0,0,120,0,4.5293736508177762,0,0,{"$f":"H8+(D8-C8)+I8","v":0}]
[null,"PE100 Ø110 PN10 HDPE PIPE",0,0,120,0,4.5293736508177762,0,0,{"$f":"H9+(D9-C9)+I9","v":0}]
[null,"PE100 Ø110 PN10 HDPE PIPE",0,0,120,0,4.5293736508177762,0,0,{"$f":"H10+(D10-C10)+I10","v":0}]
[null,"TOTAL",null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,6,H6:H10)","v":35.914231335153183},null,{"$f":"_xlfn.AGGREGATE(9,6,J6:J10)","v":45.914231335153183}]