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.
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.