cálculo-de-presiones-trab4.xlsx
TRANSCRIPT
PRIMERA ITERACIÓN
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
I AB 63.65 140 0.102 4950.114321 -0.00100 1.851851852 -0.01377399 13.77398715 -0.03703767I BC 34.22 140 0.102 2661.318335 -0.06210 1.851851852 -15.4910648 249.4535396I CD 61.07 140 0.076 19281.58192 -0.00420 1.851851852 -0.76516035 182.1810364I DA 33.7 140 0.076 10640.07386 0.09990 1.851851852 149.3785156 1495.280436
133.1085164 1940.688999
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
II CD 61.07 140 0.076 19529.9711 -0.00004 1.851851852 -0.00016782 3.805472143 0.000124793II DG 38.42 140 0.076 12286.5808 -0.00042 1.851851852 -0.00673741 16.1956892II GF 46.4 140 0.102 3540.166521 -0.00028 1.851851852 -0.00094495 3.35090272II FC 39.97 140 0.102 3049.57879 0.00040 1.851851852 0.0015551 3.887750353
-0.00629508 27.23981441
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
III DE 69.94 140 0.076 22366.56588 0.00050 1.851851852 0.017241728 34.48345667 -0.000112818III EH 40.46 140 0.102 3086.964169 0.00040 1.851851852 0.001566884 3.927028519III HG 71.85 140 0.102 5481.917339 -0.00010 1.851851852 -0.00021455 2.145482987III GD 38.42 140 0.076 12286.5808 -0.00042 1.851851852 -0.00673741 16.1956892
0.011856658 56.75165738
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
IV GH 71.85 140 0.102 5481.917339 -0.0001 1.851851852 -0.00021455 2.145482987 0.000231156IV HJ 50.24 140 0.102 3833.145819 0.0002 1.851851852 0.00053153 2.684495777IV JI 59.12 140 0.076 18906.36796 -0.0002 1.851851852 -0.00343212 14.98743182IV IG 48.5 140 0.076 15510.12933 -0.0006 1.851851852 -0.01759521 28.56365662
-0.02071035 48.38106721
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
V IJ 59.12 140 0.150 689.4400474 -0.0002 1.851851852 -0.00012516 0.546532032 -1.52523E-05V JL 36.68 140 0.150 427.7513691 0.0004 1.851851852 0.000187859 0.509103943V LK 50.97 140 0.205 129.8223893 -0.0001 1.851851852 -4.98723E-06 0.05037604V KI 31.74 140 0.205 80.84290044 -0.0003 1.851851852 -2.41987E-05 0.080662393
3.35176E-05 1.186674409
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
VI KL 50.97 140 0.102 3888.842404 0.0001 1.851851852 0.000149393 1.509019211 1.907908E-05VI LN 47.76 140 0.102 3643.930022 0.0004 1.851851852 0.001466489 4.166160537VI NM 38.77 140 0.076 12398.50957 -0.0002 1.851851852 -0.00175156 8.757800208VI MK 46.24 140 0.076 14787.38928 -0.0001 1.851851852 -0.00057874 5.787407977
-0.00071442 20.22038793
Tramo L C D K Q n hp hp/Q(m) (m) (m³/s) (m)
VII MN 38.77 140 0.076 12398.50957 -0.00020 1.851851852 -0.00175156 8.757800208 9.182299E-05VII NÑ 80.1 140 0.102 6111.36505 0.00004 1.851851852 3.60636E-05 1.001765988VII ÑM 72.74 140 0.076 22966.14162 -0.00017 1.851851852 -0.00229767 13.841403
-0.00401317 23.60096919 SEGUIR
SEGUNDA ITERACIÓN
CÁLCULO DE PRESIONES CÁLCULO DE PRESIONES
Punto Cota terreno Punto Cota terreno#REF!
A 2234.46 2251.00 16.54 1.65 A 2234.46 2251.00B 2334.07 #REF! #REF! #REF! #REF! B 2334.07 #REF! #REF!C 2233.53 #REF! #REF! #REF! #REF! C 2233.53 #REF! #REF!D 2232.77 #REF! #REF! #REF! #REF! D 2232.77 #REF! #REF!E 2230.00 #REF! #REF! #REF! #REF! E 2230.00 #REF! #REF!F 2232.31 #REF! #REF! #REF! #REF! F 2232.31 #REF! #REF!G 2232.24 #REF! #REF! #REF! #REF! G 2232.24 #REF! #REF!H 2230.50 #REF! #REF! #REF! #REF! H 2230.50 #REF! #REF!I 2228.92 I 2228.92 #REF!J 2229.10 J 2229.10L 2228.50 L 2228.50M 2228.52 M 2228.52N 2227.78 N 2227.78Ñ 2226.82 Ñ 2226.82
#REF!
Altura dinámica
16.54#REF!#REF!#REF!#REF!#REF!#REF!#REF! 1.65
#REF!#REF!#REF!#REF!#REF!#REF!#REF!
Circuito
DQI=
Circuito
DQII=
Circuito
DQII=
Circuito
DQII=
Circuito
DQII=
Circuito
DQII=
Circuito
DQII=
Dhp Cota piezométrica
Altura dinámica
Presiónkgf/cm² Dhp Cota
piezométrica
Presiónkgf/cm²