{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["WRVCS"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"WRVCS","index":0,"n_rows":34,"n_cols":20,"rows_kept":34,"merged":[[0,0,2,18],[4,0,4,2],[4,3,4,8],[4,10,4,12],[4,13,4,18],[5,0,5,2],[5,3,5,8],[5,10,5,12],[5,13,5,18],[6,0,6,8],[6,10,6,12],[6,13,6,18],[7,0,8,8],[7,9,9,9],[7,10,8,11],[7,12,8,13],[7,14,8,15],[7,16,8,18],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,18],[10,0,10,5],[10,6,11,7],[10,8,11,8],[10,9,10,13],[10,14,10,18],[11,0,11,2],[11,3,11,5],[12,0,12,2],[12,3,12,5],[12,6,12,7],[13,0,13,2],[13,3,13,5],[13,6,13,7],[14,0,14,2],[14,3,14,5],[14,6,14,7],[15,0,15,2],[15,3,15,5],[15,6,15,7],[16,0,16,2],[16,3,16,5],[16,6,16,7],[17,0,17,2],[17,3,17,5],[17,6,17,7],[18,18,19,19],[19,0,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[19,16,20,16],[19,17,20,17],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[29,0,29,7],[29,9,32,11],[29,13,29,15],[29,16,29,17],[30,0,33,7],[30,13,30,15],[30,16,30,17],[31,13,31,15],[31,16,31,17]]}
["Voluntary cost sharing is cost sharing that is not mandated by the funding agency. This applies most commonly to salaries, but can also apply to equipment and other items in a budget, such as supplies, travel, etc. Please fill out the gray boxes to calculate, then print and scan to grants@siumed.edu. If you are including a graduate student, please enter all information, and send the form to grants@siumed.edu to fill in graduate student fringe benefits (50% of the Primary Care fee). "]
[]
[]
[]
["Principal Investigator",{"$nulls":9},"Funding Agency"]
["PI Department",{"$nulls":9},"Budget Period"]
["Proposal Title",{"$nulls":9},"Application Due Date"]
[{"$nulls":9},"Fringe Rates","Personnel",null,"Retired, Emeritus",null,"Post Doc",null,"Graduate Student"]
[]
[{"$nulls":10},{"v":0.583,"d":"58.3%"},null,{"v":0.014,"d":"1.4%"},null,{"v":0.375,"d":"37.5%"},null,"grants@siumed.edu"]
["PERSONNEL",{"$nulls":5},"Annual Base Salary",null,"Fringe Rate","Total Percent Effort",{"$nulls":4},"Cost Share Percentage"]
["Name",null,null,"Department",{"$nulls":5},"Yr 1","Yr 2","Yr 3","Yr 4","Yr 5","Yr 1","Yr 2","Yr 3","Yr 4","Yr 5"]
[]
[]
[]
[]
[]
[]
["COST-SHARED PERSONNEL COSTS"]
["Name",null,null,"Yr 1 Salary","Yr 1 Fringe","Yr 1 Total","Yr 2 Salary","Yr 2 Fringe","Yr 2 Total","Yr 3 Salary","Yr 3 Fringe","Yr 3 Total","Yr 4 Salary","Yr 4 Fringe","Yr 4 Total","Yr 5 Salary","Yr 5 Fringe","Yr 5 Total"]
[]
[{"$f":"A13","v":0},null,null,{"$f":"IF(G13>189599.99,(189600*O13),G13*O13)","v":0},{"$f":"D22*I13","v":0},{"$f":"D22+E22","v":0},{"$f":"IF(P13>0,IF(G13>189599.99,(189600*P13),IF(G13*1.03>189599.99,(189600*P13),(G13*1.03*P13))),0)","v":0},{"$f":"G22*I13","v":0},{"$f":"G22+H22","v":0},{"$f":"IF(Q13>0,IF(G13>189599.99,(Q13*189600),IF((G13*1.03*1.03)>189599.99,(189600*Q13),G22*1.03)),0)","v":0},{"$f":"J22*I13","v":0},{"$f":"J22+K22","v":0},{"$f":"IF(R13>0,IF(G13>189599.99,(189600*R13),IF(G13*1.03*1.03*1.03>189599.99,(189600*R13),J22*1.03)),0)","v":0},{"$f":"M22*I13","v":0},{"$f":"M22+N22","v":0},{"$f":"IF(S13>0,IF(G13>189599.99,(S13*189600),IF(G13*1.03*1.03*1.03*1.03>189599.99,(189600*S13),M22*1.03)),0)","v":0},{"$f":"P22*I13","v":0},{"$f":"P22+Q22","v":0},{"$f":"D22+G22+J22+M22+P22","v":0},{"$f":"E22+H22+K22+N22+Q22","v":0}]
[0,null,null,{"$f":"IF(G14>189599.99,(189600*O14),G14*O14)","v":0},{"$f":"D23*I14","v":0},{"$f":"D23+E23","v":0},{"$f":"IF(P14>0,IF(G14>189599.99,(P14*189600),IF(G14*1.03>189599.99,(189600*P14),G14*1.03*P14)),0)","v":0},0,{"$f":"G23+H23","v":0},{"$f":"IF(Q14>0,IF(G14>189599.99,(189600*Q14),IF((G14*1.03*1.03)>189599.99,(189600*Q14),G23*1.03)),0)","v":0},0,{"$f":"J23+K23","v":0},{"$f":"IF(R14>0,IF(E11>189599.99,D23,IF(G14*1.03*1.03*1.03>189599.99,(189600*R14),J23*1.03)),0)","v":0},0,{"$f":"M23+N23","v":0},0,0,{"$f":"P23+Q23","v":0},{"$f":"D23+G23+J23+M23+P23","v":0},{"$f":"E23+H23+K23+N23+Q23","v":0}]
[0,null,null,0,0,0,{"$f":"IF(P15>0,IF(G15>189599.99,(P15*189600),IF(G15*1.03>189599.99,(189600*P15),G15*1.03*P15)),0)","v":0},0,0,{"$f":"IF(Q15>0,IF(G15>189599.99,(189600*Q15),IF((G15*1.03*1.03)>189599.99,(189600*Q15),G24*1.03)),0)","v":0},0,0,{"$f":"IF(R15>0,IF(E12>189599.99,D24,IF(G15*1.03*1.03*1.03>189599.99,(189600*R15),J24*1.03)),0)","v":0},0,0,0,0,0,0,0]
[0,null,null,0,0,0,{"$f":"IF(P16>0,IF(G16>189599.99,(P16*189600),IF(G16*1.03>189599.99,(189600*P16),G16*1.03*P16)),0)","v":0},0,{"$f":"G25+H25","v":0},{"$f":"IF(Q16>0,IF(G16>189599.99,(189600*Q16),IF((G16*1.03*1.03)>189599.99,(189600*Q16),G25*1.03)),0)","v":0},0,0,{"$f":"IF(R16>0,IF(E13>189599.99,D25,IF(G16*1.03*1.03*1.03>189599.99,(189600*R16),J25*1.03)),0)","v":0},0,0,0,0,0,0,0]
[0,null,null,0,0,0,{"$f":"IF(P17>0,IF(G17>189599.99,(P17*189600),IF(G17*1.03>189599.99,(189600*P17),D26*1.03)),0)","v":0},0,0,{"$f":"IF(Q17>0,IF(G17>189599.99,(189600*Q17),IF((G17*1.03*1.03)>189599.99,(189600*Q17),G26*1.03)),0)","v":0},0,0,{"$f":"IF(R17>0,IF(E14>189599.99,D26,IF(G17*1.03*1.03*1.03>189599.99,(189600*R17),J26*1.03)),0)","v":0},0,0,0,0,0,0,0]
[0,null,null,0,0,0,{"$f":"IF(P18>0,IF(G18>189599.99,(P18*189600),IF(G18*1.03>189599.99,(189600*P18),D27*1.03)),0)","v":0},0,0,{"$f":"IF(Q18>0,IF(G18>189599.99,(189600*Q18),IF((G18*1.03*1.03)>189599.99,(189600*Q18),G27*1.03)),0)","v":0},0,0,{"$f":"IF(R18>0,IF(E15>189599.99,D27,IF(G18*1.03*1.03*1.03>189599.99,(189600*R18),J27*1.03)),0)","v":0},0,0,0,0,0,0,0]
["Totals",null,null,{"$f":"SUM(D22:D27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":19},{"v":0.583,"d":"58.3%"}]
["Justify the need for cost sharing.",{"$nulls":8},"If Other Costs are cost shared, please provide justification in the box to the left.",{"$nulls":3},"Personnel Costs",null,null,{"$f":"F28+I28+L28+O28+R28","v":{"v":0,"d":"$0"}},null,null,{"v":0.014,"d":"1.4%"}]
[{"$nulls":13},"Other Costs",{"$nulls":5},{"v":0.375,"d":"37.5%"}]
[{"$nulls":13},"Total Cost Sharing",null,null,{"$f":"Q30+Q31","v":{"v":0,"d":"$0"}},null,null,"Grad"]
[]
[{"$nulls":17},"Revised: 9/24/18"]