TCRMP_Master_Algae_Heights_Jan2022.xlsx

	A	B
1	Sheets
2	SiteMetadata	List of TCRMP sites with identifying information
3	SubstrateCodes	List of codes used in the TCRMP algae heights dataset and what they mean
4	DataValidation	List of codes used for validation purposed in the "HeightsRawData" tab - do not alter
5	HeightsRawData	Raw algae heights data
6
7
8	Columns
9	Location	Monitoring location at which data was collected
10	SampleDate	Date on which data was collected
11	SampleYear	Monitoring period in which data was collected; Note - Sample year may not always match the year from the SampleDate if a location was surveyed late in the annual monitoring period (i.e. data collected in January 2018 could be included in the 2017 annual monitoring period)
12	SampleMonth	Month in which data was collected; Note - when a location was not surveyed fully in the same month, the month in which sampling began is used as the sample month
13	Period	Refers to the sample period in which the data falls; Periods are as follows: Annual (normal annual TCRMP sampling), PeakBL (secondary TCRMP sampling to capture peak bleaching due to thermal stress), PostBL (secondary sampling as a follow up to thermal stress), SCTLD (extra sampling points taken at a subsample of TCRMP locations to monitor the progression of Stony Coral Tissue Loss Disease), and WS (samples taken at a subset of TCRMP locations [Black Point, Buck Island STT, Coculus Rock, Magens Bay, Botany Bay, Savana, Flat Cay, Seahorse Cottage Shoal] during research cruises aboard the R/V Walton Smith)
14	Recorder	Diver who recorded the data
15	Transect	Transect number; Note - there are typically 6 transects per site, but additional transects may have been recorded
16	Substrate	Indicates the type of algae being measured
17	Height	Height in cm of the substrate measured undisturbed perpendicular to the plane of growth
18	Notes	Additional notes about the transect or substrate
19
20
21	Other Notes
22	1	Algae heights are measured on the same transects as those used for coral health assessments. Transects are 10 m in length and there are typically 6 per site though additional transects may have been recorded. Algae heights are measured every 50 cm along the transect line for a maximum total of 20 measurements. If no algae is present at the designated measurement interval, the interval is skipped
23	2	Peyssonnelia sp (PEY) was added as a substrate category in 2014
24	3	Filamentous turf algae with sediment was added as a substrate category in September 2015
25	4	All measurements recorded as "encrusting Lobophora sp" (ENLOBO) prior to 2016 were changed to Peyssonnelia sp in January 2016
26	5	Ramicrusta sp (RAMI) was added as a substrate category in 2017
27	6	Prior to 2016, Peyssonnelia sp and CCA heights recorded as 0 or presence/absence were entered as a height of 0.1 cm (minimum measurement)
28	7	Beginning September 2016, all encrusting forms of macroalgae (CALG, PEY, RAMI) are recorded as presence/absence and entered in the raw data as "1" to denote presence
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100