{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["About","Help","ScoresheetA","ScoresheetB","Graphs A","Graphs B","Soil Data"],"not_rendered":{"charts":3,"images":16,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"About","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,5,16],[22,1,26,16],[13,1,20,16],[6,1,11,16]]}
[]
[null,"The U.S. Environmental Protection Agency (EPA) tasked Tetra Tech, Inc. (Tetra Tech) to develop a decision support tool that local and state stakeholders can use to evaluate the short- and long-term economic, environmental, and social (EES) costs and benefits of various alternatives for managing dredge material from Federal Navigation Channels in the Lake Erie Basin.  This work was assigned under Superfund Technical Assessment and Response Team (START) Contract No. EP-S5-13-01, Technical Direction Document (TDD) No. S05-0003-1609-016, as part of the Targeted Brownfields Assessment (TBA) program. "]
[]
[]
[]
[]
[null,"The decision support tool is not fully developed and is conceptual at this stage.  The tool includes two scoresheets (Scoresheet A and Scoresheet B) that represent its front-end.  Scoresheet A uses a sliding-scale to evaluate alternatives, and Scoresheet B uses a binary scale (yes/no responses).  While Scoresheet A allows fine-tuning of scores for each sub-criterion, it relies on the user's judgment when scores are entered. On the other hand, Scoresheet B offers a simpler user-experience, requiring the user to decide only if an alternative complies with a certain sub-criterion or not.  Therefore, Scoresheet B removes subjectivity from the analysis although it cannot differentiate among alternatives that comply with all the same sub-criteria but to different degrees.  Each scoresheet has its advantages and may be the more appropriate tool in different situations.    "]
[]
[]
[]
[]
[]
[]
[null,"Both scoresheets rely on weighting of evaluation criteria.  That is, if certain criteria are applied to evaluate an alternative, some criteria could be more important than others. Therefore, more weight is given to more important criteria and less weight is given to less important criteria.  To generate the evaluation criteria and determine their relative importance, EPA's Office of Research and Development (ORD) and Region 5 office engaged in research with collaborative stakeholder interaction and feedback. This research led to the development and refinement of 50 project criteria in categories of biophysical environment, economy, social considerations, governance, and built environment.   "]

{"sheet":"Help","index":1,"n_rows":336,"n_cols":4,"rows_kept":336,"cut":false,"hidden":false,"merged":[[271,1,273,3],[195,1,196,3],[64,0,64,2],[335,1,336,3],[70,1,70,3],[115,1,116,3],[139,1,141,3],[286,1,288,3],[305,1,307,3],[77,1,78,3],[105,1,106,3],[217,1,217,3],[224,1,225,3],[149,1,151,3],[124,1,126,3],[92,1,93,3],[167,1,169,3],[239,1,240,3],[252,1,253,3],[262,1,263,3]]}
["USER GUIDANCE"]
[]
[]
[]
[]
[]
[]
[]
[]
["Row No. ","EES Criterion","Description","Sub-criterion or Metric"]
[30,"Rivers and streams habitat quantity gain/loss","River and streams habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[31,"Lakes and ponds habitat quantity gain/loss","Lakes and ponds habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[32,"Near coastal marine/estuarine habitat quantity gain/loss","Near coastal marine and estuarine habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[33,"Open water habitat quantity gain/loss","Open water habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[34,"Wetlands habitat quantity gain/loss","Wetlands habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[35,"Urban/suburban habitat quantity gain/loss","Urban and suburban habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[36,"Barren/rock and sand habitat quantity gain/loss","Barren landscape or rock and sand habitat creation or loss.","Will the reuse alternative increase the habitat type quantity?"]
[37,"Rivers and streams habitat quality improved/harmed","Quality of rivers and streams habitat affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[38,"Lakes and ponds habitat quality improved/harmed","Quality of lakes and ponds habitat affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[39,"Near coastal marine/estuarine habitat quality improved/harmed","Quality of near coastal marine and estuarine habitat affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[40,"Open water habitat quality improved/harmed","Quality of open water habitat affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[41,"Wetlands habitat quality improved/harmed","Quality of wetlands habitat affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[42,"Urban/suburban habitat quality improved/harmed","Quality of urban and suburban habitat creation affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[43,"Barren/rock and sand habitat quality improved/harmed","Quality of barren landscape or rock and sand habitat affected.","Will the reuse alternative affect the quality of the habitat type positively?"]
[44,"Impact on priority habitat","Some alternatives may emphasize the creation of a priority habitat, providing distinct desired habitat characteristics for specific organisms. ","Will the reuse alternative benefit priority habitat?"]
[45,"Benefit to species of management concern","Different alternatives may use dredged materials to benefit species of management concern. ","Will the reuse alternative benefit species of management concern?"]
[46,"Restoration of native vegetation","Dredged materials may be used to provide soil for planting and enhancement of native vegetation; increasing biodiversity, reducing stormwater runoff, and storing greenhouse gases. ","Will the reuse alternative restore native vegetation?"]
[47,"Reduction of invasive species","Dredged materials may replace sediment or structures inhabited by non-native species that can decrease biodiversity and negatively impact native organisms. ","Will the reuse alternative reduce invasive species?"]
[48,"Increase stormwater control/protection","Dredged materials can be used to build up stormwater control or protection through the creation of stormwater retention wetlands and greenspace to replace impervious surfaces. ","Will the reuse alternative increase stormwater control or protection?"]
[49,"Influence biophysical environment by reducing contamination","Dredged materials can be used to influence the biophysical environment by reducing contamination. This can be done by capping contaminated areas, replacing contaminated soil, and using stormwater control methods to prevent runoff from contaminated sites; thus, reducing the mobility and interaction between organisms and contaminants. ","Will the reuse alternative reduce contamination in the biophysical environment?"]
[50,"Funding pathway identified","Funding possibilities can depend on project design and can be applied to different phases of projects if needed. Securing funding or a funding pathway is necessary to execute a beneficial use project.","Is a funding pathway prepared for the reuse alternative?"]
[51,"Funding application prepared","Different funding sources may be available for different types of reuse alternatives and will require specific application information. Assembling the necessary information for funding applications can be a time-consuming, energy-intensive effort.","Is funding application information prepared?"]
[52,"Partnerships established","Beneficial reuse of dredged material involves complex networks of agencies and organizations. Having partnerships for projects established and in coordination with each other improves capacity, efficiency, and transparency.","Are all parties responsible for permits and planning in coordination regarding the reuse alternative?"]
[53,"Potential partnerships identified","Reusing dredged material involves complex networks of agencies and organizations and the ability to adapt to unforeseen challenges and complications throughout each stage of project processes. Identifying potential partners before these challenges arise may reduce the amount of resources required to mitigate during project implementation.","Have potential project partnerships been identified? "]
[54,"Feasible transportation of dredged materials to placement site","Feasible transportation of dredged materials from their site of extraction and/or processing to a reuse alternative site is necessary. Multiple factors influence transportation feasibility, including cost, regulation, and transportation infrastructure.","Is the transportation to the alternative reuse site feasible?"]
[55,"Accept materials (5 years)","Projects that can accept material for up to 5 years offer certainty/stability for operations and a longer planning window for developing alternative reuse options. ","Will the placement site accept/use materials for 5 years?"]
[56,"Accept materials long-term (20 years)","Projects that can accept material for up to 20 years offer certainty/stability for operations and a longer planning window for developing alternative reuse options. ","Will the placement site accept/use materials for 20 years?"]
[57,"Lead to creation/growth of viable business","Business profit is an indicator that a reuse alternative is self-sustaining and viable.","Does the reuse alternative lead to the creation or growth of viable business?"]
[58,"Secondary benefits created","Reuse of sediment converts burdens and impacts to environmental and economic gains.  Alternatives can contribute to economic activity or savings beyond the capital cost of reuse.","Does the reuse alternative produce secondary economic benefits?"]
[59,"Long-term maintenance required","Some project designs need long-term monitoring or maintenance, which may require future spending after a reuse alternative has been funded and completed. ","Will the reuse alternative require long-term maintenance or management?"]
[60,"Improve access to parks or natural spaces","Economically depressed and minority communities often have fewer public amenities, including parks and public greenspaces.","Does the reuse alternative create or improve public park space in an economically depressed or minority community? "]
[61,"Potential for indirect job creation","Beneficial reuse projects offer an opportunity of indirectly creating jobs in economically depressed or minority neighborhoods. Indirect jobs can result from the use or development of space remediated with dredged material or from a boost in local economic activity attributed to remediated or restored space(s). ","Does the reuse alternative have potential for indirect job creation?"]
[62,"Improve aesthetics","Economically depressed and minority communities often suffer from an increased prevalence of blighted or poorly maintained property. Beneficial reuse projects can provide opportunities to improve the aesthetics of local neighborhoods.","Does the reuse alternative eliminate blight or improve aesthetics in an economically depressed or minority community?"]
[63,"Community engagement","Community engagement and participation is an important consideration for project design and can strengthen public support for a beneficial reuse project. Communities involved in a project’s design and implementation are more likely to support and help maintain that project. ","Is the local community involved in providing feedback on needs, planning, and process of the reuse alternative?  "]
[64,"Reduced human exposure to contaminants","Beneficial reuse projects can improve human health by reducing human exposure to environmental and/or legacy contaminants. Suitable dredged material can be used to cap contaminants or replace removed contaminated material. ","Does the reuse alternative reduce human exposure to contaminants?"]
[65,"Improved access to ecosystem services","Beneficial reuse projects can improve or re-introduce a local provision of ecosystem services. Greenspace areas that have been constructed, remediated, or restored with suitable dredged material can improve the quantity and quality of ecosystem services, which has corresponding direct and indirect benefits for human health.","Does the reuse alternative improve ecosystem services provision to the public?"]
[66,"Improved infrastructure condition","Insufficient, damaged, or aging infrastructure can benefit from beneficial reuse projects. Dredged sediment can be used as a component in engineered construction material or for other infrastructure construction needs including site drainage and fill material. This improves environmental impact and public safety. ","Does the reuse alternative improve condition of infrastructure?"]
[67,"New/improved infrastructure services for community","Restoring or completing new infrastructure as part of a beneficial reuse project can improve capacity and safety for a community. Sufficient infrastructure in a community improves safety, is attractive for commerce and industry, and copes better with weathering and storm events. ","Does the reuse alternative offer new or improve existing infrastructure service to a community?"]
[68,"Maintain navigation channels ","Dredging maintains the necessary draft for the passage of ships and barges carrying goods. ","Does the reuse alternative maintain or increase draft for shipping? "]
[69,"Enrollment in voluntary program","To meet regulatory requirements, certain types of contaminated sites can be enrolled in state and federal voluntary programs that provide technical assistance with site investigations and cleanup. ","Is the reuse alternative enrolled in a voluntary program? "]
[70,"Able to complete within environmental windows","Aspects of dredging are restricted to certain time periods known as environmental windows to reduce the risk of impact by project activities to sensitive life stages of species and habitats. ","Will the dredging and placement be completed within the relevant environmental windows? "]
[71,"Included in existing guidance documents","If the proposed project site is part of an AOC or other program recognized at a federal or state level, there may be existing guidance documents that include references to or plans for the site. ","Is the reuse alternative referred to or included in existing guidance documents? "]
[72,"Permitting timeline conducive with project timeline","Different governing bodies require specific permits for planning and restoration activities. Often these permits pertain to sediment, water, and air quality. Time and resources for acquisition of permits varies. ","Is the timeline for permitting conducive to the project timeline? "]
[73,"Meets zoning requirements","Zoning provides a legal framework for land use. ","Does the reuse alternative meet zoning requirements?   "]
[74,"Flexible timeframe","Projects reusing dredged materials are often complex and must be adapted to meet unforeseen complications. Hhaving a contingency plan can reduce the risk of uncertainty and improve continuity of work. ","Has a contingency plan been established for the reuse alternative? "]
[75,"Replicable","Reuse alternatives that can be replicated in other locations increase their success by being adoptable and predictable.  The more replicable alternatives can foster growth of reuse businesses.","Is the reuse alternative replicable in other harbors, ports, environments, and jurisdictions?"]
[76,"Site ownership","Ownership of land/property where dredged material may be reused needs to be determined, along with ownership of any future land masses created.  ","Have the owner(s) of the potential project site been identified for the reuse alternative? "]
[77,"Reduce contamination","Within the built environment, contaminant reduction is often based on end use standards for the site. Use standards for zoning may determine the required level of contaminant reduction based on the proposed end use of a site (housing, industrial, recreational). ","Does the reuse alternative meet requirements specifically pertaining to reducing contaminants to required levels for end use?   "]
[78,"Diversion to construction","Dredged sediment can be a resource to produce engineered materials for the construction industry and displace demand on terrestrial borrow sources and related transport and mitigation costs.","Does the reuse alternative reduce demand on terrestrial borrow sources?"]
[79,"Provide fill or cap (development sites, roads, greenspace)","Dredged sediment can be used as a filling or capping material in environmental remediation.","Does the reuse alternative involve using dredged material as a fill and/or cap for the selected intended use? "]
[]
[]
[]
[]
["USER INSTRUCTIONS FOR SCORECARD A "]
[]
[]
[]
[]
[]
[1,"Enter project-specific information in shaded cells. Unshaded cells will be populated by the decision tool."]
[]
[]
[]
[]
[]
[]
[2,"Check the available disposal capacity for each alternative.  If those data are more than 6 months old, the entry date will be highlighted and warning text will appear so that a developer or high-level user can update those data as necessary.  Whenever those data are updated, the entry date should also be updated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"Enter the volume of sediment to be dredged for each alternative.  The volume should be entered in cubic yards.  Enter only the number without \"cy\".  After entry of the values, this information will appear in the project summary above the scoring table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If the volume of sediment to be dredged exceeds the available disposal capacity for each alternative, a warning will appear.  The user will not be able to score that alternative until that error is corrected.  The error can be corrected by reducing the volume of sediment to be dredged."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,"Enter the lower limit of the weighting factor. The default is 0.05.  This sets the range over which each sub-criterion will be weighted.  The lower limit will indicate the weight given to the sub-criterion with the lowest perceived importance. Increasing the lower limit of the weighting factor will essentially reduce the difference in weight between the most important and least important sub-criterion."]
[]
[]
[]
[]
[]
[]
[]
[]
[5,"The default weighting factor adjustment is 1, which means the weighting factors calculated by the decision tool for each sub-criterion will not be further adjusted.  However, if the user wants to increase the weight given to a particular sub-criterion, the corresponding adjustment factor can be changed from 1 to higher number such as 3, 7, 12, and so on.  If an adjustment factor is changed from the default value, the cell will be highlighted to alert the user.  Additionally, adjustments will be indicated in the project summary above the scoring table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6,"Enter the scoring scale.  The default minimum is 1 and the default maximum is 5, which means the user can enter scores ranging from 1 to 5 for each sub-criterion.  The user may change the minimum value, the maximum value, or both.  For example, to change to a 1 to 10 scale, enter \"10\" for \"Max\" value and allow the \"Min\" value to remain at the default value of 1.  To change to binary scoring, enter \"0\" for \"Min\" value and \"1\" for \"Max\" value.  As the range of the scoring scale decreases, so does the accuracy of the score.  For example, a score of 5 out of 10 cannot be represented on a 1 to 5 scale using only integers."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[7,"Begin scoring the alternatives and enter a score for each sub-criterion (except capital cost) under each alternative.  Scores should be entered under column entitled \"U\" and the score should be within the bounds of the scoring scale.  If a score is not within the bounds of the scoring scale, the cell will be highlighted to alert the user.  The score for the \"Capital Cost\" sub-criterion is calculated by the decision tool and should not be entered by the user."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"As the scoring is completed, percentages calculated in columns entitled \"C\" will change, and  cell shading will change accordingly.  The percentages represent the combined scores for EES criteria relative to the maximum possible scores for each EES criterion.  The color scale varies from red to green, whereby red indicates a low score (undesirable) and green indicates a high score (desirable)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"At the bottom of the table, total scores and ranks are calculated for each alternative.  In the example below, Alternative 1 has received a total score of 11.6 out of 57.85 (or 20 percent), making it the lowest ranked alternative (rank = 3).  Alternative 2 ranks the highest (rank = 1) with a score of 37.8 out of 57.85 (or 56 percent)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["USER INSTRUCTIONS FOR SCORECARD B"]
[]
[]
[]
[]
[]
[1,"Enter project-specific information in shaded cells. Unshaded cells will be populated by the decision tool."]
[]
[]
[]
[]
[]
[]
[2,"Check the available disposal capacity for each alternative.  If those data are more than 6 months old, the entry date will be highlighted and warning text will appear so that a developer or high-level user can update those data as necessary.  Whenever those data are updated, the entry date should also be updated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"Enter the volume of sediment to be dredged for each alternative.  The volume should be entered in cubic yards.  Enter only the number without \"cy\".  After the values have been entered, this information will appear in the project summary above the scoring table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If the volume of sediment to be dredged exceeds the available disposal capacity for each alternative, a warning will appear.  The user will not be able to score that alternative until that error is corrected.  The error can be corrected by reducing the volume of sediment to be dredged."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,"Enter the lower limit of the weighting factor. The default is 0.05.  This sets the range over which each sub-criterion will be weighted.  The lower limit will indicate the weight given to the sub-criterion with the lowest perceived importance. Increasing the lower limit of the weighting factor will essentially reduce the difference in weight between the most important and least important sub-criterion."]
[]
[]
[]
[]
[]
[]
[]
[]
[5,"The default weighting factor adjustment is 1, which means the weighting factors calculated by the decision tool for each sub-criterion will not be further adjusted.  However, if the user wants to increase the weight given to a particular sub-criterion, the corresponding adjustment factor can be changed from 1 to higher number such as 3, 7, 12, and so on.  If an adjustment factor is changed from the default value, the cell will be highlighted to alert the user.  Additionally, adjustments will be indicated in the project summary above the scoring table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6,"Begin scoring the alternatives by responding to each benchmark question (third column) with an \"x\" to answer \"yes,\" and leaving blank to answer \"no.\" If any other character or number is entered, it will be counted as \"no.\"  The entries should be made under the column entitled \"U\".  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"As the scoring is completed, percentages calculated in columns entitled \"C\" will change, and  cell shading will change accordingly.  The percentages represent the combined scores for EES criteria relative to the maximum possible scores for each EES criterion.  The color scale varies from red to green, whereby red indicates a low score (undesirable) and green indicates a high score (desirable)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"At the bottom of the table, total scores and ranks are calculated for each alternative.  In the example below, Alternative 1 has received a total score of 10.51 out of 11.57 (or 91 percent), making it the highest ranked alternative (rank = 1).  Alternative 2 ranks the lowest (rank = 3) with a score of 2.43 out of 11.57 (or 21 percent)."]

{"sheet":"ScoresheetA","index":2,"n_rows":99,"n_cols":31,"rows_kept":99,"cut":false,"hidden":false,"merged":[[29,15,48,15],[29,18,48,18],[29,0,48,0],[29,6,48,6],[29,7,48,7],[29,8,48,9],[29,12,48,12],[79,10,79,16],[9,10,12,18],[26,16,26,18],[27,18,28,18],[20,16,20,18],[19,10,19,18],[25,16,25,18],[25,10,25,12],[26,10,26,12],[25,13,25,15],[26,13,26,15],[59,12,66,12],[59,15,66,15],[59,18,66,18],[67,18,75,18],[76,15,78,15],[28,21,28,22],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,6,28,6],[27,7,28,7],[27,4,28,4],[27,8,27,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[27,13,28,13],[27,14,28,14],[27,15,28,15],[27,16,28,16],[27,17,28,17],[2,0,2,18],[22,10,22,12],[22,13,22,15],[22,16,22,18],[24,10,24,12],[24,13,24,15],[24,16,24,18],[23,10,23,12],[23,13,23,15],[23,16,23,18],[20,10,20,12],[20,13,20,15],[5,10,5,12],[21,10,21,12],[21,13,21,15],[21,16,21,18],[76,0,78,0],[49,12,58,12],[49,15,58,15],[49,18,58,18],[59,0,66,0],[59,6,66,6],[59,7,66,7],[59,8,66,9],[49,0,58,0],[49,6,58,6],[49,7,58,7],[49,8,58,9],[67,15,75,15],[67,0,75,0],[76,18,78,18],[67,6,75,6],[76,6,78,6],[67,7,75,7],[67,8,75,9],[67,12,75,12],[76,7,78,7],[76,8,78,9],[76,12,78,12]]}
["Duluth-Superior Harbor Working Draft"]
["2020-12-11"]
["MAINTENANCE DREDGING SCORECARD A (Duluth-Superior Harbor - February 2020)"]
[]
["Port","Duluth-Superior Harbor"]
["Project No.","ABC-123",null,null,null,null,null,null,null,null,"Cell Color",null,null,"indicates user input"]
["Dredge Location (lat/long)",null,null,null,null,null,null,null,null,null,"Font color",null,1,"indicates user input"]
["Volume (cy)",{"$f":"CONCATENATE(K21,\": \",K23/1000,\"K; \",N21,\": \",N23/1000,\"K; \",Q21,\": \",Q23/1000,\"K\")","v":"Alternative 1: 50K; Alternative 2: 50K; Alternative 3: 50K"},null,null,null,null,null,null,null,null,null,null,null,"scoring color scale"]
["Soil classification"]
["Elevated contaminants",null,null,null,null,null,null,null,null,null,"Scorecard A presents the concept for quantitative scoring of alternatives. The user inputs scores for each criterion under each alternative, and the tool calculates the combined score for each alternative and assigns ranks."]
["Weighting factor adjusted",{"$f":"IF(COUNTIF(E30:E66,\">1\"),CONCATENATE(COUNTIF(E30:E66,\">1\"),\" factor(s) adjusted; maximum adjustment = \",MAX(E30:E66),\"X\"),\"No adjustment\")","v":"No adjustment"}]
["Trial","001"]
["Scorecard No.",{"$f":"CONCATENATE(LEFT(B5,2),\"-\",YEAR(B18),\"-\",MONTH(B18),\"-\",DAY(B18),\"-\",B12)","v":"Du-2020-2-19-001"}]
["Prepared by","<Enter Name>"]
["Prepared on","<Enter Date>",null,null,null,null,null,null,null,null,null,"Click on this button for instructions to use this tool"]
["Checked by","<Enter Name>"]
["Checked on","<Enter Date>"]
["Last Modified","2020-02-19"]
[]
[null,null,null,null,null,null,null,null,null,null,"Scoring"]
[null,null,null,null,null,null,null,null,null,null,"Alternative 1",null,null,"Alternative 2",null,null,"Alternative 3"]
[null,null,null,null,null,null,null,null,null,null,"Description",null,null,"Description",null,null,"Description"]
[null,null,null,null,null,null,null,null,"Sediment to be dredged",null,50000,null,null,50000,null,null,50000]
[null,null,null,null,null,null,null,"Disposal capacity available on","2019-07-19",null,5000000,null,null,1000000,null,null,50000,null,null,{"$f":"IF((B18-I24)>183,\"Caution, data more than 6 months old\",\"\")","v":"Caution, data more than 6 months old"}]
[null,null,null,null,null,null,null,null,"Is sediment dredged ≤ available disposal capacity",null,{"$f":"IF(K23>K24,\"Reduce Volume\",\"OK\")","v":"OK"},null,null,{"$f":"IF(N23>N24,\"Reduce Volume\",\"OK\")","v":"OK"},null,null,{"$f":"IF(Q23>Q24,\"Reduce Volume\",\"OK\")","v":"OK"}]
[]
[]
["Category","Criterion","C Rank","Per-centile","Adjust WF","Weighting Factor (WF)","WF Sum","WF Share","Scoring Scale\n",null,"U","W","C","U","W","C","U","W","C",null,null,null,null,null,null,null,"Graph Controls"]
[null,null,null,null,null,0.05,null,null,1,5,null,null,null,null,null,null,null,null,null,null,null,"Denominator",null,null,null,null,"Category","Alternative 1","Alternative 2","Alternative 3","Maximum Potential Score"]
["Biophysical Environment (20)","Rivers and streams habitat quantity gain/loss",1,{"$f":"_xlfn.PERCENTRANK.INC(C$30:C$79,C30,3)","v":0},1,{"$f":"ROUND((1-((1-F$29)/(MAX($D$30:$D$79)-MIN($D$30:$D$79))*D30))*E30,2)","v":1},{"$f":"SUM(F30:F49)","v":16.330000000000002},{"$f":"G30/SUM(G$30:G$79)","v":0.62138508371385082},{"$f":"CONCATENATE(I$29,\" to \",J$29)","v":"1 to 5"},null,1,{"$f":"$F30*K30*(K$25=\"OK\")","v":1},{"$f":"SUBTOTAL(9,L30:L49)/$W30","v":0.58236374770361288},4,{"$f":"$F30*N30*(N$25=\"OK\")","v":4},{"$f":"SUBTOTAL(9,O30:O49)/$W30","v":0.6220453153704838},3,{"$f":"$F30*Q30*(Q$25=\"OK\")","v":3},{"$f":"SUBTOTAL(9,R30:R49)/$W30","v":0.55835884874464181},null,null,{"$f":"F30*J$29","v":5},{"$f":"SUBTOTAL(9,V30:V49)","v":81.650000000000006},null,null,null,"Biophysical Score",{"$f":"SUM(L30:L49)","v":47.55},{"$f":"SUM(O30:O49)","v":50.790000000000006},{"$f":"SUM(R30:R49)","v":45.590000000000011},{"$f":"W30","v":81.650000000000006}]
[null,"Lakes and ponds habitat quantity gain/loss",2,0.02,1,0.98,null,null,null,null,4,{"$f":"$F31*K31*(K$25=\"OK\")","v":3.92},null,5,4.9000000000000004,null,5,4.9000000000000004,null,null,null,{"$f":"F31*J$29","v":4.9000000000000004},null,null,null,null,"Economy Score",{"$f":"SUM(L50:L59)","v":18.960000000000004},{"$f":"SUM(O50:O59)","v":21.149999999999995},{"$f":"SUM(R50:R59)","v":18.46},{"$f":"W50","v":26.3}]
[null,"Near coastal marine/estuarine habitat quantity gain/loss",3,0.04,1,0.96,null,null,null,null,1,{"$f":"$F32*K32*(K$25=\"OK\")","v":0.96},null,3,{"$f":"$F32*N32*(N$25=\"OK\")","v":2.88},null,4,3.84,null,null,null,{"$f":"F32*J$29","v":4.8},null,null,null,null,"Social Score",{"$f":"SUM(L60:L67)","v":5.5600000000000005},{"$f":"SUM(O60:O67)","v":4.8999999999999995},{"$f":"SUM(R60:R67)","v":5.24},{"$f":"W60","v":14}]
[null,"Open water habitat quantity gain/loss",4,6.0999999999999999E-2,1,0.94,null,null,null,null,1,0.94,null,1,0.94,null,1,0.94,null,null,null,4.6999999999999993,null,null,null,null,"Governance Score",{"$f":"SUM(L68:L76)","v":7.29},{"$f":"SUM(O68:O76)","v":6.1400000000000006},{"$f":"SUM(R68:R76)","v":6.05},{"$f":"W68","v":8.4000000000000021}]
[null,"Wetlands habitat quantity gain/loss",5,8.1000000000000003E-2,1,0.92,null,null,null,null,5,4.6000000000000005,null,3,2.7600000000000002,null,5,4.6000000000000005,null,null,null,4.6000000000000005,null,null,null,null,"Built Environment Score",{"$f":"SUM(L77:L79)","v":0.57000000000000006},{"$f":"SUM(O77:O79)","v":0.49000000000000005},{"$f":"SUM(R77:R79)","v":0.42},{"$f":"W77","v":1.05}]
[null,"Urban/suburban habitat quantity gain/loss",6,0.10199999999999999,1,0.9,null,null,null,null,1,0.9,null,3,2.7,null,3,2.7,null,null,null,4.5]
[null,"Barren/rock and sand habitat quantity gain/loss",7,0.122,1,0.88,null,null,null,null,4,3.52,null,5,4.4000000000000004,null,5,4.4000000000000004,null,null,null,4.4000000000000004]
[null,"Rivers and streams habitat quality improved/harmed",8,0.14199999999999999,1,0.87,null,null,null,null,1,0.87,null,3,2.61,null,3,2.61,null,null,null,4.3499999999999996]
[null,"Lakes and ponds habitat quality improved/harmed",9,0.16300000000000001,1,0.85,null,null,null,null,1,0.85,null,1,0.85,null,1,0.85,null,null,null,4.25]
[null,"Near coastal marine/estuarine habitat quality improved/harmed",10,0.183,1,0.83,null,null,null,null,5,4.1499999999999995,null,3,2.4899999999999998,null,5,4.1499999999999995,null,null,null,4.1499999999999995]
[null,"Open water habitat quality improved/harmed",11,0.20399999999999999,1,0.81,null,null,null,null,5,4.0500000000000007,null,5,4.0500000000000007,null,5,{"$f":"$F40*Q40*(Q$25=\"OK\")","v":4.0500000000000007},null,null,null,4.0500000000000007]
[null,"Wetlands habitat quality improved/harmed",12,0.224,1,0.79,null,null,null,null,5,3.95,null,5,3.95,null,5,3.95,null,null,null,3.95]
[null,"Urban/suburban habitat quality improved/harmed",13,0.24399999999999999,1,0.77,null,null,null,null,1,0.77,null,5,3.85,null,1,0.77,null,null,null,3.85]
[null,"Barren/rock and sand habitat quality improved/harmed",14,0.26500000000000001,1,0.75,null,null,null,null,1,0.75,null,3,2.25,null,1,0.75,null,null,null,3.75]
[null,"Impact on priority habitat",15,0.28499999999999998,1,0.73,null,null,null,null,4,2.92,null,2,1.46,null,1,0.73,null,null,null,3.65]
[null,"Benefit to species of management concern",16,0.30599999999999999,1,0.71,null,null,null,null,4,2.84,null,2,1.42,null,1,0.71,null,null,null,3.55]
[null,"Restoration of native vegetation",17,0.32600000000000001,1,0.69,null,null,null,null,4,2.76,null,2,1.38,null,1,0.69,null,null,null,3.4499999999999997]
[null,"Reduction of invasive species",18,0.34599999999999997,1,0.67,null,null,null,null,4,2.68,null,2,1.34,null,1,0.67,null,null,null,3.35]
[null,"Increase stormwater control/protection",19,0.36699999999999999,1,0.65,null,null,null,null,4,2.6,null,2,1.3,null,1,0.65,null,null,null,3.25]
[null,"Influence biophysical environment by reducing contamination",20,0.38700000000000001,1,0.63,null,null,null,null,4,2.52,null,2,1.26,null,1,0.63,null,null,null,3.15]
["Economy (10)","Funding pathway identified",21,0.40799999999999997,1,0.61,{"$f":"SUM(F50:F59)","v":5.2600000000000007},{"$f":"G50/SUM(G$30:G$79)","v":0.20015220700152206},{"$f":"CONCATENATE(I$29,\" to \",J$29)","v":"1 to 5"},null,5,{"$f":"$F50*K50*(K$25=\"OK\")","v":3.05},{"$f":"SUBTOTAL(9,L50:L59)/$W50","v":0.7209125475285173},4,{"$f":"$F50*N50*(N$25=\"OK\")","v":2.44},{"$f":"SUBTOTAL(9,O50:O59)/$W50","v":0.80418250950570325},5,{"$f":"$F50*Q50*(Q$25=\"OK\")","v":3.05},{"$f":"SUBTOTAL(9,R50:R59)/$W50","v":0.70190114068441067},null,null,{"$f":"F50*J$29","v":3.05},{"$f":"SUBTOTAL(9,V50:V59)","v":26.3}]
[null,"Funding application prepared",22,0.42799999999999999,1,0.59,null,null,null,null,5,2.9499999999999997,null,3,1.77,null,5,2.9499999999999997,null,null,null,2.9499999999999997]
[null,"Partnerships established",23,0.44800000000000001,1,0.56999999999999995,null,null,null,null,5,2.8499999999999996,null,5,2.8499999999999996,null,5,2.8499999999999996,null,null,null,2.8499999999999996]
[null,"Potential partnerships identified",24,0.46899999999999997,1,0.55000000000000004,null,null,null,null,5,2.75,null,5,2.75,null,5,2.75,null,null,null,2.75]
[null,"Feasible transportation of dredged materials to placement site",25,0.48899999999999999,1,0.54,null,null,null,null,5,2.7,null,5,2.7,null,5,2.7,null,null,null,2.7]
[null,"Accept materials (5 years)",26,0.51,1,0.52,null,null,null,null,1,0.52,null,4,2.08,null,1,0.52,null,null,null,2.6]
[null,"Accept materials long-term (20 years)",27,0.53,1,0.5,null,null,null,null,1,0.5,null,5,2.5,null,1,0.5,null,null,null,2.5]
[null,"Lead to creation/growth of viable business",28,0.55100000000000005,1,0.48,null,null,null,null,2,0.96,null,1,0.48,null,1,0.48,null,null,null,2.4]
[null,"Secondary benefits created",29,0.57099999999999995,1,0.46,null,null,null,null,2,0.92,null,3,1.3800000000000001,null,1,0.46,null,null,null,2.3000000000000003]
[null,"Long-term maintenance required",30,0.59099999999999997,1,0.44,null,null,null,null,4,1.76,null,5,2.2000000000000002,null,5,2.2000000000000002,null,null,null,2.2000000000000002]
["Social (8)","Improve access to parks or natural spaces",31,0.61199999999999999,1,0.42,{"$f":"SUM(F60:F67)","v":2.8},{"$f":"G60/SUM(G$30:G$79)","v":0.10654490106544899},{"$f":"CONCATENATE(I$29,\" to \",J$29)","v":"1 to 5"},null,1,0.42,{"$f":"SUBTOTAL(9,L60:L67)/$W60","v":0.39714285714285719},1,0.42,{"$f":"SUBTOTAL(9,O60:O67)/$W60","v":0.35},1,0.42,{"$f":"SUBTOTAL(9,R60:R67)/$W60","v":0.37428571428571428},null,null,2.1,{"$f":"SUBTOTAL(9,V60:V67)","v":14}]
[null,"Potential for indirect job creation",32,0.63200000000000001,1,0.4,null,null,null,null,2,0.8,null,1,0.4,null,1,0.4,null,null,null,2]
[null,"Improve aesthetics",33,{"$f":"_xlfn.PERCENTRANK.INC(C$30:C$79,C62,3)","v":0.65300000000000002},1,{"$f":"ROUND((1-((1-F$29)/(MAX($D$30:$D$79)-MIN($D$30:$D$79))*D62))*E62,2)","v":0.38},null,null,null,null,3,1.1400000000000001,null,4,1.52,null,3,1.1400000000000001,null,null,null,1.9]
[null,"Community engagement",34,0.67300000000000004,1,0.36,null,null,null,null,2,0.72,null,1,0.36,null,3,1.08,null,null,null,1.7999999999999998]
[null,"Reduced human exposure to contaminants",35,0.69299999999999995,1,0.34,null,null,null,null,1,0.34,null,1,0.34,null,1,0.34,null,null,null,1.7000000000000002]
[null,"Improved access to ecosystem services",36,0.71399999999999997,1,0.32,null,null,null,null,4,1.28,null,4,1.28,null,4,1.28,null,null,null,1.6]
[null,"Improved infrastructure condition",37,0.73399999999999999,1,0.3,null,null,null,null,1,0.3,null,1,0.3,null,1,0.3,null,null,null,1.5]
[null,"New/improved infrastructure services for community",38,0.755,1,0.28000000000000003,null,null,null,null,2,0.56000000000000005,null,1,0.28000000000000003,null,1,0.28000000000000003,null,null,null,1.4000000000000001]
["Governance (9)","Maintain navigation channels ",39,0.77500000000000002,1,0.26,{"$f":"SUM(F68:F76)","v":1.68},{"$f":"G68/SUM(G$30:G$79)","v":6.3926940639269389E-2},"1 to 5",null,5,1.3,{"$f":"SUBTOTAL(9,L68:L76)/W68","v":0.86785714285714266},5,1.3,{"$f":"SUBTOTAL(9,O68:O76)/$W68","v":0.7309523809523808},5,1.3,{"$f":"SUBTOTAL(9,R68:R76)/$W68","v":0.72023809523809501},null,null,1.3,{"$f":"SUBTOTAL(9,V68:V76)","v":8.4000000000000021}]
[null,"Enrollment in voluntary program",40,0.79500000000000004,1,0.24,null,null,null,null,1,0.24,null,1,0.24,null,1,0.24,null,null,null,1.2]
[null,"Able to complete within environmental windows",41,0.81599999999999995,1,0.22,null,null,null,null,5,1.1000000000000001,null,3,0.66,null,4,0.88,null,null,null,1.1000000000000001]
[null,"Included in existing guidance documents",42,0.83599999999999997,1,0.21,null,null,null,null,5,1.05,null,5,1.05,null,5,1.05,null,null,null,1.05]
[null,"Permitting timeline conducive with project timeline",43,0.85699999999999998,1,0.19,null,null,null,null,5,0.95,null,5,0.95,null,4,0.76,null,null,null,0.95]
[null,"Meets zoning requirements",44,0.877,1,0.17,null,null,null,null,5,0.85000000000000009,null,3,0.51,null,1,0.17,null,null,null,0.85000000000000009]
[null,"Flexible timeframe",45,0.89700000000000002,1,0.15,null,null,null,null,4,0.6,null,3,0.44999999999999996,null,3,0.44999999999999996,null,null,null,0.75]
[null,"Replicable",46,0.91800000000000004,1,0.13,null,null,null,null,5,0.65,null,5,0.65,null,5,0.65,null,null,null,0.65]
[null,"Site ownership",47,0.93799999999999994,1,0.11,null,null,null,null,5,0.55000000000000004,null,3,0.33,null,5,0.55000000000000004,null,null,null,0.55000000000000004]
["Built Environment (3)","Reduce contamination",48,0.95899999999999996,1,0.09,{"$f":"SUM(F77:F79)","v":0.21000000000000002},{"$f":"G77/SUM(G30:G79)","v":7.9908675799086754E-3},"1 to 5",null,1,0.09,{"$f":"SUBTOTAL(9,L77:L79)/$W77","v":0.54285714285714293},1,0.09,{"$f":"SUBTOTAL(9,O77:O79)/$W77","v":0.46666666666666667},1,0.09,{"$f":"SUBTOTAL(9,R77:R79)/$W77","v":0.39999999999999997},null,null,0.44999999999999996,{"$f":"SUBTOTAL(9,V77:V79)","v":1.05}]
[null,"Diversion to construction",49,0.97899999999999998,1,7.0000000000000007E-2,null,null,null,null,4,0.28000000000000003,null,5,0.35000000000000003,null,4,0.28000000000000003,null,null,null,0.35000000000000003]
[null,"Provide fill or cap (development sites, roads, greenspace)",50,1,1,0.05,null,null,null,null,4,0.2,null,1,0.05,null,1,0.05,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,"Total Score"]
["Total Score",null,null,null,null,null,null,{"$f":"SUM(H30,H50,H60,H68,H77)","v":0.99999999999999989},null,null,{"$f":"SUM(L30:L79)","v":79.929999999999993},null,null,{"$f":"SUM(O30:O79)","v":83.470000000000013},null,null,{"$f":"SUM(R30:R79)","v":75.760000000000019},null,null,null,null,null,{"$f":"SUBTOTAL(9,V30:V79)","v":131.4},{"$f":"W30+W50+W60+W68+W77","v":131.4},"Check"]
[null,null,null,null,null,null,null,{"$f":"IF(H81=1,\"OK\",\"Error\")","v":"OK"},null,null,{"$f":"CONCATENATE(\"of \",$W81)","v":"of 131.4"},null,null,{"$f":"CONCATENATE(\"of \",$W81)","v":"of 131.4"},null,null,{"$f":"CONCATENATE(\"of \",$W81)","v":"of 131.4"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K81/$W81","v":0.60829528158295276},null,null,{"$f":"N81/$W81","v":0.63523592085235925},null,null,{"$f":"Q81/$W81","v":0.57656012176560134}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"RANK(K81,$K81:$Q81,0)","v":2},null,null,{"$f":"RANK(N81,$K81:$Q81,0)","v":1},null,null,{"$f":"RANK(Q81,$K81:$Q81,0)","v":3}]
[]
["Notes:"]
[]
["U","Unweighted score"]
["W","Weighted score"]
["C","Combined score"]
[]
["1. Weighting factor is a number greater than 0 through 1 based on perceived importance"]
["2. W = U x WF"]
["3. C = Sum (W) /Max possible Sum(W)"]
[]
[]
["Alternative 1","Describe alternative"]
["Alternative 2","Describe alternative"]
["Alternative 3","Describe alternative"]

{"sheet":"ScoresheetB","index":3,"n_rows":99,"n_cols":31,"rows_kept":99,"cut":false,"hidden":false,"merged":[[67,0,75,0],[76,0,78,0],[59,0,66,0],[21,10,21,12],[21,13,21,15],[27,0,28,0],[27,1,28,1],[27,3,28,3],[27,5,28,5],[27,7,28,7],[27,2,28,2],[29,7,48,7],[29,8,48,8],[29,0,48,0],[49,7,56,7],[49,8,56,8],[21,16,21,18],[22,10,22,12],[22,13,22,15],[22,16,22,18],[27,8,28,8],[25,10,25,12],[25,13,25,15],[25,16,25,18],[23,10,23,12],[23,13,23,15],[23,16,23,18],[24,10,24,12],[24,13,24,15],[24,16,24,18],[79,10,79,16],[26,10,26,12],[26,13,26,15],[26,16,26,18],[27,9,28,9],[29,9,48,9],[76,18,78,18],[29,12,48,12],[29,15,48,15],[29,18,48,18],[49,18,58,18],[59,18,66,18],[67,18,75,18],[76,12,78,12],[2,0,2,18],[19,10,19,18],[20,10,20,12],[20,13,20,15],[20,16,20,18],[9,10,13,18],[5,10,5,12],[28,21,28,22],[27,10,28,10],[27,11,28,11],[27,12,28,12],[27,13,28,13],[27,14,28,14],[27,15,28,15],[27,16,28,16],[27,17,28,17],[27,18,28,18],[49,0,58,0],[49,9,58,9],[76,15,78,15],[64,7,65,7],[64,8,65,8],[59,7,63,7],[59,8,63,8],[59,9,66,9],[67,9,75,9],[76,9,78,9],[49,12,58,12],[49,15,58,15],[59,12,66,12],[59,15,66,15],[67,12,75,12],[67,15,75,15]]}
["Duluth-Superior Harbor Working Draft"]
["2020-12-11"]
["MAINTENANCE DREDGING SCORECARD B (Version 1.0, July 2019)"]
[]
["Port","Duluth-Superior Harbor"]
["Project No.","ABC-123",null,null,null,null,null,null,null,null,"Cell Color",null,null,"indicates user input"]
["Dredge Location (lat/long)","41.5, -81.77",null,null,null,null,null,null,null,null,"Font color",null,1,"indicates user input"]
["Volume (cy)",{"$f":"CONCATENATE(K21,\": \",K23/1000,\"K; \",N21,\": \",N23/1000,\"K; \",Q21,\": \",Q23/1000,\"K\")","v":"Alternative 1: 50K; Alternative 2: 50K; Alternative 3: 50K"},null,null,null,null,null,null,null,null,null,null,null,"scoring color scale"]
["Soil classification","SM, SC"]
["Elevated contaminants","PAHs, metals",null,null,null,null,null,null,null,null,"Scorecard B presents the concept for qualitative scoring of alternatives.  The user inputs an \"x\" to respond \"yes\" to each benchmark question. The tool assumes x = 1 and blank = 0, calculates the combined score for each alternative, and assigns ranks."]
["Weighting factor adjusted",{"$f":"IF(COUNTIF(E30:E66,\">1\"),CONCATENATE(COUNTIF(E30:E66,\">1\"),\" factor(s) adjusted; maximum adjustment = \",MAX(E30:E66),\"X\"),\"No adjustment\")","v":"No adjustment"}]
["Trial","001"]
["Scorecard No.",{"$f":"CONCATENATE(LEFT(B5,2),\"-\",YEAR(B18),\"-\",MONTH(B18),\"-\",DAY(B18),\"-\",B12)","v":"Du-2019-7-23-001"}]
["Prepared by","<Enter Name>"]
["Prepared on","<Enter Date>"]
["Checked by","<Enter Name>",null,null,null,null,null,null,null,null,null,"Click on this button for instructions to use this tool"]
["Checked on","<Enter Date>"]
["Last Modified","2019-07-23"]
[]
[null,null,null,null,null,null,null,null,null,null,"Scoring"]
[null,null,null,null,null,null,null,null,null,null,"Alternative 1",null,null,"Alternative 2",null,null,"Alternative 3"]
[null,null,null,null,null,null,null,null,null,null,"CDF Disposal",null,null,"Beneficial Use: Recycler",null,null,"Beneficial Use: Land Reclamation"]
[null,null,null,null,null,null,null,null,null,"Sediment dredged",50000,null,null,50000,null,null,50000]
[null,null,null,null,null,null,"Disposal capacity available on","2019-07-19",null,"2019-07-19",5000000,null,null,1000000,null,null,100000,null,null,{"$f":"IF((TODAY()-J24)>183,\"Caution, data more than 6 months old\",\"\")","v":"Caution, data more than 6 months old"}]
[null,null,null,null,null,null,null,null,null,"Is sediment dredged ≤ available disposal capacity",{"$f":"IF(K23>K24,\"Reduce Volume\",\"OK\")","v":"OK"},null,null,{"$f":"IF(N23>N24,\"Reduce Volume\",\"OK\")","v":"OK"},null,null,{"$f":"IF(Q23>Q24,\"Reduce Volume\",\"OK\")","v":"OK"}]
[]
[]
["EES Category","Criterion","Sub-criterion or Metric","C Rank","Per-centile","Adjust WF","Weighting Factor (WF)","WF Sum","WF Share","Scoring Scale","U","W","C","U","W","C","U","W","C",null,null,null,null,null,null,null,"Graph Controls"]
[null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,"W","C",null,"W","C",null,null,"Denominator",null,null,null,null,"Category","Alternative 1","Alternative 2","Alternative 3","Maximum Potential Score"]
["Biophysical Environment (20)","Rivers and streams habitat gain/loss","Will the reuse alternative create river and stream habitat type?",1,{"$f":"_xlfn.PERCENTRANK.INC(D$30:D$79,D30,3)","v":0},1,{"$f":"ROUND((1-((1-G$29)/(MAX($E$30:$E$79)-MIN($E$30:$E$79))*E30))*F30,2)","v":1},{"$f":"SUM(G30:G49)","v":16.330000000000002},{"$f":"H30/SUM(H$30:H$66)","v":0.70357604480827241},"x = yes\nblank = no","x",{"$f":"$G30*(K30=\"x\")*(K$25=\"OK\")","v":1},{"$f":"SUBTOTAL(9,L30:L49)/$W30","v":0.35088793631353332},"x",{"$f":"$G30*(N30=\"x\")*(N$25=\"OK\")","v":1},{"$f":"SUBTOTAL(9,O30:O49)/$W30","v":0.11083894672382118},null,{"$f":"$G30*(Q30=\"x\")*(Q$25=\"OK\")","v":0},{"$f":"SUBTOTAL(9,R30:R49)/$W30","v":4.7152480097979177E-2},null,null,{"$f":"G30*1","v":1},{"$f":"SUBTOTAL(9,V30:V49)","v":16.330000000000002},null,null,null,"Biophysical Score",{"$f":"SUM(L30:L49)","v":5.7299999999999995},{"$f":"SUM(O30:O49)","v":1.81},{"$f":"SUM(R30:R49)","v":0.77},{"$f":"W30","v":16.330000000000002}]
[null,"Lakes and ponds habitat gain/loss","Will the reuse alternative create lake and pond habitat type?",2,0.02,1,0.98,null,null,null,"x",{"$f":"$G31*(K31=\"x\")*(K$25=\"OK\")","v":0.98},null,null,0,null,null,0,null,null,null,{"$f":"G31*1","v":0.98},null,null,null,null,"Economy Score",{"$f":"SUM(L50:L59)","v":5.2600000000000007},{"$f":"SUM(O50:O59)","v":0.61},{"$f":"SUM(R50:R59)","v":1.67},{"$f":"W50","v":5.2600000000000007}]
[null,"Near coastal marine/estuarine habitat gain/loss","Will the reuse alternative create near coastal marine/estuarine habitat type?",3,0.04,1,0.96,null,null,null,null,{"$f":"$G32*(K32=\"x\")*(K$25=\"OK\")","v":0},null,null,0,null,null,0,null,null,null,{"$f":"G32*1","v":0.96},null,null,null,null,"Social Score",{"$f":"SUM(L60:L67)","v":2.8},{"$f":"SUM(O60:O67)","v":0.9},{"$f":"SUM(R60:R67)","v":1.4800000000000002},{"$f":"W60","v":2.8}]
[null,"Open water habitat gain/loss","Will the reuse alternative create open water habitat type?",4,6.0999999999999999E-2,1,0.94,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.94,null,null,null,null,"Governance Score",{"$f":"SUM(L68:L76)","v":1.68},{"$f":"SUM(O68:O76)","v":0.97},{"$f":"SUM(R68:R76)","v":0.83000000000000007},{"$f":"W68","v":1.68}]
[null,"Wetlands habitat gain/loss","Will the reuse alternative create wetland habitat type?",5,8.1000000000000003E-2,1,0.92,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.92,null,null,null,null,"Built Environment Score",{"$f":"SUM(L77:L79)","v":0.21000000000000002},{"$f":"SUM(O77:O79)","v":0},{"$f":"SUM(R77:R79)","v":0},{"$f":"W77","v":0.21000000000000002}]
[null,"Urban/suburban habitat gain/loss","Will the reuse alternative create urban/suburban habitat type?",6,0.10199999999999999,1,0.9,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.9]
[null,"Barren/rock and sand habitat gain/loss","Will the reuse alternative create barren/rock and sand habitat type?",7,0.122,1,0.88,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.88]
[null,"Rivers and streams habitat improved/harmed","Will the reuse alternative imrpove river and stream habitat quality?",8,0.14199999999999999,1,0.87,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.87]
[null,"Lakes and ponds habitat improved/harmed","Will the reuse alternative improve lake and pond habitat quality?",9,0.16300000000000001,1,0.85,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.85]
[null,"Near coastal marine/estuarine habitat improved/harmed","Will the reuse alternative improve near coastal marine/estuarine habitat quality?",10,0.183,1,0.83,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.83]
[null,"Open water habitat improved/harmed","Will the reuse alternative improve open water habitat quality?",11,0.20399999999999999,1,0.81,null,null,null,"x",0.81,null,"x",{"$f":"$G40*(N40=\"x\")*(N$25=\"OK\")","v":0.81},null,null,{"$f":"$G40*(Q40=\"x\")*(Q$25=\"OK\")","v":0},null,null,null,0.81]
[null,"Wetlands habitat improved/harmed","Will the reuse alternative improve wetlands habitat quality?",12,0.224,1,0.79,null,null,null,"x",0.79,null,null,0,null,null,0,null,null,null,0.79]
[null,"Urban/suburban habitat improved/harmed","Will the reuse alternative improve urban/suburban habitat quality?",13,0.24399999999999999,1,0.77,null,null,null,"x",0.77,null,null,0,null,"x",0.77,null,null,null,0.77]
[null,"Barren/rock and sand habitat improved/harmed","Will the reuse alternative improve barren/rock and sand habitat quality?",14,0.26500000000000001,1,0.75,null,null,null,"x",0.75,null,null,0,null,null,0,null,null,null,0.75]
[null,"Impact on priority habitat","Will the reuse alternative benefit priority habitat?",15,0.28499999999999998,1,0.73,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.73]
[null,"Benefit to species of management concern","Will the reuse alternative benefit species of management concern?",16,0.30599999999999999,1,0.71,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0.71]
[null,"Restoration of native vegetation","Will the reuse alternative restore native vegetation?",17,0.32600000000000001,1,0.69,null,null,null,null,{"$f":"$G46*(K46=\"x\")*(K$25=\"OK\")","v":0},null,null,0,null,null,0,null,null,null,0.69]
[null,"Reduction of invasive species","Will the reuse alternative reduce invasive species?",18,0.34599999999999997,1,0.67,null,null,null,null,{"$f":"$G47*(K47=\"x\")*(K$25=\"OK\")","v":0},null,null,0,null,null,0,null,null,null,0.67]
[null,"Increase stormwater control/protection","Will the reuse alternative increase stormwater control or protection?",19,0.36699999999999999,1,0.65,null,null,null,null,{"$f":"$G48*(K48=\"x\")*(K$25=\"OK\")","v":0},null,null,0,null,null,0,null,null,null,0.65]
[null,"Influence biophysical environment by reducing contamination","Will the reuse alternative reduce contamination in the biophysical environment?",20,0.38700000000000001,1,0.63,null,null,null,"x",0.63,null,null,0,null,null,0,null,null,null,0.63]
["Economy (10)","Funding pathway","Is a funding pathway prepared for the reuse alternative?",21,0.40799999999999997,1,0.61,{"$f":"SUM(G50:G57)","v":4.3600000000000003},{"$f":"H50/SUM(H$30:H$66)","v":0.18785006462731582},"x = yes\nblank = no","x",0.61,{"$f":"SUBTOTAL(9,L50:L59)/$W50","v":1},"x",0.61,{"$f":"SUBTOTAL(9,O50:O57)/$W50","v":0.11596958174904941},"x",0.61,{"$f":"SUBTOTAL(9,R50:R57)/$W50","v":0.31749049429657789},null,null,0.61,{"$f":"SUBTOTAL(9,V50:V59)","v":5.2600000000000007}]
[null,"Application information prepared","Is funding application information prepared?",22,0.42799999999999999,1,0.59,null,null,null,"x",0.59,null,null,0,null,null,0,null,null,null,0.59]
[null,"Established partnerships","Are all parties responsible for permits and planning in coordination regarding the reuse alternative?",23,0.44800000000000001,1,0.56999999999999995,null,null,null,"x",0.56999999999999995,null,null,0,null,null,0,null,null,null,0.56999999999999995]
[null,"Working partnerships","Have potential project partnerships been identified?",24,0.46899999999999997,1,0.55000000000000004,null,null,null,"x",0.55000000000000004,null,null,0,null,null,0,null,null,null,0.55000000000000004]
[null,"Transport cost","Is transportation to the alternative reuse site feasible?",25,0.48899999999999999,1,0.54,null,null,null,"x",0.54,null,null,0,null,"x",0.54,null,null,null,0.54]
[null,"Accept materials (5 years)","Will the placement site accept/use materials for 5 years?",26,0.51,1,0.52,null,null,null,"x",0.52,null,null,0,null,"x",0.52,null,null,null,0.52]
[null,"Accept materials long-term (20 years)","Will the placement site accept/use materials for 20 years?",27,0.53,1,0.5,null,null,null,"x",0.5,null,null,0,null,null,0,null,null,null,0.5]
[null,"Profitable to reuse","Does the reuse alternative lead to the creation or growth of viable business?",28,0.55100000000000005,1,0.48,null,null,null,"x",0.48,null,null,0,null,null,0,null,null,null,0.48]
[null,"Secondary benefits","Does the reuse alternative produce secondary economic benefits?",29,0.57099999999999995,1,0.46,null,null,null,"x",0.46,null,null,0,null,null,0,null,null,null,0.46]
[null,"Long-term maintenance","Will the reuse alternative require long-term maintenance or management?",30,0.59099999999999997,1,0.44,null,null,null,"x",0.44,null,null,0,null,null,0,null,null,null,0.44]
["Social (8)","Improve park access","Does the reuse alternative create or improve public park space in an economically depressed or minority community?",31,0.61199999999999999,1,0.42,{"$f":"SUM(G60:G64)","v":1.9000000000000001},{"$f":"H60/SUM(H$30:H$66)","v":8.1861266695389914E-2},"x = yes\nblank = no","x",0.42,{"$f":"SUBTOTAL(9,L60:L67)/$W60","v":1},null,0,{"$f":"SUBTOTAL(9,O60:O67)/$W60","v":0.32142857142857145},null,0,{"$f":"SUBTOTAL(9,R60:R67)/$W60","v":0.52857142857142869},null,null,0.42,{"$f":"SUBTOTAL(9,V60:V67)","v":2.8}]
[null,"Provide jobs","Does the reuse alternative have potential for indirect job creation?",32,0.63200000000000001,1,0.4,null,null,null,"x",0.4,null,null,0,null,"x",0.4,null,null,null,0.4]
[null,"Improve aesthetics","Does the reuse alternative reduce blight or improve aesthetics in an economically depressed or minority community?",33,0.65300000000000002,1,0.38,null,null,null,"x",0.38,null,null,0,null,"x",0.38,null,null,null,0.38]
[null,"Community engagement","Is the local community involved in providing feedback on needs, planning, and process of the reuse alternative?",34,0.67300000000000004,1,0.36,null,null,null,"x",0.36,null,null,0,null,"x",0.36,null,null,null,0.36]
[null,"Reduce exposure","Does the reuse alternative reduce human exposure to contaminants?",35,0.69299999999999995,1,0.34,null,null,null,"x",0.34,null,null,0,null,"x",0.34,null,null,null,0.34]
[null,"Access to ecosystem services","Does the reuse alternative improve ecosystem services provision to the public?",36,0.71399999999999997,1,0.32,{"$f":"SUM(G65:G66)","v":0.62},{"$f":"H65/SUM(H$30:H$66)","v":2.6712623869021974E-2},null,"x",0.32,null,"x",0.32,null,null,0,null,null,null,0.32]
[null,"Infrastructure condition","Does the reuse alternative improve condition of infrastructure?",37,0.73399999999999999,1,0.3,null,null,null,"x",0.3,null,"x",0.3,null,null,0,null,null,null,0.3]
[null,"Infrastructure benefit community","Does the reuse alternative offer new or improve existing infrastructure service to a community?",38,0.755,1,0.28000000000000003,null,null,null,"x",0.28000000000000003,null,"x",{"$f":"$G67*(N67=\"x\")*(N$25=\"OK\")","v":0.28000000000000003},null,null,0,null,null,null,0.28000000000000003]
["Governance (9)","Maintain navigation channels ","Does the reuse alternative maintain or increase draft shipping?",39,0.77500000000000002,1,0.26,null,null,"x = yes\nblank = no","x",0.26,{"$f":"SUBTOTAL(9,L68:L76)/W68","v":1},"x",0.26,{"$f":"SUBTOTAL(9,O68:O76)/W68","v":0.57738095238095244},null,0,{"$f":"SUBTOTAL(9,R68:R76)/W68","v":0.49404761904761912},null,null,0.26,{"$f":"SUBTOTAL(9,V68:V76)","v":1.68}]
[null,"Voluntary program ","Is the reuse alternative enrolled in a voluntary program?",40,0.79500000000000004,1,0.24,null,null,null,"x",0.24,null,"x",0.24,null,null,0,null,null,null,0.24]
[null,"Environmental windows","Will the dredging and placement be completed within the relevant environmental windows?",41,0.81599999999999995,1,0.22,null,null,null,"x",0.22,null,null,0,null,null,0,null,null,null,0.22]
[null,"AOC or other guidance","Is the reuse alternative referred to or included in existing guidance documents?",42,0.83599999999999997,1,0.21,null,null,null,"x",0.21,null,null,0,null,"x",0.21,null,null,null,0.21]
[null,"Permit requirements","Is the timeline for permitting conducive to the project timeline?",43,0.85699999999999998,1,0.19,null,null,null,"x",0.19,null,"x",0.19,null,"x",0.19,null,null,null,0.19]
[null,"Zoning requirements","Does the reuse alternative meet zoning requirements?",44,0.877,1,0.17,null,null,null,"x",0.17,null,"x",0.17,null,"x",0.17,null,null,null,0.17]
[null,"Contingency plan","Has a contingency plan been established for the reuse alternative?",45,0.89700000000000002,1,0.15,null,null,null,"x",0.15,null,null,0,null,"x",0.15,null,null,null,0.15]
[null,"Replicability","Is the reuse alternative replicable in other projects, harbors, ports, environments, and jurisdictions?",46,0.91800000000000004,1,0.13,null,null,null,"x",0.13,null,null,0,null,null,0,null,null,null,0.13]
[null,"Site ownership","Have the owner(s) of the potential project site been identified?",47,0.93799999999999994,1,0.11,null,null,null,"x",0.11,null,"x",0.11,null,"x",0.11,null,null,null,0.11]
["Built Environment (3)","Reduce contamination","Does the reuse alternative meet requirements specifically pertaining to reducing contaminants to required levels for end use?",48,0.95899999999999996,1,0.09,null,null,"x = yes\nblank = no","x",0.09,{"$f":"SUBTOTAL(9,L77:L79)/$W77","v":1},null,0,{"$f":"SUBTOTAL(9,O77:O79)/$W77","v":0},null,0,{"$f":"SUBTOTAL(9,R77:R79)/$W77","v":0},null,null,0.09,{"$f":"SUBTOTAL(9,V77:V79)","v":0.21000000000000002}]
[null,"Diversion to construction","Does the reuse alternative reduce demand on terestrial borrow sources?",49,0.97899999999999998,1,7.0000000000000007E-2,null,null,null,"x",7.0000000000000007E-2,null,null,0,null,null,0,null,null,null,7.0000000000000007E-2]
[null,"Provide fill or cap","Does the reuse alternative involve using dredged material as a fill and/or cap for the selected intended use?",50,1,1,0.05,null,null,null,"x",0.05,null,null,0,null,null,0,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,null,"Total Score"]
["Total Score",null,null,null,null,null,null,null,{"$f":"SUM(I30,I50,I60,I65)","v":1.0000000000000002},null,{"$f":"SUM(L30:L79)","v":15.680000000000003},null,null,{"$f":"SUM(O30:O79)","v":4.29},null,null,{"$f":"SUM(R30:R79)","v":4.7500000000000009},null,null,null,null,null,{"$f":"SUBTOTAL(9,V30:V79)","v":26.280000000000005},{"$f":"W30+W50+W60+W68+W77","v":26.280000000000005},"Check"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I81=1,\"OK\",\"Error\")","v":"OK"},null,{"$f":"CONCATENATE(\"of \",$W81)","v":"of 26.28"},null,null,{"$f":"CONCATENATE(\"of \",$W81)","v":"of 26.28"},null,null,{"$f":"CONCATENATE(\"of \",$W81)","v":"of 26.28"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K81/$W81","v":0.59665144596651443},null,null,{"$f":"N81/$W81","v":0.16324200913242007},null,null,{"$f":"Q81/$W81","v":0.18074581430745815}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"RANK(K81,$K81:$Q81,0)","v":1},null,null,{"$f":"RANK(N81,$K81:$Q81,0)","v":3},null,null,{"$f":"RANK(Q81,$K81:$Q81,0)","v":2}]
[]
["Notes:"]
[]
["U","Unweighted score"]
["W","Weighted score"]
["C","Combined score"]
[]
["1. Weighting factor is a number greater than 0 through 1 based on perceived importance"]
["2. W = U x WF"]
["3. C = Sum (W) /Max possible Sum(W)"]
[]
[]
["Alternative 1","Describe alternative"]
["Alternative 2","Describe alternative"]
["Alternative 3","Describe alternative"]

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

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

{"sheet":"Soil Data","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["This worksheet can be used to summarize soil data"]