Data Entry, Import and Export > Entering Data Manually


Entering Time Series Data Manually

To enter time series data manually:

  1. From the Data Entry menu, choose Manual Time Series.  The manual Time Series Data Entry dialog will open, see below.
      

    HEC-DSSVue Manual Time Series Data Entry Dialog Box
       
  2. Type the Pathname Parts into the A, B, C, and F boxes, then select the appropriate time interval for the E box.  The complete pathname will automatically appear in the Pathname box.  Alternatively, you can enter the pathname into the Pathname box and the parts will appear in the Pathname Parts boxes.  You cannot enter the “D” (date) part, as this is set according to your Start Date.
  3. Enter the Start Date (e.g., 25Mar2002) and Start Time (e.g., 1400).
  4. Enter the Units (e.g., CFS)
  5. From the Type list, select a data type.  Your options are PER-AVER, PER-CUM, INST-VAL, and INST-CUM.
  6. For regular interval time series data, the Date/Time cells in the table will fill automatically, starting with the start date and time you entered.  For irregular interval data, you will need to enter a date and time for each data value.
  7. Type the data values into the Value column.
  8. To view the data in plot form, click the Plot button.
  9. To graphically edit the data you have entered, click Graphically Edit.
  10. To save the new time series record, click Save.

You can paste data on the clipboard from another application by clicking the Paste button.  This allows you to copy data from various applications like Microsoft Excel into HEC-DSS.  When you paste data into HEC-DSS, the tab characters and carriage return characters in the program that you are copying from must match the data entry table.  Tab characters move to the next column to the right, while carriage return characters move to the next row down.  These are the default characters used in Excel.
 
For regular interval time series data, the data must be in a columnar format (e.g., a column from Microsoft Excel) and should contain data values only.  For irregular interval data, the date and time must precede each data value, with tab characters separating them.  For paired data, all values for each ordinate must be separated by a tab character.  To enter data using the paste capability:

  1. Complete steps 1 through 5 above.
  2. Select your data set from the other applications and Copy it into the clipboard.
  3. Press the Paste button located just above the table.  You should see the data from the clipboard appear in the table.

You can also automatically generate regular-interval time series data.  This will fill in a single number for a time window.  To generate this data:

  1. Complete steps 1 through 5 above.
  2. Select the Automatic Generation tab.
  3. Enter the End Date and End Time for the data.
  4. Enter the Fill Value, which is the single value for the specified time window.
  5. Press the Generate button.  This will return you to the Manual Entry tab, where you can plot, save, or further edit the data.