{"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Massachusetts Nonprofit Security Grant Program (ARPA)"]
[]
[]
["Cost Categories",null,null,"Requested Totals"]
[]
[]
["Consultants & Contracts",null,null,{"$f":"'Budget Detail'!E14","v":0}]
[]
["Equipment & Technology",null,null,{"$f":"'Budget Detail'!E22","v":0}]
[]
["Other",null,null,{"$f":"'Budget Detail'!E30","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":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,0,32,4],[16,0,16,4],[24,0,24,4],[21,0,21,3],[29,0,29,3],[31,0,31,3],[25,0,25,4],[6,0,6,4],[9,0,9,4],[8,0,8,4],[13,0,13,3],[17,0,17,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 - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. Please note that the subtotals will auto-populate based on the numbers reported within each category. Your requested budget per cost category shall be entered in the rows below the Examples using the \"Add\" command button to add another row if needed. If you have any questions, please contact the NSGP grant manager assigned in the Availability of Grant Funds (AGF) document."]
["Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs. Applicants may solicit up to $75,000 in funding under this competitive grant. Only (1) application per nonprofit can be submitted for consideration of funding. Submitting more than one application will disqualify an applicant from this competitive process. Budgeted costs should be for up to (12) months of funding. "]
[]
["CONSULTANTS & CONTRACTS - Consultant or Contractor fees associated with the equipment/technology purchased such as installation. OGR will also allow training costs associated with utilizing technology and equipment purchased if needed."]
[]
["Consultants/Contractors Name","Pay Rate","Quantity of Hours/Days","Description ","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,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(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(Equipment,3,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER - Supplies directly correlated to the equipment purchased. For example, batteries for communication devices."]
[]
["Item","Cost","Quantity","Description","Total Expenditures"]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,4)*ROUND(C28,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B29=\"\",\"\",ROUND(ROUND(B29,4)*ROUND(C29,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(E14+E22+E30),2)","v":0}]