<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.) | 202 (Outlet Bay on Elm Creek) |
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 | 3.5 |
| | ^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 | 3/16/2010 | 6:00 PM | 3.5 | | 2 | 2 | Tea Stained | Ice going out this week on creek |
2 | 3/21/2010 | 5:00 PM | 3.5 | | 3 | 3 | Tea Stained | Tar ball' clumps of algae floating in creek |
3 | 3/24/2010 | 6:00 PM | 3 | | 3 | 3 | Tea Stained | Ice still on lake; all out on creek |
4 | 4/1/2010 | 1:00 PM | 3.5 | | 3 | 3 | Tea Stained | Ice is all out now; still 'Tar ball' clumps floating in creek |
5 | 4/5/2010 | 6:00 PM | 2.5 | | 3 | 3 | Tea Stained | Still some algae blobs floating in creek |
6 | 4/10/2010 | 6:00 PM | 2 | | 4 | 4 | Tea Stained | Still some algae blobs floating in creek; water is cloudy |
7 | 4/18/2010 | 2:00 PM | 2 | | 4 | 4 | Tea Stained | Lots of leaves/debris in water |
8 | 5/1/2010 | 4:30 PM | 2 | | 4 | 4 | Tea Stained | Lots of leaves/debris in water |
9 | 5/9/2010 | 6:30 PM | 2.5 | | 3 | 3 | Green | Air = 60; Water = 60; .5" rain 2 days ago |
10 | 5/15/2010 | 6:30 PM | 5 | B | 2 | 2 | Green | Air = 73; Water = 63; .5" rain past 2 days; Light Alphaminezon starting |
11 | 5/23/2010 | 4:00 PM | 2.5 | | 3 | 3 | Green | Air = 83; Water = 73; Light Alphaminezon floating; Cottonwood starting to fall |
12 | 5/29/2010 | 6:00 PM | 4 | B | 3 | 3 | Green | Air = 85; Water = 80; heavier Alphaminezon floating; some floating algae blobs |
13 | 6/7/2010 | 6:30 PM | 2 | | 3 | 3 | Green | Air = 75; Water = 77; heavy Alphaminezon floating throughout levels |
14 | 6/20/2010 | 8:30 PM | 2.5 | | 3 | 3 | Green | Air = 74; Water = 79; heavy Alphaminezon floating throughout levels |
15 | 6/27/2010 | 6:30 PM | 1.5 | | 3 | 3 | Green | Air = 82; Water = 81; Alphaminezon floating throughout levels |
16 | 7/2/2010 | 9:00 PM | 1.5 | | 4 | 4 | Green | Air = 82; Water = 79; Alphaminezon floating throughout levels |
17 | 7/12/2010 | 2:30 PM | 2 | | 5 | 5 | Green | Air = 79; Water = 82; heavy Alphaminezon floating throughout levels |
18 | 7/13/2010 | 12:30 PM | 2.5 | | 5 | 5 | Green | Air = 75; Water = 84; heavy Alphaminezon floating throughout levels; fish kill; low DO (0.26) |
19 | 7/19/2010 | 5:00 PM | 3 | | 4 | 4 | Green | Air = 80; Water = 83; heavy Alphaminezon floating throughout levels; 1"+ rain last 2 days |
20 | 7/25/2010 | 6:00 PM | 4 | | 4 | 4 | Green | Air = 80; Water = 84; heavy Alphaminezon floating throughout levels; some algae globs |
21 | 8/1/2010 | 12:00 PM | 1.5 | | 5 | 5 | Green | Air = 82; Water = 79; heavy Alphaminezon floating throughout levels; scum on surface (see photos K23) | | Algae blooms with scum - Tristan Bay - 8/3/10 |

22

8/7/2010

7:00 PM

1

5

5

Green

Air = 80; Water = 84; heavy Alphaminezon floating throughout levels; strong odor

| |

Algae scum with floating coontail - Tristan Bay - 8/11/10

23

8/15/2010

5:00 PM

1.5

5

5

Green

Air = 73; Water = 79; heavy Alphaminezon floating throughout levels; clumps of coontail floating (see photo S25/Z25)

| | | |
|
| |

24 | 8/21/2010 | 4:00 PM | 1.5 | | 5 | 5 | green | Air = 88; Water = 84; heavy Alphaminezon floating throughout levels
25 | 8/22/2010 | 6:00 PM | 2 | | 4 | 4 | Green | Air = 88; Water = 82; heavy Alphaminezon floating throughout levels; floating coontail
26 | 8/29/2010 | 6:30 PM | 1.5 | | 4 | 4 | Green | Air = 86; Water = 88; heavy Alphaminezon floating throughout levels; floating coontail
27 | 9/5/2010 | 5:00 PM | 1.5 | | 4 | 4 | Green | Air = 72; Water = 69; heavy Alphaminezon floating throughout levels
28 | 9/12/2010 | 6:00 PM | 1.5 | | 4 | 4 | Green | Air = 75; Water = 70; heavy Alphaminezon floating throughout levels; leaves beginning to fall
29 | 9/19/2010 | 6:00 PM | 2 | | 4 | 4 | green | Air = 61; Water = 64; new Alphaminezon starting; 2"+ rain past week
30 | 9/26/2010 | 5:30 PM | 2.5 | | 4 | 4 | green | Air = 62; Water = 62; Alphaminezon throughout; 2"+ rain past week; high lake level
31 | 10/3/2010 | 6:00 PM | 2.5 | | 4 | 4 | green | Air = 68; Water = 59; light Alphaminezon throughout
32 | 10/9/2010 | 6:00 PM | 2.5 | | 3 | 3 | Green | Air = 80; Water = 66; light Alphaminezon throughout; lots of leaves down
33 | 10/16/2010 | 1:00 PM | 2 | | 4 | 4 | Green | Air = 68; Water = 58; light Alphaminezon throughout; most of leaves down
34 | 10/24/2010 | 5:00 PM | 2 | | 4 | 4 | green | Air = 55; Water = 40; light Alphaminezon; most of leaves down; 1st rain (.50") in 3 weeks
35 | | | | | | | |
36 | | | | | | | |
37 | | | | | | | |
38 | | | | | | | |
39 | | | | | | | |
40 | | | | | | | | |
| |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |

[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