{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DATA ENTRY & PCF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"DATA ENTRY & PCF","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,3,3,4],[3,0,3,1],[31,0,31,5],[29,0,30,5],[13,3,13,4],[12,0,12,5]]}
[]
["AHA PRE-DOCTORAL FELLOWSHIP BUDGET SPREADSHEET"]
[]
["UL INFO",null,null,"AHA INFO"]
["Pre Doc name",null,null,"AHA annual stipend",23844]
["# of years for grant",2,null,"AHA annual health insurance allowance",1000]
["Institutional base salary at time of award",25500,null,"AHA Project Support Allowance",2000]
["UL fringe rate",{"$f":"B7*0.285","v":7267.4999999999991},null,"TOTAL ANNUAL ALLOWANCES",{"$f":"SUM(E5:E7)","v":26844}]
["Effort % (100% required for AHA pre-doc grants)",1]
["Project support for supplies",2000,null,"You can allocate up $2,000 per yr to travel, supplies or both.  Whatever you fill in for supplies, the remainder will auto-fill in travel"]
["Project support for travel",{"$f":"E7-B10","v":0}]
[]
["PROPOSAL CLEARANCE FORM ITEMS"]
["#18d Requested from sponsor",null,null,"#18f UofL Cost Share",null,"Speedtypes"]
["Salary & wages",{"$f":"E5*B6","v":47688},null,"Salary & wages",{"$f":"(B7*B6)-(E5*B6)","v":3312},null,"(Get this from your UBM)"]
["Fringe benefits",{"$f":"E6*B6","v":2000},null,"Fringe benefits",{"$f":"(B8*B6)-(E6*B6)","v":12534.999999999998}]
["Supplies & expenses",{"$f":"B10*2","v":4000},null,"Supplies & expenses"]
["Travel",{"$f":"B11*2","v":0},null,"Travel"]
["TOTAL Direct Costs",{"$f":"SUM(B15:B18)","v":53688},null,"TOTAL Direct Costs",{"$f":"SUM(E15:E18)","v":15846.999999999998}]
[]
["#18g Exclusions to TDC Base"]
["Total Exclusions",0]
["Modified TDC Base (18e TDC minus 18h exclusions)",{"$f":"B19","v":53688}]
[]
["TOTALS"]
["#18j F&A Indirect costs",0]
["#18k Total Cost of Project",{"$f":"B19+B26","v":53688}]
[]
["#18l Budget Remarks"]
["1) Sponsor does not allow indirect costs.  2) Stipend/salary capped at $23,844 per year, fringe at $1,000 for health insurance, and $2,000 for project support (travel, publications, supplies & fringe benefits).  3) Cost share is for the difference between the stipend and benefits cap and actual stipend & benefits."]