ACUEDUCTOS, Hardy Cross(1).xlsx

8
Malla Tramo α R I (1-2) 150 64.5 3.28E-05 2.12E-03 (1-8) 150 93 3.28E-05 3.05E-03 (2-9) 150 93 3.28E-05 3.05E-03 (8-9) 100 64.5 2.36E-04 1.52E-02 Malla Tramo α R II (2-3) 150 55.5 3.28E-05 1.82E-03 (2-9) 150 93 3.28E-05 3.05E-03 (3-4) 150 93 3.28E-05 3.05E-03 (4-9) 100 55.5 2.36E-04 1.31E-02 Malla Tramo α R III (4-5) 100 85.5 2.36E-04 2.01E-02 (4-9) 100 55.5 2.36E-04 1.31E-02 (5-6) 100 55.5 2.36E-04 1.31E-02 (6-9) 100 55.5 2.36E-04 1.31E-02 Malla Tramo α R (6-7) 100 64.5 2.36E-04 1.52E-02 Ø(mm) L(m) Ø(mm) L(m) Ø(mm) L(m) Ø(mm) L(m)

description

Tablas hardy cross acueductos

Transcript of ACUEDUCTOS, Hardy Cross(1).xlsx

Tabla de IteracionesMallaTramo(mm)L(m)RQ(L/S)RQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qI(1-2)15064.53.28E-052.12E-0312.90.020.240.9813.880.020.270.0813.950.020.280.1614.120.020.280.0114.12(1-8)150933.28E-053.05E-03-12.90.03-0.35-11.920.03-0.30-11.850.02-0.30-11.680.02-0.29-11.68(2-9)150933.28E-053.05E-035.950.010.087.560.020.137.330.020.127.480.020.137.49(8-9)10064.52.36E-041.52E-02-3.640.05-0.17-3.040.04-0.12-3.250.04-0.13-3.100.04-0.12-3.090.10-0.190.10-0.010.10-0.030.10-0.00

MallaTramo(mm)L(m)RQ(L/S)RQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qII(2-3)15055.53.28E-051.82E-035.950.010.05-0.635.320.010.040.315.620.010.040.015.630.010.04-0.005.63(2-9)150933.28E-053.05E-03-5.950.01-0.08-7.560.02-0.13-7.330.02-0.12-7.320.02-0.12-7.32(3-4)150933.28E-053.05E-035.150.010.064.520.010.054.820.010.064.830.010.064.83(4-9)10055.52.36E-041.31E-021.680.020.030.940.010.011.260.020.021.270.020.021.270.050.060.05-0.030.05-0.000.050.00

MallaTramo(mm)L(m)RQ(L/S)RQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qIII(4-5)10085.52.36E-042.01E-021.680.030.050.101.780.030.06-0.011.770.030.060.131.910.030.07-0.001.91(4-9)10055.52.36E-041.31E-02-1.680.02-0.03-0.940.01-0.01-1.260.02-0.02-1.130.01-0.02-1.13(5-6)10055.52.36E-041.31E-020.880.010.010.980.010.010.970.010.011.110.010.021.11(6-9)10055.52.36E-041.31E-02-1.960.02-0.05-2.230.03-0.06-2.530.03-0.07-2.390.03-0.07-2.390.09-0.020.080.000.09-0.020.090.00

MallaTramo(mm)L(m)RQ(L/S)RQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qRQ^0.85RQ^1.85qQ= Q + qIV(6-7)10064.52.36E-041.52E-02-1.960.03-0.050.38-1.580.02-0.040.28-1.300.02-0.020.02-1.280.02-0.020.00-1.28(6-9)10085.52.36E-042.01E-021.960.040.072.230.040.092.530.040.112.550.040.112.55(7-8)10085.52.36E-042.01E-02-4.360.07-0.31-3.980.07-0.26-3.700.06-0.23-3.680.06-0.22-3.68(8-9)10064.52.36E-041.52E-023.640.050.173.040.040.123.250.040.133.260.040.143.260.18-0.120.17-0.090.17-0.010.17-0.00

Hoja2

Hoja3