examen yacimientos

Upload: billy-landers

Post on 10-Jan-2016

214 views

Category:

Documents


0 download

DESCRIPTION

programa de Excel para resolver correlaciones

TRANSCRIPT

Hoja1

componente% molfracc molarT Crit ( R )P Crit (psia)Peso MolYiTciYi*TciPciYi*PciWmYi*Wm199.550.9955343.37341.824835667.8664.794916.04315.970806520.090.0009550.090.495081707.80.6370230.070.02706330.10.001666.010.66601616.30.616344.0970.04409740.010.0001765.650.076565550.70.0550758.1230.005812350.010.0001734.980.073498529.10.0529158.1230.0058123600845.70488.6072.1510700829.10490.4072.1510800913.70436.9086.178090.080.0008547.90.4383210710.856844.010.0352081000672.701306034.0760110.160.0016227.60.364164930.788828.0130.04482081200001300001400001500001001Tpc=343.938469Ppc=667.8018Wma=16.1336199

Ty ( R ) =600Tpr=Ty/Tpc1.7444980835

Py ( psia ) =2100Ppr=Py/Ppc3.1446456119

K=0.02827Bg= 0.0071078857

Z=0.88g=0.5569078322

aire=28.97

Hoja2

tq0 real ( y )xyx2dias opet para ectAc Vo Realgas Vg realRGAAceite q0 realGas q0 realy=ln q0(mb)(mmpc)(pc/bl)(bpd)(mmpc)MINIMOS CUADRADOS14.15600596454.156005964513111978.32693.059791361.363.816129032386.8728964516m=-0.044338910724.15860402668.317208053142821791.51070.42125597.563.982142857138.2293303571b=4.232776967234.103496107212.310488321693131877.11712.10291912.160.551612903255.22912612944.057738206416.2309528257163041735.31994.900881149.657.843333333366.496696q053.99357326119.9678663052253151681.72340.9264139254.248387096875.5137548387m*t=-0.044338910739.935483871NP=18842.463.951884538923.71130723313630615612567.845164552.033333333385.5948333333-0.088677821538.2034695739RRAC=5972.592258384573.939889176527.5792242353493171593.82583.5498162151.412903225883.340316129-0.133016732234.9615370776ROAC=24814.992258384583.855371250530.8429700044642681228.41870.2391522.547.246153846271.9322692308-0.177355642930.607093149994.031286426336.28157783638130916902796.4431654.756.333333333393.2147666667-0.221694553625.6328861284GP=24778.30294103.705990289737.059902897410031101261.41533.483981215.740.690322580649.4672251613-0.266033464420.5360440343RRGN=7978.537139965113.693784073440.631624807912130111205.91795.223331488.740.196666666759.8407776667-0.310372375115.739100964ROGN=32756.8400799651123.687265248844.24718298511443101212381820.10761470.239.93548387158.7131483871-0.354711285811.5394978738311131184.30755679081582.06711896861335.858333333338.203469573951.0344231925-0.39905019668.093525835328214978.92303817211307.70249823421335.858333333334.961537077646.7036606512-0.44338910735.43040798231315948.81988764821267.48895374731335.858333333330.607093149940.8867404435-0.4877280183.485547586830416768.98658385111027.2571362591335.858333333325.632886128434.241904542-0.53206692882.140195415731517636.6173650635850.43061226481335.858333333320.536044034327.433245556930618472.1730289185630.75627545611335.858333333315.73910096421.0252091819aceite31719357.7244340881477.86916631361335.858333333311.539497873815.4151343972A=3000000N=11250031820250.8993008953335.16592192841335.85833333338.093525835310.8118039332Hn16.76G=6052500030921162.9122394599217.62767268451335.85833333335.4304079827.2542557561=0.25311022108.05197519144.34213149071335.85833333333.48554758684.65619779Sw=0.15Fro=0.22057770930112364.205862470885.76993643041335.85833333332.14019541572.858997881Frg=0.000541211731122438.970985836152.05971618741335.85833333331.25712857541.6793456835rs=5387847.3348885699301.3363114698650

Hoja3