Spreadsheet: 1a642e1f-fe27-4a16-8dec-14c75ffa965c
Sheet: Data Sheet

Select the right-facing arrow at the bottom of this column to move to the MTDC tab | Name | NBAJOBS               Base Salary | % inc/year | Academic/Fiscal Year appointment | Percent Effort Yr1 | Request Yr1 |  | Percent Effort Yr2 | Request Yr2 |  | Percent Effort Yr3 | [NAME] 3 |  | Percent Effort Yr4 | Request Yr4 |  | Percent Effort Yr5 | Request Yr5 |  | Total Request |  |  |  |  |  |  |  |  |  | these will be hidden
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PI1 |  | CoI2
PI salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | . |  |  |  |  | 0 | 0.66 | 0 | 0.66
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 20000 | 0.66 | 20000 | 0.66
Total PI salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000 | 0.57 | 25000 | 0.57
Fringe PI AY |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 0.52 | 30000 | 0.52
[NAME] Summer |  |  |  | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35000 | 0.48 | 35000 | 0.48
Total PI fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 0.45 | 40000 | 0.45
Total PI request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 0.42 | 45000 | 0.42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 0.41 | 50000 | 0.41
Co-PIs
Co-PI 1 salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 55000 | 0.39 | 55000 | 0.39
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 60000 | 0.38 | 60000 | 0.38
Total Co-PI 1 salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65000 | 0.36 | 65000 | 0.36
[NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000 |  | 70000
[NAME] 1 Summer |  |  |  | Summer
Total Co-PI 1 fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CoI1 |  | CoI 3
Total Co-PI request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.66 | 0 | 0.66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20000 | 0.66 | 20000 | 0.66
Co-PI 2 salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 25000 | 0.57 | 25000 | 0.57
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 0.52 | 30000 | 0.52
Total Co PI 2 salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35000 | 0.48 | 35000 | 0.48
[NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 0.45 | 40000 | 0.45
[NAME] 2 Summer |  |  |  | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 0.42 | 45000 | 0.42
Total Co-PI 2 fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 0.41 | 50000 | 0.41 | Select | Select
Total Co-PI 2 request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55000 | 0.39 | 55000 | 0.39 | Academic (9 month) | Full Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000 | 0.38 | 60000 | 0.38 | Fiscal (12 month) | Part Time
Co-PI 3 salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 65000 | 0.36 | 65000 | 0.36
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 70000 |  | 70000
Total Co-PI 3 salary
[NAME] 3 AY |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CO I 4 |  | Co I 5 |  | Co I 6
[NAME] 3 Summer |  |  |  | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.66 | 0 | 0.66 | 0 | 0.66
Total Co-PI 3 fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20000 | 0.66 | 20000 | 0.66 | 20000 | 0.66
Total Co-PI 3 request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000 | 0.57 | 25000 | 0.57 | 25000 | 0.57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 0.52 | 30000 | 0.52 | 30000 | 0.52
Co-PI 4 salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 35000 | 0.48 | 35000 | 0.48 | 35000 | 0.48
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 0.45 | 40000 | 0.45 | 40000 | 0.45
Total Co-PI 4 salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 0.42 | 45000 | 0.42 | 45000 | 0.42
[NAME] 4 AY |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 0.41 | 50000 | 0.41 | 50000 | 0.41
[NAME] 4 Summer |  |  |  | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55000 | 0.39 | 55000 | 0.39 | 55000 | 0.39
Total Co-PI 4 fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000 | 0.38 | 60000 | 0.38 | 60000 | 0.38
Total Co-PI 4 request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65000 | 0.36 | 65000 | 0.36 | 65000 | 0.36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000 |  | 70000 |  | 70000
Co-PI 5 salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | POST 1 |  | POST 2 |  | POST 3 |  | POST 4
Total Co-PI 5 salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.66 | 0 | 0.66 | 0 | 0.66 | 0 | 0.66
[NAME] 5 AY |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20000 | 0.66 | 20000 | 0.66 | 20000 | 0.66 | 20000 | 0.66
[NAME] Summer |  |  |  | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000 | 0.57 | 25000 | 0.57 | 25000 | 0.57 | 25000 | 0.57
Total Co-PI 5 fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 0.52 | 30000 | 0.52 | 30000 | 0.52 | 30000 | 0.52
Total Co-PI 5 request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35000 | 0.48 | 35000 | 0.48 | 35000 | 0.48 | 35000 | 0.48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 0.45 | 40000 | 0.45 | 40000 | 0.45 | 40000 | 0.45
Co-PI 6 salary |  | 0 | 0 | Select | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 0.42 | 45000 | 0.42 | 45000 | 0.42 | 45000 | 0.42
Summer salary |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 0.41 | 50000 | 0.41 | 50000 | 0.41 | 50000 | 0.41
Total Co-PI 6 salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55000 | 0.39 | 55000 | 0.39 | 55000 | 0.39 | 55000 | 0.39
[NAME] 6 AY |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000 | 0.38 | 60000 | 0.38 | 60000 | 0.38 | 60000 | 0.38
[NAME] summer |  |  |  | Summer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65000 | 0.36 | 65000 | 0.36 | 65000 | 0.36 | 65000 | 0.36
Total Co-PI 6 fringe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000 |  | 70000 |  | 70000 |  | 70000
Total Co-PI 6 request
Post Doctoral Employees | Name | Yearly Salary | % inc/yr |  | % effort Yr 1 | Yr 1 request |  | % effort Yr 2 | Yr 2 request |  | % effort Yr 3 | Yr 3 request |  | % effort Yr 4 | Yr 4 request |  | % effort Yr 5 | Yr 5 request |  | Total
Post-Doc 1 |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fringe
Post-Doc 2 |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fringe
Post-Doc 3 |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fringe
Post-Doc 4 |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fringe
Post-Doc 5 |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fringe
Post-Doc 6 |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Fringe
Total Post-Doc
Graduate Students | Name | Hourly rate | % inc/yr |  | Hours | Request Yr 1 |  | Hours | Request Yr 2 |  | Hours | Request Yr 3 |  | Hours | [NAME] |  | Hours | Request Yr 5 |  | Total
Grad student 1 AY |  | 0 | 0 | AY [NAME] hrs = 780 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 1 fringe |  |  |  | [NAME] hrs = 260
Grad student 1 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 1 fringe |  |  |  | [NAME] = 1%
Total Grad student 1 |  |  |  | [NAME] = 9%
Grad student 2 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 2 fringe
Grad student 2 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 2 fringe
Total Grad student 2
Grad student 3 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 3 fringe
Grad student 3 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 3 fringe
Total Grad student 3
Grad student 4 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 4 fringe
Grad student 4 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 4 fringe
Total Grad student 4
Grad student 5 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 5 fringe
Grad student 5 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 5 fringe
Total Grad student 5
Grad student 6 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 6 fringe
Grad student 6 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Grad student 6 fringe
Total Grad student 6
Total Grad student
Undergraduate Students | Name | Hourly rate | % inc/yr |  | Hours | Request Yr 1 |  | Hours | Request Yr 2 |  | Hours | Request Yr 3 |  | Hours | [NAME] |  | Hours | Request Yr 5 |  | Total
UG student 1 AY |  | 0 | 0 | AY [NAME] hrs = 780 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 1 fringe |  |  |  | [NAME] hrs = 260
UG student 1 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 1 fringe |  |  |  | [NAME] = 1%
Total UG student 1 |  |  |  | [NAME] = 9%
UG student 2 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 2 fringe
UG student 2 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 2 fringe
Total UG student 2
UG student 3 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 3 fringe
UG student 3 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 3 fringe
Total UG student 3
UG student 4 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 4 fringe
UG student 4 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 4 fringe
Total UG student 4
UG student 5 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 5 fringe
UG student 5 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 5 fringe
Total UG student 5
UG student 6 AY |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 6 fringe
UG student 6 summer |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
UG student 6 fringe
Total UG student 6
Total UG student
Irregular Help | Name | Hourly rate | % inc/yr | Part/Full time | Hours | Request Yr 1 |  | Hours | Request Yr 2 |  | Hours | Request Yr 3 |  | Hours | [NAME] |  | Hours | Request Yr 5 |  | Total
IH employee 1 |  | 0 | 0 | Full Time | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
IH employee 1 fringe |  |  |  |  | Full Fringe = 31%
Total IH employee 1 |  |  |  |  | Part Fringe = 9%
IH employee 2 |  | 0 | 0 | Full Time | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
IH employee 2 fringe
Total IH employee 2
IH employee 3 |  | 0 | 0 | Full Time | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
IH employee 3 fringe
Total IH employee 3
IH employee 4 |  | 0 | 0 | Full Time | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
IH employee 4 fringe
Total IH employee 4
IH employee 5 |  | 0 | 0 | Full Time | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
IH employee 5 fringe
Total IH employee 5
IH employee 6 |  | 0 | 0 | Full Time | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
IH employee 6 fringe
Total IH employee 6
Total IH employees