{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MAIN SHEET"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MAIN SHEET","index":0,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,0,1,11],[30,0,30,1],[31,0,31,1],[34,0,34,3],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[20,0,20,3],[27,0,27,1],[28,0,28,1],[29,0,29,1],[22,0,22,1],[46,0,46,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[58,10,58,11],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[44,0,44,3],[37,0,37,3],[38,0,38,3],[35,0,35,3],[32,0,32,3],[43,0,43,3],[50,0,50,3],[53,0,53,3],[54,0,54,3],[55,0,55,3],[47,0,47,3],[48,0,48,3],[49,0,49,3],[52,0,52,3],[66,0,66,6],[56,0,56,3],[57,0,57,3],[61,0,61,3],[58,0,58,3],[63,0,63,3]]}
[]
["JHFE Research Enhancement Grant Budget Sheet"]
["PI name:"]
["Project title:"]
["Start date:"]
["End date:"]
[" "]
["MAXIUM:  $75,000 / One Year",null,null,"Start date"]
[null,null,null,"End date"]
["Salaries (Name)","Current salary","Adj salary","Effort %","Year 1",null,"TOTAL","Cal Mos."]
[null,0,{"$f":"IF(B11>J37,J37,B11)","v":0},0,{"$f":"ROUND(C11*D11,0)","v":0},null,{"$f":"SUM(E11:E11)","v":0},{"$f":"D11*12","v":0}]
[null,0,{"$f":"IF(B12>J37,J37,B12)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B13>J37,J37,B13)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B14>J37,J37,B14)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B15>J37,J37,B15)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B16>J37,J37,B16)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B17>J37,J37,B17)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B18>J37,J37,B18)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B19>J37,J37,B19)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B20>J37,J37,B20)","v":0},0,0,null,0,0]
["TOTALS",null,null,null,{"$f":"SUM(E11:E20)","v":0},null,0]
["Fringe benefits",null,"GRA","Fringe %","Year 1",null,"TOTAL"]
[{"$f":"IF(ISBLANK(A11),\"\",A11)","v":""},null,null,{"$f":"IF(C23=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C23=\"GRA\",J39,E11*D23),0)","v":0},null,{"$f":"SUM(E23:E23)","v":0}]
["",null,null,{"$f":"IF(C24=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C24=\"GRA\",J39,E12*D24),0)","v":0},null,0]
["",null,null,{"$f":"IF(C25=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C25=\"GRA\",J39,E13*D25),0)","v":0},null,0]
["",null,null,{"$f":"IF(C26=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C26=\"GRA\",J39,E14*D26),0)","v":0},null,0]
["",null,null,{"$f":"IF(C27=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C27=\"GRA\",J39,E15*D27),0)","v":0},null,0]
["",null,null,{"$f":"IF(C28=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C28=\"GRA\",J39,E16*D28),0)","v":0},null,0]
["",null,null,{"$f":"IF(C29=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C29=\"GRA\",J39,E17*D29),0)","v":0},null,0]
["",null,null,{"$f":"IF(C30=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C30=\"GRA\",J39,E18*D30),0)","v":0},null,0]
["",null,null,{"$f":"IF(C31=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C31=\"GRA\",J39,E19*D31),0)","v":0},null,0]
["",null,null,{"$f":"IF(C32=\"GRA\",0,J38)","v":0},{"$f":"ROUND(IF(C32=\"GRA\",J39,E20*D32),0)","v":0},null,0]
["TOTALS",null,null,null,{"$f":"SUM(E23:E32)","v":0},null,0]
["Supplies",null,null,null,"Year 1",null,"TOTAL"]
[null,null,null,null,null,null,{"$f":"SUM(E35)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E35:E35),0)","v":0},null,{"$f":"ROUND(SUM(E36:E36),0)","v":0}]
["Patient care costs",null,null,null,"Year 1",null,"TOTAL"]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(E38:E38),0)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(E39:E39),0)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(E40:E40),0)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(E41:E41),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E38:E41),0)","v":0},null,{"$f":"ROUND(SUM(E42:E42),0)","v":0}]
["Tuition",null,null,null,"Year 1",null,"TOTAL"]
[{"$f":"COUNTIF(C23:C32,\"GRA\")","v":0},null,null,null,{"$f":"ROUND(IF(A44>0,A44*J40,0),0)","v":0},null,{"$f":"ROUND(SUM(E44:E44),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E44),0)","v":0},null,{"$f":"ROUND(SUM(E45:E45),0)","v":0}]
["Other expenses",null,null,null,"Year 1",null,"TOTAL"]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E47:E47),0)","v":0}]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E48:E48),0)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(E49:E49),0)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(E50:E50),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E47:E50),0)","v":0},null,{"$f":"ROUND(SUM(E51:E51),0)","v":0}]
["DETAILED BUDGET TOTALS",null,null,null,"Year 1",null,"TOTAL"]
["Salary",null,null,null,{"$f":"E21","v":0},null,{"$f":"ROUND(SUM(E53:E53),0)","v":0}]
["Fringe",null,null,null,{"$f":"E33","v":0},null,0]
["Supplies",null,null,null,{"$f":"E36","v":0},null,0]
["Patient care costs",null,null,null,{"$f":"E42","v":0},null,0]
["Tuition",null,null,null,{"$f":"E45","v":0},null,0]
["Other expenses",null,null,null,{"$f":"E51","v":0},null,0]
["DIRECT COST SUBTOTAL",null,null,null,{"$f":"ROUND(SUM(E53:E58),0)","v":0},null,0]
[]
[]
["TOTAL COSTS",null,null,null,{"$f":"SUM(E53:E58)","v":0},null,{"$f":"SUM(G59)","v":0}]
[]
["TARGET ANNUAL DIRECT COSTS",null,null,null,75000,null,{"$f":"SUM(E64:E64)","v":75000}]
[]
["COMMENTS"]