{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Opening Document","Questions","Budget Summary","Primary Applicant","Member 2","Member 3","Member 4","Member 5","Member 6","Member 7","Member 8","Member 9","Member 10","Member Totals","AEL Equipment List"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":97,"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":[[4,0,6,1],[0,0,0,1]]}
["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. All (3) questions must be answered using the blue cells in Column B so the applicant can complete the actual budget. The names for each member of the consortium must be entered in Question 3. "]
[]
["1. Enter the name of the lead applicant applying on behalf of the consortium for this grant:"]
[]
["Funding Parameters: For the NSGP-NSS, a group of nonprofit organizations may collaborate to submit a consortium application (also known as a joint application) in which one nonprofit acts as the lead applicant and applies for funding on behalf of itself and any number of other consortium member nonprofit organizations. Nonprofit organizations may not apply both individually and as part of a consortium. Each consortium member may apply for up to $200,000 for their site with a maximum funding request of $1,000,000 per consortium.  If awarded, the lead consortium member will accept the subaward on behalf of the consortium, as well as implement and manage the approved projects/contracts for all consortium member sites throughout the period of performance. This includes ensuring that all terms and conditions of the subaward are met for all consortium members. There are (2) funding streams that the consortium can apply for: Urban Areas (NSGP-NSS-UA) and State (NSGP-NSS-S). Urban Areas consist of applicants located in Boston, Brookline, Cambridge, Chelsea, Everett, Quincy, Revere, Somerville, and Winthrop. NSGP-NSS-S (\"State\") involves applicants located outside the Urban Areas locations. Please keep in mind that ALL members of the consortium need to be either within Urban Areas or within State. If some members of the consortium are located in Urban Areas, while other members are located in State, the application will be rejected. If this is the case, please submit a separate application for the consortium members pertaining to each funding stream. After choosing how many members are part of the consortium on Question 3, please complete a budget that is unique to each member by using the green \"Primary Applicant\" and \"Member #\" tabs that appear below. "]
[]
[]
["2. Choose the funding stream you will be applying for from the dropdown menu:"]
[]
["3. Including the primary applicant, how many members of the consortium will participate in this joint application:"]
[]
["Member #","Name of Organization"]
["Primary Applicant",{"$f":"IF($B$3=\"\",\"\",$B$3)","v":""}]
["Member 2"]
["Member 3"]
["Member 4"]
["Member 5"]
["Member 6"]
["Member 7"]
["Member 8"]
["Member 9"]
["Member 10"]

{"sheet":"Budget Summary","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,0,2,2],[18,0,18,2],[42,1,42,2]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium\", \" - \", Questions!B8)","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Planning Costs",null,{"$f":"SUM('Member Totals'!B4:K4)","v":0}]
[]
["Equipment Costs",null,{"$f":"SUM('Member Totals'!B5:K5)","v":0}]
[]
["Maintenance & Sustainment Costs",null,{"$f":"SUM('Member Totals'!B6:K6)","v":0}]
[]
["Training & Exercises Costs",null,{"$f":"SUM('Member Totals'!B7:K7)","v":0}]
[]
["M&A Costs",null,{"$f":"SUM('Member Totals'!B8:K8)","v":0}]
[]
["Indirect Costs",null,{"$f":"SUM('Member Totals'!B9:K9)","v":0}]
[]
["Construction & Renovation Costs",null,{"$f":"SUM('Member Totals'!B10:K10)","v":0}]
[]
["Contracted Security Costs",null,{"$f":"SUM('Member Totals'!B11:K11)","v":0}]
[]
["Total Costs",null,{"$f":"SUM('Member Totals'!B12:K12)","v":0}]
[]
[]
["Name of Primary Applicant of Consortium:",{"$f":"IF(Questions!B3=\"\",\"\",Questions!B3)","v":""}]

{"sheet":"Primary Applicant","index":3,"n_rows":71,"n_cols":5,"rows_kept":71,"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],[16,0,16,4],[20,0,20,3],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[23,0,23,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[31,0,31,4],[71,0,71,4],[24,0,24,4],[28,0,28,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3],[48,0,48,4],[52,0,52,3],[55,0,55,4],[56,0,56,4],[60,0,60,3],[44,0,44,3],[47,0,47,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B13)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash 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(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 2","index":4,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B14)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 3","index":5,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B15)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 4","index":6,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B16)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 5","index":7,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B17)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 6","index":8,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B18)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 7","index":9,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B19)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 8","index":10,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B20)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 9","index":11,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B21)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member 10","index":12,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[23,0,23,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4],[20,0,20,3],[55,0,55,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[36,0,36,3],[39,0,39,4],[40,0,40,4],[44,0,44,3],[47,0,47,4],[48,0,48,4],[52,0,52,3],[71,0,71,4],[56,0,56,4],[60,0,60,3],[63,0,63,4],[64,0,64,4],[68,0,68,3],[70,0,70,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!A19","v":"FFY 2024 Nonprofit Security Grant Program Supplemental Funding For Consortium - "}]
[{"$f":"CONCATENATE(\"Budget Worksheet - \", Questions!B22)","v":"Budget Worksheet - "}]
[]
["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. Please note that budgeted 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 using the \"Add\" command button to add another row when/if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
[]
["PLANNING"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Planning,3,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Authorized Equipment List (AEL) #","Cost","Quantity","Description","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,4)*ROUND(C19,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,4):OFFSET(Maintenance,-4,4))","v":0}]
[]
[]
["MAINTENANCE & SUSTAINMENT"]
[]
["Activity","Cost","Quantity","Description ","Total Cash 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(Maintenance,3,4):OFFSET(Training,-4,4))","v":0}]
[]
[]
["TRAINING/EXERCISES"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,4):OFFSET(NMA,-4,4))","v":0}]
[]
[]
["NONPROFIT MANAGEMENT & ADMINISTRATION (M&A)"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(NMA,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT (FACILITIES & ADMINISTRATIVE [F&A]) COSTS"]
[]
["Activity","Costs Applied to       Indirect Rate","Indirect Rate","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,6),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(Construction,-4,4))","v":0}]
[]
[]
["CONSTRUCTION & RENOVATION"]
[]
["Activity","Cost","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,4)*ROUND(C59,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,4)*ROUND(C60,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Construction,3,4):OFFSET(Security,-4,4))","v":0}]
[]
[]
["CONTRACTED SECURITY"]
[]
["Contracts/Company","Rate","Quantity","Description ","Total Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,4)*ROUND(C67,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,4)*ROUND(C68,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Security,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37+E45+E53+E61+E69),2)","v":0}]

{"sheet":"Member Totals","index":13,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,0,1,10]]}
[]
["Subaward Budgets"]
["Cost Categories",{"$f":"CONCATENATE(Questions!A13, \" - \", Questions!B13)","v":"Primary Applicant - "},{"$f":"CONCATENATE(Questions!A14, \" - \", Questions!B14)","v":"Member 2 - "},{"$f":"CONCATENATE(Questions!A15, \" - \", Questions!B15)","v":"Member 3 - "},{"$f":"CONCATENATE(Questions!A16, \" - \", Questions!B16)","v":"Member 4 - "},{"$f":"CONCATENATE(Questions!A17, \" - \", Questions!B17)","v":"Member 5 - "},{"$f":"CONCATENATE(Questions!A18, \" - \", Questions!B18)","v":"Member 6 - "},{"$f":"CONCATENATE(Questions!A19, \" - \", Questions!B19)","v":"Member 7 - "},{"$f":"CONCATENATE(Questions!A20, \" - \", Questions!B20)","v":"Member 8 - "},{"$f":"CONCATENATE(Questions!A21, \" - \", Questions!B21)","v":"Member 9 - "},{"$f":"CONCATENATE(Questions!A22, \" - \", Questions!B22)","v":"Member 10 - "}]
["Planning Costs",{"$f":"'Primary Applicant'!$E$13","v":0},{"$f":"'Member 2'!$E$13","v":0},{"$f":"'Member 3'!$E$13","v":0},{"$f":"'Member 4'!$E$13","v":0},{"$f":"'Member 5'!$E$13","v":0},{"$f":"'Member 6'!$E$13","v":0},{"$f":"'Member 7'!$E$13","v":0},{"$f":"'Member 8'!$E$13","v":0},{"$f":"'Member 9'!$E$13","v":0},{"$f":"'Member 10'!$E$13","v":0}]
["Equipment Costs",{"$f":"'Primary Applicant'!$E$21","v":0},{"$f":"'Member 2'!$E$21","v":0},{"$f":"'Member 3'!$E$21","v":0},{"$f":"'Member 4'!$E$21","v":0},{"$f":"'Member 5'!$E$21","v":0},{"$f":"'Member 6'!$E$21","v":0},{"$f":"'Member 7'!$E$21","v":0},{"$f":"'Member 8'!$E$21","v":0},{"$f":"'Member 9'!$E$21","v":0},{"$f":"'Member 10'!$E$21","v":0}]
["Maintenance & Sustainment Costs",{"$f":"'Primary Applicant'!$E$29","v":0},{"$f":"'Member 2'!$E$29","v":0},{"$f":"'Member 3'!$E$29","v":0},{"$f":"'Member 4'!$E$29","v":0},{"$f":"'Member 5'!$E$29","v":0},{"$f":"'Member 6'!$E$29","v":0},{"$f":"'Member 7'!$E$29","v":0},{"$f":"'Member 8'!$E$29","v":0},{"$f":"'Member 9'!$E$29","v":0},{"$f":"'Member 10'!$E$29","v":0}]
["Training & Exercises Costs",{"$f":"'Primary Applicant'!$E$37","v":0},{"$f":"'Member 2'!$E$37","v":0},{"$f":"'Member 3'!$E$37","v":0},{"$f":"'Member 4'!$E$37","v":0},{"$f":"'Member 5'!$E$37","v":0},{"$f":"'Member 6'!$E$37","v":0},{"$f":"'Member 7'!$E$37","v":0},{"$f":"'Member 8'!$E$37","v":0},{"$f":"'Member 9'!$E$37","v":0},{"$f":"'Member 10'!$E$37","v":0}]
["M&A Costs",{"$f":"'Primary Applicant'!$E$45","v":0},{"$f":"'Member 2'!$E$45","v":0},{"$f":"'Member 3'!$E$45","v":0},{"$f":"'Member 4'!$E$45","v":0},{"$f":"'Member 5'!$E$45","v":0},{"$f":"'Member 6'!$E$45","v":0},{"$f":"'Member 7'!$E$45","v":0},{"$f":"'Member 8'!$E$45","v":0},{"$f":"'Member 9'!$E$45","v":0},{"$f":"'Member 10'!$E$45","v":0}]
["Indirect Costs",{"$f":"'Primary Applicant'!$E$53","v":0},{"$f":"'Member 2'!$E$53","v":0},{"$f":"'Member 3'!$E$53","v":0},{"$f":"'Member 4'!$E$53","v":0},{"$f":"'Member 5'!$E$53","v":0},{"$f":"'Member 6'!$E$53","v":0},{"$f":"'Member 7'!$E$53","v":0},{"$f":"'Member 8'!$E$53","v":0},{"$f":"'Member 9'!$E$53","v":0},{"$f":"'Member 10'!$E$53","v":0}]
["Construction & Renovation Costs",{"$f":"'Primary Applicant'!$E$61","v":0},{"$f":"'Member 2'!$E$61","v":0},{"$f":"'Member 3'!$E$61","v":0},{"$f":"'Member 4'!$E$61","v":0},{"$f":"'Member 5'!$E$61","v":0},{"$f":"'Member 6'!$E$61","v":0},{"$f":"'Member 7'!$E$61","v":0},{"$f":"'Member 8'!$E$61","v":0},{"$f":"'Member 9'!$E$61","v":0},{"$f":"'Member 10'!$E$61","v":0}]
["Contracted Security Costs",{"$f":"'Primary Applicant'!$E$69","v":0},{"$f":"'Member 2'!$E$69","v":0},{"$f":"'Member 3'!$E$69","v":0},{"$f":"'Member 4'!$E$69","v":0},{"$f":"'Member 5'!$E$69","v":0},{"$f":"'Member 6'!$E$69","v":0},{"$f":"'Member 7'!$E$69","v":0},{"$f":"'Member 8'!$E$69","v":0},{"$f":"'Member 9'!$E$69","v":0},{"$f":"'Member 10'!$E$69","v":0}]
["TOTALS:",{"$f":"'Primary Applicant'!$E$71","v":0},{"$f":"'Member 2'!$E$71","v":0},{"$f":"'Member 3'!$E$71","v":0},{"$f":"'Member 4'!$E$71","v":0},{"$f":"'Member 5'!$E$71","v":0},{"$f":"'Member 6'!$E$71","v":0},{"$f":"'Member 7'!$E$71","v":0},{"$f":"'Member 8'!$E$71","v":0},{"$f":"'Member 9'!$E$71","v":0},{"$f":"'Member 10'!$E$71","v":0}]
[]
[]
["GRAND TOTAL:",{"$f":"SUM(B12:K12)","v":0}]

{"sheet":"AEL Equipment List","index":14,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["03OE-03-MEGA - System, Public Address, Handheld or Mobile "]
["03OE-03-SIGN - Signs"]
["04AP-05-CRED - System, Credentialing "]
["04AP-06-VIDA - Software, Video Analytics"]
["04AP-09-ALRT - Systems, Public Notification and Warning "]
["04AP-11-SAAS - Applications, Software as a Service "]
["05AU-00-TOKN - System, Remote Authentication "]
["05EN-00-ECRP - Software, Encryption "]
["05HS-00-MALW - Software, Malware/Anti-Virus Protection "]
["05HS-00-PFWL - System, Personal Firewall "]
["05NP-00-FWAL - Firewall, Network "]
["05NP-00-IDPS - System, Intrusion Detection/Prevention "]
["06CC-02-PAGE - Services/Systems, Paging "]
["06CP-01-PORT - Radio, Portable "]
["06CP-01-REPT - Repeater"]
["06CP-03-ICOM - Intercom "]
["06CP-03-PRAC - Accessories, Portable Radio "]
["10GE-00-GENR - Generators "]
["10PE-00-UPS - Supply, Uninterruptible Power (UPS)"]
["13IT-00-ALRT - System, Alert/Notification "]
["14CI-00-COOP - System, Information Technology Contingency Operations "]
["14EX-00-BCAN - Receptacles, Trash, Blast-Resistant "]
["14EX-00-BSIR - Systems, Building, Blast/Shock/Impact Resistant "]
["14SW-01-ALRM - Systems/Sensors, Alarm "]
["14SW-01-ASTN - Network, Acoustic Sensor Triangulation"]
["14SW-01-DOOR - Doors and Gates, Impact Resistant "]
["14SW-01-LITE - Lighting, Area, Fixed "]
["14SW-01-PACS - System, Physical Access Control "]
["14SW-01-SIDP - Systems, Personnel Identification"]
["14SW-01-SIDV - Systems, Vehicle Identification "]
["14SW-01-SNSR - Sensors/Alarms, System and Infrastructure Monitoring, Standalone "]
["14SW-01-VIDA - Systems, Video Assessment, Security "]
["14SW-01-WALL - Barriers: Fences; Jersey Walls "]
["15SC-00-PPSS - Systems, Personnel/Package Screening "]
["21GN-00-INST - Installation "]
["21GN-00-TRNG - Training and Awareness "]