{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Intro","WSO 1","WSO 2","WSO 3","Indices + Universal Variables","WSO 4","WSO 5","Detailed results","Criteria_Matrix","SD","Radar Chart","MCDA_Criteria Matrix","Criteria Descriptions","(Hide-lists)","(Hide-contents)"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":2,"defined_names":63,"comments":0,"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":"Intro","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,3,9],[8,1,11,9],[13,1,14,9],[25,1,34,9]]}
[null,"Methodology for a Comprehensive Analysis (Triple Bottom Line) of Alternative Water Supply Projects Compared to Direct Potable Reuse"]
[]
[]
[]
[null,"Water Environment & Reuse Foundation Project 14-03"]
[]
[null,"Introduction to Tool"]
[]
[null,"Hazen and Sawyer and the University of New South Wales (UNSW) Australia have developed the Water Supply Evaluation Tool (WaterSET), a \"triple bottom line\" (TBL) analysis tool to help water utilities with water supply planning. The TBL tool is capable of quantitatively assessing the economic, environmental, and social implications of various water supply options based on a utility's specific inputs."]
[]
[]
[]
[]
[null,"This project, WERF-14-03, is funded by theWater Environment & Reuse Foundation (since integrated into the Water Research Foundation) and the Australian Water Recycled Centre of Excellence (AWRCoE)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The development team cannot warrant that all functions contained in this program will meet your requirements or expectations, or that the operation of the program will be uninterrupted, secure or error-free. Please note that the model and tool developed as part of this project are primarily intended for use as a comparative triple bottom line framework at the national US level. Cost curves for different unit processes are based on standard equations found in reputable engineering textbooks (see manual for a complete list of data sources and assumptions), but these references may not accurately reflect the specific context of your current operations. Thus, the results obtained from the use of this software may thus not necessarily be effective, accurate or reliable. "]

{"sheet":"WSO 1","index":1,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":false,"merged":[[9,0,11,6],[14,3,14,4],[14,5,14,6],[169,0,171,6]]}
["USER INPUTS "]
[null,"Water supply option name","WSO 1"]
[null,"Notes about water supply option (optional)"]
[null,"State","AL"]
[null,"Postcode","35007"]
[null,"Processes part of new or existing plant? ","New"]
[null,"Proposed new plant capacity or expansion yield (1-200 MGD)",1]
[null,"Plant flow rate (as % plant capacity)",100]
[]
["Please enter information below related to unit treatment processes. For example, if this WSO requires the use of 5 circular clarifiers, each having a basin area of 100 square feet (SF), then the inputs would be \"100\" for the \"Size per Individual Unit\" and \"5\" for the \"Number of Individual Units\". Please be advised that size inputs should ideally only include numbers within the recommended range (numbers outside this range may be used but are associated with a significantly higher degree of uncertainty). These unit process inputs are used to estimate process-related capital and operational expenditure and associated impacts. "]
[]
[]
["Note: For chemical feed systems, the \"size per individual unit\" refers to the maximum feed capacity (i.e., design flow rate) in units specified in column C (e.g., pounds per day or gallons per hour)."]
[]
[null,null,null,"Unit process size",null,"Recommended size range"]
["Number","Process","Units","Size per Individual Unit","Number of Individual Units","Lower Bound","Upper Bound","Process type"]
[1,"Chlorine storage and feed 150# cylinder storage","Chlorine Feed capacity (lb/day)",null,null,10,200,"Pretreatment"]
[2,"Chlorine storage and feed 1-ton cylinder storage","Chlorine Feed capacity (lb/day)",null,null,200,10000,"Pretreatment"]
[3,"On-site storage tank with rail delivery","Chlorine Feed capacity (lb/day)",null,null,1980,10000,"Pretreatment"]
[4,"Direct feed from rail car","Chlorine Feed capacity (lb/day)",null,null,1980,10000,"Pretreatment"]
[5,"Sodium hypochlorite - generated onsite","Hypochlorite Generation Rate (lb/day)",null,null,10,10000,"Pretreatment"]
[6,"Sodium hypochlorite generated offsite","Liquid Chlorine Feed (lb/day)",null,null,10,10000,"Pretreatment"]
[7,"Chlorine dioxide","Feed Capacity (lb/day)",null,null,1,5000,"Pretreatment"]
[8,"Ozone Generation","Ozone Generation Capacity (lb/day)",null,null,10,3500,"Pretreatment"]
[9,"Powdered Activated Carbon","Carbon Feed (lb/hour)",null,null,3,6600,"Pretreatment"]
[10,"Liquid Alum Feed ","Liquid Feed Capacity (lb/hour)",null,null,5.4,5400,"Coagulation, precipitation and flocculation"]
[11,"Dry Alum Feed","Feed Capacity (lb/hour)",null,null,10,5000,"Coagulation, precipitation and flocculation"]
[12,"Polymer Feed","Feed capacity (lb/day)",null,null,1,200,"Coagulation, precipitation and flocculation"]
[13,"Sulfuric Acid Feed ","Feed capacity (gallons/day)",null,null,10,5000,"Coagulation, precipitation and flocculation"]
[14,"Sodium Hydroxide Feed ","Feed capacity (lb/day)",null,null,10,10000,"Coagulation, precipitation and flocculation"]
[15,"Ferrrous sulfate feed","Feed Capacity (lb/hour)",null,null,10.7,5350,"Coagulation, precipitation and flocculation"]
[16,"Ferric sulfate feed","Feed Capacity (lb/hour)",null,null,13.3,6600,"Coagulation, precipitation and flocculation"]
[17,"Ferric Chloride Feed ","Feed Capacity (lb/day)",null,null,13,6600,"Coagulation, precipitation and flocculation"]
[18,"Lime Feed","Lime Feed Capacity (lb/day)",null,null,10,10000,"Stability"]
[19,"Potassium Permanganate Feed","Dry KMNO4 Feed (lb/day)",null,null,1,500,"Taste and odour control"]
[20,"Anhydrous Ammonia Feed ","Feed Capacity (lb/day)",null,null,240,5080,"Disinfection"]
[21,"Aqua Ammonia Feed","Ammonia Feed (gallons/day)",null,null,240,5080,"Disinfection"]
[22,"Rapid Mix G=300/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[23,"Rapid Mix G=600/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[24,"Rapid Mix G=900/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[25,"Flocculation: Horizontal paddle systems G=20/s","Total Basin Volume (ft3)",null,null,1800,1000000,"Coagulation, precipitation and flocculation"]
[26,"Flocculation: Horizontal paddle systems G=50/s","Total Basin Volume (ft3)",null,null,1800,1000000,"Coagulation, precipitation and flocculation"]
[27,"Flocculation: Horizontal paddle systems G=80/s","Total Basin Volume (ft3)",null,null,1800,500000,"Coagulation, precipitation and flocculation"]
[28,"Circular Clarifier","Basin Area (ft2)",null,null,650,32300,"Sedimentation"]
[29,"Rectangular Clarifier","Basin Area (ft2)",null,null,5000,150000,"Sedimentation"]
[30,"Gravity Filter Structure","Basin Area (ft2)",null,null,140,28000,"Filtration"]
[31,"Filtration Media - Rapid sand","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[32,"Filtration Media - Dual media","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[33,"Filtration Media - Mixed media","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[34,"Filter Backwash Pumping","Pumping capacity (gpm)",null,null,1.8,33,"Filtration"]
[35,"Surface Wash System","Filter Area (ft2)",null,null,140,28000,"Filtration"]
[36,"Air Scour Wash","Filter Area (ft2)",null,null,140,28000,"Filtration"]
[37,"Continuous automatic backwash","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[38,"Finished Water Pumping  TDH =30ft","Plant Capacity (mgd)",null,null,1.5,300,"Clear water storage and distribution"]
[39,"Finished Water Pumping  TDH =100ft","Plant Capacity (mgd)",null,null,1.5,300,"Clear water storage and distribution"]
[40,"Raw water pumping TDH = 30ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[41,"Raw water pumping TDH = 100ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[42,"In-plant pumping TDH = 35ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[43,"In-plant pumping TDH = 75ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[44,"Gravity Sludge Thickener","Thickener Diameter (ft)",null,null,20,150,"Residual processing and disposal"]
[45,"Sludge Dewatering lagoons","Effective Storage Volume (MG)",null,null,0.08,40,"Residual processing and disposal"]
[46,"Sand Drying Beds","Total Bed Area Capacity (ft2)",null,null,4800,400000,"Residual processing and disposal"]
[47,"Filter Press","Filter Press Volume (gallons)",null,null,30,6600,"Residual processing and disposal"]
[48,"Belt Filter Press","Machine Capacity (gallons/hour)",null,null,800,53000,"Residual processing and disposal"]
[49,"Ion exchange - pressure ion exchange softening","Plant Capacity (mgd)",null,null,1.1000000000000001,122.6,"Ion exchange"]
[50,"Ion exchange - gravity ion exchange softening","Plant Capacity (mgd)",null,null,1.5,150,"Ion exchange"]
[51,"Ion exchange - pressure ion exchange nitrate removal","Plant Capacity (mgd)",null,null,1.1000000000000001,12.3,"Ion exchange"]
[52,"Fluoride removal - activated alumina","Plant Capacity (mgd)",null,null,0.7,135,"Fluoride removal"]
[53,"Ozone ","Plant Capacity (mgd)",null,null,10,535,"Advanced water treatment process"]
[54,"Ozone + H2O2","Plant Capacity (mgd)",null,null,10,535,"Advanced water treatment process"]
[55,"UV advanced oxidation (UV/H2O2)","Plant Capacity (mgd)",null,null,1,80,"Advanced water treatment process"]
[56,"MF/UF","Plant Capacity (mgd)",null,null,1,53,"Advanced water treatment process"]
[57,"NF/RO","Plant Capacity (mgd)",null,null,1,53,"Advanced water treatment process"]
[58,"BAC - 10min EBCT","Plant Capacity (mgd)",null,null,10,80,"Advanced water treatment process"]
[59,"BAC - 20min EBCT","Plant Capacity (mgd)",null,null,10,80,"Advanced water treatment process"]
[60,"Administration, Laboratory, and Maintenance Building","Plant Capacity (mgd)",null,null,1,200,"Management"]
[61,"Two-stage filtration","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[62,"Direct filtration","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[63,"Conventional treatment (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[64,"Dissolved air flotation (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[65,"Lime & soda ash (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[66,"Iron manganese removal (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[67,"Micro-membrane (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[68,"Direct filtration w/pre-ozone (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[69,"Conventional treatment w/ ozone and GAC (standard WTP)","System Capacity (mgd)",null,null,1,300,"Entire plant -please note that this includes several unit processes"]
[70,"MSF - (Diesel-powered)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[71,"MSF (Gas-powered)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[72,"MSF (50% gas, 50% diesel)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[73,"SWRO (WTP)","System Capacity (mgd)",null,null,10,150,"Entire plant -please note that this includes several unit processes"]
[74,"BWRO (WTP)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[]
["Please input information below related to chemical dosing (you have the choice to enter either lb/day or mg/L). These inputs are used to calculate operational requirements."]
[]
[null,"Chemical Name ","Chemical Dose ","Units"]
[null,"Caustic Soda (Sodium Hydroxide)",null,"lb/day"]
[null,"Sodium Hypochlorite Liquid chlorine",null,"lb/day"]
[null,"Chlorine Gas",null,"lb/day"]
[null,"Liquid Oxygen (LOX)",null,"lb/day"]
[null,"Liquid Alum Feed  - 50% Solution",null,"lb/day"]
[null,"Dry Alum (coagulation) - 48%",null,"lb/day"]
[null,"Polymer (Polydyne SE1179 polymer )",null,"lb/day"]
[null,"Lime",null,"lb/day"]
[null,"Sulfuric Acid - 93% Solution (ph control)",null,"lb/day"]
[null,"Sodium Hydroxide - 50% Solution (ph control)",null,"lb/day"]
[null,"Ferric Chloride Feed  - 39% Solution",null,"lb/day"]
[null,"Powdered Activated Carbon",null,"lb/day"]
[null,"Fluoride",null,"lb/day"]
[null,"Phosphate(Phosphoric Acid)",null,"lb/day"]
[null,"Anhydrous Ammonia Feed",null,"lb/day"]
[null,"Aqua Ammonia Feed - 29%",null,"lb/day"]
[null,"Ammonia (chloramines)",null,"lb/day"]
[null,"Chlorine Dioxide",null,"lb/day"]
[null,"Potassium Permanganate - 100%",null,"lb/day"]
[null,"Conditioning of sludge prior to dewatering Polymer",null,"lb/day"]
[null,"Sodium Chloride - 100%",null,"lb/day"]
[null,"PreTreatment w/ Coagulant Addition (Alum)",null,"lb/day"]
[null,"PreTreatment w/ Coagulant Addition (Polymer Alum)",null,"lb/day"]
[null,"Dry Alum Feed (coagulation) ",null,"lb/day"]
[null,"Liquid Alum Feed  - 50% Solution ",null,"lb/day"]
[null,"Antiscalant - 100%",null,"lb/day"]
[null,"Sodium hydroxide - 30%",null,"lb/day"]
[null,"Citric Acid  - 50%",null,"lb/day"]
[null,"GAC (Granular Activated Carbon)",null,"lb/day"]
[null,"Hydrogen peroxide - 50%",null,"lb/day"]
[]
[null,"Conveyance:  Transmission Mains From Supply to Water Treatment Facility"]
["Please input information related to the conveyance of this WSO to the drinking water treatment facility."]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Estimated total head loss (sum of all major + minor losses + static head)","ft",0]
[null,"Pump efficiency (default = 0.6)","unitless (0-1) ",0.6]
[]
[null,"Pumping station(s)",null,"Capacity","Number of stations"]
[null,"Capacity 1","MGD",0,0]
[null,"Capacity 2","MGD",0,0]
[null,"Capacity 3","MGD",0,0]
[null,"Capacity 4","MGD",0,0]
[null,"Capacity 5","MGD",0,0]
[]
[null,"Piping type and length","Material (select one)","Length (ft)","Diameter (inches)","Price (per inch diameter per linear foot)"]
[null,"Pipe 1","Ductile Iron",0,0,0]
[null,"Pipe 2","PVC",0,0,0]
[null,"Pipe 3","PVC",0,0,0]
[null,"Pipe 4","PVC",0,0,0]
[null,"Pipe 5","PVC",0,0,0]
[null,"Pipe 6","Ductile Iron",0,0,0]
[]
[null,"Conveyance:  Purple Pipe from Facility to Distribution","Does this apply to this WSO?","No"]
["Please input information related to a purple pipe (dual reticulation) non-potable reuse system - if not applicable to this WSO choose 'no' above and ignore section"]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Estimated total head loss (sum of all major + minor losses + static head)","ft",0]
[null,"Pump efficiency (default = 0.6)","unitless (0-1) ",0.6]
[]
[null,"Pumping station(s)",null,"Capacity","Number of stations"]
[null,"Capacity 1","MGD",0,0]
[null,"Capacity 2","MGD",0,0]
[null,"Capacity 3","MGD",0,0]
[null,"Capacity 4","MGD",0,0]
[null,"Capacity 5","MGD",0,0]
[]
[null,"Piping type and length","Material (select one)","Length (ft)","Diameter (inches)","Price (per inch diameter per linear foot)"]
[null,"Pipe 1","Ductile Iron",0,0,0]
[null,"Pipe 2","PVC",0,0,0]
[null,"Pipe 3","PVC",0,0,0]
[null,"Pipe 4","PVC",0,0,0]
[null,"Pipe 5","PVC",0,0,0]
[null,"Pipe 6","PVC",0,0,0]
[]
["Please input information related to the daily production of residuals and their management. Here, \"residuals\" only refers to solids (i.e., sludge); brines should not be input into this section. If brine management should be included in this WSO comparison, please add it as a new criterion in the \"Criteria_Matrix\" tabs. New criteria can be added to this evaluation using the \"Add Criteria\" button. "]
[]
[]
[]
[null,"Solids/residuals disposal (Used to estimate fuel and cost)"]
[null,"Estimated residuals mass","lb wet residual mass per day",0]
[null,"Average truckload weight capacity","pounds (lb)",0]
[null,"Average distance to disposal site per day (one-way trip)","miles",0]
[null,"Fixed disposal costs (e.g., landfill fees, brine line access, etc.)","$ per year",0]
[]
["Please input data to be used by the tool to determine the costs of the WSO option being considered "]
[]
[null,"Option to enter user-defined costs","Select between 'defaults' or 'own costs'","defaults"]
[null,"Select cost year","Year",2016]
[null,"CAPEX (total construction and non-construction costs) - optional","$",0,"Only input value if using \"own costs\""]
[null,"Plant service life (years)","years",30,"Value must be entered regardless of whether \"defaults\" or \"own costs\" are used"]
[null,"Annual interest rate","percentage",5]
[null,"Annual O&M - optional ","$ per year",0,"Only input value if using \"own costs\""]
[]
[null,"Aditional costs - optional"]
[null,"Purchased water","$ per year",0,"\"Purchased water\" is shown as an example category, but any additional annual costs may be input here"]
[]
[null,"Onsite vs. grid electricity use"]
[null,"Electricity purchased from grid","%",100]
[null,"Electricity from onsite solar PV system","% ",{"$f":"100-D193","v":0}]
[]
[null,"Additional onsite fuel use from vehicles excluding residuals disposal (leave as zeros if not relevant)"]
[null,"Auto gasoline / petrol","gallons per year",0]
[null,"Automotive diesel oil","gallons per year",0]
[null,"Fuel oil / heating oil ","gallons per year",0]
[null,"Natural gas","cubic feet (1000s) per year",0]
[null,"Aviation fuel / kerosene","gallons per year",0]

{"sheet":"WSO 2","index":2,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":false,"merged":[[9,0,11,6],[14,3,14,4],[14,5,14,6],[169,0,171,6]]}
["USER INPUTS "]
[null,"Water supply option name","WSO 2"]
[null,"Notes about water supply option (optional)"]
[null,"State","AL"]
[null,"Postcode","35007"]
[null,"Processes part of new or existing plant? ","Existing"]
[null,"Proposed new plant capacity or expansion yield (1-200 MGD)",1]
[null,"Plant flow rate (as % plant capacity)",100]
[]
["Please enter information below related to unit treatment processes. For example, if this WSO requires the use of 5 circular clarifiers, each having a basin area of 100 square feet (SF), then the inputs would be \"100\" for the \"Size per Individual Unit\" and \"5\" for the \"Number of Individual Units\". Please be advised that size inputs should ideally only include numbers within the recommended range (numbers outside this range may be used but are associated with a significantly higher degree of uncertainty). These unit process inputs are used to estimate process-related capital and operational expenditure and associated impacts. "]
[]
[]
["Note: For chemical feed systems, the \"size per individual unit\" refers to the maximum feed capacity (i.e., design flow rate) in units specified in column C (e.g., pounds per day or gallons per hour)."]
[]
[null,null,null,"Unit process size",null,"Recommended size range"]
["Number","Process","Units","Size per Individual Unit","Number of Individual Units","Lower Bound","Upper Bound","Process type"]
[1,"Chlorine storage and feed 150# cylinder storage","Chlorine Feed capacity (lb/day)",null,null,10,200,"Pretreatment"]
[2,"Chlorine storage and feed 1-ton cylinder storage","Chlorine Feed capacity (lb/day)",null,null,200,10000,"Pretreatment"]
[3,"On-site storage tank with rail delivery","Chlorine Feed capacity (lb/day)",null,null,1980,10000,"Pretreatment"]
[4,"Direct feed from rail car","Chlorine Feed capacity (lb/day)",null,null,1980,10000,"Pretreatment"]
[5,"Sodium hypochlorite - generated onsite","Hypochlorite Generation Rate (lb/day)",null,null,10,10000,"Pretreatment"]
[6,"Sodium hypochlorite generated offsite","Liquid Chlorine Feed (lb/day)",null,null,10,10000,"Pretreatment"]
[7,"Chlorine dioxide","Feed Capacity (lb/day)",null,null,1,5000,"Pretreatment"]
[8,"Ozone Generation","Ozone Generation Capacity (lb/day)",null,null,10,3500,"Pretreatment"]
[9,"Powdered Activated Carbon","Carbon Feed (lb/hour)",null,null,3,6600,"Pretreatment"]
[10,"Liquid Alum Feed ","Liquid Feed Capacity (lb/hour)",null,null,5.4,5400,"Coagulation, precipitation and flocculation"]
[11,"Dry Alum Feed","Feed Capacity (lb/hour)",null,null,10,5000,"Coagulation, precipitation and flocculation"]
[12,"Polymer Feed","Feed capacity (lb/day)",null,null,1,200,"Coagulation, precipitation and flocculation"]
[13,"Sulfuric Acid Feed ","Feed capacity (gallons/day)",null,null,10,5000,"Coagulation, precipitation and flocculation"]
[14,"Sodium Hydroxide Feed ","Feed capacity (lb/day)",null,null,10,10000,"Coagulation, precipitation and flocculation"]
[15,"Ferrrous sulfate feed","Feed Capacity (lb/hour)",null,null,10.7,5350,"Coagulation, precipitation and flocculation"]
[16,"Ferric sulfate feed","Feed Capacity (lb/hour)",null,null,13.3,6600,"Coagulation, precipitation and flocculation"]
[17,"Ferric Chloride Feed ","Feed Capacity (lb/day)",null,null,13,6600,"Coagulation, precipitation and flocculation"]
[18,"Lime Feed","Lime Feed Capacity (lb/day)",null,null,10,10000,"Stability"]
[19,"Potassium Permanganate Feed","Dry KMNO4 Feed (lb/day)",null,null,1,500,"Taste and odour control"]
[20,"Anhydrous Ammonia Feed ","Feed Capacity (lb/day)",null,null,240,5080,"Disinfection"]
[21,"Aqua Ammonia Feed","Ammonia Feed (gallons/day)",null,null,240,5080,"Disinfection"]
[22,"Rapid Mix G=300/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[23,"Rapid Mix G=600/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[24,"Rapid Mix G=900/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[25,"Flocculation: Horizontal paddle systems G=20/s","Total Basin Volume (ft3)",null,null,1800,1000000,"Coagulation, precipitation and flocculation"]
[26,"Flocculation: Horizontal paddle systems G=50/s","Total Basin Volume (ft3)",null,null,1800,1000000,"Coagulation, precipitation and flocculation"]
[27,"Flocculation: Horizontal paddle systems G=80/s","Total Basin Volume (ft3)",null,null,1800,500000,"Coagulation, precipitation and flocculation"]
[28,"Circular Clarifier","Basin Area (ft2)",null,null,650,32300,"Sedimentation"]
[29,"Rectangular Clarifier","Basin Area (ft2)",null,null,5000,150000,"Sedimentation"]
[30,"Gravity Filter Structure","Basin Area (ft2)",null,null,140,28000,"Filtration"]
[31,"Filtration Media - Rapid sand","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[32,"Filtration Media - Dual media","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[33,"Filtration Media - Mixed media","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[34,"Filter Backwash Pumping","Pumping capacity (gpm)",null,null,1.8,33,"Filtration"]
[35,"Surface Wash System","Filter Area (ft2)",null,null,140,28000,"Filtration"]
[36,"Air Scour Wash","Filter Area (ft2)",null,null,140,28000,"Filtration"]
[37,"Continuous automatic backwash","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[38,"Finished Water Pumping  TDH =30ft","Plant Capacity (mgd)",null,null,1.5,300,"Clear water storage and distribution"]
[39,"Finished Water Pumping  TDH =100ft","Plant Capacity (mgd)",null,null,1.5,300,"Clear water storage and distribution"]
[40,"Raw water pumping TDH = 30ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[41,"Raw water pumping TDH = 100ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[42,"In-plant pumping TDH = 35ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[43,"In-plant pumping TDH = 75ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[44,"Gravity Sludge Thickener","Thickener Diameter (ft)",null,null,20,150,"Residual processing and disposal"]
[45,"Sludge Dewatering lagoons","Effective Storage Volume (MG)",null,null,0.08,40,"Residual processing and disposal"]
[46,"Sand Drying Beds","Total Bed Area Capacity (ft2)",null,null,4800,400000,"Residual processing and disposal"]
[47,"Filter Press","Filter Press Volume (gallons)",null,null,30,6600,"Residual processing and disposal"]
[48,"Belt Filter Press","Machine Capacity (gallons/hour)",null,null,800,53000,"Residual processing and disposal"]
[49,"Ion exchange - pressure ion exchange softening","Plant Capacity (mgd)",null,null,1.1000000000000001,122.6,"Ion exchange"]
[50,"Ion exchange - gravity ion exchange softening","Plant Capacity (mgd)",null,null,1.5,150,"Ion exchange"]
[51,"Ion exchange - pressure ion exchange nitrate removal","Plant Capacity (mgd)",null,null,1.1000000000000001,12.3,"Ion exchange"]
[52,"Fluoride removal - activated alumina","Plant Capacity (mgd)",null,null,0.7,135,"Fluoride removal"]
[53,"Ozone ","Plant Capacity (mgd)",null,null,10,535,"Advanced water treatment process"]
[54,"Ozone + H2O2","Plant Capacity (mgd)",null,null,10,535,"Advanced water treatment process"]
[55,"UV advanced oxidation (UV/H2O2)","Plant Capacity (mgd)",null,null,1,80,"Advanced water treatment process"]
[56,"MF/UF","Plant Capacity (mgd)",null,null,1,53,"Advanced water treatment process"]
[57,"NF/RO","Plant Capacity (mgd)",null,null,1,53,"Advanced water treatment process"]
[58,"BAC - 10min EBCT","Plant Capacity (mgd)",null,null,10,80,"Advanced water treatment process"]
[59,"BAC - 20min EBCT","Plant Capacity (mgd)",null,null,10,80,"Advanced water treatment process"]
[60,"Administration, Laboratory, and Maintenance Building","Plant Capacity (mgd)",null,null,1,200,"Management"]
[61,"Two-stage filtration","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[62,"Direct filtration","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[63,"Conventional treatment (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[64,"Dissolved air flotation (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[65,"Lime & soda ash (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[66,"Iron manganese removal (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[67,"Micro-membrane (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[68,"Direct filtration w/pre-ozone (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[69,"Conventional treatment w/ ozone and GAC (standard WTP)","System Capacity (mgd)",null,null,1,300,"Entire plant -please note that this includes several unit processes"]
[70,"MSF - (Diesel-powered)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[71,"MSF (Gas-powered)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[72,"MSF (50% gas, 50% diesel)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[73,"SWRO (WTP)","System Capacity (mgd)",null,null,10,150,"Entire plant -please note that this includes several unit processes"]
[74,"BWRO (WTP)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[]
["Please input information below related to chemical dosing (you have the choice to enter either lb/day or mg/L). These inputs are used to calculate operational requirements."]
[]
[null,"Chemical Name ","Chemical Dose ","Units"]
[null,"Caustic Soda (Sodium Hydroxide)",null,"lb/day"]
[null,"Sodium Hypochlorite Liquid chlorine",null,"lb/day"]
[null,"Chlorine Gas",null,"lb/day"]
[null,"Liquid Oxygen (LOX)",null,"lb/day"]
[null,"Liquid Alum Feed  - 50% Solution",null,"lb/day"]
[null,"Dry Alum (coagulation) - 48%",null,"lb/day"]
[null,"Polymer (Polydyne SE1179 polymer )",null,"lb/day"]
[null,"Lime",null,"lb/day"]
[null,"Sulfuric Acid - 93% Solution (ph control)",null,"lb/day"]
[null,"Sodium Hydroxide - 50% Solution (ph control)",null,"lb/day"]
[null,"Ferric Chloride Feed  - 39% Solution",null,"lb/day"]
[null,"Powdered Activated Carbon",null,"lb/day"]
[null,"Fluoride",null,"lb/day"]
[null,"Phosphate(Phosphoric Acid)",null,"lb/day"]
[null,"Anhydrous Ammonia Feed",null,"lb/day"]
[null,"Aqua Ammonia Feed - 29%",null,"lb/day"]
[null,"Ammonia (chloramines)",null,"lb/day"]
[null,"Chlorine Dioxide",null,"lb/day"]
[null,"Potassium Permanganate - 100%",null,"lb/day"]
[null,"Conditioning of sludge prior to dewatering Polymer",null,"lb/day"]
[null,"Sodium Chloride - 100%",null,"lb/day"]
[null,"PreTreatment w/ Coagulant Addition (Alum)",null,"lb/day"]
[null,"PreTreatment w/ Coagulant Addition (Polymer Alum)",null,"lb/day"]
[null,"Dry Alum Feed (coagulation) ",null,"lb/day"]
[null,"Liquid Alum Feed  - 50% Solution ",null,"lb/day"]
[null,"Antiscalant - 100%",null,"lb/day"]
[null,"Sodium hydroxide - 30%",null,"lb/day"]
[null,"Citric Acid  - 50%",null,"lb/day"]
[null,"GAC (Granular Activated Carbon)",null,"lb/day"]
[null,"Hydrogen peroxide - 50%",null,"lb/day"]
[]
[null,"Conveyance:  Transmission Mains From Supply to Water Treatment Facility"]
["Please input information related to the conveyance of this WSO to the drinking water treatment facility."]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Estimated total head loss (sum of all major + minor losses + static head)","ft",0]
[null,"Pump efficiency (default = 0.6)","unitless (0-1) ",0.6]
[]
[null,"Pumping station(s)",null,"Capacity","Number of stations"]
[null,"Capacity 1","MGD",0,0]
[null,"Capacity 2","MGD",0,0]
[null,"Capacity 3","MGD",0,0]
[null,"Capacity 4","MGD",0,0]
[null,"Capacity 5","MGD",0,0]
[]
[null,"Piping type and length","Material (select one)","Length (ft)","Diameter (inches)","Price (per inch diameter per linear foot)"]
[null,"Pipe 1","Ductile Iron",0,0,0]
[null,"Pipe 2","PVC",0,0,0]
[null,"Pipe 3","PVC",0,0,0]
[null,"Pipe 4","PVC",0,0,0]
[null,"Pipe 5","PVC",0,0,0]
[null,"Pipe 6","Ductile Iron",0,0,0]
[]
[null,"Conveyance:  Purple Pipe from Facility to Distribution","Does this apply to this WSO?","No"]
["Please input information related to a purple pipe (dual reticulation) non-potable reuse system - if not applicable to this WSO choose 'no' above and ignore section"]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Estimated total head loss (sum of all major + minor losses + static head)","ft",0]
[null,"Pump efficiency (default = 0.6)","unitless (0-1) ",0.6]
[]
[null,"Pumping station(s)",null,"Capacity","Number of stations"]
[null,"Capacity 1","MGD",0,0]
[null,"Capacity 2","MGD",0,0]
[null,"Capacity 3","MGD",0,0]
[null,"Capacity 4","MGD",0,0]
[null,"Capacity 5","MGD",0,0]
[]
[null,"Piping type and length","Material (select one)","Length (ft)","Diameter (inches)","Price (per inch diameter per linear foot)"]
[null,"Pipe 1","Ductile Iron",0,0,0]
[null,"Pipe 2","PVC",0,0,0]
[null,"Pipe 3","PVC",0,0,0]
[null,"Pipe 4","PVC",0,0,0]
[null,"Pipe 5","PVC",0,0,0]
[null,"Pipe 6","PVC",0,0,0]
[]
["Please input information related to the daily production of residuals and their management. Here, \"residuals\" only refers to solids (i.e., sludge); brines should not be input into this section. If brine management should be included in this WSO comparison, please add it as a new criterion in the \"Criteria_Matrix\" tabs. New criteria can be added to this evaluation using the \"Add Criteria\" button. "]
[]
[]
[]
[null,"Solids/residuals disposal (Used to estimate fuel and cost)"]
[null,"Estimated residuals mass","lb wet residual mass per day",0]
[null,"Average truckload weight capacity","pounds (lb)",0]
[null,"Average distance to disposal site per day (one-way trip)","miles",0]
[null,"Fixed disposal costs (e.g., landfill fees, brine line access, etc.)","$ per year",0]
[]
["Please input data to be used by the tool to determine the costs of the WSO option being considered "]
[]
[null,"Option to enter user-defined costs","Select between 'defaults' or 'own costs'","defaults"]
[null,"Select cost year","Year",2016]
[null,"CAPEX (total construction and non-construction costs) - optional","$",0,"Only input value if using \"own costs\""]
[null,"Plant service life (years)","years",30,"Value must be entered regardless of whether \"defaults\" or \"own costs\" are used"]
[null,"Annual interest rate","percentage",5]
[null,"Annual O&M - optional ","$ per year",0,"Only input value if using \"own costs\""]
[]
[null,"Aditional costs - optional"]
[null,"Purchased water","$ per year",0,"\"Purchased water\" is shown as an example category, but any additional annual costs may be input here"]
[]
[null,"Onsite vs. grid electricity use"]
[null,"Electricity purchased from grid","%",100]
[null,"Electricity from onsite solar PV system","% ",{"$f":"100-D193","v":0}]
[]
[null,"Additional onsite fuel use from vehicles excluding residuals disposal (leave as zeros if not relevant)"]
[null,"Auto gasoline / petrol","gallons per year",0]
[null,"Automotive diesel oil","gallons per year",0]
[null,"Fuel oil / heating oil ","gallons per year",0]
[null,"Natural gas","cubic feet (1000s) per year",0]
[null,"Aviation fuel / kerosene","gallons per year",0]

{"sheet":"WSO 3","index":3,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":false,"merged":[[9,0,11,6],[14,3,14,4],[14,5,14,6],[169,0,171,6]]}
["USER INPUTS "]
[null,"Water supply option name","WSO 3"]
[null,"Notes about water supply option (optional)"]
[null,"State","AL"]
[null,"Postcode","35007"]
[null,"Processes part of new or existing plant? ","Existing"]
[null,"Proposed new plant capacity or expansion yield (1-200 MGD)",1]
[null,"Plant flow rate (as % plant capacity)",100]
[]
["Please enter information below related to unit treatment processes. For example, if this WSO requires the use of 5 circular clarifiers, each having a basin area of 100 square feet (SF), then the inputs would be \"100\" for the \"Size per Individual Unit\" and \"5\" for the \"Number of Individual Units\". Please be advised that size inputs should ideally only include numbers within the recommended range (numbers outside this range may be used but are associated with a significantly higher degree of uncertainty). These unit process inputs are used to estimate process-related capital and operational expenditure and associated impacts. "]
[]
[]
["Note: For chemical feed systems, the \"size per individual unit\" refers to the maximum feed capacity (i.e., design flow rate) in units specified in column C (e.g., pounds per day or gallons per hour)."]
[]
[null,null,null,"Unit process size",null,"Recommended size range"]
["Number","Process","Units","Size per Individual Unit","Number of Individual Units","Lower Bound","Upper Bound","Process type"]
[1,"Chlorine storage and feed 150# cylinder storage","Chlorine Feed capacity (lb/day)",null,null,10,200,"Pretreatment"]
[2,"Chlorine storage and feed 1-ton cylinder storage","Chlorine Feed capacity (lb/day)",null,null,200,10000,"Pretreatment"]
[3,"On-site storage tank with rail delivery","Chlorine Feed capacity (lb/day)",null,null,1980,10000,"Pretreatment"]
[4,"Direct feed from rail car","Chlorine Feed capacity (lb/day)",null,null,1980,10000,"Pretreatment"]
[5,"Sodium hypochlorite - generated onsite","Hypochlorite Generation Rate (lb/day)",null,null,10,10000,"Pretreatment"]
[6,"Sodium hypochlorite generated offsite","Liquid Chlorine Feed (lb/day)",null,null,10,10000,"Pretreatment"]
[7,"Chlorine dioxide","Feed Capacity (lb/day)",null,null,1,5000,"Pretreatment"]
[8,"Ozone Generation","Ozone Generation Capacity (lb/day)",null,null,10,3500,"Pretreatment"]
[9,"Powdered Activated Carbon","Carbon Feed (lb/hour)",null,null,3,6600,"Pretreatment"]
[10,"Liquid Alum Feed ","Liquid Feed Capacity (lb/hour)",null,null,5.4,5400,"Coagulation, precipitation and flocculation"]
[11,"Dry Alum Feed","Feed Capacity (lb/hour)",null,null,10,5000,"Coagulation, precipitation and flocculation"]
[12,"Polymer Feed","Feed capacity (lb/day)",null,null,1,200,"Coagulation, precipitation and flocculation"]
[13,"Sulfuric Acid Feed ","Feed capacity (gallons/day)",null,null,10,5000,"Coagulation, precipitation and flocculation"]
[14,"Sodium Hydroxide Feed ","Feed capacity (lb/day)",null,null,10,10000,"Coagulation, precipitation and flocculation"]
[15,"Ferrrous sulfate feed","Feed Capacity (lb/hour)",null,null,10.7,5350,"Coagulation, precipitation and flocculation"]
[16,"Ferric sulfate feed","Feed Capacity (lb/hour)",null,null,13.3,6600,"Coagulation, precipitation and flocculation"]
[17,"Ferric Chloride Feed ","Feed Capacity (lb/day)",null,null,13,6600,"Coagulation, precipitation and flocculation"]
[18,"Lime Feed","Lime Feed Capacity (lb/day)",null,null,10,10000,"Stability"]
[19,"Potassium Permanganate Feed","Dry KMNO4 Feed (lb/day)",null,null,1,500,"Taste and odour control"]
[20,"Anhydrous Ammonia Feed ","Feed Capacity (lb/day)",null,null,240,5080,"Disinfection"]
[21,"Aqua Ammonia Feed","Ammonia Feed (gallons/day)",null,null,240,5080,"Disinfection"]
[22,"Rapid Mix G=300/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[23,"Rapid Mix G=600/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[24,"Rapid Mix G=900/s","Basin Volume (gallons)",null,null,800,145000,"Coagulation, precipitation and flocculation"]
[25,"Flocculation: Horizontal paddle systems G=20/s","Total Basin Volume (ft3)",null,null,1800,1000000,"Coagulation, precipitation and flocculation"]
[26,"Flocculation: Horizontal paddle systems G=50/s","Total Basin Volume (ft3)",null,null,1800,1000000,"Coagulation, precipitation and flocculation"]
[27,"Flocculation: Horizontal paddle systems G=80/s","Total Basin Volume (ft3)",null,null,1800,500000,"Coagulation, precipitation and flocculation"]
[28,"Circular Clarifier","Basin Area (ft2)",null,null,650,32300,"Sedimentation"]
[29,"Rectangular Clarifier","Basin Area (ft2)",null,null,5000,150000,"Sedimentation"]
[30,"Gravity Filter Structure","Basin Area (ft2)",null,null,140,28000,"Filtration"]
[31,"Filtration Media - Rapid sand","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[32,"Filtration Media - Dual media","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[33,"Filtration Media - Mixed media","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[34,"Filter Backwash Pumping","Pumping capacity (gpm)",null,null,1.8,33,"Filtration"]
[35,"Surface Wash System","Filter Area (ft2)",null,null,140,28000,"Filtration"]
[36,"Air Scour Wash","Filter Area (ft2)",null,null,140,28000,"Filtration"]
[37,"Continuous automatic backwash","Plant Flow Rate (mgd)",null,null,1,200,"Filtration"]
[38,"Finished Water Pumping  TDH =30ft","Plant Capacity (mgd)",null,null,1.5,300,"Clear water storage and distribution"]
[39,"Finished Water Pumping  TDH =100ft","Plant Capacity (mgd)",null,null,1.5,300,"Clear water storage and distribution"]
[40,"Raw water pumping TDH = 30ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[41,"Raw water pumping TDH = 100ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[42,"In-plant pumping TDH = 35ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[43,"In-plant pumping TDH = 75ft","Plant Capacity (mgd)",null,null,1,200,"Clear water storage and distribution"]
[44,"Gravity Sludge Thickener","Thickener Diameter (ft)",null,null,20,150,"Residual processing and disposal"]
[45,"Sludge Dewatering lagoons","Effective Storage Volume (MG)",null,null,0.08,40,"Residual processing and disposal"]
[46,"Sand Drying Beds","Total Bed Area Capacity (ft2)",null,null,4800,400000,"Residual processing and disposal"]
[47,"Filter Press","Filter Press Volume (gallons)",null,null,30,6600,"Residual processing and disposal"]
[48,"Belt Filter Press","Machine Capacity (gallons/hour)",null,null,800,53000,"Residual processing and disposal"]
[49,"Ion exchange - pressure ion exchange softening","Plant Capacity (mgd)",null,null,1.1000000000000001,122.6,"Ion exchange"]
[50,"Ion exchange - gravity ion exchange softening","Plant Capacity (mgd)",null,null,1.5,150,"Ion exchange"]
[51,"Ion exchange - pressure ion exchange nitrate removal","Plant Capacity (mgd)",null,null,1.1000000000000001,12.3,"Ion exchange"]
[52,"Fluoride removal - activated alumina","Plant Capacity (mgd)",null,null,0.7,135,"Fluoride removal"]
[53,"Ozone ","Plant Capacity (mgd)",null,null,10,535,"Advanced water treatment process"]
[54,"Ozone + H2O2","Plant Capacity (mgd)",null,null,10,535,"Advanced water treatment process"]
[55,"UV advanced oxidation (UV/H2O2)","Plant Capacity (mgd)",null,null,1,80,"Advanced water treatment process"]
[56,"MF/UF","Plant Capacity (mgd)",null,null,1,53,"Advanced water treatment process"]
[57,"NF/RO","Plant Capacity (mgd)",null,null,1,53,"Advanced water treatment process"]
[58,"BAC - 10min EBCT","Plant Capacity (mgd)",null,null,10,80,"Advanced water treatment process"]
[59,"BAC - 20min EBCT","Plant Capacity (mgd)",null,null,10,80,"Advanced water treatment process"]
[60,"Administration, Laboratory, and Maintenance Building","Plant Capacity (mgd)",null,null,1,200,"Management"]
[61,"Two-stage filtration","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[62,"Direct filtration","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[63,"Conventional treatment (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[64,"Dissolved air flotation (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[65,"Lime & soda ash (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[66,"Iron manganese removal (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[67,"Micro-membrane (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[68,"Direct filtration w/pre-ozone (standard WTP)","System Capacity (mgd)",null,null,1,100,"Entire plant -please note that this includes several unit processes"]
[69,"Conventional treatment w/ ozone and GAC (standard WTP)","System Capacity (mgd)",null,null,1,300,"Entire plant -please note that this includes several unit processes"]
[70,"MSF - (Diesel-powered)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[71,"MSF (Gas-powered)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[72,"MSF (50% gas, 50% diesel)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[73,"SWRO (WTP)","System Capacity (mgd)",null,null,10,150,"Entire plant -please note that this includes several unit processes"]
[74,"BWRO (WTP)","System Capacity (mgd)",null,null,10,50,"Entire plant -please note that this includes several unit processes"]
[]
["Please input information below related to chemical dosing (you have the choice to enter either lb/day or mg/L). These inputs are used to calculate operational requirements."]
[]
[null,"Chemical Name ","Chemical Dose ","Units"]
[null,"Caustic Soda (Sodium Hydroxide)",null,"mg/L"]
[null,"Sodium Hypochlorite Liquid chlorine",null,"mg/L"]
[null,"Chlorine Gas",null,"mg/L"]
[null,"Liquid Oxygen (LOX)",null,"mg/L"]
[null,"Liquid Alum Feed  - 50% Solution",null,"mg/L"]
[null,"Dry Alum (coagulation) - 48%",null,"mg/L"]
[null,"Polymer (Polydyne SE1179 polymer )",null,"lb/day"]
[null,"Lime",null,"lb/day"]
[null,"Sulfuric Acid - 93% Solution (ph control)",null,"lb/day"]
[null,"Sodium Hydroxide - 50% Solution (ph control)",null,"lb/day"]
[null,"Ferric Chloride Feed  - 39% Solution",null,"mg/L"]
[null,"Powdered Activated Carbon",null,"mg/L"]
[null,"Fluoride",null,"mg/L"]
[null,"Phosphate(Phosphoric Acid)",null,"mg/L"]
[null,"Anhydrous Ammonia Feed",null,"mg/L"]
[null,"Aqua Ammonia Feed - 29%",null,"mg/L"]
[null,"Ammonia (chloramines)",null,"mg/L"]
[null,"Chlorine Dioxide",null,"mg/L"]
[null,"Potassium Permanganate - 100%",null,"mg/L"]
[null,"Conditioning of sludge prior to dewatering Polymer",null,"mg/L"]
[null,"Sodium Chloride - 100%",null,"lb/day"]
[null,"PreTreatment w/ Coagulant Addition (Alum)",null,"mg/L"]
[null,"PreTreatment w/ Coagulant Addition (Polymer Alum)",null,"mg/L"]
[null,"Dry Alum Feed (coagulation) ",null,"mg/L"]
[null,"Liquid Alum Feed  - 50% Solution ",null,"mg/L"]
[null,"Antiscalant - 100%",null,"mg/L"]
[null,"Sodium hydroxide - 30%",null,"mg/L"]
[null,"Citric Acid  - 50%",null,"lb/day"]
[null,"GAC (Granular Activated Carbon)",null,"mg/L"]
[null,"Hydrogen peroxide - 50%",null,"lb/day"]
[]
[null,"Conveyance:  Transmission Mains From Supply to Water Treatment Facility"]
["Please input information related to the conveyance of this WSO to the drinking water treatment facility."]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Estimated total head loss (sum of all major + minor losses + static head)","ft",0]
[null,"Pump efficiency (default = 0.6)","unitless (0-1) ",0.6]
[]
[null,"Pumping station(s)",null,"Capacity","Number of stations"]
[null,"Capacity 1","MGD",0,0]
[null,"Capacity 2","MGD",0,0]
[null,"Capacity 3","MGD",0,0]
[null,"Capacity 4","MGD",0,0]
[null,"Capacity 5","MGD",0,0]
[]
[null,"Piping type and length","Material (select one)","Length (ft)","Diameter (inches)","Price (per inch diameter per linear foot)"]
[null,"Pipe 1","Ductile Iron",0,0,0]
[null,"Pipe 2","PVC",0,0,0]
[null,"Pipe 3","PVC",0,0,0]
[null,"Pipe 4","PVC",0,0,0]
[null,"Pipe 5","PVC",0,0,0]
[null,"Pipe 6","Ductile Iron",0,0,0]
[]
[null,"Conveyance:  Purple Pipe from Facility to Distribution","Does this apply to this WSO?","No"]
["Please input information related to a purple pipe (dual reticulation) non-potable reuse system - if not applicable to this WSO choose 'no' above and ignore section"]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Estimated total head loss (sum of all major + minor losses + static head)","ft",0]
[null,"Pump efficiency (default = 0.6)","unitless (0-1) ",0.6]
[]
[null,"Pumping station(s)",null,"Capacity","Number of stations"]
[null,"Capacity 1","MGD",0,0]
[null,"Capacity 2","MGD",0,0]
[null,"Capacity 3","MGD",0,0]
[null,"Capacity 4","MGD",0,0]
[null,"Capacity 5","MGD",0,0]
[]
[null,"Piping type and length","Material (select one)","Length (ft)","Diameter (inches)","Price (per inch diameter per linear foot)"]
[null,"Pipe 1","Ductile Iron",0,0,0]
[null,"Pipe 2","PVC",0,0,0]
[null,"Pipe 3","PVC",0,0,0]
[null,"Pipe 4","PVC",0,0,0]
[null,"Pipe 5","PVC",0,0,0]
[null,"Pipe 6","PVC",0,0,0]
[]
["Please input information related to the daily production of residuals and their management. Here, \"residuals\" only refers to solids (i.e., sludge); brines should not be input into this section. If brine management should be included in this WSO comparison, please add it as a new criterion in the \"Criteria_Matrix\" tabs. New criteria can be added to this evaluation using the \"Add Criteria\" button. "]
[]
[]
[]
[null,"Solids/residuals disposal (Used to estimate fuel and cost)"]
[null,"Estimated residuals mass","lb wet residual mass per day",0]
[null,"Average truckload weight capacity","pounds (lb)",0]
[null,"Average distance to disposal site per day (one-way trip)","miles",0]
[null,"Fixed disposal costs (e.g., landfill fees, brine line access, etc.)","$ per year",0]
[]
["Please input data to be used by the tool to determine the costs of the WSO option being considered "]
[]
[null,"Option to enter user-defined costs","Select between 'defaults' or 'own costs'","defaults"]
[null,"Select cost year","Year",2016]
[null,"CAPEX (total construction and non-construction costs) - optional","$",0,"Only input value if using \"own costs\""]
[null,"Plant service life (years)","years",30,"Value must be entered regardless of whether \"defaults\" or \"own costs\" are used"]
[null,"Annual interest rate","percentage",5]
[null,"Annual O&M - optional ","$ per year",0,"Only input value if using \"own costs\""]
[]
[null,"Aditional costs - optional"]
[null,"Purchased water","$ per year",0,"\"Purchased water\" is shown as an example category, but any additional annual costs may be input here"]
[]
[null,"Onsite vs. grid electricity use"]
[null,"Electricity purchased from grid","%",100]
[null,"Electricity from onsite solar PV system","% ",{"$f":"100-D193","v":0}]
[]
[null,"Additional onsite fuel use from vehicles excluding residuals disposal (leave as zeros if not relevant)"]
[null,"Auto gasoline / petrol","gallons per year",0]
[null,"Automotive diesel oil","gallons per year",0]
[null,"Fuel oil / heating oil ","gallons per year",0]
[null,"Natural gas","cubic feet (1000s) per year",0]
[null,"Aviation fuel / kerosene","gallons per year",0]

{"sheet":"Indices + Universal Variables","index":4,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,0,9,0],[10,0,17,0],[19,0,49,0]]}
[null,"Cost component","Index","Latest value","Month","Year","Unit","Unit/Source"]
["TOTAL","Total cost","ENR Construction Cost Index (CCI)",10282,"February",2017,"Index","http://www.enr.com/economics"]
["CAPEX","Excavation and sitework","ENR skilled labor wage index",9927.94,"October",2016,"Index","http://www.enr.com/economics"]
[null,"Manufactured equipment","BLS general purpose machinery and equipment (WPU114)",226.5,"December",2016,"Index","https://data.bls.gov/timeseries/WPU114?data_tool=Xgtable"]
[null,"Concrete","BLS concrete ingredients (WPU132)",280.60000000000002,"December",2016,"Index","https://data.bls.gov/timeseries/WPU132?amp%253bdata_tool=XGtable&output_view=data&include_graphs=true"]
[null,"Steel","BLS steel mill products (WPU1017)",174,"December",2016,"Index","https://data.bls.gov/timeseries/WPU1017?amp%253bdata_tool=XGtable&output_view=data&include_graphs=true"]
[null,"Labor","ENR skilled labor wage index",9927.94,"October",2016,"Index","http://www.enr.com/economics"]
[null,"Pipes and valves","BLS Miscellaneous General Purpose Equipment (WPU1149)",266,"December",2016,"Index","https://data.bls.gov/timeseries/WPU1149"]
[null,"Electrical and instrumentation","BLS electrical machinery and equipment (WPU117)",112.8,"December",2016,"Index","https://data.bls.gov/timeseries/WPU117?amp%253bdata_tool=XGtable&output_view=data&include_graphs=true"]
[null,"Housing","ENR building cost index (BCI)",5681.63,"October",2016,"Index","http://www.enr.com/economics"]
["O&M","Maintenance material","BLS PPI for finished goods (WPUFD49207)",193.7,"December",2016,"Index","https://data.bls.gov/cgi-bin/surveymost"]
[null,"Labor cost","ENR skilled labor wage",54.82,"October",2016,"$/h","http://www.enr.com/economics"]
[null,"Electricity","US Energy Information Administration",0.10249999999999999,"November",2016,"$/kWh","https://www.eia.gov/electricity/monthly/epm_table_grapher.cfm?t=epmt_5_03"]
[null,"Natural gas","US Energy Information Administration",7.58,"November",2016,"$/1000 ft3","https://www.eia.gov/dnav/ng/ng_pri_sum_dcu_nus_m.htm"]
[null,"Diesel","US Energy Information Administration",2.58,"January",2017,"$/gallon","http://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_m.htm"]
[null,"Gasoline","US Energy Information Administration",2.3490000000000002,"January",2017,"$/gallon","http://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_m.htm"]
[null,"Fuel oil/heating oil","US Energy Information Administration",2.64,"February",2017,"$/gallon","http://www.eia.gov/petroleum/heatingoilpropane/#itn-tabs-2"]
[null,"Kerosene","US Energy Information Administration",1.427,"November",2016,"$/gallon","https://www.eia.gov/dnav/pet/pet_sum_mkt_a_EPJK_PTG_dpgal_m.htm"]
[]
["O&M","Chemicals","Purity (as a decimal)","Density","Normal dose range (mg/L)","Indicative dose (mg/L)","Raw Costs","Median Cost ($ per lb)"]
[null,"Caustic Soda (Sodium Hydroxide)",0.17,"1.69 lb/gal","2-5 mg/L",3.5,"$470-520 per ton (50% liquid Caustic Soda)",0.2475]
[null,"Sodium Hypochlorite Liquid chlorine",0.12,"1.11 g/cm^3","3-10 mg/L",6.5,"$499 per 200L of 12.5%",2.4950000000000001]
[null,"Chlorine Gas",1,null,"3-10 mg/L",6.5,"$190-320 per short ton",0.13]
[null,"Liquid Oxygen (LOX)",1,null,"2 trucks x 6000 gallons",null,"0.176$/liter",0.66615999999999997]
[null,"Liquid Alum Feed  - 50% Solution",8.5000000000000006E-2,"11.2 lb/gal","50-100 mg/L",10,"$549.99 per 600lbs (50% solution)",0.92]
[null,"Dry Alum (coagulation) - 48%",0.17,"40 lb/ft^3","50-100 mg/L",75,"$150-220 per ton  (17% purity)",9.2499999999999999E-2]
[null,"Polymer (Polydyne SE1179 polymer )",1,null,"0.1-1 mg/L",0.55000000000000004,"$1.75/lb. ",1.75]
[null,"Lime",1,null,"20-40 mg/L",30,"$120-250 per tonne ",0.09]
[null,"Sulfuric Acid - 93% Solution (ph control)",0.93,"81.4 lb/ft^3","5-20 mg/L",12.5,"$.64 per lb (93% solution)",0.64]
[null,"Sodium Hydroxide - 50% Solution (ph control)",0.17,"1.69 lb/gal","10-20 mg/L",15,"$470-520 per ton (50% liquid Caustic Soda)",0.2475]
[null,"Ferric Chloride Feed  - 39% Solution",0.39,"11.9 lb/gal","29.40-105.56 mg/L",63.41,"$400 per ton (42%)",0.2]
[null,"Powdered Activated Carbon",1,null,"7-30 mg/L",10,"$.92 per lb",0.92]
[null,"Fluoride",0.3,"87.5 lb/cf","1 mg/L",1,"$1130 per ton(33.535%)",0.56499999999999995]
[null,"Phosphate(Phosphoric Acid)",0.75,"13.1 lb/gal","3.54-5.5 mg/L",1.96,"$600-1500 per metric ton (75%)",0.47727000000000003]
[null,"Anhydrous Ammonia Feed",1,null,"0.5-1 mg/L",0.75,"$1,128 per dry ton",0.56399999999999995]
[null,"Aqua Ammonia Feed - 29%",0.28999999999999998,"Vapor Density (Air=1): 0.6 @ 0°C","0.5-1 mg/L",0.75,"210-430 per ton (2228%)",0.16]
[null,"Ammonia (chloramines)",1,null,"0.5-2 mg/L",1,"$180-240 per ton",0.105]
[null,"Chlorine Dioxide",1,null,"1 mg/L  (Sodium Chlorite() + Chlorine())",1,"Chlorine$190-320 per short ton, Sodium Chlorite $1.47-1.65 per lb",1.6875]
[null,"Potassium Permanganate - 100%",1,null,"5-10 mg/L",7.5,"$7.85/kg",3.56]
[null,"Conditioning of sludge prior to dewatering Polymer",1,null,"3-8 lb/ton",5.5,"$1.75/lb. ",1.75]
[null,"Sodium Chloride - 100%",1,null,"5.5-7.2 lb NaCl/cubic foot of resin",null,"$65-175/ton",0.06]
[null,"PreTreatment w/ Coagulant Addition (Alum)",1,null,"0-20 mg/L",10,"$549.99 per 600lbs",0.92]
[null,"PreTreatment w/ Coagulant Addition (Polymer Alum)",1,null,"0-20 mg/L",10,"$549.99 per 600lbs",1.92]
[null,"Dry Alum Feed (coagulation) ",0.17,"40 lb/ft^3","50-100 mg/L",75,"$150-220 per ton  (17% purity)",9.2499999999999999E-2]
[null,"Liquid Alum Feed  - 50% Solution ",8.5000000000000006E-2,"11.2 lb/gal","50-100 mg/L",10,"$549.99 per 600lbs (50% solution)",0.92]
[null,"Antiscalant - 100%",1,null,"3-5 ppm(mg/L) ",4,"$4,500-5,000 per ton",2.25]
[null,"Sodium hydroxide - 30%",0.17,"1.69 lb/gal","8mg/L",8,"$470-520 per ton (50% liquid Caustic Soda)",0.2475]
[null,"Citric Acid  - 50%",0.5,null,"1-3 mg/L",2,"$800-1000 per ton",0.45]
[null,"GAC (Granular Activated Carbon)",1,null,"40,000 lb/6 months/Vessel",null,"$1.40 per pound",1.4]
[null,"Hydrogen peroxide (H2O2)",0.5,null,"2-3mg/L",2,"2.27-5.50 per gallon",{"$f":"3.5/8.35","v":0.41916167664670662}]

{"sheet":"WSO 4","index":5,"n_rows":107,"n_cols":10,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
["USER INPUTS "]
[null,"Water supply option name","WSO 4"]
[]
[null,"State","CA"]
[null,"Postcode"]
[null,"Processes part of new or existing plant? ","New"]
[null,"Proposed new plant capacity or expansion yield (1-200 MGD)"]
[null,"Plant flow rate (as % plant capacity)"]
[]
["Number","Process","Units",null,null,null,null,null,"Chemical Name ","Quantity used (lb per day)"]
[1,"Chlorine storage and feed 150# cylinder storage","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Caustic Soda (Sodium Hydroxide)"]
[{"$f":"A11+1","v":2},"Chlorine storage and feed 1-ton cylinder storage","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Sodium Hypochlorite Liquid chlorine"]
[{"$f":"A12+1","v":3},"On-site storage tank with rail delivery","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Chlorine Gas"]
[4,"Direct feed from rail car","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Liquid Oxygen (LOX)"]
[5,"Ozone Generation","Ozone Gener.Cap.-Lb/d",null,null,null,null,null,"Liquid Alum Feed  - 50% Solution"]
[6,"Liquid Alum Feed - 50% Solution","Liquid Feed cap.- Gal/h",null,null,null,null,null,"Dry Alum (coagulation) - 48%"]
[7,"Dry Alum Feed","Dry Alum. Feed- Lb/h",null,null,null,null,null,"Polymer (Polydyne SE1179 polymer )"]
[8,"Polymer Feed","Polymer Feed-Lb/d",null,null,null,null,null,"Lime"]
[9,"Lime Feed","Lime Feed- Lb/d",null,null,null,null,null,"Sulfuric Acid - 93% Solution (ph control)"]
[10,"Potassium Permanganate Feed","Dry KMNO4 Feed-Lb/d",null,null,null,null,null,"Sodium Hydroxide - 50% Solution (ph control)"]
[11,"Sulfuric Acid Feed - 93% Solution","Sulfuric  Acid (93%)Feed-Gal/d",null,null,null,null,null,"Ferric Chloride Feed  - 39% Solution"]
[12,"Sodium Hydroxide Feed - 50% Solution","Liquid Sodium Feed -gal/d",null,null,null,null,null,"Powdered Activated Carbon"]
[13,"Ferric Chloride Feed - 42% Solution","Dry Ferric Sulf. Feed-Lb/d",null,null,null,null,null,"Fluoride"]
[14,"Anhydrous Ammonia Feed - 29% Solution","Ammonia Feed - Lb/d",null,null,null,null,null,"Phosphate(Phosphoric Acid)"]
[15,"Aqua Ammonia Feed","Ammonia Feed - Gal/d",null,null,null,null,null,"Anhydrous Ammonia Feed"]
[16,"Powdered Activated Carbon","Carbon Feed - Lb/h",null,null,null,null,null,"Aqua Ammonia Feed - 29%"]
[17,"Rapid Mix G=300","Basin Volume - GAL",null,null,null,null,null,"Ammonia (chloramines)"]
[18,"Rapid Mix G=600","Basin Volume - GAL",null,null,null,null,null,"Chlorine Dioxide"]
[19,"Rapid Mix G=900","Basin Volume -GAL",null,null,null,null,null,"Potassium Permanganate - 100%"]
[20,"Flocculator G=20","Basin Volume - MG",null,null,null,null,null,"Conditioning of sludge prior to dewatering Polymer"]
[21,"Flocculator G=50","Basin Volume - MG",null,null,null,null,null,"Sodium Chloride - 100%"]
[22,"Flocculator G=80","Basin Volume - MG",null,null,null,null,null,"PreTreatment w/ Coagulant Addition (Alum)"]
[23,"Circular Clarifier","Basin Area - SF",null,null,null,null,null,"PreTreatment w/ Coagulant Addition (Polymer Alum)"]
[24,"Rectangular Clarifier","Basin Area - SF",null,null,null,null,null,"Dry Alum Feed (coagulation) "]
[25,"Gravity Filter Structure","Filter Area - SF",null,null,null,null,null,"Liquid Alum Feed  - 50% Solution "]
[26,"Filtration Media - Stratified Sand","Filter Media Area -SF",null,null,null,null,null,"Antiscalant - 100%"]
[27,"Filtration Media - Dual Media","Filter Media Area -SF",null,null,null,null,null,"Sodium hydroxide - 30%"]
[28,"Filtration Media - Tri-Media","Filter Media Area - SF",null,null,null,null,null,"Citric Acid  - 50%"]
[29,"Filter Backwash Pumping","Filter Surface Area -SF",null,null,null,null,null,"GAC (Granular Activated Carbon)"]
[30,"Surface Wash System","Filter area -SF",null,null,null,null,null,"Hydrogen peroxide - 50%"]
[31,"Air Scour Wash","Filter area -SF"]
[32,"Finished Water Pumping  TDH =30ft","Plant capacity (mgd)"]
[33,"Finished Water Pumping  TDH =100ft","Plant capacity (mgd)"]
[34,"Raw water pumping TDH = 30ft","Plant capacity (mgd)"]
[35,"Raw water pumping TDH = 100ft","Plant capacity (mgd)"]
[36,"In-plant pumping TDH = 35ft","Plant capacity (mgd)"]
[37,"In-plant pumping TDH = 75ft","Plant capacity (mgd)"]
[{"$f":"A47+1","v":38},"Gravity Sludge Thickener","Thickener Diameter-FT"]
[39,"Sludge Dewatering lagoons","Storage Volume -MG"]
[40,"Sand Drying Beds"," Bed Area-SF"]
[41,"Filter Press"," Filter Press Vol. - GAL"]
[{"$f":"A51+1","v":42},"Belt Filter Press","Machine Capacity - GAL/h"]
[{"$f":"A52+1","v":43},"Ion exchange - pressure ion exchange softening","Plant Capacity MGD"]
[44,"Ion exchange - gravity ion exchange softening","Plant Capacity MGD"]
[45,"Ion exchange - pressure ion exchange nitrate removal","Plant Capacity MGD"]
[{"$f":"A58+1","v":47},"Sodium hypochlorite/chlorination","hypochlorite generation rate (Lb/day)"]
[48,"Chlorine dioxide","chlorine dioxide feed capacity (Lb/day)"]
[{"$f":"A55+1","v":46},"Administration, Laboratory, and Maintenance Building","Plant Capacity MGD"]
[{"$f":"A57+1","v":49},"Two-stage filtration","System Capacity - MGD"]
[50,"Direct filtration","System Capacity - MGD"]
[51,"Conventional treatment (standard WTP)","System Capacity - MGD"]
[52,"Dissolved air flotation (standard WTP)","System Capacity - MGD"]
[53,"Lime & soda ash (standard WTP)","System Capacity - MGD"]
[54,"Iron manganese removal (standard WTP)","System Capacity - MGD"]
[55,"Micro-membrane (standard WTP)","System Capacity - MGD"]
[56,"Direct filtration w/pre-ozone (standard WTP)","System Capacity - MGD"]
[57,"Conventional treatment w/ ozone and GAC (standard WTP)","System Capacity - MGD"]
[58,"MSF - (Diesel-powered)","System Capacity - MGD"]
[59,"MSF (Gas-powered)","System Capacity - MGD"]
[60,"MSF (50% gas, 50% diesel)","System Capacity - MGD"]
[61,"SWRO (WTP)","System Capacity - MGD"]
[62,"BWRO (WTP)","System Capacity - MGD"]
[63,"Ozone ","System Capacity - MGD"]
[64,"Ozone + H2O2","System Capacity - MGD"]
[65,"UV advanced oxidation (UV/H2O2)","System Capacity - MGD"]
[66,"MF/UF","System Capacity - MGD"]
[67,"NF/RO","System Capacity - MGD"]
[68,"BAC - 10min EBCT","System Capacity - MGD"]
[69,"BAC - 20min EBCT","System Capacity - MGD"]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Static head (vertical lift required)","ft"]
[null,"Estimated total head loss (sum of all major + minor losses)","ft"]
[null,"Flow capacity (by default this is equal to the proposed capacity - only change if you need a stronger/weaker pump)","MGD"]
[null,"Pump efficiency (deault = 0.6, only change if you know the efficiency rating of the pump)","unitless (0-1) "]
[]
[null,"Solids/residuals disposal (Used to estimate fuel and cost)"]
[null,"Estimated residuals mass","lb wet residual mass per day"]
[null,"Average truckload weight capacity","pounds (lb)"]
[null,"Average distance to disposal site per day","miles"]
[]
[null,"Option to enter own costs (enter only if known for each of the WSO options being considered - keep zeros if you would prefer the model to estimate based on default cost curves)","Calendar year ","defaults"]
[null,"CAPEX (total construction and non-construction costs)","$"]
[null,"Plant service life (years)","years"]
[null,"Annual interest rate","percentage"]
[null,"Annual O&M","$"]
[]
[null,"Onsite vs. grid electricity use"]
[null,"Electricity purchased from grid","%"]
[null,"Electricity from onsite solar PV system","% "]
[]
[null,"Additional onsite fuel use from vehicles excluding residuals disposal (leave as zeros if not relevant)"]
[null,"Auto gasoline / petrol","gallons per year"]
[null,"Automotive diesel oil","gallons per year"]
[null,"Fuel oil / heating oil ","gallons per year"]
[null,"Natural gas","cubic feet (1000s)"]
[null,"Aviation fuel / kerosene","gallons per year"]

{"sheet":"WSO 5","index":6,"n_rows":107,"n_cols":10,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
["USER INPUTS "]
[null,"Water supply option name","WSO 5"]
[]
[null,"State","CA"]
[null,"Postcode"]
[null,"Processes part of new or existing plant? ","New"]
[null,"Proposed new plant capacity or expansion yield (1-200 MGD)"]
[null,"Plant flow rate (as % plant capacity)"]
[]
["Number","Process","Units",null,null,null,null,null,"Chemical Name ","Quantity used (lb per day)"]
[1,"Chlorine storage and feed 150# cylinder storage","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Caustic Soda (Sodium Hydroxide)"]
[{"$f":"A11+1","v":2},"Chlorine storage and feed 1-ton cylinder storage","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Sodium Hypochlorite Liquid chlorine"]
[{"$f":"A12+1","v":3},"On-site storage tank with rail delivery","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Chlorine Gas"]
[4,"Direct feed from rail car","Chlorine feed cap.-Lb/d",null,null,null,null,null,"Liquid Oxygen (LOX)"]
[5,"Ozone Generation","Ozone Gener.Cap.-Lb/d",null,null,null,null,null,"Liquid Alum Feed  - 50% Solution"]
[6,"Liquid Alum Feed - 50% Solution","Liquid Feed cap.- Gal/h",null,null,null,null,null,"Dry Alum (coagulation) - 48%"]
[7,"Dry Alum Feed","Dry Alum. Feed- Lb/h",null,null,null,null,null,"Polymer (Polydyne SE1179 polymer )"]
[8,"Polymer Feed","Polymer Feed-Lb/d",null,null,null,null,null,"Lime"]
[9,"Lime Feed","Lime Feed- Lb/d",null,null,null,null,null,"Sulfuric Acid - 93% Solution (ph control)"]
[10,"Potassium Permanganate Feed","Dry KMNO4 Feed-Lb/d",null,null,null,null,null,"Sodium Hydroxide - 50% Solution (ph control)"]
[11,"Sulfuric Acid Feed - 93% Solution","Sulfuric  Acid (93%)Feed-Gal/d",null,null,null,null,null,"Ferric Chloride Feed  - 39% Solution"]
[12,"Sodium Hydroxide Feed - 50% Solution","Liquid Sodium Feed -gal/d",null,null,null,null,null,"Powdered Activated Carbon"]
[13,"Ferric Chloride Feed - 42% Solution","Dry Ferric Sulf. Feed-Lb/d",null,null,null,null,null,"Fluoride"]
[14,"Anhydrous Ammonia Feed - 29% Solution","Ammonia Feed - Lb/d",null,null,null,null,null,"Phosphate(Phosphoric Acid)"]
[15,"Aqua Ammonia Feed","Ammonia Feed - Gal/d",null,null,null,null,null,"Anhydrous Ammonia Feed"]
[16,"Powdered Activated Carbon","Carbon Feed - Lb/h",null,null,null,null,null,"Aqua Ammonia Feed - 29%"]
[17,"Rapid Mix G=300","Basin Volume - GAL",null,null,null,null,null,"Ammonia (chloramines)"]
[18,"Rapid Mix G=600","Basin Volume - GAL",null,null,null,null,null,"Chlorine Dioxide"]
[19,"Rapid Mix G=900","Basin Volume -GAL",null,null,null,null,null,"Potassium Permanganate - 100%"]
[20,"Flocculator G=20","Basin Volume - MG",null,null,null,null,null,"Conditioning of sludge prior to dewatering Polymer"]
[21,"Flocculator G=50","Basin Volume - MG",null,null,null,null,null,"Sodium Chloride - 100%"]
[22,"Flocculator G=80","Basin Volume - MG",null,null,null,null,null,"PreTreatment w/ Coagulant Addition (Alum)"]
[23,"Circular Clarifier","Basin Area - SF",null,null,null,null,null,"PreTreatment w/ Coagulant Addition (Polymer Alum)"]
[24,"Rectangular Clarifier","Basin Area - SF",null,null,null,null,null,"Dry Alum Feed (coagulation) "]
[25,"Gravity Filter Structure","Filter Area - SF",null,null,null,null,null,"Liquid Alum Feed  - 50% Solution "]
[26,"Filtration Media - Stratified Sand","Filter Media Area -SF",null,null,null,null,null,"Antiscalant - 100%"]
[27,"Filtration Media - Dual Media","Filter Media Area -SF",null,null,null,null,null,"Sodium hydroxide - 30%"]
[28,"Filtration Media - Tri-Media","Filter Media Area - SF",null,null,null,null,null,"Citric Acid  - 50%"]
[29,"Filter Backwash Pumping","Filter Surface Area -SF",null,null,null,null,null,"GAC (Granular Activated Carbon)"]
[30,"Surface Wash System","Filter area -SF",null,null,null,null,null,"Hydrogen peroxide - 50%"]
[31,"Air Scour Wash","Filter area -SF"]
[32,"Finished Water Pumping  TDH =30ft","Plant capacity (mgd)"]
[33,"Finished Water Pumping  TDH =100ft","Plant capacity (mgd)"]
[34,"Raw water pumping TDH = 30ft","Plant capacity (mgd)"]
[35,"Raw water pumping TDH = 100ft","Plant capacity (mgd)"]
[36,"In-plant pumping TDH = 35ft","Plant capacity (mgd)"]
[37,"In-plant pumping TDH = 75ft","Plant capacity (mgd)"]
[{"$f":"A47+1","v":38},"Gravity Sludge Thickener","Thickener Diameter-FT"]
[39,"Sludge Dewatering lagoons","Storage Volume -MG"]
[40,"Sand Drying Beds"," Bed Area-SF"]
[41,"Filter Press"," Filter Press Vol. - GAL"]
[{"$f":"A51+1","v":42},"Belt Filter Press","Machine Capacity - GAL/h"]
[{"$f":"A52+1","v":43},"Ion exchange - pressure ion exchange softening","Plant Capacity MGD"]
[44,"Ion exchange - gravity ion exchange softening","Plant Capacity MGD"]
[45,"Ion exchange - pressure ion exchange nitrate removal","Plant Capacity MGD"]
[{"$f":"A58+1","v":47},"Sodium hypochlorite/chlorination","hypochlorite generation rate (Lb/day)"]
[48,"Chlorine dioxide","chlorine dioxide feed capacity (Lb/day)"]
[{"$f":"A55+1","v":46},"Administration, Laboratory, and Maintenance Building","Plant Capacity MGD"]
[{"$f":"A57+1","v":49},"Two-stage filtration","System Capacity - MGD"]
[50,"Direct filtration","System Capacity - MGD"]
[51,"Conventional treatment (standard WTP)","System Capacity - MGD"]
[52,"Dissolved air flotation (standard WTP)","System Capacity - MGD"]
[53,"Lime & soda ash (standard WTP)","System Capacity - MGD"]
[54,"Iron manganese removal (standard WTP)","System Capacity - MGD"]
[55,"Micro-membrane (standard WTP)","System Capacity - MGD"]
[56,"Direct filtration w/pre-ozone (standard WTP)","System Capacity - MGD"]
[57,"Conventional treatment w/ ozone and GAC (standard WTP)","System Capacity - MGD"]
[58,"MSF - (Diesel-powered)","System Capacity - MGD"]
[59,"MSF (Gas-powered)","System Capacity - MGD"]
[60,"MSF (50% gas, 50% diesel)","System Capacity - MGD"]
[61,"SWRO (WTP)","System Capacity - MGD"]
[62,"BWRO (WTP)","System Capacity - MGD"]
[63,"Ozone ","System Capacity - MGD"]
[64,"Ozone + H2O2","System Capacity - MGD"]
[65,"UV advanced oxidation (UV/H2O2)","System Capacity - MGD"]
[66,"MF/UF","System Capacity - MGD"]
[67,"NF/RO","System Capacity - MGD"]
[68,"BAC - 10min EBCT","System Capacity - MGD"]
[69,"BAC - 20min EBCT","System Capacity - MGD"]
[]
[null,"Conveyance (Used to estimate energy and cost)"]
[null,"Static head (vertical lift required)","ft"]
[null,"Estimated total head loss (sum of all major + minor losses)","ft"]
[null,"Flow capacity (by default this is equal to the proposed capacity - only change if you need a stronger/weaker pump)","MGD"]
[null,"Pump efficiency (deault = 0.6, only change if you know the efficiency rating of the pump)","unitless (0-1) "]
[]
[null,"Solids/residuals disposal (Used to estimate fuel and cost)"]
[null,"Estimated residuals mass","lb wet residual mass per day"]
[null,"Average truckload weight capacity","pounds (lb)"]
[null,"Average distance to disposal site per day (round trip)","miles"]
[]
[null,"Option to enter own costs (enter only if known for each of the WSO options being considered - keep zeros if you would prefer the model to estimate based on default cost curves)","Calendar year ","defaults"]
[null,"CAPEX (total construction and non-construction costs)","$"]
[null,"Plant service life (years)","years"]
[null,"Annual interest rate","percentage"]
[null,"Annual O&M","$"]
[]
[null,"Onsite vs. grid electricity use"]
[null,"Electricity purchased from grid","%"]
[null,"Electricity from onsite solar PV system","% "]
[]
[null,"Additional onsite fuel use from vehicles excluding residuals disposal (leave blank if not relevant)"]
[null,"Auto gasoline / petrol","gallons per year"]
[null,"Automotive diesel oil","gallons per year"]
[null,"Fuel oil / heating oil ","gallons per year"]
[null,"Natural gas","cubic feet (1000s)"]
[null,"Aviation fuel / kerosene","gallons per year"]

{"sheet":"Detailed results","index":7,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,10,0],[11,0,12,0],[13,0,26,0],[27,0,35,0]]}
["Type","Criterion","WSO1","WSO2","WSO3"]
["MATLAB CRITERIA - USED IN THE MCDA (see Criteria_Matrix 1 and 2)","Lifecycle cost to utility per unit of water produced",{"$f":"[2]!WRRF_WaterSET_US_Matlab_version1_0('WSO 1'!C5,'WSO 1'!C7,'WSO 1'!C8,'WSO 1'!D17:D90,'WSO 1'!E17:E90,'WSO 1'!C95:C124,'WSO 1'!D95:D124,'WSO 1'!D130:D131,'WSO 1'!D134:E138,'WSO 1'!C141:C146,'WSO 1'!D141:F146,'WSO 1'!D148,'WSO 1'!D152:D153,'WSO 1'!D156:E160,'WSO 1'!C163:C168,'WSO 1'!D163:F168,'WSO 1'!D175:D178,'WSO 1'!D182,'WSO 1'!D183,'WSO 1'!D184:D187,'WSO 1'!D190,'WSO 1'!D193:D194,'WSO 1'!D197:D201,'Indices + Universal Variables'!D2:D18,'Indices + Universal Variables'!H21:H50,'Indices + Universal Variables'!C21:C50)","v":{"$error":"#NAME?"}},{"$f":"[2]!WRRF_WaterSET_US_Matlab_version1_0('WSO 2'!C5,'WSO 2'!C7,'WSO 2'!C8,'WSO 2'!D17:D90,'WSO 2'!E17:E90,'WSO 2'!C95:C124,'WSO 2'!D95:D124,'WSO 2'!D130:D131,'WSO 2'!D134:E138,'WSO 2'!C141:C146,'WSO 2'!D141:F146,'WSO 2'!D148,'WSO 2'!D152:D153,'WSO 2'!D156:E160,'WSO 2'!C163:C168,'WSO 2'!D163:F168,'WSO 2'!D175:D178,'WSO 2'!D182,'WSO 2'!D183,'WSO 2'!D184:D187,'WSO 2'!D190,'WSO 2'!D193:D194,'WSO 2'!D197:D201,'Indices + Universal Variables'!D2:D18,'Indices + Universal Variables'!H21:H50,'Indices + Universal Variables'!C21:C50)","v":{"$error":"#NAME?"}},{"$f":"[2]!WRRF_WaterSET_US_Matlab_version1_0('WSO 3'!C5,'WSO 3'!C7,'WSO 3'!C8,'WSO 3'!D17:D90,'WSO 3'!E17:E90,'WSO 3'!C95:C124,'WSO 3'!D95:D124,'WSO 3'!D130:D131,'WSO 3'!D134:E138,'WSO 3'!C141:C146,'WSO 3'!D141:F146,'WSO 3'!D148,'WSO 3'!D152:D153,'WSO 3'!D156:E160,'WSO 3'!C163:C168,'WSO 3'!D163:F168,'WSO 3'!D175:D178,'WSO 3'!D182,'WSO 3'!D183,'WSO 3'!D184:D187,'WSO 3'!D190,'WSO 3'!D193:D194,'WSO 3'!D197:D201,'Indices + Universal Variables'!D2:D18,'Indices + Universal Variables'!H21:H50,'Indices + Universal Variables'!C21:C50)","v":{"$error":"#NAME?"}},"Model estimates"]
[null,"U.S. resident income per unit of water produced",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Variable cost percentage to capture the financial flexibility of the WSO",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Cost of imported capital and annual O&M goods as percent of capital cost and annual O&M cost, respectively",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Carbon footprint in tons of Equivalent Carbon Dioxide per unit of water produced",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Water footprint in units of water required to produce a unit of water",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Eutrophication potential – kg N equivalent- Effect of WSO construction and operation on pollution of ecosystems per unit of water produced",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Ecotoxicity potential – kg DCB equivalent- Effect of WSO construction and operation on pollution of ecosystems per unit of water produced",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"National jobs created during construction and operation of the WSO per unit of water produced",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Effect of potential pollution caused by the WSO on human health",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
["ENERGY (kWh)","Annual plant electricity requirements (kWh)",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Annual conveyance electricity (kWh)",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
["ANNUAL CAPEX ESTIMATES                                      (in 2012 USD)","Sitework",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Equipment",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Concrete",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Steel",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Pipes & valves",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Instrumentation",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Housing",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Yard piping",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Landscaping",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Site Electrical",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Engineering Legal",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"PVC pipe (conveyance)",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Ductile Iron (conveyance)",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Labour",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
["ANNUAL O&M ESTIMATES                                      (in 2012 USD)","Electricity",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Natural Gas",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Diesel",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Maintenance",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Inorganic chemicals",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Chlorine & alkalies",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Organic chemicals",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Black carbon",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]
[null,"Labour",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"Model estimates"]

{"sheet":"Criteria_Matrix","index":8,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,3,34,5],[35,3,35,5],[36,3,36,5],[4,7,4,9],[3,3,3,5],[32,2,32,5],[33,3,33,5]]}
["CRITERIA MATRIX & WEIGHTS "]
[null,"*Click grey square to right for more info about adding new criteria"]
[]
[null,null,null,"Functional unit = 1000 gallons supplied"]
[null,null,null,null,null,null,null,"WATER SUPPLY OPTIONS UNDER CONSIDERATION"]
[]
["Category","Criterion (click square buttons below for detailed description)","Description","Unit","Qualitative (L) or Quantitative (T)","Positive or Negative","Weight",{"$f":"'WSO 1'!C2","v":"WSO 1"},{"$f":"'WSO 2'!C2","v":"WSO 2"},{"$f":"'WSO 3'!C2","v":"WSO 3"}]
["Economic criteria – WSO Cost and Production","Lifecycle cost","Lifecycle cost to utility per unit of water produced","$","T","Neg",null,{"$f":"'Detailed results'!C2","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D2","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E2","v":{"$error":"#NAME?"}}]
["Economic criteria – WSO Cost and Production","Amount of water produced","Average annual amount of water produced","MGD","T","Pos"]
["Economic criteria – WSO Cost and Production","Outside capital cost %","Percent of capital cost to be paid by outside entities","%","T","Pos"]
["Economic criteria – Resident income","Resident income ","U.S. resident income per unit of water produced","$","T","Pos",null,{"$f":"'Detailed results'!C3","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D3","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E3","v":{"$error":"#NAME?"}}]
["Economic criteria – Additional Considerations","Variable cost %","Variable cost percentage to capture the financial flexibility of the WSO","%","T","Pos",null,{"$f":"'Detailed results'!C4","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D4","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E4","v":{"$error":"#NAME?"}}]
["Economic criteria – Additional Considerations","Cost of imports %","Cost of imported capital and annual O&M goods as percent of capital cost and annual O&M cost, respectively","%","T","Neg",null,{"$f":"'Detailed results'!C5","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D5","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E5","v":{"$error":"#NAME?"}}]
["Environmental criteria – Carbon and Water Footprints","Carbon footprint","Carbon footprint in tons of Equivalent Carbon Dioxide per unit of water produced","kg CO2-e","T","Neg",null,{"$f":"'Detailed results'!C6","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D6","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E6","v":{"$error":"#NAME?"}}]
["Environmental criteria – Carbon and Water Footprints","Water footprint","Water footprint in units of water required to produce a unit of water","gallons","T","Neg",null,{"$f":"'Detailed results'!C7","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D7","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E7","v":{"$error":"#NAME?"}}]
["Environmental criteria – Ecosystems and Land Footprint","Eutrophication potential","Eutrophication potential – kg N equivalent- Effect of WSO construction and operation on pollution of ecosystems per unit of water produced","kg N equivalent","T","Neg",null,{"$f":"'Detailed results'!C8","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D8","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E8","v":{"$error":"#NAME?"}}]
["Environmental criteria – Ecosystems and Land Footprint","Ecotoxicity potential","Ecotoxicity potential – kg DCB equivalent- Effect of WSO construction and operation on pollution of ecosystems per unit of water produced","kg DCB equivalent","T","Neg",null,{"$f":"'Detailed results'!C9","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D9","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E9","v":{"$error":"#NAME?"}}]
["Environmental criteria – Ecosystems and Land Footprint","Land footprint","Land footprint per unit of water produced","hectares","T","Neg"]
["Environmental criteria – Ecosystems and Land Footprint","Impact of residuals","Impact of residuals disposal and/or brine management (cost)","$","T","Neg"]
["Social criteria – Jobs and Human Health","National jobs created","National jobs created during construction and operation of the WSO per unit of water produced","Number of FTE jobs","T","Pos",null,{"$f":"'Detailed results'!C10","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D10","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E10","v":{"$error":"#NAME?"}}]
["Social criteria – Jobs and Human Health","Effect on human health ","Effect of potential pollution caused by the WSO on human health","HTP","T","Neg",null,{"$f":"'Detailed results'!C11","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!D11","v":{"$error":"#NAME?"}},{"$f":"'Detailed results'!E11","v":{"$error":"#NAME?"}}]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Drought Resilience ","Resilience of the WSO to drought","0 to 4 points","L","Pos"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Potential Public Acceptance","Potential Public Acceptance (Budget or time)","$ or hours","T","Neg"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Further Social Benefits","Other perceived social benefits","0 to 11 points","L","Pos"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Implementation Risk","Risk ","0 to 4 points","L","Pos"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Pollution Impacts","Pollution (not considered elsewhere)","1 to 10 points","L","Neg"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Waste Disposal Impacts","Waste disposal impacts (e.g brine or sludge)","1 to 10 points","L","Neg"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Construction Impacts","Construction impacts (not considered elsewhere)","1 to 10 points","L","Neg"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Operational Impacts","Operational impacts (not considered elsewhere)","1 to 10 points","L","Neg"]
["Other criteria - Optional additional criterion 1",null,null,null,null,null,null,null,null,null,"Optional input"]
["Other criteria - Optional additional criterion 2",null,null,null,null,null,null,null,null,null,"Optional input"]
[]
[null,null,"The sum of the user-defined weights should sum to 100. "]
[null,null,null,"Sum of the Weights",null,null,{"$f":"SUM(G8:G29)","v":0}]
[null,null,null,"Sum of Economic Criteria Weight",null,null,{"$f":"SUM(G8:G13)","v":0}]
[null,null,null,"Sum of Environmental Criteria Weight",null,null,{"$f":"SUM(G14:G19)","v":0}]
[null,null,null,"Sum of Social and Other Criteria Weight",null,null,{"$f":"SUM(G21:G31)","v":0}]

{"sheet":"SD","index":9,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["STANDARD DEVIATIONS"]
[]
["Category","Criterion"]
["Economic criteria – WSO Cost and Production","Lifecycle cost"]
["Economic criteria – Resident income (Impact of WSO construction and operation on:)","Resident income "]
["Economic criteria – Additional Considerations","Variable cost %"]
["Economic criteria – Additional Considerations","Cost of imports %"]
["Environmental criteria – Carbon and Water Footprints","Carbon footprint"]
["Environmental criteria – Carbon and Water Footprints","Water footprint"]
["Environmental criteria – Ecosystems and Land Footprint","Eutrophication potential"]
["Environmental criteria – Ecosystems and Land Footprint","Ecotoxicity potential"]
["Social criteria – Jobs and Human Health","National jobs created"]
["Social criteria – Jobs and Human Health","Effect on human health "]

{"sheet":"Radar Chart","index":10,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["RADAR CHART (Normalized)",null,null,null,null,"* The higher the number, the more favourable the alternative."]
[]
[]
["Criterion (click square buttons below for detailed description)"]
["Lifecycle cost"]
["Resident income "]
["Variable cost %"]
["Cost of imports %"]
["Carbon footprint"]
["Water footprint"]
["Eutrophication potential"]
["Ecotoxicity potential"]
["National jobs created"]
["Effect on human health "]

{"sheet":"MCDA_Criteria Matrix","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["MCDA RESULTS",null,null,"The EVAMIX method is used in this MCDA. The higher the number, the more favourable the alternative."]
[null,null,null,"For more details on the EVAMIX method, please refer to the user manual."]
["WSO","EVAMIX Score"]
[{"$f":"Criteria_Matrix!H7","v":"WSO 1"}]
[{"$f":"Criteria_Matrix!I7","v":"WSO 2"}]
[{"$f":"Criteria_Matrix!J7","v":"WSO 3"}]
[]
[null,"WSO Name","EVAMIX Score"]
["Most Favorable Option",{"$f":"IF($C$9=$B$4,$A$4,IF($C$9=$B$5,$A$5,IF($C$9=$B$6,$A$6,\"\")))","v":"WSO 1"},{"$f":"MAX(B4:B6)","v":0}]
["Least Favorable Option",{"$f":"IF($C$10=$B$4,$A$4,IF($C$10=$B$5,$A$5,IF($C$10=$B$6,$A$6,\"\")))","v":"WSO 1"},{"$f":"MIN(B4:B6)","v":0}]

{"sheet":"Criteria Descriptions","index":12,"n_rows":297,"n_cols":3,"rows_kept":297,"cut":false,"hidden":false,"merged":[[79,1,80,9],[3,1,5,9],[10,1,11,9],[16,1,18,9],[23,1,24,9],[29,1,31,9],[36,1,38,9],[43,1,45,9],[50,1,53,9],[58,1,61,9],[66,1,68,9],[73,1,74,9],[151,1,154,9],[85,1,87,9],[97,1,99,9],[104,1,105,9],[108,1,114,9],[117,1,121,9],[123,2,125,9],[127,2,128,9],[130,2,131,9],[133,2,134,9],[136,2,137,9],[144,1,148,9],[180,1,181,7],[156,1,157,9],[162,1,163,9],[166,1,169,9],[171,1,172,9],[173,1,173,7],[174,1,174,7],[175,1,175,7],[176,1,176,7],[177,1,177,7],[178,1,178,7],[179,1,179,7],[249,1,251,9],[182,1,182,7],[183,1,183,7],[191,1,199,9],[202,1,206,9],[208,2,210,9],[212,2,214,9],[216,2,218,9],[220,2,222,9],[224,2,226,9],[238,1,240,9],[243,1,244,9],[291,1,294,9],[296,1,297,9],[254,1,255,9],[260,1,262,9],[265,1,266,9],[271,1,273,8],[276,1,277,9],[285,1,287,9]]}
["1)","Life Cycle Cost"]
[]
[null,"Description:"]
[null,"Present value of costs over useful life of the water supply option divided by the amount of water produced. Included costs include capital costs, operation and maintenance costs, replacement and refurbishment costs, and salvage value over the water supply option's useful life. "]
[]
[]
[]
["2)","Amount of Water Produced"]
[]
[null,"Description:"]
[null,"The average annual amount of water produced. Values for this criterion are directly inputted by the user. "]
[]
[]
["3)","Outside Capital Cost %"]
[]
[null,"Description:"]
[null,"Percent of capital cost to be paid by outside entities. This indicator measures the extent to which cost is shared with others thus reducing financial impact to customers. Values for this criterion are directly inputted by the user. "]
[]
[]
[]
["4)","Resident Income"]
[]
[null,"Description:"]
[null,"U.S. resident income per unit of water produced, including wages, salaries, proprietor income, and profit. This indicator represents the contribution of the water supply option to national income. "]
[]
[]
["5)","Variable Cost %"]
[]
[null,"Description:"]
[null,"The percent of the annualized capital and operation/maintenance cost that is variable cost. Variable cost examples include costs associated with chemicals and energy, as they tend to be a function of demand. "]
[]
[]
[]
["6)","Cost of Imports %"]
[]
[null,"Description:"]
[null,"The cost of imported capital and annual operation/maintenance goods as a percent of total capital and annual operation/maintenance cost. The criterion measures the reliance on goods imported from other countries. "]
[]
[]
[]
["7)","Carbon Footprint"]
[]
[null,"Description:"]
[null,"The total amount of greenhouse gas emissions during construction and useful life of the water supply option. This criterion is measured in tons of equivalent carbon dioxide per unit of water produced. "]
[]
[]
[]
["8)","Water Footprint"]
[]
[null,"Description:"]
[null,"The water footprint is the total amoutn of water needed to produce potable water during construction and life of the water supply option. This criterion does not include the amount of water produced by the water supply option. The water footprint is often also referred to as the \"embodied water content\"."]
[]
[]
[]
[]
["9)","Eutrophication Footprint"]
[]
[null,"Description:"]
[null,"A criterion designed to measure the effect of the water supply option construction and operatin on pollution of ecosystems per unit of water produced. This criterion is communicated in units of equivalent kilograms of nitrogen (a nutrient that contributes to eutrophic conditions in water bodies). "]
[]
[]
[]
[]
["10)","Ecotoxicity Footprint"]
[]
[null,"Description:"]
[null,"A criterion designed to measure the effect of the water supply option construction and operation on pollution of ecosystems per unit of water produced. This criterion is communicated in units of equivalent kilograms of dichlorobenzene (DCB, a toxic chemical)."]
[]
[]
[]
["11)","Land Footprint"]
[]
[null,"Description:"]
[null,"The acres of land used for the water supply option site per unit of water produced. Values for this criterion are directly inputted by the user. "]
[]
[]
["12)","Impact of Residuals"]
[]
[null,"Description:"]
[null,"The cost impacts of residuals disposal and/or brine management. Values for this criterion are directly inputted by the user. "]
[]
[]
["13)","National Jobs Created"]
[]
[null,"Description:"]
[null,"This criterion estimates the number of full-time equivalent jobs created over the construction and life of the water supply option divided by the amount of water produced over the life of the water supply option. "]
[]
[]
[]
[]
[]
[]
[]
[]
["14)","Effect on Human Health"]
[]
[null,"Description:"]
[null,"A criterion designed to measure the effect of the water supply option construction and operation on human health per unit of water produced. This criterion is communicated in units of equivalent kilograms of dichlorobenzene (DCB, a toxic chemical)."]
[]
[]
[]
["15)","Drought Resilience"]
[]
[null,"Description:"]
[null,"This indicator measures the impact of the option on the frequency and extent of water shortages and the extent to which the option facilitates a drought-proof water utility."]
[]
[]
[null,"Note regarding drought resilience and water reuse:"]
[null,"Because the amount of reclaimed water available is based on the amount of potable water used, a direct potable reuse project would not always be drought-proof on its own.  This is because potable water use can vary depending on the need for increased irrigation caused by drought and the utility’s response to water shortages through water pricing and water use restrictions. All of these impacts could reduce the amount of reclaimed water available. However, its use in conjunction with other water supply sources and demand management programs could significantly reduce the impact of weather and climate on water supply."]
[]
[]
[]
[]
[]
[]
[]
[null,"Scoring:"]
[null,"Estimate the amount of water that would be produced from the water supply option during drought conditions relative to the amount that could be produced from the water supply option during years of \"average\" precipitation. Define drought as that which occurs under a one-in-ten precipitation year which is the lowest precipitation that statistically occurs on the average of once during a ten-year period. Scoring can be done as follows:"]
[]
[]
[]
[]
[]
[null,"0 Points =","During drought conditions, the water supply option can produce (or save in the case of water conservation/leak detection) no more than 25% of average year expected water production (or savings)"]
[]
[]
[]
[null,"1 Point =","During drought conditions, the water supply option can produce (or save) from 26% to 50% of average year expected water production (or savings)"]
[]
[]
[null,"2 Points =","During drought conditions, the water supply option can produce (or save) from 51% to 75% of average year expected water production (or savings)"]
[]
[]
[null,"3 Points =","During drought conditions, the water supply option can produce (or save) from 76% to 99% of average year expected water production (or savings)"]
[]
[]
[null,"4 Points =","During drought conditions, the water supply option can produce (or save) more than 99% of average year expected water production (or savings)"]
[]
[]
[]
[]
["16)","Potential Public Acceptance"]
[]
[null,"Description:"]
[null,"Public acceptance of a water supply option can be changed through education and outreach - this has been proven to be true regarding the introduction of a new water supply. This criterion measures the extent to which the utility will need to provide public education and outreach in order to obtain public consensus that the option is an acceptable method of providing the community with potable water. "]
[]
[]
[]
[]
[]
[null,"Scoring:"]
[null,"The TBL tool allows for two measures of potential public acceptance. The first measure is the estimated budget ($) to provide the public education and outreach needed to obtain sufficient public support for developing this water supply option. The estimated budget should include the cost of utility personnel, materials, services, and the contracting of private firms as needed. "]
[]
[]
[]
[]
[null,"The second measure is the number of months that it is expected to take to obtain sufficient public support using the budgeted public education and outreach efforts. "]
[]
[]
["17)","Further Social Benefits"]
[]
[null,"Description:"]
[null,"This criterion measures the social benefits provided by the water supply option in addition to its value in providing a water supply. "]
[]
[]
[null,"Scoring:"]
[null,"This criterion is measured by counting the number of benefits listed below that are created by or directly result from the water supply option. In the \"Inputs\" tabs, users have the ability to indicate whether or not each individual benefit should be counted for the given water supply option (11 potential further social benefits in total). "]
[]
[]
[]
[]
[null,"a. The water supply option provides the utility and the community with full control of its water supply through regulations, investments and/or agreements."]
[]
[null,"b. The water supply option provides a needed means of wastewater effluent disposal. "]
[null,"c. The water supply option improves recreational quality or increases recreational opportunities."]
[null,"d. The water supply option improves flood control capabilities within the community. "]
[null,"e. The water supply option directly increases the efficiency of water use. "]
[null,"f. The water supply option controls saltwater intrusion. "]
[null,"g. The water supply option will directly facilitate increases tourism in the regional area. "]
[null,"h. The water supply option will reduce soil subsidence and/or improve subsidence management."]
[null,"i. The water supply option will provide resilience from sea level rise and/or natural disasters such as earthquakes, tornadoes, tsunamis, and hurricanes."]
[]
[null,"j. The water supply option will contribute to a net nutrient balance."]
[null,"k. The water supply option will create a natural habitat on previously damaged land."]
[]
[]
[]
[]
["18)","Implementation Risk"]
[]
[null,"Description:"]
[null,"This criterion measures the degree to which the water supply option can be built and operated successfully in the study area. This criterion includes evaluation of the technologic track record of the option that considers whether the technology or program has been successfully implemented elsewhere. Knowing that a technology or program has been successfully implemented elsewhere in a similar application not only demonstrates its viability, it also provides information regarding the extent to which the technology or program can be customized to site-specific conditions. This criterion also considers the extent to which studies have demonstrated the likelihood of the Option's success. The evaluators are asked to consider issues specific to the Option including, for example, siting issues, waste disposal issues, recovery issues, and technology issues."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scoring:"]
[null,"There are four aspects to consider when scoring this criterion: 1) whether a technology and/or program has been implemented in other similar situations; 2) whether the technology or program was successful; 3) whether studies have shown that it is likely to be successful under this application, and 4) whether or not there are specific unresolved issues that may hinder the success of the Option. The scoring for this criterion is as follows:"]
[]
[]
[]
[]
[]
[null,"0 Points =","The technology or program has not been successfully implemented elsewhere in similar applications and the technology / program is not likely (< 50% probability) to be successful under this application."]
[]
[]
[]
[null,"1 Point =","The technology or program has not been successfully implemented elsewhere in similar applications but studies have shown that it is likely (> 50% probability) to be successful under this application."]
[]
[]
[]
[null,"2 Points =","The technology or program has been successfully implemented elsewhere in similar application but further study is needed to assess one or more specific unresolved issues that may hinder the success of the Option."]
[]
[]
[]
[null,"3 Points =","The technology or program has been successfully implemented in a relatively small number of similar applications and is likely (> 50% probability) to be successful under this application."]
[]
[]
[]
[null,"4 Points =","The technology or program has been implemented in many similar applications and has demonstrated success and is likely (> 50% probability) to be successful under this application."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["19)","WSO Pollution Impacts"]
[]
[null,"Description:"]
[null,"This criterion measures the expected pollution impacts (negative impacts) of the water supply option. Pollution of local air, land, and/or waterways should be taken into consideration.  Pollution may negatively impact aesthetics and/or cause loss of recreational opportunities. "]
[]
[]
[]
[null,"Scoring:"]
[null,"Values for this criterion should be given on a scale from 1 to 10, with 10 being the worst/highest level of pollution impacts and 1 being the best/lowest level of pollution impacts."]
[]
[]
["20)","WSO Waste Disposal Impacts"]
[]
[null,"Description:"]
[null,"This criterion measures the expected waste disposal impacts (negative impacts) of the water supply option. Consider impact of waste disposal on local amenities, including aesthetic impacts of landfills and waste transport. "]
[]
[]
[]
[null,"Scoring:"]
[null,"Values for this criterion should be given on a scale from 1 to 10, with 10 being the worst/highest level of waste disposal impacts and 1 being the best/lowest level of waste disposal impacts"]
[]
[]
["21)","WSO Construction Impacts"]
[]
[null,"Description:"]
[null,"This criterion measures the expected construction impacts (negative impacts) of the water supply option. Consider impacts of construction on local amenities, including noise, odor, traffic congestion, and road closures."]
[]
[]
[]
[null,"Scoring:"]
[null,"Values for this criterion should be given on a scale from 1 to 10, with 10 being the worst/highest level of construction impacts and 1 being the best/lowest level of construction impacts"]
[]
[]
["22)","WSO Operational Impacts"]
[]
[null,"Description:"]
[null,"This criterion measures the expected operational impacts (negative impacts) of the water supply option. Consider impacts of operating this water supply option on local amenities, including noise, odor, and commuting/transportation."]
[]
[]
[]
[null,"Scoring:"]
[null,"Values for this criterion should be given on a scale from 1 to 10, with 10 being the worst/highest level of operational impacts and 1 being the best/lowest level of operational impacts."]
[]
[]
[]
[]
[]
["Adding New Criteria"]
[]
[null,"Description:"]
[null,"Please review the list of criteria provided in the \"Criteria_Matrix\" tabs. If you would like to add additional criteria to this WSO comparison, please select the \"Add Criteria\" button and provide the following information:"]
[]
[]
[]
[null,"*Criterion name (e.g., Brine Impacts)"]
[null,"*Criterion classification as qualitative or quantitative"]
[null,"*Whether the criterion is positively or negatively correlated with benefit; if a high value for the criterion is seen as desirable, then then criterion is positively correlated with benefit (e.g., amount of water produced); if a high value for the criterion is seen as undesirable, then the criterion is negatively correlated with benefit (e.g., capital cost)"]
[]
[]
[]
[]
[null,"After adding the new criterion, please indicate an associated weighting (i.e., measure of importance ranging from 0 to 10) for the criterion and then assign an associated score to each WSO. "]

{"sheet":"(Hide-lists)","index":13,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["*hide this sheet"]
["US States","Year","New or Existing","AU States","Pipe material","Purple pipe","Dosage units","Defaults"]
["AL",1980,"New","ACT","PVC","Yes","mg/L","defaults"]
["AK",1981,"Existing","NSW","Ductile Iron","No","lb/day","own_costs_pre2016"]
["AZ",1982,null,"NT",null,null,null,"own costs _current"]
["AR",1983,null,"QLD"]
["CA",1984,null,"SA"]
["CO",1985,null,"TAS"]
["CT",1986,null,"VIC"]
["DE",1987,null,"WA"]
["FL",1988]
["GA",1989]
["HI",1990]
["ID",1991]
["IL",1992]
["IN",1993]
["IA",1994]
["KS",1995]
["KY",1996]
["LA",1997]
["ME",1998]
["MD",1999]
["MA",2000]
["MI",2001]
["MN",2002]
["MS",2003]
["MO",2004]
["MT",2005]
["NE",2006]
["NV",2007]
["NH",2008]
["NJ",2009]
["NM",2010]
["NY",2011]
["NC",2012]
["ND",2013]
["OH",2014]
["OK",2015]
["OR",2016]
["PA",2017]
["RI",2018]
["SC"]
["SD"]
["TN"]
["TX"]
["UT"]
["VT"]
["VA"]
["WA"]
["WV"]
["WI"]
["WY"]

{"sheet":"(Hide-contents)","index":14,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["INDICATORS",null,null,null,null,null,null,null,null,null,null,"Standard Deviation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard deviations for the results for your choice of water supply options"]
[null,null,null,null,null,null,null,null,null,null,null,"Category","Criterion"]
[null,null,null,null,null,null,null,null,null,null,null,"Economic criteria – WSO Cost and Production","Lifecycle cost"]
[null,null,null,null,null,null,null,null,null,null,null,"Economic criteria – Resident income (Impact of WSO construction and operation on:)","Resident income "]
[null,null,null,null,null,null,null,"Results for your choice of water supply options",null,null,null,"Economic criteria – Additional Considerations","Variable cost %"]
["Category","Criterion","Description","Unit","Qualitative (L) or Quantitative (T)","Positive or Negative","Weight",null,null,null,null,"Economic criteria – Additional Considerations","Cost of imports %"]
["Economic criteria – WSO Cost and Production","Lifecycle cost","Lifecycle cost to utility per unit of water produced","$","T","Neg",null,null,null,null,null,"Environmental criteria – Carbon and Water Footprints","Carbon footprint"]
["Economic criteria – WSO Cost and Production","Amount of water produced","Average annual amount of water produced","MGD","T","Pos",null,null,null,null,null,"Environmental criteria – Carbon and Water Footprints","Water footprint"]
["Economic criteria – WSO Cost and Production","Outside capital cost %","Percent of capital cost to be paid by outside entities","%","T","Pos",null,null,null,null,null,"Environmental criteria – Ecosystems and Land Footprint","Eutrophication potential"]
["Economic criteria – Resident income\n\n(Impact of WSO construction and operation on:)","Resident income ","U.S. resident income per unit of water produced","$","T","Pos",null,null,null,null,null,"Environmental criteria – Ecosystems and Land Footprint","Ecotoxicity potential"]
["Economic criteria – Additional Considerations","Variable cost %","Variable cost percentage to capture the financial flexibility of the WSO","%","T","Pos",null,null,null,null,null,"Social criteria – Jobs and Human Health","National jobs created"]
["Economic criteria – Additional Considerations","Cost of imports %","Cost of imported capital and annual O&M goods as percent of capital cost and annual O&M cost, respectively","%","T","Neg",null,null,null,null,null,"Social criteria – Jobs and Human Health","Effect on human health "]
["Environmental criteria – Carbon and Water Footprints","Carbon footprint","Carbon footprint in tons of Equivalent Carbon Dioxide per unit of water produced","kg CO2-e","T","Neg"]
["Environmental criteria – Carbon and Water Footprints","Water footprint","Water footprint in units of water required to produce a unit of water","m3 ","T","Neg"]
["Environmental criteria – Ecosystems and Land Footprint","Eutrophication potential","Eutrophication potential – kg N equivalent- Effect of WSO construction and operation on pollution of ecosystems per unit of water produced","kg N equivalent","T","Neg"]
["Environmental criteria – Ecosystems and Land Footprint","Ecotoxicity potential","Ecotoxicity potential – kg DCB equivalent- Effect of WSO construction and operation on pollution of ecosystems per unit of water produced","kg DCB equivalent","T","Neg"]
["Environmental criteria – Ecosystems and Land Footprint","Land footprint","Land footprint per unit of water produced","hectares","T","Neg"]
["Environmental criteria – Ecosystems and Land Footprint","Impact of residuals","Impact of residuals disposal and/or brine management (cost)","$","T","Neg"]
["Social criteria – Jobs and Human Health","National jobs created","National jobs created during construction and operation of the WSO per unit of water produced","Number of FTE jobs","T","Pos"]
["Social criteria – Jobs and Human Health","Effect on human health ","Effect of potential pollution caused by the WSO on human health","HTP","T","Neg"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Drought Resilience ",null,"1-10 Likert","L","Pos"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Potential Public Acceptance","Potential Public Acceptance (Budget or time)","$ or hours","T","Neg"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Further Social Benefits",null,"1-10 Likert","L","Pos"]
["Social criteria – Water Shortage, Public Acceptance, Benefits List, Risk","Implementation Risk",null,"1-10 Likert","L","Pos"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Pollution Impacts",null,"1-10 Likert","L","Neg"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Waste Disposal Impacts",null,"1-10 Likert","L","Neg"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Construction Impacts",null,"1-10 Likert","L","Neg"]
["Social criteria – Local impacts of WSO Construction and Operation\n\n(Impact of WSO on Local Amenities – Measurements and Values Provided by User)","WSO Operational Impacts",null,"1-10 Likert","L","Neg"]