just answer question 5 only...........in excel.,,,,,,,,

 

 

School of Chemical Engineering
Introduction to Process Modelling Tutorial 1
Excel Applications
1. Calculate the change of the vapour pressure with volume for methane at 250 K.
a) Using the ideal gas model to calculate p = f(v).
b) Using the Soave EoS for real gases that is given below.
= × − ( + ) where
= 0.42748 2 2 ;= 0.08664 ; = (1 + (0.48508 + 1.55171 − 0.15613 c) Plot the results as p = f(v) and = ( − ) 2) 0.5 (1 − ( ) 2 )) . × 100 d) Briefly discuss implications of you results.
Base your calculation on the experimental data at 250 K from the following table.
v (m3/mol)
5.39E-05
5.21E-05
5.06E-05
4.93E-05
4.83E-05
4.73E-05
4.65E-05
4.58E-05
4.51E-05
4.45E-05 p (bar)
400
450
500
550
600
650
700
750
800
850 v (m3/mol)
4.39E-05
4.34E-05
4.30E-05
4.25E-05
4.21E-05
4.17E-05
4.13E-05
4.10E-05
4.07E-05
4.04E-05 p (bar)
900
950
1000
1050
1100
1150
1200
1250
1300
1350 v (m3/mol)
4.01E-05
3.98E-05
3.95E-05
3.93E-05
3.90E-05
3.88E-05
3.86E-05
3.83E-05
3.81E-05
3.79E-05 p (bar)
1400
1450
1500
1550
1600
1650
1700
1750
1800
1850 v (m3/mol)
3.77E-05
3.75E-05
3.73E-05
3.72E-05
3.70E-05
3.68E-05
3.67E-05
3.65E-05
3.64E-05
3.62E-05 p (bar)
1900
1950
2000
2050
2100
2150
2200
2250
2300
2350 Experimental data for methane are obtained from NIST:
Tc = 190.564 K, pc = 45.992 bar and ω = 0.01142.
2. Calculate the pressure of CO2 at the conditions indicated in the table by using the van der Waals equation: − 2
− where the constants a and b for CO2 are: a = 3.59 bar·l2/mol2 and b = 0.0427 l/mol.
= v T 250 K 260 K 270 K 280 K 290 K 300 K 310 K School of Chemical Engineering
Introduction to Process Modelling 0.05 l/mol
0.10 l/mol
0.15 l/mol
0.20 l/mol
0.25 l/mol
0.30 l/mol
0.35 l/mol
0.40 l/mol
0.45 l/mol
0.50 l/mol
Note: use F4 to keep a reference cell, row or column in your equation.
3. A mixture of 80% of methane and 20% of propane reacts with oxygen in an incomplete reaction to produce
CO, CO2 and water. Plot methane and propane contributions to the heat of combustion for temperatures
from 298 to 900 K.
4. Create Excel functions to search for the critical properties of a given compound. Use these properties to
calculate the pressure for a given specific volume and temperature using Peng-Robinson EoS.
Formula
CH4
CH4O
CO
CO2
C2H6
C2H6O
C3H8
C3H8O
C6H6 Name
methane
methanol
carbon monoxide
carbon dioxide
ethane
ethanol
propane
1-propanol
benzene Mol Wt (g/mol)
16.043
32.042
28.01
44.01
30.07
46.069
44.097
60.096
78.114 Tc (K)
190.56
512.64
132.85
304.12
305.32
513.92
369.83
536.78
562.05 pc (bar)
45.99
80.97
34.94
73.74
48.72
61.48
42.48
51.75
48.95 vc (cm3/mol)
98.6
118
93.1
94.07
145.5
167
200
219
256 ω
0.011
0.565
0.045
0.225
0.099
0.649
0.152
0.629
0.21 5. The amount of instant coffee per can is usually expressed as mass. The standard deviation of the packing
operation is 20 g. Use the information in the table below to develop a quality control chart of the operation
and indicate if the process is under control or not. The table represents a collection of data for 30 samples.
5 cans are collected for each of the samples. Sample #
1
2
3
4
5 199.42
212.91
202.07
186.35
202.61 Observations (g)
185.99
190.08
183.33
185.53
194.66
188.84
208.70
201.15
189.57
218.41
191.58
212.57
218.63
206.64
211.22 180.87
181.71
203.26
191.28
188.08 School of Chemical Engineering
Introduction to Process Modelling 6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 203.13
216.27
205.94
182.91
210.26
198.38
217.74
205.63
191.73
218.58
180.93
208.72
208.87
190.28
200.81
184.06
182.89
191.36
213.83
190.43
195.86
214.40
186.90
188.82
196.41 188.78
202.27
186.06
182.30
206.77
212.89
217.96
207.09
189.47
190.46
196.41
196.14
216.30
204.21
183.03
181.24
184.56
214.61
206.73
198.05
209.45
195.83
197.15
182.64
184.58 196.68
210.12
190.71
204.82
216.55
197.60
198.74
209.32
212.46
185.11
187.46
184.62
195.80
180.86
203.51
215.34
211.30
196.58
195.95
202.54
218.35
213.47
204.89
215.70
191.18 194.03
215.10
189.78
204.12
193.21
185.60
190.48
184.86
188.99
216.78
219.42
204.28
215.95
209.33
185.62
188.60
210.84
191.16
213.26
207.21
185.18
200.56
219.92
211.38
190.63 201.06
192.37
192.49
200.50
215.18
181.04
187.34
190.65
209.30
195.40
202.37
216.22
201.21
214.70
203.34
195.32
191.36
214.72
195.97
206.64
211.27
198.10
181.95
210.82
191.34

• 1492665690-tutorial12_3.pdf

ComputerScienceExpert

(11)

Status NEW Posted 20 Apr 2017 05:04 AM My Price 7.00

-----------

Attachments

file 1492665715-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer