Tabulate and Editing using
MS Excel (Optional)
If the Excel plug-in is loaded, you can tabulate (or export) data in Microsoft Excel and
edit time series data in Excel. Simply select the data sets you wish to tabulate as
you normally would and then either press the Excel icon in the toolbar, or select
Tabulate in Excel from the Display menu (assuming you have Microsoft Excel
installed). The figure below is an example of how the data is displayed in
Excel.
To edit data in Excel, select your data sets and select Edit in Excel from the
Edit menu. This will load the selected data into an Excel spreadsheet and then
read it back to DSS once you have saved it. In this mode, you may not add or
delete rows or columns, you can only change the data. After you are finished,
save the Excel spread sheet and then press OK or Cancel from the dialog from
HEC-DSSVue.
Note – Take caution with dates and time in Excel. Excel shows times as “Beginning
of Period”, while the HEC-DSS convention shows times as “End of Period”. A data value
for midnight will show up as 2400 hours at the end of the day in HEC-DSS, while Excel will
display that as 0000 hours for the next day. For daily data, the hours might not be
shown in Excel and the data can be misinterpreted to be for the following day.

Tabular data exported to Excel