{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Budget_Summary","Budget Detail","Item Descriptions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":26,"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":"Instructions","index":0,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[[13,0,29,10],[0,0,0,10],[1,8,8,10]]}
["Note: This document requires macros be enabled to work properly. Please ensure that macros are enabled before entering any data. You may be able to enable macros by choosing the \"Enable this content\" option from the Security Warning Ribbon above. \n\n\n\n\n\nIf the ribbon is not visible you may have been prompted to enable macros when you opened the document as pictured here.  "]
[null,null,null,null,null,null,null,null,"If you elected to disable macros, please close the document and reopen it with the macros enabled."]

{"sheet":"Budget_Summary","index":1,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,0,38,1],[40,0,40,1],[44,0,44,1],[42,0,42,1],[28,0,28,1],[30,0,30,1],[32,0,32,1],[34,0,34,1],[36,0,36,1],[1,0,2,3],[18,0,18,3],[20,1,20,3],[23,0,23,1],[26,0,26,1],[21,1,21,3]]}
[]
["Attachment B - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2022 Municipal Road Safety Grant (MRS)"]
[]
["Name of Applicant Organization "]
[null,"Dept. Name - Required Field"]
[]
["Cost Categories",null,null,"Federal Costs"]
[]
[]
["Traffic Safety Enforcement (TE) Overtime",null,null,{"$f":"'Budget Detail'!E14","v":0}]
[]
["Traffic Safety Equipment",null,null,{"$f":"'Budget Detail'!E22","v":0}]
[]
["Ped & Bike Enforcement Overtime",null,null,{"$f":"'Budget Detail'!E28","v":0}]
[]
["Ped & Bike Safety Items",null,null,{"$f":"'Budget Detail'!E36","v":0}]
[]
["Non-Enforcement Safety Activities & Items",null,null,{"$f":"'Budget Detail'!E44","v":0}]
[]
["Consultant / Contractor Costs",null,null,{"$f":"'Budget Detail'!E52","v":0}]
[]
["Travel Costs",null,null,{"$f":"'Budget Detail'!E60","v":0}]
[]
["Fringe Benefit Costs",null,null,{"$f":"'Budget Detail'!E68","v":0}]
[]
["Indirect Costs",null,null,{"$f":"'Budget Detail'!E76","v":0}]
[]
["Total Costs",null,null,{"$f":"D27+D29+D31+D33+D35+D37+D39+D41+D43","v":0}]

{"sheet":"Budget Detail","index":2,"n_rows":79,"n_cols":5,"rows_kept":79,"cut":false,"hidden":false,"merged":[[47,0,47,4],[55,0,55,4],[17,0,17,4],[39,0,39,4],[38,0,38,4],[21,0,21,3],[27,0,27,3],[46,0,46,4],[43,0,43,3],[78,0,78,4],[51,0,51,3],[77,0,77,3],[59,0,59,3],[54,0,54,4],[62,0,62,4],[63,0,63,4],[67,0,67,3],[70,0,70,4],[71,0,71,4],[75,0,75,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[4,0,4,4],[6,0,6,4],[30,0,30,4],[31,0,31,4],[35,0,35,3],[16,0,16,4],[24,0,24,4],[13,0,13,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
["Attachment B - Budget Worksheet"]
[{"$f":"IF(Budget_Summary!B21=\"\",\"\",Budget_Summary!B21)","v":""}]
[]
["Traffic Safety Enforcement (TE) Overtime"]
["Campaign Period ","Average OT Rate","Planned OT Hours","Description","Federal Costs"]
["Winter Impaired Driving: December 2021",null,null,null,{"$f":"IF(B9=\"\",\"\",ROUND(ROUND(B9,4)*ROUND(C9,2),2))","v":""}]
["Distracted Driving: April 2022",null,null,null,{"$f":"IF(B10=\"\",\"\",ROUND(ROUND(B10,4)*ROUND(C10,2),2))","v":""}]
["Click It or Ticket: May 2022",null,null,null,""]
["Summer Speed: June 2022",null,null,null,""]
["Summer Impaired Driving: Aug. - Sept. 2022",null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment - Cannot exceed 50% of TE Overtime Budget."]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description of Equipment & Add On's","Federal Costs"]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
["Activity","Average OT Rate","Planned OT Hours","Description ","Federal Costs"]
["Ped & Bike Safety Enforcement",null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items - Cannot exceed $1,200.00."]
[]
["Item","Cost Per Unit","Quantity","Description of Item","Federal Costs"]
[null,null,null,null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(PBSI,3,4):OFFSET(NESA,-4,4))","v":0}]
[]
[]
["Non-Enforcement Safety Activities & Items"]
[]
["Activity/Item","Rate","Quantity","Description ","Federal Costs"]
[null,null,null,null,{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Contractor,-4,4))","v":0}]
[]
[]
["Consultant / Contractor Costs"]
[]
["Consultant/Contractor Name","Rate","Quantity","Description","Federal Costs"]
[null,null,null,null,{"$f":"IF(B50=\"\",\"\",ROUND(ROUND(B50,4)*ROUND(C50,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractor,3,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["Travel Costs"]
[]
["Name/Position","Cost Per Trip","# of Trips","Description","Federal Costs"]
[null,null,null,null,{"$f":"IF(B58=\"\",\"\",ROUND(ROUND(B58,4)*ROUND(C58,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Federal Costs"]
[null,null,null,null,{"$f":"IF(B66=\"\",\"\",ROUND(ROUND(B66,4)*ROUND(C66,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["Indirect Costs"]
[]
["Name/Position","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Federal Costs"]
[null,null,null,null,{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E14+E22+E28+E36+E44+E52+E60+E68+E76),2)","v":0}]
["Subtotals reported on this form will auto-populate on the Budget Summary. Please take a moment to review that all numbers are correct on both sheets. "]

{"sheet":"Item Descriptions","index":3,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Traffic Enforcement (TE) Overtime: Show the average Overtime (OT) rate of officers conducting enforcement (rounded up to the nearest whole dollar) and number of overtime hours your department plans to dedicate to each mobilization. These amounts, if fully funded, will be your department's specific budget for each campaign period."]
[]
["Traffic Enforcement Equipment: Only list allowable items noted in the AGF. The cost category shows the combined Cost Per Unit and Quantity. "]
[]
["Ped&Bike Enforcement Overtime: Show the average Overtime (OT) rate of officers conducting enforcement (rounded up to the nearest whole dollar) and the total number of overtime hours your department plans to dedicate to Ped&Bike enforcement."]
[]
["Ped&Bike Safety Items: Only list allowable items noted in the AGF. The cost category shows the combined Cost Per Unit and Quantity."]
[]
["Non-Enforcement Safety Activities + Items: Show a brief description and  hourly rate for activities and list any general costs associated with the activity (i.e. printing costs, conference fees, presentation items)."]
[]
["Consultant/Contractor Fees: List the fee of the consultant or contractor and a brief description of their activity."]
[]
["Travel: In-state travel costs include mileage rates not in excess of $0.45 per mile, as well as actual costs of tolls and parking."]
[]
["Fringe Benefits: Fringe benefits should be based on actual known costs or an established formula.  Fringe benefits are for the personnel participating in budget category A and only for the percentage of time devoted to the project.  Fringe benefits on overtime hours are limited to FICA, Workman's Compensation, and Unemployment Compensation."]
[]
["Indirect Costs: Applicants must use a federally-approved indirect cost rate agreement or may elect to charge a de minimis rate of 10% of modified total direct costs.  If the applicant's accounting system permits, indirect costs may instead be allocated to applicable direct cost categories in the budget, including \"other\" if the costs being identified do not fit into one of the direct cost categories.  See Title 2CFR Part 200 (Super Circular)"]