DSDP to Spreadsheet Conversion Utility ©1999 Pierre A. Zippi. All rights reserved. This application converts DSDP "PALEO".DAT files to tab-delimited ASCII TEXT files. The resulting files may be used with spreadsheet, statistics and plotting applications on any platform. Operation: 1) In the Options menu, set Special handling options. 2) Open a "PALEO".REF file; this loads taxa names and codes (required). 3) Open the AGECODE.REF file; this loads geologic age names and codes (optional). 4) Open the SITESUM.DAT file; this loads site specific information (optional). 5) Open a "PALEO".DAT data file; this loads sample specific information (required). 6) Select a destination to save the converted data files. Data files for each fossil type are saved to their own folders. The converted data files will be named for the leg, site number, hole. e.g., 22214_ [Leg: 22, Site: 214, Hole: 1] Note: Blank hole=underscore Thus, Harris' dinoflagellate data from Leg 22, Site 214, Hole 1 is saved as: 22214_ in the Dinoflagellate folder (directory). The converted data is saved as an Excel TEXT file or a SimpleText TEXT file with: € All hole and author specific data as a header in the first lines of the data file as comment lines. Comment lines start with the "#" symbol. € species names in the first row as the column headers, € species codes in the second row (if selected in options), € core depth, sample depth, age, core, section and other sample specific references in the first 11 columns of each row. € the resulting species-by-sample matrix filled out with the coded abundance data. The abundance code legend is contained in the header of each file. Once in spreadsheet format, the utility of the occurrence data is greatly enhanced. Use a proven commercial spreadsheet or statistics application to manipulate the data. Use WellPlot 1.0 (available from Pierre Zippi) to plot many different styles of range charts that can be incorporated into by virtually any Mac or PC graphics document. Use Counter 3.0 for original data acquistion. See software descriptions at: http://web2.airmail.net/paz   DSDP PALEO.DAT data conversion to spreadsheet format using DSDPtoSpread 1.0 How the converted data sets were constructed. All sample analyses for each hole are grouped into a single data set. There may be analyses performed by more than one analyst for an individual hole (data set). The author is listed in the 3rd column. If you wish to create data sets with only one author (analyst) then use a spreadsheet editor to sort the rows by the author column. Initially, I grouped all samples from the same hole and analysed by the same author as a data set. This worked fine for the earlier holes, but later holes had data "flip-flopping" between authors. This created numerous data sets for the same hole and each data set had large sample gaps. I settled on creating data sets that would be the most useful for biostratigraphy. Pierre A. Zippi PAZ Software 7518 Twin Oaks Court Garland, TX, USA paz@airmail.net http://web2.airmail.net/paz   DSDP Paleo data types from CD-ROM data set Fossil types (21) File name Taxa Code Algae ALGAE.REF 17 G Ammonites AMMONITE.REF 3 W Aptychi APTYCHI.REF 37 A Archaeomonads ARCHAEOM.REF 67 J Benthic foraminifera B_FORAMS.REF 3246 B Bryozoans BRYOZOAN.REF 190 Z Calcispherulides CSPHERUL.REF 26 K Crinoids CRINOIDS.REF 7 E Diatoms DIATOMS.REF 1748 D Dinoflagellates DINOFLAG.REF 562 C Ebridians & Actinicidians EBRI_ACT.REF 54 Q Fish debris FISH_DEB.REF 22 Y Nannofossils NANNOS.REF 1746 N Ostracodes OSTRACOD.REF 195 O Phytolitharia PHYLITHS.REF 11 X Planktonic foraminifera P_FORAMS.REF 2062 F Pollen and spores POLLEN.REF 608 P Radiolaria RADIOLAR.REF 2172 R Rhyncollites RHYNCOLL.REF 2 V Silicoflagellates SILIFLAG.REF 692 S Trace fossils TRFOSSIL.REF 3 T Total taxa of all types in DSDP data: 13470 The following fossil types have no data: Calpionellids No data 0 L Coproliths No data 0 U Miscellaneous fossil No data 0 I Molluscs No data 0 M Pteropods No data 0 H   Formula For Absolute Depth Calculations ZSL = Zero Section Length SECT = Section Number INT = Interval in centimeters within the section LSL = Length of last section (cm) TCD = Depth to top of core (M) LS = Number of last section If sample occurs in: Formula used is: ======================== ====================================================== Zero section AbsDepth = TCD + (INT/100) Sections 1,2,3, etc. AbsDepth = TCD + ZSL/100 +(SECT#-1)*1.5 + INT/100 Core Catcher (pre-leg47) AbsDepth = TCD + ZSL/100 + LS*1.5 + INT/100 Core Catcher (post-leg47) AbsDepth = TCD + ZSL/100 + (LS-1)*1.5 + LSL + INT/100 NOTE: Occasionally no explicit centimeter interval is assigned to a sample taken from within a core catcher.In these cases, a length of 10cm is assigned. Reference: EXPLAN.DOC DSDP CD ROM data Set DSDP Explanatory Notes 4/87: Page 5-6