USGS Home Contact USGS Search USGS

SV_Qm Creator

Name:
SV_Qm Creator - Enter historical measurements into SiteVisit through the loader from an MS-Excel 2007 spreadsheet.

Information:

When loading many historical measurements into NWIS SiteVisit from a 9-207 form it can be cumbersome to use quick_entry. This Excel spreadsheet can be used instead. You can fill out the desired fields in the spreadsheet, create a HydroML file for each entry, and then load the files into SiteVisit using the loader.

Usage:

See the attached 'readme': SV_Qm_Creator_readme.doc

Installation:

Simply download the spreadsheet to the location of your choice.

Script Language:
Excel VBA

Requirements:

• Must have NWIS 4.11 installed.
• You will need at least USER rights in SiteVisit to load the resulting measurements.

Original Author(s): Joel Dudley, Maine WSC

Note the original author is noted on this page for the purposes of giving credit only. Please address questions/comments to OSW (GS-W OSW Scripts@usgs.gov).

Known Problems/Limitations/Need Improvements:

Scripts:

Version 1.1: posted (12/16/10) (Office 2003 or 2007 version)
- Fixed mislabeling of air and water temperature columns

SV_Qm_Creator download (xlsm file = 75K)

Version 1.3.2: posted (12/19/11) (Office 2007 or 2010 version)
- Now allows use of QUNSP method
- Supports alternate collecting agency codes (same code is used for the entire sheet, however)
- Added QA check for area * velocity within 3% of entered discharge (causes 'WARNING' in entry status column)
- Added check for valid directory before run
- Added data validation for numeric fields to not allow alpha characters
- Now greying out width, area, and velocity for Discharge methods other than QSCMM and QADCP
- Added tool-tips on width, area, and velocity to remind users when they are not used (only used with QSCMM and QADCP measurements...)
- Added optional time column
- Removed need for delimiter in date column, but dates must be entered exactly as specified

SV_Qm_Creator download (xlsm file = 75K)