{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["Instructions and Summary","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect","j. Cost Share","SF-424A","SF-424A Cost Categories","SF-424A Minus FFRDC"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":102,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions and Summary","index":0,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,2,1,12],[2,1,2,2],[2,3,2,12],[8,0,8,13],[40,0,41,13],[3,1,3,2],[3,3,3,12],[5,0,5,13],[6,0,6,13],[10,0,21,0]]}
[null,null,"Instructions and Summary"]
[]
["Award Number:",null,null,"Date of Submission:"]
["Award Recipient:",null,null,"Form submitted by: "]
[{"$nulls":13},"(May be award recipient or sub-recipient)"]
["Please read the instructions on each worksheet tab before starting. If you have any questions, please ask your EERE contact!                                                                                                    Do not modify this template or any cells or formulas!  "]
["1. If using this form for award application, negotiation, or budget revision, fill out the blank white cells in workbook tabs a. through j. with total project costs.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.   \n3. Enter detailed support for the project costs identified for each Category line item within each worksheet tab to autopopulate the summary tab.  \n4. The total budget presented on tabs a. through i. must include both Federal (DOE) and Non-Federal (cost share) portions.\n5. All costs incurred by the preparer's sub-recipients, contractors, and Federal Research and Development Centers (FFRDCs), should be entered only in section f. Contractual. All other sections are for the costs of the preparer only.\n6.  Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200, and the applicable cost principles for each entity type: FAR Part 31 for For-Profit entities; and 2 CFR Part 200 Subpart E - Cost Principles for all other non-federal entities.  \n7. Add rows as needed throughout tabs a. through j. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab. If your project contains more than five budget periods, consult your EERE contact before adding additional budget period rows or columns. \n8. ALL budget period cost categories are rounded to the nearest dollar.\nBURDEN DISCLOSURE STATEMENT\nPublic reporting burden for this collection of information is estimated to average 24 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, AD-241-2 - GTN, Paperwork Reduction Project (1910-5162), U.S. Department of Energy 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget, Paperwork Reduction Project (1910-5162), Washington, DC 20503."]
[]
["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"]
[null,null,"Federal","Cost Share",{"$nulls":7},"Total Costs","Cost Share %","Proposed Budget Period Dates"]
[null,"Budget Period 1",{"$f":"L12-D12","v":0},{"$f":"'j. Cost Share'!D17","v":0},{"$nulls":7},{"$f":"B39","v":0},{"$f":"IF(L12>0,D12/L12,0)","v":0},"Example!!! 01/01/2014 - 12/31/2014"]
[null,"Budget Period 2",{"$f":"L13-D13","v":0},{"$f":"'j. Cost Share'!E17","v":0},{"$nulls":7},{"$f":"C39","v":0},{"$f":"IF(L13>0,D13/L13,0)","v":0}]
[null,"Budget Period 3",{"$f":"L14-D14","v":0},{"$f":"'j. Cost Share'!F17","v":0},{"$nulls":7},{"$f":"D39","v":0},0]
[null,"Budget Period 4",0,{"$f":"'j. Cost Share'!G17","v":0},{"$nulls":7},{"$f":"E39","v":0},0]
[null,"Budget Period 5",0,{"$f":"'j. Cost Share'!H17","v":0},{"$nulls":7},{"$f":"F39","v":0},0]
[null,"Budget Period 6",0,{"$f":"'j. Cost Share'!I17","v":0},{"$nulls":7},{"$f":"G39","v":0},0]
[null,"Budget Period 7",0,{"$f":"'j. Cost Share'!J17","v":0},{"$nulls":7},{"$f":"H39","v":0},0]
[null,"Budget Period 8",0,{"$f":"'j. Cost Share'!K17","v":0},{"$nulls":7},{"$f":"I39","v":0},0]
[null,"Budget Period 9",0,{"$f":"'j. Cost Share'!L17","v":0},{"$nulls":7},{"$f":"J39","v":0},0]
[null,"Budget Period 10",0,{"$f":"'j. Cost Share'!M17","v":0},{"$nulls":7},{"$f":"K39","v":0},0]
[null,"Total",{"$f":"SUM(C12:C21)","v":0},{"$f":"SUM(D12:D21)","v":0},{"$nulls":7},{"$f":"SUM(L12:L21)","v":0},0]
["Section B - Budget Categories"]
["CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10"," Total Costs","% of Project","Comments (as needed)"]
["a. Personnel",{"$f":"'a. Personnel'!E34","v":0},{"$f":"'a. Personnel'!H34","v":0},{"$f":"'a. Personnel'!K34","v":0},{"$f":"'a. Personnel'!N34","v":0},{"$f":"'a. Personnel'!Q34","v":0},{"$f":"'a. Personnel'!T34","v":0},{"$f":"'a. Personnel'!W34","v":0},{"$f":"'a. Personnel'!Z34","v":0},{"$f":"'a. Personnel'!AC34","v":0},{"$f":"'a. Personnel'!AF34","v":0},{"$f":"SUM(B25:K25)","v":0},{"$f":"IF(L25>0,L25/L22,0)","v":0}]
["b. Fringe Benefits",{"$f":"'b. Fringe'!D13","v":0},{"$f":"'b. Fringe'!G13","v":0},{"$f":"'b. Fringe'!J13","v":0},{"$f":"'b. Fringe'!M13","v":0},{"$f":"'b. Fringe'!P13","v":0},{"$f":"'b. Fringe'!S13","v":0},{"$f":"'b. Fringe'!V13","v":0},{"$f":"'b. Fringe'!Y13","v":0},{"$f":"'b. Fringe'!AB13","v":0},{"$f":"'b. Fringe'!AE13","v":0},{"$f":"SUM(B26:K26)","v":0},{"$f":"IF(L26>0,L26/L22,0)","v":0}]
["c. Travel",{"$f":"'c. Travel'!K14","v":0},{"$f":"'c. Travel'!K22","v":0},{"$f":"'c. Travel'!K30","v":0},{"$f":"'c. Travel'!K38","v":0},{"$f":"'c. Travel'!K46","v":0},{"$f":"'c. Travel'!K54","v":0},{"$f":"'c. Travel'!K62","v":0},{"$f":"'c. Travel'!K70","v":0},{"$f":"'c. Travel'!K78","v":0},{"$f":"'c. Travel'!K86","v":0},{"$f":"SUM(B27:K27)","v":0},{"$f":"IF(L27>0,L27/L22,0)","v":0}]
["d. Equipment",{"$f":"'d. Equipment'!E14","v":0},{"$f":"'d. Equipment'!E22","v":0},{"$f":"'d. Equipment'!E30","v":0},{"$f":"'d. Equipment'!E38","v":0},{"$f":"'d. Equipment'!E46","v":0},{"$f":"'d. Equipment'!E54","v":0},{"$f":"'d. Equipment'!E62","v":0},{"$f":"'d. Equipment'!E70","v":0},{"$f":"'d. Equipment'!E78","v":0},{"$f":"'d. Equipment'!E86","v":0},{"$f":"SUM(B28:K28)","v":0},{"$f":"IF(L28>0,L28/L22,0)","v":0}]
["e. Supplies",{"$f":"'e. Supplies'!E15","v":0},{"$f":"'e. Supplies'!E25","v":0},{"$f":"'e. Supplies'!E35","v":0},{"$f":"'e. Supplies'!E45","v":0},{"$f":"'e. Supplies'!E55","v":0},{"$f":"'e. Supplies'!E65","v":0},{"$f":"'e. Supplies'!E75","v":0},{"$f":"'e. Supplies'!E85","v":0},{"$f":"'e. Supplies'!E95","v":0},{"$f":"'e. Supplies'!E105","v":0},{"$f":"SUM(B29:K29)","v":0},{"$f":"IF(L29>0,L29/L22,0)","v":0}]
["f. Contractual"]
["Sub-recipient",{"$f":"'f. Contractual'!E13","v":0},{"$f":"'f. Contractual'!F13","v":0},{"$f":"'f. Contractual'!G13","v":0},{"$f":"'f. Contractual'!H13","v":0},{"$f":"'f. Contractual'!I13","v":0},{"$f":"'f. Contractual'!J13","v":0},{"$f":"'f. Contractual'!K13","v":0},{"$f":"'f. Contractual'!L13","v":0},{"$f":"'f. Contractual'!M13","v":0},{"$f":"'f. Contractual'!N13","v":0},{"$f":"SUM(B31:K31)","v":0},{"$f":"IF(L31>0,L31/L22,0)","v":0}]
["Contractor",{"$f":"'f. Contractual'!E22","v":0},{"$f":"'f. Contractual'!F22","v":0},{"$f":"'f. Contractual'!G22","v":0},{"$f":"'f. Contractual'!H22","v":0},{"$f":"'f. Contractual'!I22","v":0},{"$f":"'f. Contractual'!J22","v":0},{"$f":"'f. Contractual'!K22","v":0},{"$f":"'f. Contractual'!L22","v":0},{"$f":"'f. Contractual'!M22","v":0},{"$f":"'f. Contractual'!N22","v":0},0,{"$f":"IF(L32>0,L32/L22,0)","v":0}]
["FFRDC",{"$f":"'f. Contractual'!E27","v":0},{"$f":"'f. Contractual'!F27","v":0},{"$f":"'f. Contractual'!G27","v":0},{"$f":"'f. Contractual'!H27","v":0},{"$f":"'f. Contractual'!I27","v":0},{"$f":"'f. Contractual'!J27","v":0},{"$f":"'f. Contractual'!K27","v":0},{"$f":"'f. Contractual'!L27","v":0},{"$f":"'f. Contractual'!M27","v":0},{"$f":"'f. Contractual'!N27","v":0},0,{"$f":"IF(L33>0,L33/L22,0)","v":0}]
["Total Contractual ",{"$f":"SUM(B31:B33)","v":0},{"$f":"SUM(C31:C33)","v":0},{"$f":"SUM(D31:D33)","v":0},{"$f":"SUM(E31:E33)","v":0},{"$f":"SUM(F31:F33)","v":0},{"$f":"SUM(G31:G33)","v":0},0,0,0,0,0,{"$f":"IF(L34>0,L34/L22,0)","v":0}]
["g. Construction",{"$f":"'g. Construction'!C15","v":0},{"$f":"'g. Construction'!C22","v":0},{"$f":"'g. Construction'!C29","v":0},{"$f":"'g. Construction'!C36","v":0},{"$f":"'g. Construction'!C43","v":0},{"$f":"'g. Construction'!C50","v":0},{"$f":"'g. Construction'!C57","v":0},{"$f":"'g. Construction'!C64","v":0},{"$f":"'g. Construction'!C71","v":0},{"$f":"'g. Construction'!C78","v":0},0,{"$f":"IF(L35>0,L35/L22,0)","v":0}]
["h. Other Direct Costs",{"$f":"'h. Other'!C14","v":0},{"$f":"'h. Other'!C22","v":0},{"$f":"'h. Other'!C30","v":0},{"$f":"'h. Other'!C38","v":0},{"$f":"'h. Other'!C46","v":0},{"$f":"'h. Other'!C54","v":0},{"$f":"'h. Other'!C62","v":0},{"$f":"'h. Other'!C70","v":0},{"$f":"'h. Other'!C78","v":0},{"$f":"'h. Other'!C86","v":0},0,{"$f":"IF(L36>0,L36/L22,0)","v":0}]
["Total Direct Costs",{"$f":"B25+B26+B27+B28+B29+B34+B35+B36","v":0},{"$f":"C25+C26+C27+C28+C29+C34+C35+C36","v":0},{"$f":"D25+D26+D27+D28+D29+D34+D35+D36","v":0},{"$f":"E25+E26+E27+E28+E29+E34+E35+E36","v":0},{"$f":"F25+F26+F27+F28+F29+F34+F35+F36","v":0},{"$f":"G25+G26+G27+G28+G29+G34+G35+G36","v":0},0,0,0,0,0,{"$f":"IF(L37>0,L37/L22,0)","v":0}]
["i. Indirect Charges",{"$f":"'i. Indirect'!B16","v":0},{"$f":"'i. Indirect'!C16","v":0},{"$f":"'i. Indirect'!D16","v":0},{"$f":"'i. Indirect'!E16","v":0},{"$f":"'i. Indirect'!F16","v":0},{"$f":"'i. Indirect'!G16","v":0},{"$f":"'i. Indirect'!H16","v":0},{"$f":"'i. Indirect'!I16","v":0},{"$f":"'i. Indirect'!J16","v":0},{"$f":"'i. Indirect'!K16","v":0},0,{"$f":"IF(L38>0,L38/L22,0)","v":0}]
["Total Costs",{"$f":"B37+B38","v":0},{"$f":"C37+C38","v":0},{"$f":"D37+D38","v":0},{"$f":"E37+E38","v":0},0,0,0,0,0,0,{"$f":"L37+L38","v":0},{"$f":"M37+M38","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"a. Personnel","index":1,"n_rows":36,"n_cols":35,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,1,34],[5,32,6,32],[0,32,0,34],[5,2,5,4],[5,5,5,7],[5,8,5,10],[0,0,0,1],[35,0,36,34],[5,1,6,1],[2,0,3,34],[34,0,34,3],[5,0,6,0],[5,34,6,34],[5,33,6,33],[5,11,5,13],[5,14,5,16],[33,0,33,1],[5,17,5,19],[5,20,5,22],[5,23,5,25],[5,26,5,28],[5,29,5,31]]}
["Detailed Budget Justification"]
["a. Personnel"]
["INSTRUCTIONS - PLEASE READ!!!\n1. List project costs solely for employees of the entity completing this form.  All personnel costs for subrecipients and contractors must be included under f. Contractual.\n2. All personnel should be identified by position title and not employee name.  Enter the amount of time (e.g., hours or % of time) and the base hourly rate and the total direct personnel compensation will automatically calculate. Rate basis (e.g., rate negotiated for each hour worked on the project, labor distribution report, state civil service rates, etc.) must also be identified.\n3. If loaded labor rates are utilized, a description of the costs the loaded rate is comprised of must be included in the Additional Explanation section below. DOE must review all components of the loaded labor rate for reasonableness and unallowable costs (e.g. fee or profit). \n4. If a position and hours are attributed to multiple employees (e.g. Technician working 4000 hours) the number of employees for that position title must be identified.  \n5.  Each budget period is rounded to the nearest dollar."]
[]
[]
["SOPO Task #","Position Title","Budget Period 1",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Budget Period 4",null,null,"Budget Period 5",null,null,"Budget Period 6",null,null,"Budget Period 7",null,null,"Budget Period 8",null,null,"Budget Period 9",null,null,"Budget Period 10",null,null,"Project Total Hours","Project Total Dollars","Rate Basis"]
[null,null,"Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 1","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 2","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 3","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 4","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5"]
[1,"Sr. Engineer (EXAMPLE!!!)",2000,85,{"$f":"C8*D8","v":170000},200,50,{"$f":"F8*G8","v":10000},200,50,{"$f":"I8*J8","v":10000},200,50,{"$f":"L8*M8","v":10000},200,50,{"$f":"O8*P8","v":10000},200,50,{"$f":"R8*S8","v":10000},200,50,{"$f":"U8*V8","v":10000},200,50,{"$f":"X8*Y8","v":10000},200,50,{"$f":"AA8*AB8","v":10000},200,50,{"$f":"AD8*AE8","v":10000},{"$f":"C8+F8+I8","v":2400},{"$f":"E8+H8+K8","v":190000}]
[2,"Technicians (2)",4000,20,80000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"C9+F9+I9","v":4000},{"$f":"E9+H9+K9","v":80000}]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(C10+F10+I10+L10+O10+R10+U10+X10+AA10+AD10)","v":0},{"$f":"SUM(E10+H10+K10+N10+Q10+T10+W10+Z10+AC10+AF10)","v":0}]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,{"$f":"O25*P25","v":0},null,null,{"$f":"R25*S25","v":0},null,null,{"$f":"U25*V25","v":0},null,null,{"$f":"X25*Y25","v":0},null,null,{"$f":"AA25*AB25","v":0},null,null,{"$f":"AD25*AE25","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"O26*P26","v":0},null,null,{"$f":"R26*S26","v":0},null,null,{"$f":"U26*V26","v":0},null,null,{"$f":"X26*Y26","v":0},null,null,{"$f":"AA26*AB26","v":0},null,null,{"$f":"AD26*AE26","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"R27*S27","v":0},null,null,{"$f":"U27*V27","v":0},null,null,{"$f":"X27*Y27","v":0},null,null,{"$f":"AA27*AB27","v":0},null,null,{"$f":"AD27*AE27","v":0},0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,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,null,null,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,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},{"$f":"C31*D31","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},{"$f":"C32*D32","v":0},null,null,{"$f":"F32*G32","v":0},null,null,{"$f":"I32*J32","v":0},null,null,{"$f":"L32*M32","v":0},null,null,{"$f":"O32*P32","v":0},null,null,{"$f":"R32*S32","v":0},null,null,{"$f":"U32*V32","v":0},null,null,{"$f":"X32*Y32","v":0},null,null,{"$f":"AA32*AB32","v":0},null,null,{"$f":"AD32*AE32","v":0},0,0]
[{"$nulls":4},{"$f":"C33*D33","v":0},null,null,{"$f":"F33*G33","v":0},null,null,{"$f":"I33*J33","v":0},null,null,{"$f":"L33*M33","v":0},null,null,{"$f":"O33*P33","v":0},null,null,{"$f":"R33*S33","v":0},null,null,{"$f":"U33*V33","v":0},null,null,{"$f":"X33*Y33","v":0},null,null,{"$f":"AA33*AB33","v":0},null,null,{"$f":"AD33*AE33","v":0},0,0]
["TOTAL PERSONNEL",null,{"$f":"SUM(C10:C33)","v":0},null,{"$f":"SUM(E10:E33)","v":0},{"$f":"SUM(F10:F33)","v":0},null,{"$f":"SUM(H10:H33)","v":0},{"$f":"SUM(I10:I33)","v":0},null,{"$f":"SUM(K10:K33)","v":0},{"$f":"SUM(L10:L33)","v":0},null,{"$f":"SUM(N10:N33)","v":0},{"$f":"SUM(O10:O33)","v":0},null,{"$f":"SUM(Q10:Q33)","v":0},{"$f":"SUM(R10:R33)","v":0},null,{"$f":"SUM(T10:T33)","v":0},{"$f":"SUM(U10:U33)","v":0},null,{"$f":"SUM(W10:W33)","v":0},{"$f":"SUM(X10:X33)","v":0},null,{"$f":"SUM(Z10:Z33)","v":0},{"$f":"SUM(AA10:AA33)","v":0},null,{"$f":"SUM(AC10:AC33)","v":0},{"$f":"SUM(AD10:AD33)","v":0},null,{"$f":"SUM(AF10:AF33)","v":0},0,{"$f":"E34+H34+K34+N34+Q34+T34+W34+Z34+AC34+AF34","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"b. Fringe","index":2,"n_rows":21,"n_cols":32,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,25,4,27],[4,28,4,30],[0,0,0,9],[1,0,1,31],[19,0,19,31],[20,0,20,31],[2,0,2,31],[15,0,18,31],[14,0,14,31],[4,4,4,6],[4,7,4,9],[4,1,4,3],[4,10,4,12],[4,13,4,15],[4,16,4,18],[4,19,4,21],[4,22,4,24]]}
["Detailed Budget Justification "]
["b. Fringe Benefits"]
["INSTRUCTIONS - PLEASE READ!!!\n1. Fill out the table below by position title. If all employees receive the same fringe benefits, you can show \"Total Personnel\" in the Labor Type column instead of listing out all position titles.   \n2. The rates and how they are applied should not be averaged to get one fringe cost percentage. Complex calculations should be described/provided in the Additional Explanation section below. \n3. The fringe benefit rates should be applied to all positions, regardless of whether those funds will be supported by Federal Share or Recipient Cost Share.\n4.  Each budget period is rounded to the nearest dollar."]
[]
["Labor Type","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,"Budget Period 6",null,null,"Budget Period 7",null,null,"Budget Period 8",null,null,"Budget Period 9",null,null,"Budget Period 10",null,null,"Total Project "]
[null,"Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total"]
["EXAMPLE!!! Sr. Engineer",170000,0.2,{"$f":"B7*C7","v":34000},10000,0.2,{"$f":"E7*F7","v":2000},10000,0.2,{"$f":"H7*I7","v":2000},10000,0.2,{"$f":"K7*L7","v":2000},10000,0.2,{"$f":"N7*O7","v":2000},10000,0.2,{"$f":"Q7*R7","v":2000},10000,0.2,{"$f":"T7*U7","v":2000},10000,0.2,{"$f":"W7*X7","v":2000},10000,0.2,{"$f":"Z7*AA7","v":2000},10000,0.2,{"$f":"AC7*AD7","v":2000},{"$f":"D7+G7+J7","v":38000}]
[null,null,null,{"$f":"C8*B8","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(D8+G8+J8+M8+P8+S8+V8+Y8+AB8+AE8)","v":0}]
[null,null,null,{"$f":"C9*B9","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(D9+G9+J9+M9+P9+S9+V9+Y9+AB9+AE9)","v":0}]
[null,null,null,{"$f":"C10*B10","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,{"$f":"C11*B11","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,{"$f":"C12*B12","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,0]
["TOTAL FRINGE",{"$f":"SUM(B8:B12)","v":0},null,{"$f":"SUM(D8:D12)","v":0},{"$f":"SUM(E8:E12)","v":0},null,{"$f":"SUM(G8:G12)","v":0},{"$f":"SUM(H8:H12)","v":0},null,{"$f":"SUM(J8:J12)","v":0},{"$f":"SUM(K8:K12)","v":0},null,{"$f":"SUM(M8:M12)","v":0},{"$f":"SUM(N8:N12)","v":0},null,{"$f":"SUM(P8:P12)","v":0},{"$f":"SUM(Q8:Q12)","v":0},null,{"$f":"SUM(S8:S12)","v":0},{"$f":"SUM(T8:T12)","v":0},null,{"$f":"SUM(V8:V12)","v":0},{"$f":"SUM(W8:W12)","v":0},null,{"$f":"SUM(Y8:Y12)","v":0},{"$f":"SUM(Z8:Z12)","v":0},null,{"$f":"SUM(AB8:AB12)","v":0},{"$f":"SUM(AC8:AC12)","v":0},null,{"$f":"SUM(AE8:AE12)","v":0},0]
[]
["A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by DOE for estimating purposes is required at the time of award negotiation if reimbursement for fringe benefits is requested.  Please check (X) one of the options below and provide the requested information if not previously submitted."]
["______ A fringe benefit rate has been negotiated with, or approved by, a federal government agency. A copy of the latest rate agreement is/was included with the project application.*\n\n______ There is not a current federally approved rate agreement negotiated and available.**\n\n*Unless the organization has submitted an indirect rate proposal which encompasses the fringe pool of costs, please provide the organization’s benefit package and/or a list of the components/elements that comprise the fringe pool and the cost or percentage of each component/element allocated to the labor costs identified in the Budget Justification.\n\n**When this option is checked, the entity preparing this form shall submit an indirect rate proposal in the format provided in the Sample Rate Proposal at https://www.energy.gov/eere/funding/downloads/sample-indirect-rate-proposal-and-profit-compliance-audit, or a format that provides the same level of information and which will support the rates being proposed for use in the performance of the proposed project. "]
[]
[]
[]
[]
["Additional Explanation (as necessary): Please use this box (or an attachment) to list the elements that comprise your fringe benefits and how they are applied to your base (e.g. Personnel) to arrive at your fringe benefit rate."]

{"sheet":"c. Travel","index":3,"n_rows":91,"n_cols":12,"rows_kept":91,"cut":false,"hidden":false,"merged":[[2,0,2,11],[90,0,91,11],[1,0,1,11],[0,0,0,1],[5,2,5,11],[14,2,14,11],[22,2,22,11],[30,2,30,11],[38,2,38,11],[88,0,88,1],[45,0,45,1],[37,0,37,1],[29,0,29,1],[21,0,21,1],[13,0,13,1],[46,2,46,11],[70,2,70,11],[77,0,77,1],[78,2,78,11],[85,0,85,1],[53,0,53,1],[54,2,54,11],[61,0,61,1],[62,2,62,11],[69,0,69,1]]}
["Detailed Budget Justification "]
["c. Travel"]
["INSTRUCTIONS - PLEASE READ!!!\n1.  Identify Foreign and Domestic Travel as separate items. Examples of Purpose of Travel are subrecipient site visits, DOE meetings, project mgmt. meetings, etc. Examples of Basis for Estimating Costs are past trips, travel quotes, GSA rates, etc.   \n2.  All listed travel must be necessary for performance of the Statement of Project Objectives.                                                                                                                                                                                                                                                                 \n3. Only travel that is directly associated with this award should be included as a direct travel cost to the award.                                                                                                                                                                                                                                                                                                                                                                                4. Federal travel regulations are contained within the applicable cost principles for all entity types.                                                                                                                                                                                                                                                                                             5. Travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organizations written travel policy. In absence of a written travel policy, organizations must follow the regulations prescribed by the General Services Administration. \n6. Columns G, H, I, J, and K are total per trip per the total number of travelers.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     7. The number of days is inclusive of day of departure and day of return.                                                                                                                                                                                                                                                                                               8. Recipients should enter City and State (or City and Country for International travel) in the Depart from and Destination fields.                                                                                                                                                                                              9. Each budget period is rounded to the nearest dollar."]
[]
["SOPO Task #","Purpose of Travel","Depart From","Destination","No. of Days","No. of Travelers","Lodging per Traveler","Flight per Traveler","Vehicle per Traveler","Per Diem Per Traveler","Cost per Trip","Basis for Estimating Costs"]
[null,"Domestic Travel","                                                             Budget Period 1"]
[1,"EXAMPLE!!!  Visit to PV manufacturer",null,null,2,2,250,500,100,80,{"$f":"SUM(G7:J7)*F7","v":1860},"Current GSA rates"]
[{"$nulls":10},{"$f":"SUM(G8:J8)*F8","v":0}]
[{"$nulls":10},{"$f":"SUM(G9:J9)*F9","v":0}]
[{"$nulls":10},{"$f":"SUM(G10:J10)*F10","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G13:J13)*F13","v":0}]
["Budget Period 1 Total",{"$nulls":9},{"$f":"SUM(K8:K13)","v":0}]
[null,"Domestic Travel","                                                             Budget Period 2"]
[{"$nulls":10},{"$f":"SUM(G16:J16)*F16","v":0}]
[{"$nulls":10},{"$f":"SUM(G17:J17)*F17","v":0}]
[{"$nulls":10},{"$f":"SUM(G18:J18)*F18","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G21:J21)*F21","v":0}]
["Budget Period 2 Total",{"$nulls":9},{"$f":"SUM(K16:K21)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 3"]
[{"$nulls":10},{"$f":"SUM(G24:J24)*F24","v":0}]
[{"$nulls":10},{"$f":"SUM(G25:J25)*F25","v":0}]
[{"$nulls":10},{"$f":"SUM(G26:J26)*F26","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G29:J29)*F29","v":0}]
["Budget Period 3 Total",{"$nulls":9},{"$f":"SUM(K24:K29)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 4"]
[{"$nulls":10},{"$f":"SUM(G32:J32)*F32","v":0}]
[{"$nulls":10},{"$f":"SUM(G33:J33)*F33","v":0}]
[{"$nulls":10},{"$f":"SUM(G34:J34)*F34","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G37:J37)*F37","v":0}]
["Budget Period 4 Total",{"$nulls":9},{"$f":"SUM(K32:K37)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 5"]
[{"$nulls":10},{"$f":"SUM(G40:J40)*F40","v":0}]
[{"$nulls":10},{"$f":"SUM(G41:J41)*F41","v":0}]
[{"$nulls":10},{"$f":"SUM(G42:J42)*F42","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G45:J45)*F45","v":0}]
["Budget Period 5 Total",{"$nulls":9},{"$f":"SUM(K40:K45)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 6"]
[{"$nulls":10},{"$f":"SUM(G48:J48)*F48","v":0}]
[{"$nulls":10},{"$f":"SUM(G49:J49)*F49","v":0}]
[{"$nulls":10},{"$f":"SUM(G50:J50)*F50","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G53:J53)*F53","v":0}]
["Budget Period 6 Total",{"$nulls":9},{"$f":"SUM(K48:K53)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 7"]
[{"$nulls":10},{"$f":"SUM(G56:J56)*F56","v":0}]
[{"$nulls":10},{"$f":"SUM(G57:J57)*F57","v":0}]
[{"$nulls":10},{"$f":"SUM(G58:J58)*F58","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G61:J61)*F61","v":0}]
["Budget Period 7 Total",{"$nulls":9},{"$f":"SUM(K56:K61)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 8"]
[{"$nulls":10},{"$f":"SUM(G64:J64)*F64","v":0}]
[{"$nulls":10},{"$f":"SUM(G65:J65)*F65","v":0}]
[{"$nulls":10},{"$f":"SUM(G66:J66)*F66","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G69:J69)*F69","v":0}]
["Budget Period 8 Total",{"$nulls":9},{"$f":"SUM(K64:K69)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 9"]
[{"$nulls":10},{"$f":"SUM(G72:J72)*F72","v":0}]
[{"$nulls":10},{"$f":"SUM(G73:J73)*F73","v":0}]
[{"$nulls":10},{"$f":"SUM(G74:J74)*F74","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G77:J77)*F77","v":0}]
["Budget Period 9 Total",{"$nulls":9},{"$f":"SUM(K72:K77)","v":0}]
[null,"Domestic Travel","                                                              Budget Period 10"]
[null,"peer review",{"$nulls":8},{"$f":"SUM(G80:J80)*F80","v":0}]
[{"$nulls":10},{"$f":"SUM(G81:J81)*F81","v":0}]
[{"$nulls":10},{"$f":"SUM(G82:J82)*F82","v":0}]
[{"$nulls":10},0]
[null,"International Travel"]
[{"$nulls":10},{"$f":"SUM(G85:J85)*F85","v":0}]
["Budget Period 10 Total",{"$nulls":9},{"$f":"SUM(K80:K85)","v":0}]
[]
[]
["TOTAL TRAVEL",{"$nulls":9},{"$f":"K14+K22+K30+K38+K46+K54+K62+K70+K78+K86","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"d. Equipment","index":4,"n_rows":90,"n_cols":7,"rows_kept":90,"cut":false,"hidden":false,"merged":[[1,0,1,6],[0,0,0,1],[2,0,2,6],[89,0,90,6],[22,0,22,6],[14,0,14,6],[5,0,5,6],[30,0,30,6],[38,0,38,6],[87,0,87,1],[37,0,37,1],[45,0,45,1],[21,0,21,1],[13,0,13,1],[29,0,29,1],[46,0,46,6],[70,0,70,6],[77,0,77,1],[78,0,78,6],[85,0,85,1],[53,0,53,1],[54,0,54,6],[61,0,61,1],[62,0,62,6],[69,0,69,1]]}
["Detailed Budget Justification"]
["d. Equipment"]
["INSTRUCTIONS - PLEASE READ!!!\n1. 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. Please refer to the applicable Federal regulations in 2 CFR 200 for specific equipment definitions and treatment. \n2. List all equipment below, providing a basis of cost (e.g. contractor quotes, catalog prices, prior invoices, etc.). Briefly justify items as they apply to the Statement of Project Objectives. If it is existing equipment, provide logical support for the estimated value shown. \n3. During award negotiations, provide a contractor quote for all equipment items over $50,000 in price. If the contractor quote is not an exact price match, provide an explanation in the additional explanation section below. If a contractor quote is not practical, such as for a piece of equipment that is purpose-built, first of its kind, or otherwise not available off the shelf, provide a detailed engineering estimate for how the cost estimate was derived.\n4.  Each budget period is rounded to the nearest dollar."]
[]
["SOPO Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["3,4,5","EXAMPLE!!!   Thermal shock chamber",2,70000,{"$f":"C7*D7","v":140000},"Contractor Quote - Attached","Reliability testing of PV modules- Task 4.3"]
[{"$nulls":4},{"$f":"C8*D8","v":0}]
[{"$nulls":4},{"$f":"C9*D9","v":0}]
[{"$nulls":4},{"$f":"C10*D10","v":0}]
[{"$nulls":4},{"$f":"C11*D11","v":0}]
[{"$nulls":4},{"$f":"C12*D12","v":0}]
[{"$nulls":4},{"$f":"C13*D13","v":0}]
["Budget Period 1 Total",null,null,null,{"$f":"SUM(E8:E13)","v":0}]
["Budget Period 2"]
[{"$nulls":4},{"$f":"C16*D16","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 2 Total",null,null,null,{"$f":"SUM(E16:E21)","v":0}]
["Budget Period 3"]
[{"$nulls":4},{"$f":"C24*D24","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 3 Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Budget Period 4"]
[{"$nulls":4},{"$f":"C32*D32","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 4 Total",null,null,null,{"$f":"SUM(E32:E37)","v":0}]
["Budget Period 5"]
[{"$nulls":4},{"$f":"C40*D40","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 5 Total",null,null,null,{"$f":"SUM(E40:E45)","v":0}]
["Budget Period 6"]
[{"$nulls":4},{"$f":"C48*D48","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 6 Total",null,null,null,{"$f":"SUM(E48:E53)","v":0}]
["Budget Period 7"]
[{"$nulls":4},{"$f":"C56*D56","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 7 Total",null,null,null,{"$f":"SUM(E56:E61)","v":0}]
["Budget Period 8"]
[{"$nulls":4},{"$f":"C64*D64","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 8 Total",null,null,null,{"$f":"SUM(E64:E69)","v":0}]
["Budget Period 9"]
[{"$nulls":4},{"$f":"C72*D72","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 9 Total",null,null,null,{"$f":"SUM(E72:E77)","v":0}]
["Budget Period 10"]
[{"$nulls":4},{"$f":"C80*D80","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 10 Total",null,null,null,{"$f":"SUM(E80:E85)","v":0}]
[]
["TOTAL EQUIPMENT",null,null,null,{"$f":"E14+E22+E30+E38+E46+E54+E62+E70+E78+E86","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"e. Supplies","index":5,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,6],[108,0,109,6],[5,0,5,6],[1,0,1,6],[15,0,15,6],[25,0,25,6],[35,0,35,6],[45,0,45,6],[106,0,106,1],[54,0,54,1],[44,0,44,1],[34,0,34,1],[24,0,24,1],[14,0,14,1],[55,0,55,6],[85,0,85,6],[94,0,94,1],[95,0,95,6],[104,0,104,1],[64,0,64,1],[65,0,65,6],[74,0,74,1],[75,0,75,6],[84,0,84,1]]}
["Detailed Budget Justification "]
["e. Supplies"]
["INSTRUCTIONS - PLEASE READ!!!\n1. 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. Please refer to the applicable Federal regulations in 2 CFR 200 for specific supplies definitions and treatment. \n2. List all proposed supplies below, providing a basis of costs (e.g. contractor quotes, catalog prices, prior invoices, etc.). Briefly justify the need for the Supplies as they apply to the Statement of Project Objectives. Note that Supply items must be direct costs to the project at this budget category, and not duplicative of supply costs included in the indirect pool that is the basis of the indirect rate applied for this project.\n3. Multiple supply items valued at $5,000 or less used to assemble an equipment item with a value greater than $5,000 with a useful life of more than one year should be included on the equipment tab. If supply items and costs are ambiguous in nature, contact your DOE representative for proper categorization.  \n4. Add rows as needed. If rows are added, formulas/calculations may need to be adjusted by the preparer. \n5.  Each budget period is rounded to the nearest dollar."]
[]
["SOPO Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["4,6","EXAMPLE!!!  Wireless DAS components",10,360,3600,"Catalog price","For Alpha prototype - Task 2.4"]
[{"$nulls":4},{"$f":"C8*D8","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 1 Total",null,null,null,{"$f":"SUM(E8:E14)","v":0}]
["Budget Period 2"]
[{"$nulls":4},{"$f":"C17*D17","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 2 Total",null,null,null,{"$f":"SUM(E17:E24)","v":0}]
["Budget Period 3"]
[{"$nulls":4},{"$f":"C27*D27","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 3 Total",null,null,null,{"$f":"SUM(E27:E34)","v":0}]
["Budget Period 4"]
[{"$nulls":4},{"$f":"C37*D37","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 4 Total",null,null,null,{"$f":"SUM(E37:E44)","v":0}]
["Budget Period 5"]
[{"$nulls":4},{"$f":"C47*D47","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 5 Total",null,null,null,{"$f":"SUM(E47:E54)","v":0}]
["Budget Period 6"]
[{"$nulls":4},{"$f":"C57*D57","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 6 Total",null,null,null,{"$f":"SUM(E57:E64)","v":0}]
["Budget Period 7"]
[{"$nulls":4},{"$f":"C67*D67","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 7 Total",null,null,null,{"$f":"SUM(E67:E74)","v":0}]
["Budget Period 8"]
[{"$nulls":4},{"$f":"C77*D77","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 8 Total",null,null,null,{"$f":"SUM(E77:E84)","v":0}]
["Budget Period 9"]
[{"$nulls":4},{"$f":"C87*D87","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 9 Total",null,null,null,{"$f":"SUM(E87:E94)","v":0}]
["Budget Period 10"]
[{"$nulls":4},{"$f":"C97*D97","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Budget Period 10 Total",null,null,null,{"$f":"SUM(E97:E104)","v":0}]
[]
["TOTAL SUPPLIES",null,null,null,{"$f":"E35+E25+E15+E45+E55+E65+E75+E85+E95+E105","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"f. Contractual","index":6,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,1,18,2],[19,1,19,2],[20,1,20,2],[0,5,0,14],[0,0,0,1],[1,0,1,14],[2,0,2,14],[30,0,31,14],[28,0,28,3],[21,0,21,3],[12,0,12,3],[26,0,26,3],[23,1,23,2],[24,1,24,2],[25,1,25,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
["Detailed Budget Justification "]
["f. Contractual"]
["INSTRUCTIONS - PLEASE READ!!!\n1. The entity completing this form must provide all costs related to sub-recipients, contractors, and FFRDC partners in the applicable boxes below.  \n2. Sub-recipients (partners, sub-awardees): Subrecipients shall submit a Budget Justification describing all project costs and calculations when their total proposed budget exceeds either (1) $250,000 or (2) 25% of total award costs. These sub-recipient forms may be completed by either the sub-recipients themselves or by the preparer of this form.  The budget totals on the sub-recipient's forms must match the sub-recipient entries below. A subrecipient is a legal entity to which a subaward is made, who has performance measured against whether the objectives of the Federal program are met, is responsible for programmatic decision making, must adhere to applicable Federal program compliance requirements, and uses the Federal funds to carry out a program of the organization. All characteristics may not be present and judgment must be used to determine subrecipient vs. vendor status. \n3. Contractors (including contractors): List all contractors supplying commercial supplies or services used to support the project. For each Contractor cost with total project costs of $250,000 or more, a Contractor quote must be provided. A contractor is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to many different purchasers, operates in a competitive environment, provides goods or services that are ancillary to the operation of the Federal program, and is not subject to compliance requirements of the Federal program. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status. \n4. Federal Funded Research and Development Centers (FFRDCs): FFRDCs must submit a signed Field Work Proposal during award application. The award recipient may allow the FFRDC to provide this information directly to DOE, however project costs must also be provided below.\n5.  Each budget period is rounded to the nearest dollar."]
[]
["SOPO Task #","Sub-Recipient\nName/Organization","Sub-Recipient Unique Entity Identifier (UEI)","Purpose and Basis of Cost","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10","Project Total"]
["2,4","EXAMPLE!!!  XYZ Corp.",null,"Partner to develop optimal lens for Gen 2 product. Cost estimate based on personnel hours.",48000,32000,16000,{"$nulls":7},{"$f":"SUM(E6:G6)","v":96000}]
[{"$nulls":14},{"$f":"SUM(E7:N7)","v":0}]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
["Sub-total",null,null,null,{"$f":"SUM(E7:E12)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["SOPO Task #","Contractor \nName/Organization",null,"Purpose and Basis of Cost","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10","Project Total"]
[6,"EXAMPLE!!!  ABC Corp.",null,"Contractor for developing robotics to perform lens inspection. Estimate provided by contractor.",32900,86500,{"$nulls":8},{"$f":"SUM(E16:G16)","v":119400}]
[{"$nulls":14},{"$f":"SUM(E17:N17)","v":0}]
[{"$nulls":14},{"$f":"SUM(E18:N18)","v":0}]
[{"$nulls":14},{"$f":"SUM(E19:N19)","v":0}]
[{"$nulls":14},{"$f":"SUM(E20:N20)","v":0}]
[{"$nulls":14},{"$f":"SUM(E21:N21)","v":0}]
["Sub-total",null,null,null,{"$f":"SUM(E17:E21)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["SOPO Task #","FFRDC\nName/Organization",null,"Purpose and Basis of Cost","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10","Project Total"]
[{"$nulls":14},{"$f":"SUM(E25:N25)","v":0}]
[{"$nulls":14},{"$f":"SUM(E26:N26)","v":0}]
["Sub-total",null,null,null,{"$f":"SUM(E25:E26)","v":0},{"$f":"SUM(F25:F26)","v":0},{"$f":"SUM(G25:G26)","v":0},{"$f":"SUM(H25:H26)","v":0},{"$f":"SUM(I25:I26)","v":0},0,0,0,0,0,{"$f":"SUM(E27:N27)","v":0}]
[]
["TOTAL CONTRACTUAL",null,null,null,{"$f":"E13+E22+E27","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Additional Explanation (as needed):"]

{"sheet":"g. Construction","index":7,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,4],[2,0,2,4],[4,0,4,4],[81,0,82,4],[7,0,7,4],[15,0,15,4],[36,0,36,4],[22,0,22,4],[29,0,29,4],[79,0,79,1],[42,0,42,1],[35,0,35,1],[28,0,28,1],[21,0,21,1],[14,0,14,1],[43,0,43,4],[49,0,49,1],[50,0,50,4],[56,0,56,1],[57,0,57,4],[63,0,63,1],[64,0,64,4],[70,0,70,1],[71,0,71,4],[77,0,77,1]]}
["Detailed Budget Justification"]
["g. Construction"]
["PLEASE READ!!!\n1. Construction, for the purpose of budgeting, is defined as all types of work done on a particular building, including erecting, altering, or remodeling. Construction conducted by the award recipient is entered on this page. Any construction work that is performed by a contractor or subrecipient should be entered under f. Contractual.\n2. List all proposed construction below, providing a basis of cost such as engineering estimates, prior construction, etc., and briefly justify its need as it applies to the Statement of Project Objectives.\n3.  Each budget period is rounded to the nearest dollar."]
[]
["Overall description of construction activities: Example Only!!! - Build wind turbine platform"]
[]
["SOPO Task #","General Description","Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
[3,"EXAMPLE ONLY!!! Three days of excavation for platform site",28000,"Engineering estimate","Site must be prepared for construction of platform."]
[]
[]
[]
[]
[]
["Budget Period 1 Total",null,{"$f":"SUM(C10:C14)","v":0}]
["Budget Period 2"]
[]
[]
[]
[]
[]
["Budget Period 2 Total",null,{"$f":"SUM(C17:C21)","v":0}]
["Budget Period 3"]
[]
[]
[]
[]
[]
["Budget Period 3 Total",null,{"$f":"SUM(C24:C28)","v":0}]
["Budget Period 4"]
[]
[]
[]
[]
[]
["Budget Period 4 Total",null,{"$f":"SUM(C31:C35)","v":0}]
["Budget Period 5"]
[]
[]
[]
[]
[]
["Budget Period 5 Total",null,{"$f":"SUM(C38:C42)","v":0}]
["Budget Period 6"]
[]
[]
[]
[]
[]
["Budget Period 6 Total",null,{"$f":"SUM(C45:C49)","v":0}]
["Budget Period 7"]
[]
[]
[]
[]
[]
["Budget Period 7 Total",null,{"$f":"SUM(C52:C56)","v":0}]
["Budget Period 8"]
[]
[]
[]
[]
[]
["Budget Period 8 Total",null,{"$f":"SUM(C59:C63)","v":0}]
["Budget Period 9"]
[]
[]
[]
[]
[]
["Budget Period 9 Total",null,{"$f":"SUM(C66:C70)","v":0}]
["Budget Period 10"]
[]
[]
[]
[]
[]
["Budget Period 10 Total",null,{"$f":"SUM(C73:C77)","v":0}]
[]
["TOTAL CONSTRUCTION",null,{"$f":"(C15+C22+C29+C36+C43+C50+C57+C64+C71+C78)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"h. Other","index":8,"n_rows":90,"n_cols":5,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,4],[89,0,90,4],[2,0,2,4],[5,0,5,4],[22,1,22,4],[14,1,14,4],[30,1,30,4],[38,1,38,4],[87,0,87,1],[45,0,45,1],[37,0,37,1],[29,0,29,1],[21,0,21,1],[13,0,13,1],[46,0,46,4],[70,1,70,4],[77,0,77,1],[78,1,78,4],[85,0,85,1],[53,0,53,1],[54,1,54,4],[61,0,61,1],[62,1,62,4],[69,0,69,1]]}
["Detailed Budget Justification"]
["h. Other Direct Costs"]
["INSTRUCTIONS - PLEASE READ!!!\n1. Other direct costs are direct cost items required for the project which do not fit clearly into other categories.  These direct costs must not be included in the indirect costs (for which the indirect rate is being applied for this project).  Examples are: tuition, printing costs, etc. which can be directly charged to the project and are not duplicated in indirect costs (overhead costs).\n2. Basis of cost are items such as vendor quotes, prior purchases of similar or like items, published price list, etc.\n3.  Each budget period is rounded to the nearest dollar."]
[]
["SOPO Task #","General Description and SOPO Task #"," Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
[5,"EXAMPLE!!!  Grad student tuition - tasks 1-3",16000,"Established UCD costs","Support of graduate students working on project "]
[]
[]
[]
[]
[]
[]
["Budget Period 1 Total",null,{"$f":"SUM(C8:C13)","v":0}]
[null,"Budget Period 2"]
[]
[]
[]
[]
[]
[]
["Budget Period 2 Total",null,{"$f":"SUM(C16:C21)","v":0}]
[null,"Budget Period 3"]
[]
[]
[]
[]
[]
[]
["Budget Period 3 Total",null,{"$f":"SUM(C24:C29)","v":0}]
[null,"Budget Period 4"]
[]
[]
[]
[]
[]
[]
["Budget Period 4 Total",null,{"$f":"SUM(C32:C37)","v":0}]
[null,"Budget Period 5"]
[]
[]
[]
[]
[]
[]
["Budget Period 5 Total",null,{"$f":"SUM(C40:C45)","v":0}]
["Budget Period 6"]
[]
[]
[]
[]
[]
[]
["Budget Period 6 Total",null,{"$f":"SUM(C48:C53)","v":0}]
[null,"Budget Period 7"]
[]
[]
[]
[]
[]
[]
["Budget Period 7 Total",null,{"$f":"SUM(C56:C61)","v":0}]
[null,"Budget Period 8"]
[]
[]
[]
[]
[]
[]
["Budget Period 8 Total",null,{"$f":"SUM(C64:C69)","v":0}]
[null,"Budget Period 9"]
[]
[]
[]
[]
[]
[]
["Budget Period 9 Total",null,{"$f":"SUM(C72:C77)","v":0}]
[null,"Budget Period 10"]
[]
[]
[]
[]
[]
[]
["Budget Period 10 Total",null,{"$f":"SUM(C80:C85)","v":0}]
[]
["TOTAL OTHER DIRECT COSTS",null,{"$f":"C30+C22+C14+C38+C46+C54+C62+C70+C78+C86","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"i. Indirect","index":9,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,13],[2,0,2,13],[4,12,4,13],[5,12,5,13],[0,12,0,13],[22,0,24,13],[0,0,0,3],[7,12,7,13],[8,12,8,13],[9,12,9,13],[11,12,11,13],[10,12,10,13],[20,0,20,13],[17,0,17,13],[12,12,12,13],[6,12,6,13],[18,0,18,13],[15,12,15,13],[13,12,13,13],[14,12,14,13]]}
["Detailed Budget Justification "]
["i. Indirect Costs"]
["INSTRUCTIONS - PLEASE READ!!!\n1. Fill out the table below to indicate how your indirect costs are calculated. Use the box below to provide additional explanation regarding your indirect rate calculation.  \n2. The rates and how they are applied should not be averaged to get one indirect cost percentage. Complex calculations or rates that do not do not correspond to the below categories should be described/provided in the Additional Explanation section below. If questions exist, consult with your DOE contact before filling out this section. \n3. The indirect rate should be applied to both the Federal Share and Recipient Cost Share.                                                                                                                                                                                     \n4. NOTE: A Recipient who elects to employ the 10% de minimis Indirect Cost rate cannot claim resulting costs as a Cost Share contribution, nor can the Recipient claim \"unrecovered indirect costs\" as a Cost Share contribution. Neither of these costs can be reflected as actual indirect cost rates realized by the organization, and therefore are not verifiable in the Recipient records as required by Federal Regulation (§200.306(b)(1)).\n5. Each budget period is rounded to the nearest dollar."]
[]
[null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10","Total","Explanation of BASE "]
["Provide ONLY Applicable Rates:"]
["Overhead Rate",0,0,0,0,0,0,0,0,0,0,null,"Example: Labor + Fringe"]
["General & Administrative (G&A)",0,0,0,0,0,0,0,0,0,0,null,"Example: Total Cost Input"]
["FCCM Rate, if applicable",0,0,0,0,0,0,0,0,0,0]
["OTHER Indirect Rate",0,0,0,0,0,0,0,0,0,0]
["Indirect Costs (As Applicable):"]
["Overhead Costs",{"$nulls":10},{"$f":"SUM(B12:K12)","v":0}]
["G&A Costs",{"$nulls":10},{"$f":"SUM(B13:K13)","v":0}]
["FCCM Costs, if applicable",{"$nulls":10},{"$f":"SUM(B14:K14)","v":0}]
[" OTHER Indirect Costs",{"$nulls":10},{"$f":"SUM(B15:K15)","v":0}]
["Total Indirect Costs Requested:",{"$f":"SUM(B12:B15)","v":0},{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0},{"$f":"SUM(F12:F15)","v":0},0,0,0,0,0,{"$f":"SUM(B16:K16)","v":0}]
[]
["A federally approved indirect rate agreement, or rate proposed (supported and agreed upon by DOE for estimating purposes) is required if reimbursement of indirect costs is requested.  Please check (X) one of the options below and provide the requested information if it has not already been provided as requested, or has changed.  "]
["______ An indirect rate has been approved or negotiated with a federal government agency. A copy of the latest rate agreement is included with this application and will be provided electronically to the Contracting Officer for this project.\n______ The organization does not have a current, federally approved indirect cost rate agreement and has provided an indirect rate proposal in support of the proposed costs.\n______ This organization has elected to apply a 10% de minimis rate in accordance with 2 CFR 200.414(f)."]
[]
["Provide an explanation of how your indirect cost rate was applied."]
[]
["Additional Explanation (as needed): *IMPORTANT:  Please use this box (or an attachment) to further explain how your total indirect costs were calculated.  If the total indirect costs are a cumulative amount of more than one calculation or rate application, the explanation and calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with grand total).  "]

{"sheet":"j. Cost Share","index":10,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,23,13],[1,0,1,13],[0,0,0,2],[2,0,2,13],[19,4,19,5],[20,10,20,12],[20,6,20,7],[0,4,0,13],[16,0,16,2]]}
["Detailed Budget Justification"]
["Cost Share"]
["PLEASE READ!!!\n1. A detailed presentation of the cash or cash value of all cost share proposed must be provided in the table below. All items in the chart below must be identified within the applicable cost category tabs a. through i. in addition to the detailed presentation of the cash or cash value of all cost share proposed provided in the table below. Identify the source organization & amount of each cost share item proposed in the award. \n2. Cash Cost Share - encompasses all contributions to the project made by the recipient, subrecipient, or third party (an entity that does not have a role in performing the scope of work) for costs incurred and paid for during the project. This includes when an organization pays for personnel, supplies, equipment, etc. for their own company with organizational resources. If the item or service is reimbursed for, it is cash cost share. All cost share items must be necessary to the performance of the project. Contractors may not provide cost share. Any partial donation of goods or services is considered a discount and is not allowable.  \n3. In Kind Cost Share - encompasses all contributions to the project made by the recipient, subrecipient, or third party (an entity that does not have a role in performing the scope of work) where a value of the contribution can be readily determined, verified and justified but where no actual cash is transacted in securing the good or service comprising the contribution. In Kind cost share items include volunteer personnel hours, the donation of space or use of equipment, etc. The cash value and calculations thereof for all In Kind cost share items must be justified and explained in the Cost Share Item section below. All cost share items must be necessary to the performance of the project. If questions exist, consult your DOE contact before filling out In Kind cost share in this section. Contractors may not provide cost share.  Any partial donation of goods or services is considered a discount and is not allowable.  \n4. Funds from other Federal sources MAY NOT be counted as cost share. This prohibition includes FFRDC sub-recipients. Non-Federal sources include any source not originally derived from Federal funds. Cost sharing commitment letters from subrecipients and third parties must be provided with the original application.\n5. Fee or profit, including foregone fee or profit, are not allowable as project costs (including cost share) under any resulting award. The project may only incur those costs that are allowable and allocable to the project (including cost share) as determined in accordance with the applicable cost principles prescribed in FAR Part 31 for For-Profit entities and 2 CFR Part 200 Subpart E - Cost Principles for all other non-federal entities.\n6. NOTE: A Recipient who elects to employ the 10% de minimis Indirect Cost rate cannot claim the resulting indirect costs as a Cost Share contribution.                                                                                                              7. NOTE: A Recipient cannot claim \"unrecovered indirect costs\" as a Cost Share contribution, without prior approval.                                                                                                                                                                                                                                                                                                                        8. Each budget period is rounded to the nearest dollar. "]
[]
["Organization/Source                 ","Type (Cash or In Kind) ","Cost Share Item ","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10","Total Project Cost Share"]
["ABC Company\nEXAMPLE!!!","Cash","Project partner ABC Company will provide 20 PV modules for product development at the price of $680 per module",13600,{"$nulls":9},{"$f":"SUM(D6:F6)","v":13600}]
[{"$nulls":13},{"$f":"SUM(D7:M7)","v":0}]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
[{"$nulls":13},0]
["TOTAL COST SHARE",null,null,{"$f":"SUM(D7:D16)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Cost Share Percentage per Budget Period",{"$f":"IF(D17>0,D17/'Instructions and Summary'!B39,0)","v":0},{"$f":"IF(E17>0,E17/'Instructions and Summary'!C39,0)","v":0},{"$f":"IF(F17>0,F17/'Instructions and Summary'!D39,0)","v":0},{"$f":"IF(G17>0,G17/'Instructions and Summary'!E39,0)","v":0},{"$f":"IF(H17>0,H17/'Instructions and Summary'!F39,0)","v":0},{"$f":"IF(I17>0,I17/'Instructions and Summary'!G39,0)","v":0},{"$f":"IF(J17>0,J17/'Instructions and Summary'!H39,0)","v":0},{"$f":"IF(K17>0,K17/'Instructions and Summary'!I39,0)","v":0},{"$f":"IF(L17>0,L17/'Instructions and Summary'!J39,0)","v":0},{"$f":"IF(M17>0,M17/'Instructions and Summary'!K39,0)","v":0}]
[]
[{"$nulls":6},"Total Project Cost:  ",null,{"$f":"'Instructions and Summary'!L39","v":0},null,"Cost Share Percent of Award:",null,null,{"$f":"IF(I21>0,N17/I21,0)","v":0}]
[]
["Additional Explanation (as needed):"]

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

{"sheet":"SF-424A Cost Categories","index":12,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[37,0,37,13],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,0,32,13],[33,1,33,2],[36,0,36,1],[36,2,36,5],[36,6,36,13],[28,1,28,2],[19,0,20,0],[19,1,20,2],[19,3,19,6],[19,13,20,13],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[18,0,18,1],[18,2,18,13],[0,0,0,1],[0,2,0,3],[0,5,0,6],[1,0,1,13],[2,0,2,13],[3,0,3,1],[3,2,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,4,13]]}
["Applicant Name:",null,{"$f":"'Instructions and Summary'!B4","v":0},null,"Award Number:",{"$f":"'Instructions and Summary'!B3","v":0}]
["Budget Information - Non Construction Programs"]
[]
["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",{"$nulls":6},"Total"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)",{"$nulls":6},"(g)"]
["1.","Budget Period 1",null,null,null,{"$f":"'Instructions and Summary'!C12","v":0},{"$f":"'j. Cost Share'!D17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D8:G8),0)","v":0}]
["2.","Budget Period 2",null,null,null,{"$f":"'Instructions and Summary'!C13","v":0},{"$f":"'j. Cost Share'!E17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D9:G9),0)","v":0}]
["3.","Budget Period 3",null,null,null,{"$f":"'Instructions and Summary'!C14","v":0},{"$f":"'j. Cost Share'!F17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D10:G10),0)","v":0}]
["4.","Budget Period 4",null,null,null,{"$f":"'Instructions and Summary'!C15","v":0},{"$f":"'j. Cost Share'!G17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D11:G11),0)","v":0}]
[5,"Budget Period 5",null,null,null,{"$f":"'Instructions and Summary'!C16","v":0},{"$f":"'j. Cost Share'!H17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D12:G12),0)","v":0}]
[6,"Budget Period 6",null,null,null,{"$f":"'Instructions and Summary'!C17","v":0},{"$f":"'j. Cost Share'!I17","v":0},{"$nulls":6},0]
[7,"Budget Period 7",null,null,null,{"$f":"'Instructions and Summary'!C18","v":0},{"$f":"'j. Cost Share'!J17","v":0},{"$nulls":6},0]
[8,"Budget Period 8",null,null,null,{"$f":"'Instructions and Summary'!C19","v":0},{"$f":"'j. Cost Share'!K17","v":0},{"$nulls":6},0]
[9,"Budget Period 9",null,null,null,{"$f":"'Instructions and Summary'!C20","v":0},{"$f":"'j. Cost Share'!L17","v":0},{"$nulls":6},0]
[10,"Budget Period 10",null,null,null,{"$f":"'Instructions and Summary'!C21","v":0},{"$f":"'j. Cost Share'!M17","v":0},{"$nulls":6},0]
["11.","Totals",null,null,null,{"$f":"ROUND(SUM(F8:F17),0)","v":0},{"$f":"ROUND(SUM(G8:G17),0)","v":0},{"$nulls":6},{"$f":"ROUND(SUM(N8:N17),0)","v":0}]
["Section B - Budget Categories"]
["12","Object Class Categories",null,"Grant Program, Function or Activity",{"$nulls":9},"Total (5)"]
[null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10"]
[null,"a.  Personnel",null,{"$f":"'a. Personnel'!E34","v":0},{"$f":"'a. Personnel'!H34","v":0},{"$f":"'a. Personnel'!K34","v":0},{"$f":"'a. Personnel'!N34","v":0},{"$f":"'a. Personnel'!Q34","v":0},{"$f":"'a. Personnel'!T34","v":0},{"$f":"'a. Personnel'!W34","v":0},{"$f":"'a. Personnel'!Z34","v":0},{"$f":"'a. Personnel'!AC34","v":0},{"$f":"'a. Personnel'!AF34","v":0},{"$f":"ROUND(SUM(D22:M22),0)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"'b. Fringe'!D13","v":0},{"$f":"'b. Fringe'!G13","v":0},{"$f":"'b. Fringe'!J13","v":0},{"$f":"'b. Fringe'!M13","v":0},{"$f":"'b. Fringe'!P13","v":0},{"$f":"'b. Fringe'!S13","v":0},{"$f":"'b. Fringe'!V13","v":0},{"$f":"'b. Fringe'!Y13","v":0},{"$f":"'b. Fringe'!AB13","v":0},{"$f":"'b. Fringe'!AE13","v":0},0]
[null,"c.  Travel",null,{"$f":"'c. Travel'!K14","v":0},{"$f":"'c. Travel'!K22","v":0},{"$f":"'c. Travel'!K30","v":0},{"$f":"'c. Travel'!K38","v":0},{"$f":"'c. Travel'!K46","v":0},{"$f":"'c. Travel'!K54","v":0},{"$f":"'c. Travel'!K62","v":0},{"$f":"'c. Travel'!K70","v":0},{"$f":"'c. Travel'!K78","v":0},{"$f":"'c. Travel'!K86","v":0},0]
[null,"d.  Equipment",null,{"$f":"'d. Equipment'!E14","v":0},{"$f":"'d. Equipment'!E22","v":0},{"$f":"'d. Equipment'!E30","v":0},{"$f":"'d. Equipment'!E38","v":0},{"$f":"'d. Equipment'!E46","v":0},{"$f":"'d. Equipment'!E54","v":0},{"$f":"'d. Equipment'!E62","v":0},{"$f":"'d. Equipment'!E70","v":0},{"$f":"'d. Equipment'!E78","v":0},{"$f":"'d. Equipment'!E86","v":0},0]
[null,"e.  Supplies",null,{"$f":"'e. Supplies'!E15","v":0},{"$f":"'e. Supplies'!E25","v":0},{"$f":"'e. Supplies'!E35","v":0},{"$f":"'e. Supplies'!E45","v":0},{"$f":"'e. Supplies'!E55","v":0},{"$f":"'e. Supplies'!E65","v":0},{"$f":"'e. Supplies'!E75","v":0},{"$f":"'e. Supplies'!E85","v":0},{"$f":"'e. Supplies'!E95","v":0},{"$f":"'e. Supplies'!E105","v":0},0]
[null,"f.  Contractual",null,{"$f":"'f. Contractual'!E29","v":0},{"$f":"'f. Contractual'!F29","v":0},{"$f":"'f. Contractual'!G29","v":0},{"$f":"'f. Contractual'!H29","v":0},{"$f":"'f. Contractual'!I29","v":0},{"$f":"'f. Contractual'!J29","v":0},{"$f":"'f. Contractual'!K29","v":0},{"$f":"'f. Contractual'!L29","v":0},{"$f":"'f. Contractual'!M29","v":0},{"$f":"'f. Contractual'!N29","v":0},0]
[null,"g.  Construction",null,{"$f":"'g. Construction'!C15","v":0},{"$f":"'g. Construction'!C22","v":0},{"$f":"'g. Construction'!C29","v":0},{"$f":"'g. Construction'!C36","v":0},{"$f":"'g. Construction'!C43","v":0},{"$f":"'g. Construction'!C50","v":0},{"$f":"'g. Construction'!C57","v":0},{"$f":"'g. Construction'!C64","v":0},{"$f":"'g. Construction'!C71","v":0},{"$f":"'g. Construction'!C78","v":0},0]
[null,"h.  Other",null,{"$f":"'h. Other'!C14","v":0},{"$f":"'h. Other'!C22","v":0},{"$f":"'h. Other'!C30","v":0},{"$f":"'h. Other'!C38","v":0},{"$f":"'h. Other'!C46","v":0},{"$f":"'h. Other'!C54","v":0},{"$f":"'h. Other'!C62","v":0},{"$f":"'h. Other'!C70","v":0},{"$f":"'h. Other'!C78","v":0},{"$f":"'h. Other'!C86","v":0},0]
[null,"i.  Total Direct Charges (sum of 12a-12h)",null,{"$f":"SUM(D22:D29)","v":0},{"$f":"SUM(E22:E29)","v":0},{"$f":"SUM(F22:F29)","v":0},{"$f":"SUM(G22:G29)","v":0},{"$f":"SUM(H22:H29)","v":0},0,0,0,0,0,0]
[null,"j.  Indirect Charges",null,{"$f":"'i. Indirect'!B16","v":0},{"$f":"'i. Indirect'!C16","v":0},{"$f":"'i. Indirect'!D16","v":0},{"$f":"'i. Indirect'!E16","v":0},{"$f":"'i. Indirect'!F16","v":0},{"$f":"'i. Indirect'!G16","v":0},{"$f":"'i. Indirect'!H16","v":0},{"$f":"'i. Indirect'!I16","v":0},{"$f":"'i. Indirect'!J16","v":0},{"$f":"'i. Indirect'!K16","v":0},0]
[null,"k.  Totals (sum of 12i-12j)",null,{"$f":"ROUND(SUM(D30:D31),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["13","Program Income",{"$nulls":11},{"$f":"ROUND(SUM(D34:G34),0)","v":0}]

{"sheet":"SF-424A Minus FFRDC","index":13,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[18,0,18,1],[18,2,18,13],[0,0,0,1],[0,2,0,3],[0,5,0,6],[1,0,1,13],[2,0,2,13],[3,0,3,1],[3,2,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,4,13],[28,1,28,2],[19,0,20,0],[19,1,20,2],[19,3,19,6],[19,13,20,13],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[37,0,37,13],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,0,32,13],[33,1,33,2],[36,0,36,1],[36,2,36,5],[36,6,36,13]]}
["Applicant Name:",null,{"$f":"'Instructions and Summary'!B4","v":0},null,"Award Number:",{"$f":"'Instructions and Summary'!B3","v":0}]
["Budget Information - Non Construction Programs"]
[]
["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",{"$nulls":6},"Total"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)",{"$nulls":6},"(g)"]
["1.","Budget Period 1",null,null,null,{"$f":"'Instructions and Summary'!C12-'Instructions and Summary'!B33","v":0},{"$f":"'j. Cost Share'!D17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D8:G8),0)","v":0}]
["2.","Budget Period 2",null,null,null,{"$f":"'Instructions and Summary'!C13-'Instructions and Summary'!C33","v":0},{"$f":"'j. Cost Share'!E17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D9:G9),0)","v":0}]
["3.","Budget Period 3",null,null,null,{"$f":"'Instructions and Summary'!C14-'Instructions and Summary'!D33","v":0},{"$f":"'j. Cost Share'!F17","v":0},{"$nulls":6},0]
["4.","Budget Period 4",null,null,null,{"$f":"'Instructions and Summary'!C15-'Instructions and Summary'!E33","v":0},{"$f":"'j. Cost Share'!G17","v":0},{"$nulls":6},0]
[5,"Budget Period 5",null,null,null,{"$f":"'Instructions and Summary'!C16-'Instructions and Summary'!F33","v":0},{"$f":"'j. Cost Share'!H17","v":0},{"$nulls":6},0]
[6,"Budget Period 6",null,null,null,{"$f":"'Instructions and Summary'!C17-'Instructions and Summary'!G33","v":0},{"$f":"'j. Cost Share'!I17","v":0},{"$nulls":6},0]
[7,"Budget Period 7",null,null,null,{"$f":"'Instructions and Summary'!C18-'Instructions and Summary'!H33","v":0},{"$f":"'j. Cost Share'!J17","v":0},{"$nulls":6},0]
[8,"Budget Period 8",null,null,null,{"$f":"'Instructions and Summary'!C19-'Instructions and Summary'!I33","v":0},{"$f":"'j. Cost Share'!K17","v":0},{"$nulls":6},0]
[9,"Budget Period 9",null,null,null,{"$f":"'Instructions and Summary'!C20-'Instructions and Summary'!J33","v":0},{"$f":"'j. Cost Share'!L17","v":0},{"$nulls":6},0]
[10,"Budget Period 10",null,null,null,{"$f":"'Instructions and Summary'!C21-'Instructions and Summary'!K33","v":0},{"$f":"'j. Cost Share'!M17","v":0},{"$nulls":6},{"$f":"ROUND(SUM(D17:G17),0)","v":0}]
[11,"Totals",null,null,null,{"$f":"ROUND(SUM(F8:F17),0)","v":0},{"$f":"ROUND(SUM(G8:G17),0)","v":0},{"$nulls":6},{"$f":"ROUND(SUM(N8:N17),0)","v":0}]
["Section B - Budget Categories"]
["12","Object Class Categories",null,"Grant Program, Function or Activity",{"$nulls":9},"Total (5)"]
[null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Budget Period 6","Budget Period 7","Budget Period 8","Budget Period 9","Budget Period 10"]
[null,"a.  Personnel",null,{"$f":"'a. Personnel'!E34","v":0},{"$f":"'a. Personnel'!H34","v":0},{"$f":"'a. Personnel'!K34","v":0},{"$f":"'a. Personnel'!N34","v":0},{"$f":"'a. Personnel'!Q34","v":0},{"$f":"'a. Personnel'!T34","v":0},{"$f":"'a. Personnel'!W34","v":0},{"$f":"'a. Personnel'!Z34","v":0},{"$f":"'a. Personnel'!AC34","v":0},{"$f":"'a. Personnel'!AF34","v":0},{"$f":"ROUND(SUM(D22:M22),0)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"'b. Fringe'!D13","v":0},{"$f":"'b. Fringe'!G13","v":0},{"$f":"'b. Fringe'!J13","v":0},{"$f":"'b. Fringe'!M13","v":0},{"$f":"'b. Fringe'!P13","v":0},{"$f":"'b. Fringe'!S13","v":0},{"$f":"'b. Fringe'!V13","v":0},{"$f":"'b. Fringe'!Y13","v":0},{"$f":"'b. Fringe'!AB13","v":0},{"$f":"'b. Fringe'!AE13","v":0},0]
[null,"c.  Travel",null,{"$f":"'c. Travel'!K14","v":0},{"$f":"'c. Travel'!K22","v":0},{"$f":"'c. Travel'!K30","v":0},{"$f":"'c. Travel'!K38","v":0},{"$f":"'c. Travel'!K46","v":0},{"$f":"'c. Travel'!K54","v":0},{"$f":"'c. Travel'!K62","v":0},{"$f":"'c. Travel'!K70","v":0},{"$f":"'c. Travel'!K78","v":0},{"$f":"'c. Travel'!K86","v":0},0]
[null,"d.  Equipment",null,{"$f":"'d. Equipment'!E14","v":0},{"$f":"'d. Equipment'!E22","v":0},{"$f":"'d. Equipment'!E30","v":0},{"$f":"'d. Equipment'!E38","v":0},{"$f":"'d. Equipment'!E46","v":0},{"$f":"'d. Equipment'!E54","v":0},{"$f":"'d. Equipment'!E62","v":0},{"$f":"'d. Equipment'!E70","v":0},{"$f":"'d. Equipment'!E78","v":0},{"$f":"'d. Equipment'!E86","v":0},0]
[null,"e.  Supplies",null,{"$f":"'e. Supplies'!E15","v":0},{"$f":"'e. Supplies'!E25","v":0},{"$f":"'e. Supplies'!E35","v":0},{"$f":"'e. Supplies'!E45","v":0},{"$f":"'e. Supplies'!E55","v":0},{"$f":"'e. Supplies'!E65","v":0},{"$f":"'e. Supplies'!E75","v":0},{"$f":"'e. Supplies'!E85","v":0},{"$f":"'e. Supplies'!E95","v":0},{"$f":"'e. Supplies'!E105","v":0},0]
[null,"f.  Contractual",null,{"$f":"'f. Contractual'!E29-'f. Contractual'!E27","v":0},{"$f":"'f. Contractual'!F29-'f. Contractual'!F27","v":0},{"$f":"'f. Contractual'!G29-'f. Contractual'!G27","v":0},{"$f":"'f. Contractual'!H29-'f. Contractual'!H27","v":0},{"$f":"'f. Contractual'!I29-'f. Contractual'!I27","v":0},{"$f":"'f. Contractual'!J29-'f. Contractual'!J27","v":0},{"$f":"'f. Contractual'!K29-'f. Contractual'!K27","v":0},{"$f":"'f. Contractual'!L29-'f. Contractual'!L27","v":0},{"$f":"'f. Contractual'!M29-'f. Contractual'!M27","v":0},{"$f":"'f. Contractual'!N29-'f. Contractual'!N27","v":0},0]
[null,"g.  Construction",null,{"$f":"'g. Construction'!C15","v":0},{"$f":"'g. Construction'!C22","v":0},{"$f":"'g. Construction'!C29","v":0},{"$f":"'g. Construction'!C36","v":0},{"$f":"'g. Construction'!C43","v":0},{"$f":"'g. Construction'!C50","v":0},{"$f":"'g. Construction'!C57","v":0},{"$f":"'g. Construction'!C64","v":0},{"$f":"'g. Construction'!C71","v":0},{"$f":"'g. Construction'!C78","v":0},0]
[null,"h.  Other",null,{"$f":"'h. Other'!C14","v":0},{"$f":"'h. Other'!C22","v":0},{"$f":"'h. Other'!C30","v":0},{"$f":"'h. Other'!C38","v":0},{"$f":"'h. Other'!C46","v":0},{"$f":"'h. Other'!C54","v":0},{"$f":"'h. Other'!C62","v":0},{"$f":"'h. Other'!C70","v":0},{"$f":"'h. Other'!C78","v":0},{"$f":"'h. Other'!C86","v":0},0]
[null,"i.  Total Direct Charges (sum of 12a-12h)",null,{"$f":"SUM(D22:D29)","v":0},{"$f":"SUM(E22:E29)","v":0},{"$f":"SUM(F22:F29)","v":0},{"$f":"SUM(G22:G29)","v":0},{"$f":"SUM(H22:H29)","v":0},0,0,0,0,0,0]
[null,"j.  Indirect Charges",null,{"$f":"'i. Indirect'!B16","v":0},{"$f":"'i. Indirect'!C16","v":0},{"$f":"'i. Indirect'!D16","v":0},{"$f":"'i. Indirect'!E16","v":0},{"$f":"'i. Indirect'!F16","v":0},{"$f":"'i. Indirect'!G16","v":0},{"$f":"'i. Indirect'!H16","v":0},{"$f":"'i. Indirect'!I16","v":0},{"$f":"'i. Indirect'!J16","v":0},{"$f":"'i. Indirect'!K16","v":0},0]
[null,"k.  Totals (sum of 12i-12j)",null,{"$f":"ROUND(SUM(D30:D31),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(N30:N31),0)","v":0}]
[]
["7.","Program Income",{"$nulls":11},{"$f":"ROUND(SUM(D34:G34),0)","v":0}]