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-DHHS 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.

Cost Share Calculator

Calculates % and $ amount of cost share by FEC cycle. Use appropriate calculator for department's reporting cycle.

  • 1/1 -6/30 and 7/1- 12/31 use Calendar
  • 9/16 -3/15 and 3/16 -9/15 use Academic

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.

Instructions for turning on the Excel Analysis Toolpak

Cost Share calculator instructions

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 FTE is less than 100%.
Person-Months Conversion Convert person months from proposal to percents required in effort reporting.