alc..impr.xls

16
TRAMO LONGITUD(m) POBLACION COEF. HARMON GASTOS(lps) Tramo Tributaria Total Qmed Qmin QMax Prev 41-50 115 0 115 111 3.800 1.500 1.500 6.840 50-53 115 115 230 222 3.800 1.500 1.500 6.840 53-52 115 230 345 332 3.800 1.500 1.500 6.840 52-129 90 345 435 419 3.800 1.500 1.500 6.840 129-128 95 435 530 511 3.800 1.500 1.500 6.840 130-127 88 0 88 84 3.800 1.500 1.500 6.840 131-126 88 0 88 84 3.800 1.500 1.500 6.840 41-40 115 0 115 111 3.800 1.500 1.500 6.840 172-39 88 0 88 84 3.800 1.500 1.500 6.840 41-37 115 0 115 111 3.800 1.500 1.500 6.840 36-37 19 0 19 18 3.800 1.500 1.500 6.840 37-38 115 134 249 240 3.800 1.500 1.500 6.840 112-111 87 0 87 84 3.800 1.500 1.500 6.840 114-113 68 0 68 65 3.800 1.500 1.500 6.840 97-96 75 0 75 72 3.800 1.500 1.500 6.840 96-94 75 75 150 145 3.800 1.500 1.500 6.840 95-94 68 0 68 65 3.800 1.500 1.500 6.840 94-92 75 218 293 282 3.800 1.500 1.500 6.840 93-92 68 0 68 65 3.800 1.500 1.500 6.840 92-113 75 360 435 419 3.800 1.500 1.500 6.840 113-110 20 503 523 503 3.800 1.500 1.500 6.840 110-111 95 523 618 595 3.800 1.500 1.500 6.840 111-38 40 705 745 718 3.800 1.500 1.500 6.840 38-39 55 994 1049 1011 3.797 1.500 1.500 6.835 39-40 60 1136 1196 1153 3.759 1.500 1.500 6.767 40-132 35 1311 1346 1297 3.724 1.500 1.500 6.704 50-51 115 115 230 222 3.800 1.500 1.500 6.840 52-51 115 345 460 443 3.800 1.500 1.500 6.840 51-132 80 690 770 742 3.800 1.500 1.500 6.840 132-125 95 2116 2211 2131 3.564 2.066 1.500 8.834 96-89 75 75 150 145 3.800 1.500 1.500 6.840 89-88 75 150 225 217 3.800 1.500 1.500 6.840 88-87 75 225 300 289 3.800 1.500 1.500 6.840 89-90 75 150 225 217 3.800 1.500 1.500 6.840 94-90 75 218 293 282 3.800 1.500 1.500 6.840 90-87 75 518 593 571 3.800 1.500 1.500 6.840 87-86 75 893 968 932 3.800 1.500 1.500 6.840 90-91 75 518 593 571 3.800 1.500 1.500 6.840 92-91 75 360 435 419 3.800 1.500 1.500 6.840 91-86 75 1028 1103 1062 3.783 1.500 1.500 6.809 86-85 75 2070 2145 2067 3.575 2.003 1.500 8.594 85-125 60 2145 2205 2125 3.565 2.060 1.500 8.811 125-126 95 4416 4511 4347 3.301 4.214 2.107 16.690 126-127 95 4599 4694 4523 3.285 4.384 2.192 17.283 127-128 95 4781 4876 4699 3.270 4.555 2.277 17.872 128-68 30 5406 5436 5239 3.226 5.078 2.539 19.658 129-66 45 435 480 463 3.800 1.500 1.500 6.840 65-64 128 0 128 123 3.800 1.500 1.500 6.840 64-66 135 128 263 253 3.800 1.500 1.500 6.840 66-67 95 743 838 807 3.800 1.500 1.500 6.840 67-68 15 838 853 821 3.800 1.500 1.500 6.840 68-69 75 6289 6364 6132 3.162 5.944 2.972 22.552 134-74 68 0 68 65 3.800 1.500 1.500 6.840 76-75 68 0 68 65 3.800 1.500 1.500 6.840 133-79 68 0 68 65 3.800 1.500 1.500 6.840 81-80 68 0 68 65 3.800 1.500 1.500 6.840 88-83 75 225 300 289 3.800 1.500 1.500 6.840 83-82 75 300 375 361 3.800 1.500 1.500 6.840 82-80 75 375 450 434 3.800 1.500 1.500 6.840 85-84 75 2145 2220 2139 3.563 2.074 1.500 8.865 83-84 75 300 375 361 3.800 1.500 1.500 6.840 87-84 75 893 968 932 3.800 1.500 1.500 6.840 84-80 75 3563 3638 3505 3.384 3.398 1.699 13.797 80-79 75 4155 4230 4076 3.326 3.951 1.975 15.769 79-75 75 4298 4373 4213 3.313 4.084 2.042 16.237

Upload: cajamarcaperu

Post on 04-Jan-2016

5 views

Category:

Documents


2 download

DESCRIPTION

.

TRANSCRIPT

Page 1: Alc..Impr.xls

TRAMO LONGITUD(m) POBLACION COEF. HARMON GASTOS(lps)

Tramo Tributaria Total Qmed Qmin QMax Prev

41-50 115 0 115 111 3.800 1.500 1.500 6.84050-53 115 115 230 222 3.800 1.500 1.500 6.84053-52 115 230 345 332 3.800 1.500 1.500 6.84052-129 90 345 435 419 3.800 1.500 1.500 6.840

129-128 95 435 530 511 3.800 1.500 1.500 6.840130-127 88 0 88 84 3.800 1.500 1.500 6.840131-126 88 0 88 84 3.800 1.500 1.500 6.84041-40 115 0 115 111 3.800 1.500 1.500 6.840172-39 88 0 88 84 3.800 1.500 1.500 6.84041-37 115 0 115 111 3.800 1.500 1.500 6.84036-37 19 0 19 18 3.800 1.500 1.500 6.84037-38 115 134 249 240 3.800 1.500 1.500 6.840

112-111 87 0 87 84 3.800 1.500 1.500 6.840114-113 68 0 68 65 3.800 1.500 1.500 6.84097-96 75 0 75 72 3.800 1.500 1.500 6.84096-94 75 75 150 145 3.800 1.500 1.500 6.84095-94 68 0 68 65 3.800 1.500 1.500 6.84094-92 75 218 293 282 3.800 1.500 1.500 6.84093-92 68 0 68 65 3.800 1.500 1.500 6.84092-113 75 360 435 419 3.800 1.500 1.500 6.840

113-110 20 503 523 503 3.800 1.500 1.500 6.840110-111 95 523 618 595 3.800 1.500 1.500 6.840111-38 40 705 745 718 3.800 1.500 1.500 6.84038-39 55 994 1049 1011 3.797 1.500 1.500 6.83539-40 60 1136 1196 1153 3.759 1.500 1.500 6.76740-132 35 1311 1346 1297 3.724 1.500 1.500 6.70450-51 115 115 230 222 3.800 1.500 1.500 6.84052-51 115 345 460 443 3.800 1.500 1.500 6.84051-132 80 690 770 742 3.800 1.500 1.500 6.840

132-125 95 2116 2211 2131 3.564 2.066 1.500 8.83496-89 75 75 150 145 3.800 1.500 1.500 6.84089-88 75 150 225 217 3.800 1.500 1.500 6.84088-87 75 225 300 289 3.800 1.500 1.500 6.84089-90 75 150 225 217 3.800 1.500 1.500 6.84094-90 75 218 293 282 3.800 1.500 1.500 6.84090-87 75 518 593 571 3.800 1.500 1.500 6.84087-86 75 893 968 932 3.800 1.500 1.500 6.84090-91 75 518 593 571 3.800 1.500 1.500 6.84092-91 75 360 435 419 3.800 1.500 1.500 6.84091-86 75 1028 1103 1062 3.783 1.500 1.500 6.80986-85 75 2070 2145 2067 3.575 2.003 1.500 8.59485-125 60 2145 2205 2125 3.565 2.060 1.500 8.811

125-126 95 4416 4511 4347 3.301 4.214 2.107 16.690126-127 95 4599 4694 4523 3.285 4.384 2.192 17.283127-128 95 4781 4876 4699 3.270 4.555 2.277 17.872128-68 30 5406 5436 5239 3.226 5.078 2.539 19.658129-66 45 435 480 463 3.800 1.500 1.500 6.84065-64 128 0 128 123 3.800 1.500 1.500 6.84064-66 135 128 263 253 3.800 1.500 1.500 6.84066-67 95 743 838 807 3.800 1.500 1.500 6.84067-68 15 838 853 821 3.800 1.500 1.500 6.84068-69 75 6289 6364 6132 3.162 5.944 2.972 22.552134-74 68 0 68 65 3.800 1.500 1.500 6.84076-75 68 0 68 65 3.800 1.500 1.500 6.840133-79 68 0 68 65 3.800 1.500 1.500 6.84081-80 68 0 68 65 3.800 1.500 1.500 6.84088-83 75 225 300 289 3.800 1.500 1.500 6.84083-82 75 300 375 361 3.800 1.500 1.500 6.84082-80 75 375 450 434 3.800 1.500 1.500 6.84085-84 75 2145 2220 2139 3.563 2.074 1.500 8.86583-84 75 300 375 361 3.800 1.500 1.500 6.84087-84 75 893 968 932 3.800 1.500 1.500 6.84084-80 75 3563 3638 3505 3.384 3.398 1.699 13.79780-79 75 4155 4230 4076 3.326 3.951 1.975 15.76979-75 75 4298 4373 4213 3.313 4.084 2.042 16.237

Page 2: Alc..Impr.xls

75-74 75 4440 4515 4351 3.300 4.217 2.109 16.70274-69 75 4583 4658 4488 3.288 4.350 2.175 17.16569-70 52 11021 11074 10671 2.927 10.343 5.171 36.32470-71 75 11074 11149 10743 2.924 10.413 5.207 36.53474-73 75 4583 4658 4488 3.288 4.350 2.175 17.16575-77 75 4440 4515 4351 3.300 4.217 2.109 16.70279-78 75 4298 4373 4213 3.313 4.084 2.042 16.23782-78 75 375 450 434 3.800 1.500 1.500 6.84078-77 75 4823 4898 4719 3.268 4.574 2.287 17.94077-73 75 9413 9488 9142 2.993 8.862 4.431 31.83073-71 127 14145 14272 13753 2.816 13.331 6.665 45.0501-98 95 0 95 92 3.800 1.500 1.500 6.840

97-98 85 0 85 82 3.800 1.500 1.500 6.8401-2 104 0 104 100 3.800 1.500 1.500 6.8402-99 95 104 199 192 3.800 1.500 1.500 6.840

98-99 104 180 284 274 3.800 1.500 1.500 6.8402-3 95 104 199 192 3.800 1.500 1.500 6.840

3-100 95 199 294 283 3.800 1.500 1.500 6.84099-100 95 483 578 557 3.800 1.500 1.500 6.840

100-101 95 872 967 932 3.800 1.500 1.500 6.84018-7 20 0 20 19 3.800 1.500 1.500 6.8407-6 95 20 115 111 3.800 1.500 1.500 6.8406-5 95 115 210 202 3.800 1.500 1.500 6.8405-4 95 210 305 294 3.800 1.500 1.500 6.8403-4 95 199 294 283 3.800 1.500 1.500 6.840

4-101 95 599 694 669 3.800 1.500 1.500 6.8405-103 95 210 305 294 3.800 1.500 1.500 6.8406-124 95 115 210 202 3.800 1.500 1.500 6.8407-8 95 20 115 111 3.800 1.500 1.500 6.840

8-124 95 115 210 202 3.800 1.500 1.500 6.840124-104 44 420 464 447 3.800 1.500 1.500 6.840104-103 51 464 515 496 3.800 1.500 1.500 6.840103-102 24 820 844 813 3.800 1.500 1.500 6.840101-102 71 1661 1732 1669 3.645 1.618 1.500 7.078102-106 75 2576 2651 2555 3.501 2.476 1.500 10.403104-105 75 464 539 519 3.800 1.500 1.500 6.840116-115 68 0 68 65 3.800 1.500 1.500 6.840118-117 68 0 68 65 3.800 1.500 1.500 6.840117-115 75 68 143 137 3.800 1.500 1.500 6.840115-105 75 210 285 275 3.800 1.500 1.500 6.840105-106 75 824 899 866 3.800 1.500 1.500 6.840106-107 71 3550 3621 3490 3.386 3.382 1.691 13.742109-108 68 0 68 65 3.800 1.500 1.500 6.840110-108 55 523 578 556 3.800 1.500 1.500 6.840108-107 79 645 724 698 3.800 1.500 1.500 6.84036-107 135 0 135 130 3.800 1.500 1.500 6.840

101-107 75 1661 1736 1673 3.645 1.622 1.500 7.0938-9 86 115 201 194 3.800 1.500 1.500 6.840

9-119 75 201 276 266 3.800 1.500 1.500 6.840117-119 75 68 143 137 3.800 1.500 1.500 6.84015-16 115 0 115 111 3.800 1.500 1.500 6.84016-17 115 115 230 222 3.800 1.500 1.500 6.84018-17 191 0 191 184 3.800 1.500 1.500 6.84017-11 115 421 536 517 3.800 1.500 1.500 6.84016-13 115 115 230 222 3.800 1.500 1.500 6.84015-14 115 0 115 111 3.800 1.500 1.500 6.84014-13 115 115 230 222 3.800 1.500 1.500 6.84013-12 55 460 515 496 3.800 1.500 1.500 6.84012-11 60 515 575 554 3.800 1.500 1.500 6.84011-10 30 1111 1141 1100 3.773 1.500 1.500 6.7919-10 75 201 276 266 3.800 1.500 1.500 6.840

10-120 75 1417 1492 1438 3.693 1.500 1.500 6.647123-122 68 0 68 65 3.800 1.500 1.500 6.840122-121 75 68 143 137 3.800 1.500 1.500 6.84012-121 75 515 590 569 3.800 1.500 1.500 6.840

121-120 90 733 823 793 3.800 1.500 1.500 6.840119-120 75 419 494 476 3.800 1.500 1.500 6.840121-22 75 733 808 778 3.800 1.500 1.500 6.840

Page 3: Alc..Impr.xls

22-23 20 808 828 797 3.800 1.500 1.500 6.840154-153 40 0 40 39 3.800 1.500 1.500 6.840153-23 55 40 95 92 3.800 1.500 1.500 6.84023-24 95 923 1018 980 3.800 1.500 1.500 6.84025-24 88 0 88 84 3.800 1.500 1.500 6.84029-28 128 0 128 123 3.800 1.500 1.500 6.84030-28 95 0 95 92 3.800 1.500 1.500 6.84028-27 20 223 243 234 3.800 1.500 1.500 6.84027-26 115 243 358 344 3.800 1.500 1.500 6.840

154-161 95 0 95 92 3.800 1.500 1.500 6.84046-45 115 0 115 111 3.800 1.500 1.500 6.84045-161 60 115 175 169 3.800 1.500 1.500 6.840161-26 55 270 325 313 3.800 1.500 1.500 6.84026-24 40 683 723 696 3.800 1.500 1.500 6.84032-31 128 0 128 123 3.800 1.500 1.500 6.84030-31 40 0 40 39 3.800 1.500 1.500 6.84034-33 128 0 128 123 3.800 1.500 1.500 6.84031-33 35 168 203 195 3.800 1.500 1.500 6.84041-42 115 0 115 111 3.800 1.500 1.500 6.84042-35 115 115 230 222 3.800 1.500 1.500 6.84036-35 96 0 96 93 3.800 1.500 1.500 6.84035-33 40 326 366 353 3.800 1.500 1.500 6.84014-19 95 115 210 202 3.800 1.500 1.500 6.84019-20 95 210 305 294 3.800 1.500 1.500 6.840122-20 20 68 88 84 3.800 1.500 1.500 6.84022-21 75 808 883 850 3.800 1.500 1.500 6.84020-21 55 393 448 431 3.800 1.500 1.500 6.84053-54 115 230 345 332 3.800 1.500 1.500 6.84050-49 115 115 230 222 3.800 1.500 1.500 6.840

Page 4: Alc..Impr.xls

42-49 115 115 230 222 3.800 1.500 1.500 6.84049-54 115 460 575 554 3.800 1.500 1.500 6.84046-47 115 0 115 111 3.800 1.500 1.500 6.84047-48 115 115 230 222 3.800 1.500 1.500 6.84049-48 115 460 575 554 3.800 1.500 1.500 6.84042-43 115 115 230 222 3.800 1.500 1.500 6.84030-43 115 0 115 111 3.800 1.500 1.500 6.84043-48 115 345 460 443 3.800 1.500 1.500 6.84048-56 115 1265 1380 1330 3.717 1.500 1.500 6.69047-57 115 115 230 222 3.800 1.500 1.500 6.84057-56 115 230 345 332 3.800 1.500 1.500 6.84056-55 18 1725 1743 1680 3.643 1.628 1.500 7.11954-55 97 920 1017 980 3.800 1.500 1.500 6.84055-61 135 2760 2895 2790 3.469 2.704 1.500 11.25657-58 115 230 345 332 3.800 1.500 1.500 6.84046-58 115 0 115 111 3.800 1.500 1.500 6.84058-59 45 460 505 487 3.800 1.500 1.500 6.84059-60 90 505 595 573 3.800 1.500 1.500 6.84060-61 248 595 843 813 3.800 1.500 1.500 6.84061-62 97 3738 3835 3695 3.364 3.582 1.791 14.45964-62 95 128 223 214 3.800 1.500 1.500 6.84054-62 135 920 1055 1017 3.795 1.500 1.500 6.83245-44 115 115 230 222 3.800 1.500 1.500 6.84043-44 115 345 460 443 3.800 1.500 1.500 6.84027-44 115 243 358 344 3.800 1.500 1.500 6.84047-44 115 115 230 222 3.800 1.500 1.500 6.840

160-155 88 0 88 84 3.800 1.500 1.500 6.840154-155 95 0 95 92 3.800 1.500 1.500 6.840159-156 88 0 88 84 3.800 1.500 1.500 6.840155-156 95 183 278 267 3.800 1.500 1.500 6.840158-157 88 0 88 84 3.800 1.500 1.500 6.840156-157 95 365 460 443 3.800 1.500 1.500 6.840157-135 50 548 598 576 3.800 1.500 1.500 6.84059-135 95 505 600 578 3.800 1.500 1.500 6.840

170-169 68 0 68 65 3.800 1.500 1.500 6.840171-169 41 0 41 39 3.800 1.500 1.500 6.840169-168 122 108 230 222 3.800 1.500 1.500 6.840135-136 75 1198 1273 1226 3.741 1.500 1.500 6.734149-148 68 0 68 65 3.800 1.500 1.500 6.840150-147 68 0 68 65 3.800 1.500 1.500 6.840151-146 68 0 68 65 3.800 1.500 1.500 6.840152-145 68 0 68 65 3.800 1.500 1.500 6.840153-144 75 40 115 111 3.800 1.500 1.500 6.84019-142 95 210 305 294 3.800 1.500 1.500 6.840

142-143 95 305 400 385 3.800 1.500 1.500 6.84021-143 40 1330 1370 1320 3.719 1.500 1.500 6.694

143-144 35 1770 1805 1739 3.632 1.686 1.500 7.348144-145 75 1920 1995 1922 3.599 1.863 1.500 8.048145-146 75 2063 2138 2060 3.576 1.996 1.500 8.567146-147 75 2205 2280 2197 3.554 2.130 1.500 9.081147-148 75 2348 2423 2334 3.533 2.263 1.500 9.592148-137 40 2490 2530 2438 3.517 2.363 1.500 9.974137-136 35 2530 2565 2472 3.512 2.396 1.500 10.098136-168 75 3838 3913 3770 3.356 3.654 1.827 14.718162-141 88 0 88 84 3.800 1.500 1.500 6.840142-141 95 305 400 385 3.800 1.500 1.500 6.840141-140 145 488 633 609 3.800 1.500 1.500 6.840163-140 88 0 88 84 3.800 1.500 1.500 6.840140-139 40 720 760 732 3.800 1.500 1.500 6.840139-138 135 760 895 862 3.800 1.500 1.500 6.840137-138 135 2530 2665 2568 3.499 2.489 1.500 10.451138-164 86 3560 3646 3513 3.383 3.406 1.703 13.826168-167 25 4143 4168 4016 3.332 3.893 1.946 15.563167-165 221 4168 4389 4229 3.312 4.099 2.050 16.289164-165 135 3646 3781 3643 3.369 3.532 1.766 14.27971-72 30 25421 25451 24525 2.564 23.772 11.886 73.13662-63 100 5113 5213 5023 3.243 4.869 2.434 18.948

165-166 60 8170 8230 7930 3.054 7.687 3.843 28.170

Page 5: Alc..Impr.xls

TRAMO COTAS TERRENO(m) PENDIENTE(m/km) DIAMETRO Coef. Rug.Manning

Inicial Final Terreno Propuesta Cálculo (cm) Comercial (cm) Pulg.

41-50 2240.000 2239.080 8.000 9 10.212 20 8" 0.01050-53 2239.080 2233.200 51.130 51 7.419 20 8" 0.01053-52 2233.200 2227.780 47.130 47 7.533 20 8" 0.01052-129 2227.780 2222.070 63.444 63 7.131 20 8" 0.010

129-128 2222.070 2216.030 63.579 64 7.110 20 8" 0.010130-127 2227.000 2217.120 112.914 113 6.391 20 8" 0.010131-126 2225.960 2218.210 88.571 89 6.683 20 8" 0.01041-40 2240.000 2226.990 113.130 116 6.355 20 8" 0.010172-39 2231.050 2227.250 43.429 43 7.660 20 8" 0.01041-37 2240.000 2236.560 29.913 30 8.211 20 8" 0.01036-37 2238.410 2236.560 97.780 98 6.564 25 10" 0.01037-38 2236.560 2228.750 67.913 68 7.029 25 10" 0.010

112-111 2236.770 2230.000 77.375 77 6.867 20 8" 0.010114-113 2243.250 2237.360 87.259 87 6.712 20 8" 0.01097-96 2255.310 2250.260 67.333 67 7.049 20 8" 0.01096-94 2250.260 2247.650 34.800 35 7.961 20 8" 0.01095-94 2252.300 2247.650 68.889 69 7.010 20 8" 0.01094-92 2247.650 2242.940 62.800 63 7.131 20 8" 0.01093-92 2248.390 2242.940 80.741 81 6.802 20 8" 0.01092-113 2242.940 2237.360 74.400 74 6.919 20 8" 0.010

113-110 2237.360 2236.030 66.500 66 7.069 20 8" 0.010110-111 2236.030 2230.000 63.474 63 7.131 20 8" 0.010111-38 2230.000 2228.750 31.250 31 8.145 20 8" 0.01038-39 2228.750 2227.250 27.273 27 8.356 25 10" 0.01039-40 2227.250 2226.990 4.333 13 9.594 25 10" 0.01040-132 2226.990 2226.030 27.429 23 8.539 25 10" 0.01050-51 2239.080 2226.550 108.957 107 6.452 20 8" 0.01052-51 2227.780 2226.550 10.696 10 10.069 20 8" 0.01051-132 2226.550 2226.030 6.500 11 9.912 20 8" 0.010

132-125 2226.030 2220.280 60.526 61 7.896 25 10" 0.01096-89 2250.260 2243.960 84.000 84 6.756 20 8" 0.01089-88 2243.960 2236.640 97.600 98 6.564 20 8" 0.01088-87 2236.640 2235.990 8.667 13 9.633 20 8" 0.01089-90 2243.960 2241.790 28.933 29 8.247 20 8" 0.01094-90 2247.650 2241.790 78.133 78 6.851 20 8" 0.01090-87 2241.790 2235.990 77.333 80 6.824 20 8" 0.01087-86 2235.990 2234.170 24.267 24 8.545 20 8" 0.01090-91 2241.790 2238.100 49.200 49 7.475 20 8" 0.01092-91 2242.940 2238.100 64.533 64 7.110 20 8" 0.01091-86 2238.100 2234.170 52.400 52 7.379 20 8" 0.01086-85 2234.170 2227.150 93.600 94 7.206 20 8" 0.01085-125 2227.150 2220.280 114.500 114 7.016 20 8" 0.010

125-126 2220.280 2218.210 21.789 21 12.242 25 10" 0.010126-127 2218.210 2217.120 11.474 11 14.002 25 10" 0.010127-128 2217.120 2216.030 11.474 11 14.179 25 10" 0.010128-68 2216.030 2215.030 33.333 39 11.615 25 10" 0.010129-66 2222.070 2218.900 70.444 83 6.767 20 8" 0.01065-64 2232.600 2219.640 101.647 102 6.514 20 8" 0.01064-66 2219.640 2218.900 5.481 9 10.185 20 8" 0.01066-67 2218.900 2215.130 39.684 34 8.019 20 8" 0.01067-68 2215.130 2215.030 6.667 18 9.039 20 8" 0.01068-69 2215.030 2211.840 42.533 40 12.151 25 10" 0.010134-74 2216.340 2212.390 58.519 59 7.219 20 8" 0.01076-75 2217.380 2213.300 60.444 60 7.196 20 8" 0.010133-79 2217.530 2214.980 37.778 38 7.840 20 8" 0.01081-80 2219.380 2218.620 11.259 14 9.464 20 8" 0.01088-83 2236.640 2226.990 128.667 128 6.243 20 8" 0.01083-82 2226.990 2219.180 104.133 104 6.491 20 8" 0.01082-80 2219.180 2218.620 7.467 10 10.142 20 8" 0.01085-84 2227.150 2226.250 12.000 12 10.725 20 8" 0.01083-84 2226.990 2226.250 9.867 10 10.069 20 8" 0.01087-84 2235.990 2226.250 129.867 130 6.225 20 8" 0.01084-80 2226.250 2218.620 101.733 104 8.450 20 8" 0.01080-79 2218.620 2214.980 48.533 49 10.224 20 8" 0.01079-75 2214.980 2213.300 22.400 22 12.011 20 8" 0.010

Page 6: Alc..Impr.xls

75-74 2213.300 2212.390 12.133 12 13.600 20 8" 0.01074-69 2212.390 2211.840 7.333 7 15.202 20 8" 0.01069-70 2211.840 2210.830 19.363 19 16.698 25 10" 0.01070-71 2210.830 2207.670 42.133 42 14.421 25 10" 0.01074-73 2212.390 2209.920 32.933 33 11.366 20 8" 0.01075-77 2213.300 2210.890 32.133 32 11.316 20 8" 0.01079-78 2214.980 2213.920 14.133 14 13.074 20 8" 0.01082-78 2219.180 2213.920 70.133 70 6.991 20 8" 0.01078-77 2213.920 2210.890 40.400 40 11.147 20 8" 0.01077-73 2210.890 2209.920 12.933 13 17.063 20 8" 0.01073-71 2209.920 2207.670 17.694 17 18.483 20 8" 0.0101-98 2258.520 2252.390 64.526 65 7.089 20 8" 0.010

97-98 2255.310 2252.390 34.434 34 8.005 20 8" 0.0101-2 2258.520 2254.290 40.626 41 7.729 20 8" 0.0102-99 2254.290 2246.520 81.789 81 6.802 20 8" 0.010

98-99 2252.390 2246.520 56.377 56 7.290 20 8" 0.0102-3 2254.290 2248.940 56.316 56 7.290 20 8" 0.010

3-100 2248.940 2239.580 98.526 98 6.564 20 8" 0.01099-100 2246.520 2239.580 73.053 73 6.936 20 8" 0.010

100-101 2239.580 2236.480 32.632 33 8.050 20 8" 0.01018-7 2255.090 2254.910 9.000 9 10.270 20 8" 0.0107-6 2254.910 2250.100 50.632 51 7.419 20 8" 0.0106-5 2250.100 2247.170 30.842 28 8.280 20 8" 0.0105-4 2247.170 2247.010 1.684 10 10.151 20 8" 0.0103-4 2248.940 2247.010 20.316 21 8.777 20 8" 0.010

4-101 2247.010 2236.480 110.842 105 6.479 20 8" 0.0105-103 2247.170 2237.200 104.947 107 6.461 20 8" 0.0106-124 2250.100 2243.620 68.211 67 7.049 20 8" 0.0107-8 2254.910 2249.060 61.579 62 7.152 20 8" 0.010

8-124 2249.060 2243.620 57.263 57 7.266 20 8" 0.010124-104 2243.620 2239.360 96.995 97 6.576 20 8" 0.010104-103 2239.360 2237.200 42.287 42 7.694 20 8" 0.010103-102 2237.200 2236.060 47.659 64 7.118 20 8" 0.010101-102 2236.480 2236.060 5.909 11 10.092 20 8" 0.010102-106 2236.060 2229.980 81.067 76 8.061 20 8" 0.010104-105 2239.360 2233.490 78.267 78 6.851 20 8" 0.010116-115 2246.010 2240.600 80.148 80 6.818 20 8" 0.010118-117 2248.570 2245.060 52.000 52 7.392 20 8" 0.010117-115 2245.060 2240.600 59.467 59 7.219 20 8" 0.010115-105 2240.600 2233.490 94.800 95 6.602 20 8" 0.010105-106 2233.490 2229.980 46.800 47 7.533 20 8" 0.010106-107 2229.980 2228.950 14.491 14 12.281 20 8" 0.010109-108 2238.070 2231.870 91.852 92 6.642 20 8" 0.010110-108 2236.030 2231.870 75.636 75 6.901 20 8" 0.010108-107 2231.870 2228.950 36.999 37 7.879 20 8" 0.01036-107 2238.410 2228.950 70.074 70 6.991 20 8" 0.010

101-107 2236.480 2228.950 100.400 100 6.629 20 8" 0.0108-9 2249.060 2245.930 36.362 36 7.919 20 8" 0.010

9-119 2245.930 2239.730 82.667 83 6.771 20 8" 0.010117-119 2245.060 2239.730 71.067 71 6.973 20 8" 0.01015-16 2260.000 2256.170 33.304 35 7.952 20 8" 0.01016-17 2256.170 2252.970 27.826 28 8.302 20 8" 0.01018-17 2255.090 2252.970 11.095 11 9.891 20 8" 0.01017-11 2252.970 2244.960 69.652 69 7.010 20 8" 0.01016-13 2256.170 2249.740 55.913 56 7.290 20 8" 0.01015-14 2260.000 2252.900 61.739 63 7.120 20 8" 0.01014-13 2252.900 2249.740 27.478 27 8.358 20 8" 0.01013-12 2249.740 2246.950 50.727 50 7.446 20 8" 0.01012-11 2246.950 2244.960 33.167 33 8.050 20 8" 0.01011-10 2244.960 2244.340 20.667 21 8.738 20 8" 0.0109-10 2245.930 2244.340 21.200 21 8.762 20 8" 0.010

10-120 2244.340 2228.950 205.200 205 5.654 20 8" 0.010123-122 2250.390 2244.560 86.370 86 6.726 20 8" 0.010122-121 2244.560 2236.950 101.467 101 6.527 20 8" 0.01012-121 2246.950 2236.950 133.333 133 6.198 20 8" 0.010

121-120 2236.950 2228.950 88.889 89 6.683 20 8" 0.010119-120 2239.730 2228.950 143.733 143 6.115 20 8" 0.010121-22 2236.950 2234.560 31.867 32 8.092 20 8" 0.010

Page 7: Alc..Impr.xls

22-23 2234.560 2231.380 159.000 158 6.001 20 8" 0.010154-153 2240.000 2238.310 42.250 42 7.694 20 8" 0.010153-23 2238.310 2231.380 126.000 126 6.262 20 8" 0.01023-24 2231.380 2228.360 31.789 32 8.096 20 8" 0.01025-24 2235.190 2228.360 78.057 78 6.851 20 8" 0.01029-28 2244.250 2234.500 76.471 76 6.884 20 8" 0.01030-28 2235.360 2234.500 9.053 11 9.859 20 8" 0.01028-27 2234.500 2232.940 78.000 78 6.851 20 8" 0.01027-26 2232.940 2231.320 14.087 14 9.454 20 8" 0.010

154-161 2240.000 2234.640 56.421 56 7.290 20 8" 0.01046-45 2240.000 2238.440 13.565 14 9.454 20 8" 0.01045-161 2238.440 2234.640 63.333 63 7.131 20 8" 0.010161-26 2234.640 2231.320 60.364 60 7.196 20 8" 0.01026-24 2231.320 2228.360 74.000 74 6.919 20 8" 0.01032-31 2234.560 2231.600 23.216 23 8.613 20 8" 0.01030-31 2235.360 2231.600 94.000 99 6.549 20 8" 0.01034-33 2232.500 2229.910 20.314 20 8.842 20 8" 0.01031-33 2231.600 2229.910 48.286 48 7.504 20 8" 0.01041-42 2240.000 2236.160 33.391 33 8.050 20 8" 0.01042-35 2236.160 2235.090 9.304 9 10.270 20 8" 0.01036-35 2238.410 2235.090 34.555 34 8.005 20 8" 0.01035-33 2235.090 2229.910 129.500 130 6.225 20 8" 0.01014-19 2252.900 2245.650 76.316 76 6.884 20 8" 0.01019-20 2245.650 2241.890 39.579 39 7.801 20 8" 0.010122-20 2244.560 2241.890 133.500 132 6.207 20 8" 0.01022-21 2234.560 2233.970 7.867 10 10.012 20 8" 0.01020-21 2241.890 2233.970 144.000 144 6.107 20 8" 0.01053-54 2233.200 2227.070 53.304 53 7.365 20 8" 0.01050-49 2239.080 2233.100 52.000 50 7.435 20 8" 0.010

Page 8: Alc..Impr.xls

42-49 2236.160 2233.100 26.609 26 8.418 20 8" 0.01049-54 2233.100 2227.070 52.435 52 7.392 20 8" 0.01046-47 2240.000 2235.610 38.174 38 7.840 20 8" 0.01047-48 2235.610 2228.450 62.261 62 7.152 20 8" 0.01049-48 2233.100 2228.450 40.435 40 7.765 20 8" 0.01042-43 2236.160 2235.060 9.565 9 10.270 20 8" 0.01030-43 2235.360 2235.060 2.609 10 10.154 20 8" 0.01043-48 2235.060 2228.450 57.478 52 7.384 20 8" 0.01048-56 2228.450 2225.550 25.217 25 8.410 20 8" 0.01047-57 2235.610 2233.610 17.391 17 9.116 25 10" 0.01057-56 2233.610 2225.550 70.087 70 6.991 25 10" 0.01056-55 2225.550 2223.000 139.116 139 6.240 25 10" 0.01054-55 2227.070 2223.000 42.102 42 7.694 25 10" 0.01055-61 2223.000 2217.090 43.778 52 8.913 20 8" 0.01057-58 2233.610 2230.710 25.217 25 8.480 20 8" 0.01046-58 2240.000 2230.710 80.783 81 6.802 20 8" 0.01058-59 2230.710 2227.170 78.667 78 6.851 20 8" 0.01059-60 2227.170 2217.970 102.222 100 6.542 20 8" 0.01060-61 2217.970 2217.090 3.544 9 10.318 20 8" 0.01061-62 2217.090 2216.600 5.069 10 13.273 20 8" 0.01064-62 2219.640 2216.600 32.000 48 7.494 20 8" 0.01054-62 2227.070 2216.600 77.556 89 6.683 25 10" 0.01045-44 2238.440 2229.840 74.783 74 6.919 20 8" 0.01043-44 2235.060 2229.840 45.391 44 7.627 20 8" 0.01027-44 2232.940 2229.840 26.957 27 8.358 20 8" 0.01047-44 2235.610 2229.840 50.174 50 7.446 20 8" 0.010

160-155 2240.000 2235.360 53.029 53 7.365 20 8" 0.010154-155 2240.000 2235.360 48.842 48 7.504 20 8" 0.010159-156 2239.510 2231.540 91.086 91 6.656 20 8" 0.010155-156 2235.360 2231.540 40.211 40 7.765 20 8" 0.010158-157 2230.700 2225.030 64.800 65 7.089 20 8" 0.010156-157 2231.540 2225.030 68.526 69 7.010 20 8" 0.010157-135 2225.030 2221.090 78.800 78 6.851 20 8" 0.01059-135 2227.170 2221.090 64.000 64 7.110 20 8" 0.010

170-169 2223.510 2217.620 87.259 87 6.712 20 8" 0.010171-169 2218.950 2217.620 32.574 33 8.050 20 8" 0.010169-168 2217.620 2213.100 37.150 37 7.879 20 8" 0.010135-136 2221.090 2217.280 50.800 51 7.375 20 8" 0.010149-148 2226.240 2220.880 79.407 79 6.834 20 8" 0.010150-147 2231.200 2224.580 98.074 98 6.564 20 8" 0.010151-146 2234.100 2227.720 94.519 95 6.602 20 8" 0.010152-145 2238.770 2229.360 139.407 148 6.077 20 8" 0.010153-144 2238.310 2229.970 111.200 111 6.412 20 8" 0.01019-142 2245.650 2234.420 118.211 118 6.339 20 8" 0.010

142-143 2234.420 2231.460 31.158 31 8.145 20 8" 0.01021-143 2233.970 2231.460 62.750 62 7.094 20 8" 0.010

143-144 2231.460 2229.970 42.571 42 7.903 20 8" 0.010144-145 2229.970 2229.360 8.133 16 9.805 20 8" 0.010145-146 2229.360 2227.720 21.867 22 9.451 20 8" 0.010146-147 2227.720 2224.580 41.867 41 8.595 20 8" 0.010147-148 2224.580 2220.880 49.333 49 8.485 20 8" 0.010148-137 2220.880 2218.850 50.750 51 8.546 20 8" 0.010137-136 2218.850 2217.280 44.857 45 8.790 20 8" 0.010136-168 2217.280 2213.100 55.733 55 9.749 20 8" 0.010162-141 2228.940 2224.830 46.971 47 7.533 20 8" 0.010142-141 2234.420 2224.830 100.947 101 6.527 20 8" 0.010141-140 2224.830 2216.860 54.966 55 7.314 20 8" 0.010163-140 2224.580 2216.860 88.229 88 6.697 20 8" 0.010140-139 2216.860 2214.730 53.250 52 7.392 20 8" 0.010139-138 2214.730 2209.890 35.852 36 7.919 20 8" 0.010137-138 2218.850 2209.890 66.370 66 8.287 20 8" 0.010138-164 2209.890 2208.990 10.455 10 13.110 20 8" 0.010168-167 2213.100 2211.760 53.600 54 9.990 20 8" 0.010167-165 2211.760 2206.810 22.390 22 12.026 20 8" 0.010164-165 2208.990 2206.810 16.148 16 12.151 20 8" 0.01071-72 2207.670 2206.600 35.667 36 19.257 25 10" 0.01062-63 2216.600 2210.730 58.700 43 11.215 25 10" 0.010

165-166 2206.810 2205.700 18.500 19 15.180 25 10" 0.010

Page 9: Alc..Impr.xls

TRAMO TUBO LLENO RELACION DE GASTOS RELACION VELOCIDAD RELACION TIRANTES

Qll (lps) Vll (m/s) Qmin/Qll Qmax/Qll Vmin/Vll Vmax/Vll ymin/D ymax/D

41-50 42.842 1.321 0.035 0.160 0.469 0.732 0.128 0.27050-53 100.453 3.098 0.015 0.068 0.363 0.571 0.085 0.17753-52 96.434 2.974 0.016 0.071 0.367 0.578 0.087 0.18052-129 111.648 3.443 0.013 0.061 0.351 0.554 0.081 0.168

129-128 112.530 3.470 0.013 0.061 0.350 0.552 0.081 0.167130-127 149.527 4.611 0.010 0.046 0.321 0.508 0.071 0.146131-126 132.701 4.092 0.011 0.052 0.333 0.526 0.075 0.15441-40 151.793 4.681 0.010 0.045 0.320 0.505 0.070 0.145172-39 92.239 2.844 0.016 0.074 0.372 0.586 0.089 0.18441-37 76.652 2.364 0.020 0.089 0.393 0.618 0.097 0.20236-37 252.476 4.983 0.006 0.027 0.274 0.434 0.055 0.11337-38 210.310 4.151 0.007 0.033 0.290 0.458 0.060 0.124

112-111 123.431 3.806 0.012 0.055 0.341 0.537 0.077 0.160114-113 131.202 4.046 0.011 0.052 0.334 0.528 0.075 0.15597-96 115.138 3.550 0.013 0.059 0.348 0.549 0.080 0.16596-94 83.217 2.566 0.018 0.082 0.384 0.604 0.093 0.19495-94 116.843 3.603 0.013 0.059 0.346 0.546 0.079 0.16494-92 111.648 3.443 0.013 0.061 0.351 0.554 0.081 0.16893-92 126.597 3.904 0.012 0.054 0.338 0.533 0.076 0.15892-113 121.003 3.731 0.012 0.057 0.343 0.540 0.078 0.161

113-110 114.275 3.524 0.013 0.060 0.349 0.550 0.080 0.166110-111 111.648 3.443 0.013 0.061 0.351 0.554 0.081 0.168111-38 78.318 2.415 0.019 0.087 0.391 0.615 0.096 0.20038-39 132.522 2.615 0.011 0.052 0.333 0.526 0.075 0.15439-40 90.769 1.791 0.017 0.075 0.374 0.587 0.089 0.18540-132 122.692 2.421 0.012 0.055 0.341 0.535 0.078 0.15950-51 145.788 4.496 0.010 0.047 0.324 0.511 0.072 0.14752-51 44.482 1.372 0.034 0.154 0.463 0.724 0.126 0.26551-132 46.387 1.430 0.032 0.147 0.458 0.716 0.123 0.259

132-125 199.192 3.931 0.008 0.044 0.295 0.503 0.062 0.14396-89 128.920 3.975 0.012 0.053 0.336 0.530 0.076 0.15789-88 139.249 4.294 0.011 0.049 0.328 0.518 0.073 0.15188-87 50.062 1.544 0.030 0.137 0.447 0.700 0.119 0.25089-90 75.749 2.336 0.020 0.090 0.395 0.621 0.098 0.20394-90 124.230 3.831 0.012 0.055 0.340 0.536 0.077 0.15990-87 125.517 3.870 0.012 0.054 0.339 0.535 0.077 0.15987-86 68.910 2.125 0.022 0.099 0.406 0.638 0.102 0.21390-91 98.464 3.036 0.015 0.069 0.365 0.575 0.086 0.17892-91 112.530 3.470 0.013 0.061 0.350 0.552 0.081 0.16791-86 101.434 3.128 0.015 0.067 0.361 0.569 0.085 0.17686-85 136.378 4.205 0.011 0.063 0.330 0.558 0.074 0.17085-125 150.187 4.631 0.010 0.059 0.321 0.546 0.071 0.164

125-126 116.874 2.307 0.018 0.143 0.384 0.709 0.093 0.255126-127 84.587 1.669 0.026 0.204 0.428 0.786 0.111 0.307127-128 84.587 1.669 0.027 0.211 0.433 0.793 0.113 0.312128-68 158.371 3.125 0.016 0.124 0.370 0.681 0.088 0.238129-66 128.352 3.958 0.012 0.053 0.337 0.531 0.076 0.15765-64 142.072 4.381 0.011 0.048 0.326 0.515 0.072 0.14964-66 43.143 1.330 0.035 0.159 0.468 0.731 0.128 0.26966-67 81.638 2.517 0.018 0.084 0.386 0.607 0.094 0.19667-68 59.324 1.829 0.025 0.115 0.425 0.667 0.110 0.22968-69 161.118 3.180 0.018 0.140 0.386 0.705 0.094 0.253134-74 108.045 3.332 0.014 0.063 0.355 0.559 0.082 0.17176-75 108.957 3.360 0.014 0.063 0.354 0.558 0.082 0.170133-79 86.710 2.674 0.017 0.079 0.379 0.596 0.091 0.19081-80 52.472 1.618 0.029 0.130 0.441 0.691 0.116 0.24488-83 159.142 4.907 0.009 0.043 0.315 0.498 0.069 0.14183-82 143.449 4.423 0.010 0.048 0.325 0.514 0.072 0.14982-80 43.637 1.346 0.034 0.157 0.466 0.728 0.127 0.26885-84 48.727 1.503 0.031 0.182 0.451 0.760 0.120 0.28983-84 44.482 1.372 0.034 0.154 0.463 0.724 0.126 0.26587-84 160.380 4.946 0.009 0.043 0.315 0.497 0.068 0.14184-80 143.189 4.415 0.012 0.096 0.338 0.633 0.076 0.21080-79 98.464 3.036 0.020 0.160 0.396 0.733 0.098 0.27179-75 65.977 2.034 0.031 0.246 0.452 0.828 0.121 0.338

Page 10: Alc..Impr.xls

75-74 48.727 1.503 0.043 0.343 0.499 0.906 0.142 0.40474-69 37.216 1.148 0.058 0.461 0.546 0.980 0.164 0.47769-70 111.169 2.194 0.047 0.327 0.510 0.895 0.147 0.39370-71 165.284 3.262 0.032 0.221 0.454 0.803 0.122 0.31974-73 80.805 2.492 0.027 0.212 0.433 0.794 0.113 0.31375-77 79.571 2.454 0.026 0.210 0.431 0.792 0.112 0.31179-78 52.631 1.623 0.039 0.308 0.483 0.881 0.135 0.38182-78 117.687 3.629 0.013 0.058 0.346 0.545 0.079 0.16478-77 88.963 2.743 0.026 0.202 0.427 0.783 0.110 0.30577-73 50.717 1.564 0.087 0.628 0.615 1.056 0.200 0.57473-71 57.997 1.788 0.115 0.777 0.666 1.105 0.229 0.6621-98 113.406 3.497 0.013 0.060 0.349 0.551 0.081 0.167

97-98 82.020 2.529 0.018 0.083 0.385 0.606 0.094 0.1951-2 90.068 2.777 0.017 0.076 0.375 0.590 0.090 0.1862-99 126.597 3.904 0.012 0.054 0.338 0.533 0.076 0.158

98-99 105.263 3.246 0.014 0.065 0.357 0.563 0.083 0.1732-3 105.263 3.246 0.014 0.065 0.357 0.563 0.083 0.173

3-100 139.249 4.294 0.011 0.049 0.328 0.518 0.073 0.15199-100 120.182 3.706 0.012 0.057 0.343 0.542 0.078 0.162

100-101 80.805 2.492 0.019 0.085 0.387 0.609 0.095 0.19718-7 42.199 1.301 0.036 0.162 0.471 0.735 0.129 0.2727-6 100.453 3.098 0.015 0.068 0.363 0.571 0.085 0.1776-5 74.945 2.311 0.020 0.091 0.396 0.623 0.098 0.2045-4 43.535 1.342 0.034 0.157 0.466 0.729 0.127 0.2683-4 64.165 1.979 0.023 0.107 0.415 0.651 0.106 0.220

4-101 144.160 4.445 0.010 0.047 0.325 0.513 0.072 0.1485-103 145.239 4.479 0.010 0.047 0.324 0.512 0.072 0.1486-124 115.138 3.550 0.013 0.059 0.348 0.549 0.080 0.1657-8 110.758 3.415 0.014 0.062 0.352 0.555 0.081 0.169

8-124 106.198 3.275 0.014 0.064 0.357 0.562 0.083 0.172124-104 138.537 4.272 0.011 0.049 0.329 0.519 0.073 0.151104-103 91.160 2.811 0.016 0.075 0.373 0.588 0.089 0.185103-102 112.168 3.459 0.013 0.061 0.351 0.553 0.081 0.167101-102 45.759 1.411 0.033 0.155 0.459 0.726 0.124 0.266102-106 122.446 3.776 0.012 0.085 0.341 0.610 0.078 0.197104-105 124.230 3.831 0.012 0.055 0.340 0.536 0.077 0.159116-115 125.813 3.880 0.012 0.054 0.339 0.534 0.077 0.158118-117 101.434 3.128 0.015 0.067 0.361 0.569 0.085 0.176117-115 108.045 3.332 0.014 0.063 0.355 0.559 0.082 0.171115-105 137.101 4.228 0.011 0.050 0.330 0.521 0.074 0.152105-106 96.434 2.974 0.016 0.071 0.367 0.578 0.087 0.180106-107 52.631 1.623 0.032 0.261 0.457 0.841 0.123 0.349109-108 134.919 4.160 0.011 0.051 0.332 0.523 0.074 0.153110-108 121.818 3.756 0.012 0.056 0.342 0.539 0.078 0.161108-107 85.562 2.638 0.018 0.080 0.381 0.599 0.092 0.19136-107 117.687 3.629 0.013 0.058 0.346 0.545 0.079 0.164

101-107 140.663 4.338 0.011 0.050 0.327 0.522 0.073 0.1538-9 84.398 2.603 0.018 0.081 0.382 0.601 0.093 0.193

9-119 128.150 3.952 0.012 0.053 0.337 0.531 0.076 0.157117-119 118.525 3.655 0.013 0.058 0.345 0.544 0.079 0.16315-16 83.475 2.574 0.018 0.082 0.383 0.603 0.093 0.19416-17 74.432 2.295 0.020 0.092 0.397 0.624 0.098 0.20518-17 46.653 1.439 0.032 0.147 0.457 0.715 0.123 0.25917-11 116.843 3.603 0.013 0.059 0.346 0.546 0.079 0.16416-13 105.263 3.246 0.014 0.065 0.357 0.563 0.083 0.17315-14 112.071 3.456 0.013 0.061 0.351 0.553 0.081 0.16814-13 73.091 2.254 0.021 0.094 0.399 0.627 0.099 0.20713-12 99.464 3.067 0.015 0.069 0.364 0.573 0.086 0.17812-11 80.805 2.492 0.019 0.085 0.387 0.609 0.095 0.19711-10 64.460 1.988 0.023 0.105 0.414 0.649 0.105 0.2199-10 64.460 1.988 0.023 0.106 0.414 0.651 0.105 0.220

10-120 201.399 6.210 0.007 0.033 0.294 0.460 0.061 0.124123-122 130.445 4.022 0.011 0.052 0.335 0.529 0.075 0.156122-121 141.365 4.359 0.011 0.048 0.327 0.516 0.073 0.15012-121 162.220 5.002 0.009 0.042 0.314 0.495 0.068 0.140

121-120 132.701 4.092 0.011 0.052 0.333 0.526 0.075 0.154119-120 168.208 5.187 0.009 0.041 0.310 0.490 0.067 0.138121-22 79.684 2.457 0.019 0.086 0.389 0.611 0.095 0.198

Page 11: Alc..Impr.xls

22-23 176.811 5.452 0.008 0.039 0.305 0.483 0.065 0.134154-153 91.160 2.811 0.016 0.075 0.373 0.588 0.089 0.185153-23 157.894 4.869 0.010 0.043 0.316 0.499 0.069 0.14223-24 79.571 2.454 0.019 0.086 0.389 0.612 0.095 0.19825-24 124.230 3.831 0.012 0.055 0.340 0.536 0.077 0.15929-28 122.627 3.781 0.012 0.056 0.341 0.538 0.078 0.16030-28 47.057 1.451 0.032 0.145 0.456 0.713 0.122 0.25828-27 124.230 3.831 0.012 0.055 0.340 0.536 0.077 0.15927-26 52.631 1.623 0.029 0.130 0.441 0.690 0.116 0.243

154-161 105.263 3.246 0.014 0.065 0.357 0.563 0.083 0.17346-45 52.631 1.623 0.029 0.130 0.441 0.690 0.116 0.24345-161 111.648 3.443 0.013 0.061 0.351 0.554 0.081 0.168161-26 108.957 3.360 0.014 0.063 0.354 0.558 0.082 0.17026-24 121.003 3.731 0.012 0.057 0.343 0.540 0.078 0.16132-31 67.460 2.080 0.022 0.101 0.409 0.642 0.103 0.21530-31 140.103 4.320 0.011 0.049 0.328 0.517 0.073 0.15034-33 62.906 1.940 0.024 0.109 0.418 0.655 0.107 0.22331-33 97.454 3.005 0.015 0.070 0.366 0.576 0.087 0.17941-42 80.805 2.492 0.019 0.085 0.387 0.609 0.095 0.19742-35 42.199 1.301 0.036 0.162 0.471 0.735 0.129 0.27236-35 82.020 2.529 0.018 0.083 0.385 0.606 0.094 0.19535-33 160.380 4.946 0.009 0.043 0.315 0.497 0.068 0.14114-19 122.627 3.781 0.012 0.056 0.341 0.538 0.078 0.16019-20 87.844 2.709 0.017 0.078 0.378 0.594 0.091 0.189122-20 161.609 4.983 0.009 0.042 0.314 0.496 0.068 0.14022-21 45.164 1.393 0.033 0.151 0.461 0.721 0.125 0.26320-21 168.796 5.205 0.009 0.041 0.310 0.489 0.067 0.13753-54 102.404 3.158 0.015 0.067 0.360 0.568 0.085 0.17550-49 99.880 3.080 0.015 0.068 0.363 0.572 0.086 0.177

Page 12: Alc..Impr.xls

42-49 71.724 2.212 0.021 0.095 0.401 0.631 0.100 0.20949-54 101.434 3.128 0.015 0.067 0.361 0.569 0.085 0.17646-47 86.710 2.674 0.017 0.079 0.379 0.596 0.091 0.19047-48 110.758 3.415 0.014 0.062 0.352 0.555 0.081 0.16949-48 88.963 2.743 0.017 0.077 0.376 0.592 0.090 0.18842-43 42.199 1.301 0.036 0.162 0.471 0.735 0.129 0.27230-43 43.504 1.341 0.034 0.157 0.466 0.729 0.127 0.26843-48 101.715 3.137 0.015 0.067 0.361 0.569 0.085 0.17648-56 70.331 2.169 0.021 0.095 0.404 0.630 0.101 0.20847-57 105.155 2.075 0.014 0.065 0.358 0.563 0.083 0.17357-56 213.381 4.211 0.007 0.032 0.288 0.456 0.060 0.12356-55 300.686 5.934 0.005 0.024 0.260 0.417 0.051 0.10654-55 165.284 3.262 0.009 0.041 0.312 0.493 0.067 0.13955-61 101.338 3.125 0.015 0.111 0.362 0.659 0.085 0.22557-58 70.331 2.169 0.021 0.097 0.404 0.634 0.101 0.21146-58 126.597 3.904 0.012 0.054 0.338 0.533 0.076 0.15858-59 124.230 3.831 0.012 0.055 0.340 0.536 0.077 0.15959-60 140.482 4.332 0.011 0.049 0.328 0.517 0.073 0.15060-61 41.677 1.285 0.036 0.164 0.472 0.738 0.130 0.27461-62 45.014 1.388 0.040 0.321 0.487 0.891 0.136 0.39064-62 97.774 3.015 0.015 0.070 0.366 0.576 0.086 0.17954-62 240.371 4.744 0.006 0.028 0.278 0.440 0.057 0.11645-44 121.003 3.731 0.012 0.057 0.343 0.540 0.078 0.16143-44 93.305 2.877 0.016 0.073 0.371 0.584 0.088 0.18327-44 73.091 2.254 0.021 0.094 0.399 0.627 0.099 0.20747-44 99.464 3.067 0.015 0.069 0.364 0.573 0.086 0.178

160-155 102.404 3.158 0.015 0.067 0.360 0.568 0.085 0.175154-155 97.454 3.005 0.015 0.070 0.366 0.576 0.087 0.179159-156 134.184 4.138 0.011 0.051 0.332 0.524 0.074 0.153155-156 88.963 2.743 0.017 0.077 0.376 0.592 0.090 0.188158-157 113.406 3.497 0.013 0.060 0.349 0.551 0.081 0.167156-157 116.843 3.603 0.013 0.059 0.346 0.546 0.079 0.164157-135 124.230 3.831 0.012 0.055 0.340 0.536 0.077 0.15959-135 112.530 3.470 0.013 0.061 0.350 0.552 0.081 0.167

170-169 131.202 4.046 0.011 0.052 0.334 0.528 0.075 0.155171-169 80.805 2.492 0.019 0.085 0.387 0.609 0.095 0.197169-168 85.562 2.638 0.018 0.080 0.381 0.599 0.092 0.191135-136 100.453 3.098 0.015 0.067 0.363 0.568 0.085 0.175149-148 125.024 3.855 0.012 0.055 0.339 0.535 0.077 0.159150-147 139.249 4.294 0.011 0.049 0.328 0.518 0.073 0.151151-146 137.101 4.228 0.011 0.050 0.330 0.521 0.074 0.152152-145 171.032 5.274 0.009 0.040 0.309 0.488 0.066 0.137153-144 148.198 4.570 0.010 0.046 0.322 0.509 0.071 0.14619-142 152.799 4.712 0.010 0.045 0.319 0.504 0.070 0.144

142-143 78.318 2.415 0.019 0.087 0.391 0.615 0.096 0.20021-143 110.758 3.415 0.014 0.060 0.352 0.551 0.081 0.167

143-144 91.160 2.811 0.016 0.081 0.373 0.600 0.089 0.192144-145 56.190 1.733 0.027 0.143 0.432 0.710 0.112 0.256145-146 65.977 2.034 0.023 0.130 0.412 0.690 0.104 0.243146-147 90.068 2.777 0.017 0.101 0.375 0.641 0.090 0.214147-148 98.464 3.036 0.015 0.097 0.365 0.635 0.086 0.211148-137 100.453 3.098 0.015 0.099 0.363 0.638 0.085 0.213137-136 94.360 2.910 0.016 0.107 0.369 0.652 0.088 0.221136-168 104.318 3.217 0.018 0.141 0.380 0.707 0.092 0.254162-141 96.434 2.974 0.016 0.071 0.367 0.578 0.087 0.180142-141 141.365 4.359 0.011 0.048 0.327 0.516 0.073 0.150141-140 104.318 3.217 0.014 0.066 0.358 0.565 0.084 0.174163-140 131.954 4.069 0.011 0.052 0.334 0.527 0.075 0.155140-139 101.434 3.128 0.015 0.067 0.361 0.569 0.085 0.176139-138 84.398 2.603 0.018 0.081 0.382 0.601 0.093 0.193137-138 114.275 3.524 0.013 0.091 0.349 0.623 0.080 0.204138-164 44.482 1.372 0.038 0.311 0.481 0.883 0.134 0.383168-167 103.366 3.187 0.019 0.151 0.389 0.720 0.095 0.262167-165 65.977 2.034 0.031 0.247 0.452 0.828 0.121 0.339164-165 56.265 1.735 0.031 0.254 0.453 0.835 0.121 0.34371-72 153.023 3.020 0.078 0.478 0.594 0.989 0.189 0.48762-63 167.629 3.308 0.015 0.113 0.360 0.663 0.084 0.227

165-166 111.169 2.194 0.035 0.253 0.467 0.834 0.127 0.343

Page 13: Alc..Impr.xls

TRAMO VELOCIDAD (m/s) TIRANTE (cm) COTA CLAVE (m) COTA BATEA (m)

Vmin Vmax ymin ymax Inicial Final Inicial Final

41-50 0.619 0.967 2.602 5.490 2238.750 2237.683 2238.547 2237.48050-53 1.123 1.769 1.733 3.591 2237.865 2232.000 2237.662 2231.79753-52 1.091 1.719 1.767 3.664 2231.985 2226.580 2231.782 2226.37752-129 1.209 1.906 1.649 3.411 2226.540 2220.870 2226.337 2220.667

129-128 1.216 1.916 1.642 3.398 2220.870 2214.790 2220.667 2214.587130-127 1.482 2.340 1.436 2.960 2225.800 2215.913 2225.597 2215.709131-126 1.364 2.152 1.519 3.136 2224.760 2216.973 2224.557 2216.76941-40 1.497 2.365 1.426 2.938 2238.785 2225.393 2238.582 2225.190172-39 1.058 1.666 1.805 3.745 2229.813 2226.050 2229.609 2225.84741-37 0.930 1.462 1.970 4.102 2238.750 2235.335 2238.547 2235.13236-37 1.366 2.162 1.403 2.876 2237.210 2235.356 2236.956 2235.10237-38 1.203 1.902 1.529 3.139 2235.335 2227.515 2235.081 2227.261

112-111 1.297 2.045 1.572 3.248 2235.537 2228.800 2235.334 2228.597114-113 1.353 2.135 1.527 3.153 2242.033 2236.160 2241.829 2235.95797-96 1.235 1.947 1.625 3.360 2254.085 2249.060 2253.882 2248.85796-94 0.985 1.549 1.895 3.939 2249.060 2246.435 2248.857 2246.23295-94 1.248 1.968 1.613 3.336 2251.100 2246.443 2250.897 2246.23994-92 1.209 1.906 1.649 3.411 2246.435 2241.710 2246.232 2241.50793-92 1.320 2.082 1.553 3.208 2247.190 2241.723 2246.987 2241.51992-113 1.279 2.017 1.587 3.280 2241.710 2236.160 2241.507 2235.957

113-110 1.229 1.937 1.630 3.372 2236.150 2234.830 2235.947 2234.627110-111 1.209 1.906 1.649 3.411 2234.785 2228.800 2234.582 2228.597111-38 0.944 1.484 1.950 4.059 2228.790 2227.550 2228.587 2227.34738-39 0.872 1.376 1.900 3.921 2227.515 2226.030 2227.261 2225.77639-40 0.670 1.051 2.273 4.693 2226.153 2225.393 2225.899 2225.13940-132 0.826 1.296 1.971 4.032 2225.393 2224.583 2225.139 2224.32950-51 1.456 2.299 1.453 2.996 2237.683 2225.330 2237.480 2225.12752-51 0.636 0.994 2.555 5.386 2226.500 2225.350 2226.297 2225.14751-132 0.654 1.024 2.504 5.273 2225.453 2224.583 2225.250 2224.380

132-125 1.158 1.977 1.568 3.645 2224.830 2219.035 2224.576 2218.78196-89 1.336 2.109 1.540 3.180 2249.060 2242.760 2248.857 2242.55789-88 1.410 2.226 1.485 3.063 2242.760 2235.410 2242.557 2235.20788-87 0.690 1.081 2.414 5.073 2235.543 2234.593 2235.340 2234.39089-90 0.922 1.450 1.981 4.126 2242.760 2240.585 2242.557 2240.38294-90 1.302 2.054 1.567 3.238 2246.435 2240.585 2246.232 2240.38290-87 1.312 2.069 1.560 3.222 2240.565 2234.593 2240.362 2234.39087-86 0.863 1.356 2.073 4.324 2234.770 2232.970 2234.567 2232.76790-91 1.107 1.744 1.750 3.627 2240.565 2236.890 2240.362 2236.68792-91 1.216 1.916 1.642 3.398 2241.700 2236.900 2241.497 2236.69791-86 1.131 1.779 1.725 3.566 2236.870 2232.970 2236.667 2232.76786-85 1.390 2.347 1.500 3.458 2232.970 2225.920 2232.767 2225.71785-125 1.486 2.531 1.433 3.339 2225.920 2219.080 2225.717 2218.877

125-126 0.885 1.636 2.369 6.485 2219.005 2217.010 2218.751 2216.756126-127 0.715 1.311 2.816 7.789 2216.965 2215.920 2216.711 2215.666127-128 0.723 1.324 2.868 7.926 2215.875 2214.830 2215.621 2214.576128-68 1.158 2.128 2.240 6.043 2214.790 2213.633 2214.536 2213.379129-66 1.332 2.102 1.543 3.187 2220.850 2217.103 2220.647 2216.90065-64 1.430 2.258 1.471 3.034 2231.400 2218.393 2231.197 2218.19064-66 0.622 0.972 2.593 5.470 2218.373 2217.103 2218.170 2216.90066-67 0.972 1.528 1.912 3.976 2217.100 2213.900 2216.897 2213.69767-68 0.777 1.219 2.226 4.659 2213.900 2213.633 2213.697 2213.43068-69 1.229 2.242 2.395 6.420 2213.633 2210.640 2213.379 2210.386134-74 1.182 1.862 1.674 3.466 2215.140 2211.158 2214.937 2210.95476-75 1.189 1.873 1.668 3.451 2216.150 2212.100 2215.947 2211.897133-79 1.013 1.595 1.858 3.860 2216.330 2213.765 2216.127 2213.56281-80 0.713 1.118 2.361 4.955 2218.163 2217.223 2217.959 2217.02088-83 1.548 2.445 1.395 2.872 2235.390 2225.790 2235.187 2225.58783-82 1.440 2.273 1.465 3.020 2225.780 2217.980 2225.577 2217.77782-80 0.627 0.980 2.579 5.439 2217.945 2217.223 2217.742 2217.02085-84 0.677 1.142 2.446 5.869 2225.920 2225.020 2225.717 2224.81783-84 0.636 0.994 2.555 5.386 2225.780 2225.030 2225.577 2224.82787-84 1.556 2.458 1.389 2.861 2234.770 2225.020 2234.567 2224.81784-80 1.493 2.793 1.554 4.261 2224.995 2217.223 2224.792 2217.02080-79 1.203 2.225 1.994 5.499 2217.420 2213.745 2217.217 2213.54279-75 0.919 1.684 2.452 6.867 2213.745 2212.095 2213.542 2211.892

Page 14: Alc..Impr.xls

75-74 0.750 1.362 2.881 8.204 2212.090 2211.190 2211.887 2210.98774-69 0.626 1.124 3.333 9.693 2211.158 2210.633 2210.954 2210.42969-70 1.119 1.963 3.730 9.990 2210.621 2209.630 2210.367 2209.37670-71 1.481 2.620 3.091 8.114 2209.620 2206.470 2209.366 2206.21674-73 1.079 1.979 2.294 6.358 2211.158 2208.683 2210.954 2208.47975-77 1.058 1.942 2.277 6.319 2212.090 2209.690 2211.887 2209.48779-78 0.784 1.430 2.734 7.747 2213.745 2212.695 2213.542 2212.49282-78 1.254 1.978 1.608 3.324 2217.945 2212.695 2217.742 2212.49278-77 1.172 2.147 2.244 6.189 2212.690 2209.690 2212.487 2209.48777-73 0.961 1.652 4.059 11.669 2209.690 2208.715 2209.487 2208.51273-71 1.191 1.976 4.651 13.458 2208.632 2206.470 2208.429 2206.2671-98 1.222 1.927 1.636 3.385 2257.320 2251.145 2257.117 2250.942

97-98 0.975 1.533 1.908 3.967 2254.073 2251.190 2253.870 2250.9871-2 1.041 1.638 1.825 3.789 2257.320 2253.051 2257.117 2252.8482-99 1.320 2.082 1.553 3.208 2253.015 2245.320 2252.812 2245.117

98-99 1.160 1.828 1.695 3.510 2251.145 2245.314 2250.942 2245.1112-3 1.160 1.828 1.695 3.510 2253.015 2247.695 2252.812 2247.492

3-100 1.410 2.226 1.485 3.063 2247.690 2238.380 2247.487 2238.17799-100 1.273 2.007 1.592 3.290 2245.314 2238.379 2245.111 2238.176

100-101 0.965 1.517 1.922 3.996 2238.379 2235.244 2238.176 2235.04118-7 0.612 0.957 2.621 5.532 2253.890 2253.710 2253.687 2253.5077-6 1.123 1.769 1.733 3.591 2253.710 2248.865 2253.507 2248.6626-5 0.915 1.439 1.992 4.148 2248.820 2246.123 2248.617 2245.9205-4 0.626 0.978 2.582 5.445 2246.123 2245.213 2245.920 2245.0103-4 0.821 1.289 2.144 4.480 2247.690 2245.713 2247.487 2245.510

4-101 1.445 2.281 1.461 3.012 2245.213 2235.235 2245.010 2235.0325-103 1.452 2.293 1.456 3.002 2246.123 2235.995 2245.920 2235.7926-124 1.235 1.947 1.625 3.360 2248.785 2242.420 2248.582 2242.2177-8 1.202 1.895 1.655 3.424 2253.710 2247.820 2253.507 2247.617

8-124 1.167 1.840 1.688 3.495 2247.820 2242.405 2247.617 2242.202124-104 1.405 2.218 1.489 3.071 2242.405 2238.145 2242.202 2237.942104-103 1.049 1.652 1.815 3.766 2238.145 2235.999 2237.942 2235.796103-102 1.213 1.912 1.645 3.403 2235.984 2234.463 2235.781 2234.260101-102 0.648 1.024 2.521 5.402 2235.215 2234.463 2235.012 2234.260102-106 1.289 2.302 1.578 4.004 2234.463 2228.780 2234.260 2228.577104-105 1.302 2.054 1.567 3.238 2238.140 2232.290 2237.937 2232.087116-115 1.314 2.073 1.558 3.218 2244.800 2239.400 2244.597 2239.197118-117 1.131 1.781 1.725 3.574 2247.370 2243.860 2247.167 2243.657117-115 1.182 1.862 1.674 3.466 2243.825 2239.400 2243.622 2239.197115-105 1.395 2.202 1.496 3.087 2239.400 2232.275 2239.197 2232.072105-106 1.091 1.719 1.767 3.664 2232.275 2228.750 2232.072 2228.547106-107 0.741 1.365 2.497 7.086 2228.745 2227.750 2228.542 2227.547109-108 1.379 2.177 1.507 3.111 2236.870 2230.660 2236.667 2230.457110-108 1.285 2.026 1.582 3.269 2234.785 2230.660 2234.582 2230.457108-107 1.004 1.580 1.870 3.885 2230.660 2227.740 2230.457 2227.53736-107 1.254 1.978 1.608 3.324 2237.200 2227.750 2236.997 2227.547

101-107 1.420 2.266 1.478 3.103 2235.215 2227.715 2235.012 2227.5128-9 0.995 1.565 1.882 3.912 2247.820 2244.721 2247.617 2244.518

9-119 1.331 2.100 1.545 3.189 2244.721 2238.496 2244.518 2238.293117-119 1.260 1.988 1.603 3.313 2243.825 2238.500 2243.622 2238.29715-16 0.987 1.553 1.892 3.933 2259.000 2254.950 2258.797 2254.74716-17 0.911 1.432 1.998 4.162 2254.950 2251.730 2254.747 2251.52718-17 0.657 1.028 2.498 5.258 2253.872 2251.770 2253.669 2251.56717-11 1.248 1.968 1.613 3.336 2251.695 2243.760 2251.492 2243.55716-13 1.160 1.828 1.695 3.510 2254.950 2248.510 2254.747 2248.30715-14 1.212 1.911 1.646 3.404 2259.003 2251.703 2258.800 2251.50014-13 0.899 1.413 2.015 4.200 2251.645 2248.540 2251.442 2248.33713-12 1.115 1.757 1.741 3.609 2248.500 2245.750 2248.297 2245.54712-11 0.965 1.517 1.922 3.996 2245.740 2243.760 2245.537 2243.55711-10 0.824 1.291 2.140 4.454 2243.760 2243.130 2243.557 2242.9279-10 0.824 1.293 2.140 4.470 2244.715 2243.140 2244.512 2242.937

10-120 1.823 2.859 1.248 2.529 2243.125 2227.750 2242.922 2227.547123-122 1.347 2.126 1.532 3.162 2249.165 2243.360 2248.962 2243.157122-121 1.425 2.250 1.475 3.041 2243.325 2235.750 2243.122 2235.54712-121 1.568 2.478 1.382 2.845 2245.725 2235.750 2245.522 2235.547

121-120 1.364 2.152 1.519 3.136 2235.750 2227.740 2235.547 2227.537119-120 1.609 2.542 1.359 2.796 2238.475 2227.750 2238.272 2227.547121-22 0.955 1.502 1.934 4.024 2235.750 2233.343 2235.547 2233.140

Page 15: Alc..Impr.xls

22-23 1.665 2.632 1.327 2.730 2233.340 2230.180 2233.137 2229.977154-153 1.049 1.652 1.815 3.766 2238.790 2237.110 2238.587 2236.907153-23 1.539 2.431 1.400 2.883 2237.110 2230.180 2236.907 2229.97723-24 0.954 1.501 1.936 4.027 2230.180 2227.140 2229.977 2226.93725-24 1.302 2.054 1.567 3.238 2233.985 2227.160 2233.782 2226.95729-28 1.291 2.036 1.577 3.258 2242.990 2233.300 2242.787 2233.09730-28 0.661 1.034 2.487 5.235 2234.363 2233.300 2234.160 2233.09728-27 1.302 2.054 1.567 3.238 2233.300 2231.740 2233.097 2231.53727-26 0.715 1.120 2.357 4.947 2231.730 2230.120 2231.527 2229.917

154-161 1.160 1.828 1.695 3.510 2238.760 2233.440 2238.557 2233.23746-45 0.715 1.120 2.357 4.947 2238.800 2237.190 2238.597 2236.98745-161 1.209 1.906 1.649 3.411 2237.190 2233.410 2236.987 2233.207161-26 1.189 1.873 1.668 3.451 2233.410 2230.110 2233.207 2229.90726-24 1.279 2.017 1.587 3.280 2230.110 2227.150 2229.907 2226.94732-31 0.850 1.336 2.094 4.370 2233.333 2230.400 2233.129 2230.19730-31 1.416 2.236 1.481 3.054 2234.363 2230.395 2234.160 2230.19234-33 0.810 1.271 2.165 4.525 2231.260 2228.710 2231.057 2228.50731-33 1.100 1.732 1.758 3.645 2230.390 2228.710 2230.187 2228.50741-42 0.965 1.517 1.922 3.996 2238.755 2234.960 2238.552 2234.75742-35 0.612 0.957 2.621 5.532 2234.925 2233.890 2234.722 2233.68736-35 0.975 1.533 1.908 3.967 2237.157 2233.890 2236.954 2233.68735-33 1.556 2.458 1.389 2.861 2233.890 2228.690 2233.687 2228.48714-19 1.291 2.036 1.577 3.258 2251.645 2244.425 2251.442 2244.22219-20 1.023 1.610 1.847 3.835 2244.395 2240.690 2244.192 2240.487122-20 1.564 2.471 1.385 2.851 2243.325 2240.685 2243.122 2240.48222-21 0.642 1.004 2.537 5.345 2233.513 2232.740 2233.310 2232.53720-21 1.612 2.548 1.356 2.791 2240.685 2232.765 2240.482 2232.56253-54 1.138 1.793 1.717 3.558 2231.965 2225.870 2231.762 2225.66750-49 1.119 1.762 1.738 3.601 2237.683 2231.885 2237.480 2231.682

Page 16: Alc..Impr.xls

42-49 0.888 1.395 2.034 4.239 2234.890 2231.900 2234.687 2231.69749-54 1.131 1.781 1.725 3.574 2231.850 2225.870 2231.647 2225.66746-47 1.013 1.595 1.858 3.860 2238.780 2234.410 2238.577 2234.20747-48 1.202 1.895 1.655 3.424 2234.380 2227.250 2234.177 2227.04749-48 1.032 1.624 1.836 3.812 2231.850 2227.250 2231.647 2227.04742-43 0.612 0.957 2.621 5.532 2234.890 2233.855 2234.687 2233.65230-43 0.626 0.978 2.583 5.447 2234.363 2233.263 2234.160 2233.06043-48 1.133 1.785 1.723 3.569 2233.263 2227.250 2233.060 2227.04748-56 0.876 1.367 2.053 4.234 2227.225 2224.350 2227.022 2224.14747-57 0.742 1.169 2.120 4.390 2234.365 2232.410 2234.111 2232.15657-56 1.215 1.922 1.519 3.117 2232.400 2224.350 2232.146 2224.09656-55 1.542 2.472 1.293 2.697 2224.348 2221.800 2224.094 2221.54654-55 1.017 1.607 1.712 3.525 2225.860 2221.800 2225.606 2221.54655-61 1.130 2.060 1.726 4.573 2221.800 2214.793 2221.597 2214.59057-58 0.876 1.376 2.053 4.280 2232.385 2229.510 2232.182 2229.30746-58 1.320 2.082 1.553 3.208 2238.780 2229.465 2238.577 2229.26258-59 1.302 2.054 1.567 3.238 2229.465 2225.955 2229.262 2225.75259-60 1.419 2.240 1.479 3.050 2225.950 2216.973 2225.747 2216.77060-61 0.607 0.949 2.637 5.568 2216.973 2214.793 2216.770 2214.59061-62 0.676 1.236 2.767 7.918 2214.793 2213.803 2214.590 2213.60064-62 1.102 1.736 1.755 3.639 2218.393 2213.803 2218.190 2213.60054-62 1.320 2.088 1.436 2.943 2225.795 2213.803 2225.541 2213.54945-44 1.279 2.017 1.587 3.280 2237.150 2228.640 2236.947 2228.43743-44 1.067 1.679 1.795 3.724 2233.690 2228.630 2233.487 2228.42727-44 0.899 1.413 2.015 4.200 2231.730 2228.625 2231.527 2228.42247-44 1.115 1.757 1.741 3.609 2234.365 2228.615 2234.162 2228.412

160-155 1.138 1.793 1.717 3.558 2238.798 2234.160 2238.594 2233.957154-155 1.100 1.732 1.758 3.645 2238.720 2234.160 2238.517 2233.957159-156 1.374 2.169 1.511 3.119 2238.303 2230.340 2238.099 2230.137155-156 1.032 1.624 1.836 3.812 2234.140 2230.340 2233.937 2230.137158-157 1.222 1.927 1.636 3.385 2229.500 2223.813 2229.297 2223.609156-157 1.248 1.968 1.613 3.336 2230.340 2223.785 2230.137 2223.582157-135 1.302 2.054 1.567 3.238 2223.785 2219.885 2223.582 2219.68259-135 1.216 1.916 1.642 3.398 2225.950 2219.870 2225.747 2219.667

170-169 1.353 2.135 1.527 3.153 2222.293 2216.420 2222.089 2216.217171-169 0.965 1.517 1.922 3.996 2217.750 2216.403 2217.547 2216.199169-168 1.004 1.580 1.870 3.885 2216.402 2211.900 2216.199 2211.697135-136 1.123 1.761 1.733 3.564 2219.870 2216.045 2219.667 2215.842149-148 1.308 2.064 1.563 3.228 2225.013 2219.680 2224.809 2219.477150-147 1.410 2.226 1.485 3.063 2229.995 2223.380 2229.792 2223.177151-146 1.395 2.202 1.496 3.087 2232.900 2226.488 2232.697 2226.284152-145 1.627 2.571 1.348 2.774 2237.543 2227.563 2237.339 2227.360153-144 1.473 2.325 1.442 2.972 2237.095 2228.770 2236.892 2228.56719-142 1.504 2.376 1.422 2.929 2244.395 2233.185 2244.192 2232.982

142-143 0.944 1.484 1.950 4.059 2233.185 2230.240 2232.982 2230.03721-143 1.202 1.883 1.655 3.388 2232.740 2230.260 2232.537 2230.057

143-144 1.049 1.687 1.815 3.901 2230.240 2228.770 2230.037 2228.567144-145 0.748 1.230 2.285 5.196 2228.760 2227.563 2228.557 2227.360145-146 0.837 1.404 2.116 4.945 2228.160 2226.510 2227.957 2226.307146-147 1.041 1.780 1.825 4.358 2226.455 2223.380 2226.252 2223.177147-148 1.107 1.927 1.750 4.284 2223.355 2219.680 2223.152 2219.477148-137 1.123 1.977 1.733 4.325 2219.680 2217.640 2219.477 2217.437137-136 1.075 1.898 1.785 4.489 2217.640 2216.065 2217.437 2215.862136-168 1.224 2.273 1.869 5.156 2216.025 2211.900 2215.822 2211.697162-141 1.091 1.719 1.767 3.664 2227.740 2223.628 2227.537 2223.424142-141 1.425 2.250 1.475 3.041 2233.185 2223.590 2232.982 2223.387141-140 1.153 1.817 1.702 3.526 2223.590 2215.615 2223.387 2215.412163-140 1.358 2.143 1.523 3.144 2223.360 2215.660 2223.157 2215.457140-139 1.131 1.781 1.725 3.574 2215.610 2213.530 2215.407 2213.327139-138 0.995 1.565 1.882 3.912 2213.530 2208.670 2213.327 2208.467137-138 1.229 2.195 1.630 4.152 2217.600 2208.690 2217.397 2208.487138-164 0.660 1.211 2.716 7.779 2208.651 2207.790 2208.448 2207.587168-167 1.239 2.295 1.935 5.329 2211.900 2210.550 2211.697 2210.347167-165 0.920 1.685 2.457 6.879 2210.474 2205.610 2210.271 2205.407164-165 0.787 1.448 2.469 6.980 2207.770 2205.610 2207.567 2205.40771-72 1.793 2.986 4.789 12.369 2206.470 2205.390 2206.216 2205.13662-63 1.189 2.192 2.138 5.766 2213.803 2209.483 2213.549 2209.229

165-166 1.024 1.831 3.233 8.718 2205.610 2204.470 2205.356 2204.216