{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Internal budget","External budget","Tuition","FOR SPA USE ONLY"],"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":"Internal budget","index":0,"n_rows":115,"n_cols":13,"rows_kept":115,"cut":false,"hidden":false,"merged":[[2,6,3,10],[4,6,5,10]]}
["Project Budget Worksheet - Iowa State University of Science and Technology",null,null,null,null,null,null,null,null,null,null,null,"Eff. 7/1/2016"]
["Loaded Budget for Industry Proposals",null,null,null,null,null,null,null,null,null,null,null,"Updated 7/14/2016"]
["Program Sponsor",null,null,".",null,null,"FOR INTERNAL USE ONLY",null,null,null,null,null,"GS # ______"]
["Title",null,null,"."]
["PI",null,null,".",null,null,"To use this form, enter budget numbers into \"Internal Budget\" and the fringe rates and F&A rate will calculated into each line item of the \"External Budget\" which should be sent as PDF to Sponsor."]
["Period of Performance",null,null,"."]
["Deadline",null,null,"."]
[]
[" ",null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[]
[null,null,null,"Salary","Cal.","Acad.","Summer"]
["A",null,"Key Personnel","Monthly","Months","Months","Months",{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},{"$f":"SUM(K13:K21)","v":0},{"$f":"SUM(L13:L21)","v":0},{"$f":"SUM(H12:L12)","v":0}]
[null,1,"PI 1",0,0,0,0,{"$f":"D13*(E13+F13+G13)","v":0},{"$f":"H13*1.03","v":0},0,0,{"$f":"K13*1.03","v":0},0]
[null,2,"PI 2",0,0,0,0,{"$f":"D14*(E14+F14+G14)","v":0},0,0,0,0,0]
[null,3,"PI 3",0,0,0,0,{"$f":"D15*(E15+F15+G15)","v":0},{"$f":"H15*1.03","v":0},0,0,0,0]
[null,4,"PI 4",0,0,0,0,0,0,0,0,0,0]
[null,5,"PI 5",0,0,0,0,0,0,0,0,0,0]
[null,6,"PI 6",0,0,0,0,0,0,0,0,0,0]
[null,7,"PI 7",0,0,0,0,0,0,0,0,0,0]
[null,8,"PI 8",0,0,0,0,0,0,0,0,0,0]
[null,9,"PI 9",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Cal.",null,"Number of"]
["B",null,"Other Personnel","Monthly","Months",null,"persons",{"$f":"SUM(H24:H29)","v":0},{"$f":"SUM(I24:I29)","v":0},{"$f":"SUM(J24:J29)","v":0},{"$f":"SUM(K24:K29)","v":0},{"$f":"SUM(L24:L29)","v":0},{"$f":"SUM(H23:L23)","v":0}]
[null,1,"Post Doc",0,0,null,1,{"$f":"D24*(E24)*G24","v":0},{"$f":"+H24*1.03","v":0},0,0,{"$f":"+K24*1.03","v":0},0]
[null,2,"Post Doc",0,0,null,1,{"$f":"D25*(E25)*G25","v":0},0,0,0,0,0]
[null,3,"Research Asst-Halftime",0,0,null,1,{"$f":"D26*(E26)*G26","v":0},0,0,0,0,0]
[null,4,"Research Asst-Halftime",0,0,null,1,{"$f":"+D27*E27*G27","v":0},0,0,0,0,0]
[null,5,"Hourly Undergraduate student",0,0,null,1,{"$f":"D28*(E28)*G28","v":0},0,0,0,0,0]
[null,6,"Professional & Scientific ",0,0,null,1,{"$f":"D29*(E29)*G29","v":0},0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries and Wages",null,null,null,null,{"$f":"+H12+H23","v":0},{"$f":"+I12+I23","v":0},{"$f":"+J12+J23","v":0},{"$f":"+K12+K23","v":0},{"$f":"+L12+L23","v":0},{"$f":"M12+M23","v":0}]
[]
["C",null,"Fringe Benefits","Rate",null,null,null,{"$f":"SUM(H34:H48)","v":0},{"$f":"SUM(I34:I48)","v":0},{"$f":"SUM(J34:J48)","v":0},{"$f":"SUM(K34:K48)","v":0},{"$f":"SUM(L34:L48)","v":0},{"$f":"SUM(H33:L33)","v":0}]
[null,null,{"$f":"+C13","v":"PI 1"},0.27500000000000002,null,null,null,{"$f":"$D$34*H13","v":0},{"$f":"$D$34*I13","v":0},{"$f":"$D$34*J13","v":0},{"$f":"$D$34*K13","v":0},{"$f":"$D$34*L13","v":0},0]
[null,null,{"$f":"+C14","v":"PI 2"},0.27500000000000002,null,null,null,{"$f":"$D$35*H14","v":0},{"$f":"$D$35*I14","v":0},{"$f":"$D$35*J14","v":0},{"$f":"$D$35*K14","v":0},{"$f":"$D$35*L14","v":0},0]
[null,null,{"$f":"+C15","v":"PI 3"},0.27500000000000002,null,null,null,{"$f":"$D$36*H15","v":0},{"$f":"$D$36*I15","v":0},{"$f":"$D$36*J15","v":0},{"$f":"$D$36*K15","v":0},{"$f":"$D$36*L15","v":0},0]
[null,null,"PI 4",0.27500000000000002,null,null,null,{"$f":"$D$37*H16","v":0},{"$f":"$D$37*I21","v":0},{"$f":"$D$37*J21","v":0},{"$f":"$D$37*K21","v":0},{"$f":"$D$37*L21","v":0},0]
[null,null,"PI 5",0.27500000000000002,null,null,null,{"$f":"$D$38*H17","v":0},{"$f":"$D$37*I17","v":0},{"$f":"$D$37*J17","v":0},{"$f":"$D$37*K17","v":0},{"$f":"$D$37*L17","v":0},0]
[null,null,"PI 6",0.27500000000000002,null,null,null,{"$f":"$D$39*H18","v":0},{"$f":"$D$39*I18","v":0},{"$f":"$D$39*J18","v":0},{"$f":"$D$39*K18","v":0},{"$f":"$D$39*L18","v":0},0]
[null,null,"PI 7",0.27500000000000002,null,null,null,{"$f":"$D$40*H19","v":0},{"$f":"$D$40*I19","v":0},{"$f":"$D$40*J19","v":0},{"$f":"$D$40*K19","v":0},{"$f":"$D$40*L19","v":0},0]
[null,null,"PI 8",0.27500000000000002,null,null,null,{"$f":"$D$41*H20","v":0},{"$f":"$D$41*I20","v":0},{"$f":"$D$41*J20","v":0},{"$f":"$D$41*K20","v":0},{"$f":"$D$41*L20","v":0},0]
[null,null,"PI 9",0.27500000000000002,null,null,null,{"$f":"$D$42*H21","v":0},{"$f":"$D$42*I21","v":0},{"$f":"$D$42*J21","v":0},{"$f":"$D$42*K21","v":0},{"$f":"$D$42*L21","v":0},0]
[null,null,{"$f":"+C24","v":"Post Doc"},0.32900000000000001,null,null,null,{"$f":"$D$43*H24","v":0},{"$f":"$D$43*I24","v":0},{"$f":"$D$43*J24","v":0},{"$f":"$D$43*K24","v":0},{"$f":"$D$43*L24","v":0},0]
[null,null,"Post Doc",0.32900000000000001,null,null,null,{"$f":"$D$44*H25","v":0},{"$f":"$D$44*I25","v":0},{"$f":"$D$44*J25","v":0},{"$f":"$D$44*K25","v":0},{"$f":"$D$44*L25","v":0},0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,{"$f":"$D$45*H26","v":0},{"$f":"$D$45*I26","v":0},{"$f":"$D$45*J26","v":0},{"$f":"$D$45*K26","v":0},{"$f":"$D$45*L26","v":0},0]
[null,null,"Research Asst-Halftime",9.8000000000000004E-2,null,null,null,{"$f":"$D$46*H27","v":0},{"$f":"$D$46*I27","v":0},{"$f":"$D$46*J27","v":0},{"$f":"$D$46*K27","v":0},{"$f":"$D$46*L27","v":0},0]
[null,null,"Hourly Undergraduate student",6.0000000000000001E-3,null,null,null,{"$f":"$D$47*H28","v":0},{"$f":"$D$47*I28","v":0},{"$f":"$D$47*J28","v":0},{"$f":"$D$47*K28","v":0},{"$f":"$D$47*L28","v":0},0]
[null,null,"Professional & Scientific ",0.34499999999999997,null,null,null,{"$f":"$D$48*H29","v":0},{"$f":"$D$48*I29","v":0},{"$f":"$D$48*J29","v":0},{"$f":"$D$48*K29","v":0},{"$f":"$D$48*L29","v":0},0]
[]
[null,null,"Subtotal: Salaries, Wages, and Benefits",null,null,null,null,{"$f":"H31+H33","v":0},{"$f":"I31+I33","v":0},{"$f":"J31+J33","v":0},{"$f":"K31+K33","v":0},{"$f":"L31+L33","v":0},{"$f":"SUM(H50:L50)","v":0}]
[]
["D",null,"Equipment (List Item and $ amount for each item > $5k)",null,null,null,null,{"$f":"H53+H54","v":0},{"$f":"I53+I54","v":0},0,0,0,{"$f":"SUM(H52:L52)","v":0}]
[null,null,1,null,null,null,null,0,0,0,0,0,{"$f":"SUM(H53:L53)","v":0}]
[null,null,2]
[]
["E",null,"Travel",null,null,null,null,{"$f":"SUM(H57:H58)","v":0},{"$f":"SUM(I57:I58)","v":0},{"$f":"SUM(J57:J58)","v":0},{"$f":"SUM(K57:K58)","v":0},{"$f":"SUM(L57:L58)","v":0},{"$f":"SUM(H56:L56)","v":0}]
[null,null,"1. Domestic Travel",null,null,null,null,0,0,0,0,0,{"$f":"SUM(H57:L57)","v":0}]
[null,null,"2. Foreign Travel",null,null,null,null,0,0,0,0,0,{"$f":"SUM(H58:L58)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H61:H74)","v":0},{"$f":"SUM(I61:I74)","v":0},{"$f":"SUM(J61:J74)","v":0},{"$f":"SUM(K61:K74)","v":0},{"$f":"SUM(L61:L74)","v":0},{"$f":"SUM(H60:L60)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,0,0,0,0,0,0]
[null,2,"Publication cost",null,null,null,null,0,0,0,0,0,0]
[null,3,"Computing support",null,null,null,null,0,0,0,0,0,0]
[null,4,"Instrumentation facility",null,null,null,null,0,0,0,0,0,0]
[null,5,"Subcontractor1 - Subject to IDC (first $25,000)",null,"See notes below",null,null,0,0,0,0,0,0]
[null,null,"NOT subject to IDC (Amount over $25,000)",null,null,null,null,0,0,0,0,0,0]
[null,5,"Subcontractor2 - Subject to IDC (first $25,000)",null,"See notes below",null,null,0,0,0,0,0,0]
[null,null,"NOT subject to IDC (Amount over $25,000)",null,null,null,null,0,0,0,0,0,0]
[null,7,"Tuition - Non-Engineering","(Click on \"Tuition\" sheet)",null,null,null,{"$f":"Tuition!K6","v":0},{"$f":"Tuition!M6","v":0},{"$f":"Tuition!O6","v":0},{"$f":"Tuition!Q6","v":0},{"$f":"Tuition!S6","v":0},0]
[null,8,"Tuition - Engineering","(Click on \"Tuition\" sheet)",null,null,null,{"$f":"Tuition!K26","v":0},{"$f":"Tuition!M26","v":0},{"$f":"Tuition!O26","v":0},{"$f":"Tuition!Q26","v":0},{"$f":"Tuition!S26","v":0},0]
[null,8,"Tuition-Business & STB","(Click on \"Tuition\" sheet)",null,null,null,{"$f":"Tuition!K46","v":0},{"$f":"Tuition!M46","v":0},{"$f":"Tuition!O46","v":0},{"$f":"Tuition!Q46","v":0},{"$f":"Tuition!S46","v":0},0]
[null,9,"other",null,null,null,null,0,0,0,0,0,{"$f":"SUM(H72:L72)","v":0}]
[null,10,"Other",null,null,null,null,0,0,0,0,0,0]
[null,11,"Other",null,null,null,null,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Total Direct Costs (TDC)",null,null,null,null,{"$f":"H50+H52+H56+H60","v":0},{"$f":"I50+I52+I56+I60","v":0},{"$f":"J50+J52+J56+J60","v":0},{"$f":"K50+K52+K56+K60","v":0},{"$f":"L50+L52+L56+L60","v":0},{"$f":"ROUND(SUM(H76:L76),0)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H76-H52-H66-H68-H69-H70)","v":0},{"$f":"(I76-I52-I66-I68-I69-I70)","v":0},{"$f":"(J76-J52-J66-J68-J69-J70)","v":0},{"$f":"(K76-K52-K66-K68-K69-K70)","v":0},{"$f":"(L76-L52-L66-L68-L69-L70)","v":0},{"$f":"SUM(H78:L78)","v":0}]
[null,null,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H82:H82)","v":0},{"$f":"SUM(I82:I82)","v":0},{"$f":"SUM(J82:J82)","v":0},{"$f":"SUM(K82:K82)","v":0},{"$f":"SUM(L82:L82)","v":0},{"$f":"ROUND(SUM(H81:L81),0)","v":0}]
[null,null,"IDC on MTDC",0.5,null,null,null,{"$f":"+H78*$D$82","v":0},{"$f":"+I78*$D$82","v":0},{"$f":"+J78*$D$82","v":0},{"$f":"+K78*$D$82","v":0},{"$f":"+L78*$D$82","v":0}]
[null,null,null,"[ IDC = MTDC * Indirect Rate ]"]
[]
["I",null,"Total Project Costs",null,null,null,null,{"$f":"ROUND(H76+H81,0)","v":0},{"$f":"ROUND(I76+I81,0)","v":0},{"$f":"ROUND(J76+J81,0)","v":0},{"$f":"ROUND(K76+K81,0)","v":0},{"$f":"ROUND(L76+L81,0)","v":0},{"$f":"SUM(H85:L85)","v":0}]
[null,null,"[ Total = TDC + IDC ]"]
[]
[]
[]
[]
[null,null,"NOTES:"]
[null,null,"This budget is not to be distributed outside of the university.  "]
[null,null,"In order to submit budget to sponsor, print External Budget page either physically or to a PDF. "]
[]
[]
[]
[]
[]
[null,null,"Benefits:"]
[null,null,"A&B",0.315]
[null,null,"C",0.13]
[null,null,"D",0.33]
[null,null,"P",0.378]
[null,null,"E",0.5]
[null,null,"XH (Student hourly)",4.5999999999999999E-2]
[null,null,"XH (Non-Student hourly)",0.12]
[]
[null,null,"Post Doc Salary Range:"]
[null,null,"$43K- $80K"]
[null,null,"http://www.grad-college.iastate.edu/post_doc/policies.php"]
[]
[]
[null,null,"Tuition: Drop-down boxes for academic terms and appointment time (1/4-time, 1/2-time) have been disabled - you'll need to type the correct term and "]
[null,null,"appointment time for each academic year (i.e.  Summer 2011, Fall 2011, Spring 2012, etc.) to display the correct tuition amount for the corresponding term and "]
[null,null,"appointment time."]

{"sheet":"External budget","index":1,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[[39,3,39,6],[40,3,40,6]]}
[{"$f":"'Internal budget'!A1","v":"Project Budget Worksheet - Iowa State University of Science and Technology"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Internal budget'!M3","v":"GS # ______"}]
["Budget for Industry Proposals"]
[{"$f":"'Internal budget'!A3","v":"Program Sponsor"},null,null,{"$f":"'Internal budget'!D3","v":"."}]
[{"$f":"'Internal budget'!A4","v":"Title"},null,null,{"$f":"'Internal budget'!D4","v":"."}]
[{"$f":"'Internal budget'!A5","v":"PI"},null,null,{"$f":"'Internal budget'!D5","v":"."}]
[{"$f":"'Internal budget'!A6","v":"Period of Performance"},null,null,{"$f":"'Internal budget'!D6","v":"."}]
[{"$f":"'Internal budget'!A7","v":"Deadline"},null,null,{"$f":"'Internal budget'!D7","v":"."}]
[]
[null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[]
[null,null,null,"Salary","Cal.","Acad.","Summer"]
["A",null,"Key Personnel","Monthly","Months","Months","Months",{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},{"$f":"SUM(K13:K21)","v":0},{"$f":"SUM(L13:L21)","v":0},{"$f":"SUM(H12:L12)","v":0}]
[null,1,{"$f":"'Internal budget'!C13","v":"PI 1"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D13*(1+'Internal budget'!D34))","v":0},{"$f":"'Internal budget'!E13","v":0},{"$f":"'Internal budget'!F13","v":0},{"$f":"'Internal budget'!G13","v":0},{"$f":"D13*(E13+F13+G13)","v":0},{"$f":"H13*1.03","v":0},0,0,0,0]
[null,2,{"$f":"'Internal budget'!C14","v":"PI 2"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D14*(1+'Internal budget'!D35))","v":0},{"$f":"'Internal budget'!E14","v":0},{"$f":"'Internal budget'!F14","v":0},{"$f":"'Internal budget'!G14","v":0},{"$f":"D14*(E14+F14+G14)","v":0},0,0,0,0,0]
[null,3,{"$f":"'Internal budget'!C15","v":"PI 3"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D15*(1+'Internal budget'!D36))","v":0},{"$f":"'Internal budget'!E15","v":0},{"$f":"'Internal budget'!F15","v":0},{"$f":"'Internal budget'!G15","v":0},0,0,0,0,0,0]
[null,4,{"$f":"'Internal budget'!C16","v":"PI 4"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D16*(1+'Internal budget'!D37))","v":0},{"$f":"'Internal budget'!E16","v":0},{"$f":"'Internal budget'!F16","v":0},{"$f":"'Internal budget'!G16","v":0},0,0,0,0,0,0]
[null,5,{"$f":"'Internal budget'!C17","v":"PI 5"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D17*(1+'Internal budget'!D38))","v":0},{"$f":"'Internal budget'!E17","v":0},{"$f":"'Internal budget'!F17","v":0},{"$f":"'Internal budget'!G17","v":0},0,0,0,0,0,0]
[null,6,{"$f":"'Internal budget'!C18","v":"PI 6"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D18*(1+'Internal budget'!D39))","v":0},{"$f":"'Internal budget'!E18","v":0},{"$f":"'Internal budget'!F18","v":0},{"$f":"'Internal budget'!G18","v":0},0,0,0,0,0,0]
[null,7,{"$f":"'Internal budget'!C19","v":"PI 7"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D19*(1+'Internal budget'!D40))","v":0},{"$f":"'Internal budget'!E19","v":0},{"$f":"'Internal budget'!F19","v":0},{"$f":"'Internal budget'!G19","v":0},0,0,0,0,0,0]
[null,8,{"$f":"'Internal budget'!C20","v":"PI 8"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D20*(1+'Internal budget'!D41))","v":0},{"$f":"'Internal budget'!E20","v":0},{"$f":"'Internal budget'!F20","v":0},{"$f":"'Internal budget'!G20","v":0},0,0,0,0,0,0]
[null,9,{"$f":"'Internal budget'!C21","v":"PI 9"},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D21*(1+'Internal budget'!D42))","v":0},{"$f":"'Internal budget'!E21","v":0},{"$f":"'Internal budget'!F21","v":0},{"$f":"'Internal budget'!G21","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,"Cal.",null,"Number of"]
["B",null,"Other Personnel","Monthly","Months",null,"persons",{"$f":"SUM(H25:H30)","v":0},{"$f":"SUM(I25:I30)","v":0},{"$f":"SUM(J25:J30)","v":0},{"$f":"SUM(K25:K30)","v":0},{"$f":"SUM(L25:L30)","v":0},{"$f":"SUM(H24:L24)","v":0}]
[null,1,"Post Doc",{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D24*(1+'Internal budget'!D43))","v":0},{"$f":"'Internal budget'!E24","v":0},null,{"$f":"'Internal budget'!G24","v":1},{"$f":"D25*(E25)*G25","v":0},{"$f":"+H25*1.03","v":0},0,0,0,0]
[null,2,"Post Doc",{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D25*(1+'Internal budget'!D44))","v":0},{"$f":"'Internal budget'!E25","v":0},null,{"$f":"'Internal budget'!G25","v":1},{"$f":"D26*(E26)*G26","v":0},0,0,0,0,0]
[null,3,"Research Asst-Halftime",{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D26*(1+'Internal budget'!D45))","v":0},{"$f":"'Internal budget'!E26","v":0},null,{"$f":"'Internal budget'!G26","v":1},{"$f":"D27*(E27)*G27","v":0},0,0,0,0,0]
[null,4,"Research Asst-Halftime",{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D27*(1+'Internal budget'!D46))","v":0},{"$f":"'Internal budget'!E27","v":0},null,{"$f":"'Internal budget'!G27","v":1},{"$f":"+D28*E28*G28","v":0},0,0,0,0,0]
[null,5,"Hourly Undergraduate student",{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D28*(1+'Internal budget'!D47))","v":0},{"$f":"'Internal budget'!E28","v":0},null,{"$f":"'Internal budget'!G28","v":1},{"$f":"D29*(E29)*G29","v":0},0,0,0,0,0]
[null,6,{"$f":"'Internal budget'!C48","v":"Professional & Scientific "},{"$f":"(1+'Internal budget'!$D$82)*('Internal budget'!D29*(1+'Internal budget'!D48))","v":0},{"$f":"'Internal budget'!E29","v":0},null,{"$f":"'Internal budget'!G29","v":1},{"$f":"D30*(E30)*G30","v":0},0,0,0,0,0]
[]
[]
[null,null,"Subtotal: Personnel",null,null,null,null,{"$f":"H12+H24","v":0},{"$f":"I12+I24","v":0},0,0,0,{"$f":"SUM(H33:L33)","v":0}]
[]
["D",null,"Equipment (List Item and $ amount for each item > $5k)",null,null,null,null,{"$f":"H36+H37","v":0},{"$f":"I36+I37","v":0},{"$f":"J36+J37","v":0},{"$f":"K36+K37","v":0},{"$f":"L36+L37","v":0},{"$f":"SUM(H35:L35)","v":0}]
[null,null,{"$f":"'Internal budget'!C53","v":1},null,null,null,null,{"$f":"('Internal budget'!H53)","v":0},{"$f":"('Internal budget'!I53)","v":0},{"$f":"('Internal budget'!J53)","v":0},{"$f":"('Internal budget'!K53)","v":0},{"$f":"('Internal budget'!L53)","v":0},{"$f":"SUM(H36:L36)","v":0}]
[null,null,{"$f":"'Internal budget'!C54","v":2},null,null,null,null,{"$f":"('Internal budget'!H54)","v":0},{"$f":"('Internal budget'!I54)","v":0},{"$f":"('Internal budget'!J54)","v":0},{"$f":"('Internal budget'!K54)","v":0},{"$f":"('Internal budget'!L54)","v":0},{"$f":"SUM(H37:L37)","v":0}]
[]
["E",null,"Travel",null,null,null,null,{"$f":"SUM(H40:H41)","v":0},{"$f":"SUM(I40:I41)","v":0},{"$f":"SUM(J40:J41)","v":0},{"$f":"SUM(K40:K41)","v":0},{"$f":"SUM(L40:L41)","v":0},{"$f":"SUM(H39:L39)","v":0}]
[null,null,{"$f":"'Internal budget'!C57","v":"1. Domestic Travel"},null,null,null,null,{"$f":"'Internal budget'!H57*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I57*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J57*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K57*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L57*(1+'Internal budget'!$D$82)","v":0},{"$f":"SUM(H40:L40)","v":0}]
[null,null,{"$f":"'Internal budget'!C58","v":"2. Foreign Travel"},null,null,null,null,{"$f":"'Internal budget'!H58*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I58*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J58*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K58*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L58*(1+'Internal budget'!$D$82)","v":0},{"$f":"SUM(H41:L41)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H44:H55)","v":0},{"$f":"SUM(I44:I55)","v":0},{"$f":"SUM(J44:J55)","v":0},{"$f":"SUM(K44:K55)","v":0},{"$f":"SUM(L44:L55)","v":0},{"$f":"SUM(H43:L43)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,{"$f":"'Internal budget'!H61*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I61*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J61*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K61*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L61*(1+'Internal budget'!$D$82)","v":0},0]
[null,2,"Publication cost",null,null,null,null,{"$f":"'Internal budget'!H62*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I62*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J62*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K62*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L62*(1+'Internal budget'!$D$82)","v":0},0]
[null,3,"Computing support",null,null,null,null,{"$f":"'Internal budget'!H63*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I63*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J63*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K63*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L63*(1+'Internal budget'!$D$82)","v":0},0]
[null,4,"Instrumentation facility",null,null,null,null,{"$f":"'Internal budget'!H64*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I64*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J64*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K64*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L64*(1+'Internal budget'!$D$82)","v":0},0]
[null,5,"Subcontractor1 ",null,null,null,null,{"$f":"('Internal budget'!H65*(1+'Internal budget'!$D$82))+'Internal budget'!H66","v":0},{"$f":"('Internal budget'!I65*(1+'Internal budget'!$D$82))+'Internal budget'!I66","v":0},{"$f":"('Internal budget'!J65*(1+'Internal budget'!$D$82))+'Internal budget'!J66","v":0},{"$f":"('Internal budget'!K65*(1+'Internal budget'!$D$82))+'Internal budget'!K66","v":0},{"$f":"('Internal budget'!L65*(1+'Internal budget'!$D$82))+'Internal budget'!L66","v":0},0]
[null,6,"Subcontractor2",null,null,null,null,{"$f":"('Internal budget'!H67*(1+'Internal budget'!$D$82))+'Internal budget'!H68","v":0},{"$f":"('Internal budget'!I67*(1+'Internal budget'!$D$82))+'Internal budget'!I68","v":0},{"$f":"('Internal budget'!J67*(1+'Internal budget'!$D$82))+'Internal budget'!J68","v":0},{"$f":"('Internal budget'!K67*(1+'Internal budget'!$D$82))+'Internal budget'!K68","v":0},{"$f":"('Internal budget'!L67*(1+'Internal budget'!$D$82))+'Internal budget'!L68","v":0},0]
[null,7,"Tuition - Non-Engineering",null,null,null,null,{"$f":"'Internal budget'!H69","v":0},{"$f":"'Internal budget'!I69","v":0},{"$f":"'Internal budget'!J69","v":0},{"$f":"'Internal budget'!K69","v":0},{"$f":"'Internal budget'!L69","v":0},0]
[null,8,"Tuition - Engineering",null,null,null,null,{"$f":"'Internal budget'!H70","v":0},{"$f":"'Internal budget'!I70","v":0},{"$f":"'Internal budget'!J70","v":0},{"$f":"'Internal budget'!K70","v":0},{"$f":"'Internal budget'!L70","v":0},0]
[null,9,"Tuition - Business & STB",null,null,null,null,{"$f":"'Internal budget'!H71","v":0},{"$f":"'Internal budget'!I71","v":0},{"$f":"'Internal budget'!J71","v":0},{"$f":"'Internal budget'!K71","v":0},{"$f":"'Internal budget'!L71","v":0},{"$f":"SUM(H52:L52)","v":0}]
[null,null,"Other",null,null,null,null,{"$f":"'Internal budget'!H72*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I72*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J72*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K72*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L72*(1+'Internal budget'!$D$82)","v":0}]
[null,9,"Other",null,null,null,null,{"$f":"'Internal budget'!H73*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I73*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J73*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K73*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L73*(1+'Internal budget'!$D$82)","v":0},0]
[null,10,"Other",null,null,null,null,{"$f":"'Internal budget'!H74*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!I74*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!J74*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!K74*(1+'Internal budget'!$D$82)","v":0},{"$f":"'Internal budget'!L74*(1+'Internal budget'!$D$82)","v":0},0]
[]
["I",null,"Total Project Costs",null,null,null,null,{"$f":"H33+H35+H39+H43","v":0},{"$f":"I33+I35+I39+I43","v":0},{"$f":"J33+J35+J39+J43","v":0},{"$f":"K33+K35+K39+K43","v":0},{"$f":"L33+L35+L39+L43","v":0},{"$f":"SUM(H57:L57)","v":0}]

{"sheet":"Tuition","index":2,"n_rows":158,"n_cols":19,"rows_kept":158,"cut":false,"hidden":false,"merged":[[5,2,5,5],[6,2,6,5],[40,2,40,3],[42,2,42,3],[1,2,2,8],[30,2,30,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],[10,2,10,7],[25,2,25,5],[26,2,26,5],[27,2,27,5],[129,8,129,16],[66,2,66,8],[52,2,52,3],[54,2,54,3],[56,2,56,3],[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],[47,2,47,5],[50,2,50,7],[46,2,46,5],[32,0,36,0],[32,2,32,3],[34,2,34,3],[36,2,36,3],[38,0,42,0],[38,2,38,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,"Note: semester can be changed by selecting a different year in the drop down "]
[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($I$6=\"1/2-time\",K7,K8),0)","v":0},null,{"$f":"ROUND(IF($I$6=\"1/2-time\",M7,M8),0)","v":0}," ",{"$f":"ROUND(IF($I$6=\"1/2-time\",O7,O8),0)","v":0}," ",{"$f":"ROUND(IF($I$6=\"1/2-time\",Q7,Q8),0)","v":0}," ",{"$f":"ROUND(IF($I$6=\"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":"+G13*VLOOKUP(O13,$I$73:$Q$99,3,FALSE)+G15*VLOOKUP(O15,$I$73:$Q$99,3,FALSE)+G17*VLOOKUP(O17,$I$73:$Q$99,3,FALSE)+G19*VLOOKUP(O19,$I$73:$Q$99,7,FALSE)+G21*VLOOKUP(O21,$I$73:$Q$99,7,FALSE)+G23*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,0,null,0,0,0,0,"Summer",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[null,null,0,null,0,0,0,0,"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,0,null,0,0,0,0,"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,0,null,0,0,0,0,"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":"+G33*VLOOKUP(O33,$I$103:$Q$129,5,FALSE)+G35*VLOOKUP(O35,$I$103:$Q$129,5,FALSE)+G37*VLOOKUP(O37,$I$103:$Q$129,5,FALSE)+G39*VLOOKUP(O39,$I$103:$Q$129,9,FALSE)+G41*VLOOKUP(O41,$I$103:$Q$129,9,FALSE)+G43*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":"+G33*VLOOKUP(O33,$I$103:$Q$129,3,FALSE)+G35*VLOOKUP(O35,$I$103:$Q$129,3,FALSE)+G37*VLOOKUP(O37,$I$103:$Q$129,3,FALSE)+G39*VLOOKUP(O39,$I$103:$Q$129,7,FALSE)+G41*VLOOKUP(O41,$I$103:$Q$129,7,FALSE)+G43*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,0,null,0,0,0,0,"Summer",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[null,null,0,null,0,0,0,0,"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,0,null,0,0,0,0,"Summer",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[null,null,0,null,0,0,0,null,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
[null,null,null,0]
[]
[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$158,5,FALSE)+C55*VLOOKUP(K55,$I$133:$Q$158,5,FALSE)+C57*VLOOKUP(K57,$I$133:$Q$158,5,FALSE)+C59*VLOOKUP(K59,$I$133:$Q$158,9,FALSE)+C61*VLOOKUP(K61,$I$133:$Q$158,9,FALSE)+C63*VLOOKUP(K63,$I$133:$Q$158,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$133:$Q$158,5,FALSE)+E55*VLOOKUP(M55,$I$133:$Q$158,5,FALSE)+E57*VLOOKUP(M57,$I$133:$Q$158,5,FALSE)+E59*VLOOKUP(M59,$I$133:$Q$158,9,FALSE)+E61*VLOOKUP(M61,$I$133:$Q$158,9,FALSE)+E63*VLOOKUP(M63,$I$133:$Q$158,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(O53,$I$133:$Q$158,5,FALSE)+G55*VLOOKUP(O55,$I$133:$Q$158,5,FALSE)+G57*VLOOKUP(O57,$I$133:$Q$158,5,FALSE)+G59*VLOOKUP(O59,$I$133:$Q$158,9,FALSE)+G61*VLOOKUP(O61,$I$133:$Q$158,9,FALSE)+G63*VLOOKUP(O63,$I$133:$Q$158,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$133:$Q$158,5,FALSE)+G55*VLOOKUP(Q55,$I$133:$Q$158,5,FALSE)+G57*VLOOKUP(Q57,$I$133:$Q$158,5,FALSE)+G59*VLOOKUP(Q59,$I$133:$Q$158,9,FALSE)+G61*VLOOKUP(Q61,$I$133:$Q$158,9,FALSE)+G63*VLOOKUP(Q63,$I$133:$Q$158,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$133:$Q$158,5,FALSE)+H55*VLOOKUP(S55,$I$133:$Q$158,5,FALSE)+H57*VLOOKUP(S57,$I$133:$Q$158,5,FALSE)+H59*VLOOKUP(S59,$I$133:$Q$158,9,FALSE)+H61*VLOOKUP(S61,$I$133:$Q$158,9,FALSE)+H63*VLOOKUP(S63,$I$133:$Q$158,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$133:$Q$158,3,FALSE)+C55*VLOOKUP(K55,$I$133:$Q$158,3,FALSE)+C57*VLOOKUP(K57,$I$133:$Q$158,3,FALSE)+C59*VLOOKUP(K59,$I$133:$Q$158,7,FALSE)+C61*VLOOKUP(K61,$I$133:$Q$158,7,FALSE)+C63*VLOOKUP(K63,$I$133:$Q$158,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$133:$Q$158,3,FALSE)+E55*VLOOKUP(M55,$I$133:$Q$158,3,FALSE)+E57*VLOOKUP(M57,$I$133:$Q$158,3,FALSE)+E59*VLOOKUP(M59,$I$133:$Q$158,7,FALSE)+E61*VLOOKUP(M61,$I$133:$Q$158,7,FALSE)+E63*VLOOKUP(M63,$I$133:$Q$158,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(O53,$I$133:$Q$158,3,FALSE)+G55*VLOOKUP(O55,$I$133:$Q$158,3,FALSE)+G57*VLOOKUP(O57,$I$133:$Q$158,3,FALSE)+G59*VLOOKUP(O59,$I$133:$Q$158,7,FALSE)+G61*VLOOKUP(O61,$I$133:$Q$158,7,FALSE)+G63*VLOOKUP(O63,$I$133:$Q$158,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$133:$Q$158,3,FALSE)+G55*VLOOKUP(Q55,$I$133:$Q$158,3,FALSE)+G57*VLOOKUP(Q57,$I$133:$Q$158,3,FALSE)+G59*VLOOKUP(Q59,$I$133:$Q$158,7,FALSE)+G61*VLOOKUP(Q61,$I$133:$Q$158,7,FALSE)+G63*VLOOKUP(Q63,$I$133:$Q$158,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$133:$Q$158,3,FALSE)+H55*VLOOKUP(S55,$I$133:$Q$158,3,FALSE)+H57*VLOOKUP(S57,$I$133:$Q$158,3,FALSE)+H59*VLOOKUP(S59,$I$133:$Q$158,7,FALSE)+H61*VLOOKUP(S61,$I$133:$Q$158,7,FALSE)+H63*VLOOKUP(S63,$I$133:$Q$158,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,0,null,0,0,0,0,"Summer",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[null,null,null,null,0,0,0,0]
[null,null,0,null,0,0,0,0,"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,0,null,0,0,0,0,"Summer",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020"]
[]
[null,null,0,null,0,0,0,0,"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":1046.75},null,{"$f":"O73","v":2093.5},null,{"$f":"Q73/2","v":2093.5},null,4187]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K73*$S$70","v":1090.7135000000001},{"$f":"L73*$S$70","v":0},2181.4270000000001,0,2181.4270000000001,0,4362.8540000000003]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K74*$S$70","v":1136.5234670000002},null,2273.0469340000004,null,2273.0469340000004,null,4546.0938680000008]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1184.2574526140002,null,2368.5149052280003,null,2368.5149052280003,null,4737.0298104560006]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1233.9962656237883,null,2467.9925312475766,null,2467.9925312475766,null,4935.9850624951532]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1285.8241087799875,null,2571.6482175599749,null,2571.6482175599749,null,5143.2964351199498]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1339.828721348747,null,2679.6574426974939,null,2679.6574426974939,null,5359.3148853949879]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1396.1015276453943,null,2792.2030552907886,null,2792.2030552907886,null,5584.4061105815772]
[]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q82/4","v":1046.75},null,{"$f":"Q82/2","v":2093.5},null,{"$f":"Q82/2","v":2093.5},null,{"$f":"Q73","v":4187}]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K82*$S$70","v":1090.7135000000001},null,{"$f":"M82*$S$70","v":2181.4270000000001},null,{"$f":"O82*$S$70","v":2181.4270000000001},null,{"$f":"Q82*$S$70","v":4362.8540000000003}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K83*$S$70","v":1136.5234670000002},null,{"$f":"M83*$S$70","v":2273.0469340000004},null,{"$f":"O83*$S$70","v":2273.0469340000004},null,{"$f":"Q83*$S$70","v":4546.0938680000008}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1184.2574526140002,null,2368.5149052280003,null,2368.5149052280003,null,4737.0298104560006]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1233.9962656237883,null,2467.9925312475766,null,2467.9925312475766,null,4935.9850624951532]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1285.8241087799875,null,2571.6482175599749,null,2571.6482175599749,null,5143.2964351199498]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1339.828721348747,null,2679.6574426974939,null,2679.6574426974939,null,5359.3148853949879]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1396.1015276453943,null,2792.2030552907886,null,2792.2030552907886,null,5584.4061105815772]
[]
[null,null,null,null,null,null,null,null,"Summer 2016",null,{"$f":"Q91/4","v":655.5},null,{"$f":"Q91/2","v":1311},null,{"$f":"Q91/2","v":1311},null,2622]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"K91*$S$70","v":683.03100000000006},null,{"$f":"M91*$S$70","v":1366.0620000000001},null,{"$f":"O91*$S$70","v":1366.0620000000001},null,2330]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K92*$S$70","v":711.71830200000011},null,{"$f":"M92*$S$70","v":1423.4366040000002},null,{"$f":"O92*$S$70","v":1423.4366040000002},null,{"$f":"Q92*$S$70","v":2427.86}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,741.61047068400012,null,1483.2209413680002,null,1483.2209413680002,null,2529.8301200000001]
[null,null,null,null,null,null,null,null,"Summer 2020",null,772.75811045272815,null,1545.5162209054563,null,1545.5162209054563,null,2636.08298504]
[null,null,null,null,null,null,null,null,"Summer 2021",null,805.21395109174273,null,1610.4279021834855,null,1610.4279021834855,null,2746.7984704116802]
[null,null,null,null,null,null,null,null,"Summer 2022",null,839.03293703759596,null,1678.0658740751919,null,1678.0658740751919,null,2862.1640061689709]
[null,null,null,null,null,null,null,null,"Summer 2023",null,874.27232039317505,null,1748.5446407863501,null,1748.5446407863501,null,2982.3748944280678]
[]
[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":1206.75},null,{"$f":"O103","v":2413.5},null,{"$f":"Q103/2","v":2413.5},null,4827]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K103*$S$70","v":1257.4335000000001},null,{"$f":"M103*$S$70","v":2514.8670000000002},null,{"$f":"O103*$S$70","v":2514.8670000000002},null,{"$f":"Q103*$S$70","v":5029.7340000000004}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K104*$S$70","v":1310.245707},null,{"$f":"M104*$S$70","v":2620.4914140000001},null,{"$f":"O104*$S$70","v":2620.4914140000001},null,{"$f":"Q104*$S$70","v":5240.9828280000002}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1365.2760266940002,null,2730.5520533880003,null,2730.5520533880003,null,5461.1041067760007]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1422.6176198151481,null,2845.2352396302963,null,2845.2352396302963,null,5690.4704792605926]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1482.3675598473844,null,2964.7351196947689,null,2964.7351196947689,null,5929.4702393895377]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1544.6269973609747,null,3089.2539947219493,null,3089.2539947219493,null,6178.5079894438986]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1609.5013312501355,null,3219.0026625002711,null,3219.0026625002711,null,6438.0053250005421]
[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":1206.75},null,{"$f":"O112","v":2413.5},null,{"$f":"Q112/2","v":2413.5},null,4827]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K112*$S$70","v":1257.4335000000001},null,{"$f":"M112*$S$70","v":2514.8670000000002},null,{"$f":"O112*$S$70","v":2514.8670000000002},null,{"$f":"Q112*$S$70","v":5029.7340000000004}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K113*$S$70","v":1310.245707},null,{"$f":"M113*$S$70","v":2620.4914140000001},null,{"$f":"O113*$S$70","v":2620.4914140000001},null,{"$f":"Q113*$S$70","v":5240.9828280000002}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1365.2760266940002,null,2730.5520533880003,null,2730.5520533880003,null,5461.1041067760007]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1422.6176198151481,null,2845.2352396302963,null,2845.2352396302963,null,5690.4704792605926]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1482.3675598473844,null,2964.7351196947689,null,2964.7351196947689,null,5929.4702393895377]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1544.6269973609747,null,3089.2539947219493,null,3089.2539947219493,null,6178.5079894438986]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1609.5013312501355,null,3219.0026625002711,null,3219.0026625002711,null,6438.0053250005421]
[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":744.25},null,{"$f":"Q121/2","v":1488.5},null,{"$f":"Q121/2","v":1488.5},null,2977]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"K121*$S$70","v":775.50850000000003},null,{"$f":"M121*$S$70","v":1551.0170000000001},null,{"$f":"O121*$S$70","v":1551.0170000000001},null,{"$f":"Q121*$S$70","v":3102.0340000000001}]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K122*$S$70","v":808.07985700000006},null,{"$f":"M122*$S$70","v":1616.1597140000001},null,{"$f":"O122*$S$70","v":1616.1597140000001},null,{"$f":"Q122*$S$70","v":3232.3194280000002}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,842.0192109940001,null,1684.0384219880002,null,1684.0384219880002,null,3368.0768439760004]
[null,null,null,null,null,null,null,null,"Summer 2020",null,877.38401785574808,null,1754.7680357114962,null,1754.7680357114962,null,3509.5360714229923]
[null,null,null,null,null,null,null,null,"Summer 2021",null,914.23414660568949,null,1828.468293211379,null,1828.468293211379,null,3656.936586422758]
[null,null,null,null,null,null,null,null,"Summer 2022",null,952.63198076312847,null,1905.2639615262569,null,1905.2639615262569,null,3810.5279230525139]
[null,null,null,null,null,null,null,null,"Summer 2023",null,992.64252395517985,null,1985.2850479103597,null,1985.2850479103597,null,3970.5700958207194]
[" "]
[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":1270.75},null,{"$f":"Q133/2","v":2541.5},null,{"$f":"Q133/2","v":2541.5},null,5083]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K133*$S$70","v":1324.1215},null,{"$f":"M133*$S$70","v":2648.2429999999999},null,{"$f":"O133*$S$70","v":2648.2429999999999},null,{"$f":"Q133*$S$70","v":5296.4859999999999}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K134*$S$70","v":1379.7346030000001},null,{"$f":"M134*$S$70","v":2759.4692060000002},null,{"$f":"O134*$S$70","v":2759.4692060000002},null,{"$f":"Q134*$S$70","v":5518.9384120000004}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1437.6834563260002,null,2875.3669126520003,null,2875.3669126520003,null,5750.7338253040007]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1498.0661614916921,null,2996.1323229833843,null,2996.1323229833843,null,5992.2646459667685]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1560.9849402743432,null,3121.9698805486864,null,3121.9698805486864,null,6243.9397610973729]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1626.5463077658658,null,3253.0926155317316,null,3253.0926155317316,null,6506.1852310634631]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1694.8612526920322,null,3389.7225053840643,null,3389.7225053840643,null,6779.4450107681287]
[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":1270.75},null,{"$f":"Q142/2","v":2541.5},null,{"$f":"Q142/2","v":2541.5},null,5083]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K142*$S$70","v":1324.1215},null,{"$f":"M142*$S$70","v":2648.2429999999999},null,{"$f":"O142*$S$70","v":2648.2429999999999},null,{"$f":"Q142*$S$70","v":5296.4859999999999}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K143*$S$70","v":1379.7346030000001},null,{"$f":"M143*$S$70","v":2759.4692060000002},null,{"$f":"O143*$S$70","v":2759.4692060000002},null,{"$f":"Q143*$S$70","v":5518.9384120000004}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1437.6834563260002,null,2875.3669126520003,null,2875.3669126520003,null,5750.7338253040007]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1498.0661614916921,null,2996.1323229833843,null,2996.1323229833843,null,5992.2646459667685]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1560.9849402743432,null,3121.9698805486864,null,3121.9698805486864,null,6243.9397610973729]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1626.5463077658658,null,3253.0926155317316,null,3253.0926155317316,null,6506.1852310634631]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1694.8612526920322,null,3389.7225053840643,null,3389.7225053840643,null,6779.4450107681287]
[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":783},null,{"$f":"Q151/2","v":1566},null,{"$f":"Q151/2","v":1566},null,3132]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"K151*$S$70","v":815.88600000000008},null,{"$f":"M151*$S$70","v":1631.7720000000002},null,{"$f":"O151*$S$70","v":1631.7720000000002},null,{"$f":"Q151*$S$70","v":3263.5440000000003}]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K152*$S$70","v":850.15321200000017},null,{"$f":"M152*$S$70","v":1700.3064240000003},null,{"$f":"O152*$S$70","v":1700.3064240000003},null,{"$f":"Q152*$S$70","v":3400.6128480000007}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,885.85964690400021,null,1771.7192938080004,null,1771.7192938080004,null,3543.4385876160009]
[null,null,null,null,null,null,null,null,"Summer 2020",null,923.06575207396827,null,1846.1315041479365,null,1846.1315041479365,null,3692.2630082958731]
[null,null,null,null,null,null,null,null,"Summer 2021",null,961.83451366107499,null,1923.66902732215,null,1923.66902732215,null,3847.3380546443]
[null,null,null,null,null,null,null,null,"Summer 2022",null,1002.2315632348402,null,2004.4631264696804,null,2004.4631264696804,null,4008.9262529393609]
[null,null,null,null,null,null,null,null,"Summer 2023",null,1044.3252888907036,null,2088.6505777814073,null,2088.6505777814073,null,4177.3011555628145]

{"sheet":"FOR SPA USE ONLY","index":3,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Sponsor:",{"$f":"'Internal budget'!D3","v":"."}]
["Title: ",{"$f":"'Internal budget'!D4","v":"."}]
["PI Name: ",{"$f":"'Internal budget'!D5","v":"."}]
["Period of Performance:",{"$f":"'Internal budget'!D6","v":"."}]
["Account Number:"]
[]
["Budget Categories","Budget Code","Amount"]
["Salary/Hourly","0108",{"$f":"ROUND('Internal budget'!M31,0)","v":0}]
["Payroll Benefits","0130",{"$f":"ROUND('Internal budget'!M33,0)","v":0}]
["Equipment","0710",{"$f":"ROUND('Internal budget'!M52,0)","v":0}]
["Travel Domestic","0215",{"$f":"ROUND('Internal budget'!M57,0)","v":0}]
["Travel Foreign","0216",{"$f":"ROUND('Internal budget'!M58,0)","v":0}]
["Student Tuition","0610",{"$f":"ROUND('Internal budget'!M69+'Internal budget'!M70,0)","v":0}]
["Supplies","0410",{"$f":"ROUND('Internal budget'!M61,0)","v":0}]
["Subcontracts"]
["Subject to IDC","0396",{"$f":"ROUND('Internal budget'!M65+'Internal budget'!M67,0)","v":0}]
["Not Subejct to IDC","0376",{"$f":"ROUND('Internal budget'!M66+'Internal budget'!M68,0)","v":0}]
["Other Direct Costs"]
["Telecom Charges","0340",0]
["Computer Usage","0353",{"$f":"ROUND('Internal budget'!M63,0)","v":0}]
["Printing/Copying","0373",{"$f":"ROUND('Internal budget'!M62,0)","v":0}]
["Services/Honoraria","0302",{"$f":"ROUND('Internal budget'!M64,0)","v":0}]
["Postage","0379",0]
["Other  ","0630",{"$f":"ROUND(SUM('Internal budget'!M72:M74),0)","v":0}]
["Total Direct Costs",null,{"$f":"'Internal budget'!M76","v":0}]
["Indirect Costs","0642",{"$f":"'Internal budget'!M81","v":0}]
["Total Costs",null,{"$f":"SUM(C25:C26)","v":0}]