{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","F&A Calculation- Sponsor Funds ","F&A Calculations - Cost Share","Tuition","Travel"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":80,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":141,"n_cols":22,"rows_kept":141,"cut":false,"hidden":false,"merged":[[2,4,2,5],[8,18,11,18],[8,19,11,19],[0,18,0,19],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,11,17],[1,18,1,19],[125,2,125,17],[70,3,70,6],[71,3,71,6],[74,3,74,6],[123,2,123,17],[75,3,75,6],[76,3,76,6],[105,4,105,6],[73,3,73,6],[90,3,93,4],[94,3,94,4]]}
["Project Budget Worksheet - Iowa State University of Science and Technology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eff. 7/1/2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 7/22/2024"]
["Program Sponsor",null,null,null,"Enter Start Date: ",null,"2024-07-01",null,"Start Date must be entered for each budget"]
["Title",null,null,null,null,"Enter other rate as percentage (if needed): ",0,{"$f":"TRUNC(G4, 4)","v":0},"This budget is completely adjustable.  You will need to double check your work and make adjustments in certain cells, such as:",null,null,null,null,null,null,null,null,null,null,null,"Negotiated Rate","Yes"]
["PI",null,null,null,null,"Select calculation type: ","Negotiated Rate",null,"Subcontracts - Verify that only the first $25K of each subcontract is charged IDC.  You might need to adjust the MTDC for each year of each subcontract.",null,null,null,null,null,null,null,null,null,null,null,"Other TDC","No"]
["Period of Performance",null,null,null,null,"Unrecovered IDC Allowed","No",null,"Indirect costs- Budget defaults to caculate on 53% MTDC.  To use a rate other than organized research, please enter rate in 'Enter Other Rate' cell and  select the correct rate type the in dropdown.",null,null,null,null,null,null,null,null,null,null,null,"Total Project Costs (USDA TFF)"]
["Deadline",null,null,null,null,null,null,null,"For Total Project Costs (also used as the USDA NIFA Total Federal Funds calculation), enter the Total Direct Cost conversion rate.",null,null,null,null,null,null,null,null,null,null,null,"Other MTDC"]
[]
[null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total Sponsor Funds","Total Cost-Shared Matching Funds","Total Project Funds"]
[null,null,null,null,null,null,null,"Start Date","End Date","Start Date","End Date","Start Date","End Date","Start Date ","End Date","Start Date","End Date"]
[null,null,null,null,null,null,null,{"$f":"DATE(YEAR(G3),MONTH(G3),DAY(G3))","v":"2024-07-01"},{"$f":"J11-1","v":"2025-06-30"},{"$f":"DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))","v":"2025-07-01"},{"$f":"L11-1","v":"2026-06-30"},{"$f":"DATE(YEAR(G3)+2,MONTH(G3),DAY(G3))","v":"2026-07-01"},{"$f":"N11-1","v":"2027-06-30"},{"$f":"DATE(YEAR(G3)+3,MONTH(G3),DAY(G3))","v":"2027-07-01"},{"$f":"P11-1","v":"2028-06-30"},{"$f":"DATE(YEAR(G3)+4,MONTH(G3),DAY(G3))","v":"2028-07-01"},{"$f":"P11+364","v":"2029-06-30"}]
[null,null,null,null,null,null,null,"Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds","Sponsor Funds Requested","Cost-Shared  Matching Funds"]
[null,null,null,"Salary","Calendar","Academic","Summer"]
["A",null,"Key Personnel","Monthly","Months","Months","Months",{"$f":"SUM(H15:H23)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H14+J14+L14+N14+P14)","v":0},{"$f":"SUM(I14+K14+M14+O14+Q14)","v":0},{"$f":"SUM(R14+S14)","v":0}]
[null,1,null,0,0,0,0,{"$f":"D15*(E15+F15+G15)","v":0},0,{"$f":"ROUND(H15*1.03,0)","v":0},0,{"$f":"ROUND(J15*1.03,0)","v":0},0,{"$f":"ROUND(L15*1.03,0)","v":0},0,{"$f":"ROUND(N15*1.03,0)","v":0},0,{"$f":"SUM(H15+J15+L15+N15+P15)","v":0},{"$f":"SUM(I15+K15+M15+O15+Q15)","v":0},{"$f":"SUM(R15+S15)","v":0}]
[null,2,null,0,0,0,0,0,0,{"$f":"ROUND(H16*1.03,0)","v":0},0,{"$f":"ROUND(J16*1.03,0)","v":0},0,{"$f":"ROUND(L16*1.03,0)","v":0},0,{"$f":"ROUND(N16*1.03,0)","v":0},0,{"$f":"SUM(H16+J16+L16+N16+P16)","v":0},0,{"$f":"SUM(R16+S16)","v":0}]
[null,3,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Calendar",null,"Number of"]
["B",null,"Other Personnel","Monthly","Months",null,"persons",{"$f":"SUM(H26:H37)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H25+J25+L25+N25+P25)","v":0},{"$f":"SUM(I25+K25+M25+O25+Q25)","v":0},{"$f":"SUM(R25+S25)","v":0}]
[null,1,"Post Doc",0,0,null,0,{"$f":"D26*(E26)*G26","v":0},0,{"$f":"ROUND(H26*1.03,0)","v":0},0,{"$f":"ROUND(J26*1.03,0)","v":0},0,{"$f":"ROUND(L26*1.03,0)","v":0},0,{"$f":"ROUND(N26*1.03,0)","v":0},0,{"$f":"SUM(H26+J26+L26+N26+P26)","v":0},0,{"$f":"SUM(R26+S26)","v":0}]
[null,2,"Post Doc",0,0,null,0,0,0,{"$f":"ROUND(H27*1.03,0)","v":0},0,{"$f":"ROUND(J27*1.03,0)","v":0},0,{"$f":"ROUND(L27*1.03,0)","v":0},0,{"$f":"ROUND(N27*1.03,0)","v":0},0,0,0,0]
[null,3,"Research Asst-Halftime",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,"Research Asst-Halftime",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Hourly Undergraduate student",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,"Hourly Undergraduate student",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,"P&S",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,"P&S",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,"Secretarial/Clerical",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,"Secretarial/Clerical",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,11,"Non-Student Hourly",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,12,"Non-Student Hourly",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries and Wages",null,null,null,null,{"$f":"+H14+H25","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H39+J39+L39+N39+P39)","v":0},{"$f":"SUM(I39+K39+M39+O39+Q39)","v":0},{"$f":"SUM(R39+S39)","v":0}]
[]
["C",null,"Fringe Benefits","Rate",null,null,null,{"$f":"SUM(H42:H62)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H41+J41+L41+N41+P41)","v":0},{"$f":"SUM(I41+K41+M41+O41+Q41)","v":0},{"$f":"SUM(R41+S41)","v":0}]
[null,null,{"$f":"+C15","v":0},0.3,null,null,null,{"$f":"ROUND(D42*H15,0)","v":0},{"$f":"ROUND(D42*I15,0)","v":0},{"$f":"ROUND(D42*J15,0)","v":0},{"$f":"ROUND(D42*K15,0)","v":0},{"$f":"ROUND(D42*L15,0)","v":0},{"$f":"ROUND(D42*M15,0)","v":0},{"$f":"ROUND(D42*N15,0)","v":0},{"$f":"ROUND(D42*O15,0)","v":0},{"$f":"ROUND(D42*P15,0)","v":0},{"$f":"ROUND(D42*Q15,0)","v":0},{"$f":"SUM(H42+J42+L42+N42+P42)","v":0},0,{"$f":"SUM(R42+S42)","v":0}]
[null,null,{"$f":"+C16","v":0},0.3,null,null,null,{"$f":"ROUND(D43*H16,0)","v":0},{"$f":"ROUND(D43*I16,0)","v":0},{"$f":"ROUND(D43*J16,0)","v":0},{"$f":"ROUND(D43*K16,0)","v":0},{"$f":"ROUND(D43*L16,0)","v":0},{"$f":"ROUND(D43*M16,0)","v":0},{"$f":"ROUND(D43*N16,0)","v":0},{"$f":"ROUND(D43*O16,0)","v":0},{"$f":"ROUND(D43*P16,0)","v":0},{"$f":"ROUND(D43*Q16,0)","v":0},0,0,0]
[null,null,{"$f":"+C17","v":0},0.3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C18","v":0},0.3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C19","v":0},0.3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C20","v":0},0.3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C21","v":0},0.3,null,null,null,{"$f":"ROUND(D48*H21,0)","v":0},{"$f":"ROUND(D48*I21,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C22","v":0},0.3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C23","v":0},0.3,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C26","v":"Post Doc"},0.33300000000000002,null,null,null,{"$f":"ROUND(D51*H26,0)","v":0},{"$f":"ROUND(D51*I26,0)","v":0},{"$f":"ROUND(D51*J26,0)","v":0},{"$f":"ROUND(D51*K26,0)","v":0},{"$f":"ROUND(D51*L26,0)","v":0},{"$f":"ROUND(D51*M26,0)","v":0},{"$f":"ROUND(D51*N26,0)","v":0},{"$f":"ROUND(D51*O26,0)","v":0},{"$f":"ROUND(D51*P26,0)","v":0},{"$f":"ROUND(D51*Q26,0)","v":0},0,0,0]
[null,null,"Post Doc",0.33300000000000002,null,null,null,{"$f":"ROUND(D52*H27,0)","v":0},{"$f":"ROUND(D52*I27,0)","v":0},{"$f":"ROUND(D52*J27,0)","v":0},{"$f":"ROUND(D52*K27,0)","v":0},{"$f":"ROUND(D52*L27,0)","v":0},{"$f":"ROUND(D52*M27,0)","v":0},{"$f":"ROUND(D52*N27,0)","v":0},{"$f":"ROUND(D52*O27,0)","v":0},{"$f":"ROUND(D52*P27,0)","v":0},{"$f":"ROUND(D52*Q27,0)","v":0},0,0,0]
[null,null,"Research Asst-Halftime",0.14899999999999999,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Research Asst-Halftime",0.14899999999999999,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",1.9E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Hourly Undergraduate student",1.9E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C32","v":"P&S"},0.40200000000000002,null,null,null,0,0,{"$f":"ROUND(D57*J32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"P&S",0.40200000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.52400000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Secretarial/Clerical",0.52400000000000002,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",7.0999999999999994E-2,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Non-Student Hourly",7.0999999999999994E-2,null,null,null,{"$f":"ROUND(D62*H37,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Subtotal: Salaries, Wages, and Benefits",null,null,null,null,{"$f":"H39+H41","v":0},{"$f":"I39+I41","v":0},{"$f":"J39+J41","v":0},0,0,0,0,0,0,0,{"$f":"SUM(H64+J64+L64+N64+P64)","v":0},{"$f":"SUM(I64+K64+M64+O64+Q64)","v":0},{"$f":"SUM(R64+S64)","v":0}]
[]
["D",null,"Equipment (List Item and $ amount for each item > $5k)",null,null,null,null,{"$f":"SUM(H67:H68)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H66+J66+L66+N66+P66)","v":0},0,{"$f":"SUM(R66+S66)","v":0}]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R67+S67)","v":0}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(R68+S68)","v":0}]
[]
["E",null,"Travel",null,null,null,null,{"$f":"SUM(H71:H72)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H70+J70+L70+N70+P70)","v":0},0,{"$f":"SUM(R70+S70)","v":0}]
[null,null,"1. Domestic Travel",null,null,null,null,{"$f":"Yr1TravelDom","v":0},null,{"$f":"Yr2TravelDom","v":0},null,{"$f":"Yr3TravelDom","v":0},null,{"$f":"Yr4TravelDom","v":0},null,{"$f":"Yr5TravelDom","v":0},null,0,0,{"$f":"SUM(R71+S71)","v":0}]
[null,null,"2. Foreign Travel",null,null,null,null,{"$f":"Yr1TravelIntl","v":0},null,{"$f":"Yr2TravelIntl","v":0},null,{"$f":"Yr3TravelIntl","v":0},null,{"$f":"Yr4TravelIntl","v":0},null,{"$f":"Yr5TravelIntl","v":0},null,0,0,{"$f":"SUM(R72+S72)","v":0}]
[]
["F",null,"Participant Support Cost","http://www.controller.iastate.edu/spa/PSC.pdf",null,null,null,{"$f":"SUM(H75:H78)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H74+J74+L74+N74+P74)","v":0},{"$f":"SUM(I74+K74+M74+O74+Q74)","v":0},{"$f":"SUM(R74+S74)","v":0}]
[null,null,"1. Stipend",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H75+J75+L75+N75+P75)","v":0},0,{"$f":"SUM(R75+S75)","v":0}]
[null,null,"2. Travel",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R76+S76)","v":0}]
[null,null,"3. Subsistence",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R77+S77)","v":0}]
[null,null,"4. Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"SUM(R78+S78)","v":0}]
[]
["G",null,"Other Direct Costs",null,null,null,null,{"$f":"SUM(H81:H97)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(H80+J80+L80+N80+P80)","v":0},{"$f":"SUM(I80+K80+M80+O80+Q80)","v":0},{"$f":"SUM(R80+S80)","v":0}]
[null,1,"Materials and Supplies",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H81+J81+L81+N81+P81)","v":0},0,{"$f":"SUM(R81+S81)","v":0}]
[null,2,"Publication cost",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,3,"Consultant/Professional Services",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H83+J83+L83+N83+P83)","v":0},{"$f":"SUM(I83+K83+M83+O83+Q83)","v":0},{"$f":"SUM(R83+S83)","v":0}]
[null,3,"Computing support",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"Equipment/Facility Rental or User Fee",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,4,"Alterations and Renovations (not included in MTDC)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H86+J86+L86+N86+P86)","v":0},{"$f":"SUM(I86+K86+M86+O86+Q86)","v":0},{"$f":"SUM(R86+S86)","v":0}]
[null,5,"Subcontractor1 - Subject to IDC (first $25,000)",null,"See notes below",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"NOT subject to IDC (Amount over $25,000)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,6,"Subcontractor2 - Subject to IDC (first $25,000)",null,"See notes below",null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"NOT subject to IDC (Amount over $25,000)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,7,"Tuition-Most majors","https://www.grad-college.iastate.edu/handbook/chapter.php?id=3",null,"(Click on \"Tuition\" sheet)",null,{"$f":"Tuition!K6","v":0},null,{"$f":"Tuition!M6","v":0},null,{"$f":"Tuition!O6","v":0},null,{"$f":"Tuition!Q6","v":0},null,{"$f":"Tuition!S6","v":0},null,0,0,0]
[null,8,"Tuition-Bus, ENGR & Seed Tech",null,null,"(Click on \"Tuition\" sheet)",null,{"$f":"Tuition!K26","v":0},null,{"$f":"Tuition!M26","v":0},null,{"$f":"Tuition!O26","v":0},null,{"$f":"Tuition!Q26","v":0},null,{"$f":"Tuition!S26","v":0},null,0,0,0]
[null,8,"Tuition-ABE",null,null,"(Click on \"Tuition\" sheet)",null,{"$f":"Tuition!K46","v":0},null,{"$f":"Tuition!M46","v":0},null,{"$f":"Tuition!O46","v":0},null,{"$f":"Tuition!Q46","v":0},null,{"$f":"Tuition!S46","v":0},null,{"$f":"SUM(H93+J93+L93+N93+P93)","v":0},{"$f":"SUM(I93+K93+M93+O93+Q93)","v":0},{"$f":"SUM(R93+S93)","v":0}]
[null,null,"Tuition-Specific Grad Depts",null,null,"(Click on \"Tuition\" sheet)",null,{"$f":"Tuition!K67","v":0},null,{"$f":"Tuition!M67","v":0},null,{"$f":"Tuition!O67","v":0},null,{"$f":"Tuition!Q67","v":0},null,{"$f":"Tuition!S67","v":0},null,{"$f":"H94+J94+L94+N94+P94","v":0},{"$f":"SUM(I94+K94+M94+O94+Q94)","v":0},{"$f":"SUM(R94+S94)","v":0}]
[null,null,"Tuition-Experiential Learning Majors","3.3.1 Graduate Assistantship",null,"(Click on \"Tuition\" sheet)",null,{"$f":"Tuition!K88","v":0},null,{"$f":"Tuition!M88","v":0},null,{"$f":"Tuition!O88","v":0},null,{"$f":"Tuition!Q88","v":0},null,{"$f":"Tuition!S88","v":0},null,{"$f":"H95+J95+L95+N95+P95","v":0},0,0]
[null,9,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(H96+J96+L96+N96+P96)","v":0},0,0]
[null,10,"Other",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[]
[null,null,"Subtotal: Total Direct Costs (TDC)",null,null,null,null,{"$f":"H64+H66+H70+H74+H80","v":0},{"$f":"I64+I66+I70+I74+I80","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(H99+J99+L99+N99+P99)","v":0},{"$f":"SUM(I99+K99+M99+O99+Q99)","v":0},{"$f":"SUM(R99+S99)","v":0}]
[null,null,"Alternate Subtotal: Total Direct Costs Minus Subs",null,null,null,null,{"$f":"H99-H87-H88-H89-H90","v":0},{"$f":"I99-I87-I88-I89-I90","v":0},{"$f":"J99-J87-J88-J89-J90","v":0},{"$f":"K99-K87-K88-K89-K90","v":0},0,0,{"$f":"N99-N87-N88-N89-N90","v":0},0,0,0,{"$f":"SUM(H100+J100+L100+N100+P100)","v":0},{"$f":"SUM(I100+K100+M100+O100+Q100)","v":0},{"$f":"SUM(R100+S100)","v":0}]
[]
[null,null,"Subtotal: Modified Total Direct Costs",null,null,null,null,{"$f":"(H99-H66-H74-H86-H88-H90-H91-H92-H93-H94-H95)","v":0},{"$f":"(I99-I66-I74-I86-I88-I90-I91-I92-I93-I94-I95)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(H102+J102+L102+N102+P102)","v":0},{"$f":"SUM(I102+K102+M102+O102+Q102)","v":0},{"$f":"SUM(R102+S102)","v":0}]
[null,null,"[ MTDC = TDC - Tuition - Equipment - Participant Support Cost ]"]
[]
["H",null,"Indirect Costs","Rate",null,null,null,{"$f":"SUM(H106:H106)","v":0},{"$f":"SUM(I106:I107)","v":0},{"$f":"SUM(J106:J106)","v":0},{"$f":"SUM(K106:K107)","v":0},0,{"$f":"SUM(M106:M107)","v":0},0,{"$f":"SUM(O106:O107)","v":0},0,{"$f":"SUM(Q106:Q107)","v":0},{"$f":"SUM(H105+J105+L105+N105+P105)","v":0},{"$f":"SUM(I105+K105+M105+O105+Q105)","v":0},{"$f":"SUM(R105+S105)","v":0}]
[null,null,{"$f":"\"IDC on \"&G5","v":"IDC on Negotiated Rate"},{"$f":"IF(G5=U4,\"53%\",H4)","v":"53%"},{"$f":"\"[ IDC = \"&G5&\" * Indirect Rate ]\"","v":"[ IDC = Negotiated Rate * Indirect Rate ]"},null,null,{"$f":"IF($G$5=Negotiated,'F&A Calculation- Sponsor Funds '!I22,IF($G$5=OtherTDC,H99*$H$4,IF($G$5=TFF_TDC,(H99-H87-H88-H89-H90)*$H$4,IF($G$5=OtherMTDC,H102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculations - Cost Share'!I22,IF($G$5=OtherTDC,I99*$H$4,IF($G$5=TFF_TDC,(I99-I87-I88-I89-I90)*$H$4,IF($G$5=OtherMTDC,I102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculation- Sponsor Funds '!I32,IF($G$5=OtherTDC,J99*$H$4,IF($G$5=TFF_TDC,(J99-J87-J88-J89-J90)*$H$4,IF($G$5=OtherMTDC,J102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculations - Cost Share'!I32,IF($G$5=OtherTDC,K99*$H$4,IF($G$5=TFF_TDC,(K99-K87-K88-K89-K90)*$H$4,IF($G$5=OtherMTDC,K102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculation- Sponsor Funds '!I42,IF($G$5=OtherTDC,L99*$H$4,IF($G$5=TFF_TDC,(L99-L87-L88-L89-L90)*$H$4,IF($G$5=OtherMTDC,L102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculations - Cost Share'!I42,IF($G$5=OtherTDC,M99*$H$4,IF($G$5=TFF_TDC,(M99-M87-M88-M89-M90)*$H$4,IF($G$5=OtherMTDC,M102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculation- Sponsor Funds '!I52,IF($G$5=OtherTDC,N99*$H$4,IF($G$5=TFF_TDC,(N99-N87-N88-N89-N90)*$H$4,IF($G$5=OtherMTDC,N102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculations - Cost Share'!I52,IF($G$5=OtherTDC,O99*$H$4,IF($G$5=TFF_TDC,(O99-O87-O88-O89-O90)*$H$4,IF($G$5=OtherMTDC,O102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculation- Sponsor Funds '!I62,IF($G$5=OtherTDC,P99*$H$4,IF($G$5=TFF_TDC,(P99-P87-P88-P89-P90)*$H$4,IF($G$5=OtherMTDC,P102*$H$4))))","v":0},{"$f":"IF($G$5=Negotiated,'F&A Calculations - Cost Share'!I62,IF($G$5=OtherTDC,Q99*$H$4,IF($G$5=TFF_TDC,(Q99-Q87-Q88-Q89-Q90)*$H$4,IF($G$5=OtherMTDC,Q102*$H$4))))","v":0},{"$f":"SUM(H106+J106+L106+N106+P106)","v":0},{"$f":"SUM(I106+K106+M106+O106+Q106)","v":0},{"$f":"SUM(R106+S106)","v":0}]
[null,null,"Unrecovered Indirect Costs",null,null,null,null,null,{"$f":"IF($G$6=\"Yes\",(((H102+I102)*0.53)-H106-I106),0)","v":0},null,{"$f":"IF($G$6=\"Yes\",(((J102+K102)*0.53)-J106-K106),0)","v":0},null,{"$f":"IF($G$6=\"Yes\",(((L102+M102)*0.53)-L106-M106),0)","v":0},null,{"$f":"IF($G$6=\"Yes\",(((N102+O102)*0.53)-N106-O106),0)","v":0},null,{"$f":"IF($G$6=\"Yes\",(((P102+Q102)*0.53)-P106-Q106),0)","v":0},null,{"$f":"SUM(I107+K107+M107+O107+Q107)","v":0},{"$f":"S107","v":0}]
[]
[]
["I",null,"Total Direct + Indirect Costs",null,null,null,null,{"$f":"H99+H105","v":0},{"$f":"I99+I105","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(H110+J110+L110+N110+P110)","v":0},{"$f":"SUM(I110+K110+M110+O110+Q110)","v":0},{"$f":"SUM(R110+S110)","v":0}]
[null,null,"In Kind Cost Share",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I111+K111+M111+O111+Q111)","v":0},{"$f":"S111","v":0}]
[null,null,"Third Party In Kind Cost Share",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"S112","v":0}]
["J",null,"GoldSheet Total",null,null,null,null,{"$f":"H110","v":0},{"$f":"SUM(I110:I112)","v":0},{"$f":"+J110","v":0},{"$f":"SUM(K110:K112)","v":0},{"$f":"+L110","v":0},{"$f":"SUM(M110:M112)","v":0},{"$f":"+N110","v":0},{"$f":"SUM(O110:O112)","v":0},{"$f":"+P110","v":0},{"$f":"SUM(Q110:Q112)","v":0},{"$f":"+R110","v":0},0,{"$f":"SUM(R113+S113)","v":0}]
[]
[]
[]
[null,null,"Total Project Costs IDC",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Negotiated (NICRA) IDC",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"IDC Rate to Use:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"NOTES:"]
[]
[null,null,"This budget is completely adjustable.  As such, you will need to double check your work and make adjustments in certain cells, such as:"]
[]
[null,null,"Subcontracts - Verify that only the first $25K of each subcontract is charged IDC.  You might need to adjust the MTDC for each year of each subcontract."]
[]
[]
[]
[]
[null,null,"Benefits (FY24):",null,null,"Indirect Cost Categories:",null,null,null,null,"Total Project Cost F&A Rate Calculation:"]
[null,null,"Faculty",0.3]
[null,null,"Graduate Assistant ",0.14899999999999999,null,0.53,"On-Campus Organized Research"]
[null,null,"Post Doc",0.33300000000000002,null,0.53,"On Campus Instruction",null,null,null,null,"Total Project Cost F&A Rate (USDA NIFA TFF Rate)"]
[null,null,"P&S",0.40200000000000002,null,0.33,"On-Campus Other Sponsored Activities"]
[null,null,"Merit",0.52400000000000002,null,0.26,"Off-Campus All Programs",null,null,null,{"$f":"ROUNDDOWN(K134/N136,4)","v":0},"F&A Rate on Total Direct Cost*",null,{"$f":"100-K134","v":100}]
[null,null,"Student hourly",1.9E-2,null,null,null,null,null,null,null,"*F&A Rate to enter in G4"]
[null,null,"Non-Student hourly",7.0999999999999994E-2]
[null,null,"Americorps",5.0999999999999997E-2]
[null,null,"Misc.",8.1000000000000003E-2]
[null,null," "]

{"sheet":"F&A Calculation- Sponsor Funds ","index":1,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Tool to Calculate Split F&A Rates for a Project Period"]
[]
["INSTRUCTIONS:","Use this tool to help you calculate split F&A for budgeting purposes. By entering the Project Budget amount, and start and end dates, this tool will calculate the correct F&A rate for the period."]
[null,"The only fields needed are the Start Date, End Date, and the Modified Total Direct Cost Amount. This tool will calculate the F&A rate and amount based on the reference table shown."]
[]
[null,"Please be aware that if your Project period Start and End dates span multiple F&A effective dates, you will need to add the additional effective dates and rates to the Project Activity>FA Rates tab in EFS."]
[null,"See the job aid: Setting up F&A on a Project Using Split Rates"]
[]
[null,"This tool is set up to accommodate up to 7 separate Project Budget periods and will provide a Grand Total of all budget periods."]
[]
[null,null,null,"Total MTDC",null,null,null,null,"Total F&A"]
["PROJECT GRAND TOTALS:",null,null,{"$f":"D22+D32+D42+D52+D62+D72+D82","v":0},null,null,null,null,{"$f":"I22+I32+I42+I52+I62+I72+I82","v":0}]
[]
[]
["1st Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated","Reference Only \nRate Table:"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount","Use F&A Rate Effective Date","F&A Rate End","F&A Rate %"]
["Project Start Date",{"$f":"Summary!H11","v":"2024-07-01"},{"$f":"ROUND(IF((B17=0),0,(B18-B17))/30,0)","v":12},{"$f":"Summary!H102","v":0},{"$f":"IF(ISERROR(D17/F22),0,(D17/F22))","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,(MIN($B$18,$L17)-MAX($B$17,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F17/365),0,(F17/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,M17)","v":0},{"$f":"(F17*$E$17)*H17","v":0},{"$f":"IF(ISERROR(I17/H17),0,(I17/H17))","v":0},"2016-07-01","2017-06-30",0.52]
["Project End Date",{"$f":"Summary!I11","v":"2025-06-30"},null,null,null,{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,(MIN($B$18,$L18)-MAX($B$17,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F18/365),0,(F18/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,M18)","v":0},{"$f":"(F18*$E$17)*H18","v":0},{"$f":"IF(ISERROR(I18/H18),0,(I18/H18))","v":0},"2017-07-01","2018-06-30",0.52]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,(MIN($B$18,$L19)-MAX($B$17,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F19/365),0,(F19/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,M19)","v":0},{"$f":"(F19*$E$17)*H19","v":0},{"$f":"IF(ISERROR(I19/H19),0,(I19/H19))","v":0},"2018-07-01","2019-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,(MIN($B$18,$L20)-MAX($B$17,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F20/365),0,(F20/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,M20)","v":0},{"$f":"(F20*$E$17)*H20","v":0},{"$f":"IF(ISERROR(I20/H20),0,(I20/H20))","v":0},"2019-07-01","2020-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,(MIN($B$18,$L21)-MAX($B$17,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F21/365),0,(F21/365)*12),2)","v":12},{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,M21)","v":0.53},{"$f":"(F21*$E$17)*H21","v":0},{"$f":"IF(ISERROR(I21/H21),0,(I21/H21))","v":0},"2020-07-01","2030-06-30",0.53]
[null,"Totals:",null,{"$f":"SUM(D17:D21)","v":0},null,{"$f":"SUM(F17:F21)","v":365},{"$f":"SUM(G17:G21)","v":12},{"$f":"AVERAGEIF(H17:H21,\"<>0\")","v":0.53},{"$f":"SUM(I17:I21)","v":0},{"$f":"SUM(J17:J21)","v":0}]
[]
[]
["2nd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!J11","v":"2025-07-01"},{"$f":"ROUND(IF((B27=0),0,(B28-B27))/30,0)","v":12},{"$f":"Summary!J102","v":0},{"$f":"IF(ISERROR(D27/F32),0,(D27/F32))","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,(MIN($B$28,$L17)-MAX($B$27,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F27/365),0,(F27/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,M17)","v":0},{"$f":"(F27*$E$27)*H27","v":0},{"$f":"IF(ISERROR(I27/H27),0,(I27/H27))","v":0}]
["Project End Date",{"$f":"Summary!K11","v":"2026-06-30"},null,null,null,{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,(MIN($B$28,$L18)-MAX($B$27,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F28/365),0,(F28/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,M18)","v":0},{"$f":"(F28*$E$27)*H28","v":0},{"$f":"IF(ISERROR(I28/H28),0,(I28/H28))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,(MIN($B$28,$L19)-MAX($B$27,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F29/365),0,(F29/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,M19)","v":0},{"$f":"(F29*$E$27)*H29","v":0},{"$f":"IF(ISERROR(I29/H29),0,(I29/H29))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,(MIN($B$28,$L20)-MAX($B$27,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F30/365),0,(F30/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,M20)","v":0},{"$f":"(F30*$E$27)*H30","v":0},{"$f":"IF(ISERROR(I30/H30),0,(I30/H30))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,(MIN($B$28,$L21)-MAX($B$27,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F31/365),0,(F31/365))*12,0)","v":12},{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,M21)","v":0.53},{"$f":"(F31*$E$27)*H31","v":0},{"$f":"IF(ISERROR(I31/H31),0,(I31/H31))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D27:D31)","v":0},null,{"$f":"SUM(F27:F31)","v":365},{"$f":"SUM(G27:G31)","v":12},{"$f":"AVERAGEIF(H27:H31,\"<>0\")","v":0.53},{"$f":"SUM(I27:I31)","v":0},{"$f":"SUM(J27:J31)","v":0}]
[]
[]
["3rd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!L11","v":"2026-07-01"},{"$f":"ROUND(IF((B37=0),0,(B38-B37))/30,0)","v":12},{"$f":"Summary!L102","v":0},{"$f":"IF(ISERROR(D37/F42),0,(D37/F42))","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,(MIN($B$38,$L17)-MAX($B$37,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F37/365),0,(F37/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,M17)","v":0},{"$f":"(F37*$E$37)*H37","v":0},{"$f":"IF(ISERROR(I37/H37),0,(I37/H37))","v":0}]
["Project End Date",{"$f":"Summary!M11","v":"2027-06-30"},null,null,null,{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,(MIN($B$38,$L18)-MAX($B$37,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F38/365),0,(F38/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,M18)","v":0},{"$f":"(F38*$E$37)*H38","v":0},{"$f":"IF(ISERROR(I38/H38),0,(I38/H38))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,(MIN($B$38,$L19)-MAX($B$37,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F39/365),0,(F39/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,M19)","v":0},{"$f":"(F39*$E$37)*H39","v":0},{"$f":"IF(ISERROR(I39/H39),0,(I39/H39))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,(MIN($B$38,$L20)-MAX($B$37,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F40/365),0,(F40/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,M20)","v":0},{"$f":"(F40*$E$37)*H40","v":0},{"$f":"IF(ISERROR(I40/H40),0,(I40/H40))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,(MIN($B$38,$L21)-MAX($B$37,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F41/365),0,(F41/365))*12,0)","v":12},{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,M21)","v":0.53},{"$f":"(F41*$E$37)*H41","v":0},{"$f":"IF(ISERROR(I41/H41),0,(I41/H41))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D37:D41)","v":0},null,{"$f":"SUM(F37:F41)","v":365},{"$f":"SUM(G37:G41)","v":12},{"$f":"AVERAGEIF(H37:H41,\"<>0\")","v":0.53},{"$f":"SUM(I37:I41)","v":0},{"$f":"SUM(J37:J41)","v":0}]
[]
[]
["4th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!N11","v":"2027-07-01"},{"$f":"ROUND(IF((B47=0),0,(B48-B47))/30,0)","v":12},{"$f":"Summary!N102","v":0},{"$f":"IF(ISERROR(D47/F52),0,(D47/F52))","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,(MIN($B$48,$L17)-MAX($B$47,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F47/365),0,(F47/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,M17)","v":0},{"$f":"(F47*$E$47)*H47","v":0},{"$f":"IF(ISERROR(I47/H47),0,(I47/H47))","v":0}]
["Project End Date",{"$f":"Summary!O11","v":"2028-06-30"},null,null,null,{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,(MIN($B$48,$L18)-MAX($B$47,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F48/365),0,(F48/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,M18)","v":0},{"$f":"(F48*$E$47)*H48","v":0},{"$f":"IF(ISERROR(I48/H48),0,(I48/H48))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,(MIN($B$48,$L19)-MAX($B$47,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F49/365),0,(F49/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,M19)","v":0},{"$f":"(F49*$E$47)*H49","v":0},{"$f":"IF(ISERROR(I49/H49),0,(I49/H49))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,(MIN($B$48,$L20)-MAX($B$47,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F50/365),0,(F50/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,M20)","v":0},{"$f":"(F50*$E$47)*H50","v":0},{"$f":"IF(ISERROR(I50/H50),0,(I50/H50))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,(MIN($B$48,$L21)-MAX($B$47,$K21)+1))","v":366},{"$f":"ROUND(IF(ISERROR(F51/365),0,(F51/365))*12,0)","v":12},{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,M21)","v":0.53},{"$f":"(F51*$E$47)*H51","v":0},{"$f":"IF(ISERROR(I51/H51),0,(I51/H51))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D47:D51)","v":0},null,{"$f":"SUM(F47:F51)","v":366},{"$f":"SUM(G47:G51)","v":12},{"$f":"AVERAGEIF(H47:H51,\"<>0\")","v":0.53},{"$f":"SUM(I47:I51)","v":0},{"$f":"SUM(J47:J51)","v":0}]
[]
[]
["5th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!P11","v":"2028-07-01"},{"$f":"ROUND(IF((B57=0),0,(B58-B57))/30,0)","v":12},{"$f":"Summary!P102","v":0},{"$f":"IF(ISERROR(D57/F62),0,(D57/F62))","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,(MIN($B$58,$L17)-MAX($B$57,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F57/365),0,(F57/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,M17)","v":0},{"$f":"(F57*$E$57)*H57","v":0},{"$f":"IF(ISERROR(I57/H57),0,(I57/H57))","v":0}]
["Project End Date",{"$f":"Summary!Q11","v":"2029-06-30"},null,null,null,{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,(MIN($B$58,$L18)-MAX($B$57,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F58/365),0,(F58/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,M18)","v":0},{"$f":"(F58*$E$57)*H58","v":0},{"$f":"IF(ISERROR(I58/H58),0,(I58/H58))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,(MIN($B$58,$L19)-MAX($B$57,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F59/365),0,(F59/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,M19)","v":0},{"$f":"(F59*$E$57)*H59","v":0},{"$f":"IF(ISERROR(I59/H59),0,(I59/H59))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,(MIN($B$58,$L20)-MAX($B$57,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F60/365),0,(F60/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,M20)","v":0},{"$f":"(F60*$E$57)*H60","v":0},{"$f":"IF(ISERROR(I60/H60),0,(I60/H60))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,(MIN($B$58,$L21)-MAX($B$57,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F61/365),0,(F61/365))*12,0)","v":12},{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,M21)","v":0.53},{"$f":"(F61*$E$57)*H61","v":0},{"$f":"IF(ISERROR(I61/H61),0,(I61/H61))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D57:D61)","v":0},null,{"$f":"SUM(F57:F61)","v":365},{"$f":"SUM(G57:G61)","v":12},{"$f":"AVERAGEIF(H57:H61,\"<>0\")","v":0.53},{"$f":"SUM(I57:I61)","v":0},{"$f":"SUM(J57:J61)","v":0}]
[]
[]
["6th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B67=0),0,(B68-B67))/30,0)","v":0},0,{"$f":"IF(ISERROR(D67/F72),0,(D67/F72))","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,(MIN($B$68,$L17)-MAX($B$67,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F67/365),0,(F67/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,M17)","v":0},{"$f":"(F67*$E$67)*H67","v":0},{"$f":"IF(ISERROR(I67/H67),0,(I67/H67))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,(MIN($B$68,$L18)-MAX($B$67,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F68/365),0,(F68/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,M18)","v":0},{"$f":"(F68*$E$67)*H68","v":0},{"$f":"IF(ISERROR(I68/H68),0,(I68/H68))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,(MIN($B$68,$L19)-MAX($B$67,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F69/365),0,(F69/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,M19)","v":0},{"$f":"(F69*$E$67)*H69","v":0},{"$f":"IF(ISERROR(I69/H69),0,(I69/H69))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,(MIN($B$68,$L20)-MAX($B$67,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F70/365),0,(F70/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,M20)","v":0},{"$f":"(F70*$E$67)*H70","v":0},{"$f":"IF(ISERROR(I70/H70),0,(I70/H70))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,(MIN($B$68,$L21)-MAX($B$67,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F71/365),0,(F71/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,M21)","v":0},{"$f":"(F71*$E$67)*H71","v":0},{"$f":"IF(ISERROR(I71/H71),0,(I71/H71))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D67:D71)","v":0},null,{"$f":"SUM(F67:F71)","v":0},{"$f":"SUM(G67:G71)","v":0},{"$f":"AVERAGEIF(H67:H71,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I67:I71)","v":0},{"$f":"SUM(J67:J71)","v":0}]
[]
[]
["7th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B77=0),0,(B78-B77))/30,0)","v":0},0,{"$f":"IF(ISERROR(D77/F82),0,(D77/F82))","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,(MIN($B$78,$L17)-MAX($B$77,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F77/365),0,(F77/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,M17)","v":0},{"$f":"(F77*$E$77)*H77","v":0},{"$f":"IF(ISERROR(I77/H77),0,(I77/H77))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,(MIN($B$78,$L18)-MAX($B$77,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F78/365),0,(F78/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,M18)","v":0},{"$f":"(F78*$E$77)*H78","v":0},{"$f":"IF(ISERROR(I78/H78),0,(I78/H78))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,(MIN($B$78,$L19)-MAX($B$77,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F79/365),0,(F79/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,M19)","v":0},{"$f":"(F79*$E$77)*H79","v":0},{"$f":"IF(ISERROR(I79/H79),0,(I79/H79))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,(MIN($B$78,$L20)-MAX($B$77,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F80/365),0,(F80/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,M20)","v":0},{"$f":"(F80*$E$77)*H80","v":0},{"$f":"IF(ISERROR(I80/H80),0,(I80/H80))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,(MIN($B$78,$L21)-MAX($B$77,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F81/365),0,(F81/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,M21)","v":0},{"$f":"(F81*$E$77)*H81","v":0},{"$f":"IF(ISERROR(I81/H81),0,(I81/H81))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D77:D81)","v":0},null,{"$f":"SUM(F77:F81)","v":0},{"$f":"SUM(G77:G81)","v":0},{"$f":"AVERAGEIF(H77:H81,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I77:I81)","v":0},{"$f":"SUM(J77:J81)","v":0}]

{"sheet":"F&A Calculations - Cost Share","index":2,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Tool to Calculate Split F&A Rates for a Project Period"]
[]
["INSTRUCTIONS:","Use this tool to help you calculate split F&A for budgeting purposes. By entering the Project Budget amount, and start and end dates, this tool will calculate the correct F&A rate for the period."]
[null,"The only fields needed are the Start Date, End Date, and the Modified Total Direct Cost Amount. This tool will calculate the F&A rate and amount based on the reference table shown."]
[]
[null,"Please be aware that if your Project period Start and End dates span multiple F&A effective dates, you will need to add the additional effective dates and rates to the Project Activity>FA Rates tab in EFS."]
[null,"See the job aid: Setting up F&A on a Project Using Split Rates"]
[]
[null,"This tool is set up to accommodate up to 7 separate Project Budget periods and will provide a Grand Total of all budget periods."]
[]
[null,null,null,"Total MTDC",null,null,null,null,"Total F&A"]
["PROJECT GRAND TOTALS:",null,null,{"$f":"D22+D32+D42+D52+D62+D72+D82","v":0},null,null,null,null,{"$f":"I22+I32+I42+I52+I62+I72+I82","v":0}]
[]
[]
["1st Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated","Reference Only \nRate Table:"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount","Use F&A Rate Effective Date","F&A Rate End","F&A Rate %"]
["Project Start Date",{"$f":"Summary!H11","v":"2024-07-01"},{"$f":"ROUND(IF((B17=0),0,(B18-B17))/30,0)","v":12},{"$f":"Summary!I102","v":0},{"$f":"IF(ISERROR(D17/F22),0,(D17/F22))","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,(MIN($B$18,$L17)-MAX($B$17,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F17/365),0,(F17/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K17,$B$17>$L17),0,M17)","v":0},{"$f":"(F17*$E$17)*H17","v":0},{"$f":"IF(ISERROR(I17/H17),0,(I17/H17))","v":0},"2016-07-01","2017-06-30",0.52]
["Project End Date",{"$f":"Summary!I11","v":"2025-06-30"},null,null,null,{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,(MIN($B$18,$L18)-MAX($B$17,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F18/365),0,(F18/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K18,$B$17>$L18),0,M18)","v":0},{"$f":"(F18*$E$17)*H18","v":0},{"$f":"IF(ISERROR(I18/H18),0,(I18/H18))","v":0},"2017-07-01","2018-06-30",0.52]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,(MIN($B$18,$L19)-MAX($B$17,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F19/365),0,(F19/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K19,$B$17>$L19),0,M19)","v":0},{"$f":"(F19*$E$17)*H19","v":0},{"$f":"IF(ISERROR(I19/H19),0,(I19/H19))","v":0},"2018-07-01","2019-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,(MIN($B$18,$L20)-MAX($B$17,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F20/365),0,(F20/365)*12),2)","v":0},{"$f":"IF(OR($B$18<$K20,$B$17>$L20),0,M20)","v":0},{"$f":"(F20*$E$17)*H20","v":0},{"$f":"IF(ISERROR(I20/H20),0,(I20/H20))","v":0},"2019-07-01","2020-06-30",0.53]
[null,null,null,null,null,{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,(MIN($B$18,$L21)-MAX($B$17,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F21/365),0,(F21/365)*12),2)","v":12},{"$f":"IF(OR($B$18<$K21,$B$17>$L21),0,M21)","v":0.53},{"$f":"(F21*$E$17)*H21","v":0},{"$f":"IF(ISERROR(I21/H21),0,(I21/H21))","v":0},"2020-07-01","2030-06-30",0.53]
[null,"Totals:",null,{"$f":"SUM(D17:D21)","v":0},null,{"$f":"SUM(F17:F21)","v":365},{"$f":"SUM(G17:G21)","v":12},{"$f":"AVERAGEIF(H17:H21,\"<>0\")","v":0.53},{"$f":"SUM(I17:I21)","v":0},{"$f":"SUM(J17:J21)","v":0}]
[]
[]
["2nd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!J11","v":"2025-07-01"},{"$f":"ROUND(IF((B27=0),0,(B28-B27))/30,0)","v":12},{"$f":"Summary!K102","v":0},{"$f":"IF(ISERROR(D27/F32),0,(D27/F32))","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,(MIN($B$28,$L17)-MAX($B$27,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F27/365),0,(F27/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K17,$B$27>$L17),0,M17)","v":0},{"$f":"(F27*$E$27)*H27","v":0},{"$f":"IF(ISERROR(I27/H27),0,(I27/H27))","v":0}]
["Project End Date",{"$f":"Summary!K11","v":"2026-06-30"},null,null,null,{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,(MIN($B$28,$L18)-MAX($B$27,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F28/365),0,(F28/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K18,$B$27>$L18),0,M18)","v":0},{"$f":"(F28*$E$27)*H28","v":0},{"$f":"IF(ISERROR(I28/H28),0,(I28/H28))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,(MIN($B$28,$L19)-MAX($B$27,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F29/365),0,(F29/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K19,$B$27>$L19),0,M19)","v":0},{"$f":"(F29*$E$27)*H29","v":0},{"$f":"IF(ISERROR(I29/H29),0,(I29/H29))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,(MIN($B$28,$L20)-MAX($B$27,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F30/365),0,(F30/365))*12,0)","v":0},{"$f":"IF(OR($B$28<$K20,$B$27>$L20),0,M20)","v":0},{"$f":"(F30*$E$27)*H30","v":0},{"$f":"IF(ISERROR(I30/H30),0,(I30/H30))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,(MIN($B$28,$L21)-MAX($B$27,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F31/365),0,(F31/365))*12,0)","v":12},{"$f":"IF(OR($B$28<$K21,$B$27>$L21),0,M21)","v":0.53},{"$f":"(F31*$E$27)*H31","v":0},{"$f":"IF(ISERROR(I31/H31),0,(I31/H31))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D27:D31)","v":0},null,{"$f":"SUM(F27:F31)","v":365},{"$f":"SUM(G27:G31)","v":12},{"$f":"AVERAGEIF(H27:H31,\"<>0\")","v":0.53},{"$f":"SUM(I27:I31)","v":0},{"$f":"SUM(J27:J31)","v":0}]
[]
[]
["3rd Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!L11","v":"2026-07-01"},{"$f":"ROUND(IF((B37=0),0,(B38-B37))/30,0)","v":12},{"$f":"Summary!M102","v":0},{"$f":"IF(ISERROR(D37/F42),0,(D37/F42))","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,(MIN($B$38,$L17)-MAX($B$37,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F37/365),0,(F37/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K17,$B$37>$L17),0,M17)","v":0},{"$f":"(F37*$E$37)*H37","v":0},{"$f":"IF(ISERROR(I37/H37),0,(I37/H37))","v":0}]
["Project End Date",{"$f":"Summary!M11","v":"2027-06-30"},null,null,null,{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,(MIN($B$38,$L18)-MAX($B$37,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F38/365),0,(F38/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K18,$B$37>$L18),0,M18)","v":0},{"$f":"(F38*$E$37)*H38","v":0},{"$f":"IF(ISERROR(I38/H38),0,(I38/H38))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,(MIN($B$38,$L19)-MAX($B$37,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F39/365),0,(F39/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K19,$B$37>$L19),0,M19)","v":0},{"$f":"(F39*$E$37)*H39","v":0},{"$f":"IF(ISERROR(I39/H39),0,(I39/H39))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,(MIN($B$38,$L20)-MAX($B$37,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F40/365),0,(F40/365))*12,0)","v":0},{"$f":"IF(OR($B$38<$K20,$B$37>$L20),0,M20)","v":0},{"$f":"(F40*$E$37)*H40","v":0},{"$f":"IF(ISERROR(I40/H40),0,(I40/H40))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,(MIN($B$38,$L21)-MAX($B$37,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F41/365),0,(F41/365))*12,0)","v":12},{"$f":"IF(OR($B$38<$K21,$B$37>$L21),0,M21)","v":0.53},{"$f":"(F41*$E$37)*H41","v":0},{"$f":"IF(ISERROR(I41/H41),0,(I41/H41))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D37:D41)","v":0},null,{"$f":"SUM(F37:F41)","v":365},{"$f":"SUM(G37:G41)","v":12},{"$f":"AVERAGEIF(H37:H41,\"<>0\")","v":0.53},{"$f":"SUM(I37:I41)","v":0},{"$f":"SUM(J37:J41)","v":0}]
[]
[]
["4th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!N11","v":"2027-07-01"},{"$f":"ROUND(IF((B47=0),0,(B48-B47))/30,0)","v":12},{"$f":"Summary!O102","v":0},{"$f":"IF(ISERROR(D47/F52),0,(D47/F52))","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,(MIN($B$48,$L17)-MAX($B$47,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F47/365),0,(F47/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K17,$B$47>$L17),0,M17)","v":0},{"$f":"(F47*$E$47)*H47","v":0},{"$f":"IF(ISERROR(I47/H47),0,(I47/H47))","v":0}]
["Project End Date",{"$f":"Summary!O11","v":"2028-06-30"},null,null,null,{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,(MIN($B$48,$L18)-MAX($B$47,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F48/365),0,(F48/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K18,$B$47>$L18),0,M18)","v":0},{"$f":"(F48*$E$47)*H48","v":0},{"$f":"IF(ISERROR(I48/H48),0,(I48/H48))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,(MIN($B$48,$L19)-MAX($B$47,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F49/365),0,(F49/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K19,$B$47>$L19),0,M19)","v":0},{"$f":"(F49*$E$47)*H49","v":0},{"$f":"IF(ISERROR(I49/H49),0,(I49/H49))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,(MIN($B$48,$L20)-MAX($B$47,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F50/365),0,(F50/365))*12,0)","v":0},{"$f":"IF(OR($B$48<$K20,$B$47>$L20),0,M20)","v":0},{"$f":"(F50*$E$47)*H50","v":0},{"$f":"IF(ISERROR(I50/H50),0,(I50/H50))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,(MIN($B$48,$L21)-MAX($B$47,$K21)+1))","v":366},{"$f":"ROUND(IF(ISERROR(F51/365),0,(F51/365))*12,0)","v":12},{"$f":"IF(OR($B$48<$K21,$B$47>$L21),0,M21)","v":0.53},{"$f":"(F51*$E$47)*H51","v":0},{"$f":"IF(ISERROR(I51/H51),0,(I51/H51))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D47:D51)","v":0},null,{"$f":"SUM(F47:F51)","v":366},{"$f":"SUM(G47:G51)","v":12},{"$f":"AVERAGEIF(H47:H51,\"<>0\")","v":0.53},{"$f":"SUM(I47:I51)","v":0},{"$f":"SUM(J47:J51)","v":0}]
[]
[]
["5th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",{"$f":"Summary!P11","v":"2028-07-01"},{"$f":"ROUND(IF((B57=0),0,(B58-B57))/30,0)","v":12},{"$f":"Summary!Q102","v":0},{"$f":"IF(ISERROR(D57/F62),0,(D57/F62))","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,(MIN($B$58,$L17)-MAX($B$57,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F57/365),0,(F57/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K17,$B$57>$L17),0,M17)","v":0},{"$f":"(F57*$E$57)*H57","v":0},{"$f":"IF(ISERROR(I57/H57),0,(I57/H57))","v":0}]
["Project End Date",{"$f":"Summary!Q11","v":"2029-06-30"},null,null,null,{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,(MIN($B$58,$L18)-MAX($B$57,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F58/365),0,(F58/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K18,$B$57>$L18),0,M18)","v":0},{"$f":"(F58*$E$57)*H58","v":0},{"$f":"IF(ISERROR(I58/H58),0,(I58/H58))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,(MIN($B$58,$L19)-MAX($B$57,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F59/365),0,(F59/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K19,$B$57>$L19),0,M19)","v":0},{"$f":"(F59*$E$57)*H59","v":0},{"$f":"IF(ISERROR(I59/H59),0,(I59/H59))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,(MIN($B$58,$L20)-MAX($B$57,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F60/365),0,(F60/365))*12,0)","v":0},{"$f":"IF(OR($B$58<$K20,$B$57>$L20),0,M20)","v":0},{"$f":"(F60*$E$57)*H60","v":0},{"$f":"IF(ISERROR(I60/H60),0,(I60/H60))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,(MIN($B$58,$L21)-MAX($B$57,$K21)+1))","v":365},{"$f":"ROUND(IF(ISERROR(F61/365),0,(F61/365))*12,0)","v":12},{"$f":"IF(OR($B$58<$K21,$B$57>$L21),0,M21)","v":0.53},{"$f":"(F61*$E$57)*H61","v":0},{"$f":"IF(ISERROR(I61/H61),0,(I61/H61))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D57:D61)","v":0},null,{"$f":"SUM(F57:F61)","v":365},{"$f":"SUM(G57:G61)","v":12},{"$f":"AVERAGEIF(H57:H61,\"<>0\")","v":0.53},{"$f":"SUM(I57:I61)","v":0},{"$f":"SUM(J57:J61)","v":0}]
[]
[]
["6th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B67=0),0,(B68-B67))/30,0)","v":0},0,{"$f":"IF(ISERROR(D67/F72),0,(D67/F72))","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,(MIN($B$68,$L17)-MAX($B$67,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F67/365),0,(F67/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K17,$B$67>$L17),0,M17)","v":0},{"$f":"(F67*$E$67)*H67","v":0},{"$f":"IF(ISERROR(I67/H67),0,(I67/H67))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,(MIN($B$68,$L18)-MAX($B$67,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F68/365),0,(F68/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K18,$B$67>$L18),0,M18)","v":0},{"$f":"(F68*$E$67)*H68","v":0},{"$f":"IF(ISERROR(I68/H68),0,(I68/H68))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,(MIN($B$68,$L19)-MAX($B$67,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F69/365),0,(F69/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K19,$B$67>$L19),0,M19)","v":0},{"$f":"(F69*$E$67)*H69","v":0},{"$f":"IF(ISERROR(I69/H69),0,(I69/H69))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,(MIN($B$68,$L20)-MAX($B$67,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F70/365),0,(F70/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K20,$B$67>$L20),0,M20)","v":0},{"$f":"(F70*$E$67)*H70","v":0},{"$f":"IF(ISERROR(I70/H70),0,(I70/H70))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,(MIN($B$68,$L21)-MAX($B$67,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F71/365),0,(F71/365))*12,0)","v":0},{"$f":"IF(OR($B$68<$K21,$B$67>$L21),0,M21)","v":0},{"$f":"(F71*$E$67)*H71","v":0},{"$f":"IF(ISERROR(I71/H71),0,(I71/H71))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D67:D71)","v":0},null,{"$f":"SUM(F67:F71)","v":0},{"$f":"SUM(G67:G71)","v":0},{"$f":"AVERAGEIF(H67:H71,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I67:I71)","v":0},{"$f":"SUM(J67:J71)","v":0}]
[]
[]
["7th Budget Period","Enter","Calculated","Enter Amount:","Calculated",null,"Calculated",null,"Calculated","Calculated"]
[null,"Dates:","Total # Months","Total MTDC for the Period","MTDC Daily Rate","Days at Rate","Months at Rate","Use Rate","F&A Amount","MTDC Amount"]
["Project Start Date",null,{"$f":"ROUND(IF((B77=0),0,(B78-B77))/30,0)","v":0},0,{"$f":"IF(ISERROR(D77/F82),0,(D77/F82))","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,(MIN($B$78,$L17)-MAX($B$77,$K17)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F77/365),0,(F77/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K17,$B$77>$L17),0,M17)","v":0},{"$f":"(F77*$E$77)*H77","v":0},{"$f":"IF(ISERROR(I77/H77),0,(I77/H77))","v":0}]
["Project End Date",null,null,null,null,{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,(MIN($B$78,$L18)-MAX($B$77,$K18)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F78/365),0,(F78/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K18,$B$77>$L18),0,M18)","v":0},{"$f":"(F78*$E$77)*H78","v":0},{"$f":"IF(ISERROR(I78/H78),0,(I78/H78))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,(MIN($B$78,$L19)-MAX($B$77,$K19)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F79/365),0,(F79/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K19,$B$77>$L19),0,M19)","v":0},{"$f":"(F79*$E$77)*H79","v":0},{"$f":"IF(ISERROR(I79/H79),0,(I79/H79))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,(MIN($B$78,$L20)-MAX($B$77,$K20)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F80/365),0,(F80/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K20,$B$77>$L20),0,M20)","v":0},{"$f":"(F80*$E$77)*H80","v":0},{"$f":"IF(ISERROR(I80/H80),0,(I80/H80))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,(MIN($B$78,$L21)-MAX($B$77,$K21)+1))","v":0},{"$f":"ROUND(IF(ISERROR(F81/365),0,(F81/365))*12,0)","v":0},{"$f":"IF(OR($B$78<$K21,$B$77>$L21),0,M21)","v":0},{"$f":"(F81*$E$77)*H81","v":0},{"$f":"IF(ISERROR(I81/H81),0,(I81/H81))","v":0}]
[null,"Totals:",null,{"$f":"SUM(D77:D81)","v":0},null,{"$f":"SUM(F77:F81)","v":0},{"$f":"SUM(G77:G81)","v":0},{"$f":"AVERAGEIF(H77:H81,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I77:I81)","v":0},{"$f":"SUM(J77:J81)","v":0}]

{"sheet":"Tuition","index":3,"n_rows":256,"n_cols":23,"rows_kept":256,"cut":false,"hidden":false,"merged":[[79,0,83,0],[79,2,79,3],[81,2,81,3],[83,2,83,3],[84,0,85,8],[67,2,67,5],[68,2,68,5],[71,2,71,7],[73,0,77,0],[73,2,73,3],[75,2,75,3],[77,2,77,3],[38,0,42,0],[38,2,38,3],[40,2,40,3],[42,2,42,3],[32,0,36,0],[32,2,32,3],[34,2,34,3],[36,2,36,3],[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],[58,0,62,0],[58,2,58,3],[60,2,60,3],[62,2,62,3],[45,2,45,5],[52,0,56,0],[52,2,52,3],[54,2,54,3],[56,2,56,3],[46,2,46,5],[47,2,47,5],[50,2,50,7],[2,2,2,8],[10,2,10,7],[25,2,25,5],[26,2,26,5],[27,2,27,5],[30,2,30,7],[5,2,5,5],[6,2,6,5],[7,2,7,5],[66,2,66,5],[45,6,45,7],[25,6,25,7],[5,6,5,7],[66,6,66,7],[87,2,87,5],[88,2,88,5],[89,2,89,5],[92,2,92,7],[94,0,98,0],[94,2,94,3],[96,2,96,3],[98,2,98,3],[87,6,87,7],[120,20,120,22],[100,0,104,0],[100,2,100,3],[102,2,102,3],[104,2,104,3]]}
[null,null,"           Tuition Costs",null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,null,null,null,null,null,null,null,null,null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested"]
[]
[]
[null,null,"Graduate Student Tuition (most majors)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF(I6=\"1/2-time\",K7,K8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",M7,M8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",O7,O8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",Q7,Q8),0)","v":0},null,{"$f":"ROUND(IF(I6=\"1/2-time\",S7,S8),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C13*VLOOKUP(K13,$I$111:$Q$137,5,FALSE)+C15*VLOOKUP(K15,$I$111:$Q$137,5,FALSE)+C17*VLOOKUP(K17,$I$111:$Q$137,5,FALSE)+C19*VLOOKUP(K19,$I$111:$Q$137,9,FALSE)+C21*VLOOKUP(K21,$I$111:$Q$137,9,FALSE)+C23*VLOOKUP(K23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$111:$Q$137,5,FALSE)+E15*VLOOKUP(M15,$I$111:$Q$137,5,FALSE)+E17*VLOOKUP(M17,$I$111:$Q$137,5,FALSE)+E19*VLOOKUP(M19,$I$111:$Q$137,9,FALSE)+E21*VLOOKUP(M21,$I$111:$Q$137,9,FALSE)+E23*VLOOKUP(M23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$111:$Q$137,5,FALSE)+F15*VLOOKUP(O15,$I$111:$Q$137,5,FALSE)+F17*VLOOKUP(O17,$I$111:$Q$137,5,FALSE)+F19*VLOOKUP(O19,$I$111:$Q$137,9,FALSE)+F21*VLOOKUP(O21,$I$111:$Q$137,9,FALSE)+F23*VLOOKUP(O23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$111:$Q$137,5,FALSE)+G15*VLOOKUP(Q15,$I$111:$Q$137,5,FALSE)+G17*VLOOKUP(Q17,$I$111:$Q$137,5,FALSE)+G19*VLOOKUP(Q19,$I$111:$Q$137,9,FALSE)+G21*VLOOKUP(Q21,$I$111:$Q$137,9,FALSE)+G23*VLOOKUP(Q23,$I$111:$Q$137,9,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$111:$Q$137,5,FALSE)+H15*VLOOKUP(S15,$I$111:$Q$137,5,FALSE)+H17*VLOOKUP(S17,$I$111:$Q$137,5,FALSE)+H19*VLOOKUP(S19,$I$111:$Q$137,9,FALSE)+H21*VLOOKUP(S21,$I$111:$Q$137,9,FALSE)+H23*VLOOKUP(S23,$I$111:$Q$137,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C13*VLOOKUP(K13,$I$111:$Q$137,3,FALSE)+C15*VLOOKUP(K15,$I$111:$Q$137,3,FALSE)+C17*VLOOKUP(K17,$I$111:$Q$137,3,FALSE)+C19*VLOOKUP(K19,$I$111:$Q$137,7,FALSE)+C21*VLOOKUP(K21,$I$111:$Q$137,7,FALSE)+C23*VLOOKUP(K23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+E13*VLOOKUP(M13,$I$111:$Q$137,3,FALSE)+E15*VLOOKUP(M15,$I$111:$Q$137,3,FALSE)+E17*VLOOKUP(M17,$I$111:$Q$137,3,FALSE)+E19*VLOOKUP(M19,$I$111:$Q$137,7,FALSE)+E21*VLOOKUP(M21,$I$111:$Q$137,7,FALSE)+E23*VLOOKUP(M23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+F13*VLOOKUP(O13,$I$111:$Q$137,3,FALSE)+F15*VLOOKUP(O15,$I$111:$Q$137,3,FALSE)+F17*VLOOKUP(O17,$I$111:$Q$137,3,FALSE)+F19*VLOOKUP(O19,$I$111:$Q$137,7,FALSE)+F21*VLOOKUP(O21,$I$111:$Q$137,7,FALSE)+F23*VLOOKUP(O23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+G13*VLOOKUP(Q13,$I$111:$Q$137,3,FALSE)+G15*VLOOKUP(Q15,$I$111:$Q$137,3,FALSE)+G17*VLOOKUP(Q17,$I$111:$Q$137,3,FALSE)+G19*VLOOKUP(Q19,$I$111:$Q$137,7,FALSE)+G21*VLOOKUP(Q21,$I$111:$Q$137,7,FALSE)+G23*VLOOKUP(Q23,$I$111:$Q$137,7,FALSE)","v":0},null,{"$f":"+H13*VLOOKUP(S13,$I$111:$Q$137,3,FALSE)+H15*VLOOKUP(S15,$I$111:$Q$137,3,FALSE)+H17*VLOOKUP(S17,$I$111:$Q$137,3,FALSE)+H19*VLOOKUP(S19,$I$111:$Q$137,7,FALSE)+H21*VLOOKUP(S21,$I$111:$Q$137,7,FALSE)+H23*VLOOKUP(S23,$I$111:$Q$137,7,FALSE)","v":0}]
[]
[]
[null,null,"Graduate Student Tuition (most majors)"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[]
[]
[null,null,"Graduate Student Tuition (Business, Engineering & Seed Tech)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/4-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$141:$Q$167,5,FALSE)+C35*VLOOKUP(K35,$I$141:$Q$167,5,FALSE)+C37*VLOOKUP(K37,$I$141:$Q$167,5,FALSE)+C39*VLOOKUP(K39,$I$141:$Q$167,9,FALSE)+C41*VLOOKUP(K41,$I$141:$Q$167,9,FALSE)+C43*VLOOKUP(K43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$141:$Q$167,5,FALSE)+E35*VLOOKUP(M35,$I$141:$Q$167,5,FALSE)+E37*VLOOKUP(M37,$I$141:$Q$167,5,FALSE)+E39*VLOOKUP(M39,$I$141:$Q$167,9,FALSE)+E41*VLOOKUP(M41,$I$141:$Q$167,9,FALSE)+E43*VLOOKUP(M43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$141:$Q$167,5,FALSE)+F35*VLOOKUP(O35,$I$141:$Q$167,5,FALSE)+F37*VLOOKUP(O37,$I$141:$Q$167,5,FALSE)+F39*VLOOKUP(O39,$I$141:$Q$167,9,FALSE)+F41*VLOOKUP(O41,$I$141:$Q$167,9,FALSE)+F43*VLOOKUP(O43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$141:$Q$167,5,FALSE)+G35*VLOOKUP(Q35,$I$141:$Q$167,5,FALSE)+G37*VLOOKUP(Q37,$I$141:$Q$167,5,FALSE)+G39*VLOOKUP(Q39,$I$141:$Q$167,9,FALSE)+G41*VLOOKUP(Q41,$I$141:$Q$167,9,FALSE)+G43*VLOOKUP(Q43,$I$141:$Q$167,9,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$141:$Q$167,5,FALSE)+H35*VLOOKUP(S35,$I$141:$Q$167,5,FALSE)+H37*VLOOKUP(S37,$I$141:$Q$167,5,FALSE)+H39*VLOOKUP(S39,$I$141:$Q$167,9,FALSE)+H41*VLOOKUP(S41,$I$141:$Q$167,9,FALSE)+H43*VLOOKUP(S43,$I$141:$Q$167,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C33*VLOOKUP(K33,$I$141:$Q$167,3,FALSE)+C35*VLOOKUP(K35,$I$141:$Q$167,3,FALSE)+C37*VLOOKUP(K37,$I$141:$Q$167,3,FALSE)+C39*VLOOKUP(K39,$I$141:$Q$167,7,FALSE)+C41*VLOOKUP(K41,$I$141:$Q$167,7,FALSE)+C43*VLOOKUP(K43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+E33*VLOOKUP(M33,$I$141:$Q$167,3,FALSE)+E35*VLOOKUP(M35,$I$141:$Q$167,3,FALSE)+E37*VLOOKUP(M37,$I$141:$Q$167,3,FALSE)+E39*VLOOKUP(M39,$I$141:$Q$167,7,FALSE)+E41*VLOOKUP(M41,$I$141:$Q$167,7,FALSE)+E43*VLOOKUP(M43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+F33*VLOOKUP(O33,$I$141:$Q$167,3,FALSE)+F35*VLOOKUP(O35,$I$141:$Q$167,3,FALSE)+F37*VLOOKUP(O37,$I$141:$Q$167,3,FALSE)+F39*VLOOKUP(O39,$I$141:$Q$167,7,FALSE)+F41*VLOOKUP(O41,$I$141:$Q$167,7,FALSE)+F43*VLOOKUP(O43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+G33*VLOOKUP(Q33,$I$141:$Q$167,3,FALSE)+G35*VLOOKUP(Q35,$I$141:$Q$167,3,FALSE)+G37*VLOOKUP(Q37,$I$141:$Q$167,3,FALSE)+G39*VLOOKUP(Q39,$I$141:$Q$167,7,FALSE)+G41*VLOOKUP(Q41,$I$141:$Q$167,7,FALSE)+G43*VLOOKUP(Q43,$I$141:$Q$167,7,FALSE)","v":0},null,{"$f":"+H33*VLOOKUP(S33,$I$141:$Q$167,3,FALSE)+H35*VLOOKUP(S35,$I$141:$Q$167,3,FALSE)+H37*VLOOKUP(S37,$I$141:$Q$167,3,FALSE)+H39*VLOOKUP(S39,$I$141:$Q$167,7,FALSE)+H41*VLOOKUP(S41,$I$141:$Q$167,7,FALSE)+H43*VLOOKUP(S43,$I$141:$Q$167,7,FALSE)","v":0}]
[]
[]
[null,null,"Business, Engineering & Seed Tech Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[]
[]
[null,null,"Graduate Student Tuition (ABE: Ag & Biotech Engineering)",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$171:$Q$197,5,FALSE)+C55*VLOOKUP(K55,$I$171:$Q$197,5,FALSE)+C57*VLOOKUP(K57,$I$171:$Q$197,5,FALSE)+C59*VLOOKUP(K59,$I$171:$Q$197,9,FALSE)+C61*VLOOKUP(K61,$I$171:$Q$197,9,FALSE)+C63*VLOOKUP(K63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$171:$Q$197,5,FALSE)+E55*VLOOKUP(M55,$I$171:$Q$197,5,FALSE)+E57*VLOOKUP(M57,$I$171:$Q$197,5,FALSE)+E59*VLOOKUP(M59,$I$171:$Q$197,9,FALSE)+E61*VLOOKUP(M61,$I$171:$Q$197,9,FALSE)+E63*VLOOKUP(M63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$171:$Q$197,5,FALSE)+F55*VLOOKUP(O55,$I$171:$Q$197,5,FALSE)+F57*VLOOKUP(O57,$I$171:$Q$197,5,FALSE)+F59*VLOOKUP(O59,$I$171:$Q$197,9,FALSE)+F61*VLOOKUP(O61,$I$171:$Q$197,9,FALSE)+F63*VLOOKUP(O63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$171:$Q$197,5,FALSE)+G55*VLOOKUP(Q55,$I$171:$Q$197,5,FALSE)+G57*VLOOKUP(Q57,$I$171:$Q$197,5,FALSE)+G59*VLOOKUP(Q59,$I$171:$Q$197,9,FALSE)+G61*VLOOKUP(Q61,$I$171:$Q$197,9,FALSE)+G63*VLOOKUP(Q63,$I$171:$Q$197,9,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$171:$Q$197,5,FALSE)+H55*VLOOKUP(S55,$I$171:$Q$197,5,FALSE)+H57*VLOOKUP(S57,$I$171:$Q$197,5,FALSE)+H59*VLOOKUP(S59,$I$171:$Q$197,9,FALSE)+H61*VLOOKUP(S61,$I$171:$Q$197,9,FALSE)+H63*VLOOKUP(S63,$I$171:$Q$197,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C53*VLOOKUP(K53,$I$171:$Q$197,3,FALSE)+C55*VLOOKUP(K55,$I$171:$Q$197,3,FALSE)+C57*VLOOKUP(K57,$I$171:$Q$197,3,FALSE)+C59*VLOOKUP(K59,$I$171:$Q$197,7,FALSE)+C61*VLOOKUP(K61,$I$171:$Q$197,7,FALSE)+C63*VLOOKUP(K63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+E53*VLOOKUP(M53,$I$171:$Q$197,3,FALSE)+E55*VLOOKUP(M55,$I$171:$Q$197,3,FALSE)+E57*VLOOKUP(M57,$I$171:$Q$197,3,FALSE)+E59*VLOOKUP(M59,$I$171:$Q$197,7,FALSE)+E61*VLOOKUP(M61,$I$171:$Q$197,7,FALSE)+E63*VLOOKUP(M63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+F53*VLOOKUP(O53,$I$171:$Q$197,3,FALSE)+F55*VLOOKUP(O55,$I$171:$Q$197,3,FALSE)+F57*VLOOKUP(O57,$I$171:$Q$197,3,FALSE)+F59*VLOOKUP(O59,$I$171:$Q$197,7,FALSE)+F61*VLOOKUP(O61,$I$171:$Q$197,7,FALSE)+F63*VLOOKUP(O63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+G53*VLOOKUP(Q53,$I$171:$Q$197,3,FALSE)+G55*VLOOKUP(Q55,$I$171:$Q$197,3,FALSE)+G57*VLOOKUP(Q57,$I$171:$Q$197,3,FALSE)+G59*VLOOKUP(Q59,$I$171:$Q$197,7,FALSE)+G61*VLOOKUP(Q61,$I$171:$Q$197,7,FALSE)+G63*VLOOKUP(Q63,$I$171:$Q$197,7,FALSE)","v":0},null,{"$f":"+H53*VLOOKUP(S53,$I$171:$Q$197,3,FALSE)+H55*VLOOKUP(S55,$I$171:$Q$197,3,FALSE)+H57*VLOOKUP(S57,$I$171:$Q$197,3,FALSE)+H59*VLOOKUP(S59,$I$171:$Q$197,7,FALSE)+H61*VLOOKUP(S61,$I$171:$Q$197,7,FALSE)+H63*VLOOKUP(S63,$I$171:$Q$197,7,FALSE)","v":0}]
[]
[]
[null,null,"Ag & Biotech Engineering (ABE) Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,0,null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[]
[]
[]
[null,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$201:$Q$227,5,FALSE)+C76*VLOOKUP(K76,$I$201:$Q$227,5,FALSE)+C78*VLOOKUP(K78,$I$201:$Q$227,5,FALSE)+C80*VLOOKUP(K80,$I$201:$Q$227,9,FALSE)+C82*VLOOKUP(K82,$I$201:$Q$227,9,FALSE)+C84*VLOOKUP(K84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$201:$Q$227,5,FALSE)+E76*VLOOKUP(M76,$I$201:$Q$227,5,FALSE)+E78*VLOOKUP(M78,$I$201:$Q$227,5,FALSE)+E80*VLOOKUP(M80,$I$201:$Q$227,9,FALSE)+E82*VLOOKUP(M82,$I$201:$Q$227,9,FALSE)+E84*VLOOKUP(M84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$201:$Q$227,5,FALSE)+F76*VLOOKUP(O76,$I$201:$Q$227,5,FALSE)+F78*VLOOKUP(O78,$I$201:$Q$227,5,FALSE)+F80*VLOOKUP(O80,$I$201:$Q$227,9,FALSE)+F82*VLOOKUP(O82,$I$201:$Q$227,9,FALSE)+F84*VLOOKUP(O84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$201:$Q$227,5,FALSE)+G76*VLOOKUP(Q76,$I$201:$Q$227,5,FALSE)+G78*VLOOKUP(Q78,$I$201:$Q$227,5,FALSE)+G80*VLOOKUP(Q80,$I$201:$Q$227,9,FALSE)+G82*VLOOKUP(Q82,$I$201:$Q$227,9,FALSE)+G84*VLOOKUP(Q84,$I$201:$Q$227,9,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$201:$Q$227,5,FALSE)+H76*VLOOKUP(S76,$I$201:$Q$227,5,FALSE)+H78*VLOOKUP(S78,$I$201:$Q$227,5,FALSE)+H80*VLOOKUP(S80,$I$201:$Q$227,9,FALSE)+H82*VLOOKUP(S82,$I$201:$Q$227,9,FALSE)+H84*VLOOKUP(S84,$I$201:$Q$227,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C74*VLOOKUP(K74,$I$201:$Q$227,3,FALSE)+C76*VLOOKUP(K76,$I$201:$Q$227,3,FALSE)+C78*VLOOKUP(K78,$I$201:$Q$227,3,FALSE)+C80*VLOOKUP(K80,$I$201:$Q$227,7,FALSE)+C82*VLOOKUP(K82,$I$201:$Q$227,7,FALSE)+C84*VLOOKUP(K84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+E74*VLOOKUP(M74,$I$201:$Q$227,3,FALSE)+E76*VLOOKUP(M76,$I$201:$Q$227,3,FALSE)+E78*VLOOKUP(M78,$I$201:$Q$227,3,FALSE)+E80*VLOOKUP(M80,$I$201:$Q$227,7,FALSE)+E82*VLOOKUP(M82,$I$201:$Q$227,7,FALSE)+E84*VLOOKUP(M84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+F74*VLOOKUP(O74,$I$201:$Q$227,3,FALSE)+F76*VLOOKUP(O76,$I$201:$Q$227,3,FALSE)+F78*VLOOKUP(O78,$I$201:$Q$227,3,FALSE)+F80*VLOOKUP(O80,$I$201:$Q$227,7,FALSE)+F82*VLOOKUP(O82,$I$201:$Q$227,7,FALSE)+F84*VLOOKUP(O84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+G74*VLOOKUP(Q74,$I$201:$Q$227,3,FALSE)+G76*VLOOKUP(Q76,$I$201:$Q$227,3,FALSE)+G78*VLOOKUP(Q78,$I$201:$Q$227,3,FALSE)+G80*VLOOKUP(Q80,$I$201:$Q$227,7,FALSE)+G82*VLOOKUP(Q82,$I$201:$Q$227,7,FALSE)+G84*VLOOKUP(Q84,$I$201:$Q$227,7,FALSE)","v":0},null,{"$f":"+H74*VLOOKUP(S74,$I$201:$Q$227,3,FALSE)+H76*VLOOKUP(S76,$I$201:$Q$227,3,FALSE)+H78*VLOOKUP(S78,$I$201:$Q$227,3,FALSE)+H80*VLOOKUP(S80,$I$201:$Q$227,7,FALSE)+H82*VLOOKUP(S82,$I$201:$Q$227,7,FALSE)+H84*VLOOKUP(S84,$I$201:$Q$227,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,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
["*Animal Sci, Comp Sci, GDCB, Microbiology, Plant Path, EEOB, Industrial Design, NREM, Architecture"]
[]
[]
[null,null,"Graduate Student Tuition (Experiential Learning)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I88=\"1/2-time\",K89,K90),0)","v":0},null,{"$f":"ROUND(IF(I88=\"1/2-time\",M89,M90),0)","v":0},null,{"$f":"ROUND(IF($I$88=\"1/2-time\",O89,O90),0)","v":0},null,{"$f":"ROUND(IF($I$88=\"1/2-time\",Q89,Q90),0)","v":0},null,{"$f":"ROUND(IF($I$88=\"1/2-time\",S89,S90),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C95*VLOOKUP(K95,$I$231:$Q$257,5,FALSE)+C97*VLOOKUP(K97,$I$231:$Q$257,5,FALSE)+C99*VLOOKUP(K99,$I$231:$Q$257,5,FALSE)+C101*VLOOKUP(K101,$I$231:$Q$257,9,FALSE)+C103*VLOOKUP(K103,$I$231:$Q$257,9,FALSE)+C105*VLOOKUP(K105,$I$231:$Q$257,9,FALSE)","v":0},null,{"$f":"+E95*VLOOKUP(M95,$I$231:$Q$257,5,FALSE)+E97*VLOOKUP(M97,$I$231:$Q$257,5,FALSE)+E99*VLOOKUP(M99,$I$231:$Q$257,5,FALSE)+E101*VLOOKUP(M101,$I$231:$Q$257,9,FALSE)+E103*VLOOKUP(M103,$I$231:$Q$257,9,FALSE)+E105*VLOOKUP(M105,$I$231:$Q$257,9,FALSE)","v":0},null,{"$f":"+F95*VLOOKUP(O95,$I$231:$Q$257,5,FALSE)+F97*VLOOKUP(O97,$I$231:$Q$257,5,FALSE)+F99*VLOOKUP(O99,$I$231:$Q$257,5,FALSE)+F101*VLOOKUP(O101,$I$231:$Q$257,9,FALSE)+F103*VLOOKUP(O103,$I$231:$Q$257,9,FALSE)+F105*VLOOKUP(O105,$I$231:$Q$257,9,FALSE)","v":0},null,{"$f":"+G95*VLOOKUP(Q95,$I$231:$Q$257,5,FALSE)+G97*VLOOKUP(Q97,$I$231:$Q$257,5,FALSE)+G99*VLOOKUP(Q99,$I$231:$Q$257,5,FALSE)+G101*VLOOKUP(Q101,$I$231:$Q$257,9,FALSE)+G103*VLOOKUP(Q103,$I$231:$Q$257,9,FALSE)+G105*VLOOKUP(Q105,$I$231:$Q$257,9,FALSE)","v":0},null,{"$f":"+H95*VLOOKUP(S95,$I$231:$Q$257,5,FALSE)+H97*VLOOKUP(S97,$I$231:$Q$257,5,FALSE)+H99*VLOOKUP(S99,$I$231:$Q$257,5,FALSE)+H101*VLOOKUP(S101,$I$231:$Q$257,9,FALSE)+H103*VLOOKUP(S103,$I$231:$Q$257,9,FALSE)+H105*VLOOKUP(S105,$I$231:$Q$257,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C95*VLOOKUP(K95,$I$231:$Q$257,3,FALSE)+C97*VLOOKUP(K97,$I$231:$Q$257,3,FALSE)+C99*VLOOKUP(K99,$I$231:$Q$257,3,FALSE)+C101*VLOOKUP(K101,$I$231:$Q$257,7,FALSE)+C103*VLOOKUP(K103,$I$231:$Q$257,7,FALSE)+C105*VLOOKUP(K105,$I$231:$Q$257,7,FALSE)","v":0},null,{"$f":"+E95*VLOOKUP(M95,$I$231:$Q$257,3,FALSE)+E97*VLOOKUP(M97,$I$231:$Q$257,3,FALSE)+E99*VLOOKUP(M99,$I$231:$Q$257,3,FALSE)+E101*VLOOKUP(M101,$I$231:$Q$257,7,FALSE)+E103*VLOOKUP(M103,$I$231:$Q$257,7,FALSE)+E105*VLOOKUP(M105,$I$231:$Q$257,7,FALSE)","v":0},null,{"$f":"+F95*VLOOKUP(O95,$I$231:$Q$257,3,FALSE)+F97*VLOOKUP(O97,$I$231:$Q$257,3,FALSE)+F99*VLOOKUP(O99,$I$231:$Q$257,3,FALSE)+F101*VLOOKUP(O101,$I$231:$Q$257,7,FALSE)+F103*VLOOKUP(O103,$I$231:$Q$257,7,FALSE)+F105*VLOOKUP(O105,$I$231:$Q$257,7,FALSE)","v":0},null,{"$f":"+G95*VLOOKUP(Q95,$I$231:$Q$257,3,FALSE)+G97*VLOOKUP(Q97,$I$231:$Q$257,3,FALSE)+G99*VLOOKUP(Q99,$I$231:$Q$257,3,FALSE)+G101*VLOOKUP(Q101,$I$231:$Q$257,7,FALSE)+G103*VLOOKUP(Q103,$I$231:$Q$257,7,FALSE)+G105*VLOOKUP(Q105,$I$231:$Q$257,7,FALSE)","v":0},null,{"$f":"+H95*VLOOKUP(S95,$I$231:$Q$257,3,FALSE)+H97*VLOOKUP(S97,$I$231:$Q$257,3,FALSE)+H99*VLOOKUP(S99,$I$231:$Q$257,3,FALSE)+H101*VLOOKUP(S101,$I$231:$Q$257,7,FALSE)+H103*VLOOKUP(S103,$I$231:$Q$257,7,FALSE)+H105*VLOOKUP(S105,$I$231:$Q$257,7,FALSE)","v":0}]
[]
[]
[null,null,"Experiential Learning Based Majors"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2025",null,"Summer 2026",null,"Summer 2027",null,"Summer 2028",null,"Summer 2029"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2024",null,"Fall 2025",null,"Fall 2026",null,"Fall 2027",null,"Fall 2028"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2025",null,"Spring 2026",null,"Spring 2027",null,"Spring 2028",null,"Spring 2029"]
[]
[null,null,null,null,null,null,null,null,null,null,"Masters - 1/4",null,"Masters - 1/2",null,"PhD - 1/4",null,"PhD - 1/2",null,"esc. Rate",null,"Fall/Spring Current Rates:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.042,null,5746,"Graduate (most majors)"]
[null,null,null,null,null,null,null,null,"Most Majors ",null,null,null,null,null,null,null,null,null,"1/4-time",null,7355,"Ag and Biosystems"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2-time",null,7355,"Business, Eng., and Seed Tech"]
[null,null,null,null,null,null,null,null,"Fall 2024",null,{"$f":"(0.375*U108)+V123","v":2337.11},null,{"$f":"(0.75*U108)+V123","v":4491.8599999999997},null,{"$f":"(0.5*U108)+V123","v":3055.36},null,{"$f":"U108+V123","v":5928.36},null,null,null,6732,"Experiential Learning"]
[null,null,null,null,null,null,null,null,"Fall 2025",null,{"$f":"K111*$S$108","v":2435.2686200000003},null,{"$f":"M111*$S$108","v":4680.5181199999997},null,{"$f":"O111*$S$108","v":3183.6851200000001},null,{"$f":"Q111*$S$108","v":6177.3511200000003},null,null,null,6732,"Specific Grad Departments & Architecture"]
[null,null,null,null,null,null,null,null,"Fall 2026",null,{"$f":"K112*$S$108","v":2537.5499020400002},null,{"$f":"M112*$S$108","v":4877.0998810399997},null,{"$f":"O112*$S$108","v":3317.39989504},null,{"$f":"Q112*$S$108","v":6436.7998670400002}]
[null,null,null,null,null,null,null,null,"Fall 2027",null,2644.1269979256804,null,5081.9380760436798,null,3456.7306906316803,null,6707.1454614556806,null,null,null,"Summer Current Rates:"]
[null,null,null,null,null,null,null,null,"Fall 2028",null,2755.1803318385591,null,5295.3794752375143,null,3601.9133796382112,null,6988.8455708368192,null,null,null,{"$f":"3055*1.042","v":3183.31},"Graduate (most majors)"]
[null,null,null,null,null,null,null,null,"Fall 2029",null,2870.8979057757788,null,5517.78541319749,null,3753.1937415830162,null,7282.3770848119657,null,null,null,{"$f":"3910*1.042","v":4074.2200000000003},"Ag and Biosystems"]
[null,null,null,null,null,null,null,null,"Fall 2030",null,2991.4756178183616,null,5749.532400551785,null,3910.827878729503,null,7588.2369223740689,null,null,null,{"$f":"3910*1.042","v":4074.2200000000003},"Business, Eng., and Seed Tech"]
[null,null,null,null,null,null,null,null,"Fall 2031",null,3117.1175937667331,null,5991.0127613749601,null,4075.0826496361424,null,7906.9428731137805,null,null,null,{"$f":"3580*1.042","v":3730.36},"Experiential Learning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3580*1.042","v":3730.36},"Specific Grad Departments & Architecture"]
[null,null,null,null,null,null,null,null,"Spring 2025",null,{"$f":"(0.375*U108)+V123","v":2337.11},null,{"$f":"(0.75*U108)+V123","v":4491.8599999999997},null,{"$f":"(0.5*U108)+V123","v":3055.36},null,{"$f":"U108+V123","v":5928.36}]
[null,null,null,null,null,null,null,null,"Spring 2026",null,{"$f":"K120*$S$108","v":2435.2686200000003},null,{"$f":"M120*$S$108","v":4680.5181199999997},null,{"$f":"O120*$S$108","v":3183.6851200000001},null,{"$f":"Q120*$S$108","v":6177.3511200000003},null,null,null,"Graduate Student Mandatory Fees"]
[null,null,null,null,null,null,null,null,"Spring 2027",null,{"$f":"K121*$S$108","v":2537.5499020400002},null,{"$f":"M121*$S$108","v":4877.0998810399997},null,{"$f":"O121*$S$108","v":3317.39989504},null,{"$f":"Q121*$S$108","v":6436.7998670400002},null,null,null,"Year","Fall/Spring","Summer"]
[null,null,null,null,null,null,null,null,"Spring 2028",null,2644.1269979256804,null,5081.9380760436798,null,3456.7306906316803,null,6707.1454614556806,null,null,null,"2024 Fall Rates & 2025 Spring/Summer Rates",182.36,90.69]
[null,null,null,null,null,null,null,null,"Spring 2029",null,2755.1803318385591,null,5295.3794752375143,null,3601.9133796382112,null,6988.8455708368192,null,null,null,"2025 Fall Rates & 2026 Spring/Summer Rates",{"$f":"V123*$S$108","v":190.01912000000002},{"$f":"W123*$S$108","v":94.498980000000003}]
[null,null,null,null,null,null,null,null,"Spring 2030",null,2870.8979057757788,null,5517.78541319749,null,3753.1937415830162,null,7282.3770848119657,null,null,null,"2026 Fall Rates & 2027 Spring/Summer Rates",{"$f":"V124*$S$108","v":197.99992304000003},{"$f":"W124*$S$108","v":98.467937160000005}]
[null,null,null,null,null,null,null,null,"Spring 2031",null,2991.4756178183616,null,5749.532400551785,null,3910.827878729503,null,7588.2369223740689,null,null,null,"2027 Fall Rates & 2028 Spring/Summer Rates",206.31591980768005,102.60359052072]
[null,null,null,null,null,null,null,null,"Spring 2032",null,3117.1175937667331,null,5991.0127613749601,null,4075.0826496361424,null,7906.9428731137805,null,null,null,"2028 Fall Rates & 2029 Spring/Summer Rates",214.98118843960262,106.91294132259024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2029 Fall Rates & 2030 Spring/Summer Rates",224.01039835406593,111.40328485813903]
[null,null,null,null,null,null,null,null,"Summer 2025",null,{"$f":"(0.375*U115)+W123","v":1284.4312500000001},null,{"$f":"(0.75*U115)+W123","v":2478.1725000000001},null,{"$f":"(0.5*U115)+W123","v":1682.345},null,{"$f":"U115+W123","v":3274},null,null,null,"2030 Fall Rates & 2031 Spring/Summer Rates",233.41883508493672,116.08222282218088]
[null,null,null,null,null,null,null,null,"Summer 2026",null,{"$f":"K129*$S$108","v":1338.3773625000001},null,{"$f":"M129*$S$108","v":2582.2557450000004},null,{"$f":"O129*$S$108","v":1753.0034900000001},null,{"$f":"Q129*$S$108","v":3411.5080000000003},null,null,null,"2031 Fall Rates & 2032 Spring/Summer Rates",243.22242615850408,120.95767618071248]
[null,null,null,null,null,null,null,null,"Summer 2027",null,{"$f":"K130*$S$108","v":1394.5892117250003},null,{"$f":"M130*$S$108","v":2690.7104862900005},null,{"$f":"O130*$S$108","v":1826.6296365800001},null,{"$f":"Q130*$S$108","v":3554.7913360000002},null,null,null,"2032 Fall Rates & 2033 Spring/Summer Rates",253.43776805716126,126.03789858030241]
[null,null,null,null,null,null,null,null,"Summer 2028",null,1453.1619586174504,null,2803.7203267141808,null,1903.3480813163601,null,3704.0925721120002,null,null,null,"2033 Fall Rates & 2034 Spring/Summer Rates",264.08215431556204,131.33149032067513]
[null,null,null,null,null,null,null,null,"Summer 2029",null,1514.1947608793835,null,2921.4765804361764,null,1983.2887007316474,null,3859.6644601407043]
[null,null,null,null,null,null,null,null,"Summer 2030",null,1577.7909408363175,null,3044.1785968144959,null,2066.5868261623768,null,4021.7703674666141]
[null,null,null,null,null,null,null,null,"Summer 2031",null,1644.0581603514429,null,3172.0340978807048,null,2153.3834728611969,null,4190.6847229002124]
[null,null,null,null,null,null,null,null,"Summer 2032",null,1713.1086030862036,null,3305.2595299916948,null,2243.825578721367,null,4366.6934812620211]
[]
[null,null,null,null,null,null,null,null," (Business, Engineering & Seed Tech)"]
[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 2024",null,{"$f":"(0.375*U110)+V123","v":2940.4850000000001},null,{"$f":"(0.75*U110)+V123","v":5698.61},null,{"$f":"(0.5*U110)+V123","v":3859.86},null,{"$f":"U110+V123","v":7537.36}]
[null,null,null,null,null,null,null,null,"Fall 2025",null,{"$f":"K141*$S$108","v":3063.9853700000003},null,{"$f":"M141*$S$108","v":5937.9516199999998},null,{"$f":"O141*$S$108","v":4021.9741200000003},null,{"$f":"Q141*$S$108","v":7853.9291199999998}]
[null,null,null,null,null,null,null,null,"Fall 2026",null,{"$f":"K142*$S$108","v":3192.6727555400003},null,{"$f":"M142*$S$108","v":6187.3455880399997},null,{"$f":"O142*$S$108","v":4190.8970330400007},null,{"$f":"Q142*$S$108","v":8183.7941430399997}]
[null,null,null,null,null,null,null,null,"Fall 2027",null,3326.7650112726806,null,6447.2141027376802,null,4366.914708427681,null,8527.5134970476793]
[null,null,null,null,null,null,null,null,"Fall 2028",null,3466.4891417461331,null,6717.9970950526631,null,4550.325126181644,null,8885.6690639236822]
[null,null,null,null,null,null,null,null,"Fall 2029",null,3612.0816856994707,null,7000.1529730448756,null,4741.4387814812735,null,9258.8671646084767]
[null,null,null,null,null,null,null,null,"Fall 2030",null,3763.7891164988487,null,7294.1593979127611,null,4940.5792103034873,null,9647.7395855220329]
[null,null,null,null,null,null,null,null,"Fall 2031",null,3921.8682593918006,null,7600.514092625097,null,5148.0835371362336,null,10052.944648113958]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2025",null,{"$f":"(0.375*U110)+V123","v":2940.4850000000001},null,{"$f":"(0.75*U110)+V123","v":5698.61},null,{"$f":"(0.5*U110)+V123","v":3859.86},null,{"$f":"U110+V123","v":7537.36}]
[null,null,null,null,null,null,null,null,"Spring 2026",null,{"$f":"K150*$S$108","v":3063.9853700000003},null,{"$f":"M150*$S$108","v":5937.9516199999998},null,{"$f":"O150*$S$108","v":4021.9741200000003},null,{"$f":"Q150*$S$108","v":7853.9291199999998}]
[null,null,null,null,null,null,null,null,"Spring 2027",null,{"$f":"K151*$S$108","v":3192.6727555400003},null,{"$f":"M151*$S$108","v":6187.3455880399997},null,{"$f":"O151*$S$108","v":4190.8970330400007},null,{"$f":"Q151*$S$108","v":8183.7941430399997}]
[null,null,null,null,null,null,null,null,"Spring 2028",null,3326.7650112726806,null,{"$f":"M152*$S$108","v":6447.2141027376802},null,4366.914708427681,null,8527.5134970476793]
[null,null,null,null,null,null,null,null,"Spring 2029",null,3466.4891417461331,null,6717.9970950526631,null,4550.325126181644,null,8885.6690639236822]
[null,null,null,null,null,null,null,null,"Spring 2030",null,3612.0816856994707,null,7000.1529730448756,null,4741.4387814812735,null,9258.8671646084767]
[null,null,null,null,null,null,null,null,"Spring 2031",null,3763.7891164988487,null,7294.1593979127611,null,4940.5792103034873,null,9647.7395855220329]
[null,null,null,null,null,null,null,null,"Spring 2032",null,3921.8682593918006,null,7600.514092625097,null,5148.0835371362336,null,10052.944648113958]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2025",null,{"$f":"(0.375*U117)+W123","v":1618.5225},null,{"$f":"(0.75*U117)+W123","v":3146.355},null,{"$f":"(0.5*U117)+W123","v":2127.8000000000002},null,{"$f":"U117+W123","v":4164.91}]
[null,null,null,null,null,null,null,null,"Summer 2026",null,{"$f":"K159*$S$108","v":1686.5004450000001},null,{"$f":"M159*$S$108","v":3278.50191},null,{"$f":"O159*$S$108","v":2217.1676000000002},null,{"$f":"Q159*$S$108","v":4339.8362200000001}]
[null,null,null,null,null,null,null,null,"Summer 2027",null,{"$f":"K160*$S$108","v":1757.3334636900001},null,{"$f":"M160*$S$108","v":3416.1989902200003},null,{"$f":"O160*$S$108","v":2310.2886392000005},null,{"$f":"Q160*$S$108","v":4522.1093412400005}]
[null,null,null,null,null,null,null,null,"Summer 2028",null,1831.1414691649802,null,3559.6793478092404,null,2407.3207620464004,null,4712.0379335720809]
[null,null,null,null,null,null,null,null,"Summer 2029",null,1908.0494108699095,null,3709.1858804172289,null,2508.4282340523491,null,4909.9435267821082]
[null,null,null,null,null,null,null,null,"Summer 2030",null,1988.1874861264457,null,3864.9716873947527,null,2613.7822198825479,null,5116.1611549069567]
[null,null,null,null,null,null,null,null,"Summer 2031",null,2071.6913605437567,null,4027.3004982653324,null,2723.5610731176148,null,5331.0399234130491]
[null,null,null,null,null,null,null,null,"Summer 2032",null,2158.7023976865944,null,4196.4471191924767,null,2837.9506381885549,null,5554.9436001963977]
[]
[null,null,null,null,null,null,null,null,"ABE - Ag & Biotech Engineering"]
[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 2024",null,{"$f":"(0.375*U109)+V123","v":2940.4850000000001},null,{"$f":"(0.75*U109)+V123","v":5698.61},null,{"$f":"(0.5*U109)+V123","v":3859.86},null,{"$f":"U109+V123","v":7537.36}]
[null,null,null,null,null,null,null,null,"Fall 2025",null,{"$f":"K171*$S$108","v":3063.9853700000003},null,{"$f":"M171*$S$108","v":5937.9516199999998},null,{"$f":"O171*$S$108","v":4021.9741200000003},null,{"$f":"Q171*$S$108","v":7853.9291199999998}]
[null,null,null,null,null,null,null,null,"Fall 2026",null,{"$f":"K172*$S$108","v":3192.6727555400003},null,{"$f":"M172*$S$108","v":6187.3455880399997},null,{"$f":"O172*$S$108","v":4190.8970330400007},null,{"$f":"Q172*$S$108","v":8183.7941430399997}]
[null,null,null,null,null,null,null,null,"Fall 2027",null,3326.7650112726806,null,6447.2141027376802,null,4366.914708427681,null,8527.5134970476793]
[null,null,null,null,null,null,null,null,"Fall 2028",null,3466.4891417461331,null,6717.9970950526631,null,4550.325126181644,null,8885.6690639236822]
[null,null,null,null,null,null,null,null,"Fall 2029",null,3612.0816856994707,null,7000.1529730448756,null,4741.4387814812735,null,9258.8671646084767]
[null,null,null,null,null,null,null,null,"Fall 2030",null,3763.7891164988487,null,7294.1593979127611,null,4940.5792103034873,null,9647.7395855220329]
[null,null,null,null,null,null,null,null,"Fall 2031",null,3921.8682593918006,null,7600.514092625097,null,5148.0835371362336,null,10052.944648113958]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2025",null,{"$f":"(0.375*U109)+V123","v":2940.4850000000001},null,{"$f":"(0.75*U109)+V123","v":5698.61},null,{"$f":"(0.5*U109)+V123","v":3859.86},null,{"$f":"U109+V123","v":7537.36}]
[null,null,null,null,null,null,null,null,"Spring 2026",null,{"$f":"K180*$S$108","v":3063.9853700000003},null,{"$f":"M180*$S$108","v":5937.9516199999998},null,{"$f":"O180*$S$108","v":4021.9741200000003},null,{"$f":"Q180*$S$108","v":7853.9291199999998}]
[null,null,null,null,null,null,null,null,"Spring 2027",null,{"$f":"K181*$S$108","v":3192.6727555400003},null,{"$f":"M181*$S$108","v":6187.3455880399997},null,{"$f":"O181*$S$108","v":4190.8970330400007},null,{"$f":"Q181*$S$108","v":8183.7941430399997}]
[null,null,null,null,null,null,null,null,"Spring 2028",null,3326.7650112726806,null,6447.2141027376802,null,4366.914708427681,null,8527.5134970476793]
[null,null,null,null,null,null,null,null,"Spring 2029",null,3466.4891417461331,null,6717.9970950526631,null,4550.325126181644,null,8885.6690639236822]
[null,null,null,null,null,null,null,null,"Spring 2030",null,3612.0816856994707,null,7000.1529730448756,null,4741.4387814812735,null,9258.8671646084767]
[null,null,null,null,null,null,null,null,"Spring 2031",null,3763.7891164988487,null,7294.1593979127611,null,4940.5792103034873,null,9647.7395855220329]
[null,null,null,null,null,null,null,null,"Spring 2032",null,3921.8682593918006,null,7600.514092625097,null,5148.0835371362336,null,10052.944648113958]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2025",null,{"$f":"(0.375*U116)+W123","v":1618.5225},null,{"$f":"(0.75*U116)+W123","v":3146.355},null,{"$f":"(0.5*U116)+W123","v":2127.8000000000002},null,{"$f":"U116+W123","v":4164.91}]
[null,null,null,null,null,null,null,null,"Summer 2026",null,{"$f":"K189*$S$108","v":1686.5004450000001},null,{"$f":"M189*$S$108","v":3278.50191},null,{"$f":"O189*$S$108","v":2217.1676000000002},null,{"$f":"Q189*$S$108","v":4339.8362200000001}]
[null,null,null,null,null,null,null,null,"Summer 2027",null,{"$f":"K190*$S$108","v":1757.3334636900001},null,{"$f":"M190*$S$108","v":3416.1989902200003},null,{"$f":"O190*$S$108","v":2310.2886392000005},null,{"$f":"Q190*$S$108","v":4522.1093412400005}]
[null,null,null,null,null,null,null,null,"Summer 2028",null,1831.1414691649802,null,3559.6793478092404,null,2407.3207620464004,null,4712.0379335720809]
[null,null,null,null,null,null,null,null,"Summer 2029",null,1908.0494108699095,null,3709.1858804172289,null,2508.4282340523491,null,4909.9435267821082]
[null,null,null,null,null,null,null,null,"Summer 2030",null,1988.1874861264457,null,3864.9716873947527,null,2613.7822198825479,null,5116.1611549069567]
[null,null,null,null,null,null,null,null,"Summer 2031",null,2071.6913605437567,null,4027.3004982653324,null,2723.5610731176148,null,5331.0399234130491]
[null,null,null,null,null,null,null,null,"Summer 2032",null,2158.7023976865944,null,4196.4471191924767,null,2837.9506381885549,null,5554.9436001963977]
[]
[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 2024",null,{"$f":"(0.375*U112)+V123","v":2706.86},null,{"$f":"(0.75*U112)+V123","v":5231.3599999999997},null,{"$f":"(0.5*U112)+V123","v":3548.36},null,{"$f":"U112+V123","v":6914.36}]
[null,null,null,null,null,null,null,null,"Fall 2025",null,{"$f":"K201*$S$108","v":2820.5481200000004},null,{"$f":"M201*$S$108","v":5451.0771199999999},null,{"$f":"O201*$S$108","v":3697.3911200000002},null,{"$f":"Q201*$S$108","v":7204.7631199999996}]
[null,null,null,null,null,null,null,null,"Fall 2026",null,{"$f":"K202*$S$108","v":2939.0111410400004},null,{"$f":"M202*$S$108","v":5680.0223590400001},null,{"$f":"O202*$S$108","v":3852.6815470400002},null,{"$f":"Q202*$S$108","v":7507.3631710399995}]
[null,null,null,null,null,null,null,null,"Fall 2027",null,3062.4496089636805,null,5918.58329811968,null,4014.4941720156803,null,7822.6724242236796]
[null,null,null,null,null,null,null,null,"Fall 2028",null,3191.0724925401551,null,6167.163796640707,null,4183.1029272403393,null,8151.2246660410747]
[null,null,null,null,null,null,null,null,"Fall 2029",null,3325.0975372268417,null,6426.1846760996168,null,4358.7932501844334,null,8493.5761020148002]
[null,null,null,null,null,null,null,null,"Fall 2030",null,3464.7516337903694,null,6696.0844324958007,null,4541.8625666921798,null,8850.3062982994215]
[null,null,null,null,null,null,null,null,"Fall 2031",null,3610.2712024095649,null,6977.3199786606247,null,4732.6207944932512,null,9222.0191628279972]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2025",null,{"$f":"(0.375*U112)+V123","v":2706.86},null,{"$f":"(0.75*U112)+V123","v":5231.3599999999997},null,{"$f":"(0.5*U112)+V123","v":3548.36},null,{"$f":"U112+V123","v":6914.36}]
[null,null,null,null,null,null,null,null,"Spring 2026",null,{"$f":"K210*$S$108","v":2820.5481200000004},null,{"$f":"M210*$S$108","v":5451.0771199999999},null,{"$f":"O210*$S$108","v":3697.3911200000002},null,{"$f":"Q210*$S$108","v":7204.7631199999996}]
[null,null,null,null,null,null,null,null,"Spring 2027",null,{"$f":"K211*$S$108","v":2939.0111410400004},null,{"$f":"M211*$S$108","v":5680.0223590400001},null,{"$f":"O211*$S$108","v":3852.6815470400002},null,{"$f":"Q211*$S$108","v":7507.3631710399995}]
[null,null,null,null,null,null,null,null,"Spring 2028",null,3062.4496089636805,null,5918.58329811968,null,4014.4941720156803,null,7822.6724242236796]
[null,null,null,null,null,null,null,null,"Spring 2029",null,3191.0724925401551,null,6167.163796640707,null,4183.1029272403393,null,8151.2246660410747]
[null,null,null,null,null,null,null,null,"Spring 2030",null,3325.0975372268417,null,6426.1846760996168,null,4358.7932501844334,null,8493.5761020148002]
[null,null,null,null,null,null,null,null,"Spring 2031",null,3464.7516337903694,null,6696.0844324958007,null,4541.8625666921798,null,8850.3062982994215]
[null,null,null,null,null,null,null,null,"Spring 2032",null,3610.2712024095649,null,6977.3199786606247,null,4732.6207944932512,null,9222.0191628279972]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2025",null,{"$f":"(0.375*U119)+W123","v":1489.575},null,{"$f":"(0.75*U119)+W123","v":2888.46},null,{"$f":"(0.5*U119)+W123","v":1955.8700000000001},null,{"$f":"U119+W123","v":3821.05}]
[null,null,null,null,null,null,null,null,"Summer 2026",null,{"$f":"K219*$S$108","v":1552.13715},null,{"$f":"M219*$S$108","v":3009.7753200000002},null,{"$f":"O219*$S$108","v":2038.0165400000003},null,{"$f":"Q219*$S$108","v":3981.5341000000003}]
[null,null,null,null,null,null,null,null,"Summer 2027",null,{"$f":"K220*$S$108","v":1617.3269103},null,{"$f":"M220*$S$108","v":3136.1858834400005},null,{"$f":"O220*$S$108","v":2123.6132346800005},null,{"$f":"Q220*$S$108","v":4148.7585322000004}]
[null,null,null,null,null,null,null,null,"Summer 2028",null,1685.2546405326,null,3267.9056905444804,null,2212.8049905365606,null,4323.0063905524003]
[null,null,null,null,null,null,null,null,"Summer 2029",null,1756.0353354349693,null,3405.1577295473489,null,2305.7428001390963,null,4504.5726589556016]
[null,null,null,null,null,null,null,null,"Summer 2030",null,1829.7888195232381,null,3548.1743541883379,null,2402.5839977449386,null,4693.7647106317372]
[null,null,null,null,null,null,null,null,"Summer 2031",null,1906.6399499432141,null,3697.1976770642482,null,2503.4925256502261,null,4890.9028284782707]
[null,null,null,null,null,null,null,null,"Summer 2032",null,1986.7188278408291,null,3852.4799795009467,null,2608.6392117275354,null,5096.3207472743579]
[]
[null,null,null,null,null,null,null,null,"Experiential Learning Based Majors"]
[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 2024",null,{"$f":"(0.375*U111)+V123","v":2706.86},null,{"$f":"(0.75*U111)+V123","v":5231.3599999999997},null,{"$f":"(0.5*U111)+V123","v":3548.36},null,{"$f":"U111+V123","v":6914.36}]
[null,null,null,null,null,null,null,null,"Fall 2025",null,{"$f":"K231*$S$108","v":2820.5481200000004},null,{"$f":"M231*$S$108","v":5451.0771199999999},null,{"$f":"O231*$S$108","v":3697.3911200000002},null,{"$f":"Q231*$S$108","v":7204.7631199999996}]
[null,null,null,null,null,null,null,null,"Fall 2026",null,{"$f":"K232*$S$108","v":2939.0111410400004},null,{"$f":"M232*$S$108","v":5680.0223590400001},null,{"$f":"O232*$S$108","v":3852.6815470400002},null,{"$f":"Q232*$S$108","v":7507.3631710399995}]
[null,null,null,null,null,null,null,null,"Fall 2027",null,3062.4496089636805,null,5918.58329811968,null,4014.4941720156803,null,7822.6724242236796]
[null,null,null,null,null,null,null,null,"Fall 2028",null,3191.0724925401551,null,6167.163796640707,null,4183.1029272403393,null,8151.2246660410747]
[null,null,null,null,null,null,null,null,"Fall 2029",null,3325.0975372268417,null,6426.1846760996168,null,4358.7932501844334,null,8493.5761020148002]
[null,null,null,null,null,null,null,null,"Fall 2030",null,3464.7516337903694,null,{"$f":"M236*$S$108","v":6696.0844324958007},null,4541.8625666921798,null,8850.3062982994215]
[null,null,null,null,null,null,null,null,"Fall 2031",null,3610.2712024095649,null,6977.3199786606247,null,4732.6207944932512,null,9222.0191628279972]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2025",null,{"$f":"(0.375*U111)+V123","v":2706.86},null,{"$f":"(0.75*U111)+V123","v":5231.3599999999997},null,{"$f":"(0.5*U111)+V123","v":3548.36},null,{"$f":"U111+V123","v":6914.36}]
[null,null,null,null,null,null,null,null,"Spring 2026",null,{"$f":"K240*$S$108","v":2820.5481200000004},null,{"$f":"M240*$S$108","v":5451.0771199999999},null,{"$f":"O240*$S$108","v":3697.3911200000002},null,{"$f":"Q240*$S$108","v":7204.7631199999996}]
[null,null,null,null,null,null,null,null,"Spring 2027",null,{"$f":"K241*$S$108","v":2939.0111410400004},null,{"$f":"M241*$S$108","v":5680.0223590400001},null,{"$f":"O241*$S$108","v":3852.6815470400002},null,{"$f":"Q241*$S$108","v":7507.3631710399995}]
[null,null,null,null,null,null,null,null,"Spring 2028",null,3062.4496089636805,null,5918.58329811968,null,4014.4941720156803,null,7822.6724242236796]
[null,null,null,null,null,null,null,null,"Spring 2029",null,3191.0724925401551,null,6167.163796640707,null,4183.1029272403393,null,8151.2246660410747]
[null,null,null,null,null,null,null,null,"Spring 2030",null,3325.0975372268417,null,6426.1846760996168,null,4358.7932501844334,null,8493.5761020148002]
[null,null,null,null,null,null,null,null,"Spring 2031",null,3464.7516337903694,null,{"$f":"M245*$S$108","v":6696.0844324958007},null,4541.8625666921798,null,8850.3062982994215]
[null,null,null,null,null,null,null,null,"Spring 2032",null,3610.2712024095649,null,6977.3199786606247,null,4732.6207944932512,null,9222.0191628279972]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2025",null,{"$f":"(0.375*U118)+W123","v":1489.575},null,{"$f":"(0.75*U118)+W123","v":2888.46},null,{"$f":"(0.5*U118)+W123","v":1955.8700000000001},null,{"$f":"U118+W123","v":3821.05}]
[null,null,null,null,null,null,null,null,"Summer 2026",null,{"$f":"K249*$S$108","v":1552.13715},null,{"$f":"M249*$S$108","v":3009.7753200000002},null,{"$f":"O249*$S$108","v":2038.0165400000003},null,{"$f":"Q249*$S$108","v":3981.5341000000003}]
[null,null,null,null,null,null,null,null,"Summer 2027",null,{"$f":"K250*$S$108","v":1617.3269103},null,{"$f":"M250*$S$108","v":3136.1858834400005},null,{"$f":"O250*$S$108","v":2123.6132346800005},null,{"$f":"Q250*$S$108","v":4148.7585322000004}]
[null,null,null,null,null,null,null,null,"Summer 2028",null,1685.2546405326,null,3267.9056905444804,null,2212.8049905365606,null,4323.0063905524003]
[null,null,null,null,null,null,null,null,"Summer 2029",null,1756.0353354349693,null,3405.1577295473489,null,2305.7428001390963,null,4504.5726589556016]
[null,null,null,null,null,null,null,null,"Summer 2030",null,1829.7888195232381,null,3548.1743541883379,null,2402.5839977449386,null,4693.7647106317372]
[null,null,null,null,null,null,null,null,"Summer 2031",null,1906.6399499432141,null,3697.1976770642482,null,2503.4925256502261,null,4890.9028284782707]
[null,null,null,null,null,null,null,null,"Summer 2032",null,1986.7188278408291,null,3852.4799795009467,null,2608.6392117275354,null,5096.3207472743579]

{"sheet":"Travel","index":4,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[31,0,31,12],[32,4,32,6],[32,7,32,9],[29,0,29,12],[1,0,1,12],[2,0,2,12],[4,0,4,12],[5,4,5,6],[5,7,5,9]]}
[]
["Iowa State Travel Policies: http://www.controller.iastate.edu/travelinformation/homepage.htm"]
["Iowa State Mileage Guide: http://www.controller.iastate.edu/travelinformation/mileageguideiowa.pdf"]
[]
["Domestic Travel"]
[null,null,null,null,"Lodging  ",null,null,"Meals"]
["Year","Purpose & Destination","# of People","Airfare/ Person","# Nights","Rate per Night","Lodging Total","# Meal Days","Meal Cost per Day","Meal Total","Ground Transportation","Registration Per Person","TOTAL"]
[1,null,0,0,0,0,{"$f":"ROUND(+E8*F8,)","v":0},1,40,{"$f":"+H8*I8","v":40},0,0,{"$f":"ROUND(C8*SUM(D8,G8,J8,L8,K8),)","v":0}]
[1,null,0,0,0,0,{"$f":"ROUND(+E9*F9,)","v":0},{"$f":"+E9+1","v":1},40,{"$f":"+H9*I9","v":40},0,0,{"$f":"ROUND(C9*SUM(D9,G9,J9,L9,K9),)","v":0}]
[1,null,0,0,0,0,{"$f":"ROUND(+E10*F10,)","v":0},{"$f":"+E10+1","v":1},40,{"$f":"+H10*I10","v":40},0,0,{"$f":"C10*SUM(D10,G10,J10,L10,K10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 1 Total",{"$f":"ROUND(SUM(M8:M10),0)","v":0}]
[2,null,0,{"$f":"ROUND(+D8*1.03,)","v":0},0,{"$f":"ROUND(+F8*1.03,)","v":0},{"$f":"ROUND(+E12*F12,)","v":0},{"$f":"+E12+1","v":1},40,{"$f":"+H12*I12","v":40},0,0,{"$f":"ROUND(C12*SUM(D12,G12,J12,L12,K12),)","v":0}]
[2,null,0,{"$f":"ROUND(+D9*1.03,)","v":0},0,{"$f":"ROUND(+F9*1.03,)","v":0},{"$f":"ROUND(+E13*F13,)","v":0},{"$f":"+E13+1","v":1},40,{"$f":"+H13*I13","v":40},0,0,{"$f":"ROUND(C13*SUM(D13,G13,J13,L13,K13),)","v":0}]
[2,null,0,{"$f":"ROUND(+D10*1.03,)","v":0},0,{"$f":"ROUND(+F10*1.03,)","v":0},{"$f":"ROUND(+E14*F14,)","v":0},{"$f":"+E14+1","v":1},40,{"$f":"+H14*I14","v":40},0,0,{"$f":"ROUND(C14*SUM(D14,G14,J14,L14,K14),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 2 Total",{"$f":"ROUND(SUM(M12:M14),0)","v":0}]
[3,null,0,{"$f":"ROUND(+D12*1.03,)","v":0},0,{"$f":"ROUND(+F12*1.03,)","v":0},{"$f":"ROUND(+E16*F16,)","v":0},{"$f":"+E16+1","v":1},40,{"$f":"+H16*I16","v":40},0,0,{"$f":"ROUND(C16*SUM(D16,G16,J16,L16,K16),)","v":0}]
[3,null,0,{"$f":"ROUND(+D13*1.03,)","v":0},0,{"$f":"ROUND(+F13*1.03,)","v":0},{"$f":"ROUND(+E17*F17,)","v":0},{"$f":"+E17+1","v":1},40,{"$f":"+H17*I17","v":40},0,0,{"$f":"ROUND(C17*SUM(D17,G17,J17,L17,K17),)","v":0}]
[3,null,0,{"$f":"ROUND(+D14*1.03,)","v":0},0,{"$f":"ROUND(+F14*1.03,)","v":0},{"$f":"ROUND(+E18*F18,)","v":0},{"$f":"+E18+1","v":1},40,{"$f":"+H18*I18","v":40},0,0,{"$f":"ROUND(C18*SUM(D18,G18,J18,L18,K18),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 3 Total",{"$f":"ROUND(SUM(M16:M18),0)","v":0}]
[4,null,0,{"$f":"ROUND(+D16*1.03,)","v":0},0,{"$f":"ROUND(+F16*1.03,)","v":0},{"$f":"ROUND(+E20*F20,)","v":0},{"$f":"+E20+1","v":1},40,{"$f":"+H20*I20","v":40},0,0,{"$f":"ROUND(C20*SUM(D20,G20,J20,L20,K20),)","v":0}]
[4,null,0,{"$f":"ROUND(+D17*1.03,)","v":0},0,{"$f":"ROUND(+F17*1.03,)","v":0},{"$f":"ROUND(+E21*F21,)","v":0},{"$f":"+E21+1","v":1},40,{"$f":"+H21*I21","v":40},0,0,{"$f":"ROUND(C21*SUM(D21,G21,J21,L21,K21),)","v":0}]
[4,null,0,{"$f":"ROUND(+D18*1.03,)","v":0},0,{"$f":"ROUND(+F18*1.03,)","v":0},{"$f":"ROUND(+E22*F22,)","v":0},{"$f":"+E22+1","v":1},40,{"$f":"+H22*I22","v":40},0,0,{"$f":"ROUND(C22*SUM(D22,G22,J22,L22,K22),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 4 Total",{"$f":"ROUND(SUM(M20:M22),0)","v":0}]
[5,null,0,{"$f":"ROUND(+D20*1.03,)","v":0},0,{"$f":"ROUND(+F20*1.03,)","v":0},{"$f":"ROUND(+E24*F24,)","v":0},{"$f":"+E24+1","v":1},40,{"$f":"+H24*I24","v":40},0,0,{"$f":"ROUND(C24*SUM(D24,G24,J24,L24,K24),)","v":0}]
[5,null,0,{"$f":"ROUND(+D21*1.03,)","v":0},0,{"$f":"ROUND(+F21*1.03,)","v":0},{"$f":"ROUND(+E25*F25,)","v":0},{"$f":"+E25+1","v":1},40,{"$f":"+H25*I25","v":40},0,0,{"$f":"ROUND(C25*SUM(D25,G25,J25,L25,K25),)","v":0}]
[5,null,0,{"$f":"ROUND(+D22*1.03,)","v":0},0,{"$f":"ROUND(+F22*1.03,)","v":0},{"$f":"ROUND(+E26*F26,)","v":0},{"$f":"+E26+1","v":1},40,{"$f":"+H26*I26","v":40},0,0,{"$f":"ROUND(C26*SUM(D26,G26,J26,L26,K26),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 5 Total",{"$f":"ROUND(SUM(M24:M26),0)","v":0}]
[]
[]
["Dept of State Per Diem Rates: https://aoprals.state.gov/web920/per_diem.asp"]
[]
["International Travel"]
[null,null,null,null,"Lodging  ",null,null,"Meals"]
["Year","Purpose & Destination","# of People","Airfare/ Person","# Nights","Rate per Night","Lodging Total","# Meal Days","Meal Cost per Day","Meal Total","Ground Transportation","Registration Per Person","TOTAL"]
[1,null,0,0,0,0,{"$f":"ROUND(+E35*F35,)","v":0},{"$f":"+E35+1","v":1},40,{"$f":"+H35*I35","v":40},0,0,{"$f":"ROUND(C35*SUM(D35,G35,J35,L35,K35),)","v":0}]
[1,null,0,0,0,0,{"$f":"ROUND(+E36*F36,)","v":0},{"$f":"+E36+1","v":1},40,{"$f":"+H36*I36","v":40},0,0,{"$f":"ROUND(C36*SUM(D36,G36,J36,L36,K36),)","v":0}]
[1,null,0,0,0,0,{"$f":"ROUND(+E37*F37,)","v":0},{"$f":"+E37+1","v":1},40,{"$f":"+H37*I37","v":40},0,0,{"$f":"C37*SUM(D37,G37,J37,L37,K37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 1 Total",{"$f":"ROUND(SUM(M35:M37),0)","v":0}]
[2,null,0,{"$f":"ROUND(+D35*1.03,)","v":0},0,{"$f":"ROUND(+F35*1.03,)","v":0},{"$f":"ROUND(+E39*F39,)","v":0},{"$f":"+E39+1","v":1},40,{"$f":"+H39*I39","v":40},0,0,{"$f":"ROUND(C39*SUM(D39,G39,J39,L39,K39),)","v":0}]
[2,null,0,{"$f":"ROUND(+D36*1.03,)","v":0},0,{"$f":"ROUND(+F36*1.03,)","v":0},{"$f":"ROUND(+E40*F40,)","v":0},{"$f":"+E40+1","v":1},40,{"$f":"+H40*I40","v":40},0,0,{"$f":"ROUND(C40*SUM(D40,G40,J40,L40,K40),)","v":0}]
[2,null,0,{"$f":"ROUND(+D37*1.03,)","v":0},0,{"$f":"ROUND(+F37*1.03,)","v":0},{"$f":"ROUND(+E41*F41,)","v":0},{"$f":"+E41+1","v":1},40,{"$f":"+H41*I41","v":40},0,0,{"$f":"ROUND(C41*SUM(D41,G41,J41,L41,K41),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 2 Total",{"$f":"ROUND(SUM(M39:M41),0)","v":0}]
[3,null,0,{"$f":"ROUND(+D39*1.03,)","v":0},0,{"$f":"ROUND(+F39*1.03,)","v":0},{"$f":"ROUND(+E43*F43,)","v":0},{"$f":"+E43+1","v":1},40,{"$f":"+H43*I43","v":40},0,0,{"$f":"ROUND(C43*SUM(D43,G43,J43,L43,K43),)","v":0}]
[3,null,0,{"$f":"ROUND(+D40*1.03,)","v":0},0,{"$f":"ROUND(+F40*1.03,)","v":0},{"$f":"ROUND(+E44*F44,)","v":0},{"$f":"+E44+1","v":1},40,{"$f":"+H44*I44","v":40},0,0,{"$f":"ROUND(C44*SUM(D44,G44,J44,L44,K44),)","v":0}]
[3,null,0,{"$f":"ROUND(+D41*1.03,)","v":0},0,{"$f":"ROUND(+F41*1.03,)","v":0},{"$f":"ROUND(+E45*F45,)","v":0},{"$f":"+E45+1","v":1},40,{"$f":"+H45*I45","v":40},0,0,{"$f":"ROUND(C45*SUM(D45,G45,J45,L45,K45),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 3 Total",{"$f":"ROUND(SUM(M43:M45),0)","v":0}]
[4,null,0,{"$f":"ROUND(+D43*1.03,)","v":0},0,{"$f":"ROUND(+F43*1.03,)","v":0},{"$f":"ROUND(+E47*F47,)","v":0},{"$f":"+E47+1","v":1},40,{"$f":"+H47*I47","v":40},0,0,{"$f":"ROUND(C47*SUM(D47,G47,J47,L47,K47),)","v":0}]
[4,null,0,{"$f":"ROUND(+D44*1.03,)","v":0},0,{"$f":"ROUND(+F44*1.03,)","v":0},{"$f":"ROUND(+E48*F48,)","v":0},{"$f":"+E48+1","v":1},40,{"$f":"+H48*I48","v":40},0,0,{"$f":"ROUND(C48*SUM(D48,G48,J48,L48,K48),)","v":0}]
[4,null,0,{"$f":"ROUND(+D45*1.03,)","v":0},0,{"$f":"ROUND(+F45*1.03,)","v":0},{"$f":"ROUND(+E49*F49,)","v":0},{"$f":"+E49+1","v":1},40,{"$f":"+H49*I49","v":40},0,0,{"$f":"ROUND(C49*SUM(D49,G49,J49,L49,K49),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 4 Total",{"$f":"ROUND(SUM(M47:M49),0)","v":0}]
[5,null,0,{"$f":"ROUND(+D47*1.03,)","v":0},0,{"$f":"ROUND(+F47*1.03,)","v":0},{"$f":"ROUND(+E51*F51,)","v":0},{"$f":"+E51+1","v":1},40,{"$f":"+H51*I51","v":40},0,0,{"$f":"ROUND(C51*SUM(D51,G51,J51,L51,K51),)","v":0}]
[5,null,0,{"$f":"ROUND(+D48*1.03,)","v":0},0,{"$f":"ROUND(+F48*1.03,)","v":0},{"$f":"ROUND(+E52*F52,)","v":0},{"$f":"+E52+1","v":1},40,{"$f":"+H52*I52","v":40},0,0,{"$f":"ROUND(C52*SUM(D52,G52,J52,L52,K52),)","v":0}]
[5,null,0,{"$f":"ROUND(+D49*1.03,)","v":0},0,{"$f":"ROUND(+F49*1.03,)","v":0},{"$f":"ROUND(+E53*F53,)","v":0},{"$f":"+E53+1","v":1},40,{"$f":"+H53*I53","v":40},0,0,{"$f":"ROUND(C53*SUM(D53,G53,J53,L53,K53),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Year 5 Total",{"$f":"ROUND(SUM(M51:M53),0)","v":0}]