effort % worksheet by ckj14752

VIEWS: 22 PAGES: 4

									EFFORT WORKSHEET

Converting effort % to dollars or months and vice-versa

To calculate budgets based on committed effort percentage
Enter values in yellow boxes
Enter percent of effort committed by PI:
Enter PI's full time annual rate from his/her JED:
Enter JED contract length in months:
PI's annualized pay rate =                                               #DIV/0!

Value of PI's committed effort=                                              0.00% *
Equivalent number of effort months =                                         0.00% *


To calculate effort percentage or months based on budgeted dollars
Enter values in yellow boxes
Enter budgeted amount for PI salary
Enter PI's full time annual rate from his/her JED:                   $         -
Enter JED contract length in months:                                               0
PI's annualized pay rate is:                                             #DIV/0!

Budgeted amount is equivalent to this effort percentage=                      $0.00 /
Equivalent number of effort months =                                     #DIV/0!    *
   #DIV/0!   =    #DIV/0!
12 months    = 0.00




   #DIV/0!   =   #DIV/0!
12 months    =   #DIV/0!    months
EFFORT WORKSHEET

Number of Months calculated based on percent effort
         Summer         Effort Period     Academic Year (9           Calendar Year
         (3 months)     (6 months)        months)                    (12 months)
 Effort
      5%            0.2               0.3                      0.5               0.6
    10%             0.3               0.6                      0.9               1.2
    15%             0.5               0.9                      1.4               1.8
    20%             0.6               1.2                      1.8               2.4
    25%             0.8               1.5                      2.3               3.0
    30%             0.9               1.8                      2.7               3.6
    35%             1.1               2.1                      3.2               4.2
    40%             1.2               2.4                      3.6               4.8
    45%             1.4               2.7                      4.1               5.4
    50%             1.5               3.0                      4.5               6.0
    55%             1.7               3.3                      5.0               6.6
    60%             1.8               3.6                      5.4               7.2
    65%             2.0               3.9                      5.9               7.8
    70%             2.1               4.2                      6.3               8.4
    75%             2.3               4.5                      6.8               9.0
    80%             2.4               4.8                      7.2               9.6
    85%             2.6               5.1                      7.7              10.2
    90%             2.7               5.4                      8.1              10.8
    95%             2.9               5.7                      8.6              11.4
   100%             3.0               6.0                      9.0              12.0

read as:   5% of the summer equals .2 months
           5% of an effort reporting period equals .3 months
           5% of the 9 month academic year equals .5 months
           5% of the calendar year equals .6 months
Percent Effort Calculations based on number of months
           Summer             Effort Report Pd   Academic Year (9 Calendar Year (12
           (3 months)         (6 months)         months)          months)
  Months
       1              33.3%              16.7%               11.1%            8.3%
     1.5              50.0%              25.0%               16.7%           12.5%
       2              66.7%              33.3%               22.2%           16.7%
     2.5              83.3%              41.7%               27.8%           20.8%
       3             100.0%              50.0%               33.3%           25.0%
     3.5                 NA              58.3%               38.9%           29.2%
       4                 NA              66.7%               44.4%           33.3%
     4.5                 NA              75.0%               50.0%           37.5%
       5                 NA              83.3%               55.6%           41.7%
     5.5                 NA              91.7%               61.1%           45.8%
       6                 NA             100.0%               66.7%           50.0%
     6.5                 NA                 NA               72.2%           54.2%
       7                 NA                 NA               77.8%           58.3%
     7.5                 NA                 NA               83.3%           62.5%
       8                 NA                 NA               88.9%           66.7%
     8.5                 NA                 NA               94.4%           70.8%
       9                 NA                 NA              100.0%           75.0%
     9.5                 NA                 NA                  NA           79.2%
      10                 NA                 NA                  NA           83.3%
    10.5                 NA                 NA                  NA           87.5%
      11                 NA                 NA                  NA           91.7%
    11.5                 NA                 NA                  NA           95.8%
      12                 NA                 NA                  NA          100.0%

read as:   1 month is 33% of the summer
           1 month is 16.7% of an effort reporting period
           1 month is 11.1% of the 9 month academic year
           1 month is 8.3% of the calendar year

								
To top