You are currently reviewing an older revision of this page.
How can I import field data snapshots and observed targets from an external data source such as an Excel spreadsheet?
First, consider if the amount of data you want to import is reasonable. The more field data snapshots you attempt to include in a Calibration study, the longer it will take to calibrate. See the "Tips" section of this article: Using Darwin Calibrator.
If you really do need to import a large number of snapshots and observed targets, it can be done using ModelBuilder, but the source data will need to be in a specific format.
For PRVs, PSVs, FCVs, TCVs, GPVs and pumps, you'll need to specify the attribute you want to import (pressure/HGL to/from or flow) by mapping to the field "Pump Attribute (Label)" (this may be changed to "Directed Node Attribute (label) in the future since it also applies to valves) Below is the exact expected values to be mapped:
Note: the following example accompanies the Leakage Detection article.
Observed data sheet:
Snapshot sheet:
1) Go to Tools>Modelbuilder > New > Excel. Check the boxes for the sheets containing the snapshots and the observed targets.
2) Click next, change the coordinate units as per your model units.
3) Click next until mapping table; map the filed data of hydraulic grades, flows , element labels, time , owner etc. as shown in the image below. Please select Filed data snapshot, observed target as table type for observed data & Field Data Snapshot for Snapshot Labels.
4) Click next once done with the mapping of Modelbuilder, go to Calibrator to check the imported field data. It should look like this.
Using Darwin Calibrator
Performing Leakage Detection Using Darwin Calibrator
Using ModelBuilder to Import External Data