{"text_format":"2","workbook":"xlsx","n_sheets":17,"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","Spend Plan","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":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,2,6,15],[12,3,15,7],[12,9,15,14],[8,4,11,7],[8,3,11,3],[8,9,11,9],[8,10,11,14],[17,6,20,11],[25,3,32,4],[30,7,30,10],[33,3,35,7],[36,3,39,3],[36,4,39,7],[36,9,39,9],[36,10,39,14],[33,9,35,14],[21,6,29,11],[25,13,32,14],[16,3,23,4],[16,13,23,14]]}
[]
[null,null,"Budget Justification Worksheet Instructions"]
[]
[]
[]
[]
[]
[]
[null,null,null,1,"What is a Budget Justification Worksheet?",{"$nulls":4},2,"Cost Categories Tabs vs.\n Funding Allocation Tabs"]
[]
[]
[]
[null,null,null,"The budget justification worksheet is where applicants break down total project costs into nine budget categories and total resources allocated for the project into three categories (Federal, Cost Share, or Non-Federal).",{"$nulls":5},"\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\n"]
[]
[]
[]
[null,null,null,"All 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.",{"$nulls":9},"Cost Share (j.) and Non-Federal Resources Tab (k.): These tabs are used to identify resources and contributions to the project that are either included in Cost Share (to be identified on tab j.) or not inlcuded in cost share (to be identified on tab k.). Do not record expenses on these tabs."]
[{"$nulls":6},"WAIT! READ THIS BEFORE you get started."]
[]
[]
[]
[{"$nulls":6},"IMPORTANT. Please indicate how many budget periods the project spans. Based on your selection, certain fields will be dynamically adjusted to ensure only relevant information is collected. If a selection is not made, the Budget Justification Worksheet will default to include 3 budget periods. \n\nA budget period is the time interval from the start date of a funded portion of an award to the end date of that funded portion, during which Recipients and Subrecipients are authorized to incur financial obligations. Typically, budget periods are established on an annual basis. Please refer to the DOE Guide to Financial Assistance located at https://www.energy.gov/management/financial-assistance for more information. "]
[]
[]
[]
[null,null,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:\n1) Select Endmost Cell: Press the Ctrl + End keys simultaneously. This ensures the entire sheet will be selected in the next step. ",{"$nulls":9},"\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. "]
[]
[]
[]
[]
[{"$nulls":7},"3 Budget Periods or Less"]
[]
[]
[null,null,null,"2) Select All Cells: Press the Ctrl + A keys simultaneously. This action will select all cells on the active worksheet tab.\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.\n",{"$nulls":5},"Double-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."]
[]
[]
[null,null,null,3,"Unhiding Extra Rows",{"$nulls":4},4,"Additional Notes"]

{"sheet":"Summary","index":1,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,3,12,4],[13,3,13,4],[18,7,19,7],[17,3,17,4],[1,3,2,8],[9,1,9,9],[18,5,19,5],[18,6,19,6],[36,1,37,9],[6,1,6,9],[7,1,7,9],[11,1,17,1],[10,2,11,2],[10,7,11,7],[10,8,11,8],[10,9,11,9],[18,2,19,2],[18,3,19,3],[18,4,19,4],[10,3,11,4],[15,5,15,6],[16,3,16,4],[14,3,14,4],[15,3,15,4],[35,1,35,2],[35,4,35,5],[18,8,19,8],[18,9,19,9],[3,8,3,9],[4,8,4,9],[16,5,16,6],[17,5,17,6],[3,6,3,7],[4,6,4,7],[3,2,3,5],[4,2,4,5],[10,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6]]}
[]
[null,"Detailed Budget Justification",null,"Summary"]
[null,"Rev. 6/23/2025"]
[null,"Award Number:",{"$nulls":4},"Date of Submission:"]
[null,"Award Recipient:",{"$nulls":4},"Form submitted by: "]
[{"$nulls":9},"(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 will auto populate with information provided in workbook tabs a. Personnel through j. Cost Share. Budget information is NOT entered on this tab.\n3. Fill out the blank white cells in workbook tabs a through j 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*** New Awards or new funding issued after May 8, 2025 will be subject to DOE Policy PF 2025-25, PF 2025-26, and PF 2025-27 (https://www.energy.gov/management/policy-flashes), where the maximum limit of funds paid or reimbursed to a new Award recipient as indirect costs is calculated as a percentage of the Total Project Award Amount (also referred to as Total Project Costs) and will be included in the Award terms as a cap. For state and local government financial assistance awards, this maximum percentage is 10 percent (10%). For non-profit and for-profit organizations, the maximum percentage is 15 percent (15%). Accordingly, the calculated Percentage of Indirect Costs Against Total Project Costs field below will highlight yellow when above or equal to 10 percent (10%) and red when above or equal to 15 percent (15%).\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,"Federal",null,"Cost Share",null,"Total Project Costs","Cost Share %","Proposed Budget Period Dates"]
[]
[null,null,"Budget Period 1",{"$f":"H13-F13","v":0},null,{"$f":"'j. Cost Share'!E28","v":0},null,{"$f":"C35","v":0},{"$f":"IF(H13>0,F13/H13,0)","v":0}]
[null,null,"Budget Period 2",{"$f":"H14-F14","v":0},null,{"$f":"'j. Cost Share'!F28","v":0},null,{"$f":"D35","v":0},0]
[null,null,"Budget Period 3",{"$f":"H15-F15","v":0},null,{"$f":"'j. Cost Share'!G28","v":0},null,{"$f":"E35","v":0},0]
[null,null,"Budget Period 4",{"$f":"H16-F16","v":0},null,{"$f":"'j. Cost Share'!H28","v":0},null,{"$f":"F35","v":0},0]
[null,null,"Budget Period 5",{"$f":"H17-F17","v":0},null,{"$f":"'j. Cost Share'!I28","v":0},null,{"$f":"G35","v":0},0]
[null,null,"Total",{"$f":"SUM(D13:D17)","v":0},null,{"$f":"SUM(F13:F17)","v":0},null,{"$f":"SUM(H13:H17)","v":0},0]
[null,"Section B - Budget Categories","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"," Total Project Costs","% of Project","Comments (as needed)"]
[null,"CATEGORY"]
[null,"a. Personnel",{"$f":"'a. Personnel'!F50","v":0},{"$f":"'a. Personnel'!I50","v":0},{"$f":"'a. Personnel'!L50","v":0},{"$f":"'a. Personnel'!O50","v":0},{"$f":"'a. Personnel'!R50","v":0},{"$f":"SUM(C21:G21)","v":0},{"$f":"IF(H21>0,H21/H18,0)","v":0}]
[null,"b. Fringe Benefits",{"$f":"'b. Fringe'!H24","v":0},{"$f":"'b. Fringe'!K24","v":0},{"$f":"'b. Fringe'!N24","v":0},{"$f":"'b. Fringe'!Q24","v":0},{"$f":"'b. Fringe'!T24","v":0},{"$f":"SUM(C22:G22)","v":0},{"$f":"IF(H22>0,H22/H18,0)","v":0}]
[null,"c. Travel",{"$f":"'c. Travel'!M36","v":0},{"$f":"'c. Travel'!M64","v":0},{"$f":"'c. Travel'!M92","v":0},{"$f":"'c. Travel'!M120","v":0},{"$f":"'c. Travel'!M148","v":0},0,{"$f":"IF(H23>0,H23/H18,0)","v":0}]
[null,"d. Equipment",{"$f":"'d. Equipment'!F26","v":0},{"$f":"'d. Equipment'!F44","v":0},{"$f":"'d. Equipment'!F62","v":0},{"$f":"'d. Equipment'!F80","v":0},{"$f":"'d. Equipment'!F98","v":0},0,{"$f":"IF(H24>0,H24/H18,0)","v":0}]
[null,"e. Supplies",{"$f":"'e. Supplies'!F28","v":0},{"$f":"'e. Supplies'!F48","v":0},{"$f":"'e. Supplies'!F68","v":0},{"$f":"'e. Supplies'!F88","v":0},{"$f":"'e. Supplies'!F108","v":0},0,{"$f":"IF(H25>0,H25/H18,0)","v":0}]
[null,"f. Contractual"]
[null,"Sub-recipient",{"$f":"'f. Contractual'!G24","v":0},{"$f":"'f. Contractual'!H24","v":0},{"$f":"'f. Contractual'!I24","v":0},{"$f":"'f. Contractual'!J24","v":0},{"$f":"'f. Contractual'!K24","v":0},0,{"$f":"IF(H27>0,H27/H18,0)","v":0}]
[null,"Contractor",{"$f":"'f. Contractual'!G44","v":0},{"$f":"'f. Contractual'!H44","v":0},{"$f":"'f. Contractual'!I44","v":0},{"$f":"'f. Contractual'!J44","v":0},{"$f":"'f. Contractual'!K44","v":0},0,{"$f":"IF(H28>0,H28/H18,0)","v":0}]
[null,"FFRDC",{"$f":"'f. Contractual'!G59","v":0},{"$f":"'f. Contractual'!H59","v":0},{"$f":"'f. Contractual'!I59","v":0},{"$f":"'f. Contractual'!J59","v":0},{"$f":"'f. Contractual'!K59","v":0},0,{"$f":"IF(H29>0,H29/H18,0)","v":0}]
[null,"Total Contractual ",{"$f":"SUM(C27:C29)","v":0},{"$f":"SUM(D27:D29)","v":0},{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":0},0,{"$f":"IF(H30>0,H30/H18,0)","v":0}]
[null,"g. Construction",{"$f":"'g. Construction'!D28","v":0},{"$f":"'g. Construction'!D45","v":0},{"$f":"'g. Construction'!D62","v":0},{"$f":"'g. Construction'!D79","v":0},{"$f":"'g. Construction'!D96","v":0},0,{"$f":"IF(H31>0,H31/H18,0)","v":0}]
[null,"h. Other Direct Costs",{"$f":"'h. Other'!D26","v":0},{"$f":"'h. Other'!D44","v":0},{"$f":"'h. Other'!D62","v":0},{"$f":"'h. Other'!D80","v":0},{"$f":"'h. Other'!D98","v":0},0,{"$f":"IF(H32>0,H32/H18,0)","v":0}]
[null,"Total Direct Costs",{"$f":"C21+C22+C23+C24+C25+C30+C31+C32","v":0},{"$f":"D21+D22+D23+D24+D25+D30+D31+D32","v":0},{"$f":"E21+E22+E23+E24+E25+E30+E31+E32","v":0},{"$f":"F21+F22+F23+F24+F25+F30+F31+F32","v":0},{"$f":"G21+G22+G23+G24+G25+G30+G31+G32","v":0},0,{"$f":"IF(H33>0,H33/H18,0)","v":0}]
[null,"i. Indirect Charges",{"$f":"'i. Indirect'!F17","v":0},{"$f":"'i. Indirect'!G17","v":0},{"$f":"'i. Indirect'!H17","v":0},{"$f":"'i. Indirect'!I17","v":0},{"$f":"'i. Indirect'!J17","v":0},0,{"$f":"IF(H34>0,H34/H18,0)","v":0}]
[null,"Total Costs",{"$f":"C33+C34","v":0},{"$f":"D33+D34","v":0},{"$f":"E33+E34","v":0},{"$f":"F33+F34","v":0},0,{"$f":"H33+H34","v":0},{"$f":"I33+I34","v":0}]
[null,"Fringe Benefits + Indirect Charges \nAgainst Total Project Costs",null,{"$f":"IF((H22+H34)<=0,0,((H22+H34)/H18))","v":0},"Proposed Burdened Labor Amounts Against Total Project Costs",null,{"$f":"IF(('a. Personnel'!T8)<=0,0,('a. Personnel'!T8/H18))","v":0},"Percentage of Indirect Costs Against Total Project Costs",{"$f":"D36+G36","v":0},"*** The Percentage of Total Project Costs will: \n- highlight as yellow when => 10% of Total Costs \n- highlight red when => 15% of Total Costs"]
[null,"Additional Explanation (as needed):"]

{"sheet":"a. Personnel","index":2,"n_rows":52,"n_cols":21,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,1,2,20],[11,18,12,18],[1,18,1,20],[11,3,11,5],[11,6,11,8],[11,9,11,11],[1,1,1,2],[51,1,52,20],[11,2,12,2],[3,1,4,20],[50,1,50,4],[11,1,12,1],[11,20,12,20],[11,19,12,19],[11,12,11,14],[11,15,11,17],[49,1,49,2],[6,1,6,20],[9,1,9,20],[8,18,8,20]]}
[]
[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., rate \n    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. Each budget period 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":18},"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,"SOPO Task #","Position Title","Budget Period 1",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Budget Period 4",null,null,"Budget Period 5",null,null,"Project Total Hours","Project Total Dollars","Rate Basis"]
[null,null,null,"Time \n(Hrs.)","Hourly Rate\n($/Hr.)","Total Budget Period 1","Time \n(Hrs.)","Hourly Rate\n($/Hr.)","Total Budget Period 2","Time \n(Hrs.)","Hourly Rate\n($/Hr.)","Total Budget Period 3","Time \n(Hrs.)","Hourly Rate\n($/Hr.)","Total Budget Period 4","Time \n(Hrs.)","Hourly Rate\n($/Hr.)","Total Budget Period 5"]
[null,1,"Sr. Engineer (EXAMPLE!!!)",2000,85,{"$f":"D14*E14","v":170000},200,85,{"$f":"G14*H14","v":17000},200,85,{"$f":"J14*K14","v":17000},200,50,{"$f":"M14*N14","v":10000},200,50,{"$f":"P14*Q14","v":10000},{"$f":"D14+G14+J14","v":2400},{"$f":"_xlfn.IFS(OR(Instructions!$H$31=\"3 Budget Periods or Less\",Instructions!$H$31=\"Make Selection\"),F14+I14+L14,Instructions!$H$31=\"4 Budget Periods\",F14+I14+L14+O14,Instructions!$H$31=\"5 Budget Periods\",F14+I14+L14+O14+R14)","v":204000}]
[null,2,"Program Manager (EXAMPLE!!!)",1500,50,75000,150,50,7500,150,50,7500,0,0,0,0,0,0,{"$f":"D15+G15+J15","v":1800},{"$f":"_xlfn.IFS(OR(Instructions!$H$31=\"3 Budget Periods or Less\",Instructions!$H$31=\"Make Selection\"),F15+I15+L15,Instructions!$H$31=\"4 Budget Periods\",F15+I15+L15+O15,Instructions!$H$31=\"5 Budget Periods\",F15+I15+L15+O15+R15)","v":90000}]
[{"$nulls":5},{"$f":"D16*E16","v":0},null,null,{"$f":"G16*H16","v":0},null,null,{"$f":"J16*K16","v":0},null,null,{"$f":"M16*N16","v":0},null,null,{"$f":"P16*Q16","v":0},{"$f":"SUM(D16+G16+J16+M16+P16)","v":0},{"$f":"SUM(F16+I16+L16+O16+R16)","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(D17+G17+J17+M17+P17)","v":0},0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},{"$f":"D31*E31","v":0},null,null,{"$f":"G31*H31","v":0},null,null,{"$f":"J31*K31","v":0},null,null,{"$f":"M31*N31","v":0},null,null,{"$f":"P31*Q31","v":0},{"$f":"SUM(D31+G31+J31+M31+P31)","v":0},{"$f":"SUM(F31+I31+L31+O31+R31)","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"P41*Q41","v":0},0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"P42*Q42","v":0},0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},{"$f":"D47*E47","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},{"$f":"D48*E48","v":0},null,null,{"$f":"G48*H48","v":0},null,null,{"$f":"J48*K48","v":0},null,null,{"$f":"M48*N48","v":0},null,null,{"$f":"P48*Q48","v":0},0,0]
[{"$nulls":5},{"$f":"D49*E49","v":0},null,null,{"$f":"G49*H49","v":0},null,null,{"$f":"J49*K49","v":0},null,null,{"$f":"M49*N49","v":0},null,null,{"$f":"P49*Q49","v":0},0,0]
[null,"TOTAL PERSONNEL",null,{"$f":"SUM(D16:D49)","v":0},null,{"$f":"SUM(F16:F49)","v":0},{"$f":"SUM(G16:G49)","v":0},null,{"$f":"SUM(I16:I49)","v":0},{"$f":"SUM(J16:J49)","v":0},null,{"$f":"SUM(L16:L49)","v":0},{"$f":"SUM(M16:M49)","v":0},null,{"$f":"SUM(O16:O49)","v":0},{"$f":"SUM(P16:P49)","v":0},null,{"$f":"SUM(R16:R49)","v":0},{"$f":"SUM(D50+G50+J50+M50+P50)","v":0},{"$f":"F50 + I50+L50+O50+R50","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"b. Fringe","index":3,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,13],[2,1,2,20],[32,1,32,20],[33,1,33,20],[3,1,3,20],[25,1,25,20],[5,8,5,10],[5,11,5,13],[5,5,5,7],[5,14,5,16],[5,17,5,19],[7,1,7,4],[5,1,6,4],[8,1,8,4],[5,20,6,20],[19,1,19,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[31,1,31,20],[18,1,18,4],[17,1,17,4],[16,1,16,4],[15,1,15,4],[23,1,23,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[14,1,14,4],[13,1,13,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. Each budget period 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,"Budget Period 2",null,null,"Budget Period 3",null,null,"Budget Period 4",null,null,"Budget Period 5",null,null,"Total Project "]
[{"$nulls":5},"Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total"]
[null,"EXAMPLE!!! Sr. Engineer",null,null,null,170000,0.2,{"$f":"F8*G8","v":34000},10000,0.2,{"$f":"I8*J8","v":2000},10000,0.2,{"$f":"L8*M8","v":2000},10000,0.2,{"$f":"O8*P8","v":2000},10000,0.2,{"$f":"R8*S8","v":2000},{"$f":"_xlfn.IFS(OR(\nInstructions!$H$31=\"3 Budget Periods or Less\",Instructions!$H$31=\"Make Selection\"),H8+K8+N8,\nInstructions!$H$31=\"4 Budget Periods\",H8+K8+N8+Q8,\nInstructions!$H$31=\"5 Budget Periods\",H8+K8+N8+Q8+T8)","v":38000}]
[{"$nulls":7},{"$f":"G9*F9","v":0},null,null,0,null,null,0,null,null,0,null,null,{"$f":"R9*S9","v":0},{"$f":"SUM(H9+K9+N9+Q9+T9)","v":0}]
[{"$nulls":7},{"$f":"G10*F10","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"R13*S13","v":0},0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},{"$f":"G20*F20","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},{"$f":"G21*F21","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},{"$f":"G22*F22","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":7},{"$f":"G23*F23","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,"TOTAL FRINGE",null,null,null,{"$f":"SUM(F9:F23)","v":0},null,{"$f":"ROUND(SUM(H9:H23),0)","v":0},{"$f":"SUM(I9:I23)","v":0},null,{"$f":"ROUND(SUM(K9:K23),0)","v":0},{"$f":"SUM(L9:L23)","v":0},null,{"$f":"ROUND(SUM(N9:N23),0)","v":0},{"$f":"SUM(O9:O23)","v":0},null,{"$f":"ROUND(SUM(Q9:Q23),0)","v":0},{"$f":"SUM(R9:R23)","v":0},null,{"$f":"ROUND(SUM(T9:T23),0)","v":0},{"$f":"ROUND(SUM(H24+K24+N24+Q24+T24),0)","v":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 check (X) one of the options below and provide the requested information if not previously submitted."]
[]
[null,null,null,"  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,null,"  There is not a current federally approved rate agreement negotiated and available.**"]
[]
[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,"Additional Explanation (as necessary): Please use this box (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. "]

{"sheet":"c. Travel","index":4,"n_rows":152,"n_cols":14,"rows_kept":152,"cut":false,"hidden":false,"merged":[[23,3,23,13],[3,1,3,13],[151,1,152,13],[2,1,2,13],[1,1,1,2],[6,3,6,13],[36,3,36,13],[64,3,64,13],[92,3,92,13],[120,3,120,13],[149,1,149,2],[147,1,147,2],[119,1,119,2],[91,1,91,2],[63,1,63,2],[35,1,35,2]]}
[]
[null,"Detailed Budget Justification "]
[null,"c. Travel"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Identify Foreign and Domestic Travel as separate 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), State Department Foreign Per Diem Rates (https://allowances.state.gov/web920/per_diem.asp), \n               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's during normal business operations as a result of the organizations 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) For International Travel please vist https://allowances.state.gov/web920/per_diem.asp?\n           b) 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 (or City and Country for International travel) 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. Each budget period is rounded to the nearest dollar.\n10. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"SOPO 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)","Cost per Trip ($)","Basis for Estimating Costs"]
[null,null,"Domestic Travel","                                                             Budget Period 1"]
[null,1,"EXAMPLE!!!  Visit to PV manufacturer","Dallas, TX","Denver, CO",2,4,3,500,200,200,80,{"$f":"_xlfn.IFS(\nH8=0,(I8*F8)+J8+(L8*0.75)*G8*F8,\nAND(H8>0,H8<2),(I8*F8)+J8+(K8*H8*F8)+(L8*0.75)*G8*F8,\nH8>=2,((I8*F8)+J8+(K8*H8*F8)+(L8*0.75)*2*F8)+(L8*(G8-2)*F8))","v":2960},"Current GSA rates"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH9=0,(I9*F9)+J9+(L9*0.75)*G9*F9,\nAND(H9>0,H9<2),(I9*F9)+J9+(K9*H9*F9)+(L9*0.75)*G9*F9,\nH9>=2,((I9*F9)+J9+(K9*H9*F9)+(L9*0.75)*2*F9)+(L9*(G9-2)*F9))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH10=0,(I10*F10)+J10+(L10*0.75)*G10*F10,\nAND(H10>0,H10<2),(I10*F10)+J10+(K10*H10*F10)+(L10*0.75)*G10*F10,\nH10>=2,((I10*F10)+J10+(K10*H10*F10)+(L10*0.75)*2*F10)+(L10*(G10-2)*F10))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH11=0,(I11*F11)+J11+(L11*0.75)*G11*F11,\nAND(H11>0,H11<2),(I11*F11)+J11+(K11*H11*F11)+(L11*0.75)*G11*F11,\nH11>=2,((I11*F11)+J11+(K11*H11*F11)+(L11*0.75)*2*F11)+(L11*(G11-2)*F11))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH12=0,(I12*F12)+J12+(L12*0.75)*G12*F12,\nAND(H12>0,H12<2),(I12*F12)+J12+(K12*H12*F12)+(L12*0.75)*G12*F12,\nH12>=2,((I12*F12)+J12+(K12*H12*F12)+(L12*0.75)*2*F12)+(L12*(G12-2)*F12))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH13=0,(I13*F13)+J13+(L13*0.75)*G13*F13,\nAND(H13>0,H13<2),(I13*F13)+J13+(K13*H13*F13)+(L13*0.75)*G13*F13,\nH13>=2,((I13*F13)+J13+(K13*H13*F13)+(L13*0.75)*2*F13)+(L13*(G13-2)*F13))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH14=0,(I14*F14)+J14+(L14*0.75)*G14*F14,\nAND(H14>0,H14<2),(I14*F14)+J14+(K14*H14*F14)+(L14*0.75)*G14*F14,\nH14>=2,((I14*F14)+J14+(K14*H14*F14)+(L14*0.75)*2*F14)+(L14*(G14-2)*F14))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH15=0,(I15*F15)+J15+(L15*0.75)*G15*F15,\nAND(H15>0,H15<2),(I15*F15)+J15+(K15*H15*F15)+(L15*0.75)*G15*F15,\nH15>=2,((I15*F15)+J15+(K15*H15*F15)+(L15*0.75)*2*F15)+(L15*(G15-2)*F15))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH16=0,(I16*F16)+J16+(L16*0.75)*G16*F16,\nAND(H16>0,H16<2),(I16*F16)+J16+(K16*H16*F16)+(L16*0.75)*G16*F16,\nH16>=2,((I16*F16)+J16+(K16*H16*F16)+(L16*0.75)*2*F16)+(L16*(G16-2)*F16))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH17=0,(I17*F17)+J17+(L17*0.75)*G17*F17,\nAND(H17>0,H17<2),(I17*F17)+J17+(K17*H17*F17)+(L17*0.75)*G17*F17,\nH17>=2,((I17*F17)+J17+(K17*H17*F17)+(L17*0.75)*2*F17)+(L17*(G17-2)*F17))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH18=0,(I18*F18)+J18+(L18*0.75)*G18*F18,\nAND(H18>0,H18<2),(I18*F18)+J18+(K18*H18*F18)+(L18*0.75)*G18*F18,\nH18>=2,((I18*F18)+J18+(K18*H18*F18)+(L18*0.75)*2*F18)+(L18*(G18-2)*F18))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH19=0,(I19*F19)+J19+(L19*0.75)*G19*F19,\nAND(H19>0,H19<2),(I19*F19)+J19+(K19*H19*F19)+(L19*0.75)*G19*F19,\nH19>=2,((I19*F19)+J19+(K19*H19*F19)+(L19*0.75)*2*F19)+(L19*(G19-2)*F19))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH20=0,(I20*F20)+J20+(L20*0.75)*G20*F20,\nAND(H20>0,H20<2),(I20*F20)+J20+(K20*H20*F20)+(L20*0.75)*G20*F20,\nH20>=2,((I20*F20)+J20+(K20*H20*F20)+(L20*0.75)*2*F20)+(L20*(G20-2)*F20))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH21=0,(I21*F21)+J21+(L21*0.75)*G21*F21,\nAND(H21>0,H21<2),(I21*F21)+J21+(K21*H21*F21)+(L21*0.75)*G21*F21,\nH21>=2,((I21*F21)+J21+(K21*H21*F21)+(L21*0.75)*2*F21)+(L21*(G21-2)*F21))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH22=0,(I22*F22)+J22+(L22*0.75)*G22*F22,\nAND(H22>0,H22<2),(I22*F22)+J22+(K22*H22*F22)+(L22*0.75)*G22*F22,\nH22>=2,((I22*F22)+J22+(K22*H22*F22)+(L22*0.75)*2*F22)+(L22*(G22-2)*F22))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH23=0,(I23*F23)+J23+(L23*0.75)*G23*F23,\nAND(H23>0,H23<2),(I23*F23)+J23+(K23*H23*F23)+(L23*0.75)*G23*F23,\nH23>=2,((I23*F23)+J23+(K23*H23*F23)+(L23*0.75)*2*F23)+(L23*(G23-2)*F23))","v":0}]
[null,null,"International Travel"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH25=0,(I25*F25)+J25+(L25*0.75)*G25*F25,\nAND(H25>0,H25<2),(I25*F25)+J25+(K25*H25*F25)+(L25*0.75)*G25*F25,\nH25>=2,((I25*F25)+J25+(K25*H25*F25)+(L25*0.75)*2*F25)+(L25*(G25-2)*F25))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH26=0,(I26*F26)+J26+(L26*0.75)*G26*F26,\nAND(H26>0,H26<2),(I26*F26)+J26+(K26*H26*F26)+(L26*0.75)*G26*F26,\nH26>=2,((I26*F26)+J26+(K26*H26*F26)+(L26*0.75)*2*F26)+(L26*(G26-2)*F26))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH27=0,(I27*F27)+J27+(L27*0.75)*G27*F27,\nAND(H27>0,H27<2),(I27*F27)+J27+(K27*H27*F27)+(L27*0.75)*G27*F27,\nH27>=2,((I27*F27)+J27+(K27*H27*F27)+(L27*0.75)*2*F27)+(L27*(G27-2)*F27))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH28=0,(I28*F28)+J28+(L28*0.75)*G28*F28,\nAND(H28>0,H28<2),(I28*F28)+J28+(K28*H28*F28)+(L28*0.75)*G28*F28,\nH28>=2,((I28*F28)+J28+(K28*H28*F28)+(L28*0.75)*2*F28)+(L28*(G28-2)*F28))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH29=0,(I29*F29)+J29+(L29*0.75)*G29*F29,\nAND(H29>0,H29<2),(I29*F29)+J29+(K29*H29*F29)+(L29*0.75)*G29*F29,\nH29>=2,((I29*F29)+J29+(K29*H29*F29)+(L29*0.75)*2*F29)+(L29*(G29-2)*F29))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH30=0,(I30*F30)+J30+(L30*0.75)*G30*F30,\nAND(H30>0,H30<2),(I30*F30)+J30+(K30*H30*F30)+(L30*0.75)*G30*F30,\nH30>=2,((I30*F30)+J30+(K30*H30*F30)+(L30*0.75)*2*F30)+(L30*(G30-2)*F30))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH31=0,(I31*F31)+J31+(L31*0.75)*G31*F31,\nAND(H31>0,H31<2),(I31*F31)+J31+(K31*H31*F31)+(L31*0.75)*G31*F31,\nH31>=2,((I31*F31)+J31+(K31*H31*F31)+(L31*0.75)*2*F31)+(L31*(G31-2)*F31))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH32=0,(I32*F32)+J32+(L32*0.75)*G32*F32,\nAND(H32>0,H32<2),(I32*F32)+J32+(K32*H32*F32)+(L32*0.75)*G32*F32,\nH32>=2,((I32*F32)+J32+(K32*H32*F32)+(L32*0.75)*2*F32)+(L32*(G32-2)*F32))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH33=0,(I33*F33)+J33+(L33*0.75)*G33*F33,\nAND(H33>0,H33<2),(I33*F33)+J33+(K33*H33*F33)+(L33*0.75)*G33*F33,\nH33>=2,((I33*F33)+J33+(K33*H33*F33)+(L33*0.75)*2*F33)+(L33*(G33-2)*F33))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH34=0,(I34*F34)+J34+(L34*0.75)*G34*F34,\nAND(H34>0,H34<2),(I34*F34)+J34+(K34*H34*F34)+(L34*0.75)*G34*F34,\nH34>=2,((I34*F34)+J34+(K34*H34*F34)+(L34*0.75)*2*F34)+(L34*(G34-2)*F34))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH35=0,(I35*F35)+J35+(L35*0.75)*G35*F35,\nAND(H35>0,H35<2),(I35*F35)+J35+(K35*H35*F35)+(L35*0.75)*G35*F35,\nH35>=2,((I35*F35)+J35+(K35*H35*F35)+(L35*0.75)*2*F35)+(L35*(G35-2)*F35))","v":0}]
[null,"Budget Period 1 Total",{"$nulls":10},{"$f":"SUM(M9:M23)+SUM(M25:M35)","v":0}]
[null,null,"Domestic Travel","                                                             Budget Period 2"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH38=0,(I38*F38)+J38+(L38*0.75)*G38*F38,\nAND(H38>0,H38<2),(I38*F38)+J38+(K38*H38*F38)+(L38*0.75)*G38*F38,\nH38>=2,((I38*F38)+J38+(K38*H38*F38)+(L38*0.75)*2*F38)+(L38*(G38-2)*F38))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH39=0,(I39*F39)+J39+(L39*0.75)*G39*F39,\nAND(H39>0,H39<2),(I39*F39)+J39+(K39*H39*F39)+(L39*0.75)*G39*F39,\nH39>=2,((I39*F39)+J39+(K39*H39*F39)+(L39*0.75)*2*F39)+(L39*(G39-2)*F39))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH40=0,(I40*F40)+J40+(L40*0.75)*G40*F40,\nAND(H40>0,H40<2),(I40*F40)+J40+(K40*H40*F40)+(L40*0.75)*G40*F40,\nH40>=2,((I40*F40)+J40+(K40*H40*F40)+(L40*0.75)*2*F40)+(L40*(G40-2)*F40))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH41=0,(I41*F41)+J41+(L41*0.75)*G41*F41,\nAND(H41>0,H41<2),(I41*F41)+J41+(K41*H41*F41)+(L41*0.75)*G41*F41,\nH41>=2,((I41*F41)+J41+(K41*H41*F41)+(L41*0.75)*2*F41)+(L41*(G41-2)*F41))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH42=0,(I42*F42)+J42+(L42*0.75)*G42*F42,\nAND(H42>0,H42<2),(I42*F42)+J42+(K42*H42*F42)+(L42*0.75)*G42*F42,\nH42>=2,((I42*F42)+J42+(K42*H42*F42)+(L42*0.75)*2*F42)+(L42*(G42-2)*F42))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH43=0,(I43*F43)+J43+(L43*0.75)*G43*F43,\nAND(H43>0,H43<2),(I43*F43)+J43+(K43*H43*F43)+(L43*0.75)*G43*F43,\nH43>=2,((I43*F43)+J43+(K43*H43*F43)+(L43*0.75)*2*F43)+(L43*(G43-2)*F43))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH44=0,(I44*F44)+J44+(L44*0.75)*G44*F44,\nAND(H44>0,H44<2),(I44*F44)+J44+(K44*H44*F44)+(L44*0.75)*G44*F44,\nH44>=2,((I44*F44)+J44+(K44*H44*F44)+(L44*0.75)*2*F44)+(L44*(G44-2)*F44))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH45=0,(I45*F45)+J45+(L45*0.75)*G45*F45,\nAND(H45>0,H45<2),(I45*F45)+J45+(K45*H45*F45)+(L45*0.75)*G45*F45,\nH45>=2,((I45*F45)+J45+(K45*H45*F45)+(L45*0.75)*2*F45)+(L45*(G45-2)*F45))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH46=0,(I46*F46)+J46+(L46*0.75)*G46*F46,\nAND(H46>0,H46<2),(I46*F46)+J46+(K46*H46*F46)+(L46*0.75)*G46*F46,\nH46>=2,((I46*F46)+J46+(K46*H46*F46)+(L46*0.75)*2*F46)+(L46*(G46-2)*F46))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH47=0,(I47*F47)+J47+(L47*0.75)*G47*F47,\nAND(H47>0,H47<2),(I47*F47)+J47+(K47*H47*F47)+(L47*0.75)*G47*F47,\nH47>=2,((I47*F47)+J47+(K47*H47*F47)+(L47*0.75)*2*F47)+(L47*(G47-2)*F47))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH48=0,(I48*F48)+J48+(L48*0.75)*G48*F48,\nAND(H48>0,H48<2),(I48*F48)+J48+(K48*H48*F48)+(L48*0.75)*G48*F48,\nH48>=2,((I48*F48)+J48+(K48*H48*F48)+(L48*0.75)*2*F48)+(L48*(G48-2)*F48))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH49=0,(I49*F49)+J49+(L49*0.75)*G49*F49,\nAND(H49>0,H49<2),(I49*F49)+J49+(K49*H49*F49)+(L49*0.75)*G49*F49,\nH49>=2,((I49*F49)+J49+(K49*H49*F49)+(L49*0.75)*2*F49)+(L49*(G49-2)*F49))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH50=0,(I50*F50)+J50+(L50*0.75)*G50*F50,\nAND(H50>0,H50<2),(I50*F50)+J50+(K50*H50*F50)+(L50*0.75)*G50*F50,\nH50>=2,((I50*F50)+J50+(K50*H50*F50)+(L50*0.75)*2*F50)+(L50*(G50-2)*F50))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH51=0,(I51*F51)+J51+(L51*0.75)*G51*F51,\nAND(H51>0,H51<2),(I51*F51)+J51+(K51*H51*F51)+(L51*0.75)*G51*F51,\nH51>=2,((I51*F51)+J51+(K51*H51*F51)+(L51*0.75)*2*F51)+(L51*(G51-2)*F51))","v":0}]
[null,null,"International Travel"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH53=0,(I53*F53)+J53+(L53*0.75)*G53*F53,\nAND(H53>0,H53<2),(I53*F53)+J53+(K53*H53*F53)+(L53*0.75)*G53*F53,\nH53>=2,((I53*F53)+J53+(K53*H53*F53)+(L53*0.75)*2*F53)+(L53*(G53-2)*F53))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH54=0,(I54*F54)+J54+(L54*0.75)*G54*F54,\nAND(H54>0,H54<2),(I54*F54)+J54+(K54*H54*F54)+(L54*0.75)*G54*F54,\nH54>=2,((I54*F54)+J54+(K54*H54*F54)+(L54*0.75)*2*F54)+(L54*(G54-2)*F54))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH55=0,(I55*F55)+J55+(L55*0.75)*G55*F55,\nAND(H55>0,H55<2),(I55*F55)+J55+(K55*H55*F55)+(L55*0.75)*G55*F55,\nH55>=2,((I55*F55)+J55+(K55*H55*F55)+(L55*0.75)*2*F55)+(L55*(G55-2)*F55))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH56=0,(I56*F56)+J56+(L56*0.75)*G56*F56,\nAND(H56>0,H56<2),(I56*F56)+J56+(K56*H56*F56)+(L56*0.75)*G56*F56,\nH56>=2,((I56*F56)+J56+(K56*H56*F56)+(L56*0.75)*2*F56)+(L56*(G56-2)*F56))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH57=0,(I57*F57)+J57+(L57*0.75)*G57*F57,\nAND(H57>0,H57<2),(I57*F57)+J57+(K57*H57*F57)+(L57*0.75)*G57*F57,\nH57>=2,((I57*F57)+J57+(K57*H57*F57)+(L57*0.75)*2*F57)+(L57*(G57-2)*F57))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH58=0,(I58*F58)+J58+(L58*0.75)*G58*F58,\nAND(H58>0,H58<2),(I58*F58)+J58+(K58*H58*F58)+(L58*0.75)*G58*F58,\nH58>=2,((I58*F58)+J58+(K58*H58*F58)+(L58*0.75)*2*F58)+(L58*(G58-2)*F58))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH59=0,(I59*F59)+J59+(L59*0.75)*G59*F59,\nAND(H59>0,H59<2),(I59*F59)+J59+(K59*H59*F59)+(L59*0.75)*G59*F59,\nH59>=2,((I59*F59)+J59+(K59*H59*F59)+(L59*0.75)*2*F59)+(L59*(G59-2)*F59))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH60=0,(I60*F60)+J60+(L60*0.75)*G60*F60,\nAND(H60>0,H60<2),(I60*F60)+J60+(K60*H60*F60)+(L60*0.75)*G60*F60,\nH60>=2,((I60*F60)+J60+(K60*H60*F60)+(L60*0.75)*2*F60)+(L60*(G60-2)*F60))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH61=0,(I61*F61)+J61+(L61*0.75)*G61*F61,\nAND(H61>0,H61<2),(I61*F61)+J61+(K61*H61*F61)+(L61*0.75)*G61*F61,\nH61>=2,((I61*F61)+J61+(K61*H61*F61)+(L61*0.75)*2*F61)+(L61*(G61-2)*F61))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH62=0,(I62*F62)+J62+(L62*0.75)*G62*F62,\nAND(H62>0,H62<2),(I62*F62)+J62+(K62*H62*F62)+(L62*0.75)*G62*F62,\nH62>=2,((I62*F62)+J62+(K62*H62*F62)+(L62*0.75)*2*F62)+(L62*(G62-2)*F62))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH63=0,(I63*F63)+J63+(L63*0.75)*G63*F63,\nAND(H63>0,H63<2),(I63*F63)+J63+(K63*H63*F63)+(L63*0.75)*G63*F63,\nH63>=2,((I63*F63)+J63+(K63*H63*F63)+(L63*0.75)*2*F63)+(L63*(G63-2)*F63))","v":0}]
[null,"Budget Period 2 Total",{"$nulls":10},{"$f":"SUM(M38:M51)+SUM(M53:M63)","v":0}]
[null,null,"Domestic Travel","                                                              Budget Period 3"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH66=0,(I66*F66)+J66+(L66*0.75)*G66*F66,\nAND(H66>0,H66<2),(I66*F66)+J66+(K66*H66*F66)+(L66*0.75)*G66*F66,\nH66>=2,((I66*F66)+J66+(K66*H66*F66)+(L66*0.75)*2*F66)+(L66*(G66-2)*F66))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH67=0,(I67*F67)+J67+(L67*0.75)*G67*F67,\nAND(H67>0,H67<2),(I67*F67)+J67+(K67*H67*F67)+(L67*0.75)*G67*F67,\nH67>=2,((I67*F67)+J67+(K67*H67*F67)+(L67*0.75)*2*F67)+(L67*(G67-2)*F67))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH68=0,(I68*F68)+J68+(L68*0.75)*G68*F68,\nAND(H68>0,H68<2),(I68*F68)+J68+(K68*H68*F68)+(L68*0.75)*G68*F68,\nH68>=2,((I68*F68)+J68+(K68*H68*F68)+(L68*0.75)*2*F68)+(L68*(G68-2)*F68))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH69=0,(I69*F69)+J69+(L69*0.75)*G69*F69,\nAND(H69>0,H69<2),(I69*F69)+J69+(K69*H69*F69)+(L69*0.75)*G69*F69,\nH69>=2,((I69*F69)+J69+(K69*H69*F69)+(L69*0.75)*2*F69)+(L69*(G69-2)*F69))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH70=0,(I70*F70)+J70+(L70*0.75)*G70*F70,\nAND(H70>0,H70<2),(I70*F70)+J70+(K70*H70*F70)+(L70*0.75)*G70*F70,\nH70>=2,((I70*F70)+J70+(K70*H70*F70)+(L70*0.75)*2*F70)+(L70*(G70-2)*F70))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH71=0,(I71*F71)+J71+(L71*0.75)*G71*F71,\nAND(H71>0,H71<2),(I71*F71)+J71+(K71*H71*F71)+(L71*0.75)*G71*F71,\nH71>=2,((I71*F71)+J71+(K71*H71*F71)+(L71*0.75)*2*F71)+(L71*(G71-2)*F71))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH72=0,(I72*F72)+J72+(L72*0.75)*G72*F72,\nAND(H72>0,H72<2),(I72*F72)+J72+(K72*H72*F72)+(L72*0.75)*G72*F72,\nH72>=2,((I72*F72)+J72+(K72*H72*F72)+(L72*0.75)*2*F72)+(L72*(G72-2)*F72))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH73=0,(I73*F73)+J73+(L73*0.75)*G73*F73,\nAND(H73>0,H73<2),(I73*F73)+J73+(K73*H73*F73)+(L73*0.75)*G73*F73,\nH73>=2,((I73*F73)+J73+(K73*H73*F73)+(L73*0.75)*2*F73)+(L73*(G73-2)*F73))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH74=0,(I74*F74)+J74+(L74*0.75)*G74*F74,\nAND(H74>0,H74<2),(I74*F74)+J74+(K74*H74*F74)+(L74*0.75)*G74*F74,\nH74>=2,((I74*F74)+J74+(K74*H74*F74)+(L74*0.75)*2*F74)+(L74*(G74-2)*F74))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH75=0,(I75*F75)+J75+(L75*0.75)*G75*F75,\nAND(H75>0,H75<2),(I75*F75)+J75+(K75*H75*F75)+(L75*0.75)*G75*F75,\nH75>=2,((I75*F75)+J75+(K75*H75*F75)+(L75*0.75)*2*F75)+(L75*(G75-2)*F75))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH76=0,(I76*F76)+J76+(L76*0.75)*G76*F76,\nAND(H76>0,H76<2),(I76*F76)+J76+(K76*H76*F76)+(L76*0.75)*G76*F76,\nH76>=2,((I76*F76)+J76+(K76*H76*F76)+(L76*0.75)*2*F76)+(L76*(G76-2)*F76))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH77=0,(I77*F77)+J77+(L77*0.75)*G77*F77,\nAND(H77>0,H77<2),(I77*F77)+J77+(K77*H77*F77)+(L77*0.75)*G77*F77,\nH77>=2,((I77*F77)+J77+(K77*H77*F77)+(L77*0.75)*2*F77)+(L77*(G77-2)*F77))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH78=0,(I78*F78)+J78+(L78*0.75)*G78*F78,\nAND(H78>0,H78<2),(I78*F78)+J78+(K78*H78*F78)+(L78*0.75)*G78*F78,\nH78>=2,((I78*F78)+J78+(K78*H78*F78)+(L78*0.75)*2*F78)+(L78*(G78-2)*F78))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH79=0,(I79*F79)+J79+(L79*0.75)*G79*F79,\nAND(H79>0,H79<2),(I79*F79)+J79+(K79*H79*F79)+(L79*0.75)*G79*F79,\nH79>=2,((I79*F79)+J79+(K79*H79*F79)+(L79*0.75)*2*F79)+(L79*(G79-2)*F79))","v":0}]
[null,null,"International Travel"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH81=0,(I81*F81)+J81+(L81*0.75)*G81*F81,\nAND(H81>0,H81<2),(I81*F81)+J81+(K81*H81*F81)+(L81*0.75)*G81*F81,\nH81>=2,((I81*F81)+J81+(K81*H81*F81)+(L81*0.75)*2*F81)+(L81*(G81-2)*F81))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH82=0,(I82*F82)+J82+(L82*0.75)*G82*F82,\nAND(H82>0,H82<2),(I82*F82)+J82+(K82*H82*F82)+(L82*0.75)*G82*F82,\nH82>=2,((I82*F82)+J82+(K82*H82*F82)+(L82*0.75)*2*F82)+(L82*(G82-2)*F82))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH83=0,(I83*F83)+J83+(L83*0.75)*G83*F83,\nAND(H83>0,H83<2),(I83*F83)+J83+(K83*H83*F83)+(L83*0.75)*G83*F83,\nH83>=2,((I83*F83)+J83+(K83*H83*F83)+(L83*0.75)*2*F83)+(L83*(G83-2)*F83))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH84=0,(I84*F84)+J84+(L84*0.75)*G84*F84,\nAND(H84>0,H84<2),(I84*F84)+J84+(K84*H84*F84)+(L84*0.75)*G84*F84,\nH84>=2,((I84*F84)+J84+(K84*H84*F84)+(L84*0.75)*2*F84)+(L84*(G84-2)*F84))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH85=0,(I85*F85)+J85+(L85*0.75)*G85*F85,\nAND(H85>0,H85<2),(I85*F85)+J85+(K85*H85*F85)+(L85*0.75)*G85*F85,\nH85>=2,((I85*F85)+J85+(K85*H85*F85)+(L85*0.75)*2*F85)+(L85*(G85-2)*F85))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH86=0,(I86*F86)+J86+(L86*0.75)*G86*F86,\nAND(H86>0,H86<2),(I86*F86)+J86+(K86*H86*F86)+(L86*0.75)*G86*F86,\nH86>=2,((I86*F86)+J86+(K86*H86*F86)+(L86*0.75)*2*F86)+(L86*(G86-2)*F86))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH87=0,(I87*F87)+J87+(L87*0.75)*G87*F87,\nAND(H87>0,H87<2),(I87*F87)+J87+(K87*H87*F87)+(L87*0.75)*G87*F87,\nH87>=2,((I87*F87)+J87+(K87*H87*F87)+(L87*0.75)*2*F87)+(L87*(G87-2)*F87))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH88=0,(I88*F88)+J88+(L88*0.75)*G88*F88,\nAND(H88>0,H88<2),(I88*F88)+J88+(K88*H88*F88)+(L88*0.75)*G88*F88,\nH88>=2,((I88*F88)+J88+(K88*H88*F88)+(L88*0.75)*2*F88)+(L88*(G88-2)*F88))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH89=0,(I89*F89)+J89+(L89*0.75)*G89*F89,\nAND(H89>0,H89<2),(I89*F89)+J89+(K89*H89*F89)+(L89*0.75)*G89*F89,\nH89>=2,((I89*F89)+J89+(K89*H89*F89)+(L89*0.75)*2*F89)+(L89*(G89-2)*F89))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH90=0,(I90*F90)+J90+(L90*0.75)*G90*F90,\nAND(H90>0,H90<2),(I90*F90)+J90+(K90*H90*F90)+(L90*0.75)*G90*F90,\nH90>=2,((I90*F90)+J90+(K90*H90*F90)+(L90*0.75)*2*F90)+(L90*(G90-2)*F90))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH91=0,(I91*F91)+J91+(L91*0.75)*G91*F91,\nAND(H91>0,H91<2),(I91*F91)+J91+(K91*H91*F91)+(L91*0.75)*G91*F91,\nH91>=2,((I91*F91)+J91+(K91*H91*F91)+(L91*0.75)*2*F91)+(L91*(G91-2)*F91))","v":0}]
[null,"Budget Period 3 Total",{"$nulls":10},{"$f":"SUM(M66:M79)+SUM(M81:M91)","v":0}]
[null,null,"Domestic Travel","                                                              Budget Period 4"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH94=0,(I94*F94)+J94+(L94*0.75)*G94*F94,\nAND(H94>0,H94<2),(I94*F94)+J94+(K94*H94*F94)+(L94*0.75)*G94*F94,\nH94>=2,((I94*F94)+J94+(K94*H94*F94)+(L94*0.75)*2*F94)+(L94*(G94-2)*F94))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH95=0,(I95*F95)+J95+(L95*0.75)*G95*F95,\nAND(H95>0,H95<2),(I95*F95)+J95+(K95*H95*F95)+(L95*0.75)*G95*F95,\nH95>=2,((I95*F95)+J95+(K95*H95*F95)+(L95*0.75)*2*F95)+(L95*(G95-2)*F95))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH96=0,(I96*F96)+J96+(L96*0.75)*G96*F96,\nAND(H96>0,H96<2),(I96*F96)+J96+(K96*H96*F96)+(L96*0.75)*G96*F96,\nH96>=2,((I96*F96)+J96+(K96*H96*F96)+(L96*0.75)*2*F96)+(L96*(G96-2)*F96))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH97=0,(I97*F97)+J97+(L97*0.75)*G97*F97,\nAND(H97>0,H97<2),(I97*F97)+J97+(K97*H97*F97)+(L97*0.75)*G97*F97,\nH97>=2,((I97*F97)+J97+(K97*H97*F97)+(L97*0.75)*2*F97)+(L97*(G97-2)*F97))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH98=0,(I98*F98)+J98+(L98*0.75)*G98*F98,\nAND(H98>0,H98<2),(I98*F98)+J98+(K98*H98*F98)+(L98*0.75)*G98*F98,\nH98>=2,((I98*F98)+J98+(K98*H98*F98)+(L98*0.75)*2*F98)+(L98*(G98-2)*F98))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH99=0,(I99*F99)+J99+(L99*0.75)*G99*F99,\nAND(H99>0,H99<2),(I99*F99)+J99+(K99*H99*F99)+(L99*0.75)*G99*F99,\nH99>=2,((I99*F99)+J99+(K99*H99*F99)+(L99*0.75)*2*F99)+(L99*(G99-2)*F99))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH100=0,(I100*F100)+J100+(L100*0.75)*G100*F100,\nAND(H100>0,H100<2),(I100*F100)+J100+(K100*H100*F100)+(L100*0.75)*G100*F100,\nH100>=2,((I100*F100)+J100+(K100*H100*F100)+(L100*0.75)*2*F100)+(L100*(G100-2)*F100))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH101=0,(I101*F101)+J101+(L101*0.75)*G101*F101,\nAND(H101>0,H101<2),(I101*F101)+J101+(K101*H101*F101)+(L101*0.75)*G101*F101,\nH101>=2,((I101*F101)+J101+(K101*H101*F101)+(L101*0.75)*2*F101)+(L101*(G101-2)*F101))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH102=0,(I102*F102)+J102+(L102*0.75)*G102*F102,\nAND(H102>0,H102<2),(I102*F102)+J102+(K102*H102*F102)+(L102*0.75)*G102*F102,\nH102>=2,((I102*F102)+J102+(K102*H102*F102)+(L102*0.75)*2*F102)+(L102*(G102-2)*F102))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH103=0,(I103*F103)+J103+(L103*0.75)*G103*F103,\nAND(H103>0,H103<2),(I103*F103)+J103+(K103*H103*F103)+(L103*0.75)*G103*F103,\nH103>=2,((I103*F103)+J103+(K103*H103*F103)+(L103*0.75)*2*F103)+(L103*(G103-2)*F103))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH104=0,(I104*F104)+J104+(L104*0.75)*G104*F104,\nAND(H104>0,H104<2),(I104*F104)+J104+(K104*H104*F104)+(L104*0.75)*G104*F104,\nH104>=2,((I104*F104)+J104+(K104*H104*F104)+(L104*0.75)*2*F104)+(L104*(G104-2)*F104))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH105=0,(I105*F105)+J105+(L105*0.75)*G105*F105,\nAND(H105>0,H105<2),(I105*F105)+J105+(K105*H105*F105)+(L105*0.75)*G105*F105,\nH105>=2,((I105*F105)+J105+(K105*H105*F105)+(L105*0.75)*2*F105)+(L105*(G105-2)*F105))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH106=0,(I106*F106)+J106+(L106*0.75)*G106*F106,\nAND(H106>0,H106<2),(I106*F106)+J106+(K106*H106*F106)+(L106*0.75)*G106*F106,\nH106>=2,((I106*F106)+J106+(K106*H106*F106)+(L106*0.75)*2*F106)+(L106*(G106-2)*F106))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH107=0,(I107*F107)+J107+(L107*0.75)*G107*F107,\nAND(H107>0,H107<2),(I107*F107)+J107+(K107*H107*F107)+(L107*0.75)*G107*F107,\nH107>=2,((I107*F107)+J107+(K107*H107*F107)+(L107*0.75)*2*F107)+(L107*(G107-2)*F107))","v":0}]
[null,null,"International Travel"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH109=0,(I109*F109)+J109+(L109*0.75)*G109*F109,\nAND(H109>0,H109<2),(I109*F109)+J109+(K109*H109*F109)+(L109*0.75)*G109*F109,\nH109>=2,((I109*F109)+J109+(K109*H109*F109)+(L109*0.75)*2*F109)+(L109*(G109-2)*F109))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH110=0,(I110*F110)+J110+(L110*0.75)*G110*F110,\nAND(H110>0,H110<2),(I110*F110)+J110+(K110*H110*F110)+(L110*0.75)*G110*F110,\nH110>=2,((I110*F110)+J110+(K110*H110*F110)+(L110*0.75)*2*F110)+(L110*(G110-2)*F110))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH111=0,(I111*F111)+J111+(L111*0.75)*G111*F111,\nAND(H111>0,H111<2),(I111*F111)+J111+(K111*H111*F111)+(L111*0.75)*G111*F111,\nH111>=2,((I111*F111)+J111+(K111*H111*F111)+(L111*0.75)*2*F111)+(L111*(G111-2)*F111))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH112=0,(I112*F112)+J112+(L112*0.75)*G112*F112,\nAND(H112>0,H112<2),(I112*F112)+J112+(K112*H112*F112)+(L112*0.75)*G112*F112,\nH112>=2,((I112*F112)+J112+(K112*H112*F112)+(L112*0.75)*2*F112)+(L112*(G112-2)*F112))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH113=0,(I113*F113)+J113+(L113*0.75)*G113*F113,\nAND(H113>0,H113<2),(I113*F113)+J113+(K113*H113*F113)+(L113*0.75)*G113*F113,\nH113>=2,((I113*F113)+J113+(K113*H113*F113)+(L113*0.75)*2*F113)+(L113*(G113-2)*F113))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH114=0,(I114*F114)+J114+(L114*0.75)*G114*F114,\nAND(H114>0,H114<2),(I114*F114)+J114+(K114*H114*F114)+(L114*0.75)*G114*F114,\nH114>=2,((I114*F114)+J114+(K114*H114*F114)+(L114*0.75)*2*F114)+(L114*(G114-2)*F114))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH115=0,(I115*F115)+J115+(L115*0.75)*G115*F115,\nAND(H115>0,H115<2),(I115*F115)+J115+(K115*H115*F115)+(L115*0.75)*G115*F115,\nH115>=2,((I115*F115)+J115+(K115*H115*F115)+(L115*0.75)*2*F115)+(L115*(G115-2)*F115))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH116=0,(I116*F116)+J116+(L116*0.75)*G116*F116,\nAND(H116>0,H116<2),(I116*F116)+J116+(K116*H116*F116)+(L116*0.75)*G116*F116,\nH116>=2,((I116*F116)+J116+(K116*H116*F116)+(L116*0.75)*2*F116)+(L116*(G116-2)*F116))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH117=0,(I117*F117)+J117+(L117*0.75)*G117*F117,\nAND(H117>0,H117<2),(I117*F117)+J117+(K117*H117*F117)+(L117*0.75)*G117*F117,\nH117>=2,((I117*F117)+J117+(K117*H117*F117)+(L117*0.75)*2*F117)+(L117*(G117-2)*F117))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH118=0,(I118*F118)+J118+(L118*0.75)*G118*F118,\nAND(H118>0,H118<2),(I118*F118)+J118+(K118*H118*F118)+(L118*0.75)*G118*F118,\nH118>=2,((I118*F118)+J118+(K118*H118*F118)+(L118*0.75)*2*F118)+(L118*(G118-2)*F118))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH119=0,(I119*F119)+J119+(L119*0.75)*G119*F119,\nAND(H119>0,H119<2),(I119*F119)+J119+(K119*H119*F119)+(L119*0.75)*G119*F119,\nH119>=2,((I119*F119)+J119+(K119*H119*F119)+(L119*0.75)*2*F119)+(L119*(G119-2)*F119))","v":0}]
[null,"Budget Period 4 Total",{"$nulls":10},{"$f":"SUM(M94:M107)+SUM(M109:M119)","v":0}]
[null,null,"Domestic Travel","                                                              Budget Period 5"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH122=0,(I122*F122)+J122+(L122*0.75)*G122*F122,\nAND(H122>0,H122<2),(I122*F122)+J122+(K122*H122*F122)+(L122*0.75)*G122*F122,\nH122>=2,((I122*F122)+J122+(K122*H122*F122)+(L122*0.75)*2*F122)+(L122*(G122-2)*F122))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH123=0,(I123*F123)+J123+(L123*0.75)*G123*F123,\nAND(H123>0,H123<2),(I123*F123)+J123+(K123*H123*F123)+(L123*0.75)*G123*F123,\nH123>=2,((I123*F123)+J123+(K123*H123*F123)+(L123*0.75)*2*F123)+(L123*(G123-2)*F123))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH124=0,(I124*F124)+J124+(L124*0.75)*G124*F124,\nAND(H124>0,H124<2),(I124*F124)+J124+(K124*H124*F124)+(L124*0.75)*G124*F124,\nH124>=2,((I124*F124)+J124+(K124*H124*F124)+(L124*0.75)*2*F124)+(L124*(G124-2)*F124))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH125=0,(I125*F125)+J125+(L125*0.75)*G125*F125,\nAND(H125>0,H125<2),(I125*F125)+J125+(K125*H125*F125)+(L125*0.75)*G125*F125,\nH125>=2,((I125*F125)+J125+(K125*H125*F125)+(L125*0.75)*2*F125)+(L125*(G125-2)*F125))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH126=0,(I126*F126)+J126+(L126*0.75)*G126*F126,\nAND(H126>0,H126<2),(I126*F126)+J126+(K126*H126*F126)+(L126*0.75)*G126*F126,\nH126>=2,((I126*F126)+J126+(K126*H126*F126)+(L126*0.75)*2*F126)+(L126*(G126-2)*F126))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH127=0,(I127*F127)+J127+(L127*0.75)*G127*F127,\nAND(H127>0,H127<2),(I127*F127)+J127+(K127*H127*F127)+(L127*0.75)*G127*F127,\nH127>=2,((I127*F127)+J127+(K127*H127*F127)+(L127*0.75)*2*F127)+(L127*(G127-2)*F127))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH128=0,(I128*F128)+J128+(L128*0.75)*G128*F128,\nAND(H128>0,H128<2),(I128*F128)+J128+(K128*H128*F128)+(L128*0.75)*G128*F128,\nH128>=2,((I128*F128)+J128+(K128*H128*F128)+(L128*0.75)*2*F128)+(L128*(G128-2)*F128))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH129=0,(I129*F129)+J129+(L129*0.75)*G129*F129,\nAND(H129>0,H129<2),(I129*F129)+J129+(K129*H129*F129)+(L129*0.75)*G129*F129,\nH129>=2,((I129*F129)+J129+(K129*H129*F129)+(L129*0.75)*2*F129)+(L129*(G129-2)*F129))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH130=0,(I130*F130)+J130+(L130*0.75)*G130*F130,\nAND(H130>0,H130<2),(I130*F130)+J130+(K130*H130*F130)+(L130*0.75)*G130*F130,\nH130>=2,((I130*F130)+J130+(K130*H130*F130)+(L130*0.75)*2*F130)+(L130*(G130-2)*F130))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH131=0,(I131*F131)+J131+(L131*0.75)*G131*F131,\nAND(H131>0,H131<2),(I131*F131)+J131+(K131*H131*F131)+(L131*0.75)*G131*F131,\nH131>=2,((I131*F131)+J131+(K131*H131*F131)+(L131*0.75)*2*F131)+(L131*(G131-2)*F131))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH132=0,(I132*F132)+J132+(L132*0.75)*G132*F132,\nAND(H132>0,H132<2),(I132*F132)+J132+(K132*H132*F132)+(L132*0.75)*G132*F132,\nH132>=2,((I132*F132)+J132+(K132*H132*F132)+(L132*0.75)*2*F132)+(L132*(G132-2)*F132))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH133=0,(I133*F133)+J133+(L133*0.75)*G133*F133,\nAND(H133>0,H133<2),(I133*F133)+J133+(K133*H133*F133)+(L133*0.75)*G133*F133,\nH133>=2,((I133*F133)+J133+(K133*H133*F133)+(L133*0.75)*2*F133)+(L133*(G133-2)*F133))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH134=0,(I134*F134)+J134+(L134*0.75)*G134*F134,\nAND(H134>0,H134<2),(I134*F134)+J134+(K134*H134*F134)+(L134*0.75)*G134*F134,\nH134>=2,((I134*F134)+J134+(K134*H134*F134)+(L134*0.75)*2*F134)+(L134*(G134-2)*F134))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH135=0,(I135*F135)+J135+(L135*0.75)*G135*F135,\nAND(H135>0,H135<2),(I135*F135)+J135+(K135*H135*F135)+(L135*0.75)*G135*F135,\nH135>=2,((I135*F135)+J135+(K135*H135*F135)+(L135*0.75)*2*F135)+(L135*(G135-2)*F135))","v":0}]
[null,null,"International Travel"]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH137=0,(I137*F137)+J137+(L137*0.75)*G137*F137,\nAND(H137>0,H137<2),(I137*F137)+J137+(K137*H137*F137)+(L137*0.75)*G137*F137,\nH137>=2,((I137*F137)+J137+(K137*H137*F137)+(L137*0.75)*2*F137)+(L137*(G137-2)*F137))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH138=0,(I138*F138)+J138+(L138*0.75)*G138*F138,\nAND(H138>0,H138<2),(I138*F138)+J138+(K138*H138*F138)+(L138*0.75)*G138*F138,\nH138>=2,((I138*F138)+J138+(K138*H138*F138)+(L138*0.75)*2*F138)+(L138*(G138-2)*F138))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH139=0,(I139*F139)+J139+(L139*0.75)*G139*F139,\nAND(H139>0,H139<2),(I139*F139)+J139+(K139*H139*F139)+(L139*0.75)*G139*F139,\nH139>=2,((I139*F139)+J139+(K139*H139*F139)+(L139*0.75)*2*F139)+(L139*(G139-2)*F139))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH140=0,(I140*F140)+J140+(L140*0.75)*G140*F140,\nAND(H140>0,H140<2),(I140*F140)+J140+(K140*H140*F140)+(L140*0.75)*G140*F140,\nH140>=2,((I140*F140)+J140+(K140*H140*F140)+(L140*0.75)*2*F140)+(L140*(G140-2)*F140))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH141=0,(I141*F141)+J141+(L141*0.75)*G141*F141,\nAND(H141>0,H141<2),(I141*F141)+J141+(K141*H141*F141)+(L141*0.75)*G141*F141,\nH141>=2,((I141*F141)+J141+(K141*H141*F141)+(L141*0.75)*2*F141)+(L141*(G141-2)*F141))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH142=0,(I142*F142)+J142+(L142*0.75)*G142*F142,\nAND(H142>0,H142<2),(I142*F142)+J142+(K142*H142*F142)+(L142*0.75)*G142*F142,\nH142>=2,((I142*F142)+J142+(K142*H142*F142)+(L142*0.75)*2*F142)+(L142*(G142-2)*F142))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH143=0,(I143*F143)+J143+(L143*0.75)*G143*F143,\nAND(H143>0,H143<2),(I143*F143)+J143+(K143*H143*F143)+(L143*0.75)*G143*F143,\nH143>=2,((I143*F143)+J143+(K143*H143*F143)+(L143*0.75)*2*F143)+(L143*(G143-2)*F143))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH144=0,(I144*F144)+J144+(L144*0.75)*G144*F144,\nAND(H144>0,H144<2),(I144*F144)+J144+(K144*H144*F144)+(L144*0.75)*G144*F144,\nH144>=2,((I144*F144)+J144+(K144*H144*F144)+(L144*0.75)*2*F144)+(L144*(G144-2)*F144))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH145=0,(I145*F145)+J145+(L145*0.75)*G145*F145,\nAND(H145>0,H145<2),(I145*F145)+J145+(K145*H145*F145)+(L145*0.75)*G145*F145,\nH145>=2,((I145*F145)+J145+(K145*H145*F145)+(L145*0.75)*2*F145)+(L145*(G145-2)*F145))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH146=0,(I146*F146)+J146+(L146*0.75)*G146*F146,\nAND(H146>0,H146<2),(I146*F146)+J146+(K146*H146*F146)+(L146*0.75)*G146*F146,\nH146>=2,((I146*F146)+J146+(K146*H146*F146)+(L146*0.75)*2*F146)+(L146*(G146-2)*F146))","v":0}]
[{"$nulls":12},{"$f":"_xlfn.IFS(\nH147=0,(I147*F147)+J147+(L147*0.75)*G147*F147,\nAND(H147>0,H147<2),(I147*F147)+J147+(K147*H147*F147)+(L147*0.75)*G147*F147,\nH147>=2,((I147*F147)+J147+(K147*H147*F147)+(L147*0.75)*2*F147)+(L147*(G147-2)*F147))","v":0}]
[null,"Budget Period 5 Total",{"$nulls":10},{"$f":"SUM(M122:M135)+SUM(M137:M147)","v":0}]
[]
[null,"TOTAL TRAVEL",{"$nulls":10},{"$f":"M36+M64+M92+M120+M148","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"d. Equipment","index":5,"n_rows":102,"n_cols":8,"rows_kept":102,"cut":false,"hidden":false,"merged":[[2,1,2,7],[1,1,1,2],[3,1,3,7],[101,1,102,7],[44,1,44,7],[26,1,26,7],[6,1,6,7],[62,1,62,7],[80,1,80,7],[99,1,99,2],[79,1,79,2],[97,1,97,2],[43,1,43,2],[25,1,25,2],[61,1,61,2]]}
[]
[null,"Detailed Budget Justification"]
[null,"d. Equipment"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. 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. \n2. List all equipment below, providing a basis of cost (e.g. contractor 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. \n3. During award negotiations, provide a contractor quote for all equipment items over $50,000 in price. If the contractor quote is not an exact price match, provide an explanation in the additional explanation section below. If a contractor 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.\n4. Each budget period is rounded to the nearest dollar.\n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"SOPO Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
[null,"Budget Period 1"]
[null,"3,4,5","EXAMPLE!!!   Thermal shock chamber",2,70000,{"$f":"D8*E8","v":140000},"Contractor Quote - Attached","Reliability testing of PV modules- Task 4.3"]
[{"$nulls":5},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},{"$f":"D25*E25","v":0}]
[null,"Budget Period 1 Total",null,null,null,{"$f":"SUM(F9:F25)","v":0}]
[null,"Budget Period 2"]
[{"$nulls":5},{"$f":"D28*E28","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]
[null,"Budget Period 2 Total",null,null,null,{"$f":"SUM(F28:F43)","v":0}]
[null,"Budget Period 3"]
[{"$nulls":5},{"$f":"D46*E46","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]
[null,"Budget Period 3 Total",null,null,null,{"$f":"SUM(F46:F61)","v":0}]
[null,"Budget Period 4"]
[{"$nulls":5},{"$f":"D64*E64","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]
[null,"Budget Period 4 Total",null,null,null,{"$f":"SUM(F64:F79)","v":0}]
[null,"Budget Period 5"]
[{"$nulls":5},{"$f":"D82*E82","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]
[null,"Budget Period 5 Total",null,null,null,{"$f":"SUM(F82:F97)","v":0}]
[]
[null,"TOTAL EQUIPMENT",null,null,null,{"$f":"F26+F44+F62+F80+F98","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"e. Supplies","index":6,"n_rows":112,"n_cols":8,"rows_kept":112,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,7],[111,1,112,7],[6,1,6,7],[2,1,2,7],[28,1,28,7],[48,1,48,7],[68,1,68,7],[88,1,88,7],[109,1,109,2],[107,1,107,2],[87,1,87,2],[67,1,67,2],[47,1,47,2],[27,1,27,2]]}
[]
[null,"Detailed Budget Justification "]
[null,"e. Supplies"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. 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. \n2. List all proposed supplies below, providing a basis of costs (e.g. contractor 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.\n3. 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.  \n4. Each budget period is rounded to the nearest dollar.\n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"SOPO Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
[null,"Budget Period 1"]
[null,"1,2","EXAMPLE!!!  Wireless DAS components",10,360,{"$f":"D8*E8","v":3600},"Catalog price","For Alpha prototype - 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]
[null,"Budget Period 1 Total",null,null,null,{"$f":"SUM(F9:F27)","v":0}]
[null,"Budget Period 2"]
[{"$nulls":5},{"$f":"D30*E30","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]
[null,"Budget Period 2 Total",null,null,null,{"$f":"SUM(F30:F47)","v":0}]
[null,"Budget Period 3"]
[{"$nulls":5},{"$f":"D50*E50","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]
[null,"Budget Period 3 Total",null,null,null,{"$f":"SUM(F50:F67)","v":0}]
[null,"Budget Period 4"]
[{"$nulls":5},{"$f":"D70*E70","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]
[null,"Budget Period 4 Total",null,null,null,{"$f":"SUM(F70:F87)","v":0}]
[null,"Budget Period 5"]
[{"$nulls":5},{"$f":"D90*E90","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]
[null,"Budget Period 5 Total",null,null,null,{"$f":"SUM(F90:F107)","v":0}]
[]
[null,"TOTAL SUPPLIES",null,null,null,{"$f":"F68+F48+F28+F88+F108","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"f. Contractual","index":7,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,1,3,11],[1,7,1,11],[1,1,1,2],[2,1,2,11],[45,2,45,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[40,2,40,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[62,1,63,11],[60,1,60,4],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[41,2,41,3],[42,2,42,3],[46,2,46,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,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 $250,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. Each budget period is rounded to the nearest dollar.\n7. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"SOPO Task #","Sub-Recipient\nName/Organization","Sub-Recipient Unique Entity Identifier (UEI)","Purpose","Basis of Cost","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Project Total"]
[null,"2,4","EXAMPLE!!!  XYZ Corp.",null,"Partner to develop optimal lens for Gen 2 product. ","Cost estimate based on personnel hours.",48000,32000,16000,{"$f":"SUM(G7:I7)","v":96000},10000,{"$f":"_xlfn.IFS(OR(\nInstructions!$H$31=\"3 Budget Periods or Less\",Instructions!$H$31=\"Make Selection\"),SUM(G7:I7),\nInstructions!$H$31=\"4 Budget Periods\",SUM(G7:J7),\nInstructions!$H$31=\"5 Budget Periods\",SUM(G7:K7))","v":96000}]
[{"$nulls":11},{"$f":"SUM(G8:K8)","v":0}]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G8:G23)","v":0},0,0,0,0,0]
[]
[null,"SOPO Task #","Contractor \nName/Organization",null,"Purpose","Basis of Cost","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Project Total"]
[{"$nulls":11},{"$f":"SUM(G27:K27)","v":0}]
[{"$nulls":11},{"$f":"SUM(G28:K28)","v":0}]
[{"$nulls":11},{"$f":"SUM(G29:K29)","v":0}]
[{"$nulls":11},{"$f":"SUM(G30:K30)","v":0}]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},{"$f":"SUM(G35:K35)","v":0}]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},{"$f":"SUM(G41:K41)","v":0}]
[{"$nulls":11},{"$f":"SUM(G42:K42)","v":0}]
[{"$nulls":11},{"$f":"SUM(G43:K43)","v":0}]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G27:G43)","v":0},0,0,0,0,0]
[]
[null,"SOPO Task #","FFRDC\nName/Organization",null,"Purpose","Basis of Cost","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Project Total"]
[{"$nulls":11},{"$f":"SUM(G47:K47)","v":0}]
[{"$nulls":11},{"$f":"SUM(G48:K48)","v":0}]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":11},0]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G47:G58)","v":0},{"$f":"SUM(H47:H58)","v":0},{"$f":"SUM(I47:I58)","v":0},{"$f":"SUM(J47:J58)","v":0},{"$f":"SUM(K47:K58)","v":0},{"$f":"SUM(G59:K59)","v":0}]
[]
[{"$nulls":5},"TOTAL CONTRACTUAL: ",{"$f":"G24+G44+G59","v":0},0,0,0,0,0]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"g. Construction","index":8,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":false,"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":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":false,"merged":[[102,1,103,5],[1,1,1,2],[2,1,2,5],[3,1,3,5],[6,1,6,5],[44,2,44,5],[26,2,26,5],[62,2,62,5],[80,2,80,5],[99,1,99,2],[97,1,97,2],[79,1,79,2],[61,1,61,2],[43,1,43,2],[25,1,25,2]]}
[]
[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: tuition, 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 contractor quotes, prior purchases of similar or like items, published price list, etc.\n3. Each budget period is rounded to the nearest dollar.\n4. Required - list formulas for each cost in the comments section. \n5. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"SOPO Task #","General Description and SOPO Task #"," Cost             ","Basis of Cost","Justification of need"]
[null,"Budget Period 1"]
[null,1,"EXAMPLE!!!  Grad student tuition - tasks 1-3",16000,"Established UCD costs","Support of graduate students working on project "]
{"$rows_empty":17}
[null,"Budget Period 1 Total",null,{"$f":"SUM(D9:D25)","v":0}]
[null,null,"Budget Period 2"]
{"$rows_empty":16}
[null,"Budget Period 2 Total",null,{"$f":"SUM(D28:D43)","v":0}]
[null,null,"Budget Period 3"]
{"$rows_empty":16}
[null,"Budget Period 3 Total",null,{"$f":"SUM(D46:D61)","v":0}]
[null,null,"Budget Period 4"]
{"$rows_empty":16}
[null,"Budget Period 4 Total",null,{"$f":"SUM(D64:D79)","v":0}]
[null,null,"Budget Period 5"]
{"$rows_empty":16}
[null,"Budget Period 5 Total",null,{"$f":"SUM(D82:D97)","v":0}]
[]
[null,"TOTAL OTHER DIRECT COSTS",null,{"$f":"D62+D44+D26+D80+D98","v":0}]
[]
[null,"Additional Explanation (Required - list formulas for each cost):"]

{"sheet":"i. Indirect","index":10,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[1,11,1,12],[1,1,1,7],[8,11,8,12],[9,11,9,12],[10,11,10,12],[7,11,7,12],[5,1,6,4],[7,1,7,4],[8,1,8,4],[2,1,2,12],[3,1,3,12],[9,1,9,4],[10,1,10,4],[5,11,6,12],[5,5,6,5],[27,1,27,12],[29,1,31,12],[7,10,10,10],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[12,11,12,12],[11,11,11,12],[18,1,18,12],[13,11,13,12],[16,11,16,12],[14,11,14,12],[15,11,15,12],[16,1,16,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. Each budget period is rounded to the nearest dollar."]
[]
[null,"Provide ONLY Applicable Rates:",null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Total","Explanation of BASE \nExample: Labor + Fringe"]
[]
[null,"Overhead Rate %"]
[null,"General & Administrative (G&A) %"]
[null,"FCCM Rate (if applicable) %"]
[null,"OTHER Indirect Rate %"]
[null,"Indirect Costs (As Applicable):"]
[null,"Overhead Costs $",{"$nulls":8},{"$f":"ROUND(SUM(F13:J13),0)","v":0}]
[null,"G&A Costs $",{"$nulls":8},{"$f":"ROUND(SUM(F14:J14),0)","v":0}]
[null,"FCCM Costs (if applicable) $",{"$nulls":8},{"$f":"ROUND(SUM(F15:J15),0)","v":0}]
[null," OTHER Indirect Costs $",{"$nulls":8},{"$f":"ROUND(SUM(F16:J16),0)","v":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},{"$f":"ROUND(SUM(H13:H16),0)","v":0},{"$f":"ROUND(SUM(I13:I16),0)","v":0},{"$f":"ROUND(SUM(J13:J16),0)","v":0},{"$f":"ROUND(SUM(F17:J17),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 check (X) one of the options below and provide the requested information if it has not already been provided as requested, or has changed.  "]
[]
[null,null,null,"    An indirect rate has been approved or negotiated with a federal government agency with a current effective period of: "]
[null,null,null,"    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,null,"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,null,"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":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,34,9],[2,1,2,9],[1,1,1,3],[3,1,3,9],[30,5,30,6],[1,5,1,9],[27,1,27,3],[31,1,32,2],[31,3,32,3],[31,4,32,8],[31,9,32,9]]}
[]
[null,"Detailed Budget Justification"]
[null,"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) or resources (captured on tab k. Non-Federal Resources). 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. 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) under any resulting award. The project may only incur those costs that are allowable and allocable to the project (including cost share) as determined in accordance with the applicable cost principles prescribed in FAR Part 31 for For-Profit entities and 2 CFR Part 200 Subpart E - Cost Principles for all other non-federal entities.\n8. A Recipient cannot claim \"unrecovered indirect costs\" as a 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. Each budget period 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","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Total Project Cost Share"]
[null,"ABC Company\nEXAMPLE!!!","Cash","Project partner ABC Company will provide 20 PV modules for product development at the price of $680 per module",13600,{"$nulls":4},{"$f":"SUM(E7:G7)","v":13600}]
[{"$nulls":9},{"$f":"SUM(E8:I8)","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"TOTAL COST SHARE",null,null,{"$f":"ROUND(SUM(E8:E27),0)","v":0},0,0,0,0,0]
[]
[null,null,null,"Cost Share Percentage per Budget Period",{"$f":"IFERROR(IF(E28>0,E28/Summary!H13,0),0)","v":0},{"$f":"IFERROR(IF(F28>0,F28/Summary!H14,0),0)","v":0},{"$f":"IFERROR(IF(G28>0,G28/Summary!H15,0),0)","v":0},{"$f":"IFERROR(IF(H28>0,H28/Summary!H16,0),0)","v":0},{"$f":"IFERROR(IF(I28>0,I28/Summary!H17,0),0)","v":0}]
[]
[null,"Total Project Cost:  ",null,{"$f":"Summary!H35","v":0},"Cost Share Percent of Award:",{"$nulls":4},{"$f":"IF(D32>0,J28/D32,0)","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"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'!E28","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'!F28","v":0},{"$f":"SUM(D9:G9)","v":{"$error":"#REF!"}}]
["3.","Budget period 3",null,null,null,{"$f":"F26-'j. Cost Share'!G28","v":{"$error":"#REF!"}},{"$f":"'j. Cost Share'!G28","v":0},{"$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":0},{"$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!C21","v":0},{"$f":"Summary!D21","v":0},{"$f":"Summary!E21","v":0},null,{"$f":"SUM(D16:G16)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"Summary!C22","v":0},{"$f":"Summary!D22","v":0},{"$f":"Summary!E22","v":0},null,0]
[null,"c.  Travel",null,{"$f":"Summary!C23","v":0},{"$f":"Summary!D23","v":0},{"$f":"Summary!E23","v":0},null,0]
[null,"d.  Equipment",null,{"$f":"Summary!C24","v":0},{"$f":"Summary!D24","v":0},{"$f":"Summary!E24","v":0},null,0]
[null,"e.  Supplies",null,{"$f":"Summary!C25","v":0},{"$f":"Summary!D25","v":0},{"$f":"Summary!E25","v":0},null,0]
[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!C31","v":0},{"$f":"Summary!D31","v":0},{"$f":"Summary!E31","v":0},null,0]
[null,"h.  Other",null,{"$f":"Summary!C32","v":0},{"$f":"Summary!D32","v":0},{"$f":"Summary!E32","v":0},null,0]
[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!C34","v":0},{"$f":"Summary!D34","v":0},{"$f":"Summary!E34","v":0},null,0]
[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":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[38,1,53,1],[38,8,52,8],[56,1,57,8],[1,1,1,4],[2,1,2,8],[3,1,3,8],[6,1,21,1],[6,8,20,8],[22,1,37,1],[22,8,36,8]]}
[]
[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. Each 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","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Source Totals"]
[null,"Applicant"]
{"$rows_empty":14}
[null,null,"Applicant Budget Period Totals: ",{"$f":"ROUND(SUM(D7:D21),0)","v":0},{"$f":"ROUND(SUM(E7:E21),0)","v":0},0,0,0,{"$f":"SUM(D22:H22)","v":0}]
[null,"State"]
{"$rows_empty":14}
[null,null,"State Budget Period Totals: ",{"$f":"ROUND(SUM(D23:D37),0)","v":0},{"$f":"ROUND(SUM(E23:E37),0)","v":0},{"$f":"ROUND(SUM(F23:F37),0)","v":0},{"$f":"ROUND(SUM(G23:G37),0)","v":0},0,{"$f":"SUM(D38:H38)","v":0}]
[null,"Other Sources"]
{"$rows_empty":14}
[null,null,"Other Sources Budget Period Totals:   ",{"$f":"ROUND(SUM(D39:D53),0)","v":0},{"$f":"ROUND(SUM(E39:E53),0)","v":0},0,0,0,{"$f":"SUM(D54:H54)","v":0}]
[null,null,"Budget Period Totals:",{"$f":"SUM(D22+D38+D54)","v":0},{"$f":"SUM(E22+E38+E54)","v":0},{"$f":"SUM(F22+F38+F54)","v":0},{"$f":"SUM(G22+G38+G54)","v":0},0,{"$f":"SUM(D55:H55)","v":0}]
[]
[null,"Additional Explanation (as needed):  "]

{"sheet":"Spend Plan","index":14,"n_rows":78,"n_cols":26,"rows_kept":78,"cut":false,"hidden":false,"merged":[[42,17,52,17],[55,17,65,17],[15,11,16,11],[15,12,16,12],[15,17,25,17],[29,17,39,17],[29,22,39,22],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,2,16,2],[15,3,16,3],[15,4,16,4],[10,17,11,25],[12,0,13,0],[12,17,13,25],[15,13,16,13],[15,14,16,14],[15,0,16,0],[15,1,16,1],[14,0,14,3],[14,13,14,14],[15,5,16,5],[12,1,13,1],[15,22,25,22],[2,0,2,14],[10,0,11,0],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[3,0,8,12],[10,1,11,1],[10,2,11,2]]}
[]
[]
["k. Spend Plan"]
["INSTRUCTIONS - PLEASE READ!!!\n*This tab is not required to be populated during the application phase.*\n1. This tab is used to capture the ACTUAL spend plan for the project in each budget category over the life of the project. Budget category totals for each Budget Period and the overall project must match the calculated totals on the Summary tab. \n2. Fill out both the Start Date for each Budget Period for the project and the End Date of the final Budget Period in the highlighted fields (mm/dd/yyyy format). The sheet will automatically update to list all active months of the award.\n3. Budget Categories, Columns E-M: For each month of the project, fill out the Budget Categories columns based on the estimated monthly spend of the project in each category. Columns N-O will calculate automatically. Do not leave any rows during the lifecycle of the project blank.\n4. The Comparison Tables will fill automatically based on the entries in Columns E-M. The monthly spend plan totals for each budget category must match the estimated totals for each budget category and for the overall project. Totals that are highlighted in red in the Comparison Tables do not match the estimated totals on the Summary tab and must be corrected before submitting the Budget Justification."]
[]
[]
[]
[]
[]
[]
["BP1\nStart Date:",null,"BP2\nStart Date:",null,"BP3\nStart Date:",null,"BP4\nStart Date:",null,"BP5\nStart Date:",null,null,null,{"$f":"DATEDIF(B11,B13,\"m\")+1","v":1},{"$nulls":4},"Comparison Tables"]
[]
["Final BP\nEnd Date:",{"$nulls":16}," Red highlighted cells show totals on the Spend Plan which conflict with the totals on the Summary tab. Please review monthly Spend Plan to confirm. "]
[]
["Project Spend Plan",null,null,null,"Budget Categories",{"$nulls":8},"Cumulative"]
["BP","Year","Month","Month of Project","a. Personnel","b. Fringe Benefits","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect","Cumulative Costs - Month","Cumulative Costs - Total",null,null,"Budget Period 1",null,"Spend Plan Tab","Summary Tab",null,"Budget Period 2",null,"Spend Plan Tab","Summary Tab"]
[{"$nulls":18},"a. Personnel",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$E$16:$E$77)","v":0},{"$f":"_xlfn.XLOOKUP(S17,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"a. Personnel",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$E$16:$E$77)","v":0},{"$f":"_xlfn.XLOOKUP(X17,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
[{"$f":"IF((AND(B18>=$B$11,B18<$D$11)),\"BP1\",(IF((AND(B18>=$D$11,B18<IF($F$11=\"\",$B$13,$F$11))),\"BP2\",(IF((AND(B18>=$F$11,B18<IF($H$11=\"\",$B$13,$H$11))),\"BP3\",(IF((AND(B18>=$H$11,B18<IF($J$11=\"\",$B$13,$J$11))),\"BP4\",(IF((AND(B18>=$J$11)),\"BP5\")))))))))","v":"BP5"},{"$f":"EDATE($B$11,(D18-1))","v":"00:00:00"},{"$f":"EDATE($B$11,($D18-1))","v":"00:00:00"},1,{"$nulls":9},{"$f":"SUM(E18:M18)","v":0},{"$f":"IFERROR(IF(N18=0,\"\",O17+N18), \"Fill all monthly costs for cumulative total\")","v":""},null,null,null,"b. Fringe Benefits",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$F$16:$F$77)","v":0},{"$f":"_xlfn.XLOOKUP(S18,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"b. Fringe Benefits",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$F$16:$F$77)","v":0},{"$f":"_xlfn.XLOOKUP(X18,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-01-31","1900-01-31",2,{"$nulls":9},{"$f":"SUM(E19:M19)","v":0},{"$f":"IFERROR(IF(N19=0,\"\",O18+N19), \"All months must be populated to calculate\")","v":""},null,null,null,"c. Travel",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$G$16:$G$77)","v":0},{"$f":"_xlfn.XLOOKUP(S19,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"c. Travel",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$G$16:$G$77)","v":0},{"$f":"_xlfn.XLOOKUP(X19,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5",60,60,3,{"$nulls":9},{"$f":"SUM(E20:M20)","v":0},{"$f":"IFERROR(IF(N20=0,\"\",O19+N20), \"All months must be populated to calculate\")","v":""},null,null,null,"d. Equipment",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$H$16:$H$77)","v":0},{"$f":"_xlfn.XLOOKUP(S20,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"d. Equipment",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$H$16:$H$77)","v":0},{"$f":"_xlfn.XLOOKUP(X20,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-03-31","1900-03-31",4,{"$nulls":9},0,"",null,null,null,"e. Supplies",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$I$16:$I$77)","v":0},{"$f":"_xlfn.XLOOKUP(S21,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"e. Supplies",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$I$16:$I$77)","v":0},{"$f":"_xlfn.XLOOKUP(X21,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-04-30","1900-04-30",5,{"$nulls":9},0,{"$f":"IFERROR(IF(N22=0,\"\",O21+N22), \"All months must be populated to calculate\")","v":""},null,null,null,"f. Contractual",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$J$16:$J$77)","v":0},{"$f":"_xlfn.XLOOKUP(\"Total Contractual \",Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"f. Contractual",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$J$16:$J$77)","v":0},{"$f":"_xlfn.XLOOKUP(\"Total Contractual \",Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-05-31","1900-05-31",6,{"$nulls":9},0,"",null,null,null,"g. Construction",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$K$16:$K$77)","v":0},{"$f":"_xlfn.XLOOKUP(S23,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"g. Construction",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$K$16:$K$77)","v":0},{"$f":"_xlfn.XLOOKUP(X23,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-06-30","1900-06-30",7,{"$nulls":9},0,"",null,null,null,"h. Other Direct Costs",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$L$16:$L$77)","v":0},{"$f":"_xlfn.XLOOKUP(S24,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"h. Other Direct Costs",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$L$16:$L$77)","v":0},{"$f":"_xlfn.XLOOKUP(X24,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-07-31","1900-07-31",8,{"$nulls":9},0,"",null,null,null,"i. Indirect Charges",{"$f":"SUMIF($A$16:$A$77,\"BP1\",$M$16:$M$77)","v":0},{"$f":"_xlfn.XLOOKUP(S25,Summary!$B$21:$B$34,Summary!$C$21:$C$34)","v":0},null,null,"i. Indirect Charges",{"$f":"SUMIF($A$16:$A$77,\"BP2\",$M$16:$M$77)","v":0},{"$f":"_xlfn.XLOOKUP(X25,Summary!$B$21:$B$34,Summary!$D$21:$D$34)","v":0}]
["BP5","1900-08-31","1900-08-31",9,{"$nulls":9},0,"",null,null,null,"Total",{"$f":"SUM(T17:T25)","v":0},{"$f":"Summary!H13","v":0},null,null,"Total",{"$f":"SUM(Y17:Y25)","v":0},{"$f":"Summary!H14","v":0}]
["BP5","1900-09-30","1900-09-30",10,{"$nulls":9},0,""]
["BP5","1900-10-31","1900-10-31",11,{"$nulls":9},0,""]
["BP5","1900-11-30","1900-11-30",12,{"$nulls":9},0,""]
["BP5","1900-12-31","1900-12-31",13,{"$nulls":9},0,"",null,null,"Budget Period 3",null,"Spend Plan Tab","Summary Tab",null,"Budget Period 4",null,"Spend Plan Tab","Summary Tab"]
["BP5","1901-01-31","1901-01-31",14,{"$nulls":9},0,"",null,null,null,"a. Personnel",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$E$16:$E$77)","v":0},{"$f":"_xlfn.XLOOKUP(S31,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"a. Personnel",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$E$16:$E$77)","v":0},{"$f":"_xlfn.XLOOKUP(X31,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-02-28","1901-02-28",15,{"$nulls":9},0,"",null,null,null,"b. Fringe Benefits",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$F$16:$F$77)","v":0},{"$f":"_xlfn.XLOOKUP(S32,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"b. Fringe Benefits",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$F$16:$F$77)","v":0},{"$f":"_xlfn.XLOOKUP(X32,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-03-31","1901-03-31",16,{"$nulls":9},0,"",null,null,null,"c. Travel",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$G$16:$G$77)","v":0},{"$f":"_xlfn.XLOOKUP(S33,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"c. Travel",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$G$16:$G$77)","v":0},{"$f":"_xlfn.XLOOKUP(X33,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-04-30","1901-04-30",17,{"$nulls":9},0,"",null,null,null,"d. Equipment",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$H$16:$H$77)","v":0},{"$f":"_xlfn.XLOOKUP(S34,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"d. Equipment",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$H$16:$H$77)","v":0},{"$f":"_xlfn.XLOOKUP(X34,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-05-31","1901-05-31",18,{"$nulls":9},0,"",null,null,null,"e. Supplies",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$I$16:$I$77)","v":0},{"$f":"_xlfn.XLOOKUP(S35,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"e. Supplies",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$I$16:$I$77)","v":0},{"$f":"_xlfn.XLOOKUP(X35,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-06-30","1901-06-30",19,{"$nulls":9},0,"",null,null,null,"f. Contractual",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$J$16:$J$77)","v":0},{"$f":"_xlfn.XLOOKUP(\"Total Contractual \",Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"f. Contractual",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$J$16:$J$77)","v":0},{"$f":"_xlfn.XLOOKUP(\"Total Contractual \",Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-07-31","1901-07-31",20,{"$nulls":9},0,"",null,null,null,"g. Construction",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$K$16:$K$77)","v":0},{"$f":"_xlfn.XLOOKUP(S37,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"g. Construction",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$K$16:$K$77)","v":0},{"$f":"_xlfn.XLOOKUP(X37,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-08-31","1901-08-31",21,{"$nulls":9},0,"",null,null,null,"h. Other Direct Costs",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$L$16:$L$77)","v":0},{"$f":"_xlfn.XLOOKUP(S38,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"h. Other Direct Costs",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$L$16:$L$77)","v":0},{"$f":"_xlfn.XLOOKUP(X38,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-09-30","1901-09-30",22,{"$nulls":9},0,"",null,null,null,"i. Indirect Charges",{"$f":"SUMIF($A$16:$A$77,\"BP3\",$M$16:$M$77)","v":0},{"$f":"_xlfn.XLOOKUP(S39,Summary!$B$21:$B$34,Summary!$E$21:$E$34)","v":0},null,null,"i. Indirect Charges",{"$f":"SUMIF($A$16:$A$77,\"BP4\",$M$16:$M$77)","v":0},{"$f":"_xlfn.XLOOKUP(X39,Summary!$B$21:$B$34,Summary!$F$21:$F$34)","v":0}]
["BP5","1901-10-31","1901-10-31",23,{"$nulls":9},0,"",null,null,null,"Total",{"$f":"SUM(T31:T39)","v":0},{"$f":"Summary!H15","v":0},null,null,"Total",{"$f":"SUM(Y31:Y39)","v":0},{"$f":"Summary!H16","v":0}]
["BP5","1901-11-30","1901-11-30",24,{"$nulls":9},0,""]
["BP5","1901-12-31","1901-12-31",25,{"$nulls":9},0,""]
["BP5","1902-01-31","1902-01-31",26,{"$nulls":9},0,"",null,null,"Budget Period 5",null,"Spend Plan Tab","Summary Tab"]
["BP5","1902-02-28","1902-02-28",27,{"$nulls":9},0,"",null,null,null,"a. Personnel",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$E$16:$E$77)","v":0},{"$f":"_xlfn.XLOOKUP(S44,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-03-31","1902-03-31",28,{"$nulls":9},0,"",null,null,null,"b. Fringe Benefits",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$F$16:$F$77)","v":0},{"$f":"_xlfn.XLOOKUP(S45,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-04-30","1902-04-30",29,{"$nulls":9},0,"",null,null,null,"c. Travel",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$G$16:$G$77)","v":0},{"$f":"_xlfn.XLOOKUP(S46,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-05-31","1902-05-31",30,{"$nulls":9},0,"",null,null,null,"d. Equipment",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$H$16:$H$77)","v":0},{"$f":"_xlfn.XLOOKUP(S47,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-06-30","1902-06-30",31,{"$nulls":9},0,"",null,null,null,"e. Supplies",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$I$16:$I$77)","v":0},{"$f":"_xlfn.XLOOKUP(S48,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-07-31","1902-07-31",32,{"$nulls":9},0,"",null,null,null,"f. Contractual",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$J$16:$J$77)","v":0},{"$f":"_xlfn.XLOOKUP(\"Total Contractual \",Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5",{"$f":"EDATE($B$11,(D50-1))","v":"1902-08-31"},{"$f":"EDATE($B$11,($D50-1))","v":"1902-08-31"},33,{"$nulls":9},0,"",null,null,null,"g. Construction",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$K$16:$K$77)","v":0},{"$f":"_xlfn.XLOOKUP(S50,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-09-30","1902-09-30",34,{"$nulls":9},0,"",null,null,null,"h. Other Direct Costs",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$L$16:$L$77)","v":0},{"$f":"_xlfn.XLOOKUP(S51,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
[{"$f":"IF((AND(B52>=$B$11,B52<$D$11)),\"BP1\",(IF((AND(B52>=$D$11,B52<IF($F$11=\"\",$B$13,$F$11))),\"BP2\",(IF((AND(B52>=$F$11,B52<IF($H$11=\"\",$B$13,$H$11))),\"BP3\",(IF((AND(B52>=$H$11,B52<IF($J$11=\"\",$B$13,$J$11))),\"BP4\",(IF((AND(B52>=$J$11)),\"BP5\")))))))))","v":"BP5"},"1902-10-31","1902-10-31",35,{"$nulls":9},0,"",null,null,null,"i. Indirect Charges",{"$f":"SUMIF($A$16:$A$77,\"BP5\",$M$16:$M$77)","v":0},{"$f":"_xlfn.XLOOKUP(S52,Summary!$B$21:$B$34,Summary!$G$21:$G$34)","v":0}]
["BP5","1902-11-30","1902-11-30",36,{"$nulls":9},0,"",null,null,null,"Total",{"$f":"SUM(T44:T52)","v":0},{"$f":"Summary!H17","v":0}]
["BP5","1902-12-31","1902-12-31",37,{"$nulls":9},0,""]
["BP5","1903-01-31","1903-01-31",38,{"$nulls":9},0,""]
["BP5","1903-02-28","1903-02-28",39,{"$nulls":9},0,"",null,null,"Total",null,"Spend Plan Tab","Summary Tab"]
["BP5","1903-03-31","1903-03-31",40,{"$nulls":9},0,"",null,null,null,"a. Personnel",{"$f":"E78","v":0},{"$f":"_xlfn.XLOOKUP(S57,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-04-30","1903-04-30",41,{"$nulls":9},0,"",null,null,null,"b. Fringe Benefits",{"$f":"F78","v":0},{"$f":"_xlfn.XLOOKUP(S58,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-05-31","1903-05-31",42,{"$nulls":9},0,"",null,null,null,"c. Travel",{"$f":"G78","v":0},{"$f":"_xlfn.XLOOKUP(S59,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-06-30","1903-06-30",43,{"$nulls":9},0,"",null,null,null,"d. Equipment",{"$f":"H78","v":0},{"$f":"_xlfn.XLOOKUP(S60,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-07-31","1903-07-31",44,{"$nulls":9},0,"",null,null,null,"e. Supplies",{"$f":"I78","v":0},{"$f":"_xlfn.XLOOKUP(S61,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-08-31","1903-08-31",45,{"$nulls":9},0,"",null,null,null,"f. Contractual",{"$f":"J78","v":0},{"$f":"_xlfn.XLOOKUP(\"Total Contractual \",Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-09-30","1903-09-30",46,{"$nulls":9},0,"",null,null,null,"g. Construction",{"$f":"K78","v":0},{"$f":"_xlfn.XLOOKUP(S63,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-10-31","1903-10-31",47,{"$nulls":9},0,"",null,null,null,"h. Other Direct Costs",{"$f":"L78","v":0},{"$f":"_xlfn.XLOOKUP(S64,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-11-30","1903-11-30",48,{"$nulls":9},0,"",null,null,null,"i. Indirect Charges",{"$f":"M78","v":0},{"$f":"_xlfn.XLOOKUP(S65,Summary!$B$21:$B$34,Summary!$H$21:$H$34)","v":0}]
["BP5","1903-12-31","1903-12-31",49,{"$nulls":9},0,"",null,null,null,"Total",{"$f":"O78","v":0},{"$f":"Summary!H18","v":0}]
["BP5","1904-01-31","1904-01-31",50,{"$nulls":9},0,""]
["BP5","1904-02-29","1904-02-29",51,{"$nulls":9},0,""]
["BP5","1904-03-31","1904-03-31",52,{"$nulls":9},0,""]
[{"$f":"IF((AND(B70>=$B$11,B70<$D$11)),\"BP1\",(IF((AND(B70>=$D$11,B70<IF($F$11=\"\",$B$13,$F$11))),\"BP2\",(IF((AND(B70>=$F$11,B70<IF($H$11=\"\",$B$13,$H$11))),\"BP3\",(IF((AND(B70>=$H$11,B70<IF($J$11=\"\",$B$13,$J$11))),\"BP4\",(IF((AND(B70>=$J$11)),\"BP5\")))))))))","v":"BP5"},"1904-04-30","1904-04-30",53,{"$nulls":9},0,""]
["BP5","1904-05-31","1904-05-31",54,{"$nulls":9},0,""]
["BP5","1904-06-30","1904-06-30",55,{"$nulls":9},0,""]
["BP5","1904-07-31","1904-07-31",56,{"$nulls":9},0,""]
["BP5","1904-08-31","1904-08-31",57,{"$nulls":9},0,""]
["BP5","1904-09-30","1904-09-30",58,{"$nulls":9},0,""]
["BP5","1904-10-31","1904-10-31",59,{"$nulls":9},0,""]
["BP5","1904-11-30","1904-11-30",60,{"$nulls":9},{"$f":"SUM(E77:M77)","v":0},""]
[null,null,null,"Total",{"$f":"SUM(E18:E77)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(E78:M78)","v":0}]

{"sheet":"SF-424A Cost Categories","index":15,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[33,1,33,9],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[32,2,32,3],[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],[16,1,16,2],[17,1,17,9],[18,1,19,1],[18,2,19,3],[4,6,4,7],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,8,5],[8,6,8,9],[4,1,4,2],[18,4,18,7],[18,9,19,9],[28,2,28,3],[30,2,30,3],[31,1,31,9],[42,1,42,2],[42,3,42,6],[42,8,42,9],[43,1,43,9],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3]]}
[]
[null,"Detailed Budget Justification",{"$nulls":7},"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",null,"Total"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)",null,"(g)"]
[null,"1.","Budget Period 1",null,null,null,{"$f":"ROUND(Summary!D13,0)","v":0},{"$f":"ROUND(Summary!F13,0)+'k. Non-Federal Resources'!D55","v":0},null,{"$f":"ROUND(SUM(E12:H12),0)","v":0}]
[null,"2.","Budget Period 2",null,null,null,{"$f":"ROUND(Summary!D14,0)","v":0},{"$f":"ROUND(Summary!F14,0)+'k. Non-Federal Resources'!E55","v":0},null,{"$f":"ROUND(SUM(E13:H13),0)","v":0}]
[null,"3.","Budget Period 3",null,null,null,{"$f":"ROUND(Summary!D15,0)","v":0},{"$f":"ROUND(Summary!F15,0)+'k. Non-Federal Resources'!F55","v":0},null,{"$f":"ROUND(SUM(E14:H14),0)","v":0}]
[null,"4.","Budget Period 4",null,null,null,{"$f":"ROUND(Summary!D16,0)","v":0},{"$f":"ROUND(Summary!F16,0)+'k. Non-Federal Resources'!G55","v":0},null,{"$f":"ROUND(SUM(E15:H15),0)","v":0}]
[null,"5.","Budget Period 5",null,null,null,{"$f":"ROUND(Summary!D17,0)","v":0},{"$f":"ROUND(Summary!F17,0)+'k. Non-Federal Resources'!H55","v":0},null,{"$f":"ROUND(SUM(E16:H16),0)","v":0}]
[null,"Totals",{"$nulls":4},{"$f":"ROUND(SUM(G12:G16),0)","v":0},{"$f":"ROUND(SUM(H12:H16),0)","v":0},null,{"$f":"ROUND(SUM(J12:J16),0)","v":0}]
[null,"Section B - Budget Categories"]
[null,"6.","Object Class Categories",null,"Grant Program, Function or Activity",{"$nulls":4},"Total"]
[{"$nulls":4},"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"]
[null,null,"a.  Personnel",null,{"$f":"ROUND(Summary!C21,0)","v":0},{"$f":"ROUND(Summary!D21,0)","v":0},{"$f":"ROUND(Summary!E21,0)","v":0},{"$f":"ROUND(Summary!F21,0)","v":0},{"$f":"ROUND(Summary!G21,0)","v":0},{"$f":"ROUND(SUM(E21:I21),0)","v":0}]
[null,null,"b.  Fringe Benefits",null,{"$f":"ROUND(Summary!C22,0)","v":0},{"$f":"ROUND(Summary!D22,0)","v":0},{"$f":"ROUND(Summary!E22,0)","v":0},{"$f":"ROUND(Summary!F22,0)","v":0},{"$f":"ROUND(Summary!G22,0)","v":0},0]
[null,null,"c.  Travel",null,{"$f":"ROUND(Summary!C23,0)","v":0},{"$f":"ROUND(Summary!D23,0)","v":0},{"$f":"ROUND(Summary!E23,0)","v":0},{"$f":"ROUND(Summary!F23,0)","v":0},{"$f":"ROUND(Summary!G23,0)","v":0},0]
[null,null,"d.  Equipment",null,{"$f":"ROUND(Summary!C24,0)","v":0},{"$f":"ROUND(Summary!D24,0)","v":0},{"$f":"ROUND(Summary!E24,0)","v":0},{"$f":"ROUND(Summary!F24,0)","v":0},{"$f":"ROUND(Summary!G24,0)","v":0},0]
[null,null,"e.  Supplies",null,{"$f":"ROUND(Summary!C25,0)","v":0},{"$f":"ROUND(Summary!D25,0)","v":0},{"$f":"ROUND(Summary!E25,0)","v":0},{"$f":"ROUND(Summary!F25,0)","v":0},{"$f":"ROUND(Summary!G25,0)","v":0},0]
[null,null,"f.  Contractual",null,{"$f":"ROUND(Summary!C30,0)","v":0},{"$f":"ROUND(Summary!D30,0)","v":0},{"$f":"ROUND(Summary!E30,0)","v":0},{"$f":"ROUND(Summary!F30,0)","v":0},{"$f":"ROUND(Summary!G30,0)","v":0},0]
[null,null,"g.  Construction",null,{"$f":"ROUND(Summary!C31,0)","v":0},{"$f":"ROUND(Summary!D31,0)","v":0},{"$f":"ROUND(Summary!E31,0)","v":0},{"$f":"ROUND(Summary!F31,0)","v":0},{"$f":"ROUND(Summary!G31,0)","v":0},0]
[null,null,"h.  Other",null,{"$f":"ROUND(Summary!C32,0)","v":0},{"$f":"ROUND(Summary!D32,0)","v":0},{"$f":"ROUND(Summary!E32,0)","v":0},{"$f":"ROUND(Summary!F32,0)","v":0},{"$f":"ROUND(Summary!G32,0)","v":0},0]
[null,null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"ROUND(Summary!C33,0)","v":0},{"$f":"ROUND(Summary!D33,0)","v":0},{"$f":"ROUND(Summary!E33,0)","v":0},{"$f":"ROUND(Summary!F33,0)","v":0},{"$f":"ROUND(Summary!G33,0)","v":0},0]
[null,null,"j.  Indirect Charges",null,{"$f":"ROUND(Summary!C34,0)","v":0},{"$f":"ROUND(Summary!D34,0)","v":0},{"$f":"ROUND(Summary!E34,0)","v":0},{"$f":"ROUND(Summary!F34,0)","v":0},{"$f":"ROUND(Summary!G34,0)","v":0},0]
[null,null,"k.  Totals (sum of 6i-6j)",null,{"$f":"ROUND(SUM(E29:E30),0)","v":0},0,0,0,0,0]
[]
[null,"7.","Program Income",null,0,0,0,0,0,{"$f":"ROUND(SUM(E33:H33),0)","v":0}]
[null,"Section C - Non-Federal Resources"]
[null,null,"(a) Grant Program",null,"(b) Applicant","(c ) State","(d) Other Sources",null,null,"(e) Totals"]
[null,"8.",{"$f":"G5","v":0},null,{"$f":"ROUND('k. Non-Federal Resources'!I22+'j. Cost Share'!J28,0)","v":0},{"$f":"ROUND('k. Non-Federal Resources'!I38,0)","v":0},{"$f":"ROUND('k. Non-Federal Resources'!I54,0)","v":0},null,null,{"$f":"ROUND(SUM(E36:G36),0)","v":0}]
[null,"9.",{"$nulls":7},{"$f":"ROUND(SUM(E37:G37),0)","v":0}]
[null,"10.",{"$nulls":7},0]
[null,"11.",{"$nulls":7},0]
[null,"12. TOTAL (sum of lines 8-11)",null,null,{"$f":"ROUND(SUM(E36:E39),0)","v":0},{"$f":"ROUND(SUM(F36:F39),0)","v":0},{"$f":"ROUND(SUM(G36:G39),0)","v":0},null,null,{"$f":"ROUND(SUM(J36:J39),0)","v":0}]
[]
[{"$nulls":9},"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":16,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,4,4],[16,1,16,2],[17,1,17,9],[18,1,19,1],[18,2,19,3],[4,1,4,2],[4,6,4,7],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,8,5],[8,6,8,9],[33,1,33,9],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[32,2,32,3],[18,4,18,7],[18,9,19,9],[28,2,28,3],[30,2,30,3],[31,1,31,9],[24,2,24,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[42,1,42,2],[42,3,42,6],[42,8,42,9],[43,1,43,9],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3]]}
[]
[null,"Detailed Budget Justification",{"$nulls":7},"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",null,"Total"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)",null,"(g)"]
[null,"1.","Budget Period 1",null,null,null,{"$f":"ROUND(Summary!D13,0)-ROUND(Summary!C29,0)","v":0},{"$f":"ROUND(Summary!F13,0)+'k. Non-Federal Resources'!D55","v":0},null,{"$f":"ROUND(SUM(E12:H12),0)","v":0}]
[null,"2.","Budget Period 2",null,null,null,{"$f":"ROUND(Summary!D14,0)-ROUND(Summary!D29,0)","v":0},{"$f":"ROUND(Summary!F14,0)+'k. Non-Federal Resources'!E55","v":0},null,{"$f":"ROUND(SUM(E13:H13),0)","v":0}]
[null,"3.","Budget Period 3",null,null,null,{"$f":"ROUND(Summary!D15,0)-ROUND(Summary!E29,0)","v":0},{"$f":"ROUND(Summary!F15,0)+'k. Non-Federal Resources'!F55","v":0},null,{"$f":"ROUND(SUM(E14:H14),0)","v":0}]
[null,"4.","Budget Period 4",null,null,null,{"$f":"ROUND(Summary!D16,0)-ROUND(Summary!F29,0)","v":0},{"$f":"ROUND(Summary!F16,0)+'k. Non-Federal Resources'!G55","v":0},null,{"$f":"ROUND(SUM(E15:H15),0)","v":0}]
[null,"5.","Budget Period 5",null,null,null,{"$f":"ROUND(Summary!D17,0)-ROUND(Summary!G29,0)","v":0},{"$f":"ROUND(Summary!F17,0)+'k. Non-Federal Resources'!H55","v":0},null,{"$f":"ROUND(SUM(E16:H16),0)","v":0}]
[null,"Totals",{"$nulls":4},{"$f":"ROUND(SUM(G12:G16),0)","v":0},{"$f":"ROUND(SUM(H12:H16),0)","v":0},null,{"$f":"ROUND(SUM(J12:J16),0)","v":0}]
[null,"Section B - Budget Categories"]
[null,"6.","Object Class Categories",null,"Grant Program, Function or Activity",{"$nulls":4},"Total"]
[{"$nulls":4},"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"]
[null,null,"a.  Personnel",null,{"$f":"ROUND(Summary!C21,0)","v":0},{"$f":"ROUND(Summary!D21,0)","v":0},{"$f":"ROUND(Summary!E21,0)","v":0},{"$f":"ROUND(Summary!F21,0)","v":0},{"$f":"ROUND(Summary!G21,0)","v":0},{"$f":"ROUND(SUM(E21:I21),0)","v":0}]
[null,null,"b.  Fringe Benefits",null,{"$f":"ROUND(Summary!C22,0)","v":0},{"$f":"ROUND(Summary!D22,0)","v":0},{"$f":"ROUND(Summary!E22,0)","v":0},{"$f":"ROUND(Summary!F22,0)","v":0},{"$f":"ROUND(Summary!G22,0)","v":0},0]
[null,null,"c.  Travel",null,{"$f":"ROUND(Summary!C23,0)","v":0},{"$f":"ROUND(Summary!D23,0)","v":0},{"$f":"ROUND(Summary!E23,0)","v":0},{"$f":"ROUND(Summary!F23,0)","v":0},{"$f":"ROUND(Summary!G23,0)","v":0},0]
[null,null,"d.  Equipment",null,{"$f":"ROUND(Summary!C24,0)","v":0},{"$f":"ROUND(Summary!D24,0)","v":0},{"$f":"ROUND(Summary!E24,0)","v":0},{"$f":"ROUND(Summary!F24,0)","v":0},{"$f":"ROUND(Summary!G24,0)","v":0},0]
[null,null,"e.  Supplies",null,{"$f":"ROUND(Summary!C25,0)","v":0},{"$f":"ROUND(Summary!D25,0)","v":0},{"$f":"ROUND(Summary!E25,0)","v":0},{"$f":"ROUND(Summary!F25,0)","v":0},{"$f":"ROUND(Summary!G25,0)","v":0},0]
[null,null,"f.  Contractual",null,{"$f":"ROUND(Summary!C30,0)-Summary!C29","v":0},{"$f":"ROUND(Summary!D30,0)-Summary!D29","v":0},{"$f":"ROUND(Summary!E30,0)-Summary!E29","v":0},{"$f":"ROUND(Summary!F30,0)-Summary!F29","v":0},{"$f":"ROUND(Summary!G30,0)-Summary!G29","v":0},0]
[null,null,"g.  Construction",null,{"$f":"ROUND(Summary!C31,0)","v":0},{"$f":"ROUND(Summary!D31,0)","v":0},{"$f":"ROUND(Summary!E31,0)","v":0},{"$f":"ROUND(Summary!F31,0)","v":0},{"$f":"ROUND(Summary!G31,0)","v":0},0]
[null,null,"h.  Other",null,{"$f":"ROUND(Summary!C32,0)","v":0},{"$f":"ROUND(Summary!D32,0)","v":0},{"$f":"ROUND(Summary!E32,0)","v":0},{"$f":"ROUND(Summary!F32,0)","v":0},{"$f":"ROUND(Summary!G32,0)","v":0},0]
[null,null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"ROUND(Summary!C33,0)","v":0},{"$f":"ROUND(Summary!D33,0)","v":0},{"$f":"ROUND(Summary!E33,0)","v":0},{"$f":"ROUND(Summary!F33,0)","v":0},{"$f":"ROUND(Summary!G33,0)","v":0},0]
[null,null,"j.  Indirect Charges",null,{"$f":"ROUND(Summary!C34,0)","v":0},{"$f":"ROUND(Summary!D34,0)","v":0},{"$f":"ROUND(Summary!E34,0)","v":0},{"$f":"ROUND(Summary!F34,0)","v":0},{"$f":"ROUND(Summary!G34,0)","v":0},0]
[null,null,"k.  Totals (sum of 6i-6j)",null,{"$f":"ROUND(SUM(E29:E30),0)","v":0},0,0,0,0,0]
[]
[null,"7.","Program Income",null,0,0,0,0,0,{"$f":"ROUND(SUM(E33:H33),0)","v":0}]
[null,"Section C - Non-Federal Resources"]
[null,null,"(a) Grant Program",null,"(b) Applicant","(c ) State","(d) Other Sources",null,null,"(e) Totals"]
[null,"8.",{"$f":"G5","v":0},null,{"$f":"ROUND('k. Non-Federal Resources'!I22+'j. Cost Share'!J28,0)","v":0},{"$f":"ROUND('k. Non-Federal Resources'!I38,0)","v":0},{"$f":"ROUND('k. Non-Federal Resources'!I54,0)","v":0},null,null,{"$f":"ROUND(SUM(E36:G36),0)","v":0}]
[null,"9.",{"$nulls":7},{"$f":"ROUND(SUM(E37:G37),0)","v":0}]
[null,"10.",{"$nulls":7},0]
[null,"11.",{"$nulls":7},0]
[null,"12. TOTAL (sum of lines 8-11)",null,null,{"$f":"ROUND(SUM(E36:E39),0)","v":0},{"$f":"ROUND(SUM(F36:F39),0)","v":0},{"$f":"ROUND(SUM(G36:G39),0)","v":0},null,null,{"$f":"ROUND(SUM(J36:J39),0)","v":0}]
[]
[{"$nulls":9},"Standard Form 424A (Rev. 7- 97)"]
[{"$nulls":8},"Prescribed by OMB (Circular A-102)"]
[null,"Authorized for Local Reproduction"]