{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Internal budget","External budget ","Tuition","FOR SPA USE ONLY","INDUSTRY BUDGET USE THIS"],"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":"Instructions","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Preparing a Loaded Budget for Industry - Use this when the sponsor expects to see a quote.  Some sponsors may expect to see a fully detailed budget, especially if they have indicated a reduced IDC in the RFP.  In those cases, use the standard BOB."]
["1)      In the TUITION TAB, ensure the tuition matrix is properly completed.  If no students are expected for a particular semester or year, leave the square blank.  If any students are expected for a particular semester and year, enter the number of students to have tuition charged in the matrix."]
["2)      In the INTERNAL BUDGET TAB, for Key Personnel, enter the monthly salary and needed months of salary under Academic or Summer months only.  Do not enter anything in Calendar Months.  Enter the salary needs for Year 1.  If this is a one-year project, zero out the remaining months."]
["3)      In the INTERNAL BUDGET TAB, for Other Personnel, enter the monthly salary and Calendar Months.  Enter the salary needs for Year 1.  If this is a one-year project, zero out the remaining months."]
["4)      In the INTERNAL BUDGET TAB, Fringe Benefits will auto-populate based on the Key and Other Personnel.  Enter the budgeted totals for Equipment, Travel, and Other Direct Costs.  Indirect Costs and Total Project Costs should auto-populate.  "]
["5)      In the INTERNAL BUDGET TAB, if you need to change the Indirect Cost Rate, enter the revised rate.  Be sure to update the revised rate to Total Direct Costs as needed by modifying the formula in H82 (the most likely change is from =+H78*$D$82 to =+H76*$D$82)."]
["6)      In the EXTERNAL BUDGET TAB, zero out any remaining salary for Year 2 through 5.  Review to ensure Total Project Costs match from INTERNAL BUDGET TAB.  If they do not, review budget to find where the discrepancies are occurring.  The most likely error is in the months applied to the salaries."]
["7) The INDUSTRY BUDGET USE THIS tab is the budget format you will send to the sponsor.  "]

{"sheet":"Internal budget","index":1,"n_rows":119,"n_cols":13,"rows_kept":119,"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. 2/9/2017"]
["Loaded Budget for Industry Proposals",null,null,null,null,null,null,null,null,null,null,null,"Updated 2/17/2017"]
["Program Sponsor",null,null,"XYZ Company",null,null,"FOR INTERNAL USE ONLY"]
["Title",null,null,"The best proposal ever"]
["PI",null,null,"Professor Smith",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,"1/1/2017 to 12/31/2017"]
["Deadline"]
[]
[" ",null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[null,null,null,null,null,null,"Select FY ","FY17",{"$f":"IF(H10=F97,F98,IF(H10=F98,F99,IF(H10=F99,F100,IF(H10=F100,F101,IF(H10=F101,F102,IF(H10=F102,F103,IF(H10=F103,F104,IF(H10=F104,F105,IF(H10=F105,F106)))))))))","v":"FY18"},{"$f":"IF(I10=F97,F98,IF(I10=F98,F99,IF(I10=F99,F100,IF(I10=F100,F101,IF(I10=F101,F102,IF(I10=F102,F103,IF(I10=F103,F104,IF(I10=F104,F105,IF(I10=F105,F106)))))))))","v":"FY19"},{"$f":"IF(J10=F97,F98,IF(J10=F98,F99,IF(J10=F99,F100,IF(J10=F100,F101,IF(J10=F101,F102,IF(J10=F102,F103,IF(J10=F103,F104,IF(J10=F104,F105,IF(J10=F105,F106)))))))))","v":"FY20"},{"$f":"IF(IK10=F97,F98,IF(K10=F98,F99,IF(K10=F99,F100,IF(K10=F100,F101,IF(K10=F101,F102,IF(K10=F102,F103,IF(K10=F103,F104,IF(K10=F104,F105,IF(K10=F105,F106)))))))))","v":"FY21"}]
[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,1,0,0,{"$f":"D13*(E13+F13+G13)","v":0},{"$f":"H13*1.03","v":0},{"$f":"I13*1.03","v":0},{"$f":"J13*1.03","v":0},{"$f":"K13*1.03","v":0},{"$f":"SUM(H13:L13)","v":0}]
[null,2,"PI 2",0,1,0,0,{"$f":"D14*(E14+F14+G14)","v":0},{"$f":"H14*1.03","v":0},{"$f":"I14*1.03","v":0},0,{"$f":"K14*1.03","v":0},0]
[null,3,"PI 3",0,1,0,0,{"$f":"D15*(E15+F15+G15)","v":0},{"$f":"H15*1.03","v":0},0,0,0,0]
[null,4,"PI 4",0,1,0,0,{"$f":"D16*(E16+F16+G16)","v":0},0,0,0,0,0]
[null,5,"PI 5",0,1,0,0,0,0,0,0,0,0]
[null,6,"PI 6",0,1,0,0,0,0,0,0,0,0]
[null,7,"PI 7",0,1,0,0,0,0,0,0,0,0]
[null,8,"PI 8",0,1,0,0,0,0,0,0,0,0]
[null,9,"PI 9",0,1,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,1,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,1,null,1,{"$f":"D25*(E25)*G25","v":0},0,0,0,0,0]
[null,3,"Research Asst-Halftime ",0,1,null,1,{"$f":"D26*(E26)*G26","v":0},{"$f":"H26*1.03","v":0},0,0,0,0]
[null,4,"Research Asst-Halftime",0,1,null,1,{"$f":"+D27*E27*G27","v":0},0,0,0,0,0]
[null,5,"Hourly Undergraduate student",0,1,null,1,{"$f":"D28*(E28)*G28","v":0},0,0,0,0,0]
[null,6,"Professional & Scientific ",0,1,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. Centrifuge",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:H75)","v":0},{"$f":"SUM(I61:I75)","v":0},{"$f":"SUM(J61:J75)","v":0},{"$f":"SUM(K61:K75)","v":0},{"$f":"SUM(L61:L75)","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},{"$f":"SUM(H71:L71)","v":0}]
[null,8,"Tuition - Specific Grad Depts","(Click on \"Tuition\" sheet)",null,null,null,{"$f":"Tuition!K67","v":0},{"$f":"Tuition!M67","v":0},{"$f":"Tuition!O67","v":0},{"$f":"Tuition!Q67","v":0},{"$f":"Tuition!S67","v":0},{"$f":"SUM(H72:L72)","v":0}]
[null,9,"other",null,null,null,null,0,0,0,0,0,{"$f":"SUM(H73:L73)","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(H77:L77),0)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H77-H52-H66-H68-H69-H70-H71-H72)","v":0},{"$f":"(I77-I52-I66-I68-I69-I70-I71-I72)","v":0},{"$f":"(J77-J52-J66-J68-J69-J70-J71-J72)","v":0},{"$f":"(K77-K52-K66-K68-K69-K70-K71-K72)","v":0},{"$f":"(L77-L52-L66-L68-L69-L70-L71-L72)","v":0},{"$f":"SUM(H79:L79)","v":0}]
[null,null,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs",null,null,null,null,{"$f":"SUM(H83:H83)","v":0},{"$f":"SUM(I83:I83)","v":0},{"$f":"SUM(J83:J83)","v":0},{"$f":"SUM(K83:K83)","v":0},{"$f":"SUM(L83:L83)","v":0},{"$f":"ROUND(SUM(H82:L82),0)","v":0}]
[null,null,"IDC on MTDC",null,null,null,null,{"$f":"ROUND(H84*(H79),0)","v":0},{"$f":"ROUND(I84*(I79),0)","v":0},{"$f":"ROUND(J84*(J79),0)","v":0},{"$f":"ROUND(K84*(K79),0)","v":0},{"$f":"ROUND(L84*(L79),0)","v":0}]
[null,null,null,"[ IDC = MTDC * Indirect Rate ]",null,null,"Rate Used",{"$f":"IF(H10=F97,G97,IF(H10=F98,G98,IF(H10=F99,G99,IF(H10=F100,G100,IF(H10=F101,G101,IF(H10=F102,G102))))))","v":0.52},{"$f":"IF(I10=F97,G97,IF(I10=F98,G98,IF(I10=F99,G99,IF(I10=F100,G100,IF(I10=F101,G101,IF(I10=F102,G102,IF(I10=F103,G103,IF(I10=F104,G104,IF(I10=F105,G105,IF(I10=F106,G106))))))))))","v":0.52},{"$f":"IF(J10=F97,G97,IF(J10=F98,G98,IF(J10=F99,G99,IF(J10=F100,G100,IF(J10=F101,G101,IF(J10=F102,G102,IF(J10=F103,G103,IF(J10=F104,G104,IF(J10=F105,G105,IF(J10=F106,G106))))))))))","v":0.53},{"$f":"IF(K10=F97,G97,IF(K10=F98,G98,IF(K10=F99,G99,IF(K10=F100,G100,IF(K10=F101,G101,IF(K10=F102,G102,IF(K10=F103,G103,IF(K10=F104,G104,IF(K10=F105,G105,IF(K10=F106,G106))))))))))","v":0.53},{"$f":"IF(L10=F97,G97,IF(L10=F98,G98,IF(L10=F99,G99,IF(L10=F100,G100,IF(L10=F101,G101,IF(L10=F102,G102,IF(L10=F103,G103,IF(L10=F104,G104,IF(L10=F105,G105,IF(L10=F106,G106))))))))))","v":0.53}]
[]
["I",null,"Total Project Costs",null,null,null,null,{"$f":"ROUND(H77+H82,0)","v":0},{"$f":"ROUND(I77+I82,0)","v":0},{"$f":"ROUND(J77+J82,0)","v":0},{"$f":"ROUND(K77+K82,0)","v":0},{"$f":"ROUND(L77+L82,0)","v":0},{"$f":"SUM(H86:L86)","v":0}]
[null,null,"[ Total = TDC + IDC ]"]
[]
[]
[]
[]
[null,null,"NOTES:"]
[null,null,"This budget is not to be distrubuted 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,"Indirect Cost Categories:",null,null,"FY","F&A Rate"]
[null,0.52,"On-Campus Organized Research FY17-18",null,null,"FY17",0.52]
[null,0.53,"On-Campus Organized Research FY19-21",null,null,"FY18",0.52]
[null,0.51,"On Campus Instruction",null,null,"FY19",0.53]
[null,0.32,"On-Campus Other Sponsored Activities",null,null,"FY20",0.53]
[null,0.26,"Off-Campus All Programs",null,null,"FY21",0.53]
[null,null,null,null,null,"FY22",0.53]
[null,null,"Benefits:",null,null,"FY23",0.53]
[null,null,"A&B",0.27500000000000002,null,"FY24",0.53]
[null,null,"C",9.8000000000000004E-2,null,"FY25",0.53]
[null,null,"D",0.32900000000000001,null,"FY26",0.53]
[null,null,"P",0.34499999999999997]
[null,null,"E",0.45800000000000002]
[null,null,"XH (Student hourly)",6.0000000000000001E-3]
[null,null,"XH (Non-Student hourly)",0.17100000000000001]
[]
[null,null,"Post Doc Salary Range:"]
[]
[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":2,"n_rows":58,"n_cols":13,"rows_kept":58,"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"}]
["Budget for Industry Proposals"]
[{"$f":"'Internal budget'!A3","v":"Program Sponsor"},null,null,{"$f":"'Internal budget'!D3","v":"XYZ Company"}]
[{"$f":"'Internal budget'!A4","v":"Title"},null,null,{"$f":"'Internal budget'!D4","v":"The best proposal ever"}]
[{"$f":"'Internal budget'!A5","v":"PI"},null,null,{"$f":"'Internal budget'!D5","v":"Professor Smith"}]
[{"$f":"'Internal budget'!A6","v":"Period of Performance"},null,null,{"$f":"'Internal budget'!D6","v":"1/1/2017 to 12/31/2017"}]
[{"$f":"'Internal budget'!A7","v":"Deadline"},null,null,{"$f":"'Internal budget'!D7","v":"00:00:00"}]
[]
[null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[]
[null,null,null,null,"Cal.","Acad.","Summer"]
["A",null,"Key Personnel",null,"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 "},null,{"$f":"'Internal budget'!E13","v":1},{"$f":"'Internal budget'!F13","v":0},{"$f":"'Internal budget'!G13","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H13*(1+'Internal budget'!D34))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I13*(1+'Internal budget'!D34))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J13*(1+'Internal budget'!D34))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K13*(1+'Internal budget'!D34))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L13*(1+'Internal budget'!D34))","v":0},{"$f":"SUM(H13:L13)","v":0}]
[null,2,{"$f":"'Internal budget'!C14","v":"PI 2"},null,{"$f":"'Internal budget'!E14","v":1},{"$f":"'Internal budget'!F14","v":0},{"$f":"'Internal budget'!G14","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H14*(1+'Internal budget'!D35))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I14*(1+'Internal budget'!D35))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J14*(1+'Internal budget'!D35))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K14*(1+'Internal budget'!D35))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L14*(1+'Internal budget'!D35))","v":0},{"$f":"SUM(H14:L14)","v":0}]
[null,3,{"$f":"'Internal budget'!C15","v":"PI 3"},null,{"$f":"'Internal budget'!E15","v":1},{"$f":"'Internal budget'!F15","v":0},{"$f":"'Internal budget'!G15","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H15*(1+'Internal budget'!D36))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I15*(1+'Internal budget'!D36))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J15*(1+'Internal budget'!D36))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K15*(1+'Internal budget'!D36))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L15*(1+'Internal budget'!D36))","v":0},{"$f":"SUM(H15:L15)","v":0}]
[null,4,{"$f":"'Internal budget'!C16","v":"PI 4"},null,{"$f":"'Internal budget'!E16","v":1},{"$f":"'Internal budget'!F16","v":0},{"$f":"'Internal budget'!G16","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H16*(1+'Internal budget'!D37))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I16*(1+'Internal budget'!D37))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J16*(1+'Internal budget'!D37))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K16*(1+'Internal budget'!D37))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L16*(1+'Internal budget'!D37))","v":0},0]
[null,5,{"$f":"'Internal budget'!C17","v":"PI 5"},null,{"$f":"'Internal budget'!E17","v":1},{"$f":"'Internal budget'!F17","v":0},{"$f":"'Internal budget'!G17","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H17*(1+'Internal budget'!D38))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I17*(1+'Internal budget'!D38))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J17*(1+'Internal budget'!D38))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K17*(1+'Internal budget'!D38))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L17*(1+'Internal budget'!D38))","v":0},0]
[null,6,{"$f":"'Internal budget'!C18","v":"PI 6"},null,{"$f":"'Internal budget'!E18","v":1},{"$f":"'Internal budget'!F18","v":0},{"$f":"'Internal budget'!G18","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H18*(1+'Internal budget'!D39))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I18*(1+'Internal budget'!D39))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J18*(1+'Internal budget'!D39))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K18*(1+'Internal budget'!D39))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L18*(1+'Internal budget'!D39))","v":0},0]
[null,7,{"$f":"'Internal budget'!C19","v":"PI 7"},null,{"$f":"'Internal budget'!E19","v":1},{"$f":"'Internal budget'!F19","v":0},{"$f":"'Internal budget'!G19","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H19*(1+'Internal budget'!D40))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I19*(1+'Internal budget'!D40))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J19*(1+'Internal budget'!D40))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K19*(1+'Internal budget'!D40))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L19*(1+'Internal budget'!D40))","v":0},{"$f":"SUM(H19:L19)","v":0}]
[null,8,{"$f":"'Internal budget'!C20","v":"PI 8"},null,{"$f":"'Internal budget'!E20","v":1},{"$f":"'Internal budget'!F20","v":0},{"$f":"'Internal budget'!G20","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H20*(1+'Internal budget'!D41))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I20*(1+'Internal budget'!D41))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J20*(1+'Internal budget'!D41))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K20*(1+'Internal budget'!D41))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L20*(1+'Internal budget'!D41))","v":0},0]
[null,9,{"$f":"'Internal budget'!C21","v":"PI 9"},null,{"$f":"'Internal budget'!E21","v":1},{"$f":"'Internal budget'!F21","v":0},{"$f":"'Internal budget'!G21","v":0},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H21*(1+'Internal budget'!D42))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I21*(1+'Internal budget'!D42))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J21*(1+'Internal budget'!D42))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K21*(1+'Internal budget'!D42))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L21*(1+'Internal budget'!D42))","v":0},{"$f":"SUM(H21:L21)","v":0}]
[]
[null,null,null,null,"Cal.",null,"Number of"]
["B",null,"Other Personnel",null,"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",null,{"$f":"'Internal budget'!E24","v":1},null,{"$f":"'Internal budget'!G24","v":1},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H24*(1+'Internal budget'!D43))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I24*(1+'Internal budget'!D43))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J24*(1+'Internal budget'!D43))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K24*(1+'Internal budget'!D43))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L24*(1+'Internal budget'!D43))","v":0},{"$f":"SUM(H25:L25)","v":0}]
[null,2,"Post Doc",null,{"$f":"'Internal budget'!E25","v":1},null,{"$f":"'Internal budget'!G25","v":1},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H25*(1+'Internal budget'!D44))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I25*(1+'Internal budget'!D44))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J25*(1+'Internal budget'!D44))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K25*(1+'Internal budget'!D44))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L25*(1+'Internal budget'!D44))","v":0},0]
[null,3,"Research Asst-Halftime",null,{"$f":"'Internal budget'!E26","v":1},null,{"$f":"'Internal budget'!G26","v":1},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H26*(1+'Internal budget'!D45))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I26*(1+'Internal budget'!D45))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J26*(1+'Internal budget'!D45))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K26*(1+'Internal budget'!D45))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L26*(1+'Internal budget'!D45))","v":0},0]
[null,4,"Research Asst-Halftime",null,{"$f":"'Internal budget'!E27","v":1},null,{"$f":"'Internal budget'!G27","v":1},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H27*(1+'Internal budget'!D46))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I27*(1+'Internal budget'!D46))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J27*(1+'Internal budget'!D46))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K27*(1+'Internal budget'!D46))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L27*(1+'Internal budget'!D46))","v":0},{"$f":"SUM(H28:L28)","v":0}]
[null,5,"Hourly Undergraduate student",null,{"$f":"'Internal budget'!E28","v":1},null,{"$f":"'Internal budget'!G28","v":1},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H28*(1+'Internal budget'!D47))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I28*(1+'Internal budget'!D47))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J28*(1+'Internal budget'!D47))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K28*(1+'Internal budget'!D47))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L28*(1+'Internal budget'!D47))","v":0},{"$f":"SUM(H29:L29)","v":0}]
[null,6,{"$f":"'Internal budget'!C48","v":"Professional & Scientific "},null,{"$f":"'Internal budget'!E29","v":1},null,{"$f":"'Internal budget'!G29","v":1},{"$f":"(1+'Internal budget'!$H$84)*('Internal budget'!H29*(1+'Internal budget'!D48))","v":0},{"$f":"(1+'Internal budget'!$I$84)*('Internal budget'!I29*(1+'Internal budget'!D48))","v":0},{"$f":"(1+'Internal budget'!$J$84)*('Internal budget'!J29*(1+'Internal budget'!D48))","v":0},{"$f":"(1+'Internal budget'!$K$84)*('Internal budget'!K29*(1+'Internal budget'!D48))","v":0},{"$f":"(1+'Internal budget'!$L$84)*('Internal budget'!L29*(1+'Internal budget'!D48))","v":0},{"$f":"SUM(H30:L30)","v":0}]
[]
[]
[null,null,"Subtotal: Personnel",null,null,null,null,{"$f":"H12+H24","v":0},{"$f":"I12+I24","v":0},{"$f":"J12+J24","v":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. Centrifuge"},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'!$H$84)","v":0},{"$f":"'Internal budget'!I57*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J57*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K57*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L57*(1+'Internal budget'!$L$84)","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'!$H$84)","v":0},{"$f":"'Internal budget'!I58*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J58*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K58*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L58*(1+'Internal budget'!$L$84)","v":0},{"$f":"SUM(H41:L41)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H44:H56)","v":0},{"$f":"SUM(I44:I56)","v":0},{"$f":"SUM(J44:J56)","v":0},{"$f":"SUM(K44:K56)","v":0},{"$f":"SUM(L44:L56)","v":0},{"$f":"SUM(H43:L43)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,{"$f":"'Internal budget'!H61*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I61*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J61*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K61*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L61*(1+'Internal budget'!$L$84)","v":0},{"$f":"SUM(H44:L44)","v":0}]
[null,2,"Publication cost",null,null,null,null,{"$f":"'Internal budget'!H62*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I62*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J62*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K62*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L62*(1+'Internal budget'!$L$84)","v":0},{"$f":"SUM(H45:L45)","v":0}]
[null,3,"Computing support",null,null,null,null,{"$f":"'Internal budget'!H63*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I63*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J63*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K63*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L63*(1+'Internal budget'!$L$84)","v":0},{"$f":"SUM(H46:L46)","v":0}]
[null,4,"Instrumentation facility",null,null,null,null,{"$f":"'Internal budget'!H64*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I64*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J64*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K64*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L64*(1+'Internal budget'!$L$84)","v":0},{"$f":"SUM(H47:L47)","v":0}]
[null,5,"Subcontractor1 ",null,null,null,null,{"$f":"('Internal budget'!H65*(1+'Internal budget'!$H$84))+'Internal budget'!H66","v":0},{"$f":"('Internal budget'!I65*(1+'Internal budget'!$I$84))+'Internal budget'!I66","v":0},{"$f":"('Internal budget'!J65*(1+'Internal budget'!$J$84))+'Internal budget'!J66","v":0},{"$f":"('Internal budget'!K65*(1+'Internal budget'!$K$84))+'Internal budget'!K66","v":0},{"$f":"('Internal budget'!L65*(1+'Internal budget'!$L$84))+'Internal budget'!L66","v":0},0]
[null,6,"Subcontractor2",null,null,null,null,{"$f":"('Internal budget'!H67*(1+'Internal budget'!$H$84))+'Internal budget'!H68","v":0},{"$f":"('Internal budget'!I67*(1+'Internal budget'!$I$84))+'Internal budget'!I68","v":0},{"$f":"('Internal budget'!J67*(1+'Internal budget'!$J$84))+'Internal budget'!J68","v":0},{"$f":"('Internal budget'!K67*(1+'Internal budget'!$K$84))+'Internal budget'!K68","v":0},{"$f":"('Internal budget'!L67*(1+'Internal budget'!$L$84))+'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,"Tuition - Specific Grad Depts",null,null,null,null,{"$f":"'Internal budget'!H72","v":0},{"$f":"'Internal budget'!I72","v":0},{"$f":"'Internal budget'!J72","v":0},{"$f":"'Internal budget'!K72","v":0},{"$f":"'Internal budget'!L72","v":0},{"$f":"SUM(H53:L53)","v":0}]
[null,null,"Other",null,null,null,null,{"$f":"'Internal budget'!H73*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I73*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J73*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K73*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L73*(1+'Internal budget'!$L$84)","v":0},0]
[null,9,"Other",null,null,null,null,{"$f":"'Internal budget'!H74*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I74*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J74*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K74*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L74*(1+'Internal budget'!$L$84)","v":0},0]
[null,10,"Other",null,null,null,null,{"$f":"'Internal budget'!H75*(1+'Internal budget'!$H$84)","v":0},{"$f":"'Internal budget'!I75*(1+'Internal budget'!$I$84)","v":0},{"$f":"'Internal budget'!J75*(1+'Internal budget'!$J$84)","v":0},{"$f":"'Internal budget'!K75*(1+'Internal budget'!$K$84)","v":0},{"$f":"'Internal budget'!L75*(1+'Internal budget'!$L$84)","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(H58:L58)","v":0}]

{"sheet":"Tuition","index":3,"n_rows":208,"n_cols":19,"rows_kept":208,"cut":false,"hidden":false,"merged":[[32,0,36,0],[32,2,32,3],[34,2,34,3],[36,2,36,3],[38,0,42,0],[38,2,38,3],[45,2,45,5],[52,0,56,0],[47,2,47,5],[50,2,50,7],[46,2,46,5],[52,2,52,3],[54,2,54,3],[56,2,56,3],[68,2,68,5],[71,2,71,7],[84,0,85,8],[58,0,62,0],[58,2,58,3],[60,2,60,3],[62,2,62,3],[66,2,66,5],[67,2,67,5],[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],[19,2,19,3],[13,2,13,3],[15,2,15,3],[21,2,21,3],[5,2,5,5],[6,2,6,5],[40,2,40,3],[42,2,42,3],[1,2,2,8],[30,2,30,7],[10,2,10,7],[25,2,25,5],[26,2,26,5],[27,2,27,5],[7,2,7,5],[179,8,179,16],[73,0,77,0],[73,2,73,3],[75,2,75,3],[77,2,77,3],[79,0,83,0],[79,2,79,3],[81,2,81,3],[83,2,83,3],[149,8,149,16],[86,2,86,8]]}
[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$93:$Q$119,5,FALSE)+C15*VLOOKUP(K15,$I$93:$Q$119,5,FALSE)+C17*VLOOKUP(K17,$I$93:$Q$119,5,FALSE)+C19*VLOOKUP(K19,$I$93:$Q$119,9,FALSE)+C21*VLOOKUP(K21,$I$93:$Q$119,9,FALSE)+C23*VLOOKUP(K23,$I$93:$Q$119,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$93:$Q$119,5,FALSE)+E15*VLOOKUP(M15,$I$93:$Q$119,5,FALSE)+E17*VLOOKUP(M17,$I$93:$Q$119,5,FALSE)+E19*VLOOKUP(M19,$I$93:$Q$119,9,FALSE)+E21*VLOOKUP(M21,$I$93:$Q$119,9,FALSE)+E23*VLOOKUP(M23,$I$93:$Q$119,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$93:$Q$119,5,FALSE)+F15*VLOOKUP(O15,$I$93:$Q$119,5,FALSE)+F17*VLOOKUP(O17,$I$93:$Q$119,5,FALSE)+F19*VLOOKUP(O19,$I$93:$Q$119,9,FALSE)+F21*VLOOKUP(O21,$I$93:$Q$119,9,FALSE)+F23*VLOOKUP(O23,$I$93:$Q$119,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$93:$Q$119,5,FALSE)+G15*VLOOKUP(Q15,$I$93:$Q$119,5,FALSE)+G17*VLOOKUP(Q17,$I$93:$Q$119,5,FALSE)+G19*VLOOKUP(Q19,$I$93:$Q$119,9,FALSE)+G21*VLOOKUP(Q21,$I$93:$Q$119,9,FALSE)+G23*VLOOKUP(Q23,$I$93:$Q$119,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$93:$Q$119,5,FALSE)+H15*VLOOKUP(S15,$I$93:$Q$119,5,FALSE)+H17*VLOOKUP(S17,$I$93:$Q$119,5,FALSE)+H19*VLOOKUP(S19,$I$93:$Q$119,9,FALSE)+H21*VLOOKUP(S21,$I$93:$Q$119,9,FALSE)+H23*VLOOKUP(S23,$I$93:$Q$119,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$93:$Q$119,3,FALSE)+C15*VLOOKUP(K15,$I$93:$Q$119,3,FALSE)+C17*VLOOKUP(K17,$I$93:$Q$119,3,FALSE)+C19*VLOOKUP(K19,$I$93:$Q$119,7,FALSE)+C21*VLOOKUP(K21,$I$93:$Q$119,7,FALSE)+C23*VLOOKUP(K23,$I$93:$Q$119,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$93:$Q$119,3,FALSE)+E15*VLOOKUP(M15,$I$93:$Q$119,3,FALSE)+E17*VLOOKUP(M17,$I$93:$Q$119,3,FALSE)+E19*VLOOKUP(M19,$I$93:$Q$119,7,FALSE)+E21*VLOOKUP(M21,$I$93:$Q$119,7,FALSE)+E23*VLOOKUP(M23,$I$93:$Q$119,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$93:$Q$119,3,FALSE)+F15*VLOOKUP(O15,$I$93:$Q$119,3,FALSE)+F17*VLOOKUP(O17,$I$93:$Q$119,3,FALSE)+F19*VLOOKUP(O19,$I$93:$Q$119,7,FALSE)+F21*VLOOKUP(O21,$I$93:$Q$119,7,FALSE)+F23*VLOOKUP(O23,$I$93:$Q$119,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$93:$Q$119,3,FALSE)+G15*VLOOKUP(Q15,$I$93:$Q$119,3,FALSE)+G17*VLOOKUP(Q17,$I$93:$Q$119,3,FALSE)+G19*VLOOKUP(Q19,$I$93:$Q$119,7,FALSE)+G21*VLOOKUP(Q21,$I$93:$Q$119,7,FALSE)+G23*VLOOKUP(Q23,$I$93:$Q$119,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$93:$Q$119,3,FALSE)+H15*VLOOKUP(S15,$I$93:$Q$119,3,FALSE)+H17*VLOOKUP(S17,$I$93:$Q$119,3,FALSE)+H19*VLOOKUP(S19,$I$93:$Q$119,7,FALSE)+H21*VLOOKUP(S21,$I$93:$Q$119,7,FALSE)+H23*VLOOKUP(S23,$I$93:$Q$119,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,0,null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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$123:$Q$149,5,FALSE)+C35*VLOOKUP(K35,$I$123:$Q$149,5,FALSE)+C37*VLOOKUP(K37,$I$123:$Q$149,5,FALSE)+C39*VLOOKUP(K39,$I$123:$Q$149,9,FALSE)+C41*VLOOKUP(K41,$I$123:$Q$149,9,FALSE)+C43*VLOOKUP(K43,$I$123:$Q$149,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$123:$Q$149,5,FALSE)+E35*VLOOKUP(M35,$I$123:$Q$149,5,FALSE)+E37*VLOOKUP(M37,$I$123:$Q$149,5,FALSE)+E39*VLOOKUP(M39,$I$123:$Q$149,9,FALSE)+E41*VLOOKUP(M41,$I$123:$Q$149,9,FALSE)+E43*VLOOKUP(M43,$I$123:$Q$149,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$123:$Q$149,5,FALSE)+F35*VLOOKUP(O35,$I$123:$Q$149,5,FALSE)+F37*VLOOKUP(O37,$I$123:$Q$149,5,FALSE)+F39*VLOOKUP(O39,$I$123:$Q$149,9,FALSE)+F41*VLOOKUP(O41,$I$123:$Q$149,9,FALSE)+F43*VLOOKUP(O43,$I$123:$Q$149,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$123:$Q$149,5,FALSE)+G35*VLOOKUP(Q35,$I$123:$Q$149,5,FALSE)+G37*VLOOKUP(Q37,$I$123:$Q$149,5,FALSE)+G39*VLOOKUP(Q39,$I$123:$Q$149,9,FALSE)+G41*VLOOKUP(Q41,$I$123:$Q$149,9,FALSE)+G43*VLOOKUP(Q43,$I$123:$Q$149,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$123:$Q$149,5,FALSE)+H35*VLOOKUP(S35,$I$123:$Q$149,5,FALSE)+H37*VLOOKUP(S37,$I$123:$Q$149,5,FALSE)+H39*VLOOKUP(S39,$I$123:$Q$149,9,FALSE)+H41*VLOOKUP(S41,$I$123:$Q$149,9,FALSE)+H43*VLOOKUP(S43,$I$123:$Q$149,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$123:$Q$149,3,FALSE)+C35*VLOOKUP(K35,$I$123:$Q$149,3,FALSE)+C37*VLOOKUP(K37,$I$123:$Q$149,3,FALSE)+C39*VLOOKUP(K39,$I$123:$Q$149,7,FALSE)+C41*VLOOKUP(K41,$I$123:$Q$149,7,FALSE)+C43*VLOOKUP(K43,$I$123:$Q$149,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$123:$Q$149,3,FALSE)+E35*VLOOKUP(M35,$I$123:$Q$149,3,FALSE)+E37*VLOOKUP(M37,$I$123:$Q$149,3,FALSE)+E39*VLOOKUP(M39,$I$123:$Q$149,7,FALSE)+E41*VLOOKUP(M41,$I$123:$Q$149,7,FALSE)+E43*VLOOKUP(M43,$I$123:$Q$149,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$123:$Q$149,3,FALSE)+F35*VLOOKUP(O35,$I$123:$Q$149,3,FALSE)+F37*VLOOKUP(O37,$I$123:$Q$149,3,FALSE)+F39*VLOOKUP(O39,$I$123:$Q$149,7,FALSE)+F41*VLOOKUP(O41,$I$123:$Q$149,7,FALSE)+F43*VLOOKUP(O43,$I$123:$Q$149,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$123:$Q$149,3,FALSE)+G35*VLOOKUP(Q35,$I$123:$Q$149,3,FALSE)+G37*VLOOKUP(Q37,$I$123:$Q$149,3,FALSE)+G39*VLOOKUP(Q39,$I$123:$Q$149,7,FALSE)+G41*VLOOKUP(Q41,$I$123:$Q$149,7,FALSE)+G43*VLOOKUP(Q43,$I$123:$Q$149,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$123:$Q$149,3,FALSE)+H35*VLOOKUP(S35,$I$123:$Q$149,3,FALSE)+H37*VLOOKUP(S37,$I$123:$Q$149,3,FALSE)+H39*VLOOKUP(S39,$I$123:$Q$149,7,FALSE)+H41*VLOOKUP(S41,$I$123:$Q$149,7,FALSE)+H43*VLOOKUP(S43,$I$123:$Q$149,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 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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,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$153:$Q$178,5,FALSE)+C55*VLOOKUP(K55,$I$153:$Q$178,5,FALSE)+C57*VLOOKUP(K57,$I$153:$Q$178,5,FALSE)+C59*VLOOKUP(K59,$I$153:$Q$178,9,FALSE)+C61*VLOOKUP(K61,$I$153:$Q$178,9,FALSE)+C63*VLOOKUP(K63,$I$153:$Q$178,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$153:$Q$178,5,FALSE)+E55*VLOOKUP(M55,$I$153:$Q$178,5,FALSE)+E57*VLOOKUP(M57,$I$153:$Q$178,5,FALSE)+E59*VLOOKUP(M59,$I$153:$Q$178,9,FALSE)+E61*VLOOKUP(M61,$I$153:$Q$178,9,FALSE)+E63*VLOOKUP(M63,$I$153:$Q$178,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$153:$Q$179,5,FALSE)+F55*VLOOKUP(O55,$I$153:$Q$179,5,FALSE)+F57*VLOOKUP(O57,$I$153:$Q$179,5,FALSE)+F59*VLOOKUP(O59,$I$153:$Q$179,9,FALSE)+F61*VLOOKUP(O61,$I$153:$Q$179,9,FALSE)+F63*VLOOKUP(O63,$I$153:$Q$179,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$153:$Q$178,5,FALSE)+G55*VLOOKUP(Q55,$I$153:$Q$178,5,FALSE)+G57*VLOOKUP(Q57,$I$153:$Q$178,5,FALSE)+G59*VLOOKUP(Q59,$I$153:$Q$178,9,FALSE)+G61*VLOOKUP(Q61,$I$153:$Q$178,9,FALSE)+G63*VLOOKUP(Q63,$I$153:$Q$178,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$153:$Q$178,5,FALSE)+H55*VLOOKUP(S55,$I$153:$Q$178,5,FALSE)+H57*VLOOKUP(S57,$I$153:$Q$178,5,FALSE)+H59*VLOOKUP(S59,$I$153:$Q$178,9,FALSE)+H61*VLOOKUP(S61,$I$153:$Q$178,9,FALSE)+H63*VLOOKUP(S63,$I$153:$Q$178,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$153:$Q$178,3,FALSE)+C55*VLOOKUP(K55,$I$153:$Q$178,3,FALSE)+C57*VLOOKUP(K57,$I$153:$Q$178,3,FALSE)+C59*VLOOKUP(K59,$I$153:$Q$178,7,FALSE)+C61*VLOOKUP(K61,$I$153:$Q$178,7,FALSE)+C63*VLOOKUP(K63,$I$153:$Q$178,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$153:$Q$178,3,FALSE)+E55*VLOOKUP(M55,$I$153:$Q$178,3,FALSE)+E57*VLOOKUP(M57,$I$153:$Q$178,3,FALSE)+E59*VLOOKUP(M59,$I$153:$Q$178,7,FALSE)+E61*VLOOKUP(M61,$I$153:$Q$178,7,FALSE)+E63*VLOOKUP(M63,$I$153:$Q$178,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$153:$Q$179,3,FALSE)+F55*VLOOKUP(O55,$I$153:$Q$179,3,FALSE)+F57*VLOOKUP(O57,$I$153:$Q$179,3,FALSE)+F59*VLOOKUP(O59,$I$153:$Q$179,7,FALSE)+F61*VLOOKUP(O61,$I$153:$Q$179,7,FALSE)+F63*VLOOKUP(O63,$I$153:$Q$179,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$153:$Q$178,3,FALSE)+G55*VLOOKUP(Q55,$I$153:$Q$178,3,FALSE)+G57*VLOOKUP(Q57,$I$153:$Q$178,3,FALSE)+G59*VLOOKUP(Q59,$I$153:$Q$178,7,FALSE)+G61*VLOOKUP(Q61,$I$153:$Q$178,7,FALSE)+G63*VLOOKUP(Q63,$I$153:$Q$178,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$153:$Q$178,3,FALSE)+H55*VLOOKUP(S55,$I$153:$Q$178,3,FALSE)+H57*VLOOKUP(S57,$I$153:$Q$178,3,FALSE)+H59*VLOOKUP(S59,$I$153:$Q$178,7,FALSE)+H61*VLOOKUP(S61,$I$153:$Q$178,7,FALSE)+H63*VLOOKUP(S63,$I$153:$Q$178,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 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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 (*Specific Graduate Departments)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I67=\"1/2-time\",K68,K69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",M68,M69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",O68,O69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",Q68,Q69),0)","v":0},null,{"$f":"ROUND(IF($I$67=\"1/2-time\",S68,S69),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C74*VLOOKUP(K74,$I$181:$Q$207,5,FALSE)+C76*VLOOKUP(K76,$I$181:$Q$207,5,FALSE)+C78*VLOOKUP(K78,$I$181:$Q$207,5,FALSE)+C80*VLOOKUP(K80,$I$181:$Q$207,9,FALSE)+C82*VLOOKUP(K82,$I$181:$Q$207,9,FALSE)+C84*VLOOKUP(K84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$181:$Q$207,5,FALSE)+E76*VLOOKUP(M76,$I$181:$Q$207,5,FALSE)+E78*VLOOKUP(M78,$I$181:$Q$207,5,FALSE)+E80*VLOOKUP(M80,$I$181:$Q$207,9,FALSE)+E82*VLOOKUP(M82,$I$181:$Q$207,9,FALSE)+E84*VLOOKUP(M84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$181:$Q$207,5,FALSE)+F76*VLOOKUP(O76,$I$181:$Q$207,5,FALSE)+F78*VLOOKUP(O78,$I$181:$Q$207,5,FALSE)+F80*VLOOKUP(O80,$I$181:$Q$207,9,FALSE)+F82*VLOOKUP(O82,$I$181:$Q$207,9,FALSE)+F84*VLOOKUP(O84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$181:$Q$207,5,FALSE)+G76*VLOOKUP(Q76,$I$181:$Q$207,5,FALSE)+G78*VLOOKUP(Q78,$I$181:$Q$207,5,FALSE)+G80*VLOOKUP(Q80,$I$181:$Q$207,9,FALSE)+G82*VLOOKUP(Q82,$I$181:$Q$207,9,FALSE)+G84*VLOOKUP(Q84,$I$181:$Q$207,9,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$181:$Q$207,5,FALSE)+H76*VLOOKUP(S76,$I$181:$Q$207,5,FALSE)+H78*VLOOKUP(S78,$I$181:$Q$207,5,FALSE)+H80*VLOOKUP(S80,$I$181:$Q$207,9,FALSE)+H82*VLOOKUP(S82,$I$181:$Q$207,9,FALSE)+H84*VLOOKUP(S84,$I$181:$Q$207,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C74*VLOOKUP(K74,$I$181:$Q$207,3,FALSE)+C76*VLOOKUP(K76,$I$181:$Q$207,3,FALSE)+C78*VLOOKUP(K78,$I$181:$Q$207,3,FALSE)+C80*VLOOKUP(K80,$I$181:$Q$207,7,FALSE)+C82*VLOOKUP(K82,$I$181:$Q$207,7,FALSE)+C84*VLOOKUP(K84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$181:$Q$207,3,FALSE)+E76*VLOOKUP(M76,$I$181:$Q$207,3,FALSE)+E78*VLOOKUP(M78,$I$181:$Q$207,3,FALSE)+E80*VLOOKUP(M80,$I$181:$Q$207,7,FALSE)+E82*VLOOKUP(M82,$I$181:$Q$207,7,FALSE)+E84*VLOOKUP(M84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$181:$Q$207,3,FALSE)+F76*VLOOKUP(O76,$I$181:$Q$207,3,FALSE)+F78*VLOOKUP(O78,$I$181:$Q$207,3,FALSE)+F80*VLOOKUP(O80,$I$181:$Q$207,7,FALSE)+F82*VLOOKUP(O82,$I$181:$Q$207,7,FALSE)+F84*VLOOKUP(O84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$181:$Q$207,3,FALSE)+G76*VLOOKUP(Q76,$I$181:$Q$207,3,FALSE)+G78*VLOOKUP(Q78,$I$181:$Q$207,3,FALSE)+G80*VLOOKUP(Q80,$I$181:$Q$207,7,FALSE)+G82*VLOOKUP(Q82,$I$181:$Q$207,7,FALSE)+G84*VLOOKUP(Q84,$I$181:$Q$207,7,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$181:$Q$207,3,FALSE)+H76*VLOOKUP(S76,$I$181:$Q$207,3,FALSE)+H78*VLOOKUP(S78,$I$181:$Q$207,3,FALSE)+H80*VLOOKUP(S80,$I$181:$Q$207,7,FALSE)+H82*VLOOKUP(S82,$I$181:$Q$207,7,FALSE)+H84*VLOOKUP(S84,$I$181:$Q$207,7,FALSE)","v":0}]
[]
[]
[null,null,"*Specific Graduate Departments"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,0,null,0,0,0,0,"Summer",null,"Summer 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[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 2017",null,"Summer 2018",null,"Summer 2019",null,"Summer 2020",null,"Summer 2021"]
[]
[null,null,0,null,0,0,0,0,"Fall",null,"Fall 2017",null,"Fall 2018",null,"Fall 2019",null,"Fall 2020",null,"Fall 2021"]
[]
[null,null,0,null,0,0,0,0,"Spring",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019",null,"Spring 2020",null,"Spring 2021"]
["*Animal Sci, Comp Sci, GDCB, Microbiology, Plant Path, BBMB, EEOB, Industrial Design, NREM"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max",null,"esc. Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4-time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2-time"]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q93/4","v":1091},null,{"$f":"O93","v":2182},null,{"$f":"Q93/2","v":2182},null,4364]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K93*$S$90","v":1136.8220000000001},{"$f":"L93*$S$90","v":0},2273.6440000000002,0,2273.6440000000002,0,4547.2880000000005]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K94*$S$90","v":1184.5685240000003},null,2369.1370480000005,null,2369.1370480000005,null,4738.274096000001]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1234.3204020080002,null,2468.6408040160004,null,2468.6408040160004,null,4937.2816080320008]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1286.1618588923363,null,2572.3237177846727,null,2572.3237177846727,null,5144.6474355693454]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1340.1806569658145,null,2680.361313931629,null,2680.361313931629,null,5360.7226278632579]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1396.4682445583787,null,2792.9364891167575,null,2792.9364891167575,null,5585.8729782335149]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1455.1199108298306,null,2910.2398216596612,null,2910.2398216596612,null,5820.4796433193223]
[]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q102/4","v":1059.25},null,{"$f":"Q102/2","v":2118.5},null,{"$f":"Q102/2","v":2118.5},null,4237]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"Q103/4","v":1091},null,{"$f":"O103","v":2182},null,{"$f":"Q103/2","v":2182},null,4364]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K103*$S$90","v":1136.8220000000001},null,{"$f":"M103*$S$90","v":2273.6440000000002},null,{"$f":"O103*$S$90","v":2273.6440000000002},null,{"$f":"Q103*$S$90","v":4547.2880000000005}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1184.5685240000003,null,2369.1370480000005,null,2369.1370480000005,null,4738.274096000001]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1234.3204020080002,null,2468.6408040160004,null,2468.6408040160004,null,4937.2816080320008]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1286.1618588923363,null,2572.3237177846727,null,2572.3237177846727,null,5144.6474355693454]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1340.1806569658145,null,2680.361313931629,null,2680.361313931629,null,5360.7226278632579]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1396.4682445583787,null,2792.9364891167575,null,2792.9364891167575,null,5585.8729782335149]
[]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q111/4","v":606.25},null,{"$f":"Q111/2","v":1212.5},null,{"$f":"Q111/2","v":1212.5},null,2425]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K111*$S$90","v":631.71249999999998},null,{"$f":"M111*$S$90","v":1263.425},null,{"$f":"O111*$S$90","v":1263.425},null,{"$f":"Q111*$S$90","v":2526.85}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K112*$S$90","v":658.24442499999998},null,{"$f":"M112*$S$90","v":1316.48885},null,{"$f":"O112*$S$90","v":1316.48885},null,{"$f":"Q112*$S$90","v":2632.9776999999999}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,685.89069085000006,null,1371.7813817000001,null,1371.7813817000001,null,{"$f":"Q113*$S$90","v":2743.5627634000002}]
[null,null,null,null,null,null,null,null,"Summer 2021",null,714.6980998657001,null,1429.3961997314002,null,1429.3961997314002,null,2858.7923994628004]
[null,null,null,null,null,null,null,null,"Summer 2022",null,744.7154200600595,null,1489.430840120119,null,1489.430840120119,null,2978.861680240238]
[null,null,null,null,null,null,null,null,"Summer 2023",null,775.99346770258205,null,1551.9869354051641,null,1551.9869354051641,null,3103.9738708103282]
[null,null,null,null,null,null,null,null,"Summer 2024",null,808.58519334609048,null,1617.170386692181,null,1617.170386692181,null,3234.3407733843619]
[]
[null,null,null,null,null,null,null,null,"Engineering & Architecture students"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q123/4","v":1258},null,{"$f":"O123","v":2516},null,{"$f":"Q123/2","v":2516},null,5032]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K123*$S$90","v":1310.836},null,{"$f":"M123*$S$90","v":2621.672},null,{"$f":"O123*$S$90","v":2621.672},null,{"$f":"Q123*$S$90","v":5243.3440000000001}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K124*$S$90","v":1365.891112},null,{"$f":"M124*$S$90","v":2731.782224},null,{"$f":"O124*$S$90","v":2731.782224},null,{"$f":"Q124*$S$90","v":5463.5644480000001}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1423.2585387040001,null,2846.5170774080002,null,2846.5170774080002,null,5693.0341548160004]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1483.0353973295682,null,2966.0707946591365,null,2966.0707946591365,null,5932.141589318273]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1545.3228840174102,null,3090.6457680348203,null,3090.6457680348203,null,6181.2915360696406]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1610.2264451461415,null,3220.452890292283,null,3220.452890292283,null,6440.9057805845659]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1677.8559558422794,null,3355.7119116845588,null,3355.7119116845588,null,6711.4238233691176]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q132/4","v":1221.25},null,{"$f":"O132","v":2442.5},null,{"$f":"Q132/2","v":2442.5},null,4885]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"Q133/4","v":1258},null,{"$f":"O133","v":2516},null,{"$f":"Q133/2","v":2516},null,5032]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K133*$S$90","v":1310.836},null,{"$f":"M133*$S$90","v":2621.672},null,{"$f":"O133*$S$90","v":2621.672},null,{"$f":"Q133*$S$90","v":5243.3440000000001}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1365.891112,null,2731.782224,null,2731.782224,null,5463.5644480000001]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1423.2585387040001,null,2846.5170774080002,null,2846.5170774080002,null,5693.0341548160004]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1483.0353973295682,null,2966.0707946591365,null,2966.0707946591365,null,5932.141589318273]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1545.3228840174102,null,3090.6457680348203,null,3090.6457680348203,null,6181.2915360696406]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1610.2264451461415,null,3220.452890292283,null,3220.452890292283,null,6440.9057805845659]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q141/4","v":700},null,{"$f":"Q141/2","v":1400},null,{"$f":"Q141/2","v":1400},null,2800]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K141*$S$90","v":729.4},null,{"$f":"M141*$S$90","v":1458.8},null,{"$f":"O141*$S$90","v":1458.8},null,{"$f":"Q141*$S$90","v":2917.6}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K142*$S$90","v":760.03480000000002},null,{"$f":"M142*$S$90","v":1520.0696},null,{"$f":"O142*$S$90","v":1520.0696},null,{"$f":"Q142*$S$90","v":3040.1392000000001}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,791.95626160000006,null,1583.9125232000001,null,1583.9125232000001,null,3167.8250464000002]
[null,null,null,null,null,null,null,null,"Summer 2021",null,825.21842458720005,null,1650.4368491744001,null,1650.4368491744001,null,3300.8736983488002]
[null,null,null,null,null,null,null,null,"Summer 2022",null,859.87759841986247,null,1719.7551968397249,null,1719.7551968397249,null,3439.5103936794499]
[null,null,null,null,null,null,null,null,"Summer 2023",null,895.99245755349671,null,1791.9849151069934,null,1791.9849151069934,null,3583.9698302139868]
[null,null,null,null,null,null,null,null,"Summer 2024",null,933.62414077074357,null,1867.2482815414871,null,1867.2482815414871,null,3734.4965630829743]
[" "]
[null,null,null,null,null,null,null,null,"Business & STB"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q153/4","v":1324.5},null,{"$f":"Q153/2","v":2649},null,{"$f":"Q153/2","v":2649},null,5298]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K153*$S$90","v":1380.1290000000001},null,{"$f":"M153*$S$90","v":2760.2580000000003},null,{"$f":"O153*$S$90","v":2760.2580000000003},null,{"$f":"Q153*$S$90","v":5520.5160000000005}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K154*$S$90","v":1438.0944180000001},null,{"$f":"M154*$S$90","v":2876.1888360000003},null,{"$f":"O154*$S$90","v":2876.1888360000003},null,{"$f":"Q154*$S$90","v":5752.3776720000005}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1498.4943835560002,null,2996.9887671120005,null,2996.9887671120005,null,5993.9775342240009]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1561.4311476653522,null,3122.8622953307045,null,3122.8622953307045,null,6245.7245906614089]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1627.011255867297,null,3254.022511734594,null,3254.022511734594,null,6508.045023469188]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1695.3457286137236,null,3390.6914572274472,null,3390.6914572274472,null,6781.3829144548945]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1766.5502492155001,null,3533.1004984310002,null,3533.1004984310002,null,7066.2009968620005]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q162/4","v":1286},null,{"$f":"Q162/2","v":2572},null,{"$f":"Q162/2","v":2572},null,5144]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"Q163/4","v":1324.5},null,{"$f":"O163","v":2649},null,{"$f":"Q163/2","v":2649},null,5298]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K163*$S$90","v":1380.1290000000001},null,{"$f":"M163*$S$90","v":2760.2580000000003},null,{"$f":"O163*$S$90","v":2760.2580000000003},null,{"$f":"Q163*$S$90","v":5520.5160000000005}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1438.0944180000001,null,2876.1888360000003,null,2876.1888360000003,null,5752.3776720000005]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1498.4943835560002,null,2996.9887671120005,null,2996.9887671120005,null,5993.9775342240009]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1561.4311476653522,null,3122.8622953307045,null,3122.8622953307045,null,6245.7245906614089]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1627.011255867297,null,3254.022511734594,null,3254.022511734594,null,6508.045023469188]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1695.3457286137236,null,3390.6914572274472,null,3390.6914572274472,null,6781.3829144548945]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q171/4","v":736.25},null,{"$f":"Q171/2","v":1472.5},null,{"$f":"Q171/2","v":1472.5},null,2945]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K171*$S$90","v":767.17250000000001},null,{"$f":"M171*$S$90","v":1534.345},null,{"$f":"O171*$S$90","v":1534.345},null,{"$f":"Q171*$S$90","v":3068.69}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K172*$S$90","v":799.39374500000008},null,{"$f":"M172*$S$90","v":1598.7874900000002},null,{"$f":"O172*$S$90","v":1598.7874900000002},null,{"$f":"Q172*$S$90","v":3197.5749800000003}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,832.96828229000016,null,1665.9365645800003,null,1665.9365645800003,null,3331.8731291600006]
[null,null,null,null,null,null,null,null,"Summer 2021",null,867.95295014618023,null,1735.9059002923605,null,1735.9059002923605,null,3471.8118005847209]
[null,null,null,null,null,null,null,null,"Summer 2022",null,904.40697405231981,null,1808.8139481046396,null,1808.8139481046396,null,3617.6278962092792]
[null,null,null,null,null,null,null,null,"Summer 2023",null,942.39206696251733,null,1884.7841339250347,null,1884.7841339250347,null,3769.5682678500693]
[null,null,null,null,null,null,null,null,"Summer 2024",null,981.97253377494314,null,1963.9450675498863,null,1963.9450675498863,null,3927.8901350997726]
[]
[null,null,null,null,null,null,null,null,"Specific Graduate Departments"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"Q183/4","v":1137.75},null,{"$f":"Q183/2","v":2275.5},null,{"$f":"Q183/2","v":2275.5},null,4551]
[null,null,null,null,null,null,null,null,"Fall 2018",null,{"$f":"K183*$S$90","v":1185.5355},null,{"$f":"M183*$S$90","v":2371.0709999999999},null,{"$f":"O183*$S$90","v":2371.0709999999999},null,{"$f":"Q183*$S$90","v":4742.1419999999998}]
[null,null,null,null,null,null,null,null,"Fall 2019",null,{"$f":"K184*$S$90","v":1235.3279910000001},null,{"$f":"M184*$S$90","v":2470.6559820000002},null,{"$f":"O184*$S$90","v":2470.6559820000002},null,{"$f":"Q184*$S$90","v":4941.3119640000004}]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1287.2117666220001,null,2574.4235332440003,null,2574.4235332440003,null,5148.8470664880006]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1341.2746608201242,null,2682.5493216402483,null,2682.5493216402483,null,5365.0986432804966]
[null,null,null,null,null,null,null,null,"Fall 2022",null,1397.6081965745693,null,2795.2163931491386,null,2795.2163931491386,null,5590.4327862982773]
[null,null,null,null,null,null,null,null,"Fall 2023",null,1456.3077408307013,null,2912.6154816614026,null,2912.6154816614026,null,5825.2309633228051]
[null,null,null,null,null,null,null,null,"Fall 2024",null,1517.4726659455907,null,3034.9453318911815,null,3034.9453318911815,null,6069.8906637823629]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2017",null,{"$f":"Q192/4","v":1059.25},null,{"$f":"Q192/2","v":2118.5},null,{"$f":"Q192/2","v":2118.5},null,4237]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"Q193/4","v":1137.75},null,{"$f":"O193","v":2275.5},null,{"$f":"Q193/2","v":2275.5},null,4551]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K193*$S$90","v":1185.5355},null,{"$f":"M193*$S$90","v":2371.0709999999999},null,{"$f":"O193*$S$90","v":2371.0709999999999},null,{"$f":"Q193*$S$90","v":4742.1419999999998}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1235.3279910000001,null,2470.6559820000002,null,2470.6559820000002,null,4941.3119640000004]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1287.2117666220001,null,2574.4235332440003,null,2574.4235332440003,null,5148.8470664880006]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1341.2746608201242,null,2682.5493216402483,null,2682.5493216402483,null,5365.0986432804966]
[null,null,null,null,null,null,null,null,"Spring 2023",null,1397.6081965745693,null,2795.2163931491386,null,2795.2163931491386,null,5590.4327862982773]
[null,null,null,null,null,null,null,null,"Spring 2024",null,1456.3077408307013,null,2912.6154816614026,null,2912.6154816614026,null,5825.2309633228051]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2017",null,{"$f":"Q201/4","v":632.5},null,{"$f":"Q201/2","v":1265},null,{"$f":"Q201/2","v":1265},null,2530]
[null,null,null,null,null,null,null,null,"Summer 2018",null,{"$f":"K201*$S$90","v":659.06500000000005},null,{"$f":"M201*$S$90","v":1318.13},null,{"$f":"O201*$S$90","v":1318.13},null,{"$f":"Q201*$S$90","v":2636.26}]
[null,null,null,null,null,null,null,null,"Summer 2019",null,{"$f":"K202*$S$90","v":686.74573000000009},null,{"$f":"M202*$S$90","v":1373.4914600000002},null,{"$f":"O202*$S$90","v":1373.4914600000002},null,{"$f":"Q202*$S$90","v":2746.9829200000004}]
[null,null,null,null,null,null,null,null,"Summer 2020",null,715.58905066000011,null,1431.1781013200002,null,1431.1781013200002,null,2862.3562026400004]
[null,null,null,null,null,null,null,null,"Summer 2021",null,745.64379078772015,null,1491.2875815754403,null,1491.2875815754403,null,2982.5751631508806]
[null,null,null,null,null,null,null,null,"Summer 2022",null,776.96083000080444,null,1553.9216600016089,null,1553.9216600016089,null,3107.8433200032177]
[null,null,null,null,null,null,null,null,"Summer 2023",null,809.59318486083828,null,1619.1863697216766,null,1619.1863697216766,null,3238.3727394433531]
[null,null,null,null,null,null,null,null,"Summer 2024",null,843.59609862499349,null,1687.192197249987,null,1687.192197249987,null,3374.384394499974]

{"sheet":"FOR SPA USE ONLY","index":4,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Sponsor:",{"$f":"'Internal budget'!D3","v":"XYZ Company"}]
["Title: ",{"$f":"'Internal budget'!D4","v":"The best proposal ever"}]
["PI Name: ",{"$f":"'Internal budget'!D5","v":"Professor Smith"}]
["Period of Performance:",{"$f":"'Internal budget'!D6","v":"1/1/2017 to 12/31/2017"}]
["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'!M703+'Internal budget'!M71+'Internal budget'!M72,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'!M73:M75),0)","v":0}]
["Total Direct Costs",null,{"$f":"'Internal budget'!M77","v":0}]
["Indirect Costs","0642",{"$f":"'Internal budget'!M82","v":0}]
["Total Costs",null,{"$f":"SUM(C25:C26)","v":0}]

{"sheet":"INDUSTRY BUDGET USE THIS","index":5,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
[{"$f":"'Internal budget'!A1","v":"Project Budget Worksheet - Iowa State University of Science and Technology"}]
["Industry Budget"]
[{"$f":"'Internal budget'!A3","v":"Program Sponsor"},{"$f":"'Internal budget'!D3","v":"XYZ Company"}]
[{"$f":"'Internal budget'!A4","v":"Title"},{"$f":"'Internal budget'!D4","v":"The best proposal ever"}]
[{"$f":"'Internal budget'!A5","v":"PI"},{"$f":"'Internal budget'!D5","v":"Professor Smith"}]
[{"$f":"'Internal budget'!A6","v":"Period of Performance"},{"$f":"'Internal budget'!D6","v":"1/1/2017 to 12/31/2017"}]
[]
[null,"Total"]
["Personnel",{"$f":"+'External budget '!M33+'External budget '!M50+'External budget '!M51+'External budget '!M52+'External budget '!M53","v":0}]
["Equipment ",{"$f":"+'External budget '!M35","v":0}]
["Travel",{"$f":"+'External budget '!M40+'External budget '!M41","v":0}]
["Materials and Supplies",{"$f":"+'External budget '!M44","v":0}]
["Subcontracts",{"$f":"+'External budget '!M48+'External budget '!M49","v":0}]
["Other",{"$f":"+'External budget '!M45+'External budget '!M46+'External budget '!M47+'External budget '!M56+'External budget '!M55+'External budget '!M54","v":0}]
["Project Total",{"$f":"SUM(B9:B14)","v":0}]