{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Questions","Allowable Cost Categories","Budget Summary","Primary Application","Subaward 1","Subaward 2","Subaward 3","Subaward 4","Subaward 5","Subaward 6","Subaward 7","Subaward 8","Subaward 9","Subaward 10","Subaward Totals","Helper"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":156,"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":"Questions","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,0,7,1],[2,0,4,1]]}
["1. Please enter the name of the primary applicant:"]
[]
["Funding Parameters: The Individual Option allows for one individual non-profit 501(c)(3) organization to apply for a single community-based restorative justice grant; Maximum award amount of up to $20,000. The Group Option allows for two or more organizations to collaborate on a community-based restorative justice award and apply for a maximum award amount of up to $50,000. Only one joint application is needed for all organizations involved. The primary applicatnt must be an established community-based restorative justice organization/working group in existence for greater than one-year (partners don't need to be a non-profit 501(c)(3) to be considered subawardees."]
[]
[]
["2. Please choose the award option that you will be applying for:"]
[]
[{"$f":"IF(B6=\"\", \"\", IF(B6 = \"Individual Option\", Helper!B1, Helper!B2))","v":""}]
[]
[{"$f":"IF(B6=\"Group Option\", \"3. Please choose the number of subawards that will be given:\", \"\")","v":""}]
[]
["Subaward #","Name of Subawardee"]
["Subaward 1"]
["Subaward 2"]
["Subaward 3"]
["Subaward 4"]
["Subaward 5"]
["Subaward 6"]
["Subaward 7"]
["Subaward 8"]
["Subaward 9"]
["Subaward 10"]

{"sheet":"Allowable Cost Categories","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Allowable Budget Cost Categories ","Definitions and Documentation Requirements "]
["1. Personnel Costs","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. Overtime is not permitted with these funds.  "]
["2. Fringe Benefit Costs","A copy of your agency's fringe rate agreement must be provided with the application submission. Eligible costs include the employer share of the following: life insurance, health insurance, social security costs, pension costs, unemployment insurance costs, workers compensation insurance, FMLA costs, and payroll taxes. Cost amounts for direct fringe benefits can be either actual costs or rates per employee calculated by the fiscal or human resource unit in your organization (rate computations must be included)."]
["3. Indirect Costs","Federally negotiated and approved rate for costs that are not readily assignable to a particular project, but are necessary to the operation, maintenance of the organization and performance of the project. Include copy of federally negotiated approved rate agreement or if you do not have one, you can use the de minimis rate of 10%. "]
["4. Consultants Costs","Consultants are individuals hired to provide a service and possess expertise (restorative justice trainer, speakers, etc. The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and subsistence costs  ."]
["5. Contracts/Subawards Costs","List subawards such as contracts to partnering agencies/organizations. "]
["6. Equipment/Technology Costs","Tangible non-expendable personal property directly supporting the program and having a useful life of more than one year; cost based on classification of equipment. "]
["7. Travel Costs","Costs associated with attending meetings from your base to community forums, training, etc.  $.62 per mile is the maximum rate allowed for mileage reimbursement.  No out of state travel is permitted.  "]
["8. Supplies Costs","Supplies required for program (e.g., postage, training materials, copying paper, center piece, talking piece, and other expendable items such as books, ink, etc.). "]
["9. Other Costs","Items (e.g., rent costs, telephone costs, etc.) Reasonable food and beverage costs for meetings is permitted. Food costs will need to be preapproved by OGR prior to purchase. "]

{"sheet":"Budget Summary","index":2,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":true,"merged":[[1,0,2,2],[18,0,18,2],[46,1,46,2]]}
[]
["Attachment B - Budget Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY2023 Commonwealth Restorative Justice Community Grant"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Primary Application'!E17","v":0}]
[]
["Overtime Costs",null,{"$f":"'Primary Application'!E27","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Primary Application'!E37","v":0}]
[]
["Indirect Costs",null,{"$f":"'Primary Application'!E47","v":0}]
[]
["Consultants Costs",null,{"$f":"'Primary Application'!E57","v":0}]
[]
["Subawards Costs",null,{"$f":"'Primary Application'!E67","v":0}]
[]
["Equipment Costs",null,{"$f":"'Primary Application'!E77","v":0}]
[]
["Travel Costs",null,{"$f":"'Primary Application'!E87","v":0}]
[]
["Supplies Costs",null,{"$f":"'Primary Application'!E97","v":0}]
[]
["Other Costs",null,{"$f":"'Primary Application'!E107","v":0}]
[]
["Total Costs",null,{"$f":"'Primary Application'!E109","v":0}]
[]
[]
["Name of Applicant Organization ",{"$f":"IF(Questions!$B$1=\"\",\"\",Questions!$B$1)","v":""}]

{"sheet":"Primary Application","index":3,"n_rows":109,"n_cols":5,"rows_kept":109,"cut":false,"hidden":true,"merged":[[8,0,8,4],[26,0,26,3],[109,0,109,4],[96,0,96,3],[86,0,86,3],[106,0,106,3],[108,0,108,3],[36,0,36,3],[20,0,20,4],[29,0,29,4],[30,0,30,4],[66,0,66,3],[46,0,46,3],[39,0,39,4],[40,0,40,4],[59,0,59,4],[60,0,60,4],[9,0,9,4],[10,0,10,4],[19,0,19,4],[49,0,49,4],[50,0,50,4],[56,0,56,3],[16,0,16,3],[7,0,7,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[99,0,99,4],[100,0,100,4],[80,0,80,4],[69,0,69,4],[70,0,70,4],[89,0,89,4],[90,0,90,4],[76,0,76,3],[79,0,79,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Primary Application Budget Detail - \", Questions!$B$1)","v":"Primary Application Budget Detail - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["If your organization chose Option 2 on the Questions tab, please be aware that the total amount that you are requesting funding for cannot be solely for the purpose of subawards. Your organization must budget for other activities besides subawards. If Option 1 was chosen, but your organization plans on giving out a subaward, please go back to the Questions tab, select Option 2 from the dropdown, and select how many subawards will be distributed."]
["All fringe and indirect rate agreements reported below must be consistent with how they will reported during the quarterly/monthly reimbursements. If these rates change during the grant period, please contact your program manager."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),2))","v":""}]
[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"]
["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(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,4),2))","v":1664}]
[null,null,null,null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,4),2))","v":""}]
[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"]
["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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,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(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,6),2))","v":1038.46}]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,6),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,6),2))","v":2056.15}]
[null,null,null,null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,6),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,4),2))","v":9450}]
[null,null,null,null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B84=\"\",\"\",ROUND(ROUND(B84,4)*ROUND(C84,4),2))","v":225}]
[null,null,null,null,{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,4)*ROUND(C85,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B94=\"\",\"\",ROUND(ROUND(B94,4)*ROUND(C94,4),2))","v":75}]
[null,null,null,null,{"$f":"IF(B95=\"\",\"\",ROUND(ROUND(B95,4)*ROUND(C95,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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":390}]
["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(B104=\"\",\"\",ROUND(ROUND(B104,4)*ROUND(C104,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B105=\"\",\"\",ROUND(ROUND(B105,4)*ROUND(C105,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(E17+E27+E37+E47+E57+E67+E87+E77+E97+E107),2)","v":0}]

{"sheet":"Subaward 1","index":4,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[38,0,38,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[78,0,78,4],[39,0,39,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[99,0,99,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[79,0,79,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$13)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 2","index":5,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$14)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 3","index":6,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$15)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 4","index":7,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$16)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 5","index":8,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$17)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 6","index":9,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$18)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 7","index":10,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$19)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 8","index":11,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$20)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 9","index":12,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$21)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward 10","index":13,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"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],[39,0,39,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[15,0,15,3],[18,0,18,4],[19,0,19,4],[25,0,25,3],[28,0,28,4],[29,0,29,4],[35,0,35,3],[38,0,38,4],[79,0,79,4],[45,0,45,3],[48,0,48,4],[49,0,49,4],[55,0,55,3],[58,0,58,4],[59,0,59,4],[65,0,65,3],[68,0,68,4],[69,0,69,4],[75,0,75,3],[78,0,78,4],[105,0,105,3],[107,0,107,3],[108,0,108,4],[85,0,85,3],[88,0,88,4],[89,0,89,4],[95,0,95,3],[98,0,98,4],[99,0,99,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"FY2023 Commonwealth Restorative Justice Community Grant"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$22)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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 your grant manager."]
["Please note that ONLY the main beneficiary of the grant funds can budget for Contracts/Subawards. A group that is considered to be a subaward on the Questions tab cannot plan on passing through any funds that were given to them to another organization. "]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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"]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[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"]
["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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses per the negotiated indirect rate are direct salaries and direct fringe, take the sum of all applicable expenses and multiply by the federally approved rate. 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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":1534.67}]
["Example: Tracey Thomas",11423.08,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 Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Consultants,-4,4))","v":0}]
[]
[]
["CONSULTANTS"]
[]
["Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/SUBAWARDS"]
[]
["Subrecipients Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Organization ABC",10000,1,"A subaward of $10,000 will be granted to Organization ABC for providing restorative just services to local communities.",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":10000}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":150}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":310}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":225}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":75}]
[null,null,null,null,""]
[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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(B102=\"\",\"\",ROUND(ROUND(B102,4)*ROUND(C102,4),2))","v":390}]
["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(B103=\"\",\"\",ROUND(ROUND(B103,4)*ROUND(C103,4),2))","v":1500}]
[null,null,null,null,""]
[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(E16+E26+E36+E46+E56+E66+E86+E76+E96+E106),2)","v":0}]

{"sheet":"Subaward Totals","index":14,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
["Subaward Budgets"]
["Cost \nCategories",{"$f":"CONCATENATE(\"Subaward 1 - \", Questions!$B$13)","v":"Subaward 1 - "},{"$f":"CONCATENATE(\"Subaward 2 - \", Questions!$B$14)","v":"Subaward 2 - "},{"$f":"CONCATENATE(\"Subaward 3 - \", Questions!$B$15)","v":"Subaward 3 - "},{"$f":"CONCATENATE(\"Subaward 4 - \", Questions!$B$16)","v":"Subaward 4 - "},{"$f":"CONCATENATE(\"Subaward 5 - \", Questions!$B$17)","v":"Subaward 5 - "}]
["Personnel Costs",{"$f":"'Subaward 1'!$E$16","v":0},{"$f":"'Subaward 2'!$E$16","v":0},{"$f":"'Subaward 3'!$E$16","v":0},{"$f":"'Subaward 4'!$E$16","v":0},{"$f":"'Subaward 5'!$E$16","v":0}]
["Fringe Costs",{"$f":"'Subaward 1'!$E$36","v":0},{"$f":"'Subaward 2'!$E$36","v":0},{"$f":"'Subaward 3'!$E$36","v":0},{"$f":"'Subaward 4'!$E$36","v":0},{"$f":"'Subaward 5'!$E$36","v":0}]
["Indirect Costs",{"$f":"'Subaward 1'!$E$46","v":0},{"$f":"'Subaward 2'!$E$46","v":0},{"$f":"'Subaward 3'!$E$46","v":0},{"$f":"'Subaward 4'!$E$46","v":0},{"$f":"'Subaward 5'!$E$46","v":0}]
["Consultant Costs",{"$f":"'Subaward 1'!$E$56","v":0},{"$f":"'Subaward 2'!$E$56","v":0},{"$f":"'Subaward 3'!$E$56","v":0},{"$f":"'Subaward 4'!$E$56","v":0},{"$f":"'Subaward 5'!$E$56","v":0}]
["Contracts/Subawards"]
["Equipment Costs",{"$f":"'Subaward 1'!$E$76","v":0},{"$f":"'Subaward 2'!$E$76","v":0},{"$f":"'Subaward 3'!$E$76","v":0},{"$f":"'Subaward 4'!$E$76","v":0},{"$f":"'Subaward 5'!$E$76","v":0}]
["Travel Costs",{"$f":"'Subaward 1'!$E$86","v":0},{"$f":"'Subaward 2'!$E$86","v":0},{"$f":"'Subaward 3'!$E$86","v":0},{"$f":"'Subaward 4'!$E$86","v":0},{"$f":"'Subaward 5'!$E$86","v":0}]
["Supplies Costs",{"$f":"'Subaward 1'!$E$96","v":0},{"$f":"'Subaward 2'!$E$96","v":0},{"$f":"'Subaward 3'!$E$96","v":0},{"$f":"'Subaward 4'!$E$96","v":0},{"$f":"'Subaward 5'!$E$96","v":0}]
["Other Costs",{"$f":"'Subaward 1'!$E$106","v":0},{"$f":"'Subaward 2'!$E$106","v":0},{"$f":"'Subaward 3'!$E$106","v":0},{"$f":"'Subaward 4'!$E$106","v":0},{"$f":"'Subaward 5'!$E$106","v":0}]
["TOTALS:",{"$f":"'Subaward 1'!$E$108","v":0},{"$f":"'Subaward 2'!$E$108","v":0},{"$f":"'Subaward 3'!$E$108","v":0},{"$f":"'Subaward 4'!$E$108","v":0},{"$f":"'Subaward 5'!$E$108","v":0}]
[]
[]
["Cost \nCategories",{"$f":"CONCATENATE(\"Subaward 6 - \", Questions!$B$18)","v":"Subaward 6 - "},{"$f":"CONCATENATE(\"Subaward 7 - \", Questions!$B$19)","v":"Subaward 7 - "},{"$f":"CONCATENATE(\"Subaward 8 - \", Questions!$B$20)","v":"Subaward 8 - "},{"$f":"CONCATENATE(\"Subaward 9 - \", Questions!$B$21)","v":"Subaward 9 - "},{"$f":"CONCATENATE(\"Subaward 10 - \", Questions!$B$22)","v":"Subaward 10 - "}]
["Personnel Costs",{"$f":"'Subaward 6'!$E$16","v":0},{"$f":"'Subaward 7'!$E$16","v":0},{"$f":"'Subaward 8'!$E$16","v":0},{"$f":"'Subaward 9'!$E$16","v":0},{"$f":"'Subaward 10'!$E$16","v":0}]
["Fringe Costs",{"$f":"'Subaward 6'!$E$36","v":0},{"$f":"'Subaward 7'!$E$36","v":0},{"$f":"'Subaward 8'!$E$36","v":0},{"$f":"'Subaward 9'!$E$36","v":0},{"$f":"'Subaward 10'!$E$36","v":0}]
["Indirect Costs",{"$f":"'Subaward 6'!$E$46","v":0},{"$f":"'Subaward 7'!$E$46","v":0},{"$f":"'Subaward 8'!$E$46","v":0},{"$f":"'Subaward 9'!$E$46","v":0},{"$f":"'Subaward 10'!$E$46","v":0}]
["Consultant Costs",{"$f":"'Subaward 6'!$E$56","v":0},{"$f":"'Subaward 7'!$E$56","v":0},{"$f":"'Subaward 8'!$E$56","v":0},{"$f":"'Subaward 9'!$E$56","v":0},{"$f":"'Subaward 10'!$E$56","v":0}]
["Contracts/Subawards"]
["Equipment Costs",{"$f":"'Subaward 6'!$E$76","v":0},{"$f":"'Subaward 7'!$E$76","v":0},{"$f":"'Subaward 8'!$E$76","v":0},{"$f":"'Subaward 9'!$E$76","v":0},{"$f":"'Subaward 10'!$E$76","v":0}]
["Travel Costs",{"$f":"'Subaward 6'!$E$86","v":0},{"$f":"'Subaward 7'!$E$86","v":0},{"$f":"'Subaward 8'!$E$86","v":0},{"$f":"'Subaward 9'!$E$86","v":0},{"$f":"'Subaward 10'!$E$86","v":0}]
["Supplies Costs",{"$f":"'Subaward 6'!$E$96","v":0},{"$f":"'Subaward 7'!$E$96","v":0},{"$f":"'Subaward 8'!$E$96","v":0},{"$f":"'Subaward 9'!$E$96","v":0},{"$f":"'Subaward 10'!$E$96","v":0}]
["Other Costs",{"$f":"'Subaward 6'!$E$106","v":0},{"$f":"'Subaward 7'!$E$106","v":0},{"$f":"'Subaward 8'!$E$106","v":0},{"$f":"'Subaward 9'!$E$106","v":0},{"$f":"'Subaward 10'!$E$106","v":0}]
["TOTALS:",{"$f":"'Subaward 6'!$E$108","v":0},{"$f":"'Subaward 7'!$E$108","v":0},{"$f":"'Subaward 8'!$E$108","v":0},{"$f":"'Subaward 9'!$E$108","v":0},{"$f":"'Subaward 10'!$E$108","v":0}]
[]
[]
["Grand Total:",{"$f":"SUM(B13:F13,B26:F26)","v":0}]

{"sheet":"Helper","index":15,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Individual Option Text","You are applying for the Individual Option, with a maximum award amount of up to $20,000. There will be no subawards given. Please take the time to read the AGF to better understand what expenses are and are not allowable. The Allowable Cost Categories tab, highlighted in green, will provide definitions of the allowable budget cost categories. The Budget Summary and Primary Application tabs, highlighted in blue, will need to be completed by the primary applicant. The Subawards section in the Primary Application should not be completed unless, Individual Option is changed to Group Option in Question 2."]
["Group Option Text","You are applying for the Group Option, with a maximum award amount of up to $50,000. This allows for subawards to be given. Please take the time to read the AGF to better understand what expenses are and are not allowable. The Allowable Cost Categories tab, highlighted in green, will provide definitions of the allowable budget cost categories. Using the drop-down in Question 3, select the number of subawards that will be given. For each subaward, enter the names of the subawardees in the fields that populate. The Budget Summary and Primary Application tabs, highlighted in blue, will need to be completed by the primary applicant. The Subtotal listed in Subawards in these tabs should be the total amount that will be distributed to all subawardees. The primary applicant must have other activities budgeted (Ex. Personnel, Supplies, Consultants) in other to be eligible to pass through funds to subawardees. Depending on the number of subawards chosen in Question 3, each subawardee will need to have their own completed budget, highlighted in red. A subawardee will not be eligible to award funds to another subawardee. Please check that all subawardee budgets are accurate in the Subaward Totals tab, highlighted in red. The Grand Total at the bottom of the Subaward Totals tab should reflect the Subawards Section in the Primary Application tab. If not, please make any adjustment as needed. "]