calculo de red de distribucion cerrada.xlsx

26
RED DE DISTRIBUCION CERRADA Datos Poblacion 38950 habitantes Dotacion 250 litros/hab/Dia Calculo caudal de Diseño Caudal Promedio 112.703 Lt/seg caudal medio diario 146.513 Lt/seg caudal Horario 202.865 Lt/seg Caudal Diseño 1 176.513 Lt/seg Entonces el mayor Caudal Diseño 2 202.865 Lt/seg Calculo del consumo por tramos Tramo Area (Ha) Q diseño coeficiente Q por tramo (L/seg) EF 12.25 202.865 0.886 10.852 FA 25.00 202.865 0.886 22.147 AB 25.00 202.865 0.886 22.147 BC 6.25 202.865 0.886 5.537 CD 21.00 202.865 0.886 18.603 DE 35.00 202.865 0.886 31.006 EI 12.25 202.865 0.886 10.852 IH 36.00 202.865 0.886 31.891 HG 36.00 202.865 0.886 31.891 GC 20.25 202.865 0.886 17.939 Total 229 202.865 Cantidad de Caudal que pasa por cada tramo I CIRCUITO Res-A 202.865 A-F 100 A-F 22.147 A-B 102.865 A-B 22.147 F-E 10.852 E-D 31.006 D-C 18.603 E-F 67.001 B-C 80.718 II CIRCUITO E-I 10.852 E-I 35.996 I-H 25.144 I-H 31.891 B-C 5.537 C-G 56.578 C-G 17.939 G-H 38.639

Transcript of calculo de red de distribucion cerrada.xlsx

Page 1: calculo de red de distribucion cerrada.xlsx

RED DE DISTRIBUCION CERRADADatos

Poblacion 38950 habitantesDotacion 250 litros/hab/Dia

Calculo caudal de DiseñoCaudal Promedio 112.703 Lt/seg

caudal medio diario 146.513 Lt/segcaudal Horario 202.865 Lt/seg

Caudal Diseño 1 176.513 Lt/segEntonces el mayor

Caudal Diseño 2 202.865 Lt/seg

Calculo del consumo por tramosTramo Area (Ha) Q diseño coeficiente Q por tramo (L/seg)EF 12.25 202.865 0.886 10.852FA 25.00 202.865 0.886 22.147AB 25.00 202.865 0.886 22.147BC 6.25 202.865 0.886 5.537CD 21.00 202.865 0.886 18.603DE 35.00 202.865 0.886 31.006EI 12.25 202.865 0.886 10.852IH 36.00 202.865 0.886 31.891HG 36.00 202.865 0.886 31.891GC 20.25 202.865 0.886 17.939

Total 229 202.865

Cantidad de Caudal que pasa por cada tramo

I CIRCUITO

Res-A 202.865A-F 100A-F 22.147A-B 102.865A-B 22.147F-E 10.852E-D 31.006D-C 18.603E-F 67.001B-C 80.718

II CIRCUITO

E-I 10.852E-I 35.996I-H 25.144I-H 31.891B-C 5.537C-G 56.578C-G 17.939G-H 38.639

Page 2: calculo de red de distribucion cerrada.xlsx

II CIRCUITO

G-H 31.891

PRUEBADatos IH y GH 63.783Calc. IH y GH 63.783Diferencia 0.000

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140

Page 3: calculo de red de distribucion cerrada.xlsx

ICD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

Page 4: calculo de red de distribucion cerrada.xlsx

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140

Page 5: calculo de red de distribucion cerrada.xlsx

IICG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140

Page 6: calculo de red de distribucion cerrada.xlsx

I BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

Page 7: calculo de red de distribucion cerrada.xlsx

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

circuito Tramo Longitud (m) diametro (pulg) C

I

EF 700 10 140FA 1000 12 140AB 1000 12 140BC 500 10 140CD 300 6 140DE 500 6 140

II

ED 500 6 140

Page 8: calculo de red de distribucion cerrada.xlsx

II

DC 300 6 140CG 900 10 140GH 1200 10 140HI 1200 8 140IE 700 8 140

Page 9: calculo de red de distribucion cerrada.xlsx

Qdiseño 202.865 Lt/seg

Page 10: calculo de red de distribucion cerrada.xlsx

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-67.001 1.322 0.00600 -4.1989 0.0627

-100 1.371 0.00518 -5.1815 0.0518102.865 1.410 0.00546 5.4598 0.053180.718 1.593 0.00847 4.2344 0.052518.603 1.020 0.00673 2.0188 0.1085-31.006 1.700 0.01733 -8.6652 0.2795

-6.3326 0.608031.006 1.700 0.01733 8.6652 0.2795-18.603 1.020 0.00673 -2.0188 0.108556.578 1.117 0.00439 3.9471 0.069838.639 0.763 0.00216 2.5972 0.0672-25.144 0.775 0.00290 -3.4750 0.1382-35.996 1.110 0.00563 -3.9394 0.1094

5.776 0.773

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-61.371 1.211 0.00510 -3.5690 0.0582-94.370 1.293 0.00465 -4.6543 0.0493108.494 1.487 0.00603 6.0260 0.055586.348 1.704 0.00960 4.7975 0.055620.192 1.107 0.00783 2.3496 0.1164-29.417 1.613 0.01572 -7.8610 0.2672

-2.9111 0.602229.417 1.613 0.01572 7.8610 0.2672-20.192 1.107 0.00783 -2.3496 0.116452.537 1.037 0.00382 3.4410 0.065534.598 0.683 0.00176 2.1167 0.0612-29.185 0.900 0.00382 -4.5796 0.1569-40.037 1.235 0.00685 -4.7974 0.1198

1.692 0.787

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.758 1.160 0.00470 -3.2927 0.0560-91.757 1.258 0.00442 -4.4185 0.0482111.108 1.523 0.00630 6.2975 0.056788.961 1.756 0.01014 5.0699 0.0570

Page 11: calculo de red de distribucion cerrada.xlsx

21.643 1.186 0.00891 2.6719 0.1235-27.966 1.533 0.01432 -7.1580 0.2560

-0.8299 0.597327.966 1.533 0.01432 7.1580 0.2560-21.643 1.186 0.00891 -2.6719 0.123551.374 1.014 0.00367 3.3013 0.064333.436 0.660 0.00166 1.9870 0.0594-30.347 0.936 0.00410 -4.9230 0.1622-41.199 1.270 0.00723 -5.0584 0.1228

-0.207 0.788

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.007 1.145 0.00459 -3.2152 0.0554-91.006 1.247 0.00435 -4.3517 0.0478111.859 1.533 0.00638 6.3766 0.057089.712 1.770 0.01030 5.1494 0.057422.536 1.235 0.00960 2.8796 0.1278-27.073 1.484 0.01348 -6.7405 0.2490

0.0983 0.594427.073 1.484 0.01348 6.7405 0.2490-22.536 1.235 0.00960 -2.8796 0.127851.516 1.017 0.00369 3.3183 0.064433.578 0.663 0.00167 2.0026 0.0596-30.205 0.931 0.00407 -4.8804 0.1616-41.057 1.266 0.00718 -5.0262 0.1224

-0.725 0.785

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.096 1.147 0.00461 -3.2243 0.0555-91.095 1.248 0.00436 -4.3596 0.0479111.769 1.532 0.00637 6.3672 0.057089.623 1.769 0.01028 5.1399 0.057422.946 1.258 0.00992 2.9774 0.1298-26.663 1.462 0.01311 -6.5527 0.2458

0.3478 0.593226.663 1.462 0.01311 6.5527 0.2458-22.946 1.258 0.00992 -2.9774 0.129852.016 1.027 0.00375 3.3781 0.064934.077 0.673 0.00172 2.0581 0.0604-29.706 0.916 0.00394 -4.7321 0.1593-40.558 1.251 0.00702 -4.9136 0.1212

-0.634 0.781

Page 12: calculo de red de distribucion cerrada.xlsx

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.413 1.153 0.00465 -3.2570 0.0558-91.412 1.253 0.00439 -4.3878 0.0480111.452 1.527 0.00633 6.3338 0.056889.306 1.762 0.01021 5.1063 0.057223.068 1.265 0.01002 3.0067 0.1303-26.541 1.455 0.01299 -6.4973 0.2448

0.3047 0.592926.541 1.455 0.01299 6.4973 0.2448-23.068 1.265 0.01002 -3.0067 0.130352.455 1.035 0.00381 3.4310 0.065434.516 0.681 0.00176 2.1074 0.0611-29.267 0.902 0.00384 -4.6035 0.1573-40.119 1.237 0.00688 -4.8156 0.1200

-0.390 0.779

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.691 1.158 0.00469 -3.2857 0.0560-91.690 1.257 0.00441 -4.4125 0.0481111.175 1.524 0.00630 6.3046 0.056789.028 1.757 0.01015 5.0769 0.057023.061 1.264 0.01002 3.0050 0.1303-26.548 1.455 0.01300 -6.5006 0.2449

0.1877 0.593026.548 1.455 0.01300 6.5006 0.2449-23.061 1.264 0.01002 -3.0050 0.130352.725 1.041 0.00385 3.4639 0.065734.786 0.687 0.00178 2.1381 0.0615-28.996 0.894 0.00377 -4.5249 0.1561-39.848 1.229 0.00679 -4.7556 0.1193

-0.183 0.778

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.862 1.162 0.00472 -3.3035 0.0561-91.861 1.259 0.00443 -4.4278 0.0482111.004 1.521 0.00629 6.2866 0.056688.857 1.754 0.01012 5.0589 0.056923.160 1.270 0.01010 3.0291 0.1308-26.449 1.450 0.01291 -6.4555 0.2441

0.1878 0.592826.449 1.450 0.01291 6.4555 0.2441-23.160 1.270 0.01010 -3.0291 0.1308

Page 13: calculo de red de distribucion cerrada.xlsx

52.996 1.046 0.00389 3.4969 0.066035.057 0.692 0.00181 2.1691 0.0619-28.726 0.886 0.00371 -4.4470 0.1548-39.578 1.220 0.00671 -4.6960 0.1187

-0.051 0.776

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-59.034 1.165 0.00474 -3.3213 0.0563-92.032 1.261 0.00444 -4.4431 0.0483110.832 1.519 0.00627 6.2687 0.056688.685 1.750 0.01008 5.0408 0.056823.024 1.262 0.00999 2.9962 0.1301-26.584 1.457 0.01303 -6.5171 0.2451

0.0242 0.593226.584 1.457 0.01303 6.5171 0.2451-23.024 1.262 0.00999 -2.9962 0.130153.031 1.047 0.00389 3.5012 0.066035.092 0.693 0.00181 2.1731 0.0619-28.691 0.885 0.00370 -4.4369 0.1546-39.542 1.219 0.00670 -4.6882 0.1186

0.070 0.776

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-59.056 1.165 0.00475 -3.3236 0.0563-92.054 1.262 0.00445 -4.4450 0.0483110.810 1.519 0.00627 6.2663 0.056688.663 1.750 0.01008 5.0385 0.056822.953 1.258 0.00993 2.9792 0.1298-26.655 1.461 0.01310 -6.5493 0.2457

-0.0339 0.593426.655 1.461 0.01310 6.5493 0.2457-22.953 1.258 0.00993 -2.9792 0.129852.982 1.046 0.00388 3.4952 0.066035.043 0.692 0.00181 2.1675 0.0619-28.739 0.886 0.00371 -4.4509 0.1549-39.591 1.221 0.00671 -4.6989 0.1187

0.083 0.777

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-59.025 1.165 0.00474 -3.3204 0.0563-92.023 1.261 0.00444 -4.4423 0.0483110.841 1.519 0.00627 6.2696 0.0566

Page 14: calculo de red de distribucion cerrada.xlsx

88.694 1.750 0.01008 5.0418 0.056822.927 1.257 0.00991 2.9727 0.1297-26.682 1.463 0.01312 -6.5615 0.2459

-0.0401 0.593526.682 1.463 0.01312 6.5615 0.2459-22.927 1.257 0.00991 -2.9727 0.129752.925 1.044 0.00388 3.4882 0.065934.986 0.690 0.00180 2.1609 0.0618-28.797 0.888 0.00372 -4.4675 0.1551-39.649 1.223 0.00673 -4.7116 0.1188

0.059 0.777

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.988 1.164 0.00474 -3.3166 0.0562-91.987 1.261 0.00444 -4.4390 0.0483110.878 1.520 0.00627 6.2734 0.056688.731 1.751 0.01009 5.0456 0.056922.922 1.257 0.00991 2.9717 0.1296-26.687 1.463 0.01313 -6.5635 0.2459

-0.0284 0.593526.687 1.463 0.01313 6.5635 0.2459-22.922 1.257 0.00991 -2.9717 0.129652.884 1.044 0.00387 3.4832 0.065934.945 0.690 0.00180 2.1562 0.0617-28.838 0.889 0.00373 -4.4792 0.1553-39.690 1.224 0.00674 -4.7206 0.1189

0.031 0.777

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.962 1.164 0.00473 -3.3139 0.0562-91.961 1.260 0.00444 -4.4367 0.0482110.903 1.520 0.00628 6.2761 0.056688.757 1.752 0.01010 5.0483 0.056922.926 1.257 0.00991 2.9726 0.1297-26.682 1.463 0.01312 -6.5616 0.2459

-0.0151 0.593526.682 1.463 0.01312 6.5616 0.2459-22.926 1.257 0.00991 -2.9726 0.129752.862 1.043 0.00387 3.4805 0.065834.923 0.689 0.00179 2.1537 0.0617-28.860 0.890 0.00374 -4.4855 0.1554-39.712 1.225 0.00675 -4.7254 0.1190

0.012 0.778

Page 15: calculo de red de distribucion cerrada.xlsx

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.949 1.163 0.00473 -3.3125 0.0562-91.947 1.260 0.00444 -4.4355 0.0482110.917 1.520 0.00628 6.2776 0.056688.770 1.752 0.01010 5.0498 0.056922.932 1.257 0.00991 2.9739 0.1297-26.677 1.462 0.01312 -6.5593 0.2459

-0.0059 0.593526.677 1.462 0.01312 6.5593 0.2459-22.932 1.257 0.00991 -2.9739 0.129752.853 1.043 0.00387 3.4795 0.065834.914 0.689 0.00179 2.1528 0.0617-28.868 0.890 0.00374 -4.4880 0.1555-39.720 1.225 0.00675 -4.7273 0.1190

0.002 0.778

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.943 1.163 0.00473 -3.3119 0.0562-91.942 1.260 0.00443 -4.4350 0.0482110.923 1.520 0.00628 6.2781 0.056688.776 1.752 0.01010 5.0504 0.056922.935 1.257 0.00992 2.9748 0.1297-26.673 1.462 0.01312 -6.5575 0.2458

-0.0011 0.593526.673 1.462 0.01312 6.5575 0.2458-22.935 1.257 0.00992 -2.9748 0.129752.852 1.043 0.00387 3.4793 0.065834.913 0.689 0.00179 2.1526 0.0617-28.870 0.890 0.00374 -4.4884 0.1555-39.722 1.225 0.00675 -4.7277 0.1190

-0.002 0.778

caudal (lt/seg) Velocidad (m/seg) Pediente (S) perdida Hf Hf/Qp-58.942 1.163 0.00473 -3.3118 0.0562-91.941 1.260 0.00443 -4.4349 0.0482110.924 1.520 0.00628 6.2782 0.056688.777 1.752 0.01010 5.0505 0.056922.937 1.257 0.00992 2.9753 0.1297-26.671 1.462 0.01311 -6.5566 0.2458

0.0007 0.593526.671 1.462 0.01311 6.5566 0.2458

Page 16: calculo de red de distribucion cerrada.xlsx

-22.937 1.257 0.00992 -2.9753 0.129752.853 1.043 0.00387 3.4794 0.065834.914 0.689 0.00179 2.1527 0.0617-28.869 0.890 0.00374 -4.4881 0.1555-39.721 1.225 0.00675 -4.7275 0.1190

-0.002 0.778

Page 17: calculo de red de distribucion cerrada.xlsx
Page 18: calculo de red de distribucion cerrada.xlsx

Delta Q Q1 ITERACION5.630 -61.371

I

5.630 -94.3705.630 108.4945.630 86.3481.589 20.1921.589 -29.417

-1.589 29.417-1.589 -20.192-4.041 52.537-4.041 34.598-4.041 -29.185-4.041 -40.037

Delta Q Q1 ITERACION2.613 -58.758

II

2.613 -91.7572.613 111.1082.613 88.9611.451 21.6431.451 -27.966

-1.451 27.966-1.451 -21.643-1.162 51.374-1.162 33.436-1.162 -30.347-1.162 -41.199

Delta Q Q1 ITERACION0.751 -58.007

III

0.751 -91.0060.751 111.8590.751 89.712

Page 19: calculo de red de distribucion cerrada.xlsx

0.893 22.536

III

0.893 -27.073

-0.893 27.073-0.893 -22.5360.142 51.5160.142 33.5780.142 -30.2050.142 -41.057

Delta Q Q1 ITERACION-0.089 -58.096

IV

-0.089 -91.095-0.089 111.769-0.089 89.6230.410 22.9460.410 -26.663

-0.410 26.663-0.410 -22.9460.499 52.0160.499 34.0770.499 -29.7060.499 -40.558

Delta Q Q1 ITERACION-0.317 -58.413

V

-0.317 -91.412-0.317 111.452-0.317 89.3060.122 23.0680.122 -26.541

-0.122 26.541-0.122 -23.0680.439 52.4550.439 34.5160.439 -29.2670.439 -40.119

Page 20: calculo de red de distribucion cerrada.xlsx

Delta Q Q1 ITERACION-0.278 -58.691

VI

-0.278 -91.690-0.278 111.175-0.278 89.028-0.007 23.061-0.007 -26.548

0.007 26.5480.007 -23.0610.271 52.7250.271 34.7860.271 -28.9960.271 -39.848

Delta Q Q1 ITERACION-0.171 -58.862

VII

-0.171 -91.861-0.171 111.004-0.171 88.8570.100 23.1600.100 -26.449

-0.100 26.449-0.100 -23.1600.271 52.9960.271 35.0570.271 -28.7260.271 -39.578

Delta Q Q1 ITERACION-0.171 -59.034

VIII

-0.171 -92.032-0.171 110.832-0.171 88.685-0.136 23.024-0.136 -26.584

0.136 26.5840.136 -23.024

Page 21: calculo de red de distribucion cerrada.xlsx

0.035 53.031

VIII

0.035 35.0920.035 -28.6910.035 -39.542

Delta Q Q1 ITERACION-0.022 -59.056

IX

-0.022 -92.054-0.022 110.810-0.022 88.663-0.071 22.953-0.071 -26.655

0.071 26.6550.071 -22.953-0.049 52.982-0.049 35.043-0.049 -28.739-0.049 -39.591

Delta Q Q1 ITERACION0.031 -59.025

X

0.031 -92.0230.031 110.8410.031 88.694-0.027 22.927-0.027 -26.682

0.027 26.6820.027 -22.927-0.058 52.925-0.058 34.986-0.058 -28.797-0.058 -39.649

Delta Q Q1 ITERACION0.037 -58.988

XI

0.037 -91.9870.037 110.878

Page 22: calculo de red de distribucion cerrada.xlsx

0.037 88.731

XI

-0.004 22.922-0.004 -26.687

0.004 26.6870.004 -22.922-0.041 52.884-0.041 34.945-0.041 -28.838-0.041 -39.690

Delta Q Q1 ITERACION0.026 -58.962

XII

0.026 -91.9610.026 110.9030.026 88.7570.004 22.9260.004 -26.682

-0.004 26.682-0.004 -22.926-0.022 52.862-0.022 34.923-0.022 -28.860-0.022 -39.712

Delta Q Q1 ITERACION0.014 -58.949

XIII

0.014 -91.9470.014 110.9170.014 88.7700.005 22.9320.005 -26.677

-0.005 26.677-0.005 -22.932-0.009 52.853-0.009 34.914-0.009 -28.868-0.009 -39.720

Page 23: calculo de red de distribucion cerrada.xlsx

Delta Q Q1 ITERACION0.005 -58.943

XIV

0.005 -91.9420.005 110.9230.005 88.7760.004 22.9350.004 -26.673

-0.004 26.673-0.004 -22.935-0.002 52.852-0.002 34.913-0.002 -28.870-0.002 -39.722

Delta Q Q1 ITERACION0.001 -58.942

XV

0.001 -91.9410.001 110.9240.001 88.7770.002 22.9370.002 -26.671

-0.002 26.671-0.002 -22.9370.001 52.8530.001 34.9140.001 -28.8690.001 -39.721

Delta Q Q1 ITERACION-0.001 -58.943

XVI

-0.001 -91.942-0.001 110.923-0.001 88.7760.001 22.9380.001 -26.671

-0.001 26.671

Page 24: calculo de red de distribucion cerrada.xlsx

-0.001 -22.938

XVI

0.002 52.8540.002 34.9150.002 -28.8670.002 -39.719

Page 25: calculo de red de distribucion cerrada.xlsx

CALCULO DE LAS PRESIONES EN CADA PUNTOPUNTO Cota carga estatica Hf Presion

A 120 30B 98 52.00 6.28 45.72C 97 46.72 5.05 41.67G 95 43.67 3.48 40.19H 96.5 38.69 2.15 36.54I 95 38.04 -4.49 42.53E 97 40.53 -4.73 45.25F 98 44.25 -3.31 47.57A 120 25.57 -4.43 30.00

Caudal Diseño 202.865 Lt/seg

CALCULO DE LA LINEA DE ADUCCIONCota espejo Agua reservorio 158 msnm

Cota Terreno Reservorio 138 msnmLongitud Linea Aduccion 250 m

CALCULOSN numero de pisos de la edificacion 2

Presion para edificaciones 15Carga estatica RES-A 38Pendiente (S) (m/km) 60

Diametro Teorico (pulgadas) 9.49706Diametro Comercial (pulgadas)

Diametro 8 pulgadas entocnes vel. (m/seg) 6.256Diametro 10 pulgadas entocnes vel. (m/seg) 4.004

Page 26: calculo de red de distribucion cerrada.xlsx

OK