Get documents about "effort % worksheet
Document Sample
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
Related docs
