{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Object Classes"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":4,"defined_names":168,"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":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[43,1,43,3]]}
[]
["Attachment A - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Residential Substance Abuse Treatment Grant"]
[]
["Cost Categories","Federal Costs","Match Costs","Total Costs"]
[]
[]
["Personnel",{"$f":"'Budget Detail'!E17","v":0},{"$f":"'Budget Detail'!F17","v":0},{"$f":"'Budget Detail'!G17","v":0}]
[]
["Fringe Benefits & Payroll Tax",{"$f":"'Budget Detail'!E27","v":0},{"$f":"'Budget Detail'!F27","v":0},{"$f":"'Budget Detail'!G27","v":0}]
[]
["Indirect",{"$f":"'Budget Detail'!E37","v":0},{"$f":"'Budget Detail'!F37","v":0},{"$f":"'Budget Detail'!G37","v":0}]
[]
["Consultants & Contracts",{"$f":"'Budget Detail'!E47","v":0},{"$f":"'Budget Detail'!F47","v":0},{"$f":"'Budget Detail'!G47","v":0}]
[]
["Travel",{"$f":"'Budget Detail'!E57","v":0},{"$f":"'Budget Detail'!F57","v":0},{"$f":"'Budget Detail'!G57","v":0}]
[]
["Equipment & Technology",{"$f":"'Budget Detail'!E67","v":0},{"$f":"'Budget Detail'!F67","v":0},{"$f":"'Budget Detail'!G67","v":0}]
[]
["Supplies",{"$f":"'Budget Detail'!E77","v":0},{"$f":"'Budget Detail'!F77","v":0},{"$f":"'Budget Detail'!G77","v":0}]
[]
["Other",{"$f":"'Budget Detail'!E87","v":0},{"$f":"'Budget Detail'!F87","v":0},{"$f":"'Budget Detail'!G87","v":0}]
[]
["Total Costs",{"$f":"'Budget Detail'!E89","v":0},{"$f":"'Budget Detail'!F89","v":0},{"$f":"'Budget Detail'!G89","v":0}]
[]
["Match Requirement",{"$f":"ROUND(B40/3,2)","v":0}]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":89,"n_cols":8,"rows_kept":89,"cut":false,"hidden":false,"merged":[[50,0,50,6],[89,0,89,6],[76,0,76,3],[56,0,56,3],[86,0,86,3],[88,0,88,3],[69,0,69,6],[70,0,70,6],[79,0,79,6],[80,0,80,6],[66,0,66,3],[59,0,59,6],[60,0,60,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[16,0,16,3],[8,0,8,4],[9,0,9,6],[10,0,10,6],[5,0,5,6],[6,0,6,6],[7,0,7,6],[39,0,39,6],[40,0,40,6],[49,0,49,6],[46,0,46,3],[19,0,19,6],[20,0,20,6],[26,0,26,3],[29,0,29,6],[30,0,30,6],[36,0,36,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!A19","v":"Residential Substance Abuse Treatment Grant"}]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B44)","v":"Attachment A - "}]
[]
["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. The items marked as Example are only examples, and do not necessarily reflect items in your requested budget. 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. Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs."]
["Applicants proposing residential treatment programs may apply for up to $35,000. Applicants proposing jail-based treatment programs may apply for up to $30,000. For each federal dollar awarded, the sub-recipient must provide a match toward the cost of the program. Federal grant funds provided may not exceed 75% of the total cost of your program. A match of at least 25% of the total cost of the program must be provided by your agency. The 25% matching funds may be in the form of cash or in-kind contributions. The Match amount must be entered into the Match Expenditures column (Column F) in order for the requested amount to be calculated from the Total Expenditures. To determine the Match Requirement, take (Total Requested Cash Expenditures / 3). The Match Requirement is also located at the bottom of the Budget Summary page."]
["Since awards will be disbursed via Interdepartmental Service Agreement (ISA), please indicate what object class will be used for each line item associated with \"Cash Expenses\" using Column H. \"Cash Expenses\" determines the amount of your federal award. Every line item that does not have this action completed will result in a red Column H cell. This will help reflect 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 A."]
[]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. A copy of staff resume(s) and/or job descriptions must be included in the applicant’s response."]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Sue Smith",23.487500000000001,300,"Please describe duties of Employee here. ",{"$f":"IF(G13=\"\",\"\",G13-F13)","v":7046.25},0,{"$f":"IF(B13=\"\",\"\",ROUND(B13,4)*ROUND(C13,2))","v":7046.25},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15-F15)","v":""},null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,8)*ROUND(C15,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G16=\"\",\"\",G16-F16)","v":""},null,{"$f":"IF(B16=\"\",\"\",ROUND(ROUND(B16,8)*ROUND(C16,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Fringe,-4,4))","v":0},{"$f":"SUM(OFFSET(Personnel,5,5):OFFSET(Fringe,-4,5))","v":0},{"$f":"SUM(OFFSET(Personnel,5,6):OFFSET(Fringe,-4,6))","v":0}]
[]
[]
["FRINGE BENEFITS & PAYROLL TAX:  For application purposes, 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.        "]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Sue Smith",7046.25,0.21,"Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is \"Personnel.\" Take Sue Smith's total wages reported on this worksheet under the \"Personnel\" section and multiply by the federally approved fringe rate or the fringe rate that was proposed and approved by OGR in the application process. ($7,046.25 * 21%). Match expenditures should be in relation to the match in the applicable category. ",{"$f":"IF(G23=\"\",\"\",G23-F23)","v":1479.7124999999999},null,{"$f":"IF(B23=\"\",\"\",ROUND(B23,4)*ROUND(C23,4))","v":1479.7124999999999},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25-F25)","v":""},null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,8)*ROUND(C25,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G26=\"\",\"\",G26-F26)","v":""},null,{"$f":"IF(B26=\"\",\"\",ROUND(ROUND(B26,8)*ROUND(C26,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0},{"$f":"SUM(OFFSET(Fringe,5,5):OFFSET(Indirect,-4,5))","v":0},{"$f":"SUM(OFFSET(Fringe,5,6):OFFSET(Indirect,-4,6))","v":0}]
[]
[]
["INDIRECT: A COPY OF YOUR AGENCY'S INDIRECT RATE AGREEMENT MUST BE PROVIDED WITH THE APPLICATION SUBMISSION. 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."]
[]
["Indirect Expenses","Expenses Applied to Indirect","Contract Indirect Rate","Description","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses are all categories, take the sum of all categories and multiply by the federally approved rate. If allowable expenses are only Personnel and Fringe like in this example, take the approved rate and multiply by the sum of Personnel and Fringe total costs associated with Sue Smith.      (18% * (7046.25 + 1479.71)). ",{"$f":"IF(G33=\"\",\"\",G33-F33)","v":1534.6727999999998},null,{"$f":"IF(B33=\"\",\"\",ROUND(B33,4)*ROUND(C33,4))","v":1534.6727999999998},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G35=\"\",\"\",G35-F35)","v":""},null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,8)*ROUND(C35,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G36=\"\",\"\",G36-F36)","v":""},null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,8)*ROUND(C36,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0},{"$f":"SUM(OFFSET(Indirect,5,5):OFFSET(Contractors,-4,5))","v":0},{"$f":"SUM(OFFSET(Indirect,5,6):OFFSET(Contractors,-4,6))","v":0}]
[]
[]
["CONSULTANTS & CONTRACTS: This includes consultant or contractor fees. The maximum rate for consultants is $650 for an eight hour day or $81.25 per hour (excluding travel and subsistence costs). Any request for compensation over $650 per 8 hour day or $81.25 per hour requires prior written approval by EOPSS. This rate is the exception, not the rule."]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: JJ Counseling",200,24,"Please describe purpose of Contractor/Consultant here.",{"$f":"IF(G43=\"\",\"\",G43-F43)","v":2000},2800,{"$f":"IF(B43=\"\",\"\",ROUND(B43,4)*ROUND(C43,2))","v":4800},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G45=\"\",\"\",G45-F45)","v":""},null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,8)*ROUND(C45,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G46=\"\",\"\",G46-F46)","v":""},null,{"$f":"IF(B46=\"\",\"\",ROUND(ROUND(B46,8)*ROUND(C46,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Travel,-4,4))","v":0},{"$f":"SUM(OFFSET(Contractors,5,5):OFFSET(Travel,-4,5))","v":0},{"$f":"SUM(OFFSET(Contractors,5,6):OFFSET(Travel,-4,6))","v":0}]
[]
[]
["TRAVEL: Travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not in excess of $0.62 per mile, as well as the actual costs of tolls and parking. No grant funds may be spent for out-of-state conference fees, out- of-state travel or out-of-state lodging without prior written approval from OGR."]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Sue Smith",0.62,125,"Travel related to grant; $0.62/mile x 125 miles",{"$f":"IF(G53=\"\",\"\",G53-F53)","v":77.5},0,{"$f":"IF(B53=\"\",\"\",ROUND(B53,4)*ROUND(C53,2))","v":77.5},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G55=\"\",\"\",G55-F55)","v":""},null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,8)*ROUND(C55,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G56=\"\",\"\",G56-F56)","v":""},null,{"$f":"IF(B56=\"\",\"\",ROUND(ROUND(B56,8)*ROUND(C56,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Equipment,-4,4))","v":0},{"$f":"SUM(OFFSET(Travel,5,5):OFFSET(Equipment,-4,5))","v":0},{"$f":"SUM(OFFSET(Travel,5,6):OFFSET(Equipment,-4,6))","v":0}]
[]
[]
["EQUIPMENT & TECHNOLOGY: Tangible non-expendable personal property having a useful life of more than one year; cost based on classification of equipment."]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(G63=\"\",\"\",G63-F63)","v":1075},125,{"$f":"IF(B63=\"\",\"\",ROUND(B63,4)*ROUND(C63,2))","v":1200},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G65=\"\",\"\",G65-F65)","v":""},null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,8)*ROUND(C65,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G66=\"\",\"\",G66-F66)","v":""},null,{"$f":"IF(B66=\"\",\"\",ROUND(ROUND(B66,8)*ROUND(C66,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0},{"$f":"SUM(OFFSET(Equipment,5,5):OFFSET(Supplies,-4,5))","v":0},{"$f":"SUM(OFFSET(Equipment,5,6):OFFSET(Supplies,-4,6))","v":0}]
[]
[]
["SUPPLIES: General supplies required for program (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.)."]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(G73=\"\",\"\",G73-F73)","v":100},100,{"$f":"IF(B73=\"\",\"\",ROUND(B73,4)*ROUND(C73,2))","v":200},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G75=\"\",\"\",G75-F75)","v":""},null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,8)*ROUND(C75,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G76=\"\",\"\",G76-F76)","v":""},null,{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,8)*ROUND(C76,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0},{"$f":"SUM(OFFSET(Supplies,5,5):OFFSET(Other,-4,5))","v":0},{"$f":"SUM(OFFSET(Supplies,5,6):OFFSET(Other,-4,6))","v":0}]
[]
[]
["OTHER: List the purchases for other expenses not applicable in the aforementioned that were incurred due to this program implementation (e.g., telephone costs, training material costs). "]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures","Object Class"]
["Example: Telephone",65,6,"Please describe purpose of item/activity here. ",{"$f":"IF(G83=\"\",\"\",G83-F83)","v":390},0,{"$f":"IF(B83=\"\",\"\",ROUND(B83,4)*ROUND(C83,2))","v":390},"\"AA\""]
[]
[null,null,null,null,{"$f":"IF(G85=\"\",\"\",G85-F85)","v":""},null,{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,8)*ROUND(C85,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G86=\"\",\"\",G86-F86)","v":""},null,{"$f":"IF(B86=\"\",\"\",ROUND(ROUND(B86,8)*ROUND(C86,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0},{"$f":"SUM(OFFSET(Other,5,5):OFFSET(GrandTotal,-3,5))","v":0},{"$f":"SUM(OFFSET(Other,5,6):OFFSET(GrandTotal,-3,6))","v":0}]
[]
["Grand Total(s):",null,null,null,{"$f":"ROUND(SUM(E17+E27+E37+E47+E57+E67+E77+E87),2)","v":0},{"$f":"ROUND(SUM(F17+F27+F37+F47+F57+F67+F77+F87),2)","v":0},{"$f":"ROUND(SUM(G17+G27+G37+G47+G57+G67+G77+G87),2)","v":0}]

{"sheet":"Object Classes","index":3,"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'!H:H,'Object Classes'!A2,'Budget Detail'!E:E)","v":0}]
["BB","State Employee - Related Expenses",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A3,'Budget Detail'!E:E)","v":0}]
["CC","Special Employees / Contracted Services",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A4,'Budget Detail'!E:E)","v":0}]
["DD","Pension and Insurance - Related Expenditures",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A5,'Budget Detail'!E:E)","v":0}]
["EE","Administrative Expenses",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A6,'Budget Detail'!E:E)","v":0}]
["FF","Programmatic Facility Operational Supplies and Related Expenses",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A7,'Budget Detail'!E:E)","v":0}]
["GG","Energy Costs, Utilities, and Space Rental Expenses",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A8,'Budget Detail'!E:E)","v":0}]
["HH","Consultant Service Contracts",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A9,'Budget Detail'!E:E)","v":0}]
["JJ","Programmatic Operational Services",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A10,'Budget Detail'!E:E)","v":0}]
["KK","Programmatic Equipment Purchase",{"$f":"SUMIF('Budget Detail'!H:H,'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'!H:H,'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'!H:H,'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'!H:H,'Object Classes'!A14,'Budget Detail'!E:E)","v":0}]
["PP","Grants and Subsidies",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A15,'Budget Detail'!E:E)","v":0}]
["RR","Entitlement Programs",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A16,'Budget Detail'!E:E)","v":0}]
["SS","Debt Payment",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A17,'Budget Detail'!E:E)","v":0}]
["TT","Loans and Special Payments",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A18,'Budget Detail'!E:E)","v":0}]
["UU","Information Technology Expenses",{"$f":"SUMIF('Budget Detail'!H:H,'Object Classes'!A19,'Budget Detail'!E:E)","v":0}]
[null,null,{"$f":"SUM(C2:C19)","v":0}]