{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["1 Year Worksheet","1 Year with Subcontract","2 Year Worksheet","3 Year Worksheet","4 Year Worksheet","5 Year Worksheet","Sample"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"1 Year Worksheet","index":0,"n_rows":60,"n_cols":9,"rows_kept":60,"merged":[[0,0,0,7],[1,1,1,6],[1,7,4,7],[2,1,2,6],[3,1,3,6],[4,3,4,6],[5,0,5,7],[6,0,6,4],[6,5,6,6],[6,7,7,7],[7,0,7,6],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,4],[16,0,16,4],[16,5,16,6],[17,0,17,6],[18,0,18,4],[18,5,18,6],[19,0,19,4],[19,5,19,6],[20,0,20,4],[20,5,20,6],[21,0,21,4],[21,5,21,6],[22,0,22,4],[22,5,22,6],[23,0,23,6],[24,0,24,4],[24,5,24,6],[25,0,25,4],[25,5,25,6],[26,0,26,4],[26,5,26,6],[27,0,27,6],[28,0,28,4],[28,5,28,6],[29,0,29,4],[29,5,29,6],[30,0,30,4],[30,5,30,6],[31,0,31,4],[31,5,31,6],[32,0,32,7],[33,0,33,4],[33,5,33,6],[34,0,34,4],[34,5,34,6],[35,0,35,4],[35,5,35,6],[36,0,36,4],[36,5,36,6],[37,0,37,4],[37,5,37,6],[38,0,38,4],[38,5,38,6],[39,0,39,7],[40,0,40,4],[40,5,40,6],[41,0,41,4],[41,5,41,6],[42,0,42,4],[42,5,42,6],[43,0,43,4],[43,5,43,6],[44,0,44,4],[44,5,44,6],[45,0,45,3],[45,5,45,6],[46,0,46,4],[46,5,46,6],[48,0,48,6],[50,0,50,6],[51,0,51,7],[53,0,56,7]]}
["Southern Illinois University School of Medicine"]
["PI:"]
["App Title:"]
["Agency:"]
[null,null,"Deadline:"]
[]
["PROJECT DATES: ",{"$nulls":4},"Year 1 ",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%)."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%"]
[{"$nulls":5},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F10:G10)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"F14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"IF(F15>0,366,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(G10:G15)","v":{"v":0,"d":"$0"}}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F16+G16","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H10:H15)","v":{"v":0,"d":"$0"}},{"$f":"F16+G16","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":7},{"$f":"F19","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":6},{"$f":"SUM(H19:H22)","v":{"v":0,"d":"$0"}}]
["Equipment"]
[{"$nulls":7},{"$f":"F25","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F26","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":6},{"$f":"SUM(H25:H26)","v":{"v":0,"d":"$0"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
[{"$nulls":7},{"$f":"F29","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F30","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F31","v":{"v":0,"d":"$0"}}]
["Subtotal Travel",{"$nulls":6},{"$f":"SUM(H29:H31)","v":{"v":0,"d":"$0"}}]
["Contractual - for example: core facility costs, publication"]
[{"$nulls":7},{"$f":"F34","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F35","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"$f":"F37","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F38","v":{"v":0,"d":"$0"}}]
["Subtotal Contractual",{"$nulls":6},{"$f":"SUM(H34:H38)","v":{"v":0,"d":"$0"}}]
["Other Costs"]
[{"$nulls":7},{"$f":"F41","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F42","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":6},{"$f":"SUM(H41:H42)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":6},{"$f":"H17+H23+H27+H32+H39+H43","v":{"v":0,"d":"$0"}}]
["Modified Total Direct Costs (MTDC)*",{"$nulls":6},{"$f":"H17+H23+H32+H39+H43","v":{"v":0,"d":"$0"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},null,null,{"$f":"H45*E46","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":6},{"$f":"H44+H46","v":{"v":0,"d":"$0"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]

{"sheet":"1 Year with Subcontract","index":1,"n_rows":72,"n_cols":8,"rows_kept":72,"merged":[[0,0,0,7],[1,1,1,6],[1,7,4,7],[2,1,2,6],[3,1,3,6],[4,3,4,6],[5,0,5,7],[6,0,6,4],[6,5,6,6],[6,7,7,7],[7,0,7,6],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,4],[16,0,16,4],[16,5,16,6],[17,0,17,6],[18,0,18,4],[18,5,18,6],[19,0,19,4],[19,5,19,6],[20,0,20,4],[20,5,20,6],[21,0,21,4],[21,5,21,6],[22,0,22,4],[22,5,22,6],[23,0,23,4],[23,5,23,6],[24,0,24,6],[25,0,25,4],[25,5,25,6],[26,0,26,4],[26,5,26,6],[27,0,27,4],[27,5,27,6],[28,0,28,6],[29,0,29,4],[29,5,29,6],[30,0,30,4],[30,5,30,6],[31,0,31,4],[31,5,31,6],[32,0,32,4],[32,5,32,6],[33,0,33,6],[34,0,34,4],[34,5,34,6],[35,0,35,4],[35,5,35,6],[36,0,36,4],[36,5,36,6],[37,0,37,4],[37,5,37,6],[38,0,38,4],[38,5,38,6],[39,0,39,7],[40,0,40,1],[40,2,40,4],[40,5,40,6],[41,0,43,1],[41,2,41,4],[41,5,41,6],[42,2,42,4],[42,5,42,6],[43,2,43,4],[43,5,43,6],[44,0,44,1],[44,2,44,4],[44,5,44,6],[45,0,47,1],[45,2,45,4],[45,5,45,6],[46,2,46,4],[46,5,46,6],[47,2,47,4],[47,5,47,6],[48,0,48,4],[48,5,48,6],[49,0,49,4],[49,5,49,6],[50,0,50,7],[51,0,51,4],[51,5,51,6],[52,0,52,4],[52,5,52,6],[53,0,53,4],[53,5,53,6],[54,0,54,4],[54,5,54,6],[55,0,55,4],[55,5,55,6],[56,0,56,4],[56,5,56,6],[57,0,57,3],[57,5,57,6],[58,0,58,4],[58,5,58,6],[60,0,60,6],[62,0,62,6],[63,0,63,7],[65,0,68,7]]}
["Southern Illinois University School of Medicine"]
["PI:"]
["Title:"]
["Agency:"]
[null,null,"Deadline:"]
[]
["PROJECT DATES: ",{"$nulls":4},"Year 1 ",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%)."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%"]
[{"$nulls":5},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F10:G10)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"F14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"IF(F15>0,366,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(G10:G15)","v":{"v":0,"d":"$0"}}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F16+G16","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H10:H15)","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":7},{"$f":"F19","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":6},{"$f":"SUM(H19:H23)","v":{"v":0,"d":"$0"}}]
["Equipment"]
[{"$nulls":7},{"$f":"F26","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F27","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":6},{"$f":"SUM(H26:H27)","v":{"v":0,"d":"$0"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
[{"$nulls":7},{"$f":"F30","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F31","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F32","v":{"v":0,"d":"$0"}}]
["Subtotal Travel",{"$nulls":6},{"$f":"SUM(H30:H32)","v":{"v":0,"d":"$0"}}]
["Contractual - for example: core facility costs, publication"]
[{"$nulls":7},{"$f":"F35","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F36","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F37","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F38","v":{"v":0,"d":"$0"}}]
["Subtotal Contractual",{"$nulls":6},{"$f":"SUM(H35:H38)","v":{"v":0,"d":"$0"}}]
["Consortium/Subcontract Costs - List each subcontractor separately."]
["Consortia 1:",null,"Consortia 1 Direct Costs",{"$nulls":4},{"$f":"SUM(F41:G41)","v":{"v":0,"d":"$0"}}]
["Organization",null,"Consortia 1 Indirect Costs",{"$nulls":4},{"$f":"SUM(F42:G42)","v":{"v":0,"d":"$0"}}]
[null,null,"Consortia 1 Total",null,null,{"$f":"SUM(F41:G42)","v":{"v":0,"d":"$0"}},null,{"$f":"H41+H42","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F43>25000,25000,F43)","v":{"v":0,"d":"$0"}},null,{"$f":"F44","v":{"v":0,"d":"$0"}}]
["Consortia 2:",null,"Consortia 2 Direct Costs",{"$nulls":4},{"$f":"SUM(F45:G45)","v":{"v":0,"d":"$0"}}]
["Organization",null,"Consortia 2 Indirect Costs",{"$nulls":4},{"$f":"SUM(F46:G46)","v":{"v":0,"d":"$0"}}]
[null,null,"Consortia 2 Total",null,null,{"$f":"SUM(F45:G46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H45:H46)","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F47>25000,25000,F47)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H45:H46)","v":{"v":0,"d":"$0"}}]
["Subtotal Consortium/Subcontract",{"$nulls":4},{"$f":"F43+F47","v":{"v":0,"d":"$0"}},null,{"$f":"H43+H47","v":{"v":0,"d":"$0"}}]
["MTDC Calculation",{"$nulls":4},{"$f":"F44+F48","v":{"v":0,"d":"$0"}},null,{"$f":"H44+H48","v":{"v":0,"d":"$0"}}]
["Other Costs"]
[{"$nulls":7},{"$f":"F52","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"F53","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":6},{"$f":"SUM(H52:H53)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":6},{"$f":"H17+H24+H28+H33+H39+H49+H54","v":{"v":0,"d":"$0"}}]
["Total Direct Costs less Consortium F&A",{"$nulls":6},{"$f":"H17+H24+H28+H33+H39+H41+H45+H54","v":{"v":0,"d":"$0"}}]
["Modified Total Direct Costs (MTDC)*",{"$nulls":6},{"$f":"H17+H24+H33+H39+H50+H54","v":{"v":0,"d":"$0"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},null,null,{"$f":"H57*E58","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":6},{"$f":"H55+H58","v":{"v":0,"d":"$0"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]

{"sheet":"2 Year Worksheet","index":2,"n_rows":76,"n_cols":11,"rows_kept":76,"merged":[[0,0,0,9],[1,1,1,7],[1,8,4,9],[2,1,2,7],[3,1,3,7],[4,3,4,6],[5,0,5,9],[6,0,6,4],[6,5,6,6],[6,7,6,8],[6,9,7,9],[7,0,7,8],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,4],[16,0,16,4],[16,5,16,6],[16,7,16,8],[17,0,17,6],[18,0,18,4],[18,5,18,6],[18,7,18,8],[19,0,19,4],[19,5,19,6],[19,7,19,8],[20,0,20,4],[20,5,20,6],[20,7,20,8],[21,0,21,4],[21,5,21,6],[21,7,21,8],[22,0,22,4],[22,5,22,6],[22,7,22,8],[23,0,23,4],[23,5,23,6],[23,7,23,8],[24,0,24,6],[25,0,25,4],[25,5,25,6],[25,7,25,8],[26,0,26,4],[26,5,26,6],[26,7,26,8],[27,0,27,4],[27,5,27,6],[27,7,27,8],[28,0,28,6],[29,0,29,4],[29,5,29,6],[29,7,29,8],[30,0,30,4],[30,5,30,6],[30,7,30,8],[31,0,31,4],[31,5,31,6],[31,7,31,8],[32,0,32,4],[32,5,32,6],[32,7,32,8],[33,0,33,6],[34,0,34,4],[34,5,34,6],[34,7,34,8],[35,0,35,4],[35,5,35,6],[35,7,35,8],[36,0,36,4],[36,5,36,6],[36,7,36,8],[37,0,37,4],[37,5,37,6],[37,7,37,8],[38,0,38,4],[38,5,38,6],[38,7,38,8],[39,0,39,9],[40,0,40,1],[40,2,40,4],[40,5,40,6],[40,7,40,8],[41,0,43,1],[41,2,41,4],[41,5,41,6],[41,7,41,8],[42,2,42,4],[42,5,42,6],[42,7,42,8],[43,2,43,4],[43,5,43,6],[43,7,43,8],[44,0,44,1],[44,2,44,4],[44,5,44,6],[44,7,44,8],[45,0,47,1],[45,2,45,4],[45,5,45,6],[45,7,45,8],[46,2,46,4],[46,5,46,6],[46,7,46,8],[47,2,47,4],[47,5,47,6],[47,7,47,8],[48,0,48,1],[48,2,48,4],[48,5,48,6],[48,7,48,8],[49,0,51,1],[49,2,49,4],[49,5,49,6],[49,7,49,8],[50,2,50,4],[50,5,50,6],[50,7,50,8],[51,2,51,4],[51,5,51,6],[51,7,51,8],[52,0,52,4],[52,5,52,6],[52,7,52,8],[53,0,53,4],[53,5,53,6],[53,7,53,8],[54,0,54,9],[55,0,55,4],[55,5,55,6],[55,7,55,8],[56,0,56,4],[56,5,56,6],[56,7,56,8],[57,0,57,4],[57,5,57,6],[57,7,57,8],[58,0,58,4],[58,5,58,6],[58,7,58,8],[59,1,59,4],[59,5,59,6],[59,7,59,8],[60,0,60,4],[60,5,60,6],[60,7,60,8],[61,0,61,3],[61,5,61,6],[61,7,61,8],[62,0,62,4],[62,5,62,6],[62,7,62,8],[64,0,64,6],[66,0,66,6],[67,0,67,7],[69,0,72,7]]}
["Southern Illinois University School of Medicine"]
["PI:"]
["App Title:"]
["Agency:"]
[null,null,"Deadline:"]
[]
[{"$nulls":5},"Year 1 ",null,"Year 2",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%)."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%"]
[{"$nulls":5},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03>221899.99,(221900*D10),F10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"H10*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F10:I10)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H11*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F11:I11)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"F14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"IF(F15>0,366,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,376,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(G10:G15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H10:H15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I10:I15)","v":{"v":0,"d":"$0"}}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F16+G16","v":{"v":0,"d":"$0"}},null,{"$f":"H16+I16","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J10:J15)","v":{"v":0,"d":"$0"}},{"$f":"F17+H17","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":9},{"$f":"SUM(F19:I19)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"v":0,"d":"$0"}]
[{"$nulls":9},{"v":0,"d":"$0"}]
[{"$nulls":9},{"v":0,"d":"$0"}]
[{"$nulls":9},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":4},{"$f":"SUM(F19:G23)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H19:I23)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F24:I24)","v":{"v":0,"d":"$0"}},{"$f":"SUM(J19:J23)","v":{"v":0,"d":"$0"}}]
["Equipment"]
[{"$nulls":9},{"$f":"SUM(F26:I26)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F27:I27)","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":4},{"$f":"SUM(F26:G27)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H26:I27)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J26:J27)","v":{"v":0,"d":"$0"}},{"$f":"F28+H28","v":{"v":0,"d":"$0"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
[{"$nulls":9},{"$f":"SUM(F30:I30)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F31:I31)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F32:I32)","v":{"v":0,"d":"$0"}}]
["Subtotal Travel",{"$nulls":4},{"$f":"SUM(F30:G32)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H30:I32)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J30:J32)","v":{"v":0,"d":"$0"}},{"$f":"F33+H33","v":{"v":0,"d":"$0"}}]
["Contractual - for example: core facility costs, publication"]
[{"$nulls":9},{"$f":"SUM(F35:I35)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F36:I36)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F37:I37)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F38:I38)","v":{"v":0,"d":"$0"}}]
["Subtotal Contractual",{"$nulls":4},{"$f":"SUM(F34:G38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H34:I38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F39:I39)","v":{"v":0,"d":"$0"}},{"$f":"F39+H39","v":{"v":0,"d":"$0"}}]
["Consortium/Subcontract Costs - List each subcontractor separately."]
["Consortia 1:",null,"Consortia 1 Direct Costs",{"$nulls":6},{"$f":"SUM(F41:I41)","v":{"v":0,"d":"$0"}}]
["Organization",null,"Consortia 1 Indirect Costs",{"$nulls":6},{"v":0,"d":"$0"}]
[null,null,"Consortia 1 Total",null,null,{"$f":"SUM(F41:G42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H41:I42)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"J41+J42","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F43>25000,25000,F43)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F43+H43<25000,H43,IF((25000-F43)<0,0,25000-F43))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Consortia 2:",null,"Consortia 2 Direct Costs",{"$nulls":6},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 2 Indirect Costs",{"$nulls":6},{"v":0,"d":"$0"}]
[null,null,"Consortia 2 Total",null,null,{"$f":"SUM(F45:G46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H45:I46)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"J46+J45","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F47>25000,25000,F47)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F47+H47<25000,H47,IF((25000-F47)<0,0,25000-F47))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Consortia 3:",null,"Consortia 3 Direct Costs",{"$nulls":6},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 3 Indirect Costs",{"$nulls":6},{"v":0,"d":"$0"}]
[null,null,"Consortia 3 Total",null,null,{"$f":"SUM(F49:G50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H49:I50)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"J49+J50","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F51>25000,25000,F51)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F51+H51<25000,H51,IF((25000-F51)<0,0,25000-F51))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Subtotal Consortium/Subcontract",{"$nulls":4},{"$f":"F43+F47+F51","v":{"v":0,"d":"$0"}},null,{"$f":"H43+H47+H51","v":{"v":0,"d":"$0"}},null,{"$f":"J43+J47+J51","v":{"v":0,"d":"$0"}},{"$f":"SUM(B53:I53)","v":{"v":0,"d":"$0"}}]
["MTDC Calculation",{"$nulls":4},{"$f":"F44+F48+F52","v":{"v":0,"d":"$0"}},null,{"$f":"H44+H48+H52","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F54:I54)","v":{"v":0,"d":"$0"}},{"$f":"J44+J48+J52","v":{"v":0,"d":"$0"}}]
["Other Costs"]
[{"$nulls":9},{"$f":"SUM(F56:I56)","v":{"v":0,"d":"$0"}}]
[{"$nulls":9},{"$f":"SUM(F57:I57)","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":4},{"$f":"SUM(F56:G57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H56:I57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J56:J57)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F58:I58)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":4},{"$f":"F17+F24+F28+F33+F39+F58+F53","v":{"v":0,"d":"$0"}},null,{"$f":"H17+H24+H28+H33+H39+H58+H53","v":{"v":0,"d":"$0"}},null,{"$f":"F59+H59","v":{"v":0,"d":"$0"}},{"$f":"J58+J39+J33+J28+J24+J17+J53","v":{"v":0,"d":"$0"}}]
[null,"Total Direct Costs less Consortium IDC²",{"$nulls":3},{"$f":"F59-F46-F42-F50","v":{"v":0,"d":"$0"}},null,{"$f":"H59-H46-H42-H50","v":{"v":0,"d":"$0"}},null,{"$f":"J59-J42-J46-J50","v":{"v":0,"d":"$0"}},{"$f":"SUM(F60:I60)","v":{"v":0,"d":"$0"}}]
["Modified Total Direct Costs (MTDC)",{"$nulls":4},{"$f":"F58+F54+F39+F33+F24+F17","v":{"v":0,"d":"$0"}},null,{"$f":"H58+H54+H39+H33+H24+H17","v":{"v":0,"d":"$0"}},null,{"$f":"J58+J54+J39+J33+J24+J17","v":{"v":0,"d":"$0"}},{"$f":"SUM(F61:I61)","v":{"v":0,"d":"$0"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},{"$f":"F61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"H61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"J61*E62","v":{"v":0,"d":"$0"}},{"$f":"SUM(F62:I62)","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":4},{"$f":"F59+F62","v":{"v":0,"d":"$0"}},null,{"$f":"H59+H62","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F63:I63)","v":{"v":0,"d":"$0"}},{"$f":"J59+J62","v":{"v":0,"d":"$0"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]

{"sheet":"3 Year Worksheet","index":3,"n_rows":76,"n_cols":13,"rows_kept":76,"merged":[[0,0,0,11],[1,1,1,9],[1,10,4,11],[2,1,2,9],[3,1,3,9],[4,3,4,6],[5,0,5,11],[6,0,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,7,11],[7,0,7,8],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,4],[16,0,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[17,0,17,6],[18,0,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[19,0,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[20,0,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,0,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,0,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,0,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,0,24,6],[25,0,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[26,0,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,0,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,0,28,6],[29,0,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,0,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,0,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[33,0,33,6],[34,0,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[35,0,35,4],[35,5,35,6],[35,7,35,8],[35,9,35,10],[36,0,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[37,0,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[38,0,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[39,0,39,11],[40,0,40,1],[40,2,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[41,0,43,1],[41,2,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[44,0,44,1],[44,2,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,0,47,1],[45,2,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[46,2,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[48,0,48,1],[48,2,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[49,0,51,1],[49,2,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[52,0,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,0,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[54,0,54,11],[55,0,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[56,0,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[57,0,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[58,0,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[59,1,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[60,0,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[61,0,61,3],[61,5,61,6],[61,7,61,8],[61,9,61,10],[62,0,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[64,0,64,6],[66,0,66,6],[67,0,67,7],[69,0,72,7]]}
["Southern Illinois University School of Medicine"]
["PI:"]
["App Title:"]
["Agency:"]
[null,null,"Deadline:"]
[]
[{"$nulls":5},"Year 1 ",null,"Year 2",null,"Year 3",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%)."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%"]
[{"$nulls":5},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03>221899.99,(221900*D10),F10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"H10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF((E10*1.03*1.03)>221899.99,(221900*D10),H10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"J10*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F10:K10)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J11*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F11:K11)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"F14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"IF(F15>0,366,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,376,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(H15>0,386,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F15)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F16+G16","v":{"v":0,"d":"$0"}},null,{"$f":"H16+I16","v":{"v":0,"d":"$0"}},null,{"$f":"J16+K16","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L10:L15)","v":{"v":0,"d":"$0"}},{"$f":"F17+H17+J17","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":11},{"$f":"SUM(F19:K19)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"$f":"SUM(F20:K20)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"v":0,"d":"$0"}]
[{"$nulls":11},{"v":0,"d":"$0"}]
[{"$nulls":11},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":4},{"$f":"SUM(F19:G23)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H19:I23)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J19:K23)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F24:K24)","v":{"v":0,"d":"$0"}},{"$f":"SUM(L19:L23)","v":{"v":0,"d":"$0"}}]
["Equipment"]
[{"$nulls":11},{"$f":"SUM(F26:K26)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"$f":"SUM(F27:K27)","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":4},{"$f":"SUM(F26:G27)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H26:I27)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J26:K27)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L26:L27)","v":{"v":0,"d":"$0"}},{"$f":"F28+H28+J28","v":{"v":0,"d":"$0"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
[{"$nulls":11},{"$f":"SUM(F30:K30)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"$f":"SUM(F31:K31)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"v":0,"d":"$0"}]
["Subtotal Travel",{"$nulls":4},{"$f":"SUM(F30:G32)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H30:I32)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J30:K32)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L30:L32)","v":{"v":0,"d":"$0"}},{"$f":"F33+H33+J33","v":{"v":0,"d":"$0"}}]
["Contractual - for example: core facility costs, publication"]
[{"$nulls":11},{"$f":"SUM(F35:K35)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"$f":"SUM(F36:K36)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"v":0,"d":"$0"}]
[{"$nulls":11},{"v":0,"d":"$0"}]
["Subtotal Contractual",{"$nulls":4},{"$f":"SUM(F35:G38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H35:I38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J35:K38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L35:L38)","v":{"v":0,"d":"$0"}},{"$f":"F39+H39+J39","v":{"v":0,"d":"$0"}}]
["Consortium/Subcontract Costs - List each subcontractor separately."]
["Consortia 1:",null,"Consortia 1 Direct Costs",{"$nulls":8},{"$f":"SUM(F41:K41)","v":{"v":0,"d":"$0"}}]
["Organization",null,"Consortia 1 Indirect Costs",{"$nulls":8},{"v":0,"d":"$0"}]
[null,null,"Consortia 1 Total",null,null,{"$f":"SUM(F41:G42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H41:I42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J41:K42)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"L41+L42","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F43>25000,25000,F43)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F43+H43<25000,H43,IF((25000-F43)<0,0,25000-F43))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F43+H43+J43<25000,J43,IF((25000-(F43+H43))<0,0,25000-(F43+H43)))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Consortia 2:",null,"Consortia 2 Direct Costs",{"$nulls":8},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 2 Indirect Costs",{"$nulls":8},{"v":0,"d":"$0"}]
[null,null,"Consortia 2 Total",null,null,{"$f":"SUM(F45:G46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H45:I46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J45:K46)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"L46+L45","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F47>25000,25000,F47)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F47+H47<25000,H47,IF((25000-F47)<0,0,25000-F47))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F47+H47+J47<25000,J47,IF((25000-(F47+H47))<0,0,25000-(F47+H47)))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Consortia 3:",null,"Consortia 3 Direct Costs",{"$nulls":8},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 3 Indirect Costs",{"$nulls":8},{"v":0,"d":"$0"}]
[null,null,"Consortia 3 Total",null,null,{"$f":"SUM(F49:G50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H49:I50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J49:K50)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"L49+L50","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F51>25000,25000,F51)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F51+H51<25000,H51,IF((25000-F51)<0,0,25000-F51))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F51+H51+J51<25000,J51,IF((25000-(F51+H51))<0,0,25000-(F51+H51)))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Subtotal Consortium/Subcontract",{"$nulls":4},{"$f":"F43+F47+F51","v":{"v":0,"d":"$0"}},null,{"$f":"H43+H47+H51","v":{"v":0,"d":"$0"}},null,{"$f":"J43+J47+J51","v":{"v":0,"d":"$0"}},null,{"$f":"L43+L47+L51","v":{"v":0,"d":"$0"}},{"$f":"SUM(F53:K53)","v":{"v":0,"d":"$0"}}]
["MTDC Calculation",{"$nulls":4},{"$f":"F44+F48+F52","v":{"v":0,"d":"$0"}},null,{"$f":"H44+H48+H52","v":{"v":0,"d":"$0"}},null,{"$f":"J44+J48+J52","v":{"v":0,"d":"$0"}},null,{"$f":"F54+H54+J54","v":{"v":0,"d":"$0"}},{"$f":"L44+L48+L52","v":{"v":0,"d":"$0"}}]
["Other Costs"]
[{"$nulls":11},{"$f":"SUM(F56:K56)","v":{"v":0,"d":"$0"}}]
[{"$nulls":11},{"$f":"SUM(F57:K57)","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":4},{"$f":"SUM(F56:G57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H56:I57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J56:K57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L56:L57)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F58:K58)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":4},{"$f":"F17+F24+F28+F33+F39+F58+F53","v":{"v":0,"d":"$0"}},null,{"$f":"H17+H24+H28+H33+H39+H58+H53","v":{"v":0,"d":"$0"}},null,{"$f":"J17+J24+J28+J33+J39+J58+J53","v":{"v":0,"d":"$0"}},null,{"$f":"F59+H59+J59","v":{"v":0,"d":"$0"}},{"$f":"L58+L39+L33+L28+L24+L17+L53","v":{"v":0,"d":"$0"}}]
[null,"Total Direct Costs less Consortium IDC²",{"$nulls":3},{"$f":"F59-F46-F42-F50","v":{"v":0,"d":"$0"}},null,{"$f":"H59-H46-H42-H50","v":{"v":0,"d":"$0"}},null,{"$f":"J59-J46-J42-J50","v":{"v":0,"d":"$0"}},null,{"$f":"L59-L42-L46-L50","v":{"v":0,"d":"$0"}},{"$f":"SUM(F60:K60)","v":{"v":0,"d":"$0"}}]
["Modified Total Direct Costs (MTDC)",{"$nulls":4},{"$f":"F58+F54+F39+F33+F24+F17","v":{"v":0,"d":"$0"}},null,{"$f":"H58+H54+H39+H33+H24+H17","v":{"v":0,"d":"$0"}},null,{"$f":"J58+J54+J39+J33+J24+J17","v":{"v":0,"d":"$0"}},null,{"$f":"L58+L54+L39+L33+L24+L17","v":{"v":0,"d":"$0"}},{"$f":"SUM(F61:K61)","v":{"v":0,"d":"$0"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},{"$f":"F61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"H61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"J61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"L61*E62","v":{"v":0,"d":"$0"}},{"$f":"SUM(F62:K62)","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":4},{"$f":"F59+F62","v":{"v":0,"d":"$0"}},null,{"$f":"H59+H62","v":{"v":0,"d":"$0"}},null,{"$f":"J59+J62","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F63:K63)","v":{"v":0,"d":"$0"}},{"$f":"L59+L62","v":{"v":0,"d":"$0"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]

{"sheet":"4 Year Worksheet","index":4,"n_rows":76,"n_cols":15,"rows_kept":76,"merged":[[0,0,0,13],[1,0,4,1],[1,3,1,12],[1,13,4,13],[2,3,2,12],[3,3,3,12],[4,2,4,5],[4,7,4,9],[4,10,4,11],[5,0,5,13],[6,0,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,7,13],[7,0,7,12],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,4],[16,0,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[17,0,17,13],[18,0,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[19,0,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[20,0,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[21,0,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[22,0,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[23,0,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[24,0,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,0,25,13],[26,0,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[27,0,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[28,0,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,0,29,13],[30,0,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[31,0,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[32,0,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,0,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,13],[35,0,35,4],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[36,0,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[37,0,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[38,0,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[39,0,39,13],[40,0,40,1],[40,2,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[41,0,43,1],[41,2,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[44,0,44,1],[44,2,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[45,0,47,1],[45,2,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[46,2,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[48,0,48,1],[48,2,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[49,0,51,1],[49,2,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[52,0,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[53,0,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[54,0,54,13],[55,0,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[56,0,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[57,0,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[58,0,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[59,0,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[60,0,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[61,0,61,3],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[62,0,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[64,0,64,6],[66,0,66,6],[67,0,67,7],[69,0,72,7]]}
["Southern Illinois University School of Medicine"]
[null,null,"PI:"]
[null,null,"App Title:"]
[null,null,"Agency:"]
[{"$nulls":6},"Deadline:"]
[]
[{"$nulls":5},"Year 1 ",null,"Year 2",null,"Year 3",null,"Year 4",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%)."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%"]
[{"$nulls":5},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03>221899.99,(221900*D10),F10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"H10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF((E10*1.03*1.03)>221899.99,(221900*D10),H10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"J10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03*1.03*1.03>221899.99,(221900*D10),J10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"L10*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F10:M10)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L11*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F11:M11)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"F14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"IF(F15>0,366,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,376,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,386,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,396,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F15)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F16+G16","v":{"v":0,"d":"$0"}},null,{"$f":"H16+I16","v":{"v":0,"d":"$0"}},null,{"$f":"J16+K16","v":{"v":0,"d":"$0"}},null,{"$f":"L16+M16","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N10:N15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F17:M17)","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":13},{"$f":"SUM(F19:M19)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"v":0,"d":"$0"}]
[{"$nulls":13},{"v":0,"d":"$0"}]
[{"$nulls":13},{"v":0,"d":"$0"}]
[{"$nulls":13},{"v":0,"d":"$0"}]
[{"$nulls":13},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":4},{"$f":"SUM(F19:G24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H19:I24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J19:K24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L19:M24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N19:N24)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F25:M25)","v":{"v":0,"d":"$0"}}]
["Equipment"]
[{"$nulls":13},{"$f":"SUM(F27:M27)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"$f":"SUM(F28:M28)","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":4},{"$f":"SUM(F27:G28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H27:I28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J27:K28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L27:M28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N27:N28)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F29:M29)","v":{"v":0,"d":"$0"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
[{"$nulls":13},{"$f":"SUM(F31:M31)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"$f":"SUM(F32:M32)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"$f":"SUM(F33:M33)","v":{"v":0,"d":"$0"}}]
["Subtotal Travel",{"$nulls":4},{"$f":"SUM(F31:G33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H31:I33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J31:K33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L31:M33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N31:N33)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F34:M34)","v":{"v":0,"d":"$0"}}]
["Contractual - for example: core facility costs, publication"]
[{"$nulls":13},{"$f":"SUM(F36:M36)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"$f":"SUM(F37:M37)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"$f":"SUM(F38:M38)","v":{"v":0,"d":"$0"}}]
["Subtotal Contractual",{"$nulls":4},{"$f":"SUM(F36:G38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H36:I38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J36:K38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L36:M38)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N36:N38)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F39:M39)","v":{"v":0,"d":"$0"}}]
["Consortium/Subcontract Costs - List each subcontractor separately."]
["Consortia 1:",null,"Consortia 1 Direct Costs",{"$nulls":10},{"$f":"SUM(F41:M41)","v":{"v":0,"d":"$0"}}]
["Organization",null,"Consortia 1 Indirect Costs",{"$nulls":10},{"v":0,"d":"$0"}]
[null,null,"Consortia 1 Total",null,null,{"$f":"SUM(F41:G42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H41:I42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J41:K42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L41:M42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F43:M43)","v":{"v":0,"d":"$0"}},{"$f":"N41+N42","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F43>25000,25000,F43)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F43+H43<25000,H43,IF((25000-F43)<0,0,25000-F43))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F43+H43+J43<25000,J43,IF((25000-(F43+H43))<0,0,25000-(F43+H43)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F43+H43+J43+L43<25000,L43,IF((25000-(F43+H43+J43))<0,0,25000-(F43+H43+J43)))","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F44:M44)","v":{"v":0,"d":"$0"}}]
["Consortia 2:",null,"Consortia 2 Direct Costs",{"$nulls":10},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 2 Indirect Costs",{"$nulls":10},{"v":0,"d":"$0"}]
[null,null,"Consortia 2 Total",null,null,{"$f":"SUM(F45:G46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H45:I46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J45:K46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L45:M46)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F47:M47)","v":{"v":0,"d":"$0"}},{"$f":"N46+N45","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F47>25000,25000,F47)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F47+H47<25000,H47,IF((25000-F47)<0,0,25000-F47))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F47+H47+J47<25000,J47,IF((25000-(F47+H47))<0,0,25000-(F47+H47)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F47+H47+J47+L47<25000,L47,IF((25000-(F47+H47+J47))<0,0,25000-(F47+H47+J47)))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Consortia 3:",null,"Consortia 3 Direct Costs",{"$nulls":10},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 3 Indirect Costs",{"$nulls":10},{"v":0,"d":"$0"}]
[null,null,"Consortia 3 Total",null,null,{"$f":"SUM(F49:G50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H49:I50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J49:K50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L49:M50)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F51:M51)","v":{"v":0,"d":"$0"}},{"$f":"N49+N50","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F51>25000,25000,F51)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F51+H51<25000,H51,IF((25000-F51)<0,0,25000-F51))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F51+H51+J51<25000,J51,IF((25000-(F51+H51))<0,0,25000-(F51+H51)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F51+H51+J51+L51<25000,L51,IF((25000-(F51+H51+J51))<0,0,25000-(F51+H51+J51)))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Subtotal Consortium/Subcontract",{"$nulls":4},{"$f":"F43+F47+F51","v":{"v":0,"d":"$0"}},null,{"$f":"H43+H47+H51","v":{"v":0,"d":"$0"}},null,{"$f":"J43+J47+J51","v":{"v":0,"d":"$0"}},null,{"$f":"L43+L47+L51","v":{"v":0,"d":"$0"}},null,{"$f":"N43+N47+N51","v":{"v":0,"d":"$0"}},{"$f":"SUM(F53:M53)","v":{"v":0,"d":"$0"}}]
["MTDC Calculation",{"$nulls":4},{"$f":"F44+F48+F52","v":{"v":0,"d":"$0"}},null,{"$f":"H44+H48+H52","v":{"v":0,"d":"$0"}},null,{"$f":"J44+J48+J52","v":{"v":0,"d":"$0"}},null,{"$f":"L44+L48+L52","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F54:M54)","v":{"v":0,"d":"$0"}},{"$f":"N44+N48+N52","v":{"v":0,"d":"$0"}}]
["Other Costs"]
[{"$nulls":13},{"$f":"SUM(F56:M56)","v":{"v":0,"d":"$0"}}]
[{"$nulls":13},{"$f":"SUM(F57:M57)","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":4},{"$f":"SUM(F56:G57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H56:I57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J56:K57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L56:M57)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N56:N57)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F58:M58)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":4},{"$f":"F17+F25+F29+F34+F39+F53+F58","v":{"v":0,"d":"$0"}},null,{"$f":"H17+H25+H29+H34+H39+H53+H58","v":{"v":0,"d":"$0"}},null,{"$f":"J17+J25+J29+J34+J39+J53+J58","v":{"v":0,"d":"$0"}},null,{"$f":"L17+L25+L29+L34+L39+L53+L58","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F59:M59)","v":{"v":0,"d":"$0"}},{"$f":"N17+N25+N29+N34+N39+N53+N58","v":{"v":0,"d":"$0"}}]
["Total Direct Costs less Consortium F&A",{"$nulls":4},{"$f":"F59-F42-F46-F50","v":{"v":0,"d":"$0"}},null,{"$f":"H59-H42-H46-H50","v":{"v":0,"d":"$0"}},null,{"$f":"J59-J42-J46-J50","v":{"v":0,"d":"$0"}},null,{"$f":"L59-L42-L46-L50","v":{"v":0,"d":"$0"}},null,{"$f":"N59-N42-N46-N50","v":{"v":0,"d":"$0"}},{"$f":"SUM(F60:M60)","v":{"v":0,"d":"$0"}}]
["Modified Total Direct Costs (MTDC)*",{"$nulls":4},{"$f":"F17+F25+F34+F39+F54+F58","v":{"v":0,"d":"$0"}},null,{"$f":"H17+H25+H34+H39+H54+H58","v":{"v":0,"d":"$0"}},null,{"$f":"J17+J25+J34+J39+J54+J58","v":{"v":0,"d":"$0"}},null,{"$f":"L17+L25+L34+L39+L54+L58","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F61:M61)","v":{"v":0,"d":"$0"}},{"$f":"N17+N25+N34+N39+N54+N58","v":{"v":0,"d":"$0"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},{"$f":"F61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"H61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"J61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"L61*E62","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F62:M62)","v":{"v":0,"d":"$0"}},{"$f":"O61*E62","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":4},{"$f":"F59+F62","v":{"v":0,"d":"$0"}},null,{"$f":"H59+H62","v":{"v":0,"d":"$0"}},null,{"$f":"J59+J62","v":{"v":0,"d":"$0"}},null,{"$f":"L59+L62","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F63:M63)","v":{"v":0,"d":"$0"}},{"$f":"N59+N62","v":{"v":0,"d":"$0"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]

{"sheet":"5 Year Worksheet","index":5,"n_rows":80,"n_cols":17,"rows_kept":80,"merged":[[0,0,0,15],[1,0,4,1],[1,3,1,13],[1,14,4,15],[2,3,2,13],[3,3,3,13],[4,2,4,5],[4,7,4,10],[4,11,4,13],[5,0,5,15],[6,0,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[6,15,7,15],[7,0,7,14],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,4],[16,0,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[17,0,17,15],[18,0,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[18,13,18,14],[19,0,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[20,0,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[21,0,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[22,0,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[23,0,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[24,0,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[25,0,25,15],[26,0,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[27,0,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[28,0,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[29,0,29,15],[30,0,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[31,0,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[32,0,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,14],[33,0,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[34,0,34,15],[35,0,35,4],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[36,0,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[37,0,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[38,0,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[39,0,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[40,0,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[41,0,41,15],[42,0,42,1],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[43,0,45,1],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[44,2,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[45,2,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[46,0,46,1],[46,2,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[47,0,49,1],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[48,2,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[49,2,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[50,0,50,1],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[51,0,53,1],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[52,2,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[53,2,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[54,0,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[55,0,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[56,0,56,15],[57,0,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[58,0,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[59,0,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[60,0,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[61,0,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,0,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[62,13,62,14],[63,0,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[64,0,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[64,13,64,14],[65,0,65,3],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[65,13,65,14],[66,0,66,4],[66,5,66,6],[66,7,66,8],[66,9,66,10],[66,11,66,12],[66,13,66,14],[68,0,68,6],[70,0,70,6],[71,0,71,7],[73,0,76,7]]}
["Southern Illinois University School of Medicine"]
[null,null,"PI:"]
[null,null,"App Title:"]
[null,null,"Agency:"]
[{"$nulls":6},"Deadline:"]
[]
[{"$nulls":5},"Year 1 ",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%)."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%"]
[{"$nulls":5},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03>221899.99,(221900*D10),F10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"H10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF((E10*1.03*1.03)>221899.99,(221900*D10),H10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"J10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03*1.03*1.03>221899.99,(221900*D10),J10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"L10*0.484","v":{"v":0,"d":"$0"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03*1.03*1.03*1.03>221899.99,(221900*D10),L10*1.03))","v":{"v":0,"d":"$0"}},{"$f":"N10*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F10:O10)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L11*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"N11*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F11:O11)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L12*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"N12*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F12:O12)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"v":0,"d":"$0"},{"$f":"F13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L13*0.484","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"N13*0.484","v":{"v":0,"d":"$0"}},{"$f":"SUM(F13:O13)","v":{"v":0,"d":"$0"}}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"F14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"H14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"J14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"L14*0.375","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"N14*0.375","v":{"v":0,"d":"$0"}},{"$f":"SUM(F14:O14)","v":{"v":0,"d":"$0"}}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"v":0,"d":"$0"},{"$f":"IF(F15>0,366,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,376,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,386,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,396,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$f":"IF(F15>0,396,0)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F15)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(J10:J15)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F16+G16","v":{"v":0,"d":"$0"}},null,{"$f":"H16+I16","v":{"v":0,"d":"$0"}},null,{"$f":"J16+K16","v":{"v":0,"d":"$0"}},null,{"$f":"L16+M16","v":{"v":0,"d":"$0"}},null,{"$f":"N16+O16","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P10:P15)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F17:O17)","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":15},{"$f":"SUM(F19:O19)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"$f":"SUM(F21:O21)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":4},{"$f":"SUM(F19:G24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H19:I24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J19:K24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L19:M24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N19:O24)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P19:P24)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F25:O25)","v":{"v":0,"d":"$0"}}]
["Equipment"]
[{"$nulls":15},{"$f":"SUM(F27:O27)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F28:O28)","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":4},{"$f":"SUM(F27:G28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H27:I28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J27:K28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L27:M28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N27:O28)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P27:P28)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F29:O29)","v":{"v":0,"d":"$0"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
[{"$nulls":15},{"$f":"SUM(F31:O31)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F32:O32)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F33:O33)","v":{"v":0,"d":"$0"}}]
["Subtotal Travel",{"$nulls":4},{"$f":"SUM(F31:G33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H31:I33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J31:K33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L31:M33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N31:O33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P31:P33)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F34:O34)","v":{"v":0,"d":"$0"}}]
["Contractual - for example: core facility costs, publication"]
[{"$nulls":15},{"$f":"SUM(F36:O36)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F37:O37)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"$f":"SUM(F39:O39)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F40:O40)","v":{"v":0,"d":"$0"}}]
["Subtotal Contractual",{"$nulls":4},{"$f":"SUM(F36:G40)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H36:I40)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J36:K40)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L36:M40)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N36:O40)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P36:P40)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F41:O41)","v":{"v":0,"d":"$0"}}]
["Consortium/Subcontract Costs - List each subcontractor separately."]
["Consortia 1:",null,"Consortia 1 Direct Costs",{"$nulls":12},{"$f":"SUM(F43:O43)","v":{"v":0,"d":"$0"}}]
["Organization",null,"Consortia 1 Indirect Costs",{"$nulls":12},{"v":0,"d":"$0"}]
[null,null,"Consortia 1 Total",null,null,{"$f":"SUM(F43:G44)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H43:I44)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J43:K44)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L43:M44)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N43:O44)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"P43+P44","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F45>25000,25000,F45)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F45+H45<25000,H45,IF((25000-F45)<0,0,25000-F45))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F45+H45+J45<25000,J45,IF((25000-(F45+H45))<0,0,25000-(F45+H45)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F45+H45+J45+L45<25000,L45,IF((25000-(F45+H45+J45))<0,0,25000-(F45+H45+J45)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F45+H45+J45+L45+N45<25000,N45,IF((25000-(F45+H45+J45+L45))<0,0,25000-(F45+H45+J45+L45)))","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F46:O46)","v":{"v":0,"d":"$0"}}]
["Consortia 2:",null,"Consortia 2 Direct Costs",{"$nulls":12},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 2 Indirect Costs",{"$nulls":12},{"v":0,"d":"$0"}]
[null,null,"Consortia 2 Total",null,null,{"$f":"SUM(F47:G48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H47:I48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J47:K48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L47:M48)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N47:O48)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"P48+P47","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F49>25000,25000,F49)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49<25000,H49,IF((25000-F49)<0,0,25000-F49))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49+J49<25000,J49,IF((25000-(F49+H49))<0,0,25000-(F49+H49)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49+J49+L49<25000,L49,IF((25000-(F49+H49+J49))<0,0,25000-(F49+H49+J49)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49+J49+L49+N49<25000,N49,IF((25000-(F49+H49+J49+L49))<0,0,25000-(F49+H49+J49+L49)))","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F50:O50)","v":{"v":0,"d":"$0"}}]
["Consortia 3:",null,"Consortia 3 Direct Costs",{"$nulls":12},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 3 Indirect Costs",{"$nulls":12},{"v":0,"d":"$0"}]
[null,null,"Consortia 3 Total",null,null,{"$f":"SUM(F51:G52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H51:I52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J51:K52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L51:M52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N51:O52)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"P51+P52","v":{"v":0,"d":"$0"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F53>25000,25000,F53)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53<25000,H53,IF((25000-F53)<0,0,25000-F53))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53+J53<25000,J53,IF((25000-(F53+H53))<0,0,25000-(F53+H53)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53+J53+L53<25000,L53,IF((25000-(F53+H53+J53))<0,0,25000-(F53+H53+J53)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53+J53+L53+N53<25000,N53,IF((25000-(F53+H53+J53+L53))<0,0,25000-(F53+H53+J53+L53)))","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F54:O54)","v":{"v":0,"d":"$0"}}]
["Subtotal Consortium/Subcontract",{"$nulls":4},{"$f":"F45+F49+F53","v":{"v":0,"d":"$0"}},null,{"$f":"H45+H49+H53","v":{"v":0,"d":"$0"}},null,{"$f":"J45+J49+J53","v":{"v":0,"d":"$0"}},null,{"$f":"L45+L49+L53","v":{"v":0,"d":"$0"}},null,{"$f":"N45+N49+N53","v":{"v":0,"d":"$0"}},null,{"$f":"P45+P49+P53","v":{"v":0,"d":"$0"}},{"$f":"SUM(F55:O55)","v":{"v":0,"d":"$0"}}]
["MTDC Calculation",{"$nulls":4},{"$f":"F46+F50+F54","v":{"v":0,"d":"$0"}},null,{"$f":"H46+H50+H54","v":{"v":0,"d":"$0"}},null,{"$f":"J46+J50+J54","v":{"v":0,"d":"$0"}},null,{"$f":"L46+L50+L54","v":{"v":0,"d":"$0"}},null,{"$f":"N46+N50+N54","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F56:O56)","v":{"v":0,"d":"$0"}},{"$f":"P46+P50+P54","v":{"v":0,"d":"$0"}}]
["Other Costs"]
[{"$nulls":15},{"$f":"SUM(F58:O58)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F59:O59)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"$f":"SUM(F61:O61)","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":4},{"$f":"SUM(F58:G61)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H58:I61)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J58:K61)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L58:M61)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N58:O61)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P58:P61)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F62:O62)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":4},{"$f":"F17+F25+F29+F34+F41+F55+F62","v":{"v":0,"d":"$0"}},null,{"$f":"H17+H25+H29+H34+H41+H55+H62","v":{"v":0,"d":"$0"}},null,{"$f":"J17+J25+J29+J34+J41+J55+J62","v":{"v":0,"d":"$0"}},null,{"$f":"L17+L25+L29+L34+L41+L55+L62","v":{"v":0,"d":"$0"}},null,{"$f":"N17+N25+N29+N34+N41+N55+N62","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F63:O63)","v":{"v":0,"d":"$0"}},{"$f":"P17+P25+P29+P34+P41+P55+P62","v":{"v":0,"d":"$0"}}]
["Total Direct Costs less Consortium F&A",{"$nulls":4},{"$f":"F63-F44-F48-F52","v":{"v":0,"d":"$0"}},null,{"$f":"H63-H44-H48-H52","v":{"v":0,"d":"$0"}},null,{"$f":"J63-J44-J48-J52","v":{"v":0,"d":"$0"}},null,{"$f":"L63-L44-L48-L52","v":{"v":0,"d":"$0"}},null,{"$f":"N63-N44-N48-N52","v":{"v":0,"d":"$0"}},null,{"$f":"P63-P44-P48-P52","v":{"v":0,"d":"$0"}},{"$f":"SUM(F64:O64)","v":{"v":0,"d":"$0"}}]
["Modified Total Direct Costs (MTDC)*",{"$nulls":4},{"$f":"F17+F25+F34+F41+F56+F62","v":{"v":0,"d":"$0"}},null,{"$f":"H17+H25+H34+H41+H56+H62","v":{"v":0,"d":"$0"}},null,{"$f":"J17+J25+J34+J41+J56+J62","v":{"v":0,"d":"$0"}},null,{"$f":"L17+L25+L34+L41+L56+L62","v":{"v":0,"d":"$0"}},null,{"$f":"N17+N25+N34+N41+N56+N62","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F65:O65)","v":{"v":0,"d":"$0"}},{"$f":"P17+P25+P34+P41+P56+P62","v":{"v":0,"d":"$0"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},{"$f":"F65*E66","v":{"v":0,"d":"$0"}},null,{"$f":"H65*E66","v":{"v":0,"d":"$0"}},null,{"$f":"J65*E66","v":{"v":0,"d":"$0"}},null,{"$f":"L65*E66","v":{"v":0,"d":"$0"}},null,{"$f":"N65*E66","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F66:O66)","v":{"v":0,"d":"$0"}},{"$f":"Q65*E66","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":4},{"$f":"F63+F66","v":{"v":0,"d":"$0"}},null,{"$f":"H63+H66","v":{"v":0,"d":"$0"}},null,{"$f":"J63+J66","v":{"v":0,"d":"$0"}},null,{"$f":"L63+L66","v":{"v":0,"d":"$0"}},null,{"$f":"N63+N66","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F67:O67)","v":{"v":0,"d":"$0"}},{"$f":"P63+P66","v":{"v":0,"d":"$0"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]

{"sheet":"Sample","index":6,"n_rows":78,"n_cols":17,"rows_kept":78,"merged":[[0,0,0,15],[1,0,4,1],[1,3,1,13],[1,14,4,15],[2,3,2,13],[3,3,3,13],[4,2,4,5],[4,7,4,9],[4,10,4,11],[5,0,5,15],[6,0,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[6,15,7,15],[7,0,7,14],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,4],[17,0,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[18,0,18,15],[19,0,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[20,0,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[21,0,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[22,0,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[23,0,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[24,0,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[25,0,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[26,0,26,15],[27,0,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[28,0,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[29,0,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[30,0,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[31,0,31,15],[32,0,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,14],[33,0,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[34,0,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[35,0,35,4],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[36,0,36,15],[37,0,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[38,0,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[39,0,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[40,0,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[41,0,41,15],[42,0,42,1],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[43,0,45,1],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[44,2,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[45,2,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[46,0,46,1],[46,2,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[47,0,49,1],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[48,2,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[49,2,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[50,0,50,1],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[51,0,53,1],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[52,2,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[53,2,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[54,0,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[55,0,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[56,0,56,15],[57,0,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[58,0,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[59,0,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[60,0,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[61,0,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,0,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[62,13,62,14],[63,0,63,3],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[64,0,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[64,13,64,14],[66,0,66,6],[68,0,68,6],[69,0,69,7],[71,0,74,7]]}
["Southern Illinois University School of Medicine"]
[null,null,"PI:","Principal Investigator, PhD, MD"]
[null,null,"App Title:","Full Application Title"]
[null,null,"Agency:","NIH"]
[{"$nulls":6},"Deadline:","2030-01-01"]
[]
[{"$nulls":5},"Year 1 ",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total Project Costs"]
["Personnel - List all SIU SOM employees with effort on this project.  Future year salary increases modified by inflation factor (3%). Individuals at the NIH cap cannot include inflation increases."]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%","Salary Requested","Fringes @ 48.4%"]
["Principal Investigator (PI)",null,null,{"v":0.2,"d":"20%"},{"v":250000,"d":"$250,000"},{"$f":"IF(E10>221899.99,(221900*D10),D10*E10)","v":{"v":44380,"d":"$44,380"}},{"$f":"F10*0.484","v":{"v":21479.92,"d":"$21,480"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03>221899.99,(221900*D10),F10*1.03))","v":{"v":44380,"d":"$44,380"}},{"$f":"H10*0.484","v":{"v":21479.92,"d":"$21,480"}},{"$f":"IF(E10>221899.99,F10,IF((E10*1.03*1.03)>221899.99,(221900*D10),H10*1.03))","v":{"v":44380,"d":"$44,380"}},{"$f":"J10*0.484","v":{"v":21479.92,"d":"$21,480"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03*1.03*1.03>221899.99,(221900*D10),J10*1.03))","v":{"v":44380,"d":"$44,380"}},{"$f":"L10*0.484","v":{"v":21479.92,"d":"$21,480"}},{"$f":"IF(E10>221899.99,F10,IF(E10*1.03*1.03*1.03*1.03>221899.99,(221900*D10),L10*1.03))","v":{"v":44380,"d":"$44,380"}},{"$f":"N10*0.484","v":{"v":21479.92,"d":"$21,480"}},{"$f":"SUM(F10:O10)","v":{"v":329299.6,"d":"$329,300"}}]
["Co-PI",null,null,{"v":0.2,"d":"20%"},{"v":180000,"d":"$180,000"},{"v":36000,"d":"$36,000"},{"$f":"F11*0.484","v":{"v":17424,"d":"$17,424"}},{"$f":"IF(E11>221899.99,F11,IF(E11*1.03>221899.99,(221900*D11),F11*1.03))","v":{"v":37080,"d":"$37,080"}},{"$f":"H11*0.484","v":{"v":17946.72,"d":"$17,947"}},{"v":38192.4,"d":"$38,192"},{"$f":"J11*0.484","v":{"v":18485.1216,"d":"$18,485"}},{"v":39338.172000000006,"d":"$39,338"},{"$f":"L11*0.484","v":{"v":19039.675248000003,"d":"$19,040"}},{"v":40518.317160000006,"d":"$40,518"},{"$f":"N11*0.484","v":{"v":19610.86550544,"d":"$19,611"}},{"v":283635.27151344,"d":"$283,635"}]
["Co-Investigator",null,null,{"v":0.1,"d":"10%"},{"v":80000,"d":"$80,000"},{"v":8000,"d":"$8,000"},{"$f":"F12*0.484","v":{"v":3872,"d":"$3,872"}},{"$f":"IF(E12>221899.99,F12,IF(E12*1.03>221899.99,(221900*D12),F12*1.03))","v":{"v":8240,"d":"$8,240"}},{"$f":"H12*0.484","v":{"v":3988.16,"d":"$3,988"}},{"v":8487.2,"d":"$8,487"},{"$f":"J12*0.484","v":{"v":4107.8048,"d":"$4,108"}},{"v":8741.816,"d":"$8,742"},{"$f":"L12*0.484","v":{"v":4231.038944,"d":"$4,231"}},{"v":9004.07048,"d":"$9,004"},{"$f":"N12*0.484","v":{"v":4357.97011232,"d":"$4,358"}},{"v":63030.06033632,"d":"$63,030"}]
["Researcher IV",null,null,{"v":0.1,"d":"10%"},{"v":45000,"d":"$45,000"},{"v":4500,"d":"$4,500"},{"$f":"F13*0.484","v":{"v":2178,"d":"$2,178"}},{"$f":"IF(E13>221899.99,F13,IF(E13*1.03>221899.99,(221900*D13),F13*1.03))","v":{"v":4635,"d":"$4,635"}},{"$f":"H13*0.484","v":{"v":2243.34,"d":"$2,243"}},{"v":4774.05,"d":"$4,774"},{"$f":"J13*0.484","v":{"v":2310.6402,"d":"$2,311"}},{"v":4917.271500000001,"d":"$4,917"},{"$f":"L13*0.484","v":{"v":2379.9594060000004,"d":"$2,380"}},{"v":5064.789645000001,"d":"$5,065"},{"$f":"N13*0.484","v":{"v":2451.35818818,"d":"$2,451"}},{"v":35454.40893918,"d":"$35,454"}]
["Study Coordinator",null,null,{"v":0.4,"d":"40%"},{"v":65000,"d":"$65,000"},{"v":26000,"d":"$26,000"},{"$f":"F14*0.484","v":{"v":12584,"d":"$12,584"}},{"$f":"IF(E14>221899.99,F14,IF(E14*D14*1.03>221899.99,(221900*D14),F14*1.03))","v":{"v":26780,"d":"$26,780"}},{"$f":"H14*0.484","v":{"v":12961.52,"d":"$12,962"}},{"v":27583.4,"d":"$27,583"},{"$f":"J14*0.484","v":{"v":13350.365600000001,"d":"$13,350"}},{"v":28410.902000000002,"d":"$28,411"},{"$f":"L14*0.484","v":{"v":13750.876568,"d":"$13,751"}},{"v":29263.22906,"d":"$29,263"},{"$f":"N14*0.484","v":{"v":14163.40286504,"d":"$14,163"}},{"v":204847.69609304002,"d":"$204,848"}]
["POST DOC - 37.5% fringe rate",null,null,{"v":0.1,"d":"10%"},{"v":45000,"d":"$45,000"},{"v":4500,"d":"$4,500"},{"$f":"F15*0.375","v":{"v":1687.5,"d":"$1,688"}},{"$f":"IF(E15>221899.99,F15,IF(E15*1.03>221899.99,(221900*D15),F15*1.03))","v":{"v":4635,"d":"$4,635"}},{"$f":"H15*0.375","v":{"v":1738.125,"d":"$1,738"}},{"v":4774.05,"d":"$4,774"},{"$f":"J15*0.375","v":{"v":1790.2687500000002,"d":"$1,790"}},{"v":4917.271500000001,"d":"$4,917"},{"$f":"L15*0.375","v":{"v":1843.9768125000003,"d":"$1,844"}},{"v":5064.789645000001,"d":"$5,065"},{"$f":"N15*0.375","v":{"v":1899.2961168750003,"d":"$1,899"}},{"v":32850.277824375,"d":"$32,850"}]
["GRADUATE STUDENT - 50% FTE",null,null,{"v":1,"d":"100%"},{"v":20664,"d":"$20,664"},{"v":20664,"d":"$20,664"},{"$f":"IF(F16>0,366,0)","v":{"v":366,"d":"$366"}},{"$f":"IF(E16>221899.99,F16,IF(E16*1.03>221899.99,(221900*D16),F16*1.03))","v":{"v":21283.920000000002,"d":"$21,284"}},{"$f":"IF(F16>0,376,0)","v":{"v":376,"d":"$376"}},{"v":21922.4376,"d":"$21,922"},{"$f":"IF(F16>0,386,0)","v":{"v":386,"d":"$386"}},{"v":22580.110728000003,"d":"$22,580"},{"$f":"IF(F16>0,396,0)","v":{"v":396,"d":"$396"}},{"v":23257.514049840003,"d":"$23,258"},{"$f":"IF(F16>0,396,0)","v":{"v":396,"d":"$396"}},{"v":111627.98237784,"d":"$111,628"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F10:F16)","v":{"v":144044,"d":"$144,044"}},{"v":59591.42,"d":"$59,591"},{"v":147033.92,"d":"$147,034"},{"v":60733.785,"d":"$60,734"},{"v":150113.53759999998,"d":"$150,114"},{"v":61910.12095,"d":"$61,910"},{"v":153285.54372800002,"d":"$153,286"},{"v":63121.4469785,"d":"$63,121"},{"v":156552.71003984002,"d":"$156,553"},{"v":64358.81278785499,"d":"$64,359"}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F17+G17","v":{"v":203635.41999999998,"d":"$203,635"}},null,{"$f":"H17+I17","v":{"v":207767.70500000002,"d":"$207,768"}},null,{"$f":"J17+K17","v":{"v":212023.65855,"d":"$212,024"}},null,{"$f":"L17+M17","v":{"v":216406.99070650002,"d":"$216,407"}},null,{"$f":"N17+O17","v":{"v":220911.522827695,"d":"$220,912"}},null,{"$f":"SUM(P10:P16)","v":{"v":1060745.297084195,"d":"$1,060,745"}}]
["Supplies/Commodities"]
["Glassware",{"$nulls":4},{"v":3000,"d":"$3,000"},null,{"v":3000,"d":"$3,000"},null,{"v":3000,"d":"$3,000"},null,{"v":3000,"d":"$3,000"},null,{"v":3000,"d":"$3,000"},null,{"$f":"SUM(F20:O20)","v":{"v":15000,"d":"$15,000"}}]
["Animal costs",{"$nulls":4},{"v":5000,"d":"$5,000"},null,{"v":5000,"d":"$5,000"},null,{"v":5000,"d":"$5,000"},null,{"v":5000,"d":"$5,000"},null,{"v":5000,"d":"$5,000"},null,{"v":25000,"d":"$25,000"}]
["Chemicals and reagents",{"$nulls":4},{"v":7000,"d":"$7,000"},null,{"v":7000,"d":"$7,000"},null,{"v":7000,"d":"$7,000"},null,{"v":5000,"d":"$5,000"},null,{"v":5000,"d":"$5,000"},null,{"v":31000,"d":"$31,000"}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"v":0,"d":"$0"}]
[{"$nulls":15},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":4},{"$f":"SUM(F20:G25)","v":{"v":15000,"d":"$15,000"}},null,{"$f":"SUM(H20:I25)","v":{"v":15000,"d":"$15,000"}},null,{"$f":"SUM(J20:K25)","v":{"v":15000,"d":"$15,000"}},null,{"$f":"SUM(L20:M25)","v":{"v":13000,"d":"$13,000"}},null,{"$f":"SUM(N20:O25)","v":{"v":13000,"d":"$13,000"}},null,{"$f":"SUM(P20:P25)","v":{"v":71000,"d":"$71,000"}}]
["Equipment"]
["Freezer",{"$nulls":4},{"v":7000,"d":"$7,000"},{"$nulls":9},{"$f":"SUM(F28:O28)","v":{"v":7000,"d":"$7,000"}}]
[{"$nulls":15},{"$f":"SUM(F29:O29)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F30:O30)","v":{"v":0,"d":"$0"}}]
["Subtotal Equipment",{"$nulls":4},{"$f":"SUM(F28:G30)","v":{"v":7000,"d":"$7,000"}},null,{"$f":"SUM(H28:I30)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J28:K30)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L28:M30)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N28:O30)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P28:P30)","v":{"v":7000,"d":"$7,000"}}]
["Travel - list personnel, purpose, destination, and categorical cost calculation"]
["National Research Conference (PI, Atlanta, GA)",{"$nulls":8},{"v":4000,"d":"$4,000"},null,{"v":4200,"d":"$4,200"},null,{"v":5300,"d":"$5,300"},null,{"$f":"SUM(F33:O33)","v":{"v":13500,"d":"$13,500"}}]
["Conference registration fees (PI, Co-PI, annual meeting)",{"$nulls":8},{"v":1800,"d":"$1,800"},null,{"v":2000,"d":"$2,000"},null,{"v":2400,"d":"$2,400"},null,{"$f":"SUM(F34:O34)","v":{"v":6200,"d":"$6,200"}}]
[{"$nulls":15},{"$f":"SUM(F35:O35)","v":{"v":0,"d":"$0"}}]
["Subtotal Travel",{"$nulls":4},{"$f":"SUM(F33:G35)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H33:I35)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J33:K35)","v":{"v":5800,"d":"$5,800"}},null,{"$f":"SUM(L33:M35)","v":{"v":6200,"d":"$6,200"}},null,{"$f":"SUM(N33:O35)","v":{"v":7700,"d":"$7,700"}},null,{"$f":"SUM(P33:P35)","v":{"v":19700,"d":"$19,700"}}]
["Contractual - for example: core facility costs, publication"]
["Center for Clinical Research (Stats)",{"$nulls":6},{"$f":"100*80","v":{"v":8000,"d":"$8,000"}},null,{"$f":"150*80","v":{"v":12000,"d":"$12,000"}},null,{"$f":"200*80","v":{"v":16000,"d":"$16,000"}},null,{"$f":"100*80","v":{"v":8000,"d":"$8,000"}},null,{"$f":"SUM(F38:O38)","v":{"v":44000,"d":"$44,000"}}]
["Flow Cytometry",{"$nulls":4},{"v":5000,"d":"$5,000"},null,{"v":5150,"d":"$5,150"},{"$nulls":7},{"$f":"SUM(F39:O39)","v":{"v":10150,"d":"$10,150"}}]
["Publications",{"$nulls":6},{"v":2000,"d":"$2,000"},null,{"v":2000,"d":"$2,000"},null,{"v":2000,"d":"$2,000"},null,{"v":2000,"d":"$2,000"},null,{"$f":"SUM(F40:O40)","v":{"v":8000,"d":"$8,000"}}]
["Subtotal Contractual",{"$nulls":4},{"$f":"SUM(F38:G40)","v":{"v":5000,"d":"$5,000"}},null,{"$f":"SUM(H38:I40)","v":{"v":15150,"d":"$15,150"}},null,{"$f":"SUM(J38:K40)","v":{"v":14000,"d":"$14,000"}},null,{"$f":"SUM(L38:M40)","v":{"v":18000,"d":"$18,000"}},null,{"$f":"SUM(N38:O40)","v":{"v":10000,"d":"$10,000"}},null,{"$f":"SUM(P38:P40)","v":{"v":62150,"d":"$62,150"}}]
["Consortium/Subcontract Costs - list each subcontractor separately"]
["Consortia 1:",null,"Consortia 1 Direct Costs",null,null,{"v":15000,"d":"$15,000"},null,{"v":2000,"d":"$2,000"},null,{"v":6000,"d":"$6,000"},null,{"v":2000,"d":"$2,000"},null,{"v":2000,"d":"$2,000"},null,{"$f":"SUM(F43:O43)","v":{"v":27000,"d":"$27,000"}}]
["University of Illinois",null,"Consortia 1 Indirect Costs",null,null,{"v":4500,"d":"$4,500"},null,{"v":600,"d":"$600"},null,{"v":1800,"d":"$1,800"},null,{"v":600,"d":"$600"},null,{"v":600,"d":"$600"},null,{"v":8100,"d":"$8,100"}]
[null,null,"Consortia 1 Total",null,null,{"$f":"SUM(F43:G44)","v":{"v":19500,"d":"$19,500"}},null,{"$f":"SUM(H43:I44)","v":{"v":2600,"d":"$2,600"}},null,{"$f":"SUM(J43:K44)","v":{"v":7800,"d":"$7,800"}},null,{"$f":"SUM(L43:M44)","v":{"v":2600,"d":"$2,600"}},null,{"$f":"SUM(N43:O44)","v":{"v":2600,"d":"$2,600"}},null,{"v":35100,"d":"$35,100"}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F45>25000,25000,F45)","v":{"v":19500,"d":"$19,500"}},null,{"$f":"IF(F45+H45<25000,H45,IF((25000-F45)<0,0,25000-F45))","v":{"v":2600,"d":"$2,600"}},null,{"$f":"IF(F45+H45+J45<25000,J45,IF((25000-(F45+H45))<0,0,25000-(F45+H45)))","v":{"v":2900,"d":"$2,900"}},null,{"$f":"IF(F45+H45+J45+L45<25000,L45,IF((25000-(F45+H45+J45))<0,0,25000-(F45+H45+J45)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F45+H45+J45+L45+N45<25000,N45,IF((25000-(F45+H45+J45+L45))<0,0,25000-(F45+H45+J45+L45)))","v":{"v":0,"d":"$0"}},null,{"v":25000,"d":"$25,000"}]
["Consortia 2:",null,"Consortia 2 Direct Costs",null,null,{"v":35000,"d":"$35,000"},null,{"v":10000,"d":"$10,000"},null,{"v":20000,"d":"$20,000"},null,{"v":10000,"d":"$10,000"},null,{"v":10000,"d":"$10,000"},null,{"v":85000,"d":"$85,000"}]
["University of California",null,"Consortia 2 Indirect Costs",null,null,{"v":5250,"d":"$5,250"},null,{"v":1500,"d":"$1,500"},null,{"v":3000,"d":"$3,000"},null,{"v":1500,"d":"$1,500"},null,{"v":1500,"d":"$1,500"},null,{"v":12750,"d":"$12,750"}]
[null,null,"Consortia 2 Total",null,null,{"$f":"SUM(F47:G48)","v":{"v":40250,"d":"$40,250"}},null,{"$f":"SUM(H47:I48)","v":{"v":11500,"d":"$11,500"}},null,{"$f":"SUM(J47:K48)","v":{"v":23000,"d":"$23,000"}},null,{"$f":"SUM(L47:M48)","v":{"v":11500,"d":"$11,500"}},null,{"$f":"SUM(N47:O48)","v":{"v":11500,"d":"$11,500"}},null,{"$f":"SUM(F49:O49)","v":{"v":97750,"d":"$97,750"}}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F49>25000,25000,F49)","v":{"v":25000,"d":"$25,000"}},null,{"$f":"IF(F49+H49<25000,H49,IF((25000-F49)<0,0,25000-F49))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49+J49<25000,J49,IF((25000-(F49+H49))<0,0,25000-(F49+H49)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49+J49+L49<25000,L49,IF((25000-(F49+H49+J49))<0,0,25000-(F49+H49+J49)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F49+H49+J49+L49+N49<25000,N49,IF((25000-(F49+H49+J49+L49))<0,0,25000-(F49+H49+J49+L49)))","v":{"v":0,"d":"$0"}},null,{"v":25000,"d":"$25,000"}]
["Consortia 3:",null,"Consortia 3 Direct Costs",{"$nulls":12},{"v":0,"d":"$0"}]
["Organization",null,"Consortia 3 Indirect Costs",{"$nulls":12},{"v":0,"d":"$0"}]
[null,null,"Consortia 3 Total",null,null,{"$f":"SUM(F51:G52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H51:I52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J51:K52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L51:M52)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N51:O52)","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
[null,null,"MTDC Calculation",null,null,{"$f":"IF(F53>25000,25000,F53)","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53<25000,H53,IF((25000-F53)<0,0,25000-F53))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53+J53<25000,J53,IF((25000-(F53+H53))<0,0,25000-(F53+H53)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53+J53+L53<25000,L53,IF((25000-(F53+H53+J53))<0,0,25000-(F53+H53+J53)))","v":{"v":0,"d":"$0"}},null,{"$f":"IF(F53+H53+J53+L53+N53<25000,N53,IF((25000-(F53+H53+J53+L53))<0,0,25000-(F53+H53+J53+L53)))","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
["Subtotal Consortium/Subcontract",{"$nulls":4},{"$f":"F45+F49+F53","v":{"v":59750,"d":"$59,750"}},null,{"$f":"H45+H49+H53","v":{"v":14100,"d":"$14,100"}},null,{"$f":"J45+J49+J53","v":{"v":30800,"d":"$30,800"}},null,{"$f":"L45+L49+L53","v":{"v":14100,"d":"$14,100"}},null,{"$f":"N45+N49+N53","v":{"v":14100,"d":"$14,100"}},null,{"$f":"P45+P49+P54","v":{"v":132850,"d":"$132,850"}}]
["MTDC Calculation",{"$nulls":4},{"$f":"F46+F50+F54","v":{"v":44500,"d":"$44,500"}},null,{"$f":"H46+H50+H54","v":{"v":2600,"d":"$2,600"}},null,{"$f":"J46+J50+J54","v":{"v":2900,"d":"$2,900"}},null,{"$f":"L46+L50+L54","v":{"v":0,"d":"$0"}},null,{"$f":"N46+N50+N54","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F56:O56)","v":{"v":50000,"d":"$50,000"}}]
["Other Costs"]
[{"$nulls":15},{"$f":"SUM(F58:O58)","v":{"v":0,"d":"$0"}}]
[{"$nulls":15},{"$f":"SUM(F59:O59)","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":4},{"$f":"SUM(F58:G59)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H58:I59)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(J58:K59)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(L58:M59)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(N58:O59)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(P58:P59)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":4},{"$f":"F18+F26+F31+F36+F41+F55+F60","v":{"v":290385.42,"d":"$290,385"}},null,{"$f":"H18+H26+H31+H36+H41+H55+H60","v":{"v":252017.70500000002,"d":"$252,018"}},null,{"$f":"J18+J26+J31+J36+J41+J55+J60","v":{"v":277623.65855,"d":"$277,624"}},null,{"$f":"L18+L26+L31+L36+L41+L55+L60","v":{"v":267706.9907065,"d":"$267,707"}},null,{"$f":"N18+N26+N31+N36+N41+N55+N60","v":{"v":265711.522827695,"d":"$265,712"}},null,{"$f":"SUM(F61:O61)","v":{"v":1353445.297084195,"d":"$1,353,445"}},{"$f":"P18+P26+P31+P36+P41+P55+P60","v":{"v":1353445.297084195,"d":"1,353,445"}}]
["Total Direct Costs less Consortium F&A",{"$nulls":4},{"$f":"F61-F44-F48-F52","v":{"v":280635.42,"d":"$280,635"}},null,{"$f":"H61-H44-H48-H52","v":{"v":249917.70500000002,"d":"$249,918"}},null,{"$f":"J61-J44-J48-J52","v":{"v":272823.65855,"d":"$272,824"}},null,{"$f":"L61-L44-L48-L52","v":{"v":265606.9907065,"d":"$265,607"}},null,{"$f":"N61-N44-N48-N52","v":{"v":263611.522827695,"d":"$263,612"}},null,{"$f":"P61-P44-P48-P52","v":{"v":1332595.297084195,"d":"$1,332,595"}},{"$f":"SUM(F62:O62)","v":{"v":1332595.297084195,"d":"1,332,595"}}]
["Modified Total Direct Costs (MTDC)*",{"$nulls":4},{"$f":"F18+F26+F36+F41+F56+F60","v":{"v":268135.42,"d":"$268,135"}},null,{"$f":"H18+H26+H36+H41+H56+H60","v":{"v":240517.70500000002,"d":"$240,518"}},null,{"$f":"J18+J26+J36+J41+J56+J60","v":{"v":249723.65855,"d":"$249,724"}},null,{"$f":"L18+L26+L36+L41+L56+L60","v":{"v":253606.99070650002,"d":"$253,607"}},null,{"$f":"N18+N26+N36+N41+N56+N60","v":{"v":251611.522827695,"d":"$251,612"}},null,{"$f":"SUM(F63:O63)","v":{"v":1263595.297084195,"d":"$1,263,595"}},{"$f":"P60+P56+P41+P36+P26+P18","v":{"v":1263595.297084195,"d":"1,263,595"}}]
["Indirects",{"$nulls":3},{"v":0.485,"d":"48.50%"},{"$f":"F63*E64","v":{"v":130045.67869999999,"d":"$130,046"}},null,{"$f":"H63*E64","v":{"v":116651.08692500001,"d":"$116,651"}},null,{"$f":"J63*E64","v":{"v":121115.97439675,"d":"$121,116"}},null,{"$f":"L63*E64","v":{"v":122999.3904926525,"d":"$122,999"}},null,{"$f":"N63*E64","v":{"v":122031.58857143208,"d":"$122,032"}},null,{"$f":"SUM(F64:O64)","v":{"v":612843.7190858346,"d":"$612,844"}},{"$f":"P63*E64","v":{"v":612843.7190858346,"d":"612,844"}}]
["Total Budget Request",{"$nulls":4},{"$f":"F61+F64","v":{"v":420431.0987,"d":"$420,431"}},null,{"$f":"H61+H64","v":{"v":368668.791925,"d":"$368,669"}},null,{"$f":"J61+J64","v":{"v":398739.63294675,"d":"$398,740"}},null,{"$f":"L61+L64","v":{"v":390706.3811991525,"d":"$390,706"}},null,{"$f":"N61+N64","v":{"v":387743.11139912705,"d":"$387,743"}},null,{"$f":"SUM(F65:O65)","v":{"v":1966289.0161700295,"d":"$1,966,289"}},{"$f":"Q61+Q64","v":{"v":1966289.0161700295,"d":"1,966,289"}}]
[]
["Contact grants@siumed.edu for assistance or questions."]
[]
["Federal Budget Notes:"]
["1) NIH Executive Level II salary cap = $221,900 as of January 1, 2024."]
[]
["2) The applicant should not include the consortium partner Indirect Costs (IDC) associated in calculating the $250,000 direct cost level for modular budget eligibility. Consortium IDC may be requested above the normal $250,000 direct cost limits."]
[]
[]
[]
[]
[]
["Last Updated: 2/23/2024"]