Practica 6

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 19

N delta H

𝑦=101,52 + 16,491𝑋 1 0
𝑌=𝑌𝑜+𝑝∗𝑔∗ℎ
𝑌=𝐴+𝐵𝑥 2 0.2
𝐴=101,52 3 0.4
𝐵=16,491 4 0.6
𝑝∗𝑔=16,491
𝑝=16,491/9,8=1,683 5 0.8
𝑌=101,52+1,683∗𝑔∗ℎ+(𝑡𝑒𝑜𝑟𝑖𝑎 𝑑𝑒 𝑐𝑎𝑜𝑠+𝑅𝑁) 6 1
7 1.2
8 1.4
9 1.6
P(Kpa) 10 1.8
160 11 2
140 f(x) = 16.4911838235294 x + 101.521286764706 12 2.2
120 R² = 0.999851908240573
13 2.4
100
80 14 2.6
60 15 2.8
40 16 3
20
0
0 0.5 1 1.5 2 2.5 3 3.5
A 101.52
precion B 16.491
Kpa rho 1.683 2.31792013 3.17584176
101.325 g 9.8
104.948
108.184
111.41 delta H P(Pka) P2(Pka) P3(Pka)
114.44 0 101.52 101.52 101.52 1
118.32 0.1 103.16934 103.791562 104.632325 1
121.558 0.2 104.81868 106.063123 107.74465 1
124.363 0.3 106.46802 108.334685 110.856975 1
128.246 0.4 108.11736 110.606247 113.9693 1
131.05 0.5 109.7667 112.877809 117.081625 1
134.286 0.6 111.41604 115.14937 120.19395 1
137.738 0.7 113.06538 117.420932 123.306275 1
141.069 0.8 114.71472 119.692494 126.418599 1
144.4 0.9 116.36406 121.964056 129.530924 1
147.731 1 118.0134 124.235617 132.643249 1
151.061 1.1 119.66274 126.507179 135.755574 1
1.2 121.31208 128.778741 138.867899 1
1.3 122.96142 131.050303 141.980224 1
1.4 124.61076 133.321864 145.092549 1
1.5 126.2601 135.593426 148.204874 1
1.6 127.90944 137.864988 151.317199 1
1.7 129.55878 140.136549 154.429524 1

Chart Title
150

100

50

0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Column F Column G Column H


1 1
1.00603107 1.0081005
1.01187234 1.01585402 Chart Title
1.01753264 1.02328238 1.12
1.1
1.02302023 1.03040563
1.08
1.02834292 1.03724218 1.06
1.03350802 1.043809 1.04
1.03852242 1.05012175 1.02
1
1.04339263 1.05619488 0.98
1.04812479 1.06204179 0.96
1.05272467 1.06767489 0.94
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8
1.05719775 1.07310569
1.06154919 1.07834491 Column K Linear (Column K)
Linear (Column K) Linear (Column K)
1.06578391 1.08340249 Column L Linear (Column L)
1.06990652 1.08828773 Linear (Column L)
1.07392142 1.09300929
1.07783278 1.09757525
1.08164456 1.10199319
1.6 1.8

K)
K)
L)
𝑦=38,413 +6,3175𝑋
𝑌=𝑌𝑜+𝑝∗𝑔∗ℎ N delta H Kpa
𝑌=𝐴+𝐵𝑥
𝐴=38,413 1 0 38.359
𝐵=6,3175 2 0.2 39.652
𝑝∗𝑔=6,3175 3 0.4 40.965
𝑝=6,3175/3,71=1,702
𝑌=38,413+1,702∗𝑔∗ℎ+(𝑡𝑒𝑜𝑟𝑖𝑎 𝑑𝑒 𝑐𝑎𝑜𝑠+𝑅𝑁) 4 0.6 42.227
5 0.8 43.59
6 1 44.651
7 1.2 46.064
8 1.4 47.225
9 1.6 48.488
10 1.8 49.8
Chart Title 11 2 50.911
70
12 2.2 52.324
60 13 2.4 53.637
f(x) = 6.31753676470588 x + 38.4127573529412
50 R² = 0.999867222291126 14 2.6 54.899
40 15 2.8 56.161
16 3 57.272
30
20
10
0
0 0.5 1 1.5 2 2.5 3 3.5
A 38.413
B 6.3175
rho 1.702 2.05926857 2.98660843
g 3.71

delta H P(Pka) P2(Pka) P3(Pka)


0 38.413 38.413 38.413 1
0.1 39.044442 39.1769886 39.5210317 1
0.2 39.675884 39.9409773 40.6290635 1
0.3 40.307326 40.7049659 41.7370952 1
0.4 40.938768 41.4689546 42.8451269 1
0.5 41.57021 42.2329432 43.9531586 1
0.6 42.201652 42.9969318 45.0611904 1
0.7 42.833094 43.7609205 46.1692221 1
0.8 43.464536 44.5249091 47.2772538 1
0.9 44.095978 45.2888978 48.3852855 1
1 44.72742 46.0528864 49.4933173 1
1.1 45.358862 46.816875 50.601349 1
1.2 45.990304 47.5808637 51.7093807 1
1.3 46.621746 48.3448523 52.8174125 1
1.4 47.253188 49.108841 53.9254442 1
1.5 47.88463 49.8728296 55.0334759 1
1.6 48.516072 50.6368182 56.1415076 1
1.7 49.147514 51.4008069 57.2495394 1

variacion
diferentes esenarios
1.14
70
1.12
60 1.1
1.08
50
1.06
40 1.04
1.02
30
1
20 0.98
0.96
10
0.94
0 0.2 0.4 0.
0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8
1
P(Pka) P2(Pka) P3(Pka)
1 1
1.00339476 1.00878176
1.00668147 1.01722757
1.0098652 1.02535635
1.01295072 1.03318561
1.0159425 1.0407316
1.01884476 1.04800944
1.02166144 1.05503316
1.02439628 1.06181584
1.0270528 1.06836969
1.02963431 1.07470609
1.03214395 1.08083568
1.03458467 1.08676843
1.03695928 1.09251368
1.03927043 1.09808016
1.04152062 1.10347611
1.04371224 1.10870923
1.04584755 1.11378678

variacion del efecto gravitatorio


1.14
1.12
1.1
1.08
1.06
1.04
1.02
1
0.98
0.96
0.94
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

1 1 Column Q Column R
𝑦=258,02 +42,34𝑋
𝑌=𝑌𝑜+𝑝∗𝑔∗ℎ
𝑌=𝐴+𝐵𝑥
𝐴=258,02 N delta H Kpa
𝐵=42,34 1 0 257.66
𝑝∗𝑔=42,34
𝑝=42,34/24,9=1,70 2 0.2 266.809
𝑌=101,52+1,683∗𝑔∗ℎ+(𝑡𝑒𝑜𝑟𝑖𝑎 𝑑𝑒 𝑐𝑎𝑜𝑠+𝑅𝑁) 3 0.4 274.602
4 0.6 283.412
5 0.8 292.222
6 1 300.693
7 1.2 308.486
Chart Title 8 1.4 317.635
450 9 1.6 326.106
400 10 1.8 334.238
350 f(x) = 42.3403897058824 x + 258.021227941176 11 2 342.032
R² = 0.99989654213317
300 12 2.2 350.842
250 13 2.4 359.652
200 14 2.6 368.462
150
15 2.8 377.271
100
16 3 384.387
50
0
0 0.5 1 1.5 2 2.5 3 3.5
A 258.02
B 42.34
rho 1.7 2.06024355 2.5374099
g 24.9

delta H P(Pka) P2(Pka) P3(Pka)


0 258.02 258.02 258.02 1
0.1 262.253 263.150006 264.338151 1
0.2 266.486 268.280013 270.656301 1
0.3 270.719 273.410019 276.974452 1
0.4 274.952 278.540026 283.292603 1
0.5 279.185 283.670032 289.610753 1
0.6 283.418 288.800039 295.928904 1
0.7 287.651 293.930045 302.247055 1
0.8 291.884 299.060052 308.565205 1
0.9 296.117 304.190058 314.883356 1
1 300.35 309.320064 321.201507 1
1.1 304.583 314.450071 327.519657 1
1.2 308.816 319.580077 333.837808 1
1.3 313.049 324.710084 340.155958 1
1.4 317.282 329.84009 346.474109 1
1.5 321.515 334.970097 352.79226 1
1.6 325.748 340.100103 359.11041 1
1.7 329.981 345.230109 365.428561 1

variacion del
diferentes esenarios
1.07
400 1.06
350 1.05
300 1.04
1.03
250
1.02
200 1.01
150 1
100 0.99
0.98
50
0.97
0 0 0.2 0.4 0.6
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8
Colu
Column L Column M Column N
1 1
1.00342039 1.00451508
1.00673211 1.00885749
1.00994027 1.01303695
1.01304964 1.01706246
1.01606473 1.02094236
1.01898976 1.02468443
1.02182869 1.02829588
1.02458529 1.03178343
1.02726307 1.03515334
1.02986537 1.03841148
1.03239534 1.04156331
1.03485596 1.04461395
1.03725003 1.0475682
1.03958022 1.05043056
1.04184905 1.05320524
1.04405891 1.05589621
1.04621208 1.05850721

variacion del efecto gravitatorio


07
06
05
04
03
02
01
1
99
98
97
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Column Q Column R
𝑦=91,188 +14,964𝑋
𝑌=𝑌𝑜+𝑝∗𝑔∗ℎ
𝑌=𝐴+𝐵𝑥
𝐴=91,188
𝐵=14,964 N delta H Kpa
𝑝∗𝑔=14,964
𝑝=14,964/8,87=1,687 1 0 91.06
𝑌=101,52+1,683∗𝑔∗ℎ+(𝑡𝑒𝑜𝑟𝑖𝑎 𝑑𝑒 𝑐𝑎𝑜𝑠+𝑅𝑁) 2 0.2 94.294
3 0.4 97.048
4 0.6 100.162
5 0.8 103.275
6 1 106.269
Chart Title
7 1.2 109.023
160 8 1.4 112.257
140
f(x) = 14.9637426470588 x + 91.1880735294118
9 1.6 115.25
120
R² = 0.999896542832879 10 1.8 118.124
100
11 2 120.879
80
60
12 2.2 123.992
40 13 2.4 127.106
20 14 2.6 130.219
0 15 2.8 133.333
0 0.5 1 1.5 2 2.5 3 3.5
16 3 135.848
A 91.188
B 14.964
rho 1.687 2.56235388 3.2413094
g 8.87

delta H P(Pka) P2(Pka) P3(Pka)


0 91.188 91.188 91.188 1
0.1 92.684369 93.4608079 94.0630414 1
0.2 94.180738 95.7336158 96.9380829 1
0.3 95.677107 98.0064237 99.8131243 1
0.4 97.173476 100.279232 102.688166 1
0.5 98.669845 102.552039 105.563207 1
0.6 100.166214 104.824847 108.438249 1
0.7 101.662583 107.097655 111.31329 1
0.8 103.158952 109.370463 114.188332 1
0.9 104.655321 111.643271 117.063373 1
1 106.15169 113.916079 119.938414 1
1.1 107.648059 116.188887 122.813456 1
1.2 109.144428 118.461695 125.688497 1
1.3 110.640797 120.734503 128.563539 1
1.4 112.137166 123.007311 131.43858 1
1.5 113.633535 125.280118 134.313622 1
1.6 115.129904 127.552926 137.188663 1
1.7 116.626273 129.825734 140.063704 1

variacion de
diferentes esenarios 1.14
1.12
160
1.1
140
1.08
120 1.06
100 1.04
1.02
80
1
60
0.98
40 0.96
20 0.94
0 0.2 0.4 0.6 0.8
0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 Column

Column L Column M Column N


1 1
1.00837724 1.0064437
1.01648827 1.01258144
1.0243456 1.01843451
1.03196094 1.02402226
1.0393453 1.02936234
1.04650903 1.03447085
1.05346187 1.03936253
1.06021301 1.04405091
1.06677109 1.0485484
1.07314428 1.05286642
1.07934029 1.05701551
1.0853664 1.0610054
1.09122951 1.06484506
1.09693614 1.06854283
1.10249249 1.07210644
1.10790439 1.07554305
1.11317742 1.07885933

variacion del efecto gravitatorio

0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Column Q Column R
𝑦=107,77 +17,684𝑋
𝑌=𝑌𝑜+𝑝∗𝑔∗ℎ
𝑌=𝐴+𝐵𝑥
𝐴=107,77
𝐵=17,684 N delta H Kpa
𝑝∗𝑔=17,684
𝑝=17,684/10,44=1,693 1 0 107.617
𝑌=101,52+1,683∗𝑔∗ℎ+(𝑡𝑒𝑜𝑟𝑖𝑎 𝑑𝑒 𝑐𝑎𝑜𝑠+𝑅𝑁) 2 0.2 111.438
3 0.4 114.693
4 0.6 118.373
5 0.8 122.052
6 1 125.591
Chart Title 7 1.2 128.846
180 8 1.4 132.667
160 9 1.6 136.205
f(x) = 17.684375 x + 107.767875
140 R² = 0.999896544359558 10 1.8 139.602
120
100 11 2 142.857
80 12 2.2 146.536
60 13 2.4 150.216
40 14 2.6 153.896
20
0
15 2.8 157.575
0 0.5 1 1.5 2 2.5 3 3.5 16 3 160.547
A 107.77
B 17.684
rho 1.693 2.05279326 2.68724399
g 10.44

delta H P(Pka) P2(Pka) P3(Pka)


0 107.77 107.77 107.77 1
0.1 109.537492 109.913116 110.575483 1
0.2 111.304984 112.056232 113.380965 1
0.3 113.072476 114.199348 116.186448 1
0.4 114.839968 116.342465 118.991931 1
0.5 116.60746 118.485581 121.797414 1
0.6 118.374952 120.628697 124.602896 1
0.7 120.142444 122.771813 127.408379 1
0.8 121.909936 124.914929 130.213862 1
0.9 123.677428 127.058045 133.019345 1
1 125.44492 129.201162 135.824827 1
1.1 127.212412 131.344278 138.63031 1
1.2 128.979904 133.487394 141.435793 1
1.3 130.747396 135.63051 144.241275 1
1.4 132.514888 137.773626 147.046758 1
1.5 134.28238 139.916742 149.852241 1
1.6 136.049872 142.059859 152.657724 1
1.7 137.817364 144.202975 155.463206 1

diferentes esenarios variacion del e


180 1.1
160
1.08
140
1.06
120
100 1.04
80 1.02
60
1
40
20 0.98
0 0.96
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 0 0.2 0.4 0.6

Column L Column M Column N Colum


1 1
1.00342918 1.00602627
1.00674946 1.01182204
1.00996593 1.01740027
1.01308339 1.02277299
1.01610635 1.02795136
1.01903904 1.03294572
1.02188543 1.03776572
1.02464929 1.04242033
1.02733415 1.04691792
1.02994335 1.0512663
1.03248005 1.05547278
1.03494723 1.05954419
1.0373477 1.06348693
1.03968413 1.06730702
1.04195906 1.07101008
1.04417488 1.07460141
1.04633386 1.07808599

variacion del efecto gravitatorio


1

6
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Column Q Column R
𝑦=114,98+18,916𝑋
𝑌=𝑌𝑜+𝑝∗𝑔∗ℎ
𝑌=𝐴+𝐵𝑥
𝐴=114,98
𝐵=18,916 N delta H Kpa
𝑝∗𝑔=18,916
𝑝=18,916/11,15=1,696 1 0 114.86
𝑌=101,52+1,683∗𝑔∗ℎ+(𝑡𝑒𝑜𝑟𝑖𝑎 𝑑𝑒 𝑐𝑎𝑜𝑠+𝑅𝑁) 2 0.2 118.939
3 0.4 122.413
4 0.6 126.34
5 0.8 130.268
6 1 134.044
Chart Title 7 1.2 137.518
180 8 1.4 141.596
160 f(x) = 18.9163928571429 x + 114.982516666667 9 1.6 145.373
140 R² = 0.999902413275879
120 10 1.8 148.998
100 11 2 152.472
80 12 2.2 156.399
60
40 13 2.4 160.327
20 14 2.6 164.254
0
0 0.5 1 1.5 2 2.5 3 15 2.8 168.181
16 3 171.353

180
160
140
120
100
80
60
40
20
0
0 0.2 0
A 114.98
B 18.916
rho 1.696 2.41167006 2.75661012
g 11.15

delta H P(Pka) P2(Pka) P3(Pka)


0 114.98 114.98 114.98 1
0.1 116.87104 117.669012 118.05362 1
0.2 118.76208 120.358024 121.127241 1
0.3 120.65312 123.047036 124.200861 1
0.4 122.54416 125.736048 127.274481 1
0.5 124.4352 128.425061 130.348101 1
0.6 126.32624 131.114073 133.421722 1
0.7 128.21728 133.803085 136.495342 1
0.8 130.10832 136.492097 139.568962 1
0.9 131.99936 139.181109 142.642583 1
1 133.8904 141.870121 145.716203 1
1.1 135.78144 144.559133 148.789823 1
1.2 137.67248 147.248145 151.863443 1
1.3 139.56352 149.937157 154.937064 1
1.4 141.45456 152.62617 158.010684 1
1.5 143.3456 155.315182 161.084304 1
1.6 145.23664 158.004194 164.157925 1
1.7 147.12768 160.693206 167.231545 1

diferentes esenarios variacion del


1.1
180 1.08
160
1.06
140
1.04
120
1.02
100
80 1
60 0.98
40 0.96
20 0.94
0 0.2 0.4 0.6
0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8
Colu
Column L Column M Column N
1 1
1.0068278 1.00326856
1.01343816 1.00639107
1.01984131 1.0093771
1.02604684 1.01223541
1.03206376 1.01497403
1.03790054 1.01760032
1.04356515 1.02012104
1.04906509 1.02254244
1.05440745 1.02487028
1.0595989 1.02710988
1.06464575 1.02926615
1.06955395 1.03134368
1.07432915 1.03334668
1.07897667 1.0352791
1.08350156 1.03714461
1.08790863 1.03894663
1.0922024 1.04068833

variacion del efecto gravitatorio


1.1
08
06
04
02
1
98
96
94
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Column Q Column R

You might also like