cálculo-de-presiones-trab4.xlsx

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²