EXCEL METODO DE HARDY CROSS.xls
19
DATOS: Q D A v Re | f L K Línea Q D A v Re f MALLA I 1 -0.3 0.3 0.070686 4.244132 1273240 0.011076 2 0.4 0.3 0.070686 5.658842 1697653 0.010529 4 -0.1 0.3 0.070686 1.414711 424413.2 0.013575 MALLA II 1 0.3 0.3 0.070686 4.244132 1273240 0.011076 3 -0.3 0.3 0.070686 4.244132 1273240 0.011076 5 0.1 0.3 0.070686 1.414711 424413.2 0.013575 MALLA I 1 - 0.32256 0.3 0.070686 4.56331 1368993 0.010935 2 0. 368958 0.3 0. 070686 5. 219682 1565905 0. 010679 4 -0.1 3104 0.3 0. 070686 1. 853871 556161.3 0.012893 MALLA II 1 0.322561 0.3 0.070686 4.56331 1368993 0.010935 3 -0.3 0848 0.3 0.070686 4.364114 1309234 0.011022 5 0.091519 0.3 0.070686 1.294728 388418.5 0.01381 MALLA I 1 -0.31524 0.3 0.070686 4.459751 1337925 0.010979 2 0.3 6379 0.3 0.070686 5.146582 1543975 0.010706 4 -0 .1 3621 0.3 0. 070686 1. 926971 57 8091.3 0. 012799 MALLA II 1 0.315241 0.3 0.070686 4.459751 1337925 0.010979 3 -0 .3 2097 0.3 0.070686 4.540773 1362232 0.010945 5 0.079032 0.3 0.070686 1.11807 335420.9 0.014212 MALLA I 1 - 0.31686 0.3 0.070686 4.482618 1344785 0.01097 2 0. 358941 0.3 0.070686 5.077971 1523391 0.010731 4 -0.1 4106 0.3 0. 070686 1. 995582 598674.5 0.012715 MALLA II 1 0.316858 0.3 0.070686 4.482618 1344785 0.01097 3 -0.3242 0.3 0.070686 4.586517 1375955 0.010925 5 0.0 757 98 0. 3 0.0 70 68 6 1.0 72 32 6 321 697 .7 0. 01 43 29 coeficiente de perdida de cargas lineales log c/d tramo : 1000 m diam int. Tub. : 400 mm fluido: agua viscosidad cinematica: 1e-6m2/s caudal diametro CALCULO D area tub velocidad reynols coeficiente de friccion longitud
Transcript of EXCEL METODO DE HARDY CROSS.xls
CALCULO DE HARDY CROSSCALCULO DE HARDY CROSSDATOS:log c/d tramo : 1000 mdiam int. Tub. : 400 mmfluido: aguaviscosidad cinematica: 1e-6m2/sQcaudalDdiametroAarea tubvvelocidadRe |reynolsfcoeficiente de friccionLlongitudKcoeficiente de perdida de cargas linealesLneaQDAvRefLKCCorreccinMALLA I1-0.30.30.07068583474.24413181581273239.544735160.0110764856100036.92161856363694757.62454895-0.031042430620.40.30.07068583475.6588424211697652.726313550.0105294672100035.09822401513512289.976250034-0.10.30.07068583471.4147106053424413.1815783880.0135754953100045.25165085544528346.49525037MALLA II10.30.30.07068583474.24413181581273239.544735160.0110764856100036.92161856363694757.62454895-0.00848103683-0.30.30.07068583474.24413181581273239.544735160.0110764856100036.92161856363694757.6245489550.10.30.07068583471.4147106053424413.1815783880.0135754953100045.25165085544528346.49525037MALLA I1-0.32256139390.30.07068583474.56331024731368993.07418310.0109349247100036.44974904293647537.4977691-0.005167121820.36895756940.30.07068583475.21968186291565904.558877830.0106791831100035.59727688083562230.348645094-0.13104243060.30.07068583471.8538711634556161.3490141060.0128925100042.9750000264300521.35275231MALLA II10.32256139390.30.07068583474.56331024731368993.07418310.0109349247100036.44974904293647537.4977691-0.01248727553-0.30848103680.30.07068583474.36411394241309234.182722950.0110217586100036.73919522293676502.4652394450.09151896320.30.07068583471.2947284786388418.5435906030.0138104118100046.0347060444606707.0666674MALLA I1-0.31524124020.30.07068583474.45975125681337925.377036660.0109794642100036.5982140373662394.43498661-0.00484979520.36379044760.30.07068583475.14658204271543974.612796920.0107056267100035.68542223353571051.080966634-0.13620955240.30.07068583471.9269709837578091.295095020.0127987545100042.66251509144269250.89009026MALLA II10.31524124020.30.07068583474.45975125681337925.377036660.0109794642100036.5982140373662394.43498661-0.0032334563-0.32096831230.30.07068583474.54077275321362231.82595030.0109445097100036.48169911083650734.7508010750.07903168770.30.07068583471.1180696679335420.900363250.0142119446100047.37314862864740645.42411751MALLA I1-0.31685757910.30.07068583474.48261777561344785.332675370.0109695193100036.5650643423659077.13490714-0.001547400320.35894065260.30.07068583475.07797147891523391.443660250.0107308755100035.76958486483579473.261136834-0.14105934740.30.07068583471.9955815474598674.4642316920.012714767100042.38255672664241235.37118322MALLA II10.31685757910.30.07068583474.48261777561344785.332675370.0109695193100036.5650643423659077.13490714-0.00218099123-0.32420176830.30.07068583474.58651679821375955.039448260.0109251167100036.41705557693644265.8526598150.07579823170.30.07068583471.0723256229321697.6868652950.0143292735100047.76424484154779782.54135647MALLA I1-0.31622398820.30.07068583474.47365429811342096.289444340.0109734101100036.57803353153660374.96564836-0.000895679420.35739325230.30.07068583475.05608024211516824.072630070.010739021100035.79673679773582190.363338414-0.14260674770.30.07068583472.0174727842605241.8352618650.0126887341100042.29578038934232551.63665894MALLA II10.31622398820.30.07068583474.47365429811342096.289444340.0109734101100036.57803353153660374.96564836-0.00080284963-0.32638275950.30.07068583474.61737151241385211.453709460.0109121717100036.3739055653639947.8178135850.07361724050.30.07068583471.0414709087312441.2726040880.0144120809100048.04026976334807404.43941918MALLA I1-0.31631681810.30.07068583474.47496757191342490.27158170.0109728394100036.57613133863660184.61262452-0.000358345620.35649757280.30.07068583475.04340897051513022.691135010.010743756100035.81252012633583769.805837194-0.14350242720.30.07068583472.0301440559609043.216756930.012673828100042.24609330494227579.43497688MALLA II10.31631681810.30.07068583474.47496757191342490.27158170.0109728394100036.57613133863660184.61262452-0.00042232823-0.32718560910.30.07068583474.62872951021388618.853067170.0109074336100036.35811200633638367.3515792950.07281439090.30.07068583471.0301129108309033.8732463780.0144433557100048.14451903924817836.6962404MALLA I1-0.31625283550.30.07068583474.47406240361342218.721070880.0109732327100036.57744234233660315.80516783-0.000178494720.35613922720.30.07068583475.03833941711511501.825139940.0107456546100035.81884860293584403.098421234-0.14386077280.30.07068583472.0352136092610564.0827519950.0126678972100042.22632393664225601.10826553MALLA II10.31625283550.30.07068583474.47406240361342218.721070880.0109732327100036.57744234233660315.80516783-0.00017810373-0.32760793720.30.07068583474.63470423191390411.269573050.010904947100036.34982340913637537.9091397150.07239206280.30.07068583471.0241381891307241.4567405030.0144599847100048.19994886924823383.57621977MALLA I1-0.31625322650.40.12566370612.51666321361006665.285433910.0115531416100028.8828540098914514.048514422-0.000001085820.35596073250.40.12566370612.83264550631133058.202518360.011309643100028.2741075959895239.390015694-0.14403926750.40.12566370611.146228071458491.2284005960.0133753082100033.43827043151058751.60596126MALLA II10.31625322650.40.12566370612.51666321361006665.285433910.0115531416100028.8828540098914514.048514422-0.00012373393-0.3277860410.40.12566370612.60843843471043375.373885640.0114786345100028.6965863311908616.27923699550.0722139590.40.12566370610.5746604271229864.1708495230.0153246375100038.31159385641213055.0114872MALLA I1-0.31613057840.40.12566370612.51568721091006274.884357120.0115539522100028.8848804597914578.211733025-0.000042904120.35595964670.40.12566370612.83263686571133054.746288580.0113096492100028.2741230629895239.8797428724-0.14404035330.40.12566370611.1462367116458494.6846303710.0133752888100033.43822209021058750.07533432MALLA II10.31613057840.40.12566370612.51568721091006274.884357120.0115539522100028.8848804597914578.211733025-0.00001178623-0.32790977490.40.12566370612.6094230781043769.23119220.011477853100028.6946325934908554.41829543450.07209022510.40.12566370610.5736757839229470.3135429610.0153299608100038.32490195771213476.3841671MALLA I1-0.31616169630.40.12566370612.51593483911006373.935651240.0115537465100028.8843662222914561.929496351-0.000007989120.35591674260.40.12566370612.83229544561132918.178259610.0113098937100028.2747342637895259.2321155374-0.14408325740.40.12566370611.1465781316458631.2526593420.0133745249100033.43631231871058689.60648918MALLA II10.31616169630.40.12566370612.51593483911006373.935651240.0115537465100028.8843662222914561.929496351-0.00001780823-0.32792156110.40.12566370612.60951686981043806.747927050.0114777786100028.694446539908548.52727909450.07207843890.40.12566370610.573581992229432.7968081090.0153304685100038.32617114531213516.57028873MALLA I1-0.31615187720.40.12566370612.51585670111006342.680421920.0115538114100028.8845284809914567.067072419-0.000006888620.35590875350.40.12566370612.83223187071132892.748274670.0113099392100028.274848084895262.83599394-0.14409124650.40.12566370611.1466417066458656.6826442790.0133743827100033.43595678471058678.34926198MALLA II10.31615187720.40.12566370612.51585670111006342.680421920.0115538114100028.8845284809914567.067072419-0.00000474873-0.32793936930.40.12566370612.60965858291043863.433141320.0114776662100028.6941654394908539.6268603550.07206063070.40.12566370610.573440279229376.1115938450.0153312357100038.32808930621213577.30476571MALLA I1-0.31615401710.40.12566370612.515873731006349.492009390.0115537972100028.8844931186914565.947401177-0.000002270820.35590186490.40.12566370612.8321770531132870.821194760.0113099785100028.2749462285895265.9435299614-0.14409813510.40.12566370611.1466965243458678.6097241890.0133742601100033.43565024451058668.64332009MALLA II10.31615401710.40.12566370612.515873731006349.492009390.0115537972100028.8844931186914565.947401177-0.00000312143-0.3279441180.40.12566370612.60969637161043878.548633750.0114776362100028.6940904856908537.25360625750.0720558820.40.12566370610.5734024903229360.996101410.0153314404100038.32860089941213593.50327479MALLA I1-0.31615316660.40.12566370612.51586696161006346.784623280.0115538029100028.8845071739914566.39243321-0.000001286820.35589959410.40.12566370612.83215898221132863.592888760.0113099914100028.2749785826895266.9679519674-0.14410040590.40.12566370611.1467145951458685.8380301950.0133742197100033.4355491971058665.4438658MALLA II10.31615316660.40.12566370612.51586696161006346.784623280.0115538029100028.8845071739914566.39243321-0.00000117173-0.32794723940.40.12566370612.60972121081043888.484325870.0114776165100028.6940412178908535.69364599150.07205276060.40.12566370610.573377651229351.0604092960.0153315749100038.32893720261213604.1516001
METODO DE HARDY CROOSDETERMINAR LA DISTRIBUCION DE LOS CAUDALES ENLA SIGUIENTE TUBERIA. SI A ES EL PUNTO DE INGRESO Y F ES EL PUNTO DE DESCARGA11.8560.5387931034C=1001.856530 lts/seg100 lit/segA400-40300-40C300B12080 lis/seg230600 - 408040QxL^(0.54)=7.6248911815600-30600-300.2788xCxD^(2.63)2.50443951023.0445499484E480 - 40F7.8962134555120 lits/seg500 - 30120 lits/seg110 lits/seg11070393Q inicial =10080110120120530lits/segCIRCURITOTRAMODIAM (m)L(m)Q supuestohlhl/QQ corregidoIAB0.44000.37.86804321030.02622681074.6596304.6596BE0.36000.084.1453683640.05181710464.659684.6596AD0.46000.23-7.21578817050.0313729924.6596234.6596DE0.35000.11-6.22897517920.05662704714.6596114.6596-1.43135177540.1660439544CIRCURITOTRAMODIAM (m)L(m)Q supuestohlhl/QQ corregidoIIBC0.43000.121.08242674770.009020222913.9800133.9800CF0.36000.041.14909677750.028727419413.980053.9800BE0.36000.08-4.1453683640.051817104613.980093.9800EF0.44800.07-0.6384642560.009120917913.980083.9800-2.55230909490.0986856648
METODO DE HARDY CROSS EJEMPCALCULAR EL CAUDAL POR EL METODO DE HARDY CROSSC=100TRAMOLARGODIAMETROmmm1-210202002-312501503-49501504-114302502-41050100CIRCURITOTRAMODIAM (m)L(m)Q supuestohlhl/QQ corregidoI1-20.210200.0521.24785512950.4249571026-7.598742.40132-40.110500.0132.47566910323.2475669103-13.3063-3.30631-40.2514300.015-1.08234163420.07215610897.5987-22.598752.64118259853.7446801219CIRCURITOTRAMODIAM (m)L(m)Q supuestohlhl/QQ corregidoII2-30.1512500.015.37042739010.5370427395.707615.70762-40.110500.01-32.47566910323.247566910313.3063-3.30634-30.159500.025-22.25687687250.89027507495.7076-19.2924-49.36211858564.6748847242CIRCURITOTRAMODIAM (m)L(m)Q supuestohlhl/QQ corregidoI1-20.2102042.401315.66031538830.3693357195-2.850039.55132-40.11050-3.3063-4.18651405251.2662360017-2.8500-6.15621-40.251430-22.5987-2.31114849880.1022690998-2.8500-25.44879.16265283711.737840821CIRCURITOTRAMODIAM (m)L(m)Q supuestohlhl/QQ corregidoII2-30.15125015.707612.3880.7887-0.546315.16132-40.11050-3.30634.1871.26628.61645.31014-30.15950-19.2924-13.7760.7141-0.5463-19.83872.7982.7689813966
CANAL RECTANGULARDATOS:Q=0.56b=0.8y=0.5s=0.005B=0.8n=0.018AreaA=b*yA=0.4PerimetroP=b+2yP=1.8Radio hidraulicoRH=A/PRh=0.2222222222Espejo de aguaB=bB=0.8formula de manigQ=0.5764975676V=1.4412439189podemos determinar el tirante del canal mediante un tanteoEcuacion enfuncion de yvalor constanteYb0.14255272710.10.80.01485308430.20.80.04175858820.30.80.07406278620.40.80.10943846060.50.80.14675232220.60.80.18537396180.70.80.22492182110.80.80.26515050720.90.80.305894683410.80.34703873961.10.80.38849933861.20.80.43021485571.30.80.47213872271.40.80.5142350847
CANAL TRAPEZOIDALCANAL TRAPEZOIDALDATOS:Q=1.1278597211b=0.8y=0.5s=0.005B=0.8n=0.018Z=1AreaA=(b+zy)yA=0.65PerimetroP=b+P=2.2142135624Radio hidraulicoRH=A/PRh=0.2935579526Espejo de aguaB=b+2zyB=1.8Q=1.1278597211V=0.0613474813podemos determinar el tirante del canal mediante un tanteoEcuacion enfuncion de yvalor constanteYb0.10.80.01714064910.28710621250.20.80.05556690520.30.80.11292557840.40.80.18973973110.50.80.28710621250.60.80.40629978280.70.80.54865097450.80.80.71550010480.90.80.908178166210.81.12799862931.10.81.37625409531.20.81.654215233
LINEA DE IMPULSIONLINEA DE IMPULSIONDATOS:Q litros=20l/seg0.02m3/segN=7horas de bombeoc=150pvc rugosidadL=340m1) hallar caudal de diseoQd= Q/(n/24)Qd=0.0685714286m3/seg2) halla diametro (brees)D=1.3 ((N/24)^(1/4))*((Qd^(1/2)))D=0.2501708191mD=9.8492448477pug10buscamos un diametro comercial redondenado0.254m3) hallar la velocidadV= Qd/AV=1.35334) calculo de perdida de cargaQ=0.2785xCxD^(2.63)x(J/L)^(2.63)J=1.8751929837
