{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Project Data","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i.Indirect","Cost Summary","j.Cost Share","Narrative Summary","SF-424A Cost Categories"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":18,"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","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,2,24,10],[26,2,26,10],[28,1,28,10],[29,1,29,10],[19,2,19,10],[20,2,20,10],[21,2,21,10],[22,2,22,10],[23,2,23,10],[27,2,27,6],[25,2,25,10],[18,2,18,10],[14,1,14,2],[15,1,15,10],[17,1,17,10],[12,1,13,10]]}
{"$rows_empty":12}
[null,"BUDGET JUSTIFICATION WORKBOOK"]
[]
[null,"OVERVIEW"]
[null,"The Budget Justification Workbook is designed as a multipurpose tool. It is used as a template during the duration and life of the award agreement. At the application phase, DOE is aware that applicants may be able to only provide estimates for some line items, while other line items may not be included in the budget submitted with the application for various reasons. A budget submitted at the time of application may contain a less detailed budget than a potential revised budget submitted in future agreement amendments or modifications. \n\nThe Budget Justification Workbook will be used as a template for multiple phases of the project, it is designed to provide budget line items of varying levels of detail for inclusion in the application and future potential award phases. \n\nApplicants may modify the Budget Justification Workbook as stated on the Instructions and Summary Tab of the workbook. To modify the Workbook, applicants can add rows as needed throughout tabs a. through j. As noted in the Instructions and Summary tab, if rows are added, formulas/calculations may need to be adjusted by the preparer.\n\nWithin the larger context of the award lifecycle, the Budget Justification Workbook may be used as a tool during award negotiations and throughout the award. During award negotiations, DOE will work with each entity to request supporting documentation to support the budget and to design award specific terms and conditions to address any budget issues or concerns. The complexity of the project, the entity's responses, and DOE’s review will impact the negotiation timeline and process. "]
[]
[null,"WORKSHEET PREPARTION INSTRUCTIONS"]
[null,"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."]
[null,"2.","Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated. "]
[null,"3.","Enter detailed support for the project costs identified for each budget category line item within each worksheet tab to auto-populate the summary tab."]
[null,"4.","The total budget presented on tabs a. through i. must include both Federal (OCED) and Non-Federal (cost share) portions."]
[null,"5.","All costs incurred by the preparer's subrecipients, 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."]
[null,"6.","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"]
[null,"7.","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, Cost Summary, and Narrative Summary tabs. If your project contains more than five budget periods, consult your OCED contact before adding additional budget period rows or columns. "]
[null,8,"Community Benefits activity costs must be specifically highlighted within each tab and line item so they are easily identifiable to OCED reviewers (see example on a. Personnel tab). On the Narrative Summary tab, describe the roles and responsibilities, expertise, and percentage time commitment of the staff who will have responsibility to implement the Community Benefits activities."]
[null,9,"All budget period cost categories are rounded to the nearest dollar."]
[null,10,"A Budget Narrative Justification is required for each budget category except i. Indirect and Cost Share."]
[null,"BURDEN DISCLOSURE STATEMENT"]
[null,"\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."]

{"sheet":"Project Data","index":1,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,9],[12,1,12,9],[13,1,13,9],[20,1,20,9],[1,0,1,9],[3,0,3,9],[6,1,6,9],[7,1,7,9],[19,1,19,9],[14,1,14,9],[8,1,8,9],[10,1,10,9],[11,1,11,9]]}
[]
["ORGANIZATION AND APPLICATION DATA"]
[]
["PROJECT PHASE: [enter phase number]"]
[]
[]
["Prime Applicant/Recipient Name:"]
["Prime Applicant/Recipient UEI:"]
["Project Title:"]
["OCED Provision/Program and Funding Announcement Number"]
["Application Control #:"]
["Period of Performance:"]
["Current Budget Period: "]
["Point of Contact Name:"]
["Point of Contact Email:"]
[]
[]
[]
[]
["Does this award have any Subawards? "]
["List all Subrecipient(s) provided in f. Contractual tab:"]
["Have you provided a Budget Workbook for each subaward as a separate attachment? "]

{"sheet":"a. Personnel","index":2,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,1,53,20],[10,1,10,20],[11,12,11,14],[11,9,11,11],[48,1,48,4],[7,1,7,18],[8,1,8,18],[0,1,0,20],[11,6,11,8],[11,3,11,5],[11,15,11,17],[3,1,3,18],[4,1,4,18],[5,1,5,18],[6,1,6,18],[2,1,2,18]]}
[null,"a. Personnel"]
[]
[null,"INSTRUCTIONS"]
[null,"1. List project costs solely for employees of the Applicant/Recipient.  All personnel costs for subrecipients and contractors must be included under f. Contractual. A separate budget workbook must be submitted for each subrecipient."]
[null,"2. All personnel should be identified by position title.  Do not provide any employee names.  Enter the amount of time (e.g., hours or % of time) and the base hourly rate.  The total personnel costs by position and total budget will automatically calculate. The basis of the rate estimate must be identified."]
[null,"3. If a loaded labor rate is used, then provide a breakout of the costs in the Budget Narrative Justification section below.  Loaded labor rates should not include any fringe benefits, overhead costs, or profit. Fringe benefits must be included under b. Fringe and overhead costs must be included in i. Indirect as applicable. Profit is not allowable under federal financial assistance awards."]
[null,"4. If a position and hours are attributed to multiple employees (e.g. Technician working 4000 hours), then you must identify the number of employees for that position title."]
[null,"5. Each budget period is rounded to the nearest dollar."]
[null,"6. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item on the table. "]
[null,null,null,"Budget Period 1",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Budget Period 4",null,null,"Budget Period 5"]
[null,"WBS/Task #","Position Title","Time \n(Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 1","Time (Hrs) ","Hourly Rate\n($/Hr)","Total Budget Period 2","Time (Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 3","Time (Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 4","Time (Hrs)","Hourly Rate\n($/Hr)","Total Budget Period 5","Project Total Hours","Project Total Dollars","Basis of Estimate"]
[]
[null,1,"Sr. Engineer (EXAMPLE)",2000,85,{"$f":"D15*E15","v":170000},200,50,{"$f":"G15*H15","v":10000},200,50,{"$f":"J15*K15","v":10000},200,50,{"$f":"M15*N15","v":10000},200,50,{"$f":"P15*Q15","v":10000},{"$f":"D15+G15+J15+M15+P15","v":2800},{"$f":"SUM(F15,I15,L15,O15,R15)","v":210000}]
[null,2,"Technicians (2) (EXAMPLE)",4000,20,80000,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"D16+G16+J16+M16+P16","v":4000},{"$f":"SUM(F16,I16,L16,O16,R16)","v":80000}]
[null,3,"(CBP) Community Specialist (EXAMPLE)",500,75,{"$f":"D17*E17","v":37500},100,75,{"$f":"G17*H17","v":7500},0,0,{"$f":"J17*K17","v":0},0,0,{"$f":"M17*N17","v":0},0,0,{"$f":"P17*Q17","v":0},{"$f":"D17+G17+J17+M17+P17","v":600},45000]
[{"$nulls":5},{"$f":"D18*E18","v":0},null,null,{"$f":"G18*H18","v":0},null,null,{"$f":"J18*K18","v":0},null,null,{"$f":"M18*N18","v":0},null,null,{"$f":"P18*Q18","v":0},{"$f":"D18+G18+J18+M18+P18","v":0},0]
[{"$nulls":5},{"$f":"D19*E19","v":0},null,null,{"$f":"G19*H19","v":0},null,null,{"$f":"J19*K19","v":0},null,null,{"$f":"M19*N19","v":0},null,null,{"$f":"P19*Q19","v":0},0,0]
[{"$nulls":5},{"$f":"D20*E20","v":0},null,null,{"$f":"G20*H20","v":0},null,null,{"$f":"J20*K20","v":0},null,null,{"$f":"M20*N20","v":0},null,null,{"$f":"P20*Q20","v":0},0,0]
[{"$nulls":5},{"$f":"D21*E21","v":0},null,null,{"$f":"G21*H21","v":0},null,null,{"$f":"J21*K21","v":0},null,null,{"$f":"M21*N21","v":0},null,null,{"$f":"P21*Q21","v":0},0,{"$f":"SUM(F21,I21,L21,O21,R21)","v":0}]
[{"$nulls":5},{"$f":"D22*E22","v":0},null,null,{"$f":"G22*H22","v":0},null,null,{"$f":"J22*K22","v":0},null,null,{"$f":"M22*N22","v":0},null,null,{"$f":"P22*Q22","v":0},0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},{"$f":"D25*E25","v":0},null,null,{"$f":"G25*H25","v":0},null,null,{"$f":"J25*K25","v":0},null,null,{"$f":"M25*N25","v":0},null,null,{"$f":"P25*Q25","v":0},0,{"$f":"SUM(F25,I25,L25,O25,R25)","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},{"$f":"D31*E31","v":0},null,null,{"$f":"G31*H31","v":0},null,null,{"$f":"J31*K31","v":0},null,null,{"$f":"M31*N31","v":0},null,null,{"$f":"P31*Q31","v":0},0,{"$f":"SUM(F31,I31,L31,O31,R31)","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,0,0]
[{"$nulls":5},{"$f":"D41*E41","v":0},null,null,{"$f":"G41*H41","v":0},null,null,{"$f":"J41*K41","v":0},null,null,{"$f":"M41*N41","v":0},null,null,{"$f":"P41*Q41","v":0},0,{"$f":"SUM(F41,I41,L41,O41,R41)","v":0}]
[null,null,"TOTAL PERSONNEL",null,null,{"$f":"SUBTOTAL(109,Perssonnel_Table[Total Budget Period 1])-SUM(F15:F16)","v":37500},null,null,{"$f":"SUBTOTAL(109,Perssonnel_Table[Total Budget Period 2])-SUM(I15:I16)","v":7500},null,null,{"$f":"SUBTOTAL(109,Perssonnel_Table[Total Budget Period 3])-SUM(L15:L16)","v":0},null,null,{"$f":"SUBTOTAL(109,Perssonnel_Table[Total Budget Period 4])-SUM(O15:O16)","v":0},null,null,{"$f":"SUBTOTAL(109,Perssonnel_Table[Total Budget Period 5])-SUM(R15:R16)","v":0},null,{"$f":"SUBTOTAL(109,Perssonnel_Table[Project Total Dollars])-SUM(T15:T16)","v":45000}]
[]
[null,null,"Input Cost Share $ ",{"$nulls":16},{"$f":"SUM(F44,I44,L44,O44,R44)","v":0}]
[null,null,"Cost Share % of Total Personnel",null,null,{"$f":"IF(F42,F44/F42,IF(F44,F44/F44,0))","v":0},null,null,{"$f":"IF(I42,I44/I42,IF(I44,I44/I44,0))","v":0},null,null,{"$f":"IF(L42,L44/L42,IF(L44,L44/L44,0))","v":0},null,null,{"$f":"IF(O42,O44/O42,IF(O44,O44/O44,0))","v":0},null,null,{"$f":"IF(R42,R44/R42,IF(R44,R44/R44,0))","v":0},null,{"$f":"SUMPRODUCT(F45:R45,Perssonnel_Table[[#Totals],[Total Budget Period 1]:[Total Budget Period 5]])/Perssonnel_Table[[#Totals],[Project Total Dollars]]","v":0}]
[{"$nulls":4},"BP1 Total",{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 1]]","v":37500},null,"BP2 Total",{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 2]]","v":7500},null,"BP3 Total",{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 3]]","v":0},null,"BP4 Total",{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 4]]","v":0},null,"BP5 Total",{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 5]]","v":0},"Total",{"$f":"Perssonnel_Table[[#Totals],[Project Total Dollars]]","v":45000}]
[{"$nulls":4},"% of Total",{"$f":"F46/T46","v":0.83333333333333337},null,"% of Total",{"$f":"I46/T46","v":0.16666666666666666},null,"% of Total",{"$f":"L46/T46","v":0},null,"% of Total",{"$f":"O46/T46","v":0},null,"% of Total",{"$f":"R46/T46","v":0}]
[]
[null,"Budget Narrative Justification: "]
[null,"The Community Specialist (CBP) will work directly with local government leaders and citizens in the project area to ensure they are part of the decisions that impact the project and their community. This CPB Community Specialist has 10 years of community engagement experience on clean energy projects such as wind and solar and will work approximately 25% FTE during BP 1 and 5% in BP 2. (EXAMPLE)"]

{"sheet":"b. Fringe","index":3,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,0,17],[2,1,2,17],[3,1,3,17],[25,1,26,1],[25,17,26,17],[9,1,9,17],[5,1,5,17],[7,1,7,17],[52,1,56,17],[4,1,4,17],[10,1,10,17],[22,1,22,17],[25,2,25,4],[25,5,25,7],[25,8,25,10],[25,11,25,13],[25,14,25,16],[24,1,24,17],[6,1,6,17],[51,1,51,3],[16,5,16,7]]}
[null,"b. Fringe Benefits"]
[]
[null,"INSTRUCTIONS"]
[null,"1. Fill out the table below by position title. If all employees receive the same fringe benefits, you can enter \"Total Personnel\" in the Labor Type column instead of listing out all position titles.   "]
[null,"2. 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 Budget Narrative Justification section below. "]
[null,"3. The fringe benefit rates should be applied to all positions, regardless of whether those funds will be supported by Federal funding amount or Recipient Cost Share."]
[null,"4.  Each budget period is rounded to the nearest dollar."]
[null,"5. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[null,"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. Once rates are entered in the blue boxes in the instructions, they will become available as a dropdown in the \"Rate\" columns."]
[]
[null,"There is not a current federally approved rate agreement negotiated and available.*"]
[null,"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.** "]
[]
[null,"Rate Description",null,"Rate"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[null,"*When this option is checked, the entity preparing this form shall submit an indirect rate proposal. For additional details, refer to OCED's Indirect Cost Rate Agreement and Rate Proposal Guidance found at https://www.energy.gov/sites/default/files/2023-06/OCED%20Indirect%20Cost%20Rate%20Agreement%20and%20Rate%20Proposal%20Guidance.pdf. \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."]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item on the table. "]
[null,"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,"Total Project "]
[null,null,"Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total","Personnel Costs","Rate","Total"]
[null,"Labor Type","Personnel Costs","Rate","Total","Personnel Costs2","Rate3","Total4","Personnel Costs5","Rate6","Total7","Personnel Costs8","Rate9","Total10","Personnel Costs11","Rate12","Total13","Column14"]
[null,"EXAMPLE!!! Sr. Engineer negotiated and/approved rate",170000,0.2,{"$f":"C29*D29","v":34000},10000,0.2,{"$f":"F29*G29","v":2000},10000,0.2,{"$f":"I29*J29","v":2000},10000,0.2,{"$f":"L29*M29","v":2000},10000,0.2,{"$f":"O29*P29","v":2000},{"$f":"E29+H29+K29","v":38000}]
[{"$nulls":4},0,null,null,{"$f":"IF(G30<>\"\",G30*F30,0)","v":0},null,null,{"$f":"IF(J30<>\"\",J30*I30,0)","v":0},null,null,{"$f":"IF(M30<>\"\",M30*L30,0)","v":0},null,null,{"$f":"IF(P30<>\"\",P30*O30,0)","v":0},{"$f":"SUM(E30+H30+K30+N30+Q30)","v":0}]
[{"$nulls":4},0,null,null,{"$f":"IF(G31<>\"\",G31*F31,0)","v":0},null,null,{"$f":"IF(J31<>\"\",J31*I31,0)","v":0},null,null,{"$f":"IF(M31<>\"\",M31*L31,0)","v":0},null,null,{"$f":"IF(P31<>\"\",P31*O31,0)","v":0},{"$f":"SUM(E31+H31+K31+N31+Q31)","v":0}]
[{"$nulls":4},0,null,null,0,null,null,{"$f":"IF(J32<>\"\",J32*I32,0)","v":0},null,null,0,null,null,{"$f":"IF(P32<>\"\",P32*O32,0)","v":0},0]
[{"$nulls":4},{"$f":"IF(D33<>\"\",D33*C33,0)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(E34+H34+K34+N34+Q34)","v":0}]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},{"$f":"IF(D38<>\"\",D38*C38,0)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},{"$f":"IF(D39<>\"\",D39*C39,0)","v":0},null,null,{"$f":"IF(G39<>\"\",G39*F39,0)","v":0},null,null,{"$f":"IF(J39<>\"\",J39*I39,0)","v":0},null,null,{"$f":"IF(M39<>\"\",M39*L39,0)","v":0},null,null,{"$f":"IF(P39<>\"\",P39*O39,0)","v":0},{"$f":"SUM(E39+H39+K39+N39+Q39)","v":0}]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[{"$nulls":4},0,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,"TOTAL FRINGE",null,null,{"$f":"SUBTOTAL(109,Fringe_Table[Total])-E29","v":0},null,null,{"$f":"SUBTOTAL(109,Fringe_Table[Total4])-H29","v":0},null,null,{"$f":"SUBTOTAL(109,Fringe_Table[Total7])-K29","v":0},null,null,{"$f":"SUBTOTAL(109,Fringe_Table[Total10])-N29","v":0},null,null,{"$f":"SUBTOTAL(109,Fringe_Table[Total13])-Q29","v":0},{"$f":"SUBTOTAL(109,Fringe_Table[Column14])-R29","v":0}]
[]
[null,"Input Cost Share $ ",{"$nulls":15},{"$f":"SUM(E47+H47+K47+N47+Q47)","v":0}]
[null,"Cost Share % of Total Fringe",null,null,{"$f":"IF(E45,E47/E45,IF(E47,E47/E47,0))","v":0},null,null,{"$f":"IF(H45,H47/H45,IF(H47,H47/H47,0))","v":0},null,null,{"$f":"IF(K45,K47/K45,IF(K47,K47/K47,0))","v":0},null,null,{"$f":"IF(N45,N47/N45,IF(N47,N47/N47,0))","v":0},null,null,{"$f":"IF(Q45,Q47/Q45,IF(Q47,Q47/Q47,0))","v":0},{"$f":"SUMPRODUCT(E48:Q48,Fringe_Table[[#Totals],[Total]:[Total13]])/Fringe_Table[[#Totals],[Column14]]","v":{"$error":"#DIV/0!"}}]
[null,null,null,"BP1 Total",{"$f":"Fringe_Table[[#Totals],[Total]]","v":0},null,"BP2 Total",{"$f":"Fringe_Table[[#Totals],[Total4]]","v":0},null,"BP3 Total",{"$f":"Fringe_Table[[#Totals],[Total7]]","v":0},null,"BP4 Total",{"$f":"Fringe_Table[[#Totals],[Total10]]","v":0},null,"BP5 Total",{"$f":"Fringe_Table[[#Totals],[Total13]]","v":0}]
[null,null,null,"% of Total",{"$f":"Fringe_Table[[#Totals],[Total]]/Fringe_Table[[#Totals],[Column14]]","v":{"$error":"#DIV/0!"}},null,"% of Total",{"$f":"H49/Fringe_Table[[#Totals],[Column14]]","v":{"$error":"#DIV/0!"}},null,"% of Total",{"$f":"K49/Fringe_Table[[#Totals],[Column14]]","v":{"$error":"#DIV/0!"}},null,"% of Total",{"$f":"N49/Fringe_Table[[#Totals],[Column14]]","v":{"$error":"#DIV/0!"}},null,"% of Total",{"$f":"Q49/Fringe_Table[[#Totals],[Column14]]","v":{"$error":"#DIV/0!"}}]
[]
[null,"Budget Narrative Justification:"]

{"sheet":"c. Travel","index":4,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[6,1,6,13],[7,1,7,13],[8,1,8,13],[9,1,9,13],[0,1,0,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[5,1,5,13],[11,1,11,13],[12,1,12,11],[14,1,14,13],[10,1,10,13],[15,1,15,13],[87,1,87,2],[88,1,92,13],[106,1,106,2],[107,1,111,13],[66,9,66,11],[84,9,84,11],[85,9,85,11],[103,9,103,11],[104,9,104,11],[95,1,95,13],[76,1,76,13],[68,1,68,2],[69,1,73,13],[27,9,27,11],[28,9,28,11],[46,9,46,11],[47,9,47,11],[65,9,65,11],[50,1,54,13],[30,1,30,2],[49,1,49,2],[38,1,38,13],[31,1,35,13],[57,1,57,13]]}
[null,"c. Travel"]
[{"$nulls":17},"Domestic"]
[null,"INSTRUCTIONS",{"$nulls":15},"International"]
[null,"1.  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."]
[null,"2.  All listed travel must be necessary for performance of the project and WBS/Tasks assigned for each proposed travel line item.     "]
[null,"3. Only travel that is directly associated with this award should be included as a direct travel cost to the award.    "]
[null,"4. Federal travel regulations are contained within the applicable cost principles for all entity types.         "]
[null,"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. "]
[null,"6. The number of days is inclusive of day of departure and day of return.              "]
[null,"7. Recipients should enter City and State (or City and Country for International travel) in the Depart from and Destination fields.     "]
[null,"8. Each budget period is rounded to the nearest dollar."]
[null,"9. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item on the table. "]
[null,"Budget Period 1"]
[null,"WBS/Task #","Purpose of Travel","Domestic or International","Depart From","Destination","No. of Days","No. of Travelers","Lodging per night","Flight or Train per Traveler","Ground Transportation per Traveler","Per Diem Rate Per Day","Cost per Trip","Basis of Estimate"]
[null,1,"EXAMPLE: Visit to PV manufacturer","Domestic",null,null,2,2,250,500,100,80,{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":2020},"Current GSA Rates"]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"(Travel_BP1[[#This Row],[Lodging per night]]*(Travel_BP1[[#This Row],[No. of Days]]-1)*Travel_BP1[[#This Row],[No. of Travelers]])+(Travel_BP1[[#This Row],[Flight or Train per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]])+Travel_BP1[[#This Row],[Ground Transportation per Traveler]]*Travel_BP1[[#This Row],[No. of Travelers]]+Travel_BP1[[#This Row],[Per Diem Rate Per Day]]*Travel_BP1[[#This Row],[No. of Days]]*Travel_BP1[[#This Row],[No. of Travelers]]","v":0}]
[null,null,"Budget Period 1 Total",{"$nulls":9},{"$f":"SUBTOTAL(109,Travel_BP1[Cost per Trip])-M18","v":0}]
[{"$nulls":9},"Input Cost Share $ "]
[{"$nulls":9},"Cost Share % of BP1 Travel",null,null,{"$f":"IF(M27,M28/M27,IF(M28,M28/M28,0))","v":0}]
[]
[null,"Budget 1 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 2"]
[null,"WBS/Task #","Purpose of Travel","Domestic or International","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 of Estimate"]
[{"$nulls":12},{"$f":"Travel_BP2[[#This Row],[Lodging per Traveler]]*(Travel_BP2[[#This Row],[No. of Days]]-1)*Travel_BP2[[#This Row],[No. of Travelers]]+(Travel_BP2[[#This Row],[Flight per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Vehicle per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Per Diem Per Traveler]]*Travel_BP2[[#This Row],[No. of Days]]*Travel_BP2[[#This Row],[No. of Travelers]])","v":0}]
[{"$nulls":12},{"$f":"Travel_BP2[[#This Row],[Lodging per Traveler]]*(Travel_BP2[[#This Row],[No. of Days]]-1)*Travel_BP2[[#This Row],[No. of Travelers]]+(Travel_BP2[[#This Row],[Flight per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Vehicle per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Per Diem Per Traveler]]*Travel_BP2[[#This Row],[No. of Days]]*Travel_BP2[[#This Row],[No. of Travelers]])","v":0}]
[{"$nulls":12},{"$f":"Travel_BP2[[#This Row],[Lodging per Traveler]]*(Travel_BP2[[#This Row],[No. of Days]]-1)*Travel_BP2[[#This Row],[No. of Travelers]]+(Travel_BP2[[#This Row],[Flight per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Vehicle per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Per Diem Per Traveler]]*Travel_BP2[[#This Row],[No. of Days]]*Travel_BP2[[#This Row],[No. of Travelers]])","v":0}]
[{"$nulls":12},{"$f":"Travel_BP2[[#This Row],[Lodging per Traveler]]*(Travel_BP2[[#This Row],[No. of Days]]-1)*Travel_BP2[[#This Row],[No. of Travelers]]+(Travel_BP2[[#This Row],[Flight per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Vehicle per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Per Diem Per Traveler]]*Travel_BP2[[#This Row],[No. of Days]]*Travel_BP2[[#This Row],[No. of Travelers]])","v":0}]
[{"$nulls":12},{"$f":"Travel_BP2[[#This Row],[Lodging per Traveler]]*(Travel_BP2[[#This Row],[No. of Days]]-1)*Travel_BP2[[#This Row],[No. of Travelers]]+(Travel_BP2[[#This Row],[Flight per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Vehicle per Traveler]]*Travel_BP2[[#This Row],[No. of Travelers]])+(Travel_BP2[[#This Row],[Per Diem Per Traveler]]*Travel_BP2[[#This Row],[No. of Days]]*Travel_BP2[[#This Row],[No. of Travelers]])","v":0}]
[null,null,"Budget Period 2 Total",{"$nulls":9},{"$f":"SUBTOTAL(109,Travel_BP2[Cost per Trip])","v":0}]
[{"$nulls":9},"Input Cost Share $ ",null,null,0]
[{"$nulls":9},"Cost Share % of BP1 Travel",null,null,{"$f":"IF(M46,M47/M46,IF(M47,M47/M47,0))","v":0}]
[]
[null,"Budget 2 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 3"]
[null,"WBS/Task #","Purpose of Travel","Domestic or International","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 of Estimate"]
[{"$nulls":12},{"$f":"Travel_BP3[[#This Row],[Lodging per Traveler]]*(Travel_BP3[[#This Row],[No. of Days]]-1)*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Flight per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Vehicle per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Per Diem Per Traveler]]*Travel_BP3[[#This Row],[No. of Days]]*Travel_BP3[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP3[[#This Row],[Lodging per Traveler]]*(Travel_BP3[[#This Row],[No. of Days]]-1)*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Flight per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Vehicle per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Per Diem Per Traveler]]*Travel_BP3[[#This Row],[No. of Days]]*Travel_BP3[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP3[[#This Row],[Lodging per Traveler]]*(Travel_BP3[[#This Row],[No. of Days]]-1)*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Flight per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Vehicle per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Per Diem Per Traveler]]*Travel_BP3[[#This Row],[No. of Days]]*Travel_BP3[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP3[[#This Row],[Lodging per Traveler]]*(Travel_BP3[[#This Row],[No. of Days]]-1)*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Flight per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Vehicle per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Per Diem Per Traveler]]*Travel_BP3[[#This Row],[No. of Days]]*Travel_BP3[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP3[[#This Row],[Lodging per Traveler]]*(Travel_BP3[[#This Row],[No. of Days]]-1)*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Flight per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Vehicle per Traveler]]*Travel_BP3[[#This Row],[No. of Travelers]]+Travel_BP3[[#This Row],[Per Diem Per Traveler]]*Travel_BP3[[#This Row],[No. of Days]]*Travel_BP3[[#This Row],[No. of Travelers]]","v":0}]
[null,null,"Budget Period 3 Total",{"$nulls":9},{"$f":"SUBTOTAL(109,Travel_BP3[Cost per Trip])","v":0}]
[{"$nulls":9},"Input Cost Share $ "]
[{"$nulls":9},"Cost Share % of BP1 Travel",null,null,{"$f":"IF(M65,M66/M65,IF(M66,M66/M66,0))","v":0}]
[]
[null,"Budget 3 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 4"]
[null,"WBS/Task #","Purpose of Travel","Domestic or International","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 of Estimate"]
[{"$nulls":12},{"$f":"Travel_BP4[[#This Row],[Lodging per Traveler]]*(Travel_BP4[[#This Row],[No. of Days]]-1)*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Flight per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Vehicle per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Per Diem Per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]*Travel_BP4[[#This Row],[No. of Days]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP4[[#This Row],[Lodging per Traveler]]*(Travel_BP4[[#This Row],[No. of Days]]-1)*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Flight per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Vehicle per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Per Diem Per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]*Travel_BP4[[#This Row],[No. of Days]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP4[[#This Row],[Lodging per Traveler]]*(Travel_BP4[[#This Row],[No. of Days]]-1)*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Flight per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Vehicle per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Per Diem Per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]*Travel_BP4[[#This Row],[No. of Days]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP4[[#This Row],[Lodging per Traveler]]*(Travel_BP4[[#This Row],[No. of Days]]-1)*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Flight per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Vehicle per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Per Diem Per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]*Travel_BP4[[#This Row],[No. of Days]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP4[[#This Row],[Lodging per Traveler]]*(Travel_BP4[[#This Row],[No. of Days]]-1)*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Flight per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Vehicle per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]+Travel_BP4[[#This Row],[Per Diem Per Traveler]]*Travel_BP4[[#This Row],[No. of Travelers]]*Travel_BP4[[#This Row],[No. of Days]]","v":0}]
[null,null,"Budget Period 4 Total",{"$nulls":9},{"$f":"SUBTOTAL(109,Travel_BP4[Cost per Trip])","v":0}]
[{"$nulls":9},"Input Cost Share $ "]
[{"$nulls":9},"Cost Share % of BP1 Travel",null,null,{"$f":"IF(M84,M85/M84,IF(M85,M85/M85,0))","v":0}]
[]
[null,"Budget 4 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 5"]
[null,"WBS/Task #","Purpose of Travel","Domestic or International","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 of Estimate"]
[{"$nulls":12},{"$f":"Travel_BP5[[#This Row],[Lodging per Traveler]]*(Travel_BP5[[#This Row],[No. of Days]]-1)*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Flight per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Vehicle per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Per Diem Per Traveler]]*Travel_BP5[[#This Row],[No. of Days]]*Travel_BP5[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP5[[#This Row],[Lodging per Traveler]]*(Travel_BP5[[#This Row],[No. of Days]]-1)*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Flight per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Vehicle per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Per Diem Per Traveler]]*Travel_BP5[[#This Row],[No. of Days]]*Travel_BP5[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP5[[#This Row],[Lodging per Traveler]]*(Travel_BP5[[#This Row],[No. of Days]]-1)*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Flight per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Vehicle per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Per Diem Per Traveler]]*Travel_BP5[[#This Row],[No. of Days]]*Travel_BP5[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP5[[#This Row],[Lodging per Traveler]]*(Travel_BP5[[#This Row],[No. of Days]]-1)*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Flight per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Vehicle per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Per Diem Per Traveler]]*Travel_BP5[[#This Row],[No. of Days]]*Travel_BP5[[#This Row],[No. of Travelers]]","v":0}]
[{"$nulls":12},{"$f":"Travel_BP5[[#This Row],[Lodging per Traveler]]*(Travel_BP5[[#This Row],[No. of Days]]-1)*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Flight per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Vehicle per Traveler]]*Travel_BP5[[#This Row],[No. of Travelers]]+Travel_BP5[[#This Row],[Per Diem Per Traveler]]*Travel_BP5[[#This Row],[No. of Days]]*Travel_BP5[[#This Row],[No. of Travelers]]","v":0}]
[null,null,"Budget Period 5 Total",{"$nulls":9},{"$f":"SUBTOTAL(109,Travel_BP5[Cost per Trip])","v":0}]
[{"$nulls":9},"Input Cost Share $ "]
[{"$nulls":9},"Cost Share % of BP1 Travel",null,null,{"$f":"IF(M103,M104/M103,IF(M104,M104/M104,0))","v":0}]
[]
[null,"Budget 5 Narrative Justification:"]

{"sheet":"d. Equipment","index":5,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,1,0,9],[31,1,31,9],[50,1,50,9],[8,1,8,9],[10,1,10,9],[11,1,11,9],[2,1,2,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[3,1,3,9],[99,1,99,2],[100,1,104,9],[23,1,23,2],[24,1,28,9],[42,1,42,2],[69,1,69,9],[88,1,88,9],[43,1,47,9],[61,1,61,2],[62,1,66,9],[80,1,80,2],[81,1,85,9]]}
[null,"d. Equipment"]
[]
[null,"INSTRUCTIONS"]
[]
[null,"1. Equipment is generally defined as an item with an acquisition cost greater than $10,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. "]
[null,"2. List all equipment below, providing a basis of cost (e.g. contractor quotes, catalog prices, prior invoices, etc.). Justify items in the Budget Narrative Justification as they apply to the Statement of Project Objectives. If it is existing equipment, provide logical support for the estimated value shown."]
[null,"3. If selected, provide a contractor quote for all equipment items over $50,000 in price during award negotiations. 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."]
[null,"4. Each budget period is rounded to the nearest dollar."]
[null,"5. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item in each table. "]
[null,"Budget Period 1"]
[null,"WBS/Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[null,"3,4,5","EXAMPLE:  Thermal shock chamber",2,70000,{"$f":"Equipment_BP1[[#This Row],[Qty]]*Equipment_BP1[[#This Row],[Unit Cost         ]]","v":140000},null,null,"Contractor Quote - Attached","Reliability testing of PV modules- Task 4.3"]
[{"$nulls":5},{"$f":"Equipment_BP1[[#This Row],[Qty]]*Equipment_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP1[[#This Row],[Qty]]*Equipment_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP1[[#This Row],[Qty]]*Equipment_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP1[[#This Row],[Qty]]*Equipment_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP1[[#This Row],[Qty]]*Equipment_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 1 Total",null,null,{"$f":"SUBTOTAL(109,Equipment_BP1[[Total Cost             ]])-F14","v":0},{"$f":"SUBTOTAL(109,Equipment_BP1[Federal])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP1[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H20","v":0}]
[null,null,"Cost Share % of BP1 Equipment",null,null,{"$f":"IF(F20,F21/F20,IF(F21,F21/F21,0))","v":0}]
[]
[null,"Budget 1 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 2"]
[null,"WBS/Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Equipment_BP2[[#This Row],[Qty]]*Equipment_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP2[[#This Row],[Qty]]*Equipment_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP2[[#This Row],[Qty]]*Equipment_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP2[[#This Row],[Qty]]*Equipment_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP2[[#This Row],[Qty]]*Equipment_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 2 Total",null,null,{"$f":"SUBTOTAL(109,Equipment_BP2[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP2[Federal])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP2[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H39","v":0}]
[null,null,"Cost Share % of BP2 Equipment",null,null,{"$f":"IF(F39,F40/F39,IF(F40,F40/F40,0))","v":0}]
[]
[null,"Budget 2 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 3"]
[null,"WBS/Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Equipment_BP3[[#This Row],[Qty]]*Equipment_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP3[[#This Row],[Qty]]*Equipment_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP3[[#This Row],[Qty]]*Equipment_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP3[[#This Row],[Qty]]*Equipment_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP3[[#This Row],[Qty]]*Equipment_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 3 Total",null,null,{"$f":"SUBTOTAL(109,Equipment_BP3[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP3[Federal])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP3[Cost Share])","v":0}]
[null,null,"Cost Share $ "]
[null,null,"Cost Share % of BP3 Equipment",null,null,{"$f":"IF(F58,F59/F58,IF(F59,F59/F59,0))","v":0}]
[]
[null,"Budget 3 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 4"]
[null,"WBS/Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Equipment_BP4[[#This Row],[Qty]]*Equipment_BP4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP4[[#This Row],[Qty]]*Equipment_BP4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP4[[#This Row],[Qty]]*Equipment_BP4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP4[[#This Row],[Qty]]*Equipment_BP4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP4[[#This Row],[Qty]]*Equipment_BP4[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 4 Total",null,null,{"$f":"SUBTOTAL(109,Equipment_BP4[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP4[Federal])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP4[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H77","v":0}]
[null,null,"Cost Share % of BP4 Equipment",null,null,{"$f":"IF(F77,F78/F77,IF(F78,F78/F78,0))","v":0}]
[]
[null,"Budget 4 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 5"]
[null,"WBS/Task #","Equipment Item","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Equipment_BP5[[#This Row],[Qty]]*Equipment_BP5[[#This Row],[Unit Cost         ]]","v":0},{"$f":"Equipment_BP5[[#This Row],[Total Cost             ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP5[[#This Row],[Qty]]*Equipment_BP5[[#This Row],[Unit Cost         ]]","v":0},{"$f":"Equipment_BP5[[#This Row],[Total Cost             ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP5[[#This Row],[Qty]]*Equipment_BP5[[#This Row],[Unit Cost         ]]","v":0},{"$f":"Equipment_BP5[[#This Row],[Total Cost             ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP5[[#This Row],[Qty]]*Equipment_BP5[[#This Row],[Unit Cost         ]]","v":0},{"$f":"Equipment_BP5[[#This Row],[Total Cost             ]]","v":0}]
[{"$nulls":5},{"$f":"Equipment_BP5[[#This Row],[Qty]]*Equipment_BP5[[#This Row],[Unit Cost         ]]","v":0},{"$f":"Equipment_BP5[[#This Row],[Total Cost             ]]","v":0}]
[null,null,"Budget Period 5 Total",null,null,{"$f":"SUBTOTAL(109,Equipment_BP5[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP5[Federal])","v":0},{"$f":"SUBTOTAL(109,Equipment_BP5[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H96","v":0}]
[null,null,"Cost Share % of BP5 Equipment",null,null,{"$f":"IF(F96,F97/F96,IF(F97,F97/F97,0))","v":0}]
[]
[null,"Budget 5 Narrative Justification:"]

{"sheet":"e. Supplies","index":6,"n_rows":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,1,2,9],[3,1,3,9],[92,1,92,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[8,1,8,9],[32,1,32,9],[12,1,12,9],[52,1,52,9],[11,1,11,9],[72,1,72,9],[105,1,109,9],[7,1,7,9],[9,1,9,7],[24,1,24,2],[25,1,29,9],[44,1,44,2],[45,1,49,9],[64,1,64,2],[65,1,69,9],[84,1,84,2],[85,1,89,9],[104,1,104,2]]}
[null,"c. Supplies"]
[]
[null,"INSTRUCTIONS"]
[null,"1. Supplies are generally defined as an item with an acquisition cost of $10,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. "]
[null,"2. List all proposed supplies below, providing a basis of costs (e.g. contractor quotes, catalog prices, prior invoices, etc.). Justify the need for the Supplies in the Budget Narrative Justification as they apply to the Statement of Project Objectives. Note that Supply items must be direct costs to the project in 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."]
[null,"3. Multiple supply items valued at $10,000 or less used to assemble an equipment item with a value greater than $10,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 Grants and Agreements Officer for proper categorization.  "]
[null,"4. Add rows as needed. If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[null,"5. Each budget period is rounded to the nearest dollar."]
[null,"6. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item in each table. "]
[null,"Budget Period 1"]
[null,"WBS/Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Federal ","Cost Share","Basis of Estimate","Justification of need"]
[null,"4,6","EXAMPLE:  Wireless DAS components",10,360,{"$f":"Supplies_BP1[[#This Row],[Qty]]*Supplies_BP1[[#This Row],[Unit Cost         ]]","v":3600},3000,600,"Catalog price","For Alpha prototype - Task 2.4"]
[{"$nulls":5},{"$f":"Supplies_BP1[[#This Row],[Qty]]*Supplies_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP1[[#This Row],[Qty]]*Supplies_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP1[[#This Row],[Qty]]*Supplies_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP1[[#This Row],[Qty]]*Supplies_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP1[[#This Row],[Qty]]*Supplies_BP1[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 1 Total",null,null,{"$f":"SUBTOTAL(109,Supplies_BP1[[Total Cost             ]])-F15","v":0},{"$f":"SUBTOTAL(109,Supplies_BP1[[Federal ]])-G15","v":0},{"$f":"SUBTOTAL(109,Supplies_BP1[Cost Share])-H15","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H21","v":0}]
[null,null,"Cost Share % of BP1 Supplies",null,null,{"$f":"IF(F21,F22/F21,IF(F22,F22/F22,0))","v":0}]
[]
[null,"Budget 1 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 2"]
[null,"WBS/Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Federal ","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Supplies_BP2[[#This Row],[Qty]]*Supplies_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP2[[#This Row],[Qty]]*Supplies_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP2[[#This Row],[Qty]]*Supplies_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP2[[#This Row],[Qty]]*Supplies_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP2[[#This Row],[Qty]]*Supplies_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP2[[#This Row],[Qty]]*Supplies_BP2[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 2 Total",null,null,{"$f":"SUBTOTAL(109,Supplies_BP2[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP2[[Federal ]])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP2[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H41","v":0}]
[null,null,"Cost Share % of BP2 Supplies",null,null,{"$f":"IF(F41,F42/F41,IF(F42,F42/F42,0))","v":0}]
[]
[null,"Budget 2 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 3"]
[null,"WBS/Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Supplies_BP3[[#This Row],[Qty]]*Supplies_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP3[[#This Row],[Qty]]*Supplies_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP3[[#This Row],[Qty]]*Supplies_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP3[[#This Row],[Qty]]*Supplies_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP3[[#This Row],[Qty]]*Supplies_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP3[[#This Row],[Qty]]*Supplies_BP3[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 3 Total",null,null,{"$f":"SUBTOTAL(109,Supplies_BP3[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP3[Federal])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP3[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H61","v":0}]
[null,null,"Cost Share % of BP3 Supplies",null,null,{"$f":"IF(F61,F62/F61,IF(F62,F62/F62,0))","v":0}]
[]
[null,"Budget 3 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 4"]
[null,"WBS/Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Supplies_BP_4[[#This Row],[Qty]]*Supplies_BP_4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP_4[[#This Row],[Qty]]*Supplies_BP_4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP_4[[#This Row],[Qty]]*Supplies_BP_4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP_4[[#This Row],[Qty]]*Supplies_BP_4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP_4[[#This Row],[Qty]]*Supplies_BP_4[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP_4[[#This Row],[Qty]]*Supplies_BP_4[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 4 Total",null,null,{"$f":"SUBTOTAL(109,Supplies_BP_4[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP_4[Federal])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP_4[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H81","v":0}]
[null,null,"Cost Share % of BP4 Supplies",null,null,{"$f":"IF(F81,F82/F81,IF(F82,F82/F82,0))","v":0}]
[]
[null,"Budget 4 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 5"]
[null,"WBS/Task #","General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[{"$nulls":5},{"$f":"Supplies_BP5[[#This Row],[Qty]]*Supplies_BP5[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP5[[#This Row],[Qty]]*Supplies_BP5[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP5[[#This Row],[Qty]]*Supplies_BP5[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP5[[#This Row],[Qty]]*Supplies_BP5[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP5[[#This Row],[Qty]]*Supplies_BP5[[#This Row],[Unit Cost         ]]","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP5[[#This Row],[Qty]]*Supplies_BP5[[#This Row],[Unit Cost         ]]","v":0}]
[null,null,"Budget Period 5 Total",null,null,{"$f":"SUBTOTAL(109,Supplies_BP5[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP5[Federal])","v":0},{"$f":"SUBTOTAL(109,Supplies_BP5[Cost Share])","v":0}]
[null,null,"Cost Share $ ",null,null,{"$f":"H101","v":0}]
[null,null,"Cost Share % of BP5 Supplies",null,null,{"$f":"IF(F101,F102/F101,IF(F102,F102/F102,0))","v":0}]
[]
[null,"Budget 5 Narrative Justification:"]

{"sheet":"f. Contractual","index":7,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,1,6,9],[8,1,8,9],[0,1,0,9],[41,1,45,9],[15,1,15,21],[16,6,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,17],[16,18,16,20],[40,1,40,3],[14,1,14,5],[13,1,13,5],[12,1,12,5],[3,1,3,9],[4,1,4,9],[5,1,5,9],[7,1,7,9]]}
[null,"f. Contractual (includes Contractor, Subrecipients, and FFRDCs)"]
[]
[null,"INSTRUCTIONS",{"$nulls":23},"Sub-Recipient"]
[null,"1. The Applicant/Recipient or Subrecipient completing this form must provide all costs related to subawards, contractors, and FFRDCs partners in the applicable boxes below.",{"$nulls":23},"Contractor"]
[null,"2. Subrecipients (partners, subawards): Subrecipients must submit a separate Budget Workbook describing all project costs and calculations. These subrecipient Budget Workbooks may be completed by either the subrecipients themselves or by the preparer of this form.  The budget totals on the subrecipient's Budget Workbooks must match the subrecipient 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. ",{"$nulls":23},"FFRDC"]
[null,"3. 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."]
[null,"4. 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."]
[null,"5. Each budget period is rounded to the nearest dollar."]
[null,"6. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[]
[{"$nulls":6},"BP 1 ","BP 2","BP 3","BP 4","BP5","Project Total"]
[null,"Subrecipient Totals",{"$nulls":4},{"$f":"SUMIF(Contractual[Type],$C$19,Contractual[BP 1 Total])-48000","v":0},{"$f":"SUMIF(Contractual[Type],$C$19,Contractual[BP 2 Total])-32000","v":0},{"$f":"SUMIF(Contractual[Type],$C$19,Contractual[BP 3 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$C$19,Contractual[BP 4 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$C$19,Contractual[BP 5 Total])","v":0},{"$f":"SUM(G13:K13)","v":0}]
[null,"Contractor Totals",{"$nulls":4},{"$f":"SUMIF(Contractual[Type],$Z$4,Contractual[BP 1 Total])-32900","v":0},{"$f":"SUMIF(Contractual[Type],$Z$4,Contractual[BP 2 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$4,Contractual[BP 3 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$4,Contractual[BP 4 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$4,Contractual[BP 5 Total])","v":0},{"$f":"SUM(G14:K14)","v":0}]
[null,"FFRDC Totals",{"$nulls":4},{"$f":"SUMIF(Contractual[Type],$Z$5,Contractual[BP 1 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$5,Contractual[BP 2 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$5,Contractual[BP 3 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$5,Contractual[BP 4 Total])","v":0},{"$f":"SUMIF(Contractual[Type],$Z$5,Contractual[BP 5 Total])","v":0},{"$f":"SUM(G15:K15)","v":0}]
[null,"To add additional lines, use the \"TAB\" button on the last item on the table. "]
[{"$nulls":6},"Budget Period 1 ",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Budget Period 4",null,null,"Budget Period 5"]
[null,"WBS/Task #","Type","Subrecipient/Contractor/FFRDC\nName/Organization","Subrecipient Unique Entity Identifier (UEI)","Purpose and Basis of Cost","BP 1 Total","BP 1 Federal ","BP 1 Cost Share","BP 2 Total","BP2 Federal","BP 2 Cost Share","BP 3 Total","BP3 Federal","BP3 Cost Share","BP 4 Total","BP4 Federal ","BP4 Cost Share","BP 5 Total","BP5 Federal ","BP5 Cost Share","Project Total"]
[null,"2,4","Subrecipient","EXAMPLE: XYZ Corp. ",null,"Partner to develop optimal lens for Gen 2 product. Cost estimate based on personnel hours.",{"$f":"SUM(Contractual[[#This Row],[BP 1 Federal ]:[BP 1 Cost Share]])","v":48000},8000,40000,{"$f":"Contractual[[#This Row],[BP2 Federal]]+Contractual[[#This Row],[BP 2 Cost Share]]","v":32000},8000,24000,{"$f":"Contractual[[#This Row],[BP3 Federal]]+Contractual[[#This Row],[BP3 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP4 Federal ]]+Contractual[[#This Row],[BP4 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP5 Federal ]]+Contractual[[#This Row],[BP5 Cost Share]]","v":0},null,null,{"$f":"SUM(G19,J19,M19,P19,S19)","v":80000}]
[null,6,"Contractor","EXAMPLE: ABC Contracting ",null,"Contractor for developing robotics to perform lens inspection. Estimate provided by contractor.",{"$f":"SUM(Contractual[[#This Row],[BP 1 Federal ]:[BP 1 Cost Share]])","v":32900},32900,null,{"$f":"Contractual[[#This Row],[BP2 Federal]]+Contractual[[#This Row],[BP 2 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP3 Federal]]+Contractual[[#This Row],[BP3 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP4 Federal ]]+Contractual[[#This Row],[BP4 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP5 Federal ]]+Contractual[[#This Row],[BP5 Cost Share]]","v":0},null,null,32900]
[null,null,"FFRDC",null,null,null,{"$f":"SUM(Contractual[[#This Row],[BP 1 Federal ]:[BP 1 Cost Share]])","v":0},null,null,{"$f":"Contractual[[#This Row],[BP2 Federal]]+Contractual[[#This Row],[BP 2 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP3 Federal]]+Contractual[[#This Row],[BP3 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP4 Federal ]]+Contractual[[#This Row],[BP4 Cost Share]]","v":0},null,null,{"$f":"Contractual[[#This Row],[BP5 Federal ]]+Contractual[[#This Row],[BP5 Cost Share]]","v":0},null,null,0]
[{"$nulls":21},{"$f":"SUM(G21,J22,M22,P22,S22)","v":0}]
[{"$nulls":21},{"$f":"SUM(G22,J23,M23,P23,S23)","v":0}]
[{"$nulls":21},0]
[{"$nulls":21},{"$f":"SUM(G25,J25,M25,P25,S25)","v":0}]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},0]
[{"$nulls":21},{"$f":"SUM(G34,J34,M34,P34,S34)","v":0}]
[{"$nulls":21},{"$f":"SUM(G35,J35,M35,P35,S35)","v":0}]
[{"$nulls":21},{"$f":"SUM(G36,J36,M36,P36,S36)","v":0}]
[{"$nulls":5},"Totals",{"$f":"SUBTOTAL(109,Contractual[BP 1 Total])-SUM(G19:G21)","v":0},{"$f":"SUBTOTAL(109,Contractual[[BP 1 Federal ]])-SUM(H19:H21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP 1 Cost Share])-SUM(I19:I21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP 2 Total])-SUM(J19:J21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP2 Federal])-SUM(K19:K21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP 2 Cost Share])-SUM(L19:L21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP 3 Total])-SUM(M19:M21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP3 Federal])-SUM(N19:N21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP3 Cost Share])-SUM(O19:O21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP 4 Total])-SUM(P19:P21)","v":0},{"$f":"SUBTOTAL(109,Contractual[[BP4 Federal ]])-SUM(Q19:Q21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP4 Cost Share])-SUM(R19:R21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP 5 Total])-SUM(S19:S21)","v":0},{"$f":"SUBTOTAL(109,Contractual[[BP5 Federal ]])-SUM(T19:T21)","v":0},{"$f":"SUBTOTAL(109,Contractual[BP5 Cost Share])-SUM(U19:U21)","v":0},{"$f":"SUBTOTAL(109,Contractual[Project Total])-SUM(V19:V21)","v":0}]
[{"$nulls":5},"Cost Share $ ",{"$f":"I37","v":0},null,null,{"$f":"L37","v":0},null,null,{"$f":"O37","v":0},null,null,{"$f":"R37","v":0},null,null,{"$f":"U37","v":0},null,null,{"$f":"SUM(G38,J38,M38,P38,S38)","v":0}]
[{"$nulls":5},"Cost Share % of Total Contractual",{"$f":"IF(G37,G38/G37,IF(G38,G38/G38,0))","v":0},null,null,{"$f":"IF(J37,J38/J37,IF(J38,J38/J38,0))","v":0},null,null,{"$f":"IF(M37,M38/M37,IF(M38,M38/M38,0))","v":0},null,null,{"$f":"IF(P37,P38/P37,IF(P38,P38/P38,0))","v":0},null,null,{"$f":"IF(S37,S38/S37,IF(S38,S38/S38,0))","v":0},null,null,{"$f":"SUMPRODUCT(G39:S39,Contractual[[#Totals],[BP 1 Total]:[BP 5 Total]])/Contractual[[#Totals],[Project Total]]","v":{"$error":"#DIV/0!"}}]
[]
[null,"Budget Narrative Justification:"]

{"sheet":"g. Construction","index":8,"n_rows":111,"n_cols":8,"rows_kept":111,"cut":false,"hidden":false,"merged":[[0,1,0,7],[3,1,3,7],[2,1,2,7],[4,1,4,7],[5,1,5,7],[110,1,110,2],[110,4,110,5],[30,1,30,5],[50,1,50,5],[70,1,70,5],[90,1,90,5],[42,1,42,2],[43,1,47,5],[63,1,67,5],[83,1,87,5],[103,1,107,5],[102,1,102,2],[62,1,62,2],[82,1,82,2],[22,1,22,2],[7,1,7,7],[6,1,6,7],[23,1,27,5],[9,1,9,7],[10,1,10,7]]}
[null,"g. Construction"]
[]
[null,"INSTRUCTIONS"]
[null,"1. Construction, for the purpose of budgeting, is defined as all types of work done on a particular building, including renovations, erecting, altering, or remodeling. "]
[null,"2. Construction costs are normally broken out into the other cost categories or captured in d. Equipment, f. Contractual, h. Other."]
[null,"3. There should be no construction costs in Budget Period 1 or 2.  If there are construction related costs anticipated during either budget period 1 or 2, contact your Grants and Agreements Officer for guidance."]
[null,"4. Each budget period is rounded to the nearest dollar."]
[null,"5. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item in each table. "]
[null,"Budget Period 1"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[null,null,"test",500000,30000,20000]
[]
[]
[]
[]
[]
[null,null,"Budget Period 1 Total",{"$f":"SUBTOTAL(109,Construction_BP1[[Total Cost             ]])-D13","v":0},{"$f":"SUBTOTAL(109,Construction_BP1[Federal])-E13","v":0},{"$f":"SUBTOTAL(109,Construction_BP1[Cost Share])-F13","v":0}]
[null,null,"Cost Share $ ",{"$f":"F19","v":0}]
[null,null,"Cost Share % of BP1 Supplies",{"$f":"IF(D19,D20/D19,IF(D20,D20/D20,0))","v":0}]
[]
[null,"Budget 1 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 2"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 2 Total",{"$f":"SUBTOTAL(109,Construction_BP2[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Construction_BP2[Federal])","v":0},{"$f":"SUBTOTAL(109,Construction_BP2[Cost Share])","v":0}]
[null,null,"Cost Share $ ",{"$f":"F39","v":0}]
[null,null,"Cost Share % of BP2 Supplies",{"$f":"IF(D39,D40/D39,IF(D40,D40/D40,0))","v":0}]
[]
[null,"Budget 2 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 3"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 3 Total",{"$f":"SUBTOTAL(109,Construction_BP3[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Construction_BP3[Federal])","v":0},{"$f":"SUBTOTAL(109,Construction_BP3[Cost Share])","v":0}]
[null,null,"Cost Share $ ",{"$f":"F59","v":0}]
[null,null,"Cost Share % of BP3 Supplies",{"$f":"IF(D59,D60/D59,IF(D60,D60/D60,0))","v":0}]
[]
[null,"Budget 3 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 4"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 4 Total",{"$f":"SUBTOTAL(109,Construction_BP4[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Construction_BP4[Federal])","v":0},{"$f":"SUBTOTAL(109,Construction_BP4[Cost Share])","v":0}]
[null,null,"Cost Share $ ",{"$f":"F79","v":0}]
[null,null,"Cost Share % of BP4 Supplies",{"$f":"IF(D79,D80/D79,IF(D80,D80/D80,0))","v":0}]
[]
[null,"Budget 4 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 5"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 5 Total",{"$f":"SUBTOTAL(109,Construction_BP5[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,Construction_BP5[Federal])","v":0},{"$f":"SUBTOTAL(109,Construction_BP5[Cost Share])","v":0}]
[null,null,"Cost Share $ ",{"$f":"F99","v":0}]
[null,null,"Cost Share % of BP5 Supplies",{"$f":"IF(D99,D100/D99,IF(D100,D100/D100,0))","v":0}]
[]
[null,"Budget 5 Narrative Justification:"]
{"$rows_empty":7}
[null,"TOTAL CONSTRUCTION",null,{"$f":"SUM(Construction_BP1[[#Totals],[Total Cost             ]],Construction_BP2[[#Totals],[Total Cost             ]],Construction_BP3[[#Totals],[Total Cost             ]],Construction_BP4[[#Totals],[Total Cost             ]],Construction_BP5[[#Totals],[Total Cost             ]])","v":0}]

{"sheet":"h. Other","index":9,"n_rows":112,"n_cols":8,"rows_kept":112,"cut":false,"hidden":false,"merged":[[83,1,83,2],[103,1,103,2],[24,1,28,7],[10,1,10,7],[9,1,9,7],[71,1,71,7],[64,1,68,7],[51,1,51,7],[44,1,48,7],[31,1,31,7],[23,1,23,2],[43,1,43,2],[63,1,63,2],[111,1,111,2],[111,4,111,5],[104,1,108,7],[91,1,91,7],[84,1,88,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[7,1,7,7],[0,1,0,7],[6,1,6,7],[5,1,5,7]]}
[null,"h. Other"]
[]
[null,"INSTRUCTIONS"]
[null,"1. 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)."]
[null,"2. Basis of estimates are established calculations and Formulae used to determine costs."]
[null,"3. Purpose and Basis of cost are items such as vendor quotes, prior purchases of similar or like items, published price list, etc."]
[null,"4. Each budget period is rounded to the nearest dollar."]
[null,"5. You must provide a Budget Narrative Justification for the current phase of this project.  The narrative explains and justifies the projected costs attributed to each line item or category within the budget and ties the budget to the proposed deliverables and statement of work."]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item in each table. "]
[null,"Budget Period 1"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Estimate","Justification of need"]
[null,5,"EXAMPLE!!!  Grad student tuition - tasks 1-3",16000,null,null,"Established UCD costs","Support of graduate students and standard DOL pay "]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 1 Total",{"$f":"SUBTOTAL(109,Other_BP1[[Total Cost             ]])-D13","v":0},{"$f":"SUBTOTAL(109,E14:E19)-E13","v":0},{"$f":"SUBTOTAL(109,F14:F19)-F13","v":0}]
[null,null,"Input Cost Share $ ",{"$f":"F20","v":0}]
[null,null,"Input Cost Share % of BP1 Other Costs",{"$f":"IF(D20,D21/D20,IF(D21,D21/D21,0))","v":0}]
[]
[null,"Budget 1 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 2"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Cost","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 2 Total",{"$f":"SUBTOTAL(109,Other_BP2[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,E34:E39)","v":0},{"$f":"SUBTOTAL(109,F34:F39)","v":0}]
[null,null,"Input Cost Share $ ",{"$f":"F40","v":0}]
[null,null,"Input Cost Share % of BP2 Other Costs",{"$f":"IF(D40,D41/D40,IF(D41,D41/D41,0))","v":0}]
[]
[null,"Budget 2 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 3"]
[null,"WBS/Task #","General Description ","Total Cost             ","Federal","Cost Share","Basis of Cost","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 3 Total",{"$f":"SUBTOTAL(109,Other_BP3[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,E54:E59)","v":0},{"$f":"SUBTOTAL(109,F54:F59)","v":0}]
[null,null,"Input Cost Share $ ",{"$f":"F60","v":0}]
[null,null,"Input Cost Share % of BP3 Other Costs",{"$f":"IF(D60,D61/D60,IF(D61,D61/D61,0))","v":0}]
[]
[null,"Budget 3 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 4"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Cost","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 4 Total",{"$f":"SUBTOTAL(109,Other_BP4[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,E74:E79)","v":0},{"$f":"SUBTOTAL(109,F74:F79)","v":0}]
[null,null,"Input Cost Share $ ",{"$f":"F80","v":0}]
[null,null,"Input Cost Share % of BP4 Other Costs",{"$f":"IF(D80,D81/D80,IF(D81,D81/D81,0))","v":0}]
[]
[null,"Budget 4 Narrative Justification:"]
{"$rows_empty":7}
[null,"Budget Period 5"]
[null,"WBS/Task #","General Description","Total Cost             ","Federal","Cost Share","Basis of Cost","Justification of need"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Period 5 Total",{"$f":"SUBTOTAL(109,Other_BP5[[Total Cost             ]])","v":0},{"$f":"SUBTOTAL(109,E94:E99)","v":0},{"$f":"SUBTOTAL(109,F94:F99)","v":0}]
[null,null,"Input Cost Share $ ",{"$f":"F100","v":0}]
[null,null,"Input Cost Share % of BP5 Other Costs",{"$f":"IF(D100,D101/D100,IF(D101,D101/D101,0))","v":0}]
[]
[null,"Budget 5 Narrative Justification:"]
{"$rows_empty":7}
[null,"TOTAL OTHER DIRECT COSTS",null,{"$f":"SUM(D20, D40, D60, D80, D100)","v":0}]

{"sheet":"i.Indirect","index":10,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,8,39,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[27,1,27,9],[8,1,8,9],[9,1,9,9],[0,1,0,9],[2,1,2,9],[5,1,5,9],[4,1,4,9],[3,1,3,9],[7,1,7,9],[6,1,6,9],[17,1,25,9],[11,2,11,9],[13,2,13,9],[12,2,12,9],[15,1,15,9]]}
[null,"c. Indirect"]
[]
[null,"INSTRUCTIONS"]
[null,"1. 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. "]
[null,"2. 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. "]
[null,"3. The indirect rate should be applied to both the Federal funding amount and Recipient Cost Share.        "]
[null,"4. Note:  When you elect to use the de minimis indirect cost rate: \n                     -  You may use this rate to support your cost share contributions. \n                     -  You cannot claim \"unrecovered indirect costs\" and therefore you cannot use “unrecovered indirect costs” as part of your cost share contribution.  \n\n                   When you use an approved negotiated indirect cost rate:\n                     -  You may use this rate to support your cost share contribution. \n                     -  You can claim “unrecovered indirect costs” as a cost share contribution with prior approval from the Grants and Agreements Officer."]
[null,"5. Each budget period is rounded to the nearest dollar."]
[]
[null,"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.  "]
[]
[null,null,"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 Grants and Agreements Officer for this project.*"]
[null,null,"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.**"]
[null,null,"This organization has elected to apply a de minimis rate in accordance with 2 CFR 200.414(f)."]
[]
[null,"*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. For additional details, refer to OCED's Indirect Cost Rate Agreement and Rate Proposal Guidance found at https://www.energy.gov/sites/default/files/2023-06/OCED%20Indirect%20Cost%20Rate%20Agreement%20and%20Rate%20Proposal%20Guidance.pdf.  "]
[]
[null,"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).  "]
{"$rows_empty":9}
[null,"To add additional lines, use the \"TAB\" button on the last item in each table. "]
[null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Total","Explanation of BASE "]
[null,"Provide ONLY Applicable Rates:"]
[null,"Overhead Rate",0,0,0,0,0,null,"MTDC"]
[null,"General & Administrative (G&A)",0,0,0,0,0]
[null,"FCCM Rate, if applicable",0,0,0,0,0]
[null,"OTHER Indirect Rate",0,0,0,0,0]
[null,"Indirect Costs (As Applicable):"]
[null,"Overhead Costs",{"$f":"('Cost Summary'!C20+'Cost Summary'!C21+'Cost Summary'!C22+'Cost Summary'!C24+'Cost Summary'!C31-'h. Other'!D16+(25000*8))*C31","v":0},{"$f":"('Cost Summary'!D20+'Cost Summary'!D21+'Cost Summary'!D22+'Cost Summary'!D24+'Cost Summary'!D31)*D31","v":0},{"$f":"('Cost Summary'!E20+'Cost Summary'!E21+'Cost Summary'!E22+'Cost Summary'!E24+'Cost Summary'!E31)*E31","v":0},{"$f":"('Cost Summary'!F20+'Cost Summary'!F21+'Cost Summary'!F22+'Cost Summary'!F24+'Cost Summary'!F31)*F31","v":0},{"$f":"('Cost Summary'!G20+'Cost Summary'!G21+'Cost Summary'!G22+'Cost Summary'!G24+'Cost Summary'!G31)*G31","v":0},{"$f":"SUM(C36:G36)","v":0}]
[null,"G&A Costs",{"$nulls":5},{"$f":"SUM(C37:G37)","v":0}]
[null,"FCCM Costs, if applicable",{"$nulls":5},{"$f":"SUM(C38:G38)","v":0}]
[null," OTHER Indirect Costs",{"$nulls":5},{"$f":"SUM(C39:G39)","v":0}]
[null,"Total Indirect Costs Requested:",{"$f":"SUM(C36:C39)","v":0},{"$f":"SUM(D36:D39)","v":0},{"$f":"SUM(E36:E39)","v":0},{"$f":"SUM(F36:F39)","v":0},{"$f":"SUM(G36:G39)","v":0},{"$f":"SUM(C40:G40)","v":0}]
[]
[null,"Input Cost Share $ ",{"$nulls":5},{"$f":"SUM(C42+D42+E42+F42+G42)","v":0}]
[null,"Cost Share % of Total Indirect",{"$f":"IF(C40,C42/C40,IF(C42,C42/C42,0))","v":0},0,0,0,0,0]

{"sheet":"Cost Summary","index":11,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[17,2,17,9],[1,1,2,9],[3,1,3,9],[10,1,16,1],[5,1,5,9],[6,1,6,9],[7,1,7,9],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6]]}
[]
[null,"Summary of Budget Category Costs Proposed"]
[]
[null,"(Note:  The values in this summary table are from entries in each budget category worksheet)"]
[]
[null,"INSTRUCTIONS"]
[null,"The table below will auto-populate with numbers from the other worksheets. \n\nONLY complete information in Column I - Add the corresponding Proposed Budget Period Dates and any Comments."]
[]
[]
[]
[null,null,null,"Federal","Cost Share",null,null,"Total Costs","Cost Share %","Proposed Budget Period Dates"]
[null,null,"Budget Period 1",{"$f":"H12-E12","v":37500},{"$f":"C34","v":0},null,null,{"$f":"C35","v":37500},{"$f":"IF(H12>0,E12/H12,0)","v":0},"##/##/#### - ##/##/####"]
[null,null,"Budget Period 2",{"$f":"H13-E13","v":7500},{"$f":"D34","v":0},null,null,{"$f":"D35","v":7500},0,"##/##/#### - ##/##/####"]
[null,null,"Budget Period 3",{"$f":"H14-E14","v":0},{"$f":"E34","v":0},null,null,{"$f":"E35","v":0},0,"##/##/#### - ##/##/####"]
[null,null,"Budget Period 4",{"$f":"H15-E15","v":0},{"$f":"F34","v":0},null,null,{"$f":"F35","v":0},0,"##/##/#### - ##/##/####"]
[null,null,"Budget Period 5",{"$f":"H16-E16","v":0},{"$f":"G34","v":0},null,null,{"$f":"G35","v":0},0,"##/##/#### - ##/##/####"]
[null,null,"Total",{"$f":"SUM(D12:D16)","v":45000},{"$f":"SUM(E12:E16)","v":0},null,null,{"$f":"SUM(H12:H16)","v":45000},0]
[null,"Section B - Budget Categories"]
[null,"CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"," Total Costs","% of Project","Comments (as needed)"]
[null,"a. Personnel",{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 1]]","v":37500},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 2]]","v":7500},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 3]]","v":0},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 4]]","v":0},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 5]]","v":0},{"$f":"SUM(C20:G20)","v":45000},{"$f":"IF(H20>0,H20/H17,0)","v":1}]
[null,"b. Fringe Benefits",{"$f":"Fringe_Table[[#Totals],[Total]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total4]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total7]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total10]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total13]]","v":0},{"$f":"SUM(C21:G21)","v":0},{"$f":"IF(H21>0,H21/H17,0)","v":0}]
[null,"c. Travel",{"$f":"Travel_BP1[[#Totals],[Cost per Trip]]","v":0},{"$f":"Travel_BP2[[#Totals],[Cost per Trip]]","v":0},{"$f":"Travel_BP3[[#Totals],[Cost per Trip]]","v":0},{"$f":"Travel_BP4[[#Totals],[Cost per Trip]]","v":0},{"$f":"Travel_BP5[[#Totals],[Cost per Trip]]","v":0},{"$f":"SUM(C22:G22)","v":0},{"$f":"IF(H22>0,H22/H17,0)","v":0}]
[null,"d. Equipment",{"$f":"Equipment_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"Equipment_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"Equipment_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"Equipment_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"Equipment_BP5[[#Totals],[Total Cost             ]]","v":0},{"$f":"SUM(C23:G23)","v":0},{"$f":"IF(H23>0,H23/H17,0)","v":0}]
[null,"e. Supplies",{"$f":"Supplies_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"Supplies_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"Supplies_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"Supplies_BP_4[[#Totals],[Total Cost             ]]","v":0},{"$f":"Supplies_BP5[[#Totals],[Total Cost             ]]","v":0},0,{"$f":"IF(H24>0,H24/H17,0)","v":0}]
[null,"f. Contractual"]
[null,"Subrecipient",{"$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":"SUM(C26:G26)","v":0},{"$f":"IF(H26>0,H26/H17,0)","v":0}]
[null,"Contractor",{"$f":"'f. Contractual'!G14","v":0},{"$f":"'f. Contractual'!H14","v":0},{"$f":"'f. Contractual'!I14","v":0},{"$f":"'f. Contractual'!J14","v":0},{"$f":"'f. Contractual'!K14","v":0},{"$f":"SUM(C27:G27)","v":0},{"$f":"IF(H27>0,H27/H17,0)","v":0}]
[null,"FFRDC",{"$f":"'f. Contractual'!G15","v":0},{"$f":"'f. Contractual'!H15","v":0},{"$f":"'f. Contractual'!I15","v":0},{"$f":"'f. Contractual'!J15","v":0},{"$f":"'f. Contractual'!K15","v":0},{"$f":"SUM(C28:G28)","v":0},{"$f":"IF(H28>0,H28/H17,0)","v":0}]
[null,"Total Contractual ",{"$f":"Contractual[[#Totals],[BP 1 Total]]","v":0},{"$f":"Contractual[[#Totals],[BP 2 Total]]","v":0},{"$f":"Contractual[[#Totals],[BP 3 Total]]","v":0},{"$f":"Contractual[[#Totals],[BP 4 Total]]","v":0},{"$f":"Contractual[[#Totals],[BP 5 Total]]","v":0},{"$f":"SUM(C29:G29)","v":0},{"$f":"IF(H29>0,H29/H17,0)","v":0}]
[null,"g. Construction",{"$f":"Construction_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP5[[#Totals],[Total Cost             ]]","v":0},0,{"$f":"IF(H30>0,H30/H17,0)","v":0}]
[null,"h. Other Direct Costs",{"$f":"Other_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"Other_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"Other_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"Other_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"Other_BP5[[#Totals],[Total Cost             ]]","v":0},0,{"$f":"IF(H31>0,H31/H17,0)","v":0}]
[null,"Total Direct Costs",{"$f":"C20+C21+C22+C23+C24+C29+C30+C31","v":37500},{"$f":"D20+D21+D22+D23+D24+D29+D30+D31","v":7500},{"$f":"E20+E21+E22+E23+E24+E29+E30+E31","v":0},{"$f":"F20+F21+F22+F23+F24+F29+F30+F31","v":0},{"$f":"G20+G21+G22+G23+G24+G29+G30+G31","v":0},{"$f":"SUM(C32:G32)","v":45000},{"$f":"IF(H32>0,H32/H17,0)","v":1}]
[null,"i. Indirect Charges",{"$f":"i.Indirect!C40","v":0},{"$f":"i.Indirect!D40","v":0},{"$f":"i.Indirect!E40","v":0},{"$f":"i.Indirect!F40","v":0},{"$f":"i.Indirect!G40","v":0},{"$f":"SUM(C33:G33)","v":0},{"$f":"IF(H33>0,H33/H17,0)","v":0}]
[null,"j. Cost Share",{"$f":"'j.Cost Share'!C32","v":0},{"$f":"'j.Cost Share'!D32","v":0},{"$f":"'j.Cost Share'!E32","v":0},{"$f":"'j.Cost Share'!F32","v":0},{"$f":"'j.Cost Share'!G32","v":0},{"$f":"SUM(C34:G34)","v":0},{"$f":"IF(H34>0,H34/H17,0)","v":0}]
[null,"Total Costs",{"$f":"C32+C33+C34","v":37500},7500,0,0,0,45000,1]

{"sheet":"j.Cost Share","index":12,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[10,1,10,7],[11,1,12,7],[14,4,14,5],[44,3,44,4],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[50,3,50,4],[51,3,51,4],[42,1,42,5],[43,1,43,5],[54,3,54,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[60,3,60,4],[61,3,61,4],[53,1,53,5],[64,3,64,4],[65,3,65,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[71,3,71,4],[63,1,63,5],[74,3,74,4],[75,3,75,4],[76,3,76,4],[73,1,73,5],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[89,3,89,4],[90,3,90,4],[91,3,91,4],[83,1,83,5],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,3,88,4]]}
[null,"j. Cost Share"]
[]
[null,"INSTRUCTIONS"]
[null,"1. 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, type of cost share contribution (Cash or In-kind), the cost share item & amount of each cost share item proposed in the award. "]
[null,"2. 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. Any partial donation of goods or services is considered a discount and is not allowable. Contractors may not provide cost share.  "]
[null,"3. 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.  "]
[null,"4. Funds from other Federal sources MAY NOT be counted as cost share. This prohibition includes FFRDC subrecipients. 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."]
[null,"5. 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."]
[null,"6. NOTE: A Recipient electing to use the de minimis rate may not claim \"unrecovered indirect costs.\""]
[null,"7. NOTE: A Recipient with an approved negotiated rate agreement can claim “unrecovered indirect costs” as a cost share contribution with prior approval from the Grants and Agreements Officer."]
[null,"8. Each budget period is rounded to the nearest dollar. "]
[null,"Additional Explanation (as needed):"]
[]
[]
[null,null,"Total Project Cost:  ",{"$f":"'Cost Summary'!H35","v":45000},"Cost Share Percent of Award:",null,{"$f":"IF(D15>0,H32/D15,0)","v":0}]
[]
[null,"Summary from previous tabs:"]
[null,"CATEGORY","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"," Total Costs"]
[null,"a. Personnel",{"$f":"'a. Personnel'!F45*Perssonnel_Table[[#Totals],[Total Budget Period 1]]","v":0},{"$f":"'a. Personnel'!I45*Perssonnel_Table[[#Totals],[Total Budget Period 2]]","v":0},{"$f":"'a. Personnel'!L45*Perssonnel_Table[[#Totals],[Total Budget Period 3]]","v":0},{"$f":"'a. Personnel'!O45*Perssonnel_Table[[#Totals],[Total Budget Period 4]]","v":0},{"$f":"'a. Personnel'!R45*Perssonnel_Table[[#Totals],[Total Budget Period 5]]","v":0},{"$f":"SUM(C19:G19)","v":0}]
[null,"b. Fringe Benefits",{"$f":"'b. Fringe'!E48*Fringe_Table[[#Totals],[Total]]","v":0},{"$f":"'b. Fringe'!H48*Fringe_Table[[#Totals],[Total4]]","v":0},{"$f":"'b. Fringe'!K48*Fringe_Table[[#Totals],[Total7]]","v":0},{"$f":"'b. Fringe'!N48*Fringe_Table[[#Totals],[Total10]]","v":0},{"$f":"'b. Fringe'!Q48*Fringe_Table[[#Totals],[Total13]]","v":0},{"$f":"SUM(C20:G20)","v":0}]
[null,"c. Travel",{"$f":"'c. Travel'!M29*Travel_BP1[[#Totals],[Cost per Trip]]","v":0},{"$f":"'c. Travel'!M48*Travel_BP2[[#Totals],[Cost per Trip]]","v":0},{"$f":"'c. Travel'!M67*Travel_BP3[[#Totals],[Cost per Trip]]","v":0},{"$f":"'c. Travel'!M86*Travel_BP4[[#Totals],[Cost per Trip]]","v":0},{"$f":"'c. Travel'!M105*Travel_BP5[[#Totals],[Cost per Trip]]","v":0},0]
[null,"d. Equipment",{"$f":"'d. Equipment'!F22*Equipment_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"'d. Equipment'!F41*Equipment_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"'d. Equipment'!F60*Equipment_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"'d. Equipment'!F79*Equipment_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"'d. Equipment'!F98*Equipment_BP5[[#Totals],[Total Cost             ]]","v":0},0]
[null,"e. Supplies",{"$f":"'e. Supplies'!F23*Supplies_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"'e. Supplies'!F43*Supplies_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"'e. Supplies'!F63*Supplies_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"'e. Supplies'!F83*Supplies_BP_4[[#Totals],[Total Cost             ]]","v":0},{"$f":"'e. Supplies'!F103*Supplies_BP5[[#Totals],[Total Cost             ]]","v":0},0]
[null,"f. Contractual",{"$f":"'f. Contractual'!G39*Contractual[[#Totals],[BP 1 Total]]","v":0},{"$f":"'f. Contractual'!J39*Contractual[[#Totals],[BP 2 Total]]","v":0},{"$f":"'f. Contractual'!M39*Contractual[[#Totals],[BP 3 Total]]","v":0},{"$f":"'f. Contractual'!P39*Contractual[[#Totals],[BP 4 Total]]","v":0},{"$f":"'f. Contractual'!S39*Contractual[[#Totals],[BP 5 Total]]","v":0},0]
[null,"g. Construction",{"$f":"'g. Construction'!D21*Construction_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"'g. Construction'!D41*Construction_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"'g. Construction'!D61*Construction_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"'g. Construction'!D81*Construction_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"'g. Construction'!D101*Construction_BP5[[#Totals],[Total Cost             ]]","v":0},{"$f":"SUM(C25:G25)","v":0}]
[null,"h. Other Direct Costs",{"$f":"'h. Other'!D22*Other_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"'h. Other'!D42*Other_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"'h. Other'!D62*Other_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"'h. Other'!D82*Other_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"'h. Other'!D102*Other_BP5[[#Totals],[Total Cost             ]]","v":0},0]
[null,"i. Indirect Charges",{"$f":"i.Indirect!C43*i.Indirect!C40","v":0},{"$f":"i.Indirect!D43*i.Indirect!D40","v":0},{"$f":"i.Indirect!E43*i.Indirect!E40","v":0},{"$f":"i.Indirect!F43*i.Indirect!F40","v":0},{"$f":"i.Indirect!G43*i.Indirect!G40","v":0},0]
[]
[]
[null,"TOTAL COST SHARE:"]
[null,"BUDGET PERIOD","Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5","Total Project Cost Share"]
[null,null,{"$f":"'j.Cost Share'!$F$52+SUM(C19:C27)","v":0},{"$f":"'j.Cost Share'!$F$62+SUM(D19:D27)","v":0},{"$f":"'j.Cost Share'!$F$72+SUM(E19:E27)","v":0},{"$f":"'j.Cost Share'!$F$82+SUM(F19:F27)","v":0},{"$f":"'j.Cost Share'!$F$92+SUM(G19:G27)","v":0},{"$f":"SUM(C32:G32)","v":0}]
[]
[]
[]
[]
[]
[null,"Additional Cost Share:"]
[null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"]
[null,"Contractor Cost Share Percentage per Budget Period",0,0,0,0,0]
[]
[]
[null,"To add additional lines, use the \"TAB\" button on the last item in each table. "]
[null,"Budget Period 1"]
[null,"Organization/Source                 ","Type (Cash or In Kind) ","Narrative Description",null,"Cost"]
[{"$nulls":5},{"$f":"SUM(C19:C27)-F47-F48-F49","v":0}]
[{"$nulls":5},{"$f":"'f. Contractual'!I22","v":0}]
[{"$nulls":5},{"$f":"'f. Contractual'!I24","v":0}]
[{"$nulls":5},{"$f":"Supplies_BP1[[#Totals],[Cost Share]]","v":0}]
[]
[]
[null,null,null,"TOTAL COST SHARE",null,{"$f":"SUM('j.Cost Share'!$F$46:$F$51)","v":0}]
[]
[null,"Budget Period 2"]
[null,"Organization/Source                 ","Type (Cash or In Kind) ","Narrative Description",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL COST SHARE",null,{"$f":"SUM('j.Cost Share'!$F$56:$F$61)","v":0}]
[]
[null,"Budget Period 3"]
[null,"Organization/Source                 ","Type (Cash or In Kind) ","Narrative Description",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL COST SHARE",null,{"$f":"SUM('j.Cost Share'!$F$66:$F$71)","v":0}]
[]
[null,"Budget Period 4"]
[null,"Organization/Source                 ","Type (Cash or In Kind) ","Narrative Description",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL COST SHARE",null,{"$f":"SUM('j.Cost Share'!$F$76:$F$81)","v":0}]
[]
[null,"Budget Period 5"]
[null,"Organization/Source                 ","Type (Cash or In Kind) ","Narrative Description",null,"Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL COST SHARE",null,{"$f":"SUM('j.Cost Share'!$F$86:$F$91)","v":0}]

{"sheet":"Narrative Summary","index":13,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[[22,1,22,2],[34,1,34,2],[46,1,46,2],[58,1,58,2],[1,1,1,2],[3,1,3,2],[5,1,5,2],[6,1,6,2],[10,1,10,2]]}
[]
[null,"Summary of Budget Narrative Justifications"]
[]
[null,"(Note:  The values in this summary table are from entries in each budget category worksheet)"]
[]
[null,"INSTRUCTIONS"]
[null,"The table below will auto-populate with the Budget Narrative Justifications from the other worksheets. Please DO NOT fill in any data in this sheet."]
[]
[]
[]
[null,"Budget Period 1"]
[null,"CATEGORY","Summary of Budget Narrative Justifications"]
[null,"a. Personnel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))), \"\", MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))))","v":"The Community Specialist (CBP) will work directly with local government leaders and citizens in the project area to ensure they are part of the decisions that impact the project and their community. This CPB Community Specialist has 10 years of community engagement experience on clean energy projects such as wind and solar and will work approximately 25% FTE during BP 1 and 5% in BP 2. (EXAMPLE)"}]
[null,"b. Fringe Benefits",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))), \"\", MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))))","v":""}]
[null,"c. Travel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('c. Travel'!B32:B36, 1, LEN('c. Travel'!B32:B36))), \"\", MID('c. Travel'!B32:B36, 1, LEN('c. Travel'!B32:B36))))","v":""}]
[null,"d. Equipment",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('d. Equipment'!B25:B29, 1, LEN('d. Equipment'!B25:B29))), \"\", MID('d. Equipment'!B25:B29, 1, LEN('d. Equipment'!B25:B29))))","v":""}]
[null,"e. Supplies",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('e. Supplies'!B26:B30, 1, LEN('e. Supplies'!B26:B30))), \"\", MID('e. Supplies'!B26:B30, 1, LEN('e. Supplies'!B26:B30))))","v":""}]
[null,"f. Contractual",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))), \"\", MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))))","v":""}]
[null,"g. Construction",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('g. Construction'!B24:B28, 1, LEN('g. Construction'!B24:B28))), \"\", MID('g. Construction'!B24:B28, 1, LEN('g. Construction'!B24:B28))))","v":""}]
[null,"h. Other Direct Costs",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('h. Other'!B25:B29, 1, LEN('h. Other'!B25:B29))), \"\", MID('h. Other'!B25:B29, 1, LEN('h. Other'!B25:B29))))","v":""}]
[]
[]
[null,"Budget Period 2"]
[null,"CATEGORY","Summary of Budget Narrative Justifications"]
[null,"a. Personnel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))), \"\", MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))))","v":"The Community Specialist (CBP) will work directly with local government leaders and citizens in the project area to ensure they are part of the decisions that impact the project and their community. This CPB Community Specialist has 10 years of community engagement experience on clean energy projects such as wind and solar and will work approximately 25% FTE during BP 1 and 5% in BP 2. (EXAMPLE)"}]
[null,"b. Fringe Benefits",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))), \"\", MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))))","v":""}]
[null,"c. Travel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('c. Travel'!B51:B55, 1, LEN('c. Travel'!B51:B55))), \"\", MID('c. Travel'!B51:B55, 1, LEN('c. Travel'!B51:B55))))","v":""}]
[null,"d. Equipment",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('d. Equipment'!B44:B48, 1, LEN('d. Equipment'!B44:B48))), \"\", MID('d. Equipment'!B44:B48, 1, LEN('d. Equipment'!B44:B48))))","v":""}]
[null,"e. Supplies",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('e. Supplies'!B46:B50, 1, LEN('e. Supplies'!B46:B50))), \"\", MID('e. Supplies'!B46:B50, 1, LEN('e. Supplies'!B46:B50))))","v":""}]
[null,"f. Contractual",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))), \"\", MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))))","v":""}]
[null,"g. Construction",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('g. Construction'!B44:B48, 1, LEN('g. Construction'!B44:B48))), \"\", MID('g. Construction'!B44:B48, 1, LEN('g. Construction'!B44:B48))))","v":""}]
[null,"h. Other Direct Costs",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('h. Other'!B45:B49, 1, LEN('h. Other'!B45:B49))), \"\", MID('h. Other'!B45:B49, 1, LEN('h. Other'!B45:B49))))","v":""}]
[]
[]
[null,"Budget Period 3"]
[null,"CATEGORY","Summary of Budget Narrative Justifications"]
[null,"a. Personnel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))), \"\", MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))))","v":"The Community Specialist (CBP) will work directly with local government leaders and citizens in the project area to ensure they are part of the decisions that impact the project and their community. This CPB Community Specialist has 10 years of community engagement experience on clean energy projects such as wind and solar and will work approximately 25% FTE during BP 1 and 5% in BP 2. (EXAMPLE)"}]
[null,"b. Fringe Benefits",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))), \"\", MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))))","v":""}]
[null,"c. Travel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('c. Travel'!B70:B74, 1, LEN('c. Travel'!B70:B74))), \"\", MID('c. Travel'!B70:B74, 1, LEN('c. Travel'!B70:B74))))","v":""}]
[null,"d. Equipment",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('d. Equipment'!B63:B67, 1, LEN('d. Equipment'!B63:B67))), \"\", MID('d. Equipment'!B63:B67, 1, LEN('d. Equipment'!B63:B67))))","v":""}]
[null,"e. Supplies",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('e. Supplies'!B66:B70, 1, LEN('e. Supplies'!B66:B70))), \"\", MID('e. Supplies'!B66:B70, 1, LEN('e. Supplies'!B66:B70))))","v":""}]
[null,"f. Contractual",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))), \"\", MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))))","v":""}]
[null,"g. Construction",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('g. Construction'!B64:B68, 1, LEN('g. Construction'!B64:B68))), \"\", MID('g. Construction'!B64:B68, 1, LEN('g. Construction'!B64:B68))))","v":""}]
[null,"h. Other Direct Costs",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('h. Other'!B65:B69, 1, LEN('h. Other'!B65:B69))), \"\", MID('h. Other'!B65:B69, 1, LEN('h. Other'!B65:B69))))","v":""}]
[]
[]
[null,"Budget Period 4"]
[null,"CATEGORY","Summary of Budget Narrative Justifications"]
[null,"a. Personnel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))), \"\", MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))))","v":"The Community Specialist (CBP) will work directly with local government leaders and citizens in the project area to ensure they are part of the decisions that impact the project and their community. This CPB Community Specialist has 10 years of community engagement experience on clean energy projects such as wind and solar and will work approximately 25% FTE during BP 1 and 5% in BP 2. (EXAMPLE)"}]
[null,"b. Fringe Benefits",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))), \"\", MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))))","v":""}]
[null,"c. Travel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('c. Travel'!B89:B93, 1, LEN('c. Travel'!B89:B93))), \"\", MID('c. Travel'!B89:B93, 1, LEN('c. Travel'!B89:B93))))","v":""}]
[null,"d. Equipment",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('d. Equipment'!B82:B86, 1, LEN('d. Equipment'!B82:B86))), \"\", MID('d. Equipment'!B82:B86, 1, LEN('d. Equipment'!B82:B86))))","v":""}]
[null,"e. Supplies",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('e. Supplies'!B86:B90, 1, LEN('e. Supplies'!B86:B90))), \"\", MID('e. Supplies'!B86:B90, 1, LEN('e. Supplies'!B86:B90))))","v":""}]
[null,"f. Contractual",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))), \"\", MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))))","v":""}]
[null,"g. Construction",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('g. Construction'!B84:B88, 1, LEN('g. Construction'!B84:B88))), \"\", MID('g. Construction'!B84:B88, 1, LEN('g. Construction'!B84:B88))))","v":""}]
[null,"h. Other Direct Costs",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('h. Other'!B85:B89, 1, LEN('h. Other'!B85:B89))), \"\", MID('h. Other'!B85:B89, 1, LEN('h. Other'!B85:B89))))","v":""}]
[]
[]
[null,"Budget Period 5"]
[null,"CATEGORY","Summary of Budget Narrative Justifications"]
[null,"a. Personnel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))), \"\", MID('a. Personnel'!B50:B54, 1, LEN('a. Personnel'!B50:B54))))","v":"The Community Specialist (CBP) will work directly with local government leaders and citizens in the project area to ensure they are part of the decisions that impact the project and their community. This CPB Community Specialist has 10 years of community engagement experience on clean energy projects such as wind and solar and will work approximately 25% FTE during BP 1 and 5% in BP 2. (EXAMPLE)"}]
[null,"b. Fringe Benefits",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))), \"\", MID('b. Fringe'!B53:B57, 1, LEN('b. Fringe'!B53:B57))))","v":""}]
[null,"c. Travel",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('c. Travel'!B108:B112, 1, LEN('c. Travel'!B108:B112))), \"\", MID('c. Travel'!B108:B112, 1, LEN('c. Travel'!B108:B112))))","v":""}]
[null,"d. Equipment",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('d. Equipment'!B101:B105, 1, LEN('d. Equipment'!B101:B105))), \"\", MID('d. Equipment'!B101:B105, 1, LEN('d. Equipment'!B101:B105))))","v":""}]
[null,"e. Supplies",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('e. Supplies'!B106:B110, 1, LEN('e. Supplies'!B106:B110))), \"\", MID('e. Supplies'!B106:B110, 1, LEN('e. Supplies'!B106:B110))))","v":""}]
[null,"f. Contractual",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))), \"\", MID('f. Contractual'!B42:B46, 1, LEN('f. Contractual'!B42:B46))))","v":""}]
[null,"g. Construction",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('g. Construction'!B104:B108, 1, LEN('g. Construction'!B104:B108))), \"\", MID('g. Construction'!B104:B108, 1, LEN('g. Construction'!B104:B108))))","v":""}]
[null,"h. Other Direct Costs",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, IF(ISERROR(MID('h. Other'!B105:B109, 1, LEN('h. Other'!B105:B109))), \"\", MID('h. Other'!B105:B109, 1, LEN('h. Other'!B105:B109))))","v":""}]

{"sheet":"SF-424A Cost Categories","index":14,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[[31,0,31,8],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,0,26,8],[27,1,27,2],[30,0,30,1],[30,2,30,5],[30,6,30,8],[22,1,22,2],[13,0,14,0],[13,1,14,2],[13,3,13,6],[13,8,14,8],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[12,0,12,1],[12,2,12,8],[0,0,0,8],[1,0,1,8],[2,0,2,1],[2,2,2,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,8]]}
["Budget Information"]
["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",null,"Total"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)",null,"(g)"]
["1.","Budget Period 1",null,null,null,{"$f":"'Cost Summary'!D12","v":37500},{"$f":"'Cost Summary'!E12","v":0},null,{"$f":"ROUND(SUM(D7:G7),0)","v":37500}]
["2.","Budget Period 2",null,null,null,{"$f":"'Cost Summary'!D13","v":7500},{"$f":"'Cost Summary'!E13","v":0},null,{"$f":"ROUND(SUM(D8:G8),0)","v":7500}]
["3.","Budget Period 3",null,null,null,{"$f":"'Cost Summary'!D14","v":0},{"$f":"'Cost Summary'!E14","v":0},null,{"$f":"ROUND(SUM(D9:G9),0)","v":0}]
["4.","Budget Period 4",null,null,null,{"$f":"'Cost Summary'!D15","v":0},{"$f":"'Cost Summary'!E15","v":0},null,{"$f":"ROUND(SUM(D10:G10),0)","v":0}]
["5.","Budget Period 5",null,null,null,{"$f":"'Cost Summary'!D16","v":0},{"$f":"'Cost Summary'!E16","v":0},null,{"$f":"ROUND(SUM(D11:G11),0)","v":0}]
["6.","Totals",null,null,null,{"$f":"'Cost Summary'!D17","v":45000},{"$f":"'Cost Summary'!E17","v":0},null,{"$f":"ROUND(SUM(I7:I11),0)","v":45000}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",{"$nulls":4},"Total (5)"]
[null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Budget Period 4","Budget Period 5"]
[null,"a.  Personnel",null,{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 1]]","v":37500},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 2]]","v":7500},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 3]]","v":0},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 4]]","v":0},{"$f":"Perssonnel_Table[[#Totals],[Total Budget Period 4]]","v":0},{"$f":"ROUND(SUM(D16:H16),0)","v":45000}]
[null,"b.  Fringe Benefits",null,{"$f":"Fringe_Table[[#Totals],[Total]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total4]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total7]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total10]]","v":0},{"$f":"Fringe_Table[[#Totals],[Total13]]","v":0},{"$f":"ROUND(SUM(D17:H17),0)","v":0}]
[null,"c.  Travel",null,{"$f":"Travel_BP1[[#Totals],[Cost per Trip]]","v":0},{"$f":"Travel_BP2[[#Totals],[Cost per Trip]]","v":0},{"$f":"Travel_BP3[[#Totals],[Cost per Trip]]","v":0},{"$error":"#REF!"},{"$f":"Travel_BP5[[#Totals],[Cost per Trip]]","v":0},{"$error":"#REF!"}]
[null,"d.  Equipment",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"e.  Supplies",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"f.  Contractual",null,{"$f":"Contractual[[#Totals],[BP 1 Cost Share]]","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"g.  Construction",null,{"$f":"Construction_BP1[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP2[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP3[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP4[[#Totals],[Total Cost             ]]","v":0},{"$f":"Construction_BP5[[#Totals],[Total Cost             ]]","v":0},0]
[null,"h.  Other",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[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":{"$error":"#REF!"}},{"$f":"SUM(H16:H23)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"j.  Indirect Charges",null,{"$f":"i.Indirect!E38","v":0},{"$f":"i.Indirect!F38","v":0},{"$f":"i.Indirect!G38","v":0},{"$f":"i.Indirect!H38","v":0},{"$f":"i.Indirect!I38","v":0},0]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"ROUND(SUM(D24:D25),0)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(E24:E25),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["7.","Program Income",{"$nulls":6},{"$f":"ROUND(SUM(D28:G28),0)","v":0}]
[]
[{"$nulls":8},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",{"$nulls":5},"Prescribed by OMB Circular A-102"]
["Authorized for Local Reproduction"]