National Geophysics Data Center Marine Geology & Geophysical Division Index to Marine Geological Samples (Core Curators' Database) http://www.ngdc.noaa.gov/mgg/curator/ Entry Program README file Entry program and README file by Rodney Russ, University of Colorado. CHANGED (7/15/2011): Updated inst/ship lists and province codes. CHANGED (7/7/2008: Updated inst/ship lists, device codes, and added 1 missing lithology code. CHANGED (8/30/1999): modified pull-down for glass remarks to differentiate between previously truncated descriptions - see full parameter list for exact (unabbreviated) version of each term. CHANGED (8/5/1997): Added description for whole minutes and tenths of minutes lat/long fields. CHANGED (6/11/1997): Added description for End Date, and Ending lat/long fields. INTRODUCTION This Microsoft Excel(1) worksheet has been developed to aid in formatting data entry to conform to the 1996 Core Curator's Database format. It consists of a worksheet on which to enter your data and a toolbar with tools to assist in this data entry. In newer versions of Excel, you will need to choose the add-ins tab to use the macros described below. TEMPLATE The file downloaded from NGDC is a template. Every time it is opened, a new file is created with a default name. Changes are never made to the template directly. If you have a particular naming convention that you would like to use, it would probably be a good idea to do a SaveAs after opening a new document. This will ensure that the filename you choose will be used instead of the default name. TOOLBAR The toolbar consists of three buttons. The first one looks like a notebook, the next one should be an X, and the last one should be a printer. This toolbar can be placed anywhere in the workspace, keep in mind that it may be used frequently during data entry. If the toolbar is accidentally closed, it can be retrieved by doing the following: - Select the View pulldown menu - Select the Toolbars... item (displays a Toolbars listbox) - Scroll through the list and find CorEnter (probably last) - Check the box and click OK - The toolbar should reappear. * If you could not find CorEnter Toolbars list, then the toolbar may have been deleted. Opening another copy of the template will create the toolbar again. Notebook Icon ------------- The notebook icon is used to pull up a listbox of available items to choose from. For example, if you wanted to know about all the available Sampling Devices, you would choose a cell in the Samp Dev Code column and press the notebook icon. This would bring up a list of all available sampling devices. A sampling device can be chosen (by either double-clicking the choice, or selected the choice and pressing OK). This would place the code that corresponds to the chosen device into the cell. With the exception of the Inst/Ship Code column, the notebook icon functions exactly the same (as detailed above) for all columns with information available. The Inst/Ship Code column will bring up a dialog box from which two selections have to be made, the institution and the ship. To make a selection from this dialog, do the following: - Press the down arrow beside the Institution entry box - Select the institution - Wait for the Ship listbox to be initialized with all the available ships for the chosen institution (this may take a couple of seconds) - Select a Ship from the listbox by either double-clicking it, or selecting it and pressing OK - The corresponding institution/ship code should now appear in the cell. X Icon ------ The X icon sort of reverses the notebook icon function. Once a code has been placed in a cell, if you want to find out what the code translates to this is the button to use. To use this, select the cell that contains the code you want to translate. Then select the X icon button. If there is information available on the chosen code, it will be displayed in a window. Printer Icon ------------ The printer icon may be helpful if you find it cumbersome to use the notebook icon to look up codes. What the printer icon will do is print out a list of the codes and what they translate to for a chosen column. To use it, just select the column that you want a code list for and press the printer icon. This will print out a code list for the column. Again, with the exception of the Inst/Ship Code column the printer icon functions the same for all columns with information available. For the Inst/Ship Code column when the printer icon is pressed, a listbox of institutions appears. Select an institution from this box and the codes for all the ships associated with the chosen institution will be printed. WORKSHEET The worksheet (which should be named Data Input) consists of a blank worksheet with predefined headings. These headings correspond to the data elements of the 1996 Core Curators Database format. Column headings appearing in red are the columns that have lookup information associated with them (i.e. you can use the toolbar icons with these columns). The following is a list of the columns that should appear red (just in case there was a problem): - Inst/Ship Code - Samp Dev Code - Stor Meth - Prim Lith Comp - Prim Text - Sec Lith Comp - Sec Text - Other Comp#(1-6) - Age of Int - Phys Prov - Drg Lith - Drg Min - Drg Wth & Meta - Drg Gls Rem - Muns Clr Code Column Headings --------------- The following is a detailed description of all the headings included on this worksheet. Please pay particular attention to the field restrictions. Inst/Ship Code: NGDC two digit institution code concatenated with NGDC two digit ship code. (If your ship isn't in the list, just put in the ship name and NGDC will add a code) Cruise ID: Cruise identifier from institution, maximum 30 alphanumeric characters. Sample ID: Sample identifier from institution. Should be unique within cruise (for a sampling device), maximum 30 alphanumeric characters. Date Collected: Date sample collected form YYYYMMDD. End Date: End date for sample collected form YYYYMMDD. * (end date for dredges only) FOR LATITUDE/LONGITUDE please choose either the decimal (preferred) OR the deg, whole min, tenths of mins - not both - Thanks! Lat Deg.: Latitude degrees, 2 digit integer Lat whole Min.: Latitude whole minutes, no decimal, 2 digit integer tenths of Mins: Latitude tenths of minutes, no decimal, 2 digit integer N or S: North or South form either N or S Long Deg.: Longitude degrees, 3 digit integer Long whole Min.: Longitude whole minutes, no decimal, 2 digit integer tenths of Mins: Longitude tenths of minutes, no decimal, 2 digit integer E or W: East or West form either E or W Dec. Lat: Decimal latitude form +/-DD.DDDD Dec. Long: Decimal longitude form +/-DDD.DDDD Ending Lat Deg.: Ending latitude degrees, 2 digit integer Ending Lat whole Min.: Ending latitude whole minutes, no decimal, 2 digit integer tenths of Mins: Ending latitude tenths of minutes, no decimal, 2 digit integer Ending N or S: Ending North or South form either N or S Ending Long Deg.: Ending longitude degrees, 3 digit integer Ending Long whole Min.: Ending longitude whole minutes, no decimal, 2 digit integer tenths of Mins: Ending longitude tenths of minutes, no decimal, 2 digit integer Ending E or W: Ending East or West form either E or W Ending Dec. Lat: Ending decimal latitude form +/-DD.DDDD Ending Dec. Long: Ending decimal longitude form +/-DDD.DDDD * (Ending lat/longs for dredges only) Water Depth: corrected meters, no decimal, 5 digit integer. Please, no decimals, just a whole number, thanks! (beginning depth for dredges) Ending Water Depth: corrected meters, no decimal, 5 digit integer. (for dredges) Samp Dev Code: Sampling Device Code, 1 character alpha code Stor Meth: Storage Method, 1 character alpha code Core Len: Core Length, 6 digit integer total length in centimeters Core Diam: Core Diameter, 3 digit integer, in centimeters (round to nearest whole centimeter and place real value in comments field, if necessary). Depth to Top: Depth to Top of Interval, 999999.9 centimeters and tenths of centimeters. Depth to Bot: Depth to Bottom of Interval, 999999.9 centimeters and tenths of centimeters. * (if a point sample, code same depth for top & bottom of interval) Prim Lith Comp: Primary Lithologic Composition for Interval, 1 character code. For unconsolidated sediment. Prim Text: Primary Texture, 1 character code. Please do not use old rock types here - use the new rock lithology codes described below, thanks! Sec Lith Comp: Secondary Lithologic Composition for Interval, 1 character code from same list as primary lithologic composition used for a second lithology that is common but lesser than the primary lithologic composition. Sec Text: Secondary Texture from same list as primary texture, same rules apply. Components below are in no particular order, just things that you think are important to note: Other Comp#1: Other component #1, 1 character code from primary composition codes list Other Comp#2: Other component #2, 1 character code from primary composition codes list Other Comp#3: Other component #3, 1 character code from primary composition codes list Other Comp#4: Other component #4, 1 character code from primary composition codes list Other Comp#5: Other component #5, 1 character code from primary composition codes list Other Comp#6: Other component #6, 1 character code from primary composition codes list * No importance implied by order Age of Int: Age of Interval, 2 digit numeric code for geologic age of interval Int#: Interval Number, three digit integer, '001' for the first interval in a core or the first rock in a series of rocks within a single dredge Blk Wt: Bulk Weight, in kilograms, format 9999.999 (weight applies to rock or interval, if only one rock or interval coded for sample, weight applies to entire sample) Phys Prov: Physiographic Province, two digit integer Drg Lith: Dredge Lithology, two character alpha numeric Drg Min: Dredge Mineralogy, one character alpha Drg Wth & Meta: Dredge Weathering & Metamorphism, one character alpha Drg Gls Rem: Dredge Glass remarks & MN/Fe oxide coating, one character alpha Muns Clr Code: Munsell Color Code, up to 10 characters alphanumeric (standard Munsell code) Princ Inv: Principal Investigator, freeform field, up to 26 characters, last name, first name of PI who collected the samples. Mat Ex: Flag for material exhausted, no longer available, 1 character code 'X' Comments: Comments on Interval, free form comments about the interval, up to 255 characters ***NOTE*** It is important to remember that Lat/Longs are entered in only one of the two formats available. Please enter as either degrees/minutes or decimal and NEVER BOTH. WHEN FINISHED Please email the completed spreadsheet to us - Thanks! ACKNOWLEDGEMENTS The corenter program, readme files and the core curator quality control system were all written by Rodney Russ, graduate student at the University of Colorado in the Computer Science Department. *** end of readme *** MORE INFORMATION http://www.ngdc.noaa.gov/mgg/curator/ PROBLEMS If there are any problems/questions/suggestions about this template, please email them to: carla.j.moore@noaa.gov