{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Allowable Cost Categories"],"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":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,1,37,2],[38,1,38,2],[39,1,39,2],[1,0,2,2],[18,0,18,2],[34,1,34,2]]}
[]
["Attachment B - Budget Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State Share Cybersecurity Grant Program"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Consultants/Contracts Costs",null,{"$f":"'Budget Detail'!$E$16","v":0}]
[]
["Equipment/Technology Costs",null,{"$f":"'Budget Detail'!$E$26","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!$E$36","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!$E$46","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!$E$48","v":0}]
[]
[]
["Name of State Agency"]
[]
[]
["Completed by Signature:"]
["Print Name & Title:"]
["Date:"]

{"sheet":"Budget Detail","index":2,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,0,6,4],[28,0,28,4],[29,0,29,4],[18,0,18,4],[19,0,19,4],[25,0,25,3],[8,0,8,4],[9,0,9,4],[15,0,15,3],[7,0,7,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[48,0,48,4],[35,0,35,3],[47,0,47,3],[38,0,38,4],[39,0,39,4],[45,0,45,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"State Share Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Budget Detail - \", 'Budget Summary'!$B$35)","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 macros. The items marked as Example are only examples, and do not necessarily reflect items in your requested budget. 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 grant manager assigned in the Availability of Grant Funds (AGF) document."]
["NOTE: This AGF is only for state agencies. Only one (1) application per unit of state government will be permitted. The maximum amount of funding requested per application is $100,000.  "]
[]
["CONSULTANTS/CONTRACTS"]
[]
["Consultants/Contracts Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Cyber",200,24,"Please provide an explanation of the consultant/contracting services that will be provided. ",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Consultants,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT/TECHNOLOGY"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"Please provide an explanation of the equipment/technology that will be purchased.",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Batteries",65,6,"Please provide an explanation of the item that will be purchased.",{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),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: JJ Cyber",4800,0.18,"In addition to providing a negotiated indirect rate agreement with the application, please identify the object class that the expenditure will be coded as in MMARS.",{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,8),2))","v":864}]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,8),2))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E16+E26+E36+E46),2)","v":0}]

{"sheet":"Allowable Cost Categories","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,1],[8,0,8,1],[6,0,6,1],[7,0,7,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1]]}
["Allowable Budget Cost Categories ","Definitions and Documentation Requirements "]
["1. Consultants/Contracts Costs","Consultant or Contractor fees associated with the equipment/technology purchased. For example, a consultant might be hired to install the technology or provide delivery of a HSEEP compliant tabletop exercise."]
["2. Equipment/Technology Costs","Tangible non-expendable personal property having a useful life of more than one year; cost based on classification of equipment. Shipping and handling charges for equipment purchased should be placed in this cost category."]
["3. Other Costs","Supplies directly correlated to the equipment purchased. For example, ink or paper for a printer, batteries, etc. "]
["4. 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: "]
[]
[" – To pay a ransom; "]
["– For recreation or social purposes; "]
["– To pay cybersecurity insurance premiums; "]
["– To acquire land or to construct, remodel, or perform alterations of buildings or other facilities for any purpose that does not address cybersecurity risk or cybersecurity threats on information systems owned or operated by, or on behalf of, the eligible entity that receives the grant or a local government within the jurisdiction of the eligible entity;  "]
["– To pay for a retainer for cybersecurity services. "]