Importing Data (ETA)
This article shows two ways how to add your own values to an existing time series in the project with a certain number of time points or a fixed time grid in the Engineering Time Series Analyzer ETA. Detailed descriptions of time series import via ETA can be found under Getting Started/Quick Access to Time Series and in the articles Simple Time Series Import and Time Series Import with Macros.
Copy-and-Paste Into Data Grids
Values and entire columns of values, for example from an Excel file, can be copied and pasted into the Data Grid (value table) of a time series. Depending on the position in the table, existing values are overwritten or new values are created.
In the figure above, a time series with the corresponding Data Grid is opened in ETA. In Microsoft Excel, a column of values (100 in the example) is copied to the clipboard. Then click with the left mouse button into the cell of the Data Grid of ETA into which the first value is to be inserted. The values from the clipboard are copied to the column in ETA to be filled using the shortcut <CTRL>+<V> or using the Paste command from the context menu (right mouse button). The inserted values (in the example a hundred times the value “20”) replace the previously existing values. The graphical representation in the Plot Window changes accordingly (see figure below).
Copy-and-Paste Into the Plot Window
The same effect can also be achieved by inserting the values to be imported into the Plot Window of ETA. A starting point in the plot of the time series is selected with a left click. Then paste the values from the clipboard by choosing Paste in the context menu (right mouse button). As an alternative to the context menu, use the shortcut <CTRL>+<V>. The values in the plot, starting at the selected starting point, are then replaced by the values from the clipboard.
The functionality corresponds to the insertion into Data Grids described in the previous section. The advantage is that the desired position for importing the data may be easier to find in the graphical representation of the plot than in the data grid of a value table.
If the source data are formatted differently (e.g., different decimal separators are used), the insertion cannot be done the way described.
It is possible to extend the target time series by adding values beyond the existing time points. The additional points in time are added automatically. Only for non-equidistant (unequally spaced) time series, the length of the last sample (the increment of the last time step) must be specified (see following figure).
