Anchor_GoBack_GoBackDESClogik:Quick Start Guide

DESClogik Quick Start

Start DESClogik

1. Click on the DESClogik icon.

Image Modified
Figure 1. Desktop icon.

1. Login with username and password (for scientists, jrs_lastname, default password $Firstname2015).

Image Modified
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 Modified
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. 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.

...

1. Click Export and give a file output destination and name.

Figure 4. Export to Excel options

Selected features of DESClogik

Edit column visibility

This allows you to hide and unhide columns.

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.
3. If the right-click menu is not enabled, check with technical support.

Image Modified
Figure 5. Editing the visibility of columns.
Image Modified
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. This is critical.

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

Column Header Color Codes

• Blue: cells where observations are entered in free-form text.
• Yellow: a value list exists:
• 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 Modified
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.