Calculator Tools

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.

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

 

© 2014 Finance & Facilities, University of Washington     PRIVACYTERMS