{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RIM Riparian & Floodplain Resto"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RIM Riparian & Floodplain Resto","index":0,"n_rows":80,"n_cols":40,"rows_kept":80,"cut":false,"hidden":false,"merged":[[91,9,91,11],[82,2,82,13],[83,2,83,13],[84,2,84,13],[86,1,86,14],[88,0,88,3],[88,12,88,14],[81,2,81,13],[67,1,67,6],[67,10,67,15],[69,0,69,15],[70,0,70,15],[71,1,71,10],[73,1,73,7],[74,1,75,13],[77,1,77,8],[78,1,78,14],[79,2,79,13],[80,2,80,13],[65,3,66,15],[29,9,29,14],[32,9,32,12],[35,1,35,15],[36,1,36,15],[37,8,37,9],[49,3,49,10],[50,3,50,11],[53,3,54,10],[55,3,55,11],[59,3,59,11],[64,13,64,14],[28,5,28,11],[14,7,14,9],[16,3,16,11],[17,5,17,11],[18,5,18,11],[19,5,19,11],[20,5,20,11],[23,5,23,11],[24,5,24,11],[25,5,25,11],[26,5,26,11],[27,3,27,11],[13,7,13,9],[13,12,13,14],[1,1,1,6],[2,1,2,15],[3,1,3,15],[4,4,4,14],[5,5,5,8],[5,9,5,13],[6,5,6,8],[6,9,6,13],[7,13,7,14],[9,2,9,10],[10,3,11,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2  "]
[null,"RIM RIPARIAN AND FLOODPLAIN RESTORATION"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,null,null,null,"Landowner Name:",null,null,null,"County/SWCD Office:"]
[]
[null,null,"Offer must meet these minimum criteria to be eligible:"]
[null,null,"*Offer meets minimum enrollment size (8-acres) or meets waiver requirements"]
[null,null,"*A minimum scoring threshold may be set based on applications received in a given batching period",null,null,null,null,null,null,null,null,null,null,"Total Score  ",{"$f":"IF(O13=\"Error\",\"Error\",IF(O17=\"Error\",\"Error\",IF(O23=\"Error\",\"Error\",IF(O28=\"Error\",\"Error\",IF(O39=\"Error\",\"Error\",IF(O45=\"Error\",\"Error\",IF(O51=\"Error\",\"Error\",IF(O56=\"Error\",\"Error\",IF(O60=\"Error\",\"Error\",IF(O64=\"Error\",\"Error\",(O13+O17+O23+O28+O39+O45+O51+O56+O60+O64)))))))))))","v":0},null,null,null,null,null,null,null,"True/false","Score"]
[null,null,null,"Choose only ONE answer per question below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W11=TRUE,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W12=TRUE,0,0)","v":0}]
[null,null,"1.","Will this offer enroll and protect land under an existing CRP contract? (maximum score 5)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W13>1,\"Error\",X13)","v":0},null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W11:W12, TRUE)","v":0},{"$f":"SUM(X11:X12)","v":0},"Score Sum"]
[null,null,null,null,"a.","Yes  — 5 pts",null,"CRP Contract Expiration:\n"]
[null,null,null,null,"b.","No  — 0 pts",null,"CRP Contract Practice:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W16=TRUE,20,0)","v":0}]
[null,null,"2.","Proximity to existing permanently protected habitat complex (maximum score 20)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W20>1,\"Error\",X20)","v":0},null,null,null,null,null,null,"b",null,{"$f":"IF(W17=TRUE,15,0)","v":0}]
[null,null,null,null,"a.","Permanently protected land or another RIM Riparian and Floodplain Restoration eligible offer or approved contract is on both ends of the land offered in this application — 20 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",null,{"$f":"IF(W18=TRUE,5,0)","v":0}]
[null,null,null,null,"b.","Permanently protected land or another RIM Riparian and Floodplain Restoration eligible offer or approved contract is only on one end of the land offered in this application — 15 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",null,{"$f":"IF(W19=TRUE,0,0)","v":0}]
[null,null,null,null,"c.","Permanently protected land or another RIM Riparian and Floodplain Restoration eligible offer or approved contract on the same watercourse/water body is within 1/2 mile of either end of the land offered in this application — 5 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W16:W19,\"TRUE\")","v":0},{"$f":"SUM(X16:X19)","v":0},"Score Sum"]
[null,null,null,null,"d.","None of the above — 0 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score"]
[null,null,"3.","Proximity to public land that is open for public hunting (maximum score 5)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W26>1,\"Error\",X26)","v":0},null,null,null,null,null,null,"a",null,{"$f":"IF(W23=TRUE,5,0)","v":0}]
[null,null,null,null,"a.","Immediately adjacent — 5 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W24=TRUE,3,0)","v":0}]
[null,null,null,null,"b.","Within 1 mile — 3 pts",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"c",null,{"$f":"IF(W25=TRUE,0,0)","v":0}]
[null,null,null,null,"c.","None of the above — 0 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W23:W25,\"TRUE\")","v":0},{"$f":"SUM(X23:X25)","v":0},"Score Sum"]
[]
[null,null,"4.","The offered area will result in addressing water quality concerns for conventional pollutants (e.g., sediment, phosphorus, hydrology, bacteria, nitrogen) as identified in a TMDL report or implementation plan or a WRAPS (maximum score 8)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W31>1,\"Error\",X31)","v":0},null,null,null,null,null,null,null,"True/false","Score"]
[null,null,null,null,"a.","Yes — 8 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W29=TRUE,8,0)","v":0}]
[null,null,null,null,"b.","No — 0 pts",null,null,null,"BWSR Use Only",null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W30=TRUE,0,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",null,{"$f":"SUM(X29:X30)","v":0},"Score Sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"/100"]
[null,null,null,null,null,null,null,null,null,"Program Manager Approval",null,null,null,null,"Score"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 2 of 2  "]
[null,"RIM RIPARIAN AND FLOODPLAIN RESTORATION"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"True/false","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W38=TRUE,15,0)","v":0}]
[null,null,"5.","Type of water source being protected (maximum score 15)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF($W$42>1,\"Error\",$X$42)","v":0},null,null,null,null,null,null,"b",null,{"$f":"IF(W39=TRUE,10,0)","v":0}]
[null,null,null,null,"a.","River/Stream (including Public Drainage Systems that are Public Waters) — 15 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",null,{"$f":"IF(W40=TRUE,5,0)","v":0}]
[null,null,null,null,"b.","Lake — 10 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",null,{"$f":"IF(W41=TRUE,0,0)","v":0}]
[null,null,null,null,"c.","Wetland — 5 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W38:W41,\"TRUE\")","v":0},{"$f":"SUM(X38:X41)","v":0},"Score Sum"]
[null,null,null,null,"d.","Public Drainage System — 0 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"True/false","Score"]
[null,null,"6.","Easement size (maximum score 15)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF($W$49>1,\"Error\",$X$49)","v":0},null,null,null,null,null,null,"a",null,{"$f":"IF(W45=TRUE,15,0)","v":0}]
[null,null,null,null,"a.",">20 acres — 15 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W46=TRUE,10,0)","v":0}]
[null,null,null,null,"b.","11 - 20 acres — 10 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W47=TRUE,5,0)","v":0}]
[null,null,null,null,"c.","8 - 10 acres — 5 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W48=TRUE,0,0)","v":0}]
[null,null,null,null,"d.","<8 acres — 0 pts (REQUIRES APPROVED WAIVER TO BE ELIGIBLE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W45:W48,\"TRUE\")","v":0},{"$f":"SUM(X45:X48)","v":0},"Score Sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"True/false"]
[null,null,"7.","Is the offered acreage located within a high priority or priority area identified in a locally adopted Comprehensive Water Management Plan (CWMP)? List document name and page number of adopted or draft plan below. (maximum score 20)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF($W$53>1,\"Error\",$X$53)","v":0},null,null,null,null,null,null,"a",null,{"$f":"IF(W51=TRUE,20,0)","v":0}]
[null,null,null,null,"a.","High Priority — 20 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W52=TRUE,10,0)","v":0}]
[null,null,null,null,"b.","Priority — 10 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W51:W52,\"TRUE\")","v":0},{"$f":"SUM(X51:X52)","v":0},"Score Sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"True/false","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W55=TRUE,2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL63>1,1,0)","v":0}]
[null,null,"8.","The offered area is beneficial to, and within 1 miles of, a breeding/population of Federal or State listed endangered or threatened species as identified by DNR Natural Heritage Database (State special concerns species shall not be considered), Federal species to be considered include endangered, threatened, and candidate species, including designated critical habitat (e.g., Topeka Shiner). (maximum score 2)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF($W$57>1,\"Error\",$X$57)","v":0},null,null,null,null,null,null,"b",null,{"$f":"IF(W56=TRUE,0,0)","v":0}]
[null,null,null,null,"a.","Yes — 2 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W55:W56,\"TRUE\")","v":0},{"$f":"SUM(X55:X56)","v":0},"Score Sum"]
[null,null,null,null,"b.","No — 0 pts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"True/false","Score"]
[null,null,"9.","Since 2000, how many times has the offered acreage been inundated or had crop loss due to flooding? (maximum score 2)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF($W$63>1,\"Error\",$X$63)","v":0},null,null,null,null,null,null,"a",null,{"$f":"IF(W60=TRUE,2,0)","v":0}]
[null,null,null,null,"a.","≥4 — 2 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W61=TRUE,1,0)","v":0}]
[null,null,null,null,"b.","1 - 3 — 1 pt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W62=TRUE,0,0)","v":0}]
[null,null,null,null,"c.","0 — 0 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(W60:W62,\"TRUE\")","v":0},{"$f":"SUM(X60:X62)","v":0},"Score Sum",null,null,null,null,null,null,{"$f":"(V65+X65+Z65+AB65+AD65)","v":0}]
[null,null,"10.","Additional wildlife benefits (maximum score 8)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF($AF$63>1,\"Error\",$AF$65)","v":0},null,null,null,null,null,null,null,{"$f":"IF(V64=FALSE,0,0)","v":0},null,{"$f":"IF(X64=FALSE,0,2)","v":0},null,{"$f":"IF(Z64=FALSE,0,4)","v":0},null,{"$f":"IF(AB64=FALSE,0,6)","v":0},null,{"$f":"IF(AD64=FALSE,0,8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V64,\"TRUE\")","v":0},{"$f":"W64","v":0},{"$f":"COUNTIF(X64,\"TRUE\")","v":0},{"$f":"Y64","v":0},{"$f":"COUNTIF(Z64,\"TRUE\")","v":0},{"$f":"AA64","v":0},{"$f":"COUNTIF(AB64,\"TRUE\")","v":0},{"$f":"AC64","v":0},{"$f":"COUNTIF(AD64,\"TRUE\")","v":0},{"$f":"AE64","v":0},{"$f":"(W65+Y65+AA65+AC65+AE65)","v":0}]
[null,null,null,"Determine score from Additional Wildlife Benefits GIS layer and check appropriate score box\n20 (red) on the GIS layer = 8 on the scoring sheet, 15 (yellow) = 6, 10 (green) = 4, 5 (blue) = 2, 0 (gray) = 0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF79","v":0},null,{"$f":"AH79","v":0},{"$f":"SUM(X80:AL80)","v":0},{"$f":"IF(AM80>10,10,AM80)","v":0}]