{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Task_1","Task_2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":54,"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":"Task_1","index":0,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Problem 1, TPG4230, Exam 2021"]
[]
["Initial gas in place, G","[Sm3]",72000000000]
["Initial reservoir pressure, pRi","[bara]",240]
["Inflow coefficient, CR","[Sm3/d/bar2n]",1000]
["Inflow exponent, n","[-]",0.8]
["Tubing flow coefficient, CT","[Sm3/d/bar]",38000]
["Tubing exponent, S","[-]",0.43]
["Pipeline coefficient, CPL","[Sm3/d/bar]",140000]
["psep","[bara]",60]
["Nproducers","[-]",6]
["qplateau,field","[Sm3/d]",10000000]
["tuptime","[d/year]",355]
["Condensate gas-ratio, Cgr","[Sm3/Sm3]",2.9999999999999997E-4]
["oil price, Po","[USD/Sm3]",300]
["gas price, Pg","[USD/Sm3]",0.15]
["Discount rate, i","[-]",0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPVrev [1E09 USD]",{"$f":"SUM(Q23:Q33)/1000000000","v":5.7451170479457199}]
[]
[null,"time","qfield","DGp","Gp","Rf","pR","qwell","pwf","pwh","pTH","psep","Dpchoke",null,"DNp","Revenue","Discounted revenue"]
[null,"[years]","[Sm3/d]","[Sm3]","[Sm3]","[-]","[bara]","[Sm3/d]","[bara]","[bara]","[bara]","[bara]","[bar]",null,"[Sm3]","[USD]","[USD]"]
[null,0,{"$f":"$C$12","v":10000000},0,{"$f":"D22","v":0},{"$f":"E22/$C$3","v":0},{"$f":"C4","v":240},{"$f":"C22/$C$11","v":1666666.6666666667},{"$f":"IPRpwf($C$5,$C$6,G22,H22)","v":216.68167495790252},{"$f":"Tubingp2($C$7,$C$8,I22,H22)","v":169.16958955292409},{"$f":"linep1($C$9,L22,C22)","v":93.284729813225766},{"$f":"$C$10","v":60},{"$f":"J22-K22","v":75.884859739698328},null,0,0,0]
[null,1,{"$f":"$C$12","v":10000000},{"$f":"C22*(B23-B22)*$C$13","v":3550000000},{"$f":"SUM($D$22:D23)","v":3550000000},{"$f":"E23/$C$3","v":4.9305555555555554E-2},{"$f":"MBgastank_PR($G$22,F23)","v":228.16666666666666},{"$f":"C23/$C$11","v":1666666.6666666667},{"$f":"IPRpwf($C$5,$C$6,G23,H23)","v":203.49686985391176},{"$f":"Tubingp2($C$7,$C$8,I23,H23)","v":158.15988023021106},{"$f":"linep1($C$9,L23,C23)","v":93.284729813225766},{"$f":"$C$10","v":60},{"$f":"J23-K23","v":64.875150416985292},null,{"$f":"$C$14*D23","v":1065000},{"$f":"O23*$C$15+D23*$C$16","v":852000000},{"$f":"P23/((1+$C$17)^B23)","v":788888888.88888884}]
[null,2,10000000,{"$f":"C23*(B24-B23)*$C$13","v":3550000000},{"$f":"SUM($D$22:D24)","v":7100000000},9.8611111111111108E-2,{"$f":"MBgastank_PR($G$22,F24)","v":216.33333333333334},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G24,H24)","v":190.13431929473762},{"$f":"Tubingp2($C$7,$C$8,I24,H24)","v":146.94530984444958},{"$f":"linep1($C$9,L24,C24)","v":93.284729813225766},60,53.660580031223816,null,1065000,852000000,{"$f":"P24/((1+$C$17)^B24)","v":730452674.89711928}]
[null,3,10000000,3550000000,{"$f":"SUM($D$22:D25)","v":10650000000},0.14791666666666667,{"$f":"MBgastank_PR($G$22,F25)","v":204.5},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G25,H25)","v":176.553669637768},{"$f":"Tubingp2($C$7,$C$8,I25,H25)","v":135.47501298041848},{"$f":"linep1($C$9,L25,C25)","v":93.284729813225766},60,42.190283167192717,null,1065000,852000000,676345069.34918451]
[null,4,10000000,3550000000,{"$f":"SUM($D$22:D26)","v":14200000000},0.19722222222222222,{"$f":"MBgastank_PR($G$22,F26)","v":192.66666666666669},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G26,H26)","v":162.70031563278104},{"$f":"Tubingp2($C$7,$C$8,I26,H26)","v":123.67785931493358},{"$f":"linep1($C$9,L26,C26)","v":93.284729813225766},60,30.393129501707818,null,1065000,852000000,626245434.58257818]
[null,5,10000000,3550000000,{"$f":"SUM($D$22:D27)","v":17750000000},0.24652777777777779,{"$f":"MBgastank_PR($G$22,F27)","v":180.83333333333334},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G27,H27)","v":148.49795522836862},{"$f":"Tubingp2($C$7,$C$8,I27,H27)","v":111.45010234773733},{"$f":"linep1($C$9,L27,C27)","v":93.284729813225766},60,18.165372534511562,null,1065000,852000000,579856883.87275755]
[null,6,10000000,3550000000,{"$f":"SUM($D$22:D28)","v":21300000000},0.29583333333333334,{"$f":"MBgastank_PR($G$22,F28)","v":169},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G28,H28)","v":133.83552690732802},{"$f":"Tubingp2($C$7,$C$8,I28,H28)","v":98.631721204866039},{"$f":"linep1($C$9,L28,C28)","v":93.284729813225766},60,5.3469913916402732,null,1065000,852000000,536904522.10440505]
[null,7,9330263.6121839248,3550000000,{"$f":"SUM($D$22:D29)","v":24850000000},0.34513888888888888,{"$f":"MBgastank_PR($G$22,F29)","v":157.16666666666666},1555043.9353639875,{"$f":"IPRpwf($C$5,$C$6,G29,H29)","v":122.21384681589318},{"$f":"Tubingp2($C$7,$C$8,I29,H29)","v":89.674537119840863},{"$f":"linep1($C$9,L29,C29)","v":89.674530281833768},60,6.8380070956663985E-6,null,1065000,852000000,497133816.76333803]
[null,8,8281006.9143716004,3312243582.3252931,{"$f":"SUM($D$22:D30)","v":28162243582.325294},0.39114227197674017,{"$f":"MBgastank_PR($G$22,F30)","v":146.12585472558237},1380167.8190619333,{"$f":"IPRpwf($C$5,$C$6,G30,H30)","v":113.75615638196699},{"$f":"Tubingp2($C$7,$C$8,I30,H30)","v":84.253970822220253},{"$f":"linep1($C$9,L30,C30)","v":84.253951495739599},60,1.9326480654058287E-5,null,993673.07469758787,794938459.75807023,429480514.90121138]
[null,9,7339011.2974089738,2939757454.6019182,{"$f":"SUM($D$22:D31)","v":31102001036.927212},0.43197223662398904,{"$f":"MBgastank_PR($G$22,F31)","v":136.32666321024263},1223168.5495681623,{"$f":"IPRpwf($C$5,$C$6,G31,H31)","v":106.54249196584915},{"$f":"Tubingp2($C$7,$C$8,I31,H31)","v":79.674441576794209},{"$f":"linep1($C$9,L31,C31)","v":79.674428983531882},60,1.2593262326276999E-5,null,881927.23638057534,705541789.10446024,352946551.2675879]
[null,10,6492337.2491704719,2605349010.5801859,{"$f":"SUM($D$22:D32)","v":33707350047.507397},0.46815763954871387,{"$f":"MBgastank_PR($G$22,F32)","v":127.64216650830866},1082056.2081950787,{"$f":"IPRpwf($C$5,$C$6,G32,H32)","v":100.43164567392334},{"$f":"Tubingp2($C$7,$C$8,I32,H32)","v":75.832282749137519},{"$f":"linep1($C$9,L32,C32)","v":75.832267564189692},60,1.5184947827151518E-5,null,781604.70317405567,625283762.53924453,289627367.01326811]
[null,11,5730507.1536160689,{"$f":"C32*(B33-B32)*$C$13","v":2304779723.4555173},{"$f":"SUM($D$22:D33)","v":36012129770.962914},0.50016846904115153,{"$f":"MBgastank_PR($G$22,F33)","v":119.95956743012363},{"$f":"C33/$C$11","v":955084.52560267819},{"$f":"IPRpwf($C$5,$C$6,G33,H33)","v":95.293307729171985},{"$f":"Tubingp2($C$7,$C$8,I33,H33)","v":72.632254197646006},{"$f":"linep1($C$9,L33,C33)","v":72.632255244627089},60,{"$f":"J33-K33","v":-1.0469810831637005E-6},null,691433.91703665513,553147133.6293242,{"$f":"P33/((1+$C$17)^B33)","v":237235324.30538115}]

{"sheet":"Task_2","index":1,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Problem 1, TPG4230, Exam 2021"]
[]
["Initial gas in place, G","[Sm3]",{"$f":"Task_1!C3","v":72000000000}]
["Initial reservoir pressure, pRi","[bara]",{"$f":"Task_1!C4","v":240}]
["Inflow coefficient, CR","[Sm3/d/bar2n]",{"$f":"Task_1!C5","v":1000}]
["Inflow exponent, n","[-]",{"$f":"Task_1!C6","v":0.8}]
["Tubing flow coefficient, CT","[Sm3/d/bar]",{"$f":"Task_1!C7","v":38000}]
["Tubing exponent, S","[-]",{"$f":"Task_1!C8","v":0.43}]
["Pipeline coefficient, CPL","[Sm3/d/bar]",{"$f":"Task_1!C9","v":140000}]
["psep","[bara]",{"$f":"Task_1!C10","v":60}]
["Nproducers","[-]",{"$f":"Task_1!C11","v":6}]
["qplateau,field","[Sm3/d]",{"$f":"Task_1!C12","v":10000000}]
["tuptime","[d/year]",{"$f":"Task_1!C13","v":355}]
["Condensate gas-ratio, Cgr","[Sm3/Sm3]",{"$f":"Task_1!C14","v":2.9999999999999997E-4},null,null,null,null,null,null,null,null,null,"NPVrev difference between natural flow and compressor [1E09 USD]",null,null,null,null,{"$f":"R18-Task_1!Q18","v":0.91475915802739838}]
["oil price, Po","[USD/Sm3]",{"$f":"Task_1!C15","v":300}]
["gas price, Pg","[USD/Sm3]",{"$f":"Task_1!C16","v":0.15}]
["Discount rate, i","[-]",{"$f":"Task_1!C17","v":0.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPVrev [1E09 USD]",{"$f":"SUM(R23:R36)/1000000000","v":6.6598762059731182}]
[]
[null,"time","qfield","DGp","Gp","Rf","pR","qwell","pwf","pwh","pTH","psep","Dpchoke/Dpcompressor","Powercomp",null,"DNp","Revenue","Discounted revenue"]
[null,"[years]","[Sm3/d]","[Sm3]","[Sm3]","[-]","[bara]","[Sm3/d]","[bara]","[bara]","[bara]","[bara]","[bar]","[MW]",null,"[Sm3]","[USD]","[USD]"]
[null,0,{"$f":"$C$12","v":10000000},0,{"$f":"D22","v":0},{"$f":"E22/$C$3","v":0},{"$f":"C4","v":240},{"$f":"C22/$C$11","v":1666666.6666666667},{"$f":"IPRpwf($C$5,$C$6,G22,H22)","v":216.68167495790252},{"$f":"Tubingp2($C$7,$C$8,I22,H22)","v":169.16958955292409},{"$f":"linep1($C$9,L22,C22)","v":93.284729813225766},{"$f":"$C$10","v":60},{"$f":"J22-K22","v":75.884859739698328},0]
[null,1,{"$f":"$C$12","v":10000000},{"$f":"C22*(B23-B22)*$C$13","v":3550000000},{"$f":"SUM($D$22:D23)","v":3550000000},{"$f":"E23/$C$3","v":4.9305555555555554E-2},{"$f":"MBgastank_PR($G$22,F23)","v":228.16666666666666},{"$f":"C23/$C$11","v":1666666.6666666667},{"$f":"IPRpwf($C$5,$C$6,G23,H23)","v":203.49686985391176},{"$f":"Tubingp2($C$7,$C$8,I23,H23)","v":158.15988023021106},{"$f":"linep1($C$9,L23,C23)","v":93.284729813225766},{"$f":"$C$10","v":60},{"$f":"J23-K23","v":64.875150416985292},0,null,{"$f":"$C$14*D23","v":1065000},{"$f":"P23*$C$15+D23*$C$16","v":852000000},{"$f":"Q23/((1+$C$17)^B23)","v":788888888.88888884}]
[null,2,10000000,{"$f":"C23*(B24-B23)*$C$13","v":3550000000},{"$f":"SUM($D$22:D24)","v":7100000000},9.8611111111111108E-2,{"$f":"MBgastank_PR($G$22,F24)","v":216.33333333333334},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G24,H24)","v":190.13431929473762},{"$f":"Tubingp2($C$7,$C$8,I24,H24)","v":146.94530984444958},{"$f":"linep1($C$9,L24,C24)","v":93.284729813225766},60,53.660580031223816,0,null,1065000,852000000,{"$f":"Q24/((1+$C$17)^B24)","v":730452674.89711928}]
[null,3,10000000,3550000000,{"$f":"SUM($D$22:D25)","v":10650000000},0.14791666666666667,{"$f":"MBgastank_PR($G$22,F25)","v":204.5},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G25,H25)","v":176.553669637768},{"$f":"Tubingp2($C$7,$C$8,I25,H25)","v":135.47501298041848},{"$f":"linep1($C$9,L25,C25)","v":93.284729813225766},60,42.190283167192717,0,null,1065000,852000000,676345069.34918451]
[null,4,10000000,3550000000,{"$f":"SUM($D$22:D26)","v":14200000000},0.19722222222222222,{"$f":"MBgastank_PR($G$22,F26)","v":192.66666666666669},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G26,H26)","v":162.70031563278104},{"$f":"Tubingp2($C$7,$C$8,I26,H26)","v":123.67785931493358},{"$f":"linep1($C$9,L26,C26)","v":93.284729813225766},60,30.393129501707818,0,null,1065000,852000000,626245434.58257818]
[null,5,10000000,3550000000,{"$f":"SUM($D$22:D27)","v":17750000000},0.24652777777777779,{"$f":"MBgastank_PR($G$22,F27)","v":180.83333333333334},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G27,H27)","v":148.49795522836862},{"$f":"Tubingp2($C$7,$C$8,I27,H27)","v":111.45010234773733},{"$f":"linep1($C$9,L27,C27)","v":93.284729813225766},60,18.165372534511562,0,null,1065000,852000000,579856883.87275755]
[null,6,10000000,3550000000,{"$f":"SUM($D$22:D28)","v":21300000000},0.29583333333333334,{"$f":"MBgastank_PR($G$22,F28)","v":169},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G28,H28)","v":133.83552690732802},{"$f":"Tubingp2($C$7,$C$8,I28,H28)","v":98.631721204866039},{"$f":"linep1($C$9,L28,C28)","v":93.284729813225766},60,5.3469913916402732,0,null,1065000,852000000,536904522.10440505]
[null,7,10000000,3550000000,{"$f":"SUM($D$22:D29)","v":24850000000},0.34513888888888888,{"$f":"MBgastank_PR($G$22,F29)","v":157.16666666666666},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G29,H29)","v":118.54243701591946},{"$f":"Tubingp2($C$7,$C$8,I29,H29)","v":84.955789845450809},{"$f":"linep1($C$9,L29,C29)","v":93.284729813225766},60,{"$f":"K29-J29","v":8.3289399677749572},{"$f":"Power_c(K29,J29,C29)/1000000","v":1.3451831761836333},null,1065000,852000000,497133816.76333803]
[null,8,10000000,3550000000,{"$f":"SUM($D$22:D30)","v":28400000000},0.39444444444444443,{"$f":"MBgastank_PR($G$22,F30)","v":145.33333333333334},1666666.6666666667,{"$f":"IPRpwf($C$5,$C$6,G30,H30)","v":102.33633782943332},{"$f":"Tubingp2($C$7,$C$8,I30,H30)","v":69.92091757558012},{"$f":"linep1($C$9,L30,C30)","v":93.284729813225766},60,{"$f":"K30-J30","v":23.363812237645647},{"$f":"Power_c(K30,J30,C30)/1000000","v":4.2750251452133492},null,1065000,852000000,460309089.59568334]
[null,9,9648566.5991354957,3550000000,{"$f":"SUM($D$22:D31)","v":31950000000},0.44374999999999998,{"$f":"MBgastank_PR($G$22,F31)","v":133.5},1608094.4331892494,{"$f":"IPRpwf($C$5,$C$6,G31,H31)","v":87.400966574950502},{"$f":"Tubingp2($C$7,$C$8,I31,H31)","v":56.376913712477744},{"$f":"linep1($C$9,L31,C31)","v":91.37689315662243},60,34.999979444144685,{"$f":"Power_c(K31,J31,C31)/1000000","v":7.1258200438933832},null,1065000,852000000,426212119.99600309]
[null,10,8569006.6745747458,3425241142.6931009,{"$f":"SUM($D$22:D32)","v":35375241142.6931},0.49132279364851528,{"$f":"MBgastank_PR($G$22,F32)","v":122.08252952435633},1428167.779095791,{"$f":"IPRpwf($C$5,$C$6,G32,H32)","v":78.259555280095512},{"$f":"Tubingp2($C$7,$C$8,I32,H32)","v":50.710664859213146},{"$f":"linep1($C$9,L32,C32)","v":85.710677123118074},60,35.000012263904928,{"$f":"Power_c(K32,J32,C32)/1000000","v":6.9237508994314094},null,1027572.3428079302,822057874.24634409,380771854.17964482]
[null,11,7610918.6246705567,3041997369.4740348,{"$f":"SUM($D$22:D33)","v":38417238512.167137},0.53357275711343244,{"$f":"MBgastank_PR($G$22,F33)","v":111.94253829277622},1268486.4374450927,{"$f":"IPRpwf($C$5,$C$6,G33,H33)","v":70.433891482676074},{"$f":"Tubingp2($C$7,$C$8,I33,H33)","v":45.965488088367785},{"$f":"linep1($C$9,L33,C33)","v":80.965501065727651},60,35.000012977359866,{"$f":"Power_c(K33,J33,C33)/1000000","v":6.6772736754261661},null,912599.21084221033,730079368.67376828,313118527.18024713]
[null,12,6761479.8026838601,{"$f":"C33*(B34-B33)*$C$13","v":2701876111.7580476},{"$f":"SUM($D$22:D34)","v":41119114623.925186},0.57109881422118314,{"$f":"MBgastank_PR($G$22,F34)","v":102.93628458691605},{"$f":"C34/$C$11","v":1126913.3004473101},{"$f":"IPRpwf($C$5,$C$6,G34,H34)","v":63.770143429476526},{"$f":"Tubingp2($C$7,$C$8,I34,H34)","v":42.02291260102723},{"$f":"linep1($C$9,L34,C34)","v":77.022925662806742},60,35.000013061779512,{"$f":"Power_c(K34,J34,C34)/1000000","v":6.3890851757519229},null,810562.83352741424,648450266.82193136,{"$f":"Q34/((1+$C$17)^B34)","v":257508522.75265309}]
[null,13,6009046.1185050663,{"$f":"C34*(B35-B34)*$C$13","v":2400325329.9527702},{"$f":"SUM($D$22:D35)","v":43519439953.87796},0.60443666602608281,{"$f":"MBgastank_PR($G$22,F35)","v":94.935200153740126},{"$f":"C35/$C$11","v":1001507.6864175111},{"$f":"IPRpwf($C$5,$C$6,G35,H35)","v":58.12640578997005},{"$f":"Tubingp2($C$7,$C$8,I35,H35)","v":38.771779583556572},{"$f":"linep1($C$9,L35,C35)","v":73.771792094905209},60,35.000012511348636,{"$f":"Power_c(K35,J35,C35)/1000000","v":6.0647669493284182},null,720097.59898583102,576078079.18866479,{"$f":"Q35/((1+$C$17)^B35)","v":211822714.16682747}]
[null,14,5343002.181638957,2133211372.0692985,{"$f":"SUM($D$22:D36)","v":45652651325.947258},0.63406460174926749,{"$f":"MBgastank_PR($G$22,F36)","v":87.824495580175807},890500.36360649287,{"$f":"IPRpwf($C$5,$C$6,G36,H36)","v":53.372207470979902},{"$f":"Tubingp2($C$7,$C$8,I36,H36)","v":36.109177180890605},{"$f":"linep1($C$9,L36,C36)","v":71.109168842845719},60,34.999991661955114,{"$f":"Power_c(K36,J36,C36)/1000000","v":5.712227014034319},null,639963.41162078944,511970729.29663157,174306087.64378828]