{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data Input","Feasibility Output","Data Reference"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Data Input","index":0,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[75,0,75,5],[44,0,45,5],[48,0,48,5],[58,0,58,5],[2,0,2,5],[12,0,12,5],[24,0,24,5],[31,0,31,5],[68,0,68,5]]}
["Metric","Site 1","Site 2","Site 3","Site 4","Site 5"]
[]
["PHYSICAL CHARACTERISTICS"]
[{"$f":"'Data Reference'!$B$2","v":"Water Body Energy"}]
[{"$f":"'Data Reference'!$B$8","v":"Positional Energy"}]
[{"$f":"'Data Reference'!$B$13","v":"Storm Event Energy"}]
[{"$f":"'Data Reference'!B22","v":"Persistent Wave Energy"}]
[{"$f":"'Data Reference'!$B$30","v":"Boat Wake Energy"}]
[{"$f":"'Data Reference'!$B$35","v":"Nearshore Slope (Stevens guide)"}]
[{"$f":"'Data Reference'!$B$40","v":"On-site Shoreline Condition"}]
[{"$f":"'Data Reference'!$B$47","v":"Surrounding Shoreline Condition"}]
["Physical Score",{"$f":"B58","v":{"$error":"#N/A"}},{"$f":"C58","v":{"$error":"#N/A"}},{"$f":"D58","v":{"$error":"#N/A"}},{"$f":"E58","v":{"$error":"#N/A"}},{"$f":"F58","v":{"$error":"#N/A"}}]
["BIOLOGICAL CHARACTERISTICS"]
[{"$f":"'Data Reference'!B54","v":"Percent Canopy Shading"}]
[{"$f":"'Data Reference'!B60","v":"Intertidal Vegetation Community Status"}]
[{"$f":"'Data Reference'!B67","v":"Intertidal Vegetation Substrate"}]
[{"$f":"'Data Reference'!B74","v":"Subtidal Vegetation Community Status"}]
[{"$f":"'Data Reference'!B81","v":"Subtidal Vegetation Substrate"}]
[{"$f":"'Data Reference'!B88","v":"Upland Vegetation Community Status"}]
[{"$f":"'Data Reference'!B95","v":"Upland Vegetation Substrate"}]
[{"$f":"'Data Reference'!B102","v":"Shellfish Community"}]
["Ecological Score",{"$f":"B68","v":{"$error":"#N/A"}},{"$f":"C68","v":{"$error":"#N/A"}},{"$f":"D68","v":{"$error":"#N/A"}},{"$f":"E68","v":{"$error":"#N/A"}},{"$f":"F68","v":{"$error":"#N/A"}}]
["Physical + Biological Score",{"$f":"SUM(B12,B22)","v":{"$error":"#N/A"}},{"$f":"SUM(C12,C22)","v":{"$error":"#N/A"}},{"$f":"SUM(D12,D22)","v":{"$error":"#N/A"}},{"$f":"SUM(E12,E22)","v":{"$error":"#N/A"}},{"$f":"SUM(F12,F22)","v":{"$error":"#N/A"}}]
[]
[{"$f":"'Data Reference'!B109","v":"SITE ACCESS"}]
[{"$f":"'Data Reference'!B110","v":"Material Delivery"}]
[{"$f":"'Data Reference'!B115","v":"Landowner Agreement"}]
[{"$f":"'Data Reference'!B120","v":"Personnel Access"}]
[{"$f":"'Data Reference'!B125","v":"Working Window"}]
[{"$f":"'Data Reference'!B130","v":"Regulatory Considerations"}]
["Site Access Score",{"$f":"B75","v":{"$error":"#N/A"}},{"$f":"C75","v":{"$error":"#N/A"}},{"$f":"D75","v":{"$error":"#N/A"}},{"$f":"E75","v":{"$error":"#N/A"}},{"$f":"F75","v":{"$error":"#N/A"}}]
[{"$f":"'Data Reference'!B135","v":"COMMUNITY RESOURCES"}]
[{"$f":"'Data Reference'!B136","v":"Public Outreach/Education Potential"}]
[{"$f":"'Data Reference'!B141","v":"Community Stewardship"}]
[{"$f":"'Data Reference'!B146","v":"Resource/Capital Availability"}]
[{"$f":"'Data Reference'!B151","v":"Enthusiasm for Nature Based Infrastructure"}]
[{"$f":"'Data Reference'!B156","v":"Community Protection "}]
[{"$f":"'Data Reference'!B160","v":"Environmental Justice Leverage Potential"}]
["Community Resources Score",{"$f":"B83","v":{"$error":"#N/A"}},{"$f":"C83","v":{"$error":"#N/A"}},{"$f":"D83","v":{"$error":"#N/A"}},{"$f":"E83","v":{"$error":"#N/A"}},{"$f":"F83","v":{"$error":"#N/A"}}]
["MC&C and CS Score",{"$f":"SUM(B31,B39)","v":{"$error":"#N/A"}},{"$f":"SUM(C31,C39)","v":{"$error":"#N/A"}},{"$f":"SUM(D31,D39)","v":{"$error":"#N/A"}},{"$f":"SUM(E31,E39)","v":{"$error":"#N/A"}},{"$f":"SUM(F31,F39)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
["Metric Scoring Reference"]
[]
["Metric",{"$f":"B1","v":"Site 1"},{"$f":"C1","v":"Site 2"},{"$f":"D1","v":"Site 3"},"Site 4","Site 5"]
[]
[{"$f":"A3","v":"PHYSICAL CHARACTERISTICS"}]
[{"$f":"A4","v":"Water Body Energy"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B4,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C4,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D4,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E4,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F4,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
[{"$f":"A5","v":"Positional Energy"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B5,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C5,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D5,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E5,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F5,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
[{"$f":"'Data Reference'!B13","v":"Storm Event Energy"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B6,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C6,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D6,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E6,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F6,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
[{"$f":"A7","v":"Persistent Wave Energy"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B7,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C7,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D7,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E7,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F7,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Boat Wake Energy",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B8,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C8,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D8,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E8,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F8,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Nearshore Slope (Stevens guide)",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B9,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C9,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D9,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E9,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F9,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["On-site Shoreline Condition",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B10,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C10,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D10,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E10,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F10,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Surrounding Shoreline Condition",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B11,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C11,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D11,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E11,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F11,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Physical Score",{"$f":"SUM(B50:B57)","v":{"$error":"#N/A"}},{"$f":"SUM(C50:C57)","v":{"$error":"#N/A"}},{"$f":"SUM(D50:D57)","v":{"$error":"#N/A"}},{"$f":"SUM(E50:E57)","v":{"$error":"#N/A"}},{"$f":"SUM(F50:F57)","v":{"$error":"#N/A"}}]
["BIOLOGICAL CHARACTERISTICS"]
["Percent Canopy Shading",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B14,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C14,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D14,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E14,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F14,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Intertidal Vegetation Community Status",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B15,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C15,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D15,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E15,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F15,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Intertidal Vegetation Substrate",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B16,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C16,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D16,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E16,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F16,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Subtidal Vegetation Community Status",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B17,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C17,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D17,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E17,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F17,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Subtidal Vegetation Substrate",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B18,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C18,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D18,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E18,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F18,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Upland Vegetation Community Status",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B19,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C19,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D19,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E19,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F19,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Upland Vegetation Substrate",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B20,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C20,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D20,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E20,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F20,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Shellfish Community",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B21,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C21,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D21,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E21,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F21,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
[{"$f":"A22","v":"Ecological Score"},{"$f":"SUM(B60:B67)","v":{"$error":"#N/A"}},{"$f":"SUM(C60:C67)","v":{"$error":"#N/A"}},{"$f":"SUM(D60:D67)","v":{"$error":"#N/A"}},{"$f":"SUM(E60:E67)","v":{"$error":"#N/A"}},{"$f":"SUM(F60:F67)","v":{"$error":"#N/A"}}]
[{"$f":"A25","v":"SITE ACCESS"}]
[{"$f":"A26","v":"Material Delivery"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B26,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C26,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D26,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E26,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F26,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
[{"$f":"A27","v":"Landowner Agreement"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B27,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C27,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D27,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E27,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F27,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
[{"$f":"A28","v":"Personnel Access"},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B28,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C28,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D28,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E28,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F28,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Working Window",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B29,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C29,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D29,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E29,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F29,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Regulatory Considerations",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B30,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C30,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D30,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E30,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F30,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Site Access Score",{"$f":"SUM(B70:B74)","v":{"$error":"#N/A"}},{"$f":"SUM(C70:C74)","v":{"$error":"#N/A"}},{"$f":"SUM(D70:D74)","v":{"$error":"#N/A"}},{"$f":"SUM(E70:E74)","v":{"$error":"#N/A"}},{"$f":"SUM(F70:F74)","v":{"$error":"#N/A"}}]
["COMMUNITY RESOURCES"]
["Public Outreach/Education Potential",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B33,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C33,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D33,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E33,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F33,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Community Stewardship",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B34,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C34,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D34,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E34,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F34,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Resource/Capital Availability",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B35,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C35,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D35,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E35,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F35,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Enthusiasm for Nature Based Infrastructure",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B36,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C36,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D36,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E36,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F36,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Community Protection ",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B37,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C37,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D37,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E37,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F37,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Environmental Justice Leverage Potential",{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(B38,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(C38,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(D38,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(E38,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX('Data Reference'!$B$1:$C$163,MATCH(F38,'Data Reference'!$B$1:$B$163,0),2)","v":{"$error":"#N/A"}}]
["Community Resources Score",{"$f":"SUM(B77:B82)","v":{"$error":"#N/A"}},{"$f":"SUM(C77:C82)","v":{"$error":"#N/A"}},{"$f":"SUM(D77:D82)","v":{"$error":"#N/A"}},{"$f":"SUM(E77:E82)","v":{"$error":"#N/A"}},{"$f":"SUM(F77:F82)","v":{"$error":"#N/A"}}]

{"sheet":"Feasibility Output","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[36,0,38,5]]}
[]
["Table 1. Score Totals",{"$f":"'Data Input'!B1","v":"Site 1"},{"$f":"'Data Input'!C1","v":"Site 2"},{"$f":"'Data Input'!D1","v":"Site 3"},{"$f":"'Data Input'!E1","v":"Site 4"},{"$f":"'Data Input'!F1","v":"Site 5"}]
["Physical",{"$f":"'Data Input'!B12","v":{"$error":"#N/A"}},{"$f":"'Data Input'!C12","v":{"$error":"#N/A"}},{"$f":"'Data Input'!D12","v":{"$error":"#N/A"}},{"$f":"'Data Input'!E12","v":{"$error":"#N/A"}},{"$f":"'Data Input'!F12","v":{"$error":"#N/A"}}]
["Ecological",{"$f":"'Data Input'!B22","v":{"$error":"#N/A"}},{"$f":"'Data Input'!C22","v":{"$error":"#N/A"}},{"$f":"'Data Input'!D22","v":{"$error":"#N/A"}},{"$f":"'Data Input'!E22","v":{"$error":"#N/A"}},{"$f":"'Data Input'!F22","v":{"$error":"#N/A"}}]
["Access",{"$f":"'Data Input'!B31","v":{"$error":"#N/A"}},{"$f":"'Data Input'!C31","v":{"$error":"#N/A"}},{"$f":"'Data Input'!D31","v":{"$error":"#N/A"}},{"$f":"'Data Input'!E31","v":{"$error":"#N/A"}},{"$f":"'Data Input'!F31","v":{"$error":"#N/A"}}]
["Community Resources",{"$f":"'Data Input'!B39","v":{"$error":"#N/A"}},{"$f":"'Data Input'!C39","v":{"$error":"#N/A"}},{"$f":"'Data Input'!D39","v":{"$error":"#N/A"}},{"$f":"'Data Input'!E39","v":{"$error":"#N/A"}},{"$f":"'Data Input'!F39","v":{"$error":"#N/A"}}]
[]
["Table 2. Maximum Available Score",{"$f":"B2","v":"Site 1"},{"$f":"C2","v":"Site 2"},{"$f":"D2","v":"Site 3"},{"$f":"E2","v":"Site 4"},{"$f":"F2","v":"Site 5"}]
["Physical",{"$f":"IF('Data Input'!B6=\"-\", 'Data Reference'!$C$15,'Data Reference'!$C$20)+IF('Data Input'!B7=\"-\", 'Data Reference'!$C$24, 'Data Reference'!$C$29)+IF('Data Input'!B9=\"-\", 'Data Reference'!$C$37, 'Data Reference'!$C$39)+IF('Data Input'!B4=\"-\", 'Data Reference'!$C$4, 'Data Reference'!$C$6)+IF('Data Input'!B5=\"-\", 'Data Reference'!$C$10,'Data Reference'!$C$12)+IF('Data Input'!B11=\"-\",'Data Reference'!$C$51, 'Data Reference'!$C$49)+IF('Data Input'!B10=\"-\", 'Data Reference'!$C$42, 'Data Reference'!$C$45)+IF('Data Input'!B8=\"-\", 'Data Reference'!$C$32,'Data Reference'!$C$34)","v":85},{"$f":"IF('Data Input'!C6=\"-\", 'Data Reference'!$C$15,'Data Reference'!$C$20)+IF('Data Input'!C7=\"-\", 'Data Reference'!$C$24, 'Data Reference'!$C$29)+IF('Data Input'!C9=\"-\", 'Data Reference'!$C$37, 'Data Reference'!$C$39)+IF('Data Input'!C4=\"-\", 'Data Reference'!$C$4, 'Data Reference'!$C$6)+IF('Data Input'!C5=\"-\", 'Data Reference'!$C$10,'Data Reference'!$C$12)+IF('Data Input'!C11=\"-\",'Data Reference'!$C$51, 'Data Reference'!$C$49)+IF('Data Input'!C10=\"-\", 'Data Reference'!$C$42, 'Data Reference'!$C$45)+IF('Data Input'!C8=\"-\", 'Data Reference'!$C$32,'Data Reference'!$C$34)","v":85},{"$f":"IF('Data Input'!D6=\"-\", 'Data Reference'!$C$15,'Data Reference'!$C$20)+IF('Data Input'!D7=\"-\", 'Data Reference'!$C$24, 'Data Reference'!$C$29)+IF('Data Input'!D9=\"-\", 'Data Reference'!$C$37, 'Data Reference'!$C$39)+IF('Data Input'!D4=\"-\", 'Data Reference'!$C$4, 'Data Reference'!$C$6)+IF('Data Input'!D5=\"-\", 'Data Reference'!$C$10,'Data Reference'!$C$12)+IF('Data Input'!D11=\"-\",'Data Reference'!$C$51, 'Data Reference'!$C$49)+IF('Data Input'!D10=\"-\", 'Data Reference'!$C$42, 'Data Reference'!$C$45)+IF('Data Input'!D8=\"-\", 'Data Reference'!$C$32,'Data Reference'!$C$34)","v":85},{"$f":"IF('Data Input'!E6=\"-\", 'Data Reference'!$C$15,'Data Reference'!$C$20)+IF('Data Input'!E7=\"-\", 'Data Reference'!$C$24, 'Data Reference'!$C$29)+IF('Data Input'!E9=\"-\", 'Data Reference'!$C$37, 'Data Reference'!$C$39)+IF('Data Input'!E4=\"-\", 'Data Reference'!$C$4, 'Data Reference'!$C$6)+IF('Data Input'!E5=\"-\", 'Data Reference'!$C$10,'Data Reference'!$C$12)+IF('Data Input'!E11=\"-\",'Data Reference'!$C$51, 'Data Reference'!$C$49)+IF('Data Input'!E10=\"-\", 'Data Reference'!$C$42, 'Data Reference'!$C$45)+IF('Data Input'!E8=\"-\", 'Data Reference'!$C$32,'Data Reference'!$C$34)","v":85},{"$f":"IF('Data Input'!F6=\"-\", 'Data Reference'!$C$15,'Data Reference'!$C$20)+IF('Data Input'!F7=\"-\", 'Data Reference'!$C$24, 'Data Reference'!$C$29)+IF('Data Input'!F9=\"-\", 'Data Reference'!$C$37, 'Data Reference'!$C$39)+IF('Data Input'!F4=\"-\", 'Data Reference'!$C$4, 'Data Reference'!$C$6)+IF('Data Input'!F5=\"-\", 'Data Reference'!$C$10,'Data Reference'!$C$12)+IF('Data Input'!F11=\"-\",'Data Reference'!$C$51, 'Data Reference'!$C$49)+IF('Data Input'!F10=\"-\", 'Data Reference'!$C$42, 'Data Reference'!$C$45)+IF('Data Input'!F8=\"-\", 'Data Reference'!$C$32,'Data Reference'!$C$34)","v":85}]
["Ecological",{"$f":"IF('Data Input'!B14=\"-\", 'Data Reference'!$C$56, 'Data Reference'!$C$59)+IF('Data Input'!B15=\"-\", 'Data Reference'!$C$62, 'Data Reference'!$C$65)+IF('Data Input'!B16=\"-\",'Data Reference'!$C$69, 'Data Reference'!$C$72)+IF('Data Input'!B17=\"-\", 'Data Reference'!$C$76, 'Data Reference'!$C$79)+IF('Data Input'!B18=\"-\", 'Data Reference'!$C$83, 'Data Reference'!$C$86)+IF('Data Input'!B19=\"-\", 'Data Reference'!$C$90, 'Data Reference'!$C$93)+ IF('Data Input'!B20=\"-\", 'Data Reference'!$C$97, 'Data Reference'!$C$100)+ IF('Data Input'!B21=\"-\", 'Data Reference'!$C$104, 'Data Reference'!$C$107)","v":90},{"$f":"IF('Data Input'!C14=\"-\", 'Data Reference'!$C$56, 'Data Reference'!$C$59)+IF('Data Input'!C15=\"-\", 'Data Reference'!$C$62, 'Data Reference'!$C$65)+IF('Data Input'!C16=\"-\",'Data Reference'!$C$69, 'Data Reference'!$C$72)+IF('Data Input'!C17=\"-\", 'Data Reference'!$C$76, 'Data Reference'!$C$79)+IF('Data Input'!C18=\"-\", 'Data Reference'!$C$83, 'Data Reference'!$C$86)+IF('Data Input'!C19=\"-\", 'Data Reference'!$C$90, 'Data Reference'!$C$93)+ IF('Data Input'!C20=\"-\", 'Data Reference'!$C$97, 'Data Reference'!$C$100)+ IF('Data Input'!C21=\"-\", 'Data Reference'!$C$104, 'Data Reference'!$C$107)","v":90},{"$f":"IF('Data Input'!D14=\"-\", 'Data Reference'!$C$56, 'Data Reference'!$C$59)+IF('Data Input'!D15=\"-\", 'Data Reference'!$C$62, 'Data Reference'!$C$65)+IF('Data Input'!D16=\"-\",'Data Reference'!$C$69, 'Data Reference'!$C$72)+IF('Data Input'!D17=\"-\", 'Data Reference'!$C$76, 'Data Reference'!$C$79)+IF('Data Input'!D18=\"-\", 'Data Reference'!$C$83, 'Data Reference'!$C$86)+IF('Data Input'!D19=\"-\", 'Data Reference'!$C$90, 'Data Reference'!$C$93)+ IF('Data Input'!D20=\"-\", 'Data Reference'!$C$97, 'Data Reference'!$C$100)+ IF('Data Input'!D21=\"-\", 'Data Reference'!$C$104, 'Data Reference'!$C$107)","v":90},{"$f":"IF('Data Input'!E14=\"-\", 'Data Reference'!$C$56, 'Data Reference'!$C$59)+IF('Data Input'!E15=\"-\", 'Data Reference'!$C$62, 'Data Reference'!$C$65)+IF('Data Input'!E16=\"-\",'Data Reference'!$C$69, 'Data Reference'!$C$72)+IF('Data Input'!E17=\"-\", 'Data Reference'!$C$76, 'Data Reference'!$C$79)+IF('Data Input'!E18=\"-\", 'Data Reference'!$C$83, 'Data Reference'!$C$86)+IF('Data Input'!E19=\"-\", 'Data Reference'!$C$90, 'Data Reference'!$C$93)+ IF('Data Input'!E20=\"-\", 'Data Reference'!$C$97, 'Data Reference'!$C$100)+ IF('Data Input'!E21=\"-\", 'Data Reference'!$C$104, 'Data Reference'!$C$107)","v":90},{"$f":"IF('Data Input'!F14=\"-\", 'Data Reference'!$C$56, 'Data Reference'!$C$59)+IF('Data Input'!F15=\"-\", 'Data Reference'!$C$62, 'Data Reference'!$C$65)+IF('Data Input'!F16=\"-\",'Data Reference'!$C$69, 'Data Reference'!$C$72)+IF('Data Input'!F17=\"-\", 'Data Reference'!$C$76, 'Data Reference'!$C$79)+IF('Data Input'!F18=\"-\", 'Data Reference'!$C$83, 'Data Reference'!$C$86)+IF('Data Input'!F19=\"-\", 'Data Reference'!$C$90, 'Data Reference'!$C$93)+ IF('Data Input'!F20=\"-\", 'Data Reference'!$C$97, 'Data Reference'!$C$100)+ IF('Data Input'!F21=\"-\", 'Data Reference'!$C$104, 'Data Reference'!$C$107)","v":90}]
["Access",{"$f":"IF('Data Input'!B26=\"-\", 'Data Reference'!$C$112, 'Data Reference'!$C$114)+IF('Data Input'!B27=\"-\", 'Data Reference'!$C$117, 'Data Reference'!$C$119)+IF('Data Input'!B28=\"-\", 'Data Reference'!$C$122, 'Data Reference'!$C$124)+ +IF('Data Input'!B29=\"-\", 'Data Reference'!$C$127, 'Data Reference'!$C$129)+IF('Data Input'!B30=\"-\", 'Data Reference'!$C$132, 'Data Reference'!$C$133)","v":45},{"$f":"IF('Data Input'!C26=\"-\", 'Data Reference'!$C$112, 'Data Reference'!$C$114)+IF('Data Input'!C27=\"-\", 'Data Reference'!$C$117, 'Data Reference'!$C$119)+IF('Data Input'!C28=\"-\", 'Data Reference'!$C$122, 'Data Reference'!$C$124)+ +IF('Data Input'!C29=\"-\", 'Data Reference'!$C$127, 'Data Reference'!$C$129)+IF('Data Input'!C30=\"-\", 'Data Reference'!$C$132, 'Data Reference'!$C$133)","v":45},{"$f":"IF('Data Input'!D26=\"-\", 'Data Reference'!$C$112, 'Data Reference'!$C$114)+IF('Data Input'!D27=\"-\", 'Data Reference'!$C$117, 'Data Reference'!$C$119)+IF('Data Input'!D28=\"-\", 'Data Reference'!$C$122, 'Data Reference'!$C$124)+ +IF('Data Input'!D29=\"-\", 'Data Reference'!$C$127, 'Data Reference'!$C$129)+IF('Data Input'!D30=\"-\", 'Data Reference'!$C$132, 'Data Reference'!$C$133)","v":45},{"$f":"IF('Data Input'!E26=\"-\", 'Data Reference'!$C$112, 'Data Reference'!$C$114)+IF('Data Input'!E27=\"-\", 'Data Reference'!$C$117, 'Data Reference'!$C$119)+IF('Data Input'!E28=\"-\", 'Data Reference'!$C$122, 'Data Reference'!$C$124)+ +IF('Data Input'!E29=\"-\", 'Data Reference'!$C$127, 'Data Reference'!$C$129)+IF('Data Input'!E30=\"-\", 'Data Reference'!$C$132, 'Data Reference'!$C$133)","v":45},{"$f":"IF('Data Input'!F26=\"-\", 'Data Reference'!$C$112, 'Data Reference'!$C$114)+IF('Data Input'!F27=\"-\", 'Data Reference'!$C$117, 'Data Reference'!$C$119)+IF('Data Input'!F28=\"-\", 'Data Reference'!$C$122, 'Data Reference'!$C$124)+ +IF('Data Input'!F29=\"-\", 'Data Reference'!$C$127, 'Data Reference'!$C$129)+IF('Data Input'!F30=\"-\", 'Data Reference'!$C$132, 'Data Reference'!$C$133)","v":45}]
["Community Resources",{"$f":"IF('Data Input'!B33=\"-\", 'Data Reference'!$C$138,'Data Reference'!$C$140)+IF('Data Input'!B34=\"-\", 'Data Reference'!$C$143, 'Data Reference'!$C$145)+IF('Data Input'!B35=\"-\", 'Data Reference'!$C$148, 'Data Reference'!$C$150)+IF('Data Input'!B36=\"-\", 'Data Reference'!$C$153, 'Data Reference'!$C$155)+IF('Data Input'!B37=\"-\", 'Data Reference'!$C$158, 'Data Reference'!$C$159)+IF('Data Input'!B38=\"-\", 'Data Reference'!$C$162, 'Data Reference'!$C$163)","v":60},{"$f":"IF('Data Input'!C33=\"-\", 'Data Reference'!$C$138,'Data Reference'!$C$140)+IF('Data Input'!C34=\"-\", 'Data Reference'!$C$143, 'Data Reference'!$C$145)+IF('Data Input'!C35=\"-\", 'Data Reference'!$C$148, 'Data Reference'!$C$150)+IF('Data Input'!C36=\"-\", 'Data Reference'!$C$153, 'Data Reference'!$C$155)+IF('Data Input'!C37=\"-\", 'Data Reference'!$C$158, 'Data Reference'!$C$159)+IF('Data Input'!C38=\"-\", 'Data Reference'!$C$162, 'Data Reference'!$C$163)","v":60},{"$f":"IF('Data Input'!D33=\"-\", 'Data Reference'!$C$138,'Data Reference'!$C$140)+IF('Data Input'!D34=\"-\", 'Data Reference'!$C$143, 'Data Reference'!$C$145)+IF('Data Input'!D35=\"-\", 'Data Reference'!$C$148, 'Data Reference'!$C$150)+IF('Data Input'!D36=\"-\", 'Data Reference'!$C$153, 'Data Reference'!$C$155)+IF('Data Input'!D37=\"-\", 'Data Reference'!$C$158, 'Data Reference'!$C$159)+IF('Data Input'!D38=\"-\", 'Data Reference'!$C$162, 'Data Reference'!$C$163)","v":60},{"$f":"IF('Data Input'!E33=\"-\", 'Data Reference'!$C$138,'Data Reference'!$C$140)+IF('Data Input'!E34=\"-\", 'Data Reference'!$C$143, 'Data Reference'!$C$145)+IF('Data Input'!E35=\"-\", 'Data Reference'!$C$148, 'Data Reference'!$C$150)+IF('Data Input'!E36=\"-\", 'Data Reference'!$C$153, 'Data Reference'!$C$155)+IF('Data Input'!E37=\"-\", 'Data Reference'!$C$158, 'Data Reference'!$C$159)+IF('Data Input'!E38=\"-\", 'Data Reference'!$C$162, 'Data Reference'!$C$163)","v":60},{"$f":"IF('Data Input'!F33=\"-\", 'Data Reference'!$C$138,'Data Reference'!$C$140)+IF('Data Input'!F34=\"-\", 'Data Reference'!$C$143, 'Data Reference'!$C$145)+IF('Data Input'!F35=\"-\", 'Data Reference'!$C$148, 'Data Reference'!$C$150)+IF('Data Input'!F36=\"-\", 'Data Reference'!$C$153, 'Data Reference'!$C$155)+IF('Data Input'!F37=\"-\", 'Data Reference'!$C$158, 'Data Reference'!$C$159)+IF('Data Input'!F38=\"-\", 'Data Reference'!$C$162, 'Data Reference'!$C$163)","v":60}]
[]
["Table 3. Score oas Percentage of Max Score",{"$f":"B2","v":"Site 1"},{"$f":"C2","v":"Site 2"},{"$f":"D2","v":"Site 3"},{"$f":"E2","v":"Site 4"},{"$f":"F2","v":"Site 5"}]
["Physical",{"$f":"B3/B9","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Ecological",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Access",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Community Resources",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Table 4. Team Building/Resource Inventory",{"$f":"B2","v":"Site 1"},{"$f":"C2","v":"Site 2"},{"$f":"D2","v":"Site 3"},{"$f":"E2","v":"Site 4"},{"$f":"F2","v":"Site 5"}]
["Design Complexity",{"$f":"1-((B15+B16)/2)","v":{"$error":"#N/A"}},{"$f":"1-((C15+C16)/2)","v":{"$error":"#N/A"}},{"$f":"1-((D15+D16)/2)","v":{"$error":"#N/A"}},{"$f":"1-((E15+E16)/2)","v":{"$error":"#N/A"}},{"$f":"1-((F15+F16)/2)","v":{"$error":"#N/A"}}]
["Implementation Complexity",{"$f":"(1-((B17)+B18)/2)","v":{"$error":"#N/A"}},{"$f":"(1-((C17)+C18)/2)","v":{"$error":"#N/A"}},{"$f":"(1-((D17)+D18)/2)","v":{"$error":"#N/A"}},{"$f":"(1-((E17)+E18)/2)","v":{"$error":"#N/A"}},{"$f":"(1-((F17)+F18)/2)","v":{"$error":"#N/A"}}]
[]
["Table 5. Overall Feasibility",{"$f":"B2","v":"Site 1"},{"$f":"C2","v":"Site 2"},{"$f":"D2","v":"Site 3"},{"$f":"E2","v":"Site 4"},{"$f":"F2","v":"Site 5"}]
["Ease of Construction",{"$f":"((B15*0.4)+(B16*0.2)+(B17*0.4))","v":{"$error":"#N/A"}},{"$f":"((C15*0.4)+(C16*0.2)+(C17*0.4))","v":{"$error":"#N/A"}},{"$f":"((D15*0.4)+(D16*0.2)+(D17*0.4))","v":{"$error":"#N/A"}},{"$f":"((E15*0.4)+(E16*0.2)+(E17*0.4))","v":{"$error":"#N/A"}},{"$f":"((F15*0.4)+(F16*0.2)+(F17*0.4))","v":{"$error":"#N/A"}}]
["Ease of Construction (weighted 50%)",{"$f":"((B15*0.4)+(B16*0.2)+(B17*0.4))/2","v":{"$error":"#N/A"}},{"$f":"((C15*0.4)+(C16*0.2)+(C17*0.4))/2","v":{"$error":"#N/A"}},{"$f":"((D15*0.4)+(D16*0.2)+(D17*0.4))/2","v":{"$error":"#N/A"}},{"$f":"((E15*0.4)+(E16*0.2)+(E17*0.4))/2","v":{"$error":"#N/A"}},{"$f":"((F15*0.4)+(F16*0.2)+(F17*0.4))/2","v":{"$error":"#N/A"}}]
["Community Resources (weighted 50%)",{"$f":"B18*0.5","v":{"$error":"#N/A"}},{"$f":"C18*0.5","v":{"$error":"#N/A"}},{"$f":"D18*0.5","v":{"$error":"#N/A"}},{"$f":"E18*0.5","v":{"$error":"#N/A"}},{"$f":"F18*0.5","v":{"$error":"#N/A"}}]
["Overall Feasibility",{"$f":"B26+B27","v":{"$error":"#N/A"}},{"$f":"C26+C27","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Shoreline Type",{"$f":"IF(B15>66%, \"Natural\", IF(B15<33%, \"Structural\", \"Hybrid\"))","v":{"$error":"#N/A"}},{"$f":"IF(C15>66%, \"Natural\", IF(C15<33%, \"Structural\", \"Hybrid\"))","v":{"$error":"#N/A"}},{"$f":"IF(D15>66%, \"Natural\", IF(D15<33%, \"Structural\", \"Hybrid\"))","v":{"$error":"#N/A"}},{"$f":"IF(E15>66%, \"Natural\", IF(E15<33%, \"Structural\", \"Hybrid\"))","v":{"$error":"#N/A"}},{"$f":"IF(F15>66%, \"Natural\", IF(F15<33%, \"Structural\", \"Hybrid\"))","v":{"$error":"#N/A"}}]

{"sheet":"Data Reference","index":2,"n_rows":163,"n_cols":17,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
[null,"PHYSICAL CONDITIONS","Final Score ","Initial Rank","Multiplier"]
[null,"Water Body Energy",null,null,1]
[null,"-"]
[null,"High - wb",{"$f":"E2*D4","v":0},0,null,null,null,null,null,null,null,"P&E (80-20%)",{"$f":"((#REF!*0.8)+(#REF!*0.2))/((#REF!*0.8)+(#REF!*0.2))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.8)+(#REF!*0.2))/((#REF!*0.8)+(#REF!*0.2))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.8)+(#REF!*0.2))/((#REF!*0.8)+(#REF!*0.2))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.8)+(#REF!*0.2))/((#REF!*0.8)+(#REF!*0.2))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.8)+(#REF!*0.2))/((#REF!*0.8)+(#REF!*0.2))","v":{"$error":"#REF!"}}]
[null,"Medium - wb",{"$f":"E2*D5","v":2.5},2.5,null,null,null,null,null,null,null,"A & CS(60-40%)",{"$f":"((#REF!*0.6)+(#REF!*0.4))/((#REF!*0.6)+(#REF!*0.4))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.6)+(#REF!*0.4))/((#REF!*0.6)+(#REF!*0.4))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.6)+(#REF!*0.4))/((#REF!*0.6)+(#REF!*0.4))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.6)+(#REF!*0.4))/((#REF!*0.6)+(#REF!*0.4))","v":{"$error":"#REF!"}},{"$f":"((#REF!*0.6)+(#REF!*0.4))/((#REF!*0.6)+(#REF!*0.4))","v":{"$error":"#REF!"}}]
[null,"Low- wb",{"$f":"E2*D6","v":5},5]
[]
[null,"Positional Energy",null,null,2]
[null,"-"]
[null,"High - p",{"$f":"E8*D10","v":0},0]
[null,"Medium - p",{"$f":"E8*D11","v":5},2.5]
[null,"Low - p",{"$f":"E8*D12","v":10},5]
[null,"Storm Event Energy",null,null,3]
[null,"-"]
[null,"Aligned, High Winds (>30mph) ",{"$f":"E13*D15","v":0},0]
[null,"Aligned, Medium Winds (17-30mph)",{"$f":"E13*D16","v":3},1]
[null,"Aligned, Low Winds (<17mph)",{"$f":"E13*D17","v":6},2]
[null,"Unaligned, High Winds",{"$f":"E13*D18","v":9},3]
[null,"Unaligned, Medium Winds",{"$f":"E13*D19","v":12},4]
[null,"Unaligned, Low Winds",{"$f":"E13*D20","v":15},5]
[]
[null,"Persistent Wave Energy",null,null,3]
[null,"-"]
[null,"High (>5 miles)/Aligned",{"$f":"E22*D24","v":0},0]
[null,"High (>5 miles)/Unaligned",{"$f":"E22*D25","v":3},1]
[null,"Medium (1-5 miles)/Aligned",{"$f":"$E$22*D26","v":6},2]
[null,"Medium (1-5 miles)/Unaligned",{"$f":"$E$22*D27","v":9},3]
[null,"Low (<1 mile)/Aligned",{"$f":"$E$22*D28","v":12},4]
[null,"Low (<1 mile)/Unaligned",{"$f":"$E$22*D29","v":15},5]
[null,"Boat Wake Energy",null,null,2]
[null,"-"]
[null,"High - bw",{"$f":"E30*D32","v":0},0]
[null,"Medium - bw",{"$f":"E30*D33","v":5},2.5]
[null,"Low - bw",{"$f":"E30*D34","v":10},5]
[null,"Nearshore Slope (Stevens guide)",null,null,1]
[null,"-"]
[null,"High (> 20%) ",{"$f":"E35*D37","v":0},0]
[null,"Medium (10 - 20%) ",{"$f":"E35*D38","v":2.5},2.5]
[null,"Low (< 10%)",{"$f":"E35*D39","v":5},5]
[null,"On-site Shoreline Condition",null,null,3]
[null,"-"]
[null,"Seawall",{"$f":"E40*D42","v":0},0]
[null,"Rip-Rap/Stone",{"$f":"E40*D43","v":7.5},2.5]
[null,"Mixed",{"$f":"E40*D44","v":10.5},3.5]
[null,"Natural",{"$f":"E40*D45","v":15},5]
[]
[null,"Surrounding Shoreline Condition",null,null,2]
[null,"-"]
[null,"Predominantly Natural",{"$f":"E47*D49","v":10},5]
[null,"Mixed Natural and Hardened ",{"$f":"E47*D50","v":5},2.5]
[null,"Predominantly Hardened",{"$f":"E47*D51","v":0},0]
[]
[null,"ECOLOGICAL CONDITIONS"]
[null,"Percent Canopy Shading",null,null,1]
[null,"-"]
[null,"76-100%",{"$f":"E54*D56","v":0},0]
[null,"51-75%",{"$f":"E54*D57","v":1},1]
[null,"26-50%",{"$f":"E54*D58","v":2},2]
[null,"0-25%",{"$f":"E54*D59","v":5},5]
[null,"Intertidal Vegetation Community Status",null,null,3]
[null,"-"]
[null,"Only Undesired /Active Removal- int",{"$f":"E60*D62","v":0},0]
[null,"Mixed/ Active Removal- int",{"$f":"D63*E60","v":3},1]
[null,"No Vegetation/ Passive Action - int",{"$f":"D64*E60","v":6},2]
[null,"Desired or Mixed / Passive Action- int",{"$f":"E60*D65","v":15},5]
[]
[null,"Intertidal Vegetation Substrate",null,null,2]
[null,"-"]
[null,"Impenetrable- int",{"$f":"E67*D69","v":0},0]
[null,"Undesired- int",{"$f":"E67*D70","v":2},1]
[null,"Desired Unstable- int",{"$f":"E67*D71","v":6},3]
[null,"Desired Stable- int",{"$f":"E67*D72","v":10},5]
[]
[null,"Subtidal Vegetation Community Status",null,null,3]
[null,"-"]
[null,"Only Undesired /Active Removal- sub",{"$f":"E74*D76","v":0},0]
[null,"Mixed/Active Removal- sub",{"$f":"D77*E74","v":3},1]
[null,"No Vegetation /Passive Action - sub",{"$f":"D78*E74","v":6},2]
[null,"Desired or Mixed/ Passive Action- sub",{"$f":"E74*D79","v":15},5]
[]
[null,"Subtidal Vegetation Substrate",null,null,2]
[null,"-"]
[null,"Impenetrable- sub",{"$f":"E81*D83","v":0},0]
[null,"Undesired- sub",{"$f":"E81*D84","v":2},1]
[null,"Desired Unstable- sub",{"$f":"E81*D85","v":6},3]
[null,"Desired Stable- sub",{"$f":"E81*D86","v":10},5]
[]
[null,"Upland Vegetation Community Status",null,null,3]
[null,"-"]
[null,"Only Undesired/Active Removal- up",{"$f":"E88*D90","v":0},0]
[null,"Mixed /Active Removal- up",{"$f":"D91*E88","v":3},1]
[null,"No Vegetation/Passive Action- up",{"$f":"D92*E88","v":6},2]
[null,"Desired or Mixed /Passive Action- up",{"$f":"E88*D93","v":15},5]
[]
[null,"Upland Vegetation Substrate",null,null,2]
[null,"-"]
[null,"Impenetrable- up",{"$f":"E95*D97","v":0},0]
[null,"Undesired- up",{"$f":"E95*D98","v":2},1]
[null,"Desired Unstable- up",{"$f":"E95*D99","v":6},3]
[null,"Desired Stable- up",{"$f":"E95*D100","v":10},5]
[]
[null,"Shellfish Community",null,null,2]
[null,"-"]
[null,"Undesired Community Removal",{"$f":"E102*D104","v":0},0]
[null,"Biofouling Issues Require Active Attention",{"$f":"E102*D105","v":2},1]
[null,"No Shellfish Present",{"$f":"D106*E102","v":4},2]
[null,"Desired Shellfish Present",{"$f":"D107*E102","v":10},5]
[]
[null,"SITE ACCESS"]
[null,"Material Delivery",null,null,2]
[null,"-"]
[null,"High Complexity- m",{"$f":"E110*D112","v":0},0]
[null,"Medium Complexity- m",{"$f":"E110*D113","v":5},2.5]
[null,"Low Complexity- m",{"$f":"E110*D114","v":10},5]
[null,"Landowner Agreement",null,null,3]
[null,"-"]
[null,"Single or Multiple Landowner Disagreement",{"$f":"E115*D117","v":0},0]
[null,"Multiple Landowner Agreement",{"$f":"E115*D118","v":7.5},2.5]
[null,"Single Landowner Agreement",{"$f":"E115*D119","v":15},5]
[null,"Personnel Access",null,null,2]
[null,"-"]
[null,"High Complexity- p",{"$f":"E120*D122","v":0},0]
[null,"Medium Complexity- p",{"$f":"E120*D123","v":5},2.5]
[null,"Low Complexity- p",{"$f":"E120*D124","v":10},5]
[null,"Working Window",null,null,1]
[null,"-"]
[null,"<3hrs",{"$f":"E125*D127","v":0},0]
[null,"3-6hrs",{"$f":"E125*D128","v":2.5},2.5]
[null,"6-12hrs",{"$f":"E125*D129","v":5},5]
[null,"Regulatory Considerations",null,null,1]
[null,"-"]
[null,"Considerations",{"$f":"E130*D132","v":0},0]
[null,"No considerations",{"$f":"E130*D133","v":5},5]
[]
[null,"COMMUNITY RESOURCES"]
[null,"Public Outreach/Education Potential",null,null,1]
[null,"-"]
[null,"No Access/Viewability",{"$f":"E136*D138","v":0},0]
[null,"Passive Programming",{"$f":"$E$136*D139","v":3},3]
[null,"Active Progamming",{"$f":"$E$136*D140","v":5},5]
[null,"Community Stewardship",null,null,3]
[null,"-"]
[null,"Negative Engagement (vandalism, trash dumping)",{"$f":"E141*D143","v":0},0]
[null,"Neutral Engagement",{"$f":"$E$141*D144","v":7.5},2.5]
[null,"Active Positive Engagement",{"$f":"$E$141*D145","v":15},5]
[null,"Resource/Capital Availability",null,null,3]
[null,"-"]
[null,"Low Resources",{"$f":"E146*D148","v":0},0]
[null,"Moderate Resource",{"$f":"E146*D149","v":7.5},2.5]
[null,"High Resources",{"$f":"E146*D150","v":15},5]
[null,"Enthusiasm for Nature Based Infrastructure",null,null,2]
[null,"-"]
[null,"Minimumly Engaged",{"$f":"E151*D153","v":0},0]
[null,"Moderately Engaged",{"$f":"E151*D154","v":5},2.5]
[null,"Very Engaged",{"$f":"E151*D155","v":10},5]
[null,"Community Protection ",null,null,2]
[null,"-"]
[null,"Individual/ Other Protections",{"$f":"E156*D158","v":0},0]
[null,"Community Infrastructure Protection",{"$f":"E156*D159","v":10},5]
[null,"Environmental Justice Leverage Potential",null,null,1]
[null,"-"]
[null,"No-EJ",{"$f":"E160*D162","v":0},0]
[null,"Yes-EJ",{"$f":"E160*D163","v":5},5]