{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[18,7,18,9]]}
["Problem 1, Resit Exam TPG4245, Prof. Milan Stanko"]
[]
["Tubing tables (pwf values with pwh=30 bara, and different GORs in the tubing)"]
["qo","GOR","pwf"]
["[Sm3/d]","[Sm3/Sm3]","[bara]",null,"IPR"]
[0.1,54,185.27351271623616,null,"pR","[bara]",200]
[1,54,185.13075503408174,null,"qomax","[Sm3/d]",3000]
[10,54,183.87601571574854,null,"GORR","[Sm3/Sm3]",54]
[50,54,180.72597588429727]
[100,54,179.22943362749299,null,"pwf","qo"]
[250,54,181.21029044902451,null,"[bara]","[Sm3/d]"]
[500,54,190.79618296270732,null,200,{"$f":"IPR_Vogel_qo($G$6,$G$7,E12)","v":0}]
[750,54,200.90282428205623,null,150,{"$f":"IPR_Vogel_qo($G$6,$G$7,E13)","v":1200}]
[1000,54,211.42445227997405,null,100,{"$f":"IPR_Vogel_qo($G$6,$G$7,E14)","v":2100}]
[2000,54,255.59753416599403,null,50,{"$f":"IPR_Vogel_qo($G$6,$G$7,E15)","v":2699.9999999999995}]
[0.1,100,180.36507118633179,null,0,{"$f":"IPR_Vogel_qo($G$6,$G$7,E16)","v":3000}]
[1,100,179.74312907755075]
[10,100,174.29734152360771,null,"Gas lift performance curve"]
[50,100,159.72840342169624,null,null,null,null,"For solving using goal Seek only"]
[100,100,151.28884804260406,null,"GOR","qo(IPR)","qginj","pwf(IPR)","pwf(TPR)","pwf(IPR)-pwf(TPR)"]
[250,100,146.66870793862458,null,"[Sm3/Sm3]","[Sm3/d]","[Sm3/d]","[bara]","[bara]","[bar]"]
[500,100,154.31861543819431,null,54,{"$f":"IPR_Vogel_qo($G$6,$G$7,H22)","v":370.51153634887169},{"$f":"F22*(E22-$G$8)","v":0},185.83123043685629,{"$f":"TwoDimInterpol(F22,E22,3,$A$6:$C$46,1,1)","v":185.83113298542077},{"$f":"I22-H22","v":-9.7451435522089014E-5}]
[750,100,166.05704599898775,null,100,{"$f":"IPR_Vogel_qo($G$6,$G$7,H23)","v":795.06636384208139},{"$f":"F23*(E23-$G$8)","v":36573.052736735743},168.32328865391594,{"$f":"TwoDimInterpol(F23,E23,3,$A$6:$C$46,1,1)","v":168.32328897922531},{"$f":"I23-H23","v":3.2530937232877477E-7}]
[1000,100,178.62874463978986,null,300,{"$f":"IPR_Vogel_qo($G$6,$G$7,H24)","v":1125.4627036480786},276863.82509742735,153.51411225035409,{"$f":"TwoDimInterpol(F24,E24,3,$A$6:$C$46,1,1)","v":153.51407583009149},{"$f":"I24-H24","v":-3.6420262603087394E-5}]
[2000,100,225.64930548732522,null,700,{"$f":"IPR_Vogel_qo($G$6,$G$7,H25)","v":920.12478715325619},594400.61250100355,162.85522851594806,{"$f":"TwoDimInterpol(F25,E25,3,$A$6:$C$46,1,1)","v":162.8554345831956},{"$f":"I25-H25","v":2.060672475465708E-4}]
[0.1,300,174.68985257133386]
[1,300,171.91583394504136]
[10,300,149.31941428488116,null,"Explanation"]
[50,300,108.50094856738775,null,"*I populate the IPR column pwf with values from reservoir pressure to 0"]
[100,300,96.559455166162337,null,"*Use the equation IPR_Vogel_qo to find oil rates at the pwf values specified before"]
[250,300,94.831790522759093,null,"*plot the IPR on top of the TPRs"]
[500,300,105.96234213761706,null,"*to find the intersection between IPR and the TPR curves of each GOR,  I can use two approaches:"]
[750,300,119.02601449033973,null,null,"*Naked eye reading"]
[1000,300,141.48138301723014,null,null,null,"It seems the intersections are"]
[2000,300,237.38791510195958,null,null,null,"GOR","qo"]
[0.1,500,173.21172927927938,null,null,null,54,400]
[0.1,700,172.50815596163491,null,null,null,100,750]
[1,700,165.27865774929481,null,null,null,300,1100]
[10,700,118.40495983077636,null,null,null,700,900]
[50,700,76.088402006240912,null,null,null,"from these values I find the qginj as qo*(GOR-GORR), the qo and qinj are the gas lift performance curve"]
[100,700,71.444565779687451,null,null,"*Goal seek"]
[250,700,77.719469625844695,null,null,null,"*create a column with pwf assumed."]
[500,700,108.75389099538084,null,null,null,"*Use the pwf and IPR to calculate qo"]
[750,700,138.18993872220514,null,null,null,"*obtain pwf from the TPR byuse the interpolation function with the qo obtained, the GOR and the tubing table"]
[1000,700,174.43612053046019,null,null,null,"*create a column with the difference pwfassumed-pwf(TPR)"]
[2000,700,364.90040221449573,null,null,null,"*minimize the difference by changing pwf (goalseek)"]
[null,null,null,null,null,null,"*with the correct values of qo, find the qinj as qo(GOR-GORR), the qo and qinj are the GL performance curve"]