{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Form","Funding Program Eligible Types","Funding Program Details","Other potential programs","Front Page Template","Grant Report Template","Modification Instructions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Form","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[35,3,36,4],[16,3,17,4],[46,3,47,4],[16,8,17,9],[8,6,8,10],[9,5,9,9],[10,5,10,9],[11,5,11,9],[14,3,14,9],[7,5,7,10],[0,3,0,10],[1,3,1,10],[2,2,2,10],[5,5,5,10],[6,5,6,10]]}
[null,null,null,"\n"]
[null,null,null,"Funding Resource Evaluation Tool"]
[null,null,"This form is intended to assist in the evaluation of potential funding resources for various infrastructure projects.  \n\nTo utilize this tool, first ensure that macros are enabled so that the tool can run: \nClick File >> Options >> Trust Center >> Trust Center Settings >> Macro Settings >> 'Enable VBA macros'.  \nThen simply fill in the information below, check all project catagories that apply, and click 'Generate Report'.  A pdf report summarizing the funding opportunities will be generated in the designated location.\n\nDisclaimer: Funding resources and eligibility change on a regular basis. Check with the respective agency for the latest information.\nThis Version Updated: 9/23/2021"]
[]
[]
[null,null,null,null,"Community Name:","Smallville, KS"]
[null,null,null,null,"Project Name:","Example Project"]
[null,null,null,null,"Date:",{"$f":"TODAY()","v":"2021-09-23"}]
[null,null,null,null,"Output Folder Location for PDF Report:",null,"C:\\temp"]
[]
[]
[]
[]
[]
[null,null,null,"Project Types (Check all that apply)"]
[]
[null,null,null,"Flood Mitigation ",null,null,null,null,"Multi-objective & Resiliency"]
[]
[null,null,null,null,"Property Acquisition and Structure Demolition",null,null,null,null,"Stream Stabilization"]
[null,null,null,null,"Property Acquisition and Structure Relocation",null,null,null,null,"Floodplain and Stream Restoration"]
[null,null,null,null,"Mitigation Reconstruction",null,null,null,null,"Aquatic Ecosystem Restoration"]
[null,null,null,null,"Structure Elevation",null,null,null,null,"Shoreline Protection"]
[null,null,null,null,"Structural Retrofitting of Existing Buildings",null,null,null,null,"Watershed Protection/Enhancement"]
[null,null,null,null,"Non-Structural Retrofitting of Existing Buildings",null,null,null,null,"Flood Detection and Warning"]
[null,null,null,null,"Critical Facility/Lifeline Protection",null,null,null,null,"Parks"]
[null,null,null,null,"Infrastructure Retrofit",null,null,null,null,"Bike Paths"]
[null,null,null,null,"Dry Floodproofing of Historic Structures",null,null,null,null,"Open Space Acquisition"]
[null,null,null,null,"Dry Floodproofing of Non-Residential Structures",null,null,null,null,"Floodplain Easement"]
[null,null,null,null,"Channel Improvements",null,null,null,null,"Mitigation Planning"]
[null,null,null,null,"Hydrology & Hydraulics Studies",null,null,null,null,"Risk and Consequence Assessments"]
[null,null,null,null,"Bridge Improvements",null,null,null,null,"Public education and Risk Awareness"]
[null,null,null,null,"Culvert Improvements",null,null,null,null,"Emergency and Evacuation Planning"]
[null,null,null,null,"Road Protection",null,null,null,null,"Codes and Standards"]
[null,null,null,null,null,null,null,null,null,"Risk and Resilience Planning"]
[null,null,null,null,null,null,null,null,null,"Master Planning"]
[null,null,null,"Flood Control",null,null,null,null,null,"Wetland Restoration/Creation"]
[null,null,null,null,null,null,null,null,null,"Project Scoping"]
[null,null,null,null,"Levees",null,null,null,null,"Partnership and Capacity Building"]
[null,null,null,null,"Floodwater storage and diversion",null,null,null,null,"Non-Financial Technical Assistance"]
[null,null,null,null,"Localized Flood Risk Reduction Projects",null,null,null,null,"Phased Projects"]
[null,null,null,null,"Regional Flood Risk Reduction",null,null,null,null,"Water Resources Enhancement"]
[null,null,null,null,"Channel clearing, obstruction removal",null,null,null,null,"Agricultural Water Management"]
[null,null,null,null,"Dams (New Constuction)",null,null,null,null,"Other Multi-Purpose"]
[null,null,null,null,"Dam Rehabilitation and Safety Improvements"]
[]
[]
[null,null,null,"Stormwater Improvements"]
[]
[null,null,null,null,"Detention/Retention"]
[null,null,null,null,"Green Infrastructure"]
[null,null,null,null,"Stormwater Management"]
[null,null,null,null,"LID"]

{"sheet":"Funding Program Eligible Types","index":1,"n_rows":21,"n_cols":58,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Funding Agency","Administrating Agency","Funding Programs","Flood Mitigation ","Property Acquisition and Structure Demolition","Property Acquisition and Structure Relocation","Mitigation Reconstruction","Structure Elevation","Structural Retrofitting of Existing Buildings","Non-Structural Retrofitting of Existing Buildings","Critical Facility/Lifeline Protection","Infrastructure Retrofit","Dry Floodproofing of Historic Structures","Dry Floodproofing of Non-Residential Structures","Channel Improvements","Hydrology & Hydraulics Studies","Bridge Improvements","Culvert Improvements","Road Protection","Flood Control","Levees","Floodwater storage and diversion","Localized Flood Risk Reduction Projects","Regional Flood Risk Reduction","Channel clearing, obstruction removal","Dams (New Constuction)","Dam Rehabilitation and Safety Improvements","Stormwater Improvements","Detention/Retention","Green Infrastructure","Stormwater Management","LID","Multi-objective & Resiliency","Stream Stabilization","Floodplain and Stream Restoration","Aquatic Ecosystem Restoration","Shoreline Protection","Watershed Protection/Enhancement","Flood Detection and Warning","Parks","Bike Paths","Open Space Acquisition","Floodplain Easement","Mitigation Planning","Risk and Consequence Assessments","Public education and Risk Awareness","Emergency and Evacuation Planning","Codes and Standards","Risk and Resilience Planning","Master Planning","Wetland Restoration/Creation","Project Scoping","Partnership and Capacity Building","Non-Financial Technical Assistance","Phased Projects","Water Resources Enhancement","Agricultural Water Management","Other Multi-Purpose"]
["DHS-FEMA","KDEM","Building Resilient Infrastructure and Communities (BRIC)",null,"x","x","x","x",null,null,"x","x",null,"x","x","x","x","x","x",null,"x","x","x","x",null,null,"x",null,"x","x","x","x",null,"x","x",null,"x","x",null,null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,"x","x"]
["DHS-FEMA","KDEM","Flood Mitigation Assistance (FMA)",null,"x","x","x","x","x","x","x","x",null,"x","x","x","x","x",null,null,null,"x","x",null,null,null,null,null,"x",null,null,null,null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,"x","x",null,"x",null,null,null,"x"]
["DHS-FEMA","KDEM","Hazard Mitigation Grant Program (HMGP)",null,"x","x","x","x","x","x","x","x",null,"x","x","x","x","x","x",null,"x","x","x","x",null,null,null,null,"x","x","x",null,null,"x","x",null,"x","x","x","x",null,null,null,"x",null,null,null,null,null,null,"x","x",null,null,"x"]
["DHS-FEMA","KDEM","Hazard Mitigation Grant Program Post Fire (HMGP Post Fire)",null,"x","x","x","x","x","x","x","x",null,"x","x","x","x","x","x",null,null,null,"x",null,null,null,null,null,"x","x","x",null,null,"x","x",null,"x","x","x","x",null,null,null,"x",null,null,null,null,null,null,"x","x",null,null,null,null,null,"x"]
["DHS-FEMA","KDA-DWR","High Hazard Potential Dams (HHPD)",null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,"x","x","x","x",null,"x","x",null,"x",null,null,"x"]
["USACE","USACE","Flood Damage Reduction Projects ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x",null,"x",null,"x",null,null,null,null,null,null,null,null,null,null,"x"]
["USACE","USACE","Flood-Related Continuing Authorities Programs ",null,null,null,null,null,null,null,null,null,null,null,"x","x","x",null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,"x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["USACE","USACE","Silver Jackets Program",null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,"x","x","x","x",null,"x",null,null,"x","x","x",null,null,null,"x"]
["USDA-NRCS","USDA-NRCS","Watershed and Flood Prevention Operations  (WFPO)  program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x",null,"x",null,"x",null,null,null,null,null,null,null,"x","x",null,null,"x",null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x"]
["USDA-NRCS","USDA-NRCS","Emergency Watershed Protection - Floodplain Easement (EWP-FPE)",null,"x","x",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,"x","x"]
["EPA","EPA","Water Infrastructure Finance and Innovation Act (WIFIA)",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,"x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,"x"]
["EPA","KDHE","Clean Water State Revolving Fund ",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,"x","x","x","x",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,"x"]
["HUD","KDC","Community Development Block Grant (CDBG)",null,"x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["HUD","KDC","Community Development Block Grant−Disaster Recovery (CDBG-DR) ",null,"x","x","x","x","x","x","x","x",null,null,null,null,null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["HUD","KDC","Community Development Block Grant Section 108 Loan Guarantees ",null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,"x",null,null,null,null,"x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["KDOT","KDOT","Kansas Local Bridge Improvement Program (KLBIP)",null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x",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,null,null,"x"]
["FHWA","KDOT","Surface Transportation Block Grant Program (STBG)",null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["FHWA","KDWPT","Recreational Trails Grant",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,null,"x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["LWCF","KDWPT","Land and Water Conservation Fund Grant",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,"x",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["KDA","KDA- Division of Conservation","Watershed Dam Construction Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,"x",null,"x","x",null,"x",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]

{"sheet":"Funding Program Details","index":2,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Program Name","Purpose","Eligibility Requirements","Funding Priorities","Funding Level","Cost Share Requirements","Benefit Cost Analysis Requirements","Environmental Review Requirements","Program Trigger","Action Needed to Access Program","Application period","Period of Performance","Application Submittal","Website","Contact","Agency","Maximum Project Assistance","Type of Assistance","Pre-award costs Eligible?"]
["Building Resilient Infrastructure and Communities (BRIC)","The Building Resilient Infrastructure and Communities (BRIC) program makes federal funds available to states, U.S territories, Indian tribal governments, and local communities for pre-disaster mitigation activities. The guiding principles of the program are to: (1) support state and local governments, tribes, and territories through capability- and capacity-building to enable them to identify mitigation actions and implement projects that reduce risks posed by natural hazards; (2) encourage and enable innovation while allowing flexibility, consistency, and effectiveness; (3) promote partnerships and enable high-impact investments to reduce risk from natural hazards with a focus on critical services and facilities, public infrastructure, public safety, public health, and communities; (4) provide a significant opportunity to reduce future losses and minimize impacts on the Disaster Relief Fund (DRF); and (5) support the adoption and enforcement of building codes, standards, and policies that will protect the health, safety, and general welfare of the public, take into account future conditions , and have long-lasting impacts on community risk-reduction, including for critical services and facilities and for future disaster costs. ","State governments\nNative American tribal governments (Federally recognized)\nDistrict of Columbia; U.S. Territories. Additional Information on Eligibility: Local governments must apply through their state or territory. Applicants and subapplicants required to have a current FEMA-approved Hazard Mitigation Plan at time of application and award. States have requirements and deadlines for Notices of Intent by interested subapplicants.","incentivize public infrastructure projects;\nincentivize projects that mitigate risk to one or more lifelines;\nincentivize projects that incorporate nature-based solutions; and,\nincentivize adoption and enforcement of modern building codes.","In FY20 BRIC, FEMA will provide State/Territory allocations of $500M to states and territories and a Tribal Set-Aside of $20M for Indian tribal governments (federally-recognized) for mitigation projects and capability- and capacity-building (C&CB) activities. Any funds which are not awarded from the State/Territory Allocation or Tribal Set-Aside will be re-allocated to the national competition for mitigation projects.","75% federal/25% non-federal Potential for 90%/10% for small impoverished communities","Applicants and subapplicants applying for mitigation projects must provide a BCA or other documentation that validates cost-effectiveness","Applicants and subapplicants applying for mitigation projects must provide information needed to comply with the National Environmental Policy Act (NEPA) and related DHS and FEMA instructions and directives","Annual appropriations. BRIC receives funding through an offsetting of annual presidential disaster declarations nationwide.","Notice of Intent submitted to State Emergency Management. Grant subapplication. State submits final application.","FY20 opens September 30, 2020; State application due January 29, 2021; Notice of Intent and subapplication deadlines vary by state. Kansas Division of Emergency Management NOI due date is September 30. Pre-Award Selection Notice: Anticipated in June 2021","36 months from the date of the Award ","FEMA Grant Outcomes (FEMA GO) system: https://go.fema.gov","www.fema.gov/bric hhttps://www.fema.gov/media-collection/resources-building-resilient-infrastructure-communities-program-bricttps://www.fema.gov/sites/default/files/2020-08/fema_mitigation-action-portfolio-support-document_08-01-2020_0.pdf https://www.fema.gov/media-collection/resources-building-resilient-infrastructure-communities-program-bric","Kansas Division of Emergency Management State Hazard Mitigation Officer \nJeanne Bunting: jeanne.l.bunting.nfg@mail.mil","DHS-FEMA","$50M","Grant","Yes subject to approval"]
["Flood Mitigation Assistance (FMA)","Program is limited to flood-related mitigation that reduces the risk of properties that repetitively flood and to lessen future insurance claims for the NFIP","State governments\nNative American tribal governments (Federally recognized)\nDistrict of Columbia; U.S. Territories. Additional Information on Eligibility: Local governments must apply through their state or territory. Applicants and subapplicants required to have a current FEMA-approved Hazard Mitigation Plan at time of application and award. States have requirements and deadlines for Notices of Intent by interested subapplicants. Subapplicants must also participate in the National Flood Insurance Program (NFIP) (Not on probation or suspended). All structures included in the project subapplications must be insured under the NFIP (Before, During, and After).","FY20 Priorities: 1. Project scoping (previously Advanced Assistance) 2. Community Flood Mitigation Projects 3. Technical Assistance 4. Flood Hazard Mitigation Planning 5. Individual Flood Mitigation Projects with emphasis on repetitive loss properties","FY20 $160M","For NFIP insured properties and planning grants:\n75%/25%.\nFor repetitive loss property with repetitive loss strategy:\n90%/10%.\nFor severe repetitive loss property with repetitive loss strategy:\n100%/0%.","Applicants and subapplicants applying for mitigation projects must provide a BCA or other documentation that validates cost-effectiveness","Applicants and subapplicants applying for mitigation projects must provide information needed to comply with the National Environmental Policy Act (NEPA) and related DHS and FEMA instructions and directives","Annual appropriations. FMA receives funding through an offsetting collection\nof NFIP premiums in annual appropriation acts.","Notice of Intent submitted to State Emergency Management. Grant subapplication. State submits final application.","FY20 opens September 30, 2020; State application due January 29, 2021; Notice of Intent and subapplication deadlines vary by state. Pre-Award Selection Notice: Anticipated in June 2022","36 months from the date of selection. ","FEMA Grant Outcomes (FEMA GO) system: https://go.fema.gov","https://www.fema.gov/grants/mitigation/floods","Kansas Division of Emergency Management State Hazard Mitigation Officer \nJeanne Bunting: jeanne.l.bunting.nfg@mail.mil","DHS-FEMA","$30M. Various restrictions exist on maximum awards depending on the type of activity funded","Grant","Yes subject to approval"]
["Hazard Mitigation Grant Program (HMGP)","To reduce risk to individuals and property while reducing reliance on future federal disaster response and recovery funds. Eligible projects may include, but are not limited to, property acquisition, structure demolition, floodproofing of structures, structure relocation, structure elevation, mitigation, and localized and nonlocalized flood risk reduction projects. In late 2018 in Section 1210(b) of P.L. 115-254, Congress authorized that HMGP funds could be used toward the federal share of construction for authorized U.S. Army Corps of Engineers water resource projects if such activities are eligible under HMGP. On June 27, 2014, FEMA issued new policy guidance for eligible projects including major flood control projects (dams, levees, etc.), provided there is not duplication with another federal program.","Funding is provided to all 50 states, Indian reservations, DC, American Samoa, Guam, Northern Marianas, Puerto Rico, and Virgin Islands. Grants to state agencies, federally recognized tribes, local governments, and certain private nonprofit organizations for mitigation projects as well as mitigation planning. Applicants and subapplicants required to have a current FEMA-approved Hazard Mitigation Plan at time of award. States have requirements and deadlines for Notices of Intent by interested subapplicants. Subapplicants must also participate in the National Flood Insurance Program (NFIP) (Not on probation or suspended). ","Varies by disaster and state discretion. States may prioritize projects within the declared counties, though typically the funding is open to all eligible subapplicants. Other priorities might be associated with the type of disaster, e.g. flood mitigation projects for a flood-related disaster.","The total amount of HMGP funding is derived from a formula in law based on\nthe total amount of other grant assistance provided through the Stafford Act\n(§404(s) of the Stafford Act, 42 U.S.C. §170c). In summary, it is as follows:\n 15% for amounts not more than $2 billion; 10% for amounts of more than $2 billion and not more than $10 billion; and 7.5% on amounts of more than $10 billion and not more than $35.333 billion of the estimated aggregate amount of grants to be made (less any associated administrative costs).\nStates that have an Enhanced State Hazard Mitigation Plan under Section 322(e)\nof the Stafford Act receive 20% of the total amount. ","75% federal/25% non-federal ","Applicants and subapplicants applying for mitigation projects must provide a BCA or other documentation that validates cost-effectiveness","Applicants and subapplicants applying for mitigation projects must provide information needed to comply with the National Environmental Policy Act (NEPA) and related DHS and FEMA instructions and directives","Triggered by a Stafford Act major disaster declaration by the President.","Notice of Intent submitted to State Emergency Management. Grant subapplication. State submits final application. Funds are typically made available statewide in the state that received the declaration, not just in the declared counties.","Applications are due within 1 year of disaster declaration. Application period begins when HMGP is authorized, typically the date of the disaster declaration.","36 months from the close of the application period. ","Follow guidelines by State Emergency Management.","https://www.fema.gov/hazardmitigation-grant-program https://www.fema.gov/grants/mitigation/floods/fma-resources","Kansas Division of Emergency Management State Hazard Mitigation Officer \nJeanne Bunting: jeanne.l.bunting.nfg@mail.mil","DHS-FEMA","Varies depending on the type of activity funded, extent of total funding available from the disaster, and state priorities/limits.","Grant","Yes subject to approval"]
["Hazard Mitigation Grant Program Post Fire (HMGP Post Fire)","FEMA encourages the mitigation of wildfire and related hazards. Eligible project types may include defensible space measures, ignition-resistant construction, hazardous fuels reduction, erosion control measures, slope failure prevention measures, and flash flooding measures.","States, federally-recognized tribes and territories affected by fires resulting in an Fire Management Assistance Grant (FMAG) declaration on or after October 5, 2018, are eligible to apply. Applicants and subapplicants required to have a current FEMA-approved Hazard Mitigation Plan at time of award. ","Funding will first be made available to the county or counties that received an FMAG declaration. Funding will first be prioritized in the declared or burned area(s). A project may be outside of this area as long as the risk reduction benefits the declared county or counties (e.g., watershed mitigation). If funding cannot be used in the affected area, then it may be available statewide regardless of whether it benefits a declared county and it can be used for non fire related projects at the discretion of the State.","The funding amount available will be provided by FEMA, and is a national aggregate calculation based on an average of historical FMAG declarations from the last 10 years. This amount will be recalculated at the beginning of every fiscal year. The total HMGP funding available for each FMAG declaration is currently $454,432 for Applicants with a standard hazard mitigation plan, and $605,909 for Applicants with an enhanced hazard mitigation plan.","75% federal/25% non-federal ","Applicants and subapplicants applying for mitigation projects must provide a BCA or other documentation that validates cost-effectiveness. Pre-calculated benefits of $5,250 per acre are available for the following post-wildfire mitigation project types:\n\nSoil stabilization\nFlood diversion\nReforestation project","Applicants and subapplicants applying for mitigation projects must provide information needed to comply with the National Environmental Policy Act (NEPA) and related DHS and FEMA instructions and directives","Triggered by a Fire Management Assistance Grant declaration","Notice of Intent submitted to State Emergency Management. Grant subapplication. State submits final application.","The application period opens with the state or territory's first FMAG declaration of the fiscal year and closes six months after the end of that fiscal year. Application extensions may be requested.","36 months from the close of the application period. ","Follow guidelines by State Emergency Management.","https://www.fema.gov/grants/mitigation/post-fire","Kansas Division of Emergency Management State Hazard Mitigation \nOfficer \nJeanne Bunting: jeanne.l.bunting.nfg@mail.mil","DHS-FEMA","Varies depending on the type of activity funded, extent of total funding available from the disaster, and state priorities/limits.","Grant","Yes subject to approval"]
["High Hazard Potential Dams (HHPD)","The Rehabilitation of High Hazard Potential Dams Grant Program provides technical, planning, design, and construction assistance in the form of grants for rehabilitation of eligible high hazard potential dams. Includes repair removal, or any other structural or nonstructural measures to rehabilitate an eligible high hazard potential dam.","Eligible dams are Non-federal dams that are located in a state with a state dam safety program\n• Are classified as “high hazard potential”\n• Have an emergency action plan\n• Poses an unacceptable risk to the public Participate in, and comply with, all applicable Federal flood insurance programs. Have a hazard mitigation plan that includes all dam risks. Commit to provide operation and maintenance of the project for the 50-year period following completion of rehabilitation. Acts in accordance with the State dam safety program. Comply with the 42 CFR\u000bSection 5196(j)(9) regarding labor and wage rates under contracts. Have a floodplain management plan to reduce the impacts of future flood events in the area protected by the project.","The applicant has the authority and demonstrates the expertise necessary to fulfill the requirements\nof the HHPD.\n• The dams included on the applicant’s list of eligible dams meet eligibility criteria.\n• The applicant’s risk-based prioritization method meets minimum FEMA requirements\n• The applicant’s proposed work plan employs sound concepts and techniques, and realistic timetables.\n• Proposed projects improve the safety of the dam and are deliverable, sustainable, and compatible with the goals of the HHPD.\n• The applicant proposes costs that are complete, reasonable, and cost-effective in relation to proposed projects and tasks.","Subject to annual appropriations. In FY19 and FY20, FEMA appropriated $10,000,000 million ","Non-federal cost share requirement of not less than 35 percent, which may be in-kind.","None","Applicants and subapplicants applying for mitigation projects must provide information needed to comply with the National Environmental Policy Act (NEPA) and related DHS and FEMA instructions and directives","Annual notice of funding opportunity per the Water Infrastructure Improvements for the Nation Act or the “WIIN Act,” on December 16, 2016,","Contact state dam safety program","Anticipated release of the Notice of Funding Opportunity for the HHPD will be published in May with a 60-day application period.","36 months from the close of the application period. ","Follow guidelines by state dam safety program. Kansas Department of Agriculture Division of Water Resources Dam Safety","https://www.fema.gov/emergency-managers/risk-management/dam-safety/grants#hhpd","Kansas Department of Agriculture Division of Water Resources Dam Safety","DHS-FEMA","A grant under this program should not exceed the lesser of (i) 12.5 percent of the total amount of funds made available; or (ii) $7,500,000.","Grant","Yes subject to approval"]
["Flood Damage Reduction Projects ","Improvements that reduce riverine and coastal storm damages. These improvements are pursued as individual projects rather than under an authorized national program. Flood-damage reduction works, typically engineered works (e.g., levees, engineered dunes and beaches, storm surge gates and dams).","Project-specific congressional authorization determines the geographic scope of the project. USACE has participated in projects in all states, some Indian Reservations, DC, American Samoa, Guam, Commonwealth of the Northern Marianas Islands, Puerto Rico, and U.S. Virgin Islands.","Projects generally are required to have national benefits exceeding costs, or address public safety concerns","Annual appropriations are typically provided in annual Energy & Water\nDevelopment appropriations acts. FY2019 included $946 million for flood-related study and construction ($97 million for coastal studies and construction, $849 million for riverine studies and construction).","Study: typically 50%/50%. \nConstruction: typically 65%/35%. \nCoastal periodic nourishment: 50%/50%.\nOperations and maintenance (O&M): O&M is a nonfederal responsibility for most projects ","Projects generally are required to have national benefits exceeding costs, or address public safety concerns","Yes","Annual appropriations; supplemental appropriations.","For annual appropriations, inclusion in the Administration’s work plan for USACE for enacted appropriations is required. For a USACE study, congressional study authorization and nonfederal cost-share of study is required. For a USACE construction project, project-specific congressional construction authorization and nonfederal cost-share of construction is required.\nFor USACE funds provided in P.L. 116-20, the Administration selects the USACE studies and projects to fund from among those that meet the geographic eligibility identified in P.L. 116-20. For P.L. 116-20 construction funds, either a project-specific congressional authorization or a determination by the Secretary of the Army that the project is technically feasible, economically justified, and environmentally acceptable is required.","NA","NA","NA","http://www.usace.army.mil/Missions/Civil-Works/Project-Planning/WRRDA-\n7001-Proposals/\nhttp://www.iwr.usace.army.mil/Missions/Flood-Risk-Management/Flood-Risk- Management-Program/\nTo identify USACE district, use http://www.usace.army.mil/Locations/",null,"USACE","Amount depends on project-specific authorization of appropriations","USACE study and construction, or credit or reimbursement for federal portion of nonfederal-led study and construction project.","NA"]
["Flood-Related Continuing Authorities Programs ","Under authorized Continuing Authorities Programs (CAPs), USACE may study and construct certain improvements without additional project-specific congressional authorization. The purpose of the CAP is to plan and implement projects of limited size, cost, scope and complexity. The table below lists the CAP authorities and their project purposes. Caps are known by the section number of the law in which they were authorized. The four flood-related CAPs are for projects that: (§205) reduce flood damages (using structural and nonstructural approaches); (§103) reduce beach erosion and hurricane storm damage; (§14) protect public works and nonprofit services affected by streambank and shoreline erosion; or (§111) mitigate shore damage from federal navigation projects.","Sections 205, 14, and 11 are open to all of the United States and Indian Reservations and have been interpreted as being open to territorial possessions. Section 103 is open to activities associated with the shores and beaches of the United States, Indian reservations, and U.S. territories and possessions.","All projects in this program include a feasibility phase and an implementation phase. Planning activities, such as development of alternative plans to achieve the project goals, initial design and cost estimating, environmental analyses, and real estate evaluations, are performed during the feasibility phase, to develop enough information to decide whether to implement the project. Flood damage reduction works, often engineered infrastructure, that fall within the authority of the specific CAP, subject to the availability of appropriations.\nProjects generally are required to have national benefits exceeding costs, or address public safety concerns, as well as be technically feasible and comply with federal environmental and resource statutes.","Annual appropriations are typically provided in annual Energy & Water\nDevelopment appropriations acts. ","Study: (§205, §103 and §14): 50%/50% after first $100,000, which is 100% federal; (§111): Same as the federal project causing the damage; Study costs are 100% federal if using P.L. 116-20 funds.\nConstruction: (§205, §103 and §14): 65%/35%; (§111): Same as the federal project causing the damage; When using P.L. 116-20 funds, construction costs are 100% federal for projects ongoing construction projects; for projects other than ongoing construction projects, typical cost sharing applies when using P.L. 116-20 monies.\nOperations & Maintenance: Operation and maintenance is a nonfederal responsibility.","Projects generally are required to have national benefits exceeding costs, or address public safety concerns, as well as be technically feasible and comply with federal environmental and resource statutes.","Yes","Annual appropriations; supplemental appropriations.","State, tribal, or local government agency may submit to the local USACE\ndistrict a written request for work under a CAP authority. USACE identifies and selects eligible projects for funding using enacted appropriations for the CAP program. Demand for CAP projects often exceeds federal funds.\nFor P.L. 116-20 funds, the Administration selects which activities to fund from among USACE studies and projects that meet (1) geographic eligibility identified in P.L. 116-20 and (2) specific per-project federal cost limits and other limitations of the CAP programs.","NA","NA","NA","No national USACE CAP website; to identify USACE district, use http://www.usace.army.mil/Locations/",null,"USACE","Federal assistance for a project (including projects using P.L. 116-20 funds)\ncannot exceed the following: (§205): $10 million; (§103): $10 million; (§14): $5 million; and (§111): $10 million.","USACE study and construction of cost-shared projects.","NA"]
["Silver Jackets Program","The U.S. Army Corps of Engineers Silver Jackets Program has been coordinating with the Kansas Hazard Mitigation Team since 2009 offering technical services to help communities manage flood risks with the annual call for “interagency nonstructural” proposals. The goal is to assign USACE staff to help find collaborative and solutions to reduce flood impacts to communities, addressing consequences, and building on interagency work. Reducing consequences in floodplains with nonstructural measures. Acceptable products include: Pamphlets or publications for risk communication & public outreach\n• Innovative mapping                               • Training workshops                               • Tabletop exercises                           • Meeting facilitation\n• Enhanced coordination                        • Evaluations, screening measures   • Floodplain management plans  • Emergency action plans \n• Assessment tools and processes     • Methods that apply improved coordination ","Community staff at the county or city level, whether floodplain managers, emergency managers, or elected officials can begin a proposal with the state and the Lead Silver Jackets Coordinator. In Kansas, the KDA Division of Water Resources staff lead in selecting proposals that address Kansas top priorities (see Funding Priorities). At least two partners besides USACE are required, and local efforts are matched to USACE. ","The Silver Jackets efforts will support flood mitigation actions and the goals in the state hazard mitigation plan:\nGoal 1: Minimize the vulnerability of the people, property, environment, and economy of Kansas and its communities to the impacts of natural and manmade hazards. \nGoal 2: Build the mitigation capabilities of local governments throughout Kansas in establishing and implementing effective mitigation plans, policies, and programs\nGoal 3: Promote a state policy framework for effective hazard mitigation programming in the state\nGoal 4: Improve education and training in hazard mitigation and related programs for government officials, businesses, and the public.\nMore specific flood mitigation strategies, as noted in the Kansas 2018 Mitigation Actions, are to Mitigate repetitive flood loss and severe repetitive flood loss structures; Develop inundation maps for high hazard dams; Assist with development of emergency action plans for high hazard dams; Participate in the National Flood Insurance Program and Community Rating System; Prioritize and develop floodplain mapping studies; Improve coordination between the Kansas Water Plan and the Kansas Hazard Mitigation Plan; Conduct mitigation outreach activities to all government agencies and public and private organizations within the State; Support the improvement and accreditation of community flood control levees.","Technical Assistance Partnership","NA","NA","NA","This is the USACE Civil Works program enabling participation in the KHMT. The Lead Silver Jackets Coordinator for Kansas directly participates on the Kansas Hazard Mitigation Team, representing all the USACE districts within the state at the team's regular meetings. Kansas City District has the Lead Silver Jackets Coordinator for Kansas and Missouri. Each district also has a Silver Jacket Coordinator. The lead coordinator provides regular status updates, available on request. The status updates provide detail information on active USACE projects and programs, including specific project information that is useful during the FEMA Risk MAP Discovery Phases. ","Begin a proposal by emailing  Kansas Lead Silver Jackets Coordinator email: MOKAN.SilverJackets@usace.army.mil","1st quarter annually; 2020 applications were due March 10.","12-18 months","Begin a proposal by emailing  Kansas Lead Silver Jackets Coordinator email: MOKAN.SilverJackets@usace.army.mil","https://silverjackets.nfrmp.us/State-Teams/Kansas","Kansas Lead Silver Jackets Coordinator: MOKAN.SilverJackets@usace.army.mil","USACE","Not a grant: But a proposal will gain USACE assistance (typical value from $30,000 to $150,000).","USACE technical assistance","NA"]
["Watershed and Flood Prevention Operations (WFPO) program","WFPO provides technical and financial assistance to states, Indian tribes or tribal organizations, and local organizations to plan and install watershed projects. WFPO can include other water quality and water resources purposes. Eligible projects include land treatment, and nonstructural and structural facilities for flood prevention and erosion reduction. Structural measures can include dams, levees, canals, and pumping stations.","Projects in all 50 states, Indian Reservations, DC, American Samoa, Guam, Northern Marianas, Puerto Rico, and Virgin Islands.","Eligible projects include land treatment, and nonstructural and structural facilities for flood prevention and erosion reduction. Structural measures can include dams, levees, canals, and pumping stations.","Annual appropriations typically are provided in annual Agricultural and\nRelated Agencies appropriations acts.","The federal government pays all costs related to construction for flood control purposes only. Costs for nonagricultural water supply must be repaid by local organizations; however, up to 50% of costs for land, easements, and rights-of-way allocated to public fish and wildlife and recreational developments may be paid with program funds. Local sponsors agree to operate and maintain completed projects.","Principles and Requirements for Federal Investments in Water Resources (P&R) and Interagency Guidelines (IAG) or collectively PR&G analysis, apples on a project basis if meets financial threshold for required analysis.","Yes","Program appropriations in enacted legislation and permanently authorized mandatory funding.","Authorization of approved watershed plans can be (1) requested from sponsoring organizations; (2) congressionally directed; or (3) authorized by the Chief of NRCS. After approval, technical and financial assistance can be provided for installation of works of improvement specified in the plans, subject to annual appropriations.","NA","NA","NA","https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/programs/landscape/\nwfpo/",null,"USDA-NRCS","No project may exceed 250,000 acres, c and no structure may exceed more than 12,500 acre-feet of floodwater detention capacity, or 25,000 acre-feet of total capacity without congressional approval. Congressional approval is also required when a project includes an estimated federal contribution of more than $25 million for construction, or includes a storage structure with a capacity in excess of 2,500 acre-feet. There are no population or community income-level limits on applications for WFPO; however, at least 20% of the total benefit of the project must directly relate to agriculture (including rural communities).","Grant; technical advisory services","NA"]
["Emergency Watershed Protection - Floodplain Easement (EWP-FPE)","Separate from the general EWP program, floodplain easements are meant to safeguard lives and property from future floods, drought, and the products of erosion through the restoration and preservation of the land’s natural values.","Projects in all 50 states, Indian Reservations, DC, American Samoa, Guam, Northern Marianas, Puerto Rico, and Virgin Islands. A permanent easement is the only enrollment option under EWPP-FPE. Permanent floodplain easements are available on the following types of land:\n\nAgricultural or open lands. NRCS will pay up to the entire cost of the easement value and up to the entire cost for easement restoration.\n \nLands primarily used for residential housing. In these cases, NRCS will pay up to the entire easement value and up to the entire cost of the structure's value if the landowner chooses to have it demolished. If the landowner prefers to relocate the residence instead of demolishing it, NRCS will pay all costs associated with relocating the residence to a location outside the floodplain. A project sponsor is required for lands primarily used for residential housing and for the purchase of the remaining lot after structures are removed.","A major goal of EWPP–FPE is to restore the land, to the maximum extent possible, to its natural condition. Restoration techniques include the use of structural and non-structural practices to restore the flow and storage of floodwaters, control erosion, and to improve management of the easement.","Program appropriations in enacted legislation.","The federal government can provide up to 100% of restoration costs and up to 75% of building removal costs. Federal easement payments are limited to the lowest amount identified using the three valuation methods described under “Maximum Project Assistance.”","NA","NA","Program appropriations in enacted legislation.","Contact local NRCS field office; online program signup forms on website.","NA","NA","Contact local NRCS field office; online program signup forms on website.","https://www.nrcs.usda.gov/wps/portal/nrcs/main/national/programs/landscape/\newpp/","Program Manager Jeff Williams, Easement Programs Division, \nJeff Williams: 202-720-6268, jeff.williams3@usda.gov","USDA-NRCS","Landowners receive the smallest of the following values as an easement payment: (1) a geographic area rate established by the NRCS; (2) the fair- market value based on an area-wide market analysis or an appraisal completed according to the Uniform Standards of Professional Appraisal Practices; or (3) the landowner’s offer.","Floodplain easement","NA"]
["Water Infrastructure Finance and Innovation Act (WIFIA)","Program helps finance water infrastructure projects, including projects to build and upgrade wastewater and drinking water treatment systems. WIFIA provides credit assistance to large water projects that may otherwise have difficulty obtaining financing. Eligible projects include (among others) all categories eligible for State Revolving Fund assistance, including measures to manage, reduce, treat, or recapture stormwater, which may provide flood resilience and risk reduction benefits.","In general, project costs must be $20 million or larger to be eligible for WIFIA credit assistance, and WIFIA loan assistance is generally limited to 49% of eligible costs. Eligible entities include a corporation; partnership; joint venture; trust; or a federal, state, local, or tribal government (or consortium of tribal governments). Projects in all 50 states, the District of Columbia, Indian lands, and U.S. territories.","EPA announces the amount of funding it will have available and solicits letters of interest from prospective borrowers. In their letters of interest, prospective borrowers demonstrate their project's eligibility, creditworthiness, engineering feasibility, readiness to proceed, and alignment with EPA’s policy priorities. Based on this information, EPA selects projects which it intends to fund and invites the prospective borrowers to continue to the application process. ","For FY 2020, EPA has approximately $6 billion in WIFIA loans to finance approximately $12 billion in water infrastructure investment. Authorized by Water Resources Reform and Development Act of 2014, Title V, codified in\n33 U.S.C. §§3901-3914. America’s Water Infrastructure Act of 2018, Title IV, included additional authorization. Regulations are codified at 40 C.F.R.\n§35.10000.","WIFIA loan assistance is generally limited to 49% of eligible costs. ","NA",null,"Credit assistance awarded by EPA on competitive basis.","Eligible entities submit credit assistance application to EPA. Phase 1: Project Selection: EPA announces the amount of funding it will have available and solicits letters of interest from prospective borrowers. In their letters of interest, prospective borrowers demonstrate their project's eligibility, creditworthiness, engineering feasibility, readiness to proceed, and alignment with EPA’s policy priorities. Based on this information, EPA selects projects which it intends to fund and invites the prospective borrowers to continue to the application process. \n\nPhase 2: Project Review, Negotiation, and Closing: Each invitee must apply for its WIFIA loan. The WIFIA program conducts a detailed financial and engineering review of the project. Based on that review, the WIFIA program proposes terms and conditions for the project and negotiates them with the applicant until they develop a mutually agreeable term sheet and loan agreement. ","Letter of Interest for FY202 WIFIA due October 15, 2020. EPA will invite each prospective borrower whose project proposal is selected for continuation in the process to submit a final application. Final applications should be received by EPA within 365 days of the invitation to apply but EPA may extend the deadline on a case-by-case basis if the LOI schedule signals additional time may be needed.","Variable","See website.","https://www.epa.gov/wifia",null,"EPA","No maximum cost per project, but loan amounts generally are limited to 49% of eligible project cost; total amount of federal assistance (i.e., WIFIA and other federal sources) may not exceed 80% of total project cost.","Credit assistance (e.g., loans or loan guarantees)","NA"]
["Clean Water State Revolving Fund (SRF)","Program provides financial assistance through state-administered clean water state revolving fund (SRF) programs, supporting wastewater infrastructure and other eligible projects and activities. States must use SRF monies first to ensure compliance with Clean Water Act deadlines, goals, and requirements. The assistance can be used for constructing publicly owned facilities for stormwater management and for measures that would reduce stormwater (e.g., green infrastructure). Eligible projects include measures to manage, reduce, treat, or recapture stormwater, including those that may provide flood resilience and risk reduction benefits. Authorized by Clean Water Act, as amended, Sections 601-607, 33 U.S.C. §§1381-1387. Regulations are codified at 40 C.F.R. §35.3100.","SRF programs operate in all 50 states and Puerto Rico.","The selection of SRF projects for assistance remains prioritized on meeting the pollution-prevention objectives of the Clean Water Act. States implement programs, thus priorities vary.","Federal funds are distributed by formula to the state SRF programs. Annual appropriations are typically provided in annual Interior, Environment, and Related Agencies appropriations acts. The states contribute an additional 20 percent to match the federal grants. ","Most assistance is for loans that have to be 100% repaid to the state clean water SRF",null,null,"Annual project selection at state level","Apply through KDHE Bureau of Water","Varies",null,"Apply through KDHE Bureau of Water","https://www.epa.gov/cwsrf https://www.kdheks.gov/pws/loansgrants/applications.html",null,"EPA","Not specified","Clean water SRFs may provide seven general types of financial assistance: making loans; buying or refinancing existing local debt obligations; guaranteeing or purchasing insurance for local debt obligations; guaranteeing SRF debt obligations (i.e., to be used as security for leveraging the assets in the SRF); providing loan guarantees for substate revolving funds; earning interest on\nfund accounts; and supporting reasonable costs of administering the SRF.","NA"]
["Community Development Block Grant (CDBG)","Program funds must be used to address one of three national objectives that either (1) principally benefit low- or moderate-income persons, (2) aid in eliminating or preventing slums or blight, or (3) address an imminent threat to the health or safety of residents.","CDBG funds may be used for any of 27 eligible activities at the discretion of the grantee that address one of three national objectives. Limited percentage of total annual CDBG funds supports flood resilience and risk reduction. Eligible applicants under the CDBG program are defined as general purpose units of government.\u009d These units are all counties and cities not participating in the entitlement program. The entitlement program areas in Kansas are: Kansas City, Wichita, Topeka, Lawrence, Leavenworth, Overland Park, Manhattan and all of Johnson County. ","Program funds must be used to address one of three national objectives that either (1) principally benefit low- or moderate-income persons, (2) aid in eliminating or preventing slums or blight, or (3) address an imminent threat to the health or safety of residents.","P.L. 116-6, the Consolidated Appropriations Act, 2019, appropriated $3.365 billion, including $3.3 billion for CDBG formula grants to states, entitlement communities, and insular areas. The act includes $65 million for Indian tribes.\n(Annual appropriations are typically provided in annual Transportation and\nHousing and Urban Development appropriations acts.)","No matching funds required. Program funds may be used to meet the nonfederal matching fund requirement of other federal grant programs.","None","Yes","Annual appropriations. Formula-based grant.","CDBG grantees must develop and submit to HUD annual and multiyear plans outlining the proposed use of funds.","NA",null,"Variable. Typically August-November. See state website","https://www.kansascommerce.gov/programs-services/community-development/community-development-block-grant-program/ https://www.hud.gov/program_offices/comm_planning/\ncommunity development/programs.","Kansas Department of Commerce CDBG Program Manager \nDebbie Beck: 785-296-7092, Debbie.Beck@ks.gov","HUD","Not specified. Grantees may use CDBG directly to fund mitigation activities such as buyouts. Grantees also may use annual CDBG grants to access the CDBG Section 108 loan guarantee program, which allows a grantee to borrow up to five times its annual allocation for large-scale economic development, public facilities, or housing projects. Flood resilience and risk reduction activities may be part of such projects.","Formula-based block grants with 30% of appropriated funds allocated to states and Puerto Rico for distribution to small communities; and 70% of appropriated funds allocated to metropolitan-based cities with populations of 50,000 or more, and urban counties with populations of 200,000 or more. Funds are also allocated under a separate formula to the insular areas of American Samoa, Guam, Northern Marianas, and Virgin Islands. Indian tribes may compete for funds under a separate competitively awarded CDBG for Indian tribes.","No"]
["Community Development Block Grant−Disaster Recovery (CDBG-DR) ","Program funds must be used to address long-term recovery and restoration of infrastructure, housing, and economic activity, including mitigation activities intended to reduce or eliminate damage from future disasters.","Projects in the most affected and distressed areas resulting from a major disaster declared pursuant to the Stafford Act for specific years or areas depending on the language enacted in the supplemental appropriations. CDBG-DR funds may be used for any of 27 eligible activities to address long-term recovery and restoration of housing, infrastructure, and economic activity at the discretion of the grantee, that address one of the three national objectives under the regular CDBG program. Funds are tied to a specific disaster (and affected areas) or set of disasters","The CDBG-DR program is designed to help communities and neighborhoods that otherwise might not recover after a disaster due to limited resources. The block grant nature of the program allows state and local government grant recipients to undertake any of 27 categories of eligible activities, including floodplain management planning, open-space acquisition, construction, repair, replacement, or relocation of public facilities, and improvements such as dams and levees. Activities must meet one of three national objectives: principally benefit low- and moderate- income persons; aid in eliminating or preventing slums or blight; or address an imminent threat to the health or safety of residents. As a general rule, CDBG-DR grantees must use at least 70% of the funds for activities that principally benefit low- and moderate-income (LMI) persons or areas, unless Congress enacts language that allows HUD to waive this LMI targeting requirement","P.L. 116-6, the Consolidated Appropriations Act, 2019, appropriated $3.365 billion, including $3.3 billion for CDBG formula grants to states, entitlement communities, and insular areas. The act includes $65 million for Indian tribes.\n(Annual appropriations are typically provided in annual Transportation and\nHousing and Urban Development appropriations acts.)","No matching funds required. Program funds may be used to meet the nonfederal matching fund requirement of other federal grant programs.","None","Yes","Supplemental appropriations.","CDBG grantees must develop and HUD must approve a disaster recovery action plan.","NA",null,"Dependent on disaster declaration","https://www.hudexchange.info/programs/cdbg-dr/cdbg-dr-grantee-contact-information/\n#all-disasters.","Kansas Department of Commerce CDBG Program Manager \nDebbie Beck: 785-296-7092, Debbie.Beck@ks.gov","HUD","Not specified. Grantees may use CDBG-DR directly to fund mitigation activities such as buyouts.","Determined by language in the legislation providing appropriations.","No"]
["Community Development Block Grant Section 108 Loan Guarantees ","Program funds must be used to address one of three national objectives that either (1) principally benefit low- or moderate-income persons, (2) aid in eliminating or preventing slums or blight, or (3) address an imminent threat to the health or safety of residents. The program is intended to supplement the activities of the CDBG program.\nAt the discretion of the grantee, Section 108 loans may be used for any of a number of CDBG-eligible activities that address one of three national objectives. Section 108 loan guarantees can be used to support flood resilience and risk reduction.",null,"Guaranteed loan funds may be used for a number, but not all, of the activities eligible under the regular CDBG, including open-space acquisition, construction, repair, replacement, or relocation of public facilities, and improvements such as dams and levees. Funded activities must be part of a large-scale economic development, housing, or public facilities project.","P.L. 116-6 established a loan guarantee ceiling of $300 million for FY2019.\n(Annual appropriations are typically provided in annual Transportation and\nHousing and Urban Development appropriations acts.)","No matching funds required. This is a fee-based program. HUD is authorized to charge a fee to cover the long-term cost to the Section 108 loan guarantee. HUD establishes the amount of the fee annually based on a percentage of the principal amount of the Section 108 guaranteed loan.","None","Yes","Loan commitment ceiling established by annual appropriations.","Open application process with no specific deadline for submission of application. Proposed activities must meet one of the three national objectives and must be consistent with the state’s or community’s annual and multiyear plans outlining the proposed use of CDBG funds.","Open application process with no specific deadline for submission of application.",null,null,"https://www.hudexchange.info/programs/section-108/",null,"HUD","Not specified. Grantees may use all or some portion of their annual CDBG allocations to access the CDBG Section 108 loan guarantee program, which allows a grantee to borrow up to five times its annual allocation for large- scale economic development, public facilities, or housing project. Flood resilience and risk reduction activities may be part of such projects.","Loan guarantee secured by current and future annual allocations of CDBG\nfunds awarded to the state or local government.","NA"]
["Kansas Local Bridge Improvement Program (KLBIP)","The Kansas Local Bridge Improvement Program is a state-funded program that provides funds to local public authorities (LPA) to replace or rehabilitate locally-owned, deficient bridges in order to improve overall system throughout the State of Kansas. The goal of the program is to reduce the number of deficient bridges in the state in a cost-effective manner. Funding available under this program targets bridges with span length of 50 feet or less which comprise more than half of all deficient bridges in the state. Funds may only be reimbursed (90/10 funding) for projects to replace or rehabilitate existing bridges that are eligible. The eligible bridge may be replaced with another bridge, a low-water crossing, or other non-bridge length structure, e.g., multiple pipe culverts. The replacement structure design must meet current AASHTO Design requirements and must be stamped by a professional engineer. A new bridge constructed under this program shall not be scour-critical or fracture-critical.","In order to receive funding a bridge must meet any of the following criteria:\n1) classified as structurally deficient based on the latest inspection performed under the procedures of the National Bridge Inspection Program (NBI);\n2) NBI appraisal rating of 3 or less for Items (previously defined as Functionally Obsolete):\n• 67 (Structural Condition),   • 68 (Deck Geometry),   • 69 (Underclearances),\n• 71 (Waterway Adequacy),  • 72 (Approach Roadway Alignment).\n3) load rating requires bridge to be posted with a weight limit of less than legal loads;\n4) in immediate need of rehabilitation to remain open;\n5) closed due to structural inadequacies;","If applications for projects exceed the available funding, an additional selection process based on the technical merits of the projects will be used. This selection process may include, but is not limited to:\n• Structurally deficient bridges will receive priority over all others.  • Condition of the bridge (sufficiency rating).\n• Estimated average daily traffic.                                                                                • Length of adverse travel if bridge were closed.\n• Will another bridge be closed in conjunction with this project?        • Geographic distribution of projects.","$5M per year beginning SFY 2020.","State funds (90/10 funding) will be paid to the LPA on a reimbursement basis up to the maximum amount specified in the project agreement. ","None","NA","KDOT will determine the amount of state funds to be made available for the Kansas Local Bridge Improvement Program annually. ","KDOT will issue a “Call for Projects” announcing the amount of funding available for the Kansas Local Bridge Improvement Program and requesting project applications from LPAs. The LPA shall submit a project application using forms provided by KDOT. ","Typically late summer",null,"See Action Needed to Access Program and Website. KDOT Bureau of Local Projects\nEisenhower State Office Building, 700 S.W. Harrison, 3rd Floor West Wing, Topeka, KS 66603-3745, KDOT.LPePlans@ks.gov","http://www.ksdot.org/bureaus/burLocalProj/default.asp","Kansas Department of Transportation, Bureau of Local Projects\n(785) 296-3861, KDOT.LPePlans@ks.gov","KDOT","The maximum amount of state dollars that will be provided for an individual project is $150,000. If the LPA determines to permanently close and remove a second deficient bridge on their system, the maximum state dollars for the project will be increased to $200,000. “Bankrolling” or accumulation of funds over multiple years in order to fund a larger bridge will not be allowed.","Grant"]
["Surface Transportation Block Grant Program (STBG)","Flexible funding that may be used by locals for projects to preserve and improve the conditions and performance of any Federal-aid eligible highway; construction or rehabilitation of a bridge or tunnel on any public road; pedestrian and bicycle infrastructure; and transit capital projects. Consideration of climate change and extreme weather events in project development, including environmental review and design work. Resilience related: Right of way acquisition and construction of projects or features to protect existing eligible assets from impacts and damage associated with climate change and extreme weather events. ",null,"A portion of STP funds is distributed to all counties. A portion of STP funds is distributed to all cities with a population greater than 5,000 but not located in an urbanized area of 200,000 or greater. Urbanized areas with populations greater than 200,000 receive a sub-allocation of STP funds through the respective Metropolitan Planning Organization (MPO). Local Public Authorities within these regions that want to use these funds must apply for funding through the MPO.","Funding amount and availability is determined annually. Distribution\nbased on Special City/County Highway fund formula. The FAST Act directs FHWA to apportion funding as a lump sum for each State then divide that total among apportioned programs. Each State’s STBG apportionment is calculated based on a percentage specified in law. FAST Act § 1109; 23 U.S.C. 133","80% Federal / 20% Local -\u0080\u0093 Construction & Inspection phases.\n100% Local - Design, Right of Way Acquisition & Utility Relocation.",null,"Yes","FAST Act § 1109; 23 U.S.C. 133",null,null,null,"For a federally funded project, submit Form 1302, Request for a\nConstruction Project, to the Bureau of Local Projects.","https://www.fhwa.dot.gov/fastact/factsheets/stbgfs.cfm","Bur. of Local Projects \nIngrid Horton: 785-296-3861, ingrid.horton@ks.gov","FHWA",null,"Grant"]
["Recreational Trails Grant","The program provides 80 percent reimbursement to selected outdoor recreation projects. ","All projects selected must fall into one or more of three categories: motorized, non-motorized, or diversified recreational trail or trail-related projects.","Projects that provide for motorized recreation activities are encouraged, as 30% of the funding is to be devoted to motorized projects. Qualifying projects include new trail or trailhead construction, maintenance or reconstruction of existing trails, enhancements or upgrades to existing trails/trailheads, development and planning, or land acquisition and easements.",null,"50% Federal / 50% Non federal\u0080\u0093",null,"Yes",null,"Submit application - see website","2020 applications due Sept 1.",null,"See website.","https://ksoutdoors.com/KDWPT-Info/Grants","Kansas Department of Wildlife, Parks and Tourism, Trail Grant Coordinator\nCherie Riffey: 620-672-5911","FHWA",null,"Grant","No"]
["Land and Water Conservation Fund Grant","The program provides 50 percent reimbursement to selected outdoor recreation projects that are sponsored by political subdivisions and other appropriate public agencies. Since 1965, Kansas has received over $50 million and funded approximately 700 LWCF projects in nearly every county. Qualifying projects include development and/or acquisition of outdoor facilities for the purpose of public recreation.","Incorporated cities, counties, state agencies, Indian Tribes, public schools and public universities are eligible to apply for the Land and Water Conservation Funds for the acquisition and development of outdoor recreation projects. State Parks and Stateside planning projects may also be funded.","Must meet priority outdoor recreation needs identified in the 2015 Kansas Statewide Comprehensive Outdoor Recreation Plan (SCORP).","Annual appropriations; The Great American Outdoors Act of 2000 requires that the LWCF be funded at $900 million yearly","80% Federal / 20% Non federal\u0080\u0093","None","Yes","The Great American Outdoors Act of 2000 requires that the LWCF be funded at $900 million yearly","Apply through the Kansas Department of Wildlife, Parks and Tourism (KDWPT). ","KDWPT is accepting applications for Federal grants from the Land and Water Conservation Fund until September 15, 2020.",null,"See website.","https://ksoutdoors.com/KDWPT-Info/Grants","Kansas Department of Wildlife, Parks and Tourism LWCF Grant Coordinator\nKati Westerhaus: 620-672-5911, kati.westerhaus@ks.gov","KDWPT",null,"Grant","No"]
["Watershed Dam Construction Program","The Watershed Dam Construction Program provides state financial assistance to organized Watershed, Drainage or other Special Districts for the implementation of flood control structural and non-structural practices. These practices provide protection of agricultural land, urban areas, roads, bridges and utilities, in addition to providing water for livestock and in some instances for rural fire departments, enhancing wildlife and trapping sediment and pollutants. Construction and rehabilitation of flood control and/or grade stabilization dams are the main practices and components of this program.","Any organized watershed district, drainage district or other special purpose\ndistrict, interested in state assistance, may apply for state cost-share assistance funds appropriated for construction\nof detention and grade stabilization dams.","The objective is to achieve flood reduction benefits to agricultural land, roads, bridges, utilities, and urban areas.\n\nIn 2007, the WDCP was amended to include the rehabilitation of existing flood control structures. Rehabilitation is the necessary work to bring a structure to applicable safety and performance standards. An evaluation team consisting of designees from state and federal water\nrelated agencies shall evaluate applications and recommend a priority order for funding. In addition, an amount will\nbe recommended for construction of detention dams in drainage or other special purpose districts","Annual appropriations","80% state / 20% non-state","None",null,"Since 1977, the Legislature has annually appropriated funds for cost-share assistance for the construction of flood control detention and grade stabilization dams. The Watershed District Act, K.S.A. 24-1201 et seq. and the Watershed Dam Construction Program rules and regulations K.A.R. 11-3-1 to 11-3-12 provide guidance for the administration of the state cost-share funding.","Organized Watershed and Drainage Districts are encouraged to apply for the rehabilitation of any of their flood control structures. "," Applications shall be due at the commission office by April first to be included in the evaluation process for possible funding during the next fiscal year. Dam rehabilitation are due on or before July 1 each year",null," Applications for state assistance shall be on forms supplied by the commission. Applications shall be due at the commission office by April first to be included in the evaluation process for possible funding during the next fiscal year. The district submitting the application shall employ or acquire the services of a person knowledgeable of watershed dam construction administrative procedures, who shall be known as the contracting officer for the\nproposed site. ","https://agriculture.ks.gov/divisions-programs/division-of-conservation/flood-control-and-lakes-programs"," Hakim Saadi, P.E. \n(785) 291-3099, hakim.saadi@ks.gov","KDA","The maximum cost-share level for construction costs including engineering and inspection shall be 80\npercent. The maximum annual assistance per structure or district shall be $90,000, except when uncommitted funds\nare available after all eligible structures have been funded. In which case, the funds may be used to provide\nadditional cost-sharing above the maximum limit. Assistance funds shall not be used for land rights or administrative\ncosts","Cost share"]

{"sheet":"Other potential programs","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Funding Agency","Funding Programs"]
["FHWA","Emergency Relief (ER)"]
["FHWA","Highway Bridge Program"]
["KDC","Community Capacity Building Program and Kansas Partnership Fund"]
["KDA","Multiprupose small Lakes Program","https://agriculture.ks.gov/divisions-programs/division-of-conservation/flood-control-and-lakes-programs"]
["KDA","Wetland development","https://agriculture.ks.gov/divisions-programs/division-of-conservation/riparian-wetland-streambank"]
["KDA","Streambank Protection Program","https://agriculture.ks.gov/divisions-programs/division-of-conservation/riparian-wetland-streambank"]
["FEMA","Public Assistance - 406"]

{"sheet":"Front Page Template","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,1,0,3],[2,0,2,3],[8,0,8,3],[9,0,9,3]]}
[null,"\n"]
["Funding Resource Evaluation Report"]
[]
["Community Name:",{"$f":"Form!$F$6","v":"Smallville, KS"}]
["Project Name:",{"$f":"Form!$F$7","v":"Example Project"}]
["Report Date:",{"$f":"Form!$F$8","v":"2021-09-23"}]
["Funding Programs:"]
[]
["This report summarizes the potential funding resources that may be available for the identified project.  It was generated based on the types of projects that were identified by the user for the project.  The following sections summarize various information for the potential funding programs."]
["\nDisclaimer: Funding resources and eligibility change on a regular basis. Check with the respective agency for the latest available information.\n"]

{"sheet":"Grant Report Template","index":5,"n_rows":1032209,"n_cols":3,"rows_kept":4500,"cut":true,"hidden":true,"merged":[],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
["Program Name",null,"Agency"]
["Purpose"]
["Eligibility Requirements"]
["Funding Priorities"]
["Funding Level"]
["Pre-award costs Eligible?"]
["Cost Share Requirements",null,"Period of Performance"]
["Benefit Cost Analysis Requirements",null,"Pre-award costs Eligible?"]
["Environmental Review Requirements"]
["Program Trigger"]
["Action Needed to Access Program"]
["Application period"]
["Maximum Project Assistance"]
["Type of Assistance"]
["Application Submittal"]
["Website"]
["Contact"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Funding Priorities"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Program Name"]
["Agency"]
["Type of Assistance"]
["Purpose"]
["Eligibility Requirements"]
["Funding Priorities"]
["Funding Level"]
["Maximum Project Assistance"]
["Pre-award costs Eligible?"]
["Cost Share Requirements"]
["Benefit Cost Analysis Requirements"]
["Environmental Review Requirements"]
["Program Trigger"]
["Action Needed to Access Program"]
["Application period"]
["Period of Performance"]
["Application Submittal"]
["Website"]
["Contact"]

{"sheet":"Modification Instructions","index":6,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Modification Instructions"]
["*The worksheets are password-protected; to edit any values, the password must be entered to unlock cells. (Review >> Unprotect Sheet)\n"]
["To modify existing program summary information:\n1) Right-click on the visible sheet, click 'Unhide', select 'Funding Program Details'\n2) Navigate to the relevant cells  in the 'Funding Program Details' table (Each row reperesents a program while each column represents a detail) and modify the information.\n"]
["To modify existing criteria for an existing program:\n1) Right-click on the visible sheet, click 'Unhide', select 'Funding Program Eligible Types'\n2) Navigate to the relevant cells in the 'Funding Program Eligible Types' table (Each row reperesents a program while each column represents a project type) and add or remove 'X' values to trigger which project types will trigger each program.\n"]
["To add a new Program:\n1) Right-click on the visible sheet, click 'Unhide', select 'Funding Program Details'\n2) Navigate to the first empty row within the 'Funding Program Details' table and enter the relevant information (Each row reperesents a program while each column represents a detail).\n3) Right-click on the visible sheet, click 'Unhide', select 'Funding Program Eligible Types'\n4) Navigate to the first empty row within the 'Funding Program Eligible Types' table and add or remove 'X' values to trigger which project types will trigger each program (Each row reperesents a program while each column represents a project type). \n"]
["To add a new Project Type:\n1) Navigate to the 'Form' sheet\n2) Under the last project type, enter the new project type\n3) Click 'Clear Checkboxes' to trigger an update of the checkboxes\n4) Add the new project type to the 'Funding Program Eligible Types' table: Right-click on the visible sheet, click 'Unhide', select 'Funding Program Eligible Types'\n5) Navigate to the last column in the 'Funding Program Eligible Types' table, add the new project type in the header (matching exactly the value in the 'Form') and add 'X' values to trigger which programs should be triggerred by this project type.\n"]
["*After any edits, relock  each sheet ('Protect Sheet') and hide all sheets except 'Form'.  Do not protect the entire workbook as this will prevent the macro from running.\n"]