{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Opening Document","Budget Summary","Budget Detail","Monthly Expenditure Timeline","Item Descriptions"],"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":"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],[34,0,34,1],[32,0,32,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]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2024 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}]
[]
["Ped & Bike Enforcement Overtime",null,null,{"$f":"'Budget Detail'!E29","v":0}]
[]
["Non-Enforcement Safety Activities",null,null,{"$f":"'Budget Detail'!E37","v":0}]
[]
["Ped & Bike Safety Items",null,null,{"$f":"'Budget Detail'!E45","v":0}]
[]
["Consultant / Contractor Costs",null,null,{"$f":"'Budget Detail'!E53","v":0}]
[]
["Travel Costs",null,null,{"$f":"'Budget Detail'!E61","v":0}]
[]
["Fringe Benefit Costs",null,null,{"$f":"'Budget Detail'!E69","v":0}]
[]
["Indirect Costs",null,null,{"$f":"'Budget Detail'!E77","v":0}]
[]
["Total Costs",null,null,{"$f":"'Budget Detail'!E79","v":0}]

{"sheet":"Budget Detail","index":2,"n_rows":79,"n_cols":5,"rows_kept":79,"cut":false,"hidden":false,"merged":[[5,0,5,4],[39,0,39,4],[40,0,40,4],[44,0,44,3],[16,0,16,4],[24,0,24,4],[13,0,13,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[79,0,79,4],[52,0,52,3],[78,0,78,3],[60,0,60,3],[55,0,55,4],[63,0,63,4],[64,0,64,4],[68,0,68,3],[71,0,71,4],[72,0,72,4],[76,0,76,3],[48,0,48,4],[56,0,56,4],[17,0,17,4],[32,0,32,4],[31,0,31,4],[21,0,21,3],[28,0,28,3],[47,0,47,4],[36,0,36,3],[25,0,25,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2024 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 2023",null,null,null,{"$f":"IF(B8=\"\",\"\",ROUND(ROUND(B8,4)*ROUND(C8,4),2))","v":""}]
["Distracted Driving: April 2024",null,null,null,{"$f":"IF(B9=\"\",\"\",ROUND(ROUND(B9,4)*ROUND(C9,4),2))","v":""}]
["Click It or Ticket: May 2024",null,null,null,""]
["Summer Speed: June 2024",null,null,null,""]
["Summer Speed: July 2024",null,null,null,""]
["Summer Impaired: Aug. 1, 2024 - Sept. 15, 2024",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,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}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Activity","Average OT Rate","Planned OT Hours","Description ","Federal Costs"]
["Ped & Bike Safety Enforcement",null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(NESA,-4,4))","v":0}]
[]
[]
["Non-Enforcement Safety Activities"]
[]
["Activity","Rate","Quantity","Description ","Federal Costs"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description of Item","Federal Costs"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(PBSI,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(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),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(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),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(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,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(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,4)*ROUND(C76,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+E29+E37+E45+E53+E61+E69+E77),2)","v":0}]

{"sheet":"Monthly Expenditure Timeline","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Calendar Year","Month","Traffic Enforcement","Ped/Bike Enforcement","TE Equipment","Non-Enforcement Activity","Ped/Bike \nSafety Items","Report Due Date"]
[2023,"November","No","Yes","Yes","Yes","Yes","2022-12-15"]
[2023,"December","Winter Impaired","No","Yes","Yes","Yes","2023-01-15"]
[2024,"January","No","Yes","Yes","Yes","Yes","2023-02-15"]
[2024,"February","No","Yes","Yes","Yes","Yes","2023-03-15"]
[2024,"March","No","Yes","Yes","Yes","Yes","2023-04-15"]
[2024,"April","Distracted Driving","No","Yes","Yes","Yes","2023-05-15"]
[2024,"May","CIOT","Yes","No","Yes","No","2023-06-15"]
[2024,"June","Speed","No","No","Yes","No","2023-07-15"]
[2024,"July","Speed","No","No","Yes","No","2023-08-15"]
[2024,"Aug. 1 - Sept. 15","Summer Impaired","Yes","No","Yes","No","2023-10-01"]

{"sheet":"Item Descriptions","index":4,"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 across the 6 campaign periods."]
[]
["Non-Enforcement Safety 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)."]
[]
["Ped&Bike Safety Items: Only list allowable items noted in the AGF. The cost category shows the combined Cost Per Unit and Quantity."]
[]
["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.62 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)"]