{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["C. 1 Year Itemized Budget"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"C. 1 Year Itemized Budget","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[0,0,0,7],[1,0,3,1],[1,3,1,6],[1,7,3,7],[2,3,2,6],[3,3,3,6],[4,0,4,7],[5,0,5,4],[5,5,5,6],[5,7,6,7],[6,0,6,6],[7,0,7,2],[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,4],[15,0,15,4],[15,5,15,6],[16,0,16,7],[17,0,17,4],[17,5,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,7],[25,0,25,7],[26,0,26,4],[26,5,26,6],[27,0,27,4],[27,5,27,6],[28,0,28,4],[28,5,28,6],[29,0,29,4],[29,5,29,6],[30,0,30,7],[31,0,31,4],[31,5,31,6],[32,0,32,4],[32,5,32,6],[33,0,33,4],[33,5,33,6],[34,0,34,4],[34,5,34,6],[35,0,35,4],[35,5,35,6],[37,0,37,2]]}
["Southern Illinois University School of Medicine--Near-Miss Awards, Spring 2021"]
[null,null,"PI:"]
[null,null,"Project Title:"]
[null,null,"Department:"]
[]
[{"$nulls":5},"Year 1 ",null,"Total Project Costs"]
["List Personnel (SIU School of Medicine only); Faculty salaries are not allowed.  Use calendar, academic, or summer to enter months devoted to project. Enter dollar amounts requested (omit cents) for requested budget.)"]
["Name",null,null,"% Effort","Academic Base Salary","Salary Requested","Fringes @ 48.8%"]
[{"$nulls":5},{"$f":"D9*E9","v":{"v":0,"d":"$0"}},{"$f":"F9*0.488","v":{"v":0,"d":"$0"}},{"$f":"SUM(F9:G9)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"$f":"IF(E10>186999.99,(187000*D10),D10*E10)","v":{"v":0,"d":"$0"}},{"$f":"F10*0.488","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[{"$nulls":5},{"$f":"IF(E11>186999.99,(187000*D11),D11*E11)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":5},{"$f":"IF(E12>186999.99,(187000*D12),D12*E12)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["POST DOC - 37.5% fringe rate",{"$nulls":4},{"$f":"IF(E13>186999.99,(187000*D13),D13*E13)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["GRADUATE STUDENT - 50% FTE",{"$nulls":4},{"$f":"IF(E14>186999.99,(187000*D14),D14*E14)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Subtotal Personnel",{"$nulls":4},{"$f":"SUM(F9:F14)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
["Total Salary + Fringes",{"$nulls":4},{"$f":"F15+G15","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H9:H14)","v":{"v":0,"d":"$0"}},{"$f":"SUM(F16:G16)","v":{"v":0,"d":"$0"}}]
["Supplies/Commodities"]
[{"$nulls":7},{"$f":"SUM(F18:G18)","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"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
["Subtotal Supplies",{"$nulls":4},{"$f":"SUM(F18:G23)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H18:H23)","v":{"v":0,"d":"$0"}}]
["Contractual  (For example: Core facility costs, etc.)"]
["(Publication costs are not eligible for funding)."]
[{"$nulls":7},{"$f":"SUM(F27:G27)","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"v":0,"d":"$0"}]
[{"$nulls":7},{"v":0,"d":"$0"}]
["Subtotal Contractual",{"$nulls":4},{"$f":"SUM(F27:G29)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H27:H29)","v":{"v":0,"d":"$0"}}]
["Patient Care Costs"]
["Inpatient",{"$nulls":6},{"$f":"SUM(F32:G32)","v":{"v":0,"d":"$0"}}]
["Outpatient",{"$nulls":6},{"$f":"SUM(F33:G33)","v":{"v":0,"d":"$0"}}]
["Subtotal Other Costs",{"$nulls":4},{"$f":"SUM(F32:G33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(H32:H33)","v":{"v":0,"d":"$0"}}]
["Total Direct Costs",{"$nulls":4},{"$f":"SUM(F34+F30+F24+F16)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F35:G35)","v":{"v":0,"d":"$0"}}]
["Total Budget Request",{"$nulls":4},{"$f":"F35","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(F36:G36)","v":{"v":0,"d":"$0"}}]
[]
["2/10/21 update"]