{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Budget Summary","YTD Breakdown","October 2021","November 2021","December 2021","January 2022","February 2022","March 2022","April 2022","May 2022","June 2022","July 2022","August, September 2022","Reporting Periods"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":112,"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":"Budget Summary","index":0,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[24,0,24,1],[27,0,27,1],[37,0,37,1],[39,0,39,1],[29,0,29,1],[31,0,31,1],[33,0,33,1],[35,0,35,1],[52,0,55,3],[46,1,46,2],[49,1,49,2],[47,1,47,2],[41,0,41,1],[48,1,48,2]]}
[]
["Monthly Financial Report - Summary Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2022 Municipal Road Safety Grant (MRS)"]
[]
["Department Name",{"$f":"IF('YTD Breakdown'!B1=\"\",\"\",'YTD Breakdown'!B1)","v":"Southborough Police Dept."}]
["Reporting Period"]
[]
[]
["Cost Categories",null,null,"Cash Expenditures"]
[]
[]
["Traffic Enforcement (TE) Overtime",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A28,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Traffic Safety Equipment",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A30,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Ped & Bike Enforcement Overtime",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A32,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Ped & Bike Safety Items",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A34,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Non-Enforcement Safety Activities & Items",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A36,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Fringe Benefits",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A38,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Indirect Costs",null,null,{"$f":"IF($B$22=\"\",\"\",VLOOKUP(A40,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE))","v":""}]
[]
["Total Costs",null,null,{"$f":"IFERROR(SUM(D28+D30+D32+D34+D36+D38+D40),\"\")","v":""}]
[]
[{"$f":"IF($B$22=\"\",\"\",IF(VLOOKUP(K44,'YTD Breakdown'!$A$8:$M$22,MATCH($B$22,'YTD Breakdown'!$A$8:$M$8,0),FALSE)=\"Yes\",\"There was $0 expended in this reporting period.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"Zero Payment"]
[]
[]
["Completed by Signature:"]
["Date:"]
["Print Name:"]
["Email Address:"]
[]
[]
["I certify that this report, schedules, statements, and the expenses for which payment is requested are true, correct, and complete and were made in accordance with the appropriate Federal and State regulations and that the articles or services listed were (or will be) necessary for and are to be used solely for the purpose specified in the award for this project."]

{"sheet":"YTD Breakdown","index":1,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,5,0,7],[1,5,1,7],[2,5,2,7],[43,1,43,3],[0,1,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3]]}
["Agency Name:","Southborough Police Dept."]
["Project Title:","Municipal Road Safety Program (MRS)"]
["Project #:","PT-22-06"]
["Project ID:",121]
["Contract End Date:","2022-09-15"]
[]
["Monthly Cash Expenditures"]
["Cost \nCategories","Approved Budget","October 2021","November 2021","December 2021","January 2022","February 2022","March 2022","April 2022","May 2022","June 2022","July 2022","August, September 2022","YTD Cash Expenditures","Balance"]
["Zero Payment",null,{"$f":"IF('October 2021'!$B$6=\"\",\"\",IF(AND('October 2021'!$B$6=\"Yes\",C22<>0),\"\",'October 2021'!$B$6))","v":""},{"$f":"IF('November 2021'!$B$6=\"\",\"\",IF(AND('November 2021'!$B$6=\"Yes\",D22<>0),\"\",'November 2021'!$B$6))","v":""},{"$f":"IF('December 2021'!$B$6=\"\",\"\",IF(AND('December 2021'!$B$6=\"Yes\",E22<>0),\"\",'December 2021'!$B$6))","v":""},{"$f":"IF('January 2022'!$B$6=\"\",\"\",IF(AND('January 2022'!$B$6=\"Yes\",F22<>0),\"\",'January 2022'!$B$6))","v":""},{"$f":"IF('February 2022'!$B$6=\"\",\"\",IF(AND('February 2022'!$B$6=\"Yes\",G22<>0),\"\",'February 2022'!$B$6))","v":""},{"$f":"IF('March 2022'!$B$6=\"\",\"\",IF(AND('March 2022'!$B$6=\"Yes\",H22<>0),\"\",'March 2022'!$B$6))","v":""},{"$f":"IF('April 2022'!$B$6=\"\",\"\",IF(AND('April 2022'!$B$6=\"Yes\",I22<>0),\"\",'April 2022'!$B$6))","v":""},{"$f":"IF('May 2022'!$B$6=\"\",\"\",IF(AND('May 2022'!$B$6=\"Yes\",J22<>0),\"\",'May 2022'!$B$6))","v":""},{"$f":"IF('June 2022'!$B$6=\"\",\"\",IF(AND('June 2022'!$B$6=\"Yes\",K22<>0),\"\",'June 2022'!$B$6))","v":""},{"$f":"IF('July 2022'!$B$6=\"\",\"\",IF(AND('July 2022'!$B$6=\"Yes\",L22<>0),\"\",'July 2022'!$B$6))","v":""},{"$f":"IF('August, September 2022'!$B$6=\"\",\"\",IF(AND('August, September 2022'!$B$6=\"Yes\",M22<>0),\"\",'August, September 2022'!$B$6))","v":""}]
["Traffic Enforcement (TE) Overtime",{"$f":"SUM(B11:B15)","v":13500},{"$f":"SUM(C11:C15)","v":0},{"$f":"SUM(D11:D15)","v":0},0,0,0,0,0,0,0,0,0]
["Winter Impaired Driving",2700,0,0,{"$f":"'December 2021'!$E$13","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(C11:M11)","v":0},{"$f":"B11-N11","v":2700}]
["Distracted Driving",2700,0,0,0,0,0,0,{"$f":"'April 2022'!$E$13","v":0},0,0,0,0,{"$f":"SUM(C12:M12)","v":0},{"$f":"B12-N12","v":2700}]
["Click It Or Ticket",2700,0,0,0,0,0,0,0,{"$f":"'May 2022'!$E$13","v":0},0,0,0,0,2700]
["Summer Speed",2700,0,0,0,0,0,0,0,0,{"$f":"'June 2022'!$E$13","v":0},0,0,0,2700]
["Summer Impaired",2700,0,0,0,0,0,0,0,0,0,0,{"$f":"'August, September 2022'!$E$13","v":0},0,2700]
["Traffic Safety Equipment",null,{"$f":"'October 2021'!$E$21","v":0},{"$f":"'November 2021'!$E$21","v":0},{"$f":"'December 2021'!$E$21","v":0},{"$f":"'January 2022'!$E$21","v":0},{"$f":"'February 2022'!$E$21","v":0},{"$f":"'March 2022'!$E$21","v":0},{"$f":"'April 2022'!$E$21","v":0},{"$f":"'May 2022'!$E$21","v":0},{"$f":"'June 2022'!$E$21","v":0},{"$f":"'July 2022'!$E$21","v":0},{"$f":"'August, September 2022'!$E$21","v":0},0,0]
["Ped & Bike Enforcement Overtime",null,{"$f":"'October 2021'!$E$29","v":0},{"$f":"'November 2021'!$E$29","v":0},0,0,{"$f":"'February 2022'!$E$29","v":0},{"$f":"'March 2022'!$E$29","v":0},0,0,0,{"$f":"'July 2022'!$E$29","v":0},{"$f":"'August, September 2022'!$E$29","v":0},0,0]
["Ped & Bike Safety Items",null,{"$f":"'October 2021'!$E$37","v":0},{"$f":"'November 2021'!$E$37","v":0},{"$f":"'December 2021'!$E$37","v":0},{"$f":"'January 2022'!$E$37","v":0},{"$f":"'February 2022'!$E$37","v":0},{"$f":"'March 2022'!$E$37","v":0},{"$f":"'April 2022'!$E$37","v":0},{"$f":"'May 2022'!$E$37","v":0},{"$f":"'June 2022'!$E$37","v":0},{"$f":"'July 2022'!$E$37","v":0},{"$f":"'August, September 2022'!$E$37","v":0},0,0]
["Non-Enforcement Safety Activities & Items",null,{"$f":"'October 2021'!$E$45","v":0},{"$f":"'November 2021'!$E$45","v":0},{"$f":"'December 2021'!$E$45","v":0},{"$f":"'January 2022'!$E$45","v":0},{"$f":"'February 2022'!$E$45","v":0},{"$f":"'March 2022'!$E$45","v":0},{"$f":"'April 2022'!$E$45","v":0},{"$f":"'May 2022'!$E$45","v":0},{"$f":"'June 2022'!$E$45","v":0},{"$f":"'July 2022'!$E$45","v":0},{"$f":"'August, September 2022'!$E$45","v":0},0,0]
["Fringe Benefits",null,{"$f":"'October 2021'!$E$53","v":0},{"$f":"'November 2021'!$E$53","v":0},{"$f":"'December 2021'!$E$53","v":0},{"$f":"'January 2022'!$E$53","v":0},{"$f":"'February 2022'!$E$53","v":0},{"$f":"'March 2022'!$E$53","v":0},{"$f":"'April 2022'!$E$53","v":0},{"$f":"'May 2022'!$E$53","v":0},{"$f":"'June 2022'!$E$53","v":0},{"$f":"'July 2022'!$E$53","v":0},{"$f":"'August, September 2022'!$E$53","v":0},0,0]
["Indirect Costs",null,{"$f":"'October 2021'!$E$61","v":0},{"$f":"'November 2021'!$E$61","v":0},{"$f":"'December 2021'!$E$61","v":0},{"$f":"'January 2022'!$E$61","v":0},{"$f":"'February 2022'!$E$61","v":0},{"$f":"'March 2022'!$E$61","v":0},{"$f":"'April 2022'!$E$61","v":0},{"$f":"'May 2022'!$E$61","v":0},{"$f":"'June 2022'!$E$61","v":0},{"$f":"'July 2022'!$E$61","v":0},{"$f":"'August, September 2022'!$E$61","v":0},0,0]
["TOTALS:",{"$f":"SUM(B11:B21)","v":13500},{"$f":"'October 2021'!$E$63","v":0},{"$f":"'November 2021'!$E$63","v":0},{"$f":"'December 2021'!$E$63","v":0},{"$f":"'January 2022'!$E$63","v":0},{"$f":"'February 2022'!$E$63","v":0},{"$f":"'March 2022'!$E$63","v":0},{"$f":"'April 2022'!$E$63","v":0},{"$f":"'May 2022'!$E$63","v":0},{"$f":"'June 2022'!$E$63","v":0},{"$f":"'July 2022'!$E$63","v":0},{"$f":"'August, September 2022'!$E$63","v":0},{"$f":"SUM(N11:N21)","v":0},{"$f":"SUM(O11:O21)","v":13500}]
[]
[]
["Cost \nCategories","April 2022","May 2022","June 2022","July 2022","August / September 2022","YTD Cash Expenditures","Balance"]
["Traffic Enforcement (TE) Overtime"]
["Winter Impaired Driving",{"$f":"I11","v":0},{"$f":"J11","v":0},{"$f":"K11","v":0},{"$f":"L11","v":0},{"$f":"M11","v":0},{"$f":"N11","v":0},{"$f":"O11","v":2700}]
["Distracted Driving",0,0,0,0,0,{"$f":"N12","v":0},{"$f":"O12","v":2700}]
["Click It Or Ticket",0,0,0,0,0,0,2700]
["Summer Speed",0,0,0,0,0,0,2700]
["Summer Impaired",0,0,0,0,0,0,2700]
["Traffic Safety Equipment",0,0,0,0,0,0,0]
["Ped & Bike Enforcement Overtime",0,0,0,0,0,0,0]
["Ped & Bike Safety Items",0,0,0,0,0,0,0]
["Non-Enforcement Safety Activities & Items",0,0,0,0,0,0,0]
["Fringe Benefits",0,0,0,0,0,0,0]
["Indirect Costs",0,0,0,0,0,0,0]
["TOTALS:",0,0,0,0,0,0,13500]

{"sheet":"October 2021","index":2,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[7,0,7,4],[31,0,31,4],[32,0,32,4],[36,0,36,3],[15,0,15,4],[23,0,23,4],[16,0,16,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[40,0,40,4],[39,0,39,4],[20,0,20,3],[44,0,44,3],[63,0,63,4],[62,0,62,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"October 2021 Report - \", 'YTD Breakdown'!B1)","v":"October 2021 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - No Campaign This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,2)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,2)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,2)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,2)*ROUND(C28,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(PBEO,2,2):OFFSET(PBSI,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"November 2021","index":3,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"November 2021 Report - \", 'YTD Breakdown'!B1)","v":"November 2021 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - No Campaign This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,2)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,2)*ROUND(C28,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(PBEO,2,2):OFFSET(PBSI,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"December 2021","index":4,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"December 2021 Report - \", 'YTD Breakdown'!B1)","v":"December 2021 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - Winter Impaired Driving Campaign"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,2)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,2)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(TSEO,2,2):OFFSET(TSE,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime - Not Allowed This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"January 2022","index":5,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"January 2022 Report - \", 'YTD Breakdown'!B1)","v":"January 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - No Campaign This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime - Not Allowed This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"February 2022","index":6,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"February 2022 Report - \", 'YTD Breakdown'!B1)","v":"February 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - No Campaign This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,2)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,2)*ROUND(C28,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(PBEO,2,2):OFFSET(PBSI,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"March 2022","index":7,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"March 2022 Report - \", 'YTD Breakdown'!B1)","v":"March 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - No Campaign This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,2)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,2)*ROUND(C28,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(PBEO,2,2):OFFSET(PBSI,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"April 2022","index":8,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"April 2022 Report - \", 'YTD Breakdown'!B1)","v":"April 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - Distracted Driving Campaign"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,2)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,2)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(TSEO,2,2):OFFSET(TSE,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime - Not Allowed This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"May 2022","index":9,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"May 2022 Report - \", 'YTD Breakdown'!B1)","v":"May 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - Click It or Ticket Campaign"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,2)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,2)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(TSEO,2,2):OFFSET(TSE,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime - Not Allowed This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"June 2022","index":10,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"June 2022 Report - \", 'YTD Breakdown'!B1)","v":"June 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - Summer Speed Campaign"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,2)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,2)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(TSEO,2,2):OFFSET(TSE,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime - Not Allowed This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"July 2022","index":11,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"July 2022 Report - \", 'YTD Breakdown'!B1)","v":"July 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - No Campaign This Period"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",null,"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,2)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,2)*ROUND(C28,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(PBEO,2,2):OFFSET(PBSI,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"August, September 2022","index":12,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[62,0,62,3],[32,0,32,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[6,0,6,4],[7,0,7,4],[15,0,15,4],[16,0,16,4],[20,0,20,3],[23,0,23,4],[31,0,31,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2022 Municipal Road Safety Grant Program (MRS)"]
[{"$f":"CONCATENATE(\"August, September 2022 Report - \", 'YTD Breakdown'!B1)","v":"August, September 2022 Report - Southborough Police Dept."}]
[]
["Will you be reporting $0 expenditures for this period?  Use dropdown arrow for Yes/No."]
[]
["Traffic Safety Enforcement (TE) Overtime - Summer Impaired Driving Campaign"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,2)*ROUND(C11,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,2)*ROUND(C12,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(TSEO,2,2):OFFSET(TSE,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(TSEO,2,4):OFFSET(TSE,-4,4))","v":0}]
[]
[]
["Traffic Safety Equipment"]
[]
["Equipment - Type","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(TSE,3,4):OFFSET(PBEO,-4,4))","v":0}]
[]
[]
["Ped & Bike Enforcement Overtime"]
[]
["Name/Position","OT Rate","OT Hours","Enter Only the Date of Shift","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,2)*ROUND(C27,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,2)*ROUND(C28,2),2))","v":""}]
[null,"Total Hours:",{"$f":"SUM(OFFSET(PBEO,2,2):OFFSET(PBSI,-4,2))","v":0},"Subtotal:",{"$f":"SUM(OFFSET(PBEO,2,4):OFFSET(PBSI,-4,4))","v":0}]
[]
[]
["Ped & Bike Safety Items"]
[]
["Item","Cost Per Unit","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,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 (Use dropdown arrow for label)","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,2),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NESA,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["Fringe Benefit Costs"]
[]
["Name/Position","Salary Applied to Fringe Rate","Contract Fringe Rate","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,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","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,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(E13+E21+E29+E37+E45+E53+E61),2)","v":0}]

{"sheet":"Reporting Periods","index":13,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Reporting Periods","Reporting Due Dates","Traffic Enforcement Campaigns","Ped & Bike Enforcement Months"]
["October 2021","2021-11-15",null,"October"]
["November 2021","2021-12-15",null,"November"]
["December 2021","2022-01-15","Winter Impaired Driving"]
["January 2022","2022-02-15"]
["February 2022","2022-03-15",null,"February"]
["March 2022","2022-04-15",null,"March"]
["April 2022","2022-05-15","Distracted Driving"]
["May 2022","2022-06-15","Click It or Ticket"]
["June 2022","2022-07-15","Summer Speed"]
["July 2022","2022-08-15",null,"July"]
["August, September 2022","2022-10-01","Summer Impaired Driving","August - September 15th"]