{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data-Layer1","PVT-Layer1","Data-Layer2","PVT-Layer2","Task2","Task3","Task4"],"not_rendered":{"charts":0,"images":1,"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-Layer1","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Exercise 1, Prof. Milan Stanko (NTNU)"]
["Horizontal permeability, kH","[md]",150]
["Vertical permeability, kv","[md]",{"$f":"C2/20","v":7.5}]
["Layer thickness, h","[m]",200]
["Reservoir width","[m]",800]
["Reservoir length","[m]",1000]
["Reservoir top area","[m2]",{"$f":"C6*C5","v":800000}]
["Reservoir pressure, pR","[bara]",400]
["Flowing bottom-hole pressure, pwf","[bara]"]
["pav","[bara]"]
["Oil viscosity, mo at average pressure","[cp]"]
["Oil volume factor, Bo, at average pressure","[m3/Sm3]"]
["Wellbore radius, rw","[m]"]
[]
["Vertical well located in the center and perforated throughout"]
["External radius, re","[m]"]
["Skin, s","[-]"]
["Shape factor, sA","[-]"]
["Productivity Index, J","[Sm3/d/bar]"]
[]
["Horizontal well "]
["Wellbore length","[m]"]
["Elevation difference between toe and heel, b (sign doesn't matter)","[m]"]
["Productivity Index, J","[Sm3/d/bar]"]

{"sheet":"PVT-Layer1","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["p","T","Bo","visco","deno","Undersaturated GOR [Sm3/Sm3]",172.74100673293896]
["[bara]","[C]"," [m3/Sm3]","[cp]","[kg/m3]"]
[1,82.2,1.057830521931816,2.1711377378618901,803.72196995841034]
[22,82.2,1.0791007921216071,1.6438114209792998,795.43520487998398]
[43,82.2,1.1071061555148831,1.2884446252010997,784.68746078215656]
[64,82.2,1.1392245453224095,1.0592826994792637,772.67179853331083]
[85,82.2,1.1746652424352237,0.90216643134395103,759.85508902143999]
[106,82.2,1.2129889120293242,0.78834519981520634,746.54441065434412]
[127,82.2,1.2538999108622249,0.70220939120411374,732.96551787683575]
[148,82.2,1.2971790635609579,0.63474757250187686,719.29023349393708]
[169,82.2,1.3426542657285248,0.58044516263928558,705.65051152382409]
[190,82.2,1.3901851623877346,0.53575480514602336,692.14742858064051]
[211,82.2,1.4396541822887001,0.49829686021276731,678.85765925571786]
[232,82.2,1.4909608464704067,0.46641765397262674,665.83843504483116]
[253,82.2,1.5440179325593402,0.43893307618057015,653.13146120926376]
[274,82.2,1.5368511081515281,0.44819297860924212,656.17722047174323]
[295,82.2,1.5307311499538736,0.45745288103791415,658.80065774853824]
[316,82.2,1.525444334518911,0.46671278346658612,661.08389903577074]
[337,82.2,1.5208314000080505,0.47597268589525815,663.08907642257384]
[358,82.2,1.5167712398161664,0.48523258832393013,664.86406252534994]
[379,82.2,1.5131701232769901,0.49449249075260215,666.44633865876904]
[400,82.2,1.5099543748863862,0.50375239318127418,667.86566878993744]

{"sheet":"Data-Layer2","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Exercise 1, Prof. Milan Stanko (NTNU)"]
["Horizontal permeability, kH","[md]",400]
["Vertical permeability, kv","[md]",{"$f":"C2/10","v":40}]
["Layer thickness, h","[m]",50]
["Reservoir width ","[m]",400]
["Reservoir length","[m]",500]
["Reservoir top area","[m2]",{"$f":"C6*C5","v":200000}]
["Reservoir pressure, pR","[bara]",500]
["Flowing bottom-hole pressure, pwf","[bara]"]
["pav","[bara]"]
["Oil viscosity, mo at average pressure","[cp]"]
["Oil volume factor, Bo, at average pressure","[m3/Sm3]"]
["Wellbore radius, rw","[m]"]
[]
["Vertical well located in the center and perforated throughout"]
["External radius, re","[m]"]
["Skin, s","[-]"]
["Shape factor, sA","[-]"]
["Productivity Index, J","[Sm3/d/bar]"]
[]
["Horizontal well "]
["Wellbore length","[m]"]
["Elevation difference between toe and heel, b (sign doesn't matter)","[m]"]
["Productivity Index, J","[Sm3/d/bar]"]

{"sheet":"PVT-Layer2","index":3,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["p","T","Bo","visco","deno","Undersaturated GOR [Sm3/Sm3]",125.92732672717966]
["[bara]","[C]"," [m3/Sm3]","[cp]","[kg/m3]"]
[1,82.2,1.0578572870815242,2.9702574283028369,822.61998621410191]
[27.263157894736842,82.2,1.0871595852860034,1.9933557635349011,810.83910484870705]
[53.526315789473685,82.2,1.126280264742191,1.4489319443134412,795.49451394813298]
[79.78947368421052,82.2,1.1715134214414107,1.1373292308771554,778.46152219496389]
[106.05263157894737,82.2,1.2217159791306846,0.93916600766495373,760.52360945964972]
[132.31578947368422,82.2,1.2762351845429651,0.80277058566092319,742.19181597127215]
[158.57894736842104,82.2,1.3346247094582571,0.70330249152164714,723.82370497018258]
[184.84210526315789,82.2,1.3965510106983734,0.62755347942114192,705.67192525798475]
[211.10526315789474,82.2,1.3883953547014429,0.64304829182568923,709.81715482073662]
[237.36842105263159,82.2,1.3820774305776171,0.65854310423023665,713.06195921933897]
[263.63157894736844,82.2,1.3770390328143645,0.67403791663478407,715.67095554753212]
[289.89473684210526,82.2,1.3729272274130209,0.68953272903933149,717.81433186191248]
[316.15789473684208,82.2,1.3695079443447573,0.7050275414438788,719.60651598266008]
[342.42105263157896,82.2,1.3666198259276334,0.72052235384842622,721.12728188438496]
[368.68421052631578,82.2,1.364148028142151,0.73601716625297364,722.43394419788797]
[394.94736842105266,82.2,1.3620085875961552,0.75151197865752106,723.56874208836859]
[421.21052631578948,82.2,1.3601386962016164,0.76700679106206837,724.56348987987451]
[447.4736842105263,82.2,1.3584904333547017,0.78250160346661579,725.44260617784551]
[473.73684210526318,82.2,1.3570266018111496,0.79799641587116321,726.22514483150383]
[500,82.2,1.355717887163076,0.81349122827571063,726.92619148275753]

{"sheet":"Task2","index":4,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Dh - between layers","[m]",100]
[null,null,"LAYER 1","LAYER 2","WELL",null,"Dh - between pwf 1 - pwf 2","[m]",{"$f":"I1+'Data-Layer1'!C4*0.5+'Data-Layer2'!C4*0.5","v":225}]
["pR ","[bara]",{"$f":"'Data-Layer1'!C8","v":400},{"$f":"'Data-Layer2'!C8","v":500},null,null,"Den of oil column","[kg/m3]"]
["J","[Sm3/d/bar]",{"$f":"'Data-Layer1'!C19","v":0},{"$f":"'Data-Layer2'!$C$19","v":0}]
["pwf ","[bara]"]
["qo ","[Sm3/d]"]
["Rp","[Sm3/Sm3]",{"$f":"'PVT-Layer1'!$G$1","v":172.74100673293896},{"$f":"'PVT-Layer2'!G1","v":125.92732672717966}]
["qg","[Sm3/d]"]

{"sheet":"Task3","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Dh - between layers","[m]",100]
[null,null,"LAYER 1","LAYER 2","WELL",null,"Dh - between pwf 1 - pwf 2","[m]",{"$f":"I1+'Data-Layer1'!C4*0.5+'Data-Layer2'!C4*0.5","v":225}]
["pR ","[bara]",{"$f":"'Data-Layer1'!C8","v":400},{"$f":"'Data-Layer2'!C8","v":500},null,null,"Den of oil column","[kg/m3]"]
["J","[Sm3/d/bar]",{"$f":"'Data-Layer1'!C19","v":0},{"$f":"'Data-Layer2'!$C$19","v":0}]
["DP ICV","[bar]"]
["pwf ","[bara]"]
["qo ","[Sm3/d]"]
["Rp","[Sm3/Sm3]",{"$f":"'PVT-Layer1'!$G$1","v":172.74100673293896},{"$f":"'PVT-Layer2'!G1","v":125.92732672717966}]
["qg","[Sm3/d]"]

{"sheet":"Task4","index":6,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Dh - between layers","[m]",100]
[null,null,"LAYER 1","LAYER 2","WELL",null,"Dh - between pwf 1 - pwf 2","[m]",{"$f":"I1+'Data-Layer1'!C4*0.5+'Data-Layer2'!C4*0.5","v":225}]
["pR ","[bara]",{"$f":"'Data-Layer1'!C8","v":400},{"$f":"'Data-Layer2'!C8","v":500},null,null,"Den of oil column","[kg/m3]"]
["J","[Sm3/d/bar]",{"$f":"'Data-Layer1'!C24","v":0},{"$f":"'Data-Layer2'!$C$24","v":0}]
["pwf ","[bara]"]
["qo ","[Sm3/d]"]
["Rp","[Sm3/Sm3]",{"$f":"'PVT-Layer1'!$G$1","v":172.74100673293896},{"$f":"'PVT-Layer2'!G1","v":125.92732672717966}]
["qg","[Sm3/d]"]