One row per site. Adds coordinates for the map, reach groupings, and bracket roles (upstream, tributary, downstream). Auto-detected from PFAS file if omitted.
Required: Site ID | Optional: Lat, Lon, Reach_group, Bracket_role
⬇ CSV template
Reach Experiment CSV Optional
One row per bracketing experiment. Defines upstream/tributary/downstream sites. Use pipe "|" for multiple sites. Enables ΔΣPFAS contrasts and mixing fractions.
[1] Helsel, D.R. (2012) Statistics for Censored Environmental Data Using Minitab and R, 2nd ed. John Wiley & Sons. — Foundation for censored data methods (MI, substitution, distributional approaches). [2] Rubin, D.B. (1987) Multiple Imputation for Nonresponse in Surveys. John Wiley & Sons. — Theoretical basis for MI framework. [3] Lubin, J.H. et al. (2004) Epidemiologic quantification of exposure to environmental pollutants with left-censored data. Environ. Health Perspect. 112(17), 1691–1696. — MI for left-censored environmental data. [4] Helsel, D.R. (2006) Fabricating data: How substituting values for nondetects can ruin results. Chemosphere 65(11), 2434–2439. — Limitations of RL/2 and other substitution methods. [5] Antweiler, R.C. & Taylor, H.E. (2008) Evaluation of statistical treatments of left-censored environmental data. Environ. Sci. Technol. 42(10), 3732–3738. — Comparison of censoring methods for water quality data. [6] US EPA (2024) Method 1633: Analysis of per- and polyfluoroalkyl substances (PFAS) in aqueous, solid, biosolids, and tissue samples by LC-MS/MS. EPA-821-R-24-002. [7] Spearman, C. (1904) The proof and measurement of association between two things. Am. J. Psychol. 15(1), 72–101. — Rank correlation used in MI vs RL/2 sensitivity. [8] Woodward, D.S. et al. (2024) Time-of-travel synoptic survey with concurrent streamflow measurement for PFAS stream loading. ACS ES&T Water 4(10), 4356–4367. — Synoptic PFAS loading methodology.