Data Capture sign in

Data Capture is your spreadsheet type application to collect your observations based on the template configured using the Template Manager application. It has only a few windows (Fig. <CM user interface overview>), but is packed with functions and features to facilitate and validate data capture.

Figure <CM user interface overview>.

To sign into the GEODESC Data Capture application (Fig. <sign in page>):

• Enter your username in the Username entry field.
• Enter your password in the Password entry field.
• Select the project from the Chose your project dropdown list.
• Click the Sign in button

Figure <sign in page>.

Once signed in, you will land on the Capture sheet dashboard page where you define your workset(s) with the template, hole and cores you want to work on. 

Capture sheet dashboard

The dashboard controls the creation of data capture worksheets. Worksheets are specified as worksets, which define the objective and scope of the observations to be entered in the worksheet. This level of control ensures that multiple observers can work on the same template as long as they are not working on the same core at the same time. The dashboard has three functional areas (Figure <dashboard>):

• The Select template area lists all templates made available to the project in the Template Manager application.
• The Create workset area allows you to specify the cores (including all their subsamples) you will be working on during your session.
• The Existing worksets area shows worksets already specified and ready to be opened as worksheets as long as other users don't have them opened at the time.

Figure <dashboard>.

To create a workset:

• In the Select template area:
  • View a list of all available project templates
  • Optionally, filter the project template records:
    • Make a selection from the Scale dropdown menu.
    • Make a selection from the Type dropdown menu.
    • Note that all existing worksets are shown in the Existing worksets area based on your filter setting.
  • Select one or more templates you want to work with.
    • Note that this also filters the existing worksets in the Existing worksets to give you quick access to the ones you want to work with without the need to re-create them.
• In the Create workset area:
  • View the expedition associated with your project, or select an expedition if multiples are associated with the project from the Expedition dropdown menu.
  • Select a site from the Site dropdown menu (mandatory)
  • Select a hole from the Hole dropdown menu (mandatory)
  • Note that this may further filter the existing worksets list in the Existing worksets area.
  • Optionally, specify a set of core numbers by entering core numbers in the top and/or bottom entry fields.
    • Note that the cores don't need to exist yet. 
    • Specifying a limited set of cores allows other observers to work on other cores of the same hole, using the same template, at the same time.
    • Limiting the workset also avoids downloads of huge data sets into the worksheet for a current session.
  • Click the Create button.
    • If the specified workset does not overlap with an existing workset, a new workset is created.
    • If the specified workset overlaps with an existing one, you will get a warning. Check the workset table.

To create a workbook with one or more worksheets:

• In the Existing worksets area
  • Select the workset(s) that you want to open as a workbook.
    • Newly created worksets are already pre-selected for quick opening.
  • Click the Open button.
    • If any of the selected worksets are in use, you will get notified that you cannot open it. Talk to your team member(s) if you need access to (part of) those worksets.
    • If the selected workset(s) are available, the corresponding worksheet(s) will open in you current browser tab.
• For worksets that already have data, all data are downloaded automatically.
  • For deep holes with thousands of description intervals, limiting the workset for your current session is a way to deal only with the data you need at the time.
• For a workset that has no data, no spreadsheet is displayed. You need to add samples to add rows.

To manage worksets:

• The list of existing worksets in the Existing worksets area is likely to grow as multiple users work on entering and reviewing data in multiple templates from multiple holes. The worksets are not data files, they simply limit and protect the templates and cores you are 'checking out' for description. By deleting a workset, you are not deleting data, except in the case of unpublished data, and in that case you are explicitly warned as described below.

To clean up your workset list:

• Select the workset to be deleted.
• Click the Delete button.
  • If the workset has a user identified in the Current user column, you cannot
  • If the workset is flagged with not published in Publish status column, you get the warning in Figure <workset delete warning>. Follow the instructions.

Data capture worksheet

Worksheet functional areas

A worksheet has the following functional areas:

• Top banner
• Ribbon
• Cell display bar
• Spreadsheet
• Worksheet tab bar
• Bottom banner

The areas are indicated in Fig. <worksheet>, and the functions in each area are described below.

Figure <worksheet a>. Worksheet functional areas marked next to the screen shot of an actual worksheet.

Figure <worksheet b>. Worksheet functional areas marked next to a schematic of the worksheet.

Top banner

The top banner has 5 functions:

• Application menu
  • Provides access to the other GEODESC applications.
• Workset specification
  • Displays the template, hole and core selections made on the the dashboard page.
• User name
  • Displays the user name of the account currently working on this workset.
  • No other user can use this workset at the same time. The current user needs to close and release it for another user to open the worksheet with all existing data.
• Sign out button
• Help link

Ribbon functions

Add samples

Observations are made on samples registered in the Laboratory Information Management System (LIMS). Add samples is the principal method for adding rows to a worksheet. In order to maintain the chain of custody and ensure that only existing samples are described, and that all samples of a certain type are described, you cannot add empty rows to your worksheet and manually add sample identities. 

To add samples to the worksheet:

• Click the Add samples button.
  • The Add samples window opens (Fig. <add samples>)
  • The available sample list is loaded.
• Select one or more sample types.
  • The available sample types may already have been pre-filtered based on a setting in the Template Manager application.
  • Your selection may affect the sample list.
• If the template was configured for small sample types, select one or more test types.
• The worksheet is already configured for a hole and a subset of (or all) the cores from that hole. You can further constrain the sample selection with a subset of cores.
• The 'Samples available based on all selections and filters' are listed and you can select one or more of them for addition to the worksheet. 
• Tap the Add button and the selected samples are added to the worksheet. Samples that already exist in the worksheet are not shown.

Figure <add samples>. Sample selector window.

Validate

The worksheet has many validation rules: those applying to the scope of description, and others as observable attributes. Some errors are flagged immediately when the observers commits them, others are revealed when the Validate function is run. Observers cannot publish the data to LIMS as long as errors exist.

Go to error

The Go to error button is enabled if you have errors in your capture sheet. Clicking the button will focus the cursor on the left- and uppermost error in the sheet. After you have fixed the error, clicking the button will again focus on the left- and uppermost error in the sheet. When no more errors exist, a toast appears with the message ‘No errors found’ and the button will be disabled.

Publish to LIMS

Data entered in the capture sheet are automatically saved to a temporary location in the database, which is not accessible by the general user. To make the data accessible to your project scientists (and eventually the public):

• Click the Publish to LIMS button. save the data and create a file accessible by any authorized user (the shipboard science party during the moratorium; the public after the moratorium has expired), the data must be uploaded.

Note: An IT representative can access the auto-saved data in case of an emergency, the kind of which has not been encountered so far.

Undo and redo

You can undo a limited number of your past actions. 

You can redo the last undone action.

Re-sort rows

Use this button to sort the rows based on the scopes of description, in the following order: Core, then Section, then Top offset.

Column visibility

Click the Column visibility button to open a modal window with a list of all the columns. The columns are in the order they currently are in the worksheet. Check or uncheck the columns to show or hide them, respectively. 

Your adjusted column visibility will be valid as long as your worksheet is in use. If you re-open (or open a new) workset, the column visibility will be re-set to the settings in the Template Manager application. 

Move columns

Click the Move columns button to open a modal window with a list of all the columns. The columns are listed in the order they currently appear in the capture sheet. You can select columns and toggle them up and down, which means left or right, respectively, in the worksheet.

Your adjusted column order will be valid as long as your worksheet is in use. If you re-open (or open a new) workset, the column order will be re-set to the settings in the Template Manager application. 

Refresh samples

Click the Refresh samples button if you suspect that some sample lengths (and resulting depth computations) were changed in the LIMS sample registry while you were using your worksheet.

Alignment area

To align cell contents, select a range of cells and use the six buttons available:

• vertical alignement:
  • top
  • middle
  • bottom
• horizontal alignement:
  • left
  • center
  • right

Font & text area

In the Font & text button area you find four formatting functions:

• Wrap text
  • Select a cell or cell range.
  • Click the Wrap text button.
    • If the cell content was truncated, it will be wrapped and the row height may increase if needed.
    • If the cell content was wrapped, it will be truncated and the row height may shrink if not otherwise constrained.
• Cell fill color
  • Click the Paint bucket down arrow button.
  • In the dropdown color editor, select the desired color in one of two ways to 'fill the paint bucket:
    • Select any color in the editor.
    • Alternatively, select an existing color in the worksheet using the paint dropper.
  • Click outside the color editor to close it.
  • Select a cell or cell range to be colored.
  • Click the Paint bucket button to apply the color.
• Font color
  • Click the 'A' icon down arrow button.
  • In the dropdown color editor, select the desired color in one of two ways to create a font color:
    • Select any color in the editor.
    • Alternatively, select an existing color in the worksheet using the paint dropper.
  • Click outside the color editor to close it.
  • Select a cell or cell range to be colored.
  • Tap the 'A' icon button to apply the color.
• Text orientation
  • Select a cell or cell range.
  • Click the 'ab' with arrow button.
    • The text will toggle between two orientation: horizontal (default) and vertical (-90 degrees).

Zoom

This zoom function only affects the spreadsheet in the strict sense, i.e., it does not scale the surrounding area, including the ribbon. This provides an alternative to the browser's zoom, which affects the entire page.

To scale your spreadsheet area:

• Select a percentage from the Zoom dropdown menu.
• Click the Zoom to 100% button to reset the zoom level to the default. 

Freeze

Freezing rows and/or columns can improve the scrolling experience. By default, DC freezes the header row and all description scope columns (the first 13 columns that will be part of all final product files). You can change the freeze configuration in four different ways:

• Unfreeze All
• Restore default freeze
• Freeze rows above and columns to the left of the selected cell
• Freeze header row only

Close

When you click the Close button, you are presented with workset management options depending on whether you have published the latest edits using the Publish button or not.

If you have published the latest edits, you have the option of deleting or releasing the worksets (Fig. <close published>):

• If you click the Delete worksets button, the workset(s) will disappear from the Existing worksets area on the Capture sheet dashboard page. This is a good practice to keep the workset list lean and clean.
• If you click the Release worksets button, the workset(s) will show as available in the Existing worksets area. This is a good practice if you or your team mate will continue work on the same workset.

Figure <close published>.

If you have not published the latest edits, you have the following options (Fig. <close unpublished>): 

• Clicking the Lose data and delete worksets button is your choice if you made edits and don't want to keep them.
• Clicking the Keep data and release worksets button is your choice if you or your team member later want to continue capturing data but don't want to publish them yet for wider consumption.

Figure <close unpublished>.

Using the Close button is the recommended method to close you worksheets. However, the button is not the only way for your worksheets to close:

• You may (accidentally) use the browser tab's close button.
• You may be auto-signed out of the application due to security protocols, in which case you get a 1 minute warning (Figure <auto-sign out warning>.)

Figure <auto-sign out warning>.

If you get signed out involuntarily, or if you use the browser tab close button:

• You will not get any message.
• When signing back in, you will find the worksheet(s) closed and you'll be back on the dashboard.
  • The workset will be in the Existing worksets area, bolded and marked in use.
  • If you had data that were not uploaded, the workset(s) will also be marked as not uploaded.
  • You should open the worksheet(s) again and either continue your work or close them and release the worksets.

Cell display bar

• Selected cell address
• Selected cell content

Spreadsheet

Columns

Each worksheet has two types of columns:

• Scope columns
  • Include the sample identity, sample interval, corresponding depth intervals and domain to be described.
  • They are exactly the same for all GEODESC templates. Some may be hidden for data capture, however the final product description files will have them all.
  • They are shaded light gray and frozen as a group by default (you can change that).
  • Note the important difference for the ‘Top offset’ and ‘Bottom offset’ columns:
    • In templates set for ‘large samples’ (template type=summary or type=macroscopic), the ‘Top offset’ and ‘Bottom offset’ columns are editable entry fields.
    • In templates set for small samples (type=microscopic), the offsets (in section) were given at the time the small samples were created and cannot be edited.
• Observable columns
  • They represent the observables as configured in the Template Manager application.
  • Templates for micropaleontology have three types of observable column, a difference relevant when configuring the templates but not explicit in the worksheet:
    • General: observable columns are representations of observables selected or defined primarily for core description needs; they are typically added to the template from the GEODESC observable catalog.
    • Taxa columns are specifically for capturing the abundance of formally defined taxa. Template makers typically add these columns to the template in large batches, using a process only available if the template is of type=micropaleontology.
    • Taxa-like columns represent general observables that were added to the template using the same process as was used for the taxa list, i.e., it is only available if the template is of type=micropaleontology.

You cannot create columns in the Data Capture application. Columns are added, deleted and configured in the Template Manager application.

When you create a worksheet from a workset for the first time, the column display settings are those pre-defined in the Template Manager application for your convenience. The column display settings include:

• Visibility
• Lock visibility (you cannot change the visibility in Data Capture and if hidden, will never see the column.)
• Column width
• Background color

You can change the visibility for your session, and perform filter and sort operations on the worksheet, using the column context menu:

• Hide
• Unhide
• Column width...
• Filter
• Sort

You can also drag column margins to change the column width.

You can also use the Column visibility button to see and change the visibility of all columns in a simple window.

Rows

Rows represent description intervals or domains. Rows can be added in two ways:

• Click the Add samples button.
  • Use the filters and selection options described previously for that function.
  • A row will be added to the worksheet for each sample.
• Insert description intervals and/or domains using the row context menu (Fig. <row context menu>).
  • Right-click anywhere in a row to open the context menu.
  • The row context menu is deliberately restricted to the limited but specific functions needed for efficient core description and micropaleontology data entry.

Figure <row context menu>.

Description of row context menu items:

• Add interval (only enabled for large sample types)
  • Use this function to add an interval that has a top offset equal to the bottom offset of the selected row, and a bottom interval equal to the bottom of the section.
  • This is the most convenient workflow if you define description intervals one after the other.
• Add interval grid (only enabled for large sample types)
  • Use this function to create multiple description intervals of equal thickness for a section half.
  • Enter the desired interval thickness in cm and click the Insert button.

• Split and insert interval (only enabled large sample types)
  • Use this function to define an interval that overlaps with an existing interval by splitting the existing interval and adjusting the offsets to those entered for the new intervals.

• Add domain for interval (enabled for large and small sample types)
  • Use this function to define layers, areas, patches, constituents, etc., within a sample interval. The domains can be defined by texture, composition, and/or structural features. The function duplicates the selected row and automatically assigns domain numbers to ensure the scopes of description are unique (a basic rule).
  • The menu item inserts a new row with the same sample ID and offsets as the selected row.
  • If the domain number of the selected interval is null (no number entered), this function enters '1'. The new scope added gets domain no. '2'. If the selected interval already has a domain number, the domain number of the new interval is incremented by 1 over the highest existing domain number for the sample interval.
  • Note: The Validation function will check if duplicate scopes exist, which could happen if the observer changes the domain numbers such that the same number exists for more than one row within the same sample ID and offsets.

• Copy all observations from this row - Use this function to copy all observations from the selected row, ignoring scope and formula cells.

• Paste all observations in this row - Use this function to paste all observations from the (custom) clipboard into the selected row, ignoring scope and formula cells.

• Delete row - Use this function to delete the entire row, including observations and scope of description.

Cells

List validation

Numeric validation

Formulas

a) general cell context menus such as copy and paste are not allowed in this application environment (but keyboard commands work), and (b) in the context of the GEODESC data capture workflow, actions on random groups of cells are not meaningful.

Worksheet tab bar

• If you opened multiple worksets from the workset dashboard, the workset names are shown in the tabs below the current worksheet.

• Although you can change the worksheet tab name, your name is ephemeral, i.e., the next time you create a worksheet from that workset the name will return to the formally defined name.

• If you close a worksheet, the entire workbook is closed.

Bottom banner

• Locked indicator
• Autosave indicator
• Error count
• Zoom slider