Time Based Data – Data Entry

Time Based Data – Data Entry – Overview

Tool Location

·         Data > Enter Data

The Data Entry tool is used to manually enter data into the database. 

Time Based Data – Data Entry - General Usage

The Data Entry Form allows the user to build customized data entry forms by selecting desired intervals, parameters, units, and other options.  Once the form has been built, it is used to enter data into the database.  This is also where the user creates and manages templates for commonly entered data sets that can be recalled at a later date.

 

The Data Entry Form is shown below.

image

 

Use buttons and lists to customize how data will be entered.

Use the Select Intervals button to open the Location Explorer.  Select one or more intervals that you will be working with.  Double click on intervals one at a time or select several intervals and press the Select button.

Use the Parameters list to add parameters to the data entry form.

Use the Options list to change which column headings appear in the Data Entry Form.

Use the Template feature to save templates for commonly entered datasets that can be recalled at a later date

Use the Work Name feature to assign and manage names for each data set entered.  

Time Based Data – Data Entry - Features

Select Intervals Button           

image

Brings up the Location Explorer in a special mode that allows the user to search for intervals in the database, and select intervals for data entry.

image

Double click on single Intervals, or highlight multiple intervals and press the Select button in the lower right corner. If you need to use the form in normal mode, close the form and open from the Locations menu.

Delete Interval Button

image

Allows the user to delete an interval from the Data Entry Form.

Select Parameters Feature

Provides a list of all parameters that can be entered into the database.  The entries in this list are controlled by the user.

image

 

Delete Parameter Button

image

Allows the user to delete a parameter from the Data Entry Form.

 

Options Feature

Includes options to add to the data entry form such as showing MDLs.

image

Reorder Features

image

Intervals and Parameters can be reordered using these buttons. Click on the column or row header first, and then use these buttons to move the selection up or down (or left or right). Note – some columns cannot be moved.

 

Data Entry Form Feature

This is the main grid on the form and is where the user builds a data entry spreadsheet based on the selections made (i.e. Selected Intervals, Parameters and Options).  Data is typed into this form and the saved to the database. 

image              

Template Feature

Once the user has built a data entry spreadsheet, the template feature can be used to save the layout as a template.  Templates can be easily recalled at a later date. image

 

Work Name Feature

Displays and enables the user to manage work names for all of the data that has been entered.

image

 

Clear Data Button       

Erases all of the data in the current data entry form.

 

Save Data Button        

Saves all of the data in the current data entry form.

Layout Selector          

The default layout has parameters across the top and intervals down the left hand side. Layout 2 has intervals across the top and parameters down the left hand side.

Close button

Pressing this button closes the form without appending the entered data.

Time Based Data – Data Entry - Entering Data

1.        Open the Data Entry form using Data > Enter Data

2.        Press the Select Intervals button to bring up the Location Explorer. Select the desired intervals. Close the form when finished. You can change the order of intervals on the Data entry form if necessary.

3.        Move to the Parameters list.  Use the drop down list near the top to narrow down the group of Parameters.  Select the desired parameters by double-clicking on them in the box.

image

4.        Move to the Options list.  Select an entry from the list and then click Show or Hide as deemed necessary.  Doing so will add or remove the columns from the spreadsheet.

image

5.        If the intervals, parameters and options selected are a common group of parameters (i.e. monthly sampling schedule), a template can be created.  Go to the Template Name box and type a name for the Template then press the Save button located at the bottom of the Template box. The next time this Template is required, select the Template name and press the Load button (or double click) to bring up the Template. image

6.        Move to the Work Name box.  Enter a name for the data set to be entered.

image

7.        Enter your data.  The date can be entered manually, or selected from a calendar upon double-clicking on the date field.  For data units, use the drop down box to change the units or type in the units you require.

8.        Press Save Data, and your data is appended to the database.  A message box will ask if you are sure you wish to save the data.  Press Yes.

Time Based Data – Data Entry – Creating a Template

 

1.        Open the Data Entry form using Data > Enter Data

2.        Press the Select Intervals button to search for and select intervals.  Close this form when finished.

3.        Move to the Parameters list.  Use the drop down list (located near the top) to narrow down the group of Parameters if necessary.  Select the desired parameters by double-clicking on them in the box.

4.        Move to the Options box.  Select an item then click Show or Hide depending on whether you wish to see that column or not.

5.        Go to the Template Name box and type a name for the Template then press the Save button located at the bottom of the Template box. The next time this Template is required, select the Template name and press the Load button to bring up the Template.

image

Time Based Data – Data Entry – Accepting or Rejecting Outliers

There are times when the data contains a potential outlier and this data must be carefully reviewed and noted.  Upon review of the data point, you can decide whether to accept or reject the data value.  One method of doing this uses the ‘Type’ field to flag whether the value is accepted or rejected. By using the Type method, later when analyzing the data you can choose whether to include or exclude rejected values in your output.

In the example screenshot below you can see the Type column has been added to the data entry form. The Type dropdown list contains 2 values: ‘Reviewed and Rejected’ and ‘Reviewed and Accepted’. In the example below, the value has been rejected.

Also, in this particular case we have added a replacement value by adding the same interval a second time to the data entry spreadsheet. This interval appears as the last row of the spreadsheet. While adding the replacement value we have used the comment column to note this is a replacement value.

image