Working With Vectors This problem does not involve economics, but it provides a good example of working with
vectors. We will see similar problems in combustion calculations in later chapters.
For gas or liquid systems, the relation between pressure,
temperature, and molar volume can be given by a cubic equation of state (EOS), for example, the Redlich–Kwong EOS
(Redlich and Kwong, 1949):
Develop a VBA macro procedure to calculate P if
T = 600 K and υ = 100 L/mole. Here, place Tc and Pc values
for each species on the Excel sheet. Read these values into
two VBA vectors and then solve for P for each species (using
the vectors) at the given T and υ. Write the P value for each
species on the Excel sheet. For comparison purposes, also
calculate the species pressure using the ideal gas EOS,
Pυ = RT.