Hoja-de-calculo-de-alcantarillados-1.xlsx

  • Uploaded by: Linda Rodriguez
  • 0
  • 0
  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Hoja-de-calculo-de-alcantarillados-1.xlsx as PDF for free.

More details

  • Words: 1,946
  • Pages: 32
Determinacion de los elementos hidraulicos Ecuaciones para determinar los elementos hidraulicos a tubo lleno Tirante de agua: D = diΓ‘metro de la tuberΓ­a PerΓ­metro mojado: P = πœ‹ βˆ—οΏ½

Área mojado: 𝐴= (πœ‹ βˆ— οΏ½^2)/4

Rh: (Γ‘π‘Ÿπ‘’π‘Ž π‘šπ‘œπ‘—π‘Žπ‘‘π‘Ž)/(π‘π‘’π‘ŸΓ­π‘šπ‘’π‘‘π‘Ÿπ‘œ π‘šπ‘œπ‘—π‘Žπ‘‘π‘œ) Rh en una tuberia circular: (οΏ½ )/4

Para calcular la ecuacion de velocidad se utiliza las siguientes ecuaciones: EcuaciΓ³ de manning

V = (1 )/πœ‹ βˆ—(π‘…β„Ž)^(2/3) βˆ—βˆšοΏ½

EcuaciΓ³n de ChΓ©zy

V =βˆ’2√(8 βˆ—π‘” βˆ—π‘…β„Ž βˆ—οΏ½

Caudal: Q = V βˆ—π΄ Ecuaciones para determinar los elemntos hidraulicos a tubo parcialmente lleno π‘‡π‘–π‘Ÿπ‘Žπ‘›π‘‘π‘’ :𝑑= οΏ½/2 βˆ—(1βˆ’cos γ€–οΏ½ /2) γ€— Γπ‘›π‘”π‘’π‘™π‘œ :οΏ½=2 cos^(βˆ’1)(1βˆ’2𝑑/οΏ½)

Γπ‘Ÿπ‘’π‘Ž π‘šπ‘œπ‘—π‘Žπ‘‘π‘Ž :π‘Ž= οΏ½^2/8 βˆ—(οΏ½ βˆ’ sin γ€–οΏ½ ) γ€— π‘ƒπ‘’π‘ŸΓ­π‘šπ‘’π‘‘π‘Ÿπ‘œ π‘šπ‘œπ‘—π‘Žπ‘‘π‘œ :𝑝= (πœ‹ βˆ—οΏ½ βˆ— οΏ½)/(360Β°)= (οΏ½ βˆ— οΏ½)/2

π‘…π‘Žπ‘‘π‘Ÿπ‘–π‘œ β„Žπ‘–π‘‘π‘ŸΓ‘π‘’π‘™π‘–π‘π‘œ :π‘…β„Ž=οΏ½ (1/4 βˆ’ sin γ€–οΏ½ βˆ— 180 γ€— /(4 βˆ— πœ‹ βˆ— οΏ½))= π‘Ž/𝑝 π‘ƒπ‘Ÿπ‘œπ‘“π‘’π‘›π‘‘π‘–π‘Žπ‘‘ β„Žπ‘–π‘‘π‘ŸΓ‘π‘’π‘™π‘–π‘π‘Ž: 𝐿= οΏ½/8 (((οΏ½ βˆ’ sin γ€–οΏ½ ) γ€— )/sin γ€–οΏ½ /2 γ€— )= π‘Ž/𝑑 𝑇 π‘Žπ‘›π‘β„Žπ‘œ π‘™Γ‘π‘šπ‘–π‘›π‘Ž 𝑇=οΏ½ βˆ— sin γ€–οΏ½ /2 de γ€— Manning o la ecuacΓ³n de ChΓ©zy Para calcular la ecuacion𝑑𝑒 de π‘Žπ‘”π‘’π‘Ž velocidad se utiliza la eucaciΓ³n

ementos hidraulicos en las tuberias circulares

EcuaciΓ³n de ChΓ©zy

V =βˆ’2√(8 βˆ—π‘” βˆ—π‘…β„Ž βˆ—οΏ½) βˆ—log(𝐾𝑠/(14.8 βˆ—π‘…β„Ž)+(2.51 βˆ—π‘£)/(4 βˆ—π‘…β„Ž √(8 βˆ—π‘” βˆ—π‘…β„Ž βˆ—οΏ½)))

Pendiente de la tuberia (%)

1.5

Pendiente de la tuberia (m/m)

0.015

Temperatura del agua (Β°c)

15

Tipo de tuberia (material)

%

m/m

Β°C concreto

Coheficiente de rugocidad absoluta

3E-04

Viscosidad cinematica (m2/s)

1.146.E-06

m2/s

Caudal (m3/s)

0.02

m3/s

Caudal (lts)

20

Gravedad

9.81

m/s2

COMERCIAL (in)

D COMERCIAL (mm)

d/D

8 10 12 14 16 18 20 24 27 30 38 40 44 48 52 56 60 64

0.2032 0.254 0.3048 0.3556 0.4064 0.4572 0.508 0.6096 0.6858 0.762 0.9652 1.016 1.1176 1.2192 1.3208 1.4224 1.524 1.6256

D

m

lts

max

d (m)

angulo (rad)

0.7 0.7 0.7 0.7 0.7 0.7 0.8 0.8 0.8 0.8 0.8 0.5 0.5 0.5 0.5 0.5 0.5 0.5

0.142 0.178 0.213 0.249 0.284 0.320 0.406 0.488 0.549 0.610 0.772 0.508 0.559 0.610 0.660 0.711 0.762 0.813

3.965 3.965 3.965 3.965 3.965 3.965 4.429 4.429 4.429 4.429 4.429 3.142 3.142 3.142 3.142 3.142 3.142 3.142

68 72 80 86 92 98 110

1.7272 1.8288 2.032 2.1844 2.3368 2.4892 2.794

0.5 0.5 0.5 0.5 0.5 0.5 0.5

0.864 0.914 1.016 1.092 1.168 1.245 1.397

3.142 3.142 3.142 3.142 3.142 3.142 3.142

Area (m2)

Perimetro (m)

0.02425 0.03789 0.05456 0.07426 0.09699 0.12275 0.17383 0.25031 0.31680 0.39111 0.62751 0.40537 0.49049 0.58373 0.68507 0.79452 0.91207 1.03774

0.403 0.504 0.604 0.705 0.806 0.906 1.125 1.350 1.519 1.687 2.137 1.596 1.756 1.915 2.075 2.234 2.394 2.553

Radio Hidraulico Radio Hidraulico (m) Velocidad (m/s) (m) 0.060 0.075 0.090 0.105 0.120 0.135 0.155 0.185 0.209 0.232 0.294 0.254 0.279 0.305 0.330 0.356 0.381 0.406

0.0602 0.0752 0.0903 0.1053 0.1204 0.1354 0.1545 0.1854 0.2086 0.2318 0.2936 0.2540 0.2794 0.3048 0.3302 0.3556 0.3810 0.4064

1.847 2.122 2.376 2.613 2.837 3.050 3.306 3.695 3.969 4.231 4.882 4.473 4.738 4.993 5.240 5.479 5.711 5.937

Caudal (m3/s) 0.0448 0.0804 0.1296 0.1940 0.2752 0.3743 0.5747 0.9249 1.2575 1.6550 3.0634 1.8130 2.3239 2.9148 3.5899 4.3533 5.2090 6.1608

1.17151 1.31339 1.62146 1.87380 2.14439 2.43321 3.06558

2.713 2.873 3.192 3.431 3.671 3.910 4.389

0.432 0.457 0.508 0.546 0.584 0.622 0.699

0.4318 0.4572 0.5080 0.5461 0.5842 0.6223 0.6985

6.157 6.371 6.785 7.085 7.376 7.659 8.204

7.2124 8.3676 11.0024 13.2759 15.8167 18.6357 25.1496

Ancho lamina (m)

Profundidad hidraulica (m)

0.1862 0.2328 0.2794 0.3259 0.3725 0.4190 0.4064 0.4877 0.5486 0.6096 0.7722 1.0160 1.1176 1.2192 1.3208 1.4224 1.5240 1.6256

0.1302 0.1627 0.1953 0.2278 0.2604 0.2929 0.4277 0.5133 0.5774 0.6416 0.8127 0.3990 0.4389 0.4788 0.5187 0.5586 0.5985 0.6384

1.7272 1.8288 2.0320 2.1844 2.3368 2.4892 2.7940

0.6783 0.7182 0.7980 0.8578 0.9177 0.9775 1.0972

TABLA DE PESO ESPECIFICO Y VISCOCIDADES DEL AGUA PARA DIFERENTES TEMPERATUR TEMPERATURA

PESO ESPECIFICO Kg/m3

VISCOSIDAD ABSOLUTA

0 2 4 6 8 10 12 14 15 16 18 20 22 24 26 28 30 32 34 36 38 40 45 50

1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000

0.001792 0.001674 0.001569 0.001473 0.001386 0.001308 0.001236 0.00117 0.001146 0.001109 0.001054 0.001003 0.000955 0.000911 0.000871 0.000833 0.000798 0.000765 0.000734 0.000705 0.000678 0.000653 0.000596 0.000547

ARA DIFERENTES TEMPERATURAS VISCOSIDAD CINEMATICA 10-6 m2/S 1.787 1.671 1.562 1.464 1.375 1.307 1.227 1.163 0.0000011460 1.106 1.053 1.004 0.950 0.914 0.875 0.837 0.801 0.768 0.745 0.705 0.685 0.658 0.604 0.554

Pendiente de la tuberia (%) Pendiente de la tuberia (m/m) Caudal (m3/s) Caudal (lt/s) Tipo de tuberia (material) NΒ° de Manning

%

1.5

m/m

0.0150

m3/s

0.0200 20.0000

L/s concreto 0.013

D

D COMERCIAL (in) 8 10 12 14 16 18 20 24 27 30 38 40 44 48 52 56 60 64 68 72 80 86 92 98 110

COMERCIAL (mm) 0.2032 0.254 0.3048 0.3556 0.4064 0.4572 0.508 0.6096 0.6858 0.762 0.9652 1.016 1.1176 1.2192 1.3208 1.4224 1.524 1.6256 1.7272 1.8288 2.032 2.1844 2.3368 2.4892 2.794

Velocidad Tubo lleno 1.292 1.500 1.693 1.877 2.051 2.219 2.380 2.688 2.908 3.119 3.652 3.779 4.026 4.267 4.501 4.729 4.951 5.169 5.382 5.591 5.998 6.294 6.584 6.867 7.417

Caudal Tubo lleno m^3/s

q/Q

v/V

v

d/D

d (m)

0.0419 0.0760 0.1236 0.1864 0.2661 0.3643 0.4825 0.7845 1.0740 1.4224 2.6718 3.0634 3.9499 4.9814 6.1667 7.5141 9.0319 10.7281 12.6105 14.6869 19.4513 23.5887 28.2364 33.4178 45.4732

0.477 0.263 0.162 0.107 0.075 0.055 0.041 0.025 0.019 0.014 0.007 0.007 0.005 0.004 0.003 0.003 0.002 0.002 0.002 0.001 0.001 0.001 0.001 0.001 0.000

0.848 0.714 0.617 0.549 0.497 0.460 0.424 0.368 0.336 0.310 0.258 0.248 0.230 0.215 0.202 0.191 0.181 0.172 0.164 0.157 0.145 0.137 0.130 0.124 0.113

1.096 1.071 1.045 1.031 1.019 1.021 1.010 0.990 0.977 0.966 0.941 0.936 0.926 0.918 0.910 0.902 0.896 0.889 0.883 0.878 0.868 0.861 0.855 0.849 0.838

0.543 0.401 0.319 0.239 0.216 0.196 0.177 0.146 0.126 0.108 0.067 0.058 0.042 0.027 0.013 0.000 -0.012 -0.023 -0.033 -0.043 -0.061 -0.073 -0.085 -0.096 -0.116

0.110 0.102 0.097 0.085 0.088 0.089 0.090 0.089 0.086 0.082 0.065 0.059 0.047 0.033 0.017 0.000 -0.018 -0.037 -0.057 -0.079 -0.124 -0.161 -0.199 -0.239 -0.324

angulo (rad) 3.3151 2.7412 2.3988 2.0420 1.9323 1.8320 1.7390 1.5684 1.4501 1.3371 1.0472 0.9743 0.8233 0.6579 0.4577 0.0684 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

Radio Hidraulico (m)

Profundidad Hidraulica (m)

0.263 0.214 0.180 0.141 0.129 0.118 0.108 0.091 0.079 0.068 0.043 0.038 0.027 0.018 0.009 0.000 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

0.5418 0.4812 0.4820 0.5782 0.6711 0.8392 1.1950 -74.3899 -1.3843 -0.7038 -0.3691 -0.3536 -0.3566 -0.4068 -0.5570 -3.6572 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

SISTEMA DE ALCANTARILLADO DE AGUA PARAMETROS DE DISEΓ‘O Nivel de Complejidad Clima Densidad DotaciΓ³n DOTACION Factor de retorno ContribuciΓ³n industrial INFILTRACION InfiltraciΓ³n CONEXIΓ“N ERRADA COEF. MANING COEF. MANING PRODUNDIDAD CLAVE

1.2

Medio alto CΓ‘lido 400 hab/dia 135 L/hab/dia 19 m3/hab/dia 0.85 0.8 L/htarea/s 0.2 L/htarea/s 0.04 m3/mm diametro km dia 2 L/htarea/s 0.013 CONCRETO 0.01 PVC 1.5

Diametros convencionales de la tuberia Diametros convencionales de la tuberia Diametro comercial de la tuberia de concreto (in)

Diametro comercial de la tuberia PVC (mm)

Diametro comercial de la tuberia PVC (m)

6 8 10 12 14 16 18 20

145 203.2 254 304.8 355.6 406.4 457.2 508

0.145 0.2032 0.254 0.3048 0.3556 0.4064 0.4572 0.508

Calculo de la tabla sistemas de alcantarillado convencional TRAMO

ÁREA

OTRAS

ÁREA

DE A

PROPIA

ÁREAS

TOTAL

1-2 2-3 3-6 1-4 4-5 2-5

0.0625 0.1125 0.1125 0.0625 0.1250 0.1250

0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

0.0625 0.1125 0.1125 0.0625 0.1250 0.1250

5-6 6-9 4-7 7-8 5-8 8-9 9-10 10-11 11-PTAR

0.2250 0.1125 0.0625 0.0625 0.1250 0.1825 0.1400 0.0000 0.0000

0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

0.2250 0.1125 0.0625 0.0625 0.1250 0.1825 0.1400 0.0000 0.0000

ALCANTARILLADO DE AGUAS RESIDUALES TIPO CONVENCIONAL

POBLACIΓ“N

CAUDAL R.D

FACTOR

CAUDAL R.D

CAUDAL

TOTAL

MEDIO (L/S)

CAPACIDAD (ADM)

MAXIMO (L/S)

INDUSTRIAL(L/S)

25 45 45 25 50 50

0.03 0.06 0.06 0.03 0.07 0.07

4.39 5.39 6.39 7.39 8.39 9.39

0.15 0.32 0.38 0.25 0.56 0.62

0 0 2.5 0 0 0

90 45 25 25 50 73 56 0 0

0.12 0.06 0.03 0.03 0.07 0.10 0.07 0.00 0.00

10.39 11.39 12.39 13.39 14.39 15.39 16.39 17.39 18.39

1.24 0.68 0.41 0.44 0.96 1.49 1.22 0.00 0.00

0 2.5 0 0 0 0 2.5 2.5 2.5

CAUDAL

CAUDAL

CAUDAL

COMERCIAL (L/S) INSTITUCIONAL (L/S) CONECCIONES ERRADAS (L/S)

0 0 0 0 0 0

0 0 0 0 0 0

0.1250 0.2250 0.2250 0.1250 0.2500 0.2500

CAUDAL INFILTRACION (L/S)

0.0125 0.0225 0.0225 0.0125 0.0250 0.0250

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0.4500 0.2250 0.1250 0.1250 0.2500 0.3650 0.2800 0.0000 0.0000

0.0450 0.0225 0.0125 0.0125 0.0250 0.0365 0.0280 0.0000 0.0000

CAUDAL A.R

CAUDAL DISEΓ‘O

MAXIMO (L/S)

(L/S)

LONGITUD (m)

SUPERIOR (m)

INFERIOR (m)

0.2834 0.5698 3.1296 0.3830 0.8323 0.8987

1.50 1.50 3.13 1.50 1.50 1.50

50.00 70.00 50.00 50.00 50.00 50.00

100.00 100.00 98.00 100.00 97.00 100.00

100.00 98.00 93.00 97.00 95.00 95.00

COTA DE TERRENO

1.7373 3.4284 0.5490 0.5822 1.2308 1.8939 4.0272 2.5000 2.5000

1.74 3.43 1.50 1.50 1.50 1.89 4.03 2.50 2.50

70.00 50.00 50.00 50.00 50.00 70.00 80.00 60.00 15.00

95.00 93.00 97.00 93.00 95.00 92.00 90.00 85.00 80.00

93.00 90.00 93.00 92.00 92.00 90.00 85.00 80.00 78.00

COTA BETA

CORTES

PENDIENTE

DIAMETRO

SUPERIOR (m)

INFERIOR (m)

SUPERIOR (m)

INFERIOR (m)

%

mm

98.66 98.66 96.66 98.66 95.66 98.66

98.36 96.36 91.36 95.36 93.36 93.36

1.345 1.345 1.345 1.345 1.345 1.345

1.645 3.645 6.645 4.645 3.645 6.645

0.60 3.29 10.60 6.60 4.60 10.60

145 145 145 145 145 145

93.66 91.66 95.66 91.66 93.66 90.66 88.66 83.66 78.66

91.36 88.36 91.36 90.36 90.36 88.36 83.36 78.36 76.36

1.345 1.345 1.345 1.345 1.345 1.345 1.345 1.345 1.345

3.645 4.645 5.645 2.645 4.645 3.645 6.645 6.645 3.645

3.29 6.60 8.60 2.60 6.60 3.29 6.63 8.83 15.33

145 145 145 145 145 145 145 145 145

VELOCIDAD A TUBO

CAUDAL

LLENO (m/s)

LLENO (m3/s)

0.85 1.99 3.57 2.81 2.35 3.57

14.01 32.79 58.89 46.47 38.79 58.89

q/Q

vr/V

A.R admisible A.R admisible

0.107 0.046 0.053 0.032 0.039 0.025

0.5490 0.4366 0.4560 0.3944 0.4157 0.3682

vr

CHEQUEO

A.R (m/s)

si Γ³ no

0.5490 0.4366 0.4560 0.3944 0.4157 0.3682

NO SI NO SI SI SI

1.99 2.81 3.21 1.77 2.81 1.99 2.82 3.26 4.29

32.79 46.47 53.04 29.16 46.47 32.79 46.55 53.76 70.82

0.053 0.074 0.028 0.051 0.032 0.058 0.087 0.047 0.035

0.4556 0.4942 0.3795 0.4517 0.3944 0.4672 0.5169 0.4387 0.4048

0.4556 0.4942 0.3795 0.4517 0.3944 0.4672 0.5169 0.4387 0.4048

NO NO SI NO SI NO NO SI SI

h/D

CHEQUEO <=0.7

ÁNGULO

Angulo

Radio hidraulico (Rh)

A.R admisible

si Γ³ no

LAMINA (m)

(rad)

m3/s

0.2386 0.1837 0.1934 0.1613 0.1729 0.1460

SI SI SI SI SI SI

0.03 0.03 0.03 0.02 0.03 0.02

2.0413 1.7720 1.8214 1.6529 1.7153 1.5681

0.0204 0.0162 0.0170 0.0144 0.0153 0.0131

0.1932 0.2146 0.1527 0.1913 0.1613 0.1988 0.2248 0.1848 0.1670

SI SI SI SI SI SI SI SI SI

0.03 0.03 0.02 0.03 0.02 0.03 0.03 0.03 0.02

1.8205 1.9265 1.6060 1.8107 1.6529 1.8485 1.9761 1.7775 1.6840

0.0170 0.0186 0.0137 0.0168 0.0144 0.0174 0.0194 0.0163 0.0149

PROFUNDIDAD HIDRAULICA ESFUERZO CORTANTE

(m) 0.0245 0.0185 0.0196 0.0162 0.0174 0.0146

(Kg/m2) 12.25 53.25 179.88 94.99 70.55 139.21

NUMERO DE FROUDE

FLUJO

1.12 1.02 1.04 0.99 1.01 0.97

SUPER CRITICO SUPER CRITICO SUPER CRITICO SUB CRITICO SUPER CRITICO SUB CRITICO

0.0195 0.0218 0.0153 0.0193 0.0162 0.0201 0.0229 0.0186 0.0168

55.71 122.83 117.75 43.69 94.99 57.14 128.47 143.89 227.88

1.04 1.07 0.98 1.04 0.99 1.05 1.09 1.03 1.00

SUPER CRITICO SUPER CRITICO SUB CRITICO SUPER CRITICO SUB CRITICO SUPER CRITICO SUPER CRITICO SUPER CRITICO SUB CRITICO

ESCALA EN EL EJE CAMARA

(m) 0.1450 0.1450 0.1450 0.1450 0.1450 0.1450

0.1450 0.1450 0.1450 0.1450 0.1450 0.1450 0.1450 0.1450 0.1450

More Documents from "Linda Rodriguez"