{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Input","Calcs-SI","z-dzdp","z-viscosity","Bg-cg","pseudopressure","z"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"z-dzdp","index":2,"reason":"not_a_worksheet"},{"sheet":"z-viscosity","index":3,"reason":"not_a_worksheet"},{"sheet":"Bg-cg","index":4,"reason":"not_a_worksheet"},{"sheet":"pseudopressure","index":5,"reason":"not_a_worksheet"},{"sheet":"z","index":6,"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":"Input","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Gas PVT Properties"]
[]
["Gas Z-factor calculted from Hall-Yarborough approximation to Standing-Katz chart"]
["Gas viscosities calculated from Lee-Gonzales correlation"]
[]
["Curtis H. Whitson"]
["Sheet 1 - Average Gas Properties"]
[]
[]
["red","Input (different for each application of spreadsheet)"]
["pink","Optional Input (different for each application of spreadsheet)"]
["green","Input (same for each application of spreadsheet)"]
["blue","Important Calculated Results"]
["purple","Linked to another cell"]
[]
["Temperature",null,{"$f":"(220-32)*5/9","v":104.44444444444444},"C"]
["Input Specific Gravity",null,0]
["Specific Gravity",null,{"$f":"IF(C17=0,$C$38/28.97,C17)","v":0.75210327925440101},"air=1","Sutton Correlations:"]
["Tpc",null,{"$f":"IF(C17=0,$E$38,E19)","v":214.1842746034545},"K",{"$f":"(1/1.8)*(169.2+349.5*$C$18-74*$C$18^2)","v":216.77850263454812},"K"]
["Ppc",null,{"$f":"IF(C17=0,$F$38,E20)","v":45.697317728749852},"bara",{"$f":"(1/14.50377)*(756.8-131*$C$18-3.6*$C$18^2)","v":45.246035808902},"bara"]
[]
[]
["Comp.","yi","Mi","SGi","Tci","Pci"]
[null,"mol-%","kg/kmol","water=1","K","bara"]
[]
["N2",3.35,28.01,469.5,126.3,33.99]
["CO2",{"$f":"1.76+0.51","v":2.27},44.01,499.5,304.2,73.819999999999993]
["C1",83.27,16.04,329.7,190.6,46.04]
["C2",5.16,30.07,449.6,305.39999999999998,48.8]
["C3",1.91,44.1,507.2,369.8,42.49]
["iC4",0.41,58.12,560.70000000000005,408.2,36.479999999999997]
["nC4",0.7,58.12,583.79999999999995,425.2,37.97]
["iC5",0.28000000000000003,72.150000000000006,626.79999999999995,460.4,33.81]
["nC5",0.28000000000000003,72.150000000000006,629.5,469.7,33.69]
["C6",0.39,82.32,659.7,507.4,30.12]
["C7+",1.98,137.9,780,{"$f":"(1/1.8)*(608+364*LOG(C36-71.2)+(2450*LOG(C36)-3800)*LOG(D36/1000))","v":620.21639411386468},{"$f":"(1/14.50377)*(1188-431*LOG(C36-61.1)+(2319-852*LOG(C36-53.7))*(D36/1000-0.8))","v":24.947764078275668}]
[]
["Total",{"$f":"SUM(B26:B36)","v":100},{"$f":"SUMPRODUCT($B26:$B36,C26:C36)/SUM($B26:$B36)","v":21.788431999999997},null,{"$f":"SUMPRODUCT($B26:$B36,E26:E36)/SUM($B26:$B36)","v":214.1842746034545},{"$f":"SUMPRODUCT($B26:$B36,F26:F36)/SUM($B26:$B36)","v":45.697317728749852}]

{"sheet":"Calcs-SI","index":1,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Gas PVT Properties"]
[]
["© Curtis H. Whitson"]
["Sheet 2 - Gas PVT f(p)"]
[]
[]
["Gravity",{"$f":"Input!$C$18","v":0.75210327925440101},"(air=1)",null,null,"Lee et al."]
["Tpc",{"$f":"Input!$C$19","v":214.1842746034545},"K",null,null,"A1",{"$f":"0.0001*(9.379+0.46555*$B$7)*($B$10*1.8)^1.5/(209.2+558*$B$7+$B$10*1.8)","v":1.3174479675108829E-2}]
["Ppc",{"$f":"Input!$C$20","v":45.697317728749852},"bara",null,null,"A2",{"$f":"3.448+(986.4/(1.8*$B$10))+0.29231*$B$7","v":5.1191398485851458}]
["TR",{"$f":"Input!C16+273.15","v":377.59444444444443},"K",null,null,"A3",{"$f":"2.447-0.2224*G9","v":1.3085032976746638}]
["Tpr",{"$f":"$B$10/$B$8","v":1.762941958010368}]
[]
[]
[]
[null,null,null,null,null,null,"Lee et al."]
[null,null,null,null,"Inverse","Density","Viscosity",null,null,null,null,"Delta pp"]
["p","ppr","Z","Bg","bg=1/Bg","dg","ug","ugZ","p/Z","p/uZ","1/ugBg","2(p/uZ)dp","pp","cg","dZ/dp"]
["bara",null,null,"m3/Sm3","Sm3/m3","g/cm3","mPa-s","mPa-s","bara","bara/mPa-s","1/mPa-s","bar2/mPa-s","bar2/mPa-s","1/bar","1/bar"]
[]
[1000,{"$f":"A20/$B$9","v":21.883122461055596},{"$f":"Zfac($B$11,B20)","v":1.8283014895368375},{"$f":"(1.0135/(273.15+15.56))*(C20*$B$10/A20)","v":2.4234570945553106E-3},{"$f":"1/D20","v":412.63367205743486},{"$f":"deng_kgm3(A20,Input!$C$16,$B$7*28.97,C20)/1000","v":0.37960058901557969},{"$f":"visg_cp(F20*1000,Input!$C$16,$B$7*28.97)","v":5.5677172539106486E-2},{"$f":"G20*C20","v":0.10179465748644789},{"$f":"A20/C20","v":546.95574319820162},{"$f":"I20/G20","v":9823.6982636650828},{"$f":"1/G20/D20","v":7411.1822357288274},{"$f":"2*0.5*(J20+J21)*(A20-A21)","v":989256.7311832105},{"$f":"M21+L20","v":20175558.934770338},{"$f":"cg(A20,C20,O20)","v":3.0952178772987026E-4},{"$f":"dzdp($B$11,B20,$B$9,C20)","v":1.262402343986211E-3}]
[950,20.788966338002815,{"$f":"Zfac($B$11,B21)","v":1.7650310900097412},{"$f":"(1.0135/(273.15+15.56))*(C21*$B$10/A21)","v":2.4627270269985085E-3},406.05393494169243,{"$f":"deng_kgm3(A21,Input!$C$16,$B$7*28.97,C21)/1000","v":0.37354758788203218},{"$f":"visg_cp(F21*1000,Input!$C$16,$B$7*28.97)","v":5.4031780735060805E-2},{"$f":"G21*C21","v":9.5367772845971713E-2},{"$f":"A21/C21","v":538.23414520973506},{"$f":"I21/G21","v":9961.4363599991266},{"$f":"1/G21/D21","v":7515.0944391919174},{"$f":"2*0.5*(J21+J22)*(A21-A22)","v":1003347.5783294498},19186302.203587126,{"$f":"cg(A21,C21,O21)","v":3.3401051918513264E-4},{"$f":"dzdp($B$11,B21,$B$9,C21)","v":1.2683885124160944E-3}]
[900,19.694810214950039,1.701466200378893,2.505926559008287E-3,399.05399318475918,{"$f":"deng_kgm3(A22,Input!$C$16,$B$7*28.97,C22)/1000","v":0.3671080212786631},{"$f":"visg_cp(F22*1000,Input!$C$16,$B$7*28.97)","v":5.2343254664892244E-2},8.9060278630138975E-2,528.95555597847465,10105.515206589869,7623.7902235837346,1018089.2786684119,18182954.625257675,3.6225143859675761E-4,1.2741594216099791E-3]
[850,18.600654091897258,1.637621410345431,2.5537719010913932E-3,391.57765013102181,{"$f":"deng_kgm3(A23,Input!$C$16,$B$7*28.97,C23)/1000","v":0.36023019133150791},{"$f":"visg_cp(F23*1000,Input!$C$16,$B$7*28.97)","v":5.0607625085872007E-2},8.2876130367358525E-2,519.04548550125855,10256.270366778366,7737.5227441830193,1033512.5987037463,17164865.346589264,3.9512270698975843E-4,1.2795520192557283E-3]
[800,17.506497968844478,1.5735211798158815,2.6071746703711578E-3,383.55696354538452,{"$f":"deng_kgm3(A24,Input!$C$16,$B$7*28.97,C24)/1000","v":0.35285159487078699},{"$f":"visg_cp(F24*1000,Input!$C$16,$B$7*28.97)","v":4.8820316177035944E-2},7.6819801509873956E-2,508.41387473005506,10413.98160729656,7856.5030622600043,1049639.7573488906,16131352.747885518,4.3378589294660046E-4,1.2843301847130315E-3]
[750,16.412341845791698,1.5092043005718478,2.6673149115253639E-3,374.90886272147281,{"$f":"deng_kgm3(A25,Input!$C$16,$B$7*28.97,C25)/1000","v":0.34489581135400688},{"$f":"visg_cp(F25*1000,Input!$C$16,$B$7*28.97)","v":4.6976025203997254E-2},7.0896419261644167E-2,496.95061146845387,10578.813539681252,7980.8553638457115,1066476.3949655956,15081712.990536626,4.7980502144050403E-4,1.2881485989684875E-3]
[700,15.318185722738917,1.4447306944194036,2.7357498367823444E-3,365.53049791137016,{"$f":"deng_kgm3(A26,Input!$C$16,$B$7*28.97,C26)/1000","v":0.3362682245936553},{"$f":"visg_cp(F26*1000,Input!$C$16,$B$7*28.97)","v":4.5068574024215331E-2},6.5111952246496907E-2,484.51936593020901,10750.714359630658,8110.5405668031726,1083997.7616441592,14015236.59557103,5.3532841460037785E-4,1.2904955998596771E-3]
[650,14.224029599686137,1.3801918830108026,2.8145802411290561E-3,355.29276635540316,{"$f":"deng_kgm3(A27,Input!$C$16,$B$7*28.97,C27)/1000","v":0.32685006705587799},{"$f":"visg_cp(F27*1000,Input!$C$16,$B$7*28.97)","v":4.3090733821263001E-2},5.9473481053086259E-2,470.94900933779257,10929.240873252525,8245.2243173469687,1102124.5838953673,12931238.833926871,6.0337360207809846E-4,1.2906007796977456E-3]
[600,13.129873476633358,1.3157273290361611,2.9067130961906817E-3,344.03120187903113,{"$f":"deng_kgm3(A28,Input!$C$16,$B$7*28.97,C28)/1000","v":0.31649003878394205},{"$f":"visg_cp(F28*1000,Input!$C$16,$B$7*28.97)","v":4.1034036384336239E-2},5.3989603091535374E-2,456.02153786645999,11113.250804654823,8384.044861118191,1120680.1773206291,11829114.250031505,6.8828604937703868E-4,1.287282116367233E-3]
[550,12.035717353580578,1.2515510281182598,3.0162920817731298E-3,331.53287973761121,{"$f":"deng_kgm3(A29,Input!$C$16,$B$7*28.97,C29)/1000","v":0.30499226056595635},{"$f":"visg_cp(F29*1000,Input!$C$16,$B$7*28.97)","v":3.8888583812143565E-2},4.8671047052151396E-2,439.45471470463303,11300.352741757761,8525.1980719875155,1139312.3797107879,10708434.072710875,7.9650082065309377E-4,1.2786859028659642E-3]
[500,10.941561230527798,1.1879952964901577,3.14943202316896E-3,317.51756908656802,{"$f":"deng_kgm3(A30,Input!$C$16,$B$7*28.97,C30)/1000","v":0.29209893523008368},{"$f":"visg_cp(F30*1000,Input!$C$16,$B$7*28.97)","v":3.6642951429676079E-2},4.3531653947972482E-2,420.87708720498489,11485.894852457997,8665.1745205605803,1157347.5221735709,9569121.6930000875,9.3784563484487012E-4,1.2618343899507838E-3]
[450,9.8474051074750193,1.1255851168432625,3.31553296573727E-3,301.61063404707591,{"$f":"deng_kgm3(A31,Input!$C$16,$B$7*28.97,C31)/1000","v":0.27746541809534214},{"$f":"visg_cp(F31*1000,Input!$C$16,$B$7*28.97)","v":3.428438047330732E-2},3.8589988400946483E-2,399.79206660269159,11661.055591013419,8797.3190672615456,1173509.6921911284,8411774.170826517,1.1278371934825805E-3,1.2318235004454268E-3]
[400,8.753248984422239,1.0651667622826708,3.5297596727227815E-3,283.30540680369359,{"$f":"deng_kgm3(A32,Input!$C$16,$B$7*28.97,C32)/1000","v":0.26062560226304438},{"$f":"visg_cp(F32*1000,Input!$C$16,$B$7*28.97)","v":3.1799784592443828E-2},3.3872073595619751E-2,375.52805266171941,11809.138252809149,8909.0354049445923,829139.88937312679,7238264.4786353884,1.3918205992610639E-3,1.180395864313443E-3]
[365,7.9873396982852931,1.0247722303435263,3.7215341275967781E-3,268.70638981504146,{"$f":"deng_kgm3(A33,Input!$C$16,$B$7*28.97,C33)/1000","v":0.24719529876815793},{"$f":"visg_cp(F33*1000,Input!$C$16,$B$7*28.97)","v":2.9979758751241047E-2},3.0722424240670138E-2,356.17670853321613,11880.572872137331,8962.9270216831883,1543582.8002447204,6409124.589262262,1.6424444952643231E-3,1.1244636429986318E-3]
[300,6.5649367383166792,0.95679029334989285,4.2274942757715159E-3,236.54674253047935,{"$f":"deng_kgm3(A34,Input!$C$16,$B$7*28.97,C34)/1000","v":0.21761016823122528},{"$f":"visg_cp(F34*1000,Input!$C$16,$B$7*28.97)","v":2.6422193249463547E-2},2.5280498030101788E-2,313.54833142134697,11866.854823935291,8952.5778688066312,1173237.1156433881,4865541.7890175413,2.342759095339049E-3,9.4777181575539827E-4]
[250,5.4707806152638989,0.91490950200217502,4.8509371921256388E-3,206.145732338746,{"$f":"deng_kgm3(A35,Input!$C$16,$B$7*28.97,C35)/1000","v":0.18964288839700871},{"$f":"visg_cp(F35*1000,Input!$C$16,$B$7*28.97)","v":2.3560417347606895E-2},2.1555649702462428E-2,273.25106958983758,11597.887488932472,8749.6638661914385,1124149.2092117805,3692304.6733741527,3.225498527864083E-3,7.0859875617182324E-4]
[200,4.3766244922111195,0.8880735590370864,5.885813087863942E-3,169.90006054761014,{"$f":"deng_kgm3(A36,Input!$C$16,$B$7*28.97,C36)/1000","v":0.15629883701948216},{"$f":"visg_cp(F36*1000,Input!$C$16,$B$7*28.97)","v":2.0689441366312664E-2},1.8373745828670407E-2,225.20656984411795,10885.096695303135,8211.9211214783154,1016251.2769029043,2568155.4641623725,4.6145087243493806E-3,3.4234460914479181E-4]
[150,3.2824683691583396,0.88261123087641247,7.7994811448138168E-3,128.21365696421222,{"$f":"deng_kgm3(A37,Input!$C$16,$B$7*28.97,C37)/1000","v":0.1179496076042045},{"$f":"visg_cp(F37*1000,Input!$C$16,$B$7*28.97)","v":1.8003340234701921E-2},1.5889950284437102E-2,169.9502507474933,9439.9288427549491,7121.6593861330784,823988.57975273696,1551904.1872594682,6.8212126209029906E-3,-1.3640399489549143E-4]
[100,2.1883122461055597,0.90185712171026133,1.1954330576176717E-2,83.651693721173984,{"$f":"deng_kgm3(A38,Input!$C$16,$B$7*28.97,C38)/1000","v":7.6955019328351415E-2},{"$f":"visg_cp(F38*1000,Input!$C$16,$B$7*28.97)","v":1.5750679788370824E-2},1.4204862738920099E-2,110.88230895195713,7039.8427522997899,5310.9894204652946,539972.427932341,727915.60750673118,1.0691025154623718E-2,-6.2320595697833484E-4]
[50,1.0941561230527799,0.94308589522321162,2.5001655543503715E-2,39.997351305795192,{"$f":"deng_kgm3(A39,Input!$C$16,$B$7*28.97,C39)/1000","v":3.6795392966935528E-2},{"$f":"visg_cp(F39*1000,Input!$C$16,$B$7*28.97)","v":1.4101861438188203E-2},1.3299266618747408E-2,53.017440143313657,3759.6058063470305,2836.3171401955019,187943.17957439017,187943.17957439017,2.1063695937365106E-2,-1.0031566353352623E-3]
[1,2.1883122461055598E-2,0.99874633073949526,1.323862007849087,0.75536573605939938,{"$f":"deng_kgm3(A40,Input!$C$16,$B$7*28.97,C40)/1000","v":6.9489549144313083E-4},{"$f":"visg_cp(F40*1000,Input!$C$16,$B$7*28.97)","v":1.3179737264300339E-2},1.3163214232830556E-2,1.0012552429199679,75.969287007871216,57.312655094077009,0,{"$f":"L40","v":0},1.0012531407572882,-1.2515697332416758E-3]
[]
[{"$f":"5300/14.5","v":365.51724137931035}]