{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","F&A Calculation- Sponsor Funds ","F&A Calculations - Cost Share","Tuition","SPA USE ONLY"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":63,"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":134,"n_cols":21,"rows_kept":134,"cut":false,"hidden":false,"merged":[[117,2,117,17],[70,3,70,6],[71,3,71,6],[74,3,74,6],[115,2,115,17],[75,3,75,6],[76,3,76,6],[104,4,104,6],[2,4,2,5],[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/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 7/02/2018"]
["Program Sponsor",null,null,null,"Enter Start Date: ",null,"2018-07-01",null,"Start Date must be entered for each budget"]
["Title",null,null,null,"Enter other rate (if needed): ",null,0,null,"This budget is completely adjustable.  You will need to double check your work and make adjustments in certain cells, such as:",null,null,null,null,null,null,null,null,null,null,null,"Negotiated Rate"]
["PI",null,null,null,"Select calculation type: ",null,"Negotiated Rate",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,null,null,null,null,null,null,null,null,null,"Other TDC"]
["Period of Performance",null,null,null,null,null,null,null,"Indirect costs- Budget defaults to caculate on 52% MTDC and 53% MTDC, with precise rate in on \"F&A Calculations\" sheet. ",null,null,null,null,null,null,null,null,null,null,null,"Other MTDC"]
["Deadline",null,null,null,null,null,null,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":"2018-07-01"},{"$f":"J11-1","v":"2019-06-30"},{"$f":"DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))","v":"2019-07-01"},{"$f":"L11-1","v":"2020-06-30"},{"$f":"DATE(YEAR(G3)+2,MONTH(G3),DAY(G3))","v":"2020-07-01"},{"$f":"N11-1","v":"2021-06-30"},{"$f":"DATE(YEAR(G3)+3,MONTH(G3),DAY(G3))","v":"2021-07-01"},{"$f":"P11-1","v":"2022-06-30"},{"$f":"DATE(YEAR(G3)+4,MONTH(G3),DAY(G3))","v":"2022-07-01"},{"$f":"P11+364","v":"2023-06-30"}]
[null,null,null,null,null,null,null,"Federal Funds Requested","Cost-Shared  Matching Funds","Federal Funds Requested","Cost-Shared  Matching Funds","Federal Funds Requested","Cost-Shared  Matching Funds","Federal Funds Requested","Cost-Shared  Matching Funds","Federal 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.33,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.33,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",7.8E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",7.8E-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.438,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.438,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.16800000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.16800000000000001,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:H97)","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,null,"Tuition-Experiential Learning Majors",null,"(Click on \"Tuition\" sheet)",null,null,{"$f":"Tuition!K88","v":0},null,{"$f":"Tuition!M88","v":0},null,{"$f":"Tuition!O88","v":0},null,{"$f":"Tuition!Q88","v":0},null,{"$f":"Tuition!S88","v":0},null,{"$f":"H95+J95+L95+N95+P95","v":0},{"$f":"SUM(I95+K95+M95+O95+Q95)","v":0},{"$f":"SUM(R95+S95)","v":0}]
[null,9,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H96+J96+L96+N96+P96)","v":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},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H99+J99+L99+N99+P99)","v":0},{"$f":"SUM(I99+K99+M99+O99+Q99)","v":0},{"$f":"SUM(R99+S99)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H99-H66-H74-H86-H88-H90-H91-H92-H93-H94-H95)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H101+J101+L101+N101+P101)","v":0},{"$f":"SUM(I101+K101+M101+O101+Q101)","v":0},{"$f":"SUM(R101+S101)","v":0}]
[null,null,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H105:H105)","v":0},0,0,0,0,0,0,0,0,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}]
[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,H99*G4,G4*H101))","v":0},{"$f":"IF(G5=U4,'F&A Calculations - Cost Share'!I22,IF(G5=U5,I99*G4,G4*I101))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I32,IF(G5=U5,J99*G4,G4*J101))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I32,IF(G5=U5,K99*G4,G4*K101))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I42,IF(G5=U5,L99*G4,G4*L101))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I42,IF(G5=U5,M99*G4,G4*M101))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I52,IF(G5=U5,N99*G4,G4*N101))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I52,IF(G5=U5,O99*G4,G4*O101))","v":0},{"$f":"IF(G5=U4,'F&A Calculation- Sponsor Funds '!I62,IF(G5=U5,P99*G4,G4*P101))","v":0},{"$f":"IF(G5=U4, 'F&A Calculations - Cost Share'!I62,IF(G5=U5,Q99*G4,G4*Q101))","v":0},{"$f":"SUM(H105+J105+L105+N105+P105)","v":0},{"$f":"SUM(I105+K105+M105+O105+Q105)","v":0},{"$f":"SUM(R105+S105)","v":0}]
[]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H99+H104","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H108+J108+L108+N108+P108)","v":0},{"$f":"SUM(I108+K108+M108+O108+Q108)","v":0},{"$f":"SUM(R108+S108)","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",7.8E-2,null,null,null,"52 or 53%","On-Campus Organized Research"]
[null,null,"D",0.33,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.438,null,null,null,0.26,"Off-Campus All Programs"]
[null,null,"XH (Student hourly)",6.0000000000000001E-3]
[null,null,"XH (Non-Student hourly)",0.16800000000000001]
[]
[null,null,"Post Doc Salary Range:"]
[null,null," "]
[null,null,"http://www.grad-college.iastate.edu/post_doc/policies.php"]

{"sheet":"F&A Calculation- Sponsor Funds ","index":1,"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":"2018-07-01"},{"$f":"ROUND(IF((B17=0),0,(B18-B17))/30,0)","v":12},{"$f":"Summary!H101","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":"2019-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":0},{"$f":"ROUND(IF(ISERROR(F18/365),0,(F18/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,M18)","v":0},{"$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":365},{"$f":"ROUND(IF(ISERROR(F19/365),0,(F19/365)*12),2)","v":12},{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,M19)","v":0.53},{"$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.53},{"$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":"2019-07-01"},{"$f":"ROUND(IF((B27=0),0,(B28-B27))/30,0)","v":12},{"$f":"Summary!J101","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":"2020-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":0},{"$f":"ROUND(IF(ISERROR(F29/365),0,(F29/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,M19)","v":0},{"$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":366},{"$f":"ROUND(IF(ISERROR(F30/365),0,(F30/365))*12,0)","v":12},{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,M20)","v":0.53},{"$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":366},{"$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":"2020-07-01"},{"$f":"ROUND(IF((B37=0),0,(B38-B37))/30,0)","v":12},{"$f":"Summary!L101","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":"2021-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":0},{"$f":"ROUND(IF(ISERROR(F40/365),0,(F40/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,M20)","v":0},{"$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":365},{"$f":"ROUND(IF(ISERROR(F41/365),0,(F41/365))*12,0)","v":12},{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,M21)","v":0.53},{"$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":365},{"$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":"2021-07-01"},{"$f":"ROUND(IF((B47=0),0,(B48-B47))/30,0)","v":12},{"$f":"Summary!N101","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":"2022-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":"2022-07-01"},{"$f":"ROUND(IF((B57=0),0,(B58-B57))/30,0)","v":12},{"$f":"Summary!P101","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":"2023-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":2,"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":"2018-07-01"},{"$f":"ROUND(IF((B17=0),0,(B18-B17))/30,0)","v":12},{"$f":"Summary!I101","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":"2019-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":0},{"$f":"ROUND(IF(ISERROR(F18/365),0,(F18/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,M18)","v":0},{"$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":365},{"$f":"ROUND(IF(ISERROR(F19/365),0,(F19/365)*12),2)","v":12},{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,M19)","v":0.53},{"$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.53},{"$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":"2019-07-01"},{"$f":"ROUND(IF((B27=0),0,(B28-B27))/30,0)","v":12},{"$f":"Summary!K101","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":"2020-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":0},{"$f":"ROUND(IF(ISERROR(F29/365),0,(F29/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,M19)","v":0},{"$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":366},{"$f":"ROUND(IF(ISERROR(F30/365),0,(F30/365))*12,0)","v":12},{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,M20)","v":0.53},{"$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":366},{"$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":"2020-07-01"},{"$f":"ROUND(IF((B37=0),0,(B38-B37))/30,0)","v":12},{"$f":"Summary!M101","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":"2021-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":0},{"$f":"ROUND(IF(ISERROR(F40/365),0,(F40/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,M20)","v":0},{"$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":365},{"$f":"ROUND(IF(ISERROR(F41/365),0,(F41/365))*12,0)","v":12},{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,M21)","v":0.53},{"$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":365},{"$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":"2021-07-01"},{"$f":"ROUND(IF((B47=0),0,(B48-B47))/30,0)","v":12},{"$f":"Summary!O101","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":"2022-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":"2022-07-01"},{"$f":"ROUND(IF((B57=0),0,(B58-B57))/30,0)","v":12},{"$f":"Summary!Q101","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":"2023-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":"Tuition","index":3,"n_rows":286,"n_cols":19,"rows_kept":286,"cut":false,"hidden":false,"merged":[[100,0,104,0],[100,2,100,3],[102,2,102,3],[104,2,104,3],[87,2,87,5],[88,2,88,5],[89,2,89,5],[92,2,92,7],[94,0,98,0],[94,2,94,3],[96,2,96,3],[98,2,98,3],[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$111:$Q$137,5,FALSE)+C15*VLOOKUP(K15,$I$111:$Q$137,5,FALSE)+C17*VLOOKUP(K17,$I$111:$Q$137,5,FALSE)+C19*VLOOKUP(K19,$I$111:$Q$137,9,FALSE)+C21*VLOOKUP(K21,$I$111:$Q$137,9,FALSE)+C23*VLOOKUP(K23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$111:$Q$137,5,FALSE)+E15*VLOOKUP(M15,$I$111:$Q$137,5,FALSE)+E17*VLOOKUP(M17,$I$111:$Q$137,5,FALSE)+E19*VLOOKUP(M19,$I$111:$Q$137,9,FALSE)+E21*VLOOKUP(M21,$I$111:$Q$137,9,FALSE)+E23*VLOOKUP(M23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$111:$Q$137,5,FALSE)+F15*VLOOKUP(O15,$I$111:$Q$137,5,FALSE)+F17*VLOOKUP(O17,$I$111:$Q$137,5,FALSE)+F19*VLOOKUP(O19,$I$111:$Q$137,9,FALSE)+F21*VLOOKUP(O21,$I$111:$Q$137,9,FALSE)+F23*VLOOKUP(O23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$111:$Q$137,5,FALSE)+G15*VLOOKUP(Q15,$I$111:$Q$137,5,FALSE)+G17*VLOOKUP(Q17,$I$111:$Q$137,5,FALSE)+G19*VLOOKUP(Q19,$I$111:$Q$137,9,FALSE)+G21*VLOOKUP(Q21,$I$111:$Q$137,9,FALSE)+G23*VLOOKUP(Q23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$111:$Q$137,5,FALSE)+H15*VLOOKUP(S15,$I$111:$Q$137,5,FALSE)+H17*VLOOKUP(S17,$I$111:$Q$137,5,FALSE)+H19*VLOOKUP(S19,$I$111:$Q$137,9,FALSE)+H21*VLOOKUP(S21,$I$111:$Q$137,9,FALSE)+H23*VLOOKUP(S23,$I$111:$Q$137,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$111:$Q$137,3,FALSE)+C15*VLOOKUP(K15,$I$111:$Q$137,3,FALSE)+C17*VLOOKUP(K17,$I$111:$Q$137,3,FALSE)+C19*VLOOKUP(K19,$I$111:$Q$137,7,FALSE)+C21*VLOOKUP(K21,$I$111:$Q$137,7,FALSE)+C23*VLOOKUP(K23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$111:$Q$137,3,FALSE)+E15*VLOOKUP(M15,$I$111:$Q$137,3,FALSE)+E17*VLOOKUP(M17,$I$111:$Q$137,3,FALSE)+E19*VLOOKUP(M19,$I$111:$Q$137,7,FALSE)+E21*VLOOKUP(M21,$I$111:$Q$137,7,FALSE)+E23*VLOOKUP(M23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$111:$Q$137,3,FALSE)+F15*VLOOKUP(O15,$I$111:$Q$137,3,FALSE)+F17*VLOOKUP(O17,$I$111:$Q$137,3,FALSE)+F19*VLOOKUP(O19,$I$111:$Q$137,7,FALSE)+F21*VLOOKUP(O21,$I$111:$Q$137,7,FALSE)+F23*VLOOKUP(O23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$111:$Q$137,3,FALSE)+G15*VLOOKUP(Q15,$I$111:$Q$137,3,FALSE)+G17*VLOOKUP(Q17,$I$111:$Q$137,3,FALSE)+G19*VLOOKUP(Q19,$I$111:$Q$137,7,FALSE)+G21*VLOOKUP(Q21,$I$111:$Q$137,7,FALSE)+G23*VLOOKUP(Q23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$111:$Q$137,3,FALSE)+H15*VLOOKUP(S15,$I$111:$Q$137,3,FALSE)+H17*VLOOKUP(S17,$I$111:$Q$137,3,FALSE)+H19*VLOOKUP(S19,$I$111:$Q$137,7,FALSE)+H21*VLOOKUP(S21,$I$111:$Q$137,7,FALSE)+H23*VLOOKUP(S23,$I$111:$Q$137,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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[]
[]
[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$141:$Q$167,5,FALSE)+C35*VLOOKUP(K35,$I$141:$Q$167,5,FALSE)+C37*VLOOKUP(K37,$I$141:$Q$167,5,FALSE)+C39*VLOOKUP(K39,$I$141:$Q$167,9,FALSE)+C41*VLOOKUP(K41,$I$141:$Q$167,9,FALSE)+C43*VLOOKUP(K43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$141:$Q$167,5,FALSE)+E35*VLOOKUP(M35,$I$141:$Q$167,5,FALSE)+E37*VLOOKUP(M37,$I$141:$Q$167,5,FALSE)+E39*VLOOKUP(M39,$I$141:$Q$167,9,FALSE)+E41*VLOOKUP(M41,$I$141:$Q$167,9,FALSE)+E43*VLOOKUP(M43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$141:$Q$167,5,FALSE)+F35*VLOOKUP(O35,$I$141:$Q$167,5,FALSE)+F37*VLOOKUP(O37,$I$141:$Q$167,5,FALSE)+F39*VLOOKUP(O39,$I$141:$Q$167,9,FALSE)+F41*VLOOKUP(O41,$I$141:$Q$167,9,FALSE)+F43*VLOOKUP(O43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$141:$Q$167,5,FALSE)+G35*VLOOKUP(Q35,$I$141:$Q$167,5,FALSE)+G37*VLOOKUP(Q37,$I$141:$Q$167,5,FALSE)+G39*VLOOKUP(Q39,$I$141:$Q$167,9,FALSE)+G41*VLOOKUP(Q41,$I$141:$Q$167,9,FALSE)+G43*VLOOKUP(Q43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$141:$Q$167,5,FALSE)+H35*VLOOKUP(S35,$I$141:$Q$167,5,FALSE)+H37*VLOOKUP(S37,$I$141:$Q$167,5,FALSE)+H39*VLOOKUP(S39,$I$141:$Q$167,9,FALSE)+H41*VLOOKUP(S41,$I$141:$Q$167,9,FALSE)+H43*VLOOKUP(S43,$I$141:$Q$167,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$141:$Q$167,3,FALSE)+C35*VLOOKUP(K35,$I$141:$Q$167,3,FALSE)+C37*VLOOKUP(K37,$I$141:$Q$167,3,FALSE)+C39*VLOOKUP(K39,$I$141:$Q$167,7,FALSE)+C41*VLOOKUP(K41,$I$141:$Q$167,7,FALSE)+C43*VLOOKUP(K43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$141:$Q$167,3,FALSE)+E35*VLOOKUP(M35,$I$141:$Q$167,3,FALSE)+E37*VLOOKUP(M37,$I$141:$Q$167,3,FALSE)+E39*VLOOKUP(M39,$I$141:$Q$167,7,FALSE)+E41*VLOOKUP(M41,$I$141:$Q$167,7,FALSE)+E43*VLOOKUP(M43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$141:$Q$167,3,FALSE)+F35*VLOOKUP(O35,$I$141:$Q$167,3,FALSE)+F37*VLOOKUP(O37,$I$141:$Q$167,3,FALSE)+F39*VLOOKUP(O39,$I$141:$Q$167,7,FALSE)+F41*VLOOKUP(O41,$I$141:$Q$167,7,FALSE)+F43*VLOOKUP(O43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$141:$Q$167,3,FALSE)+G35*VLOOKUP(Q35,$I$141:$Q$167,3,FALSE)+G37*VLOOKUP(Q37,$I$141:$Q$167,3,FALSE)+G39*VLOOKUP(Q39,$I$141:$Q$167,7,FALSE)+G41*VLOOKUP(Q41,$I$141:$Q$167,7,FALSE)+G43*VLOOKUP(Q43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$141:$Q$167,3,FALSE)+H35*VLOOKUP(S35,$I$141:$Q$167,3,FALSE)+H37*VLOOKUP(S37,$I$141:$Q$167,3,FALSE)+H39*VLOOKUP(S39,$I$141:$Q$167,7,FALSE)+H41*VLOOKUP(S41,$I$141:$Q$167,7,FALSE)+H43*VLOOKUP(S43,$I$141:$Q$167,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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022"]
[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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[]
[]
[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$171:$Q$197,5,FALSE)+C55*VLOOKUP(K55,$I$171:$Q$197,5,FALSE)+C57*VLOOKUP(K57,$I$171:$Q$197,5,FALSE)+C59*VLOOKUP(K59,$I$171:$Q$197,9,FALSE)+C61*VLOOKUP(K61,$I$171:$Q$197,9,FALSE)+C63*VLOOKUP(K63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$171:$Q$197,5,FALSE)+E55*VLOOKUP(M55,$I$171:$Q$197,5,FALSE)+E57*VLOOKUP(M57,$I$171:$Q$197,5,FALSE)+E59*VLOOKUP(M59,$I$171:$Q$197,9,FALSE)+E61*VLOOKUP(M61,$I$171:$Q$197,9,FALSE)+E63*VLOOKUP(M63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$171:$Q$197,5,FALSE)+F55*VLOOKUP(O55,$I$171:$Q$197,5,FALSE)+F57*VLOOKUP(O57,$I$171:$Q$197,5,FALSE)+F59*VLOOKUP(O59,$I$171:$Q$197,9,FALSE)+F61*VLOOKUP(O61,$I$171:$Q$197,9,FALSE)+F63*VLOOKUP(O63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$171:$Q$197,5,FALSE)+G55*VLOOKUP(Q55,$I$171:$Q$197,5,FALSE)+G57*VLOOKUP(Q57,$I$171:$Q$197,5,FALSE)+G59*VLOOKUP(Q59,$I$171:$Q$197,9,FALSE)+G61*VLOOKUP(Q61,$I$171:$Q$197,9,FALSE)+G63*VLOOKUP(Q63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$171:$Q$197,5,FALSE)+H55*VLOOKUP(S55,$I$171:$Q$197,5,FALSE)+H57*VLOOKUP(S57,$I$171:$Q$197,5,FALSE)+H59*VLOOKUP(S59,$I$171:$Q$197,9,FALSE)+H61*VLOOKUP(S61,$I$171:$Q$197,9,FALSE)+H63*VLOOKUP(S63,$I$171:$Q$197,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$171:$Q$197,3,FALSE)+C55*VLOOKUP(K55,$I$171:$Q$197,3,FALSE)+C57*VLOOKUP(K57,$I$171:$Q$197,3,FALSE)+C59*VLOOKUP(K59,$I$171:$Q$197,7,FALSE)+C61*VLOOKUP(K61,$I$171:$Q$197,7,FALSE)+C63*VLOOKUP(K63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$171:$Q$197,3,FALSE)+E55*VLOOKUP(M55,$I$171:$Q$197,3,FALSE)+E57*VLOOKUP(M57,$I$171:$Q$197,3,FALSE)+E59*VLOOKUP(M59,$I$171:$Q$197,7,FALSE)+E61*VLOOKUP(M61,$I$171:$Q$197,7,FALSE)+E63*VLOOKUP(M63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$171:$Q$197,3,FALSE)+F55*VLOOKUP(O55,$I$171:$Q$197,3,FALSE)+F57*VLOOKUP(O57,$I$171:$Q$197,3,FALSE)+F59*VLOOKUP(O59,$I$171:$Q$197,7,FALSE)+F61*VLOOKUP(O61,$I$171:$Q$197,7,FALSE)+F63*VLOOKUP(O63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$171:$Q$197,3,FALSE)+G55*VLOOKUP(Q55,$I$171:$Q$197,3,FALSE)+G57*VLOOKUP(Q57,$I$171:$Q$197,3,FALSE)+G59*VLOOKUP(Q59,$I$171:$Q$197,7,FALSE)+G61*VLOOKUP(Q61,$I$171:$Q$197,7,FALSE)+G63*VLOOKUP(Q63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$171:$Q$197,3,FALSE)+H55*VLOOKUP(S55,$I$171:$Q$197,3,FALSE)+H57*VLOOKUP(S57,$I$171:$Q$197,3,FALSE)+H59*VLOOKUP(S59,$I$171:$Q$197,7,FALSE)+H61*VLOOKUP(S61,$I$171:$Q$197,7,FALSE)+H63*VLOOKUP(S63,$I$171:$Q$197,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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[]
[]
[]
[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$201:$Q$227,5,FALSE)+C76*VLOOKUP(K76,$I$201:$Q$227,5,FALSE)+C78*VLOOKUP(K78,$I$201:$Q$227,5,FALSE)+C80*VLOOKUP(K80,$I$201:$Q$227,9,FALSE)+C82*VLOOKUP(K82,$I$201:$Q$227,9,FALSE)+C84*VLOOKUP(K84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$201:$Q$227,5,FALSE)+E76*VLOOKUP(M76,$I$201:$Q$227,5,FALSE)+E78*VLOOKUP(M78,$I$201:$Q$227,5,FALSE)+E80*VLOOKUP(M80,$I$201:$Q$227,9,FALSE)+E82*VLOOKUP(M82,$I$201:$Q$227,9,FALSE)+E84*VLOOKUP(M84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$201:$Q$227,5,FALSE)+F76*VLOOKUP(O76,$I$201:$Q$227,5,FALSE)+F78*VLOOKUP(O78,$I$201:$Q$227,5,FALSE)+F80*VLOOKUP(O80,$I$201:$Q$227,9,FALSE)+F82*VLOOKUP(O82,$I$201:$Q$227,9,FALSE)+F84*VLOOKUP(O84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$201:$Q$227,5,FALSE)+G76*VLOOKUP(Q76,$I$201:$Q$227,5,FALSE)+G78*VLOOKUP(Q78,$I$201:$Q$227,5,FALSE)+G80*VLOOKUP(Q80,$I$201:$Q$227,9,FALSE)+G82*VLOOKUP(Q82,$I$201:$Q$227,9,FALSE)+G84*VLOOKUP(Q84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$201:$Q$227,5,FALSE)+H76*VLOOKUP(S76,$I$201:$Q$227,5,FALSE)+H78*VLOOKUP(S78,$I$201:$Q$227,5,FALSE)+H80*VLOOKUP(S80,$I$201:$Q$227,9,FALSE)+H82*VLOOKUP(S82,$I$201:$Q$227,9,FALSE)+H84*VLOOKUP(S84,$I$201:$Q$227,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C74*VLOOKUP(K74,$I$201:$Q$227,3,FALSE)+C76*VLOOKUP(K76,$I$201:$Q$227,3,FALSE)+C78*VLOOKUP(K78,$I$201:$Q$227,3,FALSE)+C80*VLOOKUP(K80,$I$201:$Q$227,7,FALSE)+C82*VLOOKUP(K82,$I$201:$Q$227,7,FALSE)+C84*VLOOKUP(K84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$201:$Q$227,3,FALSE)+E76*VLOOKUP(M76,$I$201:$Q$227,3,FALSE)+E78*VLOOKUP(M78,$I$201:$Q$227,3,FALSE)+E80*VLOOKUP(M80,$I$201:$Q$227,7,FALSE)+E82*VLOOKUP(M82,$I$201:$Q$227,7,FALSE)+E84*VLOOKUP(M84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$201:$Q$227,3,FALSE)+F76*VLOOKUP(O76,$I$201:$Q$227,3,FALSE)+F78*VLOOKUP(O78,$I$201:$Q$227,3,FALSE)+F80*VLOOKUP(O80,$I$201:$Q$227,7,FALSE)+F82*VLOOKUP(O82,$I$201:$Q$227,7,FALSE)+F84*VLOOKUP(O84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$201:$Q$227,3,FALSE)+G76*VLOOKUP(Q76,$I$201:$Q$227,3,FALSE)+G78*VLOOKUP(Q78,$I$201:$Q$227,3,FALSE)+G80*VLOOKUP(Q80,$I$201:$Q$227,7,FALSE)+G82*VLOOKUP(Q82,$I$201:$Q$227,7,FALSE)+G84*VLOOKUP(Q84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$201:$Q$227,3,FALSE)+H76*VLOOKUP(S76,$I$201:$Q$227,3,FALSE)+H78*VLOOKUP(S78,$I$201:$Q$227,3,FALSE)+H80*VLOOKUP(S80,$I$201:$Q$227,7,FALSE)+H82*VLOOKUP(S82,$I$201:$Q$227,7,FALSE)+H84*VLOOKUP(S84,$I$201:$Q$227,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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
["*Animal Sci, Comp Sci, GDCB, Microbiology, Plant Path, BBMB, EEOB, Industrial Design, NREM"]
[]
[]
[8,null,"Graduate Student Tuition (Experiential Learning Based Majors)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I88=\"1/2-time\",K89,K90),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",M89,M90),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",O89,O90),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",Q89,Q90),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",S89,S90),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C95*VLOOKUP(K95,$I$231:$Q$257,5,FALSE)+C97*VLOOKUP(K97,$I$231:$Q$257,5,FALSE)+C99*VLOOKUP(K99,$I$231:$Q$257,5,FALSE)+C101*VLOOKUP(K101,$I$231:$Q$257,9,FALSE)+C103*VLOOKUP(K103,$I$231:$Q$257,9,FALSE)+C105*VLOOKUP(K105,$I$231:$Q$257,9,FALSE)","v":0},null,{"$f":"+E95*VLOOKUP(M95,$I$201:$Q$227,5,FALSE)+E97*VLOOKUP(M97,$I$201:$Q$227,5,FALSE)+E99*VLOOKUP(M99,$I$201:$Q$227,5,FALSE)+E101*VLOOKUP(M101,$I$201:$Q$227,9,FALSE)+E103*VLOOKUP(M103,$I$201:$Q$227,9,FALSE)+E105*VLOOKUP(M105,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+F95*VLOOKUP(O95,$I$201:$Q$227,5,FALSE)+F97*VLOOKUP(O97,$I$201:$Q$227,5,FALSE)+F99*VLOOKUP(O99,$I$201:$Q$227,5,FALSE)+F101*VLOOKUP(O101,$I$201:$Q$227,9,FALSE)+F103*VLOOKUP(O103,$I$201:$Q$227,9,FALSE)+F105*VLOOKUP(O105,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+G95*VLOOKUP(Q95,$I$201:$Q$227,5,FALSE)+G97*VLOOKUP(Q97,$I$201:$Q$227,5,FALSE)+G99*VLOOKUP(Q99,$I$201:$Q$227,5,FALSE)+G101*VLOOKUP(Q101,$I$201:$Q$227,9,FALSE)+G103*VLOOKUP(Q103,$I$201:$Q$227,9,FALSE)+G105*VLOOKUP(Q105,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+H95*VLOOKUP(S95,$I$201:$Q$227,5,FALSE)+H97*VLOOKUP(S97,$I$201:$Q$227,5,FALSE)+H99*VLOOKUP(S99,$I$201:$Q$227,5,FALSE)+H101*VLOOKUP(S101,$I$201:$Q$227,9,FALSE)+H103*VLOOKUP(S103,$I$201:$Q$227,9,FALSE)+H105*VLOOKUP(S105,$I$201:$Q$227,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C95*VLOOKUP(K95,$I$231:$Q$257,3,FALSE)+C97*VLOOKUP(K97,$I$231:$Q$257,3,FALSE)+C99*VLOOKUP(K99,$I$231:$Q$257,3,FALSE)+C101*VLOOKUP(K101,$I$231:$Q$257,7,FALSE)+C103*VLOOKUP(K103,$I$231:$Q$257,7,FALSE)+C105*VLOOKUP(K105,$I$231:$Q$257,7,FALSE)","v":0},null,{"$f":"+E95*VLOOKUP(M95,$I$201:$Q$227,3,FALSE)+E97*VLOOKUP(M97,$I$201:$Q$227,3,FALSE)+E99*VLOOKUP(M99,$I$201:$Q$227,3,FALSE)+E101*VLOOKUP(M101,$I$201:$Q$227,7,FALSE)+E103*VLOOKUP(M103,$I$201:$Q$227,7,FALSE)+E105*VLOOKUP(M105,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+F95*VLOOKUP(O95,$I$201:$Q$227,3,FALSE)+F97*VLOOKUP(O97,$I$201:$Q$227,3,FALSE)+F99*VLOOKUP(O99,$I$201:$Q$227,3,FALSE)+F101*VLOOKUP(O101,$I$201:$Q$227,7,FALSE)+F103*VLOOKUP(O103,$I$201:$Q$227,7,FALSE)+F105*VLOOKUP(O105,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+G95*VLOOKUP(Q95,$I$201:$Q$227,3,FALSE)+G97*VLOOKUP(Q97,$I$201:$Q$227,3,FALSE)+G99*VLOOKUP(Q99,$I$201:$Q$227,3,FALSE)+G101*VLOOKUP(Q101,$I$201:$Q$227,7,FALSE)+G103*VLOOKUP(Q103,$I$201:$Q$227,7,FALSE)+G105*VLOOKUP(Q105,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+H95*VLOOKUP(S95,$I$201:$Q$227,3,FALSE)+H97*VLOOKUP(S97,$I$201:$Q$227,3,FALSE)+H99*VLOOKUP(S99,$I$201:$Q$227,3,FALSE)+H101*VLOOKUP(S101,$I$201:$Q$227,7,FALSE)+H103*VLOOKUP(S103,$I$201:$Q$227,7,FALSE)+H105*VLOOKUP(S105,$I$201:$Q$227,7,FALSE)","v":0}]
[]
[]
[null,null,"Experiential Learning Based 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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[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 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021",null,"Summer 2022"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021",null,"Fall 2022"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021",null,"Spring 2022",null,"Spring 2023"]
[]
["g",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.04]
[null,null,null,null,null,null,null,null,"Most Majors ",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 2018",null,{"$f":"$Q$111/4","v":1162.75},null,{"$f":"$O$111","v":2325.5},null,{"$f":"$Q$111/2","v":2325.5},null,4651]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K111*$S$108","v":1209.26},null,{"$f":"M111*$S$108","v":2418.52},null,{"$f":"$Q$112/2","v":2418.52},null,{"$f":"Q111*$S$108","v":4837.04}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,{"$f":"K112*$S$108","v":1257.6304},null,{"$f":"M112*$S$108","v":2515.2608},null,2515.2608,null,5030.5216]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1307.935616,null,2615.871232,null,2615.871232,null,{"$f":"Q113*$S$108","v":5231.7424639999999}]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1360.2530406400001,null,2720.5060812800002,null,2720.5060812800002,null,{"$f":"Q114*$S$108","v":5441.0121625600004}]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1414.6631622656002,null,2829.3263245312005,null,2829.3263245312005,null,{"$f":"Q115*$S$108","v":5658.652649062401}]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1471.2496887562243,null,2942.4993775124485,null,2942.4993775124485,null,{"$f":"Q116*$S$108","v":5884.998755024897}]
[null,null,null,null,null,null,null,null,"Fall 2025",null,1530.0996763064734,null,3060.1993526129468,null,3060.1993526129468,null,6120.3987052258935]
[]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"$Q$120/4","v":1162.75},null,{"$f":"$Q$120/2","v":2325.5},null,{"$f":"$Q$120/2","v":2325.5},null,4651]
[null,null,null,null,null,null,null,null,"Spring 2020",null,{"$f":"M121/2","v":1209.26},null,{"$f":"O121","v":2418.52},null,{"$f":"Q121/2","v":2418.52},null,{"$f":"Q120*$S$108","v":4837.04}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,{"$f":"K121*$S$108","v":1257.6304},null,{"$f":"M121*$S$108","v":2515.2608},null,{"$f":"O121*$S$108","v":2515.2608},null,{"$f":"Q121*$S$108","v":5030.5216}]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1307.935616,null,2615.871232,null,2615.871232,null,{"$f":"Q122*$S$108","v":5231.7424639999999}]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1360.2530406400001,null,2720.5060812800002,null,2720.5060812800002,null,5441.0121625600004]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1414.6631622656002,null,2829.3263245312005,null,2829.3263245312005,null,5658.652649062401]
[null,null,null,null,null,null,null,null,"Spring 2025",null,1471.2496887562243,null,2942.4993775124485,null,2942.4993775124485,null,5884.998755024897]
[null,null,null,null,null,null,null,null,"Spring 2026",null,1530.0996763064734,null,3060.1993526129468,null,3060.1993526129468,null,6120.3987052258935]
[]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"$Q$129/4","v":621.25},null,{"$f":"$Q$129/2","v":1242.5},null,{"$f":"$Q$129/2","v":1242.5},null,2485]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K129*$S$108","v":646.1},null,{"$f":"M129*$S$108","v":1292.2},null,{"$f":"O129*$S$108","v":1292.2},null,{"$f":"Q129*$S$108","v":2584.4}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,{"$f":"K130*$S$108","v":671.94400000000007},null,{"$f":"M130*$S$108","v":1343.8880000000001},null,{"$f":"O130*$S$108","v":1343.8880000000001},null,{"$f":"Q130*$S$108","v":2687.7760000000003}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,698.82176000000015,null,1397.6435200000003,null,1397.6435200000003,null,2795.2870400000006]
[null,null,null,null,null,null,null,null,"Summer 2022",null,726.77463040000021,null,1453.5492608000004,null,1453.5492608000004,null,2907.0985216000008]
[null,null,null,null,null,null,null,null,"Summer 2023",null,755.84561561600026,null,1511.6912312320005,null,1511.6912312320005,null,3023.382462464001]
[null,null,null,null,null,null,null,null,"Summer 2024",null,786.07944024064034,null,1572.1588804812807,null,1572.1588804812807,null,3144.3177609625614]
[null,null,null,null,null,null,null,null,"Summer 2025",null,817.52261785026599,null,{"$f":"M135*$S$108","v":1635.045235700532},null,1635.045235700532,null,3270.090471401064]
[]
[null,null,null,null,null,null,null,null,"Engineering "]
[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 2018",null,{"$f":"$Q$141/4","v":1409.5},null,{"$f":"$O$141","v":2819},null,{"$f":"$Q$141/2","v":2819},null,5638]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K141*$S$108","v":1465.88},null,{"$f":"M141*$S$108","v":2931.76},null,{"$f":"O141*$S$108","v":2931.76},null,{"$f":"Q141*$S$108","v":5863.52}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,{"$f":"K142*$S$108","v":1524.5152000000003},null,{"$f":"M142*$S$108","v":3049.0304000000006},null,{"$f":"O142*$S$108","v":3049.0304000000006},null,6098.0608000000011]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1585.4958080000004,null,3170.9916160000007,null,3170.9916160000007,null,6341.9832320000014]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1648.9156403200004,null,3297.8312806400008,null,3297.8312806400008,null,6595.6625612800017]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1714.8722659328005,null,3429.7445318656009,null,3429.7445318656009,null,6859.4890637312019]
[null,null,null,null,null,null,null,null,"Fall 2024",null,{"$f":"K146*$S$108","v":1783.4671565701126},null,3566.9343131402252,null,3566.9343131402252,null,7133.8686262804504]
[null,null,null,null,null,null,null,null,"Fall 2025",null,1854.8058428329171,null,3709.6116856658341,null,3709.6116856658341,null,7419.2233713316682]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"$Q$150/4","v":1409.5},null,{"$f":"$O$150","v":2819},null,{"$f":"$Q$150/2","v":2819},null,5638]
[null,null,null,null,null,null,null,null,"Spring 2020",null,{"$f":"$M$151/2","v":1465.88},null,{"$f":"O151","v":2931.76},null,{"$f":"Q151/2","v":2931.76},null,{"$f":"$Q$150*$S$108","v":5863.52}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,{"$f":"K151*$S$108","v":1524.5152000000003},null,{"$f":"M151*$S$108","v":3049.0304000000006},null,{"$f":"O151*$S$108","v":3049.0304000000006},null,{"$f":"$Q$151*$S$108","v":6098.0608000000011}]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1585.4958080000004,null,3170.9916160000007,null,{"$f":"O152*$S$108","v":3170.9916160000007},null,{"$f":"$Q$152*$S$108","v":6341.9832320000014}]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1648.9156403200004,null,3297.8312806400008,null,{"$f":"O153*$S$108","v":3297.8312806400008},null,{"$f":"$Q$153*$S$108","v":6595.6625612800017}]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1714.8722659328005,null,3429.7445318656009,null,{"$f":"O154*$S$108","v":3429.7445318656009},null,{"$f":"$Q$154*$S$108","v":6859.4890637312019}]
[null,null,null,null,null,null,null,null,"Spring 2025",null,1783.4671565701126,null,3566.9343131402252,null,{"$f":"O155*$S$108","v":3566.9343131402252},null,{"$f":"$Q$155*$S$108","v":7133.8686262804504}]
[null,null,null,null,null,null,null,null,"Spring 2026",null,1854.8058428329171,null,3709.6116856658341,null,{"$f":"$O$156*$S$108","v":3709.6116856658341},null,{"$f":"$Q$156*$S$108","v":7419.2233713316682}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"$Q$159/4","v":715},null,{"$f":"$Q$159/2","v":1430},null,{"$f":"$Q$159/2","v":1430},null,2860]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K159*$S$108","v":743.6},null,{"$f":"M159*$S$108","v":1487.2},null,{"$f":"O159*$S$108","v":1487.2},null,{"$f":"Q159*$S$108","v":2974.4}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,{"$f":"K160*$S$108","v":773.34400000000005},null,{"$f":"M160*$S$108","v":1546.6880000000001},null,{"$f":"O160*$S$108","v":1546.6880000000001},null,{"$f":"Q160*$S$108","v":3093.3760000000002}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,804.27776000000006,null,1608.5555200000001,null,1608.5555200000001,null,3217.1110400000002]
[null,null,null,null,null,null,null,null,"Summer 2022",null,836.44887040000003,null,1672.8977408000001,null,1672.8977408000001,null,3345.7954816000001]
[null,null,null,null,null,null,null,null,"Summer 2023",null,869.90682521600002,null,1739.813650432,null,1739.813650432,null,3479.6273008640001]
[null,null,null,null,null,null,null,null,"Summer 2024",null,904.70309822464003,null,1809.4061964492801,null,1809.4061964492801,null,3618.8123928985601]
[null,null,null,null,null,null,null,null,"Summer 2025",null,940.89122215362568,null,1881.7824443072514,null,1881.7824443072514,null,3763.5648886145027]
[]
[null,null,null,null,null,null,null,null,"Business & Seed Technology"]
[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 2018",null,{"$f":"Q171/4","v":1442.75},null,{"$f":"Q171/2","v":2885.5},null,{"$f":"Q171/2","v":2885.5},null,5771]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K171*$S$108","v":1500.46},null,{"$f":"M171*$S$108","v":3000.92},null,{"$f":"O171*$S$108","v":3000.92},null,{"$f":"Q171*$S$108","v":6001.84}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,{"$f":"K172*$S$108","v":1560.4784000000002},null,{"$f":"M172*$S$108","v":3120.9568000000004},null,{"$f":"O172*$S$108","v":3120.9568000000004},null,{"$f":"Q172*$S$108","v":6241.9136000000008}]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1622.8975360000002,null,3245.7950720000003,null,3245.7950720000003,null,6491.5901440000007]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1687.8134374400001,null,3375.6268748800003,null,3375.6268748800003,null,6751.2537497600006]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1755.3259749376002,null,3510.6519498752004,null,3510.6519498752004,null,7021.3038997504009]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1825.5390139351043,null,3651.0780278702086,null,3651.0780278702086,null,7302.1560557404173]
[null,null,null,null,null,null,null,null,"Fall 2025",null,1898.5605744925085,null,3797.121148985017,null,3797.121148985017,null,7594.2422979700341]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"Q180/4","v":1442.75},null,{"$f":"Q180/2","v":2885.5},null,{"$f":"Q180/2","v":2885.5},null,5771]
[null,null,null,null,null,null,null,null,"Spring 2020",null,{"$f":"M181/2","v":1500.46},null,{"$f":"O181","v":3000.92},null,{"$f":"Q181/2","v":3000.92},null,{"$f":"Q180*$S$108","v":6001.84}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,{"$f":"K181*$S$108","v":1560.4784000000002},null,{"$f":"M181*$S$108","v":3120.9568000000004},null,{"$f":"O181*$S$108","v":3120.9568000000004},null,{"$f":"Q181*$S$108","v":6241.9136000000008}]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1622.8975360000002,null,3245.7950720000003,null,3245.7950720000003,null,{"$f":"Q182*$S$108","v":6491.5901440000007}]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1687.8134374400001,null,3375.6268748800003,null,3375.6268748800003,null,6751.2537497600006]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1755.3259749376002,null,3510.6519498752004,null,3510.6519498752004,null,7021.3038997504009]
[null,null,null,null,null,null,null,null,"Spring 2025",null,1825.5390139351043,null,3651.0780278702086,null,3651.0780278702086,null,7302.1560557404173]
[null,null,null,null,null,null,null,null,"Spring 2026",null,1898.5605744925085,null,3797.121148985017,null,3797.121148985017,null,7594.2422979700341]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"Q189/4","v":751.25},null,{"$f":"Q189/2","v":1502.5},null,{"$f":"Q189/2","v":1502.5},null,3005]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K189*$S$108","v":781.30000000000007},null,{"$f":"M189*$S$108","v":1562.6000000000001},null,{"$f":"O189*$S$108","v":1562.6000000000001},null,{"$f":"Q189*$S$108","v":3125.2000000000003}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,{"$f":"K190*$S$108","v":812.55200000000013},null,{"$f":"M190*$S$108","v":1625.1040000000003},null,{"$f":"O190*$S$108","v":1625.1040000000003},null,{"$f":"Q190*$S$108","v":3250.2080000000005}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,845.05408000000011,null,1690.1081600000002,null,1690.1081600000002,null,3380.2163200000005]
[null,null,null,null,null,null,null,null,"Summer 2022",null,878.85624320000011,null,1757.7124864000002,null,1757.7124864000002,null,3515.4249728000004]
[null,null,null,null,null,null,null,null,"Summer 2023",null,914.01049292800019,null,1828.0209858560004,null,1828.0209858560004,null,3656.0419717120008]
[null,null,null,null,null,null,null,null,"Summer 2024",null,950.57091264512019,null,1901.1418252902404,null,1901.1418252902404,null,3802.2836505804808]
[null,null,null,null,null,null,null,null,"Summer 2025",null,988.59374915092508,null,1977.1874983018502,null,1977.1874983018502,null,3954.3749966037003]
[]
[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 2018",null,{"$f":"Q201/4","v":1286.25},null,{"$f":"Q201/2","v":2572.5},null,{"$f":"Q201/2","v":2572.5},null,5145]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K201*$S$108","v":1337.7},null,{"$f":"M201*$S$108","v":2675.4},null,{"$f":"O201*$S$108","v":2675.4},null,{"$f":"Q201*$S$108","v":5350.8}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,{"$f":"K202*$S$108","v":1391.2080000000001},null,{"$f":"M202*$S$108","v":2782.4160000000002},null,{"$f":"O202*$S$108","v":2782.4160000000002},null,{"$f":"Q202*$S$108","v":5564.8320000000003}]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1446.8563200000001,null,2893.7126400000002,null,2893.7126400000002,null,5787.4252800000004]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1504.7305728000001,null,3009.4611456000002,null,3009.4611456000002,null,6018.9222912000005]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1564.9197957120002,null,3129.8395914240004,null,3129.8395914240004,null,6259.6791828480009]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1627.5165875404803,null,3255.0331750809605,null,3255.0331750809605,null,6510.066350161921]
[null,null,null,null,null,null,null,null,"Fall 2025",null,1692.6172510420995,null,3385.234502084199,null,3385.234502084199,null,6770.469004168398]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"Q210/4","v":1286.25},null,{"$f":"Q210/2","v":2572.5},null,{"$f":"Q210/2","v":2572.5},null,5145]
[null,null,null,null,null,null,null,null,"Spring 2020",null,{"$f":"M211/2","v":1337.7},null,{"$f":"O211","v":2675.4},null,{"$f":"Q211/2","v":2675.4},null,{"$f":"Q210*$S$108","v":5350.8}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,{"$f":"K211*$S$108","v":1391.2080000000001},null,{"$f":"M211*$S$108","v":2782.4160000000002},null,{"$f":"O211*$S$108","v":2782.4160000000002},null,{"$f":"Q211*$S$108","v":5564.8320000000003}]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1446.8563200000001,null,2893.7126400000002,null,2893.7126400000002,null,{"$f":"Q212*$S$108","v":5787.4252800000004}]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1504.7305728000001,null,3009.4611456000002,null,3009.4611456000002,null,6018.9222912000005]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1564.9197957120002,null,3129.8395914240004,null,3129.8395914240004,null,6259.6791828480009]
[null,null,null,null,null,null,null,null,"Spring 2025",null,1627.5165875404803,null,3255.0331750809605,null,3255.0331750809605,null,6510.066350161921]
[null,null,null,null,null,null,null,null,"Spring 2026",null,1692.6172510420995,null,3385.234502084199,null,3385.234502084199,null,6770.469004168398]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"Q219/4","v":647.5},null,{"$f":"Q219/2","v":1295},null,{"$f":"Q219/2","v":1295},null,2590]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K219*$S$108","v":673.4},null,{"$f":"M219*$S$108","v":1346.8},null,{"$f":"O219*$S$108","v":1346.8},null,{"$f":"Q219*$S$108","v":2693.6}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,{"$f":"K220*$S$108","v":700.33600000000001},null,{"$f":"M220*$S$108","v":1400.672},null,{"$f":"O220*$S$108","v":1400.672},null,{"$f":"Q220*$S$108","v":2801.3440000000001}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,728.34944000000007,null,1456.6988800000001,null,1456.6988800000001,null,2913.3977600000003]
[null,null,null,null,null,null,null,null,"Summer 2022",null,757.48341760000005,null,1514.9668352000001,null,1514.9668352000001,null,3029.9336704000002]
[null,null,null,null,null,null,null,null,"Summer 2023",null,787.78275430400004,null,1575.5655086080001,null,1575.5655086080001,null,3151.1310172160001]
[null,null,null,null,null,null,null,null,"Summer 2024",null,819.29406447616009,null,1638.5881289523202,null,1638.5881289523202,null,3277.1762579046404]
[null,null,null,null,null,null,null,null,"Summer 2025",null,852.06582705520657,null,1704.1316541104131,null,1704.1316541104131,null,3408.2633082208263]
[]
[null,null,null,null,null,null,null,null,"Experiential Learning Based Majors"]
[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 2018",null,{"$f":"Q231/4","v":1229.5},null,{"$f":"Q231/2","v":2459},null,{"$f":"Q231/2","v":2459},null,4918]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K231*$S$108","v":1278.68},null,{"$f":"M231*$S$108","v":2557.36},null,{"$f":"O231*$S$108","v":2557.36},null,{"$f":"Q231*$S$108","v":5114.72}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,{"$f":"K232*$S$108","v":1329.8272000000002},null,{"$f":"M232*$S$108","v":2659.6544000000004},null,{"$f":"O232*$S$108","v":2659.6544000000004},null,{"$f":"Q232*$S$108","v":5319.3088000000007}]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1383.0202880000002,null,2766.0405760000003,null,2766.0405760000003,null,5532.0811520000007]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1438.3410995200002,null,2876.6821990400003,null,2876.6821990400003,null,5753.3643980800007]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1495.8747435008002,null,2991.7494870016003,null,2991.7494870016003,null,5983.4989740032006]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1555.7097332408323,null,3111.4194664816646,null,3111.4194664816646,null,6222.8389329633292]
[null,null,null,null,null,null,null,null,"Fall 2025",null,1617.9381225704656,null,3235.8762451409311,null,3235.8762451409311,null,6471.7524902818623]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"Q240/4","v":1229.5},null,{"$f":"Q240/2","v":2459},null,{"$f":"Q240/2","v":2459},null,4918]
[null,null,null,null,null,null,null,null,"Spring 2020",null,{"$f":"M241/2","v":1278.68},null,{"$f":"O241","v":2557.36},null,{"$f":"Q241/2","v":2557.36},null,{"$f":"Q240*$S$108","v":5114.72}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,{"$f":"K241*$S$108","v":1329.8272000000002},null,{"$f":"M241*$S$108","v":2659.6544000000004},null,{"$f":"O241*$S$108","v":2659.6544000000004},null,{"$f":"Q241*$S$108","v":5319.3088000000007}]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1383.0202880000002,null,2766.0405760000003,null,2766.0405760000003,null,{"$f":"Q242*$S$108","v":5532.0811520000007}]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1438.3410995200002,null,2876.6821990400003,null,2876.6821990400003,null,5753.3643980800007]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1495.8747435008002,null,2991.7494870016003,null,2991.7494870016003,null,5983.4989740032006]
[null,null,null,null,null,null,null,null,"Spring 2025",null,1555.7097332408323,null,3111.4194664816646,null,3111.4194664816646,null,6222.8389329633292]
[null,null,null,null,null,null,null,null,"Spring 2026",null,1617.9381225704656,null,3235.8762451409311,null,3235.8762451409311,null,6471.7524902818623]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"Q249/4","v":683.75},null,{"$f":"Q249/2","v":1367.5},null,{"$f":"Q249/2","v":1367.5},null,2735]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K249*$S$108","v":711.1},null,{"$f":"M249*$S$108","v":1422.2},null,{"$f":"O249*$S$108","v":1422.2},null,{"$f":"Q249*$S$108","v":2844.4}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,{"$f":"K250*$S$108","v":739.5440000000001},null,{"$f":"M250*$S$108","v":1479.0880000000002},null,{"$f":"O250*$S$108","v":1479.0880000000002},null,{"$f":"Q250*$S$108","v":2958.1760000000004}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,769.12576000000013,null,1538.2515200000003,null,1538.2515200000003,null,3076.5030400000005]
[null,null,null,null,null,null,null,null,"Summer 2022",null,799.89079040000013,null,1599.7815808000003,null,1599.7815808000003,null,3199.5631616000005]
[null,null,null,null,null,null,null,null,"Summer 2023",null,831.88642201600021,null,1663.7728440320004,null,1663.7728440320004,null,3327.5456880640008]
[null,null,null,null,null,null,null,null,"Summer 2024",null,865.16187889664025,null,1730.3237577932805,null,1730.3237577932805,null,3460.647515586561]
[null,null,null,null,null,null,null,null,"Summer 2025",null,899.76835405250586,null,1799.5367081050117,null,1799.5367081050117,null,3599.0734162100234]
[]
[null,null,null,null,null,null,null,null,"Architecture "]
[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 2018",null,{"$f":"Q261/4","v":1362.75},null,{"$f":"Q261/2","v":2725.5},null,{"$f":"Q261/2","v":2725.5},null,5451]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K261*$S$108","v":1417.26},null,{"$f":"M261*$S$108","v":2834.52},null,{"$f":"O261*$S$108","v":2834.52},null,{"$f":"Q261*$S$108","v":5669.04}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,{"$f":"K262*$S$108","v":1473.9503999999999},null,{"$f":"M262*$S$108","v":2947.9007999999999},null,{"$f":"O262*$S$108","v":2947.9007999999999},null,{"$f":"Q262*$S$108","v":5895.8015999999998}]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1532.908416,null,3065.816832,null,3065.816832,null,6131.633664]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1594.2247526400001,null,3188.4495052800003,null,3188.4495052800003,null,6376.8990105600005]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1657.9937427456002,null,3315.9874854912005,null,3315.9874854912005,null,6631.9749709824009]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1724.3134924554242,null,3448.6269849108485,null,3448.6269849108485,null,6897.253969821697]
[null,null,null,null,null,null,null,null,"Fall 2025",null,1793.2860321536414,null,3586.5720643072827,null,3586.5720643072827,null,7173.1441286145655]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"Q270/4","v":1362.75},null,{"$f":"Q270/2","v":2725.5},null,{"$f":"Q270/2","v":2725.5},null,5451]
[null,null,null,null,null,null,null,null,"Spring 2020",null,{"$f":"M271/2","v":1417.26},null,{"$f":"O271","v":2834.52},null,{"$f":"Q271/2","v":2834.52},null,{"$f":"Q270*$S$108","v":5669.04}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,{"$f":"K271*$S$108","v":1473.9503999999999},null,{"$f":"M271*$S$108","v":2947.9007999999999},null,{"$f":"O271*$S$108","v":2947.9007999999999},null,{"$f":"Q271*$S$108","v":5895.8015999999998}]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1532.908416,null,3065.816832,null,3065.816832,null,{"$f":"Q272*$S$108","v":6131.633664}]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1594.2247526400001,null,3188.4495052800003,null,3188.4495052800003,null,6376.8990105600005]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1657.9937427456002,null,3315.9874854912005,null,3315.9874854912005,null,6631.9749709824009]
[null,null,null,null,null,null,null,null,"Spring 2025",null,1724.3134924554242,null,3448.6269849108485,null,3448.6269849108485,null,6897.253969821697]
[null,null,null,null,null,null,null,null,"Spring 2026",null,1793.2860321536414,null,3586.5720643072827,null,3586.5720643072827,null,7173.1441286145655]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"Q279/4","v":751.25},null,{"$f":"Q279/2","v":1502.5},null,{"$f":"Q279/2","v":1502.5},null,3005]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K279*$S$108","v":781.30000000000007},null,{"$f":"M279*$S$108","v":1562.6000000000001},null,{"$f":"O279*$S$108","v":1562.6000000000001},null,{"$f":"Q279*$S$108","v":3125.2000000000003}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,{"$f":"K280*$S$108","v":812.55200000000013},null,{"$f":"M280*$S$108","v":1625.1040000000003},null,{"$f":"O280*$S$108","v":1625.1040000000003},null,{"$f":"Q280*$S$108","v":3250.2080000000005}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,845.05408000000011,null,1690.1081600000002,null,1690.1081600000002,null,3380.2163200000005]
[null,null,null,null,null,null,null,null,"Summer 2022",null,878.85624320000011,null,1757.7124864000002,null,1757.7124864000002,null,3515.4249728000004]
[null,null,null,null,null,null,null,null,"Summer 2023",null,914.01049292800019,null,1828.0209858560004,null,1828.0209858560004,null,3656.0419717120008]
[null,null,null,null,null,null,null,null,"Summer 2024",null,950.57091264512019,null,1901.1418252902404,null,1901.1418252902404,null,3802.2836505804808]
[null,null,null,null,null,null,null,null,"Summer 2025",null,988.59374915092508,null,1977.1874983018502,null,1977.1874983018502,null,3954.3749966037003]

{"sheet":"SPA USE ONLY","index":4,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Sponsor:",{"$f":"Summary!D3","v":0}]
["Title: ",{"$f":"Summary!D4","v":0}]
["PI Name: ",{"$f":"Summary!D5","v":0}]
["Period of Performance:",{"$f":"Summary!D6","v":"00:00:00"}]
["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!R96+Summary!R97+Summary!R78+Summary!R86,0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C8:C22)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND(Summary!R105,0)","v":0}]
["Total Costs",null,{"$f":"SUM(C23:C24)","v":0}]