{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["MainMenu","Technologies Intro","Chlorination","RoughingFilter","C&F","Sedimentation","RSF","UserInterface","Matrix","Requirements of Technology","Quality Standard","Evaluation","Data","Recommendation","VendorQuestions","Costs"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":1,"defined_names":38,"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":"MainMenu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Technologies Intro","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Chlorination","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"RoughingFilter","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"C&F","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sedimentation","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"RSF","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"UserInterface","index":7,"n_rows":123,"n_cols":12,"rows_kept":123,"cut":false,"hidden":true,"merged":[[120,9,120,12],[121,9,121,12],[122,9,122,12],[53,8,53,9],[79,8,79,9],[104,9,104,12],[105,9,105,12],[106,9,106,12],[89,5,89,8],[90,5,90,8],[91,5,91,8],[92,5,92,8],[93,5,93,8],[94,5,94,8],[95,5,95,8],[96,5,96,8],[118,3,118,5],[118,7,118,8],[48,8,48,9],[49,8,49,9],[108,9,108,12],[60,8,60,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[81,8,81,12],[57,4,57,5],[58,4,58,5],[53,4,53,5],[97,5,97,8],[0,0,0,13],[5,3,5,8],[6,3,6,8],[7,3,7,8],[8,3,8,8],[98,5,98,8],[9,3,9,8],[54,8,54,9],[55,8,55,9],[56,8,56,9],[31,8,31,9],[54,4,54,5],[55,4,55,5],[56,4,56,5]]}
["Water Treatment Technology Selection Guide"]
[]
[]
[null,"Who Are You?"]
[]
[null,"Name:",null,"Bart Simpson"]
[null,"Occupation / Designation:"]
[null,"Country:"]
[null,"State:"]
[null,"City:",null,"Springfield"]
[]
[]
[]
[]
[null,"Improving Your Water"]
[]
[null,"How many people will this system need to serve on a daily basis? -------------------------------------------------",null,null,null,null,null,null,6000,"people"]
[null,"How much water does one person approximately use daily? (typical: 150litres/day) ----------------------------",null,null,null,null,null,null,150,"litres/day"]
[]
[null,"What is your source of raw water? ----------------------------------------------------------------------------------------",null,null,null,null,null,null,"Stream"]
[null,"How much water can be collected from this source per day? ---------------------------------------------------------",null,null,null,null,null,null,1000000,"litres/day"]
[null,"How does the volume of the raw water change with the weather (e.g. storm, dry season, etc.)"]
[null,"Dry Season -----------------------",40,"%"]
[null,"Normal Weather -------------------",100,"%"]
[null,"Wet Season ----------------------",150,"%"]
[]
[]
[]
[]
[null,"Quality of Current Water Source"]
[]
[null,"How does your water look like? (Pick one picture that best represents the turbidity level) --------------------",null,null,null,null,null,null,"Picture 2 -  25 NTU"]
[]
[null,"Picture 1\n(10 NTU)","Picture 2\n(25 NTU)",null,"Picture 3\n(50 NTU)",null,"Picture 4\n(100 NTU)",null,"Picture 5\n(250 NTU)"]
[]
[]
[null,"Alternatively, please enter the turbidity value of the source water if you have prior sampling results -------------",null,null,null,null,null,null,null,"NTU"]
[]
[null,"Does your water smell (Yes/No)? ---------------------------------------",null,null,null,"No"]
[null,"Does your water taste bad (Yes/No)? ----------------------------------",null,null,null,"No"]
[null,"What color is your water? ------------------------------------------------",null,null,null,"Cloudy-white"]
[null,"Does your water contain algae (Yes/No)? -----------------------------",null,null,null,"No"]
[]
[null,"Do you have sampling or quality information for your water source? (e.g. from a laboratory) --------------------",null,null,null,null,null,null,"Yes"]
[]
[null,"If Yes, please indicate below the levels where data is available."]
[]
[null,"General",null,null,null,null,null,null,"Inorganics"]
[null,"Total Organic Carbon -----------------------",null,10,"mg/L",null,null,null,"Antimony --------------------",null,null,"mg/L"]
[null,"pH (1-14) -------------------------------------",null,7,null,null,null,null,"Arsenic -----------------------",null,null,"mg/L"]
[null,null,null,null,null,null,null,null,"Beryllium --------------------",null,null,"mg/L"]
[null,null,null,null,null,null,null,null,"Cadmium --------------------",null,null,"mg/L"]
[null,null,null,null,null,null,null,null,"Total Chromium ------------",null,null,"mg/L"]
[null,"Biological Contaminants",null,"Present","Concentration",null,null,null,"Cyanide ----------------------",null,null,"mg/L"]
[null,"Protozoa: Cryptosporidium ----------------",null,"Yes",1E-4,null,"Organisms/liter",null,"Mercury ----------------------",null,null,"mg/L"]
[null,"Bacteria: Total Coliform -------------------",null,"Yes",2.2000000000000001E-4,null,"Organisms/liter",null,"Selenium ---------------------",null,null,"mg/L"]
[null,"Virus: Rotavirus -----------------------------",null,"Yes",1.2999999999999999E-4,null,"Organisms/liter"]
[null,null,null,null,null,null,null,null,"Secondary Contaminants"]
[null,null,null,null,null,null,null,null,"Iron ----------------------------",null,null,"mg/L"]
[null,null,null,null,null,null,null,null,"Manganese -------------------",null,null,"mg/L"]
[]
[]
[]
[]
[]
[null,"Desired Water Quality"]
[]
[null,"Are you aware of the required standards for drinking water in your country (Yes/No)? ---------------------------",null,null,null,null,null,null,"No"]
[]
[null,"If Yes, please indicate below the required levels of treatment where data is available."]
[]
[null,"General",null,null,null,null,null,null,"Inorganics"]
[null,"Turbidity",null,null,"NTU",null,null,null,"Cadmium --------------------",null,null,"mg/L"]
[null,"Total Organic Carbon",null,null,"mg/L",null,null,null,"Total Chromium ------------",null,null,"mg/L"]
[null,"pH (1-14)",null,null,null,null,null,null,"Mercury ----------------------",null,null,"mg/L"]
[null,null,null,null,null,null,null,null,"Selenium ---------------------",null,null,"mg/L"]
[null,"Biological Contaminants"]
[null,"Protozoa: Cryptosporidium",null,null,"Organisms/Liter"]
[null,"Bacteria: Total Coliform",null,null,"Organisms/Liter"]
[null,"Virus: Rotavirus",null,null,"Organisms/Liter"]
[]
[null,"If No, please select which of the following treatment standards you will like the treatment to meet? ------------",null,null,null,null,null,null,"World Health Organization (WHO)"]
[]
[]
[]
[]
[null,"Resources Available"]
[]
[null,"Please indicate the ease of access for the following resources:"]
[null,"i) Chlorine: Tablet, or Liquids (NaOCl, Ca(OCl)2, HOCl) -----------------",null,null,null,"Yes - Can be obtained within Community"]
[null,"ii) Poly Aluminium Chloride (PACl) --------------------------------------",null,null,null,"No  - Cannot be obtained easily"]
[null,"iii) Aluminium Sulphate ---------------------------------------------------",null,null,null,"No  - Cannot be obtained easily"]
[null,"iv) Ferric Chloride ----------------------------------------------------------",null,null,null,"No  - Cannot be obtained easily"]
[null,"v) Sand -----------------------------------------------------------------------",null,null,null,"Yes - Can be obtained within Community"]
[null,"vi) Gravel --------------------------------------------------------------------",null,null,null,"Yes - Can be obtained within Community"]
[null,"vii) Cement ------------------------------------------------------------------",null,null,null,"Yes - Can be obtained within Community"]
[null,"viii) Bricks --------------------------------------------------------------------",null,null,null,"Yes - Can be obtained within Community"]
[null,"ix) PVC Pipings --------------------------------------------------------------",null,null,null,"Yes - Can be obtained within Community"]
[null,"x) Float Valves --------------------------------------------------------------",null,null,null,"Yes - Can be obtained within Community"]
[]
[null,"Is electrical supply available at the proposed site location? --------",null,null,null,"Yes"]
[]
[null,"Can you rate the skill level of the following workers in your community: (0 to 5, 0 = No Skill Workers Available, 5 = Advanced Skills)"]
[]
[null,"i) Masons -----------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,"1 - Basic Skills"]
[null,"ii) Carpenters ------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,3]
[null,"iii) Metal Workers -------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,"5 - Expert Skills"]
[]
[null,"Can you rate the technical ability of operators who will operate the proposed water treatment system: -----------------------------",null,null,null,null,null,null,null,2]
[null,"(1 to 5, 1 = Basic Skills, 5 = Advanced Engineering Skills)"]
[]
[]
[]
[]
[null,"Community Info"]
[]
[null,"Are there any strong objections within the community pertaining to the use of any of these technologies?"]
[]
[null,"None",null,"None",null,null,null,"None"]
[]
[null,"How important is the taste of water (1 to 4, 1 = Not Important, 5 = Extremely Important) ------------------------------------------------",null,null,null,null,null,null,null,3]
[null,"How important is the smell of water (1 to 4, 1 = Not Important, 5 = Extremely Important) -----------------------------------------------",null,null,null,null,null,null,null,4]
[null,"How important is the appearance of water (1 to 4, 1 = Not Important, 5 = Extremely Important) ----------------------------------------",null,null,null,null,null,null,null,4]

{"sheet":"Matrix","index":8,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["Category","User Interface Data","Unit","Boolean/Scale Interpretation","Weighted Score","Option 1:\nChlorination","Option 2:\nStacked Rapid Sand Filtration + Chlorination","Option 3:\nRoughing Filter + Stacked Rapid Sand Filtration + Chlorination","Option 4:\nCoagulation + Flocculation + Stacked Rapid Sand Filtration + Chlorination","Option 5:\nCoagulation + Flocculation + Sedimentation + Chlorination","Option 6:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration + Chlorination","Option 7: Stacked Rapid Sand Filtration","Option 8: Roughing Filter + Stacked Rapid Sand Filtration","Option 9: Coagulation + Flocculation + Stacked Rapid Sand Filtration","Option 10: Coagulation + Flocculation + Sedimentation","Option 11:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration"]
["Raw Water Source"]
["Volume of Water Required",{"$f":"UserInterface!I17*UserInterface!I18","v":900000},"litres/day",{"$f":"B3","v":900000}]
["Volume Collected (Normal)",{"$f":"UserInterface!I21","v":1000000},"litres/day",{"$f":"B4","v":1000000}]
["Volume Collected (Dry Season)",{"$f":"UserInterface!C23/100*UserInterface!I21","v":400000},"litres/day",400000]
["Volume Collected (Wet Season)",{"$f":"UserInterface!C25/100*UserInterface!I21","v":1500000},"litres/day",1500000]
[]
["Water Quality"]
["Turbidity",{"$f":"IF(LEFT(UserInterface!I32,7)=\"Picture\",VALUE(MID(UserInterface!I32,13,3)),UserInterface!I37)","v":25},"NTU",{"$f":"IF(B9>0,1,0)","v":1},100,0,1,1,1,1,1,1,1,1,1,1]
["Algae",{"$f":"UserInterface!F42","v":"No"},"Boolean",{"$f":"IF(B10=\"Yes\",1,0)","v":0},{"$f":"D10*25","v":0},0,1,1,0,1,1,1,1,1,1,1]
[]
["Sampling vs. Treatment Ability",{"$f":"UserInterface!I44","v":"Yes"},"Boolean",{"$f":"IF(B12=\"Yes\",1,0)","v":1}]
["TOC",{"$f":"UserInterface!D49","v":10},"mg/L",{"$f":"IF(B13>0,$D$12*1,0)","v":1}]
["pH",{"$f":"UserInterface!D50","v":7},"pH Scale",{"$f":"IF(B14>0,$D$12*1,0)","v":1}]
["Protozoa: Cryptosporidium",{"$f":"IF(AND(UserInterface!D55=\"Yes\",UserInterface!E55>0),UserInterface!E55,IF(AND(UserInterface!D55=\"Yes\",UserInterface!E55=\"\"),1,0))","v":1E-4},"Organisms/L",1,{"$f":"IF(NOT(D12),25,25*D15)","v":25},1,1,1,1,1,1,1,1,1,1,1]
["Bacteria: Total Coliform",{"$f":"IF(AND(UserInterface!D56=\"Yes\",UserInterface!E56>0),UserInterface!E56,IF(AND(UserInterface!D56=\"Yes\",UserInterface!E56=\"\"),1,0))","v":2.2000000000000001E-4},"Organisms/L",1,{"$f":"IF(NOT(D13),25,25*D16)","v":25},1,1,1,1,1,1,1,1,1,1,1]
["Virus: Rotavirus",{"$f":"IF(AND(UserInterface!D57=\"Yes\",UserInterface!E57>0),UserInterface!E57,IF(AND(UserInterface!D57=\"Yes\",UserInterface!E57=\"\"),1,0))","v":1.2999999999999999E-4},"Organisms/L",1,{"$f":"IF(NOT(D15),25,25*D17)","v":25},1,1,1,1,1,1,1,1,1,1,1]
["Iron",{"$f":"UserInterface!K59","v":0},"mg/L",0,25,1,1,1,1,1,1,0,0,1,1,1]
["Manganese",{"$f":"UserInterface!K60","v":0},"mg/L",0,25,1,1,1,1,1,1,0,0,1,1,1]
["Antimony",{"$f":"UserInterface!K49","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
["Arsenic",{"$f":"UserInterface!K50","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
["Beryllium",{"$f":"UserInterface!K51","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
["Cadmium",{"$f":"UserInterface!K52","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
["Total Chromium",{"$f":"UserInterface!K53","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
["Cyanide",{"$f":"UserInterface!K54","v":0},"mg/L",0,25,1,1,1,1,1,1,0,0,0,0,0]
["Mercury",{"$f":"UserInterface!K55","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
["Selenium",{"$f":"UserInterface!K56","v":0},"mg/L",0,25,0,0,0,0,1,1,0,0,1,1,1]
[]
["Meeting Standards",{"$f":"UserInterface!I68","v":"No"},"Boolean",{"$f":"IF(B29=\"Yes\", 2, IF(UserInterface!I82=\"World Health Organization (WHO)\", 0, IF(UserInterface!I82=\"United States Environmental Protection Agency (US-EPA)\",1,0)))","v":0},"(0 - WHO Standards, 1 - USEPA Standards, 2 - Local Standards)"]
["Turbidity",{"$f":"UserInterface!D73","v":0},"NTU",{"$f":"IF(AND($D$29=1,B30>0),1,IF(AND($D$29=1,B30<=0),0,1))","v":1},200,{"$f":"IF('Quality Standard'!B23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!C23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!D23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!I23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!J23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!K23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L23<=OFFSET('Quality Standard'!$B$2,0,$D$29,1,1),1,0)","v":1}]
["TOC",{"$f":"UserInterface!D74","v":0},"mg/L",1]
["pH",{"$f":"UserInterface!D75","v":0},"pH Scale",1]
["Protozoa: Cryptosporidium",{"$f":"UserInterface!D78","v":0},"Organisms/Liter",1,{"$f":"E15","v":25},{"$f":"IF('Quality Standard'!B24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!C24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!D24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!I24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!J24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!K24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L24<=OFFSET('Quality Standard'!$B$3,0,$D$29,1,1),1,0)","v":1}]
["Bacteria: Total Coliform",{"$f":"UserInterface!D79","v":0},"Organisms/Liter",1,{"$f":"E16","v":25},{"$f":"IF('Quality Standard'!B25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!C25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!D25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!E25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!F25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!G25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!H25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!I25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!J25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!K25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!L25<=OFFSET('Quality Standard'!$B$4,0,$D$29,1,1),1,0)","v":0}]
["Virus: Rotavirus",{"$f":"UserInterface!D80","v":0},"Organisms/Liter",1,{"$f":"E17","v":25},{"$f":"IF('Quality Standard'!B26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!C26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!D26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!I26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!J26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":0},{"$f":"IF('Quality Standard'!K26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L26<=OFFSET('Quality Standard'!$B$5,0,$D$29,1,1),1,0)","v":1}]
["Cadmium",{"$f":"UserInterface!K73","v":0},"mg/L",1,25,{"$f":"IF('Quality Standard'!B27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!C27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!D27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!I27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!J27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!K27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L27<=OFFSET('Quality Standard'!$B$6,0,$D$29,1,1),1,0)","v":1}]
["Total Chromium",{"$f":"UserInterface!K74","v":0},"mg/L",1,25,{"$f":"IF('Quality Standard'!B28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!C28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!D28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!I28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!J28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!K28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L28<=OFFSET('Quality Standard'!$B$7,0,$D$29,1,1),1,0)","v":1}]
["Mercury",{"$f":"UserInterface!K75","v":0},"mg/L",1,25,{"$f":"IF('Quality Standard'!B29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!C29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!D29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!I29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!J29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!K29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L29<=OFFSET('Quality Standard'!$B$8,0,$D$29,1,1),1,0)","v":1}]
["Selenium",{"$f":"UserInterface!K76","v":0},"mg/L",1,25,{"$f":"IF('Quality Standard'!B30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!C30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!D30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!E30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!F30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!G30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!H30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!I30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!J30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!K30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1},{"$f":"IF('Quality Standard'!L30<=OFFSET('Quality Standard'!$B$9,0,$D$29,1,1),1,0)","v":1}]
[]
["Resources"]
["Chlorine",{"$f":"UserInterface!F90","v":"Yes - Can be obtained within Community"},"Scale",{"$f":"IF(B42=\"Yes - Can be obtained within Community\", 4, IF(B42=\"Yes - Can be obtained within 10km from Community\", 3, IF(B42 = \"Yes - Can be obtained > 10km away in Country\", 2,IF(B42 = \"Yes - Can be obtained from other countries\", 1,0))))","v":4},25,{"$f":"IF($D42>='Requirements of Technology'!C3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!D3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!E3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!F3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!G3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!H3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!I3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!J3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!K3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!L3,1,0)","v":1},{"$f":"IF($D42>='Requirements of Technology'!M3,1,0)","v":1}]
["PACl",{"$f":"UserInterface!F91","v":"No  - Cannot be obtained easily"},"Scale",{"$f":"IF(B43=\"Yes - Can be obtained within Community\", 4, IF(B43=\"Yes - Can be obtained within 10km from Community\", 3, IF(B43 = \"Yes - Can be obtained > 10km away in Country\", 2,IF(B43 = \"Yes - Can be obtained from other countries\", 1,0))))","v":0},25,{"$f":"IF($D43>='Requirements of Technology'!C4,1,0)","v":1},{"$f":"IF($D43>='Requirements of Technology'!D4,1,0)","v":1},{"$f":"IF($D43>='Requirements of Technology'!E4,1,0)","v":1},{"$f":"IF($D43>='Requirements of Technology'!F4,1,0)","v":0},{"$f":"IF($D43>='Requirements of Technology'!G4,1,0)","v":0},{"$f":"IF($D43>='Requirements of Technology'!H4,1,0)","v":0},{"$f":"IF($D43>='Requirements of Technology'!I4,1,0)","v":1},{"$f":"IF($D43>='Requirements of Technology'!J4,1,0)","v":1},{"$f":"IF($D43>='Requirements of Technology'!K4,1,0)","v":0},{"$f":"IF($D43>='Requirements of Technology'!L4,1,0)","v":0},{"$f":"IF($D43>='Requirements of Technology'!M4,1,0)","v":0}]
["Alum",{"$f":"UserInterface!F92","v":"No  - Cannot be obtained easily"},"Scale",0,25,{"$f":"IF($D44>='Requirements of Technology'!C5,1,0)","v":1},{"$f":"IF($D44>='Requirements of Technology'!D5,1,0)","v":1},{"$f":"IF($D44>='Requirements of Technology'!E5,1,0)","v":1},{"$f":"IF($D44>='Requirements of Technology'!F5,1,0)","v":0},{"$f":"IF($D44>='Requirements of Technology'!G5,1,0)","v":0},{"$f":"IF($D44>='Requirements of Technology'!H5,1,0)","v":0},{"$f":"IF($D44>='Requirements of Technology'!I5,1,0)","v":1},{"$f":"IF($D44>='Requirements of Technology'!J5,1,0)","v":1},{"$f":"IF($D44>='Requirements of Technology'!K5,1,0)","v":0},{"$f":"IF($D44>='Requirements of Technology'!L5,1,0)","v":0},{"$f":"IF($D44>='Requirements of Technology'!M5,1,0)","v":0}]
["Ferric Chloride",{"$f":"UserInterface!F93","v":"No  - Cannot be obtained easily"},"Scale",0,25,{"$f":"IF($D45>='Requirements of Technology'!C6,1,0)","v":1},{"$f":"IF($D45>='Requirements of Technology'!D6,1,0)","v":1},{"$f":"IF($D45>='Requirements of Technology'!E6,1,0)","v":1},{"$f":"IF($D45>='Requirements of Technology'!F6,1,0)","v":0},{"$f":"IF($D45>='Requirements of Technology'!G6,1,0)","v":0},{"$f":"IF($D45>='Requirements of Technology'!H6,1,0)","v":0},{"$f":"IF($D45>='Requirements of Technology'!I6,1,0)","v":1},{"$f":"IF($D45>='Requirements of Technology'!J6,1,0)","v":1},{"$f":"IF($D45>='Requirements of Technology'!K6,1,0)","v":0},{"$f":"IF($D45>='Requirements of Technology'!L6,1,0)","v":0},{"$f":"IF($D45>='Requirements of Technology'!M6,1,0)","v":0}]
["Sand",{"$f":"UserInterface!F94","v":"Yes - Can be obtained within Community"},"Scale",4,25,{"$f":"IF($D46>='Requirements of Technology'!C7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!D7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!E7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!F7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!G7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!H7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!I7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!J7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!K7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!L7,1,0)","v":1},{"$f":"IF($D46>='Requirements of Technology'!M7,1,0)","v":1}]
["Gravel",{"$f":"UserInterface!F95","v":"Yes - Can be obtained within Community"},"Scale",4,25,{"$f":"IF($D47>='Requirements of Technology'!C8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!D8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!E8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!F8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!G8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!H8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!I8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!J8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!K8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!L8,1,0)","v":1},{"$f":"IF($D47>='Requirements of Technology'!M8,1,0)","v":1}]
["Cement",{"$f":"UserInterface!F96","v":"Yes - Can be obtained within Community"},"Scale",4,25,{"$f":"IF($D48>='Requirements of Technology'!C9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!D9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!E9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!F9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!G9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!H9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!I9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!J9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!K9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!L9,1,0)","v":1},{"$f":"IF($D48>='Requirements of Technology'!M9,1,0)","v":1}]
["Bricks",{"$f":"UserInterface!F97","v":"Yes - Can be obtained within Community"},"Scale",4,25,{"$f":"IF($D49>='Requirements of Technology'!C10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!D10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!E10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!F10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!G10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!H10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!I10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!J10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!K10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!L10,1,0)","v":1},{"$f":"IF($D49>='Requirements of Technology'!M10,1,0)","v":1}]
["PVC Pipings",{"$f":"UserInterface!F98","v":"Yes - Can be obtained within Community"},"Scale",4,25,{"$f":"IF($D50>='Requirements of Technology'!C11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!D11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!E11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!F11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!G11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!H11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!I11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!J11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!K11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!L11,1,0)","v":1},{"$f":"IF($D50>='Requirements of Technology'!M11,1,0)","v":1}]
["Float Valves",{"$f":"UserInterface!F99","v":"Yes - Can be obtained within Community"},"Scale",4,25,{"$f":"IF($D51>='Requirements of Technology'!C12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!D12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!E12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!F12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!G12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!H12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!I12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!J12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!K12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!L12,1,0)","v":1},{"$f":"IF($D51>='Requirements of Technology'!M12,1,0)","v":1}]
["Electrical Supply",{"$f":"UserInterface!F101","v":"Yes"},"Boolean",{"$f":"IF(B52=\"Yes\",1,0)","v":1},25,{"$f":"IF($D52>='Requirements of Technology'!C13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!D13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!E13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!F13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!G13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!H13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!I13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!J13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!K13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!L13,1,0)","v":1},{"$f":"IF($D52>='Requirements of Technology'!M13,1,0)","v":1}]
["Masons Skill Level",{"$f":"UserInterface!J105","v":"1 - Basic Skills"},"Scale",{"$f":"VALUE(LEFT(B53,1))","v":1},25,{"$f":"IF($D53>='Requirements of Technology'!C14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!D14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!E14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!F14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!G14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!H14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!I14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!J14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!K14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!L14,1,0)","v":1},{"$f":"IF($D53>='Requirements of Technology'!M14,1,0)","v":1}]
["Carpenters Skill Level",{"$f":"UserInterface!J106","v":3},"Scale",{"$f":"VALUE(LEFT(B54,1))","v":3},25,{"$f":"IF($D54>='Requirements of Technology'!C15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!D15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!E15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!F15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!G15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!H15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!I15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!J15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!K15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!L15,1,0)","v":1},{"$f":"IF($D54>='Requirements of Technology'!M15,1,0)","v":1}]
["Metal Workers Skill Level",{"$f":"UserInterface!J107","v":"5 - Expert Skills"},"Scale",5,25,{"$f":"IF($D55>='Requirements of Technology'!C16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!D16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!E16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!F16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!G16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!H16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!I16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!J16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!K16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!L16,1,0)","v":1},{"$f":"IF($D55>='Requirements of Technology'!M16,1,0)","v":1}]
["Local Manpower Skill Level",{"$f":"UserInterface!J109","v":2},"Scale",2,25,{"$f":"IF($D56>='Requirements of Technology'!C17,1,0)","v":1},{"$f":"IF($D56>='Requirements of Technology'!D17,1,0)","v":1},{"$f":"IF($D56>='Requirements of Technology'!E17,1,0)","v":1},{"$f":"IF($D56>='Requirements of Technology'!F17,1,0)","v":0},{"$f":"IF($D56>='Requirements of Technology'!G17,1,0)","v":0},{"$f":"IF($D56>='Requirements of Technology'!H17,1,0)","v":0},{"$f":"IF($D56>='Requirements of Technology'!I17,1,0)","v":1},{"$f":"IF($D56>='Requirements of Technology'!J17,1,0)","v":1},{"$f":"IF($D56>='Requirements of Technology'!K17,1,0)","v":0},{"$f":"IF($D56>='Requirements of Technology'!L17,1,0)","v":0},{"$f":"IF($D56>='Requirements of Technology'!M17,1,0)","v":0}]
[]
["Community Preferences"]
["Restriction 1",{"$f":"UserInterface!B119","v":"None"},"Technology",{"$f":"VLOOKUP(B59,Data!$C$15:$D$20,2,FALSE)","v":0},{"$f":"IF(D59>0,50,0)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,3,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,4,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,5,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,6,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,7,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,8,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,9,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,10,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,11,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,12,FALSE)","v":0},{"$f":"VLOOKUP($D59,'Requirements of Technology'!$A$21:$M$26,13,FALSE)","v":0}]
["Restriction 2",{"$f":"UserInterface!D119","v":"None"},"Technology",{"$f":"VLOOKUP(B60,Data!$C$15:$D$20,2,FALSE)","v":0},{"$f":"IF(D60>0,50,0)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,3,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,4,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,5,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,6,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,7,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,8,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,9,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,10,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,11,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,12,FALSE)","v":0},{"$f":"VLOOKUP($D60,'Requirements of Technology'!$A$21:$M$26,13,FALSE)","v":0}]
["Restriction 3",{"$f":"UserInterface!H119","v":"None"},"Technology",{"$f":"VLOOKUP(B61,Data!$C$15:$D$20,2,FALSE)","v":0},{"$f":"IF(D61>0,50,0)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,3,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,4,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,5,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,6,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,7,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,8,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,9,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,10,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,11,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,12,FALSE)","v":0},{"$f":"VLOOKUP($D61,'Requirements of Technology'!$A$21:$M$26,13,FALSE)","v":0}]
["Taste Importance Scale",{"$f":"UserInterface!J121","v":3},"Scale",{"$f":"LEFT(B62,1)","v":"3"},{"$f":"MAX(0,(D62-1))*12.5","v":25},0,0,0,0,0,0,0,0,0,0,0]
["Smell Importance Scale",{"$f":"UserInterface!J122","v":4},"Scale",{"$f":"LEFT(B63,1)","v":"4"},{"$f":"MAX(0,(D63-1))*12.5","v":37.5},0,0,0,0,0,0,0,0,0,0,0]
["Appearance Importance Scale",{"$f":"UserInterface!J123","v":4},"Scale","4",{"$f":"MAX(0,(D64-1))*12.5","v":37.5},0,0,0,1,1,1,0,0,1,1,1]
[]
["Costs"]
["Capital Cost","NIL",null,null,30,0.9,0.75,0.45,0.7,0.4,0.15,{"$f":"G67+3%","v":0.78},{"$f":"H67+3%","v":0.48},0.73,0.43000000000000005,0.18]
["Operating Cost","NIL",null,null,70,1,0.4,0.25,0.3,0.78,0.75,0.45,0.28000000000000003,0.4,0.81,0.78]

{"sheet":"Requirements of Technology","index":9,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,null,"Option 1:\nChlorination","Option 2:\nStacked Rapid Sand Filtration + Chlorination","Option 3:\nRoughing Filter + Stacked Rapid Sand Filtration + Chlorination","Option 4:\nDirect Filtration + Chlorination","Option 5:\nCoagulation + Flocculation + Sedimentation + Chlorination","Option 6:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration + Chlorination","Option 7: Stacked Rapid Sand Filtration","Option 8: Roughing Filter + Stacked Rapid Sand Filtration","Option 9: Coagulation + Flocculation + Stacked Rapid Sand Filtration","Option 10: Coagulation + Flocculation + Sedimentation","Option 11:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration"]
[null,"Resources Requirements"]
[null,"Chlorine",1,1,1,1,1,1,0,0,0,0,0]
[null,"PACl",0,0,0,1,1,1,0,0,1,1,1]
[null,"Alum",0,0,0,1,1,1,0,0,1,1,1]
[null,"Ferric Chloride",0,0,0,1,1,1,0,0,1,1,1]
[null,"Sand",0,1,1,1,1,1,1,1,1,1,1]
[null,"Gravel",0,1,1,1,1,1,1,1,1,1,1]
[null,"Cement",0,1,1,1,1,1,1,1,1,1,1]
[null,"Bricks",0,1,1,1,1,1,1,1,1,1,1]
[null,"PVC Pipings",1,1,1,1,1,1,1,1,1,1,1]
[null,"Float Valves",1,1,1,1,1,1,1,1,1,1,1]
[null,"Electrical Supply",1,1,1,1,1,1,1,1,1,1,1]
[null,"Masons",0,1,1,1,1,1,1,1,1,1,1]
[null,"Carpenters",0,1,1,1,1,1,1,1,1,1,1]
[null,"Metal Workers",0,1,1,1,1,1,1,1,1,1,1]
[null,"Local Manpower Skill Level",1,2,2,3,3,3,2,2,3,3,3]
[null,"Option Total score",{"$f":"SUMPRODUCT(C3:C12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":200},{"$f":"SUMPRODUCT(D3:D12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":300},{"$f":"SUMPRODUCT(E3:E12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":300},{"$f":"SUMPRODUCT(F3:F12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":375},{"$f":"SUMPRODUCT(G3:G12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":375},{"$f":"SUMPRODUCT(H3:H12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":375},{"$f":"SUMPRODUCT(I3:I12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":275},{"$f":"SUMPRODUCT(J3:J12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":275},{"$f":"SUMPRODUCT(K3:K12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":350},{"$f":"SUMPRODUCT(L3:L12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":350},{"$f":"SUMPRODUCT(M3:M12,Matrix!$E$42:$E$51)+SUM(Matrix!$E$52:$E$56)","v":350}]
[]
["Index","Restriction"]
[0,"None",0,0,0,0,0,0,0,0,0,0,0]
[1,"Chlorination",-1,-1,-1,-1,-1,-1,0,0,0,0,0]
[2,"Coagulation",0,0,0,-1,-1,-1,0,0,-1,-1,-1]
[3,"Flocculation",0,0,0,-1,-1,-1,0,0,-1,-1,-1]
[4,"Sedimentation",0,0,0,0,-1,-1,0,0,0,-1,-1]
[5,"Stacked Rapid Sand Filtration",0,-1,-1,-1,0,-1,-1,-1,-1,0,-1]

{"sheet":"Quality Standard","index":10,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,"1 - WHO","2 - US-EPA","3- Local Standards","Units","Unit Treatment Process 1:\nChlorination","Unit Treatment Process 2:\nStacked Rapid Sand Filtration","Unit Treatment Process 3: Coagulation, Floccuation and Sedimentation","Unit Treatment Process 4: Coagulation, Flocculation and Stacked Rapid Sand Filtration","Unit Treatment Process 5: Roughing Filter"]
["Turbidity",5,0.3,{"$f":"UserInterface!D73","v":0},"NTU",0,0.7,{"$f":"AVERAGE(80%,89%)","v":0.84499999999999997},0.97,{"$f":"AVERAGE(60%,90%)","v":0.75}]
["Protozoa: Cryptosporidium",{"$f":"1.3*10^-5","v":1.3000000000000001E-5},0,{"$f":"UserInterface!D78","v":0},"Organisms/Liter",0,0.7,{"$f":"AVERAGE(90%,95%)","v":0.92500000000000004},0.999,{"$f":"AVERAGE(60%,90%)","v":0.75}]
["Bacteria: Total Coliform",0,0,{"$f":"UserInterface!D79","v":0},"Organisms/Liter",0.999,{"$f":"AVERAGE(1%,50%)","v":0.255},{"$f":"AVERAGE(90%,95%)","v":0.92500000000000004},0.96,{"$f":"AVERAGE(93%,99.5%)","v":0.96250000000000002}]
["Virus: Rotavirus",{"$f":"1.1*10^-5","v":1.1000000000000001E-5},0,{"$f":"UserInterface!D80","v":0},"Organisms/Liter",0.999,{"$f":"AVERAGE(1%,50%)","v":0.255},0.92500000000000004,0.874,0]
["Cadmium",3.0000000000000001E-3,5.0000000000000001E-3,{"$f":"UserInterface!K73","v":0},"mg/L",0,0,0.7,0.7,0]
["Total Chromium",0.05,0.1,{"$f":"UserInterface!K74","v":0},"mg/L",0,0,0.9,0.9,0]
["Mercury",6.0000000000000001E-3,2E-3,{"$f":"UserInterface!K75","v":0},"mg/L",0,0,0.7,0.7,0]
["Selenium",0.04,0.05,{"$f":"UserInterface!K76","v":0},"mg/L",0,0,{"$f":"AVERAGE(40%,80%)","v":0.60000000000000009},{"$f":"AVERAGE(40%,80%)","v":0.60000000000000009},0]
[]
[]
["Removal Efficiencies","Option 1:\nChlorination","Option 2:\nStacked Rapid Sand Filtration + Chlorination","Option 3:\nRoughing Filter + Stacked Rapid Sand Filtration + Chlorination","Option 4:\nCoagulation + Flocculation + Stacked Rapid Sand Filtration + Chlorination","Option 5:\nCoagulation + Flocculation + Sedimentation + Chlorination","Option 6:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration + Chlorination","Option 7: Stacked Rapid Sand Filtration","Option 8: Roughing Filter + Stacked Rapid Sand Filtration","Option 9: Coagulation + Flocculation + Stacked Rapid Sand Filtration","Option 10: Coagulation + Flocculation + Sedimentation","Option 11:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration"]
["Turbidity",{"$f":"F2","v":0},{"$f":"100%-(100%-G2)*(100%-F2)","v":0.7},{"$f":"100%-(100%-J2)*(100%-G2)*(100%-F2)","v":0.92500000000000004},{"$f":"100%-(100%-I2)*(100%-F2)","v":0.97},{"$f":"100%-(100%-H2)*(100%-F2)","v":0.84499999999999997},{"$f":"100%-(100%-H2)*(100%-G2)*(100%-F2)","v":0.95350000000000001},{"$f":"G2","v":0.7},{"$f":"100%-(100%-J2)*(100%-G2)","v":0.92500000000000004},{"$f":"I2","v":0.97},{"$f":"H2","v":0.84499999999999997},{"$f":"100%-(100%-H2)*(100%-G2)","v":0.95350000000000001}]
["Protozoa: Cryptosporidium",0,0.7,0.92500000000000004,0.999,0.92500000000000004,0.97750000000000004,{"$f":"G3","v":0.7},{"$f":"100%-(100%-J3)*(100%-G3)","v":0.92500000000000004},{"$f":"I3","v":0.999},{"$f":"H3","v":0.92500000000000004},{"$f":"100%-(100%-H3)*(100%-G3)","v":0.97750000000000004}]
["Bacteria: Total Coliform",0.999,0.999255,0.99997206250000004,0.99995999999999996,0.99992499999999995,0.99994412499999996,0.255,0.97206250000000005,0.96,0.92500000000000004,0.94412499999999999]
["Virus: Rotavirus",0.999,0.999255,0.999255,0.99987400000000004,0.99992499999999995,0.99994412499999996,0.255,0.255,0.874,0.92500000000000004,0.94412499999999999]
["Cadmium",0,0,0,0.7,0.7,0.7,0,0,0.7,0.7,0.7]
["Total Chromium",0,0,0,0.9,0.9,0.9,0,0,0.9,0.9,0.9]
["Mercury",0,0,0,0.7,0.7,0.7,0,0,0.7,0.7,0.7]
["Selenium",0,0,0,0.60000000000000009,0.60000000000000009,0.60000000000000009,0,0,0.60000000000000009,0.60000000000000009,0.60000000000000009]
[]
["Calculated Values from User Inputs","Option 1:\nChlorination","Option 2:\nStacked Rapid Sand Filtration + Chlorination","Option 3:\nRoughing Filter + Stacked Rapid Sand Filtration + Chlorination","Option 4:\nCoagulation + Flocculation + Stacked Rapid Sand Filtration + Chlorination","Option 5:\nCoagulation + Flocculation + Sedimentation + Chlorination","Option 6:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration + Chlorination","Option 7: Stacked Rapid Sand Filtration","Option 8: Roughing Filter + Stacked Rapid Sand Filtration","Option 9: Coagulation + Flocculation + Stacked Rapid Sand Filtration","Option 10: Coagulation + Flocculation + Sedimentation","Option 11:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration"]
["Turbidity",{"$f":"(100%-B13)*Matrix!$B$9","v":25},{"$f":"(100%-C13)*Matrix!$B$9","v":7.5000000000000009},{"$f":"(100%-D13)*Matrix!$B$9","v":1.8749999999999989},{"$f":"(100%-E13)*Matrix!$B$9","v":0.75000000000000067},{"$f":"(100%-F13)*Matrix!$B$9","v":3.8750000000000009},{"$f":"(100%-G13)*Matrix!$B$9","v":1.1624999999999996},{"$f":"(100%-H13)*Matrix!$B$9","v":7.5000000000000009},{"$f":"(100%-I13)*Matrix!$B$9","v":1.8749999999999989},{"$f":"(100%-J13)*Matrix!$B$9","v":0.75000000000000067},{"$f":"(100%-K13)*Matrix!$B$9","v":3.8750000000000009},{"$f":"(100%-L13)*Matrix!$B$9","v":1.1624999999999996}]
["Protozoa: Cryptosporidium",{"$f":"(100%-B14)*Matrix!$B15","v":1E-4},{"$f":"(100%-C14)*Matrix!$B15","v":3.0000000000000008E-5},{"$f":"(100%-D14)*Matrix!$B15","v":7.499999999999996E-6},{"$f":"(100%-E14)*Matrix!$B15","v":1.0000000000000009E-7},{"$f":"(100%-F14)*Matrix!$B15","v":7.499999999999996E-6},{"$f":"(100%-G14)*Matrix!$B15","v":2.2499999999999967E-6},{"$f":"(100%-H14)*Matrix!$B15","v":3.0000000000000008E-5},{"$f":"(100%-I14)*Matrix!$B15","v":7.499999999999996E-6},{"$f":"(100%-J14)*Matrix!$B15","v":1.0000000000000009E-7},{"$f":"(100%-K14)*Matrix!$B15","v":7.499999999999996E-6},{"$f":"(100%-L14)*Matrix!$B15","v":2.2499999999999967E-6}]
["Bacteria: Total Coliform",{"$f":"(100%-B15)*Matrix!$B16","v":2.200000000000002E-7},{"$f":"(100%-C15)*Matrix!$B16","v":1.6389999999999905E-7},{"$f":"(100%-D15)*Matrix!$B16","v":6.1462499999920263E-9},{"$f":"(100%-E15)*Matrix!$B16","v":8.8000000000088006E-9},{"$f":"(100%-F15)*Matrix!$B16","v":1.6500000000010395E-8},{"$f":"(100%-G15)*Matrix!$B16","v":1.2292500000008478E-8},{"$f":"(100%-H15)*Matrix!$B16","v":1.639E-4},{"$f":"(100%-I15)*Matrix!$B16","v":6.1462499999999888E-6},{"$f":"(100%-J15)*Matrix!$B16","v":8.8000000000000089E-6},{"$f":"(100%-K15)*Matrix!$B16","v":1.6499999999999991E-5},{"$f":"(100%-L15)*Matrix!$B16","v":1.2292500000000003E-5}]
["Virus: Rotavirus",{"$f":"(100%-B16)*Matrix!$B17","v":1.3000000000000011E-7},{"$f":"(100%-C16)*Matrix!$B17","v":9.6849999999999428E-8},{"$f":"(100%-D16)*Matrix!$B17","v":9.6849999999999428E-8},{"$f":"(100%-E16)*Matrix!$B17","v":1.6379999999994731E-8},{"$f":"(100%-F16)*Matrix!$B17","v":9.7500000000061423E-9},{"$f":"(100%-G16)*Matrix!$B17","v":7.2637500000050089E-9},{"$f":"(100%-H16)*Matrix!$B17","v":9.6849999999999996E-5},{"$f":"(100%-I16)*Matrix!$B17","v":9.6849999999999996E-5},{"$f":"(100%-J16)*Matrix!$B17","v":1.6379999999999999E-5},{"$f":"(100%-K16)*Matrix!$B17","v":9.749999999999993E-6},{"$f":"(100%-L16)*Matrix!$B17","v":7.2637500000000005E-6}]
["Cadmium",{"$f":"(100%-B17)*Matrix!$B23","v":0},{"$f":"(100%-C17)*Matrix!$B23","v":0},{"$f":"(100%-D17)*Matrix!$B23","v":0},{"$f":"(100%-E17)*Matrix!$B23","v":0},{"$f":"(100%-F17)*Matrix!$B23","v":0},{"$f":"(100%-G17)*Matrix!$B23","v":0},{"$f":"(100%-H17)*Matrix!$B23","v":0},{"$f":"(100%-I17)*Matrix!$B23","v":0},{"$f":"(100%-J17)*Matrix!$B23","v":0},{"$f":"(100%-K17)*Matrix!$B23","v":0},{"$f":"(100%-L17)*Matrix!$B23","v":0}]
["Total Chromium",{"$f":"(100%-B18)*Matrix!$B24","v":0},{"$f":"(100%-C18)*Matrix!$B24","v":0},{"$f":"(100%-D18)*Matrix!$B24","v":0},{"$f":"(100%-E18)*Matrix!$B24","v":0},{"$f":"(100%-F18)*Matrix!$B24","v":0},{"$f":"(100%-G18)*Matrix!$B24","v":0},{"$f":"(100%-H18)*Matrix!$B24","v":0},{"$f":"(100%-I18)*Matrix!$B24","v":0},{"$f":"(100%-J18)*Matrix!$B24","v":0},{"$f":"(100%-K18)*Matrix!$B24","v":0},{"$f":"(100%-L18)*Matrix!$B24","v":0}]
["Mercury",{"$f":"(100%-B19)*Matrix!$B26","v":0},{"$f":"(100%-C19)*Matrix!$B26","v":0},{"$f":"(100%-D19)*Matrix!$B26","v":0},{"$f":"(100%-E19)*Matrix!$B26","v":0},{"$f":"(100%-F19)*Matrix!$B26","v":0},{"$f":"(100%-G19)*Matrix!$B26","v":0},{"$f":"(100%-H19)*Matrix!$B26","v":0},{"$f":"(100%-I19)*Matrix!$B26","v":0},{"$f":"(100%-J19)*Matrix!$B26","v":0},{"$f":"(100%-K19)*Matrix!$B26","v":0},{"$f":"(100%-L19)*Matrix!$B26","v":0}]
["Selenium",{"$f":"(100%-B20)*Matrix!$B27","v":0},{"$f":"(100%-C20)*Matrix!$B27","v":0},{"$f":"(100%-D20)*Matrix!$B27","v":0},{"$f":"(100%-E20)*Matrix!$B27","v":0},{"$f":"(100%-F20)*Matrix!$B27","v":0},{"$f":"(100%-G20)*Matrix!$B27","v":0},{"$f":"(100%-H20)*Matrix!$B27","v":0},{"$f":"(100%-I20)*Matrix!$B27","v":0},{"$f":"(100%-J20)*Matrix!$B27","v":0},{"$f":"(100%-K20)*Matrix!$B27","v":0},{"$f":"(100%-L20)*Matrix!$B27","v":0}]

{"sheet":"Evaluation","index":11,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Score","Option 1:  Chlorination","Option 2:  Stacked Rapid Sand Filtration - Chlorination","Option 3:  Roughing Filter - Stacked Rapid Sand Filtration - Chlorination","Option 4:  Coagulation & Flocculation - Stacked Rapid Sand Filtration - Chlorination","Option 5:  Coagulation & Flocculation - Sedimentation - Chlorination","Option 6:  Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration - Chlorination","Option 7:  Stacked Rapid Sand Filtration","Option 8:  Roughing Filter - Stacked Rapid Sand Filtration","Option 9:  Coagulation & Flocculation - Stacked Rapid Sand Filtration","Option 10: Coagulation & Flocculation - Sedimentation","Option 11: Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration","System Max Score","Weightage (%)"]
["Contaminant Removal Ability Score",{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!F9:F10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!F15:F17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!F18:F27))/$M$2*$N$2","v":3.28125},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!G9:G10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!G15:G17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!G18:G27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!H9:H10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!H15:H17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!H18:H27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!I9:I10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!I15:I17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!I18:I27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!J9:J10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!J15:J17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!J18:J27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!K9:K10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!K15:K17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!K18:K27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!L9:L10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!L15:L17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!L18:L27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!M9:M10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!M15:M17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!M18:M27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!N9:N10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!N15:N17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!N18:N27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!O9:O10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!O15:O17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!O18:O27))/$M$2*$N$2","v":7.65625},{"$f":"(SUMPRODUCT(Matrix!$E$9:$E$10,Matrix!P9:P10)+SUMPRODUCT(Matrix!$E$15:$E$17,Matrix!P15:P17)+SUMPRODUCT(Matrix!$D$18:$D$27,Matrix!$E$18:$E$27,Matrix!P18:P27))/$M$2*$N$2","v":7.65625},{"$f":"Matrix!E9+Matrix!E10+SUM(Matrix!E15:E39)","v":800},35]
["Actual Removal Performance Score",{"$f":"(Matrix!$E$30*Matrix!F30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!F33:F39))/$M$3*$N$3","v":11.666666666666666},{"$f":"(Matrix!$E$30*Matrix!G30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!G33:G39))/$M$3*$N$3","v":11.666666666666666},{"$f":"(Matrix!$E$30*Matrix!H30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!H33:H39))/$M$3*$N$3","v":32.666666666666664},{"$f":"(Matrix!$E$30*Matrix!I30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!I33:I39))/$M$3*$N$3","v":32.666666666666664},{"$f":"(Matrix!$E$30*Matrix!J30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!J33:J39))/$M$3*$N$3","v":32.666666666666664},{"$f":"(Matrix!$E$30*Matrix!K30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!K33:K39))/$M$3*$N$3","v":32.666666666666664},{"$f":"(Matrix!$E$30*Matrix!L30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!L33:L39))/$M$3*$N$3","v":9.3333333333333339},{"$f":"(Matrix!$E$30*Matrix!M30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!M33:M39))/$M$3*$N$3","v":30.333333333333336},{"$f":"(Matrix!$E$30*Matrix!N30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!N33:N39))/$M$3*$N$3","v":30.333333333333336},{"$f":"(Matrix!$E$30*Matrix!O30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!O33:O39))/$M$3*$N$3","v":32.666666666666664},{"$f":"(Matrix!$E$30*Matrix!P30+SUMPRODUCT(Matrix!$E$33:$E$39,Matrix!P33:P39))/$M$3*$N$3","v":32.666666666666664},{"$f":"Matrix!E30+SUM(Matrix!E33:E39)","v":375},35]
["Resources Requirement Score",{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!F42:F51,'Requirements of Technology'!C3:C12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!F52:F56))/'Requirements of Technology'!C18*Evaluation!$N$4","v":10},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!G42:G51,'Requirements of Technology'!D3:D12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!G52:G56))/'Requirements of Technology'!D18*Evaluation!$N$4","v":10},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!H42:H51,'Requirements of Technology'!E3:E12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!H52:H56))/'Requirements of Technology'!E18*Evaluation!$N$4","v":10},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!I42:I51,'Requirements of Technology'!F3:F12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!I52:I56))/'Requirements of Technology'!F18*Evaluation!$N$4","v":7.333333333333333},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!J42:J51,'Requirements of Technology'!G3:G12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!J52:J56))/'Requirements of Technology'!G18*Evaluation!$N$4","v":7.333333333333333},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!K42:K51,'Requirements of Technology'!H3:H12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!K52:K56))/'Requirements of Technology'!H18*Evaluation!$N$4","v":7.333333333333333},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!L42:L51,'Requirements of Technology'!I3:I12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!L52:L56))/'Requirements of Technology'!I18*Evaluation!$N$4","v":10},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!M42:M51,'Requirements of Technology'!J3:J12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!M52:M56))/'Requirements of Technology'!J18*Evaluation!$N$4","v":10},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!N42:N51,'Requirements of Technology'!K3:K12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!N52:N56))/'Requirements of Technology'!K18*Evaluation!$N$4","v":7.1428571428571432},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!O42:O51,'Requirements of Technology'!L3:L12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!O52:O56))/'Requirements of Technology'!L18*Evaluation!$N$4","v":7.1428571428571432},{"$f":"(SUMPRODUCT(Matrix!$D$42:$D$51/4,Matrix!$E$42:$E$51,Matrix!P42:P51,'Requirements of Technology'!M3:M12)+SUMPRODUCT(Matrix!$E$52:$E$56,Matrix!P52:P56))/'Requirements of Technology'!M18*Evaluation!$N$4","v":7.1428571428571432},"Dependent",10]
["Community Preferences Score",{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!F59:F64)/$M$5*$N$5","v":0},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!G59:G64)/$M$5*$N$5","v":0},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!H59:H64)/$M$5*$N$5","v":0},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!I59:I64)/$M$5*$N$5","v":1.875},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!J59:J64)/$M$5*$N$5","v":1.875},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!K59:K64)/$M$5*$N$5","v":1.875},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!L59:L64)/$M$5*$N$5","v":0},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!M59:M64)/$M$5*$N$5","v":0},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!N59:N64)/$M$5*$N$5","v":1.875},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!O59:O64)/$M$5*$N$5","v":1.875},{"$f":"SUMPRODUCT(Matrix!$E$59:$E$64,Matrix!P59:P64)/$M$5*$N$5","v":1.875},{"$f":"SUM(Matrix!E59:E64)","v":100},5]
["Costs",{"$f":"SUMPRODUCT(Matrix!F67:F68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":14.549999999999999},{"$f":"SUMPRODUCT(Matrix!G67:G68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":7.5750000000000002},{"$f":"SUMPRODUCT(Matrix!H67:H68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":4.6500000000000004},{"$f":"SUMPRODUCT(Matrix!I67:I68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":6.3},{"$f":"SUMPRODUCT(Matrix!J67:J68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":9.9899999999999984},{"$f":"SUMPRODUCT(Matrix!K67:K68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":8.5499999999999989},{"$f":"SUMPRODUCT(Matrix!L67:L68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":8.2350000000000012},{"$f":"SUMPRODUCT(Matrix!M67:M68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":5.1000000000000005},{"$f":"SUMPRODUCT(Matrix!N67:N68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":7.4850000000000003},{"$f":"SUMPRODUCT(Matrix!O67:O68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":10.440000000000001},{"$f":"SUMPRODUCT(Matrix!P67:P68,Matrix!$E$67:$E$68)/$M$6*$N$6","v":9},{"$f":"SUM(Matrix!E67:E68)","v":100},15]
["Percentage Score",{"$f":"SUM(B2:B6)","v":39.497916666666661},{"$f":"SUM(C2:C6)","v":36.897916666666667},{"$f":"SUM(D2:D6)","v":54.972916666666663},{"$f":"SUM(E2:E6)","v":55.831249999999997},{"$f":"SUM(F2:F6)+4","v":63.521249999999995},{"$f":"SUM(G2:G6)","v":58.081249999999997},{"$f":"SUM(H2:H6)","v":35.224583333333335},53.089583333333337,54.492440476190481,59.780773809523808,58.34077380952381,{"$f":"SUM(M2:M6)","v":1375}]
[]
[]
[null,"Score","Rank","Pre-Treatment","Main Treatment 1","Main Treatment 2","Main Treatment 3","Disinfection"]
[{"$f":"B1","v":"Option 1:  Chlorination"},{"$f":"B7","v":39.497916666666661},{"$f":"RANK(B11,$B$11:$B$21)","v":9},{"$f":"getPreTreatment(C11)","v":"PicNone"},{"$f":"getMainTreatment1(C11)","v":"PicNone"},{"$f":"getMainTreatment2(C11)","v":"PicNone"},{"$f":"getMainTreatment3(C11)","v":"PicNone"},{"$f":"getDisinfection(C11)","v":"PicChlorination"}]
[{"$f":"C1","v":"Option 2:  Stacked Rapid Sand Filtration - Chlorination"},{"$f":"C7","v":36.897916666666667},{"$f":"RANK(B12,$B$11:$B$21)","v":10},{"$f":"getPreTreatment(C12)","v":"PicNone"},{"$f":"getMainTreatment1(C12)","v":"PicRapidSandFiltration"},{"$f":"getMainTreatment2(C12)","v":"PicNone"},{"$f":"getMainTreatment3(C12)","v":"PicNone"},{"$f":"getDisinfection(C12)","v":"PicChlorination"}]
[{"$f":"D1","v":"Option 3:  Roughing Filter - Stacked Rapid Sand Filtration - Chlorination"},{"$f":"D7","v":54.972916666666663},6,"PicRoughingFilter",{"$f":"getMainTreatment1(C13)","v":"PicRapidSandFiltration"},{"$f":"getMainTreatment2(C13)","v":"PicNone"},{"$f":"getMainTreatment3(C13)","v":"PicNone"},"PicChlorination"]
[{"$f":"E1","v":"Option 4:  Coagulation & Flocculation - Stacked Rapid Sand Filtration - Chlorination"},{"$f":"E7","v":55.831249999999997},5,"PicNone","PicCoagulationAndFlocculation","PicRapidSandFiltration","PicNone",{"$f":"getDisinfection(C14)","v":"PicChlorination"}]
[{"$f":"F1","v":"Option 5:  Coagulation & Flocculation - Sedimentation - Chlorination"},{"$f":"F7","v":63.521249999999995},1,"PicNone","PicCoagulationAndFlocculation","PicSedimentation","PicNone","PicChlorination"]
[{"$f":"G1","v":"Option 6:  Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration - Chlorination"},{"$f":"G7","v":58.081249999999997},4,"PicNone","PicCoagulationAndFlocculation","PicSedimentation","PicRapidSandFiltration","PicChlorination"]
[{"$f":"H1","v":"Option 7:  Stacked Rapid Sand Filtration"},{"$f":"H7","v":35.224583333333335},11,"PicNone","PicRapidSandFiltration","PicNone","PicNone","PicNone"]
[{"$f":"I1","v":"Option 8:  Roughing Filter - Stacked Rapid Sand Filtration"},{"$f":"I7","v":53.089583333333337},8,"PicRoughingFilter","PicRapidSandFiltration","PicNone","PicNone","PicNone"]
[{"$f":"J1","v":"Option 9:  Coagulation & Flocculation - Stacked Rapid Sand Filtration"},{"$f":"J7","v":54.492440476190481},7,"PicNone","PicCoagulationAndFlocculation","PicRapidSandFiltration","PicNone","PicNone"]
[{"$f":"K1","v":"Option 10: Coagulation & Flocculation - Sedimentation"},{"$f":"K7","v":59.780773809523808},2,"PicNone","PicCoagulationAndFlocculation","PicSedimentation","PicNone","PicNone"]
[{"$f":"L1","v":"Option 11: Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration"},{"$f":"L7","v":58.34077380952381},3,"PicNone","PicCoagulationAndFlocculation","PicSedimentation","PicRapidSandFiltration","PicNone"]
[]
["Ranked 1:"]
[{"$f":"OFFSET(A11,MATCH(1,$C$11:$C$21,0)-1,0)","v":"Option 5:  Coagulation & Flocculation - Sedimentation - Chlorination"},{"$f":"OFFSET(B11,MATCH(1,$C$11:$C$21,0)-1,0)","v":63.521249999999995},1,"PicNone","PicCoagulationAndFlocculation","PicSedimentation","PicNone","PicChlorination"]

{"sheet":"Data","index":12,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Boolean",null,"Source of Raw Water",null,"DryFluctuations","WetFluctuations",null,"Color",null,"Treatment Standards"]
["Yes",null,"Groundwater",null,10,110,null,"Cloudy-white",null,"World Health Organization (WHO)"]
["No",null,"Lakes",null,20,120,null,"Yellow",null,"United States Environmental Protection Agency (US-EPA)"]
[null,null,"Rain Water",null,30,130,null,"Brown"]
["Availability",null,"Reservoir",null,40,140]
["Yes - Can be obtained within Community",4,"River",null,50,150]
["Yes - Can be obtained within 10km from Community",3,"Spring Water",null,60,160]
["Yes - Can be obtained > 10km away in Country",2,"Stream",null,70,170]
["Yes - Can be obtained from other countries",1,"Well Water",null,80,180]
["No  - Cannot be obtained easily",0,null,null,90,190]
[null,null,null,null,null,"≥200"]
[]
[]
["Operator Skill Level",null,"Technologies",null,"Importance","Turbidity Level",null,"Skill Level "]
["1 - Basic Skills",null,"None",0,"1 - Not Important","Picture 1 -  10 NTU",null,"0 - No Skilled Workers Available"]
[2,null,"Chlorination",1,2,"Picture 2 -  25 NTU",null,"1 - Basic Skills"]
[3,null,"Coagulation",2,3,"Picture 3 -  50 NTU",null,2]
[4,null,"Flocculation",3,4,"Picture 4 - 100 NTU",null,3]
["5 - Advanced Engineering Skills",null,"Sedimentation",4,"5 - Extremely Important","Picture 5 - 250 NTU",null,4]
[null,null,"Stacked Rapid Sand Filtration",5,null,null,null,"5 - Expert Skills"]
[]
[]
[]
["Pre-Treatment",null,"Main-Treatment",null,"Disinfection"]
["None",null,"None",null,"None"]
["Roughing Filter",null,"Stacked Rapid Sand Filtration",null,"Chlorination"]
[null,null,"Coagulation & Flocculation - Stacked Rapid Sand Filtration"]
[null,null,"Coagulation & Flocculation - Sedimentation"]
[null,null,"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration"]

{"sheet":"Recommendation","index":13,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":true,"merged":[[3,5,3,7],[6,5,6,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[20,5,20,7],[11,5,11,7],[15,5,15,7],[11,3,12,3],[11,2,12,2],[11,9,12,9],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[4,2,4,3],[43,1,43,4],[45,3,45,4],[47,1,47,2],[34,1,40,4],[46,3,46,4],[47,3,47,4],[42,1,42,4],[45,1,45,2],[46,1,46,2]]}
[]
[null,"Water Treatment Technology Selection Guide"]
[]
[null,null,null,null,"Pre-Treatment","Main Treatment",null,null,"Dis-infection"]
[null,null,"Top Recommendation"]
[]
[null,null,null,null,"Roughing Filter","Stacked Rapid Sand Filtration",null,null,"Chlorination"]
[]
[]
[]
[]
[null,null,"Contaminant Levels","Source\nWater Quality","After Pre-Treatment","After Main Treatment",null,null,"After Disinfection",{"$f":"\"Compliance with \"& IF(Matrix!D29=0,\"WHO Standards\",IF(Matrix!D29=1,\"US-EPA Standards\",IF(Matrix!D29=2,\"Local Standards\",\"WHO Standards\")))","v":"Compliance with WHO Standards"}]
[null,null,null,null,{"$f":"E7","v":"Roughing Filter"},{"$f":"F7","v":"Stacked Rapid Sand Filtration"},null,null,{"$f":"I7","v":"Chlorination"}]
[null,null,"Turbidity",{"$f":"Matrix!B9 & \" \" & Matrix!C9","v":"25 NTU"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J2,0))*Matrix!B9 & \" \" &Matrix!C9","v":"6.25 NTU"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J2,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G2,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I2,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H2,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H2)*(100%-'Quality Standard'!G2),0)))))*Matrix!B9 & \" \" &Matrix!C9","v":"1.875 NTU"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J2,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G2,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I2,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H2,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H2)*(100%-'Quality Standard'!G2),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F2,0))*Matrix!B9 & \" \" & Matrix!C9","v":"1.875 NTU"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J2,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G2,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I2,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H2,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H2)*(100%-'Quality Standard'!G2),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F2,0))*Matrix!B9 <= OFFSET('Quality Standard'!B2,0,Matrix!$D$29), \"Comply\", \"Does Not Comply\")","v":"Comply"}]
[null,null,"Cryptosporidium",{"$f":"Matrix!B15 & \" \" & Matrix!C15","v":"0.0001 Organisms/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J3,0))*Matrix!B15 & \" \" & Matrix!C15","v":"0.000025 Organisms/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J3,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G3,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I3,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H3,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H3)*(100%-'Quality Standard'!G3),0)))))*Matrix!B15 & \" \" &Matrix!C15","v":"0.0000075 Organisms/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J3,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G3,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I3,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H3,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H3)*(100%-'Quality Standard'!G3),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F3,0))*Matrix!B15 & \" \" &Matrix!C15","v":"0.0000075 Organisms/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J3,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G3,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I3,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H3,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H3)*(100%-'Quality Standard'!G3),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F3,0))*Matrix!B15<=OFFSET('Quality Standard'!B3,0,Matrix!D29), \"Comply\", \"Does Not Comply\")","v":"Comply"}]
[null,null,"Total Coliform",{"$f":"Matrix!B16 & \" \" & Matrix!C16","v":"0.00022 Organisms/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J4,0))*Matrix!B16 & \" \" &Matrix!C16","v":"0.00000825 Organisms/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J4,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G4,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I4,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H4,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H4)*(100%-'Quality Standard'!G4),0)))))*Matrix!B16 & \" \" &Matrix!C16","v":"0.00000614625 Organisms/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J4,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G4,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I4,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H4,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H4)*(100%-'Quality Standard'!G4),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F4,0))*Matrix!B16 & \" \" &Matrix!C16","v":"0.00000000614625 Organisms/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J4,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G4,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I4,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H4,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H4)*(100%-'Quality Standard'!G4),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F4,0))*Matrix!B16<=OFFSET('Quality Standard'!B4,0,Matrix!D29), \"Comply\", \"Does Not Comply\")","v":"Does Not Comply"}]
[null,null,"Rotavirus",{"$f":"Matrix!B17 & \" \" & Matrix!C17","v":"0.00013 Organisms/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J5,0))*Matrix!B17 & \" \" &Matrix!C17","v":"0.00013 Organisms/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J5,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G5,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I5,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H5,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H5)*(100%-'Quality Standard'!G5),0)))))*Matrix!B17& \" \" &Matrix!C17","v":"0.00009685 Organisms/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J5,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G5,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I5,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H5,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H5)*(100%-'Quality Standard'!G5),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F5,0))*Matrix!B17 & \" \" &Matrix!C17","v":"9.68500000000001E-08 Organisms/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J5,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G5,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I5,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H5,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H5)*(100%-'Quality Standard'!G5),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F5,0))*Matrix!B17 <=OFFSET('Quality Standard'!B5,0,Matrix!D29), \"Comply\", \"Does Not Comply\")","v":"Comply"}]
[null,null,"Cadmium",{"$f":"Matrix!B23 & \" \" &Matrix!C23","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J6,0))*Matrix!B23 & \" \" & Matrix!C23","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J6,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G6,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I6,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H6,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H6)*(100%-'Quality Standard'!G6),0)))))*Matrix!B23 & \" \" & Matrix!C23","v":"0 mg/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J6,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G6,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I6,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H6,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H6)*(100%-'Quality Standard'!G6),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F6,0))*Matrix!B23 & \" \" &Matrix!C23","v":"0 mg/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J6,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G6,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I6,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H6,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H6)*(100%-'Quality Standard'!G6),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F6,0))*Matrix!B23<=OFFSET('Quality Standard'!B6,0,Matrix!D29), \"Comply\", \"Does Not Comply\")","v":"Comply"}]
[null,null,"Total Chromium",{"$f":"Matrix!B24 & \" \" &Matrix!C24","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J7,0))*Matrix!B24 & \" \" & Matrix!C24","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J7,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G7,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I7,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H7,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H7)*(100%-'Quality Standard'!G7),0)))))*Matrix!B24 & \" \" & Matrix!C24","v":"0 mg/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J7,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G7,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I7,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H7,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H7)*(100%-'Quality Standard'!G7),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F7,0))*Matrix!B24 & \" \" &Matrix!C24","v":"0 mg/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J7,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G7,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I7,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H7,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H7)*(100%-'Quality Standard'!G7),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F7,0))*Matrix!B24<=OFFSET('Quality Standard'!B7,0,Matrix!D29), \"Comply\", \"Does Not Comply\")","v":"Comply"}]
[null,null,"Mercury",{"$f":"Matrix!B26 & \" \" &Matrix!C26","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J8,0))*Matrix!B26 & \" \" &Matrix!C26","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J8,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G8,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I8,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H8,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H8)*(100%-'Quality Standard'!G8),0)))))*Matrix!B26 & \" \" &Matrix!C26","v":"0 mg/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J8,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G8,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I8,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H8,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H8)*(100%-'Quality Standard'!G8),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F8,0))*Matrix!B26 & \" \" &Matrix!C26","v":"0 mg/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J8,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G8,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I8,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H8,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H8)*(100%-'Quality Standard'!G8),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F8,0))*Matrix!B26<OFFSET('Quality Standard'!B8,0,Matrix!D29), \"Comply\", \"Does Not Comply\")","v":"Comply"}]
[null,null,"Selenium",{"$f":"Matrix!B27 & \" \" &Matrix!C27","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J9,0))*Matrix!B27 & \" \" &Matrix!C27","v":"0 mg/L"},{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J9,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G9,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I9,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H9,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H9)*(100%-'Quality Standard'!G9),0)))))*Matrix!B27 & \" \" &Matrix!C27","v":"0 mg/L"},null,null,{"$f":"(100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J9,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G9,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I9,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H9,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H9)*(100%-'Quality Standard'!G9),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F9,0))*Matrix!B27 & \" \" &Matrix!C27","v":"0 mg/L"},{"$f":"IF((100%-IF($E$13 = \"Roughing Filter\", 'Quality Standard'!J9,0))*(100%-IF($F$13=\"Stacked Rapid Sand Filtration\", 'Quality Standard'!G9,IF($F$13=\"Coagulation & Flocculation - Stacked Rapid Sand Filtration\", 'Quality Standard'!I9,IF($F$13= \"Coagulation & Flocculation - Sedimentation\", 'Quality Standard'!H9,IF($F$13 = \"Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration\", 100%-(100%-'Quality Standard'!H9)*(100%-'Quality Standard'!G9),0)))))*(100%-IF($I$13 = \"Chlorination\", 'Quality Standard'!F9,0))*Matrix!B27<OFFSET('Quality Standard'!B9,0,Matrix!D29),\"Comply\", \"Does Not Comply\")","v":"Comply"}]
[]
[]
[null,null,"Resource Requirements:"]
[]
[null,null,{"$f":"Matrix!A42","v":"Chlorine"},"Met",{"$f":"Matrix!A47","v":"Gravel"},"Met","Mason","Met"]
[null,null,{"$f":"Matrix!A43","v":"PACl"},"Not Applicable","Cement","Met","Carpenters","Met"]
[null,null,{"$f":"Matrix!A44","v":"Alum"},"Not Applicable",{"$f":"Matrix!A49","v":"Bricks"},"Met","Metal Workers","Met"]
[null,null,{"$f":"Matrix!A45","v":"Ferric Chloride"},"Not Applicable",{"$f":"Matrix!A50","v":"PVC Pipings"},"Met"]
[null,null,{"$f":"Matrix!A46","v":"Sand"},"Met",{"$f":"Matrix!A51","v":"Float Valves"},"Met"]
[]
[]
["Implementing A Sustainable Water Treatment System - the AguaClara Way!"]
[]
[null,"AguaClara is a multi-disciplinary program at Cornell University that designs sustainable water treatment systems. Gravity-powered, affordable AguaClara technologies currently provide clean water to over 25,000 people in communities around the world every day."]
[]
[]
[]
[]
[]
[]
[]
[null,"With the AguaClara approach, the costs and required site area"]
[null,"for your plant is estimated as follows:"]
[]
[null,"Capital Cost (USD)",null,">$180,000"]
[null,"Operating Cost (USD)",null,"$24,000-$36,000"]
[null,"Area (m2)",null,10.886100000000001]

{"sheet":"VendorQuestions","index":14,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Top 15 Questions to Ask Your Technology Vendor"]
[]
[null,"1. What is the track record of this equipment, where has it been used and what is the maximum capacity of the plant it has been used in? "]
[null,"2. Is there any reference I can contact to find out more about its performance?"]
[null,"3. Is this equipment/system certified for use in my country?"]
[null,"4. What is the expected lifetime of this equipment/system, and what is the length of warranty?"]
[null,"5. What does the warranty cover - material and/or service?"]
[null,"6. Can our operators perform maintenance tasks on the equipment on our own accord, or must we get qualified service personnel to carry out servicing?"]
[null,"7. Is there any training that you provide to our operators to equip themselves of the skills necessary to operate and maintain the equipment/system?"]
[null,"8. Where is the nearest service support center for this equipment/system, and who to contact?"]
[null,"9. Will there be any follow-up servicing included in the purchase price to ensure the equipment/system is working properly after a year?"]
[null,"10. What are the spare parts that need to be kept to be changed periodically, and how often do I need to change them?"]
[null,"11. Where can I purchase the spare parts locally?"]
[null,"12. What is the individual cost of these spare parts?"]
[null,"13. Can you describe the routine maintenance needed for this equipment/system, and what is the cost involved with this routine maintenance?"]
[null,"14. Can you brief us on the health and safety hazards associated with this equipment/system?"]
[null,"15. What is the purchase price and the terms of payment for the equipment/system?"]

{"sheet":"Costs","index":15,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":true,"merged":[[5,1,5,5]]}
[]
[null,"Option 1: Chlorination","Option 2: Stacked Rapid Sand Filtration - Chlorination","Option 3: Roughing Filter - Stacked Rapid Sand Filtration - Chlorination","Option 4: Coagulation & Flocculation - Stacked Rapid Sand Filtration - Chlorination","Option 5: Coagulation & Flocculation - Sedimentation - Chlorination","Option 6: Coagulation & Flocculation - Sedimentation - Stacked Rapid Sand Filtration - Chlorination","Option 7: Stacked Rapid Sand Filtration","Option 8: Roughing Filter + Stacked Rapid Sand Filtration","Option 9: Coagulation + Flocculation + Stacked Rapid Sand Filtration","Option 10: Coagulation + Flocculation + Sedimentation","Option 11:\nCoagulation + Flocculation + Sedimentation + Stacked Rapid Sand Filtration"]
["Cost","LOW","MEDIUM","VERY HIGH","HIGH","HIGH","VERY HIGH","MEDIUM","VERY HIGH","HIGH","HIGH","VERY HIGH"]
[]
[]
[null,"Possible Combinations of UTPs",null,null,null,null,"CAPEX","OPEX","Corresponds to / because"]
[1,"None","None","None","None","None","Nil","Nil"]
[{"$f":"A7+1","v":2},"Roughing Filter","None","None","None","None","Very High","High","RF"]
[{"$f":"A8+1","v":3},"None","Stacked Rapid Sand Filtration","None","None","None","Medium","Medium",7]
[4,"None","Coagulation & Flocculation","Stacked Rapid Sand Filtration","None","None","High","High",9]
[5,"None","Coagulation & Flocculation","Sedimentation","None","None","High","Low",10]
[6,"None","Coagulation & Flocculation","Sedimentation","Stacked Rapid Sand Filtration","None","Very High","Low",11]
[7,"None","None","None","None","Chlorination","Low","Low",1]
[8,"Roughing Filter","Stacked Rapid Sand Filtration","None","None","None","Very High","High","RF, 8"]
[9,"Roughing Filter","Coagulation & Flocculation","Stacked Rapid Sand Filtration","None","None","Very High","High","RF"]
[10,"Roughing Filter","Coagulation & Flocculation","Sedimentation","None","None","Very High","High","RF"]
[11,"Roughing Filter","Coagulation & Flocculation","Sedimentation","Stacked Rapid Sand Filtration","None","Very High","High","RF"]
[12,"Roughing Filter","None","None","None","Chlorination","Very High","High","RF"]
[13,"None","Stacked Rapid Sand Filtration","None","None","Chlorination","Medium","Medium",2]
[14,"None","Coagulation & Flocculation","Stacked Rapid Sand Filtration","None","Chlorination","High","High",4]
[15,"None","Coagulation & Flocculation","Sedimentation","None","Chlorination","High","Medium",5]
[16,"None","Coagulation & Flocculation","Sedimentation","Stacked Rapid Sand Filtration","Chlorination","Very High","Medium",6]
[17,"Roughing Filter","Stacked Rapid Sand Filtration","None","None","Chlorination","Very High","High","RF, 3"]
[18,"Roughing Filter","Coagulation & Flocculation","Stacked Rapid Sand Filtration","None","Chlorination","Very High","High","RF"]
[19,"Roughing Filter","Coagulation & Flocculation","Sedimentation","None","Chlorination","Very High","High","RF"]
[20,"Roughing Filter","Coagulation & Flocculation","Sedimentation","Stacked Rapid Sand Filtration","Chlorination","Very High","High","RF"]
[]
[null,"Flow Ratio",{"$f":"Matrix!B3/(10000*150)","v":0.6}]
[]
[null,"Cost Matrix"]
[null,"Capex Min","Capex Max","Opex Min","Opex Max"]
["Low",0,{"$f":"C28*50000","v":30000},0,{"$f":"C28*20000","v":12000}]
["Medium",{"$f":"C28*50000","v":30000},{"$f":"C28*200000","v":120000},{"$f":"C28*20000","v":12000},{"$f":"C28*40000","v":24000}]
["High",{"$f":"C28*200000","v":120000},{"$f":"C28*300000","v":180000},{"$f":"C28*40000","v":24000},{"$f":"C28*60000","v":36000}]
["Very High",{"$f":"C28*300000","v":180000},"$ XXX",{"$f":"C28*60000","v":36000},"$ XXX"]