ODSN-Logo
Home Info Services Forum Help Search

Back to the Rangecharts

Info about the Rangecharts

  1. About the Rangecharts
  2. Coding of the filenames
  3. How to load the files into a spreadsheet program
Red Marker

About the Rangecharts

We have assumed that many researchers will want to work with a specific group or area, and that they may wish to build their own relational databases designed to serve specific purposes. To facilitate this we provide a large number of files that can be retrieved and used either as spreadsheets or incorporated into larger database structures.

The data files are listed by hole. The digits and letters before the underline in the file name designate the Hole. In the "cleaned" fossil data on the DSDP CDROM the samples are designated by depth in meters below the sea floor. The actual sample numbers (Leg, Site, Hole, Core, Section, Depth in Section) are not given. The files labeled with hole designation followed by an underline followed by "sd.ref" (e.g. 1_sd.ref (not available yet!)) can be used to reconstruct the sample number. They list the samples cited in the reports for each fossil group, the subbotom depth of each sample, and the name of the investigator who studied the sample.

The data on fossils are available as tab-delimited ASCII files that can be directly imported into Excel or other spreadsheet programs. The file names are coded as follows.

The digits and letters before the underline in the file name designate the Hole.

Go up
Red Marker

Coding

The first letter after the underbar designates the fossil group:
  • P = planktonic formaninifera
  • B = benthonic formainifera
  • N = calcareous nannofossils
  • R = radiolarians
  • D = diatoms
  • S = silicoflagellates

The number after the fossil group letter designates the data source:

For DSDP data (Holes 1 through 624):

  • 0 = Original data from the DSDP database; this is known to include a number of errors (currently not available).
  • 1 = "Cleaned" data from the DSDP CD-ROM
  • 2 and higher numbers indicate subsequent studies of samples from the hole, taxonomic revisions and critial reevaluations. The numbers 2, 3, etc are not necceasrily in the order of subsequent publication. The user must look at all of the files to determine which is most recent.

The three letter file type designation indicates the nature of the file:

A chart showing which species are present in a series of samples is commonly termed a range chart, although it does not in fact show the ranges of species. Here we call chart of this type "species distribution charts." We have also constructed range charts which indicate the state of knowledge of the ranges of species based on their occurrences in the distribution charts.

Go up
Red Marker

How to load the files into a spreadsheet program

All charts are formatted as TAB-delimited ASCII-files. If you want to load them into MS Excel, you have to make sure, to load a "delimited" ASCII-file, and the only delimiter is the TAB. In some Excel versions you will have to enter these information, others will recognize automaticly. If you have problems loading the files, send me a note and I'd be happy to help.
Go up

Go to the top of this Page

Back to the Rangecharts


Questions or Comments? Please send mail to the ODSN-Webmaster Thank you!
Page last modified: Sunday, 29-May-2011 21:42:59 CEST