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

 

Parameters to notice:

The composition of common lead

The age of lead loss

Error correlation

Optional 207Pb and 208Pb corrections

 

 

The second dialog box 

Show

 

 

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:

 

Show screenshot

rt    Observed discordance    Uncorrected ages    Correction type    Comment   

 

Corrected data

Show screenshot

Common lead    Corrected ratios    rr    Intercept age    Corrected ages

 

The header lines contain the following extra information

Show screenshot

The composition of common lead

The age of lead loss

The concordance limit used to decide which points are concordant within error, given as a multiple of s