{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Opening Document","Questions","Budget Summary","Budget Detail","AEL Equipment List"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":15,"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":"Opening Document","index":0,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UPON OPENING DOCUMENT…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IF THE RED BANNER OCCURS…."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. DOWNLOAD DOCUMENT AND SAVE TO DESKTOP"]
[null,"2. RIGHT CLICK, PROPERTIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. CHECK OFF UNBLOCK, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Questions","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,0,6,1],[0,0,0,1]]}
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. All (3) questions must be answered using the blue cells in Column B so the applicant can complete the actual budget. "]
[]
["1. Enter the name of the nonprofit 501(c)(3) organization applying for this grant. "]
[]
["Funding Parameters: Applicants must be a nonprofit 501(c)(3) organization and need to demonstrate, through the application, that the organization is at high risk of a terrorist or other extremist attack. There are (2) funding streams that an applicant can apply for: Urban Areas (NSGP-NSS-UA) and State (NSGP-NSS-S). Urban Areas consist of the sites of nonprofits located in Boston, Brookline, Cambridge, Chelsea, Everett, Quincy, Revere, Somerville, and Winthrop. NSGP-NSS-S (\"State\") involves the sites of nonprofits located outside the Urban Areas locations. A nonprofit organization may run multiple sites. A site may fall under Urban Areas or State depending on the town/city of which the site is located in. An applicant can apply for up to (3) sites for Urban Areas and up to (3) sites for State for a total of (6) sites. For each site, the applicant must fill out a separate budget to be submitted with the Investment Justification (IJ) for that site. Please note that an applicant cannot exceed $200,000 for any individual site and if an applicant intends on applying for multiple sites, the total amount for all of those sites cannot exceed $600,000, even if the sites fall under both funding streams. By applying individually, you cannot apply as part of a consortium. "]
[]
[]
["2. Choose the funding stream you will be applying for from the dropdown menu:"]
[]
["3. Enter the city/town name of the site that will be funded:"]

{"sheet":"Budget Summary","index":2,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":true,"merged":[[1,0,2,2],[18,0,18,2],[42,1,42,2],[44,1,44,2]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"FFY 2024 Nonprofit Security Grant Program Supplemental Funding\", \" - \", Questions!B8)","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding - "}]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Planning Costs",null,{"$f":"'Budget Detail'!E13","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E21","v":0}]
[]
["Maintenance & Sustainment Costs",null,{"$f":"'Budget Detail'!E29","v":0}]
[]
["Training & Exercises Costs",null,{"$f":"'Budget Detail'!E37","v":0}]
[]
["M&A Costs",null,{"$f":"'Budget Detail'!E45","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E53","v":0}]
[]
["Construction & Renovation Costs",null,{"$f":"'Budget Detail'!E61","v":0}]
[]
["Contracted Security Costs",null,{"$f":"'Budget Detail'!E69","v":0}]
[]
["Total Costs",null,{"$f":"C24+C26+C28+C30+C32+C34+C36+C38","v":0}]
[]
[]
["Name of Nonprofit Organization ",{"$f":"IF(Questions!B3=\"\",\"\",Questions!B3)","v":""}]
[]
["Site Location",{"$f":"IF(Questions!B10=\"\",\"\",Questions!B10)","v":""}]

{"sheet":"Budget Detail","index":3,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[71,0,71,4],[24,0,24,4],[28,0,28,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[44,0,44,3],[47,0,47,4],[23,0,23,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[31,0,31,4],[16,0,16,4],[20,0,20,3],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B3, \" (\", Questions!B10, \")\")","v":"Budget Worksheet -  ()"}]
[]
["Please take a moment to read the Availability of Grant Funds (AGF) document prior to completing this budget. Each subrecipient will be expected to follow the guidance that is posted in this AGF. The AGF 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. Please note that budgeted subtotals will auto-populate based on the numbers reported within each category. Your requested budget per cost category shall be entered in the rows below using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,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(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,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(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,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(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,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(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,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(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"AEL Equipment List","index":4,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["03OE-03-MEGA - System, Public Address, Handheld or Mobile "]
["03OE-03-SIGN - Signs"]
["04AP-05-CRED - System, Credentialing "]
["04AP-06-VIDA - Software, Video Analytics"]
["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 "]
["06CC-02-PAGE - Services/Systems, Paging "]
["06CP-01-PORT - Radio, Portable "]
["06CP-01-REPT - Repeater"]
["06CP-03-ICOM - Intercom "]
["06CP-03-PRAC - Accessories, Portable Radio "]
["10GE-00-GENR - Generators "]
["10PE-00-UPS - Supply, Uninterruptible Power (UPS)"]
["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-ASTN - Network, Acoustic Sensor Triangulation"]
["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 "]