{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Tuition","Travel Details","F&A Calculation- Sponsor Funds ","F&A Calculations - Cost Share","SPA USE ONLY"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":93,"comments":1,"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":"Summary","index":0,"n_rows":133,"n_cols":23,"rows_kept":133,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,3,5],[4,3,4,5],[116,2,116,17],[70,3,70,6],[71,3,71,6],[74,3,74,6],[114,2,114,17],[75,3,75,6],[76,3,76,6],[103,4,103,6],[8,18,11,18],[8,19,11,19],[0,18,0,19],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,11,17],[1,18,1,19]]}
["Project Budget Worksheet - Iowa State University of Science and Technology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eff. 7/1/2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 12/19/2017"]
["Program Sponsor",null,null,".",null,null,"2017-07-01","< <-- Start Date must be entered here"]
["Title",null,null,null,null,null,0,"Enter \"other\" rate ONLY if not using full IDC rate",null,null,null,null,null,null,null,null,null,null,null,"GS","Negotiated Rate","This budget is completely adjustable.  You will need to double check your work and make adjustments in certain cells, such as:"]
["PI",null,null,".",null,null,"Negotiated Rate","Select calculation type (drop down menu: G5)",null,null,null,null,null,null,null,null,null,null,null,null,"Other TDC","Subcontracts - Verify that only the first $25K of each subcontract is charged IDC.  You might need to adjust the MTDC for each year of each subcontract."]
["Period of Performance",null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Budget","Other MTDC","Indirect costs- Budget defaults to caculate on 52% MTDC and 53% MTDC, with precise rate in on \"F&A Calculations\" sheet. "]
["Deadline",null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T107","v":0},null,null,"   To use a rate other than organized research, please enter rate in 'Enter Other Rate' cell and  select 'Other TDC' or 'Other MTDC' in dropdown."]
[]
[null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total Federal Funds","Total Cost-Shared Matching Funds","Total Project Funds"]
[null,null,null,null,null,null,null,"Start Date","End Date","Start Date","End Date","Start Date","End Date","Start Date ","End Date","Start Date","End Date"]
[null,null,null,null,null,null,null,{"$f":"DATE(YEAR(G3),MONTH(G3),DAY(G3))","v":"2017-07-01"},{"$f":"J11-1","v":"2018-06-30"},{"$f":"DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))","v":"2018-07-01"},{"$f":"L11-1","v":"2019-06-30"},{"$f":"DATE(YEAR(G3)+2,MONTH(G3),DAY(G3))","v":"2019-07-01"},{"$f":"N11-1","v":"2020-06-30"},{"$f":"DATE(YEAR(G3)+3,MONTH(G3),DAY(G3))","v":"2020-07-01"},{"$f":"P11-1","v":"2021-06-30"},{"$f":"DATE(YEAR(G3)+4,MONTH(G3),DAY(G3))","v":"2021-07-01"},{"$f":"P11+364","v":"2022-06-30"}]
[null,null,null,null,null,null,null,"Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds"]
[null,null,null,"Salary","Calendar","Academic","Summer"]
["A",null,"Key Personnel","Monthly","Months","Months","Months",{"$f":"SUM(H15:H23)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H14+J14+L14+N14+P14)","v":0},{"$f":"SUM(I14+K14+M14+O14+Q14)","v":0},{"$f":"SUM(R14+S14)","v":0}]
[null,1,null,0,0,0,0,{"$f":"D15*(E15+F15+G15)","v":0},0,{"$f":"ROUND(H15*1.03,0)","v":0},0,{"$f":"ROUND(J15*1.03,0)","v":0},0,{"$f":"ROUND(L15*1.03,0)","v":0},0,{"$f":"ROUND(N15*1.03,0)","v":0},0,{"$f":"SUM(H15+J15+L15+N15+P15)","v":0},{"$f":"SUM(I15+K15+M15+O15+Q15)","v":0},{"$f":"SUM(R15+S15)","v":0}]
[null,2,null,0,0,0,0,0,0,{"$f":"ROUND(H16*1.03,0)","v":0},0,{"$f":"ROUND(J16*1.03,0)","v":0},0,{"$f":"ROUND(L16*1.03,0)","v":0},0,{"$f":"ROUND(N16*1.03,0)","v":0},0,{"$f":"SUM(H16+J16+L16+N16+P16)","v":0},0,{"$f":"SUM(R16+S16)","v":0}]
[null,3,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Calendar",null,"Number of"]
["B",null,"Other Personnel","Monthly","Months",null,"persons",{"$f":"SUM(H26:H37)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H25+J25+L25+N25+P25)","v":0},{"$f":"SUM(I25+K25+M25+O25+Q25)","v":0},{"$f":"SUM(R25+S25)","v":0}]
[null,1,"Post Doc",0,0,null,0,{"$f":"D26*(E26)*G26","v":0},0,{"$f":"ROUND(H26*1.03,0)","v":0},0,{"$f":"ROUND(J26*1.03,0)","v":0},0,{"$f":"ROUND(L26*1.03,0)","v":0},0,{"$f":"ROUND(N26*1.03,0)","v":0},0,{"$f":"SUM(H26+J26+L26+N26+P26)","v":0},0,{"$f":"SUM(R26+S26)","v":0}]
[null,2,"Post Doc",0,0,null,0,0,0,{"$f":"ROUND(H27*1.03,0)","v":0},0,{"$f":"ROUND(J27*1.03,0)","v":0},0,{"$f":"ROUND(L27*1.03,0)","v":0},0,{"$f":"ROUND(N27*1.03,0)","v":0},0,0,0,0]
[null,3,"Research Asst-Halftime",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,"Research Asst-Halftime",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Hourly Undergraduate student",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,"Hourly Undergraduate student",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,"P&S",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,"P&S",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,"Secretarial/Clerical",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,"Secretarial/Clerical",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,11,"Non-Student Hourly",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,12,"Non-Student Hourly",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries and Wages",null,null,null,null,{"$f":"+H14+H25","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H39+J39+L39+N39+P39)","v":0},{"$f":"SUM(I39+K39+M39+O39+Q39)","v":0},{"$f":"SUM(R39+S39)","v":0}]
[]
["C",null,"Fringe Benefits","Rate",null,null,null,{"$f":"SUM(H42:H62)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H41+J41+L41+N41+P41)","v":0},{"$f":"SUM(I41+K41+M41+O41+Q41)","v":0},{"$f":"SUM(R41+S41)","v":0}]
[null,null,{"$f":"+C15","v":0},0.27500000000000002,null,null,null,{"$f":"ROUND(D42*H15,0)","v":0},{"$f":"ROUND(D42*I15,0)","v":0},{"$f":"ROUND(D42*J15,0)","v":0},{"$f":"ROUND(D42*K15,0)","v":0},{"$f":"ROUND(D42*L15,0)","v":0},{"$f":"ROUND(D42*M15,0)","v":0},{"$f":"ROUND(D42*N15,0)","v":0},{"$f":"ROUND(D42*O15,0)","v":0},{"$f":"ROUND(D42*P15,0)","v":0},{"$f":"ROUND(D42*Q15,0)","v":0},{"$f":"SUM(H42+J42+L42+N42+P42)","v":0},0,{"$f":"SUM(R42+S42)","v":0}]
[null,null,{"$f":"+C16","v":0},0.27500000000000002,null,null,null,{"$f":"ROUND(D43*H16,0)","v":0},{"$f":"ROUND(D43*I16,0)","v":0},{"$f":"ROUND(D43*J16,0)","v":0},{"$f":"ROUND(D43*K16,0)","v":0},{"$f":"ROUND(D43*L16,0)","v":0},{"$f":"ROUND(D43*M16,0)","v":0},{"$f":"ROUND(D43*N16,0)","v":0},{"$f":"ROUND(D43*O16,0)","v":0},{"$f":"ROUND(D43*P16,0)","v":0},{"$f":"ROUND(D43*Q16,0)","v":0},0,0,0]
[null,null,{"$f":"+C17","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C18","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C19","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C20","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C21","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C22","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C23","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C26","v":"Post Doc"},0.32900000000000001,null,null,null,{"$f":"ROUND(D51*H26,0)","v":0},{"$f":"ROUND(D51*I26,0)","v":0},{"$f":"ROUND(D51*J26,0)","v":0},{"$f":"ROUND(D51*K26,0)","v":0},{"$f":"ROUND(D51*L26,0)","v":0},{"$f":"ROUND(D51*M26,0)","v":0},{"$f":"ROUND(D51*N26,0)","v":0},{"$f":"ROUND(D51*O26,0)","v":0},{"$f":"ROUND(D51*P26,0)","v":0},{"$f":"ROUND(D51*Q26,0)","v":0},0,0,0]
[null,null,"Post Doc",0.32900000000000001,null,null,null,{"$f":"ROUND(D52*H27,0)","v":0},{"$f":"ROUND(D52*I27,0)","v":0},{"$f":"ROUND(D52*J27,0)","v":0},{"$f":"ROUND(D52*K27,0)","v":0},{"$f":"ROUND(D52*L27,0)","v":0},{"$f":"ROUND(D52*M27,0)","v":0},{"$f":"ROUND(D52*N27,0)","v":0},{"$f":"ROUND(D52*O27,0)","v":0},{"$f":"ROUND(D52*P27,0)","v":0},{"$f":"ROUND(D52*Q27,0)","v":0},0,0,0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C32","v":"P&S"},0.34499999999999997,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"P&S",0.34499999999999997,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.45800000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.45800000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.17100000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.17100000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries, Wages, and Benefits",null,null,null,null,{"$f":"H39+H41","v":0},{"$f":"I39+I41","v":0},{"$f":"J39+J41","v":0},0,0,0,0,0,0,0,{"$f":"SUM(H64+J64+L64+N64+P64)","v":0},{"$f":"SUM(I64+K64+M64+O64+Q64)","v":0},{"$f":"SUM(R64+S64)","v":0}]
[]
["D",null,"Equipment (List Item and $ amount for each item > $5k)",null,null,null,null,{"$f":"SUM(H67:H68)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H66+J66+L66+N66+P66)","v":0},0,{"$f":"SUM(R66+S66)","v":0}]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R67+S67)","v":0}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R68+S68)","v":0}]
[]
["E",null,"Travel",null,null,null,null,{"$f":"SUM(H71:H72)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H70+J70+L70+N70+P70)","v":0},0,{"$f":"SUM(R70+S70)","v":0}]
[null,null,"1. Domestic Travel",null,null,null,null,0,0,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R71+S71)","v":0}]
[null,null,"2. Foreign Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R72+S72)","v":0}]
[]
["F",null,"Participant Support Cost",null,null,null,null,{"$f":"SUM(H75:H78)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H74+J74+L74+N74+P74)","v":0},{"$f":"SUM(I74+K74+M74+O74+Q74)","v":0},{"$f":"SUM(R74+S74)","v":0}]
[null,null,"1. Stipend",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H75+J75+L75+N75+P75)","v":0},0,{"$f":"SUM(R75+S75)","v":0}]
[null,null,"2. Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R76+S76)","v":0}]
[null,null,"3. Subsistence",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R77+S77)","v":0}]
[null,null,"4. Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R78+S78)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H81:H96)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H80+J80+L80+N80+P80)","v":0},{"$f":"SUM(I80+K80+M80+O80+Q80)","v":0},{"$f":"SUM(R80+S80)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H81+J81+L81+N81+P81)","v":0},0,{"$f":"SUM(R81+S81)","v":0}]
[null,2,"Publication cost",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,3,"Consultant/Professional Services",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H83+J83+L83+N83+P83)","v":0},{"$f":"SUM(I83+K83+M83+O83+Q83)","v":0},{"$f":"SUM(R83+S83)","v":0}]
[null,3,"Computing support",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"Equipment/Facility Rental or User Fee",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"Alterations and Renovations (not included in MTDC)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H86+J86+L86+N86+P86)","v":0},{"$f":"SUM(I86+K86+M86+O86+Q86)","v":0},{"$f":"SUM(R86+S86)","v":0}]
[null,5,"Subcontractor1 - Subject to IDC (first $25,000)",null,"See notes below",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"NOT subject to IDC (Amount over $25,000)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,6,"Subcontractor2 - Subject to IDC (first $25,000)",null,"See notes below",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"NOT subject to IDC (Amount over $25,000)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,7,"Tuition-(most majors)",null,"(Click on \"Tuition\" sheet)",null,null,{"$f":"Tuition!K6","v":0},null,{"$f":"Tuition!M6","v":0},null,{"$f":"Tuition!O6","v":0},null,{"$f":"Tuition!Q6","v":0},null,{"$f":"Tuition!S6","v":0},null,0,0,0]
[null,8,"Tuition-Engineering & Architecture ",null,"(Click on \"Tuition\" sheet)",null,null,{"$f":"Tuition!K26","v":0},null,{"$f":"Tuition!M26","v":0},null,{"$f":"Tuition!O26","v":0},null,{"$f":"Tuition!Q26","v":0},null,{"$f":"Tuition!S26","v":0},null,0,0,0]
[null,8,"Tuition-Business & STB",null,"(Click on \"Tuition\" sheet)",null,null,{"$f":"Tuition!K46","v":0},null,{"$f":"Tuition!M46","v":0},null,{"$f":"Tuition!O46","v":0},null,{"$f":"Tuition!Q46","v":0},null,{"$f":"Tuition!S46","v":0},null,{"$f":"SUM(H93+J93+L93+N93+P93)","v":0},{"$f":"SUM(I93+K93+M93+O93+Q93)","v":0},{"$f":"SUM(R93+S93)","v":0}]
[null,null,"Tuition-Specific Grad Depts",null,"(Click on \"Tuition\" sheet)",null,null,{"$f":"Tuition!K67","v":0},null,{"$f":"Tuition!M67","v":0},null,{"$f":"Tuition!O67","v":0},null,{"$f":"Tuition!Q67","v":0},null,{"$f":"Tuition!S67","v":0},null,{"$f":"H94+J94+L94+N94+P94","v":0},{"$f":"I94+K94+M94+O94+Q94","v":0},{"$f":"S94+R94","v":0}]
[null,9,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,10,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[]
[null,null,"Subtotal: Total Direct Costs (TDC)",null,null,null,null,{"$f":"H64+H66+H70+H74+H80","v":0},{"$f":"I64+I66+I70+I74+I80","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(H98+J98+L98+N98+P98)","v":0},{"$f":"SUM(I98+K98+M98+O98+Q98)","v":0},{"$f":"SUM(R98+S98)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H98-H66-H88-H90-H91-H92-H93-H94-H74-H86)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H100+J100+L100+N100+P100)","v":0},{"$f":"SUM(I100+K100+M100+O100+Q100)","v":0},{"$f":"SUM(R100+S100)","v":0}]
[null,null,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H104:H104)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H103+J103+L103+N103+P103)","v":0},{"$f":"SUM(I103+K103+M103+O103+Q103)","v":0},{"$f":"SUM(R103+S103)","v":0}]
[null,null,"IDC on MTDC",{"$f":"IF(G5=U4,\"52% 53%\",G4)","v":"52% 53%"},"[ IDC = MTDC * Indirect Rate ]",null,null,{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I22,IF(G5=U5,H98*G4,G4*H100))","v":0},{"$f":"IF(G5=U4,'F&A Calculations - Cost Share'!I22,IF(G5=U5,I98*G4,G4*I100))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I32,IF(G5=U5,J98*G4,G4*J100))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I32,IF(G5=U5,K98*G4,G4*K100))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I42,IF(G5=U5,L98*G4,G4*L100))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I42,IF(G5=U5,M98*G4,G4*M100))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I52,IF(G5=U5,N98*G4,G4*N100))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I52,IF(G5=U5,O98*G4,G4*O100))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I62,IF(G5=U5,P98*G4,G4*P100))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I62,IF(G5=U5,Q98*G4,G4*Q100))","v":0},{"$f":"SUM(H104+J104+L104+N104+P104)","v":0},{"$f":"SUM(I104+K104+M104+O104+Q104)","v":0},{"$f":"SUM(R104+S104)","v":0}]
[]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H98+H103","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H107+J107+L107+N107+P107)","v":0},{"$f":"SUM(I107+K107+M107+O107+Q107)","v":0},{"$f":"SUM(R107+S107)","v":0}]
[]
[]
[]
[]
[]
[null,null,"NOTES:"]
[]
[null,null,"This budget is completely adjustable.  As such, you will need to double check your work and make adjustments in certain cells, such as:"]
[]
[null,null,"Subcontracts - Verify that only the first $25K of each subcontract is charged IDC.  You might need to adjust the MTDC for each year of each subcontract."]
[]
[]
[]
[]
[null,null,"Benefits:",null,null,null,null,"Indirect Cost Categories:"]
[null,null,"A&B",0.27500000000000002]
[null,null,"C",9.8000000000000004E-2,null,null,null,"52 or 53%","On-Campus Organized Research"]
[null,null,"D",0.32900000000000001,null,null,null,0.53,"On Campus Instruction"]
[null,null,"P",0.34499999999999997,null,null,null,0.33,"On-Campus Other Sponsored Activities"]
[null,null,"E",0.45800000000000002,null,null,null,0.26,"Off-Campus All Programs"]
[null,null,"XH (Student hourly)",6.0000000000000001E-3]
[null,null,"XH (Non-Student hourly)",0.17100000000000001]
[]
[null,null,"Post Doc Salary Range:"]
[null,null," "]
[null,null,"http://www.grad-college.iastate.edu/post_doc/policies.php"]

{"sheet":"Tuition","index":1,"n_rows":206,"n_cols":19,"rows_kept":206,"cut":false,"hidden":false,"merged":[[30,2,30,7],[5,2,5,5],[6,2,6,5],[7,2,7,5],[66,2,66,5],[2,2,2,8],[10,2,10,7],[25,2,25,5],[26,2,26,5],[27,2,27,5],[58,0,62,0],[58,2,58,3],[60,2,60,3],[62,2,62,3],[45,2,45,5],[52,0,56,0],[52,2,52,3],[54,2,54,3],[56,2,56,3],[46,2,46,5],[47,2,47,5],[50,2,50,7],[12,0,16,0],[12,2,12,3],[14,2,14,3],[16,2,16,3],[18,0,22,0],[18,2,18,3],[20,2,20,3],[22,2,22,3],[38,0,42,0],[38,2,38,3],[40,2,40,3],[42,2,42,3],[32,0,36,0],[32,2,32,3],[34,2,34,3],[36,2,36,3],[67,2,67,5],[68,2,68,5],[71,2,71,7],[73,0,77,0],[73,2,73,3],[75,2,75,3],[77,2,77,3],[79,0,83,0],[79,2,79,3],[81,2,81,3],[83,2,83,3],[84,0,85,8]]}
[null,null,"           Tuition Costs",null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,null,null,null,null,null,null,null,null,null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested"]
[]
[]
[8,null,"Graduate Student Tuition (most Majors)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF(I6=\"1/2-time\",K7,K8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",M7,M8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",O7,O8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",Q7,Q8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",S7,S8),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C13*VLOOKUP(K13,$I$91:$Q$117,5,FALSE)+C15*VLOOKUP(K15,$I$91:$Q$117,5,FALSE)+C17*VLOOKUP(K17,$I$91:$Q$117,5,FALSE)+C19*VLOOKUP(K19,$I$91:$Q$117,9,FALSE)+C21*VLOOKUP(K21,$I$91:$Q$117,9,FALSE)+C23*VLOOKUP(K23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$91:$Q$117,5,FALSE)+E15*VLOOKUP(M15,$I$91:$Q$117,5,FALSE)+E17*VLOOKUP(M17,$I$91:$Q$117,5,FALSE)+E19*VLOOKUP(M19,$I$91:$Q$117,9,FALSE)+E21*VLOOKUP(M21,$I$91:$Q$117,9,FALSE)+E23*VLOOKUP(M23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$91:$Q$117,5,FALSE)+F15*VLOOKUP(O15,$I$91:$Q$117,5,FALSE)+F17*VLOOKUP(O17,$I$91:$Q$117,5,FALSE)+F19*VLOOKUP(O19,$I$91:$Q$117,9,FALSE)+F21*VLOOKUP(O21,$I$91:$Q$117,9,FALSE)+F23*VLOOKUP(O23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$91:$Q$117,5,FALSE)+G15*VLOOKUP(Q15,$I$91:$Q$117,5,FALSE)+G17*VLOOKUP(Q17,$I$91:$Q$117,5,FALSE)+G19*VLOOKUP(Q19,$I$91:$Q$117,9,FALSE)+G21*VLOOKUP(Q21,$I$91:$Q$117,9,FALSE)+G23*VLOOKUP(Q23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$91:$Q$117,5,FALSE)+H15*VLOOKUP(S15,$I$91:$Q$117,5,FALSE)+H17*VLOOKUP(S17,$I$91:$Q$117,5,FALSE)+H19*VLOOKUP(S19,$I$91:$Q$117,9,FALSE)+H21*VLOOKUP(S21,$I$91:$Q$117,9,FALSE)+H23*VLOOKUP(S23,$I$91:$Q$117,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$91:$Q$117,3,FALSE)+C15*VLOOKUP(K15,$I$91:$Q$117,3,FALSE)+C17*VLOOKUP(K17,$I$91:$Q$117,3,FALSE)+C19*VLOOKUP(K19,$I$91:$Q$117,7,FALSE)+C21*VLOOKUP(K21,$I$91:$Q$117,7,FALSE)+C23*VLOOKUP(K23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$91:$Q$117,3,FALSE)+E15*VLOOKUP(M15,$I$91:$Q$117,3,FALSE)+E17*VLOOKUP(M17,$I$91:$Q$117,3,FALSE)+E19*VLOOKUP(M19,$I$91:$Q$117,7,FALSE)+E21*VLOOKUP(M21,$I$91:$Q$117,7,FALSE)+E23*VLOOKUP(M23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$91:$Q$117,3,FALSE)+F15*VLOOKUP(O15,$I$91:$Q$117,3,FALSE)+F17*VLOOKUP(O17,$I$91:$Q$117,3,FALSE)+F19*VLOOKUP(O19,$I$91:$Q$117,7,FALSE)+F21*VLOOKUP(O21,$I$91:$Q$117,7,FALSE)+F23*VLOOKUP(O23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$91:$Q$117,3,FALSE)+G15*VLOOKUP(Q15,$I$91:$Q$117,3,FALSE)+G17*VLOOKUP(Q17,$I$91:$Q$117,3,FALSE)+G19*VLOOKUP(Q19,$I$91:$Q$117,7,FALSE)+G21*VLOOKUP(Q21,$I$91:$Q$117,7,FALSE)+G23*VLOOKUP(Q23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$91:$Q$117,3,FALSE)+H15*VLOOKUP(S15,$I$91:$Q$117,3,FALSE)+H17*VLOOKUP(S17,$I$91:$Q$117,3,FALSE)+H19*VLOOKUP(S19,$I$91:$Q$117,7,FALSE)+H21*VLOOKUP(S21,$I$91:$Q$117,7,FALSE)+H23*VLOOKUP(S23,$I$91:$Q$117,7,FALSE)","v":0}]
[]
[]
[null,null,"Graduate Student Tuition (most majors)"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2020",null,"Spring 2021"]
[]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
[]
[8,null,"Graduate Student Tuition (Engineering & Architecture)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$26=\"1/2-time\",K27,K28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",M27,M28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",O27,O28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",Q27,Q28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",S27,S28),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C33*VLOOKUP(K33,$I$121:$Q$147,5,FALSE)+C35*VLOOKUP(K35,$I$121:$Q$147,5,FALSE)+C37*VLOOKUP(K37,$I$121:$Q$147,5,FALSE)+C39*VLOOKUP(K39,$I$121:$Q$147,9,FALSE)+C41*VLOOKUP(K41,$I$121:$Q$147,9,FALSE)+C43*VLOOKUP(K43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$121:$Q$147,5,FALSE)+E35*VLOOKUP(M35,$I$121:$Q$147,5,FALSE)+E37*VLOOKUP(M37,$I$121:$Q$147,5,FALSE)+E39*VLOOKUP(M39,$I$121:$Q$147,9,FALSE)+E41*VLOOKUP(M41,$I$121:$Q$147,9,FALSE)+E43*VLOOKUP(M43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$121:$Q$147,5,FALSE)+F35*VLOOKUP(O35,$I$121:$Q$147,5,FALSE)+F37*VLOOKUP(O37,$I$121:$Q$147,5,FALSE)+F39*VLOOKUP(O39,$I$121:$Q$147,9,FALSE)+F41*VLOOKUP(O41,$I$121:$Q$147,9,FALSE)+F43*VLOOKUP(O43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$121:$Q$147,5,FALSE)+G35*VLOOKUP(Q35,$I$121:$Q$147,5,FALSE)+G37*VLOOKUP(Q37,$I$121:$Q$147,5,FALSE)+G39*VLOOKUP(Q39,$I$121:$Q$147,9,FALSE)+G41*VLOOKUP(Q41,$I$121:$Q$147,9,FALSE)+G43*VLOOKUP(Q43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$121:$Q$147,5,FALSE)+H35*VLOOKUP(S35,$I$121:$Q$147,5,FALSE)+H37*VLOOKUP(S37,$I$121:$Q$147,5,FALSE)+H39*VLOOKUP(S39,$I$121:$Q$147,9,FALSE)+H41*VLOOKUP(S41,$I$121:$Q$147,9,FALSE)+H43*VLOOKUP(S43,$I$121:$Q$147,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$121:$Q$147,3,FALSE)+C35*VLOOKUP(K35,$I$121:$Q$147,3,FALSE)+C37*VLOOKUP(K37,$I$121:$Q$147,3,FALSE)+C39*VLOOKUP(K39,$I$121:$Q$147,7,FALSE)+C41*VLOOKUP(K41,$I$121:$Q$147,7,FALSE)+C43*VLOOKUP(K43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$121:$Q$147,3,FALSE)+E35*VLOOKUP(M35,$I$121:$Q$147,3,FALSE)+E37*VLOOKUP(M37,$I$121:$Q$147,3,FALSE)+E39*VLOOKUP(M39,$I$121:$Q$147,7,FALSE)+E41*VLOOKUP(M41,$I$121:$Q$147,7,FALSE)+E43*VLOOKUP(M43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$121:$Q$147,3,FALSE)+F35*VLOOKUP(O35,$I$121:$Q$147,3,FALSE)+F37*VLOOKUP(O37,$I$121:$Q$147,3,FALSE)+F39*VLOOKUP(O39,$I$121:$Q$147,7,FALSE)+F41*VLOOKUP(O41,$I$121:$Q$147,7,FALSE)+F43*VLOOKUP(O43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$121:$Q$147,3,FALSE)+G35*VLOOKUP(Q35,$I$121:$Q$147,3,FALSE)+G37*VLOOKUP(Q37,$I$121:$Q$147,3,FALSE)+G39*VLOOKUP(Q39,$I$121:$Q$147,7,FALSE)+G41*VLOOKUP(Q41,$I$121:$Q$147,7,FALSE)+G43*VLOOKUP(Q43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$121:$Q$147,3,FALSE)+H35*VLOOKUP(S35,$I$121:$Q$147,3,FALSE)+H37*VLOOKUP(S37,$I$121:$Q$147,3,FALSE)+H39*VLOOKUP(S39,$I$121:$Q$147,7,FALSE)+H41*VLOOKUP(S41,$I$121:$Q$147,7,FALSE)+H43*VLOOKUP(S43,$I$121:$Q$147,7,FALSE)","v":0}]
[]
[]
[null,null,"Engineering & Architecture Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
[]
[8,null,"Graduate Student Tuition (Business & STB)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$46=\"1/2-time\",K47,K48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",M47,M48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",O47,O48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",Q47,Q48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",S47,S48),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C53*VLOOKUP(K53,$I$151:$Q$177,5,FALSE)+C55*VLOOKUP(K55,$I$151:$Q$177,5,FALSE)+C57*VLOOKUP(K57,$I$151:$Q$177,5,FALSE)+C59*VLOOKUP(K59,$I$151:$Q$177,9,FALSE)+C61*VLOOKUP(K61,$I$151:$Q$177,9,FALSE)+C63*VLOOKUP(K63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$151:$Q$177,5,FALSE)+E55*VLOOKUP(M55,$I$151:$Q$177,5,FALSE)+E57*VLOOKUP(M57,$I$151:$Q$177,5,FALSE)+E59*VLOOKUP(M59,$I$151:$Q$177,9,FALSE)+E61*VLOOKUP(M61,$I$151:$Q$177,9,FALSE)+E63*VLOOKUP(M63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$151:$Q$177,5,FALSE)+F55*VLOOKUP(O55,$I$151:$Q$177,5,FALSE)+F57*VLOOKUP(O57,$I$151:$Q$177,5,FALSE)+F59*VLOOKUP(O59,$I$151:$Q$177,9,FALSE)+F61*VLOOKUP(O61,$I$151:$Q$177,9,FALSE)+F63*VLOOKUP(O63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$151:$Q$177,5,FALSE)+G55*VLOOKUP(Q55,$I$151:$Q$177,5,FALSE)+G57*VLOOKUP(Q57,$I$151:$Q$177,5,FALSE)+G59*VLOOKUP(Q59,$I$151:$Q$177,9,FALSE)+G61*VLOOKUP(Q61,$I$151:$Q$177,9,FALSE)+G63*VLOOKUP(Q63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$151:$Q$177,5,FALSE)+H55*VLOOKUP(S55,$I$151:$Q$177,5,FALSE)+H57*VLOOKUP(S57,$I$151:$Q$177,5,FALSE)+H59*VLOOKUP(S59,$I$151:$Q$177,9,FALSE)+H61*VLOOKUP(S61,$I$151:$Q$177,9,FALSE)+H63*VLOOKUP(S63,$I$151:$Q$177,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$151:$Q$177,3,FALSE)+C55*VLOOKUP(K55,$I$151:$Q$177,3,FALSE)+C57*VLOOKUP(K57,$I$151:$Q$177,3,FALSE)+C59*VLOOKUP(K59,$I$151:$Q$177,7,FALSE)+C61*VLOOKUP(K61,$I$151:$Q$177,7,FALSE)+C63*VLOOKUP(K63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$151:$Q$177,3,FALSE)+E55*VLOOKUP(M55,$I$151:$Q$177,3,FALSE)+E57*VLOOKUP(M57,$I$151:$Q$177,3,FALSE)+E59*VLOOKUP(M59,$I$151:$Q$177,7,FALSE)+E61*VLOOKUP(M61,$I$151:$Q$177,7,FALSE)+E63*VLOOKUP(M63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$151:$Q$177,3,FALSE)+F55*VLOOKUP(O55,$I$151:$Q$177,3,FALSE)+F57*VLOOKUP(O57,$I$151:$Q$177,3,FALSE)+F59*VLOOKUP(O59,$I$151:$Q$177,7,FALSE)+F61*VLOOKUP(O61,$I$151:$Q$177,7,FALSE)+F63*VLOOKUP(O63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$151:$Q$177,3,FALSE)+G55*VLOOKUP(Q55,$I$151:$Q$177,3,FALSE)+G57*VLOOKUP(Q57,$I$151:$Q$177,3,FALSE)+G59*VLOOKUP(Q59,$I$151:$Q$177,7,FALSE)+G61*VLOOKUP(Q61,$I$151:$Q$177,7,FALSE)+G63*VLOOKUP(Q63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$151:$Q$177,3,FALSE)+H55*VLOOKUP(S55,$I$151:$Q$177,3,FALSE)+H57*VLOOKUP(S57,$I$151:$Q$177,3,FALSE)+H59*VLOOKUP(S59,$I$151:$Q$177,7,FALSE)+H61*VLOOKUP(S61,$I$151:$Q$177,7,FALSE)+H63*VLOOKUP(S63,$I$151:$Q$177,7,FALSE)","v":0}]
[]
[]
[null,null,"Business and STB Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,0,null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
[]
[]
[8,null,"Graduate Student Tuition (*Specific Graduate Departments)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I67=\"1/2-time\",K68,K69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",M68,M69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",O68,O69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",Q68,Q69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",S68,S69),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C74*VLOOKUP(K74,$I$181:$Q$207,5,FALSE)+C76*VLOOKUP(K76,$I$181:$Q$207,5,FALSE)+C78*VLOOKUP(K78,$I$181:$Q$207,5,FALSE)+C80*VLOOKUP(K80,$I$181:$Q$207,9,FALSE)+C82*VLOOKUP(K82,$I$181:$Q$207,9,FALSE)+C84*VLOOKUP(K84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$181:$Q$207,5,FALSE)+E76*VLOOKUP(M76,$I$181:$Q$207,5,FALSE)+E78*VLOOKUP(M78,$I$181:$Q$207,5,FALSE)+E80*VLOOKUP(M80,$I$181:$Q$207,9,FALSE)+E82*VLOOKUP(M82,$I$181:$Q$207,9,FALSE)+E84*VLOOKUP(M84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$181:$Q$207,5,FALSE)+F76*VLOOKUP(O76,$I$181:$Q$207,5,FALSE)+F78*VLOOKUP(O78,$I$181:$Q$207,5,FALSE)+F80*VLOOKUP(O80,$I$181:$Q$207,9,FALSE)+F82*VLOOKUP(O82,$I$181:$Q$207,9,FALSE)+F84*VLOOKUP(O84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$181:$Q$207,5,FALSE)+G76*VLOOKUP(Q76,$I$181:$Q$207,5,FALSE)+G78*VLOOKUP(Q78,$I$181:$Q$207,5,FALSE)+G80*VLOOKUP(Q80,$I$181:$Q$207,9,FALSE)+G82*VLOOKUP(Q82,$I$181:$Q$207,9,FALSE)+G84*VLOOKUP(Q84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$181:$Q$207,5,FALSE)+H76*VLOOKUP(S76,$I$181:$Q$207,5,FALSE)+H78*VLOOKUP(S78,$I$181:$Q$207,5,FALSE)+H80*VLOOKUP(S80,$I$181:$Q$207,9,FALSE)+H82*VLOOKUP(S82,$I$181:$Q$207,9,FALSE)+H84*VLOOKUP(S84,$I$181:$Q$207,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C74*VLOOKUP(K74,$I$181:$Q$207,3,FALSE)+C76*VLOOKUP(K76,$I$181:$Q$207,3,FALSE)+C78*VLOOKUP(K78,$I$181:$Q$207,3,FALSE)+C80*VLOOKUP(K80,$I$181:$Q$207,7,FALSE)+C82*VLOOKUP(K82,$I$181:$Q$207,7,FALSE)+C84*VLOOKUP(K84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$181:$Q$207,3,FALSE)+E76*VLOOKUP(M76,$I$181:$Q$207,3,FALSE)+E78*VLOOKUP(M78,$I$181:$Q$207,3,FALSE)+E80*VLOOKUP(M80,$I$181:$Q$207,7,FALSE)+E82*VLOOKUP(M82,$I$181:$Q$207,7,FALSE)+E84*VLOOKUP(M84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$181:$Q$207,3,FALSE)+F76*VLOOKUP(O76,$I$181:$Q$207,3,FALSE)+F78*VLOOKUP(O78,$I$181:$Q$207,3,FALSE)+F80*VLOOKUP(O80,$I$181:$Q$207,7,FALSE)+F82*VLOOKUP(O82,$I$181:$Q$207,7,FALSE)+F84*VLOOKUP(O84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$181:$Q$207,3,FALSE)+G76*VLOOKUP(Q76,$I$181:$Q$207,3,FALSE)+G78*VLOOKUP(Q78,$I$181:$Q$207,3,FALSE)+G80*VLOOKUP(Q80,$I$181:$Q$207,7,FALSE)+G82*VLOOKUP(Q82,$I$181:$Q$207,7,FALSE)+G84*VLOOKUP(Q84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$181:$Q$207,3,FALSE)+H76*VLOOKUP(S76,$I$181:$Q$207,3,FALSE)+H78*VLOOKUP(S78,$I$181:$Q$207,3,FALSE)+H80*VLOOKUP(S80,$I$181:$Q$207,7,FALSE)+H82*VLOOKUP(S82,$I$181:$Q$207,7,FALSE)+H84*VLOOKUP(S84,$I$181:$Q$207,7,FALSE)","v":0}]
[]
[]
[null,null,"*Specific Graduate Departments"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
["*Animal Sci, Comp Sci, GDCB, Microbiology, Plant Path, BBMB, EEOB, Industrial Design, NREM"]
[]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max",null,"esc. Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4-time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2-time"]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q91/4","v":1118},null,{"$f":"O91","v":2236},null,{"$f":"Q91/2","v":2236},null,4472]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K91*$S$88","v":1164.9560000000001},{"$f":"L91*$S$88","v":0},{"$f":"M91*$S$88","v":2329.9120000000003},0,{"$f":"Q92/2","v":2329.9120000000003},0,{"$f":"Q91*$S$88","v":4659.8240000000005}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K92*$S$88","v":1213.8841520000001},null,2427.7683040000002,null,2427.7683040000002,null,4855.5366080000003]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1264.8672863840002,null,2529.7345727680004,null,2529.7345727680004,null,{"$f":"Q93*$S$88","v":5059.4691455360007}]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1317.9917124121282,null,2635.9834248242564,null,2635.9834248242564,null,{"$f":"Q94*$S$88","v":5271.9668496485128}]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1373.3473643334376,null,2746.6947286668751,null,2746.6947286668751,null,{"$f":"Q95*$S$88","v":5493.3894573337502}]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1431.0279536354419,null,2862.0559072708838,null,2862.0559072708838,null,{"$f":"Q96*$S$88","v":5724.1118145417677}]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1491.1311276881306,null,2982.2622553762612,null,2982.2622553762612,null,5964.5245107525225]
[]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q100/4","v":1118},null,{"$f":"Q100/2","v":2236},null,{"$f":"Q100/2","v":2236},null,4472]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M101/2","v":1164.9560000000001},null,{"$f":"O101","v":2329.9120000000003},null,{"$f":"Q101/2","v":2329.9120000000003},null,{"$f":"Q100*$S$88","v":4659.8240000000005}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K101*$S$88","v":1213.8841520000001},null,{"$f":"M101*$S$88","v":2427.7683040000002},null,{"$f":"O101*$S$88","v":2427.7683040000002},null,{"$f":"Q101*$S$88","v":4855.5366080000003}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1264.8672863840002,null,2529.7345727680004,null,2529.7345727680004,null,{"$f":"Q102*$S$88","v":5059.4691455360007}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1317.9917124121282,null,2635.9834248242564,null,2635.9834248242564,null,5271.9668496485128]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1373.3473643334376,null,2746.6947286668751,null,2746.6947286668751,null,5493.3894573337502]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1431.0279536354419,null,2862.0559072708838,null,2862.0559072708838,null,5724.1118145417677]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1491.1311276881306,null,2982.2622553762612,null,2982.2622553762612,null,5964.5245107525225]
[]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q109/4","v":606.25},null,{"$f":"Q109/2","v":1212.5},null,{"$f":"Q109/2","v":1212.5},null,2425]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K109*$S$88","v":631.71249999999998},null,{"$f":"M109*$S$88","v":1263.425},null,{"$f":"O109*$S$88","v":1263.425},null,{"$f":"Q109*S88","v":2526.85}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K110*$S$88","v":658.24442499999998},null,{"$f":"M110*$S$88","v":1316.48885},null,{"$f":"O110*$S$88","v":1316.48885},null,{"$f":"Q110*$S$88","v":2632.9776999999999}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,685.89069085000006,null,1371.7813817000001,null,1371.7813817000001,null,2743.5627634000002]
[null,null,null,null,null,null,null,null,"Summer 2021",null,714.6980998657001,null,1429.3961997314002,null,1429.3961997314002,null,2858.7923994628004]
[null,null,null,null,null,null,null,null,"Summer 2022",null,744.7154200600595,null,1489.430840120119,null,1489.430840120119,null,2978.861680240238]
[null,null,null,null,null,null,null,null,"Summer 2023",null,775.99346770258205,null,1551.9869354051641,null,1551.9869354051641,null,3103.9738708103282]
[null,null,null,null,null,null,null,null,"Summer 2024",null,808.58519334609048,null,{"$f":"M115*$S$88","v":1617.170386692181},null,1617.170386692181,null,3234.3407733843619]
[]
[null,null,null,null,null,null,null,null,"Engineering & Architecture students"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q121/4","v":1285},null,{"$f":"O121","v":2570},null,{"$f":"Q121/2","v":2570},null,5140]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K121*$S$88","v":1338.97},null,{"$f":"M121*$S$88","v":2677.94},null,{"$f":"O121*$S$88","v":2677.94},null,{"$f":"Q121*$S$88","v":5355.88}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K122*$S$88","v":1395.2067400000001},null,{"$f":"M122*$S$88","v":2790.4134800000002},null,{"$f":"O122*$S$88","v":2790.4134800000002},null,5580.8269600000003]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1453.8054230800001,null,2907.6108461600002,null,2907.6108461600002,null,5815.2216923200003]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1514.8652508493601,null,3029.7305016987202,null,3029.7305016987202,null,6059.4610033974404]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1578.4895913850332,null,3156.9791827700665,null,3156.9791827700665,null,6313.9583655401329]
[null,null,null,null,null,null,null,null,"Fall 2023",null,{"$f":"K126*$S$88","v":1644.7861542232047},null,3289.5723084464094,null,3289.5723084464094,null,6579.1446168928187]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1713.8671727005794,null,3427.7343454011589,null,3427.7343454011589,null,6855.4686908023177]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q130/4","v":1285},null,{"$f":"O130","v":2570},null,{"$f":"Q130/2","v":2570},null,5140]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M131/2","v":1338.97},null,{"$f":"O131","v":2677.94},null,{"$f":"Q131/2","v":2677.94},null,{"$f":"Q130*$S$88","v":5355.88}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K131*$S$88","v":1395.2067400000001},null,{"$f":"M131*$S$88","v":2790.4134800000002},null,{"$f":"O131*$S$88","v":2790.4134800000002},null,{"$f":"Q131*$S$88","v":5580.8269600000003}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1453.8054230800001,null,2907.6108461600002,null,2907.6108461600002,null,5815.2216923200003]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1514.8652508493601,null,3029.7305016987202,null,3029.7305016987202,null,6059.4610033974404]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1578.4895913850332,null,3156.9791827700665,null,3156.9791827700665,null,6313.9583655401329]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1644.7861542232047,null,3289.5723084464094,null,3289.5723084464094,null,6579.1446168928187]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1713.8671727005794,null,3427.7343454011589,null,3427.7343454011589,null,6855.4686908023177]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q139/4","v":700},null,{"$f":"Q139/2","v":1400},null,{"$f":"Q139/2","v":1400},null,2800]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K139*$S$88","v":729.4},null,{"$f":"M139*$S$88","v":1458.8},null,{"$f":"O139*$S$88","v":1458.8},null,{"$f":"Q139*$S$88","v":2917.6}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K140*$S$88","v":760.03480000000002},null,{"$f":"M140*$S$88","v":1520.0696},null,{"$f":"O140*$S$88","v":1520.0696},null,{"$f":"Q140*$S$88","v":3040.1392000000001}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,791.95626160000006,null,1583.9125232000001,null,1583.9125232000001,null,3167.8250464000002]
[null,null,null,null,null,null,null,null,"Summer 2021",null,825.21842458720005,null,1650.4368491744001,null,1650.4368491744001,null,3300.8736983488002]
[null,null,null,null,null,null,null,null,"Summer 2022",null,859.87759841986247,null,1719.7551968397249,null,1719.7551968397249,null,3439.5103936794499]
[null,null,null,null,null,null,null,null,"Summer 2023",null,895.99245755349671,null,1791.9849151069934,null,1791.9849151069934,null,3583.9698302139868]
[null,null,null,null,null,null,null,null,"Summer 2024",null,933.62414077074357,null,1867.2482815414871,null,1867.2482815414871,null,3734.4965630829743]
[]
[null,null,null,null,null,null,null,null,"Business & STB"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q151/4","v":1351.5},null,{"$f":"Q151/2","v":2703},null,{"$f":"Q151/2","v":2703},null,5406]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K151*$S$88","v":1408.2630000000001},null,{"$f":"M151*$S$88","v":2816.5260000000003},null,{"$f":"O151*$S$88","v":2816.5260000000003},null,{"$f":"Q151*$S$88","v":5633.0520000000006}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K152*$S$88","v":1467.4100460000002},null,{"$f":"M152*$S$88","v":2934.8200920000004},null,{"$f":"O152*$S$88","v":2934.8200920000004},null,{"$f":"Q152*$S$88","v":5869.6401840000008}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1529.0412679320002,null,3058.0825358640004,null,3058.0825358640004,null,6116.1650717280008]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1593.2610011851443,null,3186.5220023702886,null,3186.5220023702886,null,6373.0440047405773]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1660.1779632349205,null,3320.3559264698411,null,3320.3559264698411,null,6640.7118529396821]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1729.9054376907873,null,3459.8108753815745,null,3459.8108753815745,null,6919.6217507631491]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1802.5614660738004,null,3605.1229321476007,null,3605.1229321476007,null,7210.2458642952015]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q160/4","v":1351.5},null,{"$f":"Q160/2","v":2703},null,{"$f":"Q160/2","v":2703},null,5406]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M161/2","v":1408.2630000000001},null,{"$f":"O161","v":2816.5260000000003},null,{"$f":"Q161/2","v":2816.5260000000003},null,{"$f":"Q160*$S$88","v":5633.0520000000006}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K161*$S$88","v":1467.4100460000002},null,{"$f":"M161*$S$88","v":2934.8200920000004},null,{"$f":"O161*$S$88","v":2934.8200920000004},null,{"$f":"Q161*$S$88","v":5869.6401840000008}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1529.0412679320002,null,3058.0825358640004,null,3058.0825358640004,null,{"$f":"Q162*$S$88","v":6116.1650717280008}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1593.2610011851443,null,3186.5220023702886,null,3186.5220023702886,null,6373.0440047405773]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1660.1779632349205,null,3320.3559264698411,null,3320.3559264698411,null,6640.7118529396821]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1729.9054376907873,null,3459.8108753815745,null,3459.8108753815745,null,6919.6217507631491]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1802.5614660738004,null,3605.1229321476007,null,3605.1229321476007,null,7210.2458642952015]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q169/4","v":736.25},null,{"$f":"Q169/2","v":1472.5},null,{"$f":"Q169/2","v":1472.5},null,2945]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K169*$S$88","v":767.17250000000001},null,{"$f":"M169*$S$88","v":1534.345},null,{"$f":"O169*$S$88","v":1534.345},null,{"$f":"Q169*$S$88","v":3068.69}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K170*$S$88","v":799.39374500000008},null,{"$f":"M170*$S$88","v":1598.7874900000002},null,{"$f":"O170*$S$88","v":1598.7874900000002},null,{"$f":"Q170*$S$88","v":3197.5749800000003}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,832.96828229000016,null,1665.9365645800003,null,1665.9365645800003,null,3331.8731291600006]
[null,null,null,null,null,null,null,null,"Summer 2021",null,867.95295014618023,null,1735.9059002923605,null,1735.9059002923605,null,3471.8118005847209]
[null,null,null,null,null,null,null,null,"Summer 2022",null,904.40697405231981,null,1808.8139481046396,null,1808.8139481046396,null,3617.6278962092792]
[null,null,null,null,null,null,null,null,"Summer 2023",null,942.39206696251733,null,1884.7841339250347,null,1884.7841339250347,null,3769.5682678500693]
[null,null,null,null,null,null,null,null,"Summer 2024",null,981.97253377494314,null,1963.9450675498863,null,1963.9450675498863,null,3927.8901350997726]
[]
[null,null,null,null,null,null,null,null,"Specific Graduate Departments"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q181/4","v":1164.75},null,{"$f":"Q181/2","v":2329.5},null,{"$f":"Q181/2","v":2329.5},null,4659]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K181*$S$88","v":1213.6695},null,{"$f":"M181*$S$88","v":2427.3389999999999},null,{"$f":"O181*$S$88","v":2427.3389999999999},null,{"$f":"Q181*$S$88","v":4854.6779999999999}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K182*$S$88","v":1264.6436189999999},null,{"$f":"M182*$S$88","v":2529.2872379999999},null,{"$f":"O182*$S$88","v":2529.2872379999999},null,{"$f":"Q182*$S$88","v":5058.5744759999998}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1317.7586509979999,null,2635.5173019959998,null,2635.5173019959998,null,5271.0346039919996]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1373.104514339916,null,2746.209028679832,null,2746.209028679832,null,5492.4180573596641]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1430.7749039421926,null,2861.5498078843852,null,2861.5498078843852,null,5723.0996157687705]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1490.8674499077647,null,2981.7348998155294,null,2981.7348998155294,null,5963.4697996310588]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1553.4838828038908,null,3106.9677656077815,null,3106.9677656077815,null,6213.9355312155631]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q190/4","v":1164.75},null,{"$f":"Q190/2","v":2329.5},null,{"$f":"Q190/2","v":2329.5},null,4659]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M191/2","v":1213.6695},null,{"$f":"O191","v":2427.3389999999999},null,{"$f":"Q191/2","v":2427.3389999999999},null,{"$f":"Q190*$S$88","v":4854.6779999999999}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K191*$S$88","v":1264.6436189999999},null,{"$f":"M191*$S$88","v":2529.2872379999999},null,{"$f":"O191*$S$88","v":2529.2872379999999},null,{"$f":"Q191*$S$88","v":5058.5744759999998}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1317.7586509979999,null,2635.5173019959998,null,2635.5173019959998,null,{"$f":"Q192*$S$88","v":5271.0346039919996}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1373.104514339916,null,2746.209028679832,null,2746.209028679832,null,5492.4180573596641]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1430.7749039421926,null,2861.5498078843852,null,2861.5498078843852,null,5723.0996157687705]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1490.8674499077647,null,2981.7348998155294,null,2981.7348998155294,null,5963.4697996310588]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1553.4838828038908,null,3106.9677656077815,null,3106.9677656077815,null,6213.9355312155631]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q199/4","v":632.5},null,{"$f":"Q199/2","v":1265},null,{"$f":"Q199/2","v":1265},null,2530]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K199*$S$88","v":659.06500000000005},null,{"$f":"M199*$S$88","v":1318.13},null,{"$f":"O199*$S$88","v":1318.13},null,{"$f":"Q199*$S$88","v":2636.26}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K200*$S$88","v":686.74573000000009},null,{"$f":"M200*$S$88","v":1373.4914600000002},null,{"$f":"O200*$S$88","v":1373.4914600000002},null,{"$f":"Q200*$S$88","v":2746.9829200000004}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,715.58905066000011,null,1431.1781013200002,null,1431.1781013200002,null,2862.3562026400004]
[null,null,null,null,null,null,null,null,"Summer 2021",null,745.64379078772015,null,1491.2875815754403,null,1491.2875815754403,null,2982.5751631508806]
[null,null,null,null,null,null,null,null,"Summer 2022",null,776.96083000080444,null,1553.9216600016089,null,1553.9216600016089,null,3107.8433200032177]
[null,null,null,null,null,null,null,null,"Summer 2023",null,809.59318486083828,null,1619.1863697216766,null,1619.1863697216766,null,3238.3727394433531]
[null,null,null,null,null,null,null,null,"Summer 2024",null,843.59609862499349,null,1687.192197249987,null,1687.192197249987,null,3374.384394499974]

{"sheet":"Travel Details","index":2,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,12,0,13],[4,10,15,10],[18,10,29,10],[32,0,32,8]]}
["Only use this sheet tab if the sponsor requires a detailed breakdown of your travel (Ex: NSF and USDA)",null,null,null,null,null,null,null,null,null,null,null,"Directions:"]
["Complete table; Copy & Paste (special - picture) into the Budget Justification",null,null,null,null,null,null,null,null,null,null,null,"1. Complete itemized travel table (note:  some sections have formulas; please edit as necessary)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2. Check Expedia or Travelocity for current airfare and hotel rates"]
[null,"DOMESTIC TRAVEL",null,null,null,null,null,null,null,null,null,null,"3. Use GSA rates for foreign travel - website :",null,null,null,null,"https://aoprals.state.gov/web920/per_diem.asp"]
["Year","Purpose of Travel/\nDestination","No. of Travelers","Estim.\nAirfare","Nights\nper Trip","Lodging\n Rate","Days","Per\nDiem","Misc.*","TOTAL","COPY TOTALS FROM EACH YEAR TO THE TRAVEL SECTION ON THE YELLOW SUMMARY TAB",null,"4. Misc* column includes registration fees, mileage to airport, airport parking, shuttles, taxis, etc. (add notes if needed)"]
[1,"________ Conference",1,0,null,0,null,40,0,{"$f":"C6*(((D6)+(E6*F6)+(H6*G6))+(I6))","v":0},null,null,"5. Enter yearly travel amounts on SUMMARY sheet tab"]
[null,"(Enter Location or TBD)",null,null,null,null,null,null,null,null,null,null,"6. Copy & Paste the travel table as \"Paste, Special, Picture\" into the Budget Justification "]
[2,"________ Conference",1,0,null,0,null,40,0,{"$f":"C8*(((D8)+(E8*F8)+(H8*G8))+(I8))","v":0}]
[null,"(Enter Location or TBD)",null,null,null,null,null,null,null,null,null,null,"MISC:"]
[3,"________ Conference",1,0,null,0,null,40,0,{"$f":"C10*(((D10)+(E10*F10)+(H10*G10))+(I10))","v":0},null,null,"Registration Fees - look at conferenece website for an estimate"]
[null,"(Enter Location or TBD)",null,null,null,null,null,null," ",null,null,null,"Mileage to airport:  From AMES to DSM:  84 miles x $0.545 (2018 rate) = ",null,null,null,null,null,null,{"$f":"84*0.545","v":45.78}]
[4,"________ Conference",1,0,null,0,null,40,0,{"$f":"C12*(((D12)+(E12*F12)+(H12*G12))+(I12))","v":0},null,null,"Parking at airport: up to $10/day for economy"]
[null,"(Enter Location or TBD)",null,null,null,null,null,null,null,null,null,null,"Shuttles/Cabs:  estimate up to $20/day, depending on destination"]
[5,"________ Conference",1,0,null,0,null,40,0,{"$f":"C14*(((D14)+(E14*F14)+(H14*G14))+(I14))","v":0}]
[null,"(Enter Location or TBD)",null,null,null,null,null,null," "]
["TOTAL DOMESTIC TRAVEL",null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J15)","v":0}]
["* Miscellaneous:  Registration fees, Mileage to Airport, Parking at Airport, Shuttles, Other."]
[]
["FOREIGN TRAVEL",null,null,null,null,"GSA Rate",null,"GSA Rate",null,null,"COPY TOTALS FROM EACH YEAR TO THE TRAVEL SECTION ON THE YELLOW SUMMARY TAB","Recommend using GSA rates for Lodging and Meals & Incidentals:  https://aoprals.state.gov/web920/per_diem.asp"]
[1,"________ Conference",1,0,null,0,null,0,0,{"$f":"C20*(((D20)+(E20*F20)+(H20*G20))+(I20))","v":0},null," "]
[null,"(Enter Location or TBD)",null,null,null,null,null,null,null,null,null," "]
[2,"________ Conference",1,0,null,0,null,0,0,{"$f":"C22*(((D22)+(E22*F22)+(H22*G22))+(I22))","v":0},null,null,"Use GSA rates (see instruction #3 above)"]
[null,"(Enter Location or TBD)",null,null,null,null,null,null," "]
[3,"________ Conference",1,0,null,0,null,0,0,{"$f":"C24*(((D24)+(E24*F24)+(H24*G24))+(I24))","v":0}]
[null,"(Enter Location or TBD)",null,null,null," ",null,null," "]
[4,"________ Conference",1,0,null,0,null,0,0,{"$f":"C26*(((D26)+(E26*F26)+(H26*G26))+(I26))","v":0}]
[null,"(Enter Location or TBD)",null,null,null,null,null,null," "]
[5,"________ Conference",1,0,null,0,null,0,0,{"$f":"C28*(((D28)+(E28*F28)+(H28*G28))+(I28))","v":0}]
[null,"(Enter Location or TBD)",null,null,null,null,null,null," "]
["TOTAL FOREIGN TRAVEL",null,null,null,null,null,null,null,null,{"$f":"SUM(J20:J29)","v":0}]
["* Miscellaneous:  Registration fees, Mileage to Airport, Parking at Airport, Shuttles, Other."]
[]
["TOTAL DOMESTIC AND FOREIGN TRAVEL",null,null,null,null,null,null,null,null,{"$f":"J16+J30","v":0}]
[]
[" "]

{"sheet":"F&A Calculation- Sponsor Funds ","index":3,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Tool to Calculate Split F&A Rates for a Project Period"]
[]
["INSTRUCTIONS:","Use this tool to help you calculate split F&A for budgeting purposes. By entering the Project Budget amount, and start and end dates, this tool will calculate the correct F&A rate for the period."]
[null,"The only fields needed are the Start Date, End Date, and the Modified Total Direct Cost Amount. This tool will calculate the F&A rate and amount based on the reference table shown."]
[]
[null,"Please be aware that if your Project period Start and End dates span multiple F&A effective dates, you will need to add the additional effective dates and rates to the Project Activity>FA Rates tab in EFS."]
[null,"See the job aid: Setting up F&A on a Project Using Split Rates"]
[]
[null,"This tool is set up to accommodate up to 7 separate Project Budget periods and will provide a Grand Total of all budget periods."]
[]
[null,null,null,"Total MTDC",null,null,null,null,"Total F&A"]
["PROJECT GRAND TOTALS:",null,null,{"$f":"D22+D32+D42+D52+D62+D72+D82","v":0},null,null,null,null,{"$f":"I22+I32+I42+I52+I62+I72+I82","v":0}]
[]
[]
["1st Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated","Reference Only \nRate Table:"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount","Use F&A Rate Effective Date","F&A Rate End","F&A Rate %"]
["Project Start Date",{"$f":"Summary!H11","v":"2017-07-01"},{"$f":"ROUND(IF((B17=0),0,(B18-B17))/30,0)","v":12},{"$f":"Summary!H100","v":0},{"$f":"IF(ISERROR(D17/F22),0,(D17/F22))","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,(MIN($B$18,$L17)-MAX($B$17,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F17/365),0,(F17/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,M17)","v":0},{"$f":"(F17*$E$17)*H17","v":0},{"$f":"IF(ISERROR(I17/H17),0,(I17/H17))","v":0},"2016-07-01","2017-06-30",0.52]
["Project End Date",{"$f":"Summary!I11","v":"2018-06-30"},null,null,null,{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,(MIN($B$18,$L18)-MAX($B$17,$K18)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F18/365),0,(F18/365)*12),2)","v":12},{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,M18)","v":0.52},{"$f":"(F18*$E$17)*H18","v":0},{"$f":"IF(ISERROR(I18/H18),0,(I18/H18))","v":0},"2017-07-01","2018-06-30",0.52]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,(MIN($B$18,$L19)-MAX($B$17,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F19/365),0,(F19/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,M19)","v":0},{"$f":"(F19*$E$17)*H19","v":0},{"$f":"IF(ISERROR(I19/H19),0,(I19/H19))","v":0},"2018-07-01","2019-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,(MIN($B$18,$L20)-MAX($B$17,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F20/365),0,(F20/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,M20)","v":0},{"$f":"(F20*$E$17)*H20","v":0},{"$f":"IF(ISERROR(I20/H20),0,(I20/H20))","v":0},"2019-07-01","2020-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,(MIN($B$18,$L21)-MAX($B$17,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F21/365),0,(F21/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,M21)","v":0},{"$f":"(F21*$E$17)*H21","v":0},{"$f":"IF(ISERROR(I21/H21),0,(I21/H21))","v":0},"2020-07-01","2030-06-30",0.53]
[null,"Totals:",null,{"$f":"SUM(D17:D21)","v":0},null,{"$f":"SUM(F17:F21)","v":365},{"$f":"SUM(G17:G21)","v":12},{"$f":"AVERAGEIF(H17:H21,\"<>0\")","v":0.52},{"$f":"SUM(I17:I21)","v":0},{"$f":"SUM(J17:J21)","v":0}]
[]
[]
["2nd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!J11","v":"2018-07-01"},{"$f":"ROUND(IF((B27=0),0,(B28-B27))/30,0)","v":12},{"$f":"Summary!J100","v":0},{"$f":"IF(ISERROR(D27/F32),0,(D27/F32))","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,(MIN($B$28,$L17)-MAX($B$27,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F27/365),0,(F27/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,M17)","v":0},{"$f":"(F27*$E$27)*H27","v":0},{"$f":"IF(ISERROR(I27/H27),0,(I27/H27))","v":0}]
["Project End Date",{"$f":"Summary!K11","v":"2019-06-30"},null,null,null,{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,(MIN($B$28,$L18)-MAX($B$27,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F28/365),0,(F28/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,M18)","v":0},{"$f":"(F28*$E$27)*H28","v":0},{"$f":"IF(ISERROR(I28/H28),0,(I28/H28))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,(MIN($B$28,$L19)-MAX($B$27,$K19)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F29/365),0,(F29/365))*12,0)","v":12},{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,M19)","v":0.53},{"$f":"(F29*$E$27)*H29","v":0},{"$f":"IF(ISERROR(I29/H29),0,(I29/H29))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,(MIN($B$28,$L20)-MAX($B$27,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F30/365),0,(F30/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,M20)","v":0},{"$f":"(F30*$E$27)*H30","v":0},{"$f":"IF(ISERROR(I30/H30),0,(I30/H30))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,(MIN($B$28,$L21)-MAX($B$27,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F31/365),0,(F31/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,M21)","v":0},{"$f":"(F31*$E$27)*H31","v":0},{"$f":"IF(ISERROR(I31/H31),0,(I31/H31))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D27:D31)","v":0},null,{"$f":"SUM(F27:F31)","v":365},{"$f":"SUM(G27:G31)","v":12},{"$f":"AVERAGEIF(H27:H31,\"<>0\")","v":0.53},{"$f":"SUM(I27:I31)","v":0},{"$f":"SUM(J27:J31)","v":0}]
[]
[]
["3rd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!L11","v":"2019-07-01"},{"$f":"ROUND(IF((B37=0),0,(B38-B37))/30,0)","v":12},{"$f":"Summary!L100","v":0},{"$f":"IF(ISERROR(D37/F42),0,(D37/F42))","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,(MIN($B$38,$L17)-MAX($B$37,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F37/365),0,(F37/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,M17)","v":0},{"$f":"(F37*$E$37)*H37","v":0},{"$f":"IF(ISERROR(I37/H37),0,(I37/H37))","v":0}]
["Project End Date",{"$f":"Summary!M11","v":"2020-06-30"},null,null,null,{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,(MIN($B$38,$L18)-MAX($B$37,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F38/365),0,(F38/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,M18)","v":0},{"$f":"(F38*$E$37)*H38","v":0},{"$f":"IF(ISERROR(I38/H38),0,(I38/H38))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,(MIN($B$38,$L19)-MAX($B$37,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F39/365),0,(F39/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,M19)","v":0},{"$f":"(F39*$E$37)*H39","v":0},{"$f":"IF(ISERROR(I39/H39),0,(I39/H39))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,(MIN($B$38,$L20)-MAX($B$37,$K20)+1))","v":366},{"$f":"ROUND(IF(ISERROR(F40/365),0,(F40/365))*12,0)","v":12},{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,M20)","v":0.53},{"$f":"(F40*$E$37)*H40","v":0},{"$f":"IF(ISERROR(I40/H40),0,(I40/H40))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,(MIN($B$38,$L21)-MAX($B$37,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F41/365),0,(F41/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,M21)","v":0},{"$f":"(F41*$E$37)*H41","v":0},{"$f":"IF(ISERROR(I41/H41),0,(I41/H41))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D37:D41)","v":0},null,{"$f":"SUM(F37:F41)","v":366},{"$f":"SUM(G37:G41)","v":12},{"$f":"AVERAGEIF(H37:H41,\"<>0\")","v":0.53},{"$f":"SUM(I37:I41)","v":0},{"$f":"SUM(J37:J41)","v":0}]
[]
[]
["4th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!N11","v":"2020-07-01"},{"$f":"ROUND(IF((B47=0),0,(B48-B47))/30,0)","v":12},{"$f":"Summary!N100","v":0},{"$f":"IF(ISERROR(D47/F52),0,(D47/F52))","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,(MIN($B$48,$L17)-MAX($B$47,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F47/365),0,(F47/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,M17)","v":0},{"$f":"(F47*$E$47)*H47","v":0},{"$f":"IF(ISERROR(I47/H47),0,(I47/H47))","v":0}]
["Project End Date",{"$f":"Summary!O11","v":"2021-06-30"},null,null,null,{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,(MIN($B$48,$L18)-MAX($B$47,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F48/365),0,(F48/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,M18)","v":0},{"$f":"(F48*$E$47)*H48","v":0},{"$f":"IF(ISERROR(I48/H48),0,(I48/H48))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,(MIN($B$48,$L19)-MAX($B$47,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F49/365),0,(F49/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,M19)","v":0},{"$f":"(F49*$E$47)*H49","v":0},{"$f":"IF(ISERROR(I49/H49),0,(I49/H49))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,(MIN($B$48,$L20)-MAX($B$47,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F50/365),0,(F50/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,M20)","v":0},{"$f":"(F50*$E$47)*H50","v":0},{"$f":"IF(ISERROR(I50/H50),0,(I50/H50))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,(MIN($B$48,$L21)-MAX($B$47,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F51/365),0,(F51/365))*12,0)","v":12},{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,M21)","v":0.53},{"$f":"(F51*$E$47)*H51","v":0},{"$f":"IF(ISERROR(I51/H51),0,(I51/H51))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D47:D51)","v":0},null,{"$f":"SUM(F47:F51)","v":365},{"$f":"SUM(G47:G51)","v":12},{"$f":"AVERAGEIF(H47:H51,\"<>0\")","v":0.53},{"$f":"SUM(I47:I51)","v":0},{"$f":"SUM(J47:J51)","v":0}]
[]
[]
["5th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!P11","v":"2021-07-01"},{"$f":"ROUND(IF((B57=0),0,(B58-B57))/30,0)","v":12},{"$f":"Summary!P100","v":0},{"$f":"IF(ISERROR(D57/F62),0,(D57/F62))","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,(MIN($B$58,$L17)-MAX($B$57,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F57/365),0,(F57/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,M17)","v":0},{"$f":"(F57*$E$57)*H57","v":0},{"$f":"IF(ISERROR(I57/H57),0,(I57/H57))","v":0}]
["Project End Date",{"$f":"Summary!Q11","v":"2022-06-30"},null,null,null,{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,(MIN($B$58,$L18)-MAX($B$57,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F58/365),0,(F58/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,M18)","v":0},{"$f":"(F58*$E$57)*H58","v":0},{"$f":"IF(ISERROR(I58/H58),0,(I58/H58))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,(MIN($B$58,$L19)-MAX($B$57,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F59/365),0,(F59/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,M19)","v":0},{"$f":"(F59*$E$57)*H59","v":0},{"$f":"IF(ISERROR(I59/H59),0,(I59/H59))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,(MIN($B$58,$L20)-MAX($B$57,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F60/365),0,(F60/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,M20)","v":0},{"$f":"(F60*$E$57)*H60","v":0},{"$f":"IF(ISERROR(I60/H60),0,(I60/H60))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,(MIN($B$58,$L21)-MAX($B$57,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F61/365),0,(F61/365))*12,0)","v":12},{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,M21)","v":0.53},{"$f":"(F61*$E$57)*H61","v":0},{"$f":"IF(ISERROR(I61/H61),0,(I61/H61))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D57:D61)","v":0},null,{"$f":"SUM(F57:F61)","v":365},{"$f":"SUM(G57:G61)","v":12},{"$f":"AVERAGEIF(H57:H61,\"<>0\")","v":0.53},{"$f":"SUM(I57:I61)","v":0},{"$f":"SUM(J57:J61)","v":0}]
[]
[]
["6th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B67=0),0,(B68-B67))/30,0)","v":0},0,{"$f":"IF(ISERROR(D67/F72),0,(D67/F72))","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,(MIN($B$68,$L17)-MAX($B$67,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F67/365),0,(F67/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,M17)","v":0},{"$f":"(F67*$E$67)*H67","v":0},{"$f":"IF(ISERROR(I67/H67),0,(I67/H67))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,(MIN($B$68,$L18)-MAX($B$67,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F68/365),0,(F68/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,M18)","v":0},{"$f":"(F68*$E$67)*H68","v":0},{"$f":"IF(ISERROR(I68/H68),0,(I68/H68))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,(MIN($B$68,$L19)-MAX($B$67,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F69/365),0,(F69/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,M19)","v":0},{"$f":"(F69*$E$67)*H69","v":0},{"$f":"IF(ISERROR(I69/H69),0,(I69/H69))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,(MIN($B$68,$L20)-MAX($B$67,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F70/365),0,(F70/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,M20)","v":0},{"$f":"(F70*$E$67)*H70","v":0},{"$f":"IF(ISERROR(I70/H70),0,(I70/H70))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,(MIN($B$68,$L21)-MAX($B$67,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F71/365),0,(F71/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,M21)","v":0},{"$f":"(F71*$E$67)*H71","v":0},{"$f":"IF(ISERROR(I71/H71),0,(I71/H71))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D67:D71)","v":0},null,{"$f":"SUM(F67:F71)","v":0},{"$f":"SUM(G67:G71)","v":0},{"$f":"AVERAGEIF(H67:H71,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I67:I71)","v":0},{"$f":"SUM(J67:J71)","v":0}]
[]
[]
["7th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B77=0),0,(B78-B77))/30,0)","v":0},0,{"$f":"IF(ISERROR(D77/F82),0,(D77/F82))","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,(MIN($B$78,$L17)-MAX($B$77,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F77/365),0,(F77/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,M17)","v":0},{"$f":"(F77*$E$77)*H77","v":0},{"$f":"IF(ISERROR(I77/H77),0,(I77/H77))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,(MIN($B$78,$L18)-MAX($B$77,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F78/365),0,(F78/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,M18)","v":0},{"$f":"(F78*$E$77)*H78","v":0},{"$f":"IF(ISERROR(I78/H78),0,(I78/H78))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,(MIN($B$78,$L19)-MAX($B$77,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F79/365),0,(F79/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,M19)","v":0},{"$f":"(F79*$E$77)*H79","v":0},{"$f":"IF(ISERROR(I79/H79),0,(I79/H79))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,(MIN($B$78,$L20)-MAX($B$77,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F80/365),0,(F80/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,M20)","v":0},{"$f":"(F80*$E$77)*H80","v":0},{"$f":"IF(ISERROR(I80/H80),0,(I80/H80))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,(MIN($B$78,$L21)-MAX($B$77,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F81/365),0,(F81/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,M21)","v":0},{"$f":"(F81*$E$77)*H81","v":0},{"$f":"IF(ISERROR(I81/H81),0,(I81/H81))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D77:D81)","v":0},null,{"$f":"SUM(F77:F81)","v":0},{"$f":"SUM(G77:G81)","v":0},{"$f":"AVERAGEIF(H77:H81,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I77:I81)","v":0},{"$f":"SUM(J77:J81)","v":0}]

{"sheet":"F&A Calculations - Cost Share","index":4,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Tool to Calculate Split F&A Rates for a Project Period"]
[]
["INSTRUCTIONS:","Use this tool to help you calculate split F&A for budgeting purposes. By entering the Project Budget amount, and start and end dates, this tool will calculate the correct F&A rate for the period."]
[null,"The only fields needed are the Start Date, End Date, and the Modified Total Direct Cost Amount. This tool will calculate the F&A rate and amount based on the reference table shown."]
[]
[null,"Please be aware that if your Project period Start and End dates span multiple F&A effective dates, you will need to add the additional effective dates and rates to the Project Activity>FA Rates tab in EFS."]
[null,"See the job aid: Setting up F&A on a Project Using Split Rates"]
[]
[null,"This tool is set up to accommodate up to 7 separate Project Budget periods and will provide a Grand Total of all budget periods."]
[]
[null,null,null,"Total MTDC",null,null,null,null,"Total F&A"]
["PROJECT GRAND TOTALS:",null,null,{"$f":"D22+D32+D42+D52+D62+D72+D82","v":0},null,null,null,null,{"$f":"I22+I32+I42+I52+I62+I72+I82","v":0}]
[]
[]
["1st Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated","Reference Only \nRate Table:"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount","Use F&A Rate Effective Date","F&A Rate End","F&A Rate %"]
["Project Start Date",{"$f":"Summary!H11","v":"2017-07-01"},{"$f":"ROUND(IF((B17=0),0,(B18-B17))/30,0)","v":12},{"$f":"Summary!I100","v":0},{"$f":"IF(ISERROR(D17/F22),0,(D17/F22))","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,(MIN($B$18,$L17)-MAX($B$17,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F17/365),0,(F17/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,M17)","v":0},{"$f":"(F17*$E$17)*H17","v":0},{"$f":"IF(ISERROR(I17/H17),0,(I17/H17))","v":0},"2016-07-01","2017-06-30",0.52]
["Project End Date",{"$f":"Summary!I11","v":"2018-06-30"},null,null,null,{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,(MIN($B$18,$L18)-MAX($B$17,$K18)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F18/365),0,(F18/365)*12),2)","v":12},{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,M18)","v":0.52},{"$f":"(F18*$E$17)*H18","v":0},{"$f":"IF(ISERROR(I18/H18),0,(I18/H18))","v":0},"2017-07-01","2018-06-30",0.52]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,(MIN($B$18,$L19)-MAX($B$17,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F19/365),0,(F19/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,M19)","v":0},{"$f":"(F19*$E$17)*H19","v":0},{"$f":"IF(ISERROR(I19/H19),0,(I19/H19))","v":0},"2018-07-01","2019-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,(MIN($B$18,$L20)-MAX($B$17,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F20/365),0,(F20/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,M20)","v":0},{"$f":"(F20*$E$17)*H20","v":0},{"$f":"IF(ISERROR(I20/H20),0,(I20/H20))","v":0},"2019-07-01","2020-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,(MIN($B$18,$L21)-MAX($B$17,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F21/365),0,(F21/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,M21)","v":0},{"$f":"(F21*$E$17)*H21","v":0},{"$f":"IF(ISERROR(I21/H21),0,(I21/H21))","v":0},"2020-07-01","2030-06-30",0.53]
[null,"Totals:",null,{"$f":"SUM(D17:D21)","v":0},null,{"$f":"SUM(F17:F21)","v":365},{"$f":"SUM(G17:G21)","v":12},{"$f":"AVERAGEIF(H17:H21,\"<>0\")","v":0.52},{"$f":"SUM(I17:I21)","v":0},{"$f":"SUM(J17:J21)","v":0}]
[]
[]
["2nd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!J11","v":"2018-07-01"},{"$f":"ROUND(IF((B27=0),0,(B28-B27))/30,0)","v":12},{"$f":"Summary!K100","v":0},{"$f":"IF(ISERROR(D27/F32),0,(D27/F32))","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,(MIN($B$28,$L17)-MAX($B$27,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F27/365),0,(F27/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,M17)","v":0},{"$f":"(F27*$E$27)*H27","v":0},{"$f":"IF(ISERROR(I27/H27),0,(I27/H27))","v":0}]
["Project End Date",{"$f":"Summary!K11","v":"2019-06-30"},null,null,null,{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,(MIN($B$28,$L18)-MAX($B$27,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F28/365),0,(F28/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,M18)","v":0},{"$f":"(F28*$E$27)*H28","v":0},{"$f":"IF(ISERROR(I28/H28),0,(I28/H28))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,(MIN($B$28,$L19)-MAX($B$27,$K19)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F29/365),0,(F29/365))*12,0)","v":12},{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,M19)","v":0.53},{"$f":"(F29*$E$27)*H29","v":0},{"$f":"IF(ISERROR(I29/H29),0,(I29/H29))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,(MIN($B$28,$L20)-MAX($B$27,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F30/365),0,(F30/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,M20)","v":0},{"$f":"(F30*$E$27)*H30","v":0},{"$f":"IF(ISERROR(I30/H30),0,(I30/H30))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,(MIN($B$28,$L21)-MAX($B$27,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F31/365),0,(F31/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,M21)","v":0},{"$f":"(F31*$E$27)*H31","v":0},{"$f":"IF(ISERROR(I31/H31),0,(I31/H31))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D27:D31)","v":0},null,{"$f":"SUM(F27:F31)","v":365},{"$f":"SUM(G27:G31)","v":12},{"$f":"AVERAGEIF(H27:H31,\"<>0\")","v":0.53},{"$f":"SUM(I27:I31)","v":0},{"$f":"SUM(J27:J31)","v":0}]
[]
[]
["3rd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!L11","v":"2019-07-01"},{"$f":"ROUND(IF((B37=0),0,(B38-B37))/30,0)","v":12},{"$f":"Summary!M100","v":0},{"$f":"IF(ISERROR(D37/F42),0,(D37/F42))","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,(MIN($B$38,$L17)-MAX($B$37,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F37/365),0,(F37/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,M17)","v":0},{"$f":"(F37*$E$37)*H37","v":0},{"$f":"IF(ISERROR(I37/H37),0,(I37/H37))","v":0}]
["Project End Date",{"$f":"Summary!M11","v":"2020-06-30"},null,null,null,{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,(MIN($B$38,$L18)-MAX($B$37,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F38/365),0,(F38/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,M18)","v":0},{"$f":"(F38*$E$37)*H38","v":0},{"$f":"IF(ISERROR(I38/H38),0,(I38/H38))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,(MIN($B$38,$L19)-MAX($B$37,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F39/365),0,(F39/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,M19)","v":0},{"$f":"(F39*$E$37)*H39","v":0},{"$f":"IF(ISERROR(I39/H39),0,(I39/H39))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,(MIN($B$38,$L20)-MAX($B$37,$K20)+1))","v":366},{"$f":"ROUND(IF(ISERROR(F40/365),0,(F40/365))*12,0)","v":12},{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,M20)","v":0.53},{"$f":"(F40*$E$37)*H40","v":0},{"$f":"IF(ISERROR(I40/H40),0,(I40/H40))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,(MIN($B$38,$L21)-MAX($B$37,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F41/365),0,(F41/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,M21)","v":0},{"$f":"(F41*$E$37)*H41","v":0},{"$f":"IF(ISERROR(I41/H41),0,(I41/H41))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D37:D41)","v":0},null,{"$f":"SUM(F37:F41)","v":366},{"$f":"SUM(G37:G41)","v":12},{"$f":"AVERAGEIF(H37:H41,\"<>0\")","v":0.53},{"$f":"SUM(I37:I41)","v":0},{"$f":"SUM(J37:J41)","v":0}]
[]
[]
["4th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!N11","v":"2020-07-01"},{"$f":"ROUND(IF((B47=0),0,(B48-B47))/30,0)","v":12},{"$f":"Summary!O100","v":0},{"$f":"IF(ISERROR(D47/F52),0,(D47/F52))","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,(MIN($B$48,$L17)-MAX($B$47,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F47/365),0,(F47/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,M17)","v":0},{"$f":"(F47*$E$47)*H47","v":0},{"$f":"IF(ISERROR(I47/H47),0,(I47/H47))","v":0}]
["Project End Date",{"$f":"Summary!O11","v":"2021-06-30"},null,null,null,{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,(MIN($B$48,$L18)-MAX($B$47,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F48/365),0,(F48/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,M18)","v":0},{"$f":"(F48*$E$47)*H48","v":0},{"$f":"IF(ISERROR(I48/H48),0,(I48/H48))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,(MIN($B$48,$L19)-MAX($B$47,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F49/365),0,(F49/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,M19)","v":0},{"$f":"(F49*$E$47)*H49","v":0},{"$f":"IF(ISERROR(I49/H49),0,(I49/H49))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,(MIN($B$48,$L20)-MAX($B$47,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F50/365),0,(F50/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,M20)","v":0},{"$f":"(F50*$E$47)*H50","v":0},{"$f":"IF(ISERROR(I50/H50),0,(I50/H50))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,(MIN($B$48,$L21)-MAX($B$47,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F51/365),0,(F51/365))*12,0)","v":12},{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,M21)","v":0.53},{"$f":"(F51*$E$47)*H51","v":0},{"$f":"IF(ISERROR(I51/H51),0,(I51/H51))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D47:D51)","v":0},null,{"$f":"SUM(F47:F51)","v":365},{"$f":"SUM(G47:G51)","v":12},{"$f":"AVERAGEIF(H47:H51,\"<>0\")","v":0.53},{"$f":"SUM(I47:I51)","v":0},{"$f":"SUM(J47:J51)","v":0}]
[]
[]
["5th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!P11","v":"2021-07-01"},{"$f":"ROUND(IF((B57=0),0,(B58-B57))/30,0)","v":12},{"$f":"Summary!Q100","v":0},{"$f":"IF(ISERROR(D57/F62),0,(D57/F62))","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,(MIN($B$58,$L17)-MAX($B$57,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F57/365),0,(F57/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,M17)","v":0},{"$f":"(F57*$E$57)*H57","v":0},{"$f":"IF(ISERROR(I57/H57),0,(I57/H57))","v":0}]
["Project End Date",{"$f":"Summary!Q11","v":"2022-06-30"},null,null,null,{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,(MIN($B$58,$L18)-MAX($B$57,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F58/365),0,(F58/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,M18)","v":0},{"$f":"(F58*$E$57)*H58","v":0},{"$f":"IF(ISERROR(I58/H58),0,(I58/H58))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,(MIN($B$58,$L19)-MAX($B$57,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F59/365),0,(F59/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,M19)","v":0},{"$f":"(F59*$E$57)*H59","v":0},{"$f":"IF(ISERROR(I59/H59),0,(I59/H59))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,(MIN($B$58,$L20)-MAX($B$57,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F60/365),0,(F60/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,M20)","v":0},{"$f":"(F60*$E$57)*H60","v":0},{"$f":"IF(ISERROR(I60/H60),0,(I60/H60))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,(MIN($B$58,$L21)-MAX($B$57,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F61/365),0,(F61/365))*12,0)","v":12},{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,M21)","v":0.53},{"$f":"(F61*$E$57)*H61","v":0},{"$f":"IF(ISERROR(I61/H61),0,(I61/H61))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D57:D61)","v":0},null,{"$f":"SUM(F57:F61)","v":365},{"$f":"SUM(G57:G61)","v":12},{"$f":"AVERAGEIF(H57:H61,\"<>0\")","v":0.53},{"$f":"SUM(I57:I61)","v":0},{"$f":"SUM(J57:J61)","v":0}]
[]
[]
["6th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B67=0),0,(B68-B67))/30,0)","v":0},0,{"$f":"IF(ISERROR(D67/F72),0,(D67/F72))","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,(MIN($B$68,$L17)-MAX($B$67,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F67/365),0,(F67/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,M17)","v":0},{"$f":"(F67*$E$67)*H67","v":0},{"$f":"IF(ISERROR(I67/H67),0,(I67/H67))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,(MIN($B$68,$L18)-MAX($B$67,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F68/365),0,(F68/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,M18)","v":0},{"$f":"(F68*$E$67)*H68","v":0},{"$f":"IF(ISERROR(I68/H68),0,(I68/H68))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,(MIN($B$68,$L19)-MAX($B$67,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F69/365),0,(F69/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,M19)","v":0},{"$f":"(F69*$E$67)*H69","v":0},{"$f":"IF(ISERROR(I69/H69),0,(I69/H69))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,(MIN($B$68,$L20)-MAX($B$67,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F70/365),0,(F70/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,M20)","v":0},{"$f":"(F70*$E$67)*H70","v":0},{"$f":"IF(ISERROR(I70/H70),0,(I70/H70))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,(MIN($B$68,$L21)-MAX($B$67,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F71/365),0,(F71/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,M21)","v":0},{"$f":"(F71*$E$67)*H71","v":0},{"$f":"IF(ISERROR(I71/H71),0,(I71/H71))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D67:D71)","v":0},null,{"$f":"SUM(F67:F71)","v":0},{"$f":"SUM(G67:G71)","v":0},{"$f":"AVERAGEIF(H67:H71,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I67:I71)","v":0},{"$f":"SUM(J67:J71)","v":0}]
[]
[]
["7th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B77=0),0,(B78-B77))/30,0)","v":0},0,{"$f":"IF(ISERROR(D77/F82),0,(D77/F82))","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,(MIN($B$78,$L17)-MAX($B$77,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F77/365),0,(F77/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,M17)","v":0},{"$f":"(F77*$E$77)*H77","v":0},{"$f":"IF(ISERROR(I77/H77),0,(I77/H77))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,(MIN($B$78,$L18)-MAX($B$77,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F78/365),0,(F78/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,M18)","v":0},{"$f":"(F78*$E$77)*H78","v":0},{"$f":"IF(ISERROR(I78/H78),0,(I78/H78))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,(MIN($B$78,$L19)-MAX($B$77,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F79/365),0,(F79/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,M19)","v":0},{"$f":"(F79*$E$77)*H79","v":0},{"$f":"IF(ISERROR(I79/H79),0,(I79/H79))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,(MIN($B$78,$L20)-MAX($B$77,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F80/365),0,(F80/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,M20)","v":0},{"$f":"(F80*$E$77)*H80","v":0},{"$f":"IF(ISERROR(I80/H80),0,(I80/H80))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,(MIN($B$78,$L21)-MAX($B$77,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F81/365),0,(F81/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,M21)","v":0},{"$f":"(F81*$E$77)*H81","v":0},{"$f":"IF(ISERROR(I81/H81),0,(I81/H81))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D77:D81)","v":0},null,{"$f":"SUM(F77:F81)","v":0},{"$f":"SUM(G77:G81)","v":0},{"$f":"AVERAGEIF(H77:H81,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I77:I81)","v":0},{"$f":"SUM(J77:J81)","v":0}]

{"sheet":"SPA USE ONLY","index":5,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Sponsor:",{"$f":"Summary!D3","v":"."}]
["Title: ",{"$f":"Summary!D4","v":0}]
["PI Name: ",{"$f":"Summary!D5","v":"."}]
["Period of Performance:",{"$f":"Summary!D6","v":"."}]
["Account Number:"]
[]
["Budget Categories","Budget Code","Amount"]
["Salary/Hourly","0108",{"$f":"ROUND(Summary!R39,0)","v":0}]
["Payroll Benefits","0130",{"$f":"ROUND(Summary!R41,0)","v":0}]
["Equipment","0710",{"$f":"ROUND(Summary!R66,0)","v":0}]
["Travel Domestic","0215",{"$f":"ROUND(Summary!R71+Summary!R76+Summary!R77,0)","v":0}]
["Travel Foreign","0216",{"$f":"ROUND(Summary!R72,0)","v":0}]
["Student Tuition","0610",{"$f":"ROUND(SUM(Summary!R91:R93),0)","v":0}]
["Supplies","0410",{"$f":"ROUND(Summary!R81,0)","v":0}]
["Subcontracts"]
["Subject to IDC","0396",{"$f":"ROUND(Summary!R87+Summary!R89,0)","v":0}]
["Not Subejct to IDC","0376",{"$f":"ROUND(Summary!R88+Summary!R90,0)","v":0}]
["Other Direct Costs"]
["Computer Usage","0353",{"$f":"ROUND(Summary!R84,0)","v":0}]
["Printing/Copying","0373",{"$f":"ROUND(Summary!R82,0)","v":0}]
["Services/Honoraria","0302",{"$f":"ROUND(Summary!R75+Summary!R83,0)","v":0}]
["Other  ","0630",{"$f":"ROUND(Summary!R85+Summary!R95+Summary!R96+Summary!R78+Summary!R86,0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C8:C22)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND(Summary!R104,0)","v":0}]
["Total Costs",null,{"$f":"SUM(C23:C24)","v":0}]