Databases Reference
In-Depth Information
FIGURE 9.31
Combobox automatically populated with data set names.
Sheet1.Button_Start.Visible = True
Worksheets("pKaCurveFit").Activate
End Sub
Figure 9.31 shows the Combobox on the pKaCurveFit Worksheet which is automatically
populated with the names of the datasets contained in the SampleData Worksheet.
Prior to running the sample pKa curve-fitting Workbook, fitting functions must be installed in
Origin. This can be accomplished by copying the files monopKa.fdf and bispKa.fdf from the
location \Chapter 9\Samples\Origin on the accompanying CD-ROM
to
the user's machine in the
C:\Program Files\OriginLab\OriginPro75\FitFunc folder. Once the files are in this folder, the user
must modify the nlsf.ini file located in C:\Program Files\OriginLab\OriginPro75\UserName, where
UserName is the username of the person logged into Windows. The nlsf.ini file can easily be opened
using notepad or any word processor. At the bottom of the nlsf.ini file, the following lines must be
added for Origin to utilize the pKa fitting functions.
[pKa]
monopKa=monopKa
bispKa=bispKa
Default Function=monopKa
Once the nlsf.ini file has been modified, the user is free to push the “Curve Fit Data” button
on the “pKaCurveFit” sheet and watch the sample application generate the fitted curves to the
sample data sets. Figure 9.32 shows the results when the data sets are created for the bispKa
system named “bis01.” Figure 9.33 shows the results generated for the single pKa system named
“mono01.”
