{"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":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,5],[36,4,36,5],[3,3,3,4],[10,0,10,1],[13,0,13,1],[3,0,3,1],[35,0,35,5],[33,0,34,5],[17,3,17,4],[16,0,16,5],[23,3,30,5],[14,3,15,5]]}
[]
["AHA POST-DOCTORAL FELLOWSHIP BUDGET SPREADSHEET"]
[]
["POST-DOC INFO",null,null,"AHA INFO"]
["Post Doc name",null,null,"AHA annual stipend",{"$f":"LOOKUP(B8,E38:E45,F38:F45)","v":58560}]
["Institutional base salary at time of award",48000,null,"AHA annual health insurance allowance",1000]
["Actual fringe benefit rate",0.39,null,"AHA project support allowance",3000]
["# of years of post-doc experience at time of award","7+"]
["# of years for grant",2]
[]
["EFFORT CALCULATIONS"]
["100% effort is required for submission",1]
[]
["SUPPLIES & TRAVEL CALCULATIONS PER YEAR"]
["Project support for supplies",3000,null,"You can allocate up $3,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-B15","v":0}]
["PROPOSAL CLEARANCE FORM ITEMS"]
["#18d Requested from sponsor",null,null,"#18f UofL Cost Share",null,"Speedtypes"]
["Salary & wages",{"$f":"E5*B9","v":117120},null,"Salary & wages",{"$f":"((B6*B9)*(1+B7)-(B19+B20))/(1+B7)","v":10302.158273381294}]
["Fringe benefits",{"$f":"E6*B9","v":2000},null,"Fringe benefits",{"$f":"E19*B7","v":4017.8417266187048}]
["Supplies & expenses",{"$f":"B15*B9","v":6000},null,"Supplies & expenses"]
["Travel",{"$f":"B16*B9","v":0},null,"Travel"]
["TOTAL Direct Costs",{"$f":"SUM(B19:B22)","v":125120},null,"TOTAL Direct Costs",{"$f":"SUM(E19:E22)","v":14319.999999999998}]
[null,null,null,"COST SHARE EXPLANATION: the cost share calculations are unusual in that they don't simply subtract AHA stipend from UL actual salary and AHA health benefits from UL's 39% post-doc rate.  Because the AHA caps health benefits at $1,000 per year but we're allowed to combine the AHA stipend and health benefits when awarded, the cost share salary is calculated by adding the total AHA stipend plus health benefits for all years, then dividing by 1 + the 39% post doc fringe rate.  The cost share fringe then multiplies that amount by 39%."]
["#18g Exclusions to TDC Base"]
["Total Exclusions",0]
["Modified TDC Base (18e TDC minus 18h exclusions)",{"$f":"B23","v":125120}]
[]
["TOTALS"]
["#18j F&A Indirect costs",0]
["#18k Total Cost of Project",{"$f":"B23+B30","v":125120}]
[]
["#18l Budget Remarks"]
["1) Sponsor does not allow indirect costs.  2) Stipend/salary capped based on post-doc's experence, fringe at $1,000 for health insurance, and $3,000 for project support (travel, publications, supplies & fringe benefits).  "]
[]
[]
[null,null,null,null,"AHA stipends/yrs of experience"]
[null,null,null,null,0,47484]
[null,null,null,null,1,47844]
[null,null,null,null,"2",48216]
[null,null,null,null,"3",50316]
[null,null,null,null,"4",52140]
[null,null,null,null,"5",54228]
[null,null,null,null,"6",56400]
[null,null,null,null,"7+",58560]