{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Field layout","ProdProf"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":1,"defined_names":37,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"ProdProf","index":2,"reason":"not_a_worksheet"}],"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":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[10,3,10,6],[10,7,10,10],[10,11,10,15]]}
["Problem 1, Exam TPG4230 - Prof Milan stanko"]
["uptime","[d]",355,null,"tplateau field [y]",4]
["qplateau field ","[Sm3/d]",12000]
["qplateau Alta","[Sm3/d]",9100]
["qplateau Gohta","[Sm3/d]",{"$f":"C3-C4","v":2900},null,null,null,null,null,null,null,null,null,null,"NPV CALCULATIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount rate","[1/year]",0.08]
[null,"N [1E06 Sm3]","qppo [Sm3/d]","Nwells",null,null,null,null,null,null,null,null,null,"Oil price","[USD/Sm3]",180]
["Alta",80,4100,6,null,null,null,null,null,null,null,null,null,"COST","[1E06 USD]",{"$f":"cost(C3,D8+D9)","v":2590}]
["Gohta",25,2700,3,null,null,null,null,null,null,null,null,null,"NPV","[1E06 USD]",{"$f":"P10-P8","v":2586.1550762707402}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NPVrev","[1E06 USD]",{"$f":"SUM(P14:P30)","v":5176.1550762707402}]
[null,null,null,"ALTA",null,null,null,"GOHTA",null,null,null,"FIELD"]
[null,null,"time","DNp","Np","qpp","q","DNp","Np","qpp","q","qfield","DNp","Np","Rf","Discounted yearly revenue"]
[null,null,"[y]","[1E06 Sm3]","[1E06 Sm3]","[Sm3/d]","[Sm3/d]","[1E06 Sm3]","[1E06 Sm3]","[Sm3/d]","[Sm3/d]","[Sm3/d]","[1E06 Sm3]","[1E06 Sm3]","[-]","[1E06 USD]"]
[null,null,0,0,0,{"$f":"qpp(E14,$B$8,$C$8,$D$8)","v":24600},{"$f":"IF(F14<$C$4,F14,$C$4)","v":9100},0,0,{"$f":"qpp(I14,$B$9,$C$9,$D$9)","v":8100},{"$f":"IF(J14<$C$5,J14,$C$5)","v":2900},{"$f":"G14+K14","v":12000},{"$f":"H14+D14","v":0},{"$f":"I14+E14","v":0},{"$f":"N14/($B$8+$B$9)","v":0},{"$f":"M14*$P$7/((1+$P$6)^C14)","v":0}]
[null,null,1,{"$f":"G14*(C15-C14)*$C$2/1000000","v":3.2305000000000001},{"$f":"E14+D15","v":3.2305000000000001},{"$f":"qpp(E15,$B$8,$C$8,$D$8)","v":19965.699209965096},{"$f":"IF(F15<$C$4,F15,$C$4)","v":9100},{"$f":"K14*(C15-C14)*$C$2/1000000","v":1.0295000000000001},{"$f":"H15+I14","v":1.0295000000000001},{"$f":"qpp(I15,$B$9,$C$9,$D$9)","v":6546.9850219177988},{"$f":"IF(J15<$C$5,J15,$C$5)","v":2900},{"$f":"G15+K15","v":12000},{"$f":"H15+D15","v":4.26},{"$f":"I15+E15","v":4.26},{"$f":"N15/($B$8+$B$9)","v":4.0571428571428571E-2},{"$f":"M15*$P$7/((1+$P$6)^C15)","v":709.99999999999989}]
[null,null,2,{"$f":"G15*(C16-C15)*$C$2/1000000","v":3.2305000000000001},{"$f":"E15+D16","v":6.4610000000000003},{"$f":"qpp(E16,$B$8,$C$8,$D$8)","v":16204.436786292717},{"$f":"IF(F16<$C$4,F16,$C$4)","v":9100},{"$f":"K15*(C16-C15)*$C$2/1000000","v":1.0295000000000001},{"$f":"H16+I15","v":2.0590000000000002},{"$f":"qpp(I16,$B$9,$C$9,$D$9)","v":5291.7299848414823},{"$f":"IF(J16<$C$5,J16,$C$5)","v":2900},12000,4.26,8.52,8.1142857142857142E-2,657.40740740740728]
[null,null,3,3.2305000000000001,9.6915000000000013,{"$f":"qpp(E17,$B$8,$C$8,$D$8)","v":13151.744339106252},9100,1.0295000000000001,3.0885000000000002,{"$f":"qpp(I17,$B$9,$C$9,$D$9)","v":4277.1453025667261},2900,12000,4.26,12.780000000000001,0.12171428571428572,608.71056241426595]
[null,null,4,3.2305000000000001,12.922000000000001,{"$f":"qpp(E18,$B$8,$C$8,$D$8)","v":10674.137055323441},9100,1.0295000000000001,4.1180000000000003,{"$f":"qpp(I18,$B$9,$C$9,$D$9)","v":3457.0871891938805},2900,12000,4.26,17.04,0.16228571428571428,563.62089112432034]
[null,null,5,3.2305000000000001,16.1525,{"$f":"qpp(E19,$B$8,$C$8,$D$8)","v":8663.2768200215578},8663.2768200215578,1.0295000000000001,5.1475000000000009,{"$f":"qpp(I19,$B$9,$C$9,$D$9)","v":2794.2590181624978},2794.2590181624978,11457.535838184056,4.26,21.3,0.20285714285714287,521.87119548548173]
[null,null,6,3.0754632711076533,19.227963271107654,{"$f":"qpp(E20,$B$8,$C$8,$D$8)","v":7102.0229505973512},7102.0229505973512,0.99196195144768673,6.1394619514476876,{"$f":"qpp(I20,$B$9,$C$9,$D$9)","v":2276.1124197261865},2276.1124197261865,9378.1353703235382,4.0674252225553396,25.36742522255534,0.24159452592909847,461.37021027707283]
[null,null,7,2.5212181474620596,21.749181418569712,{"$f":"qpp(E21,$B$8,$C$8,$D$8)","v":6034.4062092420763},6034.4062092420763,0.8080199090027963,6.947481860450484,{"$f":"qpp(I21,$B$9,$C$9,$D$9)","v":1925.9179519052757},1925.9179519052757,7960.3241611473522,3.329238056464856,28.696663279020196,0.27330155503828757,349.66411730791509]
[null,null,8,2.1422142042809371,23.891395622850649,{"$f":"qpp(E22,$B$8,$C$8,$D$8)","v":5254.3885581411614},5254.3885581411614,0.68370087292637294,7.6311827333768569,{"$f":"qpp(I22,$B$9,$C$9,$D$9)","v":1672.0337832064374},1672.0337832064374,6926.4223413475993,2.8259150772073101,31.522578356227505,0.30021503196407145,274.81571756281949]
[null,null,9,1.8653079381401123,25.756703560990761,{"$f":"qpp(E23,$B$8,$C$8,$D$8)","v":4657.7916180460807},4657.7916180460807,0.59357199303828534,8.2247547264151422,{"$f":"qpp(I23,$B$9,$C$9,$D$9)","v":1478.9224887003381},1478.9224887003381,6136.714106746419,2.4588799311783975,33.9814582874059,0.3236329360705324,221.40938625700792]
[null,null,10,1.6535160244063587,27.410219585397119,{"$f":"qpp(E24,$B$8,$C$8,$D$8)","v":4185.8242166103701},4185.8242166103701,0.52501748348861998,8.749772209903762,{"$f":"qpp(I24,$B$9,$C$9,$D$9)","v":1326.7882332838278},1326.7882332838278,5512.6124498941981,2.1785335078949788,36.159991795300883,0.34438087424096081,181.63485619762287]
[null,null,11,1.4859675968966815,28.896187182293801,{"$f":"qpp(E25,$B$8,$C$8,$D$8)","v":3802.6247372445569},3802.6247372445569,0.47100982281575887,9.2207820327195211,{"$f":"qpp(I25,$B$9,$C$9,$D$9)","v":1203.6699345852912},1203.6699345852912,5006.2946718298481,1.9569774197124403,38.11696921501332,0.3630187544286983,151.07653285659507]
[null,null,12,1.3499317817218177,30.246118964015619,{"$f":"qpp(E26,$B$8,$C$8,$D$8)","v":3485.0036145162221},3485.0036145162221,0.42730282677777837,9.648084859497299,{"$f":"qpp(I26,$B$9,$C$9,$D$9)","v":1101.8890621730102},1101.8890621730102,4586.8926766892328,1.777234608499596,39.894203823512917,0.37994479831917066,127.03757676786205]
[null,null,13,1.2371762831532589,31.483295247168876,{"$f":"qpp(E27,$B$8,$C$8,$D$8)","v":3217.2663159675722},3217.2663159675722,0.39117061707141859,10.039255476568718,{"$f":"qpp(I27,$B$9,$C$9,$D$9)","v":1016.2786764015243},1016.2786764015243,4233.5449923690967,1.6283469002246775,41.522550723737595,0.39545286403559615,107.77315965462843]
[null,null,14,1.1421295421684881,32.625424789337366,{"$f":"qpp(E28,$B$8,$C$8,$D$8)","v":2988.3941924021206},2988.3941924021206,0.36077893012254114,10.400034406691258,{"$f":"qpp(I28,$B$9,$C$9,$D$9)","v":943.2281808883082},943.2281808883082,3931.6223732904286,1.5029084722910291,43.025459196028621,0.40976627805741545,92.102721038949852]
[null,null,15,1.0608799383027527,33.68630472764012,{"$f":"qpp(E29,$B$8,$C$8,$D$8)","v":2790.4142980215265},2790.4142980215265,0.33484600421534938,10.734880410906607,{"$f":"qpp(I29,$B$9,$C$9,$D$9)","v":880.13514267367123},880.13514267367123,3670.5494406951975,1.3957259425181021,44.421185138546726,0.4230589060813974,79.198384641215441]
[null,null,16,0.99059707579764189,34.676901803437765,{"$f":"qpp(E30,$B$8,$C$8,$D$8)","v":2617.4095967786925},2617.4095967786925,0.31244797564915328,11.04732838655576,{"$f":"qpp(I30,$B$9,$C$9,$D$9)","v":825.0745314917333},825.0745314917333,3442.4841282704256,1.3030450514467953,45.724230189993527,0.43546885895231929,68.462357277575592]

{"sheet":"Field layout","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}