Project Worksheet User Guide _FINAL_508c.pdf

FY 2023 Tribal Cybersecurity Grant Program (TCGP) Project Worksheet User Guide September 2023

Federal Emergency Management Agency

General Information

This User Guide is intended to help applicants complete the FY 2023 TCGP 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 is a Microsoft Excel spreadsheet which is currently in draft format; this spreadsheet should be completed by tribal applicants as part of the TCGP application. 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 Cont’d

Acronyms:

FEMA: Federal Emergency Management Agency IJ: Investment Justification NOFO: Notice of Funding Opportunity POETE: Planning, Organization, Equipment, Training, Exercises PW: Project Worksheet ND Grants: Non-Disaster Grants System TCGP: Tribal 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 and right in the worksheet.

Spell Check functionality is unavailable in Excel.

Do NOT delete cells with formulas.

Excel Tips Cont’d

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 does not 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

Guidance Tab

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

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

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

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

XXX-XXXX.

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

Guidance Tab Cont’d

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 – Planning, Organization, Equipment, Training, or Exercises

(POETE) subtotal Yellow – Total project costs (Federal Amount) (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 TCGP 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 project), primary core capability, and sustain or build (if applicable).

Information related to the 13 Required Cybersecurity Elements is detailed in Appendix C of the funding opportunity.

Baseline Project Information: POETE

Amounts should be entered in Columns I through N for the breakdown of the project funding by the POETE Solution Areas.

Additional information related to POETE Solution Areas for Investments is detailed in Appendix D of the funding opportunity.

Column N calculates the SUM of Columns I - M.

Project Implementation

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).

Project Implementation Cont’d

Column K pulls data from Column O in the Baseline Project Information tab. Do not erase the formulas in Columns K and O.

Formula:

• Column K:

TCGP 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

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

Please reference the Tribal Cybersecurity Grant Program web page on FEMA.gov https://www.fema.gov/grants/preparedness mailto:Lisa.Nine@fema.dhs.gov mailto:Amanda.Carver@fema.dhs.gov mailto:Amanda.Lemminga@fema.dhs.gov mailto:Jennifer.Havasjoy@fema.dhs.gov

Thank you!