{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Document","Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":14,"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":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[50,1,50,2]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2024 Homeland Security State Share"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Planning Costs",null,{"$f":"'Budget Detail'!$E$15","v":0}]
[]
["Organizational Costs",null,{"$f":"'Budget Detail'!$E$23","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!$E$31","v":0}]
[]
["Training Costs",null,{"$f":"'Budget Detail'!$E$39","v":0}]
[]
["Exercises Costs",null,{"$f":"'Budget Detail'!$E$47","v":0}]
[]
["Maintenance Costs",null,{"$f":"'Budget Detail'!$E$55","v":0}]
[]
["Management and Administration Costs",null,{"$f":"'Budget Detail'!$E$63","v":0}]
[]
["Construction and Renovation Costs",null,{"$f":"'Budget Detail'!$E$71","v":0}]
[]
["EHP Costs",null,{"$f":"'Budget Detail'!$E$79","v":0}]
[]
["MHC Costs",null,{"$f":"'Budget Detail'!$E$87","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!$E$95","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!$E$103","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!$E$105","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":105,"n_cols":5,"rows_kept":105,"cut":false,"hidden":false,"merged":[[97,0,97,4],[98,0,98,4],[102,0,102,3],[9,0,9,4],[10,0,10,4],[14,0,14,3],[33,0,33,4],[25,0,25,4],[17,0,17,4],[18,0,18,4],[22,0,22,3],[89,0,89,4],[26,0,26,4],[30,0,30,3],[41,0,41,4],[42,0,42,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[7,0,7,4],[46,0,46,3],[81,0,81,4],[82,0,82,4],[86,0,86,3],[57,0,57,4],[58,0,58,4],[62,0,62,3],[105,0,105,4],[6,0,6,4],[50,0,50,4],[54,0,54,3],[73,0,73,4],[74,0,74,4],[78,0,78,3],[104,0,104,3],[90,0,90,4],[94,0,94,3],[65,0,65,4],[66,0,66,4],[70,0,70,3],[49,0,49,4],[34,0,34,4],[38,0,38,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!$A$19","v":"FFY 2024 Homeland Security State Share"}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", 'Budget Summary'!$B$51)","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 ","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(Organization,-4,4))","v":0}]
[]
[]
["ORGANIZATIONAL"]
[]
["Activity","Cost","Quantity","Description ","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(Organization,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","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(Equipment,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING"]
[]
["Activity","Cost","Quantity","Description ","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(Exercises,-4,4))","v":0}]
[]
[]
["EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","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(Exercises,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE"]
[]
["Activity","Cost","Quantity","Description ","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Maintenance,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","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(NMA,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","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(Construction,3,4):OFFSET(EHP,-4,4))","v":0}]
[]
[]
["ENVIRONMENTAL PLANNING AND HISTORIC PRESERVATION COMPLIANCE (EHP)"]
[]
["Activity","Cost","Quantity","Description ","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B77=\"\",\"\",ROUND(ROUND(B77,4)*ROUND(C77,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B78=\"\",\"\",ROUND(ROUND(B78,4)*ROUND(C78,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(EHP,3,4):OFFSET(MHC,-4,4))","v":0}]
[]
[]
["MASSACHUSETTS HISTORICAL COMMISSION (MHC) AND/OR LOCAL HISTORIC COMMISSION REVIEW"]
[]
["Activity","Cost","Quantity","Description ","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,4)*ROUND(C85,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B86=\"\",\"\",ROUND(ROUND(B86,4)*ROUND(C86,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(MHC,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B94=\"\",\"\",ROUND(ROUND(B94,4)*ROUND(C94,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Activity","Cost","Quantity","Description ","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B101=\"\",\"\",ROUND(ROUND(B101,4)*ROUND(C101,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E23+E31+E39+E47+E55+E63+E71+E79+E87+E95+E103),2)","v":0}]