{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Opening Document","Appendix A Guidelines","Budget Summary","Programs Budget","M&A Budget","Helper"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":27,"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":"Appendix A Guidelines","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[6,0,8,0]]}
[null,"Definitions and Documentation Requirements"]
["Personnel","Costs associated with agency personnel. List position, percentage of time charged to grant, and annual salary. Include a brief description of each staff member’s duties/activities to be supported by grant funding. "]
[]
["Operational Overtime","Overtime hours being charged against the award are only eligible for reimbursement for actual hours worked regardless of department policy or union contract rules. For example, an officer working one hour of overtime on a federally funded project awarded by OGR is prohibited from charging the grant award for four hours of overtime due to a union contract. A department that must allow for this will need to cover the remaining three hours of overtime from their own state or local budget. Departments found violating this policy will be subject to immediate termination of a grant award and must return all misspent funds to OGR. CUASGP-funded projects that include operational overtime require additional documentation, including specifying which types of overtime are eligible. Aside from the National Terrorism Advisory System alerts, which do not require pre-approval, operational overtime must be preapproved before an event. CUASGP funds may not be used to support the hiring of sworn public safety officers for purposes of fulfilling traditional public safety duties or to supplant traditional public safety positions and responsibilities\n(6 U.S.C. § 609(b)(1)(A))."]
["Fringe","A copy of the applicant's fringe rate agreement or a breakdown detailing the costs per benefit must be provided with the application submission if budgeting for fringe. Eligible costs may include the employer share of the following: life insurance, health insurance, social security costs, pension costs, unemployment insurance costs, workers compensation insurance, FMLA costs, and payroll taxes.                "]
["Indirect","A copy of your agency's indirect rate agreement must be provided with the application submission if budgeting for indirect. This agreement will determine the applicable base expenses that can be applied in this budget. This is for costs that are not readily assignable to a particular project, but necessary to the operation, maintenance of the organization, and performance of the project. Any non-federal entity, except for state, local units of government, or Indian tribes, that does not have a currently approved negotiated indirect cost rate may elect to charge a de minimis rate of 15% of modified total direct costs (MTDC), which may be used indefinitely."]
["Contractors/Consultants","Contractors: A contractor is when an entity is hired to provide specific goods or services to support the project, without substantial involvement in the project’s overall goals."]
[null,"Consultants: The maximum rate for consultants is $650 for an eight- hour day or $81.25 per hour. Any request for compensation over $650 per day requires prior written approval by OGR. Waiver of this maximum rate is at the discretion of OGR."]
[null,"All costs related to these services (Salaries/Fringe/M&A/Subsistence) should be coded as Contractors/Consultants."]
["Subawards","A subaward is when an organization receives funds to carry out a significant portion of a larger project’s goals, essentially acting as a partner in the project. Under a subaward, the award recipient transfers its responsibility to perform part of the project to another entity. All costs pertaining to the subaward should be coded as Subawards. "]
["Travel","Travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not to exceed $.62 per mile, as well as the actual costs of tolls and parking.  Out-of-state travel, or out-of-state lodging must be budgeted according to the current federal per diem rates which can be found here: https://www.gsa.gov/travel/plan-book/per-diem-rates. All Travel must be preapproved by OGR."]
["Supplies","Supplies directly correlated to the program. Supplies include any materials that are expendable or consumed during the course of the project."]
["Other","List items (e.g., rent, telephone, use of space, etc.) and provide computation. These items wouldn't be classified in the aforementioned. "]

{"sheet":"Budget Summary","index":2,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,2],[16,0,16,2],[34,1,34,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2026 Counter-Unmanned Aircraft Systems Grant Program"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Planning Costs",null,{"$f":"'Programs Budget'!$F$16","v":0}]
[]
["Organizational Costs",null,{"$f":"'Programs Budget'!$F$24","v":0}]
[]
["Equipment Costs",null,{"$f":"'Programs Budget'!$F$32","v":0}]
[]
["Training Costs",null,{"$f":"'Programs Budget'!$F$40","v":0}]
[]
["M&A Costs",null,{"$f":"'M&A Budget'!$E$39","v":0}]
[]
["Total Costs",null,{"$f":"ROUND(C22+C24+C26+C28+C30,2)","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Programs Budget","index":3,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[34,0,34,5],[42,1,42,5],[41,1,41,4],[31,1,31,4],[39,1,39,4],[35,0,35,5],[6,0,6,5],[7,0,7,5],[8,0,8,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[26,0,26,5],[27,0,27,5],[15,1,15,4],[23,1,23,4],[10,0,10,5],[11,0,11,5],[18,0,18,5],[19,0,19,5]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!$A$17","v":"2026 Counter-Unmanned Aircraft Systems Grant Program"}]
[{"$f":"CONCATENATE(\" Programs Budget Worksheet - \", 'Budget Summary'!$B$35)","v":" Programs Budget Worksheet - "}]
[]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. Please note that the subtotals will auto-populate based on the numbers reported within each category. Your requested budget per cost category shall be entered in the rows below the Examples using the \"Add\" command button to add another row if needed. If you have any questions, please contact the grant manager assigned in the AGF document."]
["Please take a moment to read the Availability of Grant Funds (AGF) prior to completing this budget. Each applicant will be expected to follow the guidance that is stated in this AGF. The AGF will highlight important aspects of this funding opportunity such as an grant overview, eligibility and application requirements, key dates, allowable costs, and unallowable costs."]
["Page 5 of the NOFO will detail the different purpose areas of the appicable cost categories under the POETE framework. Using Column A, choose the purpose area that best describes the line item that is being budgeted for. Please also read the items listed in the Appendix A Guidelines tab. Using Column B, choose the genre of the each budgeted line item as it is described in the Appendix A Guidelines tab."]
[]
["PLANNING"]
[]
["Purpose Area","Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description","Cash Expenditures"]
["Plan Development",null,null,null,null,{"$f":"IF(C14=\"\",\"\",IF(OR(B14=\"Fringe\",B14=\"Indirect\"),SUM(ROUND(ROUND(C14,8)*ROUND(D14,8),2)/100),ROUND(ROUND(C14,8)*ROUND(D14,8),2)))","v":""}]
["Plan Development",null,null,null,null,{"$f":"IF(C15=\"\",\"\",IF(OR(B15=\"Fringe\",B15=\"Indirect\"),SUM(ROUND(ROUND(C15,8)*ROUND(D15,8),2)/100),ROUND(ROUND(C15,8)*ROUND(D15,8),2)))","v":""}]
[null,"Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Planning,3,5):OFFSET(Organizational,-4,5))","v":0}]
[]
[]
["ORGANIZATION"]
[]
["Purpose Area","Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description","Cash Expenditures"]
["System Deployment",null,null,null,null,{"$f":"IF(C22=\"\",\"\",IF(OR(B22=\"Fringe\",B22=\"Indirect\"),SUM(ROUND(ROUND(C22,8)*ROUND(D22,8),2)/100),ROUND(ROUND(C22,8)*ROUND(D22,8),2)))","v":""}]
["System Deployment",null,null,null,null,{"$f":"IF(C23=\"\",\"\",IF(OR(B23=\"Fringe\",B23=\"Indirect\"),SUM(ROUND(ROUND(C23,8)*ROUND(D23,8),2)/100),ROUND(ROUND(C23,8)*ROUND(D23,8),2)))","v":""}]
[null,"Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Organizational,3,5):OFFSET(Equipment,-4,5))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Purpose Area","Activity","Cost","Quantity","Authorized Equipment List (AEL) # and Description","Cash Expenditures"]
[null,null,null,null,null,{"$f":"IF(C30=\"\",\"\",IF(B30=\"Indirect\",SUM(ROUND(ROUND(C30,8)*ROUND(D30,8),2)/100),ROUND(ROUND(C30,8)*ROUND(D30,8),2)))","v":""}]
[null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(B31=\"Indirect\",SUM(ROUND(ROUND(C31,8)*ROUND(D31,8),2)/100),ROUND(ROUND(C31,8)*ROUND(D31,8),2)))","v":""}]
[null,"Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,3,5):OFFSET(Training,-4,5))","v":0}]
[]
[]
["TRAINING"]
[]
["Purpose Area","Appendix A Activity","Cost","Quantity or Fringe/Indirect Rate","Description ","Cash Expenditures"]
[null,null,null,null,null,{"$f":"IF(C38=\"\",\"\",IF(OR(B38=\"Fringe\",B38=\"Indirect\"),SUM(ROUND(ROUND(C38,8)*ROUND(D38,8),2)/100),ROUND(ROUND(C38,8)*ROUND(D38,8),2)))","v":""}]
[null,null,null,null,null,{"$f":"IF(C39=\"\",\"\",IF(OR(B39=\"Fringe\",B39=\"Indirect\"),SUM(ROUND(ROUND(C39,8)*ROUND(D39,8),2)/100),ROUND(ROUND(C39,8)*ROUND(D39,8),2)))","v":""}]
[null,"Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Training,3,5):OFFSET(GrandTotal,-3,5))","v":0}]
[]
[null,"Grand Total:",null,null,null,{"$f":"ROUND(SUM(F16+F24+F32+F40),2)","v":0}]

{"sheet":"M&A Budget","index":4,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[36,0,36,3],[38,0,38,3],[39,0,39,4],[5,0,5,4],[20,0,20,3],[23,0,23,4],[24,0,24,4],[28,0,28,3],[31,0,31,4],[32,0,32,4],[7,0,7,4],[8,0,8,4],[12,0,12,3],[15,0,15,4],[16,0,16,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research - Homeland Security Division"]
[{"$f":"'Budget Summary'!$A$17","v":"2026 Counter-Unmanned Aircraft Systems Grant Program"}]
[{"$f":"CONCATENATE(\"M&A Budget Worksheet - \", 'Budget Summary'!$B$35)","v":"M&A Budget Worksheet - "}]
[]
["Overhead expenses not directly tied to a direct program activity, but necessary for overall business operations. Examples include salaries for executives and support staff, rent and utilities for office space. M&A should be factored into the appropriate cost category as applicable and be used to support the specific CUASGP program. Cannot exceed 3% of total budget."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,8)*ROUND(C11,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,8)*ROUND(C12,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,3,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE"]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B19=\"\",\"\",ROUND(ROUND(B19,8)*ROUND(C19,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",ROUND(ROUND(B20,8)*ROUND(C20,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,3,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",ROUND(ROUND(B27,8)*ROUND(C27,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",ROUND(ROUND(B28,8)*ROUND(C28,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,3,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT"]
[]
["Indirect Expenses","Expenses Applied to Indirect","Contract Indirect Rate","Description ","Cash Expenditures"]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,8)*ROUND(C35,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,8)*ROUND(C36,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,3,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E13+E21+E29+E37),2)","v":0}]
[]
[]
[]
["Maximum M&A Budget                    (3% of Grand Total):",{"$f":"ROUND('Programs Budget'!F42*(3/97),2)","v":0}]
["Current M&A Budget:",{"$f":"E39","v":0}]

{"sheet":"Helper","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Personnel",null,"Equipment",null,"Detection",null,"Detection, Tracking & Identification"]
["Operational Overtime",null,"Indirect",null,"Tracking",null,"Mitigation"]
["Fringe",null,null,null,"Identification",null,"Detection, Tracking, Identification & Mitigation"]
["Indirect",null,null,null,"Mitigation"]
["Contractors/Consultants",null,null,null,"Deployment, Operation & Maintenance"]
["Subawards"]
["Travel"]
["Supplies"]
["Other"]