{"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":127,"n_cols":20,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,18,9,18],[8,19,9,19],[97,4,97,6],[0,18,0,19],[110,2,110,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],[112,2,112,17],[68,3,68,6],[69,3,69,6],[72,3,72,6],[108,2,108,17],[73,3,73,6],[74,3,74,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. 7/1/2013"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 7/5/2013"]
["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,{"$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,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.23,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.23,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.5,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.5,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:H90)","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 - Non-Engineering","(Click on \"Tuition\" sheet)",null,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","(Click on \"Tuition\" sheet)",null,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,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(H92+J92+L92+N92+P92)","v":0},{"$f":"SUM(I92+K92+M92+O92+Q92)","v":0},{"$f":"SUM(R92+S92)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H92-H64-H84-H86-H87-H88)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H94+J94+L94+N94+P94)","v":0},{"$f":"SUM(I94+K94+M94+O94+Q94)","v":0},{"$f":"SUM(R94+S94)","v":0}]
[null,null,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H98:H98)","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,"IDC on MTDC",0.5,"[ IDC = MTDC * Indirect Rate ]",null,null,{"$f":"ROUND(H94*$D$98,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H98+J98+L98+N98+P98)","v":0},0,{"$f":"SUM(R98+S98)","v":0}]
[]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H92+H97","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H101+J101+L101+N101+P101)","v":0},{"$f":"SUM(I101+K101+M101+O101+Q101)","v":0},{"$f":"SUM(R101+S101)","v":0}]
[]
[]
[]
[]
[]
[null,null,"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":108,"n_cols":19,"rows_kept":108,"cut":false,"hidden":false,"merged":[[79,8,79,16],[46,2,46,8],[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],[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],[2,2,2,8],[10,2,10,7]]}
[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 (NON-ENGINEERING)",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$53:$Q$109,5,FALSE)+C15*VLOOKUP(K15,$I$53:$Q$109,5,FALSE)+C17*VLOOKUP(K17,$I$53:$Q$109,5,FALSE)+C19*VLOOKUP(K19,$I$53:$Q$109,9,FALSE)+C21*VLOOKUP(K21,$I$53:$Q$109,9,FALSE)+C23*VLOOKUP(K23,$I$53:$Q$109,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$53:$Q$109,5,FALSE)+E15*VLOOKUP(M15,$I$53:$Q$109,5,FALSE)+E17*VLOOKUP(M17,$I$53:$Q$109,5,FALSE)+E19*VLOOKUP(M19,$I$53:$Q$109,9,FALSE)+E21*VLOOKUP(M21,$I$53:$Q$109,9,FALSE)+E23*VLOOKUP(M23,$I$53:$Q$109,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$53:$Q$109,5,FALSE)+F15*VLOOKUP(O15,$I$53:$Q$109,5,FALSE)+F17*VLOOKUP(O17,$I$53:$Q$109,5,FALSE)+F19*VLOOKUP(O19,$I$53:$Q$109,9,FALSE)+F21*VLOOKUP(O21,$I$53:$Q$109,9,FALSE)+F23*VLOOKUP(O23,$I$53:$Q$109,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$53:$Q$109,5,FALSE)+G15*VLOOKUP(Q15,$I$53:$Q$109,5,FALSE)+G17*VLOOKUP(Q17,$I$53:$Q$109,5,FALSE)+G19*VLOOKUP(Q19,$I$53:$Q$109,9,FALSE)+G21*VLOOKUP(Q21,$I$53:$Q$109,9,FALSE)+G23*VLOOKUP(Q23,$I$53:$Q$109,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$53:$Q$109,5,FALSE)+H15*VLOOKUP(S15,$I$53:$Q$109,5,FALSE)+H17*VLOOKUP(S17,$I$53:$Q$109,5,FALSE)+H19*VLOOKUP(S19,$I$53:$Q$109,9,FALSE)+H21*VLOOKUP(S21,$I$53:$Q$109,9,FALSE)+H23*VLOOKUP(S23,$I$53:$Q$109,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$53:$Q$109,3,FALSE)+C15*VLOOKUP(K15,$I$53:$Q$109,3,FALSE)+C17*VLOOKUP(K17,$I$53:$Q$109,3,FALSE)+C19*VLOOKUP(K19,$I$53:$Q$109,7,FALSE)+C21*VLOOKUP(K21,$I$53:$Q$109,7,FALSE)+C23*VLOOKUP(K23,$I$53:$Q$109,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$53:$Q$109,3,FALSE)+E15*VLOOKUP(M15,$I$53:$Q$109,3,FALSE)+E17*VLOOKUP(M17,$I$53:$Q$109,3,FALSE)+E19*VLOOKUP(M19,$I$53:$Q$109,7,FALSE)+E21*VLOOKUP(M21,$I$53:$Q$109,7,FALSE)+E23*VLOOKUP(M23,$I$53:$Q$109,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$53:$Q$109,3,FALSE)+F15*VLOOKUP(O15,$I$53:$Q$109,3,FALSE)+F17*VLOOKUP(O17,$I$53:$Q$109,3,FALSE)+F19*VLOOKUP(O19,$I$53:$Q$109,7,FALSE)+F21*VLOOKUP(O21,$I$53:$Q$109,7,FALSE)+F23*VLOOKUP(O23,$I$53:$Q$109,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$53:$Q$84,3,FALSE)+G15*VLOOKUP(Q15,$I$53:$Q$84,3,FALSE)+G17*VLOOKUP(Q17,$I$53:$Q$84,3,FALSE)+G19*VLOOKUP(Q19,$I$53:$Q$84,7,FALSE)+G21*VLOOKUP(Q21,$I$53:$Q$84,7,FALSE)+G23*VLOOKUP(Q23,$I$53:$Q$84,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$53:$Q$84,3,FALSE)+H15*VLOOKUP(S15,$I$53:$Q$84,3,FALSE)+H17*VLOOKUP(S17,$I$53:$Q$84,3,FALSE)+H19*VLOOKUP(S19,$I$53:$Q$84,7,FALSE)+H21*VLOOKUP(S21,$I$53:$Q$84,7,FALSE)+H23*VLOOKUP(S23,$I$53:$Q$84,7,FALSE)","v":0}]
[]
[]
[null,null,"NON-Engineering 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 2013",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2013",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017"]
[]
[null,null,null,null,0,0,0,0,"Spring",null,"Spring 2013",null,"Spring 2014",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017"]
[]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2013",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2013",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017"]
[]
[null,null,null,null,null,null,null,null,1,null,"Spring 2013",null,"Spring 2014",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017"]
[]
[]
[8,null,"Graduate Student Tuition (ENGINEERING)",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$83:$Q$109,5,FALSE)+C35*VLOOKUP(K35,$I$83:$Q$109,5,FALSE)+C37*VLOOKUP(K37,$I$83:$Q$109,5,FALSE)+C39*VLOOKUP(K39,$I$83:$Q$109,9,FALSE)+C41*VLOOKUP(K41,$I$83:$Q$109,9,FALSE)+C43*VLOOKUP(K43,$I$83:$Q$109,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$83:$Q$109,5,FALSE)+E35*VLOOKUP(M35,$I$83:$Q$109,5,FALSE)+E37*VLOOKUP(M37,$I$83:$Q$109,5,FALSE)+E39*VLOOKUP(M39,$I$83:$Q$109,9,FALSE)+E41*VLOOKUP(M41,$I$83:$Q$109,9,FALSE)+E43*VLOOKUP(M43,$I$83:$Q$109,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$83:$Q$109,5,FALSE)+F35*VLOOKUP(O35,$I$83:$Q$109,5,FALSE)+F37*VLOOKUP(O37,$I$83:$Q$109,5,FALSE)+F39*VLOOKUP(O39,$I$83:$Q$109,9,FALSE)+F41*VLOOKUP(O41,$I$83:$Q$109,9,FALSE)+F43*VLOOKUP(O43,$I$83:$Q$109,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$83:$Q$109,5,FALSE)+G35*VLOOKUP(Q35,$I$83:$Q$109,5,FALSE)+G37*VLOOKUP(Q37,$I$83:$Q$109,5,FALSE)+G39*VLOOKUP(Q39,$I$83:$Q$109,9,FALSE)+G41*VLOOKUP(Q41,$I$83:$Q$109,9,FALSE)+G43*VLOOKUP(Q43,$I$83:$Q$109,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$83:$Q$109,5,FALSE)+H35*VLOOKUP(S35,$I$83:$Q$109,5,FALSE)+H37*VLOOKUP(S37,$I$83:$Q$109,5,FALSE)+H39*VLOOKUP(S39,$I$83:$Q$109,9,FALSE)+H41*VLOOKUP(S41,$I$83:$Q$109,9,FALSE)+H43*VLOOKUP(S43,$I$83:$Q$109,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$83:$Q$109,3,FALSE)+C35*VLOOKUP(K35,$I$83:$Q$109,3,FALSE)+C37*VLOOKUP(K37,$I$83:$Q$109,3,FALSE)+C39*VLOOKUP(K39,$I$83:$Q$109,7,FALSE)+C41*VLOOKUP(K41,$I$83:$Q$109,7,FALSE)+C43*VLOOKUP(K43,$I$83:$Q$109,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$83:$Q$109,3,FALSE)+E35*VLOOKUP(M35,$I$83:$Q$109,3,FALSE)+E37*VLOOKUP(M37,$I$83:$Q$109,3,FALSE)+E39*VLOOKUP(M39,$I$83:$Q$109,7,FALSE)+E41*VLOOKUP(M41,$I$83:$Q$109,7,FALSE)+E43*VLOOKUP(M43,$I$83:$Q$109,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$83:$Q$109,3,FALSE)+F35*VLOOKUP(O35,$I$83:$Q$109,3,FALSE)+F37*VLOOKUP(O37,$I$83:$Q$109,3,FALSE)+F39*VLOOKUP(O39,$I$83:$Q$109,7,FALSE)+F41*VLOOKUP(O41,$I$83:$Q$109,7,FALSE)+F43*VLOOKUP(O43,$I$83:$Q$109,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$83:$Q$109,3,FALSE)+G35*VLOOKUP(Q35,$I$83:$Q$109,3,FALSE)+G37*VLOOKUP(Q37,$I$83:$Q$109,3,FALSE)+G39*VLOOKUP(Q39,$I$83:$Q$109,7,FALSE)+G41*VLOOKUP(Q41,$I$83:$Q$109,7,FALSE)+G43*VLOOKUP(Q43,$I$83:$Q$109,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$83:$Q$109,3,FALSE)+H35*VLOOKUP(S35,$I$83:$Q$109,3,FALSE)+H37*VLOOKUP(S37,$I$83:$Q$109,3,FALSE)+H39*VLOOKUP(S39,$I$83:$Q$109,7,FALSE)+H41*VLOOKUP(S41,$I$83:$Q$109,7,FALSE)+H43*VLOOKUP(S43,$I$83:$Q$109,7,FALSE)","v":0}]
[]
[]
[null,null,"Engineering 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 2013",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2013",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2013",null,"Spring 2014",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,0,null,0,0,0,0,"Summer",null,"Summer 2013",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2013",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017"]
[]
[null,null,0,null,0,0,0,0,"Spring",null,"Spring 2013",null,"Spring 2014",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017"]
[]
[]
[]
[]
[]
[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 2012",null,970,null,1939,null,1939,null,3878]
[null,null,null,null,null,null,null,null,"Fall 2013",null,981,null,1962,null,1962,null,3924]
[null,null,null,null,null,null,null,null,"Fall 2014",null,{"$f":"K54*$S$50","v":1022.202},null,{"$f":"M54*$S$50","v":2044.404},null,{"$f":"O54*$S$50","v":2044.404},null,{"$f":"Q54*$S$50","v":4088.808}]
[null,null,null,null,null,null,null,null,"Fall 2015",null,1065.1344839999999,null,{"$f":"M55*$S$50","v":2130.2689679999999},null,{"$f":"O55*$S$50","v":2130.2689679999999},null,{"$f":"Q55*$S$50","v":4260.5379359999997}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1109.870132328,null,2219.7402646559999,null,2219.7402646559999,null,4439.4805293119998]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1156.4846778857759,null,2312.9693557715518,null,2312.9693557715518,null,4625.9387115431036]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1205.0570343569786,null,2410.1140687139573,null,2410.1140687139573,null,4820.2281374279146]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1255.6694297999718,null,2511.3388595999436,null,2511.3388595999436,null,5022.6777191998872]
[]
[null,null,null,null,null,null,null,null,"Spring 2012",null,935,null,1869,null,1869,null,3738]
[null,null,null,null,null,null,null,null,"Spring 2013",null,970,null,1939,null,1939,null,3878]
[null,null,null,null,null,null,null,null,"Spring 2014",null,981,null,1962,null,1962,null,3924]
[null,null,null,null,null,null,null,null,"Spring 2015",null,{"$f":"K64*$S$50","v":1022.202},null,{"$f":"M64*$S$50","v":2044.404},null,{"$f":"O64*$S$50","v":2044.404},null,{"$f":"Q64*$S$50","v":4088.808}]
[null,null,null,null,null,null,null,null,"Spring 2016",null,1065.1344839999999,null,2130.2689679999999,null,2130.2689679999999,null,{"$f":"Q65*$S$50","v":4260.5379359999997}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1109.870132328,null,2219.7402646559999,null,2219.7402646559999,null,4439.4805293119998]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1156.4846778857759,null,2312.9693557715518,null,2312.9693557715518,null,4625.9387115431036]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1205.0570343569786,null,2410.1140687139573,null,2410.1140687139573,null,4820.2281374279146]
[]
[null,null,null,null,null,null,null,null,"Summer 2012",null,539,null,1078,null,1078,null,2155]
[null,null,null,null,null,null,null,null,"Summer 2013",null,545,null,1090,null,1090,null,2180]
[null,null,null,null,null,null,null,null,"Summer 2014",null,{"$f":"K72*$S$50","v":567.89},null,{"$f":"M72*$S$50","v":1135.78},null,{"$f":"O72*$S$50","v":1135.78},null,{"$f":"Q72*$S$50","v":2271.56}]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K73*$S$50","v":591.74138000000005},null,{"$f":"M73*$S$50","v":1183.4827600000001},null,{"$f":"O73*$S$50","v":1183.4827600000001},null,{"$f":"Q73*$S$50","v":2366.9655200000002}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,616.59451796000008,null,1233.1890359200002,null,1233.1890359200002,null,2466.3780718400003]
[null,null,null,null,null,null,null,null,"Summer 2017",null,642.4914877143201,null,1284.9829754286402,null,1284.9829754286402,null,2569.9659508572804]
[null,null,null,null,null,null,null,null,"Summer 2018",null,669.47613019832158,null,1338.9522603966432,null,1338.9522603966432,null,2677.9045207932863]
[null,null,null,null,null,null,null,null,"Summer 2019",null,697.59412766665116,null,1395.1882553333023,null,1395.1882553333023,null,2790.3765106666046]
[]
[null,null,null,null,null,null,null,null,"Engineering 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 2012",null,1118,null,2235,null,2235,null,4470]
[null,null,null,null,null,null,null,null,"Fall 2013",null,1131,null,2262,null,2262,null,4523]
[null,null,null,null,null,null,null,null,"Fall 2014",null,{"$f":"K84*$S$50","v":1178.502},null,{"$f":"M84*$S$50","v":2357.0039999999999},null,{"$f":"O84*$S$50","v":2357.0039999999999},null,{"$f":"Q84*$S$50","v":4712.9660000000003}]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K85*$S$50","v":1227.999084},null,{"$f":"M85*$S$50","v":2455.9981680000001},null,{"$f":"O85*$S$50","v":2455.9981680000001},null,{"$f":"Q85*$S$50","v":4910.9105720000007}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1279.5750455280001,null,2559.1500910560003,null,2559.1500910560003,null,5117.168816024001]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1333.3171974401762,null,2666.6343948803524,null,2666.6343948803524,null,5332.0899062970093]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1389.3165197326637,null,2778.6330394653273,null,2778.6330394653273,null,5556.0376823614843]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1447.6678135614357,null,2895.3356271228713,null,2895.3356271228713,null,5789.3912650206667]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2012",null,1077,null,2154,null,2154,null,4308]
[null,null,null,null,null,null,null,null,"Spring 2013",null,1118,null,2235,null,2235,null,4470]
[null,null,null,null,null,null,null,null,"Spring 2014",null,1131,null,2262,null,2262,null,4523]
[null,null,null,null,null,null,null,null,"Spring 2015",null,{"$f":"K94*$S$50","v":1178.502},null,{"$f":"M94*$S$50","v":2357.0039999999999},null,{"$f":"O94*$S$50","v":2357.0039999999999},null,{"$f":"Q94*$S$50","v":4712.9660000000003}]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K95*$S$50","v":1227.999084},null,{"$f":"M95*$S$50","v":2455.9981680000001},null,2455.9981680000001,null,{"$f":"Q95*$S$50","v":4910.9105720000007}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1279.5750455280001,null,2559.1500910560003,null,2559.1500910560003,null,5117.168816024001]
[null,null,null,null,null,null,null,null,"Spring 2018",null,1333.3171974401762,null,2666.6343948803524,null,2666.6343948803524,null,5332.0899062970093]
[null,null,null,null,null,null,null,null,"Spring 2019",null,1389.3165197326637,null,2778.6330394653273,null,2778.6330394653273,null,5556.0376823614843]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2012",null,621,null,1243,null,1243,null,2485]
[null,null,null,null,null,null,null,null,"Summer 2013",null,629,null,1258,null,1258,null,2515]
[null,null,null,null,null,null,null,null,"Summer 2014",null,{"$f":"K102*$S$50","v":655.41800000000001},null,{"$f":"M102*$S$50","v":1310.836},null,{"$f":"O102*$S$50","v":1310.836},null,{"$f":"Q102*$S$50","v":2620.63}]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K103*$S$50","v":682.94555600000001},null,{"$f":"M103*$S$50","v":1365.891112},null,{"$f":"O103*$S$50","v":1365.891112},null,{"$f":"Q103*$S$50","v":2730.6964600000001}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,711.62926935200005,null,1423.2585387040001,null,1423.2585387040001,null,2845.3857113200002]
[null,null,null,null,null,null,null,null,"Summer 2017",null,741.51769866478412,null,1483.0353973295682,null,1483.0353973295682,null,2964.8919111954401]
[null,null,null,null,null,null,null,null,"Summer 2018",null,772.66144200870508,null,1545.3228840174102,null,1545.3228840174102,null,3089.4173714656486]
[null,null,null,null,null,null,null,null,"Summer 2019",null,805.11322257307074,null,1610.2264451461415,null,1610.2264451461415,null,3219.1729010672061]

{"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:R88),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!R89+Summary!R90+Summary!R76,0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C8:C24)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND(Summary!R98,0)","v":0}]
["Total Costs",null,{"$f":"SUM(C25:C26)","v":0}]