{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Readme","Remap-comps","CVD Data","CCE & other data","Material balance","Recovery factors","OGR chart ","K-value chart","Density chart","MBO props","Rec factors calc","CVD analysis"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":59,"comments":4,"pivot_tables":0},"unopened":[{"sheet":"Recovery factors","index":5,"reason":"not_a_worksheet"},{"sheet":"OGR chart ","index":6,"reason":"not_a_worksheet"},{"sheet":"K-value chart","index":7,"reason":"not_a_worksheet"},{"sheet":"Density chart","index":8,"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":"Readme","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Gas Condensate PVT Analysis Workbook"]
["Written by Robert Mott, August 2003"]
[]
["This worksheet analyses results from CVD and CCE tests on a gas condensate fluid"]
[]
["Data should only be entered on yellow cells"]
[]
["First enter CVD data (below the dew point) on the sheet 'CVD Data'"]
["Then enter CCE relative volumes (above the dew point) on the sheet 'CCE Data'"]
[]
["Recovery factors for individual components and for stock tank oil and  gas are shown on the sheet 'Recovery factors'"]
[]
["The sheet 'CVD analysis' contains material balance calculations which can be used as a consistency check of CVD data"]
["These checks are described in 'Phase Behavior', SPE Monograph 20, by Whitson and Brule"]
[]
["The material balance checks calculate liquid phase densities and compositions.  "]
[]
["Densities and K-values from the material balance calculation are displayed as charts."]
[]
["Non-monotonic behaviour for the K-value or liquid density curves will cast some doubt on the validity of the CVD measurements"]
[]
["If the liquid composition is measured at the end of the CVD, two other material balance checks can be used. "]
["A 'Forward Material Balance' calculates the final liquid composition from the original composition, liquid saturations, Z-factors, amounts of gas removed, and the gas compositions at each step."]
["A 'Backward Material Balance' calculates the original composition from the final liquid composition, final liquid saturation, final gas Z-factor, the amounts of gas removed, and the gas compositions at each step. This is a better check for lean condensates."]
["The Material Balance checks are shown on the sheet 'Material Balance'."]

{"sheet":"Remap-comps","index":1,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["JK1"]
[]
["Nitrogen",0,null,"N2",{"$f":"B3","v":0}]
["Carbon Dioxide",0,null,"CO2",{"$f":"B4","v":0}]
["Methane",2E-3,null,"H2S",0]
["Ethane",8.0000000000000002E-3,null,"C1",{"$f":"B5","v":2E-3}]
["Propane",0.154,null,"C2",{"$f":"B6","v":8.0000000000000002E-3}]
["Isobutane",0.188,null,"C3",{"$f":"B7","v":0.154}]
["n-Butane",0.60799999999999998,null,"iC4",{"$f":"B8","v":0.188}]
["2,2 Dimethylpropane",4.0000000000000001E-3,null,"nC4",{"$f":"B9","v":0.60799999999999998}]
["Isopentane",0.83499999999999996,null,"iC5",{"$f":"SUM(B10:B11)","v":0.83899999999999997}]
["n-Pentane",1.099,null,"nC5",{"$f":"B12","v":1.099}]
["2,2 Dimethylbutane",5.5E-2,null,"C6",{"$f":"SUM(B13:B18)","v":3.234}]
["Cyclopentane",0,null,{"$f":"PlusFrac","v":"C7+"},{"$f":"B19","v":93.867000000000004}]
["2,3 Dimethylbutane",0.35599999999999998]
["2 Methylpentane",0.84]
["3 Methylpentane",0.56000000000000005]
["n-Hexane",1.423]
["Heptanes Plus",93.867000000000004]

{"sheet":"CVD Data","index":2,"n_rows":52,"n_cols":25,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"CVD Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No of pressures in CVD",null,null,"Plus fraction"]
[null,"The first pressure must be the dew point pressure",null,null,null,null,null,null,"Fill-In-Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"The number of pressure entries must be set to display the charts correctly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N_pres",7,null,"N_plus",{"$f":"Y2+5","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PlusFrac",{"$f":"CONCATENATE(\"C\",TEXT(N_plus,\"0\"),\"+\")","v":"C7+"}]
[null,"Number of pressure entries"]
[]
[null,"Plus fraction"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,"C6+"]
[null,"Pressure (psig)",5535,4500,3500,2500,1700,900,2,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,"C7+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equilibrium",null,null,null,null,null,null,null,3,null,null,"C8+"]
[null,"Wellstream produced (cum %)",0,7.976,21.98,39.965000000000003,56.259,73.950999999999993,93.844999999999999,null,null,null,null,"Liquid",null,null,null,null,null,null,null,4,null,null,"C9+"]
[null,"Liquid volume (%)",0,17,22.841999999999999,23.832000000000001,22.309000000000001,19.062999999999999,14.967000000000001,null,null,null,null,"(last stage)",null,null,null,null,null,null,null,5,null,null,"C10+"]
[null,"Equilibrium gas Z-factor",1.0823,0.92020000000000002,0.85150000000000003,0.83689999999999998,0.85680000000000001,0.90690000000000004,1,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,"C11+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW","Density",null,null,null,7,null,null,"C12+"]
[null,"Equilibrium gas composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mwref","(lb/ft3)",null,null,null,8]
[null,"N2",0.39300000000000002,0.40500000000000003,0.433,0.442,0.437,0.42799999999999999,0.33500000000000002,null,null,null,null,0,"N2",null,28.013000000000002,null,null,null,null,9]
[null,"CO2",1.776,1.829,1.863,1.899,1.9359999999999999,1.9450000000000001,1.6120000000000001,null,null,null,null,0,"CO2",null,44.01,null,null,null,null,10]
[null,"H2S",0,0,0,0,0,0,0,null,null,null,null,0,"H2S",null,34.076000000000001]
[null,"C1",68.25,71.912999999999997,74.338999999999999,75.537999999999997,76.049000000000007,74.722999999999999,60.118000000000002,null,null,null,null,2E-3,"C1",null,16.04]
[null,"C2",7.024,7.1779999999999999,7.2439999999999998,7.4640000000000004,7.6210000000000004,7.6909999999999998,7.1779999999999999,null,null,null,null,8.0000000000000002E-3,"C2",null,30.07]
[null,"C3",6.625,6.5010000000000003,6.5010000000000003,6.5010000000000003,6.5010000000000003,7.1120000000000001,8.0909999999999993,null,null,null,null,0.154,"C3",null,44.09]
[null,"iC4",1.4179999999999999,1.3520000000000001,1.3120000000000001,1.3,1.3240000000000001,1.462,1.9910000000000001,null,null,null,null,0.188,"iC4",null,58.12,35.01]
[null,"nC4",2.319,2.1779999999999999,2.113,2.113,2.113,2.36,3.2429999999999999,null,null,null,null,0.60799999999999998,"nC4",null,58.12,36.450000000000003]
[null,"iC5",0.85699999999999998,0.8,0.76600000000000001,0.72399999999999998,0.69,0.81499999999999995,1.2130000000000001,null,null,null,null,0.83899999999999997,"iC5",null,72.150000000000006,39.130000000000003]
[null,"nC5",0.84199999999999997,0.78700000000000003,0.75700000000000001,0.71599999999999997,0.68100000000000005,0.76200000000000001,1.151,null,null,null,null,1.099,"nC5",null,72.150000000000006,39.299999999999997]
[null,"C6",0.96799999999999997,0.85699999999999998,0.77100000000000002,0.70099999999999996,0.64700000000000002,0.70099999999999996,1.268,null,null,null,null,3.234,"C6",null,86.17,41.19]
[null,"C7",null,null,null,null,null,null,null,null,null,null,null,null,"C7",null,100.2,42.583343738294417]
[null,"C8",null,null,null,null,null,null,null,null,null,null,null,null,"C8",null,114.2,44.194031714321383]
[null,"C9",null,null,null,null,null,null,null,null,null,null,null,null,"C9",null,128.30000000000001,45.348982394805837]
[null,"C10",null,null,null,null,null,null,null,null,null,null,null,null,"C10",null,142.30000000000001,45.679860157323013]
[null,"C11",null,null,null,null,null,null,null,null,null,null,null,null,"C11",null,156.30000000000001,46]
[null,{"$f":"PlusFrac","v":"C7+"},9.5289999999999999,6.2,3.9,2.6,2,2,13.8,null,null,null,null,93.867000000000004,{"$f":"B33","v":"C7+"}]
[]
[null,{"$f":"CONCATENATE(PlusFrac,\" molecular weight\")","v":"C7+ molecular weight"},169.53,149.703,136.501,126.627,120.849,116.4,131.53700000000001,null,null,null,null,189.3,{"$f":"B35","v":"C7+ molecular weight"}]
[null,{"$f":"CONCATENATE(PlusFrac,\" specific gravity\")","v":"C7+ specific gravity"},0.81630000000000003,0.80130000000000001,0.78969999999999996,0.78029999999999999,0.77459999999999996,0.76990000000000003,0.78500000000000003,null,null,null,null,0.8276,{"$f":"B36","v":"C7+ specific gravity"}]
[null,null,{"$f":"4.5579*C35^0.15178/C36^0.84573","v":11.794271132964179},{"$f":"($C$37/4.5579/D35^0.15178)^(-1/0.84573)","v":0.79828089673869351},0.78516348852768281,0.7746540365361213,0.76818819332619237,0.76303438306259563,0.77996095186900272]
[null,"Total composition",{"$f":"IF(C10>1,SUM(C17:C33),\"\")","v":100.001},{"$f":"IF(D10>1,SUM(D17:D33),\"\")","v":100},{"$f":"IF(E10>1,SUM(E17:E33),\"\")","v":99.999000000000024},99.997999999999976,99.999000000000009,99.998999999999995,99.999999999999986,"","","",null,{"$f":"SUM(N17:N33)","v":99.999000000000009}]
[]
[]
[]
[null,"mol vol",{"$f":"C35/C36","v":207.68099963248804},{"$f":"D35/D36","v":186.8251591164358},172.8517158414588,162.27989234909649,156.01471727343147,151.18846603454995,167.56305732484077,null,null,null,null,{"$f":"(SUMPRODUCT(N17:N32,Mwref)+N33*N35)/100","v":182.40849600000001},"Residual liq MW"]
[null,"Plus fraction prod",null,{"$f":"D33*(D12-C12)/100","v":0.49451200000000001},0.54615599999999997,0.46761000000000008,0.32587999999999995,0.35383999999999988,2.745372000000001]
[null,"Cum moles",0,{"$f":"SUM($C43:D43)","v":0.49451200000000001},{"$f":"SUM($C43:E43)","v":1.0406679999999999},{"$f":"SUM($C43:F43)","v":1.508278},{"$f":"SUM($C43:G43)","v":1.834158},{"$f":"SUM($C43:H43)","v":2.1879979999999999},{"$f":"SUM($C43:I43)","v":4.9333700000000009},{"$f":"SUM($C43:J43)","v":4.9333700000000009},{"$f":"SUM($C43:K43)","v":4.9333700000000009},{"$f":"SUM($C43:L43)","v":4.9333700000000009}]
[null,null,null,{"$f":"D44/$C$51","v":5.1895476965054047E-2},0.10921062021198447,0.15828292580543604,0.19248168748032321,0.22961465001574141,0.51772169167803561]
[]
[null,"Vol prod",null,{"$f":"D43*D42","v":92.387283084986905},{"$f":"E43*E42","v":94.404001717107761},75.883700461361016,50.842076065065839,53.496526821665135,460.02292581401292,0,0,0]
[null,"Cum vol",null,{"$f":"SUM($C$47:D47)","v":92.387283084986905},{"$f":"SUM($C$47:E47)","v":186.79128480209465},{"$f":"SUM($C$47:F47)","v":262.67498526345565},{"$f":"SUM($C$47:G47)","v":313.51706132852149},{"$f":"SUM($C$47:H47)","v":367.01358815018665},{"$f":"SUM($C$47:I47)","v":827.03651396419957}]
[null,null,null,{"$f":"D48/$C$52","v":4.6684004596359234E-2},9.4387072625992996E-2,0.13273169001092175,0.15842258201958262,0.18545478840814464,0.41790791037490416]
[]
[null,"Initial moles",{"$f":"C33","v":9.5289999999999999}]
[null,"Vol",{"$f":"C51*C42","v":1978.9922454979785}]

{"sheet":"CCE & other data","index":3,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,1,8,3]]}
[null,"General Information",null,null,"Fill-In-Cell"]
[]
[null,"JK-1 Gas Condensate"]
[]
[null,"Reservoir temperature (deg F)",null,null,263]
[]
[null,"Initial pressure (psig)",null,null,10440]
[]
[null,"Definition of oil for surface oil and gas recoveries",null,null,"C5+"]
[]
[]
[null,"CCE Data"]
[null,"only enter data at or above dew point pressure"]
[null,"enter pressures in descending order"]
[]
[null,"Pressure","Relative",null,null,null,null,null,null,null,null,null,"Pressure","Rel vol"]
[null,"psig","volume",null,null,null,null,null,null,null,null,null,"P_CCE","V_CCE"]
[null,10440,0.83714999999999995,null,null,null,null,null,null,null,null,null,{"$f":"-B18","v":-10440},{"$f":"C18","v":0.83714999999999995}]
[null,5535,1,null,null,null,null,null,null,null,null,null,{"$f":"-B19","v":-5535},{"$f":"C19","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C4+"]
[null,"C5+"]
[null,"C6+"]
[null,"C7+"]
[]
[null,"Oil frac",{"$f":"MATCH(E9,B35:B38)+3","v":5}]
[]
[]
[null,{"$f":"CONCATENATE(\"Calculated oil gas ratio - assumes surface oil = \",E9)","v":"Calculated oil gas ratio - assumes surface oil = C5+"}]
[]
[null,"Tstd",520,"deg R"]
[null,"Pstd",14.7,"psia"]

{"sheet":"Material balance","index":4,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Fill-In-Cell"]
[null,"Forward material balance",null,null,null,null,"Backward material balance"]
[null,"Calculates residual liquid composition",null,null,null,null,"Calculates initial gas composition"]
[]
[null,null,null,null,null,"Calculated density of residual liquid",null,null,{"$f":"INDEX('CVD analysis'!C49:K49,N_pres)","v":44.554043676349629},"lb/ft3"]
[null,null,null,null,null,"Density of res. Oil to use in calculation",null,null,{"$f":"K7*62.42797","v":51.278334558000005},"lb/ft3",0.82140000000000002,"g/cc"]
[]
[null,null,"Measured","Calculated",null,null,null,"Measured","Calculated"]
[null,{"$f":"'CVD Data'!B17","v":"N2"},{"$f":"'CVD Data'!N17","v":0},{"$f":"INDEX('CVD analysis'!C96:L96,N_pres)","v":0.10318197046067223},null,null,{"$f":"'CVD Data'!B17","v":"N2"},{"$f":"'CVD Data'!C17","v":0.39300000000000002},{"$f":"'CVD analysis'!C138","v":0.38686513036208942}]
[null,{"$f":"'CVD Data'!B18","v":"CO2"},{"$f":"'CVD Data'!N18","v":0},{"$f":"INDEX('CVD analysis'!C97:L97,N_pres)","v":0.73083760181294333},null,null,{"$f":"'CVD Data'!B18","v":"CO2"},{"$f":"'CVD Data'!C18","v":1.776},{"$f":"'CVD analysis'!C139","v":1.7327008748468302}]
[null,{"$f":"'CVD Data'!B19","v":"H2S"},{"$f":"'CVD Data'!N19","v":0},{"$f":"INDEX('CVD analysis'!C98:L98,N_pres)","v":0},null,null,{"$f":"'CVD Data'!B19","v":"H2S"},{"$f":"'CVD Data'!C19","v":0},{"$f":"'CVD analysis'!C140","v":0}]
[null,{"$f":"'CVD Data'!B20","v":"C1"},{"$f":"'CVD Data'!N20","v":2E-3},{"$f":"INDEX('CVD analysis'!C99:L99,N_pres)","v":13.273940857711361},null,null,{"$f":"'CVD Data'!B20","v":"C1"},{"$f":"'CVD Data'!C20","v":68.25},{"$f":"'CVD analysis'!C141","v":67.457443358171233}]
[null,{"$f":"'CVD Data'!B21","v":"C2"},{"$f":"'CVD Data'!N21","v":8.0000000000000002E-3},{"$f":"INDEX('CVD analysis'!C100:L100,N_pres)","v":0.75350219935224794},null,null,{"$f":"'CVD Data'!B21","v":"C2"},{"$f":"'CVD Data'!C21","v":7.024},{"$f":"'CVD analysis'!C142","v":6.9787124125259128}]
[null,{"$f":"'CVD Data'!B22","v":"C3"},{"$f":"'CVD Data'!N22","v":0.154},{"$f":"INDEX('CVD analysis'!C101:L101,N_pres)","v":1.3149334828029289},null,null,{"$f":"'CVD Data'!B22","v":"C3"},{"$f":"'CVD Data'!C22","v":6.625},{"$f":"'CVD analysis'!C143","v":6.5551273806385186}]
[null,{"$f":"'CVD Data'!B23","v":"iC4"},{"$f":"'CVD Data'!N23","v":0.188},{"$f":"INDEX('CVD analysis'!C102:L102,N_pres)","v":0.28289638515333182},null,null,{"$f":"'CVD Data'!B23","v":"iC4"},{"$f":"'CVD Data'!C23","v":1.4179999999999999},{"$f":"'CVD analysis'!C144","v":1.4120514392920815}]
[null,{"$f":"'CVD Data'!B24","v":"nC4"},{"$f":"'CVD Data'!N24","v":0.60799999999999998},{"$f":"INDEX('CVD analysis'!C103:L103,N_pres)","v":0.90797806933032466},null,null,{"$f":"'CVD Data'!B24","v":"nC4"},{"$f":"'CVD Data'!C24","v":2.319},{"$f":"'CVD analysis'!C145","v":2.3008165479227034}]
[null,{"$f":"'CVD Data'!B25","v":"iC5"},{"$f":"'CVD Data'!N25","v":0.83899999999999997},{"$f":"INDEX('CVD analysis'!C104:L104,N_pres)","v":0.92549308722885293},null,null,{"$f":"'CVD Data'!B25","v":"iC5"},{"$f":"'CVD Data'!C25","v":0.85699999999999998},{"$f":"'CVD analysis'!C146","v":0.8518230846728998}]
[null,{"$f":"'CVD Data'!B26","v":"nC5"},{"$f":"'CVD Data'!N26","v":1.099},{"$f":"INDEX('CVD analysis'!C105:L105,N_pres)","v":1.1310278334326573},null,null,{"$f":"'CVD Data'!B26","v":"nC5"},{"$f":"'CVD Data'!C26","v":0.84199999999999997},{"$f":"'CVD analysis'!C147","v":0.84008604241441387}]
[null,{"$f":"'CVD Data'!B27","v":"C6"},{"$f":"'CVD Data'!N27","v":3.234},{"$f":"INDEX('CVD analysis'!C106:L106,N_pres)","v":3.0678981303489583},null,null,{"$f":"'CVD Data'!B27","v":"C6"},{"$f":"'CVD Data'!C27","v":0.96799999999999997},{"$f":"'CVD analysis'!C148","v":0.97810544602427529}]
[null,{"$f":"'CVD Data'!B28","v":"C7"},{"$f":"'CVD Data'!N28","v":0},{"$f":"INDEX('CVD analysis'!C107:L107,N_pres)","v":0},null,null,{"$f":"'CVD Data'!B28","v":"C7"},{"$f":"'CVD Data'!C28","v":0},{"$f":"'CVD analysis'!C149","v":0}]
[null,{"$f":"'CVD Data'!B29","v":"C8"},{"$f":"'CVD Data'!N29","v":0},{"$f":"INDEX('CVD analysis'!C108:L108,N_pres)","v":0},null,null,{"$f":"'CVD Data'!B29","v":"C8"},{"$f":"'CVD Data'!C29","v":0},{"$f":"'CVD analysis'!C150","v":0}]
[null,{"$f":"'CVD Data'!B30","v":"C9"},{"$f":"'CVD Data'!N30","v":0},{"$f":"INDEX('CVD analysis'!C109:L109,N_pres)","v":0},null,null,{"$f":"'CVD Data'!B30","v":"C9"},{"$f":"'CVD Data'!C30","v":0},{"$f":"'CVD analysis'!C151","v":0}]
[null,{"$f":"'CVD Data'!B31","v":"C10"},{"$f":"'CVD Data'!N31","v":0},{"$f":"INDEX('CVD analysis'!C110:L110,N_pres)","v":0},null,null,{"$f":"'CVD Data'!B31","v":"C10"},{"$f":"'CVD Data'!C31","v":0},{"$f":"'CVD analysis'!C152","v":0}]
[null,{"$f":"'CVD Data'!B32","v":"C11"},{"$f":"'CVD Data'!N32","v":0},{"$f":"INDEX('CVD analysis'!C111:L111,N_pres)","v":0},null,null,{"$f":"'CVD Data'!B32","v":"C11"},{"$f":"'CVD Data'!C32","v":0},{"$f":"'CVD analysis'!C153","v":0}]
[null,{"$f":"'CVD Data'!B33","v":"C7+"},{"$f":"'CVD Data'!N33","v":93.867000000000004},{"$f":"INDEX('CVD analysis'!C112:L112,N_pres)","v":77.508310382365721},null,null,{"$f":"'CVD Data'!B33","v":"C7+"},{"$f":"'CVD Data'!C33","v":9.5289999999999999},{"$f":"'CVD analysis'!C154","v":10.505369699906229}]
[]
[null,null,{"$f":"SUM(C10:C26)","v":99.999000000000009},{"$f":"SUM(D10:D26)","v":100},null,null,null,{"$f":"SUM(H10:H26)","v":100.001},{"$f":"SUM(I10:I26)","v":99.999101416777194}]

{"sheet":"MBO props","index":9,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Calculated modified black oil properties"]
[]
[]
["Pressure (psia)",null,{"$f":"'CVD Data'!C10","v":5535},{"$f":"'CVD Data'!D10","v":4500},{"$f":"'CVD Data'!E10","v":3500},{"$f":"'CVD Data'!F10","v":2500},{"$f":"'CVD Data'!G10","v":1700},{"$f":"'CVD Data'!H10","v":900},{"$f":"'CVD Data'!I10","v":2},{"$f":"'CVD Data'!J10","v":0},{"$f":"'CVD Data'!K10","v":0},{"$f":"'CVD Data'!L10","v":0}]
["Pressure (psia)","P",{"$f":"C4+Pstd","v":5549.7},{"$f":"D4+Pstd","v":4514.7},3514.7,2514.6999999999998,1714.7,914.7,16.7,14.7,14.7,14.7]
[]
["Moles of Gas",null,null,null,null,null,null,null,null,null,null,null,null,"Carbon_no"]
["up to C3",null,{"$f":"SUM('CVD Data'!C17:C22)","v":84.067999999999998},{"$f":"SUM('CVD Data'!D17:D22)","v":87.825999999999993},{"$f":"SUM('CVD Data'!E17:E22)","v":90.38000000000001},{"$f":"SUM('CVD Data'!F17:F22)","v":91.843999999999994},{"$f":"SUM('CVD Data'!G17:G22)","v":92.544000000000011},{"$f":"SUM('CVD Data'!H17:H22)","v":91.899000000000001},{"$f":"SUM('CVD Data'!I17:I22)","v":77.334000000000003},{"$f":"SUM('CVD Data'!J17:J22)","v":0},{"$f":"SUM('CVD Data'!K17:K22)","v":0},{"$f":"SUM('CVD Data'!L17:L22)","v":0}]
["C4",null,{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!C23+'CVD Data'!C24,0)","v":3.7370000000000001},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!D23+'CVD Data'!D24,0)","v":3.5300000000000002},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!E23+'CVD Data'!E24,0)","v":3.4249999999999998},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!F23+'CVD Data'!F24,0)","v":3.4130000000000003},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!G23+'CVD Data'!G24,0)","v":3.4370000000000003},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!H23+'CVD Data'!H24,0)","v":3.8220000000000001},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!I23+'CVD Data'!I24,0)","v":5.234},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!J23+'CVD Data'!J24,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!K23+'CVD Data'!K24,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!L23+'CVD Data'!L24,0)","v":0},null,4]
["C5",null,{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!C25+'CVD Data'!C26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!D25+'CVD Data'!D26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!E25+'CVD Data'!E26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!F25+'CVD Data'!F26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!G25+'CVD Data'!G26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!H25+'CVD Data'!H26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!I25+'CVD Data'!I26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!J25+'CVD Data'!J26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!K25+'CVD Data'!K26,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!L25+'CVD Data'!L26,0)","v":0},null,5]
["C6",null,{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!C27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!D27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!E27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!F27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!G27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!H27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!I27,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!J27+'CVD Data'!J33,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!K27+'CVD Data'!K33,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!L27+'CVD Data'!L33,0)","v":0},null,6]
["Gas volume at surface  (ft3/mol of equil gas)",null,{"$f":"SUM(C8:C11)*UGC*Tstd/Pstd/100","v":333.33884027210877},346.81969240816323,356.1169627210885,361.62926835374145,364.377828462585,363.39077648979588,313.45733572789112,0,0,0]
[]
[]
["Moles of oil"]
["iC4",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!J23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!K23,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!L23,0)","v":0},null,4]
["nC4",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!J24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!K24,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!L24,0)","v":0},null,4]
["iC5",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C25,0)","v":0.85699999999999998},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D25,0)","v":0.8},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E25,0)","v":0.76600000000000001},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F25,0)","v":0.72399999999999998},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G25,0)","v":0.69},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H25,0)","v":0.81499999999999995},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I25,0)","v":1.2130000000000001},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!J25,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!K25,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!L25,0)","v":0},null,5]
["nC5",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C26,0)","v":0.84199999999999997},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D26,0)","v":0.78700000000000003},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E26,0)","v":0.75700000000000001},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F26,0)","v":0.71599999999999997},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G26,0)","v":0.68100000000000005},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H26,0)","v":0.76200000000000001},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I26,0)","v":1.151},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!J26,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!K26,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!L26,0)","v":0},null,5]
["C6",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C27,0)","v":0.96799999999999997},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D27,0)","v":0.85699999999999998},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E27,0)","v":0.77100000000000002},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F27,0)","v":0.70099999999999996},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G27,0)","v":0.64700000000000002},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H27,0)","v":0.70099999999999996},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I27,0)","v":1.268},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!J27,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!K27,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!L27,0)","v":0},null,6]
["C7",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I28,0)","v":0},null,null,null,null,7]
["C8",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C29,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D29,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E29,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F29,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G29,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H29,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I29,0)","v":0},null,null,null,null,8]
["C9",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C30,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D30,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E30,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F30,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G30,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H30,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I30,0)","v":0},null,null,null,null,9]
["C10",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C31,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D31,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E31,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F31,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G31,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H31,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I31,0)","v":0},null,null,null,null,10]
["C11",null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C32,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D32,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E32,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F32,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G32,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H32,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I32,0)","v":0},null,null,null,null,11]
[{"$f":"'CVD Data'!B33","v":"C7+"},null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C33,0)","v":9.5289999999999999},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!D33,0)","v":6.2},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!E33,0)","v":3.9},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!F33,0)","v":2.6},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!G33,0)","v":2},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!H33,0)","v":2},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!I33,0)","v":13.8},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!J33,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!K33,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!L33,0)","v":0},null,{"$f":"N_plus","v":7}]
[]
["Volume of Oil",null,null,null,null,null,null,null,null,null,null,null,null,"MW","Density","(lb/ft3)"]
["iC4",null,{"$f":"C16*MW/Density/100","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"'CVD Data'!Q23","v":58.12},{"$f":"'CVD Data'!R23","v":35.01}]
["nC4",null,{"$f":"C17*MW/Density/100","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"'CVD Data'!Q24","v":58.12},{"$f":"'CVD Data'!R24","v":36.450000000000003}]
["iC5",null,{"$f":"C18*MW/Density/100","v":1.5801827242524918E-2},1.4750830564784054E-2,1.4123920265780732E-2,1.3349501661129567E-2,1.2722591362126244E-2,1.5027408637873753E-2,2.2365946843853825E-2,0,0,0,null,{"$f":"'CVD Data'!Q25","v":72.150000000000006},{"$f":"'CVD Data'!R25","v":39.130000000000003}]
["nC5",null,{"$f":"C19*MW/Density/100","v":1.5458091603053437E-2},1.4448358778625957E-2,1.3897595419847331E-2,1.3144885496183208E-2,1.2502328244274812E-2,1.39893893129771E-2,2.1130954198473283E-2,0,0,0,null,{"$f":"'CVD Data'!Q26","v":72.150000000000006},{"$f":"'CVD Data'!R26","v":39.299999999999997}]
["C6",null,{"$f":"C20*MW/Density/100","v":2.0250682204418551E-2},1.7928548191308572E-2,1.6129417334304445E-2,1.4665008497208061E-2,1.3535321680019424E-2,1.4665008497208061E-2,2.6526720077688762E-2,0,0,0,null,{"$f":"'CVD Data'!Q27","v":86.17},{"$f":"'CVD Data'!R27","v":41.19}]
["C7",null,{"$f":"C21*MW/Density/100","v":0},0,0,0,0,0,0,null,null,null,null,{"$f":"'CVD Data'!Q28","v":100.2},{"$f":"'CVD Data'!R28","v":42.583343738294417}]
["C8",null,{"$f":"C22*MW/Density/100","v":0},0,0,0,0,0,0,null,null,null,null,{"$f":"'CVD Data'!Q29","v":114.2},{"$f":"'CVD Data'!R29","v":44.194031714321383}]
["C9",null,{"$f":"C23*MW/Density/100","v":0},0,0,0,0,0,0,null,null,null,null,{"$f":"'CVD Data'!Q30","v":128.30000000000001},{"$f":"'CVD Data'!R30","v":45.348982394805837}]
["C10",null,{"$f":"C24*MW/Density/100","v":0},0,0,0,0,0,0,null,null,null,null,{"$f":"'CVD Data'!Q31","v":142.30000000000001},{"$f":"'CVD Data'!R31","v":45.679860157323013}]
["C11",null,{"$f":"C25*MW/Density/100","v":0},0,0,0,0,0,0,null,null,null,null,{"$f":"'CVD Data'!Q32","v":156.30000000000001},{"$f":"'CVD Data'!R32","v":46}]
[{"$f":"A26","v":"C7+"},null,{"$f":"IF('CVD Data'!C10>1,C26*'CVD Data'!C$35/('CVD Data'!C$36*62.4)/100,0)","v":0.31714619318877862},{"$f":"IF('CVD Data'!D10>1,D26*'CVD Data'!D35/('CVD Data'!D36*62.4)/100,0)","v":0.18562756194261251},{"$f":"IF('CVD Data'!E10>1,E26*'CVD Data'!E35/('CVD Data'!E36*62.4)/100,0)","v":0.10803232240091173},{"$f":"IF('CVD Data'!F10>1,F26*'CVD Data'!F35/('CVD Data'!F36*62.4)/100,0)","v":6.7616621812123551E-2},{"$f":"IF('CVD Data'!G10>1,G26*'CVD Data'!G35/('CVD Data'!G36*62.4)/100,0)","v":5.0004717074817774E-2},{"$f":"IF('CVD Data'!H10>1,H26*'CVD Data'!H35/('CVD Data'!H36*62.4)/100,0)","v":4.8457841677740365E-2},{"$f":"IF('CVD Data'!I10>1,I26*'CVD Data'!I35/('CVD Data'!I36*62.4)/100,0)","v":0.37057214600685939},{"$f":"IF('CVD Data'!J10>1,J26*'CVD Data'!J35/('CVD Data'!J36*62.4)/100,0)","v":0},{"$f":"IF('CVD Data'!K10>1,K26*'CVD Data'!K35/('CVD Data'!K36*62.4)/100,0)","v":0},{"$f":"IF('CVD Data'!L10>1,L26*'CVD Data'!L35/('CVD Data'!L36*62.4)/100,0)","v":0}]
["Oil volume at surface (ft3/mol of equil gas)",null,{"$f":"SUM(C29:C39)","v":0.36865679423877551},0.23275529947733109,0.15218325542084424,0.10877601746664439,8.8764958361238253E-2,9.2139648125799278E-2,0.44059576712687526,0,0,0]
[]
["Oil-gas ratio (bbl/MMscf)",null,{"$f":"IF(C12>0,C40/C12/5.6146*1000000,0)","v":196.97789895711659},119.53002433431779,76.112395019500056,53.573591299642025,43.388115646396407,45.159989067078854,{"$f":"IF(I12>0,I40/I12/5.6146*1000000,0)","v":250.34738609328917},0,0,0]
["GOR (scf/STB)",null,{"$f":"1000000/C42","v":5076.7116782868452},{"$f":"1000000/D42","v":8366.0988573303093},13138.464500345826,18665.91310645777,23047.785899479477,22143.495174780484,3994.4495351246092]
["Gas FVF (res bbl/Mscf)",null,{"$f":"IF(C12>0,1000*('CVD Data'!C14*UGC*Tres/P/5.6146)/C12,0)","v":0.8081539504905183},{"$f":"IF(D12>0,1000*('CVD Data'!D14*UGC*Tres/P/5.6146)/D12,0)","v":0.81180449612876426},{"$f":"IF(E12>0,1000*('CVD Data'!E14*UGC*Tres/P/5.6146)/E12,0)","v":0.93973542625988093},{"$f":"IF(F12>0,1000*('CVD Data'!F14*UGC*Tres/P/5.6146)/F12,0)","v":1.2712345342454987},{"$f":"IF(G12>0,1000*('CVD Data'!G14*UGC*Tres/P/5.6146)/G12,0)","v":1.8942671840200109},{"$f":"IF(H12>0,1000*('CVD Data'!H14*UGC*Tres/P/5.6146)/H12,0)","v":3.7688486027272123},{"$f":"IF(I12>0,1000*('CVD Data'!I14*UGC*Tres/P/5.6146)/I12,0)","v":263.88029440276347},{"$f":"IF(J12>0,1000*('CVD Data'!J14*UGC*Tres/P/5.6146)/J12,0)","v":0},{"$f":"IF(K12>0,1000*('CVD Data'!K14*UGC*Tres/P/5.6146)/K12,0)","v":0},{"$f":"IF(L12>0,1000*('CVD Data'!L14*UGC*Tres/P/5.6146)/L12,0)","v":0}]

{"sheet":"Rec factors calc","index":10,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Calculated recovery factors"]
[]
[]
["Calculated recovery factors for each component"]
[]
["Abandonment pressure (psia)",{"$f":"P_init","v":10440},{"$f":"IF('CVD Data'!C10>1,'CVD Data'!C10,A6)","v":5535},{"$f":"IF('CVD Data'!D10>1,'CVD Data'!D10,B6)","v":4500},{"$f":"IF('CVD Data'!E10>1,'CVD Data'!E10,D6)","v":3500},{"$f":"IF('CVD Data'!F10>1,'CVD Data'!F10,E6)","v":2500},{"$f":"IF('CVD Data'!G10>1,'CVD Data'!G10,F6)","v":1700},{"$f":"IF('CVD Data'!H10>1,'CVD Data'!H10,G6)","v":900},{"$f":"IF('CVD Data'!I10>1,'CVD Data'!I10,H6)","v":2},{"$f":"IF('CVD Data'!J10>1,'CVD Data'!J10,I6)","v":2},{"$f":"IF('CVD Data'!K10>1,'CVD Data'!K10,J6)","v":2},{"$f":"IF('CVD Data'!L10>1,'CVD Data'!L10,K6)","v":2}]
[]
["Component"]
[{"$f":"'CVD Data'!B20","v":"C1"},0,{"$f":"IF(C$6=\"\",\"\",1-'CVD analysis'!C56/'CVD analysis'!$C56*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-'CVD analysis'!D56/'CVD analysis'!$C56*N_init)","v":0.2332047100907253},{"$f":"IF(E$6=\"\",\"\",1-'CVD analysis'!E56/'CVD analysis'!$C56*N_init)","v":0.3608984017354725},{"$f":"IF(F$6=\"\",\"\",1-'CVD analysis'!F56/'CVD analysis'!$C56*N_init)","v":0.52753736306140664},{"$f":"IF(G$6=\"\",\"\",1-'CVD analysis'!G56/'CVD analysis'!$C56*N_init)","v":0.67952975356439571},{"$f":"IF(H$6=\"\",\"\",1-'CVD analysis'!H56/'CVD analysis'!$C56*N_init)","v":0.84168531801705493},{"$f":"IF(I$6=\"\",\"\",1-'CVD analysis'!I56/'CVD analysis'!$C56*N_init)","v":0.98838435522259338},{"$f":"IF(J$6=\"\",\"\",1-'CVD analysis'!J56/'CVD analysis'!$C56*N_init)","v":0.98838435522259338},{"$f":"IF(K$6=\"\",\"\",1-'CVD analysis'!K56/'CVD analysis'!$C56*N_init)","v":0.98838435522259338},{"$f":"IF(L$6=\"\",\"\",1-'CVD analysis'!L56/'CVD analysis'!$C56*N_init)","v":0.98838435522259338}]
[{"$f":"'CVD Data'!B21","v":"C2"},0,{"$f":"IF(C$6=\"\",\"\",1-'CVD analysis'!C57/'CVD analysis'!$C57*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-'CVD analysis'!D57/'CVD analysis'!$C57*N_init)","v":0.23108502860933955},{"$f":"IF(E$6=\"\",\"\",1-'CVD analysis'!E57/'CVD analysis'!$C57*N_init)","v":0.3519914375763098},{"$f":"IF(F$6=\"\",\"\",1-'CVD analysis'!F57/'CVD analysis'!$C57*N_init)","v":0.51198438957801828},{"$f":"IF(G$6=\"\",\"\",1-'CVD analysis'!G57/'CVD analysis'!$C57*N_init)","v":0.6599832775679102},{"$f":"IF(H$6=\"\",\"\",1-'CVD analysis'!H57/'CVD analysis'!$C57*N_init)","v":0.82215626637742023},{"$f":"IF(I$6=\"\",\"\",1-'CVD analysis'!I57/'CVD analysis'!$C57*N_init)","v":0.99235030589023354},{"$f":"IF(J$6=\"\",\"\",1-'CVD analysis'!J57/'CVD analysis'!$C57*N_init)","v":0.99235030589023354},{"$f":"IF(K$6=\"\",\"\",1-'CVD analysis'!K57/'CVD analysis'!$C57*N_init)","v":0.99235030589023354},{"$f":"IF(L$6=\"\",\"\",1-'CVD analysis'!L57/'CVD analysis'!$C57*N_init)","v":0.99235030589023354},null,null,null,"V_Pinit",{"$f":"Tablook(-P_init,P_CCE,V_CCE)","v":0.83714999999999995}]
[{"$f":"'CVD Data'!B22","v":"C3"},0,{"$f":"IF(C$6=\"\",\"\",1-'CVD analysis'!C58/'CVD analysis'!$C58*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-'CVD analysis'!D58/'CVD analysis'!$C58*N_init)","v":0.2283713308806038},{"$f":"IF(E$6=\"\",\"\",1-'CVD analysis'!E58/'CVD analysis'!$C58*N_init)","v":0.34341154121811324},{"$f":"IF(F$6=\"\",\"\",1-'CVD analysis'!F58/'CVD analysis'!$C58*N_init)","v":0.49115491332037742},{"$f":"IF(G$6=\"\",\"\",1-'CVD analysis'!G58/'CVD analysis'!$C58*N_init)","v":0.62500704037260379},{"$f":"IF(H$6=\"\",\"\",1-'CVD analysis'!H58/'CVD analysis'!$C58*N_init)","v":0.78400299610633961},{"$f":"IF(I$6=\"\",\"\",1-'CVD analysis'!I58/'CVD analysis'!$C58*N_init)","v":0.98739867105139623},{"$f":"IF(J$6=\"\",\"\",1-'CVD analysis'!J58/'CVD analysis'!$C58*N_init)","v":0.98739867105139623},{"$f":"IF(K$6=\"\",\"\",1-'CVD analysis'!K58/'CVD analysis'!$C58*N_init)","v":0.98739867105139623},{"$f":"IF(L$6=\"\",\"\",1-'CVD analysis'!L58/'CVD analysis'!$C58*N_init)","v":0.98739867105139623},null,null,null,"V_Pdew",{"$f":"Tablook(-Pdew,P_CCE,V_CCE)","v":1}]
["C4's",0,{"$f":"IF(C$6=\"\",\"\",1-('CVD analysis'!C59+'CVD analysis'!C60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-('CVD analysis'!D59+'CVD analysis'!D60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.22592249839978606},{"$f":"IF(E$6=\"\",\"\",1-('CVD analysis'!E59+'CVD analysis'!E60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.3333691439844797},{"$f":"IF(F$6=\"\",\"\",1-('CVD analysis'!F59+'CVD analysis'!F60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.47087681111252366},{"$f":"IF(G$6=\"\",\"\",1-('CVD analysis'!G59+'CVD analysis'!G60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.5963316531186782},{"$f":"IF(H$6=\"\",\"\",1-('CVD analysis'!H59+'CVD analysis'!H60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.74780903741517246},{"$f":"IF(I$6=\"\",\"\",1-('CVD analysis'!I59+'CVD analysis'!I60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.98106675170845603},{"$f":"IF(J$6=\"\",\"\",1-('CVD analysis'!J59+'CVD analysis'!J60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.98106675170845603},{"$f":"IF(K$6=\"\",\"\",1-('CVD analysis'!K59+'CVD analysis'!K60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.98106675170845603},{"$f":"IF(L$6=\"\",\"\",1-('CVD analysis'!L59+'CVD analysis'!L60)/('CVD analysis'!$C59+'CVD analysis'!$C60)*N_init)","v":0.98106675170845603},null,null,null,"N_init",{"$f":"V_Pinit/V_Pdew","v":0.83714999999999995}]
["C5's",0,{"$f":"IF(C$6=\"\",\"\",1-('CVD analysis'!C61+'CVD analysis'!C62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-('CVD analysis'!D61+'CVD analysis'!D62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.2252194586862859},{"$f":"IF(E$6=\"\",\"\",1-('CVD analysis'!E61+'CVD analysis'!E62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.33030958357033546},{"$f":"IF(F$6=\"\",\"\",1-('CVD analysis'!F61+'CVD analysis'!F62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.4579190335997646},{"$f":"IF(G$6=\"\",\"\",1-('CVD analysis'!G61+'CVD analysis'!G62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.56799058038669803},{"$f":"IF(H$6=\"\",\"\",1-('CVD analysis'!H61+'CVD analysis'!H62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.70546393383343131},{"$f":"IF(I$6=\"\",\"\",1-('CVD analysis'!I61+'CVD analysis'!I62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.93719245416539143},{"$f":"IF(J$6=\"\",\"\",1-('CVD analysis'!J61+'CVD analysis'!J62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.93719245416539143},{"$f":"IF(K$6=\"\",\"\",1-('CVD analysis'!K61+'CVD analysis'!K62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.93719245416539143},{"$f":"IF(L$6=\"\",\"\",1-('CVD analysis'!L61+'CVD analysis'!L62)/('CVD analysis'!$C61+'CVD analysis'!$C62)*N_init)","v":0.93719245416539143}]
[{"$f":"'CVD Data'!B27","v":"C6"},0,{"$f":"IF(C$6=\"\",\"\",1-'CVD analysis'!C63/'CVD analysis'!$C63*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-'CVD analysis'!D63/'CVD analysis'!$C63*N_init)","v":0.22196448242561984},{"$f":"IF(E$6=\"\",\"\",1-'CVD analysis'!E63/'CVD analysis'!$C63*N_init)","v":0.31534029720454548},{"$f":"IF(F$6=\"\",\"\",1-'CVD analysis'!F63/'CVD analysis'!$C63*N_init)","v":0.42437290121022742},{"$f":"IF(G$6=\"\",\"\",1-'CVD analysis'!G63/'CVD analysis'!$C63*N_init)","v":0.5155445726844009},{"$f":"IF(H$6=\"\",\"\",1-'CVD analysis'!H63/'CVD analysis'!$C63*N_init)","v":0.62280088795092969},{"$f":"IF(I$6=\"\",\"\",1-'CVD analysis'!I63/'CVD analysis'!$C63*N_init)","v":0.84095795760795466},{"$f":"IF(J$6=\"\",\"\",1-'CVD analysis'!J63/'CVD analysis'!$C63*N_init)","v":0.84095795760795466},{"$f":"IF(K$6=\"\",\"\",1-'CVD analysis'!K63/'CVD analysis'!$C63*N_init)","v":0.84095795760795466},{"$f":"IF(L$6=\"\",\"\",1-'CVD analysis'!L63/'CVD analysis'!$C63*N_init)","v":0.84095795760795466}]
[{"$f":"'CVD Data'!B33","v":"C7+"},0,{"$f":"IF(C$6=\"\",\"\",1-'CVD analysis'!C69/'CVD analysis'!$C69*N_init)","v":0.16285000000000005},{"$f":"IF(D$6=\"\",\"\",1-'CVD analysis'!D69/'CVD analysis'!$C69*N_init)","v":0.206294298541295},{"$f":"IF(E$6=\"\",\"\",1-'CVD analysis'!E69/'CVD analysis'!$C69*N_init)","v":0.25427567071046286},{"$f":"IF(F$6=\"\",\"\",1-'CVD analysis'!F69/'CVD analysis'!$C69*N_init)","v":0.29535655133802086},{"$f":"IF(G$6=\"\",\"\",1-'CVD analysis'!G69/'CVD analysis'!$C69*N_init)","v":0.3239860446741526},{"$f":"IF(H$6=\"\",\"\",1-'CVD analysis'!H69/'CVD analysis'!$C69*N_init)","v":0.35507190426067803},{"$f":"IF(I$6=\"\",\"\",1-'CVD analysis'!I69/'CVD analysis'!$C69*N_init)","v":0.59626071418826765},{"$f":"IF(J$6=\"\",\"\",1-'CVD analysis'!J69/'CVD analysis'!$C69*N_init)","v":0.59626071418826765},{"$f":"IF(K$6=\"\",\"\",1-'CVD analysis'!K69/'CVD analysis'!$C69*N_init)","v":0.59626071418826765},{"$f":"IF(L$6=\"\",\"\",1-'CVD analysis'!L69/'CVD analysis'!$C69*N_init)","v":0.59626071418826765}]
[]
["Gas",0,{"$f":"IF(C$6=\"\",\"\",1-(1-C42/Initial_gas)*N_init)","v":0.16285000000000005},0.23232143271913908,0.35756693080273338,0.52090648890725477,0.67001314020047276,0.83147434622220251,0.98808377769794997,0.98808377769794997,0.98808377769794997,0.98808377769794997]
["Oil",0,{"$f":"IF(C$6=\"\",\"\",1-(1-C61/Initial_oil)*N_init)","v":0.16285000000000005},0.20500661801360986,0.25340156422342774,0.29782627773334713,0.33066984375882036,0.36768712507466028,0.56672855061065419,0.56672855061065419,0.56672855061065419,0.56672855061065419]
[]
[]
["Moles produced at each step"]
["N2",null,0,{"$f":"'CVD analysis'!C53-'CVD analysis'!D53","v":3.230280000000002E-2},{"$f":"'CVD analysis'!D53-'CVD analysis'!E53","v":6.0637319999999995E-2},{"$f":"'CVD analysis'!E53-'CVD analysis'!F53","v":7.9493700000000028E-2},{"$f":"'CVD analysis'!F53-'CVD analysis'!G53","v":7.1204779999999995E-2},{"$f":"'CVD analysis'!G53-'CVD analysis'!H53","v":7.572175999999993E-2},{"$f":"'CVD analysis'!H53-'CVD analysis'!I53","v":6.6644900000000049E-2},{"$f":"'CVD analysis'!I53-'CVD analysis'!J53","v":0},{"$f":"'CVD analysis'!J53-'CVD analysis'!K53","v":0},{"$f":"'CVD analysis'!K53-'CVD analysis'!L53","v":0}]
["CO2",null,0,{"$f":"'CVD analysis'!C54-'CVD analysis'!D54","v":0.14588103999999991},{"$f":"'CVD analysis'!D54-'CVD analysis'!E54","v":0.26089452000000013},{"$f":"'CVD analysis'!E54-'CVD analysis'!F54","v":0.34153515000000012},{"$f":"'CVD analysis'!F54-'CVD analysis'!G54","v":0.31545183999999993},{"$f":"'CVD analysis'!G54-'CVD analysis'!H54","v":0.34410939999999973},{"$f":"'CVD analysis'!H54-'CVD analysis'!I54","v":0.32069128000000019},{"$f":"'CVD analysis'!I54-'CVD analysis'!J54","v":0},{"$f":"'CVD analysis'!J54-'CVD analysis'!K54","v":0},{"$f":"'CVD analysis'!K54-'CVD analysis'!L54","v":0}]
["H2S",null,0,{"$f":"'CVD analysis'!C55-'CVD analysis'!D55","v":0},{"$f":"'CVD analysis'!D55-'CVD analysis'!E55","v":0},{"$f":"'CVD analysis'!E55-'CVD analysis'!F55","v":0},{"$f":"'CVD analysis'!F55-'CVD analysis'!G55","v":0},{"$f":"'CVD analysis'!G55-'CVD analysis'!H55","v":0},{"$f":"'CVD analysis'!H55-'CVD analysis'!I55","v":0},{"$f":"'CVD analysis'!I55-'CVD analysis'!J55","v":0},{"$f":"'CVD analysis'!J55-'CVD analysis'!K55","v":0},{"$f":"'CVD analysis'!K55-'CVD analysis'!L55","v":0}]
["C1",null,0,{"$f":"'CVD analysis'!C56-'CVD analysis'!D56","v":5.7357808800000001},{"$f":"'CVD analysis'!D56-'CVD analysis'!E56","v":10.410433560000001},{"$f":"'CVD analysis'!E56-'CVD analysis'!F56","v":13.585509300000005},{"$f":"'CVD analysis'!F56-'CVD analysis'!G56","v":12.391424059999999},{"$f":"'CVD analysis'!G56-'CVD analysis'!H56","v":13.219993159999989},{"$f":"'CVD analysis'!H56-'CVD analysis'!I56","v":11.959874920000008},{"$f":"'CVD analysis'!I56-'CVD analysis'!J56","v":0},{"$f":"'CVD analysis'!J56-'CVD analysis'!K56","v":0},{"$f":"'CVD analysis'!K56-'CVD analysis'!L56","v":0}]
["C2",null,0,{"$f":"'CVD analysis'!C57-'CVD analysis'!D57","v":0.57251728000000046},{"$f":"'CVD analysis'!D57-'CVD analysis'!E57","v":1.0144497599999998},{"$f":"'CVD analysis'!E57-'CVD analysis'!F57","v":1.3424004000000007},{"$f":"'CVD analysis'!F57-'CVD analysis'!G57","v":1.24176574},{"$f":"'CVD analysis'!G57-'CVD analysis'!H57","v":1.3606917199999988},{"$f":"'CVD analysis'!H57-'CVD analysis'!I57","v":1.4279913200000007},{"$f":"'CVD analysis'!I57-'CVD analysis'!J57","v":0},{"$f":"'CVD analysis'!J57-'CVD analysis'!K57","v":0},{"$f":"'CVD analysis'!K57-'CVD analysis'!L57","v":0}]
["C3",null,0,{"$f":"'CVD analysis'!C58-'CVD analysis'!D58","v":0.51851976000000022},{"$f":"'CVD analysis'!D58-'CVD analysis'!E58","v":0.91040003999999985},{"$f":"'CVD analysis'!E58-'CVD analysis'!F58","v":1.1692048500000007},{"$f":"'CVD analysis'!F58-'CVD analysis'!G58","v":1.0592729399999996},{"$f":"'CVD analysis'!G58-'CVD analysis'!H58","v":1.258255039999999},{"$f":"'CVD analysis'!H58-'CVD analysis'!I58","v":1.6096235400000007},{"$f":"'CVD analysis'!I58-'CVD analysis'!J58","v":0},{"$f":"'CVD analysis'!J58-'CVD analysis'!K58","v":0},{"$f":"'CVD analysis'!K58-'CVD analysis'!L58","v":0}]
["iC4",null,0,{"$f":"'CVD analysis'!C59-'CVD analysis'!D59","v":0.10783552000000007},{"$f":"'CVD analysis'!D59-'CVD analysis'!E59","v":0.18373247999999998},{"$f":"'CVD analysis'!E59-'CVD analysis'!F59","v":0.23380500000000004},{"$f":"'CVD analysis'!F59-'CVD analysis'!G59","v":0.21573255999999996},{"$f":"'CVD analysis'!G59-'CVD analysis'!H59","v":0.25865703999999978},{"$f":"'CVD analysis'!H59-'CVD analysis'!I59","v":0.39608954000000024},{"$f":"'CVD analysis'!I59-'CVD analysis'!J59","v":0},{"$f":"'CVD analysis'!J59-'CVD analysis'!K59","v":0},{"$f":"'CVD analysis'!K59-'CVD analysis'!L59","v":0}]
["nC4",null,0,{"$f":"'CVD analysis'!C60-'CVD analysis'!D60","v":0.17371727999999997},{"$f":"'CVD analysis'!D60-'CVD analysis'!E60","v":0.29590452000000012},{"$f":"'CVD analysis'!E60-'CVD analysis'!F60","v":0.38002305000000014},{"$f":"'CVD analysis'!F60-'CVD analysis'!G60","v":0.34429221999999982},{"$f":"'CVD analysis'!G60-'CVD analysis'!H60","v":0.41753119999999966},{"$f":"'CVD analysis'!H60-'CVD analysis'!I60","v":0.64516242000000035},{"$f":"'CVD analysis'!I60-'CVD analysis'!J60","v":0},{"$f":"'CVD analysis'!J60-'CVD analysis'!K60","v":0},{"$f":"'CVD analysis'!K60-'CVD analysis'!L60","v":0}]
["iC5",null,0,{"$f":"'CVD analysis'!C61-'CVD analysis'!D61","v":6.3807999999999976E-2},{"$f":"'CVD analysis'!D61-'CVD analysis'!E61","v":0.10727063999999997},{"$f":"'CVD analysis'!E61-'CVD analysis'!F61","v":0.13021140000000009},{"$f":"'CVD analysis'!F61-'CVD analysis'!G61","v":0.11242859999999999},{"$f":"'CVD analysis'!G61-'CVD analysis'!H61","v":0.14418979999999987},{"$f":"'CVD analysis'!H61-'CVD analysis'!I61","v":0.24131422000000016},{"$f":"'CVD analysis'!I61-'CVD analysis'!J61","v":0},{"$f":"'CVD analysis'!J61-'CVD analysis'!K61","v":0},{"$f":"'CVD analysis'!K61-'CVD analysis'!L61","v":0}]
["nC5",null,0,{"$f":"'CVD analysis'!C62-'CVD analysis'!D62","v":6.2771119999999958E-2},{"$f":"'CVD analysis'!D62-'CVD analysis'!E62","v":0.10601028000000001},{"$f":"'CVD analysis'!E62-'CVD analysis'!F62","v":0.12877260000000001},{"$f":"'CVD analysis'!F62-'CVD analysis'!G62","v":0.11096213999999999},{"$f":"'CVD analysis'!G62-'CVD analysis'!H62","v":0.13481303999999988},{"$f":"'CVD analysis'!H62-'CVD analysis'!I62","v":0.22897994000000013},{"$f":"'CVD analysis'!I62-'CVD analysis'!J62","v":0},{"$f":"'CVD analysis'!J62-'CVD analysis'!K62","v":0},{"$f":"'CVD analysis'!K62-'CVD analysis'!L62","v":0}]
["C6",null,0,{"$f":"'CVD analysis'!C63-'CVD analysis'!D63","v":6.8354319999999968E-2},{"$f":"'CVD analysis'!D63-'CVD analysis'!E63","v":0.10797084000000001},{"$f":"'CVD analysis'!E63-'CVD analysis'!F63","v":0.12607485000000007},{"$f":"'CVD analysis'!F63-'CVD analysis'!G63","v":0.10542218000000003},{"$f":"'CVD analysis'!G63-'CVD analysis'!H63","v":0.12402091999999987},{"$f":"'CVD analysis'!H63-'CVD analysis'!I63","v":0.25225592000000013},{"$f":"'CVD analysis'!I63-'CVD analysis'!J63","v":0},{"$f":"'CVD analysis'!J63-'CVD analysis'!K63","v":0},{"$f":"'CVD analysis'!K63-'CVD analysis'!L63","v":0}]
["C7+",null,0,{"$f":"'CVD analysis'!C69-'CVD analysis'!D69","v":0.49451200000000028},{"$f":"'CVD analysis'!D69-'CVD analysis'!E69","v":0.54615599999999986},{"$f":"'CVD analysis'!E69-'CVD analysis'!F69","v":0.46761000000000053},{"$f":"'CVD analysis'!F69-'CVD analysis'!G69","v":0.32587999999999973},{"$f":"'CVD analysis'!G69-'CVD analysis'!H69","v":0.35383999999999993},{"$f":"'CVD analysis'!H69-'CVD analysis'!I69","v":2.7453720000000015},{"$f":"'CVD analysis'!I69-'CVD analysis'!J69","v":0},{"$f":"'CVD analysis'!J69-'CVD analysis'!K69","v":0},{"$f":"'CVD analysis'!K69-'CVD analysis'!L69","v":0}]
[]
[]
["Moles of gas produced",null,null,null,null,null,null,null,null,null,null,null,null,"Carbon_no",null,"Initial gas"]
["up to C3",null,{"$f":"SUM(C22:C27)","v":0},{"$f":"SUM(D22:D27)","v":7.0050017600000007},12.6568152,16.518143400000007,15.079119359999998,16.258771079999985,15.384825960000009,0,0,0,null,null,null,{"$f":"SUM('CVD Data'!C17:C22)","v":84.067999999999998}]
["C4",null,{"$f":"IF(Oil_frac>Carbon_no,C28+C29,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,D28+D29,0)","v":0.28155280000000005},0.47963700000000009,0.61382805000000018,0.56002477999999978,0.67618823999999944,1.0412519600000005,0,0,0,null,4,null,{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!C23+'CVD Data'!C24,0)","v":3.7370000000000001}]
["C5",null,{"$f":"IF(Oil_frac>Carbon_no,C30+C31,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,D30+D31,0)","v":0},0,0,0,0,0,0,0,0,null,5,null,{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!C25+'CVD Data'!C26,0)","v":0}]
["C6",null,{"$f":"IF(Oil_frac>Carbon_no,C32,0)","v":0},{"$f":"IF(Oil_frac>Carbon_no,D32,0)","v":0},0,0,0,0,0,0,0,0,null,6,null,{"$f":"IF(Oil_frac>Carbon_no,'CVD Data'!C27,0)","v":0}]
["Total",null,{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":7.2865545600000008},13.136452200000001,17.131971450000005,15.639144139999997,16.934959319999983,16.426077920000012,0,0,0,null,null,null,{"$f":"SUM(P37:P40)","v":87.804999999999993},"Initial gas"]
["Cumulative total",null,{"$f":"SUM($C$41:C41)","v":0},{"$f":"SUM($C$41:D41)","v":7.2865545600000008},{"$f":"SUM($C$41:E41)","v":20.42300676},{"$f":"SUM($C$41:F41)","v":37.554978210000002},{"$f":"SUM($C$41:G41)","v":53.194122350000001},{"$f":"SUM($C$41:H41)","v":70.129081669999977},{"$f":"SUM($C$41:I41)","v":86.555159589999988},{"$f":"SUM($C$41:J41)","v":86.555159589999988},{"$f":"SUM($C$41:K41)","v":86.555159589999988},{"$f":"SUM($C$41:L41)","v":86.555159589999988}]
[]
[]
["Moles of oil produced",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial oil"]
["iC4",null,{"$f":"IF(Oil_frac<=Carbon_no,C28,0)","v":0},{"$f":"IF(Oil_frac<=Carbon_no,D28,0)","v":0},0,0,0,0,0,0,0,0,null,4,null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C23,0)","v":0},"`"]
["nC4",null,{"$f":"IF(Oil_frac<=Carbon_no,C29,0)","v":0},0,0,0,0,0,0,0,0,0,null,4,null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C24,0)","v":0}]
["iC5",null,0,6.3807999999999976E-2,0.10727063999999997,0.13021140000000009,0.11242859999999999,0.14418979999999987,0.24131422000000016,0,0,0,null,5,null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C25,0)","v":0.85699999999999998}]
["nC5",null,0,6.2771119999999958E-2,0.10601028000000001,0.12877260000000001,0.11096213999999999,0.13481303999999988,0.22897994000000013,0,0,0,null,5,null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C26,0)","v":0.84199999999999997}]
["C6",null,0,6.8354319999999968E-2,0.10797084000000001,0.12607485000000007,0.10542218000000003,0.12402091999999987,0.25225592000000013,0,0,0,null,6,null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C27,0)","v":0.96799999999999997}]
["C7+",null,0,0.49451200000000028,0.54615599999999986,0.46761000000000053,0.32587999999999973,0.35383999999999993,2.7453720000000015,0,0,0,null,7,null,{"$f":"IF(Oil_frac<=Carbon_no,'CVD Data'!C33,0)","v":9.5289999999999999}]
[]
["Volume of oil produced (ft3/mol of equil gas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW","Density","(lb/ft3)"]
["iC4",null,{"$f":"C46*MW/Density/100","v":0},{"$f":"D46*MW/Density/100","v":0},0,0,0,0,0,0,0,0,null,null,null,{"$f":"P46*MW/Density/100","v":0},null,{"$f":"'CVD Data'!Q23","v":58.12},{"$f":"'CVD Data'!R23","v":35.01}]
["nC4",null,{"$f":"C47*MW/Density/100","v":0},{"$f":"D47*MW/Density/100","v":0},0,0,0,0,0,0,0,0,null,null,null,{"$f":"P47*MW/Density/100","v":0},null,{"$f":"'CVD Data'!Q24","v":58.12},{"$f":"'CVD Data'!R24","v":36.450000000000003}]
["iC5",null,{"$f":"C48*MW/Density/100","v":0},{"$f":"D48*MW/Density/100","v":1.1765262458471757E-3},1.9779137940199331E-3,2.4009078737541544E-3,2.0730190365448502E-3,2.6586491362126218E-3,4.4494814651162822E-3,0,0,0,null,null,null,{"$f":"P48*MW/Density/100","v":1.5801827242524918E-2},null,{"$f":"'CVD Data'!Q25","v":72.150000000000006},{"$f":"'CVD Data'!R25","v":39.130000000000003}]
["nC5",null,{"$f":"C49*MW/Density/100","v":0},{"$f":"D49*MW/Density/100","v":1.1524010961832054E-3},1.9462192625954206E-3,2.3641076564885504E-3,2.0371293641221373E-3,2.4750027572519066E-3,4.203792028244278E-3,0,0,0,null,null,null,{"$f":"P49*MW/Density/100","v":1.5458091603053437E-2},null,{"$f":"'CVD Data'!Q26","v":72.150000000000006},{"$f":"'CVD Data'!R26","v":39.299999999999997}]
["C6",null,{"$f":"C50*MW/Density/100","v":0},{"$f":"D50*MW/Density/100","v":1.4299810037387711E-3},2.2587636034959945E-3,2.6375017782228716E-3,2.2054453145423656E-3,2.5945333033260474E-3,5.2772256922554049E-3,0,0,0,null,null,null,{"$f":"P50*MW/Density/100","v":2.0250682204418551E-2},null,{"$f":"'CVD Data'!Q27","v":86.17},{"$f":"'CVD Data'!R27","v":41.19}]
["C7+",null,{"$f":"IF(C33>0,C33*'CVD Data'!C$35/('CVD Data'!C$36*62.4)/100,0)","v":0},{"$f":"IF(D33>0,D33*'CVD Data'!D$35/('CVD Data'!D$36*62.4)/100,0)","v":1.4805654340542779E-2},{"$f":"IF(E33>0,E33*'CVD Data'!E$35/('CVD Data'!E$36*62.4)/100,0)","v":1.5128846429023677E-2},{"$f":"IF(F33>0,F33*'CVD Data'!F$35/('CVD Data'!F$36*62.4)/100,0)","v":1.2160849432910433E-2},{"$f":"IF(G33>0,G33*'CVD Data'!G$35/('CVD Data'!G$36*62.4)/100,0)","v":8.1477686001708016E-3},{"$f":"IF(H33>0,H33*'CVD Data'!H$35/('CVD Data'!H$36*62.4)/100,0)","v":8.5731613496258241E-3},{"$f":"IF(I33>0,I33*'CVD Data'!I$35/('CVD Data'!I$36*62.4)/100,0)","v":7.3721622726604652E-2},{"$f":"IF(J33>0,J33*'CVD Data'!J$35/('CVD Data'!J$36*62.4)/100,0)","v":0},{"$f":"IF(K33>0,K33*'CVD Data'!K$35/('CVD Data'!K$36*62.4)/100,0)","v":0},{"$f":"IF(L33>0,L33*'CVD Data'!L$35/('CVD Data'!L$36*62.4)/100,0)","v":0},null,null,null,{"$f":"P51*'CVD Data'!C$35/('CVD Data'!C$36*62.4)/100","v":0.31714619318877862}]
["Total",null,{"$f":"SUM(C54:C59)","v":0},1.8564562686311931E-2,2.1311743089135027E-2,1.9563366741376008E-2,1.4463362315380155E-2,1.63013465464164E-2,8.7652121912220618E-2,0,0,0,null,null,null,{"$f":"SUM(P54:P59)","v":0.36865679423877551},"Initial oil"]
["Cumulative total",null,{"$f":"SUM($C$41:C60)","v":0},{"$f":"SUM($C$60:D60)","v":1.8564562686311931E-2},{"$f":"SUM($C$60:E60)","v":3.9876305775446957E-2},{"$f":"SUM($C$60:F60)","v":5.9439672516822965E-2},{"$f":"SUM($C$60:G60)","v":7.3903034832203118E-2},{"$f":"SUM($C$60:H60)","v":9.0204381378619525E-2},{"$f":"SUM($C$60:I60)","v":0.17785650329084013},{"$f":"SUM($C$60:J60)","v":0.17785650329084013},{"$f":"SUM($C$60:K60)","v":0.17785650329084013},{"$f":"SUM($C$60:L60)","v":0.17785650329084013}]

{"sheet":"CVD analysis","index":11,"n_rows":157,"n_cols":18,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
[]
["temperature (deg R)","Tres",{"$f":"'CCE & other data'!E5+459.67","v":722.67000000000007},"deg R",null,null,null,null,null,null,null,null,null,"UGC",10.731999999999999]
[]
[]
["pressure (psia)","P",{"$f":"'CVD Data'!C10+Pstd","v":5549.7},{"$f":"'CVD Data'!D10+Pstd","v":4514.7},{"$f":"'CVD Data'!E10+Pstd","v":3514.7},{"$f":"'CVD Data'!F10+Pstd","v":2514.6999999999998},{"$f":"'CVD Data'!G10+Pstd","v":1714.7},{"$f":"'CVD Data'!H10+Pstd","v":914.7},{"$f":"'CVD Data'!I10+Pstd","v":16.7},{"$f":"'CVD Data'!J10+14.7","v":14.7},{"$f":"'CVD Data'!K10+14.7","v":14.7},{"$f":"'CVD Data'!L10+14.7","v":14.7}]
[]
["wellstream produced (cum fraction)","Np",{"$f":"'CVD Data'!C12/100","v":0},{"$f":"'CVD Data'!D12/100","v":7.9759999999999998E-2},{"$f":"'CVD Data'!E12/100","v":0.2198},{"$f":"'CVD Data'!F12/100","v":0.39965000000000006},{"$f":"'CVD Data'!G12/100","v":0.56259000000000003},{"$f":"'CVD Data'!H12/100","v":0.73950999999999989},{"$f":"'CVD Data'!I12/100","v":0.93845000000000001},{"$f":"'CVD Data'!J12/100","v":0},{"$f":"'CVD Data'!K12/100","v":0},{"$f":"'CVD Data'!L12/100","v":0}]
["liquid volume (fraction)","SL",{"$f":"'CVD Data'!C13/100","v":0},{"$f":"'CVD Data'!D13/100","v":0.17},{"$f":"'CVD Data'!E13/100","v":0.22841999999999998},{"$f":"'CVD Data'!F13/100","v":0.23832},{"$f":"'CVD Data'!G13/100","v":0.22309000000000001},{"$f":"'CVD Data'!H13/100","v":0.19062999999999999},{"$f":"'CVD Data'!I13/100","v":0.14967},{"$f":"'CVD Data'!J13/100","v":0},{"$f":"'CVD Data'!K13/100","v":0},{"$f":"'CVD Data'!L13/100","v":0}]
["eq gas Z-factor","Z",{"$f":"'CVD Data'!C14","v":1.0823},{"$f":"'CVD Data'!D14","v":0.92020000000000002},{"$f":"'CVD Data'!E14","v":0.85150000000000003},{"$f":"'CVD Data'!F14","v":0.83689999999999998},{"$f":"'CVD Data'!G14","v":0.85680000000000001},{"$f":"'CVD Data'!H14","v":0.90690000000000004},{"$f":"'CVD Data'!I14","v":1},{"$f":"'CVD Data'!J14","v":0},{"$f":"'CVD Data'!K14","v":0},{"$f":"'CVD Data'!L14","v":0}]
[]
[null,"Produced gas phase composition"]
["gas phase composition",{"$f":"'CVD Data'!B17","v":"N2"},{"$f":"'CVD Data'!C17","v":0.39300000000000002},{"$f":"'CVD Data'!D17","v":0.40500000000000003},{"$f":"'CVD Data'!E17","v":0.433},{"$f":"'CVD Data'!F17","v":0.442},{"$f":"'CVD Data'!G17","v":0.437},{"$f":"'CVD Data'!H17","v":0.42799999999999999},{"$f":"'CVD Data'!I17","v":0.33500000000000002},{"$f":"'CVD Data'!J17","v":0},{"$f":"'CVD Data'!K17","v":0},{"$f":"'CVD Data'!L17","v":0}]
[null,{"$f":"'CVD Data'!B18","v":"CO2"},{"$f":"'CVD Data'!C18","v":1.776},{"$f":"'CVD Data'!D18","v":1.829},{"$f":"'CVD Data'!E18","v":1.863},{"$f":"'CVD Data'!F18","v":1.899},{"$f":"'CVD Data'!G18","v":1.9359999999999999},{"$f":"'CVD Data'!H18","v":1.9450000000000001},{"$f":"'CVD Data'!I18","v":1.6120000000000001},{"$f":"'CVD Data'!J18","v":0},{"$f":"'CVD Data'!K18","v":0},{"$f":"'CVD Data'!L18","v":0}]
[null,{"$f":"'CVD Data'!B19","v":"H2S"},{"$f":"'CVD Data'!C19","v":0},{"$f":"'CVD Data'!D19","v":0},{"$f":"'CVD Data'!E19","v":0},{"$f":"'CVD Data'!F19","v":0},{"$f":"'CVD Data'!G19","v":0},{"$f":"'CVD Data'!H19","v":0},{"$f":"'CVD Data'!I19","v":0},{"$f":"'CVD Data'!J19","v":0},{"$f":"'CVD Data'!K19","v":0},{"$f":"'CVD Data'!L19","v":0}]
[null,{"$f":"'CVD Data'!B20","v":"C1"},{"$f":"'CVD Data'!C20","v":68.25},{"$f":"'CVD Data'!D20","v":71.912999999999997},{"$f":"'CVD Data'!E20","v":74.338999999999999},{"$f":"'CVD Data'!F20","v":75.537999999999997},{"$f":"'CVD Data'!G20","v":76.049000000000007},{"$f":"'CVD Data'!H20","v":74.722999999999999},{"$f":"'CVD Data'!I20","v":60.118000000000002},{"$f":"'CVD Data'!J20","v":0},{"$f":"'CVD Data'!K20","v":0},{"$f":"'CVD Data'!L20","v":0}]
[null,{"$f":"'CVD Data'!B21","v":"C2"},{"$f":"'CVD Data'!C21","v":7.024},{"$f":"'CVD Data'!D21","v":7.1779999999999999},{"$f":"'CVD Data'!E21","v":7.2439999999999998},{"$f":"'CVD Data'!F21","v":7.4640000000000004},{"$f":"'CVD Data'!G21","v":7.6210000000000004},{"$f":"'CVD Data'!H21","v":7.6909999999999998},{"$f":"'CVD Data'!I21","v":7.1779999999999999},{"$f":"'CVD Data'!J21","v":0},{"$f":"'CVD Data'!K21","v":0},{"$f":"'CVD Data'!L21","v":0}]
[null,{"$f":"'CVD Data'!B22","v":"C3"},{"$f":"'CVD Data'!C22","v":6.625},{"$f":"'CVD Data'!D22","v":6.5010000000000003},{"$f":"'CVD Data'!E22","v":6.5010000000000003},{"$f":"'CVD Data'!F22","v":6.5010000000000003},{"$f":"'CVD Data'!G22","v":6.5010000000000003},{"$f":"'CVD Data'!H22","v":7.1120000000000001},{"$f":"'CVD Data'!I22","v":8.0909999999999993},{"$f":"'CVD Data'!J22","v":0},{"$f":"'CVD Data'!K22","v":0},{"$f":"'CVD Data'!L22","v":0}]
[null,{"$f":"'CVD Data'!B23","v":"iC4"},{"$f":"'CVD Data'!C23","v":1.4179999999999999},{"$f":"'CVD Data'!D23","v":1.3520000000000001},{"$f":"'CVD Data'!E23","v":1.3120000000000001},{"$f":"'CVD Data'!F23","v":1.3},{"$f":"'CVD Data'!G23","v":1.3240000000000001},{"$f":"'CVD Data'!H23","v":1.462},{"$f":"'CVD Data'!I23","v":1.9910000000000001},{"$f":"'CVD Data'!J23","v":0},{"$f":"'CVD Data'!K23","v":0},{"$f":"'CVD Data'!L23","v":0}]
[null,{"$f":"'CVD Data'!B24","v":"nC4"},{"$f":"'CVD Data'!C24","v":2.319},{"$f":"'CVD Data'!D24","v":2.1779999999999999},{"$f":"'CVD Data'!E24","v":2.113},{"$f":"'CVD Data'!F24","v":2.113},{"$f":"'CVD Data'!G24","v":2.113},{"$f":"'CVD Data'!H24","v":2.36},{"$f":"'CVD Data'!I24","v":3.2429999999999999},{"$f":"'CVD Data'!J24","v":0},{"$f":"'CVD Data'!K24","v":0},{"$f":"'CVD Data'!L24","v":0}]
[null,{"$f":"'CVD Data'!B25","v":"iC5"},{"$f":"'CVD Data'!C25","v":0.85699999999999998},{"$f":"'CVD Data'!D25","v":0.8},{"$f":"'CVD Data'!E25","v":0.76600000000000001},{"$f":"'CVD Data'!F25","v":0.72399999999999998},{"$f":"'CVD Data'!G25","v":0.69},{"$f":"'CVD Data'!H25","v":0.81499999999999995},{"$f":"'CVD Data'!I25","v":1.2130000000000001},{"$f":"'CVD Data'!J25","v":0},{"$f":"'CVD Data'!K25","v":0},{"$f":"'CVD Data'!L25","v":0}]
[null,{"$f":"'CVD Data'!B26","v":"nC5"},{"$f":"'CVD Data'!C26","v":0.84199999999999997},{"$f":"'CVD Data'!D26","v":0.78700000000000003},{"$f":"'CVD Data'!E26","v":0.75700000000000001},{"$f":"'CVD Data'!F26","v":0.71599999999999997},{"$f":"'CVD Data'!G26","v":0.68100000000000005},{"$f":"'CVD Data'!H26","v":0.76200000000000001},{"$f":"'CVD Data'!I26","v":1.151},{"$f":"'CVD Data'!J26","v":0},{"$f":"'CVD Data'!K26","v":0},{"$f":"'CVD Data'!L26","v":0}]
[null,{"$f":"'CVD Data'!B27","v":"C6"},{"$f":"'CVD Data'!C27","v":0.96799999999999997},{"$f":"'CVD Data'!D27","v":0.85699999999999998},{"$f":"'CVD Data'!E27","v":0.77100000000000002},{"$f":"'CVD Data'!F27","v":0.70099999999999996},{"$f":"'CVD Data'!G27","v":0.64700000000000002},{"$f":"'CVD Data'!H27","v":0.70099999999999996},{"$f":"'CVD Data'!I27","v":1.268},{"$f":"'CVD Data'!J27","v":0},{"$f":"'CVD Data'!K27","v":0},{"$f":"'CVD Data'!L27","v":0}]
[null,{"$f":"'CVD Data'!B28","v":"C7"},{"$f":"'CVD Data'!C28","v":0},{"$f":"'CVD Data'!D28","v":0},{"$f":"'CVD Data'!E28","v":0},{"$f":"'CVD Data'!F28","v":0},{"$f":"'CVD Data'!G28","v":0},{"$f":"'CVD Data'!H28","v":0},{"$f":"'CVD Data'!I28","v":0},{"$f":"'CVD Data'!J28","v":0},{"$f":"'CVD Data'!K28","v":0},{"$f":"'CVD Data'!L28","v":0}]
[null,{"$f":"'CVD Data'!B29","v":"C8"},{"$f":"'CVD Data'!C29","v":0},{"$f":"'CVD Data'!D29","v":0},{"$f":"'CVD Data'!E29","v":0},{"$f":"'CVD Data'!F29","v":0},{"$f":"'CVD Data'!G29","v":0},{"$f":"'CVD Data'!H29","v":0},{"$f":"'CVD Data'!I29","v":0},{"$f":"'CVD Data'!J29","v":0},{"$f":"'CVD Data'!K29","v":0},{"$f":"'CVD Data'!L29","v":0}]
[null,{"$f":"'CVD Data'!B30","v":"C9"},{"$f":"'CVD Data'!C30","v":0},{"$f":"'CVD Data'!D30","v":0},{"$f":"'CVD Data'!E30","v":0},{"$f":"'CVD Data'!F30","v":0},{"$f":"'CVD Data'!G30","v":0},{"$f":"'CVD Data'!H30","v":0},{"$f":"'CVD Data'!I30","v":0},{"$f":"'CVD Data'!J30","v":0},{"$f":"'CVD Data'!K30","v":0},{"$f":"'CVD Data'!L30","v":0}]
[null,{"$f":"'CVD Data'!B31","v":"C10"},{"$f":"'CVD Data'!C31","v":0},{"$f":"'CVD Data'!D31","v":0},{"$f":"'CVD Data'!E31","v":0},{"$f":"'CVD Data'!F31","v":0},{"$f":"'CVD Data'!G31","v":0},{"$f":"'CVD Data'!H31","v":0},{"$f":"'CVD Data'!I31","v":0},{"$f":"'CVD Data'!J31","v":0},{"$f":"'CVD Data'!K31","v":0},{"$f":"'CVD Data'!L31","v":0}]
[null,{"$f":"'CVD Data'!B32","v":"C11"},{"$f":"'CVD Data'!C32","v":0},{"$f":"'CVD Data'!D32","v":0},{"$f":"'CVD Data'!E32","v":0},{"$f":"'CVD Data'!F32","v":0},{"$f":"'CVD Data'!G32","v":0},{"$f":"'CVD Data'!H32","v":0},{"$f":"'CVD Data'!I32","v":0},{"$f":"'CVD Data'!J32","v":0},{"$f":"'CVD Data'!K32","v":0},{"$f":"'CVD Data'!L32","v":0}]
[null,{"$f":"'CVD Data'!B33","v":"C7+"},{"$f":"'CVD Data'!C33","v":9.5289999999999999},{"$f":"'CVD Data'!D33","v":6.2},{"$f":"'CVD Data'!E33","v":3.9},{"$f":"'CVD Data'!F33","v":2.6},{"$f":"'CVD Data'!G33","v":2},{"$f":"'CVD Data'!H33","v":2},{"$f":"'CVD Data'!I33","v":13.8},{"$f":"'CVD Data'!J33","v":0},{"$f":"'CVD Data'!K33","v":0},{"$f":"'CVD Data'!L33","v":0}]
[]
[null,"MW_plus",{"$f":"'CVD Data'!C35","v":169.53},{"$f":"'CVD Data'!D35","v":149.703},{"$f":"'CVD Data'!E35","v":136.501},{"$f":"'CVD Data'!F35","v":126.627},{"$f":"'CVD Data'!G35","v":120.849},{"$f":"'CVD Data'!H35","v":116.4},{"$f":"'CVD Data'!I35","v":131.53700000000001},{"$f":"'CVD Data'!J35","v":0},{"$f":"'CVD Data'!K35","v":0},{"$f":"'CVD Data'!L35","v":0}]
[]
[null,"MW_gas",{"$f":"(SUMPRODUCT(C12:C27,Mwref)+C28*C30)/100","v":37.258500190000007},30.694675650000004,26.987104090000003,25.105527559999999,24.29189641,24.701027440000008,40.164326849999995,0,0,0]
[]
[]
["vol of 1 lb mole (ft3)","V",{"$f":"Z*UGC*Tres/P","v":1.5125120443288829},{"$f":"Z*UGC*Tres/P","v":1.580789426470862},1.8789580378581388,2.5811192893132384,3.8753595358908264,7.6895586395933098,464.4128407185629,0,0,0,null,"Vcell",{"$f":"C35","v":1.5125120443288829}]
["Gas density (lb/ft3)","gas density (lb/ft3)",{"$f":"MW_gas/C35","v":24.63352297239523},19.417308299263087,14.362802971780644,9.7266049128166632,6.2682948988411828,3.2122815622752583,{"$f":"MW_gas/I35","v":8.6484100628776178E-2},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Init mass",{"$f":"C32","v":37.258500190000007}]
["Gas density (Kg/m3)","gas density (kg/m3)",{"$f":"C36*16.018","v":394.5797709718268},311.02644433759616,230.06337800198236,155.80075749349731,100.40554768963807,51.454326064525091,1.3853023238717368,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Lb Moles gas produced","Ngas_p",0,{"$f":"Np-C7","v":7.9759999999999998E-2},0.14004,0.17985000000000007,0.16293999999999997,0.17691999999999986,0.19894000000000012,-0.93845000000000001,0,0]
["Vol of gas in cell","Vgas",{"$f":"(1-SL)*Vcell","v":1.5125120443288829},{"$f":"(1-SL)*Vcell","v":1.2553849967929727},1.1670240431632795,1.1520501739244235,1.1750857323595523,1.224181873318468,1.2861343666541789,1.5125120443288829,1.5125120443288829,1.5125120443288829]
["Lb moles of gas in cell","Ngas",{"$f":"Vgas/V","v":1},0.79415067925627514,0.62110170618477101,0.44633743922426422,0.30321979715088193,0.15920053811868887,2.7693772736003749E-3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Lb moles of liquid","Nliq",{"$f":"1-Ngas-Np","v":0},0.12608932074372486,0.159098293815229,0.15401256077573566,0.13419020284911809,0.10128946188131127,5.8780622726399612E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Mass removed","Mgas_p",{"$f":"Ngas_p*MW_gas","v":0},{"$f":"Ngas_p*MW_gas","v":2.4482073298440001},3.7792740567636005,4.5152291316660014,3.9581216010453995,4.3701057746847978,7.9902911835390036,0,0,0]
["Mass of gas in cell","Mgas",{"$f":"Ngas*MW_gas","v":37.258500190000007},{"$f":"Ngas*MW_gas","v":24.376197516998552},16.761736395285013,11.205536881504591,7.3657839018504365,3.9324168605325007,0.11123017398784732,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Mass of liquid","Mliq",{"$f":"Init_mass-Mgas-SUM($C$44:C44)","v":0},{"$f":"Init_mass-Mgas-SUM($C$44:D44)","v":10.434095343157455},{"$f":"Init_mass-Mgas-SUM($C$44:E44)","v":14.269282408107394},{"$f":"Init_mass-Mgas-SUM($C$44:F44)","v":15.310252790221814},{"$f":"Init_mass-Mgas-SUM($C$44:G44)","v":15.191884168830573},{"$f":"Init_mass-Mgas-SUM($C$44:H44)","v":14.25514543546371},{"$f":"Init_mass-Mgas-SUM($C$44:I44)","v":10.086040938469356},{"$f":"Init_mass-Mgas-SUM($C$44:J44)","v":{"$error":"#DIV/0!"}},{"$f":"Init_mass-Mgas-SUM($C$44:K44)","v":{"$error":"#DIV/0!"}},{"$f":"Init_mass-Mgas-SUM($C$44:L44)","v":{"$error":"#DIV/0!"}}]
["MW of liquid",null,null,{"$f":"Mliq/Nliq","v":82.751618310044179},{"$f":"Mliq/Nliq","v":89.688469096213069},99.409117757062248,113.21157466251206,140.73670815003018,171.58785447741613,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Liquid density (lb/ft3)","liquid density (lb/ft3)",null,{"$f":"Mliq/Vcell/SL","v":40.579532348498809},{"$f":"Mliq/Vcell/SL","v":41.301817602828038},42.473986979656992,45.022820183066813,49.440353000549472,44.554043676349629,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Liquid density (Kg/m3)","liquid density (kg/m3)",null,{"$f":"D49*16.018","v":650.00294915825395},661.57251436209958,680.34832344014569,721.17553369236418,791.9355743628015,713.66667160776842,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["moles of each component",{"$f":"B12","v":"N2"},0.39300000000000002,{"$f":"C53-D12*Ngas_p","v":0.3606972},0.30005988,0.22056617999999997,0.14936139999999998,7.3639640000000048E-2,6.9947399999999993E-3,6.9947399999999993E-3,6.9947399999999993E-3,6.9947399999999993E-3]
["remaining in cell","CO2",1.776,{"$f":"C54-D13*Ngas_p","v":1.6301189600000001},1.36922444,1.0276892899999999,0.71223744999999994,0.36812805000000021,4.7436770000000017E-2,4.7436770000000017E-2,4.7436770000000017E-2,4.7436770000000017E-2]
["(after extra gas has been removed)","H2S",0,{"$f":"C55-D14*Ngas_p","v":0},0,0,0,0,0,0,0,0]
[null,"C1",68.25,{"$f":"C56-D15*Ngas_p","v":62.51421912},52.103785559999999,38.518276259999993,26.126852199999995,12.906859040000006,0.94698411999999799,0.94698411999999799,0.94698411999999799,0.94698411999999799]
[null,"C2",7.024,{"$f":"C57-D16*Ngas_p","v":6.4514827199999996},5.4370329599999998,4.0946325599999991,2.8528668199999991,1.4921751000000003,6.418377999999958E-2,6.418377999999958E-2,6.418377999999958E-2,6.418377999999958E-2]
[null,"C3",6.625,{"$f":"C58-D17*Ngas_p","v":6.1064802399999998},5.1960801999999999,4.0268753499999992,2.9676024099999996,1.7093473700000006,9.9723829999999847E-2,9.9723829999999847E-2,9.9723829999999847E-2,9.9723829999999847E-2]
[null,"iC4",1.4179999999999999,{"$f":"C59-D18*Ngas_p","v":1.3101644799999999},1.1264319999999999,0.89262699999999984,0.67689443999999988,0.41823740000000009,2.2147859999999853E-2,2.2147859999999853E-2,2.2147859999999853E-2,2.2147859999999853E-2]
[null,"nC4",2.319,{"$f":"C60-D19*Ngas_p","v":2.14528272},1.8493781999999999,1.4693551499999997,1.1250629299999999,0.70753173000000025,6.23693099999999E-2,6.23693099999999E-2,6.23693099999999E-2,6.23693099999999E-2]
[null,"iC5",0.85699999999999998,{"$f":"C61-D20*Ngas_p","v":0.79319200000000001},0.68592136000000004,0.55570995999999995,0.44328135999999996,0.29909156000000009,5.7777339999999927E-2,5.7777339999999927E-2,5.7777339999999927E-2,5.7777339999999927E-2]
[null,"nC5",0.84199999999999997,{"$f":"C62-D21*Ngas_p","v":0.77922888000000001},0.6732186,0.54444599999999999,0.43348386,0.29867082000000011,6.9690879999999983E-2,6.9690879999999983E-2,6.9690879999999983E-2,6.9690879999999983E-2]
[null,"C6",0.96799999999999997,{"$f":"C63-D22*Ngas_p","v":0.89964568},0.79167483999999999,0.66559998999999992,0.56017780999999989,0.43615689000000002,0.18390096999999989,0.18390096999999989,0.18390096999999989,0.18390096999999989]
[null,{"$f":"B23","v":"C7"},0,{"$f":"C64-D23*Ngas_p","v":0},0,0,0,0,0,0,0,0]
[null,"C8",0,{"$f":"C65-D24*Ngas_p","v":0},0,0,0,0,0,0,0,0]
[null,"C9",0,{"$f":"C66-D25*Ngas_p","v":0},0,0,0,0,0,0,0,0]
[null,"C10",0,{"$f":"C67-D26*Ngas_p","v":0},0,0,0,0,0,0,0,0]
[null,"C11",0,{"$f":"C68-D27*Ngas_p","v":0},0,0,0,0,0,0,0,0]
[null,"C7+",{"$f":"C28","v":9.5289999999999999},{"$f":"C69-D28*Ngas_p","v":9.0344879999999996},8.4883319999999998,8.0207219999999992,7.6948419999999995,7.3410019999999996,4.5956299999999981,4.5956299999999981,4.5956299999999981,4.5956299999999981]
[]
[null,"Total",{"$f":"SUM(C53:C69)","v":100.001},92.025000000000006,78.021140039999992,60.036499739999982,43.742662679999995,26.050839600000007,6.1568395999999952,6.1568395999999952,6.1568395999999952,6.1568395999999952]
[]
["moles of liquid in cell",{"$f":"B12","v":"N2"},{"$f":"C53-Ngas*C12","v":0},3.9066174901208561E-2,3.1122841221994157E-2,2.3285031862875172E-2,1.6854348645064576E-2,5.5018096852012116E-3,{"$f":"I53-Ngas*I12","v":6.0669986133438736E-3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CO2",{"$f":"C54-Ngas*C13","v":0},0.17761736764027303,0.21211196137777155,0.18009449291312207,0.12520392271589253,5.8483003359150354E-2,4.2972533834956209E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"H2S",{"$f":"C55-Ngas*C14","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C1",{"$f":"C56-Ngas*C15","v":0},5.4044613226434919,5.931705823930308,4.8028387758775253,3.0672898464725726,1.0109172301572187,0.78049469706569063,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C2",{"$f":"C57-Ngas*C16","v":0},0.75106914429845695,0.93777220039751885,0.76316991363009068,0.54202874591312789,0.26776376132916435,4.4305189930096092E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C3",{"$f":"C58-Ngas*C17","v":0},0.94370667415495468,1.1582980080928031,1.1252356576030573,0.99637050872211597,0.57711314289988525,7.7316798479299217E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"iC4",{"$f":"C59-Ngas*C18","v":0},0.23647276164551578,0.31154656148558024,0.31238832900845637,0.27543142857223218,0.18548621327047699,1.6634029848261504E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"nC4",{"$f":"C60-Ngas*C19","v":0},0.41562254057983283,0.53699029483157878,0.52624414091912941,0.48435949862018635,0.33181846003989451,5.3388219501713886E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"iC5",{"$f":"C61-Ngas*C20","v":0},0.15787145659497981,0.21015745306246542,0.23256165400163265,0.23405969996589143,0.16934312143326868,5.4418085367122671E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"nC5",{"$f":"C62-Ngas*C21","v":0},0.15423229542531147,0.20304460841812833,0.22486839351542681,0.22699117814024938,0.17736000995355922,6.6503326758085957E-2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C6",{"$f":"C63-Ngas*C22","v":0},0.21905854787737222,0.31280542453154153,0.35271744510379072,0.36399460124337923,0.32455731277879912,0.18038939961707462,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C7",{"$f":"C64-Ngas*C23","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C8",{"$f":"C65-Ngas*C24","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C9",{"$f":"C66-Ngas*C25","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C10",{"$f":"C67-Ngas*C26","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C11",{"$f":"C68-Ngas*C27","v":0},0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C7+",{"$f":"C69-Ngas*C28","v":0},4.1107537886110936,6.066035345879393,6.8602446580169119,7.0884024056982353,7.0226009237626217,{"$f":"I69-Ngas*I28","v":4.5574125936243126},{"$f":"J69-Ngas*J28","v":{"$error":"#DIV/0!"}},{"$f":"K69-Ngas*K28","v":{"$error":"#DIV/0!"}},{"$f":"L69-Ngas*L28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Measured"]
[null,"Total",{"$f":"SUM(C73:C89)","v":0},12.609932074372491,15.91159052322908,15.403648492452017,13.420986184708948,10.13094498866924,5.879901872639957,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"liquid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"composition"]
["MW of C7+ fraction in liquid",null,null,{"$f":"(Mliq*100-SUMPRODUCT(D73:D83,Mwref))/D89","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N35","v":189.3}]
[]
[null,"Calculated liquid phase composition (mol %)"]
[null,{"$f":"B12","v":"N2"},null,{"$f":"100*D73/D$91","v":0.30980480046045461},0.19559855550932143,0.15116569216887243,0.1255820430265206,5.4306974239368623E-2,0.10318197046067223,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N17","v":0}]
[null,"CO2",null,{"$f":"100*D74/D$91","v":1.408551343438635},1.3330657363769678,1.1691677656846731,0.93289659189532759,0.57727095966427155,0.73083760181294333,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N18","v":0}]
[null,"H2S",null,{"$f":"100*D75/D$91","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N19","v":0}]
[null,"C1",null,{"$f":"100*D76/D$91","v":42.858766334095698},37.279150788041612,31.179877794737894,22.854429654113314,9.9785087303095565,13.273940857711361,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N20","v":2E-3}]
[null,"C2",null,{"$f":"100*D77/D$91","v":5.9561712138392497},5.8936421159687331,4.9544749998940416,4.0386655529880686,2.6430284798569095,0.75350219935224794,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N21","v":8.0000000000000002E-3}]
[null,"C3",null,{"$f":"100*D78/D$91","v":7.4838363013300873},7.2795865781099769,7.3049943859367925,7.4239738794852483,5.696538117079367,1.3149334828029289,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N22","v":0.154}]
[null,"iC4",null,{"$f":"100*D79/D$91","v":1.8752897339241488},1.9579850363215314,2.0280151755055345,2.0522443342206995,1.8308875773970785,0.28289638515333182,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N23","v":0.188}]
[null,"nC4",null,{"$f":"100*D80/D$91","v":3.2959934924987726},3.3748373177881565,3.4163603588915685,3.6089709947845408,3.2752962375277965,0.90797806933032466,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N24","v":0.60799999999999998}]
[null,"iC5",null,{"$f":"100*D81/D$91","v":1.2519611974423421},1.3207821855122519,1.5097829200373587,1.7439828694001991,1.6715431938744827,0.92549308722885293,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N25","v":0.83899999999999997}]
[null,"nC5",null,{"$f":"100*D82/D$91","v":1.2231017147091694},1.2760798998799443,1.4598385156972076,1.6913151911211208,1.750675876257586,1.1310278334326573,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N26","v":1.099}]
[null,"C6",null,{"$f":"100*D83/D$91","v":1.7371905461931147},1.9658966466921195,2.2898305247398154,2.7121300643174227,3.2036232862955427,3.0678981303489583,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N27","v":3.234}]
[null,"C7",null,{"$f":"100*D84/D$91","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N28","v":0}]
[null,"C8",null,{"$f":"100*D85/D$91","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N29","v":0}]
[null,"C9",null,{"$f":"100*D86/D$91","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N30","v":0}]
[null,"C10",null,{"$f":"100*D87/D$91","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N31","v":0}]
[null,"C11",null,{"$f":"100*D88/D$91","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N32","v":0}]
[null,"C7+",null,{"$f":"100*D89/D$91","v":32.599333322068333},38.123375139799407,44.53649186670625,52.81580882464754,69.318320567498034,77.508310382365721,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'CVD Data'!N33","v":93.867000000000004}]
[]
[null,"K-values"]
[null,{"$f":"B12","v":"N2"},null,{"$f":"D12/D96","v":1.3072747723665332},2.2137177796252439,2.9239438768039143,3.4797968679942062,7.8811240359940911,3.2466912436769673,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CO2",null,{"$f":"D13/D97","v":1.2984972173857305},1.3975304811773934,1.6242322579667872,2.0752568042581316,3.3693016553806387,2.2056883718095674,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"H2S",null,{"$f":"D14/D98","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C1",null,{"$f":"D15/D99","v":1.6779064390099023},1.994117312990038,2.4226522149085601,3.3275387376080414,7.4883935084438127,4.5290242471643269,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C2",null,{"$f":"D16/D100","v":1.205136612480483},1.229121120261526,1.5065168358220857,1.8870094341833992,2.9099194574007701,9.526183209777761,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C3",null,{"$f":"D17/D101","v":0.86867212726774778},0.89304522039050693,0.88993908229627094,0.87567657234951857,1.2484775584449779,6.1531629590518309,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"iC4",null,{"$f":"D18/D102","v":0.72095526122828202},0.67007662247759348,0.64102084427250006,0.64514735303326531,0.79851980976269676,7.037912481352012,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"nC4",null,{"$f":"D19/D103","v":0.66080227553750581},0.62610425363698552,0.61849447307296312,0.58548544808300629,0.72054551065015571,3.5716721686811894,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"iC5",null,{"$f":"D20/D104","v":0.63899743988418878},0.57995936680726412,0.47953913797228875,0.39564608810481539,0.48757340102645225,1.3106526852966687,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"nC5",null,{"$f":"D21/D105","v":0.64344607691694211},0.5932230419672152,0.49046520714521902,0.40264523346981002,0.43526046730530432,1.0176584218150737,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C6",null,{"$f":"D22/D106","v":0.49332527273880961},0.39218745364732638,0.3061361932362448,0.23855788057968164,0.21881474110852459,0.41331228943243015,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C7",null,{"$f":"D23/D107","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C8",null,{"$f":"D24/D108","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C9",null,{"$f":"D25/D109","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C10",null,{"$f":"D26/D110","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C11",null,{"$f":"D27/D111","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"C7+",null,{"$f":"D28/D112","v":0.19018793846936954},0.10229944189617521,5.8379092986972761E-2,3.7867450002330751E-2,2.8852401264576506E-2,0.17804542418640704,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["Backward material balance calculation"]
["Calculate original gas composition from residual liquid and produced gas compositions"]
[null,null,null,{"$f":"D5","v":4514.7},{"$f":"E5","v":3514.7},2514.6999999999998,1714.7,914.7,16.7,14.7,14.7,14.7,null,"Residual gas","Residual liquid",null,"Moles of residual liquid"]
[]
[null,{"$f":"B96","v":"N2"},{"$f":"SUM(D138:O138)","v":0.38686513036208942},{"$f":"Ngas_p*D12","v":3.23028E-2},6.0637320000000001E-2,7.9493700000000028E-2,7.1204779999999995E-2,7.572175999999993E-2,6.6644900000000049E-2,0,0,0,null,{"$f":"INDEX(C12:L12,N_pres)*Moles_resid_gas","v":8.5987036208942278E-4},{"$f":"'CVD Data'!N17*Moles_resid_liq","v":0},null,"Gas molar vol",{"$f":"INDEX(Z,N_pres)*UGC*Tres/INDEX(P,N_pres)","v":464.4128407185629}]
[null,"CO2",1.7327008748468302,{"$f":"Ngas_p*D13","v":0.14588103999999999},0.26089452000000002,0.34153515000000012,0.31545183999999993,0.34410939999999973,0.32069128000000019,0,0,0,null,4.1376448468302971E-3,{"$f":"'CVD Data'!N18*Moles_resid_liq","v":0},null,"Liq molar vol",{"$f":"Residual_liq_MW/Residual_liquid_density","v":3.557223485752663}]
[null,"H2S",0,{"$f":"Ngas_p*D14","v":0},0,0,0,0,0,0,0,0,null,0,{"$f":"'CVD Data'!N19*Moles_resid_liq","v":0},null,"Total moles",{"$f":"1-INDEX(Np,N_pres)","v":6.1549999999999994E-2}]
[null,"C1",67.457443358171233,{"$f":"Ngas_p*D15","v":5.7357808799999992},10.41043356,13.585509300000004,12.391424059999999,13.219993159999989,11.959874920000008,0,0,0,null,0.1543095117256475,{"$f":"'CVD Data'!N20*Moles_resid_liq","v":1.1796644559946613E-4},null,"Liq sat",{"$f":"INDEX(SL,N_pres)","v":0.14967}]
[null,"C2",6.9787124125259128,{"$f":"Ngas_p*D16","v":0.57251728000000002},1.01444976,1.3424004000000005,1.24176574,1.3606917199999988,1.4279913200000007,0,0,0,null,1.8424326743516049E-2,{"$f":"'CVD Data'!N21*Moles_resid_liq","v":4.7186578239786451E-4},null,"Liq mole frac",{"$f":"1/(1+Liq_molar_vol/Gas_molar_vol*(1/Liq_sat-1))","v":0.95829768967884754}]
[null,"C3",6.5551273806385186,{"$f":"Ngas_p*D17","v":0.51851976},0.91040004000000008,1.1692048500000005,1.0592729399999998,1.258255039999999,1.6096235400000007,0,0,0,null,2.0767794327359757E-2,{"$f":"'CVD Data'!N22*Moles_resid_liq","v":9.0834163111588907E-3}]
[null,"iC4",1.4120514392920815,{"$f":"Ngas_p*D18","v":0.10783552},0.18373248,0.2338050000000001,0.21573255999999996,0.25865703999999978,0.39608954000000024,0,0,0,null,5.110453405731465E-3,{"$f":"'CVD Data'!N23*Moles_resid_liq","v":1.1088845886349815E-2},null,"Moles resid liq",{"$f":"(1-INDEX(Np,N_pres))*R142","v":5.8983222799733059E-2}]
[null,"nC4",2.3008165479227034,{"$f":"Ngas_p*D19","v":0.17371728},0.29590452,0.38002305000000014,0.34429221999999993,0.41753119999999966,0.64516242000000035,0,0,0,null,8.3240584604656644E-3,{"$f":"'CVD Data'!N24*Moles_resid_liq","v":3.5861799462237699E-2},null,"Moles_resid_gas",{"$f":"(1-INDEX(Np,N_pres))*(1-R142)","v":2.5667772002669334E-3}]
[null,"iC5",0.8518230846728998,{"$f":"Ngas_p*D20","v":6.3808000000000004E-2},0.10727064,0.13021140000000003,0.11242859999999998,0.14418979999999987,0.24131422000000016,0,0,0,null,3.1135007439237906E-3,{"$f":"'CVD Data'!N25*Moles_resid_liq","v":4.9486923928976037E-2}]
[null,"nC5",0.84008604241441387,{"$f":"Ngas_p*D21","v":6.277112E-2},0.10601028,0.12877260000000004,0.11096213999999999,0.13481303999999988,0.22897994000000013,0,0,0,null,2.9543605575072405E-3,{"$f":"'CVD Data'!N26*Moles_resid_liq","v":6.482256185690663E-2}]
[null,"C6",0.97810544602427529,{"$f":"Ngas_p*D22","v":6.8354319999999996E-2},0.10797084,0.12607485000000004,0.10542217999999999,0.1240209199999999,0.25225592000000013,0,0,0,null,3.2546734899384718E-3,{"$f":"'CVD Data'!N27*Moles_resid_liq","v":0.19075174253433672}]
[null,null,{"$f":"SUM(D149:O149)","v":0},{"$f":"Ngas_p*D23","v":0},0,0,0,0,0,0,0,0,null,0,{"$f":"'CVD Data'!N28*Moles_resid_liq","v":0}]
[null,null,{"$f":"SUM(D150:O150)","v":0},{"$f":"Ngas_p*D24","v":0},0,0,0,0,0,0,0,0,null,0,{"$f":"'CVD Data'!N29*Moles_resid_liq","v":0}]
[null,null,{"$f":"SUM(D151:O151)","v":0},{"$f":"Ngas_p*D25","v":0},0,0,0,0,0,0,0,0,null,0,{"$f":"'CVD Data'!N30*Moles_resid_liq","v":0}]
[null,null,{"$f":"SUM(D152:O152)","v":0},{"$f":"Ngas_p*D26","v":0},0,0,0,0,0,0,0,0,null,0,{"$f":"'CVD Data'!N31*Moles_resid_liq","v":0}]
[null,null,{"$f":"SUM(D153:O153)","v":0},{"$f":"Ngas_p*D27","v":0},0,0,0,0,0,0,0,0,null,0,{"$f":"'CVD Data'!N32*Moles_resid_liq","v":0}]
[null,{"$f":"B112","v":"C7+"},10.505369699906229,{"$f":"Ngas_p*D28","v":0.49451200000000001},0.54615599999999997,0.46761000000000019,0.32587999999999995,0.35383999999999971,2.7453720000000019,0,0,0,null,3.5421525363683683E-2,{"$f":"'CVD Data'!N33*Moles_resid_liq","v":5.5365781745425435}]
[]
[]
[null,null,{"$f":"SUM(D157:O157)","v":99.999101416777194},{"$f":"SUM(D138:D154)","v":7.9759999999999991},{"$f":"SUM(E138:E154)","v":14.00385996},{"$f":"SUM(F138:F154)","v":17.984640300000009},16.293837059999998,17.691823079999981,19.894000000000013,0,0,0,null,0.25667772002669337,5.8982632967505069]