{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Title","F&A Rates","Fringe Rates","Salaries & Wages Year 1","Salaries & Wages Year 2","Salaries & Wages Year 3","Salaries & Wages Year 4","Salaries & Wages Year 5","Tuition Remission","Supplies","Equipment & Other Capital","Travel","Participant Support Costs","Other Direct Charges","Sub-Agreements","MTDC","Total"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[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,{"$f":"IF( $D$6 = 0, LEFT(INDEX('F&A Rates'!$C$5:$C$6,2,IFERROR(MATCH(\"*FY\"&'F&A Rates'!$A$23,'F&A Rates'!$C$5:$C$5,0),5)),4), LEFT(INDEX('F&A Rates'!$C$5:$C$6,2,IFERROR(MATCH(\"*FY\"&RIGHT(IF(AND(MONTH($D$6)>=7,MONTH($D$6)<=12),YEAR($D$6)+1,YEAR($D$6))),'F&A Rates'!$C$5:$C$5,0),5)),4))","v":{"$error":"#REF!"}},"     Inflation rate:",null,0.03]
[]
["Indirect Cost Base:",null,"MTDC",null,null,"Default inflation rate.  Change to the rate you wish to use."]

{"sheet":"F&A Rates","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,0,14,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,8,0],[12,0,13,0]]}
["Table of Indirect Cost Rates Rate Agreement"]
["Dated November 21, 2023"]
["Effective July 1, 2023 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,"Clinical Trials","30% of MTDC"]
[null,"Public Service","38.0% of MTDC"]
[null,"Instruction","53.0% of MTDC"]
[]
["All Sources","All Off Campus Programs","26% 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% of TDC"]
[null,"DPI, WI Tech College System","8% 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":2024}]

{"sheet":"Fringe Rates","index":2,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Fringe Rates","FY 2024"]
[]
["Category","Rate"]
["Academic Staff",0.36499999999999999]
["Ad Hoc Program Specialists",6.8000000000000005E-2]
["Grad Interns",0.19800000000000001]
["Limited Term Employees",4.8000000000000001E-2]
["Post-Doc Fellows and/or Trainees",0.16400000000000001]
["Pre-Doc Fellows and/or Trainees",0.22500000000000001]
["Program Assistants",0.22500000000000001]
["Project Assistants",0.22500000000000001]
["Regular University Staff",0.378]
["Regular Faculty",0.36499999999999999]
["Research Assistants",0.22500000000000001]
["Research Associates",0.19800000000000001]
["Student Hourly Employes",1.4999999999999999E-2]
["Teaching Assistants",0.22500000000000001]
["Undergraduate Assistants",6.8000000000000005E-2]
["Undergraduate Interns",6.8000000000000005E-2]

{"sheet":"Salaries & Wages Year 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 & Wages Year 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 & Wages Year 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 & Wages Year 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 & Wages Year 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 and on\", 6000, IF(B5 = \"Spring 2017\", 6000, IF(B5 = \"Fall 2016\", 6000, IF(B5 = \"Spring 2016\", 5000, IF(B5 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(C6*IF(C5 = \"Fall 2017 and on\", 6000, IF(C5 = \"Spring 2017\", 6000, IF(C5 = \"Fall 2016\", 6000, IF(C5 = \"Spring 2016\", 5000, IF(C5 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(D6*IF(D5 = \"Fall 2017 and on\", 6000, IF(D5 = \"Spring 2017\", 6000, IF(D5 = \"Fall 2016\", 6000, IF(D5 = \"Spring 2016\", 5000, IF(D5 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(E6*IF(E5 = \"Fall 2017 and on\", 6000, IF(E5 = \"Spring 2017\", 6000, IF(E5 = \"Fall 2016\", 6000, IF(E5 = \"Spring 2016\", 5000, IF(E5 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(F6*IF(F5 = \"Fall 2017 and on\", 6000, IF(F5 = \"Spring 2017\", 6000, IF(F5 = \"Fall 2016\", 6000, IF(F5 = \"Spring 2016\", 5000, IF(F5 = \"Fall 2015\", 5000, 0))))),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 and on\", 6000, IF(B8 = \"Spring 2017\", 6000, IF(B8 = \"Fall 2016\", 6000, IF(B8 = \"Spring 2016\", 5000, IF(B8 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(C9*IF(C8 = \"Fall 2017 and on\", 6000, IF(C8 = \"Spring 2017\", 6000, IF(C8 = \"Fall 2016\", 6000, IF(C8 = \"Spring 2016\", 5000, IF(C8 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(D9*IF(D8 = \"Fall 2017 and on\", 6000, IF(D8 = \"Spring 2017\", 6000, IF(D8 = \"Fall 2016\", 6000, IF(D8 = \"Spring 2016\", 5000, IF(D8 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(E9*IF(E8 = \"Fall 2017 and on\", 6000, IF(E8 = \"Spring 2017\", 6000, IF(E8 = \"Fall 2016\", 6000, IF(E8 = \"Spring 2016\", 5000, IF(E8 = \"Fall 2015\", 5000, 0))))),0)","v":0},{"$f":"ROUND(F9*IF(F8 = \"Fall 2017 and on\", 6000, IF(F8 = \"Spring 2017\", 6000, IF(F8 = \"Fall 2016\", 6000, IF(F8 = \"Spring 2016\", 5000, IF(F8 = \"Fall 2015\", 5000, 0))))),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 & Other 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,0,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":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[10,1,10,2],[12,0,12,6]]}
["Worksheet for Project Budget"]
["Participant Support Costs (Excluded from MTDC)"]
[]
["Category","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
["Stipends",null,null,null,null,null,{"$f":"(B5)+(C5)+(D5)+(E5)+(F5)","v":0}]
["Travel",null,null,null,null,null,{"$f":"(B6)+(C6)+(D6)+(E6)+(F6)","v":0}]
["Subsistence",null,null,null,null,null,{"$f":"(B7)+(C7)+(D7)+(E7)+(F7)","v":0}]
["Other",null,null,null,null,null,{"$f":"(B8)+(C8)+(D8)+(E8)+(F8)","v":0}]
["Total",{"$f":"SUM(B5:B8)","v":0},{"$f":"SUM(C5:C8)","v":0},{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},{"$f":"SUM(F5:F8)","v":0},{"$f":"(B9)+(C9)+(D9)+(E9)+(F9)","v":0}]
[]
[1,"Number of Participants/Trainees"]
[]
["Last Modified: 2/20/2017"]

{"sheet":"Other Direct Charges","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,0,0,0,null,0]
["Telephone (long distance or dedicated lines)",null,null,null,null,null,0]
["Research Subjects",null,0,0,0,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'!B9","v":0},{"$f":"'Participant Support Costs'!C9","v":0},{"$f":"'Participant Support Costs'!D9","v":0},{"$f":"'Participant Support Costs'!E9","v":0},{"$f":"'Participant Support Costs'!F9","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":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
["Sub-Agreements"]
[]
["Entity Name","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
[null,null,null,null,null,null,{"$f":"SUM(B5:F5)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,0,0,0,0,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
["Total Sub-Agreements",{"$f":"ROUND(SUM(B5:B15),0)","v":0},0,0,0,0,0]

{"sheet":"MTDC","index":15,"n_rows":47,"n_cols":7,"rows_kept":47,"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 & Wages Year 1'!H5:H21)+(SUM('Salaries & Wages Year 1'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries & Wages Year 2'!H5:H21)+(SUM('Salaries & Wages Year 2'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries & Wages Year 3'!H5:H21)+(SUM('Salaries & Wages Year 3'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries & Wages Year 4'!H5:H21)+(SUM('Salaries & Wages Year 4'!J5:J21)),0)","v":0},{"$f":"ROUND(SUM('Salaries & Wages Year 5'!H5:H21)+(SUM('Salaries & Wages Year 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 Charges'!B6:B20),0)","v":0},{"$f":"ROUND(SUM('Other Direct Charges'!C6:C20),0)","v":0},{"$f":"ROUND(SUM('Other Direct Charges'!D6:D20),0)","v":0},{"$f":"ROUND(SUM('Other Direct Charges'!E6:E20),0)","v":0},{"$f":"ROUND(SUM('Other Direct Charges'!F6:F20),0)","v":0},{"$f":"SUM(B8:F8)","v":0}]
["Sub-Agreements"]
[{"$f":"'Sub-Agreements'!A5","v":0},{"$f":"IF('Sub-Agreements'!B5>25000,25000,'Sub-Agreements'!B5)","v":0},{"$f":"IF('Sub-Agreements'!C5=0,0,IF(B10=25000,0,IF('Sub-Agreements'!C5<(25000-B10),'Sub-Agreements'!C5,(25000-B10))))","v":0},{"$f":"IF('Sub-Agreements'!D5=0,0,IF(SUM(B10,C10)=25000,0,IF('Sub-Agreements'!D5<(25000-SUM(B10,C10)),'Sub-Agreements'!D5,(25000-SUM(B10,C10)))))","v":0},{"$f":"IF('Sub-Agreements'!E5=0,0,IF(SUM(B10,C10,D10)=25000,0,IF('Sub-Agreements'!E5<(25000-SUM(B10,C10,D10)),'Sub-Agreements'!E5,(25000-SUM(B10,C10,D10)))))","v":0},{"$f":"IF('Sub-Agreements'!F5=0,0,IF(SUM(B10,C10,D10,E10)=25000,0,IF('Sub-Agreements'!F5<(25000-SUM(B10,C10,D10,E10)),'Sub-Agreements'!F5,(25000-SUM(B10,C10,D10,E10)))))","v":0},{"$f":"SUM(B10:F10)","v":0}]
[{"$f":"'Sub-Agreements'!A6","v":0},{"$f":"IF('Sub-Agreements'!B6>25000,25000,'Sub-Agreements'!B6)","v":0},{"$f":"IF('Sub-Agreements'!C6=0,0,IF(B11=25000,0,IF('Sub-Agreements'!C6<(25000-B11),'Sub-Agreements'!C6,(25000-B11))))","v":0},{"$f":"IF('Sub-Agreements'!D6=0,0,IF(SUM(B11,C11)=25000,0,IF('Sub-Agreements'!D6<(25000-SUM(B11,C11)),'Sub-Agreements'!D6,(25000-SUM(B11,C11)))))","v":0},{"$f":"IF('Sub-Agreements'!E6=0,0,IF(SUM(B11,C11,D11)=25000,0,IF('Sub-Agreements'!E6<(25000-SUM(B11,C11,D11)),'Sub-Agreements'!E6,(25000-SUM(B11,C11,D11)))))","v":0},{"$f":"IF('Sub-Agreements'!F6=0,0,IF(SUM(B11,C11,D11,E11)=25000,0,IF('Sub-Agreements'!F6<(25000-SUM(B11,C11,D11,E11)),'Sub-Agreements'!F6,(25000-SUM(B11,C11,D11,E11)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A7","v":0},{"$f":"IF('Sub-Agreements'!B7>25000,25000,'Sub-Agreements'!B7)","v":0},{"$f":"IF('Sub-Agreements'!C7=0,0,IF(B12=25000,0,IF('Sub-Agreements'!C7<(25000-B12),'Sub-Agreements'!C7,(25000-B12))))","v":0},{"$f":"IF('Sub-Agreements'!D7=0,0,IF(SUM(B12,C12)=25000,0,IF('Sub-Agreements'!D7<(25000-SUM(B12,C12)),'Sub-Agreements'!D7,(25000-SUM(B12,C12)))))","v":0},{"$f":"IF('Sub-Agreements'!E7=0,0,IF(SUM(B12,C12,D12)=25000,0,IF('Sub-Agreements'!E7<(25000-SUM(B12,C12,D12)),'Sub-Agreements'!E7,(25000-SUM(B12,C12,D12)))))","v":0},{"$f":"IF('Sub-Agreements'!F7=0,0,IF(SUM(B12,C12,D12,E12)=25000,0,IF('Sub-Agreements'!F7<(25000-SUM(B12,C12,D12,E12)),'Sub-Agreements'!F7,(25000-SUM(B12,C12,D12,E12)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A8","v":0},{"$f":"IF('Sub-Agreements'!B8>25000,25000,'Sub-Agreements'!B8)","v":0},{"$f":"IF('Sub-Agreements'!C8=0,0,IF(B13=25000,0,IF('Sub-Agreements'!C8<(25000-B13),'Sub-Agreements'!C8,(25000-B13))))","v":0},{"$f":"IF('Sub-Agreements'!D8=0,0,IF(SUM(B13,C13)=25000,0,IF('Sub-Agreements'!D8<(25000-SUM(B13,C13)),'Sub-Agreements'!D8,(25000-SUM(B13,C13)))))","v":0},{"$f":"IF('Sub-Agreements'!E8=0,0,IF(SUM(B13,C13,D13)=25000,0,IF('Sub-Agreements'!E8<(25000-SUM(B13,C13,D13)),'Sub-Agreements'!E8,(25000-SUM(B13,C13,D13)))))","v":0},{"$f":"IF('Sub-Agreements'!F8=0,0,IF(SUM(B13,C13,D13,E13)=25000,0,IF('Sub-Agreements'!F8<(25000-SUM(B13,C13,D13,E13)),'Sub-Agreements'!F8,(25000-SUM(B13,C13,D13,E13)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A9","v":0},{"$f":"IF('Sub-Agreements'!B9>25000,25000,'Sub-Agreements'!B9)","v":0},{"$f":"IF('Sub-Agreements'!C9=0,0,IF(B14=25000,0,IF('Sub-Agreements'!C9<(25000-B14),'Sub-Agreements'!C9,(25000-B14))))","v":0},{"$f":"IF('Sub-Agreements'!D9=0,0,IF(SUM(B14,C14)=25000,0,IF('Sub-Agreements'!D9<(25000-SUM(B14,C14)),'Sub-Agreements'!D9,(25000-SUM(B14,C14)))))","v":0},{"$f":"IF('Sub-Agreements'!E9=0,0,IF(SUM(B14,C14,D14)=25000,0,IF('Sub-Agreements'!E9<(25000-SUM(B14,C14,D14)),'Sub-Agreements'!E9,(25000-SUM(B14,C14,D14)))))","v":0},{"$f":"IF('Sub-Agreements'!F9=0,0,IF(SUM(B14,C14,D14,E14)=25000,0,IF('Sub-Agreements'!F9<(25000-SUM(B14,C14,D14,E14)),'Sub-Agreements'!F9,(25000-SUM(B14,C14,D14,E14)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A10","v":0},{"$f":"IF('Sub-Agreements'!B10>25000,25000,'Sub-Agreements'!B10)","v":0},{"$f":"IF('Sub-Agreements'!C10=0,0,IF(B15=25000,0,IF('Sub-Agreements'!C10<(25000-B15),'Sub-Agreements'!C10,(25000-B15))))","v":0},{"$f":"IF('Sub-Agreements'!D10=0,0,IF(SUM(B15,C15)=25000,0,IF('Sub-Agreements'!D10<(25000-SUM(B15,C15)),'Sub-Agreements'!D10,(25000-SUM(B15,C15)))))","v":0},{"$f":"IF('Sub-Agreements'!E10=0,0,IF(SUM(B15,C15,D15)=25000,0,IF('Sub-Agreements'!E10<(25000-SUM(B15,C15,D15)),'Sub-Agreements'!E10,(25000-SUM(B15,C15,D15)))))","v":0},{"$f":"IF('Sub-Agreements'!F10=0,0,IF(SUM(B15,C15,D15,E15)=25000,0,IF('Sub-Agreements'!F10<(25000-SUM(B15,C15,D15,E15)),'Sub-Agreements'!F10,(25000-SUM(B15,C15,D15,E15)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A11","v":0},{"$f":"IF('Sub-Agreements'!B11>25000,25000,'Sub-Agreements'!B11)","v":0},{"$f":"IF('Sub-Agreements'!C11=0,0,IF(B16=25000,0,IF('Sub-Agreements'!C11<(25000-B16),'Sub-Agreements'!C11,(25000-B16))))","v":0},{"$f":"IF('Sub-Agreements'!D11=0,0,IF(SUM(B16,C16)=25000,0,IF('Sub-Agreements'!D11<(25000-SUM(B16,C16)),'Sub-Agreements'!D11,(25000-SUM(B16,C16)))))","v":0},{"$f":"IF('Sub-Agreements'!E11=0,0,IF(SUM(B16,C16,D16)=25000,0,IF('Sub-Agreements'!E11<(25000-SUM(B16,C16,D16)),'Sub-Agreements'!E11,(25000-SUM(B16,C16,D16)))))","v":0},{"$f":"IF('Sub-Agreements'!F11=0,0,IF(SUM(B16,C16,D16,E16)=25000,0,IF('Sub-Agreements'!F11<(25000-SUM(B16,C16,D16,E16)),'Sub-Agreements'!F11,(25000-SUM(B16,C16,D16,E16)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A12","v":0},{"$f":"IF('Sub-Agreements'!B12>25000,25000,'Sub-Agreements'!B12)","v":0},{"$f":"IF('Sub-Agreements'!C12=0,0,IF(B17=25000,0,IF('Sub-Agreements'!C12<(25000-B17),'Sub-Agreements'!C12,(25000-B17))))","v":0},{"$f":"IF('Sub-Agreements'!D12=0,0,IF(SUM(B17,C17)=25000,0,IF('Sub-Agreements'!D12<(25000-SUM(B17,C17)),'Sub-Agreements'!D12,(25000-SUM(B17,C17)))))","v":0},{"$f":"IF('Sub-Agreements'!E12=0,0,IF(SUM(B17,C17,D17)=25000,0,IF('Sub-Agreements'!E12<(25000-SUM(B17,C17,D17)),'Sub-Agreements'!E12,(25000-SUM(B17,C17,D17)))))","v":0},{"$f":"IF('Sub-Agreements'!F12=0,0,IF(SUM(B17,C17,D17,E17)=25000,0,IF('Sub-Agreements'!F12<(25000-SUM(B17,C17,D17,E17)),'Sub-Agreements'!F12,(25000-SUM(B17,C17,D17,E17)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A13","v":0},{"$f":"IF('Sub-Agreements'!B13>25000,25000,'Sub-Agreements'!B13)","v":0},{"$f":"IF('Sub-Agreements'!C13=0,0,IF(B18=25000,0,IF('Sub-Agreements'!C13<(25000-B18),'Sub-Agreements'!C13,(25000-B18))))","v":0},{"$f":"IF('Sub-Agreements'!D13=0,0,IF(SUM(B18,C18)=25000,0,IF('Sub-Agreements'!D13<(25000-SUM(B18,C18)),'Sub-Agreements'!D13,(25000-SUM(B18,C18)))))","v":0},{"$f":"IF('Sub-Agreements'!E13=0,0,IF(SUM(B18,C18,D18)=25000,0,IF('Sub-Agreements'!E13<(25000-SUM(B18,C18,D18)),'Sub-Agreements'!E13,(25000-SUM(B18,C18,D18)))))","v":0},{"$f":"IF('Sub-Agreements'!F13=0,0,IF(SUM(B18,C18,D18,E18)=25000,0,IF('Sub-Agreements'!F13<(25000-SUM(B18,C18,D18,E18)),'Sub-Agreements'!F13,(25000-SUM(B18,C18,D18,E18)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A14","v":0},{"$f":"IF('Sub-Agreements'!B14>25000,25000,'Sub-Agreements'!B14)","v":0},{"$f":"IF('Sub-Agreements'!C14=0,0,IF(B19=25000,0,IF('Sub-Agreements'!C14<(25000-B19),'Sub-Agreements'!C14,(25000-B19))))","v":0},{"$f":"IF('Sub-Agreements'!D14=0,0,IF(SUM(B19,C19)=25000,0,IF('Sub-Agreements'!D14<(25000-SUM(B19,C19)),'Sub-Agreements'!D14,(25000-SUM(B19,C19)))))","v":0},{"$f":"IF('Sub-Agreements'!E14=0,0,IF(SUM(B19,C19,D19)=25000,0,IF('Sub-Agreements'!E14<(25000-SUM(B19,C19,D19)),'Sub-Agreements'!E14,(25000-SUM(B19,C19,D19)))))","v":0},{"$f":"IF('Sub-Agreements'!F14=0,0,IF(SUM(B19,C19,D19,E19)=25000,0,IF('Sub-Agreements'!F14<(25000-SUM(B19,C19,D19,E19)),'Sub-Agreements'!F14,(25000-SUM(B19,C19,D19,E19)))))","v":0},0]
[{"$f":"'Sub-Agreements'!A15","v":0},{"$f":"IF('Sub-Agreements'!B15>25000,25000,'Sub-Agreements'!B15)","v":0},{"$f":"IF('Sub-Agreements'!C15=0,0,IF(B20=25000,0,IF('Sub-Agreements'!C15<(25000-B20),'Sub-Agreements'!C15,(25000-B20))))","v":0},{"$f":"IF('Sub-Agreements'!D15=0,0,IF(SUM(B20,C20)=25000,0,IF('Sub-Agreements'!D15<(25000-SUM(B20,C20)),'Sub-Agreements'!D15,(25000-SUM(B20,C20)))))","v":0},{"$f":"IF('Sub-Agreements'!E15=0,0,IF(SUM(B20,C20,D20)=25000,0,IF('Sub-Agreements'!E15<(25000-SUM(B20,C20,D20)),'Sub-Agreements'!E15,(25000-SUM(B20,C20,D20)))))","v":0},{"$f":"IF('Sub-Agreements'!F15=0,0,IF(SUM(B20,C20,D20,E20)=25000,0,IF('Sub-Agreements'!F15<(25000-SUM(B20,C20,D20,E20)),'Sub-Agreements'!F15,(25000-SUM(B20,C20,D20,E20)))))","v":0},0]
[]
["Total MTDC",{"$f":"ROUND(SUM(B5:B20),0)","v":0},0,0,0,0,0]
[]
["Non-MTDC Items"]
[]
["Equipment & Other Capital",{"$f":"'Equipment & Other Capital'!B34","v":0},{"$f":"'Equipment & Other Capital'!C34","v":0},{"$f":"'Equipment & Other Capital'!D34","v":0},{"$f":"'Equipment & Other Capital'!E34","v":0},{"$f":"'Equipment & Other Capital'!F34","v":0},{"$f":"SUM(B26:F26)","v":0}]
["Tuition Remission",{"$f":"'Other Direct Charges'!B22","v":0},{"$f":"'Other Direct Charges'!C22","v":0},{"$f":"'Other Direct Charges'!D22","v":0},{"$f":"'Other Direct Charges'!E22","v":0},{"$f":"'Other Direct Charges'!F22","v":0},0]
["Rentals & Leases for Space and/or Land",{"$f":"'Other Direct Charges'!B23","v":0},{"$f":"'Other Direct Charges'!C23","v":0},{"$f":"'Other Direct Charges'!D23","v":0},{"$f":"'Other Direct Charges'!E23","v":0},{"$f":"'Other Direct Charges'!F23","v":0},0]
["Equipment Rentals & Leases",{"$f":"'Other Direct Charges'!B24","v":0},{"$f":"'Other Direct Charges'!C24","v":0},{"$f":"'Other Direct Charges'!D24","v":0},{"$f":"'Other Direct Charges'!E24","v":0},{"$f":"'Other Direct Charges'!F24","v":0},0]
["Patient Care Costs",{"$f":"'Other Direct Charges'!B25","v":0},{"$f":"'Other Direct Charges'!C25","v":0},{"$f":"'Other Direct Charges'!D25","v":0},{"$f":"'Other Direct Charges'!E25","v":0},{"$f":"'Other Direct Charges'!F25","v":0},0]
["Grant/Aid/Lump Sum Awards/ Research Support",{"$f":"'Other Direct Charges'!B26","v":0},{"$f":"'Other Direct Charges'!C26","v":0},{"$f":"'Other Direct Charges'!D26","v":0},{"$f":"'Other Direct Charges'!E26","v":0},{"$f":"'Other Direct Charges'!F26","v":0},0]
["Student Aid/Tuition & Fees",{"$f":"'Other Direct Charges'!B27","v":0},{"$f":"'Other Direct Charges'!C27","v":0},{"$f":"'Other Direct Charges'!D27","v":0},{"$f":"'Other Direct Charges'!E27","v":0},{"$f":"'Other Direct Charges'!F27","v":0},0]
["Alterations and Renovation Costs",{"$f":"'Other Direct Charges'!B28","v":0},{"$f":"'Other Direct Charges'!C28","v":0},{"$f":"'Other Direct Charges'!D28","v":0},{"$f":"'Other Direct Charges'!E28","v":0},{"$f":"'Other Direct Charges'!F28","v":0},0]
["Participant Support Costs",{"$f":"'Other Direct Charges'!B29","v":0},{"$f":"'Other Direct Charges'!C29","v":0},{"$f":"'Other Direct Charges'!D29","v":0},{"$f":"'Other Direct Charges'!E29","v":0},{"$f":"'Other Direct Charges'!F29","v":0},0]
["Sub-Agreements >$25,000"]
[{"$f":"'Sub-Agreements'!A5","v":0},{"$f":"IF('Sub-Agreements'!B5>=25000,('Sub-Agreements'!B5-25000),0)","v":0},{"$f":"IF((B10+C10)=25000,('Sub-Agreements'!C5-C10),0)","v":0},{"$f":"IF((B10+C10+D10)=25000,('Sub-Agreements'!D5-D10),0)","v":0},{"$f":"IF((B10+C10+D10+E10)=25000,('Sub-Agreements'!E5-E10),0)","v":0},{"$f":"IF((B10+C10+D10+E10+F10)=25000,('Sub-Agreements'!F5-F10),0)","v":0},{"$f":"SUM(B36:F36)","v":0}]
[{"$f":"'Sub-Agreements'!A6","v":0},{"$f":"IF('Sub-Agreements'!B6>=25000,('Sub-Agreements'!B6-25000),0)","v":0},{"$f":"IF((B11+C11)=25000,('Sub-Agreements'!C6-C11),0)","v":0},{"$f":"IF((B11+C11+D11)=25000,('Sub-Agreements'!D6-D11),0)","v":0},{"$f":"IF((B11+C11+D11+E11)=25000,('Sub-Agreements'!E6-E11),0)","v":0},{"$f":"IF((B11+C11+D11+E11+F11)=25000,('Sub-Agreements'!F6-F11),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A7","v":0},{"$f":"IF('Sub-Agreements'!B7>=25000,('Sub-Agreements'!B7-25000),0)","v":0},{"$f":"IF((B12+C12)=25000,('Sub-Agreements'!C7-C12),0)","v":0},{"$f":"IF((B12+C12+D12)=25000,('Sub-Agreements'!D7-D12),0)","v":0},{"$f":"IF((B12+C12+D12+E12)=25000,('Sub-Agreements'!E7-E12),0)","v":0},{"$f":"IF((B12+C12+D12+E12+F12)=25000,('Sub-Agreements'!F7-F12),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A8","v":0},{"$f":"IF('Sub-Agreements'!B8>=25000,('Sub-Agreements'!B8-25000),0)","v":0},{"$f":"IF((B13+C13)=25000,('Sub-Agreements'!C8-C13),0)","v":0},{"$f":"IF((B13+C13+D13)=25000,('Sub-Agreements'!D8-D13),0)","v":0},{"$f":"IF((B13+C13+D13+E13)=25000,('Sub-Agreements'!E8-E13),0)","v":0},{"$f":"IF((B13+C13+D13+E13+F13)=25000,('Sub-Agreements'!F8-F13),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A9","v":0},{"$f":"IF('Sub-Agreements'!B9>=25000,('Sub-Agreements'!B9-25000),0)","v":0},{"$f":"IF((B14+C14)=25000,('Sub-Agreements'!C9-C14),0)","v":0},{"$f":"IF((B14+C14+D14)=25000,('Sub-Agreements'!D9-D14),0)","v":0},{"$f":"IF((B14+C14+D14+E14)=25000,('Sub-Agreements'!E9-E14),0)","v":0},{"$f":"IF((B14+C14+D14+E14+F14)=25000,('Sub-Agreements'!F9-F14),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A10","v":0},{"$f":"IF('Sub-Agreements'!B10>=25000,('Sub-Agreements'!B10-25000),0)","v":0},{"$f":"IF((B15+C15)=25000,('Sub-Agreements'!C10-C15),0)","v":0},{"$f":"IF((B15+C15+D15)=25000,('Sub-Agreements'!D10-D15),0)","v":0},{"$f":"IF((B15+C15+D15+E15)=25000,('Sub-Agreements'!E10-E15),0)","v":0},{"$f":"IF((B15+C15+D15+E15+F15)=25000,('Sub-Agreements'!F10-F15),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A11","v":0},{"$f":"IF('Sub-Agreements'!B11>=25000,('Sub-Agreements'!B11-25000),0)","v":0},{"$f":"IF((B16+C16)=25000,('Sub-Agreements'!C11-C16),0)","v":0},{"$f":"IF((B16+C16+D16)=25000,('Sub-Agreements'!D11-D16),0)","v":0},{"$f":"IF((B16+C16+D16+E16)=25000,('Sub-Agreements'!E11-E16),0)","v":0},{"$f":"IF((B16+C16+D16+E16+F16)=25000,('Sub-Agreements'!F11-F16),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A12","v":0},{"$f":"IF('Sub-Agreements'!B12>=25000,('Sub-Agreements'!B12-25000),0)","v":0},{"$f":"IF((B17+C17)=25000,('Sub-Agreements'!C12-C17),0)","v":0},{"$f":"IF((B17+C17+D17)=25000,('Sub-Agreements'!D12-D17),0)","v":0},{"$f":"IF((B17+C17+D17+E17)=25000,('Sub-Agreements'!E12-E17),0)","v":0},{"$f":"IF((B17+C17+D17+E17+F17)=25000,('Sub-Agreements'!F12-F17),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A13","v":0},{"$f":"IF('Sub-Agreements'!B13>=25000,('Sub-Agreements'!B13-25000),0)","v":0},{"$f":"IF((B18+C18)=25000,('Sub-Agreements'!C13-C18),0)","v":0},{"$f":"IF((B18+C18+D18)=25000,('Sub-Agreements'!D13-D18),0)","v":0},{"$f":"IF((B18+C18+D18+E18)=25000,('Sub-Agreements'!E13-E18),0)","v":0},{"$f":"IF((B18+C18+D18+E18+F18)=25000,('Sub-Agreements'!F13-F18),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A14","v":0},{"$f":"IF('Sub-Agreements'!B14>=25000,('Sub-Agreements'!B14-25000),0)","v":0},{"$f":"IF((B19+C19)=25000,('Sub-Agreements'!C14-C19),0)","v":0},{"$f":"IF((B19+C19+D19)=25000,('Sub-Agreements'!D14-D19),0)","v":0},{"$f":"IF((B19+C19+D19+E19)=25000,('Sub-Agreements'!E14-E19),0)","v":0},{"$f":"IF((B19+C19+D19+E19+F19)=25000,('Sub-Agreements'!F14-F19),0)","v":0},0]
[{"$f":"'Sub-Agreements'!A15","v":0},{"$f":"IF('Sub-Agreements'!B15>=25000,('Sub-Agreements'!B15-25000),0)","v":0},{"$f":"IF((B20+C20)=25000,('Sub-Agreements'!C15-C20),0)","v":0},{"$f":"IF((B20+C20+D20)=25000,('Sub-Agreements'!D15-D20),0)","v":0},{"$f":"IF((B20+C20+D20+E20)=25000,('Sub-Agreements'!E15-E20),0)","v":0},{"$f":"IF((B20+C20+D20+E20+F20)=25000,('Sub-Agreements'!F15-F20),0)","v":0},0]
["Total Non-MTDC",{"$f":"ROUND(SUM(B26:B46),0)","v":0},0,0,0,0,0]

{"sheet":"Total","index":16,"n_rows":20,"n_cols":7,"rows_kept":20,"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 & Wages Year 1'!H23","v":0},{"$f":"'Salaries & Wages Year 2'!H23","v":0},{"$f":"'Salaries & Wages Year 3'!H23","v":0},{"$f":"'Salaries & Wages Year 4'!H23","v":0},{"$f":"'Salaries & Wages Year 5'!H23","v":0},{"$f":"SUM(B7:F7)","v":0}]
["Fringe Benefits",{"$f":"'Salaries & Wages Year 1'!J23","v":0},{"$f":"'Salaries & Wages Year 2'!J23","v":0},{"$f":"'Salaries & Wages Year 3'!J23","v":0},{"$f":"'Salaries & Wages Year 4'!J23","v":0},{"$f":"'Salaries & Wages Year 5'!J23","v":0},0]
["Equipment & Other Capital",{"$f":"'Equipment & Other Capital'!B34","v":0},{"$f":"'Equipment & Other Capital'!C34","v":0},{"$f":"'Equipment & Other Capital'!D34","v":0},{"$f":"'Equipment & Other Capital'!E34","v":0},{"$f":"'Equipment & Other 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 Charges'!B30","v":0},{"$f":"'Other Direct Charges'!C30","v":0},{"$f":"'Other Direct Charges'!D30","v":0},{"$f":"'Other Direct Charges'!E30","v":0},{"$f":"'Other Direct Charges'!F30","v":0},0]
["Sub-Agreements",{"$f":"'Sub-Agreements'!B17","v":0},{"$f":"'Sub-Agreements'!C17","v":0},{"$f":"'Sub-Agreements'!D17","v":0},{"$f":"'Sub-Agreements'!E17","v":0},{"$f":"'Sub-Agreements'!F17","v":0},0]
[]
["Direct Costs",{"$f":"SUM(B7:B14)","v":0},0,0,0,0,0]
["MTDC Costs",{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!B22,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!C22,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!D22,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!E22,0)","v":0},{"$f":"IF(Title!$C$12=\"MTDC\",MTDC!F22,0)","v":0},{"$f":"SUM(B17:F17)","v":0}]
["F&A Costs",{"$f":"IF(C4 = 0, 0, IF(Title!$C$12=\"MTDC\",B17*B19,IF(Title!$C$12=\"Salary Wage Fringe\",(B7+B8)*B19,B16*B19)))","v":0},{"$f":"IF(C4 = 0, 0, IF(Title!$C$12=\"MTDC\",C17*C19,IF(Title!$C$12=\"Salary Wage Fringe\",(C7+C8)*C19,C16*C19)))","v":0},{"$f":"IF(C4 = 0, 0, IF(Title!$C$12=\"MTDC\",D17*D19,IF(Title!$C$12=\"Salary Wage Fringe\",(D7+D8)*D19,D16*D19)))","v":0},{"$f":"IF(C4 = 0, 0, IF(Title!$C$12=\"MTDC\",E17*E19,IF(Title!$C$12=\"Salary Wage Fringe\",(E7+E8)*E19,E16*E19)))","v":0},{"$f":"IF(C4 = 0, 0, IF(Title!$C$12=\"MTDC\",F17*F19,IF(Title!$C$12=\"Salary Wage Fringe\",(F7+F8)*F19,F16*F19)))","v":0},{"$f":"SUM(B18:F18)","v":0}]
["F&A Rate (%)",{"$f":"IF($C$4=0,0.555,Title!$C10/100)","v":0.55500000000000005},{"$f":"IF($C$4=0,0.555,Title!$C10/100)","v":0.55500000000000005},{"$f":"IF($C$4=0,0.555,Title!$C10/100)","v":0.55500000000000005},{"$f":"IF($C$4=0,0.555,Title!$C10/100)","v":0.55500000000000005},{"$f":"IF($C$4=0,0.555,Title!$C10/100)","v":0.55500000000000005}]
["Total Costs",{"$f":"SUM(B16+B18)","v":0},0,0,0,0,0]