{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","N_dist","cdf_plot","pdf_plot"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"cdf_plot","index":2,"reason":"not_a_worksheet"},{"sheet":"pdf_plot","index":3,"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":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Problem 1 Undersaturated oil field, TPG4230 V2020, Resit exam, Prof. Milan Stanko "]
["Annual uptime",360,"day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Question 3. PROBABILITY TREE",null,null,"Base case cost [1E06 USD]",200]
["Initial Reservoir Pressure, PRi",265,"bara"]
["Reservoir Pressure decline rate, CD",70,"bara",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case","Probability N","N [1E06 Sm3]","Probability Cost factor","Cost factor","Cost [1E06 USD]","Probability of case","NPV of case [1E06 USD]"]
["Initial oil in place ",4000000,"[Sm3]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - Low N, high cost",0.5,3.6,0.5,1.1000000000000001,{"$f":"$W$2*W5","v":220.00000000000003},{"$f":"V5*T5","v":0.25},85.776754616381538]
["Productivity index well (oil)",60,"Sm3/d/bara",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - Low N, low cost",0.5,3.6,0.5,0.9,{"$f":"$W$2*W6","v":180},{"$f":"V6*T6","v":0.25},125.77675461638154]
["Oil density, Rho",861,"kg/m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - High N, high cost",0.5,5.2,0.5,1.1000000000000001,220.00000000000003,0.25,233.64044324432797]
["Oil viscosity(average), Vis",1.0300000000000001E-3,"Pa s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - High N, low cost",0.5,5.2,0.5,0.9,180,0.25,193.64044324432797]
["Tubing data",null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV CALCULATIONS"]
["Measured depth, MD",2200,"m",null,null,null,null,null,null,null,null,null,null,null,"Discount rate","[1/year]",0.08]
["Deviation angle  (from horizontal)",90,"deg",null,null,null,null,null,null,null,null,null,null,null,"Oil price","[USD/Sm3]",180]
["Tubing inner Diameter, ID",0.154,"m",null,null,null,null,null,null,null,null,null,null,null,"COST","[1E06 USD]",200]
["Tubing Roughness",1.5E-5,"m",null,null,null,null,null,null,null,null,null,null,null,"NPV","[1E06 USD]",{"$f":"Q14-Q12","v":122.78372724919188}]
["Pipeline data",null,null,null,null,null,null,null,null,null,null,null,null,null,"NPVrev","[1E06 USD]",{"$f":"SUM(O17:O21)","v":322.78372724919188}]
["Horizontal pipe length",14000,"m","time","qwwell","DNp","Np","RF","PR","pwf","Pwh","Priserbase","psep","error","Discounted yearly revenue"]
["Pipeline inner diameter, ID",{"$f":"10*0.0254","v":0.254},"m","[year]","[Sm3/d]","[Sm3]","[Sm3]","[-]","[bara]","[bara]","[bara]","[bara]","[bara]","[bar]","[1E06 USD]"]
["Deviation angle  (from horizontal)",0,"deg",0,{"$f":"IPRqo(I17,$B$6,J17)","v":2424.9119483814634},{"$f":"E17*(D18-D17)*$B$2","v":872968.30141732679},0,{"$f":"G17/$B$5","v":0},{"$f":"B3","v":265},224.58480086030895,{"$f":"pout(E17,$B$12,$B$7,$B$8,$B$10,$B$11,J17,$B$13)","v":36.494948112450743},{"$f":"pout(E17,$B$16,$B$7,$B$8,$B$15,$B$17,K17,$B$18)","v":35.219931885060873},{"$f":"pout(E17,$B$21,$B$7,$B$8,$B$20,$B$22,L17,$B$13)","v":20.000000819280146},{"$f":"($B$24-M17)","v":-8.1928014594723209E-7},0]
["Pipeline roughness",1.5E-5,"m",1,{"$f":"IPRqo(I18,$B$6,J18)","v":1619.4408555832574},{"$f":"E18*(D19-D18)*$B$2","v":582998.7080099727},{"$f":"G17+F17","v":872968.30141732679},{"$f":"G18/$B$5","v":0.21824207535433171},{"$f":"pressuredecline($I$17,G18,$B$4,$B$5)","v":249.72305472519679},222.73237379880916,{"$f":"pout(E18,$B$12,$B$7,$B$8,$B$10,$B$11,J18,$B$13)","v":35.82742651336094},{"$f":"pout(E18,$B$16,$B$7,$B$8,$B$15,$B$17,K18,$B$18)","v":35.21145767497871},{"$f":"pout(E18,$B$21,$B$7,$B$8,$B$20,90,L18,$B$13)","v":20.00000007562808},{"$f":"($B$24-M18)","v":-7.5628079798661929E-8},{"$f":"F17*$Q$11/((1+$Q$10)^D18)/1000000","v":145.4947169028878}]
["Riser data",null,null,2,{"$f":"IPRqo(I19,$B$6,J19)","v":1061.9101084044705},{"$f":"E19*(D20-D19)*$B$2","v":382287.63902560936},{"$f":"G18+F18","v":1455967.0094272995},0.36399175235682485,{"$f":"pressuredecline($I$17,G19,$B$4,$B$5)","v":239.52057733502227},221.82207552828109,{"$f":"pout(E19,$B$12,$B$7,$B$8,$B$10,$B$11,J19,$B$13)","v":35.49676664009943},{"$f":"pout(E19,$B$16,$B$7,$B$8,$B$15,$B$17,K19,$B$18)","v":35.207260229705746},{"$f":"pout(E19,$B$21,$B$7,$B$8,$B$20,90,L19,$B$13)","v":20.000000004429253},{"$f":"($B$24-M19)","v":-4.4292534084888757E-9},{"$f":"F18*$Q$11/((1+$Q$10)^D19)/1000000","v":89.968936421292071}]
["vertical pipe length",180,"m",3,{"$f":"IPRqo(I20,$B$6,J20)","v":686.43949899358404},{"$f":"E20*(D21-D20)*$B$2","v":247118.21963769026},{"$f":"G19+F19","v":1838254.6484529087},0.45956366211322719,{"$f":"pressuredecline($I$17,G20,$B$4,$B$5)","v":232.83054365207408},221.38988533551435,{"$f":"pout(E20,$B$12,$B$7,$B$8,$B$10,$B$11,J20,$B$13)","v":35.338662086969812},{"$f":"pout(E20,$B$16,$B$7,$B$8,$B$15,$B$17,K20,$B$18)","v":35.205253256507255},{"$f":"pout(E20,$B$21,$B$7,$B$8,$B$20,90,L20,$B$13)","v":20.000000000115591},{"$f":"($B$24-M20)","v":-1.155910922534531E-10},54.625005576361644]
["Flowline data diameter, ID",{"$f":"10*0.0254","v":0.254},"m",4,{"$f":"IPRqo(I21,$B$6,J21)","v":438.96932339796763},{"$f":"E21*(D22-D21)*$B$2","v":158028.95642326833},{"$f":"G20+F20","v":2085372.8680905991},0.52134321702264974,{"$f":"pressuredecline($I$17,G21,$B$4,$B$5)","v":228.50597480841452},221.18981941844839,{"$f":"pout(E21,$B$12,$B$7,$B$8,$B$10,$B$11,J21,$B$13)","v":35.2650112995629},{"$f":"pout(E21,$B$16,$B$7,$B$8,$B$15,$B$17,K21,$B$18)","v":35.204318339334122},{"$f":"pout(E21,$B$21,$B$7,$B$8,$B$20,90,L21,$B$13)","v":20.000000001274035},{"$f":"($B$24-M21)","v":-1.2740350996409688E-9},32.695068348650352]
["Deviation angle  (from horizontal)",90,"deg",5]
["Riser roughness",1.5E-5,"m",6]
["Separator Pressure",20,"bara",7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]

{"sheet":"N_dist","index":1,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["N [1E06 Sm3]","pdf","cdf"]
[2.4003673328371788,3.8026304940885007E-5,0]
[2.634633863614761,2.6328524453332033E-4,1.6075807993758643E-3]
[2.8689003943923432,1.0055107785341771E-3,8.3486249497444955E-3]
[3.1031669251699254,2.5379793719581606E-3,2.8274090483763108E-2]
[3.3374334559475076,4.7487396288773591E-3,7.0441681939728815E-2]
[3.5716999867250898,7.1106486512130598E-3,0.13999651162780433]
[3.805966517502672,8.9855472903212965E-3,0.23489627260782642]
[4.0402330482802542,9.9539259979661478E-3,0.34667111235386305]
[4.274499579057836,9.9400602956195312E-3,0.46394710705495873]
[4.5087661098354177,9.1377046245340859E-3,0.57617456154195468]
[4.7430326406129995,7.8579018174245677E-3,0.67590603437443075]
[4.9772991713905812,6.4004911670463831E-3,0.75936453819280236]
[5.211565702168163,4.9868386364425501E-3,0.82585794821803404]
[5.4458322329457447,3.7458219317840331E-3,0.87673780034014881]
[5.6800987637233264,2.7297535525209701E-3,0.91439246026027343]
[5.9143652945009082,1.9399386140924195E-3,0.9414987229486077]
[6.1486318252784899,1.3501250106022404E-3,0.96056747088154382]
[6.3828983560560717,9.2341567738177591E-4,0.97372714989447484]
[6.6171648868336534,6.224716765786826E-4,0.9826648328975226]
[6.8514314176112352,4.1456991488055049E-4,0.98865472775018903]
[7.0856979483888169,2.7335159897319523E-4,1]