{"text_format":"2","workbook":"xlsx","n_sheets":14,"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 Cost Categories","SF-424A Minus FFRDC"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":113,"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":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,4,5,9],[8,1,12,2],[10,5,10,8],[15,2,15,5],[15,8,15,12],[13,7,14,12],[6,4,8,9],[8,11,12,12],[4,1,6,2],[4,11,6,12],[13,1,13,5],[14,1,14,5],[9,4,9,9],[0,0,0,13],[3,1,3,5],[3,7,3,12],[2,2,2,5],[2,8,2,12]]}
["Budget Justification Workbook Instructions"]
[]
[null,1,"What is a Budget Justification Workbook?",{"$nulls":4},2,"Budget Category Tabs vs.\n Funding Allocation Tabs"]
[null,"The budget justification workbook allows applicants and recipients to break down total project costs into nine budget categories and the resources allocated for the project into two categories (Federal Share and Cost Share/Non-federal).",{"$nulls":5},"Budget Category Worksheets (a. Personnel through i. Indirect): These worksheets are used to break down and justify costs by specific categories. Each worksheet corresponds to a different budget category."]
[null,"All costs must be reasonable, allocable, and allowable and directly relevant to the project, including costs paid for with cost share. All costs must be justified in the project.",{"$nulls":9},"Cost Share (j.): This worksheet is used to identify resources and contributions to the project other than the DOE federal funding and should reflect the cost share funds allocated to the project in worksheets a. Personnel through i. Indirect."]
[{"$nulls":4},"WAIT! READ THIS BEFORE you get started."]
[{"$nulls":4},"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 Workbook will default to include one Budget Period. \n\nA Budget Period is defined as 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.\nFor more information, please refer to the most recent DOE Guide to Financial Assistance located under the Financial Assistance Policy and Guidance heading at:"]
[]
[null,"All worksheets are password protected to preserve the integrity of formulas. However, extra rows have been included on each worksheet 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},"The budget justification must adhere to the Department of Energy's financial assistance regulations (2 CFR Part 200, as adopted and supplemented by 2 CFR Part 910).\nApplicants/recipients are encouraged to review these regulations prior to completing the Budget Justification.\n\nIf you need assistance, consult the DOE contact. "]
[{"$nulls":4},"https://www.energy.gov/management/financial-assistance"]
[{"$nulls":5},"Make Selection"]
[]
[]
[null,"2) Select All Cells: Press the Ctrl + A keys simultaneously. This action will select all cells on the active worksheet.",{"$nulls":5},"Double-check for completeness. Before submitting, ensure all required fields in each worksheet are completed. Cells requiring information will dynamically highlight yellow to alert for any missing information."]
[null,"3) Unhide Rows: Once all cells are selected, press the Ctrl + SHIFT + 9 keys simultaneously. This action will unhide any hidden rows within the selected range."]
[null,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":[[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],[1,3,2,8],[9,1,9,9],[18,5,19,5],[18,6,19,6],[5,8,5,9],[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],[35,1,35,5],[12,3,12,4],[13,3,13,4],[18,7,19,7],[17,3,17,4],[35,6,35,7],[12,5,12,6],[13,5,13,6],[14,5,14,6]]}
[]
[null,"Detailed Budget Justification",null,"Summary"]
[null,"Rev. 4/16/2026"]
[null,"Award Number:",{"$nulls":4},"Date of Submission:"]
[null,"Award Recipient:",{"$nulls":4},"Form submitted by: "]
[{"$nulls":8},"(May be award recipient or sub-recipient)"]
[null,"Please read the instructions on each worksheet before starting. For all questions, please consult the DOE contact."]
[null,"1. This workbook should be used to provide detailed budget information for award application, negotiation, or budget revision. Totals from this tab auto-populate the SF-424A tabs, rounded to the nearest dollar.\n2. This summary tab will auto-populate with information provided in worksheets a. Personnel through j. Cost Share. Budget information is NOT entered on this tab.\n3. Fill out the blank white cells in worksheets a. Personnel through j. Cost Share with detailed information on and support for project costs in each Category line item within each worksheet. \n4. The total budget presented on worksheets a. Personnel through j. Cost Share must include both Federal (DOE) and Non-Federal (cost share) portions.\n5. All costs to be incurred by the preparer's subrecipients, contractors, and Federally Funded Research and Development Centers (FFRDCs), should be entered only in worksheet f. Contractual. All other worksheets 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. Do not add rows to this Summary tab.\n8. If the project requires more than five Budget Periods, consult the DOE contact before adding additional Budget Period rows or columns."]
[]
[null,"SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent worksheets. Only blank white cells require data entry"]
[null,"Section A - Budget Summary",null,"Federal",null,"Cost Share",null,"Total Project Costs","Cost Share %","Comments (as needed)"]
[null,"NEED MORE BUDGET\nPERIODS?\nNavigate to the \"Instructions\" tab and select the number of Budget Periods for the project in cell F11."]
[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'!F49","v":0},{"$f":"'a. Personnel'!I49","v":0},{"$f":"'a. Personnel'!L49","v":0},{"$f":"'a. Personnel'!O49","v":0},{"$f":"'a. Personnel'!R49","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C21,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C21+D21),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C21+D21+E21),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C21+D21+E21+F21),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C21+D21+E21+F21+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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C22,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C22+D22),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C22+D22+E22),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C22+D22+E22+F22),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C22+D22+E22+F22+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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C23,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C23+D23),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C23+D23+E23),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C23+D23+E23+F23),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C23+D23+E23+F23+G23))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C24,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C24+D24),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C24+D24+E24),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C24+D24+E24+F24),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C24+D24+E24+F24+G24))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C25,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C25+D25),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C25+D25+E25),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C25+D25+E25+F25),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C25+D25+E25+F25+G25))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C27,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C27+D27),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C27+D27+E27),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C27+D27+E27+F27),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C27+D27+E27+F27+G27))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C28,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C28+D28),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C28+D28+E28),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C28+D28+E28+F28),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C28+D28+E28+F28+G28))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C29,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C29+D29),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C29+D29+E29),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C29+D29+E29+F29),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C29+D29+E29+F29+G29))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C30,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C30+D30),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C30+D30+E30),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C30+D30+E30+F30),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C30+D30+E30+F30+G30))","v":0},{"$f":"IF(H30>0,H30/H18,0)","v":0}]
[null,"g. Construction",{"$f":"'g. Construction'!D27","v":0},{"$f":"'g. Construction'!D44","v":0},{"$f":"'g. Construction'!D61","v":0},{"$f":"'g. Construction'!D78","v":0},{"$f":"'g. Construction'!D95","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C31,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C31+D31),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C31+D31+E31),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C31+D31+E31+F31),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C31+D31+E31+F31+G31))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C32,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C32+D32),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C32+D32+E32),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C32+D32+E32+F32),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C32+D32+E32+F32+G32))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C33,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C33+D33),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C33+D33+E33),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C33+D33+E33+F33),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C33+D33+E33+F33+G33))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",C34,\nInstructions!$F$11=\"2 Budget Periods\",SUM(C34+D34),\nInstructions!$F$11=\"3 Budget Periods\",SUM(C34+D34+E34),\nInstructions!$F$11=\"4 Budget Periods\",SUM(C34+D34+E34+F34),\nInstructions!$F$11=\"5 Budget Periods\",SUM(C34+D34+E34+F34+G34))","v":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}]
[{"$nulls":6},"Fringe Benefits + Indirect Charges \nAgainst Total Project Costs",null,{"$f":"IF((H22+H34)<=0,0,((H22+H34)/H18))","v":0}]
[null,"Additional Explanation (as needed):"]

{"sheet":"a. Personnel","index":2,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,1,51,20],[10,2,11,2],[49,1,49,4],[10,1,11,1],[10,20,11,20],[10,19,11,19],[10,12,10,14],[10,15,10,17],[48,1,48,2],[1,18,1,20],[10,3,10,5],[10,6,10,8],[10,9,10,11],[1,1,1,2],[3,1,3,20],[5,1,5,20],[8,1,8,20],[2,1,2,20],[10,18,11,18],[6,1,6,18],[7,1,7,17]]}
[]
[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 in worksheet f. Contractual.\n2. All personnel should be identified by position title and not employee name. Enter the amount of time and the base hourly rate and the total direct personnel compensation will automatically calculate. Rate basis (e.g., rate negotiated for each hour worked on the project, labor distribution report, state civil service rates, etc.) must also be identified.  If any other methodology is used to pay employees, please provide an explanation.  No profit may be included in personnel rates.\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 1,000 hours each for a total of 4,000 hours).\n4. 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) that were captured in the labor costs. Total Indirect Costs Loaded into Labor Rates:  ($)"]
[{"$nulls":19},"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. to ensure no fee or profit are 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,"Total Project  Hours","Total Project Costs","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,"E.g. Sr. Engineer",2000,85,{"$f":"D13*E13","v":170000},200,85,{"$f":"G13*H13","v":17000},200,85,{"$f":"J13*K13","v":17000},200,85,{"$f":"M13*N13","v":17000},200,85,{"$f":"P13*Q13","v":17000},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",D13,\nInstructions!$F$11=\"1 Budget Period\",D13,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D13+G13),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D13+G13+J13),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D13+G13+J13+M13),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D13+G13+J13+M13+P13))","v":2000},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",F13,\nInstructions!$F$11=\"1 Budget Period\",F13,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F13+I13),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F13+I13+L13),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F13+I13+L13+O13),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F13+I13+L13+O13+R13))","v":170000},"Actual Salary"]
[null,2,"E.g. Program Manager",1500,50,75000,150,50,7500,150,50,7500,0,0,0,0,0,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",D14,\nInstructions!$F$11=\"1 Budget Period\",D14,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D14+G14),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D14+G14+J14),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D14+G14+J14+M14),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D14+G14+J14+M14+P14))","v":1500},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",F14,\nInstructions!$F$11=\"1 Budget Period\",F14,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F14+I14),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F14+I14+L14),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F14+I14+L14+O14),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F14+I14+L14+O14+R14))","v":75000},"Actual Salary"]
[{"$nulls":5},{"$f":"D15*E15","v":0},null,null,{"$f":"G15*H15","v":0},null,null,{"$f":"J15*K15","v":0},null,null,{"$f":"M15*N15","v":0},null,null,{"$f":"P15*Q15","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D15,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D15+G15),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D15+G15+J15),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D15+G15+J15+M15),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D15+G15+J15+M15+P15))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F15,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F15+I15),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F15+I15+L15),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F15+I15+L15+O15),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F15+I15+L15+O15+R15))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D16,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D16+G16),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D16+G16+J16),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D16+G16+J16+M16),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D16+G16+J16+M16+P16))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F16,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F16+I16),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F16+I16+L16),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F16+I16+L16+O16),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F16+I16+L16+O16+R16))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D17,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D17+G17),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D17+G17+J17),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D17+G17+J17+M17),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D17+G17+J17+M17+P17))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F17,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F17+I17),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F17+I17+L17),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F17+I17+L17+O17),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F17+I17+L17+O17+R17))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D18,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D18+G18),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D18+G18+J18),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D18+G18+J18+M18),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D18+G18+J18+M18+P18))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F18,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F18+I18),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F18+I18+L18),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F18+I18+L18+O18),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F18+I18+L18+O18+R18))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D19,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D19+G19),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D19+G19+J19),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D19+G19+J19+M19),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D19+G19+J19+M19+P19))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F19,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F19+I19),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F19+I19+L19),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F19+I19+L19+O19),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F19+I19+L19+O19+R19))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D20,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D20+G20),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D20+G20+J20),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D20+G20+J20+M20),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D20+G20+J20+M20+P20))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F20,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F20+I20),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F20+I20+L20),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F20+I20+L20+O20),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F20+I20+L20+O20+R20))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D21,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D21+G21),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D21+G21+J21),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D21+G21+J21+M21),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D21+G21+J21+M21+P21))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F21,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F21+I21),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F21+I21+L21),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F21+I21+L21+O21),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F21+I21+L21+O21+R21))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D22,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D22+G22),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D22+G22+J22),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D22+G22+J22+M22),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D22+G22+J22+M22+P22))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F22,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F22+I22),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F22+I22+L22),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F22+I22+L22+O22),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F22+I22+L22+O22+R22))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D23,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D23+G23),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D23+G23+J23),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D23+G23+J23+M23),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D23+G23+J23+M23+P23))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F23,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F23+I23),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F23+I23+L23),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F23+I23+L23+O23),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F23+I23+L23+O23+R23))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D24,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D24+G24),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D24+G24+J24),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D24+G24+J24+M24),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D24+G24+J24+M24+P24))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F24,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F24+I24),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F24+I24+L24),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F24+I24+L24+O24),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F24+I24+L24+O24+R24))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D25,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D25+G25),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D25+G25+J25),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D25+G25+J25+M25),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D25+G25+J25+M25+P25))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F25,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F25+I25),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F25+I25+L25),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F25+I25+L25+O25),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F25+I25+L25+O25+R25))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D26,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D26+G26),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D26+G26+J26),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D26+G26+J26+M26),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D26+G26+J26+M26+P26))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F26,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F26+I26),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F26+I26+L26),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F26+I26+L26+O26),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F26+I26+L26+O26+R26))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D27,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D27+G27),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D27+G27+J27),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D27+G27+J27+M27),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D27+G27+J27+M27+P27))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F27,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F27+I27),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F27+I27+L27),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F27+I27+L27+O27),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F27+I27+L27+O27+R27))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D28,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D28+G28),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D28+G28+J28),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D28+G28+J28+M28),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D28+G28+J28+M28+P28))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F28,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F28+I28),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F28+I28+L28),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F28+I28+L28+O28),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F28+I28+L28+O28+R28))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D29,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D29+G29),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D29+G29+J29),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D29+G29+J29+M29),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D29+G29+J29+M29+P29))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F29,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F29+I29),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F29+I29+L29),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F29+I29+L29+O29),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F29+I29+L29+O29+R29))","v":0}]
[{"$nulls":5},{"$f":"D30*E30","v":0},null,null,{"$f":"G30*H30","v":0},null,null,{"$f":"J30*K30","v":0},null,null,{"$f":"M30*N30","v":0},null,null,{"$f":"P30*Q30","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D30,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D30+G30),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D30+G30+J30),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D30+G30+J30+M30),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D30+G30+J30+M30+P30))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F30,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F30+I30),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F30+I30+L30),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F30+I30+L30+O30),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F30+I30+L30+O30+R30))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D31,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D31+G31),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D31+G31+J31),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D31+G31+J31+M31),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D31+G31+J31+M31+P31))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F31,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F31+I31),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F31+I31+L31),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F31+I31+L31+O31),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F31+I31+L31+O31+R31))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D32,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D32+G32),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D32+G32+J32),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D32+G32+J32+M32),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D32+G32+J32+M32+P32))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F32,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F32+I32),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F32+I32+L32),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F32+I32+L32+O32),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F32+I32+L32+O32+R32))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D33,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D33+G33),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D33+G33+J33),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D33+G33+J33+M33),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D33+G33+J33+M33+P33))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F33,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F33+I33),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F33+I33+L33),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F33+I33+L33+O33),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F33+I33+L33+O33+R33))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D34,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D34+G34),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D34+G34+J34),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D34+G34+J34+M34),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D34+G34+J34+M34+P34))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F34,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F34+I34),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F34+I34+L34),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F34+I34+L34+O34),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F34+I34+L34+O34+R34))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D35,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D35+G35),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D35+G35+J35),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D35+G35+J35+M35),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D35+G35+J35+M35+P35))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F35,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F35+I35),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F35+I35+L35),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F35+I35+L35+O35),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F35+I35+L35+O35+R35))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D36,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D36+G36),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D36+G36+J36),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D36+G36+J36+M36),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D36+G36+J36+M36+P36))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F36,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F36+I36),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F36+I36+L36),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F36+I36+L36+O36),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F36+I36+L36+O36+R36))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D37,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D37+G37),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D37+G37+J37),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D37+G37+J37+M37),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D37+G37+J37+M37+P37))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F37,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F37+I37),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F37+I37+L37),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F37+I37+L37+O37),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F37+I37+L37+O37+R37))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D38,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D38+G38),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D38+G38+J38),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D38+G38+J38+M38),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D38+G38+J38+M38+P38))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F38,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F38+I38),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F38+I38+L38),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F38+I38+L38+O38),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F38+I38+L38+O38+R38))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D39,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D39+G39),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D39+G39+J39),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D39+G39+J39+M39),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D39+G39+J39+M39+P39))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F39,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F39+I39),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F39+I39+L39),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F39+I39+L39+O39),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F39+I39+L39+O39+R39))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"P40*Q40","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D40,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D40+G40),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D40+G40+J40),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D40+G40+J40+M40),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D40+G40+J40+M40+P40))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F40,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F40+I40),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F40+I40+L40),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F40+I40+L40+O40),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F40+I40+L40+O40+R40))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"P41*Q41","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D41,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D41+G41),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D41+G41+J41),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D41+G41+J41+M41),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D41+G41+J41+M41+P41))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F41,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F41+I41),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F41+I41+L41),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F41+I41+L41+O41),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F41+I41+L41+O41+R41))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D42,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D42+G42),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D42+G42+J42),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D42+G42+J42+M42),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D42+G42+J42+M42+P42))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F42,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F42+I42),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F42+I42+L42),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F42+I42+L42+O42),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F42+I42+L42+O42+R42))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D43,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D43+G43),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D43+G43+J43),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D43+G43+J43+M43),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D43+G43+J43+M43+P43))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F43,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F43+I43),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F43+I43+L43),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F43+I43+L43+O43),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F43+I43+L43+O43+R43))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D44,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D44+G44),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D44+G44+J44),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D44+G44+J44+M44),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D44+G44+J44+M44+P44))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F44,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F44+I44),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F44+I44+L44),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F44+I44+L44+O44),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F44+I44+L44+O44+R44))","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D45,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D45+G45),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D45+G45+J45),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D45+G45+J45+M45),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D45+G45+J45+M45+P45))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F45,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F45+I45),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F45+I45+L45),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F45+I45+L45+O45),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F45+I45+L45+O45+R45))","v":0}]
[{"$nulls":5},{"$f":"D46*E46","v":0},null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D46,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D46+G46),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D46+G46+J46),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D46+G46+J46+M46),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D46+G46+J46+M46+P46))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F46,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F46+I46),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F46+I46+L46),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F46+I46+L46+O46),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F46+I46+L46+O46+R46))","v":0}]
[{"$nulls":5},{"$f":"D47*E47","v":0},null,null,{"$f":"G47*H47","v":0},null,null,{"$f":"J47*K47","v":0},null,null,{"$f":"M47*N47","v":0},null,null,{"$f":"P47*Q47","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D47,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D47+G47),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D47+G47+J47),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D47+G47+J47+M47),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D47+G47+J47+M47+P47))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F47,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F47+I47),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F47+I47+L47),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F47+I47+L47+O47),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F47+I47+L47+O47+R47))","v":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},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D48,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D48+G48),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D48+G48+J48),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D48+G48+J48+M48),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D48+G48+J48+M48+P48))","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F48,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F48+I48),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F48+I48+L48),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F48+I48+L48+O48),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F48+I48+L48+O48+R48))","v":0}]
[null,"TOTAL PERSONNEL",null,{"$f":"SUM(D15:D48)","v":0},null,{"$f":"SUM(F15:F48)","v":0},{"$f":"SUM(G15:G48)","v":0},null,{"$f":"SUM(I15:I48)","v":0},{"$f":"SUM(J15:J48)","v":0},null,{"$f":"SUM(L15:L48)","v":0},{"$f":"SUM(M15:M48)","v":0},null,{"$f":"SUM(O15:O48)","v":0},{"$f":"SUM(P15:P48)","v":0},null,{"$f":"SUM(R15:R48)","v":0},{"$f":"SUM(D49+G49+J49+M49+P49)","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F49,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F49+I49),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F49+I49+L49),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F49+I49+L49+O49),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F49+I49+L49+O49+R49))","v":0}]
[]
[null,"Additional Explanation (as needed):"]

{"sheet":"b. Fringe","index":3,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,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],[12,1,12,4],[9,1,9,4],[15,1,15,4],[33,1,33,20],[23,1,23,4],[20,1,20,4],[1,1,1,13],[2,1,2,20],[18,1,18,4],[17,1,17,4],[16,1,16,4],[10,1,10,4],[11,1,11,4],[21,1,21,4],[22,1,22,4],[19,1,19,4],[14,1,14,4],[13,1,13,4],[30,3,30,15],[32,3,32,15],[26,1,26,9],[31,3,31,9],[29,3,29,14],[27,3,27,14],[28,3,28,8]]}
[]
[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 with 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. 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,"E.g. Sr. Engineer",null,null,null,170000,0.2,{"$f":"F8*G8","v":34000},17000,0.2,{"$f":"I8*J8","v":3400},17000,0.2,{"$f":"L8*M8","v":3400},17000,0.2,{"$f":"O8*P8","v":3400},17000,0.2,{"$f":"R8*S8","v":3400},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",H8,\nInstructions!$F$11=\"1 Budget Period\",H8,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H8+K8),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H8+K8+N8),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H8+K8+N8+Q8),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H8+K8+N8+Q8+T8))","v":34000}]
[{"$nulls":7},{"$f":"G9*F9","v":0},null,null,0,null,null,0,null,null,0,null,null,{"$f":"R9*S9","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H9,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H9+K9),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H9+K9+N9),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H9+K9+N9+Q9),\nInstructions!$F$11=\"5 Budget Periods\",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,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H10,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H10+K10),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H10+K10+N10),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H10+K10+N10+Q10),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H10+K10+N10+Q10+T10))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H11,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H11+K11),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H11+K11+N11),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H11+K11+N11+Q11),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H11+K11+N11+Q11+T11))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H12,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H12+K12),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H12+K12+N12),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H12+K12+N12+Q12),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H12+K12+N12+Q12+T12))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"R13*S13","v":0},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H13,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H13+K13),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H13+K13+N13),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H13+K13+N13+Q13),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H13+K13+N13+Q13+T13))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H14,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H14+K14),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H14+K14+N14),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H14+K14+N14+Q14),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H14+K14+N14+Q14+T14))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H15,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H15+K15),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H15+K15+N15),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H15+K15+N15+Q15),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H15+K15+N15+Q15+T15))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H16,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H16+K16),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H16+K16+N16),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H16+K16+N16+Q16),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H16+K16+N16+Q16+T16))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H17,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H17+K17),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H17+K17+N17),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H17+K17+N17+Q17),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H17+K17+N17+Q17+T17))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H18,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H18+K18),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H18+K18+N18),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H18+K18+N18+Q18),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H18+K18+N18+Q18+T18))","v":0}]
[{"$nulls":7},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H19,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H19+K19),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H19+K19+N19),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H19+K19+N19+Q19),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H19+K19+N19+Q19+T19))","v":0}]
[{"$nulls":7},{"$f":"G20*F20","v":0},null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H20,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H20+K20),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H20+K20+N20),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H20+K20+N20+Q20),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H20+K20+N20+Q20+T20))","v":0}]
[{"$nulls":7},{"$f":"G21*F21","v":0},null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H21,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H21+K21),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H21+K21+N21),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H21+K21+N21+Q21),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H21+K21+N21+Q21+T21))","v":0}]
[{"$nulls":7},{"$f":"G22*F22","v":0},null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H22,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H22+K22),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H22+K22+N22),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H22+K22+N22+Q22),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H22+K22+N22+Q22+T22))","v":0}]
[{"$nulls":7},{"$f":"G23*F23","v":0},null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H23,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H23+K23),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H23+K23+N23),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H23+K23+N23+Q23),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H23+K23+N23+Q23+T23))","v":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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",H24,\nInstructions!$F$11=\"2 Budget Periods\",SUM(H24+K24),\nInstructions!$F$11=\"3 Budget Periods\",SUM(H24+K24+N24),\nInstructions!$F$11=\"4 Budget Periods\",SUM(H24+K24+N24+Q24),\nInstructions!$F$11=\"5 Budget Periods\",SUM(H24+K24+N24+Q24+T24))","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 þ one of the options below and provide the requested information if not previously submitted."]
[null,"FRINGE BENEFITS (If fringe costs are being allocated under a segregated fringe billing rate):"]
[null,null,false," A fringe billing rate has been negotiated with, or approved by, a federal government agency and the fringe billing rate is identified in the Agreement. "]
[null,null,null," A copy of the latest rate agreement is/was included with the project application."]
[null,null,false," A federally-approved rate agreement has been negotiated and available; however, the fringe billing rate IS NOT identified in the Agreement.*"]
[null,null,null,"* 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,null,false," There is not a current federally approved rate agreement negotiated and available.**"]
[null,null,null,"** 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":159,"n_cols":14,"rows_kept":159,"cut":false,"hidden":false,"merged":[[156,1,156,2],[157,1,157,2],[157,3,157,7],[158,1,158,2],[158,3,158,7],[156,3,156,7],[155,1,155,2],[155,3,155,7],[23,3,23,13],[3,1,3,13],[151,1,152,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],[2,1,2,13],[1,1,1,2],[6,3,6,13],[36,3,36,13],[64,3,64,13],[63,1,63,2],[35,1,35,2]]}
[]
[null,"Detailed Budget Justification "]
[null,"c. Travel"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. All travel must be reasonable and necessary for performance of the Statement of Project Objectives. Extended travel, Foreign travel, and/or significant number of travelers should be clearly justified under Additional Explanation.\n2. Federal travel regulations are contained within the applicable cost principles for all entity types. \n3. Travel costs should be consistent with the organization's written travel policy and incurred during normal business operations. In the absence of a written travel policy, organizations must follow the Federal Travel Regulations found at: https://www.ecfr.gov/current/title-41/subtitle-F (Active links can be found below).\n           a) For Foreign Travel please visit: 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 reasonableness. In the absence of a written travel policy, \n               organizations must follow GSA's Local Travel Policy.\n4. Identify Domestic and Foreign Travel as separate items. \n5. The Purpose of Travel must be necessary for achieving the objectives of the project. Examples include: subrecipient site visits, DOE meetings, project management meetings, etc. \n6. Please enter City and State (or City and Country for Foreign travel) in the Depart From and Destination fields.\n7. The number of days is inclusive of the day of departure and the day of return. Allowable per diem is adjusted to 75% for both the day of departure and the day of return.\n8. Provide a specific Basis for Estimating Costs. Examples include 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, costs of past trips, etc.\n9. If a conference is included in the travel budget, please provide answers to the following questions in the Additional Explanation section at the bottom of the form:\n          a) Please list the name of the conference in Purpose of Travel and explain how attending this conference will further the goals of the project. Conference registration fees should be listed on the h. Other worksheet.\n          b) Please confirm that the project attendees will not be funded by any other Federal awards.   \n          c) Please indicate whether any other business unrelated to the project will be conducted while attending the conference.                                                                                         \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)","Lodging ($) (Per night, per traveler)","Per Diem ($) (Per traveler)","Ground Transport ($) (Per trip, ALL travelers)","Cost per Trip ($)","Basis for Estimating Costs"]
[null,null,"Domestic Travel","                                                             Budget Period 1"]
[null,1,"E.g. Visit to PV manufacturer","Dallas, TX","Denver, CO",2,4,3,500,200,80,200,{"$f":"IF(H8=0, (I8*F8)+L8+(K8*0.75)*G8*F8, IF(AND(H8>0,H8<2), (I8*F8)+L8+(J8*H8*F8)+(K8*0.75)*G8*F8, ((I8*F8)+L8+(J8*H8*F8)+(K8*0.75)*2*F8)+(K8*(G8-2)*F8)))","v":2960},"Current GSA rates"]
[{"$nulls":12},{"$f":"IF(H9=0, (I9*F9)+L9+(K9*0.75)*G9*F9, IF(AND(H9>0,H9<2), (I9*F9)+L9+(J9*H9*F9)+(K9*0.75)*G9*F9, ((I9*F9)+L9+(J9*H9*F9)+(K9*0.75)*2*F9)+(K9*(G9-2)*F9)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,null,"Foreign Travel"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},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":"IF(H38=0, (I38*F38)+L38+(K38*0.75)*G38*F38, IF(AND(H38>0,H38<2), (I38*F38)+L38+(J38*H38*F38)+(K38*0.75)*G38*F38, ((I38*F38)+L38+(J38*H38*F38)+(K38*0.75)*2*F38)+(K38*(G38-2)*F38)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,null,"Foreign Travel"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},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":"IF(H66=0, (I66*F66)+L66+(K66*0.75)*G66*F66, IF(AND(H66>0,H66<2), (I66*F66)+L66+(J66*H66*F66)+(K66*0.75)*G66*F66, ((I66*F66)+L66+(J66*H66*F66)+(K66*0.75)*2*F66)+(K66*(G66-2)*F66)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,null,"Foreign Travel"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},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":"IF(H94=0, (I94*F94)+L94+(K94*0.75)*G94*F94, IF(AND(H94>0,H94<2), (I94*F94)+L94+(J94*H94*F94)+(K94*0.75)*G94*F94, ((I94*F94)+L94+(J94*H94*F94)+(K94*0.75)*2*F94)+(K94*(G94-2)*F94)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,null,"Foreign Travel"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},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":"IF(H122=0, (I122*F122)+L122+(K122*0.75)*G122*F122, IF(AND(H122>0,H122<2), (I122*F122)+L122+(J122*H122*F122)+(K122*0.75)*G122*F122, ((I122*F122)+L122+(J122*H122*F122)+(K122*0.75)*2*F122)+(K122*(G122-2)*F122)))","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,null,"Foreign Travel"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[null,"Budget Period 5 Total",{"$nulls":10},{"$f":"SUM(M122:M135)+SUM(M137:M147)","v":0}]
[]
[null,"TOTAL TRAVEL",{"$nulls":10},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",M36,\nInstructions!$F$11=\"2 Budget Periods\",SUM(M36+M64),\nInstructions!$F$11=\"3 Budget Periods\",SUM(M36+M64+M92),\nInstructions!$F$11=\"4 Budget Periods\",SUM(M36+M64+M92+M120),\nInstructions!$F$11=\"5 Budget Periods\",SUM(M36+M64+M92+M120+M148))","v":0}]
[]
[null,"Additional Explanation (as needed):"]
[]
[]
[null,null,"For more information, please reference:"]
[null,"Federal Travel Regulations: ",null,"https://www.ecfr.gov/current/title-41/subtitle-F"]
[null,"U.S. State Department Foreign Travel:",null,"https://allowances.state.gov/web920/per_diem.asp"]
[null,"General Services Administration Local Travel Policy:",null,"https://www.gsa.gov/directives-library/local-travel-policy"]
[null,"GSA Per Diem Rates",null,"https://www.gsa.gov/travel/plan-book/per-diem-rates"]

{"sheet":"d. Equipment","index":5,"n_rows":107,"n_cols":8,"rows_kept":107,"cut":false,"hidden":false,"merged":[[106,2,106,4],[104,2,104,3],[105,2,105,4],[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. For-profit recipients must file UCC financing statements in the state where equipment will be located. For more information, see https://www.energy.gov/documents/ucc-financing-statement-guide and https://www.energy.gov/documents/recipient-guide-filing-ucc-financing-statements.\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","E.g. 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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F26,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F26+F44),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F26+F44+F62),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F26+F44+F62+F80),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F26+F44+F62+F80+F98))","v":0}]
[]
[null,"Additional Explanation (as needed):"]
[]
[]
[null,null,"For more information on UCC financing statements, see: "]
[null,null,"https://www.energy.gov/documents/ucc-financing-statement-guide"]
[null,null,"https://www.energy.gov/documents/recipient-guide-filing-ucc-financing-statements"]

{"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 and a useful life of more than one year should be included on the d. Equipment worksheet. If supply items and costs are ambiguous in nature, consult the DOE contact for proper categorization.  \n4. 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","E.g. 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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F68,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F68+F48),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F68+F48+F28),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F68+F48+F28+F88),\nInstructions!$F$11=\"5 Budget Periods\",SUM(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":[[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],[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],[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]]}
[]
[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) must submit a separate 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 with total project costs of $350,000 or more, a detailed Contractor quote must be provided. A contractor is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to a variety of 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): For DOE FFRDCs- Applicant/selectee must submit written work authorization from the sponsoring Federal agency/Cognizant Contracting Officer prior to award. For non-DOE FFRDCs- Applicant must submit written work authorization from the sponsoring Federal agency/Cognizant Contracting Officer with the application. The award recipient may allow the FFRDC to provide this information directly to DOE, however project costs must also be provided below.\n5. 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 \"Basis of Cost\", of how the cost was derived (i.e. personnel hours at rate of pay).  \n6. 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","E.g. XYZ Corp.","TLH6A6JLE1S7","Partner to develop optimal lens for Gen 2 product. ","Cost estimate based on personnel hours and materials-   680 hrs x $150/hr + $100,000 materials = $202,000",48000,32000,16000,{"$f":"SUM(G7:I7)","v":96000},10000,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",G7,\nInstructions!$F$11=\"1 Budget Period\",G7,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G7+H7),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G7+H7+I7),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G7+H7+I7+J7),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G7+H7+I7+J7+K7))","v":48000}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G8,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G8+H8),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G8+H8+I8),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G8+H8+I8+J8),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G8+H8+I8+J8+K8))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G9,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G9+H9),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G9+H9+I9),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G9+H9+I9+J9),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G9+H9+I9+J9+K9))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G10,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G10+H10),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G10+H10+I10),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G10+H10+I10+J10),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G10+H10+I10+J10+K10))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G11,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G11+H11),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G11+H11+I11),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G11+H11+I11+J11),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G11+H11+I11+J11+K11))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G12,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G12+H12),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G12+H12+I12),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G12+H12+I12+J12),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G12+H12+I12+J12+K12))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G13,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G13+H13),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G13+H13+I13),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G13+H13+I13+J13),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G13+H13+I13+J13+K13))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G14,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G14+H14),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G14+H14+I14),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G14+H14+I14+J14),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G14+H14+I14+J14+K14))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G15,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G15+H15),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G15+H15+I15),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G15+H15+I15+J15),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G15+H15+I15+J15+K15))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G16,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G16+H16),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G16+H16+I16),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G16+H16+I16+J16),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G16+H16+I16+J16+K16))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G17,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G17+H17),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G17+H17+I17),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G17+H17+I17+J17),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G17+H17+I17+J17+K17))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G18,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G18+H18),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G18+H18+I18),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G18+H18+I18+J18),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G18+H18+I18+J18+K18))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G19,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G19+H19),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G19+H19+I19),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G19+H19+I19+J19),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G19+H19+I19+J19+K19))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G20,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G20+H20),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G20+H20+I20),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G20+H20+I20+J20),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G20+H20+I20+J20+K20))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G21,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G21+H21),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G21+H21+I21),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G21+H21+I21+J21),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G21+H21+I21+J21+K21))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G22,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G22+H22),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G22+H22+I22),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G22+H22+I22+J22),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G22+H22+I22+J22+K22))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G23,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G23+H23),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G23+H23+I23),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G23+H23+I23+J23),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G23+H23+I23+J23+K23))","v":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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G27,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G27+H27),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G27+H27+I27),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G27+H27+I27+J27),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G27+H27+I27+J27+K27))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G28,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G28+H28),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G28+H28+I28),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G28+H28+I28+J28),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G28+H28+I28+J28+K28))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G29,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G29+H29),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G29+H29+I29),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G29+H29+I29+J29),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G29+H29+I29+J29+K29))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G30,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G30+H30),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G30+H30+I30),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G30+H30+I30+J30),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G30+H30+I30+J30+K30))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G31,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G31+H31),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G31+H31+I31),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G31+H31+I31+J31),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G31+H31+I31+J31+K31))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G32,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G32+H32),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G32+H32+I32),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G32+H32+I32+J32),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G32+H32+I32+J32+K32))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G33,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G33+H33),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G33+H33+I33),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G33+H33+I33+J33),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G33+H33+I33+J33+K33))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G34,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G34+H34),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G34+H34+I34),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G34+H34+I34+J34),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G34+H34+I34+J34+K34))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G35,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G35+H35),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G35+H35+I35),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G35+H35+I35+J35),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G35+H35+I35+J35+K35))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G36,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G36+H36),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G36+H36+I36),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G36+H36+I36+J36),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G36+H36+I36+J36+K36))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G37,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G37+H37),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G37+H37+I37),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G37+H37+I37+J37),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G37+H37+I37+J37+K37))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G38,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G38+H38),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G38+H38+I38),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G38+H38+I38+J38),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G38+H38+I38+J38+K38))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G39,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G39+H39),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G39+H39+I39),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G39+H39+I39+J39),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G39+H39+I39+J39+K39))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G40,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G40+H40),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G40+H40+I40),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G40+H40+I40+J40),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G40+H40+I40+J40+K40))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G41,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G41+H41),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G41+H41+I41),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G41+H41+I41+J41),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G41+H41+I41+J41+K41))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G42,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G42+H42),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G42+H42+I42),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G42+H42+I42+J42),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G42+H42+I42+J42+K42))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G43,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G43+H43),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G43+H43+I43),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G43+H43+I43+J43),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G43+H43+I43+J43+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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G47,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G47+H47),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G47+H47+I47),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G47+H47+I47+J47),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G47+H47+I47+J47+K47))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G48,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G48+H48),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G48+H48+I48),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G48+H48+I48+J48),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G48+H48+I48+J48+K48))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G49,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G49+H49),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G49+H49+I49),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G49+H49+I49+J49),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G49+H49+I49+J49+K49))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G50,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G50+H50),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G50+H50+I50),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G50+H50+I50+J50),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G50+H50+I50+J50+K50))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G51,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G51+H51),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G51+H51+I51),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G51+H51+I51+J51),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G51+H51+I51+J51+K51))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G52,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G52+H52),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G52+H52+I52),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G52+H52+I52+J52),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G52+H52+I52+J52+K52))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G53,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G53+H53),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G53+H53+I53),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G53+H53+I53+J53),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G53+H53+I53+J53+K53))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G54,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G54+H54),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G54+H54+I54),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G54+H54+I54+J54),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G54+H54+I54+J54+K54))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G55,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G55+H55),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G55+H55+I55),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G55+H55+I55+J55),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G55+H55+I55+J55+K55))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G56,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G56+H56),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G56+H56+I56),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G56+H56+I56+J56),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G56+H56+I56+J56+K56))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G57,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G57+H57),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G57+H57+I57),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G57+H57+I57+J57),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G57+H57+I57+J57+K57))","v":0}]
[{"$nulls":11},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",G58,\nInstructions!$F$11=\"2 Budget Periods\",SUM(G58+H58),\nInstructions!$F$11=\"3 Budget Periods\",SUM(G58+H58+I58),\nInstructions!$F$11=\"4 Budget Periods\",SUM(G58+H58+I58+J58),\nInstructions!$F$11=\"5 Budget Periods\",SUM(G58+H58+I58+J58+K58))","v":0}]
[{"$nulls":5},"Sub-total: ",{"$f":"SUM(G47:G58)","v":0},0,0,0,0,{"$f":"SUM(L47:L58)","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":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,5],[1,1,1,2],[2,1,2,5],[3,1,3,5],[98,1,99,5],[8,1,8,5],[27,1,27,5],[78,1,78,5],[44,1,44,5],[61,1,61,5],[96,1,96,2],[94,1,94,2],[77,1,77,2],[60,1,60,2],[43,1,43,2],[26,1,26,2]]}
[]
[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. 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,"E.g. 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(D11:D26)","v":0}]
[null,"Budget Period 2"]
{"$rows_empty":15}
[null,"Budget Period 2 Total",null,{"$f":"SUM(D29:D43)","v":0}]
[null,"Budget Period 3"]
{"$rows_empty":15}
[null,"Budget Period 3 Total",null,{"$f":"SUM(D46:D60)","v":0}]
[null,"Budget Period 4"]
{"$rows_empty":15}
[null,"Budget Period 4 Total",null,{"$f":"SUM(D63:D77)","v":0}]
[null,"Budget Period 5"]
{"$rows_empty":15}
[null,"Budget Period 5 Total",null,{"$f":"SUM(D80:D94)","v":0}]
[]
[null,"TOTAL CONSTRUCTION",null,{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D27,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D27+D44),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D27+D44+D61),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D27+D44+D61+D78),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D27+D44+D61+D78+D95))","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 that 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 include tuition, printing costs, usage fees, etc., that 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. If not providing a separate budget justification or specific quote, provide a detailed explanation and/or calculation used to calculate the cost for each line item in the Additional Explanation section.\n4. If additional rows are needed, please see instruction box #3 on the Instructions tab."]
[]
[null,"SOPO Task #","General Description "," Cost             ","Basis of Cost","Justification of Need"]
[null,"Budget Period 1"]
[null,1,"E.g. Grad student tuition - tasks 1-3",16000,"Four (4) students at $4,000 per semester","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":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",D26,\nInstructions!$F$11=\"2 Budget Periods\",SUM(D26+D44),\nInstructions!$F$11=\"3 Budget Periods\",SUM(D26+D44+D62),\nInstructions!$F$11=\"4 Budget Periods\",SUM(D26+D44+D62+D80),\nInstructions!$F$11=\"5 Budget Periods\",SUM(D26+D44+D62+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":[[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],[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],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,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 the DOE contact before filling out this section. \n3. The indirect rate may be applied to the Federal Share and Recipient Cost Share if the proposed costs are normally part of the indirect allocation base.\n4. NOTE: An applicant/recipient who elects to apply the de minimis Indirect Cost Rate per 2 C.F.R. §200.414(f) cannot claim the resulting costs as a Cost Share contribution. The resulting costs are not verifiable in the Recipient records as required under §200.306(b)(1)."]
[]
[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(_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F13,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F13+G13),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F13+G13+H13),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F13+G13+H13+I13),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F13+G13+H13+I13+J13)),0)","v":0}]
[null,"G&A Costs $",{"$nulls":8},{"$f":"ROUND(_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F14,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F14+G14),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F14+G14+H14),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F14+G14+H14+I14),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F14+G14+H14+I14+J14)),0)","v":0}]
[null,"FCCM Costs (if applicable) $",{"$nulls":8},{"$f":"ROUND(_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F15,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F15+G15),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F15+G15+H15),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F15+G15+H15+I15),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F15+G15+H15+I15+J15)),0)","v":0}]
[null," OTHER Indirect Costs $",{"$nulls":8},{"$f":"ROUND(_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F16,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F16+G16),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F16+G16+H16),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F16+G16+H16+I16),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F16+G16+H16+I16+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(_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",F17,\nInstructions!$F$11=\"2 Budget Periods\",SUM(F17+G17),\nInstructions!$F$11=\"3 Budget Periods\",SUM(F17+G17+H17),\nInstructions!$F$11=\"4 Budget Periods\",SUM(F17+G17+H17+I17),\nInstructions!$F$11=\"5 Budget Periods\",SUM(F17+G17+H17+I17+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.\nPlease check þ one of the options below and provide the requested information if it has not already been provided as requested or has changed.  "]
[]
[null,null,false,"    An indirect rate has been approved or negotiated with a federal government agency with a current effective period of: _____________________"]
[null,null,null,"    A copy of the latest rate agreement is included with this application and will be provided electronically to the Grants Officer for this project."]
[]
[null,null,false,"The organization does not have a current, federally approved indirect cost rate agreement and has provided an indirect rate proposal in support of the proposed costs."]
[]
[null,null,false,"This organization has elected to apply de minimis rate up to 15% in accordance with 2 CFR 200.414(f)."]
[]
[null,"Provide an explanation of how the indirect cost rate was applied."]
[]
[null,"Additional Explanation (as needed): *IMPORTANT:  Please use this box (or an attachment) to further explain how the total indirect costs were calculated.  If the total indirect costs are a cumulative amount of more than one calculation or rate application, the explanation and calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with the 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,31,8],[32,6,32,9]]}
[]
[null,"Detailed Budget Justification"]
[null,"j. Cost Share"]
[null,"INSTRUCTIONS - PLEASE READ!!!\n1. Provide a detailed accounting of the cash or cash value of all proposed cost share in the table below. Cost Share is not itself a budget category. Ensure each cost share item is reflected on the applicable worksheets a. Personnel through i. Indirect which are then captured in the respective budget Categories on the Summary tab and included in calculation of Total Project Cost. Identify the source organization and amount of each cost share item proposed. If a cost share item or dollar amount does not clearly align with the item on the related worksheet, please provide an explanation to clarify in the Additional Explanation section.\n2. Cost Share contributions are resources provided to the project by the recipient, subrecipient, or third party (an entity that does not have a role in performing the scope of work) that are not paid for using DOE federal funds. Funds from other federal sources may not be used as cost share unless explicitly authorized by specific statute. This prohibition includes funds from FFRDC subrecipients. Otherwise, non-federal sources include any source not originally derived from federal funds.\n3. All cost share items must be necessary and reasonable for achieving the objectives of the project. \n4. Cash cost share includes all monetary contributions to the project made by the recipient, subrecipient(s), or third party. If money is exchanged, for example, as reimbursement for an item or service (i.e., personnel salaries and benefits paid by the recipient or subrecipient), it qualifies as cash cost share.\n5. In-kind cost share can include goods or services contributed to the project by the recipient, subrecipient(s), or third party where a value of the resource can be readily determined, verified, and justified but where no actual cash is exchanged in securing the good or service. In-kind cost share items include volunteer time (of non-salaried employees), the donation of equipment/supplies, or use of space, etc. The cash value and calculations thereof for all in-kind cost share items must be explained and justified in the table below (Cost Share Item or Additional Explanation). If there are questions, consult the DOE contact before completing the table.\n6. Cost sharing commitment letters from subrecipients and third parties must be provided with the original application or upon request.\n7. 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. Contractors are not permitted to provide cost share. Any partial donation of goods or services is considered a discount and is not allowable.  \n9. Fee or profit, including foregone fee or profit, are not allowable as project costs (including cost share) unless explicitly authorized by the terms and conditions of the award. If the recipient earns program income during the project, it must be reallocated to the project. Please include any known or anticipated Program Income on the SF-424A Budget Information tab.\n10. NOTE: An applicant/recipient who elects to apply the de minimis Indirect Cost Rate per 2 C.F.R. §200.414(f) cannot claim the resulting costs as a Cost Share contribution. The resulting costs are not verifiable in the Recipient records as required under §200.306(b)(1). \"Unrecovered indirect costs\" cannot be claimed as a source of Cost Share resource, without prior approval. \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,"E.g., ABC Company","Cash","Project partner ABC Company will provide 20 PV modules for product development at the price of $680 per module",{"$f":"3*680","v":2040},{"$f":"3*680","v":2040},{"$f":"4*680","v":2720},{"$f":"5*680","v":3400},{"$f":"5*680","v":3400},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",E7,\nInstructions!$F$11=\"1 Budget Period\",E7,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E7+F7),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E7+F7+G7),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E7+F7+G7+H7),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E7+F7+G7+H7+I7))","v":2040}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E8,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E8+F8),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E8+F8+G8),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E8+F8+G8+H8),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E8+F8+G8+H8+I8))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E9,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E9+F9),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E9+F9+G9),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E9+F9+G9+H9),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E9+F9+G9+H9+I9))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E10,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E10+F10),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E10+F10+G10),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E10+F10+G10+H10),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E10+F10+G10+H10+I10))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E11,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E11+F11),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E11+F11+G11),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E11+F11+G11+H11),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E11+F11+G11+H11+I11))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E12,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E12+F12),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E12+F12+G12),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E12+F12+G12+H12),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E12+F12+G12+H12+I12))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E13,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E13+F13),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E13+F13+G13),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E13+F13+G13+H13),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E13+F13+G13+H13+I13))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E14,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E14+F14),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E14+F14+G14),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E14+F14+G14+H14),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E14+F14+G14+H14+I14))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E15,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E15+F15),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E15+F15+G15),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E15+F15+G15+H15),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E15+F15+G15+H15+I15))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E16,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E16+F16),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E16+F16+G16),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E16+F16+G16+H16),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E16+F16+G16+H16+I16))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E17,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E17+F17),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E17+F17+G17),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E17+F17+G17+H17),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E17+F17+G17+H17+I17))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E18,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E18+F18),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E18+F18+G18),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E18+F18+G18+H18),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E18+F18+G18+H18+I18))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E19,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E19+F19),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E19+F19+G19),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E19+F19+G19+H19),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E19+F19+G19+H19+I19))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E20,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E20+F20),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E20+F20+G20),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E20+F20+G20+H20),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E20+F20+G20+H20+I20))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E21,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E21+F21),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E21+F21+G21),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E21+F21+G21+H21),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E21+F21+G21+H21+I21))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E22,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E22+F22),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E22+F22+G22),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E22+F22+G22+H22),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E22+F22+G22+H22+I22))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E23,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E23+F23),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E23+F23+G23),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E23+F23+G23+H23),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E23+F23+G23+H23+I23))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E24,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E24+F24),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E24+F24+G24),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E24+F24+G24+H24),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E24+F24+G24+H24+I24))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E25,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E25+F25),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E25+F25+G25),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E25+F25+G25+H25),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E25+F25+G25+H25+I25))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E26,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E26+F26),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E26+F26+G26),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E26+F26+G26+H26),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E26+F26+G26+H26+I26))","v":0}]
[{"$nulls":9},{"$f":"_xlfn.IFS(\nInstructions!$F$11=\"Make Selection\",0,\nInstructions!$F$11=\"1 Budget Period\",E27,\nInstructions!$F$11=\"2 Budget Periods\",SUM(E27+F27),\nInstructions!$F$11=\"3 Budget Periods\",SUM(E27+F27+G27),\nInstructions!$F$11=\"4 Budget Periods\",SUM(E27+F27+G27+H27),\nInstructions!$F$11=\"5 Budget Periods\",SUM(E27+F27+G27+H27+I27))","v":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}]
[{"$nulls":6},"(Must equal or exceed the required Cost Share for the project.)"]
[null,"Additional Explanation (as needed):"]

{"sheet":"SF-424A Cost Categories","index":12,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,1,35,2],[35,3,35,6],[35,8,35,9],[36,1,36,9],[18,4,18,7],[18,9,19,9],[28,2,28,3],[30,2,30,3],[31,1,31,9],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[32,2,32,3],[8,2,9,2],[8,3,9,3],[8,4,8,5],[8,6,8,9],[4,1,4,2],[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]]}
[]
[null,"Budget Information",{"$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: 06/30/2028"]
[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)","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)","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)","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)","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)","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(Summary!F18,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:I33),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":13,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[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],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[32,2,32,3],[35,8,35,9],[36,1,36,9],[35,1,35,2],[35,3,35,6],[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]]}
[]
[null,"Budget Information",{"$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: 06/30/2028"]
[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)","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)","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)","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)","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)","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(Summary!F18,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-Summary!C29,0)","v":0},{"$f":"ROUND(Summary!D30-Summary!D29,0)","v":0},{"$f":"ROUND(Summary!E30-Summary!E29,0)","v":0},{"$f":"ROUND(Summary!F30-Summary!F29,0)","v":0},{"$f":"ROUND(Summary!G30-Summary!G29,0)","v":0},{"$f":"ROUND(Summary!H30-Summary!H29,0)","v":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)-ROUND(Summary!C29,0)","v":0},{"$f":"ROUND(Summary!D33,0)-ROUND(Summary!D29,0)","v":0},{"$f":"ROUND(Summary!E33,0)-ROUND(Summary!E29,0)","v":0},{"$f":"ROUND(Summary!F33,0)-ROUND(Summary!F29,0)","v":0},{"$f":"ROUND(Summary!G33,0)-ROUND(Summary!G29,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:I33),0)","v":0}]
[]
[{"$nulls":9},"Standard Form 424A (Rev. 7- 97)"]
[{"$nulls":8},"Prescribed by OMB (Circular A-102)"]
[null,"Authorized for Local Reproduction"]