This file corresponds to the datafile "Smearing Method OF_TR.csv",for the total residue (TR) load calculation for the outlet of Fernan Lake from April 2014 to April 2015 The location is referred to as OF or Outflow Location of sampling site: Longitude: 522846.5 Latitude: 5279425.8 "Coordinates are in UTMs, NAD 1983" "Due to the seasonal changes with the addition of the Dam, the smearing method was only applied for days that the dam was not in place." "** For the days where the dam was in place, a linear interpolation of discharge was calculated between the bi-weekly sampling dates, the interpolated values were used for daily discharge and multiplied by the concentrations. " The values were then multiplied by 60*60*24 to gain daily loading values. "The following description is the calculation of daily loads using the non-parametric smearing method, see references below." 15 minute interval stages were converted to discharge values using the rating curve equation developed by T. LaCroix. (1) Daily loads were calculated by multiplying measured TR concentrations by the corresponding discharge values (both occurring at 15:00). (2) The natural log of daily TR loads was then plotted as a function of the natural log of discharge and a linear relationship was determined. (2) A bias-correction factor was estimated as the mean of the residuals. (2) "To estimate daily TR loading, the linear model and corresponding bias-correction factor was applied to the continuous discharge data for each site in the log transformed form:" Load=exp[b0+b1*ln(Q)]*[Σ exp(ei)/n] "Where Q is discharge (m3/s), ei are the residuals, n is the number of residuals, and b0 and b1 are site-specific fitted parameters. (3)" The daily TR loading estimates were summed to estimate annual loads (3) References Colin TA. 1995. Recent advances in statistical methods for the estimation of sediment and nutrient transport in rivers. Review of Geophysics 33: 1117. Duan N. 1983. Smearing estimate: a nonparametric retransformation method. Journal of American Statistical Association 78: 605–610. "Helsel DR, Hirsch R. 2002. Statistical methods in water resources techniques of water resources investigations, Book 4, chapter A3. Geological Survey." Column Descriptions Date time (1) : Date and time for the assoicated 15 minute interval water levels used to complete step 1 Julian Day (1): Fractional julian day used for the purposes of plotting data Stage (m) (1): Raw water level data downloaded from HOBO onset water level loggers Discharge (m^3/s) (1): Discharge data calculated using the stage discharge relationship (rating curve) developed by T.LaCroix (y=8.5444x^2.4257) Date time (2): Date and time at 15:00 each sampling day Julian Day (2): Fractional julian day at 15:00 each sampling day Stage (m) (2): Water level at 15:00 each day Discharge (m^3/s) (2): Discharge data at 15:00 calculated using the stage discharge relationship (rating curve) developed by T.LaCroix (y=8.5444x^2.4257) Discharge (L/s) (2): Discharge data at 15:00 each data converted to L/s for the analysis TR (raw) (mg/L) (2): measured TR samples taken daily at 15:00 TR (mg/s)(2): Discharge (L/s) multiplied by TR (mg/L) to get TR (mg/s) LN (Discharge) (2): Natural log of Discharge (m^3/s) LN (TR)(2): Natural log of TR (mg/s) Predicted (2): Predicted values of the regression of LN (TR) as a function of LN (Discharge) Residuals (2): Residual values of the regression of LN (TR) as a function of LN (Dischage) EXP (Residuals) (2): Exponentiated residual values b0 (2): site specific fitted parameter b1 (2): site specific fitted parameter bias (2): site specific bias correction factor Date time (3): Date and time in 15 minute intervals for the duration of the study period Julian day (3): Fractional julian day used for the purposes of plotting data Stage (m) (3): Raw water level data downloaded from HOBO onset water level loggers Discharge (m^3/s) (3): Discharge data calculated using the stage discharge relationship (rating curve) developed by T.LaCroix (y=8.5444x^2.4257) LN (Discharge) (3): Natural log of Discharge (m^3/s) (blank when dam is in) "TR (mg/L) (3): Measured TR data (raw) used when the dam was in, used with the linear interpolation of discharge (blank when the smearing method was applied) " TR (mg/s) modeled (3): TR calculated using the smearing method equation shown above (blank when dam is in) TR (mg/s) (3): used when the dam was in with linear interpolated data (blank when the smearing method was used) TR (mg/15 minutes) (3): TR (mg/s) multiplied by 60*15 TR (mg/day)(3): TR(mg/15 minutes) summed for each day (values are blank unless it is the last 15 minutes of the day) TR (g/day) (3): TR (mg/day) converted to g/day TR (kg/day)(3): TR (g/day) converted to kg/day "** Note there is some repitition with the columns associated with each step (labeled 1-3), this was for the purposes of organization throughout the steps. "