{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["10-Tray","Flash","DIY","XY with Stair Steps","Flow","Temp","Mole","VLE","xy","Txy","Lewis"],"not_rendered":{"charts":11,"macros":1,"defined_names":198},"unopened":[{"sheet":"XY with Stair Steps","index":3,"reason":"not_a_worksheet"},{"sheet":"Flow","index":4,"reason":"not_a_worksheet"},{"sheet":"Temp","index":5,"reason":"not_a_worksheet"},{"sheet":"Mole","index":6,"reason":"not_a_worksheet"},{"sheet":"xy","index":8,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1904"}

{"sheet":"10-Tray","index":0,"n_rows":51,"n_cols":26,"rows_kept":51,"merged":[[2,7,2,8],[21,4,21,7],[21,8,21,9],[26,4,26,5]]}
["Rigorous Solution Method"]
[]
["R =",{"v":2,"d":"2.0"},null,"Specified or found by iteration",{"$nulls":3},"Feed"]
["P (mm Hg) =",760,null,"Calculations",{"$nulls":3},"T (oC)",{"v":92,"d":"92.0"}]
[]
["Stage","F (mol)","z (mol B/mol)","Fz (mol B)","D (mol)","xD (mol B/mol)","L (mol)","x (mol B/mol)","V (mol)","y (mol B/mol)","T (oC)","KB","KT","BP/DP","HBL (kJ/mol)","HTL (kJ/mol)","HBV (kJ/mol)","HTV (kJ/mol)","HF (kJ)","HLi (kJ)","Hvi (kJ)","Q (kJ)"]
["Total Cond",{"$nulls":3},50,{"v":0.9498715103663707,"d":"0.950"},{"$f":"+E7*B3","v":{"v":100,"d":"100.0"}},{"$f":"+F7","v":{"v":0.9498715103663707,"d":"0.950"}},null,null,{"v":81.12052283297412,"d":"81.1"},{"$f":"10^($B$24-$C$24/($D$24+K7))/$B$4","v":{"v":1.0317577985218531,"d":"1.032"}},{"$f":"10^($B$25-$C$25/($D$25+K7))/$B$4","v":{"v":0.3982298635498323,"d":"0.398"}},{"$f":"+H7*L7+(1-H7)*M7","v":{"v":1.0000000000009936,"d":"1.0000"}},{"$f":"+$I$24*(K7-80.1)+$J$24*(K7^2-80.1^2)/2","v":{"v":0.14834605766055045,"d":"0.15"}},{"$f":"+$I$25*(K7-110.6)+$J$25*(K7^2-110.6^2)","v":{"v":-6.217736133652246,"d":"-6.22"}},{"$nulls":3},{"$f":"+G7*(H7*O7+(1-H7)*P7)","v":{"v":-17.077602747350493,"d":"-17.1"}},"---",{"$f":"+T7+E7*(F7*O7+(1-F7)*P7)-U8","v":{"v":-4668.926805528228,"d":"-4668.9"}}]
[1,null,null,{"$f":"+B8*C8","v":0},null,null,{"$f":"+I9+G7+B8-I8","v":{"v":98.52637342719245,"d":"98.5"}},{"$f":"+J8/L8","v":{"v":0.8802865066800419,"d":"0.880"}},{"$f":"+E7+G7","v":{"v":150,"d":"150.0"}},{"$f":"+F7","v":{"v":0.9498715103663707,"d":"0.950"}},{"v":82.59293899965198,"d":"82.6"},{"v":1.0790481316688192,"d":"1.079"},{"v":0.4187371719017387,"d":"0.419"},{"$f":"+J8/L8+(1-J8)/M8","v":{"v":1.0000000000056177,"d":"1.0000"}},{"$f":"+$I$24*(K8-80.1)+$J$24*(K8^2-80.1^2)/2","v":{"v":0.3628100614502031,"d":"0.36"}},{"$f":"+$I$25*(K8-110.6)+$J$25*(K8^2-110.6^2)","v":{"v":-5.92053899932931,"d":"-5.92"}},{"$f":"+$L$24+$E$24*(K8-80.1)+$F$24*(K8^2-80.1^2)/2+$G$24*(K8^3-80.1^3)/3+$H$24*(K8^4-80.1^4)/4","v":{"v":31.012393656242157,"d":"31.01"}},{"$f":"+$L$25+$E$25*(K8-110.6)+$F$25*(K8^2-110.6^2)/2+$G$25*(K8^3-110.6^3)/3+$H$25*(K8^4-110.6^4)/4","v":{"v":29.8754956445393,"d":"29.88"}},{"$f":"+B8*(C8*$R$24+(1-C8)*$R$25)","v":{"v":0,"d":"0.00"}},{"$f":"+G8*(H8*O8+(1-H8)*P8)","v":{"v":-38.36534262101946,"d":"-38.4"}},{"$f":"+I8*(J8*Q8+(1-J8)*R8)","v":{"v":4643.310401407202,"d":"4643.3"}},{"$f":"+T8+U8-T7-U9-S8","v":{"v":3.7252902984619141E-9,"d":"0.00000"}}]
[2,null,null,{"$f":"+B9*C9","v":0},null,null,{"$f":"+I10+G8+B9-I9","v":{"v":96.77223065166115,"d":"96.8"}},{"v":0.7858748481918179,"d":"0.786"},{"v":148.52637342719245,"d":"148.5"},{"$f":"+(I8*J8+G8*H8-B8*C8-G7*H7)/I9","v":{"v":0.9037116405740032,"d":"0.904"}},{"v":84.7085494614131,"d":"84.7"},{"v":1.1499434581133503,"d":"1.150"},{"v":0.4496826206682595,"d":"0.450"},{"v":1.0000000000220255,"d":"1.0000"},{"v":0.6718463240359882,"d":"0.67"},{"v":-5.491058054140169,"d":"-5.49"},{"v":31.223753469354676,"d":"31.22"},{"v":30.137968260237166,"d":"30.14"},{"$f":"+B9*(C9*$R$24+(1-C9)*$R$25)","v":{"v":0,"d":"0.00"}},{"v":-62.68774570587662,"d":"-62.7"},{"$f":"+I9*(J9*Q9+(1-J9)*R9)","v":{"v":4622.022661529808,"d":"4622.0"}},{"$f":"+T9+U9-T8-U10-S9","v":{"v":4.1187377064488828E-8,"d":"0.00000"}}]
[3,null,null,{"$f":"+B10*C10","v":0},null,null,{"$f":"+I11+G9+B10-I10","v":{"v":95.07593254868621,"d":"95.1"}},{"v":0.6773602650142581,"d":"0.677"},{"v":146.77223065166115,"d":"146.8"},{"v":0.8417425901503672,"d":"0.842"},{"v":87.32747298811918,"d":"87.3"},{"v":1.242680791340261,"d":"1.243"},{"v":0.4905081200387194,"d":"0.491"},{"v":0.9999999999836615,"d":"1.0000"},{"v":1.0558544050004877,"d":"1.06"},{"v":-4.955384296896882,"d":"-4.96"},{"v":31.48718469943475,"d":"31.49"},{"v":30.46495771424538,"d":"30.46"},{"$f":"+B10*(C10*$R$24+(1-C10)*$R$25)","v":{"v":0,"d":"0.00"}},{"v":-84.01005015164411,"d":"-84.0"},{"v":4597.700258403764,"d":"4597.7"},{"v":3.49427864421159e-08,"d":"0.00000"}]
[4,null,null,0,null,null,{"v":93.75475264826437,"d":"93.8"},{"v":0.5733470739103844,"d":"0.573"},{"v":145.0759325486862,"d":"145.1"},{"$f":"+(I10*J10+G10*H10-B10*C10-G9*H9)/I11","v":{"v":0.7712804765078707,"d":"0.771"}},{"v":90.0518375038285,"d":"90.1"},{"v":1.3452244052586266,"d":"1.345"},{"v":0.5360786474372081,"d":"0.536"},{"v":0.9999999999046428,"d":"1.0000"},{"v":1.4570262864587695,"d":"1.46"},{"v":-4.3934271855779565,"d":"-4.39"},{"v":31.763312711885398,"d":"31.76"},{"v":30.80753707816876,"d":"30.81"},{"v":0,"d":"0.00"},{"v":-97.41932650818643,"d":"-97.4"},{"v":4576.377953923053,"d":"4576.4"},{"v":-6.0008460422977805E-9,"d":"-0.00000"}]
[5,100,0.5,{"$f":"+B12*C12","v":50},null,null,{"v":191.94824737770782,"d":"191.9"},{"v":0.4890216565995777,"d":"0.489"},{"v":143.75475264826437,"d":"143.8"},{"v":0.7043077654769645,"d":"0.704"},{"v":92.43579336920313,"d":"92.4"},{"v":1.4402383942960384,"d":"1.440"},{"v":0.5786786043183565,"d":"0.579"},{"v":0.9999999998741498,"d":"1.0000"},{"v":1.809496671012096,"d":"1.81"},{"v":-3.8977407964253117,"d":"-3.90"},{"v":32.00668038208704,"d":"32.01"},{"v":31.109331788892916,"d":"31.11"},{"$f":"+Flash!G17","v":{"v":-81.84411213999998,"d":"-81.8"}},{"v":-212.44411182674108,"d":"-212.4"},{"v":4562.968677572511,"d":"4563.0"},{"v":4.8160345045289432E-8,"d":"0.00000"}]
[6,null,null,0,null,null,{"v":190.85944684295862,"d":"190.9"},{"v":0.4221714888986393,"d":"0.422"},{"v":141.9482473777078,"d":"141.9"},{"$f":"+(I12*J12+G12*H12-B12*C12-G11*H11)/I13","v":{"v":0.6436178474909333,"d":"0.644"}},{"v":94.45103601899396,"d":"94.5"},{"v":1.524541245478237,"d":"1.525"},{"v":0.6167611076784079,"d":"0.617"},{"v":0.9999999999254594,"d":"1.0000"},{"v":2.108489676394908,"d":"2.11"},{"v":-3.475847061933838,"d":"-3.48"},{"v":32.21367086505566,"d":"32.21"},{"v":31.365915122626053,"d":"31.37"},{"v":0,"d":"0.00"},{"v":-213.43798706296394,"d":"-213.4"},{"v":4529.788004345796,"d":"4529.8"},{"v":-5.1085407903883606E-8,"d":"-0.00000"}]
[7,null,null,0,null,null,{"v":189.89198035814653,"d":"189.9"},{"v":0.3367191666944949,"d":"0.337"},{"v":140.8594468429586,"d":"140.9"},{"v":0.5542332737499581,"d":"0.554"},{"v":97.20772351760169,"d":"97.2"},{"v":1.6459807714266934,"d":"1.646"},{"v":0.6720633310151508,"d":"0.672"},{"v":1.000000000030115,"d":"1.0000"},{"v":2.5190268118191304,"d":"2.52"},{"v":-2.8944687308631307,"d":"-2.89"},{"v":32.49868399939373,"d":"32.50"},{"v":31.719066738728852,"d":"31.72"},{"v":0,"d":"0.00"},{"v":-203.49603605761027,"d":"-203.5"},{"v":4528.794129160659,"d":"4528.8"},{"v":-8.6410182120744139E-8,"d":"-0.00000"}]
[8,null,null,{"$f":"+B15*C15","v":0},null,null,{"$f":"+I16+G14+B15-I15","v":{"v":189.40929818795246,"d":"189.4"}},{"v":0.2442173986555548,"d":"0.244"},{"v":139.8919803581465,"d":"139.9"},{"v":0.43915201392674785,"d":"0.439"},{"v":100.44981618691679,"d":"100.4"},{"v":1.7982011779026834,"d":"1.798"},{"v":0.7420758098675553,"d":"0.742"},{"v":1.0000000001303981,"d":"1.0000"},{"v":3.004127949567263,"d":"3.00"},{"v":-2.2044183460635196,"d":"-2.20"},{"v":32.836631438241426,"d":"32.84"},{"v":32.13759214017488,"d":"32.14"},{"$f":"+B15*(C15*$R$24+(1-C15)*$R$25)","v":{"v":0,"d":"0.00"}},{"v":-176.60536580958473,"d":"-176.6"},{"v":4538.736080252423,"d":"4538.7"},{"v":-6.4920641307253391E-8,"d":"-0.00000"}]
[9,null,null,0,null,null,{"v":189.53046691183852,"d":"189.5"},{"v":0.16016066262369935,"d":"0.160"},{"v":139.40929818795246,"d":"139.4"},{"$f":"+(I15*J15+G15*H15-B15*C15-G14*H14)/I16","v":{"v":0.313828576512664,"d":"0.314"}},{"v":103.6618624690922,"d":"103.7"},{"v":1.959461027268665,"d":"1.959"},{"v":0.8170270107763206,"d":"0.817"},{"v":1.0000000001694085,"d":"1.0000"},{"v":3.487158894815799,"d":"3.49"},{"v":-1.51404622389732,"d":"-1.51"},{"v":33.17436196946268,"d":"33.17"},{"v":32.55562280702056,"d":"32.56"},{"v":0,"d":"0.00"},{"v":-135.1446801310664,"d":"-135.1"},{"v":4565.62675056537,"d":"4565.6"},{"v":-2.1222149371169508E-8,"d":"-0.00000"}]
[10,null,null,0,null,null,{"v":190.03914692197017,"d":"190.0"},{"v":0.0949100206046495,"d":"0.095"},{"v":139.53046691183854,"d":"139.5"},{"v":0.1995901060367979,"d":"0.200"},{"v":106.3535491255551,"d":"106.4"},{"v":2.102940287708886,"d":"2.103"},{"v":0.8843428963426531,"d":"0.884"},{"v":1.0000000001515312,"d":"1.0000"},{"v":3.8937968515401398,"d":"3.89"},{"v":-0.9303674487583952,"d":"-0.93"},{"v":33.459602724673196,"d":"33.46"},{"v":32.90851308048901,"d":"32.91"},{"v":0,"d":"0.00"},{"v":-89.79462111940998,"d":"-89.8"},{"v":4607.087436265109,"d":"4607.1"},{"v":8.1445250543765724E-9,"d":"0.00000"}]
["Reboiler",{"$nulls":5},{"v":49.99999999999997,"d":"50.0"},{"v":0.05012848955127262,"d":"0.050"},{"v":140.0391469219702,"d":"140.0"},{"v":0.11089895368347409,"d":"0.111"},{"v":108.31220008673372,"d":"108.3"},{"v":2.2122939405553796,"d":"2.212"},{"v":0.9360224371745045,"d":"0.936"},{"v":1.000000000110767,"d":"1.0000"},{"v":4.190759465424368,"d":"4.19"},{"v":-0.5026926763023406,"d":"-0.50"},{"v":33.66843193298339,"d":"33.67"},{"v":33.16677329883229,"d":"33.17"},{"v":0,"d":"0.00"},{"v":-13.370850482819753,"d":"-13.4"},{"v":4652.437495268621,"d":"4652.4"},{"$f":"+T18+U18-T17","v":{"v":4728.861265905211,"d":"4728.9"}}]
["Sums",{"$f":"+SUM(B8:B17)","v":100},{"$f":"+SUM(C8:C17)","v":0.5},{"$nulls":3},"XR by Overall Mol Bal",{"$f":"+(SUM(D7:D17)-E7*F7)/G18","v":{"v":0.0501284896336293,"d":"0.050"}}]
[{"$nulls":6},"D =",{"$f":"+H18-H19","v":{"v":-8.23566770336015E-11,"d":"-0.000"}}]
[]
["Antoine Constants",{"$nulls":3},"Vapor Cp (kJ/mol oC)",{"$nulls":3},"Liquid Cp (kJ/mol oC)",null,"TB (oC)","Hvap (kJ/mol)","MW","r (kg/m3)","V (L/mol)",null,"  Instructions: In a standard experiment, specify R, F, z, TF, the feed stage, and either D or xD. "]
[null,"A","B","C","a","b","c","d","a","b",{"$nulls":6},"  Go to \"Flash\" page to calculate the feed enthalpy. Follow instructions on that page. "]
["Benzene",6.89272,1203.531,219.888,{"v":0.07406,"d":"7.41E-02"},{"v":0.0003295,"d":"3.30E-04"},{"v":-2.52e-07,"d":"-2.52E-07"},{"v":7.757e-11,"d":"7.76E-11"},{"v":0.1265,"d":"1.27E-01"},{"v":2.34E-4,"d":"2.34E-04"},{"v":80.1,"d":"80.10"},30.765,78.11,879,{"$f":"+M24/N24","v":{"v":0.08886234357224118,"d":"0.0889"}},null,"  Come back to this page and run Solver. It will find V, T, and D or xD values by iteration. "]
["Toluene",6.95805,1346.773,219.693,{"v":0.09418,"d":"9.42E-02"},{"v":0.00038,"d":"3.80E-04"},{"v":-2.786e-07,"d":"-2.79E-07"},{"v":8.033e-11,"d":"8.03E-11"},{"v":0.1488,"d":"1.49E-01"},{"v":0.000324,"d":"3.24E-04"},110.62,{"v":33.47,"d":"33.470"},92.13,866,{"$f":"+M25/N25","v":{"v":0.10638568129330253,"d":"0.1064"}}]
[]
["Operating Lines",{"$nulls":3},"McCabe-Thiele",null,null,"Profiles"]
["x","y (TOL)","y (BOL)",null,"x","y",null,"Stage","L","V","Stage","T","Stage"]
[0,{"$f":"+($B$3/($B$3+1))*A29+(1/(1+$B$3))*$F$7","v":{"v":0.31662383678879025,"d":"0.3166"}},{"$f":"+($G$17/$I$18)*A29-($G$18/$I$18)*$H$18","v":{"v":-0.017898027320604925,"d":"-0.0179"}},null,{"$f":"+H7","v":{"v":0.9498715103663707,"d":"0.9499"}},{"$f":"+J8","v":{"v":0.9498715103663707,"d":"0.9499"}},null,"1",{"$f":"+G7","v":100},null,"1",{"$f":"+K7","v":{"v":81.12052283297412,"d":"81.1"}},"1"]
[0.1,{"$f":"+($B$3/($B$3+1))*A30+(1/(1+$B$3))*$F$7","v":{"v":0.3832905034554569,"d":"0.3833"}},{"$f":"+($G$17/$I$18)*A30-($G$18/$I$18)*$H$18","v":{"v":0.11780627472563644,"d":"0.1178"}},null,{"$f":"+H8","v":{"v":0.8802865066800419,"d":"0.8803"}},{"$f":"+J8","v":{"v":0.9498715103663707,"d":"0.9499"}},null,"2",{"v":98.52637342719245,"d":"99"},{"$f":"+I8","v":150},"2",{"v":82.59293899965198,"d":"82.6"},"2",null,"Results for R = 2, D = 50, F = 100, z = 0.5, TF = 92, feed to tray 5 (stage 6)"]
[0.2,{"v":0.44995717012212355,"d":"0.4500"},{"v":0.2535105767718778,"d":"0.2535"},null,{"$f":"+H8","v":{"v":0.8802865066800419,"d":"0.8803"}},{"$f":"+J9","v":{"v":0.9037116405740032,"d":"0.9037"}},null,"3",{"v":96.77223065166115,"d":"97"},{"v":148.52637342719245,"d":"149"},"3",{"v":84.7085494614131,"d":"84.7"},"3",null,null,"ChemCAD",{"$nulls":5},"Lewis"]
[0.3,{"v":0.5166238367887902,"d":"0.5166"},{"v":0.3892148788181192,"d":"0.3892"},null,{"$f":"+H9","v":{"v":0.7858748481918179,"d":"0.7859"}},{"$f":"+J9","v":{"v":0.9037116405740032,"d":"0.9037"}},null,"4",{"v":95.07593254868621,"d":"95"},{"v":146.77223065166115,"d":"147"},"4",{"v":87.32747298811918,"d":"87.3"},"4",null,"Stage","Temp","Duties","V","L","y","x","L","x","V","y","T"]
[0.4,{"v":0.583290503455457,"d":"0.5833"},{"v":0.5249191808643605,"d":"0.5249"},null,{"$f":"+H9","v":{"v":0.7858748481918179,"d":"0.7859"}},{"$f":"+J10","v":{"v":0.8417425901503672,"d":"0.8417"}},null,"5",{"v":93.75475264826437,"d":"94"},{"v":145.0759325486862,"d":"145"},"5",{"v":90.0518375038285,"d":"90.1"},"5",null,null,"(oC)","(kJ)   ","(mol)","(mol)","(mol B/mol)","(mol B/mol)","(mol)","(mol B/mol)","(mol)","(mol B/mol)","(oC)"]
[0.5,{"v":0.6499571701221236,"d":"0.6500"},{"v":0.6606234829106019,"d":"0.6606"},null,{"$f":"+H10","v":{"v":0.6773602650142581,"d":"0.6774"}},{"$f":"+J10","v":{"v":0.8417425901503672,"d":"0.8417"}},null,"6",{"v":191.94824737770782,"d":"192"},{"v":143.75475264826437,"d":"144"},"6",{"v":92.43579336920313,"d":"92.4"},"6",null,1,81.1,-4679,"           ",{"v":100,"d":"100.0"},null,{"v":0.9506506,"d":"0.951"},100,{"v":0.9542802382952019,"d":"0.954"},null,null,{"v":81.0295570824005,"d":"81.0"}]
[0.6,{"v":0.7166238367887903,"d":"0.7166"},{"v":0.7963277849568433,"d":"0.7963"},null,{"$f":"+H10","v":{"v":0.6773602650142581,"d":"0.6774"}},{"$f":"+J11","v":{"v":0.7712804765078707,"d":"0.7713"}},null,"7",{"v":190.85944684295862,"d":"191"},{"v":141.9482473777078,"d":"142"},"7",{"v":94.45103601899396,"d":"94.5"},"7",null,2,82.6,null,{"v":150,"d":"150.0"},{"v":98.69,"d":"98.7"},{"v":0.9506506666666666,"d":"0.951"},{"v":0.8818444729751502,"d":"0.882"},100,{"v":0.8900319176987995,"d":"0.890"},150,{"v":0.9542802382952019,"d":"0.954"},{"v":82.38246929093,"d":"82.4"}]
[0.7,{"v":0.7832905034554569,"d":"0.7833"},{"v":0.9320320870030846,"d":"0.9320"},null,{"$f":"+H11","v":{"v":0.5733470739103844,"d":"0.5733"}},{"$f":"+J11","v":{"v":0.7712804765078707,"d":"0.7713"}},null,"8",{"v":189.89198035814653,"d":"190"},{"v":140.8594468429586,"d":"141"},"8",{"v":97.20772351760169,"d":"97.2"},"8",null,3,84.7,null,{"v":148.69,"d":"148.7"},{"v":97.09,"d":"97.1"},{"v":0.904982610900487,"d":"0.905"},{"v":0.7880591911124752,"d":"0.788"},100,{"v":0.8007965103187394,"d":"0.801"},150,{"v":0.911448024564267,"d":"0.911"},{"v":84.36460071839576,"d":"84.4"}]
[0.8,{"v":0.8499571701221236,"d":"0.8500"},{"v":1.067736389049326,"d":"1.0677"},null,{"$f":"+H11","v":{"v":0.5733470739103844,"d":"0.5733"}},{"$f":"+J12","v":{"v":0.7043077654769645,"d":"0.7043"}},null,"9",{"v":189.40929818795246,"d":"189"},{"v":139.8919803581465,"d":"140"},"9",{"v":100.44981618691679,"d":"100.4"},"9",null,4,87.3,null,{"v":147.09,"d":"147.1"},95.5,{"v":0.8433288983737046,"d":"0.843"},{"v":0.6796079733106036,"d":"0.680"},100,{"v":0.6940200404599536,"d":"0.694"},150,{"v":0.8519577529775605,"d":"0.852"},{"v":86.91134784425228,"d":"86.9"}]
[0.9,{"v":0.9166238367887902,"d":"0.9166"},{"v":1.2034406910955675,"d":"1.2034"},null,{"$f":"+H12","v":{"v":0.4890216565995777,"d":"0.4890"}},{"$f":"+J12","v":{"v":0.7043077654769645,"d":"0.7043"}},null,"10",{"v":189.53046691183852,"d":"190"},{"v":139.40929818795246,"d":"139"},"10",{"v":103.6618624690922,"d":"103.7"},"10",null,5,90,null,145.5,{"v":94.21,"d":"94.2"},{"v":0.7727511280185019,"d":"0.773"},{"v":0.5750070323040163,"d":"0.575"},100,{"v":0.5863545886244077,"d":"0.586"},150,{"v":0.7807734397383698,"d":"0.781"},{"v":89.69864662870602,"d":"89.7"}]
[1,{"v":0.9832905034554569,"d":"0.9833"},{"v":1.339144993141809,"d":"1.3391"},null,{"$f":"+H12","v":{"v":0.4890216565995777,"d":"0.4890"}},{"$f":"+J13","v":{"v":0.6436178474909333,"d":"0.6436"}},null,"11",{"v":190.03914692197017,"d":"190"},{"v":139.53046691183854,"d":"140"},"11",{"v":106.3535491255551,"d":"106.4"},"11",null,6,92.5,null,{"v":144.21,"d":"144.2"},193.3,{"v":0.7052504679002082,"d":"0.705"},{"v":0.48979427346982907,"d":"0.490"},200,{"v":0.49453685094338046,"d":"0.495"},150,{"v":0.708996471848006,"d":"0.709"},{"v":92.27467062816167,"d":"92.3"}]
[{"$nulls":4},{"$f":"+H13","v":{"v":0.4221714888986393,"d":"0.4222"}},{"$f":"+J13","v":{"v":0.6436178474909333,"d":"0.6436"}},null,"12",{"v":49.99999999999997,"d":"50"},{"v":140.0391469219702,"d":"140"},"12",{"v":108.31220008673372,"d":"108.3"},"12",null,7,94.5,null,143.3,192.1,{"v":0.6434732516261306,"d":"0.643"},{"v":0.4217085865043041,"d":"0.422"},200,{"v":0.4227159184645936,"d":"0.423"},150,{"v":0.6441425473562414,"d":"0.644"},{"v":94.43414133746258,"d":"94.4"}]
["Feed Line","x","y",null,{"$f":"+H13","v":{"v":0.4221714888986393,"d":"0.4222"}},{"$f":"+J14","v":{"v":0.5542332737499581,"d":"0.5542"}},{"$nulls":8},8,97.3,null,142.1,190.9,{"v":0.5527319072152977,"d":"0.553"},{"v":0.33512434292718574,"d":"0.335"},200,{"v":0.33158308596281405,"d":"0.332"},150,{"v":0.5483813040511922,"d":"0.548"},{"v":97.38038200302202,"d":"97.4"}]
[null,{"$f":"+SUM(C8:C17)","v":0.5},0,null,{"$f":"+H14","v":{"v":0.3367191666944949,"d":"0.3367"}},{"$f":"+J14","v":{"v":0.5542332737499581,"d":"0.5542"}},{"$nulls":8},9,100.6,null,140.9,{"v":190.05,"d":"190.1"},{"v":0.4365323075722036,"d":"0.437"},{"v":0.24208991553351009,"d":"0.242"},200,{"v":0.2352943385155411,"d":"0.235"},150,{"v":0.42687086071548624,"d":"0.427"},{"v":100.77813705143318,"d":"100.8"}]
[null,{"$f":"+SUM(C8:C17)","v":0.5},1,null,{"$f":"+H14","v":{"v":0.3367191666944949,"d":"0.3367"}},{"$f":"+J15","v":{"v":0.43915201392674785,"d":"0.4392"}},{"$nulls":8},10,103.8,null,{"v":140.05,"d":"140.1"},{"v":189.69,"d":"189.7"},{"v":0.3109004032082438,"d":"0.311"},{"v":0.15822281663515073,"d":"0.158"},200,{"v":0.15083310429863966,"d":"0.151"},150,{"v":0.29848586411912226,"d":"0.298"},{"v":104.03548335133343,"d":"104.0"}]
[{"$nulls":4},{"$f":"+H15","v":{"v":0.2442173986555548,"d":"0.2442"}},{"$f":"+J15","v":{"v":0.43915201392674785,"d":"0.4392"}},{"$nulls":8},11,106.5,null,{"v":139.69,"d":"139.7"},{"v":189.71,"d":"189.7"},{"v":0.1971918280391976,"d":"0.197"},{"v":0.09355083571773468,"d":"0.094"},200,{"v":0.08767632028525811,"d":"0.088"},150,{"v":0.18587088516325367,"d":"0.186"},{"v":106.6635505607801,"d":"106.7"}]
["45o Line","x","y",null,{"$f":"+H15","v":{"v":0.2442173986555548,"d":"0.2442"}},{"$f":"+J16","v":{"v":0.313828576512664,"d":"0.3138"}},{"$nulls":8},12,108.4,4744,{"v":139.71,"d":"139.7"},{"v":50,"d":"50.0"},{"v":0.10937037418793288,"d":"0.109"},{"v":0.0493494,"d":"0.049"},50,{"v":0.045719730206099374,"d":"0.046"},150,{"v":0.1016618398120783,"d":"0.102"},{"v":108.51024544707965,"d":"108.5"}]
[null,0,0,null,{"$f":"+H16","v":{"v":0.16016066262369935,"d":"0.1602"}},{"$f":"+J16","v":{"v":0.313828576512664,"d":"0.3138"}}]
[null,1,1,null,{"$f":"+H16","v":{"v":0.16016066262369935,"d":"0.1602"}},{"$f":"+J17","v":{"v":0.1995901060367979,"d":"0.1996"}}]
[{"$nulls":4},{"$f":"+H17","v":{"v":0.0949100206046495,"d":"0.0949"}},{"$f":"+J17","v":{"v":0.1995901060367979,"d":"0.1996"}}]
[{"$nulls":4},{"$f":"+H17","v":{"v":0.0949100206046495,"d":"0.0949"}},{"$f":"+J18","v":{"v":0.11089895368347409,"d":"0.1109"}}]
[{"$nulls":4},{"$f":"+H18","v":{"v":0.05012848955127262,"d":"0.0501"}},{"$f":"+J18","v":{"v":0.11089895368347409,"d":"0.1109"}}]
[{"$nulls":4},{"$f":"+H18","v":{"v":0.05012848955127262,"d":"0.0501"}},{"$f":"+H19","v":{"v":0.0501284896336293,"d":"0.0501"}}]

{"sheet":"Flash","index":1,"n_rows":27,"n_cols":15,"rows_kept":27,"merged":[[3,0,3,1],[4,0,4,1],[4,3,4,8],[5,5,6,5],[5,6,6,6],[7,5,8,5],[7,6,8,6],[9,10,9,12],[10,0,10,3],[10,5,10,6],[10,10,10,12],[11,5,11,6],[11,10,11,12],[12,10,12,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[23,4,23,7],[23,8,23,9]]}
["Feed Flash","Specified or found by iteration",null,null,"Copied to or from Rigorous page"]
[null,"Calculations",null,null,"Heading"]
[]
["Data from Rigorous Page"]
["(Make any changes there!)",null,null,"Calculation of TDP and TBP based on value of z."]
["F (mol) =",{"$f":"+'10-Tray'!B19","v":100},null,"KB",{"$f":"10^(B26-C26/(D26+$G$6))/$B$8","v":{"v":1.7180193679503408,"d":"1.718"}},"TDP =",{"v":98.76960232779275,"d":"98.77"}]
["z (mol B/mol) = ",{"$f":"+'10-Tray'!C19","v":0.5},null,"KT",{"$f":"10^(B27-C27/(D27+$G$6))/$B$8","v":{"v":0.7051040224761552,"d":"0.705"}},null,{"v":0,"d":"0.00"},"DP =",{"$f":"+B7/E6+(1-B7)/E7-1","v":{"v":1.4803598302326471E-4,"d":"0.00015"}}]
["P (mm Hg) = ",{"$f":"+'10-Tray'!B4","v":760},null,"KB",{"$f":"10^(B26-C26/(D26+$G$8))/$B$8","v":{"v":1.4284257334402906,"d":"1.428"}},"TBP =",{"v":92.14616924193915,"d":"92.15"}]
["T (oC) =",{"$f":"+'10-Tray'!I4","v":{"v":92,"d":"92.0"}},null,"KT",{"$f":"10^(B27-C27/(D27+$G$8))/$B$8","v":{"v":0.5733634535665346,"d":"0.573"}},null,{"v":-3.777870668331134e+16,"d":"-37778706683311300.00"},"BP =",{"$f":"+B7*E8+(1-B7)*E9-1","v":{"v":8.9459350341258848E-4,"d":"0.00089"}}]
[{"$nulls":10},"Explanation of Logic"]
["Flash Calculation",{"$nulls":4},"Feed Enthalpy",null,null,"superheated?",{"$f":"IF(B9>G6,1,0)","v":0},"If TF > TDP, then 1, else 0"]
["KB =",{"$f":"10^(B26-C26/(D26+$B$9))/$B$8","v":{"v":1.4224926247689693,"d":"1.4225"}},"KT =",{"$f":"10^(B27-C27/(D27+$B$9))/$B$8","v":{"v":0.5706958203663202,"d":"0.5707"}},null,"Ref: Liquids at normal boiling point",null,null,"subcooled?",{"$f":"+IF(B9<G8,1,0)","v":1},"If TF < TBP, then 1, else 0"]
["x (mol B/mol) = ",{"v":0.503998344927748,"d":"0.504"},"BP =",{"$f":"+B13*B12+(1-B13)*D12-1","v":{"v":0,"d":"0.000000"}},null,"HBL (kJ/mol) =",{"$f":"+I26*($B$9-$K$26)+J26*($B$9^2-$K$26^2)/2","v":{"v":1.7449648300000007,"d":"1.74"}},null,"mixed?",{"$f":"IF(AND(B9>=G8, B9<=G6),1,0)","v":0},"If TF >= TBP and TF <= TDP, then 1, else 0"]
["y (mol B/mol) = ",{"v":0.4999999984560363,"d":"0.500"},"DP =",{"$f":"+B14/B12+(1-B14)/D12-1","v":{"v":0.2276191385763695,"d":"0.227619"}},null,"HTL (kJ/mol) =",{"$f":"+I27*($B$9-$K$27)+J27*($B$9^2-$K$27^2)/2","v":{"v":-3.3818470728000003,"d":"-3.38"}}]
["L (mol) =",{"v":0,"d":"0.0"},"Total MB =",{"$f":"+B6-B15-B16","v":{"v":0,"d":"0.000000"}},null,"HBV (kJ/mol) =",{"$f":"+L26+E26*($B$9-K26)+F26*($B$9^2-K26^2)/2+G26*($B$9^3-K26^3)/3+H26*($B$9^4-K26^4)/4","v":{"v":31.96207101139475,"d":"31.96"}},null,"Values used to calculate ",null,"Explanation of Logic"]
["V (mol) =",{"v":99.99999999999999,"d":"100.0"},"B MB =",{"$f":"+B6*B7-B15*B13-B16*B14","v":{"v":1.5439637479630619E-7,"d":"0.000000"}},null,"HTV (kJ/mol) =",{"$f":"+L27+E27*($B$9-K27)+F27*($B$9^2-K27^2)/2+G27*($B$9^3-K27^3)/3+H27*($B$9^4-K27^4)/4","v":{"v":31.051364162909373,"d":"31.05"}},null,"the feed enthalpy",null,"Subcooled","Mixed","Superheated"]
[{"$nulls":5},"HF (kJ) =",{"$f":"+J17*(J18*G15+(1-J18)*G16)+J19*(J20*G13+(1-J20)*G14)","v":{"v":-81.84411213999998,"d":"-81.8"}},null,"V (mol) =",{"$f":"IF(J11=1,B6,IF(J12=1,0,B16))","v":{"v":0,"d":"0.0"}},0,"B17","B7"]
["Instructions: Use Goal Seek twice to calculate TDP and TBP.",{"$nulls":7},"y (mol B/mol) =",{"$f":"IF(J11=1,B7,IF(J12=1,0,B14))","v":{"v":0,"d":"0.000"}},0,"B18","B8"]
["Run Solver to calculate the feed enthalpy. It is automatically input to ",{"$nulls":7},"L (mol) =",{"$f":"IF(J11=1,0,IF(J12=1,B6,B15))","v":{"v":100,"d":"100.0"}},"B7","B16",0]
["Rigorous page. ",{"$nulls":7},"x (mol B/mol =",{"$f":"IF(J11=1,0,IF(J12=1,B7,B13))","v":{"v":0.5,"d":"0.500"}},"B8","B14",0]
["If the feed is subcooled or superheated, Solver will not find an aswer."]
["However, the feed enthalpy will be correct."]
[]
["Antoine Constants",{"$nulls":3},"Vapor Cp (kJ/mol oC)",{"$nulls":3},"Liquid Cp (kJ/mol oC)",null,"TB (oC)","Hvap (kJ/mol)","MW","r (kg/m3)","V (L/mol)"]
[null,"A","B","C","a","b","c","d","a","b"]
["Benzene",6.89272,1203.531,219.888,{"v":0.07406,"d":"7.41E-02"},{"v":0.0003295,"d":"3.30E-04"},{"v":-2.52e-07,"d":"-2.52E-07"},{"v":7.757e-11,"d":"7.76E-11"},{"v":0.1265,"d":"1.27E-01"},{"v":2.34E-4,"d":"2.34E-04"},{"v":80.1,"d":"80.10"},30.765,78.11,879,{"$f":"+M26/N26","v":{"v":0.08886234357224118,"d":"0.0889"}}]
["Toluene",6.95805,1346.773,219.693,{"v":0.09418,"d":"9.42E-02"},{"v":0.00038,"d":"3.80E-04"},{"v":-2.786e-07,"d":"-2.79E-07"},{"v":8.033e-11,"d":"8.03E-11"},{"v":0.1488,"d":"1.49E-01"},{"v":0.000324,"d":"3.24E-04"},110.62,{"v":33.47,"d":"33.470"},92.13,866,{"$f":"+M27/N27","v":{"v":0.10638568129330253,"d":"0.1064"}}]

{"sheet":"DIY","index":2,"n_rows":25,"n_cols":22,"rows_kept":25,"merged":[[2,7,2,8],[21,4,21,7],[21,8,21,9],[26,4,26,5]]}
["Rigorous Solution Method"]
[]
["R =",{"v":2,"d":"2.0"},null,"Specified or found by iteration",{"$nulls":3},"Feed"]
["P (mm Hg) =",760,null,"Calculations",{"$nulls":3},"T (oC)",{"v":92,"d":"92.0"}]
[]
["Stage","F (mol)","z (mol B/mol)","Fz (mol B)","D (mol)","xD (mol B/mol)","L (mol)","x (mol B/mol)","V (mol)","y (mol B/mol)","T (oC)","KB","KT","BP/DP","HBL (kJ/mol)","HTL (kJ/mol)","HBV (kJ/mol)","HTV (kJ/mol)","HF (kJ)","HLi (kJ)","Hvi (kJ)","Q (kJ)"]
["Total Cond"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["Reboiler"]
["Sums",{"$nulls":5},"XR by Overall Mol Bal"]
[{"$nulls":6},"D ="]
[]
["Antoine Constants",{"$nulls":3},"Vapor Cp (kJ/mol oC)",{"$nulls":3},"Liquid Cp (kJ/mol oC)",null,"TB (oC)","Hvap (kJ/mol)","MW","r (kg/m3)","V (L/mol)",null,"  Instructions: In a standard experiment, specify R, F, z, TF, the feed stage, and either D or xD. "]
[null,"A","B","C","a","b","c","d","a","b",{"$nulls":6},"  Go to \"Flash\" page to calculate the feed enthalpy. Follow instructions on that page. "]
["Benzene",6.89272,1203.531,219.888,{"v":0.07406,"d":"7.41E-02"},{"v":0.0003295,"d":"3.30E-04"},{"v":-2.52e-07,"d":"-2.52E-07"},{"v":7.757e-11,"d":"7.76E-11"},{"v":0.1265,"d":"1.27E-01"},{"v":2.34E-4,"d":"2.34E-04"},{"v":80.1,"d":"80.10"},30.765,78.11,879,{"$f":"+M24/N24","v":{"v":0.08886234357224118,"d":"0.0889"}},null,"  Come back to this page and run Solver. It will find V, T, and D or xD values by iteration. "]
["Toluene",6.95805,1346.773,219.693,{"v":0.09418,"d":"9.42E-02"},{"v":0.00038,"d":"3.80E-04"},{"v":-2.786e-07,"d":"-2.79E-07"},{"v":8.033e-11,"d":"8.03E-11"},{"v":0.1488,"d":"1.49E-01"},{"v":0.000324,"d":"3.24E-04"},110.62,{"v":33.47,"d":"33.470"},92.13,866,{"$f":"+M25/N25","v":{"v":0.10638568129330253,"d":"0.1064"}}]

{"sheet":"VLE","index":7,"n_rows":105,"n_cols":11,"rows_kept":105}
["Benzene-Toluene VLE"]
[{"$nulls":4},"P (mm Hg) =",760,null,"Antoine Constants"]
["x","y","T ","pB","pT","BP",null,null,"A","B","C"]
["(mol B/mol)","(mol B/mol)","(oC)","(mm Hg)","(mm Hg)","(mm Hg)",null,"Benzene",6.89272,1203.531,219.888]
[{"v":0,"d":"0.00"},{"$f":"+A5*D5/760","v":{"v":0,"d":"0.000"}},{"v":110.62215803356158,"d":"110.6"},{"$f":"10^($I$4-$J$4/(C5+$K$4))","v":{"v":1783.552011106232,"d":"1784"}},{"$f":"10^($I$5-$J$5/($K$5+C5))","v":{"v":759.9999383114739,"d":"760"}},{"$f":"$F$2-A5*D5-(1-A5)*E5","v":{"v":6.1688526102443575E-5,"d":"0.00006"}},null,"Toluene",6.95805,1346.773,219.693]
[0.01,{"v":0.023188539647312698,"d":"0.023"},{"v":110.15096938668002,"d":"110.2"},{"$f":"10^($I$4-$J$4/(C6+$K$4))","v":{"v":1762.329013195765,"d":"1762"}},{"$f":"10^($I$5-$J$5/($K$5+C6))","v":{"v":749.8754645131736,"d":"750"}},{"$f":"$F$2-A6*D6-(1-A6)*E6","v":{"v":0,"d":"0.00000"}}]
[0.02,{"v":0.04582980648536447,"d":"0.046"},{"v":109.68504059995139,"d":"109.7"},{"$f":"10^($I$4-$J$4/(C7+$K$4))","v":{"v":1741.53264644385,"d":"1742"}},{"$f":"10^($I$5-$J$5/($K$5+C7))","v":{"v":739.9687215011455,"d":"740"}},{"$f":"$F$2-A7*D7-(1-A7)*E7","v":{"v":0,"d":"0.00000"}},null,"Instructions:","1) Select the pressure. Most examples are for 1 atm = 760 mm Hg."]
[0.03,{"v":0.06794019873940488,"d":"0.068"},{"v":109.22428647736746,"d":"109.2"},{"v":1721.151701398257,"d":"1721"},{"v":730.2736587196416,"d":"730"},{"v":0,"d":"0.00000"},null,null,"2) Run Solver to make the BP criteria equal to zero. The cell contains"]
[0.04,{"v":0.08953553665982673,"d":"0.090"},{"v":108.76862065606147,"d":"108.8"},{"v":1701.175196536708,"d":"1701"},{"v":720.7843668109698,"d":"721"},{"v":0,"d":"0.00000"},null,null,"    P - pB xB - pT (1-xB)."]
[0.05,{"v":0.11063108520264195,"d":"0.111"},{"v":108.31795843488223,"d":"108.3"},{"v":1681.5924950801575,"d":"1682"},{"v":711.4951318378868,"d":"711"},{"v":0,"d":"0.00000"},null,null,"3) The following are set and don't need to be changed:"]
[0.06,{"v":0.13124157576548,"d":"0.131"},{"v":107.87221674690446,"d":"107.9"},{"v":1662.3932930294134,"d":"1662"},{"v":702.4004281045053,"d":"702"},{"v":0,"d":"0.00000"},null,null,"    x is set from 0 to 1 by 0.01."]
[0.07,{"v":0.1513812270185394,"d":"0.151"},{"v":107.43131413180475,"d":"107.4"},{"v":1643.5676076298562,"d":"1644"},{"v":693.4949112536666,"d":"693"},{"v":0,"d":"0.00000"},null,null,"    y = pB xB/P"]
[0.08,{"v":0.17106376486842906,"d":"0.171"},{"v":106.99517070816006,"d":"107.0"},{"v":1625.105766250076,"d":"1625"},{"v":684.7734116304289,"d":"685"},{"v":0,"d":"0.00000"},null,null,"    T is found by iteration of BP"]
[0.09,{"v":0.19030244159139262,"d":"0.190"},{"v":106.56370814572325,"d":"106.6"},{"v":1606.9983956606488,"d":"1607"},{"v":676.2309279016931,"d":"676"},{"v":0,"d":"0.00000"},null,null,"    pB and pT are the partial pressures at T using Antoine's Eq."]
[{"v":0.1,"d":"0.10"},{"v":0.20911005417098408,"d":"0.209"},{"v":106.13684963772371,"d":"106.1"},{"v":1589.2364116994788,"d":"1589"},{"v":667.8626209222808,"d":"668"},{"v":0,"d":"0.00000"},null,null,"4) If you change pressure, you will need to adjust T axis on TXY VLE."]
[0.11,{"v":0.2274989618738912,"d":"0.227"},{"v":105.71451987323739,"d":"105.7"},{"v":1571.811009310521,"d":"1572"},{"v":659.6638078380262,"d":"660"},{"v":0,"d":"0.00000"}]
[0.12,{"v":0.2454811030962579,"d":"0.245"},{"v":105.29664500966716,"d":"105.3"},{"v":1554.7136529429667,"d":"1555"},{"v":651.6299564168688,"d":"652"},{"v":0,"d":"0.00000"}]
[0.13,{"v":0.2630680115115555,"d":"0.263"},{"v":104.88315264536998,"d":"104.9"},{"v":1537.9360672983246,"d":"1538"},{"v":643.7566795991011,"d":"644"},{"v":0,"d":"0.00000"}]
[0.14,{"v":0.2802708315498018,"d":"0.280"},{"v":104.4739717924634,"d":"104.5"},{"v":1521.4702284132097,"d":"1521"},{"v":636.0397302583141,"d":"636"},{"v":0,"d":"0.00000"}]
[0.15,{"v":0.29710033323669066,"d":"0.297"},{"v":104.06903284984273,"d":"104.1"},{"v":1505.3083550658994,"d":"1505"},{"v":628.4749961648408,"d":"628"},{"v":0,"d":"0.00000"}]
[0.16,{"v":0.3135669264200338,"d":"0.314"},{"v":103.66826757643447,"d":"103.7"},{"v":1489.4429004951605,"d":"1489"},{"v":621.058495143779,"d":"621"},{"v":0,"d":"0.00000"}]
[0.17,{"v":0.32968067440975624,"d":"0.330"},{"v":103.27160906471067,"d":"103.3"},{"v":1473.8665444200865,"d":"1474"},{"v":613.7863704199823,"d":"614"},{"v":0,"d":"0.00000"}]
[0.18,{"v":0.3454513070566096,"d":"0.345"},{"v":102.87899171448595,"d":"102.9"},{"v":1458.5721853501295,"d":"1459"},{"v":606.6548861426553,"d":"607"},{"v":-6.821210263296962e-13,"d":"-0.00000"}]
[0.19,{"v":0.3608882332936931,"d":"0.361"},{"v":102.4903512070159,"d":"102.5"},{"v":1443.5529331747723,"d":"1444"},{"v":599.6604230824607,"d":"600"},{"v":0,"d":"0.00000"}]
[{"v":0.2,"d":"0.20"},{"v":0.3760005531638407,"d":"0.376"},{"v":102.10562447941372,"d":"102.1"},{"v":1428.8021020225947,"d":"1429"},{"v":592.7994744943514,"d":"593"},{"v":0,"d":"0.00000"}]
[0.21,{"v":0.3907970693549865,"d":"0.391"},{"v":101.72474969939994,"d":"101.7"},{"v":1414.3132033799511,"d":"1414"},{"v":586.0686421395066,"d":"586"},{"v":0,"d":"0.00000"}]
[0.22,{"v":0.40528629826463414,"d":"0.405"},{"v":101.34766624039833,"d":"101.3"},{"v":1400.0799394596452,"d":"1400"},{"v":579.4646324601001,"d":"579"},{"v":0,"d":"0.00000"}]
[0.23,{"v":0.41947648061366344,"d":"0.419"},{"v":100.97431465698807,"d":"101.0"},{"v":1386.096196810366,"d":"1386"},{"v":572.9842529008005,"d":"573"},{"v":-5.684341886080801e-13,"d":"-0.00000"}]
[0.24,{"v":0.4333755916288525,"d":"0.433"},{"v":100.60463666072333,"d":"100.6"},{"v":1372.356040158033,"d":"1372"},{"v":566.6244083711476,"d":"567"},{"v":0,"d":"0.00000"}]
[0.25,{"v":0.44699135081261543,"d":"0.447"},{"v":100.23857509632624,"d":"100.2"},{"v":1358.853706470351,"d":"1359"},{"v":560.3820978432166,"d":"560"},{"v":0,"d":"0.00000"}]
[0.26,{"v":0.46033123131768544,"d":"0.460"},{"v":99.87607391826099,"d":"99.9"},{"v":1345.5835992363113,"d":"1346"},{"v":554.2544110791343,"d":"554"},{"v":0,"d":"0.00000"}]
[0.27,{"v":0.4734024689436911,"d":"0.473"},{"v":99.51707816769405,"d":"99.5"},{"v":1332.540282952612,"d":"1333"},{"v":548.2385254832805,"d":"548"},{"v":0,"d":"0.00000"}]
[0.28,{"v":0.4862120707718243,"d":"0.486"},{"v":99.16153394984457,"d":"99.2"},{"v":1319.7184778092374,"d":"1320"},{"v":542.3317030741853,"d":"542"},{"v":0,"d":"0.00000"}]
[0.29,{"v":0.49876682345309936,"d":"0.499"},{"v":98.80938841172751,"d":"98.8"},{"v":1307.1130545667431,"d":"1307"},{"v":536.5312875713303,"d":"537"},{"v":0,"d":"0.00000"}]
[{"v":0.3,"d":"0.30"},{"v":0.5110733011650205,"d":"0.511"},{"v":98.46058972029229,"d":"98.5"},{"v":1294.719029618052,"d":"1295"},{"v":530.834701592264,"d":"531"},{"v":0,"d":"0.00000"}]
[0.31,{"v":0.523137873250824,"d":"0.523"},{"v":98.11508704095748,"d":"98.1"},{"v":1282.5315602278263,"d":"1283"},{"v":525.2394439556145,"d":"525"},{"v":0,"d":"0.00000"}]
[0.32,{"v":0.534966711554839,"d":"0.535"},{"v":97.7728305165422,"d":"97.8"},{"v":1270.5459399427425,"d":"1271"},{"v":519.7430870857687,"d":"520"},{"v":0,"d":"0.00000"}]
[0.33,{"v":0.5465657974669089,"d":"0.547"},{"v":97.43377124659332,"d":"97.4"},{"v":1258.7575941662144,"d":"1259"},{"v":514.3432745151483,"d":"514"},{"v":0,"d":"0.00000"}]
[0.34,{"v":0.5579409286882566,"d":"0.558"},{"v":97.0978612671081,"d":"97.1"},{"v":1247.162075891397,"d":"1247"},{"v":509.03771848018914,"d":"509"},{"v":0,"d":"0.00000"}]
[0.35,{"v":0.5690977257306196,"d":"0.569"},{"v":96.76505353064964,"d":"96.8"},{"v":1235.7550615864884,"d":"1236"},{"v":503.8241976072751,"d":"504"},{"v":0,"d":"0.00000"}]
[0.36,{"v":0.5800416381599657,"d":"0.580"},{"v":96.4353018868536,"d":"96.4"},{"v":1224.5323472265943,"d":"1225"},{"v":498.70055468504063,"d":"499"},{"v":0,"d":"0.00000"}]
[0.37,{"v":0.5907779505955922,"d":"0.591"},{"v":96.10856106332301,"d":"96.1"},{"v":1213.489844466622,"d":"1213"},{"v":493.6646945196034,"d":"494"},{"v":0,"d":"0.00000"}]
[0.38,{"v":0.6013117884749503,"d":"0.601"},{"v":95.7847866469082,"d":"95.8"},{"v":1202.6235769499006,"d":"1203"},{"v":488.7145818694158,"d":"489"},{"v":0,"d":"0.00000"}]
[0.39,{"v":0.6116481235940684,"d":"0.612"},{"v":95.46393506536792,"d":"95.5"},{"v":1191.9296767474152,"d":"1192"},{"v":483.8482394565691,"d":"484"},{"v":8.526512829121202e-13,"d":"0.00000"}]
[{"v":0.4,"d":"0.40"},{"v":0.6217917794330061,"d":"0.622"},{"v":95.14596356940801,"d":"95.1"},{"v":1181.4043809227117,"d":"1181"},{"v":479.06374605152496,"d":"479"},{"v":0,"d":"0.00000"}]
[0.41,{"v":0.6317474362753704,"d":"0.632"},{"v":94.83083021509309,"d":"94.8"},{"v":1171.04402821776,"d":"1171"},{"v":474.3592346283368,"d":"474"},{"v":0,"d":"0.00000"}]
[0.42,{"v":0.6415196361305185,"d":"0.642"},{"v":94.51849384662667,"d":"94.5"},{"v":1160.845055855224,"d":"1161"},{"v":469.73289058759667,"d":"470"},{"v":0,"d":"0.00000"}]
[0.43,{"v":0.6511127874666955,"d":"0.651"},{"v":94.20891407949564,"d":"94.2"},{"v":1150.8039964527643,"d":"1151"},{"v":465.18295004440586,"d":"465"},{"v":0,"d":"0.00000"}]
[0.44,{"v":0.6605311697629799,"d":"0.661"},{"v":93.9020512839725,"d":"93.9"},{"v":1140.917475045147,"d":"1141"},{"v":460.7076981788131,"d":"461"},{"v":0,"d":"0.00000"}]
[0.45,{"v":0.6697789378875771,"d":"0.670"},{"v":93.5978665689717,"d":"93.6"},{"v":1131.1822062101303,"d":"1131"},{"v":456.3054676462545,"d":"456"},{"v":1.3926637620897964E-12,"d":"0.00000"}]
[0.46,{"v":0.6788601263096801,"d":"0.679"},{"v":93.29632176625437,"d":"93.3"},{"v":1121.594991294254,"d":"1122"},{"v":451.9746370456327,"d":"452"},{"v":1.4779288903810084E-12,"d":"0.00000"}]
[0.47,{"v":0.6877786531517504,"d":"0.688"},{"v":92.99737941497499,"d":"93.0"},{"v":1112.1527157347452,"d":"1112"},{"v":447.7136294427729,"d":"448"},{"v":0,"d":"0.00000"}]
[0.48,{"v":0.6965383240888392,"d":"0.697"},{"v":92.70100274656568,"d":"92.7"},{"v":1102.8523464739956,"d":"1103"},{"v":443.52091094708084,"d":"444"},{"v":0,"d":"0.00000"}]
[0.49,{"v":0.7051428361012364,"d":"0.705"},{"v":92.40715566995186,"d":"92.4"},{"v":1093.690929463142,"d":"1094"},{"v":439.3949893393358,"d":"439"},{"v":-9.094947017729282e-13,"d":"-0.00000"}]
[{"v":0.5,"d":"0.50"},{"v":0.713595781086451,"d":"0.714"},{"v":92.1158027570932,"d":"92.1"},{"v":1084.6655872514057,"d":"1085"},{"v":435.3344127485947,"d":"435"},{"v":0,"d":"0.00000"}]
[0.51,{"v":0.721900649336314,"d":"0.722"},{"v":91.82690922884478,"d":"91.8"},{"v":1075.7735166580367,"d":"1076"},{"v":431.33776837632905,"d":"431"},{"v":0,"d":"0.00000"}]
[0.52,{"v":0.7300608328846775,"d":"0.730"},{"v":91.54044094113205,"d":"91.5"},{"v":1067.0119865237593,"d":"1067"},{"v":427.4036812659276,"d":"427"},{"v":0,"d":"0.00000"}]
[0.53,{"v":0.7380796287310062,"d":"0.738"},{"v":91.25636437143375,"d":"91.3"},{"v":1058.3783355388014,"d":"1058"},{"v":423.5308131158195,"d":"424"},{"v":0,"d":"0.00000"}]
[0.54,{"v":0.7459602419448822,"d":"0.746"},{"v":90.97464660556761,"d":"91.0"},{"v":1049.869970144649,"d":"1050"},{"v":419.7178611345419,"d":"420"},{"v":2.5579538487363607E-13,"d":"0.00000"}]
[0.55,{"v":0.7537057886562513,"d":"0.754"},{"v":90.69525532477178,"d":"90.7"},{"v":1041.4843625068197,"d":"1041"},{"v":415.96355693610946,"d":"416"},{"v":0,"d":"0.00000"}]
[0.56,{"v":0.7613192989360209,"d":"0.761"},{"v":90.41815879307727,"d":"90.4"},{"v":1033.2190485560282,"d":"1033"},{"v":412.26666547414493,"d":"412"},{"v":3.694822225952521E-13,"d":"0.00000"}]
[0.57,{"v":0.768803719571425,"d":"0.769"},{"v":90.14332584496498,"d":"90.1"},{"v":1025.0716260952333,"d":"1025"},{"v":408.6259840132958,"d":"409"},{"v":0,"d":"0.00000"}]
[0.58,{"v":0.7761619167403666,"d":"0.776"},{"v":89.87072587330138,"d":"89.9"},{"v":1017.0397529701355,"d":"1017"},{"v":405.0403411364813,"d":"405"},{"v":-7.389644451905042e-13,"d":"-0.00000"}]
[0.59,{"v":0.7833966785887944,"d":"0.783"},{"v":89.60032881754786,"d":"89.6"},{"v":1009.1211453008199,"d":"1009"},{"v":401.50859578662886,"d":"402"},{"v":-1.5347723092418164E-12,"d":"-0.00000"}]
[{"v":0.6,"d":"0.60"},{"v":0.7905107177149646,"d":"0.791"},{"v":89.33210515223696,"d":"89.3"},{"v":1001.3135757722886,"d":"1001"},{"v":398.02963634156464,"d":"398"},{"v":1.0231815394945443E-12,"d":"0.00000"}]
[0.61,{"v":0.7975066735643184,"d":"0.798"},{"v":89.06602587571102,"d":"89.1"},{"v":993.6148719817738,"d":"994"},{"v":394.6023797208145,"d":"395"},{"v":3.410605131648481e-13,"d":"0.00000"}]
[0.62,{"v":0.8043871147384578,"d":"0.804"},{"v":88.80206249911625,"d":"88.8"},{"v":986.0229148406902,"d":"986"},{"v":391.2257705230863,"d":"391"},{"v":-7.673861546209082E-13,"d":"-0.00000"}]
[0.63,{"v":0.8111545412216841,"d":"0.811"},{"v":88.54018703564816,"d":"88.5"},{"v":978.5356370293331,"d":"979"},{"v":387.8987801933016,"d":"388"},{"v":-1.5063505998114124E-12,"d":"-0.00000"}]
[0.64,{"$f":"+A69*D69/760","v":{"v":0.8178113865282967,"d":"0.818"}},{"v":88.28037199004184,"d":"88.3"},{"v":971.1510215023523,"d":"971"},{"v":384.62040621803794,"d":"385"},{"v":8.810729923425242e-13,"d":"0.00000"}]
[0.65,{"v":0.8243600197737959,"d":"0.824"},{"v":88.02259034830249,"d":"88.0"},{"v":963.8671000432075,"d":"964"},{"v":381.38967134832916,"d":"381"},{"v":0,"d":"0.00000"}]
[0.66,{"v":0.8308027476729101,"d":"0.831"},{"v":87.76681556766954,"d":"87.8"},{"$f":"10^($I$4-$J$4/(C71+$K$4))","v":{"v":956.6819518657753,"d":"957"}},{"$f":"10^($I$5-$J$5/($K$5+C71))","v":{"v":378.20562284878747,"d":"378"}},{"$f":"$F$2-A71*D71-(1-A71)*E71","v":{"v":5.684341886080801e-13,"d":"0.00000"}}]
[0.67,{"v":0.8371418164673875,"d":"0.837"},{"v":87.51302156681125,"d":"87.5"},{"v":949.5937022615141,"d":"950"},{"v":375.0673317720801,"d":"375"},{"v":-8.952838470577262e-13,"d":"-0.00000"}]
[0.68,{"v":0.8433794137861913,"d":"0.843"},{"v":87.26118271624233,"d":"87.3"},{"v":942.600521290449,"d":"943"},{"v":371.9738922577955,"d":"372"},{"v":0,"d":"0.00000"}]
[0.69,{"v":0.8495176704407984,"d":"0.850"},{"v":87.01127382896168,"d":"87.0"},{"v":935.7006225145027,"d":"936"},{"v":368.92442085481554,"d":"369"},{"v":3.410605131648481e-13,"d":"0.00000"}]
[{"v":0.7,"d":"0.70"},{"v":0.8555586621580401,"d":"0.856"},{"v":86.76327015130319,"d":"86.8"},{"v":928.8922617715865,"d":"929"},{"v":365.9180558662998,"d":"366"},{"v":-4.831690603168681e-13,"d":"-0.00000"}]
[0.71,{"v":0.8615044112529276,"d":"0.862"},{"v":86.51714735399652,"d":"86.5"},{"v":922.1737359890494,"d":"922"},{"v":362.95395671646816,"d":"363"},{"v":-7.958078640513122e-13,"d":"-0.00000"}]
[0.72,{"v":0.8673568882437596,"d":"0.867"},{"v":86.27288152343161,"d":"86.3"},{"v":915.5433820350795,"d":"916"},{"v":360.03130333836407,"d":"360"},{"v":7.815970093361102E-13,"d":"0.00000"}]
[0.73,{"v":0.8731180134117128,"d":"0.873"},{"v":86.03044915312368,"d":"86.0"},{"v":908.9995756067148,"d":"909"},{"v":357.1492955818453,"d":"357"},{"v":0,"d":"0.00000"}]
[0.74,{"v":0.8787896583070136,"d":"0.879"},{"v":85.78982713537215,"d":"85.8"},{"v":902.5407301531492,"d":"903"},{"v":354.3071526410372,"d":"354"},{"v":0,"d":"0.00000"}]
[0.75,{"v":0.884373647203762,"d":"0.884"},{"v":85.55099275311096,"d":"85.6"},{"v":896.1652958331454,"d":"896"},{"v":351.5041125005623,"d":"352"},{"v":3.410605131648481e-13,"d":"0.00000"}]
[0.76,{"v":0.8898717585053065,"d":"0.890"},{"v":85.31392367194475,"d":"85.3"},{"v":889.8717585053065,"d":"890"},{"v":348.73943139986375,"d":"349"},{"v":-2.8421709430404007E-13,"d":"-0.00000"}]
[0.77,{"v":0.8952857261020577,"d":"0.895"},{"v":85.07859793236611,"d":"85.1"},{"v":883.6586387500829,"d":"884"},{"v":346.01238331493664,"d":"346"},{"v":6.821210263296962e-13,"d":"0.00000"}]
[0.78,{"v":0.9006172406835353,"d":"0.901"},{"v":84.84499394215094,"d":"84.8"},{"v":877.5244909224191,"d":"878"},{"v":343.3222594568776,"d":"343"},{"v":0,"d":"0.00000"}]
[0.79,{"v":0.9058679510063254,"d":"0.906"},{"v":84.6130904689266,"d":"84.6"},{"v":871.4679022339333,"d":"871"},{"v":340.66836778662855,"d":"341"},{"v":6.963318810448982e-13,"d":"0.00000"}]
[{"v":0.8,"d":"0.80"},{"v":0.9110394651196524,"d":"0.911"},{"v":84.38286663290943,"d":"84.4"},{"v":865.4874918636697,"d":"865"},{"v":338.05003254532045,"d":"338"},{"v":1.1368683772161603E-13,"d":"0.00000"}]
[0.81,{"v":0.9161333515500771,"d":"0.916"},{"v":84.15430189980692,"d":"84.2"},{"v":859.5819100963686,"d":"860"},{"v":335.46659379969236,"d":"335"},{"v":-1.2789769243681803E-13,"d":"-0.00000"}]
[0.82,{"v":0.921151140446892,"d":"0.921"},{"v":83.92737607388165,"d":"83.9"},{"v":853.7498374873633,"d":"854"},{"v":332.91740700201234,"d":"333"},{"v":-9.237055564881302e-14,"d":"-0.00000"}]
[0.83,{"v":0.9260943246896284,"d":"0.926"},{"v":83.702069291172,"d":"83.7"},{"v":847.9899840531538,"d":"848"},{"v":330.4018425640121,"d":"330"},{"v":3.979039320256561E-13,"d":"0.00000"}]
[0.84,{"v":0.9309643609590901,"d":"0.931"},{"v":83.47836201286663,"d":"83.5"},{"v":842.3010884867958,"d":"842"},{"v":327.91928544431863,"d":"328"},{"v":5.897504706808832e-13,"d":"0.00000"}]
[0.85,{"v":0.9357626707732394,"d":"0.936"},{"v":83.25623501882909,"d":"83.3"},{"v":836.6819173972494,"d":"837"},{"v":325.46913474892625,"d":"325"},{"v":-8.952838470577262e-13,"d":"-0.00000"}]
[0.86,{"v":0.94049064148922,"d":"0.940"},{"v":83.03566940126831,"d":"83.0"},{"v":831.1312645718689,"d":"831"},{"v":323.0508033442315,"d":"323"},{"v":3.694822225952521E-13,"d":"0.00000"}]
[0.87,{"v":0.9451496272727817,"d":"0.945"},{"v":82.81664655855235,"d":"82.8"},{"v":825.6479502612807,"d":"826"},{"v":320.66371748219836,"d":"321"},{"v":0,"d":"0.00000"}]
[0.88,{"v":0.9497409500362264,"d":"0.950"},{"v":82.59914818916097,"d":"82.6"},{"v":820.2308204858318,"d":"820"},{"v":318.30731643723334,"d":"318"},{"v":0,"d":"0.00000"}]
[0.89,{"v":0.9542659003460787,"d":"0.954"},{"v":82.38315628577479,"d":"82.4"},{"v":814.8787463629436,"d":"815"},{"v":315.9810521543585,"d":"316"},{"v":7.460698725481052E-13,"d":"0.00000"}]
[{"v":0.9,"d":"0.90"},{"v":0.9587257383015415,"d":"0.959"},{"v":82.16865312949696,"d":"82.2"},{"v":809.5906234546351,"d":"810"},{"v":313.684388908283,"d":"314"},{"v":1.3855583347321954E-13,"d":"0.00000"}]
[0.91,{"v":0.9631216943847757,"d":"0.963"},{"v":81.95562128420416,"d":"82.0"},{"v":804.3653711345379,"d":"804"},{"v":311.41680297300917,"d":"311"},{"v":-3.161915174132446e-13,"d":"-0.00000"}]
[0.92,{"v":0.9674549702840414,"d":"0.967"},{"v":81.74404359102452,"d":"81.7"},{"v":799.2019319737732,"d":"799"},{"v":309.17778230160405,"d":"309"},{"v":2.7711166694643907E-13,"d":"0.00000"}]
[0.93,{"v":0.9717267396906513,"d":"0.972"},{"v":81.53390316293851,"d":"81.5"},{"v":794.0992711450483,"d":"794"},{"v":306.9668262157787,"d":"307"},{"v":5.506706202140776e-13,"d":"0.00000"}]
[0.94,{"v":0.9759381490706611,"d":"0.976"},{"v":81.32518337950074,"d":"81.3"},{"v":789.0563758443643,"d":"789"},{"v":304.78344510495725,"d":"305"},{"v":1.2434497875801753E-13,"d":"0.00000"}]
[0.95,{"v":0.980090318412205,"d":"0.980"},{"v":81.11786788167844,"d":"81.1"},{"v":784.072254729764,"d":"784"},{"v":302.6271601344858,"d":"303"},{"v":-9.059419880941277e-14,"d":"-0.00000"}]
[0.96,{"v":0.9841843419493324,"d":"0.984"},{"v":80.91194056680591,"d":"80.9"},{"v":779.1459373765548,"d":"779"},{"v":300.4975029627054,"d":"300"},{"v":-8.331113576787175e-13,"d":"-0.00000"}]
[0.97,{"v":0.9882212888631614,"d":"0.988"},{"v":80.7073855836495,"d":"80.7"},{"v":774.2764737484564,"d":"774"},{"v":298.39401546654534,"d":"298"},{"v":9.965361869035405e-13,"d":"0.00000"}]
[0.98,{"v":0.9922022039611739,"d":"0.992"},{"v":80.50418732758315,"d":"80.5"},{"v":769.4629336841757,"d":"769"},{"v":296.31624947539063,"d":"296"},{"v":4.3520742565306136E-14,"d":"0.00000"}]
[0.99,{"v":0.9961281083353573,"d":"0.996"},{"v":80.30233043586927,"d":"80.3"},{"v":764.7044063988601,"d":"765"},{"v":294.2637665129106,"d":"294"},{"v":-6.359357485052897e-13,"d":"-0.00000"}]
[{"v":1,"d":"1.00"},{"v":1.000000000000001,"d":"1.000"},{"v":80.10179978304483,"d":"80.1"},{"v":760.0000000000008,"d":"760"},{"v":292.23613754660755,"d":"292"},{"v":-7.958078640513122e-13,"d":"-0.00000"}]

{"sheet":"Txy","index":9,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Lewis","index":10,"n_rows":52,"n_cols":14,"rows_kept":52,"merged":[[27,4,27,5]]}
["Lewis Method (Benzene-Toluene)"]
[]
["R =",{"v":2,"d":"2.0"},null,"Specified or found by iteration"]
["P (mm Hg) =",760,null,"Calculations"]
[]
["Stage","F (mol)","z (mol B/mol)","Fz (mol B)","D (mol)","xD (mol B/mol)","L (mol)","x (mol B/mol)","V (mol)","y (mol B/mol)","T (oC)","KB","KT","BP/DP"]
["Total Cond",{"$nulls":3},50,{"v":0.9542802382952019,"d":"0.954"},{"$f":"+E7*B3","v":100},{"$f":"+F7","v":{"v":0.9542802382952019,"d":"0.954"}},null,null,{"v":81.0295570824005,"d":"81.0"},{"$f":"10^($B$24-$C$24/($D$24+K7))/$B$4","v":{"v":1.028890333553056,"d":"1.029"}},{"$f":"10^($B$25-$C$25/($D$25+K7))/$B$4","v":{"v":0.39698997829288457,"d":"0.397"}},{"$f":"+H7*L7+(1-H7)*M7","v":{"v":0.9999999998893836,"d":"1.0000"}}]
[1,null,null,{"$f":"+B8*C8","v":0},null,null,{"$f":"+I9+G7+B8-I8","v":100},{"$f":"+J8/L8","v":{"v":0.8900319176987995,"d":"0.890"}},{"$f":"+E7+G7","v":150},{"$f":"+F7","v":{"v":0.9542802382952019,"d":"0.954"}},{"v":82.38246929093,"d":"82.4"},{"v":1.0721865354700066,"d":"1.072"},{"v":0.4157548355539639,"d":"0.416"},{"$f":"+J8/L8+(1-J8)/M8","v":{"v":0.9999999993541331,"d":"1.0000"}}]
[2,null,null,{"$f":"+B9*C9","v":0},null,null,{"$f":"+I10+G8+B9-I9","v":100},{"v":0.8007965103187394,"d":"0.801"},{"$f":"+I8","v":150},{"$f":"+(I8*J8+G8*H8-B8*C8-G7*H7)/I9","v":{"v":0.911448024564267,"d":"0.911"}},{"v":84.36460071839576,"d":"84.4"},{"v":1.1381768187294987,"d":"1.138"},{"v":0.444530248715136,"d":"0.445"},{"v":0.9999999969018963,"d":"1.0000"}]
[3,null,null,0,null,null,100,{"v":0.6940200404599536,"d":"0.694"},{"$f":"+I9","v":150},{"v":0.8519577529775605,"d":"0.852"},{"v":86.91134784425228,"d":"86.9"},{"v":1.2275693831736265,"d":"1.228"},{"v":0.48382989188837594,"d":"0.484"},{"v":0.9999999923075633,"d":"1.0000"}]
[4,null,null,0,null,null,100,{"v":0.5863545886244077,"d":"0.586"},150,{"v":0.7807734397383698,"d":"0.781"},{"v":89.69864662870602,"d":"89.7"},{"v":1.3315721491496642,"d":"1.332"},{"v":0.5299867019477298,"d":"0.530"},{"v":0.9999999866239438,"d":"1.0000"}]
[5,100,0.5,{"$f":"+B12*C12","v":50},null,null,200,{"v":0.49453685094338046,"d":"0.495"},150,{"v":0.708996471848006,"d":"0.709"},{"v":92.27467062816167,"d":"92.3"},{"v":1.433657513076167,"d":"1.434"},{"v":0.5757168626743225,"d":"0.576"},{"v":0.9999997738117903,"d":"1.0000"}]
[6,null,null,0,null,null,200,{"v":0.4227159184645936,"d":"0.423"},150,{"$f":"+(I12*J12+G12*H12-B12*C12-G11*H11)/I13","v":{"v":0.6441425473562414,"d":"0.644"}},{"v":94.43414133746258,"d":"94.4"},{"v":1.5238189981014267,"d":"1.524"},{"v":0.6164337462431501,"d":"0.616"},{"v":1.0000001032006316,"d":"1.0000"}]
[7,null,null,0,null,null,200,{"v":0.33158308596281405,"d":"0.332"},150,{"v":0.5483813040511922,"d":"0.548"},{"v":97.38038200302202,"d":"97.4"},{"v":1.6538277350874628,"d":"1.654"},{"v":0.6756540615162417,"d":"0.676"},{"v":1.0000001379306893,"d":"1.0000"}]
[8,null,null,{"$f":"+B15*C15","v":0},null,null,200,{"v":0.2352943385155411,"d":"0.235"},150,{"v":0.42687086071548624,"d":"0.427"},{"v":100.77813705143318,"d":"100.8"},{"v":1.8141994550680258,"d":"1.814"},{"v":0.7494766472619303,"d":"0.749"},{"v":1.000000138727371,"d":"1.0000"}]
[9,null,null,0,null,null,200,{"v":0.15083310429863966,"d":"0.151"},150,{"$f":"+(I15*J15+G15*H15-B15*C15-G14*H14)/I16","v":{"v":0.29848586411912226,"d":"0.298"}},{"v":104.03548335133343,"d":"104.0"},{"v":1.9789148112216786,"d":"1.979"},{"v":0.8261203418817702,"d":"0.826"},{"v":1.0000001085669774,"d":"1.0000"}]
[10,null,null,0,null,null,200,{"v":0.08767632028525811,"d":"0.088"},150,{"v":0.18587088516325367,"d":"0.186"},{"v":106.6635505607801,"d":"106.7"},{"v":2.11996676592398,"d":"2.120"},{"v":0.8923686500343432,"d":"0.892"},{"v":1.0000000721398468,"d":"1.0000"}]
["Reboiler",{"$nulls":5},50,{"v":0.045719730206099374,"d":"0.046"},150,{"v":0.1016618398120783,"d":"0.102"},{"v":108.51024544707965,"d":"108.5"},{"v":2.223587920440436,"d":"2.224"},{"v":0.941377651077773,"d":"0.941"},{"v":1.0000000439138064,"d":"1.0000"}]
[{"$nulls":6},"XR by Overall Mol Bal",{"$f":"+(SUM(D7:D17)-E7*F7)/G18","v":{"v":0.04571976170479815,"d":"0.046"}}]
[{"$nulls":6},"D =",{"$f":"+H18-H19","v":{"v":-3.1498698774279354E-8,"d":"-0.000"}}]
[]
["Antoine Constants",{"$nulls":4},"Instructions: "]
[null,"A","B","C",null,"1) Use Solver to set BP/DP Criteria (Column N) to 1.000 and D to 0 by changing T (Column K) and something else."]
["Benzene",6.89272,1203.531,219.888,null,"2) Set R (B3), xD (F7), P (B4) and/or D (E7) according to specifications and let one of them be a variable (that \"something else\")."]
["Toluene",6.95805,1346.773,219.693,null,"3) F and Z can be applied to any stage. Saturated liquid feed only."]
[{"$nulls":5},"4) If you change the pressure, don't forget to change the pressure on the VLE diagrams."]
[]
["Operating Lines",{"$nulls":3},"McCabe-Thiele",null,null,"Profiles"]
["x","y (TOL)","y (BOL)",null,"x","y",null,"Stage","L","V","T","x","y"]
[0,{"$f":"+($B$3/($B$3+1))*A30+(1/(1+$B$3))*$F$7","v":{"v":0.3180934127650673,"d":"0.3181"}},{"$f":"+($G$17/$I$18)*A30-($G$18/$I$18)*$H$18","v":{"v":-0.015239910068699791,"d":"-0.0152"}},null,{"$f":"+H7","v":{"v":0.9542802382952019,"d":"0.9543"}},{"$f":"+J8","v":{"v":0.9542802382952019,"d":"0.9543"}},null,"1",{"$f":"+G7","v":100},0,{"$f":"+K7","v":{"v":81.0295570824005,"d":"81.0"}},{"$f":"+H7","v":{"v":0.9542802382952019,"d":"0.954"}},{"$f":"+J7","v":{"v":0,"d":"0.000"}}]
[0.1,{"$f":"+($B$3/($B$3+1))*A31+(1/(1+$B$3))*$F$7","v":{"v":0.38476007943173396,"d":"0.3848"}},{"$f":"+($G$17/$I$18)*A31-($G$18/$I$18)*$H$18","v":{"v":0.11809342326463354,"d":"0.1181"}},null,{"$f":"+H8","v":{"v":0.8900319176987995,"d":"0.8900"}},{"$f":"+J8","v":{"v":0.9542802382952019,"d":"0.9543"}},null,"2",100,{"$f":"+I8","v":150},{"v":82.38246929093,"d":"82.4"},{"$f":"+H8","v":{"v":0.8900319176987995,"d":"0.890"}},{"$f":"+J8","v":{"v":0.9542802382952019,"d":"0.954"}}]
[0.2,{"v":0.4514267460984006,"d":"0.4514"},{"v":0.25142675659796687,"d":"0.2514"},null,{"$f":"+H8","v":{"v":0.8900319176987995,"d":"0.8900"}},{"$f":"+J9","v":{"v":0.911448024564267,"d":"0.9114"}},null,"3",100,150,{"v":84.36460071839576,"d":"84.4"},{"v":0.8007965103187394,"d":"0.801"},{"v":0.911448024564267,"d":"0.911"}]
[0.3,{"v":0.5180934127650673,"d":"0.5181"},{"v":0.3847600899313002,"d":"0.3848"},null,{"$f":"+H9","v":{"v":0.8007965103187394,"d":"0.8008"}},{"$f":"+J9","v":{"v":0.911448024564267,"d":"0.9114"}},null,"4",100,150,{"v":86.91134784425228,"d":"86.9"},{"v":0.6940200404599536,"d":"0.694"},{"v":0.8519577529775605,"d":"0.852"}]
[0.4,{"v":0.584760079431734,"d":"0.5848"},{"v":0.5180934232646335,"d":"0.5181"},null,{"$f":"+H9","v":{"v":0.8007965103187394,"d":"0.8008"}},{"$f":"+J10","v":{"v":0.8519577529775605,"d":"0.8520"}},null,"5",100,150,{"v":89.69864662870602,"d":"89.7"},{"v":0.5863545886244077,"d":"0.586"},{"v":0.7807734397383698,"d":"0.781"}]
[0.5,{"v":0.6514267460984007,"d":"0.6514"},{"v":0.6514267565979668,"d":"0.6514"},null,{"$f":"+H10","v":{"v":0.6940200404599536,"d":"0.6940"}},{"$f":"+J10","v":{"v":0.8519577529775605,"d":"0.8520"}},null,"6",200,150,{"v":92.27467062816167,"d":"92.3"},{"v":0.49453685094338046,"d":"0.495"},{"v":0.708996471848006,"d":"0.709"}]
[0.6,{"v":0.7180934127650673,"d":"0.7181"},{"v":0.7847600899313001,"d":"0.7848"},null,{"$f":"+H10","v":{"v":0.6940200404599536,"d":"0.6940"}},{"$f":"+J11","v":{"v":0.7807734397383698,"d":"0.7808"}},null,"7",200,150,{"v":94.43414133746258,"d":"94.4"},{"v":0.4227159184645936,"d":"0.423"},{"v":0.6441425473562414,"d":"0.644"}]
[0.7,{"v":0.784760079431734,"d":"0.7848"},{"v":0.9180934232646334,"d":"0.9181"},null,{"$f":"+H11","v":{"v":0.5863545886244077,"d":"0.5864"}},{"$f":"+J11","v":{"v":0.7807734397383698,"d":"0.7808"}},null,"8",200,150,{"v":97.38038200302202,"d":"97.4"},{"v":0.33158308596281405,"d":"0.332"},{"v":0.5483813040511922,"d":"0.548"}]
[0.8,{"v":0.8514267460984006,"d":"0.8514"},{"v":1.051426756597967,"d":"1.0514"},null,{"$f":"+H11","v":{"v":0.5863545886244077,"d":"0.5864"}},{"$f":"+J12","v":{"v":0.708996471848006,"d":"0.7090"}},null,"9",200,150,{"v":100.77813705143318,"d":"100.8"},{"v":0.2352943385155411,"d":"0.235"},{"v":0.42687086071548624,"d":"0.427"}]
[0.9,{"v":0.9180934127650673,"d":"0.9181"},{"v":1.1847600899313002,"d":"1.1848"},null,{"$f":"+H12","v":{"v":0.49453685094338046,"d":"0.4945"}},{"$f":"+J12","v":{"v":0.708996471848006,"d":"0.7090"}},null,"10",200,150,{"v":104.03548335133343,"d":"104.0"},{"v":0.15083310429863966,"d":"0.151"},{"v":0.29848586411912226,"d":"0.298"}]
[1,{"v":0.9847600794317339,"d":"0.9848"},{"v":1.3180934232646335,"d":"1.3181"},null,{"$f":"+H12","v":{"v":0.49453685094338046,"d":"0.4945"}},{"$f":"+J13","v":{"v":0.6441425473562414,"d":"0.6441"}},null,"11",200,150,{"v":106.6635505607801,"d":"106.7"},{"v":0.08767632028525811,"d":"0.088"},{"v":0.18587088516325367,"d":"0.186"}]
[{"$nulls":4},{"$f":"+H13","v":{"v":0.4227159184645936,"d":"0.4227"}},{"$f":"+J13","v":{"v":0.6441425473562414,"d":"0.6441"}},null,"12",50,150,{"v":108.51024544707965,"d":"108.5"},{"v":0.045719730206099374,"d":"0.046"},{"v":0.1016618398120783,"d":"0.102"}]
["Feed Line","x","y",null,{"$f":"+H13","v":{"v":0.4227159184645936,"d":"0.4227"}},{"$f":"+J14","v":{"v":0.5483813040511922,"d":"0.5484"}}]
[null,{"$f":"+SUM(C8:C17)","v":0.5},0,null,{"$f":"+H14","v":{"v":0.33158308596281405,"d":"0.3316"}},{"$f":"+J14","v":{"v":0.5483813040511922,"d":"0.5484"}}]
[null,{"$f":"+SUM(C8:C17)","v":0.5},1,null,{"$f":"+H14","v":{"v":0.33158308596281405,"d":"0.3316"}},{"$f":"+J15","v":{"v":0.42687086071548624,"d":"0.4269"}}]
[{"$nulls":4},{"$f":"+H15","v":{"v":0.2352943385155411,"d":"0.2353"}},{"$f":"+J15","v":{"v":0.42687086071548624,"d":"0.4269"}}]
["45o Line","x","y",null,{"$f":"+H15","v":{"v":0.2352943385155411,"d":"0.2353"}},{"$f":"+J16","v":{"v":0.29848586411912226,"d":"0.2985"}}]
[null,0,0,null,{"$f":"+H16","v":{"v":0.15083310429863966,"d":"0.1508"}},{"$f":"+J16","v":{"v":0.29848586411912226,"d":"0.2985"}}]
[null,1,1,null,{"$f":"+H16","v":{"v":0.15083310429863966,"d":"0.1508"}},{"$f":"+J17","v":{"v":0.18587088516325367,"d":"0.1859"}}]
[{"$nulls":4},{"$f":"+H17","v":{"v":0.08767632028525811,"d":"0.0877"}},{"$f":"+J17","v":{"v":0.18587088516325367,"d":"0.1859"}}]
[{"$nulls":4},{"$f":"+H17","v":{"v":0.08767632028525811,"d":"0.0877"}},{"$f":"+J18","v":{"v":0.1016618398120783,"d":"0.1017"}}]
[{"$nulls":4},{"$f":"+H18","v":{"v":0.045719730206099374,"d":"0.0457"}},{"$f":"+J18","v":{"v":0.1016618398120783,"d":"0.1017"}}]
[{"$nulls":4},{"$f":"+H18","v":{"v":0.045719730206099374,"d":"0.0457"}},{"$f":"+H19","v":{"v":0.04571976170479815,"d":"0.0457"}}]