{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Title","F&A Rates","Fringe Rates","Salaries Yr 1","Salaries Yr 2","Salaries Yr 3","Salaries Yr 4","Salaries Yr 5","Tuition Remission","Supplies","Equipment & Capital","Travel","Participant Support Costs","Other Direct","Sub-Agreements","MTDC","Total","NIH Modular"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":0,"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":"Title","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,6],[14,0,14,8],[1,2,1,10],[3,2,3,10],[5,8,5,9],[7,2,7,8],[11,5,11,7]]}
[null,null,null,"Worksheet for Project Budget"]
["Sponsor:"]
[]
["Project Title:"]
[]
["Project Period:",null,"Begin:",null,"End:",null,"Years:",null,"Enter number of years in project."]
[]
["Principal Investigator:"]
[]
["Indirect Cost Rate:",null,0.55500000000000005,"     Inflation rate:",null,0.03]
[]
["Indirect Cost Base:",null,"MTDC",null,null,"NIH policy is to inflate at \nno more than 3% per year."]
[]
["NOTE: DHHS budgets have a salary cap of Executive Level II the current cap is:",null,null,null,null,null,null,228000]
["Please see: https://www.rsp.wisc.edu/awardmgt/NIHSalCap_change.html for additional salary guidance."]

{"sheet":"F&A Rates","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[12,0,13,0],[14,0,14,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,8,0],[5,1,6,1],[5,2,6,2]]}
["Table of Indirect Cost Rates Rate Agreement"]
[" "]
["Effective July 1, 2025 through June 30, 2026"]
[]
["Source of Funds","Applicable To","Indirect Cost Rate"]
["Federal, Non-Direct Federal Federal, For Profit Entities, Non-Profit Entities, Non-Federal governmental Agencies","Research","55.5% of MTDC"]
[null," "," "]
[null,"Public Service","38.0% of MTDC"]
[null,"Instruction","53.0% of MTDC"]
["Industry-Sponsored\n(new trials effective 7/11/2025)","Clinical Trials","32.0% of TDC"]
["All Sources","All Off Campus Programs","26.0% of MTDC"]
[]
["Governmental Agencies within the State of WI*","DHFS, DOA, DWD, DOT, DNR, DATCP, Dane County, Madison School Districts & Other State of WI governmental Units","15.0% of TDC"]
[null,"DPI, WI Tech College System","8.0% of TDC"]
["*All applications to State of WI Agencies must include indirect costs with a footnote stating, \"If funded with State GPR funds or other nonfederal funds, indirect costs should be excluded from the award.\""]
[]
["Any rates other than those detailed in the above grid must be:"]
[]
["               *Approved on Non-Federal Indirect Cost Exception List,"]
["               *Stipulated by donor's published policy, or                                                                                                                                                                                      "]
["               *Approved by the Director of RSP"]
[]
[{"$f":"YEAR(DATE(IF(AND(MONTH( TODAY() ) >= 7, MONTH( TODAY() ) <= 12), YEAR( TODAY() ), YEAR( TODAY() )-1), 7, 1))+1","v":2026}]

{"sheet":"Fringe Rates","index":2,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Fringe Rates","FY 2026"]
[]
["Category","Rate"]
["Academic Staff",0.34699999999999998]
["Ad Hoc Program Specialists",0.14599999999999999]
["Grad Interns",0.253]
["Limited Term Employees",0.10100000000000001]
["Post-Doc Fellows and/or Trainees",0.158]
["Pre-Doc Fellows and/or Trainees",0.20699999999999999]
["Program Assistants",0.20699999999999999]
["Project Assistants",0.20699999999999999]
["Regular University Staff",0.43099999999999999]
["Regular Faculty",0.34699999999999998]
["Research Assistants",0.20699999999999999]
["Research Associates",0.253]
["Student Hourly Employes",1.9E-2]
["Teaching Assistants",0.20699999999999999]
["Undergraduate Assistants",0.14599999999999999]
["Undergraduate Interns",0.14599999999999999]

{"sheet":"Salaries Yr 1","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,25,4]]}
[null,null,"Worksheet for Project Budget",null,"Year:",1]
["Salaries & Wages*"]
["Name","Title","Salary Category","Salary & Wages Base","Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost"]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((IF(E5=\"Hourly (H basis)\",D5,(D5/IF(E5=\"Annual (A basis)\",12,9)*F5*G5))),0)","v":0},{"$f":"IF(ISBLANK(C5),0,(VLOOKUP(C5,Fringe_Array,2, FALSE())+($F$1*1%)))","v":0},{"$f":"ROUND((I5*H5),0)","v":0},{"$f":"SUM(H5,J5)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[]
["* Payments to UW Hospital employees for salary reimbursements, see Services.",null,null,null,null,null,"Total Salaries & Wages",{"$f":"ROUND(SUM(H5:H21),0)","v":0},"Total Fringe Benefits",{"$f":"ROUND(SUM(J5:J21),0)","v":0}]
[null,null,null,null,null,null,null,null,"Total Salary, Wage, Fringe",{"$f":"SUM(J23,H23)","v":0}]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]

{"sheet":"Salaries Yr 2","index":4,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,25,4]]}
[null,null,"Worksheet for Project Budget",null,"Year:",2]
["Salaries & Wages*"]
["Name","Title","Salary Category","Salary & Wages Base","Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost"]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((IF(E5=\"Hourly (H basis)\",D5,(D5/IF(E5=\"Annual (A basis)\",12,9)*F5*G5))),0)","v":0},{"$f":"IF(ISBLANK(C5),0,(VLOOKUP(C5,Fringe_Array,2, FALSE())+($F$1*1%)))","v":0},{"$f":"ROUND((I5*H5),0)","v":0},{"$f":"SUM(H5,J5)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C22),0,(LOOKUP(C22,categories, rates)+($F$1*1%)))","v":0},0,0]
["* Payments to UW Hospital employees for salary reimbursements, see Services.",null,null,null,null,null,"Total Salaries & Wages",{"$f":"ROUND(SUM(H5:H21),0)","v":0},"Total Fringe Benefits",{"$f":"ROUND(SUM(J5:J21),0)","v":0}]
[null,null,null,null,null,null,null,null,"Total Salary, Wage, Fringe",{"$f":"SUM(J23,H23)","v":0}]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]

{"sheet":"Salaries Yr 3","index":5,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,25,4]]}
[null,null,"Worksheet for Project Budget",null,"Year:",3]
["Salaries & Wages*"]
["Name","Title","Salary Category","Salary & Wages Base","Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost"]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((IF(E5=\"Hourly (H basis)\",D5,(D5/IF(E5=\"Annual (A basis)\",12,9)*F5*G5))),0)","v":0},{"$f":"IF(ISBLANK(C5),0,(VLOOKUP(C5,Fringe_Array,2,FALSE())+($F$1*1%)))","v":0},{"$f":"ROUND((I5*H5),0)","v":0},{"$f":"SUM(H5,J5)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[]
["* Payments to UW Hospital employees for salary reimbursements, see Services.",null,null,null,null,null,"Total Salaries & Wages",{"$f":"ROUND(SUM(H5:H21),0)","v":0},"Total Fringe Benefits",{"$f":"ROUND(SUM(J5:J21),0)","v":0}]
[null,null,null,null,null,null,null,null,"Total Salary, Wage, Fringe",{"$f":"SUM(J23,H23)","v":0}]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]

{"sheet":"Salaries Yr 4","index":6,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,25,4]]}
[null,null,"Worksheet for Project Budget",null,"Year:",4]
["Salaries & Wages*"]
["Name","Title","Salary Category","Salary & Wages Base","Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost"]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((IF(E5=\"Hourly (H basis)\",D5,(D5/IF(E5=\"Annual (A basis)\",12,9)*F5*G5))),0)","v":0},{"$f":"IF(ISBLANK(C5),0,(VLOOKUP(C5,Fringe_Array,2,FALSE())+($F$1*1%)))","v":0},{"$f":"ROUND((I5*H5),0)","v":0},{"$f":"SUM(H5,J5)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[]
["* Payments to UW Hospital employees for salary reimbursements, see Services.",null,null,null,null,null,"Total Salaries & Wages",{"$f":"ROUND(SUM(H5:H21),0)","v":0},"Total Fringe Benefits",{"$f":"ROUND(SUM(J5:J21),0)","v":0}]
[null,null,null,null,null,null,null,null,"Total Salary, Wage, Fringe",{"$f":"SUM(J23,H23)","v":0}]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]

{"sheet":"Salaries Yr 5","index":7,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,25,4]]}
[null,null,"Worksheet for Project Budget",null,"Year:",5]
["Salaries & Wages*"]
["Name","Title","Salary Category","Salary & Wages Base","Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost"]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((IF(E5=\"Hourly (H basis)\",D5,(D5/IF(E5=\"Annual (A basis)\",12,9)*F5*G5))),0)","v":0},{"$f":"IF(ISBLANK(C5),0,(VLOOKUP(C5,Fringe_Array,2,FALSE())+($F$1*1%)))","v":0},{"$f":"ROUND((I5*H5),0)","v":0},{"$f":"SUM(H5,J5)","v":0}]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,0]
[]
["* Payments to UW Hospital employees for salary reimbursements, see Services.",null,null,null,null,null,"Total Salaries & Wages",{"$f":"ROUND(SUM(H5:H21),0)","v":0},"Total Fringe Benefits",{"$f":"ROUND(SUM(J5:J21),0)","v":0}]
[null,null,null,null,null,null,null,null,"Total Salary, Wage, Fringe",{"$f":"SUM(J23,H23)","v":0}]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]

{"sheet":"Tuition Remission","index":8,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6],[14,0,16,6]]}
["Worksheet for Project Budget"]
["Tuition Remission"]
[]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
["Select First Semester","Select…","Select…","Select…","Select…","Select…"]
["Number of PA/RA",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
["Sub-Total",{"$f":"ROUND(B6*IF(B5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(C6*IF(C5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(D6*IF(D5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(E6*IF(E5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(F6*IF(F5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"SUM(B7:F7)","v":0}]
["Select Second Semester","Select…","Select…","Select…","Select…","Select…"]
["Number of PA/RA",null,null,null,null,null,{"$f":"SUM(B9:F9)","v":0}]
["Sub-Total",{"$f":"ROUND(B9*IF(B8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(C9*IF(C8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(D9*IF(D8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(E9*IF(E8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(F9*IF(F8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"SUM(B10:F10)","v":0}]
[]
["Total Tuition Remission",{"$f":"ROUND(SUM(B7, B10),0)","v":0},{"$f":"ROUND(SUM(C7, C10),0)","v":0},{"$f":"ROUND(SUM(D7, D10),0)","v":0},{"$f":"ROUND(SUM(E7, E10),0)","v":0},{"$f":"ROUND(SUM(F7, F10),0)","v":0},{"$f":"SUM(B12:F12)","v":0}]
[]
[]
["NOTE:  To ensure that you have requested sufficient funds to cover the cost of Tuition Remission,   please indicate the number of PA/RA students you will have in each year.  If you expect to have one student for the full budget year and another for half the budget year, you may indicate 1.5 students."]

{"sheet":"Supplies","index":9,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
["Supplies"]
[]
["Category","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
["Research/Lab Supplies",null,null,null,null,null,{"$f":"SUM(B5:F5)","v":0}]
["Office Supplies",null,null,null,null,null,0]
["Equipment & Furniture (items less than $5000)",null,0,0,0,0,0]
["Research Equipment (items less than $5000).",null,null,null,null,0,0]
["Office Equipment & Furniture (items less than $5000)",null,null,null,0,0,0]
["Computer Equipment (items less than $5000)",null,null,null,0,0,0]
["Experimental Animals",null,null,null,null,null,0]
["Fuel for Vehicles",null,null,null,null,null,0]
["Printing & Duplicating",null,null,null,null,null,0]
["Publication & Reprints",null,null,null,0,0,0]
["Drafting, Photographic, Film Processing Supplies",null,null,null,0,0,0]
["Other Supplies",null,null,null,null,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[]
["Total Supplies",{"$f":"ROUND(SUM(B5:B19),0)","v":0},0,0,0,0,0]

{"sheet":"Equipment & Capital","index":10,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
["Equipment & Other Capital (individual items over $5,000)"]
[]
["Category","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
["Research/Lab Equipment (items over $5000)"]
[null,null,null,null,0,0,{"$f":"SUM(B6:F6)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B7:F7)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B8:F8)","v":0}]
["Office Equipment             (items over $5000)"]
[null,null,0,0,0,0,{"$f":"SUM(B10:F10)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B11:F11)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B12:F12)","v":0}]
["Computer Equipment           (items over $5000)"]
[null,null,null,null,null,null,{"$f":"SUM(B14:F14)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B15:F15)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B16:F16)","v":0}]
["Other Equipment             (items over $5000)"]
[null,null,null,null,null,null,{"$f":"SUM(B18:F18)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B19:F19)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B20:F20)","v":0}]
["Construction/Fabrication Component Parts (used to create items over $5000)"]
[null,null,null,null,null,null,{"$f":"SUM(B22:F22)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B23:F23)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B24:F24)","v":0}]
["Equipment to be Purchased on Multiple Funds (items under $5000; total cost over $5000)"]
[null,null,null,null,null,null,{"$f":"SUM(B26:F26)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B27:F27)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B28:F28)","v":0}]
["Permanent Additions to the Library"]
[null,null,null,null,null,null,{"$f":"SUM(B30:F30)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B31:F31)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B32:F32)","v":0}]
[]
["Total Equipment & Other Capital",{"$f":"ROUND(SUM(B5:B32),0)","v":0},0,0,0,0,0]

{"sheet":"Travel","index":11,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
["Travel"]
[]
["Category","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
["Domestic"]
["      Fleet Charges",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
["      Conferences/Conventions",null,null,null,null,null,{"$f":"SUM(B7:F7)","v":0}]
["      Business/Research Travel",null,null,null,null,null,{"$f":"SUM(B8:F8)","v":0}]
["      Other",null,null,null,null,null,{"$f":"SUM(B9:F9)","v":0}]
["Conference & Meeting Expenses (UW hosted events)"]
["      Meals/Refreshments",null,null,null,null,null,{"$f":"SUM(B11:F11)","v":0}]
["      Lodging & Transportation",null,null,null,null,null,{"$f":"SUM(B12:F12)","v":0}]
["      Space & Equipment Rental",null,null,null,null,null,{"$f":"SUM(B13:F13)","v":0}]
["      Other",null,null,null,null,null,{"$f":"SUM(B14:F14)","v":0}]
[]
["Total Domestic Travel",{"$f":"ROUND(SUM(B6:B14),0)","v":0},0,0,0,0,0]
["Foreign"]
[null,null,null,null,null,null,{"$f":"SUM(B18:F18)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B19:F19)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(B20:F20)","v":0}]
[]
["Total  Foreign Travel",{"$f":"ROUND(SUM(B18:B20),0)","v":0},0,0,0,0,0]
[]
["Total Travel",{"$f":"ROUND(SUM(B16,B22),0)","v":0},0,0,0,0,0]

{"sheet":"Participant Support Costs","index":12,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[13,1,13,2],[15,0,15,6]]}
["Worksheet for Project Budget"]
["Participant Support Costs (Excluded from MTDC)"]
["May be included in NIH budget only if specifically identified as allowable in the Funding Opportunity Announcement. For the purposes of the Kirschstein-NRSA programs, the term \"participant support costs\" does not apply."]
[]
[]
[]
["Category","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
["Stipends",null,null,null,null,null,{"$f":"(B8)+(C8)+(D8)+(E8)+(F8)","v":0}]
["Travel",null,null,null,null,null,{"$f":"(B9)+(C9)+(D9)+(E9)+(F9)","v":0}]
["Subsistence",null,null,null,null,null,{"$f":"(B10)+(C10)+(D10)+(E10)+(F10)","v":0}]
["Other",null,null,null,null,null,{"$f":"(B11)+(C11)+(D11)+(E11)+(F11)","v":0}]
["Total",{"$f":"SUM(B8:B11)","v":0},{"$f":"SUM(C8:C11)","v":0},{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0},{"$f":"(B12)+(C12)+(D12)+(E12)+(F12)","v":0}]
[]
[1,"Number of Participants/Trainees"]
[]
["Last Modified: 2/20/2017"]

{"sheet":"Other Direct","index":13,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
["Other Direct Charges"]
[]
["Category","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
["Included in MTDC"]
["Lab Animal Care & per diem",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
["Postage & Overnight Delivery",null,null,null,null,null,0]
["Telephone (long distance or dedicated lines)",null,null,null,null,null,0]
["Research Subjects",null,null,null,null,null,0]
["Consultants",null,null,null,null,null,0]
["Computing Services & Software",null,null,null,null,null,0]
["Services Provided by Other UW/State departments",null,null,null,null,null,0]
["Maintenance/Service Agreements",null,null,null,null,null,0]
["Subscriptions",null,null,null,null,null,0]
["Memberships",null,null,null,null,null,0]
["Job Related Training & Education",null,null,null,null,null,0]
["Personnel Services (e.g. Hospital staff)",null,null,null,null,null,0]
["Other Services",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Excluded from MTDC"]
["Tuition Remission",{"$f":"'Tuition Remission'!B12","v":0},{"$f":"'Tuition Remission'!C12","v":0},{"$f":"'Tuition Remission'!D12","v":0},{"$f":"'Tuition Remission'!E12","v":0},{"$f":"'Tuition Remission'!F12","v":0},{"$f":"SUM(B22:F22)","v":0}]
["Rentals & Leases for Space and/or Land",null,null,null,null,null,0]
["Equipment Rentals & Leases",null,0,0,0,null,0]
["Patient Care Costs",null,null,null,null,null,0]
["Grant/Aid/Lump Sum Awards/ Research Support",null,null,null,null,null,0]
["Student Aid/Tuition & Fees",null,0,0,0,null,0]
["Alterations and Renovation Costs",null,null,null,null,null,0]
["Participant Support Costs (enter detailed amounts on Participant Support Costs tab)",{"$f":"'Participant Support Costs'!B12","v":0},{"$f":"'Participant Support Costs'!C12","v":0},{"$f":"'Participant Support Costs'!D12","v":0},{"$f":"'Participant Support Costs'!E12","v":0},{"$f":"'Participant Support Costs'!F12","v":0},0]
["Total Services",{"$f":"ROUND((SUM(B6:B20)+SUM(B22:B29)),0)","v":0},0,0,0,0,0]

{"sheet":"Sub-Agreements","index":14,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,11,24,12],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[22,11,22,12],[23,1,23,2],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[22,1,22,2],[22,3,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[3,9,3,10],[3,11,3,12],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[3,0,4,0],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
[null,null,null,null,"Worksheet for Project Budget"]
["Sub-Agreements"]
[]
["Entity Name","Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Cumulative "]
[null,"Direct","F&A","Direct","F&A","Direct","F&A","Direct","F&A","Direct","F&A","Direct","F&A"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6,D6,F6,H6,J6)","v":0},{"$f":"SUM(C6,E6,G6,I6,K6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B21,D21,F21,H21,J21)","v":0},{"$f":"SUM(C21,E21,G21,I21,K21)","v":0}]
[]
["Total Direct",{"$f":"ROUND(SUM(B6:B21),0)","v":0},null,{"$f":"ROUND(SUM(D6:D21),0)","v":0},null,{"$f":"ROUND(SUM(F6:F21),0)","v":0},null,{"$f":"ROUND(SUM(H6:H21),0)","v":0},null,{"$f":"ROUND(SUM(J6:J21),0)","v":0},null,{"$f":"ROUND(SUM(L6:L21),0)","v":0}]
["Total F&A",{"$f":"ROUND(SUM(C6:C21),0)","v":0},null,{"$f":"ROUND(SUM(E6:E21),0)","v":0},null,{"$f":"ROUND(SUM(G6:G21),0)","v":0},null,{"$f":"ROUND(SUM(I6:I21),0)","v":0},null,{"$f":"ROUND(SUM(K6:K21),0)","v":0},null,{"$f":"ROUND(SUM(M6:M21),0)","v":0}]
["Total Sub-Agreements",{"$f":"ROUND(SUM(B23:B24),0)","v":0},null,{"$f":"ROUND(SUM(D23:D24),0)","v":0},null,{"$f":"ROUND(SUM(F23:F24),0)","v":0},null,{"$f":"ROUND(SUM(H23:H24),0)","v":0},null,{"$f":"ROUND(SUM(J23:J24),0)","v":0},null,{"$f":"ROUND(SUM(L23:L24),0)","v":0}]

{"sheet":"MTDC","index":15,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
["MTDC"]
[]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
["Salaries/Wages/Fringe",{"$f":"ROUND(SUM('Salaries Yr 1'!H5:H21)+(SUM('Salaries Yr 1'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries Yr 2'!H5:H21)+(SUM('Salaries Yr 2'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries Yr 3'!H5:H21)+(SUM('Salaries Yr 3'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries Yr 4'!H5:H21)+(SUM('Salaries Yr 4'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries Yr 5'!H5:H21)+(SUM('Salaries Yr 5'!J5:J21)),0)","v":0},{"$f":"SUM(B5:F5)","v":0}]
["Supplies",{"$f":"Supplies!B21","v":0},{"$f":"Supplies!C21","v":0},{"$f":"Supplies!D21","v":0},{"$f":"Supplies!E21","v":0},{"$f":"Supplies!F21","v":0},{"$f":"SUM(B6:F6)","v":0}]
["Travel",{"$f":"Travel!B16+Travel!B22","v":0},{"$f":"Travel!C16+Travel!C22","v":0},{"$f":"Travel!D16+Travel!D22","v":0},{"$f":"Travel!E16+Travel!E22","v":0},{"$f":"Travel!F16+Travel!F22","v":0},{"$f":"SUM(B7:F7)","v":0}]
["Other Direct Charges",{"$f":"ROUND(SUM('Other Direct'!B6:B20),0)","v":0},{"$f":"ROUND(SUM('Other Direct'!C6:C20),0)","v":0},{"$f":"ROUND(SUM('Other Direct'!D6:D20),0)","v":0},{"$f":"ROUND(SUM('Other Direct'!E6:E20),0)","v":0},{"$f":"ROUND(SUM('Other Direct'!F6:F20),0)","v":0},{"$f":"SUM(B8:F8)","v":0}]
["Sub-Agreements","Update"]
[{"$f":"'Sub-Agreements'!A6","v":0},{"$f":"IF(('Sub-Agreements'!B6+'Sub-Agreements'!C6)>25000,25000,('Sub-Agreements'!B6+'Sub-Agreements'!C6))","v":0},{"$f":"IF(('Sub-Agreements'!D6+'Sub-Agreements'!E6)=0,0,IF(B10=25000,0,IF(('Sub-Agreements'!D6+'Sub-Agreements'!E6)<(25000-B10),('Sub-Agreements'!D6+'Sub-Agreements'!E6),(25000-B10))))","v":0},{"$f":"IF(('Sub-Agreements'!F6+'Sub-Agreements'!G6)=0,0,IF(SUM(B10,C10)=25000,0,IF(('Sub-Agreements'!F6+'Sub-Agreements'!G6)<(25000-SUM(B10,C10)),('Sub-Agreements'!F6+'Sub-Agreements'!G6),(25000-SUM(B10,C10)))))","v":0},{"$f":"IF(('Sub-Agreements'!H6+'Sub-Agreements'!I6)=0,0,IF(SUM(B10,C10,D10)=25000,0,IF(('Sub-Agreements'!H6+'Sub-Agreements'!I6)<(25000-SUM(B10,C10,D10)),('Sub-Agreements'!H6+'Sub-Agreements'!I6),(25000-SUM(B10,C10,D10)))))","v":0},{"$f":"IF(('Sub-Agreements'!J6+'Sub-Agreements'!K6)=0,0,IF(SUM(B10,C10,D10,E10)=25000,0,IF(('Sub-Agreements'!J6+'Sub-Agreements'!K6)<(25000-SUM(B10,C10,D10,E10)),('Sub-Agreements'!J6+'Sub-Agreements'!K6),(25000-SUM(B10,C10,D10,E10)))))","v":0},{"$f":"SUM(B10:F10)","v":0}]
[{"$f":"'Sub-Agreements'!A7","v":0},{"$f":"IF('Sub-Agreements'!B7+'Sub-Agreements'!C7>25000,25000,'Sub-Agreements'!B7+'Sub-Agreements'!C7)","v":0},{"$f":"IF(('Sub-Agreements'!D7+'Sub-Agreements'!E7)=0,0,IF(B11=25000,0,IF(('Sub-Agreements'!D7+'Sub-Agreements'!E7)<(25000-B11),('Sub-Agreements'!D7+'Sub-Agreements'!E7),(25000-B11))))","v":0},{"$f":"IF(('Sub-Agreements'!F7+'Sub-Agreements'!G7)=0,0,IF(SUM(B11,C11)=25000,0,IF(('Sub-Agreements'!F7+'Sub-Agreements'!G7)<(25000-SUM(B11,C11)),('Sub-Agreements'!F7+'Sub-Agreements'!G7),(25000-SUM(B11,C11)))))","v":0},{"$f":"IF(('Sub-Agreements'!H7+'Sub-Agreements'!I7)=0,0,IF(SUM(B11,C11,D11)=25000,0,IF(('Sub-Agreements'!H7+'Sub-Agreements'!I7)<(25000-SUM(B11,C11,D11)),('Sub-Agreements'!H7+'Sub-Agreements'!I7),(25000-SUM(B11,C11,D11)))))","v":0},{"$f":"IF(('Sub-Agreements'!J7+'Sub-Agreements'!K7)=0,0,IF(SUM(B11,C11,D11,E11)=25000,0,IF(('Sub-Agreements'!J7+'Sub-Agreements'!K7)<(25000-SUM(B11,C11,D11,E11)),('Sub-Agreements'!J7+'Sub-Agreements'!K7),(25000-SUM(B11,C11,D11,E11)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A8","v":0},{"$f":"IF('Sub-Agreements'!B8+'Sub-Agreements'!C8>25000,25000,'Sub-Agreements'!B8+'Sub-Agreements'!C8)","v":0},{"$f":"IF(('Sub-Agreements'!D8+'Sub-Agreements'!E8)=0,0,IF(B12=25000,0,IF(('Sub-Agreements'!D8+'Sub-Agreements'!E8)<(25000-B12),('Sub-Agreements'!D8+'Sub-Agreements'!E8),(25000-B12))))","v":0},{"$f":"IF(('Sub-Agreements'!F8+'Sub-Agreements'!G8)=0,0,IF(SUM(B12,C12)=25000,0,IF(('Sub-Agreements'!F8+'Sub-Agreements'!G8)<(25000-SUM(B12,C12)),('Sub-Agreements'!F8+'Sub-Agreements'!G8),(25000-SUM(B12,C12)))))","v":0},{"$f":"IF(('Sub-Agreements'!H8+'Sub-Agreements'!I8)=0,0,IF(SUM(B12,C12,D12)=25000,0,IF(('Sub-Agreements'!H8+'Sub-Agreements'!I8)<(25000-SUM(B12,C12,D12)),('Sub-Agreements'!H8+'Sub-Agreements'!I8),(25000-SUM(B12,C12,D12)))))","v":0},{"$f":"IF(('Sub-Agreements'!J8+'Sub-Agreements'!K8)=0,0,IF(SUM(B12,C12,D12,E12)=25000,0,IF(('Sub-Agreements'!J8+'Sub-Agreements'!K8)<(25000-SUM(B12,C12,D12,E12)),('Sub-Agreements'!J8+'Sub-Agreements'!K8),(25000-SUM(B12,C12,D12,E12)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A9","v":0},{"$f":"IF('Sub-Agreements'!B9+'Sub-Agreements'!C9>25000,25000,'Sub-Agreements'!B9+'Sub-Agreements'!C9)","v":0},{"$f":"IF(('Sub-Agreements'!D9+'Sub-Agreements'!E9)=0,0,IF(B13=25000,0,IF(('Sub-Agreements'!D9+'Sub-Agreements'!E9)<(25000-B13),('Sub-Agreements'!D9+'Sub-Agreements'!E9),(25000-B13))))","v":0},{"$f":"IF(('Sub-Agreements'!F9+'Sub-Agreements'!G9)=0,0,IF(SUM(B13,C13)=25000,0,IF(('Sub-Agreements'!F9+'Sub-Agreements'!G9)<(25000-SUM(B13,C13)),('Sub-Agreements'!F9+'Sub-Agreements'!G9),(25000-SUM(B13,C13)))))","v":0},{"$f":"IF(('Sub-Agreements'!H9+'Sub-Agreements'!I9)=0,0,IF(SUM(B13,C13,D13)=25000,0,IF(('Sub-Agreements'!H9+'Sub-Agreements'!I9)<(25000-SUM(B13,C13,D13)),('Sub-Agreements'!H9+'Sub-Agreements'!I9),(25000-SUM(B13,C13,D13)))))","v":0},{"$f":"IF(('Sub-Agreements'!J9+'Sub-Agreements'!K9)=0,0,IF(SUM(B13,C13,D13,E13)=25000,0,IF(('Sub-Agreements'!J9+'Sub-Agreements'!K9)<(25000-SUM(B13,C13,D13,E13)),('Sub-Agreements'!J9+'Sub-Agreements'!K9),(25000-SUM(B13,C13,D13,E13)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A10","v":0},{"$f":"IF('Sub-Agreements'!B10+'Sub-Agreements'!C10>25000,25000,'Sub-Agreements'!B10+'Sub-Agreements'!C10)","v":0},{"$f":"IF(('Sub-Agreements'!D10+'Sub-Agreements'!E10)=0,0,IF(B14=25000,0,IF(('Sub-Agreements'!D10+'Sub-Agreements'!E10)<(25000-B14),('Sub-Agreements'!D10+'Sub-Agreements'!E10),(25000-B14))))","v":0},{"$f":"IF(('Sub-Agreements'!F10+'Sub-Agreements'!G10)=0,0,IF(SUM(B14,C14)=25000,0,IF(('Sub-Agreements'!F10+'Sub-Agreements'!G10)<(25000-SUM(B14,C14)),('Sub-Agreements'!F10+'Sub-Agreements'!G10),(25000-SUM(B14,C14)))))","v":0},{"$f":"IF(('Sub-Agreements'!H10+'Sub-Agreements'!I10)=0,0,IF(SUM(B14,C14,D14)=25000,0,IF(('Sub-Agreements'!H10+'Sub-Agreements'!I10)<(25000-SUM(B14,C14,D14)),('Sub-Agreements'!H10+'Sub-Agreements'!I10),(25000-SUM(B14,C14,D14)))))","v":0},{"$f":"IF(('Sub-Agreements'!J10+'Sub-Agreements'!K10)=0,0,IF(SUM(B14,C14,D14,E14)=25000,0,IF(('Sub-Agreements'!J10+'Sub-Agreements'!K10)<(25000-SUM(B14,C14,D14,E14)),('Sub-Agreements'!J10+'Sub-Agreements'!K10),(25000-SUM(B14,C14,D14,E14)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A11","v":0},{"$f":"IF('Sub-Agreements'!B11+'Sub-Agreements'!C11>25000,25000,'Sub-Agreements'!B11+'Sub-Agreements'!C11)","v":0},{"$f":"IF(('Sub-Agreements'!D11+'Sub-Agreements'!E11)=0,0,IF(B15=25000,0,IF(('Sub-Agreements'!D11+'Sub-Agreements'!E11)<(25000-B15),('Sub-Agreements'!D11+'Sub-Agreements'!E11),(25000-B15))))","v":0},{"$f":"IF(('Sub-Agreements'!F11+'Sub-Agreements'!G11)=0,0,IF(SUM(B15,C15)=25000,0,IF(('Sub-Agreements'!F11+'Sub-Agreements'!G11)<(25000-SUM(B15,C15)),('Sub-Agreements'!F11+'Sub-Agreements'!G11),(25000-SUM(B15,C15)))))","v":0},{"$f":"IF(('Sub-Agreements'!H11+'Sub-Agreements'!I11)=0,0,IF(SUM(B15,C15,D15)=25000,0,IF(('Sub-Agreements'!H11+'Sub-Agreements'!I11)<(25000-SUM(B15,C15,D15)),('Sub-Agreements'!H11+'Sub-Agreements'!I11),(25000-SUM(B15,C15,D15)))))","v":0},{"$f":"IF(('Sub-Agreements'!J11+'Sub-Agreements'!K11)=0,0,IF(SUM(B15,C15,D15,E15)=25000,0,IF(('Sub-Agreements'!J11+'Sub-Agreements'!K11)<(25000-SUM(B15,C15,D15,E15)),('Sub-Agreements'!J11+'Sub-Agreements'!K11),(25000-SUM(B15,C15,D15,E15)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A12","v":0},{"$f":"IF('Sub-Agreements'!B12+'Sub-Agreements'!C12>25000,25000,'Sub-Agreements'!B12+'Sub-Agreements'!C12)","v":0},{"$f":"IF(('Sub-Agreements'!D12+'Sub-Agreements'!E12)=0,0,IF(B16=25000,0,IF(('Sub-Agreements'!D12+'Sub-Agreements'!E12)<(25000-B16),('Sub-Agreements'!D12+'Sub-Agreements'!E12),(25000-B16))))","v":0},{"$f":"IF(('Sub-Agreements'!F12+'Sub-Agreements'!G12)=0,0,IF(SUM(B16,C16)=25000,0,IF(('Sub-Agreements'!F12+'Sub-Agreements'!G12)<(25000-SUM(B16,C16)),('Sub-Agreements'!F12+'Sub-Agreements'!G12),(25000-SUM(B16,C16)))))","v":0},{"$f":"IF(('Sub-Agreements'!H12+'Sub-Agreements'!I12)=0,0,IF(SUM(B16,C16,D16)=25000,0,IF(('Sub-Agreements'!H12+'Sub-Agreements'!I12)<(25000-SUM(B16,C16,D16)),('Sub-Agreements'!H12+'Sub-Agreements'!I12),(25000-SUM(B16,C16,D16)))))","v":0},{"$f":"IF(('Sub-Agreements'!J12+'Sub-Agreements'!K12)=0,0,IF(SUM(B16,C16,D16,E16)=25000,0,IF(('Sub-Agreements'!J12+'Sub-Agreements'!K12)<(25000-SUM(B16,C16,D16,E16)),('Sub-Agreements'!J12+'Sub-Agreements'!K12),(25000-SUM(B16,C16,D16,E16)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A13","v":0},{"$f":"IF('Sub-Agreements'!B13+'Sub-Agreements'!C13>25000,25000,'Sub-Agreements'!B13+'Sub-Agreements'!C13)","v":0},{"$f":"IF(('Sub-Agreements'!D13+'Sub-Agreements'!E13)=0,0,IF(B17=25000,0,IF(('Sub-Agreements'!D13+'Sub-Agreements'!E13)<(25000-B17),('Sub-Agreements'!D13+'Sub-Agreements'!E13),(25000-B17))))","v":0},{"$f":"IF(('Sub-Agreements'!F13+'Sub-Agreements'!G13)=0,0,IF(SUM(B17,C17)=25000,0,IF(('Sub-Agreements'!F13+'Sub-Agreements'!G13)<(25000-SUM(B17,C17)),('Sub-Agreements'!F13+'Sub-Agreements'!G13),(25000-SUM(B17,C17)))))","v":0},{"$f":"IF(('Sub-Agreements'!H13+'Sub-Agreements'!I13)=0,0,IF(SUM(B17,C17,D17)=25000,0,IF(('Sub-Agreements'!H13+'Sub-Agreements'!I13)<(25000-SUM(B17,C17,D17)),('Sub-Agreements'!H13+'Sub-Agreements'!I13),(25000-SUM(B17,C17,D17)))))","v":0},{"$f":"IF(('Sub-Agreements'!J13+'Sub-Agreements'!K13)=0,0,IF(SUM(B17,C17,D17,E17)=25000,0,IF(('Sub-Agreements'!J13+'Sub-Agreements'!K13)<(25000-SUM(B17,C17,D17,E17)),('Sub-Agreements'!J13+'Sub-Agreements'!K13),(25000-SUM(B17,C17,D17,E17)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A14","v":0},{"$f":"IF('Sub-Agreements'!B14+'Sub-Agreements'!C14>25000,25000,'Sub-Agreements'!B14+'Sub-Agreements'!C14)","v":0},{"$f":"IF(('Sub-Agreements'!D14+'Sub-Agreements'!E14)=0,0,IF(B18=25000,0,IF(('Sub-Agreements'!D14+'Sub-Agreements'!E14)<(25000-B18),('Sub-Agreements'!D14+'Sub-Agreements'!E14),(25000-B18))))","v":0},{"$f":"IF(('Sub-Agreements'!F14+'Sub-Agreements'!G14)=0,0,IF(SUM(B18,C18)=25000,0,IF(('Sub-Agreements'!F14+'Sub-Agreements'!G14)<(25000-SUM(B18,C18)),('Sub-Agreements'!F14+'Sub-Agreements'!G14),(25000-SUM(B18,C18)))))","v":0},{"$f":"IF(('Sub-Agreements'!H14+'Sub-Agreements'!I14)=0,0,IF(SUM(B18,C18,D18)=25000,0,IF(('Sub-Agreements'!H14+'Sub-Agreements'!I14)<(25000-SUM(B18,C18,D18)),('Sub-Agreements'!H14+'Sub-Agreements'!I14),(25000-SUM(B18,C18,D18)))))","v":0},{"$f":"IF(('Sub-Agreements'!J14+'Sub-Agreements'!K14)=0,0,IF(SUM(B18,C18,D18,E18)=25000,0,IF(('Sub-Agreements'!J14+'Sub-Agreements'!K14)<(25000-SUM(B18,C18,D18,E18)),('Sub-Agreements'!J14+'Sub-Agreements'!K14),(25000-SUM(B18,C18,D18,E18)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A15","v":0},{"$f":"IF('Sub-Agreements'!B15+'Sub-Agreements'!C15>25000,25000,'Sub-Agreements'!B15+'Sub-Agreements'!C15)","v":0},{"$f":"IF(('Sub-Agreements'!D15+'Sub-Agreements'!E15)=0,0,IF(B19=25000,0,IF(('Sub-Agreements'!D15+'Sub-Agreements'!E15)<(25000-B19),('Sub-Agreements'!D15+'Sub-Agreements'!E15),(25000-B19))))","v":0},{"$f":"IF(('Sub-Agreements'!F15+'Sub-Agreements'!G15)=0,0,IF(SUM(B19,C19)=25000,0,IF(('Sub-Agreements'!F15+'Sub-Agreements'!G15)<(25000-SUM(B19,C19)),('Sub-Agreements'!F15+'Sub-Agreements'!G15),(25000-SUM(B19,C19)))))","v":0},{"$f":"IF(('Sub-Agreements'!H15+'Sub-Agreements'!I15)=0,0,IF(SUM(B19,C19,D19)=25000,0,IF(('Sub-Agreements'!H15+'Sub-Agreements'!I15)<(25000-SUM(B19,C19,D19)),('Sub-Agreements'!H15+'Sub-Agreements'!I15),(25000-SUM(B19,C19,D19)))))","v":0},{"$f":"IF(('Sub-Agreements'!J15+'Sub-Agreements'!K15)=0,0,IF(SUM(B19,C19,D19,E19)=25000,0,IF(('Sub-Agreements'!J15+'Sub-Agreements'!K15)<(25000-SUM(B19,C19,D19,E19)),('Sub-Agreements'!J15+'Sub-Agreements'!K15),(25000-SUM(B19,C19,D19,E19)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A16","v":0},{"$f":"IF('Sub-Agreements'!B16+'Sub-Agreements'!C16>25000,25000,'Sub-Agreements'!B16+'Sub-Agreements'!C16)","v":0},{"$f":"IF(('Sub-Agreements'!D16+'Sub-Agreements'!E16)=0,0,IF(B20=25000,0,IF(('Sub-Agreements'!D16+'Sub-Agreements'!E16)<(25000-B20),('Sub-Agreements'!D16+'Sub-Agreements'!E16),(25000-B20))))","v":0},{"$f":"IF(('Sub-Agreements'!F16+'Sub-Agreements'!G16)=0,0,IF(SUM(B20,C20)=25000,0,IF(('Sub-Agreements'!F16+'Sub-Agreements'!G16)<(25000-SUM(B20,C20)),('Sub-Agreements'!F16+'Sub-Agreements'!G16),(25000-SUM(B20,C20)))))","v":0},{"$f":"IF(('Sub-Agreements'!H16+'Sub-Agreements'!I16)=0,0,IF(SUM(B20,C20,D20)=25000,0,IF(('Sub-Agreements'!H16+'Sub-Agreements'!I16)<(25000-SUM(B20,C20,D20)),('Sub-Agreements'!H16+'Sub-Agreements'!I16),(25000-SUM(B20,C20,D20)))))","v":0},{"$f":"IF(('Sub-Agreements'!J16+'Sub-Agreements'!K16)=0,0,IF(SUM(B20,C20,D20,E20)=25000,0,IF(('Sub-Agreements'!J16+'Sub-Agreements'!K16)<(25000-SUM(B20,C20,D20,E20)),('Sub-Agreements'!J16+'Sub-Agreements'!K16),(25000-SUM(B20,C20,D20,E20)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A17","v":0},{"$f":"IF('Sub-Agreements'!B17+'Sub-Agreements'!C17>25000,25000,'Sub-Agreements'!B17+'Sub-Agreements'!C17)","v":0},{"$f":"IF(('Sub-Agreements'!D17+'Sub-Agreements'!E17)=0,0,IF(B21=25000,0,IF(('Sub-Agreements'!D17+'Sub-Agreements'!E17)<(25000-B21),('Sub-Agreements'!D17+'Sub-Agreements'!E17),(25000-B21))))","v":0},{"$f":"IF(('Sub-Agreements'!F17+'Sub-Agreements'!G17)=0,0,IF(SUM(B21,C21)=25000,0,IF(('Sub-Agreements'!F17+'Sub-Agreements'!G17)<(25000-SUM(B21,C21)),('Sub-Agreements'!F17+'Sub-Agreements'!G17),(25000-SUM(B21,C21)))))","v":0},{"$f":"IF(('Sub-Agreements'!H17+'Sub-Agreements'!I17)=0,0,IF(SUM(B21,C21,D21)=25000,0,IF(('Sub-Agreements'!H17+'Sub-Agreements'!I17)<(25000-SUM(B21,C21,D21)),('Sub-Agreements'!H17+'Sub-Agreements'!I17),(25000-SUM(B21,C21,D21)))))","v":0},{"$f":"IF(('Sub-Agreements'!J17+'Sub-Agreements'!K17)=0,0,IF(SUM(B21,C21,D21,E21)=25000,0,IF(('Sub-Agreements'!J17+'Sub-Agreements'!K17)<(25000-SUM(B21,C21,D21,E21)),('Sub-Agreements'!J17+'Sub-Agreements'!K17),(25000-SUM(B21,C21,D21,E21)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A18","v":0},{"$f":"IF('Sub-Agreements'!B18+'Sub-Agreements'!C18>25000,25000,'Sub-Agreements'!B18+'Sub-Agreements'!C18)","v":0},{"$f":"IF(('Sub-Agreements'!D18+'Sub-Agreements'!E18)=0,0,IF(B22=25000,0,IF(('Sub-Agreements'!D18+'Sub-Agreements'!E18)<(25000-B22),('Sub-Agreements'!D18+'Sub-Agreements'!E18),(25000-B22))))","v":0},{"$f":"IF(('Sub-Agreements'!F18+'Sub-Agreements'!G18)=0,0,IF(SUM(B22,C22)=25000,0,IF(('Sub-Agreements'!F18+'Sub-Agreements'!G18)<(25000-SUM(B22,C22)),('Sub-Agreements'!F18+'Sub-Agreements'!G18),(25000-SUM(B22,C22)))))","v":0},{"$f":"IF(('Sub-Agreements'!H18+'Sub-Agreements'!I18)=0,0,IF(SUM(B22,C22,D22)=25000,0,IF(('Sub-Agreements'!H18+'Sub-Agreements'!I18)<(25000-SUM(B22,C22,D22)),('Sub-Agreements'!H18+'Sub-Agreements'!I18),(25000-SUM(B22,C22,D22)))))","v":0},{"$f":"IF(('Sub-Agreements'!J18+'Sub-Agreements'!K18)=0,0,IF(SUM(B22,C22,D22,E22)=25000,0,IF(('Sub-Agreements'!J18+'Sub-Agreements'!K18)<(25000-SUM(B22,C22,D22,E22)),('Sub-Agreements'!J18+'Sub-Agreements'!K18),(25000-SUM(B22,C22,D22,E22)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A19","v":0},{"$f":"IF('Sub-Agreements'!B19+'Sub-Agreements'!C19>25000,25000,'Sub-Agreements'!B19+'Sub-Agreements'!C19)","v":0},{"$f":"IF(('Sub-Agreements'!D19+'Sub-Agreements'!E19)=0,0,IF(B23=25000,0,IF(('Sub-Agreements'!D19+'Sub-Agreements'!E19)<(25000-B23),('Sub-Agreements'!D19+'Sub-Agreements'!E19),(25000-B23))))","v":0},{"$f":"IF(('Sub-Agreements'!F19+'Sub-Agreements'!G19)=0,0,IF(SUM(B23,C23)=25000,0,IF(('Sub-Agreements'!F19+'Sub-Agreements'!G19)<(25000-SUM(B23,C23)),('Sub-Agreements'!F19+'Sub-Agreements'!G19),(25000-SUM(B23,C23)))))","v":0},{"$f":"IF(('Sub-Agreements'!H19+'Sub-Agreements'!I19)=0,0,IF(SUM(B23,C23,D23)=25000,0,IF(('Sub-Agreements'!H19+'Sub-Agreements'!I19)<(25000-SUM(B23,C23,D23)),('Sub-Agreements'!H19+'Sub-Agreements'!I19),(25000-SUM(B23,C23,D23)))))","v":0},{"$f":"IF(('Sub-Agreements'!J19+'Sub-Agreements'!K19)=0,0,IF(SUM(B23,C23,D23,E23)=25000,0,IF(('Sub-Agreements'!J19+'Sub-Agreements'!K19)<(25000-SUM(B23,C23,D23,E23)),('Sub-Agreements'!J19+'Sub-Agreements'!K19),(25000-SUM(B23,C23,D23,E23)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A20","v":0},{"$f":"IF('Sub-Agreements'!B20+'Sub-Agreements'!C20>25000,25000,'Sub-Agreements'!B20+'Sub-Agreements'!C20)","v":0},{"$f":"IF(('Sub-Agreements'!D20+'Sub-Agreements'!E20)=0,0,IF(B24=25000,0,IF(('Sub-Agreements'!D20+'Sub-Agreements'!E20)<(25000-B24),('Sub-Agreements'!D20+'Sub-Agreements'!E20),(25000-B24))))","v":0},{"$f":"IF(('Sub-Agreements'!F20+'Sub-Agreements'!G20)=0,0,IF(SUM(B24,C24)=25000,0,IF(('Sub-Agreements'!F20+'Sub-Agreements'!G20)<(25000-SUM(B24,C24)),('Sub-Agreements'!F20+'Sub-Agreements'!G20),(25000-SUM(B24,C24)))))","v":0},{"$f":"IF(('Sub-Agreements'!H20+'Sub-Agreements'!I20)=0,0,IF(SUM(B24,C24,D24)=25000,0,IF(('Sub-Agreements'!H20+'Sub-Agreements'!I20)<(25000-SUM(B24,C24,D24)),('Sub-Agreements'!H20+'Sub-Agreements'!I20),(25000-SUM(B24,C24,D24)))))","v":0},{"$f":"IF(('Sub-Agreements'!J20+'Sub-Agreements'!K20)=0,0,IF(SUM(B24,C24,D24,E24)=25000,0,IF(('Sub-Agreements'!J20+'Sub-Agreements'!K20)<(25000-SUM(B24,C24,D24,E24)),('Sub-Agreements'!J20+'Sub-Agreements'!K20),(25000-SUM(B24,C24,D24,E24)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A21","v":0},{"$f":"IF('Sub-Agreements'!B21+'Sub-Agreements'!C21>25000,25000,'Sub-Agreements'!B21+'Sub-Agreements'!C21)","v":0},{"$f":"IF(('Sub-Agreements'!D21+'Sub-Agreements'!E21)=0,0,IF(B25=25000,0,IF(('Sub-Agreements'!D21+'Sub-Agreements'!E21)<(25000-B25),('Sub-Agreements'!D21+'Sub-Agreements'!E21),(25000-B25))))","v":0},{"$f":"IF(('Sub-Agreements'!F21+'Sub-Agreements'!G21)=0,0,IF(SUM(B25,C25)=25000,0,IF(('Sub-Agreements'!F21+'Sub-Agreements'!G21)<(25000-SUM(B25,C25)),('Sub-Agreements'!F21+'Sub-Agreements'!G21),(25000-SUM(B25,C25)))))","v":0},{"$f":"IF(('Sub-Agreements'!H21+'Sub-Agreements'!I21)=0,0,IF(SUM(B25,C25,D25)=25000,0,IF(('Sub-Agreements'!H21+'Sub-Agreements'!I21)<(25000-SUM(B25,C25,D25)),('Sub-Agreements'!H21+'Sub-Agreements'!I21),(25000-SUM(B25,C25,D25)))))","v":0},{"$f":"IF(('Sub-Agreements'!J21+'Sub-Agreements'!K21)=0,0,IF(SUM(B25,C25,D25,E25)=25000,0,IF(('Sub-Agreements'!J21+'Sub-Agreements'!K21)<(25000-SUM(B25,C25,D25,E25)),('Sub-Agreements'!J21+'Sub-Agreements'!K21),(25000-SUM(B25,C25,D25,E25)))))","v":0},0]
[]
["Total MTDC",{"$f":"ROUND(SUM(B5:B25),0)","v":0},0,0,0,0,0]
[]
["Non-MTDC Items"]
[]
["Equipment & Other Capital",{"$f":"'Equipment & Capital'!B34","v":0},{"$f":"'Equipment & Capital'!C34","v":0},{"$f":"'Equipment & Capital'!D34","v":0},{"$f":"'Equipment & Capital'!E34","v":0},{"$f":"'Equipment & Capital'!F34","v":0},{"$f":"SUM(B31:F31)","v":0}]
["Tuition Remission",{"$f":"'Other Direct'!B22","v":0},{"$f":"'Other Direct'!C22","v":0},{"$f":"'Other Direct'!D22","v":0},{"$f":"'Other Direct'!E22","v":0},{"$f":"'Other Direct'!F22","v":0},0]
["Rentals & Leases for Space and/or Land",{"$f":"'Other Direct'!B23","v":0},{"$f":"'Other Direct'!C23","v":0},{"$f":"'Other Direct'!D23","v":0},{"$f":"'Other Direct'!E23","v":0},{"$f":"'Other Direct'!F23","v":0},0]
["Equipment Rentals & Leases",{"$f":"'Other Direct'!B24","v":0},{"$f":"'Other Direct'!C24","v":0},{"$f":"'Other Direct'!D24","v":0},{"$f":"'Other Direct'!E24","v":0},{"$f":"'Other Direct'!F24","v":0},0]
["Patient Care Costs",{"$f":"'Other Direct'!B25","v":0},{"$f":"'Other Direct'!C25","v":0},{"$f":"'Other Direct'!D25","v":0},{"$f":"'Other Direct'!E25","v":0},{"$f":"'Other Direct'!F25","v":0},0]
["Grant/Aid/Lump Sum Awards/ Research Support",{"$f":"'Other Direct'!B26","v":0},{"$f":"'Other Direct'!C26","v":0},{"$f":"'Other Direct'!D26","v":0},{"$f":"'Other Direct'!E26","v":0},{"$f":"'Other Direct'!F26","v":0},0]
["Student Aid/Tuition & Fees",{"$f":"'Other Direct'!B27","v":0},{"$f":"'Other Direct'!C27","v":0},{"$f":"'Other Direct'!D27","v":0},{"$f":"'Other Direct'!E27","v":0},{"$f":"'Other Direct'!F27","v":0},0]
["Alterations and Renovation Costs",{"$f":"'Other Direct'!B28","v":0},{"$f":"'Other Direct'!C28","v":0},{"$f":"'Other Direct'!D28","v":0},{"$f":"'Other Direct'!E28","v":0},{"$f":"'Other Direct'!F28","v":0},0]
["Participant Support Costs",{"$f":"'Other Direct'!B29","v":0},{"$f":"'Other Direct'!C29","v":0},{"$f":"'Other Direct'!D29","v":0},{"$f":"'Other Direct'!E29","v":0},{"$f":"'Other Direct'!F29","v":0},0]
["Sub-Agreements >$25,000"]
[{"$f":"'Sub-Agreements'!A6","v":0},{"$f":"IF(('Sub-Agreements'!B6+'Sub-Agreements'!C6)>=25000,(('Sub-Agreements'!B6+'Sub-Agreements'!C6)-25000),0)","v":0},{"$f":"IF((B10+C10)=25000,(('Sub-Agreements'!D6+'Sub-Agreements'!E6)-C10),0)","v":0},{"$f":"IF((B10+C10+D10)=25000,(('Sub-Agreements'!F6+'Sub-Agreements'!G6)-D10),0)","v":0},{"$f":"IF((B10+C10+D10+E10)=25000,(('Sub-Agreements'!H6+'Sub-Agreements'!I6)-E10),0)","v":0},{"$f":"IF((B10+C10+D10+E10+F10)=25000,(('Sub-Agreements'!J6+'Sub-Agreements'!K6)-F10),0)","v":0},{"$f":"SUM(B41:F41)","v":0}]
[{"$f":"'Sub-Agreements'!A7","v":0},{"$f":"IF(('Sub-Agreements'!B7+'Sub-Agreements'!C7)>=25000,(('Sub-Agreements'!B7+'Sub-Agreements'!C7)-25000),0)","v":0},{"$f":"IF((B11+C11)=25000,(('Sub-Agreements'!D7+'Sub-Agreements'!E7)-C11),0)","v":0},{"$f":"IF((B11+C11+D11)=25000,(('Sub-Agreements'!F7+'Sub-Agreements'!G7)-D11),0)","v":0},{"$f":"IF((B11+C11+D11+E11)=25000,(('Sub-Agreements'!H7+'Sub-Agreements'!I7)-E11),0)","v":0},{"$f":"IF((B11+C11+D11+E11+F11)=25000,(('Sub-Agreements'!J7+'Sub-Agreements'!K7)-F11),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A8","v":0},{"$f":"IF(('Sub-Agreements'!B8+'Sub-Agreements'!C8)>=25000,(('Sub-Agreements'!B8+'Sub-Agreements'!C8)-25000),0)","v":0},{"$f":"IF((B12+C12)=25000,(('Sub-Agreements'!D8+'Sub-Agreements'!E8)-C12),0)","v":0},{"$f":"IF((B12+C12+D12)=25000,(('Sub-Agreements'!F8+'Sub-Agreements'!G8)-D12),0)","v":0},{"$f":"IF((B12+C12+D12+E12)=25000,(('Sub-Agreements'!H8+'Sub-Agreements'!I8)-E12),0)","v":0},{"$f":"IF((B12+C12+D12+E12+F12)=25000,(('Sub-Agreements'!J8+'Sub-Agreements'!K8)-F12),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A9","v":0},{"$f":"IF(('Sub-Agreements'!B9+'Sub-Agreements'!C9)>=25000,(('Sub-Agreements'!B9+'Sub-Agreements'!C9)-25000),0)","v":0},{"$f":"IF((B13+C13)=25000,(('Sub-Agreements'!D9+'Sub-Agreements'!E9)-C13),0)","v":0},{"$f":"IF((B13+C13+D13)=25000,(('Sub-Agreements'!F9+'Sub-Agreements'!G9)-D13),0)","v":0},{"$f":"IF((B13+C13+D13+E13)=25000,(('Sub-Agreements'!H9+'Sub-Agreements'!I9)-E13),0)","v":0},{"$f":"IF((B13+C13+D13+E13+F13)=25000,(('Sub-Agreements'!J9+'Sub-Agreements'!K9)-F13),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A10","v":0},{"$f":"IF(('Sub-Agreements'!B10+'Sub-Agreements'!C10)>=25000,(('Sub-Agreements'!B10+'Sub-Agreements'!C10)-25000),0)","v":0},{"$f":"IF((B14+C14)=25000,(('Sub-Agreements'!D10+'Sub-Agreements'!E10)-C14),0)","v":0},{"$f":"IF((B14+C14+D14)=25000,(('Sub-Agreements'!F10+'Sub-Agreements'!G10)-D14),0)","v":0},{"$f":"IF((B14+C14+D14+E14)=25000,(('Sub-Agreements'!H10+'Sub-Agreements'!I10)-E14),0)","v":0},{"$f":"IF((B14+C14+D14+E14+F14)=25000,(('Sub-Agreements'!J10+'Sub-Agreements'!K10)-F14),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A11","v":0},{"$f":"IF(('Sub-Agreements'!B11+'Sub-Agreements'!C11)>=25000,(('Sub-Agreements'!B11+'Sub-Agreements'!C11)-25000),0)","v":0},{"$f":"IF((B15+C15)=25000,(('Sub-Agreements'!D11+'Sub-Agreements'!E11)-C15),0)","v":0},{"$f":"IF((B15+C15+D15)=25000,(('Sub-Agreements'!F11+'Sub-Agreements'!G11)-D15),0)","v":0},{"$f":"IF((B15+C15+D15+E15)=25000,(('Sub-Agreements'!H11+'Sub-Agreements'!I11)-E15),0)","v":0},{"$f":"IF((B15+C15+D15+E15+F15)=25000,(('Sub-Agreements'!J11+'Sub-Agreements'!K11)-F15),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A12","v":0},{"$f":"IF(('Sub-Agreements'!B12+'Sub-Agreements'!C12)>=25000,(('Sub-Agreements'!B12+'Sub-Agreements'!C12)-25000),0)","v":0},{"$f":"IF((B16+C16)=25000,(('Sub-Agreements'!D12+'Sub-Agreements'!E12)-C16),0)","v":0},{"$f":"IF((B16+C16+D16)=25000,(('Sub-Agreements'!F12+'Sub-Agreements'!G12)-D16),0)","v":0},{"$f":"IF((B16+C16+D16+E16)=25000,(('Sub-Agreements'!H12+'Sub-Agreements'!I12)-E16),0)","v":0},{"$f":"IF((B16+C16+D16+E16+F16)=25000,(('Sub-Agreements'!J12+'Sub-Agreements'!K12)-F16),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A13","v":0},{"$f":"IF(('Sub-Agreements'!B13+'Sub-Agreements'!C13)>=25000,(('Sub-Agreements'!B13+'Sub-Agreements'!C13)-25000),0)","v":0},{"$f":"IF((B17+C17)=25000,(('Sub-Agreements'!D13+'Sub-Agreements'!E13)-C17),0)","v":0},{"$f":"IF((B17+C17+D17)=25000,(('Sub-Agreements'!F13+'Sub-Agreements'!G13)-D17),0)","v":0},{"$f":"IF((B17+C17+D17+E17)=25000,(('Sub-Agreements'!H13+'Sub-Agreements'!I13)-E17),0)","v":0},{"$f":"IF((B17+C17+D17+E17+F17)=25000,(('Sub-Agreements'!J13+'Sub-Agreements'!K13)-F17),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A14","v":0},{"$f":"IF(('Sub-Agreements'!B14+'Sub-Agreements'!C14)>=25000,(('Sub-Agreements'!B14+'Sub-Agreements'!C14)-25000),0)","v":0},{"$f":"IF((B18+C18)=25000,(('Sub-Agreements'!D14+'Sub-Agreements'!E14)-C18),0)","v":0},{"$f":"IF((B18+C18+D18)=25000,(('Sub-Agreements'!F14+'Sub-Agreements'!G14)-D18),0)","v":0},{"$f":"IF((B18+C18+D18+E18)=25000,(('Sub-Agreements'!H14+'Sub-Agreements'!I14)-E18),0)","v":0},{"$f":"IF((B18+C18+D18+E18+F18)=25000,(('Sub-Agreements'!J14+'Sub-Agreements'!K14)-F18),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A15","v":0},{"$f":"IF(('Sub-Agreements'!B15+'Sub-Agreements'!C15)>=25000,(('Sub-Agreements'!B15+'Sub-Agreements'!C15)-25000),0)","v":0},{"$f":"IF((B19+C19)=25000,(('Sub-Agreements'!D15+'Sub-Agreements'!E15)-C19),0)","v":0},{"$f":"IF((B19+C19+D19)=25000,(('Sub-Agreements'!F15+'Sub-Agreements'!G15)-D19),0)","v":0},{"$f":"IF((B19+C19+D19+E19)=25000,(('Sub-Agreements'!H15+'Sub-Agreements'!I15)-E19),0)","v":0},{"$f":"IF((B19+C19+D19+E19+F19)=25000,(('Sub-Agreements'!J15+'Sub-Agreements'!K15)-F19),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A16","v":0},{"$f":"IF(('Sub-Agreements'!B16+'Sub-Agreements'!C16)>=25000,(('Sub-Agreements'!B16+'Sub-Agreements'!C16)-25000),0)","v":0},{"$f":"IF((B20+C20)=25000,(('Sub-Agreements'!D16+'Sub-Agreements'!E16)-C20),0)","v":0},{"$f":"IF((B20+C20+D20)=25000,(('Sub-Agreements'!F16+'Sub-Agreements'!G16)-D20),0)","v":0},{"$f":"IF((B20+C20+D20+E20)=25000,(('Sub-Agreements'!H16+'Sub-Agreements'!I16)-E20),0)","v":0},{"$f":"IF((B20+C20+D20+E20+F20)=25000,(('Sub-Agreements'!J16+'Sub-Agreements'!K16)-F20),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A17","v":0},{"$f":"IF(('Sub-Agreements'!B17+'Sub-Agreements'!C17)>=25000,(('Sub-Agreements'!B17+'Sub-Agreements'!C17)-25000),0)","v":0},{"$f":"IF((B21+C21)=25000,(('Sub-Agreements'!D17+'Sub-Agreements'!E17)-C21),0)","v":0},{"$f":"IF((B21+C21+D21)=25000,(('Sub-Agreements'!F17+'Sub-Agreements'!G17)-D21),0)","v":0},{"$f":"IF((B21+C21+D21+E21)=25000,(('Sub-Agreements'!H17+'Sub-Agreements'!I17)-E21),0)","v":0},{"$f":"IF((B21+C21+D21+E21+F21)=25000,(('Sub-Agreements'!J17+'Sub-Agreements'!K17)-F21),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A18","v":0},{"$f":"IF(('Sub-Agreements'!B18+'Sub-Agreements'!C18)>=25000,(('Sub-Agreements'!B18+'Sub-Agreements'!C18)-25000),0)","v":0},{"$f":"IF((B22+C22)=25000,(('Sub-Agreements'!D18+'Sub-Agreements'!E18)-C22),0)","v":0},{"$f":"IF((B22+C22+D22)=25000,(('Sub-Agreements'!F18+'Sub-Agreements'!G18)-D22),0)","v":0},{"$f":"IF((B22+C22+D22+E22)=25000,(('Sub-Agreements'!H18+'Sub-Agreements'!I18)-E22),0)","v":0},{"$f":"IF((B22+C22+D22+E22+F22)=25000,(('Sub-Agreements'!J18+'Sub-Agreements'!K18)-F22),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A19","v":0},{"$f":"IF(('Sub-Agreements'!B19+'Sub-Agreements'!C19)>=25000,(('Sub-Agreements'!B19+'Sub-Agreements'!C19)-25000),0)","v":0},{"$f":"IF((B23+C23)=25000,(('Sub-Agreements'!D19+'Sub-Agreements'!E19)-C23),0)","v":0},{"$f":"IF((B23+C23+D23)=25000,(('Sub-Agreements'!F19+'Sub-Agreements'!G19)-D23),0)","v":0},{"$f":"IF((B23+C23+D23+E23)=25000,(('Sub-Agreements'!H19+'Sub-Agreements'!I19)-E23),0)","v":0},{"$f":"IF((B23+C23+D23+E23+F23)=25000,(('Sub-Agreements'!J19+'Sub-Agreements'!K19)-F23),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A20","v":0},{"$f":"IF(('Sub-Agreements'!B20+'Sub-Agreements'!C20)>=25000,(('Sub-Agreements'!B20+'Sub-Agreements'!C20)-25000),0)","v":0},{"$f":"IF((B24+C24)=25000,(('Sub-Agreements'!D20+'Sub-Agreements'!E20)-C24),0)","v":0},{"$f":"IF((B24+C24+D24)=25000,(('Sub-Agreements'!F20+'Sub-Agreements'!G20)-D24),0)","v":0},{"$f":"IF((B24+C24+D24+E24)=25000,(('Sub-Agreements'!H20+'Sub-Agreements'!I20)-E24),0)","v":0},{"$f":"IF((B24+C24+D24+E24+F24)=25000,(('Sub-Agreements'!J20+'Sub-Agreements'!K20)-F24),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A21","v":0},{"$f":"IF(('Sub-Agreements'!B21+'Sub-Agreements'!C21)>=25000,(('Sub-Agreements'!B21+'Sub-Agreements'!C21)-25000),0)","v":0},{"$f":"IF((B25+C25)=25000,(('Sub-Agreements'!D21+'Sub-Agreements'!E21)-C25),0)","v":0},{"$f":"IF((B25+C25+D25)=25000,(('Sub-Agreements'!F21+'Sub-Agreements'!G21)-D25),0)","v":0},{"$f":"IF((B25+C25+D25+E25)=25000,(('Sub-Agreements'!H21+'Sub-Agreements'!I21)-E25),0)","v":0},{"$f":"IF((B25+C25+D25+E25+F25)=25000,(('Sub-Agreements'!J21+'Sub-Agreements'!K21)-F25),0)","v":0},0]
["Total Non-MTDC",{"$f":"ROUND(SUM(B31:B56),0)","v":0},0,0,0,0,0]

{"sheet":"Total","index":16,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6],[4,1,4,6]]}
[null,null,"PROJECT BUDGET"]
["Sponsor:",{"$f":"Title!C2","v":0}]
["Project Title:",{"$f":"Title!C4","v":0}]
["Project Period:","Begin:",{"$f":"Title!D6","v":"00:00:00"},"End:",{"$f":"Title!F6","v":"00:00:00"}]
["Principal Investigator:",{"$f":"Title!C8","v":0}]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
["Salaries & Wages",{"$f":"'Salaries Yr 1'!H23","v":0},{"$f":"'Salaries Yr 2'!H23","v":0},{"$f":"'Salaries Yr 3'!H23","v":0},{"$f":"'Salaries Yr 4'!H23","v":0},{"$f":"'Salaries Yr 5'!H23","v":0},{"$f":"SUM(B7:F7)","v":0}]
["Fringe Benefits",{"$f":"'Salaries Yr 1'!J23","v":0},{"$f":"'Salaries Yr 2'!J23","v":0},{"$f":"'Salaries Yr 3'!J23","v":0},{"$f":"'Salaries Yr 4'!J23","v":0},{"$f":"'Salaries Yr 5'!J23","v":0},0]
["Equipment & Other Capital",{"$f":"'Equipment & Capital'!B34","v":0},{"$f":"'Equipment & Capital'!C34","v":0},{"$f":"'Equipment & Capital'!D34","v":0},{"$f":"'Equipment & Capital'!E34","v":0},{"$f":"'Equipment & Capital'!F34","v":0},0]
["Supplies",{"$f":"Supplies!B21","v":0},{"$f":"Supplies!C21","v":0},{"$f":"Supplies!D21","v":0},{"$f":"Supplies!E21","v":0},{"$f":"Supplies!F21","v":0},0]
["Travel - Domestic",{"$f":"Travel!B16","v":0},{"$f":"Travel!C16","v":0},{"$f":"Travel!D16","v":0},{"$f":"Travel!E16","v":0},{"$f":"Travel!F16","v":0},0]
["Travel - Foreign",{"$f":"Travel!B22","v":0},{"$f":"Travel!C22","v":0},{"$f":"Travel!D22","v":0},{"$f":"Travel!E22","v":0},{"$f":"Travel!F22","v":0},0]
["Other Direct Charges",{"$f":"'Other Direct'!B30","v":0},{"$f":"'Other Direct'!C30","v":0},{"$f":"'Other Direct'!D30","v":0},{"$f":"'Other Direct'!E30","v":0},{"$f":"'Other Direct'!F30","v":0},0]
["Sub-Agreements"]
[{"$f":"'Sub-Agreements'!A6","v":0},{"$f":"('Sub-Agreements'!B6+'Sub-Agreements'!C6)","v":0},{"$f":"('Sub-Agreements'!D6+'Sub-Agreements'!E6)","v":0},{"$f":"('Sub-Agreements'!F6+'Sub-Agreements'!G6)","v":0},{"$f":"('Sub-Agreements'!H6+'Sub-Agreements'!I6)","v":0},{"$f":"('Sub-Agreements'!J6+'Sub-Agreements'!K6)","v":0},{"$f":"SUM(B15:F15)","v":0}]
[{"$f":"'Sub-Agreements'!A7","v":0},{"$f":"('Sub-Agreements'!B7+'Sub-Agreements'!C7)","v":0},{"$f":"('Sub-Agreements'!D7+'Sub-Agreements'!E7)","v":0},{"$f":"('Sub-Agreements'!F7+'Sub-Agreements'!G7)","v":0},{"$f":"('Sub-Agreements'!H7+'Sub-Agreements'!I7)","v":0},{"$f":"('Sub-Agreements'!J7+'Sub-Agreements'!K7)","v":0},0]
[{"$f":"'Sub-Agreements'!A8","v":0},{"$f":"('Sub-Agreements'!B8+'Sub-Agreements'!C8)","v":0},{"$f":"('Sub-Agreements'!D8+'Sub-Agreements'!E8)","v":0},{"$f":"('Sub-Agreements'!F8+'Sub-Agreements'!G8)","v":0},{"$f":"('Sub-Agreements'!H8+'Sub-Agreements'!I8)","v":0},{"$f":"('Sub-Agreements'!J8+'Sub-Agreements'!K8)","v":0},0]
[{"$f":"'Sub-Agreements'!A9","v":0},{"$f":"('Sub-Agreements'!B9+'Sub-Agreements'!C9)","v":0},{"$f":"('Sub-Agreements'!D9+'Sub-Agreements'!E9)","v":0},{"$f":"('Sub-Agreements'!F9+'Sub-Agreements'!G9)","v":0},{"$f":"('Sub-Agreements'!H9+'Sub-Agreements'!I9)","v":0},{"$f":"('Sub-Agreements'!J9+'Sub-Agreements'!K9)","v":0},0]
[{"$f":"'Sub-Agreements'!A10","v":0},{"$f":"('Sub-Agreements'!B10+'Sub-Agreements'!C10)","v":0},{"$f":"('Sub-Agreements'!D10+'Sub-Agreements'!E10)","v":0},{"$f":"('Sub-Agreements'!F10+'Sub-Agreements'!G10)","v":0},{"$f":"('Sub-Agreements'!H10+'Sub-Agreements'!I10)","v":0},{"$f":"('Sub-Agreements'!J10+'Sub-Agreements'!K10)","v":0},0]
[{"$f":"'Sub-Agreements'!A11","v":0},{"$f":"('Sub-Agreements'!B11+'Sub-Agreements'!C11)","v":0},{"$f":"('Sub-Agreements'!D11+'Sub-Agreements'!E11)","v":0},{"$f":"('Sub-Agreements'!F11+'Sub-Agreements'!G11)","v":0},{"$f":"('Sub-Agreements'!H11+'Sub-Agreements'!I11)","v":0},{"$f":"('Sub-Agreements'!J11+'Sub-Agreements'!K11)","v":0},0]
[{"$f":"'Sub-Agreements'!A12","v":0},{"$f":"('Sub-Agreements'!B12+'Sub-Agreements'!C12)","v":0},{"$f":"('Sub-Agreements'!D12+'Sub-Agreements'!E12)","v":0},{"$f":"('Sub-Agreements'!F12+'Sub-Agreements'!G12)","v":0},{"$f":"('Sub-Agreements'!H12+'Sub-Agreements'!I12)","v":0},{"$f":"('Sub-Agreements'!J12+'Sub-Agreements'!K12)","v":0},0]
[{"$f":"'Sub-Agreements'!A13","v":0},{"$f":"('Sub-Agreements'!B13+'Sub-Agreements'!C13)","v":0},{"$f":"('Sub-Agreements'!D13+'Sub-Agreements'!E13)","v":0},{"$f":"('Sub-Agreements'!F13+'Sub-Agreements'!G13)","v":0},{"$f":"('Sub-Agreements'!H13+'Sub-Agreements'!I13)","v":0},{"$f":"('Sub-Agreements'!J13+'Sub-Agreements'!K13)","v":0},0]
[{"$f":"'Sub-Agreements'!A14","v":0},{"$f":"('Sub-Agreements'!B14+'Sub-Agreements'!C14)","v":0},{"$f":"('Sub-Agreements'!D14+'Sub-Agreements'!E14)","v":0},{"$f":"('Sub-Agreements'!F14+'Sub-Agreements'!G14)","v":0},{"$f":"('Sub-Agreements'!H14+'Sub-Agreements'!I14)","v":0},{"$f":"('Sub-Agreements'!J14+'Sub-Agreements'!K14)","v":0},0]
[{"$f":"'Sub-Agreements'!A15","v":0},{"$f":"('Sub-Agreements'!B15+'Sub-Agreements'!C15)","v":0},{"$f":"('Sub-Agreements'!D15+'Sub-Agreements'!E15)","v":0},{"$f":"('Sub-Agreements'!F15+'Sub-Agreements'!G15)","v":0},{"$f":"('Sub-Agreements'!H15+'Sub-Agreements'!I15)","v":0},{"$f":"('Sub-Agreements'!J15+'Sub-Agreements'!K15)","v":0},0]
[{"$f":"'Sub-Agreements'!A21","v":0},{"$f":"('Sub-Agreements'!B21+'Sub-Agreements'!C21)","v":0},{"$f":"('Sub-Agreements'!D21+'Sub-Agreements'!E21)","v":0},{"$f":"('Sub-Agreements'!F21+'Sub-Agreements'!G21)","v":0},{"$f":"('Sub-Agreements'!H21+'Sub-Agreements'!I21)","v":0},{"$f":"('Sub-Agreements'!J21+'Sub-Agreements'!K21)","v":0},0]
[]
["Direct Costs",{"$f":"SUM(B7:B26)","v":0},0,0,0,0,0]
["MTDC Costs",{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!B27,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!C27,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!D27,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!E27,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!F27,0)","v":0},{"$f":"SUM(B28:F28)","v":0}]
["F&A Costs",{"$f":"B28*B30","v":0},{"$f":"C28*C30","v":0},{"$f":"D28*D30","v":0},{"$f":"E28*E30","v":0},{"$f":"F28*F30","v":0},{"$f":"SUM(B29:F29)","v":0}]
["F&A Rate (%)",{"$f":"Title!C10","v":0.55500000000000005},{"$f":"Title!C10","v":0.55500000000000005},{"$f":"Title!C10","v":0.55500000000000005},{"$f":"Title!C10","v":0.55500000000000005},{"$f":"Title!C10","v":0.55500000000000005}]
["Total Costs",{"$f":"SUM(B27+B29)","v":0},0,0,0,0,0]

{"sheet":"NIH Modular","index":17,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,6,39,7],[40,6,40,7],[42,6,42,7],[43,6,43,7],[31,6,31,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[8,6,8,7],[9,6,9,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[1,5,1,7],[2,0,2,7],[3,0,3,7],[6,6,6,7],[7,6,7,7]]}
[]
[null,null,null,null,"PI Name:",{"$f":"Title!C8","v":0}]
["University of Wisconsin-Madison"]
["NIH Modular Grant Budget Tabulator"]
["Print this template and submit it with your NIH modular grant application to your Dean's Office.  This form will be used for  "]
["internal purposes only and will not be sent to NIH."]
[null,"Year One","Year Two ","Year Three","Year Four","Year Five","Cumulative Total"]
[]
["Category A (Exempt from F&A costs)"]
["Equipment Items over $5,000 ",{"$f":"'Equipment & Capital'!B34","v":0},{"$f":"'Equipment & Capital'!C34","v":0},{"$f":"'Equipment & Capital'!D34","v":0},{"$f":"'Equipment & Capital'!E34","v":0},{"$f":"'Equipment & Capital'!F34","v":0},{"$f":"SUM(B10:F10)","v":0}]
["Off-Campus Space Rental",null,null,null,null,null,{"$f":"SUM(B11:F11)","v":0}]
["Patient Care Costs",{"$f":"'Other Direct'!B25","v":0},{"$f":"'Other Direct'!C25","v":0},{"$f":"'Other Direct'!D25","v":0},{"$f":"'Other Direct'!E25","v":0},{"$f":"'Other Direct'!F25","v":0},{"$f":"SUM(B12:F12)","v":0}]
["Alterations and Renovation Costs",{"$f":"'Other Direct'!B28","v":0},{"$f":"'Other Direct'!C28","v":0},{"$f":"'Other Direct'!D28","v":0},{"$f":"'Other Direct'!E28","v":0},{"$f":"'Other Direct'!F28","v":0},{"$f":"SUM(B13:F13)","v":0}]
["Exempt Direct Charges",{"$f":"SUM('Other Direct'!B22,'Other Direct'!B24,'Other Direct'!B26,'Other Direct'!B27,'Participant Support Costs'!B12)","v":0},{"$f":"SUM('Other Direct'!C22,'Other Direct'!C24,'Other Direct'!C26,'Other Direct'!C27,'Participant Support Costs'!C12)","v":0},{"$f":"SUM('Other Direct'!D22,'Other Direct'!D24,'Other Direct'!D26,'Other Direct'!D27,'Participant Support Costs'!D12)","v":0},{"$f":"SUM('Other Direct'!E22,'Other Direct'!E24,'Other Direct'!E26,'Other Direct'!E27,'Participant Support Costs'!E12)","v":0},{"$f":"SUM('Other Direct'!F22,'Other Direct'!F24,'Other Direct'!F26,'Other Direct'!F27,'Participant Support Costs'!F12)","v":0},{"$f":"SUM(B14:F14)","v":0}]
["Category B  - Subcontracts (F&A calculated on first $25,000 of each subcontract)"]
[]
[]
[{"$f":"MTDC!A10","v":0},{"$f":"'Sub-Agreements'!B6+'Sub-Agreements'!C6","v":0},{"$f":"'Sub-Agreements'!D6+'Sub-Agreements'!E6","v":0},{"$f":"'Sub-Agreements'!F6+'Sub-Agreements'!G6","v":0},{"$f":"'Sub-Agreements'!H6+'Sub-Agreements'!I6","v":0},{"$f":"'Sub-Agreements'!J6+'Sub-Agreements'!K6","v":0},{"$f":"B18+C18+D18+E18+F18","v":0},null,{"$f":"IF($B$18>=25000,25000,$B$18)","v":0},{"$f":"IF($C$18+I18>=25000,25000-I18,$C$18)","v":0},{"$f":"I18+J18","v":0},{"$f":"IF($D$18+K18>=25000,25000-K18,$D$18)","v":0},{"$f":"K18+L18","v":0},{"$f":"IF($E$18+M18>=25000,25000-M18,$E$18)","v":0},{"$f":"M18+N18","v":0},{"$f":"IF($F$18+O18>=25000,25000-O18,$F$18)","v":0},{"$f":"IF($H$18>=25000,25000,$H$18)","v":0}]
[{"$f":"MTDC!A11","v":0},{"$f":"'Sub-Agreements'!B7+'Sub-Agreements'!C7","v":0},{"$f":"'Sub-Agreements'!D7+'Sub-Agreements'!E7","v":0},{"$f":"'Sub-Agreements'!F7+'Sub-Agreements'!G7","v":0},{"$f":"'Sub-Agreements'!H7+'Sub-Agreements'!I7","v":0},{"$f":"'Sub-Agreements'!J7+'Sub-Agreements'!K7","v":0},{"$f":"B19+C19+D19+E19+F19","v":0},null,{"$f":"IF($B$19>=25000,25000,$B$19)","v":0},{"$f":"IF($C$19+I19>=25000,25000-I19,$C$19)","v":0},{"$f":"I19+J19","v":0},{"$f":"IF($D$19+K19>=25000,25000-K19,$D$19)","v":0},{"$f":"K19+L19","v":0},{"$f":"IF($E$19+M19>=25000,25000-M19,$E$19)","v":0},{"$f":"M19+N19","v":0},{"$f":"IF($F$19+O19>=25000,25000-O19,$F$19)","v":0},{"$f":"IF($H$19>=25000,25000,$H$19)","v":0}]
[{"$f":"MTDC!A12","v":0},{"$f":"'Sub-Agreements'!B8+'Sub-Agreements'!C8","v":0},{"$f":"'Sub-Agreements'!D8+'Sub-Agreements'!E8","v":0},{"$f":"'Sub-Agreements'!F8+'Sub-Agreements'!G8","v":0},{"$f":"'Sub-Agreements'!H8+'Sub-Agreements'!I8","v":0},{"$f":"'Sub-Agreements'!J8+'Sub-Agreements'!K8","v":0},{"$f":"B20+C20+D20+E20+F20","v":0},null,{"$f":"IF($B$20>=25000,25000,$B$20)","v":0},{"$f":"IF($C$20+I20>=25000,25000-I20,$C$20)","v":0},{"$f":"I20+J20","v":0},{"$f":"IF($D$20+K20>=25000,25000-K20,$D$20)","v":0},{"$f":"K20+L20","v":0},{"$f":"IF($E$20+M20>=25000,25000-M20,$E$20)","v":0},{"$f":"M20+N20","v":0},{"$f":"IF($F$20+O20>=25000,25000-O20,$F$20)","v":0},{"$f":"IF($H$20>=25000,25000,$H$20)","v":0}]
[{"$f":"MTDC!A13","v":0},{"$f":"'Sub-Agreements'!B9+'Sub-Agreements'!C9","v":0},{"$f":"'Sub-Agreements'!D9+'Sub-Agreements'!E9","v":0},{"$f":"'Sub-Agreements'!F9+'Sub-Agreements'!G9","v":0},{"$f":"'Sub-Agreements'!H9+'Sub-Agreements'!I9","v":0},{"$f":"'Sub-Agreements'!J9+'Sub-Agreements'!K9","v":0},{"$f":"B21+C21+D21+E21+F21","v":0},null,{"$f":"IF($B$21>=25000,25000,$B$21)","v":0},{"$f":"IF($C$21+I21>=25000,25000-I21,$C$21)","v":0},{"$f":"I21+J21","v":0},{"$f":"IF($D$21+K21>=25000,25000-K21,$D$21)","v":0},{"$f":"K21+L21","v":0},{"$f":"IF($E$21+M21>=25000,25000-M21,$E$21)","v":0},{"$f":"M21+N21","v":0},{"$f":"IF($F$21+O21>=25000,25000-O21,$F$21)","v":0},{"$f":"IF($H$21>=25000,25000,$H$21)","v":0}]
[{"$f":"MTDC!A14","v":0},{"$f":"'Sub-Agreements'!B10+'Sub-Agreements'!C10","v":0},{"$f":"'Sub-Agreements'!D10+'Sub-Agreements'!E10","v":0},{"$f":"'Sub-Agreements'!F10+'Sub-Agreements'!G10","v":0},{"$f":"'Sub-Agreements'!H10+'Sub-Agreements'!I10","v":0},{"$f":"'Sub-Agreements'!J10+'Sub-Agreements'!K10","v":0},{"$f":"B22+C22+D22+E22+F22","v":0},null,{"$f":"IF($B$22>=25000,25000,$B$22)","v":0},{"$f":"IF($C$22+I22>=25000,25000-I22,$C$22)","v":0},{"$f":"I22+J22","v":0},{"$f":"IF($D$22+K22>=25000,25000-K22,$D$22)","v":0},{"$f":"K22+L22","v":0},{"$f":"IF($E$22+M22>=25000,25000-M22,$E$22)","v":0},{"$f":"M22+N22","v":0},{"$f":"IF($F$22+O22>=25000,25000-O22,$F$22)","v":0},{"$f":"IF($H$22>=25000,25000,$H$22)","v":0}]
["Category C (Subject to F&A)",null,null,null,null,null,null,null,{"$f":"SUM(I18:I22)","v":0},{"$f":"SUM(J18:J22)","v":0},null,{"$f":"SUM(L18:L22)","v":0},null,{"$f":"SUM(N18:N22)","v":0},null,{"$f":"SUM(P18:P22)","v":0},{"$f":"SUM(Q18:Q22)","v":0}]
["Total of ALL other costs (salaries, fringe benefits, supplies and expense, consultant costs, travel, animal care costs, other "]
["direct costs).  Remember that the NIH Salary Cap still applies.  "]
[]
["Salary/Wages/Fringe",{"$f":"MTDC!B5","v":0},{"$f":"MTDC!C5","v":0},{"$f":"MTDC!D5","v":0},{"$f":"MTDC!E5","v":0},{"$f":"MTDC!F5","v":0},{"$f":"MTDC!G5","v":0}]
["Supplies",{"$f":"MTDC!B6","v":0},{"$f":"MTDC!C6","v":0},{"$f":"MTDC!D6","v":0},{"$f":"MTDC!E6","v":0},{"$f":"MTDC!F6","v":0},{"$f":"MTDC!G6","v":0}]
["Travel",{"$f":"MTDC!B7","v":0},{"$f":"MTDC!C7","v":0},{"$f":"MTDC!D7","v":0},{"$f":"MTDC!E7","v":0},{"$f":"MTDC!F7","v":0},{"$f":"MTDC!G7","v":0}]
["Other Direct Charges",{"$f":"MTDC!B8","v":0},{"$f":"MTDC!C8","v":0},{"$f":"MTDC!D8","v":0},{"$f":"MTDC!E8","v":0},{"$f":"MTDC!F8","v":0},{"$f":"MTDC!G8","v":0}]
[]
["TOTAL DIRECT COSTS (A + B + C)",{"$f":"SUM(B10:B30)","v":0},0,0,0,0,0]
["MODULAR CALCULATION:"]
[null,{"$f":"IF(B32>0,A34+1,0)","v":0},{"$f":"IF(C32>0,B34+1,B34)","v":0},{"$f":"IF(D32>0,C34+1,C34)","v":0},{"$f":"IF(E32>0,D34+1,D34)","v":0},{"$f":"IF(F32>0,E34+1,E34)","v":0},null,null,null,null,null,null,null,null,null,null,null,"This row is normally hidden"]
["Year One Additional Modules (optional)",null,null,null,"results of division",null,null,null,{"$f":"IF(G32>0,(G32+H32)/G38,0)","v":0}]
["Total Direct Costs (minus additional modules)",{"$f":"G32-(B35*25000)-'Sub-Agreements'!L24","v":0},"Div. by # of Yrs ",{"$f":"F34","v":0},{"$f":"IF(D36=0,0,B36/D36)","v":0},"Round to next highest $25K",{"$f":"IF(B36>0,IF(B36<12500,25000,(25000*(ROUNDUP(B36/D36/25000,0)))),0)","v":0},null,{"$f":"IF(G32>0,G38/(G32+H32),0)","v":0}]
[null,null,null,null,null,null,"Totals (including     additional modules)"]
["MODULAR DIRECT COSTS (less Sub F&A)",{"$f":"G36 + (B35*25000)","v":0},{"$f":"IF(C32>0,IF(H7=\"Year Two\",H32+G36,G36),0)","v":0},{"$f":"IF(D32>0,IF(H7=\"Year Three\",H32+G36,G36),0)","v":0},{"$f":"IF(E32>0,IF(H7=\"Year Four\",H32+G36,G36),0)","v":0},{"$f":"IF(F32>0,IF(H7=\"Year Five\",H32+G36,G36),0)","v":0},{"$f":"SUM(B38:F38)","v":0}]
["CONSORTIUM F&A",{"$f":"'Sub-Agreements'!B24","v":0},{"$f":"'Sub-Agreements'!D24","v":0},{"$f":"'Sub-Agreements'!F24","v":0},{"$f":"'Sub-Agreements'!H24","v":0},{"$f":"'Sub-Agreements'!J24","v":0},{"$f":"SUM(B39:F39)","v":0}]
["TOTAL DIRECT COSTS",{"$f":"SUM(B38:B39)","v":0},{"$f":"SUM(C38:C39)","v":0},{"$f":"SUM(D38:D39)","v":0},{"$f":"SUM(E38:E39)","v":0},{"$f":"SUM(F38:F39)","v":0},{"$f":"SUM(G38:H39)","v":0}]
["F&A BASE",{"$f":"IF($H$7=\"year one\",(B38-((SUM(B10:B14)+((SUM(B18:B22))-I23))+(SUM($H$10:$H$13)))+$Q$23)-'Participant Support Costs'!B12,(B38-((SUM(B10:B14))+((SUM(B18:B22))-I23)))-'Participant Support Costs'!B12)+B39","v":0},{"$f":"IF($H$7=\"year two\",(C38-((SUM(C10:C14)+((SUM(C18:C22))-J23))+(SUM($H$10:$H$13)))+$Q$23)-'Participant Support Costs'!C12,(C38-((SUM(C10:C14))+((SUM(C18:C22))-J23)))-'Participant Support Costs'!C12)+C39","v":0},{"$f":"IF($H$7=\"year three\",(D38-((SUM(D10:D14)+((SUM(D18:D22))-L23))+(SUM($H$10:$H$13)))+$Q$23)-'Participant Support Costs'!D12,(D38-((SUM(D10:D14))+((SUM(D18:D22))-L23)))-'Participant Support Costs'!D12)+D39","v":0},{"$f":"IF($H$7=\"year four\",(E38-((SUM(E10:E14)+((SUM(E18:E22))-N23))+(SUM($H$10:$H$13)))+$Q$23)-'Participant Support Costs'!E12,(E38-((SUM(E10:E14))+((SUM(E18:E22))-N23)))-'Participant Support Costs'!E12)+E39","v":0},{"$f":"IF($H$7=\"year five\",(F38-((SUM(F10:F14)+((SUM(F18:F22))-P23))+(SUM($H$10:$H$13)))+$Q$23)-'Participant Support Costs'!F12,(F38-((SUM(F10:F14))+((SUM(F18:F22))-P23)))-'Participant Support Costs'!F12)+F39","v":0},{"$f":"SUM(B41:F41)","v":0}]
["F&A COSTS"]
["F&A Rate x (Annual Modular Direct Cost minus (Cat. A and Subcontract costs in excess of the first $25,000))\"",{"$f":"Total!B30*B41","v":0},{"$f":"Total!C30*C41","v":0},{"$f":"Total!D30*D41","v":0},{"$f":"Total!D30*E41","v":0},{"$f":"Total!D30*F41","v":0},{"$f":"SUM(B43:F43)","v":0}]
["TOTAL COST",{"$f":"B40+B43","v":0},0,0,0,0,0]