{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Tuition","Travel Details","SPA USE ONLY"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":3,"defined_names":42,"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":147,"n_cols":20,"rows_kept":147,"cut":false,"hidden":false,"merged":[[8,18,10,18],[8,19,10,19],[102,4,102,6],[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,10,17],[1,18,1,19],[116,2,116,17],[69,3,69,6],[70,3,70,6],[73,3,73,6],[114,2,114,17],[74,3,74,6],[75,3,75,6]]}
["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. 2/9//2017"]
[null,null,null,null,null,null,null,"Enter other IDC rate here if using rate other than standard ISU negotiated research rate",null,null,null,null,null,null,null,null,null,null,"Updated 2/16/17"]
["Program Sponsor",null,null,"."]
["Title",null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS ________"]
["PI",null,null,"."]
["Period of Performance",null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Deadline",null,null,".",null,null,null,"If using rate other than negotiated research, enter number in cell H3, and then select \"other rate\" for each year (see orange FY tabs below)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"T107","v":0}]
[]
[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,"FY17","Select FY","FY18","Select FY","FY19","Select FY",{"$f":"IF(L10=A137,A137,IF(L10=A138,A139,IF(L10=A139,A140,IF(L10=A140,A141,IF(L10=A141,A142,IF(L10=A142,A143,IF(L10=A143,A144,IF(L10=A144,A145,IF(L10=A145,A146,IF(L10=A146,A147))))))))))","v":"FY20"},"Select FY",{"$f":"IF(N10=A137,A137,IF(N10=A138,A139,IF(N10=A139,A140,IF(N10=A140,A141,IF(N10=A141,A142,IF(N10=A142,A143,IF(N10=A143,A144,IF(N10=A144,A145,IF(N10=A145,A146,IF(N10=A146,A147))))))))))","v":"FY21"},"Select FY"]
[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(H14:H22)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H13+J13+L13+N13+P13)","v":0},{"$f":"SUM(I13+K13+M13+O13+Q13)","v":0},{"$f":"SUM(R13+S13)","v":0}]
[null,1,null,0,0,0,0,{"$f":"D14*(E14+F14+G14)","v":0},null,{"$f":"ROUND(H14*1.03,0)","v":0},null,{"$f":"ROUND(J14*1.03,0)","v":0},null,{"$f":"ROUND(L14*1.03,0)","v":0},null,{"$f":"ROUND(N14*1.03,0)","v":0},null,{"$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,2,null,0,0,0,0,0,null,{"$f":"ROUND(H15*1.03,0)","v":0},null,{"$f":"ROUND(J15*1.03,0)","v":0},null,{"$f":"ROUND(L15*1.03,0)","v":0},null,{"$f":"ROUND(N15*1.03,0)","v":0},null,{"$f":"SUM(H15+J15+L15+N15+P15)","v":0},0,{"$f":"SUM(R15+S15)","v":0}]
[null,3,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,5,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,6,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,7,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,8,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,9,null,0,0,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,null,"Calendar",null,"Number of"]
["B",null,"Other Personnel","Monthly","Months",null,"persons",{"$f":"SUM(H25:H36)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H24+J24+L24+N24+P24)","v":0},{"$f":"SUM(I24+K24+M24+O24+Q24)","v":0},{"$f":"SUM(R24+S24)","v":0}]
[null,1,"Post Doc",0,0,null,0,{"$f":"D25*(E25)*G25","v":0},null,{"$f":"ROUND(H25*1.03,0)","v":0},null,{"$f":"ROUND(J25*1.03,0)","v":0},null,{"$f":"ROUND(L25*1.03,0)","v":0},null,{"$f":"ROUND(N25*1.03,0)","v":0},null,{"$f":"SUM(H25+J25+L25+N25+P25)","v":0},0,{"$f":"SUM(R25+S25)","v":0}]
[null,2,"Post Doc",0,0,null,0,{"$f":"D26*(E26)*G26","v":0},null,{"$f":"ROUND(H26*1.03,0)","v":0},null,{"$f":"ROUND(J26*1.03,0)","v":0},null,{"$f":"ROUND(L26*1.03,0)","v":0},null,{"$f":"ROUND(N26*1.03,0)","v":0},null,0,0,0]
[null,3,"Research Asst-Halftime",0,0,null,0,{"$f":"D27*(E27)*G27","v":0},null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"Research Asst-Halftime",0,0,null,0,{"$f":"D28*(E28)*G28","v":0},null,0,null,0,null,0,null,0,null,0,0,0]
[null,5,"Hourly Undergraduate student",0,0,null,0,{"$f":"D29*(E29)*G29","v":0},null,0,null,0,null,0,null,0,null,0,0,0]
[null,6,"Hourly Undergraduate student",0,0,null,0,{"$f":"D30*(E30)*G30","v":0},null,0,null,0,null,0,null,0,null,0,0,0]
[null,7,"P&S",0,0,null,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,8,"P&S",0,0,null,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,9,"Secretarial/Clerical",0,0,null,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,10,"Secretarial/Clerical",0,0,null,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,11,"Non-Student Hourly",0,0,null,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,12,"Non-Student Hourly",0,0,null,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
[]
[null,null,"Subtotal: Salaries and Wages",null,null,null,null,{"$f":"+H13+H24","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H38+J38+L38+N38+P38)","v":0},{"$f":"SUM(I38+K38+M38+O38+Q38)","v":0},{"$f":"SUM(R38+S38)","v":0}]
[]
["C",null,"Fringe Benefits","Rate",null,null,null,{"$f":"SUM(H41:H61)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H40+J40+L40+N40+P40)","v":0},{"$f":"SUM(I40+K40+M40+O40+Q40)","v":0},{"$f":"SUM(R40+S40)","v":0}]
[null,null,{"$f":"+C14","v":0},0.27500000000000002,null,null,null,{"$f":"ROUND(D41*H14,0)","v":0},{"$f":"ROUND(D41*I14,0)","v":0},{"$f":"ROUND(D41*J14,0)","v":0},{"$f":"ROUND(D41*K14,0)","v":0},{"$f":"ROUND(D41*L14,0)","v":0},{"$f":"ROUND(D41*M14,0)","v":0},{"$f":"ROUND(D41*N14,0)","v":0},{"$f":"ROUND(D41*O14,0)","v":0},{"$f":"ROUND(D41*P14,0)","v":0},{"$f":"ROUND(D41*Q14,0)","v":0},{"$f":"SUM(H41+J41+L41+N41+P41)","v":0},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},0,0,0]
[null,null,{"$f":"+C16","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,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":"+C25","v":"Post Doc"},0.32900000000000001,null,null,null,{"$f":"ROUND(D50*H25,0)","v":0},{"$f":"ROUND(D50*I25,0)","v":0},{"$f":"ROUND(D50*J25,0)","v":0},{"$f":"ROUND(D50*K25,0)","v":0},{"$f":"ROUND(D50*L25,0)","v":0},{"$f":"ROUND(D50*M25,0)","v":0},{"$f":"ROUND(D50*N25,0)","v":0},{"$f":"ROUND(D50*O25,0)","v":0},{"$f":"ROUND(D50*P25,0)","v":0},{"$f":"ROUND(D50*Q25,0)","v":0},0,0,0]
[null,null,{"$f":"+C26","v":"Post Doc"},0.32900000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"P&S",0.34499999999999997,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"P&S",0.34499999999999997,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.45800000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.45800000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.17100000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.17100000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries, Wages, and Benefits",null,null,null,null,{"$f":"H38+H40","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H63+J63+L63+N63+P63)","v":0},{"$f":"SUM(I63+K63+M63+O63+Q63)","v":0},{"$f":"SUM(R63+S63)","v":0}]
[]
["D",null,"Equipment (List Item and $ amount for each item > $5k)",null,null,null,null,{"$f":"SUM(H66:H67)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H65+J65+L65+N65+P65)","v":0},0,{"$f":"SUM(R65+S65)","v":0}]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R66+S66)","v":0}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R67+S67)","v":0}]
[]
["E",null,"Travel",null,null,null,null,{"$f":"SUM(H70:H71)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H69+J69+L69+N69+P69)","v":0},0,{"$f":"SUM(R69+S69)","v":0}]
[null,null,"1. Domestic Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R70+S70)","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(R71+S71)","v":0}]
[]
["F",null,"Participant Support Cost",null,null,null,null,{"$f":"SUM(H74:H77)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H73+J73+L73+N73+P73)","v":0},{"$f":"SUM(I73+K73+M73+O73+Q73)","v":0},{"$f":"SUM(R73+S73)","v":0}]
[null,null,"1. Stipend",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H74+J74+L74+N74+P74)","v":0},0,{"$f":"SUM(R74+S74)","v":0}]
[null,null,"2. Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R75+S75)","v":0}]
[null,null,"3. Subsistence",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R76+S76)","v":0}]
[null,null,"4. Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R77+S77)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H80:H95)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H79+J79+L79+N79+P79)","v":0},{"$f":"SUM(I79+K79+M79+O79+Q79)","v":0},{"$f":"SUM(R79+S79)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$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,2,"Publication cost",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H81+J81+L81+N81+P81)","v":0},0,0]
[null,3,"Consultant/Professional Services",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H82+J82+L82+N82+P82)","v":0},{"$f":"SUM(I82+K82+M82+O82+Q82)","v":0},{"$f":"SUM(R82+S82)","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(H85+J85+L85+N85+P85)","v":0},{"$f":"SUM(I85+K85+M85+O85+Q85)","v":0},{"$f":"SUM(R85+S85)","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(H92+J92+L92+N92+P92)","v":0},{"$f":"SUM(I92+K92+M92+O92+Q92)","v":0},{"$f":"SUM(R92+S92)","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":"H93+J93+L93+N93+P93","v":0},{"$f":"I93+K93+M93+O93+Q93","v":0},{"$f":"S93+R93","v":0}]
[null,9,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,10,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[]
[null,null,"Subtotal: Total Direct Costs (TDC)",null,null,null,null,{"$f":"H63+H65+H69+H73+H79","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H97+J97+L97+N97+P97)","v":0},{"$f":"SUM(I97+K97+M97+O97+Q97)","v":0},{"$f":"SUM(R97+S97)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"IF(H10=A137,H97,(H97-H65-H87-H89-H90-H91-H92-H93-H73-H85))","v":0},{"$f":"IF(H10=A137,I97,(I97-I65-I87-I89-I90-I91-I92-I93-I73-I85))","v":0},{"$f":"IF(J10=A137,J97,(J97-J65-J87-J89-J90-J91-J92-J93-J73-J85))","v":0},{"$f":"IF(J10=A137,K97,(K97-K65-K87-K89-K90-K91-K92-K93-K73-K85))","v":0},{"$f":"IF(L10=A137,L97,(L97-L65-L87-L89-L90-L91-L92-L93-L73-L85))","v":0},{"$f":"IF(L10=A137,M97,(M97-M65-M87-M89-M90-M91-M92-M93-M73-M85))","v":0},{"$f":"IF(N10=A137,N97,(N97-N65-N87-N89-N90-N91-N92-N93-N73-N85))","v":0},{"$f":"IF(N10=A137,O97,(O97-O65-O87-O89-O90-O91-O92-O93-O73-O85))","v":0},{"$f":"IF(P10=A137,P97,(P97-P65-P87-P89-P90-P91-P92-P93-P73-P85))","v":0},{"$f":"IF(P10=A137,Q97,(Q97-Q65-Q87-Q89-Q90-Q91-Q92-Q93-Q73-Q85))","v":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,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs",null,null,null,null,{"$f":"SUM(H103:H103)","v":0},{"$f":"SUM(I103:I103)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(H102+J102+L102+N102+P102)","v":0},{"$f":"SUM(I102+K102+M102+O102+Q102)","v":0},{"$f":"SUM(R102+S102)","v":0}]
[null,null,"IDC on MTDC",null,"[ IDC = MTDC * Indirect Rate ]",null,null,{"$f":"ROUND(IF(H10=A137,C137,IF(H10=A138,C138,IF(H10=A139,C139,IF(H10=A140,C140,IF(H10=A141,C141,IF(H10=A142,C142,IF(H10=A143,C143)))))))*(IF(H10=A137,H97,H99)),0)","v":0},{"$f":"ROUND(IF(H10=A137,C137,IF(H10=A138,C138,IF(H10=A139,C139,IF(H10=A140,C140,IF(H10=A141,C141,IF(H10=A142,C142,IF(H10=A143,C143)))))))*(IF(H10=A137,I97,I99)),0)","v":0},{"$f":"ROUND(IF(J10=A137,C137,IF(J10=A138,C138,IF(J10=A139,C139,IF(J10=A140,C140,IF(J10=A141,C141,IF(J10=A142,C142,IF(J10=A143,C143,IF(J10=A144,C144,IF(J10=A145,C145,IF(J10=A146,C146,IF(J10=A147,C147)))))))))))*(IF(J10=A137,J97,J99)),0)","v":0},{"$f":"ROUND(IF(J10=A137,C137,IF(J10=A138,C138,IF(J10=A139,C139,IF(J10=A140,C140,IF(J10=A141,C141,IF(J10=A142,C142,IF(J10=A143,C143,IF(J10=A144,C144,IF(J10=A145,C145,IF(J10=A146,C146,IF(J10=A147,C147)))))))))))*(IF(J10=A137,K97,K99)),0)","v":0},{"$f":"ROUND(IF(L10=A137,C137,IF(L10=A138,C138,IF(L10=A139,C139,IF(L10=A140,C140,IF(L10=A141,C141,IF(L10=A142,C142,IF(L10=A143,C143,IF(L10=A144,C144,IF(L10=A145,C145,IF(L10=A146,C146,IF(L10=A147,C147)))))))))))*(IF(L10=A137,L97,L99)),0)","v":0},{"$f":"ROUND(IF(L10=A137,C137,IF(L10=A138,C138,IF(L10=A139,C139,IF(L10=A140,C140,IF(L10=A141,C141,IF(L10=A142,C142,IF(L10=A143,C143,IF(L10=A144,C144,IF(L10=A145,C145,IF(L10=A146,C146,IF(L10=A147,C147)))))))))))*(IF(L10=A137,M97,M99)),0)","v":0},{"$f":"ROUND(IF(N10=A137,C137,IF(N10=A138,C138,IF(N10=A139,C139,IF(N10=A140,C140,IF(N10=A141,C141,IF(N10=A142,C142,IF(N10=A143,C143,IF(N10=A144,C144,IF(N10=A145,C145,IF(N10=A146,C146,IF(N10=A147,C147)))))))))))*(IF(N10=A137,N97,N99)),0)","v":0},{"$f":"ROUND(IF(N10=A137,C137,IF(N10=A138,C138,IF(N10=A139,C139,IF(N10=A140,C140,IF(N10=A141,C141,IF(N10=A142,C142,IF(N10=A143,C143,IF(N10=A144,C144,IF(N10=A145,C145,IF(N10=A146,C146,IF(N10=A147,C147)))))))))))*(IF(N10=A137,O97,O99)),0)","v":0},{"$f":"ROUND(IF(P10=A137,C137,IF(P10=A138,C138,IF(P10=A139,C139,IF(P10=A140,C140,IF(P10=A141,C141,IF(P10=A142,C142,IF(P10=A143,C143,IF(P10=A144,C144,IF(P10=A145,C145,IF(P10=A146,C146,IF(P10=A147,C147)))))))))))*(IF(P10=A137,P97,P99)),0)","v":0},{"$f":"ROUND(IF(P10=A137,C137,IF(P10=A138,C138,IF(P10=A139,C139,IF(P10=A140,C140,IF(P10=A141,C141,IF(P10=A142,C142,IF(P10=A143,C143,IF(P10=A144,C144,IF(P10=A145,C145,IF(P10=A146,C146,IF(P10=A147,C147)))))))))))*(IF(P10=A137,Q97,Q99)),0)","v":0},{"$f":"SUM(H103+J103+L103+N103+P103)","v":0},{"$f":"SUM(I103+K103+M103+O103+Q103)","v":0},{"$f":"SUM(R103+S103)","v":0}]
[null,null,"If less than full IDC rate, please modify MTDC line to equal TDC"]
[]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H97+H102","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H107+J107+L107+N107+P107)","v":0},{"$f":"SUM(I107+K107+M107+O107+Q107)","v":0},{"$f":"SUM(R107+S107)","v":0}]
[]
[]
[]
[]
[]
[null,null,"NOTES:"]
[]
[null,null,"This budget is completely adjustable.  As such, you will need to double check your work and make adjustments in certain cells, such as:"]
[]
[null,null,"Subcontracts - Verify that only the first $25K of each subcontract is charged IDC.  You might need to adjust the MTDC for each year of each subcontract."]
[]
[]
[]
[]
[null,null,"Benefits:",null,null,null,null,"Indirect Cost Categories:"]
[null,null,"A&B",0.27500000000000002]
[null,null,"C",9.8000000000000004E-2,null,null,null,0.52,"On-Campus Organized Research FY17, FY18"]
[null,null,"D",0.32900000000000001,null,null,null,0.53,"On-Campus Organized Research FY19-21"]
[null,null,"P",0.34499999999999997,null,null,null,0.53,"On Campus Instruction"]
[null,null,"E",0.45800000000000002,null,null,null,0.33,"On-Campus Other Sponsored Activities"]
[null,null,"XH (Student hourly)",6.0000000000000001E-3,null,null,null,0.26,"Off-Campus All Programs"]
[null,null,"XH (Non-Student hourly)",0.17100000000000001]
[]
[null,null,"Post Doc Salary Range:"]
[null,null," "]
[null,null,"http://www.grad-college.iastate.edu/post_doc/policies.php"]
[]
[]
["FY",null,"RATE"]
["Other Rate",null,{"$f":"H3","v":0}]
["FY17",null,0.52]
["FY18",null,0.52]
["FY19",null,0.53]
["FY20",null,0.53]
["FY21",null,0.53]
["FY22",null,0.53]
["FY23",null,0.53]
["FY24",null,0.53]
["FY25",null,0.53]
["FY26",null,0.53]

{"sheet":"Tuition","index":1,"n_rows":206,"n_cols":19,"rows_kept":206,"cut":false,"hidden":false,"merged":[[79,0,83,0],[79,2,79,3],[81,2,81,3],[83,2,83,3],[84,0,85,8],[68,2,68,5],[71,2,71,7],[73,0,77,0],[73,2,73,3],[75,2,75,3],[77,2,77,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],[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],[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],[2,2,2,8],[10,2,10,7],[25,2,25,5],[26,2,26,5],[27,2,27,5],[67,2,67,5],[30,2,30,7],[5,2,5,5],[6,2,6,5],[7,2,7,5],[66,2,66,5]]}
[null,null,"           Tuition Costs",null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,null,null,null,null,null,null,null,null,null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested"]
[]
[]
[8,null,"Graduate Student Tuition (most Majors)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF(I6=\"1/2-time\",K7,K8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",M7,M8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",O7,O8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",Q7,Q8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",S7,S8),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C13*VLOOKUP(K13,$I$91:$Q$117,5,FALSE)+C15*VLOOKUP(K15,$I$91:$Q$117,5,FALSE)+C17*VLOOKUP(K17,$I$91:$Q$117,5,FALSE)+C19*VLOOKUP(K19,$I$91:$Q$117,9,FALSE)+C21*VLOOKUP(K21,$I$91:$Q$117,9,FALSE)+C23*VLOOKUP(K23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$91:$Q$117,5,FALSE)+E15*VLOOKUP(M15,$I$91:$Q$117,5,FALSE)+E17*VLOOKUP(M17,$I$91:$Q$117,5,FALSE)+E19*VLOOKUP(M19,$I$91:$Q$117,9,FALSE)+E21*VLOOKUP(M21,$I$91:$Q$117,9,FALSE)+E23*VLOOKUP(M23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$91:$Q$117,5,FALSE)+F15*VLOOKUP(O15,$I$91:$Q$117,5,FALSE)+F17*VLOOKUP(O17,$I$91:$Q$117,5,FALSE)+F19*VLOOKUP(O19,$I$91:$Q$117,9,FALSE)+F21*VLOOKUP(O21,$I$91:$Q$117,9,FALSE)+F23*VLOOKUP(O23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$91:$Q$117,5,FALSE)+G15*VLOOKUP(Q15,$I$91:$Q$117,5,FALSE)+G17*VLOOKUP(Q17,$I$91:$Q$117,5,FALSE)+G19*VLOOKUP(Q19,$I$91:$Q$117,9,FALSE)+G21*VLOOKUP(Q21,$I$91:$Q$117,9,FALSE)+G23*VLOOKUP(Q23,$I$91:$Q$117,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$91:$Q$117,5,FALSE)+H15*VLOOKUP(S15,$I$91:$Q$117,5,FALSE)+H17*VLOOKUP(S17,$I$91:$Q$117,5,FALSE)+H19*VLOOKUP(S19,$I$91:$Q$117,9,FALSE)+H21*VLOOKUP(S21,$I$91:$Q$117,9,FALSE)+H23*VLOOKUP(S23,$I$91:$Q$117,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$91:$Q$117,3,FALSE)+C15*VLOOKUP(K15,$I$91:$Q$117,3,FALSE)+C17*VLOOKUP(K17,$I$91:$Q$117,3,FALSE)+C19*VLOOKUP(K19,$I$91:$Q$117,7,FALSE)+C21*VLOOKUP(K21,$I$91:$Q$117,7,FALSE)+C23*VLOOKUP(K23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$91:$Q$117,3,FALSE)+E15*VLOOKUP(M15,$I$91:$Q$117,3,FALSE)+E17*VLOOKUP(M17,$I$91:$Q$117,3,FALSE)+E19*VLOOKUP(M19,$I$91:$Q$117,7,FALSE)+E21*VLOOKUP(M21,$I$91:$Q$117,7,FALSE)+E23*VLOOKUP(M23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$91:$Q$117,3,FALSE)+F15*VLOOKUP(O15,$I$91:$Q$117,3,FALSE)+F17*VLOOKUP(O17,$I$91:$Q$117,3,FALSE)+F19*VLOOKUP(O19,$I$91:$Q$117,7,FALSE)+F21*VLOOKUP(O21,$I$91:$Q$117,7,FALSE)+F23*VLOOKUP(O23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$91:$Q$117,3,FALSE)+G15*VLOOKUP(Q15,$I$91:$Q$117,3,FALSE)+G17*VLOOKUP(Q17,$I$91:$Q$117,3,FALSE)+G19*VLOOKUP(Q19,$I$91:$Q$117,7,FALSE)+G21*VLOOKUP(Q21,$I$91:$Q$117,7,FALSE)+G23*VLOOKUP(Q23,$I$91:$Q$117,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$91:$Q$117,3,FALSE)+H15*VLOOKUP(S15,$I$91:$Q$117,3,FALSE)+H17*VLOOKUP(S17,$I$91:$Q$117,3,FALSE)+H19*VLOOKUP(S19,$I$91:$Q$117,7,FALSE)+H21*VLOOKUP(S21,$I$91:$Q$117,7,FALSE)+H23*VLOOKUP(S23,$I$91:$Q$117,7,FALSE)","v":0}]
[]
[]
[null,null,"Graduate Student Tuition (most majors)"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
[]
[8,null,"Graduate Student Tuition (Engineering & Architecture)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$26=\"1/2-time\",K27,K28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",M27,M28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",O27,O28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",Q27,Q28),0)","v":0},null,{"$f":"ROUND(IF($I$26=\"1/2-time\",S27,S28),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C33*VLOOKUP(K33,$I$121:$Q$147,5,FALSE)+C35*VLOOKUP(K35,$I$121:$Q$147,5,FALSE)+C37*VLOOKUP(K37,$I$121:$Q$147,5,FALSE)+C39*VLOOKUP(K39,$I$121:$Q$147,9,FALSE)+C41*VLOOKUP(K41,$I$121:$Q$147,9,FALSE)+C43*VLOOKUP(K43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$121:$Q$147,5,FALSE)+E35*VLOOKUP(M35,$I$121:$Q$147,5,FALSE)+E37*VLOOKUP(M37,$I$121:$Q$147,5,FALSE)+E39*VLOOKUP(M39,$I$121:$Q$147,9,FALSE)+E41*VLOOKUP(M41,$I$121:$Q$147,9,FALSE)+E43*VLOOKUP(M43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$121:$Q$147,5,FALSE)+F35*VLOOKUP(O35,$I$121:$Q$147,5,FALSE)+F37*VLOOKUP(O37,$I$121:$Q$147,5,FALSE)+F39*VLOOKUP(O39,$I$121:$Q$147,9,FALSE)+F41*VLOOKUP(O41,$I$121:$Q$147,9,FALSE)+F43*VLOOKUP(O43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$121:$Q$147,5,FALSE)+G35*VLOOKUP(Q35,$I$121:$Q$147,5,FALSE)+G37*VLOOKUP(Q37,$I$121:$Q$147,5,FALSE)+G39*VLOOKUP(Q39,$I$121:$Q$147,9,FALSE)+G41*VLOOKUP(Q41,$I$121:$Q$147,9,FALSE)+G43*VLOOKUP(Q43,$I$121:$Q$147,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$121:$Q$147,5,FALSE)+H35*VLOOKUP(S35,$I$121:$Q$147,5,FALSE)+H37*VLOOKUP(S37,$I$121:$Q$147,5,FALSE)+H39*VLOOKUP(S39,$I$121:$Q$147,9,FALSE)+H41*VLOOKUP(S41,$I$121:$Q$147,9,FALSE)+H43*VLOOKUP(S43,$I$121:$Q$147,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$121:$Q$147,3,FALSE)+C35*VLOOKUP(K35,$I$121:$Q$147,3,FALSE)+C37*VLOOKUP(K37,$I$121:$Q$147,3,FALSE)+C39*VLOOKUP(K39,$I$121:$Q$147,7,FALSE)+C41*VLOOKUP(K41,$I$121:$Q$147,7,FALSE)+C43*VLOOKUP(K43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$121:$Q$147,3,FALSE)+E35*VLOOKUP(M35,$I$121:$Q$147,3,FALSE)+E37*VLOOKUP(M37,$I$121:$Q$147,3,FALSE)+E39*VLOOKUP(M39,$I$121:$Q$147,7,FALSE)+E41*VLOOKUP(M41,$I$121:$Q$147,7,FALSE)+E43*VLOOKUP(M43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$121:$Q$147,3,FALSE)+F35*VLOOKUP(O35,$I$121:$Q$147,3,FALSE)+F37*VLOOKUP(O37,$I$121:$Q$147,3,FALSE)+F39*VLOOKUP(O39,$I$121:$Q$147,7,FALSE)+F41*VLOOKUP(O41,$I$121:$Q$147,7,FALSE)+F43*VLOOKUP(O43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$121:$Q$147,3,FALSE)+G35*VLOOKUP(Q35,$I$121:$Q$147,3,FALSE)+G37*VLOOKUP(Q37,$I$121:$Q$147,3,FALSE)+G39*VLOOKUP(Q39,$I$121:$Q$147,7,FALSE)+G41*VLOOKUP(Q41,$I$121:$Q$147,7,FALSE)+G43*VLOOKUP(Q43,$I$121:$Q$147,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$121:$Q$147,3,FALSE)+H35*VLOOKUP(S35,$I$121:$Q$147,3,FALSE)+H37*VLOOKUP(S37,$I$121:$Q$147,3,FALSE)+H39*VLOOKUP(S39,$I$121:$Q$147,7,FALSE)+H41*VLOOKUP(S41,$I$121:$Q$147,7,FALSE)+H43*VLOOKUP(S43,$I$121:$Q$147,7,FALSE)","v":0}]
[]
[]
[null,null,"Engineering & Architecture Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
[]
[8,null,"Graduate Student Tuition (Business & STB)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$46=\"1/2-time\",K47,K48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",M47,M48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",O47,O48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",Q47,Q48),0)","v":0},null,{"$f":"ROUND(IF($I$46=\"1/2-time\",S47,S48),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C53*VLOOKUP(K53,$I$151:$Q$177,5,FALSE)+C55*VLOOKUP(K55,$I$151:$Q$177,5,FALSE)+C57*VLOOKUP(K57,$I$151:$Q$177,5,FALSE)+C59*VLOOKUP(K59,$I$151:$Q$177,9,FALSE)+C61*VLOOKUP(K61,$I$151:$Q$177,9,FALSE)+C63*VLOOKUP(K63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$151:$Q$177,5,FALSE)+E55*VLOOKUP(M55,$I$151:$Q$177,5,FALSE)+E57*VLOOKUP(M57,$I$151:$Q$177,5,FALSE)+E59*VLOOKUP(M59,$I$151:$Q$177,9,FALSE)+E61*VLOOKUP(M61,$I$151:$Q$177,9,FALSE)+E63*VLOOKUP(M63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$151:$Q$177,5,FALSE)+F55*VLOOKUP(O55,$I$151:$Q$177,5,FALSE)+F57*VLOOKUP(O57,$I$151:$Q$177,5,FALSE)+F59*VLOOKUP(O59,$I$151:$Q$177,9,FALSE)+F61*VLOOKUP(O61,$I$151:$Q$177,9,FALSE)+F63*VLOOKUP(O63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$151:$Q$177,5,FALSE)+G55*VLOOKUP(Q55,$I$151:$Q$177,5,FALSE)+G57*VLOOKUP(Q57,$I$151:$Q$177,5,FALSE)+G59*VLOOKUP(Q59,$I$151:$Q$177,9,FALSE)+G61*VLOOKUP(Q61,$I$151:$Q$177,9,FALSE)+G63*VLOOKUP(Q63,$I$151:$Q$177,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$151:$Q$177,5,FALSE)+H55*VLOOKUP(S55,$I$151:$Q$177,5,FALSE)+H57*VLOOKUP(S57,$I$151:$Q$177,5,FALSE)+H59*VLOOKUP(S59,$I$151:$Q$177,9,FALSE)+H61*VLOOKUP(S61,$I$151:$Q$177,9,FALSE)+H63*VLOOKUP(S63,$I$151:$Q$177,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$151:$Q$177,3,FALSE)+C55*VLOOKUP(K55,$I$151:$Q$177,3,FALSE)+C57*VLOOKUP(K57,$I$151:$Q$177,3,FALSE)+C59*VLOOKUP(K59,$I$151:$Q$177,7,FALSE)+C61*VLOOKUP(K61,$I$151:$Q$177,7,FALSE)+C63*VLOOKUP(K63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$151:$Q$177,3,FALSE)+E55*VLOOKUP(M55,$I$151:$Q$177,3,FALSE)+E57*VLOOKUP(M57,$I$151:$Q$177,3,FALSE)+E59*VLOOKUP(M59,$I$151:$Q$177,7,FALSE)+E61*VLOOKUP(M61,$I$151:$Q$177,7,FALSE)+E63*VLOOKUP(M63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$151:$Q$177,3,FALSE)+F55*VLOOKUP(O55,$I$151:$Q$177,3,FALSE)+F57*VLOOKUP(O57,$I$151:$Q$177,3,FALSE)+F59*VLOOKUP(O59,$I$151:$Q$177,7,FALSE)+F61*VLOOKUP(O61,$I$151:$Q$177,7,FALSE)+F63*VLOOKUP(O63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$151:$Q$177,3,FALSE)+G55*VLOOKUP(Q55,$I$151:$Q$177,3,FALSE)+G57*VLOOKUP(Q57,$I$151:$Q$177,3,FALSE)+G59*VLOOKUP(Q59,$I$151:$Q$177,7,FALSE)+G61*VLOOKUP(Q61,$I$151:$Q$177,7,FALSE)+G63*VLOOKUP(Q63,$I$151:$Q$177,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$151:$Q$177,3,FALSE)+H55*VLOOKUP(S55,$I$151:$Q$177,3,FALSE)+H57*VLOOKUP(S57,$I$151:$Q$177,3,FALSE)+H59*VLOOKUP(S59,$I$151:$Q$177,7,FALSE)+H61*VLOOKUP(S61,$I$151:$Q$177,7,FALSE)+H63*VLOOKUP(S63,$I$151:$Q$177,7,FALSE)","v":0}]
[]
[]
[null,null,"Business and STB Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,0,null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[]
[]
[]
[8,null,"Graduate Student Tuition (*Specific Graduate Departments)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I67=\"1/2-time\",K68,K69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",M68,M69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",O68,O69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",Q68,Q69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",S68,S69),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C74*VLOOKUP(K74,$I$181:$Q$207,5,FALSE)+C76*VLOOKUP(K76,$I$181:$Q$207,5,FALSE)+C78*VLOOKUP(K78,$I$181:$Q$207,5,FALSE)+C80*VLOOKUP(K80,$I$181:$Q$207,9,FALSE)+C82*VLOOKUP(K82,$I$181:$Q$207,9,FALSE)+C84*VLOOKUP(K84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$181:$Q$207,5,FALSE)+E76*VLOOKUP(M76,$I$181:$Q$207,5,FALSE)+E78*VLOOKUP(M78,$I$181:$Q$207,5,FALSE)+E80*VLOOKUP(M80,$I$181:$Q$207,9,FALSE)+E82*VLOOKUP(M82,$I$181:$Q$207,9,FALSE)+E84*VLOOKUP(M84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$181:$Q$207,5,FALSE)+F76*VLOOKUP(O76,$I$181:$Q$207,5,FALSE)+F78*VLOOKUP(O78,$I$181:$Q$207,5,FALSE)+F80*VLOOKUP(O80,$I$181:$Q$207,9,FALSE)+F82*VLOOKUP(O82,$I$181:$Q$207,9,FALSE)+F84*VLOOKUP(O84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$181:$Q$207,5,FALSE)+G76*VLOOKUP(Q76,$I$181:$Q$207,5,FALSE)+G78*VLOOKUP(Q78,$I$181:$Q$207,5,FALSE)+G80*VLOOKUP(Q80,$I$181:$Q$207,9,FALSE)+G82*VLOOKUP(Q82,$I$181:$Q$207,9,FALSE)+G84*VLOOKUP(Q84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$181:$Q$207,5,FALSE)+H76*VLOOKUP(S76,$I$181:$Q$207,5,FALSE)+H78*VLOOKUP(S78,$I$181:$Q$207,5,FALSE)+H80*VLOOKUP(S80,$I$181:$Q$207,9,FALSE)+H82*VLOOKUP(S82,$I$181:$Q$207,9,FALSE)+H84*VLOOKUP(S84,$I$181:$Q$207,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C74*VLOOKUP(K74,$I$181:$Q$207,3,FALSE)+C76*VLOOKUP(K76,$I$181:$Q$207,3,FALSE)+C78*VLOOKUP(K78,$I$181:$Q$207,3,FALSE)+C80*VLOOKUP(K80,$I$181:$Q$207,7,FALSE)+C82*VLOOKUP(K82,$I$181:$Q$207,7,FALSE)+C84*VLOOKUP(K84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$181:$Q$207,3,FALSE)+E76*VLOOKUP(M76,$I$181:$Q$207,3,FALSE)+E78*VLOOKUP(M78,$I$181:$Q$207,3,FALSE)+E80*VLOOKUP(M80,$I$181:$Q$207,7,FALSE)+E82*VLOOKUP(M82,$I$181:$Q$207,7,FALSE)+E84*VLOOKUP(M84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$181:$Q$207,3,FALSE)+F76*VLOOKUP(O76,$I$181:$Q$207,3,FALSE)+F78*VLOOKUP(O78,$I$181:$Q$207,3,FALSE)+F80*VLOOKUP(O80,$I$181:$Q$207,7,FALSE)+F82*VLOOKUP(O82,$I$181:$Q$207,7,FALSE)+F84*VLOOKUP(O84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$181:$Q$207,3,FALSE)+G76*VLOOKUP(Q76,$I$181:$Q$207,3,FALSE)+G78*VLOOKUP(Q78,$I$181:$Q$207,3,FALSE)+G80*VLOOKUP(Q80,$I$181:$Q$207,7,FALSE)+G82*VLOOKUP(Q82,$I$181:$Q$207,7,FALSE)+G84*VLOOKUP(Q84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$181:$Q$207,3,FALSE)+H76*VLOOKUP(S76,$I$181:$Q$207,3,FALSE)+H78*VLOOKUP(S78,$I$181:$Q$207,3,FALSE)+H80*VLOOKUP(S80,$I$181:$Q$207,7,FALSE)+H82*VLOOKUP(S82,$I$181:$Q$207,7,FALSE)+H84*VLOOKUP(S84,$I$181:$Q$207,7,FALSE)","v":0}]
[]
[]
[null,null,"*Specific Graduate Departments"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,0,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
["*Animal Sci, Comp Sci, GDCB, Microbiology, Plant Path, BBMB, EEOB, Industrial Design, NREM"]
[]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max",null,"esc. Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4-time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2-time"]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q91/4","v":1091},null,{"$f":"O91","v":2182},null,{"$f":"Q91/2","v":2182},null,4364]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K91*$S$88","v":1136.8220000000001},{"$f":"L91*$S$88","v":0},{"$f":"M91*$S$88","v":2273.6440000000002},0,{"$f":"Q92/2","v":2273.6440000000002},0,{"$f":"Q91*$S$88","v":4547.2880000000005}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K92*$S$88","v":1184.5685240000003},null,2369.1370480000005,null,2369.1370480000005,null,4738.274096000001]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1234.3204020080002,null,2468.6408040160004,null,2468.6408040160004,null,{"$f":"Q93*$S$88","v":4937.2816080320008}]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1286.1618588923363,null,2572.3237177846727,null,2572.3237177846727,null,{"$f":"Q94*$S$88","v":5144.6474355693454}]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1340.1806569658145,null,2680.361313931629,null,2680.361313931629,null,{"$f":"Q95*$S$88","v":5360.7226278632579}]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1396.4682445583787,null,2792.9364891167575,null,2792.9364891167575,null,{"$f":"Q96*$S$88","v":5585.8729782335149}]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1455.1199108298306,null,2910.2398216596612,null,2910.2398216596612,null,5820.4796433193223]
[]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q100/4","v":1059.25},null,{"$f":"Q100/2","v":2118.5},null,{"$f":"Q100/2","v":2118.5},null,4237]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M101/2","v":1091},null,{"$f":"O101","v":2182},null,{"$f":"Q101/2","v":2182},null,4364]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K101*$S$88","v":1136.8220000000001},null,{"$f":"M101*$S$88","v":2273.6440000000002},null,{"$f":"O101*$S$88","v":2273.6440000000002},null,{"$f":"Q101*$S$88","v":4547.2880000000005}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1184.5685240000003,null,2369.1370480000005,null,2369.1370480000005,null,4738.274096000001]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1234.3204020080002,null,2468.6408040160004,null,2468.6408040160004,null,4937.2816080320008]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1286.1618588923363,null,2572.3237177846727,null,2572.3237177846727,null,5144.6474355693454]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1340.1806569658145,null,2680.361313931629,null,2680.361313931629,null,5360.7226278632579]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1396.4682445583787,null,2792.9364891167575,null,2792.9364891167575,null,5585.8729782335149]
[]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q109/4","v":606.25},null,{"$f":"Q109/2","v":1212.5},null,{"$f":"Q109/2","v":1212.5},null,2425]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K109*$S$88","v":631.71249999999998},null,{"$f":"M109*$S$88","v":1263.425},null,{"$f":"O109*$S$88","v":1263.425},null,{"$f":"Q109*S88","v":2526.85}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K110*$S$88","v":658.24442499999998},null,{"$f":"M110*$S$88","v":1316.48885},null,{"$f":"O110*$S$88","v":1316.48885},null,{"$f":"Q110*$S$88","v":2632.9776999999999}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,685.89069085000006,null,1371.7813817000001,null,1371.7813817000001,null,2743.5627634000002]
[null,null,null,null,null,null,null,null,"Summer 2021",null,714.6980998657001,null,1429.3961997314002,null,1429.3961997314002,null,2858.7923994628004]
[null,null,null,null,null,null,null,null,"Summer 2022",null,744.7154200600595,null,1489.430840120119,null,1489.430840120119,null,2978.861680240238]
[null,null,null,null,null,null,null,null,"Summer 2023",null,775.99346770258205,null,1551.9869354051641,null,1551.9869354051641,null,3103.9738708103282]
[null,null,null,null,null,null,null,null,"Summer 2024",null,808.58519334609048,null,{"$f":"M115*$S$88","v":1617.170386692181},null,1617.170386692181,null,3234.3407733843619]
[]
[null,null,null,null,null,null,null,null,"Engineering & Architecture students"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q121/4","v":1258},null,{"$f":"O121","v":2516},null,{"$f":"Q121/2","v":2516},null,5032]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K121*$S$88","v":1310.836},null,{"$f":"M121*$S$88","v":2621.672},null,{"$f":"O121*$S$88","v":2621.672},null,{"$f":"Q121*$S$88","v":5243.3440000000001}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K122*$S$88","v":1365.891112},null,{"$f":"M122*$S$88","v":2731.782224},null,{"$f":"O122*$S$88","v":2731.782224},null,5463.5644480000001]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1423.2585387040001,null,2846.5170774080002,null,2846.5170774080002,null,5693.0341548160004]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1483.0353973295682,null,2966.0707946591365,null,2966.0707946591365,null,5932.141589318273]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1545.3228840174102,null,3090.6457680348203,null,3090.6457680348203,null,6181.2915360696406]
[null,null,null,null,null,null,null,null,"Fall 2023",null,{"$f":"K126*$S$88","v":1610.2264451461415},null,3220.452890292283,null,3220.452890292283,null,6440.9057805845659]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1677.8559558422794,null,3355.7119116845588,null,3355.7119116845588,null,6711.4238233691176]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q130/4","v":1221.25},null,{"$f":"O130","v":2442.5},null,{"$f":"Q130/2","v":2442.5},null,4885]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M131/2","v":1258},null,{"$f":"O131","v":2516},null,{"$f":"Q131/2","v":2516},null,5032]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K131*$S$88","v":1310.836},null,{"$f":"M131*$S$88","v":2621.672},null,{"$f":"O131*$S$88","v":2621.672},null,{"$f":"Q131*$S$88","v":5243.3440000000001}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1365.891112,null,2731.782224,null,2731.782224,null,5463.5644480000001]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1423.2585387040001,null,2846.5170774080002,null,2846.5170774080002,null,5693.0341548160004]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1483.0353973295682,null,2966.0707946591365,null,2966.0707946591365,null,5932.141589318273]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1545.3228840174102,null,3090.6457680348203,null,3090.6457680348203,null,6181.2915360696406]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1610.2264451461415,null,3220.452890292283,null,3220.452890292283,null,6440.9057805845659]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q139/4","v":700},null,{"$f":"Q139/2","v":1400},null,{"$f":"Q139/2","v":1400},null,2800]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K139*$S$88","v":729.4},null,{"$f":"M139*$S$88","v":1458.8},null,{"$f":"O139*$S$88","v":1458.8},null,{"$f":"Q139*$S$88","v":2917.6}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K140*$S$88","v":760.03480000000002},null,{"$f":"M140*$S$88","v":1520.0696},null,{"$f":"O140*$S$88","v":1520.0696},null,{"$f":"Q140*$S$88","v":3040.1392000000001}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,791.95626160000006,null,1583.9125232000001,null,1583.9125232000001,null,3167.8250464000002]
[null,null,null,null,null,null,null,null,"Summer 2021",null,825.21842458720005,null,1650.4368491744001,null,1650.4368491744001,null,3300.8736983488002]
[null,null,null,null,null,null,null,null,"Summer 2022",null,859.87759841986247,null,1719.7551968397249,null,1719.7551968397249,null,3439.5103936794499]
[null,null,null,null,null,null,null,null,"Summer 2023",null,895.99245755349671,null,1791.9849151069934,null,1791.9849151069934,null,3583.9698302139868]
[null,null,null,null,null,null,null,null,"Summer 2024",null,933.62414077074357,null,1867.2482815414871,null,1867.2482815414871,null,3734.4965630829743]
[]
[null,null,null,null,null,null,null,null,"Business & STB"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q151/4","v":1324.5},null,{"$f":"Q151/2","v":2649},null,{"$f":"Q151/2","v":2649},null,5298]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K151*$S$88","v":1380.1290000000001},null,{"$f":"M151*$S$88","v":2760.2580000000003},null,{"$f":"O151*$S$88","v":2760.2580000000003},null,{"$f":"Q151*$S$88","v":5520.5160000000005}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K152*$S$88","v":1438.0944180000001},null,{"$f":"M152*$S$88","v":2876.1888360000003},null,{"$f":"O152*$S$88","v":2876.1888360000003},null,{"$f":"Q152*$S$88","v":5752.3776720000005}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1498.4943835560002,null,2996.9887671120005,null,2996.9887671120005,null,5993.9775342240009]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1561.4311476653522,null,3122.8622953307045,null,3122.8622953307045,null,6245.7245906614089]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1627.011255867297,null,3254.022511734594,null,3254.022511734594,null,6508.045023469188]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1695.3457286137236,null,3390.6914572274472,null,3390.6914572274472,null,6781.3829144548945]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1766.5502492155001,null,3533.1004984310002,null,3533.1004984310002,null,7066.2009968620005]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q160/4","v":1286},null,{"$f":"Q160/2","v":2572},null,{"$f":"Q160/2","v":2572},null,5144]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M161/2","v":1324.5},null,{"$f":"O161","v":2649},null,{"$f":"Q161/2","v":2649},null,5298]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K161*$S$88","v":1380.1290000000001},null,{"$f":"M161*$S$88","v":2760.2580000000003},null,{"$f":"O161*$S$88","v":2760.2580000000003},null,{"$f":"Q161*$S$88","v":5520.5160000000005}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1438.0944180000001,null,2876.1888360000003,null,2876.1888360000003,null,{"$f":"Q162*$S$88","v":5752.3776720000005}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1498.4943835560002,null,2996.9887671120005,null,2996.9887671120005,null,5993.9775342240009]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1561.4311476653522,null,3122.8622953307045,null,3122.8622953307045,null,6245.7245906614089]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1627.011255867297,null,3254.022511734594,null,3254.022511734594,null,6508.045023469188]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1695.3457286137236,null,3390.6914572274472,null,3390.6914572274472,null,6781.3829144548945]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q169/4","v":736.25},null,{"$f":"Q169/2","v":1472.5},null,{"$f":"Q169/2","v":1472.5},null,2945]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K169*$S$88","v":767.17250000000001},null,{"$f":"M169*$S$88","v":1534.345},null,{"$f":"O169*$S$88","v":1534.345},null,{"$f":"Q169*$S$88","v":3068.69}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K170*$S$88","v":799.39374500000008},null,{"$f":"M170*$S$88","v":1598.7874900000002},null,{"$f":"O170*$S$88","v":1598.7874900000002},null,{"$f":"Q170*$S$88","v":3197.5749800000003}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,832.96828229000016,null,1665.9365645800003,null,1665.9365645800003,null,3331.8731291600006]
[null,null,null,null,null,null,null,null,"Summer 2021",null,867.95295014618023,null,1735.9059002923605,null,1735.9059002923605,null,3471.8118005847209]
[null,null,null,null,null,null,null,null,"Summer 2022",null,904.40697405231981,null,1808.8139481046396,null,1808.8139481046396,null,3617.6278962092792]
[null,null,null,null,null,null,null,null,"Summer 2023",null,942.39206696251733,null,1884.7841339250347,null,1884.7841339250347,null,3769.5682678500693]
[null,null,null,null,null,null,null,null,"Summer 2024",null,981.97253377494314,null,1963.9450675498863,null,1963.9450675498863,null,3927.8901350997726]
[]
[null,null,null,null,null,null,null,null,"Specific Graduate Departments"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q181/4","v":1137.75},null,{"$f":"Q181/2","v":2275.5},null,{"$f":"Q181/2","v":2275.5},null,4551]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K181*$S$88","v":1185.5355},null,{"$f":"M181*$S$88","v":2371.0709999999999},null,{"$f":"O181*$S$88","v":2371.0709999999999},null,{"$f":"Q181*$S$88","v":4742.1419999999998}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K182*$S$88","v":1235.3279910000001},null,{"$f":"M182*$S$88","v":2470.6559820000002},null,{"$f":"O182*$S$88","v":2470.6559820000002},null,{"$f":"Q182*$S$88","v":4941.3119640000004}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1287.2117666220001,null,2574.4235332440003,null,2574.4235332440003,null,5148.8470664880006]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1341.2746608201242,null,2682.5493216402483,null,2682.5493216402483,null,5365.0986432804966]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1397.6081965745693,null,2795.2163931491386,null,2795.2163931491386,null,5590.4327862982773]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1456.3077408307013,null,2912.6154816614026,null,2912.6154816614026,null,5825.2309633228051]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1517.4726659455907,null,3034.9453318911815,null,3034.9453318911815,null,6069.8906637823629]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q190/4","v":1059.25},null,{"$f":"Q190/2","v":2118.5},null,{"$f":"Q190/2","v":2118.5},null,{"$f":"Q100","v":4237}]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"M191/2","v":1137.75},null,{"$f":"O191","v":2275.5},null,{"$f":"Q191/2","v":2275.5},null,4551]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K191*$S$88","v":1185.5355},null,{"$f":"M191*$S$88","v":2371.0709999999999},null,{"$f":"O191*$S$88","v":2371.0709999999999},null,{"$f":"Q191*$S$88","v":4742.1419999999998}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1235.3279910000001,null,2470.6559820000002,null,2470.6559820000002,null,{"$f":"Q192*$S$88","v":4941.3119640000004}]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1287.2117666220001,null,2574.4235332440003,null,2574.4235332440003,null,5148.8470664880006]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1341.2746608201242,null,2682.5493216402483,null,2682.5493216402483,null,5365.0986432804966]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1397.6081965745693,null,2795.2163931491386,null,2795.2163931491386,null,5590.4327862982773]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1456.3077408307013,null,2912.6154816614026,null,2912.6154816614026,null,5825.2309633228051]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q199/4","v":632.5},null,{"$f":"Q199/2","v":1265},null,{"$f":"Q199/2","v":1265},null,2530]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K199*$S$88","v":659.06500000000005},null,{"$f":"M199*$S$88","v":1318.13},null,{"$f":"O199*$S$88","v":1318.13},null,{"$f":"Q199*$S$88","v":2636.26}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K200*$S$88","v":686.74573000000009},null,{"$f":"M200*$S$88","v":1373.4914600000002},null,{"$f":"O200*$S$88","v":1373.4914600000002},null,{"$f":"Q200*$S$88","v":2746.9829200000004}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,715.58905066000011,null,1431.1781013200002,null,1431.1781013200002,null,2862.3562026400004]
[null,null,null,null,null,null,null,null,"Summer 2021",null,745.64379078772015,null,1491.2875815754403,null,1491.2875815754403,null,2982.5751631508806]
[null,null,null,null,null,null,null,null,"Summer 2022",null,776.96083000080444,null,1553.9216600016089,null,1553.9216600016089,null,3107.8433200032177]
[null,null,null,null,null,null,null,null,"Summer 2023",null,809.59318486083828,null,1619.1863697216766,null,1619.1863697216766,null,3238.3727394433531]
[null,null,null,null,null,null,null,null,"Summer 2024",null,843.59609862499349,null,1687.192197249987,null,1687.192197249987,null,3374.384394499974]

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

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