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.
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.
How to create a proper splinecurve?
Posted - 09/02/2013 : 10:39:21 AM
