Data Entry, Import and Export


Importing and Exporting Microsoft Excel and “.CSV” Data

Importing, exporting and editing data with Microsoft Excel is accomplished in HEC-DSSVue by the “plug-in” “Excel.jar”, stored in the HEC-DSSVue Plugins directory.  Plug-ins can be updated without having to update the HEC-DSSVue program itself.  Refer to the HEC-DSSVue plug-ins web page for updates at:  http://www.hec.usace.army.mil/software/hec-dss/plug-ins.htm.

At this time, only time-series data can be imported into HEC-DSS.  Check the web site above for updates.  Both time series and paired data can be exported to Excel but only time-series data can be edited in Excel.

You can also import time-series data in a comma separated format (.csv) or data separated by blank spaces, using the same procedure with the “Time Series Wizard”.  This plug-in is in a development stage; check the plug-ins web page for updates.

Note:  Excel uses beginning of period dates, whereas HEC-DSS uses end of period.  Thus, the average data for a day will show at 0000 hours in Excel and 2400 hours in HEC-DSS.  This can cause a time shift by a day if the data is not imported or exported carefully; Check your data after the operation.  You can shift data to the correct times by using the Time Functions tab in the Math Functions screen.
 

More:

Exporting Data to Microsoft Excel

Editing Data in Microsoft Excel

Importing Data from Microsoft Excel or ".csv" files using Data Entry

Importing Data from Microsoft Excel or ".csv" files using Time Series Wizard