User:Tswensen/Time Series Data Editor 2

The Time Series Data Editor is a specialized software tool designed for creating, editing, visualizing, and analyzing time-based and XY data series, particularly in environmental, hydrologic, and modeling applications. It supports a wide range of file types and enables users to build new datasets, modify existing ones, and export specific data subsets. Whether working with raw sensor readings, simulation outputs, or curated records, users have flexible and powerful options for data management, display customization, and file operations.

The Time Series Data Editor helps users to perform advanced data operations such as interpolation, resampling, smoothing, merging, and transformation using mathematical formulas or calibration curves. Extensive display controls allow for detailed graph formatting, axis behavior adjustment, and styling. The tool also integrates with external data sources like CUAHSI-HIS, making it a versatile platform for both routine data management and complex modeling workflows.

File Menu

The File menu contains options for starting new projects, opening existing files, and saving or exporting data. Users can create new time-based or XY datasets and extract portions of data as needed. It provides the basic tools for file and data management within the editor.

New

Clears the current session and starts a new project. Prompts to save if changes are unsaved.

New Time Series...

Creates a new, empty time series dataset. User specifies time interval and value fields.

• Opens the Time Series Properties dialog
  • Properties
    • Options for Name, Latitude, Longitude, and a place to record notes
  • Series Type
    • Incremental or Cumulative
  • Options to click Edit Time Series Data... or Show History

XY Series Properties dialog

New XY Series...

Creates a new XY dataset for data not based on time (e.g., rating curves or relationships between two variables).

• Opens the XY Series Properties dialog
  • Properties
    • Options to change the name and add notes
    • Original file name, X value description, X units, Y value description, and Y units
  • X Series Type
    • Absolute or Incremental
  • Y Series Type
    • Absolute or Incremental
  • Options to click Edit XY Series Data... or Show History

Open...

Opens an existing file (e.g., “*.txt”, “*.gag”, “*.hmt”) into the Time Series Data Editor for editing or review.

• Opens the Open dialog, where the relevant files can be accessed and opened

Save

Saves the project within the current file.

Save As...

Saves the project as a separate file.

• Opens the Save As dialog

Export Selected Data...

Saves the selected time series or values to a new file. Useful for extracting portions of a dataset.

• Opens the Save As dialog

Print...

Exports the data into a printer-friendly format.

• Opens a dialog with printing details
  • Options to select a specific printer, change the orientation, adjust the Printing Style (Color, Monochrome, or Mono plus Symbol), and the DPI

Exit

Exits the Time Series Data Editor application.

Edit Menu

The Edit menu offers functions to manage, organize, and customize individual datasets. Users can duplicate, delete, lock, or move time series, as well as edit properties like name, units, or location.

Duplicate...

Creates a copy of the selected time series or dataset for separate editing or comparison.

Delete

Removes the selected time series from the project.

Move Time Series...

Transfers time series data between projects or reorganizes the structure in the Project Explorer.

• Opens the Select Time Series List dialog
  • Time series list options
    • Add to existing time series list
      • Select a list
    • Add to a new time series list
      • List name
      • Units

Lock/Unlock Selected

Locks a time series to prevent further editing, or unlocks it to allow changes.

Properties...

Adjusts the details of the dataset.

• Opens the Time Series Properties dialog
  • Properties
    • Options for Name, Latitude, Longitude, and a place to record notes
  • Series Type
    • Incremental or Cumulative
  • Options to click Edit Time Series Data... or Show History

Preferences...

Opens the Preferences dialog with the options Prompt for copying time series and Show locked points.

Display Menu

The Display menu controls how data is displayed in the graphics window. Users can adjust visual settings such as colors and markers or auto-frame the view to fit all visible data. These tools help enhance clarity and navigation of the dataset.

Display Options...

Opens a dialog (the name changing depending on the data imported) that displays the display options and controls how the time series is shown graphically (colors, fonts, plot styles, etc.).

Dialog for display options

• General
  • Titles: Main Title and Sub Title
  • Border Style: No Border, Shadow, Line, and 3D Inset
  • Viewing Style: Color, Monochrome, and Monochrome + Symbols
  • Font Size: Large, Medium, and Small
  • Numeric Precision: 0–3
  • Grid Lines: Both, Y, X, None, and Grid in front of data
• Plot
  • Axes: Select the relevant dataset
  • Plot Style: Area, Bar, Line, Points, Points+BestFitCurve, Points+BestFitLine, Points+Line, Points+Spline, and Spline
  • Comparison Plot Style: Line, Points, Points+BestFitCurve, Points+BestFitLine, Points+Line, Points+Spline, and Spline
  • 3D: Off, Shadow, and 3D
  • Option to select Mark Data Points
• Subsets
  • Subsets to Graph: Select the relevant dataset
  • Scrolling Subsets
• Axis
  • Y Axis: Linear, Log, Auto, Min, Max, and Min/Max
    • Fields to enter Min and Max values
  • X Axis: Linear, Log, Auto, Min, Max, and Min/Max
    • Fields to enter Min and Max values
• Font
  • Options to change the fonts of the Main Title, Sub-Title, and Subset / Point / Axis Labels: bold, italic, or underline
• Color
  • Graph Attributes: Desk Foreground, Desk Background, Shadow Color, Graph Foreground, Graph Background, Table Foreground, Table Background
  • Quick Style: Bitmap / Gradient Styles options (Light, Medium, Dark) with border settings (Inset, Shadow, Line, No Border) for each option
• Style
  • Options to select the relevant dataset and adjust the color, Point Type, and Line Type

Frame

Auto-zooms or adjusts the Graphics Window to frame all visible data.

Tools Menu

The Tools menu includes a wide range of options for editing, transforming, and analyzing data. Users can fill gaps, resample, shift, smooth, or merge datasets, among other operations. It also supports more advanced tasks like applying formulas, generating curves, or importing real-world data.

Interpolate...

Fills gaps in data using interpolation between known values.

• Opens the Interpolation Options dialog, where you can adjust the Interpolation time in minutes

Interpolate to Fixed Time Increment dialog

Interpolate To Fixed Time Increment...

Resamples the dataset so the values occur at evenly spaced intervals (e.g., every 15 minutes).

• Opens the Interpolate to Fixed Time Increment dialog
  • Adjust the Start time (day, month, year, time) and Time increment (by minutes)

Interpolate To Specified Time Increments...

Interpolates to custom time intervals specified by the user.

• Opens the Interpolate to Specified Time Increments dialog
  • Based on what was chosen in the Interpolate to Fixed Time Increment dialog, incremented timestamps will be assigned to a number value

Split Time Series For GSSHA

Divides one time series into multiple events based on a specified period of inactivity (e.g., 12-hour dry window). Especially useful for modeling storm events.

• Opens the TimeSeriesSplitterGSSHA dialog
  • Time Interval (Min)
  • Select Time Series
    • Select the relevant dataset
    • Place to select the correct time series dataset
  • Selected Time Series

Offset By A Constant...

Adds or subtracts a fixed value to/from all values in a time series. Good for correcting sensor bias or unit mismatch.

• Opens the Offset Points dialog
  • Enter a point offset
    • Point offset (in inches)

Shift Times...

Shifts all timestamps forward or backward by a specified amount. Useful for aligning time zones or correcting timing errors.

• Opens the Time Series Shift Options dialog
  • Enter a shift time
    • Shift time (+/-) (in hours)

Edit Value(s)...

Allows manual editing of specific values in a dataset.

• Opens the Properties dialog
  • Options to Add Row(s) and Delete Row(s), as well as Number of rows to add
  • Spreadsheet where timestamps have values assigned to them (Value (in))

Edit Selected Value(s)...

Changes only the values currently selected in the data table or graph.

• Opens the Properties dialog
  • Only the selected timestamp appears, along with the assigned value (Value (in))

Rotate...

Reorganizes or shifts values cyclically. Not commonly used and usually depends on the context of the data.

• Opens the RotateSeries dialog
  • Pivot Point
    • Option to change the name and date
  • Rotating Point
    • Option to change the name and date
  • Offset Value
    • Name and click Rotate

Merge Time Series Data dialog

Merge...

Combines two or more time series into a single dataset, matching time points when possible.

• Opens the Merge Time Series Data dialog.
  • Merge options
    • Time series data not included in merge
      • Select the relevant time series dataset
    • Time series data to merge
      • Options to Move up or Move down
  • New name
  • Merge option
    • “Delete overlapping data”
    • “Merge all data”

Calculator

Opens a built-in calculator to apply mathematical functions to a dataset (e.g., multiply all values by 10).

• Opens the Time Series Calculator dialog
  • New time series options
    • Name
    • Add to existing time series list
      • Select a list
        • Select the relevant data
    • Add to a new time series list
      • List name
      • Units

Correct Time Series Using Observed Data...

Adjusts model data using observed (measured) data, likely by aligning trends or scaling.

• Opens the Correct Time Series dialog
  • Time series correction options
    • Select a time series to correct
    • Select a correction time series
    • Unit conversion factor
      • Unit = (Time series units/correction time series units)
  • New time series options
    • Name
    • Add to existing time series list
      • Select a list
        • Select the relevant data
    • Add to a new time series list
      • List name
      • Units

Transform Using XY Values dialog

Calculate Forward and Reverse Depth Curves...

Generates rating curves or transformation functions, often used in streamflow or hydraulic modeling.

• Opens Calculate Water Depth Curves dialog
  • Calculation options
    • First measured water depth (in millimeters)
    • Last measured water depth (in millimeters)
    • Corrected pressure curve
      • Select one of the time series datasets
    • Pressure to depth conversion factor
      • Units = (depth units/pressure units)
  • New time series options
    • Forward curve name
    • Reverse curve name
    • Add to existing time series list
      • Select a list
        • Select the relevant data
    • Add to a new time series list
      • List name
      • Units

Transform Data Using XY Values...

Applies a transformation (e.g., calibration or conversion) based on an XY lookup table or curve.

• Opens the Transform Using XY Values dialog
  • Data transform options
    • Select an XY series
      • Click Edit XY Series
    • X values correspond to time series values
    • Y values correspond to time series values
      • Select a time series
        • Select one of the time series datasets
  • New time series options
    • Name
    • Add to existing time series list
      • Select a list
    • Add to a new time series list
      • List name
      • Units

Smooth...

Applies a smoothing algorithm (such as a moving average) to reduce the noise in the data.

• Smooth… | Moving Average
  • Opens the Smoothing Options dialog
    • Enter a smoothing search factor
      • Smoothing factor
• Smooth… | Exponential Curve Fitting
  • Automatically fits the exponential curve

Trim...

Removes data before or after a selected data/time range.

• Opens the Trim Time Series dialog
  • Interpolation options
    • Customize the Start time and End time with the desired day, month, year, and time

CUAHSI-HIS

Links to the Consortium of Universities for the Advancement of Hydrologic Science – Hydrologic Information System (CUAHSI-HIS).

Allows users to search for and import real-world environmental data directly into the Time Series Data Editor.

External Links

• WMS on the Aquaveo website