Diseño de tuberias método de Hardy Cross
24
Metodo de Hardy Cross Material de Tubería: PVC Rugosidad Abso 0.0000015 Liquido Transportado: Agua Densidad: ρ= 1000 kg/m3 Viscosidad Abs μ= 1.14E-03 Pa·s Viscosidad Cin ν= 1.14E-06 m2/s Iteración: 1 Circuito Tuberia NR f hf K hm Ni Nf (m/s) I 1 2 0.05000 200.00 0.20 1.59 279219.20 133333.33 0.01465 1.89 0.00 2 7 -0.05000 200.00 0.20 1.59 279219.20 133333.33 0.01465 1.89 0.00 6 7 -0.12000 200.00 0.20 3.82 670126.08 133333.33 0.01258 9.36 0.00 1 6 -0.05000 150.00 0.20 1.59 279219.20 133333.33 0.01465 1.42 0.00 Σ= II 2 3 0.10000 200.00 0.25 2.04 446750.72 166666.67 0.01345 2.28 0.00 3 8 -0.05000 150.00 0.25 1.02 223375.36 166666.67 0.01526 0.48 0.00 7 8 -0.19000 200.00 0.25 3.87 848826.36 166666.67 0.01207 7.38 0.00 2 7 0.05000 150.00 0.20 1.59 279219.20 133333.33 0.01465 1.42 0.00 Σ= III 3 4 0.35000 200.00 0.30 4.95 1303022.93 200000.00 0.01125 9.39 0.00 4 9 -0.15000 150.00 0.30 2.12 558438.40 200000.00 0.01292 1.48 0.00 8 9 -0.02000 200.00 0.25 0.41 89350.14 166666.67 0.01833 0.12 0.00 3 8 0.05000 150.00 0.25 1.02 223375.36 166666.67 0.01526 0.48 0.00 Σ= 6 7 0.12000 200.00 0.20 3.82 670126.08 133333.33 0.01258 9.36 0.00 ε= Caudal (m3/s) Longitud (m) Diámetro (m) Velocidad (m/s) 0,6<V<3 D/ε
-
Upload
yesser-esteban-lloclla-challco -
Category
Documents
-
view
487 -
download
12
Transcript of Diseño de tuberias método de Hardy Cross
Metodo de Hardy Cross
Material de Tubería: PVC
Rugosidad Absolu 0.0000015
Liquido Transportado: Agua
Densidad: ρ= 1000 kg/m3Viscosidad Absoluμ= 1.14E-03 Pa·sViscosidad Cinemáν= 1.14E-06 m2/s
Iteración: 1
CircuitoTuberia
NR f hf K hmNi Nf (m/s)
I
1 2 0.05000 200.00 0.20 1.59 279219.20 133333.33 0.01465 1.89 0.00 1.89384 37.88
2 7 -0.05000 200.00 0.20 1.59 279219.20 133333.33 0.01465 1.89 0.00 -1.89384 37.88
6 7 -0.12000 200.00 0.20 3.82 670126.08 133333.33 0.01258 9.36 0.00 -9.36177 78.01
1 6 -0.05000 150.00 0.20 1.59 279219.20 133333.33 0.01465 1.42 0.00 -1.42038 28.41
Σ= -10.78 182.18
II
2 3 0.10000 200.00 0.25 2.04 446750.72 166666.67 0.01345 2.28 0.00 2.27815 22.78
3 8 -0.05000 150.00 0.25 1.02 223375.36 166666.67 0.01526 0.48 0.00 -0.48474 9.69
7 8 -0.19000 200.00 0.25 3.87 848826.36 166666.67 0.01207 7.38 0.00 -7.38051 38.84
2 7 0.05000 150.00 0.20 1.59 279219.20 133333.33 0.01465 1.42 0.00 1.42038 28.41
Σ= -4.17 99.73
III
3 4 0.35000 200.00 0.30 4.95 1303022.93 200000.00 0.01125 9.39 0.00 9.38528 26.82
4 9 -0.15000 150.00 0.30 2.12 558438.40 200000.00 0.01292 1.48 0.00 -1.48449 9.90
8 9 -0.02000 200.00 0.25 0.41 89350.14 166666.67 0.01833 0.12 0.00 -0.12416 6.21
3 8 0.05000 150.00 0.25 1.02 223375.36 166666.67 0.01526 0.48 0.00 0.48474 9.69
Σ= 8.26 52.61
IV
6 7 0.12000 200.00 0.20 3.82 670126.08 133333.33 0.01258 9.36 0.00 9.36177 78.01
ε=
Caudal(m3/s)
Longitud(m)
Diámetro(m)
Velocidad(m/s)
0,6<V<3D/ε hf+Σhm (hf+Σhm)/Q
IV7 11 -0.12000 150.00 0.25 2.44 536100.86 166666.67 0.01303 2.38 0.00 -2.38383 19.87
10 11 -0.01000 200.00 0.25 0.20 44675.07 166666.67 0.02132 0.04 0.00 -0.03612 3.61
6 10 0.07000 150.00 0.20 2.23 390906.88 133333.33 0.01379 2.62 0.00 2.61992 37.43
Σ= 9.56 138.92
V
7 8 0.19000 200.00 0.25 3.87 848826.36 166666.67 0.01207 7.38 0.00 7.38051 38.84
8 12 0.12000 150.00 0.25 2.44 536100.86 166666.67 0.01303 2.38 0.00 2.38383 19.87
12 17 0.06000 150.00 0.30 0.85 223375.36 200000.00 0.01525 0.28 0.00 0.28034 4.67
16 17 -0.06000 200.00 0.30 0.85 223375.36 200000.00 0.01525 0.37 0.00 -0.37378 6.23
11 16 0.01000 150.00 0.30 0.14 37229.23 200000.00 0.02223 0.01 0.00 0.01135 1.13
7 11 0.12000 150.00 0.25 2.44 536100.86 166666.67 0.01303 2.38 0.00 2.38383 19.87
Σ= 12.07 90.61
VI
8 9 0.02000 200.00 0.25 0.41 89350.14 166666.67 0.01833 0.12 0.00 0.12416 6.21
9 13 -0.03000 150.00 0.30 0.42 111687.68 200000.00 0.01749 0.08 0.00 -0.08037 2.68
12 13 -0.06000 200.00 0.30 0.85 223375.36 200000.00 0.01525 0.37 0.00 -0.37378 6.23
8 12 -0.12000 150.00 0.25 2.44 536100.86 166666.67 0.01303 2.38 0.00 -2.38383 19.87
Σ= -2.71 34.98
VII
4 5 0.40000 200.00 0.40 3.18 1116876.79 266666.67 0.01150 2.97 0.00 2.97116 7.43
5 14 -0.20000 300.00 0.45 1.26 496389.69 300000.00 0.01316 0.71 0.00 -0.70792 3.54
13 14 -0.10000 200.00 0.40 0.80 279219.20 266666.67 0.01461 0.24 0.00 -0.23605 2.36
9 13 0.03000 150.00 0.30 0.42 111687.68 200000.00 0.01749 0.08 0.00 0.08037 2.68
4 9 0.15000 150.00 0.30
Σ= 2.11 16.01
VIII
10 11 0.01000 200.00 0.25 0.20 44675.07 166666.67 0.02132 0.04 0.00 0.03612 3.61
11 16 -0.01000 150.00 0.30 0.14 37229.23 200000.00 0.02223 0.01 0.00 -0.01135 1.13
15 16 -0.07000 200.00 0.20 2.23 390906.88 133333.33 0.01379 3.49 0.00 -3.49322 49.90
10 15 0.08000 150.00 0.25 1.63 357400.57 166666.67 0.01399 1.14 0.00 1.13772 14.22
Σ= -2.33 68.87
IX
12 13 0.06000 200.00 0.30 0.85 223375.36 200000.00 0.01525 0.37 0.00 0.37378 6.23
IX13 18 -0.07000 150.00 0.35 0.73 223375.36 233333.33 0.01525 0.18 0.00 -0.17646 2.52
17 18 -0.12000 200.00 0.30 1.70 446750.72 200000.00 0.01343 1.32 0.00 -1.31690 10.97
12 17 -0.06000 150.00 0.30 0.85 223375.36 200000.00 0.01525 0.28 0.00 -0.28034 4.67
Σ= -1.40 24.40
X
13 14 0.10000 200.00 0.40 0.80 279219.20 266666.67 0.01461 0.24 0.00 0.23605 2.36
14 20 -0.10000 150.00 0.40 0.80 279219.20 266666.67 0.01461 0.18 0.00 -0.17703 1.77
19 20 -0.10000 100.00 0.40 0.80 279219.20 266666.67 0.01461 0.12 0.00 -0.11802 1.18
18 19 -0.05000 100.00 0.35 0.52 159553.83 233333.33 0.01627 0.06 0.00 -0.06407 1.28
13 18 0.07000 150.00 0.35 0.73 223375.36 233333.33 0.01525 0.18 0.00 0.17646 2.52
Σ= 0.05 9.11
ΔQ1= 0.02959270
ΔQ2= 0.02089030
ΔQ3= -0.07850815
ΔQ4= -0.03441481
ΔQ5= -0.06658082
ΔQ6= 0.03878862
ΔQ7= -0.06583288
ΔQ8= 0.01692102
ΔQ9= 0.02869027
ΔQ10= -0.00292859
Iteración: 2
CircuitoTuberia
NR f hf K hmNi Nf
I
1 2 0.07959 50.00 0.25 1.62 355580.97 166666.67 0.01401 0.38 0.00 0.37573 4.72
2 7 -0.04130 50.00 0.25 0.84 184497.31 166666.67 0.01583 0.11 0.00 -0.11434 2.77
6 7 -0.05599 150.00 0.25 1.14 250146.86 166666.67 0.01494 0.60 0.00 -0.59506 10.63
1 6 -0.02041 100.00 0.25 0.42 91169.75 166666.67 0.01825 0.06 0.00 -0.06436 3.15
Σ= -0.40 21.27
Caudal(m3/s)
Longitud(m)
Diámetro(m)
Velocidad(m/s) D/ε hf+Σhm (hf+Σhm)/Q
II
2 3 0.12089 100.00 0.20 3.85 675097.85 133333.33 0.01256 4.74 0.00 4.74481 39.25
3 8 0.04940 150.00 0.20 1.57 275859.90 133333.33 0.01469 1.39 0.00 1.38950 28.13
7 8 -0.20790 100.00 0.25 4.24 928787.25 166666.67 0.01190 4.35 0.00 -4.35473 20.95
2 7 0.04130 150.00 0.25 0.84 184497.31 166666.67 0.01583 0.34 0.00 0.34303 8.31
Σ= 2.12 96.63
III
3 4 0.27149 100.00 0.20 8.64 1516114.74 133333.33 0.01108 21.10 0.00 21.10029 77.72
4 9 -0.19409 150.00 0.20 6.18 1083891.76 133333.33 0.01165 17.01 0.00 -17.01139 87.65
8 9 -91.09851 100.00 0.20 2899.76 508729048.43 133333.33 0.00776 1664792.81 0.00 -1664792.80510 18274.64
3 8 -0.04940 150.00 0.20 1.57 275859.90 133333.33 0.01469 1.39 0.00 -1.38950 28.13
Σ= -1664790.11 18468.14
IV
6 7 0.08559 200.00 0.25 1.74 382352.47 166666.67 0.01382 1.72 0.00 1.71529 20.04
7 11 -0.15441 75.00 0.25 3.15 689849.25 166666.67 0.01249 1.89 0.00 -1.89132 12.25
10 11 -0.04441 75.00 0.25 0.90 198423.46 166666.67 0.01561 0.20 0.00 -0.19562 4.40
6 10 0.03559 150.00 0.25 0.72 158977.11 166666.67 0.01630 0.26 0.00 0.26221 7.37
Σ= -0.11 44.06
V
7 8 0.09383 100.00 0.25 1.91 419170.46 166666.67 0.01360 1.01 0.00 1.01408 10.81
8 12 0.01463 150.00 0.20 0.47 81702.66 133333.33 0.01868 0.16 0.00 0.15505 10.60
12 17 -0.02350 100.00 0.20 0.75 131243.27 133333.33 0.01694 0.24 0.00 -0.24189 10.29
16 17 -0.12658 150.00 0.25 2.58 565500.72 166666.67 0.01291 2.63 0.00 -2.62836 20.76
11 16
7 11
Σ= -1.70 52.46
VI
8 9 0.03790 100.00 0.25 0.77 169311.03 166666.67 0.01610 0.20 0.00 0.19584 5.17
9 13 0.07462 150.00 0.20 2.38 416715.13 133333.33 0.01364 2.94 0.00 2.94393 39.45
12 13 -0.04990 100.00 0.20 1.59 278669.97 133333.33 0.01466 0.94 0.00 -0.94354 18.91
8 12 -0.01463 150.00 0.20 0.47 81702.66 133333.33 0.01868 0.16 0.00 -0.15505 10.60
Σ= 2.04 74.12
VII
4 5 0.41268 100.00 0.20 13.14 2304537.14 133333.33 0.01044 45.97 0.00 45.97221 111.40
5 14 -0.23142 150.00 0.20 7.37 1292327.40 133333.33 0.01134 23.55 0.00 -23.54556 101.74
13 14 -0.16290 100.00 0.20 5.19 909720.11 133333.33 0.01197 8.21 0.00 -8.21049 50.40
9 13 -0.07462 150.00 0.20 2.38 416715.13 133333.33 0.01364 2.94 0.00 -2.94393 39.45
4 9
Σ= 11.27 303.00
VIII
10 11 0.09350 100.00 0.20 2.98 522150.15 133333.33 0.01311 2.96 0.00 2.96344 31.69
11 16 -0.02177 150.00 0.20 0.69 121567.88 133333.33 0.01721 0.32 0.00 -0.31615 14.52
15 16 -0.05308 100.00 0.15 3.00 395217.90 100000.00 0.01380 4.23 0.00 -4.23432 79.77
10 15 0.09692 150.00 0.15 5.48 721658.89 100000.00 0.01247 19.14 0.00 19.14358 197.52
Σ= 17.56 323.51
IX
12 13 0.04990 100.00 0.20 1.59 278669.97 133333.33 0.01466 0.94 0.00 0.94354 18.91
13 18 -0.03838 150.00 0.15 2.17 285780.00 100000.00 0.01462 3.52 0.00 -3.51871 91.68
17 18 -0.09131 100.00 0.20 2.91 509908.59 133333.33 0.01317 2.84 0.00 -2.83760 31.08
12 17 -0.04823 150.00 0.20 1.54 269339.00 133333.33 0.01475 1.33 0.00 -1.33045 27.59
Σ= -6.74 169.25
X
13 14 0.16290 100.00 0.20 5.19 909720.11 133333.33 0.01197 8.21 0.00 8.21049 50.40
14 20 #REF! 150.00 0.20 #REF! #REF! 133333.33 #REF! #REF! #REF! #REF! #REF!
19 20 -0.10293 100.00 0.15 5.82 766390.38 100000.00 0.01235 14.26 0.00 -14.25596 138.50
18 19 -0.08162 150.00 0.15 4.62 607721.43 100000.00 0.01283 13.96 0.00 -13.96046 171.04
13 18
Σ= #REF! #REF!
ΔQ1= 0.00935632
ΔQ2= -0.01098317
ΔQ3= 45.07195420
ΔQ4= 0.00124181
ΔQ5= 0.01621284
ΔQ6= -0.01376864
ΔQ7= -0.01860119
ΔQ8= -0.02713461
ΔQ9= 0.01992114
ΔQ10= #REF!
Metodo de Hardy Cross
Material de Tubería: PVC
Rugosidad Absolu 0.0000015
Liquido Transportado: Agua
Densidad: ρ= 1000 kg/m3Viscosidad Absoluμ= 1.14E-03 Pa·sViscosidad Cinemáν= 1.14E-06 m2/s
Iteración: 1
CircuitoTuberia
NR f hf K hmNi Nf
I
1 2 0.10000 50.00 0.25 2.04 446750.72 166666.67 0.01345 0.57 0.00 0.56954 5.70
2 7 0.09000 50.00 0.25 1.83 402075.65 166666.67 0.01370 0.47 0.00 0.46998 5.22
6 7 0.04000 150.00 0.25 0.81 178700.29 166666.67 0.01593 0.32 0.00 0.32381 8.10
1 6 -0.05000 100.00 0.25 1.02 223375.36 166666.67 0.01526 0.32 0.00 -0.32316 6.46
Σ= 1.04 25.48
II
3 4 0.03000 100.00 0.20 0.95 167531.52 133333.33 0.01614 0.38 0.00 0.37556 12.52
4 10 0.01000 150.00 0.20 0.32 55843.84 133333.33 0.02029 0.08 0.00 0.07865 7.87
9 10 -0.05000 100.00 0.25 1.02 223375.36 166666.67 0.01526 0.32 0.00 -0.32316 6.46
3 9 -0.04000 150.00 0.25 0.81 178700.29 166666.67 0.01593 0.32 0.00 -0.32381 8.10
Σ= -0.19 34.94
III
4 5 0.01000 100.00 0.20 0.32 55843.84 133333.33 0.02029 0.05 0.00 0.05243 5.24
5 11 0.00500 150.00 0.20 0.16 27921.92 133333.33 0.02380 0.02 0.00 0.02307 4.61
10 11 -0.01000 100.00 0.20 0.32 55843.84 133333.33 0.02029 0.05 0.00 -0.05243 5.24
4 10 -0.01000 150.00 0.20 0.32 55843.84 133333.33 0.02029 0.08 0.00 -0.07865 7.87
Σ= -0.06 22.97
IV
5 6 0.00500 200.00 0.25 0.10 22337.54 166666.67 0.02513 0.01 0.00 0.01064 2.13
ε=
Caudal(m3/s)
Longitud(m)
Diámetro(m)
Velocidad(m/s) D/ε hf+Σhm (hf+Σhm)/Q
IV
6 7 -0.05500 75.00 0.25 1.12 245712.89 166666.67 0.01499 0.29 0.00 -0.28804 5.24
7 12 -0.07500 75.00 0.25 1.53 335063.04 166666.67 0.01416 0.51 0.00 -0.50583 6.74
12 17 -0.08500 150.00 0.25 1.73 379738.11 166666.67 0.01384 1.27 0.00 -1.27049 14.95
16 17 -0.00500 200.00 0.25 0.10 22337.54 166666.67 0.02513 0.01 0.00 -0.01064 2.13
11 16 -0.01500 150.00 0.20 0.48 83765.76 133333.33 0.01858 0.16 0.00 -0.16212 10.81
5 11 -0.00500 150.00 0.20 0.16 27921.92 133333.33 0.02380 0.02 0.00 -0.02307 4.61
Σ= -2.25 46.61
V
8 9 0.05000 100.00 0.25 1.02 223375.36 166666.67 0.01526 0.32 0.00 0.32316 6.46
9 14 0.04000 150.00 0.20 1.27 223375.36 133333.33 0.01528 0.95 0.00 0.94767 23.69
13 14 -0.02000 100.00 0.20 0.64 111687.68 133333.33 0.01751 0.18 0.00 -0.18100 9.05
8 13 -0.07000 150.00 0.25 1.43 312725.50 166666.67 0.01434 0.89 0.00 -0.89240 12.75
Σ= 0.20 51.95
VI
9 10 0.05000 100.00 0.25 1.02 223375.36 166666.67 0.01526 0.32 0.00 0.32316 6.46
10 15 0.02000 150.00 0.20 0.64 111687.68 133333.33 0.01751 0.27 0.00 0.27149 13.57
14 15 -0.02000 100.00 0.20 0.64 111687.68 133333.33 0.01751 0.18 0.00 -0.18100 9.05
9 14 -0.04000 150.00 0.20 1.27 223375.36 133333.33 0.01528 0.95 0.00 -0.94767 23.69
Σ= -0.53 52.78
VII
10 11 0.01000 100.00 0.20 0.32 55843.84 133333.33 0.02029 0.05 0.00 0.05243 5.24
11 16 0.01500 150.00 0.20 0.48 83765.76 133333.33 0.01858 0.16 0.00 0.16212 10.81
15 16 -0.02000 100.00 0.20 0.64 111687.68 133333.33 0.01751 0.18 0.00 -0.18100 9.05
10 15 -0.02000 150.00 0.20 0.64 111687.68 133333.33 0.01751 0.27 0.00 -0.27149 13.57
Σ= -0.24 38.68
VIII
13 14 0.02000 100.00 0.20 0.64 111687.68 133333.33 0.01751 0.18 0.00 0.18100 9.05
14 19 0.03000 150.00 0.20 0.95 167531.52 133333.33 0.01614 0.56 0.00 0.56334 18.78
18 19 -0.05000 100.00 0.15 2.83 372292.26 100000.00 0.01394 3.80 0.00 -3.79691 75.94
13 18 -0.05000 150.00 0.15 2.83 372292.26 100000.00 0.01394 5.70 0.00 -5.69537 113.91
Σ= -8.75 217.67
IX
14 15 0.02000 100.00 0.20 0.64 111687.68 133333.33 0.01751 0.18 0.00 0.18100 9.05
IX15 20 0.02000 150.00 0.15 1.13 148916.91 100000.00 0.01654 1.08 0.00 1.08104 54.05
19 20 -0.06000 100.00 0.20 1.91 335063.04 133333.33 0.01418 1.32 0.00 -1.31903 21.98
14 19 -0.03000 150.00 0.20 0.95 167531.52 133333.33 0.01614 0.56 0.00 -0.56334 18.78
Σ= -0.62 103.86
X
15 16 0.02000 100.00 0.20 0.64 111687.68 133333.33 0.01751 0.18 0.00 0.18100 9.05
16 21 0.02000 150.00 0.20 0.64 111687.68 133333.33 0.01751 0.27 0.00 0.27149 13.57
20 21 -0.08000 100.00 0.15 4.53 595667.62 100000.00 0.01287 8.97 0.00 -8.97102 112.14
15 20 -0.02000 150.00 0.15 1.13 148916.91 100000.00 0.01654 1.08 0.00 -1.08104 54.05
Σ= -9.60 188.81
XI
16 17 0.00500 200.00 0.25 0.10 22337.54 166666.67 0.02513 0.01 0.00 0.01064 2.13
17 22 -0.09000 150.00 0.20 2.86 502594.56 133333.33 0.01320 4.15 0.00 -4.14542 46.06
21 22 -0.10000 200.00 0.15 5.66 744584.53 100000.00 0.01241 27.04 0.00 -27.03658 270.37
16 21 -0.02000 150.00 0.20 0.64 111687.68 133333.33 0.01751 0.27 0.00 -0.27149 13.57
Σ= -31.44 332.13
ΔQ1= -0.02041487
ΔQ2= 0.00275825
ΔQ3= 0.00121007
ΔQ4= 0.02413324
ΔQ5= -0.00190003
ΔQ6= 0.00505892
ΔQ7= 0.00307603
ΔQ8= 0.02009420
ΔQ9= 0.00298631
ΔQ10= 0.02542070
ΔQ11= 0.04733531
Iteración: 2
CircuitoTuberia
NR f hf K hmNi Nf
Caudal(m3/s)
Longitud(m)
Diámetro(m)
Velocidad(m/s) D/ε hf+Σhm (hf+Σhm)/Q
I
1 2 0.07959 50.00 0.25 1.62 355547.14 166666.67 0.01401 0.38 0.00 0.37567 4.72
2 3 0.06959 50.00 0.25 1.42 310872.07 166666.67 0.01435 0.29 0.00 0.29427 4.23
3 9 0.01683 150.00 0.25 0.34 75174.19 166666.67 0.01901 0.07 0.00 0.06838 4.06
8 9 -0.06851 100.00 0.25 1.40 306090.54 166666.67 0.01439 0.57 0.00 -0.57220 8.35
1 8 #REF! 150.00 0.25 #REF! #REF! 166666.67 #REF! #REF! #REF! #REF! #REF!
Σ= #REF! #REF!
II
3 4 0.03276 100.00 0.20 1.04 182934.66 133333.33 0.01587 0.44 0.00 0.44021 13.44
4 10 0.01155 150.00 0.20 0.37 64489.49 133333.33 0.01966 0.10 0.00 0.10163 8.80
9 10 -0.05230 100.00 0.25 1.07 233653.62 166666.67 0.01513 0.35 0.00 -0.35058 6.70
3 9 -0.01683 150.00 0.25 0.34 75174.19 166666.67 0.01901 0.07 0.00 -0.06838 4.06
Σ= 0.12 33.01
III
4 5 0.01121 100.00 0.20 0.36 62601.34 133333.33 0.01978 0.06 0.00 0.06426 5.73
5 11 -0.01792 150.00 0.20 0.57 100089.89 133333.33 0.01791 0.22 0.00 -0.22301 12.44
10 11 -91.00879 100.00 0.20 2896.90 508228027.44 133333.33 0.00776 1661524.24 0.00 -1661524.23542 18256.74
4 10 -0.01155 150.00 0.20 0.37 64489.49 133333.33 0.01966 0.10 0.00 -0.10163 8.80
Σ= -1661524.50 18283.72
IV
5 6 0.02913 200.00 0.25 0.59 130152.98 166666.67 0.01696 0.24 0.00 0.24385 8.37
6 7 -0.03087 75.00 0.25 0.63 137897.45 166666.67 0.01677 0.10 0.00 -0.10147 3.29
7 12 -0.05087 75.00 0.25 1.04 227247.59 166666.67 0.01521 0.25 0.00 -0.25003 4.92
12 17 -0.06087 150.00 0.25 1.24 271922.67 166666.67 0.01471 0.69 0.00 -0.69231 11.37
16 17 -0.02820 200.00 0.25 0.57 125992.94 166666.67 0.01707 0.23 0.00 -0.23002 8.16
11 16 0.00606 150.00 0.20 0.19 33825.80 133333.33 0.02274 0.03 0.00 0.03235 5.34
5 11 0.01792 150.00 0.20 0.57 100089.89 133333.33 0.01791 0.22 0.00 0.22301 12.44
Σ= -0.77 53.89
V
8 9 0.06851 100.00 0.25 1.40 306090.54 166666.67 0.01439 0.57 0.00 0.57220 8.35
9 14 0.03304 150.00 0.20 1.05 184513.90 133333.33 0.01584 0.67 0.00 0.67065 20.30
13 14 -0.04199 100.00 0.20 1.34 234511.90 133333.33 0.01514 0.69 0.00 -0.68999 16.43
8 13 -0.07190 150.00 0.25 1.46 321213.90 166666.67 0.01427 0.94 0.00 -0.93692 13.03
Σ= -0.38 58.11
VI
9 10 0.05230 100.00 0.25 1.07 233653.62 166666.67 0.01513 0.35 0.00 0.35058 6.70
10 15 0.02198 150.00 0.20 0.70 122760.89 133333.33 0.01717 0.32 0.00 0.32175 14.64
14 15 -0.01793 100.00 0.20 0.57 100113.42 133333.33 0.01790 0.15 0.00 -0.14873 8.30
9 14 -0.03304 150.00 0.20 1.05 184513.90 133333.33 0.01584 0.67 0.00 -0.67065 20.30
Σ= -0.15 49.93
VII
10 11 0.01187 100.00 0.20 0.38 66264.09 133333.33 0.01954 0.07 0.00 0.07111 5.99
11 16 -0.00606 150.00 0.20 0.19 33825.80 133333.33 0.02274 0.03 0.00 -0.03235 5.34
15 16 -0.04234 100.00 0.20 1.35 236468.87 133333.33 0.01511 0.70 0.00 -0.70046 16.54
10 15 -0.02198 150.00 0.20 0.70 122760.89 133333.33 0.01717 0.32 0.00 -0.32175 14.64
Σ= -0.98 42.51
VIII
13 14 0.04199 100.00 0.20 1.34 234511.90 133333.33 0.01514 0.69 0.00 0.68999 16.43
14 19 0.04711 150.00 0.20 1.50 263068.54 133333.33 0.01482 1.27 0.00 1.27477 27.06
18 19 -0.02991 100.00 0.15 1.69 222673.97 100000.00 0.01531 1.49 0.00 -1.49143 49.87
13 18 -0.02991 150.00 0.15 1.69 222673.97 100000.00 0.01531 2.24 0.00 -2.23715 74.81
Σ= -1.76 168.17
IX
14 15 0.01793 100.00 0.20 0.57 100113.42 133333.33 0.01790 0.15 0.00 0.14873 8.30
15 20 -0.00243 150.00 0.15 0.14 18126.07 100000.00 0.02649 0.03 0.00 -0.02565 10.54
19 20 -0.05701 100.00 0.20 1.81 318386.33 133333.33 0.01431 1.20 0.00 -1.20203 21.08
14 19 -0.04711 150.00 0.20 1.50 263068.54 133333.33 0.01482 1.27 0.00 -1.27477 27.06
Σ= -2.35 66.98
X
15 16 0.04234 100.00 0.20 1.35 236468.87 133333.33 0.01511 0.70 0.00 0.70046 16.54
16 21 -0.00191 150.00 0.20 0.06 10691.94 133333.33 0.03042 0.00 0.00 -0.00432 2.26
20 21 -0.05458 100.00 0.15 3.09 406389.04 100000.00 0.01373 4.46 0.00 -4.45537 81.63
15 20 0.00243 150.00 0.15 0.14 18126.07 100000.00 0.02649 0.03 0.00 0.02565 10.54
Σ= -3.73 110.97
XI
16 17 0.02820 200.00 0.25 0.57 125992.94 166666.67 0.01707 0.23 0.00 0.23002 8.16
17 22 -0.04266 150.00 0.20 1.36 238256.00 133333.33 0.01509 1.07 0.00 -1.06513 24.97
XI21 22 -0.05266 200.00 0.15 2.98 392133.12 100000.00 0.01382 8.35 0.00 -8.34839 158.52
16 21 0.00191 150.00 0.20 0.06 10691.94 133333.33 0.03042 0.00 0.00 0.00432 2.26
Σ= -9.18 193.90
ΔQ1= #REF!
ΔQ2= -0.00186146
ΔQ3= 45.43726671
ΔQ4= 0.00718751
ΔQ5= 0.00330461
ΔQ6= 0.00147240
ΔQ7= 0.01156673
ΔQ8= 0.00524419
ΔQ9= 0.01757148
ΔQ10= 0.01682303
ΔQ11= 0.02366998
