{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions - Menu","Supporting Documents Checklist","Site Eligibility Form","Site Assessment Form","Scoresheet","List_SWCD"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":5,"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":"Instructions - Menu","index":0,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[29,1,29,3],[27,2,27,6],[10,2,11,12],[12,2,12,12],[13,2,13,12],[14,2,14,12],[19,2,19,6],[19,8,19,12],[20,2,20,6],[20,8,20,12],[22,2,22,6],[23,2,23,6],[26,2,26,6],[8,2,8,12],[1,1,1,2],[2,2,2,12],[3,2,3,12],[4,6,4,8],[6,2,6,13]]}
[]
[]
[null,null,"RIM Wetlands Program"]
[null,null,"Supporting Application Documents File"]
[null,null,null,null,null,null,"2024-02-20"]
[null,null,"Instructions:"]

{"sheet":"Supporting Documents Checklist","index":1,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[29,1,29,4],[21,3,21,11],[17,3,17,10],[18,3,18,10],[24,3,24,10],[25,3,25,10],[26,3,26,10],[27,3,27,10],[28,3,28,11],[20,2,20,5],[6,3,6,7],[6,9,6,10],[14,3,14,10],[15,3,15,10],[16,3,16,10],[7,1,7,11],[9,3,9,10],[1,1,1,3],[2,1,2,11],[3,1,3,11],[5,3,5,7],[5,9,5,10]]}
[]
[]
[null,"RIM Wetlands Workbook"]
[null," Supporting Documents Checklist"]
[]
[null,null,null,"Landowner Name",null,null,null,null,null,"County/SWCD Office"]
[]
[]
[]
[]
[null,null,"AIR PHOTO AND/OR MAP DOCUMENTATION"]
[null,null,"Displaying each of the following (suggested map groupings provided)"]
[]
[null,null,"Map Set 1"]
[null,null,null,"Proposed preliminary preliminary easement boundary and access route location on aerial photo with scale. Label and list acres for MNCREP Cropland, RIM-Only Crop (Existing CRP, Ineligible CRP), RIM-Only Non-Crop, Donated.",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Planned dimensions and distances for easement area.  Identify section corners or centers.",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Location and boundary of other conservation easements contained within the proposed application area, if applicable.",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Location and name or number of any public waters or public water wetlands that are within or adjacent to the proposed application area, if applicable",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Location of building sites or utilities (pipelines, power lines, telecommunications lines or cables) located within or adjacent to the planned easement area. Provide details where possible.",null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"Map Set 2",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Areas with crop history vs. no crop history; areas under existing CRP contract."]
[]
[null,null,"Map Set 3"]
[null,null,null,"Location of all program eligible drained/altered wetland areas. If the application contains eligible drained/altered wetlands that are unsuitable for scoring, identify them separately from scored wetlands. If depressional (ponded) areas exist within wetland areas and are used in scoring, indicate them as well.",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Identification of all drainage components affecting site wetlands (tile, ditches, pumps, etc.). If tile drained, landowner/tile installer maps preferred.",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Types and locations of basic wetland restoration strategies that are anticipated such as tile blocks, tile outlets, tile reroutes, pump removal, ditch plugs, embankments, scrapes, etc.",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"LiDAR elevation information for application area and immediate surrounding area.",null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Site Eligibility Form","index":2,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[46,3,47,13],[48,6,49,13],[50,3,51,13],[52,6,53,14],[44,6,45,13],[8,1,8,14],[9,2,9,13],[13,5,13,13],[15,5,15,13],[17,5,17,13],[21,5,21,13],[27,5,27,13],[29,5,29,13],[32,12,33,13],[40,2,40,13],[38,8,39,12],[7,4,7,8],[7,10,7,12],[1,1,1,3],[2,1,2,14],[4,1,4,14],[6,4,6,8],[6,10,6,12]]}
[]
[]
[null,"RIM Wetlands Program"]
[]
[null,"Site Eligibility Form"]
[]
[null,null,null,null,"Landowner Name",null,null,null,null,null,"County/SWCD Office"]
[]
[null,0]
[null,null,"SECTION I. Land Type and Acreage Information"]
[]
[null,null,"A.  Eligible Drained and Altered Wetlands"]
[]
[null,null,null,null,null,"Acres of Drained/Altered Wetlands"]
[]
[null,null,null,null,null,"Acres of Cropped, Natural Wetlands"]
[]
[null,null,null,null,null,"Acres of Wetland Previously Restored through another program (Ex. CRP)"]
[]
[null,null,null,null,null,null,null," Estimated Restorable Wetland Acres"]
[]
[null,null,null,{"$f":"D14+D16+D18","v":0},null,"Total Acres of Eligible Drained/Altered Wetlands"]
[]
[]
[]
[null,null,"B.  Eligible Adjacent Lands"]
[]
[null,null,null,null,null,"Acres of Cropped, Adjacent Lands"]
[]
[null,null,null,null,null,"Acres of Non-Cropped Adacent Lands"]
[]
[]
[null,null,null,{"$f":"SUM(D28:D31)","v":0},null,"Total Acres of Eligible Adjacent Lands"]
[]
[null,null,"C.  Donated Lands"]
[]
[null,null,null,null,null,"Acres of Donated Lands"]
[]
[null,null,null,{"$f":"D22+D33+D37","v":0},null,"Total Easement Acres",null,null,{"$f":"IF(D39 = 0,\"\",IF(D39<8, \"Offer must be >= 8 acres in size. Mininum size waiver required.\",\"\"))","v":""}]
[]
[null,null,"SECTION II. Program Eligibility Information"]
[]
[null,null,null,"A. Eligible Cropped Adjacent Lands to Eligible Drained/Altered Wetlands Acreage Ratio"]
[]
[null,null,null,{"$f":"IF(OR(D22 = 0,ISBLANK(D28)),0,IF(D28>0,D28/D22,0))","v":0},null,":1",{"$f":"IF(D45>8,\"Warning!  You have exceeded the maximum acreage ratio of 8:1 for cropped adjacent lands. Please revise the red highlighted cells in Section I or obtain an approved waiver.\",\"\")","v":""}]
[]
[null,null,null,"B. Percent of Eligible Adjacent Non-Cropped Lands"]
[]
[null,null,null,{"$f":"IF((D22+D28)>0,D30/(D22+D28),0)","v":0},null,null,{"$f":"IF(D49>20%,\"Warning!  You have exceeded the maximum amount of adjacent non-cropped lands.  Please revise the red highlighted cells in Section I or obtain an approved waiver.\",\"\")","v":""}]
[]
[null,null,null,"C. Percent of Restorable Wetland Area"]
[]
[null,null,null,{"$f":"IF(D22>0,G20/D22,0)","v":0},null,null,{"$f":"IF(AND(D22>0,D53<50.000001%),\"Warning!  The majority of drained/altered wetland areas are not identified as being restorable. The application is not eligible for enrollment without changes or an approved waiver.\",IF(D53>100%,\"Warning!  The amount of estimated restorable wetland acres exceeds the amount of restorable wetland area\",0))","v":0}]

{"sheet":"Site Assessment Form","index":3,"n_rows":19,"n_cols":28,"rows_kept":19,"cut":false,"hidden":false,"merged":[[20,1,20,6],[15,8,15,12],[13,3,13,12],[16,3,16,12],[18,3,18,12],[19,3,19,12],[6,1,6,13],[8,1,8,13],[12,8,12,12],[10,8,10,12],[11,8,11,11],[5,5,5,8],[5,10,5,11],[1,1,1,5],[2,1,2,13],[3,1,3,13],[4,5,4,8],[4,10,4,11]]}
[]
[]
[null,"RIM Wetlands Program"]
[null,"Supplemental Site Assessment Form"]
[null,null,null,null,null,"Landowner Name",null,null,null,null,"County/SWCD Office"]
[]
[]
[]
[null,"Please check either Yes or No, and other appropriate boxes where requested. Provide answers to each question."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false,"PUBLIC DITCH","PRIVATE DITCH","LIFT STATION","PUBLIC TILE","PRIVATE TILE","DIVERSIONS OR LEVEES","FILL/SPOIL PLACEMENT","CROPPING/VEGETATION ALTERATION OF NATURAL WETLANDS","OTHER"]
[null,null,"1.",null,"Yes",null,"No",null,"Does the application area contain drained or altered wetlands? If yes, please check all applicable drainage or alteration methods and show their locations on supporting maps, when known.",null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($R$11=TRUE,$S$11=TRUE),\"Check either Yes OR No\",IF(AND(S11=TRUE,(OR(T11=TRUE,U11=TRUE,V11=TRUE,W11=TRUE,X11=TRUE,Y11=TRUE,Z11=TRUE,AA11=TRUE,AB11=TRUE))),\"Invalid answer: Do not check boxes for drained or altered wetlands if answer to question is No\",\"\"))","v":""}]
[null,null,"2.",null,"Yes",null,"No",null,"Are any of the identified drainage features in question 1 governed by known private drainage easements or agreements?  If yes, please explain and when possible, provide additional info.",null,null,null,null,null,null,null,null,false,false]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($R$13=TRUE,$S$13=TRUE),\"Check either Yes OR No\",\"\")","v":""}]
[null," ","3.",null,"Yes",null,"No",null,"Does the application area include wetlands that have been previously restored? If yes, please explain purpose or program in which the work was completed and indicate if design or construction plans might be available for review, if needed.",null,null,null,null,null,null,null,null,false,false]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($R$16=TRUE,$S$16=TRUE),\"Check either Yes OR No\",\"\")","v":""}]
[null,null,"4.","Describe any potential issues or construction constraints with restoring drained or altered wetlands within the application or project area (e.g., tile system from neighboring property enters proposed easement area, wetland restoration may hydrologically impact neighboring property, etc.)."]

{"sheet":"Scoresheet","index":4,"n_rows":70,"n_cols":34,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,16],[3,1,3,16],[4,3,4,15],[5,4,5,8],[5,9,5,14],[14,2,14,5],[14,9,14,10],[14,14,14,15],[6,4,6,8],[6,9,6,14],[7,2,7,6],[7,7,7,8],[7,9,7,12],[7,13,7,15],[8,3,8,9],[8,10,8,16],[9,9,9,13],[11,2,11,9],[12,12,12,15],[24,14,24,15],[16,2,24,4],[16,5,17,5],[16,9,16,10],[16,11,24,11],[16,13,24,13],[16,14,16,15],[17,9,17,10],[17,14,17,15],[18,9,24,10],[18,14,18,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[27,3,27,13],[28,2,28,5],[28,9,28,10],[30,2,36,4],[30,5,31,5],[30,9,30,10],[30,11,36,11],[31,9,31,10],[32,9,36,10],[37,14,37,15],[38,14,38,15],[39,2,39,9],[41,2,41,5],[41,7,47,7],[41,8,41,12],[42,2,42,5],[42,8,42,12],[43,2,43,4],[43,8,43,9],[44,2,44,4],[44,8,44,9],[45,2,45,4],[45,8,45,9],[46,2,46,4],[46,8,46,9],[62,3,62,14],[47,2,47,4],[47,8,47,9],[50,1,50,16],[51,1,51,16],[52,2,52,11],[54,2,54,8],[55,2,56,14],[58,2,58,9],[59,2,59,15],[60,3,60,14],[61,3,61,14],[71,1,71,4],[71,13,71,15],[74,10,74,12],[76,13,76,15],[64,25,65,25],[65,3,65,11],[65,12,65,14],[66,3,66,14],[67,3,67,14],[69,2,69,15],[63,3,64,11],[63,12,63,14],[63,22,65,22],[64,12,64,14],[64,23,65,23],[64,24,65,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2  "]
[null,"RIM WETLANDS PROGRAM"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,null,null,"Landowner Name",null,null,null,null,"County/SWCD Office"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Application Total Score  ",null,null,null,null,null,{"$f":"IF(P12=\"Error\",\"Error\",IF(P40=\"Error\",\"Error\",IF(P53=\"Error\",\"Error\",IF(P59=\"Error\",\"Error\",(P12+P40+P53+P59)))))","v":0}]
[]
[null,null,"A.  RESTORATION BENEFITS (maximum score capped at 50)",null,null,null,null,null,null,null,null,null,null,"Score  ",null,{"$f":"IF(AH18>0,\"Error\",IF(AD32>0,\"Error\",AE39))","v":0}]
[]
[]
[null,null,"Wetland Condition →",null,null,null,null," Effectively Drained","Partially Drained","Farmed Only",null,null,"Size of Largest Basin (acres)",null,"Total Grassland : Basin Ratio"]
[]
[null,null,"Restorable Depressional Wetlands (Basins)",null,null,"No. of Basins",null,"Check one","Check one","Check one",null,"AND","Check one","AND","Check one"]
[null,null,null,null,null,null,null,"(if applicable)","(if applicable)","(if applicable)",null,null,"(if applicable)",null,"(if applicable)",null,null,null,null,null,null,null,null,{"$f":"IF(X27>1,1,0)","v":0},null,{"$f":"IF(Z27>1,1,0)","v":0},null,{"$f":"IF(AB27>1,1,0)","v":0},null,{"$f":"IF(AD27>1,1,0)","v":0},null,{"$f":"IF(AF27>1,1,0)","v":0},null,{"$f":"SUM(X18,Z18,AB18,AD18,AF18)","v":0}]
[null,null,null,null,null,1,null,null,null,null,null,null," < 3",null,"  < 1:1",null,null,null,null,null,null,null,null,null,{"$f":"IF(X19=FALSE,0,10)","v":0},null,{"$f":"IF(Z19=FALSE,0,6)","v":0},null,{"$f":"IF(AB19=FALSE,0,4)","v":0},null,{"$f":"IF(AD19=FALSE,0,0)","v":0},null,{"$f":"IF(AF19=FALSE,0,0)","v":0}]
[null,null,null,null,null,2,null,null,null,null,null,null," 3-6",null,"  ≥ 1:1",null,null,null,null,null,null,null,null,null,{"$f":"IF(X20=FALSE,0,15)","v":0},null,{"$f":"IF(Z20=FALSE,0,10)","v":0},null,{"$f":"IF(AB20=FALSE,0,6)","v":0},null,{"$f":"IF(AD20=FALSE,0,7)","v":0},null,{"$f":"IF(AF20=FALSE,0,2)","v":0}]
[null,null,null,null,null,3,null,null,null,null,null,null," 6-10",null,"  ≥ 2:1",null,null,null,null,null,null,null,null,null,{"$f":"IF(X21=FALSE,0,20)","v":0},null,{"$f":"IF(Z21=FALSE,0,14)","v":0},null,{"$f":"IF(AB21=FALSE,0,8)","v":0},null,{"$f":"IF(AD21=FALSE,0,15)","v":0},null,{"$f":"IF(AF21=FALSE,0,3)","v":0}]
[null,null,null,null,null,4,null,null,null,null,null,null," 11-20",null,"  ≥ 3:1",null,null,null,null," ",null,null,null,null,{"$f":"IF(X22=FALSE,0,25)","v":0},null,{"$f":"IF(Z22=FALSE,0,17)","v":0},null,{"$f":"IF(AB22=FALSE,0,10)","v":0},null,{"$f":"IF(AD22=FALSE,0,20)","v":0},null,{"$f":"IF(AF22=FALSE,0,4)","v":0}]
[null,null,null,null,null,5,null,null,null,null,null,null," 21-30",null,"  ≥ 4:1",null,null,null,null,null,null,null,null,null,{"$f":"IF(X23=FALSE,0,30)","v":0},null,{"$f":"IF(Z23=FALSE,0,21)","v":0},null,{"$f":"IF(AB23=FALSE,0,12)","v":0},null,{"$f":"IF(AD23=FALSE,0,25)","v":0},null,{"$f":"IF(AF23=FALSE,0,6)","v":0}]
[null,null,null,null,null,6,null,null,null,null,null,null," > 30",null,"  ≥ 5:1",null,null,null,null,null,null,null,null,null,{"$f":"IF(X24=FALSE,0,35)","v":0},null,{"$f":"IF(Z24=FALSE,0,24)","v":0},null,{"$f":"IF(AB24=FALSE,0,14)","v":0},null,{"$f":"IF(AD24=FALSE,0,30)","v":0},null,{"$f":"IF(AF24=FALSE,0,8)","v":0}]
[null,null,null,null,null,"≥ 7",null,null,null,null,null,null,null,null,"  ≥ 6:1",null,null,null,null,null,null,null,null,null,{"$f":"IF(X25=FALSE,0,40)","v":0},null,{"$f":"IF(Z25=FALSE,0,28)","v":0},null,{"$f":"IF(AB25=FALSE,0,16)","v":0},null,null,null,{"$f":"IF(AF25=FALSE,0,10)","v":0}]
[]
[null,null,null,null,null,null,null,"AND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(X19:X25,\"TRUE\")","v":0},{"$f":"SUM(Y19:Y25)","v":0},{"$f":"COUNTIF(Z19:Z25,\"TRUE\")","v":0},{"$f":"SUM(AA19:AA25)","v":0},{"$f":"COUNTIF(AB19:AB25,\"TRUE\")","v":0},{"$f":"SUM(AC19:AC25)","v":0},{"$f":"COUNTIF(AD19:AD24,\"TRUE\")","v":0},{"$f":"SUM(AE19:AE24)","v":0},{"$f":"COUNTIF(AF19:AF25,\"TRUE\")","v":0},{"$f":"SUM(AG19:AG25)","v":0},{"$f":"(Y27+AA27+AC27+AE27+AG27)","v":0}]
[]
[null,null,"Wetland Condition →",null,null,null,null," Effectively Drained","Partially Drained","Farmed Only"]
[]
[null,null,"Restorable Non-Depressional  Wetlands",null,null,"Wetland Acres",null,"Check one","Check one","Check one"]
[null,null,null,null,null,null,null,"(if applicable)","(if applicable)","(if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X39>1,1,0)","v":0},null,{"$f":"IF(Z39>1,1,0)","v":0},null,{"$f":"IF(AB39>1,1,0)","v":0},null,{"$f":"SUM(X32,Z32,AB32)","v":0}]
[null,null,null,null,null,"< 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X33=FALSE,0,5)","v":0},null,{"$f":"IF(Z33=FALSE,0,3)","v":0},null,{"$f":"IF(AB33=FALSE,0,2)","v":0}]
[null,null,null,null,null,"10 - 40",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X34=FALSE,0,9)","v":0},null,{"$f":"IF(Z34=FALSE,0,6)","v":0},null,{"$f":"IF(AB34=FALSE,0,3)","v":0}]
[null,null,null,null,null,"41 - 80",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X35=FALSE,0,12)","v":0},null,{"$f":"IF(Z35=FALSE,0,8)","v":0},null,{"$f":"IF(AB35=FALSE,0,5)","v":0}]
[null,null,null,null,null,"81 - 120",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X36=FALSE,0,16)","v":0},null,{"$f":"IF(Z36=FALSE,0,11)","v":0},null,{"$f":"IF(AB36=FALSE,0,7)","v":0}]
[null,null,null,null,null,"≥ 121",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X37=FALSE,0,20)","v":0},null,{"$f":"IF(Z37=FALSE,0,14)","v":0},null,{"$f":"IF(AB37=FALSE,0,9)","v":0},null,"Total Score"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(X33:X37,\"TRUE\")","v":0},{"$f":"SUM(Y33:Y37)","v":0},{"$f":"COUNTIF(Z33:Z37,\"TRUE\")","v":0},{"$f":"SUM(AA33:AA37)","v":0},{"$f":"COUNTIF(AB33:AB37,\"TRUE\")","v":0},{"$f":"SUM(AC33:AC37)","v":0},{"$f":"(Y39+AA39+AC39)","v":0},{"$f":"IF(AD39+AH27>50,50,AD39+AH27)","v":0}]
[null,null,"B.  ECOLOGICAL/HABITAT BENEFITS (maximum score 20)",null,null,null,null,null,null,null,null,null,null,"Score  ",null,{"$f":"IF(X43>0,\"Error\",IF(Z43>0,\"Error\",AB49))","v":0}]
[]
[null,null,"Total Easement Acres",null,null,null,null,"AND","Acres of Permanent Habitat within 1.5 miles of the offered area"]
[null,null,"(Check one)",null,null,null,null,null,"(Check one)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X49>1,1,0)","v":0},null,{"$f":"IF(Z49>1,1,0)","v":0},null,{"$f":"SUM(X43,Z43)","v":0}]
[null,null,"≤ 40",null,null,null,null,null,"≤ 200",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X44=FALSE,0,0)","v":0},null,{"$f":"IF(Z44=FALSE,0,0)","v":0}]
[null,null,"41 - 80",null,null,null,null,null,"200 - 500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X45=FALSE,0,3)","v":0},null,{"$f":"IF(Z45=FALSE,0,3)","v":0}]
[null,null,"81 - 120",null,null,null,null,null,"501 - 1000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X46=FALSE,0,5)","v":0},null,{"$f":"IF(Z46=FALSE,0,5)","v":0}]
[null,null,"121 - 160",null,null,null,null,null,"1001 - 3000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X47=FALSE,0,8)","v":0},null,{"$f":"IF(Z47=FALSE,0,8)","v":0}]
[null,null,"> 160",null,null,null,null,null,"over 3000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X48=FALSE,0,10)","v":0},null,{"$f":"IF(Z48=FALSE,0,10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(X44:X48,\"TRUE\")","v":0},{"$f":"SUM(Y44:Y48)","v":0},{"$f":"COUNTIF(Z44:Z48,\"TRUE\")","v":0},{"$f":"SUM(AA44:AA48)","v":0},{"$f":"(Y49+AA49)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 2 of 2  "]
[null,"RIM WETLANDS PROGRAM"]
[null,"  ENVIRONMENTAL BENEFITS SCORING SHEET - Continued"]
[null,null,"C.  ADDITIONAL WILDLIFE BENEFITS (maximum score 20)",null,null,null,null,null,null,null,null,null,null,"Score  ",null,{"$f":"IF(AH53>1,\"Error\",AH56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(X56+Z56+AB56+AD56+AF56)","v":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,{"$f":"IF(X55=FALSE,0,0)","v":0},null,{"$f":"IF(Z55=FALSE,0,5)","v":0},null,{"$f":"IF(AB55=FALSE,0,10)","v":0},null,{"$f":"IF(AD55=FALSE,0,15)","v":0},null,{"$f":"IF(AF55=FALSE,0,20)","v":0}]
[null,null,"Determine score from Additional Wildlife Benefits GIS layer and check appropriate score box",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(X55,\"TRUE\")","v":0},{"$f":"Y55","v":0},{"$f":"COUNTIF(Z55,\"TRUE\")","v":0},{"$f":"AA55","v":0},{"$f":"COUNTIF(AB55,\"TRUE\")","v":0},{"$f":"AC55","v":0},{"$f":"COUNTIF(AD55,\"TRUE\")","v":0},{"$f":"AE55","v":0},{"$f":"COUNTIF(AF55,\"TRUE\")","v":0},{"$f":"AG55","v":0},{"$f":"(Y56+AA56+AC56+AE56+AG56)","v":0}]
[]
[]
[null,null,"D.  ADDITIONAL CONSIDERATIONS (maximum score 10)",null,null,null,null,null,null,null,null,null,null,"Score  ",null,{"$f":"IF(W64=TRUE,\"Error\",IF(Z70>10,10,Z70))","v":0}]
[null,null,"(Check all that Apply)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X60=FALSE,0,2)","v":0}]
[null,null,"1.","The majority of the area within the offer is within a Prairie Plan Core or Corridor Area.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X61=FALSE,0,2)","v":0},{"$f":"Y61","v":0}]
[null,null,"2.","The offered area is beneficial to, and within 1 mile of breeding/population of Federal or State listed Endangered or Threatened species as identified by DNR Natural Heritage Database (State Special Concern species shall not be considered). Federal species to be considered include Endangered, Threatened, and Candidate species, including designated critical habitat (e.g. Topeka shiner).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X62=FALSE,0,2)","v":0},{"$f":"Y62","v":0}]
[null,null,"3.","The offered area will provide a vegetated buffer to an adjacent DNR Public Water or designated aquatic management area, or the majority of runoff from the offered area drains to and is within 1 mile of DNR Public Waters or designated aquatic management areas.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X63=FALSE,0,2)","v":0},{"$f":"Y63","v":0}]
[null,null,"4.","Wetland restoration identified as either a high priority or priority restoration and protection strategy in 1W1P report or comprehensive management plan. List document name and page number of approved or draft plan below.",null,null,null,null,null,null,null,null,"High Priority",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(X64=TRUE,X65=TRUE),TRUE,FALSE)","v":false},null,{"$f":"IF(X64=FALSE,0,4)","v":0},{"$f":"Y64","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR",null,null,null,null,null,null,null,null,{"$f":"IF(X65=FALSE,0,2)","v":0},{"$f":"Y65","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Priority"]
[null,null,"5.","The predominant soils (more than 50%) within the offered area are Highly Erodible Land (HEL) or Partially Highly Erodible Land (PHEL).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X67=FALSE,0,1)","v":0},{"$f":"Y67","v":0}]
[null,null,"6.","Linear corridor connectivity along watercourses - Permanently protected land (fee title or easement) is on one or both ends of the offer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X68=FALSE,0,2)","v":0},{"$f":"Y68","v":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,{"$f":"SUM(Z61,Z62,Z63,Z64,Z65,Z67,Z68)","v":0}]

{"sheet":"List_SWCD","index":5,"n_rows":92,"n_cols":2,"rows_kept":92,"cut":false,"hidden":true,"merged":[]}
["SWCD_CODE","SWCD_DESC"]
["01","Aitkin"]
["02","Anoka"]
["03","Becker"]
["04","Beltrami"]
["05","Benton"]
["06","Big Stone"]
["07","Blue Earth"]
["08","Brown"]
["09","Carlton"]
["10","Carver"]
["11","Cass"]
["12","Chippewa"]
["13","Chisago"]
["14","Clay"]
["15","Clearwater"]
["16","Cook"]
["17","Cottonwood"]
["18","Crow Wing"]
["19","Dakota"]
["20","Dodge"]
["21","Douglas"]
["22","Faribault"]
["23","Fillmore"]
["24","Freeborn"]
["25","Goodhue"]
["26","Grant"]
["27","Hennepin"]
["28","Root River"]
["29","Hubbard"]
["30","Isanti"]
["31","Itasca"]
["32","Jackson"]
["33","Kanabec"]
["34","Kandiyohi"]
["35","Kittson"]
["36","Koochiching"]
["37","Lac Qui Parle"]
["38","Lake"]
["39","Lake of the Woods"]
["40","Le Sueur"]
["41","Lincoln"]
["42","Lyon"]
["43","McLeod"]
["44","Mahnomen"]
["45","Marshall"]
["45MB","Marshall Beltrami"]
["46","Martin"]
["47","Meeker"]
["48","Mille Lacs"]
["49","Morrison"]
["50","Mower"]
["51","Murray"]
["52","Nicollet"]
["53","Nobles"]
["54","Norman"]
["55","Olmsted"]
["56EOT","East Ottertail"]
["56WOT","West Ottertail"]
["57","Pennington"]
["58","Pine"]
["59","Pipestone"]
["60EP","East Polk"]
["60WP","West Polk"]
["61","Pope"]
["62","Ramsey"]
["63","Red Lake"]
["64","Redwood"]
["65","Renville"]
["66","Rice"]
["67","Rock"]
["68","Roseau"]
["69NSL","North St. Louis"]
["69SSL","South St. Louis"]
["70","Scott"]
["71","Sherburne"]
["72","Sibley"]
["73","Stearns"]
["74","Steele"]
["75","Stevens"]
["76","Swift"]
["77","Todd"]
["78","Traverse"]
["79","Wabasha"]
["80","Wadena"]
["81","Waseca"]
["82","Washington"]
["83","Watonwan"]
["84","Wilkin"]
["85","Winona"]
["86","Wright"]
["87","Yellow Medicine"]