{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Controls","Variable Definitions","Loaded Scenarios","Model Results","Model Input Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,1,13,17],[1,1,3,17],[4,1,4,17],[5,1,5,17],[6,1,6,17],[7,1,7,17]]}
[]
[null,"Watershed Management Optimization Support Tool (WMOST) \nScenCompare"]
[]
[]
[null,"Climate Scenario Viewer and Comparison Post Processor"]
[null,"Compatible with Microsoft Excel 2010, 2013, and 2016© "]
[null,"Please refer to the user guide for detailed instructions for using this tool."]
[null,"The original WMOST model was created in 2007 (Zoltay et al. 2010). WMOST development is sponsored by EPA. WMOST is maintained by Abt Associates."]
[]
[null,"INTRODUCTION"]
[]
[null,"● The WMOST model allows users to evaluate the effect of management options under various climate change scenarios to support robust decision-making."]
[null,"● The WMOST Climate Scenario Viewer and Comparison Post Processor was created to provide a  screening interface for WMOST to facilitate comparison across a series of WMOST runs that span a range of climate futures or any other scenario specifications. "]
[]
[]
[null,"NAVIGATION"]
[]
[]
[null,null,null,"The Controls tab provides access to steps in compiling and analyzing WMOST data"]
[]
[]
[null,null,null,"The Variable Definitions tab provides a description of the WMOST variables in the output data"]
[]
[]
[null,null,null,"The Loaded Scenarios tab provides the inventory of output files imported by the user"]

{"sheet":"Controls","index":1,"n_rows":162,"n_cols":8,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
["Step 1: Load data from selected WMOST log files.","Step 2. Compare decision variables across scenarios",null,null,null,"Step 3. Compare time series across scenarios."]
[null,"This step will compare all decision variables across scenarios:",null,null,null,"Series Variables (select below)","Category","Description"]
[null,"Stormwater BMPs",null,null,null,"COmAsr","O&M Costs","Aquifer storage and recovery (ASR)"]
[null,"Land conservation",null,null,null,"COmESep","O&M Costs","Enhanced septic treatment"]
[null,"Leak repairs",null,null,null,"COmGwPump","O&M Costs","Groundwater pumping"]
[null,"Additional infrastructure capacity",null,null,null,"COmIbtW","O&M Costs","Interbasin transfer (IBT) potable water"]
[null,"etc.",null,null,null,"COmIbtWw","O&M Costs","IBT wastewater"]
[null,null,null,null,null,"COmNpdist","O&M Costs","Nonpotable distribution system"]
[null,null,null,null,null,"COmOS","O&M Costs","Operation cost of offline storage use"]
[null,null,null,null,null,"COmRes","O&M Costs","Reservoir management"]
[null,null,null,null,null,"COmSwPump","O&M Costs","Surface water pumping"]
[null,null,null,null,null,"COmWrf","O&M Costs","Water reuse facility (WRF)"]
[null,null,null,null,null,"COmWtp","O&M Costs","Water treatment"]
[null,null,null,null,null,"COmWwtp","O&M Costs","Wastewater treatment"]
[null,null,null,null,null,"DQCSOS","Flow","Combined sewer to offline storage"]
[null,null,null,null,null,"DQGwExt","Flow","Groundwater to external"]
[null,null,null,null,null,"DQGwMake","Flow","Groundwater deficits"]
[null,null,null,null,null,"DQGwWtp","Flow","Groundwater to water treatment plant"]
[null,null,null,null,null,"DQIbtWUseNp","Flow","IBT potable water to nonpotable water use"]
[null,null,null,null,null,"DQIbtWUseP","Flow","IBT potable water to potable water use"]
[null,null,null,null,null,"DQOSWwtp","Flow","Offline storage to wastewater treatment plant"]
[null,null,null,null,null,"DQResAsr","Flow","Reservoir to ASR"]
[null,null,null,null,null,"DQResWtp","Flow","Reservoir to water treatment plant"]
[null,null,null,null,null,"DQSwAsr","Flow","Surface water to ASR"]
[null,null,null,null,null,"DQSwExt","Flow","Surface water to external"]
[null,null,null,null,null,"DQSwWtp","Flow","Surface water to water treatment plant"]
[null,null,null,null,null,"DQUseNpCS","Flow","Nonpotable water use to combined sewer"]
[null,null,null,null,null,"DQUseNpIbtWw","Flow","Nonpotable water use to IBT wastewater flow"]
[null,null,null,null,null,"DQUseNpSanS","Flow","Nonpotable water use to sanitary sewer"]
[null,null,null,null,null,"DQUsePCS","Flow","Potable water use to combined sewer"]
[null,null,null,null,null,"DQUsePIbtWw","Flow","Potable water use to IBT wastewater flow"]
[null,null,null,null,null,"DQUsePSanS","Flow","Potable water use to sanitary sewer"]
[null,null,null,null,null,"DQWMake","Flow","Water deficits"]
[null,null,null,null,null,"DQWrfAsr","Flow","WRF to ASR"]
[null,null,null,null,null,"DQWrfUseNp","Flow","WRF to nonpotable water use"]
[null,null,null,null,null,"DQWtpUseNp","Flow","Water treatment plant to nonpotable water use"]
[null,null,null,null,null,"DQWwtpWrf","Flow","Wastewater treatment plant to WRF"]
[null,null,null,null,null,"QAsrGw","Flow","ASR to groundwater"]
[null,null,null,null,null,"QCSWwtp","Flow","Combined sewer to wastewater treatment plant"]
[null,null,null,null,null,"QGwSw","Flow","Groundwater to surface water"]
[null,null,null,null,null,"QGwWwtp","Flow","Groundwater to wastewater treatment plant"]
[null,null,null,null,null,"QRe","Flow","Recharge"]
[null,null,null,null,null,"QRu","Flow","Runoff"]
[null,null,null,null,null,"QRuCS","Flow","Runoff flow to combined sewer"]
[null,null,null,null,null,"QRuStS","Flow","Runoff flow to storm sewer"]
[null,null,null,null,null,"QRuSw","Flow","Runoff flow to surface water"]
[null,null,null,null,null,"QSanSWwtp","Flow","Sanitary sewer to wastewater treatment plant"]
[null,null,null,null,null,"QSepGw","Flow","Septic systems to groundwater"]
[null,null,null,null,null,"QStSSw","Flow","Storm sewer to surface water"]
[null,null,null,null,null,"QSwRes","Flow","Surface water to reservoir"]
[null,null,null,null,null,"QUseNp","Flow","Nonpotable water use"]
[null,null,null,null,null,"QUseNpSep","Flow","Nonpotable water to septic systems inside of study area"]
[null,null,null,null,null,"QUseNpSepExt","Flow","Nonpotable water to septic systems outside of study area"]
[null,null,null,null,null,"QUseNpSewer","Flow","Municipal water use direct to the sewer system"]
[null,null,null,null,null,"QUseP","Flow","Potable water use"]
[null,null,null,null,null,"QUsePSep","Flow","Potable water to septic systems inside of study area"]
[null,null,null,null,null,"QUsePSepExt","Flow","Potable water to septic systems outside of study area"]
[null,null,null,null,null,"QWrfSw","Flow","WRF to surface water"]
[null,null,null,null,null,"QWtpGw","Flow","Water treatment plant to groundwater"]
[null,null,null,null,null,"QWtpUseP","Flow","Water treatment to potable use"]
[null,null,null,null,null,"QWwtpSw","Flow","Wastewater treatment plant to surface water"]
[null,null,null,null,null,"VGw","Storage","Groundwater volume"]
[null,null,null,null,null,"VOSTotal","Storage","Offline storage volume"]
[null,null,null,null,null,"VRes","Storage","Reservoir volume"]
[null,null,null,null,null,"QESep","Flow","Enhanced septic treatment"]
[null,null,null,null,null,"LAsrGw1","Loadings","ASR to groundwater (Constituent 1)"]
[null,null,null,null,null,"LGw1","Loadings","Groundwater (Constituent 1)"]
[null,null,null,null,null,"LGwExt1","Loadings","Groundwater to external (Constituent 1)"]
[null,null,null,null,null,"LGwPt1","Loadings","Groundwater to private withdrawals (Constituent 1)"]
[null,null,null,null,null,"LGwSw1","Loadings","Groundwater to surface water (Constituent 1)"]
[null,null,null,null,null,"LGwWtp1","Loadings","Groundwater to water treatment plant (Constituent 1)"]
[null,null,null,null,null,"LGwWwtp1","Loadings","Groundwater to wastewater treatment plant (Constituent 1)"]
[null,null,null,null,null,"LRe1","Loadings","Recharge (Constituent 1)"]
[null,null,null,null,null,"LRes1","Loadings","Reservoir (Constituent 1)"]
[null,null,null,null,null,"LResAsr1","Loadings","Reservoir to ASR (Constituent 1)"]
[null,null,null,null,null,"LResPt1","Loadings","Reservoir to private withdrawals (Constituent 1)"]
[null,null,null,null,null,"LResWtp1","Loadings","Reservoir to water treatment plant (Constituent 1)"]
[null,null,null,null,null,"LRu1","Loadings","Runoff (Constituent 1)"]
[null,null,null,null,null,"LRuAdd1","Loadings","Runoff loadings change from converted HRU land area (Constituent 1)"]
[null,null,null,null,null,"LRuAdj1","Loadings","Runoff loadings from upland HRUs to a buffer area that does not have a loadings adjustment (Constituent 1)"]
[null,null,null,null,null,"LRuAdjUp1","Loadings","Runoff loadings from upland HRUs to a buffer area that has a loadings adjustment (Constituent 1)"]
[null,null,null,null,null,"LSepGw1","Loadings","Septic systems to groundwater (Constituent 1)"]
[null,null,null,null,null,"LStSSw1","Loadings","Storm sewer to surface water loadings (Constituent 1)"]
[null,null,null,null,null,"LSwAsr1","Loadings","Surface water to ASR (Constituent 1)"]
[null,null,null,null,null,"LSwExt1","Loadings","Surface water to external (Constituent 1)"]
[null,null,null,null,null,"LSw1","Loadings","Surface water (Constituent 1)"]
[null,null,null,null,null,"LSwPt1","Loadings","Surface water to private withdrawals (Constituent 1)"]
[null,null,null,null,null,"LSwRes1","Loadings","Surface water to reservoir (Constituent 1)"]
[null,null,null,null,null,"LSwWtp1","Loadings","Surface water to water treatment plant (Constituent 1)"]
[null,null,null,null,null,"LUseNp1","Loadings","Nonpotable water use (Constituent 1)"]
[null,null,null,null,null,"LUseNpIbtWw1","Loadings","Nonpotable water use to IBT wastewater (Constituent 1)"]
[null,null,null,null,null,"LUseNpSanS1","Loadings","Nonpotable water use to sanitary sewer loadings (Constituent 1)"]
[null,null,null,null,null,"LUseNpSep1","Loadings","Nonpotable water use to septic systems (Constituent 1)"]
[null,null,null,null,null,"LUseNpSepExt1","Loadings","Nonpotable water use to external septic systems (Constituent 1)"]
[null,null,null,null,null,"LUseNpSewer1","Loadings","Nonpotable water use to storm sewer loadings (Constituent 1)"]
[null,null,null,null,null,"LUseP1","Loadings","Potable water use (Constituent 1)"]
[null,null,null,null,null,"LUsePIbtWw1","Loadings","Potable water use to IBT wastewater (Constituent 1)"]
[null,null,null,null,null,"LUsePSanS1","Loadings","Potable water use to sanitary sewer loadings (Constituent 1)"]
[null,null,null,null,null,"LUsePSep1","Loadings","Potable water use to septic systems (Constituent 1)"]
[null,null,null,null,null,"LUsePSepExt1","Loadings","Potable water use to external septic systems (Constituent 1)"]
[null,null,null,null,null,"LWrfAsr1","Loadings","WRF to ASR (Constituent 1)"]
[null,null,null,null,null,"LWrfSw1","Loadings","WRF to surface water (Constituent 1)"]
[null,null,null,null,null,"LWrfUseNp1","Loadings","WRF to nonpotable water use (Constituent 1)"]
[null,null,null,null,null,"LWtpGw1","Loadings","Water treatment plant to groundwater (Constituent 1)"]
[null,null,null,null,null,"LWtpUseNp1","Loadings","Water treatment plant to nonpotable water use (Constituent 1)"]
[null,null,null,null,null,"LWtpUseP1","Loadings","Water treatment plant to potable water use (Constituent 1)"]
[null,null,null,null,null,"LWwtpSw1","Loadings","Wastewater treatment plant to surface water (Constituent 1)"]
[null,null,null,null,null,"LWwtpWrf1","Loadings","Watewater treatment plant to WRF (Constituent 1)"]
[null,null,null,null,null,"XGwF1","Concentration","Groundwater after decay (Constituent 1)"]
[null,null,null,null,null,"XResF1","Concentration","Reservoir after decay (Constituent 1)"]
[null,null,null,null,null,"XSwF1","Concentration","Surface water after decay (Constituent 1)"]
[null,null,null,null,null,"XUseNp1","Concentration","Nonpotable water (Constituent 1)"]
[null,null,null,null,null,"XUseP1","Concentration","Potable water (Constituent 1)"]
[null,null,null,null,null,"LAsrGw2","Loadings","ASR to groundwater (Constituent 2)"]
[null,null,null,null,null,"LGw2","Loadings","Groundwater (Constituent 2)"]
[null,null,null,null,null,"LGwExt2","Loadings","Groundwater to external (Constituent 2)"]
[null,null,null,null,null,"LGwPt2","Loadings","Groundwater to private withdrawals (Constituent 2)"]
[null,null,null,null,null,"LGwSw2","Loadings","Groundwater to surface water (Constituent 2)"]
[null,null,null,null,null,"LGwWtp2","Loadings","Groundwater to water treatment plant (Constituent 2)"]
[null,null,null,null,null,"LGwWwtp2","Loadings","Groundwater to wastewater treatment plant (Constituent 2)"]
[null,null,null,null,null,"LRe2","Loadings","Recharge (Constituent 2)"]
[null,null,null,null,null,"LRes2","Loadings","Reservoir (Constituent 2)"]
[null,null,null,null,null,"LResAsr2","Loadings","Reservoir to ASR (Constituent 2)"]
[null,null,null,null,null,"LResPt2","Loadings","Reservoir to private withdrawals (Constituent 2)"]
[null,null,null,null,null,"LResWtp2","Loadings","Reservoir to water treatment plant (Constituent 2)"]
[null,null,null,null,null,"LRu2","Loadings","Runoff (Constituent 2)"]
[null,null,null,null,null,"LRuAdd2","Loadings","Runoff loadings change from converted HRU land area (Constituent 2)"]
[null,null,null,null,null,"LRuAdj2","Loadings","Runoff loadings from upland HRUs to a buffer area that does not have a loadings adjustment (Constituent 2)"]
[null,null,null,null,null,"LRuAdjUp2","Loadings","Runoff loadings from upland HRUs to a buffer area that has a loadings adjustment (Constituent 2)"]
[null,null,null,null,null,"LSepGw2","Loadings","Septic systems to groundwater (Constituent 2)"]
[null,null,null,null,null,"LStSSw2","Loadings","Storm sewer to surface water loadings (Constituent 2)"]
[null,null,null,null,null,"LSwAsr2","Loadings","Surface water to ASR (Constituent 2)"]
[null,null,null,null,null,"LSwExt2","Loadings","Surface water to external (Constituent 2)"]
[null,null,null,null,null,"LSw2","Loadings","Surface water (Constituent 2)"]
[null,null,null,null,null,"LSwPt2","Loadings","Surface water to private withdrawals (Constituent 2)"]
[null,null,null,null,null,"LSwRes2","Loadings","Surface water to reservoir (Constituent 2)"]
[null,null,null,null,null,"LSwWtp2","Loadings","Surface water to water treatment plant (Constituent 2)"]
[null,null,null,null,null,"LUseNp2","Loadings","Nonpotable water use (Constituent 2)"]
[null,null,null,null,null,"LUseNpIbtWw2","Loadings","Nonpotable water use to IBT wastewater (Constituent 2)"]
[null,null,null,null,null,"LUseNpSanS2","Loadings","Nonpotable water use to sanitary sewer loadings (Constituent 2)"]
[null,null,null,null,null,"LUseNpSep2","Loadings","Nonpotable water use to septic systems (Constituent 2)"]
[null,null,null,null,null,"LUseNpSepExt2","Loadings","Nonpotable water use to external septic systems (Constituent 2)"]
[null,null,null,null,null,"LUseNpSewer2","Loadings","Nonpotable water use to storm sewer loadings (Constituent 2)"]
[null,null,null,null,null,"LUseP2","Loadings","Potable water use (Constituent 2)"]
[null,null,null,null,null,"LUsePIbtWw2","Loadings","Potable water use to IBT wastewater (Constituent 2)"]
[null,null,null,null,null,"LUsePSanS2","Loadings","Potable water use to sanitary sewer loadings (Constituent 2)"]
[null,null,null,null,null,"LUsePSep2","Loadings","Potable water use to septic systems (Constituent 2)"]
[null,null,null,null,null,"LUsePSepExt2","Loadings","Potable water use to external septic systems (Constituent 2)"]
[null,null,null,null,null,"LWrfAsr2","Loadings","WRF to ASR (Constituent 2)"]
[null,null,null,null,null,"LWrfSw2","Loadings","WRF to surface water (Constituent 2)"]
[null,null,null,null,null,"LWrfUseNp2","Loadings","WRF to nonpotable water use (Constituent 2)"]
[null,null,null,null,null,"LWtpGw2","Loadings","Water treatment plant to groundwater (Constituent 2)"]
[null,null,null,null,null,"LWtpUseNp2","Loadings","Water treatment plant to nonpotable water use (Constituent 2)"]
[null,null,null,null,null,"LWtpUseP2","Loadings","Water treatment plant to potable water use (Constituent 2)"]
[null,null,null,null,null,"LWwtpSw2","Loadings","Wastewater treatment plant to surface water (Constituent 2)"]
[null,null,null,null,null,"LWwtpWrf2","Loadings","Watewater treatment plant to WRF (Constituent 2)"]
[null,null,null,null,null,"XGwF2","Concentration","Groundwater after decay (Constituent 2)"]
[null,null,null,null,null,"XResF2","Concentration","Reservoir after decay (Constituent 2)"]
[null,null,null,null,null,"XSwF2","Concentration","Surface water after decay (Constituent 2)"]
[null,null,null,null,null,"XUseNp2","Concentration","Nonpotable water (Constituent 2)"]
[null,null,null,null,null,"XUseP2","Concentration","Potable water (Constituent 2)"]
[null,null,null,null,null,"XUseP2","Concentration","Potable water (Constituent 2)"]

{"sheet":"Variable Definitions","index":2,"n_rows":199,"n_cols":14,"rows_kept":199,"cut":false,"hidden":false,"merged":[]}
["Table 1: Model Decisions Dictionary",null,null,null,"Table 2: Variables Dictionary",null,null,null,null,"Table 3: Model Input Data Dictionary"]
["Model Decisions","Description","Units",null,"Model Variables","Variable Category","Description","Units",null,"Model Variables","Description","Units"]
["objective","Objective cost","$/yr",null,"objective","Total Cost","Objective cost","$/yr",null,"AvgAnnualPrecip","Average annual precipitation in model time period","inches per year",{"$f":"IF(ISNA(VLOOKUP(J3,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J3,$O$167:$P$269,2,FALSE))","v":""}]
["CAsr","Total cost of ASR","$/yr",null,"COmAsr","O&M Costs","ASR","$/yr",null,"AvgTemp","Average daily temperature in model period","deg F",{"$f":"IF(ISNA(VLOOKUP(J4,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J4,$O$167:$P$269,2,FALSE))","v":""},"Note: Numeric identifiers on variable CLuSet[S] represent the cost decision for managed set number S."]
["CCAsr","Capital cost of ASR","$/yr",null,"COmESep","O&M Costs","Enhanced septic treatment","$/yr",null,"QRuT","Total monthly runoff for the study area for each managed set","in/acre/month",{"$f":"IF(ISNA(VLOOKUP(J7,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J7,$O$167:$P$269,2,FALSE))","v":""},"Numeric identifiers on variable DALu[L & S] represent the land area decision for HRU number L and managed set number S."]
["CCGwPump","Capital cost of groundwater pumping","$/yr",null,"COmGwPump","O&M Costs","Groundwater pumping","$/yr",null,"QReT","Total monthly recharge for the study area for each managed set","in/acre/month",{"$f":"IF(ISNA(VLOOKUP(J8,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J8,$O$167:$P$269,2,FALSE))","v":""},"Numeric identifiers on any WQ variable represents the decision variable for constituent number C."]
["CCIbtW","Capital cost of additional IBT potable water","$/yr",null,"COmIbtW","O&M Costs","IBT potable water","$/yr",null,"NDateHydro","Number of time steps in model","-",{"$f":"IF(ISNA(VLOOKUP(J9,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J9,$O$167:$P$269,2,FALSE))","v":""}]
["CCIbtWw","Capital cost of additional IBT wastewater","$/yr",null,"COmIbtWw","O&M Costs","IBT wastewater","$/yr",null,"Dt","Number of days in timestep (1 = daily, >28 = monthly)","days in time step"]
["CCNpdist","Capital cost of nonpotable distribution system","$/yr",null,"COmNpdist","O&M Costs","Nonpotable distribution system","$/yr",null,"NLu","Number of HRUs","# HRUs"]
["CCRes","Capital cost of reservoir management","$/yr",null,"COmOS","O&M Costs","Operation cost of offline storage use","$/yr",null,"NLuName,1","HRU names","-"]
["CCSwPump","Capital cost of surface water pumping","$/yr",null,"COmRes","O&M Costs","Reservoir management","$/yr",null,"ALuBase","Baseline land area of HRUs","acre"]
["CCWrf","Capital cost of WRF","$/yr",null,"COmSwPump","O&M Costs","Surface water pumping","$/yr",null,"EIALu","Effective impervious area of HRUs","fraction"]
["CCWtp","Capital cost of potable water treatment plant","$/yr",null,"COmWrf","O&M Costs","WRF","$/yr",null,"InfiltLu","Infiltration rate of HRUs","in/hr"]
["CCWwtp","Capital cost of wastewater treatment plant","$/yr",null,"COmWtp","O&M Costs","Water treatment","$/yr",null,"NLuSet","Number of managed sets","# of HRU Sets"]
["CDmd","Cost of direct demand reduction","$/yr",null,"COmWwtp","O&M Costs","Wastewater treatment","$/yr",null,"NLuSetName,1","HRU management set names","-"]
["CFlood","Cost of flood damage","$/yr",null,"DQCSOS","Flow","Combined sewer to offline storage","MGD",null,"ALuMin","Minimum areas for each land use management set","acre"]
["CGwMake","Penalty for groundwater deficit","$/yr",null,"DQGwExt","Flow","Groundwater to external","MGD",null,"ALuMax","Maximum areas for each land use management set","acre"]
["CGwPump","Total cost of groundwater pumping","$/yr",null,"DQGwMake","Flow","Groundwater deficits","MGD",null,"CCLu","Initial or capital cost for managing land use set","$/acre"]
["CGwWwtp","Total cost of wastewater treatment plant I/I repair","$/yr",null,"DQGwWtp","Flow","Groundwater to water treatment plant","MGD",null,"COmLu","O&M costs for managing land use set","$/acre/yr"]
["CIbtW","Total cost of IBT potable water","$/yr",null,"DQIbtWUseNp","Flow","IBT potable water to nonpotable water use","MGD",null,"NWUser","Number of water users","# of Water Users"]
["CIbtWw","Total cost of IBT wastewater","$/yr",null,"DQIbtWUseP","Flow","IBT potable water to potable water use","MGD",null,"NamesWUse,1","Water user names","-"]
["CLuSet1","Land management cost for managed set","$/yr",null,"DQOSWwtp","Flow","Offline storage to wastewater treatment plant","MGD",null,"PConsUsePI","Initial percent consumptive use for potable water","%"]
["CNpdist","Total cost of nonpotable distribution system","$/yr",null,"DQResAsr","Flow","Reservoir to ASR","MGD",null,"QUsePI","Potable water demand","MG/time step"]
["COS","Cost of offline storage","$/yr",null,"DQResWtp","Flow","Reservoir to water treatment plant","MGD",null,"PUseNp","Percent of maximum potable water demand met by nonpotable","%"]
["CPPrice","Cost of consumer rate change","$/yr",null,"DQSwAsr","Flow","Surface water to ASR","MGD",null,"PConsUseNp","Percent of nonpotable use that is consumptive use","%"]
["CRes","Total cost of reservoir management","$/yr",null,"DQSwExt","Flow","Surface water to external","MGD",null,"ElasWUser","Price elasiticities for water users","unitless"]
["CSewSep","Cost of sewer separation","$/yr",null,"DQSwWtp","Flow","Surface water to water treatment plant","MGD",null,"CCDmPrice","Initial cost of implementing Dm via price change","$"]
["CSwPump","Total cost of surface water pumping","$/yr",null,"DQUseNpCS","Flow","Nonpotable water use to combined sewer","MGD",null,"COmDmPrice","O&M cost of implementing Dm via price change","$/yr"]
["CWMake","Penalty for water deficit","$/yr",null,"DQUseNpIbtWw","Flow","Nonpotable water use to IBT wastewater flow","MGD",null,"PPriceMax","HRU Managed Set Names","%"]
["CWrf","Total cost of WRF","$/yr",null,"DQUseNpSanS","Flow","Nonpotable water use to sanitary sewer","MGD",null,"CCDm","Initial cost for implementing aggregate of Dm practices","$",{"$f":"IF(ISNA(VLOOKUP(J18,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J18,$O$167:$P$269,2,FALSE))","v":""}]
["CWtp","Total cost of potable water treatment plant","$/yr",null,"DQUsePCS","Flow","Potable water use to combined sewer","MGD",null,"COmDm","O&M annnual cost for implementing aggregate of Dm practices","$/yr"]
["CWtpUaw","Cost of potable water treatment plant repair","$/yr",null,"DQUsePIbtWw","Flow","Potable water use to IBT wastewater flow","MGD",null,"QDmRedMax","Max demand reduction for implementing aggregate of Dm practic","MGD"]
["CWwtp","Total cost of wastewater treatment plant","$/yr",null,"DQUsePSanS","Flow","Potable water use to sanitary sewer","MGD",null,"KGw","Gw recession coefficient","1/time step"]
["DALu11","Land area of HRU","ac",null,"DQWMake","Flow","Water deficits","MGD",null,"VGwI","Initial Gw aquifer volume","MG"]
["DOS","Binary decision to use offline storage","binary",null,"DQWrfAsr","Flow","WRF to ASR","MGD",null,"VGwMin","Minimum Gw aquifer volume","MG"]
["DPCS","Percent of sewer system that is combined","%",null,"DQWrfUseNp","Flow","WRF to nonpotable water use","MGD",null,"VGwMax","Maximum Gw aquifer volume","MG"]
["DPCS1","Percent of sewer system that is combined","%",null,"DQWtpUseNp","Flow","Water treatment plant to nonpotable water use","MGD",null,"ExGwMake","Make-up Gw Penalty Flag","-"]
["DPGwWwtpFix","Wastewater treatment plant I/I repairs","% of leaks",null,"DQWwtpWrf","Flow","Wastewater treatment plant to WRF","MGD",null,"COmGwMake","Cost for Make-Up Gw","$/MGD"]
["DPPrice","Percent consumer rate change","%",null,"QAsrGw","Flow","ASR to groundwater","MGD",null,"QGwPt","Private/other Gw withdrawals","MG/time step"]
["DPriceDummy","Dummy variable","-",null,"QCSWwtp","Flow","Combined sewer to wastewater treatment plant","MGD",null,"QPtGw","Private/other Gw discharges","MG/time step"]
["DPWtpGwFix","Distribution system leak repairs","% of leaks",null,"QGwSw","Flow","Groundwater to surface water","MGD",null,"QExtGw","External Gw inflow (from other watershed if Gw and Sw watersh","MG/time step"]
["DQAsrAddl","Additional ASR capacity","MG",null,"QGwWwtp","Flow","Groundwater to wastewater treatment plant","MGD",null,"QGwExtMin","Minimum Gw flow out of basin","MG/time step"]
["DQDmR","Demand reduction","MGD",null,"QRe","Flow","Recharge","MGD",null,"VResI","Initial volume in reservoir","MG"]
["DQGwPumpAddl","Additional groundwater pumping capacity","MG",null,"QRu","Flow","Runoff","MGD",null,"VResMin","Minimum volume to be maintained in reservoir (ie: dead storag","MG"]
["DQIbtWAddl","Additional IBT potable water capacity","MG",null,"QRuCS","Flow","Runoff flow to combined sewer","MGD",null,"VResMaxI","Existing maximum volume of the reservoir","MG",{"$f":"IF(ISNA(VLOOKUP(J19,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J19,$O$167:$P$269,2,FALSE))","v":""}]
["DQIbtWwAddl","Additional IBT wastewater capacity","MG",null,"QRuStS","Flow","Runoff flow to storm sewer","MGD",null,"VResMaxAddl","Maximum additional capacity of reservoir volume","MG",{"$f":"IF(ISNA(VLOOKUP(J20,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J20,$O$167:$P$269,2,FALSE))","v":""}]
["DQNpdistAddl","Additional nonpotable water distribution system capacity","MG",null,"QRuSw","Flow","Runoff flow to surface water","MGD",null,"CCRes","Initial/capital cost of additional surface storage (expand re","$/MG",{"$f":"IF(ISNA(VLOOKUP(J21,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J21,$O$167:$P$269,2,FALSE))","v":""}]
["DQSwPumpAddl","Additional surface water pumping capacity","MG",null,"QSanSWwtp","Flow","Sanitary sewer to wastewater treatment plant","MGD",null,"COmRes","O&M cost of additional surface water storage","$/MG"]
["DQWrfAddl","Additional WRF capacity","MG",null,"QSepGw","Flow","Septic systems to groundwater","MGD",null,"ExVSw","Flag to exclude additional Sw/Res storage","-",{"$f":"IF(ISNA(VLOOKUP(J26,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J26,$O$167:$P$269,2,FALSE))","v":""}]
["DQWtpAddl","Additional water treatment capacity","MG",null,"QStSSw","Flow","Storm sewer to surface water","MGD",null,"FlagSwExt","User indicated flag to model flow out of reservoir to ext sw","-",""]
["DQWwtpAddl","Additional wastewater treatment capacity","MG",null,"QSwRes","Flow","Surface water to reservoir","MGD",null,"COmWMake","Cost for Make-Up Sw","$/MG",""]
["DRuCS","Binary decision to route runoff to combined sewer","binary",null,"QUseNp1","Flow","Nonpotable water use","MGD",null,"ExWMake","Make-up Sw Penalty Flag","-",""]
["DVResAddl","Additional reservoir capacity","MG",null,"QUseNpSep","Flow","Nonpotable water to septic systems inside of study area","MGD",null,"QSwPt","Private/other surface water withdrawals","MG/time step",""]
["DWwtp","Binary decision used to count hydraulic capacity exceedances","binary",null,"QUseNpSepExt","Flow","Nonpotable water to septic systems outside of study area","MGD",null,"QPtSw","Private/other surface water discharges","MG/time step",""]
["CESep","Capital cost for new enhanced septic treatment","$/yr",null,"QUseNpSewer","Flow","Municipal water use direct to the sewer system","MGD",null,"QExtSw","External inflow to surface water (e.g., if not modeling headw","MG/time step",""]
["DPESep","Fraction of septic loadings receiving enhanced treatment","fraction",null,"QUseP1","Flow","Potable water use","MGD",null,"QResPt","Private/other reservoir withdrawals","MG/time step",""]
["CUWtp","Capital cost for new upgraded WTP","$/yr",null,"QUsePSep","Flow","Potable water to septic systems inside of study area","MGD",null,"QSwMin","Minimum in-stream flow requirement","MG/time step",""]
["DPUWtp","Fraction of WTP loadings receiving upgraded treatment","fraction",null,"QUsePSepExt","Flow","Potable water to septic systems outside of study area","MGD",null,"QSwMax","Maximum in-stream flow","MG/time step",""]
["CUWwtp","Capital cost for new upgraded WWTP","$/yr",null,"QWrfSw","Flow","WRF to surface water","MGD",null,"QSwExtMin","Minimum Sw flow out of basin","MG/time step",""]
["DPUWwtp","Fraction of WWTP loadings receiving upgraded treatment","fraction",null,"QWtpGw","Flow","Water treatment plant to groundwater","MGD",null,"QSwExtMax","Max Sw flow out of basin","MG/time step",""]
["CStream","Cost of streambank restoration/stabilization","$/yr",null,"QWtpUseP","Flow","Water treatment to potable use","MGD",null,"TPlan","planning horizon in years (time over which costs are annualized)","years",""]
["DFtStream","Steambank length restored/stabilized","ft",null,"QWwtpSw","Flow","Wastewater treatment plant to surface water","MGD",null,"PInt","Interest rate for annualizing costs","%",""]
["COutfall","Cost of outfall enhancement/stabilization","$/yr",null,"VGw","Storage","Groundwater volume","MGD",null,"RUseP","Consumer price for water (variable-fee)","$/HCF",""]
["DNOutE","Number of enhanced/stabilized outfalls","outfalls",null,"VOSTotal","Storage","Offline storage volume","MG",null,"RfUseP","Consumer price for water (fixed-fee)","$/month",""]
["CDrSet1","Cost of direct reduction land use management set","$/yr",null,"VRes","Storage","Reservoir volume","MG",null,"CCGwPumpU","Initial or capital cost for additional Gw pumping capacity","$/MGD",""]
["DDrSet1","Binary decision to apply direct reduction land management set","binary",null,"QESep","Flow","Enhanced septic treatment","MGD",null,"COmGwPumpU","O&M costs for Gw pumping","$/MG",""]
["CDrTotal","Total cost of applying direct reduction land management sets","$/yr",null,"LAsrGw1","Loadings","ASR to groundwater (Constituent 1)","lbs/day",null,"QGwPumpI","Initial Gw pumping capacity","MGD",""]
["CRipSet111","Cost of riparian buffer land use management set","$/yr",null,"LGw1","Loadings","Groundwater (Constituent 1)","lbs/day",null,"TGwPumpExist","Remaining lifetime of existing GwPump","years",""]
["DRipSet1111","Binary decision to apply riparian buffer land management set to runoff","binary",null,"LGwExt1","Loadings","Groundwater to external (Constituent 1)","lbs/day",null,"TGwPumpNew","Lifetime of new construction for additional capacity for GwPump","years",""]
["DRipSet1112","Binary decision to apply riparian buffer land management set to loadings","binary",null,"LGwPt1","Loadings","Groundwater to private withdrawals (Constituent 1)","lbs/day",null,"ExGwPump","Flag for excluding new/additional GW pumping capacity","-"]
["CRipTotal","Total cost of applying riparian buffer land management sets","$/yr",null,"LGwSw1","Loadings","Groundwater to surface water (Constituent 1)","lbs/day",null,"CCSwPumpU","Initial or capital cost for additional Sw pumping capacity","$/MGD"]
[null,null,null,null,"LGwWtp1","Loadings","Groundwater to water treatment plant (Constituent 1)","lbs/day",null,"COmSwPumpU","O&M costs for Sw pumping","$/MG"]
[null,null,null,null,"LGwWwtp1","Loadings","Groundwater to wastewater treatment plant (Constituent 1)","lbs/day",null,"QSwPumpI","Initial Sw pumping capacity","MGD"]
[null,null,null,null,"LRe1","Loadings","Recharge (Constituent 1)","lbs/day",null,"TSwPumpExist","Remaining lifetime of existing SwPump","years"]
[null,null,null,null,"LRes1","Loadings","Reservoir (Constituent 1)","lbs/day",null,"TSwPumpNew","Lifetime of new construction for additional capacity for SwPump","years"]
[null,null,null,null,"LResAsr1","Loadings","Reservoir to ASR (Constituent 1)","lbs/day",null,"ExSwPump","Flag for excluding new/additional SW pumping capacity","-"]
[null,null,null,null,"LResPt1","Loadings","Reservoir to private withdrawals (Constituent 1)","lbs/day",null,"CCWtpU","Initial or capital cost for additional water treatment plant (WTP) capacity","$/MGD"]
[null,null,null,null,"LResWtp1","Loadings","Reservoir to water treatment plant (Constituent 1)","lbs/day",null,"COmWtpU","O&M cost for WTP","$/MG"]
[null,null,null,null,"LRu1","Loadings","Runoff (Constituent 1)","lbs/day",null,"QWtpMaxI","Maximum initial capacity of WTP","MGD"]
[null,null,null,null,"LRuAdd1","Loadings","Runoff loadings change from converted HRU land area (Constituent 1)","lbs/day",null,"TWtpExist","Remaining lifetime of existing WTP","years"]
[null,null,null,null,"LRuAdjUp1","Loadings","Runoff loadings from upland HRUs to a buffer area that has a loadings adjustment (Constituent 1)","lbs/day",null,"TWtpNew","Lifetime of new construction for additional capacity for WTP","years"]
[null,null,null,null,"LSepGw1","Loadings","Septic systems to groundwater (Constituent 1)","lbs/day",null,"CCWtpUaw","initial cost for reducing unaccounted-for-water (UAW)","$"]
[null,null,null,null,"LStSSw1","Loadings","Storm sewer to surface water loadings (Constituent 1)","lbs/day",null,"COmWtpUaw","O&M cost for maintaining reduction in UAW","$/year"]
[null,null,null,null,"LSwAsr1","Loadings","Surface water to ASR (Constituent 1)","lbs/day",null,"PWtpGwFixmax","maximum percent of leak from WTP distribthat can be eliminated","%"]
[null,null,null,null,"LSwExt1","Loadings","Surface water to external (Constituent 1)","lbs/day",null,"ExWtp","Flag for excluding new/additional WTP capacity","-"]
[null,null,null,null,"LSw1","Loadings","Surface water (Constituent 1)","lbs/day",null,"RWw","Consumer","$/HCF"]
[null,null,null,null,"LSwPt1","Loadings","Surface water to private withdrawals (Constituent 1)","lbs/day",null,"RfWw","Consumer","$/month"]
[null,null,null,null,"LSwRes1","Loadings","Surface water to reservoir (Constituent 1)","lbs/day",null,"CCWwtpU","Capital cost for additional wastewater treatment plant (Wwtp) capacity","$/MGD"]
[null,null,null,null,"LSwWtp1","Loadings","Surface water to water treatment plant (Constituent 1)","lbs/day",null,"COmWwtpU","O&M cost for Wwtp","$/MG"]
[null,null,null,null,"LUseNp1","Loadings","Nonpotable water use (Constituent 1)","lbs/day",null,"QWwtpMaxI","Existing maximum capacity of Wwtp","MGD"]
[null,null,null,null,"LUseNpIbtWw1","Loadings","Nonpotable water use to IBT wastewater (Constituent 1)","lbs/day",null,"TWwtpExist","Remaining lifetime of existing Wwtp","years"]
[null,null,null,null,"LUseNpSanS1","Loadings","Nonpotable water use to sanitary sewer loadings (Constituent 1)","lbs/day",null,"TWwtpNew","Lifetime of new construction for additional capacity for Wwtp","years"]
[null,null,null,null,"LUseNpSep1","Loadings","Nonpotable water use to septic systems (Constituent 1)","lbs/day",null,"PGwWwtpI","Initial infiltration of Gw into Wwtp collection system","%"]
[null,null,null,null,"LUseNpSepExt1","Loadings","Nonpotable water use to external septic systems (Constituent 1)","lbs/day",null,"CCGwWwtp","Initial cost for reducing Gw infiltration","$"]
[null,null,null,null,"LUseNpSewer1","Loadings","Nonpotable water use to storm sewer loadings (Constituent 1)","lbs/day",null,"COmGwWwtp","O&M cost for maintaining reduction in Gw infiltration","$/yr"]
[null,null,null,null,"LUseP1","Loadings","Potable water use (Constituent 1)","lbs/day",null,"PGwWwtpFixmax","maximum percent of gw infiltration that can be eliminated","%"]
[null,null,null,null,"LUsePIbtWw1","Loadings","Potable water use to IBT wastewater (Constituent 1)","lbs/day",null,"WwFlag","Wastewater charge based on water or ww flow","-"]
[null,null,null,null,"LUsePSanS1","Loadings","Potable water use to sanitary sewer loadings (Constituent 1)","lbs/day",null,"ExWwtp","Flag for excluding new/additional WWTP capacity","-"]
[null,null,null,null,"LUsePSep1","Loadings","Potable water use to septic systems (Constituent 1)","lbs/day",null,"CCWrfU","Initial or capital cost for additional WRF capacity","$/MGD"]
[null,null,null,null,"LUsePSepExt1","Loadings","Potable water use to external septic systems (Constituent 1)","lbs/day",null,"COmWrfU","O&M cost for WRF","$/MG"]
[null,null,null,null,"LWrfAsr1","Loadings","WRF to ASR (Constituent 1)","lbs/day",null,"QWrfMaxI","Initial maximum capacity of WRF","MGD"]
[null,null,null,null,"LWrfSw1","Loadings","WRF to surface water (Constituent 1)","lbs/day",null,"TWrfExist","Remaining lifetime of existing WRF","years"]
[null,null,null,null,"LWrfUseNp1","Loadings","WRF to nonpotable water use (Constituent 1)","lbs/day",null,"TWrfNew","Lifetime of new construction for additional capacity for WRF","years"]
[null,null,null,null,"LWtpGw1","Loadings","Water treatment plant to groundwater (Constituent 1)","lbs/day",null,"ExWrf","Flag for excluding new/additional WRF capacity","-"]
[null,null,null,null,"LWtpUseNp1","Loadings","Water treatment plant to nonpotable water use (Constituent 1)","lbs/day",null,"RUseNp","Consumer","$/HCF"]
[null,null,null,null,"LWtpUseP1","Loadings","Water treatment plant to potable water use (Constituent 1)","lbs/day",null,"RfUseNp","Consumer","$/month"]
[null,null,null,null,"LWwtpSw1","Loadings","Wastewater treatment plant to surface water (Constituent 1)","lbs/day",null,"CCNpdistU","Initial or capital cost for nonpotable distribution system(Npdist) capacity","$/MGD"]
[null,null,null,null,"LWwtpWrf1","Loadings","Watewater treatment plant to WRF (Constituent 1)","lbs/day",null,"COmNpdistU","O&M cost for Npdist","$/MG"]
[null,null,null,null,"XGwF1","Concentration","Groundwater after decay (Constituent 1)","lbs/day",null,"QNpDistMaxI","Existing capacity of Npdist","MGD"]
[null,null,null,null,"XResF1","Concentration","Reservoir after decay (Constituent 1)","lbs/day",null,"TNpdistExist","Remaining lifetime of existing Npdist","years"]
[null,null,null,null,"XSwF1","Concentration","Surface water after decay (Constituent 1)","lbs/day",null,"TNpdistNew","Lifet time of new Npdist system","years"]
[null,null,null,null,"XUseNp1","Concentration","Nonpotable water (Constituent 1)","lbs/day",null,"ExNpDist","Flag for excluding new/additional nonpotable distribution system capacity","-"]
[null,null,null,null,"XUseP1","Concentration","Potable water (Constituent 1)","lbs/day",null,"CCAsrU","Initial or capital cost for additional ASR capacity","$/MGD"]
[null,null,null,null,"LAsrGw2","Loadings","ASR to groundwater (Constituent 2)","lbs/day",null,"COmAsrU","O&M cost for Asr","$/MG"]
[null,null,null,null,"LGw2","Loadings","Groundwater (Constituent 2)","lbs/day",null,"QAsrMaxI","Initial maximum capacity of Asr","MGD"]
[null,null,null,null,"LGwExt2","Loadings","Groundwater to external (Constituent 2)","lbs/day",null,"TAsrExist","Remaining lifetime of existing Asr","years"]
[null,null,null,null,"LGwPt2","Loadings","Groundwater to private withdrawals (Constituent 2)","lbs/day",null,"TAsrNew","Lifetime of new construction for additional capacity for Asr","years"]
[null,null,null,null,"LGwSw2","Loadings","Groundwater to surface water (Constituent 2)","lbs/day",null,"ExAsr","Flag for excluding new/additional ASR capacity","-"]
[null,null,null,null,"LGwWtp2","Loadings","Groundwater to water treatment plant (Constituent 2)","lbs/day",null,"PSep","Percent of each water use on septic system recharging within","%"]
[null,null,null,null,"LGwWwtp2","Loadings","Groundwater to wastewater treatment plant (Constituent 2)","lbs/day",null,"PSepExt","Percent of each water use on septic system recharging outside","%"]
[null,null,null,null,"LRe2","Loadings","Recharge (Constituent 2)","lbs/day",null,"CIbtWU","Cost of purchasing potable water from another basin","$/MG"]
[null,null,null,null,"LRes2","Loadings","Reservoir (Constituent 2)","lbs/day",null,"CIbtWwU","Cost of purchasing wastewater from another basin","$/MG"]
[null,null,null,null,"LResAsr2","Loadings","Reservoir to ASR (Constituent 2)","lbs/day",null,"CCIbtWU","Initial cost of aquiring additional rights for IBT water","$/MGD"]
[null,null,null,null,"LResPt2","Loadings","Reservoir to private withdrawals (Constituent 2)","lbs/day",null,"CCIbtWwU","Initial cost of aquiring additional rights for IBT wastewater","$/MGD"]
[null,null,null,null,"LResWtp2","Loadings","Reservoir to water treatment plant (Constituent 2)","lbs/day",null,"QIbtWMaxDay","Maximum IBT per day for importing potable water","MGD"]
[null,null,null,null,"LRu2","Loadings","Runoff (Constituent 2)","lbs/day",null,"QIbtWMaxYear","Maximum IBT per year for exporting wastewater","MG/year"]
[null,null,null,null,"LRuAdd2","Loadings","Runoff loadings change from converted HRU land area (Constituent 2)","lbs/day",null,"QIbtWwMaxDay","Maximum IBT per day for importing potable water","MGD"]
[null,null,null,null,"LRuAdj2","Loadings","Runoff loadings from upland HRUs to a buffer area that does not have a loadings adjustment (Constituent 2)","lbs/day",null,"QIbtWwMaxYear","Maximum IBT per year for exporting wastewater","MG/year"]
[null,null,null,null,"LRuAdjUp2","Loadings","Runoff loadings from upland HRUs to a buffer area that has a loadings adjustment (Constituent 2)","lbs/day",null,"QIbtWAddlMaxDay","Maximum additional IBT capacity per day for importing potable","MGD"]
[null,null,null,null,"LSepGw2","Loadings","Septic systems to groundwater (Constituent 2)","lbs/day",null,"QIbtWwAddlMaxDay","Maximum additional IBT capacity per day for exporting wastewa","MGD"]
[null,null,null,null,"LStSSw2","Loadings","Storm sewer to surface water loadings (Constituent 2)","lbs/day",null,"QIbtWMaxMonth","Monthly max IBT for importing potable water","MG/month"]
[null,null,null,null,"LSwAsr2","Loadings","Surface water to ASR (Constituent 2)","lbs/day",null,"QIbtWwMaxMonth","Monthly max IBT for exporting wastewater","MG/month"]
[null,null,null,null,"LSwExt2","Loadings","Surface water to external (Constituent 2)","lbs/day",null,"ObsFlow","Measured flow time series for calibration/validation","cfs"]
[null,null,null,null,"LSw2","Loadings","Surface water (Constituent 2)","lbs/day",null,"NCons","Number of constituents","-"]
[null,null,null,null,"LSwPt2","Loadings","Surface water to private withdrawals (Constituent 2)","lbs/day",null,"Cons1","Name of constituent 1","-"]
[null,null,null,null,"LSwRes2","Loadings","Surface water to reservoir (Constituent 2)","lbs/day",null,"LRuT","Total monthly runoff loadings for the study area for each managed set","lbs/acre/month"]
[null,null,null,null,"LSwWtp2","Loadings","Surface water to water treatment plant (Constituent 2)","lbs/day",null,"LReT","Total monthly recharge loadings for the study area for each managed set","lbs/acre/month"]
[null,null,null,null,"LUseNp2","Loadings","Nonpotable water use (Constituent 2)","lbs/day",null,"CStreamU","Cost per linear stream length of streambank stabilization","$/foot"]
[null,null,null,null,"LUseNpIbtWw2","Loadings","Nonpotable water use to IBT wastewater (Constituent 2)","lbs/day",null,"StreamMax","Maximum linear stream length that can be stabilized","ft"]
[null,null,null,null,"LUseNpSanS2","Loadings","Nonpotable water use to sanitary sewer loadings (Constituent 2)","lbs/day",null,"StreamTargetBody","Waterbody where streambank stabilization target adjustment is applied","-"]
[null,null,null,null,"LUseNpSep2","Loadings","Nonpotable water use to septic systems (Constituent 2)","lbs/day",null,"StreamRemoval","Streambank stabilization constituent loading removal rate","lbs/ft/time step"]
[null,null,null,null,"LUseNpSepExt2","Loadings","Nonpotable water use to external septic systems (Constituent 2)","lbs/day",null,"COutfallU","Cost per outfall stabilized","$/outfall"]
[null,null,null,null,"LUseNpSewer2","Loadings","Nonpotable water use to storm sewer loadings (Constituent 2)","lbs/day",null,"OutfallMax","Maximum number of outfalls that can be stabilized","outfalls"]
[null,null,null,null,"LUseP2","Loadings","Potable water use (Constituent 2)","lbs/day",null,"OutfallTargetBody","Waterbody where outfall stabilization target adjustment is applied","-"]
[null,null,null,null,"LUsePIbtWw2","Loadings","Potable water use to IBT wastewater (Constituent 2)","lbs/day",null,"OutfallRemoval","Outfall stabilization constituent loading removal rate","lbs/outfall/time step"]
[null,null,null,null,"LUsePSanS2","Loadings","Potable water use to sanitary sewer loadings (Constituent 2)","lbs/day",null,"NDrSet","Number of direct reduction management sets","-"]
[null,null,null,null,"LUsePSep2","Loadings","Potable water use to septic systems (Constituent 2)","lbs/day",null,"DrSetName,1","Direct reduction management set names","-",{"$f":"IF(ISNA(VLOOKUP(J923,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J923,$O$167:$P$269,2,FALSE))","v":""}]
[null,null,null,null,"LUsePSepExt2","Loadings","Potable water use to external septic systems (Constituent 2)","lbs/day",null,"DrArea","Application area of direct reduction management set","ac",""]
[null,null,null,null,"LWrfAsr2","Loadings","WRF to ASR (Constituent 2)","lbs/day",null,"CCDrSetU","Capital cost of direct reduction management set","$/ac",""]
[null,null,null,null,"LWrfSw2","Loadings","WRF to surface water (Constituent 2)",null,null,"COmDrSetU","O&M cost of direct reduction management set","$/ac/yr",""]
[null,null,null,null,"LWrfUseNp2","Loadings","WRF to nonpotable water use (Constituent 2)",null,null,"DrRemovalRate","Direct reduction land use constituent loading removal rate","%",""]
[null,null,null,null,"LWtpGw2","Loadings","Water treatment plant to groundwater (Constituent 2)",null,null,"NRipSet","Number of riparian buffer management sets","-",{"$f":"IF(ISNA(VLOOKUP(J928,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J928,$O$167:$P$269,2,FALSE))","v":""}]
[null,null,null,null,"LWtpUseNp2","Loadings","Water treatment plant to nonpotable water use (Constituent 2)",null,null,"NAdjEff","Number of load adjustment efficiencies","-",{"$f":"IF(ISNA(VLOOKUP(J929,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J929,$O$167:$P$269,2,FALSE))","v":""}]
[null,null,null,null,"LWtpUseP2","Loadings","Water treatment plant to potable water use (Constituent 2)",null,null,"RipSetName,1","Riparian buffer management set names","-",{"$f":"IF(ISNA(VLOOKUP(J930,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J930,$O$167:$P$269,2,FALSE))","v":""}]
[null,null,null,null,"LWwtpSw2","Loadings","Wastewater treatment plant to surface water (Constituent 2)",null,null,"AdjEff","Load adjustment efficiencies by riparian buffer set","%",{"$f":"IF(ISNA(VLOOKUP(J931,$O$167:$P$269,2,FALSE))=TRUE,\"\",VLOOKUP(J931,$O$167:$P$269,2,FALSE))","v":""}]
[null,null,null,null,"LWwtpWrf2","Loadings","Watewater treatment plant to WRF (Constituent 2)","lbs/day",null,"ARip","Area change of riparian buffer land management","ac"]
[null,null,null,null,"XGwF2","Concentration","Groundwater after decay (Constituent 2)","lbs/day",null,"CCRipU","Capital cost of riparian buffer conversion","$/ac"]
[null,null,null,null,"XResF2","Concentration","Reservoir after decay (Constituent 2)","lbs/day",null,"COmRipU","O&M cost for riparian buffer conversion","$/ac/yr"]
[null,null,null,null,"XSwF2","Concentration","Surface water after decay (Constituent 2)","lbs/day",null,"ARipUp","Areas upgradient to the riparian buffer","ac"]
[null,null,null,null,"XUseNp2","Concentration","Nonpotable water (Constituent 2)","lbs/day",null,"LWuserUseP","Potable water user average daily wastewater loadings","lbs"]
[null,null,null,null,"XUseP2","Concentration","Potable water (Constituent 2)","lbs/day",null,"LWuserUseNp","Nonpotable water user average daily wastewater loadings","lbs"]
[null,null,null,null,"XUseP2","Concentration","Potable water (Constituent 2)","lbs/day",null,"ExResArea","Decision if modeling 1st order removal in proportion to surfa","-"]
[null,null,null,null,null,null,null,null,null,"ResArea","Reservoir area","ac"]
[null,null,null,null,null,null,null,null,null,"XResI","Initial constituent concentration of reservoir","mg/L"]
[null,null,null,null,null,null,null,null,null,"ResRem0","0th order reservoir removal rates","mg/L/time step"]
[null,null,null,null,null,null,null,null,null,"ResRem1","1st order reservoir removal rates","1/timestep"]
[null,null,null,null,null,null,null,null,null,"XResTarget","Reservoir allowable target concentrations","mg/L"]
[null,null,null,null,null,null,null,null,null,"XSwTarget","Surface water target concentrations","mg/L"]
[null,null,null,null,null,null,null,null,null,"LResTarget","Reservoir target loading","mg/L"]
[null,null,null,null,null,null,null,null,null,"LSwTarget","Surface water target loading","mg/L"]
[null,null,null,null,null,null,null,null,null,"LPtSw","Private/other surface water discharge loadings","lbs/time step"]
[null,null,null,null,null,null,null,null,null,"LPtRes","Private/other reservoir discharge loadings","lbs/time step"]
[null,null,null,null,null,null,null,null,null,"XGwI","Initial constituent concentration of Gw","mg/L"]
[null,null,null,null,null,null,null,null,null,"GwRem0","0th order removal rates","mg/L/time step"]
[null,null,null,null,null,null,null,null,null,"GwRem1","1st order removal rates","1/timestep"]
[null,null,null,null,null,null,null,null,null,"LPtGw","Private Gw loadings","lbs/time step"]
[null,null,null,null,null,null,null,null,null,"LExtGw","External Gw loadings","lbs/time step"]
[null,null,null,null,null,null,null,null,null,"ExUWtp","Flag for excluding new upgraded WTP capacity","-"]
[null,null,null,null,null,null,null,null,null,"ExUWwtp","Flag for excluding upgraded WWTP capacity","-"]
[null,null,null,null,null,null,null,null,null,"ExAsrTr","Flag for excluding new/additional ASR treatment capacity","-"]
[null,null,null,null,null,null,null,null,null,"ExESep","Flag for excluding new enhanced septic treatment capacity","-"]
[null,null,null,null,null,null,null,null,null,"XWtpAvEff","WTP average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XWtpMaxIn","WTP maximum constituent influent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XUWtpAvEff","Upgraded WTP average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XWwtpAvEff","WWTP average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XWwtpMaxIn","WWTP maximum constituent influent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XUWwtpAvEff","Upgraded WWTP average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XWrfAvEff","WRF average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XAsrAvEff","ASR average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"CCUWtpU","Initial or capital cost for additional tertiary water treatment plant capacity","$/MGD"]
[null,null,null,null,null,null,null,null,null,"TUWtpNew","Lifetime of new construction for additional capacity for tertiary WTP","years"]
[null,null,null,null,null,null,null,null,null,"CCUWwtpU","Initial or capital cost for additional tertiary wastewater treatment plant capacity","$/MGD"]
[null,null,null,null,null,null,null,null,null,"TUWwtpNew","Lifetime of new construction for additional capacity for upgraded WWTP","years"]
[null,null,null,null,null,null,null,null,null,"CCESepU","Initial or capital cost for enahanced septic treatment","$/MGD"]
[null,null,null,null,null,null,null,null,null,"TESepNew","Lifetime of new construction for enhanced septic treatment","years"]
[null,null,null,null,null,null,null,null,null,"XSepAvEff","Septic average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XESepAvEff","Enhanced septic average constituent effluent concentration","mg/L"]
[null,null,null,null,null,null,null,null,null,"XIbtWUse","Average constituent concentration for interbasin transfer int","mg/L"]
[null,null,null,null,null,null,null,null,null,"ObsConc","Measured concentration time series for WQ calibration/validat","mg/L"]

{"sheet":"Loaded Scenarios","index":3,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Loaded Files: ","Data Name: ","Scenario Name (edit here):","StudyAreaName:","ScenarioName:","RunStartTime:","StartDate:","EndDate:","ModelMode:","Avg Annual Precip","Avg Temperature","Precipitation Change","Temperature Change"]

{"sheet":"Model Results","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Model Input Data","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}