{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Opening Document","Item Descriptions","Budget Summary","Budget Detail","Monthly Expenditure Timeline"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"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":"Item Descriptions","index":1,"n_rows":13,"n_cols":1,"rows_kept":13,"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."]
[]
["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 across the 6 campaign periods."]
[]
["Community Awareness, Outreach, and Educational Activities: Show a brief description and hourly rate for activities and list any general costs associated with the activity (i.e. printing costs, training registration fees).                                                                                                                                                                                                                                                                          *** Please note that Consultant/Contractor and Travel Costs can also be budgeted for within this cost category as per the AGF ***"]
[]
["Ped&Bike Safety Items: Only list allowable items noted in the AGF. The cost category shows the combined Cost Per Unit and Quantity."]
[]
["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)"]

{"sheet":"Budget Summary","index":2,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[20,1,20,3],[23,0,23,1],[26,0,26,1],[36,0,36,1],[40,0,40,1],[38,0,38,1],[28,0,28,1],[30,0,30,1],[34,0,34,1],[32,0,32,1]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2027 Municipal Road Safety Grant (MRS)"]
[]
["Name of Applicant Organization "]
[]
[]
["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}]
[]
["Pedestrian & Bicyclist Enforcement Overtime",null,null,{"$f":"'Budget Detail'!E33","v":0}]
[]
["Pedestrian & Bicyclist Safety Items",null,null,{"$f":"'Budget Detail'!E41","v":0}]
[]
["Community Awareness, Outreach, and Educational Activities",null,null,{"$f":"'Budget Detail'!E49","v":0}]
[]
["Fringe Benefit Costs",null,null,{"$f":"'Budget Detail'!E57","v":0}]
[]
["Indirect Costs",null,null,{"$f":"'Budget Detail'!E65","v":0}]
[]
["Total Costs",null,null,{"$f":"'Budget Detail'!E67","v":0}]

{"sheet":"Budget Detail","index":3,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[67,0,67,4],[66,0,66,3],[51,0,51,4],[52,0,52,4],[56,0,56,3],[59,0,59,4],[60,0,60,4],[64,0,64,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],[43,0,43,4],[44,0,44,4],[48,0,48,3],[16,0,16,4],[24,0,24,4],[13,0,13,3],[17,0,17,4],[36,0,36,4],[35,0,35,4],[21,0,21,3],[32,0,32,3],[40,0,40,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2027 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"Attachment B - \", 'Budget Summary'!B21)","v":"Attachment B - "}]
[]
["Traffic Safety Enforcement (TE) Overtime"]
["Campaign Period ","Average OT Rate","Planned OT Hours","Description","Federal Costs"]
["Winter Impaired Driving: December 2026",null,null,null,{"$f":"IF(B8=\"\",\"\",ROUND(ROUND(B8,4)*ROUND(C8,4),2))","v":""}]
["Distracted Driving: April 2027",null,null,null,{"$f":"IF(B9=\"\",\"\",ROUND(ROUND(B9,4)*ROUND(C9,4),2))","v":""}]
["Click It or Ticket: May 2027",null,null,null,""]
["Summer Speed: June 2027",null,null,null,""]
["Summer Speed: July 2027",null,null,null,""]
["Summer Impaired: Aug. 1, 2027 - Sept. 15, 2027",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. If the subtotal is displayed in red, please adjust the Traffic Safety Equipment or Traffic Safety Enforcement Overtime cost categories accordingly in order to satisfy the 50% requirement. "]
[]
["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,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Pedestrian & Bicyclist Enforcement Overtime"]
["Campaign Period ","Average OT Rate","Planned OT Hours","Description ","Federal Costs"]
["November 2026",null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,4),2))","v":""}]
["January 2027",null,null,null,""]
["February 2027",null,null,null,""]
["March 2027",null,null,null,""]
["May 2027",null,null,null,""]
["Aug. 1, 2027 - Sept. 15, 2027",null,null,null,{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(NESA,-4,4))","v":0}]
[]
[]
["Pedestrian & Bicyclist Safety Items"]
[]
["Activity","Rate","Quantity","Description ","Federal Costs"]
[null,null,null,null,{"$f":"IF(B39=\"\",\"\",ROUND(ROUND(B39,4)*ROUND(C39,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B40=\"\",\"\",ROUND(ROUND(B40,4)*ROUND(C40,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Community Awareness, Outreach, and Educational Activities"]
[]
["Item","Cost Per Unit","Quantity","Description of Item","Federal Costs"]
[null,null,null,null,{"$f":"IF(B47=\"\",\"\",ROUND(ROUND(B47,4)*ROUND(C47,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B48=\"\",\"\",ROUND(ROUND(B48,4)*ROUND(C48,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(PBSI,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(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B56=\"\",\"\",ROUND(ROUND(B56,4)*ROUND(C56,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(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,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+E33+E41+E49+E57+E65),2)","v":0}]

{"sheet":"Monthly Expenditure Timeline","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Calendar Year","Month","Traffic Enforcement","Ped/Bike Enforcement","TE Equipment","Community Awareness, Outreach, and Educational Activities","Ped/Bike \nSafety Items","Report Due Date"]
[2026,"November","N/A","Yes","Yes","Yes","Yes","2026-12-15"]
[2026,"December","Winter Impaired","N/A","Yes","Yes","Yes","2027-01-15"]
[2027,"January","N/A","Yes","Yes","Yes","Yes","2027-02-15"]
[2027,"February","N/A","Yes","Yes","Yes","Yes","2027-03-15"]
[2027,"March","N/A","Yes","Yes","Yes","Yes","2027-04-15"]
[2027,"April","Distracted Driving","N/A","N/A","Yes","N/A","2027-05-15"]
[2027,"May","CIOT","Yes","N/A","Yes","N/A","2027-06-15"]
[2027,"June","Speed","N/A","N/A","Yes","N/A","2027-07-15"]
[2027,"July","Speed","N/A","N/A","Yes","N/A","2027-08-15"]
[2027,"Aug. 1 - Sept. 15","Summer Impaired","Yes","N/A","Yes","N/A","2027-10-01"]