...

...

Table of Contents

anchor

...

...

Start DESClogik

...

1. Click on the DESClogik icon (Figure 1).

...

Image Removed

Image Added
Figure 1. Desktop icon.

2. Login with username and password (Figure 2; for scientists, jrs_lastname, default password $Firstname2015).

...

Image Removed

Image Added
Figure 2. Login screen.

Open Template

Select the template from the dropdown list:

• Group: your expedition number
• Template: Double click your specialization or sub-group

...

• , e.g. 361_macroscopic for core description (Figure 3).

Image Added
Figure 3. Home screen showing template selection.

Task Bar

• (Head Icon): Change user (will force you to log-in again but prompts you if there are unsaved data)
• Select T: Select a template (spreadsheet data entry form).
• Select Sample: Select sample by Hole, Sample Type, and/or Test.
• Upload: Upload (save) template spreadsheet entries to LIMS.
• Download: Download data from LIMS into template spreadsheet.
• Clear: Clear data from template on screen.
• All Tabs checkbox: apply upload, download or clear process on current (unchecked) tab or all tabs (checked) in template.
• Sort: Sort data in spreadsheet, using one or more columns
• Export: Export spreadsheet to Excel (.xlsx). Check Data Only.

Select Sample

1. Wiki Markup

   From

   the

   drop-down

   list (the sample globe),

   drill

   down

   to

   the

   sample

   to

   be

   described:

   select

   by

   hole,

   sample

   type,

   and/or

   test

   \

   [PAL

   \

   ].

   Double

   click

   on

   the

   sample

   LabelID

   LabelID.  Core description selects to archive >>section. E.g. 361-U1549A-23R-1A.

   1. If starting a data entry sheet, click into the next sample row in the first column to paste the sample into the spreadsheet template. Enter your description top and bottom of the description interval in the 2^nd and 3^rd columns. For section-halves the offset from top of section, i.e. 0 to 50 cm. The default is 0cm to the bottom of section. Depth is automatically calculated.
   2. If downloading data from LIMS, double-click on the sample(s) of interest and click the download button.

Export Data to Excel

You can export your DESC data spreadsheet at any time.

1. Click the Export button on the header bar.
2. Choose a formatting option:
   1. Expand sample column: if checked, the Expedition, Site, Hole, Core, Section, Section Half will export into separate columns. Do not select this box to export the sample ID in the concatenated label ID format.
   2. Include classifications: if checked, the value list classifications will be downloaded into each cell with the data entry (recommended setting if you intend to copy/paste into DESC later). If left unchecked no bracketed classifications will export with their terms.
   3. Data Only: removes all color and text formatting from the export
   4. Value lists instead of data: for technical support personnel only.

3. Click Export and give a file output destination and name (Figure 4).

...

Image Added
Figure 4. Export to Excel options and icon.

Selected features of DESClogik

Edit column visibility

This allows you to hide and unhide columns (Figure 5).

1. Right-click on a column header and choose Edit Visibility.
2. Check the boxes in the sub-window to indicate which columns you want to see on the data entry spreadsheet. Those columns will be hidden for the duration of your session (Figure 6).
3. If the right-click menu is not enabled, check with technical support.

Image Added
Figure 5. Editing the visibility of columns.

...

Image Added
Figure 6. Edit visibility sub-window. If checked, columns will appear in template. Data remains in LIMS when hidden.

Copy/Paste from Excel into DESClogik

An alternative to entering DESC data directly into the DESC template is as follows:

...

NOTE: Unless manually entered in the excel file, the top and bottom depths are not automatically calculated if blank cells are copied into them. Depths will appear upon download.
If you follow this procedure, you must enter the following additional information (automatically added in DESC) into the Excel spreadsheet:

• Correct Sample ID Wiki MarkupClassification codes for the terms defined in the classification set. For example, _sandy_ would need to be _sandy \[USGS\]{_}<span style="color: #1f497d">.</span>. This is critical.
• Classification codes for the terms defined in the classification set. For example, sandy would need to be sandy [USGS].

Column Header Color Codes

• Blue: cells where observations are entered in free-form text (Figure 7).
• Yellow: a value list exists (Figure 7):
• Double-click on the cell to see a drop-down list of values or
• Start typing to initiate dynamic search that shows a short list of possible values.

...

Image Added
Figure 7. Yellow column cell selected which displays the value-list associated. Note the bracketed reference codes.

Note: The "Legend" button in the lower left-hand corner of the software provides a handy reference for cell color and outline meanings.

Credits

This document originated from Word document DESC_QSG_374_Draft (see Archived Versions below for a pdf copy) written by A. Deloach and R. Gray. Credits for subsequent changes to this document are given in the page history.

Archived Versions