{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Budget Sheet Instructions","Demographics","PA1","PA2","PA3","PA4","PA5","PA6","PA7","PA8","PA9","Budget Summary","Reference Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":202,"comments":9,"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":"Budget Sheet Instructions","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[11,9,11,10],[10,6,10,8],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[34,1,34,10],[32,1,32,10],[33,1,33,10],[31,1,31,10],[25,0,25,10],[30,1,30,10],[29,1,29,10],[26,1,26,10],[27,1,27,10],[28,1,28,10],[0,0,0,10],[1,0,1,10],[5,0,5,10],[2,0,2,10],[6,0,6,10],[3,6,3,10],[3,0,3,4],[7,0,8,10],[24,1,24,8],[12,0,12,10],[4,0,4,10],[16,1,16,8],[17,1,17,8],[19,1,19,8],[22,1,22,8],[23,1,23,8],[20,1,20,8],[21,1,21,8],[18,1,18,8],[14,1,14,8],[15,1,15,8],[9,0,9,10],[10,2,10,4]]}
["CTAS Budget Detail Worksheet  FY17"]
["Worksheet Instructions"]
["Note: This document requires macros be enabled to work properly. Please ensure that macros are enabled before entering any data. You may be able to enable macros by choosing the \"Enable this content\" option from the Security Warning Ribbon above. \n\n\n\n\n\nIf the ribbon is not visible you may have been prompted to enable macros when you opened he document as pictured here. If you elected to disable macros, "]
[null,null,null,null,null,null," please close the document and reopen it with macros enabled. "]
["Purpose:"]
["The Budget Detail Worksheet is provided for your use in the preparation of the budget and budget narrative. All required information (including the budget narrative) must be provided. Funds may not be budgeted in the shaded categories under each purpose area. Indicate any non-federal (matching) amount in the appropriate category, if applicable."]
["How to use this Workbook:"]
["This workbook has been made available to CTAS applicants so that they can provide budgetary information for each Purpose Area they are applying for.  It is a required document and must be completed and uploaded to the Grant Management System (GMS) as an attachment to your application. The workbook includes three different worksheets. The first worksheet (this one) is an instruction sheet; the second worksheet includes the Purpose Area specific budget detail worksheet and narrative and each must be filled out if the applicant is applying for that specific Purpose Area. If an application is not being submitted for a particular Purpose Area, no action on the budget worksheet is required. The last worksheet is a Budget Summary. It compiles all of the relevant budget information for all Purpose Areas into a single location and should be reviewed for correctness before the workbook is uploaded to the GMS application. \nStep by Step Usage:\n1. Please read and print this instruction page. It can be used as a reference while completing the rest of the document.\n2. A purpose area index for this workbook has been created for your convenience. Clicking on the link for each Purpose Area will take you directly to that tab in this document.\n3. Complete this document by selecting the relevant Purpose Area tabs for which funds are being requested and entering the budget detail information in the boxes.\n4. None of the purpose areas in this solicitation require a match.  However, if a successful application proposes a voluntary match amount, and DOJ approves the budget, the total match amount incorporated into the approved budget becomes mandatory and subject to audit.\n5. A budget narrative section is provided to you for each category within the worksheet.  This is where your justification and/or linkages to the program narrative may be entered.\n6. A Budget Summary is automatically calculated for you on the last worksheet.  Note:  Any errors detected on this page should be fixed on the Purpose Area specific tab.\n\nNote regarding “Subawards (Subgrants)/Procurement Contracts” category (formerly labeled “Consultants/Contracts”):  DOJ has designated this budget category, starting with the FY 16 CTAS, to enable applicants to identify proposed costs for subawards (see “Subaward” definition at 2 CFR 200.92) and distinguish those costs from costs for procurement contracts (see “Contract” definition at 2 CFR 200.22) the applicant proposes to fund with Federal award funds.  For more information, see item IV.  “Budget Detail Worksheet and Budget Narrative including Demographic Form” under Section D. What an Application Should Include in the solicitation and the response to the CTAS FY 2016 FAQ entitled, “What do I need to know before entering data and information under the ‘Subawards (Subgrants)/Procurement Contracts’ budget category in the CTAS Budget Worksheet?”\n\nContact Information\n\nTechnical Assistance: For technical assistance with submitting an application, contact the Grants Management System Support Hotline at 1–888–549–9901, option 3, or via e-mail to GMSHelpDesk@usdoj.gov. The GMS Support Hotline is available Monday–Friday (except U.S. federal government holidays) from 6:00 a.m. to 12:00 midnight, Eastern Time. \n\nProgrammatic Assistance: For programmatic and general assistance with the requirements of this solicitation, contact the Response Center at 1–800–421–6770 or by e-mail at tribalgrants@usdoj.gov. The Response Center’s hours of operation are Monday–Friday (except U.S. federal government holidays) from 9:00 a.m. to 5:00 p.m. Eastern Time. The Response Center will remain open on the solicitation closing date until 9:00 p.m. Eastern Time. "]
[]
["Budget Point of Contact Information:"]
["Contact Name: ","Last:",null,null,null,"First: ",null,null,null,"Middle: "]
["Contact Phone: ",null,null,"Contact Fax:",null,null,null,"Contact Email:"]
["Purpose Area Index:"]
["PA (#)","Name",null,null,null,null,null,null,null,"Program Office","CFDA #"]
["Demographics Form","CTAS Demographic Form"]
[1,"Public Safety and Community Policing ",null,null,null,null,null,null,null,"COPS","16.710"]
[2,"Comprehensive Tribal Justice Systems Strategic Planning",null,null,null,null,null,null,null,null,"16.608"]
[3,"Justice Systems and Alcohol and Substance Abuse",null,null,null,null,null,null,null,"BJA","16.608"]
[4,"Tribal Justice System Infrastructure Program",null,null,null,null,null,null,null,"BJA","16.596"]
[5,"Office on Violence Against Women Tribal Governments Program",null,null,null,null,null,null,null,"OVW","16.587"]
[6,"Children’s Justice Act Partnerships for Indian Communities",null,null,null,null,null,null,null,"OVC","16.582"]
[7,"Comprehensive Tribal Victim Assistance Program ",null,null,null,null,null,null,null,"OVC","16.582"]
[8,"Tribal Juvenile Healing To Wellness Courts",null,null,null,null,null,null,null,"OJJDP","16.585"]
[9,"Tribal Youth Program",null,null,null,null,null,null,null,"OJJDP","16.731"]
[null,"Budget Summary"]
["Budget Category Descriptions:"]
["Personnel","List each position by title and name of employee, if available. Show the annual salary rate and the percentage of time to be devoted to the project. Compensation paid for employees engaged in grant activities must be consistent with that paid for similar work within the applicant organization. In the budget narrative, include a description of the responsibilities and duties of each position in relationship to fulfilling the project goals and objectives. All requested information must be included in the budget detail worksheet and budget narrative.\n"]
["Fringe Benefits","Fringe benefits should be based on actual known costs or an approved negotiated rate by a Federal agency. If not based on an approved negotiated rate, list the composition of the fringe benefit package. Fringe benefits are for the personnel listed in the budget category (A) and only for the percentage of time devoted to the project. All requested information must be included in the budget detail worksheet and budget narrative."]
["Travel","Itemize travel expenses of staff personnel (e.g. staff to training, field interviews, advisory group meeting, etc.). Describe the purpose of each travel expenditure in reference to the project objectives. Show the basis of computation (e.g., six people to 3-day training at $X airfare, $X lodging, $X subsistence). In training projects, travel and meals for trainees should be listed separately. Show the number of trainees and the unit costs involved. Identify the location of travel, if known; or if unknown, indicate \"location to be determined.\" Indicate whether applicant's formal written travel policy or the Federal Travel Regulations are followed. Note: Travel expenses for consultants should be included in the “Consultant Travel” data fields under the “Subawards (Subgrants)/Procurement Contracts” category. For each Purpose Area applied for, the budget should include the estimated cost for travel and accommodations for two staff to attend two three-day long meetings, with one in Washington D.C. and one in their region, with the exception of Purpose Area 1, which should budget for one meeting in Washington D.C, and Purpose Areas 6 and 7, which should budget for 3 meetings within a 3 year period, with 2 in Washington D.C, and 1 within their region. All requested information must be included in the budget detail worksheet and budget narrative. "]
["Equipment","List non-expendable items that are to be purchased (Note: Organization's own capitalization policy for classification of equipment should be used). Expendable items should be included in the \"Supplies\" category. Applicants should analyze the cost benefits of purchasing versus leasing equipment, especially high cost items and those subject to rapid technological advances. Rented or leased equipment costs should be listed in the “Contracts” data fields under the “Subawards (Subgrants)/Procurement Contracts\" category. In the budget narrative, explain how the equipment is necessary for the success of the project, and describe the procurement method to be used. All requested information must be included in the budget detail worksheet and budget narrative."]
["Supplies","List items by type (office supplies, postage, training materials, copy paper, and expendable equipment items costing less than $5,000, such as books, hand held tape recorders) and show the basis for computation. Generally, supplies include any materials that are expendable or consumed during the course of the project. All requested information must be included in the budget detail worksheet and budget narrative."]
["Construction","Provide a description of the construction project and an estimate of the costs.  Construction costs are only allowed for Purpose Area #4.  Minor repairs or renovations may be allowable in other Purpose Areas and should be classified in the “Other” category.  Consult with the program office before budgeting funds in this category.  All requested information must be included in the budget detail worksheet and  budget narrative. "]
["Subawards (Subgrants) / Procurement Contracts","Procurement contracts (see “Contract” definition at 2 CFR 200.22): Provide a description of the product or service to be procured by contract and an estimate of the cost.  Indicate whether the applicant’s formal, written Procurement Policy or the Federal Acquisition Regulation is followed.  Applicants are encouraged to promote free and open competition in awarding procurement contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold set in accordance with 41 U.S.C. 1908 (currently set at $150,000).\n\nConsultant Fees:  For each consultant enter the name, if known, service to be provided, hourly or daily fee (8-hour day), and estimated time on the project.  Consultant fees in excess of the DOJ grant-making component’s maximum rate for an 8-hour day (currently $650 for OJP and OVW, and $550 for the COPS Office) require additional justification and prior approval from the respective DOJ grant-making component.  All requested information must be included in the budget detail worksheet and budget narrative.\n\nSubawards (see “Subaward” definition at 2 CFR 200.92):  Provide a description of the Federal award activities proposed to be carried out by any subrecipient and an estimate of the cost (include the cost per subrecipient, to the extent known prior to application submission).  For each subrecipient, enter the subrecipient entity name, if known.  Please indicate any subaward information included under budget category G. Subawards (Subgrants)/Procurement Contracts by including the label “(subaward)” with each subaward entry."]
["Other Costs","List items (e.g., rent, reproduction, telephone, janitorial or security services, and investigative or confidential funds) by type and the basis of the computation. For example, provide the square footage and the cost per square foot for rent, or provide a monthly rental cost and how many months to rent. All requested information must be included in the budget detail worksheet and budget narrative."]
["Indirect Costs","Indirect costs are allowed only if:  a) the applicant has a current, federally approved indirect cost rate; or b) the applicant is eligible to use and elects to use the “de minimis” indirect cost rate described in 2 C.F.R. 200.414(f).  (See paragraph D.1.b. in Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals for a description of entities that may not elect to use the “de minimis” rate.)  An applicant with a current, federally approved indirect cost rate must attach a A copy of the rate approval, (a fully-executed, negotiated agreement.  If the applicant does not have an approved rate, one can be requested by contacting the applicant’s cognizant Federal agency, which will review all documentation and approve a rate for the applicant organization, or if the applicant’s accounting system permits, costs may be allocated in the direct costs categories.  (Applicant Indian tribal governments, in particular, should review Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals regarding submission and documentation of indirect cost proposals.)  Narrative for any indirect costs should clearly state which direct costs the indirect cost agreement is being applied to.  All requested information must be included in the budget detail worksheet and budget narrative.\nIn order to use the “de minimis” indirect rate an applicant would need to attach written documentation to the application that advises DOJ of both the applicant’s eligibility (to use the “de minimis” rate) and its election. If the applicant elects the de minimis method, costs must be consistently charged as either indirect or direct costs, but may not be double charged or inconsistently charged as both. In addition, if this method is chosen then it must be used consistently for all federal awards until such time as the applicant entity chooses to negotiate a federally approved indirect cost rate.\n"]

{"sheet":"Demographics","index":1,"n_rows":164,"n_cols":9,"rows_kept":164,"cut":false,"hidden":false,"merged":[[59,1,59,8],[61,2,61,8],[62,2,62,5],[62,6,62,8],[63,2,63,5],[63,6,63,8],[72,2,78,8],[83,1,83,8],[84,1,84,8],[80,1,80,8],[89,5,89,8],[64,2,64,5],[64,6,64,8],[65,2,65,5],[65,6,65,8],[66,2,66,5],[66,6,66,8],[161,7,161,8],[162,7,162,8],[151,1,152,8],[100,1,100,8],[101,3,101,4],[92,1,92,8],[93,2,93,8],[71,1,71,8],[72,0,78,1],[113,7,113,8],[107,7,107,8],[109,2,109,6],[107,2,107,6],[109,7,109,8],[111,2,111,6],[111,7,111,8],[102,3,102,4],[163,7,163,8],[155,7,155,8],[156,7,156,8],[157,7,157,8],[158,7,158,8],[159,7,159,8],[160,7,160,8],[67,2,67,5],[67,6,67,8],[68,2,68,5],[68,6,68,8],[69,2,69,5],[69,6,69,8],[154,7,154,8],[94,5,94,8],[96,1,96,8],[97,2,97,8],[98,3,98,4],[98,5,98,6],[98,7,98,8],[136,1,137,8],[146,4,146,8],[148,4,148,8],[153,7,153,8],[55,1,56,8],[58,0,58,3],[18,7,18,8],[22,1,22,8],[42,6,42,8],[45,1,46,8],[48,1,49,8],[50,1,51,8],[53,1,53,8],[54,1,54,8],[18,1,19,5],[20,1,21,5],[20,7,20,8],[14,1,15,5],[14,7,14,8],[16,1,17,5],[16,7,16,8],[0,0,0,9],[1,1,1,8],[2,0,2,3],[3,1,3,8],[4,3,4,8],[6,3,6,8],[8,7,8,8],[12,1,13,5],[12,7,12,8],[10,1,11,5],[8,1,9,5],[10,7,10,8],[102,5,102,6],[102,7,102,8],[104,2,105,6],[105,7,105,8],[126,2,126,6],[126,7,126,8],[115,1,115,8],[116,3,116,4],[117,3,117,4],[117,5,117,6],[117,7,117,8],[119,2,120,6],[120,7,120,8],[122,2,122,6],[122,7,122,8],[124,2,124,6],[124,7,124,8]]}
["Demographic Form"]
[null,"Please fill out this form in its entirety. Note that each subsection has individual instructions. Please read them carefully before filling out this form. If you are applying as a consortium please aggregate the data for all the Tribes represented in your application."]
["I. Tribe Information"]
[null,"1. The name of each federally-recognized Indian Tribe that will be served by the proposed project(s):"]
[null,"Name(s)",null,"The name(s) of your tribe and represented tribes. "]
[]
[null,"BIA Region(s)"]
[]
[null,"2. What is the Tribe's current enrollment, including members living both on and off the reservation?"]
[]
[null,"3. What is the Tribe's juvenile population, including members living both on and off the reservation?"]
[]
[null,"4. Of your current enrollment, what is the Tribe's total number of unemployed 18 years and over?"]
[]
[null,"5. Of your current enrollment, what is the Tribe's total number of under-employed (below the poverty line) 18 years and over?"]
[]
[null,"6. Of your current enrollment, what is the Tribe's total number of employed 18 years and over?"]
[]
[null,"7. What is the current local population base?"]
[]
[null,"8. Please enter the approximate square mileage of the reservation/jurisdiction to be served: (sq. miles)"]
[]
[null,"9. Please check the crime victim population area(s) that best describe the services the Tribe typically supports."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10. Have you applied for a CTAS grant before?"]
[]
[null,null,"If yes, what year?"]
[]
[null,"11. Please provide your status as an applicant (check all that apply):"]
[]
[]
[]
[]
[]
[]
[null,"a. If you selected Tribal Coalition or Tribal Consortia please list the tribes you represent:"]
[]
[]
[]
[null,"b. If you selected Non-profit organization describe the nature of you services and whom you provide them."]
[]
[]
[]
[]
[null,"12. Please indicate if you agree with the following statement: The tribe(s)submitting this application consider themselves to be remotely located with respect to availability of justice or other relevant community services."]
[null,"If you selected “Yes”, please provide a brief statement that explains your selection. Examples might include “For a majority of our tribal community, law enforcement resource centers are greater than 1 hour’s drive away.” Or  “Our tribal community has no resident medical facilities and the nearest public health center is operated by the City/Town of XXX which is not within tribal lands and not easily reached.”"]
[]
[]
[]
["II. Property/Violent Crime"]
[null,"Using the most recent available data and to the best of your ability using the UCR crime definitions, enter the actual number of incidents reported to your Tribe for the following crime types. Note that only those incidents for which your Tribe had primary response authority should be provided."]
[]
[null,null,"UCR Data *"]
[null,null,"Year"]
[null,null,"Criminal Homicide"]
[null,null,"Forcible Rape"]
[null,null,"Robbery"]
[null,null,"Aggravated Assault"]
[null,null,"Burglary"]
[null,null,"Larceny (except motor vehicle theft)"]
[null,null,"Motor Vehicle Theft"]
[]
[null,"*Note: If your Tribe is not using UCR data or reports to NIBRS, please explain the source or methods used to report your crime data. If you do not report crime incidents at all please explain why you are unable to provide such data. If instructions are needed on converting your data to UCR Summary Data style please view the COPS Application Guide of the FBI's UCR Handbook (www.fbi.gov/ucr/handbook/ucrhandbook04.pdf) for more information."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The FBI is retiring the current Summary Reporting System (SRS) and will transition to an all-NIBRS data collection system within the next five years. The transition to NIBRS will provide a more complete and accurate picture of crime at the tribal, national, state, and local level. As of 2021, the FBI will no longer collect summary data and will only accept data in the NIBRS format and COPS Office awards will be based on submitted NIBRS data. Transitioning all law enforcement agencies to NIBRS is the first step in gathering more comprehensive crime data. Tribal, state, and local COPS grantees are encouraged to expedite the transition to NIBRS in their jurisdictions so that they will remain eligible to receive COPS Office awards."]
[]
["III. Tribal Law Enforcement Information"]
[null,"Please answer the following questions. NOTE: If you choose \"none\" for question 1 you are finished completing this section and do not need to answer 1a or 1b."]
[null,"1. What law enforcement agency or departments does your Tribe operate? (check all that apply):"]
[]
[]
[]
[]
[]
[]
[]
[null,"a. What is the actual population your department serves as the primary law enforcement agency entity?"]
[null,null,"This may or may not be the same as the population reported in the U.S. Census, the Tribe's current enrollment or the local population base. A Tribe with primary law enforcement authority is defined as having first responder responsibility to calls for service for all types of criminal incidents within its jurisdiction."]
[]
[]
[null,"b. Enter the current Fiscal Year Actual Sworn Force Strength as of the date of this application:"]
[null,null,"The actual number of sworn officer positions is the actual number of sworn positions employed by your Tribe as of the date of this application. Do not include funded but currently vacant positions or unpaid positions. NOTE: For Tribes with multiple component law enforcement departments (e.g. Department of Public Safety and Fish and Wildlife Department), please report cumulative, full- and part-time sworn-force strength number for all law enforcement departments in your Tribe which would receive funding through this request if awarded."]
[null,null,"Full-Time:",null,null,"Part-Time:"]
[]
[null,"2. On average how many hours of IN-SERVICE (non-recruit) training (e.g. FTO, continuing professional education, roll call, standard) are required annually for each of your agency’s officers/deputies in the following categories (if none, please indicate 0 hours)?"]
[]
[null,null,"Use of Force:",null,null,"De-escalation of conflict:"]
[]
[null,null,"Racial and ethnic bias that includes elements of implicit/unconscious bias:     "]
[]
[]
[null,null,"Gender bias in response to domestic violence and sexual assault:"]
[]
[null,null,"Bias towards lesbian, gay, bisexual, and transgender (LGBT) individuals:"]
[]
[null,null,"Community engagement (e.g., community policing and problem solving):"]
[]
[null,"3. Does your agency administer a police training academy? "]
[]
[null,"4. How many total hours of basic/recruit ACADEMY training are required for each of your agency’s officer/deputy recruits in the following categories (if none, please indicate 0 hours)?"]
[]
[null,null,"Use of Force:",null,null,"De-escalation of conflict:"]
[]
[null,null,"Racial and ethnic bias that includes elements of implicit/unconscious bias:     "]
[]
[]
[null,null,"Gender bias in response to domestic violence and sexual assault:"]
[]
[null,null,"Bias towards lesbian, gay, bisexual, and transgender (LGBT) individuals:"]
[]
[null,null,"Community engagement (e.g., community policing and problem solving):"]
[]
["IV. Tribal Facilities, Capacities and Capabilities"]
[null,"1. Telecommunications and Technology"]
[null,"a. Describe your Internet Access:"]
[]
[]
[]
[]
[]
[null,"b. What types of communication services are generally available to the tribe at large and/or the tribe's justice components? (check all that apply)"]
[]
[null,null,null,null,null,null,null,"Tribe","Justice "]
[null,null,"i. Land Line (telephone, dial-up service)"]
[null,null,"ii. Cellular (telephone, data, etc.)"]
[null,null,"iii. Satellite - Receive only (broadcasting services)"]
[null,null,"iv. Satellite - 2-way (2-way voice and data and well as broadcasting)"]
[null,null,"v. Radio services  - (HF, VHF, UHF)"]
[null,null,"vi. Point to Point Microwave "]
[null,null,"vii. Other (please describe)"]
[null,null,null,"Tribal"]
[]
[null,null,null,"Justice Comp."]
[]
[null,"2. Facilities and Services (check all that apply)"]
[null,"Applicants should check and provide data for all the facilities and services located within the reservation/jurisdiction described in question 8 above. "]
[]
[null,null,null,null,null,null,"# of beds"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of beds"]
[null,null,null,null,null,null,"# of beds"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]

{"sheet":"PA1","index":2,"n_rows":173,"n_cols":26,"rows_kept":173,"cut":false,"hidden":false,"merged":[[120,0,120,2],[120,3,120,6],[120,7,120,10],[120,11,120,13],[99,0,99,13],[116,0,116,3],[117,0,117,13],[126,0,126,10],[125,0,125,2],[125,3,125,6],[125,7,125,10],[121,0,122,10],[121,11,122,11],[121,12,122,12],[121,13,122,13],[123,0,123,2],[123,3,123,6],[123,7,123,10],[124,0,124,2],[124,3,124,6],[124,7,124,10],[106,0,109,3],[106,4,109,5],[103,8,103,13],[104,12,105,12],[104,13,105,13],[104,11,105,11],[119,0,119,2],[119,3,119,6],[119,7,119,10],[119,11,119,13],[166,0,166,1],[166,3,166,5],[166,6,166,7],[149,0,149,13],[147,0,147,10],[141,0,141,10],[140,0,140,13],[128,0,128,13],[144,0,144,10],[165,0,165,1],[165,3,165,5],[165,6,165,7],[163,0,163,1],[163,3,163,5],[163,6,163,7],[162,0,162,7],[131,0,131,3],[131,4,131,5],[131,6,131,7],[131,8,131,13],[132,0,132,3],[132,4,132,5],[132,6,132,7],[132,8,132,13],[167,0,167,1],[167,3,167,5],[172,6,172,7],[168,0,168,1],[168,3,168,5],[168,6,168,7],[169,0,169,1],[167,6,167,7],[169,3,169,5],[169,6,169,7],[170,0,170,1],[170,3,170,5],[170,6,170,7],[171,0,171,1],[171,3,171,5],[171,6,171,7],[172,0,172,1],[172,3,172,5],[164,0,164,1],[164,3,164,5],[164,6,164,7],[133,0,134,3],[133,4,134,5],[133,6,134,7],[133,8,134,8],[133,9,134,9],[133,10,134,10],[139,0,139,13],[137,0,137,10],[135,6,135,7],[161,0,161,13],[153,8,153,13],[152,8,152,13],[159,0,159,10],[142,0,142,10],[154,5,154,7],[154,0,154,4],[155,0,155,4],[155,5,155,7],[155,8,155,10],[154,8,154,10],[153,0,153,4],[68,0,68,4],[69,5,70,7],[57,5,57,7],[81,0,81,13],[95,0,95,10],[96,0,96,13],[83,0,83,13],[80,0,80,13],[63,0,64,13],[77,0,78,13],[71,0,71,4],[71,5,71,7],[69,8,70,10],[67,0,67,4],[87,0,88,10],[82,0,82,3],[85,0,85,2],[86,0,86,2],[93,3,93,6],[93,7,93,10],[94,0,94,2],[94,3,94,6],[94,7,94,10],[92,0,92,2],[89,0,89,2],[89,3,89,6],[100,0,100,13],[101,0,101,13],[85,11,85,13],[86,11,86,13],[152,0,152,4],[114,0,114,10],[104,9,105,9],[150,0,150,13],[104,8,105,8],[106,13,109,13],[92,3,92,6],[92,7,92,10],[118,0,118,13],[102,6,102,7],[103,6,103,7],[104,6,105,7],[102,4,102,5],[103,4,103,5],[102,0,102,3],[103,0,103,3],[104,0,105,3],[104,4,105,5],[69,12,70,12],[69,11,70,11],[87,12,88,12],[71,8,71,10],[87,13,88,13],[69,0,70,4],[87,11,88,11],[74,8,74,10],[97,0,97,13],[74,5,74,7],[84,0,84,13],[69,13,70,13],[89,7,89,10],[90,0,90,2],[90,3,90,6],[90,7,90,10],[91,0,91,2],[91,3,91,6],[91,7,91,10],[93,0,93,2],[85,3,85,6],[86,3,86,6],[86,7,86,10],[85,7,85,10],[0,10,0,13],[8,13,9,13],[8,12,9,12],[0,0,0,8],[1,3,2,8],[6,0,6,3],[8,8,9,8],[8,10,9,10],[8,11,9,11],[7,4,7,13],[6,4,6,13],[5,0,5,13],[8,0,8,3],[9,0,9,3],[8,4,9,4],[1,0,2,1],[8,5,8,7],[7,0,7,3],[65,0,65,13],[51,0,51,13],[55,11,56,11],[53,5,53,13],[50,0,50,13],[57,8,57,10],[48,0,48,10],[55,8,56,10],[55,13,56,13],[6,24,28,24],[10,0,10,3],[14,8,14,10],[13,5,13,13],[16,0,16,3],[17,0,17,3],[6,14,28,14],[18,0,18,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[12,5,12,13],[12,0,12,4],[13,0,13,4],[11,4,11,6],[11,9,11,11],[14,12,15,12],[14,13,15,13],[14,11,15,11],[14,5,14,7],[14,0,15,4],[28,0,28,13],[25,0,25,3],[19,0,19,3],[39,4,40,5],[33,0,33,10],[39,11,40,11],[55,12,56,12],[61,0,61,10],[35,0,35,13],[39,12,40,12],[39,13,40,13],[39,9,40,9],[38,6,38,7],[37,6,37,7],[39,6,40,7],[39,10,40,10],[47,5,47,7],[41,9,44,9],[41,10,44,10],[41,11,44,11],[43,6,43,7],[41,13,44,13],[41,12,44,12],[54,5,54,13],[55,5,56,7],[55,0,56,4],[54,0,54,4],[20,0,20,3],[42,6,42,7],[21,0,21,3],[75,0,75,10],[37,0,37,3],[38,0,38,3],[37,4,37,5],[32,0,32,10],[31,0,31,10],[44,6,44,7],[34,0,34,10],[38,8,38,13],[37,8,37,13],[39,8,40,8],[26,0,26,1],[26,4,26,10],[41,0,44,3],[41,4,44,5],[53,0,53,4],[57,0,57,4],[41,6,41,7],[74,0,74,3],[38,4,38,5],[39,0,40,3],[135,4,135,5],[135,0,135,3],[138,0,138,3],[102,8,102,13],[67,5,67,13],[68,5,68,13],[111,6,111,7],[111,0,111,3],[111,4,111,5],[109,6,109,7],[106,6,106,7],[104,10,105,10],[133,13,134,13],[106,10,109,10],[107,6,107,7],[106,9,109,9],[115,0,115,13],[133,12,134,12],[108,6,108,7],[106,11,109,11],[106,12,109,12],[129,0,129,13],[130,0,130,13],[133,11,134,11]]}
[{"$f":"'Budget Sheet Instructions'!B16","v":"Public Safety and Community Policing "},null,null,null,null,null,null,null,null,null,"Purpose Area (1)",null,null,null,null,null,0,0,2,0,0,2,0,null,0,0]
["Program Office",null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J16","v":"COPS"},{"$f":"'Budget Sheet Instructions'!K16","v":"16.710"},null,null,null,"Personnel Salary Values","Personnel Fringe Values","Non-Federal Salary Values","Non-Federal Fringe Values"]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel, B. Fringe Benefits"]
[]
["Type of Position",null,null,null,"Computation"]
[null,null,null,null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
["Name/Position",null,null,null,"# of Positions","Rate",null,null,"Salary ","Time Worked\n(# of  years)","%","Total Cost","Non-Federal Contribution","Federal Request"]
["List each position and name, if known. New positions may be grouped by type.",null,null,null,null,"Year 1","Year 2","Year 3"]
[null,null,null,null,0,0,0,0,{"$f":"SUM(F11:H11)","v":0},{"$f":"3","v":3},{"$f":"100%","v":1},{"$f":"(E11*I11)","v":0},0,{"$f":"IF(L11-M11<0,0,L11-M11)","v":0},null,null,{"$f":"L11","v":0},null,{"$f":"M11","v":0}]
["B.Fringe Benefits",null,null,null,"Does Salary include Sick Leave?",null,null,"No",null,"Does Salary include Vacation Time?",null,null,"No",null,null,null,null,null,null,null,null,"Yes"]
["Type of Benefit",null,null,null,null,"Computation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,null,null,"Show the basis for computation."]
[null,null,null,null,null,"Base",null,null,"Rate",null,null,"Total Cost (Per Position)","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,"Year 1","Year 2","Year 3","Year 1","Year 2","Year 3"]
["Social Security",null,null,null,null,{"$f":"(F11*I17)","v":0},{"$f":"(G11*J17)","v":0},{"$f":"(H11*K17)","v":0},0,0,0,{"$f":"SUM(F17:H17)","v":0},0,{"$f":"IF(L17-M17<0,0,L17-M17)","v":0}]
["Medicare",null,null,null,null,{"$f":"(F11*I18)","v":0},{"$f":"(G11*J18)","v":0},{"$f":"(H11*K18)","v":0},0,0,0,{"$f":"SUM(F18:H18)","v":0},0,0]
["Health Insurance",null,null,null,null,{"$f":"(F11*I19)","v":0},{"$f":"(G11*J19)","v":0},{"$f":"(H11*K19)","v":0},0,0,0,0,0,0]
["Life Insurance",null,null,null,null,{"$f":"(F11*I20)","v":0},{"$f":"(G11*J20)","v":0},{"$f":"(H11*K20)","v":0},0,0,0,0,0,0]
["Vacation",null,null,null,null,{"$f":"(F11*I21)","v":0},{"$f":"(G11*J21)","v":0},{"$f":"(H11*K21)","v":0},0,0,0,0,0,0]
["Sick Leave",null,null,null,null,{"$f":"(F11*I22)","v":0},{"$f":"(G11*J22)","v":0},{"$f":"(H11*K22)","v":0},0,0,0,0,0,0]
["Retirement",null,null,null,null,{"$f":"(F11*I23)","v":0},{"$f":"(G11*J23)","v":0},{"$f":"(H11*K23)","v":0},0,0,0,0,0,0]
["Worker's Compensation",null,null,null,null,{"$f":"(F11*I24)","v":0},{"$f":"(G11*J24)","v":0},{"$f":"(H11*K24)","v":0},0,0,0,0,0,0]
["Unemployment Insurance",null,null,null,null,{"$f":"(F11*I25)","v":0},{"$f":"(G11*J25)","v":0},{"$f":"(H11*K25)","v":0},0,0,0,0,0,0]
["Other (Please specify in Narrative field below)",null,null,null,null,{"$f":"(F11*I26)","v":0},{"$f":"(G11*J26)","v":0},{"$f":"(H11*K26)","v":0},0,0,0,0,0,0]
["Number of Positions:",null,{"$f":"E11","v":0},null,"Total Fringe (All Positions)",null,null,null,null,null,null,{"$f":"SUM(L17:L26)*C27","v":0},{"$f":"SUM(M17:M26)*C27","v":0},{"$f":"SUM(L27-M27)","v":0},null,null,null,{"$f":"L27","v":0},null,{"$f":"M27","v":0}]
["Narrative"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Total"]
["Personnel Salary Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q11:Q173)","v":0},{"$f":"SUM(S11:S173)","v":0},{"$f":"SUM(SalaryTotal-LocalSalaryTotal)","v":0}]
["Personnel Fringe Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R27:R173)","v":0},{"$f":"SUM(T11:T173)","v":0},{"$f":"SUM(FringeTotal-LocalFringeTotal)","v":0}]
["Personnel Grand Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(SalaryTotal+FringeTotal)","v":0},{"$f":"SUM(LocalSalaryTotal+LocalFringeTotal)","v":0},{"$f":"SUM(PersonnelTotal-LocalGrandTotal)","v":0}]
[]
["C. Travel"]
["Event Title",null,null,null,"Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,null,null,"Indicate the location of the event",null,"Registration, Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,"Location",null,"Type of Expense",null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,"Type of Expense"]
[null,null,null,null,null,null,"Registration:",null,null,null,null,{"$f":"SUM(I42:I45)*K42","v":0},0,{"$f":"IF(L42-M42<0,0,L42-M42)","v":0}]
[null,null,null,null,null,null,"Transportation:"]
[null,null,null,null,null,null,"Lodging:"]
[null,null,null,null,null,null,"Per Diem:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L42:L48)","v":0},{"$f":"SUM(M42:M48)","v":0},{"$f":"SUM(L49-M49)","v":0}]
["Travel Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,null,null,"# of Items",null,null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEILING(F58*I58,1)","v":0},0,{"$f":"IF(L58-M58<0,0,L58-M58)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58:L61)","v":0},{"$f":"SUM(M58:M61)","v":0},{"$f":"SUM(L62-M62)","v":0}]
["Equipment Narrative"]
[]
[]
[]
["E. Supplies"]
["Supply Items",null,null,null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,null,null,"# of Items",null,null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEILING(F72*I72,1)","v":0},null,{"$f":"IF(L72-M72<0,0,L72-M72)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L72:L75)","v":0},{"$f":"SUM(M72:M75)","v":0},{"$f":"SUM(L76-M76)","v":0}]
["Supplies Narrative"]
[]
[]
["F. Construction"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,null,"Consultant?",null,null,null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,null,null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L90-M90<0,0,L90-M90)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L92-M92<0,0,L92-M92)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L93-M93<0,0,L93-M93)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L90:L95)","v":0},{"$f":"SUM(M90:M95)","v":0},{"$f":"SUM(L96-M96)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,null,null,"Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,null,null,"Indicate the location of the event",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,"Registration:",null,null,null,null,{"$f":"SUM(I107:I110)*K107","v":0},0,{"$f":"IF(L107-M110<0,0,L107-M110)","v":0}]
[null,null,null,null,null,null,"Transportation:"]
[null,null,null,null,null,null,"Lodging:"]
[null,null,null,null,null,null,"Per Diem:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I112:I112)*K112","v":0},0,{"$f":"IF(L112-M112<0,0,L112-M112)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L107:L114)","v":0},{"$f":"SUM(M107:M114)","v":0},{"$f":"SUM(L115-M115)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,null,"Consultant?",null,null,null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,null,null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L124-M124<0,0,L124-M124)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L125-M125<0,0,L125-M125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L126-M126<0,0,L126-M126)","v":0}]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L124:L126)","v":0},{"$f":"SUM(M124:M126)","v":0},{"$f":"SUM(L127-M127)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,null,null,"Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,null,null,"Indicate the location of the event",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I136:I136)*K136","v":0},0,{"$f":"IF(L136-M136<0,0,L136-M136)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L136:L137)","v":0},{"$f":"SUM(M136:M137)","v":0},{"$f":"SUM(L138-M138)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L143-M143<0,0,L143-M143)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L145-M145<0,0,L145-M145)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L143:L147)","v":0},{"$f":"SUM(M143:M147)","v":0},{"$f":"SUM(L148-M148)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,null,null,null,null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,null,null,null,null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,null,null,"Base",null,null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEILING(F156*I156,1)","v":0},0,{"$f":"IF(L156-M156<0,0,L156-M156)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L156:L159)","v":0},{"$f":"SUM(M156:M159)","v":0},{"$f":"SUM(L160-M160)","v":0}]
["Indirect Costs Narrative"]
[]
["Summary Totals"]
[null,null,"Project Total","Non-Federal Total",null,null,"Federal Total"]
["A. Personnel Salary",null,{"$f":"SalaryTotal","v":0},{"$f":"LocalSalaryTotal","v":0},null,null,{"$f":"SalaryGrandTotal","v":0}]
["B. Personnel Fringe",null,{"$f":"FringeTotal","v":0},{"$f":"LocalFringeTotal","v":0},null,null,{"$f":"FringeGrandTotal","v":0}]
["C. Travel",null,{"$f":"TravelTotal","v":0},{"$f":"TravelLocalTotal","v":0},null,null,{"$f":"TravelFederalTotal","v":0}]
["D. Equipment",null,{"$f":"EquipmentTotal","v":0},{"$f":"EquipmentLocalTotal","v":0},null,null,{"$f":"EquipmentFederalTotal","v":0}]
["E. Supplies",null,{"$f":"SuppliesTotal","v":0},{"$f":"SuppliesLocalTotal","v":0},null,null,{"$f":"SuppliesFederalTotal","v":0}]
["G. Consultants/Contracts",null,{"$f":"ContractsItemTotal+ConsultantFeesTotal+ContractsTravelTotal+CunsultantExpensesTotal","v":{"$error":"#REF!"}},{"$f":"ContractsItemLocalTotal+ConsultantFeesLocalTotal+ContractsTravelLocalTotal+ConsultantExpensesLocalTotal","v":{"$error":"#REF!"}},null,null,{"$f":"ContractsItemFederalTotal+ConsultantFeesFederalTotal+ContractsTravelFederalTotal+ConsultantExpensesFederalTotal","v":{"$error":"#REF!"}}]
["H. Other Costs",null,{"$f":"OtherTotal","v":0},{"$f":"OtherLocalTotal","v":0},null,null,{"$f":"OtherFederalTotal","v":0}]
["I. Indirect Costs",null,{"$f":"IndirectTotal","v":0},{"$f":"IndirectLocalTotal","v":0},null,null,{"$f":"IndirectFederalTotal","v":0}]
["Totals",null,{"$f":"SUM(C165:C172)","v":{"$error":"#REF!"}},{"$f":"SUM(D165:F172)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G165:H172)","v":{"$error":"#REF!"}}]

{"sheet":"PA2","index":3,"n_rows":161,"n_cols":14,"rows_kept":161,"cut":false,"hidden":false,"merged":[[35,3,35,4],[36,0,36,7],[38,0,39,10],[6,2,6,10],[5,2,5,10],[19,5,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,0,20,2],[18,0,18,2],[17,0,17,2],[9,0,9,1],[9,5,9,6],[11,0,11,1],[11,5,11,6],[12,0,12,7],[14,0,15,10],[17,3,17,10],[18,3,18,10],[19,3,20,4],[21,0,21,2],[21,3,21,4],[24,0,24,7],[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,2,8,2],[21,5,21,7],[23,0,23,1],[23,3,23,4],[23,5,23,7],[33,3,33,4],[33,1,33,2],[26,0,27,10],[29,3,29,4],[29,5,29,10],[30,3,30,4],[30,5,30,10],[31,10,32,10],[31,8,32,8],[31,9,32,9],[29,1,29,2],[31,0,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[30,1,30,2],[42,3,42,10],[43,3,44,4],[43,5,44,7],[43,8,44,8],[43,9,44,9],[45,0,45,2],[43,0,44,2],[42,0,42,2],[41,0,41,2],[41,3,41,10],[43,10,44,10],[45,3,45,4],[45,5,45,7],[48,0,48,7],[50,0,51,10],[53,3,53,10],[55,0,56,2],[53,0,53,2],[54,0,54,2],[47,0,47,1],[47,3,47,4],[47,5,47,7],[57,3,57,4],[57,5,57,7],[59,0,59,1],[59,3,59,4],[59,5,59,7],[57,0,57,2],[54,3,54,10],[55,3,56,4],[55,5,56,7],[55,8,56,8],[55,9,56,9],[55,10,56,10],[58,0,58,2],[58,3,58,4],[58,5,58,7],[67,3,68,4],[67,5,68,7],[67,0,68,2],[70,0,70,2],[67,8,68,8],[69,0,69,2],[67,9,68,9],[67,10,68,10],[60,0,60,7],[62,0,63,10],[65,3,65,10],[66,3,66,10],[66,0,66,2],[65,0,65,2],[69,3,69,4],[69,5,69,7],[70,3,70,4],[70,5,70,7],[96,3,96,4],[97,3,98,4],[88,0,88,7],[93,0,93,10],[86,0,86,2],[86,3,86,6],[86,7,86,10],[87,0,87,2],[87,3,87,6],[87,7,87,10],[89,0,89,13],[90,0,90,13],[92,0,92,10],[95,0,95,1],[71,0,71,7],[73,0,74,10],[76,0,76,10],[77,0,77,10],[78,0,78,2],[78,6,78,7],[79,6,79,7],[94,0,94,10],[95,3,95,4],[109,3,109,5],[109,6,109,7],[109,8,109,10],[110,0,111,7],[113,3,113,5],[113,6,113,7],[100,3,100,4],[104,0,104,13],[105,0,105,3],[108,0,108,2],[108,3,108,5],[108,6,108,7],[108,8,108,10],[109,0,109,2],[100,0,100,1],[116,0,116,10],[117,0,117,10],[118,0,118,10],[119,0,119,1],[119,3,119,4],[119,5,119,10],[110,8,111,8],[110,9,111,9],[110,10,111,10],[112,0,112,2],[112,3,112,6],[112,7,112,10],[113,0,113,2],[127,0,127,10],[128,0,128,10],[132,0,132,7],[121,8,122,8],[121,9,122,9],[121,10,122,10],[120,0,120,1],[120,3,120,4],[120,5,120,10],[121,0,122,1],[121,2,122,2],[121,3,122,4],[121,5,122,5],[121,6,122,6],[121,7,122,7],[151,6,151,7],[143,0,143,2],[143,3,143,4],[149,0,149,10],[138,0,138,13],[142,5,142,7],[147,0,147,7],[135,0,135,7],[137,0,137,10],[140,0,140,2],[141,0,141,2],[140,3,140,10],[141,3,141,10],[142,1,142,2],[142,3,142,4],[159,0,159,1],[159,3,159,5],[159,6,159,7],[160,0,160,1],[160,3,160,5],[160,6,160,7],[155,0,155,1],[155,3,155,5],[155,6,155,7],[156,0,156,1],[156,3,156,5],[156,6,156,7],[157,0,157,1],[157,3,157,5],[157,6,157,7],[78,3,78,5],[78,8,78,10],[79,8,79,10],[85,3,85,5],[97,7,98,7],[97,8,98,8],[97,9,98,9],[97,10,98,10],[158,0,158,1],[158,3,158,5],[158,6,158,7],[152,0,152,1],[152,3,152,5],[152,6,152,7],[153,0,153,1],[153,3,153,5],[153,6,153,7],[154,0,154,1],[154,3,154,5],[154,6,154,7],[143,5,143,7],[150,0,150,7],[151,0,151,1],[151,3,151,5],[83,7,83,10],[84,0,84,2],[84,3,84,6],[84,7,84,10],[85,0,85,2],[79,0,79,2],[80,8,81,8],[85,6,85,7],[79,3,79,5],[80,9,81,9],[80,10,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[123,0,123,1],[123,3,123,4],[125,0,125,7],[114,0,114,7],[10,0,10,1],[10,5,10,6],[22,0,22,2],[22,3,22,4],[22,5,22,7],[34,1,34,2],[34,3,34,4],[46,0,46,2],[46,3,46,4],[46,5,46,7],[96,0,96,1],[95,5,95,10],[96,5,96,10],[97,5,98,5],[97,6,98,6],[103,0,103,7],[106,0,106,10],[107,0,107,10],[83,0,83,2],[83,3,83,6]]}
[{"$f":"'Budget Sheet Instructions'!B17","v":"Comprehensive Tribal Justice Systems Strategic Planning"},null,null,null,null,null,null,"Purpose Area (2)"]
["Program Office",null,null,null,null,null,null,null,null,"16.608"]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C11*D11*F11*H11,1)","v":0},null,{"$f":"IF(I11-J11<0,0,I11-J11)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D12*F12*H12,1)","v":0},null,{"$f":"IF(I12-J12<0,0,I12-J12)","v":0}]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I12)","v":0},{"$f":"SUM(J10:J12)","v":0},{"$f":"SUM(K10:K12)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(I22-J22<0,0,I22-J22)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D23*F23,1)","v":0},null,{"$f":"IF(I23-J23<0,0,I23-J23)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I22:I24)","v":0},{"$f":"SUM(J22:J24)","v":0},{"$f":"SUM(K22:K24)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F34*G34*H34,1)","v":0},null,{"$f":"IF(I34-J34<0,0,I34-J34)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F35*G35*H35,1)","v":0},null,{"$f":"IF(I35-J35<0,0,I35-J35)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I34:I36)","v":0},{"$f":"SUM(J34:J36)","v":0},{"$f":"SUM(K34:K36)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D46*F46,1)","v":0},null,{"$f":"IF(I46-J46<0,0,I46-J46)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D47*F47,1)","v":0},null,{"$f":"IF(I47-J47<0,0,I47-J47)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D48*F48,1)","v":0},null,{"$f":"IF(I48-J48<0,0,I48-J48)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I46:I48)","v":0},{"$f":"SUM(J46:J48)","v":0},{"$f":"SUM(K46:K48)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D58*F58,1)","v":0},null,{"$f":"IF(I58-J58<0,0,I58-J58)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D59*F59,1)","v":0},null,{"$f":"IF(I59-J59<0,0,I59-J59)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I58:I60)","v":0},{"$f":"SUM(J58:J60)","v":0},{"$f":"SUM(K58:K60)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D70*F70,1)","v":0},null,{"$f":"IF(I70-J70<0,0,I70-J70)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D71*F71,1)","v":0},null,{"$f":"IF(I71-J71<0,0,I71-J71)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I70:I71)","v":0},{"$f":"SUM(J70:J71)","v":0},{"$f":"SUM(K70:K71)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L83-M83<0,0,L83-M83)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L85-M85<0,0,L85-M85)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I86-J86<0,0,I86-J86)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I83:I88)","v":0},{"$f":"SUM(J83:J88)","v":0},{"$f":"SUM(I89-J89)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F101:F101)*H101","v":0},0,{"$f":"IF(I101-J101<0,0,I101-J101)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I101:I103)","v":0},{"$f":"SUM(J101:J103)","v":0},{"$f":"SUM(I104-J104)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L113-M113<0,0,L113-M113)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I114-J114<0,0,I114-J114)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I113:I114)","v":0},{"$f":"SUM(J113:M114)","v":0},{"$f":"SUM(I115-J115)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F124*G124)*H124","v":0},0,{"$f":"IF(I124-J124<0,0,I124-J124)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I125:I125)","v":0},{"$f":"SUM(J125:J125)","v":0},{"$f":"SUM(I126-J126)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I131-J131<0,0,I131-J131)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I133-J133<0,0,I133-J133)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I134:I135)","v":0},{"$f":"SUM(J134:J135)","v":0},{"$f":"SUM(I136-J136)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C144*F144,1)","v":0},0,{"$f":"IF(I144-J144<0,0,I144-J144)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I147:I147)","v":0},{"$f":"SUM(J147:J147)","v":0},{"$f":"SUM(I148-J148)","v":0}]
["Indirect Costs Narrative"]
[]
["Summary Totals"]
[null,null,"Project Total","Non-Federal Total",null,null,"Federal Total"]
["A. Personnel Salary",null,{"$f":"SalaryTotal","v":0},{"$f":"LocalSalaryTotal","v":0},null,null,{"$f":"SalaryGrandTotal","v":0}]
["B. Personnel Fringe",null,{"$f":"FringeTotal","v":0},{"$f":"LocalFringeTotal","v":0},null,null,{"$f":"FringeGrandTotal","v":0}]
["C. Travel",null,{"$f":"TravelTotal","v":0},{"$f":"TravelLocalTotal","v":0},null,null,{"$f":"TravelFederalTotal","v":0}]
["D. Equipment",null,{"$f":"EquipmentTotal","v":0},{"$f":"EquipmentLocalTotal","v":0},null,null,{"$f":"EquipmentFederalTotal","v":0}]
["E. Supplies",null,{"$f":"SuppliesTotal","v":0},{"$f":"SuppliesLocalTotal","v":0},null,null,{"$f":"SuppliesFederalTotal","v":0}]
["G. Consultants/Contracts",null,{"$f":"ContractsItemTotal+ConsultantFeesTotal+ContractsTravelTotal+CunsultantExpensesTotal","v":{"$error":"#REF!"}},{"$f":"ContractsItemLocalTotal+ConsultantFeesLocalTotal+ContractsTravelLocalTotal+ConsultantExpensesLocalTotal","v":{"$error":"#REF!"}},null,null,{"$f":"ContractsItemFederalTotal+ConsultantFeesFederalTotal+ContractsTravelFederalTotal+ConsultantExpensesFederalTotal","v":{"$error":"#REF!"}}]
["H. Other Costs",null,{"$f":"OtherTotal","v":0},{"$f":"OtherLocalTotal","v":0},null,null,{"$f":"OtherFederalTotal","v":0}]
["I. Indirect Costs",null,{"$f":"IndirectTotal","v":0},{"$f":"IndirectLocalTotal","v":0},null,null,{"$f":"IndirectFederalTotal","v":0}]
["Totals",null,{"$f":"SUM(C153:C160)","v":{"$error":"#REF!"}},{"$f":"SUM(D153:F160)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G153:H160)","v":{"$error":"#REF!"}}]

{"sheet":"PA3","index":4,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[7,10,8,10],[9,0,9,1],[9,5,9,6],[10,0,10,1],[10,5,10,6],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,2,8,2],[6,2,6,10],[5,2,5,10],[18,3,19,4],[18,5,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[13,0,14,10],[16,3,16,10],[17,3,17,10],[11,0,11,7],[17,0,17,2],[16,0,16,2],[18,0,19,2],[20,3,20,4],[20,5,20,7],[21,0,21,1],[21,3,21,4],[21,5,21,7],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[28,1,28,2],[20,0,20,2],[31,3,31,4],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[40,10,41,10],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[28,3,28,4],[28,5,28,10],[29,10,30,10],[29,8,30,8],[29,9,30,9],[31,1,31,2],[27,1,27,2],[38,0,38,2],[42,3,42,4],[42,5,42,7],[43,0,43,1],[43,3,43,4],[43,5,43,7],[39,3,39,10],[40,3,41,4],[40,5,41,7],[40,8,41,8],[40,9,41,9],[42,0,42,2],[39,0,39,2],[40,0,41,2],[51,3,52,4],[51,5,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[44,0,44,7],[46,0,47,10],[49,3,49,10],[50,3,50,10],[51,0,52,2],[50,0,50,2],[49,0,49,2],[62,9,63,9],[62,10,63,10],[55,0,55,7],[57,0,58,10],[60,3,60,10],[61,3,61,10],[61,0,61,2],[60,0,60,2],[53,3,53,4],[53,5,53,7],[54,0,54,1],[54,3,54,4],[54,5,54,7],[53,0,53,2],[64,3,64,4],[64,5,64,7],[65,3,65,4],[65,5,65,7],[62,3,63,4],[62,5,63,7],[65,0,65,2],[62,0,63,2],[62,8,63,8],[64,0,64,2],[79,0,79,2],[79,3,79,6],[79,7,79,10],[80,0,80,2],[80,3,80,5],[80,6,80,7],[81,0,81,2],[66,0,66,7],[68,0,69,10],[75,8,76,8],[75,9,76,9],[75,10,76,10],[77,0,77,2],[77,3,77,6],[77,7,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[104,0,104,2],[104,3,104,5],[104,6,104,7],[104,8,104,10],[105,0,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[107,0,107,2],[107,3,107,6],[107,7,107,10],[71,0,71,10],[72,0,72,10],[73,0,73,2],[73,3,73,5],[73,6,73,7],[73,8,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[81,3,81,6],[81,7,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[90,5,90,10],[91,0,91,1],[91,3,91,4],[91,5,91,10],[83,0,83,7],[88,0,88,10],[89,0,89,10],[84,0,84,13],[85,0,85,13],[87,0,87,10],[90,0,90,1],[90,3,90,4],[92,3,93,4],[92,5,93,5],[92,6,93,6],[92,7,93,7],[92,8,93,8],[92,9,93,9],[92,10,93,10],[95,0,95,1],[95,3,95,4],[98,0,98,7],[99,0,99,13],[100,0,100,3],[101,0,101,10],[102,0,102,10],[103,3,103,5],[103,6,103,7],[103,8,103,10],[103,0,103,2],[108,0,108,2],[108,3,108,5],[108,6,108,7],[109,0,109,7],[111,0,111,10],[112,0,112,10],[113,0,113,10],[114,0,114,1],[114,3,114,4],[114,5,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,117,1],[116,2,117,2],[116,3,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[116,8,117,8],[116,9,117,9],[116,10,117,10],[118,0,118,1],[118,3,118,4],[120,0,120,7],[122,0,122,10],[123,0,123,10],[130,0,130,7],[132,0,132,10],[133,0,133,13],[135,0,135,2],[135,3,135,10],[136,0,136,2],[136,3,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,7],[138,0,138,2],[138,3,138,4],[138,5,138,7],[144,0,144,10],[142,0,142,7]]}
[{"$f":"'Budget Sheet Instructions'!B18","v":"Justice Systems and Alcohol and Substance Abuse"},null,null,null,null,null,null,"Purpose Area (3)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J18","v":"BJA"},{"$f":"'Budget Sheet Instructions'!K18","v":"16.608"}]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,{"$f":"IF(I11-J11<0,0,I11-J11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(I22-J22<0,0,I22-J22)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F33*G33*H33,1)","v":0},null,{"$f":"IF(I33-J33<0,0,I33-J33)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D44*F44,1)","v":0},null,{"$f":"IF(I44-J44<0,0,I44-J44)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L78-M78<0,0,L78-M78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L80-M80<0,0,L80-M80)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I81-J81<0,0,I81-J81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},{"$f":"SUM(I84-J84)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F96:F96)*H96","v":0},0,{"$f":"IF(I96-J96<0,0,I96-J96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I96:I98)","v":0},{"$f":"SUM(J96:J98)","v":0},{"$f":"SUM(I99-J99)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L108-M108<0,0,L108-M108)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I109-J109<0,0,I109-J109)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I108:I109)","v":0},{"$f":"SUM(J108:M109)","v":0},{"$f":"SUM(I110-J110)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F119*G119)*H119","v":0},0,{"$f":"IF(I119-J119<0,0,I119-J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I120:I120)","v":0},{"$f":"SUM(J120:J120)","v":0},{"$f":"SUM(I121-J121)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I126-J126<0,0,I126-J126)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I128-J128<0,0,I128-J128)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},{"$f":"SUM(J129:J130)","v":0},{"$f":"SUM(I131-J131)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C139*F139,1)","v":0},0,{"$f":"IF(I139-J139<0,0,I139-J139)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I142:I142)","v":0},{"$f":"SUM(J142:J142)","v":0},{"$f":"SUM(I143-J143)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"PA4","index":5,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[7,10,8,10],[9,0,9,1],[9,5,9,6],[10,0,10,1],[10,5,10,6],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,2,8,2],[6,2,6,10],[5,2,5,10],[18,3,19,4],[18,5,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[13,0,14,10],[16,3,16,10],[17,3,17,10],[11,0,11,7],[17,0,17,2],[16,0,16,2],[18,0,19,2],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[28,3,28,4],[28,5,28,10],[29,10,30,10],[20,3,20,4],[20,5,20,7],[21,0,21,1],[21,3,21,4],[21,5,21,7],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[29,9,30,9],[28,1,28,2],[20,0,20,2],[27,1,27,2],[39,3,39,10],[40,3,41,4],[40,5,41,7],[40,8,41,8],[40,9,41,9],[31,3,31,4],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[40,10,41,10],[31,1,31,2],[39,0,39,2],[38,0,38,2],[40,0,41,2],[51,8,52,8],[51,9,52,9],[51,10,52,10],[44,0,44,7],[46,0,47,10],[49,3,49,10],[50,3,50,10],[42,3,42,4],[42,5,42,7],[43,0,43,1],[43,3,43,4],[43,5,43,7],[42,0,42,2],[50,0,50,2],[49,0,49,2],[53,3,53,4],[53,5,53,7],[54,0,54,1],[54,3,54,4],[54,5,54,7],[51,3,52,4],[51,5,52,7],[53,0,53,2],[51,0,52,2],[62,9,63,9],[62,10,63,10],[55,0,55,7],[57,0,58,10],[60,3,60,10],[61,3,61,10],[62,0,63,2],[61,0,61,2],[60,0,60,2],[64,3,64,4],[64,5,64,7],[65,0,65,1],[65,3,65,4],[65,5,65,7],[62,3,63,4],[62,5,63,7],[64,0,64,2],[62,8,63,8],[79,0,79,2],[79,3,79,6],[79,7,79,10],[80,0,80,2],[80,3,80,5],[80,6,80,7],[81,0,81,2],[66,0,66,7],[68,0,69,10],[75,8,76,8],[75,9,76,9],[75,10,76,10],[77,0,77,2],[77,3,77,6],[77,7,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[104,0,104,2],[104,3,104,5],[104,6,104,7],[104,8,104,10],[105,0,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[107,0,107,2],[107,3,107,6],[107,7,107,10],[71,0,71,10],[72,0,72,10],[73,0,73,2],[73,3,73,5],[73,6,73,7],[73,8,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[81,3,81,6],[81,7,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[90,5,90,10],[91,0,91,1],[91,3,91,4],[91,5,91,10],[83,0,83,7],[88,0,88,10],[89,0,89,10],[84,0,84,13],[85,0,85,13],[87,0,87,10],[90,0,90,1],[90,3,90,4],[92,3,93,4],[92,5,93,5],[92,6,93,6],[92,7,93,7],[92,8,93,8],[92,9,93,9],[92,10,93,10],[95,0,95,1],[95,3,95,4],[98,0,98,7],[99,0,99,13],[100,0,100,3],[101,0,101,10],[102,0,102,10],[103,3,103,5],[103,6,103,7],[103,8,103,10],[103,0,103,2],[108,0,108,2],[108,3,108,5],[108,6,108,7],[109,0,109,7],[111,0,111,10],[112,0,112,10],[113,0,113,10],[114,0,114,1],[114,3,114,4],[114,5,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,117,1],[116,2,117,2],[116,3,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[116,8,117,8],[116,9,117,9],[116,10,117,10],[118,0,118,1],[118,3,118,4],[120,0,120,7],[122,0,122,10],[123,0,123,10],[130,0,130,7],[132,0,132,10],[133,0,133,13],[135,0,135,2],[135,3,135,10],[136,0,136,2],[136,3,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,7],[138,0,138,2],[138,3,138,4],[138,5,138,7],[144,0,144,10],[142,0,142,7]]}
[{"$f":"'Budget Sheet Instructions'!B19","v":"Tribal Justice System Infrastructure Program"},null,null,null,null,null,null,"Purpose Area (4)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J19","v":"BJA"},{"$f":"'Budget Sheet Instructions'!K19","v":"16.596"}]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,{"$f":"IF(I11-J11<0,0,I11-J11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(I22-J22<0,0,I22-J22)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F33*G33*H33,1)","v":0},null,{"$f":"IF(I33-J33<0,0,I33-J33)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D44*F44,1)","v":0},null,{"$f":"IF(I44-J44<0,0,I44-J44)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L78-M78<0,0,L78-M78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L80-M80<0,0,L80-M80)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I81-J81<0,0,I81-J81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},{"$f":"SUM(I84-J84)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F96:F96)*H96","v":0},0,{"$f":"IF(I96-J96<0,0,I96-J96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I96:I98)","v":0},{"$f":"SUM(J96:J98)","v":0},{"$f":"SUM(I99-J99)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L108-M108<0,0,L108-M108)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I109-J109<0,0,I109-J109)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I108:I109)","v":0},{"$f":"SUM(J108:M109)","v":0},{"$f":"SUM(I110-J110)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F119*G119)*H119","v":0},0,{"$f":"IF(I119-J119<0,0,I119-J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I120:I120)","v":0},{"$f":"SUM(J120:J120)","v":0},{"$f":"SUM(I121-J121)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I126-J126<0,0,I126-J126)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I128-J128<0,0,I128-J128)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},{"$f":"SUM(J129:J130)","v":0},{"$f":"SUM(I131-J131)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C139*F139,1)","v":0},0,{"$f":"IF(I139-J139<0,0,I139-J139)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I142:I142)","v":0},{"$f":"SUM(J142:J142)","v":0},{"$f":"SUM(I143-J143)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"PA5","index":6,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[7,10,8,10],[9,0,9,1],[9,5,9,6],[10,0,10,1],[10,5,10,6],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,2,8,2],[6,2,6,10],[5,2,5,10],[18,3,19,4],[18,5,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[13,0,14,10],[16,3,16,10],[17,3,17,10],[11,0,11,7],[17,0,17,2],[16,0,16,2],[18,0,19,2],[20,3,20,4],[20,5,20,7],[21,0,21,1],[21,3,21,4],[21,5,21,7],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[28,1,28,2],[20,0,20,2],[31,3,31,4],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[40,10,41,10],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[28,3,28,4],[28,5,28,10],[29,10,30,10],[29,8,30,8],[29,9,30,9],[31,1,31,2],[27,1,27,2],[38,0,38,2],[42,3,42,4],[42,5,42,7],[43,0,43,1],[43,3,43,4],[43,5,43,7],[39,3,39,10],[40,3,41,4],[40,5,41,7],[40,8,41,8],[40,9,41,9],[42,0,42,2],[39,0,39,2],[40,0,41,2],[51,3,52,4],[51,5,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[44,0,44,7],[46,0,47,10],[49,3,49,10],[50,3,50,10],[50,0,50,2],[49,0,49,2],[51,0,52,2],[62,9,63,9],[62,10,63,10],[55,0,55,7],[57,0,58,10],[60,3,60,10],[61,3,61,10],[61,0,61,2],[60,0,60,2],[53,3,53,4],[53,5,53,7],[54,0,54,1],[54,3,54,4],[54,5,54,7],[53,0,53,2],[64,3,64,4],[64,5,64,7],[65,3,65,4],[65,5,65,7],[62,3,63,4],[62,5,63,7],[62,0,63,2],[65,0,65,2],[62,8,63,8],[64,0,64,2],[79,0,79,2],[79,3,79,6],[79,7,79,10],[80,0,80,2],[80,3,80,5],[80,6,80,7],[81,0,81,2],[66,0,66,7],[68,0,69,10],[75,8,76,8],[75,9,76,9],[75,10,76,10],[77,0,77,2],[77,3,77,6],[77,7,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[104,0,104,2],[104,3,104,5],[104,6,104,7],[104,8,104,10],[105,0,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[107,0,107,2],[107,3,107,6],[107,7,107,10],[71,0,71,10],[72,0,72,10],[73,0,73,2],[73,3,73,5],[73,6,73,7],[73,8,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[81,3,81,6],[81,7,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[90,5,90,10],[91,0,91,1],[91,3,91,4],[91,5,91,10],[83,0,83,7],[88,0,88,10],[89,0,89,10],[84,0,84,13],[85,0,85,13],[87,0,87,10],[90,0,90,1],[90,3,90,4],[92,3,93,4],[92,5,93,5],[92,6,93,6],[92,7,93,7],[92,8,93,8],[92,9,93,9],[92,10,93,10],[95,0,95,1],[95,3,95,4],[98,0,98,7],[99,0,99,13],[100,0,100,3],[101,0,101,10],[102,0,102,10],[103,3,103,5],[103,6,103,7],[103,8,103,10],[103,0,103,2],[108,0,108,2],[108,3,108,5],[108,6,108,7],[109,0,109,7],[111,0,111,10],[112,0,112,10],[113,0,113,10],[114,0,114,1],[114,3,114,4],[114,5,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,117,1],[116,2,117,2],[116,3,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[116,8,117,8],[116,9,117,9],[116,10,117,10],[118,0,118,1],[118,3,118,4],[120,0,120,7],[122,0,122,10],[123,0,123,10],[130,0,130,7],[132,0,132,10],[133,0,133,13],[135,0,135,2],[135,3,135,10],[136,0,136,2],[136,3,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,7],[138,0,138,2],[138,3,138,4],[138,5,138,7],[144,0,144,10],[142,0,142,7]]}
[{"$f":"'Budget Sheet Instructions'!B20","v":"Office on Violence Against Women Tribal Governments Program"},null,null,null,null,null,null,"Purpose Area (5)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J20","v":"OVW"},{"$f":"'Budget Sheet Instructions'!K20","v":"16.587"}]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,{"$f":"IF(I11-J11<0,0,I11-J11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(I22-J22<0,0,I22-J22)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F33*G33*H33,1)","v":0},null,{"$f":"IF(I33-J33<0,0,I33-J33)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D44*F44,1)","v":0},null,{"$f":"IF(I44-J44<0,0,I44-J44)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L78-M78<0,0,L78-M78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L80-M80<0,0,L80-M80)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I81-J81<0,0,I81-J81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},{"$f":"SUM(I84-J84)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F96:F96)*H96","v":0},0,{"$f":"IF(I96-J96<0,0,I96-J96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I96:I98)","v":0},{"$f":"SUM(J96:J98)","v":0},{"$f":"SUM(I99-J99)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L108-M108<0,0,L108-M108)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I109-J109<0,0,I109-J109)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I108:I109)","v":0},{"$f":"SUM(J108:M109)","v":0},{"$f":"SUM(I110-J110)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F119*G119)*H119","v":0},0,{"$f":"IF(I119-J119<0,0,I119-J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I120:I120)","v":0},{"$f":"SUM(J120:J120)","v":0},{"$f":"SUM(I121-J121)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I126-J126<0,0,I126-J126)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I128-J128<0,0,I128-J128)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},{"$f":"SUM(J129:J130)","v":0},{"$f":"SUM(I131-J131)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C139*F139,1)","v":0},0,{"$f":"IF(I139-J139<0,0,I139-J139)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I142:I142)","v":0},{"$f":"SUM(J142:J142)","v":0},{"$f":"SUM(I143-J143)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"PA6","index":7,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[101,0,101,10],[102,0,102,10],[103,0,103,2],[103,3,103,5],[103,6,103,7],[103,8,103,10],[104,0,104,2],[104,3,104,5],[104,6,104,7],[104,8,104,10],[84,0,84,13],[85,0,85,13],[88,0,88,10],[89,0,89,10],[95,0,95,1],[95,3,95,4],[98,0,98,7],[99,0,99,13],[100,0,100,3],[87,0,87,10],[90,0,90,1],[90,3,90,4],[90,5,90,10],[91,0,91,1],[91,3,91,4],[91,5,91,10],[92,3,93,4],[92,5,93,5],[92,6,93,6],[92,7,93,7],[92,8,93,8],[92,9,93,9],[92,10,93,10],[75,8,76,8],[75,9,76,9],[75,10,76,10],[77,0,77,2],[83,0,83,7],[81,0,81,2],[81,3,81,6],[81,7,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[77,3,77,6],[77,7,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[79,0,79,2],[79,3,79,6],[79,7,79,10],[80,0,80,2],[80,3,80,5],[80,6,80,7],[66,0,66,7],[68,0,69,10],[71,0,71,10],[72,0,72,10],[73,0,73,2],[73,3,73,5],[73,6,73,7],[73,8,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[61,0,61,2],[62,0,63,2],[65,0,65,2],[64,0,64,2],[64,3,64,4],[64,5,64,7],[65,3,65,4],[65,5,65,7],[61,3,61,10],[62,3,63,4],[62,5,63,7],[62,8,63,8],[62,9,63,9],[62,10,63,10],[54,0,54,1],[54,3,54,4],[54,5,54,7],[55,0,55,7],[57,0,58,10],[60,3,60,10],[53,3,53,4],[53,5,53,7],[60,0,60,2],[53,0,53,2],[42,0,42,2],[50,3,50,10],[51,3,52,4],[51,5,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[43,0,43,1],[43,3,43,4],[43,5,43,7],[44,0,44,7],[46,0,47,10],[49,3,49,10],[50,0,50,2],[49,0,49,2],[51,0,52,2],[42,3,42,4],[42,5,42,7],[40,8,41,8],[40,9,41,9],[40,10,41,10],[31,3,31,4],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[38,0,38,2],[31,1,31,2],[39,0,39,2],[39,3,39,10],[40,0,41,2],[40,3,41,4],[40,5,41,7],[28,3,28,4],[28,5,28,10],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[29,9,30,9],[29,10,30,10],[28,1,28,2],[21,0,21,1],[21,3,21,4],[21,5,21,7],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[20,3,20,4],[20,5,20,7],[27,1,27,2],[20,0,20,2],[26,1,26,10],[18,3,19,4],[18,5,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[11,0,11,7],[13,0,14,10],[16,3,16,10],[17,3,17,10],[17,0,17,2],[16,0,16,2],[18,0,19,2],[10,0,10,1],[10,5,10,6],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[6,2,6,10],[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[9,0,9,1],[9,5,9,6],[7,2,8,2],[5,2,5,10],[3,0,3,10],[105,10,106,10],[107,0,107,2],[107,3,107,6],[107,7,107,10],[108,0,108,2],[108,3,108,5],[108,6,108,7],[109,0,109,7],[111,0,111,10],[105,0,106,7],[105,8,106,8],[105,9,106,9],[112,0,112,10],[113,0,113,10],[114,0,114,1],[114,3,114,4],[114,5,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,117,1],[116,2,117,2],[116,3,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[116,8,117,8],[116,9,117,9],[116,10,117,10],[118,0,118,1],[118,3,118,4],[120,0,120,7],[122,0,122,10],[123,0,123,10],[130,0,130,7],[132,0,132,10],[133,0,133,13],[135,0,135,2],[135,3,135,10],[136,0,136,2],[136,3,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,7],[138,0,138,2],[138,3,138,4],[138,5,138,7],[144,0,144,10],[142,0,142,7]]}
[{"$f":"'Budget Sheet Instructions'!B21","v":"Children’s Justice Act Partnerships for Indian Communities"},null,null,null,null,null,null,"Purpose Area (6)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J21","v":"OVC"},{"$f":"'Budget Sheet Instructions'!K21","v":"16.582"}]
[]
["Note: No more than 50% of the request amount can be used salary and fringe benefits. Non-Federal match is not required for this purpose area but can be provided if desired. "]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,{"$f":"IF(I11-J11<0,0,I11-J11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(I22-J22<0,0,I22-J22)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel","All applicants are required to budget sufficient funds to pay for airfare, lodging, and per diem to send two staff members to: the CTAS Orientation; an OVC-sponsored regional grantee training; and one National Indian Nations Conference. Please base all estimated cost on traveling to Washington, DC for these events."]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F33*G33*H33,1)","v":0},null,{"$f":"IF(I33-J33<0,0,I33-J33)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D44*F44,1)","v":0},null,{"$f":"IF(I44-J44<0,0,I44-J44)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L78-M78<0,0,L78-M78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L80-M80<0,0,L80-M80)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I81-J81<0,0,I81-J81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},{"$f":"SUM(I84-J84)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F96:F96)*H96","v":0},0,{"$f":"IF(I96-J96<0,0,I96-J96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I96:I98)","v":0},{"$f":"SUM(J96:J98)","v":0},{"$f":"SUM(I99-J99)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L108-M108<0,0,L108-M108)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I109-J109<0,0,I109-J109)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I108:I109)","v":0},{"$f":"SUM(J108:M109)","v":0},{"$f":"SUM(I110-J110)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F119*G119)*H119","v":0},0,{"$f":"IF(I119-J119<0,0,I119-J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I120:I120)","v":0},{"$f":"SUM(J120:J120)","v":0},{"$f":"SUM(I121-J121)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I126-J126<0,0,I126-J126)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I128-J128<0,0,I128-J128)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},{"$f":"SUM(J129:J130)","v":0},{"$f":"SUM(I131-J131)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C139*F139,1)","v":0},0,{"$f":"IF(I139-J139<0,0,I139-J139)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I142:I142)","v":0},{"$f":"SUM(J142:J142)","v":0},{"$f":"SUM(I143-J143)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"PA7","index":8,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[7,10,8,10],[9,0,9,1],[9,5,9,6],[10,0,10,1],[10,5,10,6],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,2,8,2],[6,2,6,10],[5,2,5,10],[18,3,19,4],[18,5,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[13,0,14,10],[16,3,16,10],[17,3,17,10],[11,0,11,7],[18,0,19,2],[17,0,17,2],[16,0,16,2],[20,3,20,4],[20,5,20,7],[21,0,21,1],[21,3,21,4],[21,5,21,7],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[28,1,28,2],[20,0,20,2],[26,1,26,10],[31,3,31,4],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[40,10,41,10],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[28,3,28,4],[28,5,28,10],[29,10,30,10],[29,8,30,8],[29,9,30,9],[31,1,31,2],[27,1,27,2],[38,0,38,2],[42,3,42,4],[42,5,42,7],[43,0,43,1],[43,3,43,4],[43,5,43,7],[39,3,39,10],[40,3,41,4],[40,5,41,7],[40,8,41,8],[40,9,41,9],[42,0,42,2],[39,0,39,2],[40,0,41,2],[51,3,52,4],[51,5,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[44,0,44,7],[46,0,47,10],[49,3,49,10],[50,3,50,10],[50,0,50,2],[49,0,49,2],[51,0,52,2],[62,9,63,9],[62,10,63,10],[55,0,55,7],[57,0,58,10],[60,3,60,10],[61,3,61,10],[60,0,60,2],[61,0,61,2],[53,3,53,4],[53,5,53,7],[54,0,54,1],[54,3,54,4],[54,5,54,7],[53,0,53,2],[64,3,64,4],[64,5,64,7],[65,3,65,4],[65,5,65,7],[62,3,63,4],[62,5,63,7],[62,0,63,2],[65,0,65,2],[62,8,63,8],[64,0,64,2],[79,0,79,2],[79,3,79,6],[79,7,79,10],[80,0,80,2],[80,3,80,5],[80,6,80,7],[81,0,81,2],[66,0,66,7],[68,0,69,10],[75,8,76,8],[75,9,76,9],[75,10,76,10],[77,0,77,2],[77,3,77,6],[77,7,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[104,0,104,2],[104,3,104,5],[104,6,104,7],[104,8,104,10],[105,0,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[107,0,107,2],[107,3,107,6],[107,7,107,10],[71,0,71,10],[72,0,72,10],[73,0,73,2],[73,3,73,5],[73,6,73,7],[73,8,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[81,3,81,6],[81,7,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[90,5,90,10],[91,0,91,1],[91,3,91,4],[91,5,91,10],[83,0,83,7],[88,0,88,10],[89,0,89,10],[84,0,84,13],[85,0,85,13],[87,0,87,10],[90,0,90,1],[90,3,90,4],[92,3,93,4],[92,5,93,5],[92,6,93,6],[92,7,93,7],[92,8,93,8],[92,9,93,9],[92,10,93,10],[95,0,95,1],[95,3,95,4],[98,0,98,7],[99,0,99,13],[100,0,100,3],[101,0,101,10],[102,0,102,10],[103,3,103,5],[103,6,103,7],[103,8,103,10],[103,0,103,2],[108,0,108,2],[108,3,108,5],[108,6,108,7],[109,0,109,7],[111,0,111,10],[112,0,112,10],[113,0,113,10],[114,0,114,1],[114,3,114,4],[114,5,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,117,1],[116,2,117,2],[116,3,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[116,8,117,8],[116,9,117,9],[116,10,117,10],[118,0,118,1],[118,3,118,4],[120,0,120,7],[122,0,122,10],[123,0,123,10],[130,0,130,7],[132,0,132,10],[133,0,133,13],[135,0,135,2],[135,3,135,10],[136,0,136,2],[136,3,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,7],[138,0,138,2],[138,3,138,4],[138,5,138,7],[144,0,144,10],[142,0,142,7]]}
[{"$f":"'Budget Sheet Instructions'!B22","v":"Comprehensive Tribal Victim Assistance Program "},null,null,null,null,null,null,"Purpose Area (7)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J22","v":"OVC"},{"$f":"'Budget Sheet Instructions'!K22","v":"16.582"}]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,{"$f":"IF(I11-J11<0,0,I11-J11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(I22-J22<0,0,I22-J22)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel","All applicants are required to budget sufficient funds to pay for airfare, lodging, and per diem to send two staff members to: the CTAS Orientation; an OVC-sponsored regional grantee training; and one National Indian Nations Conference. Please base all estimated cost on traveling to Washington, DC for these events."]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F33*G33*H33,1)","v":0},null,{"$f":"IF(I33-J33<0,0,I33-J33)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D44*F44,1)","v":0},null,{"$f":"IF(I44-J44<0,0,I44-J44)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L78-M78<0,0,L78-M78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L80-M80<0,0,L80-M80)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I81-J81<0,0,I81-J81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},{"$f":"SUM(I84-J84)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F96:F96)*H96","v":0},0,{"$f":"IF(I96-J96<0,0,I96-J96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I96:I98)","v":0},{"$f":"SUM(J96:J98)","v":0},{"$f":"SUM(I99-J99)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L108-M108<0,0,L108-M108)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I109-J109<0,0,I109-J109)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I108:I109)","v":0},{"$f":"SUM(J108:M109)","v":0},{"$f":"SUM(I110-J110)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F119*G119)*H119","v":0},0,{"$f":"IF(I119-J119<0,0,I119-J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I120:I120)","v":0},{"$f":"SUM(J120:J120)","v":0},{"$f":"SUM(I121-J121)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I126-J126<0,0,I126-J126)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I128-J128<0,0,I128-J128)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},{"$f":"SUM(J129:J130)","v":0},{"$f":"SUM(I131-J131)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C139*F139,1)","v":0},0,{"$f":"IF(I139-J139<0,0,I139-J139)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I142:I142)","v":0},{"$f":"SUM(J142:J142)","v":0},{"$f":"SUM(I143-J143)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"PA8","index":9,"n_rows":145,"n_cols":14,"rows_kept":145,"cut":false,"hidden":false,"merged":[[13,0,14,10],[16,3,16,10],[17,3,17,10],[11,0,11,7],[17,0,17,2],[16,0,16,2],[0,0,0,5],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[7,10,8,10],[9,0,9,1],[9,5,9,6],[10,0,10,1],[10,5,10,6],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,2,8,2],[6,2,6,10],[5,2,5,10],[51,8,52,8],[51,9,52,9],[51,10,52,10],[44,0,44,7],[46,0,47,10],[49,3,49,10],[50,3,50,10],[42,3,42,4],[42,5,42,7],[43,0,43,1],[43,3,43,4],[43,5,43,7],[42,0,42,2],[50,0,50,2],[49,0,49,2],[28,3,28,4],[28,5,28,10],[29,10,30,10],[29,8,30,8],[29,9,30,9],[31,3,31,4],[53,3,53,4],[53,5,53,7],[54,0,54,1],[54,3,54,4],[54,5,54,7],[51,3,52,4],[51,5,52,7],[53,0,53,2],[51,0,52,2],[62,8,63,8],[62,9,63,9],[62,10,63,10],[55,0,55,7],[57,0,58,10],[60,3,60,10],[61,3,61,10],[62,0,63,2],[61,0,61,2],[60,0,60,2],[64,3,64,4],[64,5,64,7],[66,0,66,1],[66,3,66,4],[66,5,66,7],[65,3,65,4],[65,5,65,7],[65,0,65,2],[62,3,63,4],[62,5,63,7],[64,0,64,2],[80,0,80,2],[80,3,80,6],[80,7,80,10],[81,0,81,2],[81,3,81,5],[81,6,81,7],[82,0,82,2],[67,0,67,7],[69,0,70,10],[76,8,77,8],[76,9,77,9],[76,10,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[79,0,79,2],[79,3,79,6],[79,7,79,10],[105,0,105,2],[105,3,105,5],[105,6,105,7],[105,8,105,10],[106,0,107,7],[106,8,107,8],[106,9,107,9],[106,10,107,10],[108,0,108,2],[108,3,108,6],[108,7,108,10],[31,1,31,2],[21,0,21,1],[21,3,21,4],[21,5,21,7],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[28,1,28,2],[27,1,27,2],[20,3,20,4],[20,5,20,7],[20,0,20,2],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[18,8,19,8],[18,9,19,9],[18,10,19,10],[18,0,19,2],[18,3,19,4],[18,5,19,7],[39,3,39,10],[40,3,41,4],[40,5,41,7],[40,8,41,8],[40,9,41,9],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[40,10,41,10],[40,0,41,2],[39,0,39,2],[38,0,38,2],[72,0,72,10],[73,0,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[75,0,75,2],[75,3,75,5],[75,6,75,7],[75,8,75,10],[82,3,82,6],[82,7,82,10],[83,0,83,2],[83,3,83,6],[83,7,83,10],[91,5,91,10],[92,0,92,1],[92,3,92,4],[92,5,92,10],[84,0,84,7],[89,0,89,10],[90,0,90,10],[85,0,85,13],[86,0,86,13],[88,0,88,10],[91,0,91,1],[91,3,91,4],[93,3,94,4],[93,5,94,5],[93,6,94,6],[93,7,94,7],[93,8,94,8],[93,9,94,9],[93,10,94,10],[96,0,96,1],[96,3,96,4],[99,0,99,7],[100,0,100,13],[101,0,101,3],[102,0,102,10],[103,0,103,10],[104,3,104,5],[104,6,104,7],[104,8,104,10],[104,0,104,2],[109,0,109,2],[109,3,109,5],[109,6,109,7],[110,0,110,7],[112,0,112,10],[113,0,113,10],[114,0,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,116,1],[116,3,116,4],[116,5,116,10],[117,0,118,1],[117,2,118,2],[117,3,118,4],[117,5,118,5],[117,6,118,6],[117,7,118,7],[117,8,118,8],[117,9,118,9],[117,10,118,10],[119,0,119,1],[119,3,119,4],[121,0,121,7],[123,0,123,10],[124,0,124,10],[131,0,131,7],[133,0,133,10],[134,0,134,13],[136,0,136,2],[136,3,136,10],[137,0,137,2],[137,3,137,10],[138,1,138,2],[138,3,138,4],[138,5,138,7],[139,0,139,2],[139,3,139,4],[139,5,139,7],[145,0,145,10],[143,0,143,7]]}
[{"$f":"'Budget Sheet Instructions'!B23","v":"Tribal Juvenile Healing To Wellness Courts"},null,null,null,null,null,null,"Purpose Area (8)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J23","v":"OJJDP"},{"$f":"'Budget Sheet Instructions'!K23","v":"16.585"}]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
["Non-Federal match is not required for this purpose area but can be provided if desired.",null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,0]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D67*F67,1)","v":0},null,{"$f":"IF(I67-J67<0,0,I67-J67)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I67)","v":0},{"$f":"SUM(J65:J67)","v":0},{"$f":"SUM(K65:K67)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L79-M79<0,0,L79-M79)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L81-M81<0,0,L81-M81)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I82-J82<0,0,I82-J82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I79:I84)","v":0},{"$f":"SUM(J79:J84)","v":0},{"$f":"SUM(I85-J85)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F97:F97)*H97","v":0},0,{"$f":"IF(I97-J97<0,0,I97-J97)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I97:I99)","v":0},{"$f":"SUM(J97:J99)","v":0},{"$f":"SUM(I100-J100)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L109-M109<0,0,L109-M109)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I110-J110<0,0,I110-J110)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I109:I110)","v":0},{"$f":"SUM(J109:M110)","v":0},{"$f":"SUM(I111-J111)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F120*G120)*H120","v":0},0,{"$f":"IF(I120-J120<0,0,I120-J120)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I121:I121)","v":0},{"$f":"SUM(J121:J121)","v":0},{"$f":"SUM(I122-J122)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I127-J127<0,0,I127-J127)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I129-J129<0,0,I129-J129)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I130:I131)","v":0},{"$f":"SUM(J130:J131)","v":0},{"$f":"SUM(I132-J132)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C140*F140,1)","v":0},0,{"$f":"IF(I140-J140<0,0,I140-J140)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I143:I143)","v":0},{"$f":"SUM(J143:J143)","v":0},{"$f":"SUM(I144-J144)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"PA9","index":10,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[75,8,76,8],[75,9,76,9],[75,10,76,10],[77,0,77,2],[88,0,88,10],[89,0,89,10],[83,0,83,7],[81,0,81,2],[81,3,81,6],[81,7,81,10],[82,0,82,2],[82,3,82,6],[82,7,82,10],[77,3,77,6],[77,7,77,10],[78,0,78,2],[78,3,78,6],[78,7,78,10],[79,0,79,2],[79,3,79,6],[79,7,79,10],[80,0,80,2],[80,3,80,5],[80,6,80,7],[66,0,66,7],[68,0,69,10],[71,0,71,10],[72,0,72,10],[73,0,73,2],[73,3,73,5],[73,6,73,7],[73,8,73,10],[74,0,74,2],[74,3,74,5],[74,6,74,7],[74,8,74,10],[61,0,61,2],[65,0,65,2],[62,0,63,2],[64,0,64,2],[64,3,64,4],[64,5,64,7],[65,3,65,4],[65,5,65,7],[61,3,61,10],[62,3,63,4],[62,5,63,7],[62,8,63,8],[62,9,63,9],[62,10,63,10],[54,0,54,1],[54,3,54,4],[54,5,54,7],[55,0,55,7],[57,0,58,10],[60,3,60,10],[53,3,53,4],[53,5,53,7],[60,0,60,2],[53,0,53,2],[50,3,50,10],[51,3,52,4],[51,5,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[43,0,43,1],[43,3,43,4],[43,5,43,7],[44,0,44,7],[46,0,47,10],[49,3,49,10],[51,0,52,2],[50,0,50,2],[49,0,49,2],[40,3,41,4],[40,5,41,7],[40,8,41,8],[40,9,41,9],[40,10,41,10],[39,0,39,2],[40,0,41,2],[42,0,42,2],[42,3,42,4],[42,5,42,7],[38,0,38,2],[31,1,31,2],[32,3,32,4],[33,0,33,7],[35,0,36,10],[38,3,38,10],[27,1,27,2],[28,1,28,2],[39,3,39,10],[16,0,16,2],[20,0,20,2],[28,5,28,10],[29,0,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[29,9,30,9],[29,10,30,10],[0,7,0,10],[1,0,2,0],[1,1,2,5],[5,0,5,1],[9,0,9,1],[9,5,9,6],[7,2,8,2],[6,0,6,1],[7,0,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[0,0,0,5],[6,2,6,10],[5,2,5,10],[10,0,10,1],[10,5,10,6],[18,3,19,4],[18,5,19,7],[22,0,22,7],[24,0,25,10],[27,3,27,4],[27,5,27,10],[31,3,31,4],[28,3,28,4],[18,8,19,8],[18,9,19,9],[18,10,19,10],[11,0,11,7],[13,0,14,10],[16,3,16,10],[17,3,17,10],[21,0,21,1],[21,3,21,4],[21,5,21,7],[20,3,20,4],[20,5,20,7],[18,0,19,2],[17,0,17,2],[84,0,84,13],[85,0,85,13],[87,0,87,10],[90,0,90,1],[90,3,90,4],[90,5,90,10],[91,0,91,1],[91,3,91,4],[91,5,91,10],[92,6,93,6],[92,7,93,7],[92,8,93,8],[92,9,93,9],[92,10,93,10],[95,0,95,1],[95,3,95,4],[98,0,98,7],[99,0,99,13],[92,3,93,4],[92,5,93,5],[100,0,100,3],[101,0,101,10],[102,0,102,10],[103,3,103,5],[103,6,103,7],[103,8,103,10],[104,0,104,2],[104,3,104,5],[104,6,104,7],[104,8,104,10],[103,0,103,2],[105,0,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[107,0,107,2],[107,3,107,6],[107,7,107,10],[108,0,108,2],[108,3,108,5],[108,6,108,7],[109,0,109,7],[111,0,111,10],[112,0,112,10],[113,0,113,10],[114,0,114,1],[114,3,114,4],[114,5,114,10],[115,0,115,1],[115,3,115,4],[115,5,115,10],[116,0,117,1],[116,2,117,2],[116,3,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[116,8,117,8],[116,9,117,9],[116,10,117,10],[118,0,118,1],[118,3,118,4],[120,0,120,7],[122,0,122,10],[123,0,123,10],[130,0,130,7],[132,0,132,10],[133,0,133,13],[135,0,135,2],[135,3,135,10],[136,0,136,2],[136,3,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,7],[138,0,138,2],[138,3,138,4],[138,5,138,7],[144,0,144,10],[142,0,142,7]]}
[{"$f":"'Budget Sheet Instructions'!B24","v":"Tribal Youth Program"},null,null,null,null,null,null,"Purpose Area (9)"]
["Program Office",null,null,null,null,null,null,null,{"$f":"'Budget Sheet Instructions'!J24","v":"OJJDP"},{"$f":"'Budget Sheet Instructions'!K24","v":"16.731"}]
[]
["Note: Non-Federal match is not required for this purpose area but can be provided if desired."]
["A. Personnel"]
["Name/Position",null,"Computation"]
["List each position and name, if known. New positions may be grouped by type.",null,"Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"# of Positions","Salary ","Rate","Time Worked\n(# of hours, days, months, years)",null,"%","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*D10*F10*H10,1)","v":0},null,{"$f":"IF(I10-J10<0,0,I10-J10)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D11*F11*H11,1)","v":0},null,0]
["Total(s)",null,null,null,null,null,null,null,{"$f":"SUM(I10:I11)","v":0},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Type of Benefit",null,null,"Computation"]
["List each grant-support fringe benefit that is provided to the grant-funded position.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(I21-J21<0,0,I21-J21)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":0},{"$f":"SUM(K21:K22)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(F32*G32*H32,1)","v":0},null,{"$f":"IF(I32-J32<0,0,I32-J32)","v":0}]
[null,null,null,null,null,null,null,null,0,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D43*F43,1)","v":0},null,{"$f":"IF(I43-J43<0,0,I43-J43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D44*F44,1)","v":0},null,{"$f":"IF(I44-J44<0,0,I44-J44)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D54*F54,1)","v":0},null,{"$f":"IF(I54-J54<0,0,I54-J54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D55*F55,1)","v":0},null,{"$f":"IF(I55-J55<0,0,I55-J55)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I54:I55)","v":0},{"$f":"SUM(J54:J55)","v":0},{"$f":"SUM(K54:K55)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["List of Construction Activities",null,null,"Computation"]
["List and describe each item that is part of construction.",null,null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(I65-J65<0,0,I65-J65)","v":0}]
["N/A",null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(I66-J66<0,0,I66-J66)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Subawards (Subgrants)"]
["Subawards (Subgrants): Provide a cost estimate for activities to be carried out by subrecipients."]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Subawards (Subgrants):  Provide a description of the activities to be carried out by subrecipients",null,null,"Describe the purpose of the subaward (subgrant)",null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L78-M78<0,0,L78-M78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L80-M80<0,0,L80-M80)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I81-J81<0,0,I81-J81)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},{"$f":"SUM(I84-J84)","v":0}]
[]
[]
["Subaward Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F96:F96)*H96","v":0},0,{"$f":"IF(I96-J96<0,0,I96-J96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I96:I98)","v":0},{"$f":"SUM(J96:J98)","v":0},{"$f":"SUM(I99-J99)","v":0}]
[]
["H. Procurement Contracts"]
["Procurement Contracts"]
["Procurement contracts: Provide a cost estimate for the product or service to be procured by contract"]
["Description",null,null,"Purpose",null,null,"Consultant?",null,"Computation"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000).",null,null,"Describe the purpose of the procurement contract",null,null,"Is the procurement contract for a consultant? If yes, use the section below to explain associated travel expenses included in the cost.",null,"Compute the cost (e.g Cost-Non-Federal Contribution)"]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L108-M108<0,0,L108-M108)","v":0}]
[null,null,null,null,null,null,null,null,0,0,{"$f":"IF(I109-J109<0,0,I109-J109)","v":0}]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I108:I109)","v":0},{"$f":"SUM(J108:M109)","v":0},{"$f":"SUM(I110-J110)","v":0}]
["Procurement Contract Narrative"]
[]
["Consultant Travel (if necessary)"]
["List all travel-related expenses to be paid from the grant to the individual consultants (e.g., transportation, meals, lodging) separate from their consultant fees."]
["Purpose of Travel",null,"Location","Type of Expense",null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)",null,"Indicate the location of the event","Hotel, airfare, per diem",null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F119*G119)*H119","v":0},0,{"$f":"IF(I119-J119<0,0,I119-J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I120:I120)","v":0},{"$f":"SUM(J120:J120)","v":0},{"$f":"SUM(I121-J121)","v":0}]
["I. Other Costs"]
["Description "]
["List and describe items that will be paid with grants funds."]
[null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I126-J126<0,0,I126-J126)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I128-J128<0,0,I128-J128)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},{"$f":"SUM(J129:J130)","v":0},{"$f":"SUM(I131-J131)","v":0}]
["Other Costs Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[null,null,null,null,null,null,null,null,{"$f":"CEILING(C139*F139,1)","v":0},0,{"$f":"IF(I139-J139<0,0,I139-J139)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I142:I142)","v":0},{"$f":"SUM(J142:J142)","v":0},{"$f":"SUM(I143-J143)","v":0}]
["Indirect Costs Narrative"]

{"sheet":"Budget Summary","index":11,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,0,5,0],[0,0,0,10],[1,0,1,10]]}
["Budget Summary"]
["Note: Any errors detected on this page should be fixed on the Purpose Area specific tab."]
["Budget Category","PA(1)","PA (2)","PA (3)","PA (4)","PA (5)","PA (6)","PA (7)","PA(8)","PA(9)"]
[null,{"$f":"'PA1'!L2","v":"COPS"},null,{"$f":"'PA3'!I2","v":"BJA"},{"$f":"'PA4'!I2","v":"BJA"},{"$f":"'PA5'!I2","v":"OVW"},{"$f":"'PA6'!I2","v":"OVC"},{"$f":"'PA7'!I2","v":"OVC"},{"$f":"'PA8'!I2","v":"OJJDP"},{"$f":"'PA9'!I2","v":"OJJDP"}]
[null,{"$f":"'PA1'!M2","v":"16.710"},{"$f":"'PA2'!J2","v":"16.608"},{"$f":"'PA3'!J2","v":"16.608"},{"$f":"'PA4'!J2","v":"16.596"},{"$f":"'PA5'!J2","v":"16.587"},{"$f":"'PA6'!J2","v":"16.582"},{"$f":"'PA7'!J2","v":"16.582"},{"$f":"'PA8'!J2","v":"16.585"},{"$f":"'PA9'!J2","v":"16.731"}]
[null,{"$f":"'PA1'!A1","v":"Public Safety and Community Policing "},{"$f":"'PA2'!A1","v":"Comprehensive Tribal Justice Systems Strategic Planning"},{"$f":"'PA3'!A1","v":"Justice Systems and Alcohol and Substance Abuse"},{"$f":"'PA4'!A1","v":"Tribal Justice System Infrastructure Program"},{"$f":"'PA5'!A1","v":"Office on Violence Against Women Tribal Governments Program"},{"$f":"'PA6'!A1","v":"Children’s Justice Act Partnerships for Indian Communities"},{"$f":"'PA7'!A1","v":"Comprehensive Tribal Victim Assistance Program "},{"$f":"'PA8'!A1","v":"Tribal Juvenile Healing To Wellness Courts"},{"$f":"'PA9'!A1","v":"Tribal Youth Program"},"Total(s)"]
["A. Personnel",{"$f":"SalaryTotal","v":0},{"$f":"'PA2'!I13","v":0},{"$f":"'PA3'!I12","v":0},{"$f":"'PA4'!I12","v":0},{"$f":"'PA5'!I12","v":0},{"$f":"'PA6'!I12","v":0},{"$f":"'PA7'!I12","v":0},{"$f":"'PA8'!I12","v":0},{"$f":"'PA9'!I12","v":0},{"$f":"SUM(B7:J7)","v":0}]
["B. Fringe Benefits",{"$f":"FringeTotal","v":0},{"$f":"'PA2'!I25","v":0},{"$f":"'PA3'!I23","v":0},{"$f":"'PA4'!I23","v":0},{"$f":"'PA5'!I23","v":0},{"$f":"'PA6'!I23","v":0},{"$f":"'PA7'!I23","v":0},{"$f":"'PA8'!I23","v":0},{"$f":"'PA9'!I23","v":0},0]
["C. Travel",{"$f":"TravelTotal","v":0},{"$f":"'PA2'!I37","v":0},{"$f":"'PA3'!I34","v":0},{"$f":"'PA4'!I34","v":0},{"$f":"'PA5'!I34","v":0},{"$f":"'PA6'!I34","v":0},{"$f":"'PA7'!I34","v":0},{"$f":"'PA8'!I34","v":0},{"$f":"'PA9'!I34","v":0},0]
["D. Equipment",{"$f":"EquipmentTotal","v":0},{"$f":"'PA2'!I49","v":0},{"$f":"'PA3'!I45","v":0},{"$f":"'PA4'!I45","v":0},{"$f":"'PA5'!I45","v":0},{"$f":"'PA6'!I45","v":0},{"$f":"'PA7'!I45","v":0},{"$f":"'PA8'!I45","v":0},{"$f":"'PA9'!I45","v":0},0]
["E. Supplies",{"$f":"SuppliesTotal","v":0},{"$f":"'PA2'!I61","v":0},{"$f":"'PA3'!I56","v":0},{"$f":"'PA4'!I56","v":0},{"$f":"'PA5'!I56","v":0},{"$f":"'PA6'!I56","v":0},{"$f":"'PA7'!I56","v":0},{"$f":"'PA8'!I56","v":0},{"$f":"'PA9'!I56","v":0},0]
["F. Construction","N/A","N/A","N/A",{"$f":"'PA4'!I67","v":0},"N/A","N/A","N/A","N/A","N/A",0]
["G. Subawards (Subgrants)",{"$f":"'PA1'!L93","v":0},{"$f":"'PA2'!I89","v":0},{"$f":"'PA3'!I89","v":0},{"$f":"'PA4'!I89","v":0},{"$f":"'PA5'!I89","v":0},{"$f":"'PA6'!I89","v":0},{"$f":"'PA7'!I89","v":0},{"$f":"'PA8'!I89","v":0},{"$f":"'PA9'!I89","v":0},0]
["H. Procurement Contracts",{"$f":"'PA1'!L125","v":0},{"$f":"'PA2'!I115","v":0},{"$f":"'PA3'!I115","v":0},{"$f":"'PA4'!I115","v":0},{"$f":"'PA5'!I115","v":0},{"$f":"'PA6'!I115","v":0},{"$f":"'PA7'!I115","v":0},{"$f":"'PA8'!I115","v":0},{"$f":"'PA9'!I115","v":0},{"$f":"SUM(B14:J14)","v":0}]
["I. Other",{"$f":"OtherTotal","v":0},{"$f":"'PA2'!I136","v":0},{"$f":"'PA3'!J136","v":0},{"$f":"'PA4'!K136","v":0},{"$f":"'PA5'!L136","v":0},{"$f":"'PA6'!M136","v":0},{"$f":"'PA7'!N136","v":0},{"$f":"'PA8'!O136","v":0},{"$f":"'PA9'!P136","v":0},0]
[]
["Total Direct Costs",{"$f":"SUM(B7:B15)","v":0},0,0,0,0,0,0,{"$f":"SUM(I7:I15)","v":0},0,{"$f":"SUM(B17:J17)","v":0}]
["J. Indirect Costs",{"$f":"IndirectTotal","v":0},{"$f":"'PA2'!I148","v":0},{"$f":"'PA3'!I143","v":0},{"$f":"'PA4'!I143","v":0},{"$f":"'PA5'!I143","v":0},{"$f":"'PA6'!I143","v":0},{"$f":"'PA7'!I143","v":0},{"$f":"'PA8'!I144","v":0},{"$f":"'PA9'!I143","v":0},{"$f":"SUM(B18:J18)","v":0}]
[]
["Total Project Costs",{"$f":"SUM(B17,B18)","v":0},0,0,0,0,0,0,{"$f":"SUM(I17,I18)","v":0},0,{"$f":"SUM(B20:J20)","v":0}]
[]
[null,"Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project","Up to 100% of total Project"]
["Federal Request",{"$f":"TravelFederalTotal+PersonnelGrandTotal+EquipmentFederalTotal+SuppliesFederalTotal+ContractsItemFederalTotal+'PA1'!N127+'PA1'!N138+OtherFederalTotal+IndirectFederalTotal","v":0},{"$f":"SUM('PA2'!$K$13,'PA2'!$K$25,'PA2'!$K$37,'PA2'!$K$49,'PA2'!$K$61,'PA2'!$K$72,'PA2'!K89,'PA2'!K115,'PA2'!K136,'PA2'!K148)","v":0},{"$f":"'PA3'!K12+'PA3'!K23+'PA3'!K34+'PA3'!K45+'PA3'!K56+'PA3'!K67+'PA3'!K84+'PA3'!K99+'PA3'!K110+'PA3'!K131+'PA3'!K143","v":0},{"$f":"'PA4'!K12+'PA4'!K23+'PA4'!K34+'PA4'!K56+'PA4'!K67+'PA4'!K84+'PA4'!K99+'PA4'!K110+'PA4'!K121+'PA4'!K131+'PA4'!K143","v":0},{"$f":"SUM('PA5'!$K$12,'PA5'!$K$23,'PA5'!$K$34,'PA5'!$K$45,'PA5'!$K$56,'PA5'!$K$67,'PA5'!K84,'PA5'!K99,'PA5'!K110,'PA5'!K121,'PA5'!K131,'PA5'!K143)","v":0},{"$f":"'PA6'!K12+'PA6'!K23+'PA6'!K34+'PA6'!K45+'PA6'!K56+'PA6'!K67+'PA6'!K84+'PA6'!K110+'PA6'!K131+'PA6'!K143","v":0},{"$f":"SUM('PA7'!$K$12,'PA7'!$K$23,'PA7'!$K$34,'PA7'!$K$45,'PA7'!$K$56,'PA7'!$K$67,'PA7'!K143,'PA7'!K131,'PA7'!K110,'PA7'!K84)","v":0},{"$f":"SUM('PA8'!$K$12,'PA8'!$K$23,'PA8'!$K$34,'PA8'!$K$45,'PA8'!$K$56,'PA8'!$K$68,'PA8'!K85,'PA8'!K111,'PA8'!K132,'PA8'!K144)","v":0},{"$f":"SUM('PA9'!$K$12,'PA9'!$K$23,'PA9'!$K$34,'PA9'!$K$45,'PA9'!$K$56,'PA9'!$K$67,'PA9'!K143,'PA9'!K131,'PA9'!K110,'PA9'!K84)","v":0},{"$f":"SUM(B23:J23)","v":0}]
["Non-Federal Contribution",{"$f":"IndirectLocalTotal+OtherLocalTotal+'PA1'!M127+ContractsItemLocalTotal+SuppliesLocalTotal+EquipmentLocalTotal+TravelLocalTotal+LocalGrandTotal","v":0},{"$f":"SUM('PA2'!$J$13,'PA2'!$J$25,'PA2'!$J$37,'PA2'!$J$49,'PA2'!$J$61,'PA2'!$J$72,'PA2'!J89+'PA2'!J115+'PA2'!J136+'PA2'!J148)","v":0},{"$f":"'PA3'!J12+'PA3'!J23+'PA3'!J34+'PA3'!J45+'PA3'!J56+'PA3'!J67+'PA3'!J84+'PA3'!J99+'PA3'!J110+'PA3'!J121+'PA3'!J131+'PA3'!J143","v":0},{"$f":"'PA4'!J143+'PA4'!J131+'PA4'!J121+'PA4'!J110+'PA4'!J99+'PA4'!J84+'PA4'!J67+'PA4'!J56+'PA4'!J45+'PA4'!J34+'PA4'!J23+'PA4'!J12","v":0},{"$f":"SUM('PA5'!$J$12,'PA5'!$J$23,'PA5'!$J$34,'PA5'!$J$45,'PA5'!$J$56,'PA5'!$J$67,'PA5'!J143,'PA5'!J131,'PA5'!J121,'PA5'!J110,'PA5'!J99,'PA5'!J84)","v":0},{"$f":"'PA6'!J143+'PA6'!J131+'PA6'!J110+'PA6'!J84+'PA6'!J67+'PA6'!J56+'PA6'!J45+'PA6'!J34+'PA6'!J23+'PA6'!J12","v":0},{"$f":"SUM('PA7'!$J$12,'PA7'!$J$23,'PA7'!$J$34,'PA7'!$J$45,'PA7'!$J$56,'PA7'!$J$67,'PA7'!J143,'PA7'!J131,'PA7'!J110,'PA7'!J84)","v":0},{"$f":"SUM('PA8'!$J$12,'PA8'!$J$23,'PA8'!$J$34,'PA8'!$J$45,'PA8'!$J$56,'PA8'!$J$68,'PA8'!J85,'PA8'!J111,'PA8'!J132,'PA8'!J144)","v":0},{"$f":"SUM('PA9'!$J$12,'PA9'!$J$23,'PA9'!$J$34,'PA9'!$J$45,'PA9'!$J$56,'PA9'!$J$67,'PA9'!J84,'PA9'!J110,'PA9'!J131,'PA9'!J143)","v":0},{"$f":"SUM(B24:J24)","v":0}]
["Required Match Met","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]

{"sheet":"Reference Data","index":12,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[{"$f":"19760","v":19760},{"$f":"A1*0.9","v":17784},{"$f":"A1*0.1","v":1976}]
[]
[]
[]
[]
["PA1 Equipment Dropdown Options"]
["Vehicles"]
["Vehicles w/ accessory package"]
["Radios"]
["Computers"]
["Computer Aided Dispatch"]
["Records Management System"]
["Communication System"]
["Basic Issue Firearm"]
["Basic Issue Equipment"]
["Bullet Proof Vests"]
[]
["PA1 Supplies Dropdown Options"]
["Basic Issue Uniforms"]
[]
["PA1 Personnel Options"]
["Entry Level Sworn Officer"]
["Village Public Safety Officer (AK Only)"]
["Entry Level Sworn Ranger"]
["Entry Level Sworn Conservation and Wildlife Officer"]
["Civilian Methamphetamine Coordinator"]
[]
["Demographics Yes No Options"]
["Yes"]
["No"]
[]
["Travel Items"]
["Lodging"]
["Meals"]
["Mileage"]
["Transportation"]
["Local Travel"]
["Other"]