{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Investment Justification","Dropdowns - Hide Before Use","Sheet2","Sheet3","Sheet1"],"not_rendered":{"images":22,"macros":1,"external_links":2,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":119,"n_cols":7,"rows_kept":119,"merged":[[1,2,1,8],[3,2,3,8],[4,4,4,6],[5,4,5,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[12,4,12,6],[14,4,14,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[21,4,21,6],[24,5,24,6],[26,5,26,6],[28,5,28,6],[29,5,29,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[40,5,40,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[52,4,52,6],[54,3,54,7],[57,2,57,8]]}
[]
[null,null," Nonprofit Security Grant Program (NSGP)\n Investment Justification Template Introduction"]
[]
[null,null,"OMB Control Number: 1660-0110\nExpiration Date: December 31, 2016"]
[{"$nulls":4},"PAPERWORK BURDEN DISCLOSURE NOTICE"]
[{"$nulls":4},"Public reporting burden for this form is estimated to average 84 hours per response. The burden estimate includes the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and submitting the form. This collection of information is required to obtain or retain benefits. You are not required to respond to this collection of information unless a valid OMB control number is displayed in the upper right corner of this form. Send comments regarding the accuracy of the burden estimate and any suggestions for reducing the burden to: Information Collections Management, Department of Homeland Security, Federal Emergency Management Agency, 500 C Street, SW., Washington, DC 20472-3100, Paperwork Reduction Project (1660-0110) NOTE: Do not send your completed form to this address. \n"]
[]
[{"$nulls":4},"Security Warning:"]
[{"$nulls":4},"When opening the IJ template, some users may see a note that says \"Security Warning: some active content has been disabled.\"  Click on the [Options …] button next to the message, select \"Enable this content,\" then click on the [OK] button.  If this is not done, the text boxes may not function properly."]
[]
[{"$nulls":4},"As part of the Nonprofit Security Grant Program (NSGP) application, 501(c)(3) organizations within Urban Areas Security Initiative (UASI)-designated urban areas must develop a formal Investment Justification (IJ) that addresses each initiative proposed for funding. These IJs must demonstrate how proposed projects address gaps and deficiencies in current programs and capabilities, as well as how the investment supports the building or sustaining of core capabilities within the National Preparedness Goal (the Goal). For more information on the Goal see: http://www.fema.gov/national-preparedness-goal. Additionally, the IJ must demonstrate the ability to provide enhancements consistent with the purpose of the program and guidance provided by the Federal Emergency Management Agency (FEMA). Applicants must ensure that the IJ is consistent with all applicable requirements outlined below. Applicants may only submit one IJ on behalf of their nonprofit organization in order to be considered for funding."]
[]
[{"$nulls":4},"FEMA has developed guidelines that establish the required IJ content and helps ensure that submissions are organized in a consistent manner while addressing key data requirements. This template (Office of Management and Budget [OMB] Number: 1660-0110/FEMA Form Number: 089-25) may be used by applicants to complete and submit their IJ.  Failure to address these data elements in the prescribed format could potentially result in the rejection of the IJ from review consideration."]
[]
[{"$nulls":4},"Applications must use the following file naming convention when submitting required documents as part of the NSGP: “NSGP <State Abbreviation>_<Urban Area>_<Nonprofit Name>.”"]
[]
[{"$nulls":4},"If using Excel 2007, applicants are required to save the final version of the IJ in the Excel 97-2003 format before submitting.  Excel 2007 or PDF formats cannot be accepted.  Instructions on saving the IJ template in the Excel 97-2003 format are below in the “Helpful Hints” Section."]
[]
[{"$nulls":4},"Applications should be submitted by the nonprofit organization to the State Administrative Agency (SAA)/Urban Area Working Group (UAWG). Applicants should contact their respective SAA to get information on the application deadline and other SAA requirments. If an extension to the deadline is required, nonprofit organizations must consult with their respective SAA/UAWG. SAAs will receive a separate, Excel-based NSGP Scoring Worksheet upon the release of the NSGP Notice of Funding Opportunity  (NOFO). The NSGP Scoring Worksheet will be used by the SAA to review and score NSGP applications consistent with the guidelines provided in the NSGP IJ and Selection Criteria as well as ensure consistency with programmatic requirements. "]
[]
[]
[{"$nulls":4},"Helpful Hints:"]
[]
[{"$nulls":5},"Moving through the Investment Justification:"]
[{"$nulls":5},"While entering information in the IJ template, applicants should try to minimize the use of the Tab and Enter keys to move between data entry fields.  As the template consists of a combination of text boxes and cells, using these keys may cause the cursor to move to an undesired location."]
[{"$nulls":5},"Copying & Pasting in the Investment Justification:"]
[{"$nulls":5},"Some applicants may find it helpful to begin drafting their IJ information in MS Word and then pasting this into the Excel-based template.  However, please be aware that, when copying and pasting information from Word into the text boxes in the template, any formatting will not carry over.  Also, right-clicking in the text boxes in Excel will not provide the usual pop-up menu where you can select Cut, Copy, Paste, or any of the usual such options.  To copy from a text box, users must select the text, then use the [Edit] menu in Excel 2003 or the [Home] tab in Excel 2007 and select [Copy].  To paste data into a text box, click in the text box, then use the [Edit] menu in Excel 2003 or the [Home] tab in Excel 2007 and select [Paste]."]
[]
[{"$nulls":5},"Character Count:"]
[{"$nulls":5},"The data entry fields included in the IJ allow for the maximum number of characters noted for that section, plus an additional number of characters to account for spaces.  Once that limit has been reached, users will not be able to include any additional text."]
[]
[{"$nulls":5},"Spell Check:"]
[{"$nulls":5},"When using Spell Check in MS Excel, it will not review information entered into the data entry boxes.  Therefore, it is suggested that applicants use MS Word to ensure that the entered information is spelled correctly.  To use Spell Check in MS Word:"]
[{"$nulls":5},"In MS Word 2003"]
[{"$nulls":5},"a) Click on the [Tools] menu"]
[{"$nulls":5},"b) Select [Spelling] and all spelling issues will be displayed"]
[{"$nulls":5},"In MS Word 2007"]
[{"$nulls":5},"a) Click on the [Review] tab near the top of the screen"]
[{"$nulls":5},"b) Click on [Spelling & Grammar] and all spelling issues will be displayed"]
[]
[{"$nulls":5},"Visible Text:"]
[{"$nulls":6},"a) Ensure that all text entered into the IJ is visible within the space provided"]
[{"$nulls":6},"b) Should text run over the space provided, reviewers will not be able to review your complete \n    response"]
[{"$nulls":6},"c) Before submitting the IJ, applicants should print the final version of IJ to make sure all text is \n    visible on the printed page"]
[]
[{"$nulls":5},"Saving in Excel 2003 Format:"]
[{"$nulls":5},"As stated above, if using Excel 2007 to complete the IJ template, applicants are required to save the final version in the Excel 97-2003 format before submitting.  To do that:"]
[{"$nulls":5},"a) Click on the Office Button at the top left of the Excel window"]
[{"$nulls":5},"b) Hover over [Save As] in the list"]
[{"$nulls":5},"c) Click on [Excel 97-2003 Workbook]"]
[{"$nulls":5},"d) In the “Save As” Window, chose a location and file name for the new file.  Be sure to use the \n    “NSGP <State Abbreviation>_<Urban Area>_<Nonprofit Name>\" file name format \n     noted above."]
[]
[{"$nulls":4},"To begin entering information into the IJ, click on the \"Investment Justification\" tab below."]
[]
[]
[]
[]
[null,null,"FEMA Form 089-25 (11/16)"]
{"$rows_empty":13}
[{"$nulls":5},"Delaware"]
[{"$nulls":5},"District of Columbia"]
[{"$nulls":5},"Florida"]
[{"$nulls":5},"Georgia"]
[{"$nulls":5},"Guam"]
[{"$nulls":5},"Hawaii"]
[{"$nulls":5},"Idaho"]
[{"$nulls":5},"Illinois"]
[{"$nulls":5},"Indiana"]
[{"$nulls":5},"Iowa"]
[{"$nulls":5},"Kansas"]
[{"$nulls":5},"Kentucky"]
[{"$nulls":5},"Louisiana"]
[{"$nulls":5},"Maine"]
[{"$nulls":5},"Maryland"]
[{"$nulls":5},"Massachusetts"]
[{"$nulls":5},"Michigan"]
[{"$nulls":5},"Minnesota"]
[{"$nulls":5},"Mississippi"]
[{"$nulls":5},"Missouri"]
[{"$nulls":5},"Montana"]
[{"$nulls":5},"Nebraska"]
[{"$nulls":5},"Nevada"]
[{"$nulls":5},"New Hampshire"]
[{"$nulls":5},"New Jersey"]
[{"$nulls":5},"New Mexico"]
[{"$nulls":5},"New York"]
[{"$nulls":5},"North Carolina"]
[{"$nulls":5},"North Dakota"]
[{"$nulls":5},"Northern Marianas Islands"]
[{"$nulls":5},"Ohio"]
[{"$nulls":5},"Oklahoma"]
[{"$nulls":5},"Oregon"]
[{"$nulls":5},"Pennsylvania"]
[{"$nulls":5},"Puerto Rico"]
[{"$nulls":5},"Rhode Island"]
[{"$nulls":5},"South Carolina"]
[{"$nulls":5},"South Dakota"]
[{"$nulls":5},"Tennessee"]
[{"$nulls":5},"Texas"]
[{"$nulls":5},"U.S. Virgin Islands"]
[{"$nulls":5},"Utah"]
[{"$nulls":5},"Vermont"]
[{"$nulls":5},"Virginia"]
[{"$nulls":5},"Washington"]
[{"$nulls":5},"West Virginia"]
[{"$nulls":5},"Wisconsin"]
[{"$nulls":5},"Wyoming"]

{"sheet":"Investment Justification","index":1,"n_rows":295,"n_cols":19,"rows_kept":295,"merged":[[1,2,1,20],[2,3,2,19],[4,3,4,19],[5,4,5,9],[7,4,7,9],[11,4,11,9],[12,5,12,9],[17,4,17,9],[20,4,20,9],[21,5,21,17],[23,4,23,9],[25,4,25,9],[25,11,25,17],[26,5,26,17],[28,4,28,9],[28,11,28,17],[30,4,30,9],[31,5,31,17],[38,3,38,19],[40,4,40,16],[66,3,66,19],[68,4,68,17],[69,5,69,17],[70,5,70,17],[71,5,71,17],[73,4,73,17],[80,4,80,16],[81,4,81,16],[82,4,82,16],[93,4,93,16],[106,2,106,20],[107,3,107,19],[109,4,109,17],[110,4,110,17],[124,4,133,18],[135,4,135,6],[135,7,135,9],[137,4,137,5],[159,3,159,19],[161,4,161,17],[163,4,163,17],[165,5,165,11],[165,13,165,14],[165,16,165,17],[167,5,167,17],[169,5,169,11],[169,13,169,14],[169,16,169,17],[171,5,171,11],[171,13,171,14],[171,16,171,17],[173,5,173,11],[173,13,173,14],[173,16,173,17],[175,5,175,11],[175,13,175,14],[175,16,175,17],[177,5,177,11],[177,13,177,14],[177,16,177,17],[179,5,179,11],[179,13,179,14],[179,16,179,17],[181,5,181,11],[181,13,181,14],[181,16,181,17],[183,5,183,11],[183,13,183,14],[183,16,183,17],[185,5,185,11],[185,13,185,14],[185,16,185,17],[187,5,187,11],[187,13,187,14],[187,16,187,17],[190,3,190,19],[194,4,194,18],[195,4,195,17],[207,4,207,17],[211,4,211,17],[234,2,234,20],[235,3,235,19],[237,4,237,17],[255,4,255,18],[260,3,260,19],[262,4,262,17],[272,4,272,17],[284,5,284,17],[286,6,287,18],[289,6,289,17],[291,6,291,17],[293,2,293,20],[294,2,296,20]]}
[]
[null,null,"NSGP Investment Justification"]
[{"$nulls":3},"I.  Nonprofit Organization Applicant Information"]
[]
[{"$nulls":3},"Identify the Following:"]
[{"$nulls":4},"Legal Name of the Organization"]
[{"$nulls":4},"Physical Address of the Facility"]
[{"$nulls":4},"(One Investment Justification per facility; include city, state, and zip code)"]
[]
[{"$nulls":4},"County"]
[{"$nulls":4},"Year the Original Facility was Constructed"]
[{"$nulls":4},"Organization Type (Short description of organization’s ideology, beliefs and mission)"]
[{"$nulls":5},"(400 character max- not including spaces)"]
[]
[{"$nulls":4},"Membership and community served"]
[]
[]
[{"$nulls":4},"501(c)(3) designation:"]
[]
[]
[{"$nulls":4},"Dun and Bradstreet Number:"]
[{"$nulls":5},"Applications can only be submitted with a current and valid DUNS number; pending DUNS numbers will not be accepted."]
[]
[{"$nulls":4},"FY 2017 Urban Area"]
[]
[{"$nulls":4},"NSGP Federal Funding Request"]
[{"$nulls":5},"Each nonprofit organization may only apply for up to a $75,000 grant award"]
[]
[{"$nulls":4},"NSGP Total Project Cost"]
[]
[{"$nulls":4},"Any Current Contract with DHS (yes/no)"]
[{"$nulls":5},"This does not include any DHS or NSGP grant funds previously awarded to the nonprofit organization."]
[]
[{"$nulls":5},"If Yes, please describe:"]
[]
[{"$nulls":4},"Investment Phase - New or Ongoing"]
[]
[]
[{"$nulls":3},"II. Background"]
[]
[{"$nulls":4},"Describe the nonprofit organization including: (300 character max per text box - not including spaces)\n\n\n\n"]
[]
[{"$nulls":4},"Describe the symbolic value of the site as a highly recognized national or historic institution or significant institution within the community                                                                                                                                                                                                                                                                                      "]
[{"$nulls":4},"commthat renders the site as a possible target of terrorism"]
{"$rows_empty":12}
[{"$nulls":4},"Describe any previous or existing role in responding to or recovering from terrorist attacks "]
{"$rows_empty":9}
[{"$nulls":3},"III. Risk"]
[]
[{"$nulls":4},"DHS defines risk as the product of three principal variables:  Threat, Vulnerability, and Consequences.  In the space below, describe specific findings from previously conducted risk assessments, including A) Threats, B) Vulnerabilities, and C) Potential Consequences of an attack."]
[{"$nulls":5},"A) Threat:  In considering threat, the applicant should discuss the identification and substantiation of specific threats or attacks against the nonprofit organization or closely related organization by a terrorist organization, network, or cell.  The applicant should also discuss findings from a risk assessment, police findings, and/or insurance claims specific to the location being applied for including dates and specific threats."]
{"$rows_empty":10}
[{"$nulls":4},"B) Vulnerabilities:  In considering vulnerabilities, the applicant should discuss the organization’s susceptibility to destruction, incapacitation, or exploitation by a terrorist attack."]
{"$rows_empty":12}
[{"$nulls":4},"C) Potential Consequences:  In considering potential consequences, the applicant should discuss potential negative effects on the organization’s asset, system, and/or network if damaged, destroyed, or disrupted by a terrorist attack."]
{"$rows_empty":13}
[{"$nulls":3},"IV. Target Hardening"]
[]
[{"$nulls":4},"In this section, describe the proposed target hardening activity that addresses the identified threat or vulnerability. Allowable costs are focused on target hardening activities as well as security-related training courses and programs limited to the protection of critical infrastructure key resources, including physical and cyber security, target hardening, and terrorism awareness/employee preparedness.  Funding can also be used for the acquisition and installation of security equipment on real property (including buildings and improvements) owned or leased by the nonprofit organization, specifically in prevention of and/or in protection against the risk of a terrorist attack. "]
[{"$nulls":4},"(2,200 character max - not including spaces)"]
{"$rows_empty":13}
[{"$nulls":4},"In this section, list all target hardening equipment being proposed. Include the Authorized Equipment List (AEL) number and description, the vulnerability the equipment addresses, and the funding requested.  \nAllowable equipment is limited to two categories of items on the AEL:\n   - AEL Category 14 - Physical Security Enhancement Equipment \n   - AEL Category 15 - Inspection and Screening Systems \nThe equipment categories are listed on the web based AEL on the FEMA website, https://www.fema.gov/authorized-equipment-list.  "]
{"$rows_empty":10}
[{"$nulls":4},"AEL Number",null,null,"         Description of Item to be Purchased",{"$nulls":3},"         Vulnerability to be Addressed",{"$nulls":3},"    Funding Requested"]
[]
[{"$nulls":3},"Ex.","14SW-01-ALRM",null,null,"Systems/Sensors, Alarm",{"$nulls":3},"Vulnerable entry",{"$nulls":4},{"v":7000,"d":"$7,000"}]
[{"$nulls":3},"1."]
[]
[{"$nulls":3},"2."]
[]
[{"$nulls":3},"3."]
[]
[{"$nulls":3},"4."]
[]
[{"$nulls":3},"5."]
[]
[{"$nulls":3},"6."]
[]
[{"$nulls":3},"7."]
[]
[{"$nulls":3},"8."]
[]
[{"$nulls":3},"9."]
[]
[{"$nulls":3},"10."]
[]
[]
[{"$nulls":3},"V. Milestones"]
[]
[{"$nulls":4},"Provide description and associated key activities that lead to the milestone event over the NSGP period of performance.  Start dates should reflect the start of the associated key activities and end dates should reflect when the milestone event will occur.  Milestones should reflect considerations to Environmental Planning and Historic Preservation reviews when applicable. (10 milestones maximum) "]
[]
[{"$nulls":4},"(1,000 character max - not including spaces)"]
[]
[{"$nulls":5},"Milestone",{"$nulls":7},"State Date",null,null,"Completion Date"]
[]
[{"$nulls":5},{"$f":"CONCATENATE(\"Remaining Characters in Table: \",1000-SUM(M170:M188,P170:P188,S170:S188))","v":"Remaining Characters in Table: 1000"}]
[]
[{"$nulls":4},{"v":1,"d":"1."},{"$nulls":7},{"$f":"LEN(F170)","v":0},null,null,{"$f":"LEN(N170)","v":0},null,null,{"$f":"LEN(Q170)","v":0}]
[]
[{"$nulls":4},{"v":2,"d":"2."},{"$nulls":7},{"$f":"LEN(F172)","v":0},null,null,{"$f":"LEN(N172)","v":0},null,null,{"$f":"LEN(Q172)","v":0}]
[]
[{"$nulls":4},{"v":3,"d":"3."},{"$nulls":7},{"$f":"LEN(F174)","v":0},null,null,{"$f":"LEN(N174)","v":0},null,null,{"$f":"LEN(Q174)","v":0}]
[]
[{"$nulls":4},{"v":4,"d":"4."},{"$nulls":7},{"$f":"LEN(F176)","v":0},null,null,{"$f":"LEN(N176)","v":0},null,null,{"$f":"LEN(Q176)","v":0}]
[]
[{"$nulls":4},{"v":5,"d":"5."},{"$nulls":7},{"$f":"LEN(F178)","v":0},null,null,{"$f":"LEN(N178)","v":0},null,null,{"$f":"LEN(Q178)","v":0}]
[]
[{"$nulls":4},{"v":6,"d":"6."},{"$nulls":7},{"$f":"LEN(F180)","v":0},null,null,{"$f":"LEN(N180)","v":0},null,null,{"$f":"LEN(Q180)","v":0}]
[]
[{"$nulls":4},{"v":7,"d":"7."},{"$nulls":7},{"$f":"LEN(F182)","v":0},null,null,{"$f":"LEN(N182)","v":0},null,null,{"$f":"LEN(Q182)","v":0}]
[]
[{"$nulls":4},{"v":8,"d":"8."},{"$nulls":7},{"$f":"LEN(F184)","v":0},null,null,{"$f":"LEN(N184)","v":0},null,null,{"$f":"LEN(Q184)","v":0}]
[]
[{"$nulls":4},{"v":9,"d":"9."},{"$nulls":7},{"$f":"LEN(F186)","v":0},null,null,{"$f":"LEN(N186)","v":0},null,null,{"$f":"LEN(Q186)","v":0}]
[]
[{"$nulls":4},{"v":10,"d":"10."},{"$nulls":7},{"$f":"LEN(F188)","v":0},null,null,{"$f":"LEN(N188)","v":0},null,null,{"$f":"LEN(Q188)","v":0}]
[]
[]
[{"$nulls":3},"VI. Project Management"]
[]
[]
[]
[{"$nulls":4},"Who will manage the project:"]
[{"$nulls":4},"Include the name, phone number, and/or email address, and experience of the project manager(s)"]
{"$rows_empty":11}
[{"$nulls":4},"Describe the project management, including:"]
[{"$nulls":4},"- Description of any challenges to the effective implementation of this project"]
[{"$nulls":4},"- Coordination of the project with State and local homeland security partners"]
[]
[{"$nulls":4},"(2,000 character max - not including spaces)"]
{"$rows_empty":23}
[{"$nulls":3},"VII. Impact"]
[]
[{"$nulls":4},"What measurable outputs and outcomes will indicate that this Investment is successful at the end of the period of performance? "]
[{"$nulls":4},"(2,200 character max - not including spaces)"]
{"$rows_empty":16}
[{"$nulls":4}," Which specific National Preparedness Goal (the Goal) core capabilities does this investment work to achieve?  Explain how this Investment supports the building or sustaining of these Goal core capabilities. For more information on the Goal see: http://www.fema.gov/national-preparedness-goal."]
[]
[]
[]
[]
[{"$nulls":3},"Bonus: Funding History"]
[]
[{"$nulls":4},"Nonprofit applicants that have not received NSGP funding in the past will receive one bonus point to their final State score at the time of application submission to FEMA.  If the nonprofit organization has received NSGP funding in the past, provide the funding source, funding amount, funding year, and the investment type."]
[]
[{"$nulls":5},"NSGP Funding in the Past (yes/no)"]
[]
[{"$nulls":5},"Year(s) NSGP Funding Received"]
[]
[{"$nulls":5},"Funding Amount"]
[]
[{"$nulls":5},"Investment Type"]
[]
[{"$nulls":4},"Additional Information"]
{"$rows_empty":11}
[{"$nulls":5},"Applicant Contact Information"]
[]
[{"$nulls":6},"I certify that I am an employee of the aforementioned nonprofit organization or have been hired by the nonprofit organization to apply on their behalf for the NSGP."]
[]
[]
[{"$nulls":6},"Name and e-mail address or phone number"]
[]
[]
[]
[]
[null,null,"End of Sheet"]

{"sheet":"Dropdowns - Hide Before Use","index":2,"n_rows":30,"n_cols":4,"rows_kept":30,"hidden":true}
[]
[null,"Anaheim/Santa Ana Area"]
[null,"Atlanta Area","Yes","New"]
[null,"Baltimore Area","No","Ongoing"]
[null,"Bay Area"]
[null,"Boston Area"]
[null,"Charlotte Area"]
[null,"Chicago Area"]
[null,"Cleveland Area"]
[null,"Dallas/Fort Worth/Arlington Area"]
[null,"Denver Area"]
[null,"Detroit Area"]
[null,"Houston Area"]
[null,"Jersey City/Newark Area"]
[null,"Las Vegas Area"]
[null,"Los Angeles/Long Beach Area"]
[null,"Miami/Fort Lauderdale Area"]
[null,"National Capital Region"]
[null,"New York City Area"]
[null,"Philadelphia Area"]
[null,"Phoenix Area"]
[null,"Pittsburgh Area"]
[null,"Portland Area"]
[null,"Riverside Area"]
[null,"Sacramento Area"]
[null,"San Diego Area"]
[null,"Seattle Area"]
[null,"St. Louis Area"]
[null,"Tampa Area"]
[null,"Twin Cities Area"]

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Sheet3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}