{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions - Menu","App Checklist","Application Form","Program Eligibility Form","CRP Data","CEFW","CP2 Scoring","CP21 Scoring","CP23 Scoring","CP23a Scoring","Questionnaire & Assessment","Min Size Waiver","AppUploadTemplate","ApplicationQuestion","ApplicationPractice","Lists"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":17,"comments":6,"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":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[34,15,36,20],[35,8,35,12],[34,8,34,12],[12,2,12,12],[23,2,23,6],[26,2,26,6],[27,2,27,6],[22,2,22,6],[13,2,13,12],[14,2,14,12],[1,1,1,2],[2,2,2,12],[6,2,6,13],[3,2,3,12],[10,2,11,12],[8,2,8,12],[4,6,4,8],[39,1,39,3],[20,2,20,6],[19,2,19,6],[19,8,19,12],[20,8,20,12],[37,2,37,6]]}
[]
[]
[null,null,"RIM MN-CREP Workbook"]
[null,null," Application Documents File"]
[null,null,null,null,null,null,"EasApp_v07"]
[null,null,"Instructions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Additional Information:"]
[]
[]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"App Checklist","index":1,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[20,3,20,10],[21,3,21,10],[22,3,22,10],[24,3,24,10],[33,3,33,10],[28,3,28,10],[29,3,29,10],[30,3,30,10],[32,3,32,10],[52,1,52,4],[51,2,51,10],[1,1,1,3],[13,3,13,9],[14,3,14,9],[18,3,18,10],[19,3,19,10],[2,1,2,10],[3,1,3,10],[7,1,7,10],[6,3,6,7],[6,8,6,9],[5,3,5,7],[5,8,5,9],[25,3,25,10],[26,2,26,10]]}
[]
[]
[null,"RIM MN-CREP Workbook"]
[null," Application Checklist"]
[]
[null,null,null,"Landowner Name:",null,null,null,null,"County/SWCD Office:"]
[null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[null,"REQUIRED FORMS AND DOCUMENTS FOR ALL APPLICATIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,"Score Sheets:",null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
[null,null,null,"(Note: All forms listed above can be found in this workbook)"]
[]
[null,"AIR PHOTO AND/OR MAP DOCUMENTATION"]
[null,null,"ALL APPLICATIONS—Aerial photo displaying each of the following (suggested map groupings provided)"]
[null,null,null,"Map 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Map 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"APPLICATIONS WITH CP-23 AND/OR CP-23a—additional documentation:"]
[null,null,null,"Map 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Map 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"OWNERSHIP AND ELIGIBILITY DOCUMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,"SHAPEFILE OF EASEMENT BOUNDARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,"AGREEMENT INFORMATION FORM FOR CONSERVATION EASEMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"W-9 IRS FORM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"Other Information/Comments:"]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"Application Form","index":2,"n_rows":43,"n_cols":37,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,1,42,9],[39,3,39,13],[39,17,39,20],[23,8,23,11],[32,3,32,21],[36,2,36,15],[37,3,37,21],[31,2,31,13],[25,2,25,21],[11,2,11,8],[16,15,16,18],[15,15,15,18],[11,16,11,21],[11,13,11,15],[8,16,8,19],[9,13,9,15],[4,11,4,18],[7,15,7,18],[6,15,6,18],[6,19,6,21],[7,19,7,21],[23,32,23,36],[18,19,19,21],[21,19,22,21],[18,17,19,18],[21,17,22,18],[3,20,3,21],[2,20,2,21],[34,3,34,13],[34,17,34,20],[14,15,14,18],[13,13,13,14],[28,2,28,21],[29,2,29,21],[1,11,2,18],[3,10,3,18],[9,2,9,12],[4,3,4,9],[8,2,8,12],[7,2,7,10],[7,11,7,14],[9,16,9,19],[6,2,6,10],[6,11,6,14],[8,13,8,15],[18,2,19,5],[18,6,19,10],[17,4,17,12],[15,2,15,11],[16,2,16,11],[13,15,13,18],[10,9,10,12],[11,9,11,12],[10,16,10,21],[10,13,10,15],[13,2,13,11],[14,2,14,11],[10,2,10,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"STATE OF MINNESOTA"]
[]
[null,null,null,null,null,null,null,null,null,null,"CONSERVATION EASEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,"Application Form"]
[]
[null,null,"Landowner First Name",null,null,null,null,null,null,null,null,"Landowner Last Name/Business*",null,null,null,"Spouse's Name (if married)",null,null,null,"County/Field Office*"]
[]
[null,null,"Complete Mailing Address (Street, RFD, Box No.)*",null,null,null,null,null,null,null,null,null,null,"Attention",null,null,"City*",null,null,null,"State*","Zip Code*"]
[]
[null,null,"Phone Number (Home)",null,null,null,null,null,null,"Phone Number (Work)",null,null,null,"Phone Number (Cell)",null,null,"E-Mail Address"]
[]
[]
[null,null,"Project Name (if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,"Township 1 Name*",null,null,null,"Sect*","TWP*","Range*"]
[]
[null,null,"LSOHC Planning Unit",null,null,null,null,null,null,null,null,null,null,null,null,"Township 2 Name: (if applicable)",null,null,null,"Sect","TWP","Range"]
[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,null,"LSOHC PLANNING UNIT"]
[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,null,"Forest/Prairie Transition"]
[null,null,{"$f":"IF(ISBLANK('CRP Data'!L35),\"\",'CRP Data'!L35)","v":""},null,null,null,"Easement Type*",null,null,null,null,null,null,null,null,null,null,"Total Easement Acres†",null,{"$f":"IF(ISBLANK(CEFW!F21),\"\",CEFW!F21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metropolitan Urbanizing Area"]
[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,null,"Northern Forest"]
[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,null,"Prairie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Easement Payment†",null,{"$f":"IF(ISBLANK(CEFW!J49),\"\",CEFW!J49)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southeast Forest"]
[]
[]
[]
[]
[]
[null,null,"TERMS AND CONDITIONS"]
[null,null,"The purpose of this application is to authorize and collect information necessary to make a preliminary determination of eligibility and acceptance for lands being offered  for a conservation easement. This application is not a binding contract on any of the involved parties. By signing, the applicant agrees to grant employees and/or agents of the state of Minnesota permission to visit and evaluate the property proposed for enrollment and to provide all requested information relating to land use and ownership."]
[null,null,"Tennessen Warning Notice - If this application is accepted for program enrollment,  social security  numbers or tax identification numbers for all identified owners of the easement property will need to be provided. Social security numbers are private data under the Minnesota Government Data Practices Act. Private data on individuals is not available to the public, but is available to other persons or entities authorized by law to receive the data. Upon making any easement payments associated  with this application, social security numbers of payment recipients may be provided to the commissioner of revenue for purposes of tax administration and to the commissioner of finance for the issuance of 1099 tax forms.  "]
[]
[null,null,"LANDOWNER ACKNOWLEDGMENT "]
[null,null,null,"I, the landowner, attest that I have read and understand the Tennessen Warning Notice. Further, I attest that to the best of my knowledge, I have truthfully answered all questions asked and provided all information requested as part of this application for a conservation easement. I also understand that the applied for conservation easement cannot be secured on any lands containing contaminants, pollutants, hazardous substances or unsealed abandoned wells unless the identified environmental problems are properly cleaned up and abandoned wells are properly sealed at my expense. I understand that both an approved CRP Contract and recorded RIM Easement are necessary in order to receive the offered payment. I understand that federal payment limitations may apply to any expected annual contract payments or incentive payments from the USDA. The RIM payment assumes the landowner will receive the full amount of annual CRP contract payments and CRP incentive payments as shown on the CRP-1 document, and it is the responsibility of any landowner(s) to confer with the USDA-Farm Service Agency and to understand potential financial impacts if a payment limitation applies."]
[]
[null,null,null,"Landowner Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,"SWCD/LGU ACKNOWLEDGMENT"]
[null,null,null,"I attest that to the best of my knowledge, the information in this landowner application for enrollment and other required associated application forms are accurate and that the landowner and said preliminary easement application and area meets eligibility requirements of the identified program(s)."]
[]
[null,null,null,"SWCD/LGU Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"Program Eligibility Form","index":3,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,1,3],[42,11,42,12],[8,1,8,13],[2,1,2,13],[4,1,4,13],[7,4,7,8],[6,9,6,11],[7,9,7,11],[6,4,6,8],[12,5,12,12],[14,5,14,12],[23,7,23,9],[18,7,19,11],[37,7,37,11],[20,3,21,12],[13,7,13,12],[53,1,53,5],[47,3,47,11],[43,3,44,12],[10,3,11,12],[29,3,31,12],[33,7,33,9],[39,3,40,12],[15,3,16,11],[51,3,51,12],[46,6,46,10],[49,7,49,11]]}
[]
[]
[null,"RIM MN-CREP Workbook"]
[]
[null,"Program Eligibility Form"]
[]
[null,null,null,null,"Landowner Name:",null,null,null,null,"County/SWCD Office:"]
[null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[]
[null,null,"1.","Is landowner (MS 103F.511 Subd.6) required to be certified by the MN Department of Agriculture (MDA) before engaging in farming or having an interest in agricultural land?"]
[]
[]
[]
[]
[null,null,null,"If yes, has the landowner obtained certification and has the SWCD verified certification using the MDA Corporate Farm Lookup website?"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(AND(R14=TRUE,S19=TRUE),\"Offer cannot proceed until certification is received. Ineligible for RIM MN-CREP if unable to obtain certification.\",\"\")","v":""}]
[]
[null,null,"2.","Has the land been owned by the landowner, or a parent or other blood relative of the landowner, for at least one year before the date of application? (MS 103F.515, Subd. 2, (c), (1))"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF($S$24=TRUE,\"Ineligible for RIM MN-CREP\",\"\")","v":""}]
[]
[null,null,null,"Check the box below that best describes the current property ownership: "]
[]
[]
[]
[null,null,"3.","Has all land included in the CRP offer been in agricultural crop production for at least two of the past five years before the date of application, or does it meet one of the other requirements as listed in MN Rules section 8400.3030?"]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF($S$34=TRUE,\"Ineligible for RIM MN-CREP\",\"\")","v":""}]
[]
[null,null,"4.","Is the offer greater than or equal to 8 acres in size?"]
[]
[null,null,null,null,null,null,null,{"$f":"IF($S$38=TRUE,\"Ineligible for RIM MN-CREP unless waiver granted\",\"\")","v":""}]
[]
[null,null,null,"Click on \"Minimum Size Waiver\" button below to review criteria and fill out the waiver, if applicable."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"CRP Data","index":4,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,9,9,14],[12,5,12,9],[23,5,23,6],[24,5,24,6],[24,9,24,10],[25,9,25,10],[27,9,29,12],[23,9,23,10],[45,5,45,7],[38,8,38,9],[35,8,35,9],[39,11,39,13],[35,5,35,7],[36,5,36,7],[37,5,37,7],[33,8,33,9],[34,8,34,9],[34,11,34,12],[33,11,33,12],[28,3,28,8],[29,3,29,8],[16,3,16,4],[16,5,16,6],[16,7,16,8],[47,5,48,7],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[19,12,19,13],[20,12,20,13],[22,9,22,10],[22,12,22,13],[34,13,34,14],[42,1,42,4],[38,11,38,12],[43,3,43,14],[25,12,25,13],[24,12,24,13],[26,12,26,13],[39,8,39,9],[39,5,39,7],[40,5,40,7],[40,11,40,12],[36,8,36,9],[37,8,37,9],[38,5,38,7],[16,9,16,10],[26,9,26,10],[17,3,17,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[17,9,17,10],[25,7,25,8],[26,7,26,8],[26,5,26,6],[19,5,19,6],[10,16,11,18],[13,16,14,18],[25,5,25,6],[17,5,17,6],[22,5,22,6],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[17,7,17,8],[20,9,20,10],[21,12,21,13],[11,6,11,7],[10,5,10,10],[15,3,15,6],[11,9,11,10],[23,12,23,13],[21,9,21,10],[24,7,24,8],[23,7,23,8],[17,12,17,13],[18,12,18,13],[13,12,14,15],[7,4,7,13],[6,4,6,8],[6,9,6,13],[2,1,2,15],[3,1,3,15],[5,4,5,8],[5,9,5,13],[33,5,33,7],[34,5,34,7],[10,3,10,4],[11,3,11,4],[13,3,13,4],[14,3,14,4],[13,5,13,8],[14,5,14,8],[13,9,13,11],[14,9,14,11],[16,12,16,14],[10,12,11,13],[20,5,20,6],[21,5,21,6],[18,5,18,6],[18,9,18,10],[19,9,19,10]]}
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]
[null,"RIM MN-CREP Workbook"]
[null,"CRP Data"]
[]
[null,null,null,null,"Landowner Name:",null,null,null,null,"County/SWCD Office:"]
[null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[null,null,null,null,"*Information entered on this worksheet MUST be taken directly from a CRP-1 Conservation Reserve Program Contract that has been signed and dated by the participant in section 12.A (4)"]
[null,null,null,"CRP-1  CONSERVATION RESERVE PROGRAM CONTRACT"]
[]
[null,null,null,"4. ACRES FOR ENROLLMENT*",null,"9. CONTRACT PERIOD (MM-DD-YYYY)*",null,null,null,null,null,null,"CRP-SIP Ineligible: Total",null,null,null,null,null,null,"Full CRP-SIP Exception",null,null,"Contract Length"]
[null,null,null,null,null,"FROM:",null,null,"TO:",null,null,{"$f":"IF(W12=\"<14\",\"<14 years\",IF(W12=\">15\",\">15 years\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(G12),ISBLANK(J12)),\"\",IF(DATEDIF(G12,J12,\"d\")<5112,\"<14\",IF(DATEDIF(G12,J12,\"d\")>5478,\">15\",IF(OR(DATEDIF(G12,J12,\"d\")=5477,DATEDIF(G12,J12,\"d\")=5478),15,IF(OR(DATEDIF(G12,J12,\"d\")=5112,DATEDIF(G12,J12,\"d\")=5113),14,IF(AND(DATEDIF(G12,J12,\"d\")>5113,DATEDIF(G12,J12,\"d\")<5477),\"14+\",\"ERROR\"))))))","v":""}]
[]
[null,null,null,"10.A. RENTAL RATE PER ACRE",null,"10.B. ANNUAL CONTRACT PAYMENT*",null,null,null,"10.C. FIRST YEAR PAYMENT",null,null,null,null,null,null,null,null,null,"First year > Annual payment",null,null,"1st year payment required"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(ISBLANK(F15)),NOT(ISBLANK(J15)),J15>F15),TRUE,FALSE)","v":false},null,null,{"$f":"IF(AND(W12 =\"14+\",ISBLANK(J15)),\"TRUE\",\"FALSE\")","v":"FALSE"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W15=\"TRUE\",NOT(ISBLANK(F15)),ISBLANK(J15)),\"REQUIRED\",\"\")","v":""}]
[null,null,null,"11.A. Tract No.",null,"11.B. Field No.",null,"11.C. Practice No.*",null,"11.D. Acres*",null,null,"CRP-SIP Ineligible: Partial",null,null,null,null,null,null,"Partial CRP-SIP Exception",null,null,"CRP Practice No."]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible",null,null,null,null,null,null,null,null,null,"CP2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible",null,null,null,null,null,null,null,null,null,"CP21"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible",null,null,null,null,null,null,null,null,null,"CP23"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible",null,null,null,null,null,null,null,null,null,"CP23a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIP Ineligible"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(E35:E38)<>0,SUM(E35:E38)<>D12),\"Sum of acres in 11.D does not match acres entered in 4. ACRES FOR ENROLLMENT\",\"\")","v":""}]
[null,null,null,"12.A (4) Participant's CRP-1 Signature Date (MM-DD-YYYY)*"]
[]
[]
[null,null,null,"CRP ACRES AND PAYMENT TOTALS"]
[]
[null,null,null,"Practice Number","Acres","Total of CRP Contract Payments",null,null,"Sign-up Incentive Payment (SIP)",null,null,"Primary Practice Number"]
[null,null,null,"CP2",{"$f":"SUMIF(H18:I27,\"CP2\",J18:K27)","v":0},{"$f":"IF(OR(ISBLANK(D12),ISBLANK(E35),D12=0),\"\",E35/$D$12*$F$39)","v":""},null,null,{"$f":"IF(T12=TRUE,\"\",0)","v":0},null,null,{"$f":"IF(AND(SUM(E35:E38)<>0,COUNTIF(E35:E38,MAX(E35:E38))>1),\"ERROR\",IF(COUNTA(J18:K27)<>0,INDEX(D35:D38,MATCH(MAX(E35:E38),E35:E38,0),0),\"\"))","v":""}]
[null,null,null,"CP21",{"$f":"SUMIF(H18:I27,\"CP21\",J18:K27)","v":0},{"$f":"IF(OR(ISBLANK(D12),ISBLANK(E36),D12=0),\"\",E36/$D$12*$F$39)","v":""},null,null,{"$f":"IF(T12=TRUE,\"\",SUMIFS(J18:J27,H18:H27,\"CP21\",T18:T27,\"<>TRUE\")*100)","v":0}]
[null,null,null,"CP23",{"$f":"SUMIF(H18:I27,\"CP23\",J18:K27)","v":0},{"$f":"IF(OR(ISBLANK(D12),ISBLANK(E37),D12=0),\"\",E37/$D$12*$F$39)","v":""},null,null,{"$f":"IF(T12=TRUE,\"\",SUMIFS(J18:J27,H18:H27,\"CP23\",T18:T27,\"<>TRUE\")*150)","v":0}]
[null,null,null,"CP23a",{"$f":"SUMIF(H18:I27,\"CP23a\",J18:K27)","v":0},{"$f":"IF(OR(ISBLANK(D12),ISBLANK(E38),D12=0),\"\",E38/$D$12*$F$39)","v":""},null,null,{"$f":"IF(T12=TRUE,\"\",SUMIFS(J18:J27,H18:H27,\"CP23a\",T18:T27,\"<>TRUE\")*150)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E35:E38)","v":0},{"$f":"IF(OR(ISBLANK(G12),ISBLANK(J12),ISBLANK(F15)),0,IF(W12=15,F15*15,IF(W12=14,F15*14,IF(AND(W12=\"14+\",ISBLANK(J15)),0,IF(W12=14,F15*14,IF(W12=\"14+\",(F15*14)+J15))))))","v":0},null,null,{"$f":"SUM(I35:J38)","v":0},null,null,{"$f":"IF(OR(ISBLANK(G12),ISBLANK(J12),ISBLANK(F15)),0,IF(W12=15,F15*15,IF(W12=14,F15*14,IF(AND(W12=\"14+\",ISBLANK(J15)),0,IF(W12=14,F15*14,IF(W12=\"14+\",(F15*14)+J15)))))+I39)","v":0}]
[null,null,null,null,null,"Contract Payment       +",null,null,"SIP",null,"=","Total CRP Payment"]
[]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"CEFW","index":5,"n_rows":57,"n_cols":31,"rows_kept":57,"cut":false,"hidden":false,"merged":[[23,20,23,27],[11,20,11,23],[15,20,15,26],[27,2,27,6],[29,3,29,7],[22,2,25,4],[22,7,22,9],[22,13,22,15],[24,5,25,18],[5,4,5,10],[5,11,5,15],[11,2,11,4],[13,2,13,4],[15,2,15,4],[7,5,7,9],[7,11,7,15],[8,5,8,9],[8,11,8,15],[8,2,9,4],[1,1,1,6],[2,1,2,19],[3,1,3,19],[4,4,4,9],[4,11,4,15],[56,1,56,4],[44,14,44,18],[46,14,46,18],[48,14,48,18],[50,14,50,18],[53,35,53,36],[53,29,53,30],[39,3,39,7],[38,3,38,7],[43,21,43,23],[41,21,42,23],[40,21,40,22],[38,21,38,23],[39,10,39,14],[43,9,43,12],[38,24,38,25],[41,24,42,25],[40,10,41,17],[38,10,38,14],[37,3,37,7],[48,21,48,23],[49,21,50,23],[44,21,46,23],[44,24,46,25],[37,21,37,23],[48,24,48,25],[36,21,36,23],[36,24,36,25],[43,24,43,25],[39,24,39,25],[40,24,40,25],[33,8,33,9],[31,3,31,7],[32,3,32,7],[35,2,35,6],[11,30,11,35],[13,30,13,35],[15,30,15,35],[23,30,23,37],[28,21,28,26],[29,21,34,26],[20,2,20,4],[17,2,17,4],[20,7,20,16],[30,3,30,7],[17,7,18,9],[19,7,19,17]]}
[null,null,null,null,null,null,null,"x"]
[]
[null,"RIM MN-CREP Workbook"]
[null,"Conservation Easement Financial Worksheet (CEFW)"]
[null,null,null,null,"Landowner Name:",null,null,null,null,null,null,"County/SWCD Office:"]
[null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[null,null,"RIM Valuation",null,null,"Township 1",null,null,null,null,null,"Township 2 (if applicable)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!P15),\"\",'Application Form'!P15)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!P17),\"\",'Application Form'!P17)","v":""}]
[null,null,null,null,null,"Acres","x","Rate","=","Value",null,"Acres","x","Rate","=","Value"]
[]
[null,null,"MNCREP Cropland*",null,null,null,null,null,null,{"$f":"IF(ISBLANK($H$12),\"\",ROUND($F$12,2)*$H$12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($N$12),\"\",ROUND($L$12,2)*$N$12)","v":""},null,null,null,null,{"$f":"IF(AND(ISBLANK(F12),ISBLANK(L12)),\"\",IF(AD12=TRUE,\"MNCREP Cropland acres must equal CRP Contract acres\",\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(NOT(ISBLANK(F12)),NOT(ISBLANK(L12))),SUM(F12,L12)<>'CRP Data'!D12),TRUE,FALSE)","v":false},"Error - MNCREP Cropland acres must equal CRP Contract acres"]
[]
[null,null,"RIM-Only Crop",null,null,null,null,null,null,{"$f":"IF(ISBLANK($H$14),\"\",ROUND($F$14,2)*$H$14)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($N$14),\"\",ROUND($L$14,2)*$N$14)","v":""}]
[]
[null,null,"RIM-Only Non-Crop",null,null,null,null,null,null,{"$f":"IF(ISBLANK($H$16),\"\",ROUND($F$16,2)*$H$16)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($N$16),\"\",ROUND($L$16,2)*$N$16)","v":""},null,null,null,null,{"$f":"IF(AND(ISBLANK(F16),ISBLANK(L16)),\"\",IF(AD16=TRUE,\"RIM-Only Non-Crop acres should not exceed 20% of MNCREP Cropland acres\",\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(F16),ISBLANK(L16)),FALSE,IF(AND(ISBLANK(F12),ISBLANK(L12)),FALSE,IF(SUM(F16,L16)/SUM(F12,L12)>0.2,TRUE,FALSE)))","v":false},"Error - RIM-Only Non-Crop acres should not exceed 20% of MNCREP Cropland acres"]
[]
[null,null,"Donated"]
[]
[]
[null,null,"Total Easement Acres",null,null,{"$f":"ROUND(SUM(F12,F14,F16,F18,L12,L14,L16,L18),2)","v":0}]
[]
[null,null,"Existing CRP Land entered above as RIM-Only Crop",null,null,"Acres",null,"Township 1",null,null,null,"Acres",null,"Township 2 (if applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(F24),ISBLANK(L24)),\"\",IF(AD24=TRUE,\"Existing CRP as RIM-Only Crop acres should not exceed 50% of MNCREP Cropland acres\",\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(F24),ISBLANK(L24)),FALSE,IF(AND(ISBLANK(F12),ISBLANK(L12)),FALSE,IF(SUM(F24,L24)/SUM(F12,L12)>0.5,TRUE,FALSE)))","v":false},"Error - Existing CRP as RIM-Only Crop acres should not exceed 50% of MNCREP Cropland acres"]
[]
[]
[]
[null,null,"CRP Payment Calculation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Productivity Incentive Payment Calculation"]
[null,null,null,"First Year Payment",null,null,null,null,null,{"$f":"IF(ISBLANK('CRP Data'!J15),\"\",'CRP Data'!J15)","v":""},null,null,null,null,null,null,null,null,null,null,null,"This calculation offers the opportunity for an additional incentive payment from RIM. It compares the MNCREP Cropland Value to a payment amount that could be expected from two consecutive Continuous Conservation Reserve Program (CCRP) contracts (30 years) on this same acreage. This incentive will only be experienced if the acreage being enrolled has exceptionally high Soil Rental Rates, as shown on the CRP-1."]
[null,null,null,"Annual Payments",null,null,null,null,null,{"$f":"IF(ISBLANK('CRP Data'!F15),0,'CRP Data'!F15)","v":0}]
[null,null,null,"Total Contract Payments",null,null,null,null,null,{"$f":"IF(ISBLANK('CRP Data'!F39),\"\",'CRP Data'!F39)","v":0}]
[null,null,null,"Sign-up Incentive Payment",null,null,null,null,null,{"$f":"IF(ISBLANK('CRP Data'!I39),\"\",'CRP Data'!I39)","v":0}]
[null,null,null,"Total CRP Payment",null,null,null,null,{"$f":"IF(ISBLANK('CRP Data'!L39),0,'CRP Data'!L39)","v":0}]
[]
[null,null,"RIM Payment Calculation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CREP Soil Rental Rate per acre",null,null,{"$f":"IF('CRP Data'!D15 = \"\",0,'CRP Data'!D15)","v":0}]
[null,null,null,"MNCREP Cropland Payment",null,null,null,null,null,{"$f":"IF(ISBLANK('CRP Data'!L39),0,IF(SUM($J$12,$P$12)<'CRP Data'!L39,0,SUM($J$12,$P$12)-'CRP Data'!L39))","v":0},"(MNCREP Cropland Value minus Total CRP Payment)"]
[null,null,null,"RIM-Only Crop Payment",null,null,null,null,"+",{"$f":"ROUND(SUM($J$14,$P$14),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,"CCRP Soil Rental Rate per acre",null,null,{"$f":"IF('CRP Data'!F15 = \"\",0,IF((('CRP Data'!F15/1.6)/'CRP Data'!D12)*0.9>300,300,(('CRP Data'!F15/1.6)/'CRP Data'!D12)*0.9))","v":0}]
[null,null,null,"RIM-Only Non-Crop Payment",null,null,null,null,"+",{"$f":"ROUND(SUM($J$16,$P$16),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,"CRP-1 Acres",null,"x",{"$f":"'CRP Data'!D12","v":0}]
[null,null,null,"Soil Productivity Incentive Payment",null,null,null,null,"+",{"$f":"Y49","v":0},"(generally applies if CRP acres enrolled have exceptionally high soil rental rates)",null,null,null,null,null,null,null,null,null,null,"Length of 2 15-year CCRP contracts",null,"x","30 years"]
[null,null,null,"Total RIM Payment",null,null,null,null,null,{"$f":"ROUND(SUM($J$38,$J$39,$J$40,$J$41),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Estimated Total Payment for 2 consecutive 15-year CCRP Contracts",null,null,{"$f":"Y39*Y40*30","v":0}]
[]
[null,null,"MN CREP Payment Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total MNCREP Cropland Value                      -",null,null,{"$f":"SUM(J12,P12)","v":0}]
[null,null,null,"Total RIM Payment",null,null,null,null,null,{"$f":"J42","v":0},null,null,null,null,null,null,null,null,null,null,null,"CCRP estimate minus MNCREP Cropland Value",null,null,{"$f":"IF(Y42 < Y44,0,Y42-Y44)","v":0}]
[]
[null,null,null,"Total CRP Payment",null,null,null,null,null,{"$f":"I34","v":0}]
[]
[null,null,null,"Total MNCREP Payment **",null,null,null,null,null,{"$f":"ROUND(SUM($J$45,$J$47),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Soil Productivity Incentive Payment",null,null,{"$f":"IF(Y45 > Y44*0.15,Y44*0.15,Y45)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"CP2 Scoring","index":6,"n_rows":30,"n_cols":25,"rows_kept":30,"cut":false,"hidden":false,"merged":[[32,10,32,12],[34,13,34,14],[23,5,23,11],[24,5,24,11],[25,5,25,11],[26,5,26,11],[29,1,29,6],[1,1,1,6],[4,4,4,14],[6,5,6,8],[6,9,6,13],[7,3,7,6],[7,7,7,8],[7,9,7,12],[7,13,7,14],[5,9,5,13],[22,5,22,11],[29,13,29,14],[11,3,13,11],[17,3,20,11],[2,1,2,15],[3,1,3,15],[8,4,8,9],[8,10,8,15],[9,9,9,13],[14,12,14,14],[5,5,5,8]]}
[]
[]
[null,"RIM WELLHEAD PROTECTION AREAS - CP2"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,null,null,null,"Landowner Name:",null,null,null,"County/SWCD Office:"]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[]
[null,null,"Choose only ONE answer per question below",null,null,null,null,null,null,"CP2 Total Score  ",null,null,null,null,{"$f":"IF(O12=\"Error\",\"Error\",IF(O18=\"Error\",\"Error\",(O12+O18)))","v":0}]
[]
[null,null,"1.","LOCATION - The majority (>50%) of the land offered as CP2 is physically located within a Wellhead Protection Area (WHPA) identified by the Minnesota Department of Health (MDH) and mapped as very high and/or high vulnerability. The WHPA must be located within the Minnesota Water Quality and Habitat CREP project area. (maximum score 50)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W17>1,\"Error\",X17)","v":0},null,null,null,null,null,null,"https://gisdata.mn.gov/dataset/water-wellhead-protection-areas"]
[]
[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 — 50 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",false,{"$f":"IF(W15=TRUE,50,0)","v":0}]
[null,null,null,null,"b.","No — 0 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",false,{"$f":"IF(W16=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",{"$f":"COUNTIF(W15:W16, TRUE)","v":0},{"$f":"SUM(X15:X16)","v":0},"Score Sum"]
[null,null,"2.","SPATIAL RELATIONSHIP - The offer and other existing permanently protected land (fee title or easement) amounts to ____% protection of the very high and/or high vulnerability portions of the WHPA. Offer acres + Existing protected acres ÷ VH and/or H vulnerability acres within WHPA (maximum score 50)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W28>1,\"Error\",X28)","v":0}]
[]
[]
[]
[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,null,null,"a.","75–100% — 50 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",false,{"$f":"IF(W23=TRUE,50,0)","v":0}]
[null,null,null,null,"b.","50–74% — 40 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",false,{"$f":"IF(W24=TRUE,40,0)","v":0}]
[null,null,null,null,"c.","25–49% — 30 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",false,{"$f":"IF(W25=TRUE,30,0)","v":0}]
[null,null,null,null,"d.","10–24% — 20 pts",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"d",false,{"$f":"IF(W26=TRUE,20,0)","v":0}]
[null,null,null,null,"e.","˂ 10% — 10 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e",false,{"$f":"IF(W27=TRUE,10,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",{"$f":"COUNTIF(W23:W27,\"TRUE\")","v":0},{"$f":"SUM(X23:X27)","v":0},"Score Sum"]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"CP21 Scoring","index":7,"n_rows":69,"n_cols":40,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,6],[4,4,4,14],[52,3,52,9],[8,4,8,9],[8,10,8,15],[43,6,45,6],[43,7,44,10],[24,5,24,11],[28,5,28,11],[29,5,29,11],[9,9,9,13],[13,12,13,14],[20,5,20,11],[21,5,21,11],[25,6,27,11],[22,5,22,11],[68,13,68,14],[71,10,71,12],[73,13,73,14],[65,13,65,14],[66,4,66,14],[68,1,68,6],[23,5,23,11],[57,6,59,6],[57,7,58,10],[30,5,30,11],[31,5,31,11],[32,5,32,11],[53,3,56,11],[36,1,36,15],[37,1,37,15],[39,3,41,11],[2,1,2,15],[3,1,3,15],[6,5,6,8],[6,9,6,13],[7,3,7,6],[7,7,7,8],[7,9,7,12],[7,13,7,14],[5,9,5,13],[5,5,5,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2  "]
[null,"RIM FILTER STRIP - CP21"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,null,null,null,"Landowner Name:",null,null,null,"County/SWCD Office:"]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[]
[null,null,"Choose only ONE answer per question below",null,null,null,null,null,null,"CP21 Total Score  ",null,null,null,null,{"$f":"IF(O13=\"Error\",\"Error\",IF(O20=\"Error\",\"Error\",IF(O26=\"Error\",\"Error\",IF(O40=\"Error\",\"Error\",(O13+O20+O26+O40)))))","v":0}]
[]
[]
[null,null,"1.","LOCATION — At least a portion of the CP21 offer is adjacent to a: (maximum score 20)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W18>1,\"Error\",X18)","v":0},null,null,null,null,null,null,null,"True/false","Score"]
[null,null,null,null,"a.","Public water included on the Buffer protection map  — 20 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W14=TRUE,20,0)","v":0}]
[null,null,null,null,"b.","Public drainage system included on the Buffer protection map  — 7 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W15=TRUE,7,0)","v":0}]
[null,null,null,null,"c.","Priority water identified in a State approved local water plan — 7 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",null,{"$f":"IF(W16=TRUE,7,0)","v":0}]
[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,"d",null,{"$f":"IF(W17=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",{"$f":"COUNTIF(W14:W17, TRUE)","v":0},{"$f":"SUM(X14:X17)","v":0},"Score Sum"]
[]
[null,null,"2.","LINEAR CORRIDOR CONNECTIVITY  (maximum score 15)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(W25>1,\"Error\",X25)","v":0},null,null,null,null,null,null,null,"True/false","Score"]
[null,null,null,null,"a.","Permanently protected land (fee title or easement) or another Minnesota Water Quality and Habitat CREP eligible offer or approved contract is on both ends of the land to be devoted to CP21 — 15 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W21=TRUE,15,0)","v":0}]
[null,null,null,null,"b.","Permanently protected land (fee title or easement) or another Minnesota Water Quality and Habitat CREP eligible offer or approved contract is only on one end of the land to be devoted to CP21 — 7 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W22=TRUE,7,0)","v":0}]
[null,null,null,null,"c.","Permanently protected land (fee title or easement) or another Minnesota Water Quality and Habitat CREP eligible offer or approved contract on the same watercourse/water body is within one mile of either end of the land to be devoted to CP21 — 4 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",null,{"$f":"IF(W23=TRUE,4,0)","v":0}]
[null,null,null,null,"d.","Permanently protected land (fee title or easement) or another Minnesota Water Quality and Habitat CREP eligible offer or approved contract on the same watercourse/water body is greater than one mile from either end of the land to be devoted to CP21 — 2 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",null,{"$f":"IF(W24=TRUE,2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"Count True",{"$f":"COUNTIF(W21:W24,\"TRUE\")","v":0},{"$f":"SUM(X21:X24)","v":0},"Score Sum"]
[null,null,"3.","LENGTH —",null,null,"total length of the CP21 offer in linear feet as measured as close to the watercourse as possible, each side is counted and added together (if both sides of a watercourse are a part of the offer)  (maximum score 30)",null,null,null,null,null,null,"Score  ",{"$f":"IF(W34>1,\"Error\",X34)","v":0}]
[]
[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.","> 20,000 ft — 30 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,{"$f":"IF(W29=TRUE,30,0)","v":0}]
[null,null,null,null,"b.","> 5,000 and ≤ 20,000 ft — 20 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,{"$f":"IF(W30=TRUE,20,0)","v":0}]
[null,null,null,null,"c.","> 2,500 and ≤ 5,000 ft — 12 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",null,{"$f":"IF(W31=TRUE,12,0)","v":0}]
[null,null,null,null,"d.","> 1,000 and ≤ 2,500 ft — 8 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d",null,{"$f":"IF(W32=TRUE,8,0)","v":0}]
[null,null,null,null,"e.","≤ 1,000 ft — 4 pts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e",null,{"$f":"IF(W33=TRUE,4,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",{"$f":"COUNTIF(W29:W33,\"TRUE\")","v":0},{"$f":"SUM(X29:X33)","v":0},"Score Sum"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 2 of 2  "]
[null,"RIM FILTER STRIP - CP21"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,"4.","Sediment and Sediment Associated Materials Potential (derived from MN NRCS Filter Strip Standard 393, Table 1). Select the score that represents the specific filter strip situation of the CP21 offer as utilized when filter strip width was determined. (maximum score 17)",null,null,null,null,null,null,null,null,null,"Score  ",{"$f":"IF(V66>1,\"Error\",V67)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"RUSLE2 Soil Loss tons/acre/yr","Upland Watershed Area to Filter Strip Area Ratio"]
[]
[null,null,null,null,null,null,null,"60:1","40:1","20:1","10:1",null,null,null,null,null,null,null,null,null,null,"True/false","Score","True/false","Score","True/false","Score","True/false","Score"]
[null,null,null,null,null,null,"≤ 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V47=TRUE,5,0)","v":0},null,{"$f":"IF(X47=TRUE,5,0)","v":0},null,{"$f":"IF(Z47=TRUE,5,0)","v":0},null,{"$f":"IF(AB47=TRUE,5,0)","v":0}]
[null,null,null,null,null,null,"2.1–4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V48=TRUE,13,0)","v":0},null,{"$f":"IF(X48=TRUE,13,0)","v":0},null,{"$f":"IF(Z48=TRUE,7,0)","v":0},null,{"$f":"IF(AB48=TRUE,5,0)","v":0}]
[null,null,null,null,null,null,"4.1–6","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",0,null,{"$f":"IF(X49=TRUE,13,0)","v":0},null,{"$f":"IF(Z49=TRUE,10,0)","v":0},null,{"$f":"IF(AB49=TRUE,7,0)","v":0}]
[null,null,null,null,null,null,"6.1–8","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",0,null,{"$f":"IF(X50=TRUE,17,0)","v":0},null,{"$f":"IF(Z50=TRUE,17,0)","v":0},null,{"$f":"IF(AB50=TRUE,10,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum Table",{"$f":"COUNTIF(V47:V50,TRUE)","v":0},{"$f":"SUM(W47:W50)","v":0},{"$f":"COUNTIF(X47:X50,TRUE)","v":0},{"$f":"SUM(Y47:Y50)","v":0},{"$f":"COUNTIF(Z47:Z50,TRUE)","v":0},{"$f":"SUM(AA47:AA50)","v":0},{"$f":"COUNTIF(AB47:AB50,TRUE)","v":0},{"$f":"SUM(AC47:AC50)","v":0}]
[null,null,null,null,null,null,null,null,"OR"]
[]
[null,null,null,"Soluble Materials Potential (sediment and sediment associated materials potential already included in the chart below) (derived from MN NRCS Filter Strip Standard 393, Table 1). Select the score that represents the specific filter strip situation of the CP21 offer as utilized when filter strip width was determined.  (maximum score 35)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
[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":"IF(AJ64>1,1,0)","v":0},null,{"$f":"IF(AL64>1,1,0)","v":0},null,{"$f":"SUM(U56:AM56)","v":0}]
[]
[null,null,null,null,null,null,"% Slope of Contributing Area","Upland Watershed Area to Filter Strip Area Ratio"]
[]
[null,null,null,null,null,null,null,"60:1","40:1","20:1","10:1",null,null,null,null,null,null,null,null,null,null,"True/false","Score","True/false","Score","True/false","Score","True/false","Score"]
[null,null,null,null,null,null,"1.1–3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V61=TRUE,22,0)","v":0},null,{"$f":"IF(X61=TRUE,20,0)","v":0},null,{"$f":"IF(Z61=TRUE,17,0)","v":0},null,{"$f":"IF(AB61=TRUE,14,0)","v":0}]
[null,null,null,null,null,null,"3.1–5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V62=TRUE,29,0)","v":0},null,{"$f":"IF(X62=TRUE,25,0)","v":0},null,{"$f":"IF(Z62=TRUE,22,0)","v":0},null,{"$f":"IF(AB62=TRUE,20,0)","v":0}]
[null,null,null,null,null,null,"5.1–12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V63=TRUE,35,0)","v":0},null,{"$f":"IF(X63=TRUE,30,0)","v":0},null,{"$f":"IF(Z63=TRUE,29,0)","v":0},null,{"$f":"IF(AB63=TRUE,24,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum Table",{"$f":"COUNTIF(V61:V63,TRUE)","v":0},{"$f":"SUM(W61:W63)","v":0},{"$f":"COUNTIF(X61:X63,TRUE)","v":0},{"$f":"SUM(Y61:Y63)","v":0},{"$f":"COUNTIF(Z61:Z63,TRUE)","v":0},{"$f":"SUM(AA61:AA63)","v":0},{"$f":"COUNTIF(AB61:AB63,TRUE)","v":0},{"$f":"SUM(AC61:AC63)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T/F Count",{"$f":"SUM(V64,X64,Z64,AB64,V51,X51,Z51,AB51)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score Sum",{"$f":"SUM(W64,Y64,AA64,AC64,W51,Y51,AA51,AC51)","v":0}]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"CP23 Scoring","index":8,"n_rows":70,"n_cols":41,"rows_kept":70,"cut":false,"hidden":false,"merged":[[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],[1,1,1,5],[4,3,4,15],[5,9,5,14],[2,1,2,16],[3,1,3,16],[5,4,5,8],[16,14,16,15],[16,2,24,4],[16,5,17,5],[16,9,16,10],[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],[24,14,24,15],[16,11,24,11],[16,13,24,13],[27,3,27,13],[28,2,28,5],[28,9,28,10],[30,2,36,4],[31,9,31,10],[56,2,57,14],[74,13,74,15],[63,3,63,14],[64,3,64,14],[65,3,65,14],[67,2,67,15],[69,13,69,15],[69,1,69,5],[72,10,72,12],[53,2,53,11],[41,7,47,7],[42,2,42,5],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[51,1,51,16],[52,1,52,16],[41,8,42,15],[55,2,55,7],[30,5,31,5],[30,9,30,10],[62,3,62,14],[43,8,43,15],[44,8,44,15],[46,8,46,15],[41,2,41,5],[45,8,45,15],[39,2,39,9],[32,9,36,10],[59,2,59,9],[60,2,60,15],[61,3,61,14],[30,11,36,11],[47,2,47,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2  "]
[null,"RIM FLOODPLAIN WETLANDS - CP23"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,null,null,"Landowner Name:",null,null,null,null,"County/SWCD Office:"]
[null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[]
[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(P54=\"Error\",\"Error\",IF(P60=\"Error\",\"Error\",(P12+P40+P54+P60)))))","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(AF32>0,\"Error\",IF(AND(AI27>0,AG39>0),\"Error\",IF(AI27>0,AI27,AG39))))","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 Upland : Wetland 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:AF18)","v":0}]
[null,null,null,null,null,1,null,null,null,null,null,null," < 6",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,3)","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," 6-10",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,5)","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," 11-20",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,7)","v":0},null,{"$f":"IF(AD21=FALSE,0,15)","v":0},null,{"$f":"IF(AF21=FALSE,0,6)","v":0}]
[null,null,null,null,null,4,null,null,null,null,null,null," 21-30",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,9)","v":0},null,{"$f":"IF(AD22=FALSE,0,20)","v":0},null,{"$f":"IF(AF22=FALSE,0,10)","v":0}]
[null,null,null,null,null,5,null,null,null,null,null,null," 31-40",null,null,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,11)","v":0},null,{"$f":"IF(AD23=FALSE,0,25)","v":0}]
[null,null,null,null,null,6,null,null,null,null,null,null," > 40",null,null,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,13)","v":0},null,{"$f":"IF(AD24=FALSE,0,30)","v":0}]
[null,null,null,null,null,"≥ 7",null,null,null,null,null,null,null,null,null,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,15)","v":0}]
[]
[null,null,null,null,null,null,null,"OR",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:AF22,\"TRUE\")","v":0},{"$f":"SUM(AG19:AG22)","v":0},{"$f":"(Y27+AA27+AC27+AE27+AG27)","v":0},{"$f":"IF(AH27>50,50,AH27)","v":0}]
[]
[null,null,"Wetland Condition →",null,null,null,null," Effectively Drained","Partially Drained","Farmed Only",null,null,"Total Upland : Wetland Ratio"]
[]
[null,null,"Restorable Non-Depressional  Wetlands",null,null,"Wetland Acres",null,"Check one","Check one","Check one",null,"AND","Check one"]
[null,null,null,null,null,null,null,"(if applicable)","(if applicable)","(if applicable)",null,null,"(if applicable)",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":"IF(AD39>1,1,0)","v":0},null,{"$f":"SUM(X32:AD32)","v":0}]
[null,null,null,null,null,"< 10",null,null,null,null,null,null,"  < 1:1",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,1)","v":0},null,{"$f":"IF(AD33=FALSE,0,0)","v":0}]
[null,null,null,null,null,"10 - 40",null,null,null,null,null,null,"  ≥ 1:1",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,2)","v":0},null,{"$f":"IF(AD34=FALSE,0,2)","v":0}]
[null,null,null,null,null,"41 - 80",null,null,null,null,null,null,"  ≥ 2:1",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,4)","v":0},null,{"$f":"IF(AD35=FALSE,0,6)","v":0}]
[null,null,null,null,null,"81 - 120",null,null,null,null,null,null,"  ≥ 3:1",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,6)","v":0},null,{"$f":"IF(AD36=FALSE,0,10)","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,8)","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(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":"COUNTIF(AD33:AD36,\"TRUE\")","v":0},{"$f":"SUM(AE33:AE36)","v":0},{"$f":"(Y39+AA39+AC39+AE39)","v":0},{"$f":"IF(AF39>50,50,AF39)","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,"Size (total CP23 acres)",null,null,null,null,"AND","LINEAR CORRIDOR CONNECTIVITY - Permanently protected land (fee title or easement) or another Minnesota Water Quality and Habitat CREP eligible offer or approved contract is on: (check one)"]
[null,null,"(Check one)",null,null,null,null,null,null,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(V43:AA43)","v":0}]
[null,null,"≤ 40",null,null,null,null,null,"Both ends of offer",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,10)","v":0}]
[null,null,"41 - 80",null,null,null,null,null,"Only one end of offer",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,5)","v":0}]
[null,null,"81 - 120",null,null,null,null,null,"The same watercourse and ≤ one mile from either end of offer",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,2)","v":0}]
[null,null,"121 - 160",null,null,null,null,null,"The same watercourse and > one mile from either end of offer",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,1)","v":0}]
[null,null,"> 160",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X48=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 FLOODPLAIN WETLANDS - CP23"]
[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(AF54>1,\"Error\",AF57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(X57+Z57+AB57+AD57)","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(X56=FALSE,0,5)","v":0},null,{"$f":"IF(Z56=FALSE,0,10)","v":0},null,{"$f":"IF(AB56=FALSE,0,15)","v":0},null,{"$f":"IF(AD56=FALSE,0,20)","v":0}]
[null,null,"Determine score from Additional Wildlife Benefits GIS layer located on the local USDA NRCS office server 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(X56,\"TRUE\")","v":0},{"$f":"Y56","v":0},{"$f":"COUNTIF(Z56,\"TRUE\")","v":0},{"$f":"AA56","v":0},{"$f":"COUNTIF(AB56,\"TRUE\")","v":0},{"$f":"AC56","v":0},{"$f":"COUNTIF(AD56,\"TRUE\")","v":0},{"$f":"AE56","v":0},{"$f":"(Y57+AA57+AC57+AE57)","v":0}]
[]
[]
[null,null,"D.  ADDITIONAL CONSIDERATIONS (maximum score 10)",null,null,null,null,null,null,null,null,null,null,"Score  ",null,{"$f":"AO62","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(X61=FALSE,0,4)","v":0},null,{"$f":"IF(Z61=FALSE,0,2)","v":0},null,{"$f":"IF(AB61=FALSE,0,2)","v":0},null,{"$f":"IF(AD61=FALSE,0,1)","v":0},null,{"$f":"IF(AF61=FALSE,0,1)","v":0}]
[null,null,"1.","The majority of the area within the CP23 offered area 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":"Y61","v":0},null,{"$f":"AA61","v":0},null,null,null,null,null,{"$f":"AC61","v":0},null,null,null,{"$f":"AE61","v":0},null,{"$f":"AG61","v":0},{"$f":"SUM(Y62:AM62)","v":0},{"$f":"IF(AN62>10,10,AN62)","v":0}]
[null,null,"2.","The CP23 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,"3.","The CP23 offered area project will result in addressing water quality concerns for conventional pollutants (examples: sediment, phosphorus, hydrology, bacteria, nitrogen) as identified in a TMDL report or implementation plan or a Watershed Restoration and Protection Strategy (WRAPS). "]
[null,null,"4.","The predominant soils (more than 50%) within the CP23 offered area are Highly Erodible Land (HEL) or Partially Highly Erodible Land (PHEL)."]
[null,null,"5.","The majority of the contributing watershed(s) to the CP23 offered area is in agricultural use."]
[]
[null,null,"Note: If points are taken for considerations 1 and 2, additional documentation must be provided. Refer to Site Evaluation Form - Instruction documents for further information."]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"CP23a Scoring","index":9,"n_rows":70,"n_cols":41,"rows_kept":70,"cut":false,"hidden":false,"merged":[[44,2,44,4],[55,2,56,14],[18,9,24,10],[28,2,28,5],[43,2,43,4],[30,11,36,11],[41,2,41,5],[42,2,42,5],[42,8,42,12],[32,12,34,12],[41,8,41,12],[45,2,45,4],[51,1,51,16],[30,2,36,4],[32,14,32,15],[30,14,30,15],[14,14,14,15],[41,7,47,7],[17,14,17,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[14,9,14,10],[16,14,16,15],[16,11,24,11],[19,14,19,15],[20,14,20,15],[21,14,21,15],[31,9,31,10],[17,9,17,10],[28,14,28,15],[36,14,36,15],[12,12,12,15],[7,7,7,8],[4,3,4,15],[7,9,7,12],[6,4,6,8],[8,10,8,16],[7,13,7,15],[7,2,7,6],[9,9,9,13],[31,14,31,15],[38,14,38,15],[33,14,33,15],[34,14,34,15],[35,14,35,15],[37,14,37,15],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[74,13,74,15],[72,10,72,12],[69,13,69,15],[27,3,27,13],[54,2,54,8],[39,2,39,9],[58,2,58,9],[28,9,28,10],[65,3,65,14],[63,3,63,14],[67,2,67,15],[52,2,52,11],[64,3,64,14],[62,3,62,14],[61,3,61,14],[60,3,60,14],[1,1,1,5],[8,3,8,9],[5,9,5,14],[6,9,6,14],[11,2,11,9],[5,4,5,8],[69,1,69,4],[2,1,2,16],[3,1,3,16],[50,1,50,16],[16,2,24,4],[14,2,14,5],[16,5,17,5],[16,13,24,13],[18,14,18,15],[16,9,16,10],[59,2,59,15],[30,9,30,10],[30,5,31,5],[46,2,46,4],[47,2,47,4],[32,9,36,10]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2  "]
[null,"RIM WETLANDS PROGRAM - CP23a"]
[null," ENVIRONMENTAL BENEFITS SCORING SHEET"]
[]
[null,null,null,null,"Landowner Name:",null,null,null,null,"County/SWCD Office:"]
[null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[]
[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(AF32>0,\"Error\",IF(AND(AI27>0,AG39>0),\"Error\",IF(AI27>0,AI27,AG39))))","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 Upland : Wetland 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:AF18)","v":0}]
[null,null,null,null,null,1,null,null,null,null,null,null," < 6",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,3)","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," 6-10",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,5)","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," 11-20",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,7)","v":0},null,{"$f":"IF(AD21=FALSE,0,15)","v":0},null,{"$f":"IF(AF21=FALSE,0,6)","v":0}]
[null,null,null,null,null,4,null,null,null,null,null,null," 21-30",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,9)","v":0},null,{"$f":"IF(AD22=FALSE,0,20)","v":0},null,{"$f":"IF(AF22=FALSE,0,8)","v":0}]
[null,null,null,null,null,5,null,null,null,null,null,null," 31-40",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,11)","v":0},null,{"$f":"IF(AD23=FALSE,0,25)","v":0},null,{"$f":"IF(AF23=FALSE,0,10)","v":0}]
[null,null,null,null,null,6,null,null,null,null,null,null," > 40",null,null,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,13)","v":0},null,{"$f":"IF(AD24=FALSE,0,30)","v":0}]
[null,null,null,null,null,"≥ 7",null,null,null,null,null,null,null,null,null,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,15)","v":0}]
[]
[null,null,null,null,null,null,null,"OR",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:AF23,\"TRUE\")","v":0},{"$f":"SUM(AG19:AG23)","v":0},{"$f":"(Y27+AA27+AC27+AE27+AG27)","v":0},{"$f":"IF(AH27>50,50,AH27)","v":0}]
[]
[null,null,"Wetland Condition →",null,null,null,null," Effectively Drained","Partially Drained","Farmed Only",null,null,null,null,"Total Upland : Wetland Ratio"]
[]
[null,null,"Restorable Non-Depressional  Wetlands",null,null,"Wetland Acres",null,"Check one","Check one","Check one",null,null,null,null,"Check one"]
[null,null,null,null,null,null,null,"(if applicable)","(if applicable)","(if applicable)",null,null,null,null,"(if applicable)",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":"IF(AD39>1,1,0)","v":0},null,{"$f":"SUM(X32:AE32)","v":0}]
[null,null,null,null,null,"< 10",null,null,null,null,null,null,"AND",null,"  < 1:1",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,1)","v":0},null,{"$f":"IF(AD33=FALSE,0,0)","v":0}]
[null,null,null,null,null,"10 - 40",null,null,null,null,null,null,null,null,"  ≥ 1:1",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,2)","v":0},null,{"$f":"IF(AD34=FALSE,0,2)","v":0}]
[null,null,null,null,null,"41 - 80",null,null,null,null,null,null,null,null,"  ≥ 2:1",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,4)","v":0},null,{"$f":"IF(AD35=FALSE,0,6)","v":0}]
[null,null,null,null,null,"81 - 120",null,null,null,null,null,null,null,null,"  ≥ 3:1",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,6)","v":0},null,{"$f":"IF(AD36=FALSE,0,8)","v":0}]
[null,null,null,null,null,"≥ 121",null,null,null,null,null,null,null,null,"  ≥ 4:1",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,8)","v":0},false,{"$f":"IF(AD37=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(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":"COUNTIF(AD33:AD37,\"TRUE\")","v":0},{"$f":"SUM(AE33:AE37)","v":0},{"$f":"(Y39+AA39+AC39+AE39)","v":0},{"$f":"IF(AF39>50,50,AF39)","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,"Size (Total CP23a acres)",null,null,null,null,"AND","Acres of Permanent Habitat within 1.5 miles of the CP23a 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(V43:AA43)","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 - CP23a"]
[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 located on the local USDA NRCS office server 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":"AO61","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,4)","v":0},null,{"$f":"IF(Z60=FALSE,0,2)","v":0},null,{"$f":"IF(AB60=FALSE,0,2)","v":0},null,{"$f":"IF(AD60=FALSE,0,2)","v":0},null,{"$f":"IF(AF60=FALSE,0,1)","v":0},null,{"$f":"IF(AH60=FALSE,0,1)","v":0}]
[null,null,"1.","The majority of the area within the CP23a offered area 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":"Y60","v":0},null,{"$f":"AA60","v":0},null,null,null,{"$f":"AC60","v":0},null,{"$f":"AE60","v":0},null,null,null,{"$f":"AG60","v":0},null,{"$f":"AI60","v":0},{"$f":"SUM(Y61:AM61)","v":0},{"$f":"IF(AN61>10,10,AN61)","v":0}]
[null,null,"2.","The CP23a 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,"3.","The CP23a offered area buffers and/or the majority of runoff from it drains to and is within 1/2 mile of a DNR Protected Waters or designated aquatic management areas."]
[null,null,"4.","The CP23a offered area project will result in addressing water quality concerns for conventional pollutants (examples: sediment, phosphorus, hydrology, bacteria, nitrogen) as identified in a TMDL report or implementation plan or a Watershed Restoration and Protection Strategy (WRAPS). "]
[null,null,"5.","The predominant soils (more than 50%) within the CP23a offered area are Highly Erodible Land (HEL) or Partially Highly Erodible Land (PHEL)."]
[null,null,"6.","The majority of the contributing watershed(s) to the CP23a offered area is in agricultural use."]
[]
[null,null,"Note: If points are taken for considerations 1 thru 3, additional documentation must be provided. Refer to Site Evaluation Form - Instruction documents for further information."]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"Questionnaire & Assessment","index":10,"n_rows":57,"n_cols":27,"rows_kept":57,"cut":false,"hidden":false,"merged":[[55,4,55,11],[54,4,54,11],[48,8,48,11],[31,2,31,5],[43,10,43,11],[46,10,46,11],[52,8,52,11],[41,2,41,3],[36,2,36,5],[51,8,51,11],[37,8,37,11],[28,8,28,11],[1,1,1,5],[24,8,24,11],[20,8,20,12],[32,8,32,11],[8,1,8,12],[21,8,21,10],[19,8,19,10],[2,1,2,12],[3,1,3,12],[6,1,6,12],[4,9,4,10],[5,9,5,10],[4,5,4,8],[5,5,5,8],[10,8,10,10],[15,8,15,10],[16,8,16,12],[11,8,11,11],[12,8,12,10],[14,8,14,11],[13,8,13,10],[56,1,56,6],[40,8,40,10],[49,8,49,10],[53,8,53,10],[17,8,17,10],[22,8,22,10],[44,4,44,11],[45,4,45,11],[41,4,41,11],[42,4,42,11],[25,8,25,10],[31,8,31,10],[34,8,34,10],[39,8,39,11],[38,8,38,11],[26,8,26,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 1 of 2"]
[null,"STATE OF MINNESOTA CONSERVATION EASEMENT"]
[null,"Landowner Questionnaire and Easement Area Assessment Form"]
[null,null,null,null,null,"Landowner Name:",null,null,null,"County/SWCD Office:"]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(I12)","v":0}]
[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,true,false,"JUDGEMENTS","LIENS","MORTGAGES","ASSESSMENTS","EASEMENTS"]
[null,null,"1.",null,"Yes",null,"No",null,"Are there any known property deed encumbrances? If so, check all that apply and explain:                                                                                                                                            "]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$11=TRUE,$R$11=TRUE),\"Check either Yes OR No\",IF(AND(R11=TRUE,(OR(S11=TRUE,T11=TRUE,U11=TRUE,V11=TRUE,W11=TRUE))),\"Invalid answer: Do not check boxes for deed encumbrance types if answer to question is No\",\"\"))","v":""},null,null,null,null,null,null,null,true,false,"ACTIVE","INACTIVE-SEALED","INACTIVE-NOT SEALED"]
[null," ","2.",null,"Yes",null,"No",null,"Are you aware of any wells within the planned easement area?  If yes, are they:"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$14=TRUE,$R$14=TRUE),\"Check either Yes OR No\",IF(AND(R14=TRUE,(OR(S14=TRUE,T14=TRUE,U14=TRUE))),\"Invalid answer: Do not check boxes for wells if answer to question is No\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false,"PRIVATELY HELD",true,"BUREAU OF LAND MANAGEMENT","OTHER"]
[null," ","3.",null,"Yes",null,"No",null,"Are you aware of any severed mineral rights on the property? If yes, these rights owned by:"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$18=TRUE,$R$18=TRUE),\"Check either Yes OR No\",IF(AND(R18=TRUE,(OR(S18=TRUE,T18=TRUE,U18=TRUE,V18=TRUE))),\"Invalid answer: Do not check boxes for severed mineral rights if answer to question is No\",\"\"))","v":""}]
[]
[null," ","4.",null,"Yes",null,"No",null,"Is part of the proposed easement area within a platted subdivision?"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$22=TRUE,$R$22=TRUE),\"Check either Yes OR No\",\"\")","v":""}]
[]
[null," ","5.",null,"Yes",null,"No",null,"Have you received a written notice of violation of any local, State, or Federal regulations? This includes DNR Shoreland Rules part 6120.3300, MN Wetland Conservation Act, MN 103E Ditch Buffers, and MN 103F Buffer Law."]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$25=TRUE,$R$25=TRUE),\"Check either Yes OR No\",\"\")","v":""},null,null,null,null,null,null,null,true,false,"DUMP SITE, JUNK PILE, OR DISPOSAL PIT","CONTAINS TANKS, DRUMS, VEHICLES, MACHINERY, APPLIANCES, TIRES, BATTERIES, OTHER STORAGE CONTAINERS","EVIDENCE OF CONTAMINATED SOILS (UNUSUAL STAINS, ODORS, OR CHEMICALS)","EVIDENCE OF CONTANIMATED SURFACE WATERS (OIL SHEEN, DISCOLORATION, OR UNUSUAL ODORS)","EVIDENCE OF FORMER, EXISITING, OR FUTURE BUILDING SITE","OTHER"]
[null,null,"6.",null,"Yes",null,"No",null,"Are there any potential environmental issues on the planned easement area, or within 200 feet of the planned easement area? If yes, please check all that apply and explain: "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$27=TRUE,$R$27=TRUE),\"Check either Yes OR No\",IF(AND(R27=TRUE,(OR(S27=TRUE,T27=TRUE,U27=TRUE,V27=TRUE,W27=TRUE,X27=TRUE))),\"Invalid answer: Do not check boxes for environmental issues if answer to question is No\",\"\"))","v":""},null,null,null,null,null,null,null,true,false,"NATURAL GAS","CRUDE OIL/REFINED","ELECTRIC","TELEPHONE","FIBER OPTIC/CABLE","WIND","OTHER"]
[null,null,"7.",null,"Yes",null,"No",null,"Are there any natural gas, crude oil, refined petroleum pipelines or other utilities located on, or within 200 feet of the property?  If yes, please check all that apply: "]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$33=TRUE,$R$33=TRUE),\"Check either Yes OR No\",IF(AND(R33=TRUE,(OR(S33=TRUE,T33=TRUE,U33=TRUE,V33=TRUE,W33=TRUE,X33=TRUE,Y33=TRUE))),\"Invalid answer: Do not check boxes for pipelines or utilities if answer to question is No\",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sheet 2 of 2"]
[null," ","8.",null,"Yes",null,"No",null,"Is some or all of the property currently enrolled in another state or federal conservation program (e.g. CRP) or is it encumbered by another conservation easement (RIM, WRP, Wetland Banking/Mitigation, U.S. Fish and Wildlife, Land Trust, etc.)? If yes, explain:"]
[]
[null,null,null,null,null,null,null,null,"Note, lands in certain conservation programs or containing other conservation easements may be restricted or ineligible for enrollment. Refer to eligibility guidance for additional information."]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$38=TRUE,$R$38=TRUE),\"Check either Yes OR No\",\"\")","v":""}]
[null," ","9.",null,"Describe the ecological benefits of acquiring a conservation easement on this area and describe any significant natural resource, natural public lands, or other protected lands that are near the site and will be benefited by it:"]
[]
[]
[null," ","10.",null,"Are there any potential problems with acquiring a conservation easement on this area?"]
[]
[]
[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,"11.",null,"Yes",null,"No",null,"Does the planned easement area contain drained or altered wetlands? If yes, please check all applicable drainage or alteration methods below:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$49=TRUE,$R$49=TRUE),\"Check either Yes OR No\",IF(AND(R49=TRUE,(OR(S49=TRUE,T49=TRUE,U49=TRUE,V49=TRUE,W49=TRUE,X49=TRUE,Y49=TRUE,Z49=TRUE,AA49=TRUE))),\"Invalid answer: Do not check boxes for drained or altered wetlands if answer to question is No\",\"\"))","v":""}]
[]
[null,null,"12.",null,"Yes",null,"No",null,"Are any of the identified drainage features in question 11 above governed by a private drainage easement or agreement?  If yes, please explain and where possible, provide additional information:"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($Q$52=TRUE,$R$52=TRUE),\"Check either Yes OR No\",\"\")","v":""}]
[null," ","13.",null,"Describe any potential issues or construction constraints with restoring drained or altered wetlands within the easement (e.g., tile system from neighboring property enters proposed easement area, wetland restoration may hydrologically impact neighboring property, etc.):"]
[]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"Min Size Waiver","index":11,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,5],[50,3,50,8],[4,1,4,13],[6,4,6,8],[6,9,6,11],[36,3,38,12],[42,3,43,12],[46,3,46,6],[46,9,46,11],[17,3,18,12],[8,1,8,13],[14,5,14,12],[10,2,13,12],[30,3,31,12],[33,3,34,12],[1,1,1,4],[22,3,24,12],[7,4,7,8],[7,9,7,11],[2,1,2,13]]}
[]
[]
[null,"RIM MN-CREP Workbook"]
[]
[null,"RIM/CREP Minimum Size Waiver Worksheet"]
[]
[null,null,null,null,"Landowner Name:",null,null,null,null,"County/SWCD Office:"]
[null,null,null,null,{"$f":"IF(AND(ISBLANK('Application Form'!C8),NOT(ISBLANK('Application Form'!L8))),'Application Form'!L8,IF(AND(NOT(ISBLANK('Application Form'!C8)),NOT(ISBLANK('Application Form'!L8))),'Application Form'!C8&\" \"&'Application Form'!L8,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Application Form'!T8),\"\",'Application Form'!T8)","v":""}]
[]
[]
[null,null,"This form documents whether a CRP offer under the Minnesota Water Quality and Habitat CREP has met the criteria necessary to waive the 8 acre minimum requirements per the State of Minnesota CREP eligibility requirements criteria. This allows the offer to be scored and ranked. This does not guarantee that the offer will be approved, only that it will be scored and ranked the same as all other eligible offers."]
[]
[]
[]
[]
[null,null,null,"Socially Disadvantaged, Limited Resource, or Beginning Farmer or Rancher"]
[]
[null,null,null,"At least one person or legal entity on the offer is a socially disadvantaged, limited resource, or beginning farmer or rancher as determined by CCC. The determination will be provided by FSA to the local SWCD.",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,null,null,"For land offered as CP-2"]
[]
[null,null,null,"The majority (>50%) of the land offered as CP-2 is physically located within a Wellhead Protection Area (WHPA) identified by the Minnesota Department of Health (MDH) AND mapped as very high and/or high vulnerability.  The WHPA must be located within the Minnesota Water Quality and Habitat CREP project area.",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,null,null,"For land offered as CP-21"]
[]
[null,null,null,"The CP-21 will be immediately adjacent to a Public Water included on the Buffer protection map.",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,null,"The CP-21 will be contiguous (immediately adjacent or directly across the watercourse) to already permanently protected land (fee title or easement).",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,null,null,"The CP-21 will be contiguous (immediately adjacent or directly across the watercourse) to another Minnesota Water Quality and Habitat CREP eligible offer or approved contract.",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,null,null,"The CP-21 will, at a minimum, require the width needed for filtering sediment, soluble materials and pathogens according to NRCS Documentation of Eligibility and Suitability for Filter Strip CP21 and the NRCS Filter Strip practice standard.",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,null,null,"For land offered as CP-23 or CP-23a"]
[]
[null,null,null,"The CP23 or CP23a will be immediately adjacent to already permanently protected land (fee title or easement) OR another Minnesota Water Quality and Habitat CREP eligible offer or approved contract.",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,null,null,"Landowner Signature",null,null,null,"Date",null,"SWCD Signature",null,null,"Date"]
[]
[null,"For SWCD office use only"]
[]
[null,null,null,"Waiver Granted—at least one box checked above",null,null,null,null,null,"Waiver Denied—no boxes above checked",null,null,null,null,null,null,null,false,false]
[null,{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"AppUploadTemplate","index":12,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["LAST_NAME_BUSINESS","FIRST_NAME","SPOUSE","COUNTY_FIELD_OFFICE","TOWNSHIP_NAME","TOWNSHIP1","RANGE1","SECTION1","TOWNSHIP2","RANGE2","SECTION2","PROJECT_NAME","ADDRESS1","ADDRESS_ATTN","CITY","STATE","ZIP","PHONE_NUM_HOME","PHONE_NUM_WORK","PHONE_NUM_CELL","EMAIL","EASEMENT_TYPE_CODE","EASEMENT_TOTAL_ACRES","CRP1_ACRES_FOR_ENROLLMENT","RIM_ONLY_CROP_ACRES","RIM_ONLY_NONCROP_ACRES","RIM_ONLY_CROP_CRP_ACRES","DONATED_ACRES","CRP_TOTAL_PAYMENT","RIM_TOTAL_PAYMENT","RIM_ONLY_CROP_PAYMENT","RIM_ONLY_NONCROP_PAYMENT","RIM_ONLY_CROP_CRP_PAYMENT","CREP_VALUE_MINUS_CRP_PAYMENT","LSOHC_PLANNING_UNIT","HUC12","WELLHEAD_PROTECTION_AREA","CRP1_CONTRACT_PERIOD_START","CRP1_CONTRACT_PERIOD_END","CRP1_PARTICANTS_SIGNATURE_DATE","MIN_SIZE_WAIVER","APP_WORKBOOK_VERSION","LAST_MODIFIED"]
[{"$f":"IF(ISBLANK('Application Form'!L8),\"\",TRIM(UPPER('Application Form'!L8)))","v":""},{"$f":"IF(ISBLANK('Application Form'!C8),\"\",TRIM(UPPER('Application Form'!C8)))","v":""},{"$f":"IF(ISBLANK('Application Form'!P8),\"\",TRIM(UPPER('Application Form'!P8)))","v":""},{"$f":"IF(ISBLANK('Application Form'!T8),\"\",INDEX(Lists!A2:A92,(MATCH('Application Form'!T8,SWCD,0)),0))","v":""},{"$f":"IF(ISBLANK('Application Form'!P15),\"\",TRIM(UPPER('Application Form'!P15)))","v":""},{"$f":"IF(ISBLANK('Application Form'!U15),\"\",'Application Form'!U15)","v":""},{"$f":"IF(ISBLANK('Application Form'!V15),\"\",'Application Form'!V15)","v":""},{"$f":"IF(ISBLANK('Application Form'!T15),\"\",'Application Form'!T15)","v":""},{"$f":"IF(ISBLANK('Application Form'!U17),\"\",'Application Form'!U17)","v":""},{"$f":"IF(ISBLANK('Application Form'!V17),\"\",'Application Form'!V17)","v":""},{"$f":"IF(ISBLANK('Application Form'!T17),\"\",'Application Form'!T17)","v":""},{"$f":"IF(ISBLANK('Application Form'!C15),\"\",UPPER('Application Form'!C15))","v":""},{"$f":"IF(ISBLANK('Application Form'!C10),\"\",TRIM(UPPER('Application Form'!C10)))","v":""},{"$f":"IF(ISBLANK('Application Form'!N10),\"\",TRIM(UPPER('Application Form'!N10)))","v":""},{"$f":"IF(ISBLANK('Application Form'!Q10),\"\",TRIM(UPPER('Application Form'!Q10)))","v":""},{"$f":"IF(ISBLANK('Application Form'!U10),\"\",TRIM(UPPER('Application Form'!U10)))","v":""},{"$f":"IF(ISBLANK('Application Form'!V10),\"\",TRIM('Application Form'!V10))","v":""},{"$f":"IF(ISBLANK('Application Form'!C12),\"\",'Application Form'!C12)","v":""},{"$f":"IF(ISBLANK('Application Form'!J12),\"\",'Application Form'!J12)","v":""},{"$f":"IF(ISBLANK('Application Form'!N12),\"\",'Application Form'!N12)","v":""},{"$f":"IF(ISBLANK('Application Form'!Q12),\"\",'Application Form'!Q12)","v":""},{"$f":"IF('CRP Data'!L35=\"CP2\",\"13\",IF('CRP Data'!L35=\"CP21\",\"10\",IF('CRP Data'!L35=\"CP23\",\"12\",IF('CRP Data'!L35=\"CP23a\",\"11\",\"\"))))","v":""},{"$f":"IF(ISBLANK(CEFW!$F$21),\"\",CEFW!$F$21)","v":0},{"$f":"IF(ISBLANK('CRP Data'!D12),\"\",'CRP Data'!D12)","v":""},{"$f":"IF(AND(ISBLANK(CEFW!F14),ISBLANK(CEFW!L14)),\"\",ROUND(SUM(CEFW!F14,CEFW!L14),2))","v":""},{"$f":"IF(AND(ISBLANK(CEFW!F16),ISBLANK(CEFW!L16)),\"\",ROUND(SUM(CEFW!F16,CEFW!L16),2))","v":""},{"$f":"IF(AND(ISBLANK(CEFW!F24),ISBLANK(CEFW!L45)),\"\",ROUND(SUM(CEFW!F24,CEFW!L24),2))","v":""},{"$f":"IF(AND(ISBLANK(CEFW!F18),ISBLANK(CEFW!L18)),\"\",ROUND(SUM(CEFW!F18,CEFW!L18),2))","v":""},{"$f":"IF('CRP Data'!$L$39=\"\",\"\",ROUND('CRP Data'!$L$39,2))","v":0},{"$f":"IF(ISBLANK(CEFW!J42),\"\",ROUND(CEFW!J42,2))","v":0},{"$f":"IF(ISBLANK(CEFW!J39),\"\",ROUND(CEFW!J39,2))","v":0},{"$f":"IF(ISBLANK(CEFW!J40),\"\",ROUND(CEFW!J40,2))","v":0},{"$f":"IF(AND(NOT(ISBLANK(CEFW!$H$14)),NOT(ISBLANK(CEFW!$F$24)),NOT(ISBLANK(CEFW!$N$14)),NOT(ISBLANK(CEFW!$L$24))),SUM(ROUND(CEFW!$F$24,2)*CEFW!$H$14,ROUND(CEFW!$L$24,2)*CEFW!$N$14),\nIF(AND(NOT(ISBLANK(CEFW!$H$14)),NOT(ISBLANK(CEFW!$F$24))),(ROUND(CEFW!$F$24,2)*CEFW!$H$14),\"\"))","v":""},{"$f":"IF(ISBLANK(CEFW!J38),\"\",ROUND(CEFW!J38,2))","v":0},{"$f":"IF(ISBLANK('Application Form'!C17),\"\",'Application Form'!C17)","v":""},null,null,{"$f":"IF(ISBLANK('CRP Data'!$G$12),\"\",('CRP Data'!$G$12))","v":""},{"$f":"IF(ISBLANK('CRP Data'!$J$12),\"\",('CRP Data'!$J$12))","v":""},{"$f":"IF(ISBLANK('CRP Data'!$D$30),\"\",('CRP Data'!$D$30))","v":""},{"$f":"IF(AND('Program Eligibility Form'!S38=TRUE,'Min Size Waiver'!R51=TRUE),TRUE,\"\")","v":""},{"$f":"'Instructions - Menu'!$G$5","v":"EasApp_v07"},{"$f":"LastModified()","v":"2019-07-31T16:46:06"}]

{"sheet":"ApplicationQuestion","index":13,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["DESCRIPTOR","YESNO_IND","OPTION_VALUES","LONG_ANSWER"]
["DEED_ENCUMBRANCE",{"$f":"IF('Questionnaire & Assessment'!Q11=TRUE,TRUE,IF('Questionnaire & Assessment'!R11=TRUE,FALSE,\"\"))","v":""},{"$f":"IF(COUNTIF('Questionnaire & Assessment'!S11:W11,\"<>TRUE\")=5,\"                                                                                                                                                      \"&\"                                                                                                                                                      \",ConcatenateIf('Questionnaire & Assessment'!S11:W11,TRUE,'Questionnaire & Assessment'!S10:W10,\";\"))","v":"                                                                                                                                                                                                                                                                                                            "},{"$f":"IF(ISBLANK('Questionnaire & Assessment'!I12),\"                                                                                                                                                      \"&\"                                                                                                                                                      \",'Questionnaire & Assessment'!I12)","v":"                                                                                                                                                                                                                                                                                                            "}]
["WELLS",{"$f":"IF('Questionnaire & Assessment'!Q14=TRUE,TRUE,IF('Questionnaire & Assessment'!R14=TRUE,FALSE,\"\"))","v":""},{"$f":"IF(COUNTIF('Questionnaire & Assessment'!S14:U14,\"<>TRUE\")=3,\"\",ConcatenateIf('Questionnaire & Assessment'!S14:U14,TRUE,'Questionnaire & Assessment'!S13:U13,\";\"))","v":""}]
["MINERAL_RIGHTS",{"$f":"IF('Questionnaire & Assessment'!Q18=TRUE,TRUE,IF('Questionnaire & Assessment'!R18=TRUE,FALSE,\"\"))","v":""},{"$f":"IF(COUNTIF('Questionnaire & Assessment'!S18:V18,\"<>TRUE\")=4,\"\",ConcatenateIf('Questionnaire & Assessment'!S18:V18,TRUE,'Questionnaire & Assessment'!S17:V17,\";\"))","v":""}]
["PLATTED_SUBDIVISION",{"$f":"IF('Questionnaire & Assessment'!Q22=TRUE,TRUE,IF('Questionnaire & Assessment'!R22=TRUE,FALSE,\"\"))","v":""}]
["NONCOMPLIANT",{"$f":"IF('Questionnaire & Assessment'!Q25=TRUE,TRUE,IF('Questionnaire & Assessment'!R25=TRUE,FALSE,\"\"))","v":""}]
["ENVIRONMENTAL_ISSUES",{"$f":"IF('Questionnaire & Assessment'!Q27=TRUE,TRUE,IF('Questionnaire & Assessment'!R27=TRUE,FALSE,\"\"))","v":""},{"$f":"IF(COUNTIF('Questionnaire & Assessment'!S27:X27,\"<>TRUE\")=6,\"\",ConcatenateIf('Questionnaire & Assessment'!S27:X27,TRUE,'Questionnaire & Assessment'!S26:X26,\";\"))","v":""},{"$f":"IF(ISBLANK('Questionnaire & Assessment'!I29),\"\",'Questionnaire & Assessment'!I29)","v":""}]
["UTILITIES",{"$f":"IF('Questionnaire & Assessment'!Q33=TRUE,TRUE,IF('Questionnaire & Assessment'!R33=TRUE,FALSE,\"\"))","v":""},{"$f":"IF(COUNTIF('Questionnaire & Assessment'!S33:Y33,\"<>TRUE\")=7,\"\",ConcatenateIf('Questionnaire & Assessment'!S33:Y33,TRUE,'Questionnaire & Assessment'!S32:Y32,\";\"))","v":""}]
["OTHER_EASEMENT",{"$f":"IF('Questionnaire & Assessment'!Q38=TRUE,TRUE,IF('Questionnaire & Assessment'!R38=TRUE,FALSE,\"\"))","v":""},null,{"$f":"IF(ISBLANK('Questionnaire & Assessment'!I39),\"\",'Questionnaire & Assessment'!I39)","v":""}]
["ECOLOGICAL_BENEFITS",null,null,{"$f":"IF(ISBLANK('Questionnaire & Assessment'!E43),\"\",'Questionnaire & Assessment'!E43)","v":""}]
["POTENTIAL_PROBLEMS",null,null,{"$f":"IF(ISBLANK('Questionnaire & Assessment'!E46),\"\",'Questionnaire & Assessment'!E46)","v":""}]
["DRAINAGE_ALTERATIONS",{"$f":"IF('Questionnaire & Assessment'!Q49=TRUE,TRUE,IF('Questionnaire & Assessment'!R49=TRUE,FALSE,\"\"))","v":""},{"$f":"IF(COUNTIF('Questionnaire & Assessment'!S49:AA49,\"<>TRUE\")=9,\"\",ConcatenateIf('Questionnaire & Assessment'!S49:AA49,TRUE,'Questionnaire & Assessment'!S48:AA48,\";\"))","v":""}]
["DRAINAGE_EASEMENT",{"$f":"IF('Questionnaire & Assessment'!Q52=TRUE,TRUE,IF('Questionnaire & Assessment'!R52=TRUE,FALSE,\"\"))","v":""},null,{"$f":"IF(ISBLANK('Questionnaire & Assessment'!I53),\"\",'Questionnaire & Assessment'!I53)","v":""}]
["WETLAND_RESTORATION_ISSUES",null,null,{"$f":"IF(ISBLANK('Questionnaire & Assessment'!E56),\"\",'Questionnaire & Assessment'!E56)","v":""}]

{"sheet":"ApplicationPractice","index":14,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["PRACTICE_CODE","ACRES","CONTRACT_PAYMENT","SIGNUP_INCENTIVE_PAYMENT","SCORE_TOTAL","LOCATION","SPATIAL_RELATIONSHIP","LINEAR_CORRIDOR","LENGTH","WIDTH","RESTORATION_BENEFITS","ECOLOGICAL_HABITAT","ADDITIONAL_WILDLIFE","ADDITIONAL_CONSIDERATIONS"]
["CP2",{"$f":"IF(ISBLANK('CRP Data'!$E$35),\"\",ROUND('CRP Data'!$E$35,2))","v":0},{"$f":"IF('CRP Data'!$F$35=\"\",\"\",ROUND('CRP Data'!$F$35,2))","v":""},{"$f":"IF(OR(ISBLANK('CRP Data'!$I$35),'CRP Data'!$I$35=\"\"),\"\",ROUND('CRP Data'!$I$35,2))","v":0},{"$f":"IF(ISBLANK('CP2 Scoring'!$O$10),\"\",'CP2 Scoring'!$O$10)","v":0},{"$f":"IF(ISBLANK('CP2 Scoring'!$O$12),\"\",'CP2 Scoring'!$O$12)","v":0},{"$f":"IF(ISBLANK('CP2 Scoring'!$O$18),\"\",'CP2 Scoring'!$O$18)","v":0}]
["CP21",{"$f":"IF(ISBLANK('CRP Data'!$E$36),\"\",ROUND('CRP Data'!$E$36,2))","v":0},{"$f":"IF('CRP Data'!$F$36=\"\",\"\",ROUND('CRP Data'!$F$36,2))","v":""},{"$f":"IF(OR(ISBLANK('CRP Data'!$I$36),'CRP Data'!$I$36=\"\"),\"\",ROUND('CRP Data'!$I$36,2))","v":0},{"$f":"IF(ISBLANK('CP21 Scoring'!$O$10),\"\",'CP21 Scoring'!$O$10)","v":0},{"$f":"IF(ISBLANK('CP21 Scoring'!$O$13),\"\",'CP21 Scoring'!$O$13)","v":0},null,{"$f":"IF(ISBLANK('CP21 Scoring'!$O$20),\"\",'CP21 Scoring'!$O$20)","v":0},{"$f":"IF(ISBLANK('CP21 Scoring'!$O$26),\"\",'CP21 Scoring'!$O$26)","v":0},{"$f":"IF(ISBLANK('CP21 Scoring'!$O$40),\"\",'CP21 Scoring'!$O$40)","v":0}]
["CP23",{"$f":"IF(ISBLANK('CRP Data'!$E$37),\"\",ROUND('CRP Data'!$E$37,2))","v":0},{"$f":"IF('CRP Data'!$F$37=\"\",\"\",ROUND('CRP Data'!$F$37,2))","v":""},{"$f":"IF(OR(ISBLANK('CRP Data'!$I$37),'CRP Data'!$I$37=\"\"),\"\",ROUND('CRP Data'!$I$37,2))","v":0},{"$f":"IF(ISBLANK('CP23 Scoring'!$P$10),\"\",'CP23 Scoring'!$P$10)","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK('CP23 Scoring'!$P$12),\"\",'CP23 Scoring'!$P$12)","v":0},{"$f":"IF(ISBLANK('CP23 Scoring'!$P$40),\"\",'CP23 Scoring'!$P$40)","v":0},{"$f":"IF(ISBLANK('CP23 Scoring'!$P$54),\"\",'CP23 Scoring'!$P$54)","v":0},{"$f":"IF(ISBLANK('CP23 Scoring'!$P$60),\"\",'CP23 Scoring'!$P$60)","v":0}]
["CP23A",{"$f":"IF(ISBLANK('CRP Data'!$E$38),\"\",ROUND('CRP Data'!$E$38,2))","v":0},{"$f":"IF('CRP Data'!$F$38=\"\",\"\",ROUND('CRP Data'!$F$38,2))","v":""},{"$f":"IF(OR(ISBLANK('CRP Data'!$I$38),'CRP Data'!$I$38=\"\"),\"\",ROUND('CRP Data'!$I$38,2))","v":0},{"$f":"IF(ISBLANK('CP23a Scoring'!$P$10),\"\",'CP23a Scoring'!$P$10)","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK('CP23a Scoring'!$P$12),\"\",'CP23a Scoring'!$P$12)","v":0},{"$f":"IF(ISBLANK('CP23a Scoring'!$P$40),\"\",'CP23a Scoring'!$P$40)","v":0},{"$f":"IF(ISBLANK('CP23a Scoring'!$P$53),\"\",'CP23a Scoring'!$P$53)","v":0},{"$f":"IF(ISBLANK('CP23a Scoring'!$P$59),\"\",'CP23a Scoring'!$P$59)","v":0}]

{"sheet":"Lists","index":15,"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"]