{"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":26,"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":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,3],[36,1,36,3],[37,1,37,3],[1,0,2,3],[18,0,18,3],[33,1,33,3],[21,0,21,1],[24,0,24,1],[26,0,26,1],[28,0,28,1],[30,0,30,1]]}
[]
["Attachment B - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State Fiscal Year 2024 Commonwealth Nonprofit Security Grant Program"]
[]
[]
["Cost Categories",null,null,"State Share"]
[]
[]
["Consultants & Contracts",null,null,{"$f":"'Budget Detail'!E13","v":0}]
[]
["Equipment & Technology",null,null,{"$f":"'Budget Detail'!E21","v":0}]
[]
["Other",null,null,{"$f":"'Budget Detail'!E29","v":0}]
[]
["Total Costs",null,null,{"$f":"SUM(D25+D27+D29)","v":0}]
[]
[]
["Name of Applicant Organization "]
[]
[]
["Completed by Signature:"]
["Print Name & Title:"]
["Date:"]

{"sheet":"Budget Detail","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,0,8,4],[7,0,7,4],[12,0,12,3],[16,0,16,4],[31,0,31,4],[15,0,15,4],[23,0,23,4],[20,0,20,3],[28,0,28,3],[30,0,30,3],[24,0,24,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Homeland Security Division"]
[{"$f":"CONCATENATE(\"Budget Worksheets - \",'Budget Summary'!B34)","v":"Budget Worksheets - "}]
[]
["You may add or delete rows in each section as necessary. To do so, please make sure that macros are enabled upon being prompted when the document is first opened. "]
[]
["CONSULTANTS & CONTRACTS - Consultant or Contractor fees associated with the equipment/technology purchased. For example, a consultant might be hired by the department to install the technology or train the staff on how to use it. The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour. Any request for compensation over $650 per day requires prior written approval by OGR. This rate is the exception, not the rule. "]
[]
["Consultants/Contractors Name","Pay Rate","Quantity of Hours/Days","Description ","Total Expenditures"]
[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(Consultants,3,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."]
[]
["Item","Cost Per Unit","Quantity","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,4)*ROUND(C20,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER - Supplies directly correlated to the equipment purchased. For example, ink or paper for a printer, batteries for communication devices, etc."]
[]
["Item","Cost","Quantity","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,4)*ROUND(C27,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),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),2)","v":0}]