HydroObjects Spreadsheets

The HydroObjects Spreadsheets allow a user to access information for a network using MS Excel via webservices (macro buttons)

I decided to create one HydroObjects excel sheet for each of our data networks for 2 reasons:

1. Users don't have to copy paste WSDL for different networks.

2. I can pre-populate site catalog and site list for the networks that don't change much. One network has 1089 sites so it takes 2 hours or more to load the site catalog.

I plan to post these individual spreadsheets to our website for people to access.

We wish: The site catalog had one row per site so we could sort on Lat/Long or dates or value count. That the USGS basin code were available in the ODM of Sites table and the SiteCatalog sheet of HydroObjects.