{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Opening Document","Questions","Allowable Cost Categories","Budget Summary","Primary Application","Local Unit 1","Local Unit 2","Local Unit 3","Local Unit 4","Local Unit 5","Local Unit 6","Local Unit 7","Local Unit 8","Local Unit 9","Local Unit 10","Local Unit Totals","Helper"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":79,"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":"Questions","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,0,7,1],[2,0,4,1]]}
["1. Please enter the name of the primary local unit of government applicant:"]
[]
["Funding Parameters: The Individual Option allows for one individual local unit of government \"LUG\" to apply for grant funding; Maximum award amount of up to $100,000. The Group Option allows for up to (10) local units of government to participate in a joint application. The (10) local units will also include the primary applicant which will serve as the programmatic and fiduciary point of contact on the joint application. Keep in mind, the threshold budget for (1) local unit of government is still $100,000 under the Group Option; Maximum award of the joint application cannot exceed $300,000."]
[]
[]
["2. Please choose the award option that you will be applying for:"]
[]
[{"$f":"IF(B6=\"\", \"\", IF(B6 = \"Individual Option\", Helper!B1, Helper!B2))","v":""}]
[]
[{"$f":"IF(B6=\"Group Option\", \"3. Including the primary applicant, how many local units of government will participate in the joint application:\", \"\")","v":""}]
[]
["Local Unit of Government #","Name of Local Unit"]
["Local Unit 1",{"$f":"IF($B$1=\"\",\"\",$B$1)","v":""}]
["Local Unit 2"]
["Local Unit 3"]
["Local Unit 4"]
["Local Unit 5"]
["Local Unit 6"]
["Local Unit 7"]
["Local Unit 8"]
["Local Unit 9"]
["Local Unit 10"]

{"sheet":"Allowable Cost Categories","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"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."]
["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. "]
[]
[]
["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;  "]
["– To pay for a retainer for cybersecurity services. "]

{"sheet":"Budget Summary","index":3,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,0,2,2],[18,0,18,2],[32,1,32,2]]}
[]
["Attachment B - Budget Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Municipal Local Cybersecurity Grant Program"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Consultants/Contracts Costs",null,{"$f":"IF(Questions!$B$6=\"Individual Option\",'Primary Application'!$E$16, SUM('Local Unit Totals'!B4:F4,'Local Unit Totals'!B11:F11))","v":0}]
[]
["Equipment/Technology Costs",null,{"$f":"IF(Questions!$B$6=\"Individual Option\",'Primary Application'!$E$26, SUM('Local Unit Totals'!B5:F5,'Local Unit Totals'!B12:F12))","v":0}]
[]
["Other Costs",null,{"$f":"IF(Questions!$B$6=\"Individual Option\",'Primary Application'!$E$36, SUM('Local Unit Totals'!B6:F6,'Local Unit Totals'!B13:F13))","v":0}]
[]
["Total Costs",null,{"$f":"IF(Questions!$B$6=\"Individual Option\",'Primary Application'!$E$38, 'Local Unit Totals'!$B$17)","v":0}]
[]
[]
["Name of Primary Applicant",{"$f":"IF(Questions!$B$1=\"\",\"\",Questions!$B$1)","v":""}]

{"sheet":"Primary Application","index":4,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"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],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[15,0,15,3],[7,0,7,4],[38,0,38,4],[35,0,35,3],[37,0,37,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Primary Application Budget Detail - \", Questions!$B$1)","v":"Primary Application 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: By entering information on this Primary Application tab, this indicates that you are proceeding with the Individual Option. Only (1) local unit of government should be considered for this application with budgeted costs that cannot exceed $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(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E16+E26+E36),2)","v":0}]

{"sheet":"Local Unit 1","index":5,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[17,0,17,4],[18,0,18,4],[24,0,24,3],[6,0,6,4],[7,0,7,4],[8,0,8,4],[14,0,14,3],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[27,0,27,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$13)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,4),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(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 2","index":6,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$14)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 3","index":7,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$15)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 4","index":8,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$16)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 5","index":9,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$17)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 6","index":10,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$18)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 7","index":11,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$19)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 8","index":12,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$20)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 9","index":13,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$21)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit 10","index":14,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[27,0,27,4],[28,0,28,4],[34,0,34,3],[36,0,36,3],[37,0,37,4],[24,0,24,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],[7,0,7,4],[8,0,8,4],[14,0,14,3],[17,0,17,4],[18,0,18,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
[{"$f":"'Budget Summary'!$A$19","v":"Municipal Local Cybersecurity Grant Program"}]
[{"$f":"CONCATENATE(\"Attachment B - \", Questions!$B$22)","v":"Attachment B - "}]
[]
["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."]
[]
["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(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":4800}]
[]
[null,null,null,null,{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":1200}]
[]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":""}]
[null,null,null,null,""]
["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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":390}]
[]
[null,null,null,null,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35),2)","v":0}]

{"sheet":"Local Unit Totals","index":15,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
["Subaward Budgets"]
["Cost \nCategories",{"$f":"CONCATENATE(\"Local Unit 1 - \", Questions!$B$13)","v":"Local Unit 1 - "},{"$f":"CONCATENATE(\"Local Unit 2 - \", Questions!$B$14)","v":"Local Unit 2 - "},{"$f":"CONCATENATE(\"Local Unit 3 - \", Questions!$B$15)","v":"Local Unit 3 - "},{"$f":"CONCATENATE(\"Local Unit 4 - \", Questions!$B$16)","v":"Local Unit 4 - "},{"$f":"CONCATENATE(\"Local Unit 5 - \", Questions!$B$17)","v":"Local Unit 5 - "}]
["Consultants/Contracts Costs",{"$f":"'Local Unit 1'!$E$15","v":0},{"$f":"'Local Unit 2'!$E$15","v":0},{"$f":"'Local Unit 3'!$E$15","v":0},{"$f":"'Local Unit 4'!$E$15","v":0},{"$f":"'Local Unit 5'!$E$15","v":0}]
["Equipment/Technology Costs",{"$f":"'Local Unit 1'!$E$25","v":0},{"$f":"'Local Unit 2'!$E$25","v":0},{"$f":"'Local Unit 3'!$E$25","v":0},{"$f":"'Local Unit 4'!$E$25","v":0},{"$f":"'Local Unit 5'!$E$25","v":0}]
["Other Costs",{"$f":"'Local Unit 1'!$E$35","v":0},{"$f":"'Local Unit 2'!$E$35","v":0},{"$f":"'Local Unit 3'!$E$35","v":0},{"$f":"'Local Unit 4'!$E$35","v":0},{"$f":"'Local Unit 5'!$E$35","v":0}]
["TOTALS:",{"$f":"'Local Unit 1'!$E$37","v":0},{"$f":"'Local Unit 2'!$E$37","v":0},{"$f":"'Local Unit 3'!$E$37","v":0},{"$f":"'Local Unit 4'!$E$37","v":0},{"$f":"'Local Unit 5'!$E$37","v":0}]
[]
[]
["Cost \nCategories",{"$f":"CONCATENATE(\"Local Unit 6 - \", Questions!$B$18)","v":"Local Unit 6 - "},{"$f":"CONCATENATE(\"Local Unit 7 - \", Questions!$B$19)","v":"Local Unit 7 - "},{"$f":"CONCATENATE(\"Local Unit 8 - \", Questions!$B$20)","v":"Local Unit 8 - "},{"$f":"CONCATENATE(\"Local Unit 9 - \", Questions!$B$21)","v":"Local Unit 9 - "},{"$f":"CONCATENATE(\"Local Unit 10 - \", Questions!$B$22)","v":"Local Unit 10 - "}]
["Consultants/Contracts Costs",{"$f":"'Local Unit 6'!$E$15","v":0},{"$f":"'Local Unit 7'!$E$15","v":0},{"$f":"'Local Unit 8'!$E$15","v":0},{"$f":"'Local Unit 9'!$E$15","v":0},{"$f":"'Local Unit 10'!$E$15","v":0}]
["Equipment/Technology Costs",{"$f":"'Local Unit 6'!$E$25","v":0},{"$f":"'Local Unit 7'!$E$25","v":0},{"$f":"'Local Unit 8'!$E$25","v":0},{"$f":"'Local Unit 9'!$E$25","v":0},{"$f":"'Local Unit 10'!$E$25","v":0}]
["Other Costs",{"$f":"'Local Unit 6'!$E$35","v":0},{"$f":"'Local Unit 7'!$E$35","v":0},{"$f":"'Local Unit 8'!$E$35","v":0},{"$f":"'Local Unit 9'!$E$35","v":0},{"$f":"'Local Unit 10'!$E$35","v":0}]
["TOTALS:",{"$f":"'Local Unit 6'!$E$37","v":0},{"$f":"'Local Unit 7'!$E$37","v":0},{"$f":"'Local Unit 8'!$E$37","v":0},{"$f":"'Local Unit 9'!$E$37","v":0},{"$f":"'Local Unit 10'!$E$37","v":0}]
[]
[]
["Grand Total:",{"$f":"SUM(B7:F7,B14:F14)","v":0}]

{"sheet":"Helper","index":16,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Individual Option Text","You are applying for the Individual Option, with a maximum award amount of up to $100,000. There will be no additional local units of government that will be applying for funding. Please take the time to read the AGF to better understand what expenses are and are not allowable as well as key dates and requirements for this cybersecurity grant. The Allowable Cost Categories tab, highlighted in green, will provide definitions of the allowable budget cost categories. The Budget Summary and Primary Application tabs, highlighted in blue, will need to be completed by the primary applicant."]
["Group Option Text","You are applying for the Group Option, with a maximum joint award amount of up to $300,000. This allows for multiple local units of government to apply under one application. Please take the time to read the AGF to better understand what expenses are and are not allowable as well as key dates and requirements for this cybersecurity grant. The Allowable Cost Categories tab, highlighted in green, will provide definitions of the allowable budget cost categories. Using the drop-down in Question 3, select the number of co-applicants that will be on this joint application. Enter the names of the LUGs in the fields that populate. The primary applicant should fill out their respective budget using the \"Local Unit 1\" tab. Depending on the number of LUGs chosen in Question 3, each LUG will need to have their own completed budget, highlighted in red. Please check that all LUG budgets are accurate in the \"Local Unit Totals\" tab, highlighted in red."]