{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Task.1.1.","Task.1.2.","Task.2.2.","Task.2.3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":134,"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.1.","index":0,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Snohvit Gas Field, Prof. Michael Golan, Prof. Milan Stanko"]
[" G (IGIP), Initial gas in place",{"$f":"270000000000","v":270000000000},"[Sm3]",null,null,null,"SOLVING EXPLANATION"]
["Production days per year (uptime)",360,"[day]",null,null,null,"end of year 0 (Gp = 0 Sm^3, pR=276 bara)"]
["TR , reservoir temperature",92,"[°C]",null,null,null,0,"Set Gp=0 and DeltaGp=0. Calculate Rf as Gp/G"]
["pRi, initial reservoir pressure",276,"[bara]",null,null,null,1,"With qwell = 20E06 / 9, and using the IPR equation, calculate the pwf available "]
["CR, inflow backpressure coefficient",1000,"[Sm3/bar^2n]",null,null,null,2," With the tubing equation, qwell and pwf, calculate pwh available . "]
["n, inflow backpressure exponent",1,"[-]",null,null,null,3,"With the pipeline equation, qfield = 20E06 Sm^3/d, and psep = 30 bara, Calculate the pplem required"]
["Ct, Tubing flow coefficient (2100 MDx0.15 ID  m)",40288.195917865203,"[Sm3/bar]",null,null,null,4,"With the flowline equation, qtemplate and pplem calculate ptemplate required."]
["S, Tubing elevation coefficient",0.155,"[-]",null,null,null,5,"Calculate dp choke by pwh-ptemp"]
["CFL , flowline coefficient from template-PLEM (5000x0.355  ID m)",283126.86618411407,"[Sm3/bar]",null,null,null,6,"Calculate Z for reservoir pressure using the ZfacStanding() VBA function"]
["CPL Pipeline coefficient from PLEM-Shore (158600x0.68  ID m)",275064.39272584103,"[Sm3/bar]",null,null,null,"For next time steps"]
["Separator  (slug catcher) pressure",30,"[bara]",null,null,null,null,"Calculate deltaGp by using the trapezoidal rule (qfield_i + qfield_i-1)*(ti – t_i-1)*uptime*0.5",null,null,null,null,null,null,null,null,null,"Suction T (Tplem)","[C]",67]
["Gas molecular weight (Methane)",16,"[kg/kmole]",null,null,null,null,"Calculate Gp by summing the deltaGp of the timestep to the previous  year Gp",null,null,null,null,null,null,null,null,null,"Adiabatic exponent, k","[-]",{"$f":"k(B14)","v":1.2990516764604219}]
["Gas specific gravity",{"$f":"$B$13/28.93","v":0.55305910819218806},"[-]",null,null,null,null,"Use the material balance equation to find pR at time 1. Use Z of the previous step.",null,null,null,null,null,null,null,null,null,"Compressor data"]
["Gas density at Sc",{"$f":"101325/((8314/(0.55*28.97))*(273.15+15.56))","v":0.67259858638728143},"[kg/m^3]",null,null,null,null,"Repeat steps 1-6",null,null,null,null,null,null,null,null,null,"Polytropic efficiency, hp","[-]",0.7]
["Number of templates",3,null,null,null,null,"When choke DP is negative",null,null,null,null,null,null,null,null,null,null,"Maximum compressor power","[MW]",22]
["Number of wells per template",3,null,null,null,null,null,"Use goal seek to change qfield to get deltap choke = 0",null,null,null,null,null,null,null,null,null,"Minimum suction pressure","[bara]",15]
["qfield",20000000,"[Sm^3/d]"]
[]
[null,"time","qfield","DGp","Gp","Rf","Z","pR","qwell","pwf","pwh","ptemp ","pplem","psep","qtemp","Dpchoke","psuc","m","Compressor power"]
[null,"[years]","[Sm^3/d]","[Sm^3]","[Sm^3]","[-]","[-]","[bara]","[Sm^3/d]","[bara]","[bara]","[bara]","[bara]","[bara]","[Sm^3/d]","[bar]","[bara]","[kg/s]","[MW]"]
[null,0,{"$f":"$B$18","v":20000000},0,0,{"$f":"E22/$B$2","v":0},{"$f":"ZfacStanding(H22,$B$4,$B$14,2)","v":0.96729106430049372},{"$f":"B5","v":276},{"$f":"C22/($B$17*$B$16)","v":2222222.222222222},{"$f":"IPRpwf($B$6,$B$7,H22,I22)","v":271.94443876971962},{"$f":"Tubingp2($B$8,$B$9,J22,I22)","v":245.54575249764781},{"$f":"linep1($B$10,M22,O22)","v":82.104939113916686},{"$f":"linep1($B$11,N22,C22)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C22/$B$16","v":6666666.666666667},{"$f":"K22-L22","v":163.44081338373113}]
[null,1,{"$f":"$B$18","v":20000000},{"$f":"(C23+C22)*0.5*(B23-B22)*$B$3","v":7200000000},{"$f":"E22+D23","v":7200000000},{"$f":"E23/$B$2","v":2.6666666666666668E-2},{"$f":"ZfacStanding(H23,$B$4,$B$14,2)","v":0.96267166832039974},{"$f":"MBgastank_PR($H$22,$G$22,G22,F23)","v":268.64},{"$f":"C23/($B$17*$B$16)","v":2222222.222222222},{"$f":"IPRpwf($B$6,$B$7,H23,I23)","v":264.47160032369783},{"$f":"Tubingp2($B$8,$B$9,J23,I23)","v":238.45279022768443},{"$f":"linep1($B$10,M23,O23)","v":82.104939113916686},{"$f":"linep1($B$11,N23,C23)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C23/$B$16","v":6666666.666666667},{"$f":"K23-L23","v":156.34785111376775}]
[null,2,{"$f":"$B$18","v":20000000},{"$f":"(C24+C23)*0.5*(B24-B23)*$B$3","v":7200000000},{"$f":"E23+D24","v":14400000000},{"$f":"E24/$B$2","v":5.3333333333333337E-2},{"$f":"ZfacStanding(H24,$B$4,$B$14,2)","v":0.95755599932655078},{"$f":"MBgastank_PR($H$22,$G$22,G23,F24)","v":260.03223102308738},{"$f":"C24/($B$17*$B$16)","v":2222222.222222222},{"$f":"IPRpwf($B$6,$B$7,H24,I24)","v":255.72355962762225},{"$f":"Tubingp2($B$8,$B$9,J24,I24)","v":230.13573066484068},{"$f":"linep1($B$10,M24,O24)","v":82.104939113916686},{"$f":"linep1($B$11,N24,C24)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C24/$B$16","v":6666666.666666667},{"$f":"K24-L24","v":148.03079155092399}]
[null,3,20000000,7200000000,21600000000,0.08,{"$f":"ZfacStanding(H25,$B$4,$B$14,2)","v":0.95273450120800862},{"$f":"MBgastank_PR($H$22,$G$22,G24,F25)","v":251.36448409644805},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H25,I25)","v":246.90460028693525},{"$f":"Tubingp2($B$8,$B$9,J25,I25)","v":221.73466020312284},{"$f":"linep1($B$10,M25,O25)","v":82.104939113916686},{"$f":"linep1($B$11,N25,C25)","v":78.656087193782554},30,6666666.666666667,139.62972108920616]
[null,4,20000000,7200000000,28800000000,0.10666666666666667,{"$f":"ZfacStanding(H26,$B$4,$B$14,2)","v":0.94833808688555954},{"$f":"MBgastank_PR($H$22,$G$22,G25,F26)","v":242.84956957368502},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H26,I26)","v":238.23033228348959},{"$f":"Tubingp2($B$8,$B$9,J26,I26)","v":213.45327682525581},{"$f":"linep1($B$10,M26,O26)","v":82.104939113916686},{"$f":"linep1($B$11,N26,C26)","v":78.656087193782554},30,6666666.666666667,131.34833771133913]
[null,5,20000000,7200000000,36000000000,0.13333333333333333,{"$f":"ZfacStanding(H27,$B$4,$B$14,2)","v":0.94437722310323535},{"$f":"MBgastank_PR($H$22,$G$22,G26,F27)","v":234.51314578933824},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H27,I27)","v":229.72634443134552},{"$f":"Tubingp2($B$8,$B$9,J27,I27)","v":205.31487766880684},{"$f":"linep1($B$10,M27,O27)","v":82.104939113916686},{"$f":"linep1($B$11,N27,C27)","v":78.656087193782554},30,6666666.666666667,123.20993855489016]
[null,6,20000000,7200000000,43200000000,0.16,{"$f":"ZfacStanding(H28,$B$4,$B$14,2)","v":0.94084273068708024},{"$f":"MBgastank_PR($H$22,$G$22,G27,F28)","v":226.34801817649986},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H28,I28)","v":221.38474001205887},{"$f":"Tubingp2($B$8,$B$9,J28,I28)","v":197.31071197177846},{"$f":"linep1($B$10,M28,O28)","v":82.104939113916686},{"$f":"linep1($B$11,N28,C28)","v":78.656087193782554},30,6666666.666666667,115.20577285786177]
[null,7,20000000,7200000000,50400000000,0.18666666666666668,{"$f":"ZfacStanding(H29,$B$4,$B$14,2)","v":0.93772294819693658},{"$f":"MBgastank_PR($H$22,$G$22,G28,F29)","v":218.34211436385743},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H29,I29)","v":213.19253430328553},{"$f":"Tubingp2($B$8,$B$9,J29,I29)","v":189.42690839527737},{"$f":"linep1($B$10,M29,O29)","v":82.104939113916686},{"$f":"linep1($B$11,N29,C29)","v":78.656087193782554},30,6666666.666666667,107.32196928136068]
[null,8,20000000,7200000000,57600000000,0.21333333333333335,{"$f":"ZfacStanding(H30,$B$4,$B$14,2)","v":0.93500635818201971},{"$f":"MBgastank_PR($H$22,$G$22,G29,F30)","v":210.48308417875552},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H30,I30)","v":205.13631200540499},{"$f":"Tubingp2($B$8,$B$9,J30,I30)","v":181.64885317581312},{"$f":"linep1($B$10,M30,O30)","v":82.104939113916686},{"$f":"linep1($B$11,N30,C30)","v":78.656087193782554},30,6666666.666666667,99.54391406189643]
[null,9,20000000,7200000000,64800000000,0.24,{"$f":"ZfacStanding(H31,$B$4,$B$14,2)","v":0.93268193553218104},{"$f":"MBgastank_PR($H$22,$G$22,G30,F31)","v":202.75896359498739},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H31,I31)","v":197.20287801117712},{"$f":"Tubingp2($B$8,$B$9,J31,I31)","v":173.96174107372096},{"$f":"linep1($B$10,M31,O31)","v":82.104939113916686},{"$f":"linep1($B$11,N31,C31)","v":78.656087193782554},30,6666666.666666667,91.856801959804272]
[null,10,20000000,7200000000,72000000000,0.26666666666666666,{"$f":"ZfacStanding(H32,$B$4,$B$14,2)","v":0.93073917732170108},{"$f":"MBgastank_PR($H$22,$G$22,G31,F32)","v":195.15824214527183},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H32,I32)","v":189.3792946840027},{"$f":"Tubingp2($B$8,$B$9,J32,I32)","v":166.35052076507193},{"$f":"linep1($B$10,M32,O32)","v":82.104939113916686},{"$f":"linep1($B$11,N32,C32)","v":78.656087193782554},30,6666666.666666667,84.245581651155248]
[null,11,20000000,7200000000,79200000000,0.29333333333333333,{"$f":"ZfacStanding(H33,$B$4,$B$14,2)","v":0.92916809366019693},{"$f":"MBgastank_PR($H$22,$G$22,G32,F33)","v":187.66985020801448},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H33,I33)","v":181.6528294711546},{"$f":"Tubingp2($B$8,$B$9,J33,I33)","v":158.79972657681051},{"$f":"linep1($B$10,M33,O33)","v":82.104939113916686},{"$f":"linep1($B$11,N33,C33)","v":78.656087193782554},30,6666666.666666667,76.694787462893828]
[null,12,20000000,7200000000,86400000000,0.32,{"$f":"ZfacStanding(H34,$B$4,$B$14,2)","v":0.92795919480632505},{"$f":"MBgastank_PR($H$22,$G$22,G33,F34)","v":180.28313736595399},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H34,I34)","v":174.01088298232733},{"$f":"Tubingp2($B$8,$B$9,J34,I34)","v":151.29325280942291},{"$f":"linep1($B$10,M34,O34)","v":82.104939113916686},{"$f":"linep1($B$11,N34,C34)","v":78.656087193782554},30,6666666.666666667,69.188313695506224]
[null,13,20000000,7200000000,93600000000,0.34666666666666668,{"$f":"ZfacStanding(H35,$B$4,$B$14,2)","v":0.9271034784622797},{"$f":"MBgastank_PR($H$22,$G$22,G34,F35)","v":172.98785048581277},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H35,I35)","v":166.44090300608107},{"$f":"Tubingp2($B$8,$B$9,J35,I35)","v":143.81405996340803},{"$f":"linep1($B$10,M35,O35)","v":82.104939113916686},{"$f":"linep1($B$11,N35,C35)","v":78.656087193782554},30,6666666.666666667,61.709120849491342]
[null,14,20000000,7200000000,100800000000,0.37333333333333335,{"$f":"ZfacStanding(H36,$B$4,$B$14,2)","v":0.92659241766375156},{"$f":"MBgastank_PR($H$22,$G$22,G35,F36)","v":165.77411241857789},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H36,I36)","v":158.93028070806733},{"$f":"Tubingp2($B$8,$B$9,J36,I36)","v":136.34378518838784},{"$f":"linep1($B$10,M36,O36)","v":82.104939113916686},{"$f":"linep1($B$11,N36,C36)","v":78.656087193782554},30,6666666.666666667,54.238846074471155]
[null,15,20000000,7200000000,108000000000,0.4,{"$f":"ZfacStanding(H37,$B$4,$B$14,2)","v":0.92641794934612942},{"$f":"MBgastank_PR($H$22,$G$22,G36,F37)","v":158.63240138177187},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H37,I37)","v":151.46622245875599},{"$f":"Tubingp2($B$8,$B$9,J37,I37)","v":128.86221331525974},{"$f":"linep1($B$10,M37,O37)","v":82.104939113916686},{"$f":"linep1($B$11,N37,C37)","v":78.656087193782554},30,6666666.666666667,46.757274201343051]
[null,16,20000000,7200000000,115200000000,0.42666666666666669,{"$f":"ZfacStanding(H38,$B$4,$B$14,2)","v":0.92657246364480295},{"$f":"MBgastank_PR($H$22,$G$22,G37,F38)","v":151.55353100521415},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H38,I38)","v":144.03558774804992},{"$f":"Tubingp2($B$8,$B$9,J38,I38)","v":121.3465396501046},{"$f":"linep1($B$10,M38,O38)","v":82.104939113916686},{"$f":"linep1($B$11,N38,C38)","v":78.656087193782554},30,6666666.666666667,39.241600536187917]
[null,17,20000000,7200000000,122400000000,0.45333333333333331,{"$f":"ZfacStanding(H39,$B$4,$B$14,2)","v":0.92704879399154816},{"$f":"MBgastank_PR($H$22,$G$22,G38,F39)","v":144.52863101327887},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H39,I39)","v":136.6246791774835},{"$f":"Tubingp2($B$8,$B$9,J39,I39)","v":113.77031252153672},{"$f":"linep1($B$10,M39,O39)","v":82.104939113916686},{"$f":"linep1($B$11,N39,C39)","v":78.656087193782554},30,6666666.666666667,31.665373407620038]
[null,18,20000000,7200000000,129600000000,0.48,{"$f":"ZfacStanding(H40,$B$4,$B$14,2)","v":0.9278402080770578},{"$f":"MBgastank_PR($H$22,$G$22,G39,F40)","v":137.54912851374621},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H40,I40)","v":129.21896351801018},{"$f":"Tubingp2($B$8,$B$9,J40,I40)","v":106.10186608784156},{"$f":"linep1($B$10,M40,O40)","v":82.104939113916686},{"$f":"linep1($B$11,N40,C40)","v":78.656087193782554},30,6666666.666666667,23.996926973924872]
[null,19,20000000,7200000000,136800000000,0.50666666666666671,{"$f":"ZfacStanding(H41,$B$4,$B$14,2)","v":0.92894039976065723},{"$f":"MBgastank_PR($H$22,$G$22,G40,F41)","v":130.6067298607089},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H41,I41)","v":121.80269152480156},{"$f":"Tubingp2($B$8,$B$9,J41,I41)","v":98.301907741327241},{"$f":"linep1($B$10,M41,O41)","v":82.104939113916686},{"$f":"linep1($B$11,N41,C41)","v":78.656087193782554},30,6666666.666666667,16.196968627410556]
[null,20,20000000,7200000000,144000000000,0.53333333333333333,{"$f":"ZfacStanding(H42,$B$4,$B$14,2)","v":0.93034348202310868},{"$f":"MBgastank_PR($H$22,$G$22,G41,F42)","v":123.69340305619069},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H42,I42)","v":114.35836540191987},{"$f":"Tubingp2($B$8,$B$9,J42,I42)","v":90.319631656926987},{"$f":"linep1($B$10,M42,O42)","v":82.104939113916686},{"$f":"linep1($B$11,N42,C42)","v":78.656087193782554},30,6666666.666666667,8.2146925430103011]
[null,21,20000000,7200000000,151200000000,0.56000000000000005,{"$f":"ZfacStanding(H43,$B$4,$B$14,2)","v":0.9320439810784088},{"$f":"MBgastank_PR($H$22,$G$22,G42,F43)","v":116.80136065206969},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H43,I43)","v":106.86597039260268},{"$f":"Tubingp2($B$8,$B$9,J43,I43)","v":82.086098775811763},{"$f":"linep1($B$10,M43,O43)","v":82.104939113916686},{"$f":"linep1($B$11,N43,C43)","v":78.656087193782554},30,6666666.666666667,-1.8840338104922694E-2]
[null,22,18643451.327547647,6955821238.9585762,158155821238.95859,0.58576230088503178,{"$f":"ZfacStanding(H44,$B$4,$B$14,2)","v":0.93396222286991515},{"$f":"MBgastank_PR($H$22,$G$22,G43,F44)","v":110.163552720423},2071494.5919497386,{"$f":"IPRpwf($B$6,$B$7,H44,I44)","v":100.32205019852654},{"$f":"Tubingp2($B$8,$B$9,J44,I44)","v":77.302675097499147},{"$f":"linep1($B$10,M44,O44)","v":77.302676901546533},{"$f":"linep1($B$11,N44,C44)","v":74.121014289164691},30,6214483.7758492157,-1.8040473861447026E-6]
[null,23,17378725.677173082,6483991860.8497314,164639813099.80832,0.60977708555484567,{"$f":"ZfacStanding(H45,$B$4,$B$14,2)","v":0.93598874233519669},{"$f":"MBgastank_PR($H$22,$G$22,G44,F45)","v":103.99057619288007},1930969.519685898,{"$f":"IPRpwf($B$6,$B$7,H45,I45)","v":94.250042001270728},{"$f":"Tubingp2($B$8,$B$9,J45,I45)","v":72.872597250692152},{"$f":"linep1($B$10,M45,O45)","v":72.872597639005818},{"$f":"linep1($B$11,N45,C45)","v":69.941294539680655},30,5792908.5590576939,-3.8831366566682846E-7]
[null,24,16193913.436323307,6043075040.4293509,170682888140.23767,0.63215884496384322,{"$f":"ZfacStanding(H46,$B$4,$B$14,2)","v":0.93808337826899091},{"$f":"MBgastank_PR($H$22,$G$22,G45,F46)","v":98.23875481697965},1799323.7151470343,{"$f":"IPRpwf($B$6,$B$7,H46,I46)","v":88.608855273294267},{"$f":"Tubingp2($B$8,$B$9,J46,I46)","v":68.771621700249199},{"$f":"linep1($B$10,M46,O46)","v":68.771693789490087},{"$f":"linep1($B$11,N46,C46)","v":66.076095813650539},30,5397971.1454411028,-7.2089240887862616E-5]
[null,25,15082980.510936122,5629840910.5066977,176312729050.74435,0.6530101075953495,{"$f":"ZfacStanding(H47,$B$4,$B$14,2)","v":0.94021148254250175},{"$f":"MBgastank_PR($H$22,$G$22,G46,F47)","v":92.877426093873041},1675886.723437347,{"$f":"IPRpwf($B$6,$B$7,H47,I47)","v":83.368636515091822},{"$f":"Tubingp2($B$8,$B$9,J47,I47)","v":64.977063822947201},{"$f":"linep1($B$10,M47,O47)","v":64.97799969004943},{"$f":"linep1($B$11,N47,C47)","v":62.504457974379768},30,5027660.1703120405,-9.3586710222837155E-4]
[null,26,14040038.558605034,{"$f":"(C48+C47)*0.5*(B48-B47)*$B$3","v":5242143432.5174084},{"$f":"E47+D48","v":181554872483.26175},0.67242545364171014,{"$f":"ZfacStanding(H48,$B$4,$B$14,2)","v":0.94234486181077348},{"$f":"MBgastank_PR($H$22,$G$22,G47,F48)","v":87.879505665539924},{"$f":"C48/($B$17*$B$16)","v":1560004.2842894483},{"$f":"IPRpwf($B$6,$B$7,H48,I48)","v":78.503523689896966},{"$f":"Tubingp2($B$8,$B$9,J48,I48)","v":61.470258459467651},{"$f":"linep1($B$10,M48,O48)","v":61.470260273252485},{"$f":"linep1($B$11,N48,C48)","v":59.206086405111201},30,{"$f":"C48/$B$16","v":4680012.8528683446},{"$f":"K48-L48","v":-1.8137848343258156E-6}]
[null,27]
[null,28]
[null,29]
[null,30]

{"sheet":"Task.1.2.","index":1,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,2,11,7]]}
["Gas price",0.1,"[usd/Sm^3]",null,null,null,null,"SOLVING EXPLANATION"]
["Discount rate",5,"[%]",null,null,null,null,null,"Add expenses as indicated in the problem text"]
["DRILLEX",null,null,null,null,null,null,null,"Production starts at end of year 5, so, there will be volume produced from year 6. Link this year to the deltaGp for time \"1\" in the previous Task1.1. and drag for subsequent time steps"]
["Well cost",100,"[1E06 USD]","(4 wells maximum per year)",null,null,null,null,"Calculate revenue by multiplying yearly gas offtake by gas price"]
["CAPEX",null,null,null,null,null,null,null,"Opex applies from end of year 6"]
["Pipeline and umbilicals",500,"[1E06 USD]","(paid in years 1 and 2)",null,null,null,null,"For each year, calculate cash flow by  summing revenue minus expenses. Remove years at the end for which there is no production"]
["Cost LNG plant",3200,"[1E06 USD]","(paid in years 1 and 2)",null,null,null,null,"discount cash flow by dividing by discount factor (1+i)^t"]
["Cost of LNG carriers",800,"[1E06 USD]","(paid in years 1 and 2)",null,null,null,null,"sum all discounted cash flow to find project NPV"]
["OPEX"]
["OPEX",200,"[1E06 USD]","(paid anually when production starts)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NPV [1E06 USD]=",{"$f":"SUM(M15:M45)","v":710.72676031845037}]
[null,null,"CAPITAL EXPENSES"]
[null,"End of year","Nwells","DRILLEX","Pipeline &  umbilicals","LNG Plant","LNG vessels","TOTAL \nCAPEX","Yearly gas\nofftake ","Revenues","OPEX","Cash flow","Discounted \ncash flow","NPV"]
[null,"[-]","[-]","[1E06 USD]","[1E06 USD]","[1E06 USD]","[1E06 USD]","[1E06 USD]","[Sm^3]","[1E06 USD]","[1E06 USD]","[1E06 USD]","[1E06 USD]","[1E06 USD]"]
[null,1,4,{"$f":"C15*$B$4","v":400},{"$f":"$B$6/2","v":250},{"$f":"$B$7/2","v":1600},{"$f":"$B$8/2","v":400},{"$f":"G15+F15+E15+D15","v":2650},0,{"$f":"I15*$B$1/1000000","v":0},0,{"$f":"J15-K15-H15","v":-2650},{"$f":"L15/((1+$B$2/100)^B15)","v":-2523.8095238095239},{"$f":"M15","v":-2523.8095238095239}]
[null,2,4,400,{"$f":"$B$6/2","v":250},{"$f":"$B$7/2","v":1600},{"$f":"$B$8/2","v":400},{"$f":"G16+F16+E16+D16","v":2650},0,{"$f":"I16*$B$1/1000000","v":0},0,{"$f":"J16-K16-H16","v":-2650},{"$f":"L16/((1+$B$2/100)^B16)","v":-2403.6281179138323},{"$f":"N15+M16","v":-4927.4376417233561}]
[null,3,1,100,0,0,0,100,0,0,0,-100,-86.383759853147595,{"$f":"N16+M17","v":-5013.8214015765034}]
[null,4,0,0,0,0,0,0,0,0,0,0,0,-5013.8214015765034]
["PROD STARTS--> ",5,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D22","v":0},0,0,0,0,-5013.8214015765034]
[null,6,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D23","v":7200000000},720,{"$f":"$B$10","v":200},520,388.03200625104637,-4625.789395325457]
[null,7,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D24","v":7200000000},720,200,520,369.55429166766316,-4256.2351036577938]
[null,8,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D25","v":7200000000},720,200,520,351.95646825491735,-3904.2786354028767]
[null,9,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D26","v":7200000000},720,200,520,335.19663643325458,-3569.081998969622]
[null,10,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D27","v":7200000000},720,200,520,319.23489184119484,-3249.8471071284271]
[null,11,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D28","v":7200000000},720,200,520,304.03323032494745,-2945.8138768034796]
[null,12,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D29","v":7200000000},720,200,520,289.55545745233093,-2656.2584193511489]
[null,13,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D30","v":7200000000},720,200,520,275.7671023355532,-2380.4913170155955]
[null,14,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D31","v":7200000000},720,200,520,262.6353355576698,-2117.8559814579257]
[null,15,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D32","v":7200000000},720,200,520,250.1288910073045,-1867.7270904506213]
[null,16,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D33","v":7200000000},720,200,520,238.21799143552812,-1629.5090990150932]
[null,17,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D34","v":7200000000},720,200,520,226.8742775576458,-1402.6348214574473]
[null,18,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D35","v":7200000000},720,200,520,216.07074053109125,-1186.5640809263559]
[null,19,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D36","v":7200000000},720,200,520,205.78165764865832,-980.7824232776976]
[null,20,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D37","v":7200000000},720,200,520,195.98253109396032,-784.79989218373726]
[null,21,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D38","v":7200000000},720,200,520,186.65002961329554,-598.14986257044166]
[null,22,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D39","v":7200000000},720,200,520,177.76193296504337,-420.38792960539831]
[null,23,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D40","v":7200000000},720,200,520,169.29707901432698,-251.09085059107133]
[null,24,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D41","v":7200000000},720,200,520,161.2353133469781,-89.855537244093227]
[null,25,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D42","v":7200000000},720,200,520,153.55744128283629,63.701904038743066]
[null,26,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D43","v":7200000000},720,200,520,146.24518217412981,209.94708621287288]
[null,27,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D44","v":6955821238.9585762},695.58212389585765,200,495.58212389585765,132.74083881207301,342.68792502494591]
[null,28,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D45","v":6483991860.8497314},648.39918608497317,200,448.39918608497317,114.38377927041415,457.07170429536006]
[null,29,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D46","v":6043075040.4293509},604.30750404293508,200,404.30750404293508,98.225020695765949,555.29672499112598]
[null,30,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D47","v":5629840910.5066977},562.9840910506698,200,362.9840910506698,83.986332889969688,639.28305788109571]
[null,31,0,0,0,0,0,0,{"$f":"'Task.1.1.'!D48","v":5242143432.5174084},524.21434325174084,200,324.21434325174084,71.443702437354673,710.72676031845037]

{"sheet":"Task.2.2.","index":2,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Snohvit Gas Field, Prof. Michael Golan, Prof. Milan Stanko",null,null,null,"SOLVING EXPLANATION"]
[" G (IGIP), Initial gas in place",{"$f":"270000000000","v":270000000000},"[Sm3]",null,null,"Task 2.1. Measures to prolong plateau:"]
["Production days per year (uptime)",360,"[day]",null,null,null,"increase formation productivity (fracking, acidizing). Available pressure at wellhead is larger and therefore Dpchoke becomes negative at a later time."]
["TR , reservoir temperature",92,"[°C]",null,null,null,"Drill more wells. Available pressure at wellhead is larger and therefore Dpchoke becomes negative at a later time."]
["pRi, initial reservoir pressure",276,"[bara]",null,null,null,"Increase tubing size or flowline diameter.  Available pressure at wellhead is larger and therefore Dpchoke becomes negative at a later time."]
["CR, inflow backpressure coefficient",1000,"[Sm3/bar^2n]",null,null,null,"Increase pipeline diameter or put another pipeline in parallel. Required pressure at the plem will be lower, and therefore Dpchoke becomes negative at a later time"]
["n, inflow backpressure exponent",1,"[-]",null,null,null,"Install a compressor (provides energy to match the difference between available and required pressure post plateau."]
["Ct, Tubing flow coefficient (2100 MDx0.15 ID  m)",40288.195917865203,"[Sm3/bar]",null,null,"Task 2.2. Measured chosen: Drill 3 more wells"]
["S, Tubing elevation coefficient",0.155,"[-]",null,null,null,"Repeat procedure given in task 1.1."]
["CFL , flowline coefficient from template-PLEM (5000x0.355  ID m)",283126.86618411407,"[Sm3/bar]",null,null,null,"When choke becomes negative, use the goalseek to change year until Dpchoke is exactly equal to Zero. "]
["CPL Pipeline coefficient from PLEM-Shore (158600x0.68  ID m)",275064.39272584103,"[Sm3/bar]",null,null,null,"3 more wells give 1.4 additional plateau years."]
["Separator  (slug catcher) pressure",30,"[bara]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suction T (Tplem)","[C]",67]
["Gas molecular weight (Methane)",16,"[kg/kmole]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adiabatic exponent, k","[-]",{"$f":"k(B14)","v":1.2990516764604219}]
["Gas specific gravity",{"$f":"$B$13/28.93","v":0.55305910819218806},"[-]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compressor data"]
["Gas density at Sc",{"$f":"101325/((8314/(0.55*28.97))*(273.15+15.56))","v":0.67259858638728143},"[kg/m^3]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polytropic efficiency, hp","[-]",0.7]
["Number of templates",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum compressor power","[MW]",22]
["Number of wells per template",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum suction pressure","[bara]",15]
["qfield",20000000,"[Sm^3/d]"]
[]
[null,"time","qfield","DGp","Gp","Rf","Z","pR","qwell","pwf","pwh","ptemp ","pplem","psep","qtemp","Dpchoke","psuc","Dp comp","m","Compressor power"]
[null,"[years]","[Sm^3/d]","[Sm^3]","[Sm^3]","[-]","[-]","[bara]","[Sm^3/d]","[bara]","[bara]","[bara]","[bara]","[bara]","[Sm^3/d]","[bar]","[bara]","[bar]","[kg/s]","[MW]"]
[null,0,{"$f":"$B$18","v":20000000},0,0,{"$f":"E22/$B$2","v":0},{"$f":"ZfacStanding(H22,$B$4,$B$14,2)","v":0.96729106430049372},{"$f":"B5","v":276},{"$f":"C22/($B$17*$B$16)","v":1666666.6666666667},{"$f":"IPRpwf($B$6,$B$7,H22,I22)","v":272.96397808746366},{"$f":"Tubingp2($B$8,$B$9,J22,I22)","v":249.19783713574216},{"$f":"linep1($B$10,M22,O22)","v":82.104939113916686},{"$f":"linep1($B$11,N22,C22)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C22/$B$16","v":6666666.666666667},{"$f":"K22-L22","v":167.09289802182548}]
[null,1,{"$f":"$B$18","v":20000000},{"$f":"(C23+C22)*0.5*(B23-B22)*$B$3","v":7200000000},{"$f":"E22+D23","v":7200000000},{"$f":"E23/$B$2","v":2.6666666666666668E-2},{"$f":"ZfacStanding(H23,$B$4,$B$14,2)","v":0.96267166832039974},{"$f":"MBgastank_PR($H$22,$G$22,G22,F23)","v":268.64},{"$f":"C23/($B$17*$B$16)","v":1666666.6666666667},{"$f":"IPRpwf($B$6,$B$7,H23,I23)","v":265.51983529170343},{"$f":"Tubingp2($B$8,$B$9,J23,I23)","v":242.2118465948019},{"$f":"linep1($B$10,M23,O23)","v":82.104939113916686},{"$f":"linep1($B$11,N23,C23)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C23/$B$16","v":6666666.666666667},{"$f":"K23-L23","v":160.10690748088521}]
[null,2,{"$f":"$B$18","v":20000000},{"$f":"(C24+C23)*0.5*(B24-B23)*$B$3","v":7200000000},{"$f":"E23+D24","v":14400000000},{"$f":"E24/$B$2","v":5.3333333333333337E-2},{"$f":"ZfacStanding(H24,$B$4,$B$14,2)","v":0.95755599932655078},{"$f":"MBgastank_PR($H$22,$G$22,G23,F24)","v":260.03223102308738},{"$f":"C24/($B$17*$B$16)","v":1666666.6666666667},{"$f":"IPRpwf($B$6,$B$7,H24,I24)","v":256.80750476607494},{"$f":"Tubingp2($B$8,$B$9,J24,I24)","v":234.02841706112488},{"$f":"linep1($B$10,M24,O24)","v":82.104939113916686},{"$f":"linep1($B$11,N24,C24)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C24/$B$16","v":6666666.666666667},{"$f":"K24-L24","v":151.9234779472082}]
[null,3,20000000,7200000000,21600000000,0.08,{"$f":"ZfacStanding(H25,$B$4,$B$14,2)","v":0.95273450120800862},{"$f":"MBgastank_PR($H$22,$G$22,G24,F25)","v":251.36448409644805},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H25,I25)","v":248.02708964628604},{"$f":"Tubingp2($B$8,$B$9,J25,I25)","v":225.77224142681953},{"$f":"linep1($B$10,M25,O25)","v":82.104939113916686},{"$f":"linep1($B$11,N25,C25)","v":78.656087193782554},30,6666666.666666667,143.66730231290285]
[null,4,20000000,7200000000,28800000000,0.10666666666666667,{"$f":"ZfacStanding(H26,$B$4,$B$14,2)","v":0.94833808688555954},{"$f":"MBgastank_PR($H$22,$G$22,G25,F26)","v":242.84956957368502},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H26,I26)","v":239.3934977718848},{"$f":"Tubingp2($B$8,$B$9,J26,I26)","v":217.64454243314955},{"$f":"linep1($B$10,M26,O26)","v":82.104939113916686},{"$f":"linep1($B$11,N26,C26)","v":78.656087193782554},30,6666666.666666667,135.53960331923287]
[null,5,20000000,7200000000,36000000000,0.13333333333333333,{"$f":"ZfacStanding(H27,$B$4,$B$14,2)","v":0.94437722310323535},{"$f":"MBgastank_PR($H$22,$G$22,G26,F27)","v":234.51314578933824},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H27,I27)","v":230.93234697925007},{"$f":"Tubingp2($B$8,$B$9,J27,I27)","v":209.66889243674865},{"$f":"linep1($B$10,M27,O27)","v":82.104939113916686},{"$f":"linep1($B$11,N27,C27)","v":78.656087193782554},30,6666666.666666667,127.56395332283196]
[null,6,20000000,7200000000,43200000000,0.16,{"$f":"ZfacStanding(H28,$B$4,$B$14,2)","v":0.94084273068708024},{"$f":"MBgastank_PR($H$22,$G$22,G27,F28)","v":226.34801817649986},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H28,I28)","v":222.63593300669694},{"$f":"Tubingp2($B$8,$B$9,J28,I28)","v":201.83746560613037},{"$f":"linep1($B$10,M28,O28)","v":82.104939113916686},{"$f":"linep1($B$11,N28,C28)","v":78.656087193782554},30,6666666.666666667,119.73252649221368]
[null,7,20000000,7200000000,50400000000,0.18666666666666668,{"$f":"ZfacStanding(H29,$B$4,$B$14,2)","v":0.93772294819693658},{"$f":"MBgastank_PR($H$22,$G$22,G28,F29)","v":218.34211436385743},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H29,I29)","v":214.49152020117984},{"$f":"Tubingp2($B$8,$B$9,J29,I29)","v":194.13757773210358},{"$f":"linep1($B$10,M29,O29)","v":82.104939113916686},{"$f":"linep1($B$11,N29,C29)","v":78.656087193782554},30,6666666.666666667,112.03263861818689]
[null,8,20000000,7200000000,57600000000,0.21333333333333335,{"$f":"ZfacStanding(H30,$B$4,$B$14,2)","v":0.93500635818201971},{"$f":"MBgastank_PR($H$22,$G$22,G29,F30)","v":210.48308417875552},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H30,I30)","v":206.48598513878471},{"$f":"Tubingp2($B$8,$B$9,J30,I30)","v":186.55602730435663},{"$f":"linep1($B$10,M30,O30)","v":82.104939113916686},{"$f":"linep1($B$11,N30,C30)","v":78.656087193782554},30,6666666.666666667,104.45108819043995]
[null,9,20000000,7200000000,64800000000,0.24,{"$f":"ZfacStanding(H31,$B$4,$B$14,2)","v":0.93268193553218104},{"$f":"MBgastank_PR($H$22,$G$22,G30,F31)","v":202.75896359498739},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H31,I31)","v":198.6064718266924},{"$f":"Tubingp2($B$8,$B$9,J31,I31)","v":179.07968288138127},{"$f":"linep1($B$10,M31,O31)","v":82.104939113916686},{"$f":"linep1($B$11,N31,C31)","v":78.656087193782554},30,6666666.666666667,96.974743767464588]
[null,10,20000000,7200000000,72000000000,0.26666666666666666,{"$f":"ZfacStanding(H32,$B$4,$B$14,2)","v":0.93073917732170108},{"$f":"MBgastank_PR($H$22,$G$22,G31,F32)","v":195.15824214527183},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H32,I32)","v":190.84043809047884},{"$f":"Tubingp2($B$8,$B$9,J32,I32)","v":171.69548981352534},{"$f":"linep1($B$10,M32,O32)","v":82.104939113916686},{"$f":"linep1($B$11,N32,C32)","v":78.656087193782554},30,6666666.666666667,89.590550699608656]
[null,11,20000000,7200000000,79200000000,0.29333333333333333,{"$f":"ZfacStanding(H33,$B$4,$B$14,2)","v":0.92916809366019693},{"$f":"MBgastank_PR($H$22,$G$22,G32,F33)","v":187.66985020801448},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H33,I33)","v":183.17561521783387},{"$f":"Tubingp2($B$8,$B$9,J33,I33)","v":164.3903848294222},{"$f":"linep1($B$10,M33,O33)","v":82.104939113916686},{"$f":"linep1($B$11,N33,C33)","v":78.656087193782554},30,6666666.666666667,82.285445715505517]
[null,12,20000000,7200000000,86400000000,0.32,{"$f":"ZfacStanding(H34,$B$4,$B$14,2)","v":0.92795919480632505},{"$f":"MBgastank_PR($H$22,$G$22,G33,F34)","v":180.28313736595399},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H34,I34)","v":175.59995145741004},{"$f":"Tubingp2($B$8,$B$9,J34,I34)","v":157.15118138007011},{"$f":"linep1($B$10,M34,O34)","v":82.104939113916686},{"$f":"linep1($B$11,N34,C34)","v":78.656087193782554},30,6666666.666666667,75.046242266153428]
[null,13,20000000,7200000000,93600000000,0.34666666666666668,{"$f":"ZfacStanding(H35,$B$4,$B$14,2)","v":0.9271034784622797},{"$f":"MBgastank_PR($H$22,$G$22,G34,F35)","v":172.98785048581277},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H35,I35)","v":168.10154594481054},{"$f":"Tubingp2($B$8,$B$9,J35,I35)","v":149.96442680400733},{"$f":"linep1($B$10,M35,O35)","v":82.104939113916686},{"$f":"linep1($B$11,N35,C35)","v":78.656087193782554},30,6666666.666666667,67.859487690090646]
[null,14,20000000,7200000000,100800000000,0.37333333333333335,{"$f":"ZfacStanding(H36,$B$4,$B$14,2)","v":0.92659241766375156},{"$f":"MBgastank_PR($H$22,$G$22,G35,F36)","v":165.77411241857789},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H36,I36)","v":160.66857092007953},{"$f":"Tubingp2($B$8,$B$9,J36,I36)","v":142.81622184819551},{"$f":"linep1($B$10,M36,O36)","v":82.104939113916686},{"$f":"linep1($B$11,N36,C36)","v":78.656087193782554},30,6666666.666666667,60.711282734278825]
[null,15,20000000,7200000000,108000000000,0.4,{"$f":"ZfacStanding(H37,$B$4,$B$14,2)","v":0.92641794934612942},{"$f":"MBgastank_PR($H$22,$G$22,G36,F37)","v":158.63240138177187},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H37,I37)","v":153.28917803119992},{"$f":"Tubingp2($B$8,$B$9,J37,I37)","v":135.69198754533463},{"$f":"linep1($B$10,M37,O37)","v":82.104939113916686},{"$f":"linep1($B$11,N37,C37)","v":78.656087193782554},30,6666666.666666667,53.587048431417941]
[null,16,20000000,7200000000,115200000000,0.42666666666666669,{"$f":"ZfacStanding(H38,$B$4,$B$14,2)","v":0.92657246364480295},{"$f":"MBgastank_PR($H$22,$G$22,G37,F38)","v":151.55353100521415},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H38,I38)","v":145.95138263641678},{"$f":"Tubingp2($B$8,$B$9,J38,I38)","v":128.5761569986837},{"$f":"linep1($B$10,M38,O38)","v":82.104939113916686},{"$f":"linep1($B$11,N38,C38)","v":78.656087193782554},30,6666666.666666667,46.471217884767015]
[null,17,20000000,7200000000,122400000000,0.45333333333333331,{"$f":"ZfacStanding(H39,$B$4,$B$14,2)","v":0.92704879399154816},{"$f":"MBgastank_PR($H$22,$G$22,G38,F39)","v":144.52863101327887},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H39,I39)","v":138.64291729441445},{"$f":"Tubingp2($B$8,$B$9,J39,I39)","v":121.4517578083738},{"$f":"linep1($B$10,M39,O39)","v":82.104939113916686},{"$f":"linep1($B$11,N39,C39)","v":78.656087193782554},30,6666666.666666667,39.346818694457113]
[null,18,20000000,7200000000,129600000000,0.48,{"$f":"ZfacStanding(H40,$B$4,$B$14,2)","v":0.9278402080770578},{"$f":"MBgastank_PR($H$22,$G$22,G39,F40)","v":137.54912851374621},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H40,I40)","v":131.35104144324248},{"$f":"Tubingp2($B$8,$B$9,J40,I40)","v":114.29983136828336},{"$f":"linep1($B$10,M40,O40)","v":82.104939113916686},{"$f":"linep1($B$11,N40,C40)","v":78.656087193782554},30,6666666.666666667,32.194892254366678]
[null,19,20000000,7200000000,136800000000,0.50666666666666671,{"$f":"ZfacStanding(H41,$B$4,$B$14,2)","v":0.92894039976065723},{"$f":"MBgastank_PR($H$22,$G$22,G40,F41)","v":130.6067298607089},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H41,I41)","v":124.06228765519973},{"$f":"Tubingp2($B$8,$B$9,J41,I41)","v":107.09860190067918},{"$f":"linep1($B$10,M41,O41)","v":82.104939113916686},{"$f":"linep1($B$11,N41,C41)","v":78.656087193782554},30,6666666.666666667,24.993662786762499]
[null,20,20000000,7200000000,144000000000,0.53333333333333333,{"$f":"ZfacStanding(H42,$B$4,$B$14,2)","v":0.93034348202310868},{"$f":"MBgastank_PR($H$22,$G$22,G41,F42)","v":123.69340305619069},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H42,I42)","v":116.76211411650004},{"$f":"Tubingp2($B$8,$B$9,J42,I42)","v":99.822248652986772},{"$f":"linep1($B$10,M42,O42)","v":82.104939113916686},{"$f":"linep1($B$11,N42,C42)","v":78.656087193782554},30,6666666.666666667,17.717309539070087]
[null,21,20000000,7200000000,151200000000,0.56000000000000005,{"$f":"ZfacStanding(H43,$B$4,$B$14,2)","v":0.9320439810784088},{"$f":"MBgastank_PR($H$22,$G$22,G42,F43)","v":116.80136065206969},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H43,I43)","v":109.43441498682299},{"$f":"Tubingp2($B$8,$B$9,J43,I43)","v":92.439023554600993},{"$f":"linep1($B$10,M43,O43)","v":82.104939113916686},{"$f":"linep1($B$11,N43,C43)","v":78.656087193782554},30,6666666.666666667,10.334084440684308]
[null,22,20000000,7200000000,158400000000,0.58666666666666667,{"$f":"ZfacStanding(H44,$B$4,$B$14,2)","v":0.93403683178756125},{"$f":"MBgastank_PR($H$22,$G$22,G43,F44)","v":109.92304311041758},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H44,I44)","v":102.06080903063651},{"$f":"Tubingp2($B$8,$B$9,J44,I44)","v":84.908236597389077},{"$f":"linep1($B$10,M44,O44)","v":82.104939113916686},{"$f":"linep1($B$11,N44,C44)","v":78.656087193782554},30,6666666.666666667,2.8032974834723916]
[null,22.387034833626799,20000000,2786650802.112956,161186650802.11295,0.59698759556338132,{"$f":"ZfacStanding(H45,$B$4,$B$14,2)","v":0.93483840637315641},{"$f":"MBgastank_PR($H$22,$G$22,G44,F45)","v":107.4074292132395},1666666.6666666667,{"$f":"IPRpwf($B$6,$B$7,H45,I45)","v":99.346309360390364},{"$f":"Tubingp2($B$8,$B$9,J45,I45)","v":82.104748438203913},{"$f":"linep1($B$10,M45,O45)","v":82.104939113916686},{"$f":"linep1($B$11,N45,C45)","v":78.656087193782554},30,6666666.666666667,-1.9067571277275874E-4]
[null,24]
[null,25]
[null,26]

{"sheet":"Task.2.3","index":3,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[[18,16,18,18]]}
["Snohvit Gas Field, Prof. Michael Golan, Prof. Milan Stanko",null,null,null,null,"SOLVING EXPLANATION"]
[" G (IGIP), Initial gas in place",{"$f":"270000000000","v":270000000000},"[Sm3]",null,null,null,"Repeat the procedure given in task 1.1. until plateau ends."]
["Production days per year (uptime)",360,"[day]",null,null,null,"For the years where Dpchoke is negative, "]
["TR , reservoir temperature",92,"[°C]",null,null,null,null,"calculate psuc by computing pressure at the plem with flowline equation, pwh and template rate"]
["pRi, initial reservoir pressure",276,"[bara]",null,null,null,null,"Calculate mass flow by multiplying gas field rate by standard condition density (and change units)"]
["CR, inflow backpressure coefficient",1000,"[Sm3/bar^2n]",null,null,null,null,"Calculate compressor power by using the VBA equation \"compressor_c\""]
["n, inflow backpressure exponent",1,"[-]",null,null,null,null,"If compressor power is greater than 22 MW, use the goalseek to reduce field rate until compressor power is equal to 22."]
["Ct, Tubing flow coefficient (2100 MDx0.15 ID  m)",40288.195917865203,"[Sm3/bar]"]
["S, Tubing elevation coefficient",0.155,"[-]"]
["CFL , flowline coefficient from template-PLEM (5000x0.355  ID m)",283126.86618411407,"[Sm3/bar]"]
["CPL Pipeline coefficient from PLEM-Shore (158600x0.68  ID m)",275064.39272584103,"[Sm3/bar]"]
["Separator  (slug catcher) pressure",30,"[bara]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suction T (Tplem)","[C]",67]
["Gas molecular weight (Methane)",16,"[kg/kmole]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adiabatic exponent, k","[-]",{"$f":"k(B14)","v":1.2990516764604219}]
["Gas specific gravity",{"$f":"$B$13/28.93","v":0.55305910819218806},"[-]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compressor data"]
["Gas density at Sc",{"$f":"101325/((8314/(0.55*28.97))*(273.15+15.56))","v":0.67259858638728143},"[kg/m^3]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polytropic efficiency, hp","[-]",0.7]
["Number of templates",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum compressor power","[MW]",22]
["Number of wells per template",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum suction pressure","[bara]",15]
["qfield",20000000,"[Sm^3/d]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPRESSOR"]
[null,"time","qfield","DGp","Gp","Rf","Z","pR","qwell","pwf","pwh","ptemp ","pplem","psep","qtemp","Dpchoke","psuc","m","Compressor power"]
[null,"[years]","[Sm^3/d]","[Sm^3]","[Sm^3]","[-]","[-]","[bara]","[Sm^3/d]","[bara]","[bara]","[bara]","[bara]","[bara]","[Sm^3/d]","[bar]","[bara]","[kg/s]","[MW]"]
[null,0,{"$f":"$B$18","v":20000000},0,0,{"$f":"E22/$B$2","v":0},{"$f":"ZfacStanding(H22,$B$4,$B$14,2)","v":0.96729106430049372},{"$f":"B5","v":276},{"$f":"C22/($B$17*$B$16)","v":2222222.222222222},{"$f":"IPRpwf($B$6,$B$7,H22,I22)","v":271.94443876971962},{"$f":"Tubingp2($B$8,$B$9,J22,I22)","v":245.54575249764781},{"$f":"linep1($B$10,M22,O22)","v":82.104939113916686},{"$f":"linep1($B$11,N22,C22)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C22/$B$16","v":6666666.666666667},{"$f":"K22-L22","v":163.44081338373113}]
[null,1,{"$f":"$B$18","v":20000000},{"$f":"(C23+C22)*0.5*(B23-B22)*$B$3","v":7200000000},{"$f":"E22+D23","v":7200000000},{"$f":"E23/$B$2","v":2.6666666666666668E-2},{"$f":"ZfacStanding(H23,$B$4,$B$14,2)","v":0.96267166832039974},{"$f":"MBgastank_PR($H$22,$G$22,G22,F23)","v":268.64},{"$f":"C23/($B$17*$B$16)","v":2222222.222222222},{"$f":"IPRpwf($B$6,$B$7,H23,I23)","v":264.47160032369783},{"$f":"Tubingp2($B$8,$B$9,J23,I23)","v":238.45279022768443},{"$f":"linep1($B$10,M23,O23)","v":82.104939113916686},{"$f":"linep1($B$11,N23,C23)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C23/$B$16","v":6666666.666666667},{"$f":"K23-L23","v":156.34785111376775}]
[null,2,{"$f":"$B$18","v":20000000},{"$f":"(C24+C23)*0.5*(B24-B23)*$B$3","v":7200000000},{"$f":"E23+D24","v":14400000000},{"$f":"E24/$B$2","v":5.3333333333333337E-2},{"$f":"ZfacStanding(H24,$B$4,$B$14,2)","v":0.95755599932655078},{"$f":"MBgastank_PR($H$22,$G$22,G23,F24)","v":260.03223102308738},{"$f":"C24/($B$17*$B$16)","v":2222222.222222222},{"$f":"IPRpwf($B$6,$B$7,H24,I24)","v":255.72355962762225},{"$f":"Tubingp2($B$8,$B$9,J24,I24)","v":230.13573066484068},{"$f":"linep1($B$10,M24,O24)","v":82.104939113916686},{"$f":"linep1($B$11,N24,C24)","v":78.656087193782554},{"$f":"$B$12","v":30},{"$f":"C24/$B$16","v":6666666.666666667},{"$f":"K24-L24","v":148.03079155092399}]
[null,3,20000000,7200000000,21600000000,0.08,{"$f":"ZfacStanding(H25,$B$4,$B$14,2)","v":0.95273450120800862},{"$f":"MBgastank_PR($H$22,$G$22,G24,F25)","v":251.36448409644805},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H25,I25)","v":246.90460028693525},{"$f":"Tubingp2($B$8,$B$9,J25,I25)","v":221.73466020312284},{"$f":"linep1($B$10,M25,O25)","v":82.104939113916686},{"$f":"linep1($B$11,N25,C25)","v":78.656087193782554},30,6666666.666666667,139.62972108920616]
[null,4,20000000,7200000000,28800000000,0.10666666666666667,{"$f":"ZfacStanding(H26,$B$4,$B$14,2)","v":0.94833808688555954},{"$f":"MBgastank_PR($H$22,$G$22,G25,F26)","v":242.84956957368502},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H26,I26)","v":238.23033228348959},{"$f":"Tubingp2($B$8,$B$9,J26,I26)","v":213.45327682525581},{"$f":"linep1($B$10,M26,O26)","v":82.104939113916686},{"$f":"linep1($B$11,N26,C26)","v":78.656087193782554},30,6666666.666666667,131.34833771133913]
[null,5,20000000,7200000000,36000000000,0.13333333333333333,{"$f":"ZfacStanding(H27,$B$4,$B$14,2)","v":0.94437722310323535},{"$f":"MBgastank_PR($H$22,$G$22,G26,F27)","v":234.51314578933824},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H27,I27)","v":229.72634443134552},{"$f":"Tubingp2($B$8,$B$9,J27,I27)","v":205.31487766880684},{"$f":"linep1($B$10,M27,O27)","v":82.104939113916686},{"$f":"linep1($B$11,N27,C27)","v":78.656087193782554},30,6666666.666666667,123.20993855489016]
[null,6,20000000,7200000000,43200000000,0.16,{"$f":"ZfacStanding(H28,$B$4,$B$14,2)","v":0.94084273068708024},{"$f":"MBgastank_PR($H$22,$G$22,G27,F28)","v":226.34801817649986},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H28,I28)","v":221.38474001205887},{"$f":"Tubingp2($B$8,$B$9,J28,I28)","v":197.31071197177846},{"$f":"linep1($B$10,M28,O28)","v":82.104939113916686},{"$f":"linep1($B$11,N28,C28)","v":78.656087193782554},30,6666666.666666667,115.20577285786177]
[null,7,20000000,7200000000,50400000000,0.18666666666666668,{"$f":"ZfacStanding(H29,$B$4,$B$14,2)","v":0.93772294819693658},{"$f":"MBgastank_PR($H$22,$G$22,G28,F29)","v":218.34211436385743},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H29,I29)","v":213.19253430328553},{"$f":"Tubingp2($B$8,$B$9,J29,I29)","v":189.42690839527737},{"$f":"linep1($B$10,M29,O29)","v":82.104939113916686},{"$f":"linep1($B$11,N29,C29)","v":78.656087193782554},30,6666666.666666667,107.32196928136068]
[null,8,20000000,7200000000,57600000000,0.21333333333333335,{"$f":"ZfacStanding(H30,$B$4,$B$14,2)","v":0.93500635818201971},{"$f":"MBgastank_PR($H$22,$G$22,G29,F30)","v":210.48308417875552},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H30,I30)","v":205.13631200540499},{"$f":"Tubingp2($B$8,$B$9,J30,I30)","v":181.64885317581312},{"$f":"linep1($B$10,M30,O30)","v":82.104939113916686},{"$f":"linep1($B$11,N30,C30)","v":78.656087193782554},30,6666666.666666667,99.54391406189643]
[null,9,20000000,7200000000,64800000000,0.24,{"$f":"ZfacStanding(H31,$B$4,$B$14,2)","v":0.93268193553218104},{"$f":"MBgastank_PR($H$22,$G$22,G30,F31)","v":202.75896359498739},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H31,I31)","v":197.20287801117712},{"$f":"Tubingp2($B$8,$B$9,J31,I31)","v":173.96174107372096},{"$f":"linep1($B$10,M31,O31)","v":82.104939113916686},{"$f":"linep1($B$11,N31,C31)","v":78.656087193782554},30,6666666.666666667,91.856801959804272]
[null,10,20000000,7200000000,72000000000,0.26666666666666666,{"$f":"ZfacStanding(H32,$B$4,$B$14,2)","v":0.93073917732170108},{"$f":"MBgastank_PR($H$22,$G$22,G31,F32)","v":195.15824214527183},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H32,I32)","v":189.3792946840027},{"$f":"Tubingp2($B$8,$B$9,J32,I32)","v":166.35052076507193},{"$f":"linep1($B$10,M32,O32)","v":82.104939113916686},{"$f":"linep1($B$11,N32,C32)","v":78.656087193782554},30,6666666.666666667,84.245581651155248]
[null,11,20000000,7200000000,79200000000,0.29333333333333333,{"$f":"ZfacStanding(H33,$B$4,$B$14,2)","v":0.92916809366019693},{"$f":"MBgastank_PR($H$22,$G$22,G32,F33)","v":187.66985020801448},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H33,I33)","v":181.6528294711546},{"$f":"Tubingp2($B$8,$B$9,J33,I33)","v":158.79972657681051},{"$f":"linep1($B$10,M33,O33)","v":82.104939113916686},{"$f":"linep1($B$11,N33,C33)","v":78.656087193782554},30,6666666.666666667,76.694787462893828]
[null,12,20000000,7200000000,86400000000,0.32,{"$f":"ZfacStanding(H34,$B$4,$B$14,2)","v":0.92795919480632505},{"$f":"MBgastank_PR($H$22,$G$22,G33,F34)","v":180.28313736595399},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H34,I34)","v":174.01088298232733},{"$f":"Tubingp2($B$8,$B$9,J34,I34)","v":151.29325280942291},{"$f":"linep1($B$10,M34,O34)","v":82.104939113916686},{"$f":"linep1($B$11,N34,C34)","v":78.656087193782554},30,6666666.666666667,69.188313695506224]
[null,13,20000000,7200000000,93600000000,0.34666666666666668,{"$f":"ZfacStanding(H35,$B$4,$B$14,2)","v":0.9271034784622797},{"$f":"MBgastank_PR($H$22,$G$22,G34,F35)","v":172.98785048581277},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H35,I35)","v":166.44090300608107},{"$f":"Tubingp2($B$8,$B$9,J35,I35)","v":143.81405996340803},{"$f":"linep1($B$10,M35,O35)","v":82.104939113916686},{"$f":"linep1($B$11,N35,C35)","v":78.656087193782554},30,6666666.666666667,61.709120849491342]
[null,14,20000000,7200000000,100800000000,0.37333333333333335,{"$f":"ZfacStanding(H36,$B$4,$B$14,2)","v":0.92659241766375156},{"$f":"MBgastank_PR($H$22,$G$22,G35,F36)","v":165.77411241857789},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H36,I36)","v":158.93028070806733},{"$f":"Tubingp2($B$8,$B$9,J36,I36)","v":136.34378518838784},{"$f":"linep1($B$10,M36,O36)","v":82.104939113916686},{"$f":"linep1($B$11,N36,C36)","v":78.656087193782554},30,6666666.666666667,54.238846074471155]
[null,15,20000000,7200000000,108000000000,0.4,{"$f":"ZfacStanding(H37,$B$4,$B$14,2)","v":0.92641794934612942},{"$f":"MBgastank_PR($H$22,$G$22,G36,F37)","v":158.63240138177187},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H37,I37)","v":151.46622245875599},{"$f":"Tubingp2($B$8,$B$9,J37,I37)","v":128.86221331525974},{"$f":"linep1($B$10,M37,O37)","v":82.104939113916686},{"$f":"linep1($B$11,N37,C37)","v":78.656087193782554},30,6666666.666666667,46.757274201343051]
[null,16,20000000,7200000000,115200000000,0.42666666666666669,{"$f":"ZfacStanding(H38,$B$4,$B$14,2)","v":0.92657246364480295},{"$f":"MBgastank_PR($H$22,$G$22,G37,F38)","v":151.55353100521415},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H38,I38)","v":144.03558774804992},{"$f":"Tubingp2($B$8,$B$9,J38,I38)","v":121.3465396501046},{"$f":"linep1($B$10,M38,O38)","v":82.104939113916686},{"$f":"linep1($B$11,N38,C38)","v":78.656087193782554},30,6666666.666666667,39.241600536187917]
[null,17,20000000,7200000000,122400000000,0.45333333333333331,{"$f":"ZfacStanding(H39,$B$4,$B$14,2)","v":0.92704879399154816},{"$f":"MBgastank_PR($H$22,$G$22,G38,F39)","v":144.52863101327887},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H39,I39)","v":136.6246791774835},{"$f":"Tubingp2($B$8,$B$9,J39,I39)","v":113.77031252153672},{"$f":"linep1($B$10,M39,O39)","v":82.104939113916686},{"$f":"linep1($B$11,N39,C39)","v":78.656087193782554},30,6666666.666666667,31.665373407620038]
[null,18,20000000,7200000000,129600000000,0.48,{"$f":"ZfacStanding(H40,$B$4,$B$14,2)","v":0.9278402080770578},{"$f":"MBgastank_PR($H$22,$G$22,G39,F40)","v":137.54912851374621},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H40,I40)","v":129.21896351801018},{"$f":"Tubingp2($B$8,$B$9,J40,I40)","v":106.10186608784156},{"$f":"linep1($B$10,M40,O40)","v":82.104939113916686},{"$f":"linep1($B$11,N40,C40)","v":78.656087193782554},30,6666666.666666667,23.996926973924872]
[null,19,20000000,7200000000,136800000000,0.50666666666666671,{"$f":"ZfacStanding(H41,$B$4,$B$14,2)","v":0.92894039976065723},{"$f":"MBgastank_PR($H$22,$G$22,G40,F41)","v":130.6067298607089},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H41,I41)","v":121.80269152480156},{"$f":"Tubingp2($B$8,$B$9,J41,I41)","v":98.301907741327241},{"$f":"linep1($B$10,M41,O41)","v":82.104939113916686},{"$f":"linep1($B$11,N41,C41)","v":78.656087193782554},30,6666666.666666667,16.196968627410556]
[null,20,20000000,7200000000,144000000000,0.53333333333333333,{"$f":"ZfacStanding(H42,$B$4,$B$14,2)","v":0.93034348202310868},{"$f":"MBgastank_PR($H$22,$G$22,G41,F42)","v":123.69340305619069},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H42,I42)","v":114.35836540191987},{"$f":"Tubingp2($B$8,$B$9,J42,I42)","v":90.319631656926987},{"$f":"linep1($B$10,M42,O42)","v":82.104939113916686},{"$f":"linep1($B$11,N42,C42)","v":78.656087193782554},30,6666666.666666667,8.2146925430103011]
[null,21,20000000,7200000000,151200000000,0.56000000000000005,{"$f":"ZfacStanding(H43,$B$4,$B$14,2)","v":0.9320439810784088},{"$f":"MBgastank_PR($H$22,$G$22,G42,F43)","v":116.80136065206969},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H43,I43)","v":106.86597039260268},{"$f":"Tubingp2($B$8,$B$9,J43,I43)","v":82.086098775811763},{"$f":"linep1($B$10,M43,O43)","v":82.104939113916686},{"$f":"linep1($B$11,N43,C43)","v":78.656087193782554},30,6666666.666666667,-1.8840338104922694E-2]
[null,22,20000000,7200000000,158400000000,0.58666666666666667,{"$f":"ZfacStanding(H44,$B$4,$B$14,2)","v":0.93403683178756125},{"$f":"MBgastank_PR($H$22,$G$22,G43,F44)","v":109.92304311041758},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H44,I44)","v":99.30182870638636},{"$f":"Tubingp2($B$8,$B$9,J44,I44)","v":73.502130435671404},{"$f":"linep1($B$10,M44,O44)","v":82.104939113916686},{"$f":"linep1($B$11,N44,C44)","v":78.656087193782554},30,6666666.666666667,null,{"$f":"linep2($B$10,K44,O44)","v":69.628458293419158},{"$f":"C44*$B$15/(3600*24)","v":155.6941172192781},{"$f":"Power_c(R44,$T$15,$T$12,Q44,M44,$B$14)/1000000","v":4.5762467233109918}]
[null,23,20000000,7200000000,165600000000,0.61333333333333329,{"$f":"ZfacStanding(H45,$B$4,$B$14,2)","v":0.93631737455415254},{"$f":"MBgastank_PR($H$22,$G$22,G44,F45)","v":103.05110257629995},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H45,I45)","v":91.636824039077609},{"$f":"Tubingp2($B$8,$B$9,J45,I45)","v":64.413977199016841},{"$f":"linep1($B$10,M45,O45)","v":82.104939113916686},{"$f":"linep1($B$11,N45,C45)","v":78.656087193782554},30,6666666.666666667,null,{"$f":"linep2($B$10,K45,O45)","v":59.955979554431607},{"$f":"C45*$B$15/(3600*24)","v":155.6941172192781},{"$f":"Power_c(R45,$T$15,$T$12,Q45,M45,$B$14)/1000000","v":10.561429486187816}]
[null,24,20000000,7200000000,172800000000,0.64,{"$f":"ZfacStanding(H46,$B$4,$B$14,2)","v":0.9388813539322286},{"$f":"MBgastank_PR($H$22,$G$22,G45,F46)","v":96.178387012163682},2222222.222222222,{"$f":"IPRpwf($B$6,$B$7,H46,I46)","v":83.833524952964453},{"$f":"Tubingp2($B$8,$B$9,J46,I46)","v":54.557456138395644},{"$f":"linep1($B$10,M46,O46)","v":82.104939113916686},{"$f":"linep1($B$11,N46,C46)","v":78.656087193782554},30,6666666.666666667,null,{"$f":"linep2($B$10,K46,O46)","v":49.214581640291563},{"$f":"C46*$B$15/(3600*24)","v":155.6941172192781},{"$f":"Power_c(R46,$T$15,$T$12,Q46,M46,$B$14)/1000000","v":19.087779790785625}]
[null,25,18918347.899635326,7005302621.9343596,179805302621.93436,0.66594556526642357,{"$f":"ZfacStanding(H47,$B$4,$B$14,2)","v":0.94164137150234539},{"$f":"MBgastank_PR($H$22,$G$22,G46,F47)","v":89.491103212293012},2102038.6555150361,{"$f":"IPRpwf($B$6,$B$7,H47,I47)","v":76.854530761941717},{"$f":"Tubingp2($B$8,$B$9,J47,I47)","v":48.33510298381897},{"$f":"linep1($B$10,M47,O47)","v":78.271893292284247},{"$f":"linep1($B$11,N47,C47)","v":75.035976902463389},30,6306115.9665451087,null,{"$f":"linep2($B$10,K47,O47)","v":42.897444336518156},{"$f":"C47*$B$15/(3600*24)","v":147.27377377404531},{"$f":"Power_c(R47,$T$15,$T$12,Q47,M47,$B$14)/1000000","v":22.00002184878878}]
[null,26,17527371.586395077,6560229507.4854717,186365532129.41983,0.69024271159044381,{"$f":"ZfacStanding(H48,$B$4,$B$14,2)","v":0.94445826689214429},{"$f":"MBgastank_PR($H$22,$G$22,G47,F48)","v":83.225990261870123},1947485.7318216753,{"$f":"IPRpwf($B$6,$B$7,H48,I48)","v":70.562594363070474},{"$f":"Tubingp2($B$8,$B$9,J48,I48)","v":43.903455577147582},{"$f":"linep1($B$10,M48,O48)","v":73.390636966891648},{"$f":"linep1($B$11,N48,C48)","v":70.429843044139261},30,5842457.1954650255,null,{"$f":"linep2($B$10,K48,O48)","v":38.751652976751586},{"$f":"C48*$B$15/(3600*24)","v":136.445432315902},{"$f":"Power_c(R48,$T$15,$T$12,Q48,M48,$B$14)/1000000","v":22.000023886987094}]