User Guide Template_Project Worksheet_508 FINAL 7.11.23.pdf

FY 2023 State and Local Cybersecurity Grant Program (SLCGP) Project Worksheet User Guide July 2023

Federal Emergency Management Agency

General Information

This User Guide is intended to help applicants complete the FY 2023 SLCGP Project Worksheet (PW). This guide walks through key tips and instructions for each tab of the PW in the order in which they are listed.

The PW must be filled out in Excel. If a cell is locked, please do not attempt to edit or fill it.

The PW will be used to identify the budget details and budget narrative portion of the application. Eligible applicants should submit only one PW as part of the overall application and must include information for each Investment Justification (IJ) submitted as part of the application for funding.

General Information

Acronyms:

FEMA: Federal Emergency Management Agency IJ: Investment Justification NOFO: Notice of Funding Opportunity POETE: Planning, Organization, Equipment, Training, Exercises PW: Project Worksheet M&A: Management and Administration ND Grants: Non-Disaster Grants POP: Period of Performance SAA: State Administrative Agency SLCGP: State and Local Cybersecurity Grant Program

Excel Tips

Zoom in and out using the slider circled on the right with a minus on one end and a plus on the other.

If any text is cut off in the cell you are looking at, try zooming in or out.

You can also use the slider above it to scroll left/right in the worksheet.

Spell Check functionality is unavailable in Excel.

Do NOT delete cells with formulas.

Copying and Pasting Text If you have existing text that you want to copy into the template, highlight the text, copy it, click the desired cell in the template, click into the formula bar (pictured below), and paste the text.

You cannot paste an entire cell; you will have to paste the text directly into the formula bar.

Resizing Cells If the text entered in a cell doesn't fit with the cell's existing size, hover your cursor over the line between the rows or columns you wish to expand. When your cursor changes, drag the cell to the desired height and/or width.

Guidance Tab

Enter the State Administrative Agency (SAA) name only; do not enter any individual names.

SAA POC Name: Please enter the first and last name of the designated SAA point of contact (POC).

SAA POC Title: Please enter the role and/or title of the SAA POC.

SAA Address: Please enter the full mailing address for the SAA, including city, state and zip code.

SAA POC Phone Number: Please enter the full phone number for the SAA POC in the following format (XXX)

XXX-XXXX.

SAA POC Email Address: Please enter the email address of the SAA POC; this should match the contact information within the ND Grants System.

• Data is pulled from multiple cells throughout the PW. Remove blank rows in Baseline Project Information and Project Implementation Tabs to ensure accuracy in data input.

Baseline Project Information

Baseline Project Information: Color Code

Blue – Federal amount (whole dollars only).

Green – POETE subtotal, local pass-through and rural pass-through requirements.

Orange – Pass-through requirements and cost share (whole dollars only).

Yellow – Total project costs (Federal + Cost Share) (whole dollars only).

Baseline Project Information: Project Details

Projects will be programmatically reviewed and approved by CISA before FEMA conducts project budget reviews. Project details in this worksheet should match exactly to each submitted IJ. Incomplete or inaccurate information could delay the approval or release of funding for related projects.

Please include the corresponding FY 2023 SLCGP objective, project name, the project’s alignment to the 16 required elements of the cybersecurity plan, project description, zip code (for the physical location for the state/territory project), primary core capability, and sustain or build (if applicable).

Information related to the 16 required cybersecurity elements is detailed in Appendix C, “Cybersecurity Plan” of the NOFO.

Baseline Project Information: POETE

Amounts should be entered in Columns I through N for the breakdown of the project funding by the Planning, Organization, Equipment, Training, or Exercises (POETE) Solution Areas.

Additional information related to POETE Solution Areas for Investments is detailed in Appendix D, “POETE Solution Areas for Investments” of the

NOFO.

Column N calculates the SUM of Columns I - M.

Baseline Project Information: Pass-Through Requirements and Cost Share

Baseline Project Information: Pass-Through – Subgrant Awards

80% of the state or territory federal award amount must be passed through to local governments.

25% of the state or territory federal award amount must be passed through to local jurisdictions in rural areas (less than

50,000 population).

Dollar amounts in Columns O and Q reflect the Subgrant

Award Amounts passed through from the SAA to Local

Governments (Column O) and Rural Areas (Column Q).

Do NOT include value of pass-through services, solution, etc. here.

Baseline Project Information: Pass-Through – Services, Solutions, etc.

SAAs may pass through items, services, capabilities, or activities on a state-wide basis to all local governments and rural areas in lieu of funding.

Dollar amounts in Columns P and R relate to the Value of the

SAA’s pass-through services, solutions, benefits, etc. for Local

Governments (Column P) and Rural Areas (Column R).

Do NOT include Subaward Award Amounts here.

Baseline Project Information: Cost Share

Total Project Costs (Column U) is the = SUM of Columns S and T. Input is not required in Column U. Cell will populate automatically after a number is entered for Federal Amount and Cost Share in Columns S and T.

Please provide the source of cost-share: Hard Match and Soft Match in Column T, Row 15.

Example of Hard (Cash): State or local general funds.

Example of Soft (In-kind): Contributions of salary, travel, equipment, supplies and other budget areas that are from third party sources (in compliance with 2 CFR 200.306) and include voluntary contributions.

Project Implementation

Data input in Column A in the Project Implementation Tab will automatically populate in the corresponding Column A Tab for the Baseline Project Information.

Columns E through H provide markers on project execution and must not be skipped. Enter the anticipated start and end date for each project (MM/YYYY).

Columns K and L pull data from Columns S and T from the Baseline Project Information tab. Do not erase the formulas in Columns K and L.

Formula:

• Column K:

• Column L:

Column M is the SUM of Columns K and L.

Formula:

• Column M:

Applicants ensure the costs in Columns K through M match Columns S through U in the Baseline Project Information Tab.

SLCGP Grant Program Contact Information and Resources

Lisa Nine, Senior Program Analyst and Team Lead: 202-706-3176, Lisa.Nine@fema.dhs.gov, R10

Amanda Carver, Preparedness Officer: 202-368-8197, Amanda.Carver@fema.dhs.gov: R6, R7, R8

Amanda Lemminga, Preparedness Officer: 202-924-3436, Amanda.Lemminga@fema.dhs.gov: R2, R3,R4

Jennifer Havas Joy, Preparedness Officer: 771-217-7053, Jennifer.Havasjoy@fema.dhs.gov: R1, R5, R9

SLCGP Mailbox: FEMA-SLCGP@fema.dhs.gov

State and Local Cybersecurity Grant Program | FEMA.gov mailto:Lisa.Nine@fema.dhs.gov mailto:Amanda.Carver@fema.dhs.gov mailto:Amanda.Lemminga@fema.dhs.gov mailto:Jennifer.Havasjoy@fema.dhs.gov mailto:FEMA-SLCGP@fema.dhs.gov https://www.fema.gov/grants/preparedness/state-local-cybersecurity-grant-program

Thank you!