Spreadsheet: 743185d1628275995-automate-table-creation-through-iterative-process-table-gen-from-a-formula-output_question
Sheet: UNIFAC (VLE)

 | Instructions:  Type the temperature of interest in centigrade.  Then enter the number
 | of occurences of each functional group in each component.
 | Further instructions are given in comment boxes. Use View…Comment…to show or hide them.
P= |  | mmHg
T(oC)= | 98.18626270800434 | oC
 | Table 1. [NAME] (mmHg) log10(Psat)=A-B/(T+C) where T[=] oC
 |  |  | comp1 | comp2 | comp3 | comp4 | [NAME]
 |  | A | 8.87829 | 8.07131 |  | 8.1122 | 6.87632
 |  | B | 2010.33 | 1730.63 |  | 1592.864 | 1075.78
 |  | C | 252.636 | 233.426 |  | 226.184 | 233.205
 |  | Psat[mmHg]
 |  | yi
 | Table 2. Component Structure Information and Activity Coefficient Calculation.
 |  |  | comp1 | comp2 | comp3 | comp4 | [NAME]
 |  |  | IPA | Water | C2-COOH | [NAME] | [NAME]
 |  | xi | 1e-20 |  | 1e-20 | 0.005 | 1e-20 |  |  |  |  | [NAME] |  |  |  |  |  | Q |  |  |  |  |  | Si(QiYij) |  |  |  |  |  | Qj/Si(QiYij) |  |  |  |  |  | Sj{QjYkj/(SiQiYij)} |  |  |  |  |  | ln G
 | SubGroup | gi |  |  |  |  |  | Sinj(i)xi |  | 1 | 2 | 3 | 4 | 5 | mix | 1 | 2 | 3 | 4 | 5 | mix | 1 | 2 | 3 | 4 | 5 | mix | 1 | 2 | 3 | 4 | 5 | mix | 1 | 2 | 3 | 4 | 5 | mix | 1 | 2 | 3 | 4 | 5 | mix
 | 1 |  | 2 |  | 1 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4457963310532765 | 0.731864170852193 | 0.8406202074308333 | 1 | 0.4494302136943036 |  |  |  |  |  |  |  | 0.02874349972892613 | 0.8668431328503542 | 0.7029219693408554 | 1 | 0.03983763810314898
 | 2 |  |  |  | 1 | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8679657800355303 | 0.4457963310532765 | 0.731864170852193 | 0.8406202074308333 | 1 | 0.4494302136943036 |  |  |  |  |  |  | 0.7726496604180623 | 0.02874349972892613 | 0.8668431328503542 | 0.7029219693408554 | 1 | 0.03983763810314898
 | 3 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8679657800355303 | 0.4457963310532765 | 0.731864170852193 | 0.8406202074308333 | 1 | 0.4494302136943036 |  |  |  |  |  |  | 0.7726496604180623 | 0.02874349972892613 | 0.8668431328503542 | 0.7029219693408554 | 1 | 0.03983763810314898
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.824167924818326 | 0.3769413956883754 | 0.8469427999475029 | 0.8191876369612073 | 0.8482145385762043 | 0.3810117446094321 |  |  |  |  |  |  | 0.8932178848478614 | 0.08769305468729675 | 0.9458337706561027 | 0.8241854475045003 | 1.030398791785288 | 0.09927014887963667
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.824167924818326 | 0.3769413956883754 | 0.8469427999475029 | 0.8191876369612073 | 0.8482145385762043 | 0.3810117446094321 |  |  |  |  |  |  | 0.8932178848478614 | 0.08769305468729675 | 0.9458337706561027 | 0.8241854475045003 | 1.030398791785288 | 0.09927014887963667
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.859536007895003 | 0.361726057738337 | 0.8002468147238792 | 0.8690036769735959 | 0.813822710179707 | 0.3663949428919739 |  |  |  |  |  |  | 0.9594187460292893 | 2.184947633714823e-07 | 0.956217664631579 | 0.8760840216045418 | 1.206472115755286 | 0.01351774545965501
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.859536007895003 | 0.361726057738337 | 0.8002468147238792 | 0.8690036769735959 | 0.813822710179707 | 0.3663949428919739 |  |  |  |  |  |  | 0.9594187460292893 | 2.184947633714823e-07 | 0.956217664631579 | 0.8760840216045418 | 1.206472115755286 | 0.01351774545965501
 | 14 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.427348204461655 | 1.853287374966282 | 0.7410314552241658 | 0.5013201979600064 | 0.07018492242110709 | 1.840844130396484 |  |  |  |  |  |  | 1.364518377796374 | 0.3859809143343805 | 0.9682468511478783 | 1.343620255462411 | 0.6562709140258305 | 0.3948114662087168
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6498751892993377 | 0.4584582140216811 | 0.2689556883029434 | 0.7527900455071054 | 0.1529653985051154 | 0.461167187306047 |  |  |  |  |  |  | 1.138280051612563 | 1.628124648091207 | 2.142356001173567 | 1.083160473988268 | 0.9565128559123285 | 1.636880936907841
 | 16 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1659665783225706 | 1 | 0.5752857329024155 | 0.1943868140745773 | 0.02874349972892613 | 0.9925852919570713 |  |  |  |  |  |  | 1.982152562142626 | 1 | 1.196563838797744 | 1.99855422083549 | 0.4457963310532765 | 1.007390278531451
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7900400253764165 | 0.417332912815896 | 0.4973649033939774 | 0.9479476283753266 | 0.02760555418018584 | 0.4222165880931759 |  |  |  |  |  |  | 3.370499677493309 | 5.056292638977036 | 0.6248959230756772 | 3.424391233691904 | 0.4758164798372538 | 5.060227153740239
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4770925346161944 | 1.692501645517229 | 1.192272155172908 | 0.5184875292433726 | 0.2772226724984007 | 1.681696246521124 |  |  |  |  |  |  | 1.237391320307838 | 0.2801495773169245 | 0.8141407532184641 | 1.187544749243021 | 0.9304712846938274 | 0.2913528035919084
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7641193333380624 | 1.366681211294146 | 0.8175878405992467 | 0.8889241617708232 | 0.1615169154574927 | 1.362284027757984 |  |  |  |  |  |  | 0.3980540473391862 | 0.273957218261471 | 0.4061178209325346 | 0.3859928087576904 | 0.2561893527263115 | 0.2768350086915946
 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6222116891712492 | 0.8218172509424193 | 1.218887251042403 | 0.640224363767232 | 0.5352400439204962 | 0.8201459051097046 |  |  |  |  |  |  | 0.9850432472887962 | 0.5823114868594675 | 0.6750110494262854 | 0.9459745788856294 | 0.7340678947078265 | 0.5905215190741974
 | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5898803568438726 | 0.8766393141193345 | 0.6537631237266612 | 0.6398858175612427 | 0.3484360800965701 | 0.8744602807000835 |  |  |  |  |  |  | 2.498701500992732 | 2.434544286503221 | 1.628573728123412 | 2.471140055639052 | 1.08554475328044 | 2.446536833841606
 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4939314763313447 | 0.519477387538032 | 0.1684877803959254 | 0.5788754621663859 | 0.08379148502334725 | 0.52002407593561 |  |  |  |  |  |  | 0.9750007266061276 | 2.509091987289926 | 2.475062166072527 | 0.9989828787356477 | 0.04654662606035784 | 2.507510177012497
 | 42 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3279235983613297 | 1.038673112683541 | 0.5576132269735916 | 0.3611495219989652 | 0.1674969372154331 | 1.032437316516238 |  |  |  |  |  |  | 1.653415378998279 | 1.195057480978235 | 1.150998146735056 | 1.661943038782483 | 0.4278016456420982 | 1.201083599962894
 | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8550651987013858 | 0.3688081583892207 | 0.9883219878899913 | 0.8529625730871067 | 0.8652174283464488 | 0.3732642220378761 |  |  |  |  |  |  | 0.8643947583196991 | 0.1483007797733984 | 0.8569390893356688 | 0.8054108482585071 | 0.912259751383407 | 0.1586129460258146
 | 51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.076228329712528 | 0.3857730827660828 | 0.9181010142948673 | 1.105448340886365 | 0.935143648895568 | 0.3923968347327929 |  |  |  |  |  |  | 0.7646241670196741 | 0.1078996823357847 | 0.8739215957205236 | 0.7033337910746554 | 0.9058946550821536 | 0.1179690845579397
 | 99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.297409572711921 | 0.1053727149284601 | 1.306745474635421 | 1.491861564173008 | 0.3585257034930911 | 0.1181336902967008 |  |  |  |  |  |  | 0.9685024852719659 | 3.941388868481918 | 1.688797435120682 | 0.9111382554806869 | 0.927444276472928 | 3.945271629601529
 |  | Sknk(i)xi |  |  |  |  |  |  | SiXiQi
 |  | N groups
 |  | q
 |  | r
 |  | qi
 |  | Fi
 |  | lngC
 |  | lngRo
 |  | lngR