{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Tuition","BA Upload"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":22,"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":128,"n_cols":20,"rows_kept":128,"cut":false,"hidden":false,"merged":[[113,2,113,17],[68,3,68,6],[69,3,69,6],[72,3,72,6],[109,2,109,17],[73,3,73,6],[74,3,74,6],[8,18,9,18],[8,19,9,19],[98,4,98,6],[0,18,0,19],[111,2,111,17],[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,"Eff. 7/1/2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 6/30/2014"]
["Program Sponsor"]
["Title"]
["PI"]
["Period of Performance"]
["Deadline"]
[]
[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,"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(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,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.315,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.315,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.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C16","v":0},0.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C17","v":0},0.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C18","v":0},0.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C19","v":0},0.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C20","v":0},0.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C21","v":0},0.315,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C24","v":"Post Doc"},0.33,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.33,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",0.13,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",0.13,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",4.5999999999999999E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",4.5999999999999999E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C30","v":"P&S"},0.378,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"P&S",0.378,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C32","v":"Secretarial/Clerical"},0.51,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.51,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.12,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",0.12,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},{"$f":"SUM(I64+K64+M64+O64+Q64)","v":0},{"$f":"SUM(R64+S64)","v":0}]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H65+J65+L65+N65+P65)","v":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,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},{"$f":"SUM(I68+K68+M68+O68+Q68)","v":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,{"$f":"SUM(H69+J69+L69+N69+P69)","v":0},0,{"$f":"SUM(R69+S69)","v":0}]
[null,null,"2. Foreign Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[]
["F",null,"Participant Support Cost",null,"See notes below",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,0]
[null,null,"3. Subsistence",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"4. Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H79:H91)","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,"Computing support",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"Instrumentation facility",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,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(H89+J89+L89+N89+P89)","v":0},{"$f":"SUM(I89+K89+M89+O89+Q89)","v":0},{"$f":"SUM(R89+S89)","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(H93+J93+L93+N93+P93)","v":0},{"$f":"SUM(I93+K93+M93+O93+Q93)","v":0},{"$f":"SUM(R93+S93)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H93-H64-H84-H86-H87-H88)","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,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H99:H99)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H98+J98+L98+N98+P98)","v":0},{"$f":"SUM(I98+K98+M98+O98+Q98)","v":0},{"$f":"SUM(R98+S98)","v":0}]
[null,null,"IDC on MTDC",0.5,"[ IDC = MTDC * Indirect Rate ]",null,null,{"$f":"ROUND(H95*$D$99,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H99+J99+L99+N99+P99)","v":0},0,{"$f":"SUM(R99+S99)","v":0}]
[]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H93+H98","v":0},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,"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,"Participant Support Costs - These are included in the MTDC for this budget.  Please note that if this is for an NSF budget, you will need to exclude it in the MTDC line."]
[]
[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.315]
[null,null,"C",0.13,null,null,null,0.5,"On-Campus Organized Research"]
[null,null,"D",0.23,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":[[129,8,129,16],[99,8,99,16],[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 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[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 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[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 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[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 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[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 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[]
[]
[]
[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 2014",null,999,null,1998,null,1998,null,3995]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K73*$S$70","v":1040.9580000000001},null,{"$f":"M73*$S$70","v":2081.9160000000002},null,{"$f":"O73*$S$70","v":2081.9160000000002},null,{"$f":"Q73*$S$70","v":4162.79}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,{"$f":"K74*$S$70","v":1084.6782360000002},null,2169.3564720000004,null,2169.3564720000004,null,4337.6271800000004]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1130.2347219120002,null,2260.4694438240003,null,2260.4694438240003,null,4519.8075215600002]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1177.7045802323041,null,2355.4091604646082,null,2355.4091604646082,null,4709.6394374655201]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1227.1681726020608,null,2454.3363452041217,null,2454.3363452041217,null,4907.4442938390721]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1278.7092358513476,null,2557.4184717026951,null,2557.4184717026951,null,5113.5569541803134]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1332.4150237571041,null,2664.8300475142082,null,2664.8300475142082,null,5328.3263462558871]
[]
[null,null,null,null,null,null,null,null,"Spring 2015",null,998.75,null,1998,null,1998,null,3995]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K82*$S$70","v":1040.6975},null,{"$f":"M82*$S$70","v":2081.9160000000002},null,{"$f":"O82*$S$70","v":2081.9160000000002},null,{"$f":"Q82*$S$70","v":4162.79}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1084.4067950000001,null,2169.3564720000004,null,2169.3564720000004,null,4337.6271800000004]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1129.95188039,null,2260.4694438240003,null,2260.4694438240003,null,4519.8075215600002]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1177.40985936638,null,2355.4091604646082,null,2355.4091604646082,null,4709.6394374655201]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1226.861073459768,null,2454.3363452041217,null,2454.3363452041217,null,4907.4442938390721]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1278.3892385450783,null,2557.4184717026951,null,2557.4184717026951,null,5113.5569541803134]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1332.0815865639718,null,2664.8300475142082,null,2664.8300475142082,null,5328.3263462558871]
[]
[null,null,null,null,null,null,null,null,"Summer 2014",null,555,null,1110,null,1110,null,2220]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K91*$S$70","v":578.31000000000006},null,{"$f":"M91*$S$70","v":1156.6200000000001},null,{"$f":"O91*$S$70","v":1156.6200000000001},null,{"$f":"Q91*$S$70","v":2313.2400000000002}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,602.59902000000011,null,1205.1980400000002,null,1205.1980400000002,null,2410.3960800000004]
[null,null,null,null,null,null,null,null,"Summer 2017",null,627.90817884000012,null,1255.8163576800002,null,1255.8163576800002,null,2511.6327153600005]
[null,null,null,null,null,null,null,null,"Summer 2018",null,654.28032235128012,null,1308.5606447025602,null,1308.5606447025602,null,2617.1212894051205]
[null,null,null,null,null,null,null,null,"Summer 2019",null,681.76009589003388,null,1363.5201917800678,null,1363.5201917800678,null,2727.0403835601355]
[null,null,null,null,null,null,null,null,"Summer 2020",null,710.39401991741533,null,1420.7880398348307,null,1420.7880398348307,null,2841.5760796696613]
[null,null,null,null,null,null,null,null,"Summer 2021",null,740.23056875394684,null,1480.4611375078937,null,1480.4611375078937,null,2960.9222750157874]
[]
[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 2014",null,1151.25,null,2302.5,null,2302.5,null,4605]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K103*$S$70","v":1199.6025},null,{"$f":"M103*$S$70","v":2399.2049999999999},null,{"$f":"O103*$S$70","v":2399.2049999999999},null,{"$f":"Q103*$S$70","v":4798.41}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1249.985805,null,2499.9716100000001,null,2499.9716100000001,null,4999.9432200000001]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1302.4852088100001,null,2604.9704176200003,null,2604.9704176200003,null,5209.9408352400005]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1357.1895875800201,null,2714.3791751600402,null,2714.3791751600402,null,5428.7583503200804]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1414.1915502583811,null,2828.3831005167622,null,2828.3831005167622,null,5656.7662010335243]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1473.5875953692332,null,2947.1751907384664,null,2947.1751907384664,null,5894.3503814769329]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1535.478274374741,null,3070.956548749482,null,3070.956548749482,null,6141.9130974989639]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2015",null,1151.25,null,2302.5,null,2302.5,null,4605]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K112*$S$70","v":1199.6025},null,{"$f":"M112*$S$70","v":2399.2049999999999},null,{"$f":"O112*$S$70","v":2399.2049999999999},null,{"$f":"Q112*$S$70","v":4798.41}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1249.985805,null,2499.9716100000001,null,2499.9716100000001,null,4999.9432200000001]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1302.4852088100001,null,2604.9704176200003,null,2604.9704176200003,null,5209.9408352400005]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1357.1895875800201,null,2714.3791751600402,null,2714.3791751600402,null,5428.7583503200804]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1414.1915502583811,null,2828.3831005167622,null,2828.3831005167622,null,5656.7662010335243]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1473.5875953692332,null,2947.1751907384664,null,2947.1751907384664,null,5894.3503814769329]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1535.478274374741,null,3070.956548749482,null,3070.956548749482,null,6141.9130974989639]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2014",null,640,null,1280,null,1280,null,2560]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K121*$S$70","v":666.88},null,{"$f":"M121*$S$70","v":1333.76},null,{"$f":"O121*$S$70","v":1333.76},null,{"$f":"Q121*$S$70","v":2667.52}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,694.88896,null,1389.77792,null,1389.77792,null,2779.55584]
[null,null,null,null,null,null,null,null,"Summer 2017",null,724.07429632000003,null,1448.1485926400001,null,1448.1485926400001,null,2896.2971852800001]
[null,null,null,null,null,null,null,null,"Summer 2018",null,754.48541676544005,null,1508.9708335308801,null,1508.9708335308801,null,3017.9416670617602]
[null,null,null,null,null,null,null,null,"Summer 2019",null,786.17380426958857,null,1572.3476085391771,null,1572.3476085391771,null,3144.6952170783543]
[null,null,null,null,null,null,null,null,"Summer 2020",null,819.19310404891132,null,1638.3862080978226,null,1638.3862080978226,null,3276.7724161956453]
[null,null,null,null,null,null,null,null,"Summer 2021",null,853.59921441896563,null,1707.1984288379313,null,1707.1984288379313,null,3414.3968576758625]
[]
[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 2014",null,1213,null,2425,null,2425,null,4850]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K133*$S$70","v":1263.9460000000001},null,{"$f":"M133*$S$70","v":2526.85},null,{"$f":"O133*$S$70","v":2526.85},null,{"$f":"Q133*$S$70","v":5053.7}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1317.0317320000001,null,2632.9776999999999,null,2632.9776999999999,null,5265.9553999999998]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1372.3470647440001,null,2743.5627634000002,null,2743.5627634000002,null,5487.1255268000004]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1429.9856414632482,null,2858.7923994628004,null,2858.7923994628004,null,5717.5847989256008]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1490.0450384047047,null,2978.861680240238,null,2978.861680240238,null,5957.723360480476]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1552.6269300177023,null,3103.9738708103282,null,3103.9738708103282,null,6207.9477416206564]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1617.8372610784459,null,3234.3407733843619,null,3234.3407733843619,null,6468.6815467687238]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2015",null,1213,null,2425,null,2425,null,4850]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K142*$S$70","v":1263.9460000000001},null,{"$f":"M142*$S$70","v":2526.85},null,{"$f":"O142*$S$70","v":2526.85},null,{"$f":"Q142*$S$70","v":5053.7}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1317.0317320000001,null,2632.9776999999999,null,2632.9776999999999,null,5265.9553999999998]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1372.3470647440001,null,2743.5627634000002,null,2743.5627634000002,null,5487.1255268000004]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1429.9856414632482,null,2858.7923994628004,null,2858.7923994628004,null,5717.5847989256008]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1490.0450384047047,null,2978.861680240238,null,2978.861680240238,null,5957.723360480476]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1552.6269300177023,null,3103.9738708103282,null,3103.9738708103282,null,6207.9477416206564]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1617.8372610784459,null,3234.3407733843619,null,3234.3407733843619,null,6468.6815467687238]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2014",null,674,null,1348,null,1348,null,2695]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K151*$S$70","v":702.30799999999999},null,{"$f":"M151*$S$70","v":1404.616},null,{"$f":"O151*$S$70","v":1404.616},null,{"$f":"Q151*$S$70","v":2808.19}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,731.804936,null,1463.609872,null,1463.609872,null,2926.1339800000001]
[null,null,null,null,null,null,null,null,"Summer 2017",null,762.54074331200002,null,1525.081486624,null,1525.081486624,null,3049.03160716]
[null,null,null,null,null,null,null,null,"Summer 2018",null,794.56745453110409,null,1589.1349090622082,null,1589.1349090622082,null,3177.09093466072]
[null,null,null,null,null,null,null,null,"Summer 2019",null,827.93928762141047,null,1655.8785752428209,null,1655.8785752428209,null,3310.5287539164706]
[null,null,null,null,null,null,null,null,"Summer 2020",null,862.7127377015097,null,1725.4254754030194,null,1725.4254754030194,null,3449.5709615809624]
[null,null,null,null,null,null,null,null,"Summer 2021",null,898.94667268497312,null,1797.8933453699462,null,1797.8933453699462,null,3594.4529419673631]

{"sheet":"BA Upload","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Sponsor:",{"$f":"Summary!D3","v":0}]
["Title: ",{"$f":"Summary!D4","v":0}]
["PI Name: ",{"$f":"Summary!D5","v":0}]
["Period of Performance:",{"$f":"Summary!D6","v":"00:00:00"}]
["Account Number:"]
[]
["Budget Categories","Budget Code","Amount"]
["Salary/Hourly","0108",{"$f":"ROUND(Summary!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!R87:R89),0)","v":0}]
["Supplies","0410",{"$f":"ROUND(Summary!R79,0)","v":0}]
["Subcontracts"]
["Subject to IDC","0396",{"$f":"ROUND(Summary!R83+Summary!R85,0)","v":0}]
["Not Subejct to IDC","0376",{"$f":"ROUND(Summary!R84+Summary!R86,0)","v":0}]
["Other Direct Costs"]
["Telecom Charges","0340",0]
["Computer Usage","0353",{"$f":"ROUND(Summary!R81,0)","v":0}]
["Printing/Copying","0373",{"$f":"ROUND(Summary!R80,0)","v":0}]
["Services/Honoraria","0302",{"$f":"ROUND(Summary!R73,0)","v":0}]
["Postage","0379",0]
["Other  ","0630",{"$f":"ROUND(Summary!R82+Summary!R90+Summary!R91+Summary!R76,0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C8:C24)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND(Summary!R99,0)","v":0}]
["Total Costs",null,{"$f":"SUM(C25:C26)","v":0}]