Welcome to the data file for the Missouri Stream Team Chloride program in the St. Louis region.
The administrator of this file is Danelle Haake (email@example.com).
|Frequently Asked Questions|
How is this file laid out? Where is my data?
|Each stream site has its own tab at the bottom of this screen. These tabs are arranged alphabetically by stream name. If there are multiple sites in a stream, the lowest numbered site is the furthest upstream in the watershed. Following the stream name and site number is the name(s) of the volunteer(s) who monitor the location.|
Scrolling to my site takes forever. Is there a faster way to find my tab?
|Yes! In the lower left corner, you will see an icon with 4 stacked lines (it is to the right of the plus sign). Click on this and it opens a list of all of the tabs.|
What is up with all the little lock symbols on each tab?
|Each tab is locked so that only the volunteers actively monitoring the site or the file administrator (Danelle) are able to change or add data in a given tab. This is intended to prevent accidental edits to data from the wrong site. Anyone with a link to the file can view all of the data.|
So, can I add my own data?
|Absolutely! Please note, if there is more than one volunteer/group monitoring at your site, please put your initials in column J next to any data you add - this will make it easier to follow up with questions.|
You will need a Google account to log in. You can set up a Google account from any email address - it does not need to be a Gmail account. Once you have a Google account, contact Danelle (firstname.lastname@example.org) to set up access to the tab for your site. Be sure to include the email address associated with your Google account so that the permissions will be set properly.
Why can't I edit or add to the data for my site(s)?
|If you need access to make edits to a tab, please contact Danelle (email@example.com) to set up access. Be sure to include the email address you would like to use to log in to Google Docs so that the permissions are set properly. You can set up a Google account from any email address - it does not need to be a Gmail account.|
I have a new monitoring site. How can I add it?
|Contact Danelle (firstname.lastname@example.org) and she will add a new sheet for you. This will generally be completed within a couple of days.|
Do I need to do anything in the summary or the graphs to make them update?
|No. These will automatically update as you add data.|
What should I enter if my conductivity meter was OR (over-range)?
|Please leave the conductivity space blank if the meter was over-range for that sample.|
What is the Conductivity vs. Chloride graph for?
|Conductivity measures the amount of ionic charge in water and is often used as a surrogate measurement for chloride (Cl- ion). The two generally have a linear relationship, particularly when chloride becomes a dominant ion in the sample water (like when lots of road salt is dissolved in the stream). In waters with little chloride (see Hamilton Creek 1 and 2), the relationship is a bit shaky because other ions like carbonate, magnesium, and potassium also contribute various amounts to the conductivity. In waters with lots of chloride, the relationship between the two can be quite striking (see Creve Coeur Creek 4 or River des Peres 1).|
Where can I put snowfall data?
|There is a tab called "Precipitation" where you can add information about snowfall, ice, sleet, etc. Or you can add it to the notes section of your data sheet.|