_id	Spreadsheet to process WetLabs ECOTriplet files
1	Made by Kate Yezhova
2	Last modified on 2025-06-01
3	"To copy data from .raw file into this spreadsheet, right click on the .raw file, choose ""Open with"", then choose any text editing software. Once opened in a text editing software, press Ctrl+A on your keyboard to select all, Ctrl+C to copy, and paste into this spreadsheet in the yellow raw data fields."
4	The .raw files will contain a column for date, time, wavelength #1, count #1, wavelength #2, count #2, wavelength #3, count #3, and therm.
5	Column to the right of the 700nm wavelength is scattering count
6	Column to the right of the 695nm wavelength is the chlorophyll count
7	Column to the right of the 595nm wavelength is the phycoerythrin count
8	Column to the right of the 460nm wavelength is the fDOM count
9	Thermistor column gives temperature output in counts
10	In order to convert from counts to engineering units (concentrations), you need the SCALE FACTOR and DARK COUNTS from calibration documents (either characterization sheets or .dev files)
11	Use the calibration documents that are closest in date to, but earlier than, the ECO deployment date.
12	The formulas to convert from counts to engineering units are:
13	fDOM (ppb) = Scale factor * (Output counts from raw data - Dark counts)
14	CHL (ug/l) = Scale factor * (Output counts from raw data - Dark counts)
15	Phycoerythrin (ppb) = Scale factor * (Output counts from raw data - Dark counts)
16	Temperature (degC) = (Output × Slope) + Intercept
17	The manufacturer recommends that the user perform a field characterization on fluorometers using a solution of a known concentration in volts or counts to make sure that the data is as accurate as possible for the user's application. The scale factor and the dark counts values can vary depending on the natural water, temperature, length of the cable, the power supply, and other factors.
18	NOTE ABOUT FDOM/CDOM: The manufacturer has changed the nomenclature for the output of all dissolved organic matter fluorometers. Fluorescent dissolved organic matter (FDOM) replaces colored dissolved organic matter (CDOM). FDOM aligns the fluorescence measurement with the output description.