This file corresponds to the datafile "Smearing Method MW_TP.csv", for the total phosphorus (TP) 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: 522846.5 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 TP concentrations by the corresponding discharge values (both occurring at 15:00). (2) The natural log of daily TP 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 TP 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 TP 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 TP (raw) (ug/L) (2): measured TP samples taken daily at 15:00 TP (ug/s)(2): Discharge (L/s) multiplied by TP (ug/L) to get TP (ug/s) LN (Discharge) (2): Natural log of Discharge (m^3/s) LN (TP)(2): Natural log of TP (ug/s) Predicted (2): Predicted values of the regression of LN (TP) as a function of LN (Discharge) Residuals (2): Residual values of the regression of LN (TP) 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) TP (ug/s) modeled (3): TP calculated using the smearing method equation shown above TP (ug/15 minutes) (3): TP (ug/s) multiplied by 60*15 TP (ug/day)(3): TP(ug/15 minutes) summed for each day (values are blank unless it is the last 15 minutes of the day) TP (g/day) (3): TP (ug/day) converted to g/day TP (kg/day)(3): TP (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. "