{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Methanol Vapor Pressure","Methanol","MEG Heat Capacity","MEG","TEG Activity Coef Chart","TEG Activity Coef","glycol viscosity","TEG Viscosity","TEG VP","TEG Vapor Pressure","TEG Dehy","TEG Reboiler","TEG Heat Capacity","TEG, CP"],"not_rendered":{"charts":18,"images":0,"macros":1,"external_links":0,"defined_names":58,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Methanol Vapor Pressure","index":0,"reason":"not_a_worksheet"},{"sheet":"MEG Heat Capacity","index":2,"reason":"not_a_worksheet"},{"sheet":"TEG Activity Coef Chart","index":4,"reason":"not_a_worksheet"},{"sheet":"glycol viscosity","index":6,"reason":"not_a_worksheet"},{"sheet":"TEG VP","index":8,"reason":"not_a_worksheet"},{"sheet":"TEG Heat Capacity","index":12,"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":"Methanol","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["T °R","T,°F","Vapor Pressure",null,null,null,"°K","x","pvp,bars",null,"gal/MMSCF"]
[null,null,"psi"]
[{"$f":"B3+459.7","v":559.7},100.0,{"$f":"I3*14.504","v":4.639695649},null,null,null,{"$f":"A3/1.8","v":310.9444444},{"$f":"1-G3/512.6","v":0.3933974943},{"$f":"80.9*EXP((1-H3)^(-1)*((-8.54796*H3)+0.76982*H3^1.5-3.1085*H3^3+1.54481*H3^6))","v":0.3198907645},null,{"$f":"1000000*C3/600/379.5*32/6.6","v":98.7944403}]
[534.7,75.0,2.324145922,null,null,null,297.0555556,0.4204924784,0.1602417211,null,49.48874084]
[509.7,50.0,1.079974007,null,null,null,283.1666667,0.4475874626,0.07446042516,null,22.99621259]
[484.7,25.0,0.460063536,null,null,null,269.2777778,0.4746824468,0.03171976944,null,9.796271776]
[459.7,0.0,0.1771313224,null,null,null,255.3888889,0.501777431,0.01221258428,null,3.771710729]
[434.7,-25.0,0.06057676671,null,null,null,241.5,0.5288724151,0.004176555896,null,1.289879383]
[409.7,-50.0,0.01801129525,null,null,null,227.6111111,0.5559673993,0.001241815724,null,0.3835199479]
[384.7,-75.0,0.004532906062,null,null,null,213.7222222,0.5830623835,0.0003125279966,null,0.09652053739]
[359.7,-100.0,0.0009333314915,null,null,null,199.8333333,0.6101573677,0.00006434993736,null,0.01987370924]

{"sheet":"MEG","index":3,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Heat Capacity of Glycol "]
["°F","100 wt%",80.0,75.0,70.0,65.0,62.5,60.0,55.0,50.0,45.0,40.0,20.0,10.0]
[]
[60.0,0.563,0.66,null,{"$f":"(C4+H4)/2","v":0.7085},null,{"$f":"H4+(C4-H4)*2.5/20","v":0.744875},0.757,null,{"$f":"(H4+L4)/2","v":0.806},null,0.855,0.94,0.976]
[80.0,0.576,0.673,null,0.721,null,0.757,0.769,null,0.8165,null,0.864,0.942,0.977]
[100.0,0.59,0.685,null,0.7325,null,0.768125,0.78,null,0.826,null,0.872,0.944,0.978]
[120.0,0.604,0.697,null,0.7445,null,0.780125,0.792,null,0.836,null,0.88,0.946,0.979]
[140.0,0.618,0.71,null,0.7565,null,0.791375,0.803,null,0.8455,null,0.888,0.948,0.98]
[160.0,0.632,0.722,null,0.768,null,0.8025,0.814,null,0.855,null,0.896,0.95,0.981]
[180.0,0.646,0.735,null,0.78,null,0.81375,0.825,null,0.865,null,0.905,0.952,0.982]
[200.0,0.66,0.748,null,0.7925,null,0.825875,0.837,null,0.8755,null,0.914,0.954,0.982]
[220.0,0.674,0.761,null,0.805,null,0.838,0.849,null,0.8855,null,0.922,0.956,0.983]
[240.0,0.688,0.774,null,0.8175,null,0.850125,0.861,null,0.8955,null,0.93,0.958,0.984]

{"sheet":"TEG Activity Coef","index":5,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"g"]
[null,null,null,null,null,"Scauzilla","Rosman","Parrish","Parrish","t,°F","a","b","c"]
[0.99999,80.0,null,null,null,{"$f":"10^(-0.405/(1+0.405*A3/((1-A3)*0.356))^2)","v":0.9999999999},{"$f":"EXP(-1/((0.0063*A3/(1-A3))+0.05449)^2/($B$3+459.7))","v":0.9999999953},{"$f":"EXP($L$3*(TANH($K$3*A3/($L$3*(1-A3)))-1)-$M$3*(1-A3)^2)","v":1},null,80.0,{"$f":"EXP(-12.792+0.03293*(J3+459.7)/1.8)","v":0.05401527871},{"$f":"EXP(0.77377-0.00695*(J3+459.7)/1.8)","v":0.26980072},{"$f":"0.88874-0.001915*(J3+459.7)/1.8","v":0.3145591667}]
[0.95,null,null,null,null,0.998178307,0.9407609266,0.9989463351]
[0.9,null,null,null,null,0.992644175,0.8608194556,0.9827052314]
[0.8,null,null,null,null,0.9701846031,0.7469406673,0.9020347254]
[0.7,null,null,null,null,0.9325562279,0.6790608637,0.834845973]
[0.6,null,null,null,null,0.880459461,0.635582767,0.7854816699]
[0.5,null,null,null,null,0.8153967733,0.6056828343,0.7444306928]
[0.4,null,null,null,null,0.739638634,0.5839604215,0.7066327818]
[0.3,null,null,null,null,0.6561103543,0.5675027124,0.6697559089]
[0.2,null,null,null,null,0.56820128,0.5546194837,0.632784073]
[0.1,null,null,null,null,0.479509822,0.5442685073,0.5953576646]
[0.09,null,null,null,null,0.4707352939,0.5433444348,0.5915874905]
[0.08,null,null,null,null,0.4619917765,0.5424382268,0.5878125983]
[0.07,null,null,null,null,0.4532826037,0.5415493737,0.5840331204]
[0.06,null,null,null,null,0.4446110651,0.5406773853,0.5802492052]
[0.05,null,null,null,null,0.435980403,0.5398217894,0.5764610158]
[0.04,null,null,null,null,0.4273938098,0.5389821311,0.5726687292]
[0.03,null,null,null,null,0.4188544253,0.5381579722,0.5688725351]
[0.02,null,null,null,null,0.4103653337,0.5373488903,0.5650726358]
[0.01,null,null,null,null,0.4019295617,0.5365544779,0.5612692449]
[1.0E-4,null,null,null,null,0.3936335821,0.5357820742,0.5575006689]
[0.1938,null,null,null,null,null,null,0.6304782946]
[0.4191,null,null,null,null,null,null,0.7137335077]
[0.6102,null,null,null,null,null,null,0.7900149319]
[0.2961,null,null,null,null,null,null,0.6683196605]
[0.503,null,null,null,null,null,null,0.7455982702]
[0.6386,null,null,null,null,null,null,0.803135924]

{"sheet":"TEG Viscosity","index":7,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"TEG","MEG",null,"Meoh"]
[null,"a","b","c","d",null,"Temp,°K","Temp,°F","Visc,cp"]
["TEG",-13.8883,3064.2,0.020531,-1.05E-5,{"$f":"G4-273.13","v":-17.74111111},{"$f":"(H4+459.7)/1.8","v":255.3888889},0.0,{"$f":"10^(A_teg+B_teg/$G4+C_teg*$G4+D_teg*($G4^2))","v":466.0316488},{"$f":"EXP(A_MEG+B_MEG/$G4)","v":89.63284039},null,{"$f":"EXP(A_MeOH+B_MeOH/$G4+C_MeOH*$G4+D_MeOH*($G4^2))","v":1.057919105}]
["MEG",-7.811,3143.0,0.0,0.0,-12.18555556,260.9444444,10.0,{"$f":"10^(A_teg+B_teg/G5+C_teg*G5+D_teg*(G5^2))","v":313.9885117},{"$f":"EXP(A_MEG+B_MEG/$G5)","v":68.97260446},null,{"$f":"EXP(A_MeOH+B_MeOH/$G5+C_MeOH*$G5+D_MeOH*($G5^2))","v":0.9386661149}]
["MeOH",-39.35,4826.0,0.1091,-1.1274E-4,-6.63,266.5,20.0,{"$f":"10^(A_teg+B_teg/G6+C_teg*G6+D_teg*(G6^2))","v":216.4781586},{"$f":"EXP(A_MEG+B_MEG/$G6)","v":53.65748706},null,{"$f":"EXP(A_MeOH+B_MeOH/$G6+C_MeOH*$G6+D_MeOH*($G6^2))","v":0.8410699449}]
[null,null,null,null,null,-1.074444444,272.0555556,30.0,{"$f":"10^(A_teg+B_teg/G7+C_teg*G7+D_teg*(G7^2))","v":152.4979283},{"$f":"EXP(A_MEG+B_MEG/$G7)","v":42.17330428},null,{"$f":"EXP(A_MeOH+B_MeOH/$G7+C_MeOH*$G7+D_MeOH*($G7^2))","v":0.7602721954}]
[null,null,null,null,null,4.481111111,277.6111111,40.0,{"$f":"10^(A_teg+B_teg/G8+C_teg*G8+D_teg*(G8^2))","v":109.6132648},{"$f":"EXP(A_MEG+B_MEG/$G8)","v":33.46810701},null,{"$f":"EXP(A_MeOH+B_MeOH/$G8+C_MeOH*$G8+D_MeOH*($G8^2))","v":0.6926463854}]
[null,null,null,null,null,10.03666667,283.1666667,50.0,{"$f":"10^(A_teg+B_teg/G9+C_teg*G9+D_teg*(G9^2))","v":80.28944878},{"$f":"EXP(A_MEG+B_MEG/$G9)","v":26.80183289},null,{"$f":"EXP(A_MeOH+B_MeOH/$G9+C_MeOH*$G9+D_MeOH*($G9^2))","v":0.6354496964}]
[null,null,null,null,null,15.59222222,288.7222222,60.0,{"$f":"10^(A_teg+B_teg/G10+C_teg*G10+D_teg*(G10^2))","v":59.86038258},{"$f":"EXP(A_MEG+B_MEG/$G10)","v":21.64762414},null,{"$f":"EXP(A_MeOH+B_MeOH/$G10+C_MeOH*$G10+D_MeOH*($G10^2))","v":0.5865819693}]
[null,null,null,null,null,21.14777778,294.2777778,70.0,{"$f":"10^(A_teg+B_teg/G11+C_teg*G11+D_teg*(G11^2))","v":45.37683044},{"$f":"EXP(A_MEG+B_MEG/$G11)","v":17.62617695},null,{"$f":"EXP(A_MeOH+B_MeOH/$G11+C_MeOH*$G11+D_MeOH*($G11^2))","v":0.5444165629}]
[null,null,null,null,null,26.70333333,299.8333333,80.0,{"$f":"10^(A_teg+B_teg/G12+C_teg*G12+D_teg*(G12^2))","v":34.93859799},{"$f":"EXP(A_MEG+B_MEG/$G12)","v":14.46150472},null,{"$f":"EXP(A_MeOH+B_MeOH/$G12+C_MeOH*$G12+D_MeOH*($G12^2))","v":0.50768008}]
[null,null,null,null,null,32.25888889,305.3888889,90.0,{"$f":"10^(A_teg+B_teg/G13+C_teg*G13+D_teg*(G13^2))","v":27.29909361},{"$f":"EXP(A_MEG+B_MEG/$G13)","v":11.95076777},null,{"$f":"EXP(A_MeOH+B_MeOH/$G13+C_MeOH*$G13+D_MeOH*($G13^2))","v":0.4753657945}]
[null,null,null,null,null,37.81444444,310.9444444,100.0,{"$f":"10^(A_teg+B_teg/G14+C_teg*G14+D_teg*(G14^2))","v":21.62649646},{"$f":"EXP(A_MEG+B_MEG/$G14)","v":9.943459063},null,{"$f":"EXP(A_MeOH+B_MeOH/$G14+C_MeOH*$G14+D_MeOH*($G14^2))","v":0.4466706227}]
[null,null,null,null,null,43.37,316.5,110.0,{"$f":"10^(A_teg+B_teg/G15+C_teg*G15+D_teg*(G15^2))","v":17.35679215},{"$f":"EXP(A_MEG+B_MEG/$G15)","v":8.326887455},null,{"$f":"EXP(A_MeOH+B_MeOH/$G15+C_MeOH*$G15+D_MeOH*($G15^2))","v":0.4209487492}]
[null,null,null,null,null,48.92555556,322.0555556,120.0,{"$f":"10^(A_teg+B_teg/G16+C_teg*G16+D_teg*(G16^2))","v":14.10173067},{"$f":"EXP(A_MEG+B_MEG/$G16)","v":7.015947595},null,{"$f":"EXP(A_MeOH+B_MeOH/$G16+C_MeOH*$G16+D_MeOH*($G16^2))","v":0.397677165}]
[null,null,null,null,null,54.48111111,327.6111111,130.0,{"$f":"10^(A_teg+B_teg/G17+C_teg*G17+D_teg*(G17^2))","v":11.59021323},{"$f":"EXP(A_MEG+B_MEG/$G17)","v":5.94583936},null,{"$f":"EXP(A_MeOH+B_MeOH/$G17+C_MeOH*$G17+D_MeOH*($G17^2))","v":0.376429819}]
[null,null,null,null,null,60.03666667,333.1666667,140.0,{"$f":"10^(A_teg+B_teg/G18+C_teg*G18+D_teg*(G18^2))","v":9.630373723},{"$f":"EXP(A_MEG+B_MEG/$G18)","v":5.066837514},null,{"$f":"EXP(A_MeOH+B_MeOH/$G18+C_MeOH*$G18+D_MeOH*($G18^2))","v":0.3568580565}]
[null,null,null,null,null,65.59222222,338.7222222,150.0,{"$f":"10^(A_teg+B_teg/G19+C_teg*G19+D_teg*(G19^2))","v":8.084679325},{"$f":"EXP(A_MEG+B_MEG/$G19)","v":4.340500513},null,{"$f":"EXP(A_MeOH+B_MeOH/$G19+C_MeOH*$G19+D_MeOH*($G19^2))","v":0.3386756854}]
[null,null,null,null,null,71.14777778,344.2777778,160.0,{"$f":"10^(A_teg+B_teg/G20+C_teg*G20+D_teg*(G20^2))","v":6.853347069},{"$f":"EXP(A_MEG+B_MEG/$G20)","v":3.736898882},null,{"$f":"EXP(A_MeOH+B_MeOH/$G20+C_MeOH*$G20+D_MeOH*($G20^2))","v":0.3216474768}]
[null,null,null,null,null,76.70333333,349.8333333,170.0,{"$f":"10^(A_teg+B_teg/G21+C_teg*G21+D_teg*(G21^2))","v":5.86314971},{"$f":"EXP(A_MEG+B_MEG/$G21)","v":3.232572396},null,{"$f":"EXP(A_MeOH+B_MeOH/$G21+C_MeOH*$G21+D_MeOH*($G21^2))","v":0.3055802283}]
[null,null,null,null,null,82.25888889,355.3888889,180.0,{"$f":"10^(A_teg+B_teg/G22+C_teg*G22+D_teg*(G22^2))","v":5.059762529},{"$f":"EXP(A_MEG+B_MEG/$G22)","v":2.809012637},null,{"$f":"EXP(A_MeOH+B_MeOH/$G22+C_MeOH*$G22+D_MeOH*($G22^2))","v":0.2903157507}]
[null,null,null,null,null,87.81444444,360.9444444,190.0,{"$f":"10^(A_teg+B_teg/G23+C_teg*G23+D_teg*(G23^2))","v":4.402467196},{"$f":"EXP(A_MEG+B_MEG/$G23)","v":2.451527382},null,{"$f":"EXP(A_MeOH+B_MeOH/$G23+C_MeOH*$G23+D_MeOH*($G23^2))","v":0.2757253024}]
[null,null,null,null,null,93.37,366.5,200.0,{"$f":"10^(A_teg+B_teg/G24+C_teg*G24+D_teg*(G24^2))","v":3.86044428},{"$f":"EXP(A_MEG+B_MEG/$G24)","v":2.148384651},null,{"$f":"EXP(A_MeOH+B_MeOH/$G24+C_MeOH*$G24+D_MeOH*($G24^2))","v":0.2617051167}]
[null,null,null,null,null,98.92555556,372.0555556,210.0,{"$f":"10^(A_teg+B_teg/G25+C_teg*G25+D_teg*(G25^2))","v":3.410149233},{"$f":"EXP(A_MEG+B_MEG/$G25)","v":1.890163121},null,{"$f":"EXP(A_MeOH+B_MeOH/$G25+C_MeOH*$G25+D_MeOH*($G25^2))","v":0.2481727529}]
[null,null,null,null,null,104.4811111,377.6111111,220.0,{"$f":"10^(A_teg+B_teg/G26+C_teg*G26+D_teg*(G26^2))","v":3.03343571},{"$f":"EXP(A_MEG+B_MEG/$G26)","v":1.669255904},null,{"$f":"EXP(A_MeOH+B_MeOH/$G26+C_MeOH*$G26+D_MeOH*($G26^2))","v":0.2350640712}]
[null,null,null,null,null,110.0366667,383.1666667,230.0,{"$f":"10^(A_teg+B_teg/G27+C_teg*G27+D_teg*(G27^2))","v":2.716199931},{"$f":"EXP(A_MEG+B_MEG/$G27)","v":1.479489099},null,{"$f":"EXP(A_MeOH+B_MeOH/$G27+C_MeOH*$G27+D_MeOH*($G27^2))","v":0.2223306755}]
[null,null,null,null,null,115.5922222,388.7222222,240.0,{"$f":"10^(A_teg+B_teg/G28+C_teg*G28+D_teg*(G28^2))","v":2.447392083},{"$f":"EXP(A_MEG+B_MEG/$G28)","v":1.315826782},null,{"$f":"EXP(A_MeOH+B_MeOH/$G28+C_MeOH*$G28+D_MeOH*($G28^2))","v":0.2099377097}]
[null,null,null,null,null,121.1477778,394.2777778,250.0,{"$f":"10^(A_teg+B_teg/G29+C_teg*G29+D_teg*(G29^2))","v":2.218288797},{"$f":"EXP(A_MEG+B_MEG/$G29)","v":1.174141532},null,{"$f":"EXP(A_MeOH+B_MeOH/$G29+C_MeOH*$G29+D_MeOH*($G29^2))","v":0.19786192}]
[null,null,null,null,null,126.7033333,399.8333333,260.0,{"$f":"10^(A_teg+B_teg/G30+C_teg*G30+D_teg*(G30^2))","v":2.021953113},{"$f":"EXP(A_MEG+B_MEG/$G30)","v":1.051034927},null,{"$f":"EXP(A_MeOH+B_MeOH/$G30+C_MeOH*$G30+D_MeOH*($G30^2))","v":0.1860899191}]
[null,null,null,null,null,132.2588889,405.3888889,270.0,{"$f":"10^(A_teg+B_teg/G31+C_teg*G31+D_teg*(G31^2))","v":1.852830263},{"$f":"EXP(A_MEG+B_MEG/$G31)","v":0.9436963746},null,{"$f":"EXP(A_MeOH+B_MeOH/$G31+C_MeOH*$G31+D_MeOH*($G31^2))","v":0.1746166052}]
[null,null,null,null,null,137.8144444,410.9444444,280.0,{"$f":"10^(A_teg+B_teg/G32+C_teg*G32+D_teg*(G32^2))","v":1.706442717},{"$f":"EXP(A_MEG+B_MEG/$G32)","v":0.8497915212},null,{"$f":"EXP(A_MeOH+B_MeOH/$G32+C_MeOH*$G32+D_MeOH*($G32^2))","v":0.1634437035}]
[null,null,null,null,null,143.37,416.5,290.0,{"$f":"10^(A_teg+B_teg/G33+C_teg*G33+D_teg*(G33^2))","v":1.579158361},{"$f":"EXP(A_MEG+B_MEG/$G33)","v":0.7673735931},null,{"$f":"EXP(A_MeOH+B_MeOH/$G33+C_MeOH*$G33+D_MeOH*($G33^2))","v":0.15257841}]
[null,null,null,null,null,148.9255556,422.0555556,300.0,{"$f":"10^(A_teg+B_teg/G34+C_teg*G34+D_teg*(G34^2))","v":1.468012981},{"$f":"EXP(A_MEG+B_MEG/$G34)","v":0.6948126272},null,{"$f":"EXP(A_MeOH+B_MeOH/$G34+C_MeOH*$G34+D_MeOH*($G34^2))","v":0.1420321233}]
[null,null,null,null,null,154.4811111,427.6111111,310.0,{"$f":"10^(A_teg+B_teg/G35+C_teg*G35+D_teg*(G35^2))","v":1.370573388},{"$f":"EXP(A_MEG+B_MEG/$G35)","v":0.6307387149},null,{"$f":"EXP(A_MeOH+B_MeOH/$G35+C_MeOH*$G35+D_MeOH*($G35^2))","v":0.1318192613}]
[null,null,null,null,null,160.0366667,433.1666667,320.0,{"$f":"10^(A_teg+B_teg/G36+C_teg*G36+D_teg*(G36^2))","v":1.284831162},{"$f":"EXP(A_MEG+B_MEG/$G36)","v":0.5739962828},null,{"$f":"EXP(A_MeOH+B_MeOH/$G36+C_MeOH*$G36+D_MeOH*($G36^2))","v":0.1219561602}]
[null,null,null,null,null,165.5922222,438.7222222,330.0,{"$f":"10^(A_teg+B_teg/G37+C_teg*G37+D_teg*(G37^2))","v":1.209119654},{"$f":"EXP(A_MEG+B_MEG/$G37)","v":0.5236071047},null,{"$f":"EXP(A_MeOH+B_MeOH/$G37+C_MeOH*$G37+D_MeOH*($G37^2))","v":0.1124600613}]
[null,null,null,null,null,171.1477778,444.2777778,340.0,{"$f":"10^(A_teg+B_teg/G38+C_teg*G38+D_teg*(G38^2))","v":1.142048727},{"$f":"EXP(A_MEG+B_MEG/$G38)","v":0.4787402525},null,{"$f":"EXP(A_MeOH+B_MeOH/$G38+C_MeOH*$G38+D_MeOH*($G38^2))","v":0.1033481887}]
[null,null,null,null,null,176.7033333,449.8333333,350.0,{"$f":"10^(A_teg+B_teg/G39+C_teg*G39+D_teg*(G39^2))","v":1.082453174},{"$f":"EXP(A_MEG+B_MEG/$G39)","v":0.4386875871},null,{"$f":"EXP(A_MeOH+B_MeOH/$G39+C_MeOH*$G39+D_MeOH*($G39^2))","v":0.09463692679}]
[null,null,null,null,null,182.2588889,455.3888889,360.0,{"$f":"10^(A_teg+B_teg/G40+C_teg*G40+D_teg*(G40^2))","v":1.029351683},{"$f":"EXP(A_MEG+B_MEG/$G40)","v":0.4028436889},null,{"$f":"EXP(A_MeOH+B_MeOH/$G40+C_MeOH*$G40+D_MeOH*($G40^2))","v":0.0863411023}]
[null,null,null,null,null,187.8144444,460.9444444,370.0,{"$f":"10^(A_teg+B_teg/G41+C_teg*G41+D_teg*(G41^2))","v":0.981914038},{"$f":"EXP(A_MEG+B_MEG/$G41)","v":0.3706893628},null,{"$f":"EXP(A_MeOH+B_MeOH/$G41+C_MeOH*$G41+D_MeOH*($G41^2))","v":0.07847337833}]
[null,null,null,null,null,193.37,466.5,380.0,{"$f":"10^(A_teg+B_teg/G42+C_teg*G42+D_teg*(G42^2))","v":0.9394347503},{"$f":"EXP(A_MEG+B_MEG/$G42)","v":0.3417780314},null,{"$f":"EXP(A_MeOH+B_MeOH/$G42+C_MeOH*$G42+D_MeOH*($G42^2))","v":0.07104376334}]
[null,null,null,null,null,198.9255556,472.0555556,390.0,{"$f":"10^(A_teg+B_teg/G43+C_teg*G43+D_teg*(G43^2))","v":0.901311757},{"$f":"EXP(A_MEG+B_MEG/$G43)","v":0.3157244715},null,{"$f":"EXP(A_MeOH+B_MeOH/$G43+C_MeOH*$G43+D_MeOH*($G43^2))","v":0.0640592381}]
[null,null,null,null,null,204.4811111,477.6111111,400.0,{"$f":"10^(A_teg+B_teg/G44+C_teg*G44+D_teg*(G44^2))","v":0.8670291307},{"$f":"EXP(A_MEG+B_MEG/$G44)","v":0.2921954576},null,{"$f":"EXP(A_MeOH+B_MeOH/$G44+C_MeOH*$G44+D_MeOH*($G44^2))","v":0.05752350001}]

{"sheet":"TEG Vapor Pressure","index":9,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,"a","b","c",null,"P","P","°C","t",null,null,"water"]
["torr,°K",17097.1,9.652867,0.0,null,{"$f":"10^((-0.2185*B3/((I3+459.7)/1.8)+C3))*0.01934","v":22.1280594},null,null,560.0]
["mmhg,°K",8.702614,2852.623,210.398,null,{"$f":"EXP(B4-C4/((I4+459.7)/1.8+D4))*0.01934","v":2.960099033},null,null,560.0]
["Psia,°F",12.0229,-6987.0,202.7,null,{"$f":"EXP(B5+C5/(I5+D5))","v":17.49690773},null,null,560.0,null,32.018,0.08865]
["Psia,°F",13.1222,-8395.32,258.7,null,17.59734115,null,null,560.0,null,35.0,0.09991]
[null,null,null,null,null,null,null,null,null,null,40.0,0.12163]
[null,null,null,null,null,null,null,null,null,null,50.0,0.17796]
[null,null,null,null,null,null,null,null,null,null,60.0,0.25611]
["Psia,°F",12.0229,-6987.0,202.7,null,{"$f":"EXP(B$10+C$10/(G10+D$10))*51.71","v":0.000008454299427},50.0,null,{"$f":"1000/(G10+459.7)","v":1.961938395},null,70.0,0.36292]
[null,null,null,null,null,0.0008138711665,100.0,null,1.786671431,null,80.0,0.50683]
[null,null,null,null,null,0.02146169261,150.0,null,1.640150894,null,90.0,0.69813]
[null,null,null,null,null,0.2511176523,200.0,null,1.515840534,null,100.0,0.94294]
[null,null,null,null,null,1.706575777,250.0,null,1.409046076,null,110.0,1.275]
[null,null,null,null,null,7.921697337,300.0,null,1.316309069,null,120.0,1.6927]
[null,null,null,null,null,27.8539135,350.0,null,1.235025318,null,130.0,2.223]
[null,null,null,null,null,79.49697189,400.0,null,1.163196464,null,140.0,2.8892]
[null,null,null,null,null,193.2116777,450.0,null,1.099263493,null,150.0,3.7184]
[null,null,null,null,null,413.8379542,500.0,null,1.041992289,null,160.0,4.7414]
[null,null,null,null,null,801.0861418,550.0,null,0.9903931861,null,170.0,5.9926]
[null,null,null,null,null,904.7650987,560.0,null,0.9806805923,null,180.0,7.511]
[null,null,null,null,null,{"$f":"EXP(B$10+C$10/(G22+D$10))","v":0.000001242155779},70.0,null,null,null,190.0,9.34]
[null,null,null,null,null,0.000003074568955,80.0,null,null,null,200.0,11.526]
[null,null,null,null,null,0.00000715315147,90.0,null,null,null,210.0,14.123]
[null,null,null,null,null,0.00001573914458,100.0]
[null,null,null,null,null,0.00003292758584,110.0]
[null,null,null,null,null,0.00006580670171,120.0]
[]
[]
[]
[null,null,"below data all from the Chemistry and Physics Handbook"]
[]
[null,null,null,null,"1000/t,°R","Vapor Press","t, °F"]
[null,null,null,null,{"$f":"1000/(459.7+G34)","v":2.175331738},{"$f":"10^((-0.2185*B$36/((G34+459.7)/1.8)+C$36))","v":0.00001060002249},0.0,{"$f":"(G34-32)/1.8","v":-17.77777778}]
[null,null,"teg",null,1.961938395,0.0002885528627,50.0,10]
["torr,°K",17097.1,9.652867,0.0,1.786671431,0.004352824735,100.0,37.77777778]
[null,null,null,null,1.725030188,0.01130484833,120.0,48.88888889]
[null,null,null,null,1.640150894,0.0420743757,150.0,65.55555556]
[null,null,null,null,1.515840534,0.2883477205,200.0,93.33333333]
[null,null,null,null,1.409046076,1.506722821,250.0,121.1111111]
[null,null,null,null,1.316309069,6.333209262,300.0,148.8888889]
[null,null,null,null,1.235025318,22.29458067,350.0,176.6666667]
[null,null,null,null,1.163196464,67.79494503,400.0,204.4444444]
[]
[]
[]
[null,null,"deg"]
["torr,°K",16146.7,9.668173,0.0,{"$f":"1000/(459.7+G48)","v":2.175331738},{"$f":"10^((-0.2185*B$48/((G48+459.7)/1.8)+C$48))","v":0.00007140606221},0.0,{"$f":"(G48-32)/1.8","v":-17.77777778}]
[null,null,null,null,1.961938395,0.001617666127,50.0,10]
[null,null,null,null,1.786671431,0.02098559273,100.0,37.77777778]
[null,null,null,null,1.725030188,0.05168610152,120.0,48.88888889]
[null,null,null,null,1.640150894,0.1788131642,150.0,65.55555556]
[null,null,null,null,1.515840534,1.101113462,200.0,93.33333333]
[null,null,null,null,1.409046076,5.248436749,250.0,121.1111111]
[null,null,null,null,1.316309069,20.36835985,300.0,148.8888889]
[null,null,null,null,1.235025318,66.85721584,350.0,176.6666667]
[null,null,null,null,1.163196464,191.1160751,400.0,204.4444444]
[]
[]
[]
[]
[]
[null,null,"EG",null,{"$f":"1000/(459.7+G63)","v":2.440810349},{"$f":"10^((-0.2185*B$64/((G63+459.7)/1.8)+C$64))","v":0.00008394445331},-50.0,{"$f":"(G63-32)/1.8","v":-45.55555556}]
["torr,°K",14032.4,9.394685,0.0,2.175331738,0.002449927911,0.0,-17.77777778]
[null,null,null,null,1.961938395,0.03688578111,50.0,10]
[null,null,null,null,1.786671431,0.3420954948,100.0,37.77777778]
[null,null,null,null,1.725030188,0.7487586576,120.0,48.88888889]
[null,null,null,null,1.640150894,2.201840402,150.0,65.55555556]
[null,null,null,null,1.515840534,10.68679846,200.0,93.33333333]
[null,null,null,null,1.409046076,41.51835481,250.0,121.1111111]
[null,null,null,null,1.316309069,134.911938,300.0,148.8888889]
[null,null,null,null,1.235025318,379.0100841,350.0,176.6666667]
[null,null,null,null,1.163196464,944.2132947,400.0,204.4444444]
[]
[]
[]
[null,null,"Methanol"]
[null,null,null,null,{"$f":"1000/(459.7+G78)","v":2.780094523},{"$f":"10^((-0.2185*B$79/((G78+459.7)/1.8)+C$79))","v":0.05029962191},-100.0,{"$f":"(G78-32)/1.8","v":-73.33333333}]
["torr,°K",9377.2,8.9547,0.0,2.440810349,0.8971450301,-50.0,-45.55555556]
[null,null,null,null,2.175331738,8.549914651,0.0,-17.77777778]
[null,null,null,null,1.961938395,52.35614802,50.0,10]
[null,null,null,null,1.786671431,231.9324402,100.0,37.77777778]
[null,null,null,null,1.725030188,391.4692501,120.0,48.88888889]
[null,null,null,null,1.640150894,804.8908104,150.0,65.55555556]
[]
[null,null,null,null,null,"water"]
[]
[null,null,null,null,{"$f":"1000/(459.7+G88)","v":2.151925974},1.436,5.0,{"$f":"(G88-32)/1.8","v":-15}]
[null,null,null,null,2.033760423,4.579,32.0,0]
[null,null,null,0.17811,1.961938395,{"$f":"D90*51.71","v":9.2100681},50.0,10]
[null,null,null,0.9492,1.786671431,49.083132,100.0,37.77777778]
[null,null,null,3.718,1.640150894,192.25778,150.0,65.55555556]
[null,null,null,11.526,1.515840534,596.00946,200.0,93.33333333]
[null,null,null,29.825,null,760.0,null,100.0]
[null,null,null,67.013]

{"sheet":"TEG Dehy","index":10,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,0,2,1],[20,0,20,1]]}
[]
[null,null,"Calculates TEG Trayed column performance"]
["Input"]
[null,"Gas Rate, MMSCFD",326.0,240.0,550.0]
[null,"P, psia",1300.0,600.0,650.0]
[null,"T, °F",115.0,90.0,90.0]
[null,"Z, compressibility",0.87,0.89,0.89]
[null,"Mw",19.47,22.5,22.89]
[null,"Lbw/MMSCFD,in",76.0,60.0,45.0]
[null,"Lbw/MMSCFD,out",1.32,0.1,0.1]
[null,"Reboiler btu/gal",1400.0,1400.0,1400.0]
[null,"Number of Theoretical Trays ",3.0,4.0,4.0]
[null,"Contactor K value",0.195,0.16,0.23]
[null,"Contactor Fs",2.6,2.6,2.9]
[null,"TEG Circ Rate\nLean TEG, gpm",25.0,60.0,30.0]
[null,"Lean TEG Wt%",99.5,99.97,99.975]
[null,"Gas Heat capacity, btu/lb-°F",0.55,0.55,0.55]
[]
[]
[]
["Output"]
[null,"Contactor Tray Dia, Ft",8.49014238690455,9.980176307573352,12.416812037068716]
[null,"Contactor Packing Dia, Ft",6.60432937873557,7.089510962643583,10.003568939227499]
[null,"Rich TEG, Wt %",92.78205390740975,98.22024018934634,94.20904800050445]
[null,"activity coef",0.6181249502545983,0.5725749793166159,0.5717728193039687]
[null,"K value",0.0010763796390115179,7.71945659116522E-4,5.684012422229956E-4]
[null,"A, L/KV",3.360912185365422,12.3764110790987,4.047288112301468]
[null,"Lbw/MMSCF in eql with lean TEG",2.0542930377340394,0.09143650887420256,0.05612619486300709]
[null,"Lbw/MMSCF in Product gas",3.4333470640120023,0.09378355729135823,0.18235646408056724]
[null,"Gas Temp out, °F",117.99065208012331,92.07573466666673,91.52942463958067]
[null,"gal lean teg/lbw absorbed",1.478701765569908,6.010016694490819,1.7493419720591215]
[null,"Reboiler Duty, MMBTU/Hr",2100000.0,5040000.0,2520000.0]
[null,"Still Col Dia, ft",1.6666666666666667,2.581988897471611,1.8257418583505538]
[" ","Stripping Col Dia, ft",1.25,1.9364916731037085,1.3693063937629153]
[null,"Gas density, Lb/Ft³",4.7172713782265365,2.571349221256858,2.8339125472940863]
[null,"Lean TEG"]
["TEG ","lb/hr",13939.95,33613.9128,16807.797]
[null,"moles/hr",96.34054333333333,224.5857560544,112.25740863000004]
["Water","lb/hr",70.05,10.087200000000383,4.203000000000956]
[null,"moles/hr",3.8916666666666666,0.5604000000000213,0.2335000000000531]
[null,"Rich TEG"]
["TEG ","lb/hr",13939.95,33613.9128,16807.797]
[null,"moles/hr",96.34054333333333,224.5857560544,112.25740863000004]
["Water","lb/hr",1084.4533333333336,609.0872000000004,1033.1613333333341]
[null,"moles/hr",60.247407407407415,33.8381777777778,57.397851851851904]

{"sheet":"TEG Reboiler","index":11,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"TEG Regenerator Heat Balance"]
[]
[null,null,null,null,"Design",null,"Current"]
["Dehydrated Gas, MMSCFD",null,null,null,240.0,500.0,500.0,700.0,800.0,500.0,700.0,800.0,50.0,15.0,15.0,15.0,null,"Dehydrated Gas, MMSCFD"]
["Water Content, lb/mmscfd",null,null,null,231.0,58.0,58.0,58.0,58.0,58.0,58.0,58.0,35.0,95.0,95.0,95.0,null,"Water Content, lb/mmscfd"]
["Rich TEG In",null,"°F"," ",287.0,287.0,280.0,280.0,280.0,280.0,280.0,280.0,280.0,280.0,280.0,270.0,null,"Rich TEG In",null,"°F"]
[null,"lb/hr","(Water)",null,{"$f":"E5*E6/24","v":2310},1208.333333,1208.333333,1691.666667,1933.333333,1208.333333,1691.666667,1933.333333,72.91666667,59.375,59.375,59.375,null,null,"lb/hr","(Water)"]
[]
["Stripping Gas in ",null,"scf/gal ",null,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,null,"Stripping Gas in ",null,"scf/gal "]
[null,null,"scfm",null,{"$f":"E10*E14","v":135},90,90,90,90,120,120,120,9,9,8.90625,8.90625,null,null,null,"scfm"]
[null,null,"lb/hr",null,{"$f":"E11/379.5*22.5*60","v":480.2371542},320.1581028,320.1581028,320.1581028,320.1581028,426.8774704,426.8774704,426.8774704,32.01581028,32.01581028,{"$f":"O11/379.5*Mw_gas*60","v":31.68231225},{"$f":"P11/379.5*Mw_gas*60","v":31.68231225},null,null,null,"lb/hr"]
[null,null,"Temp",null,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,null,null,null,"Temp"]
["Lean TEG out, gpm",null,null,null,45.0,30.0,30.0,30.0,30.0,40.0,40.0,40.0,3.0,3.0,{"$f":"O5*O6*3/1440","v":2.96875},2.96875,null,"Lean TEG out, gpm"]
[null,"lb/hr",null,null,{"$f":"E14*60*9.34","v":25218},16812,16812,16812,16812,22416,22416,22416,1681.2,1681.2,1663.6875,1663.6875,null,null,"lb/hr"]
["Effluent Gas out",null,null,null,174.0,174.0,200.0,174.0,174.0,200.0,174.0,174.0,174.0,174.0,194.6,194.6,null,"Effluent Gas out"]
[null,"water out ",null,null,174.0,174.0,174.0,174.0,174.0,174.0,174.0,174.0,174.0,174.0,194.6,194.6,null,null,"water out "]
[null,"lb/hr Gas",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$10*O$14*60*Mw_gas/379.5","v":31.68231225},{"$f":"P$10*P$14*60*Mw_gas/379.5","v":31.68231225}]
["Reflux",null,"in",null,140.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,null,"Reflux",null,"in"]
[null,null,"out",null,150.0,130.0,130.0,130.0,130.0,130.0,130.0,130.0,130.0,130.0,110.0,110.0,null,null,null,"out"]
[]
[null,"Water heat, ",null,null,{"$f":"E8*($E$35+(E17-E7)*$E$34)/1000000","v":2.04897},1.071791667,1.08025,1.51235,1.7284,1.08025,1.51235,1.7284,0.0651875,0.05308125,0.054304375,{"$f":"P8*(Latent_Ht+(P17-P7)*cp_water)/1000000","v":0.054898125},null,null,"Water heat, "]
[null,"Glycol heat",null,null,{"$f":"E15*$E$31*(400-E7)/1000000","v":1.88075844},1.25383896,1.3315104,1.3315104,1.3315104,1.7753472,1.7753472,1.7753472,0.13315104,0.13315104,0.13176405,{"$f":"P15*cp_h_teg*(385-P7)/1000000","v":0.1262738813},null,null,"Glycol heat"]
[null,"Gas heat",null,null,{"$f":"cp_gas*E12*(E16-E13)/1000000","v":0.02977470356},{"$f":"cp_gas*F12*(F16-F13)/1000000","v":0.01984980237},{"$f":"cp_gas*G12*(G16-G13)/1000000","v":0.02401185771},{"$f":"cp_gas*H12*(H16-H13)/1000000","v":0.01984980237},{"$f":"cp_gas*I12*(I16-I13)/1000000","v":0.01984980237},{"$f":"cp_gas*J12*(J16-J13)/1000000","v":0.03201581028},{"$f":"cp_gas*K12*(K16-K13)/1000000","v":0.02646640316},{"$f":"cp_gas*L12*(L16-L13)/1000000","v":0.02646640316},{"$f":"cp_gas*M12*(M16-M13)/1000000","v":0.001984980237},{"$f":"cp_gas*N12*(N16-N13)/1000000","v":0.001984980237},{"$f":"cp_gas*O12*(O16-O13)/1000000","v":0.002290631176},{"$f":"P12*cp_gas*(P16-P13)/1000000","v":0.002290631176},null,null,"Gas heat"]
[null,"reflux",null,null,{"$f":"E14*9.34*60*$E$32*(E20-E19)/1000000","v":0.138699},0.416097,0.416097,0.416097,0.416097,0.554796,0.554796,0.554796,0.0416097,0.0416097,0.02287570313,{"$f":"P14*9.34*60*cp_r_teg*(P20-P19)/1000000","v":0.02287570313},null,null,"reflux"]
[null,"desup, ovhd"]
[null,"Total",null,null,{"$f":"SUM(E22:E25)","v":4.098202144},2.761577429,2.851869258,3.279807202,3.495857202,3.44240901,3.868959603,4.085009603,0.2419332202,0.2298269702,0.2112347593,0.2063383406,null,null,"Total"]
[]
[]
[null,null,"mw Gas",null,22.5]
[null,null,"Cp TEG",null,0.66]
[null,null,"Cp TEG",null,0.55]
[null,null,"cp gas",null,0.5]
[null,null,"cp water",null,1.0]
[null,null,"latent heat water",null,1000.0]
[null,null,"cp hot teg",null,0.66]

{"sheet":"TEG, CP","index":13,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,0.0,{"$f":"0.2936+0.0004439*(459.7+B3)","v":0.49766083}]
[null,10.0,0.50209983]
[null,20.0,0.50653883]
[null,30.0,0.51097783]
[null,40.0,0.51541683]
[null,50.0,0.51985583]
[null,60.0,0.52429483]
[null,70.0,0.52873383]
[null,80.0,0.53317283]
[null,90.0,0.53761183]
[null,100.0,0.54205083]
[null,110.0,0.54648983]
[null,120.0,0.55092883]
[null,130.0,0.55536783]
[null,140.0,0.55980683]
[null,150.0,0.56424583]
[null,160.0,0.56868483]
[null,170.0,0.57312383]
[null,180.0,0.57756283]
[null,190.0,0.58200183]
[null,200.0,0.58644083]
[null,210.0,0.59087983]
[null,220.0,0.59531883]
[null,230.0,0.59975783]
[null,240.0,0.60419683]
[null,250.0,0.60863583]
[null,260.0,0.61307483]
[null,270.0,0.61751383]
[null,280.0,0.62195283]
[null,290.0,0.62639183]
[null,300.0,0.63083083]
[null,310.0,0.63526983]
[null,320.0,0.63970883]
[null,330.0,0.64414783]
[null,340.0,0.64858683]
[null,350.0,0.65302583]
[null,360.0,0.65746483]
[null,370.0,0.66190383]
[null,380.0,0.66634283]
[null,390.0,0.67078183]
[null,400.0,0.67522083]
[null,410.0,0.67965983]
[null,420.0,0.68409883]
[null,430.0,0.68853783]