{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Budget Period #1","Budget Period #2","Budget Period #3","Budget Period #4","Budget Period #5","Budget Summary","Quick Lookup","SLRs","Rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":78,"n_cols":1,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["PAMS - Portfolio Analysis and Management System"]
[]
["Budget Template Instructions"]
["Budgets are required for the entire project period. A budget template should be completed for each budget period of the award, and a cumulative budget form for the entire project period will be populated. A detailed budget justification narrative should be included after the budget pages. The justification should cover labor, domestic and foreign travel, equipment, materials and supplies, and anything else that will be covered with project funds. "]
[]
["·         Budget Period 1 – Budget Period 5 Tabs: Tabs represent budget for each period."]
["·         Budget Summary Tab: Provides a cumulative amount of all budget periods and is populated."]
["COMPLETE FIELDS HIGHLIGHTED IN BLUE"]
[]
["Budget Period Information:"]
["Note: The budget submitted by the primary applicant must include all costs associated with the award."]
[]
["·         Start Date and End Date: Enter the proposed start date and end date of the budget period."]
[]
["A.   Senior/Key Person (Required):"]
["·         Name: Enter the Last Name, First Name (ex: Smith, John) of each Senior/Key Person."]
["·         Project Role: Enter the project role of each Senior/Key Person (Principal Investigator, Co-Investigator, Project Manager Senior Researcher, etc.)"]
["·         Job Category and Job Title: Select the appropriate job category and job title from each list, to look up the Band and Standard Labor Rate (includes OPTO and Vacation).  "]
["·         Hours: Enter the hours to be worked for each Job Title (1768 is full time for a year)."]
["·         Months: Will populate based on hours"]
["·         Requested Salary ($): Will populate based on Standard Labor Rate and hours."]
["·         Fringe Benefits ($): Will populate based on the predefined rate of 31%, see cell G9."]
["·         Funds Requested ($): This amount will be populated (Requested Salary + Fringe Benefits)."]
["·         Total Senior/Key Person: This amount will be calculated by PAMS. "]
["·         SWF Type: This field defaults to Division Staff to apply the Program Support indirect rate (in section H).  The Section Staff option is available for personnel that receive Common Site Support."]
[]
["B.   Other Personnel:"]
["·         Enter “Other Personnel” budget information, using the instructions for “Senior/Key Person” as guidelines. Other Personnel are identified by Project Role, instead of Name."]
["·         # of Personnel: Enter number of personnel for each Project Role"]
["·         Project Role (to group): Select the Project Role, to summarize personnel into pre-identified roles, including Post Doctorate Associates, Graduate Students, Undergraduate Students, Secretarial/Clerical, Engineers, and Technicians. Engineers identified in this section are those who provide engineering project support and not research performance."]
["·         Fringe Benefits ($): Will populate based on the predefined rate of 31% (cell G9), and 25% for Post Doctoral Associates (cell G10)"]
["·         Total Salary, Wages and Fringe Benefits (A+B): This amount will be calculated by PAMS."]
[]
["C.   Equipment Description:"]
["·         Item: Enter each equipment item type and quantity."]
["·         Funds Requested ($): List the estimated cost of each item of equipment including shipping and any maintenance costs including maintenance agreements."]
["·         Total Equipment: This amount will be calculated by PAMS."]
[]
["D.   Travel:"]
["·         Domestic Travel Costs: Domestic travel includes Canada, Mexico and US Territories/Possessions. "]
["·         Funds Requested ($): Enter total funds requested for domestic travel."]
["·         Foreign Travel Costs: Foreign travel includes any travel outside of North America and/or US Territories/Possessions. Foreign travel may be approved only if it is directly related to project objectives."]
["·         Funds Requested ($): Enter total funds requested for foreign travel."]
["·         Total Travel: This amount will be calculated by PAMS."]
[]
["E.   Participant/Trainee Support Costs:"]
["·         Tuition/Fees/Health Insurance, Stipends, Travel, Subsistence, and Other Costs: If applicable for trainees, enter costs in Funds Requested field."]
["·         Number of Participants/Trainees: Enter the number of participants or trainees."]
["·         Total Participant/Trainee Support Costs: This amount will be calculated by PAMS."]
[]
["F.   Other Direct Costs:"]
["Enter Other Direct Costs information for each item listed. "]
["·         Materials and Supplies: Enter total funds requested for materials and supplies in the appropriate fields."]
["·         Publication Costs: Enter the total publication funds requested."]
["·         Consultant Services: Enter total funds requested for all consultant services."]
["·         ADP/Computer Services: Enter total funds requested for ADP/Computer Services."]
["·         Subawards/Consortium/Contractual Costs: Enter total costs by subaward type for subawards/consortium organizations and other contractual costs proposed for the project.  Indirect rates (section H) will be applied based on the subaward type.  "]
["·         Equipment or Facility Rental/User Fees: Enter total funds requested for Equipment or Facility Rental/User Fees."]
["·         Alterations and Renovations: Enter total funds requested for Alterations and Renovations."]
["·         Other: Add text to describe any other Direct Costs not requested above. Enter costs associated with “Other” item(s)."]
["·         Total Other Direct Costs: This amount will be calculated by PAMS."]
[]
["G.   Direct Costs:"]
["This represents Total Direct Costs (Sections A thru F) and will be calculated by PAMS. "]
[]
["H.   Other Indirect Costs:"]
["Enter the Indirect Cost information for each field. Only four general categories of indirect costs are allowed/requested on this form, so please consolidate if needed.  "]
["·         Item: Indicate the type of base; e.g., Salary & Wages, Modified Total Direct Costs, Other (explain). If more than one rate/base is involved, use separate lines for each.  The 3 most common rates have been populated."]
["·         Funds Requested ($): Populated based on Indirect Rates."]
["·         Total Other Indirect Costs: This amount will be calculated by PAMS."]
[]
["I.   Total Direct and Indirect Costs:"]
["This amount will be calculated by PAMS (Sections G + H) "]
[]
["Budget Justification:"]
["Include a budget justification that provides additional information requested in each budget category identified above and any other information you wish to submit to support your budget request."]
[]
["This includes supporting information for equipment; domestic and foreign travel; participant/trainees; material and supplies; publication; consultant services; ADP/computer services; subaward/consortium/contractual; equipment or facility rental/user fees; alterations and renovations; and indirect cost type. Provide any other information you wish to justify your budget request. "]

{"sheet":"Budget Period #1","index":1,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,9,9,13],[0,1,0,3],[92,1,92,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[70,1,70,6],[71,1,71,6],[72,1,72,6],[73,1,73,6],[74,1,74,6],[78,1,78,6],[82,1,82,4],[84,1,84,4],[69,9,69,11],[53,1,53,6],[54,1,54,6],[85,1,85,4],[87,1,87,4],[67,1,67,6],[68,1,68,6],[69,1,69,6],[83,1,83,4],[86,1,86,4]]}
[null,"DOE National Laboratory Announcement"]
[null,"Proposal Title",null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Note:  The budget submitted by the primary applicant must include all costs associated with the award. "]
[null,"Budget Period Information"]
[]
[null,"Budget Period Start Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Selecting Job Category and Title will populate Band, Rate, and Project Role"]
[null,"Budget Period End Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Adding hours will populate Months, Requested Salary, Fringe Benefits, and Funds Requested"]
[null,null,null,null,null,null,null,null,null,"Options: Rate can be selected by band only.  Project role can be customized."]
[null,"A. Senior/Key Person (required):",null,null,null,"Fringe Rate:",{"$f":"Rates!B6","v":0.29749999999999999}]
[null,null,null,null,null,"Fringe PostDoc:",{"$f":"Rates!B7","v":0.23749999999999999},null,null,"Labor Calculations (SLRs)"]
[]
[null,"Name",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,"Category","Job Title","Band","SLR + VO","Hours",null,"SWF Type (for OH)"]
["1.)",null,null,null,{"$f":"N13/(Rates!$B$22/12)","v":0},{"$f":"ROUND(M13*N13,2)","v":0},{"$f":"ROUND(F13*$G$9,2)","v":0},{"$f":"F13+G13","v":0},null,"Engineers","Senior Engineer",{"$f":"IFERROR(VLOOKUP($K13,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":"E5"},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L13,SLRs!$F$2:$F$21)","v":71.087500000000006},null,null,"Division Staff"]
["2.)",null,null,null,{"$f":"N14/(Rates!$B$22/12)","v":0},{"$f":"ROUND(M14*N14,2)","v":0},0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K14,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L14,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["3.)",null,null,null,{"$f":"N15/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K15,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L15,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["4.)",null,null,null,{"$f":"N16/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K16,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L16,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["5.)",null,null,null,{"$f":"N17/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K17,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L17,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["6.)",null,null,null,{"$f":"N18/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K18,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L18,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["7.)",null,null,null,{"$f":"N19/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K19,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L19,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["8.)",null,null,null,{"$f":"N20/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K20,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L20,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["9.)",null,null,null,{"$f":"N21/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K21,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L21,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
["10.)",null,null,null,{"$f":"N22/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K22,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L22,SLRs!$F$2:$F$21)","v":0},null,null,"Division Staff"]
[null,null,null,null,null,null,"Total Senior/Key Personnel (A)",{"$f":"SUM(H13:H22)","v":0}]
[null,"B. Other Personnel"]
[null,"# of Personnel",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,null,null,null,null,null,null,"Project Role (to Group)"]
["1.)",null,null,"Post Doctoral Associates",{"$f":"SUMIF($P$26:$P$35,$D26,$N$26:$N$35)/(Rates!$B$22/12)","v":0},{"$f":"SUMIF($P$26:$P$35,$D26,$O$26:$O$35)","v":0},{"$f":"ROUND(F26*$G$10,2)","v":0},{"$f":"F26+G26","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP($K26,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L26,SLRs!$F$2:$F$21)","v":0},null,{"$f":"ROUND(N26*M26,2)","v":0}]
["2.)",null,null,"Graduate Students",{"$f":"SUMIF($P$26:$P$35,$D27,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,{"$f":"ROUND(F27*$G$9,2)","v":0},0,null,null,null,{"$f":"IFERROR(VLOOKUP($K27,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L27,SLRs!$F$2:$F$21)","v":0},null,0]
["3.)",null,null,"Undergraduate Students",{"$f":"SUMIF($P$26:$P$35,$D28,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K28,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L28,SLRs!$F$2:$F$21)","v":0},null,0]
["4.)",null,null,"Secretarial/Clerical",{"$f":"SUMIF($P$26:$P$35,$D29,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K29,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L29,SLRs!$F$2:$F$21)","v":0},null,0]
["5.)",null,null,"Engineers",{"$f":"SUMIF($P$26:$P$35,$D30,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K30,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L30,SLRs!$F$2:$F$21)","v":0},null,0]
["6.)",null,null,"Technicians",{"$f":"SUMIF($P$26:$P$35,$D31,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K31,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L31,SLRs!$F$2:$F$21)","v":0},null,0]
["7.)",null,null,null,{"$f":"SUMIF($P$26:$P$35,$D32,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K32,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L32,SLRs!$F$2:$F$21)","v":0},null,0]
["8.)",null,null,null,{"$f":"SUMIF($P$26:$P$35,$D33,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K33,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L33,SLRs!$F$2:$F$21)","v":0},null,0]
["9.)",null,null,null,{"$f":"SUMIF($P$26:$P$35,$D34,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K34,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L34,SLRs!$F$2:$F$21)","v":0},null,0]
["10.)",null,null,null,{"$f":"SUMIF($P$26:$P$35,$D35,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,null,null,{"$f":"IFERROR(VLOOKUP($K35,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #1'!$L35,SLRs!$F$2:$F$21)","v":0},null,0]
[null,null,null,null,null,null,"Total Other Personnel (B)",{"$f":"SUM(H26:H35)","v":0}]
[]
[null,null,null,null,null,null,"Total Salary, Wages and Fringe Benefits (A+B)",{"$f":"H23+H36","v":0}]
[null,"C. Equipment Description"]
[null,"Equipment Item",null,null,null,null,"Quantity","Funds Requested"]
["1.)"]
["2.)"]
["3.)"]
["4.)"]
["5.)"]
["6.)"]
["7.)"]
["8.)"]
["9.)"]
["10.)"]
[null,null,null,null,null,null,"Total Equipment (C)",{"$f":"SUM(H41:H50)","v":0}]
[null,"D. Travel"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Domestic Travel Costs (incl. Canada, Mexico, and US Possessions)"]
["2.)","Foreign Travel Costs"]
[null,null,null,null,null,null,"Total Travel (D)",{"$f":"SUM(H54:H55)","v":0}]
[null,"E. Participant/Trainee Support Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Tuition/Fees/Health Insurance"]
["2.)","Stipends"]
["3.)","Travel"]
["4.)","Subsistence"]
["5.)","Other"]
[null,null,null,null,null,"Number of Participant/Trainees"]
["NOTE: On #1-#5, enter total costs for ALL Participant/Trainees, not as a per participant cost.",null,null,null,null,null,"Total Participant/Trainee Support Costs (E)",{"$f":"SUM(H59:H63)","v":0}]
[null,"F. Other Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Materials and Supplies"]
["2.)","Publication Costs"]
["3.)","Consultant Services",null,null,null,null,null,null,null,"Subawards / Consortium / Contractual Costs"]
["4.)","ADP/Computer Services",null,null,null,null,null,null,null,"Subawards","National Labs","Pass through"]
["5.)","Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"J72+K72+L72","v":0}]
["6.)","Equipment or Facility Rental/User Fees"]
["7.)","Alternation and Renovations"]
["8.)","Other"]
[null,null,null,null,null,null,"Total Other Direct Costs (F)",{"$f":"SUM(H68:H75)","v":0}]
[null,"G. Direct Costs"]
[null,"Item"]
["1.)","Total Direct Costs (A-F)",null,null,null,null,null,{"$f":"H23+H36+H51+H56+H65+H76","v":0}]
[]
[null,"H. Other Indirect Costs"]
[null,"Item",null,null,null,null,"FY2017 Rates","Funds Requested"]
["1.)","Salary, Wages & Fringe (Division staff)",null,null,null,"Program Support",{"$f":"Rates!B9","v":0.93530000000000002},{"$f":"ROUND((H36+SUMIF(P13:P22,'Quick Lookup'!H3,H13:H22))*G83,2)","v":0}]
["2.)","Salary, Wages & Fringe (Section staff)",null,null,null,"CSS Rate",{"$f":"Rates!B11","v":0.69469999999999998},{"$f":"ROUND(SUMIF(P13:P22,'Quick Lookup'!H4,H13:H22)*G84,2)","v":0}]
["3.)","General and Administrative ",null,null,null,null,{"$f":"Rates!B12","v":0.18720000000000001},{"$f":"ROUND((H56+H65)*G85,2)","v":0}]
["4.)","MSA (Materials/Services Acquisition) ",null,null,null,null,{"$f":"Rates!B10","v":0.2631},{"$f":"ROUND((H76+H51-K72-L72)*G86,2)","v":0}]
["5.)","Pass through",null,null,null,null,{"$f":"Rates!B15","v":4.2900000000000001E-2},{"$f":"ROUND(L72*G87,2)","v":0}]
["6.)","Pass through (National Laboratories)",null,null,null,null,{"$f":"Rates!B14","v":0.03},{"$f":"ROUND(K72*G88,2)","v":0}]
[null,null,null,null,null,null,"Total Indirect Costs (H)",{"$f":"SUM(H83:H88)","v":0}]
[]
[null,"I. Total Direct and Indirect Costs"]
[]
["1.)","Total Direct and Indirect Costs (G+H)",null,null,null,null,null,{"$f":"H79+H89","v":0}]

{"sheet":"Budget Period #2","index":2,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,9,9,13],[71,1,71,6],[53,1,53,6],[54,1,54,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[67,1,67,6],[68,1,68,6],[69,1,69,6],[70,1,70,6],[69,9,69,11],[86,1,86,4],[87,1,87,4],[92,1,92,6],[72,1,72,6],[73,1,73,6],[74,1,74,6],[78,1,78,6],[82,1,82,4],[85,1,85,4],[83,1,83,4],[84,1,84,4]]}
[null,{"$f":"'Budget Period #1'!B1:E1","v":"DOE National Laboratory Announcement"},null,null,{"$f":"IF('Budget Period #1'!E1>0,'Budget Period #1'!E1,\"\")","v":""}]
[null,"Proposal Title",null,{"$f":"IF('Budget Period #1'!D2>0,'Budget Period #1'!D2,\"\")","v":""}]
[null,"Note:  The budget submitted by the primary applicant must include all costs associated with the award. "]
[null,"Budget Period Information"]
[]
[null,"Budget Period Start Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Selecting Job Category and Title will populate Band, Rate, and Project Role"]
[null,"Budget Period End Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Adding hours will populate Months, Requested Salary, Fringe Benefits, and Funds Requested"]
[null,null,null,null,null,null,null,null,null,"Options: Rate can be selected by band only.  Project role can be customized."]
[null,"A. Senior/Key Person (required):",null,null,null,"Fringe Rate:",{"$f":"Rates!B6","v":0.29749999999999999}]
[null,null,null,null,null,"Fringe PostDoc:",{"$f":"Rates!B7","v":0.23749999999999999},null,null,"Labor Calculations (SLRs)"]
[]
[null,"Name",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,"Category","Job Title","Band","SLR + VO","Hours",null,"SWF Type (for OH)"]
["1.)",{"$f":"IF('Budget Period #1'!B13>0,'Budget Period #1'!B13,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D13>0,'Budget Period #1'!D13,\"\")","v":""},{"$f":"N13/(Rates!$B$22/12)","v":0},{"$f":"ROUND(M13*N13,2)","v":0},{"$f":"ROUND(F13*$G$9,2)","v":0},{"$f":"F13+G13","v":0},null,{"$f":"IF('Budget Period #1'!J13>0,'Budget Period #1'!J13,\"\")","v":"Engineers"},{"$f":"IF('Budget Period #1'!K13>0,'Budget Period #1'!K13,\"\")","v":"Senior Engineer"},{"$f":"IFERROR(VLOOKUP($K13,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":"E5"},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L13,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":73.362300000000005},null,null,{"$f":"IF('Budget Period #1'!P13>0,'Budget Period #1'!P13,\"\")","v":"Division Staff"}]
["2.)",{"$f":"IF('Budget Period #1'!B14>0,'Budget Period #1'!B14,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D14>0,'Budget Period #1'!D14,\"\")","v":""},{"$f":"N14/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J14>0,'Budget Period #1'!J14,\"\")","v":""},{"$f":"IF('Budget Period #1'!K14>0,'Budget Period #1'!K14,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K14,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L14,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P14>0,'Budget Period #1'!P14,\"\")","v":"Division Staff"}]
["3.)",{"$f":"IF('Budget Period #1'!B15>0,'Budget Period #1'!B15,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D15>0,'Budget Period #1'!D15,\"\")","v":""},{"$f":"N15/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J15>0,'Budget Period #1'!J15,\"\")","v":""},{"$f":"IF('Budget Period #1'!K15>0,'Budget Period #1'!K15,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K15,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L15,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P15>0,'Budget Period #1'!P15,\"\")","v":"Division Staff"}]
["4.)",{"$f":"IF('Budget Period #1'!B16>0,'Budget Period #1'!B16,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D16>0,'Budget Period #1'!D16,\"\")","v":""},{"$f":"N16/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J16>0,'Budget Period #1'!J16,\"\")","v":""},{"$f":"IF('Budget Period #1'!K16>0,'Budget Period #1'!K16,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K16,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L16,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P16>0,'Budget Period #1'!P16,\"\")","v":"Division Staff"}]
["5.)",{"$f":"IF('Budget Period #1'!B17>0,'Budget Period #1'!B17,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D17>0,'Budget Period #1'!D17,\"\")","v":""},{"$f":"N17/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J17>0,'Budget Period #1'!J17,\"\")","v":""},{"$f":"IF('Budget Period #1'!K17>0,'Budget Period #1'!K17,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K17,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L17,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P17>0,'Budget Period #1'!P17,\"\")","v":"Division Staff"}]
["6.)",{"$f":"IF('Budget Period #1'!B18>0,'Budget Period #1'!B18,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D18>0,'Budget Period #1'!D18,\"\")","v":""},{"$f":"N18/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J18>0,'Budget Period #1'!J18,\"\")","v":""},{"$f":"IF('Budget Period #1'!K18>0,'Budget Period #1'!K18,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K18,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L18,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P18>0,'Budget Period #1'!P18,\"\")","v":"Division Staff"}]
["7.)",{"$f":"IF('Budget Period #1'!B19>0,'Budget Period #1'!B19,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D19>0,'Budget Period #1'!D19,\"\")","v":""},{"$f":"N19/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J19>0,'Budget Period #1'!J19,\"\")","v":""},{"$f":"IF('Budget Period #1'!K19>0,'Budget Period #1'!K19,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K19,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L19,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P19>0,'Budget Period #1'!P19,\"\")","v":"Division Staff"}]
["8.)",{"$f":"IF('Budget Period #1'!B20>0,'Budget Period #1'!B20,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D20>0,'Budget Period #1'!D20,\"\")","v":""},{"$f":"N20/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J20>0,'Budget Period #1'!J20,\"\")","v":""},{"$f":"IF('Budget Period #1'!K20>0,'Budget Period #1'!K20,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K20,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L20,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P20>0,'Budget Period #1'!P20,\"\")","v":"Division Staff"}]
["9.)",{"$f":"IF('Budget Period #1'!B21>0,'Budget Period #1'!B21,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D21>0,'Budget Period #1'!D21,\"\")","v":""},{"$f":"N21/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J21>0,'Budget Period #1'!J21,\"\")","v":""},{"$f":"IF('Budget Period #1'!K21>0,'Budget Period #1'!K21,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K21,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L21,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P21>0,'Budget Period #1'!P21,\"\")","v":"Division Staff"}]
["10.)",{"$f":"IF('Budget Period #1'!B22>0,'Budget Period #1'!B22,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D22>0,'Budget Period #1'!D22,\"\")","v":""},{"$f":"N22/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J22>0,'Budget Period #1'!J22,\"\")","v":""},{"$f":"IF('Budget Period #1'!K22>0,'Budget Period #1'!K22,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K22,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L22,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,null,{"$f":"IF('Budget Period #1'!P22>0,'Budget Period #1'!P22,\"\")","v":"Division Staff"}]
[null,null,null,null,null,null,"Total Senior/Key Personnel (A)",{"$f":"SUM(H13:H22)","v":0}]
[null,"B. Other Personnel"]
[null,"# of Personnel",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,null,null,null,null,null,null,"Project Role (to Group)"]
["1.)",null,null,"Post Doctoral Associates",{"$f":"SUMIF($P$26:$P$35,$D26,$N$26:$N$35)/(Rates!$B$22/12)","v":0},{"$f":"SUMIF($P$26:$P$35,$D26,$O$26:$O$35)","v":0},{"$f":"ROUND(F26*$G$10,2)","v":0},{"$f":"F26+G26","v":0},null,{"$f":"IF('Budget Period #1'!J26>0,'Budget Period #1'!J26,\"\")","v":""},{"$f":"IF('Budget Period #1'!K26>0,'Budget Period #1'!K26,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K26,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L26,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,{"$f":"ROUND(N26*M26,2)","v":0},{"$f":"IF('Budget Period #1'!P26>0,'Budget Period #1'!P26,\"\")","v":""}]
["2.)",null,null,"Graduate Students",{"$f":"SUMIF($P$26:$P$35,$D27,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,{"$f":"ROUND(F27*$G$9,2)","v":0},0,null,{"$f":"IF('Budget Period #1'!J27>0,'Budget Period #1'!J27,\"\")","v":""},{"$f":"IF('Budget Period #1'!K27>0,'Budget Period #1'!K27,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K27,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L27,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P27>0,'Budget Period #1'!P27,\"\")","v":""}]
["3.)",null,null,"Undergraduate Students",{"$f":"SUMIF($P$26:$P$35,$D28,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J28>0,'Budget Period #1'!J28,\"\")","v":""},{"$f":"IF('Budget Period #1'!K28>0,'Budget Period #1'!K28,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K28,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L28,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P28>0,'Budget Period #1'!P28,\"\")","v":""}]
["4.)",null,null,"Secretarial/Clerical",{"$f":"SUMIF($P$26:$P$35,$D29,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J29>0,'Budget Period #1'!J29,\"\")","v":""},{"$f":"IF('Budget Period #1'!K29>0,'Budget Period #1'!K29,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K29,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L29,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P29>0,'Budget Period #1'!P29,\"\")","v":""}]
["5.)",null,null,"Engineers",{"$f":"SUMIF($P$26:$P$35,$D30,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J30>0,'Budget Period #1'!J30,\"\")","v":""},{"$f":"IF('Budget Period #1'!K30>0,'Budget Period #1'!K30,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K30,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L30,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P30>0,'Budget Period #1'!P30,\"\")","v":""}]
["6.)",null,null,"Technicians",{"$f":"SUMIF($P$26:$P$35,$D31,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J31>0,'Budget Period #1'!J31,\"\")","v":""},{"$f":"IF('Budget Period #1'!K31>0,'Budget Period #1'!K31,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K31,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L31,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P31>0,'Budget Period #1'!P31,\"\")","v":""}]
["7.)",null,null,{"$f":"IF('Budget Period #1'!D32>0,'Budget Period #1'!D32,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D32,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J32>0,'Budget Period #1'!J32,\"\")","v":""},{"$f":"IF('Budget Period #1'!K32>0,'Budget Period #1'!K32,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K32,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L32,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P32>0,'Budget Period #1'!P32,\"\")","v":""}]
["8.)",null,null,{"$f":"IF('Budget Period #1'!D33>0,'Budget Period #1'!D33,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D33,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J33>0,'Budget Period #1'!J33,\"\")","v":""},{"$f":"IF('Budget Period #1'!K33>0,'Budget Period #1'!K33,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K33,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L33,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P33>0,'Budget Period #1'!P33,\"\")","v":""}]
["9.)",null,null,{"$f":"IF('Budget Period #1'!D34>0,'Budget Period #1'!D34,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D34,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J34>0,'Budget Period #1'!J34,\"\")","v":""},{"$f":"IF('Budget Period #1'!K34>0,'Budget Period #1'!K34,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K34,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L34,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P34>0,'Budget Period #1'!P34,\"\")","v":""}]
["10.)",null,null,{"$f":"IF('Budget Period #1'!D35>0,'Budget Period #1'!D35,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D35,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J35>0,'Budget Period #1'!J35,\"\")","v":""},{"$f":"IF('Budget Period #1'!K35>0,'Budget Period #1'!K35,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K35,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #2'!$L35,SLRs!$F$2:$F$21)*(1+Rates!$B$17)","v":0},null,0,{"$f":"IF('Budget Period #1'!P35>0,'Budget Period #1'!P35,\"\")","v":""}]
[null,null,null,null,null,null,"Total Other Personnel (B)",{"$f":"SUM(H26:H35)","v":0}]
[]
[null,null,null,null,null,null,"Total Salary, Wages and Fringe Benefits (A+B)",{"$f":"H23+H36","v":0}]
[null,"C. Equipment Description"]
[null,"Equipment Item",null,null,null,null,"Quantity","Funds Requested"]
["1.)",{"$f":"IF('Budget Period #1'!B41>0,'Budget Period #1'!B41,\"\")","v":""}]
["2.)",{"$f":"IF('Budget Period #1'!B42>0,'Budget Period #1'!B42,\"\")","v":""}]
["3.)",{"$f":"IF('Budget Period #1'!B43>0,'Budget Period #1'!B43,\"\")","v":""}]
["4.)",{"$f":"IF('Budget Period #1'!B44>0,'Budget Period #1'!B44,\"\")","v":""}]
["5.)",{"$f":"IF('Budget Period #1'!B45>0,'Budget Period #1'!B45,\"\")","v":""}]
["6.)",{"$f":"IF('Budget Period #1'!B46>0,'Budget Period #1'!B46,\"\")","v":""}]
["7.)",{"$f":"IF('Budget Period #1'!B47>0,'Budget Period #1'!B47,\"\")","v":""}]
["8.)",{"$f":"IF('Budget Period #1'!B48>0,'Budget Period #1'!B48,\"\")","v":""}]
["9.)",{"$f":"IF('Budget Period #1'!B49>0,'Budget Period #1'!B49,\"\")","v":""}]
["10.)",{"$f":"IF('Budget Period #1'!B50>0,'Budget Period #1'!B50,\"\")","v":""}]
[null,null,null,null,null,null,"Total Equipment (C)",{"$f":"SUM(H41:H50)","v":0}]
[null,"D. Travel"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Domestic Travel Costs (incl. Canada, Mexico, and US Possessions)"]
["2.)","Foreign Travel Costs"]
[null,null,null,null,null,null,"Total Travel (D)",{"$f":"SUM(H54:H55)","v":0}]
[null,"E. Participant/Trainee Support Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Tuition/Fees/Health Insurance"]
["2.)","Stipends"]
["3.)","Travel"]
["4.)","Subsistence"]
["5.)","Other"]
[null,null,null,null,null,"Number of Participant/Trainees"]
["NOTE: On #1-#5, enter total costs for ALL Participant/Trainees, not as a per participant cost.",null,null,null,null,null,"Total Participant/Trainee Support Costs (E)",{"$f":"SUM(H59:H63)","v":0}]
[null,"F. Other Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Materials and Supplies"]
["2.)","Publication Costs"]
["3.)","Consultant Services",null,null,null,null,null,null,null,"Subawards / Consortium / Contractual Costs"]
["4.)","ADP/Computer Services",null,null,null,null,null,null,null,"Subawards","National Labs","Pass through"]
["5.)","Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"J72+K72+L72","v":0}]
["6.)","Equipment or Facility Rental/User Fees"]
["7.)","Alternation and Renovations"]
["8.)","Other"]
[null,null,null,null,null,null,"Total Other Direct Costs (F)",{"$f":"SUM(H68:H75)","v":0}]
[null,"G. Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct Costs (A-F)",null,null,null,null,null,{"$f":"H23+H36+H51+H56+H65+H76","v":0}]
[]
[null,"H. Other Indirect Costs"]
[null,"Item",null,null,null,null,"FY2017 Rates","Funds Requested"]
["1.)","Salary, Wages & Fringe (Division staff)",null,null,null,"Program Support",{"$f":"Rates!B9","v":0.93530000000000002},{"$f":"ROUND((H36+SUMIF(P13:P22,'Quick Lookup'!H3,H13:H22))*G83,2)","v":0}]
["2.)","Salary, Wages & Fringe (Section staff)",null,null,null,"CSS Rate",{"$f":"Rates!B11","v":0.69469999999999998},{"$f":"ROUND(SUMIF(P13:P22,'Quick Lookup'!H4,H13:H22)*G84,2)","v":0}]
["3.)","General and Administrative (formula, Indirect on D & E)",null,null,null,null,{"$f":"Rates!B12","v":0.18720000000000001},{"$f":"ROUND((H56+H65)*G85,2)","v":0}]
["4.)","MSA (Materials/Services Acquisition) (formula, Indirect on C & F)",null,null,null,null,{"$f":"Rates!B10","v":0.2631},{"$f":"ROUND((H76+H51-K72-L72)*G86,2)","v":0}]
["5.)","Pass through",null,null,null,null,{"$f":"Rates!B15","v":4.2900000000000001E-2},{"$f":"ROUND(L72*G87,2)","v":0}]
["6.)","Pass through (National Laboratories)",null,null,null,null,{"$f":"Rates!B14","v":0.03},{"$f":"ROUND(K72*G88,2)","v":0}]
[null,null,null,null,null,null,"Total Indirect Costs (H)",{"$f":"SUM(H83:H88)","v":0}]
[]
[null,"I. Total Direct and Indirect Costs"]
[]
["1.)","Total Direct and Indirect Costs (G+H)",null,null,null,null,null,{"$f":"H79+H89","v":0}]

{"sheet":"Budget Period #3","index":3,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,9,9,13],[71,1,71,6],[53,1,53,6],[54,1,54,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[67,1,67,6],[68,1,68,6],[69,1,69,6],[70,1,70,6],[69,9,69,11],[86,1,86,4],[87,1,87,4],[92,1,92,6],[72,1,72,6],[73,1,73,6],[74,1,74,6],[78,1,78,6],[82,1,82,4],[83,1,83,4],[84,1,84,4],[85,1,85,4]]}
[null,{"$f":"'Budget Period #1'!B1:E1","v":"DOE National Laboratory Announcement"},null,null,{"$f":"IF('Budget Period #1'!E1>0,'Budget Period #1'!E1,\"\")","v":""}]
[null,"Proposal Title",null,{"$f":"IF('Budget Period #1'!D2>0,'Budget Period #1'!D2,\"\")","v":""}]
[null,"Note:  The budget submitted by the primary applicant must include all costs associated with the award. "]
[null,"Budget Period Information"]
[]
[null,"Budget Period Start Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Selecting Job Category and Title will populate Band, Rate, and Project Role"]
[null,"Budget Period End Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Adding hours will populate Months, Requested Salary, Fringe Benefits, and Funds Requested"]
[null,null,null,null,null,null,null,null,null,"Options: Rate can be selected by band only.  Project role can be customized."]
[null,"A. Senior/Key Person (required):",null,null,null,"Fringe Rate:",{"$f":"Rates!B6","v":0.29749999999999999}]
[null,null,null,null,null,"Fringe PostDoc:",{"$f":"Rates!B7","v":0.23749999999999999},null,null,"Labor Calculations (SLRs)"]
[]
[null,"Name",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,"Category","Job Title","Band","SLR + VO","Hours",null,"SWF Type (for OH)"]
["1.)",{"$f":"IF('Budget Period #1'!B13>0,'Budget Period #1'!B13,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D13>0,'Budget Period #1'!D13,\"\")","v":""},{"$f":"N13/(Rates!$B$22/12)","v":0},{"$f":"ROUND(M13*N13,2)","v":0},{"$f":"ROUND(F13*$G$9,2)","v":0},{"$f":"F13+G13","v":0},null,{"$f":"IF('Budget Period #1'!J13>0,'Budget Period #1'!J13,\"\")","v":"Engineers"},{"$f":"IF('Budget Period #1'!K13>0,'Budget Period #1'!K13,\"\")","v":"Senior Engineer"},{"$f":"IFERROR(VLOOKUP($K13,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":"E5"},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L13,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":75.709893600000001},null,null,{"$f":"IF('Budget Period #1'!P13>0,'Budget Period #1'!P13,\"\")","v":"Division Staff"}]
["2.)",{"$f":"IF('Budget Period #1'!B14>0,'Budget Period #1'!B14,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D14>0,'Budget Period #1'!D14,\"\")","v":""},{"$f":"N14/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J14>0,'Budget Period #1'!J14,\"\")","v":""},{"$f":"IF('Budget Period #1'!K14>0,'Budget Period #1'!K14,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K14,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L14,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P14>0,'Budget Period #1'!P14,\"\")","v":"Division Staff"}]
["3.)",{"$f":"IF('Budget Period #1'!B15>0,'Budget Period #1'!B15,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D15>0,'Budget Period #1'!D15,\"\")","v":""},{"$f":"N15/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J15>0,'Budget Period #1'!J15,\"\")","v":""},{"$f":"IF('Budget Period #1'!K15>0,'Budget Period #1'!K15,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K15,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L15,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P15>0,'Budget Period #1'!P15,\"\")","v":"Division Staff"}]
["4.)",{"$f":"IF('Budget Period #1'!B16>0,'Budget Period #1'!B16,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D16>0,'Budget Period #1'!D16,\"\")","v":""},{"$f":"N16/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J16>0,'Budget Period #1'!J16,\"\")","v":""},{"$f":"IF('Budget Period #1'!K16>0,'Budget Period #1'!K16,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K16,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L16,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P16>0,'Budget Period #1'!P16,\"\")","v":"Division Staff"}]
["5.)",{"$f":"IF('Budget Period #1'!B17>0,'Budget Period #1'!B17,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D17>0,'Budget Period #1'!D17,\"\")","v":""},{"$f":"N17/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J17>0,'Budget Period #1'!J17,\"\")","v":""},{"$f":"IF('Budget Period #1'!K17>0,'Budget Period #1'!K17,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K17,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L17,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P17>0,'Budget Period #1'!P17,\"\")","v":"Division Staff"}]
["6.)",{"$f":"IF('Budget Period #1'!B18>0,'Budget Period #1'!B18,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D18>0,'Budget Period #1'!D18,\"\")","v":""},{"$f":"N18/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J18>0,'Budget Period #1'!J18,\"\")","v":""},{"$f":"IF('Budget Period #1'!K18>0,'Budget Period #1'!K18,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K18,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L18,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P18>0,'Budget Period #1'!P18,\"\")","v":"Division Staff"}]
["7.)",{"$f":"IF('Budget Period #1'!B19>0,'Budget Period #1'!B19,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D19>0,'Budget Period #1'!D19,\"\")","v":""},{"$f":"N19/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J19>0,'Budget Period #1'!J19,\"\")","v":""},{"$f":"IF('Budget Period #1'!K19>0,'Budget Period #1'!K19,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K19,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L19,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P19>0,'Budget Period #1'!P19,\"\")","v":"Division Staff"}]
["8.)",{"$f":"IF('Budget Period #1'!B20>0,'Budget Period #1'!B20,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D20>0,'Budget Period #1'!D20,\"\")","v":""},{"$f":"N20/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J20>0,'Budget Period #1'!J20,\"\")","v":""},{"$f":"IF('Budget Period #1'!K20>0,'Budget Period #1'!K20,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K20,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L20,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P20>0,'Budget Period #1'!P20,\"\")","v":"Division Staff"}]
["9.)",{"$f":"IF('Budget Period #1'!B21>0,'Budget Period #1'!B21,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D21>0,'Budget Period #1'!D21,\"\")","v":""},{"$f":"N21/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J21>0,'Budget Period #1'!J21,\"\")","v":""},{"$f":"IF('Budget Period #1'!K21>0,'Budget Period #1'!K21,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K21,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L21,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P21>0,'Budget Period #1'!P21,\"\")","v":"Division Staff"}]
["10.)",{"$f":"IF('Budget Period #1'!B22>0,'Budget Period #1'!B22,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D22>0,'Budget Period #1'!D22,\"\")","v":""},{"$f":"N22/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J22>0,'Budget Period #1'!J22,\"\")","v":""},{"$f":"IF('Budget Period #1'!K22>0,'Budget Period #1'!K22,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K22,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L22,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,null,{"$f":"IF('Budget Period #1'!P22>0,'Budget Period #1'!P22,\"\")","v":"Division Staff"}]
[null,null,null,null,null,null,"Total Senior/Key Personnel (A)",{"$f":"SUM(H13:H22)","v":0}]
[null,"B. Other Personnel"]
[null,"# of Personnel",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,null,null,null,null,null,null,"Project Role (to Group)"]
["1.)",null,null,"Post Doctoral Associates",{"$f":"SUMIF($P$26:$P$35,$D26,$N$26:$N$35)/(Rates!$B$22/12)","v":0},{"$f":"SUMIF($P$26:$P$35,$D26,$O$26:$O$35)","v":0},{"$f":"ROUND(F26*$G$10,2)","v":0},{"$f":"F26+G26","v":0},null,{"$f":"IF('Budget Period #1'!J26>0,'Budget Period #1'!J26,\"\")","v":""},{"$f":"IF('Budget Period #1'!K26>0,'Budget Period #1'!K26,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K26,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L26,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,{"$f":"ROUND(N26*M26,2)","v":0},{"$f":"IF('Budget Period #1'!P26>0,'Budget Period #1'!P26,\"\")","v":""}]
["2.)",null,null,"Graduate Students",{"$f":"SUMIF($P$26:$P$35,$D27,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,{"$f":"ROUND(F27*$G$9,2)","v":0},0,null,{"$f":"IF('Budget Period #1'!J27>0,'Budget Period #1'!J27,\"\")","v":""},{"$f":"IF('Budget Period #1'!K27>0,'Budget Period #1'!K27,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K27,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L27,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P27>0,'Budget Period #1'!P27,\"\")","v":""}]
["3.)",null,null,"Undergraduate Students",{"$f":"SUMIF($P$26:$P$35,$D28,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J28>0,'Budget Period #1'!J28,\"\")","v":""},{"$f":"IF('Budget Period #1'!K28>0,'Budget Period #1'!K28,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K28,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L28,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P28>0,'Budget Period #1'!P28,\"\")","v":""}]
["4.)",null,null,"Secretarial/Clerical",{"$f":"SUMIF($P$26:$P$35,$D29,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J29>0,'Budget Period #1'!J29,\"\")","v":""},{"$f":"IF('Budget Period #1'!K29>0,'Budget Period #1'!K29,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K29,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L29,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P29>0,'Budget Period #1'!P29,\"\")","v":""}]
["5.)",null,null,"Engineers",{"$f":"SUMIF($P$26:$P$35,$D30,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J30>0,'Budget Period #1'!J30,\"\")","v":""},{"$f":"IF('Budget Period #1'!K30>0,'Budget Period #1'!K30,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K30,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L30,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P30>0,'Budget Period #1'!P30,\"\")","v":""}]
["6.)",null,null,"Technicians",{"$f":"SUMIF($P$26:$P$35,$D31,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J31>0,'Budget Period #1'!J31,\"\")","v":""},{"$f":"IF('Budget Period #1'!K31>0,'Budget Period #1'!K31,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K31,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L31,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P31>0,'Budget Period #1'!P31,\"\")","v":""}]
["7.)",null,null,{"$f":"IF('Budget Period #1'!D32>0,'Budget Period #1'!D32,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D32,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J32>0,'Budget Period #1'!J32,\"\")","v":""},{"$f":"IF('Budget Period #1'!K32>0,'Budget Period #1'!K32,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K32,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L32,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P32>0,'Budget Period #1'!P32,\"\")","v":""}]
["8.)",null,null,{"$f":"IF('Budget Period #1'!D33>0,'Budget Period #1'!D33,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D33,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J33>0,'Budget Period #1'!J33,\"\")","v":""},{"$f":"IF('Budget Period #1'!K33>0,'Budget Period #1'!K33,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K33,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L33,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P33>0,'Budget Period #1'!P33,\"\")","v":""}]
["9.)",null,null,{"$f":"IF('Budget Period #1'!D34>0,'Budget Period #1'!D34,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D34,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J34>0,'Budget Period #1'!J34,\"\")","v":""},{"$f":"IF('Budget Period #1'!K34>0,'Budget Period #1'!K34,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K34,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L34,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P34>0,'Budget Period #1'!P34,\"\")","v":""}]
["10.)",null,null,{"$f":"IF('Budget Period #1'!D35>0,'Budget Period #1'!D35,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D35,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J35>0,'Budget Period #1'!J35,\"\")","v":""},{"$f":"IF('Budget Period #1'!K35>0,'Budget Period #1'!K35,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K35,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #3'!$L35,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)","v":0},null,0,{"$f":"IF('Budget Period #1'!P35>0,'Budget Period #1'!P35,\"\")","v":""}]
[null,null,null,null,null,null,"Total Other Personnel (B)",{"$f":"SUM(H26:H35)","v":0}]
[]
[null,null,null,null,null,null,"Total Salary, Wages and Fringe Benefits (A+B)",{"$f":"H23+H36","v":0}]
[null,"C. Equipment Description"]
[null,"Equipment Item",null,null,null,null,"Quantity","Funds Requested"]
["1.)",{"$f":"IF('Budget Period #1'!B41>0,'Budget Period #1'!B41,\"\")","v":""}]
["2.)",{"$f":"IF('Budget Period #1'!B42>0,'Budget Period #1'!B42,\"\")","v":""}]
["3.)",{"$f":"IF('Budget Period #1'!B43>0,'Budget Period #1'!B43,\"\")","v":""}]
["4.)",{"$f":"IF('Budget Period #1'!B44>0,'Budget Period #1'!B44,\"\")","v":""}]
["5.)",{"$f":"IF('Budget Period #1'!B45>0,'Budget Period #1'!B45,\"\")","v":""}]
["6.)",{"$f":"IF('Budget Period #1'!B46>0,'Budget Period #1'!B46,\"\")","v":""}]
["7.)",{"$f":"IF('Budget Period #1'!B47>0,'Budget Period #1'!B47,\"\")","v":""}]
["8.)",{"$f":"IF('Budget Period #1'!B48>0,'Budget Period #1'!B48,\"\")","v":""}]
["9.)",{"$f":"IF('Budget Period #1'!B49>0,'Budget Period #1'!B49,\"\")","v":""}]
["10.)",{"$f":"IF('Budget Period #1'!B50>0,'Budget Period #1'!B50,\"\")","v":""}]
[null,null,null,null,null,null,"Total Equipment (C)",{"$f":"SUM(H41:H50)","v":0}]
[null,"D. Travel"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Domestic Travel Costs (incl. Canada, Mexico, and US Possessions)"]
["2.)","Foreign Travel Costs"]
[null,null,null,null,null,null,"Total Travel (D)",{"$f":"SUM(H54:H55)","v":0}]
[null,"E. Participant/Trainee Support Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Tuition/Fees/Health Insurance"]
["2.)","Stipends"]
["3.)","Travel"]
["4.)","Subsistence"]
["5.)","Other"]
[null,null,null,null,null,"Number of Participant/Trainees"]
["NOTE: On #1-#5, enter total costs for ALL Participant/Trainees, not as a per participant cost.",null,null,null,null,null,"Total Participant/Trainee Support Costs (E)",{"$f":"SUM(H59:H63)","v":0}]
[null,"F. Other Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Materials and Supplies"]
["2.)","Publication Costs"]
["3.)","Consultant Services",null,null,null,null,null,null,null,"Subawards / Consortium / Contractual Costs"]
["4.)","ADP/Computer Services",null,null,null,null,null,null,null,"Subawards","National Labs","Pass through"]
["5.)","Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"J72+K72+L72","v":0}]
["6.)","Equipment or Facility Rental/User Fees"]
["7.)","Alternation and Renovations"]
["8.)","Other"]
[null,null,null,null,null,null,"Total Other Direct Costs (F)",{"$f":"SUM(H68:H75)","v":0}]
[null,"G. Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct Costs (A-F)",null,null,null,null,null,{"$f":"H23+H36+H51+H56+H65+H76","v":0}]
[]
[null,"H. Other Indirect Costs"]
[null,"Item",null,null,null,null,"FY2017 Rates","Funds Requested"]
["1.)","Salary, Wages & Fringe (Division staff)",null,null,null,"Program Support",{"$f":"Rates!B9","v":0.93530000000000002},{"$f":"ROUND((H36+SUMIF(P13:P22,'Quick Lookup'!H3,H13:H22))*G83,2)","v":0}]
["2.)","Salary, Wages & Fringe (Section staff)",null,null,null,"CSS Rate",{"$f":"Rates!B11","v":0.69469999999999998},{"$f":"ROUND(SUMIF(P13:P22,'Quick Lookup'!H4,H13:H22)*G84,2)","v":0}]
["3.)","General and Administrative (formula, Indirect on D & E)",null,null,null,null,{"$f":"Rates!B12","v":0.18720000000000001},{"$f":"ROUND((H56+H65)*G85,2)","v":0}]
["4.)","MSA (Materials/Services Acquisition) (formula, Indirect on C & F)",null,null,null,null,{"$f":"Rates!B10","v":0.2631},{"$f":"ROUND((H76+H51-K72-L72)*G86,2)","v":0}]
["5.)","Pass through",null,null,null,null,{"$f":"Rates!B15","v":4.2900000000000001E-2},{"$f":"ROUND(L72*G87,2)","v":0}]
["6.)","Pass through (National Laboratories)",null,null,null,null,{"$f":"Rates!B14","v":0.03},{"$f":"ROUND(K72*G88,2)","v":0}]
[null,null,null,null,null,null,"Total Indirect Costs (H)",{"$f":"SUM(H83:H88)","v":0}]
[]
[null,"I. Total Direct and Indirect Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct and Indirect Costs (G+H)",null,null,null,null,null,{"$f":"H79+H89","v":0}]

{"sheet":"Budget Period #4","index":4,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,9,9,13],[71,1,71,6],[53,1,53,6],[54,1,54,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[67,1,67,6],[68,1,68,6],[69,1,69,6],[70,1,70,6],[69,9,69,11],[86,1,86,4],[87,1,87,4],[92,1,92,6],[72,1,72,6],[73,1,73,6],[74,1,74,6],[78,1,78,6],[82,1,82,4],[83,1,83,4],[84,1,84,4],[85,1,85,4]]}
[null,{"$f":"'Budget Period #1'!B1:E1","v":"DOE National Laboratory Announcement"},null,null,{"$f":"IF('Budget Period #1'!E1>0,'Budget Period #1'!E1,\"\")","v":""}]
[null,"Proposal Title",null,{"$f":"IF('Budget Period #1'!D2>0,'Budget Period #1'!D2,\"\")","v":""}]
[null,"Note:  The budget submitted by the primary applicant must include all costs associated with the award. "]
[null,"Budget Period Information"]
[]
[null,"Budget Period Start Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Selecting Job Category and Title will populate Band, Rate, and Project Role"]
[null,"Budget Period End Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Adding hours will populate Months, Requested Salary, Fringe Benefits, and Funds Requested"]
[null,null,null,null,null,null,null,null,null,"Options: Rate can be selected by band only.  Project role can be customized."]
[null,"A. Senior/Key Person (required):",null,null,null,"Fringe Rate:",{"$f":"Rates!B6","v":0.29749999999999999}]
[null,null,null,null,null,"Fringe PostDoc:",{"$f":"Rates!B7","v":0.23749999999999999},null,null,"Labor Calculations (SLRs)"]
[]
[null,"Name",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,"Category","Job Title","Band","SLR + VO","Hours",null,"SWF Type (for OH)"]
["1.)",{"$f":"IF('Budget Period #1'!B13>0,'Budget Period #1'!B13,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D13>0,'Budget Period #1'!D13,\"\")","v":""},{"$f":"N13/(Rates!$B$22/12)","v":0},{"$f":"ROUND(M13*N13,2)","v":0},{"$f":"ROUND(F13*$G$9,2)","v":0},{"$f":"F13+G13","v":0},null,{"$f":"IF('Budget Period #1'!J13>0,'Budget Period #1'!J13,\"\")","v":"Engineers"},{"$f":"IF('Budget Period #1'!K13>0,'Budget Period #1'!K13,\"\")","v":"Senior Engineer"},{"$f":"IFERROR(VLOOKUP($K13,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":"E5"},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L13,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":78.056900301599995},null,null,{"$f":"IF('Budget Period #1'!P13>0,'Budget Period #1'!P13,\"\")","v":"Division Staff"}]
["2.)",{"$f":"IF('Budget Period #1'!B14>0,'Budget Period #1'!B14,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D14>0,'Budget Period #1'!D14,\"\")","v":""},{"$f":"N14/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J14>0,'Budget Period #1'!J14,\"\")","v":""},{"$f":"IF('Budget Period #1'!K14>0,'Budget Period #1'!K14,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K14,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L14,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P14>0,'Budget Period #1'!P14,\"\")","v":"Division Staff"}]
["3.)",{"$f":"IF('Budget Period #1'!B15>0,'Budget Period #1'!B15,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D15>0,'Budget Period #1'!D15,\"\")","v":""},{"$f":"N15/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J15>0,'Budget Period #1'!J15,\"\")","v":""},{"$f":"IF('Budget Period #1'!K15>0,'Budget Period #1'!K15,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K15,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L15,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P15>0,'Budget Period #1'!P15,\"\")","v":"Division Staff"}]
["4.)",{"$f":"IF('Budget Period #1'!B16>0,'Budget Period #1'!B16,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D16>0,'Budget Period #1'!D16,\"\")","v":""},{"$f":"N16/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J16>0,'Budget Period #1'!J16,\"\")","v":""},{"$f":"IF('Budget Period #1'!K16>0,'Budget Period #1'!K16,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K16,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L16,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P16>0,'Budget Period #1'!P16,\"\")","v":"Division Staff"}]
["5.)",{"$f":"IF('Budget Period #1'!B17>0,'Budget Period #1'!B17,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D17>0,'Budget Period #1'!D17,\"\")","v":""},{"$f":"N17/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J17>0,'Budget Period #1'!J17,\"\")","v":""},{"$f":"IF('Budget Period #1'!K17>0,'Budget Period #1'!K17,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K17,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L17,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P17>0,'Budget Period #1'!P17,\"\")","v":"Division Staff"}]
["6.)",{"$f":"IF('Budget Period #1'!B18>0,'Budget Period #1'!B18,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D18>0,'Budget Period #1'!D18,\"\")","v":""},{"$f":"N18/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J18>0,'Budget Period #1'!J18,\"\")","v":""},{"$f":"IF('Budget Period #1'!K18>0,'Budget Period #1'!K18,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K18,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L18,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P18>0,'Budget Period #1'!P18,\"\")","v":"Division Staff"}]
["7.)",{"$f":"IF('Budget Period #1'!B19>0,'Budget Period #1'!B19,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D19>0,'Budget Period #1'!D19,\"\")","v":""},{"$f":"N19/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J19>0,'Budget Period #1'!J19,\"\")","v":""},{"$f":"IF('Budget Period #1'!K19>0,'Budget Period #1'!K19,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K19,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L19,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P19>0,'Budget Period #1'!P19,\"\")","v":"Division Staff"}]
["8.)",{"$f":"IF('Budget Period #1'!B20>0,'Budget Period #1'!B20,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D20>0,'Budget Period #1'!D20,\"\")","v":""},{"$f":"N20/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J20>0,'Budget Period #1'!J20,\"\")","v":""},{"$f":"IF('Budget Period #1'!K20>0,'Budget Period #1'!K20,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K20,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L20,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P20>0,'Budget Period #1'!P20,\"\")","v":"Division Staff"}]
["9.)",{"$f":"IF('Budget Period #1'!B21>0,'Budget Period #1'!B21,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D21>0,'Budget Period #1'!D21,\"\")","v":""},{"$f":"N21/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J21>0,'Budget Period #1'!J21,\"\")","v":""},{"$f":"IF('Budget Period #1'!K21>0,'Budget Period #1'!K21,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K21,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L21,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P21>0,'Budget Period #1'!P21,\"\")","v":"Division Staff"}]
["10.)",{"$f":"IF('Budget Period #1'!B22>0,'Budget Period #1'!B22,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D22>0,'Budget Period #1'!D22,\"\")","v":""},{"$f":"N22/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J22>0,'Budget Period #1'!J22,\"\")","v":""},{"$f":"IF('Budget Period #1'!K22>0,'Budget Period #1'!K22,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K22,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L22,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,null,{"$f":"IF('Budget Period #1'!P22>0,'Budget Period #1'!P22,\"\")","v":"Division Staff"}]
[null,null,null,null,null,null,"Total Senior/Key Personnel (A)",{"$f":"SUM(H13:H22)","v":0}]
[null,"B. Other Personnel"]
[null,"# of Personnel",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,null,null,null,null,null,null,"Project Role (to Group)"]
["1.)",null,null,"Post Doctoral Associates",{"$f":"SUMIF($P$26:$P$35,$D26,$N$26:$N$35)/(Rates!$B$22/12)","v":0},{"$f":"SUMIF($P$26:$P$35,$D26,$O$26:$O$35)","v":0},{"$f":"ROUND(F26*$G$10,2)","v":0},{"$f":"F26+G26","v":0},null,{"$f":"IF('Budget Period #1'!J26>0,'Budget Period #1'!J26,\"\")","v":""},{"$f":"IF('Budget Period #1'!K26>0,'Budget Period #1'!K26,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K26,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L26,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,{"$f":"ROUND(N26*M26,2)","v":0},{"$f":"IF('Budget Period #1'!P26>0,'Budget Period #1'!P26,\"\")","v":""}]
["2.)",null,null,"Graduate Students",{"$f":"SUMIF($P$26:$P$35,$D27,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,{"$f":"ROUND(F27*$G$9,2)","v":0},0,null,{"$f":"IF('Budget Period #1'!J27>0,'Budget Period #1'!J27,\"\")","v":""},{"$f":"IF('Budget Period #1'!K27>0,'Budget Period #1'!K27,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K27,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L27,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P27>0,'Budget Period #1'!P27,\"\")","v":""}]
["3.)",null,null,"Undergraduate Students",{"$f":"SUMIF($P$26:$P$35,$D28,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J28>0,'Budget Period #1'!J28,\"\")","v":""},{"$f":"IF('Budget Period #1'!K28>0,'Budget Period #1'!K28,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K28,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L28,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P28>0,'Budget Period #1'!P28,\"\")","v":""}]
["4.)",null,null,"Secretarial/Clerical",{"$f":"SUMIF($P$26:$P$35,$D29,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J29>0,'Budget Period #1'!J29,\"\")","v":""},{"$f":"IF('Budget Period #1'!K29>0,'Budget Period #1'!K29,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K29,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L29,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P29>0,'Budget Period #1'!P29,\"\")","v":""}]
["5.)",null,null,"Engineers",{"$f":"SUMIF($P$26:$P$35,$D30,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J30>0,'Budget Period #1'!J30,\"\")","v":""},{"$f":"IF('Budget Period #1'!K30>0,'Budget Period #1'!K30,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K30,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L30,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P30>0,'Budget Period #1'!P30,\"\")","v":""}]
["6.)",null,null,"Technicians",{"$f":"SUMIF($P$26:$P$35,$D31,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J31>0,'Budget Period #1'!J31,\"\")","v":""},{"$f":"IF('Budget Period #1'!K31>0,'Budget Period #1'!K31,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K31,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L31,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P31>0,'Budget Period #1'!P31,\"\")","v":""}]
["7.)",null,null,{"$f":"IF('Budget Period #1'!D32>0,'Budget Period #1'!D32,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D32,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J32>0,'Budget Period #1'!J32,\"\")","v":""},{"$f":"IF('Budget Period #1'!K32>0,'Budget Period #1'!K32,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K32,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L32,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P32>0,'Budget Period #1'!P32,\"\")","v":""}]
["8.)",null,null,{"$f":"IF('Budget Period #1'!D33>0,'Budget Period #1'!D33,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D33,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J33>0,'Budget Period #1'!J33,\"\")","v":""},{"$f":"IF('Budget Period #1'!K33>0,'Budget Period #1'!K33,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K33,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L33,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P33>0,'Budget Period #1'!P33,\"\")","v":""}]
["9.)",null,null,{"$f":"IF('Budget Period #1'!D34>0,'Budget Period #1'!D34,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D34,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J34>0,'Budget Period #1'!J34,\"\")","v":""},{"$f":"IF('Budget Period #1'!K34>0,'Budget Period #1'!K34,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K34,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L34,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P34>0,'Budget Period #1'!P34,\"\")","v":""}]
["10.)",null,null,{"$f":"IF('Budget Period #1'!D35>0,'Budget Period #1'!D35,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D35,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J35>0,'Budget Period #1'!J35,\"\")","v":""},{"$f":"IF('Budget Period #1'!K35>0,'Budget Period #1'!K35,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K35,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #4'!$L35,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)","v":0},null,0,{"$f":"IF('Budget Period #1'!P35>0,'Budget Period #1'!P35,\"\")","v":""}]
[null,null,null,null,null,null,"Total Other Personnel (B)",{"$f":"SUM(H26:H35)","v":0}]
[]
[null,null,null,null,null,null,"Total Salary, Wages and Fringe Benefits (A+B)",{"$f":"H23+H36","v":0}]
[null,"C. Equipment Description"]
[null,"Equipment Item",null,null,null,null,"Quantity","Funds Requested"]
["1.)",{"$f":"IF('Budget Period #1'!B41>0,'Budget Period #1'!B41,\"\")","v":""}]
["2.)",{"$f":"IF('Budget Period #1'!B42>0,'Budget Period #1'!B42,\"\")","v":""}]
["3.)",{"$f":"IF('Budget Period #1'!B43>0,'Budget Period #1'!B43,\"\")","v":""}]
["4.)",{"$f":"IF('Budget Period #1'!B44>0,'Budget Period #1'!B44,\"\")","v":""}]
["5.)",{"$f":"IF('Budget Period #1'!B45>0,'Budget Period #1'!B45,\"\")","v":""}]
["6.)",{"$f":"IF('Budget Period #1'!B46>0,'Budget Period #1'!B46,\"\")","v":""}]
["7.)",{"$f":"IF('Budget Period #1'!B47>0,'Budget Period #1'!B47,\"\")","v":""}]
["8.)",{"$f":"IF('Budget Period #1'!B48>0,'Budget Period #1'!B48,\"\")","v":""}]
["9.)",{"$f":"IF('Budget Period #1'!B49>0,'Budget Period #1'!B49,\"\")","v":""}]
["10.)",{"$f":"IF('Budget Period #1'!B50>0,'Budget Period #1'!B50,\"\")","v":""}]
[null,null,null,null,null,null,"Total Equipment (C)",{"$f":"SUM(H41:H50)","v":0}]
[null,"D. Travel"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Domestic Travel Costs (incl. Canada, Mexico, and US Possessions)"]
["2.)","Foreign Travel Costs"]
[null,null,null,null,null,null,"Total Travel (D)",{"$f":"SUM(H54:H55)","v":0}]
[null,"E. Participant/Trainee Support Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Tuition/Fees/Health Insurance"]
["2.)","Stipends"]
["3.)","Travel"]
["4.)","Subsistence"]
["5.)","Other"]
[null,null,null,null,null,"Number of Participant/Trainees"]
["NOTE: On #1-#5, enter total costs for ALL Participant/Trainees, not as a per participant cost.",null,null,null,null,null,"Total Participant/Trainee Support Costs (E)",{"$f":"SUM(H59:H63)","v":0}]
[null,"F. Other Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Materials and Supplies"]
["2.)","Publication Costs"]
["3.)","Consultant Services",null,null,null,null,null,null,null,"Subawards / Consortium / Contractual Costs"]
["4.)","ADP/Computer Services",null,null,null,null,null,null,null,"Subawards","National Labs","Pass through"]
["5.)","Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"J72+K72+L72","v":0}]
["6.)","Equipment or Facility Rental/User Fees"]
["7.)","Alternation and Renovations"]
["8.)","Other"]
[null,null,null,null,null,null,"Total Other Direct Costs (F)",{"$f":"SUM(H68:H75)","v":0}]
[null,"G. Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct Costs (A-F)",null,null,null,null,null,{"$f":"H23+H36+H51+H56+H65+H76","v":0}]
[]
[null,"H. Other Indirect Costs"]
[null,"Item",null,null,null,null,"FY2017 Rates","Funds Requested"]
["1.)","Salary, Wages & Fringe (Division staff)",null,null,null,"Program Support",{"$f":"Rates!B9","v":0.93530000000000002},{"$f":"ROUND((H36+SUMIF(P13:P22,'Quick Lookup'!H3,H13:H22))*G83,2)","v":0}]
["2.)","Salary, Wages & Fringe (Section staff)",null,null,null,"CSS Rate",{"$f":"Rates!B11","v":0.69469999999999998},{"$f":"ROUND(SUMIF(P13:P22,'Quick Lookup'!H4,H13:H22)*G84,2)","v":0}]
["3.)","General and Administrative (formula, Indirect on D & E)",null,null,null,null,{"$f":"Rates!B12","v":0.18720000000000001},{"$f":"ROUND((H56+H65)*G85,2)","v":0}]
["4.)","MSA (Materials/Services Acquisition) (formula, Indirect on C & F)",null,null,null,null,{"$f":"Rates!B10","v":0.2631},{"$f":"ROUND((H76+H51-K72-L72)*G86,2)","v":0}]
["5.)","Pass through",null,null,null,null,{"$f":"Rates!B15","v":4.2900000000000001E-2},{"$f":"ROUND(L72*G87,2)","v":0}]
["6.)","Pass through (National Laboratories)",null,null,null,null,{"$f":"Rates!B14","v":0.03},{"$f":"ROUND(K72*G88,2)","v":0}]
[null,null,null,null,null,null,"Total Indirect Costs (H)",{"$f":"SUM(H83:H88)","v":0}]
[]
[null,"I. Total Direct and Indirect Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct and Indirect Costs (G+H)",null,null,null,null,null,{"$f":"H79+H89","v":0}]

{"sheet":"Budget Period #5","index":5,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,9,9,13],[71,1,71,6],[53,1,53,6],[54,1,54,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[67,1,67,6],[68,1,68,6],[69,1,69,6],[70,1,70,6],[69,9,69,11],[86,1,86,4],[87,1,87,4],[92,1,92,6],[72,1,72,6],[73,1,73,6],[74,1,74,6],[78,1,78,6],[82,1,82,4],[83,1,83,4],[84,1,84,4],[85,1,85,4]]}
[null,{"$f":"'Budget Period #1'!B1:E1","v":"DOE National Laboratory Announcement"},null,null,{"$f":"IF('Budget Period #1'!E1>0,'Budget Period #1'!E1,\"\")","v":""}]
[null,"Proposal Title",null,{"$f":"IF('Budget Period #1'!D2>0,'Budget Period #1'!D2,\"\")","v":""}]
[null,"Note:  The budget submitted by the primary applicant must include all costs associated with the award. "]
[null,"Budget Period Information"]
[]
[null,"Budget Period Start Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Selecting Job Category and Title will populate Band, Rate, and Project Role"]
[null,"Budget Period End Date",null,null," (per Program Announcement Guidelines)",null,null,null,null,"Adding hours will populate Months, Requested Salary, Fringe Benefits, and Funds Requested"]
[null,null,null,null,null,null,null,null,null,"Options: Rate can be selected by band only.  Project role can be customized."]
[null,"A. Senior/Key Person (required):",null,null,null,"Fringe Rate:",{"$f":"Rates!B6","v":0.29749999999999999}]
[null,null,null,null,null,"Fringe PostDoc:",{"$f":"Rates!B7","v":0.23749999999999999},null,null,"Labor Calculations (SLRs)"]
[]
[null,"Name",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,"Category","Job Title","Band","SLR + VO","Hours",null,"SWF Type (for OH)"]
["1.)",{"$f":"IF('Budget Period #1'!B13>0,'Budget Period #1'!B13,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D13>0,'Budget Period #1'!D13,\"\")","v":""},{"$f":"N13/(Rates!$B$22/12)","v":0},{"$f":"ROUND(M13*N13,2)","v":0},{"$f":"ROUND(F13*$G$9,2)","v":0},{"$f":"F13+G13","v":0},null,{"$f":"IF('Budget Period #1'!J13>0,'Budget Period #1'!J13,\"\")","v":"Engineers"},{"$f":"IF('Budget Period #1'!K13>0,'Budget Period #1'!K13,\"\")","v":"Senior Engineer"},{"$f":"IFERROR(VLOOKUP($K13,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":"E5"},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L13,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":80.476664210949593},null,null,{"$f":"IF('Budget Period #1'!P13>0,'Budget Period #1'!P13,\"\")","v":"Division Staff"}]
["2.)",{"$f":"IF('Budget Period #1'!B14>0,'Budget Period #1'!B14,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D14>0,'Budget Period #1'!D14,\"\")","v":""},{"$f":"N14/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J14>0,'Budget Period #1'!J14,\"\")","v":""},{"$f":"IF('Budget Period #1'!K14>0,'Budget Period #1'!K14,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K14,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L14,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P14>0,'Budget Period #1'!P14,\"\")","v":"Division Staff"}]
["3.)",{"$f":"IF('Budget Period #1'!B15>0,'Budget Period #1'!B15,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D15>0,'Budget Period #1'!D15,\"\")","v":""},{"$f":"N15/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J15>0,'Budget Period #1'!J15,\"\")","v":""},{"$f":"IF('Budget Period #1'!K15>0,'Budget Period #1'!K15,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K15,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L15,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P15>0,'Budget Period #1'!P15,\"\")","v":"Division Staff"}]
["4.)",{"$f":"IF('Budget Period #1'!B16>0,'Budget Period #1'!B16,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D16>0,'Budget Period #1'!D16,\"\")","v":""},{"$f":"N16/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J16>0,'Budget Period #1'!J16,\"\")","v":""},{"$f":"IF('Budget Period #1'!K16>0,'Budget Period #1'!K16,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K16,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L16,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P16>0,'Budget Period #1'!P16,\"\")","v":"Division Staff"}]
["5.)",{"$f":"IF('Budget Period #1'!B17>0,'Budget Period #1'!B17,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D17>0,'Budget Period #1'!D17,\"\")","v":""},{"$f":"N17/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J17>0,'Budget Period #1'!J17,\"\")","v":""},{"$f":"IF('Budget Period #1'!K17>0,'Budget Period #1'!K17,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K17,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L17,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P17>0,'Budget Period #1'!P17,\"\")","v":"Division Staff"}]
["6.)",{"$f":"IF('Budget Period #1'!B18>0,'Budget Period #1'!B18,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D18>0,'Budget Period #1'!D18,\"\")","v":""},{"$f":"N18/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J18>0,'Budget Period #1'!J18,\"\")","v":""},{"$f":"IF('Budget Period #1'!K18>0,'Budget Period #1'!K18,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K18,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L18,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P18>0,'Budget Period #1'!P18,\"\")","v":"Division Staff"}]
["7.)",{"$f":"IF('Budget Period #1'!B19>0,'Budget Period #1'!B19,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D19>0,'Budget Period #1'!D19,\"\")","v":""},{"$f":"N19/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J19>0,'Budget Period #1'!J19,\"\")","v":""},{"$f":"IF('Budget Period #1'!K19>0,'Budget Period #1'!K19,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K19,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L19,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P19>0,'Budget Period #1'!P19,\"\")","v":"Division Staff"}]
["8.)",{"$f":"IF('Budget Period #1'!B20>0,'Budget Period #1'!B20,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D20>0,'Budget Period #1'!D20,\"\")","v":""},{"$f":"N20/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J20>0,'Budget Period #1'!J20,\"\")","v":""},{"$f":"IF('Budget Period #1'!K20>0,'Budget Period #1'!K20,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K20,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L20,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P20>0,'Budget Period #1'!P20,\"\")","v":"Division Staff"}]
["9.)",{"$f":"IF('Budget Period #1'!B21>0,'Budget Period #1'!B21,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D21>0,'Budget Period #1'!D21,\"\")","v":""},{"$f":"N21/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J21>0,'Budget Period #1'!J21,\"\")","v":""},{"$f":"IF('Budget Period #1'!K21>0,'Budget Period #1'!K21,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K21,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L21,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P21>0,'Budget Period #1'!P21,\"\")","v":"Division Staff"}]
["10.)",{"$f":"IF('Budget Period #1'!B22>0,'Budget Period #1'!B22,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D22>0,'Budget Period #1'!D22,\"\")","v":""},{"$f":"N22/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J22>0,'Budget Period #1'!J22,\"\")","v":""},{"$f":"IF('Budget Period #1'!K22>0,'Budget Period #1'!K22,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K22,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L22,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,null,{"$f":"IF('Budget Period #1'!P22>0,'Budget Period #1'!P22,\"\")","v":"Division Staff"}]
[null,null,null,null,null,null,"Total Senior/Key Personnel (A)",{"$f":"SUM(H13:H22)","v":0}]
[null,"B. Other Personnel"]
[null,"# of Personnel",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested",null,null,null,null,null,null,null,"Project Role (to Group)"]
["1.)",null,null,"Post Doctoral Associates",{"$f":"SUMIF($P$26:$P$35,$D26,$N$26:$N$35)/(Rates!$B$22/12)","v":0},{"$f":"SUMIF($P$26:$P$35,$D26,$O$26:$O$35)","v":0},{"$f":"ROUND(F26*$G$10,2)","v":0},{"$f":"F26+G26","v":0},null,{"$f":"IF('Budget Period #1'!J26>0,'Budget Period #1'!J26,\"\")","v":""},{"$f":"IF('Budget Period #1'!K26>0,'Budget Period #1'!K26,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K26,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L26,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,{"$f":"ROUND(N26*M26,2)","v":0},{"$f":"IF('Budget Period #1'!P26>0,'Budget Period #1'!P26,\"\")","v":""}]
["2.)",null,null,"Graduate Students",{"$f":"SUMIF($P$26:$P$35,$D27,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,{"$f":"ROUND(F27*$G$9,2)","v":0},0,null,{"$f":"IF('Budget Period #1'!J27>0,'Budget Period #1'!J27,\"\")","v":""},{"$f":"IF('Budget Period #1'!K27>0,'Budget Period #1'!K27,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K27,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L27,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P27>0,'Budget Period #1'!P27,\"\")","v":""}]
["3.)",null,null,"Undergraduate Students",{"$f":"SUMIF($P$26:$P$35,$D28,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J28>0,'Budget Period #1'!J28,\"\")","v":""},{"$f":"IF('Budget Period #1'!K28>0,'Budget Period #1'!K28,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K28,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L28,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P28>0,'Budget Period #1'!P28,\"\")","v":""}]
["4.)",null,null,"Secretarial/Clerical",{"$f":"SUMIF($P$26:$P$35,$D29,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J29>0,'Budget Period #1'!J29,\"\")","v":""},{"$f":"IF('Budget Period #1'!K29>0,'Budget Period #1'!K29,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K29,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L29,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P29>0,'Budget Period #1'!P29,\"\")","v":""}]
["5.)",null,null,"Engineers",{"$f":"SUMIF($P$26:$P$35,$D30,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J30>0,'Budget Period #1'!J30,\"\")","v":""},{"$f":"IF('Budget Period #1'!K30>0,'Budget Period #1'!K30,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K30,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L30,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P30>0,'Budget Period #1'!P30,\"\")","v":""}]
["6.)",null,null,"Technicians",{"$f":"SUMIF($P$26:$P$35,$D31,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J31>0,'Budget Period #1'!J31,\"\")","v":""},{"$f":"IF('Budget Period #1'!K31>0,'Budget Period #1'!K31,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K31,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L31,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P31>0,'Budget Period #1'!P31,\"\")","v":""}]
["7.)",null,null,{"$f":"IF('Budget Period #1'!D32>0,'Budget Period #1'!D32,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D32,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J32>0,'Budget Period #1'!J32,\"\")","v":""},{"$f":"IF('Budget Period #1'!K32>0,'Budget Period #1'!K32,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K32,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L32,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P32>0,'Budget Period #1'!P32,\"\")","v":""}]
["8.)",null,null,{"$f":"IF('Budget Period #1'!D33>0,'Budget Period #1'!D33,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D33,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J33>0,'Budget Period #1'!J33,\"\")","v":""},{"$f":"IF('Budget Period #1'!K33>0,'Budget Period #1'!K33,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K33,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L33,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P33>0,'Budget Period #1'!P33,\"\")","v":""}]
["9.)",null,null,{"$f":"IF('Budget Period #1'!D34>0,'Budget Period #1'!D34,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D34,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J34>0,'Budget Period #1'!J34,\"\")","v":""},{"$f":"IF('Budget Period #1'!K34>0,'Budget Period #1'!K34,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K34,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L34,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P34>0,'Budget Period #1'!P34,\"\")","v":""}]
["10.)",null,null,{"$f":"IF('Budget Period #1'!D35>0,'Budget Period #1'!D35,\"\")","v":""},{"$f":"SUMIF($P$26:$P$35,$D35,$N$26:$N$35)/(Rates!$B$22/12)","v":0},0,0,0,null,{"$f":"IF('Budget Period #1'!J35>0,'Budget Period #1'!J35,\"\")","v":""},{"$f":"IF('Budget Period #1'!K35>0,'Budget Period #1'!K35,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($K35,'Quick Lookup'!$C$3:$D$40,2,FALSE),\"\")","v":""},{"$f":"SUMIF(SLRs!$B$2:$B$21,'Budget Period #5'!$L35,SLRs!$F$2:$F$21)*(1+Rates!$B$17)*(1+Rates!$B$18)*(1+Rates!$B$19)*(1+Rates!$B$20)","v":0},null,0,{"$f":"IF('Budget Period #1'!P35>0,'Budget Period #1'!P35,\"\")","v":""}]
[null,null,null,null,null,null,"Total Other Personnel (B)",{"$f":"SUM(H26:H35)","v":0}]
[]
[null,null,null,null,null,null,"Total Salary, Wages and Fringe Benefits (A+B)",{"$f":"H23+H36","v":0}]
[null,"C. Equipment Description"]
[null,"Equipment Item",null,null,null,null,"Quantity","Funds Requested"]
["1.)",{"$f":"IF('Budget Period #1'!B41>0,'Budget Period #1'!B41,\"\")","v":""}]
["2.)",{"$f":"IF('Budget Period #1'!B42>0,'Budget Period #1'!B42,\"\")","v":""}]
["3.)",{"$f":"IF('Budget Period #1'!B43>0,'Budget Period #1'!B43,\"\")","v":""}]
["4.)",{"$f":"IF('Budget Period #1'!B44>0,'Budget Period #1'!B44,\"\")","v":""}]
["5.)",{"$f":"IF('Budget Period #1'!B45>0,'Budget Period #1'!B45,\"\")","v":""}]
["6.)",{"$f":"IF('Budget Period #1'!B46>0,'Budget Period #1'!B46,\"\")","v":""}]
["7.)",{"$f":"IF('Budget Period #1'!B47>0,'Budget Period #1'!B47,\"\")","v":""}]
["8.)",{"$f":"IF('Budget Period #1'!B48>0,'Budget Period #1'!B48,\"\")","v":""}]
["9.)",{"$f":"IF('Budget Period #1'!B49>0,'Budget Period #1'!B49,\"\")","v":""}]
["10.)",{"$f":"IF('Budget Period #1'!B50>0,'Budget Period #1'!B50,\"\")","v":""}]
[null,null,null,null,null,null,"Total Equipment (C)",{"$f":"SUM(H41:H50)","v":0}]
[null,"D. Travel"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Domestic Travel Costs (incl. Canada, Mexico, and US Possessions)"]
["2.)","Foreign Travel Costs"]
[null,null,null,null,null,null,"Total Travel (D)",{"$f":"SUM(H54:H55)","v":0}]
[null,"E. Participant/Trainee Support Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Tuition/Fees/Health Insurance"]
["2.)","Stipends"]
["3.)","Travel"]
["4.)","Subsistence"]
["5.)","Other"]
[null,null,null,null,null,"Number of Participant/Trainees"]
["NOTE: On #1-#5, enter total costs for ALL Participant/Trainees, not as a per participant cost.",null,null,null,null,null,"Total Participant/Trainee Support Costs (E)",{"$f":"SUM(H59:H63)","v":0}]
[null,"F. Other Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Materials and Supplies"]
["2.)","Publication Costs"]
["3.)","Consultant Services",null,null,null,null,null,null,null,"Subawards / Consortium / Contractual Costs"]
["4.)","ADP/Computer Services",null,null,null,null,null,null,null,"Subawards","National Labs","Pass through"]
["5.)","Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"J72+K72+L72","v":0}]
["6.)","Equipment or Facility Rental/User Fees"]
["7.)","Alternation and Renovations"]
["8.)","Other"]
[null,null,null,null,null,null,"Total Other Direct Costs (F)",{"$f":"SUM(H68:H75)","v":0}]
[null,"G. Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct Costs (A-F)",null,null,null,null,null,{"$f":"H23+H36+H51+H56+H65+H76","v":0}]
[]
[null,"H. Other Indirect Costs"]
[null,"Item",null,null,null,null,"FY2017 Rates","Funds Requested"]
["1.)","Salary, Wages & Fringe (Division staff)",null,null,null,"Program Support",{"$f":"Rates!B9","v":0.93530000000000002},{"$f":"ROUND((H36+SUMIF(P13:P22,'Quick Lookup'!H3,H13:H22))*G83,2)","v":0}]
["2.)","Salary, Wages & Fringe (Section staff)",null,null,null,"CSS Rate",{"$f":"Rates!B11","v":0.69469999999999998},{"$f":"ROUND(SUMIF(P13:P22,'Quick Lookup'!H4,H13:H22)*G84,2)","v":0}]
["3.)","General and Administrative (formula, Indirect on D & E)",null,null,null,null,{"$f":"Rates!B12","v":0.18720000000000001},{"$f":"ROUND((H56+H65)*G85,2)","v":0}]
["4.)","MSA (Materials/Services Acquisition) (formula, Indirect on C & F)",null,null,null,null,{"$f":"Rates!B10","v":0.2631},{"$f":"ROUND((H76+H51-K72-L72)*G86,2)","v":0}]
["5.)","Pass through",null,null,null,null,{"$f":"Rates!B15","v":4.2900000000000001E-2},{"$f":"ROUND(L72*G87,2)","v":0}]
["6.)","Pass through (National Laboratories)",null,null,null,null,{"$f":"Rates!B14","v":0.03},{"$f":"ROUND(K72*G88,2)","v":0}]
[null,null,null,null,null,null,"Total Indirect Costs (H)",{"$f":"SUM(H83:H88)","v":0}]
[]
[null,"I. Total Direct and Indirect Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct and Indirect Costs (G+H)",null,null,null,null,null,{"$f":"H79+H89","v":0}]

{"sheet":"Budget Summary","index":6,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[[61,1,61,6],[62,1,62,6],[67,1,67,6],[68,1,68,6],[69,1,69,6],[53,1,53,6],[54,1,54,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[69,9,69,11],[86,1,86,4],[87,1,87,4],[92,1,92,6],[72,1,72,6],[73,1,73,6],[74,1,74,6],[78,1,78,6],[82,1,82,4],[85,1,85,4],[83,1,83,4],[84,1,84,4],[71,1,71,6],[70,1,70,6]]}
[null,{"$f":"'Budget Period #1'!B1:E1","v":"DOE National Laboratory Announcement"},null,null,{"$f":"IF('Budget Period #1'!E1>0,'Budget Period #1'!E1,\"\")","v":""}]
[null,"Proposal Title",null,{"$f":"IF('Budget Period #1'!D2>0,'Budget Period #1'!D2,\"\")","v":""}]
[null,"Note:  The budget submitted by the primary applicant must include all costs associated with the award. "]
[null,"Budget Period Information"]
[]
[null,"Budget Period Start Date",null,null," (per Program Announcement Guidelines)"]
[null,"Budget Period End Date",null,null," (per Program Announcement Guidelines)"]
[]
[null,"A. Senior/Key Person (required):",null,null,null,"Fringe Rate:",{"$f":"Rates!B6","v":0.29749999999999999}]
[null,null,null,null,null,"Fringe PostDoc:",{"$f":"Rates!B7","v":0.23749999999999999}]
[]
[null,"Name",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested"]
["1.)",{"$f":"IF('Budget Period #1'!B13>0,'Budget Period #1'!B13,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D13>0,'Budget Period #1'!D13,\"\")","v":""},{"$f":"'Budget Period #1'!E13+'Budget Period #2'!E13+'Budget Period #3'!E13+'Budget Period #4'!E13+'Budget Period #5'!E13","v":0},{"$f":"'Budget Period #1'!F13+'Budget Period #2'!F13+'Budget Period #3'!F13+'Budget Period #4'!F13+'Budget Period #5'!F13","v":0},{"$f":"'Budget Period #1'!G13+'Budget Period #2'!G13+'Budget Period #3'!G13+'Budget Period #4'!G13+'Budget Period #5'!G13","v":0},{"$f":"F13+G13","v":0}]
["2.)",{"$f":"IF('Budget Period #1'!B14>0,'Budget Period #1'!B14,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D14>0,'Budget Period #1'!D14,\"\")","v":""},{"$f":"'Budget Period #1'!E14+'Budget Period #2'!E14+'Budget Period #3'!E14+'Budget Period #4'!E14+'Budget Period #5'!E14","v":0},{"$f":"'Budget Period #1'!F14+'Budget Period #2'!F14+'Budget Period #3'!F14+'Budget Period #4'!F14+'Budget Period #5'!F14","v":0},{"$f":"'Budget Period #1'!G14+'Budget Period #2'!G14+'Budget Period #3'!G14+'Budget Period #4'!G14+'Budget Period #5'!G14","v":0},0]
["3.)",{"$f":"IF('Budget Period #1'!B15>0,'Budget Period #1'!B15,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D15>0,'Budget Period #1'!D15,\"\")","v":""},{"$f":"'Budget Period #1'!E15+'Budget Period #2'!E15+'Budget Period #3'!E15+'Budget Period #4'!E15+'Budget Period #5'!E15","v":0},{"$f":"'Budget Period #1'!F15+'Budget Period #2'!F15+'Budget Period #3'!F15+'Budget Period #4'!F15+'Budget Period #5'!F15","v":0},{"$f":"'Budget Period #1'!G15+'Budget Period #2'!G15+'Budget Period #3'!G15+'Budget Period #4'!G15+'Budget Period #5'!G15","v":0},0]
["4.)",{"$f":"IF('Budget Period #1'!B16>0,'Budget Period #1'!B16,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D16>0,'Budget Period #1'!D16,\"\")","v":""},{"$f":"'Budget Period #1'!E16+'Budget Period #2'!E16+'Budget Period #3'!E16+'Budget Period #4'!E16+'Budget Period #5'!E16","v":0},{"$f":"'Budget Period #1'!F16+'Budget Period #2'!F16+'Budget Period #3'!F16+'Budget Period #4'!F16+'Budget Period #5'!F16","v":0},{"$f":"'Budget Period #1'!G16+'Budget Period #2'!G16+'Budget Period #3'!G16+'Budget Period #4'!G16+'Budget Period #5'!G16","v":0},0]
["5.)",{"$f":"IF('Budget Period #1'!B17>0,'Budget Period #1'!B17,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D17>0,'Budget Period #1'!D17,\"\")","v":""},{"$f":"'Budget Period #1'!E17+'Budget Period #2'!E17+'Budget Period #3'!E17+'Budget Period #4'!E17+'Budget Period #5'!E17","v":0},{"$f":"'Budget Period #1'!F17+'Budget Period #2'!F17+'Budget Period #3'!F17+'Budget Period #4'!F17+'Budget Period #5'!F17","v":0},{"$f":"'Budget Period #1'!G17+'Budget Period #2'!G17+'Budget Period #3'!G17+'Budget Period #4'!G17+'Budget Period #5'!G17","v":0},0]
["6.)",{"$f":"IF('Budget Period #1'!B18>0,'Budget Period #1'!B18,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D18>0,'Budget Period #1'!D18,\"\")","v":""},{"$f":"'Budget Period #1'!E18+'Budget Period #2'!E18+'Budget Period #3'!E18+'Budget Period #4'!E18+'Budget Period #5'!E18","v":0},{"$f":"'Budget Period #1'!F18+'Budget Period #2'!F18+'Budget Period #3'!F18+'Budget Period #4'!F18+'Budget Period #5'!F18","v":0},{"$f":"'Budget Period #1'!G18+'Budget Period #2'!G18+'Budget Period #3'!G18+'Budget Period #4'!G18+'Budget Period #5'!G18","v":0},0]
["7.)",{"$f":"IF('Budget Period #1'!B19>0,'Budget Period #1'!B19,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D19>0,'Budget Period #1'!D19,\"\")","v":""},{"$f":"'Budget Period #1'!E19+'Budget Period #2'!E19+'Budget Period #3'!E19+'Budget Period #4'!E19+'Budget Period #5'!E19","v":0},{"$f":"'Budget Period #1'!F19+'Budget Period #2'!F19+'Budget Period #3'!F19+'Budget Period #4'!F19+'Budget Period #5'!F19","v":0},{"$f":"'Budget Period #1'!G19+'Budget Period #2'!G19+'Budget Period #3'!G19+'Budget Period #4'!G19+'Budget Period #5'!G19","v":0},0]
["8.)",{"$f":"IF('Budget Period #1'!B20>0,'Budget Period #1'!B20,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D20>0,'Budget Period #1'!D20,\"\")","v":""},{"$f":"'Budget Period #1'!E20+'Budget Period #2'!E20+'Budget Period #3'!E20+'Budget Period #4'!E20+'Budget Period #5'!E20","v":0},{"$f":"'Budget Period #1'!F20+'Budget Period #2'!F20+'Budget Period #3'!F20+'Budget Period #4'!F20+'Budget Period #5'!F20","v":0},{"$f":"'Budget Period #1'!G20+'Budget Period #2'!G20+'Budget Period #3'!G20+'Budget Period #4'!G20+'Budget Period #5'!G20","v":0},0]
["9.)",{"$f":"IF('Budget Period #1'!B21>0,'Budget Period #1'!B21,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D21>0,'Budget Period #1'!D21,\"\")","v":""},{"$f":"'Budget Period #1'!E21+'Budget Period #2'!E21+'Budget Period #3'!E21+'Budget Period #4'!E21+'Budget Period #5'!E21","v":0},{"$f":"'Budget Period #1'!F21+'Budget Period #2'!F21+'Budget Period #3'!F21+'Budget Period #4'!F21+'Budget Period #5'!F21","v":0},{"$f":"'Budget Period #1'!G21+'Budget Period #2'!G21+'Budget Period #3'!G21+'Budget Period #4'!G21+'Budget Period #5'!G21","v":0},0]
["10.)",{"$f":"IF('Budget Period #1'!B22>0,'Budget Period #1'!B22,\"\")","v":""},null,{"$f":"IF('Budget Period #1'!D22>0,'Budget Period #1'!D22,\"\")","v":""},{"$f":"'Budget Period #1'!E22+'Budget Period #2'!E22+'Budget Period #3'!E22+'Budget Period #4'!E22+'Budget Period #5'!E22","v":0},{"$f":"'Budget Period #1'!F22+'Budget Period #2'!F22+'Budget Period #3'!F22+'Budget Period #4'!F22+'Budget Period #5'!F22","v":0},{"$f":"'Budget Period #1'!G22+'Budget Period #2'!G22+'Budget Period #3'!G22+'Budget Period #4'!G22+'Budget Period #5'!G22","v":0},0]
[null,null,null,null,null,null,"Total Senior/Key Personnel (A)",{"$f":"SUM(H13:H22)","v":0}]
[null,"B. Other Personnel"]
[null,"# of Personnel",null,"Project Role","Months","Requested Salary ($)","Fringe Benefits","Funds Requested"]
["1.)",{"$f":"'Budget Period #1'!B26+'Budget Period #2'!B26+'Budget Period #3'!B26+'Budget Period #4'!B26+'Budget Period #5'!B26","v":0},null,"Post Doctoral Associates",{"$f":"'Budget Period #1'!E26+'Budget Period #2'!E26+'Budget Period #3'!E26+'Budget Period #4'!E26+'Budget Period #5'!E26","v":0},{"$f":"'Budget Period #1'!F26+'Budget Period #2'!F26+'Budget Period #3'!F26+'Budget Period #4'!F26+'Budget Period #5'!F26","v":0},{"$f":"'Budget Period #1'!G26+'Budget Period #2'!G26+'Budget Period #3'!G26+'Budget Period #4'!G26+'Budget Period #5'!G26","v":0},{"$f":"F26+G26","v":0}]
["2.)",{"$f":"'Budget Period #1'!B27+'Budget Period #2'!B27+'Budget Period #3'!B27+'Budget Period #4'!B27+'Budget Period #5'!B27","v":0},null,"Graduate Students",{"$f":"'Budget Period #1'!E27+'Budget Period #2'!E27+'Budget Period #3'!E27+'Budget Period #4'!E27+'Budget Period #5'!E27","v":0},{"$f":"'Budget Period #1'!F27+'Budget Period #2'!F27+'Budget Period #3'!F27+'Budget Period #4'!F27+'Budget Period #5'!F27","v":0},{"$f":"'Budget Period #1'!G27+'Budget Period #2'!G27+'Budget Period #3'!G27+'Budget Period #4'!G27+'Budget Period #5'!G27","v":0},0]
["3.)",{"$f":"'Budget Period #1'!B28+'Budget Period #2'!B28+'Budget Period #3'!B28+'Budget Period #4'!B28+'Budget Period #5'!B28","v":0},null,"Undergraduate Students",{"$f":"'Budget Period #1'!E28+'Budget Period #2'!E28+'Budget Period #3'!E28+'Budget Period #4'!E28+'Budget Period #5'!E28","v":0},{"$f":"'Budget Period #1'!F28+'Budget Period #2'!F28+'Budget Period #3'!F28+'Budget Period #4'!F28+'Budget Period #5'!F28","v":0},{"$f":"'Budget Period #1'!G28+'Budget Period #2'!G28+'Budget Period #3'!G28+'Budget Period #4'!G28+'Budget Period #5'!G28","v":0},0]
["4.)",{"$f":"'Budget Period #1'!B29+'Budget Period #2'!B29+'Budget Period #3'!B29+'Budget Period #4'!B29+'Budget Period #5'!B29","v":0},null,"Secretarial/Clerical",{"$f":"'Budget Period #1'!E29+'Budget Period #2'!E29+'Budget Period #3'!E29+'Budget Period #4'!E29+'Budget Period #5'!E29","v":0},{"$f":"'Budget Period #1'!F29+'Budget Period #2'!F29+'Budget Period #3'!F29+'Budget Period #4'!F29+'Budget Period #5'!F29","v":0},{"$f":"'Budget Period #1'!G29+'Budget Period #2'!G29+'Budget Period #3'!G29+'Budget Period #4'!G29+'Budget Period #5'!G29","v":0},0]
["5.)",{"$f":"'Budget Period #1'!B30+'Budget Period #2'!B30+'Budget Period #3'!B30+'Budget Period #4'!B30+'Budget Period #5'!B30","v":0},null,"Engineers",{"$f":"'Budget Period #1'!E30+'Budget Period #2'!E30+'Budget Period #3'!E30+'Budget Period #4'!E30+'Budget Period #5'!E30","v":0},{"$f":"'Budget Period #1'!F30+'Budget Period #2'!F30+'Budget Period #3'!F30+'Budget Period #4'!F30+'Budget Period #5'!F30","v":0},{"$f":"'Budget Period #1'!G30+'Budget Period #2'!G30+'Budget Period #3'!G30+'Budget Period #4'!G30+'Budget Period #5'!G30","v":0},0]
["6.)",{"$f":"'Budget Period #1'!B31+'Budget Period #2'!B31+'Budget Period #3'!B31+'Budget Period #4'!B31+'Budget Period #5'!B31","v":0},null,"Technicians",{"$f":"'Budget Period #1'!E31+'Budget Period #2'!E31+'Budget Period #3'!E31+'Budget Period #4'!E31+'Budget Period #5'!E31","v":0},{"$f":"'Budget Period #1'!F31+'Budget Period #2'!F31+'Budget Period #3'!F31+'Budget Period #4'!F31+'Budget Period #5'!F31","v":0},{"$f":"'Budget Period #1'!G31+'Budget Period #2'!G31+'Budget Period #3'!G31+'Budget Period #4'!G31+'Budget Period #5'!G31","v":0},0]
["7.)",{"$f":"'Budget Period #1'!B32+'Budget Period #2'!B32+'Budget Period #3'!B32+'Budget Period #4'!B32+'Budget Period #5'!B32","v":0},null,{"$f":"IF('Budget Period #1'!D32>0,'Budget Period #1'!D32,\"\")","v":""},{"$f":"'Budget Period #1'!E32+'Budget Period #2'!E32+'Budget Period #3'!E32+'Budget Period #4'!E32+'Budget Period #5'!E32","v":0},{"$f":"'Budget Period #1'!F32+'Budget Period #2'!F32+'Budget Period #3'!F32+'Budget Period #4'!F32+'Budget Period #5'!F32","v":0},{"$f":"'Budget Period #1'!G32+'Budget Period #2'!G32+'Budget Period #3'!G32+'Budget Period #4'!G32+'Budget Period #5'!G32","v":0},0]
["8.)",{"$f":"'Budget Period #1'!B33+'Budget Period #2'!B33+'Budget Period #3'!B33+'Budget Period #4'!B33+'Budget Period #5'!B33","v":0},null,{"$f":"IF('Budget Period #1'!D33>0,'Budget Period #1'!D33,\"\")","v":""},{"$f":"'Budget Period #1'!E33+'Budget Period #2'!E33+'Budget Period #3'!E33+'Budget Period #4'!E33+'Budget Period #5'!E33","v":0},{"$f":"'Budget Period #1'!F33+'Budget Period #2'!F33+'Budget Period #3'!F33+'Budget Period #4'!F33+'Budget Period #5'!F33","v":0},{"$f":"'Budget Period #1'!G33+'Budget Period #2'!G33+'Budget Period #3'!G33+'Budget Period #4'!G33+'Budget Period #5'!G33","v":0},0]
["9.)",{"$f":"'Budget Period #1'!B34+'Budget Period #2'!B34+'Budget Period #3'!B34+'Budget Period #4'!B34+'Budget Period #5'!B34","v":0},null,{"$f":"IF('Budget Period #1'!D34>0,'Budget Period #1'!D34,\"\")","v":""},{"$f":"'Budget Period #1'!E34+'Budget Period #2'!E34+'Budget Period #3'!E34+'Budget Period #4'!E34+'Budget Period #5'!E34","v":0},{"$f":"'Budget Period #1'!F34+'Budget Period #2'!F34+'Budget Period #3'!F34+'Budget Period #4'!F34+'Budget Period #5'!F34","v":0},{"$f":"'Budget Period #1'!G34+'Budget Period #2'!G34+'Budget Period #3'!G34+'Budget Period #4'!G34+'Budget Period #5'!G34","v":0},0]
["10.)",{"$f":"'Budget Period #1'!B35+'Budget Period #2'!B35+'Budget Period #3'!B35+'Budget Period #4'!B35+'Budget Period #5'!B35","v":0},null,{"$f":"IF('Budget Period #1'!D35>0,'Budget Period #1'!D35,\"\")","v":""},{"$f":"'Budget Period #1'!E35+'Budget Period #2'!E35+'Budget Period #3'!E35+'Budget Period #4'!E35+'Budget Period #5'!E35","v":0},{"$f":"'Budget Period #1'!F35+'Budget Period #2'!F35+'Budget Period #3'!F35+'Budget Period #4'!F35+'Budget Period #5'!F35","v":0},{"$f":"'Budget Period #1'!G35+'Budget Period #2'!G35+'Budget Period #3'!G35+'Budget Period #4'!G35+'Budget Period #5'!G35","v":0},0]
[null,null,null,null,null,null,"Total Other Personnel (B)",{"$f":"SUM(H26:H35)","v":0}]
[]
[null,null,null,null,null,null,"Total Salary, Wages and Fringe Benefits (A+B)",{"$f":"H23+H36","v":0}]
[null,"C. Equipment Description"]
[null,"Equipment Item",null,null,null,null,"Quantity","Funds Requested"]
["1.)",{"$f":"IF('Budget Period #1'!B41>0,'Budget Period #1'!B41,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G41+'Budget Period #2'!G41+'Budget Period #3'!G41+'Budget Period #4'!G41+'Budget Period #5'!G41","v":0},{"$f":"'Budget Period #1'!H41+'Budget Period #2'!H41+'Budget Period #3'!H41+'Budget Period #4'!H41+'Budget Period #5'!H41","v":0}]
["2.)",{"$f":"IF('Budget Period #1'!B42>0,'Budget Period #1'!B42,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G42+'Budget Period #2'!G42+'Budget Period #3'!G42+'Budget Period #4'!G42+'Budget Period #5'!G42","v":0},{"$f":"'Budget Period #1'!H42+'Budget Period #2'!H42+'Budget Period #3'!H42+'Budget Period #4'!H42+'Budget Period #5'!H42","v":0}]
["3.)",{"$f":"IF('Budget Period #1'!B43>0,'Budget Period #1'!B43,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G43+'Budget Period #2'!G43+'Budget Period #3'!G43+'Budget Period #4'!G43+'Budget Period #5'!G43","v":0},{"$f":"'Budget Period #1'!H43+'Budget Period #2'!H43+'Budget Period #3'!H43+'Budget Period #4'!H43+'Budget Period #5'!H43","v":0}]
["4.)",{"$f":"IF('Budget Period #1'!B44>0,'Budget Period #1'!B44,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G44+'Budget Period #2'!G44+'Budget Period #3'!G44+'Budget Period #4'!G44+'Budget Period #5'!G44","v":0},{"$f":"'Budget Period #1'!H44+'Budget Period #2'!H44+'Budget Period #3'!H44+'Budget Period #4'!H44+'Budget Period #5'!H44","v":0}]
["5.)",{"$f":"IF('Budget Period #1'!B45>0,'Budget Period #1'!B45,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G45+'Budget Period #2'!G45+'Budget Period #3'!G45+'Budget Period #4'!G45+'Budget Period #5'!G45","v":0},{"$f":"'Budget Period #1'!H45+'Budget Period #2'!H45+'Budget Period #3'!H45+'Budget Period #4'!H45+'Budget Period #5'!H45","v":0}]
["6.)",{"$f":"IF('Budget Period #1'!B46>0,'Budget Period #1'!B46,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G46+'Budget Period #2'!G46+'Budget Period #3'!G46+'Budget Period #4'!G46+'Budget Period #5'!G46","v":0},{"$f":"'Budget Period #1'!H46+'Budget Period #2'!H46+'Budget Period #3'!H46+'Budget Period #4'!H46+'Budget Period #5'!H46","v":0}]
["7.)",{"$f":"IF('Budget Period #1'!B47>0,'Budget Period #1'!B47,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G47+'Budget Period #2'!G47+'Budget Period #3'!G47+'Budget Period #4'!G47+'Budget Period #5'!G47","v":0},{"$f":"'Budget Period #1'!H47+'Budget Period #2'!H47+'Budget Period #3'!H47+'Budget Period #4'!H47+'Budget Period #5'!H47","v":0}]
["8.)",{"$f":"IF('Budget Period #1'!B48>0,'Budget Period #1'!B48,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G48+'Budget Period #2'!G48+'Budget Period #3'!G48+'Budget Period #4'!G48+'Budget Period #5'!G48","v":0},{"$f":"'Budget Period #1'!H48+'Budget Period #2'!H48+'Budget Period #3'!H48+'Budget Period #4'!H48+'Budget Period #5'!H48","v":0}]
["9.)",{"$f":"IF('Budget Period #1'!B49>0,'Budget Period #1'!B49,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G49+'Budget Period #2'!G49+'Budget Period #3'!G49+'Budget Period #4'!G49+'Budget Period #5'!G49","v":0},{"$f":"'Budget Period #1'!H49+'Budget Period #2'!H49+'Budget Period #3'!H49+'Budget Period #4'!H49+'Budget Period #5'!H49","v":0}]
["10.)",{"$f":"IF('Budget Period #1'!B50>0,'Budget Period #1'!B50,\"\")","v":""},null,null,null,null,{"$f":"'Budget Period #1'!G50+'Budget Period #2'!G50+'Budget Period #3'!G50+'Budget Period #4'!G50+'Budget Period #5'!G50","v":0},{"$f":"'Budget Period #1'!H50+'Budget Period #2'!H50+'Budget Period #3'!H50+'Budget Period #4'!H50+'Budget Period #5'!H50","v":0}]
[null,null,null,null,null,null,"Total Equipment (C)",{"$f":"SUM(H41:H50)","v":0}]
[null,"D. Travel"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Domestic Travel Costs (incl. Canada, Mexico, and US Possessions)",null,null,null,null,null,{"$f":"'Budget Period #1'!H54+'Budget Period #2'!H54+'Budget Period #3'!H54+'Budget Period #4'!H54+'Budget Period #5'!H54","v":0}]
["2.)","Foreign Travel Costs",null,null,null,null,null,{"$f":"'Budget Period #1'!H55+'Budget Period #2'!H55+'Budget Period #3'!H55+'Budget Period #4'!H55+'Budget Period #5'!H55","v":0}]
[null,null,null,null,null,null,"Total Travel (D)",{"$f":"SUM(H54:H55)","v":0}]
[null,"E. Participant/Trainee Support Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Tuition/Fees/Health Insurance",null,null,null,null,null,{"$f":"'Budget Period #1'!H59+'Budget Period #2'!H59+'Budget Period #3'!H59+'Budget Period #4'!H59+'Budget Period #5'!H59","v":0}]
["2.)","Stipends",null,null,null,null,null,{"$f":"'Budget Period #1'!H60+'Budget Period #2'!H60+'Budget Period #3'!H60+'Budget Period #4'!H60+'Budget Period #5'!H60","v":0}]
["3.)","Travel",null,null,null,null,null,{"$f":"'Budget Period #1'!H61+'Budget Period #2'!H61+'Budget Period #3'!H61+'Budget Period #4'!H61+'Budget Period #5'!H61","v":0}]
["4.)","Subsistence",null,null,null,null,null,{"$f":"'Budget Period #1'!H62+'Budget Period #2'!H62+'Budget Period #3'!H62+'Budget Period #4'!H62+'Budget Period #5'!H62","v":0}]
["5.)","Other",null,null,null,null,null,{"$f":"'Budget Period #1'!H63+'Budget Period #2'!H63+'Budget Period #3'!H63+'Budget Period #4'!H63+'Budget Period #5'!H63","v":0}]
[null,null,null,null,null,"Number of Participant/Trainees",{"$f":"'Budget Period #1'!G64+'Budget Period #2'!G64+'Budget Period #3'!G64+'Budget Period #4'!G64+'Budget Period #5'!G64","v":0}]
["NOTE: On #1-#5, enter total costs for ALL Participant/Trainees, not as a per participant cost.",null,null,null,null,null,"Total Participant/Trainee Support Costs (E)",{"$f":"SUM(H59:H63)","v":0}]
[null,"F. Other Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Materials and Supplies",null,null,null,null,null,{"$f":"'Budget Period #1'!H68+'Budget Period #2'!H68+'Budget Period #3'!H68+'Budget Period #4'!H68+'Budget Period #5'!H68","v":0}]
["2.)","Publication Costs",null,null,null,null,null,{"$f":"'Budget Period #1'!H69+'Budget Period #2'!H69+'Budget Period #3'!H69+'Budget Period #4'!H69+'Budget Period #5'!H69","v":0}]
["3.)","Consultant Services",null,null,null,null,null,{"$f":"'Budget Period #1'!H70+'Budget Period #2'!H70+'Budget Period #3'!H70+'Budget Period #4'!H70+'Budget Period #5'!H70","v":0},null,"Subawards / Consortium / Contractual Costs"]
["4.)","ADP/Computer Services",null,null,null,null,null,{"$f":"'Budget Period #1'!H71+'Budget Period #2'!H71+'Budget Period #3'!H71+'Budget Period #4'!H71+'Budget Period #5'!H71","v":0},null,"Subawards","National Labs","Pass through"]
["5.)","Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"'Budget Period #1'!H72+'Budget Period #2'!H72+'Budget Period #3'!H72+'Budget Period #4'!H72+'Budget Period #5'!H72","v":0},null,{"$f":"'Budget Period #1'!J72+'Budget Period #2'!J72+'Budget Period #3'!J72+'Budget Period #4'!J72+'Budget Period #5'!J72","v":0},{"$f":"'Budget Period #1'!K72+'Budget Period #2'!K72+'Budget Period #3'!K72+'Budget Period #4'!K72+'Budget Period #5'!K72","v":0},{"$f":"'Budget Period #1'!L72+'Budget Period #2'!L72+'Budget Period #3'!L72+'Budget Period #4'!L72+'Budget Period #5'!L72","v":0}]
["6.)","Equipment or Facility Rental/User Fees",null,null,null,null,null,{"$f":"'Budget Period #1'!H73+'Budget Period #2'!H73+'Budget Period #3'!H73+'Budget Period #4'!H73+'Budget Period #5'!H73","v":0}]
["7.)","Alternation and Renovations",null,null,null,null,null,{"$f":"'Budget Period #1'!H74+'Budget Period #2'!H74+'Budget Period #3'!H74+'Budget Period #4'!H74+'Budget Period #5'!H74","v":0}]
["8.)","Other",null,null,null,null,null,{"$f":"'Budget Period #1'!H75+'Budget Period #2'!H75+'Budget Period #3'!H75+'Budget Period #4'!H75+'Budget Period #5'!H75","v":0}]
[null,null,null,null,null,null,"Total Other Direct Costs (F)",{"$f":"SUM(H68:H75)","v":0}]
[null,"G. Direct Costs"]
[null,"Item",null,null,null,null,null,"Funds Requested"]
["1.)","Total Direct Costs (A-F)",null,null,null,null,null,{"$f":"H23+H36+H51+H56+H65+H76","v":0}]
[]
[null,"H. Other Indirect Costs"]
[null,"Item",null,null,null,null,"FY2017 Rates","Funds Requested"]
["1.)","Salary, Wages & Fringe (Division staff)",null,null,null,"Program Support",{"$f":"Rates!B9","v":0.93530000000000002},{"$f":"'Budget Period #1'!H83+'Budget Period #2'!H83+'Budget Period #3'!H83+'Budget Period #4'!H83+'Budget Period #5'!H83","v":0}]
["2.)","Salary, Wages & Fringe (Section staff)",null,null,null,"CSS Rate",{"$f":"Rates!B11","v":0.69469999999999998},{"$f":"'Budget Period #1'!H84+'Budget Period #2'!H84+'Budget Period #3'!H84+'Budget Period #4'!H84+'Budget Period #5'!H84","v":0}]
["3.)","General and Administrative (formula, Indirect on D & E)",null,null,null,null,{"$f":"Rates!B12","v":0.18720000000000001},{"$f":"'Budget Period #1'!H85+'Budget Period #2'!H85+'Budget Period #3'!H85+'Budget Period #4'!H85+'Budget Period #5'!H85","v":0}]
["4.)","MSA (Materials/Services Acquisition) (formula, Indirect on C & F)",null,null,null,null,{"$f":"Rates!B10","v":0.2631},{"$f":"'Budget Period #1'!H86+'Budget Period #2'!H86+'Budget Period #3'!H86+'Budget Period #4'!H86+'Budget Period #5'!H86","v":0}]
["5.)","Pass through",null,null,null,null,{"$f":"Rates!B15","v":4.2900000000000001E-2},{"$f":"'Budget Period #1'!H87+'Budget Period #2'!H87+'Budget Period #3'!H87+'Budget Period #4'!H87+'Budget Period #5'!H87","v":0}]
["6.)","Pass through (National Laboratories)",null,null,null,null,{"$f":"Rates!B14","v":0.03},{"$f":"'Budget Period #1'!H88+'Budget Period #2'!H88+'Budget Period #3'!H88+'Budget Period #4'!H88+'Budget Period #5'!H88","v":0}]
[null,null,null,null,null,null,"Total Indirect Costs (H)",{"$f":"SUM(H83:H88)","v":0}]
[]
[null,"I. Total Direct and Indirect Costs"]
[]
["1.)","Total Direct and Indirect Costs (G+H)",null,null,null,null,null,{"$f":"H79+H89","v":0}]

{"sheet":"Quick Lookup","index":7,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":true,"merged":[[2,1,7,1],[8,1,15,1],[16,1,20,1],[21,1,30,1],[31,1,36,1]]}
[]
[null,"FY16 Preliminary v2","Job Title","Band"]
[null,"Designers & Drafters","Drafter","N2",null,"Designers_Drafters",null,"Division Staff"]
[null,null,"Drafter Sr","N3",null,"Engineers",null,"Section Staff"]
[null,null,"Designer","N4",null,"Engineering_Physicists"]
[null,null,"Designer Sr","N4",null,"Scientists"]
[null,null,"Design Drafter","N3",null,"Technical"]
[null,null,"Design Drafter Sr","N4"]
[null,"Engineers","Engineering Associate","N4"]
[null,null,"Engineering Associate Sr","E4"]
[null,null,"Engineer","E2"]
[null,null,"Staff Engineer","E4"]
[null,null,"Senior Engineer","E5"]
[null,null,"Principal Engineer","E6"]
[null,null,"Senior Principal Engineer","E7"]
[null,null,"Guest Engineer","Based on Pay"]
[null,"Engineering Physicists","Engineering Physicist I","E2"]
[null,null,"Engineering Physicist II","E4"]
[null,null,"Engineering Physicist III","E4"]
[null,null,"Sr Engineering Physicist","E6"]
[null,null,"Engineering Physicist Mgr","E7"]
[null,"Scientists","Research Associate","E1"]
[null,null,"Associate Scientist","E3"]
[null,null,"Scientist","E4"]
[null,null,"Senior Scientist","E6"]
[null,null,"Distinguished Scientist","E7"]
[null,null,"Applications Physicist I","E2"]
[null,null,"Applications Physicist II","E4"]
[null,null,"Applications Physicist III","E5"]
[null,null,"Applications Physicist IV","E6"]
[null,null,"Guest Scientist","Based on Pay"]
[null,"Technical","Technician I","N2"]
[null,null,"Technician II","N3"]
[null,null,"Senior Technician","N3"]
[null,null,"Technical Specialist","N4"]
[null,null,"Technical Specialist Sr.","N4"]
[null,null,"Technical Supervisor","E3"]
[]
[null,"SLRate is Time Worked rate and includes shift premiums."]
[null,"Overtime is at 1.5 x SLRate. "]
[null,"Rates are per hour"]
[null,"Using FY16 Provisional Vacation, OPTO, Fringe, PS, CSS and G&A rates"]

{"sheet":"SLRs","index":8,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[[17,0,20,0],[1,0,8,0],[9,0,12,0],[13,0,16,0]]}
["FY16 PROVISIONAL","Band","SLRate",null,"VO","SLR+VO"]
["Exempt","E1",30.75,null,{"$f":"C2*(Rates!$B$2+Rates!$B$4)","v":5.3812499999999996},{"$f":"E2+C2","v":36.131250000000001}]
[null,"E2",36.5,null,{"$f":"C3*(Rates!$B$2+Rates!$B$4)","v":6.3874999999999993},{"$f":"E3+C3","v":42.887500000000003}]
[null,"E3",44.5,null,{"$f":"C4*(Rates!$B$2+Rates!$B$4)","v":7.7874999999999996},52.287500000000001]
[null,"E4",51.25,null,{"$f":"C5*(Rates!$B$2+Rates!$B$4)","v":8.96875},60.21875]
[null,"E5",60.5,null,{"$f":"C6*(Rates!$B$2+Rates!$B$4)","v":10.587499999999999},71.087500000000006]
[null,"E6",69.5,null,{"$f":"C7*(Rates!$B$2+Rates!$B$4)","v":12.1625},81.662499999999994]
[null,"E7",87.25,null,{"$f":"C8*(Rates!$B$2+Rates!$B$4)","v":15.268749999999999},102.51875]
[null,"E8",114.75,null,{"$f":"C9*(Rates!$B$2+Rates!$B$4)","v":20.081249999999997},134.83125000000001]
["Non-Exempt","N1",15.75,null,{"$f":"C10*(Rates!$B$3+Rates!$B$5)","v":3.2287500000000002},18.978750000000002]
[null,"N2",22.75,null,{"$f":"C11*(Rates!$B$3+Rates!$B$5)","v":4.6637500000000003},{"$f":"E11+C11","v":27.41375}]
[null,"N3",29.75,null,{"$f":"C12*(Rates!$B$3+Rates!$B$5)","v":6.0987500000000008},35.848750000000003]
[null,"N4",40,null,{"$f":"C13*(Rates!$B$3+Rates!$B$5)","v":8.2000000000000011},48.2]
["Union","UDR",23.75,null,null,{"$f":"C14","v":23.75}]
[null,"UFF",24.5,null,null,{"$f":"C15","v":24.5}]
[null,"UMT",35.5,null,null,35.5]
[null,"UMW",33.25,null,null,33.25]
["Extra Bands only available to Guest, Intern, Seasonal, OnCall","ES1",12.5,null,null,12.5]
[null,"ES2",21,null,null,21]
[null,"NS1",9,null,null,9]
[null,"NS2",12,null,null,12]

{"sheet":"Rates","index":9,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Rates Type","Rate"]
["Vacation - Monthly",0.1]
["Vacation - Weekly",0.11]
["OPTO - Monthly",7.4999999999999997E-2]
["OPTO - Weekly",9.5000000000000001E-2]
["Fringe",0.29749999999999999]
["Fringe - Post Doc",0.23749999999999999]
[]
["PS",0.93530000000000002,"Effective - Divisional"]
["MSA",0.2631,"Effective"]
["CSS",0.69469999999999998,"Effective - Non-Divisional"]
["G&A",0.18720000000000001,"Effective"]
["LDRD",1.2500000000000001E-2]
["Pass-Through - Labs",0.03]
["Pass-Through",4.2900000000000001E-2,"Effective"]
[]
["Inflation Period 2",3.2000000000000001E-2]
["Inflation Period 3",3.2000000000000001E-2]
["Inflation Period 4",3.1E-2]
["Inflation Period 5",3.1E-2]
[]
["Hours per FTE",1785]