ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This worksheet is for a straight-forward OHD computation, where site formation (turbation) is not an issue.
Formulas are built into row 2; data in row 2 are dummy variables to show how the calculation works. These two rows are protected. The rest of the worksheet is not protected.
If you need to change the headers, just unprotect the worksheet. There is no password. The Headers worksheet is also protected and contains the formulas for the OHD computation. In case you inadvertently delete the formulas in row 2 of the OHD Computation worksheet, you can copy and paste them from the Headers worksheet.
2
3
Instructions for user:
4
User must enter data in columns A through J:
5
6
RowData Description
7
ASpecimen number
8
BHydration rim mean value, microns, from OH lab
9
CHydration rim standard deviations, microns, from OH lab (if not provided by the OH lab, use 0.1 microns)
10
DSpecimen burial depth, cm
11
EGeochemical source, from the geochemical report
12
FHydration rate, in microns squared/1000 years (you'll have to look this up)
13
GEHT for the hydration rate, deg C
14
HTa, average annual temperature for your site (compute from weather records or temperature sensors), deg C
15
I Va0, annual temperature variation at the surface (hottest-month mean minus coldest-month mean,;compute from weather records or
16
temperature sensors.) deg C
17
JVd0, mean diurnal variation for the site at the surface (compute from weather records or temperature sensors), deg C
18
Once all the data are entered, highlight columns K through U starting in row 2 and <fill down>
19
The spreadsheet will then compute ages (column T) and age standard deviation (column U)
20
Age is in calendar (or calibrated) years before 2000
21
Age standard deviation is in calendar years.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100