{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Standard Inputs","INPUT","User Input","OUTPUT","Control","Price Tables","Capital Assumptions","Indirect Assumptions","O&M Assumptions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":226,"comments":4,"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":"Standard Inputs","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Design #","Standard system?","Design flow","Units","Average Flow","Units","Source","UV "]
[null,"user_I","design_flow","df_units_input","average_flow","af_units_input","source_select","uv_select","component_I"]
[1,"EPA Standard System",0.03,"MGD",7.0000000000000001E-3,"MGD","GW","no",1]
[2,"EPA Standard System",0.124,"MGD",3.5000000000000003E-2,"MGD","GW","no",1]
[3,"EPA Standard System",0.30499999999999999,"MGD",9.4E-2,"MGD","GW","no",1]
[4,"EPA Standard System",0.74,"MGD",0.251,"MGD","GW","no",1]
[5,"EPA Standard System",0.03,"MGD",8.9999999999999993E-3,"MGD","SW","no",1]
[6,"EPA Standard System",0.124,"MGD",3.9E-2,"MGD","SW","no",1]
[7,"EPA Standard System",0.30499999999999999,"MGD",0.1,"MGD","SW","no",1]
[8,"EPA Standard System",0.74,"MGD",0.251,"MGD","SW","no",1]

{"sheet":"INPUT","index":1,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":false,"merged":[[7,2,7,3],[9,2,9,3],[20,2,21,3],[4,4,4,5]]}
[{"$f":"\"Point-of-Use or Point-of-Entry System Design and Costs (results in \"&current_year&\" dollars)\"","v":"Point-of-Use or Point-of-Entry System Design and Costs (results in 2020 dollars)"}]
[]
[]
["Step 1:"]
["Select a User-Defined System to estimate costs for a single system using site-specific information. The EPA Standard System option is for EPA's use in estimating national costs, although other users might find the designs useful as a starting point.",null,"EPA Standard System",{"$f":"IF(user=1,\"click here -->\",\"\")","v":""},"To User-Defined System Input Page"]
[]
["Step 2:"]
["Choose a contaminant",null,"Arsenic"]
["Step 3:"]
["Choose a treatment technology",null,"POU Adsorptive Media NSF53"]
[]
["Step 4:"]
["Select one of the standard designs at right"]
[]
[]
[]
[]
[]
[]
["Step 5:",null,null,null,null,{"$f":"\"Results summary (\"&current_year&\" dollars, see OUTPUT sheet for details)\"","v":"Results summary (2020 dollars, see OUTPUT sheet for details)"}]
["(Optional for standard designs)",null,{"$f":"IF(AND(C34=\"Contaminant selection OK\",C35=\"Treatment technology OK\",C36=\"Average flow OK\",C37=\"\"),\"Input Complete\",\"Input Incomplete -- Check for Error Messages Below\")","v":"Input Complete"},null,null,{"$f":"\"Direct Capital Cost: \"&IF(input_status<>\"input complete\",input_status,IF(ISERROR(direct_cost),\"Calculation error!\",TEXT(direct_cost,\"$0,0\")))","v":"Direct Capital Cost: $87,137"}]
["Enter or change values in the gold cells below in Step 6.",null,null,null,null,{"$f":"\"Total Capital Cost: \"&IF(input_status<>\"input complete\",input_status,IF(ISERROR(system_cost),\"Calculation error!\",TEXT(OUTPUT!C76,\"$0,0\")))","v":"Total Capital Cost: $114,497"}]
[null,null,null,null,null,{"$f":"\"Annualized Capital Cost: \"&IF(input_status<>\"Input Complete\",input_status,IF(ISERROR(annualized_capital_cost),\"Calculation error!\",TEXT(annualized_capital_cost,\"$0,0\")&\" per year\"&\" (over \"&discount_period&\" years at \"&discount_rate*100&\"%)\"))","v":"Annualized Capital Cost: $16,302 per year (over 10 years at 7%)"}]
[null,null,null,null,null,{"$f":"\"Annual O&M Cost: \"&IF(input_status<>\"input complete\",input_status,IF(ISERROR(OM_cost),\"Calculation error!\",TEXT(OM_cost,\"$0,0\")&\" per year\"))","v":"Annual O&M Cost: $21,236 per year"}]
["Step 6:",null,null,null,null,{"$f":"\"Total Annualized Cost: \"&IF(input_status<>\"input complete\",input_status,IF(ISERROR(annualized_cost),\"Calculation error!\",TEXT(annualized_cost,\"$0,0\")&\" per year\"))","v":"Total Annualized Cost: $37,538 per year"}]
["Inputs",null,null,null,null,{"$f":"\"Total Household Cost: \"&IF(input_status<>\"Input Complete\",input_status,IF(ISERROR(OUTPUT!J115),\"Calculation error!\",TEXT(OUTPUT!J115,\"$0.00\")&\" per household per year\"))","v":"Total Household Cost: $326.41 per household per year"}]
["Design Flow (system peak flow)","design_flow",0.124,"MGD"]
["Average System Flow","average_flow",3.5000000000000003E-2,"MGD"]
["Water Source","source_select","GW","<-- enter GW or SW"]
["Include UV Disinfection","uv_select","no","<-- enter yes or no"]
["For information:"]
["Service Population (number of households)","hh_stand",{"$f":"ROUND(IF(source_select=\"GW\",((CHOOSE(df_units,design_flow*1000,design_flow*1440/1000))/0.54992)^(1/0.95538),((CHOOSE(af_units,design_flow*1000,design_flow*1440/1000))/0.59028)^(1/0.94573))/hh_size,0)","v":115}]
[]
[null,null,{"$f":"IF(COUNTIF(contaminant_list,contam_stand)=0,IF(contam_stand=\"\",\"Please select a target contaminant\",\"Warning: Target contaminant is not valid\"),\"Contaminant selection OK\")","v":"Contaminant selection OK"}]
[null,null,{"$f":"IF(ISERROR(COUNTIF(INDIRECT(contam_stand),\"\")),\"Warning: Invalid target contaminant; unable to evaluate validity of treatment technology\",IF(COUNTIF(INDIRECT(contam_stand),treat)=0,IF(treat=\"\",\"Please select a certified treatment technology\",\"Warning: Treatment technology selected is not certified for target contaminant\"),\"Treatment technology OK\"))","v":"Treatment technology OK"}]
[null,null,{"$f":"IF(df_units=af_units,IF(average_flow>design_flow,\"Warning: The average flow should not be greater than the design flow\",\"Average flow OK\"),\"Warning: Flow units do not match.\")","v":"Average flow OK"}]
[null,null,{"$f":"IF(OR(design_flow=\"\",df_units_input=\"\",average_flow=\"\",af_units_input=\"\",source_select=\"\",uv_select=\"\"),\"Input Incomplete: enter values for all gold cells above\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Optional Inputs",null,"Optional input (blue cells)"]
["Component level",null,"mid cost","<-- pick one (note - no difference as of 3/9/06 version)"]

{"sheet":"User Input","index":2,"n_rows":123,"n_cols":5,"rows_kept":123,"cut":false,"hidden":false,"merged":[[11,2,11,3],[3,2,3,3],[6,2,6,3],[15,4,15,7]]}
["User Defined Point-of-Use or Point-of-Entry System"]
[]
["Step 2:"]
["Choose a contaminant",null,"SOCs"]
[null,null,"Status:",{"$f":"IF(COUNTIF(contaminant_list,contam_user)=0,IF(contam_user=\"\",\"Please select a target contaminant\",\"Warning: Target contaminant is not valid\"),\"Contaminant selection OK\")","v":"Contaminant selection OK"}]
["Step 3:"]
["Choose a treatment technology, and",null,"POU GAC"]
["indicate whether treatment includes UV disinfection.","user_UV","yes"]
[null,null,"Status:",{"$f":"IF(ISERROR(COUNTIF(INDIRECT(contam_user),\"\")),\"Warning: Invalid target contaminant; unable to evaluate validity of treatment technology\",IF(COUNTIF(INDIRECT(contam_user),user_treat)=0,IF(user_treat=\"\",\"Please select a certified treatment technology\",\"Warning: Treatment technology selected is not certified for target contaminant\"),\"Treatment technology OK\"))","v":"Treatment technology OK"}]
["Step 4:"]
["Choose a method for entering system size. Then enter the required information in the gold cell(s)."]
["a. Select method for system size input","user_design","average flow"]
["b. Enter average daily system flow in gallons per day, and","user_flow",8800,"gallons per day","For information:"]
["     select a water source.","user_source_select","surface water",null,{"$f":"\"approx. households: \"&Control!D33","v":"approx. households: 25"}]
["b. Enter number of household connections","user_pop",50]
[null,null,null,null,"Results summary (see OUTPUT sheet for details)"]
["Step 5:",null,{"$f":"IF(OR(contam_user=\"\",user_treat=\"\",uv_user_select=\"\",user_design=\"\"),\"Incomplete input\",IF(AND(user_design=\"average flow\",OR(user_flow=\"\",user_source_select=\"\")),\"Incomplete input\",IF(AND(user_design=\"household connections\",user_pop=\"\"),\"Incomplete input\",\"Input Complete\")))","v":"Input Complete"},null,{"$f":"\"Direct Capital Cost: \"&IF(C17=\"input complete\",TEXT(direct_cost,\"$0,0\"),\"Input incomplete\")","v":"Direct Capital Cost: $87,137"}]
["Enter Cost Assumptions",null,null,null,{"$f":"\"Total Capital Cost: \"&IF(C17=\"input complete\",TEXT(OUTPUT!C76,\"$0,0\"),\"Input incomplete\")","v":"Total Capital Cost: $114,497"}]
["To replace the default value for any variable, enter a value (using correct units) in the blank blue cell. ",null,null,null,{"$f":"\"Annual O&M Cost: \"&IF(C17=\"input complete\",TEXT(OM_cost,\"$0,0\"),\"Input incomplete\")","v":"Annual O&M Cost: $21,236"}]
["Items in light gray italics are not applicable given the contaminant and treatment selections.",null,null,null,{"$f":"\"Total $/householdl: \"&IF(C17=\"Input complete\",TEXT(OUTPUT!J115,\"$0.00\"),\"Input incomplete\")","v":"Total $/householdl: $326.41"}]
["Capital Cost Assumptions"]
["Equipment Purchase",null,null,null,"Default Values"]
["Unit cost of POE/POU device without installation","user_unit_cost",null,"$/unit",{"$f":"VLOOKUP(hh_select,INDIRECT(VLOOKUP(user_treat_select,name_list,3,FALSE)),3)","v":395.21185316167197}]
["Unit cost of UV system","user_uv_cost",null,"$/unit",{"$f":"uv*VLOOKUP(hh_select,pou_uv_equipment,3)","v":0}]
[]
["Equipment Installation",null,null,null,"Default Values"]
["Wage rate for installation specialist (plumber/electrician)","user_tech_rate",null,"$/hour",{"$f":"install_rate","v":42.745999999999995}]
["Wage rate for system technical and maintenance labor","user_tech_rate",null,"$/hour",{"$f":"tech_rate","v":33.265162098930482}]
["Wage rate for scheduling and administrative labor","user_cler_rate",null,"$/hour",{"$f":"clerical_rate","v":32.037287767379674}]
["POU/POE installation time","user_install",null,"hours/household",{"$f":"VLOOKUP('Capital Assumptions'!A7,install_hours,user_treat_select+3,FALSE)","v":2}]
["POU/POE installation scheduling time",null,null,"hours/household",{"$f":"VLOOKUP('Capital Assumptions'!A8,install_hours,user_treat_select+3,FALSE)","v":0.5}]
["UV installation time","user_uv_install",null,"hours/household",{"$f":"uv*VLOOKUP('Capital Assumptions'!A9,install_hours,user_treat_select+3,FALSE)","v":0}]
[]
["Public Education Program",null,null,null,"Default Values"]
["Technical Labor to Support Educational Program"]
["Develop technical content for educational materials","user_dev_tech",null,"total hours",{"$f":"VLOOKUP('Capital Assumptions'!A12,tech_labor,user_treat_select+3,FALSE)","v":10}]
["Develop nitrate health impact information for stakeholders","user_dev_nit",null,"total hours",{"$f":"nitrate_select*VLOOKUP('Capital Assumptions'!A13,tech_labor,user_treat_select+3,FALSE)","v":0}]
["Prepare for and attend public meetings","user_meet_tech",null,"total hours",{"$f":"VLOOKUP('Capital Assumptions'!A14,tech_labor,user_treat_select+3,FALSE)","v":2}]
["Post-meeting stakeholder communication","user_post_tech",null,"total hours",{"$f":"VLOOKUP('Capital Assumptions'!A15,tech_labor,user_treat_select+3,FALSE)","v":2}]
[]
["Clerical Labor to Support Educational Program"]
["Prepare educational materials for distribution","user_dev_cler",null,"total hours",{"$f":"VLOOKUP('Capital Assumptions'!A16,clerical_labor,user_treat_select+3,FALSE)","v":6}]
["Prepare nitrate health impact information for distribution","user_nitr_cler",null,"total hours",{"$f":"nitrate_select*VLOOKUP('Capital Assumptions'!A17,clerical_labor,user_treat_select+3,FALSE)","v":0}]
["Prepare for and attend public meetings","user_meet_cler",null,"total hours",{"$f":"VLOOKUP('Capital Assumptions'!A18,clerical_labor,user_treat_select+3,FALSE)","v":2}]
["Prepare post-meeting materials for distribution","user_post_cler",null,"total hours",{"$f":"VLOOKUP('Capital Assumptions'!A19,clerical_labor,user_treat_select+3,FALSE)","v":2}]
[]
["Communication Materials for Educational Program"]
["Print flyers announcing public meetings","user_flyers",null,"flyers",{"$f":"VLOOKUP('Capital Assumptions'!A20,ed_material,user_treat_select+3,FALSE)","v":10}]
["Cost per flyer for printing",null,null,"$/flyer",{"$f":"VLOOKUP(\"Meeting Flyers\",printed_material_cost,3,FALSE)","v":1.7566666666666666}]
["Buy ads to announce public meetings","user_ads",null,"ads",{"$f":"VLOOKUP('Capital Assumptions'!A21,ed_material,user_treat_select+3,FALSE)","v":1}]
["Cost per meeting ad",null,null,"$/meeting announcement",{"$f":"VLOOKUP(\"Meeting Ads\",printed_material_cost,3,FALSE)","v":68.875}]
["Print nitrate health impact flyers","user_nitr_flyers",null,"flyers",{"$f":"nitrate_select*VLOOKUP('Capital Assumptions'!A22,ed_material,user_treat_select+3,FALSE)","v":0}]
["Print handouts for meetings","user_handout",null,"pages/household",{"$f":"VLOOKUP('Capital Assumptions'!A23,ed_material,user_treat_select+3,FALSE)","v":3}]
["Print inserts for billing mailers","user_mailers",null,"pages/household",{"$f":"VLOOKUP('Capital Assumptions'!A24,ed_material,user_treat_select+3,FALSE)","v":2}]
["Cost to print handouts and mailers",null,null,"$/page",{"$f":"VLOOKUP(\"Billing Mailers\",printed_material_cost,3,FALSE)","v":0.17333333333333334}]
[]
["First Year Water Quality Sampling",null,null,null,"Default Values"]
["Time to take sample during first year","user_samp_time",null,"hours/sample",{"$f":"VLOOKUP('Capital Assumptions'!A27,initial_sample,user_treat_select+3,FALSE)","v":0.25}]
["Time to schedule sample event at household","user_samp_sched",null,"hours/sample",{"$f":"VLOOKUP('Capital Assumptions'!A28,initial_sample,user_treat_select+3,FALSE)","v":0}]
["Number of sampling events per household during the first year","user_analysis",null,"samples/household",{"$f":"VLOOKUP('Capital Assumptions'!A29,initial_sample,user_treat_select+3,FALSE)","v":1}]
["Percent of households sampled during the first year","user_analysis",null,"% households",{"$f":"VLOOKUP('Capital Assumptions'!A30,initial_sample,user_treat_select+3,FALSE)","v":1}]
["Laboratory analysis fee (target contaminant)",null,null,"$/sample",{"$f":"VLOOKUP(contam,lab_analysis_cost,3,FALSE)","v":29.672538247055797}]
["Laboratory analysis fee (total coliform)",null,null,"$/sample",{"$f":"VLOOKUP(\"Total Coliform\",lab_analysis_cost,3,FALSE)","v":28.881270560467641}]
["Sample shipping cost (bulk) (target contaminant)",null,null,"$/bulk shipment",{"$f":"VLOOKUP(Shipping_Category,Shipping_OM,2,FALSE)","v":216.15}]
["Sample shipping cost (bulk) (total coliform)",null,null,"$/bulk shipment",{"$f":"VLOOKUP(\"Coliform\",Shipping_OM,2,FALSE)","v":59.8}]
[]
["Indirect Capital Cost Multipliers",null,null,"Choose Units:","Default Values"]
["Cost to obtain operating permit","user_permitting",null,"% installed equipment cost",{"$f":"VLOOKUP('Capital Assumptions'!A34,indirect_cost,user_treat_select+3,FALSE)","v":0.03}]
["Cost to conduct pilot test","user_pilot",null,"% installed equipment cost",{"$f":"VLOOKUP('Capital Assumptions'!A35,indirect_cost,user_treat_select+3,FALSE)","v":0.03}]
["Cost for legal activities (e.g., ordinance changes)","user_legal",null,"% installed equipment cost",{"$f":"VLOOKUP('Capital Assumptions'!A36,indirect_cost,user_treat_select+3,FALSE)","v":0.03}]
["Cost for engineering activities (e.g., device selection)","user_eng",null,"% installed equipment cost",{"$f":"VLOOKUP('Capital Assumptions'!A37,indirect_cost,user_treat_select+3,FALSE)","v":0.15}]
["Contingency cost (unknown factors)","user_cont",null,"% installed equipment cost",{"$f":"VLOOKUP('Capital Assumptions'!A38,indirect_cost,user_treat_select+3,FALSE)","v":0.1}]
[]
["O&M Cost Assumptions"]
["Equipment Maintenance",null,null,null,"Default Values"]
["POU/POE maintenance","user_maint",null,"hours/visit",{"$f":"INDEX(maint_time,1,user_treat_select)","v":0.5}]
["POU/POE replacement frequency","user_repl_freq",null,"visits/household/yr",{"$f":"INDEX(maint_time,1,user_treat_select)","v":0.5}]
["UV maintenance","user_uv_maint",null,"hours/visit",{"$f":"uv*INDEX(UV_maint_time,1,user_treat_select)","v":0}]
["UV maintenance frequency","user_uv_freq",null,"visits/household/year",{"$f":"uv*INDEX(UV_maint_frequency,1,user_treat_select)","v":0}]
["Scheduling time","user_maint_sched",null,"hours/visit",{"$f":"INDEX(maint_scheduling,1,user_treat_select)","v":0.5}]
[]
["Public Education Program",null,null,null,"Default Values"]
["Technical Labor to Support On-Going Education Program Activities"]
["Develop updates to technical information","user_updates_tech",null,"hours",{"$f":"VLOOKUP('O&M Assumptions'!A12,tech_labor_om,user_treat_select+3,FALSE)","v":12}]
["Develop updates for nitrate health effects","user_nitr_updates_tech",null,"hours",{"$f":"nitrate_select*VLOOKUP('O&M Assumptions'!A13,tech_labor_om,user_treat_select+3,FALSE)","v":0}]
[]
["Clerical Labor to Support On-Going Education Program Activities"]
["Prepare information updates for distribution","user_info_cler",null,"hours",{"$f":"VLOOKUP('O&M Assumptions'!A14,clerical_labor_om,user_treat_select+3,FALSE)","v":12}]
["Prepare nitrate information updates for distribution","user_nitr_updates_cler",null,"hours",{"$f":"nitrate_select*VLOOKUP('O&M Assumptions'!A15,clerical_labor_om,user_treat_select+3,FALSE)","v":0}]
[]
["Communication Materials to Support On-Going Education Program Activities"]
["Nitrate flyers","user_om_flyer",null,"flyers",{"$f":"nitrate_select*VLOOKUP('O&M Assumptions'!A16,ed_material_om,user_treat_select+3,FALSE)","v":0}]
["Billing mailers","user_om_billing",null,"pages/household",{"$f":"VLOOKUP('O&M Assumptions'!A17,ed_material_om,user_treat_select+3,FALSE)","v":3}]
[]
["Laboratory Analyses",null,null,null,"Default Values"]
["Sampling time","user_om_samp",null,"hrs/sample",{"$f":"VLOOKUP('O&M Assumptions'!A20,lab_analysis,user_treat_select+3,FALSE)","v":0.25}]
["Sampling scheduling time","user_om_sched",null,"hrs/sample",{"$f":"VLOOKUP('O&M Assumptions'!A21,lab_analysis,user_treat_select+3,FALSE)","v":0}]
["Analysis samples","user_om_analysis",null,"samples/household/year",{"$f":"VLOOKUP('O&M Assumptions'!A22,lab_analysis,user_treat_select+3,FALSE)","v":1}]
["Analysis share","user_om_shipping",null,"% households/year",{"$f":"IF(nitrate_select=1,\"100%\",VLOOKUP('O&M Assumptions'!A23,lab_analysis,user_treat_select+3,FALSE))","v":0.33300000000000002}]
[]
["Parts Replacement",null,null,null,"Default Values"]
["To replace default values with user-defined data, enter part names, costs, and replacement frequencies below."]
[]
["Name of Replacement Part 1",null,null,null,{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),1,1)","v":"Media Cartridge"}]
["Unit Cost of Replacement Part 1","user_repl1",null,"$/part",{"$f":"IF(AND(C104=\"\",OUTPUT!C95>0),VLOOKUP(OUTPUT!B95,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0)","v":120.17839925490911}]
["Replacement Frequency","user_repl1_freq",null,"times/household/yr",{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),1,2)","v":1}]
[]
["Name of Replacement Part 2",null,null,null,{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),2,1)","v":"NA"}]
["Unit Cost of Replacement Part 2","user_repl2",null,"$/part",{"$f":"IF(AND(C108=\"\",OUTPUT!C96>0),VLOOKUP(OUTPUT!B96,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0)","v":0}]
["Replacement Frequency","user_repl2_freq",null,"times/household/yr",{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),2,2)","v":0}]
[]
["Name of Replacement Part 3",null,null,null,{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),3,1)","v":"NA"}]
["Unit Cost of Replacement Part 3","user_repl3",null,"$/part",{"$f":"IF(AND(C112=\"\",OUTPUT!C97>0),VLOOKUP(OUTPUT!B97,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0)","v":0}]
["Replacement Frequency","user_repl3_freq",null,"times/household/yr",{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),3,2)","v":0}]
[]
["Name of Replacement Part 4",null,null,null,{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),4,1)","v":"NA"}]
["Unit Cost of Replacement Part 4","user_repl4",null,"$/part",{"$f":"IF(AND(C116=\"\",OUTPUT!C98>0),VLOOKUP(OUTPUT!B98,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0)","v":0}]
["Replacement Frequency","user_repl4_freq",null,"times/household/yr",{"$f":"INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),4,2)","v":0}]
[]
["Replacement UV Lamp","user_uv_lamp",null,"$/part",{"$f":"uv*IF(OUTPUT!C7=\"POU\",VLOOKUP(OUTPUT!B99,pou_uv_parts,3,FALSE),VLOOKUP(OUTPUT!B99,poe_uv_parts,3,FALSE))","v":0}]
["Replacement Frequency","user_uv_lamp_freq",null,"times/yr",{"$f":"uv*IF(OUTPUT!C7=\"POU\",INDEX(pou_uv_replace,1,2),INDEX(poe_uv_replace,1,2))","v":0}]
["Replacement UV Quartz Sleeve","user_uv_sleeve_freq",null,"$/part",{"$f":"uv*IF(OUTPUT!C7=\"POU\",VLOOKUP(OUTPUT!B100,pou_uv_parts,3,FALSE),VLOOKUP(OUTPUT!B100,poe_uv_parts,3,FALSE))","v":0}]
["Replacement Frequency","user_uv_sleeve",null,"times/yr",{"$f":"uv*IF(OUTPUT!C7=\"POU\",INDEX(pou_uv_replace,2,2),INDEX(poe_uv_replace,2,2))","v":0}]

{"sheet":"OUTPUT","index":3,"n_rows":150,"n_cols":24,"rows_kept":150,"cut":false,"hidden":false,"merged":[[82,4,82,5],[20,10,21,10],[21,2,21,3],[21,4,21,5],[20,2,20,5],[20,6,21,7],[20,8,21,8],[20,9,21,9]]}
["OUTPUT SUMMARY"]
[null,"Parameter","Value"]
[null,"System Description",null,null,null,null,"column not used","column not used",null,null,null,null,"Valid inputs:",{"$f":"IF(contam_stand=\"\",FALSE,TRUE)","v":true},{"$f":"IF(treat=\"\",FALSE,TRUE)","v":true},{"$f":"IF(COUNTIF(contaminant_list,contam_stand)=0,IF(contam_stand=\"\",TRUE,FALSE),TRUE)","v":true},{"$f":"IF(ISERROR(COUNTIF(INDIRECT(contam_stand),TRUE)),FALSE,IF(COUNTIF(INDIRECT(contam_stand),treat)=0,IF(treat=\"\",TRUE,FALSE),TRUE))","v":true},{"$f":"IF(average_flow>design_flow,FALSE,TRUE)","v":true}]
[null,"Households Served",{"$f":"hh_select","v":115}]
[null,"Contaminant",{"$f":"contam","v":"Arsenic"}]
[null,"Treatment Technology",{"$f":"IF(user=1,user_treat,treat)","v":"POU Adsorptive Media NSF53"}]
[null,"Treatment Location",{"$f":"LEFT(IF(user=1,user_treat,treat),3)","v":"POU"}]
[null,"UV Treatment",{"$f":"IF(user=1,uv_user_select,uv_select)","v":"no"}]
[null,"System Size Category",{"$f":"IF(design_flow<1,1,IF(design_flow<10,2,3))","v":1},"1 indicates small system, 2 indicates medium, 3 indicates large"]
[null,{"$f":"\"Resulting Costs (in year \"&TEXT(current_year,0)&\" dollars)\"","v":"Resulting Costs (in year 2020 dollars)"}]
[null,"Direct Capital Cost",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(direct_cost),\"Calculation error!\",direct_cost))","v":87136.740531252202},{"$f":"IF(input_status<>\"input complete\",\"Check INPUT sheet for errors\",\"\")","v":""}]
[null,"Add-on Cost",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(addon_cost),\"Calculation error!\",addon_cost))","v":0}]
[null,"Indirect Capital Cost",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(indirect_cost_add),\"Calculation error!\",indirect_cost_add))","v":27360.471296773947}]
[null,"Total Capital Cost",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(system_cost),\"Calculation error!\",system_cost))","v":114497}]
[null,{"$f":"\"Annualized Capital Costs (per year over \"&discount_period&\" years at \"&discount_rate*100&\"%)\"","v":"Annualized Capital Costs (per year over 10 years at 7%)"},{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(annualized_capital_cost),\"Calculation error!\",annualized_capital_cost))","v":16301.82708932045}]
[null,"Annual O&M Cost (per year)",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(OM_cost),\"Calculation error!\",OM_cost))","v":21235.849954648831}]
[null,{"$f":"\"Total Annualized Cost (per year)\"","v":"Total Annualized Cost (per year)"},{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(annualized_cost),\"Calculation error!\",annualized_cost))","v":37537.677043969277}]
[null,"Per 1,000 gallons average flow",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(J114),\"Calculation error!\",J114))","v":3.9327058191691227}]
[null,"Per household per year",{"$f":"IF(input_status<>\"input complete\",\"Action required\",IF(ISERROR(J115),\"Calculation error!\",J115))","v":326.41458299103721}]
[]
["Direct Capital Costs",null,"Design",null,null,null,"Size used in estimate",null,"Unit Cost","Total Cost","Useful Life"]
["WBS #","Item","Quantity",null,"Frequency",null,null,null,null,null,null,"Use?"]
[1,"Installed Treatment Equipment",null,null,null,null,null,null,null,null,null,null,null,"Low","Typical","High","Low","Typical","High","Low","Typical","High"]
[1.1000000000000001,"POU/POE Unit Purchase",{"$f":"IF(treat_select=1,0,1)","v":1},"unit/household",{"$f":"hh_select","v":115},"households",null,null,{"$f":"VLOOKUP($E24,INDIRECT(VLOOKUP(treat_select,name_list,3,FALSE)),3)","v":598.24565526653896},{"$f":"I24*C24*E24","v":68798.25035565198},{"$f":"VLOOKUP($E24,INDIRECT(VLOOKUP(treat_select,name_list,3,FALSE)),5)","v":10},1,{"$f":"$B$23&\" - \"&B24","v":"Installed Treatment Equipment - POU/POE Unit Purchase"},1,1,1,1,1,1,1,1,1]
[1.2,"POU/POE Installation",{"$f":"VLOOKUP(B25,install_hours,treat_select+3,FALSE)","v":2},"hours/household",{"$f":"hh_select","v":115},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_install_rate),install_rate,user_install_rate),install_rate)","v":42.745999999999995},{"$f":"I25*C25*E25","v":9831.5799999999981},{"$f":"VLOOKUP($E25,INDIRECT(VLOOKUP(treat_select,name_list,3,FALSE)),4)","v":10},1,{"$f":"$B$23&\" - \"&B25","v":"Installed Treatment Equipment - POU/POE Installation"},1,1,1,1,1,1,1,1,1]
[1.3,"Scheduling Time",{"$f":"VLOOKUP(B26,install_hours,treat_select+3,FALSE)","v":0.5},"hours/household",{"$f":"hh_select","v":115},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I26*C26*E26","v":1842.1440466243312},{"$f":"K28","v":0},null,{"$f":"$B$23&\" - \"&B26","v":"Installed Treatment Equipment - Scheduling Time"},1,1,1,1,1,1,1,1,1]
[1.4,"UV Purchase",{"$f":"uv","v":0},"unit/household",{"$f":"uv*hh_select","v":0},"households",null,null,{"$f":"uv*IF(user=1,IF(user_uv_cost=\"\",IF(C7=\"POU\",VLOOKUP(hh_select,pou_uv_equipment,3),VLOOKUP(hh_select,poe_uv_equipment,3)),user_uv_cost),IF(C7=\"POU\",VLOOKUP(hh_select,pou_uv_equipment,3),VLOOKUP(hh_select,poe_uv_equipment,3)))","v":0},{"$f":"I27*C27*E27","v":0},{"$f":"uv*IF(user=1,IF(user_uv_cost=\"\",VLOOKUP(hh_select,pou_uv_equipment,5),VLOOKUP(hh_select,user_uv_equipment,5)),VLOOKUP(hh_select,pou_uv_equipment,5))","v":0},null,{"$f":"$B$23&\" - \"&B27","v":"Installed Treatment Equipment - UV Purchase"},1,1,1,1,1,1,1,1,1]
[1.5,"UV Installation",{"$f":"uv*VLOOKUP(B28,install_hours,treat_select+3,FALSE)","v":0},"hours/household",{"$f":"uv*hh_select","v":0},"households",null,null,{"$f":"uv*IF(user=1,IF(ISBLANK(user_install_rate),install_rate,user_install_rate),install_rate)","v":0},{"$f":"I28*C28*E28","v":0},{"$f":"K27","v":0},null,{"$f":"$B$23&\" - \"&B28","v":"Installed Treatment Equipment - UV Installation"},1,1,1,1,1,1,1,1,1]
[2,"Public Education"]
[2.1,"Technical Labor"]
["2.1.1","Develop materials",{"$f":"VLOOKUP(B31,tech_labor,treat_select+3,FALSE)","v":10},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I31*C31","v":332.65162098930483},"N/A",1,{"$f":"$B$29&\" - \"&$B$30&\" - \"&B31","v":"Public Education - Technical Labor - Develop materials"},1,1,1,1,1,1,1,1,1]
["2.1.2","Nitrate health effects",{"$f":"nitrate_select*VLOOKUP(B32,tech_labor,treat_select+3,FALSE)","v":0},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I32*C32","v":0},"N/A",null,{"$f":"$B$29&\" - \"&$B$30&\" - \"&B32","v":"Public Education - Technical Labor - Nitrate health effects"},1,1,1,1,1,1,1,1,1]
["2.1.3","Meetings",{"$f":"VLOOKUP(B33,tech_labor,treat_select+3,FALSE)","v":2},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I33*C33","v":66.530324197860963},"N/A",1,{"$f":"$B$29&\" - \"&$B$30&\" - \"&B33","v":"Public Education - Technical Labor - Meetings"},1,1,1,1,1,1,1,1,1]
["2.1.4","Post-meeting",{"$f":"VLOOKUP(B34,tech_labor,treat_select+3,FALSE)","v":2},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I34*C34","v":66.530324197860963},"N/A",1,{"$f":"$B$29&\" - \"&$B$30&\" - \"&B34","v":"Public Education - Technical Labor - Post-meeting"},1,1,1,1,1,1,1,1,1]
[2.2000000000000002,"Clerical Labor"]
["2.2.1","Develop materials",{"$f":"VLOOKUP(B36,clerical_labor,treat_select+3,FALSE)","v":6},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I36*C36","v":192.22372660427806},"N/A",1,{"$f":"$B$29&\" - \"&$B$35&\" - \"&B36","v":"Public Education - Clerical Labor - Develop materials"},1,1,1,1,1,1,1,1,1]
["2.2.2","Nitrate health effects",{"$f":"nitrate_select*VLOOKUP(B37,clerical_labor,treat_select+3,FALSE)","v":0},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I37*C37","v":0},"N/A",null,{"$f":"$B$29&\" - \"&$B$35&\" - \"&B37","v":"Public Education - Clerical Labor - Nitrate health effects"},1,1,1,1,1,1,1,1,1]
["2.2.3","Meetings",{"$f":"VLOOKUP(B38,clerical_labor,treat_select+3,FALSE)","v":2},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I38*C38","v":64.074575534759347},"N/A",1,{"$f":"$B$29&\" - \"&$B$35&\" - \"&B38","v":"Public Education - Clerical Labor - Meetings"},1,1,1,1,1,1,1,1,1]
["2.2.4","Post-meeting",{"$f":"VLOOKUP(B39,clerical_labor,treat_select+3,FALSE)","v":2},"hours",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I39*C39","v":64.074575534759347},"N/A",1,{"$f":"$B$29&\" - \"&$B$35&\" - \"&B39","v":"Public Education - Clerical Labor - Post-meeting"},1,1,1,1,1,1,1,1,1]
[2.2999999999999998,"Printed Material"]
["2.3.1","Meeting flyers",{"$f":"VLOOKUP(B41,ed_material,treat_select+3,FALSE)","v":10},"flyers",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_flyer_cost),VLOOKUP($B41,printed_material_cost,3,FALSE),user_flyer_cost),VLOOKUP($B41,printed_material_cost,3,FALSE))","v":1.7566666666666666},{"$f":"I41*C41","v":17.566666666666666},{"$f":"VLOOKUP($B41,printed_material_cost,5,FALSE)","v":"N/A"},1,{"$f":"$B$29&\" - \"&$B$40&\" - \"&B41","v":"Public Education - Printed Material - Meeting flyers"},1,1,1,1,1,1,1,1,1]
["2.3.2","Meeting ads",{"$f":"VLOOKUP(B42,ed_material,treat_select+3,FALSE)","v":1},"ads",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_ad_cost),VLOOKUP($B42,printed_material_cost,3,FALSE),user_ad_cost),VLOOKUP($B42,printed_material_cost,3,FALSE))","v":68.875},{"$f":"I42*C42","v":68.875},{"$f":"VLOOKUP($B42,printed_material_cost,5,FALSE)","v":"N/A"},1,{"$f":"$B$29&\" - \"&$B$40&\" - \"&B42","v":"Public Education - Printed Material - Meeting ads"},1,1,1,1,1,1,1,1,1]
["2.3.3","Nitrate awareness flyers",{"$f":"nitrate_select*VLOOKUP(B43,ed_material,treat_select+3,FALSE)","v":0},"flyers",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_flyer_cost),VLOOKUP($B43,printed_material_cost,3,FALSE),user_flyer_cost),VLOOKUP($B43,printed_material_cost,3,FALSE))","v":1.7566666666666666},{"$f":"I43*C43","v":0},{"$f":"VLOOKUP($B43,printed_material_cost,5,FALSE)","v":"N/A"},null,{"$f":"$B$29&\" - \"&$B$40&\" - \"&B43","v":"Public Education - Printed Material - Nitrate awareness flyers"},1,1,1,1,1,1,1,1,1]
["2.3.4","Meeting handouts",{"$f":"VLOOKUP(B44,ed_material,treat_select+3,FALSE)","v":3},"pages/household",{"$f":"hh_select","v":115},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_print_cost),VLOOKUP($B44,printed_material_cost,3,FALSE),user_print_cost),VLOOKUP($B44,printed_material_cost,3,FALSE))","v":0.17333333333333334},{"$f":"I44*E44*C44","v":59.8},{"$f":"VLOOKUP($B44,printed_material_cost,5,FALSE)","v":"N/A"},1,{"$f":"$B$29&\" - \"&$B$40&\" - \"&B44","v":"Public Education - Printed Material - Meeting handouts"},1,1,1,1,1,1,1,1,1]
["2.3.5","Billing mailers",{"$f":"VLOOKUP(B45,ed_material,treat_select+3,FALSE)","v":2},"pages/household",{"$f":"hh_select","v":115},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_print_cost),VLOOKUP($B45,printed_material_cost,3,FALSE),user_print_cost),VLOOKUP($B45,printed_material_cost,3,FALSE))","v":0.17333333333333334},{"$f":"I45*E45*C45","v":39.866666666666667},{"$f":"VLOOKUP($B45,printed_material_cost,5,FALSE)","v":"N/A"},1,{"$f":"$B$29&\" - \"&$B$40&\" - \"&B45","v":"Public Education - Printed Material - Billing mailers"},1,1,1,1,1,1,1,1,1]
[3,"Initial Year Monitoring 1"]
[3.1,"Sampling time",{"$f":"VLOOKUP(B47,initial_sample,treat_select+3,FALSE)","v":0.25},"hours/household",{"$f":"hh_select-IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":77},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I47*C47*E47","v":640.35437040441172},"N/A",null,{"$f":"$B$46&\" - \"&B47","v":"Initial Year Monitoring 1 - Sampling time"},1,1,1,1,1,1,1,1,1]
[3.2,"Sampling scheduling time",{"$f":"VLOOKUP(B48,initial_sample,treat_select+3,FALSE)","v":0},"hours/household",{"$f":"hh_select-IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":77},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I48*C48*E48","v":0},"N/A",null,{"$f":"$B$46&\" - \"&B48","v":"Initial Year Monitoring 1 - Sampling scheduling time"},1,1,1,1,1,1,1,1,1]
[3.3,"Analysis",{"$f":"VLOOKUP(B49,initial_sample,treat_select+3,FALSE)","v":1},"samples/household",{"$f":"hh_select-IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":77},"households",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_lab_cost),VLOOKUP($C5,lab_analysis_cost,3,FALSE),user_lab_cost),VLOOKUP($C5,lab_analysis_cost,3,FALSE))","v":29.672538247055797},{"$f":"I49*C49*E49","v":2284.7854450232962},"N/A",1,{"$f":"$B$46&\" - \"&B49","v":"Initial Year Monitoring 1 - Analysis"},1,1,1,1,1,1,1,1,1]
[3.4,"Analysis (total coliform)",{"$f":"C49","v":1},{"$f":"D49","v":"samples/household"},{"$f":"hh_select-IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":77},{"$f":"F49","v":"households"},null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tc_cost),VLOOKUP(\"Total coliform\",lab_analysis_cost,3,FALSE),user_tc_cost),VLOOKUP(\"Total coliform\",lab_analysis_cost,3,FALSE))","v":28.881270560467641},{"$f":"I50*C50*E50","v":2223.8578331560084},"N/A",1,{"$f":"$B$46&\" - \"&B50","v":"Initial Year Monitoring 1 - Analysis (total coliform)"},1,1,1,1,1,1,1,1,1]
[3.5,"Shipping",{"$f":"C49+C50","v":2},"samples/household",{"$f":"hh_select-IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":77},"households",null,null,null,{"$f":"IF(E49>0,IF(AND(user=1,user_shipping>0),user_shipping,VLOOKUP(Shipping_Category,Shipping_Capital,2,FALSE)),0)+IF(C50>0,IF(AND(user=1,user_shipping_coliform>0),user_shipping_coliform,VLOOKUP(\"Coliform\",Shipping_Capital,2,FALSE)),0)","v":543.57500000000005},"N/A",1,{"$f":"$B$46&\" - \"&B51","v":"Initial Year Monitoring 1 - Shipping"},1,1,1,1,1,1,1,1,1,null,10]
["Note 1. The initial year monitoring cost estimates take into account the annual monitoring cost estimates that will overlap during the first year by netting out the O&M cost."]
[]
["Direct Costs",null,"Amount ($)"]
[null,"Installed Treatment Equipment",{"$f":"SUM($J$24:$J$28)","v":80471.974402276319}]
[null,"Public Education Costs",{"$f":"SUM($J$31:$J$45)","v":972.19348039215686}]
[null,"Initial Year Monitoring Costs",{"$f":"SUM($J$47:$J$51)","v":5692.5726485837158}]
[null,"Total Direct Costs",{"$f":"SUM(C55:C57)","v":87136.740531252202}]
[]
["Add-On Costs",null,0,null,"Additional cost added to Total Capital Costs (Indirect Cost multipliers not applied)."]
[]
["Indirect Costs"]
[null,"Item","Amount ($)","Amount (%)","Guidance on Estimating Cost"]
[null,"Permitting",{"$f":"IF(AND(user=1,'User Input'!D68=\"$ fixed cost\"),VLOOKUP(B64,indirect_cost,treat_select+3,FALSE),D64*$C$55)","v":2414.1592320682894},{"$f":"IF(AND(user=1,'User Input'!D68=\"$ fixed cost\"),\"--\",VLOOKUP(B64,indirect_cost,treat_select+3,FALSE))","v":0.03},"Apply percentage to installed equipment only (not public education or initial sampling costs)"]
[null,"Pilot Testing",{"$f":"IF(AND(user=1,'User Input'!D69=\"$ fixed cost\"),VLOOKUP(B65,indirect_cost,treat_select+3,FALSE),D65*$C$55)","v":2414.1592320682894},{"$f":"IF(AND(user=1,'User Input'!D69=\"$ fixed cost\"),\"--\",VLOOKUP(B65,indirect_cost,treat_select+3,FALSE))","v":0.03},"Apply percentage to installed equipment only (not public education or initial sampling costs)"]
[null,"Legal",{"$f":"IF(AND(user=1,'User Input'!D70=\"$ fixed cost\"),VLOOKUP(B66,indirect_cost,treat_select+3,FALSE),D66*$C$55)","v":2414.1592320682894},{"$f":"IF(AND(user=1,'User Input'!D70=\"$ fixed cost\"),\"--\",VLOOKUP(B66,indirect_cost,treat_select+3,FALSE))","v":0.03},"Apply percentage to installed equipment only (not public education or initial sampling costs)"]
[null,"Engineering",{"$f":"IF(AND(user=1,'User Input'!D71=\"$ fixed cost\"),VLOOKUP(B67,indirect_cost,treat_select+3,FALSE),D67*$C$55)","v":12070.796160341448},{"$f":"IF(AND(user=1,'User Input'!D71=\"$ fixed cost\"),\"--\",VLOOKUP(B67,indirect_cost,treat_select+3,FALSE))","v":0.15},"Apply percentage to installed equipment only (not public education or initial sampling costs)"]
[null,"Contingency",{"$f":"IF(AND(user=1,'User Input'!D72=\"$ fixed cost\"),VLOOKUP(B68,indirect_cost,treat_select+3,FALSE),D68*$C$55)","v":8047.1974402276319},{"$f":"IF(AND(user=1,'User Input'!D72=\"$ fixed cost\"),\"--\",VLOOKUP(B68,indirect_cost,treat_select+3,FALSE))","v":0.1},"Apply percentage to installed equipment only (not public education or initial sampling costs)"]
[null,"Total Indirect Costs",{"$f":"SUM(C64:C68)","v":27360.471296773947}]
[null,"Placeholder",0]
["Total Capital Costs"]
[null,"Assumption","Value","Guidance"]
[null,"City Index for Total Capital Cost",1,"User adjustable. Can be used to adjust estimated costs to be more reflective of a specific geographical location"]
[]
[null,null,"Amount ($)"]
[null,"Total Capital Costs",{"$f":"(direct_cost*(1+indirect_cost_mult)+addon_cost+indirect_cost_add)*city_index","v":114497.21182802615}]
[null,"Total Capital Costs (Rounded)",{"$f":"ROUND(C76,0)","v":114497}]
[]
["Operating and Maintenance Costs"]
[null,"Assumption","Value","Guidance"]
[null,"City Index for Total O&M Cost",1,"User adjustable. Can be used to adjust estimated costs to be more reflective of a specific geographical location"]
[]
[null,"Item","Quantity",null,"Frequency",null,null,null,"Unit Cost","Total Cost"]
[null,"Labor"]
[null,"Technical Labor"]
[null,"POU/POE Maintenance",{"$f":"INDEX(maint_time,1,treat_select)","v":0.5},"hours/household",{"$f":"INDEX(maint_frequency,1,treat_select)*hh_select","v":115},"household visits/year",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I86*E86*C86","v":1912.7468206885028},null,1]
[null,"UV Maintenance",{"$f":"uv*INDEX(UV_maint_time,1,treat_select)","v":0},"hours/household",{"$f":"uv*INDEX(UV_maint_frequency,1,treat_select)*hh_select","v":0},"household visits/year",null,null,{"$f":"uv*IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":0},{"$f":"I87*E87*C87","v":0},null,1]
[null,"Information updates",{"$f":"VLOOKUP(B88,tech_labor_om,treat_select+3,FALSE)","v":12},"hours/year",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I88*C88","v":399.18194518716575},null,1]
[null,"Nitrate information updates",{"$f":"nitrate_select*VLOOKUP(B89,tech_labor_om,treat_select+3,FALSE)","v":0},"hours/year",null,null,null,null,{"$f":"nitrate_select*IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":0},{"$f":"I89*C89","v":0},null,1]
[null,"Clerical Labor"]
[null,"Maintenance Scheduling",{"$f":"INDEX(maint_scheduling,1,treat_select)","v":0.5},"hours/household",{"$f":"INDEX(maint_frequency,1,treat_select)*hh_select","v":115},"household visits/year",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I91*E91*C91","v":1842.1440466243312},null,1]
[null,"Information updates",{"$f":"VLOOKUP(B92,clerical_labor_om,treat_select+3,FALSE)","v":12},"hours/year",null,null,null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I92*C92","v":384.44745320855611},null,1]
[null,"Nitrate information updates",{"$f":"nitrate_select*VLOOKUP(B93,clerical_labor_om,treat_select+3,FALSE)","v":0},"hours/year",null,null,null,null,{"$f":"nitrate_select*IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":0},{"$f":"I93*C93","v":0},null,1]
[null,"Materials"]
[null,{"$f":"IF(AND(user=1,'User Input'!C104>0),'User Input'!C104,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),1,1))","v":"Media Cartridge"},{"$f":"IF(AND(user=1,'User Input'!C106>0),'User Input'!C106,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),1,2))","v":1},"units/household",{"$f":"IF(C95>0,hh_select,0)","v":115},"households/year",null,null,{"$f":"IF(AND(user=1,'User Input'!C105>0),'User Input'!C105,IF(C95>0,VLOOKUP(B95,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0))","v":120.17839925490911},{"$f":"I95*E95*C95","v":13820.515914314548},null,1]
[null,{"$f":"IF(AND(user=1,'User Input'!C108>0),'User Input'!C108,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),2,1))","v":"NA"},{"$f":"IF(AND(user=1,'User Input'!C110>0),'User Input'!C110,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),2,2))","v":0},"units/household",{"$f":"IF(C96>0,hh_select,0)","v":0},"households/year",null,null,{"$f":"IF(AND(user=1,'User Input'!C109>0),'User Input'!C109,IF(C96>0,VLOOKUP(B96,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0))","v":0},0,null,1]
[null,{"$f":"IF(AND(user=1,'User Input'!C112>0),'User Input'!C112,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),3,1))","v":"NA"},{"$f":"IF(AND(user=1,'User Input'!C114>0),'User Input'!C114,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),3,2))","v":0},"units/household",0,"households/year",null,null,{"$f":"IF(AND(user=1,'User Input'!C113>0),'User Input'!C113,IF(C97>0,VLOOKUP(B97,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0))","v":0},0,null,1]
[null,{"$f":"IF(AND(user=1,'User Input'!C116>0),'User Input'!C116,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),4,1))","v":"NA"},{"$f":"IF(AND(user=1,'User Input'!C118>0),'User Input'!C118,INDEX(INDIRECT(VLOOKUP(treat_select,name_list,5,FALSE)),4,2))","v":0},"units/household",0,"households/year",null,null,{"$f":"IF(AND(user=1,'User Input'!C117>0),'User Input'!C117,IF(C98>0,VLOOKUP(B98,INDIRECT(VLOOKUP(treat_select,name_list,4,FALSE)),3,FALSE),0))","v":0},0,null,1]
[null,{"$f":"INDEX(pou_uv_replace,1,1)","v":"UV Lamp"},{"$f":"uv*IF(AND(user=1,user_uv_lamp_freq>0),user_uv_lamp_freq,IF(C7=\"POU\",INDEX(pou_uv_replace,1,2),INDEX(poe_uv_replace,1,2)))","v":0},"units/household",0,"households/year",null,null,{"$f":"uv*IF(AND(user=1,user_uv_lamp>0),user_uv_lamp,IF(C7=\"POU\",VLOOKUP(B99,pou_uv_parts,3,FALSE),VLOOKUP(B99,poe_uv_parts,3,FALSE)))","v":0},0,null,1]
[null,{"$f":"INDEX(pou_uv_replace,2,1)","v":"UV Quartz Sleeve"},{"$f":"uv*IF(AND(user=1,user_uv_sleeve>0),user_uv_sleeve,IF(C7=\"POU\",INDEX(pou_uv_replace,2,2),INDEX(poe_uv_replace,2,2)))","v":0},"units/household",0,"households/year",null,null,{"$f":"uv*IF(AND(user=1,user_uv_sleeve_freq>0),user_uv_sleeve_freq,IF(C7=\"POU\",VLOOKUP(B100,pou_uv_parts,3,FALSE),VLOOKUP(B100,poe_uv_parts,3,FALSE)))","v":0},0,null,1]
[null,"Nitrate awareness flyers",{"$f":"nitrate_select*VLOOKUP(B101,ed_material_om,treat_select+3,FALSE)","v":0},"flyers/year",null,null,null,null,{"$f":"nitrate_select*IF(user=1,IF(ISBLANK(user_flyer_cost),VLOOKUP($B101,printed_material_cost,3,FALSE),user_flyer_cost),VLOOKUP($B101,printed_material_cost,3,FALSE))","v":0},{"$f":"I101*C101","v":0},null,1]
[null,"Billing mailers",{"$f":"VLOOKUP(B102,ed_material_om,treat_select+3,FALSE)","v":3},"pages/household",115,"households/year",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_print_cost),VLOOKUP($B102,printed_material_cost,3,FALSE),user_print_cost),VLOOKUP($B102,printed_material_cost,3,FALSE))","v":0.17333333333333334},{"$f":"I102*E102*C102","v":59.8},null,1]
[null,"Laboratory Analysis"]
[null,"Sampling time",{"$f":"VLOOKUP(B104,lab_analysis,treat_select+3,FALSE)","v":0.25},"hours/household",{"$f":"IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":38},"households/year",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_tech_rate),tech_rate,user_tech_rate),tech_rate)","v":33.265162098930482},{"$f":"I104*E104*C104","v":316.01903993983956},null,1]
[null,"Sampling scheduling time",{"$f":"VLOOKUP(B105,lab_analysis,treat_select+3,FALSE)","v":0},"hours/household",{"$f":"IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":38},"households/year",null,null,{"$f":"IF(user=1,IF(ISBLANK(user_cler_rate),clerical_rate,user_cler_rate),clerical_rate)","v":32.037287767379674},{"$f":"I105*E105*C105","v":0},null,1]
[null,"Analysis",{"$f":"VLOOKUP(B106,lab_analysis,treat_select+3,FALSE)","v":1},"samples/household",{"$f":"IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":38},"households/year",null,null,{"$f":"IF(AND(user=1,user_lab_cost>0),user_lab_cost,VLOOKUP(C5,lab_analysis_cost,3,FALSE))","v":29.672538247055797},{"$f":"I106*E106*C106","v":1127.5564533881202},null,1]
[null,"Analysis (total coliform)",{"$f":"C106","v":1},"samples/household",{"$f":"E106","v":38},"households/year",null,null,{"$f":"IF(AND(user=1,user_tc_cost>0),user_tc_cost,VLOOKUP(\"Total coliform\",lab_analysis_cost,3,FALSE))","v":28.881270560467641},{"$f":"I107*E107*C107","v":1097.4882812977703}]
[null,"Shipping",{"$f":"C106","v":1},"samples/household",{"$f":"IF(nitrate_select=1,hh_select,ROUND(hh_select*VLOOKUP(\"Frequency\",lab_analysis,treat_select+3,FALSE),0))","v":38},"households/year",null,null,null,{"$f":"IF(E106>0,IF(AND(user=1,user_shipping>0),user_shipping,VLOOKUP(Shipping_Category,Shipping_OM,2,FALSE)),0)+IF(C107>0,IF(AND(user=1,user_shipping_coliform>0),user_shipping_coliform,VLOOKUP(\"Coliform\",Shipping_OM,2,FALSE)),0)","v":275.95},null,1]
[]
["Total O&M costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J86:J109)*OM_City_Index","v":21235.849954648831}]
[]
[{"$f":"\"Annualized Capital Costs (per year over \"&discount_period&\" years at \"&discount_rate*100&\"% discount rate)\"","v":"Annualized Capital Costs (per year over 10 years at 7% discount rate)"},null,null,null,null,null,null,null,null,{"$f":"PMT(discount_rate,discount_period,-$C$76)","v":16301.82708932045}]
["Total Annualized Costs = Annualized Capital Costs + O&M costs",null,null,null,null,null,null,null,null,{"$f":"$J$110+J112","v":37537.677043969277}]
["Average Unit Cost ($/kgal, based on average production equivalent for centralized treatment)",null,null,null,null,null,null,null,null,{"$f":"J113/average_annual_production","v":3.9327058191691227}]
["Average Annual Cost per Household",null,null,null,null,null,null,null,null,{"$f":"J113/hh_select","v":326.41458299103721}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,0]

{"sheet":"Control","index":4,"n_rows":64,"n_cols":25,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"To add new contaminants, insert into this table a column after the last column with data in it and before the yellow column. Then, highlight the list of treatment technologies and insert a range name using the contaminant's name."]
[null,"To add certified technologies for a contaminant, insert into this table a row between the last row with data in it and the yellow row, and copy a POU or POE technology name from Table 2. "]
[null,"This will preserve the range names used in the input sheet and validity checks."]
[null,"Table 1. Treatment Technologies Certified to Remove a Contaminant"]
[null,"Radium","Arsenic","SOCs","Nitrate","Barium","Cadmium","Chromium","Copper","Fluoride","Mercury","VOCs","Perchlorate","PFAS"]
[null,"POU Reverse Osmosis","POU Adsorptive Media NSF53","POU GAC","POU Reverse Osmosis","POU Reverse Osmosis","POU Reverse Osmosis","POU Reverse Osmosis","POU GAC","POU Reverse Osmosis","POU GAC","POU GAC","POU Reverse Osmosis","POU Reverse Osmosis"]
[null,"POU RO Rental","POU Reverse Osmosis",null,"POU RO Rental","POU RO Rental","POU RO Rental","POU RO Rental","POU Reverse Osmosis","POU RO Rental"]
[null,"POE Cation Exchange","POU RO Rental",null,null,"POE Cation Exchange",null,null,"POU RO Rental"]
[]
[]
[null,"Table 2. Range Name Control Table"]
[null,"Treatment Technology","Technology Number",null,"Equipment price range","Parts price range","Replacement frequency range"]
[null,"POU RO Rental",1,null,"pou_rorental_equipment","pou_rorental_parts","pou_rorental_replace"]
[null,"POU Adsorptive Media NSF53",2,null,"pou_ads_nsf53_equipment","pou_ads_nsf53_parts","pou_ads_nsf53_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"(1388+V14*488.5)/V14","v":1876.5},{"$f":"(0.08558*V14^1.0584)/1000","v":8.5580000000000004E-5},{"$f":"PMT(7%,10,-(1388+V14*488.5))/(X14*1000*365)","v":8.5531244935572541}]
[null,"POU Anion Exchange",3,null,"pou_ax_equipment","pou_ax_parts","pou_ax_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(1388+V15*488.5)/V15","v":1182.5},{"$f":"(0.08558*V15^1.0584)/1000","v":1.7823066584313617E-4},{"$f":"PMT(7%,10,-(1388+V15*488.5))/(X15*1000*365)","v":5.1760352139135737}]
[null,"POU Cation Exchange",4,null,"pou_cx_equipment","pou_cx_parts","pou_cx_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,951.16666666666663,2.7375207398830516E-4,4.0660148974637291]
[null,"POU GAC",5,null,"pou_gac_equipment","pou_gac_parts","pou_gac_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,835.5,3.7118684560513742E-4,3.5120636275982964]
[null,"POU Reverse Osmosis",6,null,"pou_ro_equipment","pou_ro_parts","pou_ro_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,766.1,4.7006956646615365E-4,3.1786436190079095]
[null,"POE Adsorptive Media",7,null,"poe_ads_equipment","poe_ads_parts","poe_ads_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,719.83333333333337,5.7012169225140337E-4,2.9550453162537291]
[null,"POE Anion Exchange",8,null,"poe_ax_equipment","poe_ax_parts","poe_ax_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,686.78571428571433,6.7115688188333351E-4,2.7941116234472951]
[null,"POE Cation Exchange",9,null,"poe_cx_equipment","poe_cx_parts","poe_cx_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,662,7.7304134896491027E-4,2.6723525928305083]
[null,"POE Aeration",10,null,"poe_aer_equipment","poe_aer_parts","poe_aer_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,642.72222222222217,8.7567419973005954E-4,2.5767469938155605]
[null,"POE GAC with Auto-Backwash",11,null,"poe_gac_bw_equipment","poe_gac_bw_parts","poe_gac_bw_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,627.29999999999995,9.7897653451573885E-4,2.4994906250448481]
[null,"POE GAC w/out Auto-Backwash",12,null,"poe_gac_equipment","poe_gac_parts","poe_gac_replace",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,557.9,2.0388366393029453E-3,2.1347766028454833]
[null,"User Define",13,null,"user_equipment",{"$f":"VLOOKUP(user_treat_select,name_list,4,FALSE)","v":"pou_gac_parts"},{"$f":"VLOOKUP(user_treat_select,name_list,5,FALSE)","v":"pou_gac_replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,534.76666666666665,3.1315360681183351E-3,1.9983735466969641]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,523.20000000000005,4.2461230634300764E-3,1.9225766190835689]
[null,"Control Section (selects range values based on design approach)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,516.26,5.3772736055194047E-3,1.8725130515237429]
[null,"Selected User mode","user",{"$f":"IF(user_I=\"User-Defined System\",1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,511.63333333333333,6.5218013383095009E-3,1.8360775606667232]
[null,"Selected Contaminant","contam",{"$f":"IF(user=1,contam_user,contam_stand)","v":"Arsenic"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,505.85,8.8430631087525035E-3,1.7850793404003289]
[null,"Selected Treatment Column","treat_select",{"$f":"IF(user=1,13,VLOOKUP(treat,system_assign,2,FALSE))","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,503.92222222222222,1.0017112566213793E-2,1.7660865073441248]
[null,"Selected Component Level","component_level",{"$f":"IF(component_level_I=\"high cost\",2,IF(component_level_I=\"mid cost\",1,\"\"))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,502.38,1.119882046193557E-2,1.7498812037207621]
[null,"If User Defined, Default Column","user_treat_select",{"$f":"VLOOKUP(user_treat,system_assign,2,FALSE)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,501.11818181818182,1.2387460998081088E-2,1.7357974743946658]
[null,"Households for user input sheet",null,{"$f":"ROUND(IF(user_design=\"average flow\",IF(user_source_select=\"ground water\",(((user_flow/1000)/(0.08558))^(1/1.0584)),(((user_flow/1000)/(0.14004))^(1/0.99703)))/hh_size,user_pop),0)","v":25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,499.60399999999998,1.4182142340987854E-2,1.7176812963509818]
[null,"Households from selected mode (rounded)","hh_select",{"$f":"ROUND(IF(user=1,D33,hh_stand),0)","v":115},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,497.75333333333333,1.7200745523644648E-2,1.6931938102557731]
[null,"Design flow units","df_units",{"$f":"IF(user=1,\"\",IF(INPUT!D27=\"MGD\",1,2))","v":1},"1=million gallons per day; 2=gallons per minute"]
[null,"Average flow units","af_units",{"$f":"IF(user=1,\"\",IF(INPUT!D28=\"MGD\",1,2))","v":1},"1=million gallons per day; 2=gallons per minute"]
[null,"Shipping Category","Shipping_Category",{"$f":"VLOOKUP(contam,Shipping_Choices,2,FALSE)","v":"IOCs"}]
[]
[null,null,"uv",{"$f":"IF(user=1,IF(uv_user_select=\"yes\",1,0),IF(uv_select=\"yes\",1,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,496.43142857142857,2.0249008042702892E-2,1.6735630205722414]
[null,null,"nitrate_select",{"$f":"IF(contam=\"nitrate\",1,0)","v":0}]
[]
[null,null,"average_annual_production",{"$f":"hh_select*IF(hh_select<500,83000,IF(hh_select<3300,85000,89000))/1000","v":9545},"kgal/year"]
[null,null,"average_flow_production",{"$f":"average_annual_production/365/1000","v":2.6150684931506848E-2},"mgd"]
[]
[null,null,null,"Min Number Households","Max Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)"]
[null,null,"user_equipment",0,1000,{"$f":"IF(user_unit_cost=\"\",VLOOKUP(hh_select,INDIRECT(VLOOKUP(user_treat_select,name_list,3,FALSE)),3),user_unit_cost)","v":395.21185316167197},10,10]
[null,null,"user_uv_equipment",0,1000,{"$f":"IF(user_uv_cost=\"0\",VLOOKUP(hh_select,pou_uv_equipment,3),user_uv_cost)","v":0},10,10]
[]
[]
[null,"Treatment Technology","Treatment Shipping Category"]
[null,"Radium","Radionuclides"]
[null,"Arsenic","IOCs"]
[null,"SOCs","SOCs"]
[null,"Nitrate","IOCs"]
[null,"Barium","IOCs"]
[null,"Cadmium","IOCs"]
[null,"Chromium","IOCs"]
[null,"Copper","IOCs"]
[null,"Fluoride","IOCs"]
[null,"Lead","IOCs"]
[null,"Mercury","IOCs"]
[null,"VOCs","VOCs"]
[null,"Perchlorate","SOCs"]
[null,"PFAS","SOCs"]

{"sheet":"Price Tables","index":5,"n_rows":541,"n_cols":58,"rows_kept":541,"cut":false,"hidden":false,"merged":[]}
["Price Tables"]
["Instructions: Do not revise information in gray cells. Enter price data in yellow cells only. Copy formulas as needed."]
["POU and POE Device Prices"]
["Price Tables for NSF-approved devices. Mention of a vendor or product does not constitute an endorsement. "]
[null,"POU RO Rental Equipment"]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
["pou_rorental_equipment",0,4,0,10,10,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L7=\"Source\",L7,IF(ISBLANK(L7),\"\",\"Vendor 1\"))","v":""},{"$f":"IF(S7=\"Source\",S7,IF(ISBLANK(S7),\"\",\"Vendor 2\"))","v":""},{"$f":"IF(Z7=\"Source\",Z7,IF(ISBLANK(Z7),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG7=\"Source\",AG7,IF(ISBLANK(AG7),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN7=\"Source\",AN7,IF(ISBLANK(AN7),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU7=\"Source\",AU7,IF(ISBLANK(AU7),\"\",\"Vendor 6\"))","v":""}]
[null,5,15,0,10,10,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L8=\"Source\",L8,IF(ISBLANK(L8),\"\",\"Vendor 1\"))","v":""},{"$f":"IF(S8=\"Source\",S8,IF(ISBLANK(S8),\"\",\"Vendor 2\"))","v":""},{"$f":"IF(Z8=\"Source\",Z8,IF(ISBLANK(Z8),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG8=\"Source\",AG8,IF(ISBLANK(AG8),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN8=\"Source\",AN8,IF(ISBLANK(AN8),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU8=\"Source\",AU8,IF(ISBLANK(AU8),\"\",\"Vendor 6\"))","v":""}]
[null,16,24,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU RO Rental Annual O&M Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_rorental_parts","Annual Rental Cost",null,{"$f":"IF(AVERAGE(K15,R15,Y15,AF15,AM15,AT15)=0,\"contact vendor\",AVERAGE(K15,R15,Y15,AF15,AM15,AT15))","v":344.48456425964366},"N/A","N/A",{"$f":"24.95*12","v":299.39999999999998},{"$f":"G15*M15","v":299.39999999999998},{"$f":"H15","v":299.39999999999998},2011,{"$f":"I15*VLOOKUP(J15,cci_table,3,FALSE)","v":344.48456425964366},"Cost Less Water Systems, 4-stage RO system rental rate ($24.95/mo). Prices online; accessed 2-1-11 (www.costlesswater.com).",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Adsorptive Media NSF53 Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["pou_ads_nsf53_equipment",0,4,{"$f":"IF(AVERAGE(K19,R19,Y19,AF19,AM19,AT19)=0,\"contact vendor\",AVERAGE(K19,R19,Y19,AF19,AM19,AT19))","v":598.24565526653896},10,10,519.95000000000005,{"$f":"G19*M19","v":519.95000000000005},{"$f":"H19","v":519.95000000000005},2011,{"$f":"I19*VLOOKUP(J19,cci_table,3,FALSE)","v":598.24565526653896},"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,5,15,598.24565526653896,10,10,519.95000000000005,519.95000000000005,{"$f":"H20","v":519.95000000000005},2011,598.24565526653896,"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,16,24,598.24565526653896,10,10,519.95000000000005,519.95000000000005,519.95000000000005,2011,598.24565526653896,"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,25,50,598.24565526653896,10,10,519.95000000000005,519.95000000000005,519.95000000000005,2011,598.24565526653896,"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,51,100,598.24565526653896,10,10,519.95000000000005,519.95000000000005,519.95000000000005,2011,598.24565526653896,"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,101,500,598.24565526653896,10,10,519.95000000000005,519.95000000000005,519.95000000000005,2011,598.24565526653896,"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,501,1000,598.24565526653896,10,10,519.95000000000005,519.95000000000005,519.95000000000005,2011,598.24565526653896,"Multi Pure MP880SB, Multi-Pure Drinking Water 2-15-11",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,"POU Adsorptive Media NSF53 Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_ads_nsf53_parts","Media Cartridge",null,{"$f":"IF(AVERAGE(K27,R27,Y27,AF27,AM27,AT27)=0,\"contact vendor\",AVERAGE(K27,R27,Y27,AF27,AM27,AT27))","v":120.17839925490911},"N/A","N/A",104.45,{"$f":"G27*M27","v":104.45},{"$f":"H27","v":104.45},2011,{"$f":"I27*VLOOKUP(J27,cci_table,3,FALSE)","v":120.17839925490911},"Multi Pure CB11As, replacement cartridge for MP880SB, Multi-Pure Drinking Water 2-15-11",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Anion Exchange Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["pou_ax_equipment",0,4,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Anion Exchange Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_ax_parts","Sediment Pre-Filter",null,0,"N/A","N/A",0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Cation Exchange Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["pou_cx_equipment",0,4,0,10,10,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,null,null,null,null,null,null,{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Cation Exchange Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_cx_parts","Item",null,0,"N/A","N/A",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Granular Activated Carbon Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["pou_gac_equipment",0,4,{"$f":"IF(AVERAGE(K55,R55,Y55,AF55,AM55,AT55)=0,\"contact vendor\",AVERAGE(K55,R55,Y55,AF55,AM55,AT55))","v":395.21185316167197},10,10,349,{"$f":"G55*M55","v":349},{"$f":"H55","v":349},2011,{"$f":"I55*VLOOKUP(J55,cci_table,3,FALSE)","v":401.55348338882982},"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,389.95,{"$f":"N55*T55","v":389.95},{"$f":"O55","v":389.95},2011,{"$f":"P55*VLOOKUP(Q55,cci_table,3,FALSE)","v":448.66985916181716},"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,{"$f":"U55*AA55","v":379.99},{"$f":"V55","v":379.99},2011,{"$f":"W55*VLOOKUP(X55,cci_table,3,FALSE)","v":437.21005201410162},"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,298,{"$f":"AB55*AH55","v":298},{"$f":"AC55","v":298},2011,{"$f":"AD55*VLOOKUP(AE55,cci_table,3,FALSE)","v":342.87374799390057},"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,298,{"$f":"AI55*AO55","v":298},{"$f":"AJ55","v":298},2011,{"$f":"AK55*VLOOKUP(AL55,cci_table,3,FALSE)","v":342.87374799390057},"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,345.99,{"$f":"AP55*AV55","v":345.99},{"$f":"AQ55","v":345.99},2011,{"$f":"AR55*VLOOKUP(AS55,cci_table,3,FALSE)","v":398.09022841748208},"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,5,15,395.21185316167197,10,10,349,349,{"$f":"H56","v":349},2011,401.55348338882982,"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,389.95,389.95,{"$f":"O56","v":389.95},2011,448.66985916181716,"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,379.99,{"$f":"V56","v":379.99},2011,437.21005201410162,"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,298,298,{"$f":"AC56","v":298},2011,342.87374799390057,"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,298,298,{"$f":"AJ56","v":298},2011,342.87374799390057,"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,345.99,{"$f":"AP56*AV56","v":345.99},{"$f":"AQ56","v":345.99},2011,398.09022841748208,"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,16,24,395.21185316167197,10,10,349,349,349,2011,401.55348338882982,"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},389.95,389.95,389.95,2011,448.66985916181716,"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,379.99,379.99,2011,437.21005201410162,"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},345.99,345.99,345.99,2011,398.09022841748208,"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,25,50,395.21185316167197,10,10,349,349,349,2011,401.55348338882982,"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},389.95,389.95,389.95,2011,448.66985916181716,"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,379.99,379.99,2011,437.21005201410162,"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},345.99,345.99,{"$f":"AQ58","v":345.99},2011,398.09022841748208,"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,51,100,395.21185316167197,10,10,349,349,349,2011,401.55348338882982,"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},389.95,389.95,389.95,2011,448.66985916181716,"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,379.99,379.99,2011,437.21005201410162,"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},345.99,345.99,345.99,2011,398.09022841748208,"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,101,500,395.21185316167197,10,10,349,349,349,2011,401.55348338882982,"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},389.95,389.95,389.95,2011,448.66985916181716,"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,379.99,379.99,2011,437.21005201410162,"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},345.99,345.99,345.99,2011,398.09022841748208,"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,501,1000,395.21185316167197,10,10,349,349,349,2011,401.55348338882982,"Alloy Safe (www.alloysafe.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},389.95,389.95,389.95,2011,448.66985916181716,"Super Water (www.superwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,379.99,379.99,379.99,2011,437.21005201410162,"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Aqua Pure Filters (www.aquapurefilters.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},298,298,298,2011,342.87374799390057,"Filter Fast (www.filterfast.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",{"$f":"$M$67","v":1},345.99,345.99,345.99,2011,398.09022841748208,"eFilter Water (www.efilterwater.com). Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,"POU Granular Activated Carbon Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_gac_parts","Media Cartridge",null,{"$f":"IF(AVERAGE(K63,R63,Y63,AF63,AM63,AT63)=0,\"contact vendor\",AVERAGE(K63,R63,Y63,AF63,AM63,AT63))","v":187.81427308737034},"N/A","N/A",236.24,{"$f":"G63*M63","v":236.24},{"$f":"H63","v":236.24},2011,{"$f":"I63*VLOOKUP(J63,cci_table,3,FALSE)","v":271.81373901368818},"Alloy Safe (www.alloysafe.com) Replacement filter cartridge set, Model EV9282-01, for Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,193.95,193.95,193.95,2011,223.15558195777518,"Super Water (www.superwater.com) Replacement filter cartridge set, model EV9282-01, for Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,169.99,{"$f":"U63*AA63","v":169.99},{"$f":"V63","v":169.99},2011,{"$f":"W63*VLOOKUP(X63,cci_table,3,FALSE)","v":195.58761215262805},"Big Brand Water Filter (www.bigbrandwater.com) Everpure H-1200 Water Filtration System, Model EV9282-00. Prices online, accessed on 2/2/11.",1,96,{"$f":"AB63*AH63","v":96},{"$f":"AC63","v":96},2011,{"$f":"AD63*VLOOKUP(AE63,cci_table,3,FALSE)","v":110.45597250810219},"Aqua Pure Filters (www.aquapurefilters.com). Replacement filter cartridge set, model AP-DW 80/90, for Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,96,{"$f":"AI63*AO63","v":96},96,2011,null,"Filter Fast (www.filterfast.com). Replacement filter cartridge set, model AP-DW 80/90, for Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,119.99,{"$f":"AP63*AV63","v":119.99},{"$f":"AQ63","v":119.99},2011,138.05845980465813,"eFilter Water (www.efilterwater.com). Replacement filter cartridge set, model AP-DW 80/90, for Aqua Pure Drinking Water System, Model AP-DWS1000. Prices online; accessed on 2/2/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Reverse Osmosis Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["pou_ro_equipment",0,4,{"$f":"IF(AVERAGE(K67,R67,Y67,AF67,AM67,AT67)=0,\"contact vendor\",AVERAGE(K67,R67,Y67,AF67,AM67,AT67))","v":211.62666666666667},10,10,179.99,{"$f":"G67*M67","v":179.99},{"$f":"H67","v":179.99},2021,{"$f":"I67*VLOOKUP(J67,cci_table,3,FALSE)","v":179.99},"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,{"$f":"N67*T67","v":194.89},{"$f":"O67","v":194.89},2021,{"$f":"P67*VLOOKUP(Q67,cci_table,3,FALSE)","v":194.89},"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,{"$f":"U67*AA67","v":260},{"$f":"V67","v":260},2021,{"$f":"W67*VLOOKUP(X67,cci_table,3,FALSE)","v":260},"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,5,15,{"$f":"IF(AVERAGE(K68,R68,Y68,AF68,AM68,AT68)=0,\"contact vendor\",AVERAGE(K68,R68,Y68,AF68,AM68,AT68))","v":211.62666666666667},10,10,179.99,{"$f":"G68*M68","v":179.99},{"$f":"H68","v":179.99},2021,179.99,"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,194.89,{"$f":"O68","v":194.89},2021,194.89,"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,260,{"$f":"V68","v":260},2021,260,"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,16,24,211.62666666666667,10,10,179.99,179.99,179.99,2021,179.99,"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,194.89,194.89,2021,194.89,"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,260,260,2021,260,"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,25,50,211.62666666666667,10,10,179.99,179.99,179.99,2021,179.99,"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,194.89,194.89,2021,194.89,"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,260,260,2021,260,"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,51,100,211.62666666666667,10,10,179.99,179.99,179.99,2021,179.99,"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,194.89,194.89,2021,194.89,"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,260,260,2021,260,"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,101,500,211.62666666666667,10,10,179.99,179.99,179.99,2021,179.99,"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,194.89,194.89,2021,194.89,"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,260,260,2021,260,"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L72=\"Source\",L72,IF(ISBLANK(L72),\"\",\"Vendor 1\"))","v":"Vendor 1"},{"$f":"IF(S72=\"Source\",S72,IF(ISBLANK(S72),\"\",\"Vendor 2\"))","v":"Vendor 2"},{"$f":"IF(Z72=\"Source\",Z72,IF(ISBLANK(Z72),\"\",\"Vendor 3\"))","v":"Vendor 3"},{"$f":"IF(AG72=\"Source\",AG72,IF(ISBLANK(AG72),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN72=\"Source\",AN72,IF(ISBLANK(AN72),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU72=\"Source\",AU72,IF(ISBLANK(AU72),\"\",\"Vendor 6\"))","v":""}]
[null,501,1000,211.62666666666667,10,10,179.99,179.99,179.99,2021,179.99,"Express Water RO5DX Five-Stage RO System, 50 GPD (www.expresswater.com). Called and verififed certified for PFAS under NSF 58, as website has not been updated to reflect most recent testing.",1,194.89,194.89,194.89,2021,194.89,"ISPRING RCC7  5-Stage 75GPD RO System (www.homedepot.com). NSF certified in 2019 after the addition of PFAS chemicals to the standard according to Nick L. with iSpring .",1,260,260,260,2021,260,"APEC Water Systems, 5-Stage 50 GPD RO System - ROES-50 (www.freedrinkingwater.com). Specifically lists PFOA and PFOS on model, NSF 58 certified through WQA. Confirmed NSF 58 2019 here: https://www.wqa.org/find-products/ctl/detail/mid/1054/cid/apec_water_systems/sid/5",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"POU Reverse Osmosis Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_ro_parts","Sediment Pre-Filter",null,{"$f":"IF(AVERAGE(K75,R75,Y75,AF75,AM75,AT75)=0,\"contact vendor\",AVERAGE(K75,R75,Y75,AF75,AM75,AT75))","v":9.6333333333333329},"N/A","N/A",9.99,9.99,9.99,2021,9.99,"Express Water 5 Micron Sediment Filter, 6 month replacement",1,8.92,{"$f":"N75*T75","v":8.92},{"$f":"O75","v":8.92},2021,{"$f":"P75*VLOOKUP(Q75,cci_table,3,FALSE)","v":8.92},"ISPRING FP15 Sediment Filter, 6-12 month replacement",1,9.99,{"$f":"U75*AA75","v":9.99},{"$f":"V75","v":9.99},2021,{"$f":"W75*VLOOKUP(X75,cci_table,3,FALSE)","v":9.99},"APEC Water Systems, FP15 Sediment Filter, 6-12 month replacement",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Pre-GAC Filter Cartridge",null,{"$f":"IF(AVERAGE(K76,R76,Y76,AF76,AM76,AT76)=0,\"contact vendor\",AVERAGE(K76,R76,Y76,AF76,AM76,AT76))","v":16.47},"N/A","N/A",24.99,24.99,24.99,2021,24.99,"Express Water GAC Pre-filter, 6 month replacement, SKU# FLTGAC0501",1,10.47,{"$f":"N76*T76","v":10.47},{"$f":"O76","v":10.47},2021,{"$f":"P76*VLOOKUP(Q76,cci_table,3,FALSE)","v":10.47},"ISPRING FG15 GAC Filter, 6-12 month replacement",1,13.95,{"$f":"U76*AA76","v":13.95},{"$f":"V76","v":13.95},2021,{"$f":"W76*VLOOKUP(X76,cci_table,3,FALSE)","v":13.95},"APEC Water Systems, FG15 GAC Filter, 6-12 month replacement",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Post-GAC Filter Cartridge",null,{"$f":"IF(AVERAGE(K77,R77,Y77,AF77,AM77,AT77)=0,\"contact vendor\",AVERAGE(K77,R77,Y77,AF77,AM77,AT77))","v":12.143333333333333},"N/A","N/A",12.99,12.99,12.99,2021,12.99,"Express Water GAC Post-filter, 6 month replacement, SKU# FLTIN01PKQ",1,10.45,{"$f":"N77*T77","v":10.45},{"$f":"O77","v":10.45},2021,{"$f":"P77*VLOOKUP(Q77,cci_table,3,FALSE)","v":10.45},"ISPRING FT15 Pst final filter 12 month replacement",1,12.99,{"$f":"U77*AA77","v":12.99},{"$f":"V77","v":12.99},2021,{"$f":"W77*VLOOKUP(X77,cci_table,3,FALSE)","v":12.99},"APEC Water Systems, FT15 Pst final filter 12 month replacement",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"RO Membrane",null,{"$f":"IF(AVERAGE(K78,R78,Y78,AF78,AM78,AT78)=0,\"contact vendor\",AVERAGE(K78,R78,Y78,AF78,AM78,AT78))","v":31.493333333333329},"N/A","N/A",19.989999999999998,19.989999999999998,19.989999999999998,2021,19.989999999999998,"Express Water 50 GPD RO Membrane; recommended replacement every 12 months. SKU# FLTMEME50",1,29.49,{"$f":"N78*T78","v":29.49},{"$f":"O78","v":29.49},2021,{"$f":"P78*VLOOKUP(Q78,cci_table,3,FALSE)","v":29.49},"ISPRING MC7 1-3 year replacement",1,45,{"$f":"U78*AA78","v":45},{"$f":"V78","v":45},2021,{"$f":"W78*VLOOKUP(X78,cci_table,3,FALSE)","v":45},"APEC Water Systems, MC7 1-3 year replacement",{"$f":"$M$67","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Ultraviolet Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["pou_uv_equipment",0,4,{"$f":"IF(AVERAGE(K82,R82,Y82,AF82,AM82,AT82)=0,\"contact vendor\",AVERAGE(K82,R82,Y82,AF82,AM82,AT82))","v":1364.3987710334802},10,10,1059,{"$f":"G82*M82","v":1059},{"$f":"H82","v":1059},2011,{"$f":"I82*VLOOKUP(J82,cci_table,3,FALSE)","v":1218.4674467300024},"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",1,1128,{"$f":"N82*T82","v":1128},{"$f":"O82","v":1128},2011,{"$f":"P82*VLOOKUP(Q82,cci_table,3,FALSE)","v":1297.8576769702008},"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,{"$f":"U82*AA82","v":1165.1300000000001},{"$f":"V82","v":1165.1300000000001},2011,{"$f":"W82*VLOOKUP(X82,cci_table,3,FALSE)","v":1340.5788255038033},"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,{"$f":"AB82*AH82","v":1391.2},{"$f":"AC82","v":1391.2},2011,{"$f":"AD82*VLOOKUP(AE82,cci_table,3,FALSE)","v":1600.6911349299144},"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,5,15,1364.3987710334802,10,10,1059,{"$f":"G83*M83","v":1059},1059,2011,1218.4674467300024,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",1,1128,{"$f":"N83*T83","v":1128},{"$f":"O83","v":1128},2011,{"$f":"P83*VLOOKUP(Q83,cci_table,3,FALSE)","v":1297.8576769702008},"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,{"$f":"U83*AA83","v":1165.1300000000001},{"$f":"V83","v":1165.1300000000001},2011,1340.5788255038033,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,{"$f":"AB83*AH83","v":1391.2},{"$f":"AC83","v":1391.2},2011,1600.6911349299144,"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,16,24,1364.3987710334802,10,10,1059,{"$f":"G84","v":1059},1059,2011,1218.4674467300024,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",{"$f":"$M$67","v":1},1128,1128,1128,2011,1297.8576769702008,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,1165.1300000000001,1165.1300000000001,2011,1340.5788255038033,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,1391.2,1391.2,2011,1600.6911349299144,"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,25,50,1364.3987710334802,10,10,1059,{"$f":"G85","v":1059},1059,2011,1218.4674467300024,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",{"$f":"$M$67","v":1},1128,1128,1128,2011,1297.8576769702008,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,1165.1300000000001,1165.1300000000001,2011,1340.5788255038033,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,1391.2,1391.2,2011,1600.6911349299144,"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,51,100,1364.3987710334802,10,10,1059,{"$f":"G86","v":1059},1059,2011,1218.4674467300024,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",{"$f":"$M$67","v":1},1128,1128,1128,2011,1297.8576769702008,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,1165.1300000000001,1165.1300000000001,2011,1340.5788255038033,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,1391.2,1391.2,2011,1600.6911349299144,"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,101,500,1364.3987710334802,10,10,1059,{"$f":"G87","v":1059},1059,2011,1218.4674467300024,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",{"$f":"$M$67","v":1},1128,1128,1128,2011,1297.8576769702008,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,1165.1300000000001,1165.1300000000001,2011,1340.5788255038033,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,1391.2,1391.2,2011,1600.6911349299144,"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,501,1000,1364.3987710334802,10,10,1059,{"$f":"G88","v":1059},1059,2011,1218.4674467300024,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",{"$f":"$M$67","v":1},1128,1128,1128,2011,1297.8576769702008,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,1165.1300000000001,1165.1300000000001,1165.1300000000001,2011,1340.5788255038033,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,1391.2,1391.2,1391.2,2011,1600.6911349299144,"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,"POU Ultraviolet Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["pou_uv_parts","UV Lamp",null,{"$f":"IF(AVERAGE(K90,R90,Y90,AF90,AM90,AT90)=0,\"contact vendor\",AVERAGE(K90,R90,Y90,AF90,AM90,AT90))","v":87.950568109576366},"N/A","N/A",72.03,{"$f":"G90","v":72.03},72.03,2011,{"$f":"I90*VLOOKUP(J90,cci_table,3,FALSE)","v":82.876496872485433},"RO Water Systems, Inc. (www.rosystems.com). UV Lamp replacement, Model S200RL-HO, for Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",1,null,null,null,null,null,null,null,71.69,71.69,71.69,2011,{"$f":"W90*VLOOKUP(X90,cci_table,3,FALSE)","v":82.485298636519232},"Freshwater Systems (www.freshwatersystems.com). UV Lamp replacement, Model S200RL-HO, for Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,85.6,85.6,85.6,2011,{"$f":"AD90*VLOOKUP(AE90,cci_table,3,FALSE)","v":98.489908819724448},"Home water Purifiers and Filters (www.home-water-purifiers-and-filters.com). UV Lamp replacement, Model S200RL, for Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","Vendor 3","Vendor 4","",""]
[null,"UV Quartz Sleeve",null,{"$f":"IF(AVERAGE(K91,R91,Y91,AF91,AM91,AT91)=0,\"contact vendor\",AVERAGE(K91,R91,Y91,AF91,AM91,AT91))","v":43.837214089153058},"N/A","N/A",37.799999999999997,{"$f":"G91","v":37.799999999999997},37.799999999999997,2011,{"$f":"I91*VLOOKUP(J91,cci_table,3,FALSE)","v":43.492039175065237},"RO Water Systems, Inc. (www.rosystems.com). UV Quartz Sleeve replacement, Model QS-200, for Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed on 2/3/11.",1,43,{"$f":"N91","v":43},{"$f":"O91","v":43},2011,{"$f":"P91*VLOOKUP(Q91,cci_table,3,FALSE)","v":49.475071019254109},"Excel Water Technologies Inc.(www.excelwater.com). UV Quartz Sleeve replacement, Model QS-150, for Sterilight Platinum NSF Certified UV Systems, Model SPV-2.5, 2.5 gpm. Prices online; ccessed 2/2/11.",1,33.5,33.5,33.5,2011,{"$f":"W91*VLOOKUP(X91,cci_table,3,FALSE)","v":38.544532073139827},"Freshwater Systems (www.freshwatersystems.com). UV Quartz Sleeve replacement, Model QS-200, for Sterilight Platinum NSF Certified UV Systems, Model SPV-200, 2.6 gpm. Prices online; accessed 2/3/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Adsorptive Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_ads_equipment",0,4,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Adsorptive Media Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_ads_parts","Sediment Pre-Filter",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L104=\"Source\",L104,IF(ISBLANK(L104),\"\",\"Vendor 1\"))","v":""},{"$f":"IF(S104=\"Source\",S104,IF(ISBLANK(S104),\"\",\"Vendor 2\"))","v":""},{"$f":"IF(Z104=\"Source\",Z104,IF(ISBLANK(Z104),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG104=\"Source\",AG104,IF(ISBLANK(AG104),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN104=\"Source\",AN104,IF(ISBLANK(AN104),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU104=\"Source\",AU104,IF(ISBLANK(AU104),\"\",\"Vendor 6\"))","v":""}]
[null,"POE Anion Exchange Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_ax_equipment",0,4,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Anion Exchange Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_ax_parts","Sediment Pre-Filter",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Cation Exchange Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_cx_equipment",0,4,{"$f":"IF(AVERAGE(K119,R119,Y119,AF119,AM119,AT119)=0,\"contact vendor\",AVERAGE(K119,R119,Y119,AF119,AM119,AT119))","v":826.53667289057626},10,10,488.97,{"$f":"G119*M119","v":488.97},{"$f":"H119","v":488.97},2011,{"$f":"I119*VLOOKUP(J119,cci_table,3,FALSE)","v":562.60059247173683},"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",1,1199,{"$f":"N119*T119","v":1199},{"$f":"O119","v":1199},2011,{"$f":"P119*VLOOKUP(Q119,cci_table,3,FALSE)","v":1379.549073304318},"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,{"$f":"AVERAGE(453,518,548)","v":506.33333333333331},{"$f":"U119*AA119","v":506.33333333333331},{"$f":"V119","v":506.33333333333331},2011,{"$f":"W119*VLOOKUP(X119,cci_table,3,FALSE)","v":582.57854944377505},"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,{"$f":"AB119*AH119","v":679.15},{"$f":"AC119","v":679.15},2011,{"$f":"AD119*VLOOKUP(AE119,cci_table,3,FALSE)","v":781.41847634247506},"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,5,15,826.53667289057626,10,10,488.97,488.97,488.97,2011,562.60059247173683,"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",1,1199,1199,1199,2011,1379.549073304318,"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,506.33333333333331,506.33333333333331,506.33333333333331,2011,582.57854944377505,"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,679.15,679.15,2011,781.41847634247506,"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,16,24,826.53667289057626,10,10,488.97,488.97,488.97,2011,562.60059247173683,"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",{"$f":"$M$67","v":1},1199,1199,1199,2011,1379.549073304318,"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,506.33333333333331,506.33333333333331,506.33333333333331,2011,582.57854944377505,"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,679.15,679.15,2011,781.41847634247506,"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,25,50,826.53667289057626,10,10,488.97,488.97,488.97,2011,562.60059247173683,"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",{"$f":"$M$67","v":1},1199,1199,1199,2011,1379.549073304318,"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,506.33333333333331,506.33333333333331,506.33333333333331,2011,582.57854944377505,"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,679.15,679.15,2011,781.41847634247506,"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,51,100,826.53667289057626,10,10,488.97,488.97,488.97,2011,562.60059247173683,"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",{"$f":"$M$67","v":1},1199,1199,1199,2011,1379.549073304318,"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,506.33333333333331,506.33333333333331,506.33333333333331,2011,582.57854944377505,"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,679.15,679.15,2011,781.41847634247506,"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,101,500,826.53667289057626,10,10,488.97,488.97,488.97,2011,562.60059247173683,"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",{"$f":"$M$67","v":1},1199,1199,1199,2011,1379.549073304318,"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,506.33333333333331,506.33333333333331,506.33333333333331,2011,582.57854944377505,"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,679.15,679.15,2011,781.41847634247506,"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,501,1000,699.97253772504246,10,10,48.97,48.97,48.97,2011,56.344051809601709,"Wal Mart (www.walmart.com) Morton System Saver Demand Water Softener, Model MSD34C. 34,000 grain capacity, 8 gpm. Prices online; accessed on 2/4/11. $0.97 shipping cost.",{"$f":"$M$67","v":1},1199,1199,1199,2011,1379.549073304318,"Premiere Sales (www.premieresales.com). GE ProSeries Performa LOGIX Water Softener, 25 gpm capacity; $2.99 shipping costs. Prices online; accessed on 2/4/11.",1,506.33333333333331,506.33333333333331,506.33333333333331,2011,582.57854944377505,"The Home Depot (www.homedepot.com). Waterboss ( www.waterboss.com) Water Softeners: Models 700, 900, and 950: (1) Model 700=$453; 70 grains per gallon, 16 gpm, 2.5 lbs of salt per regeneration, 19.5 minutes for regen, 16.4 gal used per regen; (2) Model 900=$518; 90 grains per gallon, 10gpm, 6 lbs of salt per regeneration, 20 minutes for regen, 14 gal used per regen; and (3) Model 950=$548; 35 grains per gallon, 8 gpm, 2.5 lbs of salt per regeneration, 17 minutes for regen, 14 gal used per regen.",1,679.15,679.15,679.15,2011,781.41847634247506,"Sears, Roebuck and Co. (http://www.sears.com). Kenmore Elite 420 Searies Water Softener, Model M38426, 9.5 gpm, High resin capacity- 1.20, valve fits 1-1/4\" plumbing, salt efficiency- 5,010 grains at 2.5 lbs. salt, electronic demand initiated regeneration. Prices online; accessed on 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,"POE Cation Exchange Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_cx_parts","Sodium Chloride","$/lb",{"$f":"IF(AVERAGE(K127,R127,Y127,AF127,AM127,AT127)=0,\"contact vendor\",AVERAGE(K127,R127,Y127,AF127,AM127,AT127))","v":0.15110990683400091},"N/A","N/A",{"$f":"7.49/40","v":0.18725},{"$f":"G127*M127","v":0.18725},{"$f":"H127","v":0.18725},2011,{"$f":"I127*VLOOKUP(J127,cci_table,3,FALSE)","v":0.21544667554314725},"Ace Hardware, Diamond Crystal Pellets sold in 40-lb bags for $7.49/bag online at http://www.acehardware.com/family/index.jsp?categoryId=1367182&cp=1254884. Prices online; accessed on 2/4/11.",1,{"$f":"4.38/40","v":0.1095},{"$f":"N127*T127","v":0.1095},{"$f":"O127","v":0.1095},2011,{"$f":"P127*VLOOKUP(Q127,cci_table,3,FALSE)","v":0.12598884364205407},"Sam's Club (www.samsclub.com). Morton System Saver Pellets, sold in 40 pound bags. Prices online; accessed on 2/4/11.",1,{"$f":"3.89/40","v":9.7250000000000003E-2},{"$f":"U127*AA127","v":9.7250000000000003E-2},{"$f":"V127","v":9.7250000000000003E-2},2011,{"$f":"W127*VLOOKUP(X127,cci_table,3,FALSE)","v":0.11189420131680144},"The Home Depot (www.homedepot.com). Morton Salt System Saver II Water Softener Pellets. Sold in 40 pound bags. Prices online; accessed 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Aeration Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_aer_equipment",0,4,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L136=\"Source\",L136,IF(ISBLANK(L136),\"\",\"Vendor 1\"))","v":""},{"$f":"IF(S136=\"Source\",S136,IF(ISBLANK(S136),\"\",\"Vendor 2\"))","v":""},{"$f":"IF(Z136=\"Source\",Z136,IF(ISBLANK(Z136),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG136=\"Source\",AG136,IF(ISBLANK(AG136),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN136=\"Source\",AN136,IF(ISBLANK(AN136),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU136=\"Source\",AU136,IF(ISBLANK(AU136),\"\",\"Vendor 6\"))","v":""}]
[null,501,1000,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POU Aeration Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_aer_parts","Sediment Pre-Filter",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Air Filter",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Granular Activated Carbon w/ Backwash Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_gac_bw_equipment",0,4,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Granular Activated Carbon w/ Backwash Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_gac_bw_parts","Sediment Pre-Filter",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Media Cartridge",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Granular Activated Carbon Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_gac_equipment",0,4,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,15,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,24,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,50,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,51,100,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,101,500,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,501,1000,0,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Granular Activated Carbon Replacement Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_gac_parts","Sediment Pre-Filter",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"Media Cartridge",null,0,"N/A","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"POE Ultraviolet Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L168=\"Source\",L168,IF(ISBLANK(L168),\"\",\"Vendor 1\"))","v":""},{"$f":"IF(S168=\"Source\",S168,IF(ISBLANK(S168),\"\",\"Vendor 2\"))","v":""},{"$f":"IF(Z168=\"Source\",Z168,IF(ISBLANK(Z168),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG168=\"Source\",AG168,IF(ISBLANK(AG168),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN168=\"Source\",AN168,IF(ISBLANK(AN168),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU168=\"Source\",AU168,IF(ISBLANK(AU168),\"\",\"Vendor 6\"))","v":""}]
[null,"Number Households","Number Households","Avg. Unit Cost","Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["poe_uv_equipment",0,4,{"$f":"IF(AVERAGE(K170,R170,Y170,AF170,AM170,AT170)=0,\"contact vendor\",AVERAGE(K170,R170,Y170,AF170,AM170,AT170))","v":1599.3181058272094},10,10,1529,{"$f":"G170*M170","v":1529},{"$f":"H170","v":1529},2011,{"$f":"I170*VLOOKUP(J170,cci_table,3,FALSE)","v":1759.2414788009194},"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",1,1518.89,{"$f":"N170*T170","v":1518.89},{"$f":"O170","v":1518.89},2011,{"$f":"P170*VLOOKUP(Q170,cci_table,3,FALSE)","v":1747.60908419616},"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,1237.0999999999999,{"$f":"U170*AA170","v":1237.0999999999999},{"$f":"V170","v":1237.0999999999999},2011,{"$f":"W170*VLOOKUP(X170,cci_table,3,FALSE)","v":1423.3862873934709},"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,{"$f":"AB170*AH170","v":1427.1},{"$f":"AC170","v":1427.1},2011,{"$f":"AD170*VLOOKUP(AE170,cci_table,3,FALSE)","v":1641.9970663157565},"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,{"$f":"AI170*AO170","v":1348},{"$f":"AJ170","v":1348},2011,{"$f":"AK170*VLOOKUP(AL170,cci_table,3,FALSE)","v":1550.9859473012682},"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,{"$f":"AP170*AV170","v":1279.95},{"$f":"AQ170","v":1279.95},2011,{"$f":"AR170*VLOOKUP(AS170,cci_table,3,FALSE)","v":1472.6887709556813},"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,5,15,1599.3181058272094,10,10,1529,1529,1529,2011,1759.2414788009194,"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",1,1518.89,1518.89,1518.89,2011,1747.60908419616,"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,1237.0999999999999,1237.0999999999999,1237.0999999999999,2011,1423.3862873934709,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,1427.1,1427.1,2011,1641.9970663157565,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,1348,1348,2011,1550.9859473012682,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,1279.95,1279.95,2011,1472.6887709556813,"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,16,24,1599.3181058272094,10,10,1529,1529,1529,2011,1759.2414788009194,"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1518.89,1518.89,1518.89,2011,1747.60908419616,"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1237.0999999999999,1237.0999999999999,1237.0999999999999,2011,1423.3862873934709,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,1427.1,1427.1,2011,1641.9970663157565,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,1348,1348,2011,1550.9859473012682,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,1279.95,1279.95,2011,1472.6887709556813,"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,25,50,1599.3181058272094,10,10,1529,1529,1529,2011,1759.2414788009194,"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1518.89,1518.89,1518.89,2011,1747.60908419616,"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1237.0999999999999,1237.0999999999999,1237.0999999999999,2011,1423.3862873934709,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,1427.1,1427.1,2011,1641.9970663157565,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,1348,1348,2011,1550.9859473012682,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,1279.95,1279.95,2011,1472.6887709556813,"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,51,100,1599.3181058272094,10,10,1529,1529,1529,2011,1759.2414788009194,"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1518.89,1518.89,1518.89,2011,1747.60908419616,"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1237.0999999999999,1237.0999999999999,1237.0999999999999,2011,1423.3862873934709,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,1427.1,1427.1,2011,1641.9970663157565,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,1348,1348,2011,1550.9859473012682,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,1279.95,1279.95,2011,1472.6887709556813,"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,101,500,1599.3181058272094,10,10,1529,1529,1529,2011,1759.2414788009194,"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1518.89,1518.89,1518.89,2011,1747.60908419616,"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1237.0999999999999,1237.0999999999999,1237.0999999999999,2011,1423.3862873934709,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,1427.1,1427.1,2011,1641.9970663157565,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,1348,1348,2011,1550.9859473012682,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,1279.95,1279.95,2011,1472.6887709556813,"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,501,1000,1599.3181058272094,10,10,1529,1529,1529,2011,1759.2414788009194,"Pump Store USA (www.pumpstoreusa.com). Hallett 13 NSF certified UV System, 13.3 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1518.89,1518.89,1518.89,2011,1747.60908419616,"Fresh Water Systems (www.freshwatersystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",{"$f":"$M$67","v":1},1237.0999999999999,1237.0999999999999,1237.0999999999999,2011,1423.3862873934709,"RO Water Systems, Inc. (www.rosystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,1427.1,1427.1,1427.1,2011,1641.9970663157565,"Freshwater Systems (www.freshwatersystems.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,1348,1348,1348,2011,1550.9859473012682,"Excel Water Technologies Inc.(www.excelwater.com). Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,1279.95,1279.95,1279.95,2011,1472.6887709556813,"RO Water Systems, Inc. (www.rosystems.com). Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6"]
[null,"POE Ultraviolet Replacement Parts",null,null,"Useful Life (large)","Useful Life (small)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["poe_uv_parts","UV Lamp",null,{"$f":"IF(AVERAGE(K178,R178,Y178,AF178,AM178,AT178)=0,\"contact vendor\",AVERAGE(K178,R178,Y178,AF178,AM178,AT178))","v":127.97072294044162},"N/A","N/A",100,{"$f":"G178*M178","v":100},{"$f":"H178","v":100},2011,{"$f":"I178*VLOOKUP(J178,cci_table,3,FALSE)","v":115.05830469593978},"Ultraviolet Supply Co. (www.ultravioletsupply.com). Hallett 13 UV system replacement lamps. Prices online; accessed on 2/4/11.",1,152.09,{"$f":"N178*T178","v":152.09},{"$f":"O178","v":152.09},2011,{"$f":"P178*VLOOKUP(Q178,cci_table,3,FALSE)","v":174.99217561205481},"Fresh Water Systems (www.freshwatersystems.com). Replacement UV Lamp, Model# 602854, for Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,96.99,{"$f":"U178*AA178","v":96.99},{"$f":"V178","v":96.99},2011,{"$f":"W178*VLOOKUP(X178,cci_table,3,FALSE)","v":111.59504972459199},"RO Water Systems, Inc. (www.rosystems.com). Replacement UV Lamp, Model S740RL-HO, for Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,95.81,{"$f":"AB178*AH178","v":95.81},{"$f":"AC178","v":95.81},2011,{"$f":"AD178*VLOOKUP(AE178,cci_table,3,FALSE)","v":110.23736172917991},"Freshwater Systems (www.freshwatersystems.com). Replacement UV Lamp, Model S740RL-HO, for Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,"UV Quartz Sleeve",null,{"$f":"IF(AVERAGE(K179,R179,Y179,AF179,AM179,AT179)=0,\"contact vendor\",AVERAGE(K179,R179,Y179,AF179,AM179,AT179))","v":62.094090586781306},"N/A","N/A",null,null,null,null,null,null,1,42.88,{"$f":"N179*T179","v":42.88},{"$f":"O179","v":42.88},2011,{"$f":"P179*VLOOKUP(Q179,cci_table,3,FALSE)","v":49.337001053618984},"Fresh Water Systems (www.freshwatersystems.com). Replacement Quartz Sleeve, Model# 602974, for Trojan UVMax Pro10 NSF certifiec UV system, 10 gpm. Prices online; accessed on 2/4/11.",1,52.05,{"$f":"U179*AA179","v":52.05},{"$f":"V179","v":52.05},2011,{"$f":"W179*VLOOKUP(X179,cci_table,3,FALSE)","v":59.887847594236653},"RO Water Systems, Inc. (www.rosystems.com). Replacement Quartz Sleeve, Model QS-740, for Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed on 2/4/11.",1,54.94,{"$f":"AB179*AH179","v":54.94},{"$f":"AC179","v":54.94},2011,{"$f":"AD179*VLOOKUP(AE179,cci_table,3,FALSE)","v":63.213032599949315},"Freshwater Systems (www.freshwatersystems.com). Replacement Quartz Sleeve, Model QS-740, for Sterilight Platinum NSF Certified UV Systems, Model SPV-740, 11.2 gpm. Prices online; accessed 2/4/11.",1,66,{"$f":"AI179*AO179","v":66},{"$f":"AJ179","v":66},2011,{"$f":"AK179*VLOOKUP(AL179,cci_table,3,FALSE)","v":75.938481099320256},"Excel Water Technologies Inc.(www.excelwater.com). Replacement Qaurtz Sleeve, Model QS-600, for Sterilight Platinum NSF Certified UV Systems, Model SPV-12, 12 gpm. Prices online; ccessed 2/4/11.",1,null,null,null,null,null,null,null,null,null,null,null,"","Vendor 2","Vendor 3","Vendor 4","Vendor 5",""]
[]
["Labor Costs"]
[null,"Average Hourly cost for Installation",null,null,null,null,"Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z182=\"Source\",Z182,IF(ISBLANK(Z182),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG182=\"Source\",AG182,IF(ISBLANK(AG182),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN182=\"Source\",AN182,IF(ISBLANK(AN182),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU182=\"Source\",AU182,IF(ISBLANK(AU182),\"\",\"Vendor 6\"))","v":""}]
["install_rate",null,null,{"$f":"IF(AVERAGE(K183,R183,Y183,AF183,AM183,AT183)=0,\"contact vendor\",AVERAGE(K183,R183,Y183,AF183,AM183,AT183))","v":42.745999999999995},"N/A","N/A",{"$f":"29.59*1.45","v":42.905499999999996},{"$f":"G183","v":42.905499999999996},{"$f":"G183","v":42.905499999999996},2020,{"$f":"I183*VLOOKUP(J183,eci_table,3,FALSE)","v":42.905499999999996},"Comprises mean hourly wage for electricians (SOC 47-2111) http://www.bls.gov/oes/current/oes472111.htm and benefits multiplier of 1.45 (May 2020 BLS data).",1,{"$f":"29.37*1.45","v":42.586500000000001},{"$f":"N183","v":42.586500000000001},{"$f":"N183","v":42.586500000000001},2020,{"$f":"P183*VLOOKUP(Q183,eci_table,3,FALSE)","v":42.586500000000001},"Comprises mean hourly wage for plumbers (SOC 47-2152) http://www.bls.gov/oes/current/oes472152.htm and benefits multiplier of 1.45 (May 2020 BLS data).",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z183=\"Source\",Z183,IF(ISBLANK(Z183),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG183=\"Source\",AG183,IF(ISBLANK(AG183),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN183=\"Source\",AN183,IF(ISBLANK(AN183),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU183=\"Source\",AU183,IF(ISBLANK(AU183),\"\",\"Vendor 6\"))","v":""}]
["tech_rate",null,null,{"$f":"IF(AVERAGE(K184,R184,Y184,AF184,AM184,AT184)=0,\"contact vendor\",AVERAGE(K184,R184,Y184,AF184,AM184,AT184))","v":33.265162098930482},"N/A","N/A",null,null,32.51,2019,{"$f":"I184*VLOOKUP(J184,eci_table,3,FALSE)","v":33.265162098930482},"The base wage for systems serving 25-100, Source:  EPA, 2020. Labor Costs for National Drinking Water Rules. Prepared for EPA OGWDW by Abt. October.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z184=\"Source\",Z184,IF(ISBLANK(Z184),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG184=\"Source\",AG184,IF(ISBLANK(AG184),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN184=\"Source\",AN184,IF(ISBLANK(AN184),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU184=\"Source\",AU184,IF(ISBLANK(AU184),\"\",\"Vendor 6\"))","v":""}]
["clerical_rate",null,null,{"$f":"IF(AVERAGE(K185,R185,Y185,AF185,AM185,AT185)=0,\"contact vendor\",AVERAGE(K185,R185,Y185,AF185,AM185,AT185))","v":32.037287767379674},"N/A","N/A",null,null,31.31,2019,{"$f":"I185*VLOOKUP(J185,eci_table,3,FALSE)","v":32.037287767379674},"The base wage for systems serving 25-100, Source:  EPA, 2020. Labor Costs for National Drinking Water Rules. Prepared for EPA OGWDW by Abt. October.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z185=\"Source\",Z185,IF(ISBLANK(Z185),\"\",\"Vendor 3\"))","v":""},{"$f":"IF(AG185=\"Source\",AG185,IF(ISBLANK(AG185),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN185=\"Source\",AN185,IF(ISBLANK(AN185),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU185=\"Source\",AU185,IF(ISBLANK(AU185),\"\",\"Vendor 6\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["Monitoring Costs"]
["Mention of a vendor or product does not constitute an endorsement. "]
[null,"Laboratory Analysis Costs",null,null,null,null,"Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,"Source","Source","Source","Source","Source","Source"]
["lab_analysis_cost","Radium",null,{"$f":"IF(AVERAGE(K190,R190,Y190,AF190,AM190,AT190)=0,\"contact vendor\",AVERAGE(K190,R190,Y190,AF190,AM190,AT190))","v":373.87398191290305},"N/A","N/A",null,null,null,null,null,null,1,null,null,null,null,null,null,null,315,{"$f":"U190*AA190","v":315},{"$f":"V190","v":315},2010,{"$f":"W190*VLOOKUP(X190,cci_table,3,FALSE)","v":373.87398191290305},"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","Vendor 3","","",""]
[null,"Arsenic",null,29.672538247055797,"N/A","N/A",21,{"$f":"G191*M191","v":21},{"$f":"H191","v":21},2010,{"$f":"I191*VLOOKUP(J191,cci_table,3,FALSE)","v":24.924932127526869},"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,{"$f":"N191*T191","v":22},{"$f":"O191","v":22},2010,{"$f":"P191*VLOOKUP(Q191,cci_table,3,FALSE)","v":26.1118336574091},"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,32,32,32,2010,37.980848956231419,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"VOCs",null,267.05284422350218,"N/A","N/A",null,null,null,null,null,null,1,null,null,null,null,null,null,1,225,225,225,2010,267.05284422350218,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","Vendor 3","","",""]
[null,"SOCs",null,201.77326007997942,"N/A","N/A",null,null,null,null,null,null,1,null,null,null,null,null,null,1,170,170,170,2010,201.77326007997942,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","Vendor 3","","",""]
[null,"Nitrate",null,32.441975150114338,"N/A","N/A",17,{"$f":"G194*M194","v":17},{"$f":"H194","v":17},2010,{"$f":"I194*VLOOKUP(J194,cci_table,3,FALSE)","v":20.177326007997941},"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,20,{"$f":"N194*T194","v":20},{"$f":"O194","v":20},2010,{"$f":"P194*VLOOKUP(Q194,cci_table,3,FALSE)","v":23.738030597644638},"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,45,45,45,2010,53.410568844700435,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Copper",null,27.298735187291332,"N/A","N/A",21,21,21,2010,24.924932127526869,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,22,22,2010,26.1118336574091,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,26,26,26,2010,30.859439776938029,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Barium",null,32.04634130682026,"N/A","N/A",21,21,21,2010,24.924932127526869,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,22,22,2010,26.1118336574091,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,38,38,38,2010,45.102258135524814,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Cadmium",null,29.672538247055797,"N/A","N/A",21,21,21,2010,24.924932127526869,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,22,22,2010,26.1118336574091,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,32,32,32,2010,37.980848956231419,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Chromium",null,29.672538247055797,"N/A","N/A",21,21,21,2010,24.924932127526869,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,22,22,2010,26.1118336574091,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,32,32,32,2010,37.980848956231419,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Fluoride",null,28.090002873879484,"N/A","N/A",17,17,17,2010,20.177326007997941,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,22,22,2010,26.1118336574091,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,32,32,32,2010,37.980848956231419,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Lead",null,29.672538247055797,"N/A","N/A",21,21,21,2010,24.924932127526869,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,22,22,22,2010,26.1118336574091,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,32,32,32,2010,37.980848956231419,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Mercury",null,51.828033471524122,"N/A","N/A",43,43,43,2010,51.036765784935973,"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,35,35,35,2010,41.541553545878116,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,53,53,53,2010,62.905781083758285,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L201=\"Source\",L201,IF(ISBLANK(L201),\"\",\"Vendor 1\"))","v":"Vendor 1"},{"$f":"IF(S201=\"Source\",S201,IF(ISBLANK(S201),\"\",\"Vendor 2\"))","v":"Vendor 2"},{"$f":"IF(Z201=\"Source\",Z201,IF(ISBLANK(Z201),\"\",\"Vendor 3\"))","v":"Vendor 3"},{"$f":"IF(AG201=\"Source\",AG201,IF(ISBLANK(AG201),\"\",\"Vendor 4\"))","v":""},{"$f":"IF(AN201=\"Source\",AN201,IF(ISBLANK(AN201),\"\",\"Vendor 5\"))","v":""},{"$f":"IF(AU201=\"Source\",AU201,IF(ISBLANK(AU201),\"\",\"Vendor 6\"))","v":""}]
[null,"Perchlorate",null,115.36865379409032,"N/A","N/A",null,null,null,null,null,null,1,124,124,124,2011,142.67229782296533,"Exova - EPA 314 (IC) for perchlorate to 4 ppb",1,73,73,73,2009,88.065009765215308,"Test America GSA price list for Method 314",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Vendor 2","Vendor 3","","",""]
[null,"PFAS",null,{"$f":"IF(AVERAGE(K203,R203,Y203,AF203,AM203,AT203)=0,\"contact vendor\",AVERAGE(K203,R203,Y203,AF203,AM203,AT203))","v":302},"N/A","N/A",302,{"$f":"G203*M203","v":302},{"$f":"H203","v":302},2021,{"$f":"I203*VLOOKUP(J203,cci_table,3,FALSE)","v":302},"Cost for Method 537.1. Information Collection Request for the Final Unregulated Contaminant Monitoring Rule (UCMR5). Retrieved from https://www.regulations.gov/document/EPA-HQ-OW-2020-0530-0141",1]
[null,"Total Coliform",null,28.881270560467641,"N/A","N/A",20,{"$f":"G204*M204","v":20},{"$f":"H204","v":20},2010,{"$f":"I204*VLOOKUP(J204,cci_table,3,FALSE)","v":23.738030597644638},"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,15,15,15,2010,17.803522948233478,"Water Analysis, Training, Education & Research Services (WATERS), Price list emailed from Gretchen Grover to Danielle Fortney 10/15/2010.",1,38,38,38,2010,45.102258135524814,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Uranium",null,101.48008080493082,"N/A","N/A",21,{"$f":"G205*M205","v":21},{"$f":"H205","v":21},2010,{"$f":"I205*VLOOKUP(J205,cci_table,3,FALSE)","v":24.924932127526869},"Sierra Environmental Monitoring, Inc., Joe Nava (jnava@sem-analytical.com). Price List mailed to D. Fortney on 10/8/2010.",1,null,null,null,null,null,null,1,150,150,150,2010,178.03522948233478,"UMPQUA Research Company, Drinking Water and Environmental Analytical Services, Fee Schedule 2008.  Downloaded from http://www.chemlab.cc/price.pdf on 10/5/2010.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","","Vendor 3","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["Other Annual Costs"]
["Mention of a vendor or product does not constitute an endorsement. "]
[null,"Printed Educational Materials",null,null,"Useful Life (large)","Useful Life (small)","Original Vendor Quote","Quote+Inst","Quote+Inst+Trans","Year of Original Quote","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation Multiplier","Unit cost","Unit cost + Inst","Unit cost+Inst+Trans","Year","Adjusted Cost, including installation and transportation","Source","Installation multiplier",null,null,null,null,{"$f":"IF(L209=\"Source\",L209,IF(ISBLANK(L209),\"\",\"Vendor 1\"))","v":"Source"},{"$f":"IF(S209=\"Source\",S209,IF(ISBLANK(S209),\"\",\"Vendor 2\"))","v":"Source"},{"$f":"IF(Z209=\"Source\",Z209,IF(ISBLANK(Z209),\"\",\"Vendor 3\"))","v":"Source"},{"$f":"IF(AG209=\"Source\",AG209,IF(ISBLANK(AG209),\"\",\"Vendor 4\"))","v":"Source"},{"$f":"IF(AN209=\"Source\",AN209,IF(ISBLANK(AN209),\"\",\"Vendor 5\"))","v":"Source"},{"$f":"IF(AU209=\"Source\",AU209,IF(ISBLANK(AU209),\"\",\"Vendor 6\"))","v":"Source"}]
["printed_material_cost","Meeting flyers","($/flyer)",{"$f":"IF(AVERAGE(K210,R210,Y210,AF210,AM210,AT210)=0,\"contact vendor\",AVERAGE(K210,R210,Y210,AF210,AM210,AT210))","v":1.7566666666666666},"N/A","N/A",2.27,{"$f":"G210*M210","v":2.27},{"$f":"H210","v":2.27},2021,{"$f":"I210*VLOOKUP(J210,cci_table,3,FALSE)","v":2.27},"FedEx Office Print Online (www.fedex.com/us/office/). Price for a one-sheet, single-sided, full color flyer printed on Professional quality laser (60 lb) paper. Price calculated online on 1/4/22. https://www.fedex.com/apps/printonline/#!preview/pid%3D1447174746733%7C%7CisUF%3D0",1,2.2400000000000002,{"$f":"N210*T210","v":2.2400000000000002},{"$f":"O210","v":2.2400000000000002},2021,{"$f":"P210*VLOOKUP(Q210,cci_table,3,FALSE)","v":2.2400000000000002},"UPS Printing Services (https://www.theupsstore.com/print) Price for a one-sheet, single-sided, full color flyer printed on Glossy text (100 lb) paper (default for Premium Flyers). Minimum 100 quantity. Price calculated online. https://store5146.upsstoreprintshop.com/DSF/SmartStore.aspx?6xni2of2cF31QISx6T4SkLWU3ls9b/U9IfQhAf/CYf/NZ1NPgzDM5K8N8mQkXYqt#!/CategoryHome/37",1,0.76,{"$f":"U210*AA210","v":0.76},{"$f":"V210","v":0.76},2021,{"$f":"W210*VLOOKUP(X210,cci_table,3,FALSE)","v":0.76},"Staples (https://www.staples.com/services/printing) Price for a one-sheet, single-sided, full color flyer printed on gloss stock. Less options than other sources. Minimum 25 quantity. Price calculated online. https://www.staples.com/services/printing/AddFinishings/group/266961843/266961842",1,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Meeting ads","($/ad)",{"$f":"IF(AVERAGE(K211,R211,Y211,AF211,AM211,AT211)=0,\"contact vendor\",AVERAGE(K211,R211,Y211,AF211,AM211,AT211))","v":68.875},"N/A","N/A",59,{"$f":"G211*M211","v":59},{"$f":"H211","v":59},2021,{"$f":"I211*VLOOKUP(J211,cci_table,3,FALSE)","v":59},"Roanoke Times (ads.roanoke.com), local newspaper for Roanoke, VA.  Cost for a 7-day announcement in the local newspaper based on a 25-line announcement ad",1,37.5,{"$f":"N211*T211","v":37.5},{"$f":"O211","v":37.5},2021,{"$f":"P211*VLOOKUP(Q211,cci_table,3,FALSE)","v":37.5},"The Woodstock Independent (https://www.thewoodstockindependent.com/advertise/#) , local newspaper for Woodstock, IL.  Cost for a 7-day, 1 print announcement in the local newspaper based on a 25-line announcement ad, at $1.50 per line.",1,55,{"$f":"U211*AA211","v":55},{"$f":"V211","v":55},2021,{"$f":"W211*VLOOKUP(X211,cci_table,3,FALSE)","v":55},"Floyd Press (ads.heraldcourier.com.com), local newspaper for Floyd, VA.  Cost for a 7-day announcement in the local newspaper based on a 25-line announcement ad",1,124,{"$f":"AB211*AH211","v":124},{"$f":"AC211","v":124},2021,{"$f":"AD211*VLOOKUP(AE211,cci_table,3,FALSE)","v":124},"Portland Press Herald (http://www.masthead.me/) local newspaper for Portland, ME. Cost for single press public notice is $4.96/line, using 25 lines",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","Vendor 4","",""]
[null,"Nitrate awareness flyers","($/flyer)",{"$f":"IF(AVERAGE(K212,R212,Y212,AF212,AM212,AT212)=0,\"contact vendor\",AVERAGE(K212,R212,Y212,AF212,AM212,AT212))","v":1.7566666666666666},"N/A","N/A",2.27,{"$f":"G212*M212","v":2.27},{"$f":"H212","v":2.27},2021,{"$f":"I212*VLOOKUP(J212,cci_table,3,FALSE)","v":2.27},"FedEx Office Print Online (www.fedex.com/us/office/). Price for a one-sheet, single-sided, full color flyer printed on Professional quality laser (60 lb) paper. Price calculated online. https://www.fedex.com/apps/printonline/#!preview/pid%3D1447174746733%7C%7CisUF%3D0",1,2.2400000000000002,{"$f":"N212*T212","v":2.2400000000000002},{"$f":"O212","v":2.2400000000000002},2021,{"$f":"P212*VLOOKUP(Q212,cci_table,3,FALSE)","v":2.2400000000000002},"UPS Printing Services (https://www.theupsstore.com/print) Price for a one-sheet, single-sided, full color flyer printed on Glossy text (100 lb) paper (default for Premium Flyers). Minimum 100 quantity. Price calculated online. https://store5146.upsstoreprintshop.com/DSF/SmartStore.aspx?6xni2of2cF31QISx6T4SkLWU3ls9b/U9IfQhAf/CYf/NZ1NPgzDM5K8N8mQkXYqt#!/CategoryHome/37",1,0.76,{"$f":"U212*AA212","v":0.76},{"$f":"V212","v":0.76},2021,{"$f":"W212*VLOOKUP(X212,cci_table,3,FALSE)","v":0.76},"Staples (https://www.staples.com/services/printing) Price for a one-sheet, single-sided, full color flyer printed on gloss stock. Less options than other sources. Minimum 25 quantity. Price calculated online https://www.staples.com/services/printing/AddFinishings/group/266961843/266961842",1,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Meeting handouts","($/page)",{"$f":"IF(AVERAGE(K213,R213,Y213,AF213,AM213,AT213)=0,\"contact vendor\",AVERAGE(K213,R213,Y213,AF213,AM213,AT213))","v":0.17333333333333334},"N/A","N/A",0.15,{"$f":"G213*M213","v":0.15},{"$f":"H213","v":0.15},2021,{"$f":"I213*VLOOKUP(J213,cci_table,3,FALSE)","v":0.15},"FedEx Office Print Online (www.fedex.com/us/office/). Price for a one-sheet, single-sided, black & white copy printed on laser (32 lb) paper. Price calculated online.",1,0.2,{"$f":"N213*T213","v":0.2},{"$f":"O213","v":0.2},2021,{"$f":"P213*VLOOKUP(Q213,cci_table,3,FALSE)","v":0.2},"UPS Printing Services (https://www.theupsstore.com/print) Price for a one-sheet, single-sided, black and white copy printed on standard laser (20 lb) paper. Price calculated online.",1,0.17,{"$f":"U213*AA213","v":0.17},{"$f":"V213","v":0.17},2021,{"$f":"W213*VLOOKUP(X213,cci_table,3,FALSE)","v":0.17},"Staples (https://www.staples.com/services/printing) Price for a one-sheet, single-sided, black and white copy printed on basic (24 lb) paper. Price calculated online",1,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[null,"Billing mailers","($/page)",{"$f":"IF(AVERAGE(K214,R214,Y214,AF214,AM214,AT214)=0,\"contact vendor\",AVERAGE(K214,R214,Y214,AF214,AM214,AT214))","v":0.17333333333333334},"N/A","N/A",0.15,{"$f":"G214*M214","v":0.15},{"$f":"H214","v":0.15},2021,{"$f":"I214*VLOOKUP(J214,cci_table,3,FALSE)","v":0.15},"FedEx Office Print Online (www.fedex.com/us/office/). Price for a one-sheet, single-sided, black & white copy printed on laser (32 lb) paper. Price calculated online.",1,0.2,{"$f":"N214*T214","v":0.2},{"$f":"O214","v":0.2},2021,{"$f":"P214*VLOOKUP(Q214,cci_table,3,FALSE)","v":0.2},"UPS Printing Services (https://www.theupsstore.com/print) Price for a one-sheet, single-sided, black and white copy printed on standard laser (20 lb) paper. Price calculated online.",1,0.17,{"$f":"U214*AA214","v":0.17},{"$f":"V214","v":0.17},2021,{"$f":"W214*VLOOKUP(X214,cci_table,3,FALSE)","v":0.17},"Staples (https://www.staples.com/services/printing) Price for a one-sheet, single-sided, black and white copy printed on basic (24 lb) paper. Price calculated online",1,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor 1","Vendor 2","Vendor 3","","",""]
[]
["Escalation Factors"]
["current_year",2020]
["current_cpi",{"$f":"VLOOKUP(current_year,cci_table,2,FALSE)","v":258.81099999999998}]
["current_eci",{"$f":"VLOOKUP(current_year,eci_table,2,FALSE)","v":153.07499999999999}]
[]
[null,"Consumer Price Index"]
[null,"Year","CPI","Multiplier"]
["cpi_table",1990]
[null,1995,152.4,{"$f":"current_cci/C224","v":1.6982349081364827}]
[null,1996,156.9,1.6495283620140215]
[null,1997,160.5,1.6125295950155762]
[null,1998,163,1.5877975460122697]
[null,1999,166.6,1.553487394957983]
[null,2000,172.2,1.5029674796747967]
[null,2001,177.1,1.461383399209486]
[null,2002,179.9,1.4386381322957196]
[null,2003,184,1.4065815217391304]
[null,2004,188.9,1.3700952885124402]
[null,2005,195.3,1.3251971326164873]
[null,2006,201.6,1.2837847222222221]
[null,2007,207.34200000000001,1.2482323889998166]
[null,2008,215.303,1.2020780016999297]
[null,2009,214.53700000000001,1.2063699967837713]
[null,2010,218.05600000000001,1.1869015298822319]
[null,2011,224.93899999999999,1.1505830469593978]
[null,2012,229.59399999999999,1.1272550676411404]
[null,2013,232.95699999999999,1.1109818550204544]
[null,2014,236.73599999999999,1.0932473303595567]
[null,2015,237.017,1.0919512102507414]
[null,2016,240.00700000000001,{"$f":"current_cci/C245","v":1.0783477148583165}]
[null,2017,245.12,1.0558542754569189]
[null,2018,251.107,1.0306801483033128]
[null,2019,255.65700000000001,1.0123368419405687]
[null,2020,258.81099999999998,1]
[null,2021,258.81099999999998,1]
[]
[null,"Employment Cost Index",null,"Employment cost Index for total compensation for private industry, public utilities; Dec 2005 = 100. Download historical document from: https://www.bls.gov/web/eci/echistrynaics.pdf "]
[null,"Year","ECI","multiplier"]
["eci_table",2000,79.349999999999994,{"$f":"current_eci/C254","v":1.9291115311909264}]
[null,2001,{"$f":"AVERAGE(81.1,82.3,82.1,82.7)","v":82.05},1.8656307129798901]
[null,2002,{"$f":"AVERAGE(83.3,85.6,86.7,87.2)","v":85.699999999999989},1.7861726954492416]
[null,2003,{"$f":"AVERAGE(87.9,89.1,89.7,90.2)","v":89.224999999999994},1.7156066124964977]
[null,2004,{"$f":"AVERAGE(92.2,94.8,95.2,95.1)","v":94.324999999999989},1.6228465412138882]
[null,2005,{"$f":"AVERAGE(98.1,99.3,99.5,100)","v":99.224999999999994},1.5427059712773998]
[null,2006,{"$f":"AVERAGE(107.8,109.3,110.1,110.4)","v":109.4},1.3992230347349175]
[null,2007,{"$f":"AVERAGE(102.8,104.7,105,105.6)","v":104.52500000000001},1.4644821812963404]
[null,2008,{"$f":"AVERAGE(106.5,108.1,108.1,108.9)","v":107.9},1.4186746987951806]
[null,2009,{"$f":"AVERAGE(109.6,110.9,111.2,112)","v":110.925},1.3799864773495605]
[null,2010,{"$f":"AVERAGE(115.3,117,117.8,117.5)","v":116.9},1.3094525235243797]
[null,2011,{"$f":"AVERAGE(119.3,120.9,121.5,121.6 )","v":120.82499999999999},1.2669149596523899]
[null,2012,{"$f":"AVERAGE(122.9,125.2,125.4,125.7 )","v":124.8},1.2265625]
[null,2013,{"$f":"AVERAGE(126.5,127.4,126.3,126.9)","v":126.77500000000001},1.2074541510550185]
[null,2014,{"$f":"AVERAGE(128.3,129.3,129.9,130)","v":129.375},1.1831884057971014]
[null,2015,{"$f":"AVERAGE(132.1,133.3,134.2,134.3)","v":133.47499999999999},1.1468439782730848]
[null,2016,{"$f":"AVERAGE(135.8,136.8,137.3,137.8)","v":136.92500000000001},1.1179477816322803]
[null,2017,140.39999999999998,{"$f":"current_eci/C271","v":1.0902777777777779}]
[null,2018,144.4,{"$f":"current_eci/C272","v":1.0600761772853184}]
[null,2019,149.6,{"$f":"current_eci/C273","v":1.0232286096256684}]
[null,2020,153.07499999999999,{"$f":"current_eci/C274","v":1}]
[null,2021,153.07499999999999,{"$f":"current_eci/C275","v":1}]
[]
["Shipping Costs"]
["Mention of a vendor or product does not constitute an endorsement. "]
[null,"USPS Express Mail Prices - Zone L12 (www.usps.com/prices/express-mail-prices.htm). Accessed on 2/11/2011."]
[null,"Weight Not Over (pounds)","Price"]
["USPSExpress",0.5,13.25]
[null,1,15.25]
[null,2,16.55]
[null,3,17.600000000000001]
[null,4,18.899999999999999]
[null,5,19.600000000000001]
[null,6,22.95]
[null,7,26.35]
[null,8,27.65]
[null,9,29.15]
[null,10,30.1]
[null,11,32.85]
[null,12,33.450000000000003]
[null,13,33.9]
[null,14,35]
[null,15,37.049999999999997]
[null,16,38.049999999999997]
[null,17,40.200000000000003]
[null,18,42.3]
[null,19,43.45]
[null,20,45.45]
[null,21,46.75]
[null,22,48.85]
[null,23,49.9]
[null,24,52]
[null,25,54.25]
[null,26,55.25]
[null,27,57.3]
[null,28,58.4]
[null,29,60.55]
[null,30,62.7]
[null,31,63.7]
[null,32,65.8]
[null,33,66.900000000000006]
[null,34,69.05]
[null,35,70.150000000000006]
[null,36,72.2]
[null,37,74.3]
[null,38,75.400000000000006]
[null,39,77.5]
[null,40,78.5]
[null,41,80.650000000000006]
[null,42,82.75]
[null,43,83.9]
[null,44,85.95]
[null,45,87.1]
[null,46,89.2]
[null,47,90.25]
[null,48,92.3]
[null,49,94.45]
[null,50,95.55]
[null,51,97.65]
[null,52,98.75]
[null,53,100.9]
[null,54,103.05]
[null,55,104.05]
[null,56,106.15]
[null,57,107.25]
[null,58,109.25]
[null,59,110.5]
[null,60,112.5]
[null,61,114.65]
[null,62,115.75]
[null,63,117.85]
[null,64,118.85]
[null,65,121]
[null,66,123]
[null,67,124.25]
[null,68,126.3]
[null,69,127.3]
[null,70,129.5]
[null,71,131.02500000000001]
[null,72,132.69999999999999]
[null,73,134.375]
[null,74,136.05000000000001]
[null,75,137.72499999999999]
[null,76,139.4]
[null,77,141.07499999999999]
[null,78,142.75]
[null,79,144.42500000000001]
[null,80,146.1]
[null,81,147.77500000000001]
[null,82,149.44999999999999]
[null,83,151.125]
[null,84,152.80000000000001]
[null,85,154.47499999999999]
[null,86,156.15]
[null,87,157.82499999999999]
[null,88,159.5]
[null,89,161.17500000000001]
[null,90,162.85]
[]
[null,"FedEx Standard Overnight U.S. Retail Rates -- Zone 2 (Effective 1/3/2011) (www.fedex.com/ratetools/RateToolsMain.do)"]
[null,"Weight (lbs)","Price"]
["FedExEpress",0.5,15.5]
[null,1,17.75]
[null,2,19.100000000000001]
[null,3,20.399999999999999]
[null,4,21.95]
[null,5,22.6]
[null,6,23.9]
[null,7,24.35]
[null,8,25.6]
[null,9,26.95]
[null,10,27.55]
[null,11,28.5]
[null,12,29.45]
[null,13,29.85]
[null,14,30.9]
[null,15,32.15]
[null,16,32.799999999999997]
[null,17,34.5]
[null,18,35.5]
[null,19,36.450000000000003]
[null,20,37.1]
[null,21,38.1]
[null,22,39.450000000000003]
[null,23,40.1]
[null,24,41.15]
[null,25,42.1]
[null,26,43]
[null,27,43.7]
[null,28,45]
[null,29,46]
[null,30,46.7]
[null,31,47.65]
[null,32,48.65]
[null,33,49.7]
[null,34,50.55]
[null,35,52]
[null,36,52.95]
[null,37,53.95]
[null,38,54.9]
[null,39,56.3]
[null,40,57.2]
[null,41,58.2]
[null,42,59.2]
[null,43,60.2]
[null,44,61.25]
[null,45,62.25]
[null,46,63.2]
[null,47,64.5]
[null,48,65.5]
[null,49,66.5]
[null,50,67.75]
[null,51,68.75]
[null,52,70.099999999999994]
[null,53,71.45]
[null,54,72.400000000000006]
[null,55,73.75]
[null,56,75.05]
[null,57,76.7]
[null,58,78.349999999999994]
[null,59,79.7]
[null,60,80.95]
[null,61,82.4]
[null,62,84.65]
[null,63,85.85]
[null,64,87.6]
[null,65,88.95]
[null,66,90.55]
[null,67,91.9]
[null,68,93.55]
[null,69,95.25]
[null,70,97.15]
[null,71,99.05]
[null,72,101.05]
[null,73,102.5]
[null,74,104.5]
[null,75,106.05]
[null,76,107.7]
[null,77,109.7]
[null,78,111.35]
[null,79,112.7]
[null,80,112.95]
[null,81,116.3]
[null,82,118.95]
[null,83,120.6]
[null,84,121.9]
[null,85,122.5]
[null,86,125.1]
[null,87,126.6]
[null,88,127.85]
[null,89,129.85]
[null,90,129.9]
[null,91,132.5]
[null,92,134.44999999999999]
[null,93,136.1]
[null,94,136.15]
[null,95,136.19999999999999]
[null,96,141.75]
[null,97,142.85]
[null,98,142.9]
[null,99,142.94999999999999]
[null,100,143]
[null,101,144.43]
[null,102,145.86000000000001]
[null,103,147.29]
[null,104,148.72]
[null,105,150.15]
[null,106,151.58000000000001]
[null,107,153.01]
[null,108,154.44]
[null,109,155.87]
[null,110,157.30000000000001]
[null,111,158.72999999999999]
[null,112,160.16]
[null,113,161.59]
[null,114,163.02000000000001]
[null,115,164.45]
[null,116,165.88]
[null,117,167.31]
[null,118,168.74]
[null,119,170.17]
[null,120,171.6]
[null,121,173.03]
[null,122,174.46]
[null,123,175.89]
[null,124,177.32]
[null,125,178.75]
[null,126,180.18]
[null,127,181.61]
[null,128,183.04]
[null,129,184.47]
[null,130,185.9]
[null,131,187.33]
[null,132,188.76]
[null,133,190.19]
[null,134,191.62]
[null,135,193.05]
[null,136,194.48]
[null,137,195.91]
[null,138,197.34]
[null,139,198.77]
[null,140,200.2]
[null,141,201.63]
[null,142,203.06]
[null,143,204.49]
[null,144,205.92]
[null,145,207.35]
[null,146,208.78]
[null,147,210.21]
[null,148,211.64]
[null,149,213.07]
[null,150,214.5]
[]
["Sample Shipping for Capital Costs"]
["Type","# of samples","Size of bottle (ml)","No.of bottles per sample","Total sample volume (liters)","Ice","Shipping Volume (liters)","Cooler Size (liters)","Number of coolers needed (calculatedl)","weight of bottle w/ DW sample (lbs)","total weight of samples (lbs)","weight of ice & cooler(s) (lbs)","Total Shipping Weight (lbs)","Shipping weight per cooler",null,"Type","Average","USPS Express Mail Cost per cooler","USPS Express Mail Total cost for shipment","FedEx Express Standard Overnight cost per cooler","FedEx Express Standard Overnight total cost for shipment"]
["SOCs",{"$f":"OUTPUT!$C$49*OUTPUT!$E$49","v":77},40,1,{"$f":"D529*C529/1000*B529","v":3.08},"Yes",{"$f":"E529+(IF(F529=\"yes\",2*E529,E529))","v":9.24},{"$f":"IF(G529<15.1,\"15.1\",IF(G529<26.5,\"26.5\",\"37.8\"))","v":"15.1"},{"$f":"ROUNDUP(G529/H529,0)","v":1},{"$f":"(C529*D529)/1000*0.264*8.34","v":8.8070399999999993E-2},{"$f":"J529*B529","v":6.7814207999999994},{"$f":"IF(F529=\"Yes\",2.3*E529*2,0)+IF(H529=\"15.1\",1,IF(H529=37.8,2,3))","v":15.167999999999999},{"$f":"K529+L529","v":21.949420799999999},{"$f":"IF(I529>0,ROUNDUP(M529/I529,0),0)","v":22},null,{"$f":"A529","v":"SOCs"},{"$f":"AVERAGE(S529,U529)","v":44.150000000000006},{"$f":"IF(N529>0,VLOOKUP(N529,USPSExpress,2,FALSE),0)","v":48.85},{"$f":"R529*I529","v":48.85},{"$f":"IF(N529>0,VLOOKUP(N529,FedExExpress,2,FALSE),0)","v":39.450000000000003},{"$f":"T529*I529","v":39.450000000000003}]
["VOCs",{"$f":"OUTPUT!$C$49*OUTPUT!$E$49","v":77},40,1,{"$f":"D530*C530/1000*B530","v":3.08},"Yes",{"$f":"E530+(IF(F530=\"yes\",2*E530,E530))","v":9.24},{"$f":"IF(G530<15.1,\"15.1\",IF(G530<26.5,\"26.5\",\"37.8\"))","v":"15.1"},{"$f":"ROUNDUP(G530/H530,0)","v":1},{"$f":"(C530*D530)/1000*0.264*8.34","v":8.8070399999999993E-2},{"$f":"J530*B530","v":6.7814207999999994},{"$f":"IF(F530=\"Yes\",2.3*E530*2,0)+IF(H530=\"15.1\",1,IF(H530=37.8,2,3))","v":15.167999999999999},{"$f":"K530+L530","v":21.949420799999999},{"$f":"IF(I530>0,ROUNDUP(M530/I530,0),0)","v":22},null,{"$f":"A530","v":"VOCs"},{"$f":"AVERAGE(S530,U530)","v":44.150000000000006},{"$f":"IF(N530>0,VLOOKUP(N530,USPSExpress,2,FALSE),0)","v":48.85},{"$f":"R530*I530","v":48.85},{"$f":"IF(N530>0,VLOOKUP(N530,FedExExpress,2,FALSE),0)","v":39.450000000000003},{"$f":"T530*I530","v":39.450000000000003}]
["IOCs",{"$f":"OUTPUT!$C$49*OUTPUT!$E$49","v":77},500,1,{"$f":"D531*C531/1000*B531","v":38.5},"Yes",{"$f":"E531+(IF(F531=\"yes\",2*E531,E531))","v":115.5},{"$f":"IF(G531<15.1,\"15.1\",IF(G531<26.5,\"26.5\",\"37.8\"))","v":"37.8"},{"$f":"ROUNDUP(G531/H531,0)","v":4},{"$f":"(C531*D531)/1000*0.264*8.34","v":1.1008800000000001},{"$f":"J531*B531","v":84.76776000000001},{"$f":"IF(F531=\"Yes\",2.3*E531*2,0)+IF(H531=\"15.1\",1,IF(H531=37.8,2,3))","v":180.1},{"$f":"K531+L531","v":264.86775999999998},{"$f":"IF(I531>0,ROUNDUP(M531/I531,0),0)","v":67},null,{"$f":"A531","v":"IOCs"},{"$f":"AVERAGE(S531,U531)","v":432.3},{"$f":"IF(N531>0,VLOOKUP(N531,USPSExpress,2,FALSE),0)","v":124.25},{"$f":"R531*I531","v":497},{"$f":"IF(N531>0,VLOOKUP(N531,FedExExpress,2,FALSE),0)","v":91.9},{"$f":"T531*I531","v":367.6}]
["Radionuclides",{"$f":"OUTPUT!$C$49*OUTPUT!$E$49","v":77},1000,2,{"$f":"D532*C532/1000*B532","v":154},"No",{"$f":"E532+(IF(F532=\"yes\",2*E532,E532))","v":308},{"$f":"IF(G532<15.1,\"15.1\",IF(G532<26.5,\"26.5\",\"37.8\"))","v":"37.8"},{"$f":"ROUNDUP(G532/H532,0)","v":9},{"$f":"(C532*D532)/1000*0.264*8.34","v":4.4035200000000003},{"$f":"J532*B532","v":339.07104000000004},{"$f":"IF(F532=\"Yes\",2.3*E532*2,0)+IF(H532=\"15.1\",1,IF(H532=37.8,2,3))","v":3},{"$f":"K532+L532","v":342.07104000000004},{"$f":"IF(I532>0,ROUNDUP(M532/I532,0),0)","v":39},null,{"$f":"A532","v":"Radionuclides"},{"$f":"AVERAGE(S532,U532)","v":602.1},{"$f":"IF(N532>0,VLOOKUP(N532,USPSExpress,2,FALSE),0)","v":77.5},{"$f":"R532*I532","v":697.5},{"$f":"IF(N532>0,VLOOKUP(N532,FedExExpress,2,FALSE),0)","v":56.3},{"$f":"T532*I532","v":506.7}]
["Coliform",{"$f":"OUTPUT!$C$50*OUTPUT!$E$50","v":77},125,1,{"$f":"D533*C533/1000*B533","v":9.625},"Yes",{"$f":"E533+(IF(F533=\"yes\",2*E533,E533))","v":28.875},{"$f":"IF(G533<15.1,\"15.1\",IF(G533<26.5,\"26.5\",\"37.8\"))","v":"37.8"},{"$f":"ROUNDUP(G533/H533,0)","v":1},{"$f":"(C533*D533)/1000*0.264*8.34","v":0.27522000000000002},{"$f":"J533*B533","v":21.191940000000002},{"$f":"IF(F533=\"Yes\",2.3*E533*2,0)+IF(H533=\"15.1\",1,IF(H533=37.8,2,3))","v":47.274999999999999},{"$f":"K533+L533","v":68.466939999999994},{"$f":"IF(I533>0,ROUNDUP(M533/I533,0),0)","v":69},null,{"$f":"A533","v":"Coliform"},{"$f":"AVERAGE(S533,U533)","v":111.27500000000001},{"$f":"IF(N533>0,VLOOKUP(N533,USPSExpress,2,FALSE),0)","v":127.3},{"$f":"R533*I533","v":127.3},{"$f":"IF(N533>0,VLOOKUP(N533,FedExExpress,2,FALSE),0)","v":95.25},{"$f":"T533*I533","v":95.25}]
[]
["Sample Shipping for O&M Costs"]
["Type","# of samples","Size of bottle (ml)","No.of bottles per sample","Total sample volume (liters)","Ice","Shipping Volume (liters)","Cooler Size (liters)","Number of coolers needed (calculatedl)","weight of bottle w/ DW sample (lbs)","total weight of samples (lbs)","weight of ice & cooler(s) (lbs)","Total Shipping Weight (lbs)","Shipping weight per cooler",null,"Type",{"$f":"Q528","v":"Average"},{"$f":"R528","v":"USPS Express Mail Cost per cooler"},{"$f":"S528","v":"USPS Express Mail Total cost for shipment"},{"$f":"T528","v":"FedEx Express Standard Overnight cost per cooler"},{"$f":"U528","v":"FedEx Express Standard Overnight total cost for shipment"}]
[{"$f":"A529","v":"SOCs"},{"$f":"OUTPUT!$C$106*OUTPUT!$E$106","v":38},{"$f":"C529","v":40},1,{"$f":"D537*C537/1000*B537","v":1.52},{"$f":"F529","v":"Yes"},{"$f":"E537+(IF(F537=\"yes\",2*E537,E537))","v":4.5600000000000005},{"$f":"IF(G537<15.1,\"15.1\",IF(G537<26.5,\"26.5\",\"37.8\"))","v":"15.1"},{"$f":"ROUNDUP(G537/H537,0)","v":1},{"$f":"(C537*D537)/1000*0.264*8.34","v":8.8070399999999993E-2},{"$f":"J537*B537","v":3.3466752},{"$f":"IF(F537=\"Yes\",2.3*E537*2,0)+IF(H537=\"15.1\",1,IF(H537=37.8,2,3))","v":7.9919999999999991},{"$f":"K537+L537","v":11.338675199999999},{"$f":"ROUNDUP(M537/I537,0)","v":12},null,{"$f":"A537","v":"SOCs"},{"$f":"AVERAGE(S537,U537)","v":31.450000000000003},{"$f":"VLOOKUP(N537,USPSExpress,2,FALSE)","v":33.450000000000003},{"$f":"R537*I537","v":33.450000000000003},{"$f":"IF(N537>0,VLOOKUP(N537,FedExExpress,2,FALSE),0)","v":29.45},{"$f":"T537*I537","v":29.45}]
[{"$f":"A530","v":"VOCs"},{"$f":"OUTPUT!$C$106*OUTPUT!$E$106","v":38},40,1,{"$f":"D538*C538/1000*B538","v":1.52},{"$f":"F530","v":"Yes"},{"$f":"E538+(IF(F538=\"yes\",2*E538,E538))","v":4.5600000000000005},{"$f":"IF(G538<15.1,\"15.1\",IF(G538<26.5,\"26.5\",\"37.8\"))","v":"15.1"},{"$f":"ROUNDUP(G538/H538,0)","v":1},{"$f":"(C538*D538)/1000*0.264*8.34","v":8.8070399999999993E-2},{"$f":"J538*B538","v":3.3466752},{"$f":"IF(F538=\"Yes\",2.3*E538*2,0)+IF(H538=\"15.1\",1,IF(H538=37.8,2,3))","v":7.9919999999999991},{"$f":"K538+L538","v":11.338675199999999},{"$f":"ROUNDUP(M538/I538,0)","v":12},null,{"$f":"A538","v":"VOCs"},{"$f":"AVERAGE(S538,U538)","v":31.450000000000003},{"$f":"VLOOKUP(N538,USPSExpress,2,FALSE)","v":33.450000000000003},{"$f":"R538*I538","v":33.450000000000003},{"$f":"IF(N538>0,VLOOKUP(N538,FedExExpress,2,FALSE),0)","v":29.45},{"$f":"T538*I538","v":29.45}]
[{"$f":"A531","v":"IOCs"},{"$f":"OUTPUT!$C$106*OUTPUT!$E$106","v":38},500,1,{"$f":"D539*C539/1000*B539","v":19},{"$f":"F531","v":"Yes"},{"$f":"E539+(IF(F539=\"yes\",2*E539,E539))","v":57},{"$f":"IF(G539<15.1,\"15.1\",IF(G539<26.5,\"26.5\",\"37.8\"))","v":"37.8"},{"$f":"ROUNDUP(G539/H539,0)","v":2},{"$f":"(C539*D539)/1000*0.264*8.34","v":1.1008800000000001},{"$f":"J539*B539","v":41.833440000000003},{"$f":"IF(F539=\"Yes\",2.3*E539*2,0)+IF(H539=\"15.1\",1,IF(H539=37.8,2,3))","v":90.399999999999991},{"$f":"K539+L539","v":132.23344},{"$f":"ROUNDUP(M539/I539,0)","v":67},null,{"$f":"A539","v":"IOCs"},{"$f":"AVERAGE(S539,U539)","v":216.15},{"$f":"VLOOKUP(N539,USPSExpress,2,FALSE)","v":124.25},{"$f":"R539*I539","v":248.5},{"$f":"IF(N539>0,VLOOKUP(N539,FedExExpress,2,FALSE),0)","v":91.9},{"$f":"T539*I539","v":183.8}]
[{"$f":"A532","v":"Radionuclides"},{"$f":"OUTPUT!$C$106*OUTPUT!$E$106","v":38},1000,2,{"$f":"D540*C540/1000*B540","v":76},{"$f":"F532","v":"No"},{"$f":"E540+(IF(F540=\"yes\",2*E540,E540))","v":152},{"$f":"IF(G540<15.1,\"15.1\",IF(G540<26.5,\"26.5\",\"37.8\"))","v":"37.8"},{"$f":"ROUNDUP(G540/H540,0)","v":5},{"$f":"(C540*D540)/1000*0.264*8.34","v":4.4035200000000003},{"$f":"J540*B540","v":167.33376000000001},{"$f":"IF(F540=\"Yes\",2.3*E540*2,0)+IF(H540=\"15.1\",1,IF(H540=37.8,2,3))","v":3},{"$f":"K540+L540","v":170.33376000000001},{"$f":"ROUNDUP(M540/I540,0)","v":35},null,{"$f":"A540","v":"Radionuclides"},{"$f":"AVERAGE(S540,U540)","v":305.375},{"$f":"VLOOKUP(N540,USPSExpress,2,FALSE)","v":70.150000000000006},{"$f":"R540*I540","v":350.75},{"$f":"IF(N540>0,VLOOKUP(N540,FedExExpress,2,FALSE),0)","v":52},{"$f":"T540*I540","v":260}]
[{"$f":"A533","v":"Coliform"},{"$f":"OUTPUT!$C$107*OUTPUT!$E$107","v":38},125,1,{"$f":"D541*C541/1000*B541","v":4.75},{"$f":"F533","v":"Yes"},{"$f":"E541+(IF(F541=\"yes\",2*E541,E541))","v":14.25},{"$f":"IF(G541<15.1,\"15.1\",IF(G541<26.5,\"26.5\",\"37.8\"))","v":"15.1"},{"$f":"ROUNDUP(G541/H541,0)","v":1},{"$f":"(C541*D541)/1000*0.264*8.34","v":0.27522000000000002},{"$f":"J541*B541","v":10.458360000000001},{"$f":"IF(F541=\"Yes\",2.3*E541*2,0)+IF(H541=\"15.1\",1,IF(H541=37.8,2,3))","v":22.849999999999998},{"$f":"K541+L541","v":33.30836},{"$f":"ROUNDUP(M541/I541,0)","v":34},null,{"$f":"A541","v":"Coliform"},{"$f":"AVERAGE(S541,U541)","v":59.8},{"$f":"VLOOKUP(N541,USPSExpress,2,FALSE)","v":69.05},{"$f":"R541*I541","v":69.05},{"$f":"IF(N541>0,VLOOKUP(N541,FedExExpress,2,FALSE),0)","v":50.55},{"$f":"T541*I541","v":50.55}]

{"sheet":"Capital Assumptions","index":6,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Critical Design Assumptions"]
["Instructions: Do not revise information in gray cells."]
["Average Household Size","hh_size","people/household",2.5299999999999998]
["Average Per Capita Consumption (gal/day)","daily_use","gallons/person/day",100]
[null,null,"Units","POU RO Rental","POU Adsorptive Media NSF53","POU Anion Exchange","POU Cation Exchange","POU GAC","POU Reverse Osmosis","POE Adsorptive Media","POE Anion Exchange","POE Cation Exchange","POE Aeration","POE GAC with Auto-Backwash","POE GAC w/out Auto-Backwash","User-Defined System"]
["Equipment Installation"]
["POU/POE Installation","install_hours","hrs/household",0,2,2,2,2,2,2,2,2,2,2,2,{"$f":"IF(user_install=\"\",VLOOKUP(A7,install_hours,user_treat_select+3,FALSE),user_install)","v":2}]
["Scheduling Time","install_hours","hrs/household",0,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$f":"IF(user_install_sched=\"\",VLOOKUP(A8,install_hours,user_treat_select+3,FALSE),user_install_sched)","v":0.5}]
["UV Installation","install_hours","hrs/household",0,0,1,1,1,1,2,2,2,2,2,2,{"$f":"IF(user_uv_install=\"\",VLOOKUP(A9,install_hours,user_treat_select+3,FALSE),user_uv_install)","v":1}]
[]
["Public Education Program"]
["Develop materials","tech_labor","hrs",10,10,10,10,10,10,10,10,10,10,10,10,{"$f":"IF(user_dev_tech=\"\",VLOOKUP(A12,tech_labor,user_treat_select+3,FALSE),user_dev_tech)","v":10}]
["Nitrate health effects","tech_labor","hrs",5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"IF(user_dev_nit=\"\",VLOOKUP(A13,tech_labor,user_treat_select+3,FALSE),user_dev_nit)","v":5}]
["Meetings","tech_labor","hrs",2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"IF(user_meet_tech=\"\",VLOOKUP(A14,tech_labor,user_treat_select+3,FALSE),user_meet_tech)","v":2}]
["Post-meeting","tech_labor","hrs",2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"IF(user_post_tech=\"\",VLOOKUP(A15,tech_labor,user_treat_select+3,FALSE),user_post_tech)","v":2}]
["Develop materials","clerical_labor","hrs",6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"IF(user_dev_cler=\"\",VLOOKUP(A16,clerical_labor,user_treat_select+3,FALSE),user_dev_cler)","v":6}]
["Nitrate health effects","clerical_labor","hrs",5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"IF(user_nitr_cler=\"\",VLOOKUP(A17,clerical_labor,user_treat_select+3,FALSE),user_nitr_cler)","v":5}]
["Meetings","clerical_labor","hrs",2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"IF(user_meet_cler=\"\",VLOOKUP(A18,clerical_labor,user_treat_select+3,FALSE),user_meet_cler)","v":2}]
["Post-meeting","clerical_labor","hrs",2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"IF(user_post_cler=\"\",VLOOKUP(A19,clerical_labor,user_treat_select+3,FALSE),user_post_cler)","v":2}]
["Meeting flyers","ed_material","flyers",10,10,10,10,10,10,10,10,10,10,10,10,{"$f":"IF(user_flyers=\"\",VLOOKUP(A20,ed_material,user_treat_select+3,FALSE),user_flyers)","v":10}]
["Meeting ads","ed_material","ads",1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(user_ads=\"\",VLOOKUP(A21,ed_material,user_treat_select+3,FALSE),user_ads)","v":1}]
["Nitrate awareness flyers","ed_material","flyers",10,10,10,10,10,10,10,10,10,10,10,10,{"$f":"IF(user_nitr_flyers=\"\",VLOOKUP(A22,ed_material,user_treat_select+3,FALSE),user_nitr_flyers)","v":10}]
["Meeting handouts","ed_material","pages/household",3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"IF(user_handout=\"\",VLOOKUP(A23,ed_material,user_treat_select+3,FALSE),user_handout)","v":3}]
["Billing mailers","ed_material","pages/household",2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"IF(user_mailers=\"\",VLOOKUP(A24,ed_material,user_treat_select+3,FALSE),user_mailers)","v":2}]
[]
["Laboratory Analyses"]
["Sampling time","initial_sample","hrs/sample",0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"IF(user_samp_time=\"\",VLOOKUP(A27,initial_sample,user_treat_select+3,FALSE),user_samp_time)","v":0.25}]
["Sampling scheduling time","initial_sample","hrs/sample",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(user_samp_sched=\"\",VLOOKUP(A28,initial_sample,user_treat_select+3,FALSE),user_samp_sched)","v":0}]
["Analysis","initial_sample","samples/household",1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(user_analysis=\"\",VLOOKUP(A29,initial_sample,user_treat_select+3,FALSE),user_analysis)","v":1}]
["Frequency","initial_sample","% households sampled",1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(user_hh_sampled=\"\",VLOOKUP(A30,initial_sample,user_treat_select+3,FALSE),user_hh_sampled)","v":1}]
[]
[]
["Indirect Cost Multipliers"]
["Permitting","indirect_cost","applied to base capital cost only",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"IF(user_permitting=\"\",VLOOKUP(A34,indirect_cost,user_treat_select+3,FALSE),IF('User Input'!D68=\"% installed equipment cost\",user_permitting/100,user_permitting))","v":0.03}]
["Pilot Testing","indirect_cost","applied to base capital cost only",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"IF(user_pilot=\"\",VLOOKUP(A35,indirect_cost,user_treat_select+3,FALSE),IF('User Input'!D69=\"% installed equipment cost\",user_pilot/100,user_pilot))","v":0.03}]
["Legal","indirect_cost","applied to base capital cost only",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"IF(user_legal=\"\",VLOOKUP(A36,indirect_cost,user_treat_select+3,FALSE),IF('User Input'!D70=\"% installed equipment cost\",user_legal/100,user_legal))","v":0.03}]
["Engineering","indirect_cost","applied to base capital cost only",0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,{"$f":"IF(user_eng=\"\",VLOOKUP(A37,indirect_cost,user_treat_select+3,FALSE),IF('User Input'!D71=\"% installed equipment cost\",user_eng/100,user_eng))","v":0.15}]
["Contingency","indirect_cost","applied to base capital cost only",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,{"$f":"IF(user_cont=\"\",VLOOKUP(A38,indirect_cost,user_treat_select+3,FALSE),IF('User Input'!D72=\"% installed equipment cost\",user_cont/100,user_cont))","v":0.1}]
[]
["Annualization Rate"]
["Discount rate used to annualize capital over discount period","discount_rate","percent",7.0000000000000007E-2,"Set equal to financing rate."]
["Discount period","discount_period","years",10,"Set equal to expected life of equipment or financing period."]
[]
["Complexity Factor"]
["Complexity","complexity_rng","used to calculate contingency",1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Indirect Assumptions","index":7,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Assumptions for calculating indirect and add-on costs"]
["Contingency"]
["Technology complexity factor","complexity",{"$f":"VLOOKUP(B3,complexity_rng,treat_select+3,FALSE)","v":1},null,"Technology-specific factor.  See Appendices for details.  Low complexity = 0.5; Average complexity = 1.0; High complexity = 1.5; Very high complexity = 2.0."]

{"sheet":"O&M Assumptions","index":8,"n_rows":107,"n_cols":16,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Critical Design Assumptions for O&M"]
["Instructions: Do not revise information in gray cells."]
[null,null,"Units","POU RO Rental","POU Adsorptive Media NSF53","POU Anion Exchange","POU Cation Exchange","POU GAC","POU Reverse Osmosis","POE Adsorptive Media","POE Anion Exchange","POE Cation Exchange","POE Aeration","POE GAC with Auto-Backwash","POE GAC w/out Auto-Backwash","User-Defined System"]
["Equipment Maintenance"]
["POU/POE maintenance","maint_time","hrs/visit",0,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$f":"IF(user_maint=\"\",INDEX(maint_time,user_treat_select),user_maint)","v":0.5}]
["POU/POE replacement frequency","maint_frequency","visits/hh/yr",0,1,1,1,1,1.3,1,1,1,1,1,1,{"$f":"IF(user_repl_freq=\"\",INDEX(maint_frequency,user_treat_select),user_repl_freq)","v":1}]
["UV maintenance","UV_maint_time","hrs/visit",0,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$f":"IF(user_uv_maint=\"\",INDEX(UV_maint_time,user_treat_select),user_uv_maint)","v":0.5}]
["UV maintenance frequency","UV_maint_frequency","visits/hh/yr",0,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(user_uv_freq=\"\",INDEX(UV_maint_frequency,user_treat_select),user_uv_freq)","v":1}]
["Scheduling time","maint_scheduling","hrs/visit",0,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$f":"IF(user_maint_sched=\"\",INDEX(maint_scheduling,user_treat_select),user_maint_sched)","v":0.5}]
[]
["Public Education Program"]
["Information updates","tech_labor_om","hrs",12,12,12,12,12,12,12,12,12,12,12,12,{"$f":"IF(user_updates_tech=\"\",VLOOKUP(A12,tech_labor_om,user_treat_select+3,FALSE),user_updates_tech)","v":12}]
["Nitrate information updates","tech_labor_om","hrs",20,20,20,20,20,20,20,20,20,20,20,20,{"$f":"IF(user_nitr_updates_tech=\"\",VLOOKUP(A13,tech_labor_om,user_treat_select+3,FALSE),user_nitr_updates_tech)","v":20}]
["Information updates","clerical_labor_om","hrs",12,12,12,12,12,12,12,12,12,12,12,12,{"$f":"IF(user_info_cler=\"\",VLOOKUP(A14,clerical_labor_om,user_treat_select+3,FALSE),user_info_cler)","v":12}]
["Nitrate information updates","clerical_labor_om","hrs",20,20,20,20,20,20,20,20,20,20,20,20,{"$f":"IF(user_nitr_updates_cler=\"\",VLOOKUP(A15,clerical_labor_om,user_treat_select+3,FALSE),user_nitr_updates_cler)","v":20}]
["Nitrate awareness flyers","ed_material_om","flyers",10,10,10,10,10,10,10,10,10,10,10,10,{"$f":"IF(user_om_flyer=\"\",VLOOKUP(A16,ed_material_om,user_treat_select+3,FALSE),user_om_flyer)","v":10}]
["Billing mailers","ed_material_om","pages/household",3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"IF(user_om_billing=\"\",VLOOKUP(A17,ed_material_om,user_treat_select+3,FALSE),user_om_billing)","v":3}]
[]
["Laboratory Analyses"]
["Sampling time","lab_analysis","hrs/sample",0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"IF(user_om_samp=\"\",VLOOKUP(A20,lab_analysis,user_treat_select+3,FALSE),user_om_samp)","v":0.25}]
["Sampling scheduling time","lab_analysis","hrs/sample",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(user_om_sched=\"\",VLOOKUP(A21,lab_analysis,user_treat_select+3,FALSE),user_om_sched)","v":0}]
["Analysis","lab_analysis","sample/hh",1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(user_om_analysis=\"\",VLOOKUP(A22,lab_analysis,user_treat_select+3,FALSE),user_om_analysis)","v":1}]
["Frequency","lab_analysis","% hh/yr",0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,0.33300000000000002,{"$f":"IF(user_om_shipping=\"\",VLOOKUP(A23,lab_analysis,user_treat_select+3,FALSE),user_om_shipping)","v":0.33300000000000002}]
[]
[]
["Equipment Replacement Schedule"]
["Component","Replacement Frequency"]
[]
["POU RO Rental","pou_rorental_replace"]
["Annual Rental Cost",1,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POU Adsorptive Media NSF53","pou_ads_nsf53_replace"]
["Media Cartridge",1,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POU Anion Exchange","pou_ax_replace"]
["Media Cartridge",1,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POU Cation Exchange","pou_cx_replace"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POU GAC","pou_gac_replace"]
["Media Cartridge",1,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POU RO Equipment","pou_ro_replace"]
["Sediment Pre-Filter",1.3,"units/year"]
["Pre-GAC Filter Cartridge",1.3,"units/year"]
["Post-GAC Filter Cartridge",1,"units/year"]
["RO Membrane",{"$f":"1/3","v":0.33333333333333331},"units/year"]
[]
["POU UV Replacement Schedule","pou_uv_replace"]
["UV Lamp",1,"units/year"]
["UV Quartz Sleeve",0.2,"units/year"]
[]
["POE Adsorptive Media","poe_ads_replace"]
["Media Cartridge",0.33,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POE Anion Exchange","poe_ax_replace"]
["Media Cartridge",0.2,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POE Cation Exchange","poe_cx_replace"]
["Sodium Chloride",15,"pounds/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POE Aeration","POE_aer_replace"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POE GAC with Auto-Backwash","poe_gac_bw_replace"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POE GAC w/out Auto-Backwash","poe_gac_replace"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
["NA",0,"units/year"]
[]
["POE UV Replacement Schedule","poe_uv_replace"]
["UV Lamp",1,"units/year"]
["UV Quartz Sleeve",0.2,"units/year"]