{"text_format":"2","workbook":"xlsx","n_sheets":13,"sheets":["Instructions and Summary","SF-424A (Rev. 4-92) ","SF-424A","a. Personnel","b. Fringe Benefits","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect Costs","Cost Share"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":48,"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 and Summary","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,1,2,2],[2,3,2,7],[25,0,25,2],[0,6,0,7],[0,0,0,2],[26,0,26,8],[3,1,3,2],[3,3,3,7],[5,0,5,8],[6,0,6,8],[8,0,8,8]]}
["Budget Justification for SF 424A Budget",{"$nulls":5},"Last Updated / Version # :",null,"8/24/2021  V 6.20"]
["Instructions and Summary"]
["Control Number:",null,null,"Original Date of Submission:"]
["Award Recipient:",null,null,"Submitted by: "]
[]
["Please read the instructions on each tab before starting.  \nIf you have any questions, please submit to ARPA-E-CO@hq.doe.gov.  It will save you time!  Double check all fields highlighted in yellow!"]
["• This worksheet auto populates when data is entered on subsequent tabs (a. Personnel, b. Fringe Benefits, c. Travel, d. Equipment, e. Supplies, f. Contractual, g. Other, h. Indirect Costs, Cost Share). The term “tab” refers to a worksheet within the Budget Justification Workbook.  Each tab may be found and accessed at the bottom of this Workbook. On this Instructions and Summary tab the award recipient should update Control Number, Award Recipient, Original Date of Submission, Submitted By and the Comments section as needed. If this is a new version please ensure to update the Last Updated / Version # in the top right of this sheet. X\n\n• The Prime Recipient must complete this Budget Justification Workbook.  In addition, each Subrecipient incurring greater than or equal to 10% of the Total Project Cost must complete an additional Budget Justification Workbook to justify its proposed budget.  The Subrecipient's Budget Justification Workbook total project costs must match the amount on tab f. Contractual in the Prime Recipient’s Budget Justification Workbook. All documents should be submitted as one package to ARPA-E, however, subrecipients can provide budget documents directly to ARPA-E if necessary. The Prime Recipient’s Budget Justification Workbook will not be reviewed until all supporting documentation is submitted.\n\n• The total budget presented in the Budget Justification Workbook and the SF-424A must include both Federal (ARPA-E) and Non-Federal (cost share) expenditures, the sum of which equals the Total Project Cost proposed by the Applicant.  All costs, whether paid with Federal funding or by the Project Team, must be justified.  \n\n• Each budget category will automatically populate in the second tab in this Budget Justification Workbook (SF-424A).  The totals in each budget category and the Total Project Cost must be the same in the SF-424A and the Budget Justification Workbook.  The award recipient must review the SF-424A, fill in the award number and fill in Section D (Projected Cash Flows) in the SF-424A tab.\n\n• All costs incurred by the Prime Recipient’s Subrecipients, vendors, contractors, consultants and Federally Funded Research and Development Centers (FFRDCs), must be entered in tab f. Contractual.  All other sections are for the costs of the Prime Recipient only.\n\n• No individual may be paid more than $200,000 per year under an ARPA-E funding agreement. \n\n• All expenditures must be allowable, allocable, and reasonable in accordance with the applicable Federal cost principles.  \n"]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\n(Note: The values in this summary table are from entries made in each budget category tab.)"]
["CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"," Total Costs","Project Costs %","Comments\n(Add comments as needed)"]
["a. Personnel",{"$f":"ROUND('a. Personnel'!E182,0)","v":0},{"$f":"ROUND('a. Personnel'!H182,0)","v":0},{"$f":"ROUND('a. Personnel'!K182,0)","v":0},{"$f":"ROUND('a. Personnel'!N182,0)","v":0},{"$f":"ROUND('a. Personnel'!Q182,0)","v":0},{"$f":"SUM(B11:F11)","v":0},{"$f":"IFERROR(G11/$G$24,\"\")","v":""}]
["b. Fringe Benefits",{"$f":"ROUND('b. Fringe Benefits'!D10,0)","v":0},{"$f":"ROUND('b. Fringe Benefits'!E10,0)","v":0},{"$f":"ROUND('b. Fringe Benefits'!F10,0)","v":0},{"$f":"ROUND('b. Fringe Benefits'!G10,0)","v":0},{"$f":"ROUND('b. Fringe Benefits'!H10,0)","v":0},{"$f":"SUM(B12:F12)","v":0},{"$f":"IFERROR(G12/$G$24,\"\")","v":""}]
["c. Travel",{"$f":"ROUND('c. Travel'!G49,0)","v":0},{"$f":"ROUND('c. Travel'!G96,0)","v":0},{"$f":"ROUND('c. Travel'!G146,0)","v":0},{"$f":"ROUND('c. Travel'!G196,0)","v":0},{"$f":"ROUND('c. Travel'!G246,0)","v":0},0,{"$f":"IFERROR(G13/$G$24,\"\")","v":""}]
["d. Equipment",{"$f":"ROUND('d. Equipment'!D44,0)","v":0},{"$f":"ROUND('d. Equipment'!D95,0)","v":0},{"$f":"ROUND('d. Equipment'!D151,0)","v":0},{"$f":"ROUND('d. Equipment'!D207,0)","v":0},{"$f":"ROUND('d. Equipment'!D263,0)","v":0},0,{"$f":"IFERROR(G14/$G$24,\"\")","v":""}]
["e. Supplies",{"$f":"ROUND('e. Supplies'!D80,0)","v":0},{"$f":"ROUND('e. Supplies'!D152,0)","v":0},{"$f":"ROUND('e. Supplies'!D222,0)","v":0},{"$f":"ROUND('e. Supplies'!D292,0)","v":0},{"$f":"ROUND('e. Supplies'!D362,0)","v":0},0,{"$f":"IFERROR(G15/$G$24,\"\")","v":""}]
["f. Contractual"]
["Sub-recipient",{"$f":"ROUND('f. Contractual'!C21,0)","v":0},{"$f":"ROUND('f. Contractual'!D21,0)","v":0},{"$f":"ROUND('f. Contractual'!E21,0)","v":0},{"$f":"ROUND('f. Contractual'!F21,0)","v":0},{"$f":"ROUND('f. Contractual'!G21,0)","v":0},{"$f":"SUM(B17:F17)","v":0},{"$f":"IFERROR(G17/$G$24,\"\")","v":""}]
["FFRDC (Separate Work Authorization or other Sub-Award)",{"$f":"ROUND('f. Contractual'!C52,0)","v":0},{"$f":"ROUND('f. Contractual'!D52,0)","v":0},{"$f":"ROUND('f. Contractual'!E52,0)","v":0},{"$f":"ROUND('f. Contractual'!F52,0)","v":0},{"$f":"ROUND('f. Contractual'!G52,0)","v":0},0,""]
["Vendor",{"$f":"ROUND('f. Contractual'!C40,0)","v":0},{"$f":"ROUND('f. Contractual'!D40,0)","v":0},{"$f":"ROUND('f. Contractual'!E40,0)","v":0},{"$f":"ROUND('f. Contractual'!F40,0)","v":0},{"$f":"ROUND('f. Contractual'!G40,0)","v":0},0,""]
["Total Contractual ",{"$f":"SUM(B17:B19)","v":0},{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},{"$f":"SUM(E17:E19)","v":0},{"$f":"SUM(F17:F19)","v":0},0,""]
["g. Construction",{"$f":"ROUND('g. Construction'!B16,0)","v":0},{"$f":"ROUND('g. Construction'!B24,0)","v":0},{"$f":"ROUND('g. Construction'!B32,0)","v":0},{"$f":"ROUND('g. Construction'!B40,0)","v":0},{"$f":"ROUND('g. Construction'!B49,0)","v":0},0,""]
["h. Other Direct Costs",{"$f":"ROUND('h. Other'!B44,0)","v":0},{"$f":"ROUND('h. Other'!B65,0)","v":0},{"$f":"ROUND('h. Other'!B86,0)","v":0},{"$f":"ROUND('h. Other'!B107,0)","v":0},{"$f":"ROUND('h. Other'!B128,0)","v":0},0,""]
["i. Indirect Charges",{"$f":"ROUND('i. Indirect Costs'!D9,0)","v":0},{"$f":"ROUND('i. Indirect Costs'!E9,0)","v":0},{"$f":"ROUND('i. Indirect Costs'!F9,0)","v":0},{"$f":"ROUND('i. Indirect Costs'!G9,0)","v":0},{"$f":"ROUND('i. Indirect Costs'!H9,0)","v":0},0,""]
["Total Project Costs",{"$f":"SUM(B11:B15,B20:B23)","v":0},{"$f":"SUM(C11:C15,C20:C23)","v":0},0,0,0,{"$f":"SUM(G11:G15,G20:G23)","v":0},{"$f":"IFERROR(SUM(H11:H23)-H20,\"\")","v":""}]
[]
["Additional Explanations/Comments (as necessary):"]

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

{"sheet":"SF-424A","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,6,4,8],[4,4,4,5],[4,2,5,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[46,10,47,12],[48,10,48,12],[15,8,16,8],[44,4,44,8],[20,1,20,2],[21,1,21,2],[22,1,22,2],[39,1,39,3],[42,1,42,3],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,0,28,8],[4,0,5,0],[4,1,5,1],[38,1,38,3],[23,1,23,2],[24,1,24,2],[15,0,16,0],[15,1,16,2],[15,3,15,6],[35,0,35,2],[35,3,35,8],[36,1,36,3],[17,1,17,2],[13,1,13,3],[37,1,37,3],[18,1,18,2],[19,1,19,2],[50,4,50,8],[40,1,40,3],[41,1,41,3],[0,0,0,1],[1,0,1,8],[2,0,2,8],[0,2,0,3],[0,5,0,6],[6,2,6,3],[49,0,49,4],[49,5,49,8],[12,2,12,3],[3,0,3,2],[14,0,14,2],[14,3,14,8],[3,3,3,8],[29,1,29,2],[32,0,32,1],[32,2,32,5],[32,6,32,8],[33,0,33,8],[43,1,43,3],[58,2,58,3],[53,1,53,3],[48,1,48,2],[45,0,45,3],[46,1,46,3],[47,1,47,3],[50,0,51,3],[52,1,52,3],[44,0,44,3],[64,2,64,6],[66,0,103,8],[105,0,146,8],[63,0,63,1],[54,1,54,3],[57,0,57,2],[57,3,57,8],[62,2,62,6],[59,0,59,3],[59,4,59,8],[60,2,60,8],[61,0,61,8],[58,5,58,8],[55,1,55,3],[56,1,56,3]]}
["Applicant Name:",null,{"$f":"'Instructions and Summary'!B4","v":0},null,"Award Number:"]
["Budget Information - Non Construction Programs"]
["OMB Approval No. 0348-0044"]
["Section A - Budget Summary"]
[null,"Grant Program Function or Activity","Catalog of Federal Domestic Assistance Number",null,"Estimated Unobligated Funds",null,"New or Revised Budget"]
[{"$nulls":4},"Federal ","Non-Federal ","Federal","Non-Federal","Total"]
[null,"(a)","(b)",null,"(c )","(d)","(e)","(f)","(g)"]
["1.","Budget period 1",81.135000000000005,null,null,null,{"$f":"ROUND($D$28-H8,0)","v":0},{"$f":"ROUND('Cost Share'!E25,0)","v":0},{"$f":"SUM(D8:H8)","v":0}]
["2.","Budget period 2",81.135000000000005,null,null,null,{"$f":"ROUND($E$28-H9,0)","v":0},{"$f":"ROUND('Cost Share'!F25,0)","v":0},{"$f":"SUM(D9:H9)","v":0}]
["3.","Budget period 3",81.135000000000005,null,null,null,{"$f":"ROUND($F$28-H10,0)","v":0},{"$f":"ROUND('Cost Share'!G25,0)","v":0},{"$f":"SUM(D10:H10)","v":0}]
["4.","Budget period 4",81.135000000000005,null,null,null,{"$f":"ROUND($G$28-H11,0)","v":0},{"$f":"ROUND('Cost Share'!H25,0)","v":0},{"$f":"SUM(D11:H11)","v":0}]
["5.","Budget period 5",81.135000000000005,null,null,null,{"$f":"ROUND($H$28-H12,0)","v":0},{"$f":"ROUND('Cost Share'!I25,0)","v":0},{"$f":"SUM(D12:H12)","v":0}]
[]
["6.","Totals",null,null,{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0},{"$f":"SUM(G8:G12)","v":0},{"$f":"SUM(H8:H12)","v":0},{"$f":"SUM(I8:I12)","v":0}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",{"$nulls":4},"Total (5)"]
[null,null,null,"Budget period 1","Budget period 2","Budget period 3","Budget period 4","Budget period 5"]
[null,"a.  Personnel",null,{"$f":"'Instructions and Summary'!B11","v":0},{"$f":"'Instructions and Summary'!C11","v":0},{"$f":"'Instructions and Summary'!D11","v":0},{"$f":"'Instructions and Summary'!E11","v":0},{"$f":"'Instructions and Summary'!F11","v":0},{"$f":"SUM(D18:H18)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"'Instructions and Summary'!B12","v":0},{"$f":"'Instructions and Summary'!C12","v":0},{"$f":"'Instructions and Summary'!D12","v":0},{"$f":"'Instructions and Summary'!E12","v":0},{"$f":"'Instructions and Summary'!F12","v":0},{"$f":"SUM(D19:H19)","v":0}]
[null,"c.  Travel",null,{"$f":"'Instructions and Summary'!B13","v":0},{"$f":"'Instructions and Summary'!C13","v":0},{"$f":"'Instructions and Summary'!D13","v":0},{"$f":"'Instructions and Summary'!E13","v":0},{"$f":"'Instructions and Summary'!F13","v":0},0]
[null,"d.  Equipment",null,{"$f":"'Instructions and Summary'!B14","v":0},{"$f":"'Instructions and Summary'!C14","v":0},{"$f":"'Instructions and Summary'!D14","v":0},{"$f":"'Instructions and Summary'!E14","v":0},{"$f":"'Instructions and Summary'!F14","v":0},0]
[null,"e.  Supplies",null,{"$f":"'Instructions and Summary'!B15","v":0},{"$f":"'Instructions and Summary'!C15","v":0},{"$f":"'Instructions and Summary'!D15","v":0},{"$f":"'Instructions and Summary'!E15","v":0},{"$f":"'Instructions and Summary'!F15","v":0},0]
[null,"f.  Contractual",null,{"$f":"'Instructions and Summary'!B20","v":0},{"$f":"'Instructions and Summary'!C20","v":0},{"$f":"'Instructions and Summary'!D20","v":0},{"$f":"'Instructions and Summary'!E20","v":0},{"$f":"'Instructions and Summary'!F20","v":0},0]
[null,"g.  Construction",null,{"$f":"'Instructions and Summary'!B21","v":0},{"$f":"'Instructions and Summary'!C21","v":0},{"$f":"'Instructions and Summary'!D21","v":0},{"$f":"'Instructions and Summary'!E21","v":0},{"$f":"'Instructions and Summary'!F21","v":0},0]
[null,"h.  Other",null,{"$f":"'Instructions and Summary'!B22","v":0},{"$f":"'Instructions and Summary'!C22","v":0},{"$f":"'Instructions and Summary'!D22","v":0},{"$f":"'Instructions and Summary'!E22","v":0},{"$f":"'Instructions and Summary'!F22","v":0},0]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D18:D25)","v":0},{"$f":"SUM(E18:E25)","v":0},{"$f":"SUM(F18:F25)","v":0},{"$f":"SUM(G18:G25)","v":0},0,{"$f":"SUM(D26:H26)","v":0}]
[null,"j.  Indirect Charges",null,{"$f":"'Instructions and Summary'!B23","v":0},{"$f":"'Instructions and Summary'!C23","v":0},{"$f":"'Instructions and Summary'!D23","v":0},{"$f":"'Instructions and Summary'!E23","v":0},{"$f":"'Instructions and Summary'!F23","v":0},{"$f":"SUM(D27:H27)","v":0}]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"SUM(D26:D27)","v":0},{"$f":"SUM(E26:E27)","v":0},{"$f":"SUM(F26:F27)","v":0},{"$f":"SUM(G26:G27)","v":0},0,{"$f":"SUM(I26:I27)","v":0}]
[]
["7.","Program Income",{"$nulls":6},{"$f":"SUM(D30:G30)","v":0}]
[]
[{"$nulls":8},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",{"$nulls":5},"Prescribed by OMB Circular A-102"]
["Authorized for Local Reproduction"]
[]
["Section C - Non-Federal Resources"]
[null,"(a) Grant Program",null,null,"(b) Applicant","(c ) State","(d) Other Sources",null,"(e) Totals"]
["8.","Budget period 1",null,null,{"$f":"ROUND('Cost Share'!M13,0)","v":0},{"$f":"ROUND('Cost Share'!M14,0)","v":0},{"$f":"ROUND('Cost Share'!M15,0)","v":0},null,{"$f":"SUM(E38:G38)","v":0}]
["9.","Budget period 2",null,null,{"$f":"ROUND('Cost Share'!N13,0)","v":0},{"$f":"ROUND('Cost Share'!N14,0)","v":0},{"$f":"ROUND('Cost Share'!N15,0)","v":0},null,0]
["10.","Budget period 3",null,null,{"$f":"ROUND('Cost Share'!O13,0)","v":0},{"$f":"ROUND('Cost Share'!O14,0)","v":0},{"$f":"ROUND('Cost Share'!O15,0)","v":0},null,0]
["11.","Budget period 2",null,null,{"$f":"ROUND('Cost Share'!P13,0)","v":0},{"$f":"ROUND('Cost Share'!P14,0)","v":0},{"$f":"ROUND('Cost Share'!P15,0)","v":0},null,0]
["12.","Budget period 3",null,null,{"$f":"ROUND('Cost Share'!Q13,0)","v":0},{"$f":"ROUND('Cost Share'!Q14,0)","v":0},{"$f":"ROUND('Cost Share'!Q15,0)","v":0},null,0]
["13.",{"$nulls":7},0]
["14.","Total (sum of lines 8 - 13)",null,null,{"$f":"SUM(E38:E43)","v":0},{"$f":"SUM(F38:F43)","v":0},{"$f":"SUM(G38:G43)","v":0},null,{"$f":"SUM(I38:I43)","v":0}]
["Section D - Forecasted Cash Needs"]
[{"$nulls":4},"Total for 1st Year","1st Quarter","2nd Quarter","3rd Quarter","4th quarter"]
["13.","Federal",null,null,{"$f":"G8","v":0},{"$f":"$E$47/4","v":0},{"$f":"$E$47/4","v":0},{"$f":"$E$47/4","v":0},{"$f":"$E$47/4","v":0},null,"Please populate with forecasted cash flow for the first year. This total should match total budget for the first year."]
["14.","Non-Federal",null,null,{"$f":"H8","v":0},{"$f":"$E$48/4","v":0},{"$f":"$E$48/4","v":0},{"$f":"$E$48/4","v":0},{"$f":"$E$48/4","v":0}]
["15.","Total (sum of lines 13 and 14)",null,null,{"$f":"SUM(E47:E48)","v":0},{"$f":"SUM(F47:F48)","v":0},{"$f":"SUM(G47:G48)","v":0},{"$f":"SUM(H47:H48)","v":0},{"$f":"SUM(I47:I48)","v":0},null,{"$f":"IF(SUM(F49:I49)=E49,\"Correct\",\"Review\")","v":"Correct"}]
["Section E - Budget Estimates of Federal Funds Needed for Balance of the Project"]
["(a) Grant Program",null,null,null,"Future Funding Periods (Years)"]
[{"$nulls":4},"Budget period 1","Budget period 2","Budget period 3","Budget period 4","Budget period 5"]
["16.","ARPA-E",null,null,{"$f":"E8","v":0},{"$f":"E9","v":0},{"$f":"E10","v":0},{"$f":"E11","v":0},{"$f":"E12","v":0}]
["17."]
["18."]
["19."]
["20.","Total (sum of lines 16-19)",null,null,{"$f":"SUM(E53:E56)","v":0},{"$f":"SUM(F53:F56)","v":0},{"$f":"SUM(G53:G56)","v":0},{"$f":"SUM(H53:H56)","v":0},{"$f":"SUM(I53:I56)","v":0}]
["Section F - Other Budget Information"]
["21. Direct Charges",null,{"$f":"'Instructions and Summary'!G24-'Instructions and Summary'!G23","v":0},null,"22. Indirect Charges",{"$f":"'Instructions and Summary'!G23","v":0}]
[]
["23.  Remarks"]
[]
[{"$nulls":8},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,"              ",{"$nulls":5},"Prescribed by OMB Circular A-102"]
[null,null,"Authorized for Local Reproduction"]

{"sheet":"a. Personnel","index":3,"n_rows":184,"n_cols":20,"rows_kept":184,"cut":false,"hidden":false,"merged":[[183,0,183,3],[184,0,184,19],[0,0,0,1],[0,5,0,8],[0,3,0,4],[73,0,73,1],[95,0,95,1],[118,0,118,1],[140,0,140,1],[161,0,161,1],[181,0,181,1],[5,18,6,18],[5,19,6,19],[8,0,10,0],[11,0,11,1],[31,0,31,1],[52,0,52,1],[0,17,0,19],[1,0,1,19],[2,0,3,19],[5,0,6,0],[5,1,6,1],[5,2,5,4],[5,5,5,7],[5,8,5,10],[5,17,6,17],[0,11,0,14],[5,11,5,13],[5,14,5,16]]}
["Budget Justification for SF 424A Budget",null,null,"Award Recipient:",null,{"$f":"'Instructions and Summary'!B4","v":0},{"$nulls":5},{"$f":"'Instructions and Summary'!H4","v":0},{"$nulls":5},{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["a. Personnel"]
["PLEASE READ!!!\n\nList personnel costs solely for employees of the entity completing this workbook.  All other personnel costs (of subrecipients or other contractual efforts of the entity preparing this) must be included under tab f., Contractual.  This includes all consultants and FFRDCs. When submitting this Budget Justification Workbook include resumes in the same package.\n\nIdentify positions to be supported.  Key personnel should be identified by title.  All other personnel should be identified either by title or a group category.  State the amounts of time (e.g., hours ) to be expended, the base pay rate or composite base rate, total direct personnel compensation and identify the rate basis (e.g., actual salary, labor distribution report, technical estimate, state civil service rates, etc.).  If composite rates are proposed for a particular position or group category, please provide a list of the proposed personnel and rates/hours used to compute the composite rates in the “Additional explanation/comments” box, as applicable.  If you are proposing escalation rates for the labor rates, please explain in the “Additional explanation/comments” box at the bottom.\n\n"]
[]
[]
["Task # and Title","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 Hours"," Total Dollars","Rate Basis"]
[null,null,"Time \n(Hours)","Pay Rate\n($/Hr)","Total Budget Period 1","Time \n(Hours)","Pay Rate\n($/Hr)","Total Budget Period 2","Time \n(Hours)","Pay Rate\n($/Hr)","Total Budget Period 3","Time \n(Hours)","Pay Rate\n($/Hr)","Total Budget Period 4","Time \n(Hours)","Pay Rate\n($/Hr)","Total Budget Period 5"]
["1.  Generation 2A Receiver Design",null,{"$f":"SUM(C9:C11)","v":7960},null,{"$f":"SUM(E9:E11)","v":372400},{"$f":"SUM(F9:F11)","v":600},null,{"$f":"SUM(H9:H11)","v":26000},{"$f":"SUM(I9:I11)","v":800},null,{"$f":"SUM(K9:K11)","v":34000},{"$f":"SUM(L9:L11)","v":300},null,{"$f":"SUM(N9:N11)","v":13000},{"$f":"SUM(O9:O11)","v":400},null,{"$f":"SUM(Q9:Q11)","v":17000},{"$f":"C8+F8+I8+L8+O8","v":10060},{"$f":"E8+H8+K8+N8+Q8","v":462400},"Actual Salary"]
["EXAMPLE ONLY!!!","Sr. Engineer    ",2000,85,{"$f":"C9*D9","v":170000},200,50,{"$f":"F9*G9","v":10000},200,50,{"$f":"I9*J9","v":10000},100,50,{"$f":"L9*M9","v":5000},100,50,{"$f":"O9*P9","v":5000},{"$f":"C9+F9+I9+L9+O9","v":2600},{"$f":"E9+H9+K9+N9+Q9","v":200000},"Actual Salary"]
[null,"Electrical engineers (2)",4160,40,{"$f":"C10*D10","v":166400},400,40,{"$f":"F10*G10","v":16000},600,40,{"$f":"I10*J10","v":24000},200,40,{"$f":"L10*M10","v":8000},300,40,{"$f":"O10*P10","v":12000},5660,226400,"Actual Salary"]
[null,"Technician         ",1800,20,{"$f":"C11*D11","v":36000},0,0,{"$f":"F11*G11","v":0},0,0,{"$f":"I11*J11","v":0},0,0,{"$f":"L11*M11","v":0},0,0,{"$f":"O11*P11","v":0},1800,36000,"Actual Salary"]
["Task # and Title",null,{"$f":"SUM(C13:C31)","v":0},null,{"$f":"SUM(E13:E31)","v":0},{"$f":"SUM(F13:F31)","v":0},null,{"$f":"SUM(H13:H31)","v":0},{"$f":"SUM(I13:I31)","v":0},null,{"$f":"SUM(K13:K31)","v":0},{"$f":"SUM(L13:L31)","v":0},null,{"$f":"SUM(N13:N31)","v":0},{"$f":"SUM(O13:O31)","v":0},null,{"$f":"SUM(Q13:Q31)","v":0},{"$f":"C12+F12+I12+L12+O12","v":0},{"$f":"E12+H12+K12+N12+Q12","v":0}]
[{"$nulls":4},{"$f":"C13*D13","v":0},null,null,{"$f":"F13*G13","v":0},null,null,{"$f":"I13*J13","v":0},null,null,{"$f":"L13*M13","v":0},null,null,{"$f":"O13*P13","v":0},{"$f":"C13+F13+I13+L13+O13","v":0},{"$f":"E13+H13+K13+N13+Q13","v":0}]
[{"$nulls":4},{"$f":"C14*D14","v":0},null,null,{"$f":"F14*G14","v":0},null,null,{"$f":"I14*J14","v":0},null,null,{"$f":"L14*M14","v":0},null,null,{"$f":"O14*P14","v":0},{"$f":"C14+F14+I14+L14+O14","v":0},0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C33:C52)","v":0},null,{"$f":"SUM(E33:E52)","v":0},{"$f":"SUM(F33:F52)","v":0},null,{"$f":"SUM(H33:H52)","v":0},{"$f":"SUM(I33:I52)","v":0},null,{"$f":"SUM(K33:K52)","v":0},{"$f":"SUM(L33:L52)","v":0},null,{"$f":"SUM(N33:N52)","v":0},{"$f":"SUM(O33:O52)","v":0},null,{"$f":"SUM(Q33:Q52)","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,{"$f":"L33*M33","v":0},null,null,{"$f":"O33*P33","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C54:C73)","v":0},null,{"$f":"SUM(E54:E73)","v":0},{"$f":"SUM(F54:F73)","v":0},null,{"$f":"SUM(H54:H73)","v":0},{"$f":"SUM(I54:I73)","v":0},null,{"$f":"SUM(K54:K73)","v":0},{"$f":"SUM(L54:L73)","v":0},null,{"$f":"SUM(N54:N73)","v":0},{"$f":"SUM(O54:O73)","v":0},null,{"$f":"SUM(Q54:Q73)","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,{"$f":"L54*M54","v":0},null,null,{"$f":"O54*P54","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C75:C95)","v":0},null,{"$f":"SUM(E75:E95)","v":0},{"$f":"SUM(F75:F95)","v":0},null,{"$f":"SUM(H75:H95)","v":0},{"$f":"SUM(I75:I95)","v":0},null,{"$f":"SUM(K75:K95)","v":0},{"$f":"SUM(L75:L95)","v":0},null,{"$f":"SUM(N75:N95)","v":0},{"$f":"SUM(O75:O95)","v":0},null,{"$f":"SUM(Q75:Q95)","v":0},0,0]
[{"$nulls":4},{"$f":"C75*D75","v":0},null,null,{"$f":"F75*G75","v":0},null,null,{"$f":"I75*J75","v":0},null,null,{"$f":"L75*M75","v":0},null,null,{"$f":"O75*P75","v":0},0,0]
[{"$nulls":4},{"$f":"C76*D76","v":0},null,null,{"$f":"F76*G76","v":0},null,null,{"$f":"I76*J76","v":0},null,null,{"$f":"L76*M76","v":0},null,null,{"$f":"O76*P76","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,{"$f":"E77+H77+K77+N77+Q77","v":0}]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"C78+F78+I78+L78+O78","v":0},0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C97:C118)","v":0},null,{"$f":"SUM(E97:E118)","v":0},{"$f":"SUM(F97:F118)","v":0},null,{"$f":"SUM(H97:H118)","v":0},{"$f":"SUM(I97:I118)","v":0},null,{"$f":"SUM(K97:K118)","v":0},{"$f":"SUM(L97:L118)","v":0},null,{"$f":"SUM(N97:N118)","v":0},{"$f":"SUM(O97:O118)","v":0},null,{"$f":"SUM(Q97:Q118)","v":0},0,0]
[{"$nulls":4},{"$f":"C97*D97","v":0},null,null,{"$f":"F97*G97","v":0},null,null,{"$f":"I97*J97","v":0},null,null,{"$f":"L97*M97","v":0},null,null,{"$f":"O97*P97","v":0},0,0]
[{"$nulls":4},{"$f":"C98*D98","v":0},null,null,{"$f":"F98*G98","v":0},null,null,{"$f":"I98*J98","v":0},null,null,{"$f":"L98*M98","v":0},null,null,{"$f":"O98*P98","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C120:C140)","v":0},null,{"$f":"SUM(E120:E140)","v":0},{"$f":"SUM(F120:F140)","v":0},null,{"$f":"SUM(H120:H140)","v":0},{"$f":"SUM(I120:I140)","v":0},null,{"$f":"SUM(K120:K140)","v":0},{"$f":"SUM(L120:L140)","v":0},null,{"$f":"SUM(N120:N140)","v":0},{"$f":"SUM(O120:O140)","v":0},null,{"$f":"SUM(Q120:Q140)","v":0},0,0]
[{"$nulls":4},{"$f":"C120*D120","v":0},null,null,{"$f":"F120*G120","v":0},null,null,{"$f":"I120*J120","v":0},null,null,{"$f":"L120*M120","v":0},null,null,{"$f":"O120*P120","v":0},0,0]
[{"$nulls":4},{"$f":"C121*D121","v":0},null,null,{"$f":"F121*G121","v":0},null,null,{"$f":"I121*J121","v":0},null,null,{"$f":"L121*M121","v":0},null,null,{"$f":"O121*P121","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},{"$f":"C130*D130","v":0},null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"C130+F130+I130+L130+O130","v":0},0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},{"$f":"C137*D137","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C142:C161)","v":0},null,{"$f":"SUM(E142:E161)","v":0},{"$f":"SUM(F142:F161)","v":0},null,{"$f":"SUM(H142:H161)","v":0},{"$f":"SUM(I142:I161)","v":0},null,{"$f":"SUM(K142:K161)","v":0},{"$f":"SUM(L142:L161)","v":0},null,{"$f":"SUM(N142:N161)","v":0},{"$f":"SUM(O142:O161)","v":0},null,{"$f":"SUM(Q142:Q161)","v":0},0,{"$f":"E141+H141+K141+N141+Q141","v":0}]
[{"$nulls":4},{"$f":"C142*D142","v":0},null,null,{"$f":"F142*G142","v":0},null,null,{"$f":"I142*J142","v":0},null,null,{"$f":"L142*M142","v":0},null,null,{"$f":"O142*P142","v":0},{"$f":"C142+F142+I142+L142+O142","v":0},0]
[{"$nulls":4},{"$f":"C143*D143","v":0},null,null,{"$f":"F143*G143","v":0},null,null,{"$f":"I143*J143","v":0},null,null,{"$f":"L143*M143","v":0},null,null,{"$f":"O143*P143","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Task # and Title",null,{"$f":"SUM(C163:C181)","v":0},null,{"$f":"SUM(E163:E181)","v":0},{"$f":"SUM(F163:F181)","v":0},null,{"$f":"SUM(H163:H181)","v":0},{"$f":"SUM(I163:I181)","v":0},null,{"$f":"SUM(K163:K181)","v":0},{"$f":"SUM(L163:L181)","v":0},null,{"$f":"SUM(N163:N181)","v":0},{"$f":"SUM(O163:O181)","v":0},null,{"$f":"SUM(Q163:Q181)","v":0},0,0]
[{"$nulls":4},{"$f":"C163*D163","v":0},null,null,{"$f":"F163*G163","v":0},null,null,{"$f":"I163*J163","v":0},null,null,{"$f":"L163*M163","v":0},null,null,{"$f":"O163*P163","v":0},0,0]
[{"$nulls":4},{"$f":"C164*D164","v":0},null,null,{"$f":"F164*G164","v":0},null,null,{"$f":"I164*J164","v":0},null,null,{"$f":"L164*M164","v":0},null,null,{"$f":"O164*P164","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
["Total Personnel Costs",null,{"$f":"C12+C32+C53+C74+C96+C119+C141+C162","v":0},null,{"$f":"E12+E32+E53+E74+E96+E119+E141+E162","v":0},{"$f":"F12+F32+F53+F74+F96+F119+F141+F162","v":0},null,{"$f":"H12+H32+H53+H74+H96+H119+H141+H162","v":0},{"$f":"I12+I32+I53+I74+I96+I119+I141+I162","v":0},null,{"$f":"K12+K32+K53+K74+K96+K119+K141+K162","v":0},{"$f":"L12+L32+L53+L74+L96+L119+L141+L162","v":0},null,{"$f":"N12+N32+N53+N74+N96+N119+N141+N162","v":0},{"$f":"O12+O32+O53+O74+O96+O119+O141+O162","v":0},null,{"$f":"Q12+Q32+Q53+Q74+Q96+Q119+Q141+Q162","v":0},0,0]
[]
["Additional Explanations/Comments (as necessary):"]

{"sheet":"b. Fringe Benefits","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,10,17,12],[0,0,0,3],[0,5,0,7],[17,1,17,8],[10,0,11,8],[5,0,5,2],[6,0,6,2],[24,0,24,8],[15,1,15,8],[1,0,1,8],[2,0,2,2],[3,0,3,2],[9,0,9,2],[16,1,16,8],[14,1,14,8],[13,0,13,8],[19,0,21,8],[4,0,4,2],[7,0,7,2],[8,0,8,2],[23,0,23,4],[12,0,12,8]]}
["Budget Justification for SF 424A Budget",null,null,null,"Award Recipient:",{"$f":"'Instructions and Summary'!B4","v":0},null,null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["b. Fringe Benefits"]
["Rate Type:",null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Total"]
[null,null,null,0,{"$f":"D4","v":0},0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
["Total fringe requested:",null,null,0,{"$f":"0","v":0},0,0,0,{"$f":"SUM(D10:H10)","v":0}]
[{"$f":"IF(A15=A17,\"One box should be checked in the fringe rate agreement section.\",\"\")","v":"One box should be checked in the fringe rate agreement section."}]
[]
["Applicants are required to indicate if they have a Federally approved fringe benefit rate agreement.\n\n"]
["If reimbursement for fringe benefits is requested, a Federally approved fringe benefit rate agreement, or a fringe benefit rate proposal is required in accordance with the instructions below.  The fringe benefit rate proposal must be accepted by ARPA-E for estimating purposes.  Calculate the fringe rate/dollars and enter this information above."]
[null,"A fringe benefit rate has been negotiated with, or approved by, a Federal government agency.  A copy of the latest rate agreement is included with the Full Application (*see information below). "]
[]
[null,"A fringe benefit rate has not been negotiated with, or approved by, a Federal agency (*see information below)."]
[null,"If an Applicant is selected for award negotiations and does not have a Federally approved fringe benefit rate agreement, then the Applicant is required to submit an Indirect Rate Proposal to the ARPA-E Contracting Officer.  A template for Indirect Rate Proposals is available at https://arpa-e.energy.gov/technologies/project-guidance/pre-award-guidance/required-forms-and-templates.  The Applicant must provide this information to the ARPA-E Contracting Officer at ARPA-E-CO@hq.doe.gov within 2 days after the receiving the award notification. In the subject line of the email, please state “Rate Proposal” and include the Applicant’s name, FOA name and number, and application control number.",{"$nulls":7},"X"]
[]
["*IMPORTANT:  In the space provided below (or as an attachment) provide a complete explanation and the full calculations used to derive the total fringe costs.  If the total fringe costs are a cumulative amount of more than one calculation or rate application, the explanation and calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with grand total).  Do not average the rates and apply them to get one fringe cost percentage.  NOTE:  You must apply the fringe benefit rate to both the Federal Share and Recipient Cost Share."]
[]
[]
[]
["Explanations/Comments/Calculations/Formula:"]

{"sheet":"c. Travel","index":5,"n_rows":251,"n_cols":8,"rows_kept":251,"cut":false,"hidden":false,"merged":[[244,0,244,5],[245,0,245,5],[246,0,246,7],[196,0,196,7],[197,0,197,7],[198,0,198,5],[221,0,221,5],[222,0,222,5],[250,0,250,7],[97,0,97,7],[6,0,6,7],[50,0,50,7],[2,0,2,7],[27,0,27,5],[47,0,47,5],[74,0,74,5],[94,0,94,5],[121,0,121,5],[144,0,144,5],[145,0,145,5],[95,0,95,5],[48,0,48,5],[147,0,147,7],[148,0,148,5],[0,7,0,8],[247,0,247,5],[7,0,7,5],[51,0,51,5],[75,0,75,5],[98,0,98,5],[122,0,122,5],[28,0,28,5],[146,0,146,7],[1,0,1,7],[0,4,0,6],[0,2,0,3],[171,0,171,5],[172,0,172,5],[194,0,194,5],[195,0,195,5]]}
["Budget Justification for SF 424A Budget",null,"Award Recipient:",null,{"$f":"'Instructions and Summary'!B4","v":0},null,null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["c. Travel"]
["PLEASE READ!!!\n\nProvide travel detail as requested below, identifying total Foreign and Domestic Travel as separate items.  \"Purpose of travel\" are items such as professional conference, DOE sponsored meeting, project management meeting, etc.  The Basis for Estimating Costs are items such as past trips, current quotations, Federal Travel Regulations, etc. Note:  Travel to the annual ARPA-E Energy Innovation Summit must be proposed under the “Other Direct Cost” tab for each Budget Year.  Non-travel related expenses for the ARPA-E Annual Energy Summit must be approved in advance by the ARPA-E Contracting Officer.  Applicants must submit requests to the ARPA-E Contracting Officer at ARPA-E-CO@hq.doe.gov. at least 30 days in advance of the ARPA-E Annual Summit.  In the subject line of the email, please state “Request for Non-Travel Expenses for ARPA-E Energy Innovation Summit” and include the Applicant’s name, FOA name and number, and application control number.\n\nAll listed travel must be necessary for the performance of the objectives in the Statement of Project Objectives and accompanying Technical Milestones and Deliverables.  The Prime Recipient must budget for one visit per year with the ARPA-E Program Director in Washington, DC. "]
[]
["Purpose of travel","No. of Travelers","Depart From \n","Destination \n","No. of Days","Cost per Traveler","Cost per Trip","Basis for Estimating Costs"]
["EXAMPLE ONLY!!!   Visit to PV cell mfr. to set up vendor agreement",2,null,null,2,650,{"$f":"F6*B6","v":1300},"Internet prices"]
["Budget Period 1"]
["Domestic Travel"]
[{"$nulls":6},{"$f":"F9*B9","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["Domestic Travel Subtotal",{"$nulls":5},{"$f":"SUM(G9:G27)","v":0}]
["International Travel"]
[{"$nulls":6},{"$f":"F30*B30","v":0}]
[{"$nulls":6},{"$f":"F31*B31","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F44*B44","v":0}]
[{"$nulls":6},{"$f":"F45*B45","v":0}]
[{"$nulls":6},{"$f":"F46*B46","v":0}]
[{"$nulls":6},{"$f":"F47*B47","v":0}]
["International Travel Subtotal",{"$nulls":5},{"$f":"SUM(G30:G47)","v":0}]
["Year 1 Total",{"$nulls":5},{"$f":"G28+G48","v":0}]
[]
["Budget Period 2"]
["Domestic Travel"]
[{"$nulls":6},{"$f":"F53*B53","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["Domestic Travel Subtotal",{"$nulls":5},{"$f":"SUM(G53:G74)","v":0}]
["International Travel"]
[{"$nulls":6},{"$f":"F77*B77","v":0}]
[{"$nulls":6},{"$f":"F78*B78","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F91*B91","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F93*B93","v":0}]
[{"$nulls":6},{"$f":"F94*B94","v":0}]
["International Travel Subtotal",{"$nulls":5},{"$f":"SUM(G77:G94)","v":0}]
["Year 2 Total",{"$nulls":5},{"$f":"G75+G95","v":0}]
[]
["Budget Period 3"]
["Domestic Travel"]
[{"$nulls":6},{"$f":"F100*B100","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["Domestic Travel Subtotal",{"$nulls":5},{"$f":"SUM(G100:G121)","v":0}]
["International Travel"]
[{"$nulls":6},{"$f":"F124*B124","v":0}]
[{"$nulls":6},{"$f":"F125*B125","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F140*B140","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F142*B142","v":0}]
[{"$nulls":6},{"$f":"F143*B143","v":0}]
[{"$nulls":6},{"$f":"F144*B144","v":0}]
["International Travel Subtotal",{"$nulls":5},{"$f":"SUM(G124:G144)","v":0}]
[" Year 3 Total",{"$nulls":5},{"$f":"G122+G145","v":0}]
[]
["Budget Period 4"]
["Domestic Travel"]
[{"$nulls":6},{"$f":"F150*B150","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["Domestic Travel Subtotal",{"$nulls":5},{"$f":"SUM(G150:G171)","v":0}]
["International Travel"]
[{"$nulls":6},{"$f":"F174*B174","v":0}]
[{"$nulls":6},{"$f":"F175*B175","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F192*B192","v":0}]
[{"$nulls":6},{"$f":"F193*B193","v":0}]
[{"$nulls":6},{"$f":"F194*B194","v":0}]
["International Travel Subtotal",{"$nulls":5},{"$f":"SUM(G174:G194)","v":0}]
[" Year 4 Total",{"$nulls":5},{"$f":"G172+G195","v":0}]
[]
["Budget Period 5"]
["Domestic Travel"]
[{"$nulls":6},{"$f":"F200*B200","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["Domestic Travel Subtotal",{"$nulls":5},{"$f":"SUM(G200:G221)","v":0}]
["International Travel"]
[{"$nulls":6},{"$f":"F224*B224","v":0}]
[{"$nulls":6},{"$f":"F225*B225","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},{"$f":"F242*B242","v":0}]
[{"$nulls":6},{"$f":"F243*B243","v":0}]
[{"$nulls":6},{"$f":"F244*B244","v":0}]
["International Travel Subtotal",{"$nulls":5},{"$f":"SUM(G224:G244)","v":0}]
[" Year 5 Total",{"$nulls":5},{"$f":"G222+G245","v":0}]
[]
["PROJECT TOTAL",{"$nulls":5},{"$f":"G49+G96+G146+G196+G246","v":0}]
[]
["Additional Explanations/Comments (as necessary):"]
["Travel is calculated as: Flight, per Diam, Hotel, Taxi. In the Basis for Estimating cost for each trip I have listed these values in order: Flight per person, Per Diem per person, Hotel per night per person, Taxi total."]

{"sheet":"d. Equipment","index":6,"n_rows":267,"n_cols":6,"rows_kept":267,"cut":false,"hidden":false,"merged":[[267,0,267,5],[1,0,1,5],[45,0,45,5],[96,0,96,5],[2,0,2,5],[6,0,6,5],[266,0,266,3],[43,0,43,2],[94,0,94,2],[150,0,150,2],[43,4,43,5],[94,4,94,5],[152,0,152,5],[206,0,206,2],[207,0,207,5],[208,0,208,5],[264,4,264,5],[151,0,151,5],[0,3,0,4],[0,5,0,6],[264,0,264,2],[262,0,262,2],[263,0,263,5]]}
["Budget Justification for SF 424A Budget",null,"Award Recipient:",{"$f":"'Instructions and Summary'!B4","v":0},null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["d. Equipment"]
["PLEASE READ!!!\n\n\"Equipment\" is generally defined as an item with an acquisition cost greater than $5,000 and a useful life expectancy of more than one year.  Further definitions can be found at 2 C.F.R. 200.\n\nList all proposed equipment below, providing a basis of cost such as vendor quotes, catalog prices, prior invoices, etc., and briefly justify its need as it applies to the Statement of Project Objectives and accompanying Technical Milestones and Deliverables.  If it is existing equipment, and the value of its contribution to the project budget is being shown as cost share, provide logical support for the estimated value shown.  If it is new equipment which will retain a useful life upon completion of the project, provide logical support for the estimated value shown.\n\nFor equipment with a unit price of $50,000.00 or greater, also include a copy of the associated vendor quote or catalog price list.\n"]
[]
["Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of Need"]
["EXAMPLE ONLY!!!   Thermal shock chamber",2,20000,{"$f":"B6*C6","v":40000},"Vendor Quote","Reliability testing of PV modules- Task 4.3"]
["Budget Period 1"]
[null,null,null,{"$f":"B8*C8","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 1 Total",null,null,{"$f":"SUM(D8:D43)","v":0}]
[]
["Budget Period 2"]
[null,null,null,{"$f":"B47*C47","v":0}]
[null,null,null,{"$f":"B48*C48","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 2 Total",null,null,{"$f":"SUM(D47:D94)","v":0}]
[]
["Budget Period 3"]
[null,null,null,{"$f":"B98*C98","v":0}]
[null,null,null,{"$f":"B99*C99","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B141*C141","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 3 Total",null,null,{"$f":"SUM(D98:D150)","v":0}]
[]
["Budget Period 4"]
[null,null,null,{"$f":"B154*C154","v":0}]
[null,null,null,{"$f":"B155*C155","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 4 Total",null,null,{"$f":"SUM(D154:D206)","v":0}]
[]
["Budget Period 5"]
[null,null,null,{"$f":"B210*C210","v":0}]
[null,null,null,{"$f":"B211*C211","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 5 Total",null,null,{"$f":"SUM(D210:D262)","v":0}]
[]
["PROJECT TOTAL",null,null,{"$f":"D44+D95+D151+D207+D263","v":0}]
[]
["Additional Explanations/Comments (as necessary):"]

{"sheet":"e. Supplies","index":7,"n_rows":366,"n_cols":6,"rows_kept":366,"cut":false,"hidden":false,"merged":[[366,0,366,5],[365,0,365,2],[221,4,221,5],[363,4,363,5],[363,0,363,2],[223,0,223,5],[291,0,291,2],[291,4,291,5],[292,0,292,5],[293,0,293,5],[361,0,361,2],[361,4,361,5],[362,0,362,5],[221,0,221,2],[222,0,222,5],[0,5,0,6],[0,3,0,4],[1,0,1,5],[153,0,153,5],[2,0,2,5],[6,0,6,5],[81,0,81,5],[79,4,79,5],[151,4,151,5],[151,0,151,2],[79,0,79,2]]}
["Budget Justification for SF 424A Budget",null,"Award Recipient:",{"$f":"'Instructions and Summary'!B4","v":0},null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["e. Supplies"]
["PLEASE READ!!!\n\n\"Supplies\" are generally defined as an item with an acquisition cost of $5,000 or less and a useful life expectancy of less than one year.  Supplies are generally consumed during the project performance. Further definitions can be found at 2 C.F.R. 200.\n\nList all proposed supplies below, providing a bases of cost such as vendor quotes, catalog prices, prior invoices, etc., and briefly justifying the need for the Supplies as they apply to the Statement of Project Objectives and accompanying Technical Milestones and Deliverables.  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.\n\n"]
[]
["General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of Need"]
["EXAMPLE ONLY!!!  Wireless DAS components",10,360,3600,"Catalog price","For Alpha prototype - Task 2.4"]
["Budget Period 1"]
[null,null,null,{"$f":"B8*C8","v":0}]
[null,null,null,{"$f":"B9*C9","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 1 Total",null,null,{"$f":"SUM(D8:D79)","v":0}]
[]
["Budget Period 2"]
[null,null,null,{"$f":"B83*C83","v":0}]
[null,null,null,{"$f":"B84*C84","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B150*C150","v":0}]
[null,null,null,0]
["Year 2 Total",null,null,{"$f":"SUM(D83:D151)","v":0}]
[]
["Budget Period 3"]
[null,null,null,{"$f":"B155*C155","v":0}]
[null,null,null,{"$f":"B156*C156","v":0}]
[null,null,null,{"$f":"B157*C157","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B216*C216","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Year 3 Total",null,null,{"$f":"SUM(D155:D221)","v":0}]
[]
["Budget Period 4"]
[null,null,null,{"$f":"B225*C225","v":0}]
[null,null,null,{"$f":"B226*C226","v":0}]
[null,null,null,{"$f":"B227*C227","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B291*C291","v":0}]
["Year 4 Total",null,null,{"$f":"SUM(D225:D291)","v":0}]
[]
["Budget Period 5"]
[null,null,null,{"$f":"B295*C295","v":0}]
[null,null,null,{"$f":"B296*C296","v":0}]
[null,null,null,{"$f":"B297*C297","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B361*C361","v":0}]
["Year 5 Total",null,null,{"$f":"SUM(D295:D361)","v":0}]
[]
["PROJECT TOTAL",null,null,{"$f":"D222+D152+D80+D292+D362","v":0}]
[]
["Additional Explanations/Comments (as necessary):"]

{"sheet":"f. Contractual","index":8,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[56,0,56,7],[0,0,0,1],[2,0,2,7],[1,0,1,7],[55,0,55,1],[3,0,3,7],[53,0,53,1],[39,0,39,1],[51,0,51,1],[20,0,20,1],[0,2,0,3]]}
["Budget Justification for SF 424A Budget                                                             Award Recipient:",null,{"$f":"'Instructions and Summary'!B4","v":0},{"$nulls":4},{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["f. Contractual"]
["PLEASE READ!!!\n\nThe entity completing this form must provide all costs related to subrecipients, vendors, contractors, consultants and FFRDC partners in the applicable boxes below.  \n\nSubrecipients (partners, subawardees): \nEach Subrecipient incurring greater than or equal to 10% of the Total Project Costs must complete a separate Budget Justification Workbook to justify its proposed budget.  The Subrecipients’ SF-424A and Budget Justification Workbooks may be completed by either the Subrecipients themselves or by the preparer of this workbook.  The budget totals on the Subrecipients' workbooks must match the Subrecipient entries described below.\n\nSubrecipients incurring less than 10% of the Total Project Costs are not required to complete a separate Budget Justification workbook.  However, such Subrecipients are required to provide supporting documentation to justify their proposed budgets.  At a minimum, the supporting documentation must include a sufficient basis for the estimated costs for ARPA-E evaluation.  Please also refer to instructions in tabs b. Fringe Benefits and i. Indirect Costs."]
["Vendors (includes contractors and consultants):\nList all vendors, contractors and consultants supplying commercial supplies or services used to support the project.  The support to justify vendor costs (in any amount) should provide the purpose for the products or services and a basis of the estimated costs that is considered sufficient for ARPA-E evaluation.\n\nFederal Research and Development Centers (FFRDCs):\nEach FFRDC incurring greater than or equal to 10% of the Total Project Costs must complete a separate SF-424A and separate Budget Justification worksheet to justify its proposed budget.  The FFRDC workbooks may be completed by either the Subrecipients themselves or by the preparer of this workbook.  The budget totals on the Subrecipient's SF-424A and Budget Justification Workbook must match the Subrecipient entries described below.  DOE/NNSA FFRDCs are also required to submit a Field Work Proposal in accordance with the instructions in DOE O 412.1, “Work Authorization System” (http://management.energy.gov/business_doe/business_forms.htm) in the Technical Volume of the Full Application.  \n\nFFRDCs incurring less than 10% of the Total Project Cost are not required to complete a separate SF-424A and Budget Justification Workbook.  However, FFRDCs are required to provide supporting documentation to justify their proposed budgets.  At a minimum, the supporting documentation must include a sufficient basis for the estimated costs for ARPA-E evaluation. All DOE/NNSA FFRDCs are also required to submit a Field Work Proposal.  Please also refer to instructions in tabs b. Fringe Benefits and i. Indirect Costs.                                                                    \n             "]
[]
["Sub-Recipient\nName/Organization","Purpose/Tasks in Statement of Project Objectives (SOPO)","Budget Period 1 Costs","Budget Period 2 Costs","Budget Period 3 Costs","Budget Period 4 Costs","Budget Period 5 Costs","Project Total"]
["EXAMPLE ONLY!!!  XYZ Corp.","Partner to develop optimal fresnel lens for Gen 2 product - Task 2.4",80000,64000,48000,32000,16000,{"$f":"SUM(C7:G7)","v":240000},{"$f":"IF(H7>100000,\"Separate budget forms required for this sub-recipient!\", \" \")","v":"Separate budget forms required for this sub-recipient!"}]
[{"$nulls":7},{"$f":"SUM(C8:G8)","v":0},{"$f":"IF(H8>=100000,\"Separate budget forms required for this sub-recipient!\", \" \")","v":" "}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0,{"$f":"IF(H14>100000,\"Separate budget forms required for this sub-recipient!\", \" \")","v":" "}]
[{"$nulls":7},0," "]
[{"$nulls":7},0," "]
[{"$nulls":7},0," "]
[{"$nulls":7},0," "]
[{"$nulls":7},0," "]
[{"$nulls":7},0," "]
["Total Sub-Recipient",null,{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D20)","v":0},{"$f":"SUM(E8:E20)","v":0},{"$f":"SUM(F8:F20)","v":0},{"$f":"SUM(G8:G20)","v":0},0]
[]
["Vendor \nName/Organization","Product or Service, Purpose/Need and Basis of Cost\n(Provide additional support at bottom of page as needed)","Budget Period 1 Costs","Budget Period 2 Costs","Budget Period 3 Costs","Budget Period 4 Costs","Budget Period 5 Costs","Project Total"]
["EXAMPLE ONLY!!!  ABC Corp.","Vendor for developing custom robotics to perform lens inspection,  alignment, and placement (Task 4 ).  Required for expanding CPV module mfg. capacity.  Cost is from competitive quotes.",32900,86500,null,null,null,{"$f":"SUM(C24:G24)","v":119400}]
[{"$nulls":7},{"$f":"SUM(C25:G25)","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["Total Vendor / Organization",null,{"$f":"SUM(C25:C39)","v":0},{"$f":"SUM(D25:D39)","v":0},{"$f":"SUM(E25:E39)","v":0},{"$f":"SUM(F25:F39)","v":0},{"$f":"SUM(G25:G39)","v":0},0]
[]
["FFRDC\n(Separate Work Authorization or other Sub-Award)\nName/Organization","Purpose","Budget Period 1 Costs","Budget Period 2 Costs","Budget Period 3 Costs","Budget Period 4 Costs","Budget Period 5 Costs","Project Total"]
[null," ",{"$nulls":5},{"$f":"SUM(C43:G43)","v":0}]
[{"$nulls":7},{"$f":"SUM(C44:G44)","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["Total FFRDC",null,{"$f":"SUM(C43:C51)","v":0},{"$f":"SUM(D43:D51)","v":0},{"$f":"SUM(E43:E51)","v":0},{"$f":"SUM(F43:F51)","v":0},{"$f":"SUM(G43:G51)","v":0},0]
[]
["Total Contractual",null,{"$f":"C40+C21+C52","v":0},0,0,0,0,0]
[]
["Additional Explanations/Comments (as necessary):"]

{"sheet":"g. Construction","index":9,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,0,49,3],[33,0,33,3],[39,2,39,3],[40,0,40,3],[41,0,41,3],[48,2,48,3],[0,3,0,4],[17,0,17,3],[25,0,25,3],[53,0,53,3],[1,0,1,3],[5,0,5,3],[4,0,4,3],[2,0,2,3],[9,0,9,3],[23,2,23,3],[31,2,31,3],[50,2,50,3],[15,2,15,3],[16,0,16,3],[24,0,24,3],[32,0,32,3]]}
["Budget Justification for SF 424A Budget","Award Recipient:",{"$f":"'Instructions and Summary'!B4","v":0},{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["g. Construction"]
["PLEASE READ!!!\n\n\"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 vendor or subrecipient to the award recipient should be entered under f. Contractual.\n\nList 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 and accompanying Technical Milestones and Deliverables being performed.\n\n"]
[]
["Overall description of construction activities:"]
["EXAMPLE ONLY!!! \"Build wind turbine platform\""]
[]
["General Description","Cost             ","Basis of Cost","Justification of Need"]
["EXAMPLE ONLY!!! Three days of excavation for platform site\n",28000,"Engineering estimate","Site must be prepared for construction of platform."]
["Budget Period 1"]
[]
[]
[]
[]
[]
["Year 1 Total",{"$f":"SUM(B11:B15)","v":0}]
[]
["Budget Period 2"]
[]
[]
[]
[]
[]
["Year 2 Total",{"$f":"SUM(B19:B23)","v":0}]
[]
["Budget Period 3"]
[]
[]
[]
[]
[]
["Year 3 Total",{"$f":"SUM(B27:B31)","v":0}]
[]
["Budget Period 4"]
[]
[]
[]
[]
[]
["Year 4 Total",{"$f":"SUM(B35:B39)","v":0}]
[]
["Budget Period 5"]
[]
[]
[]
[]
[]
[]
["Year 5 Total",{"$f":"SUM(B43:B48)","v":0}]
[]
["PROJECT TOTAL",{"$f":"$B$32+$B$24+$B$16+$B$40+$B$49","v":0}]
[]
["Additional Explanations/Comments (as necessary):"]

{"sheet":"h. Other","index":10,"n_rows":132,"n_cols":10,"rows_kept":132,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,5,0,6],[1,0,1,5],[2,0,18,5],[2,8,2,9],[86,0,86,5],[131,0,131,2],[132,0,132,5],[107,0,107,5],[128,0,128,5]]}
["Budget Justification for SF 424A Budget               Award Recipient:",null,{"$f":"'Instructions and Summary'!B4","v":0},null,null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["h. Other Direct Costs"]
["PLEASE READ!!!\n\nApplicants must provide and justify proposed costs related to Other Direct Costs for each year of the entire budget period.  Other Direct Costs are direct cost items required for the project which do not fit clearly into other categories, and are not included in the indirect pool for which the indirect rate is being applied to this project.  Other Direct Costs include Technology Transfer and Outreach (TT&O) activities.  Examples of TT&O activities that are allowable under Federal costs principles are provided in Section IV.G.8 of the FOA.   Applicants must provide a basis of cost (e.g., vendor quotes, prior purchases of similar or like items, published price list, etc.).                                                                                                                                                                                                                           \n\nNote for TT&O Activities:  Applicants may choose to not include TT&O activities if appropriate, and do not need a waiver to do so. If applicants do decide to include TT&O, all budget activities must relate to achieving specific objectives, Technical Milestones and Deliverables outlined in the Statement of Project Objectives. Applicants must list TT&O costs with a clear description of what activities are to take place (e.g. travel to the Annual ARPA-E Innovation Summit, work devoted to a commercialization plan, etc.). \n\nOnly TT&O costs that relate to a specific technology funded by ARPA-E will be allowed, if the costs are allowable in accordance with Federal cost principles.  For TT&O activities aimed at advancing a portfolio of technologies and/or products owned by the Recipient or Project Partner, only the portion of costs specifically attributable to advancing the ARPA-E funded technology will be reimbursed.  Applicants are required to certify in the Full Application that they have met the 5% requirement for TT&O expenditures in their SF-424A and Budget Justification unless they submit an accompanying waiver request.  Applicants may seek a waiver of the TT&O requirement in whole or in part by including an explicit request in their Full Application.  In their request, Applicants must describe the proposed technology’s stage of development (i.e., early-stage or late-stage) with reference to Technology Readiness Levels (TRLs).  In addition, Applicants must describe in detail why the TT&O requirement should not be applied to their project or why they are proposing less than the required 5%.\n \nNote for Patent Costs:  ARPA-E will reimburse up to $30,000 in expenditures incurred under the funding agreement for costs and fees relating to the filing and prosecution of U.S. patent applications on subject inventions disclosed to ARPA-E and DOE in accordance with Attachment 2 to the funding agreement (http://arpa-e.energy.gov/FundingAgreements/CooperativeAgreements.aspx).  Prime Recipients may use costs and fees in excess of $30,000 to meet their cost share obligations under the funding agreement. \n\nARPA-E will not reimburse any costs and fees relating to the filing and prosecution of foreign patent applications on subject inventions disclosed to ARPA-E and DOE in accordance with Attachment 2 to the funding agreement.  However, Prime Recipients may use such costs and fees to meet their cost share obligations. For examples of allowable patent costs, please see Section IV.G.3 of the FOA.  \n\n\n      \n\n",{"$nulls":7},"TT&O Totals (Optional)"]
[{"$nulls":8},"TT&O Personnel",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Personnel\")","v":0}]
[{"$nulls":8},"TT&O Fringe",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Fringe\")","v":0}]
[{"$nulls":8},"TT&O Travel",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Travel\")","v":0}]
[{"$nulls":8},"TT&O Equipment",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Equipment\")","v":0}]
[{"$nulls":8},"TT&O Supplies",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Supplies\")","v":0}]
[{"$nulls":8},"TT&O Other",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Other\")","v":0}]
[{"$nulls":8},"TT&O Contractual ",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Contractual\")","v":0}]
[{"$nulls":8},"TT&O Construction",{"$f":"SUMIFS($B$26:$B$127,$D$26:$D$127,\"Yes\",$E$26:$E$127,\"TT&O Construction\")","v":0}]
[{"$nulls":8},"TT&O Total",{"$f":"SUM(J4:J11)","v":0}]
[]
[{"$nulls":8},"TT&O Year 1",{"$f":"SUMIF(D26:D43, \"Yes\", B26:B43)","v":0}]
[{"$nulls":8},"TT&O Year 2",{"$f":"SUMIF(D47:D64, \"Yes\", B47:B64)","v":0}]
[{"$nulls":8},"TT&O Year 3",{"$f":"SUMIF(D68:D85, \"Yes\", B68:B85)","v":0}]
[{"$nulls":8},"TT&O Year 4",{"$f":"SUMIF(D89:D106, \"Yes\", B89:B106)","v":0}]
[{"$nulls":8},"TT&O Year 5",{"$f":"SUMIF(D110:D127, \"Yes\", B110:B127)","v":0}]
[]
[]
["General description"," Cost             ","Basis of Cost","TT&O?","TT&O Type","Justification of Need"]
["EXAMPLE ONLY!!!  Grad student tuition",16000,"Established UCD costs","No",null,"Support of graduate students working on project "]
["EXAMPLE ONLY!!!  Contractual ",10000,"Vendor Quote","No",null,"Personnel costs to develop commercialization plans"]
["EXAMPLE ONLY!!!  Conferences",4000,"Travel & Conference Expenses ","Yes","TT&O Travel","ARPA-E Energy Summit travel and registration"]
[null,null,"Budget Period 1",{"$nulls":5},"Yes"]
[{"$nulls":8},"No"]
{"$rows_empty":17}
["Year 1 Total",{"$f":"SUM(B26:B43)","v":0}]
[]
[null,null,"Budget Period 2"]
{"$rows_empty":18}
["Year 2 Total",{"$f":"SUM(B47:B64)","v":0}]
[]
[null,null,"Budget Period 3"]
{"$rows_empty":18}
["Year 3 Total",{"$f":"SUM(B68:B85)","v":0}]
[]
[null,null,"Budget Period 4"]
{"$rows_empty":18}
["Year 4 Total",{"$f":"SUM(B89:B106)","v":0}]
[]
[null,null,"Budget Period 5"]
{"$rows_empty":18}
["Year 5 Total",{"$f":"SUM(B110:B127)","v":0}]
[]
["PROJECT TOTAL",{"$f":"B86+B65+B44+B107+B128","v":0}]
[]
["Additional Explanations/Comments (as necessary):"]

{"sheet":"i. Indirect Costs","index":11,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,1,13,10],[15,1,15,10],[14,1,14,10],[16,1,16,10],[0,4,0,5],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[0,6,0,7],[22,0,22,10],[12,0,12,10],[11,0,11,10],[14,12,15,13],[0,0,0,3],[0,9,0,10],[21,0,21,8],[8,0,8,2],[2,8,2,9],[3,8,3,9],[8,8,8,9],[1,0,1,10],[2,0,2,2],[3,0,3,2],[19,0,19,10],[9,0,10,10]]}
["Budget Justification for SF 424A Budget          Award Recipient:",null,null,null,{"$f":"'Instructions and Summary'!B4","v":0},null,{"$f":"'Instructions and Summary'!D4","v":"Submitted by: "},null,null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["i. Indirect Costs"]
["Rate type:",null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Total"]
[null,null,null,0,{"$f":"D4","v":0},0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
["Total indirect costs requested:",null,null,{"$f":"ROUND((D4)*'a. Personnel'!E182,)","v":0},{"$f":"ROUND((E4)*'a. Personnel'!H182,)","v":0},0,0,0,{"$f":"SUM(D9:H9)","v":0}]
[{"$f":"IF(A14=A16,\"One box should be checked in the indirect rate agreement section.\",\"\")","v":""}]
[]
["Applicants are required to indicate if they have a Federally approved indirect rate agreement.\n\n"]
["If reimbursement for indirect costs is requested, a federally approved indirect rate agreement , or an indirect rate proposal is required in accordance with the instructions below.   The indirect rate proposal must be accepted by ARPA-E for estimating purposes.  Calculate the indirect rate/dollars and enter this information above. ",{"$nulls":11},"x"]
[null,"An indirect rate has been negotiated with, or approved by, a Federal government agency.  A copy of the latest rate agreement is included with the Full Application (*see information below)."]
[]
["x","An indirect rate agreement has not been negotiated with, or approved by, a Federal government agency (*see information below). "]
[null,"If an Applicant is selected for award negotiations and does not have a Federally approved indirect rate agreement, then the Applicant is required to submit an Indirect Rate Proposal to the ARPA-E Contracting Officer.  A template for Indirect Rate Proposal is available at https://arpa-e.energy.gov/technologies/project-guidance/pre-award-guidance/required-forms-and-templates.  The Applicant must provide this information to the ARPA-E Contracting Officer at ARPA-E-CO@hq.doe.gov within 2 days after the receiving the award notification. In the subject line of the email, please state “Rate Proposal” and include the Applicant’s name, FOA name and number, and application control number."]
[]
[]
["*IMPORTANT:  In the space provided below (or as an attachment) provide a complete explanation and the full calculations used to derive the total indirect costs.  If the total indirect costs are a cumulative amount of more than one calculation or rate application, the explanation and calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with grand total).  Do not average the rates and apply them to get one indirect cost percentage.  NOTE:  You must apply the indirect rate to both the Federal Share and Recipient Cost Share."]
[]
["Explanations/Comments/Calculations/Formula:"]

{"sheet":"Cost Share","index":12,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,5,0,9],[24,0,24,3],[0,0,0,2],[1,0,1,9],[29,0,29,9],[2,0,2,9],[28,0,28,3],[25,5,25,6],[26,4,26,6],[26,0,26,1],[25,7,25,8]]}
["Budget Justification for SF 424A Budget         Award Recipient:",null,null,{"$f":"'Instructions and Summary'!B4","v":0},null,{"$f":"'Instructions and Summary'!I1","v":"8/24/2021  V 6.20"}]
["Cost Share"]
["PLEASE READ!!!\n\nApplicants must provide and justify proposed costs related to Cost Share for each year of the entire budget period.  Applicants must provide a detailed explanation of the cash or cash value of all cost share proposed for the project.  Please refer to Section III.B of the FOA for guidance on allowable cost share contributions.  Applicants selected for award negotiations must provide cost share commitment letters, as described in Section VI.B.3 of the FOA.  \n\nProject teams are not permitted to receive fees or profits under ARPA-E awards.  All monies must be spent on activities or equipment directly related to meeting the objectives in the Statement of Project Objectives and accompanying Technical Milestones and Deliverables.  Additionally, foregone fee or profit by any member of the proposed Project Team may not be considered cost sharing under any resulting award. \n\n"]
[]
["Organization/Source                 ","Type","Type of Donor (MUST SELECT)","Cost Share Item ","Budget Period 1 Cost Share","Budget Period 2 Cost Share","Budget Period 3 Cost Share","Budget Period 4 Cost Share","Budget Period 5 Cost Share","Total Project Cost Share"]
["EXAMPLE ONLY!!! ABC Company\n","Cash","Other","Project partner ABC Company will provide 40 PV modules for product development at 50% off the of the retail price of $680",13600,{"$nulls":4},{"$f":"SUM(E6:I6)","v":13600}]
[{"$nulls":9},{"$f":"SUM(E7:I7)","v":0},null,"Cash"]
[{"$nulls":9},{"$f":"SUM(E8:I8)","v":0},null,"In Kind"]
[{"$nulls":9},0,null,"Other"]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},{"$f":"SUM(E13:I13)","v":0},null,"Applicant",{"$f":"SUMIF($C$7:$C$24,$L$13,E$7:E$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$13,F$7:F$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$13,G$7:G$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$13,H$7:H$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$13,I$7:I$24)","v":0}]
[{"$nulls":9},0,null,"State",{"$f":"SUMIF($C$7:$C$24,$L$14,E$7:E$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$14,F$7:F$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$14,G$7:G$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$14,H$7:H$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$14,I$7:I$24)","v":0}]
[{"$nulls":9},0,null,"Other Sources",{"$f":"SUMIF($C$7:$C$24,$L$15,E$7:E$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$15,F$7:F$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$15,G$7:G$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$15,H$7:H$24)","v":0},{"$f":"SUMIF($C$7:$C$24,$L$15,I$7:I$24)","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
["Totals",null,null,null,{"$f":"SUM(E7:E24)","v":0},{"$f":"SUM(F7:F24)","v":0},{"$f":"SUM(G7:G24)","v":0},{"$f":"SUM(H7:H24)","v":0},{"$f":"SUM(I7:I24)","v":0},0]
[]
["Total Project Cost:  ",null,null,{"$f":"'Instructions and Summary'!G24","v":0},"Cost Share Percent of Award:",{"$nulls":4},{"$f":"IFERROR(J25/D27,\"\")","v":""}]
[]
["Additional Explanations/Comments (as necessary):"]