{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Document","Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":20,"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":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[19,1,19,2]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY2025 Body-Worn Cameras Second Round"]
["Name of Applicant Organization "]
[]
[]
["Cost Categories",null,"Total"]
[]
[]
["Contract Costs",null,{"$f":"'Budget Detail'!E13","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E23","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E33","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E43","v":0}]
[]
["Total",null,{"$f":"C26+C28+C30+C32","v":0}]

{"sheet":"Budget Detail","index":2,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[26,0,26,4],[45,0,45,4],[25,0,25,4],[35,0,35,4],[32,0,32,3],[42,0,42,3],[44,0,44,3],[36,0,36,4],[6,0,6,4],[5,0,5,4],[12,0,12,3],[22,0,22,3],[15,0,15,4],[16,0,16,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Justice & Prevention Division"]
[{"$f":"CONCATENATE(\"Attachment B Budget Worksheet - \", 'Budget Summary'!B20)","v":"Attachment B Budget Worksheet - "}]
[]
["CONTRACTS: Contractor fees associated with the equipment/technology purchased (e.g., installation). Provide a description of the product/services to be procured by contract and an estimate of the cost.  Applicants should use a competitive process for procurements compliant with the organization's own procurement policy. If expenditures include installation, please list the cost of installation as a separate line item in the Contracts cost category. Click the \"Add Contracts\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Contracts/Company","Pay Rate","Quantity","Description ","Total Cash Expenditures"]
["Example: JJ Training",50,12,"Provided training on Body Worn Cameras. $50.00/hour for 12 hours. ",{"$f":"IF(B9=\"\",\"\",ROUND(B9,4)*ROUND(C9,2))","v":600}]
["Example: Installation",2000,1,"Installation of Body Worn Cameras; $2,000.00 for total installation. ",{"$f":"IF(B10=\"\",\"\",ROUND(B10,4)*ROUND(C10,2))","v":2000}]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT/TECHNOLOGY: Tangible non-expendable personal property having a useful life of more than one year; cost based on classification of equipment. Click the \"Add Equipment\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Equipment/Technology","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Laptop",1200,1,"Dell 1000 Laptop. Purchased (1) laptop at a rate of $1200.",{"$f":"IF(B19=\"\",\"\",ROUND(B19,4)*ROUND(C19,2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. Purchased (3) keyboards at $50/each",{"$f":"IF(B20=\"\",\"\",ROUND(B20,4)*ROUND(C20,2))","v":150}]
[null,null,null,null,{"$f":"IF(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES: Supplies directly correlated to the equipment purchased/program implementation (e.g., batteries, expendable items, etc.) Click the \"Add Supplies\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Supplies/Company","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes",{"$f":"IF(B29=\"\",\"\",ROUND(B29,4)*ROUND(C29,2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B30=\"\",\"\",ROUND(B30,4)*ROUND(C30,2))","v":75}]
[null,null,null,null,{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER: List items by major type which are not included in the aforementioned and the basis of computation. Click the \"Add Other\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Item/Company","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Telephone",65,3,"Verizon: January-March at $65 per month",{"$f":"IF(B39=\"\",\"\",ROUND(B39,4)*ROUND(C39,2))","v":195}]
["Example: Heat",3200,0.25,"Total bill for office for quarter was $3,200.00; this program is 1/4 of office space",{"$f":"IF(B40=\"\",\"\",ROUND(B40,4)*ROUND(C40,2))","v":800}]
[null,null,null,null,{"$f":"IF(B41=\"\",\"\",ROUND(ROUND(B41,4)*ROUND(C41,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E23+E33+E43),2)","v":0}]
["Subtotals reported on this form will auto-populate on the Budget Summary Sheet. Please take a moment to review that all numbers are correct on both sheets. "]