{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Document","Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Opening Document","index":0,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UPON OPENING DOCUMENT…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IF THE RED BANNER OCCURS…."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. DOWNLOAD DOCUMENT AND SAVE TO DESKTOP"]
[null,"2. RIGHT CLICK, PROPERTIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. CHECK OFF UNBLOCK, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Budget Summary","index":1,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[45,1,45,3]]}
[]
["Attachment A - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Violence Against Women Act STOP Grant"]
[]
["Cost Categories","Federal Costs","Match Costs","Total Costs"]
[]
[]
["Personnel",{"$f":"'Budget Detail'!E18","v":0},{"$f":"'Budget Detail'!F18","v":0},{"$f":"'Budget Detail'!G18","v":0}]
[]
["Overtime",{"$f":"'Budget Detail'!E28","v":0},{"$f":"'Budget Detail'!F28","v":0},{"$f":"'Budget Detail'!G28","v":0}]
[]
["Fringe Benefits & Payroll Tax",{"$f":"'Budget Detail'!E38","v":0},{"$f":"'Budget Detail'!F38","v":0},{"$f":"'Budget Detail'!G38","v":0}]
[]
["Indirect",{"$f":"'Budget Detail'!E48","v":0},{"$f":"'Budget Detail'!F48","v":0},{"$f":"'Budget Detail'!G48","v":0}]
[]
["Consultants & Contracts",{"$f":"'Budget Detail'!E58","v":0},{"$f":"'Budget Detail'!F58","v":0},{"$f":"'Budget Detail'!G58","v":0}]
[]
["Travel",{"$f":"'Budget Detail'!E68","v":0},{"$f":"'Budget Detail'!F68","v":0},{"$f":"'Budget Detail'!G68","v":0}]
[]
["Equipment & Technology",{"$f":"'Budget Detail'!E78","v":0},{"$f":"'Budget Detail'!F78","v":0},{"$f":"'Budget Detail'!G78","v":0}]
[]
["Supplies",{"$f":"'Budget Detail'!E88","v":0},{"$f":"'Budget Detail'!F88","v":0},{"$f":"'Budget Detail'!G88","v":0}]
[]
["Other",{"$f":"'Budget Detail'!E98","v":0},{"$f":"'Budget Detail'!F98","v":0},{"$f":"'Budget Detail'!G98","v":0}]
[]
["Total Costs",{"$f":"'Budget Detail'!E100","v":0},{"$f":"'Budget Detail'!F100","v":0},{"$f":"'Budget Detail'!G100","v":0}]
[]
["Match Requirement",{"$f":"ROUND(B42/3,2)","v":0}]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[17,0,17,3],[9,0,9,4],[10,0,10,6],[11,0,11,6],[5,0,5,6],[7,0,7,6],[6,0,6,6],[100,0,100,6],[87,0,87,3],[67,0,67,3],[97,0,97,3],[99,0,99,3],[80,0,80,6],[81,0,81,6],[90,0,90,6],[91,0,91,6],[77,0,77,3],[70,0,70,6],[71,0,71,6],[61,0,61,6],[8,0,8,6],[20,0,20,6],[21,0,21,6],[27,0,27,3],[50,0,50,6],[51,0,51,6],[60,0,60,6],[57,0,57,3],[30,0,30,6],[31,0,31,6],[37,0,37,3],[40,0,40,6],[41,0,41,6],[47,0,47,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!A19","v":"Violence Against Women Act STOP Grant"}]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B46)","v":"Attachment A - "}]
[]
["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 take a moment to read the Availability of Grant Funds (AGF) prior to completing this budget. Each subrecipient will be expected to follow the guidance that is stated in this AGF. The AGF will highlight important aspects of this funding opportunity such as an grant overview, eligibility and application requirements, key dates, maximum funding request amounts, allowable costs, and unallowable costs."]
["For each federal dollar awarded, the sub-recipient must provide a match toward the cost of the program. Federal grant funds provided may not exceed 75% of the total cost of your program. A match of at least 25% of the total cost of the program must be provided by your agency. The 25% matching funds may be in the form of cash or in-kind contributions. The Match amount must be entered into the Match Expenditures column (Column F) in order for the requested amount to be calculated from the Total Expenditures. To determine the Match Requirement, take (Total Requested Cash Expenditures / 3). The Match Requirement is also located at the bottom of the Budget Summary page."]
["A 25% match requirement imposed on grant funds under this program are for Law Enforcement, Prosecution and Courts only; Victim Service providers and Tribes are NOT required to provide match."]
[]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. Notification of changes to VAWA funded personnel (both award and/or match funded) must be made to the VAWA grant manager. "]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Please describe duties of Employee here.",{"$f":"IF(G14=\"\",\"\",G14-F14)","v":7046.25},0,{"$f":"IF(B14=\"\",\"\",ROUND(B14,4)*ROUND(C14,2))","v":7046.25}]
[]
[null,null,null,null,{"$f":"IF(G16=\"\",\"\",G16-F16)","v":""},null,{"$f":"IF(B16=\"\",\"\",ROUND(ROUND(B16,8)*ROUND(C16,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G17=\"\",\"\",G17-F17)","v":""},null,{"$f":"IF(B17=\"\",\"\",ROUND(ROUND(B17,8)*ROUND(C17,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Overtime,-4,4))","v":0},{"$f":"SUM(OFFSET(Personnel,5,5):OFFSET(Overtime,-4,5))","v":0},{"$f":"SUM(OFFSET(Personnel,5,6):OFFSET(Overtime,-4,6))","v":0}]
[]
[]
["OVERTIME: Allowable for all personnel working on the grant with adequate training and experience in responding to domestic and/or sexual violence incidents. Allowable costs are limited to costs associated with investigating cases; court appearances; attending trainings; and/or participating in high-risk/sexual assault teams are allowable."]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",40,104,"Please describe duties of Employee here. ",{"$f":"IF(G24=\"\",\"\",G24-F24)","v":1660},2500,{"$f":"IF(B24=\"\",\"\",ROUND(B24,4)*ROUND(C24,2))","v":4160}]
[]
[null,null,null,null,{"$f":"IF(G26=\"\",\"\",G26-F26)","v":""},null,{"$f":"IF(B26=\"\",\"\",ROUND(ROUND(B26,8)*ROUND(C26,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G27=\"\",\"\",G27-F27)","v":""},null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,8)*ROUND(C27,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Overtime,5,4):OFFSET(Fringe,-4,4))","v":0},{"$f":"SUM(OFFSET(Overtime,5,5):OFFSET(Fringe,-4,5))","v":0},{"$f":"SUM(OFFSET(Overtime,5,6):OFFSET(Fringe,-4,6))","v":0}]
[]
[]
["FRINGE BENEFITS & PAYROLL TAX:  A COPY OF YOUR AGENCY'S FRINGE RATE AGREEMENT MUST BE PROVIDED WITH THE APPLICATION SUBMISSION. Eligible costs may 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. "]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures","Match Expenditures","Total 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(G34=\"\",\"\",G34-F34)","v":1479.7124999999999},null,{"$f":"IF(B34=\"\",\"\",ROUND(B34,4)*ROUND(C34,4))","v":1479.7124999999999}]
[]
[null,null,null,null,{"$f":"IF(G36=\"\",\"\",G36-F36)","v":""},null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,8)*ROUND(C36,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G37=\"\",\"\",G37-F37)","v":""},null,{"$f":"IF(B37=\"\",\"\",ROUND(ROUND(B37,8)*ROUND(C37,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0},{"$f":"SUM(OFFSET(Fringe,5,5):OFFSET(Indirect,-4,5))","v":0},{"$f":"SUM(OFFSET(Fringe,5,6):OFFSET(Indirect,-4,6))","v":0}]
[]
[]
["INDIRECT:  A COPY OF YOUR AGENCY'S INDIRECT RATE AGREEMENT MUST BE PROVIDED WITH THE APPLICATION SUBMISSION. This agreement will determine the applicable base expenses that can be applied in this Attachment A. This is for costs that are not readily assignable to a particular project, but necessary to the operation, maintenance of the organization, and performance of the project. Include copy of rate agreement in the application response. Any non-federal entity, except for state, local units of government, or Indian tribes, that does not have a currently approved negotiated indirect cost rate may elect to charge a de minimis rate of 15% of modified total direct costs (MTDC), which may be used indefinitely."]
[]
["Indirect Expenses","Expenses Applied to Indirect","Contract Indirect Rate","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",8525.9599999999991,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses are all categories, take the sum of all categories and multiply by the federally approved rate. If allowable expenses are only Personnel and Fringe like in this example, take the approved rate and multiply by the sum of Personnel and Fringe total costs associated with Sue Smith.      (18% * (7046.25 + 1479.71)). ",{"$f":"IF(G44=\"\",\"\",G44-F44)","v":1534.6727999999998},null,{"$f":"IF(B44=\"\",\"\",ROUND(B44,4)*ROUND(C44,4))","v":1534.6727999999998}]
[]
[null,null,null,null,{"$f":"IF(G46=\"\",\"\",G46-F46)","v":""},null,{"$f":"IF(B46=\"\",\"\",ROUND(ROUND(B46,8)*ROUND(C46,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G47=\"\",\"\",G47-F47)","v":""},null,{"$f":"IF(B47=\"\",\"\",ROUND(ROUND(B47,8)*ROUND(C47,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0},{"$f":"SUM(OFFSET(Indirect,5,5):OFFSET(Contractors,-4,5))","v":0},{"$f":"SUM(OFFSET(Indirect,5,6):OFFSET(Contractors,-4,6))","v":0}]
[]
[]
["CONSULTANTS & CONTRACTS: This includes consultant or contractor fees. The maximum rate for consultants is $650 for an eight hour day or $81.25 per hour (excluding travel and subsistence costs). Any request for compensation over $650 per 8 hour day or $81.25 per hour requires prior written approval by EOPSS. This rate is the exception, not the rule. "]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: JJ Counseling",200,24,"Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here.",{"$f":"IF(G54=\"\",\"\",G54-F54)","v":2000},2800,{"$f":"IF(B54=\"\",\"\",ROUND(B54,4)*ROUND(C54,2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(G56=\"\",\"\",G56-F56)","v":""},null,{"$f":"IF(B56=\"\",\"\",ROUND(ROUND(B56,8)*ROUND(C56,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G57=\"\",\"\",G57-F57)","v":""},null,{"$f":"IF(B57=\"\",\"\",ROUND(ROUND(B57,8)*ROUND(C57,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Travel,-4,4))","v":0},{"$f":"SUM(OFFSET(Contractors,5,5):OFFSET(Travel,-4,5))","v":0},{"$f":"SUM(OFFSET(Contractors,5,6):OFFSET(Travel,-4,6))","v":0}]
[]
[]
["TRAVEL: Travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not in excess of $0.62 per mile, as well as the actual costs of tolls and parking. No grant funds may be spent for out-of-state conference fees, out- of-state travel or out-of-state lodging without prior written approval from OGR. "]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",0.62,125,"Travel related to grant; $0.62/mile x 125 miles",{"$f":"IF(G64=\"\",\"\",G64-F64)","v":77.5},0,{"$f":"IF(B64=\"\",\"\",ROUND(B64,4)*ROUND(C64,2))","v":77.5}]
[]
[null,null,null,null,{"$f":"IF(G66=\"\",\"\",G66-F66)","v":""},null,{"$f":"IF(B66=\"\",\"\",ROUND(ROUND(B66,8)*ROUND(C66,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G67=\"\",\"\",G67-F67)","v":""},null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,8)*ROUND(C67,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Equipment,-4,4))","v":0},{"$f":"SUM(OFFSET(Travel,5,5):OFFSET(Equipment,-4,5))","v":0},{"$f":"SUM(OFFSET(Travel,5,6):OFFSET(Equipment,-4,6))","v":0}]
[]
[]
["EQUIPMENT & TECHNOLOGY: Tangible non-expendable personal property having a useful life of more than one year; cost based on classification of equipment. Applicants should follow their organization's own procurement policy."]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(G74=\"\",\"\",G74-F74)","v":1075},125,{"$f":"IF(B74=\"\",\"\",ROUND(B74,4)*ROUND(C74,2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(G76=\"\",\"\",G76-F76)","v":""},null,{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,8)*ROUND(C76,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G77=\"\",\"\",G77-F77)","v":""},null,{"$f":"IF(B77=\"\",\"\",ROUND(ROUND(B77,8)*ROUND(C77,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0},{"$f":"SUM(OFFSET(Equipment,5,5):OFFSET(Supplies,-4,5))","v":0},{"$f":"SUM(OFFSET(Equipment,5,6):OFFSET(Supplies,-4,6))","v":0}]
[]
[]
["SUPPLIES: General supplies required for program (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.). "]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here.",{"$f":"IF(G84=\"\",\"\",G84-F84)","v":100},100,{"$f":"IF(B84=\"\",\"\",ROUND(B84,4)*ROUND(C84,2))","v":200}]
[]
[null,null,null,null,{"$f":"IF(G86=\"\",\"\",G86-F86)","v":""},null,{"$f":"IF(B86=\"\",\"\",ROUND(ROUND(B86,8)*ROUND(C86,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G87=\"\",\"\",G87-F87)","v":""},null,{"$f":"IF(B87=\"\",\"\",ROUND(ROUND(B87,8)*ROUND(C87,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0},{"$f":"SUM(OFFSET(Supplies,5,5):OFFSET(Other,-4,5))","v":0},{"$f":"SUM(OFFSET(Supplies,5,6):OFFSET(Other,-4,6))","v":0}]
[]
[]
["OTHER: List the purchases for other expenses not applicable in the aforementioned that were incurred due to this program implementation (e.g., telephone costs, training material costs). "]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Telephone",65,6,"Please describe purpose of item/activitiy here. ",{"$f":"IF(G94=\"\",\"\",G94-F94)","v":390},0,{"$f":"IF(B94=\"\",\"\",ROUND(B94,4)*ROUND(C94,2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(G96=\"\",\"\",G96-F96)","v":""},null,{"$f":"IF(B96=\"\",\"\",ROUND(ROUND(B96,8)*ROUND(C96,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G97=\"\",\"\",G97-F97)","v":""},null,{"$f":"IF(B97=\"\",\"\",ROUND(ROUND(B97,8)*ROUND(C97,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0},{"$f":"SUM(OFFSET(Other,5,5):OFFSET(GrandTotal,-3,5))","v":0},{"$f":"SUM(OFFSET(Other,5,6):OFFSET(GrandTotal,-3,6))","v":0}]
[]
["Grand Total(s):",null,null,null,{"$f":"ROUND(SUM(E18+E28+E38+E48+E58+E68+E78+E88+E98),2)","v":0},{"$f":"ROUND(SUM(F18+F28+F38+F48+F58+F68+F78+F88+F98),2)","v":0},{"$f":"ROUND(SUM(G18+G28+G38+G48+G58+G68+G78+G88+G98),2)","v":0}]