{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Working Lands Scoresheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Working Lands Scoresheet","index":0,"n_rows":78,"n_cols":29,"rows_kept":78,"cut":false,"hidden":false,"merged":[[3,1,3,15],[13,5,13,13],[14,5,14,13],[7,9,7,13],[6,4,6,8],[6,9,6,13],[7,4,7,8],[4,1,4,15],[9,11,9,13],[11,3,11,11],[16,3,16,10],[20,3,20,11],[24,3,25,11],[31,4,31,5],[45,3,45,6],[34,3,34,6],[34,7,37,11],[29,7,32,12],[42,3,42,8],[59,8,63,12],[67,17,68,19],[65,3,66,10],[26,17,27,20],[29,3,29,6],[50,3,50,6],[46,3,46,9],[59,3,59,7],[50,7,52,11],[54,7,57,12],[47,3,47,9],[77,1,77,5],[75,3,75,8],[73,3,74,8],[75,11,75,13],[72,2,72,14],[73,11,74,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2  "]
[]
[null,"RIM WORKING LANDS"]
[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,null,null,"Total Score",null,null,{"$f":"IF(O12=\"Error\",\"Error\",IF(O17=\"Error\",\"Error\",IF(O21=\"Error\",\"Error\",IF(O25=\"Error\",\"Error\",IF(O30=\"Error\",\"Error\",IF(O35=\"Error\",\"Error\",IF(O43=\"Error\",\"Error\",IF(O47=\"Error\",\"Error\",IF(O51=\"Error\",\"Error\",IF(O55=\"Error\",\"Error\",IF(O60=\"Error\",\"Error\",IF(O66=\"Error\",\"Error\",SUM(O12,O17,O21,O25,O30,O35,O43,O47,O51,O55,O60,O66)))))))))))))","v":0}]
[]
[null,null,"1.","APPROVED GRAZING PLAN  (maximum score 15)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(W16>1,\"Error\",X16)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","Approved and fully implemented grazing plan or recently expired EQIP contract  (15 pts)",null,null,null,null,null,null,null,null,null,null,null,"CERTIFIED GRAZING PLAN",null,null,null,"a",null,{"$f":"IF(W13 = \"\",\"\",IF(W13=TRUE,15,0))","v":""}]
[null,null,null,null,"b.","Approved and partially implemented grazing plan or applied for EQIP and not funded  (10 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W14 = \"\",\"\",IF(W14=TRUE,10,0))","v":""}]
[null,null,null,null,"c.","Approved but not implemented grazing plan  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",null,{"$f":"IF(W15 = \"\",\"\",IF(W15=TRUE,5,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W13:W15, TRUE)","v":0},{"$f":"IF(AND(X13=\"\",X14=\"\",X15=\"\"),\"\",SUM(X13:X15))","v":""},"Score sum"]
[null,null,"2.","SIZE OF OFFER  (maximum score 10)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(W20>1,\"Error\",X20)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","> 320 acres  (10 pts)",null,null,null,null,null,null,null,null,null,null,null,"SIZE OF OFFER",null,null,null,"a",null,{"$f":"IF(W18 = \"\",\"\",IF(W18=TRUE,10,0))","v":""}]
[null,null,null,null,"b.","150 – 320 acres  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W19 = \"\",\"\",IF(W19=TRUE,5,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W18:W19, TRUE)","v":0},{"$f":"IF(AND(X18=\"\",X19=\"\"),\"\",SUM(X18:X19))","v":""},"Score sum"]
[null,null,"3.","ADJACENT TO PERMANENTLY PROTECTED LAND  (maximum score 5)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(W24>1,\"Error\",X24)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","Yes  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,"ADJACENT TO PERMANENTLY PROTECTED LAND",null,null,null,"a",null,{"$f":"IF(W22 = \"\",\"\",IF(W22=TRUE,5,0))","v":""}]
[null,null,null,null,"b.","No  (0 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W23 = \"\",\"\",IF(W23=TRUE,0,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W22:W23, TRUE)","v":0},{"$f":"IF(AND(X22=\"\",X23=\"\"),\"\",SUM(X22:X23))","v":""},"Score sum"]
[null,null,"4.","LANDOWNER ENROLLED IN AG WATER QUALITY CERTIFICATION PROGRAM  (maximum score 5)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(W29>1,\"Error\",X29)","v":""}]
[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,"a.","Yes  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,"LANDOWNER ENROLLED IN AG WATER QUALITY CERTIFICATION PROGRAM",null,null,null,"a",null,{"$f":"IF(W27 = \"\",\"\",IF(W27=TRUE,5,0))","v":""}]
[null,null,null,null,"b.","No  (0 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W28 = \"\",\"\",IF(W28=TRUE,0,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W27:W28, TRUE)","v":0},{"$f":"IF(AND(X27=\"\",X28=\"\"),\"\",SUM(X27:X28))","v":""},"Score sum"]
[null,null,"5.","SHORELINE LINEAR FEET:",null,null,null,"Total shoreline length of lakes, rivers, or public ditches in linear feet. Includes both sides of the watercourse/waterbody. One point per 660 ft.  (maximum score 10)",null,null,null,null,null,"Score",{"$f":"IF(E32=\"\",\"\",IF(AND(E32>=660,E32<1320),1,IF(AND(E32>=1320,E32<1980),2,IF(AND(E32>=1980,E32<2640),3,IF(AND(E32>=2640,E32<3300),4,IF(AND(E32>=3300,E32<3960),5,IF(AND(E32>=3960,E32<4620),6,IF(AND(E32>=4620,E32<5280),7,IF(AND(E32>=5280,E32<5940),8,IF(AND(E32>=5940,E32<6600),9,IF(E32>=6600,10,0)))))))))))","v":""}]
[]
[]
[]
[]
[null,null,"6.","CROPLAND CONVERSION:",null,null,null,"Percent of offer converted from cropland to grassland/silvopasture in the last 5 years or will be converted upon easement completion  (maximum score 16)",null,null,null,null,null,"Score",{"$f":"IF(W40>1,\"Error\",X40)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","76–100%  (16 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W36 = \"\",\"\",IF(W36=TRUE,16,0))","v":""}]
[null,null,null,null,"b.","51–75%  (12 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W37 = \"\",\"\",IF(W37=TRUE,12,0))","v":""}]
[null,null,null,null,"c.","26–50%  (8 pts)",null,null,null,null,null,null,null,null,null,null,null,"CROPLAND CONVERSION",null,null,null,"c",null,{"$f":"IF(W38 = \"\",\"\",IF(W38=TRUE,8,0))","v":""}]
[null,null,null,null,"d.","0–25%  (4 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",null,{"$f":"IF(W39 = \"\",\"\",IF(W39=TRUE,4,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W36:W39, TRUE)","v":0},{"$f":"IF(AND(X36=\"\",X37=\"\",X38=\"\",X39=\"\"),\"\",SUM(X36:X39))","v":""},"Score sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 2 of 2  "]
[]
[null,null,"7.","HABITAT SCORE (maximum score 10)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(W46>1,\"Error\",X46)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","> 50% of offered area has high rank in Wildlife Action Network or within Important Bird Area  (10 pts)",null,null,null,null,null,null,null,null,null,null,null,"HABITAT SCORE",null,null,null,null,null,{"$f":"IF(W44 = \"\",\"\",IF(W44=TRUE,10,0))","v":""}]
[null,null,null,null,"b.","> 50% of offered area has medium high rank in Wildlife Action Network  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W45 = \"\",\"\",IF(W45=TRUE,5,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W44:W45, TRUE)","v":0},{"$f":"IF(AND(X44=\"\",X45=\"\"),\"\",SUM(X44:X45))","v":""},"Score sum"]
[null,null,"8.","ADDITIONAL WILDLIFE BENEFITS (maximum score 20)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(AB49>1,\"Error\",AB48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL WILDLIFE BENEFITS",null,null,null,"Score",{"$f":"IF(W49=\"\",\"\",IF(W49=TRUE,0,0))","v":""},{"$f":"IF(X49=\"\",\"\",IF(X49=TRUE,5,0))","v":""},{"$f":"IF(Y49=\"\",\"\",IF(Y49=TRUE,10,0))","v":""},{"$f":"IF(Z49=\"\",\"\",IF(Z49=TRUE,15,0))","v":""},{"$f":"IF(AA49=\"\",\"\",IF(AA49=TRUE,20,0))","v":""},{"$f":"IF(AND(W48=\"\",X48=\"\",Y48=\"\",Z48=\"\",AA48=\"\"),\"\",SUM(W48:AA48))","v":""},"Score"]
[null,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,"true/false",null,null,null,null,null,{"$f":"COUNTIF(W49:AA49, TRUE)","v":0},"Count True"]
[]
[null,null,"9","ALTERNATE WATERSOURCE:",null,null,null,"Another water source available other than natural watercourse/waterbody (maximum score 5)",null,null,null,null,null,"Score",{"$f":"IF(W54>1,\"Error\",X54)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","Yes  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,"ALTERNATE WATERSOURCE",null,null,null,"a",null,{"$f":"IF(W52 = \"\",\"\",IF(W52=TRUE,5,0))","v":""}]
[null,null,null,null,"b.","No  (0 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W53 = \"\",\"\",IF(W53=TRUE,0,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W52:W53, TRUE)","v":0},{"$f":"IF(AND(X52=\"\",X53=\"\"),\"\",SUM(X52:X53))","v":""},"Score sum"]
[null,null,"10","WELLHEAD PROTECTION:",null,null,null,"> 50% of offered area ranked Very High (VH) or High (H) Vulnerability within Drinking Water Supply Management Area Vulnerability (maximum score 10)",null,null,null,null,null,"Score",{"$f":"IF(W58>1,\"Error\",X58)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","Yes  (10 pts)",null,null,null,null,null,null,null,null,null,null,null,"WELLHEAD PROTECTION",null,null,null,"a",null,{"$f":"IF(W56 = \"\",\"\",IF(W56=TRUE,10,0))","v":""}]
[null,null,null,null,"b.","No  (0 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W57 = \"\",\"\",IF(W57=TRUE,0,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W56:W57, TRUE)","v":0},{"$f":"IF(AND(X56=\"\",X57=\"\"),\"\",SUM(X56:X57))","v":""},"Score sum"]
[]
[null,null,"11","TOTAL MAXIMUM DAILY LOAD:",null,null,null,null,"Implementation of grazing plan will address water quality concerns for conventional pollutants identified in the TMDL. Must be within 1/4 mile of listed water or tributary. (maximum score 5)",null,null,null,null,"Score",{"$f":"IF(W63>1,\"Error\",X63)","v":""},null,null,null,null,null,null,null,"true/false","Score"]
[null,null,null,null,"a.","Yes  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,"TMDL",null,null,null,"a",null,{"$f":"IF(W61 = \"\",\"\",IF(W61=TRUE,5,0))","v":""}]
[null,null,null,null,"b.","No  (0 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W62 = \"\",\"\",IF(W62=TRUE,0,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W61:W62, TRUE)","v":0},{"$f":"IF(AND(X61=\"\",X62=\"\"),\"\",SUM(X61:X62))","v":""},"Score sum"]
[]
[]
[null,null,"12","GRAZING SITE LISTED AS PRIORITY IN 1W1P/WATER PLAN  (maximum score 5)",null,null,null,null,null,null,null,null,null,"Score",{"$f":"IF(W70>1,\"Error\",X70)","v":""}]
[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,"a.","Yes  (5 pts)",null,null,null,null,null,null,null,null,null,null,null,"1W1P/WATER PLAN PRIORITY OR WATERSHED RISK CLASS",null,null,null,"a",null,{"$f":"IF(W68 = \"\",\"\",IF(W68=TRUE,5,0))","v":""}]
[null,null,null,null,"b.","No  (0 pts)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W69 = \"\",\"\",IF(W69=TRUE,0,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count True",{"$f":"COUNTIF(W68:W69, TRUE)","v":0},{"$f":"IF(AND(X68=\"\",X69=\"\"),\"\",SUM(X68:X69))","v":""},"Score sum"]
[]
[null,null,"APPLICATION FUNDING ACKNOWLEDGEMENT"]
[null,null,"I attest that this application has been reviewed by the program technical committee and selected for funding."]
[]
[]
[null,null,null,"BWSR Program Staff Signature",null,null,null,null,null,null,null,"Date"]
[]
[null,"2023-06-29"]