{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Document","Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":3,"defined_names":25,"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. MAKE SURE THERE IS A CHECK IN THE UNBLOCK BOX, 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],[42,1,42,3]]}
[]
["Budget Summary Worksheet - AGF Attachment A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2027 Traffic Safety Grant Program for                                                                                                                      State Government Agencies"]
[]
["Cost Categories","Federal Costs","Match Costs","Total Costs"]
[]
[]
["Personnel Costs",{"$f":"'Budget Detail'!E17","v":0},{"$f":"'Budget Detail'!F17","v":0},{"$f":"'Budget Detail'!G17","v":0}]
[]
["Fringe Benefit Costs",{"$f":"'Budget Detail'!E27","v":0},{"$f":"'Budget Detail'!F27","v":0},{"$f":"'Budget Detail'!G27","v":0}]
[]
["Indirect Costs",{"$f":"'Budget Detail'!E37","v":0},{"$f":"'Budget Detail'!F37","v":0},{"$f":"'Budget Detail'!G37","v":0}]
[]
["Consultants/Contractors Costs",{"$f":"'Budget Detail'!E47","v":0},{"$f":"'Budget Detail'!F47","v":0},{"$f":"'Budget Detail'!G47","v":0}]
[]
["Equipment & Software Costs",{"$f":"'Budget Detail'!E57","v":0},{"$f":"'Budget Detail'!F57","v":0},{"$f":"'Budget Detail'!G57","v":0}]
[]
["Travel Costs",{"$f":"'Budget Detail'!E67","v":0},{"$f":"'Budget Detail'!F67","v":0},{"$f":"'Budget Detail'!G67","v":0}]
[]
["Supplies Costs",{"$f":"'Budget Detail'!E77","v":0},{"$f":"'Budget Detail'!F77","v":0},{"$f":"'Budget Detail'!G77","v":0}]
[]
["Other Costs",{"$f":"'Budget Detail'!E87","v":0},{"$f":"'Budget Detail'!F87","v":0},{"$f":"'Budget Detail'!G87","v":0}]
[]
["Total Costs",{"$f":"'Budget Detail'!$E$89","v":0},{"$f":"'Budget Detail'!$F$89","v":0},{"$f":"'Budget Detail'!$G$89","v":0}]
[]
[]
["Enter Name of Applicant Organization "]
[]
[]
["Non-EOPSS Agencies Match Requirement",{"$f":"ROUND($D$40*0.2,2)","v":0}]

{"sheet":"Budget Detail","index":2,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[[89,0,89,6],[76,0,76,3],[86,0,86,3],[88,0,88,3],[56,0,56,3],[69,0,69,6],[70,0,70,6],[79,0,79,6],[80,0,80,6],[66,0,66,3],[60,0,60,6],[59,0,59,6],[19,0,19,6],[20,0,20,6],[29,0,29,6],[26,0,26,3],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[16,0,16,3],[8,0,8,4],[4,0,4,4],[9,0,9,6],[10,0,10,6],[7,0,7,6],[5,0,5,6],[6,0,6,6],[49,0,49,6],[50,0,50,6],[30,0,30,6],[39,0,39,6],[40,0,40,6],[46,0,46,3],[36,0,36,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2027 Traffic Safety Grant Program for State Government Agencies"]
[{"$f":"CONCATENATE(\"Budget Detail Worksheet - AGF Attachment A\",'Budget Summary'!B43)","v":"Budget Detail Worksheet - AGF Attachment A"}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. The items marked as Example are only examples, and do not necessarily reflect items in your requested budget. Please note that the subtotals will auto-populate based on the numbers reported within each category. Your requested budget per cost category shall be entered in the rows below the Examples using the \"Add\" command button to add another row if needed. If you have any questions, please contact the grant manager assigned in the Availability of Grant Funds (AGF) document."]
["Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs. Cost category definitions are highlighted in the Budget Guidelines tab. "]
["Applicants not under the Executive Office of Public Safety and Security must provide a minimum of 20% state or local funded cash (hard) match and/or in-kind (soft) match based on the proposed total project cost. For more information on match, please review 2 CFR Part 200.306. For example, if the total project (award + match amount) is $100,000, OGR may provide up to $80,000 via the grant award, while the subrecipient must provide at least a $20,000 via their match requirement. A related formula is (.25 x Awarded Federal Grant Funds Spent = State and/or Local Match Requirement). Match must be from state, or local (not federal) funding or resources provided by the subrecipient that directly benefit the project. Match must be an allowable expense per this AGF, incurred during the same period as the project, as well as auditable and documentable."]
[]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. At a minimum, reporting will need to detail employee names, hours worked per pay period, and the hourly rate. Please refer to the AGF regarding Overtime Costs. "]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Enter activities performed by Personnel here.",{"$f":"IF(G13=\"\",\"\",G13-F13)","v":7046.25},0,{"$f":"IF(B13=\"\",\"\",ROUND(B13,4)*ROUND(C13,2))","v":7046.25}]
[]
[null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15-F15)","v":""},null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,6)*ROUND(C15,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G16=\"\",\"\",G16-F16)","v":""},null,{"$f":"IF(B16=\"\",\"\",ROUND(ROUND(B16,6)*ROUND(C16,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Fringe,-4,4))","v":0},{"$f":"SUM(OFFSET(Personnel,5,5):OFFSET(Fringe,-4,5))","v":0},{"$f":"SUM(OFFSET(Personnel,5,6):OFFSET(Fringe,-4,6))","v":0}]
[]
[]
["FRINGE 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, 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). Must include a copy of the federally approved rate agreement in the application response."]
[]
["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(G23=\"\",\"\",G23-F23)","v":1479.7124999999999},null,{"$f":"IF(B23=\"\",\"\",ROUND(B23,4)*ROUND(C23,4))","v":1479.7124999999999}]
[]
[null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25-F25)","v":""},null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,6)*ROUND(C25,8),2))","v":""}]
[null,null,null,null,"",null,{"$f":"IF(B26=\"\",\"\",ROUND(ROUND(B26,6)*ROUND(C26,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0},{"$f":"SUM(OFFSET(Fringe,5,5):OFFSET(Indirect,-4,5))","v":0},{"$f":"SUM(OFFSET(Fringe,5,6):OFFSET(Indirect,-4,6))","v":0}]
[]
[]
["INDIRECT COSTS: Applicants that want to charge indirect costs using an indirect cost rate may use a federally approved indirect cost rate agreement or charge a de minimis rate of 15%. If the applicant’s accounting system permits, indirect costs may instead be allocated in the budget, including the category “Other” if the costs being identified do not fit into one of the direct cost categories. For more information, see Title 2 CFR Part 200, in particular 200.414. Must include a copy of the federally approved rate agreement in the application response."]
[]
["Employee Name","Expenses Applied to Indirect Rate","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(G33=\"\",\"\",G33-F33)","v":1534.6727999999998},0,{"$f":"IF(B33=\"\",\"\",ROUND(B33,4)*ROUND(C33,4))","v":1534.6727999999998}]
[]
[null,null,null,null,{"$f":"IF(G35=\"\",\"\",G35-F35)","v":""},null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,6)*ROUND(C35,8),2))","v":""}]
[null,null,null,null,"",null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,6)*ROUND(C36,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0},{"$f":"SUM(OFFSET(Indirect,5,5):OFFSET(Contractors,-4,5))","v":0},{"$f":"SUM(OFFSET(Indirect,5,6):OFFSET(Contractors,-4,6))","v":0}]
[]
[]
["CONTRACTORS/CONSULTANTS: The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and per diem costs). Any request for compensation over $650 per day or $81.25 per hour requires prior written approval by OGR. 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,"Enter activities performed by Contractors/Consultants here.",{"$f":"IF(G43=\"\",\"\",G43-F43)","v":2000},2800,{"$f":"IF(B43=\"\",\"\",ROUND(B43,4)*ROUND(C43,2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(G45=\"\",\"\",G45-F45)","v":""},null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,6)*ROUND(C45,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G46=\"\",\"\",G46-F46)","v":""},null,{"$f":"IF(B46=\"\",\"\",ROUND(ROUND(B46,6)*ROUND(C46,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0},{"$f":"SUM(OFFSET(Contractors,5,5):OFFSET(Equipment,-4,5))","v":0},{"$f":"SUM(OFFSET(Contractors,5,6):OFFSET(Equipment,-4,6))","v":0}]
[]
[]
["EQUIPMENT & SOFTWARE: Equipment is any tangible, non-expendable personal property having a useful life of more than one year; cost based on classification of equipment. Must be directly related to project need/implementation. Please refer to the AGF regarding the rules behind equipment and software as well as the need for NHTSA approval if acquisition costs are $10,000 or more. "]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Equipment ABC",12000,1,"Describe Equipment and purpose here.",{"$f":"IF(G53=\"\",\"\",G53-F53)","v":9500},2500,{"$f":"IF(B53=\"\",\"\",ROUND(B53,4)*ROUND(C53,2))","v":12000}]
[]
[null,null,null,null,{"$f":"IF(G55=\"\",\"\",G55-F55)","v":""},null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,6)*ROUND(C55,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G56=\"\",\"\",G56-F56)","v":""},null,{"$f":"IF(B56=\"\",\"\",ROUND(ROUND(B56,6)*ROUND(C56,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0},{"$f":"SUM(OFFSET(Equipment,5,5):OFFSET(Travel,-4,5))","v":0},{"$f":"SUM(OFFSET(Equipment,5,6):OFFSET(Travel,-4,6))","v":0}]
[]
[]
["TRAVEL: Costs that are directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates, not more than $0.62 per mile, as well as the actual costs of tolls and parking. No grant funds may be spent on out-of-state conference fees, out-of-state travel, or out-of-state lodging without prior written approval from OGR. (Please refer to Pages 27-29 of the OGR General Subrecipient Grant Conditions for additional guidance surrounding travel.)"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",0.62,200,"Describe Travel activities here. (Ex. Reimbursement of 200 miles driven from Boston to Springfield)",{"$f":"IF(G63=\"\",\"\",G63-F63)","v":124},0,{"$f":"IF(B63=\"\",\"\",ROUND(B63,4)*ROUND(C63,2))","v":124}]
[]
[null,null,null,null,{"$f":"IF(G65=\"\",\"\",G65-F65)","v":""},null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,6)*ROUND(C65,6),2))","v":""}]
[null,null,null,null,"",null,{"$f":"IF(B66=\"\",\"\",ROUND(ROUND(B66,6)*ROUND(C66,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0},{"$f":"SUM(OFFSET(Travel,5,5):OFFSET(Supplies,-4,5))","v":0},{"$f":"SUM(OFFSET(Travel,5,6):OFFSET(Supplies,-4,6))","v":0}]
[]
[]
["SUPPLIES: Supplies required for the 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,"Describe Supplies purchase here. ",{"$f":"IF(G73=\"\",\"\",G73-F73)","v":100},100,{"$f":"IF(B73=\"\",\"\",ROUND(B73,4)*ROUND(C73,2))","v":200}]
[]
[null,null,null,null,{"$f":"IF(G75=\"\",\"\",G75-F75)","v":""},null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,6)*ROUND(C75,6),2))","v":""}]
[null,null,null,null,"",null,{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,6)*ROUND(C76,6),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: Miscellaneous costs/items (e.g., telephone costs, CPS technician recertification fees) may be allowable with prior OGR approval."]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Telephone",65,6,"Describe Other expenses here. ",{"$f":"IF(G83=\"\",\"\",G83-F83)","v":390},0,{"$f":"IF(B83=\"\",\"\",ROUND(B83,4)*ROUND(C83,2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(G85=\"\",\"\",G85-F85)","v":""},null,{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,6)*ROUND(C85,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G86=\"\",\"\",G86-F86)","v":""},null,{"$f":"IF(B86=\"\",\"\",ROUND(ROUND(B86,6)*ROUND(C86,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0},{"$f":"SUM(OFFSET(Other,5,5):OFFSET(GrandTotal,-3,5))","v":0},{"$f":"SUM(OFFSET(Other,5,6):OFFSET(GrandTotal,-3,6))","v":0}]
[]
["Grand Total(s):",null,null,null,{"$f":"ROUND(SUM(E17+E27+E37+E47+E57+E67+E77+E87),2)","v":0},{"$f":"ROUND(SUM(F17+F27+F37+F47+F57+F67+F77+F87),2)","v":0},{"$f":"ROUND(SUM(G17+G27+G37+G47+G57+G67+G77+G87),2)","v":0}]