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 to estimate the amount of source funding needed for salary cap cost sharing by year.
|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.|
|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.|
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.|