{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Instructions and Summary","CAS Institutional Bgt","Basis of Costs","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect","Cost Share","SF-424A","SF-424A Cost Categories","Travel Summary","Foreign Travel Supp","Domestic Travel Sup"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":98,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,0,34,6],[4,1,4,2],[4,3,4,5],[6,0,6,6],[7,0,7,6],[2,0,2,6],[3,1,3,2],[3,3,3,5],[9,0,9,6],[31,0,31,2]]}
[null,null,null,null,null,null,"OMB Number: 1910-5162"]
[null,null,null,null,null,null,"Expiration Date: 01/31/2015"]
["Instructions and Summary"]
["Award Number:",null,null,"Date of Submission:"]
["Award Recipient:",null,null,"Form submitted by: "]
[null,null,null,null,null,null,"(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,{"$f":"'a. Personnel'!H23","v":0},{"$f":"'a. Personnel'!K23","v":0},{"$f":"SUM(B12:D12)","v":0},{"$f":"IF(E12=0,\" % \",E12/$E$26)","v":" % "}]
["b. Fringe Benefits",{"$f":"'b. Fringe'!D10","v":0},{"$f":"'b. Fringe'!G10","v":0},{"$f":"'b. Fringe'!J10","v":0},0,{"$f":"IF(E13=0,\" % \",E13/$E$26)","v":" % "}]
["c. Travel",{"$f":"'c. Travel'!G21","v":0},{"$f":"'c. Travel'!G38","v":0},{"$f":"'c. Travel'!G55","v":0},0," % "]
["d. Equipment",{"$f":"'d. Equipment'!D15","v":0},{"$f":"'d. Equipment'!D21","v":0},{"$f":"'d. Equipment'!D29","v":0},0," % "]
["e. Supplies",{"$f":"'e. Supplies'!D17","v":0},{"$f":"'e. Supplies'!D30","v":0},{"$f":"'e. Supplies'!D43","v":0},0," % "]
["f. Contractual"]
["Sub-recipient",{"$f":"'f. Contractual'!D17","v":0},{"$f":"'f. Contractual'!E17","v":0},{"$f":"'f. Contractual'!F17","v":0},{"$f":"SUM(B18:D18)","v":0}," % "]
["Vendor",{"$f":"'f. Contractual'!D26","v":0},{"$f":"'f. Contractual'!E26","v":0},{"$f":"'f. Contractual'!F26","v":0},{"$f":"SUM(B19:D19)","v":0}," % "]
["FFRDC",{"$f":"'f. Contractual'!D32","v":0},{"$f":"'f. Contractual'!E32","v":0},{"$f":"'f. Contractual'!F32","v":0},0," % "]
["Total Contractual ",{"$f":"SUM(B18:B20)","v":0},{"$f":"SUM(C18:C20)","v":0},{"$f":"SUM(D18:D20)","v":0},0," % "]
["g. Construction",{"$f":"'g. Construction'!B15","v":0},{"$f":"'g. Construction'!B22","v":0},{"$f":"'g. Construction'!B29","v":0},0," % "]
["h. Other Direct Costs",{"$f":"'h. Other'!B14","v":0},{"$f":"'h. Other'!B22","v":0},{"$f":"'h. Other'!B30","v":0},{"$f":"SUM(B23:D23)","v":0}," % "]
["Total Direct Costs",{"$f":"B12+B13+B14+B15+B16+B21+B22+B23","v":0},{"$f":"C12+C13+C14+C15+C16+C21+C22+C23","v":0},{"$f":"D12+D13+D14+D15+D16+D21+D22+D23","v":0},{"$f":"E12+E13+E14+E15+E16+E21+E22+E23","v":0}," % "]
["i. Indirect Charges",{"$f":"'i. Indirect'!B16","v":0},{"$f":"'i. Indirect'!C16","v":0},{"$f":"'i. Indirect'!D16","v":0},{"$f":"SUM(B25:D25)","v":0}," % "]
["Total Project Costs",{"$f":"B24+B25","v":0},{"$f":"C24+C25","v":0},{"$f":"D24+D25","v":0},{"$f":"E24+E25","v":0},{"$f":"IF(E26=0,\" \",E26/$E$26)","v":" "}]
[]
["CAS Instl Tot Direct Costs",{"$f":"('CAS Institutional Bgt'!C37)+('CAS Institutional Bgt'!C51)","v":0},{"$f":"('CAS Institutional Bgt'!D37)+('CAS Institutional Bgt'!D51)","v":0},{"$f":"('CAS Institutional Bgt'!E37)+('CAS Institutional Bgt'!E51)","v":0},{"$f":"('CAS Institutional Bgt'!F37)+('CAS Institutional Bgt'!F51)","v":0}]
["CAS Instl Total Indirect",{"$f":"'CAS Institutional Bgt'!C53","v":0},{"$f":"'CAS Institutional Bgt'!D53","v":0},{"$f":"'CAS Institutional Bgt'!E53","v":0},{"$f":"'CAS Institutional Bgt'!F53","v":0}]
["CAS Instl Bgt Proj Total",{"$f":"'CAS Institutional Bgt'!C54","v":0},{"$f":"'CAS Institutional Bgt'!D54","v":0},{"$f":"'CAS Institutional Bgt'!E54","v":0},{"$f":"'CAS Institutional Bgt'!F54","v":0},{"$f":"E28+E29","v":0},"For Cross Reference Purposes"]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"CAS Institutional Bgt","index":1,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,3],[85,0,85,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,0,5,1]]}
[]
["North Carolina State University",null,"PINS #"]
["Sponsor Legal Name:  "]
["Principal Investigator:                                    "]
["Project Title:  "]
["Project Period:       through    ",null,null,null,null,"Cumulative"]
["Budget for full Project Period",null,"BP/Year 1","BP/Year 2","BP/Year 3","Total"]
["Salaries/Compensation* "]
["Lead PI  ",null,0,0,0,{"$f":"SUM(C9:E9)","v":0}]
["Co-PI 1",null,0,0,0,0]
["Co-PI 2",null,0,0,0,0]
["Other Professionals",null,0,0,0,0]
["Post-Doc researcher (1 FTE)",null,0,0,null,0]
["Graduate Student (.5 FTE)",null,0,0,0,0]
["Temporary Employees ",null,0,0,0,{"$f":"SUM(C15:E15)","v":0}]
["Total Salaries",null,{"$f":"SUM(C9:C15)","v":0},{"$f":"SUM(D9:D15)","v":0},{"$f":"SUM(E9:E15)","v":0},{"$f":"SUM(F9:F15)","v":0}]
["Fringe Benefits *  (estimated using percentage of salary)","%"]
["Lead PI ",0.33,{"$f":"C9*B18","v":0},{"$f":"D9*B18","v":0},{"$f":"E9*B18","v":0},{"$f":"C18+D18+E18","v":0}]
["Co-PI 1",0.33,0,{"$f":"D10*B19","v":0},{"$f":"E10*B19","v":0},0]
["CO-PI 2",0.33,0,{"$f":"D11*B20","v":0},{"$f":"E11*B20","v":0},0]
["Other Professionals",0.33,0,{"$f":"D12*B21","v":0},{"$f":"E12*B21","v":0},0]
["Post-Doc researcher",0.19,0,0,0,0]
["Graduate Student ",0.16,0,0,{"$f":"E14*B23","v":0},0]
["Temporary Employees ",8.6499999999999994E-2,{"$f":"C15*B24","v":0},0,0,0]
["Total Fringe Benefits",null,{"$f":"SUM(C18:C24)","v":0},{"$f":"SUM(D18:D24)","v":0},{"$f":"SUM(E18:E24)","v":0},{"$f":"SUM(F18:F24)","v":0}]
["Domestic Travel ",null,0,0,0,{"$f":"SUM(C26:E26)","v":0}]
["Foreign Travel",null,0,0,0,{"$f":"SUM(C27:E27)","v":0}]
["Total Travel",null,{"$f":"SUM(C26:C27)","v":0},{"$f":"SUM(D26:D27)","v":0},0,{"$f":"SUM(F26:F27)","v":0}]
["Conference or Workshop",null,0,0,0,{"$f":"SUM(C29:E29)","v":0}]
["Other Direct Costs"]
["Materials & Supplies",null,0,0,0,{"$f":"SUM(C31:E31)","v":0}]
["Consulting or Contracted Services",null,0,0,0,{"$f":"SUM(C32:E32)","v":0}]
["Publication Cost/Documentation",null,0,0,0,0]
["Internal Reimbursable Service Centers",null,0,0,0,0]
["Misc.",null,0,0,0,0]
["Total Other Direct Costs",null,{"$f":"SUM(C31:C35)","v":0},{"$f":"SUM(D31:D35)","v":0},0,{"$f":"SUM(F31:F35)","v":0}]
["Total MTDC (Drawing F&A) **",null,{"$f":"C16+C25+C28+C29+C36","v":0},{"$f":"D16+D25+D28+D29+D36","v":0},0,{"$f":"F16+F25+F28+F29+F36","v":0}]
["----Excluded Direct Non-F&A Costs----"]
["Participant Support Stipends",null,0,0,0,{"$f":"SUM(C39:E39)","v":0}]
["Participant Support Travel",null,0,0,0,0]
["Participant Support Subsistence ",null,0,0,0,0]
["Other Participant Support Costs",null,0,0,0,0]
["Total Participant Support Costs",null,{"$f":"SUM(C39:C42)","v":0},{"$f":"SUM(D39:D42)","v":0},0,{"$f":"SUM(F39:F42)","v":0}]
["Equipment ABC Machine",null,0,0,0,{"$f":"SUM(F40:F43)","v":0}]
["Equipment XYZ Machine",null,0,0,0,0]
["Total Equipment",null,{"$f":"SUM(C44:C45)","v":0},{"$f":"SUM(D44:D45)","v":0},0,0]
["Subrecipient A",null,0,0,0,{"$f":"SUM(C47:E47)","v":0}]
["Subrecipient B",null,0,0,0,{"$f":"SUM(C48:E48)","v":0}]
["Total Subawards",null,{"$f":"SUM(C47:C48)","v":0},{"$f":"SUM(D47:D48)","v":0},0,0]
["Grad Student Tuition + GSSP ***",null,0,0,0,0]
["Total Excluded Direct Costs",null,{"$f":"C43+C46+C49+C50","v":0},{"$f":"D43+D46+D49+D50","v":0},0,0]
["Facilities and Administrative (Indirect cost) Rate for MTDC Base",0.51500000000000001,0.51500000000000001,0.51500000000000001,0.51500000000000001,0.51500000000000001]
["Facilities and Administrative Costs ",null,{"$f":"C37*C52","v":0},{"$f":"D37*D52","v":0},0,0]
["Total Project Costs \n(MTDC = Excl Cost + F&A)",null,{"$f":"C37+C51+C53","v":0},{"$f":"D37+D51+D53","v":0},0,0]

{"sheet":"Basis of Costs","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"a. Personnel","index":3,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,12],[5,11,6,11],[0,11,0,12],[5,2,5,4],[5,5,5,7],[5,8,5,10],[0,0,0,7],[26,0,26,12],[25,0,25,12],[5,1,6,1],[2,0,3,12],[24,0,24,3],[5,0,6,0],[5,12,6,12]]}
["Detailed Budget Justification",null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions and Summary'!G5","v":0}]
["a. Personnel"]
["PLEASE READ!!!\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. \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.).\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 as Highly Qualified Professionals and Bonafide Administrative personnel per 29 CFR 541","Budget Period 1 Salaries",null,null,"Budget Period 2 Salaries",null,null,"Budget Period 3 Salaries",null,null,"Project Total Effort","Project Total Dollars"]
[null,null,"% or Mo. of Effort","Annual or Monthly Rate","Total Budget Period 1","% or Mo. of Effort","Annual or Monthly Rate","Total Budget Period 2","% or Mo. of Effort","Annual or Monthly Rate","Total Budget Period 3"]
[null,null,null,null,{"$f":"C8*D8","v":0},null,null,{"$f":"F8*G8","v":0},null,null,{"$f":"I8*J8","v":0},{"$f":"SUM(C8+F8+I8)","v":0},{"$f":"SUM(E8+H8+K8)","v":0}]
[null,null,null,null,0,null,null,{"$f":"F9*G9","v":0},null,null,{"$f":"I9*J9","v":0},{"$f":"SUM(C9+F9+I9)","v":0},{"$f":"SUM(E9+H9+K9)","v":0}]
[null,null,null,null,{"$f":"C10*D10","v":0},null,null,0,null,null,0,{"$f":"SUM(C10+F10+I10)","v":0},0]
[null,null,null,null,{"$f":"C11*D11","v":0},null,null,0,null,null,0,{"$f":"SUM(C11+F11+I11)","v":0},0]
[null,null,null,null,0,null,null,0,null,null,0,{"$f":"SUM(C12+F12+I12)","v":0},0]
[null,null,null,null,0,null,null,0,null,null,0,null,0]
[null,null,null,null,{"$f":"C14*D14","v":0},null,null,0,null,null,0,{"$f":"SUM(C14+F14+I14)","v":0},0]
[null,null,null,null,{"$f":"C15*D15","v":0},null,null,0,null,null,0,{"$f":"SUM(C15+F15+I15)","v":0},0]
[null,null,null,null,{"$f":"C16*D16","v":0},null,null,0,null,null,{"$f":"I16*J16","v":0}]
[null,null,null,null,0,null,null,0,null,null,0,{"$f":"SUM(C17+F17+I17)","v":0},{"$f":"SUM(E17+H17+K17)","v":0}]
[null,null,null,null,0,null,null,0,null,null,0]
[null,null,null,null,{"$f":"C19*D19","v":0},null,null,0,null,null,0,null,{"$f":"SUM(E19+H19+K19)","v":0}]
[null,null,null,null,{"$f":"C20*D20","v":0},null,null,0,null,null,0,null,{"$f":"SUM(E20+H20+K20)","v":0}]
[null,null,null,null,{"$f":"C21*D21","v":0},null,null,0,null,null,0,null,{"$f":"SUM(E21+H21+K21)","v":0}]
[null,null,null,null,{"$f":"C22*D22","v":0},null,null,0,null,null,0,null,{"$f":"SUM(E22+H22+K22)","v":0}]
[null,"Total Personnel Costs",null,null,{"$f":"SUM(E8:E22)","v":0},null,null,{"$f":"SUM(H8:H22)","v":0},null,null,{"$f":"SUM(K8:K22)","v":0},{"$f":"J23+G23+D23","v":0},{"$f":"K23+H23+E23","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]
[]
["In order to provide the actual basis and rationale for all costs proposed in this budget and remain compliant with our Cost Accounting Disclosure Statement, please note: \nNCSU operates a Financial Management System compliant with 2 CFR Part 220 (formerly OMB Cir. A-21), which establishes acceptable methods of accounting for the effort of the university's faculty, staff and students.  All permanent personnel direct charged to any Federal contract, grant or other agreement are bona fide \"Professionals or Administrative Personnel\" as defined in 29 CFR Part 541.  There are no labor categories or rates for these Professional personnel, no hourly time records on any faculty or other salaried employees. In order to be responsive and for the purposes of proposal evaluation this budget display is submitted. Any references to hourly rates or hours of effort are ESTIMATES, calculated using the individual salary divided by 173 hours per average work-month.  NC State’s Invoices will reflect dollar values only, NCSU cannot certify hours of effort or hourly rates.  An NCSU Sponsored project budget that is compliant with NC State’s DS-2 Accounting Disclosure is attached for your use.   This display represents the information in the approved financial management system that is subject to audit in accordance with 2 CFR 200.\n"]

{"sheet":"b. Fringe","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,10],[13,0,13,10],[2,0,2,10],[11,0,11,10],[3,4,3,6],[3,7,3,9],[3,1,3,3]]}
["Detailed Budget Justification ",null,null,null,null,null,null,null,null,null,{"$f":"'Instructions and Summary'!$G$5","v":0},null,null,{"$f":"'Instructions and Summary'!G5","v":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."]
["PERSONNEL Type: ","Budget Period 1\nEstimated:",null,null,"Budget Period 2\nEstimated:",null,null,"Budget Period 3\nEstimated:",null,null,"Total Estimated Project Fringe Benefit Costs"]
[null,"Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total"]
["Faculty and Staff",{"$f":"'a. Personnel'!E23-'a. Personnel'!E22","v":0},0.3,{"$f":"C6*B6","v":0},{"$f":"'a. Personnel'!H23","v":0},0.3,{"$f":"E6*F6","v":0},{"$f":"'a. Personnel'!K23","v":0},0.3,{"$f":"H6*I6","v":0},{"$f":"SUM(D6+G6+J6)","v":0}]
["Post-Doctoral Staff",null,0.18,null,null,0.18,null,null,0.18]
["Graduate Student",{"$f":"'a. Personnel'!E22","v":0},0.15,{"$f":"C8*B8","v":0},null,0.15,{"$f":"E8*F8","v":0},null,0.15,{"$f":"H8*I8","v":0},{"$f":"SUM(D8+G8+J8)","v":0}]
["Temporary and undergraduate employees",null,8.4500000000000006E-2,{"$f":"C9*B9","v":0},null,8.4500000000000006E-2,{"$f":"E9*F9","v":0},null,8.4500000000000006E-2,{"$f":"H9*I9","v":0},{"$f":"SUM(D9+G9+J9)","v":0}]
["Total:",{"$f":"SUM(B6:B9)","v":0},null,{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0},null,{"$f":"SUM(G6:G9)","v":0},{"$f":"SUM(H6:H9)","v":0},null,{"$f":"SUM(J6:J9)","v":0},{"$f":"SUM(D10+G10+J10)","v":0}]
[]
["NC State uses a different method for estimating fringe benefits than it uses for charging Fringe Benefits to a sponaored project. The use of a \"average percentage\" has been approved by the Cognizant Federal Audit Agency DHHS. See Explanation of how Fringe Benefits are Estimated for budgeting purposes and how they are charged to Government Contracts and Agreements Below:\n"]
[]
["Additional Explanation/Comments (as necessary)"]

{"sheet":"c. Travel","index":5,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,0,0,1],[58,0,60,7],[38,0,38,7],[4,0,4,7],[21,0,21,7]]}
["Detailed Budget Justification ",null,null,null,null,null,null,{"$f":"'Instructions and Summary'!G5","v":0}]
["c. Travel"]
[]
["Purpose of travel","Depart From","Destination","No. of Days","No. of Travelers","Cost per Traveler","Cost per Trip","Basis for Estimating Costs Refer to Travel Supplement Tabs as necessary."]
["Budget Period 1"]
["Domestic Travel"]
["EXAMPLE ONLY!!!   Visit to PV cell mfr. to set up vendor agreement",null,null,2,2,650,{"$f":"F7*E7","v":1300},"See Travel Supplement Tab for details"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"F13*E13","v":0}]
["Domestic Travel subtotal",null,null,null,null,null,{"$f":"SUM(G8:G13)","v":0}]
["International Travel"]
[null,null,null,null,null,null,{"$f":"F16*E16","v":0}]
[null,null,null,null,null,null,{"$f":"F17*E17","v":0}]
[null,null,null,null,null,null,{"$f":"F18*E18","v":0}]
[null,null,null,null,null,null,{"$f":"F19*E19","v":0}]
["International Travel subtotal",null,null,null,null,null,{"$f":"SUM(G16:G19)","v":0}]
["Budget Period 1 Total",null,null,null,null,null,{"$f":"G14+G20","v":0}]
["Budget Period 2"]
["Domestic Travel"]
[null,null,null,null,null,null,{"$f":"F24*E24","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Domestic Travel subtotal",null,null,null,null,null,{"$f":"SUM(G24:G30)","v":0}]
["International Travel"]
[null,null,null,null,null,null,{"$f":"F33*E33","v":0}]
[null,null,null,null,null,null,{"$f":"F34*E34","v":0}]
[null,null,null,null,null,null,{"$f":"F35*E35","v":0}]
[null,null,null,null,null,null,{"$f":"F36*E36","v":0}]
["International Travel subtotal",null,null,null,null,null,{"$f":"SUM(G33:G36)","v":0}]
["Budget Period 2 Total",null,null,null,null,null,{"$f":"G31+G37","v":0}]
["Budget Period 3"]
["Domestic Travel"]
[null,null,null,null,null,null,{"$f":"F41*E41","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Domestic Travel subtotal",null,null,null,null,null,{"$f":"SUM(G41:G47)","v":0}]
["International Travel"]
[null,null,null,null,null,null,{"$f":"F50*E50","v":0}]
[null,null,null,null,null,null,{"$f":"F51*E51","v":0}]
[null,null,null,null,null,null,{"$f":"F52*E52","v":0}]
[null,null,null,null,null,null,{"$f":"F53*E53","v":0}]
["International Travel subtotal",null,null,null,null,null,{"$f":"SUM(G50:G53)","v":0}]
["Budget Period 3 Total",null,null,null,null,null,{"$f":"G48+G54","v":0}]
["PROJECT TOTAL",null,null,null,null,null,{"$f":"G21+G38+G55","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"d. Equipment","index":6,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,34,5],[0,0,0,3],[1,0,1,5],[15,0,15,5],[21,0,21,5],[2,0,2,5],[5,0,5,5],[31,0,31,3]]}
["Detailed Budget Justification",null,null,null,null,{"$f":"'Instructions and Summary'!G5","v":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,{"$f":"B7*C7","v":40000},"Vendor Quote","Reliability testing of PV modules- Task 4.3"]
[]
[]
[]
[]
[]
[]
[]
["Budget Period 1 Total",null,null,{"$f":"SUM(D8:D14)","v":0}]
["Budget Period 2"]
[null,null,null,{"$f":"B17*C17","v":0}]
[null,null,null,{"$f":"B18*C18","v":0}]
[null,null,null,0]
[null,null,null,0]
["Budget Period 2 Total",null,null,{"$f":"SUM(D17:D20)","v":0}]
["Budget Period 3"]
[null,null,null,{"$f":"B23*C23","v":0}]
[null,null,null,{"$f":"B24*C24","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 3 Total",null,null,{"$f":"SUM(D23:D28)","v":0}]
["PROJECT TOTAL",null,null,{"$f":"D15+D21+D29","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]
["As an Institution of Higher Education, conducting Federally sponsored research and development under the proposed assistance award, NC State requestes that all capital equipments listed be  approved by DOE for Federal funding and categorized as \"Exempt Property\" in accordance with 10 CFR 600.133 and 31 U.S.C 6306, whereby title to the capital equipment items vests in the recipient, (NC State) upon acquisition without further obligation to the Federal Government. "]

{"sheet":"e. Supplies","index":7,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[46,0,48,5],[0,0,0,3],[1,0,1,5],[30,0,30,5],[2,0,2,5],[5,0,5,5],[17,0,17,5],[45,0,45,2],[3,0,3,2]]}
["Detailed Budget Justification ",null,null,null,null,{"$f":"'Instructions and Summary'!G5","v":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"]
["Supplies acquired under Contract valued at >$100,000 see Contractual Tab"]
["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,{"$f":"B15*C15","v":0}]
[null,null,null,{"$f":"B16*C16","v":0}]
["Budget Period 1 Total",null,null,{"$f":"SUM(D8:D16)","v":0}]
["Budget Period 2"]
[null,null,null,{"$f":"B19*C19","v":0}]
[null,null,null,{"$f":"B20*C20","v":0}]
[null,null,null,{"$f":"B21*C21","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 2 Total",null,null,{"$f":"SUM(D19:D29)","v":0}]
["Budget Period 3"]
[null,null,null,{"$f":"B32*C32","v":0}]
[null,null,null,{"$f":"B33*C33","v":0}]
[null,null,null,{"$f":"B34*C34","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 3 Total",null,null,{"$f":"SUM(D32:D42)","v":0}]
["PROJECT TOTAL",null,null,{"$f":"D43+D30+D17","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"f. Contractual","index":8,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[36,0,38,6],[0,0,0,1],[2,0,2,6],[1,0,1,6],[35,0,35,1],[3,0,3,6],[0,4,0,6]]}
["Detailed Budget Justification ",null,null,null,{"$f":"'Instructions and Summary'!G5","v":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-recipient 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. "]
[]
[]
["Collaborating Sub-Recipient\nName/Organization","Purpose/Tasks in SOPO","% Cost Share Committed","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",null,48000,32000,16000,{"$f":"SUM(D8:F8)","v":96000},{"$f":"IF(G8>100000,\"Separate budget forms required for this sub-recipient!\", \" \")","v":" "}]
[null,null,null,null,null,null,{"$f":"SUM(D9:F9)","v":0},{"$f":"IF(G9>=100000,\"Separate budget forms required for this sub-recipient!\", \" \")","v":" "}]
[null,null,null,null,null,null,0,{"$f":"IF(G10>100000,\"Separate budget forms required for this sub-recipient!\", \" \")","v":" "}]
[null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,0," "]
[null,"Sub-total",null,{"$f":"SUM(D9:D16)","v":0},{"$f":"SUM(E9:E16)","v":0},{"$f":"SUM(F9:F15)","v":0},{"$f":"SUM(G9:G16)","v":0}]
[]
["Vendor Contracts >$100,000\nName/Organization","Product or Service, Purpose/Need and Basis of Cost\n(Provide additional support at bottom of page as needed)",null,"Budget Period 1\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","Project Total"]
[null,null,null,null,null,null,{"$f":"SUM(D20:F20)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Sub-total",null,{"$f":"SUM(D20:D25)","v":0},{"$f":"SUM(E20:E25)","v":0},{"$f":"SUM(F20:F25)","v":0},{"$f":"SUM(G20:G25)","v":0}]
[]
["FFRDC\nName/Organization","Purpose",null,"Budget Period 1\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","Project Total"]
[null," ",null,null,null,null,{"$f":"SUM(D29:F29)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D30:F30)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D31:F31)","v":0}]
[null,"Sub-total",null,{"$f":"SUM(D29:D31)","v":0},{"$f":"SUM(E29:E31)","v":0},{"$f":"SUM(F29:F31)","v":0},{"$f":"SUM(D32:F32)","v":0}]
[]
["Total Contractual",null,null,{"$f":"D26+D32+D17","v":0},{"$f":"E26+E32+E17","v":0},{"$f":"F26+F32+F17","v":0},{"$f":"G26+G32+G17","v":0}]
[]
["AdditionalExplanations/Comments (as necessary)"]

{"sheet":"g. Construction","index":9,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,0,15,3],[22,0,22,3],[32,0,34,3],[1,0,1,3],[5,0,5,3],[4,0,4,3],[2,0,2,3],[7,0,7,3]]}
["Detailed Budget Justification",null,null,{"$f":"'Instructions and Summary'!G5","v":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",{"$f":"SUM(B10:B14)","v":0}]
["Budget Period 2"]
[]
[]
[]
[]
[]
["Budget Period 2 Total",{"$f":"SUM(B17:B21)","v":0}]
["Budget Period 3"]
[]
[]
[]
[]
[]
["Budget Period 3 Total",{"$f":"SUM(B24:B28)","v":0}]
["PROJECT TOTAL",{"$f":"-B29+B22+B15","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"h. Other","index":10,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,2],[0,0,0,1],[1,0,1,3],[22,0,22,3],[2,0,2,3],[5,0,5,3],[14,0,14,3]]}
["Detailed Budget Justification",null,null,{"$f":"'Instructions and Summary'!G5","v":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 Institutional Rate","Support of graduate students working on project "]
[]
[]
[]
[]
[]
[]
["Budget Period 1 Total",{"$f":"SUM(B8:B13)","v":0}]
["Budget Period 2"]
[]
[]
[]
[]
[]
[]
["Budget Period 2 Total",{"$f":"SUM(B16:B21)","v":0}]
["Budget Period 3"]
[]
[]
[]
[]
[]
[]
["Budget Period 3 Total",{"$f":"SUM(B24:B29)","v":0}]
["PROJECT TOTAL",{"$f":"B30+B22+B14","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"i. Indirect","index":11,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,7,0,8],[13,5,13,6],[0,0,0,3],[33,0,33,1],[15,5,15,6],[18,0,22,6],[17,0,17,6],[9,5,9,6],[8,5,8,6],[14,5,14,6],[12,5,12,6],[1,1,1,6],[10,5,10,6],[7,5,7,6],[6,5,6,6],[0,5,0,6],[27,0,27,6],[2,0,2,6],[4,5,4,6],[5,5,5,6],[24,0,25,6],[11,5,11,6]]}
["Detailed Budget Justification ",null,null,null,null,{"$f":"'Instructions and Summary'!$G$5","v":0}]
[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",null,0,0]
["General & Administrative (G&A)",0,0,0]
["FCCM Rate, if applicable",0,0,0]
["OTHER Federally Negotiated F&A Rate",0.51500000000000001,0,0]
["Indirect Costs (As Applicable):"]
["Overhead Costs",{"$f":"('a. Personnel'!E23+'b. Fringe'!D10+'c. Travel'!G21+'e. Supplies'!D17+'f. Contractual'!D26+'h. Other'!B8)*B7","v":0},0,0,{"$f":"SUM(B12:D12)","v":0}]
["G&A Costs",0,{"$f":"0*C8","v":0},0,{"$f":"SUM(B13:D13)","v":0}]
["FCCM Costs, if applicable",0,0,0,{"$f":"SUM(B14:D14)","v":0}]
["Calculated on MTDC only see CAS budget",{"$f":"'CAS Institutional Bgt'!D24","v":0},0,0,{"$f":"SUM(B15:D15)","v":0}]
["Total indirect costs requested:",{"$f":"B38","v":0},{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","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.  Calculate the indirect rate dollars and the totals should calculate automatically."]
["XXX_ 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______ 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. "]
[]
[]
[]
[]
[]
["You must provide an explanation (below or in a separate attachment) and show how your indirect cost rate was applied \nto this particular budget in order to come up with the indirect costs shown."]
[]
[]
["Additional Explanations/Comments (as necessary)"]
[]
[]
[]
[]
[]
["NCSU Indirect Costs were calculated as follows:"]
["NCSU Budget Total Direct Costs",null,null,null,null,null,{"$f":"SUM(B35:F35)","v":0}]
["Less Equipment, Tuition & Subs",null,null,null,null,null,{"$f":"SUM(B36:F36)","v":0}]
["NCSU Budget Modified Total Direct Costs",null,null,null,null,null,{"$f":"SUM(B37:F37)","v":0}]
["F&A Rate used for Line 16 (51.5%)",null,null,null,null,null,{"$f":"SUM(B38:F38)","v":0}]
["Sub-Total Federal Share Project Costs",{"$f":"B35+B38","v":0},null,null,null,null,{"$f":"SUM(B39:F39)","v":0}]

{"sheet":"Cost Share","index":12,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,6],[0,0,0,2],[20,0,22,6],[3,0,3,6],[2,0,2,6],[19,0,19,2],[16,4,16,5],[17,3,17,5],[17,0,17,1],[0,4,0,6]]}
["Detailed Budget Justification",null,null,null,{"$f":"'Instructions and Summary'!G5","v":0}]
["Cost Share"]
["PLEASE READ!!! A 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 ","Cost Share Description and BASIS for $ value claimed","Budget Period 1\nCost Share","Budget Period 2\nCost Share","Budget Period 3\nCost Share","Total Project Cost Share"]
["EXAMPLES \nWidget Provider","In-Kind","100 rolls Wire 24 ga copper at Net Cost $1,500 (excludes profit)",30000,75000,45000,{"$f":"SUM(D7:F7)","v":150000}]
["University","In-Kind","4 Graduate Student Personnel, 2 semesters Tuition & Fees(In-state & GSSP)",40016,{"$f":"D8*1.1","v":44017.600000000006},{"$f":"E8*1.1","v":48419.360000000008},132452.96000000002]
["EXAMPLE\nCompany X  ","CASH","Description: X Company will provide $ 10,500  cash contribution in the form of a directed gift to the College Foundation on or about Jan 1, 2015",null,10500,null,{"$f":"SUM(E9:F9)","v":10500}]
["EXAMPLE\nCompany Y","In-Kind","$10,000 in personnel effort on TASK ## Consisting of 81 hours labor by Senior Engineer, DOL Job Classification ###/GS 12 equivalent @ $123.50 per hr. (excludes profit)",null,10000,null,{"$f":"SUM(E10:E10)","v":10000}]
["EXAMPLE \nCompany Z","In-Kind","Materials- 200 each 6 in diameter, XX mm thick Silicon Carbide Wafers @ net cost $84.57 each, (excludes profit) Total $16,914. 20 each week during Sep 1, 2014 through Nov. 15, 2014.",16914.2,null,null,16914.2]
[null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,"Totals",{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0},0,{"$f":"SUM(G12:G15)","v":0}]
[]
["Total Project Cost:  ",null,{"$f":"'Instructions and Summary'!E26","v":0},"Cost Share Percent of Award:",null,null,{"$f":"G16/C18","v":{"$error":"#DIV/0!"}}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"SF-424A","index":13,"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":0},{"$f":"'Cost Share'!D16","v":0},{"$f":"SUM(D8:G8)","v":0}]
["2.","Budget period 2",null,null,null,{"$f":"E26-G9","v":0},{"$f":"'Cost Share'!E16","v":0},{"$f":"SUM(D9:G9)","v":0}]
["3.","Budget period 3",null,null,null,{"$f":"F26-'Cost Share'!F16","v":0},{"$f":"'Cost Share'!F16","v":0},{"$f":"SUM(D10:G10)","v":0}]
["4.",null,null,null,null,null,null,{"$f":"SUM(D11:G11)","v":0}]
["5.","Totals",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0},{"$f":"SUM(G8:G11)","v":0},{"$f":"SUM(H8:H11)","v":0}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total (5)"]
[null,null,null,"Budget period 1","Budget period 2","Budget period 3","(4)"]
[null,"a.  Personnel",null,{"$f":"'Instructions and Summary'!B12","v":0},{"$f":"'Instructions and Summary'!C12","v":0},{"$f":"'Instructions and Summary'!D12","v":0},null,{"$f":"SUM(D16:G16)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"'Instructions and Summary'!B13","v":0},{"$f":"'Instructions and Summary'!C13","v":0},{"$f":"'Instructions and Summary'!D13","v":0},null,0]
[null,"c.  Travel",null,{"$f":"'Instructions and Summary'!B14","v":0},{"$f":"'Instructions and Summary'!C14","v":0},{"$f":"'Instructions and Summary'!D14","v":0},null,0]
[null,"d.  Equipment",null,{"$f":"'Instructions and Summary'!B15","v":0},{"$f":"'Instructions and Summary'!C15","v":0},{"$f":"'Instructions and Summary'!D15","v":0},null,0]
[null,"e.  Supplies",null,{"$f":"'Instructions and Summary'!B16","v":0},{"$f":"'Instructions and Summary'!C16","v":0},{"$f":"'Instructions and Summary'!D16","v":0},null,0]
[null,"f.  Contractual",null,{"$f":"'Instructions and Summary'!B21","v":0},{"$f":"'Instructions and Summary'!C21","v":0},{"$f":"'Instructions and Summary'!D21","v":0},null,0]
[null,"g.  Construction",null,{"$f":"'Instructions and Summary'!B22","v":0},{"$f":"'Instructions and Summary'!C22","v":0},{"$f":"'Instructions and Summary'!D22","v":0},null,0]
[null,"h.  Other",null,{"$f":"'Instructions and Summary'!B23","v":0},{"$f":"'Instructions and Summary'!C23","v":0},{"$f":"'Instructions and Summary'!D23","v":0},null,0]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D16:D23)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0},{"$f":"SUM(G16:G23)","v":0},0]
[null,"j.  Indirect Charges",null,{"$f":"'Instructions and Summary'!B25","v":0},{"$f":"'Instructions and Summary'!C25","v":0},{"$f":"'Instructions and Summary'!D25","v":0},null,0]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"SUM(D24:D25)","v":0},{"$f":"SUM(E24:E25)","v":0},{"$f":"SUM(F24:F25)","v":0},{"$f":"SUM(G24:G25)","v":0},{"$f":"SUM(H24:H25)","v":0}]
[]
["7.","Program Income",null,null,null,null,null,{"$f":"SUM(D28:G28)","v":0}]
[]
[null,null,null,null,null,null,null,"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,null,null,null,null,"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",null,null,null,null,null,{"$f":"SUM(E36:G36)","v":0}]
["9.","Budget period 2",null,null,null,null,null,{"$f":"SUM(E37:G37)","v":0}]
["10.","Budget period 3",null,null,null,null,null,{"$f":"SUM(E38:G38)","v":0}]
["11.",null,null,null,null,null,null,{"$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)"]
[null,null,null,null,"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"]
[]
[]
[]
[null,null,null,null,null,null,null,"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,"              ",null,null,null,null,"Prescribed by OMB Circular A-102"]
[null,null,"Authorized for Local Reproduction"]

{"sheet":"SF-424A Cost Categories","index":14,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,7],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,0,26,7],[27,1,27,2],[30,0,30,1],[30,2,30,5],[30,6,30,7],[19,1,19,2],[20,1,20,2],[12,0,12,1],[12,2,12,7],[13,0,14,0],[13,1,14,2],[13,3,13,6],[13,7,14,7],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,4,7],[0,0,0,1],[1,0,1,7],[2,0,2,7],[3,0,3,1],[3,2,3,7],[0,2,0,3],[0,5,0,6]]}
["Applicant Name:",null,{"$f":"'Instructions and Summary'!B5","v":0},null,"Award Number:",{"$f":"'Instructions and Summary'!B4","v":0}]
["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":"'Instructions and Summary'!B26-G8","v":0},{"$f":"'Cost Share'!D16","v":0},{"$f":"SUM(D8:G8)","v":0}]
["2.","Budget Period 2",null,null,null,{"$f":"'Instructions and Summary'!C26-G9","v":0},{"$f":"'Cost Share'!E16","v":0},{"$f":"SUM(D9:G9)","v":0}]
["3.","Budget Period 3",null,null,null,{"$f":"'Instructions and Summary'!D26-G10","v":0},{"$f":"'Cost Share'!F16","v":0},{"$f":"SUM(D10:G10)","v":0}]
["4.",null,null,null,null,null,null,{"$f":"SUM(D11:G11)","v":0}]
["5.","Totals",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0},{"$f":"SUM(G8:G11)","v":0},{"$f":"SUM(H8:H11)","v":0}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total (5)"]
[null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","(4)"]
[null,"a.  Personnel",null,{"$f":"'a. Personnel'!E23","v":0},{"$f":"'a. Personnel'!H23","v":0},{"$f":"'a. Personnel'!K23","v":0},null,{"$f":"SUM(D16:G16)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"'b. Fringe'!D10","v":0},{"$f":"'b. Fringe'!G10","v":0},{"$f":"'b. Fringe'!J10","v":0},null,0]
[null,"c.  Travel",null,{"$f":"'c. Travel'!G21","v":0},{"$f":"'c. Travel'!G38","v":0},{"$f":"'c. Travel'!G55","v":0},null,0]
[null,"d.  Equipment",null,{"$f":"'d. Equipment'!D15","v":0},{"$f":"'d. Equipment'!D21","v":0},{"$f":"'d. Equipment'!D29","v":0},null,0]
[null,"e.  Supplies",null,{"$f":"'e. Supplies'!D17","v":0},{"$f":"'e. Supplies'!D30","v":0},{"$f":"'e. Supplies'!D43","v":0},null,0]
[null,"f.  Contractual",null,{"$f":"'f. Contractual'!D34","v":0},{"$f":"'f. Contractual'!E34","v":0},{"$f":"'f. Contractual'!F34","v":0},null,0]
[null,"g.  Construction",null,{"$f":"'g. Construction'!B15","v":0},{"$f":"'g. Construction'!B22","v":0},{"$f":"'g. Construction'!B29","v":0},null,0]
[null,"h.  Other",null,{"$f":"'h. Other'!B14","v":0},{"$f":"'h. Other'!B22","v":0},{"$f":"'h. Other'!B30","v":0},null,0]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D16:D23)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0},{"$f":"SUM(G16:G23)","v":0},0]
[null,"j.  Indirect Charges",null,{"$f":"'i. Indirect'!B16","v":0},{"$f":"'i. Indirect'!C16","v":0},{"$f":"'i. Indirect'!D16","v":0},null,0]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"SUM(D24:D25)","v":0},{"$f":"SUM(E24:E25)","v":0},{"$f":"SUM(F24:F25)","v":0},{"$f":"SUM(G24:G25)","v":0},{"$f":"SUM(H24:H25)","v":0}]
[]
["7.","Program Income",null,null,null,null,null,{"$f":"SUM(D28:G28)","v":0}]
[]
[null,null,null,null,null,null,null,"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,null,null,null,null,"Prescribed by OMB Circular A-102"]
["Authorized for Local Reproduction"]

{"sheet":"Travel Summary","index":15,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Summary of Travel Expense and Source of Funding BP-#"]
[" Domestic Travel Total Cost Estimate (Auto filled from Domestic Tab)",{"$f":"'Domestic Travel Sup'!B9","v":0}]
[" Foreign Travel Total Cost Estimate (Auto filled from Foreign Tab)",{"$f":"'Foreign Travel Supp'!B9","v":0}]
["Grand Total  Travel Cost Estimate",{"$f":"SUM(B2:B3)","v":0}]
["Max. Federal Share Requested / NTE",0]
["Estimated Subrecipient Cost Share",0]

{"sheet":"Foreign Travel Supp","index":16,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Purpose of FOREIGN Travel Budget Period # \nEvent/Conference Name:\nConference Location & Dates: \n(if not established show most recent or typical location used for planning and cost estimating) \nReason or purpose for attendance: \n(State why it is important for Subrecipient to attend, and identify the benefit to the Institute for this participation)\n","Total Trip Cost $","Depart From","Travel dates","# Travelers ","# Days","Airfare $","Ground $","Tot. Trans. $","Lodging per night $","Tot. Lodging $","Total Food $","Registration $","Other $","Basis for Estimating Costs"]
[]
[]
[]
[]
[]
[]
[]
["Grand Total Travel Cost Estimate",{"$f":"SUM(B2:B8)","v":0}]
["Max. Federal Share Requested "]
["Estimated Subrecipient Cost Share"]

{"sheet":"Domestic Travel Sup","index":17,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Purpose of DOMESTIC travel Budget Period # \nConference Name:\nConference Location & Dates: \n(if not established show most recent or typical location used for planning and cost estimating) \nReason or purpose for attendance: \n(State why it is important for Subrecipient to attend, and identify the benefit to the Institute for this participation)\n","Total Trip Cost $","Depart From","Travel dates","No. Travelers ","No. Days","Airfare $","Ground $","Tot. Trans. $","Lodging per night $","Tot. Lodging $","Total Food $","Registration $","Other $","Basis for Estimating Costs"]
[]
[]
[]
[]
[]
[]
[]
["Grand Total Travel Cost Estimate",{"$f":"SUM(B2:B8)","v":0}]
["Max. Federal Share Requested "]
["Estimated Subrecipient Cost Share"]