Calculate the vapor pressures for several pure components

Assignment Help Computer Engineering

Reference no: EM132216523

Question :

Write a VBA-Excel program that calculates the vapor pressures for several pure components at different temperatures.

Your program should read in the species names and the Antoine equation (which gives the vapor pressure as a function of temperature) constants from a worksheet.

Your program should then output the vapor pressure of each species to a different worksheet over a temperature range of 0 to 100°C in increments of 10°C. Use arrays whenever possible.

Substance	A	B	C
Chloroform	6.90328	1163.03	227.4
Cyclohexane	6.84498	1203.526	222.863
Ethyl acetate	7.09808	1238.71	217
Methyl alcohol	7.87863	1473.11	230
n-Heptane	6.9024	1268.115	216.9

Antoine Equation Constants:

Antoine equation: log₁₀p* = A - B/(T+C) p* in mm Hg, T in °C

Reference no: EM132216523

Questions Cloud

Write vhdl test bench model to simulate the fibonacci : Write VHDL test bench model to simulate the Fibonacci Calculator model. This model, testbench model has no inputs.

Write a function to compute fibonacci numbers : Write a function to compute fibonacci numbers (in the sequence 0, 1, 1, 2, 3, 5, ... where each number is the sum of the previous two numbers on the list).

Write a code segment that prompts the user to enter sentence : Write a code segment that prompts the user to enter a sentence and then displays all of the words in the sentence.

Write a value returning function named sumofodds : Write a value returning function named sumofodds that takes two int parameters.

Calculate the vapor pressures for several pure components : Write a VBA-Excel program that calculates the vapor pressures for several pure components at different temperatures.

Simulate the roll of a pair of six-sided dice : Write a VBA script that randomly simulates the roll of a pair of six-sided dice and writes the sum of the roll to column A of the worksheet.

Write a vba script that looks for a cell between a1 and a10 : Write a VBA script (Macro) that looks for a cell between A1 and A10 that contains the number 5.

Write and test a function that is passed an array : Write and test a function that is passed an array of n integers and returns a pointer to the array cell that has the maximum value among the n integers.

Write three paragraphs or record a 1 min video : Write three paragraphs or record a 1 min video discussing the importance of documenting network problems and solutions.

User Account

All Pages