{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Tuition","Travel Details","SPA USE ONLY"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":23,"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":130,"n_cols":21,"rows_kept":130,"cut":false,"hidden":false,"merged":[[113,2,113,17],[68,3,68,6],[69,3,69,6],[72,3,72,6],[111,2,111,17],[73,3,73,6],[74,3,74,6],[8,18,9,18],[8,19,9,19],[100,4,100,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,9,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,"GS ______________",null,"Directions: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form Rev 8/22/2016",null,"Expand columns and rows by clicking on (+) and (-)  signs."]
["Program Sponsor",null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modify rows shown by selecting the row, select the Data tab, select Group or Ungroup"]
["Title",null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"When entering salaries, you will need to enter $0 in extra years where funding is not requested."]
["PI",null,null,"."]
["Period of Performance",null,null,"."]
["Deadline",null,null,"."]
[]
[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,"Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds"]
[null,null,null,"Salary","Calendar","Academic","Summer"]
["A",null,"Key Personnel","Monthly","Months","Months","Months",{"$f":"SUM(H13:H21)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H12+J12+L12+N12+P12)","v":0},{"$f":"SUM(I12+K12+M12+O12+Q12)","v":0},{"$f":"SUM(R12+S12)","v":0}]
[null,1,null,0,0,0,0,{"$f":"D13*(E13+F13+G13)","v":0},null,{"$f":"ROUND(H13*1.03,0)","v":0},null,{"$f":"ROUND(J13*1.03,0)","v":0},null,{"$f":"ROUND(L13*1.03,0)","v":0},null,{"$f":"ROUND(N13*1.03,0)","v":0},null,{"$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,2,null,0,0,0,0,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},0,{"$f":"SUM(R14+S14)","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(H24:H35)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H23+J23+L23+N23+P23)","v":0},{"$f":"SUM(I23+K23+M23+O23+Q23)","v":0},{"$f":"SUM(R23+S23)","v":0}]
[null,1,"Post Doc",0,0,null,0,{"$f":"D24*(E24)*G24","v":0},null,{"$f":"ROUND(H24*1.03,0)","v":0},null,{"$f":"ROUND(J24*1.03,0)","v":0},null,{"$f":"ROUND(L24*1.03,0)","v":0},null,{"$f":"ROUND(N24*1.03,0)","v":0},null,{"$f":"SUM(H24+J24+L24+N24+P24)","v":0},0,{"$f":"SUM(R24+S24)","v":0}]
[null,2,"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,0,0,0]
[null,3,"Research Asst-Halftime",0,0,null,0,{"$f":"D26*(E26)*G26","v":0},null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"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,5,"Hourly Undergraduate student",0,0,null,0,{"$f":"D28*(E28)*G28","v":0},null,0,null,0,null,0,null,0,null,0,0,0]
[null,6,"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,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":"+H12+H23","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H37+J37+L37+N37+P37)","v":0},{"$f":"SUM(I37+K37+M37+O37+Q37)","v":0},{"$f":"SUM(R37+S37)","v":0}]
[]
["C",null,"Fringe Benefits","Rate",null,null,null,{"$f":"SUM(H40:H60)","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}]
[null,null,{"$f":"+C13","v":0},0.27500000000000002,null,null,null,{"$f":"ROUND(D40*H13,0)","v":0},{"$f":"ROUND(D40*I13,0)","v":0},{"$f":"ROUND(D40*J13,0)","v":0},{"$f":"ROUND(D40*K13,0)","v":0},{"$f":"ROUND(D40*L13,0)","v":0},{"$f":"ROUND(D40*M13,0)","v":0},{"$f":"ROUND(D40*N13,0)","v":0},{"$f":"ROUND(D40*O13,0)","v":0},{"$f":"ROUND(D40*P13,0)","v":0},{"$f":"ROUND(D40*Q13,0)","v":0},{"$f":"SUM(H40+J40+L40+N40+P40)","v":0},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},0,0,0]
[null,null,{"$f":"+C15","v":0},0.27500000000000002,null,null,null,0,0,0,0,0,0,0,0,0,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":"+C24","v":"Post Doc"},0.32900000000000001,null,null,null,{"$f":"ROUND(D49*H24,0)","v":0},{"$f":"ROUND(D49*I24,0)","v":0},{"$f":"ROUND(D49*J24,0)","v":0},{"$f":"ROUND(D49*K24,0)","v":0},{"$f":"ROUND(D49*L24,0)","v":0},{"$f":"ROUND(D49*M24,0)","v":0},{"$f":"ROUND(D49*N24,0)","v":0},{"$f":"ROUND(D49*O24,0)","v":0},{"$f":"ROUND(D49*P24,0)","v":0},{"$f":"ROUND(D49*Q24,0)","v":0},0,0,0]
[null,null,"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,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C30","v":"P&S"},0.34499999999999997,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"P&S",0.34499999999999997,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.45800000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.45800000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.17100000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.17100000000000001,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries, Wages, and Benefits",null,null,null,null,{"$f":"H37+H39","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H62+J62+L62+N62+P62)","v":0},{"$f":"SUM(I62+K62+M62+O62+Q62)","v":0},{"$f":"SUM(R62+S62)","v":0}]
[]
["D",null,"Equipment (List Item and $ amount for each item > $5k)",null,null,null,null,{"$f":"SUM(H65:H66)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H64+J64+L64+N64+P64)","v":0},0,{"$f":"SUM(R64+S64)","v":0}]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R65+S65)","v":0}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R66+S66)","v":0}]
[]
["E",null,"Travel",null,null,null,null,{"$f":"SUM(H69:H70)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H68+J68+L68+N68+P68)","v":0},0,{"$f":"SUM(R68+S68)","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(R69+S69)","v":0},"Complete table on \"Travel Details\" sheet tab for NSF & USDA proposals"]
[null,null,"2. Foreign Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R70+S70)","v":0}]
[]
["F",null,"Participant Support Cost",null,null,null,null,{"$f":"SUM(H73:H76)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H72+J72+L72+N72+P72)","v":0},{"$f":"SUM(I72+K72+M72+O72+Q72)","v":0},{"$f":"SUM(R72+S72)","v":0}]
[null,null,"1. Stipend",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H73+J73+L73+N73+P73)","v":0},0,{"$f":"SUM(R73+S73)","v":0}]
[null,null,"2. Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R74+S74)","v":0}]
[null,null,"3. Subsistence",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R75+S75)","v":0}]
[null,null,"4. Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R76+S76)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H79:H93)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H78+J78+L78+N78+P78)","v":0},{"$f":"SUM(I78+K78+M78+O78+Q78)","v":0},{"$f":"SUM(R78+S78)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H79+J79+L79+N79+P79)","v":0},0,{"$f":"SUM(R79+S79)","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(H81+J81+L81+N81+P81)","v":0},{"$f":"SUM(I81+K81+M81+O81+Q81)","v":0},{"$f":"SUM(R81+S81)","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(H84+J84+L84+N84+P84)","v":0},{"$f":"SUM(I84+K84+M84+O84+Q84)","v":0},{"$f":"SUM(R84+S84)","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(H91+J91+L91+N91+P91)","v":0},{"$f":"SUM(I91+K91+M91+O91+Q91)","v":0},{"$f":"SUM(R91+S91)","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":"H62+H64+H68+H72+H78","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H95+J95+L95+N95+P95)","v":0},{"$f":"SUM(I95+K95+M95+O95+Q95)","v":0},{"$f":"SUM(R95+S95)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H95-H64-H86-H88-H89-H90-H91-H72-H84)","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,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H101:H101)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H100+J100+L100+N100+P100)","v":0},{"$f":"SUM(I100+K100+M100+O100+Q100)","v":0},{"$f":"SUM(R100+S100)","v":0}]
[null,null,"IDC on MTDC",0.5,"[ IDC = MTDC * Indirect Rate ]",null,null,{"$f":"ROUND(H97*$D$101,0)","v":0},{"$f":"ROUND(I97*$D$101,0)","v":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,"If less than full IDC rate, please modify formula to use TDC rather than MTDC"]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H95+H100","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,"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",0.13,null,null,null,0.5,"On-Campus Organized Research"]
[null,null,"D",0.33,null,null,null,0.51,"On Campus Instruction"]
[null,null,"P",0.378,null,null,null,0.32,"On-Campus Other Sponsored Activities"]
[null,null,"E",0.5,null,null,null,0.26,"Off-Campus All Programs"]
[null,null,"XH (Student hourly)",4.5999999999999999E-2]
[null,null,"XH (Non-Student hourly)",0.12]
[]
[null,null,"Post Doc Salary Range:"]
[null,null,"$38K- $80K"]
[null,null,"http://www.grad-college.iastate.edu/postdoc/advisors/policies.php"]

{"sheet":"Tuition","index":1,"n_rows":158,"n_cols":19,"rows_kept":158,"cut":false,"hidden":false,"merged":[[66,2,66,8],[2,2,2,8],[10,2,10,7],[25,2,25,5],[26,2,26,5],[27,2,27,5],[30,2,30,7],[5,2,5,5],[6,2,6,5],[7,2,7,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]]}
[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$73:$Q$99,5,FALSE)+C15*VLOOKUP(K15,$I$73:$Q$99,5,FALSE)+C17*VLOOKUP(K17,$I$73:$Q$99,5,FALSE)+C19*VLOOKUP(K19,$I$73:$Q$99,9,FALSE)+C21*VLOOKUP(K21,$I$73:$Q$99,9,FALSE)+C23*VLOOKUP(K23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$73:$Q$99,5,FALSE)+E15*VLOOKUP(M15,$I$73:$Q$99,5,FALSE)+E17*VLOOKUP(M17,$I$73:$Q$99,5,FALSE)+E19*VLOOKUP(M19,$I$73:$Q$99,9,FALSE)+E21*VLOOKUP(M21,$I$73:$Q$99,9,FALSE)+E23*VLOOKUP(M23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$73:$Q$99,5,FALSE)+F15*VLOOKUP(O15,$I$73:$Q$99,5,FALSE)+F17*VLOOKUP(O17,$I$73:$Q$99,5,FALSE)+F19*VLOOKUP(O19,$I$73:$Q$99,9,FALSE)+F21*VLOOKUP(O21,$I$73:$Q$99,9,FALSE)+F23*VLOOKUP(O23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$73:$Q$99,5,FALSE)+G15*VLOOKUP(Q15,$I$73:$Q$99,5,FALSE)+G17*VLOOKUP(Q17,$I$73:$Q$99,5,FALSE)+G19*VLOOKUP(Q19,$I$73:$Q$99,9,FALSE)+G21*VLOOKUP(Q21,$I$73:$Q$99,9,FALSE)+G23*VLOOKUP(Q23,$I$73:$Q$99,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$73:$Q$99,5,FALSE)+H15*VLOOKUP(S15,$I$73:$Q$99,5,FALSE)+H17*VLOOKUP(S17,$I$73:$Q$99,5,FALSE)+H19*VLOOKUP(S19,$I$73:$Q$99,9,FALSE)+H21*VLOOKUP(S21,$I$73:$Q$99,9,FALSE)+H23*VLOOKUP(S23,$I$73:$Q$99,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$73:$Q$99,3,FALSE)+C15*VLOOKUP(K15,$I$73:$Q$99,3,FALSE)+C17*VLOOKUP(K17,$I$73:$Q$99,3,FALSE)+C19*VLOOKUP(K19,$I$73:$Q$99,7,FALSE)+C21*VLOOKUP(K21,$I$73:$Q$99,7,FALSE)+C23*VLOOKUP(K23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$73:$Q$99,3,FALSE)+E15*VLOOKUP(M15,$I$73:$Q$99,3,FALSE)+E17*VLOOKUP(M17,$I$73:$Q$99,3,FALSE)+E19*VLOOKUP(M19,$I$73:$Q$99,7,FALSE)+E21*VLOOKUP(M21,$I$73:$Q$99,7,FALSE)+E23*VLOOKUP(M23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$73:$Q$99,3,FALSE)+F15*VLOOKUP(O15,$I$73:$Q$99,3,FALSE)+F17*VLOOKUP(O17,$I$73:$Q$99,3,FALSE)+F19*VLOOKUP(O19,$I$73:$Q$99,7,FALSE)+F21*VLOOKUP(O21,$I$73:$Q$99,7,FALSE)+F23*VLOOKUP(O23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$73:$Q$99,3,FALSE)+G15*VLOOKUP(Q15,$I$73:$Q$99,3,FALSE)+G17*VLOOKUP(Q17,$I$73:$Q$99,3,FALSE)+G19*VLOOKUP(Q19,$I$73:$Q$99,7,FALSE)+G21*VLOOKUP(Q21,$I$73:$Q$99,7,FALSE)+G23*VLOOKUP(Q23,$I$73:$Q$99,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$73:$Q$99,3,FALSE)+H15*VLOOKUP(S15,$I$73:$Q$99,3,FALSE)+H17*VLOOKUP(S17,$I$73:$Q$99,3,FALSE)+H19*VLOOKUP(S19,$I$73:$Q$99,7,FALSE)+H21*VLOOKUP(S21,$I$73:$Q$99,7,FALSE)+H23*VLOOKUP(S23,$I$73:$Q$99,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 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[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 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[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$103:$Q$129,5,FALSE)+C35*VLOOKUP(K35,$I$103:$Q$129,5,FALSE)+C37*VLOOKUP(K37,$I$103:$Q$129,5,FALSE)+C39*VLOOKUP(K39,$I$103:$Q$129,9,FALSE)+C41*VLOOKUP(K41,$I$103:$Q$129,9,FALSE)+C43*VLOOKUP(K43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$103:$Q$129,5,FALSE)+E35*VLOOKUP(M35,$I$103:$Q$129,5,FALSE)+E37*VLOOKUP(M37,$I$103:$Q$129,5,FALSE)+E39*VLOOKUP(M39,$I$103:$Q$129,9,FALSE)+E41*VLOOKUP(M41,$I$103:$Q$129,9,FALSE)+E43*VLOOKUP(M43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$103:$Q$129,5,FALSE)+F35*VLOOKUP(O35,$I$103:$Q$129,5,FALSE)+F37*VLOOKUP(O37,$I$103:$Q$129,5,FALSE)+F39*VLOOKUP(O39,$I$103:$Q$129,9,FALSE)+F41*VLOOKUP(O41,$I$103:$Q$129,9,FALSE)+F43*VLOOKUP(O43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$103:$Q$129,5,FALSE)+G35*VLOOKUP(Q35,$I$103:$Q$129,5,FALSE)+G37*VLOOKUP(Q37,$I$103:$Q$129,5,FALSE)+G39*VLOOKUP(Q39,$I$103:$Q$129,9,FALSE)+G41*VLOOKUP(Q41,$I$103:$Q$129,9,FALSE)+G43*VLOOKUP(Q43,$I$103:$Q$129,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$103:$Q$129,5,FALSE)+H35*VLOOKUP(S35,$I$103:$Q$129,5,FALSE)+H37*VLOOKUP(S37,$I$103:$Q$129,5,FALSE)+H39*VLOOKUP(S39,$I$103:$Q$129,9,FALSE)+H41*VLOOKUP(S41,$I$103:$Q$129,9,FALSE)+H43*VLOOKUP(S43,$I$103:$Q$129,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$103:$Q$129,3,FALSE)+C35*VLOOKUP(K35,$I$103:$Q$129,3,FALSE)+C37*VLOOKUP(K37,$I$103:$Q$129,3,FALSE)+C39*VLOOKUP(K39,$I$103:$Q$129,7,FALSE)+C41*VLOOKUP(K41,$I$103:$Q$129,7,FALSE)+C43*VLOOKUP(K43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$103:$Q$129,3,FALSE)+E35*VLOOKUP(M35,$I$103:$Q$129,3,FALSE)+E37*VLOOKUP(M37,$I$103:$Q$129,3,FALSE)+E39*VLOOKUP(M39,$I$103:$Q$129,7,FALSE)+E41*VLOOKUP(M41,$I$103:$Q$129,7,FALSE)+E43*VLOOKUP(M43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$103:$Q$129,3,FALSE)+F35*VLOOKUP(O35,$I$103:$Q$129,3,FALSE)+F37*VLOOKUP(O37,$I$103:$Q$129,3,FALSE)+F39*VLOOKUP(O39,$I$103:$Q$129,7,FALSE)+F41*VLOOKUP(O41,$I$103:$Q$129,7,FALSE)+F43*VLOOKUP(O43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$103:$Q$129,3,FALSE)+G35*VLOOKUP(Q35,$I$103:$Q$129,3,FALSE)+G37*VLOOKUP(Q37,$I$103:$Q$129,3,FALSE)+G39*VLOOKUP(Q39,$I$103:$Q$129,7,FALSE)+G41*VLOOKUP(Q41,$I$103:$Q$129,7,FALSE)+G43*VLOOKUP(Q43,$I$103:$Q$129,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$103:$Q$129,3,FALSE)+H35*VLOOKUP(S35,$I$103:$Q$129,3,FALSE)+H37*VLOOKUP(S37,$I$103:$Q$129,3,FALSE)+H39*VLOOKUP(S39,$I$103:$Q$129,7,FALSE)+H41*VLOOKUP(S41,$I$103:$Q$129,7,FALSE)+H43*VLOOKUP(S43,$I$103:$Q$129,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 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[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 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[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$133:$Q$159,5,FALSE)+C55*VLOOKUP(K55,$I$133:$Q$159,5,FALSE)+C57*VLOOKUP(K57,$I$133:$Q$159,5,FALSE)+C59*VLOOKUP(K59,$I$133:$Q$159,9,FALSE)+C61*VLOOKUP(K61,$I$133:$Q$159,9,FALSE)+C63*VLOOKUP(K63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$133:$Q$159,5,FALSE)+E55*VLOOKUP(M55,$I$133:$Q$159,5,FALSE)+E57*VLOOKUP(M57,$I$133:$Q$159,5,FALSE)+E59*VLOOKUP(M59,$I$133:$Q$159,9,FALSE)+E61*VLOOKUP(M61,$I$133:$Q$159,9,FALSE)+E63*VLOOKUP(M63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$133:$Q$159,5,FALSE)+F55*VLOOKUP(O55,$I$133:$Q$159,5,FALSE)+F57*VLOOKUP(O57,$I$133:$Q$159,5,FALSE)+F59*VLOOKUP(O59,$I$133:$Q$159,9,FALSE)+F61*VLOOKUP(O61,$I$133:$Q$159,9,FALSE)+F63*VLOOKUP(O63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$133:$Q$159,5,FALSE)+G55*VLOOKUP(Q55,$I$133:$Q$159,5,FALSE)+G57*VLOOKUP(Q57,$I$133:$Q$159,5,FALSE)+G59*VLOOKUP(Q59,$I$133:$Q$159,9,FALSE)+G61*VLOOKUP(Q61,$I$133:$Q$159,9,FALSE)+G63*VLOOKUP(Q63,$I$133:$Q$159,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$133:$Q$159,5,FALSE)+H55*VLOOKUP(S55,$I$133:$Q$159,5,FALSE)+H57*VLOOKUP(S57,$I$133:$Q$159,5,FALSE)+H59*VLOOKUP(S59,$I$133:$Q$159,9,FALSE)+H61*VLOOKUP(S61,$I$133:$Q$159,9,FALSE)+H63*VLOOKUP(S63,$I$133:$Q$159,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$133:$Q$159,3,FALSE)+C55*VLOOKUP(K55,$I$133:$Q$159,3,FALSE)+C57*VLOOKUP(K57,$I$133:$Q$159,3,FALSE)+C59*VLOOKUP(K59,$I$133:$Q$159,7,FALSE)+C61*VLOOKUP(K61,$I$133:$Q$159,7,FALSE)+C63*VLOOKUP(K63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$133:$Q$159,3,FALSE)+E55*VLOOKUP(M55,$I$133:$Q$159,3,FALSE)+E57*VLOOKUP(M57,$I$133:$Q$159,3,FALSE)+E59*VLOOKUP(M59,$I$133:$Q$159,7,FALSE)+E61*VLOOKUP(M61,$I$133:$Q$159,7,FALSE)+E63*VLOOKUP(M63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$133:$Q$159,3,FALSE)+F55*VLOOKUP(O55,$I$133:$Q$159,3,FALSE)+F57*VLOOKUP(O57,$I$133:$Q$159,3,FALSE)+F59*VLOOKUP(O59,$I$133:$Q$159,7,FALSE)+F61*VLOOKUP(O61,$I$133:$Q$159,7,FALSE)+F63*VLOOKUP(O63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$133:$Q$159,3,FALSE)+G55*VLOOKUP(Q55,$I$133:$Q$159,3,FALSE)+G57*VLOOKUP(Q57,$I$133:$Q$159,3,FALSE)+G59*VLOOKUP(Q59,$I$133:$Q$159,7,FALSE)+G61*VLOOKUP(Q61,$I$133:$Q$159,7,FALSE)+G63*VLOOKUP(Q63,$I$133:$Q$159,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$133:$Q$159,3,FALSE)+H55*VLOOKUP(S55,$I$133:$Q$159,3,FALSE)+H57*VLOOKUP(S57,$I$133:$Q$159,3,FALSE)+H59*VLOOKUP(S59,$I$133:$Q$159,7,FALSE)+H61*VLOOKUP(S61,$I$133:$Q$159,7,FALSE)+H63*VLOOKUP(S63,$I$133:$Q$159,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,"Summer",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[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 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[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,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 2016",null,{"$f":"Q73/4","v":1059.25},null,{"$f":"O73","v":2118.5},null,{"$f":"Q73/2","v":2118.5},null,4237]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K73*$S$70","v":1103.7384999999999},{"$f":"L73*$S$70","v":0},2207.4769999999999,0,2207.4769999999999,0,{"$f":"Q73*$S$70","v":4414.9539999999997}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K74*$S$70","v":1150.095517},null,2300.1910339999999,null,2300.1910339999999,null,4600.3820679999999]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1198.3995287140001,null,2396.7990574280002,null,2396.7990574280002,null,4793.5981148560004]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1248.7323089199881,null,2497.4646178399762,null,2497.4646178399762,null,4994.9292356799524]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1301.1790658946277,null,2602.3581317892554,null,2602.3581317892554,null,5204.7162635785107]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1355.828586662202,null,2711.6571733244041,null,2711.6571733244041,null,5423.3143466488082]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1412.7733873020145,null,2825.546774604029,null,2825.546774604029,null,5651.093549208058]
[]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q82/4","v":1059.25},null,{"$f":"Q82/2","v":2118.5},null,{"$f":"Q82/2","v":2118.5},null,{"$f":"Q73","v":4237}]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K82*$S$70","v":1103.7384999999999},null,{"$f":"M82*$S$70","v":2207.4769999999999},null,{"$f":"O82*$S$70","v":2207.4769999999999},null,{"$f":"Q82*$S$70","v":4414.9539999999997}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K83*$S$70","v":1150.095517},null,{"$f":"M83*$S$70","v":2300.1910339999999},null,{"$f":"O83*$S$70","v":2300.1910339999999},null,{"$f":"Q83*$S$70","v":4600.3820679999999}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1198.3995287140001,null,2396.7990574280002,null,2396.7990574280002,null,4793.5981148560004]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1248.7323089199881,null,2497.4646178399762,null,2497.4646178399762,null,4994.9292356799524]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1301.1790658946277,null,2602.3581317892554,null,2602.3581317892554,null,5204.7162635785107]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1355.828586662202,null,2711.6571733244041,null,2711.6571733244041,null,5423.3143466488082]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1412.7733873020145,null,2825.546774604029,null,2825.546774604029,null,5651.093549208058]
[]
[null,null,null,null,null,null,null,null,"Summer 2016",null,{"$f":"Q91/4","v":582.5},null,{"$f":"Q91/2","v":1165},null,{"$f":"Q91/2","v":1165},null,2330]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"K91*$S$70","v":606.96500000000003},null,{"$f":"M91*$S$70","v":1213.93},null,{"$f":"O91*$S$70","v":1213.93},null,{"$f":"Q91*S70","v":2427.86}]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K92*$S$70","v":632.45753000000002},null,{"$f":"M92*$S$70","v":1264.91506},null,{"$f":"O92*$S$70","v":1264.91506},null,{"$f":"Q92*$S$70","v":2529.8301200000001}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,659.02074626000001,null,1318.04149252,null,1318.04149252,null,2636.08298504]
[null,null,null,null,null,null,null,null,"Summer 2020",null,686.69961760292006,null,1373.3992352058401,null,1373.3992352058401,null,2746.7984704116802]
[null,null,null,null,null,null,null,null,"Summer 2021",null,715.54100154224273,null,1431.0820030844855,null,1431.0820030844855,null,2862.1640061689709]
[null,null,null,null,null,null,null,null,"Summer 2022",null,745.59372360701695,null,1491.1874472140339,null,1491.1874472140339,null,2982.3748944280678]
[null,null,null,null,null,null,null,null,"Summer 2023",null,776.90865999851167,null,1553.8173199970233,null,1553.8173199970233,null,3107.6346399940467]
[]
[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 2016",null,{"$f":"Q103/4","v":1221.25},null,{"$f":"O103","v":2442.5},null,{"$f":"Q103/2","v":2442.5},null,4885]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K103*$S$70","v":1272.5425},null,{"$f":"M103*$S$70","v":2545.085},null,{"$f":"O103*$S$70","v":2545.085},null,{"$f":"Q103*$S$70","v":5090.17}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K104*$S$70","v":1325.9892850000001},null,{"$f":"M104*$S$70","v":2651.9785700000002},null,{"$f":"O104*$S$70","v":2651.9785700000002},null,5303.9571400000004]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1381.6808349700002,null,2763.3616699400004,null,2763.3616699400004,null,5526.7233398800008]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1439.7114300387402,null,2879.4228600774804,null,2879.4228600774804,null,5758.8457201549609]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1500.1793101003673,null,3000.3586202007345,null,3000.3586202007345,null,6000.7172404014691]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1563.1868411245828,null,3126.3736822491655,null,3126.3736822491655,null,6252.7473644983311]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1628.8406884518154,null,3257.6813769036307,null,3257.6813769036307,null,6515.3627538072615]
[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":"Q112/4","v":1221.25},null,{"$f":"O112","v":2442.5},null,{"$f":"Q112/2","v":2442.5},null,4885]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K112*$S$70","v":1272.5425},null,{"$f":"M112*$S$70","v":2545.085},null,{"$f":"O112*$S$70","v":2545.085},null,{"$f":"Q112*$S$70","v":5090.17}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K113*$S$70","v":1325.9892850000001},null,{"$f":"M113*$S$70","v":2651.9785700000002},null,{"$f":"O113*$S$70","v":2651.9785700000002},null,{"$f":"Q113*$S$70","v":5303.9571400000004}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1381.6808349700002,null,2763.3616699400004,null,2763.3616699400004,null,5526.7233398800008]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1439.7114300387402,null,2879.4228600774804,null,2879.4228600774804,null,5758.8457201549609]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1500.1793101003673,null,3000.3586202007345,null,3000.3586202007345,null,6000.7172404014691]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1563.1868411245828,null,3126.3736822491655,null,3126.3736822491655,null,6252.7473644983311]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1628.8406884518154,null,3257.6813769036307,null,3257.6813769036307,null,6515.3627538072615]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2016",null,{"$f":"Q121/4","v":671.25},null,{"$f":"Q121/2","v":1342.5},null,{"$f":"Q121/2","v":1342.5},null,2685]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"K121*$S$70","v":699.4425},null,{"$f":"M121*$S$70","v":1398.885},null,{"$f":"O121*$S$70","v":1398.885},null,{"$f":"Q121*$S$70","v":2797.77}]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K122*$S$70","v":728.81908499999997},null,{"$f":"M122*$S$70","v":1457.6381699999999},null,{"$f":"O122*$S$70","v":1457.6381699999999},null,2915.2763399999999]
[null,null,null,null,null,null,null,null,"Summer 2019",null,759.42948656999999,null,1518.85897314,null,1518.85897314,null,3037.71794628]
[null,null,null,null,null,null,null,null,"Summer 2020",null,791.32552500593999,null,1582.65105001188,null,1582.65105001188,null,3165.30210002376]
[null,null,null,null,null,null,null,null,"Summer 2021",null,824.56119705618949,null,1649.122394112379,null,1649.122394112379,null,3298.2447882247579]
[null,null,null,null,null,null,null,null,"Summer 2022",null,859.19276733254947,null,1718.3855346650989,null,1718.3855346650989,null,3436.7710693301979]
[null,null,null,null,null,null,null,null,"Summer 2023",null,895.27886356051658,null,1790.5577271210332,null,1790.5577271210332,null,3581.1154542420663]
[]
[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 2016",null,{"$f":"Q133/4","v":1286},null,{"$f":"Q133/2","v":2572},null,{"$f":"Q133/2","v":2572},null,5144]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K133*$S$70","v":1340.0119999999999},null,{"$f":"M133*$S$70","v":2680.0239999999999},null,{"$f":"O133*$S$70","v":2680.0239999999999},null,{"$f":"Q133*$S$70","v":5360.0479999999998}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K134*$S$70","v":1396.292504},null,{"$f":"M134*$S$70","v":2792.585008},null,{"$f":"O134*$S$70","v":2792.585008},null,{"$f":"Q134*$S$70","v":5585.170016}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1454.9367891680001,null,2909.8735783360003,null,2909.8735783360003,null,5819.7471566720005]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1516.0441343130562,null,3032.0882686261125,null,3032.0882686261125,null,6064.176537252225]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1579.7179879542048,null,3159.4359759084095,null,3159.4359759084095,null,6318.8719518168191]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1646.0661434482815,null,3292.1322868965631,null,3292.1322868965631,null,6584.2645737931261]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1715.2009214731095,null,3430.4018429462189,null,3430.4018429462189,null,6860.8036858924379]
[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":"Q142/4","v":1286},null,{"$f":"Q142/2","v":2572},null,{"$f":"Q142/2","v":2572},null,5144]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K142*$S$70","v":1340.0119999999999},null,{"$f":"M142*$S$70","v":2680.0239999999999},null,{"$f":"O142*$S$70","v":2680.0239999999999},null,{"$f":"Q142*$S$70","v":5360.0479999999998}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K143*$S$70","v":1396.292504},null,{"$f":"M143*$S$70","v":2792.585008},null,{"$f":"O143*$S$70","v":2792.585008},null,{"$f":"Q143*$S$70","v":5585.170016}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1454.9367891680001,null,2909.8735783360003,null,2909.8735783360003,null,5819.7471566720005]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1516.0441343130562,null,3032.0882686261125,null,3032.0882686261125,null,6064.176537252225]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1579.7179879542048,null,3159.4359759084095,null,3159.4359759084095,null,6318.8719518168191]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1646.0661434482815,null,3292.1322868965631,null,3292.1322868965631,null,6584.2645737931261]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1715.2009214731095,null,3430.4018429462189,null,3430.4018429462189,null,6860.8036858924379]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2016",null,{"$f":"Q151/4","v":706.25},null,{"$f":"Q151/2","v":1412.5},null,{"$f":"Q151/2","v":1412.5},null,2825]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"K151*$S$70","v":735.91250000000002},null,{"$f":"M151*$S$70","v":1471.825},null,{"$f":"O151*$S$70","v":1471.825},null,{"$f":"Q151*$S$70","v":2943.65}]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K152*$S$70","v":766.82082500000001},null,{"$f":"M152*$S$70","v":1533.64165},null,{"$f":"O152*$S$70","v":1533.64165},null,{"$f":"Q152*$S$70","v":3067.2833000000001}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,799.02729965000003,null,1598.0545993000001,null,1598.0545993000001,null,3196.1091986000001]
[null,null,null,null,null,null,null,null,"Summer 2020",null,832.58644623530006,null,1665.1728924706001,null,1665.1728924706001,null,3330.3457849412002]
[null,null,null,null,null,null,null,null,"Summer 2021",null,867.55507697718269,null,1735.1101539543654,null,1735.1101539543654,null,3470.2203079087308]
[null,null,null,null,null,null,null,null,"Summer 2022",null,903.99239021022436,null,1807.9847804204487,null,1807.9847804204487,null,3615.9695608408974]
[null,null,null,null,null,null,null,null,"Summer 2023",null,941.96007059905378,null,1883.9201411981076,null,1883.9201411981076,null,3767.8402823962151]

{"sheet":"Travel Details","index":2,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,2,9]]}
["Only use this sheet tab if the sponsor requires a detailed breakdown of your travel (Ex: NSF and USDA)"]
["Complete table; Copy & Paste (special - picture) into the Budget Justification"]
["TRAVEL DETAILS"]
["Year","Purpose of Travel/\nDestination","No. of Travelers","Estim.\nAirfare","Nights\nper Trip","Lodging\n Rate","Days","Per\nDiem","Misc.*","TOTAL",null,null,"Totals from Travel on SUMMARY Sheet Tab"]
[null,"DOMESTIC TRAVEL",null,null,null,null,null,null,null,null,null,null," "]
[1,"____ Conference",1,0,0,0,0,40,0,{"$f":"C6*(((D6)+(E6*F6)+(H6*G6))+(I6))","v":0},null,null,{"$f":"Summary!H69","v":0}]
[null,"(Location or TBD)"]
[2,"____ Conference",1,0,0,0,0,40,0,{"$f":"C8*(((D8)+(E8*F8)+(H8*G8))+(I8))","v":0},null,null,{"$f":"Summary!J69","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
[3,"____ Conference",1,0,0,0,0,40,0,{"$f":"C10*(((D10)+(E10*F10)+(H10*G10))+(I10))","v":0},null,null,{"$f":"Summary!L69","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
[4,"____ Conference",1,0,0,0,0,40,0,{"$f":"C12*(((D12)+(E12*F12)+(H12*G12))+(I12))","v":0},null,null,{"$f":"Summary!N69","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
[5,"____ Conference",1,0,0,0,0,40,0,{"$f":"C14*(((D14)+(E14*F14)+(H14*G14))+(I14))","v":0},null,null,{"$f":"Summary!P69","v":0}]
[null,"(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},null,null,{"$f":"Summary!T69","v":0}]
[]
["INTERNATIONAL TRAVEL","FOREIGN TRAVEL",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,null,1,0,0,0,0,0,0,{"$f":"C19*(((D19)+(E19*F19)+(H19*G19))+(I19))","v":0},null,null,{"$f":"Summary!H70","v":0}]
[null,"(Location or TBD)"]
[2,null,1,0,0,0,0,0,0,{"$f":"C21*(((D21)+(E21*F21)+(H21*G21))+(I21))","v":0},null,null,{"$f":"Summary!J70","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
[3,null,1,0,0,0,0,0,0,{"$f":"C23*(((D23)+(E23*F23)+(H23*G23))+(I23))","v":0},null,null,{"$f":"Summary!L70","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
[4,null,1,0,0,0,0,0,0,{"$f":"C25*(((D25)+(E25*F25)+(H25*G25))+(I25))","v":0},null,null,{"$f":"Summary!N70","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
[5,null,1,0,0,0,0,0,0,{"$f":"C27*(((D27)+(E27*F27)+(H27*G27))+(I27))","v":0},null,null,{"$f":"Summary!P70","v":0}]
[null,"(Location or TBD)",null,null,null,null,null,null," "]
["TOTAL FOREIGN TRAVEL",null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J28)","v":0},null,null,{"$f":"Summary!T70","v":0}]
[]
["TOTAL DOMESTIC AND FOREIGN TRAVEL",null,null,null,null,null,null,null,null,{"$f":"J16+J29","v":0},null,null,{"$f":"Summary!T68","v":0}]
["* Miscellaneous:  Registration fees, Mileage to Airport, Parking at Airport, Shuttles, Other."]
[" "]

{"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!R37,0)","v":0}]
["Payroll Benefits","0130",{"$f":"ROUND(Summary!R39,0)","v":0}]
["Equipment","0710",{"$f":"ROUND(Summary!R64,0)","v":0}]
["Travel Domestic","0215",{"$f":"ROUND(Summary!R69+Summary!R74+Summary!R75,0)","v":0}]
["Travel Foreign","0216",{"$f":"ROUND(Summary!R70,0)","v":0}]
["Student Tuition","0610",{"$f":"ROUND(SUM(Summary!R89:R91),0)","v":0}]
["Supplies","0410",{"$f":"ROUND(Summary!R79,0)","v":0}]
["Subcontracts"]
["Subject to IDC","0396",{"$f":"ROUND(Summary!R85+Summary!R87,0)","v":0}]
["Not Subejct to IDC","0376",{"$f":"ROUND(Summary!R86+Summary!R88,0)","v":0}]
["Other Direct Costs"]
["Computer Usage","0353",{"$f":"ROUND(Summary!R82,0)","v":0}]
["Printing/Copying","0373",{"$f":"ROUND(Summary!R80,0)","v":0}]
["Services/Honoraria","0302",{"$f":"ROUND(Summary!R73+Summary!R81,0)","v":0}]
["Other  ","0630",{"$f":"ROUND(Summary!R83+Summary!R92+Summary!R93+Summary!R76+Summary!R84,0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C8:C22)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND(Summary!R101,0)","v":0}]
["Total Costs",null,{"$f":"SUM(C23:C24)","v":0}]