{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["Instructions and Summary","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect","Cost Share","SF-424A"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":98,"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","formulas":"cached_only"}

{"sheet":"Instructions and Summary","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,0,2,6],[3,1,3,2],[3,3,3,5],[9,0,9,6],[27,0,27,2],[28,0,30,6],[4,1,4,2],[4,3,4,5],[6,0,6,6],[7,0,7,6]],"flags":["formulas_cached_only"]}
["PMC 123.1 Detailed Budget Justification ",{"$nulls":5},"OMB Number: 1910-5162"]
[{"$nulls":6},"Expiration Date: 01/31/2015"]
["Instructions and Summary"]
["Award Number:",null,null,"Date of Submission:"]
["Award Recipient:",null,null,"Form submitted by: "]
[{"$nulls":6},"(May be award recipient or sub-recipient)"]
["Please read the instructions on each page (worksheet) before starting.  \nIf you have any questions, please ask your DOE contact.  It will save you time!  "]
["On this form, provide detailed support for the estimated project costs identified for each Category line item within each worksheet (budget items under different tabs).  \n\n●  The dollar amounts on this page must match the amounts on the associated application.\n\n● The award recipient and each sub-recipient with estimated costs of $100,000 or more must complete this form and ensure it matches the application.\n\n●   The total budget presented on this form and on the application  must include both Federal (DOE), and Non-Federal (cost share) portions, thereby reflecting TOTAL PROJECT COSTS proposed.\n\n●  For costs in each Object Class Category, complete the corresponding worksheet on this form (tab at the bottom of the page).  Include a brief narrative explanation of the costs in the \"Additional Explanations/Comments\" section to justify the costs.  \n\n●  All costs incurred by the preparer's sub-recipients, vendors, contractors, consultants 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. \n\nBURDEN DISCLOSURE STATEMENT\nPublic reporting burden for this collection of information is estimated to average  3 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\n(Note: The values in this summary table are from entries made in each budget category sheet.)"]
["CATEGORY","Budget Period 1 Costs","Budget Period 2 Costs","Budget Period 3 Costs"," Total Costs","Project Costs %","Comments\n(Add comments as needed)"]
["a. Personnel",0,0,0,0,{"$error":"#DIV/0!"}]
["b. Fringe Benefits",0,0,0,0,{"$error":"#DIV/0!"}]
["c. Travel",0,0,0,0,{"$error":"#DIV/0!"}]
["d. Equipment",0,0,0,0,{"$error":"#DIV/0!"}]
["e. Supplies",0,0,0,0,{"$error":"#DIV/0!"}]
["f. Contractual"]
["Sub-recipient",0,0,0,0,{"$error":"#DIV/0!"}]
["Vendor",0,0,0,0,{"$error":"#DIV/0!"}]
["FFRDC",0,0,0,0,{"$error":"#DIV/0!"}]
["Total Contractual ",0,0,0,0,{"$error":"#DIV/0!"}]
["g. Construction",0,0,0,0,{"$error":"#DIV/0!"}]
["h. Other Direct Costs",0,0,0,0,{"$error":"#DIV/0!"}]
["Total Direct Costs",0,0,0,0,{"$error":"#DIV/0!"}]
["i. Indirect Charges",0,0,0,0,{"$error":"#DIV/0!"}]
["Total Project Costs",0,0,0,0,{"$error":"#DIV/0!"}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"a. Personnel","index":1,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,0,1,13],[5,11,6,11],[0,11,0,13],[5,2,5,4],[5,5,5,7],[5,8,5,10],[0,0,0,7],[67,0,69,13],[5,1,6,1],[2,0,3,13],[66,0,66,3],[5,0,6,0],[5,13,6,13],[5,12,6,12],[11,0,11,1],[16,0,16,1],[19,0,19,1]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification",{"$nulls":10},0]
["a. Personnel"]
["PLEASE READ!!!\n\nList costs solely for employees of the entity completing this form (award prime recipient or sub-recipient with costs over $100,000).  All other personnel costs (for prime's subrecipients or other contractual efforts of the entity preparing this budget) must be included under f. Contractual.  This includes all consultants and FFRDCs.\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 or % of time) to be expended, the base pay rate (or composite base pay rate for group category), total direct personnel compensation, and identify the rate basis (e.g., actual salary, labor distribution report, technical estimate, state civil service rates, etc.).\n\nAdd rows as needed.  Formulas/calculations will need to be entered by the preparer of this form.  Please enter formulas as shown in the example.\n\n Include a brief narrative explanation of the costs in the \"Additional Explanations/Comments\" section to justify the costs."]
[]
[]
["Task # and Title","Position Title","Budget Period 1",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Project Total Hours","Project 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"]
["1.  Generation 2A Receiver Design",null,10000,null,423000,600,null,24000,800,null,31000,11400,478000,"Actual Salary"]
["EXAMPLE","Sr. Engineer    ",2000,85,170000,200,50,10000,200,50,10000,2400,190000,"Actual Salary"]
["ONLY!!!","Electrical engineers",6200,35,217000,400,35,14000,600,35,21000,7200,252000,"Actual Salary"]
[null,"Technician         ",1800,20,36000,0,0,0,0,0,0,1800,36000,"Actual Salary"]
["1.   (Task 1 Title)",null,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,0,0]
["2.   (Task 2 Title)"]
[{"$nulls":4},0,null,null,0,null,null,0,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,0,0]
["3.   (Task 3 Title)"]
["etc.",null,null,null,0,null,null,0,null,null,0,0,0]
{"$rows_empty":43}
[null,"Total Personnel Costs",0,null,0,0,null,0,0,null,0,0,0]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"b. Fringe","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,10],[21,0,21,10],[22,0,24,10],[2,0,2,10],[14,0,18,10],[12,0,13,10],[3,4,3,6],[3,7,3,9],[3,1,3,3]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification ",{"$nulls":9},0,null,null,0]
["b. Fringe Benefits"]
["Please Read!!!\n\nFill out the table below by labor type (add additional rows if necessary).  If all employees receive the same fringe benefits, you can show \"Total Personnel\" in the Labor Type column instead of listing out all personnel separately.  If necessary, you can use the box below to provide additional explanation regarding your fringe rate calculation.  \n\nThe rates and how they are applied should not be averaged to get one fringe cost percentage.  \n\nThe fringe benefit rate should be applied to both the Federal Share and Recipient Cost Share.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer.  Please enter formulas as shown in the example."]
["Labor Type","Budget Period 1",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Total Project Fringe Benefit Costs"]
[null,"Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total"]
["EXAMPLE ONLY:\nSr. Engineer",170000,0.2,34000,10000,0.2,2000,10000,0.2,2000,38000]
["Total Personnel",null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,0]
["Total:",0,null,0,0,null,0,0,null,0,0]
[]
[]
["A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by DOE for estimating purposes is required if reimbursement for fringe benefits is requested.  Please check (X) one of the options below and provide the requested information.  Calculate the fringe rate and the Total should calculate automatically (if adding rows, ensure the formulas are updated). "]
[]
["\n\n______ 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 this application, \n              and will be provided electronically to the Contracting Officer for this project.\n\n______ There is not a current, federally approved rate agreement negotiated and available*.  \n\n*When this option is checked, the entity preparing this form shall submit a rate proposal in the format provided at the following website, or a format that provides the same level of information; and the rate proposal must support the rates being proposed for use in performance of the proposed project.  Go to https://www.eere-pmc.energy.gov/forms.aspx and select Sample Rate Proposal.\n"]
[]
[]
[]
[]
[]
[]
["Additional Explanation/Comments (as necessary)"]
["Please use this box (or an attachment) to further explain how your total fringe benefits costs were calculated.  Your 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":"c. Travel","index":3,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,0,0,1],[61,0,63,7],[41,0,41,7],[5,0,5,7],[24,0,24,7],[2,0,2,7]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification ",{"$nulls":6},0]
["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.   \n\nAll listed travel must be necessary for performance of the Statement of Project Objectives.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[]
["Purpose of travel","Depart From","Destination","No. of Days","No. of Travelers","Cost per Traveler","Cost per Trip","Basis for Estimating Costs"]
["Budget Period 1"]
["Domestic Travel"]
["EXAMPLE ONLY!!!   Visit to PV cell mfr. to set up vendor agreement",null,null,2,2,650,1300,"Internet prices"]
[{"$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},0]
["International Travel"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["International Travel subtotal",{"$nulls":5},0]
["Budget Period 1 Total",{"$nulls":5},0]
["Budget Period 2"]
["Domestic Travel"]
[{"$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},0]
["International Travel"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["International Travel subtotal",{"$nulls":5},0]
["Budget Period 2 Total",{"$nulls":5},0]
["Budget Period 3"]
["Domestic Travel"]
[{"$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},0]
["International Travel"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["International Travel subtotal",{"$nulls":5},0]
["Budget Period 3 Total",{"$nulls":5},0]
["PROJECT TOTAL",{"$nulls":5},0]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"d. Equipment","index":4,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[44,0,46,5],[0,0,0,3],[1,0,1,5],[17,0,17,5],[28,0,28,5],[2,0,2,5],[5,0,5,5],[43,0,43,3]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification",{"$nulls":4},0]
["d. Equipment"]
["PLEASE READ!!!\n\nEquipment 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 10 CFR 600 found on the PMC Recipient Resources Forms page at \nhttps://www.eere-pmc.energy.gov/Forms.aspx#regs .\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.  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 over $50,000 in price, also include a copy of the associated vendor quote or catalog price list.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[]
["Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["EXAMPLE ONLY!!!   Thermal shock chamber",2,20000,40000,"Vendor Quote","Reliability testing of PV modules- Task 4.3"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 1 Total",null,null,0]
["Budget Period 2"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 2 Total",null,null,0]
["Budget Period 3"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 3 Total",null,null,0]
["PROJECT TOTAL",null,null,0]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"e. Supplies","index":5,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[47,0,49,5],[0,0,0,3],[1,0,1,5],[31,0,31,5],[2,0,2,5],[5,0,5,5],[18,0,18,5],[46,0,46,2]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification ",{"$nulls":4},0]
["e. Supplies"]
["PLEASE READ!!!\n\nSupplies 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 10 CFR 600 found on the PMC Recipient Resources Forms page at https://www.eere-pmc.energy.gov/Forms.aspx#regs.\n\nList all proposed supplies below, providing a bases of costs such as vendor quotes, catalog prices, prior invoices, etc.; and 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.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. \n"]
[]
["General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["EXAMPLE ONLY!!!  Wireless DAS components",10,360,3600,"Catalog price","For Alpha prototype - Task 2.4"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 1 Total",null,null,0]
["Budget Period 2"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 2 Total",null,null,0]
["Budget Period 3"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 3 Total",null,null,0]
["PROJECT TOTAL",null,null,0]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"f. Contractual","index":6,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[38,0,40,5],[0,0,0,1],[2,0,2,5],[1,0,1,5],[37,0,37,1],[3,0,3,5],[0,3,0,5]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification ",null,null,0]
["f. Contractual"]
["PLEASE READ!!!\n\nThe entity completing this form must provide all costs related to sub-recipients, vendors, contractors, consultants and FFRDC partners in the applicable boxes below.  \n\nSub-recipients (partners, sub-awardees): \nFor each sub-recipient with total project costs of $100,000 or more, a separate budget form and justification must be submitted.  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-recipeint entries below. \n\nThe preparer of this form need only provide further support of the completed sub-recipient budget forms as they deem necessary.  The support to justify the budgets of sub-recipients with estimated costs less than $100,000 may be in any format, and at a minimum should provide what Statement of Project Objectives task(s) are being performed, the purpose/need for the effort, and a basis of the estimated costs that is considered sufficient for DOE evaluation.\n"]
["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 DOE evaluation.  \n\nFederal Research and Development Centers (FFRDCs):\nFor FFRDC partners, the award recipient will provide a Field Work Proposal (if not already provided with the original application), along with the FFRDC labor mix and hours, by category and FFRDC major purchases greater than $25,000, including Quantity, Unit Cost, Basis of Cost, and Justification.   The award recipient may allow the FFRDC to provide this information directly to DOE.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[]
[]
["Sub-Recipient\nName/Organization","Purpose/Tasks in SOPO","Budget Period 1\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","Project Total"]
["EXAMPLE ONLY!!!  XYZ Corp.","Partner to develop optimal fresnel lens for Gen 2 product - Task 2.4",48000,32000,16000,96000," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[{"$nulls":5},0," "]
[null,"Sub-total",0,0,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\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","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,119400]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"Sub-total",0,0,0,0]
[]
["FFRDC\nName/Organization","Purpose","Budget Period 1\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","Project Total"]
[null," ",null,null,null,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"Sub-total",0,0,0,0]
[]
["Total Contractual",null,0,0,0,0]
[]
["AdditionalExplanations/Comments (as necessary)"]

{"sheet":"g. Construction","index":7,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[16,0,16,3],[23,0,23,3],[33,0,35,3],[1,0,1,3],[5,0,5,3],[4,0,4,3],[2,0,2,3],[8,0,8,3]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification",null,null,0]
["g. Construction"]
["PLEASE READ!!!\n\nConstruction, 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.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer."]
[]
["Overall description of construction actiivities:"]
["Example Only!!! - Build wind turbine platform "]
[]
["General Description","Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["Three days of excavation for platform site\nEXAMPLE ONLY!!!",28000,"Engineering estimate","Site must be prepared for construction of platform."]
[]
[]
[]
[]
[]
["Budget Period 1 Total",0]
["Budget Period 2"]
[]
[]
[]
[]
[]
["Budget Period 2 Total",0]
["Budget Period 3"]
[]
[]
[]
[]
[]
["Budget Period 3 Total",0]
["PROJECT TOTAL",0]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"h. Other","index":8,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,1],[33,0,35,3],[1,0,1,3],[22,0,22,3],[2,0,2,3],[5,0,5,3],[14,0,14,3],[32,0,32,2]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification",null,null,0]
["h. Other Direct Costs"]
["PLEASE READ!!!\n\nOther 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:  equipment costs less than $5000, meetings within the scope of work, printing costs, etc. which can be directly charged to the project and are not duplicated in indirect costs (overhead costs).\n\nBasis of cost are items such as vendor quotes, prior purchases of similar or like items, published price list, etc.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer."]
[]
["General description"," Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["EXAMPLE ONLY!!!  Grad student tuition",16000,"Established UCD costs","Support of graduate students working on project "]
[]
[]
[]
[]
[]
[]
["Budget Period 1 Total",0]
["Budget Period 2"]
[]
[]
[]
[]
[]
[]
["Budget Period 2 Total",0]
["Budget Period 3"]
[]
[]
[]
[]
[]
[]
["Budget Period 3 Total",0]
["PROJECT TOTAL",0]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"i. Indirect","index":9,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[17,0,17,6],[18,0,22,6],[26,0,34,6],[0,0,0,3],[0,7,0,8],[25,0,25,6],[2,0,2,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[0,5,0,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification ",{"$nulls":4},0]
[null,null,"i. Indirect Costs"]
["Please Read!!!\n\nFill out the table below to indicate how your indirect costs are calculated.  If necessary, you can use the box below to provide additional explanation regarding your indirect rate calculation.  \n\nThe rates and how they are applied should not be averaged to get one indirect cost percentage.  \n\nThe indirect rate should be applied to both the Federal Share and Recipient Cost Share.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer.  Please enter formulas as shown in the example."]
[]
[null,"Budget Period 1","Budget Period 2","Budget Period 3","Total","Explanation of BASE "]
["Provide ONLY Applicable Rates:"]
["Overhead Rate",0,0,0]
["General & Administrative (G&A)",0,0,0]
["FCCM Rate, if applicable",0,0,0]
["OTHER Indirect Rate",0,0,0]
["Indirect Costs (As Applicable):"]
["Overhead Costs",0,0,0,0]
["G&A Costs",0,0,0,0]
["FCCM Costs, if applicable",0,0,0,0]
[" OTHER Indirect Costs",0,0,0,0]
["Total indirect costs requested:",0,0,0,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.  Calculate the indirect rate dollars and the totals should calculate automatically."]
["\n\n______ 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\n______ There is not a current, federally approved rate agreement negotiated and available*.  \n\n*When this option is checked, the entity preparing this form shall submit an indirect rate proposal in the format provided at the following website, or a format that provides the same level of information and which will support the rates being proposed for use in performance of the proposed project.  Go to https://www.eere-pmc.energy.gov/forms.aspx and select Sample Rate Proposal. "]
[]
[]
[]
[]
[]
[]
["Additional Explanations/Comments (as necessary)"]
["*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":"Cost Share","index":10,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,6],[0,0,0,2],[22,0,24,6],[3,0,3,6],[2,0,2,6],[21,0,21,2],[18,4,18,5],[19,3,19,5],[19,0,19,1],[0,4,0,6]],"flags":["formulas_cached_only"]}
["Detailed Budget Justification",null,null,null,0]
["Cost Share"]
["PLEASE READ!!!\n\nA detailed presentation of the cash or cash value of all cost share proposed for the project must be provided in the table below.  Identify the source & amount of each item of cost share proposed by the award recipient and each sub-recipient or vendor.  Letters of commitment must be submitted for all third party cost share (other than award recipient).\n\nNote that “cost-share\" is not limited to cash investment.  Other items that may be assigned value in a budget if incurred as part of the project budget and are necessary to the performance of the project.  Items that may be considered as cost share include: contribution of services or property; donated, purchased or existing equipment; donated, purchased or existing supplies; and/or unrecovered personnel, fringe benefits and indirect costs, etc. For each cost share contribution identified as other than cash, identify the item and describe how the value of the cost share contribution was calculated."]
["Funds from other Federal sources MAY NOT be counted as cost share. This prohibition includes FFRDC sub-recipients.  Non-Federal sources include private, state or local Government, or any source not originally derived from Federal funds.  Documentation of cost sharing commitments must be provided, if not already provided with the original application and they have not changed since its submission.\n\nFee or profit will not be paid to the award recipients or subrecipients of financial assistance awards.  Additionally, foregone fee or profit by the applicant shall not be considered cost sharing under any resulting award.  Reimbursement of actual costs will only include those costs that are allowable and allocable to the project as determined in accordance with the applicable cost principles prescribed in 10 CFR 600.127, 10 CFR 600.222 or 10 CFR 600.317.  Also see 10 CFR 600.318 relative to profit or fee.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer."]
[]
["Organization/Source                 ","Type \n(cash or other) ","Cost Share Item ","Budget Period 1\nCost Share","Budget Period 2\nCost Share","Budget Period 3\nCost Share","Total Project Cost Share"]
["ABC Company\nEXAMPLE ONLY!!!","Cash","Project partner ABC Company will provide 40 PV modules for product development at 50% off the of the retail price of $680",13600,null,null,13600]
[{"$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]
[null,null,"Totals",0,0,0,0]
[]
["Total Project Cost:  ",null,0,"Cost Share Percent of Award:",null,null,{"$error":"#DIV/0!"}]
[]
["Additional Explanations/Comments (as necessary)"]

{"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]],"flags":["formulas_cached_only"]}
["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,0,0,0]
["2.","Budget period 2",null,null,null,0,0,0]
["3.","Budget period 3",null,null,null,0,0,0]
["4.",{"$nulls":6},0]
["5.","Totals",null,0,0,0,0,0]
["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,0,0,0,null,0]
[null,"b.  Fringe Benefits",null,0,0,0,null,0]
[null,"c.  Travel",null,0,0,0,null,0]
[null,"d.  Equipment",null,0,0,0,null,0]
[null,"e.  Supplies",null,0,0,0,null,0]
[null,"f.  Contractual",null,0,0,0,null,0]
[null,"g.  Construction",null,0,0,0,null,0]
[null,"h.  Other",null,0,0,0,null,0]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,0,0,0,0,0]
[null,"j.  Indirect Charges",null,0,0,0,null,0]
[null,"k.  Totals (sum of 6i-6j)",null,0,0,0,0,0]
[]
["7.","Program Income",{"$nulls":5},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},0]
["9.","Budget period 2",{"$nulls":5},0]
["10.","Budget period 3",{"$nulls":5},0]
["11.",{"$nulls":6},0]
["12.","Total (sum of lines 8 - 11)",null,null,0,0,0,0]
["Section D - Forecasted Cash Needs"]
[null,null,null,"Total for 1st Year","1st Quarter","2nd Quarter","3rd Quarter","4th quarter"]
["13.","Federal",null,0]
["14.","Non-Federal",null,0]
["15.","Total (sum of lines 13 and 14)",null,0,0,0,0,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,0,0,0,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"]