{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Introduction","Context","Background","Properties","Water Access","Monitoring","Institutional Controls","Oversight","Surface Water","Results","Charts","Cost Data Sources","ResponseDomains"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["The tool is organized into different tabs, each addressing different potential contributors to the cost of institutional controls. Work through each tab, advancing by clicking directly on the tab or using the buttons. Each selection and input you provide will update the contents of the last tab, which will summarize the long-term costs and list recommendations and warnings for handling the contamination."]
[]
[]
[]
[]
[]
[]
["Developed by the Institute of Water Research - Michigan State University"]
[2024]

{"sheet":"Context","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5],[4,0,4,5],[2,0,2,5],[11,0,11,5],[21,0,21,5],[17,0,17,5]]}
["Context"]
[]
["This tool will generate cost estimates for allowing groundwater contaminants to run their course while protecting people from exposure through institutional controls. However, there are costs associated with such a scenario that are beyond the scope of this tool to estimate, but should be considered when evaluating options for responding to a contamination. Responding to the questions below can highlight those hard to quantify impacts."]
[]
["Public Trust"]
[null,"Does the area affected by the contamination serve or is occupied by marginalized populations?","no"]
[null,"Does the affected area or region have a prior history of environmental contamination?","no"]
[null,"Have prior clean-up efforts in the affected area or region been adequate?","yes"]
[null,"Is there a viable liable party?","yes"]
[]
[]
["Natural Resource and Recreational Quality"]
[null,"Will the contamination threaten surface water resources?","no"]
[null,"Does the contamination threaten recreational areas?","no"]
[null,"Are the affected area's natural resources and features an important component of its economy and identity?","no"]
[]
[]
["Public Health"]
[null,"Will humans potentially be exposed to the contamination at levels that exceed safety criteria?","no"]
[]
[]
["Foregone Development"]
[null,"Could the contamination prohibit development on affected lands?","no"]
[]
[]
[null,"References"]
[1,"https://journals.sagepub.com/doi/10.1177/1468796815575382"]
[2,"https://ajph.aphapublications.org/doi/abs/10.2105/AJPH.2018.304621"]

{"sheet":"Background","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,9,0,10]]}
["Background",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
[1,"How large is the affected area?",0,"square miles",null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[2,"Is the contaminant source contained?","yes",null,null,null,null,null,null,"max",{"$f":"Results!F52","v":0}]
[3,"How would you characterize the dominant geologic class of the affected aquifer?","bedrock"]
[4,"Could the concentration of the contaminant in the aquifer increase in the future?","no"]
[5,"Do you anticipate the contaminant plume expanding into the future?","no"]
[6,"What is the time horizon for this analysis?",0,"years"]

{"sheet":"Properties","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,9,0,10]]}
["Properties",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
[1,"How many residential properties are currently affected?",0,null,null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[2,"How many commercial properties are currently affected?",0,null,null,{"$f":"SUM(C3:C4)","v":0},"total properties",null,null,"max",{"$f":"Results!F52","v":0}]
[3,"How many acres of undeveloped land (which could be developed in the absence of use restrictions) may be affected?",0]
[4,"How many acres of public land / parks may be affected?",0]
[5,"What is the population of the affected area?",0]

{"sheet":"Water Access","index":4,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,9,0,10]]}
["Water Access",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
[1,"What percentage of currently affected properties require well abandonment?",0,"%",null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[2,"What percentage of currently affected properties require bottled water delivery?",0,"%",null,null,null,null,null,"max",{"$f":"Results!F52","v":0}]
[3,"For how long?",0,"months"]
[4,"What percentage of currently affected properties require new connections to municipal water supply?",0,"%"]
["5a","Are new water mains needed?","no"]
["5b","If yes, estimate a total length of the new mains",0,"feet"]

{"sheet":"Monitoring","index":5,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,0,29,5],[0,9,0,10],[7,0,7,5],[0,0,0,5],[2,0,2,5],[13,0,13,5],[22,0,22,5]]}
["Monitoring",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
["Monitoring Well Installations",null,null,null,null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[1,"How many monitoring wells must be installed?",0,null,null,null,null,null,null,"max",{"$f":"Results!F52","v":0}]
[2,"How long will those wells operate?",0,"years"]
[3,"How frequently will results be analyzed?",0,"times per year"]
[]
["Residential/Commercial Water Monitoring"]
["4a","Is monitoring of residential or commercial water necessary?","no"]
["4b","What percentage of affected properties require water testing?",0,"%"]
["4c","For how long?",0,"years"]
["4d","How frequently will results be analyzed?",0,"times per year"]
[]
["Air Monitoring"]
["5a","Is air monitoring necessary?","no"]
["5b","What percentage of affected properties require air monitoring?",0,"%"]
["5c","For how long",0,"years"]
["5d","How frequently will residential results be analyzed?",0,"times per year"]
["5e","What percentage of affected properties require air treatment systems?",0,"%"]
["5f","For how long?",0,"years"]
["5g","How frequently will results be analyzed?",0,"times per year"]
[]
["Soil Monitoring"]
["6a","Is long-term soil monitoring for VOC gases necessary?","no"]
["6b","How many sites will require soil sampling?",0]
["6c","For how long",0,"years"]
["6d","For each site, on average, how many samples will be gathered?",0]
["6e","How frequently will the samples be analyzed",0,"times per year"]
[]
["Surface Water Monitoring"]
["7a","Is surface water sampling necessary?","no"]
["7b","How many surface water bodies require sampling?",0]
["7c","For how long?",0,"years"]
["7d","For each water body, on average, how many samples will be gathered?",0]
["7e","How frequently will samples be analyzed?",0,"times per year"]

{"sheet":"Institutional Controls","index":6,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,9,0,10]]}
["Institutional Controls",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
[1,"What percentage of affected properties will require the adoption of restrictive covenants?",0,"%",null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[2,"How many ordinances will be implemented to protect the public from exposure?",0,null,null,null,null,null,null,"max",{"$f":"Results!F52","v":0}]

{"sheet":"Oversight","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[6,0,6,5],[0,9,0,10]]}
["Oversight and Reporting",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
["Staffing",null,null,null,null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[1,"Estimate the staffing needs (contractors; local, state, and or federal agencies) for overseeing this project. Exclude FTE values associated with items previously represented in this spreadsheet, such as monitoring and reporting.",0,"FTE",null,null,null,null,null,"max",{"$f":"Results!F52","v":0}]
[2,"How long will those staffing needs be needed?",0,"years"]
[]
["Reporting"]
[3,"How frequently will reporting to regulatory agencies be required?",0,"times per year"]
[4,"Is this an EPA superfund site?","no"]
[5,"For how long?",0,"years"]

{"sheet":"Surface Water","index":8,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,9,0,10]]}
["Surface Water Impacts",null,null,null,null,null,null,null,null,"Total Costs"]
["#","Inputs",null,null,null,"Notes",null,null,null,"min",{"$f":"Results!D52","v":0}]
[1,"Will the contamination threaten surface water resources?","no",null,null,null,null,null,null,"expected",{"$f":"Results!E52","v":0}]
[2,"If yes, will it likely exceed the acceptable criteria for supporting fish habitat?","yes",null,null,null,null,null,null,"max",{"$f":"Results!F52","v":0}]
[3,"Will the surface water contamination likely exceed the acceptable criteria for human contact?","yes"]
["4a","Are beach closures likely?","no"]
["4b","If yes, for how long?",10,"years"]
["4c","How many visitors per week do the affected beaches receive?",0,"per summer week"]
["5a","Will the surface water contamination prohibit recreational fishing?","no"]
["5b","If yes, for how long?",0,"years"]
["5c","Average weekly fishing days/trips affected",0,"per week"]
["6a","Will the surface water contamination prohibit recreational boating?","no"]
["6b","If yes, for how long?",0,"years"]
["6c","Average weekly boating days/trips affected",0,"per summer week"]

{"sheet":"Results","index":9,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[42,2,42,8],[28,2,28,8],[55,2,55,8],[0,2,0,8],[3,2,3,8],[1,6,1,8],[14,2,14,8],[35,2,35,8],[2,0,6,0],[8,0,12,0],[14,0,18,0],[20,0,24,0],[26,0,30,0],[56,0,60,0],[62,0,66,0],[68,0,72,0],[32,0,36,0],[38,0,42,0],[44,0,48,0],[50,0,54,0]]}
["Warnings",null,"Costs"]
[null,null,"item","min","expected","max"]
[]
[null,null,"Water Access"]
[null,null,"Well abandonment",{"$f":"Properties!$F$4*'Water Access'!$C$3/100*MIN('Cost Data Sources'!$D$17:$F$18)","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$3/100*MEDIAN('Cost Data Sources'!$D$17:$F$18)","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$3/100*MAX('Cost Data Sources'!$D$17:$F$18)","v":0}]
[null,null,"Bottled water",{"$f":"Properties!$F$4*'Water Access'!$C$4/100*MIN('Cost Data Sources'!$D$21:$F$22)*'Water Access'!$C$5","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$4/100*MEDIAN('Cost Data Sources'!$D$21:$F$22)*'Water Access'!$C$5","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$4/100*MAX('Cost Data Sources'!$D$21:$F$22)*'Water Access'!$C$5","v":0},"over",{"$f":"'Water Access'!C5","v":0},"months"]
[null,null,"Municipal water connections",{"$f":"Properties!$F$4*'Water Access'!$C$6/100*MIN('Cost Data Sources'!$D7,'Cost Data Sources'!$E7,'Cost Data Sources'!$F7,'Cost Data Sources'!$D9,'Cost Data Sources'!$E9,'Cost Data Sources'!$F9)","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$6/100*MEDIAN('Cost Data Sources'!$E7,'Cost Data Sources'!$D9,'Cost Data Sources'!$E9,'Cost Data Sources'!$F9)","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$6/100*MAX('Cost Data Sources'!$D7,'Cost Data Sources'!$E7,'Cost Data Sources'!$F7,'Cost Data Sources'!$D9,'Cost Data Sources'!$E9,'Cost Data Sources'!$F9)","v":0}]
[null,null,"New water bills",{"$f":"Properties!$F$4*'Water Access'!$C$6/100*MIN('Cost Data Sources'!$D$5:$F$6)*Background!$C$8 - Properties!$F$4*'Water Access'!$C$6/100*MAX('Cost Data Sources'!$D$10:$F$10)*Background!$C$8","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$6/100*MEDIAN('Cost Data Sources'!$D$5:$F$6)*Background!$C$8 - Properties!$F$4*'Water Access'!$C$6/100*MEDIAN('Cost Data Sources'!$D$10:$F$10)*Background!$C$8","v":0},{"$f":"Properties!$F$4*'Water Access'!$C$6/100*MAX('Cost Data Sources'!$D$5:$F$6)*Background!$C$8 - Properties!$F$4*'Water Access'!$C$6/100*MIN('Cost Data Sources'!$D$10:$F$10)*Background!$C$8","v":0}]
[]
[null,null,"Water main installations",{"$f":"IF('Water Access'!$C$7=\"yes\", 'Water Access'!$C$8*MIN('Cost Data Sources'!D8:F8), 0)","v":0},{"$f":"IF('Water Access'!$C$7=\"yes\", 'Water Access'!$C$8*MEDIAN('Cost Data Sources'!D8:F8), 0)","v":0},{"$f":"IF('Water Access'!$C$7=\"yes\", 'Water Access'!$C$8*MAX('Cost Data Sources'!D8:F8), 0)","v":0},"over",{"$f":"'Water Access'!C8","v":0},"linear feet"]
[]
[null,null,"water access totals",{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},{"$f":"SUM(F5:F10)","v":0}]
[]
[]
[null,null,"Monitoring"]
[null,null,"Monitoring well installation",{"$f":"Monitoring!$C$4*MIN('Cost Data Sources'!$D$25:$F$25)","v":0},{"$f":"Monitoring!$C$4*MEDIAN('Cost Data Sources'!$D$25:$F$25)","v":0},{"$f":"Monitoring!$C$4*MAX('Cost Data Sources'!$D$25:$F$25)","v":0}]
[null,null,"Monitoring well maintenance / analysis",{"$f":"Monitoring!$C$4*Monitoring!$C$5*MIN('Cost Data Sources'!$D$26:$F$26)*Monitoring!$C$6","v":0},{"$f":"Monitoring!$C$4*Monitoring!$C$5*MEDIAN('Cost Data Sources'!$D$26:$F$26)*Monitoring!$C$6","v":0},{"$f":"Monitoring!$C$4*Monitoring!$C$5*MAX('Cost Data Sources'!$D$26:$F$26)*Monitoring!$C$6","v":0},"over",{"$f":"Monitoring!C5","v":0},"years"]
[]
[null,null,"Residential/property well sampling",{"$f":"IF(Monitoring!$C$9=\"yes\", Properties!$F$4*Monitoring!$C$10/100*MIN('Cost Data Sources'!$D$33:$F$33)*Monitoring!$C$11*Monitoring!$C$12,0)","v":0},{"$f":"IF(Monitoring!$C$9=\"yes\", Properties!$F$4*Monitoring!$C$10/100*MEDIAN('Cost Data Sources'!$D$33:$F$33)*Monitoring!$C$11*Monitoring!$C$12,0)","v":0},{"$f":"IF(Monitoring!$C$9=\"yes\", Properties!$F$4*Monitoring!$C$10/100*MAX('Cost Data Sources'!$D$33:$F$33)*Monitoring!$C$11*Monitoring!$C$12,0)","v":0},"over",{"$f":"Monitoring!C11","v":0},"years"]
[null,null,"Residential/property air monitoring",{"$f":"IF(Monitoring!$C$15=\"yes\", Properties!$F$4*Monitoring!$C$16/100*MIN('Cost Data Sources'!$D$36:$F$36)*Monitoring!$C$17*Monitoring!$C$18,0)","v":0},{"$f":"IF(Monitoring!$C$15=\"yes\", Properties!$F$4*Monitoring!$C$16/100*MEDIAN('Cost Data Sources'!$D$36:$F$36)*Monitoring!$C$17*Monitoring!$C$18,0)","v":0},{"$f":"IF(Monitoring!$C$15=\"yes\", Properties!$F$4*Monitoring!$C$16/100*MAX('Cost Data Sources'!$D$36:$F$36)*Monitoring!$C$17*Monitoring!$C$18,0)","v":0},"over",{"$f":"Monitoring!C17","v":0},"years"]
[null,null,"Air treatment system",{"$f":"IF(Monitoring!$C$15=\"yes\",Properties!$F$4*Monitoring!$C$19/100*MIN('Cost Data Sources'!$D$34:$F$34)+Properties!$F$4*Monitoring!$C$19/100*MIN('Cost Data Sources'!$D$35:$F$35)*Monitoring!$C$20+Properties!$F$4*Monitoring!$C$19/100*MIN('Cost Data Sources'!$D$36:$F$36)*Monitoring!$C$20*Monitoring!$C$21,0)","v":0},{"$f":"IF(Monitoring!$C$15=\"yes\",Properties!$F$4*Monitoring!$C$19/100*MEDIAN('Cost Data Sources'!$D$34:$F$34)+Properties!$F$4*Monitoring!$C$19/100*MEDIAN('Cost Data Sources'!$D$35:$F$35)*Monitoring!$C$20+Properties!$F$4*Monitoring!$C$19/100*MEDIAN('Cost Data Sources'!$D$36:$F$36)*Monitoring!$C$20*Monitoring!$C$21,0)","v":0},{"$f":"IF(Monitoring!$C$15=\"yes\",Properties!$F$4*Monitoring!$C$19/100*MAX('Cost Data Sources'!$D$34:$F$34)+Properties!$F$4*Monitoring!$C$19/100*MAX('Cost Data Sources'!$D$35:$F$35)*Monitoring!$C$20+Properties!$F$4*Monitoring!$C$19/100*MAX('Cost Data Sources'!$D$36:$F$36)*Monitoring!$C$20*Monitoring!$C$21,0)","v":0},"over",{"$f":"Monitoring!C20","v":0},"years"]
[]
[null,null,"Soil monitoring",{"$f":"IF(Monitoring!$C$24=\"yes\", Monitoring!$C$25*MIN('Cost Data Sources'!$D$46:$F$46)*Monitoring!$C$26*Monitoring!$C$27*Monitoring!$C$28,0)","v":0},{"$f":"IF(Monitoring!$C$24=\"yes\", Monitoring!$C$25*MEDIAN('Cost Data Sources'!$D$46:$F$46)*Monitoring!$C$26*Monitoring!$C$27*Monitoring!$C$28,0)","v":0},{"$f":"IF(Monitoring!$C$24=\"yes\", Monitoring!$C$25*MAX('Cost Data Sources'!$D$46:$F$46)*Monitoring!$C$26*Monitoring!$C$27*Monitoring!$C$28,0)","v":0},"over",{"$f":"Monitoring!C26","v":0},"years"]
[null,null,"Surface water monitoring",{"$f":"IF(Monitoring!$C$31=\"yes\", Monitoring!$C$32*MIN('Cost Data Sources'!$D$30:$F$30)*Monitoring!$C$33*Monitoring!$C$34*Monitoring!$C$35,0)","v":0},{"$f":"IF(Monitoring!$C$31=\"yes\", Monitoring!$C$32*MEDIAN('Cost Data Sources'!$D$30:$F$30)*Monitoring!$C$33*Monitoring!$C$34*Monitoring!$C$35,0)","v":0},{"$f":"IF(Monitoring!$C$31=\"yes\", Monitoring!$C$32*MAX('Cost Data Sources'!$D$30:$F$30)*Monitoring!$C$33*Monitoring!$C$34*Monitoring!$C$35,0)","v":0},"over",{"$f":"Monitoring!C33","v":0},"years"]
[]
[null,null,"monitoring totals",{"$f":"SUM(D16:D24)","v":0},{"$f":"SUM(E16:E24)","v":0},{"$f":"SUM(F16:F24)","v":0}]
[]
[]
[null,null,"Institutional Controls"]
[null,null,"Restrictive covenants",{"$f":"Properties!$F$4*'Institutional Controls'!$C$3/100*MIN('Cost Data Sources'!$D$49:$F$49)","v":0},{"$f":"Properties!$F$4*'Institutional Controls'!$C$3/100*MEDIAN('Cost Data Sources'!$D$49:$F$49)","v":0},{"$f":"Properties!$F$4*'Institutional Controls'!$C$3/100*MAX('Cost Data Sources'!$D$49:$F$49)","v":0}]
[null,null,"Ordinances",{"$f":"'Institutional Controls'!$C$4*MIN('Cost Data Sources'!$D$50:$F$50)","v":0},{"$f":"'Institutional Controls'!$C$4*MEDIAN('Cost Data Sources'!$D$50:$F$50)","v":0},{"$f":"'Institutional Controls'!$C$4*MAX('Cost Data Sources'!$D$50:$F$50)","v":0}]
[]
[null,null,"IC totals",{"$f":"SUM(D30:D31)","v":0},{"$f":"SUM(E30:E31)","v":0},0]
[]
[]
[null,null,"Oversight"]
[null,null,"Staffing",{"$f":"Oversight!$C$4*Oversight!$C$5*MIN('Cost Data Sources'!D44:F44)","v":0},{"$f":"Oversight!$C$4*Oversight!$C$5*MEDIAN('Cost Data Sources'!D44:F44)","v":0},{"$f":"Oversight!$C$4*Oversight!$C$5*MAX('Cost Data Sources'!D44:F44)","v":0}]
[null,null,"Reporting",{"$f":"Oversight!$C8*Oversight!$C10*MIN('Cost Data Sources'!D39:F39)+IF(Oversight!C9=\"yes\",INT(Oversight!C10/5)*MIN('Cost Data Sources'!D41:F41),0)","v":0},{"$f":"Oversight!$C8*Oversight!$C10*MEDIAN('Cost Data Sources'!D39:F39)+IF(Oversight!C9=\"yes\",INT(Oversight!C10/5)*MEDIAN('Cost Data Sources'!D41:F41),0)","v":0},{"$f":"Oversight!$C8*Oversight!$C10*MAX('Cost Data Sources'!D39:F39)+IF(Oversight!C9=\"yes\",INT(Oversight!C10/5)*MAX('Cost Data Sources'!D41:F41),0)","v":0}]
[]
[null,null,"oversight totals",{"$f":"SUM(D37:D38)","v":0},{"$f":"SUM(E37:E38)","v":0},0]
[]
[]
[null,null,"Surface Water Impacts"]
[null,null,"Surface Water Impacts",{"$f":"IF('Surface Water'!C3=\"yes\",IF('Surface Water'!C9=\"yes\",MIN('Cost Data Sources'!$D71:$F71)*'Surface Water'!$C10*'Surface Water'!$C11*13.5,0) + IF('Surface Water'!C6=\"yes\",MIN('Cost Data Sources'!$D72:$F72)*'Surface Water'!$C7*'Surface Water'!$C8*13.5,0) + IF('Surface Water'!C12=\"yes\",MIN('Cost Data Sources'!$D73:$F73)*'Surface Water'!$C13*'Surface Water'!$C14*13.5,0),0)","v":0},{"$f":"IF('Surface Water'!C3=\"yes\",IF('Surface Water'!C9=\"yes\",MEDIAN('Cost Data Sources'!$D71:$F71)*'Surface Water'!$C10*'Surface Water'!$C11*13.5,0) + IF('Surface Water'!C6=\"yes\",MEDIAN('Cost Data Sources'!$D72:$F72)*'Surface Water'!$C7*'Surface Water'!$C8*13.5,0) + IF('Surface Water'!C12=\"yes\",MEDIAN('Cost Data Sources'!$D73:$F73)*'Surface Water'!$C13*'Surface Water'!$C14*13.5,0),0)","v":0},{"$f":"IF('Surface Water'!C3=\"yes\",IF('Surface Water'!C9=\"yes\",MAX('Cost Data Sources'!$D71:$F71)*'Surface Water'!$C10*'Surface Water'!$C11*13.5,0) + IF('Surface Water'!C6=\"yes\",MAX('Cost Data Sources'!$D72:$F72)*'Surface Water'!$C7*'Surface Water'!$C8*13.5,0) + IF('Surface Water'!C12=\"yes\",MAX('Cost Data Sources'!$D73:$F73)*'Surface Water'!$C13*'Surface Water'!$C14*13.5,0),0)","v":0}]
[]
[null,null,"surface water impacts totals",{"$f":"SUM(D44:D45)","v":0},{"$f":"SUM(E44:E45)","v":0},0]
[]
[]
[]
[]
[]
[null,null,"TOTAL COSTS",{"$f":"SUM(D40,D26,D12,D46,D33)","v":0},{"$f":"SUM(E40,E26,E12,E46,E33)","v":0},{"$f":"SUM(F40,F26,F12,F46,F33)","v":0}]
[]
[]
[]
[null,null,"Other Remedial Activities"]
[null,null,"Pump and treat",{"$f":"MIN('Cost Data Sources'!$D$57:$F$58)+(MIN('Cost Data Sources'!$D$54:$F$56)*Background!$C$8)","v":2484351.7786561265},{"$f":"MEDIAN('Cost Data Sources'!$D$57:$F$58)+(MEDIAN('Cost Data Sources'!$D$54:$F$56)*Background!$C$8)","v":4687231.8414513497},{"$f":"MAX('Cost Data Sources'!$D$57:$F$58)+(MAX('Cost Data Sources'!$D$54:$F$56)*Background!$C$8)","v":8622162.0553359687},"over",{"$f":"Background!C8","v":0},"years"]
[null,null,"Permeable Reactive Barrier",{"$f":"'Cost Data Sources'!D59","v":643008.69565217395},{"$f":"'Cost Data Sources'!E59","v":993740.71146245056},{"$f":"'Cost Data Sources'!F59","v":1461383.3992094861}]
[null,null,"Hydraulic control",{"$f":"MIN('Cost Data Sources'!$D$60:$F$61)","v":2132462.3334556413},{"$f":"MEDIAN('Cost Data Sources'!$D$60:$F$61)","v":6921889.6948486548},{"$f":"MAX('Cost Data Sources'!$D$60:$F$61)","v":11711317.056241669}]
[null,null,"In-situ chemical oxidation",{"$f":"MIN('Cost Data Sources'!$D63:$F63)","v":12166922.185389016},{"$f":"MEDIAN('Cost Data Sources'!$D63:$F63)","v":12166922.185389016},{"$f":"MAX('Cost Data Sources'!$D63:$F63)","v":12166922.185389016}]
[null,null,"In-situ thermal remediation",{"$f":"MIN('Cost Data Sources'!$D64:$F64)","v":17206689.302463844},{"$f":"MEDIAN('Cost Data Sources'!$D64:$F64)","v":17206689.302463844},{"$f":"MAX('Cost Data Sources'!$D64:$F64)","v":17206689.302463844}]
[null,null,"in-situ bioremediation",{"$f":"MIN('Cost Data Sources'!$D62:$F62)","v":29538.211956521754},{"$f":"MEDIAN('Cost Data Sources'!$D62:$F62)","v":210987},{"$f":"MAX('Cost Data Sources'!$D62:$F62)","v":8017514.6739130476}]
[null,null,"soil excavation",{"$f":"MIN('Cost Data Sources'!$D65:$F65)*H63","v":0},{"$f":"MEDIAN('Cost Data Sources'!$D65:$F65)*H63","v":0},{"$f":"MAX('Cost Data Sources'!$D65:$F65)*H63","v":0},"for",0,"tons of removal"]
[null,null,"soil vapor extraction",{"$f":"MIN('Cost Data Sources'!$D66:$F66)","v":53211},{"$f":"MEDIAN('Cost Data Sources'!$D66:$F66)","v":302204},{"$f":"MAX('Cost Data Sources'!$D66:$F66)","v":1692398.8869565227}]
[null,null,"air sparging",{"$f":"MIN('Cost Data Sources'!$D67:$F67)","v":28885.558130434798},{"$f":"MEDIAN('Cost Data Sources'!$D67:$F67)","v":190960.32055434794},{"$f":"MAX('Cost Data Sources'!$D67:$F67)","v":485270.62500000029}]

{"sheet":"Charts","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cost Data Sources","index":11,"n_rows":126,"n_cols":12,"rows_kept":126,"cut":false,"hidden":false,"merged":[[2,3,2,6]]}
[null,"Cost Spreadsheet"]
[]
[null,null,null,"Cost"]
[null,"Municipal Water",null,"Lower \nbound","Expected \nCost 1","Upper \nbound",null,"Units","Price Year","Freq.","Source"]
[null,null,"Municipal Water Bill",640,959,1277,null,null,2020,"Annual","aa"]
[null,null,"Municipal Water Bill",null,612,null,null,null,2020,"Annual","KLA"]
[null,null,"Municipal Hookup ",null,12000,null,null,null,2020,"Once","KLA"]
[null,null,"Water Mainline",null,222,null,null,"linear foot",2020,"Once","KLA"]
[null,null,"Municipal Hookup + Mainline",16400,18450,20500,null,null,2020,"Once","d, e"]
[null,null,"Operating cost of well",300,350,500,null,null,2020,"Annual","hh"]
[]
[null,"Well Replacement/sealing"]
[null,null,"Well Drilling & Install",null,22541.017824851453,null,null,"Well",2020,"Once","KLA,"]
[null,null,"Well Drilling & Install",1432.6918109015755,8023.0741410488226,14613.45647119607,null,"Well",2020,"Once","b, c"]
[null,null,"Well Drilling & Install",3750,{"$f":"AVERAGE(D15,F15)","v":9525},15300,null,"Well",2020,"Once","ii"]
[null,null,"Well Drilling & Install (per foot)",25,{"$f":"AVERAGE(D16,F16)","v":43},61,null,"Foot",2020,"Once","ii"]
[null,null,"Abandon Existing Well",764.10229914750687,1098.3970550245413,1432.6918109015755,null,"Well",2020,"Once","k"]
[null,null,"Abandon Existing Well",null,3820.5114957375345,null,null,"Well",2020,"Once","KLA"]
[]
[null,"Water Delivery"]
[null,null,"Bottled Water",null,35,null,null,null,2020,null,"j"]
[null,null,"Bottled Water",null,20,null,null,null,2020,null,"KLA"]
[]
[null,"Groundwater Monitoring"]
[null,null,"Monitoring Wells",8332,45700,75731,null,"per well",2020,"Once","a, KLA, pp (Appendix D)"]
[null,null,"Lab Test",null,478.5,null,null,"per test",2020,"Irregular","a"]
[null,null,"Monitor Well Analysis",1078,{"$f":"AVERAGE(D27,F27)","v":1617},2156,null,"per well",2020,"Annual","KLA"]
[]
[null,"Surface water Monitoring"]
[null,null,"Lab Test",null,478.5,null,null,"per test",2020,"Irregular","a"]
[]
[null,"Household Costs"]
[null,null,"Testing existing wells",null,478.5,null,null,"per test",2020,"Annual"]
[null,null,"VOC System Installation",null,11631.7603677932,null,null,"per house",2020,"Once","a"]
[null,null,"VOC Operating Costs + Depreciation",100,348.95281103379602,500,null,"per house",2020,"Annual","a"]
[null,null,"Onsite VOC Test",280,420,560,null,"per test",2020,"Irregular","bb"]
[]
[null,"Site Management and Monitoring Costs"]
[null,null,"Reports to agencies",57400,57400,57400,null,"Site",2020,"Annual","KLA"]
[null,null,"Annual Operating costs ($16,500/yr)",16500,16500,16500,null,"Site",2020,"Annual","KLA"]
[null,null,"5-Year Review (Superfund)",20000,20000,20000,null,"Site",2020,"5-year","rr"]
[null,null,"Remediation Action Plan (RAP)",4000,{"$f":"AVERAGE(D42,F42)","v":19500},35000,null,"Site",2020,null,"ii"]
[]
[null,"FTE Oversight cost",null,47000,87000,120000,null,"per FTE/year",2020,null,"BLS occupation OCC"]
[]
[null,"Soil VOC Gas Monitoring",null,null,4049,null,null,"per test",2020,null,"kk"]
[]
[null,"Institutional Controls"]
[null,null,"Restrictive Covenant",1098,{"$f":"AVERAGE(D49,F49)","v":3080},5062,null,"per RC",2020,"once","jj, kk","assuming 4 hours of legal fees for MI-bar 2020 average ($267/hr) + typical $30 recording fee"]
[null,null,"Ordinance",24042,{"$f":"AVERAGE(D50,F50)","v":37021},50000,null,"per ordinance",2020,"once","KLA, ll"]
[]
[]
[null,"Active Treatment"]
[null,null,"Pump and treat O&M",null,1294511.5383023943,null,null,null,2020,"annual","mm (Table 3-1)"]
[null,null,"Pump and treat O&M",null,1548841.4428503085,null,null,null,2020,"annual","pp (Appendix D)"]
[null,null,"Pump and treat O&M",263049.01185770752,379959.68379446643,1066809.881422925,null,null,2020,"annual","qq (Exhibit 3)"]
[null,null,"Pump and treat",null,6451696.8844837276,null,null,null,2020,"capital cost","pp (Appendix D)"]
[null,null,"Pump and treat",2484351.7786561265,2922766.7984189722,8622162.0553359687,null,null,2020,"capital cost","qq (Exhibit 3)"]
[null,null,"Permeable Reactive Barrier",643008.69565217395,993740.71146245056,1461383.3992094861,null,null,2020,"capital cost","qq (Exhibit 3)"]
[null,null,"hydraulic control",null,11711317.056241669,null,null,null,2020,"capital cost","pp (Appendix D)"]
[null,null,"hydraulic control",null,2132462.3334556413,null,null,null,2020,"annual","pp (Appendix D)"]
[null,null,"in-situ bioremediation",29538.211956521754,210987,8017514.6739130476,null,null,2020,"capital cost","ww"]
[null,null,"in-situ chemical oxidation",null,12166922.185389016,null,null,null,2020,"capital cost","nn"]
[null,null,"in-situ thermal remediation",null,17206689.302463844,null,null,null,2020,"capital cost","nn"]
[null,null,"soil excavation",65,75,150,null,"per ton",2020,"capital cost","vv"]
[null,null,"soil vapor extraction",53211,302204,1692398.8869565227,null,null,2020,"capital cost","vv, ww"]
[null,null,"air sparging",28885.558130434798,190960.32055434794,485270.62500000029,null,null,2020,"capital cost","ww"]
[]
[]
[null,"Recreational Expenditures"]
[null,null,"Recreational Fishing Spending",{"$f":"(1-0.1)*E71","v":31.5},35,{"$f":"(1+0.1)*E71","v":38.5},null,"per fishing day",2020,null,"ss"]
[null,null,"Beach visits",35,40,75,null,"Per visitor day",2020,null,"tt"]
[null,null,"Boating Visits",150,{"$f":"(F73+D73)/2","v":250},350,null,"per boating day",2020,null,"uu"]
["Sources"]
[]
["a","National Research Council. 2013. Alternatives for managing the nation's complex contaminated groundwater sites: National Academies Press.","EPA. 2008. Indoor Air Vapor Intrusion Mitigation Approaches. EPA. https://www.epa.gov/sites/default/files/2015-09/documents/600r08115.pdf"]
["b","https://homeguide.com/costs/well-drilling-cost"]
["c","https://www.homeadvisor.com/cost/landscape/drill-a-well/"]
["d","EGLE legislative report (p.262, pdf 8) lists EGLE expense of $82,000 for homes on 4th street between M-43 and Almena Drive. Looking on Zillow appears to be 5 homes"]
["e","https://www.mlive.com/news/kalamazoo/2015/12/more_oshtemo_township_properti.html (60 homes at $1.23 million)"]
["f","Figure2 3rd FYR (p. 51 - 1990 ROD)"]
["g","Figure3 and 4 3rd FYR (p. 52,53 - 2003 and 2005 municipal supply area)"]
["h","3rd FYR p. 42"]
["i","3rd FYR p. 15 (addional 92 in projected GRZ zone)"]
["j","Sara Pearson email 2/4/22"]
["k","https://www.michigan.gov/egle/0,9429,7-135-3313_3675_3689-8003--,00.html#:~:text=Q%3A%20How%20much%20will%20it,well%20in%20Michigan%20is%20%24500.","https://www.cityofmadison.com/water/water-quality/private-wells/well-abandonment/well-abandonment-frequently-asked-questions#:~:text=A%20%E2%80%9Ctypical%E2%80%9D%20abandonment%20costs%20%24800%20-%20%241500%20but,available%20to%20help%20pay%20for%20the%20well%20abandonment%3F"]
["l","EPA 3rd 5-year (p.9)"]
["m","2005 ROD (p.5, pdf 10)"]
["n","Legislative report (p.257, pdf 3)"]
["o","EPA 3rd 5-year (p.59)"]
["p","EPA 3rd 5-year (p.6)"]
["q","EPA 1st 5-year (p. 13)"]
["r","2005 ROD (p. 1, pdf 6)"]
["s","EPA 1st 5-year (p.14)"]
["t","EPA 3rd 5-year (p.16, 42)"]
["u","2005 ROD (p. 3, pdf 8)"]
["v","2005 ROD (p. 6, pdf 11)"]
["w","EPA 3rd 5-year (p.6)"]
["x","EPA 3rd 5-year (p.10)"]
["y","https://www.mlive.com/news/kalamazoo/2015/12/more_oshtemo_township_properti.html"]
["z","EPA 3rd 5-year (p.14)"]
["aa","https://graham.umich.edu/media/files/MI-statewide-water-affordability-assessment-report.pdf","table 3"]
["bb","Angi.com: https://www.angi.com/articles/how-much-does-indoor-air-quality-testing-cost.htm","2022-04-14"]
["cc","EPA. 2001. Groundwater Pump and Treat Systems: Summary of Selected Cost and Performance Information at Superfund-financed Sites. Washington, DC: Environmental Protection Agency."]
["dd","https://www.bls.gov/oes/current/oes_stru.htm#19-0000 (19-4040  Environmental Science and Geoscience Technicians)"]
["ee","https://www.landsearch.com/industrial/michigan"]
["oes","https://www.bls.gov/oes/current/oes_nat.htm#21-0000"]
["ff","https://www.mswmanagement.com/landfills/article/13003375/landfill-economics-part-3-closing-up-shop"]
["gg","https://www.homeadvisor.com/cost/outdoor-living/pave-a-parking-lot/"]
["KLA","The KLA Group "]
["hh","https://mywaterearth.com/well-water-vs-city-water-cost/"]
["ii","https://emsenv.com/2016/04/28/remedial-action-plan-cost/#:~:text=We%20have%20developed%20RAPs%20ranging,%2435%2C000%20for%20large%20chemical%20spills."]
["jj","https://www.michbar.org/file/pmrc/articles/0000155.pdf"]
["kk","Charlevoix - USACE Focused Feasability Study (2019)"]
["ll","Wickes - MACTEC Evaluation of Interim Response Activities (2008)"]
["mm","ARCADIS Remedial Investigation Plan (2012)"]
["nn","Wash King proposed remediation plan for OU2 (2019)"]
["oo","Wash King 3rd FYR (2016)"]
["pp","MACTEC 2008 Evaluation of Interim Response Activites (2008)"]
["qq","https://www.epa.gov/sites/default/files/2015-04/documents/cost_analysis_groundwater.pdf"]
["rr","https://www.michigan.gov/egle/-/media/Project/Websites/egle/Documents/Reports/RRD/Report-2021-06-Federal-Superfund-FY20.pdf"]
["ss","Creel Clerks & Angler Surveys (michigan.gov)"]
["tt","Spending Pattern of Outdoor Recreation Visitors to National Forests (wi.gov)"]
["uu","https://www.townandtourist.com/boat-transportation-cost/ ",null,"2023-10-27"]
["vv","https://www.waterboards.ca.gov/water_issues/programs/ustcf/docs/cost_guidelines/202011_remediation_cost_guidelines_appendix.pdf"]
["ww","https://semspub.epa.gov/work/HQ/189904.pdf"]

{"sheet":"ResponseDomains","index":12,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Background"]
[1]
[2,"yes"]
[null,"no"]
[null,"unsure"]
[]
[]
[3,"bedrock"]
[null,"sand and gravel"]
[null,"silts and clays"]
[null,"unsure"]
[]
[]
[4,"yes"]
[null,"no"]
[null,"unsure"]
[]
[]
[5,"yes"]
[null,"no"]
[null,"unsure"]
[]
[]
[]
[]
[]
["Water Access"]
[9,"yes"]
[null,"no"]
[null,"unsure"]