{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Object Classes"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":132,"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":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[44,1,44,2]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Commonwealth Project Safe Neighborhood Initiative"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E18","v":0}]
[]
["Overtime Costs",null,{"$f":"'Budget Detail'!E28","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Budget Detail'!E38","v":0}]
[]
["Consultants and Contractors Costs",null,{"$f":"'Budget Detail'!E48","v":0}]
[]
["Subawards Costs",null,{"$f":"'Budget Detail'!E58","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E68","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E78","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E88","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E98","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!E100","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":false,"merged":[[6,0,6,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[20,0,20,4],[50,0,50,4],[100,0,100,4],[87,0,87,3],[67,0,67,3],[97,0,97,3],[99,0,99,3],[90,0,90,4],[91,0,91,4],[61,0,61,4],[70,0,70,4],[71,0,71,4],[80,0,80,4],[81,0,81,4],[77,0,77,3],[51,0,51,4],[57,0,57,3],[7,0,7,4],[60,0,60,4],[17,0,17,3],[9,0,9,4],[27,0,27,3],[37,0,37,3],[21,0,21,4],[30,0,30,4],[31,0,31,4],[47,0,47,3],[40,0,40,4],[41,0,41,4],[10,0,10,4],[11,0,11,4],[8,0,8,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Commonwealth Project Safe Neighborhood Initiative"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B45)","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. If you have any questions, please contact the grant manager assigned in the Availability of Grant Funds (AGF) document."]
["Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs. Cost category definitions are highlighted in the Budget Guidelines tab. "]
["Only a Massachusetts District Attorney’s Office and the Massachusetts State Police are eligible to apply. A District Attorney’s Office may solicit up to $100,000 in funding for this initiative, with a total of $1,100,000 available for all eleven (11) District Attorney Offices. The MSP may submit separate proposals covering different areas of the Commonwealth that they determine to have greatest need, with a total of $800,000 available to MSP. These funds must be prioritized to address the uptick in community violence and drug activity in our neighborhoods. Applicants may utilize funding over a 6-month period from January-June 30, 2025. Since these are state funds, all funds must be obligated prior to June 30, 2025."]
["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."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: Sue Smith",23.487500000000001,300,"Employee is projected to work a total of 300 hours during the grant at $23.4875/hr.",{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"Please describe duties of Employee here. ",{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),2))","v":10384.620000000001},"\"AA\""]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Overtime,-4,4))","v":0}]
[]
[]
["OVERTIME"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: Sue Smith",40,104,"Advocate worked a total of 104 hours for follow-up investigation of DV cases during the quarter at $40.00/hour. Reporting $2,500 match for S. Smith.",{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Please describe duties of Employee here. ",{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,4),2))","v":1664},"\"AA\""]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Overtime,5,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX"]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash 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(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,6),2))","v":1479.71}]
["Example: Tracey Thomas ",10384.620000000001,0.1,"Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is \"Personnel.\" Take Tracey Thomas' total wages reported on this worksheet under the \"Personnel\" section and multiply by the breakout of what rates are being charged per eligible cost. (7.5% - health insurance, 2% - life insurance, .5% - workers compensation). ",{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,6),2))","v":1038.46},"\"DD\""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B37=\"\",\"\",ROUND(ROUND(B37,4)*ROUND(C37,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONSULTANTS AND CONTRACTORS"]
[]
["Company Name/Activity","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":4800}]
["Example: JJ Contracting",45,210,"Please provide the names of each Contractor/Consultant and duties/obligations that will be performed here.",{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,4),2))","v":9450},"\"JJ\""]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Subawards,-4,4))","v":0}]
[]
[]
["SUBAWARDS (SUBGRANTS)"]
[]
["Subaward Name/Activity","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,4),2))","v":4800}]
["Example: JJ Subawards",45,210,"Please provide the names of each Subaward and duties/obligations that will be performed here.",{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,4),2))","v":9450},"\"PP\""]
[null,null,null,null,{"$f":"IF(B56=\"\",\"\",ROUND(ROUND(B56,4)*ROUND(C56,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Subawards,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Sue Smith",250,1,"Gas reimbursement related to grant. ",{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,4),2))","v":250}]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,4),2))","v":310},"\"BB\""]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,4),2))","v":1200},"\"UU\""]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,4)*ROUND(C76,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B84=\"\",\"\",ROUND(ROUND(B84,4)*ROUND(C84,4),2))","v":200},"\"EE\""]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,4)*ROUND(C85,4),2))","v":75}]
[null,null,null,null,{"$f":"IF(B86=\"\",\"\",ROUND(ROUND(B86,4)*ROUND(C86,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Promotional Printing",65,6,"Please describe purpose of item/activity here. ",{"$f":"IF(B94=\"\",\"\",ROUND(ROUND(B94,4)*ROUND(C94,4),2))","v":390},"\"EE\""]
["Example: Heat",6000,0.25,"Projected total bill for office during grant period is $6,000.00; this program is 1/4 of office space",{"$f":"IF(B95=\"\",\"\",ROUND(ROUND(B95,4)*ROUND(C95,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B96=\"\",\"\",ROUND(ROUND(B96,4)*ROUND(C96,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E18+E28+E38+E48+E58+E68+E78+E88+E98),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'!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}]