{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Budget Levels and Scope Impact","Prime Lab Budget Summary","Partner Lab 1 Budget Summary","Partner Lab 2 Budget Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"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":"Budget Levels and Scope Impact","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[5,0,5,3],[4,0,4,4]]}
["Prime Lab:"]
["Exchange ID #:"]
["Project Spend Summary (for entire Period of Performance)"]
["Instructions: To the best of your knowledge, please fill out this sheet."]
["Enter the planned project spend summary for each category in column A, capturing the prime Lab + any partner Lab(s) for the entire period of performance. The gray cells either can be left blank or will automatically calculate. \nColumn C represents the optimal project budget, whereas column B is a low budget scenario and column D is a high budget scenario. \nColumn E should briefly describe the scope impacts when comparing the optimal budget scenario to the low and high scenarios. \nRow 23 should be populated with cost-share in each of the budget scenarios. "]
["Spending Summary"]
["Categories","Low Budget","Optimal Budget","High Budget","Scope Impact"]
["a.  Federal Share: Personnel"]
["b.  Federal Share: Fringe Benefits"]
["c.  Federal Share: Travel"]
["d.  Federal Share: Equipment"]
["e.  Federal Share: Supplies"]
["f.  Federal Share: Contractual","Leave this cell blank","Leave this cell blank","Leave this cell blank","Leave this cell blank"]
["f.1:  Federal Share: Sub-recipient",null,null,null,"Add line if there are multiple subcontractors, one line per subcontractor."]
["f.2  Federal Share: Contractor"]
["f.3  Federal Share: FFRDC"]
["Total Federal Share for Contractual ",{"$f":"SUM(B14:B16)","v":0},{"$f":"SUM(C14:C16)","v":0},0,"Leave this cell blank"]
["g.  Federal Share: Construction"]
["h.  Federal Share: Other Direct Costs"]
["Federal Share: Total Direct Charges (sum of a to h)",{"$f":"SUM(B8:B12)+B17+B18+B19","v":0},{"$f":"SUM(C8:C12)+C17+C18+C19","v":0},0,"Leave this cell blank"]
["i.  Federal Share: Indirect Charges"]
["Total Federal Share",{"$f":"B20+B21","v":0},{"$f":"C20+C21","v":0},0,"Leave this cell blank"]
["Total Cost Share"]
["Calculated Cost Share Percentage",{"$f":"(B23/(B23+B22))","v":{"$error":"#DIV/0!"}},{"$f":"(C23/(C23+C22))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"Leave this cell blank"]

{"sheet":"Prime Lab Budget Summary","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,0,6,8],[8,0,8,8],[10,0,14,0],[33,0,34,8],[0,2,1,7],[2,1,2,2],[3,1,3,2],[5,0,5,8],[15,1,15,8],[22,1,22,8],[9,1,9,8]]}
[null,null,"Budget Spend Plan Reporting"]
[]
["Prime Lab:",{"$f":"'Budget Levels and Scope Impact'!B1","v":0}]
["Exchange ID #:",{"$f":"'Budget Levels and Scope Impact'!B2","v":0}]
[]
["Please read the instructions on each worksheet tab before starting. Do not modify this template or any cells or formulas unless directed to do so in the Instructions section.\nIf you have any questions, please email them to TCF@hq.doe.gov"]
["INSTRUCTIONS: To the best of your knowledge, please fill out this budget summary sheet for the prime/ lead lab.\nBudget period 1 is defined as the time from the start of the project until the first Go/No-Go decision point (when applicable). Budget period 2 is defined as the time between the first Go/No-Go decision point and the second Go/No-Go decision point, when applicable, and so on.\n1. Fill out the blank white cells with projected project costs for the optimal budget and scope scenario.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.\n3. The total budget presented in Section A must include both Federal (DOE) and Non-Federal (cost share) portions.\n4. Budget cost categories are provided as examples. Please bucket costs into their most appropriate category and/or revise categories as appropriate.\n5. 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.\n6. Add rows as needed. If rows are added, formulas/calculations may need to be adjusted by the preparer. Populate and add or remove partner Lab tabs as needed.\n7. All budget period cost categories are rounded to the nearest dollar."]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED"]
["Section A - Budget Summary, Federal Share + Cost-Share"]
[null,null,"Federal","Cost-Share (Cash)","Cost-Share (In Kind)","Cost-Share Total","Total Costs","Cost-Share %","Proposed Budget Period Dates"]
[null,"Budget Period 1",null,null,null,{"$f":"D12+E12","v":0},{"$f":"B32+F12","v":0},{"$f":"IF(G12>0,F12/G12,0)","v":0},"Example: 10/01/2024 - 09/30/2025"]
[null,"Budget Period 2",null,null,null,{"$f":"D13+E13","v":0},{"$f":"C32+F13","v":0},{"$f":"IF(G13>0,F13/G13,0)","v":0}]
[null,"Budget Period 3",null,null,null,0,{"$f":"D32+F14","v":0},0]
[null,"Total",{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0},0,{"$f":"SUM(G12:G14)","v":0},0]
["Section B - Budget Categories, Federal Share only"]
["CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3",null,null," Total Costs","% of Project","Comments (as needed)"]
["a. Personnel",{"$nulls":5},{"$f":"SUM(B18:D18)","v":0},{"$f":"IF(G18>0,G18/G15,0)","v":0}]
["b. Fringe Benefits",{"$nulls":5},{"$f":"SUM(B19:D19)","v":0},{"$f":"IF(G19>0,G19/G15,0)","v":0}]
["c. Travel",{"$nulls":5},0,{"$f":"IF(G20>0,G20/G15,0)","v":0}]
["d. Equipment",{"$nulls":5},0,{"$f":"IF(G21>0,G21/G15,0)","v":0}]
["e. Supplies",{"$nulls":5},0,{"$f":"IF(G22>0,G22/G15,0)","v":0}]
["f. Contractual"]
["Sub-recipient",{"$nulls":5},{"$f":"SUM(B24:D24)","v":0},{"$f":"IF(G24>0,G24/G15,0)","v":0},"When applicable, please indicate subcontractor entitity name. Add line if there are multiple subcontractors, one line per subcontractor."]
["Contractor",{"$nulls":5},{"$f":"SUM(B25:D25)","v":0},{"$f":"IF(G25>0,G25/G15,0)","v":0}]
["FFRDC",{"$nulls":5},{"$f":"SUM(B26:D26)","v":0},{"$f":"IF(G26>0,G26/G15,0)","v":0}]
["Total Contractual ",{"$f":"SUM(B24:B26)","v":0},{"$f":"SUM(C24:C26)","v":0},0,null,null,{"$f":"SUM(B27:D27)","v":0},{"$f":"IF(G27>0,G27/G15,0)","v":0}]
["g. Construction",{"$nulls":5},0,{"$f":"IF(G28>0,G28/G15,0)","v":0}]
["h. Other Direct Costs",{"$nulls":5},{"$f":"SUM(B29:D29)","v":0},{"$f":"IF(G29>0,G29/G15,0)","v":0}]
["Total Direct Costs",{"$f":"SUM(B18:B22)+SUM(B24:B26)+B28+B29","v":0},{"$f":"SUM(C18:C22)+SUM(C24:C26)+C28+C29","v":0},0,null,null,{"$f":"SUM(B30:D30)","v":0},{"$f":"IF(G30>0,G30/G15,0)","v":0}]
["i. Indirect Charges",{"$nulls":5},{"$f":"SUM(B31:D31)","v":0},{"$f":"IF(G31>0,G31/G15,0)","v":0}]
["Total Costs",{"$f":"B30+B31","v":0},{"$f":"C30+C31","v":0},{"$f":"D30+D31","v":0},null,null,{"$f":"G30+G31","v":0},{"$f":"H30+H31","v":0}]
[]
["Additional Explanation (at a minimum, write the names of the cost-share partner(s) and if there is cost-share with multiple partners, indicate per budget period how much cash or in-kind cost-share is attritibuted to each partner):"]

{"sheet":"Partner Lab 1 Budget Summary","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[10,0,14,0],[15,1,15,6],[22,1,22,6],[9,1,9,6],[33,0,34,8],[6,0,6,6],[8,0,8,6],[2,5,2,6],[0,2,1,5],[2,1,2,2],[3,1,3,2],[5,0,5,6]]}
[null,null,"Budget Spend Plan Reporting"]
[]
["Prime Lab:",{"$f":"'Budget Levels and Scope Impact'!B1","v":0},null,null,"Partner Lab #1:"]
["Exchange ID #:",{"$f":"'Budget Levels and Scope Impact'!B2","v":0}]
[]
["Please read the instructions on each worksheet tab before starting. Do not modify this template or any cells or formulas unless directed to do so in the Instructions section.\nIf you have any questions, please email them to TCF@hq.doe.gov"]
["INSTRUCTIONS: To the best of your knowledge, please fill out this budget summary sheet for the first partner lab.\nBudget period 1 is defined as the time from the start of the project until the first Go/No-Go decision point (when applicable). Budget period 2 is defined as the time between the first Go/No-Go decision point and the second Go/No-Go decision point, when applicable, and so on.\n1. Fill out the blank white cells with projected project costs for the optimal budget and scope scenario.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.\n3. The total budget presented in Section A must include both Federal (DOE) and Non-Federal (cost share) portions.\n4. Budget cost categories are provided as examples. Please bucket costs into their most appropriate category and/or revise categories as appropriate.\n5. 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.\n6. Add rows as needed. If rows are added, formulas/calculations may need to be adjusted by the preparer. Populate and add or remove partner Lab tabs as needed.\n7. All budget period cost categories are rounded to the nearest dollar."]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent tabs, only blank white cells require data entry"]
["Section A - Budget Summary, Federal Share + Cost Share"]
[null,null,"Federal","Cost Share","Total Costs","Cost Share %","Proposed Budget Period Dates"]
[null,"Budget Period 1",null,null,{"$f":"B32+D12","v":0},{"$f":"IF(E12>0,D12/E12,0)","v":0},"Example: 10/01/2024 - 09/30/2025"]
[null,"Budget Period 2",null,null,{"$f":"C32+D13","v":0},{"$f":"IF(E13>0,D13/E13,0)","v":0}]
[null,"Budget Period 3",null,null,{"$f":"D32+D14","v":0},0]
[null,"Total",{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0},0]
["Section B - Budget Categories, Federal Share only"]
["CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3"," Total Costs","% of Project","Comments (as needed)",{"$nulls":6},"c"]
["a. Personnel",null,null,null,{"$f":"SUM(B18:D18)","v":0},{"$f":"IF(E18>0,E18/E15,0)","v":0}]
["b. Fringe Benefits",null,null,null,0,{"$f":"IF(E19>0,E19/E15,0)","v":0}]
["c. Travel",null,null,null,0,{"$f":"IF(E20>0,E20/E15,0)","v":0}]
["d. Equipment",null,null,null,0,{"$f":"IF(E21>0,E21/E15,0)","v":0}]
["e. Supplies",null,null,null,0,{"$f":"IF(E22>0,E22/E15,0)","v":0}]
["f. Contractual"]
["Sub-recipient",null,null,null,{"$f":"SUM(B24:D24)","v":0},{"$f":"IF(E24>0,E24/E15,0)","v":0},"When applicable, please indicate subcontractor entitity name. Add line if there are multiple subcontractors, one line per subcontractor."]
["Contractor",null,null,null,{"$f":"SUM(B25:D25)","v":0},{"$f":"IF(E25>0,E25/E15,0)","v":0}]
["FFRDC",null,null,null,{"$f":"SUM(B26:D26)","v":0},{"$f":"IF(E26>0,E26/E15,0)","v":0}]
["Total Contractual ",{"$f":"SUM(B24:B26)","v":0},{"$f":"SUM(C24:C26)","v":0},0,{"$f":"SUM(B27:D27)","v":0},{"$f":"IF(E27>0,E27/E15,0)","v":0}]
["g. Construction",null,null,null,0,{"$f":"IF(E28>0,E28/E15,0)","v":0}]
["h. Other Direct Costs",null,null,null,{"$f":"SUM(B29:D29)","v":0},{"$f":"IF(E29>0,E29/E15,0)","v":0}]
["Total Direct Costs",{"$f":"SUM(B18:B22)+SUM(B24:B26)+B28+B29","v":0},{"$f":"SUM(C18:C22)+SUM(C24:C26)+C28+C29","v":0},0,{"$f":"SUM(B30:D30)","v":0},{"$f":"IF(E30>0,E30/E15,0)","v":0}]
["i. Indirect Charges",null,null,null,{"$f":"SUM(B31:D31)","v":0},{"$f":"IF(E31>0,E31/E15,0)","v":0}]
["Total Costs",{"$f":"B30+B31","v":0},{"$f":"C30+C31","v":0},{"$f":"D30+D31","v":0},{"$f":"E30+E31","v":0},{"$f":"F30+F31","v":0}]
[]
["Additional Explanation (at a minimum, write the names of the cost-share partner(s) and if there is cost-share with multiple partners, indicate per budget period how much cash or in-kind cost-share is attritibuted to each partner):"]

{"sheet":"Partner Lab 2 Budget Summary","index":3,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,1,5],[2,1,2,2],[2,5,2,6],[3,1,3,2],[5,0,5,6],[22,1,22,6],[33,0,34,8],[6,0,6,6],[8,0,8,6],[9,1,9,6],[10,0,14,0],[15,1,15,6]]}
[null,null,"Budget Spend Plan Reporting"]
[]
["Prime Lab:",{"$f":"'Budget Levels and Scope Impact'!B1","v":0},null,null,"Partner Lab #2:"]
["Exchange ID #:",{"$f":"'Budget Levels and Scope Impact'!B2","v":0}]
[]
["Please read the instructions on each worksheet tab before starting. Do not modify this template or any cells or formulas unless directed to do so in the Instructions section.\nIf you have any questions, please email them to TCF@hq.doe.gov"]
["INSTRUCTIONS: To the best of your knowledge, please fill out this budget summary sheet for the second partner lab.\nBudget period 1 is defined as the time from the start of the project until the first Go/No-Go decision point (when applicable). Budget period 2 is defined as the time between the first Go/No-Go decision point and the second Go/No-Go decision point, when applicable, and so on.\n1. Fill out the blank white cells with projected project costs for the optimal budget and scope scenario.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.\n3. The total budget presented in Section A must include both Federal (DOE) and Non-Federal (cost share) portions.\n4. Budget cost categories are provided as examples. Please bucket costs into their most appropriate category and/or revise categories as appropriate.\n5. 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.\n6. Add rows as needed. If rows are added, formulas/calculations may need to be adjusted by the preparer. Populate and add or remove partner Lab tabs as needed.\n7. All budget period cost categories are rounded to the nearest dollar."]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent tabs, only blank white cells require data entry"]
["Section A - Budget Summary, Federal Share + Cost Share"]
[null,null,"Federal","Cost Share","Total Costs","Cost Share %","Proposed Budget Period Dates"]
[null,"Budget Period 1",null,null,{"$f":"B32+D12","v":0},{"$f":"IF(E12>0,D12/E12,0)","v":0},"Example: 10/01/2024 - 09/30/2025"]
[null,"Budget Period 2",null,null,{"$f":"C32+D13","v":0},{"$f":"IF(E13>0,D13/E13,0)","v":0}]
[null,"Budget Period 3",null,null,{"$f":"D32+D14","v":0},0]
[null,"Total",{"$f":"SUM(C12:C14)","v":0},{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0},0]
["Section B - Budget Categories, Federal Share only"]
["CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3"," Total Costs","% of Project","Comments (as needed)"]
["a. Personnel",null,null,null,{"$f":"SUM(B18:D18)","v":0},{"$f":"IF(E18>0,E18/E15,0)","v":0}]
["b. Fringe Benefits",null,null,null,0,{"$f":"IF(E19>0,E19/E15,0)","v":0}]
["c. Travel",null,null,null,0,{"$f":"IF(E20>0,E20/E15,0)","v":0}]
["d. Equipment",null,null,null,0,{"$f":"IF(E21>0,E21/E15,0)","v":0}]
["e. Supplies",null,null,null,0,{"$f":"IF(E22>0,E22/E15,0)","v":0}]
["f. Contractual"]
["Sub-recipient",null,null,null,{"$f":"SUM(B24:D24)","v":0},{"$f":"IF(E24>0,E24/E15,0)","v":0},"When applicable, please indicate subcontractor entitity name. Add line if there are multiple subcontractors, one line per subcontractor."]
["Contractor",null,null,null,{"$f":"SUM(B25:D25)","v":0},{"$f":"IF(E25>0,E25/E15,0)","v":0}]
["FFRDC",null,null,null,{"$f":"SUM(B26:D26)","v":0},{"$f":"IF(E26>0,E26/E15,0)","v":0}]
["Total Contractual ",{"$f":"SUM(B24:B26)","v":0},{"$f":"SUM(C24:C26)","v":0},0,{"$f":"SUM(B27:D27)","v":0},{"$f":"IF(E27>0,E27/E15,0)","v":0}]
["g. Construction",null,null,null,0,{"$f":"IF(E28>0,E28/E15,0)","v":0}]
["h. Other Direct Costs",null,null,null,{"$f":"SUM(B29:D29)","v":0},{"$f":"IF(E29>0,E29/E15,0)","v":0}]
["Total Direct Costs",{"$f":"SUM(B18:B22)+SUM(B24:B26)+B28+B29","v":0},{"$f":"SUM(C18:C22)+SUM(C24:C26)+C28+C29","v":0},0,{"$f":"SUM(B30:D30)","v":0},{"$f":"IF(E30>0,E30/E15,0)","v":0}]
["i. Indirect Charges",null,null,null,{"$f":"SUM(B31:D31)","v":0},{"$f":"IF(E31>0,E31/E15,0)","v":0}]
["Total Costs",{"$f":"B30+B31","v":0},{"$f":"C30+C31","v":0},{"$f":"D30+D31","v":0},{"$f":"E30+E31","v":0},{"$f":"F30+F31","v":0}]
[]
["Additional Explanation (at a minimum, write the names of the cost-share partner(s) and if there is cost-share with multiple partners, indicate per budget period how much cash or in-kind cost-share is attritibuted to each partner):"]