{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["MAIN SHEET","SUBCONTRACTS","NIH 424 ITEMS","ADDL NARR JUSTIF","PCF BUDGET INFO","INSTRUCTIONS"],"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":103,"n_cols":16,"rows_kept":103,"cut":false,"hidden":false,"merged":[[88,0,88,3],[103,0,103,7],[89,0,89,3],[90,0,90,3],[91,0,91,3],[95,0,95,3],[98,0,98,3],[96,0,96,3],[92,0,92,3],[94,0,94,3],[100,0,100,3],[87,0,87,3],[79,0,79,3],[82,0,82,3],[83,0,83,3],[84,0,84,3],[85,0,85,3],[76,0,76,3],[77,0,77,3],[78,0,78,3],[81,0,81,3],[86,0,86,3],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[73,0,73,3],[45,0,45,3],[46,0,46,3],[43,0,43,3],[32,0,32,3],[40,0,40,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[61,0,61,3],[62,0,62,3],[52,0,52,3],[55,0,55,3],[56,0,56,3],[59,0,59,3],[60,0,60,3],[22,0,22,1],[69,0,69,3],[72,0,72,3],[70,0,70,3],[75,0,75,3],[63,0,63,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[64,0,64,3],[47,0,47,3],[48,0,48,3],[51,0,51,3],[53,0,53,3],[57,0,57,3],[49,0,49,3],[92,14,92,15],[1,0,1,15],[30,0,30,1],[31,0,31,1],[34,0,34,3],[42,0,42,3],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[20,0,20,3],[7,10,8,10],[27,0,27,1],[28,0,28,1],[29,0,29,1]]}
[]
["MAIN NIH R03 OR R21 MODULAR BUDGET SHEET"]
["PI name:"]
["Project title:"]
["Start date:",{"$f":"E8","v":"2016-07-01"}]
["End date:",{"$f":"F9","v":"2018-06-30"}]
["Cost of living % increase",0.03]
[null,null,null,"Start date","2016-07-01",{"$f":"EDATE(E8,12)","v":"2017-07-01"},null,null,null,null,"COST SHARE",{"$f":"E8","v":"2016-07-01"},{"$f":"F8","v":"2017-07-01"}]
[null,null,null,"End date",{"$f":"F8-1","v":"2017-06-30"},{"$f":"EDATE(E9,12)","v":"2018-06-30"},null,null,null,null,null,{"$f":"E9","v":"2017-06-30"},{"$f":"F9","v":"2018-06-30"}]
["Salaries (Name)","Current salary","Adj salary","Effort %","Year 1","Year 2",null,"TOTAL","Cal Mos.",null,"Salaries","Year 1","Year 2",null,"TOTAL","Speedtype"]
[null,0,{"$f":"IF(B11>L35,L35,B11)","v":0},0,{"$f":"ROUND(C11*D11,0)","v":0},{"$f":"IF(B11>L35,C11*D11,ROUND(E11*(1+B7),0))","v":0},null,{"$f":"SUM(E11:F11)","v":0},{"$f":"D11*12","v":0},null,{"$f":"IF(B11>L35,A11,\"\")","v":""},{"$f":"ROUND(IF(K11=\"\",0,(ROUND(((B11-C11)*D11),0))),0)","v":0},{"$f":"ROUND(L11*(1+B7),0)","v":0},null,{"$f":"ROUND(SUM(L11:M11),0)","v":0}]
[null,0,{"$f":"IF(B12>L35,L35,B12)","v":0},0,0,{"$f":"IF(B12>L35,C12*D12,ROUND(E12*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B12>L35,A12,\"\")","v":""},0,{"$f":"ROUND(L12*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B13>L35,L35,B13)","v":0},0,0,{"$f":"IF(B13>L35,C13*D13,ROUND(E13*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B13>L35,A13,\"\")","v":""},0,{"$f":"ROUND(L13*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B14>L35,L35,B14)","v":0},0,0,{"$f":"IF(B14>L35,C14*D14,ROUND(E14*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B14>L35,A14,\"\")","v":""},0,{"$f":"ROUND(L14*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B15>L35,L35,B15)","v":0},0,0,{"$f":"IF(B15>L35,C15*D15,ROUND(E15*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B15>L35,A15,\"\")","v":""},0,{"$f":"ROUND(L15*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B16>L35,L35,B16)","v":0},0,0,{"$f":"IF(B16>L35,C16*D16,ROUND(E16*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B16>L35,A16,\"\")","v":""},0,{"$f":"ROUND(L16*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B17>L35,L35,B17)","v":0},0,0,{"$f":"IF(B17>L35,C17*D17,ROUND(E17*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B17>L35,A17,\"\")","v":""},0,{"$f":"ROUND(L17*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B18>L35,L35,B18)","v":0},0,0,{"$f":"IF(B18>L35,C18*D18,ROUND(E18*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B18>L35,A18,\"\")","v":""},0,{"$f":"ROUND(L18*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B19>L35,L35,B19)","v":0},0,0,{"$f":"IF(B19>L35,C19*D19,ROUND(E19*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B19>L35,A19,\"\")","v":""},0,{"$f":"ROUND(L19*(1+B7),0)","v":0},null,0]
[null,0,{"$f":"IF(B20>L35,L35,B20)","v":0},0,0,{"$f":"IF(B20>L35,C20*D20,ROUND(E20*(1+B7),0))","v":0},null,0,0,null,{"$f":"IF(B20>L35,A20,\"\")","v":""},0,{"$f":"ROUND(L20*(1+B7),0)","v":0},null,0]
["TOTALS",null,null,null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},null,0,null,null,"TOTALS",{"$f":"ROUND(SUM(L11:L20),0)","v":0},{"$f":"ROUND(SUM(M11:M20),0)","v":0},null,0]
["Fringe benefits",null,"GRA","Fringe %","Year 1","Year 2",null,"TOTAL",null,null,"Fringe benefits","Year 1","Year 2",null,"TOTAL","Speedtype"]
[{"$f":"IF(ISBLANK(A11),\"\",A11)","v":""},null,null,{"$f":"IF(C23=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C23=\"GRA\",L37,E11*D23),0)","v":0},{"$f":"ROUND(IF(C23=\"GRA\",E23*(1+B7),F11*D23),0)","v":0},null,{"$f":"SUM(E23:F23)","v":0},null,null,{"$f":"IF(ISBLANK(K11),\"\",K11)","v":""},{"$f":"ROUND(L11*D23,0)","v":0},{"$f":"ROUND(M11*D23,0)","v":0},null,{"$f":"ROUND(SUM(L23:M23),0)","v":0},{"$f":"IF(ISBLANK(P11),\"\",P11)","v":""}]
[{"$f":"IF(ISBLANK(A12),\"\",A12)","v":""},null,null,{"$f":"IF(C24=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C24=\"GRA\",L37,E12*D24),0)","v":0},{"$f":"ROUND(IF(C24=\"GRA\",E24*(1+B7),F12*D24),0)","v":0},null,0,null,null,{"$f":"IF(ISBLANK(K12),\"\",K12)","v":""},0,0,null,0,{"$f":"IF(ISBLANK(P12),\"\",P12)","v":""}]
["",null,null,{"$f":"IF(C25=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C25=\"GRA\",L37,E13*D25),0)","v":0},{"$f":"ROUND(IF(C25=\"GRA\",E25*(1+B7),F13*D25),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C26=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C26=\"GRA\",L37,E14*D26),0)","v":0},{"$f":"ROUND(IF(C26=\"GRA\",E26*(1+B7),F14*D26),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C27=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C27=\"GRA\",L37,E15*D27),0)","v":0},{"$f":"ROUND(IF(C27=\"GRA\",E27*(1+B7),F15*D27),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C28=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C28=\"GRA\",L37,E16*D28),0)","v":0},{"$f":"ROUND(IF(C28=\"GRA\",E28*(1+B7),F16*D28),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C29=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C29=\"GRA\",L37,E17*D29),0)","v":0},{"$f":"ROUND(IF(C29=\"GRA\",E29*(1+B7),F17*D29),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C30=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C30=\"GRA\",L37,E18*D30),0)","v":0},{"$f":"ROUND(IF(C30=\"GRA\",E30*(1+B7),F18*D30),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C31=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C31=\"GRA\",L37,E19*D31),0)","v":0},{"$f":"ROUND(IF(C31=\"GRA\",E31*(1+B7),F19*D31),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C32=\"GRA\",0,L36)","v":0.28499999999999998},{"$f":"ROUND(IF(C32=\"GRA\",L37,E20*D32),0)","v":0},{"$f":"ROUND(IF(C32=\"GRA\",E32*(1+B7),F20*D32),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["TOTALS",null,null,null,{"$f":"SUM(E23:E32)","v":0},{"$f":"SUM(F23:F32)","v":0},null,0,null,null,"TOTALS",{"$f":"ROUND(SUM(L23:L32),0)","v":0},{"$f":"ROUND(SUM(M23:M32),0)","v":0},null,0]
["Equipment",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,null,null,null,{"$f":"SUM(E35:F35)","v":0},null,null,"NIH salary cap (1/15/15)",183300]
[null,null,null,null,null,null,null,0,null,null,"Fringe benefit rate",0.28499999999999998]
[null,null,null,null,null,null,null,0,null,null,"GRA insurance",2466]
[null,null,null,null,null,null,null,0,null,null,"GRA tuition",3894]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E35:E40),0)","v":0},{"$f":"ROUND(SUM(F35:F40),0)","v":0},null,{"$f":"ROUND(SUM(E41:F41),0)","v":0}]
["Supplies",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,{"$f":"ROUND(E101-E82-E83-E84-E86-E87-E88-SUBCONTRACTS!B50-E90-E91-E92,0)","v":150000},{"$f":"ROUND(F101-F82-F83-F84-F86-F87-F88-SUBCONTRACTS!C50-F90-F91-F92,0)","v":125000},null,{"$f":"ROUND(SUM(E43:F43),0)","v":275000}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E43:E43),0)","v":150000},{"$f":"ROUND(SUM(F43:F43),0)","v":125000},null,{"$f":"ROUND(SUM(E44:F44),0)","v":275000}]
["Patient care costs",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E46:F46),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E47:F47),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E48:F48),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E49:F49),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E46:E49),0)","v":0},{"$f":"ROUND(SUM(F46:F49),0)","v":0},null,{"$f":"ROUND(SUM(E50:F50),0)","v":0}]
["Alterations/renovations",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E52:F52),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E53:F53),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E52:E53),0)","v":0},{"$f":"ROUND(SUM(F52:F53),0)","v":0},null,{"$f":"ROUND(SUM(E54:F54),0)","v":0}]
["Off-site rentals",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E56:F56),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E57:F57),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E56:E57),0)","v":0},{"$f":"ROUND(SUM(F56:F57),0)","v":0},null,{"$f":"ROUND(SUM(E58:F58),0)","v":0}]
["Subcontracts",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[{"$f":"IF(ISBLANK(SUBCONTRACTS!B4),\"\",SUBCONTRACTS!B4)","v":""},null,null,null,{"$f":"SUBCONTRACTS!B9","v":0},{"$f":"SUBCONTRACTS!C9","v":0},null,{"$f":"ROUND(SUM(E60:F60),0)","v":0}]
[{"$f":"IF(ISBLANK(SUBCONTRACTS!B13),\"\",SUBCONTRACTS!B13)","v":""},null,null,null,{"$f":"SUBCONTRACTS!B18","v":0},{"$f":"SUBCONTRACTS!C18","v":0},null,0]
[{"$f":"IF(ISBLANK(SUBCONTRACTS!B22),\"\",SUBCONTRACTS!B22)","v":""},null,null,null,{"$f":"SUBCONTRACTS!B27","v":0},{"$f":"SUBCONTRACTS!C27","v":0},null,0]
[{"$f":"IF(ISBLANK(SUBCONTRACTS!B31),\"\",SUBCONTRACTS!B31)","v":""},null,null,null,{"$f":"SUBCONTRACTS!B36","v":0},{"$f":"SUBCONTRACTS!C36","v":0},null,0]
[{"$f":"IF(ISBLANK(SUBCONTRACTS!B40),\"\",SUBCONTRACTS!B40)","v":""},null,null,null,{"$f":"SUBCONTRACTS!B45","v":0},{"$f":"SUBCONTRACTS!C45","v":0},null,0]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E60:E64),0)","v":0},{"$f":"ROUND(SUM(F60:F64),0)","v":0},null,0]
["Travel",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E67:F67),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E68:F68),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E69:F69),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E70:F70),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E67:E70),0)","v":0},{"$f":"ROUND(SUM(F67:F70),0)","v":0},null,{"$f":"ROUND(SUM(E71:F71),0)","v":0}]
["Tuition",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[{"$f":"COUNTIF(C23:C32,\"GRA\")","v":0},null,null,null,{"$f":"ROUND(IF(A73>0,A73*L38,0),0)","v":0},{"$f":"ROUND(IF(E73=\"\",\"\",E73*(1+B7)),0)","v":0},null,{"$f":"ROUND(SUM(E73:F73),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E73),0)","v":0},{"$f":"ROUND(SUM(F73),0)","v":0},null,{"$f":"ROUND(SUM(E74:F74),0)","v":0}]
["Other expenses",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E76:F76),0)","v":0}]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E77:F77),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E78:F78),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E79:F79),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E76:E79),0)","v":0},{"$f":"ROUND(SUM(F76:F79),0)","v":0},null,{"$f":"ROUND(SUM(E80:F80),0)","v":0}]
["DETAILED BUDGET TOTALS",null,null,null,"Year 1","Year 2",null,"TOTAL"]
["Salary",null,null,null,{"$f":"E21","v":0},{"$f":"F21","v":0},null,{"$f":"ROUND(SUM(E82:F82),0)","v":0}]
["Fringe",null,null,null,{"$f":"E33","v":0},{"$f":"F33","v":0},null,0]
["Equipment",null,null,null,{"$f":"E41","v":0},{"$f":"F41","v":0},null,0]
["Supplies",null,null,null,{"$f":"E44","v":150000},{"$f":"F44","v":125000},null,275000]
["Patient care costs",null,null,null,{"$f":"E50","v":0},{"$f":"F50","v":0},null,0]
["Alterations/renovations",null,null,null,{"$f":"E54","v":0},{"$f":"F54","v":0},null,0]
["Off-site rentals",null,null,null,{"$f":"E58","v":0},{"$f":"F58","v":0},null,0]
["Subcontracts",null,null,null,{"$f":"E65","v":0},{"$f":"F65","v":0},null,0]
["Travel",null,null,null,{"$f":"E71","v":0},{"$f":"F71","v":0},null,0]
["Tuition",null,null,null,{"$f":"E74","v":0},{"$f":"F74","v":0},null,0]
["Other expenses",null,null,null,{"$f":"E80","v":0},{"$f":"F80","v":0},null,0]
["DIRECT COST SUBTOTAL",null,null,null,{"$f":"ROUND(SUM(E82:E92),0)","v":150000},{"$f":"ROUND(SUM(F82:F92),0)","v":125000},null,275000,null,null,null,null,null,null,"F/A calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01",{"$f":"(0.25*0.53)+(0.75*0.54)","v":0.53750000000000009}]
["MODIFIED TOTAL DIRECT COSTS",null,null,null,{"$f":"ROUND(SUM(E82+E83+E85+E90+E92+SUBCONTRACTS!B48),0)","v":150000},{"$f":"ROUND(SUM(F82+F83+F85+F90+F92+SUBCONTRACTS!C48),0)","v":125000},null,{"$f":"ROUND(SUM(E95:F95),0)","v":275000},null,null,null,null,null,null,"2016-05-01",{"$f":"((2/12)*0.53)+((10/12)*0.54)","v":0.53833333333333344}]
["F/A RATE",null,null,null,{"$f":"IF(E8=O94,P94,IF(E8=O95,P95,IF(E8=O96,P96,IF(E8=O97,P97,0.54))))","v":0.54},0.54,null,null,null,null,null,null,null,null,"2016-06-01",{"$f":"((1/12)*0.53)+((11/12)*0.54)","v":0.53916666666666668}]
["F&A SUBTOTAL",null,null,null,{"$f":"ROUND(E95*E96,0)","v":81000},{"$f":"ROUND(F95*F96,0)","v":67500},null,{"$f":"ROUND(SUM(E97:F97),0)","v":148500},null,null,null,null,null,null,"2016-07-01",0.54]
[]
["TOTAL COSTS",null,null,null,{"$f":"ROUND(SUM(E93,E97),0)","v":231000},{"$f":"ROUND(SUM(F93,F97),0)","v":192500},null,{"$f":"ROUND(SUM(E99,F99),0)","v":423500}]
[]
["TARGET ANNUAL DIRECT COSTS",null,null,null,150000,125000,null,{"$f":"SUM(E101:F101)","v":275000}]
[]
["COMMENTS"]

{"sheet":"SUBCONTRACTS","index":1,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,0,1,4],[39,1,39,4],[40,1,40,4],[22,1,22,4],[30,1,30,4],[31,1,31,4],[2,0,2,4],[38,0,38,4],[11,0,11,4],[20,0,20,4],[29,0,29,4],[3,1,3,4],[4,1,4,4],[12,1,12,4],[13,1,13,4],[21,1,21,4]]}
[]
["SUBCONTRACTS PAGE"]
["Subcontract 1"]
["Institution"]
["Principal Investigator"]
[null,"Year 1","Year 2",null,"TOTAL"]
["Direct costs",null,null,null,{"$f":"SUM(B7:C7)","v":0}]
["Indirect costs",null,null,null,{"$f":"SUM(B8:C8)","v":0}]
["TOTALS",{"$f":"SUM(B7:B8)","v":0},{"$f":"SUM(C7:C8)","v":0},null,{"$f":"SUM(B9,C9)","v":0}]
["AMT INCLUDED IN UL F/A",{"$f":"IF(B9>25000,25000,B9)","v":0},{"$f":"IF((B9+C9)<25000,C9,IF((25000-B9)<0,0,25000-B9))","v":0}]
[]
["Subcontract 2"]
["Institution"]
["Principal Investigator"]
[null,"Year 1","Year 2",null,"TOTAL"]
["Direct costs",null,null,null,{"$f":"SUM(B16:C16)","v":0}]
["Indirect costs",null,null,null,{"$f":"SUM(B17:C17)","v":0}]
["TOTALS",{"$f":"SUM(B16:B17)","v":0},{"$f":"SUM(C16:C17)","v":0},null,{"$f":"SUM(B18,C18)","v":0}]
["AMT INCLUDED IN UL F/A",{"$f":"IF(B18>25000,25000,B18)","v":0},{"$f":"IF((B18+C18)<25000,C18,IF((25000-B18)<0,0,25000-B18))","v":0}]
[]
["Subcontract 3"]
["Institution"]
["Principal Investigator"]
[null,"Year 1","Year 2",null,"TOTAL"]
["Direct costs",null,null,null,{"$f":"SUM(B25:C25)","v":0}]
["Indirect costs",null,null,null,{"$f":"SUM(B26:C26)","v":0}]
["TOTALS",{"$f":"SUM(B25:B26)","v":0},{"$f":"SUM(C25:C26)","v":0},null,{"$f":"SUM(B27,C27)","v":0}]
["AMT INCLUDED IN UL F/A",{"$f":"IF(B27>25000,25000,B27)","v":0},{"$f":"IF((B27+C27)<25000,C27,IF((25000-B27)<0,0,25000-B27))","v":0}]
[]
["Subcontract 4"]
["Institution"]
["Principal Investigator"]
[null,"Year 1","Year 2",null,"TOTAL"]
["Direct costs",null,null,null,{"$f":"SUM(B34:C34)","v":0}]
["Indirect costs",null,null,null,{"$f":"SUM(B35:C35)","v":0}]
["TOTALS",{"$f":"SUM(B34:B35)","v":0},{"$f":"SUM(C34:C35)","v":0},null,{"$f":"SUM(B36,C36)","v":0}]
["AMT INCLUDED IN UL F/A",{"$f":"IF(B36>25000,25000,B36)","v":0},{"$f":"IF((B36+C36)<25000,C36,IF((25000-B36)<0,0,25000-B36))","v":0}]
[]
["Subcontract 5"]
["Institution"]
["Principal Investigator"]
[null,"Year 1","Year 2",null,"TOTAL"]
["Direct costs",null,null,null,{"$f":"SUM(B43:C43)","v":0}]
["Indirect costs",null,null,null,{"$f":"SUM(B44:C44)","v":0}]
["TOTALS",{"$f":"SUM(B43:B44)","v":0},{"$f":"SUM(C43:C44)","v":0},null,{"$f":"SUM(B45,C45)","v":0}]
["AMT INCLUDED IN UL F/A",{"$f":"IF(B45>25000,25000,B45)","v":0},{"$f":"IF((B45+C45)<25000,C45,IF((25000-B45)<0,0,25000-B45))","v":0}]
[]
["TOTAL AMT INCLUDED IN UL F/A",{"$f":"SUM(B10,B19,B28,B37,B46)","v":0},{"$f":"SUM(C10,C19,C28,C37,C46)","v":0},null,{"$f":"SUM(B48:C48)","v":0}]
["TOTAL AMT EXCLUDED FROM UL F/A",{"$f":"SUM(B9,B18,B27,B36,B45)-B48","v":0},{"$f":"SUM(C9,C18,C27,C36,C45)-C48","v":0},null,{"$f":"SUM(B49:C49)","v":0}]
["TOTAL SUBCONTRACTOR DIRECT COSTS",{"$f":"SUM(B7,B16,B25,B34,B43)","v":0},0,null,{"$f":"SUM(B50:C50)","v":0}]
["TOTAL SUBCONTRACTOR INDIRECT COSTS",0,0,null,{"$f":"SUM(B51:C51)","v":0}]
["TOTAL SUBCONTRACTOR COSTS",0,0,null,{"$f":"SUM(B52:C52)","v":0}]

{"sheet":"NIH 424 ITEMS","index":2,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,0,33,4],[34,0,34,4],[35,0,35,4],[3,0,3,5],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[4,3,4,5],[5,3,5,5],[30,0,30,5],[31,0,31,4],[32,0,32,4],[24,0,24,4],[14,0,14,4],[20,0,20,5],[22,2,22,4],[23,0,23,4],[1,0,1,18],[12,2,12,4],[10,0,10,5],[13,0,13,4],[6,3,6,5],[7,3,7,5],[16,7,16,10]]}
[]
["NIH 424 ITEMS"]
[]
["SF 424 (R&R)",null,null,null,null,null,null,null,null,null,"Cognizant Federal Agency","DHHS,  Louis Martillotti, 212-264-2069 "]
["11. Descriptive title",null,null,{"$f":"'MAIN SHEET'!B4","v":0},null,null,null,null,null,null,"Indirect Cost Agreement Date","2015-04-29"]
["12. Project period",null,null,{"$f":"TEXT('MAIN SHEET'!B5, \"mm/dd/yyyy\")&\" - \"&TEXT('MAIN SHEET'!B6, \"mm/dd/yyyy\")","v":"07/01/2016 - 06/30/2018"}]
["15a. Total federal funds requested",null,null,{"$f":"'MAIN SHEET'!H99","v":423500},null,null,null,null,null,null,"FACILITIES AND ADMINISTRATION (F&A) costs are requested and calculated in accordance with the University’s current Rate Agreement established with DHHS. An F&A rate of 53% MTDC is the applicable rate for on-campus sponsored research during the proposed project period effective 07/01/2015 – 06/30/2016 and is 54% effective 7/1/2016 – 06/30/2018."]
["15c. Total federal and non-federal funds",null,null,{"$f":"D7","v":423500}]
[]
[]
["Budget period 1"]
["Start date","End date",null,null,null,"Funds requested"]
[{"$f":"'MAIN SHEET'!E8","v":"2016-07-01"},{"$f":"'MAIN SHEET'!E9","v":"2017-06-30"},"Direct costs less consortium F&A",null,null,{"$f":"'MAIN SHEET'!E93-SUBCONTRACTS!B51","v":150000}]
["Consortium F&A",null,null,null,null,{"$f":"SUBCONTRACTS!B51","v":0}]
["Total direct costs",null,null,null,null,{"$f":"SUM(F13:F14)","v":150000}]
[]
[null,null,"Indirect cost type","Indirect cost rate (%)","Indirect cost base ($)","Funds requested",null,"F/A calculations"]
[null,null,"MTDC",{"$f":"IF(OR(A13=H18,A13=H19,A13=H20),0.53,0.54)","v":0.54},{"$f":"IF(A13=H18,'MAIN SHEET'!E95*J18,IF(A13=H19,'MAIN SHEET'!E95*J19,IF(A13=H20,'MAIN SHEET'!E95*J20,'MAIN SHEET'!E95)))","v":150000},{"$f":"D18*E18","v":81000},null,"2016-04-01",{"$f":"(0.25*0.53)+(0.75*0.54)","v":0.53750000000000009},{"$f":"3/12","v":0.25},{"$f":"1-J18","v":0.75}]
[null,null,{"$f":"IF(OR(A13=H18,A13=H19,A13=H20),\"MTDC\",\"\")","v":""},{"$f":"IF(OR(A13=H18,A13=H19,A13=H20),0.54,\"\")","v":""},{"$f":"IF(A13=H18,'MAIN SHEET'!E95*K18,IF(A13=H19,'MAIN SHEET'!E95*K19,IF(A13=H20,'MAIN SHEET'!E95*(K20),0)))","v":0},{"$f":"IF(E19=0,0,E19*D19)","v":0},null,"2016-05-01",{"$f":"((2/12)*0.53)+((10/12)*0.54)","v":0.53833333333333344},{"$f":"2/12","v":0.16666666666666666},{"$f":"1-J19","v":0.83333333333333337}]
[null,null,null,null,null,null,null,"2016-06-01",{"$f":"((1/12)*0.53)+((11/12)*0.54)","v":0.53916666666666668},{"$f":"1/12","v":8.3333333333333329E-2},0.91666666666666663]
["Budget period 2",null,null,null,null,null,null,"2016-07-01",0.54]
["Start date","End date",null,null,null,"Funds requested"]
[{"$f":"'MAIN SHEET'!F8","v":"2017-07-01"},{"$f":"'MAIN SHEET'!F9","v":"2018-06-30"},"Direct costs less consortium F&A",null,null,{"$f":"'MAIN SHEET'!F93-SUBCONTRACTS!C51","v":125000}]
["Consortium F&A",null,null,null,null,{"$f":"SUBCONTRACTS!C51","v":0}]
["Total direct costs",null,null,null,null,{"$f":"SUM(F23:F24)","v":125000}]
[]
[null,null,"Indirect cost type","Indirect cost rate (%)","Indirect cost base ($)","Funds requested"]
[null,null,"MTDC",{"$f":"'MAIN SHEET'!F96","v":0.54},{"$f":"'MAIN SHEET'!F95","v":125000},{"$f":"'MAIN SHEET'!F97","v":67500}]
[]
[]
["1. Total Costs, Entire Project Period"]
["Section A, Total Direct Cost less Consortium F&A for Entire Project Period",null,null,null,null,{"$f":"'MAIN SHEET'!H93-SUBCONTRACTS!E51","v":275000}]
["Section A, Total Consortium F&A for Entire Project Period",null,null,null,null,{"$f":"SUBCONTRACTS!E51","v":0}]
["Section A, Total Direct Costs Entire Project Period",null,null,null,null,{"$f":"'MAIN SHEET'!H93","v":275000}]
["Section B, Total Indirect Costs for Entire Project Period",null,null,null,null,{"$f":"'MAIN SHEET'!H97","v":148500}]
["Section C, Total Direct and Indirect Costs (A+B) for Entire Project Period",null,null,null,null,{"$f":"'MAIN SHEET'!H99","v":423500}]

{"sheet":"ADDL NARR JUSTIF","index":3,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[3,0,3,3],[13,1,13,10]]}
[]
["Additional Narrative Justification"]
[]
["The following exclusions were applied to the F&A base calculations:"]
[null,"Year 1","Year 2","Total"]
["Equipment ≥$5K per item",{"$f":"'MAIN SHEET'!E41","v":0},{"$f":"'MAIN SHEET'!F41","v":0},{"$f":"SUM(B6:C6)","v":0}]
["Alteration/Renovation ≥$100K",{"$f":"'MAIN SHEET'!E54","v":0},{"$f":"'MAIN SHEET'!F54","v":0},0]
["Off-Site Rental",{"$f":"'MAIN SHEET'!E58","v":0},{"$f":"'MAIN SHEET'!F58","v":0},0]
["Patient Care",{"$f":"'MAIN SHEET'!E50","v":0},{"$f":"'MAIN SHEET'!F50","v":0},0]
["Subcontracts >$25,000",{"$f":"SUBCONTRACTS!B49","v":0},{"$f":"SUBCONTRACTS!C49","v":0},0]
["Tuition",{"$f":"'MAIN SHEET'!E74","v":0},{"$f":"'MAIN SHEET'!F74","v":0},0]
["Total Exclusions",{"$f":"SUM(B6:B11)","v":0},{"$f":"SUM(C6:C11)","v":0},0]
[]
["Difference in modules:","We are requesting an additional module in Year 1 because of additional experiments required."]
[]
[]
[]
[]
["Save selection as a PDF"]
["1) Click on the Highlight cells button above."]
["2) Click on File tab at the top left of this page."]
["3) Click on Save as Adobe PDF"]
["4) Dialog box will open "]
["5) In the top left, under Conversion Range, click Selection, then the Convert to PDF button"]
["6) Follow the rest of the directions you're given."]
[]
["Copying to a Word document"]
["1) Click on the Highlight cells button above."]
["2) Copy selection"]
["3) Paste in a Word document"]

{"sheet":"PCF BUDGET INFO","index":4,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,3,6,4],[1,0,1,16],[3,0,3,5],[33,0,33,5],[34,0,34,5],[32,0,32,5],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[37,1,37,3],[38,1,38,3]]}
[]
["PROPOSAL CLEARANCE FORM BUDGET PAGE INFO"]
[]
["#18c Entire Proposed Budget Period"]
[{"$f":"TEXT('MAIN SHEET'!B5, \"mm/dd/yyyy\")&\" - \"&TEXT('MAIN SHEET'!B6, \"mm/dd/yyyy\")","v":"07/01/2016 - 06/30/2018"}]
[]
["#18d Requested from sponsor",null,null,"#18f UofL Cost Share",null,"Speedtypes"]
["Salary & wages",{"$f":"'MAIN SHEET'!H21","v":0},null,"Salary & wages",{"$f":"'MAIN SHEET'!O21","v":0},{"$f":"IF(ISBLANK('MAIN SHEET'!P11),\"\",CONCATENATE('MAIN SHEET'!P11&\" (\"&'MAIN SHEET'!K11&\") \")\n\n&IF(ISBLANK('MAIN SHEET'!P12),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P12&\" (\"&'MAIN SHEET'!K12&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P13),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P13&\" (\"&'MAIN SHEET'!K13&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P14),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P14&\" (\"&'MAIN SHEET'!K14&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P15),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P15&\" (\"&'MAIN SHEET'!K15&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P16),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P16&\" (\"&'MAIN SHEET'!K16&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P17),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P17&\" (\"&'MAIN SHEET'!K17&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P18),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P18&\" (\"&'MAIN SHEET'!K18&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P19),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P19&\" (\"&'MAIN SHEET'!K19&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!P20),\"\",CONCATENATE(\", \"&'MAIN SHEET'!P20&\" (\"&'MAIN SHEET'!K20&\") \"))\n)","v":""}]
["Fringe benefits",{"$f":"'MAIN SHEET'!H33","v":0},null,"Fringe benefits",{"$f":"'MAIN SHEET'!O33","v":0},{"$f":"F8","v":""}]
["Equip ≥$5K per item",{"$f":"'MAIN SHEET'!H41","v":0},null,"Equip ≥$5K per item"]
["Alteration/Renovation ≥$100K",{"$f":"'MAIN SHEET'!H54","v":0},null,"Alteration/Renovation ≥$100K"]
["Subcontracts",{"$f":"'MAIN SHEET'!H65","v":0},null,"Subcontracts"]
["Supplies & expenses",{"$f":"SUM('MAIN SHEET'!H44,'MAIN SHEET'!H50,'MAIN SHEET'!H58,'MAIN SHEET'!H80)","v":275000},null,"Supplies & expenses"]
["Travel",{"$f":"'MAIN SHEET'!H71","v":0},null,"Travel"]
["Tuition",{"$f":"'MAIN SHEET'!H74","v":0},null,"Tuition"]
["TOTAL Direct Costs",{"$f":"SUM(B8:B15)","v":275000},null,"TOTAL Direct Costs",{"$f":"SUM(E8:E15)","v":0}]
[]
["#18g Exclusions to TDC Base"]
["Equipment ≥$5K per item (190000)",{"$f":"B10","v":0}]
["Alteration/Renovation ≥$100K (190000)",{"$f":"B11","v":0}]
["Off-Site Rental (519000)",{"$f":"'MAIN SHEET'!H58","v":0}]
["Patient Care (519000)",{"$f":"'MAIN SHEET'!H50","v":0}]
["Subcontract amounts in excess of first $25K on each (519000)",{"$f":"SUBCONTRACTS!E49","v":0}]
["Tuition (520000)",{"$f":"B15","v":0}]
["Other      "]
["Total Exclusions",{"$f":"SUM(B19:B25)","v":0}]
["Modified TDC Base (18e TDC minus 18h exclusions)",{"$f":"B16-B26","v":275000}]
[]
["TOTALS"]
["#18j F&A Indirect costs",{"$f":"'MAIN SHEET'!H97","v":148500}]
["#18k Total Cost of Project",{"$f":"'MAIN SHEET'!H99","v":423500}]
[]
["#18l Budget Remarks"]
[{"$f":"IF(('MAIN SHEET'!K11=\"\")*AND('MAIN SHEET'!K12=\"\")*AND('MAIN SHEET'!K13=\"\")*AND('MAIN SHEET'!K134=\"\")*AND('MAIN SHEET'!K15=\"\")*AND('MAIN SHEET'!K16=\"\")*AND('MAIN SHEET'!K17=\"\")*AND('MAIN SHEET'!K18=\"\")*AND('MAIN SHEET'!K19=\"\")*AND('MAIN SHEET'!K20=\"\"),\"\",\"1) The cost share is for the difference between the NIH salary cap and the actual salary for \")&IF('MAIN SHEET'!K11=\"\",\"\",'MAIN SHEET'!K11)&IF('MAIN SHEET'!K12=\"\",\"\",(\", \"&'MAIN SHEET'!K12))&IF('MAIN SHEET'!K13=\"\",\"\",(\", \"&'MAIN SHEET'!K13))&IF('MAIN SHEET'!K14=\"\",\"\",(\", \"&'MAIN SHEET'!K14))&IF('MAIN SHEET'!K15=\"\",\"\",(\", \"&'MAIN SHEET'!K15))&IF('MAIN SHEET'!K16=\"\",\"\",(\", \"&'MAIN SHEET'!K16))&IF('MAIN SHEET'!K17=\"\",\"\",(\", \"&'MAIN SHEET'!K17))&IF('MAIN SHEET'!K18=\"\",\"\",(\", \"&'MAIN SHEET'!K18))&IF('MAIN SHEET'!K19=\"\",\"\",(\", \"&'MAIN SHEET'!K19))&IF('MAIN SHEET'!K20=\"\",\"\",(\", \"&'MAIN SHEET'!K20))","v":""}]
[{"$f":"IF('MAIN SHEET'!A104=\"\",\"\",\"2) \"&'MAIN SHEET'!A104)","v":""}]
[]
["#19 Subcontracts to be issued"]
["Organization name","PI/Contact name",null,null,"Current year","Remain Years"]
[{"$f":"IF(SUBCONTRACTS!B4=\"\",\"\",SUBCONTRACTS!B4)","v":""},{"$f":"IF(SUBCONTRACTS!B5=\"\",\"\",SUBCONTRACTS!B5)","v":""},null,null,{"$f":"IF(SUBCONTRACTS!B9=0,\"\",SUBCONTRACTS!B9)","v":""},{"$f":"IF(SUBCONTRACTS!B4=\"\",\"\",SUBCONTRACTS!E9-SUBCONTRACTS!B9)","v":""}]
[{"$f":"IF(SUBCONTRACTS!B13=\"\",\"\",SUBCONTRACTS!B13)","v":""},{"$f":"IF(SUBCONTRACTS!B14=\"\",\"\",SUBCONTRACTS!B14)","v":""},null,null,{"$f":"IF(SUBCONTRACTS!B18=0,\"\",SUBCONTRACTS!B18)","v":""},{"$f":"IF(SUBCONTRACTS!E18=0,\"\",SUBCONTRACTS!E18-SUBCONTRACTS!B18)","v":""}]
[{"$f":"IF(SUBCONTRACTS!B22=\"\",\"\",SUBCONTRACTS!B22)","v":""},{"$f":"IF(SUBCONTRACTS!B23=\"\",\"\",SUBCONTRACTS!B23)","v":""},null,null,{"$f":"IF(SUBCONTRACTS!B27=0,\"\",SUBCONTRACTS!B27)","v":""},{"$f":"IF(SUBCONTRACTS!E27=0,\"\",SUBCONTRACTS!E27-SUBCONTRACTS!B27)","v":""}]
[{"$f":"IF(SUBCONTRACTS!B31=\"\",\"\",SUBCONTRACTS!B31)","v":""},{"$f":"IF(SUBCONTRACTS!B32=\"\",\"\",SUBCONTRACTS!B32)","v":""},null,null,{"$f":"IF(SUBCONTRACTS!B36=0,\"\",SUBCONTRACTS!B36)","v":""},{"$f":"IF(SUBCONTRACTS!E36=0,\"\",SUBCONTRACTS!E36-SUBCONTRACTS!B36)","v":""}]
[{"$f":"IF(SUBCONTRACTS!B40=\"\",\"\",SUBCONTRACTS!B40)","v":""},{"$f":"IF(SUBCONTRACTS!B41=\"\",\"\",SUBCONTRACTS!B41)","v":""},null,null,{"$f":"IF(SUBCONTRACTS!B45=0,\"\",SUBCONTRACTS!B45)","v":""},{"$f":"IF(SUBCONTRACTS!E45=0,\"\",SUBCONTRACTS!E45-SUBCONTRACTS!B45)","v":""}]

{"sheet":"INSTRUCTIONS","index":5,"n_rows":60,"n_cols":1,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
["PREPARATION"]
["Excel Tools Ad-Ins"]
["1) On the Excel toolbar, click on Tools, then Add-ins, and make sure that Analysis ToolPak is checked.  (This allows the dates at the top of the Main Sheet Years to be filled in automatically.)"]
["FORMATTING EXPLANATIONS"]
["Fillable areas"]
["Only the peach-colored cells can be filled in -- all other cells are calculated automatically."]
[]
["MAIN SHEET"]
["HEADER"]
["1) PI name: fill in the Principal Investigator's name (e.g., Mike Burry, MD)."]
["2) Project title: Fill in the title as it will be submitted to the NIH NO LONGER THAN 82 CHARACTERS (e.g., Impact of TB on HIV-infected patients)."]
["3) Start date: leave blank -- will be filled in automatically below."]
["4) End date: leave blank -- will be filled in automatically below."]
["3) COL%: use the drop-down arrow to the right of this cell to select the cost-of-living allowance increase percentage that will be used (e.g., 3%).  Note: standard is 3% and the NIH does not allow more than 3%."]
["START AND END DATES"]
["1) Year 1 start date: fill in the start date in mm/dd/yyyy format (e.g., 7/1/2010) and the remaining dates will be filled in automatically."]
["SALARIES"]
["1) Name: fill in the first name and last name of each person on the project (e.g., Mike Burry)"]
["2) Current salary: Fill in this person's current Institutional Base Salary without decimals, which include supplemental pay, but excludes X-pays, VA salary and clinical salary (e.g., 90000)."]
["3) Effort %: Enter the effort percentage this person will work on this project (e.g., if they will work 20%, enter 20).  NOTE: do not use decimals as it's difficult to justify that to sponsors."]
["4) The Adj salary adjusts any salary over the NIH cap to the cap amount."]
["5) Years 1-5: These are calculated automatically based on the Adjusted Salary x the effort %, with a cost-of-living allowance added Years 2 and up."]
["FRINGE BENEFITS"]
["1) GRA: If this person is a Graduate Research Assistant, fill in GRA here and the Fringe % will automatically be set to 0 and the first year filled in based on the current GRA fringe amount."]
["2) Fringe benefit %: Fill in the fringe benefit % for this person (e.g., if you want to enter 28.5%, then fill in 28.5).  Standard is 28.5% but you can override this amount if you want to use the person's actual fringe rate."]
["COST SHARES"]
["1) Speedtypes: Fill in the 5-character speedtype to be used for the cost share funding -- usually a letter plus 4 numbers, (e.g., P0021).  CANNOT be a grant speedtype."]
["EQUIPMENT"]
["1) Equipment item: fill in the name of the piece of equipment or equipment system you are requesting from the sponsor (e.g., Electron microscope)."]
["2) Equipment costs: fill in the cost of the equipment on this line, in the year it will be purchased.  NOTE: equipment must be greater than $5,000, so if the equipment is less, list it in Other Expenses instead.  You will get an error message if you try to enter less here."]
["SUPPLIES"]
["Each cell is calculated automatically by taking the Target amount for that year and subtracting all other costs except subcontract indirect costs."]
["PATIENT CARE COSTS"]
["1) Patient care items: fill in the type of patient care cost (e.g., CT scans)"]
["2) Patient care costs: fill in the costs of patient care costs for this year in this cell."]
["ALTERATIONS/RENOVATIONS"]
["1) Alteration/renovation item: fill in a short description of the renovation or building alteration (e.g., Hood installation)."]
["2) Alteration/renovation costs: Fill in the amount of alteration or renovation costs for this year in this cell.  NOTE: if total for each line is <$100,000, line will turn red as if less than $100,000 should be in the Other Expenses section."]
["OFF-SITE RENTALS"]
["1) Off-site rental item: fill in the description the of off-site rental cost (e.g., CTRB lobby rental)"]
["2) Off-site rental costs: fill in the amount of off-site rental costs for this year in this cell."]
["SUBCONTRACTS"]
["Each cell is filled in automatically based on information from the Subonctracts page."]
["TRAVEL"]
["1) Travel items: fill in the description the of each travel cost (e.g., PI to 1 national meeting)."]
["2) Travel costs: fill in the amount of travel costs for this year in this cell.  "]
["TUITION"]
["Tuition numbers and costs: automatically calculates the number of individuals requiring tuition support by taking the number of persons classified as GRA in the fringe section and multiplying that # by the amount of tuition listed on the References page."]
["OTHER EXPENSES"]
["1) Other expense items: fill in the description the of this other expense cost (e.g., Publications)"]
["2) Other expense costs: fill in the amount of this other expense cost for this year in this cell.  "]
["COMMENTS"]
["1) Comments: Enter in comments about the budget, if needed (e.g., Burry will be promoted 8/10 so the base salary listed is the projected amount)."]
["SUBCONTRACTS"]
["EACH LISTING"]
["1) Institution: fill in the name of the institution you will be subcontracting to (e.g., Brown University)."]
["2) Principal Investigator: fill in the name of the PI at this subcontract site (e.g., Chris Meloni)."]
["3) Direct costs: fill in the direct costs the subcontractee is charging for each year of the project."]
["4) Indirect costs: fill in the indirect costs the subcontractee is charging for each year of the project."]