This file corresponds to the datafile "Smearing Method MW_TR.csv", for the total residue (TR) load calculation for Fernan Creek from April 2014 to April 2015 "The location is referred to as MW or Mike Webb, the name of the landowner who owns the property" Location of sampling site: Longitude: 518586.2 Latitude: 5281453.9 "Coordinates are in UTMs, NAD 1983" "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=1.5009x^2.4678) 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=1.5009x^2.4678) 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=1.5009x^2.4678) LN (Discharge) (3): Natural log of Discharge (m^3/s) TR (mg/s) modeled (3): TR calculated using the smearing method equation shown above 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. "