HEC-DSS MS Excel Add-In

The HEC-DSS Excel Data Exchange Add-In is a Visual Basic Application for retrieving and storing both regular-interval time series and paired data directly from Excel to an HEC-DSS database file. Data sets to retrieve are selected from a catalog listing directly available from Excel. For time series data, an optional time window can be specified to select portions of a DSS record or to span several records. The exchange of irregular-interval time series data has not been implemented at this time.

The HEC-DSS Excel Data Exchange Add-In is a separate capability from the HEC-DSSVue Excel Plug-in.  The HEC-DSSVue Excel plug-in is run from HEC-DSSVue and can read and write both regular and irregular-interval time series data, but has not been implemented for paired data.  The HEC-DSS Excel add-in is run from within Excel.  While the format of the data is more restrictive, it can read and write both regular interval time series data and paired data, but not irregular-interval time series data.

Version 3.2 Changes

1. Added ability to specify data worksheet.
2. Added 3 worksheet data formats.
3. Added ability to retreive data by RiverWare header specifcations.
4. Added ability to store data by group specifications or RiverWare header specifications.
5. Added ability to specify time ranges for all non full catalog time series retrievals, group specification storage, and RiverWare header storage.

Version 3.2.1 Changes

1. Excel 2007 row and columns limits.
2. Support of Excel 2007 and older formats.
 

Download HEC-DSS Excel Data Exchange Add-In For Excel 2007-2010 Version 3.2.1

After running the setup package, you must load the add-in inside of Excel. See the documentation for instructions on how to do that.

Documentation for Excel 2003 or Excel 2007-2010 versions of the add-in.

If you encounter any problems with this add-in, please contact hec.dss@usace.army.mil.