{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Budget Summary","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[41,1,41,3]]}
[]
["Attachment B - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY2022 Emerging Adults Reentry Initiative                            Technical Assistance Provider"]
[]
[]
["Cost Categories","State Share",null,"Total"]
[]
[]
["Personnel Costs",{"$f":"'Budget Detail'!E13","v":0},null,{"$f":"B25","v":0}]
[]
["Fringe Costs",{"$f":"'Budget Detail'!E23","v":0},null,{"$f":"B27","v":0}]
[]
["Consultants/Contractors Costs",{"$f":"'Budget Detail'!E33","v":0},null,{"$f":"B29","v":0}]
[]
["Equipment Costs",{"$f":"'Budget Detail'!E43","v":0},null,{"$f":"B31","v":0}]
[]
["Travel Costs",{"$f":"'Budget Detail'!E53","v":0},null,{"$f":"B33","v":0}]
[]
["Supplies Costs",{"$f":"'Budget Detail'!E63","v":0},null,{"$f":"B35","v":0}]
[]
["Other Costs",{"$f":"'Budget Detail'!E73","v":0},null,{"$f":"B37","v":0}]
[]
["Total",{"$f":"B25+B27+B29+B31+B33+B35+B37","v":0},null,{"$f":"D25+D27+D29+D31+D33+D35+D37","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":1,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[[15,0,15,4],[12,0,12,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[46,0,46,4],[36,0,36,4],[56,0,56,4],[75,0,75,4],[55,0,55,4],[65,0,65,4],[62,0,62,3],[52,0,52,3],[72,0,72,3],[74,0,74,3],[66,0,66,4],[16,0,16,4],[26,0,26,4],[25,0,25,4],[22,0,22,3],[45,0,45,4],[32,0,32,3],[42,0,42,3],[35,0,35,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Justice & Prevention Division"]
[{"$f":"CONCATENATE(\"Budget Worksheets - \",'Budget Summary'!B42)","v":"Budget Worksheets - "}]
[]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. A copy of staff resume(s) and/or job descriptions must be included in the applicant's response. Click the \"Add Personnel\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Pay Rate","Quantity","Description ","Total Cash Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Advocate worked a total of 300 hours during the QTR at $23.4875/hr. (300 hours cash)",{"$f":"IF(B9=\"\",\"\",ROUND(B9,4)*ROUND(C9,2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods",{"$f":"IF(B10=\"\",\"\",ROUND(B10,4)*ROUND(C10,2))","v":10384.619999999999}]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX: Eligible costs include the employer share of the following: life insurance, health insurance, social security costs, pension costs, unemployment insurance costs, workers compensation insurance, payroll taxes, FMLA. 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). A copy of the approved rate agreement should be included with the application response. This can be either a federally approved fringe rate or a breakout of what rates are being charged per eligible cost. Click the \"Add Fringe\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Total Cash Expenditures"]
["Example: Sue Smith",7046.25,0.21,"Take Sue Smith's 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%)",{"$f":"IF(B19=\"\",\"\",ROUND(B19,4)*ROUND(C19,4))","v":1479.7124999999999}]
["Example: Tracey Thomas ",10384.620000000001,0.1,"Take Tracey Thomas' 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(B20=\"\",\"\",ROUND(B20,4)*ROUND(C20,4))","v":1038.4620000000002}]
[null,null,null,null,{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTORS/CONSULTANTS: List each subcontractor and/or consultant along with their rate. The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and subsistence costs).  Any request for compensation over $650 per day hour day or $81.25 per hour requires prior written approval by EOPSS. Requests for a waiver of this requirement, with documented justification, must be made in writing at the time of application. A competitive process based on the municipality’s procurement policy should be followed when procuring contracted services. Contract salary, fringe benefit, travel, and other costs should be placed within this category and follow instructions within personnel, fringe, travel and other cost categories. Click the \"Add C/C\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Total Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days",{"$f":"IF(B29=\"\",\"\",ROUND(B29,4)*ROUND(C29,2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B30=\"\",\"\",ROUND(B30,4)*ROUND(C30,2))","v":9450}]
[null,null,null,null,{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT: List the purchases of tangible non-expendable personal property having a useful life of more than one year. Equipment must be directly related to the program implementation. Please see the AGF for more specific Equipment guidelines. Click the \"Add Equipment\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Equipment","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Laptop",1200,1,"Dell 1000 Laptop. Purchased (1) laptop at a rate of $1200.",{"$f":"IF(B39=\"\",\"\",ROUND(B39,4)*ROUND(C39,2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. Purchased (3) keyboards at $50/each",{"$f":"IF(B40=\"\",\"\",ROUND(B40,4)*ROUND(C40,2))","v":150}]
[null,null,null,null,{"$f":"IF(B41=\"\",\"\",ROUND(ROUND(B41,4)*ROUND(C41,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL: This must be travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not in excess of $0.45 per mile, as well as the actual costs of tolls and parking. No grant funds may be spent for out of state conference fees, out of state travel or out of state lodging without prior written approval from OGR. Click the \"Add Travel\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Rate","Quantity","Description","Total Cash Expenditures"]
["Example: Sue Smith",17,1,"Parking for DV roundtable on 2/7/18",{"$f":"IF(B49=\"\",\"\",ROUND(B49,4)*ROUND(C49,2))","v":17}]
["Example: Tracey Thomas",0.45,200,"Travel related to DV cases; $0.45/mile x 200 miles",{"$f":"IF(B50=\"\",\"\",ROUND(B50,4)*ROUND(C50,2))","v":90}]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES: List the purchases of supplies required for program (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.). Click the \"Add Supplies\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Supplies/Company","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes",{"$f":"IF(B59=\"\",\"\",ROUND(B59,4)*ROUND(C59,2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B60=\"\",\"\",ROUND(B60,4)*ROUND(C60,2))","v":75}]
[null,null,null,null,{"$f":"IF(B61=\"\",\"\",ROUND(B61,4)*ROUND(C61,2))","v":""}]
[null,null,null,null,{"$f":"IF(B62=\"\",\"\",ROUND(B62,4)*ROUND(C62,2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER: List the purchases for other expenses not applicable in the aforementioned that were incurred due to this program implementation (e.g., telephone costs, training material costs). Click the \"Add Other\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Item/Company","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Telephone",65,3,"Verizon: January-March at $65 per month",{"$f":"IF(B69=\"\",\"\",ROUND(B69,4)*ROUND(C69,2))","v":195}]
["Example: Heat",3200,0.25,"Total bill for office for quarter was $3,200.00; this program is 1/4 of office space",{"$f":"IF(B70=\"\",\"\",ROUND(B70,4)*ROUND(C70,2))","v":800}]
[null,null,null,null,{"$f":"IF(B71=\"\",\"\",ROUND(B71,4)*ROUND(C71,2))","v":""}]
[null,null,null,null,{"$f":"IF(B72=\"\",\"\",ROUND(B72,4)*ROUND(C72,2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E23+E33+E43+E53+E63+E73),2)","v":0}]