{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Examples"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":3,"defined_names":132,"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. CHECK OFF UNBLOCK, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Budget Summary","index":1,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,40,3],[38,1,38,3],[39,1,39,3],[1,0,2,3],[18,0,18,3],[35,1,35,3],[21,0,21,1],[24,0,24,1],[26,0,26,1],[28,0,28,1],[30,0,30,1],[32,0,32,1]]}
[]
["Attachment A - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SFY2024 Municipal Public Safety Staffing                                                                 Police and Fire"]
[]
[]
["Cost Categories",null,null,"Total"]
[]
[]
["Personnel Costs",null,null,{"$f":"'Budget Detail'!E13","v":0}]
[]
["Fringe Costs",null,null,{"$f":"'Budget Detail'!E21","v":0}]
[]
["Overtime Costs",null,null,{"$f":"'Budget Detail'!E29","v":0}]
[]
["Other Costs",null,null,{"$f":"'Budget Detail'!E37","v":0}]
[]
["Total Costs",null,null,{"$f":"'Budget Detail'!E39","v":0}]
[]
[]
["Name of Applicant Organization "]
[]
[]
["Completed by Signature:"]
["Print Name & Title:"]
["Date:"]

{"sheet":"Budget Detail","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[23,0,23,4],[24,0,24,4],[28,0,28,3],[16,0,16,4],[20,0,20,3],[39,0,39,4],[31,0,31,4],[36,0,36,3],[38,0,38,3],[32,0,32,4],[15,0,15,4],[12,0,12,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[7,0,7,4],[8,0,8,4],[5,0,5,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Justice and Prevention Division"]
[{"$f":"CONCATENATE(\"Budget Worksheets - \",'Budget Summary'!B36)","v":"Budget Worksheets - "}]
[]
["Please make sure that macros are enabled upon being prompted when the document is first opened. Please review the Opening Document tab for further instructions on how to enable macros if any questions arise. In addition, please review the AGF for further insight on allowable and unallowable costs."]
[]
["PERSONNEL - List each position by title and name of employee, if available. Show the annual salary rate and the percentage of time to be paid by this State grant. Be sure to describe the role and function to be provided by the employee."]
[]
["Name/Position","Annual Salary","Percentage Charged to Program","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE & PAYROLL TAX - Based on federally negotiated rate agreement or established formula by sub-recipient's accountant, comptroller or human resource unit. Costs are limited to the employer's share of life insurance, health insurance, social security, pension, unemployment, workers compensation costs, FMLA, and payroll taxes. A copy of the approved or audited rate must be included with the application. If applicant does not have a federally approved or audited rate, actual known costs must be itemized by type and include rate computations in this section of the budget forms. "]
[]
["Name/Position","Salary Charged to Grant","Contract Fringe Rate","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,3,4):OFFSET(Overtime,-4,4))","v":0}]
[]
[]
["OVERTIME -  List the rank/position for each overtime request. Indicate overtime rate for employees and the number of overtime hours for the period of the State grant. Be sure to describe the purpose of the overtime. "]
[]
["Name/Position","Overtime Rate","Number of Hours","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Overtime,3,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER - Costs listed in this category may include direct costs relevant to the proposed project and/or organization that cannot be listed within the aforementioned cost categories. Costs in this category may include: 1. Direct costs associated with new hires such as phone, uniforms, etc.; 2. Support costs such as recruitment expenses for new hires, training, etc. ; 3. Supplies for new hires (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.)."]
[]
["Item","Cost","Quantity","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37),2)","v":0}]

{"sheet":"Examples","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,4],[6,0,6,4],[12,0,12,4],[18,0,18,4]]}
["PERSONNEL - List each position by title and name of employee, if available. Show the annual salary rate and the percentage of time to be paid by this State grant. Be sure to describe the role and function to be provided by the employee."]
["Name/Position","Annual Salary","Percentage Charged to Program","Description","Total Expenditures"]
["Example: Sgt. Mary Smith",50000,1,"Sergeant in the Gang Unit",{"$f":"B3*C3","v":50000}]
["Example: Off. Mark Jones",40000,0.9,"Patrolman in the Traffic Unit",{"$f":"B4*C4","v":36000}]
[]
[]
["FRINGE & PAYROLL TAX - Based on federally negotiated rate agreement or established formula by sub-recipient's accountant, comptroller or human resource unit. Costs are limited to the employer's share of life insurance, health insurance, social security, pension, unemployment, workers compensation costs, FMLA, and payroll taxes. A copy of the approved or audited rate must be included with the application. If applicant does not have a federally approved or audited rate, actual known costs must be itemized by type and include rate computations in this section of the budget forms. "]
["Name/Position","Salary Charged to Grant","Contract Fringe Rate","Description","Total Expenditures"]
["Example: Sgt. Mary Smith",50000,0.18,"Federally approved rate of 18%",{"$f":"B9*C9","v":9000}]
["Example: Off. Mark Jones",36000,0.18,"Federally approved rate of 18%",{"$f":"B10*C10","v":6480}]
[]
[]
["OVERTIME -  List the rank/position for each overtime request. Indicate overtime rate for employees and the number of overtime hours for the period of the State grant. Be sure to describe the purpose of the overtime. "]
["Name/Position","Overtime Rate","Number of Hours","Description","Total Expenditures"]
["Example: Sgt. Joe Doe",40,25,"The OT will be usd to command extra shifts",{"$f":"B15*C15","v":1000}]
["Example: Officer Jane Doe",35,100,"The OT will be used for shift coverage",{"$f":"B16*C16","v":3500}]
[]
[]
["OTHER - Costs listed in this category may include direct costs relevant to the proposed project and/or organization that cannot be listed within the aforementioned cost categories. Costs in this category may include: 1. Direct costs associated with new hires such as phone, uniforms, etc.; 2. Support costs such as recruitment expenses for new hires, training, etc. ; 3. Supplies for new hires (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.)."]
["Item","Cost","Quantity","Description","Total Expenditures"]
["Example: Firefighter uniforms",150,10,"Uniforms for 10 firefighters",{"$f":"B21*C21","v":1500}]
["Example: Mandatory training",2500,2,"Training for 2 officers",{"$f":"B22*C22","v":5000}]