Calculator Tools and Worksheets
|ADS/ENS Calculator||Calculates $ or % to put into OPUS when faculty has ADS/ENS. This calculator is a MS Excel file with three tabs.|
|Salary Cap Calculator - for Determining Salary Distribution||
Use this calculator tool to determine the correct distribution of salary between grant and non-grant budgets when an individual’s salary exceeds the salary cap or when a faculty member receives Clinical, ENS and/or ADS salary and the department desires not to distribute those earnings to a grant(s), i.e., only REG salary.
|Salary Cap Calculator - for Adjusting an FEC||Use this calculator to determine amount of salary cap cost share required - resulting from new budgets added to recertified FECs, multiple caps present during one FEC cycle, non-DHHSi sponsors applying the cap.|
|Non-Federal Grant Used as a Cost Share Source Worksheet||Use this worksheet when a non-federal grant is used as a cost share source for a federal grant. Note: this requires prior approval of both sponsors.|
|Interim Cost Share Report - Academic||Document cost sharing when budget has expired, but FEC has not been printed for faculty reporting on an academic cycle. For more information please see Interim Cost Share Report job aid.|
|Interim Cost Share Report - Calendar||Document cost sharing when budget has expired, but FEC has not been printed for faculty reporting on a calendar cycle. For more information please see Interim Cost Share Report job aid.|
Calculates % and $ amount of cost share by FEC cycle. Use appropriate calculator for department's reporting cycle.
Download the calculator first to your computer and then turn on the Excel Analysis Toolpak. This will ensure that the Toolpak activates and provides the correct calculations.
|K Award Calculator for FTE Less than 1||Calculates the percent amount to be placed on the FEC for cost sharing when the Average Paid FTEi is less than 100%.|
|Person-Months Conversion||Convert person months from proposal to percents required in effort reporting.|