Spreadsheet: 088b47e2-e587-4313-a5a5-213665dc9281
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Time and Effort Report                                                                                                                                                                               Office of Research and Sponsored Programs | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42
1. Employee Name: |  |  |  | 2. TU ID number: |  |  |  |  | 3. College: |  |  |  |  |  | 4. Department/Faculty of: |  |  |  |  |  | 5. Academic Year Period: |  |  |  |  |  |  |  |  |  | 6. Revision No. & Period: |  |  |  |  |  | 7. Date: |  |  |  | 8. Contract Period | 9. Contract  Rate:
 |        MUST FILL OUT ACCOUNT WITH OBJECT CODE, AMOUNT & PERCENT FOR EACH MONTH         
10. ACTIVITY ACCOUNT & OBJECT CODE | 8/15-8/31 |  |  |  | 9/1-9/30 |  |  |  | 10/1-10/31 |  |  |  | 11/1-11/30 |  |  |  | 12/1-12/31 |  |  |  | 1/1-1/31 |  |  |  | 2/1-2/28 |  |  |  | 3/1-3/31 |  |  |  | 4/1-4/30 |  |  |  | 5/1-5/15 |  |  |  | Total
 | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt.
Instruction
10-2- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Administration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TU Supported Research |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other (Specify) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal for all Dept. | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
or College Accounts
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
14-2-
RESEARCH - Cost Share |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
13-2-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
11. Approval Area
Employee Signature/Approval                                    Date |  |  |  |  |  |  | PI Signature/Approval                                                              Date |  |  |  |  |  |  |  |  | Date |  |  |  | Office of Research and Sponsored Programs Signature/Approval: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments:
Dept. Chair Signature/Approval                                 Date |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Date |  |  |  | Comments:
PLEASE KEEP CONFIDENTIAL      PLEASE KEEP CONFIDENTIAL      PLEASE KEEP CONFIDENTIAL
Research Form 8/02
INSTRUCTIONS & EXAMPLE
Time and Effort Report
Office of Research and Sponsored Programs
Areas 1-11 must be filled out
Time and Effort (T&E) Report:  At the beginning of the academic year, all personnel, excluding students and hourly personnel, must complete a T&E Report in order to be paid on a sponsored project account.
Mid-year appointments must be initiated upon acceptance of employment for the remainder of the academic year.  Include all allocations for major institutional activities and sponsored project activities for 100% effort.
Principal Investigators:  PI's must complete, as well as authorize by signature, the percentage (%) and Amount (Amt.) placed against their project accounts.
Activity in RESEARCH-SPONSOR Block:  PI must designate the activity in the RESEARCH-SPONSOR block to reference the funding source (example:  USDA, NSF, OCAST).
University Account Number and Object Code:  The PI must identify the project account number (either 20-2, 14-2 or 13-2) and the appropriate University Object Code (9XXXX).
The Dean's Office will identify the appropriate institutional activity (10-1) accounts.  (Note: 14-2 represents funding paid by the external sponsor.   13-2 represents TU Cost Share.)
EXAMPLE: | [NAME] is a 9 month faculty member with an academic contract of $45,000
9 Month Contracts
 | Sponsor Budget for Principal Investigator is 25% for 9 months for a total of $11,250
 | T&E formula - $45,000 divided by 9 = $5,000 per month x 25% = $1,250 x 9 months = $11,250
 | August and May should reflect 1/2 of a month as shown below ($625)
 | TU Cost Share for Principal Investigator is 10% for 9 months for a total of $4,500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Period | Contract  Rate:
 | T&E formula - $45,000 divided by 9 = $5,000 per month x 10% = $500 x 9 months = $4,500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 45000
 | August and May should reflect 1/2 of a month as shown below ($250)
ACTIVITY ACCOUNT & OBJECT CODE | 8/15-8/31 |  |  |  | 9/1-9/30 |  |  |  | 10/1-10/31 |  |  |  | 11/1-11/30 |  |  |  | 12/1-12/31 |  |  |  | 1/1-1/31 |  |  |  | 2/1-2/28 |  |  |  | 3/1-3/31 |  |  |  | 4/1-4/30 |  |  |  | 5/1-5/15 |  |  |  | Total
 | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt.
(10-1-XXXXXXX-5XXXX)
[NAME]14-2-1413999-90101 | 0.25 | 625 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 1250 |  |  | 0.25 | 625 |  |  | 0.25 | 11250
RESEARCH - Cost Share                            13-2-1413999-90101 | 0.1 | 250 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 500 |  |  | 0.1 | 250 |  |  | 0.09999999999999999 | 4500
EXAMPLE: | [NAME] is a 12 month Research Associate with an annual contract of $45,000
12 Month Contracts
 | Sponsor Budget for Principal Investigator is 25% for 9 months for a total of $11,250
 | T&E formula - $45,000 divided by 12 = $3,750 per month x 25% = $937.50 x 9 months = $8,437.50
 | August and May should reflect 1/2 of a month as shown below ($468.75)
 | TU Cost Share for Principal Investigator is 10% for 9 months for a total of $4,500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Period | Contract  Rate:
 | T&E formula - $45,000 divided by 12 = $3,750 per month x 10% = $375 x 9 months = $3,375 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 45000
 | August and May should reflect 1/2 of a month as shown below ($187.50)
ACTIVITY ACCOUNT & OBJECT CODE | 8/15-8/31 |  |  |  | 9/1-9/30 |  |  |  | 10/1-10/31 |  |  |  | 11/1-11/30 |  |  |  | 12/1-12/31 |  |  |  | 1/1-1/31 |  |  |  | 2/1-2/28 |  |  |  | 3/1-3/31 |  |  |  | 4/1-4/30 |  |  |  | 5/1-5/15 |  |  |  | Total
 | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt. |  |  | % | Amt.
(10-1-XXXXXXX-5XXXX)
[NAME]14-2-1413999-90101 | 0.25 | 468.75 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 937.5 |  |  | 0.25 | 468.75 |  |  | 0.25 | 8437.5
RESEARCH - Cost Share                            13-2-1413999-90101 | 0.1 | 187.5 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 375 |  |  | 0.1 | 187.5 |  |  | 0.09999999999999999 | 3375
Release time (TU Cost Share):  Is your level of effort the University provides (releases) toward sponsored projects.  Changes may occur from one semester to another.
(Example:  4% for the Fall and 5% over the Spring).
Revisions:  To effect a change during the academic year, revisions should be submitted prior to the month affected.  A copy of the previous T&E should be attached to revisions.
Approvals:  Each T&E Report should be routed for signatures (as referenced at the bottom of the form) through the appropriate [NAME], [NAME], [NAME] and the
Office of Research prior to submission to Personnel.  This process is required for all initial forms and revisions.
T&E forms should be received no later than the 10th of the month to affect that month's activity.
Designations should be consistent with University and Research Sponsor policies and procedures and awarded budgets.
Research Form 8/02