{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Opening Document","Appendix A Guidelines","Budget Summary","Budget Detail","Object Classes","Helper"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":12,"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":"Appendix A Guidelines","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[6,0,8,0]]}
[null,"Definitions and Documentation Requirements"]
["Personnel","Costs associated with agency personnel. List position, percentage of time charged to grant, and annual salary. Include a brief description of each staff member’s duties/activities to be supported by grant funding. All \"AA\" and \"CC\" employees should be listed as Personnel."]
[]
["Overtime","Indicate overtime rate for each employee charged to the grant and the number of overtime hours. Refer to OGR Overtime Policy in the AGF. This should be classified as Object Code A08."]
["Fringe","State Agencies should use the CTR BFY2026 total Proposed Fringe Rate and Payroll Tax Rate of 37.81%. Uniformed employees should apply a total rate of 53.04%. If an applicant is budgeting for Commonwealth Contracted Employees (Object Class: CC) or Overtime (Object Code: A08), please only apply the Payroll Tax Rate of 2.21% plus any additional employer PFML contribution that may apply.                                                        "]
["Indirect","A federally approved Indirect Cost Rate Agreement is required (if not using the de minimis 15% indirect cost rate). Refer to your agency's Indirect Cost Rate Agreement for applicable expenses (Object Classes/Object Codes) to be used as your base. State Agencies should use their BFY2026 approved indirect rate agreement. All line items subject to indirect per the indirect rate agreement should be accounted for in the cost category that the budgeted line item resides (Ex. Planning, Organizational, Equipment...)."]
["Contractors/Consultants","Contractors: A contractor is when an entity is hired to provide specific goods or services to support the project, without substantial involvement in the project’s overall goals."]
[null,"Consultants: The maximum rate for consultants is $650 for an eight- hour day or $81.25 per hour. Any request for compensation over $650 per day requires prior written approval by OGR. Waiver of this maximum rate is at the discretion of OGR."]
[null,"All costs related to these services (Salaries/Fringe/M&A/Subsistence) should be coded as Contractors/Consultants."]
["Subawards","A subaward is when an organization receives funds to carry out a significant portion of a larger project’s goals, essentially acting as a partner in the project. Under a subaward, the award recipient transfers its responsibility to perform part of the project to another entity. All costs pertaining to the subaward should be coded as Subawards. "]
["Travel","Travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not to exceed $.62 per mile, as well as the actual costs of tolls and parking.  Out-of-state travel, or out-of-state lodging must be budgeted according to the current federal per diem rates which can be found here: https://www.gsa.gov/travel/plan-book/per-diem-rates. All Travel must be preapproved by OGR."]
["Supplies","Supplies directly correlated to the program. Supplies include any materials that are expendable or consumed during the course of the project."]
["Other","List items (e.g., rent, telephone, use of space, etc.) and provide computation. These items wouldn't be classified in the aforementioned. "]

{"sheet":"Budget Summary","index":2,"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY2025 Homeland Security State Share"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Planning Costs",null,{"$f":"'Budget Detail'!$E$16","v":0}]
[]
["Organizational Costs",null,{"$f":"'Budget Detail'!$E$24","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!$E$32","v":0}]
[]
["Training Costs",null,{"$f":"'Budget Detail'!$E$40","v":0}]
[]
["Exercises Costs",null,{"$f":"'Budget Detail'!$E$48","v":0}]
[]
["Maintenance Costs",null,{"$f":"'Budget Detail'!$E$56","v":0}]
[]
["Construction and Renovation Costs",null,{"$f":"'Budget Detail'!$E$64","v":0}]
[]
["M&A Costs",null,{"$f":"'Budget Detail'!$E$72","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!$E$74","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":3,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[[27,0,27,4],[31,0,31,3],[42,0,42,4],[8,0,8,4],[43,0,43,4],[35,0,35,4],[39,0,39,3],[10,0,10,4],[11,0,11,4],[15,0,15,3],[34,0,34,4],[26,0,26,4],[18,0,18,4],[19,0,19,4],[23,0,23,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[7,0,7,4],[6,0,6,4],[47,0,47,3],[66,0,66,4],[67,0,67,4],[71,0,71,3],[74,0,74,4],[51,0,51,4],[55,0,55,3],[73,0,73,3],[58,0,58,4],[59,0,59,4],[63,0,63,3],[50,0,50,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!$A$19","v":"FFY2025 Homeland Security State Share"}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", 'Budget Summary'!$B$43)","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 AGF document."]
["Please take a moment to read the Availability of Grant Funds (AGF) prior to completing this budget. Each subrecipient will be expected to follow the guidance that is stated 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."]
["Since awards will be disbursed via Interdepartmental Service Agreement (ISA), please indicate what object class will be used for each line item using Column F. Every line item that does not have this action completed will result in a red Column F cell. This will help determine how the ISA Attachment B will be set up as well as how the award will be allocated in MMARS. The totals displayed per object class under the Object Classes tab should reflect how the totals will be displayed on the ISA Attachment B. Using Column A, please choose the genre of the budgeted line item as it is described in the Appendix A Guidelines tab."]
[]
["PLANNING"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",IF(OR(A14=\"Fringe\",A14=\"Indirect\"),SUM(ROUND(ROUND(B14,8)*ROUND(C14,8),2)/100),ROUND(ROUND(B14,8)*ROUND(C14,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",IF(OR(A15=\"Fringe\",A15=\"Indirect\"),SUM(ROUND(ROUND(B15,8)*ROUND(C15,8),2)/100),ROUND(ROUND(B15,8)*ROUND(C15,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Planning,3,4):OFFSET(Organizational,-4,4))","v":0}]
[]
[]
["ORGANIZATIONAL"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B22=\"\",\"\",IF(OR(A22=\"Fringe\",A22=\"Indirect\"),SUM(ROUND(ROUND(B22,8)*ROUND(C22,8),2)/100),ROUND(ROUND(B22,8)*ROUND(C22,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",IF(OR(A23=\"Fringe\",A23=\"Indirect\"),SUM(ROUND(ROUND(B23,8)*ROUND(C23,8),2)/100),ROUND(ROUND(B23,8)*ROUND(C23,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Organizational,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Activity","Cost","Quantity","Authorized Equipment List (AEL) # and Description","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(A30=\"Indirect\",SUM(ROUND(ROUND(B30,8)*ROUND(C30,8),2)/100),ROUND(ROUND(B30,8)*ROUND(C30,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B31=\"\",\"\",IF(A31=\"Indirect\",SUM(ROUND(ROUND(B31,8)*ROUND(C31,8),2)/100),ROUND(ROUND(B31,8)*ROUND(C31,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description ","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B38=\"\",\"\",IF(OR(A38=\"Fringe\",A38=\"Indirect\"),SUM(ROUND(ROUND(B38,8)*ROUND(C38,8),2)/100),ROUND(ROUND(B38,8)*ROUND(C38,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B39=\"\",\"\",IF(OR(A39=\"Fringe\",A39=\"Indirect\"),SUM(ROUND(ROUND(B39,8)*ROUND(C39,8),2)/100),ROUND(ROUND(B39,8)*ROUND(C39,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(Exercises,-4,4))","v":0}]
[]
[]
["EXERCISES"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description ","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B46=\"\",\"\",IF(OR(A46=\"Fringe\",A46=\"Indirect\"),SUM(ROUND(ROUND(B46,8)*ROUND(C46,8),2)/100),ROUND(ROUND(B46,8)*ROUND(C46,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B47=\"\",\"\",IF(OR(A47=\"Fringe\",A47=\"Indirect\"),SUM(ROUND(ROUND(B47,8)*ROUND(C47,8),2)/100),ROUND(ROUND(B47,8)*ROUND(C47,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Exercises,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description ","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B54=\"\",\"\",IF(OR(A54=\"Fringe\",A54=\"Indirect\"),SUM(ROUND(ROUND(B54,8)*ROUND(C54,8),2)/100),ROUND(ROUND(B54,8)*ROUND(C54,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B55=\"\",\"\",IF(OR(A55=\"Fringe\",A55=\"Indirect\"),SUM(ROUND(ROUND(B55,8)*ROUND(C55,8),2)/100),ROUND(ROUND(B55,8)*ROUND(C55,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Maintenance,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description ","Cash Expenditures","Object Classes"]
[null,null,null,null,{"$f":"IF(B62=\"\",\"\",IF(OR(A62=\"Fringe\",A62=\"Indirect\"),SUM(ROUND(ROUND(B62,8)*ROUND(C62,8),2)/100),ROUND(ROUND(B62,8)*ROUND(C62,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B63=\"\",\"\",IF(OR(A63=\"Fringe\",A63=\"Indirect\"),SUM(ROUND(ROUND(B63,8)*ROUND(C63,8),2)/100),ROUND(ROUND(B63,8)*ROUND(C63,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["MANAGEMENT & ADMINISTRATION (M&A) - CANNOT EXCEED 5% OF TOTAL BUDGET"]
[]
["Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description ","Cash Expenditures","Object Classes",null,"MAXIMUM M&A BUDGET:",{"$f":"ROUND((SUM(E16,E24,E32,E40,E48,E56,E64)/0.95)-SUM(E16,E24,E32,E40,E48,E56,E64),2)","v":0}]
[null,null,null,null,{"$f":"IF(B70=\"\",\"\",IF(OR(A70=\"Fringe\",A70=\"Indirect\"),SUM(ROUND(ROUND(B70,8)*ROUND(C70,8),2)/100),ROUND(ROUND(B70,8)*ROUND(C70,8),2)))","v":""}]
[null,null,null,null,{"$f":"IF(B71=\"\",\"\",IF(OR(A71=\"Fringe\",A71=\"Indirect\"),SUM(ROUND(ROUND(B71,8)*ROUND(C71,8),2)/100),ROUND(ROUND(B71,8)*ROUND(C71,8),2)))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E16+E24+E32+E40+E48+E56+E64+E72),2)","v":0}]

{"sheet":"Object Classes","index":4,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Object Classes","Description","Budgeted Totals"]
["AA","State Employee Compensation",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A2,'Budget Detail'!E:E)","v":0}]
["BB","State Employee - Related Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A3,'Budget Detail'!E:E)","v":0}]
["CC","Special Employees / Contracted Services",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A4,'Budget Detail'!E:E)","v":0}]
["DD","Pension and Insurance - Related Expenditures",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A5,'Budget Detail'!E:E)","v":0}]
["EE","Administrative Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A6,'Budget Detail'!E:E)","v":0}]
["FF","Programmatic Facility Operational Supplies and Related Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A7,'Budget Detail'!E:E)","v":0}]
["GG","Energy Costs, Utilities, and Space Rental Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A8,'Budget Detail'!E:E)","v":0}]
["HH","Consultant Service Contracts",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A9,'Budget Detail'!E:E)","v":0}]
["JJ","Programmatic Operational Services",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A10,'Budget Detail'!E:E)","v":0}]
["KK","Programmatic Equipment Purchase",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A11,'Budget Detail'!E:E)","v":0}]
["LL","Programmatic Equipment Tax Exempt Lease - Purchase (TELP), Lease and Rental, Maintenance and Repair",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A12,'Budget Detail'!E:E)","v":0}]
["MM","Purchased Client Human and Social Services and Non-Human Services Programs",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A13,'Budget Detail'!E:E)","v":0}]
["NN","Horizontal and Vertical Construction, Improvements, Maintenance and Repair Costs, and Land Acquisition",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A14,'Budget Detail'!E:E)","v":0}]
["PP","Grants and Subsidies",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A15,'Budget Detail'!E:E)","v":0}]
["RR","Entitlement Programs",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A16,'Budget Detail'!E:E)","v":0}]
["SS","Debt Payment",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A17,'Budget Detail'!E:E)","v":0}]
["TT","Loans and Special Payments",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A18,'Budget Detail'!E:E)","v":0}]
["UU","Information Technology Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A19,'Budget Detail'!E:E)","v":0}]
[null,null,{"$f":"SUM(C2:C19)","v":0}]

{"sheet":"Helper","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Personnel",null,"Equipment"]
["Overtime",null,"Indirect"]
["Fringe"]
["Indirect"]
["Contractors/Consultants"]
["Subawards"]
["Travel"]
["Supplies"]
["Other"]