Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel Output: MCS missing bin depths and smoothed data (v,w) include scaling #6

Ryan-Jackson-USGS opened this issue Apr 26, 2017 · 1 comment


Copy link

@Ryan-Jackson-USGS Ryan-Jackson-USGS commented Apr 26, 2017

There are two issues with the VMT 4.08 r20170404 Excel output tables:

  1. The MeanCrossSection worksheet is missing the bin (or grid node) depths. Only the bed elevation is listed.

  2. The transverse velocity and vertical velocity components listed in the Smoothed_MeanCrossSection worksheet are incorrect. The transverse velocity must be multiplied by the vector scale factor and the sign must be changed (if the cross section is flipped to look DS) to recover the true transverse velocity (as given if one sets the contour variable to be the transverse velocity and exports the Excel file--see figure below). Likewise, the vertical velocity in this worksheet must be divided by (sf/exag) and the sign must be flipped if the reference is DFS to recover the true vertical velocity (sf is the vector scale factor and exag is the vertical exaggeration).

Copy link

@frank-engel-usgs frank-engel-usgs commented Oct 5, 2017

I have modified VMT to address these issues. VMT now outputs a formatted Excel file, and implements the suggestions @Ryan-Jackson-USGS has made.

The new release v4.08 r20171005 will be compiled and distributed on the OSW VMT website.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
None yet

No branches or pull requests

2 participants