{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","PVT","TPR"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":25,"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":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[48,18,48,19]]}
["Exam TPG4245, Autumn 2022, Prof. Milan Stanko.",null,null,"Input"]
[null,null,null,"Calculated"]
[]
["Reservoir pressure, pR","[bara]",400]
["Productivity Index, J","[Sm3/d/bar]",10]
["Bubble point pressure (pb) @TR","[bara]",null,"<--Task 1",null,null,null,null,null,"Task 1 - Explanation -->"]
["Reservoir GOR","[Sm3/Sm3]",null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
["Task 2",null,null,null,null,null,null,null,null,"Task 2 - Explanation -->"]
[null,"pwf (IPR)","qo ","pwf (TPR)","pwf (TPR)-pwf (IPR)",null,null,null,null," -->"]
[null,"[bara]","[Sm3/d]","[bara]","[bar]",null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
["Task 3",null,null,null,null,null,null,null,null," -->"]
["Skin factor, initial","[-]",3,null,null,null,null,null,null,"Task 3 - Explanation  -->"]
["Skin factor, new","[-]",0,null,null,null,null,null,null," -->"]
["ln(re/rw)","[-]",8,null,null,null,null,null,null," -->"]
["New productivity index, J","[Sm3/d/bar]",null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,"pwf (IPR)","qo ","pwf (TPR)","pwf (TPR)-pwf (IPR)",null,null,null,null," -->"]
[null,"[bara]","[Sm3/d]","[bara]","[bar]",null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
["Task 4",null,null,null,null,null,null,null,null,"Task 4 - Explanation -->"]
["ESP hydraulic efficiency ","[-]",0.6,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,"pwf (IPR)","qo ","pwf (TPR)","pwf (TPR)-pwf (IPR)","Bo@psuc","qo@psuc","ESP power",null," -->"]
[null,"[bara]","[Sm3/d]","[bara]","[bar]","[-]","[m3/d]","[W]",null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
["Task 5",null,null,null,null,null,null,null,null,"Task 5 - Explanation -->"]
[null,"Tubing Rp (with gas lift)","pwf (IPR)","qo ","pwf (TPR)","pwf (TPR)-pwf (IPR)","qg - gas lift",null,null," -->"]
[null,"[-]","[bara]","[Sm3/d]","[bara]","[bar]","[Sm3/d]",null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
["Task 6",null,null,null,null,null,null,null,null,"Task 6 - Explanation -->"]
["Tubing inner diameter, d","[m]",{"$f":"4.5*25.4/1000","v":0.1143},null,null,null,null,null,null," -->"]
["Tubing cross section area, A","[m2]",{"$f":"((C42)^2)*PI()*0.25","v":1.0260826451724329E-2},null,null,null,null,null,null," -->"]
["Tubing wall roughness","[m]",1.0000000000000001E-5,null,null,null,null,null,null," -->"]
["Tubing inclination angle from horizontal","[deg]",90,null,null,null,null,null,null," -->"]
["Well oil rate at standard conditions, qo","[Sm3/d]",null,null,null,null,null,null,null," -->"]
["Well gas rate at standard conditions, qg","[Sm3/d]",null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[null,null,null,null,null,null,null,null,null," -->"]
[]
[null,null,null,"BO table column->",2,3,4,5,6,7,8,9]
[null,"TVD [m]","T [C]","p[bara]","Rs [Sm3/Sm3]","rs [Sm3/Sm3]","Bo [m3/Sm3]","Bg [m3/Sm3]","deng [kg/m3]","viscg [cp]","deno [kg/m3]","viso [cp]","qo [m3/d]","qg[m3/d]","uso [m/s]","usg [m/s]","lambdag[-]","ɛ - void fraction [-]","dp/dx [bara/m]"]
[null,0,80]
[null,500,80]
[null,1000,80]
[null,1500,80]
[null,2000,80]
[null,2500,80]

{"sheet":"PVT","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["T","[C]",80]
["COLUMN:",2,3,4,5,6,7,8,9]
["p","Rs","rs","Bo","Bg","deng","viscg","deno","visco"]
["[bara]","[Sm3/Sm3]","[Sm3/Sm3]","[m3/Sm3]","[m3/Sm3]","[kg/m3]","[cP]","[kg/m3]","[cP]"]
[1,0.59555999999999998,0,1.0355300000000001,1.2276899999999999,0.75144,1.2539E-2,811.73699999999997,1.41903]
[14.758599999999999,5.6726099999999997,0,1.04514,8.2159999999999997E-2,11.2286,1.2692E-2,808.75400000000002,1.33548]
[28.517199999999999,10.0177,0,1.0539000000000001,4.1432999999999998E-2,22.265799999999999,1.2935E-2,805.83900000000006,1.27023]
[42.2759,14.3302,0,1.06301,2.7241000000000001E-2,33.865299999999998,1.3247E-2,802.673,1.2104600000000001]
[56.034500000000001,18.717500000000001,0,1.07267,2.0046000000000001E-2,46.020400000000002,1.3625999999999999E-2,799.21699999999998,1.1541600000000001]
[69.793099999999995,23.221599999999999,0,1.0829599999999999,1.5716999999999998E-2,58.696100000000001,1.4074E-2,795.46400000000006,1.10059]
[83.551699999999997,27.864699999999999,0,1.0939099999999999,1.2845000000000001E-2,71.821299999999994,1.4592000000000001E-2,791.41600000000005,1.0493600000000001]
[97.310299999999998,32.660899999999998,0,1.1055600000000001,1.0817E-2,85.283299999999997,1.5181E-2,787.08100000000002,1.00027]
[111.069,37.6205,0,1.1179300000000001,9.3250999999999994E-3,98.930400000000006,1.5838000000000001E-2,782.46799999999996,0.95318000000000003]
[124.828,42.751800000000003,0,1.13103,8.1942000000000004E-3,112.584,1.6559000000000001E-2,777.58799999999997,0.90800999999999998]
[138.58600000000001,48.061999999999998,0,1.14489,7.3182000000000004E-3,126.06100000000001,1.7333999999999999E-2,772.45500000000004,0.86470000000000002]
[152.345,53.557699999999997,0,1.1595200000000001,6.6277999999999997E-3,139.19300000000001,1.8155000000000001E-2,767.08299999999997,0.82320000000000004]
[166.10300000000001,59.2453,0,1.17493,6.0755000000000002E-3,151.846,1.9009999999999999E-2,761.48599999999999,0.78346000000000005]
[179.86199999999999,65.130799999999994,0,1.1911400000000001,5.6277000000000002E-3,163.92699999999999,1.9890000000000001E-2,755.68100000000004,0.74546000000000001]
[193.62100000000001,71.220500000000001,0,1.20817,5.2601999999999996E-3,175.381,2.0782999999999999E-2,749.68200000000002,0.70916999999999997]
[207.37899999999999,77.520600000000002,0,1.2260200000000001,4.9548999999999999E-3,186.18700000000001,2.1683000000000001E-2,743.50699999999995,0.67456000000000005]
[221.13800000000001,84.037499999999994,0,1.24471,4.6985000000000004E-3,196.34800000000001,2.2582999999999999E-2,737.17200000000003,0.64159999999999995]
[234.89699999999999,90.777799999999999,0,1.2642599999999999,4.4809000000000003E-3,205.88200000000001,2.3476E-2,730.69299999999998,0.61026000000000002]
[248.655,97.748099999999994,0,1.28468,4.2944999999999997E-3,214.81800000000001,2.436E-2,724.08699999999999,0.58052999999999999]
[253,100,0,1.29131,0,0,0,721.97699999999998,0.57145999999999997]
[262.41399999999999,100,0,1.2894600000000001,0,0,0,723.01199999999994,0.57659000000000005]
[276.17200000000003,100,0,1.2869900000000001,0,0,0,724.40099999999995,0.58409]
[289.93099999999998,100,0,1.2847500000000001,0,0,0,725.66099999999994,0.59157999999999999]
[303.69,100,0,1.2827200000000001,0,0,0,726.80799999999999,0.59907999999999995]
[317.44799999999998,100,0,1.28088,0,0,0,727.85799999999995,0.60658000000000001]
[331.20699999999999,100,0,1.27918,0,0,0,728.822,0.61407999999999996]
[344.96600000000001,100,0,1.27762,0,0,0,729.71,0.62158000000000002]
[358.72399999999999,100,0,1.2761899999999999,0,0,0,730.53099999999995,0.62907999999999997]
[372.483,100,0,1.2748600000000001,0,0,0,731.29200000000003,0.63658000000000003]
[386.24099999999999,100,0,1.27363,0,0,0,731.99900000000002,0.64407999999999999]
[400,100,0,1.2724800000000001,0,0,0,732.65899999999999,0.65158000000000005]

{"sheet":"TPR","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Tubing performance relationship (TPR)"]
["pwh ","[bara]",100]
[]
["COLUMN",2,3,4,5,6]
["Rp (GOR)",100,200,400,600,800]
["qo","pwf","pwf","pwf","pwf","pwf"]
["[Sm3/d]","[bara]","[bara]","[bara]","[bara]","[bara]"]
[0,286.37799999999999,285.06700000000001,283.471,281.85700000000003,280.22500000000002]
[153.642,278.452,243.506,194.952,174.268,167.04]
[304.41399999999999,272.16399999999999,233.20599999999999,191.11,175.511,170.994]
[455.185,270.75700000000001,231.274,190.65799999999999,178.14599999999999,175.245]
[605.95699999999999,270.01299999999998,230.518,191.77600000000001,181.55,179.904]
[756.72900000000004,269.74299999999999,230.565,193.845,185.52600000000001,185.084]
[907.50099999999998,269.83199999999999,231.214,196.577,189.99,190.8]
[1058.27,270.21499999999997,232.34700000000001,199.83500000000001,194.90299999999999,197.041]
[1209.04,270.85000000000002,233.887,203.58,200.23599999999999,203.791]
[1359.82,271.70600000000002,235.78100000000001,207.72800000000001,205.96899999999999,211.03200000000001]
[1510.59,272.75900000000001,237.989,212.24700000000001,212.089,218.745]
[1661.36,273.99200000000002,240.48099999999999,217.107,218.578,226.91399999999999]
[1812.13,275.392,243.23400000000001,222.28800000000001,225.42500000000001,235.523]
[1962.9,276.94900000000001,246.22800000000001,227.77199999999999,232.614,244.559]
[2113.6799999999998,278.654,249.446,233.54400000000001,240.131,254.01]
[2264.4499999999998,280.49900000000002,252.874,239.589,247.965,263.87099999999998]
[2415.2199999999998,282.47899999999998,256.49900000000002,245.89699999999999,256.101,274.12900000000002]
[2565.9899999999998,284.529,260.31099999999998,252.25700000000001,264.52800000000002,284.76799999999997]
[2716.76,286.76100000000002,264.298,259.03300000000002,273.23500000000001,295.77699999999999]
[2867.54,289.11599999999999,268.452,266.04300000000001,282.43200000000002,307.142]