{"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":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[55,0,55,3],[58,0,58,3],[62,0,62,3],[63,0,63,3],[52,0,52,3],[50,0,50,3],[63,10,63,11],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[49,0,49,3],[47,0,47,3],[32,0,32,3],[56,0,56,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[53,0,53,3],[54,0,54,3],[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]]}
[]
["SOMRC Basic Grant Budget Sheet"]
["PI name:"]
["Project title:"]
["Start date:"]
["End date:"]
[" "]
[null,null,null,"Start date"]
[null,null,null,"End date"]
["Salaries *No faculty salary allowed*","Current salary","Adj salary","Effort %","Year 1",null,"TOTAL","Cal Mos."]
[null,0,{"$f":"IF(B11>J49,J49,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>J49,J49,B12)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B13>J49,J49,B13)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B14>J49,J49,B14)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B15>J49,J49,B15)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B16>J49,J49,B16)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B17>J49,J49,B17)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B18>J49,J49,B18)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B19>J49,J49,B19)","v":0},0,0,null,0,0]
[null,0,{"$f":"IF(B20>J49,J49,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,J50)","v":0},{"$f":"ROUND(IF(C23=\"GRA\",#REF!,E11*D23),0)","v":0},null,{"$f":"SUM(E23:E23)","v":0}]
["",null,null,{"$f":"IF(C24=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C24=\"GRA\",#REF!,E12*D24),0)","v":0},null,0]
["",null,null,{"$f":"IF(C25=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C25=\"GRA\",#REF!,E13*D25),0)","v":0},null,0]
["",null,null,{"$f":"IF(C26=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C26=\"GRA\",#REF!,E14*D26),0)","v":0},null,0]
["",null,null,{"$f":"IF(C27=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C27=\"GRA\",#REF!,E15*D27),0)","v":0},null,0]
["",null,null,{"$f":"IF(C28=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C28=\"GRA\",#REF!,E16*D28),0)","v":0},null,0]
["",null,null,{"$f":"IF(C29=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C29=\"GRA\",#REF!,E17*D29),0)","v":0},null,0]
["",null,null,{"$f":"IF(C30=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C30=\"GRA\",#REF!,E18*D30),0)","v":0},null,0]
["",null,null,{"$f":"IF(C31=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C31=\"GRA\",#REF!,E19*D31),0)","v":0},null,0]
["",null,null,{"$f":"IF(C32=\"GRA\",0,J50)","v":0},{"$f":"ROUND(IF(C32=\"GRA\",#REF!,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,0,null,{"$f":"SUM(E35)","v":0}]
[null,null,null,null,0,null,{"$f":"SUM(E36)","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E35:E47),0)","v":0},null,{"$f":"ROUND(SUM(E48:E48),0)","v":0}]
["Patient care costs",null,null,null,"Year 1",null,"TOTAL"]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E50:E50),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E50:E50),0)","v":0},null,{"$f":"ROUND(SUM(E51:E51),0)","v":0}]
["Other expenses",null,null,null,"Year 1",null,"TOTAL"]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E53:E53),0)","v":0}]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E54:E54),0)","v":0}]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E55:E55),0)","v":0}]
[null,null,null,null,0,null,{"$f":"ROUND(SUM(E56:E56),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E53:E56),0)","v":0},null,{"$f":"ROUND(SUM(E57:E57),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(E59:E59),0)","v":0}]
["Fringe",null,null,null,{"$f":"E33","v":0},null,0]
["Supplies",null,null,null,{"$f":"E48","v":0},null,0]
["Patient care costs",null,null,null,{"$f":"E51","v":0},null,0]
["Other expenses",null,null,null,{"$f":"E57","v":0},null,0]
["DIRECT COST SUBTOTAL",null,null,null,{"$f":"ROUND(SUM(E59:E63),0)","v":0},null,0]