<body> <p>This page uses frames, but your browser doesn't support them.</p> </body>

Reminders_and_Notes | Personal_and_Lake_Info | CLMP_Data_Template

Last_name | Example-Smith | Schneider | | | | | | | | | |
First_name | John | George |
CLMP_number | 9999 | 5273 |
Lake_name | Casey | Rice |
Lake_number | 62-0005 (What's this? See below.) | 27-0116 |
Site_number | 201 (What's this? See below.) | 201 (Center of lake) |
County | Ramsey | Hennepin |
Phone_summer | 651-555-1234 | 763-420-8027 |
Phone_winter | 651-555-4321 | 763-420-8027 |
Email | [email-masked] | [email-masked] |
Did_you_monitor_this_site_last_year? | Yes | Yes |
Lake_depth_at_sampling_site_ft[1] | 5 | 11 |
| | ^Please fill out this section.^ |
| | |
The image below should help you find the correct numbers to enter in the above table. |
You can find these numbers on page 2 of your individual site report. |
Don't forget to save after filling out the table above. | |
| | |

| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | | | | | | | | | |

[1]
The depth at your sampling location and not the maximum depth of the lake.

CLMP Electronic Datasheet
Citizen Lake Monitoring Program (CLMP)

There are three worksheets in this document; click on the tabs on the bottom to see each one. |
1. Reminders and Notes: Refer back to this tab for help filling out the other worksheets. |
2. Personal and Lake Info: Basic information about you and your sampling location. Please fill out all of the personal and lake information.
3. CLMP Data Template: Enter your data in the table. |

Data Template Reminders |
• Don't forget to save after every entry. | |
• Enter your data into the CLMP_Data_Template table as you would fill out your hardcopy datasheet. |
• If you sample more than one site, fill out and submit one Excel document for each lake site. |
• You will find drop-down menus and notes in the template to help you with your choices. |
• Type out time in hh:mm format plus "AM" or "PM". | |
• Record Secchi depth carefully: 6 ft, 6 in is 6. 5 ft (not 6.6 ft). |
• If disk is on lake bottom, mark “B” in Bottom? column. |
• Physical Condition & Recreational Suitability: Each day that you sample record the one number that best describes the physical condition (appearance) and the recreational suitability of the lake water at your sampling site. See scale below.
| | |
Physical Condition (PC) | | | | | | | | Recreational Suitability (RS) | | |
1 = Crystal clear water | | | | 1 = Beautiful, could not be better |
2 = Not quite crystal clear - a little algae present/visible | | | 2 = Very minor aesthetic problems; excellent for swimming, boating
3 = Definite algae green, yellow, or brown color apparent | | | 3 = Swimming and aesthetic enjoyment slightly impaired because of algae levels |
4 = High algae levels with limited clarity and/or mild odor apparent | |
5 = Severely high algae levels with one or more of the following: | | 4 = Desire to swim and level of enjoyment of the lake substantially reduced because of algae levels (but boating is okay)
| - massive floating scums on the lake or washed up on shore |
| - strong, foul odor | | | | 5 = Swimming and aesthetic enjoyment of the lake nearly impossible because of algae levels
| - fish kill (please note the number and types of fish) | |
|

Email completed data templates to [email-masked] by November 5, 2010. |
Questions? Contact Miranda Nichols at 651-757-2614 (Twin Cities Metro), 800-657-3864 (Greater Minnesota), or e-mail [email-masked].
| | | | | | | | | | | | | |

Line | Date | Time_hh:mm[1] | Secchi_Depth_ft[2] | Bottom?[3] | Physical_Appearance[4] | Recreational_Suitability[5] | Water_Color | Notes | | | | | | | | | | | | | | | | |
Ex. | 5/10/2010 | 1:15 PM | 5.5 | B | 2 | 3 | Green | Very windy |
1 | 4/11/2010 | 5:00 PM | 4 | | 3 | 3 | Tea Stained | Air temp = 76; Water temp = 61 |
2 | 4/18/2010 | 4:00 PM | 4 | | 3 | 3 | Tea Stained | Air temp = 78; Water temp = 62 |
3 | 5/9/2010 | 5:00 PM | 6 | | 2 | 2 | Tea Stained | Air temp = 60; Water temp = 58; .50" rain 48 hours ago |
4 | 5/15/2010 | 4:30 PM | 5 | | 3 | 3 | Green | Air temp = 73; Water temp = 62; 1.0" rain past 72 hours; new Aphanizomenon algae bloom starting | | Tristan Bay (outbound Rice Lake via Elm Creek) 7/9/10 | | Fish Kill - Photo taken at Elm Creek Dam 7/13/10 |

5

5/23/2010

2:00 PM

4.5

3

3

Green

Air temp = 83; Water temp = 68; Aphanizomenon algae bloom getting heavier

| |

6 | 5/29/2010 | 4:00 PM | 7 | | 2 | 2 | Green | Air temp = 85; Water temp = 76; Aphanizomenon algae bloom reduced impact |
7 | 6/7/2010 | 6:00 PM | 2.5 | | 3 | 3 | Green | Air temp = 75; Water temp = 76; Aphanizomenon algae bloom reduced impact |
8 | 6/20/2010 | 2:30 PM | 2.5 | | 3 | 3 | Green | Air temp = 75; Water temp = 77; Aphanizomenon algae bloom reduced impact |
9 | 6/27/2010 | 4:00 PM | 3 | | 3 | 3 | Green | Air temp = 82; Water temp = 78; Aphanizomenon algae bloom reduced impact |
10 | 7/2/2010 | 7:30 PM | 1.5 | | 4 | 4 | Green | Air temp = 82; Water temp = 77; Aphanizomenon algae bloom getting heavier again |
11 | 7/12/2010 | 12:30 PM | 3 | | 4 | 4 | Green | Air temp = 77; Water temp = 79; Aphanizomenon algae bloom getting heavier again; beginning to see dead fish (see photo to right). |
12 | 7/25/2010 | 3:30 PM | 3 | | 4 | 4 | Green | Air temp = 84; Water temp = 85; Aphanizomenon algae bloom covering entire lake/creek; DO level at surface=8.66; 2 meter=4.03 . |
13 | 8/7/2010 | 6:30 PM | 3.5 | | 3 | 3 | Green | Air temp = 77; Water temp = 81; Aphanizomenon algae bloom throughout water levels; see photos at right |
14 | 8/15/2010 | 3:30 PM | 1.5 | | 4 | 4 | Green | Air temp = 73; Water temp = 78; Aphanizomenon algae bloom throughout water levels; some floating Coontail w/Duckweed |
15 | 8/22/2010 | 4:30 PM | 2 | | 4 | 4 | Green | Air temp = 88; Water temp = 80; Aphanizomenon algae bloom throughout water levels; some floating Coontail w/Duckweed | | Tristan Bay - August 3rd |
16 | 8/29/2010 | 6:00 PM | 1 | | 4 | 4 | Green | Air temp = 91; Water temp = 76; Aphanizomenon algae bloom throughout water levels; some floating Coontail w/Duckweed |
17 | 9/5/2010 | 4:00 PM | 1 | | 3 | 3 | Green | Air temp = 75; Water temp = 67; light Aphanizomenon algae bloom throughout water levels |
18 | 9/12/2010 | 4:30 PM | 2 | | 3 | 3 | Green | Air temp = 75; Water temp = 66 |

19

9/19/2010

5:30 PM

2

3

3

Green

Air temp = 75; Water temp = 66; light Aphanizomenon starting again; 2"+ rain past week

| |

20 | 9/26/2010 | 4:00 PM | 2 | | 3 | 3 | Green | Air temp = 63; Water temp = 61; light Aphanizomenon starting again; 2"+ rain past week | |
21 | 10/3/2010 | 5:30 PM | 2 | | 3 | 3 | Green | Air temp = 63; Water temp = 59; light Aphanizomenon present | |
22 | 10/9/2010 | 4:30 PM | 3.5 | | 3 | 3 | Green | Air temp = 84; Water temp = 64; light Aphanizomenon present; lots of leaves falling down | |
23 | 10/16/2010 | 12:30 PM | 4 | | 3 | 3 | Green | Air temp = 68; Water temp = 56; light Aphanizomenon present; most of leaves are down | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | | | | | | | | | | | | | | | | | | | | | | |

[1]
Type out time in hh:mm format plus "AM" or "PM". For example: 11:15 AM, 6:40 PM

[2]
Record carefully: 6 ft, 6 in is 6. 5 ft - NOT 6.6 ft.

[3]
If disk is on lake bottom, mark “B” in this column.

[4]
1 = Crystal clear water
2 = Not quite crystal clear - a little algae present/visible
3 = Definite algae green, yellow, or brown color apparent
4 = High algae levels with limited clarity and/or mild odor apparent
5 = Severely high algae levels with one or more of the following:
- massive floating scums on the lake or washed up on shore
- strong, foul odor
- fish kill (please note the number and types of fish)

[5]
1 = Beautiful, could not be better
2 = Very minor aesthetic problems; excellent for swimming, boating
3 = Swimming and aesthetic enjoyment slightly impaired because of algae levels
4 = Desire to swim and level of enjoyment of the lake substantially reduced because of algae levels (i.e. would not swim but boating is okay)
5 = Swimming and aesthetic enjoyment of the lake nearlyimpossible because of algae levels