Development and evaluation of an improved TFM formulation for use in feeder stream treatments

The data for this project can be broken down into three sub-groups: TFM Pellet data, Temp data, and Water Quality data. Each subgroup and associated csv files are explained below: TFM Pellet data: The TFM Pellet dataset consists of 36 individual csv files with each file having a unique name making it representative of 1 trial of the study. For example “0.08 mps at 12C Trials rep 1.csv” would be the first replicate with a flow of 0.08 meters per second and a water temperature of 12°C. Each of the csv files has 16 columns of data. Target Temp: The target temperature of the trial Target Velocity: The target velocity (m/sec) of the trial Replicate #: The rep of the trial Actual Temp: The actual measured temp at the beginning of the trial Average Actual Velocity: The measured velocity in m/sec Average flow: The measured flow in Liters/min Average Height: The measured height of the water column (mm) Mass of TFM in Pellets: The mass of TFM (grams) in the pellets used Time Between Samples: the time in minutes between each sample Sample Name: a unique name given to each sample based on the time Time: numeric description of how many hours into the trial it has been River Conc.: TFM concentration (mg/L)provided by HPLC data TFM Released: The amount of TFM in mg released from the pellets during the previous sample time based on the River Conc. at this sample time: Total TFM Released: a cumulative amount of TFM released % TFM Used: Percent TFM that is gone from the pellets, essentially a percent recovery % recov correction: corrects for the amount of TFM used in order to have a total recovery of 100% Temp Data: This dataset consists of 3 csv files, one for each of the three temperatures in our trials. Temp 12.csv, Temp 16.csv, Temp 20.csv. Each file has a summary of recorded temps in Celcius for the 12 trials that were run at the temperature associated with the file name. There are only two columns in each file: Date_Time, and Temp. The “Date_Time” column shows the date and time the temperature was recorded. The “Temp” column shows the temperature that was recorded in degress celcius. Water Quality data: This data consists of a single csv file summary of the water quality collected during each trial. There are 11 columns in the file: Velocity: Target velocity of the trial Temperature: Target temp of the trial Replicate: rep (1-4) of each trial pre post: whether or not the data was collected at the beginning (pre) or end (post) of each trial pH: the measured pH Alk: the measured alkalinity (mg/L CaCO3) Hardness: the measured hardness (mg/L CaCO3) Flow 1: There were two flow measurements taken before each trial and two flows taken at the end of each trial. This represents the first one taken and is in L/min. Flow 2: This represents the second flow reading taken in L/min. Depth: the depth of the water column in mm Velocity: the calculated velocity of the stream in meters per second