| Applies To | |||
| Product(s): |
|
||
| Version(s): | All |
How do I enter time series field data and add it to my graph? (so that I can graph observed data along with calculated results)
If you have observed data that you would like to plot on a graph for an element so that you can view it layered on top of your model data, Time Series Field data can be used. This enables you to see how well calibrated your model data is to your field data and help identify differences in your model.
The Time Series Field Data feature is still available for legacy purposes but has been effectively replaced with the more powerful SCADA Element. The latest versions of the Water and Storm/Sewer products have a SCADA Element, which is a much better option for viewing field data alongside model results.
The following section is preserved for legacy purposes as this feature has been replaced with the SCADA Element (see above).
To use Time Series Field data:
1) Go to Components > Time Series Field Data
2) Right click on the element that you'd like to enter time series field data for and choose 'Add'
3) Choose the associated modeling attribute (property) which you will be creating the time series field data for
4) Choose the start date and time the data was collected, click the ellipsis button next to the element row to select that element in the drawing to which the time series field data will be associated with, and finally enter your time series field data in the table below.
5) In the model right click on the element you added the time series field data for and choose graph. When the graph series options dialog opens you can select Flow under the common or results section which will add your model results to the graph. Next, go to the time series field data result (highlighted below in red) and select the time series field data property.
My time series data is not lining up with my results
It takes too long to set this up for many elements
Consider the SCADA Signal feature. See article below for more.
As mentioned at the beginning of this article, the SCADA Element is the preferred approach, and you can configure the SCADA Signal to read directly from your SCADA data (database connection or file-based) without having to set up the necessary ModelBuilder configuration for bulk import.
If you must use time series field data and need to import it via ModelBuilder, it needs to be done in two passes (two separate imports with two separate worksheets/tables (for Excel or Access data source). Determine the necessary syntax for mapped fields by first creating a test/fake time series field data entry, then set up a ModelBuilder connection to a blank spreadsheet and perform a sync-out to export the values to the spreadsheet. Examine the syntax in the exported spreadsheet data to determine what you need to do for your actual import. Here are the two Table Types that need to be mapped:
Time Series: this is for the basic attributes associated with the time series entry such as the associated element and units. Basic fields that need to be mapped:
Time Series, Time Series Curve: this contains the actual table of time from start vs. data value, associated with the "time series" record.
Example: