WHOI Mass Spec Data entry

We are able to use four columns of information to uniquely identify each analysis run on the mass spec. We now provide an EXCEL sample spreadsheet template which you can download. After reading this section and asking questions of our staff, you should be able to fill out the spreadsheet with all the samples ou are submitting for analysis. Please email the completed spreadsheet to your WHOI contact and we can use this spreadsheet to run your samples. No one knows your data better than you, so whom better to fill out the running sequence.

Weight or Depth Column
We only enter either depth in core or sample weight in this column. If you enter a depth in core, we suggest that you use a range describing the width of the sample slab taken from the core. The database will automatically calculate and return the mid-depth of the range for use in plotting downcore data. Sample weights are always in micrograms, but must be of the correct units in the preparation field column. Sample depths can be of any unit but those units must be described in the preparation field column. The database converts all units of depth to centimeters.

94 the weight of the standard which requires "u:ug" flag in the preparation field
22 the sample depth of unknown range which requires the "u:cm" flag in the preparation field
105-107 the sample range which requires the "u:cm" flag in the preparation field
4492 the sample depth in feet which requires the "u:ft" flag in the preparation field

Identification 1
We normally use this column for a description of the Cruise and core from which the sample was taken. Please use an identification which describes most of the data. We use all upper case characters for this field.


Identification 2
We normally put the genus and species information in this column. The first letter of the genus is always in capitals and the species is in lower case. You may also put the color and coiling direction using a "-" after the species. N. pachyderma is shortened to "pachy" as there is a benthic foram called "pachyderma".

G. ruber-r
N. pachy-L
C. pachyderma
C. wuellerstorfi
Speleothem band
bulk ground-rock

Within this column, we use a series of flags to delineate the type of information required. Each flag is semi-colon ";" delimited. You may use any, all or none of the flags as your data requires. The flags are described below and in the downloadable file (MSword).

Many items can be strung together and are separated by a semicolon

for example R:WBC;o:DRO;u:cm;f:125-150;s:;n:10
these are Curry samples loaded by ostermann, depth in cm, fraction 125-150, sonicated, n=10

NOTE: enter the things which may change, like n;10, last in the list for ease of editing

u:units (in core depth) u:cmor u:ft
f: size fraction f:125-150or f:>250
n:number of specimens n:10
s: sonicated s:
p:pyrite present p:
c:comment c: these were very dirty bugs in general
o:operator o:DRO
R:requestor R:WBC (the PI who is paying)
V: weight (for instance) V:527
U:“V” units U:ug
I: PI supplied ID number or string I:5 or I:PT10039
V: PI supplied weight or other info V:52
U:“V” units U:ug - eg. 52 ug
a: Archive usually used with ODP samples

The flags currently allowable are described in the following section, along with their use. A rule-of-thumb here is lower case tokens indicate system flags whereas upper case flags indicate a user parameter.

a: Archive Sample - Mostly used for ODP archive vs. working samples. No string is necessary.
c:comment Multiple comments may be used, up to 256 characters.
D:depth Core depth, in meters.
f:size_fraction categorization of the specimen size distribution, usually entered in the forms e.g. 250-500, <250, >500. Try not to use embedded spaces.
n:count count of number of specimens analyzed.
o:operator Initials of the person loading the carousel at WHOI. Identifiers may be no more than four characters in length. We prefer three characters.
p: identifies the occurance of pyrite in the sample. No string is necessary.
I:information user assigned ID number or string- Note the identifier may contain both letters and numbers, the only constraint being that it may not use semi-colons, colons or commas.
Q:quality a user assigned integer quality value to the specimen. The Convention is 0:good (default) to 9:very bad.
R:requestor Initials of the person whose samples are in the carousel. Identifiers may be no more than four characters in length. We prefer three characters.
s: identifies sonification. No string is necessary.
U:units specifies some special units of measurement associated with the users value of measurement. Length is limited to 16 characters.
u:units is the identifier assigned to describe the units associated with the Core-Depth field which contains the distance taken from the top of the core in centimeters ("cm"). Other two character identifiers could be used, e.g. "m." (meters), "mm", "ft", "in", etc. If the sample was take from a depth of 4 to 6 centimeters the value entry must be constructed as "4-6". The hyphen must be used.
V:value_string a user specified value associated with the specimen. The string may be no longer than 32 characters. The units are as described in the U: token.
X:longitude denotes the decimal degrees of longitude of the position from which the specimen was taken. East of Greenwich is positive and the allowable range is -180 to +180.
Y:latitude denotes the decimal degrees of latitude of the position from which the specimen was taken. North of the equator is positive and the allowable range is -90 to +90.