{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Opening Document","Budget Summary","Budget Detail","Allowable Cost Categories","Helper"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":8,"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":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[37,1,37,2],[1,0,2,2],[18,0,18,2],[32,1,32,2]]}
[]
["Attachment B - Budget Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cybersecurity Incident Response Planning and Tabletop Exercise Grant Opportunity"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Consultants/Contracts Costs",null,{"$f":"'Budget Detail'!$E$19","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!$E$29","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!$E$39","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!$E$41","v":0}]
[]
[]
["Name of State Agency"]
[]
[]
["Completed by Signature:"]
["Print Name & Title:"]
["Date:"]

{"sheet":"Budget Detail","index":2,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,0,41,4],[28,0,28,3],[40,0,40,3],[31,0,31,4],[32,0,32,4],[38,0,38,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[21,0,21,4],[22,0,22,4],[11,0,11,4],[12,0,12,4],[18,0,18,3],[7,0,7,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Cybersecurity Incident Response Planning and Tabletop Exercise Grant Opportunity"}]
[{"$f":"CONCATENATE(\"Budget Detail - \", 'Budget Summary'!$B$33)","v":"Budget Detail - "}]
[]
["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. Please take a moment to read the Availability of Grant Funds (AGF) document prior to completing this budget. Each subrecipient will be expected to follow the guidance that is posted in this AGF. The AGF will highlight important aspects of this funding opportunity such as an grant overview, eligibility and application requirements, key dates, maximum funding request amounts, allowable costs, and unallowable costs. 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 grant manager assigned in the Availability of Grant Funds (AGF) document."]
["NOTE: Only a Massachusetts Executive Branch State Agency can apply. The applicant will need to choose whether they will be applying to develop a cyber IRP (IRP) as required by EOTSS or in need of testing an existing cyber IRP via a TTX (TTX). Funds cannot be used for both objectives. The applicant may not request more than $40,000 in funds for the development of a cyber IRP or $30,000 for a TTX. Using the drop down value below (Column B), please choose if you will be applying for IRP or TTX. "]
[]
["Which objective are you applying for?"]
[]
[]
["CONTRACTS/VENDOR"]
[]
["Contracts/Vendor Name or Activity","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Cyber",200,24,"Please provide an explanation of the contract/vendor services that will be provided. ",{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),2))","v":4800}]
[]
["",null,null,null,{"$f":"IF(B17=\"\",\"\",ROUND(ROUND(B17,6)*ROUND(C17,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B18=\"\",\"\",ROUND(ROUND(B18,6)*ROUND(C18,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Item ABC",65,6,"Please provide an explanation of the item that will be purchased.",{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,6)*ROUND(C27,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,6)*ROUND(C28,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT"]
[]
["Applicable Expense","Expenses Applied to Indirect Rate","Indirect Rate","Description","Cash Expenditures"]
["Example: Contracted Service",1200,0.18,"Please confirm with your agency's negotiated indirect rate agreement that the expenditure as will be classified in MMARS is subject to indirect.",{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,8),2))","v":216}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B37=\"\",\"\",ROUND(ROUND(B37,6)*ROUND(C37,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B38=\"\",\"\",ROUND(ROUND(B38,6)*ROUND(C38,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E19+E29+E39),2)","v":0}]
[]
["Objective","Max Amount Ceiling","Amount Budgeted"]
[{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Helper!A:A,1,0))","v":""},{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,Helper!A:B,2,0))","v":""},{"$f":"E41","v":0}]

{"sheet":"Allowable Cost Categories","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,1],[11,0,11,1],[7,0,7,1],[5,0,5,1],[6,0,6,1],[8,0,8,1],[9,0,9,1]]}
["Allowable Budget Cost Categories ","Definitions and Documentation Requirements "]
["1. Consultants/Contracts Costs","Eligible vendors for awardees to select from to procure the services for an approved and allowable project under this AGF will be provided by the Commonwealth to awardees at the time of contracting."]
["2. Other Costs","Supplies needed to implement a TTX if not included in the vendor costs, dissemination costs associated with reproducing the cyber IRP plan developed, etc."]
["3. Indirect Costs","Federally negotiated and approved rate for costs that are not readily assignable to a particular project, but are necessary to the operation, maintenance of the organization and performance of the project. Include copy of federally approved rate with the proposal. Applicants must include copy of a federally approved rate with the proposal."]
[]
["Unallowable Costs  "]
["These grant funds may NOT be used for any of the following: "]
[]
[" – Agency personnel, rent and other related administrative costs; "]
["– Equipment and technology;"]
["– Retainer fees;"]
["– Food or catering services;"]

{"sheet":"Helper","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Objective","Max Amount Ceiling"]
["IRP",40000]
["TTX",30000]