{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MAIN SHEET","KLCRP BUDGET PAGE","PCF BUDGET INFO"],"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":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,7],[52,0,52,3],[53,0,53,3],[55,0,55,3],[58,0,58,3],[56,0,56,3],[54,0,54,3],[60,0,60,3],[46,0,46,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[48,0,48,3],[31,0,31,3],[26,0,26,3],[28,0,28,3],[32,0,32,3],[33,0,33,3],[30,0,30,3],[34,0,34,3],[39,0,39,3],[40,0,40,3],[42,0,42,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[1,0,1,15],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[17,0,17,3],[7,10,8,10],[24,0,24,1],[25,0,25,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1]]}
[]
["KLCRP Cycle 14 budget spreadsheet"]
["PI name:"]
["Project title:"]
["Start date:",{"$f":"E8","v":"2015-03-01"}]
["End date:",{"$f":"F9","v":"2017-02-28"}]
["Cost of living % increase",0.03]
[null,null,null,"Start date","2015-03-01",{"$f":"EDATE(E8,12)","v":"2016-03-01"},null,null,null,null,"COST SHARE",{"$f":"E8","v":"2015-03-01"},{"$f":"F8","v":"2016-03-01"}]
[null,null,null,"End date",{"$f":"F8-1","v":"2016-02-29"},{"$f":"EDATE(E9,12)","v":"2017-02-28"},null,null,null,null,null,{"$f":"E9","v":"2016-02-29"},{"$f":"F9","v":"2017-02-28"}]
["Salaries (Name)","Current salary","Adj salary","Effort %","Year 1","Year 2",null,"TOTAL","Sr Faculty?",null,"Salaries","Year 1","Year 2",null,"TOTAL","Speedtype"]
[null,0,{"$f":"IF(I11=\"Y\",0,B11)","v":0},0,{"$f":"ROUND(C11*D11,0)","v":0},{"$f":"ROUND(E11*(1+B7),0)","v":0},null,{"$f":"SUM(E11:F11)","v":0},null,null,{"$f":"IF(I11=\"Y\",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(I12=\"Y\",0,B12)","v":0},0,0,{"$f":"ROUND(E12*(1+B7),0)","v":0},null,0,null,null,{"$f":"IF(I12=\"Y\",A12,\"\")","v":""},0,{"$f":"ROUND(L12*(1+B7),0)","v":0},null,0]
[null,0,0,0,0,{"$f":"ROUND(E13*(1+B7),0)","v":0},null,0,null,null,"",0,{"$f":"ROUND(L13*(1+B7),0)","v":0},null,0]
[null,0,0,0,0,{"$f":"ROUND(E14*(1+B7),0)","v":0},null,0,null,null,"",0,{"$f":"ROUND(L14*(1+B7),0)","v":0},null,0]
[null,0,0,0,0,{"$f":"ROUND(E15*(1+B7),0)","v":0},null,0,null,null,"",0,{"$f":"ROUND(L15*(1+B7),0)","v":0},null,0]
[null,0,0,0,0,{"$f":"ROUND(E16*(1+B7),0)","v":0},null,0,null,null,"",0,{"$f":"ROUND(L16*(1+B7),0)","v":0},null,0]
[null,0,0,0,0,{"$f":"ROUND(E17*(1+B7),0)","v":0},null,0,null,null,"",0,{"$f":"ROUND(L17*(1+B7),0)","v":0},null,0]
["TOTALS",null,null,null,{"$f":"SUM(E11:E17)","v":0},{"$f":"SUM(F11:F17)","v":0},null,0,null,null,"TOTALS",{"$f":"ROUND(SUM(L11:L17),0)","v":0},{"$f":"ROUND(SUM(M11:M17),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(C20=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C20=\"GRA\",L31,E11*D20),0)","v":0},{"$f":"ROUND(IF(C20=\"GRA\",E20*(1+B7),F11*D20),0)","v":0},null,{"$f":"SUM(E20:F20)","v":0},null,null,{"$f":"IF(ISBLANK(K11),\"\",K11)","v":""},{"$f":"ROUND(L11*D20,0)","v":0},{"$f":"ROUND(M11*D20,0)","v":0},null,{"$f":"ROUND(SUM(L20:M20),0)","v":0},{"$f":"IF(ISBLANK(P11),\"\",P11)","v":""}]
["",null,null,{"$f":"IF(C21=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C21=\"GRA\",L31,E12*D21),0)","v":0},{"$f":"ROUND(IF(C21=\"GRA\",E21*(1+B7),F12*D21),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C22=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C22=\"GRA\",L31,E13*D22),0)","v":0},{"$f":"ROUND(IF(C22=\"GRA\",E22*(1+B7),F13*D22),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C23=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C23=\"GRA\",L31,E14*D23),0)","v":0},{"$f":"ROUND(IF(C23=\"GRA\",E23*(1+B7),F14*D23),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C24=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C24=\"GRA\",L31,E15*D24),0)","v":0},{"$f":"ROUND(IF(C24=\"GRA\",E24*(1+B7),F15*D24),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C25=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C25=\"GRA\",L31,E16*D25),0)","v":0},{"$f":"ROUND(IF(C25=\"GRA\",E25*(1+B7),F16*D25),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["",null,null,{"$f":"IF(C26=\"GRA\",0,L30)","v":0.28499999999999998},{"$f":"ROUND(IF(C26=\"GRA\",L31,E17*D26),0)","v":0},{"$f":"ROUND(IF(C26=\"GRA\",E26*(1+B7),F17*D26),0)","v":0},null,0,null,null,"",0,0,null,0,""]
["TOTALS",null,null,null,{"$f":"SUM(E20:E26)","v":0},{"$f":"SUM(F20:F26)","v":0},null,0,null,null,"TOTALS",{"$f":"ROUND(SUM(L20:L26),0)","v":0},{"$f":"ROUND(SUM(M20:M26),0)","v":0},null,0]
["Supplies",null,null,null,"Year 1","Year 2",null,"TOTAL"]
["TOTALS",null,null,null,{"$f":"E51","v":68181.820000000007},{"$f":"F51","v":68181.820000000007},null,{"$f":"ROUND(SUM(E29:F29),0)","v":136364}]
["Animals",null,null,null,"Year 1","Year 2",null,"TOTAL",null,null,"Fringe benefit rate",0.28499999999999998]
["TBD",null,null,null,0,0,null,{"$f":"ROUND(SUM(E31:F31),0)","v":0},null,null,"GRA insurance",2466]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E32:F32),0)","v":0},null,null,"GRA tuition",3780]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E33:F33),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E34:F34),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E31:E34),0)","v":0},{"$f":"ROUND(SUM(F31:F34),0)","v":0},null,{"$f":"ROUND(SUM(E35:F35),0)","v":0}]
["Travel",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E37:F37),0)","v":0}]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E38:F38),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E39:F39),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E40:F40),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E37:E40),0)","v":0},{"$f":"ROUND(SUM(F37:F40),0)","v":0},null,{"$f":"ROUND(SUM(E41:F41),0)","v":0}]
["Other expenses",null,null,null,"Year 1","Year 2",null,"TOTAL"]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E43:F43),0)","v":0}]
[null,null,null,null,0,0,null,{"$f":"ROUND(SUM(E44:F44),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E45:F45),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E46:F46),0)","v":0}]
["TOTALS",null,null,null,{"$f":"ROUND(SUM(E43:E46),0)","v":0},{"$f":"ROUND(SUM(F43:F46),0)","v":0},null,{"$f":"ROUND(SUM(E47:F47),0)","v":0}]
["DETAILED BUDGET TOTALS",null,null,null,"Year 1","Year 2",null,"TOTAL"]
["Salary",null,null,null,{"$f":"E18","v":0},{"$f":"F18","v":0},null,{"$f":"ROUND(SUM(E49:F49),0)","v":0}]
["Fringe",null,null,null,{"$f":"E27","v":0},{"$f":"F27","v":0},null,0]
["Supplies",null,null,null,{"$f":"E61-E49-E50-E52-E53-E54","v":68181.820000000007},{"$f":"F61-F49-F50-F52-F53-F54","v":68181.820000000007},null,136364]
["Animals",null,null,null,{"$f":"E35","v":0},{"$f":"F35","v":0},null,0]
["Travel",null,null,null,{"$f":"E41","v":0},{"$f":"F41","v":0},null,0]
["Other expenses",null,null,null,{"$f":"E47","v":0},{"$f":"F47","v":0},null,0]
["DIRECT COST SUBTOTAL",null,null,null,{"$f":"ROUND(SUM(E49:E54),0)","v":68182},{"$f":"ROUND(SUM(F49:F54),0)","v":68182},null,136364]
["F/A RATE",null,null,null,0.1,0.1]
["F&A SUBTOTAL",null,null,null,{"$f":"E56*E55","v":6818.2000000000007},{"$f":"F56*F55","v":6818.2000000000007},null,{"$f":"ROUND(SUM(E57:F57),0)","v":13636}]
[]
["TOTAL COSTS",null,null,null,{"$f":"ROUND(SUM(E55,E57),0)","v":75000},{"$f":"ROUND(SUM(F55,F57),0)","v":75000},null,{"$f":"ROUND(SUM(E59,F59),0)","v":150000}]
[]
["TARGET ANNUAL DIRECT COSTS",null,null,null,68181.820000000007,68181.820000000007,null,{"$f":"SUM(E61:F61)","v":136363.64000000001}]
[]
["COMMENTS"]

{"sheet":"KLCRP BUDGET PAGE","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,0,16,5],[17,0,17,5],[19,0,19,1],[1,0,1,18],[4,0,4,6],[13,0,13,5],[14,0,14,5],[15,0,15,5]]}
[]
["KLCRP SECTION 2 BUDGET"]
[]
["YEAR 1 Budget"]
["Personnel"]
["Name","Title","% effort","Base salary","Salary requested","Fringe benefits","Total"]
[{"$f":"'MAIN SHEET'!A11","v":0},null,{"$f":"'MAIN SHEET'!D11","v":0},{"$f":"'MAIN SHEET'!C11","v":0},{"$f":"'MAIN SHEET'!E11","v":0},{"$f":"'MAIN SHEET'!E20","v":0},{"$f":"SUM('MAIN SHEET'!E11,'MAIN SHEET'!E20)","v":0}]
[{"$f":"'MAIN SHEET'!A12","v":0},null,{"$f":"'MAIN SHEET'!D12","v":0},{"$f":"'MAIN SHEET'!C12","v":0},{"$f":"'MAIN SHEET'!E12","v":0},{"$f":"'MAIN SHEET'!E21","v":0},{"$f":"SUM('MAIN SHEET'!E12,'MAIN SHEET'!E21)","v":0}]
[{"$f":"'MAIN SHEET'!A13","v":0},null,{"$f":"'MAIN SHEET'!D13","v":0},{"$f":"'MAIN SHEET'!C13","v":0},{"$f":"'MAIN SHEET'!E13","v":0},{"$f":"'MAIN SHEET'!E22","v":0},{"$f":"SUM('MAIN SHEET'!E13,'MAIN SHEET'!E22)","v":0}]
[{"$f":"'MAIN SHEET'!A14","v":0},null,{"$f":"'MAIN SHEET'!D14","v":0},{"$f":"'MAIN SHEET'!C14","v":0},{"$f":"'MAIN SHEET'!E14","v":0},{"$f":"'MAIN SHEET'!E23","v":0},{"$f":"SUM('MAIN SHEET'!E14,'MAIN SHEET'!E23)","v":0}]
[{"$f":"'MAIN SHEET'!A15","v":0},null,{"$f":"'MAIN SHEET'!D15","v":0},{"$f":"'MAIN SHEET'!C15","v":0},{"$f":"'MAIN SHEET'!E15","v":0},{"$f":"'MAIN SHEET'!E24","v":0},{"$f":"SUM('MAIN SHEET'!E15,'MAIN SHEET'!E24)","v":0}]
[{"$f":"'MAIN SHEET'!A16","v":0},null,{"$f":"'MAIN SHEET'!D16","v":0},{"$f":"'MAIN SHEET'!C16","v":0},{"$f":"'MAIN SHEET'!E16","v":0},{"$f":"'MAIN SHEET'!E25","v":0},{"$f":"SUM('MAIN SHEET'!E16,'MAIN SHEET'!E25)","v":0}]
[{"$f":"'MAIN SHEET'!A17","v":0},null,{"$f":"'MAIN SHEET'!D17","v":0},{"$f":"'MAIN SHEET'!C17","v":0},{"$f":"'MAIN SHEET'!E17","v":0},{"$f":"'MAIN SHEET'!E26","v":0},{"$f":"SUM('MAIN SHEET'!E17,'MAIN SHEET'!E26)","v":0}]
["Supplies",null,null,null,null,null,{"$f":"'MAIN SHEET'!E29","v":68181.820000000007}]
["Animals",null,null,null,null,null,{"$f":"'MAIN SHEET'!E35","v":0}]
["Travel",null,null,null,null,null,{"$f":"'MAIN SHEET'!E41","v":0}]
["Other",null,null,null,null,null,{"$f":"'MAIN SHEET'!E47","v":0}]
["Total Direct Costs Reqeuested Year 1",null,null,null,null,null,{"$f":"'MAIN SHEET'!E59","v":75000}]
[]
["Total Budget Request Summary"]
["Category","Year 1","Year 2","Totals"]
["Personnel",{"$f":"SUM('MAIN SHEET'!E18,'MAIN SHEET'!E27)","v":0},{"$f":"SUM('MAIN SHEET'!F18,'MAIN SHEET'!F27)","v":0},{"$f":"SUM(B22:C22)","v":0}]
["Supplies",{"$f":"'MAIN SHEET'!E29","v":68181.820000000007},{"$f":"'MAIN SHEET'!F29","v":68181.820000000007},{"$f":"SUM(B23:C23)","v":136363.64000000001}]
["Animals",{"$f":"'MAIN SHEET'!E35","v":0},{"$f":"'MAIN SHEET'!F35","v":0},0]
["Travel",{"$f":"'MAIN SHEET'!E41","v":0},{"$f":"'MAIN SHEET'!F41","v":0},0]
["Other",{"$f":"'MAIN SHEET'!E47","v":0},{"$f":"'MAIN SHEET'!F47","v":0},0]
["Total Direct Costs",{"$f":"'MAIN SHEET'!E55","v":68182},{"$f":"'MAIN SHEET'!F55","v":68182},136364]
["Indirect Costs (10% of TDC)",{"$f":"'MAIN SHEET'!E57","v":6818.2000000000007},{"$f":"'MAIN SHEET'!F57","v":6818.2000000000007},13636.400000000001]
["Total Funds Requested",{"$f":"'MAIN SHEET'!E59","v":75000},{"$f":"'MAIN SHEET'!F59","v":75000},150000]

{"sheet":"PCF BUDGET INFO","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"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":"03/01/2015 - 02/28/2017"}]
[]
["#18d Requested from sponsor",null,null,"#18f UofL Cost Share",null,"Speedtypes"]
["Salary & wages",{"$f":"'MAIN SHEET'!H18","v":0},null,"Salary & wages",{"$f":"'MAIN SHEET'!O18","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'!#REF!),\"\",CONCATENATE(\", \"&'MAIN SHEET'!#REF!&\" (\"&'MAIN SHEET'!#REF!&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!#REF!),\"\",CONCATENATE(\", \"&'MAIN SHEET'!#REF!&\" (\"&'MAIN SHEET'!#REF!&\") \"))\n\n&IF(ISBLANK('MAIN SHEET'!#REF!),\"\",CONCATENATE(\", \"&'MAIN SHEET'!#REF!&\" (\"&'MAIN SHEET'!#REF!&\") \"))\n)","v":""}]
["Fringe benefits",{"$f":"'MAIN SHEET'!H27","v":0},null,"Fringe benefits",{"$f":"'MAIN SHEET'!O27","v":0},{"$f":"F8","v":""}]
["Equip ≥$5K per item",0,null,"Equip ≥$5K per item"]
["Alteration/Renovation ≥$100K",0,null,"Alteration/Renovation ≥$100K"]
["Subcontracts",0,null,"Subcontracts"]
["Supplies & expenses",{"$f":"SUM('MAIN SHEET'!H29,'MAIN SHEET'!H35,'MAIN SHEET'!H47)","v":136364},null,"Supplies & expenses"]
["Travel",{"$f":"'MAIN SHEET'!H53","v":0},null,"Travel"]
["Tuition",0,null,"Tuition"]
["TOTAL Direct Costs",{"$f":"SUM(B8:B15)","v":136364},null,"TOTAL Direct Costs",{"$f":"SUM(E8:E15)","v":0}]
[]
["#18g Exclusions to TDC Base"]
["Equipment ≥$5K per item (190000)",0]
["Alteration/Renovation ≥$100K (190000)",0]
["Off-Site Rental (519000)",0]
["Patient Care (519000)",0]
["Subcontract amounts in excess of first $25K on each (519000)",0]
["Tuition (520000)",0]
["Other      ",0]
["Total Exclusions",{"$f":"SUM(B19:B25)","v":0}]
["Modified TDC Base (18e TDC minus 18h exclusions)",{"$f":"B16-B26","v":136364}]
[]
["TOTALS"]
["#18j F&A Indirect costs",{"$f":"'MAIN SHEET'!H57","v":13636}]
["#18k Total Cost of Project",{"$f":"'MAIN SHEET'!H59","v":150000}]
[]
["#18l Budget Remarks"]
["Sponsor caps indirects at 10%, inclusive of total.  Salaries and fringe for senior faculty must be cost-shared.  Salary for junior faculty capped at 10%."]
[{"$f":"IF('MAIN SHEET'!A64=\"\",\"\",\"2) \"&'MAIN SHEET'!A64)","v":""}]
[]
["#19 Subcontracts to be issued"]
["Organization name","PI/Contact name",null,null,"Current year","Remain Years"]