{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","AEL Equipment List"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":10,"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":"Budget Summary","index":1,"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 2024 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":2,"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 2024 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 read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. Please note that the 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 the Examples using the \"Add\" command button to add another row if needed. If you have any questions, please contact the  grant manager assigned in the NOFO document."]
["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."]
[]
["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":"AEL Equipment List","index":3,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["03OE-03-MEGA - System, Public Address, Handheld or Mobile "]
["03OE-03-SIGN - Signs"]
["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 "]
["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 "]