The files provided in this archive are stored as plain ASCII text files. These can be readily imported into standard database, spreadsheet, or statistical software packages. Rows 1-51 of each file contain the following metadata: Line Item Name Description ======================================================================================================= 01 File Name Names of raw files containing individual spectral measurements 02 Project Project name (generally, the name of the lake) 03 Date Date (formatted as YYYY-MM-DD) 04 Replication Measurement type (cal = calibration, above = above-surface, under = below-surface) 05 Plot Station number within lake (generally, 001) 06 Plot Scan Measurement number at station (generally, 001-018) 07 Cumulative Scan Cumulative measurement number within project 08 Instrument Instrument identifier 09 Integration t. Integration time used during measurement 10 Averaged Scans Number of scans averaged for each measurement 11 Start Time Start time for each measurement 12 End Time End time for each measurement 13 Software Vers. CDAP software version 14 Average Adj Average adjustment (internal) 15 Solar Angles Solar azimuth, elevation, and zenith (degrees) 16 Solar Azimuthal Solar azimuth (degrees) 17 Solar Elevation Solar elevation (degrees) 18 Solar Zenith Solar zenith (degrees) 19 GPS Latitude and longitude from the GPS (decimal degrees) 20 Altitude Altitude () 21 Latitude Latitude (decimal degrees) 22 Longitude Longitude (decimal degrees) 23 GPS Count 24 Data Logger 25 SCUFA 26 Fluorometer 27 Reserved 28 Reserved 29 Reserved 30 Irradiance 31 Calibration M. 32 Panel BDRF 33 Processing Pan. 34 OONL Correct 35 Lamp 36 Shutter Status 37 Unispec DC 38 Battery Voltage 39 Reserved 40 Decimal Time 41 Comments 42 Additional Data 43 Auto Integrat. 44 Reserved 45 Reserved 46 Reserved 46 Reserved 48 Reserved 49 Reserved 50 Reserved 51 Reserved Lines 52+ include the actual spectral measurements. The first field on each line is the wavelength (in nanometers), and subsequent fields represent each individual measurement at that wavelength. As described elsewhere (see link to "Brief description of spectroradiometry methods") a series of multiple spectra were measured both above and below the surface of the water, with calibration spectra acquired before and after each group. The "Replication" field (line 04 in the above list) provides the definitive explanation of which type of observation a given spectrum represents. However, the general pattern is as follows: # Description =================================== 1 Calibration 2 Calibration 3 Above-surface 4 Above-surface 5 Above-surface 6 Above-surface 7 Above-surface 8 Above-surface 9 Calibration 10 Calibration 11 Below-surface 12 Below-surface 13 Below-surface 14 Below-surface 15 Below-surface 16 Below-surface 17 Calibration 18 Calibration