To utilize SPAR's Excel Template files, just click on the link below that applies to the length of your current proposal.
Please note: the templates automatically calculate university average fringe rates and the federally-negotiated indirect/F&A rates. Please refer to the proposal guidelines for specific budgetary instructions.
1 Year Excel Template
2 Year Excel Template
3 Year Excel Template
4 Year Excel Template
5 Year Excel Template
6 Year Excel Template
Sample Budget Justification (pdf)
How do you calculate person months?
Conversion of percentage of effort to person months is straight-forward. To calculate person months, multiply the percentage of your effort associated with the project times the number of months of your appointment. For example:
25% of a 9 month academic year appointment equals 2.25 (AY) person months (9 x .25= 2.25)
10% of a 12 month calendar appointment equals 1.2 (CY) person months (12 x .10 = 1.2)
35% of a 3 month summer term appointment equals 1.05 (SM) person months (3 x .35= 1.05)