Getting started
ComPbCorr comes as an Excel template, which ought to run with Microsoft Excel97 and later. Save the file ComPbCorr#?_??.xlt as read-only in an appropriate library directory. To use the program, open a new file from the template. You will then see a worksheet containing six lines of heading, and with a command button in the upper left corner. Paste in your data, and click the button. Choose your preferred correction options in the first dialog box to appear, and click OK. Accept the conditions shown in the next dialog box, and wait for the program to finish. Once done, corrected isotope ratios and derived parameters are written into the worksheet. Save the file with data under a separate name. The code and a hidden worksheet needed for error propagation will then be saved together with the data, and you can re-run the corrections with different parameters whenever you like, without having to import the same data into the spreadsheet a second time.
Windows Regional Settings: Please use decimal point (.) - using comma (,) as decimal symbol may cause errors !
Data input: Show screenshot with explanation
The first dialog box
gives access to the main parameters controlling the correction routine:
Show the dialog box with explanations
The composition of common lead
Optional 207Pb and 208Pb corrections
The second dialog box
Output
Corrected data are written into the right-hand part of the worksheet. There are no formulas in the worksheet, nor links between cells.
Parameters derived from uncorrected data:
rt Observed discordance Uncorrected ages Correction type Comment
Corrected data
Common lead Corrected ratios rr Intercept age Corrected ages
The header lines contain the following extra information
The composition of common lead
The concordance limit used to decide which points are concordant within error, given as a multiple of s