### Appendix 3-F(1) Comparison of SAM Outputs Generated Using Individual Soil Map Unit Scenarios or Soil WQI Grouping Scenarios in Mark Twain Lake Basin, MO
This appendix, the first of three spreadsheets, is provided in support of the comparison of model outputs using scenarios based on individual soil map units (MU) or on soils grouped according to USDA Water Quality Index (WQI) groupings in Section 3.3 of the SAP document Development of a Spatial Aquatic Model (SAM) for Pesticide Assessments . The outputs are also compared with monitoring data from the Atrazine Ecological Exposure Monitoring Program (AEEMP) and the Atrazine Monitoring Program (AMP) in the Mark Twain Lake area. Monitoring data and descriptions can also be found in Appendix 2C.

The table to the right describes each tab linked to the monitoring sites found in the Mark Twain test basin. Figures 1 and 2 (below) shows the locations of the test sites. Each basin is identified both by the original study ID and by the NHDplus (version 2) comid for the catchment that is associated with the monitoring sampling site (pour point).

Figure 1: Location of Test Basin Areas for SAM Model Development and Evaluation.

Figure 2: AEEMP and AMP Monitoring Sites in the Mark Twain Lake (MO) Test Basin Area.Worksheet Tab SummaryByYear

MO-01_4989415_basin MO-02_5042380_basin MO-04a_4989385_basin MO-04b_4989739_basin MO-05_5042400_basin MO-05b_5039952_basin MO-08_2508563_basin AEMP_Monitoring1 AMP_Monitoring

Each basin tab includes the foll

Field Data for Soil Groupings: Date Est. Conc (ug/L), Aggreg Scenarios Rmass (kg), Aggreg Secnarios
Runoff(m)
RConc(ug/L)
TotalFlow(m3) baseflow(m3)Cumul. Runoff Loss, Aggreg Scenarios
Data for Individual Map Units: JulD Est. Conc (ug/L), Indiv. MU Scenarios Rmass (kg), Indiv. MU Scenarios Runoff(m) RConc(ug/L) TotalFlow(m3) baseflow(m3) Cumul. Runoff Loss, Indiv. MU ScenariosContents Summary of annual (2000-2014) total runoff, total mass lost, and maximum atrazine concentrations based on individual soil map units or soil WQI groupings for each test basin site. Includes graphs comparing concentration estimates, cumulative mass losses.

Results for AEEMP site MO-01 (NHD+ comid 4989415) Results for AEEMP site MO-02 (NHD+ comid 5042380) Results for AEEMP site MO-04a (NHD+ comid 4989385) Results for AEEMP site MO-04b (NHD+ comid 4989739) Results for AEEMP site MO-05 (NHD+ comid 5042400) Results for AEEMP site MO-05b (NHD+ comid 5039952) Results for AEEMP site MO-08 (NHD+ comid 2508563) Monitoring data for each of the AEEMP test basin sites (used for graphs) Monitoring data for each of the AMP test basin sites (used for graphs)
owing fields:
Description/source
Daily dates from scenario, 1/1/2000 - 12/31/2014 Estimated daily concentrations generated using aggregated scenarios (soils grouped by WQI criteria) Daily pesticide mass flux lost in runoff generated using aggregated scenarios (soils grouped by WQI criteria) Daily runoff volume using aggregated scenarios (soils grouped by WQI criteria)
Daily runoff concentration using aggregated scenarios (soils grouped by WQI criteria)
Total flow estimate in stream mixing cell, based on NHD+ data Base flow estimate for stream mixing cell (see Section 2.1)Cumulative pesticide mass lost in runoff (summing daily Rmass values)

Julian dates from scenario, 1/1/2000 - 12/31/2014 Estimated daily concentrations generated using individual soil map units
Daily pesticide mass flux lost in runoff generated using individual soil map units
Daily runoff volume using individual soil map units Daily runoff concentration using individual soil map units Total flow estimate in stream mixing cell, based on NHD+ data Base flow estimate for stream mixing cell (see Section 2.1) Cumulative pesticide mass lost in runoff (summing daily Rmass values)