{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Blank Budget","NTP Budget","Control","Budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Blank Budget","index":0,"n_rows":78,"n_cols":30,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3],[59,1,59,2]]}
["Funding Proposal/Award Number"]
["PI"]
["Project Period"]
["Project Title"]
[]
[null,null,null,null,null,"WBSE RCC"]
[null,null,null,null,null,"WBSE RCC Name"]
[null,null,null,null,null,"Responsible PI Name"]
[null,null,null,null,null,"Responsible PI Person ID"]
[null,null,null,null,null,"Sponsored Program"]
[null,null,null,null,null,"WBSE Description"]
[null,null,"Project F&A Rate",null,null,"F&A Rate"]
[null,null,"F&A Base",{"$f":"IF($F$13=\"MTDC Base\",D54+D73-SUMIFS(D26:D60,$C26:$C60,\"Y\"),IF($F$13=\"TDC Base\",D54,IF($F$13=\"USDA Base\",(D54),IF($F$13=\"NIFA/AFRI\",(D54-D47),\"\"))))","v":0},"CHOOSE BASE:","MTDC Base",{"$f":"IF($F$13=\"MTDC Base\",G54+G73-SUMIFS(G26:G60,$C26:$C60,\"Y\"),IF($F$13=\"TDC Base\",G54,IF($F$13=\"USDA Base\",(G54),IF($F$13=\"NIFA/AFRI\",(G54-G47),\"\"))))","v":0},{"$f":"IF($F$13=\"MTDC Base\",H54+H73-SUMIFS(H26:H60,$C26:$C60,\"Y\"),IF($F$13=\"TDC Base\",H54,IF($F$13=\"USDA Base\",(H54),IF($F$13=\"NIFA/AFRI\",(H54-H47),\"\"))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Budget Categories",null,null,"Total Budget","Remaining","Budgeted Total"]
["Professional Salary",null,null,null,{"$f":"D16-F16","v":0},{"$f":"SUM(G16:AD16)","v":0}]
["Graduate Salaries",null,null,null,{"$f":"D17-F17","v":0},{"$f":"SUM(G17:AD17)","v":0}]
["Post Doc",null,null,null,0,0]
["Service Salaries",null,null,null,0,0]
["Clerical Salaries",null,null,null,0,0]
["Temporary Staff Salaries",null,null,null,0,0]
["Total Salaries",null,null,{"$f":"SUM(D16:D21)","v":0},0,0,{"$f":"SUM(G16:G21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Fringes",null,null,null,0,0]
["Other Direct Costs"]
["Cost Type","Description","Exclude From MTDC Base"]
["ADP/Computer Services",null,null,null,{"$f":"D26-F26","v":0},{"$f":"SUM(G26:AD26)","v":0}]
["Alterations and Renovations",null,null,null,{"$f":"D27-F27","v":0},0]
["Animal",null,null,null,0,0]
["Consultant Services",null,null,null,0,0]
["Equipment",null,"Y",null,0,0]
["Equipment or Facility Rental/User Fees",null,"Y",null,0,0]
["Grad Fee Remit",null,"Y",null,0,0]
["Human Subjects",null,null,null,0,0]
["Materials and Supplies",null,null,null,0,0]
["Other",null,null,null,0,0]
["Publication Costs",null,null,null,0,0]
["Trainee: Other",null,"Y",null,0,0]
["Trainee: Stipend",null,"Y",null,0,0]
["Trainee: Subsistence",null,"Y",null,0,0]
["Trainee: Travel",null,"Y",null,0,0]
["Trainee: Tuition",null,"Y",null,0,0]
["Travel: Domestic",null,null,null,0,0]
["Travel: Foreign",null,null,null,0,0]
["Recharge Rates",null,null,{"$f":"D45+D46","v":0},0,0,{"$f":"G45+G46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Recharge Rates Included in Base",null,null,null,{"$f":"D45-F45","v":0},0]
["Recharge Rates Not Included in Base",null,"Y",null,{"$f":"D46-F46","v":0},0]
["Total Subaward Costs (including Indirects)",null,"Y",{"$f":"SUM(D48:D52)","v":0},{"$f":"D47-F47","v":0},0,{"$f":"SUM(G48:G52)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"\"Total \" & A62","v":"Total Subaward 1"},null,null,{"$f":"D62+D68","v":0},0,0]
[{"$f":"\"Total \" & A63","v":"Total Subaward 2"},null,null,{"$f":"D63+D69","v":0},0,0]
[{"$f":"\"Total \" & A64","v":"Total Subaward 3"},null,null,{"$f":"D64+D70","v":0},0,0]
[{"$f":"\"Total \" & A65","v":"Total Subaward 4"},null,null,{"$f":"D65+D71","v":0},0,0]
[{"$f":"\"Total \" & A66","v":"Total Subaward 5"},null,null,{"$f":"D66+D72","v":0},0,0]
["Total Other Direct Costs",null,null,{"$f":"SUM(D26:D44,D47)","v":0},{"$f":"D53-F53","v":0},0,{"$f":"SUM(G26:G44,G47)","v":0},{"$f":"SUM(H26:H44,H47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Direct Costs (Salaries + Fringes + Other)",null,null,{"$f":"D22+D23+D53","v":0},0,0,{"$f":"G22+G23+G53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["IP Fee",null,null,null,{"$f":"D55-F55","v":0},0]
["Unallocated Available",null,null,null,0,0]
["Unallocated Restricted",null,null,null,0,0]
["Purdue Indirects",null,null,{"$f":"IFERROR(D13*D12,0)","v":0},{"$f":"D58-F58","v":0},0,{"$f":"IFERROR(G13*G12,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs",null,null,{"$f":"SUM(D54,D58,D56:D57)","v":0},{"$f":"D59-F59","v":0},0,{"$f":"SUM(G54,G58,G56:G57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs w IP Fee",null,null,{"$f":"D59+D55","v":0},{"$f":"D60-F60","v":0},0,{"$f":"G59+G55","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subawards",null,"Y",{"$f":"SUM(D62:D66)","v":0},{"$f":"D61-F61","v":0},0,{"$f":"SUM(G62:G66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subaward 1",null,null,null,0,0]
["Subaward 2",null,null,null,0,0]
["Subaward 3",null,null,null,0,0]
["Subaward 4",null,null,null,0,0]
["Subaward 5",null,null,null,0,0]
["Sub Indirects",null,{"$f":"IF(F2=\"No\",\"Y\",\"\")","v":""},{"$f":"SUM(D68:D72)","v":0},{"$f":"D67-F67","v":0},0,{"$f":"SUM(G68:G72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subaward 1",null,null,null,0,0]
["Subaward 2",null,null,null,0,0]
["Subaward 3",null,null,null,0,0]
["Subaward 4",null,null,null,0,0]
["Subaward 5",null,null,null,0,0]
["Subawards Base",null,null,{"$f":"SUM(D74:D78)","v":0},{"$f":"D73-F73","v":0},0,{"$f":"SUM(G74:G78)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subaward 1",null,null,{"$f":"IF(IF(SUM($A74:A74,D62,D68)>25000,25000-SUM($A74:A74),SUM(D62,D68))=0,\"\",IF(SUM($A74:A74,D62,D68)>25000,25000-SUM($A74:A74),SUM(D62,D68)))","v":""},{"$f":"IFERROR(D74-F74,\"\")","v":""},0]
["Subaward 2",null,null,{"$f":"IF(IF(SUM($A75:A75,D63,D69)>25000,25000-SUM($A75:A75),SUM(D63,D69))=0,\"\",IF(SUM($A75:A75,D63,D69)>25000,25000-SUM($A75:A75),SUM(D63,D69)))","v":""},{"$f":"IFERROR(D75-F75,\"\")","v":""},0]
["Subaward 3",null,null,{"$f":"IF(IF(SUM($A76:A76,D64,D70)>25000,25000-SUM($A76:A76),SUM(D64,D70))=0,\"\",IF(SUM($A76:A76,D64,D70)>25000,25000-SUM($A76:A76),SUM(D64,D70)))","v":""},"",0]
["Subaward 4",null,null,{"$f":"IF(IF(SUM($A77:A77,D65,D71)>25000,25000-SUM($A77:A77),SUM(D65,D71))=0,\"\",IF(SUM($A77:A77,D65,D71)>25000,25000-SUM($A77:A77),SUM(D65,D71)))","v":""},"",0]
["Subaward 5",null,null,{"$f":"IF(IF(SUM($A78:A78,D66,D72)>25000,25000-SUM($A78:A78),SUM(D66,D72))=0,\"\",IF(SUM($A78:A78,D66,D72)>25000,25000-SUM($A78:A78),SUM(D66,D72)))","v":""},"",0]

{"sheet":"NTP Budget","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3]]}
["Funding Proposal/Award Number"]
["PI"]
["Project Period"]
["Project Title"]
[]
[null,null,null,null,null,"WBSE RCC"]
[null,null,null,null,null,"WBSE RCC Name"]
[null,null,null,null,null,"Responsible PI Name"]
[null,null,null,null,null,"Responsible PI Person ID"]
[null,null,null,null,null,"Sponsored Program"]
[null,null,null,null,null,"WBSE Description"]
[]
["Budget Categories",null,null,"Total Budget","Remaining","Budgeted Total"]
["Notice To Proceed",null,null,null,{"$f":"D14-F14","v":0},{"$f":"SUM(G14:AD14)","v":0}]

{"sheet":"Control","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,4,5,7],[8,4,10,7],[13,4,15,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated: ","2025-03-12"]
[]
[]
[null,null,null,null,"Use this to transfer an existing budget to this template"]
[]
[]
[]
[]
[null,null,null,null,"Use this to create a blank budget worksheet for manual entry"]
[]
[]
[]
[]
[null,null,null,null,"Use this to create a Notice to Proceed Budget\n                          (SPS USE ONLY)"]

{"sheet":"Budget","index":3,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3],[41,1,41,2]]}
["Funding Proposal/Award Number"]
["PI"]
["Project Period"]
["Project Title"]
[]
[null,null,null,null,null,"Sponsored Program RCC"]
[null,null,null,null,null,"Sponsored Program RCC Name"]
[null,null,null,null,null,"Responsible PI Name"]
[null,null,null,null,null,"Responsible PI Person ID"]
[null,null,null,null,null,"Sponsored Program"]
[null,null,null,null,null,"Sponsored Program Description"]
[null,null,"Project F&A Rate",null,null,"F&A Rate"]
[null,null,"F&A Base",{"$f":"IF(D35=SUM(D26:D28,D29),IF($F$13=\"MTDC Base\",D36+D55-SUMIFS(D26:D42,$C26:$C42,\"Y\"),IF($F$13=\"TDC Base\",D36,IF($F$13=\"USDA Base\",(D36),IF($F$13=\"NIFA/AFRI\",(D36-SUM(D43,D49)),\"\")))),IF($F$13=\"MTDC Base\",D36+D55-SUMIFS(D26:D42,$C26:$C42,\"Y\"),IF($F$13=\"TDC Base\",D36,IF($F$13=\"USDA Base\",(D36),IF($F$13=\"NIFA/AFRI\",(D36-SUM(D43,D49)),\"\"))))+D49)","v":""},"BASE:",null,{"$f":"IF($F$13=\"MTDC Base\",G36+G55-SUMIFS(G26:G42,$C26:$C42,\"Y\"),IF($F$13=\"TDC Base\",G36,IF($F$13=\"USDA Base\",(G36),IF($F$13=\"NIFA/AFRI\",(G36-G29),\"\"))))","v":""},{"$f":"IF($F$13=\"MTDC Base\",H36+H55-SUMIFS(H26:H42,$C26:$C42,\"Y\"),IF($F$13=\"TDC Base\",H36,IF($F$13=\"USDA Base\",(H36),IF($F$13=\"NIFA/AFRI\",(H36-H29),\"\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
["Budget Categories",null,null,"Total Budget","Remaining","Budgeted Total"]
["Professional Salary",null,null,null,{"$f":"D16-F16","v":0},{"$f":"SUM(G16:AD16)","v":0}]
["Graduate Salaries",null,null,null,{"$f":"D17-F17","v":0},{"$f":"SUM(G17:AD17)","v":0}]
["Post Doc",null,null,null,0,0]
["Service Salaries",null,null,null,0,0]
["Clerical Salaries",null,null,null,0,0]
["Temporary Staff Salaries",null,null,null,0,0]
["Total Salaries",null,null,{"$f":"SUM(D16:D21)","v":0},0,0,{"$f":"SUM(G16:G21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Fringes",null,null,null,0,0]
["Other Direct Costs"]
["Cost Type","Description","Exclude From MTDC Base"]
[null,null,null,null,0,0]
["Recharge Rates Included in Base",null,null,null,{"$f":"D27-F27","v":0},{"$f":"SUM(G27:AD27)","v":0}]
["Recharge Rates Not Included in Base",null,"Y",null,{"$f":"D28-F28","v":0},{"$f":"SUM(G28:AD28)","v":0}]
["Total Subaward Costs (w/ Indirects)",null,"Y",{"$f":"SUM(D30:D34)","v":0},{"$f":"D29-F29","v":0},0,{"$f":"SUM(G30:G34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"\"Total \" & A44","v":"Total Subaward 1"},null,null,{"$f":"D44+D50","v":0},0,0]
[{"$f":"\"Total \" & A45","v":"Total Subaward 2"},null,null,{"$f":"D45+D51","v":0},0,{"$f":"SUM(G31:AD31)","v":0}]
["Total Subaward 3",null,null,0,0,0]
["Total Subaward 4",null,null,0,0,0]
["Total Subaward 5",null,null,0,0,0]
["Total Other Direct Costs",null,null,{"$f":"SUM(D26:D28,D29)","v":0},{"$f":"D35-F35","v":0},0,{"$f":"SUM(G26:G28,G29)","v":0},{"$f":"SUM(H26:H28,H29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Direct Costs (Salaries + Fringes + Other)",null,null,{"$f":"D22+D23+D35","v":0},0,0,{"$f":"G22+G23+G35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["IP Fee",null,null,null,{"$f":"D37-F37","v":0},{"$f":"SUM(G37:AD37)","v":0}]
["Unallocated Available",null,null,null,0,0]
["Unallocated Restricted",null,null,null,0,0]
["Purdue Indirects",null,null,{"$f":"IFERROR(D13*D12,0)","v":0},{"$f":"D40-F40","v":0},{"$f":"SUM(G40:AD40)","v":0},{"$f":"IFERROR(G13*G12,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs",null,null,{"$f":"SUM(D36,D40,D38:D39)","v":0},{"$f":"D41-F41","v":0},{"$f":"SUM(G41:AD41)","v":0},{"$f":"SUM(G36,G40,G38:G39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs w IP Fee",null,null,{"$f":"D41+D37","v":0},{"$f":"D42-F42","v":0},{"$f":"SUM(G42:AD42)","v":0},{"$f":"G41+G37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subawards",null,"Y",{"$f":"SUM(D44:D48)","v":0},{"$f":"D43-F43","v":0},0,{"$f":"SUM(G44:G48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subaward 1",null,null,null,0,0]
["Subaward 2",null,null,null,0,0]
["Subaward 3",null,null,null,0,0]
["Subaward 4",null,null,null,0,0]
["Subaward 5",null,null,null,0,0]
["Sub Indirects",null,{"$f":"IF(F2=\"No\",\"Y\",\"\")","v":""},{"$f":"SUM(D50:D54)","v":0},{"$f":"D49-F49","v":0},0,{"$f":"SUM(G50:G54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subaward 1",null,null,null,0,0]
["Subaward 2",null,null,null,0,0]
["Subaward 3",null,null,null,0,0]
["Subaward 4",null,null,null,0,0]
["Subaward 5",null,null,null,0,0]
["Subawards Base",null,null,{"$f":"SUM(D56:D60)","v":0},{"$f":"D55-F55","v":0},{"$f":"SUM(G55:AD55)","v":0},{"$f":"SUM(G56:G60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subaward 1",null,null,{"$f":"IF(IF(SUM($A56:A56,D44,D50)>25000,25000-SUM($A56:A56),SUM(D44,D50))=0,\"\",IF(SUM($A56:A56,D44,D50)>25000,25000-SUM($A56:A56),SUM(D44,D50)))","v":""},{"$f":"IFERROR(D56-F56,\"\")","v":""},0]
["Subaward 2",null,null,{"$f":"IF(IF(SUM($A57:A57,D45,D51)>25000,25000-SUM($A57:A57),SUM(D45,D51))=0,\"\",IF(SUM($A57:A57,D45,D51)>25000,25000-SUM($A57:A57),SUM(D45,D51)))","v":""},{"$f":"IFERROR(D57-F57,\"\")","v":""},0]
["Subaward 3",null,null,{"$f":"IF(IF(SUM($A58:A58,D46,D52)>25000,25000-SUM($A58:A58),SUM(D46,D52))=0,\"\",IF(SUM($A58:A58,D46,D52)>25000,25000-SUM($A58:A58),SUM(D46,D52)))","v":""},"",0]
["Subaward 4",null,null,{"$f":"IF(IF(SUM($A59:A59,D47,D53)>25000,25000-SUM($A59:A59),SUM(D47,D53))=0,\"\",IF(SUM($A59:A59,D47,D53)>25000,25000-SUM($A59:A59),SUM(D47,D53)))","v":""},"",0]
["Subaward 5",null,null,{"$f":"IF(IF(SUM($A60:A60,D48,D54)>25000,25000-SUM($A60:A60),SUM(D48,D54))=0,\"\",IF(SUM($A60:A60,D48,D54)>25000,25000-SUM($A60:A60),SUM(D48,D54)))","v":""},"",0]