0% found this document useful (0 votes)
26 views10 pages

Biochem Module 4 Excel

Uploaded by

Patrick Cortes
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
26 views10 pages

Biochem Module 4 Excel

Uploaded by

Patrick Cortes
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Time X P dX/dt dP/dt 1/dx/dt 1/dp/dt

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.2 p1 = 0.09 g/L

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)

.3 0.4 0.5 0.6


/L)
Time X P dX/dt dP/dt 1/dx/dt 1/dp/dt
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
10 6.5 0.06 1.4 0.045 0.714286 22.22222
10.5 7 0.08 1.4 0.052 0.714286 19.23077
11 7.4 0.1 0.6 0.059 1.666667 16.94915
12 7.7 0.17 0.2 0.072 5 13.88889
13 7.8 0.26 0.02 0.105 50 9.52381
14 8 0.36 0 0.13 #DIV/0! 7.692308
15 8 0.47 0 0.087 #DIV/0! 11.49425
16 8 0.54 0 0.042 #DIV/0! 23.80952
17 8 0.58 0 0.021 #DIV/0! 47.61905
18 8 0.6 0 0.005 #DIV/0! 200

slope 0.302316
umax 0.302316

1/dP/dt vs. P p and x vs. t


50 0.7
45
0.6
40
35 0.5
1/dp/dt(h/g-L)

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 [Link]
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)

0.4 0.5 0.6 0.7


g/L)
dX/dt vs. X
6

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)

You might also like