Biochem Module 4 Excel
Biochem Module 4 Excel
Biochem Module 4 Excel
0 0.3 0.01 0 0
3 1 0.01 0.3 3.333333
6 2.3 0.01 0.55 1.818182
8 4 0.01 1 0.005 1 200
9 5.1 0.025 1.3 0.01 0.769231 100 50
10 6.5 0.06 1.4 0.045 0.714286 22.22222 45
10.5 7 0.08 1.4 0.052 0.714286 19.23077 40
11 7.4 0.1 0.6 0.059 1.666667 16.94915 35
1/dp/dt(h/g-L)
12 7.7 0.17 0.2 0.072 5 13.88889 30
13 7.8 0.26 0.02 0.105 50 9.52381 25
14 8 0.36 0 0.13 #DIV/0! 7.692308 20
15
15 8 0.47 0 0.087 #DIV/0! 11.49425
10
16 8 0.54 0 0.042 #DIV/0! 23.80952
5
17 8 0.58 0 0.021 #DIV/0! 47.61905 0
18 8 0.6 0 0.005 #DIV/0! 200 0 0.1
-0.028333 -2 Err:502
0.619632 Err:502
p and x vs. t
0.7
0.6
0.5
0.4
p(g/L0
0.3
0.1
0
0 2 4 6 8 10
Time 12
Volume Dilution rate
1 900 0.1111111111
2 600 0.1666666667
3 300 0.3333333333
dx dt
0.7 3 dX/dt vs. X
1.3 3 6
1.7 2 1/dP/dt vs. P
5
50 1.1 1
45 1.4 1 4
1/dx/dt(h/g-L)
40 0.5 0.5
35 0.4 0.5 3
1/dp/dt(h/g-L)
30 0.3 1
25 0.1 2
1
20 0.2 (0.5,14.63)
1 1
15
0 1
10 0
0 1 0 1 2 3 4 5 6
5
0
0 1
0 0 0.1 X (g/L)
1 0.2 0.3 0.4 0.5 0.6 0.7
-8 -18 X(g/L)
p and x vs. t
1/dp/dt vs. P
9 (0.527, 42.767)
50
x1 = 7.28 g/L
8 45
7 40
35
6
1/dp/dt(h/g-L)
30
5 25
X(g/L)
4 20
3 15
10
2
5
1 0
0 0.1 0.2 0.3 0.4 0.5
0
6 8 10
Time 12 14 16 18 20 X(g/L)
dX/dt vs. X
(7.28,1.236)
3 4 5 6 7 8 9
X (g/L)
s. P
(0.527, 42.767)
slope 0.302316
umax 0.302316
30
25 0.4
p(g/L0
20 (0.43,
15 0.3
8.82)
10 p1 = 0.09 g/L
0.2
5
0 0.1
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7
P(g/L) 0
0 2 4 6 8 10
Time 12
lnx
-1.203973
0
0.832909 Time vs. p and x
1.386294 9 1/dp/dt vs.XP
dX/dt vs. 0.7
1.629241 12
8 6
1.871802 0.6
7 10
5
0.5
6
48
1/dp/dt(h/g-L)
1/dx/dt(h/g-L)
5 0.4
36
4 0.3
(0.582, 57.69)
3 24
0.2
2 12
0.1
1
00
0 00 1 2 2 34 4 6 5 86 7 10 8 1209
0 2 4 6 8 10 12 14 16 18 20
P (g/L)
X (g/L)
p and x vs. t
1/dP/dt vs. P
9
x1 = 7.28 g/L 50
8 (0.572, 43)
45
7 40
35
6
1/dp/dt(h/g-L)
30
5 25
X(g/L)
4 20
15
3
10
2 5
1 0
0 0.1 0.2 0.3 0.4 0.5 0.6
0
6 8 10
Time 12 14 16 18 20 P(g/L)
vs. P
(0.572, 43)
5
50
4 45
1/dx/dt(h/g-L) 40
3 35
1/dp/dt(h/g-L)
30
2 (7.1, 0.08451)
25
1 20
15
0 10
0 1 2 3 4 5 6 7 8 9
5
X (g/L) 0
0
x1 = 7.1 g/L
1/dp/dt vs. P
9
250
8
200 7
6
1/dp/dt(h/g-L)
150 5
x(g/L)
4
100 (0.582, 57.32) 3
2
50
1
0
0 0 2
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7
P (g/L)
1/dP/dt vs. P
50
45 1/dP/dt vs. P
50 40
35 (0.572, 43)
45
1/dp/dt(h/g-L)
40 30
35 25 (.0.425, 8.83)
1/dp/dt(h/g-L)
30 20
25 15
20 10
15 5
10 0
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7
5
0 X(g/L)
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7
X(g/L)
P and X vs. t
9 0.7
8 0.6
7
0.5
6
5 0.4
P(g/L)
x(g/L)
4 0.3
3
0.2
2
p1 = 0.08451 0.1
1
0 0
0 2 4 6 8 10 12 14 16 18 20
Time
1/dx/dt(h/g-L)
0
1
2
3
4
5
6
0
1
2
dX/dt vs. X
6
4
1/dx/dt(h/g-L)
0
0 1 2 3 4 5 6 7 8 9
X (g/L)