| T O P I C R E V I E W |
| JPP1989 |
Posted - 09/02/2013 : 10:39:21 AM
Hey comunity,
I am a biotechnologist and doing my bachelor of science.
For that I d like to calculate the specific glucose consumption rate (mol / (h*g cell mass)^-1) for my bacteria cultivation.
I got all datas at hand (see below).
In theory I know how to proceed:
1) Form the 1st derivative of glucose vs time curve (Result: glucose consumption rate in [mM/h]
2) Divide every single value by the cell mass (result: specific glucose consumption rate)
In order to accomplish this task I need to create a spline curve, which accurately describes my glucose vs time curve.
When I try to do it I get a very kinky curve without any use (see below):
That's what I did:
Choose "Spline" (Line -->"Connect" --> Spline) and then I did a Interpolation/Extrapolation with either 45, 300 or 1000 values. None of these different attempts were successfull.
Please help me out.
Thanks in advance.
Greetings from Germany.  |
| 1 L A T E S T R E P L I E S (Newest First) |
| Hideo Fujii |
Posted - 09/03/2013 : 11:14:16 AM
Hi Jan,
It seems your result didn't take the correct X values because the Glucose slope should be negative.
Probably you consider the following procedure (see the screenshot below):
1) Run the interpolation (to get column B(Y#). Here # indicates that X's initial and intervals are assumed and hidden).
2) Run the Differentiate (to get column D(Y#) ).
3) Run the interpolation with the same X range and the number of points to 1) so that column D
and column G have the same X set.
4) Run "Column: Show X Column" menu for column G, with "Clear Sampling Interval" check box to
create the real X column. (col(H) at left of col(G) is created.)
5) Run Set Column Values tool to get column I as col(D)/col(G). When col(I) is plotted, col(H) is used as its X.
Hope this helps.
--Hideo Fujii
OriginLab |
|
|
