{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Budget Summary","Budget Detail","Allowable Cost Categories","Unallowable Costs","AEL Equipment List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":20,"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":"Budget Summary","index":0,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[42,1,42,2]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2023 Nonprofit Security Grant Program"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Planning Costs",null,{"$f":"'Budget Detail'!E15","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E23","v":0}]
[]
["Maintenance & Sustainment Costs",null,{"$f":"'Budget Detail'!E31","v":0}]
[]
["Training & Exercises Costs",null,{"$f":"'Budget Detail'!E39","v":0}]
[]
["M&A Costs",null,{"$f":"'Budget Detail'!E47","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E55","v":0}]
[]
["Construction & Renovation Costs",null,{"$f":"'Budget Detail'!E63","v":0}]
[]
["Contracted Security Costs",null,{"$f":"'Budget Detail'!E71","v":0}]
[]
["Total Costs",null,{"$f":"C24+C26+C28+C30+C32+C34+C36+C38","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":1,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[[9,0,9,4],[10,0,10,4],[14,0,14,3],[33,0,33,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[7,0,7,4],[17,0,17,4],[41,0,41,4],[42,0,42,4],[46,0,46,3],[49,0,49,4],[18,0,18,4],[22,0,22,3],[73,0,73,4],[6,0,6,4],[26,0,26,4],[30,0,30,3],[65,0,65,4],[66,0,66,4],[70,0,70,3],[72,0,72,3],[50,0,50,4],[54,0,54,3],[57,0,57,4],[58,0,58,4],[62,0,62,3],[25,0,25,4],[34,0,34,4],[38,0,38,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
["Federal Fiscal Year 2023 Nonprofit Security Grant Program"]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", 'Budget Summary'!B43)","v":"Budget Worksheet - "}]
[]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have Enabled Macros and Content when prompted upon while opening this document. Please note that the subtotals will auto-populate based on the numbers reported within each category. In order for Total Cash Expenditures to show in Column E, a Cost and Quantity will need to be entered in Columns B and C. Your requested budget per cost category shall be entered in the rows below using the \"Add\" command button to add another row if needed. "]
["Please take a moment to read the Notice of Funding Opportunity (NOFO) prior to completing this budget. Each subrecipient will be expected to follow the guidance that is stated in this NOFO. The NOFO will highlight important aspects of this funding opportunity such as an grant overview, eligibility and application requirements, key dates, maximum funding request amounts, allowable costs, and unallowable costs. If applying for Indirect, the Indirect Cost Rate Agreement must be submitted at the time of application. "]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B29=\"\",\"\",ROUND(ROUND(B29,4)*ROUND(C29,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B30=\"\",\"\",ROUND(ROUND(B30,4)*ROUND(C30,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B37=\"\",\"\",ROUND(ROUND(B37,4)*ROUND(C37,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B38=\"\",\"\",ROUND(ROUND(B38,4)*ROUND(C38,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B46=\"\",\"\",ROUND(ROUND(B46,4)*ROUND(C46,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B61=\"\",\"\",ROUND(ROUND(B61,4)*ROUND(C61,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B69=\"\",\"\",ROUND(ROUND(B69,4)*ROUND(C69,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B70=\"\",\"\",ROUND(ROUND(B70,4)*ROUND(C70,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E23+E31+E39+E47+E55+E63+E71),2)","v":0}]

{"sheet":"Allowable Cost Categories","index":2,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[44,1,44,6],[46,1,46,6],[48,1,48,6],[0,0,0,6],[2,1,2,6],[4,1,4,6],[38,1,38,6],[40,1,40,6],[42,1,42,6]]}
["ALLOWABLE COSTS"]
[]
["1. PLANNING","Funding may be used for security or emergency planning expenses and the materials required to conduct planning activities.  Planning must be related to the protection of the facility and the people within the facility; this should include those with access and functional needs as well as those with limited English proficiency."]
[]
["2. EQUIPMENT","Funding may be used for the acquisition and installation of security equipment on real property owned or leased by the nonprofit organization, specifically to prevent or protect against a terrorist attack."]
[]
[null,"03OE-03-MEGA - System, Public Address, Handheld or Mobile "]
[null,"04AP-05-CRED - System, Credentialing "]
[null,"04AP-09-ALRT - Systems, Public Notification and Warning "]
[null,"04AP-11-SAAS - Applications, Software as a Service "]
[null,"05AU-00-TOKN - System, Remote Authentication "]
[null,"05EN-00-ECRP - Software, Encryption "]
[null,"05HS-00-MALW - Software, Malware/Anti-Virus Protection "]
[null,"05HS-00-PFWL - System, Personal Firewall "]
[null,"05NP-00-FWAL - Firewall, Network "]
[null,"05NP-00-IDPS - System, Intrusion Detection/Prevention "]
[null,"06CP-01-PORT - Radio, Portable "]
[null,"06CC-02-PAGE - Services/Systems, Paging "]
[null,"06CP-03-ICOM - Intercom "]
[null,"06CP-03-PRAC - Accessories, Portable Radio "]
[null,"10GE-00-GENR - Generators "]
[null,"13IT-00-ALRT - System, Alert/Notification "]
[null,"14CI-00-COOP - System, Information Technology Contingency Operations "]
[null,"14EX-00-BCAN - Receptacles, Trash, Blast-Resistant "]
[null,"14EX-00-BSIR - Systems, Building, Blast/Shock/Impact Resistant "]
[null,"14SW-01-ALRM - Systems/Sensors, Alarm "]
[null,"14SW-01-DOOR - Doors and Gates, Impact Resistant "]
[null,"14SW-01-LITE - Lighting, Area, Fixed "]
[null,"14SW-01-PACS - System, Physical Access Control "]
[null,"14SW-01-SIDP - Systems, Personnel Identification"]
[null,"14SW-01-SIDV - Systems, Vehicle Identification "]
[null,"14SW-01-SNSR - Sensors/Alarms, System and Infrastructure Monitoring, Standalone "]
[null,"14SW-01-VIDA - Systems, Video Assessment, Security "]
[null,"14SW-01-WALL - Barriers: Fences; Jersey Walls "]
[null,"15SC-00-PPSS - Systems, Personnel/Package Screening "]
[null,"21GN-00-INST - Installation "]
[null,"21GN-00-TRNG - Training and Awareness "]
[]
["3. MAINTENANCE AND SUSTAINMENT","Funding may be used for maintenance contracts, warranties, repair or replacement costs, upgrades, and user fees as described in DHS/FEMA Policy FP 205-402-125-1."]
[]
["4. TRAINING AND EXERCISES","Nonprofit organization security personnel may use NSGP funds to attend security-related training courses, exercises and programs in the United States. Allowable training-related costs under NSGP are limited to attendance fees for the training, and related expenses, such as materials, supplies, and/or equipment. Overtime, backfill, and/or travel expenses are not allowable costs. Allowable training topics are limited to the protection of Critical Infrastructure/Key Resources (CI/KR), including physical and cyber security, target hardening, and terrorism awareness/employee preparedness programs such as Community Emergency Response Team (CERT) training, Active Shooter training and emergency first aid.                                                                                                                        Training conducted using NSGP funds must address a specific threat, vulnerability and/or consequence, as identified in the nonprofit’s Investment Justification. Proposed attendance at training courses and all associated costs leveraging the FFY 2023 NSGP must be included in the nonprofit organization’s Investment Justification.  Proposed attendance at training/exercises and all associated costs using NSGP must be included in the IJ.                                                                                                                         The Homeland Security Exercise and Evaluation Program (HSEEP) provides a set of guiding principles for exercise programs, as well as a common approach to exercise program management, design, and development, conduct, evaluation, and improvement planning.  For additional information on HSEEP refer to https://www.fema.gov/emergency-managers/national-preparedness/exercises/hseep."]
[]
["5. NONPROFIT MANAGEMENT AND ADMINISTRATION (M&A)","Nonprofit organizations that receive an award under this program may use and expend up to five percent (5%) of their FFY 2023 NSGP funds for M&A purposes.  M&A costs are for activities directly related to the management and administration of the award, such as financial management and monitoring, submitting required programmatic and financial reports, establishing, and maintaining equipment inventory."]
[]
["6. INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS","Indirect costs are allowable under this program as described in 2 C.F.R. § 200.414. With the exception of recipients who have never received a negotiated indirect cost rate as described in 2 C.F.R. § 200.414(f). Recipients must have an approved indirect cost rate agreement with their cognizant federal agency to charge indirect costs to this award. The Indirect Cost Rate Agreement must be submitted at the time of application. "]
[]
["7. CONSTRUCTION AND RENOVATION","Any applicant considering submitting an application that involves construction and renovation cost must contact OGR prior to submission.  All recipients of NSGP funds must request and receive approval from DHS/FEMA before any funds are used for construction or renovation."]
[]
["8. CONTRACTED SECURITY","The recipient must be able to sustain this capability in future years without NSGP funding, and a sustainment plan will be part of the closeout package for any award funding this capability.  NSGP funds may not be used to purchase equipment for contracted security.  Contracted Security costs described in the IJ should include the hourly/daily rate, the number of personnel, and anticipated number of hours/days the personnel will work over the course of the period of performance.                                                                                                                Additionally, NSGP recipients and subrecipients may not use more than 50% of their award to pay for personnel activities unless a waiver is approved by FEMA."]

{"sheet":"Unallowable Costs","index":3,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,0,12,6],[0,0,0,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6],[6,0,6,6],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[17,0,17,6]]}
["UNALLOWABLE COSTS"]
[]
["·     Hiring of public safety personnel. NSGP funds may not be used to support sworn public safety officers for the purposes of fulfilling traditional public safety duties or to supplant traditional public safety positions and responsibilities."]
["·     General-use expenditures. Expenditures for items such as general-use software (word processing, spreadsheet, graphics, etc.), general-use computers and related equipment (other than for allowable M&A activities, or otherwise associated preparedness functions), general- use vehicles, licensing fees."]
["·     Overtime and backfill."]
["·     Weapons, weapons systems and accessories, ammunition, or weapons-related training."]
["·     Initiatives that do not address the implementation of programs/initiatives to build prevention and protection-focused capabilities directed at identified facilities and/or the surrounding communities."]
["·     The development of risk/vulnerability assessment models."]
["·     Initiatives that fund risk or vulnerability security assessments or the development of the Investment Justification."]
["·     Initiatives in which Federal agencies are the beneficiary or that enhance Federal property."]
["·     Initiatives that study technology development."]
["·     Proof-of-concept initiatives."]
["·     Initiatives that duplicate capabilities being provided by the Federal government."]
["·     Organizational operating expenses."]
["·     Reimbursement of pre-award security expenses."]
["·     Cameras for license plate readers/license plate reader software."]
["·     Cameras for facial recognition."]
["·     Knox Boxes."]

{"sheet":"AEL Equipment List","index":4,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["03OE-03-MEGA - System, Public Address, Handheld or Mobile "]
["04AP-05-CRED - System, Credentialing "]
["04AP-09-ALRT - Systems, Public Notification and Warning "]
["04AP-11-SAAS - Applications, Software as a Service "]
["05AU-00-TOKN - System, Remote Authentication "]
["05EN-00-ECRP - Software, Encryption "]
["05HS-00-MALW - Software, Malware/Anti-Virus Protection "]
["05HS-00-PFWL - System, Personal Firewall "]
["05NP-00-FWAL - Firewall, Network "]
["05NP-00-IDPS - System, Intrusion Detection/Prevention "]
["06CP-01-PORT - Radio, Portable "]
["06CC-02-PAGE - Services/Systems, Paging "]
["06CP-03-ICOM - Intercom "]
["06CP-03-PRAC - Accessories, Portable Radio "]
["10GE-00-GENR - Generators "]
["13IT-00-ALRT - System, Alert/Notification "]
["14CI-00-COOP - System, Information Technology Contingency Operations "]
["14EX-00-BCAN - Receptacles, Trash, Blast-Resistant "]
["14EX-00-BSIR - Systems, Building, Blast/Shock/Impact Resistant "]
["14SW-01-ALRM - Systems/Sensors, Alarm "]
["14SW-01-DOOR - Doors and Gates, Impact Resistant "]
["14SW-01-LITE - Lighting, Area, Fixed "]
["14SW-01-PACS - System, Physical Access Control "]
["14SW-01-SIDP - Systems, Personnel Identification"]
["14SW-01-SIDV - Systems, Vehicle Identification "]
["14SW-01-SNSR - Sensors/Alarms, System and Infrastructure Monitoring, Standalone "]
["14SW-01-VIDA - Systems, Video Assessment, Security "]
["14SW-01-WALL - Barriers: Fences; Jersey Walls "]
["15SC-00-PPSS - Systems, Personnel/Package Screening "]
["21GN-00-INST - Installation "]
["21GN-00-TRNG - Training and Awareness "]