bloodtalon
New Member
- Joined
- Aug 7, 2014
- Messages
- 2
So I have a file here where I want to do something.
http://www.egr.msu.edu/~lira/computer/EXCEL/PREOS.XLS
If we fix P (Cell B8) and want to find where the fugacity ratio (cell H12) is 1 (i.e. system at equilibrium), I need to use solver/goalseek to vary the T (Cell B7) until H12 = 1. The problem is you often don't even have a valid fugacity ratio (cell H12) until you hit a certain, narrow range for the T. Until you do so, you can't start solver. I was wondering if there's a way (VBA/Add-in) to let excel try new values in the T cell (Cell B8) until a valid number appears in the fugacity ratio (cell H12) and then I can (or, even better, excel can) initiate solver to make the fugacity ratio (cell H12) = 1.
http://www.egr.msu.edu/~lira/computer/EXCEL/PREOS.XLS
If we fix P (Cell B8) and want to find where the fugacity ratio (cell H12) is 1 (i.e. system at equilibrium), I need to use solver/goalseek to vary the T (Cell B7) until H12 = 1. The problem is you often don't even have a valid fugacity ratio (cell H12) until you hit a certain, narrow range for the T. Until you do so, you can't start solver. I was wondering if there's a way (VBA/Add-in) to let excel try new values in the T cell (Cell B8) until a valid number appears in the fugacity ratio (cell H12) and then I can (or, even better, excel can) initiate solver to make the fugacity ratio (cell H12) = 1.
