The data source is either an Excel spreadsheet (or multiple spreadsheets) or an instrument via a custom DLL.In addition to curve fitting, the Automation feature is available for other TableCurve features such as noise filtering, smoothing, local regression, splines and autoregressive modeling and prediction.An example is the analysis of regional pulmonary ventilation of a 133Xe airway bolus using a scintillation camera.Since the bolus of xenon initially washes into the lung and subsequently washes out, we would expect one of the TableCurve intermediate kinetic functions to fit the data.
See the TableCurve PDF nonlinear equation documentation for description of the intermediate functions. They represent measurement from the middle of three compartments. In our case the middle compartment is the lung with the airway and recirculation-via-organ-systems being the first and third compartments, respectively. We want to fit all ten data sets as a batch and place the results in a Word file. Open TableCurve and Import the file regional 133Xe washout.xls that you have downloaded. The Select Columns dialog, Figure 2, shows the data in columns A K of the Excel worksheet. This data is in X Many Y format with the X data in column A and the ten Y data sets in columns B - K. For each tab select Clear to deselect the equations except for the Kinetic tab - select all Kinetic equations. ![]() ![]() The data source is the Excel file regional 133Xe washout.xls. The Word output file is 133Xe washout output.doc. Two output options, Curve-Fit Graph and Numeric Summary, are selected to view the curve fit results and obtain numeric parameter values for the ten data sets. These are the options selected in the Data Source group box in Figure 5. Select the options in the Output group box in Figure 5 to put the ten data set curve fit results in the Word document 133Xe washout output.doc. Click OK to curve fit the ten data sets with the Intermed11 c Results of the Automated Fit Graphs for the fit to each data set and the numerical fit results are placed into the Word document. The results for the second data set are representative and are shown in Figure 6. Of physiological interest, the clearance constant (c parameter) is 0.058 sec-1. For all data sets this clearance rate ranges from 0.028 to 0.065 sec-1 with corresponding time constants of 35 (apical lung region) to 15 seconds (basal lung region). Processing TableCurve Results The Word file is an excellent report format but if you want to continue to process the results of TableCurve Automation then use the Excel output option. For example, you might create a table of lung clearance constant (c parameter) results for the ten data sets as a function of distance from lung apex to base.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |