{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SWRM Appl","Table 1","OPTIONAL Innovation Grant App","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SWRM Appl","index":0,"n_rows":84,"n_cols":11,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,1,83,11],[80,1,80,9],[71,1,71,7],[73,3,73,4],[61,10,61,11],[74,3,74,4],[68,10,68,11],[79,1,79,9],[65,10,65,11],[74,5,74,7],[59,10,59,11],[55,7,55,8],[55,9,55,11],[57,0,57,11],[45,7,45,8],[53,9,54,11],[45,1,45,6],[46,0,52,0],[53,7,53,8],[47,7,52,8],[53,1,53,6],[46,1,46,6],[46,7,46,8],[54,1,54,6],[52,2,52,5],[47,1,47,5],[43,7,43,8],[43,0,43,6],[44,1,44,6],[37,7,37,8],[40,7,41,8],[44,7,44,8],[38,1,38,2],[2,1,2,10],[33,1,33,2],[43,9,43,11],[36,1,36,6],[8,1,8,2],[20,9,20,10],[20,1,20,5],[39,1,39,6],[33,3,33,6],[35,1,35,2],[37,1,37,6],[38,3,38,6],[38,7,38,8],[36,9,41,11],[29,7,32,8],[33,7,33,8],[25,7,25,8],[34,1,34,2],[35,3,35,6],[31,1,31,6],[32,2,32,6],[34,3,34,6],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[4,1,4,10],[21,1,21,4],[20,6,20,8],[23,1,23,10],[5,1,5,10],[6,1,6,10],[22,1,22,10],[25,9,25,11],[34,7,34,8],[35,7,35,8],[26,7,28,8],[25,0,25,6]]}
[null,"JOINT DATCP/DNR NONPOINT SOURCE GRANT APPLICATION FOR CALENDAR YEAR 2026"]
[]
[null,"1. Read the request for proposal document before completing this application."]
[null,"2. Complete all yellow-highlighted items in the combined application and Table 1.   "]
[null,"3. Sign the completed application electronically "]
[null,"4. Submit the signed Excel spreadsheet to: datcpswrm@wisconsin.gov "]
[null,"5. April 15, 2025 is the deadline for submission of this grant application. "]
[]
[null,null,null,"county, through its authorized representative, is applying for annual"]
[null,"grant funds from the Wisconsin Department of Agriculture, Trade and Consumer Protection (DATCP) awarded"]
[null,"under s. 92.14, Wis. Stats., and the Department of Natural Resources (DNR) awarded under ss. 281.65 and 281.66,"]
[null,"Wis. Stats. By signing and dating a completed application, the authorized representative certifies that (i) the Land"]
[null,"Conservation Committee (LCC) or other committee designated under s. 92.06(1), Wis. Stats., has authorized the"]
[null,"representative to submit this application; (ii) the county has submitted an Annual Report and Annual Work Plan,"]
[null,"and has complied with other grant requrirements including ATCP s. 50.20, Wis. Admin. Code; and (iii) the"]
[null,"information provided in this application (including Table 1) is true, complete and accurate to"]
[null,"the best of his or her knowledge. (s. 92.14, Wis. Stats.) This is a mandatory form for applying for grant funds."]
[null,"Any personally identifiable information, as defined under s. 19.62(5), Wis. Stats., requested on this form"]
[null,"may be used for purposes other than that for which it is originally being collected (s. 15.04(1)(m), Wis. Stats.).  "]
[null,"Confidentiality of this information will be maintained to the extent authorized by law.  "]
[]
[null,"SIGNATURE OF AUTHORIZED REPRESENTATIVE",null,null,null,null,"LCC CHAIR OR OTHER TITLE",null,null,"DATE"]
[null,"The authorized representative may sign this application electronically by typing his or her name in the space provided for a signature, and inserting the person's title and the date. An electronic signature has the same force and effect, pursuant to chapter 137 of the Wisconsin statutes, as a non-electronic signature."]
[null,"NOTICE: This application does not represent a commitment by DATCP or DNR to provide funding for any grant category at any specific level.  If grant funds are awarded, the county must agree to comply with any resulting terms including those specified in a grant contract. "]
[]
["SECTION I.  STAFFING/PLANNING GRANTS",null,null,null,null,null,null,"Amount Requested of DATCP",null,"Amount Requested of DNR"]
[1,"Soil and Water Resource Management (SWRM) Tier 1 ",null,null,null,null,null,75000]
[null,"A.    Base Funding"]
[null,"$75,000 is automatically entered.   "]
[2,"SWRM Tier 2 "]
[null,"A.     Funding for three positions "]
[null,"Automatically enters amounts from Table 1, column F, for first three positions"]
[null,null,"Amount from Table 1, column F"]
[null,"i.  First (100%) position    ",null,{"$f":"'Table 1'!H9","v":0},null,null,null,{"$f":"ROUND(D34,0)","v":0}]
[null,"ii.  Second (70%) position",null,{"$f":"'Table 1'!H10","v":0},null,null,null,{"$f":"ROUND(D35*0.7,0)","v":0}]
[null,"iii.  Third (50%) position",null,{"$f":"'Table 1'!H11","v":0},null,null,null,{"$f":"ROUND(D36*0.5,0)","v":0}]
[null,"B.      Funding for subsequent positions "]
[null,"Automatically enters amount from Table 1, column G"]
[null,"iv. Fourth & more (50%) positions",null,{"$f":"'Table 1'!I12","v":0},null,null,null,{"$f":"ROUND(D39*0.5,0)","v":0}]
[3,"Urban NPS & Storm Water Management - Planning Projects (Complete separate application available on DNR website) "]
[null,null,null,null,null,null,null,{"$f":"IF((H34+H35+H36+H39)>75000,H34+H35+H36+H39,75000)","v":75000}]
[null,null,null,null,null,null,"TOTAL STAFFING REQUESTS ►"]
[]
["SECTION II.  COST-SHARING GRANTS",null,null,null,null,null,null,"Amount Requested of DATCP",null,"Amount Requested of DNR"]
[1,"Land and Water Resource Mgmt. (LWRM) Plan Implementation: Structural Funds "]
[2,"LWRM Plan Implementation: SEG Funds "]
[3,"Nutrient Management Programming in County (enter \"yes\" if True)",null,null,null,null,null,{"$f":"COUNTIFS(G48:G53,\"Yes\")","v":0},{"$f":"COUNTIFS(I39:I45,\"Yes\")","v":0}]
[null,"We employ a staff agronomist"]
[null,"We employ a nutrient management specialist"]
[null,"NM planning and implementation strategy are in our 2025 Workplan"]
[null,"We support NUE/MRTN projects in the county through grant funds or education."]
[null,"We have programming to support outreach and education regarding NM planning, soil testing, plan renewal, soil health."]
[null,"Other"]
[4,"Targeted Runoff Management Projects\n(Complete separate application available on DNR website) "]
[5,"Urban NPS & Storm Water Management - Construction Projects (Complete separate application on DNR webstite)"]
[null,null,null,null,null,null,"TOTAL COST-SHARING REQUESTS ►",{"$f":"H45+H46","v":0}]
[]
["SECTION III.  FINANCIAL AND OTHER DATCP REPORTING REQUIREMENTS"]
[1,"Financial Report of County LCD Expenditures for 2024"]
["A.","Enter the total amount of all county LCD expenditures in 2024 from all funding sources."]
[]
["B.","Enter the amount of expenditures in 2024 from all non-county sources."]
[null,"(Of the total expenditure listed in line 1A., enter the amount funded using non-county sources,  "]
[null,"which may include grants, shared revenue, and other funds from sources external to the county.  "]
[null,"NOTE: Line 1B. plus line IC. equals line 1A.)"]
["C.","Amount of county source funding expended in 2024",null,null,null,null,null,null,null,null,{"$f":"K60-K62","v":0}]
[null,"(County source funding may include county levies, fees, permits, tree sales, or other funds generated "]
[null,"by the county.  This amount is used to determine fulfillment of maintenance of effort requirements).  "]
["D.","Enter the amount of salary and fringe benefits paid using county source funding.           "]
[null,"(NOTE: LINE 1D. CANNOT EXCEED LINE 1C.)"]
[]
[2,"Funding for 2024 Staff (FTE,LTE,IC) "]
[null,"Enter the total number of 2024 staff funded by each of the following categories:"]
[null,"County ","DATCP SWRM","All Other",null,null,"*TOTAL 2024 Staff"]
[null,null,null,null,null,{"$f":"+B75+C75+D75","v":0}]
[null,"*Total 2024 staff should be equal to the sum of FTE, LTE and IC staff listed in Table 1."]
[3,"2025 Work Plan"]
[null,"Each county must submit a current work plan that describes activities planned for 2025."]
[null,"Submissions must comply with the requirements identified by DATCP in separate communications. "]
[]
[null,"Work plans should be emailed by no later than April 15, 2025 to DATCPSWRM@wisconsin.gov. Grant applications will not be processed if work plans are not submitted, are incomplete, or fail to meet DATCP requirements."]
[]
[4,"2024 Annual Report "]
[null,"Reminder: To be eligible for 2026 funding, counties must electronically complete a 2024 Annual Report, which DATCP is requesting that counties submit by March 15, 2025. "]

{"sheet":"Table 1","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[6,8,7,8],[33,1,33,6],[36,0,36,7],[37,5,37,6],[44,0,45,2],[44,3,45,7],[39,0,39,7],[1,0,3,0],[1,5,1,6],[4,1,4,7],[5,2,5,3],[6,2,6,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7]]}
[null,null,null,null,"TABLE 1"]
[null,"DATCP 2026 STAFF APPLICATION DATA FOR",null,null,null,null,null,"COUNTY"]
[]
[]
[null,"COUNTY LCD STAFF POSITION INFORMATION FOR 2024"]
[null,"Column A","Column B",null,"Column C ~","Column D ~","Column E ~","Column F ~","Column G ~"]
[null,null,"Status",null,"Salary or Fee","Fringe (for employees -county contribution only)","% Time spent on conservation activities (see instructions)","Total eligible staffing costs (C+D) x E (Rounded to the nearest dollar)","This is the sum of the 4th and subsequent positions."]
["Position Number","Position Title ","Limited (LTE), Permanent (FTE), Independent Contractor (IC)","If not currently hired or retained*, insert expected fill date"]
[1,null,null,null,null,null,null,{"$f":"ROUND(((E9+F9)*G9),0)","v":0}]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0,{"$f":"SUM(H12:H33)","v":0}]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,{"$f":"((E28+F28)*G28)","v":0}]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H9:H33)","v":0}]
[]
[]
["By submitting a completed table with the joint grant application, the authorized county respresentative certifies that the information in this table is true, complete and accurate. "]
[]
[]
["~ Complete Columns A to E (highlighted in yellow) according to the instructions including provisions related to eligibility for claiming a person as position number 1, and the treatment of new or vacant positions."]
[]
["* Must attach evidence showing that the county has taken action (e.g. posting of position), consistent with an intent to"]
["rehire or fill a new position.  When filling vacant positions, salary cannot exceed rates paid for equivalent classification and"]
["benefits must be based on standard percentage used in county. Fees must be based on past payments made to contractors."]
["Explanation regarding projected salaries and benefits for positions hired during the year. "]
[]
["POSITION TITLES (Insert the letter A-E in column A that best describes position title of employee)"]
[]
["A = Department Head: County Conservationsist; Director; Administrator; Supervisor; Manager; Conservation Coordinator"]
["B = Administrative Support (Not eligible for first position): Clerk; Secretary; Admin. Assistant; GIS Specialist; Computer Programmer; Office Manager; Typist "]
["C = Technician: Project Manager/Coordinator; Specialist; Engineering Technician; Agronomist; Planner; Conservationist; Forester"]
["D = Engineer: Environmental; Project; Civil; Conservation"]
["E = Information & Education (Not eligible for first position): Education Coordinator; PR Representative"]

{"sheet":"OPTIONAL Innovation Grant App","index":2,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,9],[51,8,51,9],[46,2,46,5],[44,0,44,1],[45,6,45,7],[47,6,47,7],[41,8,41,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[47,2,47,5],[9,2,9,6],[2,3,2,9],[60,0,60,2],[44,6,44,7],[46,6,46,7],[51,2,51,3],[55,0,55,9],[50,6,50,7],[48,2,48,5],[51,0,51,1],[48,6,48,7],[49,2,49,5],[51,6,51,7],[47,0,47,1],[46,8,46,9],[45,8,45,9],[44,2,44,5],[45,2,45,5],[61,0,61,2],[49,0,49,1],[43,6,43,7],[43,0,43,1],[56,3,56,5],[50,0,50,1],[61,3,61,5],[49,6,49,7],[50,2,50,5],[60,3,60,5],[59,3,59,5],[58,3,58,5],[57,3,57,5],[56,0,56,2],[45,0,45,1],[59,0,59,2],[57,0,57,2],[58,0,58,2],[41,0,41,1],[41,6,41,7],[21,0,21,9],[33,0,33,9],[34,0,34,9],[40,0,40,9],[41,2,41,5],[47,8,47,9],[48,0,48,1],[42,0,42,1],[42,2,42,5],[43,2,43,5],[46,0,46,1],[42,6,42,7],[4,5,4,7],[4,8,4,9],[4,0,4,4],[3,0,3,4],[3,5,3,7],[3,8,3,9],[6,0,6,4],[13,2,13,3],[8,0,8,1],[5,5,5,7],[6,5,6,7],[8,2,8,9],[5,0,5,4],[9,0,9,1],[15,0,15,9],[11,0,11,3],[10,0,10,3],[10,6,10,8],[11,6,11,8]]}
["2026 SEG Innovation Grant Application (Optional)"]
["GENERAL INFORMATION"]
["Grant Applicant(s)"]
["Lead Contact Name",null,null,null,null,"E-Mail",null,null,"Phone Number"]
["                                               "]
["Mailing Address for Entity to be Paid",null,null,null,null,"City",null,null,"State","Zip"]
["                                               "]
["Application Type"]
["Proposal Title"]
["Amount Requested",null,"$"]
["Budget Attached?"]
["Workplan/Timeline Attached?"]
["Has Proposal Been Discussed with DATCP Staff?"]
[null,"Name"]
["PROPOSAL DESCRIPTION"]
["Please describe your proposed project. Maximum of 300 words. "]
[]
[]
[]
[]
["ANTICIPATED OUTCOMES"]
["Provide expected project outcomes, including nutrient load reductions, new partnerships or working agreements, goals for number of farmers or number of acres impacted, outcome of any support services provided, etc. List any anticipated deliverables from the project."]
[]
[]
[]
[]
["OUTREACH and EDUCATION "]
["Please describe how you plan to promote the project to landowners, if applicable.  "]
[]
[]
[]
[]
["ADDITIONAL INFORMATION"]
["Please provide any additional details about your proposal that will help reviewers assess the need and merit. This could include, but is not limited to:"]
["Additional descriptions or detail to support your proposal, including a description of partnerships with other agencies, agricultural or environmental groups or agricultural professionals to strengthen and leverage your efforts (ex. Implement dealers, crop consultants, UW-Extension agents, etc.) (Maximum 1 additional page)"]
["Letters of support for the project are welcome (no more than two as attachments to email)"]
[]
[]
[]
[]
["Budget Form"]
["Project Expenditures (Required)",null,"Practices (if applicable)",null,null,null,"Number (if applicable)",null,"Budgeted amount (required)"]
["Incentive Payments"]
["Supplies and Materials"]
["Equipment Rental"]
["Public Information"]
["Support/Training Services"]
["Other (please list)"]
["Other (please list)"]
["Other (please list)"]
["Other (please list)"]
["Total",null,null,null,null,null,{"$f":"SUM(G43:H51)","v":0},null,{"$f":"SUM(I43:J51)","v":0}]
[]
[]
[]
["Workplan / Timeline"]
["Conservation Activity",null,null,"Deliverables",null,null,"Q1","Q2","Q3","Q4"]
["Example: Cost-Share NM Plans",null,null,"1000 acres / 4 farmers",null,null,"x"]

{"sheet":"Sheet1","index":3,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["YES "]
["NO"]
[]
[]
["Password"]
["kcsl"]

{"sheet":"Sheet2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}