{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Summary","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect","j. Cost Share","SF-424A","k. Non-Federal Resources","SF-424A Cost Categories","SF-424A Minus FFRDC"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":102,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Instructions","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,4,7,5],[7,1,7,2],[4,1,4,2],[4,4,4,5],[1,0,1,6]]}
[]
["Budget Justification Worksheet Instructions"]
[]
[null,1,"What is a Budget Justification Worksheet?",null,2,"Cost Categories Tabs vs.\n Funding Allocation Tabs"]
[null,"\nThe budget justification worksheet is where applicants break down total project costs into eight budget categories and total resources allocated for the project into two categories (Federal funds and Non-Federal Cost Share).\n\nAll costs must be reasonable, allocable, and allowable and directly relevant to the project, including costs covered by matching share. All costs must be justified in the project.",null,null,"\nCost Category Tabs (a. through i.): These tabs are used to break down and justify costs by specific categories. Each tab corresponds to a different type of expense.\n\nCost Share (j.): This tab is used to identify resources and contributions to the project that are included in Cost Share (to be identified on tab j.). Do not record expenses on this tab."]
[]
[null,3,"Unhiding Extra Rows",null,4,"Additional Notes"]
[null,"\nAll tabs are password protected to preserve the integrity of formulas. However, extra rows have been included on each tab and can be unhidden to provide extra space as needed. To reveal these hidden rows, please follow these steps:\n\n1) Select Endmost Cell: Press the Ctrl + End keys simultaneously. This ensures the entire sheet will be selected in the next step. \n\n2) Select All Cells: Press the Ctrl + A keys simultaneously. This action will select all cells on the active worksheet tab.\n\n3) Unhide Rows: Once all cells are selected, press the Ctrl + SHIFT + 9 keys simultaneously. This action will unhide any hidden rows within the selected range.",null,null,"\nThe budget justification must meticulously adhere to the Department of Energy's financial assistance regulations (2 CFR Part 200, as adopted and supplemented by 2 CFR Part 910). A thorough review of these regulations is required.\n\nIf you need assistance at any point, reach out to the DOE Contact. \n\nDouble-check for completeness. Before submitting, ensure all required fields in each tab are completed. Cells requiring information will dynamically highlight yellow to alert for any missing information."]

{"sheet":"Summary","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,3,2,8],[9,1,9,9],[3,8,3,9],[4,8,4,9],[3,6,3,7],[4,6,4,7],[3,2,3,5],[4,2,4,5],[6,1,6,9],[7,1,7,9],[33,1,33,9],[30,1,30,2],[30,4,30,5],[32,1,32,9],[13,3,14,3],[13,2,14,2],[15,5,15,9],[20,5,20,9],[16,5,16,9],[17,5,17,9],[18,5,18,9],[19,5,19,9],[13,5,14,9],[13,4,14,4],[26,5,26,9],[27,5,27,9],[12,2,12,3],[10,2,10,3],[10,8,10,9],[11,2,11,3],[11,8,12,9],[28,5,28,9],[29,5,29,9],[21,5,21,9],[22,5,22,9],[23,5,23,9],[24,5,24,9],[25,5,25,9]]}
[]
[null,"Detailed Budget Justification",null,"Summary"]
[null,"Rev. 03/24/2026"]
[null,"Control Number",{"$nulls":4},"Date of Submission:"]
[null,"Applicant",{"$nulls":4},"Form submitted by: "]
[{"$nulls":8},"(May be award recipient or sub-recipient)"]
[null,"Please read the instructions on each worksheet tab before starting. For all questions, please ask the DOE contact."]
[null,"\n1. This spreadsheet should be used to provide detailed budget information for award application, negotiation, or budget revision.\n2. This summary tab and the SF424A tabs will auto populate with information provided in workbook tabs a. Personnel through j. Cost Share. Budget information is NOT entered on this tab or the SF424A tabs.\n3. Fill out the blank white cells in workbook tabs a. Personnel through j. Cost Share with detailed information on and support for project costs in each Category line item within each worksheet tab. \n4. The total budget presented on tabs a. Personnel through j. Cost Share must include both Federal (DOE) and Non-Federal (cost share) portions.\n5. All costs incurred by the preparer's sub-recipients, contractors, and Federal Research and Development Centers (FFRDCs), should be entered only in tab f. Contractual. All other sections are for the costs of the preparer only.\n6. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200, and the applicable cost principles for each entity type: FAR Part 31 for For-Profit entities; and 2 CFR Part 200 Subpart E - Cost Principles for all other non-federal entities.  \n7. Add rows as needed throughout tabs  a. Personnel through j. Cost Share. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to this Summary tab. If the project contains more than three budget periods, consult the DOE contact before adding additional budget period rows or columns. \n8. For a definition of budget period, please refer to the Department of Energy Guide to Financial Assistance located at https://www.energy.gov/management/articles/department-energy-guide-financial-assistance. \n"]
[]
[null,"SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent tabs, only blank white cells require data entry"]
[null,"Section A - Budget Summary",null,null,"Federal","Cost Share","Total Project Costs","Cost Share %","Proposed Budget Period Dates (m/d/yr - m/d/yr)"]
[null,null,"Budget Period 1",null,{"$f":"G12-F12","v":0},{"$f":"'j. Cost Share'!E38","v":0},{"$f":"C30","v":0},{"$f":"IF(G12>0,F12/G13,0)","v":0}]
[null,null,"Total",null,{"$f":"G13-F13","v":0},{"$f":"'j. Cost Share'!F38","v":0},{"$f":"D30","v":0},{"$f":"IF(G13>0,F13/G13,0)","v":0}]
[null,"Section B - Budget Categories","Budget Period 1"," Total Project Costs","% of Project","Comments (as needed)"]
[null,"CATEGORY"]
[null,"a. Personnel",{"$f":"'a. Personnel'!F51","v":0},{"$f":"'a. Personnel'!H51","v":0},{"$f":"IF(D16>0,D16/G13,0)","v":0}]
[null,"b. Fringe Benefits",{"$f":"'b. Fringe'!H44","v":0},{"$f":"'b. Fringe'!I44","v":0},{"$f":"IF(D17>0,D17/G13,0)","v":0}]
[null,"c. Travel",{"$f":"'c. Travel'!M34","v":0},{"$f":"'c. Travel'!M36","v":0},{"$f":"IF(D18>0,D18/G13,0)","v":0}]
[null,"d. Equipment",{"$f":"'d. Equipment'!F49","v":0},{"$f":"'d. Equipment'!F51","v":0},{"$f":"IF(D19>0,D19/G13,0)","v":0}]
[null,"e. Supplies",{"$f":"'e. Supplies'!F49","v":0},{"$f":"'e. Supplies'!F51","v":0},{"$f":"IF(D20>0,D20/G13,0)","v":0}]
[null,"f. Contractual"]
[null,"Sub-recipient",{"$f":"'f. Contractual'!G24","v":0},{"$f":"'f. Contractual'!H24","v":0},{"$f":"IF(D22>0,D22/G13,0)","v":0}]
[null,"Contractor",{"$f":"'f. Contractual'!G58","v":0},{"$f":"'f. Contractual'!H58","v":0},{"$f":"IF(D23>0,D23/G13,0)","v":0}]
[null,"FFRDC",{"$f":"'f. Contractual'!G73","v":0},{"$f":"'f. Contractual'!H73","v":0},{"$f":"IF(D24>0,D24/G13,0)","v":0}]
[null,"Total Contractual ",{"$f":"SUM(D22:D24)","v":0},{"$f":"SUM(D22:D24)","v":0},{"$f":"IF(D25>0,D25/G13,0)","v":0}]
[null,"g. Construction",{"$f":"'g. Construction'!D28","v":0},{"$f":"'g. Construction'!D28","v":0},{"$f":"IF(D26>0,D26/G13,0)","v":0}]
[null,"h. Other Direct Costs",{"$f":"'h. Other'!D34","v":0},{"$f":"'h. Other'!D36","v":0},{"$f":"IF(D27>0,D27/G13,0)","v":0}]
[null,"Total Direct Costs",{"$f":"D16+D17+D18+D19+D20+D25+D26+D27","v":0},{"$f":"D16+D17+D18+D19+D20+D25+D26+D27","v":0},{"$f":"IF(D28>0,D28/G13,0)","v":0}]
[null,"i. Indirect Charges",{"$f":"'i. Indirect'!G17","v":0},{"$f":"'i. Indirect'!G17","v":0},{"$f":"IF(D29>0,D29/G13,0)","v":0}]
[null,"Total Costs",{"$f":"D28+D29","v":0},{"$f":"D28+D29","v":0},{"$f":"E28+E29","v":0}]
[null,"Fringe Benefits + Indirect Charges \nAgainst Total Project Costs",null,{"$f":"IF((D17+D29)<=0,0,((D17+D29)/G13))","v":0},"Proposed Burdened Labor Amounts Against Total Project Costs",null,{"$f":"IF(('a. Personnel'!J8)<=0,0,('a. Personnel'!J8/G13))","v":0},"Percentage of Indirect Costs Against Total Project Costs",{"$f":"D31+G31","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"a. Personnel","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[53,1,53,10],[52,1,52,10],[2,1,2,10],[1,1,1,2],[3,1,4,10],[50,1,50,2],[6,1,6,10],[9,1,9,10],[26,8,26,10],[27,8,27,10],[28,8,28,10],[29,8,29,10],[50,8,50,10],[11,1,12,1],[11,2,12,2],[11,3,11,5],[11,6,11,7],[25,8,25,10],[23,8,23,10],[24,8,24,10],[22,8,22,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[16,8,16,10],[17,8,17,10],[11,8,11,10],[18,8,18,10],[19,8,19,10],[20,8,20,10],[21,8,21,10],[30,8,30,10],[31,8,31,10],[32,8,32,10],[33,8,33,10],[34,8,34,10],[35,8,35,10],[36,8,36,10],[37,8,37,10],[38,8,38,10],[39,8,39,10],[40,8,40,10],[41,8,41,10],[42,8,42,10],[43,8,43,10],[44,8,44,10],[45,8,45,10],[46,8,46,10],[47,8,47,10],[48,8,48,10],[49,8,49,10]]}
[]
[null,"Detailed Budget Justification"]
[null,"a. Personnel"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. List project costs solely for employees of the entity completing this form.  All personnel costs for subrecipients and contractors must be included under f. Contractual.\n2. All personnel should be identified by position title and not employee name. Enter the amount of time (e.g., hours or % of time) and the base hourly rate and the total direct personnel compensation will automatically calculate. Rate basis (e.g., negotiated for each hour worked on the project, labor distribution report, state civil service rates, etc.) must also be identified.\n3. If a position and hours are attributed to multiple employees, the number of employees for that position title must be identified in the Position Title field (e.g. Four (4) Technicians working 4000 hours).\n4. Total Personnel cost is rounded to the nearest dollar.\n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[]
[null,"Loaded Labor Rates"]
[null,"If loaded labor rates are proposed, please reflect the total dollar amount of indirect costs (fringe and other overheads) which were captured in the labor costs. Total Indirect Costs Loaded into Labor Rates:  ($)"]
[{"$nulls":9},"Enter zero if not applicable."]
[null,"A detailed description must be included to provide a breakdown of the burdened costs for each personnel hourly pay rate. The description should reflect the percentage added to the actual pay rates and can be included in the Additional Explanation section below or as an attachment to this form. DOE will review all components of the loaded labor rate to ensure cost reasonableness and allowability (e.g. are fee or profit included?). "]
[]
[null,"Workplan Task #","Position Title","Budget Period 1",null,null,"Total Project",null,"Rate Basis"]
[null,null,null,"Time \n(Hrs.)","Hourly Rate\n($/Hr.)","Total","Time \n(Hrs.)","Project Total Dollars"]
[null,1,"Sr. Engineer (EXAMPLE!!!)",2000,85,{"$f":"D14*E14","v":170000},{"$f":"D14","v":2000},{"$f":"F14","v":170000},"Actual Salary"]
[null,2,"Program Manager (EXAMPLE!!!)",1500,50,75000,{"$f":"D15","v":1500},{"$f":"F15","v":75000},"Actual Salary"]
[{"$nulls":5},{"$f":"D16*E16","v":0},{"$f":"D16","v":0},{"$f":"F16","v":0}]
[{"$nulls":5},0,{"$f":"D17","v":0},{"$f":"F17","v":0}]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},{"$f":"D32*E32","v":0},0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},{"$f":"D48*E48","v":0},0,0]
[{"$nulls":5},{"$f":"D49*E49","v":0},0,0]
[{"$nulls":5},{"$f":"D50*E50","v":0},0,0]
[null,"TOTAL PERSONNEL",null,{"$f":"SUM(D16:D50)","v":0},null,{"$f":"ROUND(SUM(F16:F50),0)","v":0},0,{"$f":"F51","v":0}]
[]
[null,"Additional Explanation (as needed - use box below):"]

{"sheet":"b. Fringe","index":3,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[51,2,51,9],[54,1,54,9],[53,1,53,9],[3,1,3,9],[45,1,45,9],[7,1,7,4],[8,1,8,4],[39,1,39,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[32,1,32,4],[43,1,43,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[1,1,1,7],[2,1,2,9],[34,1,34,4],[33,1,33,4],[38,1,38,4],[37,1,37,4],[36,1,36,4],[35,1,35,4],[5,1,6,4],[5,5,5,7],[5,8,6,8],[25,1,25,4],[26,1,26,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[31,1,31,4],[24,1,24,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4]]}
[]
[null,"Detailed Budget Justification "]
[null,"b. Fringe Benefits"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Fill out the table below by position title. If all employees receive the same fringe benefits, the Labor Type column can show \"Total Personnel\" instead of listing out all position titles.   \n2. The rates and how they are applied should not be averaged to get one fringe cost percentage. A detailed description must be included to provide DOE a breakdown of the calculation. This description may be provided in the Additional Explanation section below or may be provided in an attachment to this form.  \n3. The fringe benefit rates should be applied to all positions, regardless of whether those funds will be supported by Federal Share or Recipient Cost Share.\n4. Total Fringe cost is rounded to the nearest dollar.\n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Labor Type",null,null,null,"Budget Period 1",null,null,"Total Project $"]
[{"$nulls":5},"Personnel Costs","Rate","Total $"]
[null,"EXAMPLE!!! Sr. Engineer",null,null,null,170000,0.2,{"$f":"F8*G8","v":34000},{"$f":"H8","v":34000}]
[{"$nulls":7},{"$f":"G9*F9","v":0},{"$f":"H9","v":0}]
[{"$nulls":7},{"$f":"G10*F10","v":0},0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},0,0]
[{"$nulls":7},{"$f":"G40*F40","v":0},0]
[{"$nulls":7},{"$f":"G41*F41","v":0},0]
[{"$nulls":7},{"$f":"G42*F42","v":0},0]
[{"$nulls":7},{"$f":"G43*F43","v":0},0]
[null,"TOTAL FRINGE",null,null,null,{"$f":"SUM(F9:F43)","v":0},null,{"$f":"ROUND(SUM(H9:H43),0)","v":0},0]
[]
[null,"A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by DOE for estimating purposes is required at the time of award negotiation if reimbursement for fringe benefits is requested.  \nPlease click [√] one of the options below and provide the requested information if not previously submitted."]
[]
[null,null,false,"  A fringe benefit rate has been negotiated with, or approved by, a federal government agency. A copy of the latest rate agreement is/was included with the project application.*"]
[]
[null,null,false,"  There is not a current federally approved rate agreement negotiated and available.**"]
[]
[null,null,"* If the fringe billing rate is not identified under the federally approved rate agreement, please provide the organization’s benefit package and/or a list of the components/elements that comprise the fringe pool and the cost or percentage of each component/element allocated to the labor costs identified in the Budget Justification. \n\n** When this option is checked: (1) If the entity is submitting an indirect rate proposal (IRP), the fringe elements should be identified and a billing rate should be reflected in the IRP; or (2) If the entity is not submitting an IRP, please provide the organization’s benefit package and/or a list of the components/elements that comprise the fringe pool and the cost or percentage of each component/element allocated to the labor costs identified in the Budget Justification."]
[]
[null,"Please use the box below (or an attachment) to list the elements that comprise fringe benefits and how they are applied to the base (e.g. Personnel) to arrive at the fringe benefit rate.\nAdditional Explanation (as necessary):  "]

{"sheet":"c. Travel","index":4,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,1,37,13],[38,1,38,13],[3,1,3,13],[2,1,2,13],[1,1,1,2],[33,1,33,2],[5,1,5,13]]}
[]
[null,"Detailed Budget Justification "]
[null,"c. Travel"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Identify Domestic Travel items. \n           a) Examples of Purpose of Travel are subrecipient site visits, DOE meetings, project management meetings, etc. \n           b) Examples of Basis for Estimating Costs are GSA Per Diem Rates (https://www.gsa.gov/travel/plan-book/per-diem-rates), travel quotes, past trips, etc.    \n2. All listed travel must be necessary for performance of the Statement of Project Objectives.  \n3. Only travel that is directly associated with this award should be included as a direct travel cost to the award. \n4. Federal travel regulations are contained within the applicable cost principles for all entity types. \n5. Travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organization's written travel policy. In absence of a written travel policy, organizations must follow the travel regulations prescribed by the General Services Administration located at https://www.gsa.gov/policy-regulations/regulations/federal-travel-regulation. \n           a) Should an entity need to plan on including Local Travel, the DOE will use the GSA Local Travel Policy (https://www.gsa.gov/directives-library/local-travel-policy) to determine reasonablelness. Absent a written travel policy, \n               organizations must follow GSA's Local Travel Policy.\n6. The number of days is inclusive of day of departure and day of return. \n7. Please enter City and State in the Depart From and Destination fields.\n8. If a conference is included in the travel budget, please provide answers to the following questions in the Additional Explanation section on the bottom of the form:\n          a) Please indicate whether any other business unrelated to the project will be conducted while attending the conference. \n          b) Please confirm that the attendees will not be supported by any other DOE (or Federal) awards.   \n          c) Please explain how attending this conference will further the goals of the project.                                                                                                                     \n9. Total Travel cost is rounded to the nearest dollar.\n10. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Budget Period 1"]
[null,"Workplan Task #","Purpose of Travel","Depart From","Destination","# of Travelers","# of Days (Include day of departure and day of return)","# of Nights ","Flight ($) (Per traveler)","Ground Transport ($) (Per trip, ALL travelers)","Lodging ($) (Per night, per traveler)","Per Diem ($) (Per traveler / Per day)","Cost per Trip ($)","Basis for Estimating Costs"]
[null,1,"EXAMPLE!!!  Visit to PV manufacturer","Dallas, TX","Denver, CO",2,4,3,500,200,200,80,{"$f":"IF(H8=0, (I8*F8)+J8+(L8*0.75)*G8*F8, IF(AND(H8>0,H8<2), (I8*F8)+J8+(K8*H8*F8)+(L8*0.75)*G8*F8, ((I8*F8)+J8+(K8*H8*F8)+(L8*0.75)*2*F8)+(L8*(G8-2)*F8)))","v":2960},"Current GSA rates"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},{"$f":"IF(H11=0, (I11*F11)+J11+(L11*0.75)*G11*F11, IF(AND(H11>0,H11<2), (I11*F11)+J11+(K11*H11*F11)+(L11*0.75)*G11*F11, ((I11*F11)+J11+(K11*H11*F11)+(L11*0.75)*2*F11)+(L11*(G11-2)*F11)))","v":0}]
[{"$nulls":12},{"$f":"IF(H12=0, (I12*F12)+J12+(L12*0.75)*G12*F12, IF(AND(H12>0,H12<2), (I12*F12)+J12+(K12*H12*F12)+(L12*0.75)*G12*F12, ((I12*F12)+J12+(K12*H12*F12)+(L12*0.75)*2*F12)+(L12*(G12-2)*F12)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},{"$f":"IF(H23=0, (I23*F23)+J23+(L23*0.75)*G23*F23, IF(AND(H23>0,H23<2), (I23*F23)+J23+(K23*H23*F23)+(L23*0.75)*G23*F23, ((I23*F23)+J23+(K23*H23*F23)+(L23*0.75)*2*F23)+(L23*(G23-2)*F23)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,"Budget Period 1 Total",{"$nulls":10},{"$f":"SUM(M9:M33)","v":0}]
[]
[null,null,"TOTAL TRAVEL",{"$nulls":9},{"$f":"M34","v":0}]
[]
[null,"Additional Explanation (as needed - use box below):"]
[null,"hi"]

{"sheet":"d. Equipment","index":5,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,1,52,7],[53,1,53,7],[2,1,2,7],[1,1,1,2],[3,1,3,7],[48,1,48,2],[5,1,5,7]]}
[]
[null,"Detailed Budget Justification"]
[null,"d. Equipment"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Only costs for Equipment to be purchased directly by the Applicant are to be included on this tab. Equipment to be purchased by project contractor(s) should be included under Contractual (tab f.). \n2. Equipment means tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $10,000. Please refer to the applicable Federal regulations in 2 CFR 200 for specific equipment definitions and treatment. \n3. List all equipment below, providing a basis of cost (e.g. vendor quotes, catalog prices, prior invoices, etc.). Briefly justify items as they apply to the Statement of Project Objectives. If it is existing equipment, provide logical support for the estimated value shown. \n4. During award negotiations, provide a quote for all equipment items over $50,000 in price. If the quote is not an exact price match, provide an explanation in the additional explanation section below. If a quote is not practical, such as for a piece of equipment that is purpose-built, first of its kind, or otherwise not available off the shelf, provide a detailed engineering estimate for how the cost estimate was derived.\n5. Total Equipment cost is rounded to the nearest dollar.\n6. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Budget Period 1"]
[null,"Workplan Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
[null,"3,4,5","EXAMPLE!!!   167 KVA Pad Mount Transformer",2,54000,108000,"Contractor Quote - Attached","Voltage step-down for residential service "]
[{"$nulls":5},{"$f":"D9*E9","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},{"$f":"D15*E15","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},{"$f":"D48*E48","v":0}]
[null,"Budget Period 1 Total",null,null,null,{"$f":"ROUND(SUM(F9:F48),0)","v":0}]
[]
[null,null,"TOTAL EQUIPMENT",null,null,{"$f":"F49","v":0}]
[]
[null,"Additional Explanation (as needed - use box below):"]

{"sheet":"e. Supplies","index":6,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,1,52,7],[53,1,53,7],[1,1,1,2],[3,1,3,7],[2,1,2,7],[48,1,48,2],[5,1,5,7]]}
[]
[null,"Detailed Budget Justification "]
[null,"e. Supplies"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Only costs for Supplies to be purchased directly by the Applicant are to be included on this tab. Supplies to be purchased by project contractor(s) should be included under Contractual (tab f.).\n2. Supplies are generally defined as an item with an acquisition cost of $10,000 or less and a useful life expectancy of less than one year.  Supplies are generally consumed during the project performance. Please refer to the applicable Federal regulations in 2 CFR 200 for specific supplies definitions and treatment. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the non-Federal entity for financial statement purposes or $10,000, regardless of the length of its useful life. \n3. List all proposed supplies below, providing a basis of costs (e.g. vendor quotes, catalog prices, prior invoices, etc.). Briefly justify the need for the Supplies as they apply to the Statement of Project Objectives. Note that Supply items must be direct costs to the project at this budget category, and not duplicative of supply costs included in the indirect pool that is the basis of the indirect rate applied for this project.\n4. Multiple supply items valued at $10,000 or less used to assemble an equipment item with a value greater than $10,000 with a useful life of more than one year should be included on the equipment tab. If supply items and costs are ambiguous in nature, contact the DOE representative for proper categorization.  \n5. Total cost of supplies is rounded to the nearest dollar.\n6. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Budget Period 1"]
[null,"Workplan Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
[null,"1,2","EXAMPLE!!! 200A Main Breaker Meter Combo",4,360,{"$f":"D8*E8","v":1440},"Catalog price","Residential service panels for electrical service - Task 2.4"]
[{"$nulls":5},{"$f":"D9*E9","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"Budget Period 1 Total",null,null,null,{"$f":"ROUND(SUM(F9:F48),0)","v":0}]
[]
[null,null,"TOTAL SUPPLIES",null,null,{"$f":"F49","v":0}]
[]
[null,"Additional Explanation (as needed - use box below):"]

{"sheet":"f. Contractual","index":7,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,7],[59,2,59,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[54,2,54,3],[29,2,29,3],[30,2,30,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[55,2,55,3],[3,1,3,7],[71,2,71,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[76,1,76,7],[77,1,77,7],[56,2,56,3],[60,2,60,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[74,1,74,4],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[69,2,69,3],[70,2,70,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3]]}
[]
[null,"Detailed Budget Justification "]
[null,"f. Contractual"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. The entity completing this form must provide all costs related to subrecipients, contractors, and FFRDC partners in the applicable boxes below.  \n2. Subrecipients (partners, sub-awardees): Subrecipients shall submit a Budget Justification describing all project costs and calculations when their total proposed budget exceeds $500,000 of total award costs. These subrecipient forms may be completed by either the subrecipients themselves or by the preparer of this form.  The budget totals on the subrecipient's forms must match the subrecipient entries below. A subrecipient is a legal entity to which a subaward is made, who has performance measured against whether the objectives of the Federal program are met, is responsible for programmatic decision making, must adhere to applicable Federal program compliance requirements, and uses the Federal funds to carry out a program of the organization. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status. \n3. Contractors: List all contractors supplying commercial supplies or services used to support the project. For each Contractor cost with total project costs of $350,000 or more, a detailed Contractor quote must be provided. A contractor is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to many different purchasers, operates in a competitive environment, provides goods or services that are ancillary to the operation of the Federal program, and is not subject to compliance requirements of the Federal program. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status. \n4. Federal Funded Research and Development Centers (FFRDCs): FFRDCs must submit a signed Field Work Proposal during award application. The award recipient may allow the FFRDC to provide this information directly to DOE, however project costs must also be provided below.\n5. BASIS OF COST: If not providing a separate budget justification or specific quote which covers in detail the subrecipient/contractual costs below, the applicant MUST provide a detailed explanation in \"Purpose and Basis of Cost\", of how the cost was derived (i.e. personnel hours at rate of pay).  \n6. Total Contractual cost is rounded to the nearest dollar.\n7. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Workplan Task #","Sub-Recipient\nName/Organization","Sub-Recipient Unique Entity Identifier (UEI)","Purpose","Basis of Cost","Budget Period 1","Total Cost"]
[null,"2,4","EXAMPLE!!!  XYZ Corp.",null,"Partner to provide project management and oversight. ","Cost estimate based on personnel hours.",48000,{"$f":"G7","v":48000}]
[{"$nulls":7},{"$f":"G8","v":0}]
[{"$nulls":7},{"$f":"G9","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G8:G23)","v":0},0]
[]
[null,"Workplan Task #","Contractor \nName/Organization",null,"Purpose","Basis of Cost","Budget Period 1","Total Cost"]
[null,"3,4,5","EXAMPLE!!! ABC Inc.",null,"Engineering, procurement & installation contractor","Contractor quote - attached",500000,{"$f":"G27","v":500000}]
[{"$nulls":7},{"$f":"G28","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G28:G57)","v":0},{"$f":"SUM(H28:H57)","v":0}]
[]
[null,"Workplan Task #","FFRDC\nName/Organization",null,"Purpose","Basis of Cost","Budget Period 1","Total Cost"]
[{"$nulls":7},{"$f":"G61","v":0}]
[{"$nulls":7},{"$f":"G62","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G61:G72)","v":0},{"$f":"SUM(H61:H72)","v":0}]
[]
[{"$nulls":5},"TOTAL CONTRACTUAL: ",{"$f":"ROUND(G24+G58+G73,0)","v":0},{"$f":"ROUND(H24+H58+H73,0)","v":0}]
[]
[null,"Additional Explanation (as needed - use box below):"]

{"sheet":"g. Construction","index":8,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":true,"merged":[[99,1,100,5],[9,1,9,5],[28,1,28,5],[79,1,79,5],[45,1,45,5],[62,1,62,5],[97,1,97,2],[95,1,95,2],[78,1,78,2],[61,1,61,2],[44,1,44,2],[27,1,27,2],[6,1,6,2],[6,3,6,5],[1,1,1,2],[2,1,2,5],[3,1,3,5]]}
[]
[null,"Detailed Budget Justification"]
[null,"g. Construction"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Construction, for the purpose of budgeting, is defined as all types of work done on a particular building, including erecting, altering, or remodeling. Construction conducted by the award recipient is entered on this page. Any construction work that is performed by a contractor or subrecipient should be entered under f. Contractual.\n2. List all proposed construction below, providing a basis of cost such as engineering estimates, prior construction, etc., and briefly justify its need as it applies to the Statement of Project Objectives.\n3. Each budget period is rounded to the nearest dollar.\n4. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[]
[null,"Overall description of construction activities:"]
[]
[null,"SOPO Task #","General Description","Cost             ","Basis of Cost","Justification of need"]
[null,"Budget Period 1"]
[null,6,"EXAMPLE ONLY!!! Three days of excavation for platform site",28000,"Engineering estimate","Site must be prepared for construction of platform."]
{"$rows_empty":16}
[null,"Budget Period 1 Total",null,{"$f":"SUM(D12:D27)","v":0}]
[null,"Budget Period 2"]
{"$rows_empty":15}
[null,"Budget Period 2 Total",null,{"$f":"SUM(D30:D44)","v":0}]
[null,"Budget Period 3"]
{"$rows_empty":15}
[null,"Budget Period 3 Total",null,{"$f":"SUM(D47:D61)","v":0}]
[null,"Budget Period 4"]
{"$rows_empty":15}
[null,"Budget Period 4 Total",null,{"$f":"SUM(D64:D78)","v":0}]
[null,"Budget Period 5"]
{"$rows_empty":15}
[null,"Budget Period 5 Total",null,{"$f":"SUM(D81:D95)","v":0}]
[]
[null,"TOTAL CONSTRUCTION",null,{"$f":"(D28+D45+D62+D79+D96)","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"h. Other","index":9,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,37,5],[38,1,38,5],[1,1,1,2],[3,1,3,5],[33,1,33,2],[2,1,2,6],[5,1,5,5]]}
[]
[null,"Detailed Budget Justification"]
[null,"h. Other Direct Costs"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Other direct costs are direct cost items required for the project which do not fit clearly into other categories.  These direct costs must not be included in the indirect costs (for which the indirect rate is being applied for this project).  Examples are: printing costs, usage fees, etc. which can be directly charged to the project and are not duplicated in indirect costs (overhead costs).\n2. Basis of cost are items such as quotes, estimates, prior purchases of similar or like items, published price list, etc.\n3. Total Other Direct Costs is rounded to the nearest dollar.\n4. Required - list formulas for each cost in the Additional Explanation section. \n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Budget Period 1"]
[null,"Workplan Task #","General Description"," Cost             ","Basis of Cost","Justification of need"]
[null,1,"EXAMPLE!!!  Site prep - applicant organization facilities dept.",16000,"Established facilities department costs","Ground clearing, grading to be done by applicant org. facilities dept."]
{"$rows_empty":25}
[null,"Budget Period 1 Total",null,{"$f":"ROUND(SUM(D9:D33),0)","v":0}]
[]
[null,null,"TOTAL OTHER DIRECT COSTS",{"$f":"D34","v":0}]
[]
[null,"Additional Explanation (Required - list formulas for each cost in the box below):"]

{"sheet":"i. Indirect","index":10,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,29,9],[30,1,30,9],[14,7,14,9],[15,7,15,9],[1,1,1,7],[5,1,6,4],[7,1,7,4],[8,1,8,4],[2,1,2,9],[3,1,3,9],[5,6,6,6],[5,7,6,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[7,7,7,9],[5,5,6,5],[16,7,16,9],[11,7,11,9],[27,1,27,9],[18,1,18,9],[16,1,16,4],[14,1,14,4],[15,1,15,4],[12,7,12,9],[13,7,13,9],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4]]}
[]
[null,"Detailed Budget Justification "]
[null,"i. Indirect Costs"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Fill out the table below to indicate how the indirect costs are calculated. Use the box below to provide additional explanation regarding the indirect rate calculation.  \n2. The rates and how they are applied should not be averaged to get one indirect cost percentage. Complex calculations or rates that do not do not correspond to the below categories should be described/provided in the Additional Explanation section below. If questions exist, consult with the DOE contact before filling out this section. \n3. The indirect rate should be applied to both the Federal Share and Recipient Cost Share. \n4. An applicant/recipient who elects to apply the de minimis Indirect Cost Rate per 2 C.F.R. §200.414(f) cannot claim the resulting costs as a Cost Share contribution. The resulting costs are not verifiable in the Recipient records as required under §200.306(b)(1)\n5. Total Indirect Costs is rounded to the nearest dollar."]
[]
[null,"Provide ONLY Applicable Rates:",null,null,null,"Budget Period 1","Total Cost","Explanation of BASE \nExample: Labor + Fringe"]
[]
[null,"Overhead Rate %",{"$nulls":4},{"$f":"F8","v":0}]
[null,"General & Administrative (G&A) %",{"$nulls":4},{"$f":"F9","v":0}]
[null,"FCCM Rate (if applicable) %",{"$nulls":4},0]
[null,"OTHER Indirect Rate %",{"$nulls":4},0]
[null,"Indirect Costs (As Applicable):"]
[null,"Overhead Costs $",{"$nulls":4},{"$f":"F13","v":0}]
[null,"G&A Costs $",{"$nulls":4},{"$f":"F14","v":0}]
[null,"FCCM Costs (if applicable) $",{"$nulls":4},0]
[null," OTHER Indirect Costs $",{"$nulls":4},0]
[null,"Total Indirect Costs Requested:",null,null,null,{"$f":"ROUND(SUM(F13:F16),0)","v":0},{"$f":"ROUND(SUM(G13:G16),0)","v":0}]
[]
[null,"A federally approved indirect rate agreement, or rate proposed (supported and agreed upon by DOE for estimating purposes) is required if reimbursement of indirect costs is requested.  Please click [√] one of the options below and provide the requested information if it has not already been provided as requested, or has changed.  "]
[]
[null,null,false,"    An indirect rate has been approved or negotiated with a federal government agency with a current effective period of: "]
[null,null,null,false,"A copy of the latest rate agreement is included with this application and will be provided electronically to the Grants Officer for this project."]
[]
[null,null,false,"The organization does not have a current, federally approved indirect cost rate agreement and has provided an indirect rate proposal in support of the proposed costs."]
[]
[null,null,false,"This organization has elected to apply de minimis rate up to 15% in accordance with 2 CFR 200.414(f)."]
[]
[null,"Provide an explanation of how the indirect cost rate was applied."]
[]
[null,"Additional Explanation (as needed): *IMPORTANT:  Please use this box (or an attachment) to further explain how the total indirect costs were calculated.  If the total indirect costs are a cumulative amount of more than one calculation or rate application, the explanation and calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with grand total).  "]

{"sheet":"j. Cost Share","index":11,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,1,37,3],[1,1,1,2],[2,1,2,9],[3,1,3,5],[42,1,42,5],[41,1,41,5]]}
[]
[null,"Detailed Budget Justification"]
[null,"j. Cost Share"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Cost Share is the portion of project costs not paid by Federal funds (captured in tabs a. Personnel through i. Indirect). Cost Share is not a cost category or a place to capture costs, this is the place to reflect cost share funds allocated to cover project costs already captured on tabs a. Personnel through i. Indirect.\n2. A detailed presentation of the cash or cash value of all cost share proposed must be provided in the table below. All items in the form below must be identified within the applicable cost category tabs a. through i. in addition to the detailed presentation of the cash or cash value of all cost share proposed provided in the table below. Identify the source organization & amount of each cost share item proposed in the award. \n3. Cash Cost Share - encompasses all project costs paid for by the recipient, subrecipient, or third party (an entity that does not have a role in performing the scope of work) for costs incurred and paid for during the project. This includes when an organization pays for personnel, supplies, equipment, etc. for their own company with organizational resources. If the item or service is reimbursed for, it is cash cost share. All cost share items must be necessary to the performance of the project. Contractors may not provide cost share. Any partial donation of goods or services is considered a discount and is not allowable.  \n4. In Kind Cost Share - encompasses all resources allocated to the project made by the recipient, subrecipient, or third party (an entity that does not have a role in performing the scope of work) where a value of the resource can be readily determined, verified and justified but where no actual cash is transacted in securing the good or service comprising the resource. In Kind cost share items include volunteer personnel hours, the donation of space or use of equipment, etc. The cash value and calculations thereof for all In Kind cost share items must be justified and explained in the Cost Share Item section below. All cost share items must be necessary to the performance of the project. If questions exist, consult the DOE contact before filling out In Kind cost share in this section. Contractors may not provide cost share.  Any partial donation of goods or services is considered a discount and is not allowable.  \n5. Funds from other Federal sources MAY NOT be counted as cost share (unless permissible by law). This prohibition includes FFRDC sub-recipients. Non-Federal sources include any source not originally derived from Federal funds. \n6. Cost sharing commitment letters from subrecipients and third parties must be provided with the original application.\n7. Fee or profit, including foregone fee or profit, are not allowable as project costs (including cost share) unless explicitly authorized by the terms and conditions of the award. If the recipient earns program income during the project, it must be reallocated to the project. Please include any known or anticipated Program Income on the SF-424A Budget Information tab.\n8. An applicant/recipient who elects to apply the de minimis Indirect Cost Rate per 2 C.F.R. §200.414(f) cannot claim the resulting costs as a Cost Share contribution. The resulting costs are not verifiable in the Recipient records as required under §200.306(b)(1). \"Unrecovered indirect costs\" cannot be claimed as a source of Cost Share resource, without prior approval.  \n9. NOTE: Each cost share item entered below must align with an expense listed in the various tabs of this workbook. If the expense names or dollar amounts do not align with related expense, please provide an explanation to clarify in the Additional Explanation section.  \n10. Total Cost Share is rounded to the nearest dollar. \n11. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Organization/Source                 ","Type (Cash or In Kind) ","Cost Share Item ","Budget Period 1","Total Cost"]
[null,"EXAMPLE!!!  ABC Company","Cash","Project partner ABC Company will provide 20 PV modules at the price of $680 per module",13600,{"$f":"E7","v":13600}]
[null,"EXAMPLE!!!  Applicant Org","Cash","Contributed personnel costs (1,200 hours x $75/hour)",670682,{"$f":"E8","v":670682}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"TOTAL COST SHARE",null,null,{"$f":"ROUND(SUM(E9:E37),0)","v":0},{"$f":"ROUND(SUM(F9:F37),0)","v":0}]
[]
[null,"Total Project Cost:  ",{"$f":"Summary!D30","v":0},"Cost Share Percent:",{"$f":"IF(C40>0,E38/C40,0)","v":0},{"$f":"IF(C40>0,F38/C40,0)","v":0}]
[]
[null,"Additional Explanation (as needed - use box below):"]

{"sheet":"SF-424A","index":12,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":true,"merged":[[62,2,62,6],[64,0,101,7],[103,0,144,7],[0,2,0,3],[0,5,0,6],[58,0,58,7],[59,0,59,7],[60,2,60,6],[61,0,61,1],[55,0,55,3],[55,4,55,7],[56,2,56,7],[57,0,57,7],[53,0,53,2],[53,3,53,7],[54,2,54,3],[54,5,54,7],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[45,4,45,7],[46,0,47,3],[46,4,46,7],[48,1,48,3],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,0,45,3],[39,1,39,3],[40,0,40,2],[40,3,40,7],[41,0,41,2],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[31,0,31,7],[33,0,33,2],[33,3,33,7],[34,1,34,3],[27,1,27,2],[30,0,30,1],[30,2,30,5],[30,6,30,7],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,0,26,7],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[12,0,12,1],[12,2,12,7],[13,0,14,0],[13,1,14,2],[13,3,13,6],[13,7,14,7],[4,3,4,4],[0,0,0,1],[1,0,1,7],[2,0,2,7],[3,0,3,1],[3,2,3,7],[4,5,4,7],[4,0,5,0],[4,1,5,1],[4,2,5,2]]}
["Applicant Name:",null,null,null,"Award Number:"]
["Budget Information - Non Construction Programs"]
["OMB Approval No. 0348-0044"]
["Section A - Budget Summary"]
[null,"Grant Program Function or Activity","Catalog of Federal Domestic Assistance Number","Estimated Unobligated Funds",null,"New or Revised Budget"]
[null,null,null,"Federal ","Non-Federal ","Federal","Non-Federal","Total"]
[null,"(a)","(b)","(c )","(d)","(e)","(f)","(g)"]
["1.","Budget period 1",null,null,null,{"$f":"D26-G8","v":{"$error":"#REF!"}},{"$f":"'j. Cost Share'!F38","v":0},{"$f":"SUM(D8:G8)","v":{"$error":"#REF!"}}]
["2.","Budget period 2",null,null,null,{"$f":"E26-G9","v":{"$error":"#REF!"}},{"$f":"'j. Cost Share'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(D9:G9)","v":{"$error":"#REF!"}}]
["3.","Budget period 3",null,null,null,{"$f":"F26-'j. Cost Share'!#REF!","v":{"$error":"#REF!"}},{"$f":"'j. Cost Share'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(D10:G10)","v":{"$error":"#REF!"}}]
["4.",{"$nulls":6},{"$f":"SUM(D11:G11)","v":0}]
["5.","Totals",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G11)","v":{"$error":"#REF!"}},{"$f":"SUM(H8:H11)","v":{"$error":"#REF!"}}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total (5)"]
[null,null,null,"Budget period 1","Budget period 2","Budget period 3","(4)"]
[null,"a.  Personnel",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(D16:G16)","v":{"$error":"#REF!"}}]
[null,"b.  Fringe Benefits",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"c.  Travel",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"d.  Equipment",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"e.  Supplies",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"f.  Contractual",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"g.  Construction",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"h.  Other",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D16:D23)","v":{"$error":"#REF!"}},{"$f":"SUM(E16:E23)","v":{"$error":"#REF!"}},{"$f":"SUM(F16:F23)","v":{"$error":"#REF!"}},{"$f":"SUM(G16:G23)","v":0},{"$error":"#REF!"}]
[null,"j.  Indirect Charges",null,{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},{"$f":"Summary!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"SUM(D24:D25)","v":{"$error":"#REF!"}},{"$f":"SUM(E24:E25)","v":{"$error":"#REF!"}},{"$f":"SUM(F24:F25)","v":{"$error":"#REF!"}},{"$f":"SUM(G24:G25)","v":0},{"$f":"SUM(H24:H25)","v":{"$error":"#REF!"}}]
[]
["7.","Program Income",{"$nulls":5},{"$f":"SUM(D28:G28)","v":0}]
[]
[{"$nulls":7},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",{"$nulls":5},"Prescribed by OMB Circular A-102"]
["Authorized for Local Reproduction"]
[]
["Section C - Non-Federal Resources"]
[null,"(a) Grant Program",null,null,"(b) Applicant","(c ) State","(d) Other Sources","(e) Totals"]
["8.","Budget period 1",{"$nulls":5},{"$f":"SUM(E36:G36)","v":0}]
["9.","Budget period 2",{"$nulls":5},{"$f":"SUM(E37:G37)","v":0}]
["10.","Budget period 3",{"$nulls":5},{"$f":"SUM(E38:G38)","v":0}]
["11.",{"$nulls":6},{"$f":"SUM(E39:G39)","v":0}]
["12.","Total (sum of lines 8 - 11)",null,null,{"$f":"SUM(E36:E39)","v":0},{"$f":"SUM(F36:F39)","v":0},{"$f":"SUM(G36:G39)","v":0},{"$f":"SUM(H36:H39)","v":0}]
["Section D - Forecasted Cash Needs"]
[null,null,null,"Total for 1st Year","1st Quarter","2nd Quarter","3rd Quarter","4th quarter"]
["13.","Federal",null,{"$f":"SUM(E43:H43)","v":0}]
["14.","Non-Federal",null,{"$f":"SUM(E44:H44)","v":0}]
["15.","Total (sum of lines 13 and 14)",null,{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0}]
["Section E - Budget Estimates of Federal Funds Needed for Balance of the Project"]
["(a) Grant Program",null,null,null,"Future Funding Periods (Years)"]
[{"$nulls":4},"Budget period 1","Budget period 2","Budget period 3"]
["16."]
["17."]
["18."]
["19."]
["20.","Total (sum of lines 16-19)",null,null,{"$f":"SUM(E49:E52)","v":0},{"$f":"SUM(F49:F52)","v":0},{"$f":"SUM(G49:G52)","v":0},{"$f":"SUM(H49:H52)","v":0}]
["Section F - Other Budget Information"]
["21. Direct Charges",null,null,null,"22. Indirect Charges"]
[]
["23.  Remarks"]
[]
[]
[]
[{"$nulls":7},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,"              ",{"$nulls":4},"Prescribed by OMB Circular A-102"]
[null,null,"Authorized for Local Reproduction"]

{"sheet":"k. Non-Federal Resources","index":13,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":true,"merged":[[56,1,56,4],[57,1,57,4],[38,1,53,1],[38,4,52,4],[1,1,1,3],[2,1,2,4],[3,1,3,4],[6,1,21,1],[6,4,20,4],[22,1,37,1],[22,4,36,4]]}
[]
[null,"Detailed Budget Justification"]
[null,"k. Non-Federal Resources"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Non-federal resources are funds used for costs incurred for the project that are not included in cost share or tabs a. through i. These contributions are tracked separately and do not affect the project totals on the Summary tab. This tab is rarely used. Before entering any information on this page, please review with the DOE contact.\n2. Standalone tab: The data entered here flows only to the SF-424A Cost Categories and the SF-424A Minus FFRDC tabs and does not impact the project total costs.\n3. No Split Costs: All costs covered by contributions of Non-Federal resources must be fully attributed to a single source. Split costs across multiple funding sources are strictly prohibited. \n4. The budget period is rounded to the nearest dollar. \n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"Source","Source Description","Total"]
[null,"Applicant"]
{"$rows_empty":14}
[null,null,"Applicant Totals: ",{"$f":"ROUND(SUM(D7:D21),0)","v":0}]
[null,"State"]
{"$rows_empty":14}
[null,null,"State Totals: ",{"$f":"ROUND(SUM(D23:D37),0)","v":0}]
[null,"Other Sources"]
{"$rows_empty":14}
[null,null,"Other Sources Totals:   ",{"$f":"ROUND(SUM(D39:D53),0)","v":0}]
[null,null,"Grand Total",{"$f":"ROUND(SUM(D22+D38+D54),0)","v":0}]
[]
[null,"Additional Explanation (as needed):  "]

{"sheet":"SF-424A Cost Categories","index":14,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[32,2,32,3],[28,2,28,3],[30,2,30,3],[31,1,31,8],[1,1,1,3],[4,3,4,4],[24,2,24,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[17,1,17,8],[18,1,19,1],[18,2,19,3],[4,6,4,7],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,8,5],[8,6,8,8],[4,1,4,2],[18,4,18,7],[18,8,19,8],[35,1,35,2],[35,3,35,6],[36,1,36,8]]}
[]
[null,"Detailed Budget Justification",{"$nulls":6},"Attachment 3"]
[]
[]
[null,"Applicant Name:",null,{"$f":"Summary!C5","v":0},null,"Award Number:",{"$f":"Summary!C4","v":0}]
[null,"Budget Information - Non Construction Programs"]
[null,"OMB Number: 4040-0006\nExpiration Date: 02/28/2025"]
[null,"Section A - Budget Summary"]
[null,null,"Grant Program Function or Activity","Assistance Listing Number","Estimated Unobligated Funds",null,"New or Revised Budget"]
[{"$nulls":4},"Federal","Non-Federal ","Federal","Non-Federal","Total"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)"]
[null,"1.","Budget Period 1",null,null,null,{"$f":"ROUND(Summary!E13,0)","v":0},{"$f":"ROUND(Summary!F13,0)+'k. Non-Federal Resources'!D55","v":0},{"$f":"ROUND(SUM(E12:H12),0)","v":0}]
[null,"2.","Budget Period 2",null,null,null,{"$f":"ROUND(Summary!#REF!,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(Summary!#REF!,0)+'k. Non-Federal Resources'!#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(E13:H13),0)","v":{"$error":"#REF!"}}]
[null,"3.","Budget Period 3",null,null,null,{"$f":"ROUND(Summary!#REF!,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(Summary!#REF!,0)+'k. Non-Federal Resources'!#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(E14:H14),0)","v":{"$error":"#REF!"}}]
[null,"4.","Budget Period 4",null,null,null,{"$f":"ROUND(Summary!#REF!,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(Summary!#REF!,0)+'k. Non-Federal Resources'!#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(E15:H15),0)","v":{"$error":"#REF!"}}]
[null,"5.","Budget Period 5",null,null,null,{"$f":"ROUND(Summary!#REF!,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(Summary!#REF!,0)+'k. Non-Federal Resources'!#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(E16:H16),0)","v":{"$error":"#REF!"}}]
[null,null,"Total",null,null,null,{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0}]
[null,"Section B - Budget Categories"]
[null,"2.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total"]
[{"$nulls":4},"Budget Period 1"]
[null,null,"a.  Personnel",null,{"$f":"ROUND(Summary!D16,0)","v":0},null,null,null,{"$f":"E21","v":0}]
[null,null,"b.  Fringe Benefits",null,{"$f":"ROUND(Summary!D17,0)","v":0},null,null,null,0]
[null,null,"c.  Travel",null,{"$f":"ROUND(Summary!D18,0)","v":0},null,null,null,0]
[null,null,"d.  Equipment",null,{"$f":"ROUND(Summary!D19,0)","v":0},null,null,null,0]
[null,null,"e.  Supplies",null,{"$f":"ROUND(Summary!D20,0)","v":0},null,null,null,0]
[null,null,"f.  Contractual",null,{"$f":"ROUND(Summary!D25,0)","v":0},null,null,null,0]
[null,null,"g.  Construction",null,{"$f":"ROUND(Summary!D26,0)","v":0},null,null,null,0]
[null,null,"h.  Other",null,{"$f":"ROUND(Summary!D27,0)","v":0},null,null,null,0]
[null,null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"ROUND(Summary!D28,0)","v":0},null,null,null,0]
[null,null,"j.  Indirect Charges",null,{"$f":"ROUND(Summary!D29,0)","v":0},null,null,null,0]
[null,null,"k.  Totals (sum of 6i-6j)",null,{"$f":"ROUND(SUM(E29:E30),0)","v":0},null,null,null,0]
[]
[null,"3.","Program Income",null,0,null,0,0,{"$f":"ROUND(SUM(E33:H33),0)","v":0}]
[]
[{"$nulls":8},"Standard Form 424A (Rev. 7- 97)"]
[{"$nulls":8},"Prescribed by OMB (Circular A-102)"]
[null,"Authorized for Local Reproduction"]

{"sheet":"SF-424A Minus FFRDC","index":15,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,4,4],[13,1,13,8],[14,1,15,1],[14,2,15,3],[4,1,4,2],[4,6,4,7],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,8,5],[8,6,8,8],[14,4,14,7],[21,2,21,3],[22,2,22,3],[23,2,23,3],[25,2,25,3],[28,2,28,3],[14,8,15,8],[24,2,24,3],[26,2,26,3],[27,1,27,8],[20,2,20,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[31,1,31,2],[31,3,31,6],[32,1,32,8]]}
[]
[null,"Detailed Budget Justification",{"$nulls":6},"Attachment 3"]
[]
[]
[null,"Applicant Name:",null,{"$f":"Summary!C5","v":0},null,"Award Number:",{"$f":"Summary!C4","v":0}]
[null,"Budget Information - Non Construction Programs"]
[null,"OMB Number: 4040-0006\nExpiration Date: 02/28/2025"]
[null,"Section A - Budget Summary"]
[null,null,"Grant Program Function or Activity","Assistance Listing Number","Estimated Unobligated Funds",null,"New or Revised Budget"]
[{"$nulls":4},"Federal","Non-Federal ","Federal","Non-Federal","Total"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)"]
[null,"1.","Budget Period 1",null,null,null,{"$f":"ROUND(Summary!E13,0)-ROUND(Summary!D24,0)","v":0},{"$f":"ROUND(Summary!F13,0)+'k. Non-Federal Resources'!D55","v":0},{"$f":"ROUND(SUM(E12:H12),0)","v":0}]
[null,null,"Total",null,null,null,{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0}]
[null,"Section B - Budget Categories"]
[null,"2.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total"]
[{"$nulls":4},"Budget Period 1"]
[null,null,"a.  Personnel",null,{"$f":"ROUND(Summary!D16,0)","v":0},null,null,null,{"$f":"E17","v":0}]
[null,null,"b.  Fringe Benefits",null,{"$f":"ROUND(Summary!D17,0)","v":0},null,null,null,{"$f":"E18","v":0}]
[null,null,"c.  Travel",null,{"$f":"ROUND(Summary!D18,0)","v":0},null,null,null,0]
[null,null,"d.  Equipment",null,{"$f":"ROUND(Summary!D19,0)","v":0},null,null,null,0]
[null,null,"e.  Supplies",null,{"$f":"ROUND(Summary!D20,0)","v":0},null,null,null,0]
[null,null,"f.  Contractual",null,{"$f":"ROUND(Summary!D25,0)- Summary!D24","v":0},null,null,null,0]
[null,null,"g.  Construction",null,{"$f":"ROUND(Summary!D26,0)","v":0},null,null,null,0]
[null,null,"h.  Other",null,{"$f":"ROUND(Summary!D27,0)","v":0},null,null,null,0]
[null,null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"ROUND(Summary!D28,0)","v":0},null,null,null,0]
[null,null,"j.  Indirect Charges",null,{"$f":"ROUND(Summary!D29,0)","v":0},null,null,null,0]
[null,null,"k.  Totals (sum of 6i-6j)",null,{"$f":"ROUND(SUM(E25:E26),0)","v":0},null,null,null,0]
[]
[null,"3.","Program Income",null,0,0,0,0,{"$f":"ROUND(SUM(E29:H29),0)","v":0}]
[]
[{"$nulls":8},"Standard Form 424A (Rev. 7- 97)"]
[{"$nulls":8},"Prescribed by OMB (Circular A-102)"]
[null,"Authorized for Local Reproduction"]